{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Alternative 1","Alternative 2"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Alternative 1","index":0,"n_rows":34,"n_cols":13,"rows_kept":34,"merged":[[0,1,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[4,9,4,11],[5,0,5,7],[5,9,5,11],[6,0,6,1],[6,9,6,11],[7,0,7,1],[7,9,7,11],[8,0,8,1],[8,9,8,11],[9,0,9,1],[10,0,10,1],[10,9,10,11],[11,0,11,1],[11,9,11,11],[12,0,12,1],[13,0,13,1],[13,9,13,11],[14,0,14,4],[14,9,14,11],[15,0,15,4],[15,9,15,11],[16,0,16,4],[16,9,16,11],[17,0,17,7],[17,9,17,11],[18,0,18,5],[18,9,18,11],[19,0,19,7],[19,9,19,11],[20,0,20,1],[20,9,20,11],[21,0,21,4],[21,9,21,11],[22,0,22,4],[22,9,22,11],[23,0,23,7],[23,9,23,11],[24,0,24,5],[24,9,24,11],[25,0,25,7],[25,9,25,11],[26,0,26,5],[26,9,27,9],[26,10,27,10],[26,11,27,11],[26,12,30,13],[27,0,27,7],[28,0,28,4],[29,0,29,5],[29,9,29,11],[30,0,30,4],[31,0,31,5],[31,9,31,11],[32,0,32,7],[32,9,32,11],[33,0,33,5],[33,9,33,11]]}
["PROJECT:","Anytown, Common Bridge #1234",{"$nulls":3},"WIN:",null,{"v":10000,"d":"10000.00"}]
[]
["Alternative 1:","Culvert Replacement: [Description]"]
[null,"Construction Type",{"$nulls":3},"ESTIMATED BY: ",null,"ABC"]
[null,"Culvert Area: 200’ x 30' = 6,000 SF ",{"$nulls":7},"Unit Cost Reference:"]
[]
["STRUCTURE",null,null,"SF","×",null,"=",{"$f":"ROUNDUP(C7*F7,-3)","v":{"v":0,"d":"$0"}}]
["COFFERDAMS",null,null,"EA","×",null,"=",{"v":0,"d":"$0"}]
["STRUCTURAL EXCAVATION & BORROW",null,null,"CY","×",null,"=",{"v":0,"d":"$0"}]
["SPECIAL FILL",null,null,"CY","×",null,"=",{"v":0,"d":"$0"}]
["PLAIN RIPRAP",null,null,"CY","×",null,"=",{"v":0,"d":"$0"}]
["EXISTING BRIDGE REMOVAL",null,null,"LS","×",null,"=",{"v":0,"d":"$0"}]
["STAGED CONSTRUCTION TEMPORARY WALL",null,null,"SF","×",null,"=",{"v":0,"d":"$0"}]
["TEMPORARY TRAFFIC SIGNAL",null,null,"LS","×",null,"=",{"v":0,"d":"$0"}]
["REHABILITATION CONTINGENCIES",{"$nulls":4},"N/A","=",{"$f":"IF(F15=\"N/A\",0,ROUNDUP(F15*SUM(H7:H14),-3))","v":{"v":0,"d":"$0"}}]
["MISCELLANEOUS (TCP'S, FIELD OFFICE, ETC.)",{"$nulls":4},{"v":0.1,"d":"10%"},"=",{"$f":"ROUNDUP(F16*SUM(H7:H14),-3)","v":{"v":0,"d":"$0"}}]
["MOBILIZATION",{"$nulls":4},{"v":0.1,"d":"10%"},"=",{"$f":"ROUNDUP(F17*SUM(H7:H14),-3)","v":{"v":0,"d":"$0"}}]
[]
["STRUCTURE SUBTOTAL",{"$nulls":5},"=",{"$f":"5000*ROUNDUP(SUM(H7:H17)/5000,0)+IF(IF(5000*ROUNDUP(SUM(H7:H17)/5000,0)+H25>1000000,10000*ROUNDUP((5000*ROUNDUP(SUM(H7:H17)/5000,0)+H25)/10000,0),5000*ROUNDUP((5000*ROUNDUP(SUM(H7:H17)/5000,0)+H25)/5000,0))-H25-5000*ROUNDUP(SUM(H7:H17)/5000,0)=5000,5000,0)","v":{"v":0,"d":"$0"}}]
[]
["APPROACHES",null,null,"LF","×",null,"=",{"$f":"ROUNDUP(C21*F21,-3)","v":{"v":0,"d":"$0"}}]
["MISCELLANEOUS",{"$nulls":4},{"v":0.07,"d":"7%"},"=",{"$f":"ROUNDUP(F22*SUM(H21),-3)","v":{"v":0,"d":"$0"}}]
["MOBILIZATION",{"$nulls":4},{"v":0.1,"d":"10%"},"=",{"$f":"ROUNDUP(F23*SUM(H21),-3)","v":{"v":0,"d":"$0"}}]
[]
["APPROACHES SUBTOTAL",{"$nulls":5},"=",{"$f":"5000*ROUNDUP(SUM(H21:H23)/5000,0)","v":{"v":0,"d":"$0"}}]
[]
["TOTAL CONSTRUCTION COST",{"$nulls":5},"=",{"$f":"IF(H19+H25>1000000,10000*ROUNDUP((H19+H25)/10000,0),5000*ROUNDUP((H19+H25)/5000,0))","v":{"v":0,"d":"$0"}},null,"Preliminary Percentage:","Preliminary Value:","Manual Value Override:","NOTE: Enter PE and CE percentage and value override (if needed) in green cells. Do NOT enter override values for both PE and CE"]
[]
["PRELIMINARY ENGINEERING",{"$nulls":4},{"$f":"IF(H27=0,0,H29/H27)","v":{"v":0,"d":"0%"}},"=",{"$f":"IF(L29<>\"\",L29,H34-H27-IF((H34-H27-H30-H32)*J29/(J29+J31)>1000000,10000*ROUNDUP((H34-H27-H30-H32)*J29/(J29+J31)/10000,0),5000*ROUNDUP((H34-H27-H30-H32)*J29/(J29+J31)/5000,0))-H30-H31-H32+IF((H34-H27-H30-H32)*J29/(J29+J31)>1000000,10000*ROUNDUP((H34-H27-H30-H32)*J29/(J29+J31)/10000,0),5000*ROUNDUP((H34-H27-H30-H32)*J29/(J29+J31)/5000,0)))","v":{"v":0,"d":"$0"}},null,{"v":0.1,"d":"10%"},{"$f":"IF(J29*H$27>1000000,10000*ROUNDUP(J29*H$27/10000,0),5000*ROUNDUP(J29*H$27/5000,0))","v":{"v":0,"d":"$0"}}]
["RIGHT OF WAY",{"$nulls":5},"="]
["CONSTRUCTION ENGINEERING",{"$nulls":4},{"$f":"IF(H27=0,0,H31/H27)","v":{"v":0,"d":"0%"}},"=",{"$f":"IF(L31<>\"\",L31,IF(L29<>\"\",IF(H34-H27-H29-H30-H32>1000000,10000*ROUNDUP((H34-H27-H29-H30-H32)/10000,0),5000*ROUNDUP((H34-H27-H29-H30-H32)/5000,0)),IF((H34-H27-H30-H32)*J31/(J29+J31)>1000000,10000*ROUNDUP((H34-H27-H30-H32)*J31/(J29+J31)/10000,0),5000*ROUNDUP((H34-H27-H30-H32)*J31/(J29+J31)/5000,0))))","v":{"v":0,"d":"$0"}},null,{"v":0.1,"d":"10%"},{"$f":"IF(J31*H$27>1000000,10000*ROUNDUP(J31*H$27/10000,0),5000*ROUNDUP(J31*H$27/5000,0))","v":{"v":0,"d":"$0"}}]
["OTHER:  ",{"$nulls":5},"=",{"v":0,"d":"$0"}]
[]
["TOTAL PROJECT COST",{"$nulls":5},"=",{"$f":"IF(H27+K29+H30+K31+H32>1000000,100000*ROUNDUP((H27+K29+H30+K31+H32)/100000,0),IF(H27+K29+H30+K31+H32>=500000,10000*ROUNDUP((H27+K29+H30+K31+H32)/10000,0),5000*ROUNDUP((H27+K29+H30+K31+H32)/5000,0)))","v":{"v":0,"d":"$0"}}]

{"sheet":"Alternative 2","index":1,"n_rows":34,"n_cols":13,"rows_kept":34,"merged":[[0,1,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[4,9,4,11],[5,0,5,7],[5,9,5,11],[6,0,6,1],[6,9,6,11],[7,0,7,1],[7,9,7,11],[8,0,8,1],[8,9,8,11],[9,0,9,1],[9,9,9,11],[10,0,10,1],[10,9,10,11],[11,0,11,1],[11,9,11,11],[12,0,12,1],[12,9,12,11],[13,0,13,1],[13,9,13,11],[14,0,14,4],[14,9,14,11],[15,0,15,4],[15,9,15,11],[16,0,16,4],[16,9,16,11],[17,0,17,7],[17,9,17,11],[18,0,18,5],[18,9,18,11],[19,0,19,7],[19,9,19,11],[20,0,20,1],[20,9,20,11],[21,0,21,4],[21,9,21,11],[22,0,22,4],[22,9,22,11],[23,0,23,7],[23,9,23,11],[24,0,24,5],[24,9,24,11],[25,0,25,7],[25,9,25,11],[26,0,26,5],[26,9,27,9],[26,10,27,10],[26,11,27,11],[26,12,30,13],[27,0,27,7],[28,0,28,4],[29,0,29,5],[29,9,29,11],[30,0,30,4],[31,0,31,5],[31,9,31,11],[32,0,32,7],[32,9,32,11],[33,0,33,5],[33,9,33,11]]}
["PROJECT:","Anytown, Common Bridge #1234",{"$nulls":3},"WIN:",null,{"v":10000,"d":"10000.00"}]
[]
["Alternative 1:","Culvert Replacement: [Description]"]
[null,"Construction Type",{"$nulls":3},"ESTIMATED BY: ",null,"ABC"]
[null,"Culvert Area: 200’ x 30' = 6,000 SF ",{"$nulls":7},"Unit Cost Reference:"]
[]
["STRUCTURE",null,null,"SF","×",null,"=",{"$f":"ROUNDUP(C7*F7,-3)","v":{"v":0,"d":"$0"}}]
["COFFERDAMS",null,null,"EA","×",null,"=",{"v":0,"d":"$0"}]
["STRUCTURAL EXCAVATION & BORROW",null,null,"CY","×",null,"=",{"v":0,"d":"$0"}]
["SPECIAL FILL",null,null,"CY","×",null,"=",{"v":0,"d":"$0"}]
["PLAIN RIPRAP",null,null,"CY","×",null,"=",{"v":0,"d":"$0"}]
["EXISTING BRIDGE REMOVAL",null,null,"LS","×",null,"=",{"v":0,"d":"$0"}]
["STAGED CONSTRUCTION TEMPORARY WALL",null,null,"SF","×",null,"=",{"v":0,"d":"$0"}]
["TEMPORARY TRAFFIC SIGNAL",null,null,"LS","×",null,"=",{"v":0,"d":"$0"}]
["REHABILITATION CONTINGENCIES",{"$nulls":4},"N/A","=",{"$f":"IF(F15=\"N/A\",0,ROUNDUP(F15*SUM(H7:H14),-3))","v":{"v":0,"d":"$0"}}]
["MISCELLANEOUS (TCP'S, FIELD OFFICE, ETC.)",{"$nulls":4},{"v":0.1,"d":"10%"},"=",{"$f":"ROUNDUP(F16*SUM(H7:H14),-3)","v":{"v":0,"d":"$0"}}]
["MOBILIZATION",{"$nulls":4},{"v":0.1,"d":"10%"},"=",{"$f":"ROUNDUP(F17*SUM(H7:H14),-3)","v":{"v":0,"d":"$0"}}]
[]
["STRUCTURE SUBTOTAL",{"$nulls":5},"=",{"$f":"5000*ROUNDUP(SUM(H7:H17)/5000,0)+IF(IF(5000*ROUNDUP(SUM(H7:H17)/5000,0)+H25>1000000,10000*ROUNDUP((5000*ROUNDUP(SUM(H7:H17)/5000,0)+H25)/10000,0),5000*ROUNDUP((5000*ROUNDUP(SUM(H7:H17)/5000,0)+H25)/5000,0))-H25-5000*ROUNDUP(SUM(H7:H17)/5000,0)=5000,5000,0)","v":{"v":0,"d":"$0"}}]
[]
["APPROACHES",null,null,"LF","×",null,"=",{"$f":"ROUNDUP(C21*F21,-3)","v":{"v":0,"d":"$0"}}]
["MISCELLANEOUS",{"$nulls":4},{"v":0.07,"d":"7%"},"=",{"$f":"ROUNDUP(F22*SUM(H21),-3)","v":{"v":0,"d":"$0"}}]
["MOBILIZATION",{"$nulls":4},{"v":0.1,"d":"10%"},"=",{"$f":"ROUNDUP(F23*SUM(H21),-3)","v":{"v":0,"d":"$0"}}]
[]
["APPROACHES SUBTOTAL",{"$nulls":5},"=",{"$f":"5000*ROUNDUP(SUM(H21:H23)/5000,0)","v":{"v":0,"d":"$0"}}]
[]
["TOTAL CONSTRUCTION COST",{"$nulls":5},"=",{"$f":"IF(H19+H25>1000000,10000*ROUNDUP((H19+H25)/10000,0),5000*ROUNDUP((H19+H25)/5000,0))","v":{"v":0,"d":"$0"}},null,"Preliminary Percentage:","Preliminary Value:","Manual Value Override:","NOTE: Enter PE and CE percentage and value override (if needed) in green cells. Do NOT enter override values for both PE and CE"]
[]
["PRELIMINARY ENGINEERING",{"$nulls":4},{"$f":"IF(H27=0,0,H29/H27)","v":{"v":0,"d":"0%"}},"=",{"$f":"IF(L29<>\"\",L29,H34-H27-IF((H34-H27-H30-H32)*J29/(J29+J31)>1000000,10000*ROUNDUP((H34-H27-H30-H32)*J29/(J29+J31)/10000,0),5000*ROUNDUP((H34-H27-H30-H32)*J29/(J29+J31)/5000,0))-H30-H31-H32+IF((H34-H27-H30-H32)*J29/(J29+J31)>1000000,10000*ROUNDUP((H34-H27-H30-H32)*J29/(J29+J31)/10000,0),5000*ROUNDUP((H34-H27-H30-H32)*J29/(J29+J31)/5000,0)))","v":{"v":0,"d":"$0"}},null,{"v":0.1,"d":"10%"},{"$f":"IF(J29*H$27>1000000,10000*ROUNDUP(J29*H$27/10000,0),5000*ROUNDUP(J29*H$27/5000,0))","v":{"v":0,"d":"$0"}}]
["RIGHT OF WAY",{"$nulls":5},"="]
["CONSTRUCTION ENGINEERING",{"$nulls":4},{"$f":"IF(H27=0,0,H31/H27)","v":{"v":0,"d":"0%"}},"=",{"$f":"IF(L31<>\"\",L31,IF(L29<>\"\",IF(H34-H27-H29-H30-H32>1000000,10000*ROUNDUP((H34-H27-H29-H30-H32)/10000,0),5000*ROUNDUP((H34-H27-H29-H30-H32)/5000,0)),IF((H34-H27-H30-H32)*J31/(J29+J31)>1000000,10000*ROUNDUP((H34-H27-H30-H32)*J31/(J29+J31)/10000,0),5000*ROUNDUP((H34-H27-H30-H32)*J31/(J29+J31)/5000,0))))","v":{"v":0,"d":"$0"}},null,{"v":0.1,"d":"10%"},{"$f":"IF(J31*H$27>1000000,10000*ROUNDUP(J31*H$27/10000,0),5000*ROUNDUP(J31*H$27/5000,0))","v":{"v":0,"d":"$0"}}]
["OTHER:  ",{"$nulls":5},"=",{"v":0,"d":"$0"}]
[]
["TOTAL PROJECT COST",{"$nulls":5},"=",{"$f":"IF(H27+K29+H30+K31+H32>1000000,100000*ROUNDUP((H27+K29+H30+K31+H32)/100000,0),IF(H27+K29+H30+K31+H32>=500000,10000*ROUNDUP((H27+K29+H30+K31+H32)/10000,0),5000*ROUNDUP((H27+K29+H30+K31+H32)/5000,0)))","v":{"v":0,"d":"$0"}}]