{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Adoption Promo Worksheet"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"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":"Adoption Promo Worksheet","index":0,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,5,1,8],[32,0,32,10],[2,1,2,3],[2,5,2,7],[17,1,17,3],[17,5,17,7],[30,0,30,10],[31,0,31,10],[1,0,2,0],[1,1,1,3]]}
["Form instructions: complete all the Green cells (all others are locked) and see the impact of your Event."]
["Agency Name","   Dates:   ",null,null,null,"  Dates:"]
[null,"Base-line Weekend/Period (from same Season this year)",null,null," Total","Adoption Campaign Weekend/Period",null,null,"Total","Difference","% change"]
["Day of the Week:"]
["Total Visitors",null,null,null,{"$f":"SUM(B5:D5)","v":0},null,null,null,{"$f":"SUM(F5:H5)","v":0},{"$f":"+I5-E5","v":0},{"$f":"IF(J$5>0,+J5/E5,\"-\")","v":"-"}]
["# of hours open for adoption",null,null,null,{"$f":"SUM(B6:D6)","v":0},null,null,null,{"$f":"SUM(F6:H6)","v":0},0,{"$f":"IF(J$5>0,+J6/E6,\"-\")","v":"-"}]
["Avg # Visitors/Hour",{"$f":"IF(B5>0, +B5/B6, \"-\")","v":"-"},{"$f":"IF(C5>0, +C5/C6, \"-\")","v":"-"},{"$f":"IF(D5>0, +D5/D6, \"-\")","v":"-"},"-","-","-","-","-",{"$f":"IF(J5>0, +I7-E7, \"-\")","v":"-"},{"$f":"IF(J$5>0,+J7/E7,\"-\")","v":"-"}]
["Cat Adoption Total",null,null,null,{"$f":"SUM(B8:D8)","v":0},null,null,null,{"$f":"SUM(F8:H8)","v":0},0,{"$f":"IF(J$12>0,+J8/E8,\"-\")","v":"-"}]
["Kitten Adoption Total",null,null,null,{"$f":"SUM(B9:D9)","v":0},null,null,null,{"$f":"SUM(F9:H9)","v":0},0,{"$f":"IF(J$12>0,+J9/E9,\"-\")","v":"-"}]
["Dog Adoptions Total",null,null,null,{"$f":"SUM(B10:D10)","v":0},null,null,null,{"$f":"SUM(F10:H10)","v":0},0,"-"]
["Puppy Adoption Total",null,null,null,{"$f":"SUM(B11:D11)","v":0},null,null,null,{"$f":"SUM(F11:H11)","v":0},0,"-"]
["Total Adoptions",{"$f":"SUM(B8:B11)","v":0},0,0,0,0,0,0,0,0,"-"]
["Avg # Adoptions/Hour",{"$f":"IF(B12>0,+B12/B6,\"-\")","v":"-"},{"$f":"IF(C12>0,+C12/C6,\"-\")","v":"-"},"-","-","-","-","-","-",{"$f":"IF(J12>0,+I13-E13,\"-\")","v":"-"},"-"]
["Adoption Revenue",null,null,null,{"$f":"SUM(B14:D14)","v":0},null,null,null,{"$f":"SUM(F14:H14)","v":0},0,"-"]
["Donations On-Site",null,null,null,{"$f":"SUM(B15:D15)","v":0},null,null,null,{"$f":"SUM(F15:H15)","v":0},0,"-"]
["Gift Shop Revenue",null,null,null,{"$f":"SUM(B16:D16)","v":0},null,null,null,{"$f":"SUM(F16:H16)","v":0},0,"-"]
[]
[null,"Previous year’s baseline data                                                                              (for same weekend/period as Adoption Event dates this year)",null,null,null,"Adoption Campaign Weekend/Period"]
["Day of the Week:"]
["Cat Adoption Total",null,null,null,{"$f":"SUM(B20:D20)","v":0},{"$f":"+F8","v":0},0,0,{"$f":"SUM(F20:H20)","v":0},{"$f":"+I20-E20","v":0},{"$f":"IF(J20>0,+J20/E20,\"-\")","v":"-"}]
["Kitten Adoption Total",null,null,null,0,0,0,0,0,0,{"$f":"IF(J21>0,+J21/E21,\"-\")","v":"-"}]
["Dog Adoptions Total",null,null,null,0,0,0,0,0,0,"-"]
["Puppy Adoption Total",null,null,null,0,0,0,0,0,0,"-"]
["Total Adoptions",{"$f":"SUM(B20:B23)","v":0},{"$f":"SUM(C20:C23)","v":0},{"$f":"SUM(D20:D23)","v":0},0,0,0,0,0,0,"-"]
["# of hours open for adoption",null,null,null,0,{"$f":"+F6","v":0},{"$f":"+G6","v":0},{"$f":"+H6","v":0},0,0,"-"]
["Avg # Adoptions/Hour",{"$f":"IF(B24>0,+B24/B25,\"-\")","v":"-"},{"$f":"IF(C24>0,+C24/C25,\"-\")","v":"-"},"-","-","-","-","-","-",{"$f":"IF(J25>0,+I26-E26,\"-\")","v":"-"},{"$f":"IF(J25>0,+J26/E26,\"-\")","v":"-"}]
["Adoption Revenue",null,null,null,{"$f":"SUM(B27:D27)","v":0},{"$f":"+F14","v":0},{"$f":"+G14","v":0},{"$f":"+H14","v":0},{"$f":"SUM(F27:H27)","v":0},0,"-"]
["Gift Shop Revenue",null,null,null,{"$f":"SUM(B28:D28)","v":0},{"$f":"+F16","v":0},{"$f":"+G16","v":0},{"$f":"+H16","v":0},{"$f":"SUM(F28:H28)","v":0},0,"-"]
[]
["Description of the Event/Promotion:"]