{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Event Planning Checklist","Event Budget","Budgeted Expenses Worksheet","Gate Sheet","Event Report","Actual Expenses Worksheet","NMS"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":9,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Instructions","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[3,0,3,1],[4,0,4,1]]}
["SOCIETY FOR CREATIVE ANACHRONISM  INC."]
["EVENT PACKET INSTRUCTIONS"]
[]
["Note that all cells in Green are those to be filled in manually.  Pink cells have drop down menus, white cells will be automatically calculated.  Other formatting may happen depending on cell values."]
[]
["1.   ","On the Event Planning Checklist, enter the Event Name and Event Start Date.  Review the tasks and in the “Needed Task” column,  mark \"YES\" or \"NO\" for each from the drop-down menu.  Dates for each item must be done will be automatically calculated.  If it is not needed, that line item will fade out.  Note that as each item is done, and marked in that column, the formatting for that line item will change."]
["2.   ","On the Event Budget tab, enter the Event End Date, Event Stewards, estimated attendance, and appropriate fees in the green cells.  The total income will be automatically calculated."]
["3.   ","On the Budgeted Expenses worksheet, list all event expenses, quantity, and cost per item in the green cells of the appropriate category.  E.g. Item: porto-potties, Quantity: 2, Price/Item: $100, Total: $200.  Totals for each category align with the Exchequer’s Quarterly Reports, and will fill in on the Budget tab."]
["4.   ","Print the Event Budget tab and the Itemized Expenses Worksheet tab and submit to the Financial Committee for review, commentary, and approval."]
["5.    ","To complete the Event Report, add up total attendance for each fee category in the Income section, and list out any refunds for each fee category in the Refunds section.  In the Expenses section, if there are any variable costs based on attendance, enter that there.  "]
["6.    ","On the Actual Expenses worksheet, complete as on the Budgeted Expenses Worksheet, but with actual costs for all approved expenses.  These will automatically fill in on the Event Report in the Expenses section."]
["7.    ","On the Event Report tab, in the Reconciliation section, enter all funds received in the appropriate section.  Note the check to see if it balances.  In the Transfers section, select “YES” or “NO” if it a Kingdom Event, and note any groups and percentages if there is profit sharing.  The group’s profit will be calculated after all expenses are entered.  "]
["8.    ","Once the Event Report is completed, have it signed by the group’s Seneschal, Exchequer, and Autocrats.  It must be submitted to the Regional Exchequer within 30 days of the end of the event."]
["9.    ","To complete the NMS report, if a check is needed, enter the check number and amount in the green cells.  In the Approvals section, enter the local Exchequer’s contact information.  Print the NMS report, and mail with the check (that is made payable to: “SCA Inc, Middle Kingdom” to the NMS deputy by the due date on the report (14 days after the end of the event)."]

{"sheet":"Event Planning Checklist","index":1,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[30,0,30,1],[18,0,18,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[24,0,24,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[13,0,13,1],[14,0,14,1],[3,0,3,1],[5,0,5,1],[6,0,6,1],[15,0,15,1],[16,0,16,1],[11,0,11,1],[25,0,25,1],[12,0,12,1],[32,0,32,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[17,0,17,1],[31,0,31,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1]]}
["SOCIETY FOR CREATIVE ANACHRONISM, INC."]
["KINGDOM OF THE MIDDLE -EXCHEQUER'S EVENT CHECKLIST"]
[null,null,"today's date",{"$f":"TODAY()","v":"2017-08-31"}]
["Item",null,"Needed Task","Due Date","Done?","Notes"]
["Event Name:"]
["Event Bid Approval",null,"YES",{"$f":"IF(C6=\"YES\",$D$5-180,\"\")","v":-180},"NO"]
["Event Budget Approval",null,"YES",{"$f":"IF(C7=\"YES\",$D$5-180,\"\")","v":-180},"NO"]
["Feast Budget Approval",null,"YES",{"$f":"IF(C8=\"YES\",$D$5-90,\"\")","v":-90},"NO"]
["Lunch Budget Approval",null,"YES",{"$f":"IF(C9=\"YES\",$D$5-90,\"\")","v":-90},"NO"]
["Pale Ad Check issued #1",null,"YES",{"$f":"IF(C10=\"YES\",$D$5-70,\"\")","v":-70},"NO"]
["Feast Advance Issued",null,"YES",{"$f":"IF(C11=\"YES\",$D$5-60,\"\")","v":-60},"NO"]
["Lunch Advance Issued",null,"YES",{"$f":"IF(C12=\"YES\",$D$5-60,\"\")","v":-60},"NO"]
["Volunteer Page set up",null,"YES",{"$f":"IF(C13=\"YES\",$D$5-60,\"\")","v":-60},"NO"]
["Pale Ad Check issued #2",null,"YES",{"$f":"IF(C14=\"YES\",$D$5-40,\"\")","v":-40},"NO"]
["Certificate Of Insurance check issued",null,"YES",{"$f":"IF(C15=\"YES\",$D$5-30,\"\")","v":-30},"NO"]
["Equestrian COI check issued",null,"YES",{"$f":"IF(C16=\"YES\",$D$5-30,\"\")","v":-30},"NO"]
["Gate Class offered #2",null,"YES",{"$f":"IF(C17=\"YES\",$D$5-14,\"\")","v":-14},"NO"]
["Gate Class offered #1",null,"YES",{"$f":"IF(C18=\"YES\",$D$5-7,\"\")","v":-7},"NO"]
["Site tokens, feast tokens, maps, event booklet given to Gate Coordinator",null,"YES",-7,"NO"]
["Gate forms prepared and box given to Gate Coordinator",null,"YES",-7,"NO"]
["Gate Seed Issued",null,"YES",-7,"NO"]
["List of Comps submitted to Gate Coordinator",null,"YES",-7,"NO"]
["Lunch cash box seed Issued",null,"YES",-7,"NO"]
["Event Income deposited",null,"YES",{"$f":"IF(C24=\"YES\",$D$5+7,\"\")","v":"1900-01-07"},"NO"]
["Waivers given to Seneschal",null,"YES",{"$f":"IF(C25=\"YES\",$D$5+7,\"\")","v":"1900-01-07"},"NO"]
["NMS Check submitted",null,"YES",{"$f":"IF(C26=\"YES\",$D$5+14,\"\")","v":"1900-01-14"},"NO"]
["Event Report submitted",null,"YES",{"$f":"IF(C27=\"YES\",$D$5+30,\"\")","v":"1900-01-30"},"NO"]
["Profit Split Checks Issued",null,"YES",{"$f":"IF(C28=\"YES\",$D$5+30,\"\")","v":"1900-01-30"},"NO"]
["Security Fee Issued",null,"YES",null,"NO"]
["Site Deposit Issued",null,"YES",null,"NO"]
["Site Fee Issued",null,"YES",null,"NO"]
[null,null,"YES",null,"NO"]
[null,null,"YES",null,"NO"]
[null,null,"YES",null,"NO"]
[null,null,"YES",null,"NO"]
[null,null,"YES",null,"NO"]
[null,null,"YES",null,"NO"]
[null,null,"YES",null,"NO"]

{"sheet":"Event Budget","index":2,"n_rows":152,"n_cols":9,"rows_kept":152,"cut":false,"hidden":false,"merged":[[54,0,54,8],[29,1,29,8],[30,1,30,8],[31,1,31,8],[47,0,47,1],[33,0,33,2],[52,0,52,1],[39,4,39,7],[40,4,40,7],[34,4,34,6],[56,5,56,7],[57,5,57,7],[58,5,58,7],[59,5,59,7],[60,5,60,7],[60,3,60,4],[59,1,59,2],[56,1,56,2],[57,1,57,2],[0,0,0,8],[1,0,1,8],[55,1,55,2],[55,5,55,7],[3,1,3,8],[6,0,6,1],[4,1,4,4],[28,0,28,8],[22,0,22,8],[17,0,17,8],[7,0,7,8],[21,0,21,7],[26,0,26,7],[16,0,16,7],[35,4,35,6],[33,4,33,6],[20,0,20,1],[19,0,19,1],[13,0,13,1],[12,0,12,1],[11,0,11,1],[10,0,10,1],[8,0,8,1],[9,0,9,1],[150,4,150,8],[151,4,151,8],[51,0,51,1],[48,0,48,1],[53,0,53,1],[58,1,58,2],[145,4,145,8],[146,4,146,8],[147,4,147,8],[148,4,148,8],[149,4,149,8],[140,4,140,8],[141,4,141,8],[142,4,142,8],[143,4,143,8],[144,4,144,8],[135,4,135,8],[136,4,136,8],[137,4,137,8],[138,4,138,8],[139,4,139,8],[130,4,130,8],[131,4,131,8],[132,4,132,8],[133,4,133,8],[134,4,134,8],[125,4,125,8],[126,4,126,8],[127,4,127,8],[128,4,128,8],[129,4,129,8],[120,4,120,8],[121,4,121,8],[122,4,122,8],[123,4,123,8],[124,4,124,8],[115,4,115,8],[116,4,116,8],[117,4,117,8],[118,4,118,8],[119,4,119,8],[110,4,110,8],[111,4,111,8],[112,4,112,8],[113,4,113,8],[114,4,114,8],[105,4,105,8],[106,4,106,8],[107,4,107,8],[108,4,108,8],[109,4,109,8],[100,4,100,8],[101,4,101,8],[102,4,102,8],[103,4,103,8],[104,4,104,8],[95,4,95,8],[96,4,96,8],[97,4,97,8],[98,4,98,8],[99,4,99,8],[90,4,90,8],[91,4,91,8],[92,4,92,8],[93,4,93,8],[94,4,94,8],[85,4,85,8],[86,4,86,8],[87,4,87,8],[88,4,88,8],[89,4,89,8],[80,4,80,8],[81,4,81,8],[82,4,82,8],[83,4,83,8],[84,4,84,8],[75,4,75,8],[76,4,76,8],[77,4,77,8],[78,4,78,8],[79,4,79,8],[70,4,70,8],[71,4,71,8],[72,4,72,8],[73,4,73,8],[74,4,74,8],[65,4,65,8],[66,4,66,8],[67,4,67,8],[68,4,68,8],[69,4,69,8],[43,0,43,1],[42,0,42,1],[44,0,44,1],[23,0,23,1],[45,0,45,1],[24,0,24,1],[25,0,25,1],[50,0,50,1],[49,0,49,1],[60,1,60,2],[59,3,59,4],[58,3,58,4],[57,3,57,4],[55,3,55,4],[36,4,36,6],[37,4,37,6],[38,4,38,6],[46,0,46,1],[56,3,56,4],[14,0,14,1],[15,0,15,1],[18,0,18,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[32,0,32,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[27,0,27,7]]}
["SOCIETY FOR CREATIVE ANACHRONISM, INC."]
["KINGDOM OF THE MIDDLE - EVENT BUDGET REPORT"]
[]
["GROUP:","Group Name"]
["EVENT:",{"$f":"IF('Event Planning Checklist'!B5=\"\",\"\",'Event Planning Checklist'!B5)","v":""},null,null,null,"DATE:",{"$f":"IF('Event Planning Checklist'!D5=\"\",\"\",'Event Planning Checklist'!D5)","v":""},"to"]
[]
["INCOME",null,"Age","Pre-Reg Fee","# Reserve","Gate Fee","# at Gate","Total Attendance","Income"]
["Site Fees"]
["Adult - Whole weekend",{"$nulls":6},{"$f":"E9+G9","v":0},{"$f":"(D9*E9) +(F9*G9)","v":0}]
["Adult - One Day",{"$nulls":6},{"$f":"E10+G10","v":0},{"$f":"(D10*E10) +(F10*G10)","v":0}]
["Youth  - Whole Weekend",{"$nulls":6},{"$f":"E11+G11","v":0},{"$f":"(D11*E11) +(F11*G11)","v":0}]
["Youth - One Day ",{"$nulls":6},{"$f":"E12+G12","v":0},{"$f":"(D12*E12) +(F12*G12)","v":0}]
["Child - Whole Weekend",{"$nulls":6},0,0]
["Child - One Day",{"$nulls":6},{"$f":"E14+G14","v":0},{"$f":"(D14*E14) +(F14*G14)","v":0}]
["Family Max - Whole Weekend",{"$nulls":6},0,0]
["Family Max - One Day",{"$nulls":6},{"$f":"E16+G16","v":0},{"$f":"(D16*E16) +(F16*G16)","v":0}]
["Total Site Income",{"$nulls":7},{"$f":"SUM(I9:I15)","v":0}]
["Feast Fees"]
["Adult",{"$nulls":6},0,0]
["Youth",{"$nulls":6},0,0]
["Child",{"$nulls":6},{"$f":"E21+G21","v":0},{"$f":"(D21*E21) +(F21*G21)","v":0}]
["Total Feast Income",{"$nulls":7},{"$f":"SUM(I19:I21)","v":0}]
["Other Fees"]
["Camping",{"$nulls":6},0,0]
["Other Fee",{"$nulls":6},{"$f":"E25+G25","v":0},{"$f":"(D25*E25) +(F25*G25)","v":0}]
["Other Fee",{"$nulls":6},0,0]
[{"$nulls":8},{"$f":"SUM(I24:I26)","v":0}]
["Total Income",{"$nulls":7},{"$f":"SUM(I17+I22+I27)","v":0}]
["Who will attend Free? (What Guests, as per group and kingdom policy?)"]
["Free Site"]
["Free Feast"]
["Free Other"]
[]
["EXPENSES (from Itemized Expenses Worksheet)",null,null,null,"Profit Splits (automatically calculated)",null,null,"Kingdom event?","YES"]
["Non-SCA Advertising",null,{"$f":"'Budgeted Expenses Worksheet'!F8","v":0},null,"Group",null,null,"% profit","Profit Split"]
["Equipment Rental and Maintenance",null,{"$f":"'Budgeted Expenses Worksheet'!F14","v":0},null,"SCA Inc, Middle Kingdom",null,null,{"$f":"IF(I34=\"yes\",0.5,0)","v":0.5},{"$f":"H36*(I28-C53)","v":0}]
["Fees and Honoraria",null,{"$f":"'Budgeted Expenses Worksheet'!F20","v":0},null,"Group Name",null,null,0,{"$f":"H37*(I28-C53)","v":0}]
["Food",null,{"$f":"'Budgeted Expenses Worksheet'!F26","v":0},null,"Group Name",null,null,0,{"$f":"H38*(I28-C53)","v":0}]
["General supplies",null,{"$f":"'Budgeted Expenses Worksheet'!F32","v":0},null,"Group Name",null,null,0,{"$f":"H39*(I28-C53)","v":0}]
["Insurance",null,{"$f":"'Budgeted Expenses Worksheet'!F38","v":0},null,"Total Transfers",null,null,null,{"$f":"SUM(I36:I39)","v":0}]
["Occupancy and Site Charges",null,{"$f":"'Budgeted Expenses Worksheet'!F44","v":0},null,"Gross Profit",null,null,null,{"$f":"SUM(I28-C53-I40)","v":0}]
["Postage, Shipping, PO Box rental",null,{"$f":"'Budgeted Expenses Worksheet'!F50","v":0}]
["Printing and Publications",null,{"$f":"'Budgeted Expenses Worksheet'!F56","v":0}]
["Telephone",null,{"$f":"'Budgeted Expenses Worksheet'!F62","v":0}]
["Travel",null,{"$f":"'Budgeted Expenses Worksheet'!F68","v":0}]
["SCA insurance",null,{"$f":"'Budgeted Expenses Worksheet'!F74","v":0}]
["Transfer Within Kingdom",null,{"$f":"'Budgeted Expenses Worksheet'!F86","v":0}]
["Transfer Outside Kingdom",null,{"$f":"'Budgeted Expenses Worksheet'!F92","v":0}]
[null,null,"Variable Costs"]
["Occupancy-per adult",null,0]
["Occupancy-per youth",null,0]
["Occupancy-per child",null,0]
["Total Expenses",null,{"$f":"SUM(C35:D52)","v":0}]
[]
["Approval"]
[null,"SCA Name",null,"Legal Name",null,"Signature",null,null,"Date"]
["Seneschal"]
["Exchequer"]
["Event Steward 1"]
["Event Steward 2"]
["Event Steward 3"]
[]
[]
[]
[{"$nulls":4},"Group Name"]
[{"$nulls":4},"SCA Illinois Inc, Applicant Canton of Elv Av Tiden"]
[{"$nulls":4},"SCA Illinois Inc, Barony of Ayreton"]
[{"$nulls":4},"SCA Illinois Inc, Barony of Carraig Ban"]
[{"$nulls":4},"SCA Illinois Inc, Barony of Illiton"]
[{"$nulls":4},"SCA Illinois Inc, Barony of Shattered Crystal"]
[{"$nulls":4},"SCA Illinois Inc, Canton of Foxvale"]
[{"$nulls":4},"SCA Illinois Inc, Canton of Grey Gargoyles"]
[{"$nulls":4},"SCA Illinois Inc, Canton of Lochmorrow"]
[{"$nulls":4},"SCA Illinois Inc, Canton of Rokkehealden"]
[{"$nulls":4},"SCA Illinois Inc, Canton of Tree-Girt-Sea"]
[{"$nulls":4},"SCA Illinois Inc, Canton of Vanished Wood"]
[{"$nulls":4},"SCA Illinois Inc, College of Saint Carol on the Moor"]
[{"$nulls":4},"SCA Illinois Inc, Incipient Canton of Athelington"]
[{"$nulls":4},"SCA Illinois Inc, Shire of Baile na Scolairi"]
[{"$nulls":4},"SCA Illinois Inc, Shire of Blackhawk"]
[{"$nulls":4},"SCA Illinois Inc, Shire of Dark River"]
[{"$nulls":4},"SCA Illinois Inc, Shire of Ravenslake"]
[{"$nulls":4},"SCA Illinois Inc, Shire of Swordcliff"]
[{"$nulls":4},"SCA Illinois Inc, Shire of Wurm Wald"]
[{"$nulls":4},"SCA Inc, Applicant Canton of Gray Ridge"]
[{"$nulls":4},"SCA Inc, Barony of Brendoken"]
[{"$nulls":4},"SCA Inc, Barony of Cleftlands"]
[{"$nulls":4},"SCA Inc, Barony of Fenix"]
[{"$nulls":4},"SCA Inc, Barony of Flame"]
[{"$nulls":4},"SCA Inc, Barony of Flaming Gryphon"]
[{"$nulls":4},"SCA Inc, Barony of Middle Marches"]
[{"$nulls":4},"SCA Inc, Barony of Red Spears"]
[{"$nulls":4},"SCA Inc, Barony of Rivenstar"]
[{"$nulls":4},"SCA Inc, Barony of Sternfeld"]
[{"$nulls":4},"SCA Inc, Barony of White Waters"]
[{"$nulls":4},"SCA Inc, Canton of Border Keep"]
[{"$nulls":4},"SCA Inc, Canton of Catteden"]
[{"$nulls":4},"SCA Inc, Canton of Hawkes Keye"]
[{"$nulls":4},"SCA Inc, Canton of Hroogeirsfjordr"]
[{"$nulls":4},"SCA Inc, Canton of Unicorn"]
[{"$nulls":4},"SCA Inc, Canton of Winged Hills"]
[{"$nulls":4},"SCA Inc, Incipient Canton of Ath Dreagain"]
[{"$nulls":4},"SCA Inc, Marche of Alderford"]
[{"$nulls":4},"SCA Inc, Marche of Gwyntarian"]
[{"$nulls":4},"SCA Inc, Marche of Havenholde"]
[{"$nulls":4},"SCA Inc, Marche of Marshes"]
[{"$nulls":4},"SCA Inc, Marche of Norborough"]
[{"$nulls":4},"SCA Inc, Marche of Thistle"]
[{"$nulls":4},"SCA Inc, Marche of Three Towers"]
[{"$nulls":4},"SCA Inc, Middle Kingdom"]
[{"$nulls":4},"SCA Inc, MK College of Heralds"]
[{"$nulls":4},"SCA Inc, Shire of Afonlyn"]
[{"$nulls":4},"SCA Inc, Shire of Aurea Ripae"]
[{"$nulls":4},"SCA Inc, Shire of Castell Gwent"]
[{"$nulls":4},"SCA Inc, Shire of Cuil Choluim"]
[{"$nulls":4},"SCA Inc, Shire of Dernehealde"]
[{"$nulls":4},"SCA Inc, Shire of Dragon's Vale"]
[{"$nulls":4},"SCA Inc, Shire of Dragonsmark"]
[{"$nulls":4},"SCA Inc, Shire of Eastwatch"]
[{"$nulls":4},"SCA Inc, Shire of Falcon's Quarry"]
[{"$nulls":4},"SCA Inc, Shire of Greyhope"]
[{"$nulls":4},"SCA Inc, Shire of Mugmort"]
[{"$nulls":4},"SCA Inc, Shire of Mynydd Seren"]
[{"$nulls":4},"SCA Inc, Shire of Narrental"]
[{"$nulls":4},"SCA Inc, Shire of Oakford"]
[{"$nulls":4},"SCA Inc, Shire of Qal`at Ja`far"]
[{"$nulls":4},"SCA Inc, Shire of Rivenvale"]
[{"$nulls":4},"SCA Inc, Shire of Riviere Constelle"]
[{"$nulls":4},"SCA Inc, Shire of Shadowed Stars"]
[{"$nulls":4},"SCA Inc, Shire of Starleaf Gate"]
[{"$nulls":4},"SCA Inc, Shire of Steren Codha"]
[{"$nulls":4},"SCA Inc, Shire of Tirnewydd"]
[{"$nulls":4},"SCA Michigan Inc, Barony of Andelcrag"]
[{"$nulls":4},"SCA Michigan Inc, Barony of Cynnabar"]
[{"$nulls":4},"SCA Michigan Inc, Barony of Donnershafen"]
[{"$nulls":4},"SCA Michigan Inc, Barony of Northwoods"]
[{"$nulls":4},"SCA Michigan Inc, Barony of Roaring Wastes"]
[{"$nulls":4},"SCA Michigan Inc, Canton of Brackendelve"]
[{"$nulls":4},"SCA Michigan Inc, Canton of Dun Traigh"]
[{"$nulls":4},"SCA Michigan Inc, Canton of Ealdnordwuda"]
[{"$nulls":4},"SCA Michigan Inc, Canton of Rimsholt"]
[{"$nulls":4},"SCA Michigan Inc, Canton of Three Hills"]
[{"$nulls":4},"SCA Michigan Inc, Canton of Three Walls"]
[{"$nulls":4},"SCA Michigan Inc, Canton of Westmere"]
[{"$nulls":4},"SCA Michigan Inc, Incipient Canton of Iron Oak"]
[{"$nulls":4},"SCA Michigan Inc, Incipient Canton of Northgate"]
[{"$nulls":4},"SCA Michigan Inc, Incipient Canton of Weldlake"]
[{"$nulls":4},"SCA Michigan Inc, Riding of Hawkland Moor"]
[{"$nulls":4},"SCA Michigan Inc, Shire of Altenberg"]
[{"$nulls":4},"SCA Michigan Inc, Shire of Fearann na Criche"]
[{"$nulls":4},"SCA Michigan Inc, Shire of Stormvale"]
[{"$nulls":4},"SCA Michigan Inc, Shire of Talonvale"]

{"sheet":"Budgeted Expenses Worksheet","index":3,"n_rows":93,"n_cols":6,"rows_kept":93,"cut":false,"hidden":false,"merged":[[49,2,49,3],[55,2,55,3],[61,2,61,3],[67,2,67,3],[73,2,73,3],[19,2,19,3],[25,2,25,3],[31,2,31,3],[37,2,37,3],[43,2,43,3],[13,0,13,1],[0,0,0,5],[1,0,1,1],[2,0,6,1],[7,0,7,1],[8,0,12,1],[7,2,7,3],[13,2,13,3],[49,0,49,1],[14,0,18,1],[19,0,19,1],[20,0,24,1],[25,0,25,1],[26,0,30,1],[31,0,31,1],[32,0,36,1],[37,0,37,1],[38,0,42,1],[43,0,43,1],[44,0,48,1],[50,0,54,1],[55,0,55,1],[56,0,60,1],[61,0,61,1],[68,0,72,1],[92,0,92,4],[62,0,66,1],[67,0,67,1],[74,0,78,1],[79,0,79,1],[80,0,91,0],[80,1,85,1],[86,1,91,1],[73,0,73,1],[79,2,79,3],[85,2,85,3],[91,2,91,3]]}
["ITEMIZED EXPENSES:"]
["EXPENSES",null,"Description","Quantity","Price / Item","Budget Total"]
["Non-SCA Advertising",{"$nulls":4},{"$f":"SUM(D3*E3)","v":0}]
[{"$nulls":5},{"$f":"SUM(D4*E4)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F3:F7)","v":0}]
["Equipment Rental & Maintenance",{"$nulls":4},{"$f":"SUM(D9*E9)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F9:F13)","v":0}]
["Fees & Honoraria",{"$nulls":4},{"$f":"SUM(D15*E15)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F15:F19)","v":0}]
["Food",{"$nulls":4},{"$f":"SUM(D21*E21)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F21:F25)","v":0}]
["General Supplies",{"$nulls":4},{"$f":"SUM(D27*E27)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F27:F31)","v":0}]
["Insurance (NON-SCA)",{"$nulls":4},{"$f":"SUM(D33*E33)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F33:F37)","v":0}]
["Occupancy & Site Charges",{"$nulls":4},{"$f":"SUM(D39*E39)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F39:F43)","v":0}]
["Postage & Shipping, PO Box Rental",{"$nulls":4},{"$f":"SUM(D45*E45)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F45:F49)","v":0}]
["Printing & Publications",{"$nulls":4},{"$f":"SUM(D51*E51)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F51:F55)","v":0}]
["Telephone",{"$nulls":4},{"$f":"SUM(D57*E57)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F57:F61)","v":0}]
["Travel (Gas, Tolls, Airfare)",{"$nulls":4},{"$f":"SUM(D63*E63)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F63:F67)","v":0}]
["SCA Insurance",null,"Named Insurance Certificate:",null,null,{"$f":"SUM(D69*E69)","v":0}]
[null,null,"Equestrian Named Insurance Certificate:",null,null,0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F69:F73)","v":0}]
["Donations to Other 501(c)(3) [Nonprofit] Organizations  ",{"$nulls":4},{"$f":"SUM(D75*E75)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F75:F79)","v":0}]
["Transfer to Another SCA Account  \n(Expenses such as NMS, ACCEPS Fees, etc…)","WITHIN KINGDOM \n(such as the Pale Ad)","Pale Ad",null,null,{"$f":"SUM(D81*E81)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F81:F85)","v":0}]
[null,"OUTSIDE KINGDOM\n(such as ACCEPS)","ACCEPS Registration",null,null,{"$f":"SUM(D87*E87)","v":0}]
[{"$nulls":5},{"$f":"SUM(D88*E88)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F87:F91)","v":0}]
["Total ESTIMATED Expenses",{"$nulls":4},{"$f":"SUM(F8+F14+F20+F26+F32+F38+F44+F50+F56+F62+F68+F74+F80+F86+F92)","v":0}]

{"sheet":"Gate Sheet","index":4,"n_rows":62,"n_cols":35,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,9,0,30],[9,22,13,22],[9,23,13,23],[9,24,13,24],[9,25,13,25],[9,26,13,26],[9,27,13,27],[9,28,13,28],[9,29,13,29],[9,30,13,30],[2,28,8,28],[7,27,8,27],[2,29,6,29],[2,30,8,30],[7,29,8,29],[2,22,8,22],[7,21,8,21],[2,23,6,23],[2,24,8,24],[7,23,8,23],[2,25,6,25],[2,26,8,26],[7,25,8,25],[59,0,61,0],[59,1,61,1],[59,2,61,2],[59,3,61,3],[59,4,61,4],[55,0,57,0],[9,11,13,11],[9,12,13,12],[9,13,13,13],[59,12,61,12],[43,11,46,11],[43,12,45,12],[43,13,46,13],[57,10,61,10],[49,10,50,10],[47,10,48,10],[47,9,48,9],[49,9,50,9],[57,9,61,9],[18,7,21,7],[34,9,41,10],[51,3,53,3],[30,2,33,2],[30,1,33,1],[14,28,33,28],[14,29,33,29],[14,30,33,30],[9,19,13,19],[9,20,13,20],[9,21,13,21],[55,1,57,1],[55,2,57,2],[55,3,57,3],[55,4,57,4],[9,14,13,14],[9,15,13,15],[9,16,13,16],[9,17,13,17],[9,18,13,18],[43,14,45,14],[14,19,33,19],[14,20,33,20],[14,21,33,21],[14,22,33,22],[14,23,33,23],[14,24,33,24],[14,25,33,25],[14,26,33,26],[14,27,33,27],[34,7,42,7],[14,11,33,11],[14,12,33,12],[14,13,33,13],[14,14,33,14],[14,15,33,15],[14,16,33,16],[14,17,33,17],[14,18,33,18],[35,25,37,25],[35,26,37,26],[35,27,37,27],[2,15,6,15],[2,27,6,27],[2,16,8,16],[7,15,8,15],[2,17,6,17],[2,18,8,18],[7,17,8,17],[2,19,6,19],[2,20,8,20],[7,19,8,19],[2,21,6,21],[38,31,41,32],[47,31,48,32],[49,31,50,32],[57,31,58,32],[53,31,54,32],[55,31,56,32],[44,0,46,0],[44,1,46,1],[44,2,46,2],[44,3,46,3],[44,4,46,4],[39,30,41,30],[39,21,41,21],[39,22,41,22],[39,23,41,23],[39,24,41,24],[43,30,45,30],[43,29,46,29],[43,27,46,27],[43,28,45,28],[43,24,45,24],[43,25,46,25],[43,26,45,26],[34,5,42,5],[39,29,41,29],[39,19,41,19],[39,20,41,20],[1,0,23,0],[2,10,8,10],[10,6,13,6],[14,6,17,6],[18,6,21,6],[10,7,13,7],[10,4,13,4],[10,5,13,5],[6,4,9,4],[6,5,9,5],[6,6,9,6],[6,7,9,7],[9,9,13,10],[14,4,17,4],[14,5,17,5],[14,7,17,7],[14,9,33,9],[14,10,33,10],[18,4,21,4],[18,5,21,5],[7,9,8,9],[5,33,55,34],[47,0,49,0],[47,1,49,1],[47,2,49,2],[47,4,49,4],[47,3,49,3],[55,9,56,9],[55,10,56,10],[51,0,53,0],[51,1,53,1],[51,2,53,2],[51,4,53,4],[24,0,33,0],[1,2,29,2],[39,11,41,11],[39,12,41,12],[39,13,41,13],[39,14,41,14],[39,15,41,15],[39,16,41,16],[39,17,41,17],[39,18,41,18],[39,25,41,25],[39,26,41,26],[51,31,52,32],[47,5,49,5],[51,5,53,5],[55,5,57,5],[59,5,61,5],[44,5,46,5],[47,6,49,6],[51,6,53,6],[55,6,57,6],[59,6,61,6],[51,10,52,10],[60,11,61,11],[53,9,54,9],[53,10,54,10],[59,20,61,20],[59,22,61,22],[59,24,61,24],[59,26,61,26],[59,28,61,28],[59,30,61,30],[44,7,61,7],[42,31,46,32],[34,6,42,6],[35,24,37,24],[56,33,58,33],[56,34,58,34],[60,25,61,25],[60,27,61,27],[60,29,61,29],[60,13,61,13],[60,15,61,15],[60,17,61,17],[60,19,61,19],[60,21,61,21],[60,23,61,23],[59,34,61,34],[59,14,61,14],[59,16,61,16],[59,18,61,18],[39,28,41,28],[2,4,5,4],[2,5,5,5],[2,6,5,6],[2,7,5,7],[26,4,29,4],[26,5,29,5],[26,6,29,6],[26,7,29,7],[30,4,33,4],[30,5,33,5],[30,6,33,6],[30,7,33,7],[22,4,25,4],[22,5,25,5],[22,6,25,6],[22,7,25,7],[2,9,6,9],[2,11,6,11],[2,12,8,12],[7,11,8,11],[2,13,6,13],[2,14,8,14],[7,13,8,13],[43,16,45,16],[43,17,46,17],[43,18,45,18],[43,19,46,19],[43,20,45,20],[43,21,46,21],[43,22,45,22],[43,23,46,23],[39,27,41,27],[1,1,13,1],[14,1,16,1],[17,1,29,1],[4,31,14,32],[42,10,46,10],[42,9,46,9],[34,31,37,32],[35,30,37,30],[35,29,37,29],[35,11,37,11],[35,12,37,12],[35,13,37,13],[35,14,37,14],[35,15,37,15],[35,16,37,16],[35,17,37,17],[35,18,37,18],[35,19,37,19],[35,20,37,20],[35,21,37,21],[35,22,37,22],[35,23,37,23],[35,28,37,28],[43,15,46,15]]}
["Shift:"]
[{"$f":"IF('Event Budget'!B4=\"\",\"\",'Event Budget'!B4)","v":"Group Name"},{"$f":"IF('Event Budget'!I5=\"\",\"\",'Event Budget'!I5)","v":""},{"$f":"IF('Event Budget'!B5=\"\",\"\",'Event Budget'!B5)","v":""}]
[{"$nulls":4},{"$f":"IF('Event Budget'!A26=\"\",\"\",'Event Budget'!A26)","v":"Other Fee"},{"$f":"IF('Event Budget'!F26=\"\",\"\",'Event Budget'!F26)","v":""},null,null,null,"(if under 18) &","Parent/Guardian Name",{"$nulls":20},"Form for use within the Middle Kingdom\nRevised July 2013"]
[]
[{"$nulls":31},"For use within the Middle Kingdom\nRevised June 2014"]
[{"$nulls":33},"SCA Inc, Middle Kingdom Gate Sign-in Sheet"]
[{"$nulls":4},{"$f":"IF('Event Budget'!A25=\"\",\"\",'Event Budget'!A25)","v":"Other Fee"},{"$f":"IF('Event Budget'!F25=\"\",\"\",'Event Budget'!F25)","v":""}]
[{"$nulls":9},"Age"]
[{"$nulls":5},{"$f":"'Event Budget'!F22","v":0}]
[{"$nulls":9},"Branch"]
[{"$nulls":4},{"$f":"IF('Event Budget'!A24=\"\",\"\",'Event Budget'!A24)","v":"Camping"},{"$f":"IF('Event Budget'!F24=\"\",\"\",'Event Budget'!F24)","v":""}]
[]
[{"$nulls":5},{"$f":"'Event Budget'!F26","v":0}]
[]
[null,"-",null,null,"Family Max",{"$f":"IF('Event Budget'!F16=\"\",\"\",'Event Budget'!F16)","v":""},{"$f":"IF('Event Budget'!F15=\"\",\"\",'Event Budget'!F15)","v":""},null,null,"SCA Name","Legal Name","SCA Name","Legal Name","SCA Name","Legal Name","SCA Name","Legal Name","SCA Name","Legal Name","SCA Name","Legal Name","SCA Name","Legal Name","SCA Name","Legal Name","SCA Name","Legal Name","SCA Name","Legal Name","SCA Name","Legal Name"]
[]
[]
[null,{"$f":"IF('Event Budget'!G5=\"\",\"\",'Event Budget'!G5)","v":""}]
[{"$nulls":4},"5 & Under","Free","Free","Free"]
[]
[]
[]
[{"$nulls":4},{"$f":"IF('Event Budget'!C13=\"\",\"\",'Event Budget'!C13)","v":""},{"$f":"IF('Event Budget'!F14=\"\",\"\",'Event Budget'!F14)","v":""},{"$f":"IF('Event Budget'!F13=\"\",\"\",'Event Budget'!F13)","v":""},{"$f":"IF('Event Budget'!F21=\"\",\"\",'Event Budget'!F21)","v":""}]
[]
["MAKE CHECKS PAYABLE TO:"]
[]
[{"$nulls":4},{"$f":"IF('Event Budget'!C11=\"\",\"\",'Event Budget'!C11)","v":""},{"$f":"IF('Event Budget'!F12=\"\",\"\",'Event Budget'!F12)","v":""},{"$f":"IF('Event Budget'!F11=\"\",\"\",'Event Budget'!F11)","v":""},{"$f":"IF('Event Budget'!F20=\"\",\"\",'Event Budget'!F20)","v":""}]
[]
[]
[]
[null,"Date:","Event:",null,"Adult",{"$f":"IF('Event Budget'!F10=\"\",\"\",'Event Budget'!F10)","v":""},{"$f":"IF('Event Budget'!F9=\"\",\"\",'Event Budget'!F9)","v":""},{"$f":"IF('Event Budget'!F19=\"\",\"\",'Event Budget'!F19)","v":""}]
[]
[]
[]
[{"$nulls":5},"Site - One Day","Site - Whole Weekend","Feast:",null,"Column Totals",null,"o","o","o","o","o","o","o","o","o","o","o","o","o","o","o","o","o","o","o","o","Notorized Minor \nMedicalAuth?"]
[{"$nulls":11},"N/A","Yes","N/A","Yes","N/A","Yes","N/A","Yes","N/A","Yes","N/A","Yes","N/A","Yes","N/A","Yes","N/A","Yes","N/A","Yes"]
[]
[]
[{"$nulls":11},"o","o","o","o","o","o","o","o","o","o","o","o","o","o","o","o","o","o","o","o","Blue Card \nor Waiver"]
[{"$nulls":11},"Waiver","Blue Card","Waiver","Blue Card","Waiver","Blue Card","Waiver","Blue Card","Waiver","Blue Card","Waiver","Blue Card","Waiver","Blue Card","Waiver","Blue Card","Waiver","Blue Card","Waiver","Blue Card"]
[]
[]
[{"$nulls":9},"at $5 = $_____","#NMS ______","o","#","o","#","o","#","o","#","o","#","o","#","o","#","o","#","o","#","o","#","Member # \nor NMS"]
[{"$nulls":11},"NMS  $5",null,"NMS  $5",null,"NMS  $5",null,"NMS  $5",null,"NMS  $5",null,"NMS  $5",null,"NMS  $5",null,"NMS  $5",null,"NMS  $5",null,"NMS  $5"]
["Other","Other","Camping","Feast","Site","Site",null,"Totals for this page"]
[]
[]
[{"$nulls":6},"# Adults",null,null,"$","Site",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$","Site"]
[]
[{"$nulls":9},"$","Feast",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$","Feast "]
[]
[{"$nulls":6},{"$f":"'Event Budget'!D14","v":0},null,null,"$","None",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",{"$f":"IF('Event Budget'!A24=\"\",\"\",'Event Budget'!A24)","v":"Camping"}]
[]
[{"$nulls":9},"$","None",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",{"$f":"IF('Event Budget'!A25=\"\",\"\",'Event Budget'!A25)","v":"Other Fee"}]
[]
[{"$nulls":6},{"$f":"'Event Budget'!D17","v":0},null,null,"$","None",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",{"$f":"IF('Event Budget'!A26=\"\",\"\",'Event Budget'!A26)","v":"Other Fee"}]
[{"$nulls":33},"Page","Book"]
[{"$nulls":9},"$","Total",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$",null,"$","Total"]
[]
[{"$nulls":6},"5 & Under",{"$nulls":4},"o","Ck#","o","Ck#","o","Ck#","o","Ck#","o","Ck#","o","Ck#","o","Ck#","o","Ck#","o","Ck#","o","Ck#",null,null,"_____","_________"]
[{"$nulls":11},"Cash",null,"Cash",null,"Cash",null,"Cash",null,"Cash",null,"Cash",null,"Cash",null,"Cash",null,"Cash",null,"Cash",null,null,null,"of"]
[{"$nulls":33},"_____"]

{"sheet":"Event Report","index":5,"n_rows":86,"n_cols":12,"rows_kept":86,"cut":false,"hidden":false,"merged":[[70,5,70,8],[71,5,71,9],[72,5,72,9],[63,0,63,2],[64,0,64,2],[65,0,65,2],[66,0,66,2],[51,0,51,1],[66,10,66,11],[66,5,66,9],[67,5,67,11],[57,5,57,9],[58,5,58,9],[59,5,59,9],[60,5,60,9],[61,5,61,9],[62,5,62,9],[63,5,63,9],[64,5,64,9],[52,0,52,1],[75,0,75,2],[76,0,76,2],[77,0,77,2],[41,0,41,1],[70,0,70,2],[71,0,71,2],[62,0,62,2],[79,0,79,11],[56,0,56,11],[68,5,68,11],[69,5,69,11],[65,5,65,11],[78,0,78,11],[54,0,54,10],[55,0,55,10],[73,0,73,3],[58,0,58,2],[59,0,59,2],[60,0,60,2],[67,0,67,2],[68,0,68,2],[69,0,69,2],[70,9,70,10],[72,0,72,2],[73,5,73,9],[74,5,74,9],[75,5,75,9],[77,5,77,9],[76,5,76,9],[82,1,82,4],[83,1,83,4],[84,1,84,4],[85,1,85,4],[80,5,80,7],[80,8,80,10],[81,5,81,7],[81,8,81,10],[82,5,82,7],[82,8,82,10],[83,5,83,7],[83,8,83,10],[84,5,84,7],[84,8,84,10],[85,5,85,7],[85,8,85,10],[80,1,80,4],[81,1,81,4],[74,0,74,2],[8,0,8,11],[18,0,18,11],[23,0,23,11],[33,0,33,11],[43,0,43,11],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[15,0,15,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,3],[26,0,26,1],[24,0,24,1],[25,0,25,1],[17,0,17,3],[9,0,9,1],[10,0,10,1],[29,0,29,10],[30,0,30,5],[30,7,30,8],[16,0,16,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[27,0,27,1],[32,0,32,1],[34,0,34,1],[35,0,35,1],[31,0,31,11],[49,0,49,1],[50,0,50,1],[61,0,61,2],[28,0,28,3],[53,0,53,3],[48,0,48,11],[46,0,46,1],[44,0,44,1],[45,0,45,1],[47,0,47,3],[42,0,42,3],[57,0,57,3],[4,1,4,4],[7,0,7,1],[3,1,3,11],[0,0,0,11],[1,0,1,11],[4,6,4,7],[4,9,4,10],[5,8,5,9],[5,0,5,5],[5,6,5,7]]}
["SOCIETY FOR CREATIVE ANACHRONISM, INC."]
["KINGDOM OF THE MIDDLE - FINAL EVENT REPORT"]
[]
["GROUP:",{"$f":"IF('Event Budget'!B4=\"\",\"\",'Event Budget'!B4)","v":"Group Name"}]
["EVENT:",{"$f":"IF('Event Budget'!B5=\"\",\"\",'Event Budget'!B5)","v":""},null,null,null,"DATE:",{"$f":"IF('Event Budget'!G5=\"\",\"\",'Event Budget'!G5)","v":""},null,"to",{"$f":"IF('Event Budget'!I5=\"\",\"\",'Event Budget'!I5)","v":""}]
["Due 30 days after the close of the event",{"$nulls":5},"Due Date:",null,{"$f":"IF('Event Budget'!I5=\"\",\"\",'Event Budget'!I5+30)","v":""}]
[]
["INCOME",null,"Age","Pre-Reg \nFee","# \nACCEPS","# \nMail-In","Pre-reg\nTotals","Gate\nFee","# at \nGate","Gate \nTotals","Total \nAttendance","Total \nIncome"]
["Site Fees"]
[{"$f":"'Event Budget'!A9","v":"Adult - Whole weekend"},null,{"$f":"'Event Budget'!C9","v":0},{"$f":"'Event Budget'!D9","v":0},null,null,{"$f":"SUM(E10+F10)*D10","v":0},{"$f":"'Event Budget'!F9","v":0},null,{"$f":"SUM(H10*I10)","v":0},{"$f":"E10+F10+I10","v":0},{"$f":"SUM(G10+J10)","v":0}]
[{"$f":"'Event Budget'!A10","v":"Adult - One Day"},null,{"$f":"'Event Budget'!C10","v":0},{"$f":"'Event Budget'!D10","v":0},null,null,0,{"$f":"'Event Budget'!F10","v":0},null,{"$f":"SUM(H11*I11)","v":0},{"$f":"E11+F11+I11","v":0},0]
[{"$f":"'Event Budget'!A11","v":"Youth  - Whole Weekend"},null,{"$f":"'Event Budget'!C11","v":0},{"$f":"'Event Budget'!D11","v":0},null,null,0,{"$f":"'Event Budget'!F11","v":0},null,0,0,0]
[{"$f":"'Event Budget'!A12","v":"Youth - One Day "},null,{"$f":"'Event Budget'!C12","v":0},{"$f":"'Event Budget'!D12","v":0},null,null,0,{"$f":"'Event Budget'!F12","v":0},null,0,0,0]
[{"$f":"'Event Budget'!A13","v":"Child - Whole Weekend"},null,{"$f":"'Event Budget'!C13","v":0},{"$f":"'Event Budget'!D13","v":0},null,null,0,{"$f":"'Event Budget'!F13","v":0},null,0,0,0]
[{"$f":"'Event Budget'!A14","v":"Child - One Day"},null,{"$f":"'Event Budget'!C14","v":0},{"$f":"'Event Budget'!D14","v":0},null,null,0,{"$f":"'Event Budget'!F14","v":0},null,0,0,0]
[{"$f":"'Event Budget'!A15","v":"Family Max - Whole Weekend"},null,{"$f":"'Event Budget'!C15","v":0},{"$f":"'Event Budget'!D15","v":0},null,null,0,{"$f":"'Event Budget'!F15","v":0},null,0,0,0]
[{"$f":"'Event Budget'!A16","v":"Family Max - One Day"},null,{"$f":"'Event Budget'!C16","v":0},{"$f":"'Event Budget'!D16","v":0},null,null,{"$f":"SUM(E17+F17)*D17","v":0},{"$f":"'Event Budget'!F16","v":0},null,{"$f":"SUM(H17*I17)","v":0},{"$f":"E17+F17+I17","v":0},{"$f":"SUM(G17+J17)","v":0}]
["Total Site Income",null,null,null,{"$f":"SUM(E10:E17)","v":0},{"$f":"SUM(F10:F17)","v":0},0,null,0,0,0,0]
["Feast Fees"]
[{"$f":"'Event Budget'!A19","v":"Adult"},null,{"$f":"'Event Budget'!C19","v":0},{"$f":"'Event Budget'!D19","v":0},null,null,{"$f":"SUM(E20+F20)*D20","v":0},{"$f":"'Event Budget'!F19","v":0},null,{"$f":"SUM(H20*I20)","v":0},{"$f":"E20+F20+I20","v":0},{"$f":"SUM(G20+J20)","v":0}]
[{"$f":"'Event Budget'!A20","v":"Youth"},null,{"$f":"'Event Budget'!C20","v":0},{"$f":"'Event Budget'!D20","v":0},null,null,{"$f":"SUM(E21+F21)*D21","v":0},{"$f":"'Event Budget'!F20","v":0},null,0,0,{"$f":"SUM(G21+J21)","v":0}]
[{"$f":"'Event Budget'!A21","v":"Child"},null,{"$f":"'Event Budget'!C21","v":0},{"$f":"'Event Budget'!D21","v":0},null,null,{"$f":"SUM(E22+F22)*D22","v":0},{"$f":"'Event Budget'!F21","v":0},null,0,0,{"$f":"SUM(G22+J22)","v":0}]
["Total Feast Income",null,null,null,{"$f":"SUM(E20:E22)","v":0},{"$f":"SUM(F20:F22)","v":0},{"$f":"SUM(G20:G22)","v":0},null,{"$f":"SUM(I20:I22)","v":0},{"$f":"SUM(J20:J22)","v":0},{"$f":"SUM(K20:K22)","v":0},{"$f":"SUM(L20:L22)","v":0}]
["Other Fees"]
[{"$f":"'Event Budget'!A24","v":"Camping"},null,{"$f":"'Event Budget'!C24","v":0},{"$f":"'Event Budget'!D24","v":0},null,null,{"$f":"SUM(E25+F25)*D25","v":0},{"$f":"'Event Budget'!F24","v":0},null,{"$f":"SUM(H25*I25)","v":0},{"$f":"E25+F25+I25","v":0},{"$f":"SUM(G25+J25)","v":0}]
[{"$f":"'Event Budget'!A25","v":"Other Fee"},null,{"$f":"'Event Budget'!C25","v":0},{"$f":"'Event Budget'!D25","v":0},null,null,0,{"$f":"'Event Budget'!F25","v":0},null,0,0,0]
[{"$f":"'Event Budget'!A26","v":"Other Fee"},null,{"$f":"'Event Budget'!C26","v":0},{"$f":"'Event Budget'!D26","v":0},null,null,0,{"$f":"'Event Budget'!F26","v":0},null,0,0,0]
["NMS",null,null,5,null,null,0,5,null,0,0,0]
["Total Other Fee Income",null,null,null,{"$f":"SUM(E25:E28)","v":0},{"$f":"SUM(F25:F28)","v":0},{"$f":"SUM(G25:G28)","v":0},null,{"$f":"SUM(I25:I28)","v":0},{"$f":"SUM(J25:J28)","v":0},{"$f":"SUM(K25:K28)","v":0},{"$f":"SUM(L25:L28)","v":0}]
["Gate donations (not entrance fees - \"keep the change\") pg 11a, box 2(a)"]
["GROSS GATE INCOME (reserved + gate)   pg 11b, box 3b, col (A)",{"$nulls":5},{"$f":"SUM(G18+G23+G29+G30)","v":0},null,null,{"$f":"SUM(J18+J23+J29+J30)","v":0},{"$f":"SUM(K18+K23+K29+K30)","v":0},{"$f":"SUM(L18+L23+L29+L30)","v":0}]
[]
["Refunds",null,"Age","Pre-Reg \nFee","# \nACCEPS","# \nMail-In","Pre-reg\nTotals","Gate\nFee","# at \nGate","Gate \nTotals","Total \nAttendance","Total \nIncome"]
["Site Fees"]
[{"$f":"'Event Budget'!A9","v":"Adult - Whole weekend"},null,{"$f":"'Event Budget'!C9","v":0},{"$f":"'Event Budget'!D9","v":0},null,null,{"$f":"SUM(E35+F35)*D35","v":0},{"$f":"'Event Budget'!F9","v":0},null,{"$f":"SUM(H35*I35)","v":0},{"$f":"E35+F35+I35","v":0},{"$f":"SUM(G35+J35)","v":0}]
[{"$f":"'Event Budget'!A10","v":"Adult - One Day"},null,{"$f":"'Event Budget'!C10","v":0},{"$f":"'Event Budget'!D10","v":0},null,null,0,{"$f":"'Event Budget'!F10","v":0},null,0,0,0]
[{"$f":"'Event Budget'!A11","v":"Youth  - Whole Weekend"},null,{"$f":"'Event Budget'!C11","v":0},{"$f":"'Event Budget'!D11","v":0},null,null,0,{"$f":"'Event Budget'!F11","v":0},null,0,0,0]
[{"$f":"'Event Budget'!A12","v":"Youth - One Day "},null,{"$f":"'Event Budget'!C12","v":0},{"$f":"'Event Budget'!D12","v":0},null,null,0,{"$f":"'Event Budget'!F12","v":0},null,0,0,0]
[{"$f":"'Event Budget'!A13","v":"Child - Whole Weekend"},null,{"$f":"'Event Budget'!C13","v":0},{"$f":"'Event Budget'!D13","v":0},null,null,0,{"$f":"'Event Budget'!F13","v":0},null,0,0,0]
[{"$f":"'Event Budget'!A14","v":"Child - One Day"},null,{"$f":"'Event Budget'!C14","v":0},{"$f":"'Event Budget'!D14","v":0},null,null,0,{"$f":"'Event Budget'!F14","v":0},null,0,0,0]
[{"$f":"'Event Budget'!A15","v":"Family Max - Whole Weekend"},null,{"$f":"'Event Budget'!C15","v":0},{"$f":"'Event Budget'!D15","v":0},null,null,0,{"$f":"'Event Budget'!F15","v":0},null,0,0,0]
[{"$f":"'Event Budget'!A16","v":"Family Max - One Day"},null,{"$f":"'Event Budget'!C16","v":0},{"$f":"'Event Budget'!D16","v":0},null,null,{"$f":"SUM(E42+F42)*D42","v":0},{"$f":"'Event Budget'!F16","v":0},null,{"$f":"SUM(H42*I42)","v":0},{"$f":"E42+F42+I42","v":0},{"$f":"SUM(G42+J42)","v":0}]
["Total Site Refund",null,null,null,{"$f":"SUM(E35:E42)","v":0},{"$f":"SUM(F35:F42)","v":0},{"$f":"SUM(G35:G42)","v":0},null,{"$f":"SUM(I35:I42)","v":0},{"$f":"SUM(J35:J42)","v":0},{"$f":"SUM(K35:K42)","v":0},{"$f":"SUM(L35:L42)","v":0}]
["Feast Fees"]
[{"$f":"'Event Budget'!A19","v":"Adult"},null,{"$f":"'Event Budget'!C19","v":0},{"$f":"'Event Budget'!D19","v":0},null,null,{"$f":"SUM(E45+F45)*D45","v":0},{"$f":"'Event Budget'!F19","v":0},null,{"$f":"SUM(H45*I45)","v":0},{"$f":"E45+F45+I45","v":0},{"$f":"SUM(G45+J45)","v":0}]
[{"$f":"'Event Budget'!A20","v":"Youth"},null,{"$f":"'Event Budget'!C20","v":0},{"$f":"'Event Budget'!D20","v":0},null,null,{"$f":"SUM(E46+F46)*D46","v":0},{"$f":"'Event Budget'!F20","v":0},null,0,0,0]
[{"$f":"'Event Budget'!A21","v":"Child"},null,{"$f":"'Event Budget'!C21","v":0},{"$f":"'Event Budget'!D21","v":0},null,null,{"$f":"SUM(E47+F47)*D47","v":0},{"$f":"'Event Budget'!F21","v":0},null,0,0,0]
["Total Feast Refund",null,null,null,{"$f":"SUM(E45:E47)","v":0},{"$f":"SUM(F45:F47)","v":0},{"$f":"SUM(G45:G47)","v":0},null,{"$f":"SUM(I45:I47)","v":0},{"$f":"SUM(J45:J47)","v":0},{"$f":"SUM(K45:K47)","v":0},{"$f":"SUM(L45:L47)","v":0}]
["Other Fees"]
[{"$f":"'Event Budget'!A24","v":"Camping"},null,{"$f":"'Event Budget'!C24","v":0},{"$f":"'Event Budget'!D24","v":0},null,null,{"$f":"SUM(E50+F50)*D50","v":0},{"$f":"'Event Budget'!F24","v":0},null,{"$f":"SUM(H50*I50)","v":0},{"$f":"E50+F50+I50","v":0},{"$f":"SUM(G50+J50)","v":0}]
[{"$f":"'Event Budget'!A25","v":"Other Fee"},null,{"$f":"'Event Budget'!C25","v":0},{"$f":"'Event Budget'!D25","v":0},null,null,0,{"$f":"'Event Budget'!F25","v":0},null,0,0,0]
[{"$f":"'Event Budget'!A26","v":"Other Fee"},null,{"$f":"'Event Budget'!C26","v":0},{"$f":"'Event Budget'!D26","v":0},null,null,0,{"$f":"'Event Budget'!F26","v":0},null,0,0,0]
["NMS",null,null,5,null,null,0,5,null,0,0,{"$f":"SUM(G53+J53)","v":0}]
["Total Other Fee Refund",null,null,null,{"$f":"SUM(E50:E53)","v":0},{"$f":"SUM(F50:F53)","v":0},{"$f":"SUM(G50:G53)","v":0},null,{"$f":"SUM(I50:I53)","v":0},{"$f":"SUM(J50:J53)","v":0},{"$f":"SUM(K50:K53)","v":0},{"$f":"SUM(L50:L53)","v":0}]
["Total Refunds  pg 11b, box 3b, col (B)",{"$nulls":10},{"$f":"SUM(L43+L48+L54+L54)","v":0}]
["TOTAL EVENT INCOME  pg 11b, box 3b, col (A-B)",{"$nulls":10},{"$f":"SUM(L31-L55)","v":0}]
[]
["EXPENSES (from reciepts)  pg 2, activity related expenses",{"$nulls":4},"Reconcilliation",{"$nulls":4},"$"]
["Non-SCA Advertising",null,null,{"$f":"'Actual Expenses Worksheet'!F8","v":0},null,"Total Cash recieved (including Gate Seed)"]
["Equipment Rental and Maintenance",null,null,{"$f":"'Actual Expenses Worksheet'!F14","v":0},null,"Total Checks Received"]
["Fees and Honoraria",null,null,{"$f":"'Actual Expenses Worksheet'!F20","v":0},null,"Gate Seed"]
["Food",null,null,{"$f":"'Actual Expenses Worksheet'!F26","v":0},null,"ACCEPS Check received"]
["General supplies",null,null,{"$f":"'Actual Expenses Worksheet'!F32","v":0},null,"Mail-in Registraions received"]
["Insurance",null,null,{"$f":"'Actual Expenses Worksheet'!F38","v":0},null,"Total Deposits",{"$nulls":4},{"$f":"SUM(K59+K60+K62+K63)","v":0}]
["Occupancy and Site Charges",null,null,{"$f":"'Actual Expenses Worksheet'!F44","v":0},null,"Total Income (including Gate Seed, but not including refunds)",{"$nulls":4},{"$f":"SUM(L31+K61)","v":0},{"$f":"IF(K65=K64,\"yes\",K65-K64)","v":"yes"}]
["Postage, Shipping, PO Box rental",null,null,{"$f":"'Actual Expenses Worksheet'!F50","v":0}]
["Printing and Publications",null,null,{"$f":"'Actual Expenses Worksheet'!F56","v":0},null,"Gate Seed Deposit Date"]
["Telephone",null,null,{"$f":"'Actual Expenses Worksheet'!F62","v":0},null,"IF not returned w/in quarter, put Troll advance on pg 5, Receivables"]
["Travel",null,null,{"$f":"'Actual Expenses Worksheet'!F68","v":0}]
["SCA insurance",null,null,{"$f":"'Actual Expenses Worksheet'!F74","v":0}]
["Transfer Within Kingdom",null,null,{"$f":"'Actual Expenses Worksheet'!F86","v":0},null,"Profit Splits (automatically calculated)",null,null,null,"Kingdom event?",null,"NO"]
["Transfer Outside Kingdom",null,null,{"$f":"'Actual Expenses Worksheet'!F92","v":0},null,"Group  Subsidiaries capture as Donation to 501(c)3",{"$nulls":4},"% profit","Profit Split"]
["NMS",null,null,{"$f":"SUM(L28-L53)","v":0},null,"SCA Inc, Middle Kingdom",{"$nulls":4},{"$f":"IF(L71=\"yes\",0.5,0)","v":0},{"$f":"K73*(L56-D78)","v":0}]
["Variable Costs",{"$nulls":4},"Group Name",{"$nulls":4},0,{"$f":"K74*(L56-D78)","v":0}]
["Occupancy-per adult",null,null,0,null,"Group Name",{"$nulls":4},0,{"$f":"K75*(L56-D78)","v":0}]
["Occupancy-per youth",null,null,0,null,"Group Name",{"$nulls":4},0,{"$f":"K76*(L56-D78)","v":0}]
["Occupancy-per child",null,null,0,null,"Total Transfers  SCA Inc capture in Transfer Out Within Kingdom",{"$nulls":4},{"$f":"SUM(K73:K76)","v":0},{"$f":"SUM(L73:L76)","v":0}]
["Total Expenses",null,null,{"$f":"SUM(D59:G76)","v":0},null,"Gross Profit   Income_11b, Event Income",{"$nulls":4},{"$f":"SUM(1,-K73-K74-K75-K76)","v":1},{"$f":"SUM(L56-D78-L77)","v":0}]
[]
["Approval"]
[null,"SCA Name",null,null,null,"Legal Name",null,null,"Signature",null,null,"Date"]
["Seneschal",{"$f":"IF('Event Budget'!B57=\"\",\"\",'Event Budget'!B57)","v":""},null,null,null,{"$f":"IF('Event Budget'!D57=\"\",\"\",'Event Budget'!D57)","v":""}]
["Exchequer",{"$f":"IF('Event Budget'!B58=\"\",\"\",'Event Budget'!B58)","v":""},null,null,null,{"$f":"IF('Event Budget'!D58=\"\",\"\",'Event Budget'!D58)","v":""}]
["Event Steward 1",{"$f":"IF('Event Budget'!B59=\"\",\"\",'Event Budget'!B59)","v":""},null,null,null,{"$f":"IF('Event Budget'!D59=\"\",\"\",'Event Budget'!D59)","v":""}]
["Event Steward 2",{"$f":"IF('Event Budget'!B60=\"\",\"\",'Event Budget'!B60)","v":""},null,null,null,{"$f":"IF('Event Budget'!D60=\"\",\"\",'Event Budget'!D60)","v":""}]
["Event Steward 3",{"$f":"IF('Event Budget'!B61=\"\",\"\",'Event Budget'!B61)","v":""},null,null,null,{"$f":"IF('Event Budget'!D61=\"\",\"\",'Event Budget'!D61)","v":""}]

{"sheet":"Actual Expenses Worksheet","index":6,"n_rows":93,"n_cols":6,"rows_kept":93,"cut":false,"hidden":false,"merged":[[92,0,92,4],[73,0,73,1],[73,2,73,3],[74,0,78,1],[79,0,79,1],[79,2,79,3],[80,0,91,0],[80,1,85,1],[85,2,85,3],[86,1,91,1],[91,2,91,3],[68,0,72,1],[49,0,49,1],[49,2,49,3],[50,0,54,1],[55,0,55,1],[55,2,55,3],[56,0,60,1],[61,0,61,1],[61,2,61,3],[62,0,66,1],[67,0,67,1],[67,2,67,3],[44,0,48,1],[25,0,25,1],[25,2,25,3],[26,0,30,1],[31,0,31,1],[31,2,31,3],[32,0,36,1],[37,0,37,1],[37,2,37,3],[38,0,42,1],[43,0,43,1],[43,2,43,3],[20,0,24,1],[0,0,0,5],[1,0,1,1],[2,0,6,1],[7,0,7,1],[7,2,7,3],[8,0,12,1],[13,0,13,1],[13,2,13,3],[14,0,18,1],[19,0,19,1],[19,2,19,3]]}
["ITEMIZED EXPENSES:"]
["EXPENSES",null,"Description","Quantity","Price / Item","Budget Total"]
["Non-SCA Advertising",{"$nulls":4},{"$f":"SUM(D3*E3)","v":0}]
[{"$nulls":5},{"$f":"SUM(D4*E4)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F3:F7)","v":0}]
["Equipment Rental & Maintenance",{"$nulls":4},{"$f":"SUM(D9*E9)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F9:F13)","v":0}]
["Fees & Honoraria",{"$nulls":4},{"$f":"SUM(D15*E15)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F15:F19)","v":0}]
["Food",{"$nulls":4},{"$f":"SUM(D21*E21)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F21:F25)","v":0}]
["General Supplies",{"$nulls":4},{"$f":"SUM(D27*E27)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F27:F31)","v":0}]
["Insurance (NON-SCA)",{"$nulls":4},{"$f":"SUM(D33*E33)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F33:F37)","v":0}]
["Occupancy & Site Charges",{"$nulls":4},{"$f":"SUM(D39*E39)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F39:F43)","v":0}]
["Postage & Shipping, PO Box Rental",{"$nulls":4},{"$f":"SUM(D45*E45)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F45:F49)","v":0}]
["Printing & Publications",{"$nulls":4},{"$f":"SUM(D51*E51)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F51:F55)","v":0}]
["Telephone",{"$nulls":4},{"$f":"SUM(D57*E57)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F57:F61)","v":0}]
["Travel (Gas, Tolls, Airfare)",{"$nulls":4},{"$f":"SUM(D63*E63)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F63:F67)","v":0}]
["SCA Insurance",null,"Named Insurance Certificate:",null,null,{"$f":"SUM(D69*E69)","v":0}]
[null,null,"Equestrian Named Insurance Certificate:",null,null,0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F69:F73)","v":0}]
["Donations to Other 501(c)(3) [Nonprofit] Organizations  ",{"$nulls":4},{"$f":"SUM(D75*E75)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F75:F79)","v":0}]
["Transfer to Another SCA Account  \n(Expenses such as NMS, ACCEPS Fees, etc…)","WITHIN KINGDOM \n(such as the Pale Ad)","Pale Ad",null,null,{"$f":"SUM(D81*E81)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F81:F85)","v":0}]
[null,"OUTSIDE KINGDOM\n(such as ACCEPS)","ACCEPS Registration",null,null,{"$f":"SUM(D87*E87)","v":0}]
[{"$nulls":5},{"$f":"SUM(D88*E88)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,null,"Subtotal",null,null,{"$f":"SUM(F87:F91)","v":0}]
["Total ESTIMATED Expenses",{"$nulls":4},{"$f":"SUM(F8+F14+F20+F26+F32+F38+F44+F50+F56+F62+F68+F74+F80+F86+F92)","v":0}]

{"sheet":"NMS","index":7,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,7],[10,1,10,4],[5,1,5,7],[4,4,4,6],[17,1,17,7],[7,1,7,7],[29,1,29,3],[29,5,29,7],[20,2,20,7],[26,1,26,7],[1,0,1,7],[27,1,27,7],[28,1,28,3],[13,0,13,4],[20,0,20,1],[21,0,21,1],[22,0,22,1],[21,2,21,7],[22,2,22,7],[11,1,11,4],[2,0,2,2],[2,4,2,5]]}
["SOCIETY FOR CREATIVE ANACHRONISM, INC."]
["KINGDOM OF THE MIDDLE - NON-MEMBER SURCHARGE REPORT"]
["Due 14 days after the close of the event",null,null,"Due Date:",{"$f":"IF('Event Budget'!I5=\"\",\"\",'Event Budget'!I5+14)","v":""}]
[]
["EVENT DATE:",{"$f":"IF('Event Budget'!G5=\"\",\"\",'Event Budget'!G5)","v":""},null,"END DATE:",{"$f":"IF('Event Budget'!I5=\"\",\"\",'Event Budget'!I5)","v":""}]
["GROUP:",{"$f":"IF('Event Budget'!B4=\"\",\"\",'Event Budget'!B4)","v":"Group Name"}]
[]
["EVENT:",{"$f":"IF('Event Budget'!B5=\"\",\"\",'Event Budget'!B5)","v":""}]
[]
[]
[null,"Total # actual adult attendees",null,null,null,{"$f":"SUM('Event Report'!K10,'Event Report'!K11,-'Event Report'!K35,-'Event Report'!K36)","v":0}]
[null,"# Non-members attending",null,null,null,{"$f":"SUM('Event Report'!K28,-'Event Report'!K53)","v":0}]
[]
["Make check payable to:  SCA Inc, Middle Kingdom",{"$nulls":4},{"$f":"SUM('Event Report'!L28,-'Event Report'!L53)","v":0}]
[]
["Check Number",null,"Check Date"]
[]
["Mail to:","Domnall Ohodhrain (Dennis Horan) PO Box 455 Greensburg, IN  47240"]
[]
[]
["SCA Inc Groups",null,"page 10 - Transfers Out (w/in Kingdom)"]
["SCA Illinois Inc, Groups",null,"page 12b - Donations to SCA, Inc Subsidiaries and other 501(c)3 "]
["SCA Michigan Inc, Groups",null,"page 12b - Donations to SCA, Inc Subsidiaries and other 501(c)3 "]
[]
[]
["APPROVALS","Print Name"]
["Exchequer",{"$f":"IF('Event Budget'!D58=\"\",\"\",'Event Budget'!D58)","v":""}]
["Address"]
["City",null,null,null,"State",null,"Zip"]
["Phone",null,null,null,"email"]