{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["QuickBooks Desktop Export Tips","Sheet1"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":78,"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":"QuickBooks Desktop Export Tips","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet1","index":1,"n_rows":66,"n_cols":15,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Type",null,"Date",null,"Num",null,"Name",null,"Split",null,"Amount","Gallons"]
[]
["610 · Purchased Water"]
[null,null,null,"Bill",null,"2023-01-04",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,9941.7800000000007,4772200]
[null,null,null,"Bill",null,"2023-01-04",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,4087.3,1868645]
[null,null,null,"Bill",null,"2023-01-04",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,7156.15,3467314]
[null,null,null,null,null,null,null,null,null,null,null,"JANUARY",null,{"$f":"SUM(N4:N6)","v":21185.230000000003},{"$f":"SUM(O4:O6)","v":10108159}]
[]
[null,null,null,"Bill",null,"2023-02-07",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,11581.85,5581800]
[null,null,null,"Bill",null,"2023-02-07",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,5512.03,2609071]
[null,null,null,"Bill",null,"2023-02-07",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,8017.1,3915402]
[null,null,null,null,null,null,null,null,null,null,null,"FEBRUARY",null,{"$f":"SUM(N9:N11)","v":25110.980000000003},{"$f":"SUM(O9:O11)","v":12106273}]
[]
[null,null,null,"Bill",null,"2023-03-03",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,7709.04,3755069]
[null,null,null,"Bill",null,"2023-03-03",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,4725.33,2198778]
[null,null,null,"Bill",null,"2023-03-13",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,11414.75,5507850]
[null,null,null,null,null,null,null,null,null,null,null,"MARCH",null,{"$f":"SUM(N14:N16)","v":23849.119999999999},{"$f":"SUM(O14:O16)","v":11461697}]
[]
[null,null,null,"Bill",null,"2023-04-12",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,10465.41,5036690]
[null,null,null,"Bill",null,"2023-04-12",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,6529.58,3141215]
[null,null,null,"Bill",null,"2023-04-12",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,4767.57,2222822]
[null,null,null,null,null,null,null,null,null,null,null,"APRIL",null,{"$f":"SUM(N19:N21)","v":21762.559999999998},{"$f":"SUM(O19:O21)","v":10400727}]
[]
[null,null,null,"Bill",null,"2023-05-15",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,11115.34,5375790]
[null,null,null,"Bill",null,"2023-05-15",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,4844.3500000000004,2262754]
[null,null,null,"Bill",null,"2023-05-15",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,8031.34,3922813]
[null,null,null,null,null,null,null,null,null,null,null,"MAY",null,{"$f":"SUM(N24:N26)","v":23991.03},{"$f":"SUM(O24:O26)","v":11561357}]
[]
[null,null,null,"Bill",null,"2023-06-14",null,"CON 121",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,11388.49,5510410]
[null,null,null,"Bill",null,"2023-06-14",null,"CON BKSG",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,7968.75,3890236]
[null,null,null,"Bill",null,"2023-06-14",null,"HRD",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,4142.37,1897427]
[null,null,null,null,null,null,null,null,null,null,null,"JUNE",null,{"$f":"SUM(N29:N31)","v":23499.609999999997},{"$f":"SUM(O29:O31)","v":11298073}]
[]
[null,null,null,"Bill",null,"2023-07-10",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,4487.28,2076802]
[null,null,null,"Bill",null,"2023-07-10",null,"2nd feed",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,9266.6,4565706]
[null,null,null,"Bill",null,"2023-07-10",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,14272.41,6949990]
[null,null,null,null,null,null,null,null,null,null,null,"JULY",null,{"$f":"SUM(N34:N36)","v":28026.29},{"$f":"SUM(O34:O36)","v":13592498}]
[]
[null,null,null,"Bill",null,"2023-08-10",null,"hrd",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,4726.6400000000003,2201437]
[null,null,null,"Bill",null,"2023-08-10",null,"CON",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,8877.7099999999991,4363309]
[null,null,null,"Bill",null,"2023-08-10",null,"CON2",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,13021.47,6331060]
[null,null,null,null,null,null,null,null,null,null,null,"AUGUST",null,{"$f":"SUM(N39:N41)","v":26625.82},{"$f":"SUM(O39:O41)","v":12895806}]
[]
[null,null,null,"Bill",null,"2023-09-14",null,"CON121",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,13426.15,6545220]
[null,null,null,"Bill",null,"2023-09-14",null,"HRD",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,6265.07,3002060]
[null,null,null,"Bill",null,"2023-09-14",null,"CONBKS",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,9407.0499999999993,4638803]
[null,null,null,"Bill",null,"2023-09-14",null,"HK",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,826.45,145758]
[null,null,null,null,null,null,null,null,null,null,null,"SEPTEMBER",null,{"$f":"SUM(N44:N47)","v":29924.720000000001},{"$f":"SUM(O44:O47)","v":14331841}]
[]
[null,null,null,"Bill",null,"2023-10-09",null,"CONSBACK",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,8723.08,4282831]
[null,null,null,"Bill",null,"2023-10-09",null,"HARDEMAN",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,4128.04,1889941]
[null,null,null,"Bill",null,"2023-10-09",null,"HICKORY",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,2686.44,708071]
[null,null,null,"Bill",null,"2023-10-09",null,"CONSUMBERS121",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,11459.99,5557640]
[null,null,null,null,null,null,null,null,null,null,null,"OCTOBER",null,{"$f":"SUM(N50:N53)","v":26997.55},{"$f":"SUM(O50:O53)","v":12438483}]
[]
[null,null,null,"Bill",null,"2023-11-08",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,11364.14,5524290]
[null,null,null,"Bill",null,"2023-11-08",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,8329.69,4075946]
[null,null,null,"Bill",null,"2023-11-08",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,4008.64,1825648]
[null,null,null,null,null,null,null,null,null,null,null,"NOVEMBER",null,{"$f":"SUM(N56:N58)","v":23702.47},{"$f":"SUM(O56:O58)","v":11425884}]
[]
[null,null,null,"Bill",null,"2023-12-19",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,4037.55,1840580]
[null,null,null,"Bill",null,"2023-12-19",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,8235.19,4026762]
[null,null,null,"Bill",null,"2023-12-19",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,11284.9,5484230]
[null,null,null,null,null,null,null,null,null,null,null,"DECEMBER",null,{"$f":"SUM(N61:N63)","v":23557.64},{"$f":"SUM(O61:O63)","v":11351572}]
[]
["Total 610 · Purchased Water",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N7,N12,N17,N22,N27,N32,N37,N42,N48,N54,N59,N64)","v":298233.02},{"$f":"SUM(O7,O12,O17,O22,O27,O32,O37,O42,O48,O54,O59,O64)","v":142972370}]