{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["P&L to Bud","YTD Rev by Type","July Rev by Type","Balance Sheet"],"not_rendered":{"charts":0,"images":8,"macros":0,"external_links":0,"defined_names":411,"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":"P&L to Bud","index":0,"n_rows":45,"n_cols":68,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[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,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,"TOTAL"]
[null,null,null,null,null,"Jan 23",null,"Budget",null,"$ Over Budget",null,"% of Budget",null,"Feb 23",null,"Budget",null,"$ Over Budget",null,"% of Budget",null,"Mar 23",null,"Budget",null,"$ Over Budget",null,"% of Budget",null,"Apr 23",null,"Budget",null,"$ Over Budget",null,"% of Budget",null,"May 23",null,"Budget",null,"$ Over Budget",null,"% of Budget",null,"Jun 23",null,"Budget",null,"$ Over Budget",null,"% of Budget",null,"Jul 23",null,"Budget",null,"$ Over Budget",null,"% of Budget",null,"Jan - Jul 23",null,"Budget",null,"$ Over Budget",null,"% of Budget"]
[null,"Ordinary Income/Expense"]
[null,null,null,"Income"]
[null,null,null,null,"40000 · Member Dues and Fees",66850,null,66250,null,{"$f":"ROUND((F5-H5),5)","v":600},null,{"$f":"ROUND(IF(H5=0, IF(F5=0, 0, 1), F5/H5),5)","v":1.0090600000000001},null,65350,null,66250,null,{"$f":"ROUND((N5-P5),5)","v":-900},null,{"$f":"ROUND(IF(P5=0, IF(N5=0, 0, 1), N5/P5),5)","v":0.98641999999999996},null,71300,null,66250,null,{"$f":"ROUND((V5-X5),5)","v":5050},null,{"$f":"ROUND(IF(X5=0, IF(V5=0, 0, 1), V5/X5),5)","v":1.07623},null,64050,null,66250,null,{"$f":"ROUND((AD5-AF5),5)","v":-2200},null,{"$f":"ROUND(IF(AF5=0, IF(AD5=0, 0, 1), AD5/AF5),5)","v":0.96679000000000004},null,71800,null,66250,null,{"$f":"ROUND((AL5-AN5),5)","v":5550},null,{"$f":"ROUND(IF(AN5=0, IF(AL5=0, 0, 1), AL5/AN5),5)","v":1.0837699999999999},null,70300,null,66250,null,{"$f":"ROUND((AT5-AV5),5)","v":4050},null,{"$f":"ROUND(IF(AV5=0, IF(AT5=0, 0, 1), AT5/AV5),5)","v":1.0611299999999999},null,63550,null,66250,null,{"$f":"ROUND((BB5-BD5),5)","v":-2700},null,{"$f":"ROUND(IF(BD5=0, IF(BB5=0, 0, 1), BB5/BD5),5)","v":0.95925000000000005},null,{"$f":"ROUND(F5+N5+V5+AD5+AL5+AT5+BB5,5)","v":473200},null,{"$f":"ROUND(H5+P5+X5+AF5+AN5+AV5+BD5,5)","v":463750},null,{"$f":"ROUND((BJ5-BL5),5)","v":9450},null,{"$f":"ROUND(IF(BL5=0, IF(BJ5=0, 0, 1), BJ5/BL5),5)","v":1.0203800000000001}]
[null,null,null,null,"40100 · Meal Sales",41371,null,19000,null,{"$f":"ROUND((F6-H6),5)","v":22371},null,{"$f":"ROUND(IF(H6=0, IF(F6=0, 0, 1), F6/H6),5)","v":2.1774200000000001},null,45613,null,33000,null,{"$f":"ROUND((N6-P6),5)","v":12613},null,{"$f":"ROUND(IF(P6=0, IF(N6=0, 0, 1), N6/P6),5)","v":1.3822099999999999},null,55366,null,63801,null,{"$f":"ROUND((V6-X6),5)","v":-8435},null,{"$f":"ROUND(IF(X6=0, IF(V6=0, 0, 1), V6/X6),5)","v":0.86778999999999995},null,86873,null,83300,null,{"$f":"ROUND((AD6-AF6),5)","v":3573},null,{"$f":"ROUND(IF(AF6=0, IF(AD6=0, 0, 1), AD6/AF6),5)","v":1.0428900000000001},null,83229,null,80714,null,{"$f":"ROUND((AL6-AN6),5)","v":2515},null,{"$f":"ROUND(IF(AN6=0, IF(AL6=0, 0, 1), AL6/AN6),5)","v":1.0311600000000001},null,102719,null,92182,null,{"$f":"ROUND((AT6-AV6),5)","v":10537},null,{"$f":"ROUND(IF(AV6=0, IF(AT6=0, 0, 1), AT6/AV6),5)","v":1.1143099999999999},null,70696,null,88295,null,{"$f":"ROUND((BB6-BD6),5)","v":-17599},null,{"$f":"ROUND(IF(BD6=0, IF(BB6=0, 0, 1), BB6/BD6),5)","v":0.80067999999999995},null,{"$f":"ROUND(F6+N6+V6+AD6+AL6+AT6+BB6,5)","v":485867},null,{"$f":"ROUND(H6+P6+X6+AF6+AN6+AV6+BD6,5)","v":460292},null,{"$f":"ROUND((BJ6-BL6),5)","v":25575},null,{"$f":"ROUND(IF(BL6=0, IF(BJ6=0, 0, 1), BJ6/BL6),5)","v":1.0555600000000001}]
[null,null,null,null,"40200 · Beverage Sales",8739,null,5063,null,{"$f":"ROUND((F7-H7),5)","v":3676},null,{"$f":"ROUND(IF(H7=0, IF(F7=0, 0, 1), F7/H7),5)","v":1.7260500000000001},null,6249,null,6289,null,{"$f":"ROUND((N7-P7),5)","v":-40},null,{"$f":"ROUND(IF(P7=0, IF(N7=0, 0, 1), N7/P7),5)","v":0.99363999999999997},null,9893,null,9000,null,{"$f":"ROUND((V7-X7),5)","v":893},null,{"$f":"ROUND(IF(X7=0, IF(V7=0, 0, 1), V7/X7),5)","v":1.0992200000000001},null,23777,null,13000,null,{"$f":"ROUND((AD7-AF7),5)","v":10777},null,{"$f":"ROUND(IF(AF7=0, IF(AD7=0, 0, 1), AD7/AF7),5)","v":1.829},null,7710,null,13000,null,{"$f":"ROUND((AL7-AN7),5)","v":-5290},null,{"$f":"ROUND(IF(AN7=0, IF(AL7=0, 0, 1), AL7/AN7),5)","v":0.59308000000000005},null,11378,null,16000,null,{"$f":"ROUND((AT7-AV7),5)","v":-4622},null,{"$f":"ROUND(IF(AV7=0, IF(AT7=0, 0, 1), AT7/AV7),5)","v":0.71113000000000004},null,7883,null,15000,null,{"$f":"ROUND((BB7-BD7),5)","v":-7117},null,{"$f":"ROUND(IF(BD7=0, IF(BB7=0, 0, 1), BB7/BD7),5)","v":0.52553000000000005},null,{"$f":"ROUND(F7+N7+V7+AD7+AL7+AT7+BB7,5)","v":75629},null,{"$f":"ROUND(H7+P7+X7+AF7+AN7+AV7+BD7,5)","v":77352},null,{"$f":"ROUND((BJ7-BL7),5)","v":-1723},null,{"$f":"ROUND(IF(BL7=0, IF(BJ7=0, 0, 1), BJ7/BL7),5)","v":0.97772999999999999}]
[null,null,null,null,"40300 · Service Fees",4330,null,578,null,{"$f":"ROUND((F8-H8),5)","v":3752},null,{"$f":"ROUND(IF(H8=0, IF(F8=0, 0, 1), F8/H8),5)","v":7.4913499999999997},null,3047,null,539,null,{"$f":"ROUND((N8-P8),5)","v":2508},null,{"$f":"ROUND(IF(P8=0, IF(N8=0, 0, 1), N8/P8),5)","v":5.65306},null,3287,null,6894,null,{"$f":"ROUND((V8-X8),5)","v":-3607},null,{"$f":"ROUND(IF(X8=0, IF(V8=0, 0, 1), V8/X8),5)","v":0.47678999999999999},null,12027,null,9006,null,{"$f":"ROUND((AD8-AF8),5)","v":3021},null,{"$f":"ROUND(IF(AF8=0, IF(AD8=0, 0, 1), AD8/AF8),5)","v":1.33544},null,4766,null,9025,null,{"$f":"ROUND((AL8-AN8),5)","v":-4259},null,{"$f":"ROUND(IF(AN8=0, IF(AL8=0, 0, 1), AL8/AN8),5)","v":0.52808999999999995},null,9385,null,9388,null,{"$f":"ROUND((AT8-AV8),5)","v":-3},null,{"$f":"ROUND(IF(AV8=0, IF(AT8=0, 0, 1), AT8/AV8),5)","v":0.99968000000000001},null,5977,null,9058,null,{"$f":"ROUND((BB8-BD8),5)","v":-3081},null,{"$f":"ROUND(IF(BD8=0, IF(BB8=0, 0, 1), BB8/BD8),5)","v":0.65986},null,{"$f":"ROUND(F8+N8+V8+AD8+AL8+AT8+BB8,5)","v":42819},null,{"$f":"ROUND(H8+P8+X8+AF8+AN8+AV8+BD8,5)","v":44488},null,{"$f":"ROUND((BJ8-BL8),5)","v":-1669},null,{"$f":"ROUND(IF(BL8=0, IF(BJ8=0, 0, 1), BJ8/BL8),5)","v":0.96248}]
[null,null,null,null,"40400 · Rental Income",0,null,0,null,{"$f":"ROUND((F9-H9),5)","v":0},null,{"$f":"ROUND(IF(H9=0, IF(F9=0, 0, 1), F9/H9),5)","v":0},null,0,null,152,null,{"$f":"ROUND((N9-P9),5)","v":-152},null,{"$f":"ROUND(IF(P9=0, IF(N9=0, 0, 1), N9/P9),5)","v":0},null,0,null,2600,null,{"$f":"ROUND((V9-X9),5)","v":-2600},null,{"$f":"ROUND(IF(X9=0, IF(V9=0, 0, 1), V9/X9),5)","v":0},null,3132,null,2600,null,{"$f":"ROUND((AD9-AF9),5)","v":532},null,{"$f":"ROUND(IF(AF9=0, IF(AD9=0, 0, 1), AD9/AF9),5)","v":1.20462},null,140,null,2600,null,{"$f":"ROUND((AL9-AN9),5)","v":-2460},null,{"$f":"ROUND(IF(AN9=0, IF(AL9=0, 0, 1), AL9/AN9),5)","v":5.3850000000000002E-2},null,15449,null,2600,null,{"$f":"ROUND((AT9-AV9),5)","v":12849},null,{"$f":"ROUND(IF(AV9=0, IF(AT9=0, 0, 1), AT9/AV9),5)","v":5.9419199999999996},null,1000,null,2600,null,{"$f":"ROUND((BB9-BD9),5)","v":-1600},null,{"$f":"ROUND(IF(BD9=0, IF(BB9=0, 0, 1), BB9/BD9),5)","v":0.38462000000000002},null,{"$f":"ROUND(F9+N9+V9+AD9+AL9+AT9+BB9,5)","v":19721},null,{"$f":"ROUND(H9+P9+X9+AF9+AN9+AV9+BD9,5)","v":13152},null,{"$f":"ROUND((BJ9-BL9),5)","v":6569},null,{"$f":"ROUND(IF(BL9=0, IF(BJ9=0, 0, 1), BJ9/BL9),5)","v":1.4994700000000001}]
[null,null,null,null,"40800 · Other Income",675,null,168,null,{"$f":"ROUND((F10-H10),5)","v":507},null,{"$f":"ROUND(IF(H10=0, IF(F10=0, 0, 1), F10/H10),5)","v":4.0178599999999998},null,300,null,919,null,{"$f":"ROUND((N10-P10),5)","v":-619},null,{"$f":"ROUND(IF(P10=0, IF(N10=0, 0, 1), N10/P10),5)","v":0.32644000000000001},null,71,null,553,null,{"$f":"ROUND((V10-X10),5)","v":-482},null,{"$f":"ROUND(IF(X10=0, IF(V10=0, 0, 1), V10/X10),5)","v":0.12839},null,430,null,670,null,{"$f":"ROUND((AD10-AF10),5)","v":-240},null,{"$f":"ROUND(IF(AF10=0, IF(AD10=0, 0, 1), AD10/AF10),5)","v":0.64178999999999997},null,230,null,757,null,{"$f":"ROUND((AL10-AN10),5)","v":-527},null,{"$f":"ROUND(IF(AN10=0, IF(AL10=0, 0, 1), AL10/AN10),5)","v":0.30382999999999999},null,165,null,1402,null,{"$f":"ROUND((AT10-AV10),5)","v":-1237},null,{"$f":"ROUND(IF(AV10=0, IF(AT10=0, 0, 1), AT10/AV10),5)","v":0.11769},null,350,null,1335,null,{"$f":"ROUND((BB10-BD10),5)","v":-985},null,{"$f":"ROUND(IF(BD10=0, IF(BB10=0, 0, 1), BB10/BD10),5)","v":0.26217000000000001},null,{"$f":"ROUND(F10+N10+V10+AD10+AL10+AT10+BB10,5)","v":2221},null,{"$f":"ROUND(H10+P10+X10+AF10+AN10+AV10+BD10,5)","v":5804},null,{"$f":"ROUND((BJ10-BL10),5)","v":-3583},null,{"$f":"ROUND(IF(BL10=0, IF(BJ10=0, 0, 1), BJ10/BL10),5)","v":0.38267000000000001}]
[null,null,null,"Total Income",null,{"$f":"ROUND(SUM(F4:F10),5)","v":121965},null,{"$f":"ROUND(SUM(H4:H10),5)","v":91059},null,{"$f":"ROUND((F11-H11),5)","v":30906},null,{"$f":"ROUND(IF(H11=0, IF(F11=0, 0, 1), F11/H11),5)","v":1.33941},null,{"$f":"ROUND(SUM(N4:N10),5)","v":120559},null,{"$f":"ROUND(SUM(P4:P10),5)","v":107149},null,{"$f":"ROUND((N11-P11),5)","v":13410},null,{"$f":"ROUND(IF(P11=0, IF(N11=0, 0, 1), N11/P11),5)","v":1.1251500000000001},null,{"$f":"ROUND(SUM(V4:V10),5)","v":139917},null,{"$f":"ROUND(SUM(X4:X10),5)","v":149098},null,{"$f":"ROUND((V11-X11),5)","v":-9181},null,{"$f":"ROUND(IF(X11=0, IF(V11=0, 0, 1), V11/X11),5)","v":0.93842000000000003},null,{"$f":"ROUND(SUM(AD4:AD10),5)","v":190289},null,{"$f":"ROUND(SUM(AF4:AF10),5)","v":174826},null,{"$f":"ROUND((AD11-AF11),5)","v":15463},null,{"$f":"ROUND(IF(AF11=0, IF(AD11=0, 0, 1), AD11/AF11),5)","v":1.0884499999999999},null,{"$f":"ROUND(SUM(AL4:AL10),5)","v":167875},null,{"$f":"ROUND(SUM(AN4:AN10),5)","v":172346},null,{"$f":"ROUND((AL11-AN11),5)","v":-4471},null,{"$f":"ROUND(IF(AN11=0, IF(AL11=0, 0, 1), AL11/AN11),5)","v":0.97406000000000004},null,{"$f":"ROUND(SUM(AT4:AT10),5)","v":209396},null,{"$f":"ROUND(SUM(AV4:AV10),5)","v":187822},null,{"$f":"ROUND((AT11-AV11),5)","v":21574},null,{"$f":"ROUND(IF(AV11=0, IF(AT11=0, 0, 1), AT11/AV11),5)","v":1.11486},null,{"$f":"ROUND(SUM(BB4:BB10),5)","v":149456},null,{"$f":"ROUND(SUM(BD4:BD10),5)","v":182538},null,{"$f":"ROUND((BB11-BD11),5)","v":-33082},null,{"$f":"ROUND(IF(BD11=0, IF(BB11=0, 0, 1), BB11/BD11),5)","v":0.81877},null,{"$f":"ROUND(F11+N11+V11+AD11+AL11+AT11+BB11,5)","v":1099457},null,{"$f":"ROUND(H11+P11+X11+AF11+AN11+AV11+BD11,5)","v":1064838},null,{"$f":"ROUND((BJ11-BL11),5)","v":34619},null,{"$f":"ROUND(IF(BL11=0, IF(BJ11=0, 0, 1), BJ11/BL11),5)","v":1.03251}]
[null,null,"Gross Profit",null,null,{"$f":"F11","v":121965},null,{"$f":"H11","v":91059},null,{"$f":"ROUND((F12-H12),5)","v":30906},null,{"$f":"ROUND(IF(H12=0, IF(F12=0, 0, 1), F12/H12),5)","v":1.33941},null,{"$f":"N11","v":120559},null,{"$f":"P11","v":107149},null,{"$f":"ROUND((N12-P12),5)","v":13410},null,{"$f":"ROUND(IF(P12=0, IF(N12=0, 0, 1), N12/P12),5)","v":1.1251500000000001},null,{"$f":"V11","v":139917},null,{"$f":"X11","v":149098},null,{"$f":"ROUND((V12-X12),5)","v":-9181},null,{"$f":"ROUND(IF(X12=0, IF(V12=0, 0, 1), V12/X12),5)","v":0.93842000000000003},null,{"$f":"AD11","v":190289},null,{"$f":"AF11","v":174826},null,{"$f":"ROUND((AD12-AF12),5)","v":15463},null,{"$f":"ROUND(IF(AF12=0, IF(AD12=0, 0, 1), AD12/AF12),5)","v":1.0884499999999999},null,{"$f":"AL11","v":167875},null,{"$f":"AN11","v":172346},null,{"$f":"ROUND((AL12-AN12),5)","v":-4471},null,{"$f":"ROUND(IF(AN12=0, IF(AL12=0, 0, 1), AL12/AN12),5)","v":0.97406000000000004},null,{"$f":"AT11","v":209396},null,{"$f":"AV11","v":187822},null,{"$f":"ROUND((AT12-AV12),5)","v":21574},null,{"$f":"ROUND(IF(AV12=0, IF(AT12=0, 0, 1), AT12/AV12),5)","v":1.11486},null,{"$f":"BB11","v":149456},null,{"$f":"BD11","v":182538},null,{"$f":"ROUND((BB12-BD12),5)","v":-33082},null,{"$f":"ROUND(IF(BD12=0, IF(BB12=0, 0, 1), BB12/BD12),5)","v":0.81877},null,{"$f":"ROUND(F12+N12+V12+AD12+AL12+AT12+BB12,5)","v":1099457},null,{"$f":"ROUND(H12+P12+X12+AF12+AN12+AV12+BD12,5)","v":1064838},null,{"$f":"ROUND((BJ12-BL12),5)","v":34619},null,{"$f":"ROUND(IF(BL12=0, IF(BJ12=0, 0, 1), BJ12/BL12),5)","v":1.03251}]
[null,null,null,"Expense"]
[null,null,null,null,"55100 · Food Purchased",16506,null,17020,null,{"$f":"ROUND((F14-H14),5)","v":-514},null,{"$f":"ROUND(IF(H14=0, IF(F14=0, 0, 1), F14/H14),5)","v":0.9698},null,18293,null,20000,null,{"$f":"ROUND((N14-P14),5)","v":-1707},null,{"$f":"ROUND(IF(P14=0, IF(N14=0, 0, 1), N14/P14),5)","v":0.91464999999999996},null,21249,null,22000,null,{"$f":"ROUND((V14-X14),5)","v":-751},null,{"$f":"ROUND(IF(X14=0, IF(V14=0, 0, 1), V14/X14),5)","v":0.96586000000000005},null,27673,null,27000,null,{"$f":"ROUND((AD14-AF14),5)","v":673},null,{"$f":"ROUND(IF(AF14=0, IF(AD14=0, 0, 1), AD14/AF14),5)","v":1.0249299999999999},null,27231,null,27000,null,{"$f":"ROUND((AL14-AN14),5)","v":231},null,{"$f":"ROUND(IF(AN14=0, IF(AL14=0, 0, 1), AL14/AN14),5)","v":1.0085599999999999},null,26056,null,28000,null,{"$f":"ROUND((AT14-AV14),5)","v":-1944},null,{"$f":"ROUND(IF(AV14=0, IF(AT14=0, 0, 1), AT14/AV14),5)","v":0.93057000000000001},null,22729,null,32000,null,{"$f":"ROUND((BB14-BD14),5)","v":-9271},null,{"$f":"ROUND(IF(BD14=0, IF(BB14=0, 0, 1), BB14/BD14),5)","v":0.71028000000000002},null,{"$f":"ROUND(F14+N14+V14+AD14+AL14+AT14+BB14,5)","v":159737},null,{"$f":"ROUND(H14+P14+X14+AF14+AN14+AV14+BD14,5)","v":173020},null,{"$f":"ROUND((BJ14-BL14),5)","v":-13283},null,{"$f":"ROUND(IF(BL14=0, IF(BJ14=0, 0, 1), BJ14/BL14),5)","v":0.92323}]
[null,null,null,null,"55200 · Beverages",12326,null,4051,null,{"$f":"ROUND((F15-H15),5)","v":8275},null,{"$f":"ROUND(IF(H15=0, IF(F15=0, 0, 1), F15/H15),5)","v":3.04271},null,5382,null,7805,null,{"$f":"ROUND((N15-P15),5)","v":-2423},null,{"$f":"ROUND(IF(P15=0, IF(N15=0, 0, 1), N15/P15),5)","v":0.68955999999999995},null,10200,null,12716,null,{"$f":"ROUND((V15-X15),5)","v":-2516},null,{"$f":"ROUND(IF(X15=0, IF(V15=0, 0, 1), V15/X15),5)","v":0.80213999999999996},null,22493,null,16643,null,{"$f":"ROUND((AD15-AF15),5)","v":5850},null,{"$f":"ROUND(IF(AF15=0, IF(AD15=0, 0, 1), AD15/AF15),5)","v":1.3514999999999999},null,17719,null,11828,null,{"$f":"ROUND((AL15-AN15),5)","v":5891},null,{"$f":"ROUND(IF(AN15=0, IF(AL15=0, 0, 1), AL15/AN15),5)","v":1.4980599999999999},null,15121,null,15100,null,{"$f":"ROUND((AT15-AV15),5)","v":21},null,{"$f":"ROUND(IF(AV15=0, IF(AT15=0, 0, 1), AT15/AV15),5)","v":1.00139},null,8477,null,17267,null,{"$f":"ROUND((BB15-BD15),5)","v":-8790},null,{"$f":"ROUND(IF(BD15=0, IF(BB15=0, 0, 1), BB15/BD15),5)","v":0.49093999999999999},null,{"$f":"ROUND(F15+N15+V15+AD15+AL15+AT15+BB15,5)","v":91718},null,{"$f":"ROUND(H15+P15+X15+AF15+AN15+AV15+BD15,5)","v":85410},null,{"$f":"ROUND((BJ15-BL15),5)","v":6308},null,{"$f":"ROUND(IF(BL15=0, IF(BJ15=0, 0, 1), BJ15/BL15),5)","v":1.07386}]
[null,null,null,null,"55300 · Kitchen Employee Expense",31159,null,30332,null,{"$f":"ROUND((F16-H16),5)","v":827},null,{"$f":"ROUND(IF(H16=0, IF(F16=0, 0, 1), F16/H16),5)","v":1.0272600000000001},null,31421,null,30332,null,{"$f":"ROUND((N16-P16),5)","v":1089},null,{"$f":"ROUND(IF(P16=0, IF(N16=0, 0, 1), N16/P16),5)","v":1.0359},null,29671,null,30332,null,{"$f":"ROUND((V16-X16),5)","v":-661},null,{"$f":"ROUND(IF(X16=0, IF(V16=0, 0, 1), V16/X16),5)","v":0.97821000000000002},null,31990,null,30332,null,{"$f":"ROUND((AD16-AF16),5)","v":1658},null,{"$f":"ROUND(IF(AF16=0, IF(AD16=0, 0, 1), AD16/AF16),5)","v":1.0546599999999999},null,37353,null,30332,null,{"$f":"ROUND((AL16-AN16),5)","v":7021},null,{"$f":"ROUND(IF(AN16=0, IF(AL16=0, 0, 1), AL16/AN16),5)","v":1.2314700000000001},null,31704,null,30332,null,{"$f":"ROUND((AT16-AV16),5)","v":1372},null,{"$f":"ROUND(IF(AV16=0, IF(AT16=0, 0, 1), AT16/AV16),5)","v":1.0452300000000001},null,35185,null,30332,null,{"$f":"ROUND((BB16-BD16),5)","v":4853},null,{"$f":"ROUND(IF(BD16=0, IF(BB16=0, 0, 1), BB16/BD16),5)","v":1.1599999999999999},null,{"$f":"ROUND(F16+N16+V16+AD16+AL16+AT16+BB16,5)","v":228483},null,{"$f":"ROUND(H16+P16+X16+AF16+AN16+AV16+BD16,5)","v":212324},null,{"$f":"ROUND((BJ16-BL16),5)","v":16159},null,{"$f":"ROUND(IF(BL16=0, IF(BJ16=0, 0, 1), BJ16/BL16),5)","v":1.0761099999999999}]
[null,null,null,null,"55400 · Front of House Employee Expense",24021,null,30425,null,{"$f":"ROUND((F17-H17),5)","v":-6404},null,{"$f":"ROUND(IF(H17=0, IF(F17=0, 0, 1), F17/H17),5)","v":0.78952},null,23094,null,30425,null,{"$f":"ROUND((N17-P17),5)","v":-7331},null,{"$f":"ROUND(IF(P17=0, IF(N17=0, 0, 1), N17/P17),5)","v":0.75905},null,24415,null,30425,null,{"$f":"ROUND((V17-X17),5)","v":-6010},null,{"$f":"ROUND(IF(X17=0, IF(V17=0, 0, 1), V17/X17),5)","v":0.80247000000000002},null,30535,null,30425,null,{"$f":"ROUND((AD17-AF17),5)","v":110},null,{"$f":"ROUND(IF(AF17=0, IF(AD17=0, 0, 1), AD17/AF17),5)","v":1.00362},null,41005,null,30425,null,{"$f":"ROUND((AL17-AN17),5)","v":10580},null,{"$f":"ROUND(IF(AN17=0, IF(AL17=0, 0, 1), AL17/AN17),5)","v":1.3477399999999999},null,30573,null,30425,null,{"$f":"ROUND((AT17-AV17),5)","v":148},null,{"$f":"ROUND(IF(AV17=0, IF(AT17=0, 0, 1), AT17/AV17),5)","v":1.0048600000000001},null,28697,null,30425,null,{"$f":"ROUND((BB17-BD17),5)","v":-1728},null,{"$f":"ROUND(IF(BD17=0, IF(BB17=0, 0, 1), BB17/BD17),5)","v":0.94320000000000004},null,{"$f":"ROUND(F17+N17+V17+AD17+AL17+AT17+BB17,5)","v":202340},null,{"$f":"ROUND(H17+P17+X17+AF17+AN17+AV17+BD17,5)","v":212975},null,{"$f":"ROUND((BJ17-BL17),5)","v":-10635},null,{"$f":"ROUND(IF(BL17=0, IF(BJ17=0, 0, 1), BJ17/BL17),5)","v":0.95006000000000002}]
[null,null,null,null,"55500 · Kitchen Supplies",1058,null,1098,null,{"$f":"ROUND((F18-H18),5)","v":-40},null,{"$f":"ROUND(IF(H18=0, IF(F18=0, 0, 1), F18/H18),5)","v":0.96357000000000004},null,464,null,1098,null,{"$f":"ROUND((N18-P18),5)","v":-634},null,{"$f":"ROUND(IF(P18=0, IF(N18=0, 0, 1), N18/P18),5)","v":0.42259000000000002},null,1431,null,1098,null,{"$f":"ROUND((V18-X18),5)","v":333},null,{"$f":"ROUND(IF(X18=0, IF(V18=0, 0, 1), V18/X18),5)","v":1.30328},null,708,null,1098,null,{"$f":"ROUND((AD18-AF18),5)","v":-390},null,{"$f":"ROUND(IF(AF18=0, IF(AD18=0, 0, 1), AD18/AF18),5)","v":0.64480999999999999},null,1035,null,1098,null,{"$f":"ROUND((AL18-AN18),5)","v":-63},null,{"$f":"ROUND(IF(AN18=0, IF(AL18=0, 0, 1), AL18/AN18),5)","v":0.94262000000000001},null,1130,null,1098,null,{"$f":"ROUND((AT18-AV18),5)","v":32},null,{"$f":"ROUND(IF(AV18=0, IF(AT18=0, 0, 1), AT18/AV18),5)","v":1.0291399999999999},null,445,null,1098,null,{"$f":"ROUND((BB18-BD18),5)","v":-653},null,{"$f":"ROUND(IF(BD18=0, IF(BB18=0, 0, 1), BB18/BD18),5)","v":0.40527999999999997},null,{"$f":"ROUND(F18+N18+V18+AD18+AL18+AT18+BB18,5)","v":6271},null,{"$f":"ROUND(H18+P18+X18+AF18+AN18+AV18+BD18,5)","v":7686},null,{"$f":"ROUND((BJ18-BL18),5)","v":-1415},null,{"$f":"ROUND(IF(BL18=0, IF(BJ18=0, 0, 1), BJ18/BL18),5)","v":0.81589999999999996}]
[null,null,null,null,"55800 · Entertainment",654,null,5426,null,{"$f":"ROUND((F19-H19),5)","v":-4772},null,{"$f":"ROUND(IF(H19=0, IF(F19=0, 0, 1), F19/H19),5)","v":0.12053},null,4854,null,5426,null,{"$f":"ROUND((N19-P19),5)","v":-572},null,{"$f":"ROUND(IF(P19=0, IF(N19=0, 0, 1), N19/P19),5)","v":0.89458000000000004},null,2054,null,5426,null,{"$f":"ROUND((V19-X19),5)","v":-3372},null,{"$f":"ROUND(IF(X19=0, IF(V19=0, 0, 1), V19/X19),5)","v":0.37855},null,3454,null,5426,null,{"$f":"ROUND((AD19-AF19),5)","v":-1972},null,{"$f":"ROUND(IF(AF19=0, IF(AD19=0, 0, 1), AD19/AF19),5)","v":0.63656000000000001},null,7504,null,5426,null,{"$f":"ROUND((AL19-AN19),5)","v":2078},null,{"$f":"ROUND(IF(AN19=0, IF(AL19=0, 0, 1), AL19/AN19),5)","v":1.38297},null,10504,null,5426,null,{"$f":"ROUND((AT19-AV19),5)","v":5078},null,{"$f":"ROUND(IF(AV19=0, IF(AT19=0, 0, 1), AT19/AV19),5)","v":1.9358599999999999},null,9604,null,5426,null,{"$f":"ROUND((BB19-BD19),5)","v":4178},null,{"$f":"ROUND(IF(BD19=0, IF(BB19=0, 0, 1), BB19/BD19),5)","v":1.77},null,{"$f":"ROUND(F19+N19+V19+AD19+AL19+AT19+BB19,5)","v":38628},null,{"$f":"ROUND(H19+P19+X19+AF19+AN19+AV19+BD19,5)","v":37982},null,{"$f":"ROUND((BJ19-BL19),5)","v":646},null,{"$f":"ROUND(IF(BL19=0, IF(BJ19=0, 0, 1), BJ19/BL19),5)","v":1.01701}]
[null,null,null,null,"60000 · General & Admin Employee Exp",24908,null,26572,null,{"$f":"ROUND((F20-H20),5)","v":-1664},null,{"$f":"ROUND(IF(H20=0, IF(F20=0, 0, 1), F20/H20),5)","v":0.93737999999999999},null,24328,null,26572,null,{"$f":"ROUND((N20-P20),5)","v":-2244},null,{"$f":"ROUND(IF(P20=0, IF(N20=0, 0, 1), N20/P20),5)","v":0.91554999999999997},null,24203,null,26572,null,{"$f":"ROUND((V20-X20),5)","v":-2369},null,{"$f":"ROUND(IF(X20=0, IF(V20=0, 0, 1), V20/X20),5)","v":0.91085000000000005},null,24203,null,26572,null,{"$f":"ROUND((AD20-AF20),5)","v":-2369},null,{"$f":"ROUND(IF(AF20=0, IF(AD20=0, 0, 1), AD20/AF20),5)","v":0.91085000000000005},null,25727,null,26572,null,{"$f":"ROUND((AL20-AN20),5)","v":-845},null,{"$f":"ROUND(IF(AN20=0, IF(AL20=0, 0, 1), AL20/AN20),5)","v":0.96819999999999995},null,24203,null,26572,null,{"$f":"ROUND((AT20-AV20),5)","v":-2369},null,{"$f":"ROUND(IF(AV20=0, IF(AT20=0, 0, 1), AT20/AV20),5)","v":0.91085000000000005},null,24203,null,26572,null,{"$f":"ROUND((BB20-BD20),5)","v":-2369},null,{"$f":"ROUND(IF(BD20=0, IF(BB20=0, 0, 1), BB20/BD20),5)","v":0.91085000000000005},null,{"$f":"ROUND(F20+N20+V20+AD20+AL20+AT20+BB20,5)","v":171775},null,{"$f":"ROUND(H20+P20+X20+AF20+AN20+AV20+BD20,5)","v":186004},null,{"$f":"ROUND((BJ20-BL20),5)","v":-14229},null,{"$f":"ROUND(IF(BL20=0, IF(BJ20=0, 0, 1), BJ20/BL20),5)","v":0.92349999999999999}]
[null,null,null,null,"60700 · Advertising & Promotional",887,null,2065,null,{"$f":"ROUND((F21-H21),5)","v":-1178},null,{"$f":"ROUND(IF(H21=0, IF(F21=0, 0, 1), F21/H21),5)","v":0.42953999999999998},null,1139,null,2065,null,{"$f":"ROUND((N21-P21),5)","v":-926},null,{"$f":"ROUND(IF(P21=0, IF(N21=0, 0, 1), N21/P21),5)","v":0.55157},null,905,null,2065,null,{"$f":"ROUND((V21-X21),5)","v":-1160},null,{"$f":"ROUND(IF(X21=0, IF(V21=0, 0, 1), V21/X21),5)","v":0.43825999999999998},null,607,null,2065,null,{"$f":"ROUND((AD21-AF21),5)","v":-1458},null,{"$f":"ROUND(IF(AF21=0, IF(AD21=0, 0, 1), AD21/AF21),5)","v":0.29394999999999999},null,4322,null,2065,null,{"$f":"ROUND((AL21-AN21),5)","v":2257},null,{"$f":"ROUND(IF(AN21=0, IF(AL21=0, 0, 1), AL21/AN21),5)","v":2.0929799999999998},null,3567,null,2065,null,{"$f":"ROUND((AT21-AV21),5)","v":1502},null,{"$f":"ROUND(IF(AV21=0, IF(AT21=0, 0, 1), AT21/AV21),5)","v":1.72736},null,5057,null,2065,null,{"$f":"ROUND((BB21-BD21),5)","v":2992},null,{"$f":"ROUND(IF(BD21=0, IF(BB21=0, 0, 1), BB21/BD21),5)","v":2.4489100000000001},null,{"$f":"ROUND(F21+N21+V21+AD21+AL21+AT21+BB21,5)","v":16484},null,{"$f":"ROUND(H21+P21+X21+AF21+AN21+AV21+BD21,5)","v":14455},null,{"$f":"ROUND((BJ21-BL21),5)","v":2029},null,{"$f":"ROUND(IF(BL21=0, IF(BJ21=0, 0, 1), BJ21/BL21),5)","v":1.1403700000000001}]
[null,null,null,null,"62020 · Dues & Subscriptions",338,null,85,null,{"$f":"ROUND((F22-H22),5)","v":253},null,{"$f":"ROUND(IF(H22=0, IF(F22=0, 0, 1), F22/H22),5)","v":3.9764699999999999},null,0,null,85,null,{"$f":"ROUND((N22-P22),5)","v":-85},null,{"$f":"ROUND(IF(P22=0, IF(N22=0, 0, 1), N22/P22),5)","v":0},null,0,null,85,null,{"$f":"ROUND((V22-X22),5)","v":-85},null,{"$f":"ROUND(IF(X22=0, IF(V22=0, 0, 1), V22/X22),5)","v":0},null,401,null,85,null,{"$f":"ROUND((AD22-AF22),5)","v":316},null,{"$f":"ROUND(IF(AF22=0, IF(AD22=0, 0, 1), AD22/AF22),5)","v":4.7176499999999999},null,0,null,85,null,{"$f":"ROUND((AL22-AN22),5)","v":-85},null,{"$f":"ROUND(IF(AN22=0, IF(AL22=0, 0, 1), AL22/AN22),5)","v":0},null,0,null,85,null,{"$f":"ROUND((AT22-AV22),5)","v":-85},null,{"$f":"ROUND(IF(AV22=0, IF(AT22=0, 0, 1), AT22/AV22),5)","v":0},null,401,null,85,null,{"$f":"ROUND((BB22-BD22),5)","v":316},null,{"$f":"ROUND(IF(BD22=0, IF(BB22=0, 0, 1), BB22/BD22),5)","v":4.7176499999999999},null,{"$f":"ROUND(F22+N22+V22+AD22+AL22+AT22+BB22,5)","v":1140},null,{"$f":"ROUND(H22+P22+X22+AF22+AN22+AV22+BD22,5)","v":595},null,{"$f":"ROUND((BJ22-BL22),5)","v":545},null,{"$f":"ROUND(IF(BL22=0, IF(BJ22=0, 0, 1), BJ22/BL22),5)","v":1.91597}]
[null,null,null,null,"62030 · Equipment Rental",333,null,2101,null,{"$f":"ROUND((F23-H23),5)","v":-1768},null,{"$f":"ROUND(IF(H23=0, IF(F23=0, 0, 1), F23/H23),5)","v":0.1585},null,458,null,2101,null,{"$f":"ROUND((N23-P23),5)","v":-1643},null,{"$f":"ROUND(IF(P23=0, IF(N23=0, 0, 1), N23/P23),5)","v":0.21798999999999999},null,391,null,2101,null,{"$f":"ROUND((V23-X23),5)","v":-1710},null,{"$f":"ROUND(IF(X23=0, IF(V23=0, 0, 1), V23/X23),5)","v":0.18609999999999999},null,4932,null,2101,null,{"$f":"ROUND((AD23-AF23),5)","v":2831},null,{"$f":"ROUND(IF(AF23=0, IF(AD23=0, 0, 1), AD23/AF23),5)","v":2.3474499999999998},null,2203,null,2101,null,{"$f":"ROUND((AL23-AN23),5)","v":102},null,{"$f":"ROUND(IF(AN23=0, IF(AL23=0, 0, 1), AL23/AN23),5)","v":1.0485500000000001},null,9888,null,2101,null,{"$f":"ROUND((AT23-AV23),5)","v":7787},null,{"$f":"ROUND(IF(AV23=0, IF(AT23=0, 0, 1), AT23/AV23),5)","v":4.7063300000000003},null,3400,null,2101,null,{"$f":"ROUND((BB23-BD23),5)","v":1299},null,{"$f":"ROUND(IF(BD23=0, IF(BB23=0, 0, 1), BB23/BD23),5)","v":1.6182799999999999},null,{"$f":"ROUND(F23+N23+V23+AD23+AL23+AT23+BB23,5)","v":21605},null,{"$f":"ROUND(H23+P23+X23+AF23+AN23+AV23+BD23,5)","v":14707},null,{"$f":"ROUND((BJ23-BL23),5)","v":6898},null,{"$f":"ROUND(IF(BL23=0, IF(BJ23=0, 0, 1), BJ23/BL23),5)","v":1.4690300000000001}]
[null,null,null,null,"62040 · Repairs & Maintenance",5558,null,6782,null,{"$f":"ROUND((F24-H24),5)","v":-1224},null,{"$f":"ROUND(IF(H24=0, IF(F24=0, 0, 1), F24/H24),5)","v":0.81952000000000003},null,8028,null,6782,null,{"$f":"ROUND((N24-P24),5)","v":1246},null,{"$f":"ROUND(IF(P24=0, IF(N24=0, 0, 1), N24/P24),5)","v":1.1837200000000001},null,2888,null,6782,null,{"$f":"ROUND((V24-X24),5)","v":-3894},null,{"$f":"ROUND(IF(X24=0, IF(V24=0, 0, 1), V24/X24),5)","v":0.42582999999999999},null,8601,null,6782,null,{"$f":"ROUND((AD24-AF24),5)","v":1819},null,{"$f":"ROUND(IF(AF24=0, IF(AD24=0, 0, 1), AD24/AF24),5)","v":1.2682100000000001},null,5057,null,6782,null,{"$f":"ROUND((AL24-AN24),5)","v":-1725},null,{"$f":"ROUND(IF(AN24=0, IF(AL24=0, 0, 1), AL24/AN24),5)","v":0.74565000000000003},null,5211,null,6782,null,{"$f":"ROUND((AT24-AV24),5)","v":-1571},null,{"$f":"ROUND(IF(AV24=0, IF(AT24=0, 0, 1), AT24/AV24),5)","v":0.76836000000000004},null,5483,null,6782,null,{"$f":"ROUND((BB24-BD24),5)","v":-1299},null,{"$f":"ROUND(IF(BD24=0, IF(BB24=0, 0, 1), BB24/BD24),5)","v":0.80845999999999996},null,{"$f":"ROUND(F24+N24+V24+AD24+AL24+AT24+BB24,5)","v":40826},null,{"$f":"ROUND(H24+P24+X24+AF24+AN24+AV24+BD24,5)","v":47474},null,{"$f":"ROUND((BJ24-BL24),5)","v":-6648},null,{"$f":"ROUND(IF(BL24=0, IF(BJ24=0, 0, 1), BJ24/BL24),5)","v":0.85997000000000001}]
[null,null,null,null,"62100 · Auto related",51,null,64,null,{"$f":"ROUND((F25-H25),5)","v":-13},null,{"$f":"ROUND(IF(H25=0, IF(F25=0, 0, 1), F25/H25),5)","v":0.79688000000000003},null,114,null,64,null,{"$f":"ROUND((N25-P25),5)","v":50},null,{"$f":"ROUND(IF(P25=0, IF(N25=0, 0, 1), N25/P25),5)","v":1.78125},null,0,null,64,null,{"$f":"ROUND((V25-X25),5)","v":-64},null,{"$f":"ROUND(IF(X25=0, IF(V25=0, 0, 1), V25/X25),5)","v":0},null,170,null,64,null,{"$f":"ROUND((AD25-AF25),5)","v":106},null,{"$f":"ROUND(IF(AF25=0, IF(AD25=0, 0, 1), AD25/AF25),5)","v":2.65625},null,75,null,64,null,{"$f":"ROUND((AL25-AN25),5)","v":11},null,{"$f":"ROUND(IF(AN25=0, IF(AL25=0, 0, 1), AL25/AN25),5)","v":1.17188},null,80,null,64,null,{"$f":"ROUND((AT25-AV25),5)","v":16},null,{"$f":"ROUND(IF(AV25=0, IF(AT25=0, 0, 1), AT25/AV25),5)","v":1.25},null,116,null,64,null,{"$f":"ROUND((BB25-BD25),5)","v":52},null,{"$f":"ROUND(IF(BD25=0, IF(BB25=0, 0, 1), BB25/BD25),5)","v":1.8125},null,{"$f":"ROUND(F25+N25+V25+AD25+AL25+AT25+BB25,5)","v":606},null,{"$f":"ROUND(H25+P25+X25+AF25+AN25+AV25+BD25,5)","v":448},null,{"$f":"ROUND((BJ25-BL25),5)","v":158},null,{"$f":"ROUND(IF(BL25=0, IF(BJ25=0, 0, 1), BJ25/BL25),5)","v":1.3526800000000001}]
[null,null,null,null,"62200 · Meals and Entertainment",3278,null,60,null,{"$f":"ROUND((F26-H26),5)","v":3218},null,{"$f":"ROUND(IF(H26=0, IF(F26=0, 0, 1), F26/H26),5)","v":54.633330000000001},null,0,null,60,null,{"$f":"ROUND((N26-P26),5)","v":-60},null,{"$f":"ROUND(IF(P26=0, IF(N26=0, 0, 1), N26/P26),5)","v":0},null,157,null,60,null,{"$f":"ROUND((V26-X26),5)","v":97},null,{"$f":"ROUND(IF(X26=0, IF(V26=0, 0, 1), V26/X26),5)","v":2.6166700000000001},null,0,null,60,null,{"$f":"ROUND((AD26-AF26),5)","v":-60},null,{"$f":"ROUND(IF(AF26=0, IF(AD26=0, 0, 1), AD26/AF26),5)","v":0},null,0,null,60,null,{"$f":"ROUND((AL26-AN26),5)","v":-60},null,{"$f":"ROUND(IF(AN26=0, IF(AL26=0, 0, 1), AL26/AN26),5)","v":0},null,0,null,60,null,{"$f":"ROUND((AT26-AV26),5)","v":-60},null,{"$f":"ROUND(IF(AV26=0, IF(AT26=0, 0, 1), AT26/AV26),5)","v":0},null,0,null,60,null,{"$f":"ROUND((BB26-BD26),5)","v":-60},null,{"$f":"ROUND(IF(BD26=0, IF(BB26=0, 0, 1), BB26/BD26),5)","v":0},null,{"$f":"ROUND(F26+N26+V26+AD26+AL26+AT26+BB26,5)","v":3435},null,{"$f":"ROUND(H26+P26+X26+AF26+AN26+AV26+BD26,5)","v":420},null,{"$f":"ROUND((BJ26-BL26),5)","v":3015},null,{"$f":"ROUND(IF(BL26=0, IF(BJ26=0, 0, 1), BJ26/BL26),5)","v":8.1785700000000006}]
[null,null,null,null,"62300 · Postage",0,null,211,null,{"$f":"ROUND((F27-H27),5)","v":-211},null,{"$f":"ROUND(IF(H27=0, IF(F27=0, 0, 1), F27/H27),5)","v":0},null,676,null,211,null,{"$f":"ROUND((N27-P27),5)","v":465},null,{"$f":"ROUND(IF(P27=0, IF(N27=0, 0, 1), N27/P27),5)","v":3.2037900000000001},null,31,null,211,null,{"$f":"ROUND((V27-X27),5)","v":-180},null,{"$f":"ROUND(IF(X27=0, IF(V27=0, 0, 1), V27/X27),5)","v":0.14692},null,630,null,211,null,{"$f":"ROUND((AD27-AF27),5)","v":419},null,{"$f":"ROUND(IF(AF27=0, IF(AD27=0, 0, 1), AD27/AF27),5)","v":2.9857800000000001},null,0,null,211,null,{"$f":"ROUND((AL27-AN27),5)","v":-211},null,{"$f":"ROUND(IF(AN27=0, IF(AL27=0, 0, 1), AL27/AN27),5)","v":0},null,630,null,211,null,{"$f":"ROUND((AT27-AV27),5)","v":419},null,{"$f":"ROUND(IF(AV27=0, IF(AT27=0, 0, 1), AT27/AV27),5)","v":2.9857800000000001},null,0,null,211,null,{"$f":"ROUND((BB27-BD27),5)","v":-211},null,{"$f":"ROUND(IF(BD27=0, IF(BB27=0, 0, 1), BB27/BD27),5)","v":0},null,{"$f":"ROUND(F27+N27+V27+AD27+AL27+AT27+BB27,5)","v":1967},null,{"$f":"ROUND(H27+P27+X27+AF27+AN27+AV27+BD27,5)","v":1477},null,{"$f":"ROUND((BJ27-BL27),5)","v":490},null,{"$f":"ROUND(IF(BL27=0, IF(BJ27=0, 0, 1), BJ27/BL27),5)","v":1.33175}]
[null,null,null,null,"62400 · Printing",1101,null,160,null,{"$f":"ROUND((F28-H28),5)","v":941},null,{"$f":"ROUND(IF(H28=0, IF(F28=0, 0, 1), F28/H28),5)","v":6.8812499999999996},null,0,null,160,null,{"$f":"ROUND((N28-P28),5)","v":-160},null,{"$f":"ROUND(IF(P28=0, IF(N28=0, 0, 1), N28/P28),5)","v":0},null,378,null,160,null,{"$f":"ROUND((V28-X28),5)","v":218},null,{"$f":"ROUND(IF(X28=0, IF(V28=0, 0, 1), V28/X28),5)","v":2.3624999999999998},null,0,null,160,null,{"$f":"ROUND((AD28-AF28),5)","v":-160},null,{"$f":"ROUND(IF(AF28=0, IF(AD28=0, 0, 1), AD28/AF28),5)","v":0},null,0,null,160,null,{"$f":"ROUND((AL28-AN28),5)","v":-160},null,{"$f":"ROUND(IF(AN28=0, IF(AL28=0, 0, 1), AL28/AN28),5)","v":0},null,0,null,160,null,{"$f":"ROUND((AT28-AV28),5)","v":-160},null,{"$f":"ROUND(IF(AV28=0, IF(AT28=0, 0, 1), AT28/AV28),5)","v":0},null,0,null,160,null,{"$f":"ROUND((BB28-BD28),5)","v":-160},null,{"$f":"ROUND(IF(BD28=0, IF(BB28=0, 0, 1), BB28/BD28),5)","v":0},null,{"$f":"ROUND(F28+N28+V28+AD28+AL28+AT28+BB28,5)","v":1479},null,{"$f":"ROUND(H28+P28+X28+AF28+AN28+AV28+BD28,5)","v":1120},null,{"$f":"ROUND((BJ28-BL28),5)","v":359},null,{"$f":"ROUND(IF(BL28=0, IF(BJ28=0, 0, 1), BJ28/BL28),5)","v":1.32054}]
[null,null,null,null,"62500 · Training",100,null,325,null,{"$f":"ROUND((F29-H29),5)","v":-225},null,{"$f":"ROUND(IF(H29=0, IF(F29=0, 0, 1), F29/H29),5)","v":0.30769000000000002},null,850,null,325,null,{"$f":"ROUND((N29-P29),5)","v":525},null,{"$f":"ROUND(IF(P29=0, IF(N29=0, 0, 1), N29/P29),5)","v":2.61538},null,262,null,325,null,{"$f":"ROUND((V29-X29),5)","v":-63},null,{"$f":"ROUND(IF(X29=0, IF(V29=0, 0, 1), V29/X29),5)","v":0.80615000000000003},null,0,null,325,null,{"$f":"ROUND((AD29-AF29),5)","v":-325},null,{"$f":"ROUND(IF(AF29=0, IF(AD29=0, 0, 1), AD29/AF29),5)","v":0},null,0,null,325,null,{"$f":"ROUND((AL29-AN29),5)","v":-325},null,{"$f":"ROUND(IF(AN29=0, IF(AL29=0, 0, 1), AL29/AN29),5)","v":0},null,0,null,325,null,{"$f":"ROUND((AT29-AV29),5)","v":-325},null,{"$f":"ROUND(IF(AV29=0, IF(AT29=0, 0, 1), AT29/AV29),5)","v":0},null,0,null,325,null,{"$f":"ROUND((BB29-BD29),5)","v":-325},null,{"$f":"ROUND(IF(BD29=0, IF(BB29=0, 0, 1), BB29/BD29),5)","v":0},null,{"$f":"ROUND(F29+N29+V29+AD29+AL29+AT29+BB29,5)","v":1212},null,{"$f":"ROUND(H29+P29+X29+AF29+AN29+AV29+BD29,5)","v":2275},null,{"$f":"ROUND((BJ29-BL29),5)","v":-1063},null,{"$f":"ROUND(IF(BL29=0, IF(BJ29=0, 0, 1), BJ29/BL29),5)","v":0.53274999999999995}]
[null,null,null,null,"63000 · Insurance",2782,null,3923,null,{"$f":"ROUND((F30-H30),5)","v":-1141},null,{"$f":"ROUND(IF(H30=0, IF(F30=0, 0, 1), F30/H30),5)","v":0.70914999999999995},null,1417,null,3923,null,{"$f":"ROUND((N30-P30),5)","v":-2506},null,{"$f":"ROUND(IF(P30=0, IF(N30=0, 0, 1), N30/P30),5)","v":0.36120000000000002},null,-926,null,3923,null,{"$f":"ROUND((V30-X30),5)","v":-4849},null,{"$f":"ROUND(IF(X30=0, IF(V30=0, 0, 1), V30/X30),5)","v":-0.23604},null,2786,null,3923,null,{"$f":"ROUND((AD30-AF30),5)","v":-1137},null,{"$f":"ROUND(IF(AF30=0, IF(AD30=0, 0, 1), AD30/AF30),5)","v":0.71016999999999997},null,2950,null,3923,null,{"$f":"ROUND((AL30-AN30),5)","v":-973},null,{"$f":"ROUND(IF(AN30=0, IF(AL30=0, 0, 1), AL30/AN30),5)","v":0.75197999999999998},null,2806,null,3923,null,{"$f":"ROUND((AT30-AV30),5)","v":-1117},null,{"$f":"ROUND(IF(AV30=0, IF(AT30=0, 0, 1), AT30/AV30),5)","v":0.71526999999999996},null,2786,null,3923,null,{"$f":"ROUND((BB30-BD30),5)","v":-1137},null,{"$f":"ROUND(IF(BD30=0, IF(BB30=0, 0, 1), BB30/BD30),5)","v":0.71016999999999997},null,{"$f":"ROUND(F30+N30+V30+AD30+AL30+AT30+BB30,5)","v":14601},null,{"$f":"ROUND(H30+P30+X30+AF30+AN30+AV30+BD30,5)","v":27461},null,{"$f":"ROUND((BJ30-BL30),5)","v":-12860},null,{"$f":"ROUND(IF(BL30=0, IF(BJ30=0, 0, 1), BJ30/BL30),5)","v":0.53169999999999995}]
[null,null,null,null,"64000 · Supplies and Related",5637,null,3487,null,{"$f":"ROUND((F31-H31),5)","v":2150},null,{"$f":"ROUND(IF(H31=0, IF(F31=0, 0, 1), F31/H31),5)","v":1.6165799999999999},null,4729,null,3487,null,{"$f":"ROUND((N31-P31),5)","v":1242},null,{"$f":"ROUND(IF(P31=0, IF(N31=0, 0, 1), N31/P31),5)","v":1.3561799999999999},null,2052,null,3487,null,{"$f":"ROUND((V31-X31),5)","v":-1435},null,{"$f":"ROUND(IF(X31=0, IF(V31=0, 0, 1), V31/X31),5)","v":0.58847000000000005},null,2219,null,3487,null,{"$f":"ROUND((AD31-AF31),5)","v":-1268},null,{"$f":"ROUND(IF(AF31=0, IF(AD31=0, 0, 1), AD31/AF31),5)","v":0.63636000000000004},null,4883,null,3487,null,{"$f":"ROUND((AL31-AN31),5)","v":1396},null,{"$f":"ROUND(IF(AN31=0, IF(AL31=0, 0, 1), AL31/AN31),5)","v":1.4003399999999999},null,2851,null,3487,null,{"$f":"ROUND((AT31-AV31),5)","v":-636},null,{"$f":"ROUND(IF(AV31=0, IF(AT31=0, 0, 1), AT31/AV31),5)","v":0.81760999999999995},null,3770,null,3487,null,{"$f":"ROUND((BB31-BD31),5)","v":283},null,{"$f":"ROUND(IF(BD31=0, IF(BB31=0, 0, 1), BB31/BD31),5)","v":1.0811599999999999},null,{"$f":"ROUND(F31+N31+V31+AD31+AL31+AT31+BB31,5)","v":26141},null,{"$f":"ROUND(H31+P31+X31+AF31+AN31+AV31+BD31,5)","v":24409},null,{"$f":"ROUND((BJ31-BL31),5)","v":1732},null,{"$f":"ROUND(IF(BL31=0, IF(BJ31=0, 0, 1), BJ31/BL31),5)","v":1.0709599999999999}]
[null,null,null,null,"65000 · Professional Services",4557,null,3015,null,{"$f":"ROUND((F32-H32),5)","v":1542},null,{"$f":"ROUND(IF(H32=0, IF(F32=0, 0, 1), F32/H32),5)","v":1.5114399999999999},null,4038,null,3015,null,{"$f":"ROUND((N32-P32),5)","v":1023},null,{"$f":"ROUND(IF(P32=0, IF(N32=0, 0, 1), N32/P32),5)","v":1.3392999999999999},null,3247,null,3015,null,{"$f":"ROUND((V32-X32),5)","v":232},null,{"$f":"ROUND(IF(X32=0, IF(V32=0, 0, 1), V32/X32),5)","v":1.0769500000000001},null,2706,null,3015,null,{"$f":"ROUND((AD32-AF32),5)","v":-309},null,{"$f":"ROUND(IF(AF32=0, IF(AD32=0, 0, 1), AD32/AF32),5)","v":0.89751000000000003},null,3011,null,3015,null,{"$f":"ROUND((AL32-AN32),5)","v":-4},null,{"$f":"ROUND(IF(AN32=0, IF(AL32=0, 0, 1), AL32/AN32),5)","v":0.99866999999999995},null,3699,null,3015,null,{"$f":"ROUND((AT32-AV32),5)","v":684},null,{"$f":"ROUND(IF(AV32=0, IF(AT32=0, 0, 1), AT32/AV32),5)","v":1.2268699999999999},null,2832,null,3015,null,{"$f":"ROUND((BB32-BD32),5)","v":-183},null,{"$f":"ROUND(IF(BD32=0, IF(BB32=0, 0, 1), BB32/BD32),5)","v":0.93930000000000002},null,{"$f":"ROUND(F32+N32+V32+AD32+AL32+AT32+BB32,5)","v":24090},null,{"$f":"ROUND(H32+P32+X32+AF32+AN32+AV32+BD32,5)","v":21105},null,{"$f":"ROUND((BJ32-BL32),5)","v":2985},null,{"$f":"ROUND(IF(BL32=0, IF(BJ32=0, 0, 1), BJ32/BL32),5)","v":1.14144}]
[null,null,null,null,"65050 · Other Outside Services",322,null,2579,null,{"$f":"ROUND((F33-H33),5)","v":-2257},null,{"$f":"ROUND(IF(H33=0, IF(F33=0, 0, 1), F33/H33),5)","v":0.12485},null,971,null,2579,null,{"$f":"ROUND((N33-P33),5)","v":-1608},null,{"$f":"ROUND(IF(P33=0, IF(N33=0, 0, 1), N33/P33),5)","v":0.3765},null,1214,null,2579,null,{"$f":"ROUND((V33-X33),5)","v":-1365},null,{"$f":"ROUND(IF(X33=0, IF(V33=0, 0, 1), V33/X33),5)","v":0.47072999999999998},null,1401,null,2579,null,{"$f":"ROUND((AD33-AF33),5)","v":-1178},null,{"$f":"ROUND(IF(AF33=0, IF(AD33=0, 0, 1), AD33/AF33),5)","v":0.54322999999999999},null,1428,null,2579,null,{"$f":"ROUND((AL33-AN33),5)","v":-1151},null,{"$f":"ROUND(IF(AN33=0, IF(AL33=0, 0, 1), AL33/AN33),5)","v":0.55369999999999997},null,1680,null,2579,null,{"$f":"ROUND((AT33-AV33),5)","v":-899},null,{"$f":"ROUND(IF(AV33=0, IF(AT33=0, 0, 1), AT33/AV33),5)","v":0.65142},null,1401,null,2579,null,{"$f":"ROUND((BB33-BD33),5)","v":-1178},null,{"$f":"ROUND(IF(BD33=0, IF(BB33=0, 0, 1), BB33/BD33),5)","v":0.54322999999999999},null,{"$f":"ROUND(F33+N33+V33+AD33+AL33+AT33+BB33,5)","v":8417},null,{"$f":"ROUND(H33+P33+X33+AF33+AN33+AV33+BD33,5)","v":18053},null,{"$f":"ROUND((BJ33-BL33),5)","v":-9636},null,{"$f":"ROUND(IF(BL33=0, IF(BJ33=0, 0, 1), BJ33/BL33),5)","v":0.46623999999999999}]
[null,null,null,null,"66000 · Bank and Other Service Charges",462,null,290,null,{"$f":"ROUND((F34-H34),5)","v":172},null,{"$f":"ROUND(IF(H34=0, IF(F34=0, 0, 1), F34/H34),5)","v":1.5931},null,252,null,290,null,{"$f":"ROUND((N34-P34),5)","v":-38},null,{"$f":"ROUND(IF(P34=0, IF(N34=0, 0, 1), N34/P34),5)","v":0.86897000000000002},null,258,null,290,null,{"$f":"ROUND((V34-X34),5)","v":-32},null,{"$f":"ROUND(IF(X34=0, IF(V34=0, 0, 1), V34/X34),5)","v":0.88966000000000001},null,266,null,290,null,{"$f":"ROUND((AD34-AF34),5)","v":-24},null,{"$f":"ROUND(IF(AF34=0, IF(AD34=0, 0, 1), AD34/AF34),5)","v":0.91724000000000006},null,285,null,290,null,{"$f":"ROUND((AL34-AN34),5)","v":-5},null,{"$f":"ROUND(IF(AN34=0, IF(AL34=0, 0, 1), AL34/AN34),5)","v":0.98275999999999997},null,293,null,290,null,{"$f":"ROUND((AT34-AV34),5)","v":3},null,{"$f":"ROUND(IF(AV34=0, IF(AT34=0, 0, 1), AT34/AV34),5)","v":1.01034},null,277,null,290,null,{"$f":"ROUND((BB34-BD34),5)","v":-13},null,{"$f":"ROUND(IF(BD34=0, IF(BB34=0, 0, 1), BB34/BD34),5)","v":0.95516999999999996},null,{"$f":"ROUND(F34+N34+V34+AD34+AL34+AT34+BB34,5)","v":2093},null,{"$f":"ROUND(H34+P34+X34+AF34+AN34+AV34+BD34,5)","v":2030},null,{"$f":"ROUND((BJ34-BL34),5)","v":63},null,{"$f":"ROUND(IF(BL34=0, IF(BJ34=0, 0, 1), BJ34/BL34),5)","v":1.0310299999999999}]
[null,null,null,null,"67000 · Taxes and Fees",0,null,0,null,{"$f":"ROUND((F35-H35),5)","v":0},null,{"$f":"ROUND(IF(H35=0, IF(F35=0, 0, 1), F35/H35),5)","v":0},null,7112,null,7000,null,{"$f":"ROUND((N35-P35),5)","v":112},null,{"$f":"ROUND(IF(P35=0, IF(N35=0, 0, 1), N35/P35),5)","v":1.016},null,0,null,0,null,{"$f":"ROUND((V35-X35),5)","v":0},null,{"$f":"ROUND(IF(X35=0, IF(V35=0, 0, 1), V35/X35),5)","v":0},null,0,null,0,null,{"$f":"ROUND((AD35-AF35),5)","v":0},null,{"$f":"ROUND(IF(AF35=0, IF(AD35=0, 0, 1), AD35/AF35),5)","v":0},null,654,null,500,null,{"$f":"ROUND((AL35-AN35),5)","v":154},null,{"$f":"ROUND(IF(AN35=0, IF(AL35=0, 0, 1), AL35/AN35),5)","v":1.3080000000000001},null,2095,null,1000,null,{"$f":"ROUND((AT35-AV35),5)","v":1095},null,{"$f":"ROUND(IF(AV35=0, IF(AT35=0, 0, 1), AT35/AV35),5)","v":2.0950000000000002},null,222,null,0,null,{"$f":"ROUND((BB35-BD35),5)","v":222},null,{"$f":"ROUND(IF(BD35=0, IF(BB35=0, 0, 1), BB35/BD35),5)","v":1},null,{"$f":"ROUND(F35+N35+V35+AD35+AL35+AT35+BB35,5)","v":10083},null,{"$f":"ROUND(H35+P35+X35+AF35+AN35+AV35+BD35,5)","v":8500},null,{"$f":"ROUND((BJ35-BL35),5)","v":1583},null,{"$f":"ROUND(IF(BL35=0, IF(BJ35=0, 0, 1), BJ35/BL35),5)","v":1.18624}]
[null,null,null,null,"68000 · Utilities",5149,null,5801,null,{"$f":"ROUND((F36-H36),5)","v":-652},null,{"$f":"ROUND(IF(H36=0, IF(F36=0, 0, 1), F36/H36),5)","v":0.88761000000000001},null,5827,null,5801,null,{"$f":"ROUND((N36-P36),5)","v":26},null,{"$f":"ROUND(IF(P36=0, IF(N36=0, 0, 1), N36/P36),5)","v":1.00448},null,5066,null,5801,null,{"$f":"ROUND((V36-X36),5)","v":-735},null,{"$f":"ROUND(IF(X36=0, IF(V36=0, 0, 1), V36/X36),5)","v":0.87329999999999997},null,4311,null,5801,null,{"$f":"ROUND((AD36-AF36),5)","v":-1490},null,{"$f":"ROUND(IF(AF36=0, IF(AD36=0, 0, 1), AD36/AF36),5)","v":0.74314999999999998},null,5686,null,5801,null,{"$f":"ROUND((AL36-AN36),5)","v":-115},null,{"$f":"ROUND(IF(AN36=0, IF(AL36=0, 0, 1), AL36/AN36),5)","v":0.98018000000000005},null,8059,null,5801,null,{"$f":"ROUND((AT36-AV36),5)","v":2258},null,{"$f":"ROUND(IF(AV36=0, IF(AT36=0, 0, 1), AT36/AV36),5)","v":1.38924},null,8299,null,5801,null,{"$f":"ROUND((BB36-BD36),5)","v":2498},null,{"$f":"ROUND(IF(BD36=0, IF(BB36=0, 0, 1), BB36/BD36),5)","v":1.43062},null,{"$f":"ROUND(F36+N36+V36+AD36+AL36+AT36+BB36,5)","v":42397},null,{"$f":"ROUND(H36+P36+X36+AF36+AN36+AV36+BD36,5)","v":40607},null,{"$f":"ROUND((BJ36-BL36),5)","v":1790},null,{"$f":"ROUND(IF(BL36=0, IF(BJ36=0, 0, 1), BJ36/BL36),5)","v":1.0440799999999999}]
[null,null,null,"Total Expense",null,{"$f":"ROUND(SUM(F13:F36),5)","v":141187},null,{"$f":"ROUND(SUM(H13:H36),5)","v":145872},null,{"$f":"ROUND((F37-H37),5)","v":-4685},null,{"$f":"ROUND(IF(H37=0, IF(F37=0, 0, 1), F37/H37),5)","v":0.96787999999999996},null,{"$f":"ROUND(SUM(N13:N36),5)","v":143447},null,{"$f":"ROUND(SUM(P13:P36),5)","v":159606},null,{"$f":"ROUND((N37-P37),5)","v":-16159},null,{"$f":"ROUND(IF(P37=0, IF(N37=0, 0, 1), N37/P37),5)","v":0.89876},null,{"$f":"ROUND(SUM(V13:V36),5)","v":129146},null,{"$f":"ROUND(SUM(X13:X36),5)","v":159517},null,{"$f":"ROUND((V37-X37),5)","v":-30371},null,{"$f":"ROUND(IF(X37=0, IF(V37=0, 0, 1), V37/X37),5)","v":0.80961000000000005},null,{"$f":"ROUND(SUM(AD13:AD36),5)","v":170086},null,{"$f":"ROUND(SUM(AF13:AF36),5)","v":168444},null,{"$f":"ROUND((AD37-AF37),5)","v":1642},null,{"$f":"ROUND(IF(AF37=0, IF(AD37=0, 0, 1), AD37/AF37),5)","v":1.0097499999999999},null,{"$f":"ROUND(SUM(AL13:AL36),5)","v":188128},null,{"$f":"ROUND(SUM(AN13:AN36),5)","v":164129},null,{"$f":"ROUND((AL37-AN37),5)","v":23999},null,{"$f":"ROUND(IF(AN37=0, IF(AL37=0, 0, 1), AL37/AN37),5)","v":1.14622},null,{"$f":"ROUND(SUM(AT13:AT36),5)","v":180150},null,{"$f":"ROUND(SUM(AV13:AV36),5)","v":168901},null,{"$f":"ROUND((AT37-AV37),5)","v":11249},null,{"$f":"ROUND(IF(AV37=0, IF(AT37=0, 0, 1), AT37/AV37),5)","v":1.0666},null,{"$f":"ROUND(SUM(BB13:BB36),5)","v":163384},null,{"$f":"ROUND(SUM(BD13:BD36),5)","v":174068},null,{"$f":"ROUND((BB37-BD37),5)","v":-10684},null,{"$f":"ROUND(IF(BD37=0, IF(BB37=0, 0, 1), BB37/BD37),5)","v":0.93862000000000001},null,{"$f":"ROUND(F37+N37+V37+AD37+AL37+AT37+BB37,5)","v":1115528},null,{"$f":"ROUND(H37+P37+X37+AF37+AN37+AV37+BD37,5)","v":1140537},null,{"$f":"ROUND((BJ37-BL37),5)","v":-25009},null,{"$f":"ROUND(IF(BL37=0, IF(BJ37=0, 0, 1), BJ37/BL37),5)","v":0.97806999999999999}]
[null,"Net Ordinary Income",null,null,null,{"$f":"ROUND(F3+F12-F37,5)","v":-19222},null,{"$f":"ROUND(H3+H12-H37,5)","v":-54813},null,{"$f":"ROUND((F38-H38),5)","v":35591},null,{"$f":"ROUND(IF(H38=0, IF(F38=0, 0, 1), F38/H38),5)","v":0.35067999999999999},null,{"$f":"ROUND(N3+N12-N37,5)","v":-22888},null,{"$f":"ROUND(P3+P12-P37,5)","v":-52457},null,{"$f":"ROUND((N38-P38),5)","v":29569},null,{"$f":"ROUND(IF(P38=0, IF(N38=0, 0, 1), N38/P38),5)","v":0.43631999999999999},null,{"$f":"ROUND(V3+V12-V37,5)","v":10771},null,{"$f":"ROUND(X3+X12-X37,5)","v":-10419},null,{"$f":"ROUND((V38-X38),5)","v":21190},null,{"$f":"ROUND(IF(X38=0, IF(V38=0, 0, 1), V38/X38),5)","v":-1.0337799999999999},null,{"$f":"ROUND(AD3+AD12-AD37,5)","v":20203},null,{"$f":"ROUND(AF3+AF12-AF37,5)","v":6382},null,{"$f":"ROUND((AD38-AF38),5)","v":13821},null,{"$f":"ROUND(IF(AF38=0, IF(AD38=0, 0, 1), AD38/AF38),5)","v":3.1656200000000001},null,{"$f":"ROUND(AL3+AL12-AL37,5)","v":-20253},null,{"$f":"ROUND(AN3+AN12-AN37,5)","v":8217},null,{"$f":"ROUND((AL38-AN38),5)","v":-28470},null,{"$f":"ROUND(IF(AN38=0, IF(AL38=0, 0, 1), AL38/AN38),5)","v":-2.4647700000000001},null,{"$f":"ROUND(AT3+AT12-AT37,5)","v":29246},null,{"$f":"ROUND(AV3+AV12-AV37,5)","v":18921},null,{"$f":"ROUND((AT38-AV38),5)","v":10325},null,{"$f":"ROUND(IF(AV38=0, IF(AT38=0, 0, 1), AT38/AV38),5)","v":1.54569},null,{"$f":"ROUND(BB3+BB12-BB37,5)","v":-13928},null,{"$f":"ROUND(BD3+BD12-BD37,5)","v":8470},null,{"$f":"ROUND((BB38-BD38),5)","v":-22398},null,{"$f":"ROUND(IF(BD38=0, IF(BB38=0, 0, 1), BB38/BD38),5)","v":-1.64439},null,{"$f":"ROUND(F38+N38+V38+AD38+AL38+AT38+BB38,5)","v":-16071},null,{"$f":"ROUND(H38+P38+X38+AF38+AN38+AV38+BD38,5)","v":-75699},null,{"$f":"ROUND((BJ38-BL38),5)","v":59628},null,{"$f":"ROUND(IF(BL38=0, IF(BJ38=0, 0, 1), BJ38/BL38),5)","v":0.21229999999999999}]
[null,"Other Income/Expense"]
[null,null,"Other Income"]
[null,null,null,"70001 · Interest & Dividend Income",null,1,null,1,null,{"$f":"ROUND((F41-H41),5)","v":0},null,{"$f":"ROUND(IF(H41=0, IF(F41=0, 0, 1), F41/H41),5)","v":1},null,0,null,1,null,{"$f":"ROUND((N41-P41),5)","v":-1},null,{"$f":"ROUND(IF(P41=0, IF(N41=0, 0, 1), N41/P41),5)","v":0},null,0,null,1,null,{"$f":"ROUND((V41-X41),5)","v":-1},null,{"$f":"ROUND(IF(X41=0, IF(V41=0, 0, 1), V41/X41),5)","v":0},null,0,null,1,null,{"$f":"ROUND((AD41-AF41),5)","v":-1},null,{"$f":"ROUND(IF(AF41=0, IF(AD41=0, 0, 1), AD41/AF41),5)","v":0},null,0,null,1,null,{"$f":"ROUND((AL41-AN41),5)","v":-1},null,{"$f":"ROUND(IF(AN41=0, IF(AL41=0, 0, 1), AL41/AN41),5)","v":0},null,1,null,1,null,{"$f":"ROUND((AT41-AV41),5)","v":0},null,{"$f":"ROUND(IF(AV41=0, IF(AT41=0, 0, 1), AT41/AV41),5)","v":1},null,0,null,1,null,{"$f":"ROUND((BB41-BD41),5)","v":-1},null,{"$f":"ROUND(IF(BD41=0, IF(BB41=0, 0, 1), BB41/BD41),5)","v":0},null,{"$f":"ROUND(F41+N41+V41+AD41+AL41+AT41+BB41,5)","v":2},null,{"$f":"ROUND(H41+P41+X41+AF41+AN41+AV41+BD41,5)","v":7},null,{"$f":"ROUND((BJ41-BL41),5)","v":-5},null,{"$f":"ROUND(IF(BL41=0, IF(BJ41=0, 0, 1), BJ41/BL41),5)","v":0.28571000000000002}]
[null,null,null,"70011 · Assessment Fee Income",null,125,null,125,null,{"$f":"ROUND((F42-H42),5)","v":0},null,{"$f":"ROUND(IF(H42=0, IF(F42=0, 0, 1), F42/H42),5)","v":1},null,125,null,125,null,{"$f":"ROUND((N42-P42),5)","v":0},null,{"$f":"ROUND(IF(P42=0, IF(N42=0, 0, 1), N42/P42),5)","v":1},null,125,null,125,null,{"$f":"ROUND((V42-X42),5)","v":0},null,{"$f":"ROUND(IF(X42=0, IF(V42=0, 0, 1), V42/X42),5)","v":1},null,125,null,125,null,{"$f":"ROUND((AD42-AF42),5)","v":0},null,{"$f":"ROUND(IF(AF42=0, IF(AD42=0, 0, 1), AD42/AF42),5)","v":1},null,125,null,125,null,{"$f":"ROUND((AL42-AN42),5)","v":0},null,{"$f":"ROUND(IF(AN42=0, IF(AL42=0, 0, 1), AL42/AN42),5)","v":1},null,125,null,125,null,{"$f":"ROUND((AT42-AV42),5)","v":0},null,{"$f":"ROUND(IF(AV42=0, IF(AT42=0, 0, 1), AT42/AV42),5)","v":1},null,100,null,125,null,{"$f":"ROUND((BB42-BD42),5)","v":-25},null,{"$f":"ROUND(IF(BD42=0, IF(BB42=0, 0, 1), BB42/BD42),5)","v":0.8},null,{"$f":"ROUND(F42+N42+V42+AD42+AL42+AT42+BB42,5)","v":850},null,{"$f":"ROUND(H42+P42+X42+AF42+AN42+AV42+BD42,5)","v":875},null,{"$f":"ROUND((BJ42-BL42),5)","v":-25},null,{"$f":"ROUND(IF(BL42=0, IF(BJ42=0, 0, 1), BJ42/BL42),5)","v":0.97143000000000002}]
[null,null,null,"70012 · Other Member Contributions",null,0,null,0,null,{"$f":"ROUND((F43-H43),5)","v":0},null,{"$f":"ROUND(IF(H43=0, IF(F43=0, 0, 1), F43/H43),5)","v":0},null,850,null,0,null,{"$f":"ROUND((N43-P43),5)","v":850},null,{"$f":"ROUND(IF(P43=0, IF(N43=0, 0, 1), N43/P43),5)","v":1},null,1200,null,0,null,{"$f":"ROUND((V43-X43),5)","v":1200},null,{"$f":"ROUND(IF(X43=0, IF(V43=0, 0, 1), V43/X43),5)","v":1},null,-85,null,0,null,{"$f":"ROUND((AD43-AF43),5)","v":-85},null,{"$f":"ROUND(IF(AF43=0, IF(AD43=0, 0, 1), AD43/AF43),5)","v":1},null,125475,null,81008,null,{"$f":"ROUND((AL43-AN43),5)","v":44467},null,{"$f":"ROUND(IF(AN43=0, IF(AL43=0, 0, 1), AL43/AN43),5)","v":1.5489200000000001},null,4450,null,0,null,{"$f":"ROUND((AT43-AV43),5)","v":4450},null,{"$f":"ROUND(IF(AV43=0, IF(AT43=0, 0, 1), AT43/AV43),5)","v":1},null,132,null,0,null,{"$f":"ROUND((BB43-BD43),5)","v":132},null,{"$f":"ROUND(IF(BD43=0, IF(BB43=0, 0, 1), BB43/BD43),5)","v":1},null,{"$f":"ROUND(F43+N43+V43+AD43+AL43+AT43+BB43,5)","v":132022},null,{"$f":"ROUND(H43+P43+X43+AF43+AN43+AV43+BD43,5)","v":81008},null,{"$f":"ROUND((BJ43-BL43),5)","v":51014},null,{"$f":"ROUND(IF(BL43=0, IF(BJ43=0, 0, 1), BJ43/BL43),5)","v":1.62974}]
[null,null,"Total Other Income",null,null,{"$f":"ROUND(SUM(F40:F43),5)","v":126},null,{"$f":"ROUND(SUM(H40:H43),5)","v":126},null,{"$f":"ROUND((F44-H44),5)","v":0},null,{"$f":"ROUND(IF(H44=0, IF(F44=0, 0, 1), F44/H44),5)","v":1},null,{"$f":"ROUND(SUM(N40:N43),5)","v":975},null,{"$f":"ROUND(SUM(P40:P43),5)","v":126},null,{"$f":"ROUND((N44-P44),5)","v":849},null,{"$f":"ROUND(IF(P44=0, IF(N44=0, 0, 1), N44/P44),5)","v":7.7381000000000002},null,{"$f":"ROUND(SUM(V40:V43),5)","v":1325},null,{"$f":"ROUND(SUM(X40:X43),5)","v":126},null,{"$f":"ROUND((V44-X44),5)","v":1199},null,{"$f":"ROUND(IF(X44=0, IF(V44=0, 0, 1), V44/X44),5)","v":10.51587},null,{"$f":"ROUND(SUM(AD40:AD43),5)","v":40},null,{"$f":"ROUND(SUM(AF40:AF43),5)","v":126},null,{"$f":"ROUND((AD44-AF44),5)","v":-86},null,{"$f":"ROUND(IF(AF44=0, IF(AD44=0, 0, 1), AD44/AF44),5)","v":0.31746000000000002},null,{"$f":"ROUND(SUM(AL40:AL43),5)","v":125600},null,{"$f":"ROUND(SUM(AN40:AN43),5)","v":81134},null,{"$f":"ROUND((AL44-AN44),5)","v":44466},null,{"$f":"ROUND(IF(AN44=0, IF(AL44=0, 0, 1), AL44/AN44),5)","v":1.54806},null,{"$f":"ROUND(SUM(AT40:AT43),5)","v":4576},null,{"$f":"ROUND(SUM(AV40:AV43),5)","v":126},null,{"$f":"ROUND((AT44-AV44),5)","v":4450},null,{"$f":"ROUND(IF(AV44=0, IF(AT44=0, 0, 1), AT44/AV44),5)","v":36.317459999999997},null,{"$f":"ROUND(SUM(BB40:BB43),5)","v":232},null,{"$f":"ROUND(SUM(BD40:BD43),5)","v":126},null,{"$f":"ROUND((BB44-BD44),5)","v":106},null,{"$f":"ROUND(IF(BD44=0, IF(BB44=0, 0, 1), BB44/BD44),5)","v":1.84127},null,{"$f":"ROUND(F44+N44+V44+AD44+AL44+AT44+BB44,5)","v":132874},null,{"$f":"ROUND(H44+P44+X44+AF44+AN44+AV44+BD44,5)","v":81890},null,{"$f":"ROUND((BJ44-BL44),5)","v":50984},null,{"$f":"ROUND(IF(BL44=0, IF(BJ44=0, 0, 1), BJ44/BL44),5)","v":1.62259}]
["Net Income (excluding depreciation)",null,null,null,null,{"$f":"ROUND(F38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(H38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND((F45-H45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(IF(H45=0, IF(F45=0, 0, 1), F45/H45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(N38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(P38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND((N45-P45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(IF(P45=0, IF(N45=0, 0, 1), N45/P45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(V38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(X38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND((V45-X45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(IF(X45=0, IF(V45=0, 0, 1), V45/X45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(AD38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(AF38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND((AD45-AF45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(IF(AF45=0, IF(AD45=0, 0, 1), AD45/AF45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(AL38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(AN38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND((AL45-AN45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(IF(AN45=0, IF(AL45=0, 0, 1), AL45/AN45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(AT38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(AV38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND((AT45-AV45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(IF(AV45=0, IF(AT45=0, 0, 1), AT45/AV45),5)","v":{"$error":"#REF!"}},null,{"$f":"BB38+BB44","v":-13696},null,{"$f":"BD38+BD44","v":8596},null,{"$f":"ROUND((BB45-BD45),5)","v":-22292},null,{"$f":"ROUND(IF(BD45=0, IF(BB45=0, 0, 1), BB45/BD45),5)","v":-1.5932999999999999},null,{"$f":"BJ38+BJ44","v":116803},null,{"$f":"BL38+BL44","v":6191},null,{"$f":"ROUND((BJ45-BL45),5)","v":110612},null,{"$f":"ROUND(IF(BL45=0, IF(BJ45=0, 0, 1), BJ45/BL45),5)","v":18.866579999999999}]

{"sheet":"YTD Rev by Type","index":1,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Events- Member",null,"Events- Member Referral & Other",null,"Events-Club",null,"Member Services",null,"TOTAL"]
[null,"Ordinary Income/Expense"]
[null,null,null,"Income"]
[null,null,null,null,"40000 · Member Dues and Fees",0,null,0,null,0,null,473200,null,{"$f":"ROUND(SUM(F4:L4),5)","v":473200}]
[null,null,null,null,"40100 · Meal Sales",117012,null,66334,null,98994,null,203527,null,{"$f":"ROUND(SUM(F5:L5),5)","v":485867}]
[null,null,null,null,"40200 · Beverage Sales",9355,null,6158,null,96,null,60020,null,{"$f":"ROUND(SUM(F6:L6),5)","v":75629}]
[null,null,null,null,"40300 · Service Fees",19089,null,6758,null,182,null,16792,null,{"$f":"ROUND(SUM(F7:L7),5)","v":42821}]
[null,null,null,null,"40400 · Rental Income",8457,null,11264,null,0,null,0,null,{"$f":"ROUND(SUM(F8:L8),5)","v":19721}]
[null,null,null,null,"40800 · Other Income",725,null,800,null,0,null,696,null,{"$f":"ROUND(SUM(F9:L9),5)","v":2221}]
[null,null,null,"Total Income",null,{"$f":"ROUND(SUM(F3:F9),5)","v":154638},null,{"$f":"ROUND(SUM(H3:H9),5)","v":91314},null,{"$f":"ROUND(SUM(J3:J9),5)","v":99272},null,{"$f":"ROUND(SUM(L3:L9),5)","v":754235},null,{"$f":"ROUND(SUM(F10:L10),5)","v":1099459}]
[null,null,"Prior Year Revenues",null,null,119887,null,99778,null,59065,null,625670,null,904400]
[null,null,"Change from Prior Year",null,null,{"$f":"F10-F11","v":34751},null,{"$f":"H10-H11","v":-8464},null,{"$f":"J10-J11","v":40207},null,{"$f":"L10-L11","v":128565},null,{"$f":"N10-N11","v":195059}]
[]
[null,null,"% of Total Revenues",null,null,{"$f":"F10/N10","v":0.14064917382094286},null,{"$f":"H10/N10","v":8.305357453074648E-2},null,{"$f":"J10/N10","v":9.0291679817073672E-2},null,{"$f":"L10/N10","v":0.686005571831237},null,1]

{"sheet":"July Rev by Type","index":2,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Events- Member",null,"Events- Member Referral & Other",null,"Events-Club",null,"Member Services",null,"TOTAL"]
[null,"Ordinary Income/Expense"]
[null,null,null,"Income"]
[null,null,null,null,"40000 · Member Dues and Fees",0,null,0,null,0,null,63550,null,{"$f":"ROUND(SUM(F4:L4),5)","v":63550}]
[null,null,null,null,"40100 · Meal Sales",14483,null,13149,null,17520,null,25545,null,{"$f":"ROUND(SUM(F5:L5),5)","v":70697}]
[null,null,null,null,"40200 · Beverage Sales",0,null,0,null,56,null,7827,null,{"$f":"ROUND(SUM(F6:L6),5)","v":7883}]
[null,null,null,null,"40300 · Service Fees",2813,null,0,null,0,null,3164,null,{"$f":"ROUND(SUM(F7:L7),5)","v":5977}]
[null,null,null,null,"40400 · Rental Income",0,null,1000,null,0,null,0,null,{"$f":"ROUND(SUM(F8:L8),5)","v":1000}]
[null,null,null,null,"40800 · Other Income",350,null,0,null,0,null,0,null,{"$f":"ROUND(SUM(F9:L9),5)","v":350}]
[null,null,null,"Total Income",null,{"$f":"ROUND(SUM(F3:F9),5)","v":17646},null,{"$f":"ROUND(SUM(H3:H9),5)","v":14149},null,{"$f":"ROUND(SUM(J3:J9),5)","v":17576},null,{"$f":"ROUND(SUM(L3:L9),5)","v":100086},null,{"$f":"ROUND(SUM(F10:L10),5)","v":149457}]
[null,null,"Prior Year Revenues",null,null,22401,null,54430,null,18308,null,116412,null,211551]
[null,null,"Change from Prior Year",null,null,{"$f":"F10-F11","v":-4755},null,{"$f":"H10-H11","v":-40281},null,{"$f":"J10-J11","v":-732},null,{"$f":"L10-L11","v":-16326},null,{"$f":"N10-N11","v":-62094}]
[]
[null,null,"% of Total Revenues",null,null,{"$f":"F10/N10","v":0.11806740400248901},null,{"$f":"H10/N10","v":9.466936978528942E-2},null,{"$f":"J10/N10","v":0.11759904186488421},null,{"$f":"L10/N10","v":0.66966418434733732},null,1]

{"sheet":"Balance Sheet","index":3,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Jul 31, 23",null,"Jul 31, 22",null,"$ Change",null,"% Change"]
["ASSETS"]
[null,"Current Assets"]
[null,null,"Checking/Savings",null,489787,null,271627,null,{"$f":"ROUND((E5-G5),5)","v":218160},null,{"$f":"ROUND(IF(E5=0, IF(G5=0, 0, SIGN(-G5)), IF(G5=0, SIGN(E5), (E5-G5)/ABS(G5))),5)","v":0.80315999999999999}]
[null,null,"Accounts Receivable",null,160530,null,317002,null,{"$f":"ROUND((E6-G6),5)","v":-156472},null,{"$f":"ROUND(IF(E6=0, IF(G6=0, 0, SIGN(-G6)), IF(G6=0, SIGN(E6), (E6-G6)/ABS(G6))),5)","v":-0.49359999999999998}]
[null,null,"Other Current Assets",null,92588,null,116699,null,{"$f":"ROUND((E7-G7),5)","v":-24111},null,{"$f":"ROUND(IF(E7=0, IF(G7=0, 0, SIGN(-G7)), IF(G7=0, SIGN(E7), (E7-G7)/ABS(G7))),5)","v":-0.20660999999999999}]
[null,"Total Current Assets",null,null,{"$f":"ROUND(SUM(E4:E7),5)","v":742905},null,{"$f":"ROUND(SUM(G4:G7),5)","v":705328},null,{"$f":"ROUND((E8-G8),5)","v":37577},null,{"$f":"ROUND(IF(E8=0, IF(G8=0, 0, SIGN(-G8)), IF(G8=0, SIGN(E8), (E8-G8)/ABS(G8))),5)","v":5.3280000000000001E-2}]
[null,"Fixed Assets",null,null,1052052,null,1059347,null,{"$f":"ROUND((E9-G9),5)","v":-7295},null,{"$f":"ROUND(IF(E9=0, IF(G9=0, 0, SIGN(-G9)), IF(G9=0, SIGN(E9), (E9-G9)/ABS(G9))),5)","v":-6.8900000000000003E-3}]
["TOTAL ASSETS",null,null,null,{"$f":"ROUND(E3+SUM(E8:E9),5)","v":1794957},null,{"$f":"ROUND(G3+SUM(G8:G9),5)","v":1764675},null,{"$f":"ROUND((E10-G10),5)","v":30282},null,{"$f":"ROUND(IF(E10=0, IF(G10=0, 0, SIGN(-G10)), IF(G10=0, SIGN(E10), (E10-G10)/ABS(G10))),5)","v":1.7160000000000002E-2}]
["LIABILITIES & EQUITY"]
[null,"Liabilities"]
[null,null,"Current Liabilities"]
[null,null,null,"Accounts Payable",34603,null,123972,null,{"$f":"ROUND((E14-G14),5)","v":-89369},null,{"$f":"ROUND(IF(E14=0, IF(G14=0, 0, SIGN(-G14)), IF(G14=0, SIGN(E14), (E14-G14)/ABS(G14))),5)","v":-0.72087999999999997}]
[null,null,null,"Other Current Liabilities",6237,null,20162,null,{"$f":"ROUND((E15-G15),5)","v":-13925},null,{"$f":"ROUND(IF(E15=0, IF(G15=0, 0, SIGN(-G15)), IF(G15=0, SIGN(E15), (E15-G15)/ABS(G15))),5)","v":-0.69066000000000005}]
[null,null,"Total Current Liabilities",null,{"$f":"ROUND(SUM(E13:E15),5)","v":40840},null,{"$f":"ROUND(SUM(G13:G15),5)","v":144134},null,{"$f":"ROUND((E16-G16),5)","v":-103294},null,{"$f":"ROUND(IF(E16=0, IF(G16=0, 0, SIGN(-G16)), IF(G16=0, SIGN(E16), (E16-G16)/ABS(G16))),5)","v":-0.71665000000000001}]
[null,"Total Liabilities",null,null,{"$f":"ROUND(E12+E16,5)","v":40840},null,{"$f":"ROUND(G12+G16,5)","v":144134},null,{"$f":"ROUND((E17-G17),5)","v":-103294},null,{"$f":"ROUND(IF(E17=0, IF(G17=0, 0, SIGN(-G17)), IF(G17=0, SIGN(E17), (E17-G17)/ABS(G17))),5)","v":-0.71665000000000001}]
[null,"Equity",null,null,1754117,null,1620542,null,{"$f":"ROUND((E18-G18),5)","v":133575},null,{"$f":"ROUND(IF(E18=0, IF(G18=0, 0, SIGN(-G18)), IF(G18=0, SIGN(E18), (E18-G18)/ABS(G18))),5)","v":8.2430000000000003E-2}]
["TOTAL LIABILITIES & EQUITY",null,null,null,{"$f":"ROUND(E11+SUM(E17:E18),5)","v":1794957},null,{"$f":"ROUND(G11+SUM(G17:G18),5)","v":1764676},null,{"$f":"ROUND((E19-G19),5)","v":30281},null,{"$f":"ROUND(IF(E19=0, IF(G19=0, 0, SIGN(-G19)), IF(G19=0, SIGN(E19), (E19-G19)/ABS(G19))),5)","v":1.7160000000000002E-2}]