{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Uw dossier","_grafieken","_datasheet","_sector_data","_sector_formules"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":109,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Uw dossier","index":0,"n_rows":635,"n_cols":26,"rows_kept":635,"cut":false,"hidden":false,"merged":[[580,10,581,16],[532,2,532,5],[533,2,533,5],[524,2,524,5],[525,2,525,5],[526,2,526,5],[527,2,527,5],[528,2,528,5],[516,2,516,4],[516,5,516,6],[516,7,516,8],[516,9,516,10],[530,6,530,8],[529,10,529,12],[530,10,530,12],[527,6,527,8],[528,6,528,8],[531,6,531,8],[529,2,529,5],[530,2,530,5],[531,2,531,5],[528,10,528,12],[575,2,582,8],[557,10,557,16],[200,5,200,6],[206,5,206,6],[514,2,514,4],[514,5,514,6],[514,7,514,8],[514,9,514,10],[513,2,513,4],[513,5,513,6],[513,7,513,8],[513,9,513,10],[511,2,511,4],[511,5,511,6],[511,7,511,8],[511,9,511,10],[512,2,512,4],[512,5,512,6],[512,7,512,8],[512,9,512,10],[510,2,510,4],[510,5,510,6],[510,7,510,8],[232,8,232,9],[510,9,510,10],[503,2,503,4],[502,7,502,8],[502,9,502,10],[493,9,493,10],[494,9,494,10],[499,2,499,20],[506,2,506,20],[508,2,508,20],[493,5,493,6],[494,5,494,6],[503,5,503,6],[503,7,503,8],[503,9,503,10],[501,2,501,4],[501,5,501,6],[501,7,501,8],[501,9,501,10],[502,2,502,4],[502,5,502,6],[489,2,489,4],[490,2,490,4],[491,2,491,4],[492,2,492,4],[493,2,493,4],[491,7,491,8],[492,7,492,8],[493,7,493,8],[494,7,494,8],[172,1,172,4],[190,1,190,4],[523,6,523,8],[525,6,525,8],[526,6,526,8],[524,6,524,8],[529,6,529,8],[484,2,484,20],[486,2,486,20],[202,5,202,6],[204,5,204,6],[200,8,200,9],[206,8,206,9],[202,8,202,9],[204,8,204,9],[200,11,200,12],[206,11,206,12],[202,11,202,12],[489,9,489,10],[490,9,490,10],[491,9,491,10],[492,9,492,10],[210,5,210,6],[210,8,210,9],[142,11,144,20],[149,11,157,20],[4,2,4,20],[10,2,10,20],[6,2,6,20],[5,2,5,20],[46,11,49,20],[78,11,81,20],[86,1,86,4],[62,1,62,4],[27,1,27,4],[8,1,8,4],[122,1,122,4],[102,11,105,20],[131,11,134,20],[145,11,145,12],[145,13,145,15],[146,11,146,12],[146,13,146,15],[34,11,37,20],[67,11,70,20],[91,11,94,20],[575,10,577,16],[178,4,178,5],[515,5,515,6],[515,7,515,8],[515,9,515,10],[531,10,531,12],[532,6,532,8],[533,6,533,8],[532,10,532,12],[533,10,533,12],[551,10,551,16],[551,2,551,8],[554,2,554,8],[548,2,548,8],[548,10,548,16],[521,2,521,20],[543,2,543,20],[545,2,545,20],[554,10,554,16],[430,2,430,20],[519,2,519,20],[208,11,208,12],[210,11,210,12],[216,1,216,4],[160,11,168,20],[251,2,251,20],[239,2,239,20],[237,2,237,20],[241,2,241,21],[497,2,497,20],[488,7,488,8],[488,9,488,10],[489,5,489,6],[490,5,490,6],[489,7,489,8],[490,7,490,8],[494,2,494,4],[487,2,487,4],[488,2,488,4],[488,5,488,6],[491,5,491,6],[492,5,492,6],[208,5,208,6],[204,11,204,12],[198,8,198,9],[198,11,198,12],[198,5,198,6],[208,8,208,9],[432,2,432,20],[458,2,458,20],[456,2,456,20],[222,5,222,6],[221,5,221,6],[222,8,222,9],[221,8,221,9],[224,5,224,6],[224,8,224,9],[226,5,226,6],[226,8,226,9],[228,5,228,6],[228,8,228,9],[230,5,230,6],[230,8,230,9],[232,5,232,6]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uw financieel plan"]
[null,null,"Voorspelling financiële resultaten van uw online activiteiten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"versie 2.0 - gepubliceerd op 01/04/2018"]
[]
[null,null,"Via dit excel-document kunt u de financiële haalbaarheid van uw plan om uw zaak ook online uit te bouwen, laten berekenen en visualiseren. Dit excel-document is slechts één van de beschikbare tools. U vindt ze allemaal terug op de website www.hetinternetookuwzaak.be. "]
[]
[null,null,"Alhoewel het excel-document en daar in opgenomen fomules en standaard waarden met de grootste zorg zijn samengesteld is het evident dat het resultaat slechts een inschatting is. Het is belangrijk dat u de resultaten dan ook met die wetenschap behandelt."]
[]
[null,"Uw bedrijf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ALGEMEEN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sector",16]
[null,null,"Probeer een zo accuraat mogelijk antwoord te geven op alle onderstaande vragen.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Turnover",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# Klanten",5]
[null,null,"In welke sector bent u actief?"]
[]
[]
[null,null,"Wat is uw huidige omzet?"]
[]
[]
[null,null,"Wat is uw marge?"]
[null,null,50,"%"]
[]
[null,null,"Hoeveel klanten heeft u momenteel?"]
[]
[]
[]
[]
[]
[null,"Social Media",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SOCIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Include",1]
[null,null,"Wilt u het gebruik van Sociale Media mee opnemen in uw business case?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Include FB",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Include LI",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Include TW",1]
[null,null,"Overzicht van de sociale media kanalen:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Include Insta",1]
[null,null,null,"Kanaal",null,"Huidige status",null,null,"Geplande status",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Include Pint",1]
[null,null,null,null,null,null,null,null,null,null,null,"Opmerking:\nIndien u kiest voor 'Niet actief' wordt er een opstartkost in rekening gebracht. \nIndien u kiest voor 'Niet actief' of 'Aanwezig maar geen actief gebruik' wordt er ook een leercurve in rekening gebracht.",null,null,null,null,null,null,null,null,null,null,null,null,"StatusFacebook",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StatusLinkedIn",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StatusTwitter",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StatusInstagram",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StatusPinterest",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FutureFacebook",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FutureLinkedIn",3]
[null,null,"In welke talen zal u communiceren op sociale media?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FutureTwitter",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FutureInstagram",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FuturePinterest",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Talen",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ChannelCount",{"$f":"IncludeFacebook+IncludeLinkedIn+IncludeTwitter+IncludeInstagram+IncludePinterest","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,"Opmerking:\nVoert u zelf deze taken uit? Waardeer dan uw eigen tijd in €/uur. Doet u beroep op externe uitvoerders, dan kunt u het mee te rekenen netto uurtarief hier invullen, bijvoorbeeld 50€/uur."]
[]
[null,null,"Aan welk uurtarief moet de te investeren tijd in Sociale Media opgenomen worden?"]
[null,null,null,50," €/uur"]
[]
[]
[]
[null,"Uw financieel plan"]
[null,"Meer tips en inspiratie op www.hetinternetookuwzaak.be"]
[null,"Pagina 1 van 11"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uw financieel plan"]
[]
[]
[]
[null,"Email marketing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EMAIL MKT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Include",1]
[null,null,"Wilt u het gebruik van email marketing mee opnemen in uw business case?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Activiteit",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frequentie",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Talen",2]
[null,null,"In hoeverre bent u al actief met email marketing?",null,null,null,null,null,null,null,null,"Opmerking:\nIndien u kiest voor 'Niet actief' wordt er een opstartkost in rekening gebracht. \nIndien u kiest voor 'Niet actief' of 'Af en toe van eigen email adres' wordt er ook een leercurve in rekening gebracht."]
[]
[]
[null,null,"Met welke frequentie gaat u emails sturen?"]
[]
[]
[null,null,"In welke talen zal u emails verzenden?"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Opmerking:\nVoert u zelf deze taken uit? Waardeer dan uw eigen tijd in €/uur. Doet u beroep op externe uitvoerders, dan kunt u het mee te rekenen netto uurtarief hier invullen, bijvoorbeeld 50€/uur."]
[]
[null,null,"Aan welk uurtarief moet de te investeren tijd in email marketing opgenomen worden?"]
[null,null,50," €/uur"]
[]
[]
[]
[]
[null,"Content Marketing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLOG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Include",1]
[null,null,"Wilt u het gebruik van een blog mee opnemen in uw business case?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Activiteit",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frequentie",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Talen",2]
[null,null,"In hoeverre bent u al actief met een blog?",null,null,null,null,null,null,null,null,"Opmerking:\nIndien u kiest voor 'Niet actief' wordt er een opstartkost in rekening gebracht. \nIndien u kiest voor 'Niet actief' of 'Er is een blog maar die wordt weinig actief gebruikt' wordt er ook een leercurve in rekening gebracht."]
[]
[]
[null,null,"Met welke frequentie gaat u bloggen?"]
[]
[]
[null,null,"In welke talen zal u bloggen?"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Opmerking:\nVoert u zelf deze taken uit? Waardeer dan uw eigen tijd in €/uur. Doet u beroep op externe uitvoerders, dan kunt u het mee te rekenen netto uurtarief hier invullen, bijvoorbeeld 50€/uur."]
[]
[null,null,"Aan welk uurtarief moet de te investeren tijd in een blog opgenomen worden?"]
[null,null,50," €/uur"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Uw financieel plan"]
[null,"Meer tips en inspiratie op www.hetinternetookuwzaak.be"]
[null,"Pagina 2 van 11"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uw financieel plan"]
[]
[]
[null,"Site of e-shop",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SITE/SHOP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Include",1]
[null,null,"Wilt u een website of e-shop opnemen in uw business case?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Site/shop",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buy/Rent",1]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Opmerking:\nHet koop-model: \nU laat uw site of e-shop volledig op maat maken en betaalt eenmalig een ontwikkelkost en een jaarlijkse onderhouds- en hostingkost."]
[]
[]
[]
[null,null,null,"Hoeveel bedragen de éénmalige kosten?",null,null,null,null,null,null,null,null,"site op maat:","tss. €2.500 en €10.000"]
[null,null,null,null,"ontwikkeling",20000,"€",null,null,null,null,null,"basis e-shop:","tss. €5.000 en €25.000"]
[null,null,null,null,null,null,null,null,null,null,null,null,"geïntegreerde e-shop:","tss. €20.000 en €40.000"]
[null,null,null,"Hoeveel bedragen de terugkerende kosten?"]
[null,null,null,null,"onderhoud",2000,"€",null,null,null,null,null,"Reken voor onderhoud en voor hosting telkens ongeveer  +/- 10%"]
[]
[null,null,null,null,"hosting",2000,"€"]
[null,null,null,null,null,null,null,null,null,null,null,"Het huur-model: \nU betaalt een maandelijkse abonnementskost waarin alles inbegrepen is. Vaak dient u wel nog een percentage van uw omzet bij te dragen."]
[]
[]
[null,null,null,"Hoeveel bedraagt de jaarlijkse huurprijs?",null,null,null,null,null,null,null,"site op maat",null,"tss. €50 en €250 per maand"]
[null,null,null,null,"Abonnement",null,"€",null,null,null,null,"basis e-shop",null,"tss. €100 en €1.000 per maand"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Opmerking:\nHet onderhouden van uw online productdatabase kan zeer arbeidsintensief zijn.  Indien u de activiteiten zelf zal uitvoeren kunt u uw eigen tijd waarderen. Indien u een beroep doet op een consultant kunt u rekening houden met een gemiddeld uurtarief van €50.\n\nIndien u dit geautomatiseerd heeft kunt u het uurtarief op 0 €/uur zetten."]
[null,null,null,null,"Aantal producten",100," (op jaarbasis)"]
[]
[null,null,null,null,"Aantal wijzigingen in gamma",25," (op jaarbasis)"]
[]
[null,null,null,null,"Online brengen 1 product",30," (hoeveel tijd in minuten spendeert u daar aan?)"]
[]
[null,null,null,null,"Uurtarief",50," €/uur"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Opmerking:\nGeef de gemiddelde verzend- en retourkost in zoals die aangerekend worden aan de klant. De berekening houdt rekening met een effectieve vervoerskost waar het klantgedeelte van wordt afgetrokken.\n\nU kunt nog een percentage invullen van het aantal leveringen dat u gratis bezorgt (vb. grote bestellingen) of gratis laat afhalen (vb. afhalen in winkel). Percentage wordt standaard op 10% gezet."]
[]
[null,null,null,null,"Kostprijs verzenden",0,"€"]
[]
[null,null,null,null,"Kostprijs retour",3,"€"]
[]
[null,null,null,"Percentage gratis verzending of afhaling"]
[null,null,null,null,"Percentage",10,"%"]
[]
[]
[]
[]
[null,"Online adverteren"]
[]
[null,null,"Uw advertenties op Google en andere online kanalen zoals bijvoorbeeld sociale media, brengen bezoekers naar je website en winkel. Geef hieronder het bedrag in dat u jaarlijks voorziet voor online advertenties."]
[]
[null,null,null,"Zoekmachine advertenties",null,null,null,"Sociale media advertenties"]
[]
[null,null,null,"Jaarbudget",2000,null,"€","Jaarbudget",500,"€"]
[]
[]
[]
[null,"Uw financieel plan"]
[null,"Meer tips en inspiratie op www.hetinternetookuwzaak.be"]
[null,"Pagina 3 van 11"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uw financieel plan"]
[]
[]
[null,"Marktplaatsen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MARKETPLACES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Include",0]
[null,null,"Wilt u uw producten verkopen op marktplaatsen?"]
[]
[]
[]
[null,null,"Geef de marktplaatsen, de verwachte jaaromzet, de abonnementskost en het commissiepercentage in. "]
[]
[null,null,null,null,null,"Marktplaats 1",null,null,"Marktplaats 2",null,null,"Marktplaats 3"]
[]
[null,null,null,null,"Marktplaats"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"€"]
[null,null,null,null,"Vaste kosten",null,null,"€",null,null,"€",null,null,"€","Vaste kosten = onderhoudskost en de verzend- en retourkost"]
[]
[null,null,null,null,"Commissie marktplaats",null,null,"%",null,null,"%",null,null,"%","Vul de af te stane commissie in % in"]
[]
[null,null,null,null,"Verwachte omzet jaar 1",null,null,"€",null,null,"€",null,null,"€","Vul de te verwachten jaaromzet in"]
[]
[null,null,null,null,"Verwachte omzet jaar 2",null,null,"€",null,null,"€",null,null,"€","Vul de te verwachten jaaromzet in"]
[]
[null,null,null,null,"Verwachte omzet jaar 3",null,null,"€",null,null,"€",null,null,"€","Vul de te verwachten jaaromzet in"]
[]
[]
[]
[]
[]
[null,"Personaliseren"]
[]
[null,null,"Indien u zelf over correcte waarden beschikt van de berekende parameters kunt u deze hier optioneel ingeven. De berekeningen gebeuren dan met uw parameters i.p.v. de standaard waarden."]
[null,null,"U kunt desgewenst ook zelf experimenteren met de gevoeligheid van deze parameters en het effect hiervan op uw financieel plan."]
[]
[null,null,null,null,null,"Onze waarde",null,null,"Uw waarde"]
[null,null,null,null,"Online conversie",{"$f":"VLOOKUP(VALUE(InputSector),SECTORDATA,3,0)*100","v":3},null,"%",null,null,"%"]
[]
[null,null,null,null,"Retour percentage",10,null,"%",null,null,"%"]
[]
[null,null,null,null,"Gemiddelde bestelwaarde",{"$f":"VLOOKUP(VALUE(InputSector),SECTORDATA,6,0)","v":50},null,"€",null,null,"€"]
[]
[null,null,null,null,"Online transactiekost",{"$f":"VLOOKUP(VALUE(InputSector),SECTORDATA,12,0)*100","v":1.5},null,"%",null,null,"%"]
[]
[null,null,null,null,"Behandel kost (incl verpakking)",{"$f":"VLOOKUP(VALUE(InputSector),SECTORDATA,15,0)+VLOOKUP(VALUE(InputSector),SECTORDATA,16,0)","v":5},null,"€",null,null,"€"]
[]
[null,null,null,null,"Kostprijs verzending",{"$f":"VLOOKUP(VALUE(InputSector),SECTORDATA,19,0)","v":3.87},null,"€",null,null,"€"]
[]
[]
[]
[]
[null,null,"Klaar voor uw resultaten"]
[]
[null,null,"Hieronder vindt u uw financieel plan, dat de volgende elementen bevat:\n - Overzicht van alle kosten en baten Jaar 1 (pag. 5)\n - Overzicht van alle kosten en baten Jaar 2 (pag. 6)\n - Overzicht van alle kosten en baten Jaar 3 (pag. 7)\n - Zicht op evolutie van omzet, cashflow en klantenbestand (pag. 8)\n - Breakeven analyse voor uw e-shop (pag. 9)"]
[]
[null,null,"Op pagina 10 en 11 vindt u nog wat uitleg bij de gebruikte cijfers, formules en statistieken, alsook een bronvermelding.\n\nMet de \"print\" knop hiernaast kunt u het volledige excel-document, inclusief uw antwoorden en resultaten, afdrukken."]
[]
[]
[]
[null,"Uw financieel plan"]
[null,"Meer tips en inspiratie op www.hetinternetookuwzaak.be"]
[null,"Pagina 4 van 11"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uw financieel plan"]
[null,null,"Uw resultaat"]
[]
[null,null,"Jaar 1"]
[null,null,null,null,null,"m1","m2","m3","m4","m5","m6","m7","m8","m9","m10","m11","m12"]
[null,null,"Social Media"]
[null,null,null,null,"Configuratie en onderhoud",{"$f":"IF(InputIncludeSocial=1,VLOOKUP(InputSector,SECTORDATA,32,0),\"\")","v":1358.6227200000001}]
[null,null,null,null,"Plaatsen van berichten, foto's, …",{"$f":"IF(InputIncludeSocial=1,VLOOKUP(InputSector,SECTORDATA,36,0)*(52/12),\"\")","v":1381.8175800000006},{"$f":"F258","v":1381.8175800000006},1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,{"$f":"O258","v":1381.8175800000006},1381.8175800000006]
[null,null,null,null,"Netto resultaat Social Media",{"$f":"SUM(F257:F258)","v":2740.4403000000007},{"$f":"SUM(G257:G258)","v":1381.8175800000006},1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006]
[null,null,"Email Marketing"]
[null,null,null,null,"Configuratie en onderhoud",{"$f":"IF(InputIncludeEmail=1,VLOOKUP(InputSector,SECTORDATA,44,0),\"\")","v":520}]
[null,null,null,null,"Schrijven en versturen van emails",{"$f":"IF(InputIncludeEmail=1,VLOOKUP(InputSector,SECTORDATA,48,0)*(52/12),\"\")","v":417.08333333333331},{"$f":"F262","v":417.08333333333331},417.08333333333331,417.08333333333331,417.08333333333331,417.08333333333331,417.08333333333331,417.08333333333331,417.08333333333331,417.08333333333331,{"$f":"O262","v":417.08333333333331},417.08333333333331]
[null,null,null,null,"Abonnementskost",{"$f":"IF(InputIncludeEmail=1,(F280*FormuleEmailMultiplier*1.2%),\"\")","v":194.99999999999997},{"$f":"IF(InputIncludeEmail=1,(G280*FormuleEmailMultiplier*1.2%),\"\")","v":197.97062765729166},200.98320912322876,204.03833690628511,207.13661188285906,210.278643415452,213.46504947251714,216.69645674999995,219.97350079459559,223.29682612874706,226.66708637740831,230.08494439659808]
[null,null,null,null,"Netto resultaat Email Marketing",{"$f":"SUM(F261:F263)","v":1132.0833333333333},{"$f":"SUM(G261:G263)","v":615.053960990625},618.06654245656205,621.12167023961842,624.2199452161924,627.36197674878531,630.54838280585045,633.7797900833333,637.05683412792894,640.38015946208043,643.75041971074165,647.16827772993133]
[null,null,"Content Marketing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,"Configuratie en onderhoud",{"$f":"IF(InputIncludeBlog=1,VLOOKUP(InputSector,SECTORDATA,56,0),\"\")","v":2600},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.43]
[null,null,null,null,"Schrijven voor en promoten van blog",{"$f":"IF(InputIncludeBlog=1,VLOOKUP(InputSector,SECTORDATA,60,0)*(52/12),\"\")","v":154},{"$f":"F267","v":154},154,154,154,154,154,154,154,154,{"$f":"O267","v":154},154,null,null,null,null,{"$f":"V265*V266","v":134.88}]
[null,null,null,null,"Netto resultaat Content Marketing",{"$f":"SUM(F266:F267)","v":2754},{"$f":"SUM(G266:G267)","v":154},154,154,154,154,154,154,154,154,154,154,null,null,null,null,{"$f":"V267/12","v":11.24}]
[null,null,"Online advertenties"]
[null,null,null,null,"Zoekmachine advertenties",{"$f":"VALUE(InputMarketing)/12","v":166.66666666666666},{"$f":"F270","v":166.66666666666666},166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,{"$f":"O270","v":166.66666666666666},166.66666666666666]
[null,null,null,null,"Sociale media advertenties",{"$f":"VALUE(InputMarketingSocial)/12","v":41.666666666666664},{"$f":"F271","v":41.666666666666664},{"$f":"G271","v":41.666666666666664},{"$f":"H271","v":41.666666666666664},{"$f":"I271","v":41.666666666666664},{"$f":"J271","v":41.666666666666664},{"$f":"K271","v":41.666666666666664},{"$f":"L271","v":41.666666666666664},{"$f":"M271","v":41.666666666666664},{"$f":"N271","v":41.666666666666664},{"$f":"O271","v":41.666666666666664},{"$f":"P271","v":41.666666666666664}]
[null,null,null,null,"Netto resultaat Advertenties",{"$f":"SUM(F270:F271)","v":208.33333333333331},{"$f":"SUM(G270:G271)","v":208.33333333333331},208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,null,null,null,null,{"$f":"V271/12","v":0}]
[null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,IF(InputSiteShop=1,\"Ontwikkeling van uw site\",\"Ontwikkeling van uw e-shop\"),\"Ontwikkeling\")","v":"Ontwikkeling van uw e-shop"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Ontwikkeling\",\"\")","v":"Ontwikkeling"},{"$f":"IF(VALUE(InputIncludeSiteShop)=1,IF(VALUE(InputBuyRent)=1,VALUE(InputDevCost),\"\"),\"\")","v":20000}]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Onderhoud\",\"\")","v":"Onderhoud"},{"$f":"IF(VALUE(InputIncludeSiteShop)=1,IF(VALUE(InputBuyRent)=1,VALUE(InputSlaCost)/12,\"\"),\"\")","v":166.66666666666666},{"$f":"F275","v":166.66666666666666},166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Hosting\",\"\")","v":"Hosting"},{"$f":"IF(VALUE(InputIncludeSiteShop)=1,IF(VALUE(InputBuyRent)=1,VALUE(InputHostCost)/12,\"\"),\"\")","v":166.66666666666666},{"$f":"F276","v":166.66666666666666},166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Abonnement\",\"\")","v":"Abonnement"},{"$f":"IF(VALUE(InputIncludeSiteShop)=1,IF(VALUE(InputBuyRent)=2,VALUE(InputRentCost),\"\"),\"\")","v":""},{"$f":"F277","v":""},"","","","","","","","",{"$f":"O277","v":""},""]
[null,null,null,null,"Netto resultaat ontwikkeling",{"$f":"SUM(F274:F277)","v":20333.333333333336},{"$f":"SUM(G274:G277)","v":333.33333333333331},333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331]
[null,null,"Simulatie klantenevolutie"]
[null,null,null,null,"Actieve klanten",{"$f":"VLOOKUP(InputKlanten,DATAKLANTENTABEL,2,0)","v":7500},{"$f":"F280+((F281+F282+F283)*VLOOKUP(InputSector,SECTORDATA,5,0))","v":7614.2549098958334},7730.1234278164902,7847.6283425494285,7966.7927647253482,8087.6401313635388,8210.1942104814279,8334.4791057692291,8460.5192613306008,8588.3394664902717,8717.96486066955,8849.4209383306952]
[null,null,null,null,"Bezoekers n.a.v. marketing activiteiten",{"$f":"(F280*VALUE(FormuleMarketingImpact))-F280","v":3530.7192187500041},3584.5061529107734,3639.0527133201776,3694.3696280862014,3750.4677768285683,3807.3581928185404,3865.052065148906,3923.5607409346358,3982.8957275446046,4043.0686948648472,4104.0914775937563,4165.9760775697159]
[null,null,null,null,"Bezoekers n.a.v. sector evolutie",{"$f":"(F280*VALUE(FormuleVisitorsY1))-F280","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Bezoekers n.a.v. online advertenties",{"$f":"F272/VLOOKUP(InputSector,SECTORDATA,22,0)","v":277.77777777777777},277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777]
[null,null,{"$f":"IF(InputSiteShop=2,\"Simulatie van uw e-shop\",\"\")","v":"Simulatie van uw e-shop"}]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Aantal verkopen\",\"\")","v":"Aantal verkopen"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,CEILING((F281+F282+F283)*VLOOKUP(InputSector,SECTORDATA,5,0)+((F280*VLOOKUP(InputSector,SECTORDATA,25,0)/12)),1),\"\"),\"\")","v":1365},1385,1406,1428,1449,1471,1493,1516,1538,1562,1585,1609]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Aantal retouren\",\"\")","v":"Aantal retouren"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,FLOOR((F285)*VLOOKUP(InputSector,SECTORDATA,11,0),1),\"\"),\"\")","v":136},138,140,142,144,147,149,151,153,156,158,160]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Omzet\",\"\")","v":"Omzet"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,CEILING((F285-F286)*VLOOKUP(InputSector,SECTORDATA,8,0),1),\"\"),\"\")","v":61450},62350,63300,64300,65250,66200,67200,68250,69250,70300,71350,72450]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Marge\",\"\")","v":"Marge"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,CEILING(F287*InputMarge/100,2),\"\"),\"\")","v":30726},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,CEILING(G287*InputMarge/100,2),\"\"),\"\")","v":31176},31650,32150,32626,33100,33600,34126,34626,35150,35676,36226]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Kostprijs online betaling\",\"\")","v":"Kostprijs online betaling"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,CEILING((F285+2*F286)*VLOOKUP(InputSector,SECTORDATA,8,0)*VLOOKUP(InputSector,SECTORDATA,14,0),1),\"\"),\"\")","v":1228},1246,1265,1284,1303,1324,1344,1364,1383,1406,1426,1447]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Kostprijs productbeheer\",\"\")","v":"Kostprijs productbeheer"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,ROUND((VALUE(InputProducts)*(VALUE(InputUpdateTime)/60)*VALUE(InputProductRate))+((VALUE(InputProductChange)/12)*(VALUE(InputUpdateTime)/60)*VALUE(InputProductRate)),2),\"\"),\"\")","v":2552.08},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,ROUND((VALUE(InputProductChange)/12)*(VALUE(InputUpdateTime)/60)*VALUE(InputProductRate),2),\"\"),\"\")","v":52.08},{"$f":"G290","v":52.08},52.08,52.08,52.08,52.08,52.08,52.08,52.08,52.08,52.08]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Kostprijs logistiek\",\"\")","v":"Kostprijs logistiek"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,CEILING((F285+F286)*((100-VALUE(InputNoShipCosts))/100)*(VLOOKUP(InputSector,SECTORDATA,21,0)-InputSendCost),1)+CEILING((F286)*(VLOOKUP(InputSector,SECTORDATA,21,0)-InputRetourCost),1)+CEILING((F285+F286)*VLOOKUP(InputSector,SECTORDATA,18,0),1),\"\"),\"\")","v":12852},13041,13237,13443,13640,13854,14060,14274,14479,14710,14924,15147]
[null,null,null,null,"Netto resultaat e-shop",{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,F288-F289-F290-F291,0),0)","v":14093.919999999998},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,G288-G289-G290-G291,0),0)","v":16836.919999999998},17095.919999999998,17370.919999999998,17630.919999999998,17869.919999999998,18143.919999999998,18435.919999999998,18711.919999999998,18981.919999999998,19273.919999999998,19579.919999999998,0]
[null,null,"Simulatie marktplaatsen"]
[null,null,null,null,{"$f":"IF(InputIncludeMarkt=1,IF(LEN(InputMarktNaam1)>0,InputMarktNaam1,\"\"),\"\")","v":""},{"$f":"IF(InputIncludeMarkt=1,IF(VALUE(InputMarktOmzet1Y1)>0,((VALUE(InputMarktOmzet1Y1)*InputMarge/100)-(VALUE(InputMarktOmzet1Y1)*VALUE(InputMarktCom1)/100)-VALUE(InputMarktAbo1))/12,\"\"),\"\")","v":""},{"$f":"F294","v":""},"","","","","","","","",{"$f":"O294","v":""},""]
[null,null,null,null,{"$f":"IF(InputIncludeMarkt=1,IF(LEN(InputMarktNaam2)>0,InputMarktNaam2,\"\"),\"\")","v":""},{"$f":"IF(InputIncludeMarkt=1,IF(VALUE(InputMarktOmzet2Y1)>0,((VALUE(InputMarktOmzet2Y1)*InputMarge/100)-(VALUE(InputMarktOmzet2Y1)*VALUE(InputMarktCom2)/100)-VALUE(InputMarktAbo2))/12,\"\"),\"\")","v":""},"","","","","","","","","",{"$f":"O295","v":""},""]
[null,null,null,null,{"$f":"IF(InputIncludeMarkt=1,IF(LEN(InputMarktNaam3)>0,InputMarktNaam3,\"\"),\"\")","v":""},{"$f":"IF(InputIncludeMarkt=1,IF(VALUE(InputMarktOmzet3Y1)>0,((VALUE(InputMarktOmzet3Y1)*InputMarge/100)-(VALUE(InputMarktOmzet3Y1)*VALUE(InputMarktCom3)/100)-VALUE(InputMarktAbo3))/12,\"\"),\"\")","v":""},"","","","","","","","","",{"$f":"O296","v":""},""]
[null,null,null,null,{"$f":"IF(InputIncludeMarkt=1,\"Netto resultaat marktplaatsen\",\"\")","v":""},{"$f":"IF(InputIncludeMarkt=1,SUM(F294:F296),\"\")","v":""},"","","","","","","","","","",""]
[]
[null,null,"Netto Resultaat (*)",null,null,{"$f":"IF(InputIncludeMarkt=1,F297,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,F292,0),0)-F278-F272-F268-F264-F259","v":-13074.270300000004},14144.381792342707,14400.369210876772,14672.314083093715,14929.21580811714,15165.07377658455,15435.887370527484,15724.655963250001,15997.378919205405,16264.055593871251,16552.685333622594,16855.267475603403]
[null,null,"(*) Het betreft enkel uw netto online resultaat. Uw online inspanningen zullen ook resulteren in verkoop in uw fysieke winkel."]
[]
[]
[]
[]
[]
[null,"Uw financieel plan"]
[null,"Meer tips en inspiratie op www.hetinternetookuwzaak.be"]
[null,"Pagina 5 van 11"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uw financieel plan"]
[]
[null,null,"Jaar 2"]
[null,null,null,null,null,"m1","m2","m3","m4","m5","m6","m7","m8","m9","m10","m11","m12"]
[null,null,"Social Media"]
[null,null,null,null,"Configuratie en onderhoud",{"$f":"IF(InputIncludeSocial=1,VLOOKUP(InputSector,SECTORDATA,32,0)*0.75,\"\")","v":1018.96704}]
[null,null,null,null,"Plaatsen van berichten, foto's, …",{"$f":"IF(InputIncludeSocial=1,VLOOKUP(InputSector,SECTORDATA,40,0)*(52/12),\"\")","v":1381.8175800000006},{"$f":"F317","v":1381.8175800000006},1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006]
[null,null,null,null,"Netto resultaat Sociale Media",{"$f":"SUM(F316:F317)","v":2400.7846200000004},{"$f":"SUM(G316:G317)","v":1381.8175800000006},1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006]
[null,null,"Email Marketing"]
[null,null,null,null,"Configuratie en onderhoud",{"$f":"IF(InputIncludeEmail=1,VLOOKUP(InputSector,SECTORDATA,44,0)*0.75,\"\")","v":390}]
[null,null,null,null,"Schrijven en versturen van emails",{"$f":"IF(InputIncludeEmail=1,VLOOKUP(InputSector,SECTORDATA,52,0)*(52/12),\"\")","v":327.70833333333337},{"$f":"F321","v":327.70833333333337},327.70833333333337,327.70833333333337,327.70833333333337,327.70833333333337,327.70833333333337,327.70833333333337,327.70833333333337,327.70833333333337,327.70833333333337,327.70833333333337]
[null,null,null,null,"Abonnementskost",{"$f":"IF(InputIncludeEmail=1,(F339*FormuleEmailMultiplier*1.2%),\"\")","v":233.55107240376913},237.06615211001841,240.63087485416494,244.24594173872049,247.91206376778152,251.6299619868677,255.40036762473585,259.22402223719638,263.10167785296125,267.03409712155116,271.02205346329231,275.06633122143074]
[null,null,null,null,"Netto resultaat Email Marketing",{"$f":"SUM(F320:F322)","v":951.2594057371025},{"$f":"SUM(G320:G322)","v":564.77448544335175},568.33920818749834,571.95427507205386,575.62039710111492,579.33829532020104,583.10870095806922,586.93235557052981,590.81001118629456,594.74243045488447,598.73038679662568,602.77466455476406]
[null,null,"Content Marketing"]
[null,null,null,null,"Configuratie en onderhoud",{"$f":"IF(InputIncludeBlog=1,VLOOKUP(InputSector,SECTORDATA,56,0)*0.75,\"\")","v":1950}]
[null,null,null,null,"Schrijven voor en promoten van blog",{"$f":"IF(InputIncludeBlog=1,VLOOKUP(InputSector,SECTORDATA,64,0)*(52/12),\"\")","v":154},{"$f":"F326","v":154},154,154,154,154,154,154,154,154,154,154]
[null,null,null,null,"Netto resultaat Blog",{"$f":"SUM(F325:F326)","v":2104},{"$f":"SUM(G325:G326)","v":154},154,154,154,154,154,154,154,154,154,154]
[null,null,"Online advertenties"]
[null,null,null,null,"Zoekmachine advertenties",{"$f":"VALUE(InputMarketing)/12","v":166.66666666666666},{"$f":"F329","v":166.66666666666666},166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666]
[null,null,null,null,"Sociale media advertenties",{"$f":"VALUE(InputMarketingSocial)/12","v":41.666666666666664},41.666666666666664,41.666666666666664,41.666666666666664,41.666666666666664,41.666666666666664,41.666666666666664,41.666666666666664,41.666666666666664,41.666666666666664,41.666666666666664,41.666666666666664]
[null,null,null,null,"Netto resultaat Advertenties",{"$f":"SUM(F329:F330)","v":208.33333333333331},{"$f":"SUM(G329:G330)","v":208.33333333333331},208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331]
[null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,IF(InputSiteShop=1,\"Ontwikkeling van uw site\",\"Ontwikkeling van uw e-shop\"),\"Ontwikkeling\")","v":"Ontwikkeling van uw e-shop"}]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Ontwikkeling\",\"\")","v":"Ontwikkeling"}]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Onderhoud\",\"\")","v":"Onderhoud"},{"$f":"IF(VALUE(InputIncludeSiteShop)=1,IF(VALUE(InputBuyRent)=1,VALUE(InputSlaCost)/12,\"\"),\"\")","v":166.66666666666666},{"$f":"F334","v":166.66666666666666},166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Hosting\",\"\")","v":"Hosting"},{"$f":"IF(VALUE(InputIncludeSiteShop)=1,IF(VALUE(InputBuyRent)=1,VALUE(InputHostCost)/12,\"\"),\"\")","v":166.66666666666666},{"$f":"F335","v":166.66666666666666},166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Abonnement\",\"\")","v":"Abonnement"},{"$f":"IF(VALUE(InputIncludeSiteShop)=1,IF(VALUE(InputBuyRent)=2,VALUE(InputRentCost),\"\"),\"\")","v":""},{"$f":"F336","v":""},"","","","","","","","","",""]
[null,null,null,null,"Netto resultaat ontwikkeling",{"$f":"SUM(F333:F336)","v":333.33333333333331},{"$f":"SUM(G333:G336)","v":333.33333333333331},333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331]
[null,null,"Simulatie klantenevolutie"]
[null,null,null,null,"Actieve klanten",{"$f":"Q280+((Q281+Q282+Q283)*VLOOKUP(InputSector,SECTORDATA,5,0))","v":8982.7335539911201},{"$f":"F339+((F340+F341+F342)*VLOOKUP(InputSector,SECTORDATA,5,0))","v":9117.9289273084014},9255.0336482371131,9394.0746822584806,9535.0793756839048,9678.0754610333734,9823.0910624898406,9970.1547014306307,10119.295302036971,10270.542196982738,10423.925133203551,10579.474277747337]
[null,null,null,null,"Bezoekers n.a.v. marketing activiteiten",{"$f":"(F339*VALUE(FormuleMarketingImpact))-F339","v":4228.7346661315969},4292.379586512583,4356.923356267831,4422.3786697363794,4488.7584005378594,4556.0756041044442,4624.3435202485689,4693.5755757669103,4763.7853870811414,4834.986762915978,4907.1937070150634,4980.4204208951778]
[null,null,null,null,"Bezoekers n.a.v. sector evolutie",{"$f":"(F339*VALUE(FormuleVisitorsY2))-F339","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Bezoekers n.a.v. online advertenties",{"$f":"F331/VLOOKUP(InputSector,SECTORDATA,22,0)","v":277.77777777777777},277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777]
[null,null,{"$f":"IF(InputSiteShop=2,\"Simulatie van uw e-shop\",\"\")","v":"Simulatie van uw e-shop"}]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Aantal verkopen\",\"\")","v":"Aantal verkopen"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,CEILING((F340+F341+F342)*VLOOKUP(InputSector,SECTORDATA,5,0)+((F339*VLOOKUP(InputSector,SECTORDATA,25,0)/12)),1),\"\"),\"\")","v":1633},1657,1682,1707,1733,1759,1785,1811,1838,1866,1893,1921]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Aantal retouren\",\"\")","v":"Aantal retouren"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,FLOOR((F344)*VLOOKUP(InputSector,SECTORDATA,11,0),1),\"\"),\"\")","v":163},165,168,170,173,175,178,181,183,186,189,192]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Omzet\",\"\")","v":"Omzet"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,CEILING((F344-F345)*VLOOKUP(InputSector,SECTORDATA,8,0),1),\"\"),\"\")","v":73500},74600,75700,76850,78000,79200,80350,81500,82750,84000,85200,86450]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Marge\",\"\")","v":"Marge"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,CEILING((F346)*InputMarge/100,2),\"\"),\"\")","v":36750},37300,37850,38426,39000,39600,40176,40750,41376,42000,42600,43226]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Kostprijs online betaling\",\"\")","v":"Kostprijs online betaling"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,CEILING((F344+F345)*VLOOKUP(InputSector,SECTORDATA,8,0)*VLOOKUP(InputSector,SECTORDATA,14,0),1),\"\"),\"\")","v":1347},1367,1388,1408,1430,1451,1473,1494,1516,1539,1562,1585]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Kostprijs productbeheer\",\"\")","v":"Kostprijs productbeheer"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,ROUND((((VALUE(InputProductChange)*VALUE(InputUpdateTime))/60)*VALUE(InputProductRate))/12,2),\"\"),\"\")","v":52.08},{"$f":"F349","v":52.08},52.08,52.08,52.08,52.08,52.08,52.08,52.08,52.08,52.08,52.08]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Kostprijs logistiek\",\"\")","v":"Kostprijs logistiek"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,CEILING((F344+F345)*((100-VALUE(InputNoShipCosts))/100)*(VLOOKUP(InputSector,SECTORDATA,21,0)-InputSendCost),1)+CEILING((F345)*(VLOOKUP(InputSector,SECTORDATA,21,0)-InputRetourCost),1)+CEILING((F344+F345)*VLOOKUP(InputSector,SECTORDATA,18,0),1),\"\"),\"\")","v":15378},15601,15841,16071,16320,16560,16808,17057,17305,17570,17827,18093]
[null,null,null,null,"Netto resultaat e-shop",{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,F347-F348-F349-F350,0),0)","v":19972.919999999998},20279.919999999998,20568.919999999998,20894.919999999998,21197.919999999998,21536.92,21842.92,22146.92,22502.92,22838.92,23158.92,23495.919999999998]
[null,null,"Simulatie marktplaatsen"]
[null,null,null,null,{"$f":"IF(InputIncludeMarkt=1,IF(LEN(InputMarktNaam1)>0,InputMarktNaam1,\"\"),\"\")","v":""},{"$f":"IF(InputIncludeMarkt=1,IF(VALUE(InputMarktOmzet1Y2)>0,((VALUE(InputMarktOmzet1Y2)*InputMarge/100)-(VALUE(InputMarktOmzet1Y2)*VALUE(InputMarktCom1)/100)-VALUE(InputMarktAbo1))/12,\"\"),\"\")","v":""},{"$f":"F353","v":""},"","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(InputIncludeMarkt=1,IF(LEN(InputMarktNaam2)>0,InputMarktNaam2,\"\"),\"\")","v":""},{"$f":"IF(InputIncludeMarkt=1,IF(VALUE(InputMarktOmzet2Y2)>0,((VALUE(InputMarktOmzet2Y2)*InputMarge/100)-(VALUE(InputMarktOmzet2Y2)*VALUE(InputMarktCom2)/100)-VALUE(InputMarktAbo2))/12,\"\"),\"\")","v":""},{"$f":"F354","v":""},"","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(InputIncludeMarkt=1,IF(LEN(InputMarktNaam3)>0,InputMarktNaam3,\"\"),\"\")","v":""},{"$f":"IF(InputIncludeMarkt=1,IF(VALUE(InputMarktOmzet3Y2)>0,((VALUE(InputMarktOmzet3Y2)*InputMarge/100)-(VALUE(InputMarktOmzet3Y2)*VALUE(InputMarktCom3)/100)-VALUE(InputMarktAbo3))/12,\"\"),\"\")","v":""},{"$f":"F355","v":""},"","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(InputIncludeMarkt=1,\"Netto resultaat marktplaatsen\",\"\")","v":""},{"$f":"IF(InputIncludeMarkt=1,SUM(F353:F355),\"\")","v":""},"","","","","","","","","","",""]
[]
[null,null,"Netto Resultaat (*)",null,null,{"$f":"IF(InputIncludeMarkt=1,F356,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,F351,0),0)-F337-F331-F327-F323-F318","v":13975.209307596231},17637.661267889984,17923.096545145836,18245.481478261281,18544.815356232219,18880.097458013133,19182.327052375265,19482.503397762805,19834.62574214704,20166.693322878451,20482.705366536709,20815.661088778572]
[null,null,"(*) Het betreft enkel uw netto online resultaat. Uw online inspanningen zullen ook resulteren in verkoop in uw fysieke winkel."]
[]
[]
[]
[]
[]
[null,"Uw financieel plan"]
[null,"Meer tips en inspiratie op www.hetinternetookuwzaak.be"]
[null,"Pagina 6 van 11"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uw financieel plan"]
[]
[null,null,"Jaar 3"]
[null,null,null,null,null,"m1","m2","m3","m4","m5","m6","m7","m8","m9","m10","m11","m12"]
[null,null,"Social Media"]
[null,null,null,null,"Configuratie en onderhoud",{"$f":"IF(InputIncludeSocial=1,VLOOKUP(InputSector,SECTORDATA,32,0)*0.5,\"\")","v":679.31136000000004}]
[null,null,null,null,"Plaatsen van berichten, foto's, …",{"$f":"IF(InputIncludeSocial=1,VLOOKUP(InputSector,SECTORDATA,40,0)*(52/12),\"\")","v":1381.8175800000006},{"$f":"F376","v":1381.8175800000006},1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006]
[null,null,null,null,"Netto resultaat Sociale Media",{"$f":"SUM(F375:F376)","v":2061.1289400000005},{"$f":"SUM(G375:G376)","v":1381.8175800000006},1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006,1381.8175800000006]
[null,null,"Email Marketing"]
[null,null,null,null,"Configuratie en onderhoud",{"$f":"IF(InputIncludeEmail=1,VLOOKUP(InputSector,SECTORDATA,44,0)*0.5,\"\")","v":260}]
[null,null,null,null,"Schrijven en versturen van emails",{"$f":"IF(InputIncludeEmail=1,VLOOKUP(InputSector,SECTORDATA,52,0)*(52/12),\"\")","v":327.70833333333337},{"$f":"F380","v":327.70833333333337},327.70833333333337,327.70833333333337,327.70833333333337,327.70833333333337,327.70833333333337,327.70833333333337,327.70833333333337,327.70833333333337,327.70833333333337,327.70833333333337]
[null,null,null,null,"Abonnementskost",{"$f":"IF(InputIncludeEmail=1,(F398*FormuleEmailMultiplier*1.2%),\"\")","v":279.16772581639566},{"$f":"IF(InputIncludeEmail=1,(G398*FormuleEmailMultiplier*1.2%),\"\")","v":283.32704390224097},287.54510352529672,291.82273428506033,296.16077749736075,300.56008635982693,305.02152611969279,309.54597424397252,314.1343205920387,318.78746759063853,323.50633041138082,328.29183715073049]
[null,null,null,null,"Netto resultaat Email Marketing",{"$f":"SUM(F379:F381)","v":866.87605914972903},{"$f":"SUM(G379:G381)","v":611.03537723557429},615.25343685863004,619.53106761839376,623.86911083069413,628.26841969316024,632.72985945302617,637.25430757730589,641.84265392537213,646.49580092397196,651.21466374471424,656.0001704840638]
[null,null,"Content Marketing"]
[null,null,null,null,"Configuratie en onderhoud",{"$f":"IF(InputIncludeBlog=1,VLOOKUP(InputSector,SECTORDATA,56,0)*0.5,\"\")","v":1300}]
[null,null,null,null,"Schrijven voor en promoten van blog",{"$f":"IF(InputIncludeBlog=1,VLOOKUP(InputSector,SECTORDATA,64,0)*(52/12),\"\")","v":154},{"$f":"F385","v":154},154,154,154,154,154,154,154,154,154,154]
[null,null,null,null,"Netto resultaat Blog",{"$f":"SUM(F384:F385)","v":1454},{"$f":"SUM(G384:G385)","v":154},154,154,154,154,154,154,154,154,154,154]
[null,null,"Online advertenties"]
[null,null,null,null,"Zoekmachine advertenties",{"$f":"VALUE(InputMarketing)/12","v":166.66666666666666},{"$f":"F388","v":166.66666666666666},166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666]
[null,null,null,null,"Sociale media advertenties",{"$f":"VALUE(InputMarketingSocial)/12","v":41.666666666666664},41.666666666666664,41.666666666666664,41.666666666666664,41.666666666666664,41.666666666666664,41.666666666666664,41.666666666666664,41.666666666666664,41.666666666666664,41.666666666666664,41.666666666666664]
[null,null,null,null,"Netto resultaat Advertenties",{"$f":"SUM(F388:F389)","v":208.33333333333331},{"$f":"SUM(G388:G389)","v":208.33333333333331},208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331,208.33333333333331]
[null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,IF(InputSiteShop=1,\"Ontwikkeling van uw site\",\"Ontwikkeling van uw e-shop\"),\"Ontwikkeling\")","v":"Ontwikkeling van uw e-shop"}]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Ontwikkeling\",\"\")","v":"Ontwikkeling"}]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Onderhoud\",\"\")","v":"Onderhoud"},{"$f":"IF(VALUE(InputIncludeSiteShop)=1,IF(VALUE(InputBuyRent)=1,VALUE(InputSlaCost)/12,\"\"),\"\")","v":166.66666666666666},{"$f":"F393","v":166.66666666666666},166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Hosting\",\"\")","v":"Hosting"},{"$f":"IF(VALUE(InputIncludeSiteShop)=1,IF(VALUE(InputBuyRent)=1,VALUE(InputHostCost)/12,\"\"),\"\")","v":166.66666666666666},{"$f":"F394","v":166.66666666666666},166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666,166.66666666666666]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Abonnement\",\"\")","v":"Abonnement"},{"$f":"IF(VALUE(InputIncludeSiteShop)=1,IF(VALUE(InputBuyRent)=2,VALUE(InputRentCost),\"\"),\"\")","v":""},{"$f":"F395","v":""},"","","","","","","","","",""]
[null,null,null,null,"Netto resultaat ontwikkeling",{"$f":"SUM(F392:F395)","v":333.33333333333331},{"$f":"SUM(G392:G395)","v":333.33333333333331},333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331,333.33333333333331]
[null,null,"Simulatie klantenevolutie"]
[null,null,null,null,"Actieve klanten",{"$f":"Q339+((Q340+Q341+Q342)*VLOOKUP(InputSector,SECTORDATA,5,0))","v":10737.220223707525},{"$f":"F398+((F399+F400+F401)*VLOOKUP(InputSector,SECTORDATA,5,0))","v":10897.193996240039},11059.42705866526,11223.951318656167,11390.799134513876,11560.003321531805,11731.597158449724,11905.614393998943,12082.089253539951,12261.056445793789,12442.551169668493,12626.609121181942]
[null,null,null,null,"Bezoekers n.a.v. marketing activiteiten",{"$f":"(F398*VALUE(FormuleMarketingImpact))-F398","v":5054.6813066393825},5129.9909697295807,5206.3642219191006,5283.8160841458375,5362.3617894865383,5442.0167861528298,5522.7967405295167,5604.7175402558332,5687.7952973501851,5772.0463513790328,5857.4872726705198,5944.1348655734892]
[null,null,null,null,"Bezoekers n.a.v. sector evolutie",{"$f":"(F398*VALUE(FormuleVisitorsY2))-F398","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Bezoekers n.a.v. online advertenties",{"$f":"F390/VLOOKUP(InputSector,SECTORDATA,22,0)","v":277.77777777777777},277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777,277.77777777777777]
[null,null,{"$f":"IF(InputSiteShop=2,\"Simulatie van uw e-shop\",\"\")","v":"Simulatie van uw e-shop"}]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Aantal verkopen\",\"\")","v":"Aantal verkopen"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,CEILING((F399+F400+F401)*VLOOKUP(InputSector,SECTORDATA,5,0)+((F398*VLOOKUP(InputSector,SECTORDATA,25,0)/12)),1),\"\"),\"\")","v":1950},1979,2008,2038,2068,2099,2130,2161,2193,2226,2258,2292]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Aantal retouren\",\"\")","v":"Aantal retouren"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,FLOOR((F403)*VLOOKUP(InputSector,SECTORDATA,11,0),1),\"\"),\"\")","v":195},197,200,203,206,209,213,216,219,222,225,229]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Omzet\",\"\")","v":"Omzet"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,CEILING((F403-F404)*VLOOKUP(InputSector,SECTORDATA,8,0),1),\"\"),\"\")","v":87750},89100,90400,91750,93100,94500,95850,97250,98700,100200,101650,103150]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Marge\",\"\")","v":"Marge"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,CEILING((F405)*InputMarge/100,1),\"\"),\"\")","v":43875},44550,45200,45875,46550,47250,47925,48625,49350,50100,50825,51575]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Kostprijs online betaling\",\"\")","v":"Kostprijs online betaling"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,CEILING((F403+F404)*VLOOKUP(InputSector,SECTORDATA,8,0)*VLOOKUP(InputSector,SECTORDATA,14,0),1),\"\"),\"\")","v":1609},1632,1656,1681,1706,1731,1758,1783,1809,1836,1863,1891]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Kostprijs productbeheer\",\"\")","v":"Kostprijs productbeheer"},{"$f":"Q349","v":52.08},{"$f":"F408","v":52.08},52.08,52.08,52.08,52.08,52.08,52.08,52.08,52.08,52.08,52.08]
[null,null,null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,\"Kostprijs logistiek\",\"\")","v":"Kostprijs logistiek"},{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,CEILING((F403+F404)*((100-VALUE(InputNoShipCosts))/100)*(VLOOKUP(InputSector,SECTORDATA,21,0)-InputSendCost),1)+CEILING((F404)*(VLOOKUP(InputSector,SECTORDATA,21,0)-InputRetourCost),1)+CEILING((F403+F404)*VLOOKUP(InputSector,SECTORDATA,18,0),1),\"\"),\"\")","v":18367},18632,18905,19188,19471,19761,20062,20353,20652,20961,21260,21586]
[null,null,null,null,"Netto resultaat e-shop",{"$f":"IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,F406-F407-F408-F409,0),0)","v":23846.92},24233.919999999998,24586.92,24953.919999999998,25320.92,25705.919999999998,26052.92,26436.92,26836.92,27250.92,27649.919999999998,28045.919999999998]
[null,null,"Simulatie marktplaatsen"]
[null,null,null,null,{"$f":"IF(InputIncludeMarkt=1,IF(LEN(InputMarktNaam1)>0,InputMarktNaam1,\"\"),\"\")","v":""},{"$f":"IF(InputIncludeMarkt=1,IF(VALUE(InputMarktOmzet1Y3)>0,((VALUE(InputMarktOmzet1Y3)*InputMarge/100)-(VALUE(InputMarktOmzet1Y3)*VALUE(InputMarktCom1)/100)-VALUE(InputMarktAbo1))/12,\"\"),\"\")","v":""},{"$f":"F412","v":""},"","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(InputIncludeMarkt=1,IF(LEN(InputMarktNaam2)>0,InputMarktNaam2,\"\"),\"\")","v":""},{"$f":"IF(InputIncludeMarkt=1,IF(VALUE(InputMarktOmzet2Y3)>0,((VALUE(InputMarktOmzet2Y3)*InputMarge/100)-(VALUE(InputMarktOmzet2Y3)*VALUE(InputMarktCom2)/100)-VALUE(InputMarktAbo2))/12,\"\"),\"\")","v":""},{"$f":"F413","v":""},"","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(InputIncludeMarkt=1,IF(LEN(InputMarktNaam3)>0,InputMarktNaam3,\"\"),\"\")","v":""},{"$f":"IF(InputIncludeMarkt=1,IF(VALUE(InputMarktOmzet3Y3)>0,((VALUE(InputMarktOmzet3Y3)*InputMarge/100)-(VALUE(InputMarktOmzet3Y3)*VALUE(InputMarktCom3)/100)-VALUE(InputMarktAbo3))/12,\"\"),\"\")","v":""},{"$f":"F414","v":""},"","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(InputIncludeMarkt=1,\"Netto resultaat marktplaatsen\",\"\")","v":""},{"$f":"IF(InputIncludeMarkt=1,SUM(F412:F414),\"\")","v":""},"","","","","","","","","","","",""]
[]
[null,null,"Netto Resultaat (*)",null,null,{"$f":"IF(InputIncludeMarkt=1,F415,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,F410,0),0)-F396-F390-F386-F382-F377","v":18923.248334183605},21545.400376097761,21894.182316474704,22256.904685714941,22619.566642502639,23000.167333640176,23342.705893880309,23722.181445756029,24117.593099407964,24526.939952409364,24921.22108958862,25312.43558284927]
[null,null,"(*) Het betreft enkel uw netto online resultaat. Uw online inspanningen zullen ook resulteren in verkoop in uw fysieke winkel."]
[]
[]
[]
[]
[]
[]
[null,"Uw financieel plan"]
[null,"Meer tips en inspiratie op www.hetinternetookuwzaak.be"]
[null,"Pagina 7 van 11"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uw financieel plan"]
[null,null,"Uw omzet- en cashflow-evolutie"]
[]
[null,null,"Uw online omzet evolutie duidt voor elke maand de verwachte situatie aan. Uw cashflow evolutie is het resultaat van de gecombineerde omzetten.\n\nMet een stijgende cashflow-evolutie staat u er goed voor: wij verwachten namelijk dat, mist de nodige inspanningen zoals u ze heeft gedefinieerd, uw online plannen een zeer grote slaagkans hebben. Maar zelfs een dalende cashflow-evolutie kan positief zijn voor uw offline activiteiten. Hiervoor kijkt u best naar de 2e grafiek: de klantenevolutie. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Uw klantenevolutie"]
[]
[null,null,"Al uw online activiteiten hebben een grote invloed op uw klantenportefeuille en deze invloed beperkt zich echter niet alleen tot online. Ook uw offline activiteiten profiteren mee van uw online inspanningen. Een groter bereik en meer klanten online = meer klanten in uw winkel.\n\nU kunt deze overgang van online naar offline verder stimuleren door bijvoorbeeld gratis afhaling in uw winkel aan te bieden voor online bestellingen."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Uw financieel plan"]
[null,"Meer tips en inspiratie op www.hetinternetookuwzaak.be"]
[null,"Pagina 8 van 11"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uw financieel plan"]
[null,null,"Resultaat"]
[]
[null,null,"Op basis van uw input heeft u voor uw online activiteiten volgend budget nodig. "]
[]
[null,null,null,null,null,"Jaar 1",null,"Jaar 2",null,"Jaar 3"]
[null,null,"Social media",null,null,{"$f":"SUM(F259:Q259)","v":17940.433680000006},null,{"$f":"SUM(F318:Q318)","v":17600.778000000009},null,{"$f":"SUM(F377:Q377)","v":17261.122320000009}]
[null,null,"Email marketing",null,null,{"$f":"SUM(F264:Q264)","v":8070.5912929049809},null,{"$f":"SUM(F323:Q323)","v":7368.3846163824901},null,{"$f":"SUM(F382:Q382)","v":7830.3709274946359}]
[null,null,"Blog",null,null,{"$f":"SUM(F268:Q268)","v":4448},null,{"$f":"SUM(F386:Q386)","v":3148},null,{"$f":"SUM(F386:Q386)","v":3148}]
[null,null,"Online advertenties",null,null,{"$f":"SUM(F272:Q272)","v":2500},null,{"$f":"SUM(F331:Q331)","v":2500},null,{"$f":"SUM(F390:Q390)","v":2500}]
[null,null,"Ontwikkeling van uw site",null,null,{"$f":"SUM(F278:Q278)","v":23999.999999999989},null,{"$f":"SUM(F337:Q337)","v":4000.0000000000005},null,{"$f":"SUM(F396:Q396)","v":4000.0000000000005}]
[null,null,"Totaal",null,null,{"$f":"SUM(F490:G494)","v":56959.024972904968},null,{"$f":"SUM(H490:I494)","v":34617.162616382499},null,{"$f":"SUM(J490:K494)","v":34739.493247494647}]
[]
[]
[null,null,"Deze inspanning resulteert in meer klanten en daaruit volgend meer omzet. Zowel in uw winkel als online. "]
[]
[null,null,"De evolutie van online netto-resultaat wordt als volgt ingeschat:"]
[]
[null,null,null,null,null,"Jaar 1",null,"Jaar 2",null,"Jaar 3"]
[null,null,"Uw e-shop",null,null,{"$f":"SUM(F292:Q292)","v":214026.03999999992},null,{"$f":"SUM(F351:Q351)","v":260438.03999999992},null,{"$f":"SUM(F410:Q410)","v":310922.03999999992}]
[null,null,"Marktplaatsen",null,null,{"$f":"SUM(F297:Q297)","v":0},null,{"$f":"SUM(F356:Q356)","v":0},null,{"$f":"SUM(F415:Q415)","v":0}]
[]
[]
[null,null,"Tijdsinvestering"]
[]
[null,null,"Op basis van uw input heeft u voor uw online activiteiten volgend aantal uren per maand nodig. "]
[]
[null,null,null,null,null,"Jaar 1",null,"Jaar 2",null,"Jaar 3"]
[null,null,"Social media",null,null,{"$f":"IF(VALUE(InputIncludeSocial)=1,VLOOKUP(VALUE(InputSector),SECTORDATA,35,0)*(52/12),\"n.v.t.\")","v":27.636351600000008},null,{"$f":"IF(VALUE(InputIncludeSocial)=1,VLOOKUP(VALUE(InputSector),SECTORDATA,39,0)*(52/12),\"n.v.t.\")","v":27.636351600000008},null,{"$f":"IF(VALUE(InputIncludeSocial)=1,VLOOKUP(VALUE(InputSector),SECTORDATA,39,0)*(52/12),\"n.v.t.\")","v":27.636351600000008}]
[null,null,"Email marketing",null,null,{"$f":"IF(VALUE(InputIncludeEmail)=1,VLOOKUP(VALUE(InputSector),SECTORDATA,47,0)*(52/12),\"n.v.t.\")","v":8.3416666666666668},null,{"$f":"IF(VALUE(InputIncludeEmail)=1,VLOOKUP(VALUE(InputSector),SECTORDATA,51,0)*(52/12),\"n.v.t.\")","v":6.5541666666666671},null,{"$f":"IF(VALUE(InputIncludeEmail)=1,VLOOKUP(VALUE(InputSector),SECTORDATA,51,0)*(52/12),\"n.v.t.\")","v":6.5541666666666671}]
[null,null,"Blog",null,null,{"$f":"IF(VALUE(InputIncludeBlog)=1,VLOOKUP(VALUE(InputSector),SECTORDATA,59,0)*(52/12),\"n.v.t.\")","v":3.08},null,{"$f":"IF(VALUE(InputIncludeBlog)=1,VLOOKUP(VALUE(InputSector),SECTORDATA,63,0)*(52/12),\"n.v.t.\")","v":3.08},null,{"$f":"IF(VALUE(InputIncludeBlog)=1,VLOOKUP(VALUE(InputSector),SECTORDATA,63,0)*(52/12),\"n.v.t.\")","v":3.08}]
[null,null,"Beheren productcataloog",null,null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,(VALUE(InputProductChange)*VALUE(InputUpdateTime)/60)/12,0)","v":1.0416666666666667},null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,(VALUE(InputProductChange)*VALUE(InputUpdateTime)/60)/12,0)","v":1.0416666666666667},null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,(VALUE(InputProductChange)*VALUE(InputUpdateTime)/60)/12,0)","v":1.0416666666666667}]
[null,null,null,null,"Logistiek beheer",{"$f":"IF(VALUE(InputIncludeSiteShop)=1,((SUM(F285:Q285)+SUM(F286:Q286))/12)*VLOOKUP(InputSector,SECTORDATA,15,0)*(0.25/7),0)","v":174.83035714285714},null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,((SUM(F344:Q344)+2*SUM(F345:Q345))/12)*VLOOKUP(InputSector,SECTORDATA,15,0)*(0.25/7),0)","v":227.95535714285714},null,{"$f":"IF(VALUE(InputIncludeSiteShop)=1,((SUM(F403:Q403)+2*SUM(F404:Q404))/12)*VLOOKUP(InputSector,SECTORDATA,15,0)*(0.25/7),0)","v":272.05357142857139}]
[null,null,"Totaal",null,null,{"$f":"SUM(F512:G516)","v":214.93004207619049},null,{"$f":"SUM(H512:I516)","v":266.26754207619047},null,{"$f":"SUM(J512:K516)","v":310.36575636190474}]
[]
[]
[null,null,"Break-even analyse"]
[]
[null,null,"Indien u wenst dat uw e-shop op zichzelf rendabel is, dan kunt u door middel van een break-even analyse heel snel (zij het minder accuraat dan via een echte business case) inschatten hoeveel bestellingen u jaarlijks moet halen en welke omzet dat vertegenwoordigt.\n\nIndien u specifieke medewerkers in dienst heeft kunt u bij uw operationele kosten de volledige loonkost bijtellen."]
[]
[null,null,null,null,null,null,"Onze inschatting"]
[null,null,"Gemiddelde bestelwaarde",null,null,null,{"$f":"VLOOKUP(VALUE(InputSector),SECTORDATA,8,0)","v":50}]
[null,null,"Marge",null,null,null,{"$f":"VALUE(InputMarge)/100","v":0.5}]
[null,null,"Vaste kost per order",null,null,null,{"$f":"AVERAGE((SUM(F289:Q289)+SUM(F291:Q291))/SUM(F285:Q285),(SUM(F348:Q348)+SUM(F350:Q350))/SUM(F344:Q344),(SUM(F407:Q407)+SUM(F409:Q409))/SUM(F403:Q403))","v":10.266023360049074},null,null,null,"?"]
[null,null,"Retour percentage",null,null,null,{"$f":"VLOOKUP(VALUE(InputSector),SECTORDATA,5,0)","v":0.03}]
[null,null,"Jaarlijkse operationele kosten",null,null,null,{"$f":"AVERAGE(\n IF(InputIncludeSocial=1,VLOOKUP(VALUE(InputSector),SECTORDATA,32,0),0)+IF(InputIncludeSocial=1,VLOOKUP(VALUE(InputSector),SECTORDATA,36,0)*52,0)\n +IF(InputIncludeBlog=1,VLOOKUP(VALUE(InputSector),SECTORDATA,44,0),0)+IF(InputIncludeBlog=1,VLOOKUP(VALUE(InputSector),SECTORDATA,48,0)*52,0)\n +IF(InputIncludeEmail=1,VLOOKUP(VALUE(InputSector),SECTORDATA,56,0),0)+IF(InputIncludeEmail=1,VLOOKUP(VALUE(InputSector),SECTORDATA,60,0)*52,0),\n IF(InputIncludeSocial=1,VLOOKUP(VALUE(InputSector),SECTORDATA,40,0)*52,0)\n +IF(InputIncludeBlog=1,VLOOKUP(VALUE(InputSector),SECTORDATA,52,0)*52,0)\n +IF(InputIncludeEmail=1,VLOOKUP(VALUE(InputSector),SECTORDATA,64,0)*52,0)\n)\n+VALUE(InputMarketing)+VALUE(InputMarketingSocial)\n+IF(InputSiteShop=2,((((VALUE(InputProducts)+VALUE(InputProductChange))*VALUE(InputUpdateTime))/60)*VALUE(InputProductRate)),0)","v":30762.872320000006}]
[null,null,"Break-even order aantal",null,null,null,{"$f":"ROUND(G529/((G526*(1-G528)*G525)-G527),0)","v":2200}]
[null,null,"Break-even omzet",null,null,null,{"$f":"G530*G525","v":110000}]
[null,null,"Omzet Jaar 1 uit financieel plan",null,null,null,{"$f":"SUM(F287:Q287)","v":801650}]
[null,null,"Omzet Jaar 2 uit financieel plan",null,null,null,{"$f":"SUM(F346:Q346)","v":958100}]
[null,null,"Omzet Jaar 3 uit financieel plan",null,null,null,{"$f":"SUM(F405:Q405)","v":1143400}]
[]
[]
[]
[null,"Uw financieel plan"]
[null,"Meer tips en inspiratie op www.hetinternetookuwzaak.be"]
[null,"Pagina 9 van 11"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uw financieel plan"]
[null,null,"Methodiek, bronnen en auteur"]
[]
[null,null,"Hieronder vindt u een kort overzicht van hoe alle bedragen in uw financieel plan berekend werden. De gebruikte bronnen en studies zijn eveneens vermeld."]
[]
[null,null,"Sociale Media",null,null,null,null,null,null,null,"Email Marketing"]
[null,null,"Per sector heeft een expertgroep bepaald welke de ideale sociale media mix is en wat de gemiddelde tijdsbesteding per week is die daar bij hoort.\n\nEr wordt een setup kost berekend die beïnvloed wordt door de volgende parameters:\n - Uw huidige activiteiten op sociale media\n - Het aantal talen waarin u wenst te posten\n\nEr wordt een beheerskost berekend voor het eerste jaar die beïnvloed wordt door de volgende parameters:\n - Uw huidige activiteiten op sociale media\n - Het aantal talen waarin u wenst te posten\n - De frequentie waarmee u wenst te posten\n\nDe beheerskost wordt met een vast percentage verlaagd voor jaar 2 en 3. Daarnaast heeft het gebruik van sociale media een impact op de aanbreng van bezoekers door middel van marketing activiteiten.\n",null,null,null,null,null,null,null,"Per sector heeft een expertgroep een setupkost voor email marketing en de te spenderen tijd per email bepaald.\n\nEr wordt een setup kost berekend die beïnvloed wordt door de volgende parameters:\n - Uw huidige activiteit met email marketing\n - Het aantal talen waarin u wenst te emailen\n\nEr wordt een beheerskost berekend voor het eerste jaar die beïnvloed wordt door de volgende parameters:\n - Uw huidige activiteit met email marketing\n - Het aantal talen waarin u wenst te emailen\n - De frequentie waarmee u wenst te emailen\n\nDe beheerskost wordt met een vast percentage verlaagd voor jaar 2 en 3. De licentiekost wordt bepaald door de emailfrequentie toe te passen op de klantendatabase met een vaste kost per email. Daarnaast heeft het gebruik van email marketing een impact op de aanbreng van bezoekers door middel van marketing activiteiten.\n"]
[]
[null,null,"Content Marketing",null,null,null,null,null,null,null,"Klantenevolutie"]
[null,null,"Per sector heeft een expertgroep een setupkost voor een blog en de te spenderen tijd per blog post bepaald. \n\nEr wordt een setup kost berekend die beïnvloed wordt door de volgende parameters:\n - Uw huidige activiteit op een blog\n - Het aantal talen waarin u wenst te posten\n\nEr wordt een beheerskost berekend voor het eerste jaar die beïnvloed wordt door de volgende parameters:\n - Uw huidige activiteiten op een blog\n - Het aantal talen waarin u wenst te posten\n - De frequentie waarmee u wenst te posten\n\nDe beheerskost wordt met een vast percentage verlaagd voor jaar 2 en 3. Daarnaast heeft het gebruik van een blog een impact op de aanbreng van bezoekers door middel van marketing activiteiten.\n",null,null,null,null,null,null,null,"De klantenevolutie wordt bepaald door de volgende parameters:\n - uw initieel klantenbestand\n - de globale impact van uw geconfigureerde digitale marketing activiteiten op uw initieel klantenbestand\n - de impact van uw geconfigureerde digitale marketing activiteiten op niet-klanten\n - de evolutie van uw markt zoals gepercipiëerd door Comeos\n - uw online advertentiebudget gecombineerd met een sectorspecifieke cost-per-click."]
[]
[null,null,"Online advertentiebudget",null,null,null,null,null,null,null,"Marktplaatsen"]
[null,null,"Een gemiddelde Belgische CPC (cost-per-click) werd bepaald per sector op basis van diverse bronnen.",null,null,null,null,null,null,null,"De opgegeven omzet wordt, door middel van de commissie, uw marge en de abonnementskost, omgerekend naar een maandelijkse netto kost of opbrengst."]
[null,null,{"$f":"CONCATENATE(\"Voor uw sector hebben we rekening gehouden met een CPC van €\",VLOOKUP(VALUE(InputSector),SECTORDATA,22,0))","v":"Voor uw sector hebben we rekening gehouden met een CPC van €0,75"}]
[null,null,null,null,null,null,null,null,null,null,"Ontwikkelingsbudget"]
[null,null,null,null,null,null,null,null,null,null,"Het opgegeven ontwikkelingsbudget wordt in het koopmodel in maand 1 van jaar 1 opgenomen en in het huurmodel gespreid over de 3 jaren."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Uw financieel plan"]
[null,"Meer tips en inspiratie op www.hetinternetookuwzaak.be"]
[null,"Pagina 10 van 11"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uw financieel plan"]
[]
[null,null,"e-shop",null,null,null,null,null,null,null,"Bronnen"]
[null,null,"De e-shop resultaten worden berekend door uw bezoekers, mits een sector specifieke conversie, om te rekenen naar online aankopen. Op de weg van het eindresultaat worden de volgende zaken in berekend:\n - sector specifieke retour van online aankopen \n - sector specifieke marge\n - kost van online betalingen\n - kost van online productbeheer volgens uw parameters\n - kost van logistiek (behandeling van producten bij verkoop en retour, kostprijs verpakking, kostprijs verzenden en retour)",null,null,null,null,null,null,null,"De berekeningen in dit excel-document gebruiken informatie van de volgende bronnen: Comeos, Becommerce, E-commerce Europe, Google, Facebook, Amazon, E-bay, FOD economie."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Auteurs"]
[null,null,null,null,null,null,null,null,null,null,"Pascal Sabbe - www.ivisio.be"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Uw financieel plan"]
[null,"Meer tips en inspiratie op www.hetinternetookuwzaak.be"]
[null,"Pagina 11 van 11"]

{"sheet":"_grafieken","index":1,"n_rows":10,"n_cols":38,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[null,"cashflow"]
[null,null,{"$f":"'Uw dossier'!F255","v":"m1"},{"$f":"'Uw dossier'!G255","v":"m2"},{"$f":"'Uw dossier'!H255","v":"m3"},{"$f":"'Uw dossier'!I255","v":"m4"},{"$f":"'Uw dossier'!J255","v":"m5"},{"$f":"'Uw dossier'!K255","v":"m6"},{"$f":"'Uw dossier'!L255","v":"m7"},{"$f":"'Uw dossier'!M255","v":"m8"},{"$f":"'Uw dossier'!N255","v":"m9"},{"$f":"'Uw dossier'!O255","v":"m10"},{"$f":"'Uw dossier'!P255","v":"m11"},{"$f":"'Uw dossier'!Q255","v":"m12"},{"$f":"'Uw dossier'!F314","v":"m1"},{"$f":"'Uw dossier'!G314","v":"m2"},{"$f":"'Uw dossier'!H314","v":"m3"},{"$f":"'Uw dossier'!I314","v":"m4"},{"$f":"'Uw dossier'!J314","v":"m5"},{"$f":"'Uw dossier'!K314","v":"m6"},{"$f":"'Uw dossier'!L314","v":"m7"},{"$f":"'Uw dossier'!M314","v":"m8"},{"$f":"'Uw dossier'!N314","v":"m9"},{"$f":"'Uw dossier'!O314","v":"m10"},{"$f":"'Uw dossier'!P314","v":"m11"},{"$f":"'Uw dossier'!Q314","v":"m12"},{"$f":"'Uw dossier'!F373","v":"m1"},{"$f":"'Uw dossier'!G373","v":"m2"},{"$f":"'Uw dossier'!H373","v":"m3"},{"$f":"'Uw dossier'!I373","v":"m4"},{"$f":"'Uw dossier'!J373","v":"m5"},{"$f":"'Uw dossier'!K373","v":"m6"},{"$f":"'Uw dossier'!L373","v":"m7"},{"$f":"'Uw dossier'!M373","v":"m8"},{"$f":"'Uw dossier'!N373","v":"m9"},{"$f":"'Uw dossier'!O373","v":"m10"},{"$f":"'Uw dossier'!P373","v":"m11"},{"$f":"'Uw dossier'!Q373","v":"m12"}]
[null,"omzet",{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!F297,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!F292,0),0)","v":14093.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!G297,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!G292,0),0)","v":16836.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!H297,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!H292,0),0)","v":17095.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!I297,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!I292,0),0)","v":17370.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!J297,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!J292,0),0)","v":17630.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!K297,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!K292,0),0)","v":17869.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!L297,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!L292,0),0)","v":18143.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!M297,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!M292,0),0)","v":18435.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!N297,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!N292,0),0)","v":18711.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!O297,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!O292,0),0)","v":18981.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!P297,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!P292,0),0)","v":19273.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!Q297,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!Q292,0),0)","v":19579.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!F374,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!F351,0),0)","v":19972.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!G374,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!G351,0),0)","v":20279.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!H374,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!H351,0),0)","v":20568.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!I374,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!I351,0),0)","v":20894.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!J374,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!J351,0),0)","v":21197.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!K374,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!K351,0),0)","v":21536.92},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!L374,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!L351,0),0)","v":21842.92},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!M374,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!M351,0),0)","v":22146.92},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!N374,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!N351,0),0)","v":22502.92},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!O374,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!O351,0),0)","v":22838.92},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!P374,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!P351,0),0)","v":23158.92},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!Q374,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!Q351,0),0)","v":23495.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!F415,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!F410,0),0)","v":23846.92},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!G415,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!G410,0),0)","v":24233.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!H415,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!H410,0),0)","v":24586.92},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!I415,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!I410,0),0)","v":24953.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!J415,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!J410,0),0)","v":25320.92},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!K415,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!K410,0),0)","v":25705.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!L415,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!L410,0),0)","v":26052.92},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!M415,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!M410,0),0)","v":26436.92},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!N415,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!N410,0),0)","v":26836.92},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!O415,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!O410,0),0)","v":27250.92},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!P415,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!P410,0),0)","v":27649.919999999998},{"$f":"IF(InputIncludeMarkt=1,'Uw dossier'!Q415,0)+IF(InputIncludeSiteShop=1,IF(InputSiteShop=2,'Uw dossier'!Q410,0),0)","v":28045.919999999998}]
[null,"kosten",{"$f":"-'Uw dossier'!F278-'Uw dossier'!F272-'Uw dossier'!F268-'Uw dossier'!F264-'Uw dossier'!F259","v":-27168.190300000002},{"$f":"-'Uw dossier'!G278-'Uw dossier'!G272-'Uw dossier'!G268-'Uw dossier'!G264-'Uw dossier'!G259","v":-2692.5382076572923},{"$f":"-'Uw dossier'!H278-'Uw dossier'!H272-'Uw dossier'!H268-'Uw dossier'!H264-'Uw dossier'!H259","v":-2695.5507891232292},{"$f":"-'Uw dossier'!I278-'Uw dossier'!I272-'Uw dossier'!I268-'Uw dossier'!I264-'Uw dossier'!I259","v":-2698.6059169062855},{"$f":"-'Uw dossier'!J278-'Uw dossier'!J272-'Uw dossier'!J268-'Uw dossier'!J264-'Uw dossier'!J259","v":-2701.70419188286},{"$f":"-'Uw dossier'!K278-'Uw dossier'!K272-'Uw dossier'!K268-'Uw dossier'!K264-'Uw dossier'!K259","v":-2704.8462234154522},{"$f":"-'Uw dossier'!L278-'Uw dossier'!L272-'Uw dossier'!L268-'Uw dossier'!L264-'Uw dossier'!L259","v":-2708.0326294725173},{"$f":"-'Uw dossier'!M278-'Uw dossier'!M272-'Uw dossier'!M268-'Uw dossier'!M264-'Uw dossier'!M259","v":-2711.2640367500007},{"$f":"-'Uw dossier'!N278-'Uw dossier'!N272-'Uw dossier'!N268-'Uw dossier'!N264-'Uw dossier'!N259","v":-2714.5410807945964},{"$f":"-'Uw dossier'!O278-'Uw dossier'!O272-'Uw dossier'!O268-'Uw dossier'!O264-'Uw dossier'!O259","v":-2717.8644061287478},{"$f":"-'Uw dossier'!P278-'Uw dossier'!P272-'Uw dossier'!P268-'Uw dossier'!P264-'Uw dossier'!P259","v":-2721.2346663774088},{"$f":"-'Uw dossier'!Q278-'Uw dossier'!Q272-'Uw dossier'!Q268-'Uw dossier'!Q264-'Uw dossier'!Q259","v":-2724.6525243965989},{"$f":"-'Uw dossier'!F318-'Uw dossier'!F323-'Uw dossier'!F327-'Uw dossier'!F331-'Uw dossier'!F337","v":-5997.7106924037689},{"$f":"-'Uw dossier'!G318-'Uw dossier'!G323-'Uw dossier'!G327-'Uw dossier'!G331-'Uw dossier'!G337","v":-2642.2587321100191},{"$f":"-'Uw dossier'!H318-'Uw dossier'!H323-'Uw dossier'!H327-'Uw dossier'!H331-'Uw dossier'!H337","v":-2645.8234548541659},{"$f":"-'Uw dossier'!I318-'Uw dossier'!I323-'Uw dossier'!I327-'Uw dossier'!I331-'Uw dossier'!I337","v":-2649.4385217387216},{"$f":"-'Uw dossier'!J318-'Uw dossier'!J323-'Uw dossier'!J327-'Uw dossier'!J331-'Uw dossier'!J337","v":-2653.1046437677824},{"$f":"-'Uw dossier'!K318-'Uw dossier'!K323-'Uw dossier'!K327-'Uw dossier'!K331-'Uw dossier'!K337","v":-2656.8225419868686},{"$f":"-'Uw dossier'!L318-'Uw dossier'!L323-'Uw dossier'!L327-'Uw dossier'!L331-'Uw dossier'!L337","v":-2660.5929476247366},{"$f":"-'Uw dossier'!M318-'Uw dossier'!M323-'Uw dossier'!M327-'Uw dossier'!M331-'Uw dossier'!M337","v":-2664.4166022371974},{"$f":"-'Uw dossier'!N318-'Uw dossier'!N323-'Uw dossier'!N327-'Uw dossier'!N331-'Uw dossier'!N337","v":-2668.2942578529619},{"$f":"-'Uw dossier'!O318-'Uw dossier'!O323-'Uw dossier'!O327-'Uw dossier'!O331-'Uw dossier'!O337","v":-2672.2266771215518},{"$f":"-'Uw dossier'!P318-'Uw dossier'!P323-'Uw dossier'!P327-'Uw dossier'!P331-'Uw dossier'!P337","v":-2676.2146334632935},{"$f":"-'Uw dossier'!Q318-'Uw dossier'!Q323-'Uw dossier'!Q327-'Uw dossier'!Q331-'Uw dossier'!Q337","v":-2680.2589112214318},{"$f":"-'Uw dossier'!F377-'Uw dossier'!F382-'Uw dossier'!F386-'Uw dossier'!F390-'Uw dossier'!F396","v":-4923.671665816395},{"$f":"-'Uw dossier'!G377-'Uw dossier'!G382-'Uw dossier'!G386-'Uw dossier'!G390-'Uw dossier'!G396","v":-2688.5196239022416},{"$f":"-'Uw dossier'!H377-'Uw dossier'!H382-'Uw dossier'!H386-'Uw dossier'!H390-'Uw dossier'!H396","v":-2692.7376835252976},{"$f":"-'Uw dossier'!I377-'Uw dossier'!I382-'Uw dossier'!I386-'Uw dossier'!I390-'Uw dossier'!I396","v":-2697.0153142850613},{"$f":"-'Uw dossier'!J377-'Uw dossier'!J382-'Uw dossier'!J386-'Uw dossier'!J390-'Uw dossier'!J396","v":-2701.3533574973617},{"$f":"-'Uw dossier'!K377-'Uw dossier'!K382-'Uw dossier'!K386-'Uw dossier'!K390-'Uw dossier'!K396","v":-2705.7526663598278},{"$f":"-'Uw dossier'!L377-'Uw dossier'!L382-'Uw dossier'!L386-'Uw dossier'!L390-'Uw dossier'!L396","v":-2710.2141061196935},{"$f":"-'Uw dossier'!M377-'Uw dossier'!M382-'Uw dossier'!M386-'Uw dossier'!M390-'Uw dossier'!M396","v":-2714.7385542439733},{"$f":"-'Uw dossier'!N377-'Uw dossier'!N382-'Uw dossier'!N386-'Uw dossier'!N390-'Uw dossier'!N396","v":-2719.3269005920397},{"$f":"-'Uw dossier'!O377-'Uw dossier'!O382-'Uw dossier'!O386-'Uw dossier'!O390-'Uw dossier'!O396","v":-2723.9800475906395},{"$f":"-'Uw dossier'!P377-'Uw dossier'!P382-'Uw dossier'!P386-'Uw dossier'!P390-'Uw dossier'!P396","v":-2728.6989104113818},{"$f":"-'Uw dossier'!Q377-'Uw dossier'!Q382-'Uw dossier'!Q386-'Uw dossier'!Q390-'Uw dossier'!Q396","v":-2733.4844171507311}]
[null,"netto",{"$f":"'Uw dossier'!F299","v":-13074.270300000004},{"$f":"'Uw dossier'!G299","v":14144.381792342707},{"$f":"'Uw dossier'!H299","v":14400.369210876772},{"$f":"'Uw dossier'!I299","v":14672.314083093715},{"$f":"'Uw dossier'!J299","v":14929.21580811714},{"$f":"'Uw dossier'!K299","v":15165.07377658455},{"$f":"'Uw dossier'!L299","v":15435.887370527484},{"$f":"'Uw dossier'!M299","v":15724.655963250001},{"$f":"'Uw dossier'!N299","v":15997.378919205405},{"$f":"'Uw dossier'!O299","v":16264.055593871251},{"$f":"'Uw dossier'!P299","v":16552.685333622594},{"$f":"'Uw dossier'!Q299","v":16855.267475603403},{"$f":"'Uw dossier'!F358","v":13975.209307596231},{"$f":"'Uw dossier'!G358","v":17637.661267889984},{"$f":"'Uw dossier'!H358","v":17923.096545145836},{"$f":"'Uw dossier'!I358","v":18245.481478261281},{"$f":"'Uw dossier'!J358","v":18544.815356232219},{"$f":"'Uw dossier'!K358","v":18880.097458013133},{"$f":"'Uw dossier'!L358","v":19182.327052375265},{"$f":"'Uw dossier'!M358","v":19482.503397762805},{"$f":"'Uw dossier'!N358","v":19834.62574214704},{"$f":"'Uw dossier'!O358","v":20166.693322878451},{"$f":"'Uw dossier'!P358","v":20482.705366536709},{"$f":"'Uw dossier'!Q358","v":20815.661088778572},{"$f":"'Uw dossier'!F417","v":18923.248334183605},{"$f":"'Uw dossier'!G417","v":21545.400376097761},{"$f":"'Uw dossier'!H417","v":21894.182316474704},{"$f":"'Uw dossier'!I417","v":22256.904685714941},{"$f":"'Uw dossier'!J417","v":22619.566642502639},{"$f":"'Uw dossier'!K417","v":23000.167333640176},{"$f":"'Uw dossier'!L417","v":23342.705893880309},{"$f":"'Uw dossier'!M417","v":23722.181445756029},{"$f":"'Uw dossier'!N417","v":24117.593099407964},{"$f":"'Uw dossier'!O417","v":24526.939952409364},{"$f":"'Uw dossier'!P417","v":24921.22108958862},{"$f":"'Uw dossier'!Q417","v":25312.43558284927}]
[null,"cashflow",{"$f":"C5","v":-13074.270300000004},{"$f":"C6+D5","v":1070.1114923427031},{"$f":"D6+E5","v":15470.480703219475},30142.794786313192,45072.010594430336,60237.084371014884,75672.971741542366,91397.627704792365,107395.00662399778,123659.06221786902,140211.74755149163,157067.01502709504,171042.22433469127,188679.88560258126,206602.9821477271,224848.4636259884,243393.27898222063,262273.37644023378,281455.70349260903,300938.20689037186,320772.8326325189,340939.52595539734,361422.23132193403,382237.89241071261,401161.1407448962,422706.54112099396,444600.72343746864,466857.62812318356,489477.19476568617,512477.36209932633,535820.06799320667,559542.24943896267,583659.84253837063,608186.78249077999,633108.00358036859,658420.4391632179]
[]
[null,"klanten"]
[null,null,"m1","m2","m3","m4","m5","m6","m7","m8","m9","m10","m11","m12","m1","m2","m3","m4","m5","m6","m7","m8","m9","m10","m11","m12","m1","m2","m3","m4","m5","m6","m7","m8","m9","m10","m11","m12"]
[null,null,{"$f":"'Uw dossier'!F280","v":7500},{"$f":"'Uw dossier'!G280","v":7614.2549098958334},{"$f":"'Uw dossier'!H280","v":7730.1234278164902},{"$f":"'Uw dossier'!I280","v":7847.6283425494285},{"$f":"'Uw dossier'!J280","v":7966.7927647253482},{"$f":"'Uw dossier'!K280","v":8087.6401313635388},{"$f":"'Uw dossier'!L280","v":8210.1942104814279},{"$f":"'Uw dossier'!M280","v":8334.4791057692291},{"$f":"'Uw dossier'!N280","v":8460.5192613306008},{"$f":"'Uw dossier'!O280","v":8588.3394664902717},{"$f":"'Uw dossier'!P280","v":8717.96486066955},{"$f":"'Uw dossier'!Q280","v":8849.4209383306952},{"$f":"'Uw dossier'!F339","v":8982.7335539911201},{"$f":"'Uw dossier'!G339","v":9117.9289273084014},{"$f":"'Uw dossier'!H339","v":9255.0336482371131},{"$f":"'Uw dossier'!I339","v":9394.0746822584806},{"$f":"'Uw dossier'!J339","v":9535.0793756839048},{"$f":"'Uw dossier'!K339","v":9678.0754610333734},{"$f":"'Uw dossier'!L339","v":9823.0910624898406},{"$f":"'Uw dossier'!M339","v":9970.1547014306307},{"$f":"'Uw dossier'!N339","v":10119.295302036971},{"$f":"'Uw dossier'!O339","v":10270.542196982738},{"$f":"'Uw dossier'!P339","v":10423.925133203551},{"$f":"'Uw dossier'!Q339","v":10579.474277747337},{"$f":"'Uw dossier'!F398","v":10737.220223707525},{"$f":"'Uw dossier'!G398","v":10897.193996240039},{"$f":"'Uw dossier'!H398","v":11059.42705866526},{"$f":"'Uw dossier'!I398","v":11223.951318656167},{"$f":"'Uw dossier'!J398","v":11390.799134513876},{"$f":"'Uw dossier'!K398","v":11560.003321531805},{"$f":"'Uw dossier'!L398","v":11731.597158449724},{"$f":"'Uw dossier'!M398","v":11905.614393998943},{"$f":"'Uw dossier'!N398","v":12082.089253539951},{"$f":"'Uw dossier'!O398","v":12261.056445793789},{"$f":"'Uw dossier'!P398","v":12442.551169668493},{"$f":"'Uw dossier'!Q398","v":12626.609121181942}]

{"sheet":"_datasheet","index":2,"n_rows":114,"n_cols":5,"rows_kept":114,"cut":false,"hidden":true,"merged":[[79,4,79,5],[73,7,73,8],[79,7,79,8],[54,7,54,8],[73,1,73,2],[79,1,79,2],[73,4,73,5],[61,1,61,2],[68,1,68,2],[1,1,1,9],[2,1,2,9],[3,1,3,9],[4,1,4,9],[5,1,5,9],[6,1,6,9],[7,1,7,9],[9,1,9,2],[9,4,9,5],[54,1,54,2],[54,4,54,5],[32,4,32,5],[32,7,32,8],[27,1,27,2],[33,1,33,2],[47,1,47,2],[39,4,39,5],[39,7,39,8],[40,1,40,2],[115,1,115,2],[86,1,86,2],[91,1,91,2],[98,1,98,2],[103,1,103,2],[110,1,110,2]]}
[]
[null,"*****************************************************************************"]
[null,"*                                                                                                                                                                               *"]
[null,"*                                            Gelieve geen wijzigingen aan te brengen                                               *"]
[null,"*                                                                                                                                                                               *"]
[null,"*                                                        Alle rechten voorbehouden                                                              *"]
[null,"*                                                                                                                                                                               *"]
[null,"*****************************************************************************"]
[]
[null,"Sector",null,null,"Gebaseerd op Comeos"]
[null,"Boeken & E-boeken",1]
[null,"Entertainment",2]
[null,"Computer & Electronica",3]
[null,"Doe-het-zelf & Tuin",4]
[null,"Reizen & Ontspanning",5]
[null,"Financiële producten",6]
[null,"Voertuigen",7]
[null,"Dieren",8]
[null,"Huis & Interieur",9]
[null,"Mode",10]
[null,"Schoonheid & Gezondheid",11]
[null,"Speelgoed & Hobbies",12]
[null,"Sportartikelen",13]
[null,"Telecom ",14]
[null,"Voeding ",15]
[null,"Overige",16]
[]
[null,"Turnover"]
[null,"< €100.000",1]
[null,"€100.000 … €250.000",2]
[null,"€250.000 … €500.000",3]
[null,"> €500.000",4]
[]
[null,"Customer"]
[null,"Geen",1]
[null,"< 250",2]
[null,"250 … 1.000",3]
[null,"1.000 … 5.000",4]
[null,"> 5.000",5]
[]
[null,"Customer visits per month"]
[null,1,{"$f":"50*2","v":100}]
[null,2]
[null,3]
[null,4]
[null,5]
[]
[null,"Customer count"]
[null,1,50]
[null,2,250]
[null,3,1000]
[null,4,2500]
[null,5,7500]
[]
[null,"CCOP 2017"]
[null,"SPECIAL",1.25]
[null,"NO_VOLUME",0.5]
[null,"VOLUME",1.5]
[null,"NICHE",0.75]
[null,"NEUTRAL",1]
[]
[null,"CFOP"]
[null,"NEUTRAL",1]
[null,"STABLE",1.1000000000000001]
[null,"BOOMING",1.25]
[null,"POTENTIAL",1.1000000000000001]
[null,"LATENT",0.75]
[]
[null,"COMPETITION"]
[null,"NEUTRAL",1]
[null,"HIGH",0.75]
[null,"LOW",1.25]
[]
[null,"Sociale Media"]
[null,"Niet actief",1]
[null,"Aanwezig maar geen actief gebruik",2]
[null,"Aanwezig en actief gebruik",3]
[null,"Aanwezig en zowel actief als proactief gebruik",4]
[]
[null,"Sociale Media Priority"]
[null,"Elke dag",1]
[null,"Meerdere keren per week",2]
[null,"Elke week",3]
[null,"Meerdere keren per maand",4]
[null,"Elke maand",5]
[]
[null,"Email marketing"]
[null,"Niet actief",1]
[null,"Af en toe van eigen email adres",2]
[null,"Actief met een email platform",3]
[]
[null,"Email marketing frequency"]
[null,"Elke week",1]
[null,"Elke 2 weken",2]
[null,"Elke maand",3]
[null,"Elke 3 maanden",4]
[null,"Elke 6 maanden",5]
[]
[null,"Blog"]
[null,"Niet actief",1]
[null,"Er is een blog maar die wordt weinig actief gebruikt",2]
[null,"Actief gebruik",3]
[]
[null,"Blog frequency"]
[null,"Elke week",1]
[null,"Elke 2 weken",2]
[null,"Elke maand",3]
[null,"Elke 3 maanden",4]
[null,"Elke 6 maanden",5]
[]
[null,"Product Range"]
[null,100,1]
[null,1000,2]
[null,99999999,3]

{"sheet":"_sector_data","index":3,"n_rows":22,"n_cols":65,"rows_kept":22,"cut":false,"hidden":true,"merged":[[2,1,2,2],[1,41,1,52],[1,53,1,64],[1,3,1,28],[1,29,1,40]]}
[]
[null,null,null,"E-commerce",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,"SOCIAL MEDIA",null,null,null,null,null,null,null,null,null,null,null,"EMAIL MARKETING",null,null,null,null,null,null,null,null,null,null,null,"CONTENT MARKETING"]
[null,"Sector",null,"Def. Conv.","User Conv.","Act. Conv","Def. Order Value","User Order Value","Act. Order Value","Def. Retour","User Retour","Act. Retour","Def. Payment","User Payment","Actual Payment","handling","packaging","User Handle","Act. Handle","Def. shipment","User Shipment","Act. Shipment","Av. CPC","Av. CTR","Av. Aff. Cost","ord/cust","CCOP","CFOP","COMPETITION","Base Setup ","Formula","Act. Setup","Setup Cost","Base Mngt ","Formula","Act. Mngt Y1","Act. Mngt Cost Y1","Base Mngt ","Formula ","Act. Mngt ","Act. Mngt Cost Y2/3","Base Setup ","Formula ","Act. Setup ","Setup Cost","Base Mngt ","Formula ","Act. Mngt ","Act. Mngt Cost Y1","Base Mngt","Formula ","Actual Mngt ","Act. Mngt Cost Y2/3","Base Setup ","Formula ","Act. Setup ","Act. Setup Cost","Base Mngt ","Formula ","Act. Mngt ","Act. Mngt Cost Y1","Base Mngt ","Formula ","Actual Mngt ","Act. Mngt Cost Y2/3"]
[null,1,"Boeken & E-boeken",2.86E-2,{"$f":"IF(LEN(PersonaliseConversion)>0,VALUE(PersonaliseConversion)/100,\"\")","v":""},{"$f":"IF(LEN(E4)>0,E4,D4)","v":2.86E-2},34,{"$f":"IF(LEN(PersonaliseOrderValue)>0,VALUE(PersonaliseOrderValue),\"\")","v":""},{"$f":"IF(LEN(H4)>0,H4,G4)","v":34},0.13,{"$f":"IF(LEN(PersonaliseRetour)>0,VALUE(PersonaliseRetour)/100,\"\")","v":""},{"$f":"IF(LEN(K4)>0,K4,J4)","v":0.13},1.4999999999999999E-2,{"$f":"IF(LEN(PersonalisePayment)>0,VALUE(PersonalisePayment)/100,\"\")","v":""},{"$f":"IF(LEN(N4)>0,N4,M4)","v":1.4999999999999999E-2},2,1.5,{"$f":"IF(LEN(PersonaliseHandle)>0,VALUE(PersonaliseHandle),\"\")","v":""},{"$f":"IF(LEN(R4)>0,R4,P4+Q4)","v":3.5},3.87,{"$f":"IF(LEN(PersonaliseShipment)>0,VALUE(PersonaliseShipment),\"\")","v":""},{"$f":"IF(LEN(U4)>0,U4,T4)","v":3.87},0.75,0.05,0.15,4.84,"VOLUME","BOOMING","NEUTRAL",6,{"$f":"VALUE(FormuleSocialSetup)","v":4.5287423999999996},{"$f":"AD4*AE4","v":27.172454399999999},{"$f":"AF4*VALUE(InputSocialRate)","v":1358.6227200000001},3,{"$f":"VALUE(FormuleSocialManagement)","v":2.1258732000000009},{"$f":"AH4*AI4","v":6.3776196000000027},{"$f":"AJ4*VALUE(InputSocialRate)","v":318.88098000000014},3,{"$f":"VALUE(FormuleSocialManagementY2)","v":2.1258732000000009},{"$f":"AL4*AM4","v":6.3776196000000027},{"$f":"AN4*VALUE(InputSocialRate)","v":318.88098000000014},8,{"$f":"VALUE(FormuleEmailSetup)","v":1.3},{"$f":"AP4*AQ4","v":10.4},{"$f":"AR4*VALUE(InputEmailRate)","v":520},2.5,{"$f":"VALUE(FormuleEmailManagement)","v":0.77},{"$f":"AT4*AU4","v":1.925},{"$f":"AV4*VALUE(InputEmailRate)","v":96.25},2.5,{"$f":"VALUE(FormuleEmailManagementY2)","v":0.60500000000000009},{"$f":"AX4*AY4","v":1.5125000000000002},{"$f":"AZ4*VALUE(InputEmailRate)","v":75.625000000000014},40,{"$f":"VALUE(FormuleBlogSetup)","v":1.3},{"$f":"BB4*BC4","v":52},{"$f":"BD4*VALUE(InputBlogRate)","v":2600},2,{"$f":"VALUE(FormuleBlogManagement)","v":0.35538461538461541},{"$f":"BF4*BG4","v":0.71076923076923082},{"$f":"BH4*VALUE(InputBlogRate)","v":35.53846153846154},2,{"$f":"VALUE(FormuleBlogManagementY2)","v":0.35538461538461541},{"$f":"BJ4*BK4","v":0.71076923076923082},{"$f":"BL4*VALUE(InputBlogRate)","v":35.53846153846154}]
[null,2,"Entertainment",0.03,"",{"$f":"IF(LEN(E5)>0,E5,D5)","v":0.03},43,"",{"$f":"IF(LEN(H5)>0,H5,G5)","v":43},0.09,"",{"$f":"IF(LEN(K5)>0,K5,J5)","v":0.09},1.4999999999999999E-2,"",{"$f":"IF(LEN(N5)>0,N5,M5)","v":1.4999999999999999E-2},2,1.5,"",{"$f":"IF(LEN(R5)>0,R5,P5+Q5)","v":3.5},3.87,"",{"$f":"IF(LEN(U5)>0,U5,T5)","v":3.87},0.75,0.05,0.15,5.09,"BOOMING","BOOMING","NEUTRAL",6,4.5287423999999996,27.172454399999999,1358.6227200000001,3,2.1258732000000009,{"$f":"AH5*AI5","v":6.3776196000000027},318.88098000000014,3,2.1258732000000009,{"$f":"AL5*AM5","v":6.3776196000000027},318.88098000000014,8,1.3,10.4,520,2.5,0.77,{"$f":"AT5*AU5","v":1.925},96.25,2.5,0.60500000000000009,{"$f":"AX5*AY5","v":1.5125000000000002},75.625000000000014,40,1.3,52,2600,2,0.35538461538461541,{"$f":"BF5*BG5","v":0.71076923076923082},35.53846153846154,2,0.35538461538461541,{"$f":"BJ5*BK5","v":0.71076923076923082},35.53846153846154]
[null,3,"Computer & Electronica",0.05,"",0.05,269,"",269,0.1,"",0.1,1.4999999999999999E-2,"",1.4999999999999999E-2,3,2,"",5,3.87,"",3.87,0.75,0.05,0.05,2.2400000000000002,"SPECIAL","STABLE","NEUTRAL",6,4.5287423999999996,27.172454399999999,1358.6227200000001,3,2.1258732000000009,6.3776196000000027,318.88098000000014,3,2.1258732000000009,6.3776196000000027,318.88098000000014,8,1.3,10.4,520,2.5,0.77,1.925,96.25,2.5,0.60500000000000009,1.5125000000000002,75.625000000000014,40,1.3,52,2600,2,0.35538461538461541,0.71076923076923082,35.53846153846154,2,0.35538461538461541,0.71076923076923082,35.53846153846154]
[null,4,"Doe-het-zelf & Tuin",0.03,"",0.03,147,"",147,7.0000000000000007E-2,"",7.0000000000000007E-2,1.4999999999999999E-2,"",1.4999999999999999E-2,4,2,"",6,5.87,"",5.87,0.75,0.05,0.12,2.68,"NO_VOLUME","LATENT","NEUTRAL",12,4.5287423999999996,54.344908799999999,2717.2454400000001,4,2.1258732000000009,8.5034928000000036,425.17464000000018,4,2.1258732000000009,8.5034928000000036,425.17464000000018,8,1.3,10.4,520,2.5,0.77,1.925,96.25,2.5,0.60500000000000009,1.5125000000000002,75.625000000000014,40,1.3,52,2600,2,0.35538461538461541,0.71076923076923082,35.53846153846154,2,0.35538461538461541,0.71076923076923082,35.53846153846154]
[null,5,"Reizen & Ontspanning",0.04,"",0.04,316,"",316,0.04,"",0.04,1.4999999999999999E-2,"",1.4999999999999999E-2,1,2,"",3,4.87,"",4.87,0.75,0.05,0.12,3.17,"SPECIAL","NEUTRAL","NEUTRAL",12,4.5287423999999996,54.344908799999999,2717.2454400000001,4,2.1258732000000009,8.5034928000000036,425.17464000000018,4,2.1258732000000009,8.5034928000000036,425.17464000000018,8,1.3,10.4,520,2.5,0.77,1.925,96.25,2.5,0.60500000000000009,1.5125000000000002,75.625000000000014,40,1.3,52,2600,2,0.35538461538461541,0.71076923076923082,35.53846153846154,2,0.35538461538461541,0.71076923076923082,35.53846153846154]
[null,6,"Financiële producten",0.1,"",0.1,60.84,"",60.84,0.06,"",0.06,1.4999999999999999E-2,"",1.4999999999999999E-2,0,0,"",0,0,"",0,0.75,0.05,0.15,3.21,"NO_VOLUME","NEUTRAL","NEUTRAL",6,4.5287423999999996,27.172454399999999,1358.6227200000001,3,2.1258732000000009,6.3776196000000027,318.88098000000014,3,2.1258732000000009,6.3776196000000027,318.88098000000014,8,1.3,10.4,520,2.5,0.77,1.925,96.25,2.5,0.60500000000000009,1.5125000000000002,75.625000000000014,40,1.3,52,2600,2,0.35538461538461541,0.71076923076923082,35.53846153846154,2,0.35538461538461541,0.71076923076923082,35.53846153846154]
[null,7,"Voertuigen",0.03,"",0.03,113.88,"",113.88,0.11,"",0.11,1.4999999999999999E-2,"",1.4999999999999999E-2,4,2,"",6,3.87,"",3.87,0.75,0.05,0.15,2.34,"NO_VOLUME","NEUTRAL","NEUTRAL",12,4.5287423999999996,54.344908799999999,2717.2454400000001,4,2.1258732000000009,8.5034928000000036,425.17464000000018,4,2.1258732000000009,8.5034928000000036,425.17464000000018,8,1.3,10.4,520,2.5,0.77,1.925,96.25,2.5,0.60500000000000009,1.5125000000000002,75.625000000000014,40,1.3,52,2600,2,0.35538461538461541,0.71076923076923082,35.53846153846154,2,0.35538461538461541,0.71076923076923082,35.53846153846154]
[null,8,"Dieren",0.03,"",0.03,83,"",83,0.08,"",0.08,1.4999999999999999E-2,"",1.4999999999999999E-2,4,2,"",6,4.87,"",4.87,0.75,0.05,7.0000000000000007E-2,4.33,"NICHE","NEUTRAL","NEUTRAL",12,4.5287423999999996,54.344908799999999,2717.2454400000001,4,2.1258732000000009,8.5034928000000036,425.17464000000018,4,2.1258732000000009,8.5034928000000036,425.17464000000018,8,1.3,10.4,520,2.5,0.77,1.925,96.25,2.5,0.60500000000000009,1.5125000000000002,75.625000000000014,40,1.3,52,2600,2,0.35538461538461541,0.71076923076923082,35.53846153846154,2,0.35538461538461541,0.71076923076923082,35.53846153846154]
[null,9,"Huis & Interieur",0.03,"",0.03,142,"",142,0.1,"",0.1,1.4999999999999999E-2,"",1.4999999999999999E-2,5,5,"",10,3.87,"",3.87,0.75,0.05,0.12,2.16,"NO_VOLUME","LATENT","NEUTRAL",6,4.5287423999999996,27.172454399999999,1358.6227200000001,4,2.1258732000000009,8.5034928000000036,425.17464000000018,4,2.1258732000000009,8.5034928000000036,425.17464000000018,8,1.3,10.4,520,2.5,0.77,1.925,96.25,2.5,0.60500000000000009,1.5125000000000002,75.625000000000014,40,1.3,52,2600,2,0.35538461538461541,0.71076923076923082,35.53846153846154,2,0.35538461538461541,0.71076923076923082,35.53846153846154]
[null,10,"Mode",0.03,"",0.03,74,"",74,0.28999999999999998,"",0.28999999999999998,1.4999999999999999E-2,"",1.4999999999999999E-2,3,1.5,"",4.5,3.87,"",3.87,0.75,0.05,0.15,3.43,"SPECIAL","STABLE","NEUTRAL",6,4.5287423999999996,27.172454399999999,1358.6227200000001,3,2.1258732000000009,6.3776196000000027,318.88098000000014,3,2.1258732000000009,6.3776196000000027,318.88098000000014,8,1.3,10.4,520,2.5,0.77,1.925,96.25,2.5,0.60500000000000009,1.5125000000000002,75.625000000000014,40,1.3,52,2600,2,0.35538461538461541,0.71076923076923082,35.53846153846154,2,0.35538461538461541,0.71076923076923082,35.53846153846154]
[null,11,"Schoonheid & Gezondheid",0.03,"",0.03,58,"",58,7.0000000000000007E-2,"",7.0000000000000007E-2,1.4999999999999999E-2,"",1.4999999999999999E-2,2,1.5,"",3.5,3.87,"",3.87,0.75,0.05,0.15,3.7,"SPECIAL","BOOMING","NEUTRAL",6,4.5287423999999996,27.172454399999999,1358.6227200000001,3,2.1258732000000009,{"$f":"AH14*AI14","v":6.3776196000000027},318.88098000000014,3,2.1258732000000009,{"$f":"AL14*AM14","v":6.3776196000000027},318.88098000000014,8,1.3,10.4,520,2.5,0.77,{"$f":"AT14*AU14","v":1.925},96.25,2.5,0.60500000000000009,{"$f":"AX14*AY14","v":1.5125000000000002},75.625000000000014,40,1.3,52,2600,2,0.35538461538461541,{"$f":"BF14*BG14","v":0.71076923076923082},35.53846153846154,2,0.35538461538461541,{"$f":"BJ14*BK14","v":0.71076923076923082},35.53846153846154]
[null,12,"Speelgoed & Hobbies",0.03,"",0.03,84,"",84,0.1,"",0.1,1.4999999999999999E-2,"",1.4999999999999999E-2,3,1.5,"",4.5,3.87,"",3.87,0.75,0.05,0.15,2.94,"NO_VOLUME","BOOMING","NEUTRAL",6,4.5287423999999996,27.172454399999999,1358.6227200000001,3,2.1258732000000009,6.3776196000000027,318.88098000000014,3,2.1258732000000009,6.3776196000000027,318.88098000000014,8,1.3,10.4,520,2.5,0.77,1.925,96.25,2.5,0.60500000000000009,1.5125000000000002,75.625000000000014,40,1.3,52,2600,2,0.35538461538461541,0.71076923076923082,35.53846153846154,2,0.35538461538461541,0.71076923076923082,35.53846153846154]
[null,13,"Sportartikelen",0.03,"",0.03,87,"",87,0.16,"",0.16,1.4999999999999999E-2,"",1.4999999999999999E-2,3,2,"",5,3.87,"",3.87,0.64,0.05,0.15,2.4500000000000002,"NO_VOLUME","POTENTIAL","NEUTRAL",9,4.5287423999999996,40.758681599999996,2037.9340799999998,4,2.1258732000000009,8.5034928000000036,425.17464000000018,4,2.1258732000000009,8.5034928000000036,425.17464000000018,8,1.3,10.4,520,2.5,0.77,1.925,96.25,2.5,0.60500000000000009,1.5125000000000002,75.625000000000014,40,1.3,52,2600,2,0.35538461538461541,0.71076923076923082,35.53846153846154,2,0.35538461538461541,0.71076923076923082,35.53846153846154]
[null,14,"Telecom ",0.03,"",0.03,64,"",64,7.0000000000000007E-2,"",7.0000000000000007E-2,1.4999999999999999E-2,"",1.4999999999999999E-2,1,1.5,"",2.5,3.87,"",3.87,0.75,0.05,7.0000000000000007E-2,4.6100000000000003,"NICHE","POTENTIAL","NEUTRAL",6,4.5287423999999996,27.172454399999999,1358.6227200000001,3,2.1258732000000009,6.3776196000000027,318.88098000000014,3,2.1258732000000009,6.3776196000000027,318.88098000000014,8,1.3,10.4,520,2.5,0.77,1.925,96.25,2.5,0.60500000000000009,1.5125000000000002,75.625000000000014,40,1.3,52,2600,2,0.35538461538461541,0.71076923076923082,35.53846153846154,2,0.35538461538461541,0.71076923076923082,35.53846153846154]
[null,15,"Voeding ",0.03,"",0.03,71,"",71,7.0000000000000007E-2,"",7.0000000000000007E-2,1.4999999999999999E-2,"",1.4999999999999999E-2,7,4,"",11,3.87,"",3.87,0.75,0.05,0.15,7.87,"NICHE","POTENTIAL","NEUTRAL",9,4.5287423999999996,40.758681599999996,2037.9340799999998,4,2.1258732000000009,8.5034928000000036,425.17464000000018,4,2.1258732000000009,8.5034928000000036,425.17464000000018,8,1.3,10.4,520,2.5,0.77,1.925,96.25,2.5,0.60500000000000009,1.5125000000000002,75.625000000000014,40,1.3,52,2600,2,0.35538461538461541,0.71076923076923082,35.53846153846154,2,0.35538461538461541,0.71076923076923082,35.53846153846154]
[null,16,"Overige",0.03,"",0.03,50,"",50,0.1,"",0.1,1.4999999999999999E-2,"",1.4999999999999999E-2,3,2,"",5,3.87,"",3.87,0.75,0.05,0.18,2,"NEUTRAL","NEUTRAL","NEUTRAL",6,4.5287423999999996,27.172454399999999,1358.6227200000001,3,2.1258732000000009,6.3776196000000027,318.88098000000014,3,2.1258732000000009,6.3776196000000027,318.88098000000014,8,1.3,10.4,520,2.5,0.77,1.925,96.25,2.5,0.60500000000000009,1.5125000000000002,75.625000000000014,40,1.3,52,2600,2,0.35538461538461541,0.71076923076923082,35.53846153846154,2,0.35538461538461541,0.71076923076923082,35.53846153846154]
[]
[]
[null,null,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64]

{"sheet":"_sector_formules","index":4,"n_rows":441,"n_cols":7,"rows_kept":441,"cut":false,"hidden":true,"merged":[]}
[]
["Calculate impact of user provided information on Social Media cost"]
[]
[null,"x) Use of Social Media"]
[null,"Is social media in scope?"]
[]
[null,null,"Include","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,0,0,0,0,"(exclude)"]
[null,null,1,1,1,1,"(include)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(VALUE(InputIncludeSocial),C8:F9,2,0)","v":1}]
[null,"Impact on Management",{"$f":"VLOOKUP(VALUE(InputIncludeSocial),C8:F9,3,0)","v":1}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(VALUE(InputIncludeSocial),C8:F9,4,0)","v":1}]
[]
[null,"x) Number of Social Media channels"]
[null,"How many channels are in scope"]
[]
[null,null,"#channels","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,0,0,0,0]
[null,null,1,1,1,1]
[null,null,2,1.1000000000000001,1.1000000000000001,1.1000000000000001]
[null,null,3,1.2,1.1499999999999999,1.1499999999999999]
[null,null,4,1.3,1.2,1.2]
[null,null,5,1.4,1.2,1.2]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(VALUE(InputSocialChannelCount),C19:F24,2,0)","v":1.4}]
[null,"Impact on Management",{"$f":"VLOOKUP(VALUE(InputSocialChannelCount),C19:F24,3,0)","v":1.2}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(VALUE(InputSocialChannelCount),C19:F24,4,0)","v":1.2}]
[]
[null,"x) Products"]
[null,"What is the sector independent impact of the number of products on the setup and the management of social media channels?"]
[]
[null,null,"# Products","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,1,1,1,1,"(low # of products)"]
[null,null,2,1,1,1,"(average # of products)"]
[null,null,3,1,1,1,"(large # of products)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,0,0,1,1),1,IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,1,0,1,1),2,3)),C34:F36,2,0)","v":1}]
[null,"Impact on Management",{"$f":"VLOOKUP(IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,0,0,1,1),1,IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,1,0,1,1),2,3)),C34:F36,3,0)","v":1}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,0,0,1,1),1,IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,1,0,1,1),2,3)),C34:F36,4,0)","v":1}]
[]
[null,"x) Turnover"]
[null,"What is the sector independent impact of the company turnover on the setup and the management of social media channels?"]
[]
[null,null,"Turnover","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,1,1,1,1,"(low turnover)"]
[null,null,2,1,1,1,"(average turnover)"]
[null,null,3,1,1,1,"(high turnover)"]
[null,null,4,1,1,1,"(highest turnover)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(VALUE(InputTurnover),C46:F49,2,0)","v":1}]
[null,"Impact on Management",{"$f":"VLOOKUP(VALUE(InputTurnover),C46:F49,3,0)","v":1}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(VALUE(InputTurnover),C46:F49,4,0)","v":1}]
[]
[null,"x) Customers"]
[null,"What is the sector independent impact of the number of customers on the setup and the management of social media channels?"]
[]
[null,null,"# Customers","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,1,1,1,1,"(no customers)"]
[null,null,2,1,1,1,"(low # of customers)"]
[null,null,3,1,1,1,"(average # of customers)"]
[null,null,4,1,1,1,"(large # of customers)"]
[null,null,5,1,1,1,"(largest # of customers)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(VALUE(InputKlanten),C59:F63,2,0)","v":1}]
[null,"Impact on Management",{"$f":"VLOOKUP(VALUE(InputKlanten),C59:F63,3,0)","v":1}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(VALUE(InputKlanten),C59:F63,4,0)","v":1}]
[]
[null,"x) Languages"]
[null,"What is the sector independent impact of the number of languages on the setup and the management of social media channels?"]
[]
[null,null,"# Languages","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,0,0,0,0,"(no languages)"]
[null,null,1,1,1,1,"(1 language)"]
[null,null,2,1.3,1.1000000000000001,1.1000000000000001,"(2 languages)"]
[null,null,3,1.6,1.2,1.2,"(3 languages)"]
[null,null,4,1.9,1.3,1.3,"(4 languages)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(VALUE(InputSocialLanguages),C73:F77,2,0)","v":1.3}]
[null,"Impact on Management",{"$f":"VLOOKUP(VALUE(InputSocialLanguages),C73:F77,3,0)","v":1.1000000000000001}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(VALUE(InputSocialLanguages),C73:F77,4,0)","v":1.1000000000000001}]
[]
[null,"x) Current activity"]
[null,"What is the sector independent impact of the current social media activity on the setup and the management of social media channels?"]
[]
[null,null,"Activity","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,1,1.2,1.1000000000000001,1.1000000000000001,"(not active)"]
[null,null,2,1.1000000000000001,1.05,1,"(present but not used)"]
[null,null,3,1,1,0.9,"(used with average skill)"]
[null,null,4,1,0.8,0.75,"(used as a pro)"]
[]
[null,"Impact on Setup",{"$f":"IF(IncludeFacebook=1,VLOOKUP(VALUE(StatusFacebook),C87:F90,2,0),1)*IF(IncludeLinkedIn=1,VLOOKUP(VALUE(StatusLinkedIn),C87:F90,2,0),1)*IF(IncludeTwitter=1,VLOOKUP(VALUE(StatusTwitter),C87:F90,2,0),1)*IF(IncludeInstagram=1,VLOOKUP(VALUE(StatusInstagram),C87:F90,2,0),1)*IF(IncludePinterest=1,VLOOKUP(VALUE(StatusPinterest),C87:F90,2,0),1)","v":2.4883199999999999}]
[null,"Impact on Management",{"$f":"IF(IncludeFacebook=1,VLOOKUP(VALUE(StatusFacebook),C87:F90,3,0),1)*IF(IncludeLinkedIn=1,VLOOKUP(VALUE(StatusLinkedIn),C87:F90,3,0),1)*IF(IncludeTwitter=1,VLOOKUP(VALUE(StatusTwitter),C87:F90,3,0),1)*IF(IncludeInstagram=1,VLOOKUP(VALUE(StatusInstagram),C87:F90,3,0),1)*IF(IncludePinterest=1,VLOOKUP(VALUE(StatusPinterest),C87:F90,3,0),1)","v":1.6105100000000008}]
[null,"Impact on ManagementY2",{"$f":"IF(IncludeFacebook=1,VLOOKUP(VALUE(StatusFacebook),C87:F90,4,0),1)*IF(IncludeLinkedIn=1,VLOOKUP(VALUE(StatusLinkedIn),C87:F90,4,0),1)*IF(IncludeTwitter=1,VLOOKUP(VALUE(StatusTwitter),C87:F90,4,0),1)*IF(IncludeInstagram=1,VLOOKUP(VALUE(StatusInstagram),C87:F90,4,0),1)*IF(IncludePinterest=1,VLOOKUP(VALUE(StatusPinterest),C87:F90,4,0),1)","v":1.6105100000000008}]
[]
[null,"x) Frequentie"]
[null,"What is the sector independent impact of the frequency of posting on the setup and the management of social media?"]
[]
[null,null,"Frequency","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,1,1,1.2,1.1000000000000001,"(elke dag)"]
[null,null,2,1,1.1000000000000001,1.05,"(meerder keren per week)"]
[null,null,3,1,1,1,"(elke week)"]
[null,null,4,1,0.9,0.85,"(enkele keren per maand)"]
[null,null,5,1,0.8,0.75,"(elke maand)"]
[]
[null,"Impact on Setup",{"$f":"IF(IncludeFacebook=1,VLOOKUP(VALUE(FutureFacebook),C100:F104,2,0),1)*IF(IncludeLinkedIn=1,VLOOKUP(VALUE(FutureLinkedIn),C100:F104,2,0),1)*IF(IncludeTwitter=1,VLOOKUP(VALUE(FutureTwitter),C100:F104,2,0),1)*IF(IncludeInstagram=1,VLOOKUP(VALUE(FutureInstagram),C100:F104,2,0),1)*IF(IncludePinterest=1,VLOOKUP(VALUE(FuturePinterest),C100:F104,2,0),1)","v":1}]
[null,"Impact on Management",{"$f":"IF(IncludeFacebook=1,VLOOKUP(VALUE(FutureFacebook),C100:F104,3,0),1)*IF(IncludeLinkedIn=1,VLOOKUP(VALUE(FutureLinkedIn),C100:F104,3,0),1)*IF(IncludeTwitter=1,VLOOKUP(VALUE(FutureTwitter),C100:F104,3,0),1)*IF(IncludeInstagram=1,VLOOKUP(VALUE(FutureInstagram),C100:F104,3,0),1)*IF(IncludePinterest=1,VLOOKUP(VALUE(FuturePinterest),C100:F104,3,0),1)","v":1}]
[null,"Impact on ManagementY2",{"$f":"IF(IncludeFacebook=1,VLOOKUP(VALUE(FutureFacebook),C100:F104,4,0),1)*IF(IncludeLinkedIn=1,VLOOKUP(VALUE(FutureLinkedIn),C100:F104,4,0),1)*IF(IncludeTwitter=1,VLOOKUP(VALUE(FutureTwitter),C100:F104,4,0),1)*IF(IncludeInstagram=1,VLOOKUP(VALUE(FutureInstagram),C100:F104,4,0),1)*IF(IncludePinterest=1,VLOOKUP(VALUE(FuturePinterest),C100:F104,4,0),1)","v":1}]
[]
[null,"x) TOTAL IMPACT SOCIAL MEDIA"]
[]
[null,"Impact on Setup",{"$f":"C11*C26*C38*C51*C65*C79*C92*C106","v":4.5287423999999996}]
[null,"Impact on Management",{"$f":"C12*C27*C39*C52*C66*C80*C93*C107","v":2.1258732000000009}]
[null,"Impact on Management Y2",{"$f":"C13*C28*C40*C53*C67*C81*C94*C108","v":2.1258732000000009}]
[]
["Calculate impact of user provided information onEmail marketing cost"]
[]
[null,"x) Include"]
[null,"Is email marketing in scope?"]
[]
[null,null,"Include","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,0,0,0,0,"(exclude)"]
[null,null,1,1,1,1,"(include)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(VALUE(InputIncludeEmail),C122:F123,2,0)","v":1}]
[null,"Impact on Management",{"$f":"VLOOKUP(VALUE(InputIncludeEmail),C122:F123,3,0)","v":1}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(VALUE(InputIncludeEmail),C122:F123,4,0)","v":1}]
[]
[null,"x) Products"]
[null,"What is the sector independent impact of the number of products on the setup and the management of social media channels?"]
[]
[null,null,"# Products","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,1,1,1,1,"(low # of products)"]
[null,null,2,1,1,1,"(average # of products)"]
[null,null,3,1,1,1,"(large # of products)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,0,0,1,1),1,IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,1,0,1,1),2,3)),C133:F135,2,0)","v":1}]
[null,"Impact on Management",{"$f":"VLOOKUP(IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,0,0,1,1),1,IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,1,0,1,1),2,3)),C133:F135,3,0)","v":1}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,0,0,1,1),1,IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,1,0,1,1),2,3)),C133:F135,4,0)","v":1}]
[]
[null,"x) Turnover"]
[null,"What is the sector independent impact of the company turnover on the setup and the management of social media channels?"]
[]
[null,null,"Turnover","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,1,1,1,1,"(low turnover)"]
[null,null,2,1,1,1,"(average turnover)"]
[null,null,3,1,1,1,"(high turnover)"]
[null,null,4,1,1,1,"(highest turnover)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(VALUE(InputTurnover),C145:F148,2,0)","v":1}]
[null,"Impact on Management",{"$f":"VLOOKUP(VALUE(InputTurnover),C145:F148,3,0)","v":1}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(VALUE(InputTurnover),C145:F148,4,0)","v":1}]
[]
[null,"x) Customers"]
[null,"What is the sector independent impact of the number of customers on the setup and the management of social media channels?"]
[]
[null,null,"# Customers","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,1,1,1,1,"(no customers)"]
[null,null,2,1,1,1,"(low # of customers)"]
[null,null,3,1,1,1,"(average # of customers)"]
[null,null,4,1,1,1,"(large # of customers)"]
[null,null,5,1,1,1,"(largest # of customers)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(VALUE(InputKlanten),C158:F162,2,0)","v":1}]
[null,"Impact on Management",{"$f":"VLOOKUP(VALUE(InputKlanten),C158:F162,3,0)","v":1}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(VALUE(InputKlanten),C158:F162,4,0)","v":1}]
[]
[null,"x) Languages"]
[null,"What is the sector independent impact of the number of languages on the setup and the management of email marketing?"]
[]
[null,null,"#Languages","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,0,0,0,0,"(no languages)"]
[null,null,1,1,1,1,"(1 language)"]
[null,null,2,1.3,1.1000000000000001,1.1000000000000001,"(2 languages)"]
[null,null,3,1.6,1.2,1.2,"(3 languages)"]
[null,null,4,1.9,1.3,1.3,"(4 languages)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(VALUE(InputEmailLanguages),C172:F176,2,0)","v":1.3}]
[null,"Impact on Management",{"$f":"VLOOKUP(VALUE(InputEmailLanguages),C172:F176,3,0)","v":1.1000000000000001}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(VALUE(InputEmailLanguages),C172:F176,4,0)","v":1.1000000000000001}]
[]
[null,"x) Current activity"]
[null,"What is the sector independent impact of the current activity on the setup and the management of email marketing?"]
[]
[null,null,"Activity","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,1,1,1.4,1.1000000000000001,"(no activity)"]
[null,null,2,1,1.2,1,"(basic activity)"]
[null,null,3,0,1,0.9,"(pro activity)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(VALUE(InputEmailActivity),C186:F188,2,0)","v":1}]
[null,"Impact on Management",{"$f":"VLOOKUP(VALUE(InputEmailActivity),C186:F188,3,0)","v":1.4}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(VALUE(InputEmailActivity),C186:F188,4,0)","v":1.1000000000000001}]
[]
[null,"x) Frequentie"]
[null,"What is the sector independent impact of the frequency of mailing on the setup and the management of email marketing?"]
[]
[null,null,"# Frequentie","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,1,1,1,1,"(every week)"]
[null,null,2,1,0.5,0.5,"(every 2 weeks)"]
[null,null,3,1,{"$f":"12/52","v":0.23076923076923078},{"$f":"12/52","v":0.23076923076923078},"(every month)"]
[null,null,4,1,{"$f":"4/52","v":7.6923076923076927E-2},{"$f":"4/52","v":7.6923076923076927E-2},"(every quarter)"]
[null,null,5,1,{"$f":"2/52","v":3.8461538461538464E-2},{"$f":"2/52","v":3.8461538461538464E-2},"(every half year)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(VALUE(InputEmailFrequency),C198:F202,2,0)","v":1}]
[null,"Impact on Management",{"$f":"VLOOKUP(VALUE(InputEmailFrequency),C198:F202,3,0)","v":0.5}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(VALUE(InputEmailFrequency),C198:F202,4,0)","v":0.5}]
[]
[null,"x) TOTAL IMPACT EMAIL MARKETING"]
[]
[null,"Impact on Setup",{"$f":"C125*C137*C150*C164*C178*C190*C204","v":1.3}]
[null,"Impact on Management",{"$f":"C126*C138*C151*C165*C179*C191*C205","v":0.77}]
[null,"Impact on ManagementY2",{"$f":"C127*C139*C152*C166*C180*C192*C206","v":0.60500000000000009}]
[]
["Email marketing mails"]
[]
[null,"1. Frequentie","What's the multiplier for the amount of emails sent"]
[]
[null,null,"# Frequentie","Impact"]
[null,null,1,{"$f":"52/12","v":4.333333333333333},null,"(every week)"]
[null,null,2,{"$f":"26/12","v":2.1666666666666665},null,"(every 2 weeks)"]
[null,null,3,1,null,"(every month)"]
[null,null,4,{"$f":"4/12","v":0.33333333333333331},null,"(every quarter)"]
[null,null,5,{"$f":"2/12","v":0.16666666666666666},null,"(every half year)"]
[]
[null,"Impact",{"$f":"VLOOKUP(VALUE(InputEmailFrequency),C219:D223,2,0)","v":2.1666666666666665}]
[]
["Calculate impact of user provided information on Content Marketing cost"]
[]
[null,"X) Include"]
[null,"In- or exclude setup and management of blogging?"]
[]
[null,null,"Include","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,0,0,0,0,"(exclude)"]
[null,null,1,1,1,1,"(include)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(VALUE(InputIncludeBlog),C233:F234,2,0)","v":1}]
[null,"Impact on Management",{"$f":"VLOOKUP(VALUE(InputIncludeBlog),C233:F234,3,0)","v":1}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(VALUE(InputIncludeBlog),C233:F234,4,0)","v":1}]
[]
[null,"x) Products"]
[null,"What is the sector independent impact of the number of products on the setup and the management of social media channels?"]
[]
[null,null,"# Products","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,1,1,1,1,"(low # of products)"]
[null,null,2,1,1,1,"(average # of products)"]
[null,null,3,1,1,1,"(large # of products)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,0,0,1,1),1,IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,1,0,1,1),2,3)),C244:F246,2,0)","v":1}]
[null,"Impact on Management",{"$f":"VLOOKUP(IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,0,0,1,1),1,IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,1,0,1,1),2,3)),C244:F246,3,0)","v":1}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,0,0,1,1),1,IF(VALUE(InputProducts)<OFFSET(LIST_PRODUCTRANGE,1,0,1,1),2,3)),C244:F246,4,0)","v":1}]
[]
[null,"x) Turnover"]
[null,"What is the sector independent impact of the company turnover on the setup and the management of social media channels?"]
[]
[null,null,"Turnover","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,1,1,1,1,"(low turnover)"]
[null,null,2,1,1,1,"(average turnover)"]
[null,null,3,1,1,1,"(high turnover)"]
[null,null,4,1,1,1,"(highest turnover)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(VALUE(InputTurnover),C256:F259,2,0)","v":1}]
[null,"Impact on Management",{"$f":"VLOOKUP(VALUE(InputTurnover),C256:F259,3,0)","v":1}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(VALUE(InputTurnover),C256:F259,4,0)","v":1}]
[]
[null,"x) Customers"]
[null,"What is the sector independent impact of the number of customers on the setup and the management of social media channels?"]
[]
[null,null,"# Customers","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,1,1,1,1,"(no customers)"]
[null,null,2,1,1,1,"(low # of customers)"]
[null,null,3,1,1,1,"(average # of customers)"]
[null,null,4,1,1,1,"(large # of customers)"]
[null,null,5,1,1,1,"(largest # of customers)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(VALUE(InputKlanten),C269:F273,2,0)","v":1}]
[null,"Impact on Management",{"$f":"VLOOKUP(VALUE(InputKlanten),C269:F273,3,0)","v":1}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(VALUE(InputKlanten),C269:F273,4,0)","v":1}]
[]
[null,"x) Languages"]
[null,"What is the sector independent impact of the number of languages on the setup and the management of blogging?"]
[]
[null,null,"# Languages","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,0,0,0,0,"(no languages)"]
[null,null,1,1,1,1,"(1 language)"]
[null,null,2,1.3,1.1000000000000001,1.1000000000000001,"(2 languages)"]
[null,null,3,1.6,1.2,1.2,"(3 languages)"]
[null,null,4,1.9,1.3,1.3,"(4 languages)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(VALUE(InputBlogLanguages),C283:F287,2,0)","v":1.3}]
[null,"Impact on Management",{"$f":"VLOOKUP(VALUE(InputBlogLanguages),C283:F287,3,0)","v":1.1000000000000001}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(VALUE(InputBlogLanguages),C283:F287,4,0)","v":1.1000000000000001}]
[]
[null,"x) Current activity"]
[null,"What is the sector independent impact of the current activity on the setup and the management of blogging?"]
[]
[null,null,"Activity","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,1,1,1.4,1.4,"(no activity)"]
[null,null,2,1,1.2,1,"(basic activity)"]
[null,null,3,0,1,0.9,"(pro activity)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(VALUE(InputBlogActivity),C297:F299,2,0)","v":1}]
[null,"Impact on Management",{"$f":"VLOOKUP(VALUE(InputBlogActivity),C297:F299,3,0)","v":1.4}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(VALUE(InputBlogActivity),C297:F299,4,0)","v":1.4}]
[]
[null,"x) Frequentie"]
[null,"What is the sector independent impact of the frequency of blogging on the setup and the management of content marketing?"]
[]
[null,null,"Frequency","Setup Impact ","Mngmt Factor","Mngmt Y2"]
[null,null,1,1,1,1,"(every week)"]
[null,null,2,1,0.5,0.5,"(every 2 weeks)"]
[null,null,3,1,{"$f":"12/52","v":0.23076923076923078},{"$f":"12/52","v":0.23076923076923078},"(every month)"]
[null,null,4,1,{"$f":"4/52","v":7.6923076923076927E-2},{"$f":"4/52","v":7.6923076923076927E-2},"(every quarter)"]
[null,null,5,1,{"$f":"2/52","v":3.8461538461538464E-2},{"$f":"2/52","v":3.8461538461538464E-2},"(every half year)"]
[]
[null,"Impact on Setup",{"$f":"VLOOKUP(VALUE(InputBlogFrequency),C309:F313,2,0)","v":1}]
[null,"Impact on Management",{"$f":"VLOOKUP(VALUE(InputBlogFrequency),C309:F313,3,0)","v":0.23076923076923078}]
[null,"Impact on ManagementY2",{"$f":"VLOOKUP(VALUE(InputBlogFrequency),C309:F313,4,0)","v":0.23076923076923078}]
[]
[null,"X) TOTAL IMPACT BLOGGING"]
[]
[null,"Impact on Setup",{"$f":"C236*C248*C261*C275*C289*C301*C315","v":1.3}]
[null,"Impact on Management",{"$f":"C237*C249*C262*C276*C290*C302*C316","v":0.35538461538461541}]
[null,"Impact on ManagementY2",{"$f":"C238*C250*C263*C277*C291*C303*C317","v":0.35538461538461541}]
[]
["Marketing Impact"]
[]
[null,"x) Social Media Use"]
[]
[null,"Frequency"]
[]
[null,null,"Activity","Impact factor"]
[null,null,1,1.075,null,"(elke dag)"]
[null,null,2,1.05,null,"(meerder keren per week)"]
[null,null,3,1,null,"(elke week)"]
[null,null,4,1,null,"(enkele keren per maand)"]
[null,null,5,1,null,"(elke maand)"]
[]
[null,"Languages"]
[]
[null,null,"# Languages","Impact factor"]
[null,null,0,0,null,"(no languages)"]
[null,null,1,1,null,"(1 language)"]
[null,null,2,1.05,null,"(2 languages)"]
[null,null,3,1.075,null,"(3 languages)"]
[null,null,4,1.1000000000000001,null,"(4 languages)"]
[]
[null,"Impact on visitors by Social Media",{"$f":"IF(VLOOKUP(VALUE(InputIncludeSocial),C8:F9,2,0)=1,(IF(IncludeFacebook=1,VLOOKUP(VALUE(FutureFacebook),C332:D336,2,0),1)*IF(IncludeLinkedIn=1,VLOOKUP(VALUE(FutureLinkedIn),C332:D336,2,0),1)*IF(IncludeTwitter=1,VLOOKUP(VALUE(FutureTwitter),C332:D336,2,0),1)*IF(IncludeInstagram=1,VLOOKUP(VALUE(FutureInstagram),C332:D336,2,0),1)*IF(IncludePinterest=1,VLOOKUP(VALUE(FuturePinterest),C332:D336,2,0),1))*VLOOKUP(VALUE(InputSocialLanguages),C341:D345,2,0),1)","v":1.05}]
[]
[null,"x)  Email Marketing Use"]
[]
[null,"Frequency"]
[]
[null,null,"# Frequentie","Impact factor"]
[null,null,1,1.25,null,"(every week)"]
[null,null,2,1.1000000000000001,null,"(every 2 weeks)"]
[null,null,3,1,null,"(every month)"]
[null,null,4,1,null,"(every quarter)"]
[null,null,5,1,null,"(every half year)"]
[]
[null,"Languages"]
[]
[null,null,"# Languages","Impact factor"]
[null,null,0,0,null,"(no languages)"]
[null,null,1,1,null,"(1 language)"]
[null,null,2,1.05,null,"(2 languages)"]
[null,null,3,1.075,null,"(3 languages)"]
[null,null,4,1.1000000000000001,null,"(4 languages)"]
[]
[null,"Impact on visitors by Email Marketing",{"$f":"IF(VLOOKUP(VALUE(InputIncludeEmail),C122:F123,2,0)=1,VLOOKUP(VALUE(InputEmailFrequency),C354:D358,2,0)*VLOOKUP(VALUE(InputEmailLanguages),C363:D367,2,0),1)","v":1.1550000000000002}]
[]
[null,"x) Content Marketing Use"]
[]
[null,"Frequency"]
[]
[null,null,"# Frequentie","Impact factor"]
[null,null,1,1.2,null,"(every week)"]
[null,null,2,1.1000000000000001,null,"(every 2 weeks)"]
[null,null,3,1.05,null,"(every month)"]
[null,null,4,1,null,"(every quarter)"]
[null,null,5,1,null,"(every half year)"]
[]
[null,"Languages of blogging"]
[]
[null,null,"# Languages","Impact factor"]
[null,null,0,0,null,"(no languages)"]
[null,null,1,1,null,"(1 language)"]
[null,null,2,1.05,null,"(2 languages)"]
[null,null,3,1.1000000000000001,null,"(3 languages)"]
[null,null,4,1.1499999999999999,null,"(4 languages)"]
[]
[null,"Impact on visitors by Blogging",{"$f":"IF(VLOOKUP(VALUE(InputIncludeBlog),C233:F234,2,0)=1,VLOOKUP(VALUE(InputBlogFrequency),C376:D380,2,0)*VLOOKUP(VALUE(InputBlogLanguages),C385:D389,2,0),1)","v":1.1025}]
[]
[null,"x) Turnover"]
[null,"What is the sector independent impact of the company turnover on the setup and the management of social media channels?"]
[]
[null,null,"Turnover","Impact"]
[null,null,1,1,null,null,"(low turnover)"]
[null,null,2,1,null,null,"(average turnover)"]
[null,null,3,1,null,null,"(high turnover)"]
[null,null,4,1,null,null,"(highest turnover)"]
[]
[null,"Impact",{"$f":"VLOOKUP(VALUE(InputTurnover),C397:F400,2,0)","v":1}]
[]
[null,"x) Customers"]
[null,"What is the sector independent impact of the number of customers on the setup and the management of social media channels?"]
[]
[null,null,"# Customers","Impact"]
[null,null,1,1,null,null,"(no customers)"]
[null,null,2,1,null,null,"(low # of customers)"]
[null,null,3,1.05,null,null,"(average # of customers)"]
[null,null,4,1.05,null,null,"(large # of customers)"]
[null,null,5,1.1000000000000001,null,null,"(largest # of customers)"]
[]
[null,"Impact",{"$f":"VLOOKUP(VALUE(InputKlanten),C408:F412,2,0)","v":1.1000000000000001}]
[]
[null,"x) TOTAL IMPACT MARKETING"]
[]
[null,"Impact",{"$f":"C347*C369*C391*C402*C414","v":1.4707625625000005}]
[]
["Sector Impact"]
[]
[null,"x) Comeos Indicators"]
[]
[null,"Comeos Indicator Y1",{"$f":"VLOOKUP(VALUE(InputSector),SECTORDATA,26,0)","v":"NEUTRAL"},{"$f":"VLOOKUP(C424,DATA_CCOP,2,0)","v":1}]
[null,"Comeos Indicator Y2",{"$f":"VLOOKUP(VALUE(InputSector),SECTORDATA,27,0)","v":"NEUTRAL"},{"$f":"VLOOKUP(C425,DATA_CFOP,2,0)","v":1}]
[null,"Competition Indicator",{"$f":"VLOOKUP(VALUE(InputSector),SECTORDATA,28,0)","v":"NEUTRAL"},{"$f":"VLOOKUP(C426,DATA_COMPETITION,2,0)","v":1}]
[]
[null,"x) TOTAL IMPACT VISITORS"]
[]
[null,"Y1",{"$f":"D424*D426","v":1}]
[null,"Y2",{"$f":"D425*D426","v":1}]
[]
[]
["Product beheer"]
[]
[null,"Aantal producten",{"$f":"VALUE(InputProducts)","v":100}]
[null,"Jaarlijks te wijzigen",{"$f":"VALUE(InputProductChange)","v":25}]
[null,"Duurtijd",11]
[null,"Tarief",{"$f":"VALUE(InputProductRate)","v":50}]
[]
[null,null,{"$f":"ROUND(((((VALUE(InputProducts)+VALUE(InputProductChange))*VALUE(InputUpdateTime))/60)*VALUE(InputProductRate))/12,2)","v":260.42}]