{"text_format":"2","workbook":"xlsx","n_sheets":9,"sheets":["Read Me","1 General Information","2 Equipment & Assets","3 Fixed Costs & Financing","4 Seasonal Crops","5 Perennial Crops","6 Livestock","7 Summary","8 Farm Income Statement"],"not_rendered":{"charts":2,"images":3,"macros":0,"external_links":0,"defined_names":101,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Read Me","index":0,"n_rows":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":false,"merged":[[33,0,33,9],[43,1,43,8],[45,1,48,8],[49,1,49,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[39,1,39,8],[41,1,41,8],[42,0,42,9],[34,0,34,9],[1,0,1,9],[3,0,3,8],[9,1,9,8],[10,0,10,9],[11,0,11,9],[12,0,12,9],[14,1,14,8],[16,0,16,9],[30,1,30,8],[32,0,32,9],[20,4,21,9],[22,4,23,9],[24,4,25,9],[26,4,27,9],[28,4,28,9]]}
[]
["Read Me Sheet"]
[]
["Solar Powered Irrigation Systems - Manual and Tools"]
[]
[]
[]
[]
[]
[null,"Introduction"]
["DESIGN 06 - Farm Analysis Tool"]
["This tool allows for assessment on farm productivity and profitability, through ist agricultural production. "]
["This tool allows an SPIS advisor (supplier, development practisioner, extension officer) to support a farm enterprise towards identify unnecessary costs, determine best value agricultural activities and correctly monetise differt farm inputs. "]
[]
[null,"Overview"]
[]
["This tool comprises the following sheets:"]
[null,"1. General Information",null,null,"on the farm identity, location and area"]
[null,"2. Equipment & Assets",null,null,"currently available on the farm or considered for future purchase"]
[null,"3. Fixed Costs & Financing",null,null,"that comprises fixed regular expenditures"]
[null,"4. Seasonal Crops",null,null,"to add current or projected sales of seasonal crops (e.g. rice, vegetables, fodder) and by-products and the related variable expenditures"]
[]
[null,"5. Perennial Crops",null,null,"to add current or projected sales of perennial crops (e.g. fruit trees) and by-products and the related variable expenditures"]
[]
[null,"6. Livestock",null,null,"to add current or projected sales of livestock, poultry and by-products and the related variable expenditures"]
[]
[null,"7. Summary",null,null,"No Entry! Table summarising crop and livestock income and variable expenditures"]
[]
[null,"8. Farm Income Statement",null,null,"No Entry! Summary calculation on gross profitability of the farm enterprise"]
[]
[null,"Tips & Tricks"]
[]
["This tool contains numerous critical formulas or calculations."]
["Only add data into white (non-coloured) cells!"]
["This tool provides an indicative assessment of farm profitability, and should be complemented by depper and more detailed assessments, market analysis and other due diligence, before committing to large-scale investments."]
[]
[null,"About"]
[null,"Authors: Robert Schultz, GFA Consulting"]
[null,"Version: 1.0 (January 2017)"]
[null,"Published by: Powering Agriculture – An Energy Grand Challenge for Development"]
[{"$nulls":4},"Internet: https://poweringag.org"]
[null,"Design/layout: "]
["Download link: "]
[null,"Contact: Robert.Schultz@giz.de"]
[]
[null,"GIZ encourages the use, reproduction and dissemination of material in this information product. Except where otherwise indicated, material may be copied, downloaded and printed for private study, research and teaching purposes, or for use in non-commercial products or services, provided that appropriate acknowledgement of GIZ as the source."]
[]
[]
[]
[null,"© GIZ 2017"]

{"sheet":"1 General Information","index":1,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,9],[5,7,5,9],[11,2,11,7],[17,1,17,9],[18,1,18,9],[1,1,2,9],[7,2,7,9],[8,2,8,4],[10,2,10,4],[9,2,9,4],[4,2,4,4],[4,7,4,9]]}
["DESIGN 06 - Farm Analysis Tool"]
[null,"1 GENERAL FARM INFORMATION"]
[]
[]
[null,"Country","Namibia",null,null,null,"Region","Karas"]
[null,"Farm code","Nam_123456789",null,null,null,"Date","2017-11-14"]
[]
[null,"Name of the farm"]
[null,"Village"]
[null,"Division"]
[null,"District"]
[null,"Interviewer"]
[null,"Agricultural campaign",null,2019,2020,"( four digits each ! )"]
[null,"Currency used for calculation",null,"€"]
[null,"Area measurement unit",null,"ha",{"$nulls":4},"Conversion factor to 1 ha :",1]
[null,"Weight measurement unit",null,"kg",{"$nulls":4},"Conversion factor to 1 kg :",1]
[]
[]
[null,"LAND RESOURCES"]
[]
[null,"Property status",null,"Area"]
[null,"+ Land owned",null,null,7,{"$f":"+$D$15","v":"ha"},"=",null,{"$f":"+E22/$J$15","v":7},"ha"]
[null,"+ Part of co-operative land",null,null,null,"ha","=",null,{"$f":"+E23/$J$15","v":0},"ha"]
[null,"+ Land exploited as sharegrower (partner possesses)",null,null,null,"ha","=",null,0,"ha"]
[null,"+ Land leased in",null,null,3,"ha","=",null,3,"ha"]
[null," - Land leased out",null,null,1,"ha","=",null,1,"ha"]
[null,"+ Land in possession of other sources",null,null,null,"ha","=",null,0,"ha"]
[null,null,null,"Total",{"$f":"+SUM(E22:E25)-E26+E27","v":9},"ha","=",null,9,"ha"]
[]
[null,"Access to communal grazing lands",null,"Yes",null,null,null,"No","X"]
[]
[null,"Land classification",null,"Area","rain fed","irrigated",null,null,"Total area"]
[null,"Seasonal crop land",null,null,2,7,{"$f":"+$D$15","v":"ha"},"=",{"$f":"(+E33+F33)/$J$15","v":9},"ha"]
[null,"Perennials (with & without option of intercropping)",null,null,null,0,"ha","=",{"$f":"(+E34+F34)/$J$15","v":0},"ha"]
[null,"Greenhouses",{"$nulls":4},"ha","=",{"$f":"(+E35+F35)/$J$15","v":0},"ha"]
[null,"Pastures (grazing land)",{"$nulls":4},"ha","=",{"$f":"(+E36+F36)/$J$15","v":0},"ha"]
[{"$nulls":6},"ha","=",{"$f":"(+E37+F37)/$J$15","v":0},"ha"]
[null,null,null,"Total agricultural / horticultural land",{"$f":"+SUM(E33:E37)","v":2},{"$f":"+SUM(F33:F37)","v":7},"ha","=",{"$f":"IF((+$I$33+$I$34+$I$35+$I$36+$I$37)=I28,+$I$33+$I$34+$I$35+$I$36+$I$37,\"CHECK !\")","v":9},"ha"]
[]
[null,"Afforested area",null,null,null,{"$f":"+$D$15","v":"ha"},"=",null,{"$f":"+E40/$J$15","v":0},"ha"]
[null,"Long term fallow ( >3 years )",null,null,null,{"$f":"+$D$15","v":"ha"},"=",null,{"$f":"+E41/$J$15","v":0},"ha"]
[null,null,null,"Total non-agricultural land",{"$f":"+E41+E40","v":0},{"$f":"+$D$15","v":"ha"},"=",null,{"$f":"+E42/$J$15","v":0},"ha"]
[{"$nulls":4},"or lease in kind"]
[null,"Lease costs",300,{"$f":"+$D$14","v":"€"},"for",{"$f":"+$E$25","v":3},"leased in"]
[null,"unit costs equivalent to",{"$f":"IF(F44=0,0,+C44/F44)","v":100},{"$f":"+$D$14","v":"€"}]
[]
[null,"Revenue from lease",500,{"$f":"+$D$14","v":"€"},"for",{"$f":"+$E$26","v":1},"leased out"]
[null,"unit revenue equivalent to",{"$f":"IF(F47=0,0,+C47/F47)","v":500},{"$f":"+$D$14","v":"€"}]

{"sheet":"2 Equipment & Assets","index":2,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,9],[41,1,41,3],[1,1,1,7],[3,6,3,7],[3,2,3,3],[5,1,9,3],[5,5,8,5],[5,6,8,6],[34,1,34,3],[36,1,36,7],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,1,40,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[5,4,8,4],[5,7,8,7],[21,2,21,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3]]}
["DESIGN 06 - Farm Analysis Tool"]
[null,"2 EQUIPMENT & ASSETS"]
[]
[null,"Annual inflation rate",5.3999999999999999E-2,null,null,"Farm code",{"$f":"'1 General Information'!C6","v":"Nam_123456789"},null,null,"Please select",null,"Please select"]
[{"$nulls":9},"Sugar cane",null,"Livestock shed / stable"]
[null,"Type\n\n(Position the mouse on \"Type\" to get suggestions)",null,null,"Today's value of equivalent replacement","Age","Normal life span","Annual depreciation for replacement",null,"Fruit tree",null,"Workshop / garage"]
[{"$nulls":9},"Olive",null,"Storage / warehouse"]
[{"$nulls":9},"Dates",null,"Other buildings"]
[{"$nulls":11},"Well / borehole"]
[{"$nulls":4},{"$f":"'1 General Information'!D14","v":"€"},"years","years",{"$f":"'1 General Information'!D14","v":"€"},null,null,null,"Ox cart",null,"Indicative normal life span:"]
[null,"Sprayer",null,null,450000,4,7,{"$f":"IF(G11=0,0,+IF((+G11-F11)<0,\"amorti   \",(E11*((1+$C$4)^(G11-F11)))/G11))","v":75272.494114285713},null,null,null,"Tractor / car"]
[null,"Well / borehole",null,null,275000,10,20,{"$f":"IF(G12=0,0,+IF((+G12-F12)<0,\"amorti   \",(E12*((1+$C$4)^(G12-F12)))/G12))","v":23265.308030817709},null,null,null,"Plough",null,"Livestock shed - 20 years"]
[null,"Livestock shed / stable",{"$nulls":5},0,null,null,null,"Cultivator / tiller",null,"Garage / Workshop - 20 year"]
[null,"Please select",{"$nulls":5},0,null,null,null,"Sowing machine",null,"Storage / warehouse - 20 years"]
[null,"Please select",{"$nulls":5},0,null,null,null,"Fertilizer distributor",null,"Other building - 20 years"]
[null,"Please select",{"$nulls":5},0,null,null,null,"Sprayer",null,"Well / borehole - 20 years"]
[null,"Please select",{"$nulls":5},0,null,null,null,"Grass cutter",null,"Ox cart - 7 years"]
[null,"Please select",{"$nulls":5},0,null,null,null,"Baler"," ","Truck / car - 10 years"]
[null,"Please select",{"$nulls":5},0,null,null,null,"Cereal harvester",null,"Tractor - 10 years"]
[null,"Please select",{"$nulls":5},0,null,null,null,"Irrigation material",null,"Plough - 7 years"]
[null,"Please select",{"$nulls":5},0,null,null,null,"Water pump",null,"Cultivator / tiller - 7 years"]
[null,"Please select",{"$nulls":5},0,null,null,null,"PV generator",null,"Sowing machine - 7 years"]
[null,"Please select",{"$nulls":5},0,null,null,null,"Glashouse equipement",null,"Fertilizer distributor - 7 years"]
[null,"Please select",{"$nulls":5},0,{"$nulls":5},"Sprayer - 7 years "]
[null,"Please select",{"$nulls":5},0,{"$nulls":5},"Grass cutter  -  7 years"]
[null,"Please select",{"$nulls":5},0,{"$nulls":5},"Baler - 7 years"]
[null,"Please select",{"$nulls":5},0,{"$nulls":5},"Cereal harvester - 10 years"]
[null,"Please select",{"$nulls":5},0,{"$nulls":5},"Irrigation material - 5 years"]
[{"$nulls":7},0,{"$nulls":5},"Water pump - 7 years"]
[{"$nulls":7},0,{"$nulls":5},"PV generator - 20 years"]
[{"$nulls":7},0,{"$nulls":5},"Glasshouse equipment - 10 years"]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[null,"Investment in perennial crops"]
[null,"Fruit tree",null,null,12500,5,12,{"$f":"IF(G38=0,0,+IF((+G38-F38)<0,\"amorti   \",(E38*((1+$G$3)^(G38-F38)))/G38))","v":1041.6666666666667}]
[null,"Please select",{"$nulls":5},{"$f":"IF(G39=0,0,+IF((+G39-F39)<0,\"amorti   \",(E39*((1+$G$3)^(G39-F39)))/G39))","v":0}]
[null,"Please select",{"$nulls":5},{"$f":"IF(G40=0,0,+IF((+G40-F40)<0,\"amorti   \",(E40*((1+$G$3)^(G40-F40)))/G40))","v":0}]
[{"$nulls":7},{"$f":"IF(G41=0,0,+IF((+G41-F41)<0,\"amorti   \",(E41*((1+$G$3)^(G41-F41)))/G41))","v":0}]
[{"$nulls":7},{"$f":"IF(G42=0,0,+IF((+G42-F42)<0,\"amorti   \",(E42*((1+$G$3)^(G42-F42)))/G42))","v":0}]
[]
[null,"TOTAL ANNUAL DEPRECIATION needed for replacement",{"$nulls":4},{"$f":"'1 General Information'!D14","v":"€"},{"$f":"+SUM(H11:H42)","v":99579.468811770101}]

{"sheet":"3 Fixed Costs & Financing","index":3,"n_rows":64,"n_cols":15,"rows_kept":64,"cut":false,"hidden":false,"merged":[[3,12,3,13],[1,1,1,14],[0,0,0,14],[19,7,19,8],[55,1,55,8],[18,1,18,14],[20,6,22,6],[20,7,21,8],[22,7,22,8],[33,1,33,9],[44,1,44,9],[20,1,22,1],[20,2,22,2],[20,3,22,3],[20,4,22,4],[20,5,22,5]]}
["DESIGN 06 - Farm Analysis Tool"]
[null,"4 FIXED COSTS"]
[]
[{"$nulls":11},"Farm code",{"$f":"'1 General Information'!C6","v":"Nam_123456789"}]
[]
[null,"Month","January","February","March","April","May","June","July","August","September","October","November","December","Total"]
[null,"Type of costs",1,2,3,4,5,6,7,8,9,10,11,12]
[null,"Maintenance & repair of equipment",{"$nulls":12},{"$f":"+SUM(C8:N8)","v":0}]
[null,"Fuel & lubricants \n(except for irrigation pumps)",{"$nulls":12},{"$f":"+SUM(C9:N9)","v":0}]
[null,"Water electricity, gaz",{"$nulls":12},0]
[null,"Transport \n(e.g. to the market) ",{"$nulls":12},0]
[null,"Membership fees \n(farmer organsisations)",{"$nulls":12},0]
[null,"Insurance costs",{"$nulls":12},0]
[null,"Other non-variable costs",{"$nulls":12},{"$f":"+SUM(C14:N14)","v":0}]
[null,"TOTAL per month",{"$f":"+SUM(C8:C14)","v":0},{"$f":"+SUM(D8:D14)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(O8:O14)","v":0}]
[null,"Land tax",{"$nulls":12},0]
[null,"Social fund contribution",{"$nulls":12},0]
[null,"Other farm taxes",{"$nulls":12},0]
[null,"CREDIT AND FINANCING (current)"]
[]
[null,"Bank name","Loan amount","Credit period (months)","Month of taking credit","Year of taking credit","Annual interest rate","Monthly loan repayment"]
[]
[]
[null,"Test Bank",50000,36,1,2017,0.2,{"$f":"IFERROR((J36+J47)/D24,0)","v":1944.4444444444443}]
[null,"tt",40000,10,3,2017,0.15,{"$f":"IFERROR((J37+J48)/D25,0)","v":4500}]
[{"$nulls":7},{"$f":"IFERROR((J38+J49)/D26,0)","v":0}]
[{"$nulls":7},{"$f":"IFERROR((J39+J50)/D27,0)","v":0}]
[{"$nulls":7},{"$f":"IFERROR((J40+J51)/D28,0)","v":0}]
[{"$nulls":7},0]
[{"$nulls":7},0]
[null,"TOTAL CREDIT",{"$f":"SUM(C24:C30)","v":90000},{"$nulls":4},{"$f":"SUM(H24:H30)","v":6444.4444444444443}]
[]
[]
[null,"Repayment of loan / financing amount"]
[null,"1st year","2nd year","3rd year","4th year","5th year","6th year","7th year","8th year","Total"]
[null,{"$f":"IF(ISBLANK($C$24),\"\",+B58/$D24*$C24)","v":16666.666666666664},{"$f":"IF(ISBLANK($C$24),\"\",+C58/$D24*$C24)","v":16666.666666666664},{"$f":"IF(ISBLANK($C$24),\"\",+D58/$D24*$C24)","v":16666.666666666664},0,0,0,0,0,{"$f":"+SUM(B36:I36)","v":49999.999999999993}]
[null,{"$f":"IF(ISBLANK($C$25),\"\",+B59/$D25*$C25)","v":40000},{"$f":"IF(ISBLANK($C$25),\"\",+C59/$D25*$C25)","v":0},{"$f":"IF(ISBLANK($C$25),\"\",+D59/$D25*$C25)","v":0},0,0,0,0,0,{"$f":"+SUM(B37:I37)","v":40000}]
[null,{"$f":"IF(ISBLANK($C$26),\"\",+B60/$D26*$C26)","v":""},{"$f":"IF(ISBLANK($C$26),\"\",+C60/$D26*$C26)","v":""},{"$f":"IF(ISBLANK($C$26),\"\",+D60/$D26*$C26)","v":""},"","","","","",0]
[null,{"$f":"IF(ISBLANK($C$27),\"\",+B61/$D27*$C27)","v":""},{"$f":"IF(ISBLANK($C$27),\"\",+C61/$D27*$C27)","v":""},{"$f":"IF(ISBLANK($C$27),\"\",+D61/$D27*$C27)","v":""},"","","","","",0]
[null,{"$f":"IF(ISBLANK($C$28),\"\",+B62/$D28*$C28)","v":""},{"$f":"IF(ISBLANK($C$28),\"\",+C62/$D28*$C28)","v":""},{"$f":"IF(ISBLANK($C$28),\"\",+D62/$D28*$C28)","v":""},"","","","","",0]
[null,{"$f":"IF(ISBLANK($C$29),\"\",+B63/$D29*$C29)","v":""},{"$f":"IF(ISBLANK($C$29),\"\",+C63/$D29*$C29)","v":""},{"$f":"IF(ISBLANK($C$29),\"\",+D63/$D29*$C29)","v":""},"","","","","",0]
[null,{"$f":"IF(ISBLANK($C$30),\"\",+B64/$D30*$C30)","v":""},{"$f":"IF(ISBLANK($C$30),\"\",+C64/$D30*$C30)","v":""},{"$f":"IF(ISBLANK($C$30),\"\",+D64/$D30*$C30)","v":""},"","","","","",0]
[null,{"$f":"SUM(B36:B42)","v":56666.666666666664},{"$f":"SUM(C36:C42)","v":16666.666666666664},16666.666666666664,0,0,0,0,0]
[]
[null,"Interest payments"]
[null,"1st year","2nd year","3rd year","4th year","5th year","6th year","7th year","8th year","Total"]
[null,{"$f":"IF(ISERROR(+B58/12*$G24*$C24),\"\",+B58/12*$G24*$C24)","v":10000},{"$f":"IF(ISERROR(+C58/12*$G24*($C24-$B36)),\"\",+C58/12*$G24*($C24-$B36))","v":6666.6666666666679},{"$f":"IF(ISERROR(+D58/12*$G24*($C24-$B36-$C36)),\"\",+D58/12*$G24*($C24-$B36-$C36))","v":3333.3333333333344},{"$f":"IF(ISERROR(+E58/12*$G24*($C24-$B36-$C36-$D36)),\"\",+E58/12*$G24*($C24-$B36-$C36-$D36))","v":0},{"$f":"IF(ISERROR(+F58/12*$G24*($C24-$B36-$C36-$D36-$E36)),\"\",+F58/12*$G24*($C24-$B36-$C36-$D36-$E36))","v":0},{"$f":"IF(ISERROR(+G58/12*$G24*($C24-$B36-$C36-$D36-$E36-$F36)),\"\",56/12*$G24*($C24-$B36-$C36-$D36-$E36-$F36))","v":6.7908937732378651E-12},{"$f":"IF(ISERROR(+H58/12*$G24*($C24-$B36-$C36-$D36-$E36-$F36-$G36)),\"\",+H58/12*$G24*($C24-$B36-$C36-$D36-$E36-$E36-$F36-$G36))","v":0},{"$f":"IF(ISERROR(+I58/12*$G24*($C24-$B36-$C36-$D36-$E36-$F36-$G36-$H36)),\"\",+I58/12*$G24*($C24-$B36-$C36-$D36-$E36-$F36-$G36-$H36))","v":0},{"$f":"+SUM(B47:I47)","v":20000.000000000011}]
[null,5000,{"$f":"IF(ISERROR(+C59/12*$G25*($C25-$B37)),\"\",+C59/12*$G25*($C25-$B37))","v":0},0,0,0,0,0,0,{"$f":"+SUM(B48:I48)","v":5000}]
[null,0,{"$f":"IF(ISERROR(+C60/12*$G26*($C26-$B38)),\"\",+C60/12*$G26*($C26-$B38))","v":""},"","","","","","",0]
[null,0,"","","","","","","",0]
[null,0,"","","","","","","",0]
[null,0,"","","","","","","",0]
[null,0,"","","","","","","",0]
[null,{"$f":"SUM(B47:B53)","v":15000},{"$f":"SUM(C47:C53)","v":6666.6666666666679},3333.3333333333344,0,0,6.7908937732378651E-12,0,0]
[]
[null,"Annual duration of credit / financing services (months)"]
[null,"1st year","2nd year","3rd year","4th year","5th year","6th year","7th year","8th year"]
[null,{"$f":"+IF(12-$E24+1<$D24,12-$E24+1,$D24)","v":12},{"$f":"+IF($D24-$B58>=12,12,$D24-$B58)","v":12},{"$f":"+IF($D24-SUM($B58:$C58)>=12,12,$D24-SUM($B58:$C58))","v":12},{"$f":"+IF($D24-SUM($B58:$D58)>=12,12,$D24-SUM($B58:$D58))","v":0},{"$f":"+IF($D24-SUM($B58:$E58)>=12,12,$D24-SUM($B58:$E58))","v":0},{"$f":"+IF($D24-SUM($B58:$F58)>=12,12,$D24-SUM($B58:$F58))","v":0},{"$f":"+IF($D24-SUM($B58:$G58)>=12,12,$D24-SUM($B58:$G58))","v":0},{"$f":"+IF($D24-SUM($B58:$H58)>=12,12,$D24-SUM($B58:$H58))","v":0}]
[null,10,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0]

{"sheet":"4 Seasonal Crops","index":4,"n_rows":77,"n_cols":9,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,1,1,6],[7,1,7,6],[19,1,19,6],[66,1,66,6],[55,1,55,6],[23,1,23,6],[29,1,29,6],[35,1,35,6],[48,1,48,6],[62,1,62,6]]}
["DESIGN 06 - Farm Analysis Tool"]
[null,"4 SEASONAL CROP GROSS PROFIT CALCULATION"]
[]
[{"$nulls":4},"Farm code",{"$f":"'1 General Information'!C6","v":"Nam_123456789"}]
[]
[null,"Agricultural land used:",{"$f":"SUM(C10:C14)","v":4},{"$f":"'1 General Information'!D15","v":"ha"}]
[null,null,null,"Unit","Quantity","Unit Price","Value"]
[null,"Sales"]
[null,"Crop types:","Area:"]
[null,"rice ",1,"kg",1400,500,{"$f":"+F10*E10","v":700000}]
[null,"potatoes",1,"kg",1400,500,{"$f":"+F11*E11","v":700000}]
[null,"maize",1,"kg",1000,500,{"$f":"+F12*E12","v":500000}]
[null,"fodder",1,"kg",1400,500,700000]
[null,null,null,"kg",1400,500,700000]
[null,"By-products:"]
[null,"Compost",null,"bags",500,120,{"$f":"+F16*E16","v":60000}]
[null,"Hay",null,"bale",500,120,60000]
[{"$nulls":6},0]
[null,"GROSS PRODUCT",{"$nulls":4},{"$f":"SUM(G10:G18)","v":3420000}]
[null,"Seeds"]
[null,"Local seeds",null,"kg",100,null,{"$f":"+F21*E21","v":0}]
[null,"Certified seeds",null,"kg",80,40,{"$f":"+F22*E22","v":3200}]
[null,null,"Sub-Total",null,null,null,{"$f":"+G22+G21","v":3200}]
[null,"Manure & Fertiliser"]
[null,"Manure",null,"kg",300,50,{"$f":"+F25*E25","v":15000}]
[null,"N",null,"kg",120,250,{"$f":"+F26*E26","v":30000}]
[null,"P",null,"kg",80,380,{"$f":"+F27*E27","v":30400}]
[null,"K",null,"kg",50,90,{"$f":"+F28*E28","v":4500}]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G25:G28)","v":79900}]
[null,"Plant Protection"]
[null,"Herbicides",null,"kg or litres",10,1300,{"$f":"+F31*E31","v":13000}]
[null,"Insecticides",null,"kg or litres",null,null,{"$f":"+F32*E32","v":0}]
[null,"Fungicides",null,"kg or litres",null,null,{"$f":"+F33*E33","v":0}]
[null,"Others",null,"kg or litres",null,null,{"$f":"+F34*E34","v":0}]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G31:G34)","v":13000}]
[null,"Labour (family, permanent staff and temporary staff)"]
[null,"Labour type","Number of labour type:"]
[null,"Family member",1,"months",12,200,{"$f":"+F38*E38*C38","v":2400},null,"Family member"]
[null,"Family member",2,"months",8,200,{"$f":"+F39*E39*C39","v":3200},null,"Permanent staff"]
[null,"Family member",null,"months",null,null,{"$f":"+F40*E40*C40","v":0},null,"Temporary staff"]
[null,"Family member",null,"months",null,null,{"$f":"+F41*E41*C41","v":0}]
[null,"Family member",1,"months",12,250,3000]
[null,"Family member",null,"months",null,null,0]
[null,"Family member",null,"months",null,null,0]
[null,"Family member",5,"days",40,10,2000]
[null,null,null,"days",null,null,0]
[null,null,null,"days",null,null,0]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G38:G47)","v":10600}]
[null,"Traction and Mechanisation (own equipment and hired services)"]
[null,"Ploughing / tillage",null,"days",4,800,{"$f":"+F50*E50","v":3200}]
[null,"Transport",null,"trips",4,1200,4800]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G50:G54)","v":8000}]
[null,"Infrastructure (maintenance and expansion)"]
[null,"Fence repairs",null,null,4,800,{"$f":"+F57*E57","v":3200}]
[null,"Irrigation system repair",null,null,3,1200,3600]
[null,"New greenhouse",{"$nulls":4},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G57:G61)","v":6800}]
[null,"Irrigation"]
[null,"Water fees",null,null,1,400,{"$f":"+F64*E64","v":400}]
[null,"Fuel / energie",null,null,1,5000,{"$f":"+F65*E65","v":5000}]
[null,null,"Sub-Total",null,null,null,{"$f":"+G65+G64","v":5400}]
[null,"Other costs"]
[null,"Post-harvest operations",null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,{"$f":"E68*F68","v":0}]
[null,"Packaging materials",null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,{"$f":"E69*F69","v":0}]
[null,"Processing",null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,0]
[null,"Processing",null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,0]
[null,"Marketing",null,{"$f":"'1 General Information'!$D$14","v":"€"},2,700,1400]
[null,null,"Sub-Total",null,null,null,{"$f":"SUM(G68:G72)","v":1400}]
[]
[null,"TOTAL VARIABLE COSTS",{"$nulls":4},{"$f":"+G73+G66+G62+G48+G35+G29+G23","v":120300}]
[]
[null,"GROSS PROFIT",{"$nulls":4},{"$f":"+G19-G75","v":3299700}]

{"sheet":"5 Perennial Crops","index":5,"n_rows":79,"n_cols":9,"rows_kept":79,"cut":false,"hidden":false,"merged":[[50,1,50,6],[64,1,64,6],[68,1,68,6],[57,1,57,6],[37,1,37,6],[31,1,31,6],[0,0,0,6],[1,1,1,6],[7,1,7,6],[19,1,19,6],[25,1,25,6]]}
["DESIGN 06 - Farm Analysis Tool"]
[null,"5 PERENNIAL CROP GROSS PROFIT CALCULATION"]
[]
[{"$nulls":4},"Farm code",{"$f":"'1 General Information'!C6","v":"Nam_123456789"}]
[]
[null,"Agricultural land used:",{"$f":"SUM(C10:C14)","v":6},{"$f":"'1 General Information'!D15","v":"ha"}]
[null,null,null,"Unit","Quantity","Unit Price","Value"]
[null,"Sales"]
[null,"Crop types:","Area:"]
[null,"date palm",1,"kg",1400,500,{"$f":"+F10*E10","v":700000}]
[null,"pomegranat",1,"kg",1400,500,{"$f":"+F11*E11","v":700000}]
[null,"citrus",4,"kg",1000,500,500000]
[null,null,null,"kg",null,500,0]
[null,null,null,"kg",null,500,0]
[null,"By-products:"]
[null,"Compost",null,"bags",500,120,{"$f":"+F16*E16","v":60000}]
[null,"Wood",null,"bundles",500,120,{"$f":"+F17*E17","v":60000}]
[{"$nulls":6},0]
[null,"GROSS PRODUCT",{"$nulls":4},{"$f":"SUM(G10:G18)","v":2020000}]
[null,"Seedlings"]
[null,"Local Seedlings",null,"no.",null,null,{"$f":"+F21*E21","v":0}]
[null,"Nursery Seedlings",null,"no.",80,400,{"$f":"+F22*E22","v":32000}]
[null,"Other establishment cost (juvenile phase)",null,{"$f":"'1 General Information'!D20","v":0},null,null,{"$f":"F23","v":0}]
[null,"Duration of juvenile phase",null,"years",3,null,{"$f":"SUM(G21:G23)","v":32000}]
[null,null,"Sub-Total",null,null,null,{"$f":"IF(+G24=0,0,(+G22+G21+G23)/E24)","v":10666.666666666666}]
[null,"Manure & Fertiliser"]
[null,"Manure",null,"kg",300,50,{"$f":"+F27*E27","v":15000}]
[null,"N",null,"kg",120,250,{"$f":"+F28*E28","v":30000}]
[null,"P",null,"kg",80,380,{"$f":"+F29*E29","v":30400}]
[null,"K",null,"kg",50,20,{"$f":"+F30*E30","v":1000}]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G27:G30)","v":76400}]
[null,"Plant Protection"]
[null,"Herbicides",null,"kg or litres",10,1300,{"$f":"+F33*E33","v":13000}]
[null,"Insecticides",null,"kg or litres",19,1000,{"$f":"+F34*E34","v":19000}]
[null,"Fungicides",null,"kg or litres",null,null,{"$f":"+F35*E35","v":0}]
[null,"Others",null,"kg or litres",null,null,{"$f":"+F36*E36","v":0}]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G33:G36)","v":32000}]
[null,"Labour (family, permanent staff and temporary staff)"]
[null,"Labour type","Number of labour type:"]
[null,"Family member",1,"months",12,200,{"$f":"+F40*E40*C40","v":2400},null,"Family member"]
[null,"Family member",2,"months",8,200,{"$f":"+F41*E41*C41","v":3200},null,"Permanent staff"]
[null,"Family member",null,"months",null,null,{"$f":"+F42*E42*C42","v":0},null,"Temporary staff"]
[null,"Family member",null,"months",null,null,{"$f":"+F43*E43*C43","v":0}]
[null,"Family member",1,"months",12,250,{"$f":"+F44*E44*C44","v":3000}]
[null,"Family member",null,"months",null,null,0]
[null,"Family member",null,"months",null,null,0]
[null,"Family member",5,"days",40,10,2000]
[null,null,null,"days",null,null,0]
[null,null,null,"days",null,null,0]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G40:G49)","v":10600}]
[null,"Traction and Mechanisation (own equipment and hired services)"]
[null,"Ploughing / tillage",null,"days",4,800,{"$f":"+F52*E52","v":3200}]
[null,"Transport",null,"trips",1,1200,1200]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G52:G56)","v":4400}]
[null,"Infrastructure (maintenance and expansion)"]
[null,"Fence repairs",null,null,4,800,{"$f":"+F59*E59","v":3200}]
[null,"Irrigation system repair",null,null,3,1200,3600]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G59:G63)","v":6800}]
[null,"Irrigation"]
[null,"Water fees",null,null,1,400,{"$f":"+F66*E66","v":400}]
[null,"Fuel / energie",null,null,1,5000,{"$f":"+F67*E67","v":5000}]
[null,null,"Sub-Total",null,null,null,{"$f":"+G67+G66","v":5400}]
[null,"Other costs"]
[null,"Post-harvest operations",null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,{"$f":"E70*F70","v":0}]
[null,"Packaging materials",null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,{"$f":"E71*F71","v":0}]
[null,"Processing",null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,0]
[null,"Processing",null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,0]
[null,"Marketing",null,{"$f":"'1 General Information'!$D$14","v":"€"},2,700,1400]
[null,null,"Sub-Total",null,null,null,{"$f":"SUM(G70:G74)","v":1400}]
[]
[null,"TOTAL VARIABLE COSTS",{"$nulls":4},{"$f":"+G75+G68+G64+G50+G37+G31+G25","v":143266.66666666666}]
[]
[null,"GROSS PROFIT",{"$nulls":4},{"$f":"+G19-G77","v":1876733.3333333333}]

{"sheet":"6 Livestock","index":6,"n_rows":89,"n_cols":9,"rows_kept":89,"cut":false,"hidden":false,"merged":[[58,1,58,6],[72,1,72,6],[76,1,76,6],[65,1,65,6],[45,1,45,6],[0,0,0,6],[1,1,1,6],[7,1,7,6],[30,1,30,6],[39,1,39,6]]}
["DESIGN 06 - Farm Analysis Tool"]
[null,"6 LIVESTOCK GROSS PROFIT CALCULATION"]
[]
[{"$nulls":4},"Farm code",{"$f":"'1 General Information'!C6","v":"Nam_123456789"}]
[]
[null,"Livestock sold:",{"$f":"SUM(E10:E23)","v":10},"head"]
[null,null,null,"Unit","Quantity","Unit Price","Value"]
[null,"Sales"]
[null,"Livestock type"]
[null,"Dairy cows (0,7 TLU)",null,"head",10,500,{"$f":"+F10*E10","v":5000}]
[null,"Heifers (0,5 TLU)",null,"head",null,null,{"$f":"+F11*E11","v":0}]
[null,"Adult steers / bullocks (0,7 TLU)",null,"head",null,null,0]
[null,"Juvenile steers / bullocks (0,5 TLU)",null,"head",null,null,0]
[null,"Calfs (0,2 TLU)",null,"head",null,null,0]
[null,"Sheep does (0,1 TLU)",null,"head",null,null,0]
[null,"Sheep bucks (0,1 TLU)",null,"head",null,null,0]
[null,"Sheep kids (0,0 TLU)",null,"head",null,null,0]
[null,"Goat does (0,1 TLU)",null,"head",null,null,0]
[null,"Goat bucks (0,1 TLU)",null,"head",null,null,0]
[null,"Goat kids (0,0 TLU)",null,"head",null,null,0]
[null,"Chickens",null,"head",null,null,0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[null,"By-products:"]
[null,"Milk",null,"litres",500,120,{"$f":"+F25*E25","v":60000}]
[null,"Eggs",null,null,500,120,{"$f":"+F26*E26","v":60000}]
[null,"Skins",{"$nulls":4},{"$f":"+F27*E27","v":0}]
[null,"Manure",{"$nulls":4},{"$f":"+F28*E28","v":0}]
[{"$nulls":6},0]
[null,"GROSS PRODUCT",{"$nulls":4},{"$f":"SUM(G10:G29)","v":125000}]
[null,"Fodder & Fodder Concentrates"]
[null,"Regular base fodder",null,"kg",null,null,{"$f":"+F32*E32","v":0}]
[null,"Special fodder",null,"kg",80,400,{"$f":"+F33*E33","v":32000}]
[null,"Composed concentrates",{"$nulls":4},0]
[null,"Husks",{"$nulls":4},0]
[null,"Sunflower oil cakes",{"$nulls":4},0]
[null,"Grains",{"$nulls":4},0]
[null,"Milk powder",null,null,3,null,0]
[null,null,"Sub-Total",null,null,null,{"$f":"SUM(G32:G38)","v":32000}]
[null,"Veterinary Services"]
[null,"Vaccination",null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,{"$f":"+F41*E41","v":0}]
[null,"Inspections",null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,{"$f":"+F42*E42","v":0}]
[null,null,null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,{"$f":"+F43*E43","v":0}]
[null,null,null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,{"$f":"+F44*E44","v":0}]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G41:G44)","v":0}]
[null,"Labour (family, permanent staff and temporary staff)"]
[null,"Labour type","Number of labour type:"]
[null,"Family member",1,"months",12,200,{"$f":"+F48*E48*C48","v":2400},null,"Family member"]
[null,"Family member",2,"months",8,200,{"$f":"+F49*E49*C49","v":3200},null,"Permanent staff"]
[null,"Family member",null,"months",null,null,{"$f":"+F50*E50*C50","v":0},null,"Temporary staff"]
[null,"Family member",null,"months",null,null,{"$f":"+F51*E51*C51","v":0}]
[null,"Family member",1,"months",12,250,{"$f":"+F52*E52*C52","v":3000}]
[null,"Family member",null,"months",null,null,0]
[null,"Family member",null,"months",null,null,0]
[null,"Family member",5,"days",40,10,2000]
[null,null,null,"days",null,null,0]
[null,null,null,"days",null,null,0]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G48:G57)","v":10600}]
[null,"Traction and Mechanisation (own equipment and hired services)"]
[null,"Ploughing / tillage",null,"days",4,800,{"$f":"+F60*E60","v":3200}]
[null,"Transport",null,"trips",3,1200,3600]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G60:G64)","v":6800}]
[null,"Infrastructure (maintenance and expansion)"]
[null,"Fence repair",null,{"$f":"'1 General Information'!$D$14","v":"€"},4,800,{"$f":"+F67*E67","v":3200}]
[null,"New shed",null,{"$f":"'1 General Information'!$D$14","v":"€"},1,30000,30000]
[null,null,null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,0]
[null,null,null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,0]
[null,null,null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,0]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G67:G71)","v":33200}]
[null,"Water supply"]
[null,"Water fees",null,null,1,400,{"$f":"+F74*E74","v":400}]
[null,"Fuel / energie",null,null,1,5000,{"$f":"+F75*E75","v":5000}]
[null,null,"Sub-Total",null,null,null,{"$f":"+G75+G74","v":5400}]
[null,"Other costs"]
[null,"Cooling services",null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,{"$f":"E78*F78","v":0}]
[null,"Abattoir services",null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,{"$f":"E79*F79","v":0}]
[null,"Packaging materials",null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,0]
[null,"Pasture leasing",null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,0]
[null,"Processing",null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,0]
[null,"Marketing",null,{"$f":"'1 General Information'!$D$14","v":"€"},null,null,0]
[null,null,null,{"$f":"'1 General Information'!$D$14","v":"€"},2,700,{"$f":"E84*F84","v":1400}]
[null,null,"Sub-Total",null,null,null,{"$f":"SUM(G78:G84)","v":1400}]
[]
[null,"TOTAL VARIABLE COSTS",{"$nulls":4},{"$f":"+G85+G76+G72+G58+G65+G45+G39","v":89400}]
[]
[null,"GROSS PROFIT",{"$nulls":4},{"$f":"+G30-G87","v":35600}]

{"sheet":"7 Summary","index":7,"n_rows":12,"n_cols":19,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,18],[0,1,0,18],[3,2,3,5],[5,1,7,1],[6,2,7,2],[6,18,7,18]]}
[null,"DESIGN 06 - Farm Analysis Tool"]
[null,"7 SUMMARY OF GROSS MARGINS"]
[]
[null,"Farm code",{"$f":"'1 General Information'!C6","v":"Nam_123456789"}]
[]
[null,"Farm Enterprise","Area cultivated / Livestock sold","Gross Main Product","Gross \nBy-product","Gross Prodcut","Seeds / Seedlings / Establishment","Fodder / Fodder Concentrates","Manure / Fertiliser","Veterinary Services","Plant Protection","Labour","Traction / Mechanisation","Infrastructure","Irrigation / Water supply","Other Costs","Total Variable Costs","Gross Profit","Share of enterprise at total GM"]
[null,null,"ha / head",{"$f":"'1 General Information'!D14","v":"€"},{"$f":"'1 General Information'!D14","v":"€"},{"$f":"'1 General Information'!D14","v":"€"},{"$f":"F7","v":"€"},{"$f":"G7","v":"€"},{"$f":"F7","v":"€"},{"$f":"H7","v":"€"},{"$f":"F7","v":"€"},{"$f":"G7","v":"€"},{"$f":"I7","v":"€"},{"$f":"J7","v":"€"},{"$f":"K7","v":"€"},{"$f":"L7","v":"€"},{"$f":"M7","v":"€"},{"$f":"Q7","v":"€"},"%"]
[null,null,null,"total","total","total","total","total","total","total","total","total","total","total","total","total","total","per farm enterprise"]
[null,"Seasonal crops",{"$f":"'4 Seasonal Crops'!C6","v":4},{"$f":"SUM('4 Seasonal Crops'!G10:G14)","v":3300000},{"$f":"SUM('4 Seasonal Crops'!G16:G18)","v":120000},{"$f":"'4 Seasonal Crops'!G19","v":3420000},{"$f":"'4 Seasonal Crops'!G23","v":3200},null,{"$f":"'4 Seasonal Crops'!G29","v":79900},null,{"$f":"'4 Seasonal Crops'!G35","v":13000},{"$f":"'4 Seasonal Crops'!G48","v":10600},{"$f":"'4 Seasonal Crops'!G55","v":8000},{"$f":"'4 Seasonal Crops'!G62","v":6800},{"$f":"'4 Seasonal Crops'!G66","v":5400},{"$f":"'4 Seasonal Crops'!G73","v":1400},{"$f":"'4 Seasonal Crops'!G75","v":120300},{"$f":"'4 Seasonal Crops'!G77","v":3299700},{"$f":"IF($R$12=0,0,+R9/$R$12)","v":0.6330926509807433}]
[null,"Perennial crops",{"$f":"'5 Perennial Crops'!C6","v":6},{"$f":"SUM('5 Perennial Crops'!G10:G14)","v":1900000},{"$f":"SUM('5 Perennial Crops'!G16:G18)","v":120000},{"$f":"'5 Perennial Crops'!G19","v":2020000},{"$f":"'5 Perennial Crops'!G25","v":10666.666666666666},null,{"$f":"'5 Perennial Crops'!G31","v":76400},null,{"$f":"'5 Perennial Crops'!G37","v":32000},{"$f":"'5 Perennial Crops'!G50","v":10600},{"$f":"'5 Perennial Crops'!G57","v":4400},{"$f":"'5 Perennial Crops'!G64","v":6800},{"$f":"'5 Perennial Crops'!G68","v":5400},{"$f":"'5 Perennial Crops'!G75","v":1400},{"$f":"'5 Perennial Crops'!G77","v":143266.66666666666},{"$f":"'5 Perennial Crops'!G79","v":1876733.3333333333},{"$f":"IF($R$12=0,0,+R10/$R$12)","v":0.36007700129827769}]
[null,"Livestock",{"$f":"'6 Livestock'!C6","v":10},{"$f":"SUM('6 Livestock'!G10:G23)","v":5000},{"$f":"SUM('6 Livestock'!G25:G29)","v":120000},{"$f":"'6 Livestock'!G30","v":125000},null,{"$f":"'6 Livestock'!G39","v":32000},null,{"$f":"'6 Livestock'!G45","v":0},null,{"$f":"'6 Livestock'!G58","v":10600},null,{"$f":"'6 Livestock'!G72","v":33200},{"$f":"'6 Livestock'!G76","v":5400},{"$f":"'6 Livestock'!G85","v":1400},{"$f":"'6 Livestock'!G87","v":89400},{"$f":"'6 Livestock'!G89","v":35600},{"$f":"IF($R$12=0,0,+R11/$R$12)","v":6.8303477209790166E-3}]
[null,"Sub-Total (for entire farm)",null,{"$f":"SUM(D9:D11)","v":5205000},{"$f":"SUM(E9:E11)","v":360000},5565000,13866.666666666666,32000,156300,0,45000,31800,12400,46800,16200,4200,{"$f":"SUM(Q9:Q11)","v":352966.66666666663},{"$f":"SUM(R9:R11)","v":5212033.333333333},{"$f":"SUM(S9:S11)","v":1}]

{"sheet":"8 Farm Income Statement","index":8,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[[48,3,48,5],[49,2,49,5],[1,1,1,8],[3,6,3,7],[0,0,0,8],[46,3,46,5],[47,3,47,5]]}
["DESIGN 06 - Farm Analysis Tool"]
[null,"8 FARM INCOME STATEMENT (incl. family labour and own equipment)"]
[]
[{"$nulls":5},"Farm code",{"$f":"'1 General Information'!C6","v":"Nam_123456789"}]
[]
[null,null,"+","Gross value of seasonal crop production",{"$f":"'7 Summary'!D9","v":3300000},{"$f":"'1 General Information'!$D$14","v":"€"},"+",{"$f":"IF($E$13=0,0,+E6/$E$13)","v":0.59293863983469586}]
[null,null,"+","Gross value of seasonal crop by-product production",{"$f":"'7 Summary'!E9","v":120000},{"$f":"'1 General Information'!$D$14","v":"€"},"+",2.1561405084898032E-2]
[null,null,"+","Gross value of perennial crop production",{"$f":"'7 Summary'!D10","v":1900000},{"$f":"'1 General Information'!$D$14","v":"€"},"+",0.34138891384421882]
[null,null,"+","Gross value of perennial crop by-product production",{"$f":"'7 Summary'!E10","v":120000},{"$f":"'1 General Information'!$D$14","v":"€"},"+",2.1561405084898032E-2]
[null,null,"+","Gross value of livestock production: ",{"$f":"'7 Summary'!D11","v":5000},{"$f":"'1 General Information'!$D$14","v":"€"},"+",8.9839187853741806E-4]
[null,null,"+","Gross value of livestock by-product production: ",{"$f":"'7 Summary'!E11","v":120000},{"$f":"'1 General Information'!$D$14","v":"€"},"+",2.1561405084898032E-2]
[null,null,"+","Gross value of land leased out: ",{"$f":"'1 General Information'!C47","v":500},{"$f":"'1 General Information'!$D$14","v":"€"},"+",8.9839187853741804E-5]
[null,null,"=","GROSS FARM INCOME",{"$f":"+SUM(E6:E12)","v":5565500},{"$f":"'1 General Information'!$D$14","v":"€"},"=",{"$f":"SUM(H6:H12)","v":0.99999999999999989}]
[]
[null,null,"-","Anticipated losses of total sales",0.1,"%"]
[]
[null,null,"-","Variable costs",{"$f":"'7 Summary'!Q12","v":352966.66666666663},{"$f":"'1 General Information'!$D$14","v":"€"}]
[null,null,"-","Other variable costs",null,{"$f":"'1 General Information'!$D$14","v":"€"}]
[null,null,"-","Depreciation",{"$f":"'2 Equipment & Assets'!H44","v":99579.468811770101},{"$f":"'1 General Information'!$D$14","v":"€"}]
[null,null,"-","Fixed costs: Maintenance & repair of equipment",{"$f":"'3 Fixed Costs & Financing'!O8","v":0},{"$f":"'1 General Information'!$D$14","v":"€"}]
[null,null,"-","Fixed costs: Fuel & lubricants",{"$f":"'3 Fixed Costs & Financing'!O9","v":0},{"$f":"'1 General Information'!$D$14","v":"€"}]
[null,null,"-","Fixed costs: Water, electricity, gas",{"$f":"'3 Fixed Costs & Financing'!O10","v":0},{"$f":"'1 General Information'!$D$14","v":"€"}]
[null,null,"-","Fixed costs: Transport",{"$f":"'3 Fixed Costs & Financing'!O11","v":0},{"$f":"'1 General Information'!$D$14","v":"€"}]
[null,null,"-","Fixed costs: Interest payment",{"$f":"'3 Fixed Costs & Financing'!H31","v":6444.4444444444443},{"$f":"'1 General Information'!$D$14","v":"€"}]
[null,null,"-","Fixed costs: Land leased in",{"$f":"'1 General Information'!C44","v":300},{"$f":"'1 General Information'!$D$14","v":"€"}]
[null,null,"-","Other non-variable costs",{"$f":"'3 Fixed Costs & Financing'!O14","v":0},{"$f":"'1 General Information'!$D$14","v":"€"}]
[null,null,"=","TOTAL EXPENSES",{"$f":"SUM(E17:E26)","v":459290.57992288115},{"$f":"'1 General Information'!$D$14","v":"€"}]
{"$rows_empty":18}
[null,null,"=","GROSS FARM PROFIT",{"$f":"\"For period\"  &   '1 General Information'!D13","v":"For period2019"},{"$f":"\"to\" & '1 General Information'!E13","v":"to2020"},{"$f":"E13-(E13*E15)-E27","v":4549659.420077119},{"$f":"'1 General Information'!$D$14","v":"€"}]
[null,null,null,"average per ha of crops",null,null,{"$f":"SUM('7 Summary'!R9:R10)/SUM('7 Summary'!C9:C10)","v":517643.33333333331},{"$f":"'1 General Information'!$D$14","v":"€"}]
[null,null,null,"average per head of livestock",null,null,{"$f":"'7 Summary'!R11/'7 Summary'!C11","v":3560},{"$f":"'1 General Information'!$D$14","v":"€"}]
[null,null,null,"total crop area under cultivation ",null,null,{"$f":"'7 Summary'!C9+'7 Summary'!C10","v":10},{"$f":"'1 General Information'!D15","v":"ha"}]
[null,null,"total number of employees (familiy, permanent and temporary staff)",null,null,null,{"$f":"SUM('4 Seasonal Crops'!C38:C47)+SUM('5 Perennial Crops'!C40:C49)+SUM('6 Livestock'!C48:C57)","v":27},"persons"]