{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["Overview",".addinPivotBarData","VBA Overview","VBA Summary",".cache","VBA Results","VBA Remediation","VBA References","Add-in Summary","Add-in Details","By computer name","Device Upgrade Readiness(32bit)","Device Upgrade Readiness(64bit)",".addinDataSheet",".vbaPivotData","styles",".vbaAggregation",".vbaDeptDropDownData",".addinDeptDropDownData",".reportDebugInfo",".addinAggregation",".addinByComputerName",".addinStatuses",".toolHealth"],"not_rendered":{"charts":6,"images":5,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":8},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":".addinPivotBarData","index":1,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["AdvancedReport","AdoptedSupported","Other","Total","Used","NotUsed"]
["False"]

{"sheet":"VBA Overview","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"VBA Summary","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":".cache","index":4,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Parameter","Value",null,"OfficeApp","Value",null,"ReadinessFailure",null,null,"Row Labels","Count of Total Installs",null,"32-bit",null,"No",null,"Office 2003 or earlier"]
["Include 64 bit","No",null,"Access",true,null,false,null,null,"(blank)",null,null,"64-bit",null,"Yes",null,"Office 2007"]
["Add-in Bitness","X86",null,"Excel",true,null,null,null,null,"Grand Total",null,null,null,null,null,null,"Office 2010"]
["Office Add-ins",false,null,"Outlook",true,null,null,null,null,null,null,null,null,null,null,null,"Office 2013"]
["Add-ins Usage",false,null,"PowerPoint",true,null,null,null,null,null,null,null,null,null,null,null,"Office 2016"]
["Usage Data Collection Start Date",null,null,"Project",true]
["Office Version","Office 2003",null,"Publisher",true]
[null,null,null,"Visio",true]
[null,null,null,"Word",true]

{"sheet":"VBA Results","index":5,"n_rows":3,"n_cols":23,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Guideline","Severity","Source File Hash","Source File Extension","Module","Line #","Type","Member","Statement","VBA Hash","Reference","FileStatus","64Bit","UserHash","DeviceName","Remarks","Label1","Label2","Label3","Label4","Source file reference","RT Version","Applies to"]
["Online files not supported","Inaccessible","",".xlsb","","","","","","","","Cloud-based","False","barendsea","T112A-LPF2GEE5B","","","","","","B02946572ACA2CD46664535F553ED900BB9DBC195226BB1E29A6673538E473FC","1.2.22161.1",""]
["Online files not supported","Inaccessible","",".xlsm","","","","","","","","Cloud-based","False","barendsea","T112A-LPF2GEE5B","","","","","","0DB4E7D25262C57E2ABB29076946E8CB0B9243C03797B6407D98700B6FF5465E","1.2.22161.1",""]

{"sheet":"VBA Remediation","index":6,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["The following guidance aims to help with the remediation of issues we've identified within your VBA code. It is not an exhaustive list and other issues may be present but not listed below. It is highly recommended to test and validate the proposed changes work as expected."]
["Category","Source Location","Source File","Source File Hash","Source File Extension","Module","Line #","Original Code","Proposed Changes","UserHash","DeviceName","Source file reference"]

{"sheet":"VBA References","index":7,"n_rows":1,"n_cols":17,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Guideline","Severity","Source Location","Source File","Source File Hash","Source File Extension","Module","Line #","Type","Member","Statement","VBA Hash","Reference","FileStatus","UserHash","DeviceName","Source file reference"]

{"sheet":"Add-in Summary","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Add-in Details","index":9,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Built In","(All)"]
["Label1","(All)"]
["Label2","(All)"]
["Label3","(All)"]
["Label4","(All)"]
["Add-in used","(All)"]
[]
["Add-in Name","Add-in Publisher","Add-in Version","App","Readiness status (32-bit)","Readiness status (64-bit)","Remarks","More information","Total Installs","Total device installs","Total devices add-in used"]
["(blank)","(blank)","(blank)","(blank)","(blank)","(blank)","(blank)","(blank)"]

{"sheet":"By computer name","index":10,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Machine Name","Add-in Name","Add-in Publisher","Add-in Version","App","Readiness status (32-bit)","Readiness status (64-bit)","Add-in used","Add-in used since","Remarks","More information","Built In","UsageCollectionEnabledDate","Label1","Label2","Label3","Label4"]
["T112A-LPF2GEE5B","Rbnz Documentum Office Connectors","Reserve Bank of New Zealand","2.1.0.0","Excel","Unknown","Unknown","Unknown","Unknown","",null,"False",""]
["T112A-LPF2GEE5B","Microsoft Power Map for Excel","Microsoft Corporation","16.0.4266.1001","Excel","Supported version available","Supported version available","Unknown","Unknown","",null,"True",""]
["T112A-LPF2GEE5B","Inquire","Microsoft Corporation","16.0.4266.1001","Excel","Supported version available","Supported version available","Unknown","Unknown","",null,"True",""]
["T112A-LPF2GEE5B","Microsoft Power View for Excel","Microsoft Corporation","2011.110.9166.183","Excel","Supported version available","Supported version available","Unknown","Unknown","",null,"True",""]
["T112A-LPF2GEE5B","Microsoft Power Pivot for Excel","Microsoft Corporation","2011.110.9165.1186","Excel","Supported version available","Supported version available","Unknown","Unknown","",null,"True",""]
["T112A-LPF2GEE5B","Rbnz Documentum Office Connectors","Reserve Bank of New Zealand","2.1.0.0","Word","Unknown","Unknown","Unknown","Unknown","",null,"False",""]
["T112A-LPF2GEE5B","Rbnz Documentum Office Connectors","Reserve Bank of New Zealand","2.1.0.0","PowerPoint","Unknown","Unknown","Unknown","Unknown","",null,"False",""]
["T112A-LPF2GEE5B","Liverton MailAdviser Desktop Client (x86/64)","Liverton Technology Group","1.3.2.0","Outlook","Adopted version available","Adopted version available","Unknown","Unknown","",null,"False",""]
["T112A-LPF2GEE5B","Phish Alert","KnowBe4 Inc.","1.10.0.200","Outlook","Unknown","Unknown","Unknown","Unknown","",null,"False",""]
["T112A-LPF2GEE5B","Microsoft VBA for Outlook Addin","Microsoft Corporation","16.0.5197.1000","Outlook","Supported version available","Supported version available","Unknown","Unknown","",null,"True",""]
["T112A-LPF2GEE5B","Rbnz Documentum Office Connectors","Reserve Bank of New Zealand","2.1.0.0","Outlook","Unknown","Unknown","Unknown","Unknown","",null,"False",""]
["T112A-LPF2GEE5B","Microsoft Exchange Add-in","","16.0.4888.1000","Outlook","Supported version available","Supported version available","Unknown","Unknown","",null,"True",""]
["T112A-LPF2GEE5B","Microsoft Teams Meeting Add-in for Microsoft Office","Microsoft Corporation","1.0.0.1","Outlook","Supported version available","Supported version available","Unknown","Unknown","",null,"False",""]

{"sheet":"Device Upgrade Readiness(32bit)","index":11,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Machine Name","Ready to Upgrade?","Macro Files","Macro Files with Issues","Installed Add-ins","Add-ins to assess"]

{"sheet":"Device Upgrade Readiness(64bit)","index":12,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Machine Name","Ready to Upgrade?","Macro Files","Macro Files with Issues","Installed Add-ins","Add-ins to assess"]

{"sheet":".addinDataSheet","index":13,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Machine Name","Addin Name","Addin Publisher","Addin Version","App","X86Readiness","X64Readiness","Bitness","QueryId","ProgId","ClsId","PublisherType","BuiltIn","IsSupported","AddinUsed","ReadinessMissing"]

{"sheet":".vbaPivotData","index":14,"n_rows":3,"n_cols":36,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Guideline","Severity","Source Location","Source File","Source File Hash","Source File Extension","Module","Line #","Type","Member","Statement","VBA Hash","Reference","FileStatus","64Bit","UserHash","DeviceName","MaxSevX86","MaxSevX64","SeverityX86","SeverityX64","Mx86-VbaH","Mx64-VbaH","Mx86-SFH","Mx64-SFH","SF-UH(X86)","SF-UH(X64)","VbaH,SL,SF-UH(X86)","VbaH,SL,SF-UH(X64)","VbaH,SL,SF-SFH(X86)","VbaH,SL,SF-SFH(X64)","Label1","Label2","Label3","Label4","Applies to"]
["Online files not supported","Inaccessible","https://rbnzgovt-my.sharepoint.com/personal/sean_boss_rbnz_govt_nz/documents/microsoft teams chat files","20220506104049 - box current files.xlsb","",".xlsb","","","","","","","","Cloud-based","False","barendsea","T112A-LPF2GEE5B","Inaccessible","Inaccessible","Inaccessible","Inaccessible",1,1,1,1,1,1,1,1,1,1,null,null,null,null,""]
["Online files not supported","Inaccessible","https://rbnzgovt.sharepoint.com/sites/documentumreplacementproject/shared documents/go live","timeline documentum go live.xlsm","",".xlsm","","","","","","","","Cloud-based","False","barendsea","T112A-LPF2GEE5B","Inaccessible","Inaccessible","Inaccessible","Inaccessible",0,0,1,1,1,1,1,1,1,1,null,null,null,null,""]

{"sheet":"styles","index":15,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["SeverityStyle"]
["Ready to upgrade"]
["Code design awareness"]
["Minimal validation recommended"]
["Limited remediation required"]
["Significant remediation required"]
["Unknown"]

{"sheet":".vbaAggregation","index":16,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["FileStatus","Count","Label1","Label2","Label3","Label4"]
["No VBA",156,"(All)","(All)","(All)","(All)"]
["Cloud-based",2,"(All)","(All)","(All)","(All)"]

{"sheet":".vbaDeptDropDownData","index":17,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Label1","Label2","Label3","Label4"]

{"sheet":".addinDeptDropDownData","index":18,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Label1","Label2","Label3","Label4"]

{"sheet":".reportDebugInfo","index":19,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["ToolVersion","ReportGuid","CorrelationId"]
["1.2.22161.1","4e730787-aafe-422f-b351-51db3a69aa04","32234c40-ca11-417a-96a0-05ec5b9b39d7"]

{"sheet":".addinAggregation","index":20,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":".addinByComputerName","index":21,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Machine Name","Add-in Name","Add-in Publisher","Add-in Version","App","Readiness status (32-bit)","Readiness status (64-bit)","Add-in used","Add-in used since","Remarks","More information","Built In","UsageCollectionEnabledDate","Label1","Label2","Label3","Label4"]
["T112A-LPF2GEE5B","Rbnz Documentum Office Connectors","Reserve Bank of New Zealand","2.1.0.0","Excel","Unknown","Unknown","Unknown","Unknown","",null,"False",""]
["T112A-LPF2GEE5B","Microsoft Power Map for Excel","Microsoft Corporation","16.0.4266.1001","Excel","Supported version available","Supported version available","Unknown","Unknown","",null,"True",""]
["T112A-LPF2GEE5B","Inquire","Microsoft Corporation","16.0.4266.1001","Excel","Supported version available","Supported version available","Unknown","Unknown","",null,"True",""]
["T112A-LPF2GEE5B","Microsoft Power View for Excel","Microsoft Corporation","2011.110.9166.183","Excel","Supported version available","Supported version available","Unknown","Unknown","",null,"True",""]
["T112A-LPF2GEE5B","Microsoft Power Pivot for Excel","Microsoft Corporation","2011.110.9165.1186","Excel","Supported version available","Supported version available","Unknown","Unknown","",null,"True",""]
["T112A-LPF2GEE5B","Rbnz Documentum Office Connectors","Reserve Bank of New Zealand","2.1.0.0","Word","Unknown","Unknown","Unknown","Unknown","",null,"False",""]
["T112A-LPF2GEE5B","Rbnz Documentum Office Connectors","Reserve Bank of New Zealand","2.1.0.0","PowerPoint","Unknown","Unknown","Unknown","Unknown","",null,"False",""]
["T112A-LPF2GEE5B","Liverton MailAdviser Desktop Client (x86/64)","Liverton Technology Group","1.3.2.0","Outlook","Adopted version available","Adopted version available","Unknown","Unknown","",null,"False",""]
["T112A-LPF2GEE5B","Phish Alert","KnowBe4 Inc.","1.10.0.200","Outlook","Unknown","Unknown","Unknown","Unknown","",null,"False",""]
["T112A-LPF2GEE5B","Microsoft VBA for Outlook Addin","Microsoft Corporation","16.0.5197.1000","Outlook","Supported version available","Supported version available","Unknown","Unknown","",null,"True",""]
["T112A-LPF2GEE5B","Rbnz Documentum Office Connectors","Reserve Bank of New Zealand","2.1.0.0","Outlook","Unknown","Unknown","Unknown","Unknown","",null,"False",""]
["T112A-LPF2GEE5B","Microsoft Exchange Add-in","","16.0.4888.1000","Outlook","Supported version available","Supported version available","Unknown","Unknown","",null,"True",""]
["T112A-LPF2GEE5B","Microsoft Teams Meeting Add-in for Microsoft Office","Microsoft Corporation","1.0.0.1","Outlook","Supported version available","Supported version available","Unknown","Unknown","",null,"False",""]

{"sheet":".addinStatuses","index":22,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Unknown"]
["Supported version available"]
["Adopted version available"]

{"sheet":".toolHealth","index":23,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[""]