{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Master","Master Setup"],"not_rendered":{"charts":0,"images":21,"macros":1,"external_links":0,"defined_names":2,"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":"Master","index":0,"n_rows":199,"n_cols":16,"rows_kept":199,"cut":false,"hidden":false,"merged":[[40,2,41,2],[44,13,44,14],[42,2,42,7],[43,2,43,7],[44,2,44,7],[42,13,42,14],[45,2,45,7],[1,1,1,2],[47,10,47,12],[47,13,47,15],[45,13,45,14],[47,5,47,7],[24,1,38,1],[24,9,38,9],[40,11,40,12],[40,13,40,14],[43,13,43,14],[47,2,47,4],[43,11,43,12],[44,11,44,12],[45,11,45,12],[42,11,42,12],[1,13,1,15],[1,5,1,12],[9,9,23,9],[9,1,23,1],[6,12,6,14],[2,1,2,15],[3,1,3,15],[5,1,5,3],[5,4,5,5],[5,6,5,7],[5,9,5,11],[5,12,5,14],[6,1,6,3],[6,4,6,5],[6,6,6,7],[6,9,6,11]]}
[]
[null,"Form TD-18B",null,null,null,{"$f":"IF('Master Setup'!F14=\"Truck\",\"Truck Route:  \"&'Master Setup'!F15,\"Bulk Pump:  \"&'Master Setup'!F11)","v":"Bulk Pump:  "},null,null,null,null,null,null,null,"Revised 09-16-19- csw"]
[null,"NC Public Schools Transporation"]
[null,"Fuel and Lube Service"]
[]
[null,"Date/Title",null,null,"Station ",null,"Credit",null,null,"Fuel Total",null,null,"Oil Total"]
[null,{"$f":"RIGHT(CELL(\"filename\",E2),LEN(CELL(\"filename\",E2))-FIND(\"]\",CELL(\"filename\",E2)))","v":"Master"},null,null,{"$f":"IF('Master Setup'!F7>0,IF('Master Setup'!F7=6100,\"69950\", TEXT(LEFT('Master Setup'!F7,1),0)&TEXT(RIGHT('Master Setup'!F7,2),\"00\")&\"00\"),\"\")","v":""},null,null,null,null,{"$f":"IF(SUM(L41)>0,SUM(L41),\"\")","v":""},null,null,{"$f":"IF(SUM(N41)>0,SUM(N41),\"\")","v":""}]
[]
[null,null,"EQ/INV\nNumber","Fuel\nType","Gals","Lube\nType","Qty","Meter",null,null,"EQ/INV\nNumber","Fuel\nType","Gals","Lube\nType","Qty","Meter"]
[null,"Print Section #1",null,{"$f":"IF(AND($C10>0,$E10>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,"Print Section #3",null,{"$f":"IF(AND($K10>0,$M10>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C11>0,$E11>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K11>0,$M11>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C12>0,$E12>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K12>0,$M12>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C13>0,$E13>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K13>0,$M13>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C14>0,$E14>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K14>0,$M14>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C15>0,$E15>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K15>0,$M15>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C16>0,$E16>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K16>0,$M16>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C17>0,$E17>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K17>0,$M17>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C18>0,$E18>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K18>0,$M18>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C19>0,$E19>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K19>0,$M19>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C20>0,$E20>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K20>0,$M20>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C21>0,$E21>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K21>0,$M21>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C22>0,$E22>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K22>0,$M22>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C23>0,$E23>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K23>0,$M23>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C24>0,$E24>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K24>0,$M24>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,"Print Section #2",null,{"$f":"IF(AND($C25>0,$E25>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,"Print Section #4",null,{"$f":"IF(AND($K25>0,$M25>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C26>0,$E26>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K26>0,$M26>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C27>0,$E27>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K27>0,$M27>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C28>0,$E28>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K28>0,$M28>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C29>0,$E29>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K29>0,$M29>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C30>0,$E30>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K30>0,$M30>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C31>0,$E31>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K31>0,$M31>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C32>0,$E32>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K32>0,$M32>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C33>0,$E33>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K33>0,$M33>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C34>0,$E34>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K34>0,$M34>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C35>0,$E35>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K35>0,$M35>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C36>0,$E36>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K36>0,$M36>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C37>0,$E37>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K37>0,$M37>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C38>0,$E38>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K38>0,$M38>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[null,null,null,{"$f":"IF(AND($C39>0,$E39>0), LEFT('Master Setup'!$F$11,1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND($K39>0,$M39>0),LEFT('Master Setup'!$F$11,1),\"\")","v":""}]
[]
[null,null,"Notes:",null,null,null,null,null,null,null,"Form Totals:",{"$f":"IF(SUM(E10:E39,M10:M39)>0,ROUND(SUM(E10:E39,M10:M39),1),\"\")","v":""},null,{"$f":"IF(SUM(G10:G39,O10:O39)>0,ROUND(SUM(G10:G39,O10:O39),0),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,"Meters:","Bulk",null,"Truck"]
[null,null,null,null,null,null,null,null,null,null,"Ending"]
[null,null,null,null,null,null,null,null,null,null,"Beginning"]
[null,null,null,null,null,null,null,null,null,null,"Variance",{"$f":"IF(L44>0,SUM(L44-L45),\"\")","v":""},null,{"$f":"IF(SUM(N44-N45)>0,ROUND(SUM(N44-N45),1),\"\")","v":""}]
[]
[null,null,"Technician Signature:",null,null,{"$f":"IF('Master Setup'!F18<>\"\",IF('Master Setup'!F14=\"Truck\",'Master Setup'!F18,\"\"),\"\")","v":""},null,null,null,null,"Personnel No.",null,null,{"$f":"IF('Master Setup'!F19<>\"\",   IF('Master Setup'!F14=\"Truck\",'Master Setup'!F19,\"\"),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Lube Types"]
[null,null,"04","15W40 Oil for buses 159000049"]
[null,null,"45","DEF Gallons 1599000098"]
[null,null,"46","DEF Package 159000099"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Copy & Paste Data"]
[null,null,"Item #","Fuel","Gal","Oil","Qts","Meter",null,null,"Item #","Fuel","Gal","Oil","Qts","Meter"]

{"sheet":"Master Setup","index":1,"n_rows":138,"n_cols":12,"rows_kept":138,"cut":false,"hidden":false,"merged":[[2,2,2,5],[3,2,3,5],[1,9,5,9]]}
["`"]
[null,null,null,null,null,null,null,null,null,"Master Setup\nExample "]
[null,null,"Master Setup "]
[null,null,"(Fill in all applicable fields)"]
[]
[null,null,"Plant "]
[null,null,1,"Plant Number",null,null,null,null,null,6056]
[null,null,2,"County Name",null,{"$f":"IF(F7<>\"\",INDEX(D24:D138,MATCH(F7,C24:C138,0)),\"\")","v":""},null,null,null,"Macon",null,"Auto populates"]
[]
[null,null,"Default Fuel Type"]
[null,null,1,"Fuel Type",null,null,null,null,null,"Diesel",null,"Diesel or Unleaded"]
[]
[null,null,"Fuel Truck or Pump"]
[null,null,1,"Fuel dispensed from",null,null,null,null,null,"Truck ",null,"Truck or Bulk"]
[null,null,2,"Truck/Pump Number",null,null,null,null,null,"4001 Route A \n",null,"Truck = Vehicle & Description"]
[]
[null,null,"Driver  (Only use if  form is for Fuel Truck)"]
[null,null,1,"Name",null,null,null,null,null,"CS Wright",null,"First & Last"]
[null,null,2,"Personnel number",null,null,null,null,null,7804625,null,"Employee ID"]
[]
[]
[]
[null,null,"Plant Number","LEA Name",null,"Truck Capacity"]
[null,null,6001,"Alamance",null,1400]
[null,null,6002,"Alexander",null,1800]
[null,null,6003,"Alleghany"]
[null,null,6004,"Anson",null,"Fuel Type"]
[null,null,6005,"Ashe",null,"Unleaded"]
[null,null,6006,"Avery",null,"Diesel"]
[null,null,6007,"Beaufort"]
[null,null,6008,"Bertie",null,"Pump"]
[null,null,6009,"Bladen",null,"Bulk Pump"]
[null,null,6010,"Brunswick",null,"Truck"]
[null,null,6011,"Buncombe"]
[null,null,6111,"Asheville"]
[null,null,6012,"Burke"]
[null,null,6013,"Cabarrus"]
[null,null,6132,"Kannapolis"]
[null,null,6014,"Caldwell"]
[null,null,6015,"Camden"]
[null,null,6016,"Carteret"]
[null,null,6017,"Caswell"]
[null,null,6018,"Catawba"]
[null,null,6181,"Hickory"]
[null,null,6182,"Newton Conover"]
[null,null,6019,"Chatham"]
[null,null,6020,"Cherokee"]
[null,null,6021,"Chowan"]
[null,null,6022,"Clay"]
[null,null,6023,"Cleveland"]
[null,null,6024,"Columbus"]
[null,null,6241,"Whiteville"]
[null,null,6025,"Craven"]
[null,null,6026,"Cumberland"]
[null,null,6027,"Currituck"]
[null,null,6028,"Dare"]
[null,null,6029,"Davidson"]
[null,null,6291,"Lexington"]
[null,null,6292,"Thomasville"]
[null,null,6030,"Davie"]
[null,null,6031,"Duplin"]
[null,null,6032,"Durham"]
[null,null,6033,"Edgecombe"]
[null,null,6034,"Forsyth"]
[null,null,6035,"Franklin"]
[null,null,6036,"Gaston"]
[null,null,6037,"Gates"]
[null,null,6038,"Graham"]
[null,null,6039,"Granville"]
[null,null,6040,"Greene"]
[null,null,6041,"Guilford"]
[null,null,6042,"Halifax"]
[null,null,6421,"Roanoke Rapids"]
[null,null,6422,"Weldon"]
[null,null,6043,"Harnett"]
[null,null,6044,"Haywood"]
[null,null,6045,"Henderson"]
[null,null,6046,"Hertford"]
[null,null,6047,"Hoke"]
[null,null,6048,"Hyde"]
[null,null,6049,"Iredell"]
[null,null,6491,"Mooresville"]
[null,null,6050,"Jackson"]
[null,null,6051,"Johnston"]
[null,null,6052,"Jones"]
[null,null,6053,"Lee"]
[null,null,6054,"Lenoir"]
[null,null,6055,"Lincoln"]
[null,null,6056,"Macon"]
[null,null,6057,"Madison"]
[null,null,6058,"Martin"]
[null,null,6059,"McDowell"]
[null,null,6060,"Mecklenburg"]
[null,null,6061,"Mitchell"]
[null,null,6062,"Montgomery"]
[null,null,6063,"Moore"]
[null,null,6064,"Nash"]
[null,null,6065,"New Hanover"]
[null,null,6066,"Northampton"]
[null,null,6067,"Onslow"]
[null,null,6068,"Orange"]
[null,null,6681,"ChapelHill-Carrboro"]
[null,null,6069,"Pamlico"]
[null,null,6070,"Pasquotank"]
[null,null,6071,"Pender"]
[null,null,6072,"Perquimans"]
[null,null,6073,"Person"]
[null,null,6074,"Pitt"]
[null,null,6075,"Polk"]
[null,null,6076,"Randolph"]
[null,null,6761,"Asheboro"]
[null,null,6077,"Richmond"]
[null,null,6078,"Robeson"]
[null,null,6079,"Rockingham"]
[null,null,6080,"Rowan"]
[null,null,6081,"Rutherford"]
[null,null,6082,"Sampson"]
[null,null,6821,"Clinton"]
[null,null,6083,"Scotland"]
[null,null,6084,"Stanly"]
[null,null,6085,"Stokes"]
[null,null,6086,"Surry"]
[null,null,6861,"Elkin"]
[null,null,6862,"Mount Airy"]
[null,null,6087,"Swain"]
[null,null,6088,"Transylvania"]
[null,null,6089,"Tyrrell"]
[null,null,6090,"Union"]
[null,null,6091,"Vance"]
[null,null,6092,"Wake"]
[null,null,6093,"Warren"]
[null,null,6094,"Washington"]
[null,null,6095,"Watauga"]
[null,null,6096,"Wayne"]
[null,null,6097,"Wilkes"]
[null,null,6098,"Wilson"]
[null,null,6099,"Yadkin"]
[null,null,6100,"Yancey"]