{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Welkom","Info","Invoer gegevens"," Rekenblad 1","Rekenblad 2","Resultaat"],"not_rendered":{"charts":16,"images":7,"macros":1,"external_links":2,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Welkom","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ENDIFE"]
[null,"Educatie- eN DIagnose voor Financieel-Economische gezondheid"]
[]
[]
[null,"Auteurs: Erwin Wauters, Dries Loncke, Jef Van Meensel"]
[null,"Gemaakt in het kader van het demonstratieproject 'Witloofbarometer' i.o.v. het Departement Landbouw en Visserij"]
[null,"Projectpartners: Nationale Proeftuin voor Witloof (projectleider), Inagro, ILVO en BB-Consult"]
[]
[]
[null,"Contact: "]
[null,"Tim De Clercq (Nationale Proeftuin voor Witloof, tim.declercq@vlaamsbrabant.be)"]
[null,"Tania De Marez (Inagro, tania.demarez@inagro.be)"]
[null,"Christien Miroir (BB-Consult,christien.miroir@boerenbond.be)"]
[]
[]
[null,"Aansprakelijkheidsbeperking\nENDIFETM werd door het ILVO met de meeste zorg en nauwkeurigheid ontwikkeld. Er wordt evenwel geen enkele garantie gegeven omtrent de juistheid of de volledigheid van de informatie geleverd door ENDIFETM. De gebruiker van ENDIFETM ziet af van elke klacht tegen het ILVO of zijn ambtenaren, van welke aard ook, met betrekking tot het gebruik van de via ENDIFETM beschikbaar gestelde informatie. In geen geval zal het ILVO of zijn ambtenaren aansprakelijk gesteld kunnen worden voor eventuele nadelige gevolgen die voortvloeien uit het gebruik van de via ENDIFETM beschikbaar gestelde informatie.\nENDIFETM is een gedeponeerd handelsmerk.\n"]

{"sheet":"Info","index":1,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ENDIFE"]
[null,"Educatie- eN DIagnose voor Financieel-Economische gezondheid"]
[]
[]
[]
[null,"ENDIFE is een programma dat in staat is om de economische en financiële toestand van uw witloofbedrijf onder de loep te nemen op basis van gegevens uit de bedrijfseconomische boekhouding. Het economisch luik is vooral een indicatie van de gezondheid van uw bedrijf op een iets langere termijn, terwijl het financieel luik eerder meet hoe goed het bedrijf erin slaagt om te voldoen aan de cashverplichtingen op korte termijn. Verschillende parameters zullen door het programma worden berekend en afgetoetst aan gewenste streefwaarden. Vervolgens worden ook tips meegegeven over hoe u de economische en financiële toestand van uw bedrijf verder kan optimaliseren."]
[]
[null,"Invoer"]
[]
[null,"In tabblad \"Invoer gegevens\" vult u de gegevens uit de bedrijfseconomische boekhouding in. Het gaat hierbij over de resultatenrekening, de balans en enkele algemene bedrijfsgegevens."]
[]
[null,"Analyse"]
[]
[null,"Het model berekent op basis van de ingevoerde gegevens enkele indicatoren die het economisch prestatievermogen van uw bedrijf analyseren, alsook de mate waarin uw bedrijf in staat is om aan de lopende financiële verplichtingen te voldoen. In het \"Resultaat\" tabblad staat voor elke indicator een barometer die aangeeft of uw bedrijf Goed, Matig of Zwak scoort op deze indicator. Voor elke indicator is ook een fiche voorzien met uitleg en mogelijke verbeteropties."]
[]
[null,"Opmerkingen"]
[]
[null,"ENDIFE kan enkel gebruikt worden indien macro's zijn ingeschakeld."]
[]
[null,"Voor zowel witloofteelt in de grond als op hydrocultuur zijn reeds voorbeeldwaarden uit de sector beschikbaar. U kunt de tool ook toepassen op uw eigen bedrijf. Hiervoor heeft u gegevens uit de bedrijfseconomische boekhouding nodig."]

{"sheet":"Invoer gegevens","index":2,"n_rows":95,"n_cols":15,"rows_kept":95,"cut":false,"hidden":false,"merged":[[5,1,5,2],[8,1,8,3],[8,5,8,7],[8,9,8,11]]}
["In dit tabblad moeten gegevens uit de boekhouding ingevuld worden. "]
["Om voorbeeldwaarden te bekijken, geeft u eerst een jaartal op waarvan u de waarden wilt zien. Daarna klikt u op \"Toon voorbeeldwaarden\"."]
["Om de voorbeeldwaarden terug weg te doen, klikt u op \"Wis voorbeeldwaarden\". U kan daarna ook uw eigen bedrijfsgegevens invullen."]
[]
[]
["Hydrocultuur","Kies een referentiejaar (2010-2014):",null,2013]
[]
[]
[null,"Resultatenrekening",null,null,null,"Balans",null,null,null,"Algemeen"]
[null,null,null,"Voorbeeldbedrijf",null,null,null,"Voorbeeldbedrijf",null,null,null,"Voorbeeldbedrijf"]
[null,"Opbrengsten",null,{"$f":"SUM(D12:D14)","v":394290.41000000003},null,"Activa",null,{"$f":"SUM(H12:H17)","v":1524821.2150000001},null,"Algemene bedrijfsgegevens"]
[null,"Ontvangsten witloof","€",313527.88,null,"Gebouwen","€",789744.22,null,"Eigen arbeid","aantal volwaardige arbeidskrachten (VAK)*",2.0499999999999998]
[null,"Andere ontvangsten (via verkoop van andere producten en bijproducten)","€",80762.53,null,"Machines","€",510386.19300000009,null,"Totaal kg geoogst witloof","kg",321690.94]
[null,"Varia (verkoop machines, installatiepremies VLIF, pachtafstandsvergoedingen,…)","€",0,null,"Cash","€",0,null,"Niet-landbouwinkomen","€",0]
[null,null,null,null,null,"Voorraden (teeltproducten, \nmeststoffen, brandstoffen en olie)","€",70000,null,"Gezinsuitgaven","€",0]
[null,"Variabele kosten",null,{"$f":"SUM(D17:D25)","v":215422.7856},null,"Voorschotten","€",0,null,"Aflossingen (leningen)","€",41000]
[null,"Zaaigoed","€",24534.674800000001,null,"Grond","€",154690.802]
[null,"Meststoffen","€",11493.9768]
[null,"Gewasbescherming","€",15982.239800000001,null,"Passiva",null,{"$f":"SUM(H20:H22)","v":1524821.2150000001}]
[null,"Bewaring","€",2086.8100000000004,null,"Schulden korte termijn \n(binnen het jaar)","€",41000]
[null,"Verwarming","€",2478.6576,null,"Schulden lange termijn \n(langer dan een jaar)","€",369000]
[null,"Energie en water","€",37821.111199999999,null,"Eigen vermogen","€",{"$f":"H11-(H20+H21)","v":1114821.2150000001}]
[null,"Afzet en vermarkting","€",4418.9110000000001]
[null,"Loonwerk en seizoenslonen","€",104804.6844]
[null,"Diverse (andere dan bovengenoemde)","€",11801.719999999998]
[]
[null,"Vaste kosten",null,{"$f":"SUM(D28:D35)","v":269908.34019999998}]
[null,"Betaalde arbeid (loon van werknemers)","€",6465.2579999999998]
[null,"Fictieve arbeid (Aangerekend loon van de bedrijfsleider en/of zijn gezinsleden. Richtwaarde: 15,45 €/uur)","€",79600.117200000008]
[null,"Betaalde rente (intrest betaald op schulden)","€",11645.592000000001]
[null,"Fictieve rente (Intrestkost op alle eigen kapitaal. Het standaard-\npercentage bedraagt 5%)","€",32052.836000000003]
[null,"Fictieve pacht (Fictieve huursom voor gebruik van eigen grond. De gemiddelde pachtprijs van de streek is richtinggevend)","€",1956.6260000000002]
[null,"Betaalde pacht (huursom van grond die gehuurd wordt)","€",70837.105599999995]
[null,"Afschrijvingen (jaarlijkse kost voor machines, gebouwen,…)","€",62058.317999999992]
[null,"Algemene vaste kosten (verzekeringen, vergunningen, lidgelden, autokosten…)","€",5292.4874]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Voorbeeldbedrijf"]
["Resultatenrekening: grondteelt",null,null,null,null,"Balans: grondteelt",null,null,null,null,"Algemeen: grondteelt"]
[2010,2011,2012,2013,2014,2010,2011,2012,2013,2014,2010,2011,2012,2013,2014]
[41952.797999999995,35423.206599999998,35247.2716,41113.623599999992,30640.569200000005,129530.523,170539.66400000002,132734.1,135308.35699999999,201833.78999999998,2.274,1.466,1.9120000000000001,1.8320000000000001,1.544]
[51047.762600000009,41972.993999999992,93234.193199999994,83832.936799999996,106312.68099999998,200712.20299999998,248147.59999999995,163682.25,269909.22500000003,355310.42000000004,21935.4,15789.8,15869.3,14238.8,16390.166000000001]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[3987.7544000000007,4010.3540000000003,9458.9096000000009,5699.0963999999994,12094.822400000001,40000,40000,40000,40000,40000,0,0,0,0,0]
[3057.6293999999998,3834.8019999999997,6908.7978000000003,4952.3441999999986,13182.143600000001,0,0,0,0,0,11900,10100,7600,10900,11100]
[3258.4789999999998,3853.2424000000001,5985.8234000000002,6771.3138000000008,14808.819,101658.90399999999,82455.76999999999,96747.85,122874.31499999999,113932.41200000001]
[0,0,0,0,0,null,null,null,null,null,"Algemeen: hydrocultuur"]
[729.54079999999999,1239.4318000000001,1424.3036,1568.4866000000002,1478.6926000000001,11900,10100,7600,10900,11100,2010,2011,2012,2013,2014]
[4944.8,6627.4292000000005,7816.0603999999994,7209.337199999999,8863.5419999999976,107100,90900,68400,98100,99900,2.2359999999999998,2.242,2.1339999999999999,2.0499999999999998,1.9280000000000002]
[22.362000000000002,93.696000000000012,230.5496,623.33459999999991,220.9,null,null,null,null,null,281459.90000000002,393972.50060000003,322868.57999999996,321690.94,356984.34399999998]
[5199.5681999999997,5070.6161999999995,5954.5942000000005,9519.1799999999985,6563.2003999999997,"Balans: hydrocultuur",null,null,null,null,0,0,0,0,0]
[5589.7364000000007,2398.9052000000011,8351.9986000000008,5684.6924000000008,5407.8229999999994,2010,2011,2012,2013,2014,0,0,0,0,0]
[716.60000000000014,112.26399999999997,0,122.31800000000003,138.27000000000001,523127.96600000001,801115.00099999993,752179.32600000012,789744.22,605289.54399999999,29200,42100,47200,41000,15100]
[84263.997000000003,56005.528399999996,74939.883600000001,69448.816000000006,70599.712,538411.10100000002,491438.58799999999,482671.23100000003,510386.19300000009,440352.54000000004]
[2337.9719999999998,1628.0460000000003,2026.0540000000005,1367.374,1242.6200000000001,0,0,0,0,0]
[9433.9180000000015,8984.7659999999996,9893.2800000000007,11501.77,12024.388000000003,70000,70000,70000,70000,70000]
[1392.52,1156.5819999999999,1190.4839999999999,1403.65,1363.2040000000002,0,0,0,0,0]
[7083.0815999999995,6350.5683999999992,12329.5592,9255.2103999999999,21725.094000000001,214613.55900000004,119240.70600000001,136730.283,154690.802,113170.48499999999]
[17306.056,21376.708000000002,14574.200000000003,22317.024000000001,28339.508000000009]
[2278.3723999999993,2128.0602000000008,1484.8898000000002,1749.6278000000009,2006.2552000000001,29200,42100,47200,41000,15100]
[null,null,null,null,null,262800,378900,424800,369000,134900]
["Resultatenrekening: hydrocultuur"]
[2010,2011,2012,2013,2014]
[352560.13400000002,463886.41200000001,411336.86799999996,313527.88,353535.61799999996]
[52121.445800000009,64897.346799999978,87883.818000000043,80762.53,45668.795999999966]
[0,0,0,0,0]
[20313.738799999999,28804.873799999994,35729.546599999994,24534.674800000001,63980.24500000001]
[10145.352600000002,9733.7465999999986,10955.615000000002,11493.9768,10433.587999999996]
[14050.571,12898.227600000002,17431.999,15982.239800000001,16721.109999999997]
[18.975999999999999,80.123999999999995,0,2086.8100000000004,0]
[1850.1894,2095.5820000000003,2158.7233999999999,2478.6576,2518.4270000000001]
[25375.295000000002,45668.774799999992,42677.324200000003,37821.111199999999,34203.934800000003]
[791.64200000000005,1804.5656000000006,2124.0766000000031,4418.9110000000001,9194.0918000000001]
[62998.126799999991,104662.4498,108629.30920000002,104804.6844,68973.411600000036]
[19277.017400000004,33123.467599999996,23400.500399999972,11801.719999999998,14867.295799999998]
[8339.6371999999974,744.31780000000015,1603.9302000000002,6465.2579999999998,23139.598999999998]
[83692.654600000009,91363.114999999991,82941.807599999986,79600.117200000008,77314.446599999996]
[3604.1399999999994,10452.526000000002,11250.735999999999,11645.592000000001,2124.7860000000001]
[23669.216000000004,32590.004000000015,31197.331999999984,32052.836000000003,22733.53]
[2909.2080000000005,1292.3440000000001,1541.5119999999999,1956.6260000000002,1348.816]
[43984.716,57511.625200000009,66251.637600000002,70837.105599999995,76639.284]
[54499.637999999992,68367.613999999972,57784.114000000016,62058.317999999992,45018.864000000009]
[5424.5426000000016,6676.6148000000012,6065.5,5292.4874,4857.2689999999984]

{"sheet":" Rekenblad 1","index":3,"n_rows":63,"n_cols":10,"rows_kept":63,"cut":false,"hidden":true,"merged":[[5,0,5,1],[34,0,34,1],[4,3,4,7]]}
["Hier staan verschillende economische en financiële indicatoren weergegeven, alsook een diagnose die zegt of de score van een indicator Goed, Matig of Zwak is. "]
["Wanneer u de cursor van uw computer boven een indicator houdt, verschijnt uitleg over wat die indicator precies betekent."]
["Wat kan gedaan worden om de waarde van deze indicator te verbeteren, kunt u vinden door op de aanwezige blauwe hyperlinks te klikken."]
["Hydrocultuur"]
[]
["Economische indicatoren",null,null,"Uw waarde","Streefwaarde 1","Streefwaarde 2 ","Diagnose"]
["Schuldgraad"]
[]
[null,"Vreemd vermogen / totaal vermogen",null,{"$f":"('Invoer gegevens'!H20+'Invoer gegevens'!H21)/('Invoer gegevens'!H11)","v":0.26888398191652912},0.6,0.3,{"$f":"IF(D9>=E9,\"Zwak\",IF(AND(E9>D9,D9>F9),\"Matig\",IF(D9<=F9,\"Goed\",\" \")))","v":"Goed"}]
[]
["Winstgevendheid"]
[]
[null,"Rendement van eigen arbeid (\"arbeidsinkomen\")",null,{"$f":"(('Invoer gegevens'!D11)-('Invoer gegevens'!D16)-('Invoer gegevens'!D28+'Invoer gegevens'!D30+'Invoer gegevens'!D31+'Invoer gegevens'!D32+'Invoer gegevens'!D33+'Invoer gegevens'!D34+'Invoer gegevens'!D35))/'Invoer gegevens'!L12","v":-5580.7798048780342},25000,50000,{"$f":"IF(D13<=E13,\"Zwak\",IF(AND(E13<D13,D13<F13),\"Matig\",IF(D13>=F13,\"Goed\",\" \")))","v":"Zwak"}]
[]
[null,"Rendement van totaal vermogen",null,{"$f":"('Invoer gegevens'!D11-'Invoer gegevens'!D16-('Invoer gegevens'!D28+'Invoer gegevens'!D29+'Invoer gegevens'!D30+'Invoer gegevens'!D34+'Invoer gegevens'!D35))/('Invoer gegevens'!H11)","v":9.0540790383743467E-3},0.03,0.06,{"$f":"IF(D15<=E15,\"Zwak\",IF(AND(E15<D15,D15<F15),\"Matig\",IF(D15>=F15,\"Goed\",\" \")))","v":"Zwak"}]
[]
[null,"Rendement van eigen vermogen",null,{"$f":"('Invoer gegevens'!D11-'Invoer gegevens'!D16-('Invoer gegevens'!D28+'Invoer gegevens'!D29+'Invoer gegevens'!D30+'Invoer gegevens'!D34+'Invoer gegevens'!D35))/('Invoer gegevens'!H22)","v":1.238391556802227E-2},0.02,0.08,{"$f":"IF(D17<=E17,\"Zwak\",IF(AND(E17<D17,D17<F17),\"Matig\",IF(D17>=F17,\"Goed\",\" \")))","v":"Zwak"}]
[]
[null,"Operationele winstmarge ratio",null,{"$f":"((D21+'Invoer gegevens'!D30)-'Invoer gegevens'!D29)/('Invoer gegevens'!D12+'Invoer gegevens'!D13)","v":-0.11510719167630774},0.1,0.25,{"$f":"IF(D19<=E19,\"Zwak\",IF(AND(E19<D19,D19<F19),\"Matig\",IF(D19>=F19,\"Goed\",\" \")))","v":"Zwak"}]
[]
[null,"Netto bedrijfsinkomen",null,{"$f":"('Invoer gegevens'!D11)-('Invoer gegevens'!D16)-('Invoer gegevens'!D34+'Invoer gegevens'!D33+'Invoer gegevens'!D30+'Invoer gegevens'!D28+'Invoer gegevens'!D35)","v":22568.863400000031},100000,300000,{"$f":"IF(D21<=E21,\"Zwak\",IF(AND(E21<D21,D21<F21),\"Matig\",IF(D21>=F21,\"Goed\",\" \")))","v":"Zwak"}]
[]
["Financieel-economische efficiëntie",null,null,null,null,null,{"$f":"IF(D23>E23,\"zwak\",IF(AND(E23>D23,D23>F23),\"matig\",IF(D21<=F23,\"goed\",\" \")))","v":" "}]
[]
[null,"Activa-omzet ratio",null,{"$f":"('Invoer gegevens'!D11)/('Invoer gegevens'!H11)","v":0.2585814035909777},0.3,0.45,{"$f":"IF(D25<=E25,\"Zwak\",IF(AND(E25<D25,D25<F25),\"Matig\",IF(D25>=F25,\"Goed\",\" \")))","v":"Zwak"},null,"Kosten",{"$f":"D27","v":0.74241001499377057}]
[null,null,null,null,null,null,null,null,"Afschrijvingen",{"$f":"D29","v":0.15739241033024359}]
[null,"Kosten-omzetratio",null,{"$f":"('Invoer gegevens'!D16+'Invoer gegevens'!D28+'Invoer gegevens'!D33)/('Invoer gegevens'!D11)","v":0.74241001499377057},0.8,0.6,{"$f":"IF(D27>=E27,\"Zwak\",IF(AND(E27>D27,D27>F27),\"Matig\",IF(D27<=F27,\"Goed\",\" \")))","v":"Matig"},null,"Intrest",{"$f":"D31","v":2.953556998761395E-2}]
[null,null,null,null,null,null,null,null,"Inkomen",{"$f":"D33","v":5.7239189256467156E-2}]
[null,"Afschrijvings-omzetratio",null,{"$f":"'Invoer gegevens'!D34/'Invoer gegevens'!D11","v":0.15739241033024359},0.1,0.05,{"$f":"IF(D29>=E29,\"Zwak\",IF(AND(E29>D29,D29>F29),\"Matig\",IF(D29<=F29,\"Goed\",\" \")))","v":"Zwak"}]
[]
[null,"Intrest-omzetratio",null,{"$f":"'Invoer gegevens'!D30/'Invoer gegevens'!D11","v":2.953556998761395E-2},0.1,0.05,{"$f":"IF(D31>=E31,\"Zwak\",IF(AND(E31>D31,D31>F31),\"Matig\",IF(D31<=F31,\"Goed\",\" \")))","v":"Goed"}]
[]
[null,"Inkomens-omzetratio",null,{"$f":"D21/('Invoer gegevens'!D11)","v":5.7239189256467156E-2},0.1,0.2,{"$f":"IF(D33<=E33,\"Zwak\",IF(AND(E33<D33,D33<F33),\"Matig\",IF(D33>=F33,\"Goed\",\" \")))","v":"Zwak"}]
[]
["Financiële indicatoren"]
["Balansliquiditeit"]
[null,"Vlottende ratio",null,{"$f":"('Invoer gegevens'!H14+'Invoer gegevens'!H15+'Invoer gegevens'!H16)/('Invoer gegevens'!H20)","v":1.7073170731707317},1,1.3,{"$f":"IF(D37<=E37,\"Zwak\",IF(AND(E37<D37,D37<F37),\"Matig\",IF(D37>=F37,\"Goed\",\" \")))","v":"Goed"}]
[]
[null,"Vlottende marge ten opzichte van omzet",null,{"$f":"(('Invoer gegevens'!H14+'Invoer gegevens'!H15+'Invoer gegevens'!H16)-('Invoer gegevens'!H20))/('Invoer gegevens'!D11)","v":7.3549848701620707E-2},0.1,0.3,{"$f":"IF(D39<=E39,\"Zwak\",IF(AND(E39<D39,D39<F39),\"Matig\",IF(D39>=F39,\"Goed\",\" \")))","v":"Zwak"}]
[]
["Terugbetalingscapaciteit"]
[]
[null,"Aflossingscapaciteit",null,{"$f":"(D21+'Invoer gegevens'!D34+'Invoer gegevens'!L14+'Invoer gegevens'!D30)-'Invoer gegevens'!L15","v":96272.773400000035},55000,80000,{"$f":"IF(D43<=E43,\"Zwak\",IF(AND(E43<D43,D43<F43),\"Matig\",IF(D43>=F43,\"Goed\",\" \")))","v":"Goed"}]
[]
[null,"Aflossingsmarge",null,{"$f":"D43-('Invoer gegevens'!L16+'Invoer gegevens'!D30)","v":43627.18140000003},35000,60000,{"$f":"IF(D45<=E45,\"Zwak\",IF(AND(E45<D45,D45<F45),\"Matig\",IF(D45>=F45,\"Goed\",\" \")))","v":"Matig"}]
[]
[]
[]
[]
[]
[null,"Kostenstructuur (OPM: kosten van mogelijk meerdere takken)"]
[null,"Categorie","Totale kost","Kost / kg witloof"]
[null,"Zaaigoed",{"$f":"'Invoer gegevens'!D17","v":24534.674800000001},{"$f":"C53/'Invoer gegevens'!L$13","v":7.6267845155974859E-2}]
[null,"Meststoffen",{"$f":"'Invoer gegevens'!D18","v":11493.9768},{"$f":"C54/'Invoer gegevens'!L$13","v":3.5729874145662914E-2}]
[null,"Gewasbescherming",{"$f":"'Invoer gegevens'!D19","v":15982.239800000001},{"$f":"C55/'Invoer gegevens'!L$13","v":4.9681970527363936E-2}]
[null,"Bewaring",{"$f":"'Invoer gegevens'!D20","v":2086.8100000000004},{"$f":"C56/'Invoer gegevens'!L$13","v":6.4870027113601656E-3}]
[null,"Verwarming",{"$f":"'Invoer gegevens'!D21","v":2478.6576},{"$f":"C57/'Invoer gegevens'!L$13","v":7.7050898604729126E-3}]
[null,"Energie en water",{"$f":"'Invoer gegevens'!D22","v":37821.111199999999},{"$f":"C58/'Invoer gegevens'!L$13","v":0.11756971209695866}]
[null,"Afzet en vermarkting",{"$f":"'Invoer gegevens'!D23","v":4418.9110000000001},{"$f":"C59/'Invoer gegevens'!L$13","v":1.3736510577512689E-2}]
[null,"Loonwerk en seizoenslonen",{"$f":"'Invoer gegevens'!D24","v":104804.6844},{"$f":"C60/'Invoer gegevens'!L$13","v":0.32579308699212978}]
[null,"Diverse",{"$f":"'Invoer gegevens'!D25","v":11801.719999999998},{"$f":"C61/'Invoer gegevens'!L$13","v":3.668651656773423E-2}]
[null,"Betaalde arbeid",{"$f":"'Invoer gegevens'!D28","v":6465.2579999999998},{"$f":"C62/'Invoer gegevens'!L$13","v":2.0097731070697854E-2}]
[null,"Betaalde pacht ",{"$f":"'Invoer gegevens'!D33","v":70837.105599999995},{"$f":"C63/'Invoer gegevens'!L$13","v":0.22020236441846947}]

{"sheet":"Rekenblad 2","index":4,"n_rows":75,"n_cols":10,"rows_kept":75,"cut":false,"hidden":true,"merged":[[2,1,2,2],[2,3,2,4],[2,5,2,6]]}
[]
[]
["Rendement van eigen arbeid","Speedometer",null,"Pointer",null,"Real values"]
[null,"Start",0,"Value",{"$f":"(G9/G8)*C8","v":-1.8602599349593449},"Min",0]
[null,"Initial",{"$f":"((G5-G4)/G8)*C8","v":8.3333333333333321},"Pointer",1,"Bad",25000]
[null,"Middle",{"$f":"((G6-G5)/G8)*C8","v":8.3333333333333321},"End",{"$f":"(C8+C7+C6+C5+C4) - (E4+E5)","v":200.86025993495937},"Good",50000]
[null,"End",{"$f":"((G7-G6)/G8)*C8","v":83.333333333333343},null,null,"Max",300000]
[null,"Total",100,null,null,"Total",{"$f":"G7-G4","v":300000}]
[null,null,null,null,null,"Value",{"$f":"' Rekenblad 1'!D13","v":-5580.7798048780342}]
["Rendement van eigen vermogen","Start",0,"Value",{"$f":"((G15-G10)/G14)*C14","v":17.823975876577794},"Min",-5]
[null,"Initial",{"$f":"((G11-G10)/G14)*C14","v":22.857142857142858},"Pointer",1,"Bad",3]
[null,"Middle",{"$f":"((G12-G11)/G14)*C14","v":5.7142857142857144},"End",{"$f":"(C14+C13+C12+C11+C10) - (E10+E11)","v":181.17602412342222},"Good",5]
[null,"End",{"$f":"((G13-G12)/G14)*C14","v":71.428571428571431},null,null,"Max",30]
[null,"Total",100,null,null,"Total",{"$f":"G13-G10","v":35}]
[null,null,null,null,null,"Value",{"$f":"' Rekenblad 1'!D17*100","v":1.238391556802227}]
["Rendement van totaal vermogen","Start",0,"Value",{"$f":"((G21-G16)/G19)*C20","v":23.621631615349738},"Min",-5]
[null,"Initial",{"$f":"((G17-G16)/G20)*C20","v":26.666666666666668},"Pointer",1,"Bad",3]
[null,"Middle",{"$f":"((G18-G17)/G20)*100","v":6.666666666666667},"End",{"$f":"(C20+C19+C18+C17+C16) -(E16+E17)","v":175.37836838465023},"Good",5,null,null,{"$f":"C17+C18+C19","v":100}]
[null,"End",{"$f":"((G19-G18)/G20)*C20","v":66.666666666666657},null,null,"Max",25]
[null,"Total",100,null,null,"Total",{"$f":"G19-G16","v":30}]
[null,null,null,null,null,"Value",{"$f":"' Rekenblad 1'!D15*100","v":0.90540790383743464}]
["Netto bedrijfsinkomen","Start",0,"Value",{"$f":"(G27/G26)*C26","v":6.4482466857142944},"Min",0]
[null,"Initial",{"$f":"((G23-G22)/G26)*100","v":7.1428571428571423},"Pointer",1,"Bad",25000]
[null,"Middle",{"$f":"((G24-G23)/G26)*C26","v":21.428571428571427},"End",{"$f":"(C22+C23+C24+C25+C26)-(E22+E23)","v":192.55175331428572},"Good",100000]
[null,"End",{"$f":"((G25-G24)/G26)*C26","v":71.428571428571431},null,null,"Max",350000]
[null,"Total",100,null,null,"Total",{"$f":"G25-G22","v":350000}]
[null,null,null,null,null,"Value",{"$f":"' Rekenblad 1'!D21","v":22568.863400000031}]
["Vlottende marge","Start",0,"Value",{"$f":"((G33-G28)/G32)*C32","v":33.335609756097561},"Min",-25000]
[null,"Initial",{"$f":"((G29-G28)/G32)*C32","v":33.333333333333329},"Pointer",1,"Bad",0]
[null,"Middle",{"$f":"((G30-G29)/G32)*C32","v":33.333333333333329},"End",{"$f":"(C32*2)-(E28+E29)","v":165.66439024390243},"Good",25000]
[null,"End",{"$f":"((G31-G30)/G32)*C32","v":33.333333333333329},null,null,"Max",50000]
[null,"Total",100,null,null,"Total",{"$f":"G31-G28","v":75000}]
[null,null,null,null,null,"Value",{"$f":"' Rekenblad 1'!D37","v":1.7073170731707317}]
["Vlottende marge-omzet ratio","Start",0,"Value",{"$f":"((G39-G34)/G38)*C38","v":28.924974783603453},"Min",-10]
[null,"Initial",{"$f":"((G35-G34)/G38)*C38","v":33.333333333333329},"Pointer",1,"Bad",10]
[null,"Middle",{"$f":"((G36-G35)/G38)*C38","v":33.333333333333329},"End",{"$f":"(2*C38)-(E34+E35)","v":170.07502521639654},"Good",30]
[null,"End",{"$f":"((G37-G36)/G38)*C38","v":33.333333333333329},null,null,"Max",50]
[null,"Total",100,null,null,"Total",{"$f":"G37-G34","v":60}]
[null,null,null,null,null,"Value",{"$f":"' Rekenblad 1'!D39*100","v":7.3549848701620704}]
["Aflossingscapaciteit","Start",0,"Value",{"$f":"((G45-G40)/G44)*C44","v":21.393949644444451},"Min",0]
[null,"Initial",{"$f":"((G41-G40)/G44)*C44","v":11.111111111111111},"Pointer",1,"Bad",50000]
[null,"Middle",{"$f":"((G42-G41)/G44)*C44","v":11.111111111111111},"End",{"$f":"(2*C44)-(E40+E41)","v":177.60605035555554},"Good",100000]
[null,"End",{"$f":"((G43-G42)/G44)*C44","v":77.777777777777786},null,null,"Max",450000]
[null,"Total",100,null,null,"Total",{"$f":"G43-G40","v":450000}]
[null,null,null,null,null,"Value",{"$f":"' Rekenblad 1'!D43","v":96272.773400000035}]
["Aflossingsmarge","Start",0,"Value",{"$f":"((G51-G46)/G50)*C50","v":10.906795350000008},"Min",0]
[null,"Initial",{"$f":"((G47-G46)/G50)*C50","v":6.25},"Pointer",1,"Bad",25000]
[null,"Middle",{"$f":"((G48-G47)/G50)*C50","v":12.5},"End",{"$f":"200-(E46+E47)","v":188.09320464999999},"Good",75000]
[null,"End",{"$f":"((G49-G48)/G50)*C50","v":81.25},null,null,"Max",400000]
[null,"Total",100,null,null,"Total",{"$f":"G49-G46","v":400000}]
[null,null,null,null,null,"Value",{"$f":"' Rekenblad 1'!D45","v":43627.18140000003}]
["Schuldgraad","Start",0,"Value",{"$f":"((G57-G52)/G56)*C56","v":26.888398191652911},"Min",0]
[null,"Initial",{"$f":"((G53-G52)/G56)*C56","v":30},"Pointer",1,"Bad",30]
[null,"Middle",{"$f":"((G54-G53)/G56)*C56","v":30},"End",{"$f":"200-(E52+E53)","v":172.11160180834707},"Good",60]
[null,"End",{"$f":"((G55-G54)/G56)*C56","v":40},null,null,"Max",100]
[null,"Total",100,null,null,"Total",{"$f":"G55-G52","v":100}]
[null,null,null,null,null,"Value",{"$f":"' Rekenblad 1'!D9*100","v":26.888398191652911}]
["Operationele winst marge ratio","Start",0,"Value",{"$f":"((G63-G58)/G62)*C62","v":-16.443884525186821},"Min",0]
[null,"Initial",{"$f":"((G59-G58)/G62)*C62","v":14.285714285714285},"Pointer",1,"Bad",10]
[null,"Middle",{"$f":"((G60-G59)/G62)*C62","v":21.428571428571427},"End",{"$f":"200-(E58+E59)","v":215.44388452518683},"Good",25]
[null,"End",{"$f":"((G61-G60)/G62)*C62","v":64.285714285714292},null,null,"Max",70]
[null,"Total",100,null,null,"Total",{"$f":"G61-G58","v":70}]
[null,null,null,null,null,"Value",{"$f":"' Rekenblad 1'!D19*100","v":-11.510719167630775}]
["Activa turnover","Start",0,"Value",{"$f":"((G69-G64)/G68)*C68","v":34.477520478797032},"Min",0]
[null,"Initial",{"$f":"((G65-G64)/G68)*C68","v":40},"Pointer",1,"Bad",30]
[null,"Middle",{"$f":"((G66-G65)/G68)*C68","v":20},"End",{"$f":"200-(E65+E64)","v":164.52247952120297},"Good",45]
[null,"End",{"$f":"((G67-G66)/G68)*C68","v":40},null,null,"Max",75]
[null,"Total",100,null,null,"Total",{"$f":"G67-G64","v":75}]
[null,null,null,null,null,"Value",{"$f":"' Rekenblad 1'!D25*100","v":25.858140359097771}]
["Kosten omzet ratio","Start",0,"Value",{"$f":"((G75-G70)/G74)*C74","v":78.148422630923221},"Min",0]
[null,"Initial",{"$f":"((G71-G70)/G74)*C74","v":63.157894736842103},"Pointer",1,"Bad",60]
[null,"Middle",{"$f":"((G72-G71)/G74)*C74","v":21.052631578947366},"End",{"$f":"200-(E70+E71)","v":120.85157736907678},"Good",80]
[null,"End",{"$f":"((G73-G72)/G74)*C74","v":15.789473684210526},null,null,"Max",95]
[null,"Total",100,null,null,"Total",{"$f":"G73-G70","v":95}]
[null,null,null,null,null,"Value",{"$f":"' Rekenblad 1'!D27*100","v":74.241001499377063}]

{"sheet":"Resultaat","index":5,"n_rows":65,"n_cols":22,"rows_kept":65,"cut":false,"hidden":false,"merged":[[43,0,43,5],[43,7,43,12],[43,14,43,19],[43,21,43,26],[2,7,2,12],[2,0,2,5],[2,14,2,19],[2,21,2,26],[22,0,22,5],[22,7,22,12],[22,14,22,19],[22,21,22,26]]}
["Basisindicatoren"]
["Economische gezondheid"]
["Rendement van eigen arbeid",null,null,null,null,null,null,"Rendement van eigen vermogen",null,null,null,null,null,null,"Rendement van totaal vermogen",null,null,null,null,null,null,"Netto bedrijfsinkomen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Financiële gezondheid"]
["Vlottende ratio",null,null,null,null,null,null,"Vlottende marge-omzet ratio",null,null,null,null,null,null,"Aflossingscapaciteit",null,null,null,null,null,null,"Aflossingsmarge"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Hulpindicatoren en verdere analyse"]
["Schuldgraad",null,null,null,null,null,null,"Operationele winstmarge ratio",null,null,null,null,null,null,"Activa-omzet ratio",null,null,null,null,null,null,"Kosten-omzet ratio"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Waar gaat mijn omzet heen?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waar spendeer ik mijn kosten aan?"]