{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Visio Data Visualizer","Understand the Process Map","Process Map","Shape Notation Mapping"],"not_rendered":{"images":33,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Visio Data Visualizer","index":0,"n_rows":9,"n_cols":7,"rows_kept":9}
[]
[null,"Audit Diagram - Data Visualizer"]
[null,"Three easy steps to create process diagrams from your data."]
[]
[{"$nulls":5},1,"Add your process data\nUse this Excel template to add your process data to the sheet titled 'Process Map'."]
[]
[{"$nulls":5},2,"Import to Visio\nUse the Data Visualizer templates in Visio and import this workbook to automatically create an Audit Diagram."]
[]
[{"$nulls":5},3,"Get your diagram\nVisio creates the shapes and connectors, and it does the layout automatically for you!"]

{"sheet":"Understand the Process Map","index":1,"n_rows":25,"n_cols":8,"rows_kept":25,"merged":[[5,1,7,1],[10,1,12,1]]}
[]
[null,"Audit Diagram - Data Visualizer"]
[null,"This sheet will help you understand the meaning of the data columns in the Process Map."]
[]
[null,"Process Step ID",null,"Process Step ID","Process Step Description","Next Step ID","Connector Label","Shape Type"]
[null,"The values in this column should uniquely identify your process steps for example 1,2,3… or P100,P200,P300…\nThis is a mandatory field.",null,"P100","Authorize start of the Audit","P200",null,"Event"]
[{"$nulls":3},"P200","Prepare Audit guide","P300",null,"Tagged document"]
[{"$nulls":3},"P300","Audit guide approved?","P400, P500","No,Yes","Decision"]
[{"$nulls":3},"P400","Address feedback","P200",null,"Event"]
[null,"Process Step Description",null,"P500","Conduct Audit","P600",null,"Event"]
[null,"Add a brief description about your process steps in this column. This description is shown as shape text for process steps in Visio.",null,"P600","Prepare Audit report",null,null,"Tagged process"]
[]
[]
[]
[null,"Next Step ID"]
[null,"Add the 'Process Step ID' of the next step in this column.  \n\nNote: If any process step has multiple next steps, then these should be represented as comma separated values, for example \"2,3\" or \"P200,P300\"."]
[]
[null,"Connector Labels"]
[null,"Add the connector text for outgoing connectors of any process step in this column.\n\nNote: The labels for multiple next steps for a process should be represented as comma separated values, for example \"Yes,No\", in the same order as that of the outgoing steps."]
[]
[null,"Shape Type  "]
[null,"Add keywords for shape type in this column. This column contains a list of all available Audit flowchart shapes in Visio.  \n\nRecommended: Select a shape type value from the available values in the dropdown list."]
[]
[null,"Meta Data / Metric Data"]
[null,"The rest of the columns are metric/ metadata columns for your process steps. You can add any number of additional columns.\n"]

{"sheet":"Process Map","index":2,"n_rows":11,"n_cols":12,"rows_kept":11}
[]
[null,"Process Map: Replace the sample data with your data."]
[null,"Note: Use the given column names to quickly create a diagram in Visio or modify the column names to create custom mappings in Visio."]
[]
[null,"Process Step ID","Process Step Description","Next Step ID","Connector Label","Shape Type","Cost","Duration","Resources","Risks","Controls","Alt Description"]
[null,"P100","Authorize start of the Audit","P200",null,"Event"]
[null,"P200","Prepare Audit guide","P300",null,"Tagged document"]
[null,"P300","Audit guide approved?","P400, P500","No,Yes","Decision"]
[null,"P400","Address feedback","P200",null,"Event"]
[null,"P500","Conduct Audit","P600",null,"Event"]
[null,"P600","Prepare Audit report",null,null,"Tagged process"]

{"sheet":"Shape Notation Mapping","index":3,"n_rows":31,"n_cols":2,"rows_kept":31,"hidden":true}
["ShapeNotation","Representation"]
["Tagged process"]
["Tagged document"]
["Decision"]
["Manual operation"]
["I/O"]
["Terminator"]
["Manual file"]
["On-page reference"]
["Off-page reference"]
["Display"]
["Divided process"]
["Lined/Shaded process"]
["Multi proc/doc"]
["Multi document"]
["Lined document"]
["Disk storage"]
["Database"]
["Diskette 1"]
["Diskette 2"]
["Data transmission"]
["Magnetic tape"]
["Check 1 (audit)"]
["Check 2 (audit)"]
["Manual input"]
["Reference point"]
["Compare 1"]
["Compare 2"]
["Divided event"]
["Event"]
["Note block"]