{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Using the Model","Interface","Built-In Assumptions","Validation","Production Assumptions","Technical info","Feed and Biomass","Bio-Model","CAPEX ","HR","OPEX - RAS","Working Capital - RAS","IS - RAS","BS - RAS","CF - RAS","IRR - RAS","NPV & PI - RAS","DEP - RAS","Loan - RAS","Loan Int & Bal - RAS","RISK"],"not_rendered":{"charts":0,"images":20,"macros":1,"external_links":1,"defined_names":2,"comments":1,"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":"Using the Model","index":0,"n_rows":74,"n_cols":3,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"INSTRUCTIONS"]
[null,"Step 1","Please read over the information and diagrams below."]
[null,"Step 2","Navigate to the Interface tab (Tab number 2)."]
[null,"Step 3","On the Interface tab, you will presented with various options to select & complete (See examples below)."]
[null,"Step 4","Each block the requires your information/inputs must be completed  to ensure the end results are accuarate."]
[null,"Step 5","Every effort has been made to provide you with accuarte, industry specific data. The Built-in Assumptions and Production Assumptions tabs provide data that the user can ammend if necessary."]
[null,"Step 6","The remaining tabs in the excel sheet will automatically update according to the data selected and inputs used. It is not recommended these sheets are changed."]
[null,"Step 7","Consult the Generic Economic Model User Manual  for a detailed information & guidelines on the model."]
[]
[]
[null,"THE INTERFACE - PRODUCTION INFO"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"THE INTERFACE - APPLICANT INFO (TELL US ABOUT YOU)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"THE INTERFACE - QUICK FACTS (OBTAIN YOUR RESULTS)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"THE INTERFACE - QUICK FACTS (SPECIES REQUIREMENTS)"]

{"sheet":"Interface","index":1,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,5,47,8],[7,6,9,6],[29,4,29,5],[8,8,9,8],[28,4,28,5],[39,7,40,7],[34,5,35,5],[34,8,35,8],[39,5,40,5],[39,6,40,6],[34,6,35,6],[18,5,18,6],[34,7,35,7],[7,4,8,4],[42,6,42,7],[43,6,44,7],[7,5,8,5]]}
[null,"Economic Analysis Model For the R&D aquaculture projects"]
[]
[]
[]
[]
[]
[null,null,null,null,"<Please Select a Species>","<Please Select a Location>","<Please Select a System>","<Please Select a Market>","<Please select an appropriate selling price?>","<Please Select Number of Fish>"]
[null,null,null,null,{"$f":"IF(E7=Validation!H67,\"WARNING! More research on egg broadcasters is required\",\" \")","v":" "},{"$f":"IF(F7=Validation!D15,\" \",IF(F7=Validation!D17,\" \",IF(F7=Validation!D23,\" \",IF(F7=Validation!D21,\"Only recommended for areas along the coast\",\"Production is not viable in non-coastal provinces due to the cost of trucking/synthesising seawater\"))))","v":"Production is not viable in non-coastal provinces due to the cost of trucking/synthesising seawater"},{"$f":"IF(G7=Validation!F5,\"Pond production is not viable for these marine species due to the quantity of seawater required\", IF(G7=Validation!F4,\"As these are marine species, conventional aquaponics is not possible\",IF(G7=Validation!F6,\"Due to the cost of obtaining seawater, a flow-through system is not recommended\",IF(G7=Validation!F7,\"Although raceways have been used, limited data is avaliable on raceways in South Africa thus more research into this system is required. Raceways are currently not recommended for marine ornamentals\",\" \"))))","v":" "},null,"Prices typically can range from R 25 to R 28 per fish","Number of Fish (Per annum)"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J7/12","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"Fish to sell per month"]
[null,null,null,null,"Applicant's Profile"]
[]
[null,null,null,null,"OPERATIONAL","FARM","SURETY","FINANCING","PERCENTAGE DEBT"]
[null,null,null,null,"<Select Operational Status>","<Do you already have a Farm?>","<Do you already have a investor?>","<Type of financing>","<Select % to be financed through debt>"]
[null,null,null,null,null,{"$f":"IF($E$15=Validation!H10,\"If facility already exists, please change this option to YES\",\" \")","v":" "}]
[null,null,null,null,"LENGTH OF PRODUCTION","TUNNEL SYSTEM","SKILLS LEVEL"]
[null,null,null,null,"6 Months","<Tunnel System?>","<Please Select a Skills Level>"]
[null,null,null,null,null,{"$f":"IF(AND($F$7=\"KwaZulu-Natal\",$G$7=Validation!$F$3),\"RAS may work in northern extremity of KZN (near the border) without greenhouse tunnels, but even then reduces the growth period by four months  in winter when water temperatures are down to 17 degrees C\",\" \")","v":" "}]
[]
[null,null,null,null,"Quick Facts"]
[]
[null,null,null,null,"Financial Aspects"]
[]
[null,null,null,null,"INTERNAL RATE OF RETURN","PROFITABILITY INDEX/COST-BENEFIT RATIO","LOAN AMOUNT FOR WORKING CAPITAL","LOAN AMOUNT FOR INFRASTRUCTURE & FACILITY","INTEREST RATE","PAYBACK PERIOD"]
[null,null,null,null,{"$f":"IF(G7=\" Recirculation Aquaculture System (RAS)\",'IRR - RAS'!D19,0)","v":0},{"$f":"IF(G7=\" Recirculation Aquaculture System (RAS)\",'NPV & PI - RAS'!D19,\"Please select different system\")","v":"Please select different system"},{"$f":"IF(G7=\" Recirculation Aquaculture System (RAS)\",'Working Capital - RAS'!C34,\"Please select a different system\")","v":"Please select a different system"},{"$f":"IF(G7=\" Recirculation Aquaculture System (RAS)\",'CAPEX '!J31,\"Please select different system\")","v":"Please select different system"},{"$f":"IF(H15=\"DEBT\",RISK!C25,IF(H15=\"DEBT/EQUITY\",RISK!C25,0))","v":0},"<Please select a payback period>"]
[]
[null,null,null,null,"Operational Aspects"]
[null,null,null,null,"OPERATING PERMITS",null,"YEAR UNTIL PROFITABLE","YEAR UNTIL +CASHFLOW","FARM SIZE REQUIRED (ha)","# OF EMPLOYEES REQUIRED IN FIRST YEAR"]
[null,null,null,null,"15 year aquaculture right. Annual permit to undertake marine aquaculture. Annual permit to operate a marine hatchery.  ",null,{"$f":"IF(G7=\" Recirculation Aquaculture System (RAS)\",(INDEX('IS - RAS'!C4:N4,1,MATCH(0,'IS - RAS'!C45:N45,1)+1)))","v":false},{"$f":"IF(G7=\" Recirculation Aquaculture System (RAS)\",(INDEX('CF - RAS'!B2:M2,1,MATCH(0,'CF - RAS'!B33:M33,1)+1)))","v":false},{"$f":"'CAPEX '!E11","v":{"$error":"#VALUE!"}},{"$f":"IF(G7=\" Recirculation Aquaculture System (RAS)\",HR!D21,\"Please select a different system\")","v":"Please select a different system"}]
[]
[null,null,null,null,"Species Requirements"]
[]
[null,null,null,null,null,"OPTIMAL TEMPERATURE","SURVIVAL RATE ","OPTIMAL pH","SALINITY"]
[null,null,null,null,null,{"$f":"IF(E7=Validation!H66,\"23 - 26˚C\",\"23 - 24˚C\")","v":"23 - 24˚C"},{"$f":"'Production Assumptions'!$C$21","v":0.1},"Between 7 - 8.5","28 -36 ppt"]
[]
[]
[]
[null,null,null,null,null,"OXYGEN","NITRITE ","AMMONIA"]
[null,null,null,null,null,"between 5 and 8 mg/L","Less than 1mg/l NO₂-N","less than 0.5 mg/L NH₃-N"]
[]
[]
[null,null,null,null,null,null,"RECOMMENDED SPECIES"]
[null,null,null,null,null,null,{"$f":"IF(E7=Validation!H66,\"CLOWN FISH & DOTTY BACKS\",IF(E7=Validation!H67,\"YELLOW TANG & MARINE ANGELFISH\",\" \"))","v":" "}]
[]
[]
[null,null,null,null,null,"*These figures and calculations are based on assumptions, please consult with a professional Aquaculture expert for more assistance and guidance before developing an aquaculture facility. "]

{"sheet":"Built-In Assumptions","index":2,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,3,3,4],[19,3,19,4]]}
[null,"Built-In Assumptions"]
[]
[]
[null,null,null,"GENERAL ASSUMPTIONS"]
[null,null,null,"CPI",5.0999999999999997E-2]
[null,null,null,"Business Tax",0.28000000000000003]
[null,null,null,"Water (per kl) for 2016/17",0]
[null,null,null,"Electricity  (per kWh)",1.0900000000000001]
[null,null,null,"Minimum price of Security",800]
[null,null,null,"Vet services (every 3 months)",1500]
[null,null,null,"Health and safety apparel",500]
[null,null,null,"Stationary",100]
[null,null,null,"Cost of breeding fish/per fish",50]
[null,null,null,"Average selling price",{"$f":"Interface!I7","v":"<Please select an appropriate selling price?>"}]
[null,null,null,"Average feed price (per kg)",30]
[null,null,null,"Fuel costs",13.9]
[null,null,null,"Fuel consumption 2 to 5 tonne bakkie (R/Km)",20]
[null,null,null,"Land price (Dry land crop)",246346]
[]
[null,null,null,"HUMAN RESOURCE ASSUMPTIONS"]
[null,null,null,"Skills level","Salary"]
[null,null,null,"High skilled",0,null,null,"* Assumed owner will take a share of the profits."]
[null,null,null,"Low skilled",5000]

{"sheet":"Validation","index":3,"n_rows":120,"n_cols":8,"rows_kept":120,"cut":false,"hidden":true,"merged":[]}
[null,"NUMBER OF FISH",null,"Species",null,"Systems",null,"Markets"]
[null,"<Please Select Number of Fish>",null,"<Please Select a Species>",null,"<Please Select a System>",null,"<Please Select a Market>"]
[null,15000,null,"Marine Ornamental ",null," Recirculation Aquaculture System (RAS)",null,"Local Markets"]
[null,16000,null,null,null,"Aquaponics",null,"International Markets"]
[null,17000,null,null,null,"Pond culture"]
[null,18000,null,null,null,"Flow-Through "]
[null,19000,null,null,null,"Raceways",null,"Operational Status"]
[null,20000,null,null,null,"Cage",null,"<Select Operational Status>"]
[null,21000,null,null,null,null,null,"Start-Up"]
[null,22000,null,null,null,null,null,"Existing"]
[null,23000]
[null,24000,null,null,null,"Skills level"]
[null,25000,null,"Location",null,"<Please Select a Skills Level>",null,"Investor"]
[null,26000,null,"<Please Select a Location>",null,"No skills in Aquaculture",null,"<Do you already have a investor?>"]
[null,27000,null,"Eastern Cape",null,"Work experience (1-2 years)",null,"Yes"]
[null,28000,null,"Gauteng",null,"Work experience (3-5 years)",null,"No"]
[null,29000,null,"KwaZulu-Natal",null,"Work experience (over 5 years)"]
[null,30000,null,"Limpopo",null,"Formal education (certificate, diploma, degrees)"]
[null,31000,null,"Mpumalanga",null,null,null,"YEARS FOR LOAN"]
[null,32000,null,"North West",null,null,null,"<Please select a payback period>"]
[null,33000,null,"Northern Cape",null,"Existing Farm",null,1]
[null,34000,null,"The Free State",null,"<Do you already have a Farm?>",null,{"$f":"H21+1","v":2}]
[null,35000,null,"Western Cape",null,"Yes",null,{"$f":"H22+1","v":3}]
[null,36000,null,null,null,"No",null,4]
[null,37000,null,null,null,null,null,5]
[null,38000,null,"LOAN",null,null,null,6]
[null,39000,null,"<Type of financing>",null,"TUNNEL SYSTEM",null,7]
[null,40000,null,"Debt",null,"<Tunnel System?>",null,8]
[null,41000,null,"Equity",null,"Yes",null,9]
[null,42000,null,"Debt/Equity",null,"No",null,10]
[null,43000,null,null,null,"Existing Ras",null,11]
[null,44000,null,"NATURAL POND",null,"<Do you have an existing RAS system?>",null,12]
[null,45000,null,"<Will a natural pond be used?>",null,"Yes ",null,13]
[null,46000,null,"Yes",null,"No",null,14]
[null,47000,null,"No",null,"PRICE INCREASE %",null,15]
[null,48000,null,null,null,"<Please select an appropriate selling price?>",null,16]
[null,49000,null,"Length of production/ target weight",null,20,null,17]
[null,50000,null,"<Please select the length of production(target weight)>",null,21,null,18]
[null,51000,null,"1 Month",null,22,null,19]
[null,52000,null,"2 Months",null,23,null,20]
[null,53000,null,"3 Months",null,24,null,"Percentage Debt"]
[null,54000,null,"4 Months",null,25,null,"<Select % to be financed through debt>"]
[null,55000,null,"5 Months",null,26,null,0.05]
[null,56000,null,"6 Months",null,27,null,0.1]
[null,57000,null,"7 Months",null,28,null,0.15]
[null,58000,null,"8 Months",null,29,null,0.2]
[null,59000,null,"9 Months",null,30,null,0.25]
[null,60000,null,null,null,null,null,0.3]
[null,61000,null,null,null,null,null,0.35]
[null,62000,null,null,null,null,null,0.4]
[null,63000,null,null,null,null,null,0.45]
[null,64000,null,null,null,null,null,0.5]
[null,65000,null,null,null,null,null,0.55000000000000004]
[null,66000,null,null,null,null,null,0.6]
[null,67000,null,null,null,null,null,0.65]
[null,68000,null,null,null,null,null,0.7]
[null,69000,null,null,null,null,null,0.75]
[null,70000,null,null,null,null,null,0.8]
[null,71000,null,null,null,null,null,0.85]
[null,72000,null,null,null,null,null,0.9]
[null,73000,null,null,null,null,null,0.95]
[null,74000,null,null,null,null,null,1]
[null,75000]
[null,null,null,null,null,null,null,"Marine Ornamentals"]
[null,null,null,null,null,null,null,"<Please Select a Species>"]
[null,null,null,null,null,null,null,"Substrate Spawners"]
[null,null,null,null,null,null,null,"Egg Broadcasters"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,57]
[null,null,null,58]
[null,null,null,59]
[null,null,null,60]

{"sheet":"Production Assumptions","index":4,"n_rows":75,"n_cols":12,"rows_kept":75,"cut":false,"hidden":false,"merged":[[2,1,2,2],[40,1,40,2],[0,0,0,16383]]}
["PRODUCTION ASSUMPTIONS - MARINE ORNAMENTALS MODEL"]
[]
[null,"GENERAL ASSUMPTIONS",null,null,null,"Tonnages","Permits","Price"]
[null,"CPI",{"$f":"'Built-In Assumptions'!E5","v":5.0999999999999997E-2},null,null,"15 year aquaculture right. Annual permit to undertake marine aquaculture. Annual permit to operate a marine hatchery.  \n",null,4500]
[null,"Days per month",30]
[null," CPI in percentage",{"$f":"C4+1","v":1.0509999999999999},null,null,"Feed & Stocking",null,"FEED AVERAGE"]
[null,"Business Tax",{"$f":"'Built-In Assumptions'!E6","v":0.28000000000000003},null,null,"Stocking number",{"$f":"G8","v":300},{"$f":"'Built-In Assumptions'!E15","v":30}]
[null,"Vet services (once a month)",{"$f":"'Built-In Assumptions'!E10","v":1500},null,null,"Stocking density (fish per m³)",300]
[null,"Water (per kl) for 2017",{"$f":"'Built-In Assumptions'!E7","v":0},null,null,"FCR",3]
[null,"water price increases by: (pa)",1.0509999999999999,null,null,"Additional",null,"FEED AVERAGE"]
[null,"Security ",{"$f":"'Built-In Assumptions'!E9","v":800},null,null,"Packaging (per 100 fish)",40,{"$f":"(Interface!J7/100)*'Production Assumptions'!G11","v":{"$error":"#VALUE!"}}]
[null,"Electricity  (per kWh)",{"$f":"'Built-In Assumptions'!E8","v":1.0900000000000001},"Eskom",null,"Freight (per 100 fish)",50,{"$f":"(Interface!J7/100)*'Production Assumptions'!G12","v":{"$error":"#VALUE!"}}]
[null,"Facilities Electricty (per square meter)",20.14,null,null,"Chemicals (per tunnel)",300,{"$f":"'CAPEX '!E7*'Production Assumptions'!G13","v":{"$error":"#VALUE!"}}]
[null,"Recommended Sale price: R/kg",35,null,null,"Consumables (per tunnel)",500,{"$f":"G14*'CAPEX '!E7","v":{"$error":"#VALUE!"}}]
[null,"Cost of a fingerling/fish",{"$f":"'Built-In Assumptions'!E13","v":50}]
[null,"Cost of brood pair",150]
[null,"Number of brood pairs",50]
[null,"Land price (Dry land crop)/ha",{"$f":"'Built-In Assumptions'!E18","v":246346}]
[null,"Months of production (max)",6]
[null,"Final weight of fish (grams)",10]
[null,"Expected Survival (%) ",{"$f":"IF(Interface!$E$7=Validation!$H$66,80%,10%)","v":0.1}]
[null,"Expected Mortality rate ",{"$f":"1-C21","v":0.9}]
[null,"Average Monthly Mortality Rate",{"$f":"C22/C19","v":0.15}]
[]
[]
[]
[null,"Inputs","Unit","Price"]
[null,{"$f":"'Technical info'!J4","v":"Electricity Per tank (kWh/day)"},null,{"$f":"'Technical info'!K4","v":1.3}]
[null,{"$f":"'Technical info'!J5","v":"Electricity Per tank (kWh/month)"},null,{"$f":"'Technical info'!K5","v":39}]
[null,{"$f":"'Technical info'!J6","v":"Total Electricity Breeding Tanks/month"},null,{"$f":"'Technical info'!K6","v":1950}]
[null,{"$f":"'Technical info'!J7","v":"Cost breeding tanks/month"},null,{"$f":"D30*C12","v":2125.5}]
[]
[]
[null,"HUMAN RESOURCES",null,null,"RAS","Number of Fish"]
[null,"Skills level","Salary","No. of employees","Ratio (person per Fish)",{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"}]
[null,"High skilled (Owner)",{"$f":"'Built-In Assumptions'!E22","v":0},null,{"$f":"1/1000000","v":9.9999999999999995E-7},{"$f":"IF(Interface!J7<=25000,0,1)","v":1},{"$f":"E36*$F$35","v":{"$error":"#VALUE!"}}]
[null,"Low skilled",{"$f":"'Built-In Assumptions'!E23","v":5000},null,9.9999999999999995E-7,{"$f":"IF(F35<=30000,1,3)","v":3},{"$f":"E37*$F$35","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"SUM(C36:C37)","v":5000},null,"Number of people: ",{"$f":"ROUNDDOWN(F37+F36,0)","v":4}]
[]
[]
[null,"Assumption: Working Capital -RAS"]
[null,null,"Debtors Recovery Rate","RateRecovery Period"]
[null,null,12,1]
[]
[null,"Expected to receive 11 of the 12 months payments in present year and the last month in the following year"]
[]
[null,null,"YEAR 1","YEAR 2","YEAR 3","YEAR 4","YEAR 5","YEAR 6","YEAR 7","YEAR 8","YEAR 9","YEAR 10"]
[null,"INCOME",{"$f":"'IS - RAS'!D7","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!E7","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!F7","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!G7","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!H7","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!I7","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!J7","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!K7","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!L7","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!M7","v":{"$error":"#VALUE!"}}]
[null,"EFFECT ON CASH",{"$f":"(($C$43-$D$43)/$C$43*C48+($D$43/$C$43)*C51)","v":{"$error":"#VALUE!"}},{"$f":"(($C$43-$D$43)/$C$43*D48+($D$43/$C$43)*C48)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"DEBTORS",{"$f":"C48-C49","v":{"$error":"#VALUE!"}},{"$f":"C50+D48-D49","v":{"$error":"#VALUE!"}},{"$f":"D50+E48-E49","v":{"$error":"#VALUE!"}},{"$f":"E50+F48-F49","v":{"$error":"#VALUE!"}},{"$f":"F50+G48-G49","v":{"$error":"#VALUE!"}},{"$f":"G50+H48-H49","v":{"$error":"#VALUE!"}},{"$f":"H50+I48-I49","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
[]
[null,"Assumptions on costs and increases"]
[null,"Increase in Insurance",0.02]
[null,"Market size",{"$f":"IF(Interface!$E$18=Validation!$D$47,3,IF(Interface!$E$18=Validation!$D$46,2.5,IF(Interface!$E$18=Validation!$D$45,2,IF(Interface!$E$18=Validation!$D$44,1.75,IF(Interface!$E$18=Validation!$D$43,1.5,IF(Interface!$E$18=Validation!$D$42,0.75,IF(Interface!$E$18=Validation!$D$41,0.4,IF(Interface!$E$18=Validation!D40,0.02,'Feed and Biomass'!D4))))))))","v":1.75}]
[null,"Transport cost (local)",{"$f":"D72","v":{"$error":"#VALUE!"}}]
[null,"Telephone costs",{"$f":"IF(AND(Interface!$H$7=Validation!$H$4,Interface!$J$7<10000),500,IF(AND(Interface!$H$7=Validation!$H$4,Interface!$J$7<100000),1000,IF(AND(Interface!$H$7=Validation!$H$4,Interface!$J$7>100000),2000,IF(AND(Interface!$H$7=Validation!$H$3,Interface!$J$7<10000),250,IF(AND(Interface!$H$7=Validation!$H$3,Interface!$J$7<100000),500,1000)))))","v":1000}]
[null,"increase in transport cost",0.02]
[null,"Health and safety apparel",{"$f":"'Built-In Assumptions'!E11","v":500}]
[null,"stationary",{"$f":"'Built-In Assumptions'!E12","v":100}]
[null,"Cleaning materials",800]
[null,"Vet Services",{"$f":"IF(Interface!$J$7<10000,'Built-In Assumptions'!E10,IF(Interface!J7<100000,2500,5000))","v":5000}]
[null,"Bank Charges",{"$f":"1.9/100","v":1.9E-2}]
[null,"Marketing",{"$f":"IF(Interface!$J$7<5000,500,500*(1+(0.02*Interface!$J$7/1000)))","v":{"$error":"#VALUE!"}}]
[null,"increase in marketing ",0.01]
[null,"Percentage of variable costs kept as a reserve",{"$f":"IF(Interface!$J$7<20000,0.01,0.03)","v":0.03}]
[null,"Transport cost (International)",{"$f":"D73","v":{"$error":"#VALUE!"}}]
[null,"liters per cubic meter",1000]
[null,"2kg Weight conversion - Fuel ",1.4600000000000001E-7]
[null,"Weight conversion - Fuel ",{"$f":"C70/2","v":7.3000000000000005E-8}]
[null,"Local Radius (KM) from farm (max)",{"$f":"IF(OR(Interface!$F$7=Validation!$D$15,Interface!$F$7=Validation!$D$16,Interface!$F$7=Validation!$D$23,Interface!$F$7=Validation!$D$17),100,IF(OR(Interface!$F$7=Validation!$D$18,Interface!$F$7=Validation!$D$19,Interface!$F$7=Validation!$D$20,Interface!$F$7=Validation!$D$22),120,200))*((Interface!$J$7/1000)/2)","v":{"$error":"#VALUE!"}},{"$f":"(C75*C72)+(C74*C71)","v":{"$error":"#VALUE!"}}]
[null,"International Radius (KM) from farm (max)",{"$f":"IF(OR(Interface!$F$7=Validation!$D$15,Interface!$F$7=Validation!$D$16,Interface!$F$7=Validation!$D$23,Interface!$F$7=Validation!$D$17),240,IF(OR(Interface!$F$7=Validation!$D$18,Interface!$F$7=Validation!$D$19,Interface!$F$7=Validation!$D$20,Interface!$F$7=Validation!$D$22),350,500))*((Interface!$J$7/1000)/2)","v":{"$error":"#VALUE!"}},{"$f":"(C75*C73)+(C74*C71)","v":{"$error":"#VALUE!"}}]
[null,"# of fish",{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"}]
[null,"2 to 5 tonne bakkie (R/Km)",{"$f":"'Built-In Assumptions'!E17","v":20}]

{"sheet":"Technical info","index":5,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[24,1,24,3],[24,5,24,6]]}
[]
[null,"MARINE ORNAMENTALS"]
[null,"Production Per Tunnel",null,null,null,null,null,null,null,"Electricity Usage"]
[null,null,null,null,"Volume",null,null,null,null,"Electricity Per tank (kWh/day)",1.3]
[null,"Number of Ponds",{"$f":"72","v":72},null,1200,null,null,null,null,"Electricity Per tank (kWh/month)",{"$f":"K4*30","v":39}]
[null,"Breeding Tanks",50,null,null,null,null,null,null,"Total Electricity Breeding Tanks/month",{"$f":"C6*K5","v":1950}]
[null,"Grow out Ponds",72,null,null,null,null,null,null,"Cost breeding tanks/month",{"$f":"K6*'Built-In Assumptions'!E8","v":2125.5}]
[null,"Volume water/tank",{"$f":"C9*C10*C11","v":1.2}]
[null,"    ~Length (m)",1.2]
[null,"    ~width (m)",1]
[null,"    ~Hight (m)",1,null,null,null,null,null,null,"Required Number of Systems"]
[null,"Price per tank",3000,null,null,null,null,null,null,"Total Number fish/tunnel",{"$f":"C5*C15","v":21600}]
[null,"Production Assumptions"]
[null,"Density (fish/litre)",1,null,null,null,null,null,null,"Total no fish required/pa",{"$f":"Interface!J7","v":"<Please Select Number of Fish>"},"*After mortality Rate"]
[null,"Stocking density/pond",{"$f":"'Production Assumptions'!G8","v":300},null,null,null,null,null,null,"Fish to sell per month",{"$f":"K14/12","v":{"$error":"#VALUE!"}}]
[null,"Grow Out period (months)",6,null,null,null,null,null,null,"Total no fish required/pa",{"$f":"(K14*'Production Assumptions'!C22)+K14","v":{"$error":"#VALUE!"}},"* Before mortality rate"]
[null,"Harvest weight of fish (g)",{"$f":"'Production Assumptions'!C20","v":10},null,null,null,null,null,null,"Total number ponds needed",{"$f":"ROUNDDOWN(K16/'Technical info'!C15,0)","v":{"$error":"#VALUE!"}},"* based on required number fish/pa"]
[null,"Breeding Info",100,null,null,"Per fish","Total Price",null,null,"Total number tunnels needed",{"$f":"ROUND(K17/C5,0)","v":{"$error":"#VALUE!"}},"* based on required number fish/pa"]
[null,"Males",0.5,null,{"$f":"C18*C19","v":50},50,{"$f":"E19*F19","v":2500},null,null,"Water Volume",{"$f":"E5/C5","v":16.666666666666668}]
[null,"Females",0.5,null,{"$f":"C20*C18","v":50},50,{"$f":"E20*F20","v":2500}]
[null,"Number Breeding Tanks ( 1 per pair)",{"$f":"C18/2","v":50}]
[]
[]
[]
[null,"BREEDING ASSUMPTIONS",null,null,null,"MALE TO FEMALE RATIO"]
[null,"Substrate Spawners - Clownfish/Dottybacks",null,null,null,"Egg Scatters -Yellow Tangs",{"$f":"SUM(G27:G28)","v":3}]
[null,"Breeding stock - per fish",null,50,null,"Egg Scatter Males",2]
[null,"Number of fish to buy",null,100,null,"Egg Scatter Females",1]
[null,"Estimated number of breeding pairs",null,30,null,"Substrate Spawners",{"$f":"SUM(G30:G31)","v":2}]
[null,"Initial broodstock cost",null,{"$f":"D27*D28","v":5000},null,"Substrate Spawners males",1]
[null,"Ratio of fish/pairs",null,0.6,null,"Substrate Spawners Females",1]
[null,"Number of eggs produced per pair",null,500]
[null,"Survival Rate of eggs",null,0.7]
[null,"Mortality rate of eggs/fry",null,0.3]
[null,"Total Number of eggs produced",null,175000]
[null,"Total number of eggs/fry for sale (after mortality)",null,{"$f":"D35-(D35*D34)","v":122500}]
[null,"Ratio brood pairs/fry (each produce/eggs)",null,{"$f":"D36/D29","v":4083.3333333333335}]
[null,"Number of fish to produce/annum",null,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"}]
[null,"Number of fish to sell/month",null,{"$f":"D38/12","v":{"$error":"#VALUE!"}}]
[null,"Number of fish to buy",null,{"$f":"ROUNDUP((D41*G29)*10/6,0)","v":{"$error":"#VALUE!"}}]
[null,"Number of brood pairs required (M 1)",null,{"$f":"ROUNDUP(D39/D37,0)","v":{"$error":"#VALUE!"}}]
[]
[null,"Egg Scatters -Yellow Tangs"]
[null,"Breeding stock - per fish",null,200]
[null,"Number of fish to buy",null,100]
[null,"Estimated number of breeding pairs",null,20]
[null,"Ratio fish/pairs",null,0.6]
[null,"Number of eggs produced per pair",null,250000]
[null,"Mortality Rate",null,0.95]
[null,"Number of eggs/pair (after mortality)",null,{"$f":"D48-(D48*D49)","v":12500}]
[null,"Number of fish (after monthly mortality)",null,{"$f":"D50-(D50*D49)","v":625}]
[null,"Number of fish to produce/annum",null,{"$f":"Interface!J30","v":"Please select a different system"}]
[null,"Number of fish to sell/month",null,{"$f":"D52/12","v":{"$error":"#VALUE!"}}]
[null,"Number of breeding fish required in M 1",null,{"$f":"ROUNDUP((D55*G26)*10/6,0)","v":{"$error":"#VALUE!"}}]
[null,"Number of brood pairs required",null,{"$f":"ROUNDUP(D52/D50,0)","v":{"$error":"#VALUE!"}}]

{"sheet":"Feed and Biomass","index":6,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,16383]]}
["FEED REQUIREMENTS - MARINE ORNAMENTALS MODEL"]
[]
[null,null,null,null,"Pond Size",null,{"$f":"'Technical info'!E5","v":1200}]
[null,null,"BIOMASS CALCULATIONS",null,"Number fish/pond",null,{"$f":"'Technical info'!C15","v":300}]
[null,null,"Fish per pond",{"$f":"'Technical info'!C15","v":300},"Number of ponds",null,{"$f":"'Technical info'!K17","v":{"$error":"#VALUE!"}}]
[null,null,"Final Mass fish (g)",10]
[null,null,"Biomass per pond (kg)",{"$f":"(G4*D6)/1000","v":3}]
[null,null,"Biomass for all ponds",{"$f":"D7*G5","v":{"$error":"#VALUE!"}}]
[null,null,"Biomass (kg) per m3",{"$f":"(D8/G3)*1000","v":{"$error":"#VALUE!"}}]
[]
[null,null,"FEED CALCULATIONS"]
[null,null,"Growout period (months)",{"$f":"'Production Assumptions'!C19","v":6}]
[null,null,"FCR",{"$f":"'Production Assumptions'!G9","v":3}]
[null,null,"Price of Feed/kg",{"$f":"'Production Assumptions'!H7","v":30}]
[null,null,"Final Biomass/pond",{"$f":"D7","v":3}]
[null,null,"Total feed/pond/growout",{"$f":"D15*D13","v":9}]
[null,null,"Total feed for grow out (kg)",{"$f":"G5*D16","v":{"$error":"#VALUE!"}}]
[null,null,"Monthly Feed Avg",{"$f":"D17/D12","v":{"$error":"#VALUE!"}}]
[null,null,"Avg feed price/month",{"$f":"D14*D18","v":{"$error":"#VALUE!"}}]

{"sheet":"Bio-Model","index":7,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":true,"merged":[[0,0,0,16383]]}
["BIO-MODEL - MARINE ORNAMENTALS MODEL"]
[]
["Biofilter"]
["Hungary model"]
[null,"Portion of system"]
["Solids settlement",{"$f":"100/3","v":33.333333333333336}]
[]
["Biofilter - RAS"]
["TAN removal per day (0.4-0.6g/m2/day)"]
["For removal of TAN from 1 kg of feed , 70-80m2 of biofilter needed (about 0.5m3 biofilter vlume)"]
[null,null,null,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"}]
["recirc vol"]
["Biofileter surface area per 1 kg dailyl feed",null,null,75,null,null,null,null,null,"1 ton","3 ton","5 ton","8 ton","10 ton","100 ton"]
["Daily feed amount",null,null,{"$f":"'Feed and Biomass'!D18/30","v":{"$error":"#VALUE!"}},null,null,null,"Volume (m3)",null,1,1,1,5.4,5.4,5.4]
["Biofilter surface area needed m",null,null,{"$f":"D14*D13","v":{"$error":"#VALUE!"}},null,null,null,"Diameter (m)",null,1.3,1.3,1.3,2.5,2.5,2.5]
["Biofilter media vol needed at (800 m2/m3) ",null,null,{"$f":"D15/800","v":{"$error":"#VALUE!"}},null,null,null,"Depth (m)",null,0.8,0.8,0.8,1.1000000000000001,1.1000000000000001,1.1000000000000001]
["Biofilter vol",null,null,{"$f":"D14*1.1","v":{"$error":"#VALUE!"}},null,null,null,"Price per tank",null,1100,1100,1100,3400,3400,3400]
["Biofilter tank size",null,null,{"$f":"IF(Interface!J7<=3000,K14,IF(Interface!$J$7<=5000,L14,IF(Interface!$J$7<=10000,N14,O14)))","v":5.4}]
["Number of biofilter tanks",null,null,{"$f":"ROUNDUP(D17/D18,0)","v":{"$error":"#VALUE!"}}]

{"sheet":"CAPEX ","index":8,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,1,2,9],[0,0,0,16383]]}
["CAPITAL EXPENDITURE - FRESHWATER ORNAMENTALS MODEL"]
[]
[null,"RAS - CAPEX TO ESTABLISH ONE TUNNEL & NECESSARY INFRASTRUCTURE"]
[null,"Item","Units","Capacity (tanks per month)","Number of units","RATIO","Price per Unit (R)","Number of Fish","TOTAL","TOTAL: WITH Increases in numbers",null,"Pumps"]
[null,"1. Infrastructure",null,null,null,null,null,null,null,{"$f":"SUM(J6:J9)","v":{"$error":"#VALUE!"}},null,"no pumps (2 pumps per tunnel)",2,{"$f":"E7*M5","v":{"$error":"#VALUE!"}}]
[null,"Hatchery Room",{"$f":"IF(Interface!J7<=25000,6*8,IF(Interface!J7<=35000,8*8,9*8))","v":72},null,1,1,1200,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"C6*G6","v":86400},{"$f":"IF(Interface!E15=\"EXISTING\",0,I6)","v":86400},null,"Pump Cost",null,1200]
[null,"Tunnels (number) (m)",{"$f":"50*3","v":150},null,{"$f":"'Technical info'!K18","v":{"$error":"#VALUE!"}},1,80000,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"G7*E7","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!F18=Validation!F30,0,I7)","v":{"$error":"#VALUE!"}}]
[null,"Office/Storage/Feed store",{"$f":"IF(Interface!J7<=25000,6*8,IF(Interface!J7<=35000,8*8,9*8))","v":72},null,1,1,2500,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"G8*C8*F8","v":180000},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I8)","v":180000}]
[null,"Packing Room (Complete with tanks,piping etc)",{"$f":"5*5","v":25},null,1,{"$f":"IF(Interface!J7<=25000,1,1.01)","v":1.01},25000,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"E9*G9*F9","v":25250},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I9)","v":25250}]
[null,"2. Land",null,null,null,null,null,null,null,{"$f":"J11","v":{"$error":"#VALUE!"}}]
[null,"Purchase Land (ha)",1,null,{"$f":"IF(Interface!$J$7<=20000,1.5,1.5+(Interface!$J$7/1000)*0.04)","v":{"$error":"#VALUE!"}},null,{"$f":"'Production Assumptions'!$C$18","v":246346},{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"G11*E11*C11","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Interface!F15=\"YES\",Interface!E15=\"EXISTING\"),0,IF(AND(Interface!F15=\"YES\",Interface!E15=Validation!$H$9),0,'CAPEX '!I11))","v":{"$error":"#VALUE!"}}]
[null,"3. Equipment",null,null,null,null,null,null,null,{"$f":"SUM(J13:J23)","v":{"$error":"#VALUE!"}}]
[null,"Grow-out containment number (m3)",1.5,null,{"$f":"'Technical info'!K17","v":{"$error":"#VALUE!"}},null,{"$f":"'Technical info'!C12","v":3000},{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"G13*E13","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I13)","v":{"$error":"#VALUE!"}}]
[null,"Hatchery: Breeding Tanks (1 brood pair/tank)",null,null,{"$f":"'Technical info'!C21","v":50},null,250,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"G14*E14","v":12500},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I14)","v":12500}]
[null,"Hatchery Tank Stands",null,null,{"$f":"ROUNDUP(E14/3,0)","v":17},null,1200,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"G15*E15","v":20400},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I15)","v":20400}]
[null,"Hatchery piping & Fittings",null,null,1,1,10000,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"G16*E16","v":10000},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I16)","v":10000}]
[null,"Hatchery Heating/cooling",null,null,1,1,15000,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},15000,{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I17)","v":15000}]
[null,"Water quality testing equipment",1,null,1,null,16500,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"E18*G18","v":16500},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I18)","v":16500}]
[null,"Water Pumps",null,null,{"$f":"N5","v":{"$error":"#VALUE!"}},null,{"$f":"N6","v":1200},{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"G19*E19","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I19)","v":{"$error":"#VALUE!"}}]
[null,"Water Supply Piping & fittings",null,null,{"$f":"E7","v":{"$error":"#VALUE!"}},1,6000,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"G20*E20*F20","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I20)","v":{"$error":"#VALUE!"}}]
[null,"Water Drainage Piping & fittings",null,null,{"$f":"E7","v":{"$error":"#VALUE!"}},1,8000,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"G21*E21*F21","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I21)","v":{"$error":"#VALUE!"}}]
[null,"Biofilter Tank",{"$f":"'Bio-Model'!D18","v":5.4},null,{"$f":"'Bio-Model'!D19","v":{"$error":"#VALUE!"}},1,{"$f":"IF(Interface!J7<=3000,'Bio-Model'!K17,IF(Interface!$J$7<=5000,'Bio-Model'!L17,IF(Interface!$J$7<=10000,'Bio-Model'!M17,'Bio-Model'!O17)))","v":3400},{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"C22*G22","v":18360},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I22)","v":18360}]
[null,"Biofilter Media",{"$f":"'Bio-Model'!D16","v":{"$error":"#VALUE!"}},null,null,null,7000,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"G23*C23","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I23)","v":{"$error":"#VALUE!"}}]
[null,"4. More Equipment",null,null,null,null,null,null,null,{"$f":"SUM(J25:J30)","v":{"$error":"#VALUE!"}}]
[null,"Buckets/drums",1,null,{"$f":"'Production Assumptions'!F38","v":4},1,273.2,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"G25*E25","v":1092.8},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I25)","v":1092.8}]
[null,"Feeding Stations",null,null,{"$f":"E13","v":{"$error":"#VALUE!"}},null,15,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"G26*E26","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I26)","v":{"$error":"#VALUE!"}}]
[null,"Spawning Traps",null,null,{"$f":"E14","v":50},null,150,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"G27*E27","v":7500},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I27)","v":7500}]
[null,"Office equipment",1,null,1,1,6000,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"G28*C28","v":6000},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I28)","v":6000}]
[null,"Short/long handle Hand net",1,null,{"$f":"E25","v":4},1,216,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"G29*E29","v":864},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I29)","v":864}]
[null,"Vehicle",{"$f":"IF(Interface!$J$7<=20000,0,1)","v":1},null,0,null,200000,{"$f":"Interface!$J$7","v":"<Please Select Number of Fish>"},{"$f":"G30*C30","v":200000},{"$f":"IF(Interface!$E$15=\"EXISTING\",0,I30)","v":200000}]
[null,"TOTAL EXCLUDING Working Capital",null,null,null,null,null,null,null,{"$f":"J24+J12+J10+J5","v":{"$error":"#VALUE!"}}]

{"sheet":"HR","index":9,"n_rows":21,"n_cols":46,"rows_kept":21,"cut":false,"hidden":true,"merged":[[10,36,11,36],[10,29,11,29],[10,30,11,30],[0,0,0,16383],[2,1,2,45],[10,31,11,31],[10,32,11,32],[10,33,11,33],[10,34,11,34],[10,35,11,35],[17,1,17,9],[4,4,4,15],[4,17,4,28],[10,3,10,14],[10,17,10,28],[10,15,11,15],[10,16,11,16]]}
["HUMAN RESOURCES - FRESHWATER ORNAMENTALS MODEL"]
[]
[null,"RAS"]
[null,"LABOUR:"]
[null,null,null,null,"YEAR 1",null,null,null,null,null,null,null,null,null,null,null,1,"YEAR 2",null,null,null,null,null,null,null,null,null,null,null,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9]
[null,"Employees:","Year 1","Annual Cost: Year 1","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12","Year 2:","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12","Annual Cost: Year 2","Year 3:","Annual Cost: Year 3","Year 4:","Annual Cost: Year 4","Year 5","Annual Cost: Year 5","Year 6","Annual Cost: Year 6","Year 7","Annual Cost: Year 7","Year 8","Annual Cost: Year 8","Year 9","Annual Cost: Year 9","Year 10","Annual Cost: Year 10"]
[null,"Owner",{"$f":"P13","v":1},{"$f":"SUM(E7:P7)","v":0},{"$f":"'Production Assumptions'!$C$36*D13","v":0},{"$f":"'Production Assumptions'!$C$36*E13","v":0},{"$f":"'Production Assumptions'!$C$36*F13","v":0},{"$f":"'Production Assumptions'!$C$36*G13","v":0},{"$f":"'Production Assumptions'!$C$36*H13","v":0},{"$f":"'Production Assumptions'!$C$36*I13","v":0},{"$f":"'Production Assumptions'!$C$36*J13","v":0},{"$f":"'Production Assumptions'!$C$36*K13","v":0},{"$f":"'Production Assumptions'!$C$36*L13","v":0},{"$f":"'Production Assumptions'!$C$36*M13","v":0},{"$f":"'Production Assumptions'!$C$36*N13","v":0},{"$f":"'Production Assumptions'!$C$36*O13","v":0},{"$f":"Q13","v":1},{"$f":"'Production Assumptions'!$C$36*(1+'Production Assumptions'!$C$4)*R13","v":0},{"$f":"'Production Assumptions'!$C$36*(1+'Production Assumptions'!$C$4)*S13","v":0},{"$f":"'Production Assumptions'!$C$36*(1+'Production Assumptions'!$C$4)*T13","v":0},{"$f":"'Production Assumptions'!$C$36*(1+'Production Assumptions'!$C$4)*U13","v":0},{"$f":"'Production Assumptions'!$C$36*(1+'Production Assumptions'!$C$4)*V13","v":0},{"$f":"'Production Assumptions'!$C$36*(1+'Production Assumptions'!$C$4)*W13","v":0},{"$f":"'Production Assumptions'!$C$36*(1+'Production Assumptions'!$C$4)*X13","v":0},{"$f":"'Production Assumptions'!$C$36*(1+'Production Assumptions'!$C$4)*Y13","v":0},{"$f":"'Production Assumptions'!$C$36*(1+'Production Assumptions'!$C$4)*Z13","v":0},{"$f":"'Production Assumptions'!$C$36*(1+'Production Assumptions'!$C$4)*AA13","v":0},{"$f":"'Production Assumptions'!$C$36*(1+'Production Assumptions'!$C$4)*AB13","v":0},{"$f":"'Production Assumptions'!$C$36*(1+'Production Assumptions'!$C$4)*AC13","v":0},{"$f":"SUM(R7:AC7)","v":0},{"$f":"AD13","v":1},{"$f":"$AD7*(1+'Production Assumptions'!$C$4)","v":0},{"$f":"AE13","v":1},{"$f":"$AD7*(1+'Production Assumptions'!$C$4)^2","v":0},{"$f":"AF13","v":1},{"$f":"$AD7*(1+'Production Assumptions'!$C$4)^3","v":0},{"$f":"AG13","v":1},{"$f":"$AD7*(1+'Production Assumptions'!$C$4)^4","v":0},{"$f":"AH13","v":1},{"$f":"$AD7*(1+'Production Assumptions'!$C$4)^5","v":0},{"$f":"AI13","v":1},{"$f":"$AD7*(1+'Production Assumptions'!$C$4)^6","v":0},{"$f":"AJ13","v":1},{"$f":"$AD7*(1+'Production Assumptions'!$C$4)^7","v":0},{"$f":"AK13","v":1},{"$f":"$AD7*(1+'Production Assumptions'!$C$4)^8","v":0}]
[null,"Low Skilled",{"$f":"P14","v":3},{"$f":"SUM(E8:P8)","v":180000},{"$f":"'Production Assumptions'!$C$37*D14","v":15000},{"$f":"'Production Assumptions'!$C$37*E14","v":15000},{"$f":"'Production Assumptions'!$C$37*F14","v":15000},{"$f":"'Production Assumptions'!$C$37*G14","v":15000},{"$f":"'Production Assumptions'!$C$37*H14","v":15000},{"$f":"'Production Assumptions'!$C$37*I14","v":15000},{"$f":"'Production Assumptions'!$C$37*J14","v":15000},{"$f":"'Production Assumptions'!$C$37*K14","v":15000},{"$f":"'Production Assumptions'!$C$37*L14","v":15000},{"$f":"'Production Assumptions'!$C$37*M14","v":15000},{"$f":"'Production Assumptions'!$C$37*N14","v":15000},{"$f":"'Production Assumptions'!$C$37*O14","v":15000},{"$f":"Q14","v":3},{"$f":"'Production Assumptions'!$C$37*(1+'Production Assumptions'!$C$4)*R14","v":15765},{"$f":"'Production Assumptions'!$C$37*(1+'Production Assumptions'!$C$4)*S14","v":15765},{"$f":"'Production Assumptions'!$C$37*(1+'Production Assumptions'!$C$4)*T14","v":15765},{"$f":"'Production Assumptions'!$C$37*(1+'Production Assumptions'!$C$4)*U14","v":15765},{"$f":"'Production Assumptions'!$C$37*(1+'Production Assumptions'!$C$4)*V14","v":15765},{"$f":"'Production Assumptions'!$C$37*(1+'Production Assumptions'!$C$4)*W14","v":15765},{"$f":"'Production Assumptions'!$C$37*(1+'Production Assumptions'!$C$4)*X14","v":15765},{"$f":"'Production Assumptions'!$C$37*(1+'Production Assumptions'!$C$4)*Y14","v":15765},{"$f":"'Production Assumptions'!$C$37*(1+'Production Assumptions'!$C$4)*Z14","v":15765},{"$f":"'Production Assumptions'!$C$37*(1+'Production Assumptions'!$C$4)*AA14","v":15765},{"$f":"'Production Assumptions'!$C$37*(1+'Production Assumptions'!$C$4)*AB14","v":15765},{"$f":"'Production Assumptions'!$C$37*(1+'Production Assumptions'!$C$4)*AC14","v":15765},{"$f":"SUM(R8:AC8)","v":189180},{"$f":"AD14","v":3},{"$f":"$AD8*(1+'Production Assumptions'!$C$4)","v":198828.18},{"$f":"AE14","v":3},{"$f":"$AD8*(1+'Production Assumptions'!$C$4)^2","v":208968.41717999999},{"$f":"AF14","v":3},{"$f":"$AD8*(1+'Production Assumptions'!$C$4)^3","v":219625.80645618},{"$f":"AG14","v":3},{"$f":"$AD8*(1+'Production Assumptions'!$C$4)^4","v":230826.72258544518},{"$f":"AH14","v":3},{"$f":"$AD8*(1+'Production Assumptions'!$C$4)^5","v":242598.88543730287},{"$f":"AI14","v":3},{"$f":"$AD8*(1+'Production Assumptions'!$C$4)^6","v":254971.4285946053},{"$f":"AJ14","v":3},{"$f":"$AD8*(1+'Production Assumptions'!$C$4)^7","v":267974.97145293019},{"$f":"AK14","v":3},{"$f":"$AD8*(1+'Production Assumptions'!$C$4)^8","v":281641.69499702961}]
[null,null,{"$f":"P15","v":4},{"$f":"SUM(D7:D8)","v":180000},15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,4,15765,15765,15765,15765,15765,15765,15765,15765,15765,15765,15765,15765,189180,4,198828.18,4,208968.41717999999,4,219625.80645618,{"$f":"AI9","v":4},{"$f":"SUM(AL7:AL8)","v":230826.72258544518},4,242598.88543730287,4,254971.4285946053,4,267974.97145293019,4,281641.69499702961]
[]
[null,"HR",null,{"$f":"E5","v":"YEAR 1"},null,null,null,null,null,null,null,null,null,null,null,"Year 1","Year 2:",{"$f":"R5","v":"YEAR 2"},null,null,null,null,null,null,null,null,null,null,null,"Year 3:","Year 4:","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"No. of Employees:",null,{"$f":"E6","v":"Month 1"},{"$f":"F6","v":"Month 2"},"Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12",null,null,{"$f":"R6","v":"Month 1"},{"$f":"S6","v":"Month 2"},"Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
[null,"Managers:",{"$f":"B7","v":"Owner"},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"O13","v":1},{"$f":"AC13","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"'Production Assumptions'!$F$36","v":1},{"$f":"(AC$13)","v":1},{"$f":"(AD$13)","v":1},1,1,1,1,1,1]
[null,"Staff:",{"$f":"B8","v":"Low Skilled"},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"O14","v":3},{"$f":"AC14","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"'Production Assumptions'!$F$37","v":3},{"$f":"AC14","v":3},{"$f":"AD14","v":3},3,3,3,3,3,3]
[null,"Total:",null,{"$f":"SUM(D13:D14)","v":4},4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4]
[]
[]
[null,"Summary "]
[]
[null,null,null,"Year 1"]
[null,null,"RAS",{"$f":"C9","v":4}]

{"sheet":"OPEX - RAS","index":10,"n_rows":37,"n_cols":36,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,16383],[2,35,3,35],[2,29,3,29],[2,30,3,30],[2,31,3,31],[2,32,3,32],[2,33,3,33],[2,34,3,34],[2,2,3,2],[2,3,2,14],[2,15,3,15],[2,16,2,27],[2,28,3,28]]}
["OPERATIONAL EXPENDITURE - RAS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9]
[null,null,"YEAR 1",{"$f":"C3","v":"YEAR 1"},null,null,null,null,null,null,null,null,null,null,null,"YEAR 2","Year 2",null,null,null,null,null,null,null,null,null,null,null,"YEAR 3","YEAR 4","YEAR 5","YEAR 6","YEAR 7","YEAR 8","YEAR 9","YEAR 10"]
[null,null,null,"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12",null,"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
[null,"Income from Sales:"]
[null,"Marine Ornamentals (Selling stock)",{"$f":"SUM(D6:O6)","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$E$18=Validation!D39,(Interface!$I$7*'Feed and Biomass'!#REF!),0)","v":0},{"$f":"IF(Interface!$E$18=Validation!D39,D6,IF(Interface!$E$18=Validation!D40,Interface!$I$7*'Feed and Biomass'!#REF!,0))","v":0},{"$f":"IF(Interface!$E$18=Validation!D39,D6,IF(Interface!$E$18=Validation!D40,E6,IF(Interface!$E$18=Validation!D41,Interface!$I$7*'Feed and Biomass'!#REF!,0)))","v":0},{"$f":"IF(Interface!$E$18=Validation!D39,D6,IF(Interface!$E$18=Validation!D40,E6,IF(Interface!$E$18=Validation!D41,F6,IF(Interface!$E$18=Validation!D42,Interface!$I$7*'Feed and Biomass'!#REF!,0))))","v":0},{"$f":"IF(Interface!$E$18=Validation!D39,D6,IF(Interface!$E$18=Validation!D40,E6,IF(Interface!$E$18=Validation!D41,F6,IF(Interface!$E$18=Validation!D42,G6,IF(Interface!$E$18=Validation!D43,Interface!$I$7*'Feed and Biomass'!#REF!,0)))))","v":0},{"$f":"Interface!J10*Interface!I7","v":{"$error":"#VALUE!"}},{"$f":"I6","v":{"$error":"#VALUE!"}},{"$f":"J6","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(Q6:AB6)","v":{"$error":"#VALUE!"}},{"$f":"O6*'Production Assumptions'!$C$6","v":{"$error":"#VALUE!"}},{"$f":"Q6","v":{"$error":"#VALUE!"}},{"$f":"R6","v":{"$error":"#VALUE!"}},{"$f":"S6","v":{"$error":"#VALUE!"}},{"$f":"T6","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"($AB$6*'Production Assumptions'!$C$6)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$6*12)*('Production Assumptions'!$C$6)^AC2","v":{"$error":"#VALUE!"}},{"$f":"($AB$6*12)*('Production Assumptions'!$C$6)^AD2","v":{"$error":"#VALUE!"}},{"$f":"($AB$6*12)*('Production Assumptions'!$C$6)^AE2","v":{"$error":"#VALUE!"}},{"$f":"($AB$6*12)*('Production Assumptions'!$C$6)^AF2","v":{"$error":"#VALUE!"}},{"$f":"($AB$6*12)*('Production Assumptions'!$C$6)^AG2","v":{"$error":"#VALUE!"}},{"$f":"($AB$6*12)*('Production Assumptions'!$C$6)^AH2","v":{"$error":"#VALUE!"}},{"$f":"($AB$6*12)*('Production Assumptions'!$C$6)^AI2","v":{"$error":"#VALUE!"}}]
[null,"TOTAL INCOME:",{"$f":"SUM(D7:O7)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D6:D6)","v":0},0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"VARIABLE COSTS:"]
[null,"Breeding Fish",{"$f":"SUM(D10:O10)","v":20000},{"$f":"IF(Interface!$E$7=Validation!$H$66,'Technical info'!D28*'Technical info'!D27,'Technical info'!D44*'Technical info'!D45)","v":20000},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q10:AB10)","v":0},0,{"$f":"$O$10*('Production Assumptions'!$C$6)","v":0},{"$f":"$O$10*('Production Assumptions'!$C$6)","v":0},{"$f":"$O$10*('Production Assumptions'!$C$6)","v":0},{"$f":"$O$10*('Production Assumptions'!$C$6)","v":0},{"$f":"$O$10*('Production Assumptions'!$C$6)","v":0},{"$f":"$O$10*('Production Assumptions'!$C$6)","v":0},{"$f":"$O$10*('Production Assumptions'!$C$6)","v":0},{"$f":"$O$10*('Production Assumptions'!$C$6)","v":0},{"$f":"$O$10*('Production Assumptions'!$C$6)","v":0},{"$f":"$O$10*('Production Assumptions'!$C$6)","v":0},{"$f":"$O$10*('Production Assumptions'!$C$6)","v":0},null,{"$f":"((C10*'Production Assumptions'!C6)*'Production Assumptions'!C6*'Production Assumptions'!C6)","v":23218.713019999996},{"$f":"$P$10*('Production Assumptions'!$C$6)^AD2","v":0},{"$f":"$P$10*('Production Assumptions'!$C$6)^AE2","v":0},{"$f":"((AD10*'Production Assumptions'!C6)*'Production Assumptions'!C6*'Production Assumptions'!C6)","v":26955.431715255869},null,{"$f":"$P$10*('Production Assumptions'!$C$6)^AH2","v":0},{"$f":"((AG10*'Production Assumptions'!C6)*'Production Assumptions'!C6*'Production Assumptions'!C6)","v":31293.521666336612}]
[null,"Feed",{"$f":"SUM(D11:O11)","v":{"$error":"#VALUE!"}},{"$f":"'Feed and Biomass'!D19","v":{"$error":"#VALUE!"}},{"$f":"D11","v":{"$error":"#VALUE!"}},{"$f":"E11","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(Q11:AB11)","v":{"$error":"#VALUE!"}},{"$f":"O11*'Production Assumptions'!$C$6","v":{"$error":"#VALUE!"}},{"$f":"Q11","v":{"$error":"#VALUE!"}},{"$f":"R11","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"(AB11*12)*('Production Assumptions'!C6)","v":{"$error":"#VALUE!"}},{"$f":"($AB$11*12)*('Production Assumptions'!$C$6)^AC2","v":{"$error":"#VALUE!"}},{"$f":"($AB$11*12)*('Production Assumptions'!$C$6)^AD2","v":{"$error":"#VALUE!"}},{"$f":"($AB$11*12)*('Production Assumptions'!$C$6)^AE2","v":{"$error":"#VALUE!"}},{"$f":"($AB$11*12)*('Production Assumptions'!$C$6)^AF2","v":{"$error":"#VALUE!"}},{"$f":"($AB$11*12)*('Production Assumptions'!$C$6)^AG2","v":{"$error":"#VALUE!"}},{"$f":"($AB$11*12)*('Production Assumptions'!$C$6)^AH2","v":{"$error":"#VALUE!"}},{"$f":"($AB$11*12)*('Production Assumptions'!$C$6)^AI2","v":{"$error":"#VALUE!"}}]
[null,"Freight (per 100 fish)",{"$f":"SUM(D12:O12)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Interface!$H$7=\"International Markets\",Interface!$E$18=Validation!$D$39),'Production Assumptions'!$C$68,IF(AND(Interface!$H$7=Validation!$H$3,Interface!$E$18=Validation!$D$39),'Production Assumptions'!$C$57,300))","v":300},{"$f":"IF(AND(Interface!$H$7=\"International Markets\",Interface!$E$18=Validation!$D$40),'Production Assumptions'!$C$68,IF(AND(Interface!$H$7=Validation!$H$3,Interface!$E$18=Validation!$D$40),'Production Assumptions'!$C$57,D12))","v":300},{"$f":"IF(AND(Interface!$H$7=\"International Markets\",Interface!$E$18=Validation!$D$41),'Production Assumptions'!$C$68,IF(AND(Interface!$H$7=Validation!$H$3,Interface!$E$18=Validation!$D$41),'Production Assumptions'!$C$57,E12))","v":300},{"$f":"IF(AND(Interface!$H$7=\"International Markets\",Interface!$E$18=Validation!$D$42),'Production Assumptions'!$C$68,IF(AND(Interface!$H$7=Validation!$H$3,Interface!$E$18=Validation!$D$42),'Production Assumptions'!$C$57,F12))","v":300},{"$f":"IF(AND(Interface!$H$7=\"International Markets\",Interface!$E$18=Validation!$D$43),'Production Assumptions'!$C$68,IF(AND(Interface!$H$7=Validation!$H$3,Interface!$E$18=Validation!$D$43),'Production Assumptions'!$C$57,G12))","v":300},{"$f":"'Production Assumptions'!H12","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Interface!$H$7=\"International Markets\",Interface!$E$18=Validation!$D$45),'Production Assumptions'!$C$68,IF(AND(Interface!$H$7=Validation!$H$3,Interface!$E$18=Validation!$D$45),'Production Assumptions'!$C$57,I12))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Interface!$H$7=\"International Markets\",Interface!$E$18=Validation!$D$46),'Production Assumptions'!$C$68,IF(AND(Interface!$H$7=Validation!$H$3,Interface!$E$18=Validation!$D$46),'Production Assumptions'!$C$57,J12))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Interface!$H$7=\"International Markets\",Interface!$E$18=Validation!D47),'Production Assumptions'!$C$68,IF(AND(Interface!$H$7=Validation!$H$3,Interface!$E$18=Validation!D47),'Production Assumptions'!$C$57,K12))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Interface!$H$7=\"International Markets\",Interface!$E$18=Validation!$D$48),'Production Assumptions'!$C$68,IF(AND(Interface!$H$7=Validation!$H$3,Interface!$E$18=Validation!$D$48),'Production Assumptions'!$C$57,L12))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Interface!$H$7=\"International Markets\",Interface!$E$18=Validation!$D$49),'Production Assumptions'!$C$68,IF(AND(Interface!$H$7=Validation!$H$3,Interface!$E$18=Validation!$D$49),'Production Assumptions'!$C$57,M12))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Interface!$H$7=\"International Markets\",Interface!$E$18=Validation!$D$50),'Production Assumptions'!$C$68,IF(AND(Interface!$H$7=Validation!$H$3,Interface!$E$18=Validation!$D$50),'Production Assumptions'!$C$57,N12))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Q12:AB12)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(Interface!$H$7=\"International Markets\",Interface!$E$18=Validation!$D$51),'Production Assumptions'!$C$68,IF(AND(Interface!$H$7=Validation!$H$3,Interface!$E$18=Validation!$D$51),'Production Assumptions'!$C$57,O12))*'Production Assumptions'!$C$6^'OPEX - RAS'!$P$2","v":{"$error":"#VALUE!"}},{"$f":"Q12","v":{"$error":"#VALUE!"}},{"$f":"R12","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"($AB$12*12)*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"($AB$12*12)*('Production Assumptions'!$C$6)^AC2","v":{"$error":"#VALUE!"}},{"$f":"($AB$12*12)*('Production Assumptions'!$C$6)^AD2","v":{"$error":"#VALUE!"}},{"$f":"($AB$12*12)*('Production Assumptions'!$C$6)^AE2","v":{"$error":"#VALUE!"}},{"$f":"($AB$12*12)*('Production Assumptions'!$C$6)^AF2","v":{"$error":"#VALUE!"}},{"$f":"($AB$12*12)*('Production Assumptions'!$C$6)^AG2","v":{"$error":"#VALUE!"}},{"$f":"($AB$12*12)*('Production Assumptions'!$C$6)^AH2","v":{"$error":"#VALUE!"}},{"$f":"($AB$12*12)*('Production Assumptions'!$C$6)^AI2","v":{"$error":"#VALUE!"}}]
[null,"Packaging",{"$error":"#VALUE!"},0,0,0,0,0,{"$f":"'Production Assumptions'!H11","v":{"$error":"#VALUE!"}},{"$f":"I13","v":{"$error":"#VALUE!"}},{"$f":"J13","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(Q13:AB13)","v":{"$error":"#VALUE!"}},{"$f":"$O$13*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$13*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$13*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$13*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$13*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$13*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$13*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$13*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$13*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$13*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$13*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$13*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"($AB$13*('Production Assumptions'!$C$6)^AB2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$13*('Production Assumptions'!$C$6)^AC2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$13*('Production Assumptions'!$C$6)^AD2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$13*('Production Assumptions'!$C$6)^AE2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$13*('Production Assumptions'!$C$6)^AF2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$13*('Production Assumptions'!$C$6)^AG2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$13*('Production Assumptions'!$C$6)^AH2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$13*('Production Assumptions'!$C$6)^AI2)*12","v":{"$error":"#VALUE!"}}]
[null,"Chemicals",{"$error":"#VALUE!"},{"$f":"'Production Assumptions'!H13","v":{"$error":"#VALUE!"}},{"$f":"D14","v":{"$error":"#VALUE!"}},{"$f":"E14","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(Q14:AB14)","v":{"$error":"#VALUE!"}},{"$f":"$O$14*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"Q14","v":{"$error":"#VALUE!"}},{"$f":"R14","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"($AB$14*('Production Assumptions'!$C$6)^AB2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$14*('Production Assumptions'!$C$6)^AC2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$14*('Production Assumptions'!$C$6)^AD2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$14*('Production Assumptions'!$C$6)^AE2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$14*('Production Assumptions'!$C$6)^AF2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$14*('Production Assumptions'!$C$6)^AG2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$14*('Production Assumptions'!$C$6)^AH2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$14*('Production Assumptions'!$C$6)^AI2)*12","v":{"$error":"#VALUE!"}}]
[null,"Consumables",{"$error":"#VALUE!"},{"$f":"'Production Assumptions'!H14","v":{"$error":"#VALUE!"}},{"$f":"D15","v":{"$error":"#VALUE!"}},{"$f":"E15","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(Q15:AB15)","v":{"$error":"#VALUE!"}},{"$f":"$O$15*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"Q15","v":{"$error":"#VALUE!"}},{"$f":"R15","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"($AB$15*('Production Assumptions'!$C$6)^AB2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$15*('Production Assumptions'!$C$6)^AC2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$15*('Production Assumptions'!$C$6)^AD2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$15*('Production Assumptions'!$C$6)^AE2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$15*('Production Assumptions'!$C$6)^AF2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$15*('Production Assumptions'!$C$6)^AG2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$15*('Production Assumptions'!$C$6)^AH2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$15*('Production Assumptions'!$C$6)^AI2)*12","v":{"$error":"#VALUE!"}}]
[null,"TOTAL VARIABLE COST:",{"$f":"SUM(C10:C15)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D10:D15)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E10:E15)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(Q10:Q15)","v":{"$error":"#VALUE!"}},{"$f":"SUM(R10:R15)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"FIXED COSTS:"]
[null,"Salaries - Staff",{"$f":"SUM(D19:O19)","v":180000},{"$f":"HR!E9","v":15000},{"$f":"HR!F9","v":15000},{"$f":"HR!G9","v":15000},{"$f":"HR!H9","v":15000},{"$f":"HR!I9","v":15000},{"$f":"HR!J9","v":15000},{"$f":"HR!K9","v":15000},{"$f":"HR!L9","v":15000},{"$f":"HR!M9","v":15000},{"$f":"HR!N9","v":15000},{"$f":"HR!O9","v":15000},{"$f":"HR!P9","v":15000},{"$f":"SUM(Q19:AB19)","v":189180},{"$f":"HR!R9","v":15765},{"$f":"HR!S9","v":15765},{"$f":"HR!T9","v":15765},{"$f":"HR!U9","v":15765},{"$f":"HR!V9","v":15765},{"$f":"HR!W9","v":15765},{"$f":"HR!X9","v":15765},{"$f":"HR!Y9","v":15765},{"$f":"HR!Z9","v":15765},{"$f":"HR!AA9","v":15765},{"$f":"HR!AB9","v":15765},{"$f":"HR!AC9","v":15765},{"$f":"($AB$19*('Production Assumptions'!$C$6)^AB2)*12","v":198828.18},{"$f":"($AB$19*('Production Assumptions'!$C$6)^AC2)*12","v":208968.41717999999},{"$f":"($AB$19*('Production Assumptions'!$C$6)^AD2)*12","v":219625.80645618},{"$f":"($AB$19*('Production Assumptions'!$C$6)^AE2)*12","v":230826.72258544515},{"$f":"($AB$19*('Production Assumptions'!$C$6)^AF2)*12","v":242598.88543730287},{"$f":"($AB$19*('Production Assumptions'!$C$6)^AG2)*12","v":254971.4285946053},{"$f":"($AB$19*('Production Assumptions'!$C$6)^AH2)*12","v":267974.97145293019},{"$f":"($AB$19*('Production Assumptions'!$C$6)^AI2)*12","v":281641.69499702961}]
[null,"Telephone Expenses",{"$f":"SUM(D20:O20)","v":12000},{"$f":"'Production Assumptions'!$C$58","v":1000},{"$f":"'Production Assumptions'!$C$58","v":1000},{"$f":"'Production Assumptions'!$C$58","v":1000},{"$f":"'Production Assumptions'!$C$58","v":1000},{"$f":"'Production Assumptions'!$C$58","v":1000},{"$f":"'Production Assumptions'!$C$58","v":1000},{"$f":"'Production Assumptions'!$C$58","v":1000},{"$f":"'Production Assumptions'!$C$58","v":1000},{"$f":"'Production Assumptions'!$C$58","v":1000},{"$f":"'Production Assumptions'!$C$58","v":1000},{"$f":"'Production Assumptions'!$C$58","v":1000},{"$f":"'Production Assumptions'!$C$58","v":1000},{"$f":"SUM(Q20:AB20)","v":12612},{"$f":"$O$20*('Production Assumptions'!$C$6)","v":1051},{"$f":"$O$20*('Production Assumptions'!$C$6)","v":1051},{"$f":"$O$20*('Production Assumptions'!$C$6)","v":1051},{"$f":"$O$20*('Production Assumptions'!$C$6)","v":1051},{"$f":"$O$20*('Production Assumptions'!$C$6)","v":1051},{"$f":"$O$20*('Production Assumptions'!$C$6)","v":1051},{"$f":"$O$20*('Production Assumptions'!$C$6)","v":1051},{"$f":"$O$20*('Production Assumptions'!$C$6)","v":1051},{"$f":"$O$20*('Production Assumptions'!$C$6)","v":1051},{"$f":"$O$20*('Production Assumptions'!$C$6)","v":1051},{"$f":"$O$20*('Production Assumptions'!$C$6)","v":1051},{"$f":"$O$20*('Production Assumptions'!$C$6)","v":1051},{"$f":"($AB$20*('Production Assumptions'!$C$6))*12","v":13255.212},{"$f":"($AB$20*('Production Assumptions'!$C$6)^AC2)*12","v":13931.227812000001},{"$f":"($AB$20*('Production Assumptions'!$C$6)^AD2)*12","v":14641.720430412},{"$f":"($AB$20*('Production Assumptions'!$C$6)^AE2)*12","v":15388.448172363012},{"$f":"($AB$20*('Production Assumptions'!$C$6)^AF2)*12","v":16173.259029153523},{"$f":"($AB$20*('Production Assumptions'!$C$6)^AG2)*12","v":16998.095239640352},{"$f":"($AB$20*('Production Assumptions'!$C$6)^AH2)*12","v":17864.998096862011},{"$f":"($AB$20*('Production Assumptions'!$C$6)^AI2)*12","v":18776.112999801975}]
[null,"Electricity",25506,{"$f":"'Production Assumptions'!D31","v":2125.5},{"$f":"D21","v":2125.5},{"$f":"E21","v":2125.5},2125.5,2125.5,2125.5,2125.5,2125.5,2125.5,2125.5,2125.5,2125.5,26806.805999999997,{"$f":"$O$21*('Production Assumptions'!$C$6)","v":2233.9004999999997},{"$f":"$O$21*('Production Assumptions'!$C$6)","v":2233.9004999999997},{"$f":"$O$21*('Production Assumptions'!$C$6)","v":2233.9004999999997},{"$f":"$O$21*('Production Assumptions'!$C$6)","v":2233.9004999999997},{"$f":"$O$21*('Production Assumptions'!$C$6)","v":2233.9004999999997},{"$f":"$O$21*('Production Assumptions'!$C$6)","v":2233.9004999999997},{"$f":"$O$21*('Production Assumptions'!$C$6)","v":2233.9004999999997},{"$f":"$O$21*('Production Assumptions'!$C$6)","v":2233.9004999999997},{"$f":"$O$21*('Production Assumptions'!$C$6)","v":2233.9004999999997},{"$f":"$O$21*('Production Assumptions'!$C$6)","v":2233.9004999999997},{"$f":"$O$21*('Production Assumptions'!$C$6)","v":2233.9004999999997},{"$f":"$O$21*('Production Assumptions'!$C$6)","v":2233.9004999999997},{"$f":"($AB$21*('Production Assumptions'!$C$6))*12","v":28173.953105999994},{"$f":"($AB$21*('Production Assumptions'!$C$6)^AC2)*12","v":29610.824714405993},{"$f":"($AB$21*('Production Assumptions'!$C$6)^AD2)*12","v":31120.976774840699},{"$f":"($AB$21*('Production Assumptions'!$C$6)^AE2)*12","v":32708.146590357577},{"$f":"($AB$21*('Production Assumptions'!$C$6)^AF2)*12","v":34376.26206646581},{"$f":"($AB$21*('Production Assumptions'!$C$6)^AG2)*12","v":36129.451431855567},{"$f":"($AB$21*('Production Assumptions'!$C$6)^AH2)*12","v":37972.053454880202},{"$f":"($AB$21*('Production Assumptions'!$C$6)^AI2)*12","v":39908.62818107909}]
[null,"Legal & licencing",4500,{"$f":"'Production Assumptions'!H4","v":4500},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"E22*('Production Assumptions'!$C$6)","v":0},{"$f":"F22*('Production Assumptions'!$C$6)","v":0},{"$f":"G22*('Production Assumptions'!$C$6)","v":0},{"$f":"H22*('Production Assumptions'!$C$6)","v":0},{"$f":"I22*('Production Assumptions'!$C$6)","v":0},{"$f":"J22*('Production Assumptions'!$C$6)","v":0},{"$f":"K22*('Production Assumptions'!$C$6)","v":0},{"$f":"L22*('Production Assumptions'!$C$6)","v":0},{"$f":"M22*('Production Assumptions'!$C$6)","v":0},{"$f":"N22*('Production Assumptions'!$C$6)","v":0},{"$f":"O22*('Production Assumptions'!$C$6)","v":0},{"$f":"$Q$22*('Production Assumptions'!$C$6)","v":0},{"$f":"$Q$22*('Production Assumptions'!$C$6)^AC2","v":0},{"$f":"$D$22*('Production Assumptions'!$C$6)^AE2","v":5490.6451614045},{"$f":"$Q$22*('Production Assumptions'!$C$6)^AE2","v":0},{"$f":"$Q$22*('Production Assumptions'!$C$6)^AF2","v":0},{"$f":"$Q$22*('Production Assumptions'!$C$6)^AG2","v":0},{"$f":"$Q$22*('Production Assumptions'!$C$6)^AH2","v":0},{"$f":"$Q$22*('Production Assumptions'!$C$6)^AI2","v":0}]
[null,"Health and safety apparel",2000,{"$f":"'Production Assumptions'!$C$60*HR!$D$21","v":2000},0,0,0,0,0,0,0,0,0,0,0,2102,{"$f":"D23*('Production Assumptions'!$C$6)","v":2102},{"$f":"E23*('Production Assumptions'!$C$6)","v":0},{"$f":"F23*('Production Assumptions'!$C$6)","v":0},{"$f":"G23*('Production Assumptions'!$C$6)","v":0},{"$f":"H23*('Production Assumptions'!$C$6)","v":0},{"$f":"I23*('Production Assumptions'!$C$6)","v":0},{"$f":"J23*('Production Assumptions'!$C$6)","v":0},{"$f":"K23*('Production Assumptions'!$C$6)","v":0},{"$f":"L23*('Production Assumptions'!$C$6)","v":0},{"$f":"M23*('Production Assumptions'!$C$6)","v":0},{"$f":"N23*('Production Assumptions'!$C$6)","v":0},{"$f":"O23*('Production Assumptions'!$C$6)","v":0},{"$f":"$Q$23*('Production Assumptions'!$C$6)","v":2209.2019999999998},{"$f":"$Q$23*('Production Assumptions'!$C$6)^AC2","v":2321.871302},{"$f":"$Q$23*('Production Assumptions'!$C$6)^AD2","v":2440.2867384020001},{"$f":"$Q$23*('Production Assumptions'!$C$6)^AE2","v":2564.7413620605021},{"$f":"$Q$23*('Production Assumptions'!$C$6)^AF2","v":2695.5431715255872},{"$f":"$Q$23*('Production Assumptions'!$C$6)^AG2","v":2833.0158732733921},{"$f":"$Q$23*('Production Assumptions'!$C$6)^AH2","v":2977.4996828103353},{"$f":"$Q$23*('Production Assumptions'!$C$6)^AI2","v":3129.3521666336624}]
[null,"stationary",1200,{"$f":"IF(Interface!$J$7<9,0,'Production Assumptions'!$C$61)","v":100},{"$f":"IF(Interface!$J$7<9,0,'Production Assumptions'!$C$61)","v":100},{"$f":"IF(Interface!$J$7<9,0,'Production Assumptions'!$C$61)","v":100},{"$f":"IF(Interface!$J$7<9,0,'Production Assumptions'!$C$61)","v":100},{"$f":"IF(Interface!$J$7<9,0,'Production Assumptions'!$C$61)","v":100},{"$f":"IF(Interface!$J$7<9,0,'Production Assumptions'!$C$61)","v":100},{"$f":"IF(Interface!$J$7<9,0,'Production Assumptions'!$C$61)","v":100},{"$f":"IF(Interface!$J$7<9,0,'Production Assumptions'!$C$61)","v":100},{"$f":"IF(Interface!$J$7<9,0,'Production Assumptions'!$C$61)","v":100},{"$f":"IF(Interface!$J$7<9,0,'Production Assumptions'!$C$61)","v":100},{"$f":"IF(Interface!$J$7<9,0,'Production Assumptions'!$C$61)","v":100},{"$f":"IF(Interface!$J$7<9,0,'Production Assumptions'!$C$61)","v":100},1261.1999999999998,{"$f":"$O$24*('Production Assumptions'!$C$6)","v":105.1},{"$f":"$O$24*('Production Assumptions'!$C$6)","v":105.1},{"$f":"$O$24*('Production Assumptions'!$C$6)","v":105.1},{"$f":"$O$24*('Production Assumptions'!$C$6)","v":105.1},{"$f":"$O$24*('Production Assumptions'!$C$6)","v":105.1},{"$f":"$O$24*('Production Assumptions'!$C$6)","v":105.1},{"$f":"$O$24*('Production Assumptions'!$C$6)","v":105.1},{"$f":"$O$24*('Production Assumptions'!$C$6)","v":105.1},{"$f":"$O$24*('Production Assumptions'!$C$6)","v":105.1},{"$f":"$O$24*('Production Assumptions'!$C$6)","v":105.1},{"$f":"$O$24*('Production Assumptions'!$C$6)","v":105.1},{"$f":"$O$24*('Production Assumptions'!$C$6)","v":105.1},{"$f":"($AB$24*('Production Assumptions'!$C$6))*12","v":1325.5211999999997},{"$f":"($AB$24*('Production Assumptions'!$C$6)^AC2)*12","v":1393.1227812},{"$f":"($AB$24*('Production Assumptions'!$C$6)^AD2)*12","v":1464.1720430411999},{"$f":"($AB$24*('Production Assumptions'!$C$6)^AE2)*12","v":1538.844817236301},{"$f":"($AB$24*('Production Assumptions'!$C$6)^AF2)*12","v":1617.3259029153523},{"$f":"($AB$24*('Production Assumptions'!$C$6)^AG2)*12","v":1699.8095239640354},{"$f":"($AB$24*('Production Assumptions'!$C$6)^AH2)*12","v":1786.4998096862014},{"$f":"($AB$24*('Production Assumptions'!$C$6)^AI2)*12","v":1877.6112999801976}]
[null,"Cleaning materials",9600,{"$f":"'Production Assumptions'!$C$62","v":800},{"$f":"'Production Assumptions'!$C$62","v":800},{"$f":"'Production Assumptions'!$C$62","v":800},{"$f":"'Production Assumptions'!$C$62","v":800},{"$f":"'Production Assumptions'!$C$62","v":800},{"$f":"'Production Assumptions'!$C$62","v":800},{"$f":"'Production Assumptions'!$C$62","v":800},{"$f":"'Production Assumptions'!$C$62","v":800},{"$f":"'Production Assumptions'!$C$62","v":800},{"$f":"'Production Assumptions'!$C$62","v":800},{"$f":"'Production Assumptions'!$C$62","v":800},{"$f":"'Production Assumptions'!$C$62","v":800},10089.599999999999,{"$f":"$O$25*('Production Assumptions'!$C$6)","v":840.8},{"$f":"$O$25*('Production Assumptions'!$C$6)","v":840.8},{"$f":"$O$25*('Production Assumptions'!$C$6)","v":840.8},{"$f":"$O$25*('Production Assumptions'!$C$6)","v":840.8},{"$f":"$O$25*('Production Assumptions'!$C$6)","v":840.8},{"$f":"$O$25*('Production Assumptions'!$C$6)","v":840.8},{"$f":"$O$25*('Production Assumptions'!$C$6)","v":840.8},{"$f":"$O$25*('Production Assumptions'!$C$6)","v":840.8},{"$f":"$O$25*('Production Assumptions'!$C$6)","v":840.8},{"$f":"$O$25*('Production Assumptions'!$C$6)","v":840.8},{"$f":"$O$25*('Production Assumptions'!$C$6)","v":840.8},{"$f":"$O$25*('Production Assumptions'!$C$6)","v":840.8},{"$f":"($AB$25*('Production Assumptions'!$C$6))*12","v":10604.169599999997},{"$f":"($AB$25*('Production Assumptions'!$C$6)^AC2)*12","v":11144.9822496},{"$f":"($AB$25*('Production Assumptions'!$C$6)^AD2)*12","v":11713.376344329599},{"$f":"($AB$25*('Production Assumptions'!$C$6)^AE2)*12","v":12310.758537890408},{"$f":"($AB$25*('Production Assumptions'!$C$6)^AF2)*12","v":12938.607223322819},{"$f":"($AB$25*('Production Assumptions'!$C$6)^AG2)*12","v":13598.476191712283},{"$f":"($AB$25*('Production Assumptions'!$C$6)^AH2)*12","v":14291.998477489611},{"$f":"($AB$25*('Production Assumptions'!$C$6)^AI2)*12","v":15020.890399841581}]
[null,"Vet Services",20000,{"$f":"'Production Assumptions'!$C$63","v":5000},0,0,{"$f":"D26","v":5000},0,null,{"$f":"D26","v":5000},null,null,{"$f":"D26","v":5000},null,null,21020,{"$f":"D26*('Production Assumptions'!$C$6)","v":5255},{"$f":"E26*('Production Assumptions'!$C$6)","v":0},{"$f":"F26*('Production Assumptions'!$C$6)","v":0},{"$f":"G26*('Production Assumptions'!$C$6)","v":5255},{"$f":"H26*('Production Assumptions'!$C$6)","v":0},{"$f":"I26*('Production Assumptions'!$C$6)","v":0},{"$f":"J26*('Production Assumptions'!$C$6)","v":5255},{"$f":"K26*('Production Assumptions'!$C$6)","v":0},{"$f":"L26*('Production Assumptions'!$C$6)","v":0},{"$f":"M26*('Production Assumptions'!$C$6)","v":5255},{"$f":"N26*('Production Assumptions'!$C$6)","v":0},{"$f":"O26*('Production Assumptions'!$C$6)","v":0},{"$f":"($P$26*('Production Assumptions'!$C$6))","v":22092.019999999997},{"$f":"($P$26*('Production Assumptions'!$C$6)^AC2)","v":23218.713019999999},{"$f":"($P$26*('Production Assumptions'!$C$6)^AD2)","v":24402.867384019999},{"$f":"($P$26*('Production Assumptions'!$C$6)^AE2)","v":25647.413620605021},{"$f":"($P$26*('Production Assumptions'!$C$6)^AF2)","v":26955.431715255872},{"$f":"($P$26*('Production Assumptions'!$C$6)^AG2)","v":28330.158732733922},{"$f":"($P$26*('Production Assumptions'!$C$6)^AH2)","v":29774.996828103354},{"$f":"($P$26*('Production Assumptions'!$C$6)^AI2)","v":31293.521666336623}]
[null,"Bank Charges",{"$f":"SUM(D27:O27)","v":{"$error":"#VALUE!"}},{"$f":"IF(D$6=0,60,D$6/100*(1+'Production Assumptions'!$C$64)+60)","v":60},{"$f":"IF(E$6=0,60,E$6/100*(1+'Production Assumptions'!$C$64)+60)","v":60},{"$f":"IF(F$6=0,60,F$6/100*(1+'Production Assumptions'!$C$64)+60)","v":60},{"$f":"IF(G$6=0,60,G$6/100*(1+'Production Assumptions'!$C$64)+60)","v":60},{"$f":"IF(H$6=0,60,H$6/100*(1+'Production Assumptions'!$C$64)+60)","v":60},{"$f":"IF(I$6=0,60,I$6/100*(1+'Production Assumptions'!$C$64)+60)","v":{"$error":"#VALUE!"}},{"$f":"IF(J$6=0,60,J$6/100*(1+'Production Assumptions'!$C$64)+60)","v":{"$error":"#VALUE!"}},{"$f":"IF(K$6=0,60,K$6/100*(1+'Production Assumptions'!$C$64)+60)","v":{"$error":"#VALUE!"}},{"$f":"IF(L$6=0,60,L$6/100*(1+'Production Assumptions'!$C$64)+60)","v":{"$error":"#VALUE!"}},{"$f":"IF(M$6=0,60,M$6/100*(1+'Production Assumptions'!$C$64)+60)","v":{"$error":"#VALUE!"}},{"$f":"IF(N$6=0,60,N$6/100*(1+'Production Assumptions'!$C$64)+60)","v":{"$error":"#VALUE!"}},{"$f":"IF(O$6=0,60,O$6/100*(1+'Production Assumptions'!$C$64)+60)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(Q$6=0,60,Q$6/100*(1+'Production Assumptions'!$C$64)+60)*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$Q$27","v":{"$error":"#VALUE!"}},{"$f":"$Q$27","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"($AB27*('Production Assumptions'!$C$6))*12","v":{"$error":"#VALUE!"}},{"$f":"($AB27*('Production Assumptions'!$C$6)^AC2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB27*('Production Assumptions'!$C$6)^AD2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$27*('Production Assumptions'!$C$6)^AE2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$27*('Production Assumptions'!$C$6)^AF2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$27*('Production Assumptions'!$C$6)^AG2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$27*('Production Assumptions'!$C$6)^AH2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$27*('Production Assumptions'!$C$6)^AI2)*12","v":{"$error":"#VALUE!"}}]
[null,"Marketing",{"$error":"#VALUE!"},{"$f":"'Production Assumptions'!C65","v":{"$error":"#VALUE!"}},{"$f":"D28","v":{"$error":"#VALUE!"}},{"$f":"E28","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"O28*'Production Assumptions'!$C$6","v":{"$error":"#VALUE!"}},{"$f":"Q28","v":{"$error":"#VALUE!"}},{"$f":"R28","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"($AB28*('Production Assumptions'!$C$6))*12","v":{"$error":"#VALUE!"}},{"$f":"($AB28*('Production Assumptions'!$C$6)^AC2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB28*('Production Assumptions'!$C$6)^AD2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB28*('Production Assumptions'!$C$6)^AE2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB28*('Production Assumptions'!$C$6)^AF2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB28*('Production Assumptions'!$C$6)^AG2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB28*('Production Assumptions'!$C$6)^AH2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB28*('Production Assumptions'!$C$6)^AI2)*12","v":{"$error":"#VALUE!"}}]
[null,"Reserve & Unforeseen Cost",{"$error":"#VALUE!"},{"$f":"D$16*'Production Assumptions'!$C$67","v":{"$error":"#VALUE!"}},{"$f":"$D$29","v":{"$error":"#VALUE!"}},{"$f":"$D$29","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"$O$29*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$29*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$29*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$29*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$29*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$29*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$29*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$29*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$29*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$29*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$29*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"$O$29*('Production Assumptions'!$C$6)","v":{"$error":"#VALUE!"}},{"$f":"($AB$29*('Production Assumptions'!$C$6))*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$29*('Production Assumptions'!$C$6)^AC2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$29*('Production Assumptions'!$C$6)^AD2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$29*('Production Assumptions'!$C$6)^AE2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$29*('Production Assumptions'!$C$6)^AF2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$29*('Production Assumptions'!$C$6)^AG2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$29*('Production Assumptions'!$C$6)^AH2)*12","v":{"$error":"#VALUE!"}},{"$f":"($AB$29*('Production Assumptions'!$C$6)^AI2)*12","v":{"$error":"#VALUE!"}}]
[null,"TOTAL FIXED COST:",{"$f":"SUM(C19:C29)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"TOTAL EXPENSES:",{"$f":"C16+C30","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"PROFIT OR LOSS:",{"$f":"C7-C32","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC32/AC7","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"Working Capital - RAS","index":11,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[29,1,29,2],[0,0,0,25],[2,1,3,1]]}
["WORKING CAPITAL - RAS "]
[]
[null,"WORKING CAPITAL"]
[null,null,"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","TOTAL"]
[null,"VARIABLE COSTS:"]
[null,{"$f":"'OPEX - RAS'!B10","v":"Breeding Fish"},{"$f":"'OPEX - RAS'!D10","v":20000},{"$f":"'OPEX - RAS'!E10","v":0},{"$f":"'OPEX - RAS'!F10","v":0},{"$f":"'OPEX - RAS'!G10","v":0},{"$f":"'OPEX - RAS'!H10","v":0},{"$f":"'OPEX - RAS'!I10","v":0},{"$f":"IF(Interface!$E$18=Validation!$D$39,C6,IF(Interface!$E$18=Validation!$D$40,SUM(C6:D6),IF(Interface!$E$18=Validation!$D$41,SUM(C6:E6),IF(Interface!$E$18=Validation!$D$42,SUM(C6:F6),IF(Interface!$E$18=Validation!$D$43,SUM(C6:G6),IF(Interface!$E$18=Validation!$D$44,SUM(C6:H6),IF(Interface!$E$18=Validation!$D$45,SUM(C6:H6),IF(Interface!$E$18=Validation!$D$46,SUM(C6:H6),IF(Interface!$E$18=Validation!$D$47,SUM(C6:H6),)))))))))","v":20000}]
[null,{"$f":"'OPEX - RAS'!B11","v":"Feed"},{"$f":"'OPEX - RAS'!D11","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!E11","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!F11","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!G11","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!H11","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!I11","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$E$18=Validation!$D$39,C7,IF(Interface!$E$18=Validation!$D$40,SUM(C7:D7),IF(Interface!$E$18=Validation!$D$41,SUM(C7:E7),IF(Interface!$E$18=Validation!$D$42,SUM(C7:F7),IF(Interface!$E$18=Validation!$D$43,SUM(C7:G7),IF(Interface!$E$18=Validation!$D$44,SUM(C7:H7),IF(Interface!$E$18=Validation!$D$45,SUM(C7:H7),IF(Interface!$E$18=Validation!$D$46,SUM(C7:H7),IF(Interface!$E$18=Validation!$D$47,SUM(C7:H7),)))))))))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'OPEX - RAS'!B12","v":"Freight (per 100 fish)"},{"$f":"'OPEX - RAS'!D12","v":300},{"$f":"'OPEX - RAS'!E12","v":300},{"$f":"'OPEX - RAS'!F12","v":300},{"$f":"'OPEX - RAS'!G12","v":300},{"$f":"'OPEX - RAS'!H12","v":300},{"$f":"'OPEX - RAS'!I12","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$E$18=Validation!$D$39,C8,IF(Interface!$E$18=Validation!$D$40,SUM(C8:D8),IF(Interface!$E$18=Validation!$D$41,SUM(C8:E8),IF(Interface!$E$18=Validation!$D$42,SUM(C8:F8),IF(Interface!$E$18=Validation!$D$43,SUM(C8:G8),IF(Interface!$E$18=Validation!$D$44,SUM(C8:H8),IF(Interface!$E$18=Validation!$D$45,SUM(C8:H8),IF(Interface!$E$18=Validation!$D$46,SUM(C8:H8),IF(Interface!$E$18=Validation!$D$47,SUM(C8:H8),)))))))))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'OPEX - RAS'!B13","v":"Packaging"},{"$f":"'OPEX - RAS'!D13","v":0},{"$f":"'OPEX - RAS'!E13","v":0},{"$f":"'OPEX - RAS'!F13","v":0},{"$f":"'OPEX - RAS'!G13","v":0},{"$f":"'OPEX - RAS'!H13","v":0},{"$f":"'OPEX - RAS'!I13","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$E$18=Validation!$D$39,C9,IF(Interface!$E$18=Validation!$D$40,SUM(C9:D9),IF(Interface!$E$18=Validation!$D$41,SUM(C9:E9),IF(Interface!$E$18=Validation!$D$42,SUM(C9:F9),IF(Interface!$E$18=Validation!$D$43,SUM(C9:G9),IF(Interface!$E$18=Validation!$D$44,SUM(C9:H9),IF(Interface!$E$18=Validation!$D$45,SUM(C9:H9),IF(Interface!$E$18=Validation!$D$46,SUM(C9:H9),IF(Interface!$E$18=Validation!$D$47,SUM(C9:H9),)))))))))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'OPEX - RAS'!B14","v":"Chemicals"},{"$f":"'OPEX - RAS'!D14","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!E14","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!F14","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!G14","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!H14","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!I14","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$E$18=Validation!$D$39,C10,IF(Interface!$E$18=Validation!$D$40,SUM(C10:D10),IF(Interface!$E$18=Validation!$D$41,SUM(C10:E10),IF(Interface!$E$18=Validation!$D$42,SUM(C10:F10),IF(Interface!$E$18=Validation!$D$43,SUM(C10:G10),IF(Interface!$E$18=Validation!$D$44,SUM(C10:H10),IF(Interface!$E$18=Validation!$D$45,SUM(C10:H10),IF(Interface!$E$18=Validation!$D$46,SUM(C10:H10),IF(Interface!$E$18=Validation!$D$47,SUM(C10:H10),)))))))))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'OPEX - RAS'!B15","v":"Consumables"},{"$f":"'OPEX - RAS'!D15","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!E15","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!F15","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!G15","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!H15","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!I15","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$E$18=Validation!$D$39,C11,IF(Interface!$E$18=Validation!$D$40,SUM(C11:D11),IF(Interface!$E$18=Validation!$D$41,SUM(C11:E11),IF(Interface!$E$18=Validation!$D$42,SUM(C11:F11),IF(Interface!$E$18=Validation!$D$43,SUM(C11:G11),IF(Interface!$E$18=Validation!$D$44,SUM(C11:H11),IF(Interface!$E$18=Validation!$D$45,SUM(C11:H11),IF(Interface!$E$18=Validation!$D$46,SUM(C11:H11),IF(Interface!$E$18=Validation!$D$47,SUM(C11:H11),)))))))))","v":{"$error":"#VALUE!"}}]
[null,"TOTAL VARIABLE COST:",{"$f":"SUM(C6:C11)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D6:D11)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"FIXED COSTS:"]
[null,{"$f":"'OPEX - RAS'!B19","v":"Salaries - Staff"},{"$f":"'OPEX - RAS'!D19","v":15000},{"$f":"'OPEX - RAS'!E19","v":15000},{"$f":"'OPEX - RAS'!F19","v":15000},{"$f":"'OPEX - RAS'!G19","v":15000},{"$f":"'OPEX - RAS'!H19","v":15000},{"$f":"'OPEX - RAS'!I19","v":15000},{"$f":"IF(Interface!$E$18=Validation!$D$39,C15,IF(Interface!$E$18=Validation!$D$40,SUM(C15:D15),IF(Interface!$E$18=Validation!$D$41,SUM(C15:E15),IF(Interface!$E$18=Validation!$D$42,SUM(C15:F15),IF(Interface!$E$18=Validation!$D$43,SUM(C15:G15),IF(Interface!$E$18=Validation!$D$44,SUM(C15:H15),IF(Interface!$E$18=Validation!$D$45,SUM(C15:H15),IF(Interface!$E$18=Validation!$D$46,SUM(C15:H15),IF(Interface!$E$18=Validation!$D$47,SUM(C15:H15),)))))))))","v":90000}]
[null,{"$f":"'OPEX - RAS'!B20","v":"Telephone Expenses"},{"$f":"'OPEX - RAS'!D20","v":1000},{"$f":"'OPEX - RAS'!E20","v":1000},{"$f":"'OPEX - RAS'!F20","v":1000},{"$f":"'OPEX - RAS'!G20","v":1000},{"$f":"'OPEX - RAS'!H20","v":1000},{"$f":"'OPEX - RAS'!I20","v":1000},{"$f":"IF(Interface!$E$18=Validation!$D$39,C16,IF(Interface!$E$18=Validation!$D$40,SUM(C16:D16),IF(Interface!$E$18=Validation!$D$41,SUM(C16:E16),IF(Interface!$E$18=Validation!$D$42,SUM(C16:F16),IF(Interface!$E$18=Validation!$D$43,SUM(C16:G16),IF(Interface!$E$18=Validation!$D$44,SUM(C16:H16),IF(Interface!$E$18=Validation!$D$45,SUM(C16:H16),IF(Interface!$E$18=Validation!$D$46,SUM(C16:H16),IF(Interface!$E$18=Validation!$D$47,SUM(C16:H16),)))))))))","v":6000}]
[null,{"$f":"'OPEX - RAS'!B21","v":"Electricity"},{"$f":"'OPEX - RAS'!D21","v":2125.5},{"$f":"'OPEX - RAS'!E21","v":2125.5},{"$f":"'OPEX - RAS'!F21","v":2125.5},{"$f":"'OPEX - RAS'!G21","v":2125.5},{"$f":"'OPEX - RAS'!H21","v":2125.5},{"$f":"'OPEX - RAS'!I21","v":2125.5},{"$f":"IF(Interface!$E$18=Validation!$D$39,C17,IF(Interface!$E$18=Validation!$D$40,SUM(C17:D17),IF(Interface!$E$18=Validation!$D$41,SUM(C17:E17),IF(Interface!$E$18=Validation!$D$42,SUM(C17:F17),IF(Interface!$E$18=Validation!$D$43,SUM(C17:G17),IF(Interface!$E$18=Validation!$D$44,SUM(C17:H17),IF(Interface!$E$18=Validation!$D$45,SUM(C17:H17),IF(Interface!$E$18=Validation!$D$46,SUM(C17:H17),IF(Interface!$E$18=Validation!$D$47,SUM(C17:H17),)))))))))","v":12753}]
[null,{"$f":"'OPEX - RAS'!B22","v":"Legal & licencing"},{"$f":"'OPEX - RAS'!D22","v":4500},{"$f":"'OPEX - RAS'!E22","v":0},{"$f":"'OPEX - RAS'!F22","v":0},{"$f":"'OPEX - RAS'!G22","v":0},{"$f":"'OPEX - RAS'!H22","v":0},{"$f":"'OPEX - RAS'!I22","v":0},{"$f":"IF(Interface!$E$18=Validation!$D$39,C18,IF(Interface!$E$18=Validation!$D$40,SUM(C18:D18),IF(Interface!$E$18=Validation!$D$41,SUM(C18:E18),IF(Interface!$E$18=Validation!$D$42,SUM(C18:F18),IF(Interface!$E$18=Validation!$D$43,SUM(C18:G18),IF(Interface!$E$18=Validation!$D$44,SUM(C18:H18),IF(Interface!$E$18=Validation!$D$45,SUM(C18:H18),IF(Interface!$E$18=Validation!$D$46,SUM(C18:H18),IF(Interface!$E$18=Validation!$D$47,SUM(C18:H18),)))))))))","v":4500}]
[null,{"$f":"'OPEX - RAS'!B23","v":"Health and safety apparel"},{"$f":"'OPEX - RAS'!D23","v":2000},{"$f":"'OPEX - RAS'!E23","v":0},{"$f":"'OPEX - RAS'!F23","v":0},{"$f":"'OPEX - RAS'!G23","v":0},{"$f":"'OPEX - RAS'!H23","v":0},{"$f":"'OPEX - RAS'!I23","v":0},{"$f":"IF(Interface!$E$18=Validation!$D$39,C19,IF(Interface!$E$18=Validation!$D$40,SUM(C19:D19),IF(Interface!$E$18=Validation!$D$41,SUM(C19:E19),IF(Interface!$E$18=Validation!$D$42,SUM(C19:F19),IF(Interface!$E$18=Validation!$D$43,SUM(C19:G19),IF(Interface!$E$18=Validation!$D$44,SUM(C19:H19),IF(Interface!$E$18=Validation!$D$45,SUM(C19:H19),IF(Interface!$E$18=Validation!$D$46,SUM(C19:H19),IF(Interface!$E$18=Validation!$D$47,SUM(C19:H19),)))))))))","v":2000}]
[null,{"$f":"'OPEX - RAS'!B24","v":"stationary"},{"$f":"'OPEX - RAS'!D24","v":100},{"$f":"'OPEX - RAS'!E24","v":100},{"$f":"'OPEX - RAS'!F24","v":100},{"$f":"'OPEX - RAS'!G24","v":100},{"$f":"'OPEX - RAS'!H24","v":100},{"$f":"'OPEX - RAS'!I24","v":100},{"$f":"IF(Interface!$E$18=Validation!$D$39,C20,IF(Interface!$E$18=Validation!$D$40,SUM(C20:D20),IF(Interface!$E$18=Validation!$D$41,SUM(C20:E20),IF(Interface!$E$18=Validation!$D$42,SUM(C20:F20),IF(Interface!$E$18=Validation!$D$43,SUM(C20:G20),IF(Interface!$E$18=Validation!$D$44,SUM(C20:H20),IF(Interface!$E$18=Validation!$D$45,SUM(C20:H20),IF(Interface!$E$18=Validation!$D$46,SUM(C20:H20),IF(Interface!$E$18=Validation!$D$47,SUM(C20:H20),)))))))))","v":600}]
[null,{"$f":"'OPEX - RAS'!B25","v":"Cleaning materials"},{"$f":"'OPEX - RAS'!D25","v":800},{"$f":"'OPEX - RAS'!E25","v":800},{"$f":"'OPEX - RAS'!F25","v":800},{"$f":"'OPEX - RAS'!G25","v":800},{"$f":"'OPEX - RAS'!H25","v":800},{"$f":"'OPEX - RAS'!I25","v":800},{"$f":"IF(Interface!$E$18=Validation!$D$39,C21,IF(Interface!$E$18=Validation!$D$40,SUM(C21:D21),IF(Interface!$E$18=Validation!$D$41,SUM(C21:E21),IF(Interface!$E$18=Validation!$D$42,SUM(C21:F21),IF(Interface!$E$18=Validation!$D$43,SUM(C21:G21),IF(Interface!$E$18=Validation!$D$44,SUM(C21:H21),IF(Interface!$E$18=Validation!$D$45,SUM(C21:H21),IF(Interface!$E$18=Validation!$D$46,SUM(C21:H21),IF(Interface!$E$18=Validation!$D$47,SUM(C21:H21),)))))))))","v":4800}]
[null,{"$f":"'OPEX - RAS'!B26","v":"Vet Services"},{"$f":"'OPEX - RAS'!D26","v":5000},{"$f":"'OPEX - RAS'!E26","v":0},{"$f":"'OPEX - RAS'!F26","v":0},{"$f":"'OPEX - RAS'!G26","v":5000},{"$f":"'OPEX - RAS'!H26","v":0},{"$f":"'OPEX - RAS'!I26","v":0},{"$f":"IF(Interface!$E$18=Validation!$D$39,C22,IF(Interface!$E$18=Validation!$D$40,SUM(C22:D22),IF(Interface!$E$18=Validation!$D$41,SUM(C22:E22),IF(Interface!$E$18=Validation!$D$42,SUM(C22:F22),IF(Interface!$E$18=Validation!$D$43,SUM(C22:G22),IF(Interface!$E$18=Validation!$D$44,SUM(C22:H22),IF(Interface!$E$18=Validation!$D$45,SUM(C22:H22),IF(Interface!$E$18=Validation!$D$46,SUM(C22:H22),IF(Interface!$E$18=Validation!$D$47,SUM(C22:H22),)))))))))","v":10000}]
[null,{"$f":"'OPEX - RAS'!B27","v":"Bank Charges"},{"$f":"'OPEX - RAS'!D27","v":60},{"$f":"'OPEX - RAS'!E27","v":60},{"$f":"'OPEX - RAS'!F27","v":60},{"$f":"'OPEX - RAS'!G27","v":60},{"$f":"'OPEX - RAS'!H27","v":60},{"$f":"'OPEX - RAS'!I27","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$E$18=Validation!$D$39,C23,IF(Interface!$E$18=Validation!$D$40,SUM(C23:D23),IF(Interface!$E$18=Validation!$D$41,SUM(C23:E23),IF(Interface!$E$18=Validation!$D$42,SUM(C23:F23),IF(Interface!$E$18=Validation!$D$43,SUM(C23:G23),IF(Interface!$E$18=Validation!$D$44,SUM(C23:H23),IF(Interface!$E$18=Validation!$D$45,SUM(C23:H23),IF(Interface!$E$18=Validation!$D$46,SUM(C23:H23),IF(Interface!$E$18=Validation!$D$47,SUM(C23:H23),)))))))))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'OPEX - RAS'!B28","v":"Marketing"},{"$f":"'OPEX - RAS'!D28","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!E28","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!F28","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!G28","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!H28","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!I28","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$E$18=Validation!$D$39,C24,IF(Interface!$E$18=Validation!$D$40,SUM(C24:D24),IF(Interface!$E$18=Validation!$D$41,SUM(C24:E24),IF(Interface!$E$18=Validation!$D$42,SUM(C24:F24),IF(Interface!$E$18=Validation!$D$43,SUM(C24:G24),IF(Interface!$E$18=Validation!$D$44,SUM(C24:H24),IF(Interface!$E$18=Validation!$D$45,SUM(C24:H24),IF(Interface!$E$18=Validation!$D$46,SUM(C24:H24),IF(Interface!$E$18=Validation!$D$47,SUM(C24:H24),)))))))))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'OPEX - RAS'!B29","v":"Reserve & Unforeseen Cost"},{"$f":"'OPEX - RAS'!D29","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!E29","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!F29","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!G29","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!H29","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!I29","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$E$18=Validation!$D$39,C25,IF(Interface!$E$18=Validation!$D$40,SUM(C25:D25),IF(Interface!$E$18=Validation!$D$41,SUM(C25:E25),IF(Interface!$E$18=Validation!$D$42,SUM(C25:F25),IF(Interface!$E$18=Validation!$D$43,SUM(C25:G25),IF(Interface!$E$18=Validation!$D$44,SUM(C25:H25),IF(Interface!$E$18=Validation!$D$45,SUM(C25:H25),IF(Interface!$E$18=Validation!$D$46,SUM(C25:H25),IF(Interface!$E$18=Validation!$D$47,SUM(C25:H25),)))))))))","v":{"$error":"#VALUE!"}}]
[null,"TOTAL FIXED COST:",{"$f":"SUM(C15:C25)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"TOTAL EXPENSES:",{"$f":"SUM(C26,C12)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"TOTAL WORKING CAPITAL FOR 6 MONTHS"]
[null,"Items","Cost"]
[null,"Variable",{"$f":"I12","v":{"$error":"#VALUE!"}}]
[null,"Fixed cost",{"$f":"I26","v":{"$error":"#VALUE!"}}]
[null,"Total",{"$f":"SUM(C32:C33)","v":{"$error":"#VALUE!"}}]

{"sheet":"IS - RAS","index":12,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,16383],[2,1,3,1],[2,2,2,12]]}
["INCOME STATEMENT - RAS"]
[]
[null,"Projected Income Statement","Year"]
[null,null,"YEAR 0","YEAR 1","YEAR 2","YEAR 3","YEAR 4","YEAR 5","YEAR 6","YEAR 7","YEAR 8","YEAR 9","YEAR 10","NO POSITIVE"]
[null,"Revenue"]
[null,{"$f":"'OPEX - RAS'!B6","v":"Marine Ornamentals (Selling stock)"},null,{"$f":"'OPEX - RAS'!C7","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!P7","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!AC7","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!AD7","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!AE7","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!AF7","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!AG7","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!AH7","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!AI7","v":{"$error":"#VALUE!"}},{"$f":"'OPEX - RAS'!AJ7","v":{"$error":"#VALUE!"}}]
[null,"Total Revenue",null,{"$f":"SUM(D6:D6)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"Variable Costs (Cost of Sales)"]
[null,{"$f":"'OPEX - RAS'!B10","v":"Breeding Fish"},null,{"$f":"-'OPEX - RAS'!C10","v":-20000},{"$f":"-'OPEX - RAS'!P10","v":0},{"$f":"-'OPEX - RAS'!AC10","v":0},{"$f":"-'OPEX - RAS'!AD10","v":-23218.713019999996},{"$f":"-'OPEX - RAS'!AE10","v":0},{"$f":"-'OPEX - RAS'!AF10","v":0},{"$f":"-'OPEX - RAS'!AG10","v":-26955.431715255869},{"$f":"-'OPEX - RAS'!AH10","v":0},{"$f":"-'OPEX - RAS'!AI10","v":0},{"$f":"-'OPEX - RAS'!AJ10","v":-31293.521666336612}]
[null,{"$f":"'OPEX - RAS'!B11","v":"Feed"},null,{"$f":"-'OPEX - RAS'!C11","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!P11","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AC11","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AD11","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AE11","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AF11","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AG11","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AH11","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AI11","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AJ11","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'OPEX - RAS'!B12","v":"Freight (per 100 fish)"},null,{"$f":"-'OPEX - RAS'!C12","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!P12","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AC12","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AD12","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AE12","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AF12","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AG12","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AH12","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AI12","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AJ12","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'OPEX - RAS'!B13","v":"Packaging"},null,{"$f":"-'OPEX - RAS'!C13","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!P13","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AC13","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AD13","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AE13","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AF13","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AG13","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AH13","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AI13","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AJ13","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'OPEX - RAS'!B14","v":"Chemicals"},null,{"$f":"-'OPEX - RAS'!C14","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!P14","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AC14","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AD14","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AE14","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AF14","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AG14","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AH14","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AI14","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AJ14","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'OPEX - RAS'!B15","v":"Consumables"},null,{"$f":"-'OPEX - RAS'!C15","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!P15","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AC15","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AD15","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AE15","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AF15","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AG15","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AH15","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AI15","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AJ15","v":{"$error":"#VALUE!"}}]
[null,"Total Variable Costs (Cost of Sales)",null,{"$f":"SUM(D10:D15)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E10:E15)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"Gross Profit",null,{"$f":"D7+D16","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Gross Profit %",null,{"$f":"D18/D7","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"Fixed Costs"]
[null,"Salaries and wages",null,{"$f":"-SUM(D23:D24)","v":-180000},-189180,-198828.18,-208968.41717999999,-219625.80645618,-230826.72258544518,-242598.88543730287,-254971.4285946053,-267974.97145293019,-281641.69499702961]
[null,{"$f":"HR!B7","v":"Owner"},null,{"$f":"HR!D7","v":0},{"$f":"HR!AD7","v":0},{"$f":"HR!AF7","v":0},{"$f":"HR!AH7","v":0},{"$f":"HR!AJ7","v":0},{"$f":"HR!AL7","v":0},{"$f":"HR!AN7","v":0},{"$f":"HR!AP7","v":0},{"$f":"HR!AR7","v":0},{"$f":"HR!AT7","v":0}]
[null,{"$f":"HR!B8","v":"Low Skilled"},null,{"$f":"HR!D8","v":180000},{"$f":"HR!AD8","v":189180},{"$f":"HR!AF8","v":198828.18},{"$f":"HR!AH8","v":208968.41717999999},{"$f":"HR!AJ8","v":219625.80645618},{"$f":"HR!AL8","v":230826.72258544518},{"$f":"HR!AN8","v":242598.88543730287},{"$f":"HR!AP8","v":254971.4285946053},{"$f":"HR!AR8","v":267974.97145293019},{"$f":"HR!AT8","v":281641.69499702961}]
[null,"General Expenses",null,{"$f":"SUM(D26:D35)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"'OPEX - RAS'!B20","v":"Telephone Expenses"},null,{"$f":"-'OPEX - RAS'!C20","v":-12000},{"$f":"-'OPEX - RAS'!P20","v":-12612},{"$f":"-'OPEX - RAS'!AC20","v":-13255.212},{"$f":"-'OPEX - RAS'!AD20","v":-13931.227812000001},{"$f":"-'OPEX - RAS'!AE20","v":-14641.720430412},{"$f":"-'OPEX - RAS'!AF20","v":-15388.448172363012},{"$f":"-'OPEX - RAS'!AG20","v":-16173.259029153523},{"$f":"-'OPEX - RAS'!AH20","v":-16998.095239640352},{"$f":"-'OPEX - RAS'!AI20","v":-17864.998096862011},{"$f":"-'OPEX - RAS'!AJ20","v":-18776.112999801975}]
[null,{"$f":"'OPEX - RAS'!B21","v":"Electricity"},null,{"$f":"-'OPEX - RAS'!C21","v":-25506},{"$f":"-'OPEX - RAS'!P21","v":-26806.805999999997},{"$f":"-'OPEX - RAS'!AC21","v":-28173.953105999994},{"$f":"-'OPEX - RAS'!AD21","v":-29610.824714405993},{"$f":"-'OPEX - RAS'!AE21","v":-31120.976774840699},{"$f":"-'OPEX - RAS'!AF21","v":-32708.146590357577},{"$f":"-'OPEX - RAS'!AG21","v":-34376.26206646581},{"$f":"-'OPEX - RAS'!AH21","v":-36129.451431855567},{"$f":"-'OPEX - RAS'!AI21","v":-37972.053454880202},{"$f":"-'OPEX - RAS'!AJ21","v":-39908.62818107909}]
[null,{"$f":"'OPEX - RAS'!B22","v":"Legal & licencing"},null,{"$f":"-'OPEX - RAS'!C22","v":-4500},{"$f":"-'OPEX - RAS'!P22","v":0},{"$f":"-'OPEX - RAS'!AC22","v":0},{"$f":"-'OPEX - RAS'!AD22","v":0},{"$f":"-'OPEX - RAS'!AE22","v":-5490.6451614045},{"$f":"-'OPEX - RAS'!AF22","v":0},{"$f":"-'OPEX - RAS'!AG22","v":0},{"$f":"-'OPEX - RAS'!AH22","v":0},{"$f":"-'OPEX - RAS'!AI22","v":0},{"$f":"-'OPEX - RAS'!AJ22","v":0}]
[null,{"$f":"'OPEX - RAS'!B23","v":"Health and safety apparel"},null,{"$f":"-'OPEX - RAS'!C23","v":-2000},{"$f":"-'OPEX - RAS'!P23","v":-2102},{"$f":"-'OPEX - RAS'!AC23","v":-2209.2019999999998},{"$f":"-'OPEX - RAS'!AD23","v":-2321.871302},{"$f":"-'OPEX - RAS'!AE23","v":-2440.2867384020001},{"$f":"-'OPEX - RAS'!AF23","v":-2564.7413620605021},{"$f":"-'OPEX - RAS'!AG23","v":-2695.5431715255872},{"$f":"-'OPEX - RAS'!AH23","v":-2833.0158732733921},{"$f":"-'OPEX - RAS'!AI23","v":-2977.4996828103353},{"$f":"-'OPEX - RAS'!AJ23","v":-3129.3521666336624}]
[null,{"$f":"'OPEX - RAS'!B24","v":"stationary"},null,{"$f":"-'OPEX - RAS'!C24","v":-1200},{"$f":"-'OPEX - RAS'!P24","v":-1261.1999999999998},{"$f":"-'OPEX - RAS'!AC24","v":-1325.5211999999997},{"$f":"-'OPEX - RAS'!AD24","v":-1393.1227812},{"$f":"-'OPEX - RAS'!AE24","v":-1464.1720430411999},{"$f":"-'OPEX - RAS'!AF24","v":-1538.844817236301},{"$f":"-'OPEX - RAS'!AG24","v":-1617.3259029153523},{"$f":"-'OPEX - RAS'!AH24","v":-1699.8095239640354},{"$f":"-'OPEX - RAS'!AI24","v":-1786.4998096862014},{"$f":"-'OPEX - RAS'!AJ24","v":-1877.6112999801976}]
[null,{"$f":"'OPEX - RAS'!B25","v":"Cleaning materials"},null,{"$f":"-'OPEX - RAS'!C25","v":-9600},{"$f":"-'OPEX - RAS'!P25","v":-10089.599999999999},{"$f":"-'OPEX - RAS'!AC25","v":-10604.169599999997},{"$f":"-'OPEX - RAS'!AD25","v":-11144.9822496},{"$f":"-'OPEX - RAS'!AE25","v":-11713.376344329599},{"$f":"-'OPEX - RAS'!AF25","v":-12310.758537890408},{"$f":"-'OPEX - RAS'!AG25","v":-12938.607223322819},{"$f":"-'OPEX - RAS'!AH25","v":-13598.476191712283},{"$f":"-'OPEX - RAS'!AI25","v":-14291.998477489611},{"$f":"-'OPEX - RAS'!AJ25","v":-15020.890399841581}]
[null,{"$f":"'OPEX - RAS'!B26","v":"Vet Services"},null,{"$f":"-'OPEX - RAS'!C26","v":-20000},{"$f":"-'OPEX - RAS'!P26","v":-21020},{"$f":"-'OPEX - RAS'!AC26","v":-22092.019999999997},{"$f":"-'OPEX - RAS'!AD26","v":-23218.713019999999},{"$f":"-'OPEX - RAS'!AE26","v":-24402.867384019999},{"$f":"-'OPEX - RAS'!AF26","v":-25647.413620605021},{"$f":"-'OPEX - RAS'!AG26","v":-26955.431715255872},{"$f":"-'OPEX - RAS'!AH26","v":-28330.158732733922},{"$f":"-'OPEX - RAS'!AI26","v":-29774.996828103354},{"$f":"-'OPEX - RAS'!AJ26","v":-31293.521666336623}]
[null,{"$f":"'OPEX - RAS'!B27","v":"Bank Charges"},null,{"$f":"-'OPEX - RAS'!C27","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!P27","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AC27","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AD27","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AE27","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AF27","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AG27","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AH27","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AI27","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AJ27","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'OPEX - RAS'!B28","v":"Marketing"},null,{"$f":"-'OPEX - RAS'!C28","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!P28","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AC28","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AD28","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AE28","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AF28","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AG28","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AH28","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AI28","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AJ28","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'OPEX - RAS'!B29","v":"Reserve & Unforeseen Cost"},null,{"$f":"-'OPEX - RAS'!C29","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!P29","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AC29","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AD29","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AE29","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AF29","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AG29","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AH29","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AI29","v":{"$error":"#VALUE!"}},{"$f":"-'OPEX - RAS'!AJ29","v":{"$error":"#VALUE!"}}]
[null,"Total Fixed Costs",null,{"$f":"D25+D22","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"TOTAL COSTS",null,{"$f":"-(D16+D36)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Depreciation",null,{"$f":"-'DEP - RAS'!F27","v":{"$error":"#VALUE!"}},{"$f":"-'DEP - RAS'!G27","v":{"$error":"#VALUE!"}},{"$f":"-'DEP - RAS'!H27","v":{"$error":"#VALUE!"}},{"$f":"-'DEP - RAS'!I27","v":{"$error":"#VALUE!"}},{"$f":"-'DEP - RAS'!J27","v":{"$error":"#VALUE!"}},{"$f":"-'DEP - RAS'!K27","v":{"$error":"#VALUE!"}},{"$f":"-'DEP - RAS'!L27","v":{"$error":"#VALUE!"}},{"$f":"-'DEP - RAS'!M27","v":{"$error":"#VALUE!"}},{"$f":"-'DEP - RAS'!N27","v":{"$error":"#VALUE!"}},{"$f":"-'DEP - RAS'!O27","v":{"$error":"#VALUE!"}}]
[]
[null,"Profit / (Loss) before Interest & Tax",null,{"$f":"D16+D36+D38+D7","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"Interest",null,{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!B3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!B3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!C3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!C3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!D3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!D3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!E3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!E3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!F3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!F3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!G3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!G3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!H3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!H3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!I3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!I3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!J3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!J3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!K3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!K3,0))","v":0}]
[null,"Taxation",null,{"$f":"-IF((D40)*28%>0, (D40)*28%, 0)","v":{"$error":"#VALUE!"}},{"$f":"-IF((E40)*28%>0, (E40)*28%, 0)","v":{"$error":"#VALUE!"}},{"$f":"-IF((F40)*28%>0, (F40)*28%, 0)","v":{"$error":"#VALUE!"}},{"$f":"-IF((G40)*28%>0, (G40)*28%, 0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"Profit / (Loss) for the year",-1,{"$f":"D40+D43+D42","v":{"$error":"#VALUE!"}},{"$f":"E40+E43+E42","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},1]
[null,"Profit / (Loss) %",null,{"$f":"D45/D7","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"Breakeven",-1,{"$f":"D7-D37","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0]

{"sheet":"BS - RAS","index":13,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
["Projected Balance Sheet","Year"]
[null,"YEAR 1","YEAR 2","YEAR 3","YEAR 4","YEAR 5","YEAR 6","YEAR 7","YEAR 8","YEAR 9","YEAR 10"]
["Fixed Assets"]
["Net Property, Plant & Equipment",{"$f":"'CAPEX '!J31+'IS - RAS'!D38","v":{"$error":"#VALUE!"}},{"$f":"(B5+'IS - RAS'!E38)","v":{"$error":"#VALUE!"}},{"$f":"(C5+'IS - RAS'!F38)","v":{"$error":"#VALUE!"}},{"$f":"(D5+'IS - RAS'!G38)","v":{"$error":"#VALUE!"}},{"$f":"(E5+'IS - RAS'!H38)","v":{"$error":"#VALUE!"}},{"$f":"(F5+'IS - RAS'!I38)","v":{"$error":"#VALUE!"}},{"$f":"(G5+'IS - RAS'!J38)","v":{"$error":"#VALUE!"}},{"$f":"(H5+'IS - RAS'!K38)","v":{"$error":"#VALUE!"}},{"$f":"(I5+'IS - RAS'!L38)","v":{"$error":"#VALUE!"}},{"$f":"(J5+'IS - RAS'!M38)","v":{"$error":"#VALUE!"}}]
["Current Assets"]
["Inventory",0,0,0,0,0,0,0,0,0,0]
["Debtors",{"$f":"'Production Assumptions'!C50","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!D50","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!E50","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!F50","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!G50","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!H50","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!I50","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!J50","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!K50","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!L50","v":{"$error":"#VALUE!"}}]
["Cash",{"$f":"IF(Interface!H15=\"Equity\",'Production Assumptions'!C49+'IS - RAS'!D36+'IS - RAS'!D16+'Working Capital - RAS'!C34,IF(Interface!H15=\"Debt/Equity\",('Production Assumptions'!C49+'IS - RAS'!D36+'IS - RAS'!D16+'Working Capital - RAS'!C34-'Loan Int & Bal - RAS'!B5),'Production Assumptions'!C49+'IS - RAS'!D36+'IS - RAS'!D16+'Working Capital - RAS'!C34-'Loan Int & Bal - RAS'!B5))","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$H$15=\"Equity\",'Production Assumptions'!D49+'IS - RAS'!E36+'IS - RAS'!E16+B9, IF(Interface!H15=\"Debt/Equity\",('Production Assumptions'!D49+'IS - RAS'!E36+'IS - RAS'!E16-'Loan Int & Bal - RAS'!C5+B9),'Production Assumptions'!D49+'IS - RAS'!E36+'IS - RAS'!E16+B9-'Loan Int & Bal - RAS'!C5))","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$H$15=\"Equity\",'Production Assumptions'!E49+'IS - RAS'!F36+'IS - RAS'!F16+C9, IF(Interface!I15=\"Debt/Equity\",('Production Assumptions'!E49+'IS - RAS'!F36+'IS - RAS'!F16-'Loan Int & Bal - RAS'!D5+C9),'Production Assumptions'!E49+'IS - RAS'!F36+'IS - RAS'!F16+C9-'Loan Int & Bal - RAS'!D5))","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$H$15=\"Equity\",'Production Assumptions'!F49+'IS - RAS'!G36+'IS - RAS'!G16+D9, IF(Interface!J15=\"Debt/Equity\",('Production Assumptions'!F49+'IS - RAS'!G36+'IS - RAS'!G16-'Loan Int & Bal - RAS'!E5+D9),'Production Assumptions'!F49+'IS - RAS'!G36+'IS - RAS'!G16+D9-'Loan Int & Bal - RAS'!E5))","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$H$15=\"Equity\",'Production Assumptions'!G49+'IS - RAS'!H36+'IS - RAS'!H16+E9, IF(Interface!K15=\"Debt/Equity\",('Production Assumptions'!G49+'IS - RAS'!H36+'IS - RAS'!H16-'Loan Int & Bal - RAS'!F5+E9),'Production Assumptions'!G49+'IS - RAS'!H36+'IS - RAS'!H16+E9-'Loan Int & Bal - RAS'!F5))","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$H$15=\"Equity\",'Production Assumptions'!H49+'IS - RAS'!I36+'IS - RAS'!I16+F9, IF(Interface!L15=\"Debt/Equity\",('Production Assumptions'!H49+'IS - RAS'!I36+'IS - RAS'!I16-'Loan Int & Bal - RAS'!G5+F9),'Production Assumptions'!H49+'IS - RAS'!I36+'IS - RAS'!I16+F9-'Loan Int & Bal - RAS'!G5))","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$H$15=\"Equity\",'Production Assumptions'!I49+'IS - RAS'!J36+'IS - RAS'!J16+G9, IF(Interface!M15=\"Debt/Equity\",('Production Assumptions'!I49+'IS - RAS'!J36+'IS - RAS'!J16-'Loan Int & Bal - RAS'!H5+G9),'Production Assumptions'!I49+'IS - RAS'!J36+'IS - RAS'!J16+G9-'Loan Int & Bal - RAS'!H5))","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$H$15=\"Equity\",'Production Assumptions'!J49+'IS - RAS'!K36+'IS - RAS'!K16+H9, IF(Interface!N15=\"Debt/Equity\",('Production Assumptions'!J49+'IS - RAS'!K36+'IS - RAS'!K16-'Loan Int & Bal - RAS'!I5+H9),'Production Assumptions'!J49+'IS - RAS'!K36+'IS - RAS'!K16+H9-'Loan Int & Bal - RAS'!I5))","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$H$15=\"Equity\",'Production Assumptions'!K49+'IS - RAS'!L36+'IS - RAS'!L16+I9, IF(Interface!O15=\"Debt/Equity\",('Production Assumptions'!K49+'IS - RAS'!L36+'IS - RAS'!L16-'Loan Int & Bal - RAS'!J5+I9),'Production Assumptions'!K49+'IS - RAS'!L36+'IS - RAS'!L16+I9-'Loan Int & Bal - RAS'!J5))","v":{"$error":"#VALUE!"}},{"$f":"IF(Interface!$H$15=\"Equity\",'Production Assumptions'!L49+'IS - RAS'!M36+'IS - RAS'!M16+J9, IF(Interface!P15=\"Debt/Equity\",('Production Assumptions'!L49+'IS - RAS'!M36+'IS - RAS'!M16-'Loan Int & Bal - RAS'!K5+J9),'Production Assumptions'!L49+'IS - RAS'!M36+'IS - RAS'!M16+J9-'Loan Int & Bal - RAS'!K5))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"SUM(B5:B9)","v":{"$error":"#VALUE!"}},{"$f":"SUM(C5:C9)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D5:D9)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Equity & Liabilities"]
["Retained Earnings",{"$f":"'IS - RAS'!D45","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!E45+B12","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!F45+C12","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!G45+D12","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!H45+E12","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!I45+F12","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!J45+G12","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!K45+H12","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!L45+I12","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!M45+J12","v":{"$error":"#VALUE!"}}]
["Deferred Income",{"$f":"IF(Interface!$H$15=\"EQUITY\",'CAPEX '!$J$31+'Working Capital - RAS'!$C$34,IF(Interface!$H$15=\"DEBT/EQUITY\",('CAPEX '!$J$31+'Working Capital - RAS'!$C$34)*(100%-Interface!$I$15),0))","v":0},{"$f":"IF(Interface!$H$15=\"EQUITY\",'CAPEX '!$J$31+'Working Capital - RAS'!$C$34,IF(Interface!$H$15=\"DEBT/EQUITY\",('CAPEX '!$J$31+'Working Capital - RAS'!$C$34)*(100%-Interface!$I$15),0))","v":0},{"$f":"IF(Interface!$H$15=\"EQUITY\",'CAPEX '!$J$31+'Working Capital - RAS'!$C$34,IF(Interface!$H$15=\"DEBT/EQUITY\",('CAPEX '!$J$31+'Working Capital - RAS'!$C$34)*(100%-Interface!$I$15),0))","v":0},{"$f":"IF(Interface!$H$15=\"EQUITY\",'CAPEX '!$J$31+'Working Capital - RAS'!$C$34,IF(Interface!$H$15=\"DEBT/EQUITY\",('CAPEX '!$J$31+'Working Capital - RAS'!$C$34)*(100%-Interface!$I$15),0))","v":0},{"$f":"IF(Interface!$H$15=\"EQUITY\",'CAPEX '!$J$31+'Working Capital - RAS'!$C$34,IF(Interface!$H$15=\"DEBT/EQUITY\",('CAPEX '!$J$31+'Working Capital - RAS'!$C$34)*(100%-Interface!$I$15),0))","v":0},{"$f":"IF(Interface!$H$15=\"EQUITY\",'CAPEX '!$J$31+'Working Capital - RAS'!$C$34,IF(Interface!$H$15=\"DEBT/EQUITY\",('CAPEX '!$J$31+'Working Capital - RAS'!$C$34)*(100%-Interface!$I$15),0))","v":0},{"$f":"IF(Interface!$H$15=\"EQUITY\",'CAPEX '!$J$31+'Working Capital - RAS'!$C$34,IF(Interface!$H$15=\"DEBT/EQUITY\",('CAPEX '!$J$31+'Working Capital - RAS'!$C$34)*(100%-Interface!$I$15),0))","v":0},{"$f":"IF(Interface!$H$15=\"EQUITY\",'CAPEX '!$J$31+'Working Capital - RAS'!$C$34,IF(Interface!$H$15=\"DEBT/EQUITY\",('CAPEX '!$J$31+'Working Capital - RAS'!$C$34)*(100%-Interface!$I$15),0))","v":0},{"$f":"IF(Interface!$H$15=\"EQUITY\",'CAPEX '!$J$31+'Working Capital - RAS'!$C$34,IF(Interface!$H$15=\"DEBT/EQUITY\",('CAPEX '!$J$31+'Working Capital - RAS'!$C$34)*(100%-Interface!$I$15),0))","v":0},{"$f":"IF(Interface!$H$15=\"EQUITY\",'CAPEX '!$J$31+'Working Capital - RAS'!$C$34,IF(Interface!$H$15=\"DEBT/EQUITY\",('CAPEX '!$J$31+'Working Capital - RAS'!$C$34)*(100%-Interface!$I$15),0))","v":0}]
["Long Term Liability",{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!B4,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!B4,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!C4,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!C4,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!D4,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!D4,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!E4,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!E4,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!F4,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!F4,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!G4,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!G4,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!H4,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!H4,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!I4,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!I4,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!J4,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!J4,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!K4,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!K4,0))","v":0}]
["Provision for Taxation",{"$f":"-'IS - RAS'!D43","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!E43+B15","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!F43+C15","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!G43+D15","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!H43+E15","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!I43+F15","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!J43+G15","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!K43+H15","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!L43+I15","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!M43+J15","v":{"$error":"#VALUE!"}}]
[null,{"$f":"SUM(B12:B15)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"B10-B16","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"IF(ABS(B17)<0.00001,\"OK\",\"ERROR\")","v":{"$error":"#VALUE!"}},{"$f":"IF(ABS(C17)<0.00001,\"OK\",\"ERROR\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(ABS(E17)<0.00001,\"OK\",\"ERROR\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"CF - RAS","index":14,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,2,0,11]]}
["Projected Cash Flow Statement",null,"Year"]
[null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","NO POSITIVE"]
["Cash flows from operating activities"]
["Profit / (Loss) for the year",null,{"$f":"'IS - RAS'!D45","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!E45","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!F45","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!G45","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!H45","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!I45","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!J45","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!K45","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!L45","v":{"$error":"#VALUE!"}},{"$f":"'IS - RAS'!M45","v":{"$error":"#VALUE!"}}]
["Taxation",null,{"$f":"-'IS - RAS'!D43","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!E43","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!F43","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!G43","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!H43","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!I43","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!J43","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!K43","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!L43","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!M43","v":{"$error":"#VALUE!"}}]
["Adjustment for non-cash expenses:"]
["Interest Charged",null,{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!B3,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!B3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!C3,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!C3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!D3,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!D3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!E3,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!E3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!F3,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!F3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!G3,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!G3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!H3,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!H3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!I3,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!I3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!J3,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!J3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",'Loan Int & Bal - RAS'!K3,IF(Interface!$H$15=\"DEBT/EQUITY\",'Loan Int & Bal - RAS'!K3,0))","v":0}]
["Depreciation",null,{"$f":"-'IS - RAS'!D38","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!E38","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!F38","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!G38","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!H38","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!I38","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!J38","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!K38","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!L38","v":{"$error":"#VALUE!"}},{"$f":"-'IS - RAS'!M38","v":{"$error":"#VALUE!"}}]
["Changes in operating assets & liabilities"]
["Inventory",null,0,0,0,0,0,0,0,0,0,0]
["Receivables (INCREASE)/DECREASE",null,{"$f":"-'BS - RAS'!B8","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!C50-'Production Assumptions'!D50","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!D50-'Production Assumptions'!E50","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!E50-'Production Assumptions'!F50","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!F50-'Production Assumptions'!G50","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!G50-'Production Assumptions'!H50","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!H50-'Production Assumptions'!I50","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!I50-'Production Assumptions'!J50","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!J50-'Production Assumptions'!K50","v":{"$error":"#VALUE!"}},{"$f":"'Production Assumptions'!K50-'Production Assumptions'!L50","v":{"$error":"#VALUE!"}}]
["Payables",null,0,0,0,0,0,0,0,0,0,0]
["Cash generated from operations",null,{"$f":"SUM(C3:C12)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D3:D12)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Interest paid",null,{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!B3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!B3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!C3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!C3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!D3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!D3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!E3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!E3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!F3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!F3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!G3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!G3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!H3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!H3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!I3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!I3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!J3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!J3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!K3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!K3,0))","v":0}]
["Taxation paid",null,0,0,0,0,0,0,0,0,0,0]
["Net cash from operating activities",null,{"$f":"SUM(C13:C15)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D13:D15)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Cash flows from investing activities"]
["Purchases of property, plant & equipment",null,{"$f":"-'CAPEX '!J31","v":{"$error":"#VALUE!"}},0,0,0,0,0,0,0,0,0]
["Net cash used in investing activities",null,{"$f":"C19","v":{"$error":"#VALUE!"}},{"$f":"D19","v":0},0,0,0,0,0,0,0,0]
[]
["Cash flows from financing activities"]
["Proceeds from shareholders' contributions",null,0,0,0,0,0,0,0,0,0,0]
["Proceeds  from equity",null,{"$f":"IF(Interface!$H$15=\"EQUITY\",'CAPEX '!$J$31+'Working Capital - RAS'!$C$34,IF(Interface!$H$15=\"Debt/Equity\",('CAPEX '!$J$31+'Working Capital - RAS'!$C$34)*(100%-Interface!$I$15),0))","v":0},0,0,0,0,0,0,0,0,0]
["Proceeds from Loans",null,{"$f":"IF(Interface!H15=\"DEBT\",(+'CAPEX '!J31+'Working Capital - RAS'!C34),IF(Interface!H15=\"DEBT/EQUITY\",(+'CAPEX '!J31+'Working Capital - RAS'!C34)*Interface!$I$15,0))","v":0},{"$f":"IF(Interface!I15=\"DEBT\",(+'CAPEX '!K33+'Working Capital - RAS'!D34*Interface!$I$15),IF(Interface!I15=\"DEBT/EQUITY\",+'CAPEX '!K33+'Working Capital - RAS'!D34*Interface!$I$15,0))","v":0},{"$f":"IF(Interface!J15=\"DEBT\",(+'CAPEX '!L20+'Working Capital - RAS'!E34*Interface!$I$15),IF(Interface!J15=\"DEBT/EQUITY\",+'CAPEX '!L20+'Working Capital - RAS'!E34*Interface!$I$15,0))","v":0},{"$f":"IF(Interface!K15=\"DEBT\",(+'CAPEX '!M20+'Working Capital - RAS'!F34*Interface!$I$15),IF(Interface!K15=\"DEBT/EQUITY\",+'CAPEX '!M20+'Working Capital - RAS'!F34*Interface!$I$15,0))","v":0},{"$f":"IF(Interface!L15=\"DEBT\",(+'CAPEX '!N20+'Working Capital - RAS'!G34*Interface!$I$15),IF(Interface!L15=\"DEBT/EQUITY\",+'CAPEX '!N20+'Working Capital - RAS'!G34*Interface!$I$15,0))","v":0},{"$f":"IF(Interface!M15=\"DEBT\",(+'CAPEX '!O33+'Working Capital - RAS'!H34*Interface!$I$15),IF(Interface!M15=\"DEBT/EQUITY\",+'CAPEX '!O33+'Working Capital - RAS'!H34*Interface!$I$15,0))","v":0},{"$f":"IF(Interface!N15=\"DEBT\",(+'CAPEX '!P33+'Working Capital - RAS'!#REF!*Interface!$I$15),IF(Interface!N15=\"DEBT/EQUITY\",+'CAPEX '!P33+'Working Capital - RAS'!#REF!*Interface!$I$15,0))","v":0},{"$f":"IF(Interface!O15=\"DEBT\",(+'CAPEX '!Q33+'Working Capital - RAS'!#REF!*Interface!$I$15),IF(Interface!O15=\"DEBT/EQUITY\",+'CAPEX '!Q33+'Working Capital - RAS'!#REF!*Interface!$I$15,0))","v":0},{"$f":"IF(Interface!P15=\"DEBT\",(+'CAPEX '!R33+'Working Capital - RAS'!#REF!*Interface!$I$15),IF(Interface!P15=\"DEBT/EQUITY\",+'CAPEX '!R33+'Working Capital - RAS'!#REF!*Interface!$I$15,0))","v":0},{"$f":"IF(Interface!Q15=\"DEBT\",(+'CAPEX '!S33+'Working Capital - RAS'!#REF!*Interface!$I$15),IF(Interface!Q15=\"DEBT/EQUITY\",+'CAPEX '!S33+'Working Capital - RAS'!#REF!*Interface!$I$15,0))","v":0}]
["Repayment of Loans",null,{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!B5+'Loan Int & Bal - RAS'!B3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!B5+'Loan Int & Bal - RAS'!B3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!C5+'Loan Int & Bal - RAS'!C3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!C5+'Loan Int & Bal - RAS'!C3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!D5+'Loan Int & Bal - RAS'!D3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!D5+'Loan Int & Bal - RAS'!D3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!E5+'Loan Int & Bal - RAS'!E3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!E5+'Loan Int & Bal - RAS'!E3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!F5+'Loan Int & Bal - RAS'!F3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!F5+'Loan Int & Bal - RAS'!F3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!G5+'Loan Int & Bal - RAS'!G3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!G5+'Loan Int & Bal - RAS'!G3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!H5+'Loan Int & Bal - RAS'!H3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!H5+'Loan Int & Bal - RAS'!H3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!I5+'Loan Int & Bal - RAS'!I3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!I5+'Loan Int & Bal - RAS'!I3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!J5+'Loan Int & Bal - RAS'!J3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!J5+'Loan Int & Bal - RAS'!J3,0))","v":0},{"$f":"IF(Interface!$H$15=\"DEBT\",-'Loan Int & Bal - RAS'!K5+'Loan Int & Bal - RAS'!K3,IF(Interface!$H$15=\"DEBT/EQUITY\",-'Loan Int & Bal - RAS'!K5+'Loan Int & Bal - RAS'!K3,0))","v":0}]
["Net cash from financing activities",null,{"$f":"SUM(C23:C26)","v":0},{"$f":"SUM(D23:D26)","v":0},0,0,0,0,0,0,0,0]
[]
["Increase / (Decrease) in cash equivalents",null,{"$f":"C27+C20+C16","v":{"$error":"#VALUE!"}},{"$f":"D27+D20+D16","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Cash & cash equivalents at beginning of year",null,0,{"$f":"C33","v":{"$error":"#VALUE!"}},{"$f":"D33","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Cash & cash equivalents at end of year",-1,{"$f":"SUM(C29:C32)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},1]
["DIFF",null,{"$f":"C33-'BS - RAS'!B9","v":{"$error":"#VALUE!"}},{"$f":"D33-'BS - RAS'!C9","v":{"$error":"#VALUE!"}},{"$f":"E33-'BS - RAS'!D9","v":{"$error":"#VALUE!"}},{"$f":"F33-'BS - RAS'!E9","v":{"$error":"#VALUE!"}},{"$f":"G33-'BS - RAS'!F9","v":{"$error":"#VALUE!"}},{"$f":"H33-'BS - RAS'!G9","v":{"$error":"#VALUE!"}},{"$f":"I33-'BS - RAS'!H9","v":{"$error":"#VALUE!"}},{"$f":"J33-'BS - RAS'!I9","v":{"$error":"#VALUE!"}},{"$f":"K33-'BS - RAS'!J9","v":{"$error":"#VALUE!"}},{"$f":"L33-'BS - RAS'!K9","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"IF(ABS(C34)<0.00001,\"OK\",\"ERROR\")","v":{"$error":"#VALUE!"}},{"$f":"IF(ABS(D34)<0.00001,\"OK\",\"ERROR\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"IRR - RAS","index":15,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,2,2,3]]}
[]
[]
[null,null,"IRR CALCULATION"]
[null,null,"Period","Nett cash Flow for period"]
[null,null,"Initial Investment",{"$f":"-('BS - RAS'!B13+'Loan - RAS'!B9)","v":0}]
[null,null,1,{"$f":"'CF - RAS'!C33","v":{"$error":"#VALUE!"}}]
[null,null,2,{"$f":"'CF - RAS'!D33","v":{"$error":"#VALUE!"}}]
[null,null,3,{"$f":"'CF - RAS'!E33","v":{"$error":"#VALUE!"}}]
[null,null,4,{"$f":"'CF - RAS'!F33","v":{"$error":"#VALUE!"}}]
[null,null,5,{"$f":"'CF - RAS'!G33","v":{"$error":"#VALUE!"}}]
[null,null,6,{"$f":"'CF - RAS'!H33","v":{"$error":"#VALUE!"}}]
[null,null,7,{"$f":"'CF - RAS'!I33","v":{"$error":"#VALUE!"}}]
[null,null,8,{"$f":"'CF - RAS'!J33","v":{"$error":"#VALUE!"}}]
[null,null,9,{"$f":"'CF - RAS'!K33","v":{"$error":"#VALUE!"}}]
[null,null,10,{"$f":"'CF - RAS'!L33","v":{"$error":"#VALUE!"}}]
[]
[null,null,"TOTAL NETT INFLOW",{"$f":"SUM(D5:D15)","v":{"$error":"#VALUE!"}}]
[]
[null,null,"IRR",{"$f":"IF(D17>0, IRR(D5:D15), 0)","v":{"$error":"#VALUE!"}}]

{"sheet":"NPV & PI - RAS","index":16,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,2,2,3]]}
[]
[null,null,null,"2016 REPO Rate",7.0000000000000007E-2]
[null,null,"NPV & PI Index"]
[null,null,"Period","Nett cash Flow for period","Discounted Cash Flow"]
[null,null,"Initial Investment",{"$f":"'IRR - RAS'!D5","v":0}]
[null,null,1,{"$f":"'IRR - RAS'!D6","v":{"$error":"#VALUE!"}},{"$f":"D6/((1+$E$2)^C6)","v":{"$error":"#VALUE!"}}]
[null,null,2,{"$f":"'IRR - RAS'!D7","v":{"$error":"#VALUE!"}},{"$f":"D7/((1+$E$2)^C7)","v":{"$error":"#VALUE!"}}]
[null,null,3,{"$f":"'IRR - RAS'!D8","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,null,null," "]
[null,null,4,{"$f":"'IRR - RAS'!D9","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,5,{"$f":"'IRR - RAS'!D10","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,6,{"$f":"'IRR - RAS'!D11","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,7,{"$f":"'IRR - RAS'!D12","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,8,{"$f":"'IRR - RAS'!D13","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,9,{"$f":"'IRR - RAS'!D14","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,10,{"$f":"'IRR - RAS'!D15","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[]
[null,null,"NETT PRESENT VALUE",{"$f":"SUM(E6:E15)","v":{"$error":"#VALUE!"}}]
[]
[null,null,"Profitability Index",{"$f":"NPV(E2,D6,D7,D8,D9,D10,D11,D12,D13,D14,D15)/-D5","v":{"$error":"#VALUE!"}}]

{"sheet":"DEP - RAS","index":17,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,5,2,14]]}
[]
[]
[null,"Item","Useful Lifetime in Years","Rate","Price","Year"]
[null,null,null,null,null,1,{"$f":"F4+1","v":2},{"$f":"G4+1","v":3},4,5,6,7,8,9,10]
[null,"Infrastructure"]
[null,{"$f":"'CAPEX '!B6","v":"Hatchery Room"},50,{"$f":"100%/C6","v":0.02},{"$f":"'CAPEX '!J6","v":86400},{"$f":"E6*D6","v":1728},{"$f":"IF(G$4<=$C6,F6,0)","v":1728},{"$f":"IF(H$4<=$C6,G6,0)","v":1728},1728,1728,1728,1728,1728,1728,1728]
[null,{"$f":"'CAPEX '!B7","v":"Tunnels (number) (m)"},10,{"$f":"100%/C7","v":0.1},{"$f":"'CAPEX '!J7","v":{"$error":"#VALUE!"}},{"$f":"E7*D7","v":{"$error":"#VALUE!"}},{"$f":"IF(G$4<=$C7,F7,0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"'CAPEX '!B8","v":"Office/Storage/Feed store"},50,0.02,{"$f":"'CAPEX '!J8","v":180000},{"$f":"E8*D8","v":3600},3600,3600,3600,3600,3600,3600,3600,3600,3600]
[null,{"$f":"'CAPEX '!B9","v":"Packing Room (Complete with tanks,piping etc)"},25,0.04,{"$f":"'CAPEX '!J9","v":25250},1010,1010,1010,1010,1010,1010,1010,1010,1010,1010]
[null,"Equipment"]
[null,{"$f":"'CAPEX '!B13","v":"Grow-out containment number (m3)"},10,{"$f":"100%/C11","v":0.1},{"$f":"'CAPEX '!J13","v":{"$error":"#VALUE!"}},{"$f":"E11*D11","v":{"$error":"#VALUE!"}},{"$f":"IF(G$4<=$C11,F11,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(H$4<=$C11,G11,0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"'CAPEX '!B14","v":"Hatchery: Breeding Tanks (1 brood pair/tank)"},10,{"$f":"100%/C12","v":0.1},{"$f":"'CAPEX '!J14","v":12500},{"$f":"E12*D12","v":1250},{"$f":"IF(G$4<=$C12,F12,0)","v":1250},{"$f":"IF(H$4<=$C12,G12,0)","v":1250},{"$f":"IF(I$4<=$C12,H12,0)","v":1250},{"$f":"IF(J$4<=$C12,I12,0)","v":1250},{"$f":"IF(K$4<=$C12,J12,0)","v":1250},{"$f":"IF(L$4<=$C12,K12,0)","v":1250},{"$f":"IF(M$4<=$C12,L12,0)","v":1250},{"$f":"IF(N$4<=$C12,M12,0)","v":1250},{"$f":"IF(O$4<=$C12,N12,0)","v":1250}]
[null,{"$f":"'CAPEX '!B15","v":"Hatchery Tank Stands"},10,{"$f":"100%/C13","v":0.1},{"$f":"'CAPEX '!J15","v":20400},2040,2040,2040,2040,2040,2040,2040,2040,2040,2040]
[null,{"$f":"'CAPEX '!B16","v":"Hatchery piping & Fittings"},4,{"$f":"100%/C14","v":0.25},{"$f":"'CAPEX '!J16","v":10000},2500,2500,2500,2500,0,0,0,0,0,0]
[null,{"$f":"'CAPEX '!B17","v":"Hatchery Heating/cooling"},6,{"$f":"100%/C15","v":0.16666666666666666},{"$f":"'CAPEX '!J17","v":15000},2500,2500,2500,2500,2500,2500,0,0,0,0]
[null,{"$f":"'CAPEX '!B18","v":"Water quality testing equipment"},7,{"$f":"100%/C16","v":0.14285714285714285},{"$f":"'CAPEX '!J18","v":16500},{"$f":"E16*D16","v":2357.1428571428569},{"$f":"IF(G$4<=$C16,F16,0)","v":2357.1428571428569},2357.1428571428569,2357.1428571428569,2357.1428571428569,2357.1428571428569,2357.1428571428569,0,0,0]
[null,{"$f":"'CAPEX '!B19","v":"Water Pumps"},4,0.25,{"$f":"'CAPEX '!J19","v":{"$error":"#VALUE!"}},{"$f":"E17*D17","v":{"$error":"#VALUE!"}},{"$f":"IF(G$4<=$C17,F17,0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0,0]
[null,{"$f":"'CAPEX '!B22","v":"Biofilter Tank"},10,0.1,{"$f":"'CAPEX '!J22","v":18360},1836,{"$f":"IF(G$4<=$C18,F18,0)","v":1836},1836,1836,1836,1836,1836,1836,1836,1836]
[null,{"$f":"'CAPEX '!B23","v":"Biofilter Media"},5,0.2,{"$f":"'CAPEX '!J23","v":{"$error":"#VALUE!"}},{"$f":"E19*D19","v":{"$error":"#VALUE!"}},{"$f":"IF(G$4<=$C19,F19,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(H$4<=$C19,G19,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(I$4<=$C19,H19,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(J$4<=$C19,I19,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(K$4<=$C19,J19,0)","v":0},{"$f":"IF(L$4<=$C19,K19,0)","v":0},{"$f":"IF(M$4<=$C19,L19,0)","v":0},{"$f":"IF(N$4<=$C19,M19,0)","v":0},{"$f":"IF(O$4<=$C19,N19,0)","v":0}]
[null,"Moveable assets"]
[null,{"$f":"'CAPEX '!B25","v":"Buckets/drums"},7,{"$f":"100%/C21","v":0.14285714285714285},{"$f":"'CAPEX '!J25","v":1092.8},{"$f":"E21*D21","v":156.1142857142857},{"$f":"IF(G$4<=$C21,F21,0)","v":156.1142857142857},{"$f":"IF(H$4<=$C21,G21,0)","v":156.1142857142857},156.1142857142857,156.1142857142857,156.1142857142857,156.1142857142857,0,0,0]
[null,{"$f":"'CAPEX '!B26","v":"Feeding Stations"},3,{"$f":"100%/C22","v":0.33333333333333331},{"$f":"'CAPEX '!J26","v":{"$error":"#VALUE!"}},{"$f":"E22*D22","v":{"$error":"#VALUE!"}},{"$f":"IF(G$4<=$C22,F22,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(H$4<=$C22,G22,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(I$4<=$C22,H22,0)","v":0},{"$f":"IF(J$4<=$C22,I22,0)","v":0},{"$f":"IF(K$4<=$C22,J22,0)","v":0},{"$f":"IF(L$4<=$C22,K22,0)","v":0},{"$f":"IF(M$4<=$C22,L22,0)","v":0},{"$f":"IF(N$4<=$C22,M22,0)","v":0},{"$f":"IF(O$4<=$C22,N22,0)","v":0}]
[null,{"$f":"'CAPEX '!B27","v":"Spawning Traps"},3,0.33333333333333331,{"$f":"'CAPEX '!J27","v":7500},2500,2500,2500,0,0,0,0,0,0,0]
[null,{"$f":"'CAPEX '!B28","v":"Office equipment"},3,{"$f":"100%/C24","v":0.33333333333333331},{"$f":"'CAPEX '!J28","v":6000},2000,{"$f":"IF(G$4<=$C24,F24,0)","v":2000},2000,0,0,0,0,0,0,0]
[null,{"$f":"'CAPEX '!B29","v":"Short/long handle Hand net"},4,0.25,{"$f":"'CAPEX '!J29","v":864},216,{"$f":"IF(G$4<=$C25,F25,0)","v":216},216,216,0,0,0,0,0,0]
[null,{"$f":"'CAPEX '!B30","v":"Vehicle"},4,0.25,{"$f":"'CAPEX '!J30","v":200000},50000,{"$f":"IF(G$4<=$C26,F26,0)","v":50000},50000,50000,0,0,0,0,0,0]
[null,"TOTAL",null,null,{"$f":"SUM(E6:E26)","v":{"$error":"#VALUE!"}},{"$f":"SUM(F6:F26)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"Loan - RAS","index":18,"n_rows":255,"n_cols":8,"rows_kept":255,"cut":false,"hidden":true,"merged":[[7,0,7,1]]}
[]
["Year 1 loan"]
["Balance:",{"$f":"B9","v":0}]
["Interest rate:",{"$f":"B10/12","v":0}]
["Periods:",12]
["Monthly Payment:",{"$f":"PMT(B4,B5,-B3)","v":0}]
[]
["Loan Amortization schedule"]
["Loan Amount",{"$f":"IF(Interface!H15=\"DEBT\",'CAPEX '!J31+'Working Capital - RAS'!C34, IF(Interface!H15=\"DEBT/EQUITY\",('CAPEX '!J31+'Working Capital - RAS'!C34)*Interface!I15,0))","v":0}]
["Interest rate",{"$f":"Interface!I26","v":0}]
["Months",{"$f":"B12*12","v":{"$error":"#VALUE!"}}]
["YEARS",{"$f":"Interface!J26","v":"<Please select a payback period>"}]
["Payments",{"$f":"ROUND(PMT($B$10/12,$B$11,-$B$9, 0),0)","v":{"$error":"#VALUE!"}},{"$f":"B13*12","v":{"$error":"#VALUE!"}}]
[]
["Payment Number","Beginning Balance","Payment","Principal","interest","Cumulative Principal","Cumulative Interest","Ending Balance"]
[1,{"$f":"$B$9","v":0},{"$f":"$B$13","v":{"$error":"#VALUE!"}},{"$f":"$C16-$E16","v":{"$error":"#VALUE!"}},{"$f":"IF($B16*$B$4>0,$B16*$B$4,0)","v":0},null,null,{"$f":"$B16-$D16","v":{"$error":"#VALUE!"}}]
[2,{"$f":"H16","v":{"$error":"#VALUE!"}},{"$f":"$B$13","v":{"$error":"#VALUE!"}},{"$f":"$C17-$E17","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,{"$f":"$B17-$D17","v":{"$error":"#VALUE!"}}]
[3,{"$f":"H17","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[5,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF($B20*$B$4>0,$B20*$B$4,0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#VALUE!"}]
[6,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF($B21*$B$4>0,$B21*$B$4,0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#VALUE!"}]
[7,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[8,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[9,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[10,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[11,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[12,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[13,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[14,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[16,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[17,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[18,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[19,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[20,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[21,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[22,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[23,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[24,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[25,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[26,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[27,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[28,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[29,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[32,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[33,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[34,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[35,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[36,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[37,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[38,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[39,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[40,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[41,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[42,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[43,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[44,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[45,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[46,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[47,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[48,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[49,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[50,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[51,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[52,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[53,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[54,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[55,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[56,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[57,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[58,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[59,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[60,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[61,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[62,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[63,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[64,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[65,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[66,{"$error":"#VALUE!"},{"$f":"$B$13","v":{"$error":"#VALUE!"}},{"$f":"$C81-$E81","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,{"$f":"$B81-$D81","v":{"$error":"#VALUE!"}}]
[67,{"$f":"H81","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[68,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[69,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[70,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF($B85*$B$4>0,$B85*$B$4,0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#VALUE!"}]
[71,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[72,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[73,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[74,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[75,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[76,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[77,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[78,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[79,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[80,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[81,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[82,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[83,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[84,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[85,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[86,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[87,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[88,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[89,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[90,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[91,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[92,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[93,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[94,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[95,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[96,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[97,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[98,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[99,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[100,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[101,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[102,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[103,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[104,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[105,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[106,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[107,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[108,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[109,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[110,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[111,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[112,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[113,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[114,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[115,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[116,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[117,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[118,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[119,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[120,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[121,{"$f":"H135","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[122,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[123,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[124,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[125,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[126,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[127,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[128,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[129,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[130,{"$error":"#VALUE!"},{"$f":"$B$13","v":{"$error":"#VALUE!"}},{"$f":"$C145-$E145","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,{"$f":"$B145-$D145","v":{"$error":"#VALUE!"}}]
[131,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[132,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[133,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[134,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF($B149*$B$4>0,$B149*$B$4,0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#VALUE!"}]
[135,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[136,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[137,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[138,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[139,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[140,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[141,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[142,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[143,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[144,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[146,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[147,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[148,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[149,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[150,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[151,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[152,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[153,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[154,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[155,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[156,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[157,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[158,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[159,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[160,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[161,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[162,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[163,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[164,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[165,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[166,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[167,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[168,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[169,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[170,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[171,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[172,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[173,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[174,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[175,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[176,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[177,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[178,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[179,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[180,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[181,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$f":"IF($B196-$D196>0,$B196-$D196,0)","v":{"$error":"#VALUE!"}}]
[182,{"$f":"IF(H196>0,H196,0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$f":"IF($B197-$D197>0,$B197-$D197,0)","v":{"$error":"#VALUE!"}}]
[183,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[184,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[185,{"$f":"H199","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[186,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[187,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[188,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[189,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[190,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[191,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[192,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[193,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[194,{"$error":"#VALUE!"},{"$f":"$B$13","v":{"$error":"#VALUE!"}},{"$f":"$C209-$E209","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[195,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[196,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[197,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[198,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF($B213*$B$4>0,$B213*$B$4,0)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#VALUE!"}]
[199,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[200,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[201,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[202,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[203,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[204,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[205,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[206,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[207,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[208,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[209,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[210,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[211,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[212,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[213,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[214,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[215,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[216,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[217,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[218,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[219,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[220,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[221,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[222,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[223,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[224,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[225,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[226,{"$f":"H240","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[227,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[228,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[229,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[230,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[231,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[232,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[233,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[234,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[235,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[236,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[237,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[238,{"$f":"H252","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[239,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[240,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]

{"sheet":"Loan Int & Bal - RAS","index":19,"n_rows":5,"n_cols":21,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20"]
["Annual Interest",{"$f":"SUM('Loan - RAS'!E16:E27)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E28:E39)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E40:E51)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E52:E63)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E64:E75)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E76:E87)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E88:E99)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E100:E111)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E112:E123)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E124:E135)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E136:E147)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E148:E159)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E160:E171)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E172:E183)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E184:E195)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E196:E207)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E208:E219)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E220:E231)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E232:E243)","v":{"$error":"#VALUE!"}},{"$f":"SUM('Loan - RAS'!E244:E255)","v":{"$error":"#VALUE!"}}]
["Annual Balance",{"$f":"'Loan - RAS'!H27","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H39","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H51","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H63","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H75","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H87","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H99","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H111","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H123","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H135","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H147","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H159","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H171","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H183","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H195","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H207","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H219","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H231","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H243","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!H255","v":{"$error":"#VALUE!"}}]
["Repayments",{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}},{"$f":"'Loan - RAS'!$B$13*12","v":{"$error":"#VALUE!"}}]

{"sheet":"RISK","index":20,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":true,"merged":[[1,1,2,3]]}
[]
[null,"RISK FACTORS"]
[]
[]
[null,"PRIME INTEREST",0.10249999999999999]
[null,"CURRENT PRODUCTION FACTOR",1]
[null,null,null,null,null,null,null,null,"No skills in Aquaculture"]
[null,null,null,null,null,null,null,null,"Work experience (1-2 years)"]
[null,"EXISTING SITE?",null,{"$f":"Interface!F15","v":"<Do you already have a Farm?>"},null,null,null,null,"Work experience (3-5 years)"]
[null,"Interest Rate Effect",{"$f":"IF(D9=\"YES\",1%,0%)","v":0},null,null,null,null,null,"Work experience (over 5 years)"]
[null,"Higher Production Factor",{"$f":"IF(D9=\"YES\",0.1,0)","v":0},null,null,null,null,null,"Formal education (certificate, diploma, degrees)"]
[null,"CAPEX - NO LAND"]
[]
[null,"SKILLED WORKERS?",null,{"$f":"Interface!G18","v":"<Please Select a Skills Level>"}]
[null,"Interest Rate Effect",{"$f":"IF(D14=Validation!F14,0%,IF(D14=Validation!F15,0.25%,IF(D14=Validation!F16,0.5%,IF(D14=Validation!F17,0.75%,IF(D14=Validation!F18,1%,0%)))))","v":0}]
[null,"Higher Production Factor",{"$f":"IF(D14=B32, 0.05, IF(D14=B33, 0.1, IF(D14=B34, 0.15, IF(D14=B35, 0.2, 0))))","v":0}]
[null,"HIGHER EMPLOYEE COST"]
[]
[null,"ESTABLISHED FACILITY?",null,{"$f":"Interface!E15","v":"<Select Operational Status>"}]
[null,"Interest Rate",{"$f":"IF(D19=\"EXISTING\",1%,0%)","v":0}]
[]
[null,"INVESTOR?",null,{"$f":"Interface!G15","v":"<Do you already have a investor?>"}]
[null,"Interest Rate",{"$f":"IF(D22=\"YES\",1%,0%)","v":0}]
[]
[null,"NETT INTEREST RATE",{"$f":"C5-C10-C20-C23-C15","v":0.10249999999999999}]
[null,"NETT ESCALATED PRODUCTION FACTOR",{"$f":"C6+C11+C16","v":1}]
[]
[]
[]
[]
[null,"No skills in Aquaculture"]
[null,"Work experience (1-2 years)"]
[null,"Work experience (3-5 years)"]
[null,"Work experience (over 5 years)"]
[null,"Formal education (certificate, diploma, degrees)"]