{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Overview","Instructions","General Information","Pay_Items","Database","Maintenance Policies","TMP(NewHMA)","TMP(NewPCC)","TMP(HMARehab)","TMP(PCCRehab)","Summary"],"not_rendered":{"charts":4,"images":63,"macros":1,"external_links":2,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Tennessee Department of Transportation"]
[null,null,null,null,"Aeronautics Division"]
[null,null,null,null,"7335 Centennial Boulevard"]
[null,null,null,null,"Nashville, Tennessee 37209"]
[null,null,null,null,"615-741-3208"]
[null,null,null,null,"https://www.tn.gov/tdot/aeronautics.html"]
[]
[null,"Overview:"]

{"sheet":"Instructions","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Tennessee Department of Transportation"]
[null,null,null,null,"Aeronautics Division"]
[null,null,null,null,"7335 Centennial Boulevard"]
[null,null,null,null,"Nashville, Tennessee 37209"]
[null,null,null,null,"615-741-3208"]
[null,null,null,null,"https://www.tn.gov/tdot/aeronautics.html"]
[]
[null,"Instructions:"]

{"sheet":"General Information","index":2,"n_rows":88,"n_cols":19,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Hidden"]
[null,"Airport Information:",null,null,null,null,null,null,null,null,null,"Name","ID","City","County","Region","Owner",null,"Branch Use"]
[null,null,"Airport Name:",null,null,null,null,null,null,null,null,null,null,"N/A","N/A"]
[null,null,"Airport ID:",{"$f":"IF(D9=\"\",\"N/A\",VLOOKUP(Airport_Name,Table17[],2))","v":"N/A"},null,null,null,null,null,null,null,"Abernathy Field","GZS","Pulaski","Giles","Middle",null,null,"Runway"]
[null,null,"City:",{"$f":"IF(D9=\"\",\"N/A\",VLOOKUP(Airport_Name,Table17[],3))","v":"N/A"},null,null,null,null,null,null,null,"Arnold Field","M31","Halls","Lauderdale","West",null,null,"Taxiway"]
[null,null,"Airport Owner:",{"$f":"IF(D9=\"\",\"N/A\",VLOOKUP(Airport_Name,Table17[],6))","v":"N/A"},null,null,null,null,null,null,null,"Beech River Regional Airport","PVE","Lexington/Parsons","Henderson","West",null,null,"Apron"]
[null,null,"State Region:",{"$f":"IF(D9=\"\",\"N/A\",VLOOKUP(Airport_Name,Table17[],5))","v":"N/A"},null,null,null,null,null,null,null,"Benton County Airport","0M4","Camden","Benton","West"]
[null,null,"Design Consultant:",null,null,null,null,null,null,null,null,"Bomar Field-Shelbyville Municipal Airport","SYI","Shelbyville","Bedford","Middle"]
[null,null,"Project Number:",null,null,null,null,null,null,null,null,"Carroll County Airport","HZD","Huntingdon","Carroll","West",null,null,"Markings Type"]
[null,null,"Project Name:",null,null,null,null,null,null,null,null,"Centerville Municipal Airport","GHM","Centerville","Hickman","Middle"]
[null,null,"Date of LCCA:",null,null,null,null,null,null,null,null,"Charles W. Baker Field","2M8","Millington","Shelby","West",null,null,"Reflective"]
[null,null,null,null,null,null,null,null,null,null,null,"Chilhowee Gliderport","92A","Benton","Polk","East",null,null,"Non-Reflective"]
[null,null,null,null,null,null,null,null,null,null,null,"Cleveland Regional Jetport","RZR","Cleveland","Bradley","East"]
[null,"Project Information:",null,null,null,null,null,null,null,null,null,"Collegedale Municipal Airport","FGU","Collegedale","Hamilton","East"]
[null,null,"Branch Type:",null,null,null,null,null,null,null,null,"Colonel Tommy C. Stiner-Campbell County Airport","JAU","Jacksboro","Campbell","East",null,null,"Weight Category"]
[null,null,"Branch Name:",null,null,null,null,null,null,null,null,"Covington Municipal Airport","M04","Covington","Tipton","West"]
[null,null,"Project Type:",null,null,null,null,null,null,null,null,"Crossville Memorial Airport/Whitson Field","CSV","Crossville","Cumberland","East",null,null,"< 60,000 lbs"]
[null,null,"Project Description:",null,null,null,null,null,null,null,null,"Dallas Bay Skypark Airport","1A0","Chattanooga","Hamilton","East",null,null,"> 60,000 to < 100,000 lbs"]
[null,null,"Intial Construction Year:",null,null,null,null,null,null,null,null,"Dickson Municipal Airport","M02","Dickson","Dickson","Middle",null,null,"> 100,000 lbs"]
[null,null,"Mainline Area, S.Y.:",null,null,null,null,null,null,null,null,"Dyersburg Municipal Airport","DYR","Dyersburg","Dyer","West"]
[null,null,"Shoulder Area, S.Y.:",null,null,null,null,null,null,null,null,"Elizabethton Municipal Airport","0A9","Elizabethton","Carter","East"]
[null,null,"Markings, S.F.:",null,null,null,null,null,null,null,null,"Ellington Airport","LUG","Lewisburg","Marshall","Middle"]
[null,null,"Markings, Type:",null,null,null,null,null,null,null,null,"Everett-Stewart Airport","UCY","Union City","Obion","West"]
[null,null,null,null,null,null,null,null,null,null,null,"Fayette County Airport","FYE","Somerville","Fayette","West"]
[null,null,null,null,null,null,null,null,null,null,null,"Fayetteville Municipal Airport","FYM","Fayetteville","Lincoln","Middle"]
[null,"LCCA Parameters:",null,null,null,null,null,null,null,null,null,"Franklin County Airport","UOS","Sewanee","Franklin","Middle"]
[null,null,"Analysis Period, years:",30,null,null,null,null,null,null,null,"Gatlinburg-Pigeon Forge Airport","GKT","Sevierville","Sevier","East"]
[null,null,"Discount Rate, percent:",3,null,null,null,null,null,null,null,"General Dewitt Spain Airport","M01","Memphis","Shelby","West"]
[null,null,"Salvage Value, $:","Remaining service life at end of analysis period (as percent of cost)",null,null,null,null,null,null,null,"Gibson County Airport","TGC","Trenton","Gibson","West"]
[null,null,"Mobilization, percent:",10,null,null,null,null,null,null,null,"Greeneville-Green County Municipal Airport","GCY","Greeneville","Greene","East"]
[null,null,"Engineering, percent:",5,null,null,null,null,null,null,null,"Hassell-Carroll Field","M29","Clifton","Wayne","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Hawkins County Airport","RVN","Rogersville","Hawkins","East"]
[null,"Alternative Setup:",null,null,null,null,null,null,null,null,null,"Henry County Airport","PHT","Paris","Henry","West"]
[null,null,null,null,null,null,null,null,null,null,null,"Houston County Airport","M93","McKinnon","Houston","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Humboldt Municipal Airport","M53","Humboldt","Gibson","West"]
[null,null,null,null,null,null,null,null,null,null,null,"Humphreys County Airport","0M5","Waverly","Humphreys","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Jackson County Airport","1A7","Gainesboro","Jackson","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"James Tucker-Perry County Airport","M15","Linden","Perry","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Jamestown Municipal Airport","2A1","Jamestown","Fentress","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"John A. Baker Field","0M3","Hohenwald","Lewis","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"John C. Tune Airport","JWN","Nashville","Davidson","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Johnson City Airport","0A4","Johnson City","Washington","East"]
[null,null,null,null,null,null,null,null,null,null,null,"Johnson County Airport","6A4","Mountain City","Johnson","East"]
[null,null,null,null,null,null,null,null,null,null,null,"Knoxville Downtown Island Airport","DKX","Knoxville","Knox","East"]
[null,null,null,null,null,null,null,null,null,null,null,"Lafayette Municipal Airport","3M7","Lafayette","Macon","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Lawrenceburg-Lawrence County Airport","2M2","Lawrenceburg","Lawrence","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Lebanon Municipal Airport","M54","Lebanon","Wilson","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Livingston Municipal Airport","8A3","Livingston","Overton","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Lovell Field","CHA","Chattanooga","Hamilton","East"]
[null,null,null,null,null,null,null,null,null,null,null,"Marion County Airport-Brown Field","APT","Jasper","Marion","East"]
[null,null,null,null,null,null,null,null,null,null,null,"Mark Anton Airport","2A0","Dayton","Rhea","East"]
[null,null,null,null,null,null,null,null,null,null,null,"Martin Campbell Field","1A3","Copperhill","Polk","East"]
[null,null,null,null,null,null,null,null,null,null,null,"Maury County Airport","MRC","Columbia","Maury","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"McGhee Tyson Airport","TYS","Knoxville","Blount","East"]
[null,null,null,null,null,null,null,null,null,null,null,"McKellar-Sipes Regional Airport","MKL","Jackson","Madison","West"]
[null,null,null,null,null,null,null,null,null,null,null,"McMinn County Airport","MMI","Athens","Mcminn","East"]
[null,null,null,null,null,null,null,null,null,null,null,"Memphis International Airport","MEM","Memphis","Shelby","West"]
[null,null,null,null,null,null,null,null,null,null,null,"Millington Regional Jetport","NQA","Millington","Shelby","West"]
[null,null,null,null,null,null,null,null,null,null,null,"Monroe County Airport","MNV","Madisonville","Monroe","East"]
[null,null,null,null,null,null,null,null,null,null,null,"Moore-Murrell Field","MOR","Morristown","Hamblen","East"]
[null,null,null,null,null,null,null,null,null,null,null,"Murfreesboro Municipal Airport","MBT","Murfreesboro","Rutherford","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Music City Executive Airport","XNX","Gallatin","Sumner","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Nashville International Airport","BNA","Nashville","Davidson","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"New Tazewell Municipal Airport","3A2","Tazewell","Claiborne","East"]
[null,null,null,null,null,null,null,null,null,null,null,"Outlaw Field","CKV","Clarksville","Montgomery","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Portland Municipal Airport","1M5","Portland","Sumner","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Puckett Airport","50M","Eagleville","Bedford","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Reelfoot Lake Airport","0M2","Tiptonville","Lake","West"]
[null,null,null,null,null,null,null,null,null,null,null,"Robert Sibley Airport","SZY","Selmer","Mcnairy","West"]
[null,null,null,null,null,null,null,null,null,null,null,"Rockwood Municipal Airport","RKW","Rockwood","Morgan","East"]
[null,null,null,null,null,null,null,null,null,null,null,"Savannah-Hardin County Airport","SNH","Savannah","Hardin","West"]
[null,null,null,null,null,null,null,null,null,null,null,"Scott Municipal Airport","SCX","Oneida","Scott","East"]
[null,null,null,null,null,null,null,null,null,null,null,"Smithville Municipal Airport","0A3","Smithville","Dekalb","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Smyrna Airport","MQY","Smyrna","Rutherford","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Springfield-Robertson County Airport","M91","Springfield","Robertson","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Tri-Cities Airport","TRI","Bristol/Johnson/Kingsport","Sullivan","East"]
[null,null,null,null,null,null,null,null,null,null,null,"Tullahoma Regional Airport/Northern Field","THA","Tullahoma","Coffee","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Upper Cumberland Regional Airport","SRB","Sparta","White","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Warren County Memorial Airport","RNC","McMinnville","Warren","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"William L. Whitehurst Field","M08","Bolivar","Hardeman","West"]
[null,null,null,null,null,null,null,null,null,null,null,"Winchester Municipal Airport","BGF","Winchester","Franklin","Middle"]
[null,null,null,null,null,null,null,null,null,null,null,"Wolf River","54M","Rossville","Fayette","West"]

{"sheet":"Pay_Items","index":3,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,6,0,8]]}
[null,null,null,null,null,null,"Average Pay Item Unit Cost"]
["Division","Division Type","Pay Item No.","Pay Item Description","Units","Unit Cost","Middle","West","East"]
[null,"Default",null,null,"N/A","N/A"]
["Part 3 – Sitework","Sitework","P-101-5.1a","Pavement Removal, Asphalt","S.Y.",4.2,null,null,null,"Thickness adjustment or multiple"]
[null,"Sitework","P-101-5.1b","Pavement Removal, Concrete","S.Y.",null,null,null,null,"Thickness adjustment or multiple"]
[null,"Sitework","P-101-5.2a","Crack Repair (Type I), Asphalt","L.F.",4]
[null,"Sitework","P-101-5.2b","Crack Repair (Type II), Asphalt","L.F.",6.5]
[null,"Sitework","P-101-5.2c","Crack Seal, Concrete","L.F.",8]
[null,"Sitework","P-101-5.2d","Crack Repair, Concrete","L.F.",8.5]
[null,"Sitework","P-101-5.3","Markings Removal","S.F.",{"$f":"7/9","v":0.77777777777777779}]
[null,"Sitework","P-101-5.4a","Spall Repair, Asphalt","S.F.",8.5,null,null,null,"Thickness adjustment or multiple"]
[null,"Sitework","P-101-5.4b","Full-Depth Repair, Asphalt","S.F.",null,null,null,null,"Assumed Section: 4-inch HMA; 4-inch P-209"]
[null,"Sitework","P-101-5.5a","Spall Repair, Concrete","S.F.",60,null,null,null,"Thickness adjustment or multiple"]
[null,"Sitework","P-101-5.5b","Full-Depth Repair, Concrete","S.Y.",120,null,null,null,"Thickness adjustment or multiple"]
[null,"Sitework","P-101-5.5c","Slab Replacement, Concrete","S.Y.",100]
[null,"Sitework","P-101-5.6","Cold Milling","S.Y.",{"$f":"10/2","v":5},null,null,null,"Thickness adjustment or multiple"]
[null,"Sitework","P-152-4.1","Unclassified Excavation","C.Y."]
[null,"Sitework","P-152-4.2","Embankment In-Place","C.Y."]
[null,"Sitework","P-154-5.1","Subbase Course","C.Y.",55]
[null,"Sitework","P-154-5.2","Separation geotextile","S.Y."]
[null,"Sitework","P-155-8.1","Lime Treated subgrade","S.Y.",10,null,null,null,"Thickness adjustment or multiple"]
[null,"Sitework","P-156-8.1","Cement-Treated Subgrade","S.Y.",null,null,null,null,"Thickness adjustment or multiple"]
[null,"Sitework","P-157-8.1a","Cement Kiln Dust-Treated Subgrade","S.Y.",null,null,null,null,"Thickness adjustment or multiple"]
[null,"Sitework","P-157-8.1b","Lime Kiln Dust-Treated Subgrade","S.Y.",null,null,null,null,"Thickness adjustment or multiple"]
[null,"Sitework","P-158-8.1","Fly Ash-Treated Subgrade","S.Y.",null,null,null,null,"Thickness adjustment or multiple"]
["Part 4 – Base Courses","Base Course","P-207-5.1","In-Place Full Depth Reclamation (FDR) Recycled Asphalt Aggregate Base Course","S.Y.",null,null,null,null,"Thickness adjustment or multiple"]
[null,"Base Course","P-208-5.1","Aggregate Base Course","C.Y."]
[null,"Base Course","P-208-5.2","Separation Geotextile","S.Y."]
[null,"Base Course","P-209-5.1","Crushed Aggregate Base Course","C.Y.",65]
[null,"Base Course","P-209-5.2","Separation Geotextile","S.Y."]
[null,"Base Course","P-219-5.1","Recycled Concrete Aggregate Base Course","C.Y."]
[null,"Base Course","P-219-5.2","Separation Geotextile","S.Y."]
[null,"Base Course","P-220-6.1","Cement-Treated Soil Base Course","S.Y.",null,null,null,null,"Thickness adjustment or multiple"]
["Part 5 – Stabilized Base Courses","Stabilized Base Course","P-304-8.1","Cement-Treated Base Course","C.Y.",null,null,null,null,"If S.Y., then thickness adjustment"]
[null,"Stabilized Base Course","P-306-8.1","Lean Concrete Base Course","C.Y.",null,null,null,null,"If S.Y., then thickness adjustment"]
[null,"Stabilized Base Course","P-307-7.1","Cement-Treated Permeable Base Course (CTPB)","C.Y.",null,null,null,null,"If S.Y., then thickness adjustment"]
["Part 6 – Flexible Pavements","Flexible Pavement","P-401-8.1a","Asphalt Surface Course","TON",130]
[null,"Flexible Pavement","P-401-8.1b","Asphalt Base Course","TON",120]
[null,"Flexible Pavement","P-401-8.1c","Asphalt Leveling Course","TON",110]
[null,"Flexible Pavement","P-403-8.1a","Asphalt Mixture Surface Course","TON"]
[null,"Flexible Pavement","P-403-8.1b","Asphalt Mixture Base Course","TON"]
[null,"Flexible Pavement","P-403-8.1c","Asphalt Mixture Leveling Course","TON"]
[null,"Flexible Pavement","P-407-X.1","Asphalt-Treated Permeable Base Course (ATPB)","TON"]
["Part 7 – Rigid Pavement","Cement Concrete","P-501-8.1a","Concrete Pavement, 5-inch","S.Y.",79,null,null,null,"Thickness adjustment or multiple"]
[null,"Cement Concrete","P-501-8.1b","Concrete Pavement, 6-inch","S.Y.",82,null,null,null,"Thickness adjustment or multiple"]
[null,"Cement Concrete","P-501-8.1c","Concrete Pavement, 9-inch","S.Y.",85,null,null,null,"Thickness adjustment or multiple"]
[null,"Cement Concrete","P-501-8.1d","Concrete Pavement, 11-inch","S.Y.",91,null,null,null,"Thickness adjustment or multiple"]
["Part 8 – Surface Treatments","Surface Treatment","P-608-8.1","Emulsified Asphalt Surface Treatment","S.Y.",4]
[null,"Surface Treatment","P-623-8.1","Emulsified Asphalt Spray Seal Coat","S.Y.",5]
[null,"Surface Treatment","P-626-6.1","Emulsified Asphalt Slurry Seal Surface Treatment","S.Y.",7]
[null,"Surface Treatment","P-629-8.1","Thermoplastic Coal Tar Emulsion Surface Treatment","S.Y."]
[null,"Surface Treatment","P-630-7.1a","Refined Coal Tar Emulsion Without Additives, Slurry Seal Surface Treatment","S.Y."]
[null,"Surface Treatment","P-631-7.1b","Refined Coal Tar Emulsion With Additives, Slurry Seal Surface Treatment","S.Y."]
["Part 9 – Miscellaneous","Tack Coat","P-603-5.1","Emulsified Asphalt Tack Coat","GAL",4.5,null,null,null,"Assume 0.1 gal/SY for mill and overlay"]
[null,"Joint Sealant","P-605-5.1a","Joint Clean and Reseal, Concrete","L.F.",7,null,null,null,"Assume 12.5x12.5 slabs for these GA pavements"]
[null,"Marking","P-620-5.1a","Markings (prep, markings, reflective media)","S.F.",{"$f":"6/9","v":0.66666666666666663}]
[null,"Marking","P-620-5.1b","Markings (prep, markings, non-reflective media)","S.F."]
[null,"Grooving","P-621-5.1A","Grooving, Asphalt","S.Y."]
[null,"Grooving","P-621-5.1B","Grooving, Concrete","S.Y."]

{"sheet":"Database","index":4,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Alternative List"]
[]
["Name","Type","Description","Alt Worksheet Name"]

{"sheet":"Maintenance Policies","index":5,"n_rows":85,"n_cols":5,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"Table 1. New HMA maintenance policies."]
[null,"Asphalt Maintenance","Maintenance Item","Rate","Year Applied"]
[null,"Maintenance 1","Surface treatment, SYD",1,4]
[null,null,"Paint markings, SFT",1]
[null,"Maintenance 2","Surface treatment, SYD",1,8]
[null,null,"Paint markings, SFT",1]
[null,"Maintenance 3","Patching: 0.75% of area",7.4999999999999997E-3,12]
[null,null,"Crack sealing: 3.25% of area as linear feet",3.2500000000000001E-2]
[null,null,"Surface treatment: 100% of area",1]
[null,null,"Paint markings: 100% of markings",1]
[null,"Maintenance 4","Patching: 1.00% of area",0.01,16]
[null,null,"Crack sealing: 3.50% of area as linear feet",3.5000000000000003E-2]
[null,null,"Surface treatment: 100% of area",1]
[null,null,"Paint markings: 100% of markings",1]
[null,"Rehabilitation 1","Mill and overlay: 4-inch cold mill, tack coat, and asphalt overlay",1,20]
[null,null,"Pre-overlay crack repair: 1.5% of area as linear feet",1.4999999999999999E-2]
[null,null,"Pre-overlay patching: 0.5% of area",5.0000000000000001E-3]
[null,null,"Paint markings: 100% of markings",1]
[null,"Maintenance 5","Surface treatment: 100% of area",1,24]
[null,null,"Paint markings: 100% of markings",1]
[null,"Maintenance 6","Patching: 1.25% of area",1.2500000000000001E-2,28]
[null,null,"Crack sealing: 4.0% of area as linear feet",0.04]
[null,null,"Surface treatment: 100% of area",1]
[null,null,"Paint markings: 100% of markings",1]
[null,"Salvage","Salvage value: 2 years (0.125) of mill and overlay",0.125,30]
[]
[]
[null,"Table 2. New PCC maintenance policies."]
[null,"Concrete Maintenance","Maintenance Item","Rate","Year Applied"]
[null,"Maintenance 1","Joint resealing: 100% of joints",1,19]
[null,null,"Crack sealing: 0.25% of area as linear feet ",2.5000000000000001E-3]
[null,null,"Partial-depth patching: 0.13% of area",1.2999999999999999E-3]
[null,null,"Full-depth patching: 0.30% of area",3.0000000000000001E-3]
[null,"Rehabilitation 1","Slab replacements: 2% of area",0.02,27]
[null,null,"Full-depth patching: 0.30% of area",3.0000000000000001E-3]
[null,null,"Partial-depth patching: 0.13% of area",1.2999999999999999E-3]
[null,null,"Crack sealing: 0.30% of area as linear feet",3.0000000000000001E-3]
[null,null,"Joint sealing: 100% of joints",1]
[null,"Salvage","Salvage value: 10 years (0.25) of initial construction",0.25,30]
[]
[]
[null,"Table 3. First HMA Overlay maintenance policies."]
[null,"Asphalt Maintenance","Maintenance Item","Rate","Year Applied"]
[null,"Maintenance 1","Surface treatment: 100% of area",1,4]
[null,null,"Paint markings: 100% of markings",1]
[null,"Maintenance 2","Patching: 1.25% of area",1.2500000000000001E-2,8]
[null,null,"Crack sealing: 4.0% of area as linear feet",0.04]
[null,null,"Surface treatment: 100% of area",1]
[null,null,"Paint markings: 100% of markings",1]
[null,"Maintenance 3","Surface treatment, SYD",1,12]
[null,null,"Paint markings, SFT",1]
[null,"Rehabilitation 2","Mill and overlay: 4-inch cold mill, tack coat, and asphalt overlay",1,16]
[null,null,"Pre-overlay crack repair: 2% of area as linear feet",1.4999999999999999E-2]
[null,null,"Pre-overlay patching: 1% of area",5.0000000000000001E-3]
[null,null,"Paint markings: 100% of markings",1]
[null,"Maintenance 4","Surface treatment: 100% of area",1,20]
[null,null,"Paint markings: 100% of markings",1]
[null,"Maintenance 5","Patching: 1.25% of area",1.2500000000000001E-2,24]
[null,null,"Crack sealing: 4.0% of area as linear feet",0.04]
[null,null,"Surface treatment: 100% of area",1]
[null,null,"Paint markings: 100% of markings",1]
[null,"Maintenance 6","Surface treatment: 100% of area",1,28]
[null,null,"Paint markings: 100% of markings",1]
[null,"Salvage","Salvage value: Need for reconstruction (zero salvage)",0,30]
[]
[]
[null,"Table 4. PCC rehabilitation maintenance policies."]
[null,"Concrete Maintenance","Maintenance Item","Rate","Year Applied"]
[null,"Maintenance 1","Joint resealing: 100% of joints",1,15]
[null,null,"Crack sealing: 0.35% of area as linear feet ",3.5000000000000001E-3]
[null,null,"Partial-depth patching: 0.2% of area",2E-3]
[null,null,"Full-depth patching: 0.30% of area",3.0000000000000001E-3]
[null,"Rehabilitation 1","Slab replacements: 5% of area",0.05,25]
[null,null,"Full-depth patching: 0.30% of area",3.0000000000000001E-3]
[null,null,"Partial-depth patching: 0.15% of area",1.5E-3]
[null,null,"Crack sealing: 0.30% of area as linear feet",3.0000000000000001E-3]
[null,null,"Joint sealing: 100% of joints",1]
[null,"Salvage","Salvage value: Need for reconstruction (zero salvage)",0,30]

{"sheet":"TMP(NewHMA)","index":6,"n_rows":67,"n_cols":64,"rows_kept":67,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,"Hidden"]
["Initial Construction Costs:",null,null,null,null,null,null,null,null,"Maintenance 1",null,null,null,null,null,null,null,"Maintenance 2",null,null,null,null,null,null,null,"Maintenance 3",null,null,null,null,null,null,null,"Maintenance 4",null,null,null,null,null,null,null,"Rehabilitation 1",null,null,null,null,null,null,null,"Maintenance 5",null,null,null,null,null,null,null,"Maintenance 6"]
[]
["Pavement Type:",null,"New HMA"]
["Mainline Pavement Area:",null,{"$f":"'General Information'!D26","v":0},"S.Y."]
["Initial Construction Year:",null,{"$f":"'General Information'!D25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mill and overlay:",2,"inches"]
["Asphalt Surface Treatment Type:",null,"Emulsified Asphalt Surface Treatment","Select alternative treatment, if planned.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asphalt:",120,"lbs/SY-in"]
["Markings Area:",null,{"$f":"'General Information'!D28","v":0},"S.F."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tack Coat Application",0.1,"gal/S.Y."]
[]
[]
["Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost",null,null,"Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost",null,"Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost",null,"Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost",null,"Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost",null,"Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost",null,"Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost",null,"Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost"]
[1,{"$f":"IF(C13=\"\",0,VLOOKUP(C13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},"",{"$f":"IF(C13=\"\",\"N/A\",VLOOKUP(C13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C13=\"\",\"N/A\",VLOOKUP(C13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},{"$f":"IF(B13<>0,F13*E13,0)","v":0},null,null,1,{"$f":"IF(L13=\"\",0,VLOOKUP(L13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-608-8.1"},{"$f":"C7","v":"Emulsified Asphalt Surface Treatment"},{"$f":"VLOOKUP(L13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0)","v":"S.Y."},{"$f":"'Maintenance Policies'!D10*$C$5","v":0},{"$f":"IF(L13=\"\",\"N/A\",VLOOKUP(L13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"O13*N13","v":0},null,1,{"$f":"IF(T13=\"\",0,VLOOKUP(T13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-608-8.1"},{"$f":"C7","v":"Emulsified Asphalt Surface Treatment"},{"$f":"VLOOKUP(T13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0)","v":"S.Y."},{"$f":"'Maintenance Policies'!D12*$C$5","v":0},{"$f":"IF(T13=\"\",\"N/A\",VLOOKUP(T13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"W13*V13","v":0},null,1,{"$f":"IF(AB13=\"\",0,VLOOKUP(AB13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.4a"},{"$f":"Pay_Items!D11","v":"Spall Repair, Asphalt"},{"$f":"IF(AB13=\"\",\"N/A\",VLOOKUP(AB13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D14*($C$5*9)","v":0},{"$f":"IF(AB13=\"\",\"N/A\",VLOOKUP(AB13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":8.5},{"$f":"AE13*AD13","v":0},null,1,{"$f":"IF(AJ13=\"\",0,VLOOKUP(AJ13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.4a"},{"$f":"Pay_Items!D11","v":"Spall Repair, Asphalt"},{"$f":"IF(AJ13=\"\",\"N/A\",VLOOKUP(AJ13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D18*($C$5*9)","v":0},{"$f":"IF(AJ13=\"\",\"N/A\",VLOOKUP(AJ13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":8.5},{"$f":"AM13*AL13","v":0},null,1,{"$f":"IF(AR13=\"\",0,VLOOKUP(AR13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.6"},{"$f":"Pay_Items!D16","v":"Cold Milling"},{"$f":"IF(AR13=\"\",\"N/A\",VLOOKUP(AR13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.Y."},{"$f":"'Maintenance Policies'!D22*$C$5","v":0},{"$f":"IF(AR13=\"\",\"N/A\",VLOOKUP(AR13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":5},{"$f":"AU13*AT13","v":0},null,1,{"$f":"IF(AZ13=\"\",0,VLOOKUP(AZ13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-608-8.1"},{"$f":"C7","v":"Emulsified Asphalt Surface Treatment"},{"$f":"IF(AZ13=\"\",\"N/A\",VLOOKUP(AZ13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.Y."},{"$f":"'Maintenance Policies'!D26*$C$5","v":0},{"$f":"IF(AZ13=\"\",\"N/A\",VLOOKUP(AZ13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"BC13*BB13","v":0},null,1,{"$f":"IF(BH13=\"\",0,VLOOKUP(BH13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.4a"},{"$f":"Pay_Items!D11","v":"Spall Repair, Asphalt"},{"$f":"IF(BH13=\"\",\"N/A\",VLOOKUP(BH13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D28*($C$5*9)","v":0},{"$f":"IF(BH13=\"\",\"N/A\",VLOOKUP(BH13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":8.5},{"$f":"BK13*BJ13","v":0}]
[2,{"$f":"IF(C14=\"\",0,VLOOKUP(C14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},"",{"$f":"IF(C14=\"\",\"N/A\",VLOOKUP(C14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C14=\"\",\"N/A\",VLOOKUP(C14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,2,{"$f":"IF(L14=\"\",0,VLOOKUP(L14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.3"},{"$f":"Pay_Items!D10","v":"Markings Removal"},{"$f":"IF(L14=\"\",\"N/A\",VLOOKUP(L14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D10*$C$8","v":0},{"$f":"IF(L14=\"\",\"N/A\",VLOOKUP(L14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.77777777777777779},{"$f":"O14*N14","v":0},null,2,{"$f":"IF(T14=\"\",0,VLOOKUP(T14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.3"},{"$f":"Pay_Items!D10","v":"Markings Removal"},{"$f":"IF(T14=\"\",\"N/A\",VLOOKUP(T14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D12*$C$8","v":0},{"$f":"IF(T14=\"\",\"N/A\",VLOOKUP(T14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.77777777777777779},{"$f":"W14*V14","v":0},null,2,{"$f":"IF(AB14=\"\",0,VLOOKUP(AB14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.2a"},{"$f":"Pay_Items!D6","v":"Crack Repair (Type I), Asphalt"},{"$f":"IF(AB14=\"\",\"N/A\",VLOOKUP(AB14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"L.F."},{"$f":"'Maintenance Policies'!D15*($C$5*9)","v":0},{"$f":"IF(AB14=\"\",\"N/A\",VLOOKUP(AB14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"AE14*AD14","v":0},null,2,{"$f":"IF(AJ14=\"\",0,VLOOKUP(AJ14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.2a"},{"$f":"Pay_Items!D6","v":"Crack Repair (Type I), Asphalt"},{"$f":"IF(AJ14=\"\",\"N/A\",VLOOKUP(AJ14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"L.F."},{"$f":"'Maintenance Policies'!D19*($C$5*9)","v":0},{"$f":"IF(AJ14=\"\",\"N/A\",VLOOKUP(AJ14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"AM14*AL14","v":0},null,2,{"$f":"IF(AR14=\"\",0,VLOOKUP(AR14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-603-5.1"},{"$f":"Pay_Items!D54","v":"Emulsified Asphalt Tack Coat"},{"$f":"IF(AR14=\"\",\"N/A\",VLOOKUP(AR14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"GAL"},{"$f":"'Maintenance Policies'!D22*$C$5*AQ9","v":0},{"$f":"IF(AR14=\"\",\"N/A\",VLOOKUP(AR14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4.5},0,null,2,{"$f":"IF(AZ14=\"\",0,VLOOKUP(AZ14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.3"},{"$f":"Pay_Items!D10","v":"Markings Removal"},{"$f":"IF(AZ14=\"\",\"N/A\",VLOOKUP(AZ14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D26*$C$8","v":0},{"$f":"IF(AZ14=\"\",\"N/A\",VLOOKUP(AZ14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.77777777777777779},{"$f":"BC14*BB14","v":0},null,2,{"$f":"IF(BH14=\"\",0,VLOOKUP(BH14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.2a"},{"$f":"Pay_Items!D6","v":"Crack Repair (Type I), Asphalt"},{"$f":"IF(BH14=\"\",\"N/A\",VLOOKUP(BH14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"L.F."},{"$f":"'Maintenance Policies'!D29*($C$5*9)","v":0},{"$f":"IF(BH14=\"\",\"N/A\",VLOOKUP(BH14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"BK14*BJ14","v":0}]
[3,{"$f":"IF(C15=\"\",0,VLOOKUP(C15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},null,{"$f":"IF(C15=\"\",\"N/A\",VLOOKUP(C15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C15=\"\",\"N/A\",VLOOKUP(C15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,3,{"$f":"IF(L15=\"\",0,VLOOKUP(L15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-620-5.1a"},{"$f":"Pay_Items!D56","v":"Markings (prep, markings, reflective media)"},{"$f":"IF(L15=\"\",\"N/A\",VLOOKUP(L15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D11*$C$8","v":0},{"$f":"IF(L15=\"\",\"N/A\",VLOOKUP(L15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.66666666666666663},{"$f":"O15*N15","v":0},null,3,{"$f":"IF(T15=\"\",0,VLOOKUP(T15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-620-5.1a"},{"$f":"Pay_Items!D56","v":"Markings (prep, markings, reflective media)"},{"$f":"Pay_Items!E56","v":"S.F."},{"$f":"'Maintenance Policies'!D13*$C$8","v":0},{"$f":"IF(T15=\"\",\"N/A\",VLOOKUP(T15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.66666666666666663},{"$f":"W15*V15","v":0},null,3,{"$f":"IF(AB15=\"\",0,VLOOKUP(AB15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-608-8.1"},{"$f":"C7","v":"Emulsified Asphalt Surface Treatment"},{"$f":"IF(AB15=\"\",\"N/A\",VLOOKUP(AB15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.Y."},{"$f":"'Maintenance Policies'!D16*$C$5","v":0},{"$f":"IF(AB15=\"\",\"N/A\",VLOOKUP(AB15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"AE15*AD15","v":0},null,3,{"$f":"IF(AJ15=\"\",0,VLOOKUP(AJ15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-608-8.1"},{"$f":"C7","v":"Emulsified Asphalt Surface Treatment"},{"$f":"IF(AJ15=\"\",\"N/A\",VLOOKUP(AJ15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.Y."},{"$f":"'Maintenance Policies'!D20*$C$5","v":0},{"$f":"IF(AJ15=\"\",\"N/A\",VLOOKUP(AJ15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"AM15*AL15","v":0},null,3,{"$f":"IF(AR15=\"\",0,VLOOKUP(AR15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-401-8.1a"},{"$f":"Pay_Items!D37","v":"Asphalt Surface Course"},{"$f":"IF(AR15=\"\",\"N/A\",VLOOKUP(AR15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"TON"},{"$f":"'Maintenance Policies'!D22*$C$5*AQ6*AQ7/2000","v":0},{"$f":"IF(AR15=\"\",\"N/A\",VLOOKUP(AR15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":130},0,null,3,{"$f":"IF(AZ15=\"\",0,VLOOKUP(AZ15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-620-5.1a"},{"$f":"Pay_Items!D56","v":"Markings (prep, markings, reflective media)"},{"$f":"IF(AZ15=\"\",\"N/A\",VLOOKUP(AZ15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D27*$C$8","v":0},{"$f":"IF(AZ15=\"\",\"N/A\",VLOOKUP(AZ15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.66666666666666663},{"$f":"BC15*BB15","v":0},null,3,{"$f":"IF(BH15=\"\",0,VLOOKUP(BH15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-608-8.1"},{"$f":"C7","v":"Emulsified Asphalt Surface Treatment"},{"$f":"IF(BH15=\"\",\"N/A\",VLOOKUP(BH15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.Y."},{"$f":"'Maintenance Policies'!D30*$C$5","v":0},{"$f":"IF(BH15=\"\",\"N/A\",VLOOKUP(BH15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"BK15*BJ15","v":0}]
[4,{"$f":"IF(C16=\"\",0,VLOOKUP(C16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},null,{"$f":"IF(C16=\"\",\"N/A\",VLOOKUP(C16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C16=\"\",\"N/A\",VLOOKUP(C16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(P13:P15)","v":0},null,null,null,null,null,null,"Subtotal",{"$f":"SUM(X13:X15)","v":0},null,4,{"$f":"IF(AB16=\"\",0,VLOOKUP(AB16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.3"},{"$f":"Pay_Items!D10","v":"Markings Removal"},{"$f":"IF(AB16=\"\",\"N/A\",VLOOKUP(AB16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D16*$C$8","v":0},{"$f":"IF(AB16=\"\",\"N/A\",VLOOKUP(AB16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.77777777777777779},{"$f":"AE16*AD16","v":0},null,4,{"$f":"IF(AJ16=\"\",0,VLOOKUP(AJ16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.3"},{"$f":"Pay_Items!D10","v":"Markings Removal"},{"$f":"IF(AJ16=\"\",\"N/A\",VLOOKUP(AJ16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D20*$C$8","v":0},{"$f":"IF(AJ16=\"\",\"N/A\",VLOOKUP(AJ16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.77777777777777779},{"$f":"AM16*AL16","v":0},null,4,{"$f":"IF(AR16=\"\",0,VLOOKUP(AR16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.2a"},{"$f":"Pay_Items!D6","v":"Crack Repair (Type I), Asphalt"},{"$f":"IF(AR16=\"\",\"N/A\",VLOOKUP(AR16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"L.F."},{"$f":"'Maintenance Policies'!D23*($C$5*9)","v":0},{"$f":"IF(AR16=\"\",\"N/A\",VLOOKUP(AR16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},0,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(BD13:BD15)","v":0},null,4,{"$f":"IF(BH16=\"\",0,VLOOKUP(BH16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.3"},{"$f":"Pay_Items!D10","v":"Markings Removal"},{"$f":"IF(BH16=\"\",\"N/A\",VLOOKUP(BH16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"C8","v":0},{"$f":"IF(BH16=\"\",\"N/A\",VLOOKUP(BH16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.77777777777777779},{"$f":"BK16*BJ16","v":0}]
[5,{"$f":"IF(C17=\"\",0,VLOOKUP(C17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},null,{"$f":"IF(C17=\"\",\"N/A\",VLOOKUP(C17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C17=\"\",\"N/A\",VLOOKUP(C17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,null,null,"Mobilization",null,null,null,{"$f":"('General Information'!$D$36/100)*P16","v":0},null,null,null,"Mobilization",null,null,null,{"$f":"('General Information'!$D$36/100)*X16","v":0},null,5,{"$f":"IF(AB17=\"\",0,VLOOKUP(AB17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-620-5.1a"},{"$f":"Pay_Items!D56","v":"Markings (prep, markings, reflective media)"},{"$f":"IF(AB17=\"\",\"N/A\",VLOOKUP(AB17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D17*$C$8","v":0},{"$f":"IF(AB17=\"\",\"N/A\",VLOOKUP(AB17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.66666666666666663},{"$f":"AE17*AD17","v":0},null,5,{"$f":"IF(AJ17=\"\",0,VLOOKUP(AJ17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-620-5.1a"},{"$f":"Pay_Items!D56","v":"Markings (prep, markings, reflective media)"},{"$f":"IF(AJ17=\"\",\"N/A\",VLOOKUP(AJ17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D21*$C$8","v":0},{"$f":"IF(AJ17=\"\",\"N/A\",VLOOKUP(AJ17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.66666666666666663},{"$f":"AM17*AL17","v":0},null,5,{"$f":"IF(AR17=\"\",0,VLOOKUP(AR17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.4a"},{"$f":"Pay_Items!D11","v":"Spall Repair, Asphalt"},{"$f":"IF(AR17=\"\",\"N/A\",VLOOKUP(AR17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D24*($C$5*9)","v":0},{"$f":"IF(AR17=\"\",\"N/A\",VLOOKUP(AR17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":8.5},0,null,null,null,"Mobilization",null,null,null,{"$f":"('General Information'!$D$36/100)*BD16","v":0},null,5,{"$f":"IF(BH17=\"\",0,VLOOKUP(BH17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-620-5.1a"},{"$f":"Pay_Items!D56","v":"Markings (prep, markings, reflective media)"},{"$f":"IF(BH17=\"\",\"N/A\",VLOOKUP(BH17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D31*$C$8","v":0},{"$f":"IF(BH17=\"\",\"N/A\",VLOOKUP(BH17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.66666666666666663},{"$f":"BK17*BJ17","v":0}]
[6,{"$f":"IF(C18=\"\",0,VLOOKUP(C18,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},null,{"$f":"IF(C18=\"\",\"N/A\",VLOOKUP(C18,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C18=\"\",\"N/A\",VLOOKUP(C18,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,null,null,"Engineering",null,null,null,{"$f":"('General Information'!$D$37/100)*P16","v":0},null,null,null,"Engineering",null,null,null,{"$f":"('General Information'!$D$37/100)*X16","v":0},null,null,null,null,null,null,"Subtotal",{"$f":"SUM(AF13:AF17)","v":0},null,null,null,null,null,null,"Subtotal",{"$f":"SUM(AN13:AN17)","v":0},null,6,{"$f":"IF(AR18=\"\",0,VLOOKUP(AR18,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-620-5.1a"},{"$f":"Pay_Items!D56","v":"Markings (prep, markings, reflective media)"},{"$f":"IF(AR18=\"\",\"N/A\",VLOOKUP(AR18,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D25*$C$8","v":0},{"$f":"IF(AR18=\"\",\"N/A\",VLOOKUP(AR18,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.66666666666666663},0,null,null,null,"Engineering",null,null,null,{"$f":"('General Information'!$D$37/100)*BD16","v":0},null,null,null,null,null,null,"Subtotal",{"$f":"SUM(BL13:BL17)","v":0}]
[7,{"$f":"IF(C19=\"\",0,VLOOKUP(C19,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},null,{"$f":"IF(C19=\"\",\"N/A\",VLOOKUP(C19,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C19=\"\",\"N/A\",VLOOKUP(C19,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,null,null,null,null,null,"Total",{"$f":"SUM(P16:P18)","v":0},null,null,null,null,null,null,"Total",{"$f":"SUM(X16:X18)","v":0},null,null,null,"Mobilization",null,null,null,{"$f":"('General Information'!$D$36/100)*AF18","v":0},null,null,null,"Mobilization",null,null,null,{"$f":"('General Information'!$D$36/100)*AN18","v":0},null,null,null,null,null,null,"Subtotal",{"$f":"SUM(AV13:AV18)","v":0},null,null,null,null,null,null,"Total",{"$f":"SUM(BD16:BD18)","v":0},null,null,null,"Mobilization",null,null,null,{"$f":"('General Information'!$D$36/100)*BL18","v":0}]
[8,{"$f":"IF(C20=\"\",0,VLOOKUP(C20,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},null,{"$f":"IF(C20=\"\",\"N/A\",VLOOKUP(C20,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C20=\"\",\"N/A\",VLOOKUP(C20,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},{"$f":"IF(B20<>0,F20*E20,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineering",null,null,null,{"$f":"('General Information'!$D$37/100)*AF18","v":0},null,null,null,"Engineering",null,null,null,{"$f":"('General Information'!$D$37/100)*AN18","v":0},null,null,null,"Mobilization",null,null,null,{"$f":"('General Information'!$D$36/100)*AV19","v":0},null,null,null,null,null,null,null,null,null,null,null,"Engineering",null,null,null,{"$f":"('General Information'!$D$37/100)*BL18","v":0}]
[9,{"$f":"IF(C21=\"\",0,VLOOKUP(C21,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},null,{"$f":"IF(C21=\"\",\"N/A\",VLOOKUP(C21,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C21=\"\",\"N/A\",VLOOKUP(C21,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AF18:AF20)","v":0},null,null,null,null,null,null,"Total",{"$f":"SUM(AN18:AN20)","v":0},null,null,null,"Engineering",null,null,null,{"$f":"('General Information'!$D$37/100)*AV19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(BL18:BL20)","v":0}]
[10,{"$f":"IF(C22=\"\",0,VLOOKUP(C22,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},null,{"$f":"IF(C22=\"\",\"N/A\",VLOOKUP(C22,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C22=\"\",\"N/A\",VLOOKUP(C22,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AV19:AV21)","v":0}]
[]
["Subtotal",null,null,null,null,null,{"$f":"SUM(G14:G23)","v":0}]
[null,"Mobilization",null,null,null,null,{"$f":"('General Information'!$D$36/100)*G24","v":0}]
[]
["Total",null,null,null,null,null,{"$f":"SUM(G24:G26)","v":0}]
[]
[]
[]
[]
["Net Present Worth"]
["HMA Reconstruction - Alternative 1",null,null,null,null,null,null,null,"Hidden"]
[]
[null,"Item","Year Applied","Actual Cost","Discounted Cost"]
[null,"Initial Construction",{"$f":"C6","v":0},{"$f":"G27","v":0},{"$f":"D36","v":0},null,null,null,null,null,"Year","Actual","Discounted"]
[null,"Maintenance 1",{"$f":"'Maintenance Policies'!E10","v":4},{"$f":"P19","v":0},{"$f":"D37/(1+('General Information'!$D$34/100))^C37","v":0},null,null,null,null,null,{"$f":"C6","v":0},{"$f":"D36","v":0},{"$f":"E36","v":0}]
[null,"Maintenance 2",{"$f":"'Maintenance Policies'!E12","v":8},{"$f":"X19","v":0},{"$f":"D38/(1+('General Information'!$D$34/100))^C38","v":0},null,null,null,null,null,{"$f":"K37+1","v":1}]
[null,"Maintenance 3",{"$f":"'Maintenance Policies'!E14","v":12},{"$f":"AF21","v":0},{"$f":"D39/(1+('General Information'!$D$34/100))^C39","v":0},null,null,null,null,null,{"$f":"K38+1","v":2}]
[null,"Maintenance 4",{"$f":"'Maintenance Policies'!E18","v":16},{"$f":"AN21","v":0},{"$f":"D40/(1+('General Information'!$D$34/100))^C40","v":0},null,null,null,null,null,3]
[null,"Rehabilitation 1",{"$f":"'Maintenance Policies'!E22","v":20},{"$f":"AV22","v":0},{"$f":"D41/(1+('General Information'!$D$34/100))^C41","v":0},null,null,null,null,null,4,{"$f":"D37","v":0},{"$f":"E37","v":0}]
[null,"Maintenance 5",{"$f":"'Maintenance Policies'!E26","v":24},{"$f":"BD19","v":0},{"$f":"D42/(1+('General Information'!$D$34/100))^C42","v":0},null,null,null,null,null,5]
[null,"Maintenance 6",{"$f":"'Maintenance Policies'!E28","v":28},{"$f":"BL21","v":0},{"$f":"D43/(1+('General Information'!$D$34/100))^C43","v":0},null,null,null,null,null,6]
[null,"Salvage",{"$f":"'General Information'!D33","v":30},{"$f":"-'Maintenance Policies'!D58*AV22","v":0},{"$f":"D44/(1+('General Information'!$D$34/100))^C44","v":0},null,null,null,null,null,7]
[null,"Net Present Worth",null,null,{"$f":"SUM(E36:E44)","v":0},null,null,null,null,null,8,{"$f":"D38","v":0},{"$f":"E38","v":0}]
[null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,12,{"$f":"D39","v":0},{"$f":"E39","v":0}]
[null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,16,{"$f":"D40","v":0},{"$f":"E40","v":0}]
[null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,20,{"$f":"D41","v":0},{"$f":"E41","v":0}]
[null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K59+1","v":23}]
[null,null,null,null,null,null,null,null,null,null,24,{"$f":"D42","v":0},{"$f":"E42","v":0}]
[null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,28,{"$f":"D43","v":0},{"$f":"E43","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K65+1","v":29}]
[null,null,null,null,null,null,null,null,null,null,30,{"$f":"D44","v":0},{"$f":"E44","v":0}]

{"sheet":"TMP(NewPCC)","index":7,"n_rows":68,"n_cols":24,"rows_kept":68,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,"Hidden"]
["Initial Construction Costs:",null,null,null,null,null,null,null,null,"Maintenance 1",null,null,null,null,null,null,null,"Rehabilitation 1"]
[]
["Pavement Type:",null,"New PCC"]
["Mainline Pavement Area:",null,{"$f":"'General Information'!D26","v":0},"S.Y."]
["Initial Construction Year:",null,{"$f":"'General Information'!D25","v":0}]
["Markings Area:",null,{"$f":"'General Information'!D28","v":0},"S.F.",null,null,null,null,null,"No. of Slabs:",{"$f":"C5/((12.5*12.5)/9)","v":0}]
[null,null,null,null,null,null,null,null,null,"Joint length:",{"$f":"K7*25+((K7/8)*12.5)","v":0}]
[]
[]
[]
["Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost",null,null,"Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost",null,"Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost"]
[1,{"$f":"IF(C13=\"\",0,VLOOKUP(C13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},"",{"$f":"IF(C13=\"\",\"N/A\",VLOOKUP(C13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C13=\"\",\"N/A\",VLOOKUP(C13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},{"$f":"IF(B13<>0,F13*E13,0)","v":0},null,null,1,{"$f":"IF(L13=\"\",0,VLOOKUP(L13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-605-5.1a"},{"$f":"Pay_Items!D55","v":"Joint Clean and Reseal, Concrete"},{"$f":"IF(L13=\"\",\"N/A\",VLOOKUP(L13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"L.F."},{"$f":"K8*'Maintenance Policies'!D37","v":0},{"$f":"IF(L13=\"\",\"N/A\",VLOOKUP(L13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":7},{"$f":"O13*N13","v":0},null,1,{"$f":"IF(T13=\"\",0,VLOOKUP(T13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.5c"},{"$f":"Pay_Items!D15","v":"Slab Replacement, Concrete"},{"$f":"IF(T13=\"\",\"N/A\",VLOOKUP(T13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.Y."},{"$f":"'Maintenance Policies'!D41*C5","v":0},{"$f":"IF(T13=\"\",\"N/A\",VLOOKUP(T13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":100},{"$f":"W13*V13","v":0}]
[2,{"$f":"VLOOKUP(C14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0)","v":0},null,{"$f":"IF(C14=\"\",\"N/A\",VLOOKUP(C14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C14=\"\",\"N/A\",VLOOKUP(C14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,2,{"$f":"VLOOKUP(L14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0)","v":"P-101-5.2c"},{"$f":"Pay_Items!D8","v":"Crack Seal, Concrete"},{"$f":"IF(L14=\"\",\"N/A\",VLOOKUP(L14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"L.F."},{"$f":"'Maintenance Policies'!D38*(C5*9)","v":0},{"$f":"IF(L14=\"\",\"N/A\",VLOOKUP(L14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":8},{"$f":"O14*N14","v":0},null,2,{"$f":"VLOOKUP(T14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0)","v":"P-101-5.5b"},{"$f":"Pay_Items!D14","v":"Full-Depth Repair, Concrete"},{"$f":"IF(T14=\"\",\"N/A\",VLOOKUP(T14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.Y."},{"$f":"'Maintenance Policies'!D42*C5","v":0},{"$f":"IF(T14=\"\",\"N/A\",VLOOKUP(T14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":120},{"$f":"W14*V14","v":0}]
[3,{"$f":"VLOOKUP(C15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0)","v":0},null,{"$f":"IF(C15=\"\",\"N/A\",VLOOKUP(C15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C15=\"\",\"N/A\",VLOOKUP(C15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,3,{"$f":"VLOOKUP(L15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0)","v":"P-101-5.5a"},{"$f":"Pay_Items!D13","v":"Spall Repair, Concrete"},{"$f":"IF(L15=\"\",\"N/A\",VLOOKUP(L15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D39*(C5*9)","v":0},{"$f":"IF(L15=\"\",\"N/A\",VLOOKUP(L15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":60},{"$f":"O15*N15","v":0},null,3,{"$f":"VLOOKUP(T15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0)","v":"P-101-5.5a"},{"$f":"Pay_Items!D13","v":"Spall Repair, Concrete"},{"$f":"IF(T15=\"\",\"N/A\",VLOOKUP(T15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D43*(C5*9)","v":0},{"$f":"IF(T15=\"\",\"N/A\",VLOOKUP(T15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":60},{"$f":"W15*V15","v":0}]
[4,{"$f":"VLOOKUP(C16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0)","v":0},null,{"$f":"IF(C16=\"\",\"N/A\",VLOOKUP(C16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C16=\"\",\"N/A\",VLOOKUP(C16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,4,{"$f":"VLOOKUP(L16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0)","v":"P-101-5.5b"},{"$f":"Pay_Items!D14","v":"Full-Depth Repair, Concrete"},{"$f":"IF(L16=\"\",\"N/A\",VLOOKUP(L16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.Y."},{"$f":"'Maintenance Policies'!D40*C5","v":0},{"$f":"IF(L16=\"\",\"N/A\",VLOOKUP(L16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":120},{"$f":"O16*N16","v":0},null,4,{"$f":"VLOOKUP(T16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0)","v":"P-101-5.2c"},{"$f":"Pay_Items!D8","v":"Crack Seal, Concrete"},{"$f":"IF(T16=\"\",\"N/A\",VLOOKUP(T16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"L.F."},{"$f":"'Maintenance Policies'!D44*(C5*9)","v":0},{"$f":"IF(T16=\"\",\"N/A\",VLOOKUP(T16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":8},{"$f":"W16*V16","v":0}]
[5,{"$f":"VLOOKUP(C17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0)","v":0},null,{"$f":"IF(C17=\"\",\"N/A\",VLOOKUP(C17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C17=\"\",\"N/A\",VLOOKUP(C17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(P13:P16)","v":0},null,5,{"$f":"VLOOKUP(T17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0)","v":"P-605-5.1a"},{"$f":"Pay_Items!D55","v":"Joint Clean and Reseal, Concrete"},{"$f":"IF(T17=\"\",\"N/A\",VLOOKUP(T17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"L.F."},{"$f":"'Maintenance Policies'!D45*K8","v":0},{"$f":"IF(T17=\"\",\"N/A\",VLOOKUP(T17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":7},{"$f":"W17*V17","v":0}]
[6,{"$f":"VLOOKUP(C18,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0)","v":0},null,{"$f":"IF(C18=\"\",\"N/A\",VLOOKUP(C18,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C18=\"\",\"N/A\",VLOOKUP(C18,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},{"$f":"IF(B18<>0,F18*E18,0)","v":0},null,null,null,null,"Mobilization",null,null,null,{"$f":"('General Information'!$D$36/100)*P17","v":0},null,null,null,null,null,null,"Subtotal",{"$f":"SUM(X13:X17)","v":0}]
[7,{"$f":"VLOOKUP(C19,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0)","v":0},null,{"$f":"IF(C19=\"\",\"N/A\",VLOOKUP(C19,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C19=\"\",\"N/A\",VLOOKUP(C19,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},{"$f":"IF(B19<>0,F19*E19,0)","v":0},null,null,null,null,"Engineering",null,null,null,{"$f":"('General Information'!$D$37/100)*P17","v":0},null,null,null,"Mobilization",null,null,null,{"$f":"('General Information'!$D$36/100)*X18","v":0}]
[8,{"$f":"VLOOKUP(C20,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0)","v":0},null,{"$f":"IF(C20=\"\",\"N/A\",VLOOKUP(C20,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C20=\"\",\"N/A\",VLOOKUP(C20,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},{"$f":"IF(B20<>0,F20*E20,0)","v":0},null,null,null,null,null,null,null,"Total",{"$f":"SUM(P17:P19)","v":0},null,null,null,"Engineering",null,null,null,{"$f":"('General Information'!$D$37/100)*X18","v":0}]
[9,{"$f":"VLOOKUP(C21,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0)","v":0},null,{"$f":"IF(C21=\"\",\"N/A\",VLOOKUP(C21,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C21=\"\",\"N/A\",VLOOKUP(C21,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(X18:X20)","v":0}]
[10,{"$f":"VLOOKUP(C22,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0)","v":0},null,{"$f":"IF(C22=\"\",\"N/A\",VLOOKUP(C22,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},null,{"$f":"IF(C22=\"\",\"N/A\",VLOOKUP(C22,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0]
[]
["Subtotal",null,null,null,null,null,{"$f":"SUM(G14:G23)","v":0}]
[null,"Mobilization",null,null,null,null,{"$f":"('General Information'!$D$36/100)*G24","v":0}]
[]
["Total",null,null,null,null,null,{"$f":"SUM(G24:G26)","v":0}]
[]
[]
[]
[]
[]
["Net Present Worth"]
["PCC Reconstruction - Alternative 2",null,null,null,null,null,null,null,"Hidden"]
[]
[null,"Item","Year Applied","Actual Cost","Discounted Cost"]
[null,"Initial Construction",{"$f":"C6","v":0},{"$f":"G27","v":0},{"$f":"D37","v":0},null,null,null,null,null,"Year","Actual","Discounted"]
[null,"Maintenance 1",{"$f":"'Maintenance Policies'!E37","v":19},{"$f":"P20","v":0},{"$f":"D38/(1+('General Information'!$D$34/100))^C38","v":0},null,null,null,null,null,{"$f":"C6","v":0},{"$f":"D37","v":0},{"$f":"E37","v":0}]
[null,"Rehabilitation 1",{"$f":"'Maintenance Policies'!E41","v":27},{"$f":"X21","v":0},{"$f":"D39/(1+('General Information'!$D$34/100))^C39","v":0},null,null,null,null,null,{"$f":"K38+1","v":1}]
[null,"Salvage",{"$f":"'General Information'!D33","v":30},{"$f":"-'Maintenance Policies'!D73*G27","v":0},{"$f":"D40/(1+('General Information'!$D$34/100))^C40","v":0},null,null,null,null,null,{"$f":"K39+1","v":2}]
[null,"Net Present Worth",null,null,{"$f":"SUM(E37:E40)","v":0},null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,19,{"$f":"D38","v":0},{"$f":"E38","v":0}]
[null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K60+1","v":23}]
[null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,27,{"$f":"D39","v":0},{"$f":"E39","v":0}]
[null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K66+1","v":29}]
[null,null,null,null,null,null,null,null,null,null,30,{"$f":"D40","v":0},{"$f":"E40","v":0}]

{"sheet":"TMP(HMARehab)","index":8,"n_rows":67,"n_cols":64,"rows_kept":67,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,"Hidden"]
["Initial Construction Costs:",null,null,null,null,null,null,null,null,"Maintenance 1",null,null,null,null,null,null,null,"Maintenance 2",null,null,null,null,null,null,null,"Maintenance 3",null,null,null,null,null,null,null,"Rehabilitation 1",null,null,null,null,null,null,null,"Maintenance 4",null,null,null,null,null,null,null,"Maintenance 5",null,null,null,null,null,null,null,"Maintenance 6"]
[]
["Pavement Type:",null,"HMA mill and overlay"]
["Mainline Pavement Area:",null,{"$f":"'General Information'!D26","v":0},"S.Y."]
["Initial Construction Year:",null,{"$f":"'General Information'!D25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mill and overlay:",2,"inches"]
["Asphalt Surface Treatment Type:",null,"Emulsified Asphalt Surface Treatment","Select alternative treatment, if planned.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asphalt:",120,"lbs/SY-in"]
["Markings Area:",null,{"$f":"'General Information'!D28","v":0},"S.F."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tack Coat Application",7.0000000000000007E-2,"gal/S.Y."]
[]
[]
["Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost",null,null,"Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost",null,"Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost",null,"Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost",null,"Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost",null,"Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost",null,"Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost",null,"Item No.","Pay Item","Description","Unit","Qty","Unit Cost","Item Cost"]
[1,{"$f":"IF(C13=\"\",0,VLOOKUP(C13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},"",{"$f":"IF(C13=\"\",\"N/A\",VLOOKUP(C13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},0,{"$f":"IF(C13=\"\",\"N/A\",VLOOKUP(C13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},{"$f":"IF(B13<>0,F13*E13,0)","v":0},null,null,1,{"$f":"IF(L13=\"\",0,VLOOKUP(L13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-608-8.1"},{"$f":"C7","v":"Emulsified Asphalt Surface Treatment"},{"$f":"IF(L13=\"\",\"N/A\",VLOOKUP(L13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.Y."},{"$f":"'Maintenance Policies'!D51*$C$5","v":0},{"$f":"IF(L13=\"\",\"N/A\",VLOOKUP(L13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"O13*N13","v":0},null,1,{"$f":"IF(T13=\"\",0,VLOOKUP(T13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.4a"},{"$f":"Pay_Items!D11","v":"Spall Repair, Asphalt"},{"$f":"IF(T13=\"\",\"N/A\",VLOOKUP(T13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D53*($C$5*9)","v":0},{"$f":"IF(T13=\"\",\"N/A\",VLOOKUP(T13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":8.5},{"$f":"W13*V13","v":0},null,1,{"$f":"IF(AB13=\"\",0,VLOOKUP(AB13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-608-8.1"},{"$f":"C7","v":"Emulsified Asphalt Surface Treatment"},{"$f":"IF(AB13=\"\",\"N/A\",VLOOKUP(AB13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.Y."},{"$f":"'Maintenance Policies'!D57*$C$5","v":0},{"$f":"IF(AB13=\"\",\"N/A\",VLOOKUP(AB13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"AE13*AD13","v":0},null,1,{"$f":"IF(AJ13=\"\",0,VLOOKUP(AJ13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.6"},"Cold Milling",{"$f":"IF(AJ13=\"\",\"N/A\",VLOOKUP(AJ13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.Y."},{"$f":"'Maintenance Policies'!D59*$C$5","v":0},{"$f":"IF(AJ13=\"\",\"N/A\",VLOOKUP(AJ13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":5},{"$f":"AM13*AL13","v":0},null,1,{"$f":"IF(AR13=\"\",0,VLOOKUP(AR13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-608-8.1"},{"$f":"C7","v":"Emulsified Asphalt Surface Treatment"},{"$f":"IF(AR13=\"\",\"N/A\",VLOOKUP(AR13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.Y."},{"$f":"'Maintenance Policies'!D63*$C$5","v":0},{"$f":"IF(AR13=\"\",\"N/A\",VLOOKUP(AR13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"AU13*AT13","v":0},null,1,{"$f":"IF(AZ13=\"\",0,VLOOKUP(AZ13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.4a"},"Spall Repair, Asphalt",{"$f":"IF(AZ13=\"\",\"N/A\",VLOOKUP(AZ13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D65*($C$5*9)","v":0},{"$f":"IF(AZ13=\"\",\"N/A\",VLOOKUP(AZ13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":8.5},{"$f":"BC13*BB13","v":0},null,1,{"$f":"IF(BH13=\"\",0,VLOOKUP(BH13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-608-8.1"},{"$f":"C7","v":"Emulsified Asphalt Surface Treatment"},{"$f":"IF(BH13=\"\",\"N/A\",VLOOKUP(BH13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.Y."},{"$f":"'Maintenance Policies'!D69*$C$5","v":0},{"$f":"IF(BH13=\"\",\"N/A\",VLOOKUP(BH13,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"BK13*BJ13","v":0}]
[2,{"$f":"IF(C14=\"\",0,VLOOKUP(C14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},"",{"$f":"IF(C14=\"\",\"N/A\",VLOOKUP(C14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},0,{"$f":"IF(C14=\"\",\"N/A\",VLOOKUP(C14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,2,{"$f":"IF(L14=\"\",0,VLOOKUP(L14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.3"},"Markings Removal",{"$f":"IF(L14=\"\",\"N/A\",VLOOKUP(L14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D52*$C$8","v":0},{"$f":"IF(L14=\"\",\"N/A\",VLOOKUP(L14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.77777777777777779},{"$f":"O14*N14","v":0},null,2,{"$f":"IF(T14=\"\",0,VLOOKUP(T14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.2a"},{"$f":"Pay_Items!D6","v":"Crack Repair (Type I), Asphalt"},{"$f":"IF(T14=\"\",\"N/A\",VLOOKUP(T14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"L.F."},{"$f":"'Maintenance Policies'!D54*($C$5*9)","v":0},{"$f":"IF(T14=\"\",\"N/A\",VLOOKUP(T14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"W14*V14","v":0},null,2,{"$f":"IF(AB14=\"\",0,VLOOKUP(AB14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.3"},"Markings Removal",{"$f":"IF(AB14=\"\",\"N/A\",VLOOKUP(AB14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D58*$C$8","v":0},{"$f":"IF(AB14=\"\",\"N/A\",VLOOKUP(AB14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.77777777777777779},{"$f":"AE14*AD14","v":0},null,2,{"$f":"IF(AJ14=\"\",0,VLOOKUP(AJ14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-603-5.1"},"Emulsified Asphalt Tack Coat",{"$f":"IF(AJ14=\"\",\"N/A\",VLOOKUP(AJ14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"GAL"},{"$f":"'Maintenance Policies'!D59*$C$5*AI9","v":0},{"$f":"IF(AJ14=\"\",\"N/A\",VLOOKUP(AJ14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4.5},{"$f":"AM14*AL14","v":0},null,2,{"$f":"IF(AR14=\"\",0,VLOOKUP(AR14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.3"},"Markings Removal",{"$f":"IF(AR14=\"\",\"N/A\",VLOOKUP(AR14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D64*$C$8","v":0},{"$f":"IF(AR14=\"\",\"N/A\",VLOOKUP(AR14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.77777777777777779},0,null,2,{"$f":"IF(AZ14=\"\",0,VLOOKUP(AZ14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.2a"},"Crack Repair (Type I), Asphalt",{"$f":"IF(AZ14=\"\",\"N/A\",VLOOKUP(AZ14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"L.F."},{"$f":"'Maintenance Policies'!D66*($C$5*9)","v":0},{"$f":"IF(AZ14=\"\",\"N/A\",VLOOKUP(AZ14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"BC14*BB14","v":0},null,2,{"$f":"IF(BH14=\"\",0,VLOOKUP(BH14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.3"},"Markings Removal",{"$f":"IF(BH14=\"\",\"N/A\",VLOOKUP(BH14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D70*$C$8","v":0},{"$f":"IF(BH14=\"\",\"N/A\",VLOOKUP(BH14,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.77777777777777779},{"$f":"BK14*BJ14","v":0}]
[3,{"$f":"IF(C15=\"\",0,VLOOKUP(C15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},"",{"$f":"IF(C15=\"\",\"N/A\",VLOOKUP(C15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},0,{"$f":"IF(C15=\"\",\"N/A\",VLOOKUP(C15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,3,{"$f":"IF(L15=\"\",0,VLOOKUP(L15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-620-5.1a"},"Markings (prep, markings, reflective media)",{"$f":"IF(L15=\"\",\"N/A\",VLOOKUP(L15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D52*$C$8","v":0},{"$f":"IF(L15=\"\",\"N/A\",VLOOKUP(L15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.66666666666666663},{"$f":"O15*N15","v":0},null,3,{"$f":"IF(T15=\"\",0,VLOOKUP(T15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-608-8.1"},{"$f":"C7","v":"Emulsified Asphalt Surface Treatment"},{"$f":"IF(T15=\"\",\"N/A\",VLOOKUP(T15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.Y."},{"$f":"'Maintenance Policies'!D55*$C$5","v":0},{"$f":"IF(T15=\"\",\"N/A\",VLOOKUP(T15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"W15*V15","v":0},null,3,{"$f":"IF(AB15=\"\",0,VLOOKUP(AB15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-620-5.1a"},"Markings (prep, markings, reflective media)",{"$f":"IF(AB15=\"\",\"N/A\",VLOOKUP(AB15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D58*$C$8","v":0},{"$f":"IF(AB15=\"\",\"N/A\",VLOOKUP(AB15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.66666666666666663},{"$f":"AE15*AD15","v":0},null,3,{"$f":"IF(AJ15=\"\",0,VLOOKUP(AJ15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-401-8.1a"},"Asphalt Surface Course",{"$f":"IF(AJ15=\"\",\"N/A\",VLOOKUP(AJ15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"TON"},{"$f":"'Maintenance Policies'!D59*$C$5*AI6*AI7/2000","v":0},{"$f":"IF(AJ15=\"\",\"N/A\",VLOOKUP(AJ15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":130},{"$f":"AM15*AL15","v":0},null,3,{"$f":"IF(AR15=\"\",0,VLOOKUP(AR15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-620-5.1a"},"Markings (prep, markings, reflective media)",{"$f":"IF(AR15=\"\",\"N/A\",VLOOKUP(AR15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D64*$C$8","v":0},{"$f":"IF(AR15=\"\",\"N/A\",VLOOKUP(AR15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.66666666666666663},0,null,3,{"$f":"IF(AZ15=\"\",0,VLOOKUP(AZ15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-608-8.1"},{"$f":"C7","v":"Emulsified Asphalt Surface Treatment"},{"$f":"IF(AZ15=\"\",\"N/A\",VLOOKUP(AZ15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.Y."},{"$f":"'Maintenance Policies'!D67*$C$5","v":0},{"$f":"IF(AZ15=\"\",\"N/A\",VLOOKUP(AZ15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"BC15*BB15","v":0},null,3,{"$f":"IF(BH15=\"\",0,VLOOKUP(BH15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-620-5.1a"},"Markings (prep, markings, reflective media)",{"$f":"IF(BH15=\"\",\"N/A\",VLOOKUP(BH15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D70*$C$8","v":0},{"$f":"IF(BH15=\"\",\"N/A\",VLOOKUP(BH15,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.66666666666666663},{"$f":"BK15*BJ15","v":0}]
[4,{"$f":"IF(C16=\"\",0,VLOOKUP(C16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},"",{"$f":"IF(C16=\"\",\"N/A\",VLOOKUP(C16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},0,{"$f":"IF(C16=\"\",\"N/A\",VLOOKUP(C16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(P13:P15)","v":0},null,4,{"$f":"IF(T16=\"\",0,VLOOKUP(T16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.3"},{"$f":"Pay_Items!D10","v":"Markings Removal"},{"$f":"IF(T16=\"\",\"N/A\",VLOOKUP(T16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D56*$C$8","v":0},{"$f":"IF(T16=\"\",\"N/A\",VLOOKUP(T16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.77777777777777779},{"$f":"W16*V16","v":0},null,null,null,null,null,null,"Subtotal",{"$f":"SUM(AF13:AF15)","v":0},null,4,{"$f":"IF(AJ16=\"\",0,VLOOKUP(AJ16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.2a"},"Crack Repair (Type I), Asphalt",{"$f":"IF(AJ16=\"\",\"N/A\",VLOOKUP(AJ16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"L.F."},{"$f":"'Maintenance Policies'!D60*($C$5*9)","v":0},{"$f":"IF(AJ16=\"\",\"N/A\",VLOOKUP(AJ16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":4},{"$f":"AM16*AL16","v":0},null,null,null,null,null,null,"Subtotal",{"$f":"SUM(AV13:AV15)","v":0},null,4,{"$f":"IF(AZ16=\"\",0,VLOOKUP(AZ16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.3"},"Markings Removal",{"$f":"IF(AZ16=\"\",\"N/A\",VLOOKUP(AZ16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D68*$C$8","v":0},{"$f":"IF(AZ16=\"\",\"N/A\",VLOOKUP(AZ16,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.77777777777777779},{"$f":"BC16*BB16","v":0},null,null,null,null,null,null,"Subtotal",{"$f":"SUM(BL13:BL15)","v":0}]
[5,{"$f":"IF(C17=\"\",0,VLOOKUP(C17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},"",{"$f":"IF(C17=\"\",\"N/A\",VLOOKUP(C17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},0,{"$f":"IF(C17=\"\",\"N/A\",VLOOKUP(C17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,null,null,"Mobilization",null,null,null,{"$f":"('General Information'!$D$36/100)*P16","v":0},null,5,{"$f":"IF(T17=\"\",0,VLOOKUP(T17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-620-5.1a"},{"$f":"Pay_Items!D56","v":"Markings (prep, markings, reflective media)"},{"$f":"IF(T17=\"\",\"N/A\",VLOOKUP(T17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D56*$C$8","v":0},{"$f":"IF(T17=\"\",\"N/A\",VLOOKUP(T17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.66666666666666663},{"$f":"W17*V17","v":0},null,null,null,"Mobilization",null,null,null,{"$f":"('General Information'!$D$36/100)*AF16","v":0},null,5,{"$f":"IF(AJ17=\"\",0,VLOOKUP(AJ17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-101-5.4a"},"Spall Repair, Asphalt",{"$f":"IF(AJ17=\"\",\"N/A\",VLOOKUP(AJ17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D61*($C$5*9)","v":0},{"$f":"IF(AJ17=\"\",\"N/A\",VLOOKUP(AJ17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":8.5},{"$f":"AM17*AL17","v":0},null,null,null,"Mobilization",null,null,null,{"$f":"('General Information'!$D$36/100)*AV16","v":0},null,5,{"$f":"IF(AZ17=\"\",0,VLOOKUP(AZ17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-620-5.1a"},"Markings (prep, markings, reflective media)",{"$f":"IF(AZ17=\"\",\"N/A\",VLOOKUP(AZ17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D68*$C$8","v":0},{"$f":"IF(AZ17=\"\",\"N/A\",VLOOKUP(AZ17,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.66666666666666663},{"$f":"BC17*BB17","v":0},null,null,null,"Mobilization",null,null,null,{"$f":"('General Information'!$D$36/100)*BL16","v":0}]
[6,{"$f":"IF(C18=\"\",0,VLOOKUP(C18,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},"",{"$f":"IF(C18=\"\",\"N/A\",VLOOKUP(C18,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},0,{"$f":"IF(C18=\"\",\"N/A\",VLOOKUP(C18,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,null,null,"Engineering",null,null,null,{"$f":"('General Information'!$D$37/100)*P16","v":0},null,null,null,null,null,null,"Subtotal",{"$f":"SUM(X13:X17)","v":0},null,null,null,"Engineering",null,null,null,{"$f":"('General Information'!$D$37/100)*AF16","v":0},null,6,{"$f":"IF(AJ18=\"\",0,VLOOKUP(AJ18,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":"P-620-5.1a"},"Markings (prep, markings, reflective media)",{"$f":"IF(AJ18=\"\",\"N/A\",VLOOKUP(AJ18,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"S.F."},{"$f":"'Maintenance Policies'!D62*$C$8","v":0},{"$f":"IF(AJ18=\"\",\"N/A\",VLOOKUP(AJ18,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":0.66666666666666663},0,null,null,null,"Engineering",null,null,null,{"$f":"('General Information'!$D$37/100)*AV16","v":0},null,null,null,null,null,null,"Subtotal",{"$f":"SUM(BD13:BD17)","v":0},null,null,null,"Engineering",null,null,null,{"$f":"('General Information'!$D$37/100)*BL16","v":0}]
[7,{"$f":"IF(C19=\"\",0,VLOOKUP(C19,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},"",{"$f":"IF(C19=\"\",\"N/A\",VLOOKUP(C19,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},0,{"$f":"IF(C19=\"\",\"N/A\",VLOOKUP(C19,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,null,null,null,null,null,"Total",{"$f":"SUM(P16:P18)","v":0},null,null,null,"Mobilization",null,null,null,{"$f":"('General Information'!$D$36/100)*X18","v":0},null,null,null,null,null,null,"Total",{"$f":"SUM(AF16:AF18)","v":0},null,null,null,null,null,null,"Subtotal",{"$f":"SUM(AN13:AN18)","v":0},null,null,null,null,null,null,"Total",{"$f":"SUM(AV16:AV18)","v":0},null,null,null,"Mobilization",null,null,null,{"$f":"('General Information'!$D$36/100)*BD18","v":0},null,null,null,null,null,null,"Total",{"$f":"SUM(BL16:BL18)","v":0}]
[8,{"$f":"IF(C20=\"\",0,VLOOKUP(C20,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},"",{"$f":"IF(C20=\"\",\"N/A\",VLOOKUP(C20,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},0,{"$f":"IF(C20=\"\",\"N/A\",VLOOKUP(C20,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,null,null,null,null,null,null,null,null,null,null,"Engineering",null,null,null,{"$f":"('General Information'!$D$37/100)*X18","v":0},null,null,null,null,null,null,null,null,null,null,null,"Mobilization",null,null,null,{"$f":"('General Information'!$D$36/100)*AN19","v":0},null,null,null,null,null,null,null,null,null,null,null,"Engineering",null,null,null,{"$f":"('General Information'!$D$37/100)*BD18","v":0}]
[9,{"$f":"IF(C21=\"\",0,VLOOKUP(C21,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},"",{"$f":"IF(C21=\"\",\"N/A\",VLOOKUP(C21,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},0,{"$f":"IF(C21=\"\",\"N/A\",VLOOKUP(C21,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(X18:X20)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Engineering",null,null,null,{"$f":"('General Information'!$D$37/100)*AN19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(BD18:BD20)","v":0}]
[10,{"$f":"IF(C22=\"\",0,VLOOKUP(C22,CHOOSE({1,2},Table2[Pay Item Description],Table2[Pay Item No.]),2,0))","v":0},"",{"$f":"IF(C22=\"\",\"N/A\",VLOOKUP(C22,CHOOSE({1,2},Table2[Pay Item Description],Table2[Units]),2,0))","v":"N/A"},0,{"$f":"IF(C22=\"\",\"N/A\",VLOOKUP(C22,CHOOSE({1,2},Table2[Pay Item Description],Table2[Unit Cost]),2,0))","v":"N/A"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AN19:AN21)","v":0}]
[]
["Subtotal",null,null,null,null,null,{"$f":"SUM(G14:G23)","v":0}]
[null,"Mobilization",null,null,null,null,{"$f":"('General Information'!$D$36/100)*G24","v":0}]
[]
["Total",null,null,null,null,null,{"$f":"SUM(G24:G26)","v":0}]
[]
[]
[]
[]
["Net Present Worth"]
["HMA Mill and Overlay - Alternative 3",null,null,null,null,null,null,null,"Hidden"]
[]
[null,"Item","Year Applied","Actual Cost","Discounted Cost"]
[null,"Initial Construction",{"$f":"C6","v":0},{"$f":"G27","v":0},{"$f":"D36","v":0},null,null,null,null,null,"Year","Actual","Discounted"]
[null,"Maintenance 1",{"$f":"'Maintenance Policies'!E51","v":4},{"$f":"P19","v":0},{"$f":"D37/(1+('General Information'!$D$34/100))^C37","v":0},null,null,null,null,null,{"$f":"C6","v":0},{"$f":"D36","v":0},{"$f":"E36","v":0}]
[null,"Maintenance 2",{"$f":"'Maintenance Policies'!E53","v":8},{"$f":"X21","v":0},{"$f":"D38/(1+('General Information'!$D$34/100))^C38","v":0},null,null,null,null,null,{"$f":"K37+1","v":1}]
[null,"Maintenance 3",{"$f":"'Maintenance Policies'!E57","v":12},{"$f":"AF19","v":0},{"$f":"D39/(1+('General Information'!$D$34/100))^C39","v":0},null,null,null,null,null,{"$f":"K38+1","v":2}]
[null,"Rehabilitation 1",{"$f":"'Maintenance Policies'!E59","v":16},{"$f":"AN22","v":0},{"$f":"D40/(1+('General Information'!$D$34/100))^C40","v":0},null,null,null,null,null,3]
[null,"Maintenance 4",{"$f":"'Maintenance Policies'!E63","v":20},{"$f":"AV19","v":0},{"$f":"D41/(1+('General Information'!$D$34/100))^C41","v":0},null,null,null,null,null,4,{"$f":"D37","v":0},{"$f":"E37","v":0}]
[null,"Maintenance 5",{"$f":"C36+'Maintenance Policies'!E65","v":24},{"$f":"BD21","v":0},{"$f":"D42/(1+('General Information'!$D$34/100))^C42","v":0},null,null,null,null,null,5]
[null,"Maintenance 6",{"$f":"'Maintenance Policies'!E69","v":28},{"$f":"BL19","v":0},{"$f":"D43/(1+('General Information'!$D$34/100))^C43","v":0},null,null,null,null,null,6]
[null,"Salvage",{"$f":"'General Information'!D33","v":30},{"$f":"-'Maintenance Policies'!D71*AV22","v":0},{"$f":"D44/(1+('General Information'!$D$34/100))^C44","v":0},null,null,null,null,null,7]
[null,"Net Present Worth",null,null,{"$f":"SUM(E36:E44)","v":0},null,null,null,null,null,8,{"$f":"D38","v":0},{"$f":"E38","v":0}]
[null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,12,{"$f":"D39","v":0},{"$f":"E39","v":0}]
[null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,16,{"$f":"D40","v":0},{"$f":"E40","v":0}]
[null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,20,{"$f":"D41","v":0},{"$f":"E41","v":0}]
[null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K59+1","v":23}]
[null,null,null,null,null,null,null,null,null,null,24,{"$f":"D42","v":0},{"$f":"E42","v":0}]
[null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,28,{"$f":"D43","v":0},{"$f":"E43","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K65+1","v":29}]
[null,null,null,null,null,null,null,null,null,null,30,{"$f":"D44","v":0},{"$f":"E44","v":0}]

{"sheet":"TMP(PCCRehab)","index":9,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
["Coming soon."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"I "]

{"sheet":"Summary","index":10,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Alternative","Name","Initial Construction","Present Worth","Alternative Description"]