{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Hog Information Form","Export","Properties (Data)"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":27,"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":"Hog Information Form","index":0,"n_rows":72,"n_cols":7,"rows_kept":72,"cut":false,"hidden":false,"merged":[[71,0,71,8],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[67,0,69,8],[41,5,41,6],[42,5,42,6],[26,5,26,6],[27,5,27,6],[21,5,21,6],[22,5,22,6],[35,5,35,6],[0,0,0,10],[3,4,3,5],[4,0,4,3],[4,4,4,5],[3,6,3,10],[4,6,4,10],[23,5,23,6],[24,5,24,6],[25,5,25,6],[2,0,2,10],[7,1,7,6],[8,1,8,6],[60,5,60,6],[63,0,63,9],[48,5,48,6],[49,5,49,6],[40,5,40,6],[43,5,43,6],[44,5,44,6],[36,5,36,6],[37,5,37,6],[38,5,38,6],[39,5,39,6],[28,5,28,6],[29,5,29,6],[33,5,33,6],[34,5,34,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[64,0,64,8],[65,0,65,8],[1,0,1,10],[55,5,55,6],[56,5,56,6],[57,5,57,6],[58,5,58,6],[59,5,59,6],[50,5,50,6],[51,5,51,6],[52,5,52,6],[53,5,53,6],[54,5,54,6],[45,5,45,6],[46,5,46,6],[47,5,47,6]]}
["2021 Canada-Alberta Hog Recovery Initiative"]
["Hog Feed Maintenance Component\nHog Information Form"]
["Submit one application, per producer, covering all hogs owned and impacted between Feb 8, 2021 - Mar 31, 2021"]
["Identification Number",null,null,null,"Subscription",null,"AgriStability Pin"]
[]
[]
[]
["Legal Name"]
["Email "]
[]
[null,null,"Premises ID","Number of Eligible Hogs that were delayed from being marketed","Scheduled marketing date\nmmm-dd-yyyy ","Actual or estimated marketing date\nmmm-dd-yyyy"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[]
["Premise ID - Add Premise ID for the location of the animals being applied for"]
["Number of Eligible Hogs that were delayed from being marketed - List hogs that were normally scheduled to be shipped to Olymel and were delayed "]
["Scheduled marketing date - Had Olymel remained open what would have been the date these hogs would have been shipped"]
["Actual or estimated marketing date - the actual date the hogs were delivered to Olymel, or if not shipped the projected date"]
[]
["By selecting the Save button you agree to the Terms & Conditions of the 2021 Canada-Alberta Hog Recovery Initiative and will submit your application form to AFSC by email at AgriRecovery@afsc.ca"]
[]
[]
[]
["Completed applications may be submitted to AFSC through email to AgriRecovery@afsc.ca.  All applications must be received by AFSC no later than 11:59 p.m. on March 25, 2021 to be considered for this initiative."]

{"sheet":"Export","index":1,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["2021-03-17","jimtest",234423,324432234,4,"A12345678",26,"2021-02-08","2021-02-28"]
["2021-03-17","jimtest",234423,324432234,4,"A12345679",26,"2021-02-08","2021-02-28"]
["2021-03-17","jimtest",234423,324432234,4,"A12345671",26,"2021-02-08","2021-02-28"]
["2021-03-17","jimtest",234423,324432234,4,"A12345672",26,"2021-02-08","2021-02-28"]
["2021-03-17","jimtest",234423,324432234,4,"A12345673",26,"2021-02-08","2021-02-28"]

{"sheet":"Properties (Data)","index":2,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":true,"merged":[[0,3,0,4]]}
["Common Properties",null,null,"Local Properties"]
["Property","Value",null,"Property","Value",null,"crop_year",{"$f":"VLOOKUP(\"CropYear\",LocalProperties[],2)","v":2021}]
["ReplyEmailAddress","AgriRecovery@afsc.ca ",null,"CropYear",2021]
["LogoFile","CAP AFSC AB CAN bw.jpg",null,"Email.To"]
["CommonDataFile","ManualCalcCommonData",null,"Email.Subject"," AgriRecovery Hog Recovery Initiative"]
["ModuleName","CalculatorMacros.code",null,"Email.Body","Attached to this email is a copy of the second part of the Canada-Alberta Hog Recovery Initiative Application Form. Please input your Hog data, if you need to stop inputting data so you can finish it at a later time select the button \"Save Draft\". This will save a draft copy to your desktop that you can reopen and continue inputting data until you have completed your form. When you have input all your data select the \"Save Final\" button. This will save your completed form to your desktop and lock it so no changes can be made. You will need to email the Final workbook to AgriRecovery@afsc.ca."]
[null,null,null,"email.cc"]
[null,null,null,"email.bcc"]
[null,null,null,"HE Factor",null,null,null,"Modication History"]
[null,null,null,"PowerUsers",null,null,null,"2021-03-03","Martine West","Created Calc"]
[null,null,null,"DefaultPDFDir"]
[null,null,null,"DeadlineComment","The Deadline to apply, cancel and/or make changes to your Application is March 31, 2021"]
[null,null,null,"WorkBookName"]
[null,null,null,"Path to save file to email to client","S:\\DEVELOP\\Manual Calculators\\2021 WIP\\Test Hog Recovery\\HogInfoFormClient\\"]
[null,null,null,"Path to save final application to","S:\\DEVELOP\\Manual Calculators\\2021 WIP\\Test Hog Recovery\\ExportHogInfoFormFinal\\"]
[null,null,null,"Summary WB Location for test","S:\\DEVELOP\\Manual Calculators\\2021 WIP\\Test Hog Recovery\\Master Spreadsheet\\"]
[]
[]
[null,null,null,null,"2021 Canada-Alberta Hog Recovery Initiative - Initial Benefit Paid.xlsm"]
[null,null,null,null,"Canada-Alberta Hog Recovery Initiative Hog Information Form.xlsm"]
[]
[]
[null,null,null,null,"S:\\DEVELOP\\Manual Calculators\\2021 WIP\\"]
[]
[]
[null,null,null,null,"S:\\DEVELOP\\Manual Calculators\\2021 WIP\\"]
[]
[]
[]
[]
[]
[null,null,null,null,"\\\\AFSC.ads\\LC\\HOME\\CAIS\\Commercial Loan Annual Review\\AgriRecovery HOG\\"]
[]
[null,null,null,null,"\\\\AFSC.ads\\LC\\HOME\\CAIS\\Commercial Loan Annual Review\\AgriRecovery HOG\\ExportHogInfoFormFinal",null,"FinalForm"]
[]
[null,null,null,null,"\\\\AFSC.ads\\LC\\HOME\\CAIS\\Commercial Loan Annual Review\\AgriRecovery HOG\\HogInfoFormClient",null,"ClientForm"]
[]
[null,null,null,null,"\\\\AFSC.ads\\LC\\HOME\\CAIS\\Commercial Loan Annual Review\\AgriRecovery HOG\\Master Spreadsheet\\",null,"Master"]