{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Calibration"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":12,"n_cols":1,"rows_kept":12,"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. Three 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."]
[]
["Changing default options for measuring units, the first 3 options in the drop downlist."]
["1. unprotect in Review with password ofra"]
["2. change the name and volume as appropriate in cells q9 to r11. This will change the name in the dropdown list. (Determine the volume by filling with water and then weighing the water. Grams of water is volume in mL."]
["3. Go to Review and protect the worksheet with password ofra."]

{"sheet":"Calibration","index":1,"n_rows":23,"n_cols":27,"rows_kept":23,"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,"Look up table for density",null,null,"Look up table for application"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Description","Volume","D10","D11","D12",null,"Urea",1.32,null,"Point",{"$f":"D19*E19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water bottle lid ",4,null,null,null,null,"Triple Super phosphate",2.2200000000000002,null,"Band",{"$f":"D19","v":0.3}]
[null,null,null,{"$f":"IF(C11=0,0,VLOOKUP($C$11,Volume,3,FALSE))","v":0},{"$f":"IF(C11=0,0,VLOOKUP($C$11,Volume,4,FALSE))","v":0},{"$f":"IF(C11=0,0,VLOOKUP($C$11,Volume,5,FALSE))","v":0},"Volume, mL",null,null,null,null,null,null,null,null,null,"2-cm highland bottle",50,null,null,null,null,"Murate of potash",1.98,null,"Broadcast",{"$f":"D19","v":0.3}]
[null,"Volume","2-cm highland bottle",null,null,null,{"$f":"IF(C11=0,0,VLOOKUP(C11,Volume,2,FALSE))","v":50},null,null,null,null,null,null,null,null,null," "," ",null,null,null,null,"Diammonium phosphate",1.62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volume of round measuring unit",{"$f":"3.14*(E11/2)^2*F11","v":0},null,"Diameter, cm","Depth, cm",null,"NPK 12-24-12",1]
[null,null,null,{"$f":"IF(C14=\"Other\",\"Enter Density\",\"\")","v":""},"Density, g/mL",null,null,null,null,null,null,null,null,null,null,null,"Volume of square/rectangle measuring unit",{"$f":"D11*E11*F11","v":0},"Length, cm","Width, cm","Height, cm",null,"NPS 23-21-0-4",1.2]
[null,"Fertilizer type","Urea",null,{"$f":"IF(C14=0,0,VLOOKUP(C14,Density,2,FALSE))","v":1.32}]
[]
[null,"Fertilizer Rate",16,"kg/acre"]
[]
[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":""}]
[null,"Application Method","band",0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volume",{"$f":"VLOOKUP(C11,Volume,2,FALSE)","v":50}]
[null,null,{"$f":"IF(C19=\"Point\",\"Points/container\",\"Meters/container\")","v":"Meters/container"},{"$f":"IF(C11=0,\"Choose a method to calculate volume\",IF(C16=0,\"Enter a fertilizer rate\",IF(C14=0,\"Enter fertilizer type\",IF(X20=0,\"Enter volume data\",IF(C19=0,\"Enter 'Application Method'\",IF(X22=0,\"Enter 'Application Method' data\",(X20/(X23/10*X22))*X21))))))","v":55.644275774999997},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Density",{"$f":"IF(C14=0,0,VLOOKUP(C14,Density,2,FALSE))","v":1.32}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Application Method",{"$f":"IF(C19=\"point\",D19*E19,IF(C19=\"band\",D19,IF(C19=\"broadcast\",D19,\"\")))","v":0.3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":39.536861058193907}]