{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["0a - Homesheet","0b - Model Structure","0 - Input Sheet","1 - Homog Asset Groups","2 - Transition Matrices","3 - Treatment Effects & Costs","4 - Treatment Strategies","5 - Budgets","6 - Performance Targets","7 - Scenario","8 - Condition by Year","9 - Condition Graph","10 - Work Quantity","11 - Work Qty Graph","12 - Exp by Condition Band","13 - Exp by Cond Graph","14 - Exp by Treatment","15 - Exp by Treat Graph","16 - Area by Year","16 - Graph Data","Deterioration Graph","System"],"not_rendered":{"charts":5,"images":37,"macros":1,"external_links":3,"defined_names":84,"comments":1,"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":"0a - Homesheet","index":0,"n_rows":80,"n_cols":9,"rows_kept":80,"cut":false,"hidden":false,"merged":[[77,1,77,7],[77,8,77,11],[78,1,78,7],[78,8,78,11],[79,1,79,7],[79,8,79,11],[74,1,74,7],[74,8,74,11],[75,1,75,7],[75,8,75,11],[76,1,76,7],[76,8,76,11],[57,1,57,5],[57,6,57,9],[59,1,59,11],[72,1,72,11],[73,1,73,7],[73,8,73,11],[53,1,53,11],[54,1,54,11],[46,2,46,4],[46,5,46,11],[47,5,47,11],[51,1,51,11],[47,2,47,4],[49,1,49,5],[49,6,49,9],[6,6,6,9],[40,6,40,9],[44,2,44,4],[45,2,45,4],[42,5,42,11],[44,5,44,11],[45,5,45,11],[6,1,6,5],[40,1,40,5],[42,2,42,4],[43,2,43,4]]}
[]
[]
[null,"HOMESHEET"]
[]
[]
[]
[null,"BASIC USER GUIDANCE"]
[]
[null,"SHEET TAB COLOURS"]
[]
[null,null,null,"Input Sheets: use these sheets to input data to be used in the model, and to initiate model runs."]
[]
[null,null,null,"Output Sheets: use these sheets to view model outputs in tabular and graphical form."]
[]
[null,"INPUT CELL COLOURS"]
[]
[null,null,null,"Mandatory: values must be supplied for these cells before the model can be run. In certain circumstances values"]
[null,null,null,"may be left blank to signify zero values"]
[]
[null,null,null,"Optional: the values in these cells are not used in model runs, but may be entered to aid interpretation of outputs."]
[]
[null,null,null,"Read-Only: the values in these cells are for display purposes only and may not be edited."]
[]
[null,"TASK-BAR BUTTONS"]
[]
[null,null,null,"Homesheet: Click on this button to go to the Homesheet."]
[]
[]
[null,null,null,"Model Structure: Click on the button to go to the Model Structure sheet."]
[]
[]
[null,null,null,"Copy to Clipboard: Click on the button to copy the contents of the worksheet to the Windows Clipboard for ."]
[null,null,null,"subsequent transfer / pasting to MS Word, Excel, etc."]
[null,null,null,"Help Button: a help button is located on the title-bar of each sheet/screen. Click on the button to display"]
[null,null,null,"guidance which is appropriate to the relevant screen."]
[]
[null,"For more comprehensive user guidance, please refer to the accompanying user manual."]
[]
[null,"N.B. Please ensure that Macros are enabled before attempting to use this model."]
[]
[null,"VERSION HISTORY"]
[]
[null,"Version","Date",null,null,"Description"]
[null,1,"2012-11-29",null,null,"First release of the HMEP Toolkit"]
[null,2,"2014-07-03",null,null,"New release to address an issue with performance targets"]
[]
[]
[]
[]
[null,"FAULT REPORTING"]
[]
[null,"The HMEP Programme Board would welcome any comments and feedback on this Toolkit, so that it may be reviewed, improved, and refined to give the sector the best support possible."]
[]
[null,"Please send your comments by email to highwaysefficiency@dft.gsi.gov.uk with the header, \"Feedback on the Lifecycle Planning Toolkit\":"]
[null,"highwaysefficiency@dft.gsi.gov.uk"]
[]
[]
[null,"ACKNOWLEDGMENTS"]
[]
[null,"The Lifecycle Planning Toolkit was developed by Atkins under the Highways Maintenance Efficiency Programme (HMEP).  The help and support of the HMEP Asset Management Working Group and other contributors is acknowledged."]
[]
[null,"Atkins Project Team"]
[null,"Dr. Michael Anyala"]
[null,"Alan Taggart"]
[null,"Lila Tachtsi"]
[null,"Dr. Eric Stannard"]
[null,"Dr. Ro Cartwright"]
[null,"Prof. Martin Snaith"]
[null,"John Paterson"]
[]
[null,"HMEP Asset Management Working Group"]
[]
[null,"Chair – Matthew Lugg OBE (President of ADEPT and Director of Environment and Transport for Leicestershire CC)"]
[null,"DfT - Haydn Davies",null,null,null,null,null,null,"UK Lighting Board - Peter Hosking"]
[null,"DfT - Steve Berry",null,null,null,null,null,null,"UK Bridges Board / TAG - David Yeoell"]
[null,"HAMFIG - Chris Allen-Smith",null,null,null,null,null,null,"UKRLG AM Group - Andy Stevenson"]
[null,"Highways Agency - Clare Griffin",null,null,null,null,null,null,"UKRLG AM Group - Garry Sterritt"]
[null,"Highways Agency - Richard Arrowsmith",null,null,null,null,null,null,"UKRLG AM Group - Paul Boss"]
[null,"HMEP - Gary Thompson",null,null,null,null,null,null,"UKRLG AM Group - Lester Wilmington"]
[null,"HTMA - Dennis Parkinson",null,null,null,null,null,null,"UKRLG AM Group - Phil Moore"]

{"sheet":"0b - Model Structure","index":1,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,2],[4,1,14,1],[15,1,20,1],[21,1,31,1]]}
[]
[]
[null,"MODEL STRUCTURE"]
[]
[null,"INPUTS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ANALYSIS"]
[]
[]
[]
[]
[]
[null,"OUTPUTS"]

{"sheet":"0 - Input Sheet","index":2,"n_rows":117,"n_cols":19,"rows_kept":117,"cut":false,"hidden":false,"merged":[[6,1,6,2],[6,16,6,18],[7,4,9,4],[6,11,6,12],[7,11,9,11],[7,17,9,17],[6,4,6,6]]}
[]
[]
[null,"Input Sheet"]
[]
[]
[]
[null,"Analysis period",null,null,"Condition Bands",null,null,null,null,null,null,"Homogeneous asset groups",null,null,"Scenarios",null,"Treatment Types"]
[null,null,null,null,"Number of condition bands",null,null,null,null,null,null,"Number of homogeneous asset groups",null,null,null,null,null,"Number of treatment types"]
[null,"Start Year",2012,null,null,3,null,null,null,null,null,null,1,null,null,null,null,null,2]
[]
[null,"Analysis Period",25,"yrs","Rank","Description","Short Code",null,null,null,null,"No.","Name",null,"Number",null,"No.","Description","Name"]
[null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,null,null,null,"None"]
[null,null,null,null,{"$f":"ROW()-12","v":1},null,null,null,null,null,null,{"$f":"ROW()-12","v":1},null,null,1,null,{"$f":"ROW()-12","v":1}]
[null,"End Year: ",{"$f":"start_year+analysis_period-1","v":2036},null,{"$f":"ROW()-12","v":2},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()-12","v":2}]
[null,null,null,null,{"$f":"ROW()-12","v":3}]
[null,"Output Graphs"]
[]
[null,"Graph Type:","Bar","Bar"]
[null,null,null,"Area"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Model parameters, which are not user-definable"]
[null,"Minimum analysis period",10,null,"Minimum number of bands",3,null,null,null,null,null,"Minimum number of homogeneous groups",1,null,1,null,"Minimum number of treatments",null,2]
[null,"Maximum analysis period",60,null,"Maximum number of bands",10,null,null,null,null,null,"Maximum number of homogeneous groups",100,null,3,null,"Maximum number of treatments",null,10]

{"sheet":"1 - Homog Asset Groups","index":3,"n_rows":10,"n_cols":30,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2],[5,19,5,23],[5,25,5,29],[6,19,6,23],[6,25,6,29],[5,8,5,10],[6,8,6,10]]}
[]
[]
[null,"HOMOGENEOUS ASSET GROUPS"]
[]
[]
[null,null,null,null,null,null,null,null,"Initial Condition",null,null,null,null,null,null,null,null,null,null,"CAT 1 Defects",null,null,null,null,null,"CAT 2 Defects"]
[null,null,null,null,null,null,null,null,"% of Asset Group in condition band in base year",null,null,null,null,null,null,null,null,null,null,"Average Annual Number per 100m Section in Condition Band",null,null,null,null,null,"Average Annual Number per 100m Section in Condition Band"]
[null,null,null,null,null,null,null,null,{"$f":"COLUMN()-8","v":1},2,3,4,5,6,7,8,9,10,null,1,2,3,4,5,null,1,2,3,4,5]
[null,"Asset Group","Description","Length\n(m)","Width \n(m)","Area","Units",null,{"$f":"OFFSET(CONDITION_BAND_CODE,I8-1,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"OFFSET(CONDITION_BAND_CODE,T8-1,0)","v":0},{"$f":"OFFSET(CONDITION_BAND_CODE,U8-1,0)","v":0},{"$f":"OFFSET(CONDITION_BAND_CODE,V8-1,0)","v":0},{"$f":"OFFSET(CONDITION_BAND_CODE,W8-1,0)","v":0},{"$f":"OFFSET(CONDITION_BAND_CODE,X8-1,0)","v":0},null,{"$f":"OFFSET(CONDITION_BAND_CODE,Z8-1,0)","v":0},{"$f":"OFFSET(CONDITION_BAND_CODE,AA8-1,0)","v":0},{"$f":"OFFSET(CONDITION_BAND_CODE,AB8-1,0)","v":0},{"$f":"OFFSET(CONDITION_BAND_CODE,AC8-1,0)","v":0},{"$f":"OFFSET(CONDITION_BAND_CODE,AD8-1,0)","v":0}]
[null,{"$f":" ROW() - 9","v":1},{"$f":"OFFSET(ASSET_GROUP_NAME,'1 - Homog Asset Groups'!B10-1,0)","v":0},null,null,{"$f":"D10*E10","v":0},"m²",null,null,null,null,0,0,0,0,0,0,0,{"$f":"IF(SUM(OFFSET(I10,0,0,1,current_conditionBands)) <> 100%, \"ERROR\",\"\")","v":"ERROR"},0,0,0,0,0,null,0,0,0,0,0]

{"sheet":"2 - Transition Matrices","index":4,"n_rows":11,"n_cols":65,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2],[7,12,9,12],[7,23,7,30],[6,13,6,21],[7,22,9,22],[7,2,7,11],[7,13,7,21],[6,2,6,11],[6,23,6,30],[7,31,9,31],[7,39,9,39],[7,46,9,46],[7,62,7,63],[7,52,9,52],[7,57,9,57],[7,61,9,61],[7,64,9,64],[7,32,7,38],[7,40,7,45],[7,47,7,51],[7,53,7,56],[7,58,7,60]]}
[]
[]
[null,"TRANSITION MATRICES"]
[]
[]
[]
[null,null,1,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,5,null,null,null,null,null,null,6,null,null,null,null,null,7,null,null,null,null,8,null,null,null,9]
[null,null,{"$f":"OFFSET(CONDITION_BAND_CODE,C7-1,0)","v":0},null,null,null,null,null,null,null,null,null,"Validity Check",{"$f":"OFFSET(CONDITION_BAND_CODE,N7-1,0)","v":0},null,null,null,null,null,null,null,null,"Validity Check",{"$f":"OFFSET(CONDITION_BAND_CODE,X7-1,0)","v":0},null,null,null,null,null,null,null,"Validity Check",{"$f":"OFFSET(CONDITION_BAND_CODE,AG7-1,0)","v":0},null,null,null,null,null,null,"Validity Check",{"$f":"OFFSET(CONDITION_BAND_CODE,AO7-1,0)","v":0},null,null,null,null,null,"Validity Check",{"$f":"OFFSET(CONDITION_BAND_CODE,AV7-1,0)","v":0},null,null,null,null,"Validity Check",{"$f":"OFFSET(CONDITION_BAND_CODE,BB7-1,0)","v":0},null,null,null,"Validity Check",{"$f":"OFFSET(CONDITION_BAND_CODE,BG7-1,0)","v":0},null,null,"Validity Check",{"$f":"OFFSET(CONDITION_BAND_CODE,BK7-1,0)","v":0},null,"Validity Check"]
[null,null,1,2,3,4,5,6,7,8,9,10,null,2,3,4,5,6,7,8,9,10,null,3,4,5,6,7,8,9,10,null,4,5,6,7,8,9,10,null,5,6,7,8,9,10,null,6,7,8,9,10,null,7,8,9,10,null,8,9,10,null,9,10]
[null,"Matrix Name",{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,C9-1,0)","v":"-> "},"-> ","-> ","-> ","-> ","-> ","-> ","-> ","-> ","-> ",null,{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,N9-1,0)","v":"-> "},"-> ","-> ","-> ","-> ","-> ","-> ","-> ","-> ",null,{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,X9-1,0)","v":"-> "},"-> ","-> ","-> ","-> ","-> ","-> ","-> ",null,{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,AG9-1,0)","v":"-> "},"-> ","-> ","-> ","-> ","-> ","-> ",null,{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,AO9-1,0)","v":"-> "},"-> ","-> ","-> ","-> ","-> ",null,{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,AV9-1,0)","v":"-> "},{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,AW9-1,0)","v":"-> "},{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,AX9-1,0)","v":"-> "},{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,AY9-1,0)","v":"-> "},{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,AZ9-1,0)","v":"-> "},null,{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,BB9-1,0)","v":"-> "},{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,BC9-1,0)","v":"-> "},{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,BD9-1,0)","v":"-> "},{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,BE9-1,0)","v":"-> "},null,{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,BG9-1,0)","v":"-> "},{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,BH9-1,0)","v":"-> "},{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,BI9-1,0)","v":"-> "},null,{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,BK9-1,0)","v":"-> "},{"$f":"\"-> \" & OFFSET(CONDITION_BAND_CODE,BL9-1,0)","v":"-> "}]
[null,null,null,null,null,0.05,0,0,0,0,0,0,{"$f":"IF(SUM(OFFSET(C11,0,0,1,current_conditionBands))=1, \"OK\", \"ERROR\")","v":"ERROR"},null,null,0.1,0.1,0.1,0.05,0.05,0,0,{"$f":"IF(SUM(OFFSET(N11,0,0,1,current_conditionBands-1))=1, \"OK\", \"ERROR\")","v":"ERROR"},0.15,0.85,0,0,0,0,0,0,{"$f":"IF(SUM(OFFSET(X11,0,0,1,current_conditionBands-2))=1, \"OK\", \"ERROR\")","v":"ERROR"},0.05,0.95,0,0,0,0,0,{"$f":"IF(SUM(OFFSET(AG11,0,0,1,current_conditionBands-3))=1, \"OK\", \"ERROR\")","v":{"$error":"#REF!"}},0,1,0,0,0,0,{"$f":"IF(SUM(OFFSET(AO11,0,0,1,current_conditionBands-4))=1, \"OK\", \"ERROR\")","v":"ERROR"},0,1,0,0,0,{"$f":"IF(SUM(OFFSET(AV11,0,0,1,current_conditionBands-5))=1, \"OK\", \"ERROR\")","v":"ERROR"},0,1,0,0,{"$f":"IF(SUM(OFFSET(BB11,0,0,1,current_conditionBands-6))=1, \"OK\", \"ERROR\")","v":"ERROR"},0,0,0,{"$f":"IF(SUM(OFFSET(BG11,0,0,1,current_conditionBands-7))=1, \"OK\", \"ERROR\")","v":"ERROR"},0,0,{"$f":"IF(SUM(OFFSET(BK11,0,0,1,current_conditionBands-8))=1, \"OK\", \"ERROR\")","v":"ERROR"}]

{"sheet":"3 - Treatment Effects & Costs","index":5,"n_rows":13,"n_cols":30,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,1,12,1],[11,2,12,2],[11,29,12,29],[5,7,6,17],[5,19,6,29],[7,29,8,29]]}
[]
[]
[null,null,"TREATMENTS EFFECTS & COSTS"]
[]
[]
[null,null,null,null,null,null,null,"Effect of treatment",null,null,null,null,null,null,null,null,null,null,null,"Treatment Cost (£)"]
[]
[null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,null,1,2,3,4,5,6,7,8,9,10,"Units\n(£ per)"]
[null,"No","Asset Group","Treatment",null,"Treatment Details","ID","After-treatment Asset Group",{"$f":"OFFSET(CONDITION_BAND_CODE,I8-1,0)","v":0},0,0,0,0,0,0,0,0,0,"Validity Check",{"$f":"OFFSET(CONDITION_BAND_CODE,T8-1,0)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"CAT 1",null,"CAT 1","None","None","None","None","None","None","None","None","None","None",null,5.58,5.58,5.58,5.58,5.58,5.58,5.58,5.58,5.58,5.58,"no."]
[null,null,null,null,null,"CAT 2",null,"CAT 2","None","None","None","None","None","None","None","None","None","None",null,29.39,29.39,29.39,29.39,29.39,29.39,29.39,29.39,29.39,29.39,"no."]
[null,{"$f":"INT((ROW()-12)/(current_treatmentTypes))+1","v":1},{"$f":"OFFSET(ASSET_GROUP_NAME,B12-1,0)","v":0},1,null,{"$f":"OFFSET(TREATMENT_TYPE_NAME,D12-1,0)","v":0},{"$f":"IF(H12=\"\",0,IF(ISERROR(MATCH(H12,System!$AE$4:$AE$105,0)),-1,MATCH(H12,System!$AE$4:$AE$105,0)-1))","v":0},null,null,null,null,"A","VG","VG",null,null,null,null,{"$f":"IF(CheckTreatmenTypeCodesOK(SELECT_CONDITION_BAND,OFFSET(I12,0,0,1,current_conditionBands),H12,G12)=FALSE,\"ERROR\",\"OK\")","v":{"$error":"#NAME?"}},null,null,null,10,10,10,null,null,null,null,"m²"]
[null,null,null,{"$f":"D12+1","v":2},null,0,{"$f":"IF(H13=\"\",0,IF(ISERROR(MATCH(H13,System!$AE$4:$AE$105,0)),-1,MATCH(H13,System!$AE$4:$AE$105,0)-1))","v":0},null,null,null,null,"A","VG","VG",null,null,null,null,{"$error":"#NAME?"},null,null,null,10,10,10]

{"sheet":"4 - Treatment Strategies","index":6,"n_rows":11,"n_cols":20,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,1,10,1],[9,2,10,2],[2,1,2,14]]}
[]
[]
[null,"Treatment Strategies"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10]
[null,"Serial","Name","Step","Condition Band Index","Treatment Type Index","Treatment","Condition Band","% Treated",{"$f":"OFFSET(CONDITION_BAND_CODE,'4 - Treatment Strategies'!J8-1,0)","v":0},{"$f":"OFFSET(CONDITION_BAND_CODE,'4 - Treatment Strategies'!K8-1,0)","v":0},{"$f":"OFFSET(CONDITION_BAND_CODE,'4 - Treatment Strategies'!L8-1,0)","v":0},{"$f":"OFFSET(CONDITION_BAND_CODE,'4 - Treatment Strategies'!M8-1,0)","v":0},{"$f":"OFFSET(CONDITION_BAND_CODE,'4 - Treatment Strategies'!N8-1,0)","v":0},{"$f":"OFFSET(CONDITION_BAND_CODE,'4 - Treatment Strategies'!O8-1,0)","v":0},{"$f":"OFFSET(CONDITION_BAND_CODE,'4 - Treatment Strategies'!P8-1,0)","v":0},{"$f":"OFFSET(CONDITION_BAND_CODE,'4 - Treatment Strategies'!Q8-1,0)","v":0},{"$f":"OFFSET(CONDITION_BAND_CODE,'4 - Treatment Strategies'!R8-1,0)","v":0},{"$f":"OFFSET(CONDITION_BAND_CODE,'4 - Treatment Strategies'!S8-1,0)","v":0}]
[null,{"$f":"1+(INT(ROW()-10)/System!$B$38)","v":1},null,1,{"$f":"IF(ISERROR(MATCH(H10,SELECT_CONDITION_BAND_ONLY,0)),0,MATCH(H10,SELECT_CONDITION_BAND_ONLY,0))","v":0},{"$f":"IF(ISERROR(MATCH(G10,SELECT_TREATMENT_TYPE,0)),0,MATCH(G10,SELECT_TREATMENT_TYPE,0)-1)","v":0},null,null,null,{"$f":"IF($E10=J$8,$I10,\"\")","v":""},"","","","","","","","","",{"$f":"IF(D10=0,\"Error: Update/enter a performance indicator\",IF(G10='0 - Input Sheet'!$S$12,\"\",IF(OR(G10=\"\",H10=\"\"),System!$Q$6,IF(F10=0,System!$Q$4,IF(E10=0,System!$Q$5,\"\")))))","v":"Error: Select a treatment type and condition band."}]
[null,null,null,{"$f":"D10+1","v":2},0,0,null,null,null,"","","","","","","","","","",{"$f":"IF(D11=0,\"Error: Update/enter a performance indicator\",IF(G11='0 - Input Sheet'!$S$12,\"\",IF(OR(G11=\"\",H11=\"\"),System!$Q$6,IF(F11=0,System!$Q$4,IF(E11=0,System!$Q$5,\"\")))))","v":"Error: Select a treatment type and condition band."}]

{"sheet":"5 - Budgets","index":7,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,1,10,1],[9,2,10,2],[9,6,10,6],[2,1,2,9],[6,1,6,2],[6,4,6,5]]}
[]
[]
[null,"Budgets"]
[]
[]
[]
[]
[]
[null,"Serial","Name","Treatment No.","Treatment","Budget constraints \n(£ 000s)","Total (£ 000s)"]
[null,{"$f":"1+(INT(ROW()-10)/System!$B$35)","v":1},null,1,{"$f":"OFFSET(TREATMENT_TYPE_NAME,D10-1,0)","v":0},null,{"$f":"SUM(OFFSET(F10,0,0,current_treatmentTypes,1))","v":0}]
[null,null,null,{"$f":"D10+1","v":2},0]

{"sheet":"6 - Performance Targets","index":8,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Performance Targets"]
[]
[]
[]
[null,null,"Maximum number of iterations for treatment strategy:",null,1]
[]
[null,"No.","Name","Performance Indicator Code","Performance Indicator","Expression Index","Expression","Performance Target (%)"]
[null,{"$f":"ROW()-9","v":1},null,{"$f":"IF(ISERROR(MATCH(E10,SELECT_PERFOEMANCETARGET,0)),0,MATCH(E10,SELECT_PERFOEMANCETARGET,0))","v":1},null,{"$f":"MATCH(G10,LIST_EXPRESSIONS,0)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(D10=0,\"Error: Update/enter a performance indicator\",IF(OR(E10=\"\",G10=\"\",H10=\"\"),\"Incomplete data entered for target\",IF(OR(AND(F10=1,D10>2),AND(F10=3,D10<3)),\"Error: invalid expression for '\"&E10&\"'.\",\"\")))","v":"Incomplete data entered for target"}]

{"sheet":"7 - Scenario","index":9,"n_rows":11,"n_cols":30,"rows_kept":11,"cut":false,"hidden":false,"merged":[[7,1,10,1],[7,2,10,2],[7,3,10,3],[11,2,11,11]]}
[]
[]
[null,"Scenarios"]
[]
[]
[null,null,null,null,null,{"$f":"TEXT((COLUMN()-5),\"0\")","v":"1"},{"$f":"TEXT((COLUMN()-5),\"0\")","v":"2"},"3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25"]
[null,"No.","Homogeneous Group","Scenario Name","Criteria",{"$f":"TEXT(start_year+(COLUMN()-6),\"0\")","v":"2012"},"2013","2014","2015","2016","2017","2018","2019","2020","2021","2022","2023","2024","2025","2026","2027","2028","2029","2030","2031","2032","2033","2034","2035","2036"]
[null,{"$f":"1+B4","v":1},{"$f":"OFFSET(ASSET_GROUP_NAME,B8-1,0)","v":0},null,"Transition matrix"]
[null,null,null,null,"Treatment strategy"]
[null,null,null,null,"Budget constraint"]
[null,null,null,null,"Performance target"]

{"sheet":"8 - Condition by Year","index":10,"n_rows":10,"n_cols":30,"rows_kept":10,"cut":false,"hidden":false,"merged":[[5,5,5,29],[7,1,9,1]]}
[]
[]
[null,"CONDITION BY YEAR"]
[]
[]
[null,null,null,null,"Initial Distribution",{"$f":" \"End of Year\"","v":"End of Year"}]
[null,"Asset Group","No.","Cond",{"$f":"TEXT(start_year+(COLUMN()-5),\"0\")","v":"2012"},{"$f":"TEXT(start_year+(COLUMN()-6),\"0\")","v":"2012"},"2013","2014","2015","2016","2017","2018","2019","2020","2021","2022","2023","2024","2025","2026","2027","2028","2029","2030","2031","2032","2033","2034","2035","2036"]
[{"$f":"INT((ROW()-8)/current_conditionBands)+1","v":1},{"$f":"OFFSET(ASSET_GROUP_NAME,A8-1,0)","v":0},1,{"$f":"OFFSET(CONDITION_BAND_CODE,'8 - Condition by Year'!C8-1,0)","v":0},1,0.95,0.90249999999999997,0.85737499999999989,0.81450624999999988,0.77378093749999988,0.7350918906249998,0.69833729609374973,0.66342043128906225,0.63024940972460908,0.59873693923837856,0.56880009227645956,0.54036008766263655,0.5133420832795047,0.48767497911552943,0.46329123015975293,0.44012666865176525,0.41812033521917696,0.39721431845821809,0.37735360253530714,0.35848592240854177,0.34056162628811465,0.3235335449737089,0.30735686772502346,0.29198902433877227,0.27738957312183365]
[null,null,{"$f":"C8+1","v":2},{"$f":"OFFSET(CONDITION_BAND_CODE,'8 - Condition by Year'!C9-1,0)","v":0},0,0.05,9.5000000000000001E-2,0.135375,0.17147499999999999,0.20362656249999997,0.23213428124999996,0.25728216171874996,0.27933491843749991,0.29853919408007801,0.31512470486230454,0.32930531658110823,0.3412800553658758,0.3512340569807138,0.35933945829565334,0.36575623433664711,0.37063298412780238,0.3741076683540005,0.37630830169725932,0.37735360253530725,0.37735360253530725,0.37641021852896894,0.37461778891692621,0.37206357671976531,0.36882824127002822,0.36498628042346543]
[null,null,{"$f":"C9+1","v":3},{"$f":"OFFSET(CONDITION_BAND_CODE,'8 - Condition by Year'!C10-1,0)","v":0},0,0,2.5000000000000005E-3,7.2500000000000012E-3,1.4018750000000002E-2,2.2592500000000001E-2,3.2773828125000001E-2,4.4380542187499997E-2,5.7244650273437496E-2,7.1211396195312499E-2,8.6138355899316399E-2,0.10189459114243163,0.11835985697148704,0.13542385973978083,0.15298556258881651,0.17095253550359918,0.18924034722043154,0.20777199642682165,0.22647737984452168,0.24529279492938466,0.26416047505615003,0.28302815518291541,0.30184866610936384,0.32057955555521017,0.33918273439119845,0.35762414645469986]

{"sheet":"9 - Condition Graph","index":11,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,1,5,2],[5,3,5,7]]}
[]
[]
[null,"CONDITION GRAPH"]
[]
[]
[null,"Select Asset Group: ",null,"Test"]

{"sheet":"10 - Work Quantity","index":12,"n_rows":9,"n_cols":30,"rows_kept":9,"cut":false,"hidden":false,"merged":[[6,1,8,1]]}
[]
[]
[null,"WORK QUANTITY"]
[]
[null,"Table of Work Quantities (m²) for Treatment Types by Asset Group"]
[null,"Asset Group","Num","Treatment","Total  (m²)",{"$f":"TEXT(start_year+(COLUMN()-6),\"0\")","v":"2012"},"2013","2014","2015","2016","2017","2018","2019","2020","2021","2022","2023","2024","2025","2026","2027","2028","2029","2030","2031","2032","2033","2034","2035","2036"]
[{"$f":"INT((ROW()-7)/(current_treatmentTypes+1))+1","v":1},{"$f":"OFFSET(ASSET_GROUP_NAME,A7-1,0)","v":0},1,{"$f":"OFFSET(TREATMENT_TYPE_NAME,'10 - Work Quantity'!C7-1,0)","v":0},{"$f":"SUM(OFFSET(F7,0,0,1,analysis_period))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C7+1","v":2},{"$f":"OFFSET(TREATMENT_TYPE_NAME,'10 - Work Quantity'!C8-1,0)","v":0},{"$f":"SUM(OFFSET(F8,0,0,1,analysis_period))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total",{"$f":"SUM(OFFSET(E7,0,0,current_treatmentTypes,1))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(OFFSET(P7,0,0,current_treatmentTypes,1))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"11 - Work Qty Graph","index":13,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,1,5,2],[5,3,5,7]]}
[]
[]
[null,"WORK QUANTITY GRAPH"]
[]
[]
[null,"Select Asset Group: ",null,"Test"]

{"sheet":"12 - Exp by Condition Band","index":14,"n_rows":16,"n_cols":30,"rows_kept":16,"cut":false,"hidden":false,"merged":[[16,1,16,13],[11,1,15,1],[6,1,10,1]]}
[]
[]
[null,"EXPENDITURE BY CONDITION BAND"]
[]
[null,"Table of Expenditure (£) in each Condition Band for Asset Groups"]
[null,"Asset Group","No.","Condition Band","Analysis Period\nTotal (£)",{"$f":"TEXT(start_year+(COLUMN()-6),\"0\")","v":"2012"},"2013","2014","2015","2016","2017","2018","2019","2020","2021","2022","2023","2024","2025","2026","2027","2028","2029","2030","2031","2032","2033","2034","2035","2036"]
[{"$f":"INT((ROW()-7)/(current_conditionBands+2))+1","v":1},{"$f":"OFFSET(ASSET_GROUP_NAME,A7-1,0)","v":0},1,{"$f":"OFFSET(CONDITION_BAND_CODE,C7-1,0)","v":0},{"$f":"SUM(OFFSET(F7,0,0,1,analysis_period))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C7+1","v":2},{"$f":"OFFSET(CONDITION_BAND_CODE,C8-1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C8+1","v":3},{"$f":"OFFSET(CONDITION_BAND_CODE,C9-1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total",0,{"$f":"SUM(OFFSET(F7,0,0,current_conditionBands,1))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(OFFSET(P7,0,0,current_conditionBands,1))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Cumulative",{"$f":"E10","v":0},{"$f":" F10","v":0},{"$f":"OFFSET(G10,1,-1)+G10","v":0},{"$f":"OFFSET(H10,1,-1)+H10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Expenditure",1,{"$f":"OFFSET(CONDITION_BAND_CODE,C12-1,0)","v":0},{"$f":"SUM(OFFSET(F12,0,0,1,analysis_period))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C12+1","v":2},{"$f":"OFFSET(CONDITION_BAND_CODE,C13-1,0)","v":0},{"$f":"SUM(OFFSET(F13,0,0,1,analysis_period))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C13+1","v":3},{"$f":"OFFSET(CONDITION_BAND_CODE,C14-1,0)","v":0},{"$f":"SUM(OFFSET(F14,0,0,1,analysis_period))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total",{"$f":"SUM(OFFSET(E12,0,0,current_conditionBands,1))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(OFFSET(P12,0,0,current_conditionBands,1))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Cumulative",{"$f":" E15","v":0},{"$f":" F15","v":0},{"$f":"OFFSET(G15,1,-1)+G15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"13 - Exp by Cond Graph","index":15,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,1,5,2]]}
[]
[]
[null,"EXPENDITURE BY CONDITION BAND GRAPH"]
[]
[]
[null,null,null,null,"(Selected: Test)"]

{"sheet":"14 - Exp by Treatment","index":16,"n_rows":14,"n_cols":30,"rows_kept":14,"cut":false,"hidden":false,"merged":[[10,1,13,1],[6,1,9,1]]}
[]
[]
[null,"EXPENDITURE BY TREATMENT"]
[]
[null,"Table of Expenditure (£) by Treatment Type for Asset Groups"]
[null,"Asset Group","No.","Treatment","Analysis Period\nTotal (£)",{"$f":"TEXT(start_year+(COLUMN()-6),\"0\")","v":"2012"},"2013","2014","2015","2016","2017","2018","2019","2020","2021","2022","2023","2024","2025","2026","2027","2028","2029","2030","2031","2032","2033","2034","2035","2036"]
[{"$f":"INT((ROW()-7)/(current_treatmentTypes+2))+1","v":1},{"$f":"OFFSET(ASSET_GROUP_NAME,A7-1,0)","v":0},1,{"$f":"OFFSET(TREATMENT_TYPE_NAME,C7-1,0)","v":0},{"$f":"SUM(OFFSET(F7,0,0,1,analysis_period))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C7+1","v":2},{"$f":"OFFSET(TREATMENT_TYPE_NAME,C8-1,0)","v":0},{"$f":"SUM(OFFSET(F8,0,0,1,analysis_period))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total",{"$f":"SUM(OFFSET(E7,0,0,current_treatmentTypes,1))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(OFFSET(P7,0,0,current_treatmentTypes,1))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Cumulative",{"$f":"E9","v":0},{"$f":"F9","v":0},{"$f":"OFFSET(G9,1,-1)+G9","v":0},{"$f":"OFFSET(H9,1,-1)+H9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Expenditure",1,{"$f":"OFFSET(TREATMENT_TYPE_NAME,C11-1,0)","v":0},{"$f":"SUM(OFFSET(F11,0,0,1,analysis_period))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C11+1","v":2},{"$f":"OFFSET(TREATMENT_TYPE_NAME,C12-1,0)","v":0},{"$f":"SUM(OFFSET(F12,0,0,1,analysis_period))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total",{"$f":"SUM(OFFSET(E11,0,0,current_treatmentTypes,1))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(OFFSET(P11,0,0,current_treatmentTypes,1))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Cumulative",{"$f":"E13","v":0},{"$f":"F13","v":0},{"$f":"OFFSET(G13,1,-1)+G13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"15 - Exp by Treat Graph","index":17,"n_rows":6,"n_cols":14,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,1,5,2],[5,3,5,7],[5,13,5,14]]}
[]
[]
[null,"EXPENDITURE BY TREATMENT GRAPH"]
[]
[]
[null,"Select Asset Group:  ",null,"Test",null,null,null,null,null,null,null,null,"Treatment:","All Treatments"]

{"sheet":"16 - Area by Year","index":18,"n_rows":10,"n_cols":30,"rows_kept":10,"cut":false,"hidden":false,"merged":[[5,5,5,29],[7,1,9,1]]}
[]
[]
[null,"AREA BY YEAR"]
[]
[]
[null,null,null,null,"Initial Distribution (m²)",{"$f":" \"End of Year Distribution (m²)\"","v":"End of Year Distribution (m²)"}]
[null,"Asset Group","No.","Cond",{"$f":"TEXT(start_year+(COLUMN()-5),\"0\")","v":"2012"},{"$f":"TEXT(start_year+(COLUMN()-6),\"0\")","v":"2012"},"2013","2014","2015","2016","2017","2018","2019","2020","2021","2022","2023","2024","2025","2026","2027","2028","2029","2030","2031","2032","2033","2034","2035","2036"]
[{"$f":"INT((ROW()-8)/current_conditionBands)+1","v":1},{"$f":"OFFSET(ASSET_GROUP_NAME,A8-1,0)","v":0},1,{"$f":"OFFSET(CONDITION_BAND_CODE,'16 - Area by Year'!C8-1,0)","v":0},2000,1900,1805,1714.7499999999998,1629.0124999999998,1547.5618749999996,1470.1837812499996,1396.6745921874995,1326.8408625781244,1260.4988194492182,1197.4738784767571,1137.600184552919,1080.7201753252732,1026.6841665590093,975.34995823105885,926.58246031950591,880.25333730353054,836.24067043835396,794.42863691643618,754.70720507061424,716.97184481708359,681.12325257622933,647.0670899474178,614.7137354500469,583.97804867754451,554.77914624366736]
[null,null,{"$f":"C8+1","v":2},{"$f":"OFFSET(CONDITION_BAND_CODE,'16 - Area by Year'!C9-1,0)","v":0},0,100,190,270.75,342.95,407.25312499999995,464.26856249999992,514.56432343749987,558.66983687499987,597.07838816015601,630.24940972460911,658.61063316221646,682.56011073175159,702.46811396142766,718.67891659130669,731.51246867329428,741.26596825560478,748.21533670800102,752.61660339451862,754.70720507061446,754.70720507061446,752.82043705793785,749.2355778338524,744.12715343953062,737.65648254005646,729.97256084693083]
[null,null,{"$f":"C9+1","v":3},{"$f":"OFFSET(CONDITION_BAND_CODE,'16 - Area by Year'!C10-1,0)","v":0},0,0,5.0000000000000009,14.500000000000002,28.037500000000005,45.185000000000002,65.547656250000003,88.761084374999996,114.48930054687499,142.42279239062501,172.27671179863279,203.78918228486324,236.7197139429741,270.84771947956165,305.97112517763304,341.90507100719833,378.48069444086309,415.54399285364332,452.95475968904339,490.58558985876931,528.32095011230012,566.05631036583077,603.69733221872764,641.15911111042033,678.36546878239687,715.24829290939977]

{"sheet":"16 - Graph Data","index":19,"n_rows":11,"n_cols":51,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Year",2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061]
["G",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["F",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["P",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["P",0,1347500,0,0,0,64550,1297715.6250000002,0,0,0,0,0,0,0,0,0,0,0,0,1563394.6945312503,2062212.07,2140711.2310922858,0,0,0]
["VP",0,981000,0,0,0,337700,2493527.5,0,0,0,0,0,0,0,0,0,0,0,0,3522337.1804687511,2879190.1116601573,2813833.882191407,0,0,0]
["FAL",0,10000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0]
["CB#8",0,0,0,1000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["CB#9",0,0,0,0,0,0,0,170000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["CB#10",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Deterioration Graph","index":20,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["yr",{"$f":"OFFSET(CONDITION_BAND_CODE,COLUMN()-2,0)","v":0},0,0,0,0,0,0,0,0,0]
[0,0.8,0.05,0.05,0.05,0.05,0,0.05,0.05,0.05,0.05]
[1,0.64,0.1575,5.2499999999999998E-2,4.4999999999999998E-2,0.105,0,0.1,0.1,0.05,0.05]
[2,0.51200000000000012,0.21412500000000001,6.6125000000000017E-2,5.2499999999999998E-2,0.15525,0.03,0.12,0.2,0.05,0.05]
[3,0.40960000000000013,0.23739375000000001,7.173125000000001E-2,6.6912500000000014E-2,0.21436250000000001,0.13750000000000001,0.13100000000000001,0.32,0.05,0.05]
[4,0.32768000000000014,0.23948531250000002,7.1545312500000013E-2,7.284125000000001E-2,0.28844812500000006,0.33724999999999999,0.122,0.45100000000000001,0.05,0.05]
[5,0.2621440000000001,0.22876598437500004,6.785832812500002E-2,7.2787781250000017E-2,0.36844390625000006,0.5453937499999999,0.11228750000000001,0.57299999999999995,0.05,0.05]
[6,0.2097152000000001,0.21089608828125003,6.2253313281250021E-2,6.9117878125000018E-2,0.44801752031250008,0.70990562499999987,8.1929999999999989E-2,0.68528749999999994,0.05,0.05]
[7,0.16777216000000009,0.18962934621093752,5.5777643320312514E-2,6.3460120703125025E-2,0.52336072976562509,0.82337817187499984,5.3713843749999997E-2,0.76721749999999989,0.05,0.05]
[8,0.13421772800000006,0.16738783365820314,4.9103359408203137E-2,5.6892464132812515E-2,0.59239861480078138,0.89587477968749984,3.3201418749999996E-2,0.82093134374999988,0.05,0.05]
[9,0.10737418240000006,0.14567353444365236,4.2643621102050791E-2,5.0107247179882825E-2,0.65420141487441419,0.94002618214843736,1.9768054921875E-2,0.85413276249999992,0.05,0.05]
[10,8.589934592000005E-2,0.12536127819273929,3.6635597063833014E-2,4.3530754658925787E-2,0.70857302416450207,0.96605687870703116,1.1466944093750001E-2,0.87390081742187498,0.05,0.05]
[11,6.871947673600004E-2,0.10690586053255448,3.1199002787739512E-2,3.7408321413895024E-2,0.75576733852981115,0.98105024187529288,6.5248159068359377E-3,0.88536776151562502,0.05,0.05]
[12,5.4975581388800036E-2,9.048731690981586E-2,2.6377096082697876E-2,3.1864445396206309E-2,0.79629556022248016,0.98953600850350576,3.658062663164062E-3,0.89189257742246097,0.05,0.05]
[13,4.3980465111040035E-2,7.6111824890681898E-2,2.2165097255538072E-2,2.6944897515783987E-2,0.83079771522695622,0.99427344598038636,2.0268561008315428E-3,0.89555064008562502,0.05,0.05]
[14,3.518437208883203E-2,6.3680938434667433E-2,1.8529643096465286E-2,2.2645923911741455E-2,0.85995912246829398,0.99688944354636344,1.112340047067578E-3,0.89757749618645655,0.05,0.05]
[15,2.8147497671065627E-2,5.3038359639325378E-2,1.5421888446198354E-2,1.8934243553728865E-2,0.88445801068968199,0.99832108200504477,6.0562596365727913E-4,0.89868983623352416,0.05,0.05]
[16,2.2517998136852502E-2,4.4000894380153879E-2,1.2786141233728275E-2,1.5760523161234871E-2,0.90493444308803073,0.99909872111152054,3.2754094315969897E-4,0.89929546219718148,0.05,0.05]
[17,1.8014398509482003E-2,3.6378370505643284E-2,1.0565385844559814E-2,1.3068264767676727E-2,0.92197358037263843,0.99951845060921929,1.7613445093576021E-4,0.89962300314034116,0.05,0.05]
[18,1.4411518807585602E-2,2.9985937655654764E-2,8.7046633188307496E-3,1.0799496493158006E-2,0.93609838372477117,0.99974377033118311,9.4249214949391807E-5,0.89979913759127694,0.05,0.05]
[19,1.1529215046068483E-2,2.4651181062878912E-2,7.1529966374517711E-3,8.898260703788876E-3,0.94776834654981224,0.99986415767885484,5.0215602185985172E-5,0.89989338680622633,0.05,0.05]
[20,9.2233720368547871E-3,2.0217768054069454E-2,5.8643467967517959E-3,7.3126061949779506E-3,0.95738190691734626,0.99992821509605556,2.6653298444217223E-5,0.89994360240841231,0.05,0.05]

{"sheet":"System","index":21,"n_rows":105,"n_cols":52,"rows_kept":105,"cut":false,"hidden":true,"merged":[[2,21,2,22],[2,9,2,10],[2,12,2,13],[2,15,2,16],[2,18,2,19]]}
["DO NOT EDIT THIS WORKSHEET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Graph Titles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colours For Treatment Based Graphs",null,null,null,null,"Expenditure By Condition Graph Selections"]
["Improvement in Condition",null,null,"Asset Groups","Scenarios","Strategies",null,"Transition Matrix",null,"List of Treatment Strategies",null,null,"List of Budgets",null,null,"Error Messages",null,null,"List of Performance Targets",null,null,"List of Performance Expressions",null,null,null,"All Treatments",null,"Sheet","Title",null,"Asset Groups - after-treatment list",null,null,null,null,null,null,null,null,null,null,null,null,null,"Treat Num",null,"R","G","B",null,"# Assets",1]
["VG",null,null,"Total Expenditure",null,"Do Nothing",null,"Unselected",null,1,{"$f":"TREATSTRAT_NAME_FIRST","v":0},null,1,{"$f":"BUDGETS_NAME_FIRST","v":0},null,1,"Error: The treatment selected no longer exists on the input sheet.",null,1,{"$f":"CONDITION_BAND_CODE","v":0},null,1,">=",null,null,"All Treatments",null,9,{"$f":"\"Asset: \" & cond_graph_subnet_choice & \" Scenario: \" & OFFSET('7 - Scenario'!D8,(MATCH(cond_graph_subnet_choice,subnets_pick_range,0)-1)*4,0)","v":{"$error":"#N/A"}},null,"No Change",null,"RED",0,0,0,0,0,0,0,0,null,null,null,1,"[Color 17]",153,153,255,null,"Asset List",0]
["G",null,null,{"$f":"'0 - Input Sheet'!M13","v":0},1,"Subnetwork 1",1,null,null,{"$f":"J4+1","v":2},{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J5,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J5-1),0),\"\")","v":""},null,{"$f":"M4+1","v":2},{"$f":"IF(CURRENT_BUDGETS>=M5,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M5-1),0),\"\")","v":""},null,{"$f":"P4+1","v":2},"Error: The condition band selected no longer exists on the input sheet.",null,{"$f":"S4+1","v":2},{"$f":"CONDITION_BAND_CODE & \" & \" &'0 - Input Sheet'!G14","v":" & "},null,{"$f":"V4+1","v":2},"=",null,1,{"$f":"TREATMENT_TYPE_NAME","v":0},null,11,{"$f":"\"Asset: \" & work_qty_picklist & \" Scenario: \" & OFFSET('7 - Scenario'!D8,(MATCH(work_qty_picklist,subnets_pick_range,0)-1)*4,0)","v":{"$error":"#N/A"}},null,{"$f":"'0 - Input Sheet'!M13","v":0},null,null,51,51,0,0,0,0,0,255,1,null,"0, 128, 0",2,null,255,255,0,null,null,1]
["A",null,null,{"$f":"'0 - Input Sheet'!M14","v":0},1,"Subnetworks 2 to 4",{"$f":"G5+1","v":2},"RR High",null,{"$f":"J5+1","v":3},{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J6,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J6-1),0),\"\")","v":""},null,{"$f":"M5+1","v":3},{"$f":"IF(CURRENT_BUDGETS>=M6,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M6-1),0),\"\")","v":""},null,3,"Error: Select a treatment type and condition band.",null,{"$f":"S5+1","v":3},{"$f":"OFFSET(CONDITION_BAND_CODE,current_conditionBands-1,0) & \" & \" & OFFSET(CONDITION_BAND_CODE, current_conditionBands-2,0)","v":" & "},null,3,"<=",null,2,{"$f":"OFFSET(TREATMENT_TYPE_NAME,Y6-1,0)","v":0},null,13,null,null,{"$f":"'0 - Input Sheet'!M14","v":0},null,null,0,0,153,153,153,255,255,255,2,null,"153, 204, 0",3,"[Color 19]",255,255,204]
["None",null,null,{"$f":"'0 - Input Sheet'!M15","v":0},1,null,{"$f":"G6+1","v":3},"No Deterioration",null,4,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J7,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J7-1),0),\"\")","v":""},null,4,{"$f":"IF(CURRENT_BUDGETS>=M7,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M7-1),0),\"\")","v":""},null,4,null,null,{"$f":"S6+1","v":4},{"$f":"OFFSET(CONDITION_BAND_CODE,current_conditionBands-1,0)","v":0},null,null,null,null,3,0,null,15,{"$f":"IF(exp_by_treat_picklist=System!D4,System!D4,\"Asset: \" & exp_by_treat_picklist & \" Scenario: \" & OFFSET('7 - Scenario'!D8,(MATCH(exp_by_treat_picklist,subnets_pick_range,0)-1)*4,0))","v":{"$error":"#N/A"}},null,{"$f":"'0 - Input Sheet'!M15","v":0},null,null,153,153,255,255,255,255,255,null,3,null,"0, 255, 0",4,"[Color 20]",204,255,255]
[null,null,null,{"$f":"'0 - Input Sheet'!M16","v":0},1,null,4,"No Deterioration",null,5,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J8,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J8-1),0),\"\")","v":""},null,5,{"$f":"IF(CURRENT_BUDGETS>=M8,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M8-1),0),\"\")","v":""},null,5,null,null,null,null,null,null,null,null,4,0,null,null,null,null,{"$f":"'0 - Input Sheet'!M16","v":0},null,null,255,255,255,255,255,255,null,null,4,null,"255, 255, 0",5,"[Color 21]",102,0,102]
["Yes/No",null,null,{"$f":"'0 - Input Sheet'!M17","v":0},1,null,5,"Copy: RR Low 1",null,6,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J9,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J9-1),0),\"\")","v":""},null,6,{"$f":"IF(CURRENT_BUDGETS>=M9,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M9-1),0),\"\")","v":""},null,6,null,null,null,null,null,null,null,null,5,0,null,null,null,null,{"$f":"'0 - Input Sheet'!M17","v":0},null,null,255,255,255,255,255,null,null,null,5,null,"255, 255, 153",6,"[Color 22]",255,128,128]
["Y",null,null,{"$f":"'0 - Input Sheet'!M18","v":0},1,null,6,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G10-1,0)","v":{"$error":"#REF!"}},null,7,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J10,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J10-1),0),\"\")","v":""},null,7,{"$f":"IF(CURRENT_BUDGETS>=M10,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M10-1),0),\"\")","v":""},null,7,null,null,null,null,null,null,null,null,6,0,null,null,null,null,{"$f":"'0 - Input Sheet'!M18","v":0},null,null,255,255,255,255,null,null,null,null,6,null,"255, 153, 0",7,"[Color 23]",0,102,204]
["N",null,null,{"$f":"'0 - Input Sheet'!M19","v":0},1,null,7,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G11-1,0)","v":{"$error":"#REF!"}},null,8,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J11,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J11-1),0),\"\")","v":""},null,8,{"$f":"IF(CURRENT_BUDGETS>=M11,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M11-1),0),\"\")","v":""},null,8,null,null,null,null,null,null,null,null,7,0,null,null,null,null,{"$f":"'0 - Input Sheet'!M19","v":0},null,null,255,255,255,null,null,null,null,null,7,null,"255, 102, 0",8,"[Color 24]",204,204,255]
[null,null,null,{"$f":"'0 - Input Sheet'!M20","v":0},1,null,8,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G12-1,0)","v":{"$error":"#REF!"}},null,9,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J12,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J12-1),0),\"\")","v":""},null,9,{"$f":"IF(CURRENT_BUDGETS>=M12,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M12-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,8,0,null,null,null,null,{"$f":"'0 - Input Sheet'!M20","v":0},null,null,255,255,null,null,null,null,null,null,8,null,"255, 153, 204",9,"[Color 25]",0,0,128]
["Units",null,null,{"$f":"'0 - Input Sheet'!M21","v":0},1,null,9,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G13-1,0)","v":{"$error":"#REF!"}},null,10,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J13,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J13-1),0),\"\")","v":""},null,10,{"$f":"IF(CURRENT_BUDGETS>=M13,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M13-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,9,0,null,null,null,null,{"$f":"'0 - Input Sheet'!M21","v":0},null,null,255,null,null,null,null,null,null,null,9,null,"255, 128, 128",10,"[Color 26]",255,0,255]
["no.",null,null,{"$f":"'0 - Input Sheet'!M22","v":0},1,null,10,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G14-1,0)","v":{"$error":"#REF!"}},null,11,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J14,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J14-1),0),\"\")","v":""},null,11,{"$f":"IF(CURRENT_BUDGETS>=M14,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M14-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,10,0,null,null,null,null,{"$f":"'0 - Input Sheet'!M22","v":0},null,null,null,null,null,null,null,null,null,null,10,null,"255, 0, 0"]
["m",null,null,{"$f":"'0 - Input Sheet'!M23","v":0},1,null,11,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G15-1,0)","v":{"$error":"#REF!"}},null,12,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J15,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J15-1),0),\"\")","v":""},null,12,{"$f":"IF(CURRENT_BUDGETS>=M15,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M15-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M23","v":0},null,"GREEN",128,128,128,128,128,128,128,128]
["m²",null,null,{"$f":"'0 - Input Sheet'!M24","v":0},1,null,12,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G16-1,0)","v":{"$error":"#REF!"}},null,13,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J16,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J16-1),0),\"\")","v":""},null,13,{"$f":"IF(CURRENT_BUDGETS>=M16,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M16-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M24","v":0},null,null,153,153,255,255,255,255,255,255]
[null,null,null,{"$f":"'0 - Input Sheet'!M25","v":0},1,null,13,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G17-1,0)","v":{"$error":"#REF!"}},null,14,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J17,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J17-1),0),\"\")","v":""},null,14,{"$f":"IF(CURRENT_BUDGETS>=M17,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M17-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M25","v":0},null,null,255,255,204,204,204,255,255,0]
["Months",null,null,{"$f":"'0 - Input Sheet'!M26","v":0},1,null,14,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G18-1,0)","v":{"$error":"#REF!"}},null,15,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J18,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J18-1),0),\"\")","v":""},null,15,{"$f":"IF(CURRENT_BUDGETS>=M18,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M18-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M26","v":0},null,null,204,204,255,255,255,204,0]
[1,"January",null,{"$f":"'0 - Input Sheet'!M27","v":0},1,null,15,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G19-1,0)","v":{"$error":"#REF!"}},null,16,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J19,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J19-1),0),\"\")","v":""},null,16,{"$f":"IF(CURRENT_BUDGETS>=M19,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M19-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M27","v":0},null,null,255,255,255,255,204,0]
[2,"February",null,{"$f":"'0 - Input Sheet'!M28","v":0},1,null,16,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G20-1,0)","v":{"$error":"#REF!"}},null,17,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J20,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J20-1),0),\"\")","v":""},null,17,{"$f":"IF(CURRENT_BUDGETS>=M20,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M20-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M28","v":0},null,null,255,255,255,204,0]
[3,"March",null,{"$f":"'0 - Input Sheet'!M29","v":0},1,null,17,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G21-1,0)","v":{"$error":"#REF!"}},null,18,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J21,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J21-1),0),\"\")","v":""},null,18,{"$f":"IF(CURRENT_BUDGETS>=M21,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M21-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M29","v":0},null,null,255,255,204,0]
[4,"April",null,{"$f":"'0 - Input Sheet'!M30","v":0},1,null,18,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G22-1,0)","v":{"$error":"#REF!"}},null,19,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J22,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J22-1),0),\"\")","v":""},null,19,{"$f":"IF(CURRENT_BUDGETS>=M22,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M22-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M30","v":0},null,null,204,204,0]
[5,"May",null,{"$f":"'0 - Input Sheet'!M31","v":0},1,null,19,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G23-1,0)","v":{"$error":"#REF!"}},null,20,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J23,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J23-1),0),\"\")","v":""},null,20,{"$f":"IF(CURRENT_BUDGETS>=M23,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M23-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M31","v":0},null,null,102,0]
[6,"June",null,{"$f":"'0 - Input Sheet'!M32","v":0},1,null,20,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G24-1,0)","v":{"$error":"#REF!"}},null,21,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J24,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J24-1),0),\"\")","v":""},null,21,{"$f":"IF(CURRENT_BUDGETS>=M24,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M24-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M32","v":0},null,null,0]
[7,"July",null,{"$f":"'0 - Input Sheet'!M33","v":0},1,null,21,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G25-1,0)","v":{"$error":"#REF!"}},null,22,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J25,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J25-1),0),\"\")","v":""},null,22,{"$f":"IF(CURRENT_BUDGETS>=M25,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M25-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M33","v":0}]
[8,"August",null,{"$f":"'0 - Input Sheet'!M34","v":0},1,null,22,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G26-1,0)","v":{"$error":"#REF!"}},null,23,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J26,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J26-1),0),\"\")","v":""},null,23,{"$f":"IF(CURRENT_BUDGETS>=M26,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M26-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M34","v":0},null,"BLUE",0,0,0,0,0,0,0,0]
[9,"September",null,{"$f":"'0 - Input Sheet'!M35","v":0},1,null,23,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G27-1,0)","v":{"$error":"#REF!"}},null,24,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J27,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J27-1),0),\"\")","v":""},null,24,{"$f":"IF(CURRENT_BUDGETS>=M27,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M27-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M35","v":0},null,null,102,102,0,0,0,0,0,0]
[10,"October",null,{"$f":"'0 - Input Sheet'!M36","v":0},1,null,24,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G28-1,0)","v":{"$error":"#REF!"}},null,25,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J28,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J28-1),0),\"\")","v":""},null,25,{"$f":"IF(CURRENT_BUDGETS>=M28,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M28-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M36","v":0},null,null,0,0,0,0,0,0,0,0]
[11,"November",null,{"$f":"'0 - Input Sheet'!M37","v":0},1,null,25,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G29-1,0)","v":{"$error":"#REF!"}},null,26,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J29,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J29-1),0),\"\")","v":""},null,26,{"$f":"IF(CURRENT_BUDGETS>=M29,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M29-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M37","v":0},null,null,0,0,204,153,0,0,0]
[12,"December",null,{"$f":"'0 - Input Sheet'!M38","v":0},1,null,26,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G30-1,0)","v":{"$error":"#REF!"}},null,27,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J30,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J30-1),0),\"\")","v":""},null,27,{"$f":"IF(CURRENT_BUDGETS>=M30,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M30-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M38","v":0},null,null,204,204,153,0,0,0]
[null,null,null,{"$f":"'0 - Input Sheet'!M39","v":0},1,null,27,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G31-1,0)","v":{"$error":"#REF!"}},null,28,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J31,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J31-1),0),\"\")","v":""},null,28,{"$f":"IF(CURRENT_BUDGETS>=M31,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M31-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M39","v":0},null,null,153,153,0,0,0]
["Analysis period:",25,null,{"$f":"'0 - Input Sheet'!M40","v":0},1,null,28,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G32-1,0)","v":{"$error":"#REF!"}},null,29,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J32,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J32-1),0),\"\")","v":""},null,29,{"$f":"IF(CURRENT_BUDGETS>=M32,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M32-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M40","v":0},null,null,0,0,0,0]
["Start Year:",2012,null,{"$f":"'0 - Input Sheet'!M41","v":0},1,null,29,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G33-1,0)","v":{"$error":"#REF!"}},null,30,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J33,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J33-1),0),\"\")","v":""},null,30,{"$f":"IF(CURRENT_BUDGETS>=M33,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M33-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M41","v":0},null,null,0,0,0]
["condition bands:",3,null,{"$f":"'0 - Input Sheet'!M42","v":0},1,null,30,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G34-1,0)","v":{"$error":"#REF!"}},null,31,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J34,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J34-1),0),\"\")","v":""},null,31,{"$f":"IF(CURRENT_BUDGETS>=M34,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M34-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M42","v":0},null,null,0,0]
["treatment types:",2,null,{"$f":"'0 - Input Sheet'!M43","v":0},1,null,31,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G35-1,0)","v":{"$error":"#REF!"}},null,32,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J35,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J35-1),0),\"\")","v":""},null,32,{"$f":"IF(CURRENT_BUDGETS>=M35,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M35-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M43","v":0},null,null,0]
["asset groups:",1,null,{"$f":"'0 - Input Sheet'!M44","v":0},1,null,32,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G36-1,0)","v":{"$error":"#REF!"}},null,33,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J36,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J36-1),0),\"\")","v":""},null,33,{"$f":"IF(CURRENT_BUDGETS>=M36,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M36-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M44","v":0},null,null,{"$f":"AH4 & \",\" & AH15 &  \",\" &AH26","v":"0,128,0"},{"$f":"AI4 & \",\" & AI15 &  \",\" &AI26","v":"0,128,0"},"0,128,0","0,128,0","0,128,0","0,128,0","0,128,0","0,128,0"]
["treatment strategies:",1,null,{"$f":"'0 - Input Sheet'!M45","v":0},1,null,33,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G37-1,0)","v":{"$error":"#REF!"}},null,34,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J37,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J37-1),0),\"\")","v":""},null,34,{"$f":"IF(CURRENT_BUDGETS>=M37,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M37-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M45","v":0},null,null,{"$f":"AH5 & \",\" & AH16 &  \",\" &AH27","v":"51,153,102"},"51,153,102","0,255,0","0,255,0","0,255,0","0,255,0","0,255,0","255,255,0"]
["treatment steps:",2,null,{"$f":"'0 - Input Sheet'!M46","v":0},1,null,34,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G38-1,0)","v":{"$error":"#REF!"}},null,35,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J38,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J38-1),0),\"\")","v":""},null,35,{"$f":"IF(CURRENT_BUDGETS>=M38,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M38-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M46","v":0},null,null,"0,255,0","0,255,0","153,204,0","153,204,0","153,204,0","255,255,0","255,255,0","255,0,0"]
["budgets",1,null,{"$f":"'0 - Input Sheet'!M47","v":0},1,null,35,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G39-1,0)","v":{"$error":"#REF!"}},null,36,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J39,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J39-1),0),\"\")","v":""},null,36,{"$f":"IF(CURRENT_BUDGETS>=M39,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M39-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M47","v":0},null,null,"153,204,0","153,204,0","255,255,204","255,255,153","255,255,0","255,204,0","255,0,0"]
["transition matrix",1,null,{"$f":"'0 - Input Sheet'!M48","v":0},1,null,36,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G40-1,0)","v":{"$error":"#REF!"}},null,37,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J40,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J40-1),0),\"\")","v":""},null,37,{"$f":"IF(CURRENT_BUDGETS>=M40,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M40-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M48","v":0},null,null,"255,255,204","255,255,204","255,255,153","255,255,0","255,204,0","255,0,0"]
["performance targets",1,null,{"$f":"'0 - Input Sheet'!M49","v":0},1,null,37,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G41-1,0)","v":{"$error":"#REF!"}},null,38,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J41,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J41-1),0),\"\")","v":""},null,38,{"$f":"IF(CURRENT_BUDGETS>=M41,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M41-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M49","v":0},null,null,"255,255,153","255,255,153","255,255,0","255,204,0","255,0,0"]
["perftargetoptions",4,null,{"$f":"'0 - Input Sheet'!M50","v":0},1,null,38,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G42-1,0)","v":{"$error":"#REF!"}},null,39,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J42,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J42-1),0),\"\")","v":""},null,39,{"$f":"IF(CURRENT_BUDGETS>=M42,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M42-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M50","v":0},null,null,"255,255,0","255,255,0","255,204,0","255,0,0"]
["cat1 & cat2 visible",true,null,{"$f":"'0 - Input Sheet'!M51","v":0},1,null,39,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G43-1,0)","v":{"$error":"#REF!"}},null,40,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J43,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J43-1),0),\"\")","v":""},null,40,{"$f":"IF(CURRENT_BUDGETS>=M43,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M43-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M51","v":0},null,null,"255,204,0","255,204,0","255,0,0"]
[null,null,null,{"$f":"'0 - Input Sheet'!M52","v":0},1,null,40,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G44-1,0)","v":{"$error":"#REF!"}},null,41,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J44,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J44-1),0),\"\")","v":""},null,41,{"$f":"IF(CURRENT_BUDGETS>=M44,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M44-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M52","v":0},null,null,"255,102,0","255,0,0"]
[null,null,null,{"$f":"'0 - Input Sheet'!M53","v":0},1,null,41,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G45-1,0)","v":{"$error":"#REF!"}},null,42,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J45,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J45-1),0),\"\")","v":""},null,42,{"$f":"IF(CURRENT_BUDGETS>=M45,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M45-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M53","v":0},null,null,"255,0,0"]
[null,null,null,{"$f":"'0 - Input Sheet'!M54","v":0},1,null,42,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G46-1,0)","v":{"$error":"#REF!"}},null,43,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J46,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J46-1),0),\"\")","v":""},null,43,{"$f":"IF(CURRENT_BUDGETS>=M46,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M46-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M54","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M55","v":0},1,null,43,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G47-1,0)","v":{"$error":"#REF!"}},null,44,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J47,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J47-1),0),\"\")","v":""},null,44,{"$f":"IF(CURRENT_BUDGETS>=M47,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M47-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M55","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M56","v":0},1,null,44,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G48-1,0)","v":{"$error":"#REF!"}},null,45,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J48,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J48-1),0),\"\")","v":""},null,45,{"$f":"IF(CURRENT_BUDGETS>=M48,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M48-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M56","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M57","v":0},1,null,45,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G49-1,0)","v":{"$error":"#REF!"}},null,46,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J49,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J49-1),0),\"\")","v":""},null,46,{"$f":"IF(CURRENT_BUDGETS>=M49,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M49-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M57","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M58","v":0},1,null,46,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G50-1,0)","v":{"$error":"#REF!"}},null,47,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J50,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J50-1),0),\"\")","v":""},null,47,{"$f":"IF(CURRENT_BUDGETS>=M50,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M50-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M58","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M59","v":0},1,null,47,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G51-1,0)","v":{"$error":"#REF!"}},null,48,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J51,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J51-1),0),\"\")","v":""},null,48,{"$f":"IF(CURRENT_BUDGETS>=M51,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M51-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M59","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M60","v":0},1,null,48,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G52-1,0)","v":{"$error":"#REF!"}},null,49,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J52,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J52-1),0),\"\")","v":""},null,49,{"$f":"IF(CURRENT_BUDGETS>=M52,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M52-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M60","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M61","v":0},1,null,49,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G53-1,0)","v":{"$error":"#REF!"}},null,50,{"$f":"IF(CURRENT_TREATMENT_STRATEGIES>=J53,OFFSET(TREATSTRAT_NAME_FIRST,CURRENT_TREATMENT_STEPS*(System!J53-1),0),\"\")","v":""},null,50,{"$f":"IF(CURRENT_BUDGETS>=M53,OFFSET(BUDGETS_NAME_FIRST,current_treatmentTypes*(System!M53-1),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M61","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M62","v":0},1,null,50,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G54-1,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M62","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M63","v":0},1,null,51,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G55-1,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M63","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M64","v":0},1,null,52,{"$f":"OFFSET('2 - Transition Matrices'!#REF!,G56-1,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M64","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M65","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M65","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M66","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M66","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M67","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M67","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M68","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M68","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M69","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M69","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M70","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M70","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M71","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M71","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M72","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M72","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M73","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M73","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M74","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M74","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M75","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M75","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M76","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M76","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M77","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M77","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M78","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M78","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M79","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M79","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M80","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M80","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M81","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M81","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M82","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M82","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M83","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M83","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M84","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M84","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M85","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M85","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M86","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M86","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M87","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M87","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M88","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M88","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M89","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M89","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M90","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M90","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M91","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M91","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M92","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M92","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M93","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M93","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M94","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M94","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M95","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M95","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M96","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M96","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M97","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M97","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M98","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M98","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M99","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M99","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M100","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M100","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M101","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M101","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M102","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M102","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M103","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M103","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M104","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M104","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M105","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M105","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M106","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M106","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M107","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M107","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M108","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M108","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M109","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M109","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M110","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M110","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M111","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M111","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M112","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M112","v":0}]
[null,null,null,{"$f":"'0 - Input Sheet'!M113","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'0 - Input Sheet'!M113","v":0}]