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

{"sheet":"Data Entry","index":0,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[23,4,23,9],[1,1,1,10],[7,6,7,8],[9,6,9,8],[11,6,11,8]]}
[]
[null,"Preservation Treatment Form"]
[]
[null,null,null,"State/Province: ",null,null,null,null,"Year: "]
[]
[null,null,null,"Preservation Treatment: ",null,null,null,null,"Work Performed By: "]
[]
[null,null,null,"Lane Distance Complete: ",null,null,null,null,null," Lane Distance Units: "]
[]
[null,null,null,"Lane Width: ",null,null,null,null,null," Lane Width Units: "]
[]
[null,null,null,"Total Treatment Cost: ",null,null,null,null,null," Currency: "]
[]
[null,null,null,"Treatment Service Life: ",null,null,null,null,"Estimated Life Extension: "]
[]
[null,null,null,"Quantity 1: ",null,null,null,null,"Quantity 2: "]
[]
[null,null,null,"Quantity 1 - Unit: ",null,null,null,null,"Quantity 2 - Unit: "]
[]
[null,null,null,"Quantity 1 - Material: ",null,null,null,null,"Quantity 2 - Material: "]
[]
[null,null,null,"Name: ",null,null,null,null,"Email: "]
[]
[null,null,null,"Comments: "]
[]
[]
[]
[]
[null,null,null,"Preservation Treatment",{"$f":"E6","v":0}]
[null,null,null,"Province/State",{"$f":"E4","v":0}]
[null,null,null,"Lane Distance Complete",{"$f":"E8","v":0}]
[null,null,null,"Lane Distance Units",{"$f":"G8","v":0}]
[null,null,null,"Lane Width",{"$f":"E10","v":0}]
[null,null,null,"Lane Width Units",{"$f":"G10","v":0}]
[null,null,null,"Total Treatment Cost",{"$f":"E12","v":0}]
[null,null,null,"Currency",{"$f":"G12","v":0}]
[null,null,null,"Work Performed By",{"$f":"IF(H37=1,\"Agency\",IF(H37=2,\"Contractor\",IF(H37=3,\"Both\",\"Not Applicable\")))","v":"Agency"},null,null,1]
[null,null,null,"Year",{"$f":"J4","v":0}]
[null,null,null,"Treatment Service Life",{"$f":"E14","v":0}]
[null,null,null,"Estimated Life Extension",{"$f":"J14","v":0}]
[null,null,null,"Quantity 1",{"$f":"E16","v":0}]
[null,null,null,"Quantity 1 - Unit",{"$f":"E18","v":0}]
[null,null,null,"Quantity 1 - Material",{"$f":"E20","v":0}]
[null,null,null,"Quantity 2",{"$f":"J16","v":0}]
[null,null,null,"Quantity 2 - Unit",{"$f":"J18","v":0}]
[null,null,null,"Quantity 2 - Material",{"$f":"J20","v":0}]
[null,null,null,"Name",{"$f":"E22","v":0}]
[null,null,null,"Email",{"$f":"J22","v":0}]
[null,null,null,"Comments",{"$f":"E24","v":0}]
[null,null,null,"Cost per Unit Distance",{"$f":"(E35/E31)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Summary","index":1,"n_rows":1,"n_cols":23,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"Preservation Treatment","State/Province","Lane Distance Complete","Lane Distance Units","Lane Width","Lane Width Units","Total Treatment Cost","Currency","Work Performed By","Year","Treatment Service Life","Estimated Life Extension","Quantity 1","Quantity 1 - Unit","Quantity 1 - Material","Quantity 2","Quantity 2 - Unit","Quantity 2 - Material","Name","Email","Comments","Cost per Distance"]

{"sheet":"Data","index":2,"n_rows":67,"n_cols":31,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Preservation Treatment","Province/Territory/State","Work Preformed By","Lane Distance Units","Currency","Lane Width Units",null,null,"Preservation Treatment","State/Province","Lane Distance Complete","Lane Distance Units","Lane Width","Lane Width Units","Total Treatment Cost","Currency","Work Performed By","Year","Treatment Service Life","Estimated Life Extension","Quantity 1","Quantity 1 - Unit","Quantity 1 - Material","Quantity 2","Quantity 2 - Unit","Quantity 2 - Material","Name","Email","Comments","Cost per Distance"]
[null,"Bonded Wearing Course","Alabama","Agency","Kilometers","CAD","Meters",null,null,0,"Florida",0,0,0,0,0,0,"Agency",0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"Chip Seal (Double)","Alaska","Contractor","Miles","USD","Feet"]
[null,"Chip Seal (Single)","Arizona","Both"]
[null,"Cold-In-Place Recycling","Arkansas"]
[null,"Concrete Pavement Restoration","California"]
[null,"Crack Filling","Colorado"]
[null,"Crack Sealing","Connecticut"]
[null,"Diamond Grinding","Delaware"]
[null,"Dowel Bar Retrofit","District of Columbia"]
[null,"Fog Seal","Florida"]
[null,"Hot-In-Place Recycling","Georgia"]
[null,"Joint Resealing - Concrete","Hawaii"]
[null,"Micro Milling","Idaho"]
[null,"Mirco-surfacing (Single Lift)","Illinois"]
[null,"Mirco-surfacing (Two Lifts)","Indiana"]
[null,"Otta Seal","Iowa"]
[null,"Rejuvenator Fog Seal","Kansas"]
[null,"Scrub Seal","Kentucky"]
[null,"Slurry Seal","Lousiana"]
[null,"Thin HMA Overlay (Metric)","Maine"]
[null,"Thin HMA Overlay (US)","Maryland"]
[null,"Other","Massachusetts"]
[null,null,"Michigan"]
[null,null,"Minnesota"]
[null,null,"Mississippi"]
[null,null,"Missouri"]
[null,null,"Montana"]
[null,null,"Nebraska"]
[null,null,"Nevada"]
[null,null,"New Hampshire"]
[null,null,"New Jersey"]
[null,null,"New Mexico"]
[null,null,"New York"]
[null,null,"North Carolina"]
[null,null,"North Dakota"]
[null,null,"Ohio"]
[null,null,"Oklahoma"]
[null,null,"Oregon"]
[null,null,"Pennsylvania"]
[null,null,"Rhode Island"]
[null,null,"South Carolina"]
[null,null,"South Dakota"]
[null,null,"Tennessee"]
[null,null,"Texas"]
[null,null,"Utah"]
[null,null,"Vermont"]
[null,null,"Virginia"]
[null,null,"Washington"]
[null,null,"West Virginia"]
[null,null,"Wisconsin"]
[null,null,"Wyoming"]
[null,null,"-----------------------------------"]
[null,null,"Alberta"]
[null,null,"British Columbia"]
[null,null,"Manitoba"]
[null,null,"New Brunswick"]
[null,null,"Newfoundland and Labrador"]
[null,null,"Northwest Territories"]
[null,null,"Nova Scotia"]
[null,null,"Nunavut"]
[null,null,"Ontario"]
[null,null,"Prince Edward Island"]
[null,null,"Quebec"]
[null,null,"Saskatchewan"]
[null,null,"Yukon"]