{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Basic Inputs","Unit Prices","Flexible","Rigid","Alternate","DATABASE","Graphs","Report","Advanced Report","Instructions"],"not_rendered":{"charts":4,"images":29,"macros":1,"external_links":0,"defined_names":14,"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":"Basic Inputs","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,2,1,3],[4,2,4,3],[3,2,3,3]]}
[]
[null,null,"FLORIDA DEPARTMENT OF TRANSPORTATION"]
[]
[null,null,"PAVEMENT TYPE SELECTION SPREADSHEET"]
[null,null,"PROJECT DESCRIPTION:"]
[]
[null,null,"Financial Project ID:"]
[null,null,"State Road Number:"]
[null,null,"County:"]
[null,null,"Project Length:"]
[null,null,"Roadway ID:"]
[null,null,"Begining MP:"]
[null,null,"Ending MP:"]
[null,null,"Transportation System:"]
[null,null,"Type of Work"]
[null,null,"Design Version"]

{"sheet":"Unit Prices","index":1,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,5],[4,7,4,9],[2,7,2,9],[5,7,5,9],[3,1,3,5],[1,1,1,5],[2,1,2,5],[3,7,3,9]]}
[null,"Note: It is Not Necessary to Enter the Standard Deviation for Normal Calculations."]
[]
[null,"Generic Example 1",null,null,null,null,null,"LINKS"]
[null,"LIST OF CONSTRUCTION ITEMS",null,null,null,null,null,"Specifications Office",null,null,null,null,null,null,"List of Units"]
[null,"Pay Item","Description","Mean Price","St. Deviation","Unit",null,"Preliminary Estimates",null,null,null,null,null,null,"Cu. Yd"]
[null,null,null,null,null,null,null,"Pavement Management Section",null,null,null,null,null,null,"Each"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gal."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sq. Ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sq. Yd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ton"]

{"sheet":"Flexible","index":2,"n_rows":103,"n_cols":27,"rows_kept":103,"cut":false,"hidden":false,"merged":[[86,1,86,4],[87,1,87,4],[88,1,88,4],[70,1,70,4],[82,1,82,4],[84,1,84,4],[85,1,85,4],[81,1,81,4],[78,1,78,4],[80,1,80,4],[61,1,61,4],[52,1,52,4],[62,1,62,4],[63,1,63,4],[79,1,79,4],[64,1,64,4],[66,1,66,4],[67,1,67,4],[68,1,68,4],[69,1,69,4],[50,1,50,4],[51,1,51,4],[60,1,60,4],[43,1,43,4],[44,1,44,4],[46,1,46,4],[45,1,45,4],[48,1,48,4],[49,1,49,4],[31,1,31,4],[32,1,32,4],[2,2,2,10],[3,2,3,10],[28,1,28,4],[30,1,30,4],[24,1,24,4],[25,1,25,4],[4,2,4,10],[22,1,22,4],[14,1,14,4],[42,1,42,4],[0,21,0,22],[19,1,19,4],[20,1,20,4],[21,1,21,4],[18,13,19,16],[17,13,17,16],[5,5,5,8],[0,18,0,20],[1,2,1,10],[0,13,0,16],[34,1,34,4],[23,1,23,4],[26,1,26,4],[27,1,27,4],[33,1,33,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TOOL BOX",null,null,null,null,"Design Options",null,null,"Calculation Options"]
[null,null,"LIFE CYCLE COST ANALYSIS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Superpave Structural Course Density",145,"Lbs/Cu.Ft","Lower Side",2]
[null,null,"ASPHALT CONCRETE PAVEMENT DESIGN (FLEXIBLE PAVEMENT)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Friction Course Density",135,"Lbs/Cu.Ft","Higher Side",2]
[null,null,{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7 &\", \" & \"SR No.-\" &'Basic Inputs'!$D$8 & \", \" & \"County:\" & 'Basic Inputs'!$D$9)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},null,null,null,null,null,null,null,"Tack Coat Spread Rate",0.5,"Gal/Sq.Yd"]
[null,null,{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$10&\" \"&'Basic Inputs'!$D$10&\", \"&'Basic Inputs'!$C$11&\" \"&'Basic Inputs'!$D$11)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Limerock Density",120,"Lbs/Cu.Ft"]
[null,"Definitions:",null,null,null,{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$12&\" \"&'Basic Inputs'!$D$12&\", \"&'Basic Inputs'!$C$13&\" \"&'Basic Inputs'!$D$13)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Subbase Density",110,"Lbs/Cu.Ft"]
[null,"Length of Section:",null,null,"Ft",null,null,null,null,null,"Analysis Period:"]
[null,"Passing Lane Width:",null,null,"Ft",null,null,null,null,null,"Discount Rate:"]
[null,"Travel Lane Width:",null,null,"Ft",null,null,null,null,null,"Initial Year of Construction:"]
[null,"Inside Shoulder Width:",null,null,"Ft",null,null,null,null,null,"No. of Passing Lanes:"]
[null,"Outside Shoulder Width:",null,null,"Ft",null,null,null,null,null,"No. of Travel Lanes:"]
[null,"Total Pavement Area:",null,{"$f":"(($D$8*$L$10)+($D$9*$L$11))*($D$7)*($L$12)","v":0},"Sq. Ft",null,null,null,null,null,"No. of Travel Directions:"]
[null,"Total Shoulder Area:",null,{"$f":"($D$10+$D$11)*($D$7)*($L$12)","v":0},"Sq. Ft"]
[]
[null,"CONSTRUCTION ITEMS",null,null,null,"THK.","QTY.","UNIT","UNIT PRICE","ST DEV","COST","PRESENT WORTH",null,null,null,null,null,null,null,null,null,"Lower Side","Normal","Higher Side","PW Lower Side","PW Normal","PW Higher Side"]
[]
[null,"INITIAL CONSTRUCTION IN YEAR:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MESSAGE BOX"]
[null,"MAINLINE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K20=\"\",\"\",($G20)*($I20-($W$2*$J20)))","v":""},{"$f":"IF($K20=\"\",\"\",($G20*$I20))","v":""},{"$f":"IF($K20=\"\",\"\",($G20)*($I20+($W$2*$J20)))","v":""},{"$f":"IF(V20=\"\",\"\",(V20*(1/(1+($L$8/100)))^$F$17))","v":""},{"$f":"IF(W20=\"\",\"\",(W20*(1/(1+($L$8/100)))^$F$17))","v":""},{"$f":"IF(X20=\"\",\"\",(X20*(1/(1+($L$8/100)))^$F$17))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K21=\"\",\"\",($G21)*($I21-($W$2*$J21)))","v":""},{"$f":"IF($K21=\"\",\"\",($G21*$I21))","v":""},{"$f":"IF($K21=\"\",\"\",($G21)*($I21+($W$2*$J21)))","v":""},{"$f":"IF(V21=\"\",\"\",(V21*(1/(1+($L$8/100)))^$F$17))","v":""},{"$f":"IF(W21=\"\",\"\",(W21*(1/(1+($L$8/100)))^$F$17))","v":""},{"$f":"IF(X21=\"\",\"\",(X21*(1/(1+($L$8/100)))^$F$17))","v":""}]
[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,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,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,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,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,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,null,null,null,null,null,null,"","","","","",""]
[null,"SHOULDER:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K31=\"\",\"\",($G31)*($I31-($W$2*$J31)))","v":""},{"$f":"IF($K31=\"\",\"\",($G31*$I31))","v":""},{"$f":"IF($K31=\"\",\"\",($G31)*($I31+($W$2*$J31)))","v":""},{"$f":"IF(V31=\"\",\"\",(V31*(1/(1+($L$8/100)))^$F$17))","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K32=\"\",\"\",($G32)*($I32-($W$2*$J32)))","v":""},{"$f":"IF($K32=\"\",\"\",($G32*$I32))","v":""},{"$f":"IF($K32=\"\",\"\",($G32)*($I32+($W$2*$J32)))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K33=\"\",\"\",($G33)*($I33-($W$2*$J33)))","v":""},{"$f":"IF($K33=\"\",\"\",($G33*$I33))","v":""},{"$f":"IF($K33=\"\",\"\",($G33)*($I33+($W$2*$J33)))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K34=\"\",\"\",($G34)*($I34-($W$2*$J34)))","v":""},{"$f":"IF($K34=\"\",\"\",($G34*$I34))","v":""},{"$f":"IF($K34=\"\",\"\",($G34)*($I34+($W$2*$J34)))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K35=\"\",\"\",($G35)*($I35-($W$2*$J35)))","v":""},{"$f":"IF($K35=\"\",\"\",($G35*$I35))","v":""},{"$f":"IF($K35=\"\",\"\",($G35)*($I35+($W$2*$J35)))","v":""},"","",""]
[]
[null,"DESIGN COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F37=\"\",\"\",SUM($K$20:$K$35))","v":""},null,{"$f":"IF(F37=\"\",\"\",(I37*(F37/100)))","v":""},{"$f":"IF($K37=\"\",\"\",($K37*(1/(1+($L$8/100)))^$F$17))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F37=\"\",\"\",(SUM(V$20:V$35)*($F37/100)))","v":""},{"$f":"IF($F37=\"\",\"\",(SUM(W$20:W$35)*($F37/100)))","v":""},"","","",""]
[null,"MOT COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F38=\"\",\"\",SUM($K$20:$K$35))","v":""},null,{"$f":"IF(F38=\"\",\"\",(I38*(F38/100)))","v":""},{"$f":"IF($K38=\"\",\"\",($K38*(1/(1+($L$8/100)))^$F$17))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F38=\"\",\"\",(SUM(V$20:V$35)*($F38/100)))","v":""},"","","","",""]
[null,"CEI COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F39=\"\",\"\",SUM($K$20:$K$35))","v":""},null,{"$f":"IF(F39=\"\",\"\",(I39*(F39/100)))","v":""},{"$f":"IF($K39=\"\",\"\",($K39*(1/(1+($L$8/100)))^$F$17))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F39=\"\",\"\",(SUM(V$20:V$35)*($F39/100)))","v":""},"","","","",""]
[]
[null,"REHABILITATION IN YEAR:"]
[null,"MAINLINE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K43=\"\",\"\",($G43)*($I43-($W$2*$J43)))","v":""},{"$f":"IF($K43=\"\",\"\",($G43*$I43))","v":""},{"$f":"IF($K43=\"\",\"\",($G43)*($I43+($W$2*$J43)))","v":""},{"$f":"IF(V43=\"\",\"\",(V43*(1/(1+($L$8/100)))^$F$41))","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K44=\"\",\"\",($G44)*($I44-($W$2*$J44)))","v":""},{"$f":"IF($K44=\"\",\"\",($G44*$I44))","v":""},{"$f":"IF($K44=\"\",\"\",($G44)*($I44+($W$2*$J44)))","v":""},"","",""]
[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,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,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"SHOULDER:",null,null,null,null,null,null,null,null,null,{"$f":"IF($K48=\"\",\"\",($K48*(1/(1+($L$8/100)))^$F$41))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(V49=\"\",\"\",(V49*(1/(1+($L$8/100)))^$F$41))","v":""},"",""]
[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,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,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,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,""]
[null,"DESIGN COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F55=\"\",\"\",SUM($K$43:$K$53))","v":""},null,{"$f":"IF(F55=\"\",\"\",(I55*(F55/100)))","v":""},{"$f":"IF($K55=\"\",\"\",($K55*(1/(1+($L$8/100)))^$F$41))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F55=\"\",\"\",(SUM(V$43:V$53)*($F55/100)))","v":""},{"$f":"IF($F55=\"\",\"\",(SUM(W$43:W$53)*($F55/100)))","v":""},"","","",""]
[null,"MOT COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F56=\"\",\"\",SUM($K$43:$K$53))","v":""},null,{"$f":"IF(F56=\"\",\"\",(I56*(F56/100)))","v":""},{"$f":"IF($K56=\"\",\"\",($K56*(1/(1+($L$8/100)))^$F$41))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F56=\"\",\"\",(SUM(V$43:V$53)*($F56/100)))","v":""},"","","","",""]
[null,"CEI COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F57=\"\",\"\",SUM($K$43:$K$53))","v":""},null,{"$f":"IF(F57=\"\",\"\",(I57*(F57/100)))","v":""},{"$f":"IF($K57=\"\",\"\",($K57*(1/(1+($L$8/100)))^$F$41))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F57=\"\",\"\",(SUM(V$43:V$53)*($F57/100)))","v":""},"","","","",""]
[]
[null,"REHABILITATION IN YEAR:"]
[null,"MAINLINE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K61=\"\",\"\",($G61)*($I61-($W$2*$J61)))","v":""},{"$f":"IF($K61=\"\",\"\",($G61*$I61))","v":""},{"$f":"IF($K61=\"\",\"\",($G61)*($I61+($W$2*$J61)))","v":""},{"$f":"IF(V61=\"\",\"\",(V61*(1/(1+($L$8/100)))^$F$59))","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K62=\"\",\"\",($G62)*($I62-($W$2*$J62)))","v":""},{"$f":"IF($K62=\"\",\"\",($G62*$I62))","v":""},{"$f":"IF($K62=\"\",\"\",($G62)*($I62+($W$2*$J62)))","v":""},"","",""]
[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,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,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"SHOULDER:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(V67=\"\",\"\",(V67*(1/(1+($L$8/100)))^$F$59))","v":""},"",""]
[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,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,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,null,null,null,"","","","","",""]
[]
[null,"DESIGN COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F73=\"\",\"\",SUM($K$61:$K$71))","v":""},null,{"$f":"IF(F73=\"\",\"\",(I73*(F73/100)))","v":""},{"$f":"IF($K73=\"\",\"\",($K73*(1/(1+($L$8/100)))^$F$59))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F73=\"\",\"\",(SUM(V$61:V$71)*($F73/100)))","v":""},{"$f":"IF($F73=\"\",\"\",(SUM(W$61:W$71)*($F73/100)))","v":""},"","","",""]
[null,"MOT COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F74=\"\",\"\",SUM($K$61:$K$71))","v":""},null,{"$f":"IF(F74=\"\",\"\",(I74*(F74/100)))","v":""},{"$f":"IF($K74=\"\",\"\",($K74*(1/(1+($L$8/100)))^$F$59))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F74=\"\",\"\",(SUM(V$61:V$71)*($F74/100)))","v":""},"","","","",""]
[null,"CEI COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F75=\"\",\"\",SUM($K$61:$K$71))","v":""},null,{"$f":"IF(F75=\"\",\"\",(I75*(F75/100)))","v":""},{"$f":"IF($K75=\"\",\"\",($K75*(1/(1+($L$8/100)))^$F$59))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F75=\"\",\"\",(SUM(V$61:V$71)*($F75/100)))","v":""},"","","","",""]
[]
[null,"REHABILITATION IN YEAR:"]
[null,"MAINLINE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K79=\"\",\"\",($G79)*($I79-($W$2*$J79)))","v":""},{"$f":"IF($K79=\"\",\"\",($G79*$I79))","v":""},{"$f":"IF($K79=\"\",\"\",($G79)*($I79+($W$2*$J79)))","v":""},{"$f":"IF(V79=\"\",\"\",(V79*(1/(1+($L$8/100)))^$F$77))","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K80=\"\",\"\",($G80)*($I80-($W$2*$J80)))","v":""},{"$f":"IF($K80=\"\",\"\",($G80*$I80))","v":""},{"$f":"IF($K80=\"\",\"\",($G80)*($I80+($W$2*$J80)))","v":""},"","",""]
[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,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,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"SHOULDER:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(V85=\"\",\"\",(V85*(1/(1+($L$8/100)))^$F$77))","v":""},"",""]
[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,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,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,null,null,null,"","","","","",""]
[]
[null,"DESIGN COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F91=\"\",\"\",SUM($K$79:$K$89))","v":""},null,{"$f":"IF(F91=\"\",\"\",(I91*(F91/100)))","v":""},{"$f":"IF($K91=\"\",\"\",($K91*(1/(1+($L$8/100)))^$F$77))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F91=\"\",\"\",(SUM(V$79:V$89)*($F91/100)))","v":""},{"$f":"IF($F91=\"\",\"\",(SUM(W$79:W$89)*($F91/100)))","v":""},"","","",""]
[null,"MOT COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F92=\"\",\"\",SUM($K$79:$K$89))","v":""},null,{"$f":"IF(F92=\"\",\"\",(I92*(F92/100)))","v":""},{"$f":"IF($K92=\"\",\"\",($K92*(1/(1+($L$8/100)))^$F$77))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F92=\"\",\"\",(SUM(V$79:V$89)*($F92/100)))","v":""},"","","","",""]
[null,"CEI COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F93=\"\",\"\",SUM($K$79:$K$89))","v":""},null,{"$f":"IF(F93=\"\",\"\",(I93*(F93/100)))","v":""},{"$f":"IF($K93=\"\",\"\",($K93*(1/(1+($L$8/100)))^$F$77))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F93=\"\",\"\",(SUM(V$79:V$89)*($F93/100)))","v":""},"","","","",""]
[]
[null,"REHABILITATION IN YEAR:"]
[]
[null,null,null,null,null,null,null,null,{"$f":"\"TOTAL INITIAL CONSTRUCTION COST\" & \" (YEAR  \"& $L$9&\"):\"","v":"TOTAL INITIAL CONSTRUCTION COST (YEAR  ):"},null,null,{"$f":"SUM(L20:L29,L31:L39)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y20:Y29,Y31:Y39)","v":0},{"$f":"SUM(Z20:Z29,Z31:Z39)","v":0},{"$f":"SUM(AA20:AA29,AA31:AA39)","v":0}]
[]
[null,null,null,null,null,null,null,null,"TOTAL PRESENT WORTH REHABILITATION COST:",null,null,{"$f":"SUM(L43:L47,L49:L53,L55:L57,L61:L65,L67:L71,L73:L75,L79:L83,L85:L89,L91:L93)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y43:Y93)","v":0},{"$f":"SUM(Z43:Z93)","v":0},{"$f":"SUM(AA43:AA93)","v":0}]
[]
[null,null,null,null,null,null,null,null,"TOTAL PRESENT WORTH SALVAGE VALUE:",null,null,{"$f":"Z101","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y99=0,0,IF($F$41>=40,((SUM(V20:V39)*(1/((1+($L$8/100))^40)))*(($F$41-40)/($F$41-$F$17))),IF($F$59>=40,((SUM(V43:V57)*(1/((1+($L$8/100))^40)))*(($F$59-40)/($F$59-$F$41))),IF($F$77>=40,((SUM(V61:V75)*(1/((1+($L$8/100))^40)))*(($F$77-40)/($F$77-$F$59))),((SUM(V79:V93)*(1/((1+($L$8/100))^40)))*(($F$95-40)/($F$95-$F$77)))))))","v":0},{"$f":"IF(Z99=0,0,IF($F$41>=40,((SUM(W20:W39)*(1/((1+($L$8/100))^40)))*(($F$41-40)/($F$41-$F$17))),IF($F$59>=40,((SUM(W43:W57)*(1/((1+($L$8/100))^40)))*(($F$59-40)/($F$59-$F$41))),IF($F$77>=40,((SUM(W61:W75)*(1/((1+($L$8/100))^40)))*(($F$77-40)/($F$77-$F$59))),((SUM(W79:W93)*(1/((1+($L$8/100))^40)))*(($F$95-40)/($F$95-$F$77)))))))","v":0},0]
[]
[null,null,null,null,null,null,null,null,"PRESENT WORTH:",null,null,{"$f":"Z103","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y101=\"\",\"\",Y97+Y99-Y101)","v":0},{"$f":"IF(Z101=\"\",\"\",Z97+Z99-Z101)","v":0},0]

{"sheet":"Rigid","index":3,"n_rows":103,"n_cols":27,"rows_kept":103,"cut":false,"hidden":false,"merged":[[88,1,88,4],[69,1,69,4],[70,1,70,4],[82,1,82,4],[84,1,84,4],[81,1,81,4],[78,1,78,4],[79,1,79,4],[80,1,80,4],[62,1,62,4],[63,1,63,4],[85,1,85,4],[86,1,86,4],[87,1,87,4],[67,1,67,4],[68,1,68,4],[64,1,64,4],[66,1,66,4],[2,2,2,10],[25,1,25,4],[4,2,4,10],[5,5,5,8],[18,13,19,16],[17,13,17,16],[45,1,45,4],[46,1,46,4],[0,21,0,22],[0,18,0,20],[26,1,26,4],[3,2,3,10],[23,1,23,4],[24,1,24,4],[19,1,19,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[27,1,27,4],[14,1,14,4],[1,2,1,10],[0,13,0,16],[60,1,60,4],[61,1,61,4],[34,1,34,4],[28,1,28,4],[30,1,30,4],[33,1,33,4],[31,1,31,4],[32,1,32,4],[48,1,48,4],[49,1,49,4],[50,1,50,4],[51,1,51,4],[52,1,52,4],[42,1,42,4],[43,1,43,4],[44,1,44,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TOOL BOX",null,null,null,null,"Design Options",null,null,"Calculation Options"]
[null,null,"LIFE CYCLE COST ANALYSIS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Superpave Structural Course Density",145,"Lbs/Cu.Ft","Lower Side",2]
[null,null,"JOINTED PLAIN CONCRETE PAVEMENT DESIGN (RIGID PAVEMENT)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Friction Course Density",135,"Lbs/Cu.Ft","Higher Side",2]
[null,null,{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7 &\", \" & \"SR No.-\" &'Basic Inputs'!$D$8 & \", \" & \"County:\" & 'Basic Inputs'!$D$9)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},null,null,null,null,null,null,null,"Slab Length",15,"Ft"]
[null,null,{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$10&\" \"&'Basic Inputs'!$D$10&\", \"&'Basic Inputs'!$C$11&\" \"&'Basic Inputs'!$D$11)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slab Width",10,"Ft"]
[null,"Definitions:",null,null,null,{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$12&\" \"&'Basic Inputs'!$D$12&\", \"&'Basic Inputs'!$C$13&\" \"&'Basic Inputs'!$D$13)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Base Course Density",120,"Lbs/Cu.Ft"]
[null,"Length of Section:",null,null,"Ft",null,null,null,null,null,"Analysis Period:",null,null,null,null,null,null,null,"CTPB Density",120,"Lbs/Cu.Ft"]
[null,"Passing Lane Width:",null,null,"Ft",null,null,null,null,null,"Discount Rate:"]
[null,"Travel Lane Width:",null,null,"Ft",null,null,null,null,null,"Initial Year of Construction:"]
[null,"Inside Shoulder Width:",null,null,"Ft",null,null,null,null,null,"No. of Passing Lanes:"]
[null,"Outside Shoulder Width:",null,null,"Ft",null,null,null,null,null,"No. of Travel Lanes:"]
[null,"Total Pavement Area:",null,{"$f":"(($D$8*$L$10)+($D$9*$L$11))*($D$7)*($L$12)","v":0},"Sq. Ft",null,null,null,null,null,"No. of Travel Directions:"]
[null,"Total Shoulder Area:",null,{"$f":"($D$10+$D$11)*($D$7)*($L$12)","v":0},"Sq. Ft",{"$f":"(SUM($L$10:$L$11)+1)*($D$7)*($L$12)","v":0},"Long. Concrete Joints (Ft)",null,null,{"$f":"(($D$8*$L$10)+($D$9*$L$11))*(ROUNDUP(($D$7/$T$4),0))*($L$12)","v":0},"Trans. Concrete Joints (Ft)"]
[]
[null,"CONSTRUCTION ITEMS",null,null,null,"THK.","QTY.","UNIT","UNIT PRICE","ST DEV","COST","PRESENT WORTH",null,null,null,null,null,null,null,null,null,"Lower Side","Normal","Higher Side","PW Lower Side","PW Normal","PW Higher Side"]
[]
[null,"INITIAL CONSTRUCTION IN YEAR:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MESSAGE BOX"]
[null,"MAINLINE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K20=\"\",\"\",($G20)*($I20-($W$2*$J20)))","v":""},{"$f":"IF($K20=\"\",\"\",($G20*$I20))","v":""},{"$f":"IF($K20=\"\",\"\",($G20)*($I20+($W$2*$J20)))","v":""},{"$f":"IF(V20=\"\",\"\",(V20*(1/(1+($L$8/100)))^$F$17))","v":""},{"$f":"IF(W20=\"\",\"\",(W20*(1/(1+($L$8/100)))^$F$17))","v":""},{"$f":"IF(X20=\"\",\"\",(X20*(1/(1+($L$8/100)))^$F$17))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K21=\"\",\"\",($G21)*($I21-($W$2*$J21)))","v":""},{"$f":"IF($K21=\"\",\"\",($G21*$I21))","v":""},{"$f":"IF($K21=\"\",\"\",($G21)*($I21+($W$2*$J21)))","v":""},{"$f":"IF(V21=\"\",\"\",(V21*(1/(1+($L$8/100)))^$F$17))","v":""},"",""]
[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,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,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,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,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,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,null,null,null,null,null,null,"","","","","",""]
[null,"SHOULDER:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K31=\"\",\"\",($G31)*($I31-($W$2*$J31)))","v":""},{"$f":"IF($K31=\"\",\"\",($G31*$I31))","v":""},{"$f":"IF($K31=\"\",\"\",($G31)*($I31+($W$2*$J31)))","v":""},{"$f":"IF(V31=\"\",\"\",(V31*(1/(1+($L$8/100)))^$F$17))","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K32=\"\",\"\",($G32)*($I32-($W$2*$J32)))","v":""},{"$f":"IF($K32=\"\",\"\",($G32*$I32))","v":""},{"$f":"IF($K32=\"\",\"\",($G32)*($I32+($W$2*$J32)))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K33=\"\",\"\",($G33)*($I33-($W$2*$J33)))","v":""},{"$f":"IF($K33=\"\",\"\",($G33*$I33))","v":""},{"$f":"IF($K33=\"\",\"\",($G33)*($I33+($W$2*$J33)))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K34=\"\",\"\",($G34)*($I34-($W$2*$J34)))","v":""},{"$f":"IF($K34=\"\",\"\",($G34*$I34))","v":""},{"$f":"IF($K34=\"\",\"\",($G34)*($I34+($W$2*$J34)))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K35=\"\",\"\",($G35)*($I35-($W$2*$J35)))","v":""},{"$f":"IF($K35=\"\",\"\",($G35*$I35))","v":""},{"$f":"IF($K35=\"\",\"\",($G35)*($I35+($W$2*$J35)))","v":""},"","",""]
[]
[null,"DESIGN COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F37=\"\",\"\",SUM($K$20:$K$35))","v":""},null,{"$f":"IF(F37=\"\",\"\",(I37*(F37/100)))","v":""},{"$f":"IF($K37=\"\",\"\",($K37*(1/(1+($L$8/100)))^$F$17))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F37=\"\",\"\",(SUM(V$20:V$35)*($F37/100)))","v":""},{"$f":"IF($F37=\"\",\"\",(SUM(W$20:W$35)*($F37/100)))","v":""},"","","",""]
[null,"MOT COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F38=\"\",\"\",SUM($K$20:$K$35))","v":""},null,{"$f":"IF(F38=\"\",\"\",(I38*(F38/100)))","v":""},{"$f":"IF($K38=\"\",\"\",($K38*(1/(1+($L$8/100)))^$F$17))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F38=\"\",\"\",(SUM(V$20:V$35)*($F38/100)))","v":""},"","","","",""]
[null,"CEI COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F39=\"\",\"\",SUM($K$20:$K$35))","v":""},null,{"$f":"IF(F39=\"\",\"\",(I39*(F39/100)))","v":""},{"$f":"IF($K39=\"\",\"\",($K39*(1/(1+($L$8/100)))^$F$17))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F39=\"\",\"\",(SUM(V$20:V$35)*($F39/100)))","v":""},"","","","",""]
[]
[null,"REHABILITATION IN YEAR:"]
[null,"MAINLINE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K43=\"\",\"\",($G43)*($I43-($W$2*$J43)))","v":""},{"$f":"IF($K43=\"\",\"\",($G43*$I43))","v":""},{"$f":"IF($K43=\"\",\"\",($G43)*($I43+($W$2*$J43)))","v":""},{"$f":"IF(V43=\"\",\"\",(V43*(1/(1+($L$8/100)))^$F$41))","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K44=\"\",\"\",($G44)*($I44-($W$2*$J44)))","v":""},{"$f":"IF($K44=\"\",\"\",($G44*$I44))","v":""},{"$f":"IF($K44=\"\",\"\",($G44)*($I44+($W$2*$J44)))","v":""},"","",""]
[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,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,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"SHOULDER:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(V49=\"\",\"\",(V49*(1/(1+($L$8/100)))^$F$41))","v":""},"",""]
[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,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,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,null,null,null,"","","","","",""]
[]
[null,"DESIGN COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F55=\"\",\"\",SUM($K$43:$K$53))","v":""},null,{"$f":"IF(F55=\"\",\"\",(I55*(F55/100)))","v":""},{"$f":"IF($K55=\"\",\"\",($K55*(1/(1+($L$8/100)))^$F$41))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F55=\"\",\"\",(SUM(V$43:V$53)*($F55/100)))","v":""},{"$f":"IF($F55=\"\",\"\",(SUM(W$43:W$53)*($F55/100)))","v":""},"","","",""]
[null,"MOT COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F56=\"\",\"\",SUM($K$43:$K$53))","v":""},null,{"$f":"IF(F56=\"\",\"\",(I56*(F56/100)))","v":""},{"$f":"IF($K56=\"\",\"\",($K56*(1/(1+($L$8/100)))^$F$41))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F56=\"\",\"\",(SUM(V$43:V$53)*($F56/100)))","v":""},"","","","",""]
[null,"CEI COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F57=\"\",\"\",SUM($K$43:$K$53))","v":""},null,{"$f":"IF(F57=\"\",\"\",(I57*(F57/100)))","v":""},{"$f":"IF($K57=\"\",\"\",($K57*(1/(1+($L$8/100)))^$F$41))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F57=\"\",\"\",(SUM(V$43:V$53)*($F57/100)))","v":""},"","","","",""]
[]
[null,"REHABILITATION IN YEAR:"]
[null,"MAINLINE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K61=\"\",\"\",($G61)*($I61-($W$2*$J61)))","v":""},{"$f":"IF($K61=\"\",\"\",($G61*$I61))","v":""},{"$f":"IF($K61=\"\",\"\",($G61)*($I61+($W$2*$J61)))","v":""},{"$f":"IF(V61=\"\",\"\",(V61*(1/(1+($L$8/100)))^$F$59))","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K62=\"\",\"\",($G62)*($I62-($W$2*$J62)))","v":""},{"$f":"IF($K62=\"\",\"\",($G62*$I62))","v":""},{"$f":"IF($K62=\"\",\"\",($G62)*($I62+($W$2*$J62)))","v":""},"","",""]
[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,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,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"SHOULDER:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(V67=\"\",\"\",(V67*(1/(1+($L$8/100)))^$F$59))","v":""},"",""]
[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,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,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,null,null,null,"","","","","",""]
[]
[null,"DESIGN COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F73=\"\",\"\",SUM($K$61:$K$71))","v":""},null,{"$f":"IF(F73=\"\",\"\",(I73*(F73/100)))","v":""},{"$f":"IF($K73=\"\",\"\",($K73*(1/(1+($L$8/100)))^$F$59))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F73=\"\",\"\",(SUM(V$61:V$71)*($F73/100)))","v":""},{"$f":"IF($F73=\"\",\"\",(SUM(W$61:W$71)*($F73/100)))","v":""},"","","",""]
[null,"MOT COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F74=\"\",\"\",SUM($K$61:$K$71))","v":""},null,{"$f":"IF(F74=\"\",\"\",(I74*(F74/100)))","v":""},{"$f":"IF($K74=\"\",\"\",($K74*(1/(1+($L$8/100)))^$F$59))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F74=\"\",\"\",(SUM(V$61:V$71)*($F74/100)))","v":""},"","","","",""]
[null,"CEI COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F75=\"\",\"\",SUM($K$61:$K$71))","v":""},null,{"$f":"IF(F75=\"\",\"\",(I75*(F75/100)))","v":""},{"$f":"IF($K75=\"\",\"\",($K75*(1/(1+($L$8/100)))^$F$59))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F75=\"\",\"\",(SUM(V$61:V$71)*($F75/100)))","v":""},"","","","",""]
[]
[null,"REHABILITATION IN YEAR:"]
[null,"MAINLINE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K79=\"\",\"\",($G79)*($I79-($W$2*$J79)))","v":""},{"$f":"IF($K79=\"\",\"\",($G79*$I79))","v":""},{"$f":"IF($K79=\"\",\"\",($G79)*($I79+($W$2*$J79)))","v":""},{"$f":"IF(V79=\"\",\"\",(V79*(1/(1+($L$8/100)))^$F$77))","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K80=\"\",\"\",($G80)*($I80-($W$2*$J80)))","v":""},{"$f":"IF($K80=\"\",\"\",($G80*$I80))","v":""},{"$f":"IF($K80=\"\",\"\",($G80)*($I80+($W$2*$J80)))","v":""},"","",""]
[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,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,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"SHOULDER:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(V85=\"\",\"\",(V85*(1/(1+($L$8/100)))^$F$77))","v":""},"",""]
[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,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,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,null,null,null,"","","","","",""]
[]
[null,"DESIGN COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F91=\"\",\"\",SUM($K$79:$K$89))","v":""},null,{"$f":"IF(F91=\"\",\"\",(I91*(F91/100)))","v":""},{"$f":"IF($K91=\"\",\"\",($K91*(1/(1+($L$8/100)))^$F$77))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F91=\"\",\"\",(SUM(V$79:V$89)*($F91/100)))","v":""},{"$f":"IF($F91=\"\",\"\",(SUM(W$79:W$89)*($F91/100)))","v":""},"","","",""]
[null,"MOT COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F92=\"\",\"\",SUM($K$79:$K$89))","v":""},null,{"$f":"IF(F92=\"\",\"\",(I92*(F92/100)))","v":""},{"$f":"IF($K92=\"\",\"\",($K92*(1/(1+($L$8/100)))^$F$77))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F92=\"\",\"\",(SUM(V$79:V$89)*($F92/100)))","v":""},"","","","",""]
[null,"CEI COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F93=\"\",\"\",SUM($K$79:$K$89))","v":""},null,{"$f":"IF(F93=\"\",\"\",(I93*(F93/100)))","v":""},{"$f":"IF($K93=\"\",\"\",($K93*(1/(1+($L$8/100)))^$F$77))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F93=\"\",\"\",(SUM(V$79:V$89)*($F93/100)))","v":""},"","","","",""]
[]
[null,"REHABILITATION IN YEAR:"]
[]
[null,null,null,null,null,null,null,null,{"$f":"\"TOTAL INITIAL CONSTRUCTION COST\" & \" (YEAR  \"& $L$9&\"):\"","v":"TOTAL INITIAL CONSTRUCTION COST (YEAR  ):"},null,null,{"$f":"SUM(L20:L29,L31:L39)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y20:Y29,Y31:Y39)","v":0},{"$f":"SUM(Z20:Z29,Z31:Z39)","v":0},{"$f":"SUM(AA20:AA29,AA31:AA39)","v":0}]
[]
[null,null,null,null,null,null,null,null,"TOTAL PRESENT WORTH REHABILITATION COST:",null,null,{"$f":"SUM(L43:L47,L49:L53,L55:L57,L61:L65,L67:L71,L73:L75,L79:L83,L85:L89,L91:L93)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y43:Y93)","v":0},{"$f":"SUM(Z43:Z93)","v":0},{"$f":"SUM(AA43:AA93)","v":0}]
[]
[null,null,null,null,null,null,null,null,"TOTAL PRESENT WORTH SALVAGE VALUE:",null,null,{"$f":"Z101","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y99=0,0,IF($F$41>=40,((SUM(V20:V39)*(1/((1+($L$8/100))^40)))*(($F$41-40)/($F$41-$F$17))),IF($F$59>=40,((SUM(V43:V57)*(1/((1+($L$8/100))^40)))*(($F$59-40)/($F$59-$F$41))),IF($F$77>=40,((SUM(V61:V75)*(1/((1+($L$8/100))^40)))*(($F$77-40)/($F$77-$F$59))),((SUM(V79:V93)*(1/((1+($L$8/100))^40)))*(($F$95-40)/($F$95-$F$77)))))))","v":0},{"$f":"IF(Z99=0,0,IF($F$41>=40,((SUM(W20:W39)*(1/((1+($L$8/100))^40)))*(($F$41-40)/($F$41-$F$17))),IF($F$59>=40,((SUM(W43:W57)*(1/((1+($L$8/100))^40)))*(($F$59-40)/($F$59-$F$41))),IF($F$77>=40,((SUM(W61:W75)*(1/((1+($L$8/100))^40)))*(($F$77-40)/($F$77-$F$59))),((SUM(W79:W93)*(1/((1+($L$8/100))^40)))*(($F$95-40)/($F$95-$F$77)))))))","v":0},0]
[]
[null,null,null,null,null,null,null,null,"PRESENT WORTH:",null,null,{"$f":"Z103","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y101=\"\",\"\",Y97+Y99-Y101)","v":0},{"$f":"IF(Z101=\"\",\"\",Z97+Z99-Z101)","v":0},0]

{"sheet":"Alternate","index":4,"n_rows":103,"n_cols":27,"rows_kept":103,"cut":false,"hidden":false,"merged":[[86,1,86,4],[88,1,88,4],[70,1,70,4],[82,1,82,4],[84,1,84,4],[85,1,85,4],[87,1,87,4],[50,1,50,4],[66,1,66,4],[67,1,67,4],[68,1,68,4],[69,1,69,4],[18,13,19,16],[17,13,17,16],[0,21,0,22],[34,1,34,4],[28,1,28,4],[30,1,30,4],[0,18,0,20],[26,1,26,4],[27,1,27,4],[14,1,14,4],[1,2,1,10],[0,13,0,16],[42,1,42,4],[43,1,43,4],[2,2,2,10],[3,2,3,10],[23,1,23,4],[24,1,24,4],[4,2,4,10],[5,5,5,8],[33,1,33,4],[19,1,19,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[31,1,31,4],[32,1,32,4],[25,1,25,4],[44,1,44,4],[45,1,45,4],[81,1,81,4],[60,1,60,4],[61,1,61,4],[62,1,62,4],[63,1,63,4],[78,1,78,4],[79,1,79,4],[80,1,80,4],[51,1,51,4],[52,1,52,4],[64,1,64,4],[46,1,46,4],[48,1,48,4],[49,1,49,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TOOL BOX",null,null,null,null,"Design Options",null,null,"Calculation Options"]
[null,null,"LIFE CYCLE COST ANALYSIS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Superpave Structural Course Density",145,"Lbs/Cu.Ft","Lower Side",2]
[null,null,"COMPOSITE PAVEMENT DEISGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Friction Course Density",135,"Lbs/Cu.Ft","Higher Side",2]
[null,null,{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7 &\", \" & \"SR No.-\" &'Basic Inputs'!$D$8 & \", \" & \"County:\" & 'Basic Inputs'!$D$9)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},null,null,null,null,null,null,null,"Slab Panel Length",6,"Ft"]
[null,null,{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$10&\" \"&'Basic Inputs'!$D$10&\", \"&'Basic Inputs'!$C$11&\" \"&'Basic Inputs'!$D$11)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slab Panel Width",6,"Ft"]
[null,"Definitions:",null,null,null,{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$12&\" \"&'Basic Inputs'!$D$12&\", \"&'Basic Inputs'!$C$13&\" \"&'Basic Inputs'!$D$13)","v":""}]
[null,"Length of Section:",null,null,"Ft",null,null,null,null,null,"Analysis Period:"]
[null,"Passing Lane Width:",null,null,"Ft",null,null,null,null,null,"Discount Rate:"]
[null,"Travel Lane Width:",null,null,"Ft",null,null,null,null,null,"Initial Year of Construction:"]
[null,"Inside Shoulder Width:",null,null,"Ft",null,null,null,null,null,"No. of Passing Lanes:"]
[null,"Outside Shoulder Width:",null,null,"Ft",null,null,null,null,null,"No. of Travel Lanes:"]
[null,"Total Pavement Area:",null,{"$f":"(($D$8*$L$10)+($D$9*$L$11))*($D$7)*($L$12)","v":0},"Sq. Ft",null,null,null,null,null,"No. of Travel Directions:"]
[null,"Total Shoulder Area:",null,{"$f":"($D$10+$D$11)*($D$7)*($L$12)","v":0},"Sq. Ft",{"$f":"((($D$8*$L$10)/$T$5)+(($D$9*$L$11)/$T$5)+1)*($L$12)*($D$7)","v":0},"Long. Concrete Joints (Ft)",null,null,{"$f":"(($D$8*$L$10)+($D$9*$L$11))*(ROUNDUP(($D$7/$T$4),0))*($L$12)","v":0},"Trans. Concrete Joints (Ft)"]
[]
[null,"CONSTRUCTION ITEMS",null,null,null,"THK.","QTY.","UNIT","UNIT PRICE","ST DEV","COST","PRESENT WORTH",null,null,null,null,null,null,null,null,null,"Lower Side","Normal","Higher Side","PW Lower Side","PW Normal","PW Higher Side"]
[]
[null,"INITIAL CONSTRUCTION IN YEAR:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MESSAGE BOX"]
[null,"MAINLINE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K20=\"\",\"\",($G20)*($I20-($W$2*$J20)))","v":""},{"$f":"IF($K20=\"\",\"\",($G20*$I20))","v":""},{"$f":"IF($K20=\"\",\"\",($G20)*($I20+($W$2*$J20)))","v":""},{"$f":"IF(V20=\"\",\"\",(V20*(1/(1+($L$8/100)))^$F$17))","v":""},{"$f":"IF(W20=\"\",\"\",(W20*(1/(1+($L$8/100)))^$F$17))","v":""},{"$f":"IF(X20=\"\",\"\",(X20*(1/(1+($L$8/100)))^$F$17))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K21=\"\",\"\",($G21)*($I21-($W$2*$J21)))","v":""},{"$f":"IF($K21=\"\",\"\",($G21*$I21))","v":""},{"$f":"IF($K21=\"\",\"\",($G21)*($I21+($W$2*$J21)))","v":""},{"$f":"IF(V21=\"\",\"\",(V21*(1/(1+($L$8/100)))^$F$17))","v":""},"",""]
[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,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,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,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,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,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,null,null,null,null,null,null,"","","","","",""]
[null,"SHOULDER:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K31=\"\",\"\",($G31)*($I31-($W$2*$J31)))","v":""},{"$f":"IF($K31=\"\",\"\",($G31*$I31))","v":""},{"$f":"IF($K31=\"\",\"\",($G31)*($I31+($W$2*$J31)))","v":""},{"$f":"IF(V31=\"\",\"\",(V31*(1/(1+($L$8/100)))^$F$17))","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K32=\"\",\"\",($G32)*($I32-($W$2*$J32)))","v":""},{"$f":"IF($K32=\"\",\"\",($G32*$I32))","v":""},{"$f":"IF($K32=\"\",\"\",($G32)*($I32+($W$2*$J32)))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K33=\"\",\"\",($G33)*($I33-($W$2*$J33)))","v":""},{"$f":"IF($K33=\"\",\"\",($G33*$I33))","v":""},{"$f":"IF($K33=\"\",\"\",($G33)*($I33+($W$2*$J33)))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K34=\"\",\"\",($G34)*($I34-($W$2*$J34)))","v":""},{"$f":"IF($K34=\"\",\"\",($G34*$I34))","v":""},{"$f":"IF($K34=\"\",\"\",($G34)*($I34+($W$2*$J34)))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K35=\"\",\"\",($G35)*($I35-($W$2*$J35)))","v":""},{"$f":"IF($K35=\"\",\"\",($G35*$I35))","v":""},{"$f":"IF($K35=\"\",\"\",($G35)*($I35+($W$2*$J35)))","v":""},"","",""]
[]
[null,"DESIGN COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F37=\"\",\"\",SUM($K$20:$K$35))","v":""},null,{"$f":"IF(F37=\"\",\"\",(I37*(F37/100)))","v":""},{"$f":"IF($K37=\"\",\"\",($K37*(1/(1+($L$8/100)))^$F$17))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F37=\"\",\"\",(SUM(V$20:V$35)*($F37/100)))","v":""},{"$f":"IF($F37=\"\",\"\",(SUM(W$20:W$35)*($F37/100)))","v":""},"","","",""]
[null,"MOT COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F38=\"\",\"\",SUM($K$20:$K$35))","v":""},null,{"$f":"IF(F38=\"\",\"\",(I38*(F38/100)))","v":""},{"$f":"IF($K38=\"\",\"\",($K38*(1/(1+($L$8/100)))^$F$17))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F38=\"\",\"\",(SUM(V$20:V$35)*($F38/100)))","v":""},"","","","",""]
[null,"CEI COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F39=\"\",\"\",SUM($K$20:$K$35))","v":""},null,{"$f":"IF(F39=\"\",\"\",(I39*(F39/100)))","v":""},{"$f":"IF($K39=\"\",\"\",($K39*(1/(1+($L$8/100)))^$F$17))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F39=\"\",\"\",(SUM(V$20:V$35)*($F39/100)))","v":""},"","","","",""]
[]
[null,"REHABILITATION IN YEAR:"]
[null,"MAINLINE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K43=\"\",\"\",($G43)*($I43-($W$2*$J43)))","v":""},{"$f":"IF($K43=\"\",\"\",($G43*$I43))","v":""},{"$f":"IF($K43=\"\",\"\",($G43)*($I43+($W$2*$J43)))","v":""},{"$f":"IF(V43=\"\",\"\",(V43*(1/(1+($L$8/100)))^$F$41))","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K44=\"\",\"\",($G44)*($I44-($W$2*$J44)))","v":""},{"$f":"IF($K44=\"\",\"\",($G44*$I44))","v":""},{"$f":"IF($K44=\"\",\"\",($G44)*($I44+($W$2*$J44)))","v":""},"","",""]
[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,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,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"SHOULDER:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(V49=\"\",\"\",(V49*(1/(1+($L$8/100)))^$F$41))","v":""},"",""]
[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,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,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,null,null,null,"","","","","",""]
[]
[null,"DESIGN COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F55=\"\",\"\",SUM($K$43:$K$53))","v":""},null,{"$f":"IF(F55=\"\",\"\",(I55*(F55/100)))","v":""},{"$f":"IF($K55=\"\",\"\",($K55*(1/(1+($L$8/100)))^$F$41))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F55=\"\",\"\",(SUM(V$43:V$53)*($F55/100)))","v":""},{"$f":"IF($F55=\"\",\"\",(SUM(W$43:W$53)*($F55/100)))","v":""},"","","",""]
[null,"MOT COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F56=\"\",\"\",SUM($K$43:$K$53))","v":""},null,{"$f":"IF(F56=\"\",\"\",(I56*(F56/100)))","v":""},{"$f":"IF($K56=\"\",\"\",($K56*(1/(1+($L$8/100)))^$F$41))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F56=\"\",\"\",(SUM(V$43:V$53)*($F56/100)))","v":""},"","","","",""]
[null,"CEI COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F57=\"\",\"\",SUM($K$43:$K$53))","v":""},null,{"$f":"IF(F57=\"\",\"\",(I57*(F57/100)))","v":""},{"$f":"IF($K57=\"\",\"\",($K57*(1/(1+($L$8/100)))^$F$41))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F57=\"\",\"\",(SUM(V$43:V$53)*($F57/100)))","v":""},"","","","",""]
[]
[null,"REHABILITATION IN YEAR:"]
[null,"MAINLINE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K61=\"\",\"\",($G61)*($I61-($W$2*$J61)))","v":""},{"$f":"IF($K61=\"\",\"\",($G61*$I61))","v":""},{"$f":"IF($K61=\"\",\"\",($G61)*($I61+($W$2*$J61)))","v":""},{"$f":"IF(V61=\"\",\"\",(V61*(1/(1+($L$8/100)))^$F$59))","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K62=\"\",\"\",($G62)*($I62-($W$2*$J62)))","v":""},{"$f":"IF($K62=\"\",\"\",($G62*$I62))","v":""},{"$f":"IF($K62=\"\",\"\",($G62)*($I62+($W$2*$J62)))","v":""},"","",""]
[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,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,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"SHOULDER:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(V67=\"\",\"\",(V67*(1/(1+($L$8/100)))^$F$59))","v":""},"",""]
[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,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,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,null,null,null,"","","","","",""]
[]
[null,"DESIGN COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F73=\"\",\"\",SUM($K$61:$K$71))","v":""},null,{"$f":"IF(F73=\"\",\"\",(I73*(F73/100)))","v":""},{"$f":"IF($K73=\"\",\"\",($K73*(1/(1+($L$8/100)))^$F$59))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F73=\"\",\"\",(SUM(V$61:V$71)*($F73/100)))","v":""},{"$f":"IF($F73=\"\",\"\",(SUM(W$61:W$71)*($F73/100)))","v":""},"","","",""]
[null,"MOT COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F74=\"\",\"\",SUM($K$61:$K$71))","v":""},null,{"$f":"IF(F74=\"\",\"\",(I74*(F74/100)))","v":""},{"$f":"IF($K74=\"\",\"\",($K74*(1/(1+($L$8/100)))^$F$59))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F74=\"\",\"\",(SUM(V$61:V$71)*($F74/100)))","v":""},"","","","",""]
[null,"CEI COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F75=\"\",\"\",SUM($K$61:$K$71))","v":""},null,{"$f":"IF(F75=\"\",\"\",(I75*(F75/100)))","v":""},{"$f":"IF($K75=\"\",\"\",($K75*(1/(1+($L$8/100)))^$F$59))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F75=\"\",\"\",(SUM(V$61:V$71)*($F75/100)))","v":""},"","","","",""]
[]
[null,"REHABILITATION IN YEAR:"]
[null,"MAINLINE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K79=\"\",\"\",($G79)*($I79-($W$2*$J79)))","v":""},{"$f":"IF($K79=\"\",\"\",($G79*$I79))","v":""},{"$f":"IF($K79=\"\",\"\",($G79)*($I79+($W$2*$J79)))","v":""},{"$f":"IF(V79=\"\",\"\",(V79*(1/(1+($L$8/100)))^$F$77))","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K80=\"\",\"\",($G80)*($I80-($W$2*$J80)))","v":""},{"$f":"IF($K80=\"\",\"\",($G80*$I80))","v":""},{"$f":"IF($K80=\"\",\"\",($G80)*($I80+($W$2*$J80)))","v":""},"","",""]
[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,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,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,"SHOULDER:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IF(V85=\"\",\"\",(V85*(1/(1+($L$8/100)))^$F$77))","v":""},"",""]
[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,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,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,null,null,null,"","","","","",""]
[]
[null,"DESIGN COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F91=\"\",\"\",SUM($K$79:$K$89))","v":""},null,{"$f":"IF(F91=\"\",\"\",(I91*(F91/100)))","v":""},{"$f":"IF($K91=\"\",\"\",($K91*(1/(1+($L$8/100)))^$F$77))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F91=\"\",\"\",(SUM(V$79:V$89)*($F91/100)))","v":""},{"$f":"IF($F91=\"\",\"\",(SUM(W$79:W$89)*($F91/100)))","v":""},"","","",""]
[null,"MOT COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F92=\"\",\"\",SUM($K$79:$K$89))","v":""},null,{"$f":"IF(F92=\"\",\"\",(I92*(F92/100)))","v":""},{"$f":"IF($K92=\"\",\"\",($K92*(1/(1+($L$8/100)))^$F$77))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F92=\"\",\"\",(SUM(V$79:V$89)*($F92/100)))","v":""},"","","","",""]
[null,"CEI COSTS:",null,null,null,null,null,"Subtotal",{"$f":"IF(F93=\"\",\"\",SUM($K$79:$K$89))","v":""},null,{"$f":"IF(F93=\"\",\"\",(I93*(F93/100)))","v":""},{"$f":"IF($K93=\"\",\"\",($K93*(1/(1+($L$8/100)))^$F$77))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($F93=\"\",\"\",(SUM(V$79:V$89)*($F93/100)))","v":""},"","","","",""]
[]
[null,"REHABILITATION IN YEAR:"]
[]
[null,null,null,null,null,null,null,null,{"$f":"\"TOTAL INITIAL CONSTRUCTION COST\" & \" (YEAR  \"& $L$9&\"):\"","v":"TOTAL INITIAL CONSTRUCTION COST (YEAR  ):"},null,null,{"$f":"SUM(L20:L29,L31:L39)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y20:Y29,Y31:Y39)","v":0},{"$f":"SUM(Z20:Z29,Z31:Z39)","v":0},{"$f":"SUM(AA20:AA29,AA31:AA39)","v":0}]
[]
[null,null,null,null,null,null,null,null,"TOTAL PRESENT WORTH REHABILITATION COST:",null,null,{"$f":"SUM(L43:L47,L49:L53,L55:L57,L61:L65,L67:L71,L73:L75,L79:L83,L85:L89,L91:L93)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y43:Y93)","v":0},{"$f":"SUM(Z43:Z93)","v":0},{"$f":"SUM(AA43:AA93)","v":0}]
[]
[null,null,null,null,null,null,null,null,"TOTAL PRESENT WORTH SALVAGE VALUE:",null,null,{"$f":"Z101","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y99=0,0,IF($F$41>=40,((SUM(V20:V39)*(1/((1+($L$8/100))^40)))*(($F$41-40)/($F$41-$F$17))),IF($F$59>=40,((SUM(V43:V57)*(1/((1+($L$8/100))^40)))*(($F$59-40)/($F$59-$F$41))),IF($F$77>=40,((SUM(V61:V75)*(1/((1+($L$8/100))^40)))*(($F$77-40)/($F$77-$F$59))),((SUM(V79:V93)*(1/((1+($L$8/100))^40)))*(($F$95-40)/($F$95-$F$77)))))))","v":0},{"$f":"IF(Z99=0,0,IF($F$41>=40,((SUM(W20:W39)*(1/((1+($L$8/100))^40)))*(($F$41-40)/($F$41-$F$17))),IF($F$59>=40,((SUM(W43:W57)*(1/((1+($L$8/100))^40)))*(($F$59-40)/($F$59-$F$41))),IF($F$77>=40,((SUM(W61:W75)*(1/((1+($L$8/100))^40)))*(($F$77-40)/($F$77-$F$59))),((SUM(W79:W93)*(1/((1+($L$8/100))^40)))*(($F$95-40)/($F$95-$F$77)))))))","v":0},0]
[]
[null,null,null,null,null,null,null,null,"PRESENT WORTH:",null,null,{"$f":"Z103","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y101=\"\",\"\",Y97+Y99-Y101)","v":0},{"$f":"IF(Z101=\"\",\"\",Z97+Z99-Z101)","v":0},0]

{"sheet":"DATABASE","index":5,"n_rows":518,"n_cols":256,"rows_kept":518,"cut":false,"hidden":true,"merged":[[167,0,283,0],[284,1,328,1],[401,0,517,0],[4,0,166,0],[401,1,445,1],[446,1,469,1],[470,1,493,1],[494,1,517,1],[329,1,352,1],[353,1,376,1],[4,1,16,1],[17,1,166,1],[167,1,211,1],[212,1,235,1],[236,1,259,1],[260,1,283,1],[377,1,400,1],[284,0,400,0]]}
["DATABASE",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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,null,null,11]
[]
[]
[]
["COMMON ITEMS","BASIC INPUTS","Unique Identifier","Rural Arterial/Collector 2-Lane (2-Way)","Rural Arterial/Collector 4-Lane Divided","Rural Limited Access 4-Lane Divided","Urban 4-Lane Arterial Divided (45 Mph)","Urban 6-Lane Arterial Divided (< 45Mph)","Urban 5-Lane Arterial/Collector Undivided","Generic Example 1","Generic Example 2","Generic Example 3 - Advanced Option","Rural Limited Access 4-Lane Divided--Ver: ","Generic Example 1--Ver: Version-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,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,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,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,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,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,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,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,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,"Rural Arterial/Collector 2-Lane (2-Way)"]
[null,null,"Fin Project ID","Rural Arterial/Collector 2-Lane (2-Way)","Rural Arterial/Collector 4-Lane Divided","Rural Limited Access 4-Lane Divided","Urban 4-Lane Arterial Divided (45 Mph)","Urban 6-Lane Arterial Divided (< 45Mph)","Urban 5-Lane Arterial/Collector Undivided","Generic Example 1","Generic Example 2","Generic Example 3 - Advanced Option","Rural Limited Access 4-Lane Divided","Generic Example 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,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,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,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,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,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,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,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,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,"Rural Arterial/Collector 4-Lane Divided"]
[null,null,"State Road Number",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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,"Rural Limited Access 4-Lane Divided"]
[null,null,"County",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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,"Urban 4-Lane Arterial Divided (45 Mph)"]
[null,null,"Project Length",null,null,null,null,null,null,"1 Mile","1 Mile","1 Mile",null,"1 Mile",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,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,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,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,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,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,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,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,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,"Urban 6-Lane Arterial Divided (< 45Mph)"]
[null,null,"Roadway ID",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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,"Urban 5-Lane Arterial/Collector Undivided"]
[null,null,"Beginning MP",null,null,null,null,null,null,"0.000","0.000","0.000","","0.000",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,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,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,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,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,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,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,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,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,"Generic Example 1"]
[null,null,"Ending MP",null,null,null,null,null,null,"1.000","1.000","1.000","","1.000",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,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,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,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,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,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,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,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,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,"Generic Example 2"]
[null,null,"Transportation System",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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,"Generic Example 3 - Advanced Option"]
[null,null,"Type of Work",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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,"Rural Limited Access 4-Lane Divided--Ver: "]
[null,null,"Design Version",null,null,null,null,null,null,"Version-1","Version-1","Version-1",null,"Version-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,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,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,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,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,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,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,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,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,"Generic Example 1--Ver: Version-1"]
[null,null,"EXTRA","Extra","Extra","Extra",null,null,null,"Extra","Extra","Extra","Extra","Extra"]
[null,null,"EXTRA","Extra","Extra","Extra",null,null,null,"Extra","Extra","Extra","Extra","Extra"]
[null,"UNIT                               PRICES","Pay Item-1","337 7","337 1","337 7","337 7","337 7","337 7","337 1","337 1","337 1","337 7","337 1"]
[null,null,"Description Item-1","FC-9.5 (Rubber)","FC-5 PG 76-22","FC-5 Rubber","FC-12.5 Rubber","FC-12.5 Rubber","FC-12.5 Rubber","FC-5 PG 76-22","FC-12.5 (Rubber)","FC-5 PG 76-22","FC-5 Rubber","FC-5 PG 76-22"]
[null,null,"Item-1 MP",null,null,null,null,null,null,98,85,98,null,98]
[null,null,"Item-1 StDev",null,null,null,null,null,null,null,null,15]
[null,null,"Item-1 Unit","Ton","Ton","Ton","Ton","Ton","Ton","Ton","Ton","Ton","Ton","Ton"]
[null,null,"Pay Item-2","334 1","334 1","337 7","334 1","334 1","334 1","334 1","334 1","334 1","337 7","334 1"]
[null,null,"Description Item-2","Type SP Traffic Level C","Type SP Traffic Level C","FC-5 PG76-22","Type SP Traffic Level B","Type SP Traffic Level C","Type SP Traffic Level B","Type SP Traffic Level C","Type SP Traffic Level C","Type SP Traffic Level C","FC-5 PG76-22","Type SP Traffic Level C"]
[null,null,"Item-2 MP","","","","","","",69,80,69,null,69]
[null,null,"Item-2 StDev","","","","","","",null,null,10]
[null,null,"Item-2 Unit","Ton","Ton","Ton","Ton","Ton","Ton","Ton","Ton","Ton","Ton","Ton"]
[null,null,"Pay Item-3","350 1","334 1","334 1","334 1","350 1","334 1","334 1","350 1","334 1","334 1","334 1"]
[null,null,"Description Item-3","JPCP","Type SP Traffic Level D","Type SP Traffic Level C","Type SP Traffic Level C","JPCP","Type SP Traffic Level C","Type SP Traffic Level D","JPCP","Type SP Traffic Level D","Type SP Traffic Level C","Type SP Traffic Level D"]
[null,null,"Item-3 MP","","","","","","",80,60,80,null,80]
[null,null,"Item-3 StDev","","","","","","",null,null,8]
[null,null,"Item-3 Unit","Cu. Yd","Ton","Ton","Ton","Cu. Yd","Ton","Ton","Sq. Yd","Ton","Ton","Ton"]
[null,null,"Pay Item-4","287 1","334 1","334 1","250 1","287 1","350 1","334 1","287 1","334 1","334 1","334 1"]
[null,null,"Description Item-4","ATPB","Type SP Traffic Level D PG76-22","Type SP Traffic Level D","JPCP","ATPB","JPCP","Type SP Traffic Level D PG 76-22","ATPB","Type SP Traffic Level D PG 76-22","Type SP Traffic Level D","Type SP Traffic Level D PG 76-22"]
[null,null,"Item-4 MP","","","","","","",84,90,84,null,84]
[null,null,"Item-4 StDev","","","","","","",null,null,8]
[null,null,"Item-4 Unit","Cu. Yd","Ton","Ton","Cu. Yd","Cu. Yd","Cu. Yd","Ton","Cu. Yd","Ton","Ton","Ton"]
[null,null,"Pay Item-5","160 4","350 1","334 1","287 1","160 4","287 1","350 1","160 4","350 1","334 1","350 1"]
[null,null,"Description Item-5","Type B Stabilized (LBR 40)","JPCP","Type SP Traffic Level D PG76-22","ATPB","Type B Stabilized (LBR 40)","ATPB","JPCP","Type B Stabilized (LBR 40)","JPCP","Type SP Traffic Level D PG76-22","JPCP"]
[null,null,"Item-5 MP","","","","","","",60,3.5,60,null,60]
[null,null,"Item-5 StDev","","","","","","",null,null,6]
[null,null,"Item-5 Unit","Cu. Yd","Cu. Yd","Ton","Cu. Yd","Cu. Yd","Cu. Yd","Sq. Yd","Sq. Yd","Sq. Yd","Ton","Sq. Yd"]
[null,null,"Pay Item-6","446 1","287 1","350 1","160 4","446 1","160 4","287 1","446 1","287 1","350 1","287 1"]
[null,null,"Description Item-6","Edgedrain","ATPB","JPCP","Type B Stabilized (LBR 40)","Edgedrain (Draincrete)","Type B Stabilized (LBR 40)","ATPB","Edgedrain (Draincrete)","ATPB","JPCP","ATPB"]
[null,null,"Item-6 MP","","","","","","",90,16.5,90,null,90]
[null,null,"Item-6 StDev","","","","","","",null,null,10]
[null,null,"Item-6 Unit","Ft","Cu. Yd","Cu. Yd","Cu. Yd","Ft","Sq. Yd","Cu. Yd","Ft","Cu. Yd","Cu. Yd","Cu. Yd"]
[null,null,"Pay Item-7","446 71","160 4","287 1","446 1","446 71","446 1","160 4","446 71","160 4","287 1","160 4"]
[null,null,"Description Item-7","Edgedrain Outlet Pipe (4 in)","Type B Stabilized (LBR 40)","ATPB","Edgedrain (Draincrete)","Edgedrain Outlet Pipe (4 in)","Edgedrain (Draincrete)","Type B Stabilized (LBR 40)","Edgedrain Outlet Pipe (4 in)","Type B Stabilized (LBR 40)","ATPB","Type B Stabilized (LBR 40)"]
[null,null,"Item-7 MP","","","","","","",3.5,27,3.5,null,3.5]
[null,null,"Item-7 StDev","","","","","","",null,null,0.5]
[null,null,"Item-7 Unit","Ft","Cu. Yd","Cu. Yd","Ft","Ft","Ft","Sq. Yd","Ft","Sq. Yd","Cu. Yd","Sq. Yd"]
[null,null,"Pay Item-8","285 7","446 1","160 4","446 71","285 7","446 71","446 1","285 7","446 1","160 4","446 1"]
[null,null,"Description Item-8","OBG-1","Edgedrain (Draincrete)","Type B Stabilized (LBR 40)","Edgedrain Outlet Pipe (4 in)","OBG-9","Edgedrain Outlet Pipe (4 in)","Edgedrain (Draincrete)","OBG-1","Edgedrain (Draincrete)","Type B Stabilized (LBR 40)","Edgedrain (Draincrete)"]
[null,null,"Item-8 MP","","","","","","",16.5,7,16.5,null,16.5]
[null,null,"Item-8 StDev","","","","","","",null,null,1.5]
[null,null,"Item-8 Unit","Cu. Yd","Ft","Cu. Yd","Ft","Cu. Yd","Ft","Ft","Sq. Yd","Ft","Cu. Yd","Ft"]
[null,null,"Pay Item-9","285 7","446 71","446 1","285 7","327 70","285 7","446 71","285 7","446 71","446 1","446 71"]
[null,null,"Description Item-9","OBG-8","Edgedrain Outlet Pipe (4 in)","Edgedrain (Draincrete)","OBG-9","Milling","OBG-9","Edgedrain Outlet Pipe (4 in)","OBG-9","Edgedrain Outlet Pipe (4 in)","Edgedrain (Draincrete)","Edgedrain Outlet Pipe (4 in)"]
[null,null,"Item-9 MP","","","","","","",27,12,27,null,27]
[null,null,"Item-9 StDev","","","","","","",null,null,3]
[null,null,"Item-9 Unit","Cu. Yd","Ft","Ft","Cu. Yd","Sq. Yd","Cu. Yd","Ft","Sq. Yd","Ft","Ft","Ft"]
[null,null,"Pay Item-10","327 70","285 7","446 71","327 70","353 70","327 70","285 7","327 70","285 7","446 71","285 7"]
[null,null,"Description Item-10","Milling","OBG-1","Edgedrain Outlet Pipe (4 in)","Milling","CPR - Slab Replacement (3%)","Milling","OBG-1","Milling (1 in)","OBG-1","Edgedrain Outlet Pipe (4 in)","OBG-1"]
[null,null,"Item-10 MP","","","","","","",14,2,14,null,14]
[null,null,"Item-10 StDev","","","","","","",null,null,1.5]
[null,null,"Item-10 Unit","Sq. Yd","Cu. Yd","Ft","Sq. Yd","Cu. Yd","Sq. Yd","Sq. Yd","Sq. Yd","Sq. Yd","Ft","Sq. Yd"]
[null,null,"Pay Item-11","353 70","285 7","285 7","353 70","353 70","353 70","285 7","327 70","285 7","285 7","285 7"]
[null,null,"Description Item-11","CPR - Slab Replacement (3%)","OBG-9","OBG-1","CPR - Slab Replacement (3%)","CPR - Slab Replacement (5%)","CPR - Slab Replacement (3%)","OBG-9","Milling (2 in)","OBG-9","OBG-1","OBG-9"]
[null,null,"Item-11 MP","","","","","","",12,2.5,12,null,12]
[null,null,"Item-11 StDev","","","","","","",null,null,1]
[null,null,"Item-11 Unit","Cu. Yd","Cu. Yd","Cu. Yd","Cu. Yd","Cu. Yd","Cu. Yd","Sq. Yd","Sq. Yd","Sq. Yd","Cu. Yd","Sq. Yd"]
[null,null,"Pay Item-12","175 1","327 70","285 7","353 70",null,"353 70","327 70","353 70","327 70","285 7","327 70"]
[null,null,"Description Item-12","Crack and Reseat Concrete","Milling","OBG-9","CPR - Slab Replacement (5%)","","CPR - Slab Replacement (5%)","Milling (2 in)","CPR - Slab Replacement (3%)","Milling (2 in)","OBG-9","Milling (2 in)"]
[null,null,"Item-12 MP","","","","","","",2.5,37,2.5,null,2.5]
[null,null,"Item-12 StDev","","","","","","",null,null,0.25]
[null,null,"Item-12 Unit","Sq. Yd","Sq. Yd","Cu. Yd","Cu. Yd","","Cu. Yd","Sq. Yd","Cu. Yd","Sq. Yd","Cu. Yd","Sq. Yd"]
[null,null,"Pay Item-13","341 70","353 70","327 70",null,null,null,"327 20","353 70","327 20","327 70","327 20"]
[null,null,"Description Item-13","ARMI","CPR - Slab Replacement (3%)","Milling","","","","Milling (1 in)","CPR - Slab Replacement (5%)","Milling (1 in)","Milling","Milling (1 in)"]
[null,null,"Item-13 MP","","","","","","",2,37,2,null,2]
[null,null,"Item-13 StDev","","","","","","",null,null,0.25]
[null,null,"Item-13 Unit","Sq. Yd","Cu. Yd","Sq. Yd","","","","Sq. Yd","Cu. Yd","Sq. Yd","Sq. Yd","Sq. Yd"]
[null,null,"Pay Item-14",null,"175 1","353 70",null,null,null,"353 70","175 1","353 70","353 70","353 70"]
[null,null,"Description Item-14","","Crack and Reseat Concrete","CPR - Slab Replacement (3%)","","","","CPR - Slab Replacement (3%)","Crack and Reseat Concrete","CPR - Slab Replacement (3%)","CPR - Slab Replacement (3%)","CPR - Slab Replacement (3%)"]
[null,null,"Item-14 MP","","","","","","",37,3,37,null,37]
[null,null,"Item-14 StDev","","","","","","",null,null,4]
[null,null,"Item-14 Unit","","Sq. Yd","Cu. Yd","","","","Cu. Yd","Sq. Yd","Cu. Yd","Cu. Yd","Cu. Yd"]
[null,null,"Pay Item-15",null,"341 70","175 1",null,null,null,"175 1","341 70","175 1","175 1","175 1"]
[null,null,"Description Item-15","","ARMI","Crack and Reseat Concrete","","","","Crack and Reseat Concrete","ARMI","Crack and Reseat Concrete","Crack and Reseat Concrete","Crack and Reseat Concrete"]
[null,null,"Item-15 MP","","","","","","",3,1.3,3,null,3]
[null,null,"Item-15 StDev","","","","","","",null,null,0.5]
[null,null,"Item-15 Unit","","Sq. Yd","Sq. Yd","","","","Sq. Yd","Sq. Yd","Sq. Yd","Sq. Yd","Sq. Yd"]
[null,null,"Pay Item-16",null,null,"341 70",null,null,null,"341 70","352 70","341 70","341 70","341 70"]
[null,null,"Description Item-16","","","ARMI","","","","ARMI","Grinding Concrete Pavement","ARMI","ARMI","ARMI"]
[null,null,"Item-16 MP","","","","","","",1.3,2.8,1.3,null,1.3]
[null,null,"Item-16 StDev","","","","","","",null,null,0.25]
[null,null,"Item-16 Unit","","","Sq. Yd","","","","Sq. Yd","Sq. Yd","Sq. Yd","Sq. Yd","Sq. Yd"]
[null,null,"Pay Item-17",null,null,null,null,null,null,"352 70","350 72","352 70",null,"352 70"]
[null,null,"Description Item-17",null,null,null,null,null,null,"Grinding Concrete Pavement","Cleaning and Resealing","Grinding Concrete Pavement",null,"Grinding Concrete Pavement"]
[null,null,"Item-17 MP",null,null,null,null,null,null,2.8,3.36,2.8,null,2.8]
[null,null,"Item-17 StDev",null,null,null,null,null,null,null,null,0.25]
[null,null,"Item-17 Unit",null,null,null,null,null,null,"Sq. Yd","Ft","Sq. Yd",null,"Sq. Yd"]
[null,null,"Pay Item-18",null,null,null,null,null,null,"353 70",null,"353 70",null,"353 70"]
[null,null,"Description Item-18",null,null,null,null,null,null,"CPR - Slab Replacement (5%)",null,"CPR - Slab Replacement (5%)",null,"CPR - Slab Replacement (5%)"]
[null,null,"Item-18 MP",null,null,null,null,null,null,37,null,37,null,37]
[null,null,"Item-18 StDev",null,null,null,null,null,null,null,null,4]
[null,null,"Item-18 Unit",null,null,null,null,null,null,"Cu. Yd",null,"Cu. Yd",null,"Cu. Yd"]
[null,null,"Pay Item-19",null,null,null,null,null,null,"350 72",null,"350 72",null,"350 72"]
[null,null,"Description Item-19",null,null,null,null,null,null,"Cleaning and Resealing",null,"Cleaning and Resealing",null,"Cleaning and Resealing"]
[null,null,"Item-19 MP",null,null,null,null,null,null,3.36,null,3.36,null,3.36]
[null,null,"Item-19 StDev",null,null,null,null,null,null,null,null,0.5]
[null,null,"Item-19 Unit",null,null,null,null,null,null,"Ft",null,"Ft",null,"Ft"]
[null,null,"Pay Item-20"]
[null,null,"Description Item-20"]
[null,null,"Item-20 MP"]
[null,null,"Item-20 StDev"]
[null,null,"Item-20 Unit"]
[null,null,"Pay Item-21"]
[null,null,"Description Item-21"]
[null,null,"Item-21 MP"]
[null,null,"Item-21 StDev"]
[null,null,"Item-21 Unit"]
[null,null,"Pay Item-22"]
[null,null,"Description Item-22"]
[null,null,"Item-22 MP"]
[null,null,"Item-22 StDev"]
[null,null,"Item-22 Unit"]
[null,null,"Pay Item-23"]
[null,null,"Description Item-23"]
[null,null,"Item-23 MP"]
[null,null,"Item-23 StDev"]
[null,null,"Item-23 Unit"]
[null,null,"Pay Item-24"]
[null,null,"Description Item-24"]
[null,null,"Item-24 MP"]
[null,null,"Item-24 StDev"]
[null,null,"Item-24 Unit"]
[null,null,"Pay Item-25"]
[null,null,"Description Item-25"]
[null,null,"Item-25 MP"]
[null,null,"Item-25 StDev"]
[null,null,"Item-25 Unit"]
[null,null,"Pay Item-26"]
[null,null,"Description Item-26"]
[null,null,"Item-26 MP"]
[null,null,"Item-26 StDev"]
[null,null,"Item-26 Unit"]
[null,null,"Pay Item-27"]
[null,null,"Description Item-27"]
[null,null,"Item-27 MP"]
[null,null,"Item-27 StDev"]
[null,null,"Item-27 Unit"]
[null,null,"Pay Item-28"]
[null,null,"Description Item-28"]
[null,null,"Item-28 MP"]
[null,null,"Item-28 StDev"]
[null,null,"Item-28 Unit"]
[null,null,"Pay Item-29"]
[null,null,"Description Item-29"]
[null,null,"Item-29 MP"]
[null,null,"Item-29 StDev"]
[null,null,"Item-29 Unit"]
[null,null,"Pay Item-30"]
[null,null,"Description Item-30"]
[null,null,"Item-30 MP"]
[null,null,"Item-30 StDev"]
[null,null,"Item-30 Unit"]
["LCCA-AC FLEXIBLE PAVEMENT","ORIGINAL CONSTRUCTION","Length of Section","5280","5280","5280","5280","5280","5280",5280,5280,5280,5280,5280]
[null,null,"Passing Lane Width","","12","12","12","12","12",12,12,12,12,12]
[null,null,"Travel Lane width","12","12","","16","16","16",12,12,12,null,12]
[null,null,"Inside Shoulder Width","","","4","","","",4,null,4,4,4]
[null,null,"Outside Shoulder Width","5","5","10","","","",10,5,10,10,10]
[null,null,"Analysis Period","40","40","40","40","40","40",40,40,40,40,40]
[null,null,"Discount Rate","3.5","3.5","3.5","3.5","3.5","3.5","3.5","3.5","3.5","3.5","3.5"]
[null,null,"Initial Year of Construction","2012","2012","2012","2012","2012","2012","2012","2012","2012","2012","2012"]
[null,null,"No of Passing Lanes",null,1,2,1,2,1.5,1,1,1,2,1]
[null,null,"No of Travel Lanes",1,1,null,1,1,1,1,1,1,null,1]
[null,null,"No of Travel Directions",2,2,2,2,2,2,2,2,2,2,2]
[null,null,"Initial Year in Construction","0","0","0","0","0","0",0,0,0,0,0]
[null,null,"Mainline Item-1","FC-9.5 (Rubber)","FC-5 PG 76-22","FC-5 PG76-22","FC-12.5 Rubber","FC-12.5 Rubber","FC-12.5 Rubber","FC-5 PG 76-22","FC-12.5 (Rubber)","FC-5 PG 76-22","FC-5 PG76-22","FC-5 PG 76-22"]
[null,null,"Mainline Item-2","Type SP Traffic Level C","Type SP Traffic Level D PG76-22","Type SP Traffic Level D PG76-22","Type SP Traffic Level B","Type SP Traffic Level C","Type SP Traffic Level B","Type SP Traffic Level D PG 76-22","Type SP Traffic Level C","Type SP Traffic Level D PG 76-22","Type SP Traffic Level D PG76-22","Type SP Traffic Level D PG 76-22"]
[null,null,"Mainline Item-3","OBG-8","Type SP Traffic Level D","Type SP Traffic Level D","OBG-9","OBG-9","Type B Stabilized (LBR 40)","Type SP Traffic Level D","OBG-9","Type SP Traffic Level D","Type SP Traffic Level D","Type SP Traffic Level D"]
[null,null,"Mainline Item-4","Type B Stabilized (LBR 40)","OBG-9","OBG-9","Type B Stabilized (LBR 40)","Type B Stabilized (LBR 40)","OBG-9","OBG-9","Type B Stabilized (LBR 40)","OBG-9","OBG-9","OBG-9"]
[null,null,"Mainline Item-5","","Type B Stabilized (LBR 40)","Type B Stabilized (LBR 40)","","","","Type B Stabilized (LBR 40)",null,"Type B Stabilized (LBR 40)","Type B Stabilized (LBR 40)","Type B Stabilized (LBR 40)"]
[null,null,"Mainline Item-6"]
[null,null,"Mainline Item-7"]
[null,null,"Mainline Item-8"]
[null,null,"Mainline Item-9"]
[null,null,"Mainline Item-10"]
[null,null,"Mainline Thk/Qty-1",null,null,null,null,null,null,0.75,1,0.75,null,0.75]
[null,null,"Mainline Thk/Qty-2",null,null,null,null,null,null,1.5,3.5,1.5,null,1.5]
[null,null,"Mainline Thk/Qty-3",null,null,null,null,null,null,2.5,10,2.5,null,2.5]
[null,null,"Mainline Thk/Qty-4",null,null,null,null,null,null,10,12,10,null,10]
[null,null,"Mainline Thk/Qty-5",null,null,null,null,null,null,12,null,12,null,12]
[null,null,"Mainline Thk/Qty-6"]
[null,null,"Mainline Thk/Qty-7"]
[null,null,"Mainline Thk/Qty-8"]
[null,null,"Mainline Thk/Qty-9"]
[null,null,"Mainline Thk/Qty-10"]
[null,null,"Shoulder Item-1","Type SP Traffic Level C","FC-5 PG 76-22","FC-5 PG76-22",null,null,null,"FC-5 PG 76-22","FC-12.5 (Rubber)","FC-5 PG 76-22","FC-5 PG76-22","FC-5 PG 76-22"]
[null,null,"Shoulder Item-2","OBG-1","Type SP Traffic Level D PG76-22","Type SP Traffic Level D PG76-22",null,null,null,"Type SP Traffic Level D PG 76-22","Type SP Traffic Level C","Type SP Traffic Level D PG 76-22","Type SP Traffic Level D PG76-22","Type SP Traffic Level D PG 76-22"]
[null,null,"Shoulder Item-3","Type B Stabilized (LBR 40)","OBG-1","Type SP Traffic Level D",null,null,null,"OBG-1","OBG-1","OBG-1","Type SP Traffic Level D","OBG-1"]
[null,null,"Shoulder Item-4","","Type B Stabilized (LBR 40)","OBG-1",null,null,null,"Type B Stabilized (LBR 40)","Type B Stabilized (LBR 40)","Type B Stabilized (LBR 40)","OBG-1","Type B Stabilized (LBR 40)"]
[null,null,"Shoulder Item-5","","","Type B Stabilized (LBR 40)",null,null,null,null,null,null,"Type B Stabilized (LBR 40)"]
[null,null,"Shoulder Thk/Qty-1",null,null,null,null,null,null,0.75,1,0.75,null,0.75]
[null,null,"Shoulder Thk/Qty-2",null,null,null,null,null,null,1.5,1.5,1.5,null,1.5]
[null,null,"Shoulder Thk/Qty-3",null,null,null,null,null,null,4,4,4,null,4]
[null,null,"Shoulder Thk/Qty-4",null,null,null,null,null,null,12,12,12,null,12]
[null,null,"Shoulder Thk/Qty-5"]
[null,null,"Design Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,null,"MOT Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,null,"CEI Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,"REHABILITATION YEAR -1","Rehabilitation Year -1","14","14","14","14","14","14",14,14,14,14,14]
[null,null,"Rehab-Mainline Item-1","Milling","Milling","Milling","Milling","Milling","Milling","Milling (2 in)","Milling (2 in)","Milling (2 in)","Milling","Milling (2 in)"]
[null,null,"Rehab-Mainline Item-2","FC-9.5 (Rubber)","FC-5 PG 76-22","FC-5 PG76-22","FC-12.5 Rubber","FC-12.5 Rubber","FC-12.5 Rubber","FC-5 PG 76-22","Type SP Traffic Level C","FC-5 PG 76-22","FC-5 PG76-22","FC-5 PG 76-22"]
[null,null,"Rehab-Mainline Item-3","Type SP Traffic Level C","Type SP Traffic Level D","Type SP Traffic Level D PG76-22","Type SP Traffic Level B","Type SP Traffic Level C","Type SP Traffic Level B","Type SP Traffic Level D","FC-12.5 (Rubber)","Type SP Traffic Level D","Type SP Traffic Level D PG76-22","Type SP Traffic Level D"]
[null,null,"Rehab-Mainline Item-4",null,null,null,null,null,null,"Type SP Traffic Level D PG 76-22",null,"Type SP Traffic Level D PG 76-22",null,"Type SP Traffic Level D PG 76-22"]
[null,null,"Rehab-Mainline Item-5"]
[null,null,"Rehab-Mainline Qty-1",null,null,null,null,null,null,2,2,2,null,2]
[null,null,"Rehab-Mainline Qty-2",null,null,null,null,null,null,0.75,3,0.75,null,0.75]
[null,null,"Rehab-Mainline Qty-3",null,null,null,null,null,null,1.5,1,1.5,null,1.5]
[null,null,"Rehab-Mainline Qty-4",null,null,null,null,null,null,1.5,null,1.5,null,1.5]
[null,null,"Rehab-Mainline Qty-5"]
[null,null,"Rehab-Shldr-Item-1","Milling","Milling","Milling",null,null,null,"Milling (1 in)","Milling (1 in)","Milling (1 in)","Milling","Milling (1 in)"]
[null,null,"Rehab-Shldr-Item-2","Type SP Traffic Level C","Type SP Traffic Level D PG76-22","Type SP Traffic Level D PG76-22",null,null,null,"Type SP Traffic Level D PG 76-22","FC-12.5 (Rubber)","Type SP Traffic Level D PG 76-22","Type SP Traffic Level D PG76-22","Type SP Traffic Level D PG 76-22"]
[null,null,"Rehab-Shldr-Item-3",null,"FC-5 PG 76-22","FC-5 PG76-22",null,null,null,"FC-5 PG 76-22",null,"FC-5 PG 76-22","FC-5 PG76-22","FC-5 PG 76-22"]
[null,null,"Rehab-Shldr-Item-4"]
[null,null,"Rehab-Shldr-Item-5"]
[null,null,"Rehab-Shldr-Qty-1",null,null,null,null,null,null,1,1,1,null,1]
[null,null,"Rehab-Shldr-Qty-2",null,null,null,null,null,null,1.5,1,1.5,null,1.5]
[null,null,"Rehab-Shldr-Qty-3",null,null,null,null,null,null,0.75,null,0.75,null,0.75]
[null,null,"Rehab-Shldr-Qty-4"]
[null,null,"Rehab-Shldr-Qty-5"]
[null,null,"Design Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,null,"MOT Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,null,"CEI Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,"REHABILITATION YEAR -2","Rehabilitation Year -2","28","28","28","28","28","28",28,28,28,28,28]
[null,null,"Rehab-Mainline Item-1","Milling","Milling","Milling","Milling","Milling","Milling","Milling (2 in)","Milling (2 in)","Milling (2 in)","Milling","Milling (2 in)"]
[null,null,"Rehab-Mainline Item-2","FC-9.5 (Rubber)","FC-5 PG 76-22","FC-5 PG76-22","FC-12.5 Rubber","FC-12.5 Rubber","FC-12.5 Rubber","FC-5 PG 76-22","Type SP Traffic Level C","FC-5 PG 76-22","FC-5 PG76-22","FC-5 PG 76-22"]
[null,null,"Rehab-Mainline Item-3","Type SP Traffic Level C","Type SP Traffic Level D","Type SP Traffic Level D PG76-22","Type SP Traffic Level B","Type SP Traffic Level C","Type SP Traffic Level B","Type SP Traffic Level D","FC-12.5 (Rubber)","Type SP Traffic Level D","Type SP Traffic Level D PG76-22","Type SP Traffic Level D"]
[null,null,"Rehab-Mainline Item-4",null,null,null,null,null,null,"Type SP Traffic Level D PG 76-22",null,"Type SP Traffic Level D PG 76-22",null,"Type SP Traffic Level D PG 76-22"]
[null,null,"Rehab-Mainline Item-5"]
[null,null,"Rehab-Mainline Qty-1",null,null,null,null,null,null,2,2,2,null,2]
[null,null,"Rehab-Mainline Qty-2",null,null,null,null,null,null,0.75,3,0.75,null,0.75]
[null,null,"Rehab-Mainline Qty-3",null,null,null,null,null,null,1.5,1,1.5,null,1.5]
[null,null,"Rehab-Mainline Qty-4",null,null,null,null,null,null,1.5,null,1.5,null,1.5]
[null,null,"Rehab-Mainline Qty-5"]
[null,null,"Rehab-Shldr-Item-1","Milling","Milling","Milling",null,null,null,"Milling (1 in)","Milling (1 in)","Milling (1 in)","Milling","Milling (1 in)"]
[null,null,"Rehab-Shldr-Item-2","Type SP Traffic Level C","Type SP Traffic Level D PG76-22","Type SP Traffic Level D PG76-22",null,null,null,"Type SP Traffic Level D PG 76-22","FC-12.5 (Rubber)","Type SP Traffic Level D PG 76-22","Type SP Traffic Level D PG76-22","Type SP Traffic Level D PG 76-22"]
[null,null,"Rehab-Shldr-Item-3",null,"FC-5 PG 76-22","FC-5 PG76-22",null,null,null,"FC-5 PG 76-22",null,"FC-5 PG 76-22","FC-5 PG76-22","FC-5 PG 76-22"]
[null,null,"Rehab-Shldr-Item-4"]
[null,null,"Rehab-Shldr-Item-5"]
[null,null,"Rehab-Shldr-Qty-1",null,null,null,null,null,null,1,1,1,null,1]
[null,null,"Rehab-Shldr-Qty-2",null,null,null,null,null,null,1.5,1,1.5,null,1.5]
[null,null,"Rehab-Shldr-Qty-3",null,null,null,null,null,null,0.75,null,0.75,null,0.75]
[null,null,"Rehab-Shldr-Qty-4"]
[null,null,"Rehab-Shldr-Qty-5"]
[null,null,"Design Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,null,"MOT Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,null,"CEI Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,"REHABILITATION YEAR -3","Rehabilitation Year -3",42,42,42,42,42,42,42,42,42,42,42]
[null,null,"Rehab-Mainline Item-1"]
[null,null,"Rehab-Mainline Item-2"]
[null,null,"Rehab-Mainline Item-3"]
[null,null,"Rehab-Mainline Item-4"]
[null,null,"Rehab-Mainline Item-5"]
[null,null,"Rehab-Mainline Qty-1"]
[null,null,"Rehab-Mainline Qty-2"]
[null,null,"Rehab-Mainline Qty-3"]
[null,null,"Rehab-Mainline Qty-4"]
[null,null,"Rehab-Mainline Qty-5"]
[null,null,"Rehab-Shldr-Item-1"]
[null,null,"Rehab-Shldr-Item-2"]
[null,null,"Rehab-Shldr-Item-3"]
[null,null,"Rehab-Shldr-Item-4"]
[null,null,"Rehab-Shldr-Item-5"]
[null,null,"Rehab-Shldr-Qty-1"]
[null,null,"Rehab-Shldr-Qty-2"]
[null,null,"Rehab-Shldr-Qty-3"]
[null,null,"Rehab-Shldr-Qty-4"]
[null,null,"Rehab-Shldr-Qty-5"]
[null,null,"Design Costs"]
[null,null,"MOT Costs"]
[null,null,"CEI Costs"]
["LCCA-PCC RIGID PAVEMENT","ORIGINAL CONSTRUCTION","Length of Section","5280","5280","5280","5280","5280","5280",5280,5280,5280,5280,5280]
[null,null,"Passing Lane Width","","12","12","12","12","12",12,12,12,12,12]
[null,null,"Travel Lane width","12","12","","16","16","16",14,14,14,null,14]
[null,null,"Inside Shoulder Width","","","4","","","",4,null,4,4,4]
[null,null,"Outside Shoulder Width","5","5","10","","","",10,5,10,10,10]
[null,null,"Analysis Period","40","40","40","40","40","40",40,40,40,40,40]
[null,null,"Discount Rate","3.5","3.5","3.5","3.5","3.5","3.5","3.5","3.5","3.5","3.5","3.5"]
[null,null,"Initial Year of Construction","2012","2012","2012","2012","2012","2012","2012","2012","2012","2012","2012"]
[null,null,"No of Passing Lanes",null,1,2,1,2,1.5,1,1,1,2,1]
[null,null,"No of Travel Lanes",1,1,null,1,1,1,1,1,1,null,1]
[null,null,"No of Travel Directions",2,2,2,2,2,2,2,2,2,2,2]
[null,null,"Initial Year in Construction","0","0","0","0","0","0",0,0,0,0,0]
[null,null,"Mainline Item-1","JPCP","JPCP","JPCP","JPCP","JPCP","JPCP","JPCP","JPCP","JPCP","JPCP","JPCP"]
[null,null,"Mainline Item-2","ATPB","ATPB","ATPB","ATPB","ATPB","ATPB","ATPB","ATPB","ATPB","ATPB","ATPB"]
[null,null,"Mainline Item-3","Type SP Traffic Level C","Type SP Traffic Level C","Type SP Traffic Level C","Type SP Traffic Level C","Type SP Traffic Level C","Type B Stabilized (LBR 40)","Type SP Traffic Level C","Type SP Traffic Level C","Type SP Traffic Level C","Type SP Traffic Level C","Type SP Traffic Level C"]
[null,null,"Mainline Item-4","Type B Stabilized (LBR 40)","Type B Stabilized (LBR 40)","Type B Stabilized (LBR 40)","Type B Stabilized (LBR 40)","Type B Stabilized (LBR 40)","Edgedrain (Draincrete)","Type B Stabilized (LBR 40)","Type B Stabilized (LBR 40)","Type B Stabilized (LBR 40)","Type B Stabilized (LBR 40)","Type B Stabilized (LBR 40)"]
[null,null,"Mainline Item-5","Edgedrain","Edgedrain (Draincrete)","Edgedrain (Draincrete)","Edgedrain (Draincrete)","Edgedrain (Draincrete)","Edgedrain Outlet Pipe (4 in)","Edgedrain (Draincrete)","Edgedrain (Draincrete)","Edgedrain (Draincrete)","Edgedrain (Draincrete)","Edgedrain (Draincrete)"]
[null,null,"Mainline Item-6","Edgedrain Outlet Pipe (4 in)","Edgedrain Outlet Pipe (4 in)","Edgedrain Outlet Pipe (4 in)","Edgedrain Outlet Pipe (4 in)","Edgedrain Outlet Pipe (4 in)","","Edgedrain Outlet Pipe (4 in)","Edgedrain Outlet Pipe (4 in)","Edgedrain Outlet Pipe (4 in)","Edgedrain Outlet Pipe (4 in)","Edgedrain Outlet Pipe (4 in)"]
[null,null,"Mainline Item-7"]
[null,null,"Mainline Item-8"]
[null,null,"Mainline Item-9"]
[null,null,"Mainline Item-10"]
[null,null,"Mainline Thk/Qty-1",null,null,null,null,null,null,12.5,10.5,12.5,null,12.5]
[null,null,"Mainline Thk/Qty-2",null,null,null,null,null,null,4,4,4,null,4]
[null,null,"Mainline Thk/Qty-3",null,null,null,null,null,null,1,1,1,null,1]
[null,null,"Mainline Thk/Qty-4",null,null,null,null,null,null,12,12,12,null,12]
[null,null,"Mainline Thk/Qty-5",null,null,null,null,null,null,10560,10560,10560,null,10560]
[null,null,"Mainline Thk/Qty-6",null,null,null,null,null,null,3168,3168,3168,null,3168]
[null,null,"Mainline Thk/Qty-7"]
[null,null,"Mainline Thk/Qty-8"]
[null,null,"Mainline Thk/Qty-9"]
[null,null,"Mainline Thk/Qty-10"]
[null,null,"Shoulder Item-1","Type SP Traffic Level C","FC-5 PG 76-22","FC-5 PG76-22",null,null,null,"Type SP Traffic Level D PG 76-22","Type SP Traffic Level C","Type SP Traffic Level D PG 76-22","FC-5 PG76-22","Type SP Traffic Level D PG 76-22"]
[null,null,"Shoulder Item-2","OBG-1","Type SP Traffic Level D PG76-22","Type SP Traffic Level D PG76-22",null,null,null,"OBG-1","OBG-1","OBG-1","Type SP Traffic Level D PG76-22","OBG-1"]
[null,null,"Shoulder Item-3","Type B Stabilized (LBR 40)","OBG-1","OBG-1",null,null,null,"Type B Stabilized (LBR 40)","Type B Stabilized (LBR 40)","Type B Stabilized (LBR 40)","OBG-1","Type B Stabilized (LBR 40)"]
[null,null,"Shoulder Item-4","","Type B Stabilized (LBR 40)","Type B Stabilized (LBR 40)",null,null,null,null,null,null,"Type B Stabilized (LBR 40)"]
[null,null,"Shoulder Item-5"]
[null,null,"Shoulder Thk/Qty-1",null,null,null,null,null,null,1.5,1.5,1.5,null,1.5]
[null,null,"Shoulder Thk/Qty-2",null,null,null,null,null,null,4,4,4,null,4]
[null,null,"Shoulder Thk/Qty-3",null,null,null,null,null,null,12,12,12,null,12]
[null,null,"Shoulder Thk/Qty-4"]
[null,null,"Shoulder Thk/Qty-5"]
[null,null,"Design Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,null,"MOT Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,null,"CEI Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,"REHABILITATION YEAR -1","Rehabilitation Year -1","20","20","20","20","20","20",20,20,20,20,20]
[null,null,"Rehab-Mainline Item-1","CPR - Slab Replacement (3%)","CPR - Slab Replacement (3%)","CPR - Slab Replacement (3%)","CPR - Slab Replacement (3%)","CPR - Slab Replacement (3%)","CPR - Slab Replacement (3%)","CPR - Slab Replacement (3%)","CPR - Slab Replacement (3%)","CPR - Slab Replacement (3%)","CPR - Slab Replacement (3%)","CPR - Slab Replacement (3%)"]
[null,null,"Rehab-Mainline Item-2",null,null,null,null,null,null,"Grinding Concrete Pavement","Grinding Concrete Pavement","Grinding Concrete Pavement",null,"Grinding Concrete Pavement"]
[null,null,"Rehab-Mainline Item-3",null,null,null,null,null,null,"Cleaning and Resealing","Cleaning and Resealing","Cleaning and Resealing",null,"Cleaning and Resealing"]
[null,null,"Rehab-Mainline Item-4"]
[null,null,"Rehab-Mainline Item-5"]
[null,null,"Rehab-Mainline Qty-1",null,null,null,null,null,null,3,3,3,null,3]
[null,null,"Rehab-Mainline Qty-2",null,null,null,null,null,null,1,1,1,null,1]
[null,null,"Rehab-Mainline Qty-3",null,null,null,null,null,null,48576,48576,48576,null,48576]
[null,null,"Rehab-Mainline Qty-4"]
[null,null,"Rehab-Mainline Qty-5"]
[null,null,"Rehab-Shldr-Item-1","Milling","Milling","Milling",null,null,null,"Milling (1 in)","Milling (1 in)","Milling (1 in)","Milling","Milling (1 in)"]
[null,null,"Rehab-Shldr-Item-2","Type SP Traffic Level C","Type SP Traffic Level D PG76-22","Type SP Traffic Level D PG76-22",null,null,null,"Type SP Traffic Level D PG 76-22","Type SP Traffic Level C","Type SP Traffic Level D PG 76-22","Type SP Traffic Level D PG76-22","Type SP Traffic Level D PG 76-22"]
[null,null,"Rehab-Shldr-Item-3",null,"FC-5 PG 76-22","FC-5 PG76-22",null,null,null,"FC-5 PG 76-22",null,"FC-5 PG 76-22","FC-5 PG76-22","FC-5 PG 76-22"]
[null,null,"Rehab-Shldr-Item-4"]
[null,null,"Rehab-Shldr-Item-5"]
[null,null,"Rehab-Shldr-Qty-1",null,null,null,null,null,null,1,1,1,null,1]
[null,null,"Rehab-Shldr-Qty-2",null,null,null,null,null,null,1.5,1,1.5,null,1.5]
[null,null,"Rehab-Shldr-Qty-3",null,null,null,null,null,null,0.75,null,0.75,null,0.75]
[null,null,"Rehab-Shldr-Qty-4"]
[null,null,"Rehab-Shldr-Qty-5"]
[null,null,"Design Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,null,"MOT Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,null,"CEI Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,"REHABILITATION YEAR -2","Rehabilitation Year -2","30","30","30","30","30","30",30,30,30,30,30]
[null,null,"Rehab-Mainline Item-1","Crack and Reseat Concrete","Crack and Reseat Concrete","Crack and Reseat Concrete","CPR - Slab Replacement (5%)","CPR - Slab Replacement (5%)","CPR - Slab Replacement (5%)","CPR - Slab Replacement (5%)","CPR - Slab Replacement (5%)","CPR - Slab Replacement (5%)","Crack and Reseat Concrete","CPR - Slab Replacement (5%)"]
[null,null,"Rehab-Mainline Item-2","ARMI","ARMI","ARMI","","","","Grinding Concrete Pavement","Grinding Concrete Pavement","Grinding Concrete Pavement","ARMI","Grinding Concrete Pavement"]
[null,null,"Rehab-Mainline Item-3","FC-9.5 (Rubber)","FC-5 PG 76-22","FC-5 PG76-22","","","","Cleaning and Resealing","Cleaning and Resealing","Cleaning and Resealing","FC-5 PG76-22","Cleaning and Resealing"]
[null,null,"Rehab-Mainline Item-4","Type SP Traffic Level C","Type SP Traffic Level C","Type SP Traffic Level D PG76-22","","","",null,null,null,"Type SP Traffic Level D PG76-22"]
[null,null,"Rehab-Mainline Item-5"]
[null,null,"Rehab-Mainline Qty-1",null,null,null,null,null,null,5,5,5,null,5]
[null,null,"Rehab-Mainline Qty-2",null,null,null,null,null,null,1,1,1,null,1]
[null,null,"Rehab-Mainline Qty-3",null,null,null,null,null,null,48576,48576,48576,null,48576]
[null,null,"Rehab-Mainline Qty-4"]
[null,null,"Rehab-Mainline Qty-5"]
[null,null,"Rehab-Shldr-Item-1","Milling","Milling","Milling",null,null,null,"Milling (1 in)","Milling (1 in)","Milling (1 in)","Milling","Milling (1 in)"]
[null,null,"Rehab-Shldr-Item-2","Type SP Traffic Level C","Type SP Traffic Level D PG76-22","Type SP Traffic Level D PG76-22",null,null,null,"Type SP Traffic Level D PG 76-22","Type SP Traffic Level C","Type SP Traffic Level D PG 76-22","Type SP Traffic Level D PG76-22","Type SP Traffic Level D PG 76-22"]
[null,null,"Rehab-Shldr-Item-3",null,"FC-5 PG 76-22","FC-5 PG76-22",null,null,null,"FC-5 PG 76-22",null,"FC-5 PG 76-22","FC-5 PG76-22","FC-5 PG 76-22"]
[null,null,"Rehab-Shldr-Item-4"]
[null,null,"Rehab-Shldr-Item-5"]
[null,null,"Rehab-Shldr-Qty-1",null,null,null,null,null,null,1,1,1,null,1]
[null,null,"Rehab-Shldr-Qty-2",null,null,null,null,null,null,1.5,1,1.5,null,1.5]
[null,null,"Rehab-Shldr-Qty-3",null,null,null,null,null,null,0.75,null,0.75,null,0.75]
[null,null,"Rehab-Shldr-Qty-4"]
[null,null,"Rehab-Shldr-Qty-5"]
[null,null,"Design Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,null,"MOT Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,null,"CEI Costs",null,null,null,null,null,null,10,10,10,null,10]
[null,"REHABILITATION YEAR -3","Rehabilitation Year -3",40,40,40,40,40,40,40,40,40,40,40]
[null,null,"Rehab-Mainline Item-1"]
[null,null,"Rehab-Mainline Item-2"]
[null,null,"Rehab-Mainline Item-3"]
[null,null,"Rehab-Mainline Item-4"]
[null,null,"Rehab-Mainline Item-5"]
[null,null,"Rehab-Mainline Qty-1"]
[null,null,"Rehab-Mainline Qty-2"]
[null,null,"Rehab-Mainline Qty-3"]
[null,null,"Rehab-Mainline Qty-4"]
[null,null,"Rehab-Mainline Qty-5"]
[null,null,"Rehab-Shldr-Item-1"]
[null,null,"Rehab-Shldr-Item-2"]
[null,null,"Rehab-Shldr-Item-3"]
[null,null,"Rehab-Shldr-Item-4"]
[null,null,"Rehab-Shldr-Item-5"]
[null,null,"Rehab-Shldr-Qty-1"]
[null,null,"Rehab-Shldr-Qty-2"]
[null,null,"Rehab-Shldr-Qty-3"]
[null,null,"Rehab-Shldr-Qty-4"]
[null,null,"Rehab-Shldr-Qty-5"]
[null,null,"Design Costs"]
[null,null,"MOT Costs"]
[null,null,"CEI Costs"]
["LCCA-ALTERNATE PAVEMENT","ORIGINAL CONSTRUCTION","Length of Section"]
[null,null,"Passing Lane Width"]
[null,null,"Travel Lane width"]
[null,null,"Inside Shoulder Width"]
[null,null,"Outside Shoulder Width"]
[null,null,"Analysis Period"]
[null,null,"Discount Rate"]
[null,null,"Initial Year of Construction"]
[null,null,"No of Passing Lanes"]
[null,null,"No of Travel Lanes"]
[null,null,"No of Travel Directions"]
[null,null,"Initial Year in Construction"]
[null,null,"Mainline Item-1"]
[null,null,"Mainline Item-2"]
[null,null,"Mainline Item-3"]
[null,null,"Mainline Item-4"]
[null,null,"Mainline Item-5"]
[null,null,"Mainline Item-6"]
[null,null,"Mainline Item-7"]
[null,null,"Mainline Item-8"]
[null,null,"Mainline Item-9"]
[null,null,"Mainline Item-10"]
[null,null,"Mainline Thk/Qty-1"]
[null,null,"Mainline Thk/Qty-2"]
[null,null,"Mainline Thk/Qty-3"]
[null,null,"Mainline Thk/Qty-4"]
[null,null,"Mainline Thk/Qty-5"]
[null,null,"Mainline Thk/Qty-6"]
[null,null,"Mainline Thk/Qty-7"]
[null,null,"Mainline Thk/Qty-8"]
[null,null,"Mainline Thk/Qty-9"]
[null,null,"Mainline Thk/Qty-10"]
[null,null,"Shoulder Item-1"]
[null,null,"Shoulder Item-2"]
[null,null,"Shoulder Item-3"]
[null,null,"Shoulder Item-4"]
[null,null,"Shoulder Item-5"]
[null,null,"Shoulder Thk/Qty-1"]
[null,null,"Shoulder Thk/Qty-2"]
[null,null,"Shoulder Thk/Qty-3"]
[null,null,"Shoulder Thk/Qty-4"]
[null,null,"Shoulder Thk/Qty-5"]
[null,null,"Design Costs"]
[null,null,"MOT Costs"]
[null,null,"CEI Costs"]
[null,"REHABILITATION YEAR -1","Rehabilitation Year -1"]
[null,null,"Rehab-Mainline Item-1"]
[null,null,"Rehab-Mainline Item-2"]
[null,null,"Rehab-Mainline Item-3"]
[null,null,"Rehab-Mainline Item-4"]
[null,null,"Rehab-Mainline Item-5"]
[null,null,"Rehab-Mainline Qty-1"]
[null,null,"Rehab-Mainline Qty-2"]
[null,null,"Rehab-Mainline Qty-3"]
[null,null,"Rehab-Mainline Qty-4"]
[null,null,"Rehab-Mainline Qty-5"]
[null,null,"Rehab-Shldr-Item-1"]
[null,null,"Rehab-Shldr-Item-2"]
[null,null,"Rehab-Shldr-Item-3"]
[null,null,"Rehab-Shldr-Item-4"]
[null,null,"Rehab-Shldr-Item-5"]
[null,null,"Rehab-Shldr-Qty-1"]
[null,null,"Rehab-Shldr-Qty-2"]
[null,null,"Rehab-Shldr-Qty-3"]
[null,null,"Rehab-Shldr-Qty-4"]
[null,null,"Rehab-Shldr-Qty-5"]
[null,null,"Design Costs"]
[null,null,"MOT Costs"]
[null,null,"CEI Costs"]
[null,"REHABILITATION YEAR -2","Rehabilitation Year -2"]
[null,null,"Rehab-Mainline Item-1"]
[null,null,"Rehab-Mainline Item-2"]
[null,null,"Rehab-Mainline Item-3"]
[null,null,"Rehab-Mainline Item-4"]
[null,null,"Rehab-Mainline Item-5"]
[null,null,"Rehab-Mainline Qty-1"]
[null,null,"Rehab-Mainline Qty-2"]
[null,null,"Rehab-Mainline Qty-3"]
[null,null,"Rehab-Mainline Qty-4"]
[null,null,"Rehab-Mainline Qty-5"]
[null,null,"Rehab-Shldr-Item-1"]
[null,null,"Rehab-Shldr-Item-2"]
[null,null,"Rehab-Shldr-Item-3"]
[null,null,"Rehab-Shldr-Item-4"]
[null,null,"Rehab-Shldr-Item-5"]
[null,null,"Rehab-Shldr-Qty-1"]
[null,null,"Rehab-Shldr-Qty-2"]
[null,null,"Rehab-Shldr-Qty-3"]
[null,null,"Rehab-Shldr-Qty-4"]
[null,null,"Rehab-Shldr-Qty-5"]
[null,null,"Design Costs"]
[null,null,"MOT Costs"]
[null,null,"CEI Costs"]
[null,"REHABILITATION YEAR -3","Rehabilitation Year -3"]
[null,null,"Rehab-Mainline Item-1"]
[null,null,"Rehab-Mainline Item-2"]
[null,null,"Rehab-Mainline Item-3"]
[null,null,"Rehab-Mainline Item-4"]
[null,null,"Rehab-Mainline Item-5"]
[null,null,"Rehab-Mainline Qty-1"]
[null,null,"Rehab-Mainline Qty-2"]
[null,null,"Rehab-Mainline Qty-3"]
[null,null,"Rehab-Mainline Qty-4"]
[null,null,"Rehab-Mainline Qty-5"]
[null,null,"Rehab-Shldr-Item-1"]
[null,null,"Rehab-Shldr-Item-2"]
[null,null,"Rehab-Shldr-Item-3"]
[null,null,"Rehab-Shldr-Item-4"]
[null,null,"Rehab-Shldr-Item-5"]
[null,null,"Rehab-Shldr-Qty-1"]
[null,null,"Rehab-Shldr-Qty-2"]
[null,null,"Rehab-Shldr-Qty-3"]
[null,null,"Rehab-Shldr-Qty-4"]
[null,null,"Rehab-Shldr-Qty-5"]
[null,null,"Design Costs"]
[null,null,"MOT Costs"]
[null,null,"CEI Costs"]

{"sheet":"Graphs","index":6,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,10],[0,11,0,21]]}
["Financial Project ID:Urban 5-Lane Arterial/Collector Undivided, SR No.-, County:",null,null,null,null,null,null,null,null,null,null,"Financial Project ID:Urban 5-Lane Arterial/Collector Undivided, SR No.-, County:"]

{"sheet":"Report","index":7,"n_rows":48,"n_cols":15,"rows_kept":48,"cut":false,"hidden":false,"merged":[[15,5,15,7],[20,2,20,4],[11,5,11,7],[12,5,12,7],[13,5,13,7],[14,5,14,7],[1,1,1,11],[2,1,2,11],[3,1,3,11],[4,1,4,11],[10,5,10,7],[7,5,7,7],[25,5,25,7],[26,5,26,7],[27,5,27,7],[28,5,28,7],[34,2,34,4]]}
[]
[null,"FLORIDA DEPARTMENT OF TRANSPORTATION"]
[null,"PAVEMENT TYPE SELECTION"]
[null,"ECONOMIC ANALYSIS"]
[null,"COST PER MILE"]
[]
[]
[null,"Analysis Period:",null,null,40,"Years",null,null,"Discount Rate:",null,3.5000000000000003E-2]
[]
[null,"PCC PAVEMENT"]
[null,null,null,null,null,"Cost",null,null,null,"P / F",null,"PRESENT WORTH"]
[null,null,null,"Initial",null,{"$f":"IF(SUM(Rigid!$K$20:$K$39)=0,\"\",SUM(Rigid!$K$20:$K$39))","v":""},null,null,"*",{"$f":"(1/((1+K8)^0))","v":1},"=",{"$f":"IF(OR($F12=\"\",$J12=\"\"),\"\",($F12*$J12))","v":""}]
[null,null,{"$f":"IF(Rigid!$F$41=\"\",\"\",Rigid!$F$41)","v":""},"Year",null,{"$f":"IF(SUM(Rigid!$K$43:$K$57)=0,\"\",SUM(Rigid!$K$43:$K$57))","v":""},null,null,"*",{"$f":"(IF(F13=\"\",\"\",(1/((1+$K$8)^$C13))))","v":""},"=",{"$f":"IF(OR($F13=\"\",$J13=\"\"),\"\",($F13*$J13))","v":""}]
[null,null,{"$f":"IF(Rigid!$F$59=\"\",\"\",Rigid!$F$59)","v":""},"Year",null,{"$f":"IF(SUM(Rigid!$K$61:$K$75)=0,\"\",SUM(Rigid!$K$61:$K$75))","v":""},null,null,"*",{"$f":"(IF(F14=\"\",\"\",(1/((1+$K$8)^$C14))))","v":""},"=",{"$f":"IF(OR($F14=\"\",$J14=\"\"),\"\",($F14*$J14))","v":""}]
[null,null,{"$f":"IF(Rigid!$F$77=\"\",\"\",Rigid!$F$77)","v":""},"Year",null,{"$f":"IF(SUM(Rigid!$K$79:$K$93)=0,\"\",SUM(Rigid!$K$79:$K$93))","v":""},null,null,"*","","=",{"$f":"IF(OR($F15=\"\",$J15=\"\"),\"\",($F15*$J15))","v":""}]
[null,null,{"$f":"IF(Rigid!F95=\"\",\"\",Rigid!F95)","v":""},"Year"]
[null,null,null,null,null,null,null,null,null,"TOTAL AGENCY COSTS","=",{"$f":"IF($L$12=\"\",\"\",SUM($L$12,$L$13,$L$14,$L$15))","v":""}]
[null,null,null,null,null,null,null,null,null,"USER COSTS","=",null,null,null,"<---  Enter User Costs Here"]
[null,null,null,null,null,null,null,null,null,"PW of Last Rehab"]
[null,null,null,null,null,null,"Remaining Service Life",null,null,"at Year 40"]
[null,null,"SALVAGE VALUE",null,null,{"$f":"IF(C13=\"\",\"\",IF(C13>=40,C13-40,IF(C14>=40,C14-40,IF(C15>=40,C15-40,C16-40))))","v":""},"/",{"$f":"IF(C14=\"\",C13,IF(C15=\"\",C14-C13,IF(C16=\"\",C15-C14,C16-C15)))","v":""},"*",{"$f":"IF(F12=\"\",\"\",IF(F13=\"\",F12*(1/((1+$K$8)^40)),IF(F14=\"\",F13*(1/((1+$K$8)^40)),IF(F15=\"\",F14*(1/((1+$K$8)^40)),F15*(1/((1+$K$8)^40))))))","v":""},"=",{"$f":"IF(F21=\"\",\"\",IF(J21=\"\",\"\",(F21/H21)*J21))","v":""}]
[null,null,null,null,null,null,null,null,null,"TOTAL PRESENT WORTH LIFE-CYCLE COSTS","=",{"$f":"IF(L17=\"\",\"\",L17+L18-L21)","v":""}]
[]
[null,"AC PAVEMENT"]
[null,null,null,null,null,null,null,"Cost",null,"P / F",null,"PRESENT WORTH"]
[null,null,null,"Initial",null,{"$f":"IF(SUM(Flexible!$K$20:$K$39)=0,\"\",SUM(Flexible!$K$20:$K$39))","v":""},null,null,"*",{"$f":"(1/((1+K8)^0))","v":1},"=",{"$f":"IF(OR($F26=\"\",$J26=\"\"),\"\",($F26*$J26))","v":""}]
[null,null,{"$f":"IF(Flexible!$F$41=\"\",\"\",Flexible!$F$41)","v":""},"Year",null,{"$f":"IF(SUM(Flexible!$K$43:$K$57)=0,\"\",SUM(Flexible!$K$43:$K$57))","v":""},null,null,"*",{"$f":"(IF(F27=\"\",\"\",(1/((1+K8)^$C27))))","v":""},"=",{"$f":"IF(OR($F27=\"\",$J27=\"\"),\"\",($F27*$J27))","v":""}]
[null,null,{"$f":"IF(Flexible!$F$59=\"\",\"\",Flexible!$F$59)","v":""},"Year",null,{"$f":"IF(SUM(Flexible!$K$61:$K$75)=0,\"\",SUM(Flexible!$K$61:$K$75))","v":""},null,null,"*",{"$f":"(IF(F28=\"\",\"\",(1/((1+K8)^$C28))))","v":""},"=",{"$f":"IF(OR($F28=\"\",$J28=\"\"),\"\",($F28*$J28))","v":""}]
[null,null,{"$f":"IF(Flexible!$F$77=\"\",\"\",Flexible!$F$77)","v":""},"Year",null,{"$f":"IF(SUM(Flexible!$K$79:$K$93)=0,\"\",SUM(Flexible!$K$79:$K$93))","v":""},null,null,"*",{"$f":"(IF(F29=\"\",\"\",(1/((1+K8)^$C29))))","v":""},"=",{"$f":"IF(OR($F29=\"\",$J29=\"\"),\"\",($F29*$J29))","v":""}]
[null,null,{"$f":"IF(Flexible!F95=\"\",\"\",Flexible!F95)","v":""},"Year"]
[null,null,null,null,null,null,null,null,null,"TOTAL AGENCY COSTS","=",{"$f":"IF($L$26=\"\",\"\",SUM($L$26,$L$27,$L$28,$L$29))","v":""}]
[null,null,null,null,null,null,null,null,null,"USER COSTS","=",null,null,null,"<---  Enter User Costs Here"]
[null,null,null,null,null,null,null,null,null,"PW of Last Rehab"]
[null,null,null,null,null,null,"Remaining Service Life",null,null,"at Year 40"]
[null,null,"SALVAGE VALUE",null,null,{"$f":"IF(C27=\"\",\"\",IF(C27>=40,C27-40,IF(C28>=40,C28-40,IF(C29>=40,C29-40,C30-40))))","v":""},"/",{"$f":"IF(C28=\"\",C27,IF(C29=\"\",C28-C27,IF(C30=\"\",C29-C28,C30-C29)))","v":""},"*",{"$f":"IF(F26=\"\",\"\",IF(F27=\"\",F26*(1/((1+$K$8)^40)),IF(F28=\"\",F27*(1/((1+$K$8)^40)),IF(F29=\"\",F28*(1/((1+$K$8)^40)),F29*(1/((1+$K$8)^40))))))","v":""},"=",{"$f":"IF(F35=\"\",\"\",IF(J35=\"\",\"\",(F35/H35)*J35))","v":""}]
[null,null,null,null,null,null,null,null,null,"TOTAL PRESENT WORTH LIFE-CYCLE COSTS","=",{"$f":"IF(L31=\"\",\"\",L31+L32-L35)","v":""}]
[]
[null,"COST COMPARISON"]
[null,null,null,null,null,null,null,null,null,"DIFFERENCE IN TOTAL PRESENT WORTH LIFE-CYCLE COSTS","=",{"$f":"IF(L22=\"\",\"\",IF(L36=\"\",\"\",ABS(L22-L36)))","v":""}]
[null,null,null,null,null,null,null,null,null,"AVERAGE TOTAL PRESENT WORTH","=",{"$f":"IF(L39=\"\",\"\",(L22+L36)/2)","v":""}]
[null,null,null,null,null,null,null,null,null,"PERCENT DIFFERENCE IN TOTAL PRESENT WORTH","=",{"$f":"IF(L40=\"\",\"\",L39/L40)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,"DIFFERENCE IN ESTIMATED INITIAL COSTS","=",{"$f":"IF(F12=\"\",\"\",IF(F26=\"\",\"\",ABS(F12-F26)))","v":""}]
[null,null,null,null,null,null,null,null,null,"PERCENT DIFFERENCE IN ESTIMATED INITIAL COSTS","=",{"$f":"IF(L43=\"\",\"\",L43/L26)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,"TOTAL PRESENT WORTH COST OF REHAB FOR PCC PAVEMENT","=",{"$f":"IF(L13=\"\",\"\",SUM(L13:L15))","v":""}]
[null,null,null,null,null,null,null,null,null,"TOTAL PRESENT WORTH COST OF REHAB FOR AC PAVEMENT","=",{"$f":"IF(L27=\"\",\"\",SUM(L27:L29))","v":""}]
[null,null,null,null,null,null,null,null,null,"DIFFERENCE IN TOTAL PRESENT WORTH OF REHAB COSTS (LCCF)","=",{"$f":"IF(L46=\"\",\"\",IF(L47=\"\",\"\",ABS(L46-L47)))","v":""}]

{"sheet":"Advanced Report","index":8,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":true,"merged":[[5,0,5,4],[6,0,6,4],[7,0,7,4],[1,0,1,4],[2,0,2,4],[3,0,3,4]]}
[]
["FLORIDA DEPARTMENT OF TRANSPORTATION"]
["PAVEMENT TYPE SELECTION"]
["DETAILED ECONOMIC ANALYSIS REPORT"]
[]
[{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7 &\", \" & \"SR No.-\" &'Basic Inputs'!$D$8 & \", \" & \"County:\" & 'Basic Inputs'!$D$9)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$7 & 'Basic Inputs'!$D$7)","v":""}]
[{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$10&\" \"&'Basic Inputs'!$D$10&\", \"&'Basic Inputs'!$C$11&\" \"&'Basic Inputs'!$D$11)","v":""}]
[{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$12&\" \"&'Basic Inputs'!$D$12&\", \"&'Basic Inputs'!$C$13&\" \"&'Basic Inputs'!$D$13)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$12&\" \"&'Basic Inputs'!$D$12&\", \"&'Basic Inputs'!$C$13&\" \"&'Basic Inputs'!$D$13)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$12&\" \"&'Basic Inputs'!$D$12&\", \"&'Basic Inputs'!$C$13&\" \"&'Basic Inputs'!$D$13)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$12&\" \"&'Basic Inputs'!$D$12&\", \"&'Basic Inputs'!$C$13&\" \"&'Basic Inputs'!$D$13)","v":""},{"$f":"IF('Basic Inputs'!$D$7=\"\",\"\",'Basic Inputs'!$C$12&\" \"&'Basic Inputs'!$D$12&\", \"&'Basic Inputs'!$C$13&\" \"&'Basic Inputs'!$D$13)","v":""}]
[]
[]
["Analysis Period: 40 Years"]
["Discount Rate: 3.5%"]
["Note: This Analysis Assumes a St. Dev. of +/- 2 for Calculation of Lower & Higher Side Present Worth Values"]
[]
[null,"Cost","Lower Side","PW","Higher Side"]

{"sheet":"Instructions","index":9,"n_rows":283,"n_cols":6,"rows_kept":283,"cut":false,"hidden":false,"merged":[[2,3,2,5],[58,3,58,5],[129,3,129,5],[145,3,145,5],[5,0,5,2],[6,0,6,2],[7,0,7,2],[277,3,277,5],[278,3,278,5],[8,0,8,2],[178,3,178,5],[214,3,214,5],[236,3,236,5],[276,3,276,5],[274,3,274,5],[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[281,3,281,5],[282,3,282,5],[283,3,283,5],[279,3,279,5],[280,3,280,5]]}
["INDEX"]
["Simple Instructions"]
["Formulae",null,null,"INSTRUCTIONS"]
["Change Design Options Form"]
["Pavement Definitions"]
["Advanced Life Cycle Cost Analysis",null,null,"1.","Click the 'Select Roadway Typical Sections LCCA Data' button to load typical"]
["Graphs",null,null,null,"highway construction pay items and design options. Clicking this button will do the"]
["Saving and Retrieving Data",null,null,null,"following:"]
["Contact Information"]
[null,null,null,null,"i.","Create a list of typical construction items and the respective units that they are measured in."]
[null,null,null,null,"ii.","Loads all pertinent highway design section information, including number and width of travel and passing lanes and shoulders."]
[null,null,null,null,"iii.","The net pavement and shoulder area is calculated automatically."]
[null,null,null,null,"iv.","By default, 2 pavement design alternatives are provided as part of the template. One each for flexible and rigid pavement design. In addition, a third alternate pavement design is also provided. For example, this may be a composite pavement."]
[null,null,null,null,"v.","Assuming a typical pavement design, the various construction items associated with it are loaded into the respective sheets."]
[null,null,null,null,"vi.","A list of typical construction items (Pay Items) are loaded in the Unit Prices sheet."]
[null,null,null,null,"vii.","In addition, the various items required for rehabilitation are also loaded. Rehabilitation for Flexible (Asphalt) Pavement takes place in Years 14, 28, and 42 whereas Rehabilitation for Rigid (Concrete) Pavement takes place in Years 20, 30 and 40."]
[null,null,null,null,"viii.","The final rehab must occur in Year 40 or beyond.  The final rehab period will not have any Pay Items or Mean Costs associated with it.  This rehab is used to calculate Salvage Value."]
[null,null,null,null,"ix.","The years in which Rehabilitation takes place can be changed as seen necessary. A fourth rehabilitation period is also provided."]
[null,null,null,null,"x.","Type in the Mean Costs associated with each of the Pay Items. The option to enter the Standard Deviation is also provided."]
[null,null,null,null,"xi.","In case accurate data for St.Dev are not available, a standard value of 10% of the mean cost price of the Pay Item may be assumed."]
[]
[null,null,null,"2.","Users are encouraged to follow the links on the Unit Prices sheet and confirm"]
[null,null,null,null,"mean construction Pay Item costs for their specific location from the Master Pay"]
[null,null,null,null,"Item list."]
[]
[null,null,null,"3.","Once these costs are entered, select any of the LCC sheets. The cost prices and"]
[null,null,null,null,"standard deviations are updated automatically."]
[]
[null,null,null,"4.","Double check the number of travel and passing lanes, widths for travel, passing"]
[null,null,null,null,"lanes, inside and outside shoulders.  Usually, the number of travel directions is 2."]
[null,null,null,null,"In special cases, a one-direction roadway may be considered such as an"]
[null,null,null,null,"experimental section of a road, toll plaza, rest area or a weighing station."]
[]
[null,null,null,"5.","In the LCC sheets, the common materials used in pavement construction (for that"]
[null,null,null,null,"particular example selected) have already been input."]
[]
[null,null,null,"6.","Enter the appropriate layer thickness in inches. For pay items based on pavement "]
[null,null,null,null,"area, ex.. Milling, enter '1' as thickness. A thickness is required to invoke the VBA"]
[null,null,null,null,"code to enter the appropriate formula for quantity calculation."]
[]
[null,null,null,"7.","Add or remove construction items as deemed necessary. A drop down list of the"]
[null,null,null,null,"previously input construction pay items appears in the cell. After selecting the item"]
[null,null,null,null,"the Message Box will display Help Messages on what to enter in the Thk. Column."]
[]
[null,null,null,"8.","The Analysis Period is fixed at 40 Years and the Discount Rate is fixed at 3.5%."]
[]
[null,null,null,"9.","The Report Sheet shows a standard one-page report."]
[]
[null,null,null,"10.","The Graphs sheet provides the user with additional information about the Present"]
[null,null,null,null,"Worths of different construction items. Click the 'Refresh Graphs' button to create"]
[null,null,null,null,"graphs of the Original Construction and Rehabilitation pay items."]
[null,null,null,null,"Note: At present this has been set up only for Flexible and Rigid Pavement designs."]
[]
[null,null,null,"11.","If the Advanced Life Cycle Cost Option has been selected, the 'Advanced Report'"]
[null,null,null,null,"sheet will be visible. Click the 'Generate Report' button to generate a full Life Cycle"]
[null,null,null,null,"Cost Report. The details about its calculations are provided further on."]
[]
[]
[null,null,null,"FORMULAE"]
[]
[null,null,null,"1.","One of the biggest challenges in designing this spreadsheet was to automate the"]
[null,null,null,null,"formulae used in calculation of construction quantities. Since the quantity of any "]
[null,null,null,null,"given item depends upon the units it is measured in, the units of measurement are"]
[null,null,null,null,"very important and need to be specified in the Unit Prices Sheet."]
[]
[null,null,null,"2.","Currently, the following units of measure have been defined:"]
[null,null,null,null,"i.","Cu. Yd  - Cubic Yards"]
[null,null,null,null,"ii.","Each - Each Item"]
[null,null,null,null,"iii.","Ft - Linear Feet"]
[null,null,null,null,"iv.","Gal. - Gallons"]
[null,null,null,null,"v","In - Inches"]
[null,null,null,null,"vi.","Sq. Ft - Square Feet"]
[null,null,null,null,"vii.","Sq. Yd - Square Yards"]
[null,null,null,null,"viii.","Ton - Tons (2000lbs  = 1 Ton)"]
[]
[null,null,null,null,"These units are listed in cell \"O5\" of the Unit Prices sheet. There is space for 2"]
[null,null,null,null,"more units if necessary. All of these entries will be available in the main table."]
[]
[null,null,null,null,"Note that calculation formulae will be entered automatically for the units defined in"]
[null,null,null,null,"Part 2 above only. "]
[]
[null,null,null,"3.","Enter a Pay Item in the table, and select the relevant measurement unit from the "]
[null,null,null,null,"drop down box."]
[]
[null,null,null,"4. ","For Standard deviation, a typical value of 10% of the mean construction item cost"]
[null,null,null,null,"can be assumed. The standard deviation is used only in the Advanced LCC."]
[]
[null,null,null,"5.","Specific Formulae"]
[]
[null,null,null,null,null,"Cu.Yd = Volume = Based on mainline (or shoulder area) and lift thickness"]
[null,null,null,null,null,"Each = Individual = Based on each Item"]
[null,null,null,null,null,"Ft = Length = This is a special case, where the linear feet of that item need"]
[null,null,null,null,null,"                        to be entered, Ex. 1000 Ft of Crack Sealing"]
[null,null,null,null,null,"Gal. = Volume = Based on mainline (or shoulder area) and spread rate,"]
[null,null,null,null,null,"                            Ex. Tack Coat at 0.5 Gal/Sq.Yd"]
[null,null,null,null,null,"In = Length = Inches of a pavement layer"]
[null,null,null,null,null,"Sq. Ft = Area = Based on mainline (or shoulder area)"]
[null,null,null,null,null,"Sq.Yd = Area = (Sq.Ft / 9)"]
[null,null,null,null,null,"Tons = Mass = Based on pavement (or shoulder area), lift thickness & density."]
[]
[null,null,null,"6. ","Special Cases:"]
[]
[null,null,null,null,"i.","Sometimes, AC mix can be specified as a pay item in Tons or in Lbs/Sq.Yd/In."]
[null,null,null,null,null,"For example if the Pay Item is defined as 'Type SP Traffic Level C Mix"]
[null,null,null,null,null,"(110 Lbs/Sq.Yd/1 In Spread rate)', then enter 'Sq.Yd' as the unit of measure."]
[null,null,null,null,null,"This is because the pay item is already specific for thickness of lift (1 In)"]
[null,null,null,null,null,"and the total quantity (and cost) will be dependent only on the total area."]
[]
[null,null,null,null,null,"If the Pay Item is defined in Tons, it is necessary to know the material density."]
[null,null,null,null,null,"A calculator is provided in the 'Change Design Options' form to convert a "]
[null,null,null,null,null,"given spread rate from Lbs/Sq.Yd/In to Lbs/Cu.Ft. Enter the spread rate and click"]
[null,null,null,null,null,"the Calculate button, and then type in the density in the appropriate box above."]
[]
[null,null,null,null,"ii.","It is not possible to automate the quantity formula if the measurement unit is Ft."]
[null,null,null,null,null,"This is because the linear feet can depend on a number of variables such as"]
[null,null,null,null,null,"length of section, number of lanes, travel directions, etc."]
[null,null,null,null,null,"For example, the quantity of edge drain pipe is related to the section length"]
[null,null,null,null,null,"but the quantity of crack sealing is a known number in feet."]
[]
[null,null,null,null,"iii.","CPR-Slab Replacement: Since this pay item is based on volume (Cu.Yd), the "]
[null,null,null,null,null,"formula looks for the word 'CPR' in the Unit Prices Table.  Therefore please"]
[null,null,null,null,null,"make sure you have the word 'CPR' while refering to Slab Replacement."]
[]
[]
[null,null,null,"7.","Design, CEI and MOT costs"]
[]
[null,null,null,null,null,"Enter these costs as a percentage in the cell, Ex. Enter 10 for 10% MOT cost."]
[]
[]
[null,null,null,"CHANGE DESIGN OPTIONS FORM"]
[]
[null,null,null,"1.","This form has been provided to give Users an opportunity to change the design"]
[null,null,null,null,"options as necessary."]
[]
[null,null,null,"2.","Various material densities, spread rates and slab dimensions can be input."]
[]
[null,null,null,"3.","A calculator is also provided to convert from Lbs/Sq.Yd/In to Lbs/Cu.Ft."]
[]
[null,null,null,"4.","Click the Default Values button to revert to sample default values."]
[]
[null,null,null,"5.","Click the save changes button to accept the changes. These values are stored in"]
[null,null,null,null,"cell \"S2\" and further in each LCC sheet, and then used in subsequent calculations."]
[]
[]
[]
[null,null,null,"PAVEMENT DEFINITIONS"]
[]
[null,null,null,"1.","Each LCC sheet has the following input cells that define the pavement section "]
[null,null,null,null,"under consideration"]
[]
[null,null,null,null,"i.","Length of section - Typically 1-mile for analysis purposes (5280 Ft.)"]
[]
[null,null,null,null,"ii.","Passing lane width - (Inside lane/s) - Typically 12 Ft."]
[]
[null,null,null,null,"iii.","Travel lane width - (Outside lane) - Typically 12 Ft."]
[]
[null,null,null,null,"iv.","Inside and Outside Shoulder width - Enter width in Ft."]
[]
[null,null,null,null,"v.","Analysis Period - 40 Years"]
[]
[null,null,null,null,"vi.","Discount rate - 3.5%"]
[]
[null,null,null,null,"vii.","Initial year of construction"]
[]
[null,null,null,null,"viii.","Number of Passing lanes - Number of passing lanes in EACH direction"]
[]
[null,null,null,null,"ix.","Number of Travel lanes - Number of travel lanes in EACH direction"]
[]
[null,null,null,null,"x.","Number of Travel Directions - Typically 2."]
[null,null,null,null,null,"Therefore, for a 2 lane highway, the number of passing lanes is 0, number of"]
[null,null,null,null,null,"travel lanes is 1, and number of travel directions is 2"]
[]
[null,null,null,"2.","Note: for rigid pavements, the slab dimensions will determine the total length of "]
[null,null,null,null,"longitudinal and transverse joints. Change the dimensions if necessary in the "]
[null,null,null,null,"Change Design Options Form."]
[]
[]
[]
[null,null,null,"ADVANCED LIFE CYCLE COST ANALYSIS"]
[]
[null,null,null,"1.","The methodology adopted for this Life Cycle Cost Analysis spreadsheet is purely "]
[null,null,null,null,"deterministic. That is, one fixed, mean cost price of a pay item is used to calculate"]
[null,null,null,null,"the total cost and present worth. This method does not take into account the "]
[null,null,null,null,"variability associated with market prices that fluctuate very often. Thus, the "]
[null,null,null,null,"standard deviation of any pay item is not necessary, if the 'Advanced LCC' option"]
[null,null,null,null,"is not selected in the Unit Prices sheet."]
[]
[null,null,null,"2.","In lieu of expensive probabilistic analysis software, the Advanced Life Cycle Cost"]
[null,null,null,null,"Analysis uses a simpler approach. By incorporating the standard deviation along"]
[null,null,null,null,"with the mean cost of a pay item, it is possible to calculate a 'high' and a 'low' cost"]
[null,null,null,null,"(and present worth) for each item."]
[]
[null,null,null,"3.","As a default, +/- 2 standard deviations are employed in the calculations."]
[null,null,null,null,"For example, assume an ITEM A with a Mean Cost of $100, and a Stdev of $10."]
[null,null,null,null,"Let us calculate the total cost for 10 units."]
[null,null,null,null,"Therefore:"]
[null,null,null,null,"Mean cost (for normal or deterministic analysis) is = $100 * 10 = $1000"]
[null,null,null,null,"Low cost (for Advanced LCC analysis) is = ($100 - (2*$10)) * 10 = $800"]
[null,null,null,null,"High cost (for Advanced LCC analysis) is = ($100 + (2*$10)) * 10 = $1200"]
[]
[null,null,null,null,"Thus, this item will typically vary in cost from $800 to $1200."]
[]
[null,null,null,"4.","When the Advanced LCC option is selected, an additional report sheet named"]
[null,null,null,null,"Advanced Report is visible. Click the 'Generate Report' button to generate a full"]
[null,null,null,null,"detailed report. This report shows the actual cost of the pay item (in today's dollars)"]
[null,null,null,null,"along with Low, Normal and High Present Worths calculated by employing the "]
[null,null,null,null,"standard deviation of the item (+/- 2)"]
[]
[null,null,null,"5.","This option will generally not be used by most users, but has still been provided to"]
[null,null,null,null,"give experienced users a complete range of costs that can be associated with"]
[null,null,null,null,"their pavement design alternative."]
[]
[]
[]
[null,null,null,"GRAPHS"]
[]
[null,null,null,"1.","The graphing sheet provides additional information on the costs associated with "]
[null,null,null,null,"various construction items."]
[]
[null,null,null,"2.","This same information is available on the individual LCC sheets, but the graphic"]
[null,null,null,null,"information has been provided for additional ease of use."]
[]
[null,null,null,"3.","An extensive graphing algorithm was developed to gather and group the various"]
[null,null,null,null,"pay items, sort them in descending order and represent them graphically."]
[]
[null,null,null,"4.","This graphing algorithm has been developed for the deterministic analysis only, "]
[null,null,null,null,"and for Flexible and Rigid pavement design alternatives only."]
[null,null,null,null,"i.e.. The graphs will not show a high or low PW even if the Advanced LCCA option"]
[null,null,null,null,"is selected. The graphs show only the Normal Present Worth."]
[]
[null,null,null,"5.","Most users will not use the third pavement option (Alternate sheet) and therefore the "]
[null,null,null,null,"graphs only reflect construction and rehabilitation items for flexible and rigid"]
[null,null,null,null,"pavements."]
[]
[]
[]
[null,null,null,"SAVING AND RETRIEVING DATA"]
[]
[null,null,null,"1.","Another useful tool included with this spreadsheet is a tool for storing and retrieving"]
[null,null,null,null,"previously stored data. This data is stored in the current file in a Database."]
[]
[null,null,null,"2.","As part of the original spreadsheet, 7 typical roadway design templates and 3 "]
[null,null,null,null,"examples are provided."]
[]
[null,null,null,"3.","Please note that the examples are for information purposes only. All the costs have "]
[null,null,null,null,"been completely assumed. Do not use these examples to continue your work."]
[]
[null,null,null,"4.","Select a type of roadway design from the drop down box from the 'Retrieve Data'"]
[null,null,null,null,"form."]
[]
[null,null,null,"5.","As explained earlier, typical pay items, roadway design options, initial construction"]
[null,null,null,null,"items and rehabilitation items will be loaded into LCC sheets."]
[]
[null,null,null,"6.","Overwrite the information in the Basic Inputs sheet to match your current project."]
[]
[null,null,null,"7.","It is highly recommended that the User perform random checks to verify quantity"]
[null,null,null,null,"and cost calculations."]
[]
[null,null,null,"8.","After all the data is entered and the spreadsheet checked for calculations, click the "]
[null,null,null,null,"'Save Data' button. All data that is in blue cells, will be saved to the database."]
[]
[null,null,null,"9.","Your data will be stored with a unique identifier. This unique identifier is a "]
[null,null,null,null,"combination of Financial Project ID, State Road Number, and Design Version."]
[]
[null,null,null,"10.","The code has been written to check the database if this combination already exists"]
[null,null,null,null,"and will warn if you an identical match is found."]
[]
[null,null,null,"11.","If an identical match is found, change your design version (in the Basic Inputs Sheet)"]
[null,null,null,null,"say for example, from Version-1 to Version-2"]
[]
[null,null,null,"12.","Please do not over-write any of the previously stored templates!"]
[]
[]
[]
[null,null,null,"CONTACT INFORMATION"]
[]
[null,null,null,"For information or questions regarding this spreadsheet please contact:"]
[]
[null,null,null,"Florida Department of Transportation"]
[null,null,null,"Pavement Management Section"]
[null,null,null,"605 Suwannee Street, MS-32"]
[null,null,null,"Tallahassee, FL 32399-0450"]
[null,null,null,"Tel: (850) 414-4158"]