{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["sheet1","Version changes - Styles","Version changes - Settings","Developement Notes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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"}

{"sheet":"sheet1","index":0,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Change all the names in Origin location to include a suffix for instance _OLD"]
[]
["Suffix","_OLD"]
[]
[]
[]
[]
["Pull data from one SummaryPro excel into another"]
[]
["File paths (ensure there is a \\ at the end):"]
["Original","C:\\SummaryPro\\Test of HS2 transfer\\Old Files\\","Containing the files to be migrated"]
["Latest","C:\\SummaryPro\\Test of HS2 transfer\\New Files\\","Containing the \"latest\" versions & where the new files will be located"]
[]
["File names (no suffix)"]
["Enter the \"origin\" file name:","SummaryPro v1_14_1 all bit - Copy_OLD","HIDE as the code populates this"]
["Enter the \"latest\" file name (no suffix)","SummaryPro CC TESTING","Enter the file name of the latest version which will be used as the basis for all new copies, use F2 to easily copy the name.  No file type suffix"]
[]
[]
[]
[]
["Length check",{"$f":"IF(LEN(CurrentPath)+LEN(CurrentName)>123,\"file name / path too long by \"&LEN(CurrentPath)+LEN(CurrentName)-123&\" characters\",\"OK\")","v":"OK"},"Checks that the latest file name + path isn't too long.  If it is please move the file to a location with a shorter path"]

{"sheet":"Version changes - Styles","index":1,"n_rows":81,"n_cols":24,"rows_kept":81,"cut":false,"hidden":true,"merged":[]}
["Versions","Date","Comments",null,14.4,null,"Colour Selector",null,null,null,"14.1.  Styles",null,"Colour Selector",null,null,"1.12.2",null,"Colour Selector",null,null,null,"1.13.1",null,"Colour Selector"]
[1.1100000000000001,"2020-09-20","not covered",null,"Column N:Y",null,"Reference",null,null,null,"Column N:Y",null,"Reference",null,null,null,null,"Reference",null,null,null,null,null,"Reference"]
[1.1200000000000001,"2020-09-27","not covered",null,null,"RAG","R",null,null,null,null,"RAG","R",null,null,null,"Defauts","white",null,null,null,null,"RAG","Red"]
["1.12.2","2020-12-16",null,null,null,null,"A",null,null,null,null,null,"A",null,null,null,null,"grey",null,null,null,null,null,"Amber"]
["1.13.1","2021-06-16",null,null,null,null,"G",null,null,null,null,null,"G",null,null,null,null,"black",null,null,null,null,null,"Green"]
["1.13.2","2021-06-16",null,null,null,null,"I",null,null,null,null,null,"I",null,null,null,null,"Default_bar",null,null,null,null,null,"Custom1"]
["1.13.3","2021-07-21",null,null,null,null,"Custom2",null,null,null,null,null,"Custom2",null,null,null,null,"Default_Major_space",null,null,null,null,null,"Custom2"]
["1.13.4","2021-08-26",null,null,null,null,"B",null,null,null,null,null,"B",null,null,null,null,"Default_Minor_space",null,null,null,null,null,"Complete"]
["1.13.5","2021-09-14",null,null,null,null,"unknown",null,null,null,null,null,"unknown",null,null,null,"Time Scales","Floating primary boxes",null,null,null,null,null,"unknown"]
["1.13.6","2021-12-14",null,null,null,"lines","dependency line",null,null,null,null,"lines","dependency line",null,null,null,null,"Line Timescale",null,null,null,null,"lines","dependency line"]
["1.13.8","2022-05-27",null,null,null,null,"Critical Path outline",null,null,null,null,null,"Critical Path outline",null,null,null,null,"Top Timescale boxes colour 1",null,null,null,null,null,"Critical Path outline"]
["1.13.7","2022-05-16",null,null,null,null,"Status Date Line",null,null,null,null,null,"Status Date Line",null,null,null,null,"Top Timescale boxes colour 2",null,null,null,null,null,"Status Date Line"]
["1.13.9","2022-11-11",null,null,null,null,"Target lines",null,null,null,null,null,"Target lines",null,null,null,null,"Primary Timescale boxes colour 1",null,null,null,null,null,"Target lines"]
["1.14.0","2023-03-13",null,null,null,"Defauts","white",null,null,null,null,"Defauts","white",null,null,null,null,"Primary Timescale boxes colour 2",null,null,null,null,"Defauts","white"]
["1.14.1","2023-04-27",null,null,null,null,"grey",null,null,null,null,null,"grey",null,null,null,"lines","dependency line",null,null,null,null,null,"grey"]
["1.14.2","2023-12-19",null,null,null,null,"black",null,null,null,null,null,"black",null,null,null,null,"Critical Path outline",null,null,null,null,null,"black"]
["1.14.3","2024-12-31",null,null,null,null,"Default_bar",null,null,null,null,null,"Default_bar",null,null,null,null,"Status Date Line",null,null,null,null,null,"Default_bar"]
["1.14.4","2025-01-10",null,null,null,null,"Default_Major_space",null,null,null,null,null,"Default_Major_space",null,null,null,null,"Target lines",null,null,null,null,null,"Default_Major_space"]
[null,null,null,null,null,null,"Default_Minor_space",null,null,null,null,null,"Default_Minor_space",null,null,null,"RAG","red",null,null,null,null,null,"Default_Minor_space"]
[null,null,null,null,null,"Time Scales","Floating primary boxes",null,null,null,null,"Time Scales","Floating primary boxes",null,null,null,null,"amber",null,null,null,null,"Time Scales","Floating primary boxes"]
[null,null,null,null,null,null,"Line Timescale",null,null,null,null,null,"Line Timescale",null,null,null,null,"green",null,null,null,null,null,"Line Timescale"]
[null,null,null,null,null,null,"Top Timescale boxes colour 1",null,null,null,null,null,"Top Timescale boxes colour 1",null,null,null,null,"complete",null,null,null,null,null,"Top Timescale boxes colour 1"]
[null,null,null,null,null,null,"Top Timescale boxes colour 2",null,null,null,null,null,"Top Timescale boxes colour 2",null,null,null,null,"unknown",null,null,null,null,null,"Top Timescale boxes colour 2"]
[null,null,null,null,null,null,"Primary Timescale boxes colour 1",null,null,null,null,null,"Primary Timescale boxes colour 1",null,null,null,null,"Custom1",null,null,null,null,null,"Primary Timescale boxes colour 1"]
[null,null,null,null,null,null,"Primary Timescale boxes colour 2",null,null,null,null,null,"Primary Timescale boxes colour 2",null,null,null,null,"Custom2",null,null,null,null,null,"Primary Timescale boxes colour 2"]
[null,null,null,null,null,"Custom Styles - will show in Key Shapes","Mid Blue",null,null,null,null,"Custom Styles - will show in Key Shapes","Mid Blue",null,null,null,"Custom Styles - will show in Key Shapes","Mid Blue",null,null,null,null,"Custom Styles - will show in Key Shapes","Mid Blue"]
[null,null,null,null,null,null,"Holiday",null,null,null,null,null,"Holiday",null,null,null,null,"Holiday",null,null,null,null,null,"Holiday"]
[]
[null,null,null,null,null,null,"Min_div",null,null,null,null,null,"Min_div",null,null,null,null,"Min_div",null,null,null,null,null,"Min_div"]
[null,null,null,null,null,null,"Key",null,null,null,null,null,"Key"]
[]
[null,null,null,null,null,null,"hidden"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Custom Styles - will not show in Key","sample"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Styles - will not show in Key","sample",null,null,null,null,"Custom Styles - will not show in Key","sample"]

{"sheet":"Version changes - Settings","index":2,"n_rows":129,"n_cols":9,"rows_kept":129,"cut":false,"hidden":true,"merged":[]}
["1.14.2","Bar Sizes",null,null,null,"1.12.2","Bar Sizes"]
[null,"Main Bar Height",null,20,null,null,"Main Bar Height",null,12]
[null,"Progress / RAG bar height",null,0,null,null,"Progress / RAG bar height",null,6]
[null,"Baseline bar height",null,0,null,null,"Baseline bar height",null,2]
[null,"Overlay bar",null,6,null,null,"Overlay bar",null,2]
[null,"Major space",null,0,null,null,"Major space"]
[null,"Minor space",null,2,null,null,"Minor space",null,5]
[]
[null,"Page Layout / Size",null,null,null,null,"Page Layout / Size"]
[null,"Optional: gap between minor label and chart",null,0]
[null,"Page width (paper size)",null,420,null,null,"Page width (paper size)",null,420]
[null,"Left Margin",null,10,null,null,"Left Margin",null,8]
[null,"Right Margin",null,10,null,null,"Right Margin",null,10]
[null,"Label width",null,70,null,null,"Label width",null,45]
[null,"Minor Label width",null,55,null,null,"Minor Label width",null,30]
[null,"Page height (top of the paper)",null,297,null,null,"Page height (top of the paper)",null,297]
[null,"Bottom Margin (bottom of the display area)",null,30,null,null,"Bottom Margin (bottom of the display area)",null,30]
[null,"Height of Top timescale labels ",null,15,null,null,"Height of Top timescale labels ",null,12]
[null,"length/height of Primary timescale marks",null,10,null,null,"length/height of Primary timescale marks",null,10]
[null,"Top Margin (Space for Title)",null,25,null,null,"Top Margin (Space for Title)",null,25]
[]
[null,"Dates",null,null,null,null,"Dates"]
[null,"Left Compression","Start",null,null,null,"Left Compression","Start"]
[null,null,"Title",null,null,null,null,"Title"]
[null,"Main Section","Start",44470,null,null,"Main Section","Start",43374]
[null,null,"Finish",44915.75,null,null,null,"Finish",43465]
[null,"Right Compression","Finish",null,null,null,"Right Compression","Finish",43554]
[null,null,"Title","",null,null,null,"Title","Q1 '19"]
[null,"",null,null,null,null,""]
[null,"Weekends","Hide Weekends?","y",null,null,"Weekends","Hide Weekends?","n"]
[null,null,"Weekend starts on","Saturday",null,null,null,"Weekend starts on","Saturday"]
[]
[null,"Days","Start time",0.33333333333333331,null,null,"Days","Start time",0.33333333333333331]
[null,null,"Finish time",0.75,null,null,null,"Finish time",0.75]
[null,null,"Calculated hours per day","10 h",null,null,null,"Calculated hours per day","10 h"]
[null,null,"Hourly divisions",5,null,null,null,"Hourly divisions",5]
[]
[null,"Timescales",null,"Formats",null,null,"Timescales",null,"Formats"]
[null,"Scale","Show","Main Area",null,null,"Scale","Show","Main Area"]
[null,"Line","No Entry","yyyy",null,null,"Line","Years","yyyy"]
[null,"Top Scale","Years","yyyy",null,null,"Top Scale","Quarters","\"Q \"#"]
[null,"Primary Scale","Quarters","\"Q \"#",null,null,"Primary Scale","Months","mmmm"]
[null,"Hide date information?",null,"n",null,null,"Hide date information?",null,"n"]
[null,"Round up Primary scale to whole increment?",null,"y",null,null,"Round up Primary scale to whole increment?",null,"y"]
[null,"Layout",null,null,null,null,"Layout"]
[null,"Which scale extends down the page",null,"Both",null,null,"Which scale extends down the page",null,"Both"]
[null,"Primary label orientation (Vertical / Horizontal)",null,"H",null,null,"Primary label orientation (Vertical / Horizontal)",null,"H"]
[null,"Compress into scales",null,"Primary",null,null,"Compress into scales",null,"Primary"]
[null,"Show divisions in the primary compressions?",null,"y",null,null,"Show divisions in the primary compressions?",null,"y"]
[null,"Show line timescale in compessions?",null,"n",null,null,"Show line timescale in compessions?",null,"y"]
[null,"Start/end shape for top line scale",null,11,null,null,"Start/end shape for top line scale",null,11]
[null,"Start/end size for top line scale",null,2,null,null,"Start/end size for top line scale",null,2]
[]
[null,"Drop Lines / Target dates",null,null,null,null,"Drop Lines / Target dates"]
[null,"1st Target Line ","Date",null,null,null,"1st Target Line ","Date",43429]
[null,null,"Name",null,null,null,null,"Name","test"]
[null,"2nd Target Line","Date",null,null,null,"2nd Target Line","Date",43459]
[null,null,"Name",null,null,null,null,"Name","test 2"]
[null,"Today / Status line","Show?","y",null,null,"Today / Status line","Show?","y"]
[null,null,"Name","Status",null,null,null,"Name","Status"]
[]
[null,"Display options",null,null,null,null,"Display options"]
[null,"Show de-bug ref?",null,"n",null,null,"Show de-bug ref?",null,"n"]
[null,"Show % complete Figures?",null,"n",null,null,"Show % complete Figures?",null,"y"]
[null,"Show row indicators?",null,"n",null,null,"Show row indicators?",null,"y"]
[null,"Show critical path?",null,"n",null,null,"Show critical path?",null,"y"]
[null,"Hide rag / progress bars",null,"y",null,null,"Hide rag / progress bars",null,"n"]
[null,"Hide baseline?",null,"y",null,null,"Hide baseline?",null,"n"]
[]
[null,"Dependencies",null,null,null,null,"Dependencies"]
[null,"Dependency End width",null,0.24,null,null,"Dependency End width",null,0.24]
[null,"Beginning and end size (mm)",null,3,null,null,"Beginning and end size (mm)",null,1]
[]
[null,"Milestones",null,null,null,null,"Milestones"]
[null,"What to show in milestone fill",null,"RAG",null,null,"What to show in milestone fill",null,"Style"]
[null,"Milestone line colour",null,"Style",null,null,"Milestone line colour",null,"Style"]
[null,"When milestone is complete fill colour",null,"complete",null,null,"When milestone is complete fill colour",null,"complete"]
[null,"Show dates in milestones?",null,"n",null,null,"Show dates in milestones?",null,"y"]
[]
[null,"Major Dividing Box defaults",null,null,null,null,"Major Dividing Box defaults"]
[null,"Rounding",null,0,null,null,"Rounding",null,5]
[]
[null,"Minor dividers (Horizontal and vertial)",null,null,null,null,"Minor dividers (Horizontal and vertial)"]
[null,"Line \"overhanging\" to the left of the display",null,55,null,null,"Line \"overhanging\" to the left of the display",null,30]
[null,"Show vertial dividers?",null,"n",null,null,"Show vertial dividers?",null,"n"]
[]
[null,"Task  bars",null,null,null,null,"Task  bars"]
[null,"Rounding for both bars and milestones",null,2,null,null,"Rounding for both bars and milestones",null,0]
[null,"What to show in bar fill",null,"Style",null,null,"What to show in bar fill",null,"Style"]
[null,"Bar line colour",null,"RAG",null,null,"Bar line colour",null,"Style"]
[null,"When bar is complete fill colour",null,"Do not change",null,null,"When bar is complete fill colour",null,"complete"]
[]
[null,"Baseline Bar Settings",null,null,null,null,"Baseline Bar Settings"]
[null,"Milestones:",null,null,null,null,"Milestones:"]
[null,"Dotted baseline milestones?",null,"y",null,null,"Dotted baseline milestones?",null,"y"]
[null,"Baseline Milestone Line",null,"grey",null,null,"Baseline Milestone Line",null,"black"]
[null,"Baseline milestone Fill",null,"grey",null,null,"Baseline milestone Fill",null,"grey"]
[null,"Baseline bars",null,null,null,null,"Baseline bars"]
[null,"Dotted baseline bars?",null,"y",null,null,"Dotted baseline bars?",null,"n"]
[null,"Basline Bar Line",null,"grey",null,null,"Basline Bar Line",null,"black"]
[null,"Baseline Bar Fill",null,"grey",null,null,"Baseline Bar Fill",null,"grey"]
[null,"Line linking basline to plan (if required)",null,null,null,null,"Line linking basline to plan (if required)"]
[null,"Show at all?",null,"y",null,null,"Show at all?",null,"y"]
[null,"Dotted?",null,"y",null,null,"Dotted?",null,"y"]
[null,"Colour",null,"black",null,null,"Colour",null,"black"]
[null,"width",null,0.24,null,null,"width",null,0.24]
[]
[null,"Attachment points - used to \"attach\" brainstorm icons to dates on the summary",null,null,null,null,"Attachment points - used to \"attach\" brainstorm icons to dates on the summary"]
[null,"Show? (make lines and fill visible)",null,"n",null,null,"Show? (make lines and fill visible)",null,"n"]
[null,"colour when shown",null,"RGB(255,0,255)",null,null,"colour when shown",null,"RGB(255,0,255)"]
[]
[null,"Floating date boxes - Primary scale",null,null,null,null,"Floating date boxes - Primary scale"]
[null,"Height",null,10,null,null,"Height",null,20]
[null,"You can move these up from the bottom and they will stay where you put them vertically, can be useful if you veiw the summary on a screen and the dates disapear off the top of the screen, or to display a timescale at the bottom of the page.",null,null,null,null,"You can move these up from the bottom and they will stay where you put them vertically, can be useful if you veiw the summary on a screen and the dates disapear off the top of the screen, or to display a timescale at the bottom of the page."]
[]
[null,"AutoLayout timescale triggers for Primary timescale"]
[null,"Minimum thresholds (in days) to set the Primary timescale"]
[null,"Days",null,31]
[null,"Weeks",null,98]
[null,"Months",null,366]
[null,"Anything more will display Quarters"]
[null,"Set the minimum and maximum space that all the chosen bars can take up (main task  bar + RAG/Status + Baseline)"]
[null,"Min bar size",null,2]
[null,"Max bar size",null,20]
[]
[null,"Dependency Naming convention"]
[null,"SummaryPro use the convesions of Dep for Dependency and Del for Deliverable, however you are free to use your own terms (Dep in, Give etc).  Just provide the \"transalation\" bellow"]
[null,"Dependency (received from another party)",null,"Dep In"]
[null,"Deliverable (provided to another party)",null,"Dep Out"]

{"sheet":"Developement Notes","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}