{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Page 1","Page 2","Page 3","Page 4","Page 5","Page 6","Page 7","Instructions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":8,"comments":2,"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":"Page 1","index":0,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[[11,2,11,4],[15,2,15,4],[19,2,19,4],[23,2,23,4]]}
[]
[]
[null,null,null,"PBGVCA HUNT TEST REPORT"]
[]
[]
[]
[]
[]
[]
[]
[]
["EVENT NAME:"]
[]
[]
[]
["EVENT TYPE:   ",null,"LICENSED HUNT TEST"]
[]
[]
[]
["EVENT HOSTED by:"]
[]
[]
[]
["LOCATION:"]
[]
[]
[null,null,"Day 1","Day 2","Day 3"]
["DATE(s) of EVENT:  ",null,null,null,"Date"]
[null,null,"Enter hunt dates only, not pratice date."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Roscoe, IL "]
[null,null,"Carlisie, PA"]
[null,null,"Concord, NC"]
[null,null,"Elmer, NJ",null,"PBGVCA"]
[null,null,"Fleming, NJ",null,"MID NJ PBGVA"]
[null,null,"Ladonia, TX",null,"Carolinas PBGVC"]
[null,null,"Platteville, WI"]
[null,null,"Royal Center, IN"]
[null,null,"Seneca, SC"]
[null,null,"Stroudsbur, PA"]
[null,null,"Townville, SC"]
[null,null,"Upland, IN"]
[null,null,"Wisconsin Rapids, WI"]
[null,null,"Gallipolis, OH"]

{"sheet":"Page 2","index":1,"n_rows":33,"n_cols":18,"rows_kept":33,"cut":false,"hidden":false,"merged":[[27,2,27,5],[29,2,29,5],[33,0,41,5],[15,2,15,5],[17,2,17,5],[19,2,19,5],[21,2,21,5],[23,2,23,5],[25,2,25,5],[13,3,13,5],[0,0,0,2],[0,3,0,5],[4,2,4,5],[12,0,12,2],[12,3,12,5]]}
["Event Committee",null,null,"Present on Event Day"]
[null,"Name","Title",{"$f":"'Page 1'!C28","v":"00:00:00"},{"$f":"'Page 1'!D28","v":"00:00:00"},{"$f":"'Page 1'!E28","v":"Date"}]
["1.",null,"Chairperson",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YES"]
["2.",null,"Secretary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO"]
[]
["3."]
["4."]
["5."]
["6."]
["7."]
["8."]
[]
["Judges",null,null,"Judged on Event Day"]
[null,"Name","Advertised/Alternate/Substitute"]
[]
["1.","Address:"]
[]
["2.","Address:"]
[]
["3.","Address:"]
[]
["4.","Address:"]
[]
["5.","Address:"]
[]
["6.","Address:"]
[]
["7.","Address:"]
[]
["8.","Address:"]
[]
[]
["If substitute or additional judges were appointed, please state the reason [ENTER BELOW]."]

{"sheet":"Page 3","index":2,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,5,1,5],[10,5,11,5],[20,5,21,5],[1,0,2,0],[10,2,11,4],[11,0,12,0],[20,2,21,4],[21,0,22,0],[0,1,1,1],[10,1,11,1],[20,1,21,1],[0,2,1,4]]}
["Hounds Tested on","HIT","HUNT",null,null,"Total    "]
[{"$f":"'Page 1'!C28","v":"00:00:00"}]
[null,"Pack or Brace","Solo","Brace","Pack","  HIT + HUNT"]
["Hounds entered",0,{"$f":"K12","v":0},{"$f":"L12","v":0},{"$f":"M12","v":0},{"$f":"SUM(B4:E4)","v":0}]
["Hounds started",0,0,0,0,{"$f":"SUM(B5:E5)","v":0}]
["Hounds passed",0,0,0,0,{"$f":"SUM(B6:E6)","v":0}]
[]
[]
[]
[]
["Hounds Tested on","HIT","HUNT",null,null,"Total    "]
[{"$f":"'Page 1'!D28","v":"00:00:00"}]
[null,"Pack or Brace","Solo","Brace","Pack","  HIT + HUNT"]
["Hounds entered",0,{"$f":"K22","v":0},{"$f":"L22","v":0},{"$f":"M22","v":0},{"$f":"SUM(B14:E14)","v":0}]
["Hounds started",0,0,0,0,{"$f":"SUM(B15:E15)","v":0}]
["Hounds passed",0,0,0,0,{"$f":"SUM(B16:E16)","v":0}]
[]
[]
[]
[]
["Hounds Tested on","HIT","HUNT",null,null,"Total    "]
[{"$f":"'Page 1'!E28","v":"Date"}]
[null,"Pack or Brace","Solo","Brace","Pack","  HIT + HUNT"]
["Hounds entered",{"$f":"J32","v":0},0,0,0,{"$f":"SUM(B24:E24)","v":0}]
["Hounds started",0,0,0,0,{"$f":"SUM(B25:E25)","v":0}]
["Hounds passed",0,0,0,0,{"$f":"SUM(B26:E26)","v":0}]
[]
["Total Hounds entered",{"$f":"B24+B14+B4","v":0},0,0,0,{"$f":"F24+F14+F4","v":0}]
["Total Hounds started",{"$f":"B5+B15+B25","v":0},0,0,0,{"$f":"F5+F15+F25","v":0}]
["Total Hounds passed",{"$f":"SUM(B38+B26+B16+B6)","v":0},{"$f":"SUM(+C26+C16+C6)","v":0},{"$f":"SUM(+D26+D16+D6)","v":0},{"$f":"SUM(+E26+E16+E6)","v":0},{"$f":"SUM(+F26+F16+F6)","v":0}]
[]
[]
[]
["Note: PBGVCA recording fee based on total hounds entered  in hunt (F28)."]
["PBGVCA Fee =",{"$f":"3*F28","v":0}]

{"sheet":"Page 4","index":3,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,3,0,6]]}
[null,null,null,"PBGVs who Passed the HIT & Hunt Test - Day 1"]
[]
["Date","Location","AKC Name","AKC#","Owners","Stake","Score","Judge 1","Judge 2"]

{"sheet":"Page 5","index":4,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,3,0,6]]}
[null,null,null,"PBGVs who Passed the HIT & Hunt Test - Day 2"]
[]
["Date","Location","AKC Name","AKC#","Owners","Stake","Score","Judge 1","Judge 2"]

{"sheet":"Page 6","index":5,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"PBGVs who Passed the HIT & Hunt Test - Day 3"]
[]
["Date","Location","AKC Name","AKC#","Owners","Stake","Score","Judge 1","Judge 2"]

{"sheet":"Page 7","index":6,"n_rows":44,"n_cols":20,"rows_kept":44,"cut":false,"hidden":false,"merged":[[18,0,18,1],[43,0,43,8],[38,3,38,5],[30,0,34,9],[20,0,20,6],[21,0,24,10],[25,0,29,10],[37,2,37,6],[39,2,39,4]]}
[]
[null,"HUNT TEST SECRETARY’S REPORT CONTENT CHECK LIST:"]
[]
[null,"Cover Sheet"]
[null,"Event Committee and Judges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,"Count of Hounds passing HIT and HUNT tests"]
[null,"PBGV’s Passing HIT & Hunt Test - Day 1"]
[null,"PBGV’s Passing HIT & Hunt Test - Day 2"]
[null,"PBGV’s Passing HIT & Hunt Test - Day 3 (if necessary)"]
[null,"Check List and Instructions",null,null," - Secretaries' signature"]
[null,"Signed Judges score sheets for HIT & HUNT tests "]
[null,"Chairperson’s Daily Reports"]
[null,"Printed copies of Hunt Test Results from each day"]
[null,"Entry forms of all hounds entered "]
[null,"Copies of all “Official Summary” of HIT & HUNT Scores"]
[null,"Any other Forms or Documents required by the Hunt Test Rules and Standard Procedures"]
[null,"Mail complete report to PBGVCA within 30 days"]
[]
["Official Rules State:"]
[]
["Chapter 10: Judges' Books and Hunt Test Reports"]
["At the conclusion of the judging of each test, the club shall provide for the Judges' signatures paperwork showing the type of test, class(s) and the full particulars and scores of each hound judged. At the conclusion of the Hunt Test, the Hunt Test Secretary shall verify the Judges' signatures for the respective test."]
[]
[]
[]
["The Hunt Test secretary is responsible for assembling the PBGVCS Hunt Test Report which shall include a copy of all signed Judges Score Sheets, a document stating the number of dogs started, the number of dogs passing and a list of passing dogs by registered name and number, together with all the entry forms, and a full report of the trial which shall be sent to The PBGVCA postmarked no later than thirty (30) days after the date of the test. "]
[]
[]
[]
[]
["The report shall contain a cover sheet with the event name, date and location, the report shall include a list of the names of all members of the Hunt Test Committee with a notation of those who were present at the trial, a list of the names and addresses of the advertised judges and the names and complete addresses of any substitute Judges with a reason given for the substitution and the name and address of the Test Secretary."]
[]
[]
[]
[]
[]
[]
[null,"Signiture"]
[null,"Secretary",null,{"$f":"'Page 2'!B4","v":0}]
[null,"Date"]
[]
["SEND REPORT TO PBGVCA HUNT RECORDS ARCHIVIST  WITHIN 30 DAYS"]
["The Hunt Records Archivist’s name and address can be found at:"]
["http://www.pbgv.org/BreedInfo/hunt-main.shtml"]

{"sheet":"Instructions","index":7,"n_rows":54,"n_cols":4,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,2,43,3],[49,2,49,3],[7,2,7,3],[19,2,19,3],[23,2,23,3],[32,2,32,3],[37,2,37,3],[42,2,42,3],[44,2,44,3]]}
[]
[null,null,null,"Instructions for filling out PBGVCA Hunt Test Report:"]
[]
[null,null,null,"After opening PBGVCA Hunt Test Report, save with unique name such as HTR+date"]
[]
[null,null,null,"Security Warning – Click Options then enable this content."]
[]
[null,1," Cover  sheet (page 1)"]
[null,null,"a"," Fill in Event Name"]
[null,null,"b"," Fill in Name of Organization hosting event, use dropdown menu"]
[null,null,"c","Fill in Location of event, use dropdown menu"]
[null,null,"d"," Type in date with format = 2014/05/21 - hunt date only, not practice date."]
[null,2,null,"2.       Event Committee (page 2)"]
[null,null,"a"," Dates are automatically transferred form cover sheet "]
[null,null,"b"," Fill in names of Chairperson and Secretary"]
[null,null,"c"," Check attendance boxes for each day as appropriate"]
[null,null,"d"," Fill in Secretary’s  address"]
[null,null,"e"," Fill in Names and Titles of committee members"]
[null,null,"f","  Check attendance boxes for each day as appropriate"]
[null,3," Judges (page 2)"]
[null,null,"a","Fill in names and addresses and use pull down menu to fill in  advertised, alternate, or substitute "]
[null,null,"b","Check “Judged on Event Day” boxes for each day as appropriate"]
[null,null,"c","Explain reason for substitute if necessary"]
[null,4,"Hounds Tested (page 3)"]
[null,null,"a","Dates are automatically transferred from page 1"]
[null,null,"b"," In Excel, open Event Record Workbook for 1st test day and select the Q Numbers sheet"]
[null,null,"c","Copy number of hounds entered, started, and passed for HIT, Solo, Brace, and Pack (cell B4:E6)"]
[null,null,"d","Using Paste Special command, paste values only into PBGVCA Hunt Test Report, page 3, in day 1 table (cells B4:E6)"]
[null,null,"e","In Excel, open Event Workbook for 2nd test day and select the Q Numbers sheet"]
[null,null,"f","Copy number of hounds entered, started, and passed for HIT, Solo, Brace, and Pack (cell B4:E6)"]
[null,null,"g"," Using Paste Special command, paste values only into PBGVCA Hunt Test Report, page 3, in day 2 table (cells B4:E6)"]
[null,null,null," Repeat for additional days"]
[null,5,"PBGV’s  passing HIT & Hunt Test – Day 1 (page 4)"]
[null,null,"a"," In Excel, open Event Workbook for 1st test day and select the Q Record sheet"]
[null,null,"b","Click  Macro Button  “RESULTS” "]
[null,null,"c","Copy all the data from\"Date\" to \"Judge 2\", exclude header row"]
[null,null,"d","  Using Paste Special command, paste values only into PBGVCA Hunt Test Report, page 4, Cell A4"]
[null,6,"PBGV’s  passing HIT & Hunt Test – Day 2 (page 5)"]
[null,null,"a"," In Excel, open Event Workbook for 2nd test day and select the Q Record sheet"]
[null,null,"b","Click  Macro Button  “RESULTS” "]
[null,null,"c","Copy all the data from\"Date\" to \"Judge 2\", exclude header row"]
[null,null,"d","  Using Paste Special command, paste values only into PBGVCA Hunt Test Report, page 4, Cell A4"]
[null,7,"Repeat above steps for additional day (page 6)"]
[null,8,"Print report, pages 1 – 7 "]
[null,9,"Print report for Hunt Records Archivist - \"Hunt Test Results\""]
[null,null,"a"," In Excel, open Event Workbook for 1st test day and select the Hunt Test Results sheet"]
[null,null,"b","Print report (2 pages)"]
[null,null,"c"," In Excel, open Event Workbook for 2nd test day and select the Hunt Test Results sheet"]
[null,null,"d","Print report (2 pages)"]
[null,10,"Hunt Test Secretary – "]
[null,null,"a","Review check list (page 7), attach all required forms and sign and date report "]
[null,null,"b","Mail to: HUNT RECORDS ARCHIVIST "]
[null,null,null,"The Hunt Records Archivist’s name and address can be found at:"]
[null,null,null,"http://www.pbgv.org/BreedInfo/hunt-main.shtml"]