{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Inventory","Work Order","Lists"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":10,"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":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Inventory","index":1,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Collection System Trouble Spots"]
[]
["         Problem Key                                                                                "]
["Grease","Grit","Roots","Debris"]
["G-2","GT-2","RT-2","D-2"]
["G-3","GT-3","RT-3","D-3"]
["G-4","GT-4","RT-4","D-4"]
[]
[]
["Sewershed","Pipe ID","UPS MH ID","DWNS MH ID","Location","Diam (in)","Length (ft)","Material","Problem","Equipment","Frequency Days  ","Last Maintained","Next Maintenance","Comment"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L11+K11","v":0}]
[2,"2-05-04","2-05","2-04","Water St",10,260,"VC","G3","Jet/vac",30,"2014-08-01",{"$f":"L12+K12","v":"2014-08-31"}]
["2","2-06-05","2-06","2-05","Water St",10,300,"VC","G3","Jet/vac",90,"2014-11-12",{"$f":"L13+K13","v":"2015-02-10"}]
["2","2-07-06","2-07","2-06","Water St",12,300,"VC","RT2","Rodder",360,"2014-11-19","2015-11-14"]
["1","1-05-04","1-05","1-04","Main St",15,300,"RCP","G2","Jet/vac",360,"2013-07-01","2014-06-26"]
[null,null,null,null,null,null,null,null,null,null,360,"2014-07-01","2015-06-26"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["1"]

{"sheet":"Work Order","index":2,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,0,2,3],[37,0,37,2],[35,0,35,2],[6,7,6,8],[25,0,25,5],[4,0,4,1],[4,4,4,5],[26,0,26,5],[27,0,27,5],[4,6,4,8]]}
["Sewer Cleaning Work Order Form"]
[]
[" Town of Tewksbury"]
[]
["Work Order Date       ",null,{"$f":"TODAY()","v":"2015-06-24"},null,"Work Order # ",null,{"$f":"A11&\" \"&TEXT(C5,\"mmm-dd-yyyy\")","v":"2-07-06 Jun-24-2015"}]
[]
["Reason for Maintenance",null,null,"CCTV  ___",null,"PM ___",null,"Service Call _______"]
[]
[]
["Pipe ID","UPS MH #","DWNS MH #","Location","Diam (in)","Length (ft)","Material","Problem","Equipment"]
["2-07-06","2-07","2-06","Water St",12,300,"VC","RT2","Rodder"]
[]
[]
[]
[]
[]
[]
["Cleaning Results"]
["Material","Clear","Light","Medium","Heavy","Not Rated"]
["Debris"]
["Grease"]
["Roots"]
["Other"]
[]
[]
["Remarks:"]
[]
[]
[]
["Recommended Actions:"]
["Cleaning frequency:",null,"The Same ___",null,"Increase ___",null,"Decrease ___"]
["Repair Pipe:  No ___","    No ___",null,"Yes ___","Comment _______________________________"]
["Repair MH:   No ___","    No ___",null,"Yes ___","Comment _______________________________"]
["Root Control: No ___",null,null,"Yes ___","Comment _______________________________"]
[]
["Completed by: ______________",null,null,null,"Date: __________"]
[]
["Supervisor Review: __________",null,null,null,"Date: __________"]

{"sheet":"Lists","index":3,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["pipematerial",null,"pipediameter",null,"problemkey",null,"pipes",null,"equipment"]
["AC",null,6,null,"G2",null,"2-05-04",null,"Jet/vac"]
["CI",null,8,null,"G3",null,"2-06-05",null,"Rodder"]
["DI",null,10,null,"G4",null,"2-07-06",null,"Rootx"]
["PE",null,12,null,"GT2",null,"2-08-07"]
["PVC",null,15,null,"GT3"]
["RCP",null,18,null,"GT4"]
["VC",null,21,null,"RT2"]
[null,null,24,null,"RT3"]
[null,null,30,null,"RT4"]
[null,null,null,null,"D2"]
[null,null,null,null,"D3"]
[null,null,null,null,"D4"]