{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Pardavimas pagal regioną"],"not_rendered":{"charts":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Pardavimas pagal regioną","index":0,"n_rows":12,"n_cols":17,"rows_kept":12,"merged":[[0,0,0,14],[1,0,1,12],[1,13,1,14]]}
["PARDAVIMAS PAGAL REGIONĄ",{"$nulls":15}," "]
["Pardavimo pagal regioną diagramoje vaizduojamas iki 8 regionų pardavimas nuo sausio iki gruodžio. N2 langelyje dešinėje įveskite pastabas ir kiekvieno mėnesio pardavimo duomenis langeliuose apačioje.",{"$nulls":12},"\nPASTABOS:\nŠiaurės Amerikoje rugpjūčio mėnesį ir toliau sekėsi puikiai, bet reikėtų atidžiai išnagrinėti pardavimą Azijoje. "]
["REGIONAS","SAU","VAS","KOV","BAL","GEG","BIR","LIE","RGP","RGS","SPL","LAP","GRD","Suma","%","Žyma"]
["Šiaurės Amerika",{"v":23000,"d":"23,000 EUR"},{"v":25000,"d":"25,000 EUR"},{"v":19000,"d":"19,000 EUR"},{"v":13000,"d":"13,000 EUR"},{"v":18000,"d":"18,000 EUR"},{"v":22000,"d":"22,000 EUR"},{"v":26000,"d":"26,000 EUR"},{"$nulls":5},{"$f":"SUM('Pardavimas pagal regioną'!$B4:$M4)","v":{"v":146000,"d":"146,000.00 EUR"}},{"$f":"'Pardavimas pagal regioną'!$N4/SUM('Pardavimas pagal regioną'!$N$4:$N$11)","v":{"v":0.42196531791907516,"d":"42%"}},{"$f":"'Pardavimas pagal regioną'!$A4 & \" (\" & TEXT('Pardavimas pagal regioną'!$O4,\"0%\") & \")\"","v":"Šiaurės Amerika (42%)"}]
["Azija",{"v":14000,"d":"14,000 EUR"},{"v":18000,"d":"18,000 EUR"},{"v":14000,"d":"14,000 EUR"},{"v":12000,"d":"12,000 EUR"},{"v":14000,"d":"14,000 EUR"},{"v":18000,"d":"18,000 EUR"},{"v":12000,"d":"12,000 EUR"},{"$nulls":5},{"$f":"SUM('Pardavimas pagal regioną'!$B5:$M5)","v":{"v":102000,"d":"102,000.00 EUR"}},{"$f":"'Pardavimas pagal regioną'!$N5/SUM('Pardavimas pagal regioną'!$N$4:$N$11)","v":{"v":0.2947976878612717,"d":"29%"}},{"$f":"'Pardavimas pagal regioną'!$A5 & \" (\" & TEXT('Pardavimas pagal regioną'!$O5,\"0%\") & \")\"","v":"Azija (29%)"}]
["Europa",{"v":20000,"d":"20,000 EUR"},{"v":12000,"d":"12,000 EUR"},{"v":13000,"d":"13,000 EUR"},{"v":10000,"d":"10,000 EUR"},{"v":11000,"d":"11,000 EUR"},{"v":15000,"d":"15,000 EUR"},{"v":17000,"d":"17,000 EUR"},{"$nulls":5},{"$f":"SUM('Pardavimas pagal regioną'!$B6:$M6)","v":{"v":98000,"d":"98,000.00 EUR"}},{"$f":"'Pardavimas pagal regioną'!$N6/SUM('Pardavimas pagal regioną'!$N$4:$N$11)","v":{"v":0.2832369942196532,"d":"28%"}},{"$f":"'Pardavimas pagal regioną'!$A6 & \" (\" & TEXT('Pardavimas pagal regioną'!$O6,\"0%\") & \")\"","v":"Europa (28%)"}]
[{"$nulls":13},{"$f":"SUM('Pardavimas pagal regioną'!$B7:$M7)","v":{"v":0,"d":"0.00 EUR"}},{"$f":"'Pardavimas pagal regioną'!$N7/SUM('Pardavimas pagal regioną'!$N$4:$N$11)","v":{"v":0,"d":"0%"}},{"$f":"'Pardavimas pagal regioną'!$A7 & \" (\" & TEXT('Pardavimas pagal regioną'!$O7,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Pardavimas pagal regioną'!$B8:$M8)","v":{"v":0,"d":"0.00 EUR"}},{"$f":"'Pardavimas pagal regioną'!$N8/SUM('Pardavimas pagal regioną'!$N$4:$N$11)","v":{"v":0,"d":"0%"}},{"$f":"'Pardavimas pagal regioną'!$A8 & \" (\" & TEXT('Pardavimas pagal regioną'!$O8,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Pardavimas pagal regioną'!$B9:$M9)","v":{"v":0,"d":"0.00 EUR"}},{"$f":"'Pardavimas pagal regioną'!$N9/SUM('Pardavimas pagal regioną'!$N$4:$N$11)","v":{"v":0,"d":"0%"}},{"$f":"'Pardavimas pagal regioną'!$A9 & \" (\" & TEXT('Pardavimas pagal regioną'!$O9,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Pardavimas pagal regioną'!$B10:$M10)","v":{"v":0,"d":"0.00 EUR"}},{"$f":"'Pardavimas pagal regioną'!$N10/SUM('Pardavimas pagal regioną'!$N$4:$N$11)","v":{"v":0,"d":"0%"}},{"$f":"'Pardavimas pagal regioną'!$A10 & \" (\" & TEXT('Pardavimas pagal regioną'!$O10,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Pardavimas pagal regioną'!$B11:$M11)","v":{"v":0,"d":"0.00 EUR"}},{"$f":"'Pardavimas pagal regioną'!$N11/SUM('Pardavimas pagal regioną'!$N$4:$N$11)","v":{"v":0,"d":"0%"}},{"$f":"'Pardavimas pagal regioną'!$A11 & \" (\" & TEXT('Pardavimas pagal regioną'!$O11,\"0%\") & \")\"","v":" (0%)"}]
["Suma",{"$f":"SUBTOTAL(109,Regionas[SAU])","v":{"v":57000,"d":"57,000 EUR"}},{"$f":"SUBTOTAL(109,Regionas[VAS])","v":{"v":55000,"d":"55,000 EUR"}},{"$f":"SUBTOTAL(109,Regionas[KOV])","v":{"v":46000,"d":"46,000 EUR"}},{"$f":"SUBTOTAL(109,Regionas[BAL])","v":{"v":35000,"d":"35,000 EUR"}},{"$f":"SUBTOTAL(109,Regionas[GEG])","v":{"v":43000,"d":"43,000 EUR"}},{"$f":"SUBTOTAL(109,Regionas[BIR])","v":{"v":55000,"d":"55,000 EUR"}},{"$f":"SUBTOTAL(109,Regionas[LIE])","v":{"v":55000,"d":"55,000 EUR"}},{"$f":"SUBTOTAL(109,Regionas[RGP])","v":{"v":0,"d":"0 EUR"}},{"$f":"SUBTOTAL(109,Regionas[RGS])","v":{"v":0,"d":"0 EUR"}},{"$f":"SUBTOTAL(109,Regionas[SPL])","v":{"v":0,"d":"0 EUR"}},{"$f":"SUBTOTAL(109,Regionas[LAP])","v":{"v":0,"d":"0 EUR"}},{"$f":"SUBTOTAL(109,Regionas[GRD])","v":{"v":0,"d":"0 EUR"}},{"$f":"SUBTOTAL(109,Regionas[Suma])","v":{"v":346000,"d":"346,000.00 EUR"}},{"$f":"SUBTOTAL(109,Regionas[%])","v":{"v":1,"d":"100%"}}]