{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Regionale verkopen"],"not_rendered":{"charts":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Regionale verkopen","index":0,"n_rows":12,"n_cols":17,"rows_kept":12,"merged":[[0,0,0,14],[1,0,1,12],[1,13,1,14]]}
["  REGIONALE VERKOPEN",{"$nulls":15}," "]
["In de grafiek Regionale verkopen worden de verkopen van maximaal acht regio's van januari tot en met december uitgezet. Voer notities in cel N2 in en verkoopgegevens voor elke maand in de cellen hieronder.",{"$nulls":12},"\nNOTITIES:\nNoord-Amerika zet haar\nsterke ontwikkeling in augustus voort, maar we moeten goed naar Azië kijken."]
["REGIO","JAN","FEB","MRT","APR","MEI","JUN","JUL","AUG","SEP","OKT","NOV","DEC","TOTAAL","%","Etiket"]
["Noord-Amerika",{"v":23000,"d":"€ 23,000"},{"v":25000,"d":"€ 25,000"},{"v":19000,"d":"€ 19,000"},{"v":13000,"d":"€ 13,000"},{"v":18000,"d":"€ 18,000"},{"v":22000,"d":"€ 22,000"},{"v":26000,"d":"€ 26,000"},{"$nulls":5},{"$f":"SUM('Regionale verkopen'!$B4:$M4)","v":{"v":146000,"d":"€ 146,000.00"}},{"$f":"'Regionale verkopen'!$N4/SUM('Regionale verkopen'!$N$4:$N$11)","v":{"v":0.42196531791907516,"d":"€ 0"}},{"$f":"'Regionale verkopen'!$A4 & \" (\" & TEXT('Regionale verkopen'!$O4,\"0%\") & \")\"","v":"Noord-Amerika (42%)"}]
["Azië",{"v":14000,"d":"€ 14,000"},{"v":18000,"d":"€ 18,000"},{"v":14000,"d":"€ 14,000"},{"v":12000,"d":"€ 12,000"},{"v":14000,"d":"€ 14,000"},{"v":18000,"d":"€ 18,000"},{"v":12000,"d":"€ 12,000"},{"$nulls":5},{"$f":"SUM('Regionale verkopen'!$B5:$M5)","v":{"v":102000,"d":"€ 102,000.00"}},{"$f":"'Regionale verkopen'!$N5/SUM('Regionale verkopen'!$N$4:$N$11)","v":{"v":0.2947976878612717,"d":"€ 0"}},{"$f":"'Regionale verkopen'!$A5 & \" (\" & TEXT('Regionale verkopen'!$O5,\"0%\") & \")\"","v":"Azië (29%)"}]
["Europa",{"v":20000,"d":"€ 20,000"},{"v":12000,"d":"€ 12,000"},{"v":13000,"d":"€ 13,000"},{"v":10000,"d":"€ 10,000"},{"v":11000,"d":"€ 11,000"},{"v":15000,"d":"€ 15,000"},{"v":17000,"d":"€ 17,000"},{"$nulls":5},{"$f":"SUM('Regionale verkopen'!$B6:$M6)","v":{"v":98000,"d":"€ 98,000.00"}},{"$f":"'Regionale verkopen'!$N6/SUM('Regionale verkopen'!$N$4:$N$11)","v":{"v":0.2832369942196532,"d":"€ 0"}},{"$f":"'Regionale verkopen'!$A6 & \" (\" & TEXT('Regionale verkopen'!$O6,\"0%\") & \")\"","v":"Europa (28%)"}]
[{"$nulls":13},{"$f":"SUM('Regionale verkopen'!$B7:$M7)","v":{"v":0,"d":"€ 0.00"}},{"$f":"'Regionale verkopen'!$N7/SUM('Regionale verkopen'!$N$4:$N$11)","v":{"v":0,"d":"€ 0"}},{"$f":"'Regionale verkopen'!$A7 & \" (\" & TEXT('Regionale verkopen'!$O7,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Regionale verkopen'!$B8:$M8)","v":{"v":0,"d":"€ 0.00"}},{"$f":"'Regionale verkopen'!$N8/SUM('Regionale verkopen'!$N$4:$N$11)","v":{"v":0,"d":"€ 0"}},{"$f":"'Regionale verkopen'!$A8 & \" (\" & TEXT('Regionale verkopen'!$O8,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Regionale verkopen'!$B9:$M9)","v":{"v":0,"d":"€ 0.00"}},{"$f":"'Regionale verkopen'!$N9/SUM('Regionale verkopen'!$N$4:$N$11)","v":{"v":0,"d":"€ 0"}},{"$f":"'Regionale verkopen'!$A9 & \" (\" & TEXT('Regionale verkopen'!$O9,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Regionale verkopen'!$B10:$M10)","v":{"v":0,"d":"€ 0.00"}},{"$f":"'Regionale verkopen'!$N10/SUM('Regionale verkopen'!$N$4:$N$11)","v":{"v":0,"d":"€ 0"}},{"$f":"'Regionale verkopen'!$A10 & \" (\" & TEXT('Regionale verkopen'!$O10,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Regionale verkopen'!$B11:$M11)","v":{"v":0,"d":"€ 0.00"}},{"$f":"'Regionale verkopen'!$N11/SUM('Regionale verkopen'!$N$4:$N$11)","v":{"v":0,"d":"€ 0"}},{"$f":"'Regionale verkopen'!$A11 & \" (\" & TEXT('Regionale verkopen'!$O11,\"0%\") & \")\"","v":" (0%)"}]
["TOTAAL",{"$f":"SUBTOTAL(109,Regio[JAN])","v":{"v":57000,"d":"€ 57,000"}},{"$f":"SUBTOTAL(109,Regio[FEB])","v":{"v":55000,"d":"€ 55,000"}},{"$f":"SUBTOTAL(109,Regio[MRT])","v":{"v":46000,"d":"€ 46,000"}},{"$f":"SUBTOTAL(109,Regio[APR])","v":{"v":35000,"d":"€ 35,000"}},{"$f":"SUBTOTAL(109,Regio[MEI])","v":{"v":43000,"d":"€ 43,000"}},{"$f":"SUBTOTAL(109,Regio[JUN])","v":{"v":55000,"d":"€ 55,000"}},{"$f":"SUBTOTAL(109,Regio[JUL])","v":{"v":55000,"d":"€ 55,000"}},{"$f":"SUBTOTAL(109,Regio[AUG])","v":{"v":0,"d":"€ 0"}},{"$f":"SUBTOTAL(109,Regio[SEP])","v":{"v":0,"d":"€ 0"}},{"$f":"SUBTOTAL(109,Regio[OKT])","v":{"v":0,"d":"€ 0"}},{"$f":"SUBTOTAL(109,Regio[NOV])","v":{"v":0,"d":"€ 0"}},{"$f":"SUBTOTAL(109,Regio[DEC])","v":{"v":0,"d":"€ 0"}},{"$f":"SUBTOTAL(109,Regio[TOTAAL])","v":{"v":346000,"d":"€ 346,000.00"}},{"$f":"SUBTOTAL(109,Regio[%])","v":{"v":1,"d":"€ 1"}}]