{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Checklist","Background","Mix Design","Quantities","Equipment","Summary","Performance Review"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":50,"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":"Checklist","index":0,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[50,1,51,8],[34,4,34,7],[38,4,38,7],[24,4,24,7],[25,4,25,7],[27,4,27,7],[29,4,29,7],[32,4,32,7],[33,4,33,7],[26,4,26,7],[35,4,35,7],[36,4,36,7],[37,4,37,7],[43,4,43,7],[44,4,44,7],[45,4,45,7],[20,4,20,7],[11,7,11,8],[19,4,19,7],[46,4,46,7],[47,4,47,7],[23,4,23,7],[13,4,13,7],[15,4,15,7],[16,4,16,7],[17,4,17,7],[18,4,18,7],[41,4,41,7],[42,4,42,7],[6,6,6,8],[7,3,7,8],[8,3,8,8],[10,2,10,8],[11,2,11,3],[9,3,9,4]]}
[]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION"]
[]
[null,"FDR Project Development Checklist"]
[null,"for Foamed Asphalt or Asphalt Emulsion Treatment"]
[]
[null,"Control/Sect.:",null,"Highway:",null,"County:"]
[null,"Limits:","From:"]
[null,null,"To:"]
[null,null,"Length:"]
[null,"Type:"]
[null,"Prepared By:",null,null,null,null,"Date:"]
[]
[null,"Step",null,null,"Comments",null,null,null,"Status"]
[null,"Upfront testing to include:"]
[null,"Review of soils maps"]
[null,"GPR survey"]
[null,"FWD survey"]
[null,"Sample materials"]
[null,"Determine existing typical section"]
[null,"Other",null,null,"Insert type of other testing here"]
[]
[null,"Pavement design to include:"]
[null,"Determine traffic requirements"]
[null,"FPS design"]
[null,"Texas triaxial design"]
[null,"Evaluate alternate designs"]
[null,"Select proposed typical section"]
[]
[null,"Lab mix design:"]
[]
[null,"Construction planning to include:"]
[null,"Quantity estimates"]
[null,"Order materials"]
[null,"Hold pre-construction meeting"]
[null,"Secure required equipment"]
[null,"Set up traffic control"]
[null,"Schedule construction"]
[null,"Other",null,null,"Insert description here"]
[]
[null,"Construction to include:"]
[null,"Gradation"]
[null,"Depth of pulverization"]
[null,"Density"]
[null,"Moisture content"]
[null,"Place fog seal"]
[null,"Place surface"]
[null,"Other",null,null,"Insert description here"]
[]
[null,"Remarks"]

{"sheet":"Background","index":1,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[6,6,6,8],[11,7,11,8],[22,1,23,8],[7,3,7,4],[8,3,8,4],[9,3,9,4],[14,1,15,3],[14,4,15,8],[18,1,19,3],[18,4,19,8]]}
[]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION"]
[]
[null,"FDR Project Background"]
[null,"for Foamed Asphalt or Asphalt Emulsion Treatment"]
[]
[null,"Control/Sect.:",{"$f":"IF(COUNTA(Checklist!C7)>0,Checklist!C7,\"\")","v":""},"Highway:",{"$f":"IF(COUNTA(Checklist!E7)>0,Checklist!E7,\"\")","v":""},"County:",{"$f":"IF(COUNTA(Checklist!G7)>0,Checklist!G7,\"\")","v":""}]
[null,"Limits:","From:",{"$f":"IF(COUNTA(Checklist!D8)>0,Checklist!D8,\"\")","v":""}]
[null,null,"To:",{"$f":"IF(COUNTA(Checklist!D9)>0,Checklist!D9,\"\")","v":""}]
[null,null,"Length:",{"$f":"IF(COUNTA(Checklist!D10)>0,Checklist!D10,\"\")","v":""}]
[null,"Type:",{"$f":"IF(COUNTA(Checklist!C11)>0,Checklist!C11,\"\")","v":""}]
[null,"Prepared By:",{"$f":"IF(COUNTA(Checklist!C12)>0,Checklist!C12,\"\")","v":""},null,null,null,"Date:",{"$f":"IF(COUNTA(Checklist!H12)>0,Checklist!H12,\"\")","v":""}]
[]
[null,"Existing Typical Section"]
[null,"Insert remarks here.",null,null,"Double click to insert photo of completed section"]
[]
[]
[null,"Proposed Typical Section"]
[null,"Insert remarks here.",null,null,"Double click to insert photo of completed section"]
[]
[]
[null,"Remarks"]

{"sheet":"Mix Design","index":2,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[29,1,30,8],[22,5,22,7],[23,5,23,7],[24,5,24,7],[25,5,25,7],[26,5,26,7],[26,1,26,3],[22,1,22,3],[24,1,24,3],[23,1,23,3],[6,6,6,8],[11,7,11,8],[20,9,23,11],[24,9,24,11],[25,9,25,11],[20,5,20,7],[21,5,21,7],[13,1,13,5],[7,3,7,4],[8,3,8,4],[9,3,9,4],[20,1,20,3],[21,1,21,3],[26,9,26,11],[14,1,14,2],[15,1,15,2],[17,1,17,2],[25,1,25,3],[16,1,16,2],[16,3,16,5],[14,3,14,5],[15,3,15,5],[17,3,17,5]]}
[]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION"]
[]
[null,"FDR Mixture Design"]
[null,"for Foamed Asphalt or Asphalt Emulsion Treatment"]
[]
[null,"Control/Sect.:",{"$f":"IF(COUNTA(Checklist!C7)>0,Checklist!C7,\"\")","v":""},"Highway:",{"$f":"IF(COUNTA(Checklist!E7)>0,Checklist!E7,\"\")","v":""},"County:",{"$f":"IF(COUNTA(Checklist!G7)>0,Checklist!G7,\"\")","v":""}]
[null,"Limits:","From:",{"$f":"IF(COUNTA(Checklist!D8)>0,Checklist!D8,\"\")","v":""}]
[null,null,"To:",{"$f":"IF(COUNTA(Checklist!D9)>0,Checklist!D9,\"\")","v":""}]
[null,null,"Length:",{"$f":"IF(COUNTA(Checklist!D10)>0,Checklist!D10,\"\")","v":""}]
[null,"Type:",{"$f":"IF(COUNTA(Checklist!C11)>0,Checklist!C11,\"\")","v":""}]
[null,"Prepared By:",{"$f":"IF(COUNTA(Checklist!C12)>0,Checklist!C12,\"\")","v":""},null,null,null,"Date:",{"$f":"IF(COUNTA(Checklist!H12)>0,Checklist!H12,\"\")","v":""}]
[]
[null,"Ashpalt Information"]
[null,"Asphalt treatment type:"]
[null,"Asphalt source:"]
[null,"Emulsion Type:"]
[null,"Asphalt type:"]
[]
[null,"Mixture Design Summary"]
[null,"Optimum moisture content (%):",null,null,null,null,null,null,null,{"$f":"IF(AND(SUM(I21:I24)<>100, COUNTBLANK(I21:I24)<>4),\"Specification not met\",\"\")","v":""}]
[null,"Maximum Dry Density (pcf):"]
[null,"Asphalt treatment rate (%):"]
[null,"Cement content (%):"]
[null,"Lime content (%):",null,null,null,"Average IDT (unconditioned) (psi):",null,null,null,{"$f":"IF(AND(I25<50,COUNTBLANK(I25)=0),\"Specification not met\",\"\")","v":""}]
[null,"Foaming Water (%):",null,null,null,"Average IDT (conditioned) (psi):",null,null,null,{"$f":"IF(AND(I26<30,COUNTBLANK(I26)=0),\"Specification not met\",\"\")","v":""}]
[null,"Foaming Temperature (oC):",null,null,null,"Average UCS (conditioned) (psi):",null,null,null,{"$f":"IF(AND(I27<120,COUNTBLANK(I27)=0),\"Specification not met\",\"\")","v":""}]
[]
[null,"Remarks"]

{"sheet":"Quantities","index":3,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[31,2,31,4],[37,2,37,4],[44,1,45,8],[38,2,38,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[41,1,41,5],[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[11,7,11,8],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[13,1,13,4],[19,1,19,3],[21,1,21,8],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3]]}
[]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION"]
[]
[null,"FDR Quantity Estimates"]
[null,"for Foamed Asphalt or Asphalt Emulsion Treatment"]
[]
[null,"Control/Sect.:",{"$f":"IF(COUNTA(Checklist!C7)>0,Checklist!C7,\"\")","v":""},"Highway:",{"$f":"IF(COUNTA(Checklist!E7)>0,Checklist!E7,\"\")","v":""},"County:",{"$f":"IF(COUNTA(Checklist!G7)>0,Checklist!G7,\"\")","v":""}]
[null,"Limits:","From:",{"$f":"IF(COUNTA(Checklist!D8)>0,Checklist!D8,\"\")","v":""}]
[null,null,"To:",{"$f":"IF(COUNTA(Checklist!D9)>0,Checklist!D9,\"\")","v":""}]
[null,null,"Length:",{"$f":"IF(COUNTA(Checklist!D10)>0,Checklist!D10,\"\")","v":""}]
[null,"Type:",{"$f":"IF(COUNTA(Checklist!C11)>0,Checklist!C11,\"\")","v":""}]
[null,"Prepared By:",{"$f":"IF(COUNTA(Checklist!C12)>0,Checklist!C12,\"\")","v":""},null,null,null,"Date:",{"$f":"IF(COUNTA(Checklist!H12)>0,Checklist!H12,\"\")","v":""}]
[]
[null,"Area and Depth to Treat"]
[null,"Select area input format:"]
[null,"Project Length (miles):"]
[null,"Width of pavement to treat (ft):"]
[null,"FDR Treatment Depth (in.):"]
[null,"Total project SY:",null,null,{"$f":"IF(COUNT(E16,E17,E20)>0,IF(E15=\"by length and width\",((E16*5280)*E17)/9,E20),\"\")","v":""}]
[null,"Total project SY:"]
[]
[null,"Quantity Estimates"]
[null,"Item","Description",null,null,"Unit","QTY","Unit Price","Amount"]
[null,{"$f":"IF('Mix Design'!D15=\"Asphalt Emulsion\",\"Asphalt Emulsion*\",\"Asphalt*\")","v":"Asphalt*"},null,null,null,"Ton",{"$f":"IF(COUNT(E18,E19,E20)>1,IF(F24=\"ton\",1.08*('Mix Design'!E23/100)*(Quantities!E18/12*9*'Mix Design'!E22)*Quantities!E19/2000,1.08*('Mix Design'!E23/100)*(Quantities!E18/12*9*'Mix Design'!E22)*Quantities!E19/8.59),\"\")","v":""},null,{"$f":"IF(ISBLANK(H24),\"\",G24*H24)","v":""}]
[null,"Cement",null,null,null,"Ton",{"$f":"'Mix Design'!E24/100*'Mix Design'!E22*9*Quantities!E18/12*E19/2000","v":{"$error":"#VALUE!"}},null,{"$f":"IF(ISBLANK(H25),\"\",G25*H25)","v":""}]
[null,"Lime",null,null,null,"Ton",{"$f":"'Mix Design'!E25/100*'Mix Design'!E22*9*Quantities!E18/12*Quantities!E19/2000","v":{"$error":"#VALUE!"}},null,""]
[null,{"$f":"IF(OR('Mix Design'!F21=\"RAP (Stockpile) (%):\",'Mix Design'!F22=\"RAP (Stockpile) (%):\",'Mix Design'!F23=\"RAP (Stockpile) (%):\",'Mix Design'!F24=\"RAP (Stockpile) (%):\"), \"RAP (Stockpile)\",\"\")","v":""},null,null,null,"CY",{"$f":"(VLOOKUP(\"RAP (Stockpile) (%):\",'Mix Design'!F21:I24,4,FALSE)/100*Quantities!E18)/36*E19","v":{"$error":"#N/A"}},null,""]
[null,{"$f":"IF(OR('Mix Design'!F22=\"Flexible Base (Stockpile) (%):\",'Mix Design'!F23=\"Flexible Base (Stockpile) (%):\",'Mix Design'!F24=\"Flexible Base (Stockpile) (%):\",'Mix Design'!F25=\"Flexible Base (Stockpile) (%):\"), \"Flexible Base (Stockpile)\",\"\")","v":""},null,null,null,"CY",{"$f":"(VLOOKUP(\"Flexible Base (Stockpile) (%):\",'Mix Design'!F21:I24,4,FALSE)/100*Quantities!E18)/36*E19","v":{"$error":"#N/A"}},null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,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(I24:I39)","v":0}]
[]
[null,"*Asphalt estimate includes an 8% increase from theoretical to account for minimum 6\" treatment overlap in adjacent cutter passes."]
[]
[null,"Remarks"]

{"sheet":"Equipment","index":4,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[24,4,24,7],[38,4,38,7],[37,4,37,7],[39,4,39,7],[44,1,45,8],[40,1,41,8],[30,4,30,7],[31,4,31,7],[32,4,32,7],[35,4,35,7],[36,4,36,7],[26,4,26,7],[29,4,29,7],[6,6,6,8],[7,3,7,4],[8,3,8,4],[9,3,9,4],[11,7,11,8],[23,4,23,7],[13,4,13,7],[15,4,15,7],[16,4,16,7],[21,4,21,7],[22,4,22,7],[18,4,18,7],[19,4,19,7],[20,4,20,7]]}
[]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION"]
[]
[null,"FDR Equipment Checklist"]
[null,"for Foamed Asphalt or Asphalt Emulsion Treatment"]
[]
[null,"Control/Sect.:",{"$f":"IF(COUNTA(Checklist!C7)>0,Checklist!C7,\"\")","v":""},"Highway:",{"$f":"IF(COUNTA(Checklist!E7)>0,Checklist!E7,\"\")","v":""},"County:",{"$f":"IF(COUNTA(Checklist!G7)>0,Checklist!G7,\"\")","v":""}]
[null,"Limits:","From:",{"$f":"IF(COUNTA(Checklist!D8)>0,Checklist!D8,\"\")","v":""}]
[null,null,"To:",{"$f":"IF(COUNTA(Checklist!D9)>0,Checklist!D9,\"\")","v":""}]
[null,null,"Length:",{"$f":"IF(COUNTA(Checklist!D10)>0,Checklist!D10,\"\")","v":""}]
[null,"Type:",{"$f":"IF(COUNTA(Checklist!C11)>0,Checklist!C11,\"\")","v":""}]
[null,"Prepared By:",{"$f":"IF(COUNTA(Checklist!C12)>0,Checklist!C12,\"\")","v":""},null,null,null,"Date:",{"$f":"IF(COUNTA(Checklist!H12)>0,Checklist!H12,\"\")","v":""}]
[]
[null,"Equipment",null,null,"Comments",null,null,null,"Status"]
[null,"Required Equipment"]
[null,"Reclaimer with tow bars and hoses"]
[null,"Water truck with pintle hitch, 2500 gal. min.*",null,null,"6,000 gal preferred"]
[null,"Additive spreader (cement or lime)",null,null,"vane spreader or spreader bar w/socks"]
[null,"Padfoot roller, 20t"]
[null,"Blade"]
[null,"Pneumatic roller, 14t"]
[null,"Flat wheel roller, 10t ",null,null,"double smooth drum recommended"]
[null,"2nd water truck for sprinkling*"]
[null,"Distributor with fog emulsion"]
[null,"Density gauge"]
[null,"Equipment for placing surface"]
[null,"Other",null,null,"Insert type of equipment here"]
[]
[null,"Optional Equipment"]
[null,"2nd padfoot roller"]
[null,"2nd blade"]
[null,"Power broom"]
[null,"Other"]
[]
[null,"Supplies"]
[null,"1 3/4 and 3/4 in. sieves and scale"]
[null,"PPE for working with oil"]
[null,"Replacement cutting teeth"]
[null,"Lube for daily maintenance"]
[null,"Other",null,null,"Insert description here"]
[null,"*at least one water truck must have a working pump to fill foam water                                                  tank on reclaimer if process uses foamed asphalt"]
[]
[]
[null,"Remarks"]

{"sheet":"Summary","index":5,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[33,1,33,4],[18,6,18,7],[20,1,20,2],[21,1,21,2],[18,1,18,2],[48,1,49,8],[27,1,27,8],[34,5,34,8],[35,5,35,8],[38,5,38,8],[29,5,29,8],[30,5,30,8],[31,5,31,8],[39,5,39,8],[37,5,37,8],[37,1,37,4],[42,5,42,8],[43,5,43,8],[44,5,44,8],[45,5,45,8],[28,5,28,8],[42,1,42,2],[42,3,42,4],[6,6,6,8],[11,7,11,8],[15,6,15,7],[16,6,16,7],[17,6,17,7],[7,3,7,4],[8,3,8,4],[9,3,9,4],[13,1,13,8],[14,1,14,3],[23,1,23,3],[14,6,14,8],[33,5,33,8],[28,1,28,4]]}
[]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION"]
[]
[null,"FDR Project Summary"]
[null,"for Foamed Asphalt or Asphalt Emulsion Treatment"]
[]
[null,"Control/Sect.:",{"$f":"IF(COUNTA(Checklist!C7)>0,Checklist!C7,\"\")","v":""},"Highway:",{"$f":"IF(COUNTA(Checklist!E7)>0,Checklist!E7,\"\")","v":""},"County:",{"$f":"IF(COUNTA(Checklist!G7)>0,Checklist!G7,\"\")","v":""}]
[null,"Limits:","From:",{"$f":"IF(COUNTA(Checklist!D8)>0,Checklist!D8,\"\")","v":""}]
[null,null,"To:",{"$f":"IF(COUNTA(Checklist!D9)>0,Checklist!D9,\"\")","v":""}]
[null,null,"Length:",{"$f":"IF(COUNTA(Checklist!D10)>0,Checklist!D10,\"\")","v":""}]
[null,"Type:",{"$f":"IF(COUNTA(Checklist!C11)>0,Checklist!C11,\"\")","v":""}]
[null,"Prepared By:",{"$f":"IF(COUNTA(Checklist!C12)>0,Checklist!C12,\"\")","v":""},null,null,null,"Date:",{"$f":"IF(COUNTA(Checklist!H12)>0,Checklist!H12,\"\")","v":""}]
[]
[null,"Materials and Mixture Design"]
[null,"FDR Treatment Parameters",null,null,null,null,"Materials information"]
[null,"Treatment depth (in.):",null,{"$f":"IF(COUNT(Quantities!E18)>0,Quantities!E18,\"\")","v":""},null,null,{"$f":"IF(COUNTA('Mix Design'!F21)>0,'Mix Design'!F21,\"\")","v":""},null,{"$f":"IF(COUNT('Mix Design'!I21)>0,'Mix Design'!I21,\"\")","v":""}]
[null,"Cement content (%):",null,{"$f":"IF(COUNT('Mix Design'!E24)>0,'Mix Design'!E24,\"\")","v":""},null,null,{"$f":"IF(COUNTA('Mix Design'!F22)>0,'Mix Design'!F22,\"\")","v":""},null,{"$f":"IF(COUNT('Mix Design'!I22)>0,'Mix Design'!I22,\"\")","v":""}]
[null,"Lime content (%):",null,{"$f":"IF(COUNT('Mix Design'!E25)>0,'Mix Design'!E25,\"\")","v":""},null,null,{"$f":"IF(COUNTA('Mix Design'!F23)>0,'Mix Design'!F23,\"\")","v":""},null,{"$f":"IF(COUNT('Mix Design'!I23)>0,'Mix Design'!I23,\"\")","v":""}]
[null,{"$f":"IF('Mix Design'!D15=\"Asphalt Emulsion\",\"Emulsion Type:\",\"Asphalt Type:\")","v":"Asphalt Type:"},null,{"$f":"IF(COUNTA('Mix Design'!D17,'Mix Design'!D18)>0,IF('Mix Design'!D15=\"Asphalt Emulsion\",'Mix Design'!D17,'Mix Design'!D18),\"\")","v":""},null,null,{"$f":"IF(COUNTA('Mix Design'!F24)>0,'Mix Design'!F24,\"\")","v":""},null,{"$f":"IF(COUNT('Mix Design'!I24)>0,'Mix Design'!I24,\"\")","v":""}]
[null,"Asphalt rate (%):",null,{"$f":"IF(COUNT('Mix Design'!E23)>0,'Mix Design'!E23,\"\")","v":""}]
[null,"Foaming Water (%):",null,{"$f":"IF(COUNT('Mix Design'!E26)>0,'Mix Design'!E26,\"\")","v":""},null,null,"Mixture Design Results"]
[null,"Foaming Temperature (oC):",null,{"$f":"IF(COUNT('Mix Design'!E27)>0,'Mix Design'!E27,\"\")","v":""},null,null,"IDT (unconditioned) (psi):",null,{"$f":"IF(COUNT('Mix Design'!I25)>0,'Mix Design'!I25,\"\")","v":""}]
[null,null,null,null,null,null,"IDT (conditioned) (psi):",null,{"$f":"IF(COUNT('Mix Design'!I26)>0,'Mix Design'!I26,\"\")","v":""}]
[null,"Moisture-Density Results",null,null,null,null,"UCS (conditioned) (psi):",null,{"$f":"IF(COUNT('Mix Design'!I27)>0,'Mix Design'!I27,\"\")","v":""}]
[null,"Optimum Moisture Content:",null,{"$f":"IF(COUNT('Mix Design'!E21)>0,'Mix Design'!E21,\"\")","v":""}]
[null,"Maximum Dry Density:",null,{"$f":"IF(COUNT('Mix Design'!E22)>0,'Mix Design'!E22,\"\")","v":""}]
[]
[null,"FDR Production Estimates"]
[null,"Asphalt",null,null,null,"Comment"]
[null,"Equivalent rate, (lb/SY):",null,null,{"$f":"IF(COUNT('Mix Design'!E23, Quantities!E18, 'Mix Design'!E22)>2,'Mix Design'!E23/100*9*Quantities!E18/12*'Mix Design'!E22,\"\")","v":""}]
[null,"Equivalent rate, (gal/SY):",null,null,{"$f":"IF(COUNT(E30)>0,E30/8.59,\"\")","v":""}]
[null,"Estimated length for each transport, (ft)*:",null,null,{"$f":"IF(COUNT(E30)>0, 37500/E30,\"\")","v":""}]
[]
[null,"Cement",null,null,null,"Comment"]
[null,"Equivalent rate, (lb/SY):",null,null,{"$f":"IF(COUNT(Quantities!G25,Quantities!E19)>1,Quantities!G25*2000/Quantities!E19,\"\")","v":""}]
[null,"Estimated length for each transport, (ft)*:",null,null,{"$f":"IF(COUNT(E35)>0,37500/E35,\"\")","v":""}]
[]
[null,"Lime",null,null,null,"Comment"]
[null,"Equivalent rate, (lb/SY):",null,null,{"$f":"IF(COUNT(Quantities!G26,Quantities!E19)>1,Quantities!G26*2000/Quantities!E19,\"\")","v":""}]
[null,"Estimated length for each transport, (ft)*:",null,null,{"$f":"IF(COUNT(E39)>0,37500/E39,\"\")","v":""}]
[null,"     *Production estimates assume 25 tons per transport treating 12' wide with each transport."]
[]
[null,"FDR Working Days Estimate",null,null,null,"Comment"]
[null,{"$f":"\"Estimated quantity per transport (\"& Quantities!F24 &\"):\"","v":"Estimated quantity per transport (Ton):"},null,null,25]
[null,"Estimated transports per working day:",null,null,2]
[null,"Estimated number of FDR working days:",null,null,{"$f":"IF(COUNT(D20) >0, ROUNDUP(Quantities!G24/(Summary!E44*Summary!E45),0),\"\")","v":""}]
[]
[null,"Remarks"]

{"sheet":"Performance Review","index":6,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[[11,12,11,14],[32,1,33,14],[18,1,19,14],[22,1,23,14],[25,10,25,11],[25,12,25,14],[14,1,15,8],[14,9,15,14]]}
[]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION"]
[]
[null,"FDR Performance Review"]
[null,"for Foamed Asphalt or Asphalt Emulsion Treatment"]
[]
[null,"Control/Sect.:",{"$f":"IF(COUNTA(Checklist!C7)>0,Checklist!C7,\"\")","v":""},null,null,null,"Highway:",{"$f":"IF(COUNTA(Checklist!E7)>0,Checklist!E7,\"\")","v":""},null,null,"County:",{"$f":"IF(COUNTA(Checklist!G7)>0,Checklist!G7,\"\")","v":""}]
[null,"Limits:",null,"From:",{"$f":"IF(COUNTA(Checklist!D8)>0,Checklist!D8,\"\")","v":""}]
[null,null,null,"To:",{"$f":"IF(COUNTA(Checklist!D9)>0,Checklist!D9,\"\")","v":""}]
[null,null,null,"Length:",{"$f":"IF(COUNTA(Checklist!D10)>0,Checklist!D10,\"\")","v":""}]
[null,"Type:",{"$f":"IF(COUNTA(Checklist!C11)>0,Checklist!C11,\"\")","v":""}]
[null,"Prepared By:",{"$f":"IF(COUNTA(Checklist!C12)>0,Checklist!C12,\"\")","v":""},null,null,null,null,null,null,null,null,"Date:"]
[]
[null,"Completed Typical Section"]
[null,"Insert remarks here.",null,null,null,null,null,null,null,"Double click to insert photo of completed section"]
[]
[]
[null,"What went well"]
[]
[]
[]
[null,"What areas exist for improvement"]
[]
[]
[]
[null,"FWD Data on Completed Typical Section",null,null,null,null,null,null,null,null,"Collection Date:"]
[null,null,"R1","R2","R3","R4","R5","R6","R7","SURF(E1)","BASE(E2)","SUBB(E3)","SUBG(E4)"," Absolute Err/Sens","Depth to Bedrock"]
[null,"Mean:"]
[null,"Std. Dev:"]
[null,"Var Coeff (%):"]
[]
[null,"Remarks"]