{"text_format":"1","workbook":"xls","n_sheets":8,"sheets":["Overview","List of Documents","Issues Analyzed","Issue Details","Word Issues","Excel Issues","PowerPoint Issues","Reference Details"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":1,"defined_names":497,"comments":0,"pivot_tables":0},"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","formulas":"cached_only"}

{"sheet":"Overview","index":0,"n_rows":78,"n_cols":15,"rows_kept":78,"cut":false,"hidden":false,"merged":[[77,1,77,2],[77,7,77,9],[72,1,72,3],[72,7,72,10],[76,1,76,3],[76,7,76,10],[51,7,51,11],[52,9,52,11],[69,1,69,11],[71,1,71,4],[71,7,71,11],[27,16,27,18],[30,7,30,11],[31,8,31,11],[49,1,49,11],[11,7,11,11],[12,7,12,9],[17,7,17,9],[27,12,27,14],[8,1,8,2],[8,4,8,5],[8,7,8,9],[9,1,9,2],[9,4,9,5],[9,7,9,9],[6,1,6,3],[6,4,6,6],[6,7,6,10],[7,1,7,2],[7,4,7,5],[7,7,7,9],[1,1,1,6],[2,1,2,6],[3,1,3,6],[5,1,5,10]],"flags":["formulas_cached_only"]}
[]
[null,"Placeholder - Document Analysis Overview"]
[null,"Placeholder - Date"]
[null,"Placeholder - Version"]
[]
[null,"Number of Documents Analyzed",null,null,null,null,null,null,null,null,null,null,null,"Internal Attributes - do not modify"]
[null,"Word",null,null,"Excel",null,null,"PowerPoint",null,null,null,"Totals",null,0,"TotalDocsAnalysed"]
[null,"Documents (.doc)",null,0,"  Spreadsheets (.xls)",null,0,"  Presentations (.ppt)",null,null,0,0,null,0,"TotalIssuesAnalysed"]
[null,"Templates (.dot)",null,0,"  Templates (.xlt)",null,0,"  Templates (.pot)",null,null,0,0,null,0,"TotalRefsAnalysed"]
[null,"Total",null,0,"Total",null,0,"Total",null,null,0,0,null,0,"Word_TotalDocsAnalysedWithIssues"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Excel_TotalDocsAnalysedWithIssues"]
[null,null,null,null,null,null,null,"Document Modification Dates",null,null,null,null,null,0,"PowerPoint_TotalDocsAnalysedWithIssues"]
[null,null,null,null,null,null,null,"Last Modified",null,null,"Number","%",null,0,"LocalizeParam_LangList"]
[null,null,null,null,null,null,null,"< 3 months",null,null,0,"-",null,0,"LocalizeParam_Target"]
[null,null,null,null,null,null,null,"3 - 6 months",null,null,0,"-",null,0,"Word_MAW_ISSUECOUNT_COMPLEX"]
[null,null,null,null,null,null,null,"6 - 12 months",null,null,0,"-",null,0,"Excel_MAW_ISSUECOUNT_COMPLEX"]
[null,null,null,null,null,null,null,"> 1 year",null,null,0,"-",null,0,"PowerPoint_MAW_ISSUECOUNT_COMPLEX"]
[null,null,null,null,null,null,null,"Total",null,null,0,0,null,0,"Word_MAW_ISSUECOUNT_MINOR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Excel_MAW_ISSUECOUNT_MINOR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,"PowerPoint_MAW_ISSUECOUNT_MINOR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,"OV_DAW_SETUP_SHEETS_RUN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,"OV_PAW_SETUP_SHEETS_RUN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"smoketest_source_directory"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Documents with Macro Migration Issues"]
[null,null,null,null,null,null,null,"Type","Number of docs"]
[null,null,null,null,null,null,null,null,"Complex","Medium","Simple","None"]
[null,null,null,null,null,null,null,"Word",0,0,0,0]
[null,null,null,null,null,null,null,"Excel",0,0,0,0]
[null,null,null,null,null,null,null,"PowerPoint",0,0,0,0]
[null,null,null,null,null,null,null,"Total",0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Placeholder - High level analysis of document migration issues"]
[]
[null,null,null,null,null,null,null,"Documents with Document Migration Issues (excludes macro issues)"]
[null,null,null,null,null,null,null,"Type",null,"Number of docs"]
[null,null,null,null,null,null,null,null,null,"Complex","Minor","None"]
[null,null,null,null,null,null,null,"Word",null,0,0,0]
[null,null,null,null,null,null,null,"Excel",null,0,0,0]
[null,null,null,null,null,null,null,"PowerPoint",null,0,0,0]
[null,null,null,null,null,null,null,"Total",null,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cost estimates for migration of all analyzed documents"]
[]
[null,"Document Migration Costs \n( costs based on: issues listed in Issues Analyzed, excludes macros  issues )",null,null,null,null,null,"Manual Macro Migration Costs \n( costs based on: number of lines in unique code modules and number of user form controls )"]
[null,"Type",null,null,"Costs (MD)",null,null,"Type",null,null,null,"Costs (MD)"]
[null,"Word ",null,0,0,null,null,"Word ",null,null,0,0]
[null,"Excel ",null,0,0,null,null,"Excel ",null,null,0,0]
[null,"PowerPoint ",null,0,0,null,null,"PowerPoint ",null,null,0,0]
[null,"Total",null,null,0,null,null,"Total",null,null,null,0]
[null,"Potential Savings with Automated Preparation",null,null,0,null,null,"Potential Savings with Automated Macro Migration of 20 to 60%",null,null,0.4,0]

{"sheet":"List of Documents","index":1,"n_rows":3,"n_cols":21,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,12,1,13],[1,2,1,5],[1,6,1,8],[1,9,1,11]],"flags":["formulas_cached_only"]}
["All Analyzed Documents"]
[null,null,"Document Migration Issues",null,null,null,"Macro Migration Issues",null,null,"Costs",null,null,"Document Details"]
["Document Name","Application","Document Migration Issues","Issues Complex Count","Issues Minor Count","Prepareable Document Issues","Macro Migration Issues","User Form Count","Lines of Macro Code","Document Migration Costs (min)","Prepareable Issues Savings (min)","Macro Migration Costs (min)","Pages, Sheets or  Slides Count","Created","Last Modified","Accessed","Printed","Last Saved By","Revision","Based on Template","Document Name and Path"]

{"sheet":"Issues Analyzed","index":2,"n_rows":124,"n_cols":16,"rows_kept":124,"cut":false,"hidden":false,"merged":[[123,3,123,4],[0,0,0,1],[0,4,0,5],[39,3,39,4],[87,3,87,4]],"flags":["formulas_cached_only"]}
["Migration Issues Analyzed",null,"Total Cost  (MD) = ",0,"Hours Per MD =",null,7]
["Application","Issue Category","Issue Type","Additional Weighting Factors","Cost per Issue or Factor (min)","Complex Issue"," Issue Count","Prepared Issue Count","Prepared Savings (min)","Factor Count","Costs (min)",null,"Status","Comment","Work Around","Cost Comment"]
["Word","Changes And Reviewing"]
["Word"]
["Word","Content And Document Properties","Document Parts Protection",null,0,"False",0,null,null,null,0,null,"Not Planned","Issue: Password protection of comments, tracked changes and forms is lost.",null,"Cost = 0. No work around."]
["Word",null,"Invalid Password Entered",null,0,"False",0,null,null,null,0,null,"User Error","Issue: Incorrect password entered. ","Rerun analysis with correct password.","Cost = 0. Rerun analysis with correct password."]
["Word",null,"Mail Merge Datasource",null,10,"True",0,null,null,null,0,null,"Not Planned","Issue: Information relating to the data source is lost in migration.","Setup Datasource in SO7 using Tools/ Datasource"]
["Word",null,"Password Protection",null,1,"False",0,null,null,null,0,null,"Not Planned","Issue: Document is password protected and cannot be opened by SO.","Remove password to open."]
["Word",null,"RID_RESXLS_COST_LineStyle",null,0,"False",0,null,null,null,0,null,"Planned SO8","RID_RESXLS_COST_LineStyle_Comment"]
["Word",null,"RID_RESXLS_COST_Transparent",null,0,"False",0,null,null,null,0,null,"Planned SO8","RID_RESXLS_COST_Transparent_Comment"]
["Word",null,"RID_RESXLS_COST_GradientStyle",null,0,"False",0,null,null,null,0,null,"Planned SO8","RID_RESXLS_COST_GradientStyle_Comment"]
["Word","Controls"]
["Word"]
["Word","Fields","Appearance",null,0,"False",0,null,null,null,0,null,"Not Planned","Issue: Shading can be applied to fields and to controls separately in Word. StarOffice does not differentiate between controls and fields so shading can look different in Writer.",null,"Cost = 0. No work around."]
["Word",null,"Form Field",null,5,"True",0,null,null,null,0,null,"Planned SO8","Issue: Text form fields roundtrip as Fill In field. Field attributes are lost."]
["Word",null,"Mail Merge Field",null,0,"True",0,null,null,null,0,null,"Not Planned","Issue: Fields are imported but need to have the link to datasource reset.","Reset link to Data Base having setup a Datasource in SO7.","Cost = 0 Data pilot will fix all of the fields."]
["Word",null,"Table Of Authorities Field",null,0,"False",0,null,null,null,0,null,"Not Planned","Issue: Lost during migration. No StarOffice equivalent.",null,"Cost = 0. No work around."]
["Word"]
["Word","Format","Custom Bullet List"]
["Word"]
["Word","Indexes And References","Table Of Authorities",null,0,"False",0,null,null,null,0,null,"Not Planned","Issue: Table imported as text as no StarOffice equivalent.",null,"Cost = 0. No work around."]
["Word"]
["Word","Portability","External References In Macro - Module, Class or UserForm","Number of Modules",0,"True",0,null,null,null,0,null,"Not Planned","Issue: External references are windows specific."]
["Word",null,null,"Number Of External References",0,null,null,null,null,0,0,null,"Not Planned","Issue: Calls to windows API functions are windows specific.",null,"Cost = 0. Set a cost factor if the macro has to be ported off Windows. "]
["Word",null,"Embedded OLE Object",null,0,"True",0,null,null,null,0,null,"Planned SO8","Issue: Presents a cross platform interoperability issue."]
["Word",null,"Linked OLE Object",null,10,"True",0,null,null,null,0,null,"Not Planned","Issue: Presents a cross platform interoperability issue.",null,"Cost = 0. Most embedded objects come across. If one does not then this may require some reenginering and is not in the scope of an automated cost calculation."]
["Word",null,"OLE Control",null,5,"True",0,null,null,null,0,null,"Planned SO8","Issue: Most migrate ok but do not roundtrip.",null,"Cost variations occur because of the use of macros with controls."]
["Word"]
["Word","Tables","Border Styles",null,1,"False",0,null,null,null,0,null,"Planned SO8","Issue: 18 of the 24 table border styles do not display correctly."]
["Word",null,"Nested Tables",null,5,"False",0,null,null,null,0,null,"Planned SO8","Issue: Tables nested in tables are not supported by SO7.","In word use split cell to create similar layout."]
["Word"]
["Word","VBA Macros","Password Protected",null,null,"False",0,null,null,null,0,null,"User Error","Issue: VBProject is password protected. Remove password, rerun analysis."]
["Word",null,"Properties - Module, Class or UserForm","Number of Modules",0,"True",0,null,null,null,0,null,"Not Planned","Issue: Modules will need porting to StarOffice Basic.",null,"Cost = 0 using lines of code as better cost estimate."]
["Word",null,null,"Number Of Lines",0,"True",null,null,null,0,0,null,"Not Planned","Issue: Modules will need porting to StarOffice Basic.",null,"Cost of 4 min per line, takes no account of complexity of code, number of comment lines and so on"]
["Word",null,null,"Number of Unique Code Modules",0,"True",null,null,null,0,0,null,"Not Planned","Issue: Modules will need porting to StarOffice Basic."]
["Word",null,null,"Number of Lines in Unique Code Modules",4,"True",null,null,null,0,0,null,"Not Planned","Issue: Modules will need porting to StarOffice Basic."]
["Word",null,null,"User Forms Count",0,"True",null,null,null,0,0,null,"Not Planned","Issue: Userforms will need porting to StarOffice Basic.",null,"Cost = 0. Using total number of controls on forms as better estimate"]
["Word",null,null,"User Forms Control Count",3,"True",null,null,null,0,0,null,"Not Planned","Issue: Userform controls will need porting to StarOffice Basic.",null,"Cost = 3 minute per control, this does not take account of issues with Frame controls or the number of these controls that have event handlers that need manually linked to migrated code."]
["Word",null,null,"User Forms Control Type Count",0,"True",null,null,null,0,0,null,"Not Planned","Issue: Userform controls will need porting to StarOffice Basic.",null,"Cost = 0. Total number of controls better estimate - this information is useful as an indication of complexity of the Forms."]
["Word",null,null,"Word Totals",null,null,0,0,0,null,0]
["Excel","Changes And Reviewing"]
["Excel"]
["Excel","Charts And Tables","Pivot Chart",null,0,"True",0,null,null,null,0,null,"Not Planned","Issue: Pivot charts are not supported by SO7.",null,"Cost = 0. Calc does not support dynamically created charts. No workaround."]
["Excel",null,"Chart Issues Complex",null,15,"False",0,null,null,null,0,null,"Planned SO8","Issue: Chart support is limited in SO7.",null,"Variations in cost can range from 0 - 30 mins. Cost caused by uneven datasouce, external datasource, unsupported chart types, floating legend position."]
["Excel",null,"Chart Issues Minor",null,1,"False",0,null,null,null,0,null,"Planned SO8","Issue: Chart support is limited in SO7.",null,"Variations in cost can range from 0 - 30 mins. Cost caused by uneven datasouce, external datasource, unsupported chart types, floating legend position."]
["Excel",null,"RID_RESXLS_COST_DB_Query",null,0,"True",0,null,null,null,0,null,"Planned SO8","RID_RESXLS_COST_DB_Query_Comment"]
["Excel"]
["Excel","Content And Document Properties","Document Parts Protection",null,0,"False",0,null,null,null,0,null,"User Error","Issue: Password protection of comments, tracked changes and forms is lost.",null,"Cost = 0. Rerun analysis with correct password."]
["Excel",null,"Invalid Password Entered",null,0,"False",0,null,null,null,0,null,"User Error","Issue: Invalid password entered. Rerun analysis.",null,"Cost = 0. Rerun analysis with correct password."]
["Excel",null,"Invalid Worksheet Name",null,1,"False",0,null,null,null,0,null,"Not Planned","Issue: A worksheet in the workbook has a name with invalid characters.","Remove the invalid characters from the worksheet name.","Cost: When the worksheet has been renamed, ensure that all macros with a reference to the worksheet are also renamed accordingly.Cost depends on how many lines of code there are that refer to the worksheet name."]
["Excel",null,"Maximum Sheets Exceeded",null,10,"True",0,null,null,null,0,null,"Not Planned","Issue: 256 sheet limit exceeded.","Need to move sheets to new workbook. ","All sheets >256 will need to be moved to a new workbook"]
["Excel",null,"Old Workbook Version",null,1,"False",0,0,0,null,0,null,"Not Planned","Issue: Macros from old workbook versions do not import into SO7.","Save workbook as a new workbook version."]
["Excel",null,"WorkbookProtection ",null,1,"False",0,null,null,null,0,null,"Not Planned","Issue: Workbook protection is not supported","Remove protection before importing"]
["Excel",null,"Password Protection",null,1,"False",0,null,null,null,0,null,"Not Planned","Issue: Document is password protected and cannot be opened by SO."]
["Excel",null,"RID_RESXLS_COST_LineStyle",null,0,"False",0,null,null,null,0,null,"Planned SO8","RID_RESXLS_COST_LineStyle_Comment"]
["Excel",null,"RID_RESXLS_COST_Transparent",null,0,"False",0,null,null,null,0,null,"Planned SO8","RID_RESXLS_COST_Transparent_Comment"]
["Excel",null,"RID_RESXLS_COST_GradientStyle",null,0,"False",0,null,null,null,0,null,"Planned SO8","RID_RESXLS_COST_GradientStyle_Comment"]
["Excel","Controls"]
["Excel"]
["Excel","Filters",null,null,null,null,null,0,0]
["Excel"]
["Excel","Format","Cell Attributes",null,5,"False",0,null,null,null,0,null,"Planned SO8","Issue: Unsupported formatting set."]
["Excel",null,"Zoom",null,1,"False",null,null,null,null,0,null,"Not Planned"]
["Excel"]
["Excel","Functions","ERROR.TYPE",null,3,"True",0,null,null,null,0,null,"Not Planned","Issue: Unsupported function type. ",null,"Fix up cost can vary depending on the context in which this is used. Cost 3 - 5"]
["Excel",null,"External",null,5,"False",0,null,null,null,0,null,"Not Planned","Issue: External functions not supported by SO7"]
["Excel",null,"INFO",null,3,"True",0,null,null,null,0,null,"Not Planned","Issue: Unsupported function type. ",null,"Fix up cost can vary depending on the context in which this is used. Cost 2 - 4"]
["Excel",null,"GETPIVOTDATA",null,3,"True",0,null,null,null,0,null,"Not Planned","Issue: Unsupported function type. ",null,"Fix up cost can vary depending on the context in which this is used. Cost 2 - 4"]
["Excel",null,"DATEDIF",null,3,"True",0,null,null,null,0,null,"Not Planned","Issue: Unsupported function type. ","RID_RESXLS_COST_DATEDIF_Note","Fix up cost can vary depending on the context in which this is used. Cost 2 - 4"]
["Excel",null,"PHONETIC",null,3,"True",0,null,null,null,0,null,"Not Planned","Issue: Unsupported function type. ",null,"Fix up cost can vary depending on the context in which this is used. Cost 2 - 4"]
["Excel",null,null,null,null,null,null,null,null,null,null,null," "]
["Excel","Objects And Graphics"]
["Excel"]
["Excel","Portability","External References In Macro - Module, Class or UserForm","Number of Modules",0,"True",0,null,null,null,0,null,"Not Planned","Issue: External references are windows specific."]
["Excel",null,null,"Number Of External References",0,null,null,null,null,0,0,null,"Not Planned","Issue: Calls to windows API functions are windows specific.",null,"Cost = 0. Set a cost factor if the macro has to be ported off Windows. "]
["Excel",null,"Embedded OLE Object",null,0,"True",0,null,null,null,0,null,"Planned SO8","Issue: Presents a cross platform interoperability issue.",null,"Cost = 0. Most embedded objects come across. If one does not then this may require some reenginering and is not in the scope of an automated cost calculation."]
["Excel",null,"Linked OLE Object",null,10,"True",0,null,null,null,0,null,"Not Planned","Issue: Presents a cross platform interoperability issue."]
["Excel",null,"OLE Control",null,5,"True",0,null,null,null,0,null,"Planned SO8","Issue: Most migrate ok but do not roundtrip.",null,"Cost variations occur because of the use of macros with controls."]
["Excel"]
["Excel","VBA Macros","Password Protected",null,null,"False",0,null,null,null,0,null,"User Error","Issue: VBProject is password protected. Remove password, rerun analysis."]
["Excel",null,"Properties - Module, Class or UserForm","Number of Modules",0,"True",0,null,null,null,0,null,"Not Planned","Issue: Modules will need porting to StarOffice Basic.",null,"Cost = 0 using lines of code as better cost estimate."]
["Excel",null,null,"Number Of Lines",0,"True",null,null,null,0,0,null,"Not Planned","Issue: Modules will need porting to StarOffice Basic.",null,"Cost of 4 min per line, takes no account of complexity of code, number of comment lines and so on"]
["Excel",null,null,"Number of Unique Code Modules",0,"True",null,null,null,0,0,null,"Not Planned","Issue: Modules will need porting to StarOffice Basic."]
["Excel",null,null,"Number of Lines in Unique Code Modules",4,"True",null,null,null,0,0,null,"Not Planned","Issue: Modules will need porting to StarOffice Basic."]
["Excel",null,null,"User Forms Count",0,"True",null,null,null,0,0,null,"Not Planned","Issue: Userforms will need porting to StarOffice Basic.",null,"Cost = 0. Using total number of controls on forms as better estimate"]
["Excel",null,null,"User Forms Control Count",3,"True",null,null,null,0,0,null,"Not Planned","Issue: Userform controls will need porting to StarOffice Basic.",null,"Cost = 3 minute per control, this does not take account of issues with Frame controls or the number of these controls that have event handlers that need manually linked to migrated code."]
["Excel",null,null,"User Forms Control Type Count",0,"True",null,null,null,0,0,null,"Not Planned","Issue: Userform controls will need porting to StarOffice Basic.",null,"Cost = 0. Total number of controls better estimate - this information is useful as an indication of complexity of the Forms."]
["Excel",null,null,"Excel Totals",null,null,0,0,0,null,0]
["PowerPoint","Action Settings"]
["PowerPoint"]
["PowerPoint","Content And Document Properties","Comment",null,0,"False",0,null,null,null,0,null,"Planned SO8","Issue: Comments are lost on migration to SO7.",null,"Cost = 0. No work around."]
["PowerPoint",null,"RID_RESXLS_COST_LineStyle",null,0,"False",0,null,null,null,0,null,"Planned SO8","RID_RESXLS_COST_LineStyle_Comment"]
["PowerPoint",null,"RID_RESXLS_COST_Numbering",null,0,"False",0,null,null,null,0,null,"Planned SO8","RID_RESXLS_COST_Numbering_Comment"]
["PowerPoint",null,"RID_RESXLS_COST_Template",null,0,"False",0,null,null,null,0,null,"Planned SO8","RID_RESXLS_COST_Template_Comment"]
["PowerPoint",null,"RID_RESXLS_COST_Tabstop",null,0,"False",0,null,null,null,0,null,"Planned SO8","RID_RESXLS_COST_Tabstop_Comment"]
["PowerPoint",null,"RID_RESXLS_COST_Transparent",null,0,"False",0,null,null,null,0,null,"Planned SO8","RID_RESXLS_COST_Transparent_Comment"]
["PowerPoint",null,"RID_RESXLS_COST_GradientStyle",null,0,"False",0,null,null,null,0,null,"Planned SO8","RID_RESXLS_COST_GradientStyle_Comment","RID_RESXLS_COST_GradientStyle_Note"]
["PowerPoint",null,"RID_RESXLS_COST_Hyperlink",null,0,"False",0,null,null,null,0,null,"Planned SO8","RID_RESXLS_COST_Hyperlink_Comment"]
["PowerPoint",null,"RID_RESXLS_COST_HyperlinkSplit",null,0,"False",0,null,null,null,0,null,"Planned SO8","RID_RESXLS_COST_HyperlinkSplit_Comment"]
["PowerPoint",null,"RID_RESXLS_COST_Background",null,0,"False",0,null,null,null,0,null,"Planned SO8","RID_RESXLS_COST_Background_Comment"]
["PowerPoint"]
["PowerPoint","Fields"]
["PowerPoint"]
["PowerPoint","Format"]
["PowerPoint"]
["PowerPoint","Notes And Handouts"]
["PowerPoint"]
["PowerPoint","Objects Graphics And Textboxes","Movie",null,0,"True",0,null,null,null,0,null,"Planned SO8","Issue: Movies are not supported by SO7."]
["PowerPoint"]
["PowerPoint","Portability","External References In Macro - Module, Class or UserForm","Number of Modules",0,"True",0,null,null,null,0,null,"Not Planned","Issue: External references are windows specific."]
["PowerPoint",null,null,"Number Of External References",0,null,null,null,null,0,0,null,"Not Planned","Issue: Calls to windows API functions are windows specific.",null,"Cost = 0. Set a cost factor if the macro has to be ported off Windows. "]
["PowerPoint",null,"Embedded OLE Object",null,0,"True",0,null,null,null,0,null,"Planned SO8","Issue: Presents a cross platform interoperability issue.",null,"Cost = 0. Most embedded objects come across. If one does not then this may require some reenginering and is not in the scope of an automated cost calculation."]
["PowerPoint",null,"Linked OLE Object",null,10,"True",0,null,null,null,0,null,"Not Planned","Issue: Presents a cross platform interoperability issue."]
["PowerPoint",null,"OLE Control",null,5,"True",0,null,null,null,0,null,"Planned SO8","Issue: Most migrate ok but do not roundtrip.",null,"Cost variations occur because of the use of macros with controls."]
["PowerPoint"]
["PowerPoint","VBA Macros","Password Protected",null,null,"False",0,null,null,null,0,null,"User Error","Issue: VBProject is password protected. Remove password, rerun analysis."]
["PowerPoint",null,"Properties - Module, Class or UserForm","Number of Modules",0,"True",0,null,null,null,0,null,"Not Planned","Issue: Modules will need porting to StarOffice Basic.",null,"Cost = 0 using lines of code as better cost estimate."]
["PowerPoint",null,null,"Number Of Lines",0,"True",null,null,null,0,0,null,"Not Planned","Issue: Modules will need porting to StarOffice Basic.",null,"Cost of 4 min per line, takes no account of complexity of code, number of comment lines and so on"]
["PowerPoint",null,null,"Number of Unique Code Modules",0,"True",null,null,null,0,0,null,"Not Planned","Issue: Modules will need porting to StarOffice Basic."]
["PowerPoint",null,null,"Number of Lines in Unique Code Modules",4,"True",null,null,null,0,0,null,"Not Planned","Issue: Modules will need porting to StarOffice Basic."]
["PowerPoint",null,null,"User Forms Count",0,"True",null,null,null,0,0,null,"Not Planned","Issue: Userforms will need porting to StarOffice Basic.",null,"Cost = 0. Using total number of controls on forms as better estimate"]
["PowerPoint",null,null,"User Forms Control Count",3,"True",null,null,null,0,0,null,"Not Planned","Issue: Userform controls will need porting to StarOffice Basic.",null,"Cost = 3 minute per control, this does not take account of issues with Frame controls or the number of these controls that have event handlers that need manually linked to migrated code."]
["PowerPoint",null,null,"User Forms Control Type Count",0,"True",null,null,null,0,0,null,"Not Planned","Issue: Userform controls will need porting to StarOffice Basic.",null,"Cost = 0. Total number of controls better estimate - this information is useful as an indication of complexity of the Forms."]
["PowerPoint",null,null,"PowerPoint Totals",null,null,0,0,0,null,0]

{"sheet":"Issue Details","index":3,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,4]],"flags":["formulas_cached_only"]}
["All Documents with Issues - Issue Details"]
["Document Name","Application","Issue Category","Issue Type","Location Type","Location","Line/ Row/ Top","Column/ Left","Issue Details","Document Name and Path"]

{"sheet":"Word Issues","index":4,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,11]],"flags":["formulas_cached_only"]}
["Word Documents with Issues - Issue Summary"]
["Word Document Name","Application","Changes and Reviewing","Content & Document Properties","Controls","Fields","Format","Index and References","Objects, Graphics  & Frames","Portability","Tables","VBA Macros","Writing Aids","Document Name and Path"]

{"sheet":"Excel Issues","index":5,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,11]],"flags":["formulas_cached_only"]}
["Excel Documents with Issues - Issue Summary"]
["Excel Spreadsheet Name","Application","Changes & Reviewing","Charts & Tables","Content & Document Properties","Controls","Filters","Format","Functions","Objects & Graphics","Portability","VBA Macros","Document Name and Path"]

{"sheet":"PowerPoint Issues","index":6,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,9]],"flags":["formulas_cached_only"]}
["PowerPoint Documents with Issues - Issue Summary"]
["PowerPoint Presentation Name","Application","Action Settings","Content & Document Properties","Fields","Format","Notes & Handouts","Objects, Graphics & Textboxes","Portability","VBA Macros","Document Name and Path"]

{"sheet":"Reference Details","index":7,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,5]],"flags":["formulas_cached_only"]}
["All Documents with Macros - Reference Details"]
["Document Name","Application","Reference","Description","Location","Reference Details","Document Name and Path"]