{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["INTRO","PROFILE","PROSPERITY","PEOPLE","PLANET","SAI QUESTIONS","REPORT","CALCULATORS"],"not_rendered":{"charts":0,"images":19,"macros":1,"external_links":0,"defined_names":31,"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":"INTRO","index":0,"n_rows":68,"n_cols":3,"rows_kept":68,"cut":false,"hidden":false,"merged":[[2,2,2,4],[65,2,65,3]]}
[]
[null,null,"\n"]
[null,null,"\n\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"SUSFARMS VERSION 4.1"]
[null,null,"© March 2024"]
[null,null,"Release 01"]

{"sheet":"PROFILE","index":1,"n_rows":86,"n_cols":11,"rows_kept":86,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[3,2,3,4],[12,1,12,4],[4,2,4,4],[5,2,5,4],[10,2,10,4],[9,2,9,4],[6,2,6,4],[11,1,11,4],[49,2,50,2],[43,6,43,10],[18,3,18,4],[20,2,20,4],[7,2,7,4],[8,2,8,4],[17,3,17,4],[38,6,38,10],[28,1,28,4],[38,1,38,4],[21,3,21,4],[23,3,23,4],[26,3,26,4],[37,1,37,4],[22,3,22,4]]}
[]
[null,"PROFILE"]
[null,"GENERAL",null,null,null,"NOTES"]
[null,"GROWER NAME"]
[null,"GROWER CODE"]
[null,"FARM NAME"]
[null,"GPS CO-ORDINATE OF FARM LOCATION"]
[null,"EXTENSION AREA","Lower South Coast"]
[null,"ECOZONE OR WARD"]
[null,"TWELVE-MONTH REPORTING PERIOD","1 March 2023 - 29 February 2024"]
[null,"TODAY'S DATE"]
[null,{"$f":"IF(C18>C14,\"Error: Area under sugarcane cannot be greater than total farm area!\",\"\")","v":""}]
[null,"FARM INFORMATION"]
[null,"TOTAL FARM SIZE",null,"Ha"]
[null,"AREA UNDER IRRIGATED SUGARCANE",null,"Ha"]
[null,"AREA UNDER SUPPLEMENTARY- IRRIGATED SUGARCANE",null,"Ha"]
[null,"AREA UNDER RAINFED SUGARCANE",null,"Ha"]
[null,"TOTAL AREA UNDER SUGARCANE",{"$f":"SUM(C15:C17)","v":0},{"$f":"IF(C18>C14,\"ERROR! Total area exceeds farm size.\",\"\")","v":""}]
[null,"AVERAGE FARM RV%",null,"%"]
[null,"AVERAGE LEAD DISTANCE TO MILL (i.e. one-way)",null,"Km"]
[null,"OTHER CROPS CULTIVATED"]
[null,"AVERAGE NUMBER OF EMPLOYEES\nIndicate ALL employees (i.e. permanent, part-time, contract staff) that have worked directly for you. "]
[null,"HOW MANY OF THESE ARE WOMEN?"]
[null,"DO YOU HAVE A HISTORICAL OR CULTURAL HERITAGE SITE ON YOUR FARM?"]
[null,"DO YOU HAVE ANY UNCULTIVATED NATURAL AREAS ON YOUR FARM e.g. forests, grasslands,natural watercourses and wetlands ?"]
[null,"DO YOU HAVE AN EXISTING OR NEW QUARRY OR BORROW PIT ON YOUR FARM?"]
[null,"DO YOU SELL MATERIAL FROM AN EXISTING OR NEW QUARRY OR BORROW PIT?"]
[]
[null,"CANE HARVESTED \n(Indicate the area harvested, total tons harvested and average age of cane at harvest.)"]
[null,"CATEGORY","HECTARES","TOTAL TONS","AVERAGE AGE AT HARVEST (MONTHS)"]
[null,"IRRIGATED"]
[null,"SUPPLEMENTARY-IRRIGATED"]
[null,"RAINFED"]
[null,"IRRIGATED",{"$f":"IF(C15=0,0,C31)","v":0},{"$f":"IF(C15=0,0,IF(C31=0,0,D31))","v":0}]
[null,"SUPPLEMENTARY-IRRIGATED",{"$f":"IF(C16=0,0,C32)","v":0},{"$f":"IF(C16=0,0,IF(C32=0,0,D32))","v":0}]
[null,"RAINFED",0,0]
[null,"TOTAL",{"$f":"SUM(C34:C36)","v":0},{"$f":"SUM(D34:D36)","v":0}]
[null,{"$f":"IF(OR(AND(C31>C15,C15>0),AND(C32>C16,C16>0),AND(C33>C17,C17>0)),\"ERROR! Area harvested in any category cannot exceed area available!\",\"\")","v":""}]
[null,"FARMING INPUTS\nIf you know the total annual amounts for the inputs listed in Column 1 below, then choose \"Known\" in Column 2 and enter the amount in Column 3.\nIf you do not know the amounts, choose \"Unknown\" in Column 2 below.\nYou can use the NPK Calculator on the right to work out the quantites of N, P and K in blends.",null,null,null,"          N:P:K Calculator","N :P : K CALCULATOR"]
[null,"RAINFALL RECEIVED","Unknown",null,"mm",null,"TONS FERTILISER USED  "]
[null,"AMOUNT OF IRRIGATION WATER APPLIED","Unknown",null,"m3 or KL",null,null,"N","P","K","CONCENTRATION"]
[null,"DIESEL CONSUMED FOR ON-FARM SUGARCANE OPERATIONS","Unknown",null,"Litres",null,"BLEND  "]
[null,"DIESEL CONSUMED FOR TRANSPORTING SUGARCANE TO MILL","Unknown",null,"Litres",null,"TONS  N : P : K   ",{"$f":"IF(H42=0,0,(H40*K42/100)/(SUM(H42:J42)/H42))","v":0},{"$f":"IF(I42=0,0,(H40*K42/100)/(SUM(H42:J42)/I42))","v":0},{"$f":"IF(J42=0,0,(H40*K42/100)/(SUM(H42:J42)/J42))","v":0}]
[null,"ELECTRICITY CONSUMED FOR SUGARCANE OPERATIONS","Unknown",null,"kWh"]
[null,"NITROGEN (Chemical fertiliser only, exclude organics)","Unknown",null,"Tons"]
[null,"PHOSPHORUS (Chemical fertiliser only, exclude organics)","Unknown",null,"Tons"]
[null,"POTASSIUM (Chemical fertiliser only, exclude organics)","Unknown",null,"Tons"]
[null,"TOTAL LIME plus GYPSUM","Unknown",null,"Tons"]
[null,"DO YOU USE ORGANIC FERTILISER (CHICKEN LITTER, KRAAL MANURE, MILO, FLYASH, ETC)"]
[null,"AGROCHEMICALS","Known"]
[null,"If you have a record of all agrochemicals used during the year under review, select \"Known\" in Column 2 on the right. Then, enter all the agrochemicals used by selecting from the dropdown list in Column 1 below.\nThereafter, enter the volume or mass (in litres or kgs) used during the past year in Column 2.\nIf an agrochemical does not appear in the dropdown list, type the name in the 'Other Agrochemicals' section in Column 1. \nThen enter the volume or mass in Column 2, AND the amount of active ingredient (in g/litre, from chemical label) in Column 3.  "]
[null,"LISTED AGROCHEMICALS","VOLUME / MASS","ACTIVE INGREDIENT"]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B53,AGROCHEMTAB,2),\"\")","v":""},{"$f":"IFERROR(C53*D53,0)","v":0}]
[null,null,null,"",0]
[null,null,null,"",0]
[null,null,null,"",0]
[null,null,null,"",0]
[null,null,null,"",0]
[null,null,null,"",0]
[null,null,null,"",0]
[null,null,null,"",0]
[null,null,null,"",0]
[null,null,null,"",0]
[null,null,null,"",0]
[null,null,null,"",0]
[null,null,null,"",0]
[null,null,null,"",0]
[null,"OTHER AGROCHEMICALS","VOLUME / MASS","ACTIVE INGREDIENT"]
[null,null,null,null,{"$f":"IFERROR(C69*D69,0)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,{"$f":"SUM(C53:C83)","v":0},{"$f":"SUM(D53:D83)","v":0},{"$f":"SUM(E53:E83)","v":0}]
[]
[null,"\n"]

{"sheet":"PROSPERITY","index":2,"n_rows":102,"n_cols":7,"rows_kept":102,"cut":false,"hidden":false,"merged":[[65,1,65,3],[80,1,80,3],[1,1,1,3],[2,1,2,3],[31,1,31,3]]}
[]
[null,"PROSPERITY",null,null,null,null,{"$f":"SUM(C6:C13,D14:D29,D35,D37:D48,D50:D52,D58:D59,D68:D78,C84:C99,G4:G101)","v":0}]
[null,"\n1.1 LAND USE PLAN\nSTATEMENT OF INTENT : The agronomic and mechanisation practices of the sugarcane farm are integrated with the climate, \nsoils, water and topography to obtain optimum and sustained economic crop production.\n",null,null,null,null,"NOTES"]
[null,null,"LEGAL","BMP"]
[null,"Do you possess a land-use plan (or other maps) containing details and specifications with regard to the following?",null,"NOTES…"]
["1.1.3","• Conservation terraces (indicating vertical intervals and height of terrace banks)",null,null,{"$f":"IF(C6=\"YES\",1,IF(C6=\"N/A\",\"N/A\",0))","v":0}]
["1.1.4","• Waterways (indicating their location and waterway category)",null,null,{"$f":"IF(C7=\"YES\",1,IF(C7=\"N/A\",\"N/A\",0))","v":0}]
["1.1.5","• Roads and cane extraction system (indicating the location and type of road i.e. diagonal, crest, access or district road)",null,null,0]
["1.1.6","• Road drainage for all roads",null,null,0]
["1.1.7","• Natural Wetlands and watercourses (indicating their location)",null,null,0]
["1.1.8","• Dams (indicating their location)",null,null,0]
["1.1.9","• Quarries (indicating their location)",null,null,0]
["1.1.10","• Rubbish dumps (indicating their location)",null,null,0]
["1.1.11","• Staff/labour housing and workshop (indicating their location)",null,null,{"$f":"IF(D14=\"YES\",1,IF(D14=\"N/A\",\"N/A\",0))","v":0}]
["1.1.13","• Soil parent material",null,null,{"$f":"IF(D15=\"YES\",1,IF(D15=\"N/A\",\"N/A\",0))","v":0}]
["1.1.14","• Soil form including depth, total available water (TAW) and erodibility",null,null,0]
["1.1.15","• Non-arable and natural areas",null,null,0]
["1.1.16","• Wet agricultural land (relic wetlands)",null,null,0]
["1.1.17","• Fields including number and area in hectares",null,null,0]
["1.1.18","• Minimum tillage fields",null,null,0]
["1.1.19","• Fields suitable for green cane harvesting (trashing)",null,null,0]
["1.1.20","• Fields suitable for mechanisation",null,null,0]
[null,"• Historically or culturally important sites",null,null,0]
["1.1.21","• Bulk and infield Irrigation system design",null,null,0]
["1.1.22","• Irrigation blocks",null,null,0]
["1.1.23","• Irrigation types",null,null,0]
["1.1.24","• Electric power supply system for irrigation",null,null,0]
["1.1.25","• For irrigated fields, surface and subsurface water management structures i.e. drainage system network \n(dimensions stipulated in SABI norms) and waterways",null,null,0]
["1.1.26","• Dams, dyke and canal network for irrigation",null,null,0]
[null,"LAND USE PLAN",{"$f":"AVERAGE(E6:E13)","v":0},{"$f":"AVERAGE(E14:E29)","v":0}]
[]
[null,"1.2 ANNUAL PRODUCTION PLAN\nSTATEMENT OF INTENT : Production potential of the land is maintained or enhanced."]
[null,"RECORD KEEPING","LEGAL","BMP"]
[null,"The production potential of the land is maintained or enhanced through recording and monitoring inputs and outputs.",null,"NOTES…"]
["1.2.1","Do you have a field specific record-keeping system in place?",null,null,{"$f":"IF(D35=\"Yes\",0.4,0)","v":0}]
[null,"Does your record-keeping system include the following?",null,null,{"$f":"IF(D35=\"No\",0,AVERAGE(E37:E52)*0.6)","v":0}]
["1.2.2","• Area under cane ",null,null,{"$f":"IF(D37=\"Yes\",1,0)","v":0}]
["1.2.4","• Area planted to each variety recorded annually in hectares",null,null,0]
["1.2.5","• Replant dates",null,null,0]
["1.2.6","• Sugarcane yield (t/ha)",null,null,0]
["1.2.8","• Average RV% ",null,null,0]
["1.2.9","• All fertiliser applications",null,null,0]
["1.2.10","• All agrochemicals applications (herbicides, insecticides, nematicides, fungicides, ripeners) ",null,null,0]
["1.2.11","• Net irrigation water used",null,null,{"$f":"IF(PROFILE!C15+PROFILE!C16=0,\"\",IF(D44=\"Yes\",1,IF(D44=\"No\",0,\"N/A\")))","v":""}]
["1.2.12","• Annual rainfall",null,null,0]
["1.2.13","• Net electricity usage for sugarcane production",null,null,{"$f":"IF(D46=\"Yes\",1,IF(D46=\"N/A\",\"N/A\",0))","v":0}]
["1.2.14","• Net  diesel used  for all sugarcane production operations",null,null,{"$f":"IF(D47=\"Yes\",1,IF(D47=\"N/A\",\"N/A\",0))","v":0}]
["1.2.15","• Net  diesel used  for sugarcane transport to mill",null,null,{"$f":"IF(D48=\"Yes\",1,IF(D48=\"N/A\",\"N/A\",0))","v":0}]
[null,"• Records of sampling (done at least once every four years) for the following:"]
["1.2.16"," - Soil pH",null,null,{"$f":"IF(D50=\"Yes\",1,0)","v":0}]
["1.2.17"," - Acid saturation",null,null,{"$f":"IF(D51=\"Yes\",1,0)","v":0}]
["1.2.18"," - Salinity (where this is an issue)",null,null,{"$f":"IF(D52=\"Yes\",1,IF(D52=\"N/A\",\"N/A\",0))","v":0}]
[]
[null,"PRODUCTION STANDARDS"]
[null,"The production potential of the land is maintained or enhanced through the achievement of production standards. ",null,"NOTES…"]
["1.2.20","RV Efficiency\nYour RV% average of        is compared against an industry average of 10%.",null,{"$f":"IF(PROFILE!C19<=10,PROFILE!C19*10,100)/100","v":0},{"$f":"D56","v":0}]
["1.2.24","Average mass of agrochemical active ingredient applied. (Kg/ha).\nYour average of                  kg/ha is compared agains a standard of 5 kg/ha.",null,{"$f":"CALCULATORS!B79","v":{"$error":"#DIV/0!"}},{"$f":"D57","v":{"$error":"#DIV/0!"}}]
[null,"Have you established the yield potential of your farm by using an appropriate tool (e.g.MyCanesim or StalkGro) in order to benchmark your own productivity?",null,null,{"$f":"IF(D58=\"Yes\",1,IF(D59=\"Yes\",0.5,0))","v":0}]
["1.2.21","Do you take note of the mill average (yield) in order to benchmark your own productivity?"]
["1.2.22","Net primary energy used per ton of cane per annum.(MJ/t). \nYour net prinmary energy used per ton of cane per annum of                    MJ/t is compared against the global standard of  300 MJ/t.",null,{"$f":"CALCULATORS!B65","v":0}]
["1.2.23","Efficiency of energy used for cane transport (MJ/t)\nYour energy used for cane transport of                   MJ/t is compared against the global standard of  50 MJ/t.",null,{"$f":"CALCULATORS!B73","v":0}]
[null,"Note: The last two items are for information only and are not taken into account for scoring purposes."]
[null,null,"N/A",{"$f":"(AVERAGE(SUM(E35,E36),E56:E58))","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"\n1.3 ANNUAL FINANCIAL PLAN\nSTATEMENT OF INTENT : Profitability and viability of a farming operation is planned on an annual basis.\n","LEGAL","BMP"]
[null,null,"LEGAL","BMP"]
["1.3.1","Do you prepare an annual budget for income and expenses as per the  production plan and for monthly expenses such as living costs, finance costs, insurance and also asset replacement, taxes, bonds and hire purchase?","NOTES…",null,{"$f":"COUNTIF(D68:D74,\"Yes\") +COUNTIF(D76:D78,\"Yes\")","v":0}]
["1.3.2","Do you draw up cash flow and savings projections annually?",null,null,10]
["1.3.3","Are all transactions associated with the farming activities captured on a monthly basis and are monthly reports generated?",null,null,{"$f":"COUNTIF(D68:D74,\"Yes\") +COUNTIF(D78,\"Yes\")","v":0}]
["1.3.4","Are there monthly reviews of the budget and cash flow and forecasts for the following months in order to take action when required?",null,null,8]
["1.3.5","Are Annual Financial Statements prepared?"]
["1.3.6","Do you undertake an annual review of the profitability of the business?"]
["1.3.7","Do you have a full understanding of the obligations of a business owner?"]
[null,"Do you have any loans or debts?"]
[null,"Are you up-to-date with your loan / debt repayments?"]
[null,"Do you measure your repayment ability to service your debts / loans?"]
[null,"Do you evaluate whether your expenses on depreciated vehicles / equipment is justified?"]
[null,"ANNUAL FINANCIAL PLAN","N/A",{"$f":"IFERROR(IF(D75=\"Yes\",E68/E69,E70/E71),\"\")","v":0}]
[]
[null,"1.4 FINANCIAL COMPLIANCE\nSTATEMENT OF INTENT : Compliance with relevant financial legislation is achieved and maintained."]
[null,null,"LEGAL","BMP"]
[null,null,null,"NOTES…"]
["1.4.4","Are you registered for tax with SARS?",null,null,{"$f":"IF(C84=\"Yes\",1,(IF(C84=\"No - not required\",\"N/A\",0)))","v":0}]
[null,"Have you submitted income tax returns for the past tax year (i.e. are you up-to-date with SARS)?",null,null,{"$f":"IF(C84=\"Yes\",IF(C85=\"Yes\",1,0),\"N/A\")","v":"N/A"}]
[null,"If any payments were required on the returns, have you made these payments?",null,null,{"$f":"IF(C84=\"Yes\",IF(C86=\"Yes\",1,0),\"N/A\")","v":"N/A"}]
[null,"If any refunds were due to you, have you received these?",null,null,{"$f":"IF(C84=\"Yes\",IF(C87=\"Yes\",1,0),\"N/A\")","v":"N/A"}]
[null,"Are you (business owners and employees) registered for PAYE?",null,null,{"$f":"IF(C88=\"Yes\",1,(IF(C88=\"No - not required\",\"N/A\",0)))","v":0}]
[null,"Are you submitting PAYE returns and paying PAYE on a monthly basis?",null,null,{"$f":"IF(C88=\"Yes\",IF(C89=\"Yes\",1,0),\"N/A\")","v":"N/A"}]
["2.2.18","Are you registered with either SARS or the UIF for the purposes of contributing to the Fund?",null,null,{"$f":"IF(C90=\"Yes\",1,(IF(C90=\"No - not required\",\"N/A\",0)))","v":0}]
["2.2.19","Do you pay UIF contributions to SARS or the UIF in respect of  employees on a monthly basis?",null,null,{"$f":"IF(C90=\"Yes\",IF(C91=\"Yes\",1,0),\"N/A\")","v":"N/A"}]
[null,"Does your annual payroll exceed R500 000?"]
[null,"Do you pay a Skills Development Levy at a rate of 1% of the total remuneration payable to employees?",null,null,{"$f":"IF(C92=\"Yes\",IF(C93=\"Yes\",1,0),\"N/A\")","v":"N/A"}]
[null,"Do you qualify to pay Provisional Tax? "]
[null,"Are you up to date with the Provisional Tax returns and payments (Feb and August)?",null,null,{"$f":"IF(C94=\"Yes\",IF(C95=\"Yes\",1,0),\"N/A\")","v":"N/A"}]
[null,"Is your annual turnover > R1million?"]
[null,"Are you VAT registered? ",null,null,{"$f":"IF(C96=\"Yes\",IF(C97=\"Yes\",1,0),\"N/A\")","v":"N/A"}]
[null,"Are you paying and submitting VAT returns as required?",null,null,{"$f":"IF(C96=\"Yes\",IF(C98=\"Yes\",1,0),\"N/A\")","v":"N/A"}]
["1.4.5","Are your Annual Financial Statements audited and submitted, if required?",null,null,{"$f":"IF(C99=\"Yes\",1,(IF(C99=\"Not required\",\"N/A\",0)))","v":0}]
[null,"FINANCIAL COMPLIANCE",{"$f":"IFERROR(AVERAGE(E84:E99),\"\")","v":0},"N/A"]
[]
[null,"PROSPERITY",{"$f":"AVERAGE(C30, C100)","v":0},{"$f":"AVERAGE(D30,D63,D79,D100)","v":{"$error":"#DIV/0!"}}]

{"sheet":"PEOPLE","index":3,"n_rows":150,"n_cols":6,"rows_kept":150,"cut":false,"hidden":false,"merged":[[13,5,13,8],[36,5,36,8],[37,5,37,8],[58,5,58,8],[59,5,59,8],[65,5,65,8],[67,5,67,8],[104,5,104,8],[132,5,132,8],[25,5,25,8],[38,5,38,8],[39,5,39,8],[40,5,40,8],[41,5,41,8],[31,5,31,8],[32,5,32,8],[33,5,33,8],[34,5,34,8],[35,5,35,8],[47,5,47,8],[48,5,48,8],[49,5,49,8],[50,5,50,8],[51,5,51,8],[130,1,130,3],[142,1,142,3],[1,1,1,3],[2,1,2,3],[62,1,62,3],[102,1,102,3],[111,1,111,3],[16,5,16,8],[17,5,17,8],[18,5,18,8],[19,5,19,8],[20,5,20,8],[14,5,14,8],[15,5,15,8],[121,1,121,3],[26,5,26,8],[27,5,27,8],[28,5,28,8],[29,5,29,8],[30,5,30,8],[21,5,21,8],[22,5,22,8],[23,5,23,8],[24,5,24,8],[42,5,42,8],[43,5,43,8],[44,5,44,8],[45,5,45,8],[46,5,46,8],[60,5,60,8],[61,5,61,8],[62,5,62,8],[64,5,64,8],[52,5,52,8],[54,5,54,8],[55,5,55,8],[56,5,56,8],[57,5,57,8],[53,5,53,8],[63,5,63,8],[72,5,72,8],[73,5,73,8],[74,5,74,8],[75,5,75,8],[76,5,76,8],[66,5,66,8],[68,5,68,8],[69,5,69,8],[70,5,70,8],[71,5,71,8],[82,5,82,8],[83,5,83,8],[84,5,84,8],[77,5,77,8],[78,5,78,8],[79,5,79,8],[80,5,80,8],[81,5,81,8],[92,5,92,8],[85,5,85,8],[86,5,86,8],[101,5,101,8],[93,5,93,8],[94,5,94,8],[95,5,95,8],[96,5,96,8],[87,5,87,8],[88,5,88,8],[89,5,89,8],[90,5,90,8],[91,5,91,8],[12,5,12,8],[121,5,121,8],[122,5,122,8],[123,5,123,8],[118,5,118,8],[119,5,119,8],[120,5,120,8],[112,5,112,8],[113,5,113,8],[115,5,115,8],[116,5,116,8],[111,5,111,8],[108,5,108,8],[117,5,117,8],[109,5,109,8],[110,5,110,8],[102,5,102,8],[103,5,103,8],[105,5,105,8],[107,5,107,8],[97,5,97,8],[98,5,98,8],[99,5,99,8],[100,5,100,8],[2,5,2,8],[3,5,3,8],[4,5,4,8],[5,5,5,8],[6,5,6,8],[7,5,7,8],[9,5,9,8],[10,5,10,8],[11,5,11,8],[8,5,8,8],[145,5,145,8],[146,5,146,8],[147,5,147,8],[148,5,148,8],[149,5,149,8],[133,5,133,8],[141,5,141,8],[142,5,142,8],[143,5,143,8],[144,5,144,8],[140,5,140,8],[106,5,106,8],[126,5,126,8],[127,5,127,8],[128,5,128,8],[135,5,135,8],[136,5,136,8],[137,5,137,8],[138,5,138,8],[139,5,139,8],[130,5,130,8],[131,5,131,8],[134,5,134,8],[129,5,129,8],[114,5,114,8],[124,5,124,8],[125,5,125,8]]}
[]
[null,"PEOPLE"]
[null,"2.1 HEALTH AND SAFETY\nSTATEMENT OF INTENT : A working environment that is safe and without risk to the health of the employees is provided and maintained. ",null,null,null,"NOTES"]
[null,null,"LEGAL","BMP"]
[null,"Occupational Health and Safety Act 85 of 1993.",null,"NOTES…"]
["2.1.1","Is a copy of the Act (or summary) displayed on each farm?",null,null,{"$f":"IF(C6=\"Yes\",1,0)","v":0}]
["2.1.2","Are you familiar with the relevant sections of the Act?",null,null,{"$f":"IF(C7=\"Yes\",1,0)","v":0}]
["2.1.3","Is there a policy available to employees detailing relevant sections of the Act and their application?",null,null,{"$f":"IF(C8=\"Yes\",1,0)","v":0}]
[null,"Does the policy clearly set out a commitment to workplace health and safety and a zero tolerance for non-compliance?",null,null,{"$f":"IF(C9=\"Yes\",1,IF(C9=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,"Safe Working Environment.\nThe farmer provides and maintains systems of work, plant and machinery that are safe and without risks to health.",null,"NOTES…"]
["2.1.4","Are all workshops, storerooms, ablutions and other employee workplaces neat and tidy?",null,null,{"$f":"VLOOKUP(C11,OPTSCORE1,2,FALSE)","v":{"$error":"#N/A"}}]
["2.1.5","Are passageways in the workplace kept free of obstacles?",null,null,{"$f":"VLOOKUP(C12,OPTSCORE1,2,FALSE)","v":{"$error":"#N/A"}}]
["2.1.6","If you have more than 5 employees, are First Aid boxes adequately stocked, accessible and maintained? (see notes for minimum requirements)",null,null,{"$f":"VLOOKUP(C13,OPTSCORE4,2,FALSE)","v":{"$error":"#N/A"}}]
["2.1.7","Are fire extinguishers appropriately labelled (with their contents and purpose identified), accessible, and regularly serviced?",null,null,{"$f":"VLOOKUP(C14,OPTSCORE3,2,FALSE)","v":{"$error":"#N/A"}}]
["2.1.8","Are electric plugs and socket outlets covered?",null,null,{"$f":"VLOOKUP(C15,OPTSCORE3,2,FALSE)","v":{"$error":"#N/A"}}]
["2.1.9","Are circuit breakers and panel boards labelled?",null,null,{"$f":"VLOOKUP(C16,OPTSCORE3,2,FALSE)","v":{"$error":"#N/A"}}]
["2.1.10","Are earth leakage devices present?",null,null,{"$f":"VLOOKUP(C17,OPTSCORE3,2,FALSE)","v":{"$error":"#N/A"}}]
["2.1.11","Are moving parts of machines, power take off and fan belts guarded?",null,null,{"$f":"VLOOKUP(C18,OPTSCORE4,2,FALSE)","v":{"$error":"#N/A"}}]
["2.1.12","Does machinery used for lifting clearly indicate the maximum permissible load?",null,null,{"$f":"VLOOKUP(C19,OPTSCORE4,2,FALSE)","v":{"$error":"#N/A"}}]
["2.1.13","Are your operators of driven machinery trained and licensed where necessary?",null,null,{"$f":"VLOOKUP(C20,OPTSCORE4,2,FALSE)","v":{"$error":"#N/A"}}]
["2.1.14","Are Personal Protective Equipment (PPE) such as earplugs, safety boots, goggles and hard hats issued to employees?",null,null,{"$f":"VLOOKUP(C21,OPTSCORE3,2,FALSE)","v":{"$error":"#N/A"}}]
["2.1.15","Is all signage clear, unambiguous and, where necessary, in two official languages?",null,null,{"$f":"VLOOKUP(C22,OPTSCORE3,2,FALSE)","v":{"$error":"#N/A"}}]
["2.1.16","Are taps and pipes which contain water not fit for human consumption clearly marked?",null,null,{"$f":"VLOOKUP(C23,OPTSCORE4,2,FALSE)","v":{"$error":"#N/A"}}]
["2.1.17","For every 50 employees (or part thereof), is at least one employee  trained in first aid with possession of a certificate of competency?",null,null,{"$f":"IF(C24=\"Yes\",1,(IF(C24=\"N/A\",\"N/A\",0)))","v":0}]
["2.1.18","Are employees who arrive at work intoxicated or who become intoxicated during working hours removed  from the workplace?",null,null,{"$f":"IF(C25=\"Yes\",1,0)","v":0}]
["2.1.19","Have employees been made aware of the need to consume sufficient amounts of water especially in extreme temperatures?",null,null,{"$f":"IF(C26=\"Yes\",1,0)","v":0}]
["2.1.20","Do you supply sufficient safe drinking water to each worker operating in the field?  (5 -10 litres of water per worker per day depending on the environmental conditions).",null,null,{"$f":"IF(D27=\"Yes\",1,0)","v":0}]
["2.1.21","Is all drinking water that is not from a municipal supply tested by a recognised potable water testing facility and deemed suitable for human consumption?",null,null,{"$f":"IF(D28=\"Yes\",1,(IF(D28=\"N/A\",\"N/A\",0)))","v":0}]
["2.1.22","Do you maintain records of all injuries (first aid, medical, lost time or disabling) and the frequency of lost time events for a period of 5 years? ",null,null,{"$f":"IF(D29=\"Yes\",1,0)","v":0}]
["2.1.23","How many lost time accident events occurred over the past year?"]
["2.1.24","Do you conduct (or review) a health and safety risk assessment annually?",null,null,{"$f":"IF(D31=\"Yes\",1,0)","v":0}]
[null,"Precautionary measures for potential hazards.\nThe farmer provides and maintains precautionary measures with respect to potential hazards to the health and safety of employees.",null,"NOTES…"]
["2.1.25","Do you take steps to eliminate or mitigate any hazard or potential hazard to the safety or health of employees before resorting to personal protective equipment (PPE)?",null,null,{"$f":"IF(C33=\"Yes\",1,0)","v":0}]
["2.1.26","Are all hazardous chemical substances (HCS) handled and stored in accordance with SANS 10206:2010?",null,null,{"$f":"IF(C34=\"Yes\",1,(IF(C34=\"N/A\",\"N/A\",0)))","v":0}]
["2.1.27","Are chemicals stored in a room that can be locked?",null,null,{"$f":"IF(C35=\"Yes\",1,(IF(C35=\"N/A\",\"N/A\",0)))","v":0}]
["2.1.28","Are all stored chemicals clearly identified?",null,null,0]
["2.1.29","Are Safety Data Sheets (SDS) available to employees?",null,null,0]
["2.1.30","Are employees made aware of and/or trained on the use and understanding of the SDS and its contents?",null,null,0]
["2.1.31","Are flammable liquids stored separately from other chemicals?",null,null,0]
["2.1.32","Is a daily inventory and record of products used, and returned to the store, controlled by a designated member of the farm staff?",null,null,0]
["2.1.33","Are gloves and face masks always available?",null,null,0]
["2.1.34","Are washing facilities available?",null,null,0]
["2.1.36","Are empty chemical containers returned to the supplier, or disposed of safely in an appropriate waste disposal site?",null,null,0]
[null,"Health and Safety Representatives."]
["2.1.37","Where 20 or more people are employed, is there at least one Health and Safety representative appointed for every 50 employees (or part thereof) ?",null,null,{"$f":"IF(C45=\"Yes\",1,(IF(C45=\"N/A\",\"N/A\",0)))","v":0}]
["2.1.38","Where more than one health and safety representative is appointed, has a health and safety committee been established?",null,null,{"$f":"IF(C45=\"N/A\",\"N/A\",(IF(C46=\"N/A\",\"N/A\",(IF(C46=\"Yes\",1,0)))))","v":0}]
[null,"Training for health and safety.\nFarmers provide information, instructions, training and supervision as is necessary to ensure the health and safety of the employee at work."]
["2.1.39","Is all work performed and plant or machinery used under the general supervision of a person trained in the hazards associated with it?",null,null,0]
["2.1.40","What percentage of all staff (including contract, seasonal and migrant workers) have received basic training in health and safety measures related to their work?",null,null,{"$f":"IF(D49>=90%,1,D49/90%)","v":0}]
["2.1.41","Are environmental awareness programmes  encouraged?",null,null,{"$f":"IF(D50=\"Yes\",1,0)","v":0}]
["2.1.42","Are employees at management and supervisor level encouraged to attend sugarcane agriculture certificate courses?",null,null,{"$f":"IF(D51=\"Yes\",1,0)","v":0}]
["2.1.43","Are training records (e.g. attendance registers, certificates or list of informal events) kept for a minimum of 5 years? ",null,null,{"$f":"IF(D52=\"Yes\",1,0)","v":0}]
[null,"Village Management.\nFarmers who provide employee villages ensure that the villages are safe and without risk to the health of the employee."]
["2.1.44","Do you provide staff housing on your farm?"]
["2.1.45","Is all drinking water suitable for human consumption?",null,null,{"$f":"IF(D54=\"No\",\"N/A\",(IF(C55=\"Yes\",1,0)))","v":0}]
["2.1.46","Is sewerage disposed of safely?",null,null,{"$f":"IF(D54=\"No\",\"N/A\",(IF(C56=\"Yes\",1,0)))","v":0}]
["2.1.47","Are waste disposal bins provided?",null,null,{"$f":"IF(D54=\"No\",\"N/A\",(IF(D57=\"Yes\",1,0)))","v":0}]
["2.1.48","Are provisions made for recycling glass, tins, paper, organic kitchen waste and oil?",null,null,{"$f":"IF(D54=\"No\",\"N/A\",(IF(D58=\"Yes\",1,0)))","v":0}]
[null,"Safe environment for persons other than employees (Section 9(2))"]
[null,"Do you ensure that all persons who may be directly affected by your activities are not exposed to hazards to their health and safety?",null,null,{"$f":"IF(C60=\"Yes\",1,0)","v":0}]
[null,"HEALTH AND SAFETY",{"$f":"IF(PROFILE!C22=0,E60,AVERAGE(E6:E26,E33:E48,E55:E56,E60))","v":0},{"$f":"IF(PROFILE!C22=0,\"N/A\",AVERAGE(E27:E31,E49:E52,E57:E58))","v":"N/A"}]
[]
[null,"2.2 LABOUR\nSTATEMENT OF INTENT \nThe right to fair labour practice is upheld."]
[null,null,"LEGAL","BMP"]
[null,"Compliance with the Basic Conditions of Employment Act, 75 of 1997 ",null,"NOTES…"]
[null,"Is a summary of the BCEA kept on the farm as per the requirements of section 30 of the Act?",null,null,{"$f":"IF(C66=\"Yes\",1,0)","v":0}]
["2.2.1","Are all employees over the age of 18?",null,null,{"$f":"IF(C67=\"Yes\",1,IF(AND(OR(C68=\"No\",C68=\"N/A\"),C69=\"No\"),1,0))","v":0}]
["2.2.2","Are those employees between 15-18 years old doing any work that is not appropriate for their age, i.e. which will place the child's overall well-being at risk?"]
["2.2.3","Are any employees under 15 years old?"]
["2.2.4","Do you have a written contract of employment between you and your employees?",null,null,{"$f":"IF(C70=\"Yes\",0.6,0)","v":0}]
[null,"Does your contract have details of the following:",null,null,{"$f":"COUNTIF(C72:C81,\"Yes\")","v":0}]
["2.2.5","• Employer name and address",null,null,{"$f":"COUNTA(C72:C81)","v":0}]
["2.2.6","• Name and occupation of Employee (or a brief description of the work for which the farm worker is employed)",null,null,{"$f":"IF(C70=\"No\",0,(E71/E72)*0.4)","v":{"$error":"#DIV/0!"}}]
["2.2.7","• Place of work that the Employee is required to tender services",null,null,{"$f":"E70+E73","v":{"$error":"#DIV/0!"}}]
["2.2.8","• Date employment began"]
["2.2.9","• Days of work, ordinary working hours and overtime limits"]
["2.2.10","• Employee's wage or hourly rate, rate of pay for overtime and method of payment"]
["2.2.11","• Any deductions to be made from wages"]
["2.2.12","• Leave"]
["2.2.13","• Notice period"]
["2.2.14","• Termination of employment"]
["2.2.15","Minimum wage: Are all employees (including contract, seasonal and migrant workers) receiving a wage equal to or above the minimum level?",null,null,{"$f":"IF(C82=\"Yes\",1,0)","v":0}]
["2.2.16","Forced labour: Have there been any valid reports or evidence of forced labour on the farm?",null,null,{"$f":"IF(C83=\"No\",1,0)","v":0}]
["2.2.17","Farmworkers: Is a copy of the Sectoral Determination 13 document available in the workplace?",null,null,{"$f":"IF(C84=\"Yes\",1,0)","v":0}]
[null,"Unemployment benefits.\nFarmers contribute to employee unemployment benefits by complying with collection of contributions for the Unemployment Insurance Fund as prescribed by the Unemployment Insurance Contributions Act 4 of 2002.",null,"NOTES…"]
["2.2.18","Are you registered with either SARS or the UIF for the purposes of contributing to the Fund?",{"$f":"PROSPERITY!C90","v":0},null,{"$f":"PROSPERITY!E90","v":0}]
["2.2.19","Do you pay UIF contributions to SARS or the UIF in respect of  employees on a monthly basis?",{"$f":"PROSPERITY!C91","v":0},null,{"$f":"PROSPERITY!E91","v":"N/A"}]
[null,"Worker Compensation.\nFarmers provide for compensation for disablement, diseases or death \nresulting from occupational activities as prescribed by the Compensation \nfor Occupational Injuries and Diseases Act 130 of 1993.",null,"NOTES…"]
["2.2.20","Are you registered with the Compensation Commissioner? ",null,null,{"$f":"IF(C89=\"Yes\",0.6,0)","v":0}]
["2.2.21","Do you have a record of all employees in terms of wages, time worked, payment for piece work, overtime and any other prescribed particulars?",null,null,{"$f":"IF(C90=\"Yes\",0.1,0)","v":0}]
["2.2.22","Do you, on an annual basis (from 1 March to the last day of February of the following year), furnish the commissioner with a return showing amount of earnings for that year?",null,null,{"$f":"IF(C91=\"Yes\",0.1,0)","v":0}]
["2.2.23","Do you and your employees report accidents and occupational diseases timeously?",null,null,{"$f":"IF(C92=\"Yes\",0.1,0)","v":0}]
["2.2.24","Are claims for compensation lodged in the prescribed manner?",null,null,{"$f":"IF(C93=\"Yes\",0.1,0)","v":0}]
[null,"Employment Equity Act, 55 of 1998",null,"NOTES…",{"$f":"IF(C89=\"No\",0,SUM(E89:E93))","v":0}]
["2.2.25","If you are a designated employer, have you implemented affirmative action measures for people from designated groups in terms of the Act?",null,null,{"$f":"IF(C95=\"Yes\",1,IF(C95=\"N/A\",\"N/A\",0))","v":0}]
["2.2.26","Have there been any valid claims of unfair discrimination (i.e. with compensation or reinstatement orders being issued)?",null,null,{"$f":"IF(C96=\"Yes\",0,IF(C96=\"N/A\",\"N/A\",1))","v":1}]
[null,"Labour Relations Act, 66 of 1995"]
["2.2.27","Do you respect the rights of employees to form and join trade unions and establish workplace forums for collective bargaining?",null,null,{"$f":"IF(C98=\"Yes\",1,IF(C98=\"N/A\",\"N/A\",0))","v":0}]
["2.2.28","Have there been any valid reports of unfair dismissal or unfair labour practice?",null,null,{"$f":"IF(C99=\"Yes\",0,IF(C99=\"N/A\",\"N/A\",1))","v":1}]
["2.2.29","Do you have a copy of Schedule 8 of the Act, ‘Code of Good Practice: Dismissal’  on the farm?",null,null,{"$f":"IF(C100=\"Yes\",1,IF(C100=\"N/A\",\"N/A\",0))","v":0}]
[null,"LABOUR",{"$f":"IF(PROFILE!C22=0,\"N/A\",AVERAGE(E66,E67,E74,E82:E87,E94:E100))","v":"N/A"},"N/A"]
[]
[null,"2.3 LAND TENURE\nSTATEMENT OF INTENT : The right to use land is upheld. "]
[null,null,"LEGAL","BMP"]
[null,null,null,"NOTES…"]
[null,"The right to use land is demonstrated \nCan you demonstrate your right to use your land for sugarcane farming?",null,null,{"$f":"IF(C106=\"YES\",1,0)","v":0}]
["2.3.1","Restitution of Land Rights Act, 22 of 1994, as amended.\nDo you respect the rights of communities with legitimate and demonstrable rights to the land to lodge claims through the Land Claims Court as entitled in terms of the Act?",null,null,{"$f":"IF(C107=\"Yes\",1,IF(C107=\"N/A\",\"N/A\",0))","v":0}]
["2.3.2","Land Reform (Labour Tenants) Act 3 of 1996.\nDo you uphold the right of labour tenants to occupy and use that part of the farm to which they are legally entitled in terms of the Act?",null,null,{"$f":"IF(C108=\"Yes\",1,IF(C108=\"N/A\",\"N/A\",0))","v":0}]
["2.3.3","Extension of Security of Tenure Act 62 of 1997.\nDo you uphold the rights of occupiers (not labour tenants) to reside on and use land to which they are legally entitled in  terms of the Act?",null,null,{"$f":"IF(C109=\"Yes\",1,IF(C109=\"N/A\",\"N/A\",0))","v":0}]
[null,"LAND TENURE",{"$f":"IFERROR(AVERAGE(E106:E109),\" N/A\")","v":0},"N/A"]
[null,null,{"$f":"(COUNTIF(C108:C109,\"Below 50%\")*20)+(COUNTIF(C108:C109,\"Above 50%\")*70)+(COUNTIF(C108:C109,\"100%\")*100)","v":0},{"$f":"(COUNTIF(D108:D109,\"Below 50%\")*20)+(COUNTIF(D108:D109,\"Above 50%\")*70)+(COUNTIF(D108:D109,\"100%\")*100)","v":0}]
[null,"2.4 COMMUNITY DEVELOPMENT & STAKEHOLDER ENGAGEMENT\nSTATEMENT OF INTENT : Farmers contribute towards the economy of the local community and engage stakeholders effectively."]
[null,null,"LEGAL","BMP"]
[null,null,null,"NOTES…"]
[null,"Preferential employment opportunities"]
["2.4.1","Do you give preferential opportunity to people living on the farm, or in close proximity to the farm?",null,null,{"$f":"IF(D116=\"Yes\",1,(IF(D116=\"N/A\",\"N/A\",0)))","v":0}]
["2.4.2","Do you participate in community upliftment initiatives? (Example: mowing local school soccer field, providing school facilities on farm).",null,null,{"$f":"IF(D117=\"Yes\",1,0)","v":0}]
[null,"Stakeholder engagement"]
["2.4.3","Do you proactively consult and engage with local communities and other stakeholders?",null,null,{"$f":"IF(D119=\"Yes\",1,0)","v":0}]
[null,"COMMUNITY DEVELOPMENT & STAKEHOLDER ENGAGEMENT","N/A",{"$f":"AVERAGE(E116:E119)","v":0}]
[null,null,{"$f":"(COUNTIF(C116:C119,\"Below 50%\")*20)+(COUNTIF(C116:C119,\"Above 50%\")*70)+(COUNTIF(C116:C119,\"100%\")*100)","v":0},{"$f":"(COUNTIF(D116:D119,\"Below 50%\")*20)+(COUNTIF(D116:D119,\"Above 50%\")*70)+(COUNTIF(D116:D119,\"100%\")*100)","v":0}]
[null,"2.5 SKILLS DEVELOPMENT\nSTATEMENT OF INTENT : Farmers contribute towards skills development. "]
[null,null,"LEGAL","BMP"]
[null,"Compliance with the Skills Development Levies Act 9 of 1999",null,"NOTES…"]
["2.5.1","Are you required to pay a skills development levy (annual payroll exceeds R 500 000)?",{"$f":"PROSPERITY!C92","v":0}]
["2.5.2","Do you pay a skills development levy at a rate of 1% of the total remuneration (including overtime payments, leave pay, bonuses, commissions and lump sum payments) payable to employees? ",{"$f":"PROSPERITY!C93","v":0},null,{"$f":"PROSPERITY!E93","v":"N/A"}]
["2.5.3","Do you provide opportunities for staff development? These may include sending  staff on relevant formal training courses, such as SASRI Junior or Senior Certificate Courses or Shukela Training Centre Courses.",null,null,{"$f":"IF(D127=\"Yes\",1,IF(D127=\"N/A\",\"N/A\",0))","v":0}]
["2.5.4"," Do you conduct in-house training events?",null,null,{"$f":"IF(D128=\"Yes\",1,IF(D128=\"N/A\",\"N/A\",0))","v":0}]
[null,"SKILLS DEVELOPMENT",{"$f":"IF(PROFILE!C22=0,\"N/A\",E126)","v":"N/A"},{"$f":"IF(PROFILE!C22=0,\"N/A\",IFERROR(AVERAGE(E127:E128),\"N/A\"))","v":"N/A"}]
[]
[null,"2.6 PUBLIC RECREATION\nSTATEMENT OF INTENT : Recreational facilities for the public are provided on a voluntary basis."]
[null,null,"LEGAL","BMP"]
[null,null,null,"NOTES…"]
["2.6.1","Do you allow public access to your farm for recreational purposes?",null,null,{"$f":"IF(D134=\"Yes\",1,\"\")","v":""}]
["2.6.2","Are you familiar with the obligations associated with allowing public access to your property?",null,null,{"$f":"IF(C135=\"Yes\",1,0)","v":0}]
["2.6.3","Do the toilet facilities comply with the by-laws of the local municipality?",null,null,{"$f":"IF(C136=\"Yes\",1,IF(C136=\"N/A\",\"N/A\",0))","v":0}]
["2.6.4","Where re-establishment of indigenous wildlife (mammals, fish)  occurs, is this being done in accordance with the legislation?",null,null,{"$f":"IF(C137=\"Yes\",1,IF(C137=\"N/A\",\"N/A\",0))","v":0}]
["2.6.5","Are suitable 'exclusion of liability' signs clearly visible?",null,null,{"$f":"IF(C138=\"Yes\",1,0)","v":0}]
["2.6.6","Do you control public access for reasons of security and fire protection?",null,null,{"$f":"IF(C139=\"Yes\",1,0)","v":0}]
["2.6.7","Are trails for public use designed and maintained to minimise soil loss?",null,null,{"$f":"IF(D140=\"Yes\",1,IF(D140=\"N/A\",\"N/A\",0))","v":0}]
[null,"PUBLIC RECREATION",{"$f":"IF(D134=\"Yes\",AVERAGE(E135:E139),\"N/A\")","v":"N/A"},{"$f":"IF(D134=\"No\",\"N/A\",AVERAGE(E134,E140))","v":0}]
[]
[null,"2.7 HERITAGE\nSTATEMENT OF INTENT : Cultural assets are protected."]
[null,null,"LEGAL","BMP"]
[null,"National Heritage Resources Act 25 of 1999",null,"NOTES…"]
["2.7.1","Is maintenance, repair and management of historically important sites, buildings, graves, archaeological and paleontological sites and artefacts, rock art, cultural sites practised in terms of the law?",null,null,{"$f":"IF(C146=\"Yes\",1,IF(C146=\"No\",,\"\"))","v":""}]
["2.7.2","Are these sites incorporated into the Land Use Plan?",null,{"$f":"IF(PROSPERITY!D23=\"\",\"\",PROSPERITY!D23)","v":""},{"$f":"IF(D147=\"Yes\",1,IF(D147=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,"HERITAGE",{"$f":"IF(PROFILE!C24=\"No\",\"N/A\",E146)","v":""},{"$f":"IF(PROFILE!C24=\"No\",\"N/A\",E147)","v":"N/A"}]
[]
[null,"PEOPLE",{"$f":"IFERROR(AVERAGE(C148,C141,C129,C120,C110,C101,C61),\"N/A\")","v":0},{"$f":"IFERROR(AVERAGE(D148,D141,D129,D120,D110,D101,D61),\"N/A\")","v":0}]

{"sheet":"PLANET","index":4,"n_rows":430,"n_cols":7,"rows_kept":430,"cut":false,"hidden":false,"merged":[[391,1,391,3],[50,1,50,3],[142,1,142,3],[106,1,106,3],[228,1,228,3],[266,1,266,3],[84,1,84,3],[190,1,190,3],[356,1,356,3],[39,1,39,3],[300,1,300,3],[96,1,96,3],[117,1,117,3],[1,1,1,3],[2,1,2,3],[25,1,25,3]]}
[]
[null,"PLANET"]
[null,"3.1  THREATENED, CRITICAL AND PROTECTED SPECIES AND ECOSYSTEMS\nSTATEMENT OF INTENT : Threatened and protected species are protected.",null,null,null,"NOTES"]
[null,null,"LEGAL","BMP"]
[null,"Threatened and protected species","NOTES…"]
["3.1.1","Have you cut, damaged or destroyed any forest, or indigenous trees in that forest, or any trees deemed protected in terms of the National Forest Act 84 of 1998 and identified in the Government Gazette? If you have done so under a licence, answer 'No'.",null,null,{"$f":"IF(C6=\"No\",1,0)","v":0}]
["3.1.2","Do you comply with the requirements of the National Environmental Management: Biodiversity Act 10 of 2004 in terms of any identified restricted activity (section 57), a threatening process or a listed threatened species (section 53)?",null,null,{"$f":"IF(C7=\"Yes\",1,IF(C7=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.1.3","Do you comply with the requirements of protected and specially protected species as prescribed in terms of provincial legislation (e.g. Mpumalanga Nature Conservation Act 10 of 1998 or KZN Nature Conservation Act 29 of 1992)?",null,null,{"$f":"IF(C8=\"Yes\",1,IF(C8=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,"Threatened and protected ecosystems","NOTES…"]
["3.4.7","Is fire sensitive natural vegetation protected through an effective fire protection programme?",null,null,{"$f":"IF(D10=\"Yes\",1,IF(D10=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.3.1","Have you allowed any process or activity in a listed threatened ecosystem to take place in the absence of a permit? ",null,null,{"$f":"IF(C11=\"Yes\",0,IF(C11=\"No\",1,\"N/A\"))","v":"N/A"}]
[null,"Have you performed any voluntary protection of land based on its inherent environmental characteristics e.g. establishment of conservation agreements or formation of conservancies?",null,null,{"$f":"IF(D12=\"Yes\",1,IF(D12=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,"Better management practices are implemented in natural areas and heritage resources are protected:",null,"NOTES…"]
["3.3.4","Are natural areas identified and mapped?",null,null,{"$f":"IF(D14=\"Yes\",1,0)","v":0}]
["3.4.6","Do you manage these areas with fire?",null,null,{"$f":"IF(D15=\"Yes\",1,0)","v":0}]
["3.3.8","Has any natural vegetation been classified?",null,null,{"$f":"IF(D16=\"Yes\",1,0)","v":0}]
["3.3.9","Is the natural vegetation on the farm, or adjoining farms/neighbours connected in the form of corridors?",null,null,{"$f":"IF(D17=\"Yes\",1,IF(D17=\"No\",0,0.75))","v":0.75}]
[null,"Have you considered the costs and benefit of removing sugarcane from wetlands and areas adjacent to watercourses?",null,null,{"$f":"IF(D18=\"Yes\",1,IF(D18=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.3.7","Are nesting sites of protected bird species identified?",null,null,{"$f":"IF(D19=\"Yes\",1,0)","v":0}]
["3.3.12","Do you remove and destroy snares?",null,null,{"$f":"IF(D20=\"Yes\",1,IF(D20=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.3.13","Are you a member of a Conservancy Association?",null,null,{"$f":"IF(D21=\"Yes\",1,IF(D21=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.3.15","Are indigenous plant seeds (excluding protected species) collected and potted as part of a plant rescue programme or for the purposes of re-establishment elsewhere?",null,null,{"$f":"IF(D22=\"Yes\",1,IF(D22=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.3.2","Where hunting takes place, is this in accordance with the National Environmental Management: Biodiversity Act, 10 of 2004 and the provincial conservation legislation?",null,null,{"$f":"IF(C23=\"Yes\",1,IF(C23=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,null,{"$f":"IF(PROFILE!C25=\"No\",\"N/A\",(AVERAGE(E6:E8,E11,E23)))","v":0},{"$f":"IF(PROFILE!C25=\"No\",\"N/A\",IFERROR(AVERAGE(E14:E22,E10,E12),\"N/A\"))","v":0.15}]
[]
[null,"3.2 ALIEN AND INVASIVE SPECIES\nSTATEMENT OF INTENT : Alien and invasive species and weeds posing potential threats to biodiversity are controlled."]
[null,null,"LEGAL","BMP"]
[null,"Conservation of Agricultural Resources Act No. 43 of 1983",null,"NOTES…"]
["3.2.1","Are you actively controlling all Declared Weeds (Category 1 plants) that occur on land or on inland water?",null,null,{"$f":"IF(C29=\"Yes\",1,IF(C29=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.2.3","Do you control any Category 2 plants growing outside a demarcated plantation area?",null,null,{"$f":"IF(C30=\"Yes\",1,IF(C30=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.2.4","Are there any unauthorised plantings of Category 2 plants within 30 m of the 1:50 year flood line of a water resource?",null,null,{"$f":"IF(C31=\"No\",1,0)","v":0}]
["3.2.5","Have you planted or propagated any Category 3 plants since 30 March 2001?",null,null,{"$f":"IF(C32=\"No\",1,0)","v":0}]
["3.2.6","Are there any Category 3 plants within 30 m of the 1:50 year flood line of a water resource?",null,null,{"$f":"IF(C33=\"No\",1,0)","v":0}]
[null,"National Environmental Management: Biodiversity Act 10 of 2004, for restricted activities"]
[null,"Do you have a control plan for the management of invasive plant species on your farm?",null,null,{"$f":"IF(PROFILE!C14<=1,\"N/A\",IF(C35=\"Yes\",1,0))","v":"N/A"}]
[null,"Biological Weed Control"]
["3.2.7","Are you using biological weed control measures on your farm?",null,null,{"$f":"IF(D37=\"Yes\",1,0)","v":0}]
[null,null,{"$f":"AVERAGE(E29:E35)","v":0},{"$f":"E37","v":0}]
[]
[null,"3.3 FIRE\nSTATEMENT OF INTENT: Veld and forest fires are prevented"]
[null,null,"LEGAL","BMP"]
[null,"Farmers comply with the National Veld and Forest Fire Act 101 of 1998.",null,"NOTES…"]
["3.5.6","Are you a member of a local Fire Protection Association?",null,null,{"$f":"IF(C43=\"Yes\",1,IF(C43=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.15.1","Do you prepare and maintain firebreaks on your side of the boundary between your land and the adjoining land?",null,null,{"$f":"IF(C44=\"Yes\",1,IF(C44=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,"Do you notify neighbours of the intention to burn?",null,null,{"$f":"IF(C45=\"Yes\",1,IF(C45=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,"Do you notify the fire protection association of the intention to burn?",null,null,{"$f":"IF(C46=\"Yes\",1,IF(C46=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.15.2","Do you have the necessary equipment and personnel to fight fires?",null,null,{"$f":"IF(C47=\"Yes\",1,IF(C47=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.15.3","Are you aware of the annual restrictions on the burning of firebreaks and crop residue (trash)?",null,null,{"$f":"IF(C48=\"Yes\",1,0)","v":0}]
[null,null,{"$f":"IFERROR(AVERAGE(E43:E48),\"N/A\")","v":0},"N/A"]
[]
[null,"3.4 POLLUTION CONTROL\nSTATEMENT OF INTENT : Significant pollution of the environment is prevented, contained, minimised or remedied. "]
[null,null,"LEGAL","BMP"]
[null,"Air pollution is avoided, or where it cannot be avoided, is minimised.",null,"NOTES…"]
["3.5.1","What percentage of the harvested area was green-cane harvested (i.e. not burnt)?",null,null,{"$f":"D54","v":0}]
["3.5.3","Do you comply with the restrictions on burning over weekends and other periods when burning is prohibited?",null,null,{"$f":"IF(D$54=100%,\"N/A\",IF(C55=\"Yes\",1,0))","v":0}]
["3.5.4","Do you advise provincial traffic authorities when burning along public roads?",null,null,{"$f":"IF(D$54=100%,\"N/A\",IF(C56=\"Yes\",1,IF(C56=\"No\",0,\"N/A\")))","v":"N/A"}]
["3.5.5","Do you adhere to safe practices when burning along public roads?",null,null,{"$f":"IF(D$54=100%,\"N/A\",IF(C57=\"Yes\",1,IF(C57=\"No\",0,\"N/A\")))","v":"N/A"}]
["3.5.7","Have you identified areas sensitive to burning  e.g. public roads, residential areas, beaches, power lines, etc.?",null,null,{"$f":"IF(D58=\"Yes\",1,IF(D58=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.5.8","Do you leave a barrier of unburnt cane adjacent to sensitive areas?",null,null,{"$f":"IF(D59=\"Yes\",1,IF(D59=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.5.9","Do you consider weather forecasts and local knowledge as to the advisability and time of burning?",null,null,{"$f":"IF(D$54=100%,\"N/A\",IF(D60=\"Yes\",1,0))","v":0}]
["3.5.11","Have you planned the harvest programme so that there are always fields that may be green cane harvested (trashed) or safely burned if burning is inadvisable?",null,null,{"$f":"IF(D$54=100%,\"N/A\",IF(D61=\"Yes\",1,0))","v":0}]
["3.5.12","Do you advise authorities in the event of an unintended burn?",null,null,{"$f":"IF(D62=\"Yes\",1,0)","v":0}]
["3.5.13","Do you record fields burnt, date and time of burn?",null,null,{"$f":"IF(D63=\"Yes\",1,0)","v":0}]
["3.5.14","Do you ever burn cane in stacks in the fields or on the zones?",null,null,{"$f":"IF(D64=\"No\",1,0)","v":0}]
["3.5.15","Do you flatten cane under power lines before burning?",null,null,{"$f":"IF(D65=\"Yes\",1,IF(D65=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,"Better management practice systems are in place to prevent soil and water pollution.",null,"NOTES…"]
[null,"Do you regularly analyse your organic fertiliser?",null,null,{"$f":"IF(PROFILE!C$49=\"No\",\"N/A\",IF(D67=\"Yes\",1,0))","v":0}]
["3.5.17","Are organic fertiliser stock piles placed at least 30 m away from natural water sources or stormwater run-off systems?",null,null,{"$f":"IF(PROFILE!C$49=\"No\",\"N/A\",IF(D68=\"Yes\",1,0))","v":0}]
["3.5.18","Are organic fertiliser stock piles protected against the breeding of insects and pests and from wind-blown dispersal?",null,null,{"$f":"IF(PROFILE!C$49=\"No\",\"N/A\",IF(D69=\"Yes\",1,0))","v":0}]
["3.5.19","Are residential/public areas avoided when siting organic stock piles?",null,null,{"$f":"IF(PROFILE!C$49=\"No\",\"N/A\",IF(D70=\"Yes\",1,0))","v":0}]
[null,"Do you wash or service tractors or equipment?"]
["3.5.20","Are wash-bay facilities provided for cleaning tractors and equipment?",null,null,{"$f":"IF(D71=\"No\",\"N/A\",IF(D72=\"Yes\",1,0))","v":0}]
[null,"Is all run-off from the wash-bay directed into a protected sump?",null,null,{"$f":"IF(D71=\"No\",\" N/A\",IF(D73=\"Yes\",1,0))","v":0}]
[null,"Is collected contaminated water lawfully disposed of to minimise contamination of ground-water?",null,null,{"$f":"IF(D71=\"No\",\" N/A\",IF(D74=\"Yes\",1,0))","v":0}]
["3.5.21","Is all oil and diesel from vehicles serviced in fields and workshops collected and lawfully disposed of?",null,null,{"$f":"IF(D71=\"No\",\" N/A\",IF(D75=\"Yes\",1,0))","v":0}]
["3.5.23","Does servicing of vehicles occur in the proximity of waterways?",null,null,{"$f":"IF(D71=\"No\",\" N/A\",IF(D76=\"Yes\",0,1))","v":1}]
[null,"Waste disposal",null,"NOTES…"]
["3.5.26","Do your small waste disposal sites that are exempted from the need to be registered comply with conditions of the exemption?",null,null,{"$f":"IF(C78=\"Yes\",1,IF(C78=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.5.27","Are steps taken to avoid visible littering?",null,null,{"$f":"IF(C79=\"Yes\",1,0)","v":0}]
[null,"Disposal of hazardous substances",null,"NOTES…"]
["3.5.28","Are empty containers previously holding hazardous substances returned to the supplier where the label requires that they be returned?",{"$f":"PEOPLE!C43","v":0},null,{"$f":"IF(C81=\"Yes\",1,0)","v":0}]
["3.5.29","Where these containers are not required to be returned to the supplier, are they disposed of at an authorised landfill site?",null,null,{"$f":"IF(C82=\"Yes\",1,IF(C82=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,null,{"$f":"AVERAGE(E55:E57,E78:E82)","v":0},{"$f":"AVERAGE(E54,E58:E76)","v":6.6666666666666666E-2}]
[]
[null,"3.5 TRANSFORMATION OF THE NATURAL ENVIRONMENT\nSTATEMENT OF INTENT : Significant transformation of the environment is prevented, contained, minimised or remedied."]
[null,null,"LEGAL","BMP"]
[null,"Environment Conservation Act (sections 21, 22 and 26)\nNational Environmental Management Act 107 of 1998 (section 24).",null,"NOTES…"]
[null,"If you are undertaking any of the following activities, do you have appropriate authorisation?"]
["3.6.1","• To construct or expand a structure (including dams) within a watercourse or within 32 metres of the edge of a watercourse? ",null,null,{"$f":"IF(C89=\"Yes\",1,IF(C89=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,"• To infill or deposit any material of more than 5 cubic metres into, or the dredging, excavation, removal or moving of soil, sand or rock of more than 5 cubic metres from a watercourse?",null,null,"N/A"]
["3.6.3","• To clear more than 1 ha of indigenous vegetation in prescribed areas or more than 20 ha of indigenous vegetation?.",null,null,"N/A"]
[null,"• To physically alter virgin soil to agriculture of 100 hectares or more?",null,null,"N/A"]
[null,"• To clear indigenous vegetation of more than 300m2 in certain sensitive geographical areas?",null,null,"N/A"]
[null,"• To construct or expand roads above prescribed thresholds?",null,null,"N/A"]
[null,null,{"$f":"IFERROR(AVERAGE(E89:E94),\"N/A\")","v":"N/A"},"N/A"]
[]
[null,"3.6 QUARRIES\nSTATEMENT OF INTENT : Management of quarries to prevent environmental impacts."]
[null,null,"LEGAL","BMP"]
[null,"Farmers comply with the requirements of the Department of Mineral Resources and any environmental authorisation under the NEMBA EIA Regulations and Listing Notices.",null,"NOTES…"]
["3..17.1","Do you have a mining permit for your new or existing quarry or borrow pit?",null,null,{"$f":"IF(OR(PROFILE!C26=\"No\",PROFILE!C27=\"No\"),\"N/A\",IF(C100=\"Yes\",1,0))","v":0}]
["3..17.4","Are quarries marked on the Land Use Plan?",{"$f":"PROSPERITY!C12","v":0},null,{"$f":"IF(PROFILE!C26=\"No\",\"N/A\",IF(C101=\"Yes\",1,0))","v":0}]
["3..17.6","Do quarries have minimum visual impact and are sited away from public or recreation routes?",null,null,{"$f":"IF(PROFILE!C26=\"No\",\"N/A\",IF(D102=\"Yes\",1,0))","v":0}]
["3..17.5","Is top soil from new quariries set aside for eventual closure?",null,null,{"$f":"IF(PROFILE!C26=\"No\",\"N/A\",IF(D103=\"Yes\",1,0))","v":0}]
["3..17.7","Are disused quarries rehabilitated or converted to water bodies (dams)?",null,null,{"$f":"IF(D104=\"Yes\",1,IF(D104=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,null,{"$f":"IF(PROFILE!$C$26=\"No\",\"N/A\",IF(PROFILE!$C$27=\"No\",\"N/A\",AVERAGE(E100:E101)))","v":0},{"$f":"IF(PROFILE!$C$26=\"No\",\"N/A\",AVERAGE(PLANET!E102:E104))","v":0}]
[]
[null,"3.7 WATER USE\nSTATEMENT OF INTENT : Water resources are conserved."]
[null,null,"LEGAL","BMP"]
[null,"Authorised Water Use",null,"NOTES…"]
[null,"Schedule 1 Water Use refers to water used for domestic purposes, or water is that is used from roof run-off, or water used in an emergency (see notes.) \n\nWater use that falls outside Schedule 1 includes:\ntaking and storing water, activities which reduce stream flow (e.g. cultivation of crops), waste discharges and disposals, controlled activities (activities which impact detrimentally on a water resource), altering a watercourse, removing water found underground for certain purposes, and recreation. \n\nIf any water use  falls outside Schedule 1 use, it must be registered with the Department of Water Affairs who will process the necessary authorisation. \n\nPlease select an option below that best describes your situation."]
["3.10.1","Option 1:  All water use on the farm is Schedule 1 water use."]
[null,"Option 2:  Some water use falls outside Schedule 1 use, but is not yet registered with DWA."]
[null,"Option 3: Some water use falls outside Schedule 1, registration has taken place but authorisation has not yet been received."]
[null,"Option 4:  Some water use falls outside Schedule 1, registration has taken place and authorisation received."]
[null,"Option 5:  I do not know."]
[null,null,{"$f":"IF(OR(C110=\"Option 1\",C110=\"Option 4\",C110=\"Option 3\"),1,0)","v":0},"N/A"]
[]
[null,"3.8 WETLANDS & WATERCOURSES\nSTATEMENT OF INTENT : Wetlands and natural watercourses are conserved."]
[null,null,"LEGAL","BMP"]
[null,"Vleis, marshes, water sponges and water courses are protected in\n terms of regulations published under the Conservation of Agricultural\nResources Act 43 of 1983.",null,"NOTES…"]
["3.12.2","Has utilisation of vegetation in a wetland or within the flood area of a water course, or within 10 meters horizontally outside the flood area, damaged the area?",null,null,{"$f":"IF(PROFILE!C25=\"No\",\"N/A\",IF(C121=\"Yes\",0,1))","v":1}]
["3.12.3","Has there been any cultivation or drainage of a vlei, marsh or water sponge, or any land within the flood area or within 10 m horizontally outside the flood area or watercourse?",null,null,{"$f":"IF(PROFILE!C25=\"No\",\"N/A\",IF(C122=\"Yes\",0,1))","v":1}]
[null,"The flow pattern of water is regulated in terms of regulations published \nunder the Conservation of Agricultural Resources Act 43 of 1983.",null,"NOTES…"]
["3.12.4","If any run-off water from a water course has been diverted to another water course, has authorisation first been obtained?",null,null,{"$f":"IF(C124=\"Yes\",1,IF(C124=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,"Wetland management",null,"NOTES…"]
["3.12.8","Are there any category 2 or 3 plants within 30 m of the 1:50 year flood line of wetlands?",{"$f":"C33","v":0},null,{"$f":"IF(PROFILE!C25=\"No\",\"N/A\",IF(C126=\"Yes\",0,1))","v":1}]
["3.12.11","Have natural wetlands been identified and mapped?",null,{"$f":"IF(PROSPERITY!C10=\"\",\"\",PROSPERITY!C10)","v":""},{"$f":"IF(PROFILE!C25=\"No\",\"N/A\",IF(D127=\"Yes\",1,IF(D127=\"No\",0,\"N/A\")))","v":"N/A"}]
["3.12.13","Is controlled burning/grazing practised in wetland areas?",null,null,{"$f":"IF(PROFILE!C25=\"No\",\"N/A\",IF(D128=\"Yes\",1,0))","v":0}]
[null,"Natural watercourses",null,"NOTES…"]
["3.12.17","Have natural watercourses been identified and mapped?",null,{"$f":"IF(PROSPERITY!C10=\"\",\"\",PROSPERITY!C10)","v":""},{"$f":"IF(PROFILE!C25=\"No\",\"N/A\",IF(D130=\"Yes\",1,IF(D130=\"No\",0,\"N/A\")))","v":"N/A"}]
["3.12.18","Are alien invaders and exotic plants removed regularly from watercourses?",null,null,{"$f":"IF(PROFILE!C25=\"No\",\"N/A\",IF(D131=\"Yes\",1,0))","v":0}]
["3.12.19","Have any forested riparian areas been burnt?",null,null,{"$f":"IF(PROFILE!C25=\"No\",\"N/A\",IF(D132=\"Yes\",0,1))","v":1}]
["3.12.20","Are disturbed watercourses rehabilitated?",null,null,{"$f":"IF(D133=\"Yes\",1,IF(D133=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,"Wet agricultural land (i.e. relic wetlands)",null,"NOTES…"]
["3.12.21","Do you have any wet agricultural land?"]
["3.12.22","Have any mechanical practices been used to clean drains? If this is done with authorisation, answer 'No.'",null,null,{"$f":"IF(D135=\"No\",\"N/A\",IF(C136=\"No\",1,0))","v":0}]
["3.12.23","Have any existing drains been widened or deepened?",null,null,{"$f":"IF(D135=\"No\",\"N/A\",IF(C137=\"No\",1,IF(C137=\"Yes\",0,\"N/A\")))","v":"N/A"}]
["3.12.24","Is there any evidence of active erosion?",null,null,{"$f":"IF(D135=\"No\",\"N/A\",IF(C138=\"No\",1,0))","v":0}]
["3.12.25","Are approved plans available for any alterations to existing drains?",null,null,{"$f":"IF(D135=\"No\",\"N/A\",IF(C139=\"No\",0,IF(C139=\"Yes\",1,\"N/A\")))","v":"N/A"}]
["3.12.26","Have relic wetlands been (or are being) rehabilitated?",null,null,{"$f":"IF(D135=\"No\",\"N/A\",IF(D140=\"No\",0,1))","v":1}]
[null,null,{"$f":"IFERROR(AVERAGE(E121:E126,E136:E139),\"N/A\")","v":0.6},{"$f":"IFERROR(AVERAGE(E127:E133,E140),\"N/A\")","v":0.5}]
[]
[null,"3.9 IRRIGATION & DRAINAGE\nSTATEMENT OF INTENT : Irrigation systems are planned and managed to conserve water."]
[null,null,"LEGAL","BMP"]
[null,"Planning & Design",null,"NOTES…"]
["3.11.1","What proportion of the irrigation system meets the daily peak crop water requirements (ET) or some agreed proportion of the daily peak crop water requirement?",null,null,{"$f":"D146","v":0},null," "]
["3.11.2","For what proportion of irrigation events is the volume of water applied per irrigation event (target application depth) less than 50% of the storage capacity of the soil (Total Available Water (TAW))?",null,null,{"$f":"D147","v":0}]
["3.11.3","Is the water source taken into account in planning and design of the irrigation system?",null,null,{"$f":"IF(D148=\"Yes\",1,0)","v":0}]
["3.11.4","For new irrigation systems, have your preferences been taken into account in planning and design of the system?",null,null,{"$f":"IF(D149=\"Yes\",1,IF(D149=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.11.5","Has the irrigation system been designed in accordance with SABI norms?",null,null,{"$f":"IF(D150=\"Yes\",1,0)","v":0}]
["3.11.6","Do you have the design documentation for the irrigation system?",null,null,{"$f":"IF(D151=\"Yes\",1,0)","v":0}]
[null,"Operation and Monitoring",null,"NOTES…"]
["3.11.7","Are irrigation systems operated according to design specifications by regularly checking pressure and discharge (flow)?",null,null,{"$f":"VLOOKUP(D153,OPTSCORE1,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Irrigation Scheduling",null,"NOTES…"]
["3.11.8","Is irrigation scheduling  practised using an appropriate method to prevent over and under irrigation?",null,null,{"$f":"VLOOKUP(D155,OPTSCORE1,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Preventative Maintenance",null,"NOTES…"]
["3.11.9","Is preventative maintenance of systems performed in accordance with a pre-determined schedule, to remain within manufacturers' design specifications?",null,null,{"$f":"VLOOKUP(D157,OPTSCORE1,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Energy Use Efficiency",null,"NOTES…"]
["3.11.10","Is the electric motor coupled to the irrigation pump of the proper size (i.e. not excessively over-sized)?",null,null,{"$f":"IF(D159=\"Yes\",1,0)","v":0}]
["3.11.11","Has the most appropriate ESKOM electricity tariff option been selected?",null,null,{"$f":"VLOOKUP(D160,OPTSCORE1,2,FALSE)","v":{"$error":"#N/A"}}]
["3.11.12","Is pump operation, informed by irrigation scheduling, limited during the electricity peak hours when possible?",null,null,{"$f":"VLOOKUP(D161,OPTSCORE1,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Evaluation",null,"NOTES…"]
["3.11.13","Is the irrigation system evaluated at least every two years to ensure uniform and accurate application of water?",null,null,{"$f":"IF(D163=\"Yes\",1,0)","v":0}]
[null,"Water Monitoring, Metering and Recording",null,"NOTES…"]
["3.11.14","Is irrigation water volume measured at the point of abstraction to ensure compliance with authorised allocation and abstraction rates? ",null,null,{"$f":"VLOOKUP(D165,OPTSCORE1,2,FALSE)","v":{"$error":"#N/A"}}]
["3.11.15","Do you keep a record of water used per annum?",null,null,{"$f":"IF(D166=\"Yes\",1,0)","v":0}]
[null,"Monitoring Water Quality",null,"NOTES…"]
["3.11.17","Is the quality of irrigation water monitored twice a year (during winter and summer) for irrigation suitability?",null,null,{"$f":"IF(D168=\"Yes\",1,0)","v":0}]
[null,"Salinity and Sodicity",null,"NOTES…"]
["3.11.18","Are soil samples taken annually for irrigated lands and assessed for total soluble salts and sodium absorption ratio, and are practices adapted when required?",null,null,{"$f":"VLOOKUP(D170,OPTSCORE1,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Irrigation with wastewater",null,"NOTES…"]
["3.11.19","Do you irrigate with wastewater?"]
["3.11.20","Is your irrigation with wastewater authorised?",null,null,{"$f":"IF(C172=\"No\",\"N/A\",IF(C173=\"Yes\",1,0))","v":0}]
["3.11.21","Are you meeting the conditions of that authorisation?",null,null,{"$f":"IF(C172=\"No\",\"N/A\",IF(C174=\"Yes\",1,0))","v":0}]
["3.11.22","Do you conduct precautionary monitoring of wastewater according to the National Water Act?",null,null,{"$f":"IF(C172=\"No\",\"N/A\",IF(C175=\"Yes\",1,0))","v":0}]
[null,"Have you implemented the following measures to protect irrigated land against waterlogging and salination?",null,"NOTES…"]
["3.11.23","Feeder channels, irrigation furrows and storage and catchment dams for irrigation water are made impermeable.",null,null,{"$f":"VLOOKUP(C177,OPTSCORE3,2,FALSE)","v":{"$error":"#N/A"}}]
["3.11.24","Irrigation water has low salt content",null,null,{"$f":"VLOOKUP(C178,OPTSCORE3,2,FALSE)","v":{"$error":"#N/A"}}]
["3.11.25","Soil conservation works have been constructed to draw off excess surface and subsurface water so as to dispose of it, to prevent the waterlogging and salination of lower lying land.",null,null,{"$f":"IF(C179=\"Yes\",1,IF(C179=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.11.26","Fertilisers that could contribute to salination have been avoided.",null,null,{"$f":"IF(C180=\"Yes\",1,0)","v":0}]
["3.11.27","Soil ameliorants have been applied to land showing signs of salination.",null,null,{"$f":"IF(C181=\"Yes\",1,IF(C181=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,"Drainage management",null,"NOTES…"]
["3.11.28","If any new drainage systems have been established, has this been done under the necessary water use licence and, where necessary, environmental authorisation?",null,null,{"$f":"IF(C183=\"Yes\",1,IF(C183=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.11.29","Are existing drainage systems managed to maintain flow?",null,null,{"$f":"VLOOKUP(D184,OPTSCORE3,2,FALSE)","v":{"$error":"#N/A"}}]
["3.11.30","Are existing drains stabilised with grass?",null,null,{"$f":"VLOOKUP(D185,OPTSCORE3,2,FALSE)","v":{"$error":"#N/A"}}]
["3.11.31","Are drain outlets protected to prevent erosion?",null,null,{"$f":"VLOOKUP(D186,OPTSCORE3,2,FALSE)","v":{"$error":"#N/A"}}]
["3.11.32","Does an annual maintenance programme exist?",null,null,{"$f":"IF(D187=\"Yes\",1,0)","v":0}]
[null,null,{"$f":"IF(PROFILE!C15+PROFILE!C16=0,E183,AVERAGE(E173:E183))","v":"N/A"},{"$f":"IF(PROFILE!C15+PROFILE!C16=0,AVERAGE(E184:E187),AVERAGE(E146:E170,E184:E187))","v":{"$error":"#N/A"}}]
[]
[]
[null,"3.10 SOIL CONSERVATION: LAYOUT\nSTATEMENT OF INTENT : Soil erosion is minimised."]
[null,null,"LEGAL","BMP"]
[null,"Conservation of Agricultural Resources Act 43 of 1983"]
[null,"Cultivation of new land",null,"NOTES…"]
["3.7.1","If you have virgin land available, has any been cultivated without written authority?",null,null,{"$f":"IF(C195=\"Yes\",0,IF(C195=\"No\",1,\"N/A\"))","v":"N/A"}]
["3.7.2","Has any land with a slope of more than 20% been cultivated without written authority?",null,null,{"$f":"IF(C196=\"Yes\",0,IF(C196=\"No\",1,\"N/A\"))","v":"N/A"}]
["3.7.3","Has any land with a slope of more than 12%, and situated in certain magisterial areas (namely Eshowe) been cultivated without written authority?",null,null,{"$f":"IF(C197=\"No\",1,IF(C197=\"Yes\",0,\"N/A\"))","v":"N/A"}]
[null,"For EXISTING conditions:"]
["3.7.5","• Are the maximum slope limits, according to the soil erodibility rating in KZN, being adhered to? ",null,null,{"$f":"VLOOKUP(C199,OPTSCORE4,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"• Are there visible signs of erosion?",null,null,{"$f":"IF(C200=\"Yes\",0,1)","v":1}]
[null,"Mapping",null,"NOTES…"]
["3.7.6","Are soil types (forms) mapped and classified in terms of their erodibility?",null,{"$f":"IF(PROSPERITY!D16=\"\",\"\",PROSPERITY!D16)","v":""},{"$f":"IF(D202=\"Yes\",1,IF(D202=\"N/A\",\"N/A\",0))","v":0}]
[null,"Conservation structures ",null,"NOTES…"]
[null,"Do you have slopes over 2% ?"]
["3.7.7","Is land over 2% slope protected by conservation structures?",null,null,{"$f":"IF(D$204=\"No\", \"N/A\", VLOOKUP(D205,OPTSCORE3,2,FALSE))","v":{"$error":"#N/A"}}]
["3.7.8","Are panel widths within specifications for slopes?",null,null,{"$error":"#N/A"}]
["3.7.9","Are highly erodible soils protected by conservation structures on slopes over 1.5%?",null,null,{"$f":"VLOOKUP(D207,OPTSCORE3,2,FALSE)","v":{"$error":"#N/A"}}]
["3.7.10","Are broad-based contour banks constructed on slopes of up to 12% ",null,null,{"$error":"#N/A"}]
["3.7.11","Are Improved Bench Contour Banks constructed on slopes steeper than 12%?",null,null,{"$f":"IF(D$204=\"No\", \"N/A\", VLOOKUP(D209,OPTSCORE4,2,FALSE))","v":{"$error":"#N/A"}}]
["3.7.12","Do conservation structures not exceed 300 m on weak (sandy) soils, and 400 m on good (clay) soil?",null,null,{"$error":"#N/A"}]
["3.7.13","Are conservation structures kept free from silt and debris where necessary?",null,null,{"$error":"#N/A"}]
[null,"Are conservation structures checked on plough-out  for line, level and grade?",null,null,{"$error":"#N/A"}]
["3.7.14","Are conservation structures stabilised through a suitable vegetative cover?",null,null,{"$error":"#N/A"}]
["3.7.15","Do conservation structures have acceptable accelerating gradients to discharge water from selected crestlines, across the slope, to selected waterways?",null,null,{"$error":"#N/A"}]
[null,"Waterways ",null,"NOTES…"]
[null,"Does the farm have waterway/s?"]
["3.7.16","Are waterways sited at the lowest point of selected natural depressions?",null,null,{"$f":"IF(D$216=\"No\", \"N/A\", VLOOKUP(D217,OPTSCORE3,2,FALSE))","v":{"$error":"#N/A"}}]
["3.7.17","In the absence of natural depressions, are artificial waterways constructed at right angles to the natural contour and/or adjacent to the crest road?",null,null,{"$f":"IF(D$216=\"No\", \"N/A\", VLOOKUP(D218,OPTSCORE3,2,FALSE))","v":{"$error":"#N/A"}}]
["3.7.18","Do the waterway dimensions conform to Land Use Plan specifications? ",null,null,{"$f":"IF(D$216=\"No\", \"N/A\", VLOOKUP(D219,OPTSCORE3,2,FALSE))","v":{"$error":"#N/A"}}]
["3.7.19","Are the discharge ends of waterways protected to prevent any undercutting?",null,null,{"$f":"IF(D$216=\"No\", \"N/A\", VLOOKUP(D220,OPTSCORE3,2,FALSE))","v":{"$error":"#N/A"}}]
["3.7.20","Have earth waterways been planted with a creeping grass suitable to the area?",null,null,{"$f":"IF(D$216=\"No\", \"N/A\", VLOOKUP(D221,OPTSCORE3,2,FALSE))","v":{"$error":"#N/A"}}]
["3.7.21","For new waterways, have revetts been spaced at 10 m intervals across the main axis of the waterway to prevent erosion until such time as the vegetative cover is adequate?",null,null,{"$f":"IF(D$216=\"No\", \"N/A\", VLOOKUP(D222,OPTSCORE4,2,FALSE))","v":{"$error":"#N/A"}}]
["3.7.23","Is there additional protection where extraction routes cross waterways?",null,null,{"$f":"IF(D$216=\"No\", \"N/A\", VLOOKUP(D223,OPTSCORE3,2,FALSE))","v":{"$error":"#N/A"}}]
["3.7.25","Have you avoided hoeing on the verges of all waterways?",null,null,{"$f":"IF(D216=\"No\",\"N/A\",IF(D224=\"Yes\",1,0))","v":0}]
["3.7.26","Are waterways used as roads or paths?",null,null,{"$f":"IF(D216=\"No\", \"N/A\",IF(D225=\"Yes\",0,1))","v":1}]
["3.7.27","Do the waterways allow for free flow of surface water?",null,null,{"$f":"IF(D$216=\"No\", \"N/A\", VLOOKUP(D226,OPTSCORE3,2,FALSE))","v":{"$error":"#N/A"}}]
[null,null,{"$f":"AVERAGE(E195:E200)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(E202:E226)","v":{"$error":"#N/A"}}]
[]
[null,"3.11 SOIL CONSERVATION: EXTRACTION\nSTATEMENT OF INTENT : Soil erosion is minimised."]
[null,null,"LEGAL","BMP"]
[null,"Roads are sited to minimise soil loss.",null,"NOTES…"]
["3.8.1","Are all roads included in the land-use plan?",null,{"$f":"IF(PROSPERITY!C8=\"\",\"\",PROSPERITY!C8)","v":""},{"$f":"IF(D232=\"Yes\",1,IF(D232=\"N/A\",\"N/A\",0))","v":0}]
["3.8.2","Does the land use plan specify road drainage for each road?",null,{"$f":"IF(PROSPERITY!C9=\"\",\"\",PROSPERITY!C9)","v":""},{"$f":"IF(D233=\"Yes\",1,IF(D233=\"N/A\",\"N/A\",0))","v":0}]
["3.8.3","Do farm roads follow the crestlines and/or conservation terraces except under specified circumstances?",null,null,{"$f":"VLOOKUP(D234,OPTSCORE4,2,FALSE)","v":{"$error":"#N/A"}}]
["3.8.4","Are crest roads on crests of 12% gradient or less?",null,null,{"$error":"#N/A"}]
["3.8.5","Are diagonal roads on slopes greater than 12%?",null,null,{"$error":"#N/A"}]
["3.8.10","Is soil erosion minimised  on unusually steep (>12%) areas where roads are constructed?",null,null,{"$error":"#N/A"}]
["3.8.6","Are routes selected to minimise impacts on sensitive areas? ",null,null,{"$error":"#N/A"}]
["3.8.7","Are primary roads (5 m wide) constructed more than 20 m away from a stream, river or wetland, except where they cross?",null,null,{"$error":"#N/A"}]
["3.8.8","Are secondary roads (at least 4 m wide) used for field access and cane haulage?",null,null,{"$error":"#N/A"}]
["3.8.9","Are tertiary roads (at least 3.5 m wide) used for infield access?",null,null,{"$error":"#N/A"}]
["3.8.11","Do roads cross watercourses at right-angles? ",null,null,{"$error":"#N/A"}]
["3.8.12","Does water drained off primary roads flow through a minimum of 10 m of natural vegetation or canefield before entering the watercourse?",null,null,{"$error":"#N/A"}]
["3.8.13","Are discharge points provided to protect the upper road channel?",null,null,{"$error":"#N/A"}]
["3.8.14","Are roadside drains grassed or paved?",null,null,{"$error":"#N/A"}]
[null,"Roads are constructed to minimise soil loss",null,"NOTES…"]
["3.8.15"," Has authority been sought for new roads or upgrades in sensitive areas or exeeding prescribed thresholds?",null,null,{"$f":"IF(C247=\"Yes\",1,IF(C247=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.8.16","Are drifts confined to sites where there is solid rock, or constructed of suitable material?",null,null,{"$f":"VLOOKUP(D248,OPTSCORE4,2,FALSE)","v":{"$error":"#N/A"}}]
["3.8.17","Are road cuttings and fills stabilised with suitable grasses?",null,null,{"$error":"#N/A"}]
[null,"Road maintenance",null,"NOTES…"]
[null,"Is crest road camber maintained where necessary?",null,null,{"$error":"#N/A"}]
["3.8.18","Are mitre drains constructed where necessary?",null,null,{"$error":"#N/A"}]
["3.8.19","Is water from district roads diverted into stable waterways?",null,null,{"$error":"#N/A"}]
["3.8.21","Are road drains and verges kept clear of invading vegetation to allow free flow of surface water?",null,null,{"$error":"#N/A"}]
["3.8.22","Are boundary breaks that are used as roads protected from erosion?",null,null,{"$error":"#N/A"}]
["3.8.23","Are grasses on secondary and tertiary roads maintained by slashing or chemical control?",null,null,{"$error":"#N/A"}]
["3.8.24","Are primary road surfaces protected by quarry, stone or cement?",null,null,{"$error":"#N/A"}]
[null,"Road culverts are in place to manage water discharge and \nminimise soil loss.",null,"NOTES…"]
["3.8.24","Can culverts accommodate a 1:10 year flood?",null,null,{"$error":"#N/A"}]
["3.8.25","Do culverts have a minimum diameter of 600 mm?",null,null,{"$error":"#N/A"}]
["3.8.26","Are culverts and their discharge points protected?",null,null,{"$error":"#N/A"}]
[null,"Road bridges are constructed to accommodate floods",null,"NOTES…"]
["3.8.27","Can farm bridges on primary roads accommodate a 1:20 year flood?",null,null,{"$error":"#N/A"}]
["3.8.28","Can farm bridges on  secondary roads accommodate a 1:10 year flood?",null,null,{"$error":"#N/A"}]
[null,null,{"$f":"E247","v":"N/A"},{"$f":"IFERROR(AVERAGE(E232:E245,E248:E264),\"N/A\")","v":"N/A"}]
[]
[null,"3.12 SOIL CONSERVATION: MANAGEMENT\nSTATEMENT OF INTENT : Farming operations are managed well so as to prevent soil erosion."]
[null,null,"LEGAL","BMP"]
[null,"Minimum tillage is practised to minimise soil erosion.",null,"NOTES…"]
["3.9.1","What percentage of the land under cane is tilled per annum?",null,null,{"$f":"D270","v":0}]
["3.9.2","Is minimum tillage  practised in recommended situations?\n- Slopes greater than 11% on erodible soils, \n- Slopes greater than 13% on moderately erodible soils and \n- Slopes greater than 16% on resistant soils.",null,null,{"$f":"VLOOKUP(D271,OPTSCORE4,2,FALSE)","v":{"$error":"#N/A"}}]
["3.9.3","On slopes less than those above, and where conventional tillage is practised, is this carried out along the contour?",null,null,{"$error":"#N/A"}]
[null,"Row alignment"]
[null,"Are there any areas where row alignment runs with the slope?"]
[null,"Where row alignment runs with the slopes, are slopes less than 2%?",null,null,{"$f":"IF(D274=\"No\",\"N/A\", VLOOKUP(D275,OPTSCORE4,2,FALSE))","v":{"$error":"#N/A"}}]
[null,"Where row alignment runs with the slopes and on parallel crest areas,  are slopes less than 2% on erodible soils, less than 3% on moderately erodible soils or less than  4% on resistant soils?",null,null,{"$f":"IF(D274=\"No\",\"N/A\", VLOOKUP(D276,OPTSCORE4,2,FALSE))","v":{"$error":"#N/A"}}]
[null,"Where row alignment runs with the slopes, are conservation structures in place?",null,null,{"$f":"IF(D274=\"No\",\"N/A\", VLOOKUP(D277,OPTSCORE4,2,FALSE))","v":{"$error":"#N/A"}}]
["3.9.5","Where row alignment runs with the slopes, do rows run over conservation structures?",null,null,{"$f":"IF(D274=\"No\",\"N/A\", VLOOKUP(D278,OPTSCORE4,2,FALSE))","v":{"$error":"#N/A"}}]
[null,"Strip planting is practised to minimise soil loss.",null,"NOTES…"]
["3.9.6","Is strip planting practised on all slopes exceeding 2%, except on certain specified irrigation layouts?",null,null,{"$error":"#N/A"}]
["3.9.7","Is strip planting practised only on areas that are equal to or less than three panels (three times the recommended vertical interval for that particular soil and slope) with sugarcane of at least six months difference in age on the upper and lower bordering strips?",null,null,{"$error":"#N/A"}]
["3.9.8","Where strip planting is not practised, have standards for dimensions and location of conservation structures (i.e. contour banks) been adjusted according to the SASRI nomograph and DAEA upper slope limits?",null,null,{"$error":"#N/A"}]
["3.9.9","Is alternate strip planting practised on slopes above 12%?",null,null,{"$error":"#N/A"}]
[null,"Harvesting operations minimise soil loss and compaction.",null,"NOTES…"]
["3.9.10","Are wet, poorly drained soils harvested during the dry season?",null,null,{"$error":"#N/A"}]
["3.9.11","Are grab loaders and infield vehicles operated with low tyre pressures and preferably radial ply tyres?",null,null,{"$error":"#N/A"}]
["3.9.12","Is the total mass distributed over all axles, with infield loads not exceeding 5 tons per axle?",null,null,{"$error":"#N/A"}]
["3.9.13","Where tandem axles are used, do you make use of walking beam axles?",null,null,{"$error":"#N/A"}]
["3.9.14","Are your vehicles driving on the interrows only?",null,null,{"$error":"#N/A"}]
["3.9.15","Is all in-field traffic following the same path each year?",null,null,{"$error":"#N/A"}]
[null,"Green cane harvesting (trashing) and/or burning of sugarcane is practised in terms of economic, social and environmental conditions.",null,"NOTES…"]
["3.9.16","On what percentage of harvested area is green cane harvesting practised?",null,{"$f":"D54","v":0},{"$f":"D292","v":0}]
["3.9.17","Are all harvested fields left with at least 30% ground cover (consisting of tops or leaves)?",null,null,{"$f":"VLOOKUP(D293,OPTSCORE4,2,FALSE)","v":{"$error":"#N/A"}}]
["3.9.18","Are cool burns carried out in the morning on slopes of more than 15%?",null,null,{"$f":"VLOOKUP(D294,OPTSCORE4,2,FALSE)","v":{"$error":"#N/A"}}]
["3.9.20","Is green cane harvesting practised on slopes greater than 15% and in areas where the cane residue blanket does not increase the risk of stools rotting or inhibition of ratooning?",null,null,{"$f":"VLOOKUP(D295,OPTSCORE4,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Choice of land newly planted to sugarcane",null,"NOTES…"]
["3.9.21","Is all newly planted sugarcane planted more than 10 m from the edge of a wetland or watercourse or as authorised?",null,null,{"$f":"VLOOKUP(C297,OPTSCORE4,2,FALSE)","v":{"$error":"#N/A"}}]
["3.9.22","Where there is a natural forest present, is all sugarcane more than 10 m from this forest?",null,null,{"$f":"VLOOKUP(C298,OPTSCORE4,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"IFERROR(AVERAGE(E297:E298), \"N/A\")","v":"N/A"},{"$f":"AVERAGE(E270:E295)","v":{"$error":"#N/A"}}]
[]
[null,"3.13 HAULAGE\nSTATEMENT OF INTENT : Sugarcane is transported efficiently and safely with spillage and overloading avoided"]
[null,null,"LEGAL","BMP"]
[null,"RTMS Accreditation",null,"NOTES…"]
["3.16.1","Is your haulage (loading and transport) operation RTMS accredited?"]
[null,"Do you transport more than 500 t cane in any one month?"]
[null,"LOADING (from zone to haulage vehicle)",null,"NOTES…"]
[null,"Do you make use of the services of a contractor for loading?"]
[null," Does a written agreement exist between yourself (as a consignor) and loading operator in terms of loading instructions and responsibilities of parties?",null,null,{"$f":"IF(OR(D307=\"No\",D305=\"No\"),\"N/A\",IF(C308=\"Yes\",1,0))","v":0}]
[null,"Loading Best Practices"]
["3.16.4","Is the loading equipment appropriate for the task?",null,null,{"$f":"IF(D307=\"Yes\",\"N/A\",IF(D310=\"Yes\",1,0))","v":0}]
["3.16.5","Is the loading equipment inspected  daily to ensure safe and efficient operation?",null,null,{"$f":"IF(D307=\"Yes\",\"N/A\",IF(D311=\"Yes\",1,0))","v":0}]
["3.16.6","Is the equipment maintained according to a regular maintenance schedule?",null,null,{"$f":"IF(D307=\"Yes\",\"N/A\",IF(D312=\"Yes\",1,0))","v":0}]
["3.16.7","Are loading staff trained to use the loading equipment properly?",null,null,{"$f":"IF(D307=\"Yes\",\"N/A\",IF(D313=\"Yes\",1,0))","v":0}]
["3.16.8","Is a schedule of training needs compiled and matched to a training plan?",null,null,{"$f":"IF(D307=\"Yes\",\"N/A\",IF(D314=\"Yes\",1,0))","v":0}]
["3.16.9","Is a record of all training conducted maintained?",null,null,{"$f":"IF(D307=\"Yes\",\"N/A\",IF(D315=\"Yes\",1,0))","v":0}]
["3.16.10","Are competency assessments conducted for all staff and operations?",null,null,{"$f":"IF(D307=\"Yes\",\"N/A\",IF(D316=\"Yes\",1,0))","v":0}]
["3.16.11","Is the loading operation timetable and practices arranged in a reasonable fashion so that driver fatigue is minimised?",null,null,{"$f":"IF(D307=\"Yes\",\"N/A\",IF(D317=\"Yes\",1,0))","v":0}]
["3.16.12","Do equipment operators undergo regular medical check-ups?",null,null,{"$f":"IF(D307=\"Yes\",\"N/A\",IF(D318=\"Yes\",1,0))","v":0}]
["3.16.13","Is there regular and open communication between management, equipment operators and loading staff on matters that affect the safe operation of the business?",null,null,{"$f":"IF(D307=\"Yes\",\"N/A\",IF(D319=\"Yes\",1,0))","v":0}]
["3.16.14","When using side-loading trailers, are cable drains parallel and deep enough to guide cables and are they closed after use?",null,null,{"$f":"IF(D307=\"Yes\",\"N/A\",IF(D320=\"Yes\",1,IF(D320=\"No\",0,\"N/A\")))","v":"N/A"}]
[null,"HAULAGE",null,"NOTES…"]
["3.16.15","Do you make use of the services of a haulier?"]
[null,"Does a written agreement exist between yourself (as a consignor) and haulage operator in terms of responsibilities of parties?",null,null,{"$f":"IF(OR(D305=\"No\",D322=\"No\"),\"N/A\",IF(C323=\"Yes\",1,0))","v":0}]
[null,"National Roads Amendment Act, 64 of 2008"]
[null,"Do you comply with the Road Traffic Act 93 of 1996 in terms of the manner in which sugarcane can be transported (section 246 of the National Road Traffic Regulations 1999 as amended in Government Gazette Notice No. R846)?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(C325=\"Yes\",1,0))","v":0}]
[null,"Do you comply with the axle mass of the load vehicle (section 234 – 239 of the National Road Traffic Regulations 1999 as amended in Government Gazette Notice No. R846)?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(C326=\"Yes\",1,0))","v":0}]
[null,"Load mass best practices"]
["3.16.16","Is the legal load capacity of the haulage vehicle known and documented?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D328=\"Yes\",1,0))","v":0}]
["3.16.17","Does a method exist for determining the mass of the load on the vehicle?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D329=\"Yes\",1,0))","v":0}]
["3.16.18","Is there a back-up method should the usual method fail?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D330=\"Yes\",1,0))","v":0}]
["3.16.19","Is the measuring method calibrated regularly?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D331=\"Yes\",1,0))","v":0}]
["3.16.20","Are vehicle loads properly secured?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D332=\"Yes\",1,0))","v":0}]
[null,"Is the sugarcane tightly stacked?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D333=\"Yes\",1,0))","v":0}]
["3.16.21","Are stacks of uniform size?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D334=\"Yes\",1,0))","v":0}]
["3.16.22","Is all loose cane removed prior to transport?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D335=\"Yes\",1,0))","v":0}]
["3.16.23","Are you complying with your allocation and any agreed schedules?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D336=\"Yes\",1,0))","v":0}]
["3.16.24","Driver Wellness"]
["3.16.25","Are drivers’ schedules arranged such that driving hours are not only within the legal limits but are scheduled to minimise driver fatigue?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D338=\"Yes\",1,0))","v":0}]
["3.16.26","Are depot facilities and workplace conditions conducive to driver health and well-being?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D339=\"Yes\",1,0))","v":0}]
["3.16.27","Do drivers undergo regular medical examinations to ensure that they are fit and competent to perform their duties?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D340=\"Yes\",1,0))","v":0}]
["3.16.28","Is there regular and open communication between management and drivers on matters that affect the safe operation of the business?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D341=\"Yes\",1,0))","v":0}]
["3.16.29","Driver Training"]
["3.16.30","Are drivers of haulage vehicles properly trained?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D343=\"Yes\",1,0))","v":0}]
[null,"Is a schedule of training needs compiled and matched to a training plan?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D344=\"Yes\",1,0))","v":0}]
["3.16.31","Are competency assessments conducted for all drivers?",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D345=\"Yes\",1,0))","v":0}]
["3.16.32","Record Keeping"]
["3.16.33","Are detailed records kept of the following documents pertaining to the loading and haulage operation?"]
["3.16.34","• Trip-mass records",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D348=\"Yes\",1,0))","v":0}]
[null,"• Accident and incident reports",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D349=\"Yes\",1,0))","v":0}]
["3.16.35","• Vehicle fault reports",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D350=\"Yes\",1,0))","v":0}]
["3.16.36","• Vehicle service and maintenance records",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D351=\"Yes\",1,0))","v":0}]
["3.16.37","• Record of driving hours",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D352=\"Yes\",1,0))","v":0}]
[null,"• All staff medical records",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D353=\"Yes\",1,0))","v":0}]
["3.16.38","• All training conducted",null,null,{"$f":"IF(D322=\"Yes\",\"N/A\",IF(D354=\"Yes\",1,0))","v":0}]
[null,null,{"$f":"IF(D304=\"Yes\",1,IFERROR(AVERAGE(E308,E323:E326),\"N/A\"))","v":0},{"$f":"IF(D304=\"Yes\",100%,IFERROR(AVERAGE(E310:E320,E328:E354),\"N/A\"))","v":0}]
[]
[null,"3.14 AGROCHEMICALS\nSTATEMENT OF INTENT : Acquisition and use of agricultural remedies and fertilisers are controlled."]
[null,null,"LEGAL","BMP"]
[null,"Fertilizers, Farm Feeds, Seeds and Remedies Act, 36 of 1947",null,"NOTES…"]
["3.14.1","Have you acquired or used any agricultural remedies that contain any of the following ingredients:\n- 2,4-D (dimethylamine salt)\n- 2,4-DB (sodium salt)\n- dicamba (dimethylamine salt)\n- any other salts or esters of 2,4-D (except APM salt) on farms in certain Magisterial Districts.\n- Monocrotophos\n- Chlordane\n- Lindane (gamma – BHC)?",null,null,{"$f":"IF(C360=\"Yes\",0,1)","v":1}]
["3.14.2","If in KwaZulu-Natal, have you aerially applied any of the agricultural remedies listed above, or any agricultural remedy containing 2,4-D (iso-actylesther), NCPA (potassium salt), MCPB (sodium salt), any salt or esters of triclopyr or salts of dicamba?",null,null,{"$f":"IF(C361=\"Yes\",0,IF(C361=\"No\",1,\"N/A\"))","v":"N/A"}]
["3.14.3","Have you acquired, sold, disposed of or used any agricultural remedy containing the pesticide chlorobensilate?",null,null,{"$f":"IF(C362=\"Yes\",0,IF(C362=\"No\",1,\"N/A\"))","v":"N/A"}]
["3.14.4","Have you acquired, sold, disposed of or used  “Super phosphate + Cu”?",null,null,{"$f":"IF(C363=\"Yes\",0,IF(C363=\"No\",1,\"N/A\"))","v":"N/A"}]
[null,"Storage of fertilisers and agrochemicals",null,"NOTES…"]
[null,"Do you keep any agrochemicals on the farm (for any length of time)?"]
["3.14.5","Are agrochemicals stored in secure buildings which comply with the relevant standards?",null,null,{"$f":"IF(C365=\"No\", \"N/A\",IF(C366=\"Yes\",1,0))","v":0}]
["3.14.6","Are Toxic Group I poisons secured in a separate, locked storage area?",{"$f":"PEOPLE!C34","v":0},null,{"$f":"IF(C365=\"No\", \"N/A\",IF(C367=\"Yes\",1,0))","v":0}]
["3.14.7","Are agrochemicals stored away from food and animal feed?",null,null,{"$f":"IF(C365=\"No\", \"N/A\",IF(C368=\"Yes\",1,0))","v":0}]
["3.14.8","Are all safety requirements available (e.g. water and washing facilities, fire-fighting equipment, other requirements specified on label)?",null,null,{"$f":"IF(C365=\"No\", \"N/A\",IF(C369=\"Yes\",1,0))","v":0}]
["3.14.9","Are Safety Data Sheets (SDS) available at point of use?",{"$f":"PEOPLE!C37","v":0},null,{"$f":"IF(C365=\"No\", \"N/A\",IF(C370=\"Yes\",1,0))","v":0}]
["3.14.10","Are employees made aware of and/or trained on the use and understanding of the SDS and its contents?",{"$f":"IF(PROFILE!C22=0,\"N/A\",PEOPLE!C38)","v":"N/A"},null,{"$f":"IF(OR(PROFILE!C22=0,C365=\"No\"), \"N/A\",IF(C371=\"Yes\",1,0))","v":"N/A"}]
["3.14.11","Is the storage area easily drained with a sealed sump to collect spillage?",null,null,{"$f":"IF(C365=\"No\", \"N/A\",IF(C372=\"Yes\",1,0))","v":0}]
["3.14.12","Is a daily inventory and record of products used, and returned to the store, controlled by a designated member of the farm staff?",{"$f":"PEOPLE!C40","v":0},null,{"$f":"IF(C365=\"No\", \"N/A\",IF(C373=\"Yes\",1,0))","v":0}]
[null,"Application of agrochemicals",null,"NOTES…"]
["3.14.13","Is mixing of agrochemicals carried out in a well ventilated area with the necessary protective clothing being worn?",null,null,{"$f":"IF(C375=\"Yes\",1,IF(C375=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.14.14","Is washing of equipment done in a manner which avoids soil and water pollution?",null,null,{"$f":"IF(C376=\"Yes\",1,IF(C376=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.14.16","Are soil samples taken at regular intervals to ensure correct type and quantity of fertiliser?",null,null,{"$f":"VLOOKUP(D377,OPTSCORE3,2,FALSE)","v":{"$error":"#N/A"}}]
["3.14.15","Is fertiliser application managed in terms of soil  requirements, as determined by SASRI FAS or equivalent laboratory?",null,null,{"$f":"VLOOKUP(D378,OPTSCORE3,2,FALSE)","v":{"$error":"#N/A"}}]
["3.14.17","Are agrochemicals applied at the correct rate, to the specific target, at the correct growth stage and under suitable weather conditions?",null,null,{"$f":"VLOOKUP(D379,OPTSCORE3,2,FALSE)","v":{"$error":"#N/A"}}]
["3.14.18","Do you record and calculate the combined mass of agrochemicals applied for all sugarcane operations?",null,{"$f":"IF(PROFILE!C50=\"Known\",\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(D380=\"Yes\",1,0)","v":1}]
[null,"Is the combined mass of agrochemicals applied, less than 5kg active ingredient per hectare of area under cane?",null,{"$f":"IF(CALCULATORS!B78<5,\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}},{"$f":"CALCULATORS!B79","v":{"$error":"#DIV/0!"}}]
[null,"Operators and equipment",null,"NOTES…"]
["3.14.19","Is all application equipment serviced and calibrated regularly?",null,null,{"$f":"IF(C383=\"Yes\",1,IF(C383=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.14.20","Are all operators using agrochemicals trained and provided with the necessary safety equipment?",{"$f":"PEOPLE!C21","v":0},null,{"$f":"VLOOKUP(C384,OPTSCORE3,2,FALSE)","v":{"$error":"#N/A"}}]
["3.14.21","Are all agrochemicals applied according to the manufacturer’s specifications?",null,null,{"$f":"IF(C385=\"Yes\",1,IF(C385=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,"Disposal of containers and unused chemicals ",null,"NOTES…"]
["3.14.22","Are empty containers returned to the supplier where the label requires that they be returned?",{"$f":"C81","v":0},null,{"$f":"IF(C387=\"Yes\",1,IF(C387=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.14.23","Are empty containers that are not required to be returned to the supplier rendered unusable? ",null,null,{"$f":"IF(C388=\"Yes\",1,IF(C388=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.14.24","If any flammable material from containers has been burnt, has this been done at a licensed facility?",null,null,{"$f":"IF(C389=\"Yes\",1,IF(C389=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,null,{"$f":"AVERAGE(E360:E376,E383:E389)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(E377:E381)","v":{"$error":"#N/A"}}]
[]
[null,"3.15 PESTS AND DISEASES\nSTATEMENT OF INTENT : Plant diseases and insect pests are prevented and controlled."]
[null,null,"LEGAL","BMP"]
[null,"Farmers comply with the Agricultural Pests Act 36 of 1993.",null,"NOTES…"]
["3.13.1","Have you notified the local department of agriculture of the presence of any flying locusts or  breeding swarms of red-billed queleas?",null,null,{"$f":"IF(C395=\"Yes\",1,IF(C395=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.13.2","Have you complied with any control measures as instructed by the Minister of Agriculture?",null,null,{"$f":"IF(C396=\"Yes\",1,IF(C396=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,"Farmers comply with the Sugar Act 9 of 1978.",null,"NOTES…"]
["3.13.3","If you are within a proclaimed area, have you complied with any remedial operations required by the SA Sugar Association?",null,null,{"$f":"IF(C398=\"Yes\",1,IF(C398=\"No\",0,\"N/A\"))","v":"N/A"}]
[null,"Farmers have implemented an Integrated Pest Management System",null,"NOTES…"]
["3.13.4","Have you notified your Local PD&V Control Committee regarding the outbreak of any major pests and diseases on your farm or in the area?",null,null,{"$f":"IF(D400=\"Yes\",1,IF(D400=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.13.5","Do you keep up to date with the latest rules and recommendations from the Local Pest, Disease and Variety Control Committee?",null,null,{"$f":"IF(D401=\"Yes\",1,0)","v":0}]
["3.13.7","Do you use either certified or approved seedcane for all crop re-establishment?",null,null,{"$f":"IF(C402=\"Yes\",1,0)","v":0}]
["3.13.8","Are fields due for re-plant checked for RSD prior to eradication of the penultimate crop?",null,null,{"$f":"IF(D403=\"Yes\",1,IF(D403=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.13.9","Is 100% crop eradication achieved before planting?",null,null,{"$f":"VLOOKUP(D404,OPTSCORE1,2,FALSE)","v":{"$error":"#N/A"}}]
["3.13.10","Are RSD positive fields fallowed for a minimum of 3 months from the death of the last volunteer?",null,null,{"$f":"IF(D405=\"Yes\",1,IF(D405=\"No\",0,\"N/A\"))","v":"N/A"}]
["3.13.11","Do you choose pest and disease resistant varieties suitable to your specific growing conditions?",null,null,{"$f":"IF(D406=\"Yes\",1,0)","v":0}]
[null,"Do you ensure that no single variety occupies greater than 30% of your areas under cane?",null,null,0]
["3.13.12","Do you undertake any scouting with your own staff for pests and diseases on your farm?",null,null,0]
["3.13.13","Do you undertake regular training on pests and diseases with your scouting staff?",null,null,0]
["3.13.14","Are you recording and monitoring trends on the incidence of pests and diseases on a field basis for your farm?",null,null,0]
["3.13.15","Are you implementing an integrated approach towards the control of any threatening pests on your farm? (i.e. planting sedges or melinis, releasing predators, encouraging bats, variety choice etc)",null,null,0]
[null,null,{"$f":"IFERROR(AVERAGE(E395:E398,E402),\"N/A\")","v":0},{"$f":"AVERAGE(E400:E401,E403:E411)","v":{"$error":"#N/A"}}]
[]
[null,"PLANET",{"$f":"IFERROR(AVERAGE(C24,C38,C49,C83,C95,C105,C116,C141,C188,C227,C265,C299,C355,C390,C412),\"N/A\")","v":"N/A"},{"$f":"IFERROR(AVERAGE(D24,D38,D49,D83,D95,D105,D116,D141,D188,D227,D265,D299,D355,D390,D412),\"N/A\")","v":"N/A"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"VERSION 4.1 2024"]

{"sheet":"SAI QUESTIONS","index":5,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2]]}
[]
[null,"SAI QUESTIONS"]
[null,"STATEMENT OF INTENT\nSUSFARMS is aligned with the SAI Platform (a globally used, certified system). In order to maintain the highest integrity of this alignment, the following questions should be addressed in your annual SUSFARMS Self-Assesment. \n\n*Please note that these questions will not be factored into your SUSFARMS score for 2024. "]
[null,"FARM MANAGEMENT AND COMMUNITY",null,"NOTES"]
[null,"• Do you take any measures to prevent bribery, corruption and fraud, in accordance with relevant legislation?",null,"This could include a Cane Supply Agreement which specifies business ethics, audited financials or evidence of tax compliance. "]
[null,"• Do you have a documented system to manage the traceability of your product? (i.e. a record of all consignments from field to mill?",null,"This could include a delivery note from the field, weighbridge receipt notes, consignment notes,or reconciliation with Cane Testing Services."]
[null,"• Do you have contracts in place for the purchase of your product which take into consideration (a) specification, (b) price, (c) volume, and (d) payment terms and conditions?",null,"This could include a Cane Supply Agreement."]
[null,"PLANT MATERIAL SELECTION AND PROPAGATION : Genetically Modified Organisms (GMOs)"]
[null,"• Do you handle, produce or process GMOs on your land?"]
[null,"• If yes, can you demonstrate compliance with the handling, production and processing of approved genetically modified organisms (GMOs) on your land, in accordance with relevant legislation, seed company guidelines and client requirements?",null,"For example, the use of GM maize is subject to compliance with technology stewardship requirements as provided for in the Plant Improvement Act (Act 53 of 1976), the Plant Breeders Rights Act (Act 15 of 1976), the South African Patents Act (Act 57 of 1978) the South African Trade Marks Act (Act 194 of 1993), the Genetically Modified Organisms (GMO) Act (Act 15 of 1997) and the GMO Amendment Act (Act 26 of 2006)"]
[null,"• Do you take appropriate measures to prevent the risk of cross-contamination with conventional (non-GMO) material also grown on your land or in the wider community, in accordance with relevant legislation and seed company guidelines?"]
[null,"AIR QUALITY AND EMISSIONS"]
[null,"• Have you identified and sourced any clean and sustainable sources of renewable energy for your farming operations (such as solar, biogas etc.)?"]
[null,"• Do you measure and monitor all of your sources of greenhouse (GHG) emissions?"]
[null,"LABOUR CONDITIONS "]
[null,"• Do you directly or indirectly employ any permanent, temporary, seasonal or voluntary workers, including family members?      "]
[null,"• Do you provide information and/or support to workers of the availability of health care facilities?"]
[null,"• Have you established and implemented a grievance mechanism that allows permanent, temporary and seasonal workers the right to report complaints, in the knowledge that a) grievances will be investigated and b) any upheld findings will be actioned?",null,"This could include a complaints form or dropbox, guidelines on how the complaint is investigated and actioned and how feedback is provided. "]
[null,"OCCUPATIONAL HEALTH & SAFETY (OHS)"]
[null,"• Where applicable, do you provide medical screening for all permanent, temporary and seasonal workers that have a higher risk of disease or health-related issues due to environmental factors or the nature of their work?",null,"This could include blood tests for chemical handlers and storage personnel prior and post employment or medical screenings."]
[null,"General Occupational Health and Safety (OHS)"]
[null,"• Are emergency contact details available and easily accessible at the farm to meet all reasonably foreseeable emergency medical situations?",null,"This could include posters on notice boards and details of first aiders "]
[null,"• Where applicable, do you ensure that all permanent, temporary and seasonal workers who may be vulnerable or whose immune systems may be compromised do not handle plant protection products (PPPs) or hazardous substances?"]
[null,"• Where accommodation is provided, is there access to appropriate cooking facilities?"]

{"sheet":"REPORT","index":6,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,1,1,3],[5,1,5,3],[14,1,14,3],[11,2,11,3],[3,2,3,3],[2,2,2,3],[4,2,4,3]]}
[]
[null,"SUSFARMS PROGRESS TRACKER\nREPORT"]
[null,{"$f":"PROFILE!C4","v":0},{"$f":"PROFILE!C5","v":0}]
[null,{"$f":"PROFILE!C6","v":0}]
[null,{"$f":"PROFILE!C10","v":"1 March 2023 - 29 February 2024"}]
[null,"SCORE SUMMARY"]
[null,null,"LEGAL","BMP"]
[null,"PROSPERITY",{"$f":"C21","v":0},{"$f":"D21","v":"N/A"}]
[null,"PEOPLE",{"$f":"C30","v":0},{"$f":"D30","v":0}]
[null,"PLANET",{"$f":"C47","v":"N/A"},{"$f":"D47","v":"N/A"}]
[null,"TOTAL",{"$f":"IFERROR(AVERAGE(C8:C10),\"N/A\")","v":0},{"$f":"IFERROR(AVERAGE(D8:D10),\"N/A\")","v":0}]
[null,"TOTAL AVERAGE (LEGAL AND BMP)",{"$f":"AVERAGE(C11:D11)","v":0}]
[]
[]
[null,"SCORE DETAILS"]
[null,"PROSPERITY","LEGAL","BMP"]
[null,"1.1 Land Use Plan",{"$f":"PROSPERITY!C30","v":0},{"$f":"PROSPERITY!D30","v":0}]
[null,"1.2 Annual Production Plan",{"$f":"PROSPERITY!C63","v":"N/A"},{"$f":"PROSPERITY!D63","v":{"$error":"#DIV/0!"}}]
[null,"1.3 Annual Financial Plan",{"$f":"PROSPERITY!C79","v":"N/A"},{"$f":"PROSPERITY!D79","v":0}]
[null,"1.4 Financial Compliance",{"$f":"PROSPERITY!C100","v":0},{"$f":"PROSPERITY!D100","v":"N/A"}]
[null,null,{"$f":"IFERROR(AVERAGE(C17:C20),\"N/A\")","v":0},{"$f":"IFERROR(AVERAGE(D17:D20),\"N/A\")","v":"N/A"}]
[null,"PEOPLE","LEGAL","BMP"]
[null,"2.1 Health and Safety",{"$f":"PEOPLE!C61","v":0},{"$f":"PEOPLE!D61","v":"N/A"}]
[null,"2.2 Labour",{"$f":"PEOPLE!C101","v":"N/A"},{"$f":"PEOPLE!D101","v":"N/A"}]
[null,"2.3 Land Tenure",{"$f":"PEOPLE!C110","v":0},{"$f":"PEOPLE!D110","v":"N/A"}]
[null,"2.4 Community Development & Stakeholder Engagement",{"$f":"PEOPLE!C120","v":"N/A"},{"$f":"PEOPLE!D120","v":0}]
[null,"2.5 Skills Development",{"$f":"PEOPLE!C129","v":"N/A"},{"$f":"PEOPLE!D129","v":"N/A"}]
[null,"2.6 Public Recreation",{"$f":"PEOPLE!C141","v":"N/A"},{"$f":"PEOPLE!D141","v":0}]
[null,"2.7 Heritage",{"$f":"PEOPLE!C148","v":""},{"$f":"PEOPLE!D148","v":"N/A"}]
[null,null,{"$f":"IFERROR(AVERAGE(C23:C29),\"N/A\")","v":0},{"$f":"IFERROR(AVERAGE(D23:D29),\"N/A\")","v":0}]
[null,"PLANET","LEGAL","BMP"]
[null,"3.1 Threatened, Critical and Protected Species and Ecosystems",{"$f":"PLANET!C24","v":0},{"$f":"PLANET!D24","v":0.15}]
[null,"3.2 Alien and Invasive Species",{"$f":"PLANET!C38","v":0},{"$f":"PLANET!D38","v":0}]
[null,"3.3 Fire",{"$f":"PLANET!C49","v":0},{"$f":"PLANET!D49","v":"N/A"}]
[null,"3.4 Pollution Control",{"$f":"PLANET!C83","v":0},{"$f":"PLANET!D83","v":6.6666666666666666E-2}]
[null,"3.5 Transformation of the Natural Environment",{"$f":"PLANET!C95","v":"N/A"},{"$f":"PLANET!D95","v":"N/A"}]
[null,"3.6 Quarries",{"$f":"PLANET!C105","v":0},{"$f":"PLANET!D105","v":0}]
[null,"3.7 Water Use",{"$f":"PLANET!C116","v":0},{"$f":"PLANET!D116","v":"N/A"}]
[null,"3.8 Wetlands and Watercourses",{"$f":"PLANET!C141","v":0.6},{"$f":"PLANET!D141","v":0.5}]
[null,"3.9 Irrigation and Drainage",{"$f":"PLANET!C188","v":"N/A"},{"$f":"PLANET!D188","v":{"$error":"#N/A"}}]
[null,"3.10 Soil Conservation: Layout",{"$f":"PLANET!C227","v":{"$error":"#N/A"}},{"$f":"PLANET!D227","v":{"$error":"#N/A"}}]
[null,"3.11 Soil Conservation: Extraction",{"$f":"PLANET!C265","v":"N/A"},{"$f":"PLANET!D265","v":"N/A"}]
[null,"3.12 Soil Conservation: Management",{"$f":"PLANET!C299","v":"N/A"},{"$f":"PLANET!D299","v":{"$error":"#N/A"}}]
[null,"3.13 Haulage",{"$f":"PLANET!C355","v":0},{"$f":"PLANET!D355","v":0}]
[null,"3.14 Agrochemicals",{"$f":"PLANET!C390","v":{"$error":"#N/A"}},{"$f":"PLANET!D390","v":{"$error":"#N/A"}}]
[null,"3.15 Pests and Diseases",{"$f":"PLANET!C412","v":0},{"$f":"PLANET!D412","v":{"$error":"#N/A"}}]
[null,null,{"$f":"IFERROR(AVERAGE(C32:C46),\"N/A\")","v":"N/A"},{"$f":"IFERROR(AVERAGE(D32:D46),\"N/A\")","v":"N/A"}]

{"sheet":"CALCULATORS","index":7,"n_rows":588,"n_cols":7,"rows_kept":588,"cut":false,"hidden":true,"merged":[[0,5,0,6]]}
["WATER USE YIELD EFFICIENCY",null,null,null,"uses the 9tc/100 mm of water rule","OPTION SCORES"]
[null,null,null,null,null,"Never (0%)",0]
["RAINFALL RECEIVED",{"$f":"IF(PROFILE!C40 = \"Unknown\", \"Unknown\",PROFILE!D40 )","v":"Unknown"},"mm/ha",null,null,"Seldom (1-25%)",0.25]
["RAINFED AREA HARVESTED",{"$f":"PROFILE!C33","v":0},"ha",null,null,"Sometimes (25-50%)",0.5]
["RAINFED POTENTIAL",{"$f":"(B3/100)*9*B4","v":{"$error":"#VALUE!"}},"t",null,null,"Mostly (51-75%)",0.75]
[null,null,null,null,null,"Almost always (76 - 99%)",0.9]
["IRRIGATION WATER APPLIED",{"$f":"IF(PROFILE!C41=\"Unknown\",\"Unknown\",IF(PROFILE!D41=\"N/A\",0,PROFILE!D41))","v":"Unknown"},"KL",null,"amended formula for N/A option","Always (100%)",1]
["TOTAL IRRIGATED AND SUPPLEMENTARY AREA",{"$f":"PROFILE!C15+PROFILE!C16","v":0},"ha"]
["APPROX IRRIGATION PER HECTARE",{"$f":"IFERROR(IF(B8=0,0,(B7/B8)/10),\"Unknown\")","v":0},"mm/ha",null,"iferror trap added","None (0%)",0]
["IRRIGATED POTENTIAL",{"$f":"IFERROR(IF(B8=0,0,(B3+B9)/100*9*B8),\"Unknown\")","v":0},"t",null,"iferror trap added","Some (1-33%)",0.33]
[null,null,null,null,null,"Mostly (34-66%)",0.66]
["AVERAGE POTENTIAL YIELD",{"$f":"((B5+B10)/(B4+B8))","v":{"$error":"#VALUE!"}},"t/ha",null,null,"Almost Always (67-99%)",0.99]
["ACTUAL YIELD",{"$f":"PROFILE!D37/PROFILE!C37","v":{"$error":"#DIV/0!"}},"t/ha",null,null,"Always (100%)",1]
[]
["WATER USE YIELD EFFICIENCY",{"$f":"IF(OR(B3=\"Unknown\",B7=\"Unknown\"),\"Unknown\",IF(B13>=B12,1,B13/B12))","v":"Unknown"},null,null,null,"N/A","N/A"]
[null,null,null,null,null,"None (0%)",0]
[null,null,null,null,null,"Some (0-33%)",0.33]
["IRRIGATION AREA ONLY",null,null,null,null,"Most (34-66%)",0.66]
["ACTUAL IRRIGATED YIELD",{"$f":"PROFILE!D31+PROFILE!D32","v":0},null,null,null,"Almost All (67-99%)",0.99]
["IRRIGATED AREA HARVESTED",{"$f":"PROFILE!C31+PROFILE!C32","v":0},null,null,null,"All (100%)",1]
["YIELD PER HA",{"$f":"IF(B20=0,0,B19/B20)","v":0},"t/ha",null,"updated"]
["LESS: RAIFALL YIELD IN IRRIGATED AREA",{"$f":"IF(B20=0,0,B3/100*9)","v":0},"t/ha",null,"updated"]
["GAINS FROM IRRIGATION",{"$f":"B21-B22","v":0},"t/ha"]
["POTENTIAL YIELD FROM IRRIGATION ONLY",{"$f":"B9/100*9","v":0},"t/ha"]
[]
["IRRIGATED WATER USE EFFICIENCY",{"$f":"IFERROR(  IF(B20=0,\"N/A\",IF(B23>=B24,1,IF(B23/B24<0,0,B23/B24))),\"Unknown\")","v":"N/A"},null,null,"iferror trap added"]
[]
[]
[]
[]
["PRIMARY ENERGY USE"]
[]
["DIRECT ENERGY"]
["DIESEL FOR SUGARCANE FARM OPERATIONS",{"$f":"IF(PROFILE!C42=\"Unknown\", \"Unknown\",PROFILE!D42)","v":"Unknown"},"L"]
["CONVERSION FACTOR",37]
[null,{"$f":"B34*B35","v":{"$error":"#VALUE!"}},"MJ"]
["ELECTRICITY FOR SUGARCANE OPERATIONS ",{"$f":"IF(PROFILE!C44=\"Unknown\", \"Unknown\",PROFILE!D44)","v":"Unknown"},"kWh"]
["CONVERSION FACTOR",3.6]
[null,{"$f":"B37*B38","v":{"$error":"#VALUE!"}}]
["TOTAL DIESEL AND ELECTRICITY",{"$f":"B36+B39","v":{"$error":"#VALUE!"}},"MJ"]
["TONS CANE HARVESTED",{"$f":"PROFILE!D37","v":0},"t"]
["TOTAL DIRECT ENERGY",{"$f":"IF(OR(B34=\"Unknown\",B37=\"Unknown\"),\"Unknown\",B40/B41)","v":"Unknown"},"MJ/t"]
[]
[]
["INDIRECT ENERGY USE"]
[null,"AMOUNT","CONVERSION FACTOR"]
["NITROGEN",{"$f":"IF(PROFILE!C45=\"Unknown\",\"Unknown\",PROFILE!D45*1000)","v":"Unknown"},56.9,{"$f":"B47*C47","v":{"$error":"#VALUE!"}}]
["PHOSPHORUS",{"$f":"IF(PROFILE!C46=\"Unknown\",\"Unknown\",PROFILE!D46*1000)","v":"Unknown"},9.3000000000000007,{"$f":"B48*C48","v":{"$error":"#VALUE!"}}]
["POTASSIUM",{"$f":"IF(PROFILE!C47=\"Unknown\",\"Unknown\",PROFILE!D47*1000)","v":"Unknown"},7,{"$f":"B49*C49","v":{"$error":"#VALUE!"}}]
["LIME / GYPSUM",{"$f":"IF(PROFILE!C48=\"Unknown\",\"Unknown\",PROFILE!D48*1000)","v":"Unknown"},0.12,{"$f":"B50*C50","v":{"$error":"#VALUE!"}}]
["AGROCHEMICALS",{"$f":"IF(PROFILE!C50=\"Unknown\",\"Unknown\",PROFILE!C84)","v":0},357,{"$f":"B51*C51","v":0}]
[]
["TOTAL",{"$f":"IF(COUNTIF(B47:B51,\"Unknown\")>0,\"Unknown\",SUM(B47:B51))","v":"Unknown"},null,{"$f":"SUM(D47:D51)","v":{"$error":"#VALUE!"}},"MJ"]
["TONS CANE HARVESTED",{"$f":"PROFILE!D37","v":0},null,{"$f":"PROFILE!D37","v":0}]
["TOTAL INDIRECT ENERGY USED",{"$f":"IF(B53=\"Unknown\",\"Unknown\",D53/D54)","v":"Unknown"},"MJ/t"]
[]
[]
["ENERGY USED FOR TRANSPORTING CHEMICALS"]
["TOTAL CHEMICAL APPLIED",{"$f":"B53","v":"Unknown"}]
["CONVERSION FACTOR",0.64,null,{"$f":"CALCULATORS!B1","v":0}]
["AVERAGE YIELD PER HECTARE",{"$f":"B54/PROFILE!C37","v":{"$error":"#DIV/0!"}}]
["ENERGY USED FOR TRANSPORT",{"$f":"IF(B59=\"Unknown\",\"Unknown\",(B59*B60)/B61)","v":"Unknown"},"MJ/t"]
[]
["TOTAL PRIMARY ENERGY",{"$f":"IF(OR(B42=\"Unknown\",B55=\"Unknown\",B62=\"Unknown\"),\"Unknown\",B42+B55+B62)","v":"Unknown"},"MJ/t",{"$f":"TEXT(B64,\"#######\")","v":"Unknown"},"(formatted as two decimal places for proper display in production report)"]
[null,{"$f":"IF(B64<=300,1,IF(B64<600,(100-B64/6)*0.02,0))","v":0}]
[]
["ENERGY USED IN CANE TRANSPORT"]
[]
["DIESEL CONSUMED IN TRANSPORTING CANE TO MILL",{"$f":"IF(PROFILE!C43=\"Unknown\",\"Unknown\",PROFILE!D43)","v":"Unknown"},"L"]
["CONVERSION FACTOR",37]
["ANNUAL TONS CANE HARVESTED",{"$f":"PROFILE!D37","v":0}]
[null,{"$f":"IF(B69=\"Unknown\",\"Unknown\",(B69*B70)/B71)","v":"Unknown"},"MJ/t",{"$f":"TEXT(B72,\"###.#\")","v":"Unknown"},"(formatted as two decimal places for proper display in production report)"]
[null,{"$f":"IF(B72<=50,1,IF(B72<100,(100-B72)*0.02,0))","v":0}]
[]
["MASS of ai /ha"]
["Total mass of ai",{"$f":"IF(PROFILE!C50=\"Unknown\",\"Unknown\",PROFILE!E84)","v":0},"g/L"]
["Total area under cane ",{"$f":"PROFILE!C18","v":0},"ha"]
[null,{"$f":"IF(B76=\"Unknown\",\"Unknown\",B76/B77/1000)","v":{"$error":"#DIV/0!"}},"kg/ha",{"$f":"TEXT(B78,\"####.##\")","v":{"$error":"#DIV/0!"}},"(formatted as two decimal places for proper display in production report)"]
["Efficiency% compared against 5kg/ha",{"$f":"IF(B78<5,1,IF(B78<10,(10-B78)*0.2,0))","v":{"$error":"#DIV/0!"}},"% (x 100)"]
[]
["LIST OF AGROCHEMICALS 2019"]
["2,4-D 480 ",480]
["2,4-D Amine ",480]
["2,4-D Amine 480 SL",480]
["2,4-D Amine Soluble",800]
["2,4-D Ester 500 EC",500]
["2.4-D Iso-Octyl Ester",500]
["Abacus Advance",125]
["Acetak EC",900]
["Acetamet 700 SC",700]
["Aceto 900",900]
["Acetochlor 700 EC ",700]
["Acetochlor 700 S",700]
["Acetochlor 750 ",750]
["Acetochlor 900 EC ",900]
["Acetochlor S 700",700]
["Acetogan 900 EC",900]
["Acetogan Plus 768 EC",768]
["Actara SC",240]
["Adama 2,4 D-Amine ",480]
["Addition 150 SC",150]
["Advance 150 SC",150]
["Ag- Metribuzin 480 SC",480]
["Ag-Diuron 800 SC",800]
["Agfuran 10 G",100]
["Agfuran 10 GR",100]
["Agriquat 200 SL",200]
["Agrizine 500 SC",500]
["Agromate",720]
["Agroquat ",200]
["Alachlor",384]
["Alachlor 384 EC",384]
["Alanex 384 EC",384]
["Alanex 480 CS",480]
["Alion Total",600]
["Allice 20 SP",200]
["Alligator 500 EC",500]
["Alvuran 100 G",100]
["Amazing 480 SC",480]
["Amazon 480 SC",480]
["Ametrex 500 SC",500]
["Ametryn 500 SC  ",500]
["Ametryn 750 WDG",750]
["Amistar Xtra",280]
["Ampligo ",150]
["Anaconda 500 SC",500]
["Apache 350 SC",350]
["Apax 500 SC",500]
["Armadillo ",425]
["Arsenal GEN 2",240]
["Arysta Acetochlor",900]
["Arysta Alachlor",384]
["Arysta Ametryn",500]
["Arysta Atrazine 500",500]
["Arysta Diuron",800]
["Arysta Hexazinone",240]
["Arysta Metribuzin 480",480]
["Arysta MSMA",720]
["Arysta Paraquat",200]
["Assault 700 SC",700]
["Astron 480 SC",480]
["Atraflo 500 SC",500]
["Atranex 500 SC",500]
["Atranex 90 WG",900]
["Atrasien 500 SC",500]
["Atrazine 500 SC",500]
["Atrazine 900 WG",900]
["Atrazine SC",500]
["Authority 480 SC",480]
["AVI- Amine 720",720]
["Avi- D- Weed SL",400]
["Avi-Merkaptothion DP",250]
["Avon 750 WDG",750]
["Badger 700 EC",700]
["Bandit 350 SC",350]
["Bandito GR",125]
["Baseline 960",960]
["Basta",200]
["Bastion SC",500]
["Bazooka",800]
["Benevia 100 OD",100]
["Benomyl 500WP (Universal crop protection)",500]
["Bishop",500]
["Blative 200 SL",200]
["Blockade G",100]
["Bound ",200]
["Bound 200 SL",200]
["Bounty 450 SL",450]
["Bowler 960 EC",960]
["Brass",200]
["Brass 200 SL",200]
["Brigadier 750 WG",750]
["Bromotril T",483]
["Buccaneer 960 EC",960]
["Buffalo",951]
["Buzzin 480 SC",480]
["Caballo ",425]
["Calculus 125 SE",125]
["Callisto",480]
["Cantron 480 SC",480]
["Carbodan 10 GR",100]
["Carbofuran 10 G",100]
["Carbofuran 10 GR",100]
["Carbofuran 100 GR",100]
["Carboterr 100 GR",100]
["Castle Ametryn",500]
["Castle Atrazine 500",500]
["Castle Paraquat 200",200]
["Chesa 200 SL",200]
["Chrome Plus 750 WG",750]
["Claw 500 SC",500]
["Clear all",360]
["Clear pave",360]
["Clearout 360",360]
["Clearout 500 WG",500]
["Clincher 960 EC",960]
["Coller 200 SL",200]
["Commander",600]
["Coragen",200]
["Crocodile",750]
["Cropguard",900]
["Cropguard 80",800]
["Crown 750 WDG",750]
["Cyprex WG",750]
["Delphi 480 SL",480]
["Develop 800 WDG",800]
["Diablo 800 SC",800]
["Diamant 700 S",793]
["Dinamic 700 WG",700]
["Di-Plus ",620]
["Direction 700 WDG",700]
["Diron 800 WG",800]
["Discipline 700 WDG",700]
["Diurex 80 WG",800]
["Diurex 800 SC",800]
["Diuron 80 WG",800]
["Diuron 800 SC",800]
["Diuron 800 WG",800]
["DNA 2,4-D Amine 480 SL ",480]
["Dropzone 500 WP",500]
["Dynamo 800 SC",800]
["Effon 480 SL",480]
["Eland",384]
["Elegance 500 WP",500]
["Elegance Super 750 WDG",750]
["Emma",50.4]
["Enviro Glyphosate 360",360]
["Eptam Super ",720]
["EPTC Plus ",720]
["EPTC Plus 720 EC",720]
["Eradicate Plus 720 EC",720]
["Erase 360 SL",360]
["Esculentus 720 EC",720]
["Ethephon ",480]
["Ethephon 480 SL ",480]
["Evito T",477]
["Extend 800 WDG",800]
["Extreme 500 WP",500]
["Extreme plus",750]
["Falcon Gold",960]
["FarmAg 2,4-D 720 SL",720]
["FarmAg 2,4-D Amine 480",480]
["FarmAg Acetochlor 900 EC",900]
["FarmAg Acetochlor S 700",700]
["Farm-Ag Ametryn 500 SC",500]
["FarmAg Atrazine 500 SC",500]
["FarmAg Diuron 800 SC",800]
["FarmAg Diuron 800 WG",800]
["Farmag EPTC S",780]
["FarmAg Ethephon",480]
["FarmAg Glyphosate 360",360]
["FarmAg Hexazinone 480 SL",480]
["FarmAg Hexazinone 750 WG",750]
["Farmag MCPA",400]
["Farmag Metribuzin 480",480]
["Farmag MSMA 720 SL",720]
["FarmAg Paraquat 200",200]
["Farmazone 700 WG",700]
["Farmex",800]
["Farmuron",400]
["Farmuron 400 SC",400]
["Fastac",100]
["Fastac EC",100]
["Fastac SC",100]
["Flatdown",540]
["Fluent 125 EC",125]
["Fluent 150 EC",150]
["FluZade",125]
["Fluzie ",125]
["Foxamyl 10 GR",100]
["Foxamyl 310 SL",310]
["Fullstop 200 SL",200]
["Fusilade Forte",150]
["Galago S",480]
["Galaxy 320 SL",320]
["Galigan 240 EC",240]
["Gallant Super",108]
["GAP Acetochlor 900",900]
["GAP Alachlor",384]
["Garlon 480",480]
["Garlon 480 EC",480]
["Glygran 710 SG",710]
["Glynox 540 SL",540]
["Glyphogan 360 SL",360]
["Glyphogan Plus",687]
["Glyphosate WSG",500]
["Grafton 360 SL",360]
["Gramoxone ",200]
["Guillotine 750 WG",750]
["Halo 750 WDG",750]
["Halo-Fron WG",750]
["Harness Extra EC",960]
["Harpoon 200 SL",200]
["Harvest Oxamyl 100 GR",100]
["HexaziMax 240 SL",240]
["Hexazinone 240",240]
["Hexazinone 240 SL",240]
["Hexazinone 75 DF",750]
["Hexazinone 750 WDG",750]
["Hexsan 240 SL",240]
["Hexuron 2400",783]
["Hornet 480 SL",480]
["Imposter 750 WP",750]
["Inecor",200]
["Intelex",668]
["Judge",50]
["Kalach 510 SL",510]
["Kalach 700",700]
["Kalach 700 WSG",700]
["Karmex DF",800]
["Kestrel 960 EC",960]
["Kleen Up ",360]
["Knersus 200 SL",200]
["Kohinor 350 SC",350]
["Lava",500]
["Lava 800 WDG",800]
["Lava 900 WDG",900]
["Leap 840 EC",840]
["Lion ",700]
["Local 538 SC",538]
["Locate 538 SC",538]
["Lumax",538]
["Maintain 200 SP",200]
["Makhro MCPA",400]
["Makhro Paraquat",200]
["Mamba",360]
["Mamba 360 SL",360]
["Mamba DMA 480 SL",480]
["Mamba Max",480]
["Manter 750 WDG",750]
["MCPA ",400]
["MCPA 400 SL",400]
["MCPA 700 WSG",700]
["MCPA 750 Dmax",750]
["Mentor",750]
["Merlin ",750]
["Meta 960",960]
["Metagan Gold",960]
["Metaxa 700 WDG",700]
["Meto",965]
["Metolachlor 960",960]
["Metolachlor 960 EC",960]
["Metrad 760 WDG",760]
["Metribuzin 700 WDG",700]
["Metribuzin 75 WG",750]
["Metricane 700 WDG",700]
["Micra 750 WDG",750]
["Milano",480]
["Mistral 700 WG",700]
["Moddus",250]
["MSMA 720 SL",720]
["Muscle-Up",360]
["Myrmidon",500]
["Nirvana",200]
["Nufarm 2,4-D Amine 480 SL",480]
["Nufarm Diuron 900 WG Herbicide",900]
["Nufarm MCPA",400]
["Opera",183]
["Orca 125 EC",125]
["Oryx 240 EC",240]
["Oxadate",310]
["Oxatak SL",310]
["Palladium 960 EC",960]
["Palmero 750 WG",750]
["Panga 360 SL",360]
["Panga Turbo 450 SL",450]
["Pangolin",452]
["Parabat 500 EC",500]
["Parabat Extra 660 WP",660]
["Paradigm 500 EC",400]
["Paragone 200 SL",200]
["Paraquat 200 SL",200]
["Parody 200 SL",200]
["Pendimethalin 500 EC",500]
["Pendulum ",500]
["Pentium 960 EC",960]
["Piranha 360 SL",360]
["Piranha 510 SL",510]
["Piranha Dry",686]
["Platinum 960 EC",960]
["Preeglone ",250]
["Preelect 750 WDG",750]
["Premium 840 EC",840]
["Premium 900 EC",900]
["Primagram Gold",660]
["Prowl CS",455]
["Pythion 5% DP",50.4]
["Qwest SC",450]
["Ransom 240 SL",240]
["Refuge 360 CS",360]
["Reglone ",200]
["Relay Super 900 EC",900]
["Remquat 200 SL",200]
["Rescue",400]
["Restrict ",240]
["Ripen-It",480]
["Rondo 757 SG",757]
["Rosate 360 SL",360]
["Roundup",360]
["Roundup power max",540]
["Roundup Turbo",450]
["S- MOC 960",960]
["Safari",720]
["Saffier 750",750]
["Scat 360 SL",360]
["Scorcher",200]
["Sentak SC",480]
["Servian ",750]
["Sharda Acetochlor 900 EC",900]
["Sharda Ametryn 500 SC",500]
["Sharda Glyphosate 360 SL",360]
["Sharda Glyphosate 500 WG",500]
["Sharda Hexazinone 240 SL",240]
["Sharda Hexazinone 750 WG",750]
["Sharda Paraquat 200 SL",200]
["Sharmin 480 SL",480]
["Sharmin 720 SL",720]
["Sharpen 500 EC",500]
["Shuttle 425 SC",425]
["Silencer 750 WDG",750]
["Silvimax",680]
["Silvinator",510]
["Skoffel 145 SL",145]
["Skoffel 200 Super ",200]
["Slash 360 SL",360]
["Slash 710 SG",710]
["Slash Turbo 450 SL",450]
["Spectrum 538 SE",537.5]
["Springbok 360 SL",360]
["Squash 550 EC",550]
["Steward 150 EC",150]
["Style 750 WDG",750]
["Sucrazone Flo",350]
["Sulcoron",450]
["Sulcozine SC",425]
["Sultan 50 SC",500]
["Sumi-Alpha 200 EW",200]
["Suoy",500]
["Tanzanite 900 EC",900]
["Tarantula 500 SC",500]
["Teburox",500]
["Tebusan 500 SC",500]
["Tolla 840 S",840]
["Tolla 960",960]
["Tornado 400 SL",400]
["Tornado 700 WSG",700]
["Touchdown Forte Hitech",500]
["Tremor ",960]
["Triclon 480 EC",480]
["Tripac 250 EC",250]
["Trolli 900 EC",900]
["Trooper SL",620]
["Tumbleweed",324]
["Unimark ",700]
["Unimoc EC",960]
["V- Zone 750 DF",750]
["Velpar DF",750]
["Velpar K2.0",775]
["Velpar K2.4",783]
["Velpar K3.0",783]
["Venone 240 SL",240]
["Vigour 310 SL",310]
["Villa- Klor 480 CS",480]
["Villex 750 WDG",750]
["Vitex 50",50]
["Vixen ",480]
["Volley 125",125]
["Volley 125 EC",125]
["Volmuron",400]
["Voloxytril 400 EC",400]
["Voltril ",700]
["Vulture 480 EC",480]
["Vydate 100 GR",100]
["Vydate SL",310]
["Wildebees",480]
["Wildebees Ester",500]
["Wonderland 200 SP",200]
["X-Tinct SC",500]
["Zinon 750 WG",750]
[]
[]
[]
[]
["EXTENSION REGIONS"]
["Komati"]
["Lower South Coast"]
["Malelane"]
["Midlands North"]
["Midlands South"]
["North Coast"]
["Pongola"]
["South Coast"]
["Umfolozi"]
["Zululand North"]
["Zululand South"]
["WARDS PER REGION"]
["Komati"]
["Amaxala"]
["Coopersdal"]
["Komati Central"]
["Komati Projects"]
["Krokodilbrug"]
["Lower South Coast"]
["Harding"]
["Izotsha"]
["Maringo Flats"]
["Murchison"]
["Oribi"]
["Paddock"]
["Southbroom"]
["Umzumbe"]
["Malelane"]
["Baberton"]
["Hectorspruit"]
["Kaalrug/Inyoni"]
["Louw's Creek"]
["Malelane Projects"]
["Mhlati/Kaapmuiden"]
["Mzinti"]
["Nelspruit"]
["Midlands North"]
["1   Bishopstowe/Hilton"]
["2   Table Mountain/Umgeni"]
["3   Mpolweni / Wartburg"]
["4   Windy Hill / Bruyns Hill / Harburg"]
["5   Dalton / Noodsberg"]
["6   Mt Elias / Glenside"]
["7   Seven Oaks"]
["8   New Hanover / York / Albert Falls"]
["9   Greytown"]
["10  Kranskop"]
[" 11 Muden"]
["Midlands South"]
["Baynesfield"]
["Eston"]
["Gumtree"]
["Mid-Illovo North/Ismont"]
["Mid-Illovo South"]
["Ntimbankulu"]
["Powerscourt/Hillcrest"]
["Richmond"]
["Tala Valley"]
["Thornville / Umlaas Road"]
["Umkomaas"]
["North Coast"]
["Coastal"]
["Coastal Hinterland"]
["Table Mountain Sandstone"]
["Mist Belt"]
["Pongola"]
["Pongola"]
["Mkuze"]
["Mhlangasi"]
["South Coast"]
["Dumisa"]
["Glen Echo"]
["Hibberdene North"]
["Hibberdene South"]
["Highflats/Ixopo"]
["Ifafa Beach"]
["Jolivet"]
["Umzinto/South"]
["Umfolozi"]
["Dryland lower flats east"]
["Dryland lower flats south"]
["Dryland upper flats (green island)"]
["Hills"]
["Irrigated upper flats"]
["Road haulage"]
["Small-scale grower"]
["Supplementary irrigated mid flats"]
["Zululand North"]
["Empangeni Central"]
["Empangeni East"]
["Empangeni West"]
["Felixton Flats"]
["Felixton Hills"]
["Heatonville Riparian"]
["Heatonville Scheme"]
["Mpoza",null,null,null,null,2]
["Mtunzini"]
["Nkwaleni"]
["Zululand South"]
["Amatikulu"]
["Emoyeni"]
["Eshowe"]
["Entumeni"]
["Melmoth"]