{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Info","Refund Request","Summary","Instructions","References"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":56,"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":"Info","index":0,"n_rows":40,"n_cols":40,"rows_kept":40,"cut":false,"hidden":false,"merged":[[24,23,24,32],[36,13,36,31],[39,1,39,32],[31,1,32,7],[4,1,4,32],[19,8,19,32],[26,8,26,15],[21,21,21,22],[28,8,28,32],[21,8,21,16],[21,23,21,27],[21,28,21,32],[21,17,21,20],[11,26,11,32],[13,8,13,32],[26,25,26,32],[11,8,11,14],[16,12,16,19],[16,25,16,32],[23,23,23,32]]}
[]
[]
[]
[]
[null,"$2.00 Alberta Service Charge Refund Request Form"]
[]
[null,"Refund requests for the period January 1 until June 30 of the current calendar year are due "]
[null,"in the ABP office by July 31 for processing in August and will be paid by October 31.  "]
[null,"Refund request for the period July 1 until December 31 of the current calendar year are due"]
[null,"in the ABP office by Januaray 31, for processing in February and will be paid by April 30.  "]
[]
[null,"Date of Request ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Refund Period"]
[]
[null,"Name of Producer"]
[null,null,null,null,null,null,null,null,"Name of Company or Producer who paid the checkoff"]
[]
[null,"Contact Name",null,null,null,null,null,null,"First Name",null,null,null,null,null,null,null,null,null,null,null,null,"Last Name"]
[null,null,null,null,null,null,null,null,"(If a company or partnership, please specify the person authorized to sign on behalf of the company)"]
[]
[null,"Address"]
[]
[null,"Town, City",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Province ",null,null,null,"AB",null,"Postal Code   "]
[]
[null,"County, Municipality, I.D. or Special Area of Residence"]
[null,"County, Municipality, I.D. or Special Area of Primary Operations "]
[]
[null,"Telephone Number"]
[]
[null,"E-mail Address"]
[]
[null,"I am predominantly a:",null,null,null,null,null,null,null,null,"Cow Calf Producer",null,null,null,null,null,null,null,null,null,"Backgrounder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false]
[null,"(select any that apply)"]
[null,null,null,null,null,null,null,null,null,null,"Feedlot",null,null,null,null,null,null,null,null,null,"Custom Feedlot",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false]
[]
[null,null,null,null,null,null,null,null,null,null,"Licenced Dealer",null,null,null,null,null,null,null,null,null,"Auction Market",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false]
[]
[null,null,null,null,null,null,null,null,null,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(please describe here if other)"]
[]
[null,"Ready"]

{"sheet":"Refund Request","index":1,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[4,3,4,5],[5,3,5,5]]}
[]
[]
[]
[]
["ABP Detailed Refund Request",null,"Requested by ",{"$f":"GetProducerName(FirstName, LastName, NameOfProducer)","v":" "}]
[null,null,"Period",{"$f":"IF(RefundPeriod1=1,\"January to June\",\"July to December\")","v":"January to June"}]
[null,null,null,null,"(Total @ $2.00 / Head) ",{"$f":"I11*2","v":0}]
[]
[null,null,null,null,null,"ABP Checkoff",null,null,"# of Head"]
["Purchaser or Dealer","Document #","Date","# Head","% ","Paid",null,null,"when % Applied"]
[null,null,null,{"$f":"SUM(D13:D50)","v":0},null,{"$f":"SUM(F13:F50)","v":0},null,null,{"$f":"SUM(I13:I50)","v":0}]
[]
[null,null,null,null,1,{"$f":"D13*E13*4.5","v":0},null,null,{"$f":"D13*E13","v":0}]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,{"$f":"D32*E32*4.5","v":0},null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,{"$f":"D45*E45*4.5","v":0},null,null,{"$f":"D45*E45","v":0}]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,0,null,null,0]
[null,null,null,null,1,{"$f":"D50*E50*4.5","v":0},null,null,{"$f":"D50*E50","v":0}]

{"sheet":"Summary","index":2,"n_rows":35,"n_cols":37,"rows_kept":35,"cut":false,"hidden":false,"merged":[[21,13,21,15],[22,13,22,15],[23,13,23,15],[30,2,30,16],[11,29,11,33],[15,23,15,25],[15,29,15,33],[17,23,17,25],[20,13,20,15],[29,18,29,27],[30,18,30,27],[21,29,21,33],[23,29,23,33],[29,2,29,16],[4,0,4,33],[19,29,19,33],[13,23,13,25],[13,29,13,33],[10,22,10,25],[10,29,10,33],[17,29,17,33],[10,16,10,18],[11,16,11,18],[11,23,11,25],[8,1,8,33]]}
[]
[]
[]
[]
["Total ABP Service Charge Refund Calculation"]
[]
["Total Service Charge Refund Calculation"]
[]
[null,"The following table show “zero” refund as ABP asks that you consider the consequences of requesting a refund and think about leaving all or some of the refundable Service Charge with ABP.  For further information on how your Service Charge helps the beef cattle industry, please press the “Info” buttons.   To change the amounts, please check the appropriate boxes and specify the amounts you wish to leave with ABP."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# Head",null,null,null,null,null,"   / Head",null,null,null,null,null,null,"Amount"]
["Number of head available for a refund at $2.00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Refund Request'!I11","v":0},null,null,null,null,null,"@",2,null,null,null,"=",null,{"$f":"SummaryNoHead*X12","v":0}]
[]
[null,null,"Less: Dealer dealer remittance fee Paid by ABP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",0.05,null,null,null,"=",null,{"$f":"IF(AK14=TRUE,SummaryNoHead*X14,0)","v":0},null,null,null,null,null,null,true]
[]
[null,null,"Less: Contribution to ABP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",0,null,null,null,"=",null,{"$f":"SummaryNoHead*SummaryContributionRateToABP","v":0},null,null,null,null,null,null,true]
[]
[null,null,"Less: Contribution to CCA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@",0.53,null,null,null,"=",null,{"$f":"IF(AK18=TRUE,Q12*X18,0)","v":0},null,null,null,null,null,null,true]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payout before GST",null,{"$f":"AD12-AD14-AD16-AD18","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add GST",null,{"$f":"AD20*0.05","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"= Calculated Refund Amount",null,{"$f":"AD20+AD22","v":0}]
[null,null,"Certification"]
[null,null,"I hereby certify that the ABP Service Charge was paid by the producer requesting"]
[null,null," the refund and was not passed on to another person for payment, and that"]
[null,null," the copies of the documentation supporting this request for a refund"]
[null,null," are true copies of the original documents."]
[]
[null,null,"Requested By",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Certified"]
[]
[]
["The above information is collected by ABP for the purpose of the Alberta Beef Producers Commission Regulation,"]
["and is governed by the Protection of Personal Information Act and the ABP Personal Information Protection Policy. "]

{"sheet":"Instructions","index":3,"n_rows":39,"n_cols":2,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,1,38,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Filename","C:\\Data\\Clients\\ABP\\Refunds\\000 Refund Request Form\\Refund Template 2022.xlsm"]

{"sheet":"References","index":4,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Province",null,"MaxRow"]
[null,"AB",null,50,null,null,null,"Test Mode",false,null,"Comments Region"]
[null,"BC",null,null,null,null,null,"Protect Mode","ON",null,"Instructions","Instructions"]
[null,"SK",null,null,null,null,null,null,null,null,"Info01","Info"]
[null,"MN",null,null,null,null,null,"CurRefundRow",13,null,"Info02","Info"]
[null,"ON",null,null,null,null,null,null,null,null,"InfoRefundRequest","Info"]
[null,null,null,null,null,null,null,"CurRefundCol",1]
[]
[true,null,null,null,null,null,null,"RefundPeriod",1]
[false]
[null,null,null,null,null,null,null,"Certified",false]
[]
[null,null,null,null,null,null,null,"AllowClose",true]
[null,"Range Name","Required"]
[null,"NameOfProducer",true]
[null,"FirstName",true]
[null,"LastName",true]
[null,"Address",true]
[null,"Town",true]
[null,"PostalCode",true]
[null,"Phone",true]
[null,"eMail",true]
[null,"County",true]
[null,"OperatingCounty",true]
[null,"DateOfRequest",true]
[]
[null,"ProducerCategory"]
[null,"CategoryCowCalfProducer"]
[null,"CategoryFeedlot"]
[null,"CategoryLicencedDealer"]
[null,"CategoryBackgrounder"]
[null,"CategoryCustomFeedlot"]
[null,"CategoryAuctionMarket"]
[null,"CategoryOther"]