{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["READ ME","1 General Information","2 Equipment & Assets","3 Income Crops & Livestock","4 Other Income","5 Financing","6 Fixed and Variable Costs","7 Farm Income Statement","Crop Price Calculation Sheet","Quick Check","Translate","Graph table","List of dropdown"],"not_rendered":{"charts":1,"images":13,"macros":1,"external_links":0,"defined_names":130,"comments":3,"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":"READ ME","index":0,"n_rows":115,"n_cols":7,"rows_kept":115,"cut":false,"hidden":false,"merged":[[37,3,37,9],[61,5,61,9],[31,3,31,9],[32,3,32,9],[33,3,33,9],[34,3,34,9],[10,3,10,5],[10,6,10,8],[28,3,28,9],[29,3,29,9],[30,3,30,9],[71,3,89,9],[12,3,12,9],[17,3,17,9],[19,3,19,9],[27,3,27,9],[36,3,36,9],[38,3,39,5],[38,6,39,9],[50,3,51,5],[50,6,51,9],[40,3,41,5],[40,6,41,9],[60,3,60,9],[42,3,44,5],[52,6,53,9],[52,3,53,5],[62,5,63,9],[64,3,64,4],[64,5,64,7],[48,3,49,5],[48,6,49,9],[54,6,55,9],[54,3,55,5],[56,6,58,9],[56,3,58,5],[91,3,104,9],[106,3,112,9],[114,3,114,5],[20,3,25,9],[45,6,47,9],[45,3,47,5],[42,6,44,9],[65,3,65,4],[65,5,65,9],[66,3,68,4],[66,5,67,9],[68,5,68,7],[69,3,69,4],[69,5,69,7],[61,3,61,4],[62,3,63,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Translate!C24","v":"Select language"},null,null,"English"]
[]
[null,null,null,{"$f":"Translate!$C$25","v":"Read Me Sheet"}]
[]
[]
[]
[]
[null,null,null,{"$f":"Translate!$C$26","v":"INVEST – Farm Analysis Tool"}]
[]
[null,null,null,{"$f":"Translate!$C$27","v":"Introduction"}]
[null,null,null,{"$f":"Translate!$C$28","v":"This tool allows for the assessment of on-farm productivity and profitability through its average annual agricultural production. The tool is useful for establishing a baseline or assessing the impact of planned investments. This tool allows an SPIS advisor (supplier, development practitioner, extension officer) to support a farm enterprise towards identify unnecessary costs, determine best value agricultural activities and correctly monetize different farm inputs. "}]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Translate!$C$29","v":"Tips & Tricks"}]
[null,null,null,{"$f":"Translate!$C$30","v":"● Make sure that macro is always enabled for the proper functioning of this tool  "}]
[null,null,null,{"$f":"Translate!$C$31","v":"● Only enter values into white cells"}]
[null,null,null,{"$f":"Translate!$C$32","v":"● This tool comprises drop down lists and macros to simplify data entry and results review."}]
[null,null,null,{"$f":"Translate!$C$33","v":"● For the multilanguage option to work properly, do NOT delete sheets"}]
[null,null,null,{"$f":"Translate!$C$34","v":"● This tool provides an indicative assessment of farm profitability and should be complemented by deeper and more detailed assessments, market analysis, and other due diligence, before committing to large-scale investments."}]
[null,null,null,{"$f":"Translate!$C$35","v":"● This tool contains numerous critical formulas or calculations"}]
[null,null,null,{"$f":"Translate!$C$36","v":"● Make sure that this file is always saved as \".xlsm\"    \n"}]
[]
[null,null,null,{"$f":"Translate!$C$37","v":"Overview"}]
[null,null,null,{"$f":"Translate!$C$38","v":"This tool comprises the following sheet:"}]
[null,null,null,{"$f":"Translate!$C$8","v":"1 General Information"},null,null,{"$f":"Translate!$C$39","v":"farm name, location, and area"}]
[]
[null,null,null,{"$f":"Translate!$C$9","v":"2 Equipment & Assets"},null,null,{"$f":"Translate!$C$40","v":"currently available on the farm or considered for future purchases"}]
[]
[null,null,null,{"$f":"Translate!$C$10","v":"3 Income Crops & Livestock"},null,null,{"$f":"Translate!$C$41","v":"to add current or projected sales of seasonal crops (e.g. rice, maize), perennial crops (e.g. fruits), and livestock and respective by-products "}]
[]
[]
[null,null,null,{"$f":"Translate!$C$11","v":"4 Other Income"},null,null,{"$f":"Translate!$C$42","v":"additional income not directly related to crop or livestock production such as the sale of water or rental of equipment"}]
[]
[]
[null,null,null,{"$f":"Translate!$C$12","v":"5 Financing"},null,null,{"$f":"Translate!$C$43","v":"calculates annual loan repayment based on credit information"}]
[]
[null,null,null,{"$f":"Translate!$C$13","v":"6 Fixed and Variable Costs"},null,null,{"$f":"Translate!$C$44","v":"to add all fixed and variable costs/expenditures of the farm enterprise"}]
[]
[null,null,null,{"$f":"Translate!$C$14","v":"7 Farm Income Statement"},null,null,{"$f":"Translate!$C$45","v":"No Entry! Summary calculation on gross profitability of the farm enterprise"}]
[]
[null,null,null,{"$f":"Translate!$C$15","v":"Crop Price Calculation Sheet"},null,null,{"$f":"Translate!$C$46","v":"side sheet for calculating average annual crop and livestock prices"}]
[]
[null,null,null,{"$f":"Translate!$C$16","v":"Quick Check"},null,null,{"$f":"Translate!$C$47","v":"side sheet for a quick calculation of farm profitability useful before conducting a full analysis"}]
[]
[]
[]
[null,null,null,{"$f":"Translate!$C$48","v":"About"}]
[null,null,null,{"$f":"Translate!$C$49","v":"Published by: "},null,{"$f":"Translate!$C$55","v":"GIZ & FAO"}]
[null,null,null,{"$f":"Translate!$C$50","v":"Responsible:"},null,{"$f":"Translate!$C$56","v":"GIZ project \"Water and Energy for Food (WE4F)\""}]
[]
[null,null,null,{"$f":"Translate!$C$51","v":"Contact:"},null,"we4f@giz.de"]
[null,null,null,{"$f":"Translate!$C$52","v":"Download link:"},null,"https://energypedia.info/wiki/Toolbox_on_SPIS"]
[null,null,null,{"$f":"Translate!$C$53","v":"About:"},null,{"$f":"Translate!$C$57","v":"Water and Energy for Food Grand Challenge at:  "}]
[]
[null,null,null,null,null,"https://we4f.org/"]
[null,null,null,{"$f":"Translate!$C$54","v":"Version:"},null,{"$f":"Translate!$C$58","v":"3.0 (June 2021)"}]
[]
[null,null,null,{"$f":"Translate!$C$59","v":"The Toolbox on Solar Powered Irrigation Systems (SPIS) is a legacy project of the global initiative Powering Agriculture: An Energy Grand Challenge for Development (PAEGC). In 2012, the United States Agency for International Development (USAID), the Swedish International Development Cooperation Agency (Sida), the German Federal Ministry for Economic Cooperation and Development (BMZ), Duke Energy, and the Overseas Private Investment Corporation (OPIC) combined resources to support new and sustainable approaches to accelerate the development and deployment of clean energy solutions for increasing agriculture productivity.\n\nThe Toolbox on SPIS has now been embraced for further development by PAEGC's successor program Water and Energy for Food (WE4F). WE4F is a joint international initiative of the European Union (EU), German Federal Ministry for Economic Cooperation and Development (BMZ), the Ministry of Foreign Affairs of the Kingdom of the Netherlands, Sweden through the Swedish International Development Cooperation Agency (Sida), and the U.S. Agency for International Development (USAID). WE4F aims to increase food production along the value chain through a more sustainable and efficient usage of water and/or energy."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Translate!$C$60","v":"The designations employed and the presentation of material in this information product do not imply the expression of any opinion whatsoever on the part of Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, Food and Agriculture Organization of the United Nations (FAO) or any of the PAEGC Founding Partners concerning the legal or development status of any country, territory, city or area or of its authorities, or concerning the delimitation of its frontiers or boundaries. The mention of specific companies or products of manufacturers, whether or not these have been patented, does not imply that these have been endorsed or recommended by GIZ, FAO, or any of the PAEGC Founding Partners in preference to others of a similar nature that are not mentioned. The views expressed in this information product are those of the author and do not necessarily reflect the views or policies of GIZ, FAO, or any of the PAEGC Founding Partners."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Translate!$C$61","v":"GIZ, FAO and the PAEGC Founding Partners encourage 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 and FAO as the source and copyright holder is given."}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Translate!$C$62","v":"© GIZ and FAO, 2021"}]

{"sheet":"1 General Information","index":1,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,9],[11,5,11,7],[5,7,5,9],[10,2,10,7],[15,1,15,9],[16,1,16,9],[1,1,2,9],[7,2,7,4],[9,2,9,4],[8,2,8,4],[4,2,4,4],[5,2,5,4],[4,7,4,9],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[33,7,34,7],[24,1,24,3],[25,1,25,3],[31,1,31,3],[30,1,30,3],[32,1,32,3]]}
[null,{"$f":"Translate!$C$64","v":"INVEST – Farm Analysis Tool"}]
[null,{"$f":"Translate!$C$65","v":"1 GENERAL FARM INFORMATION"}]
[]
[]
[null,{"$f":"Translate!$C$66","v":"Country"},null,null,null,null,{"$f":"Translate!$C$68","v":"Region"}]
[null,{"$f":"Translate!$C$67","v":"Farm code or name"},null,null,null,null,{"$f":"Translate!$C$69","v":"Date"}]
[]
[null,{"$f":"Translate!$C$70","v":"Village"}]
[null,{"$f":"Translate!$C$71","v":"Division"}]
[null,{"$f":"Translate!$C$72","v":"District"}]
[null,{"$f":"Translate!$C$73","v":"Assessor"}]
[null,{"$f":"Translate!$C$74","v":"Agricultural planning period (years)"},null,2021,2022,{"$f":"Translate!$C$77","v":"(year in  four digits each!)"}]
[null,{"$f":"Translate!$C$75","v":"Currency used for calculation"},null,"€"]
[null,{"$f":"Translate!$C$76","v":"Area measurement unit"},null,"ha"]
[]
[]
[null,{"$f":"Translate!$C$84","v":"LAND RESOURCES"}]
[]
[null,{"$f":"Translate!$C$85","v":"Property rights"},null,null,{"$f":"Translate!$C$93","v":"Area"}]
[null,{"$f":"Translate!$C$86","v":"+ Land owned"},null,null,1,{"$f":"+$D$14","v":"ha"}]
[null,{"$f":"Translate!$C$87","v":"+ Additional land as part of cooperative land"},null,null,null,{"$f":"+$D$14","v":"ha"}]
[null,{"$f":"Translate!$C$88","v":"+ Additional land exploited as a shared grower"},null,null,null,"ha"]
[null,{"$f":"Translate!$C$89","v":"+ Additional land leased in"},null,null,null,"ha"]
[null,{"$f":"Translate!$C$90","v":"- Own land leased out"},null,null,null,"ha"]
[null,{"$f":"Translate!$C$91","v":"+ Additional land in possession of other sources"},null,null,null,"ha"]
[null,{"$f":"Translate!$C$92","v":"-  Own land unused or unusable"},null,null,null,"ha"]
[null,null,null,{"$f":"Translate!$C$94","v":"Total"},{"$f":"+SUM(E20:E23)-E24+E25-E26","v":1},"ha"]
[]
[]
[null,{"$f":"Translate!$C$95","v":"Land classification"},null,{"$f":"Translate!$C$93","v":"Area"},{"$f":"Translate!$C$101","v":"rainfed"},{"$f":"Translate!$C$102","v":"irrigated"}]
[null,{"$f":"Translate!$C$96","v":"Seasonal crop land"},null,null,null,1,{"$f":"+$D$14","v":"ha"}]
[null,{"$f":"Translate!$C$97","v":"Perennials (with & without option of intercropping)"},null,null,null,null,"ha"]
[null,{"$f":"Translate!$C$98","v":"Greenhouses"},null,null,null,null,"ha"]
[null,{"$f":"Translate!$C$99","v":"Pastures (grazing land)"},null,null,null,null,"ha",{"$f":"Translate!$C$104","v":"Total area"}]
[null,{"$f":"Translate!$C$100","v":"Fallow land"},null,null,null,null,"ha"]
[null,{"$f":"Translate!$C$103","v":"Total agricultural / horticultural land"},null,null,{"$f":"+SUM(E31:E35)","v":0},{"$f":"+SUM(F31:F35)","v":1},"ha",{"$f":"IF(E36+F36=E27,E36+F36,Translate!$C$105)","v":1},"ha"]

{"sheet":"2 Equipment & Assets","index":2,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,1,0,6],[37,2,37,4],[5,6,8,6],[5,3,8,3],[5,2,8,2],[1,1,1,6],[3,5,3,6],[5,1,9,1],[5,4,8,4],[5,5,8,5],[3,3,3,4]]}
[null,{"$f":"Translate!$C$107","v":"INVEST – Farm Analysis Tool"}]
[null,{"$f":"Translate!$C$108","v":"2 EQUIPMENT & ASSETS"}]
[]
[null,null,null,{"$f":"Translate!$C$109","v":"Farm code/name"},null,{"$f":"'1 General Information'!C6","v":0}]
[]
[null,{"$f":"Translate!$C$110","v":"Type"},{"$f":"Translate!$C$111","v":"Cost of existing equipment (when originally purchased)"},{"$f":"Translate!$C$112","v":"Salvage value (when selling existing equipment)"},{"$f":"Translate!$C$113","v":"Age"},{"$f":"Translate!$C$114","v":"Normal life span"},{"$f":"Translate!$C$115","v":"Annual depreciation for replacement"}]
[]
[]
[]
[null,null,{"$f":"'1 General Information'!D13","v":"€"},{"$f":"'1 General Information'!D13","v":"€"},{"$f":"Translate!$C$116","v":"years"},{"$f":"Translate!$C$116","v":"years"},{"$f":"'1 General Information'!D13","v":"€"}]
[null,"Please select",60000,10000,2,20,{"$f":"IFERROR(SLN(C11,D11,(F11-E11)),\"\")","v":2777.7777777777778},{"$f":"Translate!$C$117","v":"Indicative normal life span:"},{"$f":"Translate!$C$139","v":"Please select"}]
[null,"Please select",null,null,null,null,{"$f":"IFERROR(SLN(C12,D12,(F12-E12)),\"\")","v":""},{"$f":"Translate!$C$118","v":"(highly quality dependent!)"}]
[null,"Please select",null,null,null,null,"",{"$f":"Translate!$C$119","v":"Livestock shed - 20 years"},{"$f":"Translate!$C$140","v":"Livestock shed"}]
[null,"Please select",null,null,null,null,"",{"$f":"Translate!$C$120","v":"Garage / workshop - 20 year"},{"$f":"Translate!$C$141","v":"Garage / workshop"}]
[null,"Please select",null,null,null,null,"",{"$f":"Translate!$C$121","v":"Storage / warehouse - 20 years"},{"$f":"Translate!$C$142","v":"Storage / warehouse"}]
[null,"Please select",null,null,null,null,"",{"$f":"Translate!$C$122","v":"Greenhouse - 10 years"},{"$f":"Translate!$C$143","v":"Greenhouse"}]
[null,"Please select",null,null,null,null,{"$f":"IFERROR(SLN(C17,D17,(F17-E17)),\"\")","v":""},{"$f":"Translate!$C$123","v":"Other building - 20 years"},{"$f":"Translate!$C$144","v":"Other building"}]
[null,"Please select",null,null,null,null,"",{"$f":"Translate!$C$124","v":"Ox cart - 7 years"},{"$f":"Translate!$C$145","v":"Ox cart"}]
[null,"Please select",null,null,null,null,"",{"$f":"Translate!$C$125","v":"Truck / car - 10 years"},{"$f":"Translate!$C$146","v":"Truck / car"}]
[null,"Please select",null,null,null,null,"",{"$f":"Translate!$C$126","v":"Tractor - 10 years"},{"$f":"Translate!$C$147","v":"Tractor"}]
[null,"Please select",null,null,null,null,"",{"$f":"Translate!$C$127","v":"Plough - 7 years"},{"$f":"Translate!$C$148","v":"Plough"}]
[null,"Please select",null,null,null,null,"",{"$f":"Translate!$C$128","v":"Cultivator / tiller - 7 years"},{"$f":"Translate!$C$149","v":"Cultivator / tiller"}]
[null,"Please select",null,null,null,null,"",{"$f":"Translate!$C$129","v":"Sowing machine - 7 years"},{"$f":"Translate!$C$150","v":"Sowing machine"}]
[null,"Please select",null,null,null,null,"",{"$f":"Translate!$C$130","v":"Fertilizer distributor - 7 years"},{"$f":"Translate!$C$151","v":"Fertilizer distributor"}]
[null,"Please select",null,null,null,null,"",{"$f":"Translate!$C$131","v":"Sprayer - 7 years "},{"$f":"Translate!$C$152","v":"Sprayer"}]
[null,"Please select",null,null,null,null,"",{"$f":"Translate!$C$132","v":"Grass cutter  -  7 years"},{"$f":"Translate!$C$153","v":"Grass cutter"}]
[null,"Please select",null,null,null,null,"",{"$f":"Translate!$C$133","v":"Baler - 7 years"},{"$f":"Translate!$C$154","v":"Baler"}]
[null,"Please select",null,null,null,null,"",{"$f":"Translate!$C$134","v":"Cereal harvester - 10 years"},{"$f":"Translate!$C$155","v":"Cereal harvester"}]
[null,null,null,null,null,null,"",{"$f":"Translate!$C$135","v":"Irrigation material - 5 years"},{"$f":"Translate!$C$156","v":"Irrigation material"}]
[null,null,null,null,null,null,"",{"$f":"Translate!$C$136","v":"Water pump - 7 years"},{"$f":"Translate!$C$157","v":"Water pump"}]
[null,null,null,null,null,null,"",{"$f":"Translate!$C$137","v":"PV modules - 20 years"},{"$f":"Translate!$C$158","v":"PV generator"}]
[null,null,null,null,null,null,"",{"$f":"Translate!$C$138","v":"Well / borehole - 20 years"},{"$f":"Translate!$C$159","v":"Well / borehole"}]
[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":"Translate!$C$160","v":"Total Annual Depreciation "},null,null,{"$f":"'1 General Information'!D13","v":"€"},{"$f":"+SUM(G11:G36)","v":2777.7777777777778}]

{"sheet":"3 Income Crops & Livestock","index":3,"n_rows":64,"n_cols":16,"rows_kept":64,"cut":false,"hidden":false,"merged":[[20,1,20,7],[24,1,24,7],[19,1,19,6],[35,1,35,6],[34,1,34,2],[33,1,33,2],[32,1,32,2],[28,1,28,2],[26,1,26,2],[27,1,27,2],[29,1,29,2],[30,1,30,2],[58,11,58,13],[59,11,59,13],[62,11,62,13],[60,11,61,15],[63,1,63,6],[57,11,57,13],[31,11,31,15],[55,11,55,13],[36,1,36,7],[41,1,41,3],[41,4,41,7],[39,4,39,5],[0,1,0,7],[3,3,3,5],[16,1,16,2],[17,1,17,2],[18,1,18,2],[1,1,1,7],[3,6,3,7],[7,1,7,7]]}
[null,{"$f":"Translate!$C$162","v":"INVEST – Farm Analysis Tool"}]
[null,{"$f":"Translate!$C$163","v":"INCOME: SEASONAL CROP"}]
[]
[null,null,null,{"$f":"Translate!$C$164","v":"Farm code/name"},null,null,{"$f":"'1 General Information'!C6","v":0}]
[null,null,{"$f":"Translate!$C$166","v":"Season 1"},{"$f":"Translate!$C$167","v":"Season 2"}]
[null,{"$f":"Translate!$C$165","v":"Agricultural land used:"},{"$f":"'List of dropdown'!E24","v":0},{"$f":"'List of dropdown'!E25","v":0},{"$f":"'1 General Information'!D14","v":"ha"}]
[null,null,null,null,{"$f":"Translate!$C$168","v":"Unit"},{"$f":"Translate!$C$169&\" \"& '1 General Information'!D14 &\" \"&Translate!$C$170","v":"Yield per ha or Quantity"},{"$f":"Translate!$C$171","v":"Unit Price"},{"$f":"Translate!$C$172","v":"Value"}]
[null,{"$f":"Translate!$C$173","v":"Sales"}]
[null,{"$f":"Translate!$C$174","v":"Crop types:"},{"$f":"Translate!$C$175","v":"Season:"},{"$f":"Translate!$C$176","v":"Area:"}]
[null,"Tomato",null,0.5,null,null,null,{"$f":"+G10*F10*D10","v":0}]
[null,"Maize",null,0.5,null,null,null,{"$f":"+G11*F11*D11","v":0}]
[null,"Tomato",null,0.5,null,null,null,0]
[null,"Beans",null,0.5,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"+G15*F15*D15","v":0}]
[null,{"$f":"Translate!$C$177","v":"By-products:"}]
[null,null,null,null,null,null,null,{"$f":"+G17*F17","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,{"$f":"Translate!$C$178","v":"GROSS INCOME"},null,null,null,null,null,{"$f":"SUM(H10:H19)","v":0}]
[null,{"$f":"Translate!$C$179","v":"INCOME: PERENNIAL CROP"}]
[]
[null,{"$f":"Translate!$C$165","v":"Agricultural land used:"},null,{"$f":"SUM(D27:D31)","v":0},{"$f":"'1 General Information'!D14","v":"ha"}]
[null,null,null,null,{"$f":"Translate!$C$168","v":"Unit"},{"$f":"Translate!$C$169&\" \"& '1 General Information'!D14 &\" \"&Translate!$C$170","v":"Yield per ha or Quantity"},{"$f":"Translate!$C$171","v":"Unit Price"},{"$f":"Translate!$C$172","v":"Value"}]
[null,{"$f":"Translate!$C$173","v":"Sales"}]
[null,{"$f":"Translate!$C$174","v":"Crop types:"},null,{"$f":"Translate!$C$176","v":"Area:"}]
[null,null,null,null,null,null,null,{"$f":"+G27*F27*D27","v":0}]
[null,null,null,null,null,null,null,{"$f":"+G28*F28*D28","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,{"$f":"Translate!$C$177","v":"By-products:"}]
[null,null,null,null,null,null,null,{"$f":"+G33*F33","v":0}]
[null,null,null,null,null,null,null,{"$f":"+G34*F34","v":0}]
[null,null,null,null,null,null,null,0]
[null,{"$f":"Translate!$C$178","v":"GROSS INCOME"},null,null,null,null,null,{"$f":"SUM(H27:H35)","v":0}]
[null,{"$f":"Translate!$C$180","v":"INCOME: LIVESTOCK"}]
[]
[]
[null,{"$f":"Translate!$C$181","v":"Livestock for production:"},null,{"$f":"SUM(D44:D57)","v":3},{"$f":"Translate!$C$182","v":"Livestock sold:"},null,{"$f":"SUM(F44:F57)","v":2},{"$f":"Translate!$C$183","v":"head"}]
[null,null,null,null,{"$f":"Translate!$C$168","v":"Unit"},{"$f":"Translate!$C$184","v":"Quantity"},{"$f":"Translate!$C$171","v":"Unit Price"},{"$f":"Translate!$C$172","v":"Value"}]
[null,{"$f":"Translate!$C$185","v":"For Production"},null,null,{"$f":"Translate!$C$186","v":"For Sale"}]
[null,{"$f":"Translate!$C$187","v":"Livestock type"},null,{"$f":"Translate!$C$184","v":"Quantity"}]
[null,{"$f":"Translate!$C$188","v":"Dairy cows"},null,3,{"$f":"Translate!$C$183","v":"head"},null,null,{"$f":"+G44*F44","v":0}]
[null,{"$f":"Translate!$C$189","v":"Heifers"},null,null,{"$f":"Translate!$C$183","v":"head"},null,null,{"$f":"+G45*F45","v":0}]
[null,{"$f":"Translate!$C$190","v":"Adult steers"},null,null,{"$f":"Translate!$C$183","v":"head"},null,null,0]
[null,{"$f":"Translate!$C$191","v":"Juvenile steers"},null,null,{"$f":"Translate!$C$183","v":"head"},2,null,0]
[null,{"$f":"Translate!$C$192","v":"Calfs"},null,null,{"$f":"Translate!$C$183","v":"head"},null,null,0]
[null,{"$f":"Translate!$C$193","v":"Sheep does"},null,null,{"$f":"Translate!$C$183","v":"head"},null,null,0]
[null,{"$f":"Translate!$C$194","v":"Sheep bucks"},null,null,{"$f":"Translate!$C$183","v":"head"},null,null,0]
[null,{"$f":"Translate!$C$195","v":"Sheep kids"},null,null,{"$f":"Translate!$C$183","v":"head"},null,null,0]
[null,{"$f":"Translate!$C$196","v":"Goat does"},null,null,{"$f":"Translate!$C$183","v":"head"},null,null,0]
[null,{"$f":"Translate!$C$197","v":"Goat bucks"},null,null,{"$f":"Translate!$C$183","v":"head"},null,null,0]
[null,{"$f":"Translate!$C$198","v":"Goat kids"},null,null,{"$f":"Translate!$C$183","v":"head"},null,null,0]
[null,{"$f":"Translate!$C$199","v":"Chickens"},null,null,{"$f":"Translate!$C$183","v":"head"},null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,{"$f":"Translate!$C$206","v":"By-product calculator for"},null,null,"Milk",{"$f":"Translate!$C$207","v":"Select"}]
[null,null,null,null,null,null,null,0]
[null,{"$f":"Translate!$C$177","v":"By-products:"},null,null,null,null,null,null,null,null,null,{"$f":"IF($O$56=$B$59,Translate!$C$208,\"\")","v":"Daily milk yield:"},null,null,10,{"$f":"IF($O$56=$B$59,Translate!$C$209,\"\")","v":"litres/day"}]
[null,{"$f":"Translate!$C$200","v":"Milk"},null,null,{"$f":"Translate!$C$204","v":"litres"},15000,4,{"$f":"+G59*F59","v":60000},null,null,null,{"$f":"IF($O$56=$B$59,Translate!$C$211,Translate!$C$210)","v":"Number of dairy livestock:"},null,null,2,{"$f":"Translate!$C$183","v":"head"}]
[null,{"$f":"Translate!$C$201","v":"Eggs"},null,null,{"$f":"Translate!$C$205","v":"piece"},null,null,{"$f":"+G60*F60","v":0},null,null,null,{"$f":"IF($O$56=$B$59,Translate!$C$212,Translate!$C$213)","v":"Days of milking per year:"},null,null,300,{"$f":"Translate!C215","v":"days/year"}]
[null,{"$f":"Translate!$C$202","v":"Skins"},null,null,null,null,null,{"$f":"+G61*F61","v":0},null,null,null,{"$f":"IF($O$56=$B$59,Translate!C214,\"\")","v":"Note: milking (lactation) periods typically range between 209 and 305 days per year for dairy livestock"}]
[null,{"$f":"Translate!$C$203","v":"Manure"},null,null,null,null,null,{"$f":"+G62*F62","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,{"$f":"Translate!$C$216","v":"Total"},null,null,{"$f":"IF($O$56=\"Milk\",$O$58*$O$59*$O$60,$O$59*$O$60)","v":6000},{"$f":"IF($O$56=$B$59,Translate!$C$217,Translate!$C$218)","v":"litres/year"}]
[null,{"$f":"Translate!$C$178","v":"GROSS INCOME"},null,null,null,null,null,{"$f":"SUM(H44:H63)","v":60000}]

{"sheet":"4 Other Income","index":4,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,16],[1,1,1,16],[3,13,3,15],[5,2,6,2],[5,15,6,15],[5,16,6,16],[3,9,3,12]]}
[{"$f":"Translate!$C$220","v":"INVEST – Farm Analysis Tool"}]
[null,{"$f":"Translate!$C$221","v":"4 OTHER INCOME"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"Translate!$C$222","v":"Farm code/name"},null,null,null,{"$f":"'1 General Information'!C6","v":0}]
[]
[null,{"$f":"Translate!$C$223","v":"Month"},{"$f":"Translate!$C$224","v":"Monthly/Yearly Costs"},{"$f":"Translate!$C$225","v":"January"},{"$f":"Translate!$C$226","v":"February"},{"$f":"Translate!$C$227","v":"March"},{"$f":"Translate!$C$228","v":"April"},{"$f":"Translate!$C$229","v":"May"},{"$f":"Translate!$C$230","v":"June"},{"$f":"Translate!$C$231","v":"July"},{"$f":"Translate!$C$232","v":"August"},{"$f":"Translate!$C$233","v":"September"},{"$f":"Translate!$C$234","v":"October"},{"$f":"Translate!$C$235","v":"November"},{"$f":"Translate!$C$236","v":"December"},{"$f":"Translate!$C$237","v":"Yearly Costs"},{"$f":"Translate!$C$238","v":"Total"}]
[null,{"$f":"Translate!$C$239","v":"Type of OTHER INCOME"},null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,{"$f":"Translate!$C$240","v":"Sale of water"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C8='List of dropdown'!$A$29,SUM(D8:O8),IF(C8='List of dropdown'!$A$30,P8,0))","v":0}]
[null,{"$f":"Translate!$C$241","v":"Hire out of equipment"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C9='List of dropdown'!$A$29,SUM(D9:O9),IF(C9='List of dropdown'!$A$30,P9,0))","v":0}]
[null,{"$f":"Translate!$C$242","v":"Lease out storage space"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C10='List of dropdown'!$A$29,SUM(D10:O10),IF(C10='List of dropdown'!$A$30,P10,0))","v":0}]
[null,{"$f":"Translate!$C$243","v":"Lease out land"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C11='List of dropdown'!$A$29,SUM(D11:O11),IF(C11='List of dropdown'!$A$30,P11,0))","v":0}]
[null,{"$f":"Translate!$C$244","v":"Lease out labour"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C12='List of dropdown'!$A$29,SUM(D12:O12),IF(C12='List of dropdown'!$A$30,P12,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C13='List of dropdown'!$A$29,SUM(D13:O13),IF(C13='List of dropdown'!$A$30,P13,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C14='List of dropdown'!$A$29,SUM(D14:O14),IF(C14='List of dropdown'!$A$30,P14,0))","v":0}]
[null,{"$f":"Translate!$C$245","v":"TOTAL OTHER INCOME per month/year"},null,{"$f":"SUMIF($C$8:$C$14,'List of dropdown'!$A$29,D8:D14)","v":0},{"$f":"SUMIF($C$8:$C$14,'List of dropdown'!$A$29,E8:E14)","v":0},{"$f":"SUMIF($C$8:$C$14,'List of dropdown'!$A$29,F8:F14)","v":0},{"$f":"SUMIF($C$8:$C$14,'List of dropdown'!$A$29,G8:G14)","v":0},{"$f":"SUMIF($C$8:$C$14,'List of dropdown'!$A$29,H8:H14)","v":0},{"$f":"SUMIF($C$8:$C$14,'List of dropdown'!$A$29,I8:I14)","v":0},{"$f":"SUMIF($C$8:$C$14,'List of dropdown'!$A$29,J8:J14)","v":0},{"$f":"SUMIF($C$8:$C$14,'List of dropdown'!$A$29,K8:K14)","v":0},{"$f":"SUMIF($C$8:$C$14,'List of dropdown'!$A$29,L8:L14)","v":0},{"$f":"SUMIF($C$8:$C$14,'List of dropdown'!$A$29,M8:M14)","v":0},{"$f":"SUMIF($C$8:$C$14,'List of dropdown'!$A$29,N8:N14)","v":0},{"$f":"SUMIF($C$8:$C$14,'List of dropdown'!$A$29,O8:O14)","v":0},{"$f":"SUMIF($C$8:$C$14,'List of dropdown'!$A$30,P8:P14)","v":0},{"$f":"+SUM(Q8:Q14)","v":0}]

{"sheet":"5 Financing","index":5,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,7,3,9],[17,2,17,5],[0,0,0,13],[1,0,1,13],[5,8,8,8],[6,0,8,0],[6,1,8,1],[6,2,8,2],[6,3,8,3],[6,4,8,4],[6,5,8,5],[6,6,8,6],[6,9,16,13],[3,10,3,12],[5,0,5,6]]}
[{"$f":"Translate!$C$249","v":"INVEST – Farm Analysis Tool"}]
[{"$f":"Translate!$C$250","v":"5 CREDIT AND FINANCING (simplified calculator, to be confirmed with loan provider)"}]
[]
[null,null,null,null,null,null,null,{"$f":"Translate!$C$251","v":"Farm code/name"},null,null,{"$f":"'1 General Information'!C6","v":0}]
[]
[{"$f":"Translate!$C$252","v":"Calculator"},null,null,null,null,null,null,null,{"$f":"Translate!$C$263","v":"Enter manually:"}]
[{"$f":"Translate!$C$253","v":"Bank name"},{"$f":"Translate!$C$254","v":"Loan amount"},{"$f":"Translate!$C$255","v":"Credit period (years)"},{"$f":"Translate!$C$256","v":"Month of taking credit"},{"$f":"Translate!$C$257","v":"Year of taking credit"},{"$f":"Translate!$C$258","v":"Annual interest rate"},{"$f":"Translate!$C$259","v":"Monthly loan repayment"},null,null,{"$f":"Translate!$C$264","v":"Note: the Calculator value will take precedence to the manual value. Ensure calculator value is 0 in order to use manual value."}]
[null,null,null,null,null,null,null,{"$f":"Translate!$C$262","v":"OR"}]
[]
[null,7000,3,1,2018,0.08,{"$f":"IF(D10,-PMT(F10/12,C10*12,B10),\"0\")","v":219.35455823001593}]
[null,null,null,null,null,null,{"$f":"IF(D11,-PMT(F11/12,C11*12,B11),\"0\")","v":"0"}]
[null,null,null,null,null,null,{"$f":"IF(D12,-PMT(F12/12,C12*12,B12),\"0\")","v":"0"}]
[null,null,null,null,null,null,"0"]
[null,null,null,null,null,null,"0"]
[null,null,null,null,null,null,"0"]
[null,null,null,null,null,null,"0"]
[{"$f":"Translate!$C$260","v":"TOTAL CREDIT"},{"$f":"SUM(B10:B16)","v":7000},null,null,null,null,{"$f":"SUM(G10:G16)","v":219.35455823001593},null,{"$f":"SUM(I10:I15)","v":0}]
[null,null,{"$f":"Translate!$C$261","v":"Total Annual Loan Repayments"},null,null,null,{"$f":"G17*12","v":2632.2546987601909},null,{"$f":"I17*12","v":0}]

{"sheet":"6 Fixed and Variable Costs","index":6,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,1,38,2],[5,1,6,1],[20,1,20,16],[0,0,0,16],[1,1,1,16],[2,1,4,4],[5,2,6,2],[18,1,18,2],[5,15,6,15],[5,16,6,16],[3,10,3,12],[3,13,3,15]]}
[{"$f":"Translate!C266","v":"INVEST – Farm Analysis Tool"}]
[null,{"$f":"Translate!$C$267","v":"6 COSTS (FIXED and VARIABLE)"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Translate!$C$268","v":"Farm code/name"},null,null,{"$f":"'1 General Information'!C6","v":0}]
[]
[null,{"$f":"Translate!$C$269","v":"Month"},{"$f":"Translate!$C$270","v":"Monthly/Yearly Costs"},{"$f":"Translate!$C$271","v":"January"},{"$f":"Translate!$C$272","v":"February"},{"$f":"Translate!$C$273","v":"March"},{"$f":"Translate!$C$274","v":"April"},{"$f":"Translate!$C$275","v":"May"},{"$f":"Translate!$C$276","v":"June"},{"$f":"Translate!$C$277","v":"July"},{"$f":"Translate!$C$278","v":"August"},{"$f":"Translate!$C$279","v":"September"},{"$f":"Translate!$C$280","v":"October"},{"$f":"Translate!$C$281","v":"November"},{"$f":"Translate!$C$282","v":"December"},{"$f":"Translate!$C$283","v":"Yearly Costs"},{"$f":"Translate!$C$284","v":"Total"}]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,{"$f":"Translate!$C$285","v":"FIXED COSTS"}]
[null,{"$f":"Translate!$C$286","v":"Financing fees"},{"$f":"'List of dropdown'!$A$29","v":"Monthly"},{"$f":"'5 Financing'!$G$17","v":219.35455823001593},{"$f":"'5 Financing'!$G$17","v":219.35455823001593},{"$f":"'5 Financing'!$G$17","v":219.35455823001593},{"$f":"'5 Financing'!$G$17","v":219.35455823001593},{"$f":"'5 Financing'!$G$17","v":219.35455823001593},{"$f":"'5 Financing'!$G$17","v":219.35455823001593},{"$f":"'5 Financing'!$G$17","v":219.35455823001593},{"$f":"'5 Financing'!$G$17","v":219.35455823001593},{"$f":"'5 Financing'!$G$17","v":219.35455823001593},{"$f":"'5 Financing'!$G$17","v":219.35455823001593},{"$f":"'5 Financing'!$G$17","v":219.35455823001593},{"$f":"'5 Financing'!$G$17","v":219.35455823001593},{"$f":"SUM(D9:O9)","v":2632.2546987601909},{"$f":"IF(C9='List of dropdown'!$A$29,SUM(D9:O9),IF(C9='List of dropdown'!$A$30,P9,0))","v":2632.2546987601909}]
[null,{"$f":"Translate!$C$287","v":"Depreciation costs"},{"$f":"'List of dropdown'!$A$30","v":"Yearly"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2 Equipment & Assets'!$G$38","v":2777.7777777777778},{"$f":"IF(C10='List of dropdown'!$A$29,SUM(D10:O10),IF(C10='List of dropdown'!$A$30,P10,0))","v":2777.7777777777778}]
[null,{"$f":"Translate!$C$288","v":"Membership fees "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C11='List of dropdown'!$A$29,SUM(D11:O11),IF(C11='List of dropdown'!$A$30,P11,0))","v":0}]
[null,{"$f":"Translate!$C$289","v":"Insurance costs"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C12='List of dropdown'!$A$29,SUM(D12:O12),IF(C12='List of dropdown'!$A$30,P12,0))","v":0}]
[null,{"$f":"Translate!$C$290","v":"Land tax"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C13='List of dropdown'!$A$29,SUM(D13:O13),IF(C13='List of dropdown'!$A$30,P13,0))","v":0}]
[null,{"$f":"Translate!$C$291","v":"Social fund contribution"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C14='List of dropdown'!$A$29,SUM(D14:O14),IF(C14='List of dropdown'!$A$30,P14,0))","v":0}]
[null,{"$f":"Translate!$C$292","v":"Leasing fees for equipment"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C15='List of dropdown'!$A$29,SUM(D15:O15),IF(C15='List of dropdown'!$A$30,P15,0))","v":0}]
[null,{"$f":"Translate!$C$293","v":"Rental costs for land"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C16='List of dropdown'!$A$29,SUM(D16:O16),IF(C16='List of dropdown'!$A$30,P16,0))","v":0}]
[null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C17='List of dropdown'!$A$29,SUM(D17:O17),IF(C17='List of dropdown'!$A$30,P17,0))","v":0}]
[null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C18='List of dropdown'!$A$29,SUM(D18:O18),IF(C18='List of dropdown'!$A$30,P18,0))","v":0}]
[null,{"$f":"Translate!$C$294","v":"TOTAL FIXED COSTS per month/year"},null,{"$f":"SUMIF($C$9:$C$18,'List of dropdown'!$A$29,D$9:D$18)","v":219.35455823001593},{"$f":"SUMIF($C$9:$C$18,'List of dropdown'!$A$29,E$9:E$18)","v":219.35455823001593},{"$f":"SUMIF($C$9:$C$18,'List of dropdown'!$A$29,F$9:F$18)","v":219.35455823001593},{"$f":"SUMIF($C$9:$C$18,'List of dropdown'!$A$29,G$9:G$18)","v":219.35455823001593},{"$f":"SUMIF($C$9:$C$18,'List of dropdown'!$A$29,H$9:H$18)","v":219.35455823001593},{"$f":"SUMIF($C$9:$C$18,'List of dropdown'!$A$29,I$9:I$18)","v":219.35455823001593},{"$f":"SUMIF($C$9:$C$18,'List of dropdown'!$A$29,J$9:J$18)","v":219.35455823001593},{"$f":"SUMIF($C$9:$C$18,'List of dropdown'!$A$29,K$9:K$18)","v":219.35455823001593},{"$f":"SUMIF($C$9:$C$18,'List of dropdown'!$A$29,L$9:L$18)","v":219.35455823001593},{"$f":"SUMIF($C$9:$C$18,'List of dropdown'!$A$29,M$9:M$18)","v":219.35455823001593},{"$f":"SUMIF($C$9:$C$18,'List of dropdown'!$A$29,N$9:N$18)","v":219.35455823001593},{"$f":"SUMIF($C$9:$C$18,'List of dropdown'!$A$29,O$9:O$18)","v":219.35455823001593},{"$f":"SUMIF($C$9:$C$18,'List of dropdown'!$A$30,P$9:P$18)","v":2777.7777777777778},{"$f":"+SUM(Q9:Q18)","v":5410.0324765379683}]
[]
[null,{"$f":"Translate!$C$295","v":"VARIABLE COSTS"}]
[null,{"$f":"Translate!$C$296","v":"Fuel and gas costs"},null,null,null,null,null,null,null,null,null,null,null,null,null,10000,{"$f":"IF(C22='List of dropdown'!$A$29,SUM(D22:O22),IF(C22='List of dropdown'!$A$30,P22,0))","v":0}]
[null,{"$f":"Translate!$C$297","v":"Water fees"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C23='List of dropdown'!$A$29,SUM(D23:O23),IF(C23='List of dropdown'!$A$30,P23,0))","v":0}]
[null,{"$f":"Translate!$C$298","v":"Electricity fees"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C24='List of dropdown'!$A$29,SUM(D24:O24),IF(C24='List of dropdown'!$A$30,P24,0))","v":0}]
[null,{"$f":"Translate!$C$299","v":"Transport fees "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C25='List of dropdown'!$A$29,SUM(D25:O25),IF(C25='List of dropdown'!$A$30,P25,0))","v":0}]
[null,{"$f":"Translate!$C$300","v":"Salary costs (permanent staff)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C26='List of dropdown'!$A$29,SUM(D26:O26),IF(C26='List of dropdown'!$A$30,P26,0))","v":0}]
[null,{"$f":"Translate!$C$301","v":"Salary costs (temporary staff)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C27='List of dropdown'!$A$29,SUM(D27:O27),IF(C27='List of dropdown'!$A$30,P27,0))","v":0}]
[null,{"$f":"Translate!$C$302","v":"Seeds"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C28='List of dropdown'!$A$29,SUM(D28:O28),IF(C28='List of dropdown'!$A$30,P28,0))","v":0}]
[null,{"$f":"Translate!$C$303","v":"Manure and fertilizer"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C29='List of dropdown'!$A$29,SUM(D29:O29),IF(C29='List of dropdown'!$A$30,P29,0))","v":0}]
[null,{"$f":"Translate!$C$304","v":"Plant protection"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C30='List of dropdown'!$A$29,SUM(D30:O30),IF(C30='List of dropdown'!$A$30,P30,0))","v":0}]
[null,{"$f":"Translate!$C$305","v":"Fodder"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C31='List of dropdown'!$A$29,SUM(D31:O31),IF(C31='List of dropdown'!$A$30,P31,0))","v":0}]
[null,{"$f":"Translate!$C$306","v":"Veterinary Services"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C32='List of dropdown'!$A$29,SUM(D32:O32),IF(C32='List of dropdown'!$A$30,P32,0))","v":0}]
[null,{"$f":"Translate!$C$307","v":"Traction and mechanisation hire"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C33='List of dropdown'!$A$29,SUM(D33:O33),IF(C33='List of dropdown'!$A$30,P33,0))","v":0}]
[null,{"$f":"Translate!$C$308","v":"Machinery repairs and maintenance"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C34='List of dropdown'!$A$29,SUM(D34:O34),IF(C34='List of dropdown'!$A$30,P34,0))","v":0}]
[null,{"$f":"Translate!$C$309","v":"Infrastructure repairs and maintenance"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C35='List of dropdown'!$A$29,SUM(D35:O35),IF(C35='List of dropdown'!$A$30,P35,0))","v":0}]
[null,{"$f":"Translate!$C$310","v":"Irrigation repair and maintenance"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C36='List of dropdown'!$A$29,SUM(D36:O36),IF(C36='List of dropdown'!$A$30,P36,0))","v":0}]
[null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C37='List of dropdown'!$A$29,SUM(D37:O37),IF(C37='List of dropdown'!$A$30,P37,0))","v":0}]
[null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C38='List of dropdown'!$A$29,SUM(D38:O38),IF(C38='List of dropdown'!$A$30,P38,0))","v":0}]
[null,{"$f":"Translate!$C$311","v":"VARIABLE COSTS per month/month"},null,{"$f":"SUMIF($C$22:$C$38,'List of dropdown'!$A$29,D$22:D$38)","v":0},{"$f":"SUMIF($C$22:$C$38,'List of dropdown'!$A$29,E$22:E$38)","v":0},{"$f":"SUMIF($C$22:$C$38,'List of dropdown'!$A$29,F$22:F$38)","v":0},{"$f":"SUMIF($C$22:$C$38,'List of dropdown'!$A$29,G$22:G$38)","v":0},{"$f":"SUMIF($C$22:$C$38,'List of dropdown'!$A$29,H$22:H$38)","v":0},{"$f":"SUMIF($C$22:$C$38,'List of dropdown'!$A$29,I$22:I$38)","v":0},{"$f":"SUMIF($C$22:$C$38,'List of dropdown'!$A$29,J$22:J$38)","v":0},{"$f":"SUMIF($C$22:$C$38,'List of dropdown'!$A$29,K$22:K$38)","v":0},{"$f":"SUMIF($C$22:$C$38,'List of dropdown'!$A$29,L$22:L$38)","v":0},{"$f":"SUMIF($C$22:$C$38,'List of dropdown'!$A$29,M$22:M$38)","v":0},{"$f":"SUMIF($C$22:$C$38,'List of dropdown'!$A$29,N$22:N$38)","v":0},{"$f":"SUMIF($C$22:$C$38,'List of dropdown'!$A$29,O$22:O$38)","v":0},{"$f":"SUMIF($C$22:$C$38,'List of dropdown'!$A$30,P$22:P$38)","v":0},{"$f":"+SUM(Q22:Q38)","v":0}]

{"sheet":"7 Farm Income Statement","index":7,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,1,0,8],[56,3,56,5],[59,7,59,8],[60,7,60,8],[61,7,61,8],[63,3,63,7],[1,1,1,8],[3,6,3,7],[57,3,57,5],[59,3,59,4],[60,3,60,4],[61,3,61,4],[62,3,62,4],[59,5,59,6],[60,5,60,6],[61,5,61,6],[62,5,62,6],[3,4,3,5],[62,7,62,8]]}
[null,{"$f":"Translate!C313","v":"INVEST – Farm Analysis Tool"}]
[null,{"$f":"Translate!$C$314","v":"7 FARM INCOME STATEMENT"}]
[]
[null,null,null,null,{"$f":"Translate!$C$315","v":"Farm code/name"},null,{"$f":"'1 General Information'!C6","v":0}]
[]
[null,null,"+",{"$f":"Translate!$C$316","v":"Gross value of seasonal crop production"},{"$f":"SUM('3 Income Crops & Livestock'!H10:H15)","v":0},{"$f":"'1 General Information'!$D$13","v":"€"},"+",{"$f":"IF($E$16=0,0,(+E6/$E$16)*(1-$E$14))","v":0}]
[null,null,"+",{"$f":"Translate!$C$317","v":"Gross value of seasonal crop by-product production"},{"$f":"SUM('3 Income Crops & Livestock'!H17:H19)","v":0},{"$f":"'1 General Information'!$D$13","v":"€"},"+",{"$f":"IF($E$16=0,0,(+E7/$E$16)*(1-$E$14))","v":0}]
[null,null,"+",{"$f":"Translate!$C$318","v":"Gross value of perennial crop production"},{"$f":"SUM('3 Income Crops & Livestock'!H27:H31)","v":0},{"$f":"'1 General Information'!$D$13","v":"€"},"+",0]
[null,null,"+",{"$f":"Translate!$C$319","v":"Gross value of perennial crop by-product production"},{"$f":"SUM('3 Income Crops & Livestock'!H33:H35)","v":0},{"$f":"'1 General Information'!$D$13","v":"€"},"+",0]
[null,null,"+",{"$f":"Translate!$C$320","v":"Gross value of livestock production"},{"$f":"SUM('3 Income Crops & Livestock'!H44:H57)","v":0},{"$f":"'1 General Information'!$D$13","v":"€"},"+",0]
[null,null,"+",{"$f":"Translate!$C$321","v":"Gross value of livestock by-product production"},{"$f":"SUM('3 Income Crops & Livestock'!H59:H63)","v":60000},{"$f":"'1 General Information'!$D$13","v":"€"},"+",1]
[null,null,"+",{"$f":"Translate!$C$322","v":"Gross value of other income"},{"$f":"'4 Other Income'!Q15","v":0},{"$f":"'1 General Information'!$D$13","v":"€"},"+",0]
[]
[null,null,"-",{"$f":"Translate!$C$323","v":"Anticipated losses of total sales (reduction factor)"},0.1,"%"]
[]
[null,null,"=",{"$f":"Translate!$C$324","v":"GROSS FARM INCOME"},{"$f":"SUM(E6:E12)-(SUM(E6:E12)*E14)","v":54000},{"$f":"'1 General Information'!$D$13","v":"€"},"=",{"$f":"SUM(H6:H12)","v":1}]
[]
[]
[null,null,"-",{"$f":"Translate!$C$325","v":"Total fixed costs"},{"$f":"'6 Fixed and Variable Costs'!Q19","v":5410.0324765379683},{"$f":"'1 General Information'!$D$13","v":"€"},"+",{"$f":"IF($E$21=0,0,+E19/$E$21)","v":1}]
[null,null,"-",{"$f":"Translate!$C$326","v":"Total variable costs"},{"$f":"'6 Fixed and Variable Costs'!Q39","v":0},{"$f":"'1 General Information'!$D$13","v":"€"},"+",{"$f":"IF($E$21=0,0,+E20/$E$21)","v":0}]
[null,null,"=",{"$f":"Translate!$C$327","v":"TOTAL COST"},{"$f":"SUM(E19:E20)","v":5410.0324765379683},{"$f":"'1 General Information'!$D$13","v":"€"},"=",{"$f":"SUM(H19:H20)","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"=",{"$f":"Translate!$C$328 &\" \"  &   '1 General Information'!$D$12 & \" \" &Translate!$C$329 & \" \"& '1 General Information'!$E$12","v":"GROSS FARM PROFIT for the period 2021 to 2022"},null,null,{"$f":"E16-E21","v":48589.96752346203},{"$f":"'1 General Information'!$D$13","v":"€"}]
[null,null,null,{"$f":"Translate!$C$330","v":"Farm Profit Margin "},null,null,{"$f":"(E16-E21)/E16","v":0.89981421339744505}]
[]
[null,null,null,{"$f":"Translate!$C$331 &\" \"&'1 General Information'!$D$14& \" \" & Translate!$C$332","v":"Average profit per ha for seasonal crops:"},null,{"$f":"IFERROR('3 Income Crops & Livestock'!H20/MAX('3 Income Crops & Livestock'!C6:D6),Translate!$C$337)","v":"no crops"},null,{"$f":"'1 General Information'!$D$13&\" \" &Translate!$C$336&\" \"&'1 General Information'!$D$14","v":"€ per ha"}]
[null,null,null,{"$f":"Translate!$C$331 &\" \"&'1 General Information'!$D$14&\" \" &Translate!$C$333","v":"Average profit per ha for perennial crops:"},null,{"$f":"IFERROR('3 Income Crops & Livestock'!H36/'3 Income Crops & Livestock'!D23,Translate!$C$337)","v":"no crops"},null,{"$f":"'1 General Information'!$D$13&\" \" &Translate!$C$336&\" \"&'1 General Information'!$D$14","v":"€ per ha"}]
[null,null,null,{"$f":"Translate!$C$334","v":"Average profit per head of livestock:"},null,{"$f":"IFERROR('3 Income Crops & Livestock'!H64/('3 Income Crops & Livestock'!G40+'3 Income Crops & Livestock'!D40),Translate!$C$338)","v":12000},null,{"$f":"'1 General Information'!$D$13& \" \" & Translate!C339","v":"€ per head"}]
[null,null,null,{"$f":"Translate!$C$335","v":"Total crop area under cultivation:"},null,{"$f":"MAX('3 Income Crops & Livestock'!C6:D6)+'3 Income Crops & Livestock'!D23","v":0},null,{"$f":"'1 General Information'!D14","v":"ha"}]
[null,null,null,{"$f":"IF(F63>'1 General Information'!H36,Translate!$C$343,\"\")","v":""}]

{"sheet":"Crop Price Calculation Sheet","index":8,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,0,1,13],[4,0,4,13],[14,0,14,13],[24,0,24,13],[0,0,0,13]]}
[{"$f":"Translate!$C$345","v":"INVEST – Farm Analysis Tool"}]
[{"$f":"Translate!$C$346","v":"Supplementary sheet for calculating average annual costs for selected crops and livestock based on seasonal monthly variations"}]
[null,{"$f":"'6 Fixed and Variable Costs'!D6","v":"January"},{"$f":"'6 Fixed and Variable Costs'!E6","v":"February"},{"$f":"'6 Fixed and Variable Costs'!F6","v":"March"},{"$f":"'6 Fixed and Variable Costs'!G6","v":"April"},{"$f":"'6 Fixed and Variable Costs'!H6","v":"May"},{"$f":"'6 Fixed and Variable Costs'!I6","v":"June"},{"$f":"'6 Fixed and Variable Costs'!J6","v":"July"},{"$f":"'6 Fixed and Variable Costs'!K6","v":"August"},{"$f":"'6 Fixed and Variable Costs'!L6","v":"September"},{"$f":"'6 Fixed and Variable Costs'!M6","v":"October"},{"$f":"'6 Fixed and Variable Costs'!N6","v":"November"},{"$f":"'6 Fixed and Variable Costs'!O6","v":"December"},{"$f":"Translate!$C$347","v":"AVERAGE"}]
[null,{"$f":"'3 Income Crops & Livestock'!$G$7","v":"Unit Price"},{"$f":"'3 Income Crops & Livestock'!$G$7","v":"Unit Price"},{"$f":"'3 Income Crops & Livestock'!$G$7","v":"Unit Price"},{"$f":"'3 Income Crops & Livestock'!$G$7","v":"Unit Price"},{"$f":"'3 Income Crops & Livestock'!$G$7","v":"Unit Price"},{"$f":"'3 Income Crops & Livestock'!$G$7","v":"Unit Price"},{"$f":"'3 Income Crops & Livestock'!$G$7","v":"Unit Price"},{"$f":"'3 Income Crops & Livestock'!$G$7","v":"Unit Price"},{"$f":"'3 Income Crops & Livestock'!$G$7","v":"Unit Price"},{"$f":"'3 Income Crops & Livestock'!$G$7","v":"Unit Price"},{"$f":"'3 Income Crops & Livestock'!$G$7","v":"Unit Price"},{"$f":"'3 Income Crops & Livestock'!$G$7","v":"Unit Price"},{"$f":"'3 Income Crops & Livestock'!$G$7","v":"Unit Price"}]
[{"$f":"Translate!$C$348","v":"Seasonal Crops"}]
[{"$f":"'3 Income Crops & Livestock'!B10","v":"Tomato"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(B6:M6)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'3 Income Crops & Livestock'!B11","v":"Maize"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(B7:M7)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'3 Income Crops & Livestock'!B12","v":"Tomato"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B13","v":"Beans"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!$B$16","v":"By-products:"}]
[{"$f":"'3 Income Crops & Livestock'!B17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"Translate!$C$349","v":"Perennial crops"}]
[{"$f":"'3 Income Crops & Livestock'!B27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!$B$16","v":"By-products:"}]
[{"$f":"'3 Income Crops & Livestock'!B33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B34","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"Translate!$C$350","v":"Livestock"}]
[{"$f":"'3 Income Crops & Livestock'!B44","v":"Dairy cows"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B45","v":"Heifers"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B46","v":"Adult steers"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B47","v":"Juvenile steers"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B48","v":"Calfs"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B49","v":"Sheep does"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B50","v":"Sheep bucks"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B51","v":"Sheep kids"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B52","v":"Goat does"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B53","v":"Goat bucks"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B54","v":"Goat kids"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B55","v":"Chickens"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B56","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B57","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!$B$16","v":"By-products:"}]
[{"$f":"'3 Income Crops & Livestock'!B59","v":"Milk"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B60","v":"Eggs"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B61","v":"Skins"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B62","v":"Manure"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B63","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]

{"sheet":"Quick Check","index":9,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,1,1,3],[32,1,32,3],[6,5,6,8],[33,2,33,3],[4,1,4,3],[18,1,18,3]]}
[null,{"$f":"Translate!$C$352","v":"INVEST – Farm Analysis Tool"}]
[null,{"$f":"Translate!$C$353","v":"QUICK CHECK"}]
[]
[]
[null,{"$f":"Translate!$C$354","v":"Annual Expenditure"}]
[null,{"$f":"Translate!$C$355","v":"Expenditure Type"},{"$f":"Translate!$C$356","v":"Examples"},{"$f":"Translate!$C$357","v":"Annual Amount"}]
[null,{"$f":"Translate!$C$358","v":"Seasonal crop expenses"},{"$f":"Translate!$C$367","v":"Seedlings, pesticides, fertilisers, protection, etc"},null,null,{"$f":"Translate!$C$397","v":"Calculator"}]
[null,{"$f":"Translate!$C$359","v":"Perennial crop expenses"},{"$f":"Translate!$C$368","v":"Seedlings, pesticides, fertilisers, protection, etc"},null,null,null,{"$f":"Translate!$C$398","v":"add up:"},{"$f":"Translate!$C$399","v":"multiply:"},{"$f":"Translate!$C$400","v":"divide:"}]
[null,{"$f":"Translate!$C$360","v":"Livestock expenses"},{"$f":"Translate!$C$369","v":"New livestock, fodder, slaughtering, veterinary services, etc"},null,null,{"$f":"Translate!$C$401","v":"a."}]
[null,{"$f":"Translate!$C$361","v":"Operation and maintenance \n- Infrastructure"},{"$f":"Translate!$C$370","v":"Building renovations, painting, plastering, fencing, electricity, water, etc "},null,null,{"$f":"Translate!$C$402","v":"b."}]
[null,{"$f":"Translate!$C$362","v":"Operation and maintenance\n- Fixed equipment"},{"$f":"Translate!$C$371","v":"Water pumps, irrigation equipment, packaging equipment, milling, fuel, spare parts, repairs, etc"},null,null,{"$f":"Translate!$C$403","v":"c."}]
[null,{"$f":"Translate!$C$363","v":"Operation and maintenance \n- Movable equipment"},{"$f":"Translate!$C$372","v":"Tractor, trucks, plough, trailer, fuel, spare parts, repairs, etc"},null,null,{"$f":"Translate!$C$404","v":"d."}]
[null,{"$f":"Translate!$C$364","v":"Labour"},{"$f":"Translate!$C$373","v":"Salaries, benefits, own salary (?) etc"},null,null,{"$f":"Translate!$C$405","v":"e."}]
[null,{"$f":"Translate!$C$365","v":"Sales and distribution"},{"$f":"Translate!$C$374","v":"Packaging, fees, advertising, etc"},null,null,{"$f":"Translate!$C$406","v":"Total"},{"$f":"SUM(G9:G13)","v":0},{"$f":"H9*H10","v":0},{"$f":"I9/I10","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Translate!$C$366","v":"Management and administration"},{"$f":"Translate!$C$375","v":"Rent, office consumables, insurance, memberships, loan repayments, etc"}]
[]
[null,null,null,{"$f":"SUM(D7:D16)","v":0}]
[]
[null,{"$f":"Translate!$C$376","v":"Annual Income"}]
[null,{"$f":"Translate!$C$377","v":"Income Type"},{"$f":"Translate!$C$356","v":"Examples"},{"$f":"Translate!$C$357","v":"Annual Amount"}]
[null,{"$f":"Translate!$C$378","v":"Seasonal crop sales"},{"$f":"Translate!$C$386","v":"Tomatos, grain, rice, value added product, etc"}]
[null,{"$f":"Translate!$C$379","v":"By-products from seasonal crops"},{"$f":"Translate!$C$387","v":"Compost, fodder, value added product, etc"}]
[null,{"$f":"Translate!$C$380","v":"Perennial crop sales"},{"$f":"Translate!$C$388","v":"Citrus, apples, dates, berries, value added product, etc"}]
[null,{"$f":"Translate!$C$381","v":"By-products from perennial crops"},{"$f":"Translate!$C$389","v":"Wood fuel, mulch, value added product, etc"}]
[null,{"$f":"Translate!$C$382","v":"Livestock sales"},{"$f":"Translate!$C$390","v":"Cattle, sheep, chickens, etc"},12]
[null,{"$f":"Translate!$C$383","v":"By-products from livestock"},{"$f":"Translate!$C$391","v":"Manure, eggs, milk, wool, value added product, etc"}]
[null,{"$f":"Translate!$C$384","v":"Lease income"},{"$f":"Translate!$C$392","v":"Labour, vehicles, land, etc"}]
[null,{"$f":"Translate!$C$385","v":"Services income"},{"$f":"Translate!$C$393","v":"Subcontract work, maintenance service, packaging service, transport, etc"}]
[]
[null,null,null,{"$f":"SUM(D21:D29)","v":12}]
[]
[null,null,{"$f":"Translate!$C$394","v":"Profit or loss"},{"$f":"D30-D17","v":12}]
[null,{"$f":"IF(D32>0,Translate!$C$395,(IF(D32<0,Translate!$C$396,\"\")))","v":"This activity is profitable! Proceed with a detailed analysis to be sure."}]

{"sheet":"Translate","index":10,"n_rows":594,"n_cols":9,"rows_kept":594,"cut":false,"hidden":false,"merged":[[1,1,2,2],[4,1,4,8],[6,1,16,1]]}
[]
[null,{"$f":"$C$19","v":"Do not modify this sheet"}]
[]
[]
[null,{"$f":"$C$20","v":"Reference Row"}]
[null,{"$f":"$C$21","v":"Selected Language:"},{"$f":"'READ ME'!$G$11","v":"English"},"English","Français","Español","العربية"]
[null,{"$f":"$C$22","v":"Sheet name"},{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"READ ME"},"READ ME","LISER MOI","LÉEME","اقرأ هذه الصفحة"]
[null,null,"1 General Information","1 General Information","1 Informations générales","1 Información general","1 معلومات عامة"]
[null,null,"2 Equipment & Assets","2 Equipment & Assets","2 Équipements et actifs","2 Equipamiento y activos","2 المعدات والأصول"]
[null,null,"3 Income Crops & Livestock","3 Income Crops & Livestock","3 Recettes cultures & élévage","3 Ingresos cultivo y ganado","3 دخل المحاصيل والثروة الحيوانية   "]
[null,null,"4 Other Income","4 Other Income","4 Autres recettes","4 Otros ingresos","4 مداخيل أخرى"]
[null,null,"5 Financing","5 Financing","5 Financement","5 Financiación","5 التمويل"]
[null,null,"6 Fixed and Variable Costs","6 Fixed and Variable Costs","6 Coûts Fixes et Variables","6 Costos fijos y variables","6 التكاليف الثابتة والمتغيرة"]
[null,null,"7 Farm Income Statement","7 Farm Income Statement","7 Compte de résultat de l’exploitation","7 Declaración de ingresos de la explotación","7 بيان دخل المزرعة"]
[null,null,"Crop Price Calculation Sheet","Crop Price Calculation Sheet","Feuille de calcul des prix des cultures","Hoja de calculación de precios","ورقة حساب سعر المحاصيل"]
[null,null,"Quick Check","Quick Check","Contrôle rapide","Verificación rápida","فحص سريع"]
[null,null,"Translate","Translate","Traduire","Traducción","ترجمة"]
[]
[null,{"$f":"$C$17","v":"Translate"},{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"Do not modify this sheet"},"Do not modify this sheet","Ne modifiez pas cette feuille","No modifique esta hoja","لا تعدل هذه الصفحة"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"Reference Row"},"Reference Row","Ligne de référence","Fila de referencia","صف مرجعي"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"Selected Language:"},"Selected Language:","Langue sélectionnée:","Idioma seleccionado:","اللغة المختارة:"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"Sheet name"},"Sheet name","Nom de la feuille","Nombre de la hoja","اسم الصفحة"]
[]
[null,{"$f":"$C$7","v":"READ ME"},{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"Select language"},"Select language","Sélectionner la langue","Seleccione el idioma","اختار اللغة"]
[null,null,"Read Me Sheet","Read Me Sheet","Feuille Lisez-moi","Léeme","اقرأ هذه الصفحة"]
[null,null,"INVEST – Farm Analysis Tool","INVEST – Farm Analysis Tool","INVESTIR – Outil d’analyse de l’exploitation agricole","INVIERTE – Herramienta de cálculo del balance económico","استثمار - أداة تحليل المزرعة"]
[null,null,"Introduction","Introduction","Introduction","Introducción","مقدمة"]
[null,null,"This tool allows for the assessment of on-farm productivity and profitability through its average annual agricultural production. The tool is useful for establishing a baseline or assessing the impact of planned investments. This tool allows an SPIS advisor (supplier, development practitioner, extension officer) to support a farm enterprise towards identify unnecessary costs, determine best value agricultural activities and correctly monetize different farm inputs. ","This tool allows for the assessment of on-farm productivity and profitability through its average annual agricultural production. The tool is useful for establishing a baseline or assessing the impact of planned investments. This tool allows an SPIS advisor (supplier, development practitioner, extension officer) to support a farm enterprise towards identify unnecessary costs, determine best value agricultural activities and correctly monetize different farm inputs. ","Cet outil permet d’évaluer la productivité et la rentabilité d’une exploitation en se fondant sur sa production agricole annuelle moyenne. Il permet d’établir des valeurs de référence ou d’évaluer l’impact d’investissements prévus. L’outil permet à un conseiller en SPIS (fournisseur, professionnel du développement, agent de vulgarisation) d’aider une exploitation agricole à identifier les coûts inutiles, à déterminer les activités qui apportent le plus de valeur et à bien rentabiliser les différents intrants. ","Esta herramienta permite evaluar la productividad y rentabilidad de una explotación a través de su producción agrícola anual promedio. La herramienta resulta útil para establecer una referencia o evaluar el impacto de inversiones planificadas y permite al asesor o asesora de SPIS (proveedor, profesional de desarrollo, funcionario o funcionaria de extensión agraria) ayudar a identificar costos innecesarios en una granja, determinar actividades agrícolas con el máximo beneficio y generar correctamente beneficios económicos a partir de diferentes insumos agrícolas.","تسمح هذه الأداة بتقييم الإنتاجية والربحية في المزرعة من خلال متوسط ​​الإنتاج الزراعي السنوي. هذه الأداة مفيدة لإنشاء خط أساس أو تقييم تأثير الاستثمارات المخطط لها. تتيح هذه الأداة لمستشار أنظمة الريّ بالطاقة الشمسية (مورد ، ممارس تطوير ، مسؤول إرشاد) دعم مشروع مزرعة لتحديد التكاليف الغير ضرورية ، وتحديد أفضل الأنشطة الزراعية ، وتحقيق الدخل بشكل صحيح من المدخلات الزراعية المختلفة."]
[null,null,"Tips & Tricks","Tips & Tricks","Conseils et Astuces","Consejos y trucos","نصائح وحيل"]
[null,null,"● Make sure that macro is always enabled for the proper functioning of this tool  ","● Make sure that macro is always enabled for the proper functioning of this tool  ","● Assurez-vous que les macros sont toujours activées pour le bon fonctionnement de cet outil ","● Asegúrese de que la macro esté siempre habilitada para el correcto funcionamiento de esta herramienta.","● تأكد من تمكين الماكرو دائمًا من أجل حسن سير هذه الأداة"]
[null,null,"● Only enter values into white cells","● Only enter values into white cells","● Saisissez des valeurs uniquement dans les cellules blanches","● Solo ingrese valores en las celdas blancas.","● أدخل القيم فقط في الخلايا البيضاء"]
[null,null,"● This tool comprises drop down lists and macros to simplify data entry and results review.","● This tool comprises drop down lists and macros to simplify data entry and results review.","● Cet outil contient des listes déroulantes et des macros pour simplifier la saisie des données et la présentation des résultats","● Esta herramienta incluye listas desplegables y macros para simplificar la entrada de datos y la revisión de resultados.","● تتضمن هذه الأداة قوائم منسدلة ووحدات ماكرو لتبسيط إدخال البيانات ومراجعة النتائج."]
[null,null,"● For the multilanguage option to work properly, do NOT delete sheets","● For the multilanguage option to work properly, do NOT delete sheets","● Pour que l'option multilingue fonctionne correctement, ne supprimez PAS les feuilles","● Para que la opción de varios idiomas funcione correctamente, NO elimine las hojas.","● لكي يعمل خيار اللغات المتعددة بشكل صحيح ، لا تحذف الصفحات"]
[null,null,"● This tool provides an indicative assessment of farm profitability and should be complemented by deeper and more detailed assessments, market analysis, and other due diligence, before committing to large-scale investments.","● This tool provides an indicative assessment of farm profitability and should be complemented by deeper and more detailed assessments, market analysis, and other due diligence, before committing to large-scale investments.","● Cet outil fournit une évaluation indicative de la rentabilité des exploitations agricoles et devrait être complété par des évaluations plus approfondies et plus détaillées, des analyses de marché et d'autres contrôles préalables, avant de s'engager dans des investissements à grande échelle.","● Esta herramienta proporciona una evaluación indicativa de la rentabilidad de la explotación y debería complementarse con evaluaciones más detalladas y más profundas, análisis de mercado y otras actividades de debida diligencia antes de comprometerse a hacer inversiones a gran escala.","● توفر هذه الأداة تقييمًا إرشاديًا لربحية المزرعة ويجب استكمالها بتقييمات أعمق وأكثر تفصيلاً ، وتحليل السوق ، وغيرها من العناية الواجبة ، قبل الالتزام باستثمارات واسعة النطاق."]
[null,null,"● This tool contains numerous critical formulas or calculations","● This tool contains numerous critical formulas or calculations","● Cet outil contient de nombreuses formules ou calculs critiques","● Esta herramienta contiene numerosas fórmulas o cálculos críticos","● تحتوي هذه الأداة على العديد من المعادلات أو الحسابات الهامة"]
[null,null,"● Make sure that this file is always saved as \".xlsm\"    \n","● Make sure that this file is always saved as \".xlsm\"    \n","● Assurez-vous que ce fichier est toujours enregistré sous \".xlsm\"    \n","● Asegúrese de que este archivo siempre se guarde como \".xlsm\"","● تأكد من حفظ هذا الملف دائمًا باسم \".xlsm\""]
[null,null,"Overview","Overview","Aperçu","Sinopsis","نظرة عامة"]
[null,null,"This tool comprises the following sheet:","This tool comprises the following sheet:","Cet outil est composé des feuilles suivantes:","Esta herramienta incluye las siguientes hojas:","تتكون هذه الأداة من الصفحات التالية:"]
[null,null,"farm name, location, and area","farm name, location, and area","nom, emplacement et région de la ferme","nombre de la granja, ubicación y área","اسم المزرعة والموقع والمنطقة"]
[null,null,"currently available on the farm or considered for future purchases","currently available on the farm or considered for future purchases","actuellement disponibles sur l’exploitation ou dont l’acquisition prochaine est envisagée","disponibles actualmente en la granja o que se contemplan en una futura compra","متوفر حاليًا في المزرعة أو  من المشتريات المستقبلية المخطط لها"]
[null,null,"to add current or projected sales of seasonal crops (e.g. rice, maize), perennial crops (e.g. fruits), and livestock and respective by-products ","to add current or projected sales of seasonal crops (e.g. rice, maize), perennial crops (e.g. fruits), and livestock and respective by-products ","pour ajouter les ventes réelles ou prévues de cultures saisonnières (riz, maïs etc.), de cultures pluriannuelles (arbres fruitiers, etc.) et d'élevage et de produits dérivés","añade ventas actuales o previstas de cultivos estacionales (p. ej. arroz, maíz) perennes (p. ej. árboles frutales) y de ganado y sus respectivos derivados ","لإضافة المبيعات الحالية أو المتوقعة للمحاصيل الموسمية (مثل الأرز والذرة) والمحاصيل المعمرة (مثل الفواكه) والمواشي والمنتجات الثانوية ذات الصلة"]
[null,null,"additional income not directly related to crop or livestock production such as the sale of water or rental of equipment","additional income not directly related to crop or livestock production such as the sale of water or rental of equipment","recettes supplémentaires ne provenant pas directement de la production de cultures ou d’animaux d’élevage, par exemple, la vente d’eau ou la location d’équipements","ingresos adicionales no relacionados directamente con la producción agrícola o ganadera, como son la venta de agua o el alquiler de equipamiento","الدخل الإضافي غير المرتبط مباشرة بإنتاج المحاصيل أو الثروة الحيوانية مثل بيع المياه أو تأجير المعدات"]
[null,null,"calculates annual loan repayment based on credit information","calculates annual loan repayment based on credit information","calcule le remboursement annuel du prêt en fonction de l'information sur le crédit","calcula el reembolso anual del préstamo en función de la información crediticia","يحسب سداد القرض السنوي بناءً على معلومات الائتمان"]
[null,null,"to add all fixed and variable costs/expenditures of the farm enterprise","to add all fixed and variable costs/expenditures of the farm enterprise","pour ajouter tous les coûts/dépenses fixes et variables de l'entreprise agricole","añade todos los costos fijos y variables/gastos de la empresa agrícola","لإضافة جميع التكاليف الثابتة والمتغيرة / النفقات لمشروع المزرعة"]
[null,null,"No Entry! Summary calculation on gross profitability of the farm enterprise","No Entry! Summary calculation on gross profitability of the farm enterprise","Pas de saisie ! Calcul de la rentabilité brute de l’exploitation","¡Sin entrada! Cálculo resumen de la rentabilidad bruta de la empresa agrícola","ملخص حساب الربحية الإجمالية لمشروع المزرعة"]
[null,null,"side sheet for calculating average annual crop and livestock prices","side sheet for calculating average annual crop and livestock prices","pour calculer les coûts annuels moyens de certaines cultures et de certains animaux d’élevage","hoja de cálculo para determinar los precios anuales medios de los cultivos y del ganado","ورقة جانبية لحساب متوسط أسعار المحاصيل والماشية السنوية"]
[null,null,"side sheet for a quick calculation of farm profitability useful before conducting a full analysis","side sheet for a quick calculation of farm profitability useful before conducting a full analysis","calcul rapide de la rentabilité de l'exploitation utile avant d'effectuer une analyse complète","hoja de cálculo adjunta para una evaluación básica de la rentabilidad de la explotación previa al análisis completo","ورقة جانبية للحساب السريع لربحية المزرعة ، مفيدة قبل إجراء تحليل كامل"]
[null,null,"About","About","En savoir plus","Acerca de","حول"]
[null,null,"Published by: ","Published by: ","Publié par: ","Publicado por: ","نشرت من قبل:"]
[null,null,"Responsible:","Responsible:","Responsables:","Responsable:","مسؤول:"]
[null,null,"Contact:","Contact:","Contact:","Contacto: ","اتصال:"]
[null,null,"Download link:","Download link:","Lien de téléchargement:","Enlace descarga: ","رابط التحميل:"]
[null,null,"About:","About:","À propos de: ","Acerca de:","حول:"]
[null,null,"Version:","Version:","Version:","Versión:","إصدار:"]
[null,null,"GIZ & FAO","GIZ & FAO","GIZ et FAO","GIZ & FAO","الوكالة الألمانية للتعاون الدولي (GIZ) ومنظمة الأغذية والزراعة (FAO)"]
[null,null,"GIZ project \"Water and Energy for Food (WE4F)\"","GIZ project \"Water and Energy for Food (WE4F)\"","Projet de la GIZ « Les innovations dans l’agriculture et la production alimentaire protègent le climat (PEEPA/WE4F) » (Water and Energy for Food)","GIZ project \"Water and Energy for Food (WE4F)\"","مشروع الوكالة الألمانية للتعاون الدولي \"المياه والطاقة من أجل الغذاء Water and Energy for Food (WE4F)\""]
[null,null,"Water and Energy for Food Grand Challenge at:  ","Water and Energy for Food Grand Challenge at:  ","Eau et Energie pour l'Alimentation (PEEPA). Disponible à l’adresse :  ","Water and Energy for Food Grand Challenge at:  ","التحدي الكبير للمياه والطاقة من أجل الغذاء في:"]
[null,null,"3.0 (June 2021)","3.0 (June 2021)","3.0 (Juin 2021)","3.0 (Junio 2021)","3.0 (يونيو 2021)"]
[null,null,"The Toolbox on Solar Powered Irrigation Systems (SPIS) is a legacy project of the global initiative Powering Agriculture: An Energy Grand Challenge for Development (PAEGC). In 2012, the United States Agency for International Development (USAID), the Swedish International Development Cooperation Agency (Sida), the German Federal Ministry for Economic Cooperation and Development (BMZ), Duke Energy, and the Overseas Private Investment Corporation (OPIC) combined resources to support new and sustainable approaches to accelerate the development and deployment of clean energy solutions for increasing agriculture productivity.\n\nThe Toolbox on SPIS has now been embraced for further development by PAEGC's successor program Water and Energy for Food (WE4F). WE4F is a joint international initiative of the European Union (EU), German Federal Ministry for Economic Cooperation and Development (BMZ), the Ministry of Foreign Affairs of the Kingdom of the Netherlands, Sweden through the Swedish International Development Cooperation Agency (Sida), and the U.S. Agency for International Development (USAID). WE4F aims to increase food production along the value chain through a more sustainable and efficient usage of water and/or energy.","The Toolbox on Solar Powered Irrigation Systems (SPIS) is a legacy project of the global initiative Powering Agriculture: An Energy Grand Challenge for Development (PAEGC). In 2012, the United States Agency for International Development (USAID), the Swedish International Development Cooperation Agency (Sida), the German Federal Ministry for Economic Cooperation and Development (BMZ), Duke Energy, and the Overseas Private Investment Corporation (OPIC) combined resources to support new and sustainable approaches to accelerate the development and deployment of clean energy solutions for increasing agriculture productivity.\n\nThe Toolbox on SPIS has now been embraced for further development by PAEGC's successor program Water and Energy for Food (WE4F). WE4F is a joint international initiative of the European Union (EU), German Federal Ministry for Economic Cooperation and Development (BMZ), the Ministry of Foreign Affairs of the Kingdom of the Netherlands, Sweden through the Swedish International Development Cooperation Agency (Sida), and the U.S. Agency for International Development (USAID). WE4F aims to increase food production along the value chain through a more sustainable and efficient usage of water and/or energy.","La boîte à outils pour les systèmes d’irrigation à énergie solaire (Solar Powered Irrigation Systems, SPIS) est un projet hérité de l'initiative mondiale « Propulser l’agriculture : un grand défi énergétique pour le développement » (Powering Agriculture: An Energy Grand Challenge for Development – PAEGC). En 2012, l’Agence des États-Unis pour le développement international (USAID), l’Agence suédoise de coopération internationale au développement (Sida), le ministère fédéral allemand de la Coopération économique et du Développement (BMZ), Duke Energy et l’Overseas Private Investment Cooperation (OPIC) ont mis leurs ressources en commun pour soutenir des approches nouvelles et durables afin d'accélérer le développement et le déploiement des solutions énergétiques propres pour accroître la productivité agricole.\n\nLa boîte à outils sur les SPIS a maintenant été adoptée pour un développement ultérieur par le programme successeur du PAEGC, Eau et Energie pour l'Alimentation (PEEPA) - Water and Energy for Food (WE4F). WE4F/PEEPA est une initiative commune de l'Union européenne, du Ministère fédéral allemand de la coopération économique et du développement (BMZ), du Ministère des affaires étrangères du royaume des Pays-Bas, de l’Agence suédoise de développement (Sida) et de l’Agence de développement des États-Unis (USAID). WE4F/PEEPA vise à accroître la production alimentaire tout au long de la chaîne de valeur grâce à une utilisation plus durable et plus efficace de l'eau et/ou de l'énergie.","La publicación de la Caja de herramientas de sistemas de riego solar ha sido posible gracias al apoyo brindado por la iniciativa mundial Powering Agriculture: An Energy Grand Challenge for Development (PAEGC) (Energización Rural: Un gran desafío energético para el desarrollo). En 2012, la Agencia de los Estados Unidos para el Desarrollo Internacional (USAID), la Agencia Sueca de Cooperación Internacional para el Desarrollo (Sida), el Ministerio Federal de Cooperación Económica y Desarrollo (BMZ) de Alemania, la empresa de energía Duke Energy Corporation y la Corporación de Inversiones Privadas en el Extranjero (OPIC) juntaron recursos para crear la iniciativa PAEGC. El objetivo de PAEGC es fomentar nuevos enfoques sostenibles con el fin de acelerar el desarrollo y asegurar el establecimiento de energías limpias que incrementen la productividad y/o el valor de la agricultura en países en desarrollo y regiones emergentes sin acceso a fuentes de energía confiables, asequibles y limpias.","يعتبر صندوق الأدوات الخاص بأنظمة الري التي تعمل بالطاقة الشمسية (SPIS) مشروعًا هاما للمبادرة العالمية \"دعم الزراعة: تحدي الطاقة الكبير من أجل التنمية\" Powering Agriculture: An Energy Grand Challenge for Development (PAEGC). في عام 2012 ، قامت الوكالة الأمريكية للتنمية الدولية (USAID) ، والوكالة السويدية للتعاون الإنمائي الدولي (ٍSida) ، والوزارة الفيدرالية الألمانية للتعاون الاقتصادي والتنمية (BMZ) ، وشركة Duke Energy ، ومؤسسة الاستثمار الخاص لما وراء البحار (OPIC) بجهود مشتركة لدعم الأساليب الجديدة والمستدامة لتسريع تطوير ونشر حلول الطاقة النظيفة لزيادة الإنتاجية الزراعية.\n\nتم اعتماد صندوق SPIS الآن لمزيد من التطوير من قبل البرنامج اللاحق لـ PAEGC \"الماء والطاقة من اجل الغذاء\" Water and Energy for Food (WE4F). الاخير هو مبادرة دولية مشتركة من الاتحاد الأوروبي (EU) ، والوزارة الاتحادية الألمانية للتعاون الاقتصادي والتنمية (BMZ) ، ووزارة الشؤون الخارجية لمملكة هولندا ، والسويد من خلال الوكالة السويدية للتعاون الإنمائي الدولي (Sida) ، والوكالة الأمريكية للتنمية الدولية (USAID). تهدف WE4F إلى زيادة إنتاج الغذاء على امتداد سلاسل القيمة الغذائية من خلال استخدام المياه و / أو الطاقة بطريقة أكثر استدامة وكفاءة."]
[null,null,"The designations employed and the presentation of material in this information product do not imply the expression of any opinion whatsoever on the part of Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, Food and Agriculture Organization of the United Nations (FAO) or any of the PAEGC Founding Partners concerning the legal or development status of any country, territory, city or area or of its authorities, or concerning the delimitation of its frontiers or boundaries. The mention of specific companies or products of manufacturers, whether or not these have been patented, does not imply that these have been endorsed or recommended by GIZ, FAO, or any of the PAEGC Founding Partners in preference to others of a similar nature that are not mentioned. The views expressed in this information product are those of the author and do not necessarily reflect the views or policies of GIZ, FAO, or any of the PAEGC Founding Partners.","The designations employed and the presentation of material in this information product do not imply the expression of any opinion whatsoever on the part of Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, Food and Agriculture Organization of the United Nations (FAO) or any of the PAEGC Founding Partners concerning the legal or development status of any country, territory, city or area or of its authorities, or concerning the delimitation of its frontiers or boundaries. The mention of specific companies or products of manufacturers, whether or not these have been patented, does not imply that these have been endorsed or recommended by GIZ, FAO, or any of the PAEGC Founding Partners in preference to others of a similar nature that are not mentioned. The views expressed in this information product are those of the author and do not necessarily reflect the views or policies of GIZ, FAO, or any of the PAEGC Founding Partners.","Les appellations employées dans ce produit d’information et la présentation des documents qui y figurent n’impliquent de la part de la Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, de l’Organisation des Nations unies pour l’alimentation et l’agriculture (FAO) ou de l’un des partenaires fondateurs de l’initiative PAEGC aucune prise de position quant au statut juridique ou au stade de développement des pays, territoires, villes ou zones ou de leurs autorités, ni quant au tracé de leurs frontières ou limites. La mention de sociétés déterminées ou de produits de fabricants, qu’ils soient ou non brevetés, n’entraîne de la part de la GIZ, de la FAO ou de l’un des partenaires fondateurs du PAEGC aucune approbation ou recommandation desdits produits de préférence à d’autres de nature analogue qui ne sont pas cités. Les opinions exprimées dans ce produit d’information sont celles des auteurs et ne reflètent pas nécessairement celles de la GIZ, de la FAO, ou de l’un des partenaires fondateurs du PAEGC.","Las denominaciones empleadas y la presentación del material en este producto informativo no implican juicio alguno por parte de la Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, la Organización de las Naciones Unidas para la Alimentación y la Agricultura (FAO), o los socios fundadores de la iniciativa PAEGC, sobre la condición jurídica o el grado de desarrollo de ninguno de los países, territorios, ciudades o zonas citados o de sus autoridades, ni respecto de la delimitación de sus fronteras o límites. La mención de empresas o productos de fabricantes en particular, estén o no patentados, no implica que la GIZ, la FAO o alguno de los socios fundadores de la iniciativa PAEGC los aprueben o recomienden, dándoles preferencia sobre otros de naturaleza similar que no se mencionan. Las opiniones expresadas en este producto informativo son las de su(s) autor(es) o autora(s), y no reflejan necesariamente los puntos de vista o las políticas de la GIZ, la FAO o ninguno de los socios fundadores de la iniciativa PAEGC.","التسميات المستخدمة وطريقة عرض المواد في هذا المنتج المعلوماتي لا تعبر عن أي رأي من جانب Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH أو منظمة الأغذية والزراعة للأمم المتحدة (FAO) أو أي من الشركاء المؤسسين لـ PAEGC فيما يتعلق بالوضع القانوني أو التنموي لأي بلد أو إقليم أو مدينة أو منطقة أو لسلطاتها ، أو فيما يتعلق بترسيم حدودها أو نطاقاتها. إن ذكر شركات أو منتجات معينة من الشركات المصنعة ، سواء تم تسجيل براءات اختراع لها أم لا ، لا يعني أن هذه الشركات أو المنتجات قد تم اعتمادها أو التوصية بها من قبل GIZ أو منظمة الأغذية والزراعة أو أي من الشركاء المؤسسين لـ PAEGC او تفضيلها على الشركات أو المنتجات الاخرى غير مذكورة من نفس الطبيعة. الآراء الواردة في هذا المنتج المعلوماتي هي آراء المؤلف ولا تعكس بالضرورة آراء أو سياسات الوكالة الألمانية للتعاون الدولي أو منظمة الأغذية والزراعة أو أي من الشركاء المؤسسين  لـ PAEGC."]
[null,null,"GIZ, FAO and the PAEGC Founding Partners encourage 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 and FAO as the source and copyright holder is given.","GIZ, FAO and the PAEGC Founding Partners encourage 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 and FAO as the source and copyright holder is given.","La GIZ, la FAO et les partenaires fondateurs du PAEGC encouragent l’utilisation, la reproduction et la diffusion des informations contenues dans ce document. Sauf indication contraire, ces dernières peuvent être copiées, téléchargées et imprimées à des fins privées d’étude, de recherche et d’enseignement, ou pour être utilisées dans des produits ou services non commerciaux, à condition que la GIZ et la FAO soient clairement indiquées en tant que sources des informations et détentrices du droit d’auteur.","La GIZ, la FAO y los socios fundadores de la iniciativa PAEGC fomentan la utilización, la reproducción y la difusión del material presentado en este producto informativo. A menos que se indique lo contrario, el material puede ser copiado, descargado e impreso con fines de estudio privado, enseñanza e investigación científica, o para su utilización en productos o servicios no comerciales, siempre que se otorgue a la GIZ y la FAO el debido reconocimiento como fuentes y como titulares de los derechos de autor.","تشجع الوكالة الألمانية للتعاون الدولي ومنظمة الأغذية والزراعة والشركاء المؤسسين لـ PAEGC على استخدام واستنساخ ونشر المواد في هذا المنتج المعلوماتي. يمكن نسخ المواد وتنزيلها وطباعتها للدراسة الخاصة ، ولأغراض البحث والتعليم ، أو لاستخدامها في المنتجات أو الخدمات غير التجارية ، ما لم يُذكر خلاف ذلك ، شريطة تقديم إقرار مناسب من الوكالة الألمانية للتعاون الدولي ومنظمة الأغذية والزراعة كمصدر وصاحب حقوق التأليف والنشر."]
[null,null,"© GIZ and FAO, 2021","© GIZ and FAO, 2021","© GIZ et FAO, 2021","© GIZ & FAO, 2021","© GIZ و FAO, 2021"]
[]
[null,{"$f":"$C$8","v":"1 General Information"},{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"INVEST – Farm Analysis Tool"},"INVEST – Farm Analysis Tool","INVESTIR – Outil d’analyse de l’exploitation agricole","INVIERTE – Herramienta de cálculo del balance económico","استثمار - أداة تحليل المزرعة"]
[null,null,"1 GENERAL FARM INFORMATION","1 GENERAL FARM INFORMATION","1 INFORMATIONS GÉNÉRALES SUR LA FERME","1 INFORMACIÓN GENERAL SOBRE LA GRANJA","1 معلومات عامة عن المزرعة"]
[null,null,"Country","Country","Pays","País","الدولة"]
[null,null,"Farm code or name","Farm code or name","Code ou nom de l’exploitation","Código o nombre de la granja","رمز  أو اسم المزرعة"]
[null,null,"Region","Region","Région","Región","المنطقة"]
[null,null,"Date","Date","Date","Fecha","التاريخ"]
[null,null,"Village","Village","Village","Localidad","القرية"]
[null,null,"Division","Division","Division","División","القسم"]
[null,null,"District","District","District","Distrito","الحي"]
[null,null,"Assessor","Assessor","Enquêteur","Asesor","محقق"]
[null,null,"Agricultural planning period (years)","Agricultural planning period (years)","Campagne agricole (années)","Período de planificación agrícola (años)","الحملة الزراعية (سنوات)"]
[null,null,"Currency used for calculation","Currency used for calculation","Monnaie utilisée pour les calculs","Moneda utilizada para el cálculo","العملة المستخدمة في الحسابات"]
[null,null,"Area measurement unit","Area measurement unit","Unité de mesure de surface","Unidad de medida del área","وحدة قياس المساحة"]
[null,null,"(year in  four digits each!)","(year in  four digits each!)","(Année à quatre chiffres chacune!)","(año con cuatro dígitos!)","(سنة مكونة من أربعة أرقام!)"]
[null,null,"ha","ha","ha","ha","هكتار"]
[null,null,"Acre","Acre","acre","acre","أكر"]
[null,null,"Sq. km","Sq. km","km carré","km cuad.","كيلومتر مربع"]
[null,null,"Sq. m","Sq. m","m carré","m cuad.","متر مربع"]
[null,null,"Sq. yard","Sq. yard","verge carrée","yarda cuad.","ياردة مربعة"]
[null,null,"Sq. ft","Sq. ft","pied carré","pie cuad.","قدم مربع"]
[null,null,"LAND RESOURCES","LAND RESOURCES","RESSOURCES FONCIÈRES","RECURSOS DE TIERRAS","موارد الأراضي"]
[null,null,"Property rights","Property rights","Droits de propriété","Derechos de propiedad","حقوق الملكية"]
[null,null,"+ Land owned","+ Land owned","+ Terres en propriété","+ tierras en propiedad","+ أرض مملوكة"]
[null,null,"+ Additional land as part of cooperative land","+ Additional land as part of cooperative land","+ Partie des terres coopératives","+ tierras adicionales como parte de tierras cooperativa","+ أرض إضافية كجزء من أرض التعاونية"]
[null,null,"+ Additional land exploited as a shared grower","+ Additional land exploited as a shared grower","+ Terres exploitées sous contrat (appartenant à un partenaire)","+ tierras adicionales explotadas (colaboración con terceros)","+ استغلال أراضٍ إضافية كمزارع مشترك"]
[null,null,"+ Additional land leased in","+ Additional land leased in","+ Terres prises en location","+ tierras adicionales arrendadas","+ أرض إضافية مؤجرة"]
[null,null,"- Own land leased out","- Own land leased out","- Terres données en location","- tierras en propiedad arrendadas a terceros","- أرض التملك المؤجرة"]
[null,null,"+ Additional land in possession of other sources","+ Additional land in possession of other sources","+ Terres en possession d’autres sources","+ tierras adicionales en posesión de otras fuentes","+ أرض إضافية بحوزة مصادر أخرى"]
[null,null,"-  Own land unused or unusable","-  Own land unused or unusable","- Terres en propriété inutilisées ou inutilisables","-  tierras en propiedad no utilizadas o no utilizables","- تملك أرض غير مستخدمة أو غير صالحة للاستعمال"]
[null,null,"Area","Area","Superficie","Área","المساحة"]
[null,null,"Total","Total","Total","Total","المجموع"]
[null,null,"Land classification","Land classification","Classification des terres","Clasificación de las tierras","تصنيف الأراضي"]
[null,null,"Seasonal crop land","Seasonal crop land","Terres à cultures saisonnières","Tierras de cultivos estacionales","الأراضي الزراعية الموسمية"]
[null,null,"Perennials (with & without option of intercropping)","Perennials (with & without option of intercropping)","Pluriannuelles (avec et sans cultures intercalaires)","Cultivos perennes (con y sin opción de cultivos intercalados)","النباتات المعمرة (مع أو بدون خيار الزراعة البينية)"]
[null,null,"Greenhouses","Greenhouses","Serres","Invernaderos","البيوت البلاستيكية"]
[null,null,"Pastures (grazing land)","Pastures (grazing land)","Pâturages","Pastizales (tierras de pasto)","المراعي (أراضي الرعي)"]
[null,null,"Fallow land","Fallow land","Jachères","Tierra en barbecho","الأرض البور"]
[null,null,"rainfed","rainfed","pluviales","de secano","بعلية"]
[null,null,"irrigated","irrigated","irriguées","de regadío","مروية"]
[null,null,"Total agricultural / horticultural land","Total agricultural / horticultural land","Total des terres agricoles/horticoles","Total de tierras para agricultura/horticultura","مجموع الأراضي الزراعية / البستانية"]
[null,null,"Total area","Total area","Superficie totale","Área total","المساحة الكلية"]
[null,null,"CHECK Property rights","CHECK Property rights","VÉRIFIER Droits de propriété","VERIFICAR Derechos de propiedad","تحقق من حقوق الملكية"]
[]
[null,{"$f":"$C$9","v":"2 Equipment & Assets"},{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"INVEST – Farm Analysis Tool"},"INVEST – Farm Analysis Tool","INVESTIR – Outil d’analyse de l’exploitation agricole","INVIERTE – Herramienta de cálculo del balance económico","استثمار - أداة تحليل المزرعة",null,"استثمار - أداة تحليل المزرعة"]
[null,null,"2 EQUIPMENT & ASSETS","2 EQUIPMENT & ASSETS","2 ÉQUIPEMENTS ET RESSOURCES","2 EQUIPAMIENTO Y ACTIVOS","2 المعدات والأصول"]
[null,null,"Farm code/name","Farm code/name","Code/nom de l’exploitation","Código/nombre de la granja","رمز / اسم المزرعة"]
[null,null,"Type","Type","Type","Tipo","النوع"]
[null,null,"Cost of existing equipment (when originally purchased)","Cost of existing equipment (when originally purchased)","Coût de l'équipement existant (au moment de l'achat initial)","Costo del equipo existente (cuando se compró originalmente)","تكلفة المعدات الموجودة (عند شرائها جديدة)"]
[null,null,"Salvage value (when selling existing equipment)","Salvage value (when selling existing equipment)","Valeur de récupération (lors de la vente d'équipement existant)","Valor residual (al vender equipo existente)","القيمة المتبقية (عند بيع المعدات الموجودة)"]
[null,null,"Age","Age","Âge","Edad","عمر المعدة"]
[null,null,"Normal life span","Normal life span","Durée de vie normale","Vida útil","العمر الإفتراضي"]
[null,null,"Annual depreciation for replacement","Annual depreciation for replacement","Dépréciation annuelle en vue du remplacement","Depreciación anual para sustitución","الاهلاك السنوي "]
[null,null,"years","years","années","años","سنوات"]
[null,null,"Indicative normal life span:","Indicative normal life span:","Durée de vie normale indicative :","Vida útil normal indicativa:","العمر الافتراضي الإرشادي:"]
[null,null,"(highly quality dependent!)","(highly quality dependent!)","(très dépendante de la qualité!)","(según la calidad)","(يعتمد على الجودة بدرجة عالية!)"]
[null,null,"Livestock shed - 20 years","Livestock shed - 20 years","Hangar pour animaux  - 20 years","Cobertizo ganado - 20 años","حظيرة المواشي - 20 سنة"]
[null,null,"Garage / workshop - 20 year","Garage / workshop - 20 year","Garage/atelier – 20 ans","Garaje/taller - 20 años","المرآب / ورشة العمل - 20 سنة"]
[null,null,"Storage / warehouse - 20 years","Storage / warehouse - 20 years","Stockage/entrepôt – 20 ans","Almacén/depósito - 20 años","التخزين / المستودع - 20 سنة"]
[null,null,"Greenhouse - 10 years","Greenhouse - 10 years","Serre - 10 years","Equipamiento invernadero - 10 años","بيت بلاستيكي - 10 سنوات"]
[null,null,"Other building - 20 years","Other building - 20 years","Autre bâtiment – 20 ans","Otra edificación - 20 años","مبنى آخر - 20 سنة"]
[null,null,"Ox cart - 7 years","Ox cart - 7 years","Char à bœufs – 7 ans","Carro de bueyes - 7 años","عربة الثور - 7 سنوات"]
[null,null,"Truck / car - 10 years","Truck / car - 10 years","Camion/voiture – 10 ans","Camión/automóvil - 10 años","شاحنة / سيارة - 10 سنوات"]
[null,null,"Tractor - 10 years","Tractor - 10 years","Tracteur – 10 ans","Tractor - 10 años","جرار - 10 سنوات"]
[null,null,"Plough - 7 years","Plough - 7 years","Charrue – 7 ans","Arado - 7 años","محراث - 7 سنوات"]
[null,null,"Cultivator / tiller - 7 years","Cultivator / tiller - 7 years","Cultivateur/charrue – 7 ans","Cultivador/rotocultivador - 7 años","حراثة - 7 سنوات"]
[null,null,"Sowing machine - 7 years","Sowing machine - 7 years","Semoir – 7 ans","Sembradora - 7 años","آلة البذر - 7 سنوات"]
[null,null,"Fertilizer distributor - 7 years","Fertilizer distributor - 7 years","Épandeur à engrais – 7 ans","Distribuidor de fertilizantes - 7 años","موزع سماد - 7 سنوات"]
[null,null,"Sprayer - 7 years ","Sprayer - 7 years ","Pulvérisateur – 7 ans ","Pulverizador - 7 años ","بخاخ - 7 سنوات"]
[null,null,"Grass cutter  -  7 years","Grass cutter  -  7 years","Faucheuse – 7 ans","Segadora -  7 años","قاطعة العشب - 7 سنوات"]
[null,null,"Baler - 7 years","Baler - 7 years","Presse – 7 ans","Embaladora - 7 años","محزمة - 7 سنوات"]
[null,null,"Cereal harvester - 10 years","Cereal harvester - 10 years","Moissonneuse-batteuse – 10 ans","Cosechadora de cereales - 10 años","حصادة الحبوب - 10 سنوات"]
[null,null,"Irrigation material - 5 years","Irrigation material - 5 years","Matériel d’irrigation – 5 ans","Material de riego - 5 años","معدات الري - 5 سنوات"]
[null,null,"Water pump - 7 years","Water pump - 7 years","Pompe à eau – 7 ans","Bomba de agua - 7 años","مضخة مياه - ٧ سنوات"]
[null,null,"PV modules - 20 years","PV modules - 20 years","Modules photovoltaïques - 20 ans","Generador fotovoltaico - 20 años","ألواح شمسية - 20 سنة"]
[null,null,"Well / borehole - 20 years","Well / borehole - 20 years","puits/forage - 20 ans","Pozo/perforación - 20 años","بئر - 20 سنة"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"Please select"},"Please select","Veuillez sélectionner","Seleccione","الرجاء الاختيار"]
[null,null,"Livestock shed","Livestock shed","Hangar pour animaux","Cobertizo ganado","حظيرة المواشي"]
[null,null,"Garage / workshop","Garage / workshop","garage/atelier","Garaje/taller","المرآب / ورشة العمل"]
[null,null,"Storage / warehouse","Storage / warehouse","Stockage/entrepôt ","Almacén/depósito","التخزين / المستودع"]
[null,null,"Greenhouse","Greenhouse","Serre ","Equipamiento invernadero","بيت بلاستيكي"]
[null,null,"Other building","Other building","Autre bâtiment","Otra edificación","مبنى آخر"]
[null,null,"Ox cart","Ox cart","Char à bœufs","Carro de bueyes","عربة الثور"]
[null,null,"Truck / car","Truck / car","Camion/voiture","Camión/automóvil","شاحنة / سيارة"]
[null,null,"Tractor","Tractor","Tracteur","Tractor","جرار"]
[null,null,"Plough","Plough","Charrue","Arado","محراث"]
[null,null,"Cultivator / tiller","Cultivator / tiller","Cultivateur/charrue","Cultivador/rotocultivador","حراثة"]
[null,null,"Sowing machine","Sowing machine","Semoir","Sembradora","آلة البذر"]
[null,null,"Fertilizer distributor","Fertilizer distributor","Épandeur à engrais","Distribuidor de fertilizantes","موزع سماد"]
[null,null,"Sprayer","Sprayer","Pulvérisateur ","Pulverizador","بخاخ"]
[null,null,"Grass cutter","Grass cutter","Faucheuse","Segadora","قاطعة العشب"]
[null,null,"Baler","Baler","Presse","Embaladora","محزمة العشب"]
[null,null,"Cereal harvester","Cereal harvester","Moissonneuse-batteuse","Cosechadora de cereales","حصادة الحبوب"]
[null,null,"Irrigation material","Irrigation material","Matériel d’irrigation","Material de riego","معدات الري"]
[null,null,"Water pump","Water pump","Pompe à eau","Bomba de agua","مضخة مياه"]
[null,null,"PV generator","PV generator","Modules photovoltaïques","Generador fotovoltaico","ألواح شمسية"]
[null,null,"Well / borehole","Well / borehole","puits/forage","Pozo/perforación","بئر"]
[null,null,"Total Annual Depreciation ","Total Annual Depreciation ","Dépréciation annuelle totale ","Depreciación total anual","إجمالي الإهلاك السنوي"]
[]
[null,{"$f":"$C$10","v":"3 Income Crops & Livestock"},{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"INVEST – Farm Analysis Tool"},"INVEST – Farm Analysis Tool","INVESTIR – Outil d’analyse de l’exploitation agricole","INVIERTE – Herramienta de cálculo del balance económico","استثمار - أداة تحليل المزرعة"]
[null,null,"INCOME: SEASONAL CROP","INCOME: SEASONAL CROP","REVENU : CULTURE SAISONNIÈRE","INGRESOS: CULTIVOS ESTACIONALES","الدخل: المحاصيل الموسمية"]
[null,null,"Farm code/name","Farm code/name","Code/nom de l’exploitation","Código/nombre de la granja","رمز / اسم المزرعة"]
[null,null,"Agricultural land used:","Agricultural land used:","Terres agricoles utilisées :","Terreno agrícola en uso:","الأراضي الزراعية المستخدمة:"]
[null,null,"Season 1","Season 1","Saison 1","Temporada 1","الموسم 1"]
[null,null,"Season 2","Season 2","Saison 2","Temporada 2","الموسم 2"]
[null,null,"Unit","Unit","Unité","Unidad","الوحدة"]
[null,null,"Yield per","Yield per","Rendement par","Rendimiento por","العائد لكل"]
[null,null,"or Quantity","or Quantity","ou Quantité","o cantidad","أو الكمية"]
[null,null,"Unit Price","Unit Price","Prix unitaire","Precio unidad","سعر الوحدة"]
[null,null,"Value","Value","Valeur","Valor","القيمة"]
[null,null,"Sales","Sales","Ventes","Ventas","المبيعات"]
[null,null,"Crop types:","Crop types:","Types de cultures:","Tipos de cultivo","أنواع المحاصيل:"]
[null,null,"Season:","Season:","Saison:","Temporada:","الموسم:"]
[null,null,"Area:","Area:","Surface:","Área:","المساحة:"]
[null,null,"By-products:","By-products:","Produits dérivés:","Subproductos:","المنتجات الثانوية:"]
[null,null,"GROSS INCOME","GROSS INCOME","REVENU BRUT","PRODUCTO BRUTO","الدخل الإجمالي"]
[null,null,"INCOME: PERENNIAL CROP","INCOME: PERENNIAL CROP","REVENU : CULTURE PÉNÉNINIALE","INGRESOS: CULTIVOS PERENNES","الدخل: المحاصيل الدائمة"]
[null,null,"INCOME: LIVESTOCK","INCOME: LIVESTOCK","REVENU : ÉLEVAGE","INGRESOS: GANADERÍA","الدخل: الثروة الحيوانية"]
[null,null,"Livestock for production:","Livestock for production:","Bétail pour la production :","Ganado en la producción:","الثروة الحيوانية للإنتاج:"]
[null,null,"Livestock sold:","Livestock sold:","Bétail vendu :","Ganado vendido","الماشية المباعة:"]
[null,null,"head","head","tête","cabeza","رأس"]
[null,null,"Quantity","Quantity","Quantité","Cantidad","الكمية"]
[null,null,"For Production","For Production","Pour la production","Para la producción","للإنتاج"]
[null,null,"For Sale","For Sale","A Vendre","Para la venta","للبيع"]
[null,null,"Livestock type","Livestock type","Type de bétail","Tipo de ganado","نوع الثروة الحيوانية"]
[null,null,"Dairy cows","Dairy cows","Vaches laitières","Vacas lecheras","الأبقار الحلوب"]
[null,null,"Heifers","Heifers","Génisses","Terneros","عجلة"]
[null,null,"Adult steers","Adult steers","Bœufs adultes","Bueyes adultos","ثور مخصي"]
[null,null,"Juvenile steers","Juvenile steers","Bœufs juvéniles","Bueyes jóvenes","عجل مخصي"]
[null,null,"Calfs","Calfs","Veaux","Becerros","عجول"]
[null,null,"Sheep does","Sheep does","Moutons - brebis","Ovejas hembra","الخراف - نعجة"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"Sheep bucks"},"Sheep bucks","Moutons - bélier","Ovejas macho","الخراف - كبش"]
[null,null,"Sheep kids","Sheep kids","Moutons - agneau","Corderos","الخراف - حمل"]
[null,null,"Goat does","Goat does","Chèvres - chèvre","Cabras hembra","الماعز - عنزة"]
[null,null,"Goat bucks","Goat bucks","Chèvres - boucs","Cabras macho","الماعز - تيس"]
[null,null,"Goat kids","Goat kids","Chèvres - chevreau","Cabritos","الماعز - جدي"]
[null,null,"Chickens","Chickens","Poulets","Pollos","دجاج"]
[null,null,"Milk","Milk","Lait","Leche","حليب"]
[null,null,"Eggs","Eggs","Œufs","Huevos","بيض"]
[null,null,"Skins","Skins","Peaux","Piel","جلود"]
[null,null,"Manure","Manure","Fumier","Estiércol","سماد"]
[null,null,"litres","litres","litres","litros","لترات"]
[null,null,"piece","piece","pièce","trozo","قطعة"]
[null,null,"By-product calculator for","By-product calculator for","Calculateur de produits dérivés","Calculadora para subproductos","الحاسبة للمنتج الثانوي لـ"]
[null,null,"Select","Select","Sélectionner","Seleccione","اختر"]
[null,null,"Daily milk yield:","Daily milk yield:","Rendement laitier journalier :","Producción diaria de leche:","إنتاج الحليب اليومي:"]
[null,null,"litres/day","litres/day","litres/jour","litros / día","لتر / اليوم"]
[null,null,"Number of chickens:","Number of chickens:","Nombre de poulets :","Número de pollos:","عدد الدجاج:"]
[null,null,"Number of dairy livestock:","Number of dairy livestock:","Nombre d'animaux laitiers:","Número de ganado lechero:","عدد مواشي الألبان:"]
[null,null,"Days of milking per year:","Days of milking per year:","Jours de traite par an :","Días de ordeño al año:","أيام الحلب في السنة:"]
[null,null,"Days of egg laying per year:","Days of egg laying per year:","Jours de ponte par an :","Días de puesta de huevos al año:","عدد أيام وضع البيض في السنة:"]
[null,null,"Note: milking (lactation) periods typically range between 209 and 305 days per year for dairy livestock","Note: milking (lactation) periods typically range between 209 and 305 days per year for dairy livestock","Remarque : Les périodes de traite (lactation) varient généralement entre 209 et 305 jours par année pour le bétail laitier","Nota: Los períodos de ordeño (lactancia) generalmente varían entre 209 y 305 días por año para el ganado lechero","ملحوظة: تتراوح فترات الحلب عادةً بين 209 و 305 يومًا في السنة للماشية الحلوب"]
[null,null,"days/year","days/year","jours/an","días/año","أيام / السنة"]
[null,null,"Total","Total","Total","Total","المجموع"]
[null,null,"litres/year","litres/year","litres/an","litros/año","لتر / السنة"]
[null,null,"eggs/year","eggs/year","oeufs/an","huevos/año","بيضة / السنة"]
[]
[null,{"$f":"$C$11","v":"4 Other Income"},{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"INVEST – Farm Analysis Tool"},"INVEST – Farm Analysis Tool","INVESTIR – Outil d’analyse de l’exploitation agricole","INVIERTE – Herramienta de cálculo del balance económico","استثمار - أداة تحليل المزرعة"]
[null,null,"4 OTHER INCOME","4 OTHER INCOME","4 AUTRES RECETTES","4 OTROS INGRESOS","4 مداخيل أخرى"]
[null,null,"Farm code/name","Farm code/name","Code/nom de l’exploitation","Código/nombre de la granja","رمز / اسم المزرعة"]
[null,null,"Month","Month","Mois","Mes","الشهر"]
[null,null,"Monthly/Yearly Costs","Monthly/Yearly Costs","Coûts mensuels / annuels","Costos mensuales / anuales","التكاليف الشهرية / السنوية"]
[null,null,"January","January","Janvier","Enero","يناير"]
[null,null,"February","February","Février","Febrero","فبراير"]
[null,null,"March","March","Mars","Marzo","مارس"]
[null,null,"April","April","Avril","Abril","أبريل"]
[null,null,"May","May","Mai","Mayo","مايو"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"June"},"June","Juin","Junio","يونيو"]
[null,null,"July","July","Juillet","Julio","يوليو"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"August"},"August","Août","Agosto","أغسطس"]
[null,null,"September","September","Septembre","Septiembre","سبتمبر"]
[null,null,"October","October","Octobre","Octubre","أكتوبر"]
[null,null,"November","November","Novembre","Noviembre","نوفمبر"]
[null,null,"December","December","Décembre","Diciembre","ديسمبر"]
[null,null,"Yearly Costs","Yearly Costs","Coûts annuels","Costos anuales","التكاليف السنوية"]
[null,null,"Total","Total","Total","Total","المجموع"]
[null,null,"Type of OTHER INCOME","Type of OTHER INCOME","Type AUTRES RECETTES","Tipo OTROS INGRESOS","نوع المداخيل الأخرى"]
[null,null,"Sale of water","Sale of water","Vente d’eau","Venta de agua","بيع المياه"]
[null,null,"Hire out of equipment","Hire out of equipment","Équipements donnés en location","Alquiler del equipamiento","تأجير المعدات"]
[null,null,"Lease out storage space","Lease out storage space","Espace de stockage donné en location","Arendar espacio de almacenamiento","تأجير مساحة التخزين"]
[null,null,"Lease out land","Lease out land","Terres données en location","Arrendar tierra","تأجير الأرض"]
[null,null,"Lease out labour","Lease out labour","Main-d’œuvre donnée en location","Arrendar mano de obra","تأجير العمالة"]
[null,null,"TOTAL OTHER INCOME per month/year","TOTAL OTHER INCOME per month/year","TOTAL DES AUTRES RECETTES par mois/an","TOTAL OTROS INGRESOS por mes/año","إجمالي المداخيل الأخرى في الشهر / السنة"]
[null,null,"Monthly","Monthly","Mensuel","Mensual","شهري"]
[null,null,"Yearly","Yearly","Annuel","Anual","سنوي"]
[]
[null,{"$f":"$C$12","v":"5 Financing"},{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"INVEST – Farm Analysis Tool"},"INVEST – Farm Analysis Tool","INVESTIR – Outil d’analyse de l’exploitation agricole","INVIERTE – Herramienta de cálculo del balance económico","استثمار - أداة تحليل المزرعة"]
[null,null,"5 CREDIT AND FINANCING (simplified calculator, to be confirmed with loan provider)","5 CREDIT AND FINANCING (simplified calculator, to be confirmed with loan provider)","5 CRÉDIT ET FINANCEMENT (calculateur simplifié, à confirmer auprès du prêteur)","5 CRÉDITOS Y FINANCIACIÓN (calculadora simplificada, a confirmar con proveedor de préstamos)","5 الائتمان والتمويل (آلة حاسبة مبسطة ، يتم تأكيدها مع مقدم القرض)"]
[null,null,"Farm code/name","Farm code/name","Code/nom de l’exploitation","Código/nombre de la granja","رمز / اسم المزرعة"]
[null,null,"Calculator","Calculator","Calculateur","Calculadora","آلة حاسبة"]
[null,null,"Bank name","Bank name","Nom de la banque","Nombre entidad bancaria","اسم البنك"]
[null,null,"Loan amount","Loan amount","Montant du prêt","Importe préstamo","مبلغ القرض"]
[null,null,"Credit period (years)","Credit period (years)","Période de crédit (années)","Período crédito (años)","فترة الائتمان (سنوات)"]
[null,null,"Month of taking credit","Month of taking credit","Mois de la prise de crédit","Mes de aceptación del crédito","شهر أخذ الائتمان"]
[null,null,"Year of taking credit","Year of taking credit","Année de prise de crédit","Año de aceptación del crédito","سنة أخذ الائتمان"]
[null,null,"Annual interest rate","Annual interest rate","Taux d'intérêt annuel","Tasa de interés anual","معدل الفائدة السنوي"]
[null,null,"Monthly loan repayment","Monthly loan repayment","Remboursement mensuel du prêt","Pago mensual del préstamo","سداد القرض الشهري"]
[null,null,"TOTAL CREDIT","TOTAL CREDIT","TOTAL DU CRÉDIT","CRÉDITO TOTAL","إجمالي الائتمان"]
[null,null,"Total Annual Loan Repayments","Total Annual Loan Repayments","Total des remboursements annuels des prêts","Total anual de amortizaciones de préstamos","إجمالي أقساط القرض السنوية"]
[null,null,"OR","OR","OU","O BIEN","أو"]
[null,null,"Enter manually:","Enter manually:","Saisissez manuellement:","Introducir manualmente:","أدخل يدويًا:"]
[null,null,"Note: the Calculator value will take precedence to the manual value. Ensure calculator value is 0 in order to use manual value.","Note: the Calculator value will take precedence to the manual value. Ensure calculator value is 0 in order to use manual value.","Remarque : la valeur de la calculatrice aura priorité sur la valeur manuelle. Assurez-vous que la valeur de la calculatrice est 0 afin d'utiliser la valeur manuelle.","Nota: El valor de la calculadora prevalecerá sobre el valor manual. Para usar el valor manual, asegúrese de que el valor de la calculadora es 0.","ملاحظة: قيمة الآلة الحاسبة لها الأسبقية على القيمة اليدوية. تأكد من أن قيمة الآلة الحاسبة هي 0 من أجل استخدام القيمة اليدوية."]
[]
[null,{"$f":"$C$13","v":"6 Fixed and Variable Costs"},{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"INVEST – Farm Analysis Tool"},"INVEST – Farm Analysis Tool","INVESTIR – Outil d’analyse de l’exploitation agricole","INVIERTE – Herramienta de cálculo del balance económico","استثمار - أداة تحليل المزرعة"]
[null,null,"6 COSTS (FIXED and VARIABLE)","6 COSTS (FIXED and VARIABLE)","6 COÛTS (FIXES et VARIABLES)","6 COSTOS (FIJOS Y VARIABLES)","6 التكاليف الثابتة والمتغيرة"]
[null,null,"Farm code/name","Farm code/name","Code/nom de l’exploitation","Código/nombre de la granja","رمز / اسم المزرعة"]
[null,null,"Month","Month","Mois","Mes","الشهر"]
[null,null,"Monthly/Yearly Costs","Monthly/Yearly Costs","Coûts mensuels / annuels","Costos mensuales / anuales","التكاليف الشهرية / السنوية"]
[null,null,"January","January","Janvier","Enero","يناير"]
[null,null,"February","February","Février","Febrero","فبراير"]
[null,null,"March","March","Mars","Marzo","مارس"]
[null,null,"April","April","Avril","Abril","أبريل"]
[null,null,"May","May","Mai","Mayo","مايو"]
[null,null,"June","June","Juin","Junio","يونيو"]
[null,null,"July","July","Juillet","Julio","يوليو"]
[null,null,"August","August","Août","Agosto","أغسطس"]
[null,null,"September","September","Septembre","Septiembre","سبتمبر"]
[null,null,"October","October","Octobre","Octubre","أكتوبر"]
[null,null,"November","November","Novembre","Noviembre","نوفمبر"]
[null,null,"December","December","Décembre","Diciembre","ديسمبر"]
[null,null,"Yearly Costs","Yearly Costs","Coûts annuels","Costos anuales","التكاليف السنوية"]
[null,null,"Total","Total","Total","Total","المجموع"]
[null,null,"FIXED COSTS","FIXED COSTS","COÛTS FIXES","COSTOS FIJOS","التكاليف الثابتة"]
[null,null,"Financing fees","Financing fees","Frais de financement","Costos por financiación","رسوم التمويل"]
[null,null,"Depreciation costs","Depreciation costs","Coûts d'amortissement","Costos por depreciación","تكاليف الإهلاك"]
[null,null,"Membership fees ","Membership fees ","Cotisations des membres ","Cuotas de afiliación ","رسوم العضوية"]
[null,null,"Insurance costs","Insurance costs","Frais d'assurance","Costos de seguros","تكاليف التأمين"]
[null,null,"Land tax","Land tax","Impôt foncier","Impuesto rústico","ضريبة الأرض"]
[null,null,"Social fund contribution","Social fund contribution","Cotisation au Fonds social","Contribución al fondo social","مساهمة الصندوق الاجتماعي"]
[null,null,"Leasing fees for equipment","Leasing fees for equipment","Frais de location d'équipement","Tasas de arrendamiento de equipamiento","رسوم تأجير المعدات"]
[null,null,"Rental costs for land","Rental costs for land","Frais de location du terrain","Costos de arrendamiento de tierras","تكاليف إيجار الأرض"]
[null,null,"TOTAL FIXED COSTS per month/year","TOTAL FIXED COSTS per month/year","TOTAL DES FRAIS FIXES par mois/an","TOTAL COSTOS FIJOS por mes/año","إجمالي التكاليف الثابتة في الشهر / السنة"]
[null,null,"VARIABLE COSTS","VARIABLE COSTS","FRAIS VARIABLES","COSTOS VARIABLES","التكاليف المتغيرة"]
[null,null,"Fuel and gas costs","Fuel and gas costs","Coûts du carburant et du gaz","Costos de combustible y gas","تكاليف الوقود والغاز"]
[null,null,"Water fees","Water fees","Frais d'eau","Suministro de agua","رسوم المياه"]
[null,null,"Electricity fees","Electricity fees","Frais d'électricité","Suministro de electricidad","رسوم الكهرباء"]
[null,null,"Transport fees ","Transport fees ","Frais de transport ","Tasas de transporte regulares ","رسوم النقل"]
[null,null,"Salary costs (permanent staff)","Salary costs (permanent staff)","Coûts salariaux (personnel permanent)","Salario (personal permanente)","تكاليف المرتبات (الموظفين الدائمين)"]
[null,null,"Salary costs (temporary staff)","Salary costs (temporary staff)","Coûts salariaux (personnel temporaire)","Salario (personal temporal)","تكاليف المرتبات (الموظفين المؤقتين)"]
[null,null,"Seeds","Seeds","Semences","Semillas","بذور"]
[null,null,"Manure and fertilizer","Manure and fertilizer","Fumier et engrais","Estiércol y fertilizante","السماد العضوي والأسمدة"]
[null,null,"Plant protection","Plant protection","Protection des végétaux","Protección de plantas","وقاية النبات"]
[null,null,"Fodder","Fodder","Fourrage","Forraje","علف"]
[null,null,"Veterinary Services","Veterinary Services","Services vétérinaires","Servicios veterinarios","خدمات بيطرية"]
[null,null,"Traction and mechanisation hire","Traction and mechanisation hire","\nLocation traction et mécanisation","Tracción y mecanización","تأجير الجرارات والميكنة"]
[null,null,"Machinery repairs and maintenance","Machinery repairs and maintenance","Réparation et entretien de machines","Maquinaria (mantenimiento y arreglos)","إصلاح الآلات وصيانتها"]
[null,null,"Infrastructure repairs and maintenance","Infrastructure repairs and maintenance","Réparation et entretien de l'infrastructure","Infraestructura (mantenimiento y arreglos)","إصلاحات البنية التحتية وصيانتها"]
[null,null,"Irrigation repair and maintenance","Irrigation repair and maintenance","Réparation et entretien de l'irrigation","Riego (mantenimiento y arreglos)","إصلاح وصيانة الري"]
[null,null,"VARIABLE COSTS per month/month","VARIABLE COSTS per month/month","FRAIS VARIABLES par mois/an","COSTOS VARIABLES por mes/año","التكاليف المتغيرة في الشهر / السنة"]
[]
[null,{"$f":"$C$14","v":"7 Farm Income Statement"},"INVEST – Farm Analysis Tool","INVEST – Farm Analysis Tool","INVESTIR – Outil d’analyse de l’exploitation agricole","INVIERTE – Herramienta de cálculo del balance económico","استثمار - أداة تحليل المزرعة"]
[null,null,"7 FARM INCOME STATEMENT","7 FARM INCOME STATEMENT","7 COMPTE DE RÉSULTAT DE L’EXPLOITATION","7 DECLARACIÓN DE INGRESOS DE LA EXPLOTACIÓN","7 بيان دخل المزرعة"]
[null,null,"Farm code/name","Farm code/name","Code/nom de l’exploitation","Código/nombre de la granja","رمز / اسم المزرعة"]
[null,null,"Gross value of seasonal crop production","Gross value of seasonal crop production","Valeur brute de production de cultures saisonnières","Valor bruto producción cultivos estacionales","القيمة الإجمالية لإنتاج المحاصيل الموسمية"]
[null,null,"Gross value of seasonal crop by-product production","Gross value of seasonal crop by-product production","Valeur brute de production de produits dérivés des cultures saisonnières","Valor bruto producción subproductos cultivos estacionales","القيمة الإجمالية للإنتاج الثانوي للمحاصيل الموسمية"]
[null,null,"Gross value of perennial crop production","Gross value of perennial crop production","Valeur brute de production de cultures pluriannuelles","Valor bruto producción cultivos perennes","القيمة الإجمالية لإنتاج المحاصيل المعمرة"]
[null,null,"Gross value of perennial crop by-product production","Gross value of perennial crop by-product production","Valeur brute de production de produits dérivés des cultures pluriannuelles","Valor bruto producción subproductos cultivos perennes","القيمة الإجمالية للإنتاج الثانوي للمحاصيل المعمرة"]
[null,null,"Gross value of livestock production","Gross value of livestock production","Valeur brute de production d’animaux d’élevage","Valor bruto producción ganado","القيمة الإجمالية للإنتاج الحيواني"]
[null,null,"Gross value of livestock by-product production","Gross value of livestock by-product production","Valeur brute de production de produits dérivés d’animaux d’élevage","Valor bruto producción subproductos ganado ","القيمة الإجمالية للإنتاج الحيواني الثانوي"]
[null,null,"Gross value of other income","Gross value of other income","Valeur brute des autres recettes","Valor bruto de otros ingresos","القيمة الإجمالية للمداخيل الأخرى"]
[null,null,"Anticipated losses of total sales (reduction factor)","Anticipated losses of total sales (reduction factor)","Pertes anticipées sur le total des ventes (facteur de réduction)","Pérdidas anticipadas de total de ventas (factor de reducción)","الخسائر المتوقعة من إجمالي المبيعات (عامل التخفيض)"]
[null,null,"GROSS FARM INCOME","GROSS FARM INCOME","REVENU BRUT DE L’EXPLOITATION","INGRESOS BRUTOS DE LA GRANJA","إجمالي دخل المزرعة"]
[null,null,"Total fixed costs","Total fixed costs","Total des coûts fixes","Total costos fijos","إجمالي التكاليف الثابتة"]
[null,null,"Total variable costs","Total variable costs","Total des coûts variables","Total costos variables","إجمالي التكاليف المتغيرة"]
[null,null,"TOTAL COST","TOTAL COST","TOTAL DES COÛTS","TOTAL DE COSTOS","التكلفة الإجمالية"]
[null,null,"GROSS FARM PROFIT for the period","GROSS FARM PROFIT for the period","RÉSULTAT BRUT DE LA FERME pour la période","BENEFICIO BRUTO DE LA GRANJA para el período","إجمالي أرباح المزرعة للفترة"]
[null,null,"to","to","à","a","إلى"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"Farm Profit Margin "},"Farm Profit Margin ","Marge bénéficiaire de l’exploitation ","Margen de beneficio agrícola","هامش ربح المزرعة"]
[null,null,"Average profit per","Average profit per","Bénéfice moyen par","Beneficio promedio por","متوسط الربح لكل"]
[null,null,"for seasonal crops:","for seasonal crops:","pour les cultures saisonnières:","para cultivos estacionales:","للمحاصيل الموسمية:"]
[null,null,"for perennial crops:","for perennial crops:","pour les cultures pérennes:","para cultivos perennes:","للمحاصيل المعمرة:"]
[null,null,"Average profit per head of livestock:","Average profit per head of livestock:","Bénéfice moyen par tête de bétail:","Beneficio promedio por cabeza de ganado:","متوسط الربح لكل رأس من الماشية:"]
[null,null,"Total crop area under cultivation:","Total crop area under cultivation:","Superficie totale en culture:","Área total bajo cultivo:","إجمالي مساحة المحصول المزروعة:"]
[null,null,"per","per","par","por","لكل"]
[null,null,"no crops","no crops","pas de cultures","sin cultivos","لا محاصيل"]
[null,null,"no livestock","no livestock","pas de bétail","sin ganado","لا ماشية"]
[null,null,"per head","per head","par tête","por cabeza","لكل رأس"]
[null,null,"Total annual fixed and variable costs","Total annual fixed and variable costs","Total des coûts fixes et variables annuels","Total de costos fijos y variables anuales ","إجمالي التكاليف الثابتة والمتغيرة السنوية"]
[null,null,"Fixed","Fixed","Fixé","Fijo","ثابتة"]
[null,null,"Variable","Variable","Variable","Variable","متغيرة"]
[null,null,"Cultivated area does not match available crop area (1. General Information)","Cultivated area does not match available crop area (1. General Information)","La superficie cultivée ne correspond pas à la superficie cultivée disponible (1. Informations générales)","El área cultivada no coincide con el área de cultivo disponible (1. Información general)","المساحة المزروعة لا تتطابق مع مساحة المحاصيل المتاحة (1. معلومات عامة)"]
[]
[null,{"$f":"$C$15","v":"Crop Price Calculation Sheet"},"INVEST – Farm Analysis Tool","INVEST – Farm Analysis Tool","INVESTIR – Outil d’analyse de l’exploitation agricole","INVIERTE – Herramienta de cálculo del balance económico","استثمار - أداة تحليل المزرعة"]
[null,null,"Supplementary sheet for calculating average annual costs for selected crops and livestock based on seasonal monthly variations","Supplementary sheet for calculating average annual costs for selected crops and livestock based on seasonal monthly variations","Feuille supplémentaire permettant de calculer les coûts annuels moyens de certaines cultures et de certains animaux d’élevage sur la base des variations mensuelles saisonnières","Hoja suplementaria para calcular los costos anuales promedio de cultivos y ganado seleccionados sobre la base de variaciones mensuales estacionales","ورقة تكميلية لحساب متوسط التكاليف السنوية لبعض المحاصيل والماشية المختارة بناءً على التغيرات الشهرية الموسمية"]
[null,null,"AVERAGE","AVERAGE","MOYENNE","PROMEDIO","المتوسط"]
[null,null,"Seasonal Crops","Seasonal Crops","Cultures saisonnières","Cultivos estacionales","المحاصيل الموسمية"]
[null,null,"Perennial crops","Perennial crops","Cultures pluriannuelles","Cultivos perennes","المحاصيل المعمرة"]
[null,null,"Livestock","Livestock","Animaux d’élevage","Ganado","الماشية"]
[null,null,0]
[null,{"$f":"$C$16","v":"Quick Check"},"INVEST – Farm Analysis Tool","INVEST – Farm Analysis Tool","INVESTIR – Outil d’analyse de l’exploitation agricole","INVIERTE – Herramienta de cálculo del balance económico","استثمار - أداة تحليل المزرعة"]
[null,null,"QUICK CHECK","QUICK CHECK","CONTRÔLE RAPIDE","VERIFICACIÓN RÁPIDA","فحص سريع"]
[null,null,"Annual Expenditure","Annual Expenditure","Dépenses annuelles","Gasto annual","النفقات السنوية"]
[null,null,"Expenditure Type","Expenditure Type","Nature de la dépense","Tipo de gasto","نوع الإنفاق"]
[null,null,"Examples","Examples","Exemples","Ejemplos","أمثلة"]
[null,null,"Annual Amount","Annual Amount","Montant annuel","Importe anual","القيمة السنوية"]
[null,null,"Seasonal crop expenses","Seasonal crop expenses","Coûts des cultures saisonnières","Gastos cultivos estacionales","نفقات المحاصيل الموسمية"]
[null,null,"Perennial crop expenses","Perennial crop expenses","Dépenses liées aux cultures pérennes","Gastos cultivos perennes","نفقات المحاصيل المعمرة"]
[null,null,"Livestock expenses","Livestock expenses","Dépenses liées au bétail ","Gastos ganado","نفقات الثروة الحيوانية"]
[null,null,"Operation and maintenance \n- Infrastructure","Operation and maintenance \n- Infrastructure","Exploitation et maintenance \n- Infrastructure","Operación y mantenimiento\n- Infraestructura","التشغيل والصيانة\n- البنية التحتية"]
[null,null,"Operation and maintenance\n- Fixed equipment","Operation and maintenance\n- Fixed equipment","Exploitation et maintenance\n- Équipements fixes","Operación y mantenimiento\n- Equipo fijo","التشغيل والصيانة\n- المعدات الثابتة "]
[null,null,"Operation and maintenance \n- Movable equipment","Operation and maintenance \n- Movable equipment","Exploitation et maintenance \n- Équipement mobile","Operación y mantenimiento\n- Equipo móvil","التشغيل والصيانة\n- المعدات المنقولة "]
[null,null,"Labour","Labour","Main-d'œuvre","Mano de obra","العمالة"]
[null,null,"Sales and distribution","Sales and distribution","Vente et distribution","Ventas y distribución","المبيعات و التوزيع"]
[null,null,"Management and administration","Management and administration","Gestion et administration","Manejo y administración","التنظيم والإدارة"]
[null,null,"Seedlings, pesticides, fertilisers, protection, etc","Seedlings, pesticides, fertilisers, protection, etc","Semis, pesticides, engrais, protection, etc.","Plántulas, pesticidas, fertilizantes, protección, etc","الشتلات ، المبيدات ، الأسمدة ، الحماية ، إلخ"]
[null,null,"Seedlings, pesticides, fertilisers, protection, etc","Seedlings, pesticides, fertilisers, protection, etc","Semis, pesticides, engrais, protection, etc.","Plántulas, pesticidas, fertilizantes, protección, etc","الشتلات ، المبيدات ، الأسمدة ، الوقاية ، إلخ"]
[null,null,"New livestock, fodder, slaughtering, veterinary services, etc","New livestock, fodder, slaughtering, veterinary services, etc","Nouveau bétail, fourrage, abattage, services vétérinaires, etc.","Nuevo ganado, forraje, matanza, servicios veterinarios, etc","مواشي جديدة ، علف ، ذبح ، خدمات بيطرية ، إلخ"]
[null,null,"Building renovations, painting, plastering, fencing, electricity, water, etc ","Building renovations, painting, plastering, fencing, electricity, water, etc ","Rénovations de bâtiments, peinture, plâtrage, clôtures, électricité, eau, etc. ","Renovaciones de edificios, pintura, yesería, cercas, electricidad, agua, etc","ترميمات المباني ، الطلاء ، الجص ، الأسوار ، الكهرباء ، المياه ، إلخ"]
[null,null,"Water pumps, irrigation equipment, packaging equipment, milling, fuel, spare parts, repairs, etc","Water pumps, irrigation equipment, packaging equipment, milling, fuel, spare parts, repairs, etc","Pompes à eau, matériel d'irrigation, matériel d'emballage, broyage, carburant, pièces de rechange, réparations, etc.","Bombas de agua, equipos de riego, equipos de embalaje, fresado, combustible, piezas de repuesto, reparaciones, etc","مضخات المياه ، معدات الري ، معدات التغليف ، الطحن ، الوقود ، قطع الغيار ، التصليح ، إلخ"]
[null,null,"Tractor, trucks, plough, trailer, fuel, spare parts, repairs, etc","Tractor, trucks, plough, trailer, fuel, spare parts, repairs, etc","Tracteur, camions, charrue, remorque, carburant, pièces de rechange, réparations, etc.","Tractor, camiones, arado, remolque, combustible, piezas de repuesto, reparaciones, etc.","جرار ، شاحنات ، محراث ، مقطورة ، وقود ، قطع غيار ، إصلاحات ، إلخ"]
[null,null,"Salaries, benefits, own salary (?) etc","Salaries, benefits, own salary (?) etc","Salaires, avantages sociaux, salaire propre etc.","Salarios, beneficios, salario propio (?), etc","الرواتب والمزايا والراتب الخاص (؟) إلخ"]
[null,null,"Packaging, fees, advertising, etc","Packaging, fees, advertising, etc","Emballage, frais, publicité, etc.","Embalaje, tarifas, publicidad, etc","التعبئة والتغليف والرسوم والدعاية وما إلى ذلك"]
[null,null,"Rent, office consumables, insurance, memberships, loan repayments, etc","Rent, office consumables, insurance, memberships, loan repayments, etc","Loyer, consommables de bureau, assurances, adhésions, remboursements de prêts, etc.","Alquiler, consumibles de oficina, seguros, membresías, reembolsos de préstamos, etc","الإيجار ، والمواد الاستهلاكية المكتبية ، والتأمين ، والعضويات ، وسداد القروض ، إلخ"]
[null,null,"Annual Income","Annual Income","Revenu annuel","Ingreso annual","الدخل السنوي"]
[null,null,"Income Type","Income Type","Type de revenu","Tipo de ingreso","نوع الدخل"]
[null,null,"Seasonal crop sales","Seasonal crop sales","Ventes de cultures saisonnières","Ventas cultivos estacionales","مبيعات المحاصيل الموسمية"]
[null,null,"By-products from seasonal crops","By-products from seasonal crops","Produits dérivés des cultures saisonnières","Subproductos de cultivos estacionales","المنتجات الثانوية من المحاصيل الموسمية"]
[null,null,"Perennial crop sales","Perennial crop sales","Ventes de cultures pérennes","Ventas cultivos perennes","مبيعات المحاصيل المعمرة"]
[null,null,"By-products from perennial crops","By-products from perennial crops","Produits dérivés des cultures pérennes","Subproductos de cultivos perennes","المنتجات الثانوية من المحاصيل المعمرة"]
[null,null,"Livestock sales","Livestock sales","Ventes de bétail","Venta de ganado","بيع الماشية"]
[null,null,"By-products from livestock","By-products from livestock","Produits dérivés de l'élevage","Subproductos de ganado","المنتجات الثانوية من الماشية"]
[null,null,"Lease income","Lease income","Revenus de location","Ingresos por arrendamientos","دخل الإيجار"]
[null,null,"Services income","Services income","Revenus des services","Ingresos por servicios","دخل الخدمات"]
[null,null,"Tomatos, grain, rice, value added product, etc","Tomatos, grain, rice, value added product, etc","Tomates, céréales, riz, produits à valeur ajoutée, etc.","Tomates, granos, arroz, productos de valor agregado, etc","الطماطم، الحبوب، الأرز، والمنتجات ذات القيمة المضافة ، إلخ"]
[null,null,"Compost, fodder, value added product, etc","Compost, fodder, value added product, etc","Compost, fourrage, produit à valeur ajoutée, etc.","Compost, forraje, producto de valor agregado, etc","السماد، الأعلاف، والمنتجات ذات القيمة المضافة، الخ"]
[null,null,"Citrus, apples, dates, berries, value added product, etc","Citrus, apples, dates, berries, value added product, etc","Agrumes, pommes, dattes, baies, produits à valeur ajoutée, etc.","Cítricos, manzanas, dátiles, bayas, productos de valor agregado, etc","الحمضيات، التفاح، التمر، التوت، والمنتجات ذات القيمة المضافة ، إلخ"]
[null,null,"Wood fuel, mulch, value added product, etc","Wood fuel, mulch, value added product, etc","Bois de chauffage, paillis, produits à valeur ajoutée, etc.","Madera de combustión, mantillo, producto de valor agregado, etc","الوقود الخشبي، الغطاء العضوي، والمنتجات ذات القيمة المضافة، الخ"]
[null,null,"Cattle, sheep, chickens, etc","Cattle, sheep, chickens, etc","Bovins, moutons, poulets, etc.","Ganado, ovejas, gallinas, etc","الماشية والأغنام والدجاج وغيرها"]
[null,null,"Manure, eggs, milk, wool, value added product, etc","Manure, eggs, milk, wool, value added product, etc","Fumier, œufs, lait, laine, produit à valeur ajoutée, etc.","Estiécrol, huevos, leche, lana, producto de valor agregado","السماد الطبيعي، البيض، الحليب، الصوف، والمنتجات ذات القيمة المضافة ، إلخ"]
[null,null,"Labour, vehicles, land, etc","Labour, vehicles, land, etc","Main-d'œuvre, véhicules, terrains, etc.","Mano de obra, vehículos, tierra, etc","العمالة ، المركبات ، الأرض ، إلخ"]
[null,null,"Subcontract work, maintenance service, packaging service, transport, etc","Subcontract work, maintenance service, packaging service, transport, etc","Sous-traitance, service d'entretien, service d'emballage, transport, etc.","Trabajo subcontratado, servicio de mantenimiento, servicio de empaque, transporte, etc","أعمال المقاولة الفرعیة ، خدمة الصيانة ، خدمة التغليف ، النقل ، إلخ"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":"Profit or loss"},"Profit or loss","Profit ou perte","Balance aproximado:","الربح أو الخسارة"]
[null,null,"This activity is profitable! Proceed with a detailed analysis to be sure.","This activity is profitable! Proceed with a detailed analysis to be sure.","Cette activité est rentable ! Procédez à une analyse détaillée pour être sûr.","¡Esta actividad es rentable! Proceda con un análisis detallado para estar seguro.","هذا النشاط مربح! المضي قدما في تحليل مفصل للتأكد."]
[null,null,"This activity is not profitable. Review your values or consider additional income opportunities or ways to reduce expenses.","This activity is not profitable. Review your values or consider additional income opportunities or ways to reduce expenses.","Cette activité n'est pas rentable. Revoyez vos valeurs ou envisagez des opportunités de revenus supplémentaires ou des moyens de réduire les dépenses.","Esta actividad no es rentable. Revise sus valores o considere oportunidades de ingresos adicionales o formas de reducir gastos.","هذا النشاط غير مربح. مراجعة القيم الخاصة بك أو النظر في فرص الدخل الإضافي أو وسائل للحد من النفقات."]
[null,null,"Calculator","Calculator","Calculatrice","Calculadora","آلة حاسبة"]
[null,null,"add up:","add up:","additionner :","sumar:","جمع:"]
[null,null,"multiply:","multiply:","multiplier :","multiplicar:","ضرب:"]
[null,null,"divide:","divide:","diviser :","dividir:","قسمة:"]
[null,null,"a.","a.","a.","a.","أ."]
[null,null,"b.","b.","b.","b.","ب."]
[null,null,"c.","c.","c.","c.","ج."]
[null,null,"d.","d.","d.","d.","د."]
[null,null,"e.","e.","e.","e.","ه."]
[null,null,"Total","Total","Total","Total","المجموع"]
[]
[null,"COMMENTS (Note Boxes)"]
[null,{"$f":"$C$10","v":"3 Income Crops & Livestock"},"The sum of the crop areas per season should not exceed the available area","The sum of the crop areas per season should not exceed the available area","La somme des surfaces cultivées par saison ne doit pas dépasser la surface disponible","La suma de las áreas de cultivo por temporada no debe exceder el área disponible","يجب ألا يتجاوز مجموع مساحات المحاصيل لكل موسم المساحة المتاحة"]
[null,{"$f":"$C$11","v":"4 Other Income"},"Select \"Monthly\" or \"Yearly\", according to the available data","Select \"Monthly\" or \"Yearly\", according to the available data","Sélectionnez « Mensuel » ou « Annuel », selon les données disponibles","Seleccione \"Mensual\" o \"Anual\", según los datos disponibles","اختر \"شهري\" أو \"سنوي\" حسب البيانات المتوفرة"]
[null,{"$f":"$C$13","v":"6 Fixed and Variable Costs"},"from \"5 Financing\" sheet","from \"5 Financing\" sheet","de la fiche \"5 Financement\"","de la hoja \"5 Financiación\"","من ورقة \"5 التمويل\""]
[null,null,"from \"2 Equipment & Assets\" sheet","from \"2 Equipment & Assets\" sheet","de la fiche \"2 Équipements et actifs\"","de la hoja \"2 Equipamiento y activos\"","من ورقة \"2 المعدات والأصول\""]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$I$594,ROW()-ROW($B$5),FALSE)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]

{"sheet":"Graph table","index":11,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[{"$f":"'6 Fixed and Variable Costs'!B8","v":"FIXED COSTS"},{"$f":"'6 Fixed and Variable Costs'!B9","v":"Financing fees"},{"$f":"'6 Fixed and Variable Costs'!Q9","v":2632.2546987601909}]
[null,{"$f":"'6 Fixed and Variable Costs'!B10","v":"Depreciation costs"},{"$f":"'6 Fixed and Variable Costs'!Q10","v":2777.7777777777778}]
[null,{"$f":"'6 Fixed and Variable Costs'!B11","v":"Membership fees "},{"$f":"'6 Fixed and Variable Costs'!Q11","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B12","v":"Insurance costs"},{"$f":"'6 Fixed and Variable Costs'!Q12","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B13","v":"Land tax"},{"$f":"'6 Fixed and Variable Costs'!Q13","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B14","v":"Social fund contribution"},{"$f":"'6 Fixed and Variable Costs'!Q14","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B15","v":"Leasing fees for equipment"},{"$f":"'6 Fixed and Variable Costs'!Q15","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B16","v":"Rental costs for land"},{"$f":"'6 Fixed and Variable Costs'!Q16","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B17","v":"-"},{"$f":"'6 Fixed and Variable Costs'!Q17","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B18","v":"-"},{"$f":"'6 Fixed and Variable Costs'!Q18","v":0}]
[{"$f":"'6 Fixed and Variable Costs'!B21","v":"VARIABLE COSTS"},{"$f":"'6 Fixed and Variable Costs'!B22","v":"Fuel and gas costs"},{"$f":"'6 Fixed and Variable Costs'!Q22","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B23","v":"Water fees"},{"$f":"'6 Fixed and Variable Costs'!Q23","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B24","v":"Electricity fees"},{"$f":"'6 Fixed and Variable Costs'!Q24","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B25","v":"Transport fees "},{"$f":"'6 Fixed and Variable Costs'!Q25","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B26","v":"Salary costs (permanent staff)"},{"$f":"'6 Fixed and Variable Costs'!Q26","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B27","v":"Salary costs (temporary staff)"},{"$f":"'6 Fixed and Variable Costs'!Q27","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B28","v":"Seeds"},{"$f":"'6 Fixed and Variable Costs'!Q28","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B29","v":"Manure and fertilizer"},{"$f":"'6 Fixed and Variable Costs'!Q29","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B30","v":"Plant protection"},{"$f":"'6 Fixed and Variable Costs'!Q30","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B31","v":"Fodder"},{"$f":"'6 Fixed and Variable Costs'!Q31","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B32","v":"Veterinary Services"},{"$f":"'6 Fixed and Variable Costs'!Q32","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B33","v":"Traction and mechanisation hire"},{"$f":"'6 Fixed and Variable Costs'!Q33","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B34","v":"Machinery repairs and maintenance"},{"$f":"'6 Fixed and Variable Costs'!Q34","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B35","v":"Infrastructure repairs and maintenance"},{"$f":"'6 Fixed and Variable Costs'!Q35","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B36","v":"Irrigation repair and maintenance"},{"$f":"'6 Fixed and Variable Costs'!Q36","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B37","v":"-"},{"$f":"'6 Fixed and Variable Costs'!Q37","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B38","v":"-"},{"$f":"'6 Fixed and Variable Costs'!Q38","v":0}]

{"sheet":"List of dropdown","index":12,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[]
["Area","CF to ha"]
[{"$f":"Translate!C78","v":"ha"},1]
[{"$f":"Translate!C79","v":"Acre"},2.47105]
[{"$f":"Translate!C80","v":"Sq. km"},0.01]
[{"$f":"Translate!C81","v":"Sq. m"},10000]
[{"$f":"Translate!C82","v":"Sq. yard"},11959.9]
[{"$f":"Translate!C83","v":"Sq. ft"},107639]
[]
[]
["Season"]
[]
[{"$f":"Translate!$C$166","v":"Season 1"}]
[{"$f":"Translate!$C$167","v":"Season 2"}]
[]
["Total irrigated Area",{"$f":"SUM('1 General Information'!$E$31:$F$31)","v":1}]
[null,null,"Crop","Season","Area"]
[null,null,"Crop 1",{"$f":"'3 Income Crops & Livestock'!$C10","v":0},{"$f":"'3 Income Crops & Livestock'!$D10","v":0.5}]
[null,null,"Crop 2",{"$f":"'3 Income Crops & Livestock'!$C11","v":0},{"$f":"'3 Income Crops & Livestock'!$D11","v":0.5}]
[null,null,"Crop 3",{"$f":"'3 Income Crops & Livestock'!$C12","v":0},{"$f":"'3 Income Crops & Livestock'!$D12","v":0.5}]
[null,null,"Crop 4",{"$f":"'3 Income Crops & Livestock'!$C13","v":0},{"$f":"'3 Income Crops & Livestock'!$D13","v":0.5}]
[null,null,"Crop 5",{"$f":"'3 Income Crops & Livestock'!$C14","v":0},{"$f":"'3 Income Crops & Livestock'!$D14","v":0}]
[null,null,"Crop 6",{"$f":"'3 Income Crops & Livestock'!$C15","v":0},{"$f":"'3 Income Crops & Livestock'!$D15","v":0}]
[null,{"$f":"$E$24<=$B$16","v":true},{"$f":"Translate!$C$166","v":"Season 1"},"Total area",{"$f":"SUMIF($D$18:D23, $C$24,$E$18:$E$23)","v":0}]
[null,{"$f":"$E$25<=$B$16","v":true},{"$f":"Translate!$C$167","v":"Season 2"},"Total area",{"$f":"SUMIF($D$18:D23, $C$25,$E$18:$E$23)","v":0}]
[]
[]
["Costs"]
[{"$f":"Translate!$C$246","v":"Monthly"}]
[{"$f":"Translate!$C$247","v":"Yearly"}]