{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["2025 Fees","Calculator","list"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"2025 Fees","index":0,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,1,26,5],[2,1,2,5],[1,1,1,5]]}
[]
[null,"Daradgee Environmental Education Centre 2025 Schedule of Fees "]
[null,"Growth. Connection. Opportunity For All."]
[null,"Primary Schools (Prices Exclude GST)"]
[null,"Camp Selection","Activities","Food ","Accommodation","Total"]
[null,"Day visit",15,10,0,{"$f":"SUM(C6:E6)","v":25}]
[null,"3 day camp",45,102,30,{"$f":"SUM(C7:E7)","v":177}]
[null,"4 day camp",55,148,45,{"$f":"SUM(C8:E8)","v":248}]
[null,"5 day camp",65,194,60,{"$f":"SUM(C9:E9)","v":319}]
[null,"Additional  Optional Charges"]
[null,"Morning Tea First Day",null,5.5,null,{"$f":"SUM(C11:E11)","v":5.5}]
[null,"Afternoon Tea Last Day",null,5.5,null,{"$f":"SUM(C12:E12)","v":5.5}]
[null,"Camp Shirt",null,25,null,25]
[]
[null,"Secondary Students + Clubs & Associations (Prices Exclude GST).  "]
[null,"Camp Selection","Activities","Food ","Accommodation","Total"]
[null,"Day visit ",{"$f":"C6","v":15},{"$f":"(D6+(D6*0.5))","v":15},{"$f":"E6","v":0},{"$f":"SUM(C17:E17)","v":30}]
[null,"3 day camp",{"$f":"C7","v":45},{"$f":"(D7+(D7*0.5))","v":153},{"$f":"E7","v":30},{"$f":"SUM(C18:E18)","v":228}]
[null,"4 day camp",{"$f":"C8","v":55},{"$f":"(D8+(D8*0.5))","v":222},45,{"$f":"SUM(C19:E19)","v":322}]
[null,"5 day camp",{"$f":"C9","v":65},{"$f":"(D9+(D9*0.5))","v":291},60,{"$f":"SUM(C20:E20)","v":416}]
[null,"Additional Optional Charges"]
[null,"Morning Tea First Day",null,{"$f":"D11+(D11*0.5)","v":8.25},null,{"$f":"SUM(C22:E22)","v":8.25}]
[null,"Afternoon Tea Last Day",null,{"$f":"D12+(D12*0.5)","v":8.25},null,{"$f":"SUM(C23:E23)","v":8.25}]
[null,"Camp Shirt",null,25,null,25]
[]
[null,"Terms and Conditions:"]
[null,"* Multiple day camps include lunch on the first and last day.                                                                                                                                                                                                       * Adults will need to pay for food only.                                                                                                                                                                                                                                                                                                                              * For groups less than 25 total (adults + students) there is a kitchen surcharge of 30%.                                                                                                                                                                                                                                                                                              * Food prices are based on adults and children assisting in the kitchen.  If full catering is required a 50% surcharge will be applied.                                                                                                                                                                                                                                                                          * Weekends and Public Holidays incur a 35% surcharge                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   * Bus / Transport charges will be in addition to camp cost and will be charged directly to you based on price from third party provider.                                                                                                                                                                                                                                                                                                                                                 *GST is charged on the basis on what Daradgee EEC is required to charge.  You are required to work out what GST you need to pass onto individuals attending camp.                                                                                                                                                                                                                                                                              *Late cancellations with less than 8 weeks’ notice prior to camp incur a late cancellation fee calculated at 60% of accommodation and activity costs.                                                                                                                                                                                                                                                                                                                                                 *Final student and adult numbers must be confirmed via Book the Cook 2 weeks/10 working days prior to camp.     "]

{"sheet":"Calculator","index":1,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,1,2,5],[1,1,1,5],[17,1,17,5],[3,1,3,5],[16,1,16,2],[10,4,10,5],[36,1,36,2],[45,1,45,5],[46,1,46,5],[43,1,43,3],[40,1,40,3],[41,1,41,3],[38,1,38,2]]}
[]
[null," Daradgee Environmental Education Centre 2025 Camp Calculator"]
[null,"Growth. Connection. Opportunity For All."]
[null,"Please select from drop down menus and insert dates and numbers where applicable in WHITE areas. These are used to calcuate the camp cost."]
[]
[null,"Camp Selection",null,null,"Would Students like camp shirts?"]
[null,null,null,null,"$25 per shirt"]
[null,"Camp Arrival Date",null,null,"Is the camp on Weekend or Public Holiday?"]
[]
[null,"Number of Students",null,null,"Full Catering Required?"]
[null,null,null,null,"50% surcharge if camp attendees want Full Catering - i.e. no kitchen/dining duties (clearing & wiping of tables, dishwasher duty, general tidy-up)",null,null,{"$f":"F12&F14&F16","v":""}]
[null,"Number of Supervising Adults                                        ",null,null,"Add Morning Tea - First Day",null,null,"YesYesYes",{"$f":"'2025 Fees'!D11+'2025 Fees'!D12-'2025 Fees'!D12","v":5.5}]
[null,"Supervising Adults Pay for food only",null,null,null,null,null,"YesYesNo",{"$f":"'2025 Fees'!D11+'2025 Fees'!D12","v":11}]
[null,"Group Type",null,null,"Add Afternoon Tea - Last Day",null,null,"YesNoNo",{"$f":"'2025 Fees'!D11","v":5.5}]
[null,null,{"$f":"IF($C$10<=list!$I$3,list!$J$3,(IF($C$10<=list!$I$4,list!$J$4,(IF($C$10<=list!$I$5,list!$J$5,(IF($C$10<=list!$I$6,list!$J$6,(IF($C$10<=list!$I$7,list!$J$7,(IF($C$10<=list!$I$8,list!$J$8,(\"add to list\"))))))))))))","v":1},null,null,null,null,"NoYesYes",0]
[null," Are you a State School?",null,null,"Remove Morning Tea - Last Day",null,null,"NoNoYes",-5.5]
[null,"GST is not applicable to state schools. GST does apply to other entities.",null,null,null,null,null,"NoNoNo",0]
[null,"Summary of Camp Costs ",null,null,null,null,null,"NoYesNo",5.5]
[]
[null,"Item","Per Student",null,"Student Group Total (Excl GST)","GST (If Applicable)"]
[null,{"$f":"IF(ISBLANK(C6),\"Camp Selection\",C6)","v":"Camp Selection"},{"$f":"IF(ISBLANK($C$14),0,(IF($C$14=\"Primary School\",VLOOKUP($B$21,list!$B$14:$E$17,2,FALSE),VLOOKUP($B$21,list!$B$14:$D$17,3,FALSE))))","v":0},null,{"$f":"IFERROR(IF(ISBLANK($C$10),0,($C$10*C21)),0)","v":0},{"$f":"IF($C$16=\"No\",(E21*10%),0)","v":0}]
[null,"Additional Morning Tea",{"$f":"IF(F12=\"Yes\",(IF(ISBLANK($C$14),0,(IF($C$14=\"Primary School\",VLOOKUP($B$21,list!$B$14:$K$17,10,FALSE),VLOOKUP($B$21,list!$B$14:$L$17,11,FALSE))))),0)","v":0},null,0,0]
[null,"Additional Afternoon Tea",{"$f":"IF(F14=\"Yes\",(IF(ISBLANK($C$14),0,(IF($C$14=\"Primary School\",VLOOKUP($B$21,list!$B$14:$K$17,10,FALSE),VLOOKUP($B$21,list!$B$14:$L$17,11,FALSE))))),0)","v":0},null,0,0]
[null,"Remove Morning Tea Last Day",{"$f":"IF(F16=\"Yes\",(IF(ISBLANK($C$14),0,(IF($C$14=\"Primary School\",-(VLOOKUP($B$21,list!$B$14:$K$17,10,FALSE)),-(VLOOKUP($B$21,list!$B$14:$L$17,11,FALSE)))))),0)","v":0},null,{"$f":"IFERROR(IF(ISBLANK($C$10),0,($C$10*C24)),0)","v":0},0]
[null,"Fully Catered loading",{"$f":"IF(ISBLANK(F10),0,(IF(F10=\"Yes\",(IF(ISBLANK($C$14),\"\",(IF($C$14=\"Primary School\",VLOOKUP($B$21,list!$B$14:$J$17,4,FALSE),VLOOKUP($B$21,list!$B$14:$J$17,5,FALSE))))),0)))","v":0},null,0,0]
[null,"< 25 People Kitchen loading",{"$f":"IF(ISBLANK($C$10),0,(IF(SUM($C$10,$C$12)<25,(IF(ISBLANK($C$14),0,(IF($C$14=\"Primary School\",VLOOKUP($B$21,list!$B$14:$J$17,8,FALSE),VLOOKUP($B$21,list!$B$14:$J$17,9,FALSE))))),0)))","v":0},null,0,0]
[null,"Weekend loading",{"$f":"IF(ISBLANK($F$8),0,(IF($F$8=\"Yes\",(SUM($C$21:$C$26*35%)),0)))","v":0},null,0,0]
[null,"Camp Shirt",{"$f":"IF($F$6=\"Yes\",25,0)","v":0},null,0,0]
[null,"Total Student Costs",{"$f":"SUM(C21:C28)","v":0},null,{"$f":"SUM(E21:E28)","v":0},{"$f":"SUM(F21:F28)","v":0}]
[]
[null,"Supervising Adult Food Costs ",{"$f":"IF(B21=\"Camp Selection\",0,(IF(F10=\"Yes\",((VLOOKUP($B$21,list!$B$14:$N$17,13,FALSE)))+((VLOOKUP($B$21,list!$B$14:$N$17,13,FALSE))*50%),(IF(F8=\"Yes\",((VLOOKUP($B$21,list!$B$14:$N$17,13,FALSE)))+((VLOOKUP($B$21,list!$B$14:$N$17,13,FALSE))*35%),((VLOOKUP($B$21,list!$B$14:$N$17,13,FALSE))))))))","v":0},null,{"$f":"C31*C12","v":0},{"$f":"IF($C$16=\"No\",(E31*10%),0)","v":0}]
[null,"Adult Morning & Afternoon Tea Adjustment/s",{"$f":"IF(F14=\"Yes\",(IF(ISBLANK($C$14),0,(IF($C$14=\"Primary School\",VLOOKUP($B$21,list!$B$14:$K$17,10,FALSE),VLOOKUP($B$21,list!$B$14:$L$17,11,FALSE))))),0)+IF(F12=\"Yes\",(IF(ISBLANK($C$14),0,(IF($C$14=\"Primary School\",VLOOKUP($B$21,list!$B$14:$K$17,10,FALSE),VLOOKUP($B$21,list!$B$14:$L$17,11,FALSE))))),0)-IF(F16=\"Yes\",(IF(ISBLANK($C$14),0,(IF($C$14=\"Primary School\",VLOOKUP($B$21,list!$B$14:$K$17,10,FALSE),VLOOKUP($B$21,list!$B$14:$L$17,11,FALSE))))),0)","v":0},null,{"$f":"C32*C12","v":0},{"$f":"IF($C$16=\"No\",(E32*10%),0)","v":0}]
[null,"Fully Catered loading",{"$f":"IF(ISBLANK(F10),0,(IF(F10=\"Yes\",(IF(ISBLANK($C$14),\"\",(IF($C$14=\"Primary School\",VLOOKUP($B$21,list!$B$14:$J$17,4,FALSE),VLOOKUP($B$21,list!$B$14:$J$17,5,FALSE))))),0)))","v":0},null,{"$f":"IFERROR(IF(ISBLANK($C$12),0,($C$12*C33)),0)","v":0},{"$f":"IF($C$16=\"No\",(E33*10%),0)","v":0}]
[null,"< 25 People Kitchen loading",{"$f":"IF(ISBLANK($C$10),0,(IF(SUM($C$10,$C$12)<25,(IF(ISBLANK($C$14),0,(IF($C$14=\"Primary School\",VLOOKUP($B$21,list!$B$14:$J$17,8,FALSE),VLOOKUP($B$21,list!$B$14:$J$17,9,FALSE))))),0)))","v":0},null,{"$f":"IFERROR(IF(ISBLANK($C$12),0,($C$12*C34)),0)","v":0},0]
[null,"Weekend loading",{"$f":"IF(ISBLANK($F$8),0,(IF($F$8=\"Yes\",(SUM($C$31:$C$34*35%)),0)))","v":0},null,{"$f":"IFERROR(IF(ISBLANK($C$12),0,($C$12*C35)),0)","v":0},0]
[null,"Insert No. of Adult Camp Shirts Required",null,null,{"$f":"IFERROR(C36*25,0)","v":0},{"$f":"IF($C$16=\"No\",(E36*10%),0)","v":0}]
[null,"Total Adult Costs",null,null,{"$f":"SUM(E31:E36)","v":0},{"$f":"SUM(F31:F36)","v":0}]
[]
[null,"Total Daradgee EEC Costs",null,null,{"$f":"E37+E29","v":0},{"$f":"F37+F29","v":0}]
[]
[null,"Total Bus Transport on Camp Costs (Third Party Charge)",null,null,null,{"$f":"E41*10%","v":0}]
[null,"Other External Visitation Costs (Insert As Appropriate)",null,null,null,{"$f":"E42*10%","v":0}]
[]
[null,"Total School Camp Cost",null,null,{"$f":"SUM(E39,E41,E42)","v":0},{"$f":"SUM(F39,F41,F42)","v":0}]
[]
[null,"Terms and Conditions"]
[null,"* Multiple day camps include lunch on the first and last day.                                                                                                                                                                                                       * Adults will need to pay for food only.                                                                                                                                                                                                                          * For groups less than 25 total (adults + students) there is a kitchen surcharge of 30%.                                                                                                                                                                                                    * Food prices are based on adults and children assisting in the kitchen.  If full catering is required a 50% surcharge will be applied.                                                                                                                                                                                                                 * Weekends and Public Holidays incur a 35% surcharge                                                                                                                                                                                                                                                                                                                                                                                                            * Bus / Transport charges will be in addition to camp cost and will be charged directly to you based on price from third party provider.                                                                                                                                                                                                                                                                        *GST is charged on the basis on what Daradgee EEC is required to charge.  You are required to work out what GST you need to pass onto individuals attending camp.                                                                                                                                                                                                      *Late cancellations with less than 8 weeks’ notice prior to camp incur a late cancellation fee calculated at 60% of accommodation and activity costs.                                                                                                                                                                                                                                                                   *Final student and adult numbers must be confirmed via Book the Cook 2 weeks/10 working days prior to camp.                                               "]

{"sheet":"list","index":2,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[null,"Group Type","Loading"]
[null,"Primary School","BASE",1,null,"Yes",null,"Min Group Size","Max Group Size","Number of FOC adults",null,"Acceptable Ratio of adults / kids",null,null,null,"Start Date","Finish Date","Days between"]
[null,"Secondary School",0.5,2,null,"No",null,0,25,1,{"$f":"J3/I3","v":0.04},{"$f":"2/26","v":7.6923076923076927E-2},null,null,null,"2025-01-01"]
[null,"Club or Association",0.5,2,null,null,null,26,50,2,{"$f":"J4/I4","v":0.04},{"$f":"3/51","v":5.8823529411764705E-2},null,null,null,"2025-01-02"]
[null,"Weekend camp",0.35,3,null,null,null,51,75,3,0.04,{"$f":"4/76","v":5.2631578947368418E-2},null,null,null,"2025-01-03"]
[null,"Fully Catered",0.5,4,null,null,null,76,100,4,0.04,{"$f":"5/101","v":4.9504950495049507E-2},null,null,null,"2025-01-04"]
[null,"State School","Excl GST",null,null,null,null,101,125,5,0.04,{"$f":"6/126","v":4.7619047619047616E-2},null,null,null,"2025-01-05"]
[null,"Private School or Club or Association","Incl GST",null,null,null,null,126,150,6,0.04,{"$f":"7/151","v":4.6357615894039736E-2},null,null,null,"2025-01-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-07"]
[null,"optional extras",null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-09"]
[null,"Additional adult cost",null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-10"]
[null,null,"Primary School","Secondary School","Primary Fully catered","secondary fully catered","Primary Additional Adult","Secondary Addititional Adult","Primary <25 pax","Secondary < 25","Primary Additional Morning / Afternoon Tea","Secondary Additional Morning / Afternoon Tea","GST","Additional Adult Cost",null,"2025-01-11"]
[null,"Day visit",{"$f":"'2025 Fees'!F6","v":25},{"$f":"'2025 Fees'!F17","v":30},{"$f":"('2025 Fees'!$D6*50%)","v":5},{"$f":"('2025 Fees'!$D17*50%)","v":7.5},{"$f":"SUM('2025 Fees'!D6:E6)","v":10},{"$f":"SUM('2025 Fees'!D17:E17)","v":15},{"$f":"('2025 Fees'!$D6*30%)","v":3},{"$f":"('2025 Fees'!$D17*30%)","v":4.5},{"$f":"'2025 Fees'!$D$11","v":5.5},{"$f":"'2025 Fees'!$D$22","v":8.25},"Yes",{"$f":"('2025 Fees'!$D6)","v":10},null,"2025-01-12"]
[null,"3 Day Camp",{"$f":"'2025 Fees'!F7","v":177},{"$f":"'2025 Fees'!F18","v":228},{"$f":"('2025 Fees'!$D7*50%)","v":51},{"$f":"('2025 Fees'!$D18*50%)","v":76.5},{"$f":"SUM('2025 Fees'!D7:E7)","v":132},{"$f":"SUM('2025 Fees'!D18:E18)","v":183},{"$f":"('2025 Fees'!$D7*30%)","v":30.599999999999998},{"$f":"('2025 Fees'!$D18*30%)","v":45.9},{"$f":"'2025 Fees'!$D$11","v":5.5},{"$f":"'2025 Fees'!$D$22","v":8.25},"No",{"$f":"('2025 Fees'!$D7)","v":102},null,"2025-01-13"]
[null,"4 Day Camp",{"$f":"'2025 Fees'!F8","v":248},{"$f":"'2025 Fees'!F19","v":322},{"$f":"('2025 Fees'!$D8*50%)","v":74},{"$f":"('2025 Fees'!$D19*50%)","v":111},{"$f":"SUM('2025 Fees'!D8:E8)","v":193},{"$f":"SUM('2025 Fees'!D19:E19)","v":267},{"$f":"('2025 Fees'!$D8*30%)","v":44.4},{"$f":"('2025 Fees'!$D19*30%)","v":66.599999999999994},{"$f":"'2025 Fees'!$D$11","v":5.5},{"$f":"'2025 Fees'!$D$22","v":8.25},null,{"$f":"('2025 Fees'!$D8)","v":148},null,"2025-01-14"]
[null,"5 Day Camp",{"$f":"'2025 Fees'!F9","v":319},{"$f":"'2025 Fees'!F20","v":416},{"$f":"('2025 Fees'!$D9*50%)","v":97},{"$f":"('2025 Fees'!$D20*50%)","v":145.5},{"$f":"SUM('2025 Fees'!D9:E9)","v":254},{"$f":"SUM('2025 Fees'!D20:E20)","v":351},{"$f":"('2025 Fees'!$D9*30%)","v":58.199999999999996},{"$f":"('2025 Fees'!$D20*30%)","v":87.3},{"$f":"'2025 Fees'!$D$11","v":5.5},{"$f":"'2025 Fees'!$D$22","v":8.25},null,{"$f":"('2025 Fees'!$D9)","v":194},null,"2025-01-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-16"]
[null,1,2,3,4,5,6,7,8,9,10,11,null,null,null,"2025-01-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-18"]
[null,"Note:  If it changes back to a number of FOC adults per child then bbring formula back in from cell H30.",null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-20"]