{"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":224,"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":58,"n_cols":117,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"AARON HORTENBURY",null,null,null,null,null,"AUDRA M MOORE",null,null,null,null,null,"BILLY ALDRIDGE",null,null,null,null,null,"BRYAN FRANKLIN {director}",null,null,null,null,null,"CHRISTOPHER S COX",null,null,null,null,null,"DAKOTA J BAATZ",null,null,null,null,null,"DAVID L HEDGES",null,null,null,null,null,"ELIJAH T STIGERS",null,null,null,null,null,"FRANKIE W MASTERS",null,null,null,null,null,"GUSTAVO LARA",null,null,null,null,null,"JEREMY T CARMACK",null,null,null,null,null,"JERRY RUBLE {SECRETARY}",null,null,null,null,null,"JOHN T MCGINNIS",null,null,null,null,null,"NOAH AUGUSTINE-SMITH",null,null,null,null,null,"RONDA K HILL",null,null,null,null,null,"ROY M LEWIS",null,null,null,null,null,"TARA M PEYTON",null,null,null,null,null,"WHITNEY SMITH",null,null,null,null,null,"TOTAL"]
[null,null,null,null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20",null,"Hours",null,"Rate",null,"Jan - Dec 20"]
["Employee Wages, Taxes and Adjustments"]
[null,null,"Gross Pay"]
[null,null,null,"MANAGEMENT",null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,81030.91,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,62030.95,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,57953.66,null,null,null,null,null,0,null,null,null,null,null,{"$f":"ROUND(I5+O5+U5+AA5+AG5+AM5+AS5+AY5+BE5+BK5+BQ5+BW5+CC5+CI5+CO5+CU5+DA5+DG5,5)","v":201015.52}]
[null,null,null,"1000-109-DISTRIBUTION MAINS",null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,5,null,18,null,90,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,4,null,18.5,null,74,null,null,null,null,null,0,null,null,null,null,null,0,null,{"$f":"ROUND(E6+K6+Q6+W6+AC6+AI6+AO6+AU6+BA6+BG6+BM6+BS6+BY6+CE6+CK6+CQ6+CW6+DC6,5)","v":9},null,null,null,164]
[null,null,null,"1000-111 NEW METERS",74,null,13.5,null,999,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,156.5,null,18.5,null,2752.75,null,37.5,null,14,null,525,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,193,null,13,null,2509,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,109.5,null,13,null,1423.5,null,null,null,null,null,0,null,276,null,18.5,null,4842,null,null,null,null,null,0,null,null,null,null,null,0,null,{"$f":"ROUND(E7+K7+Q7+W7+AC7+AI7+AO7+AU7+BA7+BG7+BM7+BS7+BY7+CE7+CK7+CQ7+CW7+DC7,5)","v":846.5},null,null,null,13051.25]
[null,null,null,"1000-720 - MAINT/STRUCTURE",null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0]
[null,null,null,"1000-724 MAINT/DIST MAIN",14,null,13.5,null,189,null,null,null,null,null,0,null,2,null,14.5,null,29,null,null,null,null,null,0,null,33,null,17.5,null,577.5,null,21,null,14,null,294,null,null,null,null,null,0,null,null,null,null,null,0,null,10,null,18,null,180,null,28,null,13,null,364,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,30,null,13,null,390,null,null,null,null,null,0,null,54.5,null,18.5,null,965.75,null,null,null,null,null,0,null,null,null,null,null,0,null,{"$f":"ROUND(E9+K9+Q9+W9+AC9+AI9+AO9+AU9+BA9+BG9+BM9+BS9+BY9+CE9+CK9+CQ9+CW9+DC9,5)","v":192.5},null,null,null,2989.25]
[null,null,null,"1000-726-MAINT SERVICE METERS",2,null,13.5,null,27,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,31,null,18.5,null,565.5,null,8,null,14,null,112,null,null,null,null,null,0,null,null,null,null,null,0,null,44,null,19.5,null,858,null,20,null,13,null,260,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,36,null,13,null,468,null,52,null,18.350000000000001,null,934.2,null,51,null,18.5,null,903.5,null,null,null,null,null,0,null,null,null,null,null,0,null,244,null,null,null,4128.2]
[null,null,null,"1000-727-MAINT HYDRANTS",null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,8,null,18.5,null,148,null,null,null,null,null,0,null,null,null,null,null,0,null,8,null,null,null,148]
[null,null,null,"1000-728-MAINT WATER SALES",null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,12,null,14,null,168,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,9,null,17.5,null,157.5,null,null,null,null,null,0,null,null,null,null,null,0,null,21,null,null,null,325.5]
[null,null,null,"1000-801 HOLIDAY",48,null,14.5,null,656,null,184,null,19.75,null,3550,null,72,null,14.5,null,1044,null,null,null,null,null,0,null,120,null,18.5,null,2156,null,80,null,14,null,1120,null,null,null,null,null,0,null,56,null,13,null,728,null,104,null,19.5,null,1944,null,72,null,13,null,936,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,72,null,13,null,936,null,144,null,18.350000000000001,null,2562.4,null,112,null,18.5,null,2016,null,null,null,null,null,0,null,112,null,18.75,null,2016,null,1176,null,null,null,19664.400000000001]
[null,null,null,"1000-802-COLLECTIONS/ADMIN",614.5,null,14.5,null,8509.25,null,1628,null,19.75,null,30300.53,null,668,null,14.5,null,9686,null,null,null,null,null,0,null,893,null,18.5,null,15889.5,null,542.5,null,14,null,7595,null,null,null,null,null,0,null,325,null,13,null,4225,null,799.5,null,19.5,null,14455.5,null,533,null,13,null,6929,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,600,null,13,null,7800,null,1390,null,18.350000000000001,null,24489.5,null,849,null,18.5,null,15132,null,null,null,null,null,0,null,1826,null,18.75,null,32259.77,null,10668.5,null,null,null,177271.05]
[null,null,null,"1000-820-MAINT GENERAL PROP",null,null,null,null,0,null,null,null,null,null,0,null,16,null,14.5,null,232,null,null,null,null,null,0,null,8,null,18.5,null,148,null,null,null,14,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,3,null,13,null,39,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,8,null,13,null,104,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,35,null,null,null,523]
[null,null,null,"2000-109-DISTRIBUTION MAINS",6,null,13.5,null,81,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,36,null,18.5,null,642,null,16,null,14,null,224,null,null,null,null,null,0,null,null,null,null,null,0,null,8,null,18,null,144,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,66,null,null,null,1091]
[null,null,null,"2000-111-NEW METERS",5,null,13.5,null,67.5,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,60,null,18.5,null,1060,null,31,null,14,null,434,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,20,null,13,null,260,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,71,null,13,null,923,null,null,null,null,null,0,null,27,null,18.5,null,480.5,null,null,null,null,null,0,null,null,null,null,null,0,null,214,null,null,null,3225]
[null,null,null,"2000-113 NEW HYDRANTS",null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,4,null,14,null,56,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,4,null,null,null,56]
[null,null,null,"2000-724 MAINT DIST MAINS",14.5,null,14.5,null,201.25,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,39,null,18.5,null,694.5,null,6,null,14,null,84,null,null,null,null,null,0,null,null,null,null,null,0,null,2,null,18,null,36,null,27,null,13,null,351,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,35.5,null,13,null,461.5,null,null,null,null,null,0,null,26,null,18.5,null,465,null,null,null,null,null,0,null,null,null,null,null,0,null,150,null,null,null,2293.25]
[null,null,null,"2000-726 MAINT SERVICE METERS",null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,8,null,18.5,null,148,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,35.5,null,19.5,null,692.25,null,34,null,13,null,442,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,2,null,13,null,26,null,26,null,18.350000000000001,null,459.1,null,26,null,18.5,null,471,null,null,null,null,null,0,null,null,null,null,null,0,null,131.5,null,null,null,2238.35]
[null,null,null,"2000-727-MAINT HYDRANTS",4,null,13.5,null,54,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,4,null,17.5,null,70,null,null,null,null,null,0,null,null,null,null,null,0,null,8,null,null,null,124]
[null,null,null,"2000-728-WATER SALES",null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,12,null,14,null,168,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,12,null,null,null,168]
[null,null,null,"2000-802 COLLECTION/ADMIN",349,null,14.5,null,4783.5,null,null,null,null,null,0,null,366,null,14.5,null,5307,null,null,null,null,null,0,null,369,null,18.5,null,6541.5,null,354,null,14,null,4956,null,null,null,null,null,0,null,160,null,13,null,2080,null,632.5,null,19.5,null,11440.5,null,208,null,13,null,2704,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,176,null,13,null,2288,null,218,null,18.350000000000001,null,3790.3,null,549.5,null,18.5,null,9758.75,null,null,null,null,null,0,null,null,null,null,null,0,null,3382,null,null,null,53649.55]
[null,null,null,"2000-820 MAINT GENERAL PROP",null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,8,null,18.5,null,148,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,8,null,13,null,104,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,16,null,null,null,252]
[null,null,null,"Hourly Sick",55.5,null,14.5,null,754.25,null,121,null,19.75,null,2244.25,null,null,null,null,null,0,null,null,null,null,null,0,null,239.5,null,18.5,null,4226.25,null,28.5,null,14,null,399,null,null,null,null,null,0,null,4,null,13,null,52,null,408,null,19.5,null,7920,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,18,null,13,null,234,null,116.5,null,18.350000000000001,null,2058.7800000000002,null,17,null,18.5,null,306.5,null,null,null,null,null,0,null,73.5,null,17.25,null,1267.8900000000001,null,1081.5,null,null,null,19462.919999999998]
[null,null,null,"Hourly Vacation",91.5,null,14.5,null,1258.75,null,189,null,19.75,null,3534.02,null,8,null,14.5,null,116,null,null,null,null,null,0,null,136,null,18.5,null,2448,null,63.5,null,14,null,889,null,null,null,null,null,0,null,null,null,null,null,0,null,87,null,18,null,1578.75,null,28,null,13,null,364,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,48,null,13,null,624,null,184,null,18.350000000000001,null,3280.4,null,146,null,18.5,null,2600,null,null,null,null,null,0,null,112,null,18.75,null,1992,null,1093,null,null,null,18684.919999999998]
[null,null,null,"OVERTIME 1000-722 MAINT/PUMP",null,null,null,null,0,null,null,null,null,null,0,null,19,null,21.75,null,413.25,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,19,null,null,null,413.25]
[null,null,null,"OVERTIME 1000-724 MAINT DIST",6,null,20.25,null,121.5,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,4.5,null,26.25,null,118.13,null,9.5,null,21,null,199.5,null,null,null,null,null,0,null,null,null,null,null,0,null,5,null,27,null,135,null,5,null,19.5,null,97.5,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,5,null,19.5,null,97.5,null,null,null,null,null,0,null,13.5,null,26.25,null,354.38,null,null,null,null,null,0,null,null,null,null,null,0,null,48.5,null,null,null,1123.51]
[null,null,null,"OVERTIME 1000-726 MAINT SVC MET",12,null,20.25,null,243,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,2,null,26.25,null,52.5,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,5,null,26.25,null,131.25,null,null,null,null,null,0,null,null,null,null,null,0,null,19,null,null,null,426.75]
[null,null,null,"OVERTIME 1000-802 COLLECT/ADMIN",2,null,20.25,null,40.5,null,null,null,null,null,0,null,19.5,null,21.75,null,424.13,null,null,null,null,null,0,null,null,null,null,null,0,null,3,null,21,null,63,null,null,null,null,null,0,null,null,null,null,null,0,null,7.5,null,27,null,202.5,null,2,null,19.5,null,39,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,32,null,27.53,null,860.73,null,6,null,26.25,null,157.5,null,null,null,null,null,0,null,1.5,null,28.13,null,41.07,null,73.5,null,null,null,1828.43]
[null,null,null,"OVERTIME 1000-820 MAINT GENERAL",11,null,20.25,null,225.75,null,null,null,null,null,0,null,2,null,21.75,null,43.5,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,13,null,null,null,269.25]
[null,null,null,"OVERTIME 2000-722 MAINT/PUMPING",null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,2,null,26.25,null,52.5,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,3,null,27,null,81,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,3,null,26.25,null,78.75,null,null,null,null,null,0,null,null,null,null,null,0,null,8,null,null,null,212.25]
[null,null,null,"OVERTIME 2000-724 MAIN DIS MAIN",12.5,null,21.75,null,260.63,null,null,null,null,null,0,null,5,null,21.75,null,108.75,null,null,null,null,null,0,null,15.5,null,26.25,null,406.88,null,7.5,null,21,null,157.5,null,null,null,null,null,0,null,null,null,null,null,0,null,10,null,27,null,270,null,20.5,null,19.5,null,399.75,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,7,null,19.5,null,136.5,null,null,null,null,null,0,null,3.5,null,26.25,null,91.88,null,null,null,null,null,0,null,null,null,null,null,0,null,81.5,null,null,null,1831.89]
[null,null,null,"OVERTIME 2000-726 MAINT SVC MTR",null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,2,null,26.25,null,52.5,null,2,null,21,null,42,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,4,null,null,null,94.5]
[null,null,null,"OVERTIME 2000-802 COLLECT/ADMIN",1,null,20.25,null,20.25,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,3,null,27.75,null,81.75,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,2,null,27,null,54,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,2,null,26.03,null,52.06,null,17,null,26.25,null,446.26,null,null,null,null,null,0,null,null,null,null,null,0,null,25,null,null,null,654.32000000000005]
[null,null,null,"812-COMMISSION MEMBER FEES",null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,600,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,4200,null,null,null,null,null,1600,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,6400]
[null,null,null,"Bonus",null,null,null,null,0,null,null,null,null,null,1000,null,null,null,null,null,500,null,null,null,null,null,0,null,null,null,null,null,1000,null,null,null,null,null,250,null,null,null,null,null,2100,null,null,null,null,null,250,null,null,null,null,null,1000,null,null,null,null,null,500,null,null,null,null,null,1300,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,500,null,null,null,null,null,4758.8,null,null,null,null,null,1000,null,null,null,null,null,1100,null,null,null,null,null,1000,null,null,null,null,null,16258.8]
[null,null,null,"Retro-active check",null,null,null,null,0,null,null,null,null,null,720,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,514.25,null,null,null,null,null,0,null,null,null,null,null,820.8,null,null,null,null,null,0,null,null,null,null,null,783,null,null,null,null,null,0,null,null,null,null,null,700.8,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,498,null,null,null,null,null,516.5,null,null,null,null,null,700.8,null,null,null,null,null,720,null,null,null,null,null,5974.15]
[null,null,"Total Gross Pay",null,{"$f":"ROUND(SUM(E4:E38),5)","v":1322.5},null,null,null,{"$f":"ROUND(SUM(I4:I38),5)","v":18492.13},null,{"$f":"ROUND(SUM(K4:K38),5)","v":2122},null,null,null,{"$f":"ROUND(SUM(O4:O38),5)","v":41348.800000000003},null,{"$f":"ROUND(SUM(Q4:Q38),5)","v":1177.5},null,null,null,{"$f":"ROUND(SUM(U4:U38),5)","v":17903.63},null,null,null,null,null,{"$f":"ROUND(SUM(AA4:AA38),5)","v":600},null,{"$f":"ROUND(SUM(AC4:AC38),5)","v":2166},null,null,null,{"$f":"ROUND(SUM(AG4:AG38),5)","v":40276.01},null,{"$f":"ROUND(SUM(AI4:AI38),5)","v":1238},null,null,null,{"$f":"ROUND(SUM(AM4:AM38),5)","v":17736},null,null,null,null,null,{"$f":"ROUND(SUM(AS4:AS38),5)","v":83951.71},null,{"$f":"ROUND(SUM(AU4:AU38),5)","v":545},null,null,null,{"$f":"ROUND(SUM(AY4:AY38),5)","v":7335},null,{"$f":"ROUND(SUM(BA4:BA38),5)","v":2163},null,null,null,{"$f":"ROUND(SUM(BE4:BE38),5)","v":41864.5},null,{"$f":"ROUND(SUM(BG4:BG38),5)","v":1193.5},null,null,null,{"$f":"ROUND(SUM(BK4:BK38),5)","v":16194.25},null,null,null,null,null,{"$f":"ROUND(SUM(BQ4:BQ38),5)","v":64031.75},null,null,null,null,null,{"$f":"ROUND(SUM(BW4:BW38),5)","v":4200},null,null,null,null,null,{"$f":"ROUND(SUM(CC4:CC38),5)","v":1600},null,{"$f":"ROUND(SUM(CE4:CE38),5)","v":1226},null,null,null,{"$f":"ROUND(SUM(CI4:CI38),5)","v":16516},null,{"$f":"ROUND(SUM(CK4:CK38),5)","v":2164.5},null,null,null,{"$f":"ROUND(SUM(CO4:CO38),5)","v":43744.27},null,{"$f":"ROUND(SUM(CQ4:CQ38),5)","v":2207},null,null,null,{"$f":"ROUND(SUM(CU4:CU38),5)","v":41167.019999999997},null,null,null,null,null,{"$f":"ROUND(SUM(DA4:DA38),5)","v":59754.46},null,{"$f":"ROUND(SUM(DC4:DC38),5)","v":2125},null,null,null,{"$f":"ROUND(SUM(DG4:DG38),5)","v":39296.730000000003},null,{"$f":"ROUND(E39+K39+Q39+W39+AC39+AI39+AO39+AU39+BA39+BG39+BM39+BS39+BY39+CE39+CK39+CQ39+CW39+DC39,5)","v":19650},null,null,null,556012.26]
[null,null,"Deductions from Gross Pay"]
[null,null,null,"Aflac pre-tax",null,null,null,null,-67.14,null,null,null,null,null,-911.07,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,-470.64,null,null,null,null,null,0,null,null,null,null,null,-725.04,null,null,null,null,null,0,null,null,null,null,null,-1638.23,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,-486.54,null,null,null,null,null,0,null,null,null,null,null,-876.62,null,null,null,null,null,-818.85,null,null,null,null,null,{"$f":"ROUND(I41+O41+U41+AA41+AG41+AM41+AS41+AY41+BE41+BK41+BQ41+BW41+CC41+CI41+CO41+CU41+DA41+DG41,5)","v":-5994.13}]
[null,null,null,"Colonial LIfe - pretax",null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,-417.64,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,-417.64]
[null,null,null,"Deferred Compensation",null,null,null,null,0,null,null,null,null,null,-927.5,null,null,null,null,null,-50,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,-1060,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,-5150,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,-795,null,null,null,null,null,-927.5,null,null,null,null,null,-795,null,null,null,null,null,-1060,null,null,null,null,null,-10765]
[null,null,null,"Liberty National pretax",null,null,null,null,0,null,null,null,null,null,-293.62,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,-199.29,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,-664.38,null,null,null,null,null,0,null,null,null,null,null,-293.62,null,null,null,null,null,-1450.91]
[null,null,null,"Retirement - Employee",null,null,null,null,-1109.56,null,null,null,null,null,-2067.44,null,null,null,null,null,-625.53,null,null,null,null,null,0,null,null,null,null,null,-2416.58,null,null,null,null,null,-749.28,null,null,null,null,null,-4197.4799999999996,null,null,null,null,null,-31.2,null,null,null,null,null,-2093.23,null,null,null,null,null,-534.66,null,null,null,null,null,-3201.56,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,-596.28,null,null,null,null,null,-2187.2199999999998,null,null,null,null,null,-2470.0500000000002,null,null,null,null,null,-2987.89,null,null,null,null,null,-1964.84,null,null,null,null,null,-27232.799999999999]
[null,null,"Total Deductions from Gross Pay",null,null,null,null,null,{"$f":"ROUND(SUM(I40:I45),5)","v":-1176.7},null,null,null,null,null,{"$f":"ROUND(SUM(O40:O45),5)","v":-4199.63},null,null,null,null,null,{"$f":"ROUND(SUM(U40:U45),5)","v":-675.53},null,null,null,null,null,{"$f":"ROUND(SUM(AA40:AA45),5)","v":0},null,null,null,null,null,{"$f":"ROUND(SUM(AG40:AG45),5)","v":-2887.22},null,null,null,null,null,{"$f":"ROUND(SUM(AM40:AM45),5)","v":-948.57},null,null,null,null,null,{"$f":"ROUND(SUM(AS40:AS45),5)","v":-6400.16},null,null,null,null,null,{"$f":"ROUND(SUM(AY40:AY45),5)","v":-31.2},null,null,null,null,null,{"$f":"ROUND(SUM(BE40:BE45),5)","v":-3731.46},null,null,null,null,null,{"$f":"ROUND(SUM(BK40:BK45),5)","v":-534.66},null,null,null,null,null,{"$f":"ROUND(SUM(BQ40:BQ45),5)","v":-8351.56},null,null,null,null,null,{"$f":"ROUND(SUM(BW40:BW45),5)","v":0},null,null,null,null,null,{"$f":"ROUND(SUM(CC40:CC45),5)","v":0},null,null,null,null,null,{"$f":"ROUND(SUM(CI40:CI45),5)","v":-596.28},null,null,null,null,null,{"$f":"ROUND(SUM(CO40:CO45),5)","v":-3468.76},null,null,null,null,null,{"$f":"ROUND(SUM(CU40:CU45),5)","v":-4061.93},null,null,null,null,null,{"$f":"ROUND(SUM(DA40:DA45),5)","v":-4659.51},null,null,null,null,null,{"$f":"ROUND(SUM(DG40:DG45),5)","v":-4137.3100000000004},null,null,null,null,null,-45860.480000000003]
[null,"Adjusted Gross Pay",null,null,{"$f":"ROUND(E39+E46,5)","v":1322.5},null,null,null,{"$f":"ROUND(I39+I46,5)","v":17315.43},null,{"$f":"ROUND(K39+K46,5)","v":2122},null,null,null,{"$f":"ROUND(O39+O46,5)","v":37149.17},null,{"$f":"ROUND(Q39+Q46,5)","v":1177.5},null,null,null,{"$f":"ROUND(U39+U46,5)","v":17228.099999999999},null,null,null,null,null,{"$f":"ROUND(AA39+AA46,5)","v":600},null,{"$f":"ROUND(AC39+AC46,5)","v":2166},null,null,null,{"$f":"ROUND(AG39+AG46,5)","v":37388.79},null,{"$f":"ROUND(AI39+AI46,5)","v":1238},null,null,null,{"$f":"ROUND(AM39+AM46,5)","v":16787.43},null,null,null,null,null,{"$f":"ROUND(AS39+AS46,5)","v":77551.55},null,{"$f":"ROUND(AU39+AU46,5)","v":545},null,null,null,{"$f":"ROUND(AY39+AY46,5)","v":7303.8},null,{"$f":"ROUND(BA39+BA46,5)","v":2163},null,null,null,{"$f":"ROUND(BE39+BE46,5)","v":38133.040000000001},null,{"$f":"ROUND(BG39+BG46,5)","v":1193.5},null,null,null,{"$f":"ROUND(BK39+BK46,5)","v":15659.59},null,null,null,null,null,{"$f":"ROUND(BQ39+BQ46,5)","v":55680.19},null,null,null,null,null,{"$f":"ROUND(BW39+BW46,5)","v":4200},null,null,null,null,null,{"$f":"ROUND(CC39+CC46,5)","v":1600},null,{"$f":"ROUND(CE39+CE46,5)","v":1226},null,null,null,{"$f":"ROUND(CI39+CI46,5)","v":15919.72},null,{"$f":"ROUND(CK39+CK46,5)","v":2164.5},null,null,null,{"$f":"ROUND(CO39+CO46,5)","v":40275.51},null,{"$f":"ROUND(CQ39+CQ46,5)","v":2207},null,null,null,{"$f":"ROUND(CU39+CU46,5)","v":37105.089999999997},null,null,null,null,null,{"$f":"ROUND(DA39+DA46,5)","v":55094.95},null,{"$f":"ROUND(DC39+DC46,5)","v":2125},null,null,null,{"$f":"ROUND(DG39+DG46,5)","v":35159.42},null,{"$f":"ROUND(E47+K47+Q47+W47+AC47+AI47+AO47+AU47+BA47+BG47+BM47+BS47+BY47+CE47+CK47+CQ47+CW47+DC47,5)","v":19650},null,null,null,510151.78]
[null,"Taxes Withheld"]
[null,null,"Federal Withholding",null,null,null,null,null,-1673,null,null,null,null,null,-2003,null,null,null,null,null,-1111,null,null,null,null,null,0,null,null,null,null,null,-3797,null,null,null,null,null,-1596,null,null,null,null,null,-11730,null,null,null,null,null,-383,null,null,null,null,null,-3904,null,null,null,null,null,-904,null,null,null,null,null,-6921,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,-899,null,null,null,null,null,-4573,null,null,null,null,null,-3764,null,null,null,null,null,-4692,null,null,null,null,null,-2309,null,null,null,null,null,{"$f":"ROUND(I49+O49+U49+AA49+AG49+AM49+AS49+AY49+BE49+BK49+BQ49+BW49+CC49+CI49+CO49+CU49+DA49+DG49,5)","v":-50259}]
[null,null,"Medicare Employee",null,null,null,null,null,-267.16000000000003,null,null,null,null,null,-582.09,null,null,null,null,null,-259.60000000000002,null,null,null,null,null,-8.6999999999999993,null,null,null,null,null,-577.17999999999995,null,null,null,null,null,-254.28,null,null,null,null,null,-1200.73,null,null,null,null,null,-106.36,null,null,null,null,null,-583.28,null,null,null,null,null,-234.82,null,null,null,null,null,-928.46,null,null,null,null,null,-60.9,null,null,null,null,null,-23.2,null,null,null,null,null,-239.48,null,null,null,null,null,-627.24,null,null,null,null,null,-587.29,null,null,null,null,null,-853.73,null,null,null,null,null,-553.66999999999996,null,null,null,null,null,-7948.17]
[null,null,"Social Security Employee",null,null,null,null,null,-1142.3499999999999,null,null,null,null,null,-2488.9299999999998,null,null,null,null,null,-1110.03,null,null,null,null,null,-37.200000000000003,null,null,null,null,null,-2467.9299999999998,null,null,null,null,null,-1087.28,null,null,null,null,null,-5134.16,null,null,null,null,null,-454.77,null,null,null,null,null,-2494.0300000000002,null,null,null,null,null,-1004.04,null,null,null,null,null,-3969.97,null,null,null,null,null,-260.39999999999998,null,null,null,null,null,-99.2,null,null,null,null,null,-1023.99,null,null,null,null,null,-2681.98,null,null,null,null,null,-2511.16,null,null,null,null,null,-3650.43,null,null,null,null,null,-2367.42,null,null,null,null,null,-33985.269999999997]
[null,null,"KY - Withholding",null,null,null,null,null,-784.22,null,null,null,null,null,-1717.54,null,null,null,null,null,-784.95,null,null,null,null,null,-18.96,null,null,null,null,null,-1729.39,null,null,null,null,null,-755.29,null,null,null,null,null,-3737.33,null,null,null,null,null,-324.39,null,null,null,null,null,-1766.63,null,null,null,null,null,-706.49,null,null,null,null,null,-2643.92,null,null,null,null,null,-132.72,null,null,null,null,null,0,null,null,null,null,null,-711.85,null,null,null,null,null,-1873.72,null,null,null,null,null,-1715.16,null,null,null,null,null,-2614.73,null,null,null,null,null,-1617.95,null,null,null,null,null,-23635.24]
[null,null,"Medicare Employee Addl Tax",null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0]
[null,null,"Shelby County Local Tax",null,null,null,null,null,-183.64,null,null,null,null,null,-412.05,null,null,null,null,null,-179.06,null,null,null,null,null,-6,null,null,null,null,null,-400.99,null,null,null,null,null,-176,null,null,null,null,null,-836.67,null,null,null,null,null,-73.349999999999994,null,null,null,null,null,-417.18,null,null,null,null,null,-161.94999999999999,null,null,null,null,null,-638.01,null,null,null,null,null,-42,null,null,null,null,null,-16,null,null,null,null,null,-165.17,null,null,null,null,null,-436.05,null,null,null,null,null,-409.91,null,null,null,null,null,-595.36,null,null,null,null,null,-391.61,null,null,null,null,null,-5541]
[null,"Total Taxes Withheld",null,null,null,null,null,null,{"$f":"ROUND(SUM(I48:I54),5)","v":-4050.37},null,null,null,null,null,{"$f":"ROUND(SUM(O48:O54),5)","v":-7203.61},null,null,null,null,null,{"$f":"ROUND(SUM(U48:U54),5)","v":-3444.64},null,null,null,null,null,{"$f":"ROUND(SUM(AA48:AA54),5)","v":-70.86},null,null,null,null,null,{"$f":"ROUND(SUM(AG48:AG54),5)","v":-8972.49},null,null,null,null,null,{"$f":"ROUND(SUM(AM48:AM54),5)","v":-3868.85},null,null,null,null,null,{"$f":"ROUND(SUM(AS48:AS54),5)","v":-22638.89},null,null,null,null,null,{"$f":"ROUND(SUM(AY48:AY54),5)","v":-1341.87},null,null,null,null,null,{"$f":"ROUND(SUM(BE48:BE54),5)","v":-9165.1200000000008},null,null,null,null,null,{"$f":"ROUND(SUM(BK48:BK54),5)","v":-3011.3},null,null,null,null,null,{"$f":"ROUND(SUM(BQ48:BQ54),5)","v":-15101.36},null,null,null,null,null,{"$f":"ROUND(SUM(BW48:BW54),5)","v":-496.02},null,null,null,null,null,{"$f":"ROUND(SUM(CC48:CC54),5)","v":-138.4},null,null,null,null,null,{"$f":"ROUND(SUM(CI48:CI54),5)","v":-3039.49},null,null,null,null,null,{"$f":"ROUND(SUM(CO48:CO54),5)","v":-10191.99},null,null,null,null,null,{"$f":"ROUND(SUM(CU48:CU54),5)","v":-8987.52},null,null,null,null,null,{"$f":"ROUND(SUM(DA48:DA54),5)","v":-12406.25},null,null,null,null,null,{"$f":"ROUND(SUM(DG48:DG54),5)","v":-7239.65},null,null,null,null,null,-121368.68]
[]
[null,null,null,"JOB TITLE:","SERVICE TECH ",null,null,null,null,null,"Administrative Assistant II",null,null,null,null,null,"Meter Reader",null,null,null,null,null,"Board Member",null,null,null,null,null,"Service Technician",null,null,null,null,null,"Service Technician",null,null,null,null,null,"Manager",null,null,null,null,null,"Service Technician",null,null,null,null,null,"Service Technician",null,null,null,null,null,"Meter Reader",null,null,null,null,null,"Assistant Manager",null,null,null,null,null,"Board Member",null,null,null,null,null,"Board Member",null,null,null,null,null,"Service Technician",null,null,null,null,null,"Service Technician",null,null,null,null,null,"Service Technician",null,null,null,null,null,"Office Manager",null,null,null,null,null,"Aministrative Assistant"]
[null,null,null,"HIRE DATE / TERMINATION DATE:","TERMINATION DATE: 8-5-2020",null,null,null,null,null,"Hire Date: 7-21-2004",null,null,null,null,null,"Hire Date: 6/16/2020",null,null,null,null,null,null,null,null,null,null,null,"Hire Date: 4/29/2011",null,null,null,null,null,"Termination Date: 7-15-2021",null,null,null,null,null,"Hire Date: 4/1/1999",null,null,null,null,null,"Termination Date: 7-15-2021",null,null,null,null,null,"Hire Date: 2-5-2006",null,null,null,null,null,"Hire Date: 6-15-2020",null,null,null,null,null,"Hire Date: 1-3-2002",null,null,null,null,null,"deceased",null,null,null,null,null,null,null,null,null,null,null,"Termination Date: 2-4-2021",null,null,null,null,null,"Hire Date: 3-11-2005",null,null,null,null,null,"Hire Date: 5-27-2011",null,null,null,null,null,"Hire Date: 6-1-1998",null,null,null,null,null,"Hire Date: 2-12-2007"]