{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INSTRUCTIONS","1. Info & Certification","2. Current Inventory","3. Herd Additions","4. Herd Deletions"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"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":"INSTRUCTIONS","index":0,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,0,3,4],[4,0,6,4],[7,0,9,4],[10,0,12,4],[16,0,16,8],[15,0,15,8]]}
["INSTRUCTIONS FOR COMPLETING ELECTRONICALLY:"]
["1. You will see tabs below.  Tab 1 is where you enter your farm information and certify that your inventory is accurate.  This is the only page that needs to be signed.  Please be sure to enter or select each field in YELLOW."]
[]
[]
["2. Tab 2 is where you will validate your current inventory."]
[]
[]
["3. Tab 3 is where you will list any Herd Additions."]
[]
[]
["4. Tab 4 is where you will list any Herd Deletions."]
[]
[]
[]
[]
["Helpful Tip"]
["** Click on \"1\" in the upper left hand corner (see yellow arrow on first image shown below) to view more rows for data entry after your information is completed at the top of the page for Current Herd Inventory, Herd Additions and Herd Deletions.\n\n** Click on \"+\" in the upper left hand corner (see yellow arrow on the second image shown below) to expand your top information again."]

{"sheet":"1. Info & Certification","index":1,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[10,1,10,2],[14,1,14,10],[11,1,11,12],[17,11,17,12],[18,11,18,12],[18,6,18,10],[18,3,18,5],[18,1,18,2],[15,2,15,12],[13,1,13,12],[12,1,12,12],[17,1,17,2],[17,3,17,5],[17,6,17,10],[0,1,0,12],[1,1,1,12],[3,1,3,2],[3,3,9,12],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[20,11,20,12],[21,1,21,2],[21,3,21,5],[21,6,21,10],[21,11,21,12],[20,1,20,2],[20,3,20,5],[20,6,20,10]]}
[null,"HERD INVENTORY CERTIFICATION"]
[null,"DATE"]
[]
[null,"Name",null,"Instructions:\n1) REVIEW THE INVENTORY INFORMATION ON THE CURRENT INVENTORY PAGE/TAB\n\n2) If current inventory is correct, Check or \"X\" \"No Changes\", then provide your title, print your name, sign and date this page/tab, and email or mail this page to your inspector.\n\n3) If changes within the herd have been made, Check or \"X\" all appropriate options, then provide your title, print your name, sign and date this page/tab, complete the forms for Additions to Herd and/or Deletions to Herd, and email or mail this page to your inspector.\n\n"]
[null,"Address"]
[null,"City, State, Zip"]
[null,"Premise ID"]
[null,"HMP or HCP"]
[]
[]
[null,"This inventory contains \n(Please Check those that apply):",null,"No Changes",null,null,"Additions",null,null,"Deletions"]
[null,"By checking the \"NO Changes\" box, you are indicating that there were no additions to your herd (i.e. you did not purchase deer and you did not have any deer born at your\npremise) AND you did not have any deletions to your herd (i.e. you did not sell deer, you did not have any deer die, you did not have any deer escape, stolen, or egressed)."]
[null,"Information regarding your deer herd had been prepopulated into the form as a courtesy. This information is from our inventory system and is based on your previously submitted inventory information.  Please review and update the information and make the changes necessary to account for the current inventory and proper identification of cervids currently in your herd. The cervid owner, personally or through your representative or agent, is responsible for ensuring that the inventory is complete and accurate when submitted.  "]
[null,"Participant Verification, Certification and Acknowledgment \nThe undersigned Participant(s) verifies, certifies, represents, affirms and warrants to the Commonwealth of Pennsylvania, Department of Agriculture, Bureau of Animal  Health and Diagnostic Services, that the undersigned Participant(s) has/have the power and authority to execute this Herd Inventory Report and thereby be bound to its terms or has been duly authorized by the Owner, if an individual of sole proprietorship, the Partners or if a corporation or LLC, the Board of Directors thereof to sign on behalf thereof and thereby bind that person, and the undersigned(s) thereby has/have authority to execute this Herd Inventory Report on behalf thereof. The undersigned Participant(s) further affirm(s) he/they have read and understand the provision of this Verification, Certification and Acknowledgment.  \n\nSignature instructions: Please sign below in the space provided applicable to your status as the Participant.  The owner or authorized representative subject to this Agreement are Participants and must sign. The owner(s) or person duly authorized to sign and bind the owner(s) must sign and date below and set forth their title. All persons with an ownership interest in the business subject to this Agreement are Participants and the signature(s) below binds them to the terms of this Agreement. Please note, Corporations must have the signature of the President or Vice President and the Secretary or Treasurer.  Partnerships must have the signatures of all partners.  If additional signature lines are needed, please sign below the lines and provide the necessary information.  SIGNATURES MUST BE ORIGINAL. Electronic inventories may have electronic signatures.\n\nIN WITNESS WHEREOF, the Parties have executed this Agreement intending to be bound hereby."]
[null,"I hereby certify that all the info contained in this inventory is complete and accurate to date (Provide your title, print your name, sign, and date)."]
[null,null,"By placing an \"X\" in this box you agree that the \"electronic signature\" below is equivalent to your hand written signature."]
[]
[]
[null,"Title (Owner, President, etc.)",null,"Print Name",null,null,"Signature",null,null,null,null,"Date"]
[]
[]
[null,"Title (Owner, President, etc.)",null,"Print Name",null,null,"Signature",null,null,null,null,"Date"]

{"sheet":"2. Current Inventory","index":2,"n_rows":114,"n_cols":10,"rows_kept":114,"cut":false,"hidden":false,"merged":[[1,1,1,9],[11,0,11,9],[0,0,0,9],[3,4,9,9],[8,0,8,2],[3,0,3,3],[4,0,4,3],[5,0,5,3],[6,0,6,3],[7,0,7,3]]}
["CURRENT HERD INVENTORY AS OF"]
[null,{"$f":"'1. Info & Certification'!$B$2","v":"DATE"}]
[]
[{"$f":"'1. Info & Certification'!$B$4","v":"Name"},null,null,null,"Instructions:\n1) REVIEW THE INVENTORY INFORMATION ON THIS PAGE/TAB.\n\n2) If current inventory is correct, Select \"No Changes\" on the Info & Certification Page/Tab, then sign/date, and send to your inspector. \n\n3) If HMP, provide estimated number of animals to the left in the yellow highlighted section. Provide the below information for any of the animals included in the estimate that have identification.\n\n4) If changes within the herd have been made, select the appropriate option on the Info & Certification Page/Tab, then sign/date, complete the forms for Additions to Herd and/or Deletions to Herd, and then send to your inspector."]
[{"$f":"'1. Info & Certification'!$B$5","v":"Address"}]
[{"$f":"'1. Info & Certification'!$B$6","v":"City, State, Zip"}]
[{"$f":"'1. Info & Certification'!$B$7","v":"Premise ID"}]
[{"$f":"'1. Info & Certification'!$B$8","v":"HMP or HCP"}]
["HMP - Estimated number of animals:"]
[]
[null,"Remove ","Official ID","Additional ID","Species","Sex (M/F)","Age (YRS)","DOB","Retagged","Retag #"]
["**EXAMPLE**"]
["*",null,123456789123456,"GREEN 578","WHITETAIL","M",3,"2015-06-19","X",789456123789123]
["*","X",456123789123456,"RED 64","WHITETAIL","F",3,"2015-06-19"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[{"$f":"A22+1","v":9}]
[10]
[{"$f":"A24+1","v":11}]
[{"$f":"A25+1","v":12}]
[{"$f":"A26+1","v":13}]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[{"$f":"A90+1","v":77}]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"3. Herd Additions","index":3,"n_rows":113,"n_cols":12,"rows_kept":113,"cut":false,"hidden":false,"merged":[[0,0,0,11],[10,0,10,11],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[5,0,5,5],[6,0,6,4],[7,0,7,4],[1,6,8,11]]}
["HERD ADDITIONS"]
[{"$f":"'1. Info & Certification'!$B$4","v":"Name"},null,null,null,null,null,"Instructions:\n1)  ALL FIELDS ARE REQUIRED FOR ADDED ANIMALS. YOUR INVENTORY WILL BE RETURNED IF THERE ARE INCOMPLETE FIELDS.\n\n2) If any animal was purchased, a newborn, or ingressed,  \"X\" the appropriate box and complete ALL boxes to the right. \n\n3) If HCP, list total number of natural births added to the herd since last inventory that are less than 12 months of age and have received no ID. List this information to the left in the yellow highlighted section. Also, individually list all animals added to your herd that are 12 months of age or older.\n\n4) If HMP, provide estimated number of newborns without any ID.  List this information to the left in the yellow highlighted section. If animals are identified with an ID, please provide this information below.\n\n                                        **Newborns: Born on your farm since last annual inventory submitted**\n                          You do not need to return the HERD ADDITIONS form if you do not have any additions.\n                               Inventories will NOT be accepted and reviewed unless ALL FIELDS ARE COMPLETE."]
[{"$f":"'1. Info & Certification'!$B$5","v":"Address"}]
[{"$f":"'1. Info & Certification'!$B$6","v":"City, State, Zip"}]
[{"$f":"'1. Info & Certification'!$B$7","v":"Premise ID"}]
[{"$f":"'1. Info & Certification'!$B$8","v":"HMP or HCP"}]
["HCP - Total number of natural births added to the herd since last inventory that are less than 12 months of age and have received \nno ID."]
["HMP - Estimated number of \nnewborns without ID:"]
[]
[null,"Purchased","Newborn","Ingressed","Official ID","Additional ID","Species","Sex\n(M/F)","Age\n(YRS)","DOB","Purchase Date","Purchased From \n(Premise ID, Name, Address, Phone, Email)"]
["***EXAMPLE***"]
["*","X",null,null,123456789123456,"GREEN 578","WHITETAIL","M",3,"2015-04-08","2018-06-14","PA1234AZ                Ben Ritter\n123 Barn Drive, Delta, PA 17314\n717-637-5924               RitterB@gmail.com"]
["*",null,"X",null,456123789123456,"RED 64","WHITETAIL","F",0,"2018-05-19"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"4. Herd Deletions","index":4,"n_rows":113,"n_cols":13,"rows_kept":113,"cut":false,"hidden":false,"merged":[[10,0,10,12],[0,0,0,12],[1,0,1,6],[2,0,2,6],[3,0,3,6],[4,0,4,6],[5,0,5,6],[6,0,6,5],[1,7,8,12]]}
["HERD DELETIONS"]
[{"$f":"'1. Info & Certification'!$B$4","v":"Name"},null,null,null,null,null,null,"Instructions:\n1)  ALL FIELDS ARE REQUIRED FOR DELETED/DEAD/ESCAPE/THEFT ANIMALS. YOUR INVENTORY WILL BE RETURNED IF THERE ARE INCOMPLETE FIELDS.\n\n2) If any animal was sold, died, escaped, or was stolen, \"X\" the appropriate box and complete ALL proceeding boxes to the right.\n \n3) If HCP, provide DOB.\n\n4) If HMP, provide DOB or if DOB is unknown, document in the DOB column if the animal is less than or greater than 12 months of age. Provide estimated number of animals without ID and less than 12 months of age that died. List this information to the left in the yellow highlighted section.\n\n5) Any animal listed with an ID number on your current inventory  or previous inventory that has left the herd must be documented on this Herd Deletions page/tab regardless of the age.\n\n                     You do not need to return the HERD DELETIONS form if you do not have any deletions.\n                         Inventories will NOT be accepted and reviewed unless ALL FIELDS ARE COMPLETE."]
[{"$f":"'1. Info & Certification'!$B$5","v":"Address"}]
[{"$f":"'1. Info & Certification'!$B$6","v":"City, State, Zip"}]
[{"$f":"'1. Info & Certification'!$B$7","v":"Premise ID"}]
[{"$f":"'1. Info & Certification'!$B$8","v":"HMP or HCP"}]
["HMP: Estimated number of animals \nwithout ID and less than 12 months \nof age that died:"]
[]
[]
[null,"Sold (S)","Died (D)","Escaped (E)","Theft (T)","Official ID","Additional ID","Species","Sex \n(M/F)","DOB","If sold, record Premise ID, Name, Address, Phone, Email. If animal died, write \"died\" or \"hunted/harvested,\" or \"culled.\"","Date of Removal\nor Death","Lab \nAccession #"]
["***EXAMPLE***"]
["*","X",null,null,null,123456789123456,"GREEN 578","WHITETAIL","M","2016-04-08","PA1234AZ                Ben Ritter\n123 Barn Drive, Delta, PA 17314\n717-637-5924               RitterB@gmail.com","2018-09-25"]
["*",null,"X",null,null,456123789123456,"RED 64","WHITETAIL","F","2018-05-19",null,"2018-07-14",12345678]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]