{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Calibration"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["The OFRA Fertilizer Calibration Tool eases calibration for accurate fertilizer application."]
["1. With first use: enable editing and enable content."]
["2. Provide information to determine the volume of the fertilizer application container. Two default options for Highland water bottles are given in the dropdown list in cell C11. The dropdown also offers options for round or rectangular containers. If one of these is selected, cells are created to enter the dimensions measured in cm."]
["3. Select fertilizer from the dropdown in cell C14. This will access the fertilizer density which is used to calculate fertilizer weight in the container when level full. If the fertilizer of interest is not in the list, select other and enter the fertilizer density in cell D13. "]
["4. Enter fertilizer application rate in C16, and select units for rate, either kg/ha or kg/acre from dropdown in D16."]
["5. Dropdown in C19 offers three application options. Depending on selection, information on distance between rows and/or between application points, or width of pass will be requested."]
["6. The solution is given in D21 as to how many points or meters are covered per container."]

{"sheet":"Calibration","index":1,"n_rows":21,"n_cols":27,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"                 OFRA FERTILIZER "]
[null,null,"CALIBRATION TOOL","CALIBRATION TOOL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Look up Table for Calculating Volume"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water bottle lid ",3.8]
[null,null,null,{"$f":"IF(C11=\"volume of square/rectangle measuring unit\",\"Length, cm\",\"\")","v":""},{"$f":"IF(C11=\"Volume of round measuring unit\",\" Diameter, cm\",IF(C11=\"volume of square/rectangle measuring unit\",\"Width, cm\",\"\"))","v":" Diameter, cm"},{"$f":"IF(C11=\"volume of round measuring unit\",\"Depth, cm\",IF(C11=\"volume of square/rectangle measuring unit\",\"Height, cm\",\"\"))","v":"Depth, cm"},"Volume, mL",null,null,null,null,null,null,null,null,null,"Water bottle cut to 2 cm ht",38]
[null,"Volume","volume of round measuring unit",null,4,4,{"$f":"AA13","v":50.24}]
[]
[null,null,null,{"$f":"IF(C14=\"Other\",\"Enter Density\",\"\")","v":""},"Density, g/mL",null,null,null,null,null,null,null,null,null,null,null,"Look up table for density",null,null,null,null,null,null,null,null,"Volume",{"$f":"IF(C11=\"water bottle lid\",R9,IF(C11=\"water bottle cut to 2 cm ht\",R10,IF(C11=\"volume of round measuring unit\",(3.14)*(E11/2)^2*F11,IF(C11=\"volume of square/rectangle measuring unit\",D11*E11*F11))))","v":50.24}]
[null,"Fertilizer type","Diammonium phosphate",null,{"$f":"AA14","v":1.62},null,null,null,null,null,null,null,null,null,null,null,"Urea",1.32,null,null,null,null,null,null,null,"Density",{"$f":"IF(C14=\"Urea\",IF(D14=\"\",R14,D14),IF(C14=\"Triple super phosphate\",IF(D14=\"\",R15,D14),IF(C14=\"murate of potash\",IF(D14=\"\",R16,D14),IF(C14=\"diammonium phosphate\",IF(D14=\"\",R17,D14),IF(C14=\"single super phosphate\",IF(D14=\"\",R18,D14),IF(C14=\"calcium ammonium nitrate\",IF(D14=\"\",R19,D14),IF(C14=\"other\",D14,\"\")))))))","v":1.62}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Triple Super phosphate",2.2200000000000002,null,null,null,null,null,null,null,"Application Method",{"$f":"IF(C19=\"point\",D19*E19,IF(C19=\"band\",D19,IF(C19=\"broadcast\",D19,\"\")))","v":13.5}]
[null,"Fertilizer Rate",20,"kg/acre",null,null,null,null,null,null,null,null,null,null,null,null,"Murate of potash",1.98,null,null,null,null,null,null,null,"Fertilizer Rate (kg/ha)",{"$f":"IF(D16=\"kg/ha\",C16,IF(D16=\"kg/acre\",C16/0.404685642,\"\"))","v":49.42107632274238}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diammonium Phosphate",1.62]
[null,null,null,{"$f":"IF(C19=\"point\",\"Row Spacing, m\",IF(C19=\"band\",\"Row Spacing, m\",IF(C19=\"Broadcast\",\"Application Width, m\",\"\")))","v":"Row Spacing, m"},{"$f":"IF(C19=\"point\",\"Point Spacing, m\",\"\")","v":"Point Spacing, m"},null,null,null,null,null,null,null,null,null,null,null,"Single Super Phosphate",1.1200000000000001]
[null,"Application Method","point",2.25,6,null,null,null,null,null,null,null,null,null,null,null,"Calcium ammonium Nitrate",1.1000000000000001]
[]
[null,null,{"$f":"IF(C19=\"Point\",\"Points/container\",\"Meters/container\")","v":"Points/container"},{"$f":"IF(AA16=0,\"Need more data\",IF(AA15=0,\"Need more data\",(AA13/(AA16/10*AA15))*AA14))","v":1.2198843992448001}]