{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,1,1,1],[0,0,1,0]]}
["Starting Date","2025-01-01"]
[]
["Ending date of payroll","Days to Date","Item","YTD Amount","Daily","Weekly","Bi-Weekly","Monthly","Annually"]
[null,{"$f":"IF(A4=\"\",\"\",_xlfn.DAYS(A4,B1))","v":""},"Gross Pay",null,{"$f":"IF($D4=\"\",\"\",D4/$B$4)","v":""},{"$f":"IF($D4=\"\",\"\",E4*7)","v":""},{"$f":"IF($D4=\"\",\"\",E4*14)","v":""},{"$f":"IF($D4=\"\",\"\",F4*4.3)","v":""},{"$f":"IF($D4=\"\",\"\",H4*12)","v":""}]
[null,null,"W-4 WH",null,{"$f":"IF($D5=\"\",\"\",D5/$B$4)","v":""},{"$f":"IF($D5=\"\",\"\",E5*7)","v":""},{"$f":"IF($D5=\"\",\"\",E5*14)","v":""},{"$f":"IF($D5=\"\",\"\",F5*4.3)","v":""},{"$f":"IF($D5=\"\",\"\",H5*12)","v":""}]
[null,null,"State W/H",null,"","","","",""]
[null,null,"Local W/H",null,"","","","",""]
[null,null,"Medical W/H",null,"","","","",""]
[null,null,"Retirement",null,{"$f":"IF($D9=\"\",\"\",D9/$B$4)","v":""},{"$f":"IF($D9=\"\",\"\",E9*7)","v":""},{"$f":"IF($D9=\"\",\"\",E9*14)","v":""},"",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]
[null,null,null,null,"","","","",""]

{"sheet":"Sheet2","index":1,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item","Monthly"]
[null,null,"Jan",null,null,"Dec",null,null,"Nov",null,null,"Oct",null,null,null,null,null,"Gross Pay",4019.592916666667]
[null,null,3994.2,null,null,5276.32,null,null,5640,null,null,6170.08,null,null,null,null,null,"W-4 WH",315.72499999999997]
[null,"refund",36.89,null,"CashApp",122.81,null,"Zelle",200,null,"Zelle",40,null,null,null,null,null,"State W/H",170.99236111111111]
[null,"Zelle",340,null,"Zelle",100,null,"Zelle",300,null,"Remote Online Deposit",309.76,null,null,null,null,null,"Local W/H",""]
[null,"Zelle",20,null,"Zelle",1240,null,"CashApp",122.81,null,"CashApp",122.81,null,null,null,null,null,"Medical W/H",""]
[null,"ATM Cash",202,null,"CashApp",43.03,null,"CashApp",10.81,null,"Zelle",560,null,null,null,null,null,"Retirement",""]
[null,null,null,null,null,null,null,"Reversal",25,null,"CashApp",19.649999999999999,null,null,null,null,null,"Accident, Critical Ill, STD, Hospital",82.733333333333334]
[null,null,null,null,null,null,null,null,null,null,"Zelle",1034,null,null,null,null,null,"Net",{"$f":"S2-SUM(S3:S8)","v":3450.1422222222227}]
[null,null,null,null,null,null,null,null,null,null,"Zelle",100]
[]
[]
[null,"Zelle",{"$f":"SUMIF(B4:B10,$B$13,C4:C10)","v":360},null,null,{"$f":"SUMIF(E4:E10,$B$13,F4:F10)","v":1340},null,null,{"$f":"SUMIF(H4:H10,$B$13,I4:I10)","v":500},null,null,{"$f":"SUMIF(K4:K10,$B$13,L4:L10)","v":1734}]
[null,"CashApp",{"$f":"SUMIF(B4:B10,$B$14,C4:C10)","v":0},null,null,{"$f":"SUMIF(E4:E10,$B$14,F4:F10)","v":165.84},null,null,{"$f":"SUMIF(H4:H10,$B$14,I4:I10)","v":133.62},null,null,{"$f":"SUMIF(K4:K10,$B$14,L4:L10)","v":142.46}]
[]
[]
[]
[null,null,{"$f":"C3-SUM(C4:C17)","v":3035.31},null,null,{"$f":"F3-SUM(F4:F17)","v":2264.6399999999994},null,null,{"$f":"I3-SUM(I4:I17)","v":4347.76},null,null,{"$f":"L3-SUM(L4:L17)","v":2107.3999999999996},null,{"$f":"SUM(C18:L18)/4","v":2938.7774999999997}]
[]
[]
[]
[]
[]
[]
[null,"Zelle Average",{"$f":"AVERAGE(C13:L13)","v":983.5}]
[null,"Zelle Average",{"$f":"AVERAGE(C13:I13)","v":733.33333333333337}]