{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Disclaimer","Calculations"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,3,10,8],[11,3,25,8],[21,10,25,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Disclaimer"]
[]
[null,null,null,"This Design Calculation Spreadsheet is provided \"as-is\" without warranty of any kind. The Montana Department of Transportation makes no representations or warranties whatsoever with respect to the accuracy or completeness of this tool and assumes no responsibility for the suitability of this tool for a particular purpose; and MDT will not be liable for any damages incurred as a result of errors in this tool. \n\nBy selecting Accept, you are agreeing to these terms and conditions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"WARNING: \nFor the tool to work properly, please make sure you click on \"Enable Content/Macros\" if the security warning appears."]

{"sheet":"Calculations","index":1,"n_rows":241,"n_cols":22,"rows_kept":241,"cut":false,"hidden":true,"merged":[[53,16,53,17],[54,16,54,17],[55,16,55,17],[49,16,49,17],[46,16,46,17],[47,16,47,17],[48,16,48,17],[50,16,50,17],[51,16,51,17],[52,16,52,17],[45,16,45,17],[40,16,40,17],[41,16,41,17],[42,16,42,17],[43,16,43,17],[44,16,44,17]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vertical Curve K-value Calcs."]
[null,"Sum",null,null,null,null,null,null,null,null,null,null,null,45,"K","Grade","A","L","K",null,"Sum"]
[null,null,null,"Subtract",null,"Average",null,"Interpolation Calc.",null,null,null,"Grade Calcs.",null,"Crest",61,0.5]
[null,null,null,3427,null,13,null,"Begin",19224.349999999999,0,null,"Sta Start",14.3,"Sag",79,null,{"$f":"ABS(P5-P3)","v":1.5029999999999999},1400,{"$f":"R4/Q4","v":931.47039254823687},"C"]
[null,null,null,1832,null,13.7,null,"Middle",19249.82,{"$f":"((I5-I4)*(J6-J4)/(I6-I4))+J4","v":1.4483111566019038},null,"Elev Start",2945.75,null,null,-1.0029999999999999]
[null,null,null,{"$f":"D4-D5","v":1595},null,{"$f":"(F4+F5)/2","v":13.35},null,"End",19312.28,5,null,"Sta End",40.32,"45 (3%)",null,null,{"$f":"ABS(P7-P5)","v":3.6739999999999995},500,{"$f":"R6/Q6","v":136.09145345672295},"S"]
[null,null,null,null,null,null,null,null,null,null,null,"Elev End",2938.36,"Crest",67,2.6709999999999998,null," "]
[null,null,null,"Multiply",null,null,null,"Divide",null,null,null,"Grade",{"$f":"(M7-M5)/(M6-M4)","v":-0.28401229823212426},"Sag",83,null,{"$f":"ABS(P9-P7)","v":5.4789999999999992},840,{"$f":"R8/Q8","v":153.31264829348424},"C"]
[null,null,null,28,5,7855,null,3400,560,null,null,null,null,null,null,-2.8079999999999998]
[null,null,null,0.2,6.2E-2,1.4E-2,null,9,27,null,null,null,null,60,null,null,{"$f":"ABS(P11-P9)","v":3.6159999999999997},500,{"$f":"R10/Q10","v":138.27433628318585},"S"]
[null,null,null,{"$f":"D9*D10","v":5.6000000000000005},{"$f":"E9*E10","v":0.31},{"$f":"F9*F10","v":109.97},null,{"$f":"H9/H10","v":377.77777777777777},{"$f":"I9/I10","v":20.74074074074074},null,null,null,null,"Crest",151,0.80800000000000005]
[null,null,null,null,null,null,null,null,null,null,"PGL Vertical Curve Elev. Calcs.",null,null,"Sag",136,null,{"$f":"ABS(P13-P11)","v":0.80600000000000005},500,{"$f":"R12/Q12","v":620.3473945409429},"S"]
[null,null,null,null,null,null,null,null,null,null,"VPC Sta",40582,null,null,null,1.6140000000000001]
[null,null,null,"Typ. Sect. Quantity Calcs",null,null,null,null,null,null,"VPC Elev",2953.84,null,"60 (3%)",null,null,{"$f":"ABS(P15-P13)","v":3.3840000000000003},450,{"$f":"R14/Q14","v":132.97872340425531},"S"]
[null,null,null,null,"English",null,null,null,null,null,"G1 (%)",2,null,"Crest",166,-1.77]
[null,null,null,"Plant Mix",20.7,{"$f":"E16*3855/2000","v":39.899250000000002},"% AC",null,null,null,"G2 (%)",-1.7170000000000001,null,"Sag",144,null,{"$f":"ABS(P17-P15)","v":5.55},700,{"$f":"R16/Q16","v":126.12612612612612},"C"]
[null,null,null,"AC","---",{"$f":"ROUND(F16,1)*(G17/100)","v":2.4737999999999998},6.2,null,null,null,"L",316,null,null,null,3.78]
[null,null,null,"Seal",289,{"$f":"E18*0.42*8.5/2000","v":0.51586500000000002},null,null,null,null,"X Sta",40625,null," @SG",null,null,{"$f":"ABS(P19-P17)","v":3.4699999999999998},460,{"$f":"R18/Q18","v":132.56484149855908},"S"]
[null,null,null,"Fog Seal",0,{"$f":"E19*0.075","v":0},null,null,null,null,"X",{"$f":"L18-L13","v":43},"@ SG","w/ super",null,0.31]
[null,null,null,null,null,null,null,null,null,null,"PGL - X Elev",{"$f":"(L19^2)*((L16-L15)/(200*L17))+(L15/100)*L19+L14","v":2954.5912542246838},{"$f":"L20-M23","v":2954.4512542246839},{"$f":"L20-M23+M22*((N24/100)-0.02)","v":2954.4512542246839},null,null,{"$f":"ABS(P21-P19)","v":1.3},400,{"$f":"R20/Q20","v":307.69230769230768},"C"]
[null,null,null,"Surfacing Quantities Calcs",null,null,null,null,null,null,null,null,null,null,null,1.61]
[null,null,null,"Length","Typ 1 Qtys","Typ 2 Qtys","Qtys","Avg Qtys",null,null,null,"Super Width",12,null,null,null,{"$f":"ABS(P23-P21)","v":3.4400000000000004},550,210,"S"]
[null,null,null,14.7699,267,311,{"$f":"$D$23*E23","v":3943.5632999999998},{"$f":"$D$23*((E23+F23)/2)","v":4268.5010999999995},"Cover",null,null,"Section Depth",0.14000000000000001,null,null,-1.83]
[null,null,null,null,59.9,39.9,884.71700999999996,737.01801,"Plant Mix",null,null,"Superelevation (%)",null,2,null,null,{"$f":"ABS(P25-P23)","v":4.62},650,{"$f":"R24/Q24","v":140.69264069264068},"C"]
[null,null,null,null,0,0,0,0,"CAC",null,null,null,null,null,null,2.79]
[null,null,null,null,0,0,0,0,"Spec. Borrow",null,"PGL Elev. Calcs on Tangents",null,null,null,null,null,{"$f":"ABS(P27-P25)","v":2.4900000000000002},400,{"$f":"R26/Q26","v":160.64257028112448},"S"]
[null,null,null,null,0,0,0,0,"Shldr Gravel",null,"VPI Sta",40090,null,null,null,0.3]
[null,null,null,null,1.24,1.26,18.314675999999999,18.462375000000002,"AC",null,"VPI Elev",2944,null,null,null,null,{"$f":"ABS(P29-P27)","v":2.7800000000000002},400,{"$f":"R28/Q28","v":143.88489208633092},"C"]
[null,null,null,null,0.72,0.8,10.634328,11.225123999999999,"Seal",null,"G (%)",2,null,null,null,3.08]
[null,null,null,null,16,16,236.3184,236.3184,"Tack",null,"X Sta",40582,null," @SG",null,null,{"$f":"ABS(P31-P29)","v":3.38},800,{"$f":"R30/Q30","v":236.68639053254438},"S"]
[null,null,null,null,0,0,0,0,"Fog Seal",null,"X",{"$f":"L30-L27","v":492},"@ SG","w/ super",null,-0.3]
[null,{"$f":"SUM(B3:B31)","v":0},null,null,0,0,0,0,"Agg. Treat",null,"PGL - X Elev",{"$f":"L28+L31*(L29/100)","v":2953.84},{"$f":"L32-M23","v":2953.7000000000003},{"$f":"L32-M23+M22*((N24/100)-0.02)","v":2953.7000000000003},null,null,{"$f":"ABS(P33-P31)","v":0.6},200,{"$f":"R32/Q32","v":333.33333333333337},"C",{"$f":"SUM(U3:U31)","v":0}]
[null,null,null,null,311,327,4593.4389000000001,4711.5981000000002,"Cold Mill",null,null,null,null,null,null,0.3]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"D6","v":1595},null,null,null,null,{"$f":"ABS(P35-P33)","v":3.13},500,{"$f":"R34/Q34","v":159.7444089456869},"S"]
[null,"From Sta","To Sta","Dist",null,null,null,null,null,null,null,null,null,null,null,-2.83]
[null,31933.33,37950,{"$f":"C36-B36","v":6016.6699999999983},null,"KPH","MPH",null,53.808,"N of Pt 1",null,null,null,null,null,null,{"$f":"ABS(P37-P35)","v":2.69},350,{"$f":"R36/Q36","v":130.11152416356879},"S"]
[null,{"$f":"C36","v":37950},38050,100,null,90,{"$f":"CONVERT(F37,\"m\",\"mi\")*1000","v":55.923407301360058},null,304.185,"E of Pt 1",null,null,null,null,null,-0.14000000000000001]
[null,{"$f":"C37","v":38050},38084,34]
[null,{"$f":"C38","v":38084},38184,100,null,{"$f":"CONVERT(G39,\"mi\",\"m\")/1000","v":96.560640000000006},60,null,820.95699999999999,"N of Pt 2",null,null,null,null,null,null,null,null,null,"Interpolation Calc."]
[null,38184,39660.99,1476.989999999998,null,null,null,null,262.07100000000003,"E of Pt 2",null,null,null,null,null,"Spiral Curve Formulas",null,null,null,"Begin",1935,45]
[null,39660.99,39775,114.01000000000204,null,"M","FT",null,{"$f":"((I39-I36)^2+(I40-I37)^2)^0.5","v":768.30409161802595},"Dist between Pt 1 and Pt 2",null,null,null,null,null,"PI Sta",32393.5,null,null,"Middle",1909.82,{"$f":"((U41-U40)*(V42-V40)/(U42-U40))+V40","v":44.681265822784809}]
[null,39775,177157.4,137382.39999999999,null,9.6,{"$f":"CONVERT(F42,\"m\",\"ft\")","v":31.496062992125985},null,null,null,null,null,null,null,null,"Δ",21.3,null,null,"End",1540,40]
[null,177157.4,177914.3,756.89999999999418,null,null,null,null,null,null,null,"Project Cost",2956325,null,null,"Rc",1500]
[null,177914.3,178514.3,600,null,{"$f":"CONVERT(G44,\"ft\",\"m\")","v":6.0960000000000001},20,null,null,null,null,"Yrs Inflation",2,null,null,"Ls",273]
[null,178514.3,178899.9,385.60000000000582,null,null,null,null,null,"IDC %",10.41,"CN",{"$f":"M43/((1+(K45/100))*(1.03)^M44*(1+(K46/100)))","v":2381022.2370733493},null,null,"TR",78,null,null,"Stopping Sight Distance"]
[null,178899.9,179090,190.10000000000582,null,null,null,null,null,"CE %",6,"CE",{"$f":"M45*(K46/100)","v":142861.33422440095},null,null,"Θs",{"$f":"(Q44/Q43)*(90/PI())","v":5.2139159356904914},null,null,"Design Speed (mph)",null,50]
[null,179090,179145,55,null,null,"Quantities per Project",null,null,null,null,null,null,null,null,"p",{"$f":"Q44*((0.0014544*Q46)-(1.582315*(Q46^3)*(10^-8))+(1.022426*(Q46^5)*(10^-13)))","v":2.0695794099097764},null,null,"Grade (%)",null,-3.7730000000000001]
[null,179145,179335,190,null,null,"Project 1","Project 2","Total","Unit Costs","Project 1","Project 2",null,null,null,"k",{"$f":"Q44*(0.5-(5.076957*(Q46^2)*(10^-6))+(4.295915*(Q46^4)*(10^-11)))","v":136.46233011708594},null,null,"SSD (ft)",null,{"$f":"(1.47*V46*2.5)+(V46^2)/(30*((11.2/32.2)+(V47/100)))","v":452.48390809674237}]
[null,179335,179530,195,null,null,1,0,{"$f":"G49+H49","v":1},2646285.5,{"$f":"G49*J49","v":2646285.5},{"$f":"H49*J49","v":0},null,null,null,"Ts",{"$f":"(Q43+Q47)*TAN(RADIANS(Q42/2))+Q48","v":418.92394467785016}]
[null,179530,179948.5,{"$f":"C50-B50","v":418.5},null,null,0,1,1,436875.2,0,436875.2,null,null,null,"Ec",{"$f":"(Q43+Q47)*(1/(COS(RADIANS(Q42/2)))-1)+Q47","v":28.397063949331447},null,null,null,"K-Value for Crest Curve"]
[null,179948.5,181655,1706.5,null,null,492,237,729,190.3,93627.6,45101.100000000006,null,null,null,"Δc",{"$f":"Q42-2*Q46","v":10.872168128619018},null,null,null,"SSD (ft)",452]
[null,181655,181921.6,266.60000000000582,null,null,236,105,341,10.7,2525.1999999999998,1123.5,null,null,null,"Lc",{"$f":"(Q51/360)*2*PI()*Q43","v":284.63269601218826},null,null,null,"K",{"$f":"V51^2/2158","v":94.672845227062098}]
[null,181921.6,182720,798.39999999999418,null,null,272,0,272,10.7,2910.3999999999996,0,null,null,null,"TS Sta",{"$f":"Q41-Q49","v":31974.576055322148}]
[null,182720,182800,80,null,null,1658,465,2123,7.8,12932.4,3627,null,null,null,"SC Sta",{"$f":"Q53+Q44","v":32247.576055322148},null,null,null,"K-Value for Sag Curve"]
[null,182800,186647,3847,null,null,401810,1996,403806,2.2999999999999998,924162.99999999988,4590.7999999999993,null,null,null,"CS Sta",{"$f":"Q54+Q52","v":32532.208751334336},null,null,null,"SSD (ft)",460]
[null,186647,187007,360,null,null,101.9,0,101.9,910,92729,0,null,null,null,"ST Sta",{"$f":"Q55+Q44","v":32805.208751334336},null,null,null,"K",{"$f":"V55^2/(400+3.5*V55)","v":105.27363184079601}]
[null,187007,187638.3,631.29999999998836,null,null,2874.3,661,3535.3,505,1451521.5,333805]
[null,187638.3,187998.3,360,null,null,57,3,60,2345,133665,7035,null,null,null,null,"Asymmetrical Vertical Curves"]
[null,187998.3,189251,1252.7000000000116,null,null,10,0,10,51.15,511.5,0,null,null,null,null,"PGL Vertical Curve Elev. Calcs."]
[null,189251,189549,298,null,null,0,115,115,240,0,27600,null,null,null,null,"VPC Sta",14276.5]
[null,189549,189722,173,null,null,30,75.099999999999994,105.1,130,3900,9763,null,null,null,null,"VPC Elev",926.14]
[null,189722,190236,514,null,null,116,1188.5999999999999,1304.5999999999999,29.35,3404.6000000000004,34885.409999999996,null,null,null,null,"G1 (%)",-4.4589999999999996]
[null,190236,190780,544,null,null,230,1090,1320,25.6,5888,27904,null,null,null,null,"G2 (%)",0.439,"L1",148]
[null,190780,193060.96,2280.9599999999919,null,null,50,0,50,14.3,715,0,null,null,null,null,"L",{"$f":"T63+T64","v":323},"L2",175]
[null,193060.96,201366,8305.0400000000081,null,null,2370,1235,3605,71.75,170047.5,88611.25,null,null,null,null,"X Sta",14580]
[null,201366,201440,74,null,null,6,6,12,1375,8250,8250,null,null,null,null,"X",{"$f":"R65-R60","v":303.5},"@ SG"]
[null,201440,51202.43,-150237.57,null,null,2,3,5,2200,4400,6600,null,null,null,"PGL","X Elev",{"$f":"(R66^2)*(T64/T63)*((R63-R62)/(200*R64))+(R62/100)*R66+R61","v":920.86503213491551},{"$f":"R67-S70","v":920.55003213491545},"from VPC to VPI"]
[null,51202.43,51501.27,{"$f":"C68-B68","v":298.83999999999651},null,null,28,10,38,10700,299600,107000,null,null,null,"PGL","X Elev",{"$f":"((R64-R66)^2)*(T63/T64)*((R63-R62)/(200*R64))+(R62/100)*T63+(R66-T63)*(R63/100)+R61","v":920.24770755161433},{"$f":"R68-S70","v":919.93270755161427},"from VPI to VPT"]
[null,51501.27,51787.31,286.04000000000087,null,null,16,0,16,11900,190400,0]
[null,51787.31,51867.12,79.810000000004948,null,null,0.5,0.5,1,37500,18750,18750,null,null,null,null,null,"Section Depth",0.315]
[null,51867.12,51966.14,99.019999999996799,null,null,487.8,10,497.8,29.1,14194.980000000001,291]
[null,51966.14,177325.59,125359.45,null,null,1012,22.2,1034.2,26.8,27121.600000000002,594.96]
[null,177325.59,177444.25,118.66000000000349,null,null,1672.5,111.6,1784.1,24.4,40809,2723.0399999999995]
[null,177444.25,178004.63,560.38000000000466,null,null,287,9,296,29.7,8523.9,267.3,null,null,null,"Shared Use Path SSD"]
[null,178004.63,178022.73,18.100000000005821,null,null,16,1,17,300,4800,300,null,null,null,null,"V (mph)",18]
[null,178022.73,179723.35,1700.6199999999953,null,null,644.1,236,880.1,10.1,6505.41,2383.6,null,null,null,null,"Grade (%)",1.032]
[null,179723.35,179773.85,50.5,null,null,87,0,87,4.75,413.25,0,null,null,null,null,"SSD (ft)",{"$f":"(R75^2)/(30*(0.16+(R76/100)))+3.67*R75","v":129.4700516674495}]
[null,179773.85,179862.18,88.329999999987194,null,null,5,1,6,1100,5500,1100]
[null,179862.18,179918.75,56.570000000006985,null,null,2,0,2,1100,2200,0,null,null,null,"Length of Path Crest Vertical Curve"]
[null,179918.75,180477.15,558.39999999999418,null,null,26,0,26,53.5,1391,0,null,null,null,null,"SSD (ft)",129.47]
[null,180477.15,37048.58,-143428.57,null,null,36,2,38,53.5,{"$f":"G81*J81","v":1926},{"$f":"H81*J81","v":107},null,null,null,null,"A (%)",6.03]
[null,37048.58,37100,51.419999999998254,null,null,565,0,565,27.35,15452.75,0,null,null,null,null,"L (ft)",{"$f":"(2*R80)-((200*4.5)/R81)","v":109.68626865671644},"when S>L",{"$f":"IF(R80>R82,TRUE,FALSE)","v":true}]
[null,37100,38931,1831,null,null,382,382,764,119,45458,45458,null,null,null,null,"L (ft)",{"$f":"(R81*(R80^2))/(100*2*4.5)","v":112.30862203},"when S<L",{"$f":"IF(R80<R83,TRUE,FALSE)","v":false}]
[null,38931,39195.08,264.08000000000175,null,null,12440,434,12874,9.5,118180,4123]
[null,39195.08,39297.480000000003,102.40000000000146,null,null,15556,53,15609,19,295564,1007]
[null,39297.480000000003,39386,88.519999999996799,null,null,1807,0,1807,17.850000000000001,32254.950000000004,0]
[null,39386,39606.83,220.83000000000175,null,null,184800,1056,185856,0.2,36960,211.20000000000002]
[null,39606.83,39656.519999999997,49.689999999995052,null,null,209747,977,{"$f":"G88+H88","v":210724},0.7,146822.9,683.9]
[null,39656.519999999997,39753.339999999997,96.819999999999709,null,null,17363,53,17416,6,104178,318]
[null,39753.339999999997,39813.480000000003,60.140000000006694,null,null,0,0,0,0,0,0]
[null,39813.480000000003,42515.8,2702.3199999999997,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,"Weighted Average",null,null,null,null,0,0,0,0,0,0]
[null,null,null,{"$f":"B97*C97","v":0},null,null,0,0,0,0,0,0]
[null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(K49:K97)","v":6974481.9400000004},{"$f":"SUM(L49:L97)","v":1221089.2600000002}]
[null,null,null,0,null,null,null,null,null,"Proportioned Costs",{"$f":"K98/(K98+L98)","v":0.85100620442416497},{"$f":"L98/(K98+L98)","v":0.14899379557583492}]
[null,null,null,0,null,null,null,"Sum",null,735867,{"$f":"K99*J100","v":626227.38263099699},{"$f":"L99*J100","v":109639.61736900291}]
[null,null,null,0,null,null,null,9.75,null,490000,{"$f":"K99*J101","v":416993.04016784084},{"$f":"L99*J101","v":73006.959832159104}]
[null,null,null,0,null,23.1,"Avg",13.35,null,0,{"$f":"K99*J102","v":0},{"$f":"L99*J102","v":0}]
[null,null,null,0,null,19.5,{"$f":"(F102+F103)/2","v":21.3},0,null,null,{"$f":"K98+SUM(K100:K102)","v":8017702.3627988379},{"$f":"L98+SUM(L100:L102)","v":1403735.8372011622}]
[null,null,null,0,null,{"$f":"F102+F103","v":42.6},null,null,null,null,null,{"$f":"K103+L103","v":9421438.1999999993}]
[null,null,null,0,null,null,null,{"$f":"SUM(H101:H104)","v":23.1}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0,null,"Quantities per Project"]
[null,null,null,0,null,"Project 1","Project 2","Project 3","Total","Unit Costs","Project 1","Project 2","Project 3"]
[null,null,null,0,null,0,0,1,{"$f":"SUM(F110:H110)","v":1},12072.45,{"$f":"F110*J110","v":0},{"$f":"G110*J110","v":0},{"$f":"H110*J110","v":12072.45}]
[null,null,null,0,null,0,0,1,{"$f":"SUM(F111:H111)","v":1},47070,{"$f":"F111*J111","v":0},0,47070]
[null,null,null,0,null,0,0,1,1,91430.6,0,0,91430.6]
[null,null,null,0,null,22536,9589,4426,36551,37.75,850734,361984.75,167081.5]
[null,null,null,0,null,316,134,62,512,217,68572,29078,13454]
[null,null,null,0,null,1306.5,556.4,256.39999999999998,2119.3000000000002,475,620587.5,264290,121789.99999999999]
[null,null,null,0,null,8665,3779,2585,15029,3.7,32060.5,13982.300000000001,9564.5]
[null,null,null,0,null,16339,8451,2488,27278,2.75,44932.25,23240.25,6842]
[null,null,null,0,null,385.9,184.9,105.4,676.19999999999993,633,244274.69999999998,117041.7,66718.2]
[null,null,null,0,null,0,0,0.9,0.9,2000,0,0,1800]
[null,null,null,0,null,216937,0,59004,275941,0.81,175718.97,0,47793.240000000005]
[null,null,null,0,null,0,103439,0,103439,0.69,0,71372.909999999989,0]
[null,null,null,0,null,175382,74451,19267,{"$f":"SUM(F122:H122)","v":269100},1.4,245534.8,104231.4,26973.8]
[null,null,null,0,null,1.6,0,0,1.6,1500,2400,0,0]
[null,null,null,0,null,0,1514,1196.5999999999999,2710.6,9,0,13626,10769.4]
[null,null,null,0,null,0,0,172.9,172.9,350,0,0,60515]
[null,null,null,0,null,4,0,4,8,1050,4200,0,4200]
[null,null,null,0,null,6437.5,0,139.19999999999999,6576.7,38,244625,0,5289.5999999999995]
[null,null,null,{"$f":"B128*C128","v":0},null,4,0,4,8,2620,10480,0,10480]
[null,null,null,0,null,6422.3,0,0,6422.3,3,19266.900000000001,0,0]
[null,null,null,0,null,2,0,0,2,1400,2800,0,0]
[null,null,null,0,null,403.9,341.9,79,824.8,24,9693.5999999999985,8205.5999999999985,1896]
[null,null,null,0,null,182.6,0,0,182.6,19,3469.4,0,0]
[null,null,null,{"$f":"B133*C133","v":0},null,153,192.8,214.8,560.6,22.75,3480.75,4386.2,4886.7]
[null,null,null,0,null,336.1,420.2,419.4,1175.6999999999998,21,7058.1,8824.1999999999989,8807.4]
[null,null,null,0,null,57,56,93,206,25,1425,1400,2325]
[null,null,null,0,null,14,7,4,25,300,4200,2100,1200]
[null,null,null,0,null,369,0,0,369,8,2952,0,0]
[null,null,null,0,null,308,126,120,554,2.5,770,315,300]
[null,null,null,0,null,859,0,0,859,8,6872,0,0]
[null,null,null,0,null,0,0,619,619,6.5,0,0,4023.5]
[null,null,null,0,null,170,62,42,274,10,1700,620,420]
[null,null,null,0,null,148,78,0,226,12,1776,936,0]
[null,null,null,0,null,0,16,0,16,15,0,240,0]
[null,null,null,0,null,2,0,0,2,975,1950,0,0]
[null,null,null,0,null,1,0,0,1,25357,25357,0,0]
[null,null,null,0,null,136,14,47,197,21,2856,294,987]
[null,null,null,0,null,37,0,14,51,28,1036,0,392]
[null,{"$f":"SUM(B97:B147)","v":0},null,{"$f":"SUM(D97:D147)","v":0},{"$f":"D148/B148","v":{"$error":"#DIV/0!"}},34,0,10,44,23,782,0,230]
[null,null,null,{"$f":"D148/9","v":0},null,0,134,58,192,175,0,23450,10150]
[null,null,null,null,null,19,54,8,81,175,3325,9450,1400]
[null,null,null,null,null,0,9,6,15,175,0,1575,1050]
[null,null,null,null,null,12,36,6,{"$f":"SUM(F152:H152)","v":54},275,{"$f":"F152*J152","v":3300},{"$f":"G152*J152","v":9900},{"$f":"H152*J152","v":1650}]
[null,null,null,null,null,0,6,4,10,275,0,1650,1100]
[null,null,null,null,null,14.3,14.3,4.2,{"$f":"SUM(F154:H154)","v":32.800000000000004},400,{"$f":"F154*J154","v":5720},{"$f":"G154*J154","v":5720},{"$f":"H154*J154","v":1680}]
[null,null,null,null,null,628,258,246,1132,26,16328,6708,6396]
[null,null,null,null,null,459,172,164,795,47,21573,8084,7708]
[null,null,null,null,null,483,297,148,928,26,12558,7722,3848]
[null,null,null,null,null,331,198,100,629,47,15557,9306,4700]
[null,null,null,null,null,0,0,0,0,0,0,{"$f":"G159*J159","v":0},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K110:K159)","v":2719925.4699999997},{"$f":"SUM(L110:L159)","v":1109733.31},{"$f":"SUM(M110:M159)","v":768993.89}]
[null,null,null,null,null,null,null,null,null,"Proportioned Costs",{"$f":"K160/(SUM(K160:M160))","v":0.59146138340558774},{"$f":"L160/(SUM(K160:M160))","v":0.2413170529793458},{"$f":"M160/(SUM(K160:M160))","v":0.1672215636150664}]
[null,null,null,null,null,null,null,null,null,1041890,{"$f":"K161*J162","v":616237.70075644786},{"$f":"L161*J162","v":251425.8243286506},{"$f":"M161*J162","v":174226.47491490154}]
[null,null,null,null,null,null,null,null,null,893.7,{"$f":"K161*J163","v":528.5890383495738},{"$f":"L161*J163","v":215.66505024764135},{"$f":"M161*J163","v":149.44591140278484}]
[null,null,null,null,null,null,null,null,null,0,{"$f":"K161*J164","v":0},{"$f":"L161*J164","v":0},{"$f":"M161*J164","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K160+SUM(K162:K164)","v":3336691.7597947973},{"$f":"L160+SUM(L162:L164)","v":1361374.7993788982},{"$f":"M160+SUM(M162:M164)","v":943369.81082630437}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K165:M165)","v":5641436.3700000001}]
[]
[]
[]
[]
[]
[null,null,null,"Quantities per Project"]
[null,null,null,"Project 1","Project 2","Project 3","Project 4","Total","Unit Costs","Project 1","Project 2","Project 3","Project 4"]
[null,null,null,0,0,11839,5099,{"$f":"SUM(D174:G174)","v":16938},3.25,{"$f":"D174*I174","v":0},{"$f":"E174*I174","v":0},{"$f":"F174*I174","v":38476.75},{"$f":"G174*I174","v":16571.75}]
[null,null,null,0,335,0,122.3,{"$f":"SUM(D175:G175)","v":457.3},560,0,187600,0,68488]
[null,null,null,252.2,0,321,0,573.20000000000005,670,168974,0,215070,0]
[null,null,null,19138,923,4350,26870,51281,2.8,53586.399999999994,2584.3999999999996,12180,75236]
[null,null,null,7.2,9.8000000000000007,0,0,17,300,2160,2940,0,0]
[null,null,null,140567,186478,159349,68072,554466,0.5,70283.5,93239,79674.5,34036]
[null,null,null,6.5,9.8000000000000007,0,0,16.3,930,6045,9114,0,0]
[null,null,null,13.1,16.600000000000001,12.2,0,41.900000000000006,635,8318.5,10541,7747,0]
[null,null,null,2193,458,0,0,2651,14,30702,6412,0,0]
[null,null,null,15,0,0,0,15,265,3975,0,0,0]
[null,null,null,9,1,1,0,{"$f":"SUM(D184:G184)","v":11},215,1935,215,215,0]
[null,null,null,5,0,0,0,5,215,1075,0,0,0]
[null,null,null,10,1,2,0,13,320,3200,320,640,0]
[null,null,null,7,0,0,0,7,320,2240,0,0,0]
[null,null,null,266,364,305,163,1098,31,8246,11284,9455,5053]
[null,null,null,354,485,407,218,1464,58.5,20709,28372.5,23809.5,12753]
[null,null,null,116,118,149,30,413,31,3596,3658,4619,930]
[null,null,null,155,158,199,40,552,58.5,9067.5,9243,11641.5,2340]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,{"$f":"D206*I206","v":0},{"$f":"E206*I206","v":0},{"$f":"F206*I206","v":0},{"$f":"G206*I206","v":0}]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,{"$f":"SUM(D210:G210)","v":0},0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,{"$f":"SUM(D230:G230)","v":0},0,0,0,0,0]
[null,null,null,0,0,0,0,{"$f":"SUM(D231:G231)","v":0},0,0,0,0,0]
[null,null,null,0,0,0,0,{"$f":"SUM(D232:G232)","v":0},0,0,0,0,0]
[null,null,null,0,0,0,0,{"$f":"SUM(D233:G233)","v":0},0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J174:J234)","v":394112.9},{"$f":"SUM(K174:K234)","v":365522.9},{"$f":"SUM(L174:L234)","v":403528.25},{"$f":"SUM(M174:M234)","v":215407.75}]
[null,null,null,null,null,null,null,null,"Proportioned Costs",{"$f":"J235/(SUM(J235:M235))","v":0.28588492815535615},{"$f":"K235/(SUM(J235:M235))","v":0.26514607363939985},{"$f":"L235/(SUM(J235:M235))","v":0.29271471387997344},{"$f":"M235/(SUM(J235:M235))","v":0.15625428432527053}]
[null,null,null,null,null,null,null,null,272000,{"$f":"J236*I237","v":77760.700458256877},{"$f":"K236*I237","v":72119.732029916762},{"$f":"L236*I237","v":79618.402175352778},{"$f":"M236*I237","v":42501.165336473583}]
[null,null,null,null,null,null,null,null,0,{"$f":"J236*I238","v":0},{"$f":"K236*I238","v":0},{"$f":"L236*I238","v":0},{"$f":"M236*I238","v":0}]
[null,null,null,null,null,null,null,null,0,{"$f":"J236*I239","v":0},{"$f":"K236*I239","v":0},{"$f":"L236*I239","v":0},{"$f":"M236*I239","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J235+SUM(J237:J239)","v":471873.6004582569},{"$f":"K235+SUM(K237:K239)","v":437642.6320299168},{"$f":"L235+SUM(L237:L239)","v":483146.65217535279},{"$f":"M235+SUM(M237:M239)","v":257908.91533647358}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J240:M240)","v":1650571.8}]