{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Start","Small Project","Title Sheet","Limited Access","Open Access","New Route","Bridge Rehabilitation","Bridge Replacement","Work Day Calc","CostIndex"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":42,"comments":7,"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":"Start","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,16,9]]}
["Please Enable Macros Before Using this Form"]

{"sheet":"Small Project","index":1,"n_rows":19,"n_cols":16,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,3,19,6],[0,0,0,5],[2,4,2,5],[7,3,7,6],[13,3,14,6],[16,3,16,6]]}
["Estimated Duration for Projects Less Than $1 Million               ",null,null,null,null,null,null,null,null,null,null,null,"Design Desc Range","Mean","Lower 95% CI","Upper 95% CI"]
["Item#               ",null,null,null,null,null,null,null,null,null,null,null,"BRIDGE REHAB",-28.012,-73.848929999999996,17.824936000000001]
["Current Year:",{"$f":"YEAR(TODAY())","v":2015},"Cost Index",{"$f":"IF(ISNA(VLOOKUP(B3,CostIndex!A:E,5,FALSE)),VLOOKUP((B3-1),CostIndex!A:E,5,FALSE),VLOOKUP(B3,CostIndex!A:E,5,FALSE))","v":{"$error":"#N/A"}},"Range",null,null,null,null,null,null,null,"BRIDGE REPLACEMENT",50.771987000000003,30.465602000000001,71.078372000000002]
[null,"Activity","Input Value","Mean Duration (Days)","Lower Duration (Days)","Upper Duration (Days)",null,null,null,null,null,null,"CONGESTION MITIGTN",3.5490811999999998,-49.442830000000001,56.540987999999999]
[null,"Construction Estimate",null,{"$f":"IF($C$6=\"\",0,IF(N12+N13*$C$5*$D$3+VLOOKUP($C$6,$M$2:$P$11,2,FALSE)<1,1,N12+N13*$C$5*$D$3+VLOOKUP($C$6,$M$2:$P$11,2,FALSE)))","v":0},{"$f":"IF($C$6=\"\",0,IF(O12+O13*$C$5*D3+VLOOKUP($C$6,$M$2:$P$11,3,FALSE)<1,1,O12+O13*$C$5*$D$3+VLOOKUP($C$6,$M$2:$P$11,3,FALSE)))","v":0},{"$f":"IF($C$6=\"\",0,IF(P12+P13*$C$5*$D$3+VLOOKUP($C$6,$M$2:$P$11,4,FALSE)<1,1,P12+P13*$C$5*$D$3+VLOOKUP($C$6,$M$2:$P$11,4,FALSE)))","v":0},null,null,null,null,null,null,"GUARDRAIL REPLCMNT",-12.701739999999999,-41.512219999999999,16.108746]
[null,"Select Design Project Type",null,null,null,null,null,null,null,null,null,null,"MINOR WIDENING",-3.3121520000000002,-56.089080000000003,49.464776999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,"NEW ROUTE",2.5356310999999998,-78.592010000000002,83.663274000000001]
[null,null,null,"Schedule Estimator",null,null,null,null,null,null,null,null,"PAVEMENT REHAB",-11.46744,-45.50797,22.573093]
[null,null,null,"Proposed Letting Date",{"$f":"TODAY()","v":"2015-07-22"},null,null,null,null,null,null,null,"RECONSTRUCTION",55.440976999999997,16.420342000000002,94.461612000000002]
[null,null,null,null,"Lower Range","Mean","Upper Range",null,null,null,null,null,"RESURFACING",-71.53783,-138.4699,-4.6057949999999996]
[null,null,null,"Estimated Calendar Days",{"$f":"E5","v":0},{"$f":"D5","v":0},{"$f":"F5","v":0},null,null,null,null,null,"SAFETY/SAFETY-HAZARD ELIM",0,0,0]
[null,null,null,"Estimated Completion Date",{"$f":"E11+E9+'Work Day Calc'!$N$7","v":"2015-08-21T10:00:00"},{"$f":"F11+E9+'Work Day Calc'!$N$7","v":"2015-08-21T10:00:00"},{"$f":"G11+E9+'Work Day Calc'!$N$7","v":"2015-08-21T10:00:00"},null,null,null,null,null,"Intercept",28.741365999999999,7.6043165999999998,49.878414999999997]
[null,null,null,"Estimated Working Days**",{"$f":"INDEX('Work Day Calc'!$S$3:$AD$123,IF(MONTH(E9)>10,ROUNDDOWN(YEAR(E12)-YEAR(E9),0)*12+ROUNDUP(MONTH(E12)+DAY(E12)/30,0)-12,ROUNDDOWN(YEAR(E12)-YEAR(E9),0)*12+ROUNDUP(MONTH(E12)+DAY(E12)/30,0)),IF(MONTH(E9)>10,MONTH(E9)+2-12,MONTH(E9)+2))","v":0},{"$f":"INDEX('Work Day Calc'!$S$3:$AD$123,IF(MONTH(E9)>10,ROUNDDOWN(YEAR(F12)-YEAR(E9),0)*12+ROUNDUP(MONTH(F12)+DAY(F12)/30,0)-12,ROUNDDOWN(YEAR(F12)-YEAR(E9),0)*12+ROUNDUP(MONTH(F12)+DAY(F12)/30,0)),IF(MONTH(E9)>10,MONTH(E9)+2-12,MONTH(E9)+2))","v":0},{"$f":"INDEX('Work Day Calc'!$S$3:$AD$123,IF(MONTH(E9)>10,ROUNDDOWN(YEAR(G12)-YEAR(E9),0)*12+ROUNDUP(MONTH(G12)+DAY(G12)/30,0)-12,ROUNDDOWN(YEAR(G12)-YEAR(E9),0)*12+ROUNDUP(MONTH(G12)+DAY(G12)/30,0)),IF(MONTH(E9)>10,MONTH(E9)+2-12,MONTH(E9)+2))","v":0},null,null,null,null,null,"2005 $",1.325E-4,9.7800000000000006E-5,1.672E-4]
[null,null,null,"**Adjust \"Working Day Calc\" sheet if desired; calculation attempts to account for weather.  This is only an approximation.  Because working days are not charged in December through March, the letting date can severly affect this calculation."]
[]
[]
[null,null,null,"Season Estimator"]
[null,null,null,"Estimated Seasons***",{"$f":"(E11/'Work Day Calc'!$N$7)/8","v":0},{"$f":"(F11/'Work Day Calc'!$N$7)/8","v":0},{"$f":"(G11/'Work Day Calc'!$N$7)/8","v":0}]
[null,null,null,"***This calculation does not consider the letting date; this is for informational purposes.  A full season is considered 8 months (April through November).  A 1.00 season estimate starting in August will not likely be complete within the current season."]

{"sheet":"Title Sheet","index":2,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[13,9,15,13],[16,9,23,13]]}
[]
[]
[null,null,null,null,null,null,null,null,null,"Item#:"]
[]
[null,null,null,null,null,"KTC Large Project Contract Time Determination System"]
[]
[null,"Choose Project Type:",null,null,null,null,null,null,null,"Instructions:"]
[null,null,null,null,null,null,null,null,null,"1. Fill Out Item # above."]
[null,null,null,null,null,null,null,null,null,"2. Save as Item # for Reference"]
[null,null,null,null,null,null,null,null,null,"3. Choose Project Type"]
[null,null,null,null,null,null,null,null,null,"4. Fill in Activity Fields"]
[null,null,null,null,null,null,null,null,null,"5. Save"]
[]
[null,null,null,null,null,null,null,null,null,"***Cost Indicies are updated on program initialization and valid from 2003 to current year."]
[]
[]
[null,null,null,null,null,null,null,null,null,"*Select a project type using a holistic approach.  For instance if a project is a New Route, Grade & Drain type project, that includes bridge construction, select New Route as the project type."]

{"sheet":"Limited Access","index":3,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,5],[7,3,7,6],[13,3,14,6],[16,3,16,6],[18,3,19,6],[2,4,2,5]]}
["Limited Access Duration                   "]
["Item#               ",{"$f":"IF('Title Sheet'!$J$4=0, \"\",'Title Sheet'!$J$4)","v":""}]
["Current Year:",{"$f":"YEAR(TODAY())","v":2015},"Cost Index",{"$f":"IF(ISNA(VLOOKUP(B3,CostIndex!A:E,5,FALSE)),VLOOKUP((B3-1),CostIndex!A:E,5,FALSE),VLOOKUP(B3,CostIndex!A:E,5,FALSE))","v":{"$error":"#N/A"}},"Range"]
["Construction Type","Activity","Input Value","Mean Duration (Days)","Lower Duration (Days)","Upper Duration (Days)"]
["Limited Access (>$1 million)","Construction Estimate",null,{"$f":"ROUNDUP(145.821+0.000009493*C5*D3+0.0003552*C6+0.023*C7,0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(75.965+0.000004393*C5*D3+0.0002281*C6+0.0044*C7,0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(215.677+0.00001459*C5*D3+0.0004823*C6+0.0413*C7,0)","v":{"$error":"#N/A"}}]
[null,"Roadway Excv. (CY)"]
[null,"Storm Sewer (LF)"]
[null,null,null,"Schedule Estimator"]
[null,null,null,"Proposed Letting Date",{"$f":"TODAY()","v":"2015-07-22"}]
[null,null,null,null,"Lower Range","Mean","Upper Range"]
[null,null,null,"Estimated Calendar Days",{"$f":"E5","v":{"$error":"#N/A"}},{"$f":"D5","v":{"$error":"#N/A"}},{"$f":"F5","v":{"$error":"#N/A"}}]
[null,null,null,"Estimated Completion Date",{"$f":"E11+E9+'Work Day Calc'!$N$7","v":{"$error":"#N/A"}},{"$f":"F11+E9+'Work Day Calc'!$N$7","v":{"$error":"#N/A"}},{"$f":"G11+E9+'Work Day Calc'!$N$7","v":{"$error":"#N/A"}}]
[null,null,null,"Estimated Working Days**",{"$f":"INDEX('Work Day Calc'!$S$3:$AD$123,IF(MONTH(E9)>10,ROUNDDOWN(YEAR(E12)-YEAR(E9),0)*12+ROUNDUP(MONTH(E12)+DAY(E12)/30,0)-12,ROUNDDOWN(YEAR(E12)-YEAR(E9),0)*12+ROUNDUP(MONTH(E12)+DAY(E12)/30,0)),IF(MONTH(E9)>10,MONTH(E9)+2-12,MONTH(E9)+2))","v":{"$error":"#N/A"}},{"$f":"INDEX('Work Day Calc'!$S$3:$AD$123,IF(MONTH(E9)>10,ROUNDDOWN(YEAR(F12)-YEAR(E9),0)*12+ROUNDUP(MONTH(F12)+DAY(F12)/30,0)-12,ROUNDDOWN(YEAR(F12)-YEAR(E9),0)*12+ROUNDUP(MONTH(F12)+DAY(F12)/30,0)),IF(MONTH(E9)>10,MONTH(E9)+2-12,MONTH(E9)+2))","v":{"$error":"#N/A"}},{"$f":"INDEX('Work Day Calc'!$S$3:$AD$123,IF(MONTH(E9)>10,ROUNDDOWN(YEAR(G12)-YEAR(E9),0)*12+ROUNDUP(MONTH(G12)+DAY(G12)/30,0)-12,ROUNDDOWN(YEAR(G12)-YEAR(E9),0)*12+ROUNDUP(MONTH(G12)+DAY(G12)/30,0)),IF(MONTH(E9)>10,MONTH(E9)+2-12,MONTH(E9)+2))","v":{"$error":"#N/A"}}]
[null,null,null,"**Adjust \"Working Day Calc\" sheet if desired; calculation attempts to account for weather.  This is only an approximation.  Because working days are not charged in December through March, the letting date can severly affect this calculation."]
[]
[]
[null,null,null,"Season Estimator"]
[null,null,null,"Estimated Seasons***",{"$f":"(E11/'Work Day Calc'!$N$7)/8","v":{"$error":"#N/A"}},{"$f":"(F11/'Work Day Calc'!$N$7)/8","v":{"$error":"#N/A"}},{"$f":"(G11/'Work Day Calc'!$N$7)/8","v":{"$error":"#N/A"}}]
[null,null,null,"***This calculation does not consider the letting date; this is for informational purposes.  A full season is considered 8 months (April through November).  A 1.00 season estimate starting in August will not likely be complete within the current season."]

{"sheet":"Open Access","index":4,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,3,19,6],[2,4,2,5],[0,0,0,5],[7,3,7,6],[13,3,14,6],[16,3,16,6]]}
["Open Access Duration                   "]
["Item#             ",{"$f":"IF('Title Sheet'!$J$4=0, \"\",'Title Sheet'!$J$4)","v":""}]
["Current Year:",{"$f":"YEAR(TODAY())","v":2015},"Cost Index:",{"$f":"IF(ISNA(VLOOKUP(B3,CostIndex!A:E,5,FALSE)),VLOOKUP((B3-1),CostIndex!A:E,5,FALSE),VLOOKUP(B3,CostIndex!A:E,5,FALSE))","v":{"$error":"#N/A"}},"Range"]
["Construction Type","Activity","Input Value","Mean Duration (Days)","Lower Duration (Days)","Upper Duration (Days)"]
["Open Access (>$1 million)","Construction Estimate",null,{"$f":"ROUNDUP(173.6423+0.00001188*C5*D3+0.000292*C6+0.048*C7+0.006*C8+0.036*C9+0.075*C10-0.001*C11,0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(115.429+0.000002251*C5*D3+0.0002177*C6+0.015*C7+0.004*C8+0.024*C9+0.042*C10-0.001*C11,0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(231.855+0.0000215*C5*D3+0.0003655*C6+0.082*C7+0.009*C8+0.048*C9+0.11*C10-0.0002347*C11,0)","v":{"$error":"#N/A"}}]
[null,"Roadway Excv. (CY)"]
[null,"PVC Pipe (LF)"]
[null,"Crushed Stone Base (Ton)",null,"Schedule Estimator"]
[null,"Storm Sewer (LF)",null,"Proposed Letting Date",{"$f":"TODAY()","v":"2015-07-22"}]
[null,"Culvert Pipe (LF)",null,null,"Lower Range","Mean","Upper Range"]
[null,"Pavement Striping (LF)",null,"Estimated Calendar Days",{"$f":"E5","v":{"$error":"#N/A"}},{"$f":"D5","v":{"$error":"#N/A"}},{"$f":"F5","v":{"$error":"#N/A"}}]
[null,null,null,"Estimated Completion Date",{"$f":"E11+E9+'Work Day Calc'!$N$7","v":{"$error":"#N/A"}},{"$f":"F11+E9+'Work Day Calc'!$N$7","v":{"$error":"#N/A"}},{"$f":"G11+E9+'Work Day Calc'!$N$7","v":{"$error":"#N/A"}}]
[null,null,null,"Estimated Working Days**",{"$f":"INDEX('Work Day Calc'!$S$3:$AD$123,IF(MONTH(E9)>10,ROUNDDOWN(YEAR(E12)-YEAR(E9),0)*12+ROUNDUP(MONTH(E12)+DAY(E12)/30,0)-12,ROUNDDOWN(YEAR(E12)-YEAR(E9),0)*12+ROUNDUP(MONTH(E12)+DAY(E12)/30,0)),IF(MONTH(E9)>10,MONTH(E9)+2-12,MONTH(E9)+2))","v":{"$error":"#N/A"}},{"$f":"INDEX('Work Day Calc'!$S$3:$AD$123,IF(MONTH(E9)>10,ROUNDDOWN(YEAR(F12)-YEAR(E9),0)*12+ROUNDUP(MONTH(F12)+DAY(F12)/30,0)-12,ROUNDDOWN(YEAR(F12)-YEAR(E9),0)*12+ROUNDUP(MONTH(F12)+DAY(F12)/30,0)),IF(MONTH(E9)>10,MONTH(E9)+2-12,MONTH(E9)+2))","v":{"$error":"#N/A"}},{"$f":"INDEX('Work Day Calc'!$S$3:$AD$123,IF(MONTH(E9)>10,ROUNDDOWN(YEAR(G12)-YEAR(E9),0)*12+ROUNDUP(MONTH(G12)+DAY(G12)/30,0)-12,ROUNDDOWN(YEAR(G12)-YEAR(E9),0)*12+ROUNDUP(MONTH(G12)+DAY(G12)/30,0)),IF(MONTH(E9)>10,MONTH(E9)+2-12,MONTH(E9)+2))","v":{"$error":"#N/A"}}]
[null,null,null,"**Adjust \"Working Day Calc\" sheet if desired; calculation attempts to account for weather.  This is only an approximation.  Because working days are not charged in December through March, the letting date can severly affect this calculation."]
[]
[]
[null,null,null,"Season Estimator"]
[null,null,null,"Estimated Seasons***",{"$f":"(E11/'Work Day Calc'!$N$7)/8","v":{"$error":"#N/A"}},{"$f":"(F11/'Work Day Calc'!$N$7)/8","v":{"$error":"#N/A"}},{"$f":"(G11/'Work Day Calc'!$N$7)/8","v":{"$error":"#N/A"}}]
[null,null,null,"***This calculation does not consider the letting date; this is for informational purposes.  A full season is considered 8 months (April through November).  A 1.00 season estimate starting in August will not likely be complete within the current season."]

{"sheet":"New Route","index":5,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,3,19,6],[2,4,2,5],[0,0,0,5],[7,3,7,6],[13,3,14,6],[16,3,16,6]]}
["New Route Duration                   "]
["Item#        ",{"$f":"IF('Title Sheet'!$J$4=0, \"\",'Title Sheet'!$J$4)","v":""}]
["Current Year:",{"$f":"YEAR(TODAY())","v":2015},"Cost Index",{"$f":"IF(ISNA(VLOOKUP(B3,CostIndex!A:E,5,FALSE)),VLOOKUP((B3-1),CostIndex!A:E,5,FALSE),VLOOKUP(B3,CostIndex!A:E,5,FALSE))","v":{"$error":"#N/A"}},"Range"]
["Construction Type","Activity","Input Value","Mean Duration (Days)","Lower Duration (Days)","Upper Duration (Days)"]
["New Route (>$1 million)","Construction Estimate",null,{"$f":"ROUNDUP(39.289+0.00006894*C5*D3-0.001*C6-0.018*C7-0.01*C8-0.000451*C9,0)","v":{"$error":"#N/A"}},"n/a",{"$f":"ROUNDUP(105.728+0.00008107*C5*D3-0.0001758*C6-0.011*C7-0.004*C8-0.000002272*C9,0)","v":{"$error":"#N/A"}}]
[null,"Steel Reinforcement (LB)"]
[null,"Granular Emb (CY)"]
[null,"Perforated Pipe (LF)",null,"Schedule Estimator"]
[null,"Pavement Striping (LF)",null,"Proposed Letting Date",{"$f":"TODAY()","v":"2015-07-22"}]
[null,null,null,null,"Lower Range","Mean","Upper Range"]
[null,null,null,"Estimated Calendar Days",{"$f":"E5","v":"n/a"},{"$f":"D5","v":{"$error":"#N/A"}},{"$f":"F5","v":{"$error":"#N/A"}}]
[null,null,null,"Estimated Completion Date","n/a",{"$f":"F11+E9+'Work Day Calc'!$N$7","v":{"$error":"#N/A"}},{"$f":"G11+E9+'Work Day Calc'!$N$7","v":{"$error":"#N/A"}}]
[null,null,null,"Estimated Working Days**","n/a",{"$f":"INDEX('Work Day Calc'!$S$3:$AD$123,IF(MONTH(E9)>10,ROUNDDOWN(YEAR(F12)-YEAR(E9),0)*12+ROUNDUP(MONTH(F12)+DAY(F12)/30,0)-12,ROUNDDOWN(YEAR(F12)-YEAR(E9),0)*12+ROUNDUP(MONTH(F12)+DAY(F12)/30,0)),IF(MONTH(E9)>10,MONTH(E9)+2-12,MONTH(E9)+2))","v":{"$error":"#N/A"}},{"$f":"INDEX('Work Day Calc'!$S$3:$AD$123,IF(MONTH(E9)>10,ROUNDDOWN(YEAR(G12)-YEAR(E9),0)*12+ROUNDUP(MONTH(G12)+DAY(G12)/30,0)-12,ROUNDDOWN(YEAR(G12)-YEAR(E9),0)*12+ROUNDUP(MONTH(G12)+DAY(G12)/30,0)),IF(MONTH(E9)>10,MONTH(E9)+2-12,MONTH(E9)+2))","v":{"$error":"#N/A"}}]
[null,null,null,"**Adjust \"Working Day Calc\" sheet if desired; calculation attempts to account for weather.  This is only an approximation.  Because working days are not charged in December through March, the letting date can severly affect this calculation."]
[]
[]
[null,null,null,"Season Estimator"]
[null,null,null,"Estimated Seasons***","n/a",{"$f":"(F11/'Work Day Calc'!$N$7)/8","v":{"$error":"#N/A"}},{"$f":"(G11/'Work Day Calc'!$N$7)/8","v":{"$error":"#N/A"}}]
[null,null,null,"***This calculation does not consider the letting date; this is for informational purposes.  A full season is considered 8 months (April through November).  A 1.00 season estimate starting in August will not likely be complete within the current season."]

{"sheet":"Bridge Rehabilitation","index":6,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,3,16,6],[18,3,19,6],[2,4,2,5],[0,0,0,5],[7,3,7,6],[13,3,14,6]]}
["Bridge Rehabilitation Duration                   "]
["Item#           ",{"$f":"IF('Title Sheet'!$J$4=0, \"\",'Title Sheet'!$J$4)","v":""}]
["Current Year:",{"$f":"YEAR(TODAY())","v":2015},"Cost Index",{"$f":"IF(ISNA(VLOOKUP(B3,CostIndex!A:E,5,FALSE)),VLOOKUP((B3-1),CostIndex!A:E,5,FALSE),VLOOKUP(B3,CostIndex!A:E,5,FALSE))","v":{"$error":"#N/A"}},"Range"]
["Construciton Type","Activity","Input Value","Mean Duration (Days)","Lower Duration (Days)","Upper Duration (Days)"]
["Bridge Rehabilitation","Construction Estimate",null,{"$f":"ROUNDUP(26.933+0.00005602*C5*D3,0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(4.406+0.00004919*C5*D3,0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(49.461+0.00006284*C5*D3,0)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,null,"Schedule Estimator"]
[null,null,null,"Proposed Letting Date",{"$f":"TODAY()","v":"2015-07-22"}]
[null,null,null,null,"Lower Range","Mean","Upper Range"]
[null,null,null,"Estimated Calendar Days",{"$f":"E5","v":{"$error":"#N/A"}},{"$f":"D5","v":{"$error":"#N/A"}},{"$f":"F5","v":{"$error":"#N/A"}}]
[null,null,null,"Estimated Completion Date",{"$f":"E11+E9+'Work Day Calc'!$N$7","v":{"$error":"#N/A"}},{"$f":"F11+E9+'Work Day Calc'!$N$7","v":{"$error":"#N/A"}},{"$f":"G11+E9+'Work Day Calc'!$N$7","v":{"$error":"#N/A"}}]
[null,null,null,"Estimated Working Days**",{"$f":"INDEX('Work Day Calc'!$S$3:$AD$123,IF(MONTH(E9)>10,ROUNDDOWN(YEAR(E12)-YEAR(E9),0)*12+ROUNDUP(MONTH(E12)+DAY(E12)/30,0)-12,ROUNDDOWN(YEAR(E12)-YEAR(E9),0)*12+ROUNDUP(MONTH(E12)+DAY(E12)/30,0)),IF(MONTH(E9)>10,MONTH(E9)+2-12,MONTH(E9)+2))","v":{"$error":"#N/A"}},{"$f":"INDEX('Work Day Calc'!$S$3:$AD$123,IF(MONTH(E9)>10,ROUNDDOWN(YEAR(F12)-YEAR(E9),0)*12+ROUNDUP(MONTH(F12)+DAY(F12)/30,0)-12,ROUNDDOWN(YEAR(F12)-YEAR(E9),0)*12+ROUNDUP(MONTH(F12)+DAY(F12)/30,0)),IF(MONTH(E9)>10,MONTH(E9)+2-12,MONTH(E9)+2))","v":{"$error":"#N/A"}},{"$f":"INDEX('Work Day Calc'!$S$3:$AD$123,IF(MONTH(E9)>10,ROUNDDOWN(YEAR(G12)-YEAR(E9),0)*12+ROUNDUP(MONTH(G12)+DAY(G12)/30,0)-12,ROUNDDOWN(YEAR(G12)-YEAR(E9),0)*12+ROUNDUP(MONTH(G12)+DAY(G12)/30,0)),IF(MONTH(E9)>10,MONTH(E9)+2-12,MONTH(E9)+2))","v":{"$error":"#N/A"}}]
[null,null,null,"**Adjust \"Working Day Calc\" sheet if desired; calculation attempts to account for weather.  This is only an approximation.  Because working days are not charged in December through March, the letting date can severly affect this calculation."]
[]
[]
[null,null,null,"Season Estimator"]
[null,null,null,"Estimated Seasons***",{"$f":"(E11/'Work Day Calc'!$N$7)/8","v":{"$error":"#N/A"}},{"$f":"(F11/'Work Day Calc'!$N$7)/8","v":{"$error":"#N/A"}},{"$f":"(G11/'Work Day Calc'!$N$7)/8","v":{"$error":"#N/A"}}]
[null,null,null,"***This calculation does not consider the letting date; this is for informational purposes.  A full season is considered 8 months (April through November).  A 1.00 season estimate starting in August will not likely be complete within the current season."]

{"sheet":"Bridge Replacement","index":7,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,3,16,6],[18,3,19,6],[2,4,2,5],[0,0,0,5],[7,3,7,6],[13,3,14,6]]}
["Bridge Replacement Duration                   "]
["Item#           ",{"$f":"IF('Title Sheet'!$J$4=0, \"\",'Title Sheet'!$J$4)","v":""}]
["Current Year:",{"$f":"YEAR(TODAY())","v":2015},"Cost Index",{"$f":"IF(ISNA(VLOOKUP(B3,CostIndex!A:E,5,FALSE)),VLOOKUP((B3-1),CostIndex!A:E,5,FALSE),VLOOKUP(B3,CostIndex!A:E,5,FALSE))","v":{"$error":"#N/A"}},"Range"]
["Construction Type","Activity","Input Value","Mean Duration (Days)","Lower Duration (Days)","Upper Duration (Days)"]
["Bridge Replacement-Engineers’ Estimate (>$1 million) ","Class AA Concrete (CY)",null,{"$f":"ROUNDUP(97.155+0.447*C5+0.043*C6+0.00001909*C7*D3,0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(22.585+0.249*C5+0.018*C6+0.000001208*C7*D3,0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(171.725+0.644*C5+0.068*C6+0.00003696*C7*D3,0)","v":{"$error":"#N/A"}}]
[null,"Granular Emb (CY)"]
[null,"Construction Estimate"]
[null,null,null,"Schedule Estimator"]
[null,null,null,"Proposed Letting Date",{"$f":"TODAY()","v":"2015-07-22"}]
[null,null,null,null,"Lower Range","Mean","Upper Range"]
[null,null,null,"Estimated Calendar Days",{"$f":"E5","v":{"$error":"#N/A"}},{"$f":"D5","v":{"$error":"#N/A"}},{"$f":"F5","v":{"$error":"#N/A"}}]
[null,null,null,"Estimated Completion Date",{"$f":"E11+E9+'Work Day Calc'!$N$7","v":{"$error":"#N/A"}},{"$f":"F11+E9+'Work Day Calc'!$N$7","v":{"$error":"#N/A"}},{"$f":"G11+E9+'Work Day Calc'!$N$7","v":{"$error":"#N/A"}}]
[null,null,null,"Estimated Working Days**",{"$f":"INDEX('Work Day Calc'!$S$3:$AD$123,IF(MONTH(E9)>10,ROUNDDOWN(YEAR(E12)-YEAR(E9),0)*12+ROUNDUP(MONTH(E12)+DAY(E12)/30,0)-12,ROUNDDOWN(YEAR(E12)-YEAR(E9),0)*12+ROUNDUP(MONTH(E12)+DAY(E12)/30,0)),IF(MONTH(E9)>10,MONTH(E9)+2-12,MONTH(E9)+2))","v":{"$error":"#N/A"}},{"$f":"INDEX('Work Day Calc'!$S$3:$AD$123,IF(MONTH(E9)>10,ROUNDDOWN(YEAR(F12)-YEAR(E9),0)*12+ROUNDUP(MONTH(F12)+DAY(F12)/30,0)-12,ROUNDDOWN(YEAR(F12)-YEAR(E9),0)*12+ROUNDUP(MONTH(F12)+DAY(F12)/30,0)),IF(MONTH(E9)>10,MONTH(E9)+2-12,MONTH(E9)+2))","v":{"$error":"#N/A"}},{"$f":"INDEX('Work Day Calc'!$S$3:$AD$123,IF(MONTH(E9)>10,ROUNDDOWN(YEAR(G12)-YEAR(E9),0)*12+ROUNDUP(MONTH(G12)+DAY(G12)/30,0)-12,ROUNDDOWN(YEAR(G12)-YEAR(E9),0)*12+ROUNDUP(MONTH(G12)+DAY(G12)/30,0)),IF(MONTH(E9)>10,MONTH(E9)+2-12,MONTH(E9)+2))","v":{"$error":"#N/A"}}]
[null,null,null,"**Adjust \"Working Day Calc\" sheet if desired; calculation attempts to account for weather.  This is only an approximation.  Because working days are not charged in December through March, the letting date can severly affect this calculation."]
[]
[]
[null,null,null,"Season Estimator"]
[null,null,null,"Estimated Seasons***",{"$f":"(E11/'Work Day Calc'!$N$7)/8","v":{"$error":"#N/A"}},{"$f":"(F11/'Work Day Calc'!$N$7)/8","v":{"$error":"#N/A"}},{"$f":"(G11/'Work Day Calc'!$N$7)/8","v":{"$error":"#N/A"}}]
[null,null,null,"***This calculation does not consider the letting date; this is for informational purposes.  A full season is considered 8 months (April through November).  A 1.00 season estimate starting in August will not likely be complete within the current season."]

{"sheet":"Work Day Calc","index":8,"n_rows":122,"n_cols":30,"rows_kept":122,"cut":false,"hidden":false,"merged":[[0,0,0,9],[0,15,0,16]]}
["Kentucky Adjusted Working Days",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calendar (Eqn)",null,null,"Starting Month (First Month After NTP--Approx 2 months after letting)"]
["Month","Calendar Days","Working Days Per Week","Start Working Days","Adjusted Working Days (AWD)","Spec & Weather Adjusted Working Days","  ","Rainfall Issues","Temp Issues","Adverse Days",null,null,null,null,null,"Year","Months","# WD/Mo",1,2,3,4,5,6,7,8,9,10,11,12]
["January",31,5,{"$f":"ROUND(B3/7*C3,0)","v":22},{"$f":"ROUND(B3/7*C3-J3,0)","v":11},0,null,0.2,0.3,{"$f":"D3*H3+D3*I3","v":11},null,null,null,null,null,1,1,{"$f":"F3","v":0}]
["February",28,5,{"$f":"ROUND(B4/7*C4,0)","v":20},{"$f":"ROUND(B4/7*C4-J4,0)","v":10},0,null,0.25,0.23,{"$f":"D4*H4+D4*I4","v":9.6000000000000014},null,null,null,null,null,1,2,0,{"$f":"R3","v":0}]
["March",31,5,22,13,0,null,0.33,0.08,9.0200000000000014,null,null,null,null,null,1,3,0,{"$f":"S4+$R4","v":0},{"$f":"R4","v":0}]
["April",30,5,21,15,{"$f":"Table2[[#This Row],[Adjusted Working Days (AWD)]]","v":15},null,0.3,0,6.3,null,null,"Average",null,null,1,4,15,{"$f":"S5+$R5","v":0},{"$f":"T5+$R5","v":0},{"$f":"R5","v":0}]
["May",31,6,27,19,{"$f":"Table2[[#This Row],[Adjusted Working Days (AWD)]]","v":19},null,0.28000000000000003,0,7.5600000000000005,null,null,"Days/Month",{"$f":"AVERAGE(Table2[Calendar Days])","v":30.416666666666668},null,1,5,19,{"$f":"S6+R6","v":15},15,{"$f":"U6+$R6","v":15},{"$f":"R6","v":15}]
["June",30,6,26,19,{"$f":"Table2[[#This Row],[Adjusted Working Days (AWD)]]","v":19},null,0.25,0,6.5,null,null,"WD/Month",{"$f":"AVERAGE(Table2[Start Working Days])","v":23.583333333333332},null,1,6,19,34,34,34,{"$f":"V7+$R7","v":34},{"$f":"R7","v":19}]
["July",31,6,27,20,{"$f":"Table2[[#This Row],[Adjusted Working Days (AWD)]]","v":20},null,0.23,0,6.21,null,null,"AWD/Month",{"$f":"AVERAGE(Table2[Adjusted Working Days (AWD)])","v":15.833333333333334},null,1,7,20,53,53,53,53,{"$f":"W8+$R8","v":38},{"$f":"R8","v":19}]
["August",31,6,27,20,{"$f":"Table2[[#This Row],[Adjusted Working Days (AWD)]]","v":20},null,0.23,0,6.21,null,null,null,null,null,1,8,20,73,73,73,73,58,{"$f":"X9+$R9","v":39},{"$f":"R9","v":20}]
["September",30,6,26,19,{"$f":"Table2[[#This Row],[Adjusted Working Days (AWD)]]","v":19},null,0.25,0,6.5,null,null,null,null,null,1,9,19,93,93,93,93,78,59,{"$f":"Y10+$R10","v":40},{"$f":"R10","v":20}]
["October",31,5,22,17,{"$f":"Table2[[#This Row],[Adjusted Working Days (AWD)]]","v":17},null,0.25,0,5.5,null,null,null,null,null,1,10,17,112,112,112,112,97,78,59,{"$f":"Z11+$R11","v":39},{"$f":"R11","v":19}]
["November",30,5,21,15,{"$f":"Table2[[#This Row],[Adjusted Working Days (AWD)]]","v":15},null,0.25,0.05,6.3,null,null,null,null,null,1,11,15,129,129,129,129,114,95,76,56,{"$f":"AA12+$R12","v":36},{"$f":"R12","v":17}]
["December",31,5,22,12,0,null,0.23,0.25,10.56,null,null,null,null,null,1,12,0,144,144,144,144,129,110,91,71,51,{"$f":"AB13+$R13","v":32},{"$f":"R13","v":15}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,1,{"$f":"F3","v":0},144,144,144,144,129,110,91,71,51,32,{"$f":"AC14+$R14","v":15},{"$f":"R14","v":0}]
["**Criteria: Moderate or greater rainfall/snow, temperatures less than 32 degrees (Source: weatherspark.com)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,0,144,144,144,144,129,110,91,71,51,32,15,{"$f":"AD15+$R15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,3,0,144,144,144,144,129,110,91,71,51,32,15,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,4,15,144,144,144,144,129,110,91,71,51,32,15,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,5,19,159,159,159,159,144,125,106,86,66,47,30,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,6,19,178,178,178,178,163,144,125,105,85,66,49,34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,7,20,197,197,197,197,182,163,144,124,104,85,68,53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,8,20,217,217,217,217,202,183,164,144,124,105,88,73]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,9,19,237,237,237,237,222,203,184,164,144,125,108,93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,10,17,256,256,256,256,241,222,203,183,163,144,127,112]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,11,15,273,273,273,273,258,239,220,200,180,161,144,129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,12,0,288,288,288,288,273,254,235,215,195,176,159,144]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,1,{"$f":"F3","v":0},288,288,288,288,273,254,235,215,195,176,159,144]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,2,0,288,288,288,288,273,254,235,215,195,176,159,144]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3,0,288,288,288,288,273,254,235,215,195,176,159,144]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,4,15,288,288,288,288,273,254,235,215,195,176,159,144]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,5,19,303,303,303,303,288,269,250,230,210,191,174,159]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,6,19,322,322,322,322,307,288,269,249,229,210,193,178]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,7,20,341,341,341,341,326,307,288,268,248,229,212,197]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,8,20,361,361,361,361,346,327,308,288,268,249,232,217]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,9,19,381,381,381,381,366,347,328,308,288,269,252,237]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,10,17,400,400,400,400,385,366,347,327,307,288,271,256]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,11,15,417,417,417,417,402,383,364,344,324,305,288,273]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,12,0,432,{"$f":"T37+$R37","v":432},432,432,417,398,379,359,339,320,303,288]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,1,{"$f":"F3","v":0},{"$f":"S38+R38","v":432},432,{"$f":"U38+$R38","v":432},432,417,398,379,359,339,320,303,288]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,2,0,432,432,432,{"$f":"V39+$R39","v":432},417,398,379,359,339,320,303,288]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,3,0,432,432,432,432,{"$f":"W40+$R40","v":417},398,379,359,339,320,303,288]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,4,15,432,432,432,432,417,{"$f":"X41+$R41","v":398},379,359,339,320,303,288]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,5,19,447,447,447,447,432,413,{"$f":"Y42+$R42","v":394},374,354,335,318,303]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,6,19,466,466,466,466,451,432,413,{"$f":"Z43+$R43","v":393},373,354,337,322]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,7,20,485,485,485,485,470,451,432,412,{"$f":"AA44+$R44","v":392},373,356,341]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,8,20,505,505,505,505,490,471,452,432,412,{"$f":"AB45+$R45","v":393},376,361]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,9,19,525,525,525,525,510,491,472,452,432,413,{"$f":"AC46+$R46","v":396},381]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,10,17,544,544,544,544,529,510,491,471,451,432,415,{"$f":"AD47+$R47","v":400}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,11,15,561,561,561,561,546,527,508,488,468,449,432,417]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,12,0,576,576,576,576,561,542,523,503,483,464,447,432]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,1,{"$f":"F3","v":0},576,576,576,576,561,542,523,503,483,464,447,432]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,2,0,576,576,576,576,561,542,523,503,483,464,447,432]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,3,0,576,576,576,576,561,542,523,503,483,464,447,432]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,4,15,576,576,576,576,561,542,523,503,483,464,447,432]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,19,591,591,591,591,576,557,538,518,498,479,462,447]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,6,19,610,610,610,610,595,576,557,537,517,498,481,466]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,7,20,629,629,629,629,614,595,576,556,536,517,500,485]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,8,20,649,649,649,649,634,615,596,576,556,537,520,505]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,9,19,669,669,669,669,654,635,616,596,576,557,540,525]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,10,17,688,688,688,688,673,654,635,615,595,576,559,544]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,11,15,705,705,705,705,690,671,652,632,612,593,576,561]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,12,0,720,720,720,720,705,686,667,647,627,608,591,576]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,1,{"$f":"F3","v":0},720,720,720,720,705,686,667,647,627,608,591,576]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,2,0,720,720,720,720,705,686,667,647,627,608,591,576]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,3,0,720,720,720,720,705,686,667,647,627,608,591,576]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,4,15,720,720,720,720,705,686,667,647,627,608,591,576]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,5,19,735,735,735,735,720,701,682,662,642,623,606,591]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,6,19,754,754,754,754,739,720,701,681,661,642,625,610]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,7,20,773,773,773,773,758,739,720,700,680,661,644,629]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,8,20,793,{"$f":"T69+$R69","v":793},793,793,778,759,740,720,700,681,664,649]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,9,19,{"$f":"S70+R70","v":813},813,{"$f":"U70+$R70","v":813},813,798,779,760,740,720,701,684,669]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,10,17,832,832,832,{"$f":"V71+$R71","v":832},817,798,779,759,739,720,703,688]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,11,15,849,849,849,849,{"$f":"W72+$R72","v":834},815,796,776,756,737,720,705]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,12,0,864,864,864,864,849,{"$f":"X73+$R73","v":830},811,791,771,752,735,720]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1,{"$f":"F3","v":0},864,864,864,864,849,830,{"$f":"Y74+$R74","v":811},791,771,752,735,720]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,2,0,864,864,864,864,849,830,811,{"$f":"Z75+$R75","v":791},771,752,735,720]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,3,0,864,864,864,864,849,830,811,791,{"$f":"AA76+$R76","v":771},752,735,720]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,4,15,864,864,864,864,849,830,811,791,771,{"$f":"AB77+$R77","v":752},735,720]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,5,19,879,879,879,879,864,845,826,806,786,767,{"$f":"AC78+$R78","v":750},735]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,6,19,898,898,898,898,883,864,845,825,805,786,769,{"$f":"AD79+$R79","v":754}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,7,20,917,917,917,917,902,883,864,844,824,805,788,773]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,8,20,937,937,937,937,922,903,884,864,844,825,808,793]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,9,19,957,957,957,957,942,923,904,884,864,845,828,813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,10,17,976,976,976,976,961,942,923,903,883,864,847,832]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,11,15,993,993,993,993,978,959,940,920,900,881,864,849]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,12,0,1008,1008,1008,1008,993,974,955,935,915,896,879,864]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,1,{"$f":"F3","v":0},1008,1008,1008,1008,993,974,955,935,915,896,879,864]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,2,0,1008,1008,1008,1008,993,974,955,935,915,896,879,864]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,3,0,1008,1008,1008,1008,993,974,955,935,915,896,879,864]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,4,15,1008,1008,1008,1008,993,974,955,935,915,896,879,864]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,5,19,1023,1023,1023,1023,1008,989,970,950,930,911,894,879]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,6,19,1042,1042,1042,1042,1027,1008,989,969,949,930,913,898]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,7,20,1061,1061,1061,1061,1046,1027,1008,988,968,949,932,917]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,8,20,1081,1081,1081,1081,1066,1047,1028,1008,988,969,952,937]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,9,19,1101,1101,1101,1101,1086,1067,1048,1028,1008,989,972,957]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,10,17,1120,1120,1120,1120,1105,1086,1067,1047,1027,1008,991,976]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,11,15,1137,1137,1137,1137,1122,1103,1084,1064,1044,1025,1008,993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,12,0,1152,1152,1152,1152,1137,1118,1099,1079,1059,1040,1023,1008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,1,{"$f":"F3","v":0},1152,1152,1152,1152,1137,1118,1099,1079,1059,1040,1023,1008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,2,0,1152,1152,1152,1152,1137,1118,1099,1079,1059,1040,1023,1008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,3,0,1152,1152,1152,1152,1137,1118,1099,1079,1059,1040,1023,1008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,4,15,1152,{"$f":"T101+$R101","v":1152},1152,1152,1137,1118,1099,1079,1059,1040,1023,1008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,5,19,{"$f":"S102+R102","v":1167},1167,{"$f":"U102+$R102","v":1167},1167,1152,1133,1114,1094,1074,1055,1038,1023]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,6,19,1186,1186,1186,{"$f":"V103+$R103","v":1186},1171,1152,1133,1113,1093,1074,1057,1042]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,7,20,1205,1205,1205,1205,{"$f":"W104+$R104","v":1190},1171,1152,1132,1112,1093,1076,1061]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,8,20,1225,1225,1225,1225,1210,{"$f":"X105+$R105","v":1191},1172,1152,1132,1113,1096,1081]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,9,19,1245,1245,1245,1245,1230,1211,{"$f":"Y106+$R106","v":1192},1172,1152,1133,1116,1101]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,10,17,1264,1264,1264,1264,1249,1230,1211,{"$f":"Z107+$R107","v":1191},1171,1152,1135,1120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,11,15,1281,1281,1281,1281,1266,1247,1228,1208,{"$f":"AA108+$R108","v":1188},1169,1152,1137]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,12,0,1296,1296,1296,1296,1281,1262,1243,1223,1203,{"$f":"AB109+$R109","v":1184},1167,1152]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,1,{"$f":"F3","v":0},1296,1296,1296,1296,1281,1262,1243,1223,1203,1184,{"$f":"AC110+$R110","v":1167},1152]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,2,0,1296,1296,1296,1296,1281,1262,1243,1223,1203,1184,1167,{"$f":"AD111+$R111","v":1152}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,3,0,1296,1296,1296,1296,1281,1262,1243,1223,1203,1184,1167,1152]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,4,15,1296,1296,1296,1296,1281,1262,1243,1223,1203,1184,1167,1152]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,5,19,1311,1311,1311,1311,1296,1277,1258,1238,1218,1199,1182,1167]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,6,19,1330,1330,1330,1330,1315,1296,1277,1257,1237,1218,1201,1186]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,7,20,1349,1349,1349,1349,1334,1315,1296,1276,1256,1237,1220,1205]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,8,20,1369,1369,1369,1369,1354,1335,1316,1296,1276,1257,1240,1225]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,9,19,1389,1389,1389,1389,1374,1355,1336,1316,1296,1277,1260,1245]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,10,17,1408,1408,1408,1408,1393,1374,1355,1335,1315,1296,1279,1264]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,11,15,1425,1425,1425,1425,1410,1391,1372,1352,1332,1313,1296,1281]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,12,0,1440,1440,1440,1440,1425,1406,1387,1367,1347,1328,1311,1296]

{"sheet":"CostIndex","index":9,"n_rows":333,"n_cols":5,"rows_kept":333,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Average","Adj. to 2005 $"]
[null,null,null,{"$f":"AVERAGE(C113:C116)","v":{"$error":"#DIV/0!"}},{"$f":"D113/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C117:C120)","v":{"$error":"#DIV/0!"}},{"$f":"D117/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C121:C124)","v":{"$error":"#DIV/0!"}},{"$f":"D121/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C125:C128)","v":{"$error":"#DIV/0!"}},{"$f":"D125/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C129:C132)","v":{"$error":"#DIV/0!"}},{"$f":"D129/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C133:C136)","v":{"$error":"#DIV/0!"}},{"$f":"D133/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C137:C140)","v":{"$error":"#DIV/0!"}},{"$f":"D137/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C141:C144)","v":{"$error":"#DIV/0!"}},{"$f":"D141/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C145:C148)","v":{"$error":"#DIV/0!"}},{"$f":"D145/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C149:C152)","v":{"$error":"#DIV/0!"}},{"$f":"D149/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C153:C156)","v":{"$error":"#DIV/0!"}},{"$f":"D153/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C157:C160)","v":{"$error":"#DIV/0!"}},{"$f":"D157/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C161:C164)","v":{"$error":"#DIV/0!"}},{"$f":"D161/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C165:C168)","v":{"$error":"#DIV/0!"}},{"$f":"D165/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C169:C172)","v":{"$error":"#DIV/0!"}},{"$f":"D169/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C173:C176)","v":{"$error":"#DIV/0!"}},{"$f":"D173/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C177:C180)","v":{"$error":"#DIV/0!"}},{"$f":"D177/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C181:C184)","v":{"$error":"#DIV/0!"}},{"$f":"D181/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C185:C188)","v":{"$error":"#DIV/0!"}},{"$f":"D185/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C189:C192)","v":{"$error":"#DIV/0!"}},{"$f":"D189/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C193:C196)","v":{"$error":"#DIV/0!"}},{"$f":"D193/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C197:C200)","v":{"$error":"#DIV/0!"}},{"$f":"D197/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C201:C204)","v":{"$error":"#DIV/0!"}},{"$f":"D201/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C205:C208)","v":{"$error":"#DIV/0!"}},{"$f":"D205/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C209:C212)","v":{"$error":"#DIV/0!"}},{"$f":"D209/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C213:C216)","v":{"$error":"#DIV/0!"}},{"$f":"D213/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C217:C220)","v":{"$error":"#DIV/0!"}},{"$f":"D217/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C221:C224)","v":{"$error":"#DIV/0!"}},{"$f":"D221/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C225:C228)","v":{"$error":"#DIV/0!"}},{"$f":"D225/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C229:C232)","v":{"$error":"#DIV/0!"}},{"$f":"D229/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C233:C236)","v":{"$error":"#DIV/0!"}},{"$f":"D233/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C237:C240)","v":{"$error":"#DIV/0!"}},{"$f":"D237/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C241:C244)","v":{"$error":"#DIV/0!"}},{"$f":"D241/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C245:C248)","v":{"$error":"#DIV/0!"}},{"$f":"D245/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C249:C252)","v":{"$error":"#DIV/0!"}},{"$f":"D249/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C253:C256)","v":{"$error":"#DIV/0!"}},{"$f":"D253/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C257:C260)","v":{"$error":"#DIV/0!"}},{"$f":"D257/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C261:C264)","v":{"$error":"#DIV/0!"}},{"$f":"D261/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C265:C268)","v":{"$error":"#DIV/0!"}},{"$f":"D265/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C269:C272)","v":{"$error":"#DIV/0!"}},{"$f":"D269/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C273:C276)","v":{"$error":"#DIV/0!"}},{"$f":"D273/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C277:C280)","v":{"$error":"#DIV/0!"}},{"$f":"D277/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C281:C284)","v":{"$error":"#DIV/0!"}},{"$f":"D281/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C285:C288)","v":{"$error":"#DIV/0!"}},{"$f":"D285/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C289:C292)","v":{"$error":"#DIV/0!"}},{"$f":"D289/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C293:C296)","v":{"$error":"#DIV/0!"}},{"$f":"D293/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C297:C300)","v":{"$error":"#DIV/0!"}},{"$f":"D297/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C301:C304)","v":{"$error":"#DIV/0!"}},{"$f":"D301/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C305:C308)","v":{"$error":"#DIV/0!"}},{"$f":"D305/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C309:C312)","v":{"$error":"#DIV/0!"}},{"$f":"D309/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C313:C316)","v":{"$error":"#DIV/0!"}},{"$f":"D313/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C317:C320)","v":{"$error":"#DIV/0!"}},{"$f":"D317/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C321:C324)","v":{"$error":"#DIV/0!"}},{"$f":"D321/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C325:C328)","v":{"$error":"#DIV/0!"}},{"$f":"D325/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C329:C332)","v":{"$error":"#DIV/0!"}},{"$f":"D329/$D$121","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,{"$f":"AVERAGE(C333:C336)","v":{"$error":"#DIV/0!"}},{"$f":"D333/$D$121","v":{"$error":"#DIV/0!"}}]