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

{"sheet":"Penjualan Regional","index":0,"n_rows":12,"n_cols":17,"rows_kept":12,"merged":[[0,0,0,14],[1,0,1,12],[1,13,1,14]]}
["PENJUALAN REGIONAL",{"$nulls":15}," "]
["Bagan Penjualan Regional menggambarkan penjualan hingga delapan kawasan dari Januari sampai Desember. Masukkan Catatan di sel N2 di sebelah kanan dan data penjualan untuk setiap bulan dalam sel di bawah ini.",{"$nulls":12},"\nCATATAN:\nAmerika Utara melanjutkan kinerja bagusnya di bulan Agustus, tetapi \nkita perlu melihat Asia secara lebih saksama."]
["KAWASAN","JAN","FEB","MAR","APR","MEI","JUN","JUL","AGU","SEP","OKT","NOV","DES","TOTAL","%","Label"]
["Amerika Utara",{"v":23000,"d":"Rp23,000"},{"v":25000,"d":"Rp25,000"},{"v":19000,"d":"Rp19,000"},{"v":13000,"d":"Rp13,000"},{"v":18000,"d":"Rp18,000"},{"v":22000,"d":"Rp22,000"},{"v":26000,"d":"Rp26,000"},{"$nulls":5},{"$f":"SUM('Penjualan Regional'!$B4:$M4)","v":{"v":146000,"d":"Rp146,000.00"}},{"$f":"'Penjualan Regional'!$N4/SUM('Penjualan Regional'!$N$4:$N$11)","v":{"v":0.42196531791907516,"d":"42%"}},{"$f":"'Penjualan Regional'!$A4 & \" (\" & TEXT('Penjualan Regional'!$O4,\"0%\") & \")\"","v":"Amerika Utara (42%)"}]
["Asia",{"v":14000,"d":"Rp14,000"},{"v":18000,"d":"Rp18,000"},{"v":14000,"d":"Rp14,000"},{"v":12000,"d":"Rp12,000"},{"v":14000,"d":"Rp14,000"},{"v":18000,"d":"Rp18,000"},{"v":12000,"d":"Rp12,000"},{"$nulls":5},{"$f":"SUM('Penjualan Regional'!$B5:$M5)","v":{"v":102000,"d":"Rp102,000.00"}},{"$f":"'Penjualan Regional'!$N5/SUM('Penjualan Regional'!$N$4:$N$11)","v":{"v":0.2947976878612717,"d":"29%"}},{"$f":"'Penjualan Regional'!$A5 & \" (\" & TEXT('Penjualan Regional'!$O5,\"0%\") & \")\"","v":"Asia (29%)"}]
["Eropa",{"v":20000,"d":"Rp20,000"},{"v":12000,"d":"Rp12,000"},{"v":13000,"d":"Rp13,000"},{"v":10000,"d":"Rp10,000"},{"v":11000,"d":"Rp11,000"},{"v":15000,"d":"Rp15,000"},{"v":17000,"d":"Rp17,000"},{"$nulls":5},{"$f":"SUM('Penjualan Regional'!$B6:$M6)","v":{"v":98000,"d":"Rp98,000.00"}},{"$f":"'Penjualan Regional'!$N6/SUM('Penjualan Regional'!$N$4:$N$11)","v":{"v":0.2832369942196532,"d":"28%"}},{"$f":"'Penjualan Regional'!$A6 & \" (\" & TEXT('Penjualan Regional'!$O6,\"0%\") & \")\"","v":"Eropa (28%)"}]
[{"$nulls":13},{"$f":"SUM('Penjualan Regional'!$B7:$M7)","v":{"v":0,"d":"Rp0.00"}},{"$f":"'Penjualan Regional'!$N7/SUM('Penjualan Regional'!$N$4:$N$11)","v":{"v":0,"d":"0%"}},{"$f":"'Penjualan Regional'!$A7 & \" (\" & TEXT('Penjualan Regional'!$O7,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Penjualan Regional'!$B8:$M8)","v":{"v":0,"d":"Rp0.00"}},{"$f":"'Penjualan Regional'!$N8/SUM('Penjualan Regional'!$N$4:$N$11)","v":{"v":0,"d":"0%"}},{"$f":"'Penjualan Regional'!$A8 & \" (\" & TEXT('Penjualan Regional'!$O8,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Penjualan Regional'!$B9:$M9)","v":{"v":0,"d":"Rp0.00"}},{"$f":"'Penjualan Regional'!$N9/SUM('Penjualan Regional'!$N$4:$N$11)","v":{"v":0,"d":"0%"}},{"$f":"'Penjualan Regional'!$A9 & \" (\" & TEXT('Penjualan Regional'!$O9,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Penjualan Regional'!$B10:$M10)","v":{"v":0,"d":"Rp0.00"}},{"$f":"'Penjualan Regional'!$N10/SUM('Penjualan Regional'!$N$4:$N$11)","v":{"v":0,"d":"0%"}},{"$f":"'Penjualan Regional'!$A10 & \" (\" & TEXT('Penjualan Regional'!$O10,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Penjualan Regional'!$B11:$M11)","v":{"v":0,"d":"Rp0.00"}},{"$f":"'Penjualan Regional'!$N11/SUM('Penjualan Regional'!$N$4:$N$11)","v":{"v":0,"d":"0%"}},{"$f":"'Penjualan Regional'!$A11 & \" (\" & TEXT('Penjualan Regional'!$O11,\"0%\") & \")\"","v":" (0%)"}]
["TOTAL",{"$f":"SUBTOTAL(109,Kawasan[JAN])","v":{"v":57000,"d":"Rp57,000"}},{"$f":"SUBTOTAL(109,Kawasan[FEB])","v":{"v":55000,"d":"Rp55,000"}},{"$f":"SUBTOTAL(109,Kawasan[MAR])","v":{"v":46000,"d":"Rp46,000"}},{"$f":"SUBTOTAL(109,Kawasan[APR])","v":{"v":35000,"d":"Rp35,000"}},{"$f":"SUBTOTAL(109,Kawasan[MEI])","v":{"v":43000,"d":"Rp43,000"}},{"$f":"SUBTOTAL(109,Kawasan[JUN])","v":{"v":55000,"d":"Rp55,000"}},{"$f":"SUBTOTAL(109,Kawasan[JUL])","v":{"v":55000,"d":"Rp55,000"}},{"$f":"SUBTOTAL(109,Kawasan[AGU])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Kawasan[SEP])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Kawasan[OKT])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Kawasan[NOV])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Kawasan[DES])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Kawasan[TOTAL])","v":{"v":346000,"d":"Rp346,000.00"}},{"$f":"SUBTOTAL(109,Kawasan[%])","v":{"v":1,"d":"100%"}}]