{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Camp SD Sheet"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":"Camp SD Sheet","index":0,"n_rows":118,"n_cols":12,"rows_kept":118,"cut":false,"hidden":false,"merged":[[54,0,54,4],[54,9,54,13],[73,0,73,13],[74,0,74,13],[75,0,75,4],[75,9,75,13],[76,0,76,13],[71,0,71,13],[67,9,67,13],[68,9,68,13],[66,1,66,4],[67,1,67,4],[68,1,68,4],[69,1,69,4],[66,9,66,13],[69,9,69,13],[62,0,62,13],[63,0,63,13],[64,0,64,4],[64,9,64,13],[65,0,65,13],[117,0,117,13],[95,1,95,4],[95,9,95,13],[96,1,96,4],[96,9,96,13],[97,1,97,4],[97,9,97,13],[116,11,116,13],[115,11,115,13],[98,1,98,4],[98,9,98,13],[100,1,100,4],[101,1,101,4],[100,5,100,8],[100,9,100,12],[101,5,101,8],[101,9,101,12],[48,1,48,4],[53,2,53,6],[10,1,10,3],[89,0,89,4],[89,9,89,13],[90,0,90,13],[58,1,58,4],[58,9,58,13],[60,0,60,13],[33,0,33,13],[55,0,55,13],[56,1,56,4],[56,9,56,13],[57,1,57,4],[57,9,57,13],[50,1,50,4],[48,9,48,13],[49,1,49,4],[49,9,49,13],[42,1,42,4],[42,9,42,13],[45,0,45,1],[45,2,45,6],[53,8,53,10],[50,9,50,13],[52,0,52,13],[0,0,1,13],[4,4,4,9],[6,3,6,9],[8,3,8,11],[39,0,39,13],[44,0,44,13],[46,0,46,4],[46,9,46,13],[38,0,38,4],[40,1,40,4],[38,9,38,13],[40,9,40,13],[41,1,41,4],[41,9,41,13],[23,0,23,6],[35,0,35,12],[3,2,3,5],[9,3,9,8],[37,2,37,6],[34,0,34,13],[36,0,36,13],[47,0,47,13],[79,1,79,4],[79,9,79,13],[80,1,80,4],[80,9,80,13],[81,1,81,4],[81,9,81,13],[77,1,77,4],[77,9,77,13],[78,1,78,4],[78,9,78,13],[92,1,92,4],[92,9,92,13],[93,1,93,4],[93,9,93,13],[94,1,94,4],[94,9,94,13],[85,0,85,13],[87,0,87,13],[82,1,82,4],[82,9,82,13],[83,1,83,4],[83,9,83,13],[86,0,86,13],[91,1,91,4],[91,9,91,13]]}
["Camp / Property Sustainability Data Sheet"]
[]
[]
["Council Name:",{"$nulls":6},"      Council Number:                ",null,"________"]
["Council Headquarters city/state: "]
[]
["Camp/Property  Name:",null,null,"______________________________________________________________"]
[]
["Council contact name:                  ",null,null,"__________________________________________________________________________________"]
["Contact Email:                 ",null,null,"_______________________________________________________"]
["Phone:      ","_________________________________________________"]
[]
["Instructions for Completing This Form:"]
[]
["A Camp/Property Sustainability Data Sheet is required for each camp property, regardless of whether it hosts a long-term camp."]
[]
["Gather the requested information: "]
["1.    Complete a section of page 2 for each long-Term Camp (LTC) at this property. Use additional sheets if necessary. "]
["2.    Complete the aggregate expenses and revenue section for all LTC’s at this property."]
["3.    Complete the Other (non-LTC) section for this property (including day and short-term camps)."]
["4.    Complete the overall aggregate return for the combined LTC’s and the camp property."]
["The information should be obtained from your council camping and financial data.  "]
[]
["Submit to your assigned National Reviewer and via email to ",{"$nulls":6},"NCAP@scouting.org."]
[]
[]
["Note: A Camp/Property Sustainability Data Sheet should also be filled out for any long-term camp that you operate that is "]
[null,"not on council camp property.  The financial information from this camp will be needed for completing this form and for"]
[null,"the Council Sustainability Commitments Form."]
[]
[]
[]
[]
[1]
["Long-Term Camp Sustainability Data Sheet"]
["Fill out a section below for each long-term camp at this property. Include additional sheets as necessary."]
["LTC 1"]
["LTC Camp Name        ",null,"____________________________________________",{"$nulls":4},"Camp Type  _____Scouts BSA_______________"]
["Question",{"$nulls":4},2022,2023,2024,2025,"Instructions"]
["Long Term Camp Attendence/Fees"]
[1,"How many weeks does this long term property operate on this property",{"$nulls":7},"Gather from camping data.  "]
[2,"What is the camp fee charged for this long-term camp at this property?",{"$nulls":7},"Primary long-term camp fee for youth participants."]
[3,"How many participants attended/capacity in this long-term camp (attended/capacity)",null,null,null,"/","/","/","/","Information from camp attendance. "]
[]
["LTC 2"]
["LTC Camp Name        ",null,"______________________________________________",{"$nulls":4}," Camp Type  __________Cub___________________"]
["Question",{"$nulls":4},2022,2023,2024,2025,"Instructions"]
["Long Term Camp Attendence/Fees"]
[1,"How many weeks does this long term property operate on this property",{"$nulls":7},"Gather from camping data.  "]
[2,"What is the camp fee charged for this long-term camp at this property?",{"$nulls":7},"Primary long-term camp fee for youth participants."]
[3,"How many participants attended/capacity in this long-term camp (attended/capacity)",null,null,null,"/","/","/","/","Information from camp attendance."]
[]
["LTC 3"]
["LTC Camp Name        ",null,"____________________________________________",{"$nulls":4},"Camp Type  ","___Other (Venturing/Winter)___"]
["Question",{"$nulls":4},2022,2023,2024,2025,"Instructions"]
["Long Term Camp Attendence/Fees"]
[1,"How many weeks does this long term property operate on this property ",{"$nulls":7},"Gather from camping data.  "]
[2,"What is the camp fee charged for this long-term camp at this property?",{"$nulls":7},"Primary long-term camp fee for youth participants."]
[3,"How many participants attended/capacity in this long-term camp (attended/capacity)",null,null,null,"/","/","/","/","Information from camp attendance."]
[]
[2]
[]
["Long-Term Camp Sustainability Data Sheet"]
["Fill out the section below aggregating expenses and revenues from all long-term camps at this property."]
["Question",{"$nulls":4},2022,2023,2024,2025,"Instructions"]
["Long Term Camp Data - Expenses and Revenues"]
[4,"What were the actual revenues from all long-term camp(s) at this property?",{"$nulls":7},"These are gross revenues from all long-term camp(s) at this camp property.  Council financials."]
[5,"What were the actual expenses from all long-term camp(s) at this property?",{"$nulls":7},"These are gross expenses from all long-term camp(s) at this camp property.  Council financials."]
[6,"Net gain/loss",null,null,null,{"$f":"F67-F68","v":0},0,0,{"$f":"I67-I68","v":0},"Subtract row 5 from row 4."]
[7,"Aggregate return: in %",null,null,null,{"$f":"(F67/F68-1)","v":{"$error":"#DIV/0!"}},{"$f":"(G67/G68-1)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Divide row 4 by row 5, subtract 1 and multiply by 100"]
[]
["_______________________________________________________________________________________________________________________________"]
[]
["Other (Non-LTC) Camp Sustainability Data Sheet"]
["One sheet for the Camp Property"]
["Question",{"$nulls":4},2022,2023,2024,2025,"Instructions"]
["Non Long Term Camp Data "]
[8,"What were the actual revenues from day camps and short-term camps at this facility?",{"$nulls":7},"Balance of camping/activity revenues assigned to camp property"]
[9,"What were the actual expenses from day camps and short-term camps at this facility?",{"$nulls":7},"Balance of camping/activity expenses assigned to camp property"]
[10,"What other revenues were generated at this camp property?",{"$nulls":7},"Typically, non-Scout camping revenues (rentals, oil and gas, timber, etc.)."]
[11,"What other expenses were generated at this camp property?",{"$nulls":7},"All other year-round expenses."]
[12,"What is the council’s allocated insurance, overhead, debt service, professional and support personnel expense allocated to this camp property?",{"$nulls":7},"Enter the allocated amount from line 10a on the Council Sustainability Data Sheet (if multiple camps) for this camp/camp property.  Explain allocation basis below if multiple camps."]
[13,"Total Other revenues:",null,null,null,{"$f":"F78+F80","v":0},{"$f":"G78+G80","v":0},0,0,"Add rows 8 and 10."]
[14,"Total Other expenses:",null,null,null,{"$f":"F79+F81+F82","v":0},{"$f":"G79+G81+G82","v":0},0,0,"Add rows 9, 11 and 12."]
["Please explain the basis for allocation of line 12 expenses to this camp (user days, revenues, other method)?"]
["____________________________________________________________________________________________________________________________________________________"]
[3]
["Overall Camp/Property Sustainability Data Sheet"]
[{"$nulls":8},"D"]
[{"$nulls":5},2022,2023,2024,2025,"Instructions"]
["Overall Sustainability"]
[15,"Total Revenues",null,null,null,{"$f":"F67+F83","v":0},{"$f":"G67+G83","v":0},0,0,"Add line 4 and line 13 "]
[16,"Total Expenses",null,null,null,{"$f":"F68+F84","v":0},{"$f":"G68+G84","v":0},{"$f":"H68+H84","v":0},{"$f":"I68+I84","v":0},"Add line 5  and line 14 "]
[17,"Total Net gain/loss",null,null,null,{"$f":"F92-F93","v":0},{"$f":"G92-G93","v":0},{"$f":"H92-H93","v":0},0,"Subtract row 16 from row 15"]
[18,"Total Aggregate Return in %",null,null,null,{"$f":"(F92/F93)-1","v":{"$error":"#DIV/0!"}},{"$f":"(G92/G93)-1","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Divide row 15 by row 16, subtract 1 and multiply by 100"]
[19,"What is depreciated value of camp facilities, program equipment, assets (other than land) at the camp property (or camp)?",{"$nulls":7},"From council finances, fund 2."]
[20,"Return on depreciated investment in percent",null,null,null,{"$f":"F94/F96","v":{"$error":"#DIV/0!"}},{"$f":"G94/G96","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Divide row 17 by row 19 and multiply by 100"]
[21,"Calculated National minimum revenue expectation ($):",null,null,null,{"$f":"F93*1.05","v":0},{"$f":"G93*1.05","v":0},0,0,"Multiply row 16  by 1.05."]
[22,"Calculated National revenue goal ($):",null,null,null,{"$f":"(F96*0.05)+F98","v":0},{"$f":"(G96*0.05)+G98","v":0},0,0,"(Row 19 multiplied by 0.05) + row 21"]
[]
[23,"Four Year Average Revenues",null,null,null,{"$f":"(F92+G92+H92+I92)/4","v":0},null,null,null,"Transfer this number to the Commitments Data Sheet in Section A.1"]
[24,"Four Year Average Expenses",null,null,null,{"$f":"(F93+G93+H93+I93)/4","v":0},null,null,null,"Transfer this number to the Commitments Data Sheet in Section A.1"]
{"$rows_empty":13}
[{"$nulls":11},"430-090"]
[{"$nulls":11},"2026 Printing"]
[4]