{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Calculator","Renewal Fee","Net Worth","Bond"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":9,"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":"Calculator","index":0,"n_rows":39,"n_cols":19,"rows_kept":39,"cut":false,"hidden":false,"merged":[[21,0,21,28],[6,12,6,15],[7,18,7,21],[11,11,11,13],[16,12,16,15],[0,0,0,28],[1,0,1,28],[17,4,17,5],[13,17,13,23],[4,4,4,23],[6,6,6,11],[7,6,7,17],[9,17,9,23],[12,17,12,23],[14,17,14,23],[15,17,15,23],[16,6,16,11],[16,17,16,23],[17,17,17,23]]}
["Indiana Grain Buyers and Warehouse Licensing Agency"]
["Indiana State Department of Agriculture"]
[]
[]
[null,null,null,null,"Grain License Renewal Fee Calculator"]
[]
[null,null,null,null,"Grain License Type:",null,null,null,null,null,null,null,"Step 1"]
[null,null,null,null,"Total Bushel Capacity:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Step 2"]
[]
[null,null,null,null,"Initial Fee ($):",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Calculator!G8,'Renewal Fee'!C3:D6,2,0),IFERROR(VLOOKUP(Calculator!G8,'Renewal Fee'!E3:F3,2,0),(VLOOKUP(Calculator!G8,'Renewal Fee'!G3:H3,2,0))))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Add'l Facility Fee ($):",null,null,null,null,250]
[null,null,null,null,null,"Total Grain Facilities:",null,null,null,"x",null,"Step 3"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K11*K12","v":0},null,null,null,null,null,"+",{"$f":"K13","v":0}]
[null,null,null,null,"less: One Facility ($):",null,null,null,null,null,null,null,null,null,null,null,"-",{"$f":"IF(K12<1,0,250)","v":0}]
[null,null,null,null,"Renewal Fee Due ($):",null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"R10+R13-R14","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,"Late Fee ($):",null,null,null,null,null,null,null,"Step 4",null,null,null,"+",{"$f":"R15*VLOOKUP(G17,'Renewal Fee'!A12:C14,3,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Total Amount Due ($):",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R15+R17","v":{"$error":"#N/A"}}]
[]
[]
[]
["Directions"]
[]
[null,"***","You may only enter data using the dropdown menus provided in the yellow cells above.***"]
[]
[null,"1.","Using the dropdown menu, select the GRAIN LICENSE TYPE your company is appyling for relicensure. "]
[]
[null,"2.","Using the dropdown menu, select the TOTAL BUSHEL CAPACITY category that accurately represents your company.  Companies"]
[null,null,"applying to renew a Grain Buyer license should select \"Open Capacity\"."]
[]
[null,"3.","Using the dropdown menu, select the TOTAL number of GRAIN FACILITIES your company operates in Indiana.  Remember"]
[null,null,"all initial grain license fees are for a company's first grain facility.  The calculator already accounts for this first facility for you."]
[null,null,"A reduction for your company's first facility can be seen in the \"less: One Facility ($)\" section of the calulator. "]
[]
[null,"4.","Using the dropdown menu, select the category that accurately represents the total number of calendar days your company is"]
[null,null,"late in submitting all required documents for its annual grain license renewal.  If your company's required documents are NOT"]
[null,null,"LATE, please select \"0 days late\" from the dropdown menu."]
[]
[null,"5.","You must fully answer steps one (1) through four (4) in order to determine your company's total grain license renewal fee."]

{"sheet":"Renewal Fee","index":1,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[null,null,"Table 1",null,"Table 2",null,"Table 3",null,"Table 4"]
["License Type",null,"Warehouse",null,"Grain_Bank",null,"Grain_Buyer",null,"Buyer_Warehouse"]
["Warehouse",null,"Capacity < 250,000",1000,"Capacity < 50,000",1000,"Open Capacity",1500,"Capacity < 250,000",1000]
["Grain_Bank",null,"250,000 ≤ Capacity < 1,000,000",1500,null,null,null,null,"250,000 ≤ Capacity < 1,000,000",1500]
["Grain_Buyer",null,"1,000,000 ≤ Capacity < 10,000,000",2000,null,null,null,null,"1,000,000 ≤ Capacity < 10,000,000",2000]
["Buyer_Warehouse",null,"Capacity > 10,000,000",2500,null,null,null,null,"Capacity > 10,000,000",2500]
[]
[]
[]
[]
["Late Fee"]
["0 days late",null,0]
["1-60 days late",null,0.5]
["61+ days late",null,1]
[]
["Tot_Fac"]
[0]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]

{"sheet":"Net Worth","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
["License Type",null,"Minimum","Capacity"]
["Warehouse",null,100000,"not applicable"]
["Grain_Bank",null,100000,"not applicable"]
["Grain_Buyer",null,100000,"not applicable"]
["Buyer_Warehouse ","No",150000,"< 1,000,000"]
[null,"Yes",200000,"≥ 1,000,000"]
[]
["Yes_No"]
["Yes"]
["No"]

{"sheet":"Bond","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}