{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["SUMMARY","REV","EXP"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":348,"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":"SUMMARY","index":0,"n_rows":23,"n_cols":20,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL"]
[null,null,null,null,null,null,null,"Jul 22","Aug 22","Sep 22","Oct 22","Nov 22","Dec 22","Jan 23","Feb 23","Mar 23","Apr 23","May 23","Jun 23","Jul '22 - Jun 23"]
[]
[null,null,"Ordinary Income/Expense"]
[null,null,null,null,"Income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(H5:S5),5)","v":0}]
[null,null,null,null,null,"42250 · Sponsorships",null,{"$f":"REV!E8","v":0},{"$f":"REV!F8","v":0},{"$f":"REV!G8","v":0},{"$f":"REV!H8","v":50000},{"$f":"REV!I8","v":0},{"$f":"REV!J8","v":0},{"$f":"REV!K8","v":0},{"$f":"REV!L8","v":0},{"$f":"REV!M8","v":0},{"$f":"REV!N8","v":0},{"$f":"REV!O8","v":0},{"$f":"REV!P8","v":0},{"$f":"SUM(H6:S6)","v":50000}]
[null,null,null,null,null,"42380 · Commissions - Other",null,{"$f":"REV!E11","v":0},{"$f":"REV!F11","v":0},{"$f":"REV!G11","v":0},{"$f":"REV!H11","v":1500},{"$f":"REV!I11","v":0},{"$f":"REV!J11","v":0},{"$f":"REV!K11","v":0},{"$f":"REV!L11","v":0},{"$f":"REV!M11","v":0},{"$f":"REV!N11","v":0},{"$f":"REV!O11","v":0},{"$f":"REV!P11","v":0},1500]
[null,null,null,null,null,"42600 · Attendees",null,{"$f":"REV!E14","v":0},{"$f":"REV!F14","v":0},{"$f":"REV!G14","v":0},{"$f":"REV!H14","v":21890},{"$f":"REV!I14","v":0},{"$f":"REV!J14","v":0},{"$f":"REV!K14","v":0},{"$f":"REV!L14","v":0},{"$f":"REV!M14","v":0},{"$f":"REV!N14","v":0},{"$f":"REV!O14","v":0},{"$f":"REV!P14","v":0},21890]
[null,null,null,null,"Total Income",null,null,{"$f":"REV!E16","v":0},{"$f":"REV!F16","v":0},{"$f":"REV!G16","v":0},{"$f":"REV!H16","v":73390},{"$f":"REV!I16","v":0},{"$f":"REV!J16","v":0},{"$f":"REV!K16","v":0},{"$f":"REV!L16","v":0},{"$f":"REV!M16","v":0},{"$f":"REV!N16","v":0},{"$f":"REV!O16","v":0},{"$f":"REV!P16","v":0},73390]
[null,null,null,"Gross Profit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Expense",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,"54040 · Audio/Visual",null,{"$f":"EXP!H7","v":0},{"$f":"EXP!I7","v":0},{"$f":"EXP!J7","v":0},{"$f":"EXP!K7","v":1000},{"$f":"EXP!L7","v":0},{"$f":"EXP!M7","v":0},{"$f":"EXP!N7","v":0},{"$f":"EXP!O7","v":0},{"$f":"EXP!P7","v":0},{"$f":"EXP!Q7","v":0},{"$f":"EXP!R7","v":0},{"$f":"EXP!S7","v":0},1000]
[null,null,null,null,null,"54045 · Awards",null,{"$f":"EXP!H10","v":0},{"$f":"EXP!I10","v":0},{"$f":"EXP!J10","v":0},{"$f":"EXP!K10","v":0},{"$f":"EXP!L10","v":0},{"$f":"EXP!M10","v":0},{"$f":"EXP!N10","v":0},{"$f":"EXP!O10","v":0},{"$f":"EXP!P10","v":0},{"$f":"EXP!Q10","v":0},{"$f":"EXP!R10","v":0},{"$f":"EXP!S10","v":0},0]
[null,null,null,null,null,"54082 · Conventions / Seminars",null,{"$f":"EXP!H12","v":0},{"$f":"EXP!I12","v":0},{"$f":"EXP!J12","v":0},{"$f":"EXP!K12","v":0},{"$f":"EXP!L12","v":0},{"$f":"EXP!M12","v":0},{"$f":"EXP!N12","v":0},{"$f":"EXP!O12","v":0},{"$f":"EXP!P12","v":0},{"$f":"EXP!Q12","v":0},{"$f":"EXP!R12","v":0},{"$f":"EXP!S12","v":0},0]
[null,null,null,null,null,"54120 · Event Space",null,{"$f":"EXP!H16","v":0},{"$f":"EXP!I16","v":0},{"$f":"EXP!J16","v":0},{"$f":"EXP!K16","v":50000},{"$f":"EXP!L16","v":0},{"$f":"EXP!M16","v":0},{"$f":"EXP!N16","v":0},{"$f":"EXP!O16","v":0},{"$f":"EXP!P16","v":0},{"$f":"EXP!Q16","v":0},{"$f":"EXP!R16","v":0},{"$f":"EXP!S16","v":0},50000]
[null,null,null,null,null,"Total 54135 · Food Service",null,{"$f":"EXP!H21","v":0},{"$f":"EXP!I21","v":0},{"$f":"EXP!J21","v":0},{"$f":"EXP!K21","v":8500},{"$f":"EXP!L21","v":0},{"$f":"EXP!M21","v":0},{"$f":"EXP!N21","v":0},{"$f":"EXP!O21","v":0},{"$f":"EXP!P21","v":0},{"$f":"EXP!Q21","v":0},{"$f":"EXP!R21","v":0},{"$f":"EXP!S21","v":0},8500]
[null,null,null,null,null,"54142 · Gifts",null,{"$f":"EXP!H25","v":0},{"$f":"EXP!I25","v":0},{"$f":"EXP!J25","v":0},{"$f":"EXP!K25","v":0},{"$f":"EXP!L25","v":0},{"$f":"EXP!M25","v":0},{"$f":"EXP!N25","v":0},{"$f":"EXP!O25","v":0},{"$f":"EXP!P25","v":0},{"$f":"EXP!Q25","v":0},{"$f":"EXP!R25","v":0},{"$f":"EXP!S25","v":0},0]
[null,null,null,null,null,"54257 · Registration Services",null,{"$f":"EXP!H28","v":0},{"$f":"EXP!I28","v":0},{"$f":"EXP!J28","v":0},{"$f":"EXP!K28","v":5000},{"$f":"EXP!L28","v":0},{"$f":"EXP!M28","v":0},{"$f":"EXP!N28","v":0},{"$f":"EXP!O28","v":0},{"$f":"EXP!P28","v":0},{"$f":"EXP!Q28","v":0},{"$f":"EXP!R28","v":0},{"$f":"EXP!S28","v":0},5000]
[null,null,null,null,null,"Total 54265 · Speaker",null,{"$f":"EXP!H31","v":0},{"$f":"EXP!I31","v":0},{"$f":"EXP!J31","v":0},{"$f":"EXP!K31","v":0},{"$f":"EXP!L31","v":0},{"$f":"EXP!M31","v":0},{"$f":"EXP!N31","v":0},{"$f":"EXP!O31","v":0},{"$f":"EXP!P31","v":0},{"$f":"EXP!Q31","v":0},{"$f":"EXP!R31","v":0},{"$f":"EXP!S31","v":0},0]
[null,null,null,null,null,"54280 · Supplies",null,{"$f":"EXP!H35","v":0},{"$f":"EXP!I35","v":0},{"$f":"EXP!J35","v":0},{"$f":"EXP!K35","v":3500},{"$f":"EXP!L35","v":0},{"$f":"EXP!M35","v":0},{"$f":"EXP!N35","v":0},{"$f":"EXP!O35","v":0},{"$f":"EXP!P35","v":0},{"$f":"EXP!Q35","v":0},{"$f":"EXP!R35","v":0},{"$f":"EXP!S35","v":0},3500]
[null,null,null,null,null,"Total 54290 · Travel",null,{"$f":"EXP!H43","v":0},{"$f":"EXP!I43","v":0},{"$f":"EXP!J43","v":0},{"$f":"EXP!K43","v":2000},{"$f":"EXP!L43","v":0},{"$f":"EXP!M43","v":0},{"$f":"EXP!N43","v":0},{"$f":"EXP!O43","v":0},{"$f":"EXP!P43","v":0},{"$f":"EXP!Q43","v":0},{"$f":"EXP!R43","v":0},{"$f":"EXP!S43","v":0},2000]
[null,null,null,null,"Total Expense",null,null,{"$f":"EXP!H47","v":0},{"$f":"EXP!I47","v":0},{"$f":"EXP!J47","v":0},{"$f":"EXP!K47","v":70000},{"$f":"EXP!L47","v":0},{"$f":"EXP!M47","v":0},{"$f":"EXP!N47","v":0},{"$f":"EXP!O47","v":0},{"$f":"EXP!P47","v":0},{"$f":"EXP!Q47","v":0},{"$f":"EXP!R47","v":0},{"$f":"EXP!S47","v":0},70000]
[null,null,"Net Ordinary Income",null,null,null,null,{"$f":"H9-H22","v":0},{"$f":"I9-I22","v":0},{"$f":"J9-J22","v":0},{"$f":"K9-K22","v":3390},{"$f":"L9-L22","v":0},{"$f":"M9-M22","v":0},{"$f":"N9-N22","v":0},{"$f":"O9-O22","v":0},{"$f":"P9-P22","v":0},{"$f":"Q9-Q22","v":0},{"$f":"R9-R22","v":0},{"$f":"S9-S22","v":0},3390]

{"sheet":"REV","index":1,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Jul 22","Aug 22","Sep 22","Oct 22","Nov 22","Dec 22","Jan 23","Feb 23","Mar 23","Apr 23","May 23","Jun 23","Jul '22 - Jun 23"]
[]
[null,"Income"]
[null,null,"Income",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(E4:P4),5)","v":0}]
[null,null,null,"42250 · Sponsorships"]
[null,null,null,"Sponsorships",null,null,null,50000]
[]
[null,null,null,"Total",{"$f":"SUM(E6:E7)","v":0},{"$f":"SUM(F6:F7)","v":0},{"$f":"SUM(G6:G6)","v":0},{"$f":"SUM(H6:H7)","v":50000},{"$f":"SUM(I6:I7)","v":0},{"$f":"SUM(J6:J6)","v":0},{"$f":"SUM(K6:K6)","v":0},{"$f":"SUM(L6)","v":0},{"$f":"SUM(M6)","v":0},{"$f":"SUM(N6)","v":0},{"$f":"SUM(O6)","v":0},{"$f":"SUM(P6)","v":0},{"$f":"SUM(E8:P8)","v":50000},"Based on 144 golfers or 36 teams "]
[null,null,null,"42380 · Commissions - Other"]
[null,null,null,null,null,null,null,1500]
[null,null,null,"Total",{"$f":"SUM(E10)","v":0},{"$f":"SUM(F10:F10)","v":0},0,1500,0,0,0,0,{"$f":"SUM(M10)","v":0},{"$f":"SUM(N10)","v":0},{"$f":"SUM(O10)","v":0},{"$f":"SUM(P10)","v":0},{"$f":"SUM(E11:P11)","v":1500}]
[null,null,null,"42600 · Attendees"]
[null,null,null,"Education & Awards Reception based on 110pp @ $199 per person",null,null,null,21890,null,null,0]
[null,null,null,"Total",{"$f":"SUM(E13)","v":0},{"$f":"SUM(F13:F13)","v":0},0,21890,0,0,0,0,{"$f":"SUM(M13)","v":0},{"$f":"SUM(N13)","v":0},{"$f":"SUM(O13)","v":0},{"$f":"SUM(P13)","v":0},{"$f":"SUM(E14:P14)","v":21890},"Based on 110 Attendees"]
[]
[null,null,null,"TOTAL INCOME",{"$f":"E8++E11+E14","v":0},{"$f":"F8++F11+F14","v":0},0,73390,0,0,0,0,0,0,0,0,73390]

{"sheet":"EXP","index":2,"n_rows":47,"n_cols":20,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL"]
[null,null,null,null,null,null,null,"Jul 22","Aug 22","Sep 22","Oct 22","Nov 22","Dec 22","Jan 23","Feb 23","Mar 23","Apr 23","May 23","Jun 23","Jul '22 - Jun 23"]
[null,null,null,"Expense"]
[null,null,null,null,"Expense"]
[null,null,null,null,null,"54040 · Audio/Visual"]
[null,null,null,null,null,null,"Audio Visual at Saint Arnold Brewery",null,null,null,1000]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H6:H6)","v":0},{"$f":"SUM(I6:I6)","v":0},{"$f":"SUM(J6)","v":0},{"$f":"SUM(K6)","v":1000},{"$f":"SUM(L6)","v":0},{"$f":"SUM(M6)","v":0},{"$f":"SUM(N6)","v":0},{"$f":"SUM(O6:O6)","v":0},{"$f":"SUM(P6)","v":0},{"$f":"SUM(Q6)","v":0},{"$f":"SUM(R6)","v":0},{"$f":"SUM(S6)","v":0},{"$f":"SUM(H7:S7)","v":1000}]
[null,null,null,null,null,"54045 · Awards"]
[]
[null,null,null,null,null,null,"Total",{"$f":"H9","v":0},{"$f":"I9","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(H10:S10)","v":0}]
[]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H11)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(H12:S12)","v":0}]
[null,null,null,null,null,"54120 · Event Space"]
[null,null,null,null,null,null,"Golf Club of Houston",null,null,null,48000]
[null,null,null,null,null,null,"Saint Arnold Brewery",null,null,null,2000]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H14)","v":0},{"$f":"SUM(I14)","v":0},0,{"$f":"SUM(K14:K15)","v":50000},0,0,0,0,0,0,0,0,{"$f":"SUM(H16:S16)","v":50000}]
[null,null,null,null,null,"54135 · Food Service"]
[null,null,null,null,null,null,"54170 · Lunches/Buffets"]
[null,null,null,null,null,null,"Education/Lunches/Buffets",null,null,null,8500]
[]
[null,null,null,null,null,"Total 54135 · Food Service",null,{"$f":"SUM(H18:H20)","v":0},0,0,8500,0,0,0,0,0,0,0,0,{"$f":"SUM(H21:S21)","v":8500}]
[]
[null,null,null,null,null,"54142 · Gifts"]
[]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H24)","v":0},{"$f":"SUM(I24)","v":0},0,0,{"$f":"SUM(L24:L24)","v":0},{"$f":"SUM(M24:M24)","v":0},{"$f":"SUM(N24:N24)","v":0},{"$f":"SUM(O24:O24)","v":0},0,0,0,0,{"$f":"SUM(H25:S25)","v":0}]
[null,null,null,null,null,"54257 · Registration Services"]
[null,null,null,null,null,null,"Registration Services (MCI)",null,null,null,5000,null,null,null,0]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H27:H27)","v":0},{"$f":"SUM(I27)","v":0},0,5000,0,0,0,0,0,0,0,0,{"$f":"SUM(H28:S28)","v":5000}]
[null,null,null,null,null,null,"54266 · Speaker Fees"]
[null,null,null,null,null,null,"Speaker for Education",null,null,null,0]
[null,null,null,null,null,"Total 54265 · Speaker",null,{"$f":"SUM(H29:H30)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(H31:S31)","v":0}]
[]
[null,null,null,null,null,"54280 · Supplies"]
[null,null,null,null,null,null,"NAPE Classic",null,null,null,3500]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H34)","v":0},{"$f":"SUM(I34)","v":0},{"$f":"SUM(J34)","v":0},{"$f":"SUM(K34:K34)","v":3500},{"$f":"SUM(L34:L34)","v":0},{"$f":"SUM(M34:M34)","v":0},{"$f":"SUM(N34:N34)","v":0},{"$f":"SUM(O34:O34)","v":0},{"$f":"SUM(P34)","v":0},{"$f":"SUM(Q34)","v":0},{"$f":"SUM(R34)","v":0},{"$f":"SUM(S34)","v":0},{"$f":"SUM(H35:S35)","v":3500}]
[null,null,null,null,null,"54290 · Travel"]
[]
[null,null,null,null,null,null,"54291 · Travel - Staff"]
[]
[null,null,null,null,null,null,"54292 · Travel - NAPE Event"]
[null,null,null,null,null,null,null,null,null,null,2000]
[]
[null,null,null,null,null,"Total 54290 · Travel",null,{"$f":"SUM(H37:H42)","v":0},{"$f":"SUM(I37:I42)","v":0},{"$f":"SUM(J37:J42)","v":0},{"$f":"SUM(K39:K42)","v":2000},{"$f":"SUM(L39:L42)","v":0},{"$f":"SUM(M39:M42)","v":0},{"$f":"SUM(N39:N42)","v":0},{"$f":"SUM(O39:O42)","v":0},{"$f":"SUM(P37:P42)","v":0},{"$f":"SUM(Q37:Q42)","v":0},{"$f":"SUM(R37:R42)","v":0},{"$f":"SUM(S37:S42)","v":0},{"$f":"SUM(H43:S43)","v":2000}]
[]
[]
[]
[null,null,null,null,"Total Expense",null,null,{"$f":"+H7+H10+H12+H16+H21+H25+H28+H31+H35+H43","v":0},{"$f":"+I7+I10+I12+I16+I21+I25+I28+I31+I35+I43","v":0},0,70000,0,0,0,{"$f":"O7+O10+O12+O16+O21+O25+O28+O31+O35+O43","v":0},0,0,0,0,70000]