{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["PRADŽIA","SUPLANUOTOS IŠLAIDOS","FAKTINĖS IŠLAIDOS","IŠLAIDŲ NUOKRYPIAI","IŠLAIDŲ ANALIZĖ"],"not_rendered":{"charts":2,"images":3,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"PRADŽIA","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"APIE ŠĮ ŠABLONĄ"]
[null,"Naudokite šią verslo išlaidų biudžeto darbaknygę norėdami stebėti suplanuotas ir faktines išlaidas bei nuokrypius."]
[null,"Įveskite įmonės pavadinimą ir pridėkite logotipą."]
[null,"Įveskite informaciją į lenteles darbalapiuose Suplanuotos išlaidos ir Faktinės išlaidos."]
[null,"Automatiškai atnaujinamos darbalapio Išlaidų nuokrypiai lentelės ir darbalapio Išlaidų analizė diagramos"]
[null,"Pastaba: "]
[null,"Papildomos instrukcijos pateikiamos kiekvieno darbalapio A stulpelyje. Šis tekstas buvo specialiai paslėptas. Norėdami pašalinti tekstą, pasirinkite A stulpelį, tada pasirinkite Naikinti. Norėdami nebeslėpti teksto, pasirinkite A stulpelį, tada pakeiskite šrifto spalvą."]
[null,"Norėdami sužinoti daugiau apie lenteles, lentelėje paspauskite SHIFT, tada – F10, pasirinkite parinktį LENTELĖ, tada pasirinkite ALTERNATYVUSIS TEKSTAS"]

{"sheet":"SUPLANUOTOS IŠLAIDOS","index":1,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,10,1,12],[2,10,2,12],[3,17,12,19]]}
[{"$nulls":15}," "]
[null,"Įmonės pavadinimas",{"$nulls":8},"Išsamios apskaičiuotos išlaidos"]
[{"$nulls":10},"Patamsinti langeliai yra apskaičiuotos vertės."]
[null,"SUPLANUOTOS IŠLAIDOS","SAU","VAS","KOV","BAL","GEG","BIR","LIE","RGP","RGS","SPL","LAP","GRD","METAI"]
[null,"Darbuotojų išlaidos","Sau","Vas","Kov","Bal","Geg","Bir","Lie","Rgp","Rgs","Spl","Lap","Grd","METAI"]
[null,"Darbo užmokesčiai",{"v":85000,"d":"85,000.00 EUR"},{"v":85000,"d":"85,000.00 EUR"},{"v":85000,"d":"85,000.00 EUR"},{"v":87500,"d":"87,500.00 EUR"},{"v":87500,"d":"87,500.00 EUR"},{"v":87500,"d":"87,500.00 EUR"},{"v":87500,"d":"87,500.00 EUR"},{"v":92400,"d":"92,400.00 EUR"},{"v":92400,"d":"92,400.00 EUR"},{"v":92400,"d":"92,400.00 EUR"},{"v":92400,"d":"92,400.00 EUR"},{"v":92400,"d":"92,400.00 EUR"},{"$f":"SUM(C6:N6)","v":{"v":1067000,"d":"1,067,000.00 EUR"}}]
[null,"Išmokos",{"$f":"C6*0.27","v":{"v":22950,"d":"22,950.00 EUR"}},{"v":22950,"d":"22,950.00 EUR"},{"v":22950,"d":"22,950.00 EUR"},{"v":23625,"d":"23,625.00 EUR"},{"v":23625,"d":"23,625.00 EUR"},{"v":23625,"d":"23,625.00 EUR"},{"v":23625,"d":"23,625.00 EUR"},{"v":24948,"d":"24,948.00 EUR"},{"v":24948,"d":"24,948.00 EUR"},{"v":24948,"d":"24,948.00 EUR"},{"v":24948,"d":"24,948.00 EUR"},{"v":24948,"d":"24,948.00 EUR"},{"$f":"SUM(C7:N7)","v":{"v":288090,"d":"288,090.00 EUR"}}]
[null,"Tarpinė suma",{"$f":"SUBTOTAL(109,EmployeePlan[Sau])","v":{"v":107950,"d":"107,950.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeePlan[Vas])","v":{"v":107950,"d":"107,950.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeePlan[Kov])","v":{"v":107950,"d":"107,950.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeePlan[Bal])","v":{"v":111125,"d":"111,125.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeePlan[Geg])","v":{"v":111125,"d":"111,125.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeePlan[Bir])","v":{"v":111125,"d":"111,125.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeePlan[Lie])","v":{"v":111125,"d":"111,125.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeePlan[Rgp])","v":{"v":117348,"d":"117,348.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeePlan[Rgs])","v":{"v":117348,"d":"117,348.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeePlan[Spl])","v":{"v":117348,"d":"117,348.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeePlan[Lap])","v":{"v":117348,"d":"117,348.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeePlan[Grd])","v":{"v":117348,"d":"117,348.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeePlan[METAI])","v":{"v":1355090,"d":"1,355,090.00 EUR"}}]
[]
[null,"Biuro išlaidos","Sau","Vas","Kov","Bal","Geg","Bir","Lie","Rgp","Rgs","Spl","Lap","Grd","METAI"]
[null,"Biuro nuoma",{"v":9800,"d":"9,800.00 EUR"},{"v":9800,"d":"9,800.00 EUR"},{"v":9800,"d":"9,800.00 EUR"},{"v":9800,"d":"9,800.00 EUR"},{"v":9800,"d":"9,800.00 EUR"},{"v":9800,"d":"9,800.00 EUR"},{"v":9800,"d":"9,800.00 EUR"},{"v":9800,"d":"9,800.00 EUR"},{"v":9800,"d":"9,800.00 EUR"},{"v":9800,"d":"9,800.00 EUR"},{"v":9800,"d":"9,800.00 EUR"},{"v":9800,"d":"9,800.00 EUR"},{"$f":"SUM(C11:N11)","v":{"v":117600,"d":"117,600.00 EUR"}}]
[null,"Dujos",null,{"v":400,"d":"400.00 EUR"},{"v":400,"d":"400.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":400,"d":"400.00 EUR"},{"v":400,"d":"400.00 EUR"},{"v":2300,"d":"2,300.00 EUR"}]
[null,"Elektra",{"v":300,"d":"300.00 EUR"},{"v":300,"d":"300.00 EUR"},{"v":300,"d":"300.00 EUR"},{"v":300,"d":"300.00 EUR"},{"v":300,"d":"300.00 EUR"},{"v":300,"d":"300.00 EUR"},{"v":300,"d":"300.00 EUR"},{"v":300,"d":"300.00 EUR"},{"v":300,"d":"300.00 EUR"},{"v":300,"d":"300.00 EUR"},{"v":300,"d":"300.00 EUR"},{"v":300,"d":"300.00 EUR"},{"v":3600,"d":"3,600.00 EUR"}]
[null,"Vanduo",{"v":40,"d":"40.00 EUR"},{"v":40,"d":"40.00 EUR"},{"v":40,"d":"40.00 EUR"},{"v":40,"d":"40.00 EUR"},{"v":40,"d":"40.00 EUR"},{"v":40,"d":"40.00 EUR"},{"v":40,"d":"40.00 EUR"},{"v":40,"d":"40.00 EUR"},{"v":40,"d":"40.00 EUR"},{"v":40,"d":"40.00 EUR"},{"v":40,"d":"40.00 EUR"},{"v":40,"d":"40.00 EUR"},{"v":480,"d":"480.00 EUR"}]
[null,"Telefonas",{"v":250,"d":"250.00 EUR"},{"v":250,"d":"250.00 EUR"},{"v":250,"d":"250.00 EUR"},{"v":250,"d":"250.00 EUR"},{"v":250,"d":"250.00 EUR"},{"v":250,"d":"250.00 EUR"},{"v":250,"d":"250.00 EUR"},{"v":250,"d":"250.00 EUR"},{"v":250,"d":"250.00 EUR"},{"v":250,"d":"250.00 EUR"},{"v":250,"d":"250.00 EUR"},{"v":250,"d":"250.00 EUR"},{"v":3000,"d":"3,000.00 EUR"}]
[null,"Interneto prieiga",{"v":180,"d":"180.00 EUR"},{"v":180,"d":"180.00 EUR"},{"v":180,"d":"180.00 EUR"},{"v":180,"d":"180.00 EUR"},{"v":180,"d":"180.00 EUR"},{"v":180,"d":"180.00 EUR"},{"v":180,"d":"180.00 EUR"},{"v":180,"d":"180.00 EUR"},{"v":180,"d":"180.00 EUR"},{"v":180,"d":"180.00 EUR"},{"v":180,"d":"180.00 EUR"},{"v":180,"d":"180.00 EUR"},{"v":2160,"d":"2,160.00 EUR"}]
[null,"Biuro reikmenys",{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":2400,"d":"2,400.00 EUR"}]
[null,"Apsauga",{"v":600,"d":"600.00 EUR"},{"v":600,"d":"600.00 EUR"},{"v":600,"d":"600.00 EUR"},{"v":600,"d":"600.00 EUR"},{"v":600,"d":"600.00 EUR"},{"v":600,"d":"600.00 EUR"},{"v":600,"d":"600.00 EUR"},{"v":600,"d":"600.00 EUR"},{"v":600,"d":"600.00 EUR"},{"v":600,"d":"600.00 EUR"},{"v":600,"d":"600.00 EUR"},{"v":600,"d":"600.00 EUR"},{"v":7200,"d":"7,200.00 EUR"}]
[null,"Tarpinė suma",{"$f":"SUBTOTAL(109,OfficePlan[Sau])","v":{"v":11370,"d":"11,370.00 EUR"}},{"$f":"SUBTOTAL(109,OfficePlan[Vas])","v":{"v":11770,"d":"11,770.00 EUR"}},{"$f":"SUBTOTAL(109,OfficePlan[Kov])","v":{"v":11770,"d":"11,770.00 EUR"}},{"$f":"SUBTOTAL(109,OfficePlan[Bal])","v":{"v":11470,"d":"11,470.00 EUR"}},{"$f":"SUBTOTAL(109,OfficePlan[Geg])","v":{"v":11470,"d":"11,470.00 EUR"}},{"$f":"SUBTOTAL(109,OfficePlan[Bir])","v":{"v":11470,"d":"11,470.00 EUR"}},{"$f":"SUBTOTAL(109,OfficePlan[Lie])","v":{"v":11470,"d":"11,470.00 EUR"}},{"$f":"SUBTOTAL(109,OfficePlan[Rgp])","v":{"v":11470,"d":"11,470.00 EUR"}},{"$f":"SUBTOTAL(109,OfficePlan[Rgs])","v":{"v":11470,"d":"11,470.00 EUR"}},{"$f":"SUBTOTAL(109,OfficePlan[Spl])","v":{"v":11470,"d":"11,470.00 EUR"}},{"$f":"SUBTOTAL(109,OfficePlan[Lap])","v":{"v":11770,"d":"11,770.00 EUR"}},{"$f":"SUBTOTAL(109,OfficePlan[Grd])","v":{"v":11770,"d":"11,770.00 EUR"}},{"$f":"SUBTOTAL(109,OfficePlan[METAI])","v":{"v":138740,"d":"138,740.00 EUR"}}]
[]
[null,"Rinkodaros išlaidos","Sau","Vas","Kov","Bal","Geg","Bir","Lie","Rgp","Rgs","Spl","Lap","Grd","METAI"]
[null,"Svetainės išteklių nuoma",{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"$f":"SUM(C22:N22)","v":{"v":6000,"d":"6,000.00 EUR"}}]
[null,"Svetainės naujinimai",{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":1000,"d":"1,000.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":1000,"d":"1,000.00 EUR"},{"v":4000,"d":"4,000.00 EUR"}]
[null,"Dokumentų parengimas",{"v":5000,"d":"5,000.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":5000,"d":"5,000.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":5000,"d":"5,000.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":5000,"d":"5,000.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":20000,"d":"20,000.00 EUR"}]
[null,"Dokumentų spausdinimas",{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":2400,"d":"2,400.00 EUR"}]
[null,"Rinkodaros įvykiai",{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":5000,"d":"5,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":5000,"d":"5,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":5000,"d":"5,000.00 EUR"},{"v":33000,"d":"33,000.00 EUR"}]
[null,"Įvairios išlaidos",{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":2400,"d":"2,400.00 EUR"}]
[null,"Tarpinė suma",{"$f":"SUBTOTAL(109,MarketingPlan[Sau])","v":{"v":8100,"d":"8,100.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingPlan[Vas])","v":{"v":3100,"d":"3,100.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingPlan[Kov])","v":{"v":3100,"d":"3,100.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingPlan[Bal])","v":{"v":11100,"d":"11,100.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingPlan[Geg])","v":{"v":3100,"d":"3,100.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingPlan[Bir])","v":{"v":3900,"d":"3,900.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingPlan[Lie])","v":{"v":8100,"d":"8,100.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingPlan[Rgp])","v":{"v":6100,"d":"6,100.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingPlan[Rgs])","v":{"v":3100,"d":"3,100.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingPlan[Spl])","v":{"v":8100,"d":"8,100.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingPlan[Lap])","v":{"v":3100,"d":"3,100.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingPlan[Grd])","v":{"v":6900,"d":"6,900.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingPlan[METAI])","v":{"v":67800,"d":"67,800.00 EUR"}}]
[]
[null,"Mokymas / kelionės","Sau","Vas","Kov","Bal","Geg","Bir","Lie","Rgp","Rgs","Spl","Lap","Grd","METAI"]
[null,"Mokymo klasės",{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"$f":"SUM(C31:N31)","v":{"v":24000,"d":"24,000.00 EUR"}}]
[null,"Su mokymu susijusios kelionių išlaidos",{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"v":2000,"d":"2,000.00 EUR"},{"$f":"SUM(C32:N32)","v":{"v":24000,"d":"24,000.00 EUR"}}]
[null,"Tarpinė suma",{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Sau])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Vas])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Kov])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Bal])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Geg])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Bir])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Lie])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Rgp])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Rgs])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Spl])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Lap])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Grd])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[METAI])","v":{"v":48000,"d":"48,000.00 EUR"}}]
[]
[null,"BENDROSIOS SUMOS","Sau","Vas","Kov","Bal","Geg","Bir","Lie","Rgp","Rgs","Spl","Lap","Grd","Metai"]
[null,"Suplanuotos mėnesio išlaidos",{"$f":"TrainingAndTravelPlan[[#Totals],[Sau]]+MarketingPlan[[#Totals],[Sau]]+OfficePlan[[#Totals],[Sau]]+EmployeePlan[[#Totals],[Sau]]","v":{"v":131420,"d":"131,420.00 EUR"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Vas]]+MarketingPlan[[#Totals],[Vas]]+OfficePlan[[#Totals],[Vas]]+EmployeePlan[[#Totals],[Vas]]","v":{"v":126820,"d":"126,820.00 EUR"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Kov]]+MarketingPlan[[#Totals],[Kov]]+OfficePlan[[#Totals],[Kov]]+EmployeePlan[[#Totals],[Kov]]","v":{"v":126820,"d":"126,820.00 EUR"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Bal]]+MarketingPlan[[#Totals],[Bal]]+OfficePlan[[#Totals],[Bal]]+EmployeePlan[[#Totals],[Bal]]","v":{"v":137695,"d":"137,695.00 EUR"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Geg]]+MarketingPlan[[#Totals],[Geg]]+OfficePlan[[#Totals],[Geg]]+EmployeePlan[[#Totals],[Geg]]","v":{"v":129695,"d":"129,695.00 EUR"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Bir]]+MarketingPlan[[#Totals],[Bir]]+OfficePlan[[#Totals],[Bir]]+EmployeePlan[[#Totals],[Bir]]","v":{"v":130495,"d":"130,495.00 EUR"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Lie]]+MarketingPlan[[#Totals],[Lie]]+OfficePlan[[#Totals],[Lie]]+EmployeePlan[[#Totals],[Lie]]","v":{"v":134695,"d":"134,695.00 EUR"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Rgp]]+MarketingPlan[[#Totals],[Rgp]]+OfficePlan[[#Totals],[Rgp]]+EmployeePlan[[#Totals],[Rgp]]","v":{"v":138918,"d":"138,918.00 EUR"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Rgs]]+MarketingPlan[[#Totals],[Rgs]]+OfficePlan[[#Totals],[Rgs]]+EmployeePlan[[#Totals],[Rgs]]","v":{"v":135918,"d":"135,918.00 EUR"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Spl]]+MarketingPlan[[#Totals],[Spl]]+OfficePlan[[#Totals],[Spl]]+EmployeePlan[[#Totals],[Spl]]","v":{"v":140918,"d":"140,918.00 EUR"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Lap]]+MarketingPlan[[#Totals],[Lap]]+OfficePlan[[#Totals],[Lap]]+EmployeePlan[[#Totals],[Lap]]","v":{"v":136218,"d":"136,218.00 EUR"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Grd]]+MarketingPlan[[#Totals],[Grd]]+OfficePlan[[#Totals],[Grd]]+EmployeePlan[[#Totals],[Grd]]","v":{"v":140018,"d":"140,018.00 EUR"}},{"$f":"TrainingAndTravelPlan[[#Totals],[METAI]]+MarketingPlan[[#Totals],[METAI]]+OfficePlan[[#Totals],[METAI]]+EmployeePlan[[#Totals],[METAI]]","v":{"v":1609630,"d":"1,609,630.00 EUR"}}]
[null,"Suplanuotų išlaidų BENDROJI SUMA",{"$f":"SUM($C$36:C36)","v":{"v":131420,"d":"131,420.00 EUR"}},{"$f":"SUM($C$36:D36)","v":{"v":258240,"d":"258,240.00 EUR"}},{"$f":"SUM($C$36:E36)","v":{"v":385060,"d":"385,060.00 EUR"}},{"$f":"SUM($C$36:F36)","v":{"v":522755,"d":"522,755.00 EUR"}},{"$f":"SUM($C$36:G36)","v":{"v":652450,"d":"652,450.00 EUR"}},{"$f":"SUM($C$36:H36)","v":{"v":782945,"d":"782,945.00 EUR"}},{"$f":"SUM($C$36:I36)","v":{"v":917640,"d":"917,640.00 EUR"}},{"$f":"SUM($C$36:J36)","v":{"v":1056558,"d":"1,056,558.00 EUR"}},{"$f":"SUM($C$36:K36)","v":{"v":1192476,"d":"1,192,476.00 EUR"}},{"$f":"SUM($C$36:L36)","v":{"v":1333394,"d":"1,333,394.00 EUR"}},{"$f":"SUM($C$36:M36)","v":{"v":1469612,"d":"1,469,612.00 EUR"}},{"$f":"SUM($C$36:N36)","v":{"v":1609630,"d":"1,609,630.00 EUR"}}]

{"sheet":"FAKTINĖS IŠLAIDOS","index":2,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,10,1,12],[2,10,2,12]]}
[{"$nulls":15}," "]
[null,{"$f":"'SUPLANUOTOS IŠLAIDOS'!B2:D3","v":"Įmonės pavadinimas"},{"$nulls":8},{"$f":"darbalapio_pavadinimas","v":"Išsamios apskaičiuotos išlaidos"}]
[{"$nulls":10},"Patamsinti langeliai yra apskaičiuotos vertės."]
[null,"FAKTINĖS IŠLAIDOS","SAU","VAS","KOV","BAL","GEG","BIR","LIE","RGP","RGS","SPL","LAP","GRD","METAI"]
[null,"Darbuotojų išlaidos","Sau","Vas","Kov","Bal","Geg","Bir","Lie","Rgp","Rgs","Spl","Lap","Grd","METAI"]
[null,"Darbo užmokesčiai",{"v":85000,"d":"85,000.00 EUR"},{"v":85000,"d":"85,000.00 EUR"},{"v":85000,"d":"85,000.00 EUR"},{"v":88000,"d":"88,000.00 EUR"},{"v":88000,"d":"88,000.00 EUR"},{"v":88000,"d":"88,000.00 EUR"},{"$nulls":6},{"$f":"SUM(C6:N6)","v":{"v":519000,"d":"519,000.00 EUR"}}]
[null,"Išmokos",{"$f":"C6*0.27","v":{"v":22950,"d":"22,950.00 EUR"}},{"v":22950,"d":"22,950.00 EUR"},{"v":22950,"d":"22,950.00 EUR"},{"v":23760,"d":"23,760.00 EUR"},{"v":23760,"d":"23,760.00 EUR"},{"v":23760,"d":"23,760.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$f":"SUM(C7:N7)","v":{"v":140130,"d":"140,130.00 EUR"}}]
[null,"Tarpinė suma",{"$f":"SUBTOTAL(109,EmployeeActual[Sau])","v":{"v":107950,"d":"107,950.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeActual[Vas])","v":{"v":107950,"d":"107,950.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeActual[Kov])","v":{"v":107950,"d":"107,950.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeActual[Bal])","v":{"v":111760,"d":"111,760.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeActual[Geg])","v":{"v":111760,"d":"111,760.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeActual[Bir])","v":{"v":111760,"d":"111,760.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeActual[Lie])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeActual[Rgp])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeActual[Rgs])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeActual[Spl])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeActual[Lap])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeActual[Grd])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeActual[METAI])","v":{"v":659130,"d":"659,130.00 EUR"}}]
[]
[null,"Biuro išlaidos","Sau","Vas","Kov","Bal","Geg","Bir","Lie","Rgp","Rgs","Spl","Lap","Grd","METAI"]
[null,"Biuro nuoma",{"v":9800,"d":"9,800.00 EUR"},{"v":9800,"d":"9,800.00 EUR"},{"v":9800,"d":"9,800.00 EUR"},{"v":9800,"d":"9,800.00 EUR"},{"v":9800,"d":"9,800.00 EUR"},{"v":9800,"d":"9,800.00 EUR"},{"$nulls":6},{"$f":"SUM(C11:N11)","v":{"v":58800,"d":"58,800.00 EUR"}}]
[null,"Dujos",{"v":4,"d":"4.00 EUR"},{"v":430,"d":"430.00 EUR"},{"v":385,"d":"385.00 EUR"},{"v":230,"d":"230.00 EUR"},{"v":87,"d":"87.00 EUR"},{"v":88,"d":"88.00 EUR"},{"$nulls":6},{"v":1224,"d":"1,224.00 EUR"}]
[null,"Elektra",{"v":288,"d":"288.00 EUR"},{"v":278,"d":"278.00 EUR"},{"v":268,"d":"268.00 EUR"},{"v":299,"d":"299.00 EUR"},{"v":306,"d":"306.00 EUR"},{"v":290,"d":"290.00 EUR"},{"$nulls":6},{"v":1729,"d":"1,729.00 EUR"}]
[null,"Vanduo",{"v":35,"d":"35.00 EUR"},{"v":33,"d":"33.00 EUR"},{"v":34,"d":"34.00 EUR"},{"v":36,"d":"36.00 EUR"},{"v":34,"d":"34.00 EUR"},{"v":36,"d":"36.00 EUR"},{"$nulls":6},{"v":208,"d":"208.00 EUR"}]
[null,"Telefonas",{"v":224,"d":"224.00 EUR"},{"v":235,"d":"235.00 EUR"},{"v":265,"d":"265.00 EUR"},{"v":245,"d":"245.00 EUR"},{"v":245,"d":"245.00 EUR"},{"v":220,"d":"220.00 EUR"},{"$nulls":6},{"v":1434,"d":"1,434.00 EUR"}]
[null,"Interneto prieiga",{"v":180,"d":"180.00 EUR"},{"v":180,"d":"180.00 EUR"},{"v":180,"d":"180.00 EUR"},{"v":180,"d":"180.00 EUR"},{"v":180,"d":"180.00 EUR"},{"v":180,"d":"180.00 EUR"},{"$nulls":6},{"v":1080,"d":"1,080.00 EUR"}]
[null,"Biuro reikmenys",{"v":256,"d":"256.00 EUR"},{"v":142,"d":"142.00 EUR"},{"v":160,"d":"160.00 EUR"},{"v":221,"d":"221.00 EUR"},{"v":256,"d":"256.00 EUR"},{"v":240,"d":"240.00 EUR"},{"$nulls":6},{"v":1275,"d":"1,275.00 EUR"}]
[null,"Apsauga",{"v":600,"d":"600.00 EUR"},{"v":600,"d":"600.00 EUR"},{"v":600,"d":"600.00 EUR"},{"v":600,"d":"600.00 EUR"},{"v":600,"d":"600.00 EUR"},{"v":600,"d":"600.00 EUR"},{"$nulls":6},{"v":3600,"d":"3,600.00 EUR"}]
[null,"Tarpinė suma",{"$f":"SUBTOTAL(109,OfficeActual[Sau])","v":{"v":11387,"d":"11,387.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeActual[Vas])","v":{"v":11698,"d":"11,698.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeActual[Kov])","v":{"v":11692,"d":"11,692.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeActual[Bal])","v":{"v":11611,"d":"11,611.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeActual[Geg])","v":{"v":11508,"d":"11,508.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeActual[Bir])","v":{"v":11454,"d":"11,454.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeActual[Lie])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeActual[Rgp])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeActual[Rgs])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeActual[Spl])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeActual[Lap])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeActual[Grd])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeActual[METAI])","v":{"v":69350,"d":"69,350.00 EUR"}}]
[]
[null,"Rinkodaros išlaidos","Sau","Vas","Kov","Bal","Geg","Bir","Lie","Rgp","Rgs","Spl","Lap","Grd","METAI"]
[null,"Svetainės išteklių nuoma",{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"$nulls":6},{"$f":"SUM(C22:N22)","v":{"v":3000,"d":"3,000.00 EUR"}}]
[null,"Svetainės naujinimai",{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":1500,"d":"1,500.00 EUR"},{"$nulls":6},{"v":2500,"d":"2,500.00 EUR"}]
[null,"Dokumentų parengimas",{"v":4800,"d":"4,800.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":5500,"d":"5,500.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"v":10300,"d":"10,300.00 EUR"}]
[null,"Dokumentų spausdinimas",{"v":100,"d":"100.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":600,"d":"600.00 EUR"},{"v":180,"d":"180.00 EUR"},{"$nulls":6},{"v":1580,"d":"1,580.00 EUR"}]
[null,"Rinkodaros įvykiai",{"v":1800,"d":"1,800.00 EUR"},{"v":2200,"d":"2,200.00 EUR"},{"v":2200,"d":"2,200.00 EUR"},{"v":4700,"d":"4,700.00 EUR"},{"v":1500,"d":"1,500.00 EUR"},{"v":2300,"d":"2,300.00 EUR"},{"$nulls":6},{"v":14700,"d":"14,700.00 EUR"}]
[null,"Įvairios išlaidos",{"v":145,"d":"145.00 EUR"},{"v":156,"d":"156.00 EUR"},{"v":123,"d":"123.00 EUR"},{"v":223,"d":"223.00 EUR"},{"v":187,"d":"187.00 EUR"},{"v":245,"d":"245.00 EUR"},{"$nulls":6},{"v":1079,"d":"1,079.00 EUR"}]
[null,"Tarpinė suma",{"$f":"SUBTOTAL(109,MarketingActual[Sau])","v":{"v":7545,"d":"7,545.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingActual[Vas])","v":{"v":3556,"d":"3,556.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingActual[Kov])","v":{"v":3123,"d":"3,123.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingActual[Bal])","v":{"v":11223,"d":"11,223.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingActual[Geg])","v":{"v":2987,"d":"2,987.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingActual[Bir])","v":{"v":4725,"d":"4,725.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingActual[Lie])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingActual[Rgp])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingActual[Rgs])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingActual[Spl])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingActual[Lap])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingActual[Grd])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingActual[METAI])","v":{"v":33159,"d":"33,159.00 EUR"}}]
[]
[null,"Mokymas / kelionės","Sau","Vas","Kov","Bal","Geg","Bir","Lie","Rgp","Rgs","Spl","Lap","Grd","METAI"]
[null,"Mokymo klasės",{"v":1600,"d":"1,600.00 EUR"},{"v":2400,"d":"2,400.00 EUR"},{"v":1400,"d":"1,400.00 EUR"},{"v":1600,"d":"1,600.00 EUR"},{"v":1200,"d":"1,200.00 EUR"},{"v":2800,"d":"2,800.00 EUR"},{"$nulls":6},{"$f":"SUM(C31:N31)","v":{"v":11000,"d":"11,000.00 EUR"}}]
[null,"Su mokymu susijusios kelionių išlaidos",{"v":1200,"d":"1,200.00 EUR"},{"v":2200,"d":"2,200.00 EUR"},{"v":1400,"d":"1,400.00 EUR"},{"v":1200,"d":"1,200.00 EUR"},{"v":800,"d":"800.00 EUR"},{"v":3500,"d":"3,500.00 EUR"},{"$nulls":6},{"$f":"SUM(C32:N32)","v":{"v":10300,"d":"10,300.00 EUR"}}]
[null,"Tarpinė suma",{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Sau])","v":{"v":2800,"d":"2,800.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Vas])","v":{"v":4600,"d":"4,600.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Kov])","v":{"v":2800,"d":"2,800.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Bal])","v":{"v":2800,"d":"2,800.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Geg])","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Bir])","v":{"v":6300,"d":"6,300.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Lie])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Rgp])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Rgs])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Spl])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Lap])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Grd])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[METAI])","v":{"v":21300,"d":"21,300.00 EUR"}}]
[]
[null,"Suplanuotų išlaidų BENDROJI SUMA","Sau","Vas","Kov","Bal","Geg","Bir","Lie","Rgp","Rgs","Spl","Lap","Grd","Metai"]
[null,"Faktinės mėnesio išlaidos",{"$f":"TrainingAndTravelActual[[#Totals],[Sau]]+MarketingActual[[#Totals],[Sau]]+OfficeActual[[#Totals],[Sau]]+EmployeeActual[[#Totals],[Sau]]","v":{"v":129682,"d":"129,682.00 EUR"}},{"$f":"TrainingAndTravelActual[[#Totals],[Vas]]+MarketingActual[[#Totals],[Vas]]+OfficeActual[[#Totals],[Vas]]+EmployeeActual[[#Totals],[Vas]]","v":{"v":127804,"d":"127,804.00 EUR"}},{"$f":"TrainingAndTravelActual[[#Totals],[Kov]]+MarketingActual[[#Totals],[Kov]]+OfficeActual[[#Totals],[Kov]]+EmployeeActual[[#Totals],[Kov]]","v":{"v":125565,"d":"125,565.00 EUR"}},{"$f":"TrainingAndTravelActual[[#Totals],[Bal]]+MarketingActual[[#Totals],[Bal]]+OfficeActual[[#Totals],[Bal]]+EmployeeActual[[#Totals],[Bal]]","v":{"v":137394,"d":"137,394.00 EUR"}},{"$f":"TrainingAndTravelActual[[#Totals],[Geg]]+MarketingActual[[#Totals],[Geg]]+OfficeActual[[#Totals],[Geg]]+EmployeeActual[[#Totals],[Geg]]","v":{"v":128255,"d":"128,255.00 EUR"}},{"$f":"TrainingAndTravelActual[[#Totals],[Bir]]+MarketingActual[[#Totals],[Bir]]+OfficeActual[[#Totals],[Bir]]+EmployeeActual[[#Totals],[Bir]]","v":{"v":134239,"d":"134,239.00 EUR"}},{"$f":"TrainingAndTravelActual[[#Totals],[Lie]]+MarketingActual[[#Totals],[Lie]]+OfficeActual[[#Totals],[Lie]]+EmployeeActual[[#Totals],[Lie]]","v":{"v":0,"d":"0.00 EUR"}},{"$f":"TrainingAndTravelActual[[#Totals],[Rgp]]+MarketingActual[[#Totals],[Rgp]]+OfficeActual[[#Totals],[Rgp]]+EmployeeActual[[#Totals],[Rgp]]","v":{"v":0,"d":"0.00 EUR"}},{"$f":"TrainingAndTravelActual[[#Totals],[Rgs]]+MarketingActual[[#Totals],[Rgs]]+OfficeActual[[#Totals],[Rgs]]+EmployeeActual[[#Totals],[Rgs]]","v":{"v":0,"d":"0.00 EUR"}},{"$f":"TrainingAndTravelActual[[#Totals],[Spl]]+MarketingActual[[#Totals],[Spl]]+OfficeActual[[#Totals],[Spl]]+EmployeeActual[[#Totals],[Spl]]","v":{"v":0,"d":"0.00 EUR"}},{"$f":"TrainingAndTravelActual[[#Totals],[Lap]]+MarketingActual[[#Totals],[Lap]]+OfficeActual[[#Totals],[Lap]]+EmployeeActual[[#Totals],[Lap]]","v":{"v":0,"d":"0.00 EUR"}},{"$f":"TrainingAndTravelActual[[#Totals],[Grd]]+MarketingActual[[#Totals],[Grd]]+OfficeActual[[#Totals],[Grd]]+EmployeeActual[[#Totals],[Grd]]","v":{"v":0,"d":"0.00 EUR"}},{"$f":"TrainingAndTravelActual[[#Totals],[METAI]]+MarketingActual[[#Totals],[METAI]]+OfficeActual[[#Totals],[METAI]]+EmployeeActual[[#Totals],[METAI]]","v":{"v":782939,"d":"782,939.00 EUR"}}]
[null,"Faktinių išlaidų BENDROJI SUMA",{"$f":"SUM($C$36:C36)","v":{"v":129682,"d":"129,682.00 EUR"}},{"$f":"SUM($C$36:D36)","v":{"v":257486,"d":"257,486.00 EUR"}},{"$f":"SUM($C$36:E36)","v":{"v":383051,"d":"383,051.00 EUR"}},{"$f":"SUM($C$36:F36)","v":{"v":520445,"d":"520,445.00 EUR"}},{"$f":"SUM($C$36:G36)","v":{"v":648700,"d":"648,700.00 EUR"}},{"$f":"SUM($C$36:H36)","v":{"v":782939,"d":"782,939.00 EUR"}},{"$f":"SUM($C$36:I36)","v":{"v":782939,"d":"782,939.00 EUR"}},{"$f":"SUM($C$36:J36)","v":{"v":782939,"d":"782,939.00 EUR"}},{"$f":"SUM($C$36:K36)","v":{"v":782939,"d":"782,939.00 EUR"}},{"$f":"SUM($C$36:L36)","v":{"v":782939,"d":"782,939.00 EUR"}},{"$f":"SUM($C$36:M36)","v":{"v":782939,"d":"782,939.00 EUR"}},{"$f":"SUM($C$36:N36)","v":{"v":782939,"d":"782,939.00 EUR"}}]

{"sheet":"IŠLAIDŲ NUOKRYPIAI","index":3,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,10,1,12],[2,10,2,12]]}
[{"$nulls":15}," "]
[null,{"$f":"'SUPLANUOTOS IŠLAIDOS'!B2:D3","v":"Įmonės pavadinimas"},{"$nulls":8},{"$f":"darbalapio_pavadinimas","v":"Išsamios apskaičiuotos išlaidos"}]
[{"$nulls":10},"Patamsinti langeliai yra apskaičiuotos vertės."]
[null,"IŠLAIDŲ NUOKRYPIAI","SAU","VAS","KOV","BAL","GEG","BIR","LIE","RGP","RGS","SPL","LAP","GRD","METAI"]
[null,"Darbuotojų išlaidos","Sau","Vas","Kov","Bal","Geg","Bir","Lie","Rgp","Rgs","Spl","Lap","Grd","METAI"]
[null,"Darbo užmokesčiai",{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Sau]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Sau]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Sau]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Sau]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Vas]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Vas]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Vas]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Vas]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Kov]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Kov]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Kov]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Kov]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Bal]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Bal]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Bal]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Bal]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"-500.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Geg]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Geg]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Geg]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Geg]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"-500.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Bir]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Bir]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Bir]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Bir]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"-500.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Lie]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Lie]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Lie]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Lie]],EmployeeActual[#Headers],0))","v":{"v":87500,"d":"87,500.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Rgp]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Rgp]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Rgp]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Rgp]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"92,400.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Rgs]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Rgs]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Rgs]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Rgs]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"92,400.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Spl]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Spl]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Spl]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Spl]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"92,400.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Lap]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Lap]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Lap]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Lap]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"92,400.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Grd]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Grd]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Grd]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Grd]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"92,400.00 EUR"}},{"$f":"SUM(EmployeeVariances[[#This Row],[Sau]:[Grd]])","v":{"v":548000,"d":"548,000.00 EUR"}}]
[null,"Išmokos",{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Sau]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Sau]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Sau]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Sau]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Vas]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Vas]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Vas]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Vas]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Kov]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Kov]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Kov]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Kov]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Bal]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Bal]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Bal]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Bal]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"-135.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Geg]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Geg]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Geg]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Geg]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"-135.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Bir]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Bir]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Bir]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Bir]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"-135.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Lie]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Lie]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Lie]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Lie]],EmployeeActual[#Headers],0))","v":{"v":23625,"d":"23,625.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Rgp]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Rgp]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Rgp]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Rgp]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"24,948.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Rgs]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Rgs]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Rgs]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Rgs]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"24,948.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Spl]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Spl]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Spl]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Spl]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"24,948.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Lap]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Lap]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Lap]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Lap]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"24,948.00 EUR"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Grd]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Grd]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Grd]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Grd]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"24,948.00 EUR"}},{"$f":"SUM(EmployeeVariances[[#This Row],[Sau]:[Grd]])","v":{"v":147960,"d":"147,960.00 EUR"}}]
[null,"Tarpinė suma",{"$f":"SUBTOTAL(109,EmployeeVariances[Sau])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Vas])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Kov])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Bal])","v":{"v":-635,"d":"-635.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Geg])","v":{"v":-635,"d":"-635.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Bir])","v":{"v":-635,"d":"-635.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Lie])","v":{"v":111125,"d":"111,125.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Rgp])","v":{"v":117348,"d":"117,348.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Rgs])","v":{"v":117348,"d":"117,348.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Spl])","v":{"v":117348,"d":"117,348.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Lap])","v":{"v":117348,"d":"117,348.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Grd])","v":{"v":117348,"d":"117,348.00 EUR"}},{"$f":"SUBTOTAL(109,EmployeeVariances[METAI])","v":{"v":695960,"d":"695,960.00 EUR"}}]
[]
[null,"Biuro išlaidos","Sau","Vas","Kov","Bal","Geg","Bir","Lie","Rgp","Rgs","Spl","Lap","Grd","METAI"]
[null,"Biuro nuoma",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sau]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sau]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sau]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sau]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Vas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Vas]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Vas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Vas]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kov]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kov]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bal]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bal]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bal]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bal]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Geg]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Geg]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Geg]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Geg]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bir]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bir]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bir]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bir]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lie]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lie]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lie]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lie]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"9,800.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgp]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgp]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"9,800.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgs]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgs]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgs]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgs]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"9,800.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Spl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Spl]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Spl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Spl]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"9,800.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lap]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lap]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lap]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lap]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"9,800.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Grd]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Grd]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Grd]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Grd]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"9,800.00 EUR"}},{"$f":"SUM(OfficeVariances[[#This Row],[Sau]:[Grd]])","v":{"v":58800,"d":"58,800.00 EUR"}}]
[null,"Dujos",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sau]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sau]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sau]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sau]],OfficeActual[#Headers],0))","v":{"v":-4,"d":"-4.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Vas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Vas]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Vas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Vas]],OfficeActual[#Headers],0))","v":{"v":-30,"d":"-30.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kov]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kov]],OfficeActual[#Headers],0))","v":{"v":15,"d":"15.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bal]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bal]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bal]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bal]],OfficeActual[#Headers],0))","v":{"v":-130,"d":"-130.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Geg]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Geg]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Geg]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Geg]],OfficeActual[#Headers],0))","v":{"v":13,"d":"13.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bir]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bir]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bir]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bir]],OfficeActual[#Headers],0))","v":{"v":12,"d":"12.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lie]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lie]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lie]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lie]],OfficeActual[#Headers],0))","v":{"v":100,"d":"100.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgp]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgp]],OfficeActual[#Headers],0))","v":{"v":100,"d":"100.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgs]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgs]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgs]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgs]],OfficeActual[#Headers],0))","v":{"v":100,"d":"100.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Spl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Spl]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Spl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Spl]],OfficeActual[#Headers],0))","v":{"v":100,"d":"100.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lap]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lap]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lap]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lap]],OfficeActual[#Headers],0))","v":{"v":400,"d":"400.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Grd]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Grd]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Grd]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Grd]],OfficeActual[#Headers],0))","v":{"v":400,"d":"400.00 EUR"}},{"$f":"SUM(OfficeVariances[[#This Row],[Sau]:[Grd]])","v":{"v":1076,"d":"1,076.00 EUR"}}]
[null,"Elektra",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sau]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sau]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sau]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sau]],OfficeActual[#Headers],0))","v":{"v":12,"d":"12.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Vas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Vas]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Vas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Vas]],OfficeActual[#Headers],0))","v":{"v":22,"d":"22.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kov]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kov]],OfficeActual[#Headers],0))","v":{"v":32,"d":"32.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bal]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bal]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bal]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bal]],OfficeActual[#Headers],0))","v":{"v":1,"d":"1.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Geg]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Geg]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Geg]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Geg]],OfficeActual[#Headers],0))","v":{"v":-6,"d":"-6.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bir]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bir]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bir]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bir]],OfficeActual[#Headers],0))","v":{"v":10,"d":"10.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lie]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lie]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lie]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lie]],OfficeActual[#Headers],0))","v":{"v":300,"d":"300.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgp]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgp]],OfficeActual[#Headers],0))","v":{"v":300,"d":"300.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgs]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgs]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgs]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgs]],OfficeActual[#Headers],0))","v":{"v":300,"d":"300.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Spl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Spl]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Spl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Spl]],OfficeActual[#Headers],0))","v":{"v":300,"d":"300.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lap]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lap]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lap]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lap]],OfficeActual[#Headers],0))","v":{"v":300,"d":"300.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Grd]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Grd]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Grd]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Grd]],OfficeActual[#Headers],0))","v":{"v":300,"d":"300.00 EUR"}},{"$f":"SUM(OfficeVariances[[#This Row],[Sau]:[Grd]])","v":{"v":1871,"d":"1,871.00 EUR"}}]
[null,"Vanduo",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sau]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sau]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sau]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sau]],OfficeActual[#Headers],0))","v":{"v":5,"d":"5.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Vas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Vas]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Vas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Vas]],OfficeActual[#Headers],0))","v":{"v":7,"d":"7.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kov]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kov]],OfficeActual[#Headers],0))","v":{"v":6,"d":"6.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bal]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bal]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bal]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bal]],OfficeActual[#Headers],0))","v":{"v":4,"d":"4.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Geg]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Geg]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Geg]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Geg]],OfficeActual[#Headers],0))","v":{"v":6,"d":"6.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bir]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bir]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bir]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bir]],OfficeActual[#Headers],0))","v":{"v":4,"d":"4.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lie]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lie]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lie]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lie]],OfficeActual[#Headers],0))","v":{"v":40,"d":"40.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgp]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgp]],OfficeActual[#Headers],0))","v":{"v":40,"d":"40.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgs]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgs]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgs]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgs]],OfficeActual[#Headers],0))","v":{"v":40,"d":"40.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Spl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Spl]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Spl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Spl]],OfficeActual[#Headers],0))","v":{"v":40,"d":"40.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lap]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lap]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lap]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lap]],OfficeActual[#Headers],0))","v":{"v":40,"d":"40.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Grd]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Grd]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Grd]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Grd]],OfficeActual[#Headers],0))","v":{"v":40,"d":"40.00 EUR"}},{"$f":"SUM(OfficeVariances[[#This Row],[Sau]:[Grd]])","v":{"v":272,"d":"272.00 EUR"}}]
[null,"Telefonas",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sau]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sau]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sau]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sau]],OfficeActual[#Headers],0))","v":{"v":26,"d":"26.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Vas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Vas]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Vas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Vas]],OfficeActual[#Headers],0))","v":{"v":15,"d":"15.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kov]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kov]],OfficeActual[#Headers],0))","v":{"v":-15,"d":"-15.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bal]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bal]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bal]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bal]],OfficeActual[#Headers],0))","v":{"v":5,"d":"5.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Geg]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Geg]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Geg]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Geg]],OfficeActual[#Headers],0))","v":{"v":5,"d":"5.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bir]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bir]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bir]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bir]],OfficeActual[#Headers],0))","v":{"v":30,"d":"30.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lie]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lie]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lie]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lie]],OfficeActual[#Headers],0))","v":{"v":250,"d":"250.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgp]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgp]],OfficeActual[#Headers],0))","v":{"v":250,"d":"250.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgs]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgs]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgs]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgs]],OfficeActual[#Headers],0))","v":{"v":250,"d":"250.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Spl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Spl]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Spl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Spl]],OfficeActual[#Headers],0))","v":{"v":250,"d":"250.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lap]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lap]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lap]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lap]],OfficeActual[#Headers],0))","v":{"v":250,"d":"250.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Grd]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Grd]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Grd]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Grd]],OfficeActual[#Headers],0))","v":{"v":250,"d":"250.00 EUR"}},{"$f":"SUM(OfficeVariances[[#This Row],[Sau]:[Grd]])","v":{"v":1566,"d":"1,566.00 EUR"}}]
[null,"Interneto prieiga",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sau]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sau]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sau]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sau]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Vas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Vas]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Vas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Vas]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kov]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kov]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bal]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bal]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bal]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bal]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Geg]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Geg]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Geg]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Geg]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bir]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bir]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bir]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bir]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lie]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lie]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lie]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lie]],OfficeActual[#Headers],0))","v":{"v":180,"d":"180.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgp]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgp]],OfficeActual[#Headers],0))","v":{"v":180,"d":"180.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgs]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgs]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgs]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgs]],OfficeActual[#Headers],0))","v":{"v":180,"d":"180.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Spl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Spl]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Spl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Spl]],OfficeActual[#Headers],0))","v":{"v":180,"d":"180.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lap]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lap]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lap]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lap]],OfficeActual[#Headers],0))","v":{"v":180,"d":"180.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Grd]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Grd]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Grd]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Grd]],OfficeActual[#Headers],0))","v":{"v":180,"d":"180.00 EUR"}},{"$f":"SUM(OfficeVariances[[#This Row],[Sau]:[Grd]])","v":{"v":1080,"d":"1,080.00 EUR"}}]
[null,"Biuro reikmenys",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sau]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sau]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sau]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sau]],OfficeActual[#Headers],0))","v":{"v":-56,"d":"-56.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Vas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Vas]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Vas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Vas]],OfficeActual[#Headers],0))","v":{"v":58,"d":"58.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kov]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kov]],OfficeActual[#Headers],0))","v":{"v":40,"d":"40.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bal]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bal]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bal]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bal]],OfficeActual[#Headers],0))","v":{"v":-21,"d":"-21.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Geg]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Geg]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Geg]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Geg]],OfficeActual[#Headers],0))","v":{"v":-56,"d":"-56.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bir]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bir]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bir]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bir]],OfficeActual[#Headers],0))","v":{"v":-40,"d":"-40.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lie]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lie]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lie]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lie]],OfficeActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgp]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgp]],OfficeActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgs]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgs]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgs]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgs]],OfficeActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Spl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Spl]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Spl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Spl]],OfficeActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lap]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lap]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lap]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lap]],OfficeActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Grd]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Grd]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Grd]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Grd]],OfficeActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"SUM(OfficeVariances[[#This Row],[Sau]:[Grd]])","v":{"v":1125,"d":"1,125.00 EUR"}}]
[null,"Apsauga",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sau]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sau]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sau]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sau]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Vas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Vas]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Vas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Vas]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kov]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kov]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bal]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bal]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bal]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bal]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Geg]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Geg]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Geg]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Geg]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bir]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bir]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Bir]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Bir]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lie]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lie]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lie]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lie]],OfficeActual[#Headers],0))","v":{"v":600,"d":"600.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgp]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgp]],OfficeActual[#Headers],0))","v":{"v":600,"d":"600.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgs]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgs]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Rgs]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Rgs]],OfficeActual[#Headers],0))","v":{"v":600,"d":"600.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Spl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Spl]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Spl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Spl]],OfficeActual[#Headers],0))","v":{"v":600,"d":"600.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lap]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lap]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lap]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lap]],OfficeActual[#Headers],0))","v":{"v":600,"d":"600.00 EUR"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Grd]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Grd]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Grd]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Grd]],OfficeActual[#Headers],0))","v":{"v":600,"d":"600.00 EUR"}},{"$f":"SUM(OfficeVariances[[#This Row],[Sau]:[Grd]])","v":{"v":3600,"d":"3,600.00 EUR"}}]
[null,"Tarpinė suma",{"$f":"SUBTOTAL(109,OfficeVariances[Sau])","v":{"v":-17,"d":"-17.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeVariances[Vas])","v":{"v":72,"d":"72.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeVariances[Kov])","v":{"v":78,"d":"78.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeVariances[Bal])","v":{"v":-141,"d":"-141.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeVariances[Geg])","v":{"v":-38,"d":"-38.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeVariances[Bir])","v":{"v":16,"d":"16.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeVariances[Lie])","v":{"v":11470,"d":"11,470.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeVariances[Rgp])","v":{"v":11470,"d":"11,470.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeVariances[Rgs])","v":{"v":11470,"d":"11,470.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeVariances[Spl])","v":{"v":11470,"d":"11,470.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeVariances[Lap])","v":{"v":11770,"d":"11,770.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeVariances[Grd])","v":{"v":11770,"d":"11,770.00 EUR"}},{"$f":"SUBTOTAL(109,OfficeVariances[METAI])","v":{"v":69390,"d":"69,390.00 EUR"}}]
[]
[null,"Rinkodaros išlaidos","Sau","Vas","Kov","Bal","Geg","Bir","Lie","Rgp","Rgs","Spl","Lap","Grd","METAI"]
[null,"Svetainės išteklių nuoma",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sau]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sau]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sau]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sau]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Vas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Vas]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Vas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Vas]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kov]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kov]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bal]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bal]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bal]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bal]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Geg]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Geg]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Geg]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Geg]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bir]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bir]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bir]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bir]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lie]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lie]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lie]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lie]],MarketingActual[#Headers],0))","v":{"v":500,"d":"500.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgp]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgp]],MarketingActual[#Headers],0))","v":{"v":500,"d":"500.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgs]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgs]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgs]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgs]],MarketingActual[#Headers],0))","v":{"v":500,"d":"500.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Spl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Spl]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Spl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Spl]],MarketingActual[#Headers],0))","v":{"v":500,"d":"500.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lap]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lap]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lap]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lap]],MarketingActual[#Headers],0))","v":{"v":500,"d":"500.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Grd]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Grd]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Grd]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Grd]],MarketingActual[#Headers],0))","v":{"v":500,"d":"500.00 EUR"}},{"$f":"SUM(MarketingVariances[[#This Row],[Sau]:[Grd]])","v":{"v":3000,"d":"3,000.00 EUR"}}]
[null,"Svetainės naujinimai",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sau]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sau]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sau]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sau]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Vas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Vas]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Vas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Vas]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kov]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kov]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bal]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bal]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bal]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bal]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Geg]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Geg]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Geg]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Geg]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bir]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bir]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bir]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bir]],MarketingActual[#Headers],0))","v":{"v":-500,"d":"-500.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lie]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lie]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lie]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lie]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgp]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgp]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgs]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgs]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgs]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgs]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Spl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Spl]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Spl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Spl]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lap]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lap]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lap]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lap]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Grd]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Grd]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Grd]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Grd]],MarketingActual[#Headers],0))","v":{"v":1000,"d":"1,000.00 EUR"}},{"$f":"SUM(MarketingVariances[[#This Row],[Sau]:[Grd]])","v":{"v":1500,"d":"1,500.00 EUR"}}]
[null,"Dokumentų parengimas",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sau]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sau]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sau]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sau]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Vas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Vas]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Vas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Vas]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kov]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kov]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bal]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bal]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bal]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bal]],MarketingActual[#Headers],0))","v":{"v":-500,"d":"-500.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Geg]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Geg]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Geg]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Geg]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bir]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bir]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bir]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bir]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lie]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lie]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lie]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lie]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"5,000.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgp]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgp]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgs]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgs]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgs]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgs]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Spl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Spl]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Spl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Spl]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"5,000.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lap]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lap]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lap]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lap]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Grd]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Grd]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Grd]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Grd]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUM(MarketingVariances[[#This Row],[Sau]:[Grd]])","v":{"v":9700,"d":"9,700.00 EUR"}}]
[null,"Dokumentų spausdinimas",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sau]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sau]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sau]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sau]],MarketingActual[#Headers],0))","v":{"v":100,"d":"100.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Vas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Vas]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Vas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Vas]],MarketingActual[#Headers],0))","v":{"v":-300,"d":"-300.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kov]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kov]],MarketingActual[#Headers],0))","v":{"v":100,"d":"100.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bal]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bal]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bal]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bal]],MarketingActual[#Headers],0))","v":{"v":100,"d":"100.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Geg]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Geg]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Geg]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Geg]],MarketingActual[#Headers],0))","v":{"v":-400,"d":"-400.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bir]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bir]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bir]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bir]],MarketingActual[#Headers],0))","v":{"v":20,"d":"20.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lie]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lie]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lie]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lie]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgp]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgp]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgs]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgs]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgs]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgs]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Spl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Spl]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Spl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Spl]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lap]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lap]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lap]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lap]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Grd]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Grd]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Grd]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Grd]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"SUM(MarketingVariances[[#This Row],[Sau]:[Grd]])","v":{"v":820,"d":"820.00 EUR"}}]
[null,"Rinkodaros įvykiai",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sau]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sau]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sau]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sau]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Vas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Vas]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Vas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Vas]],MarketingActual[#Headers],0))","v":{"v":-200,"d":"-200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kov]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kov]],MarketingActual[#Headers],0))","v":{"v":-200,"d":"-200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bal]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bal]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bal]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bal]],MarketingActual[#Headers],0))","v":{"v":300,"d":"300.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Geg]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Geg]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Geg]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Geg]],MarketingActual[#Headers],0))","v":{"v":500,"d":"500.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bir]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bir]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bir]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bir]],MarketingActual[#Headers],0))","v":{"v":-300,"d":"-300.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lie]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lie]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lie]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lie]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgp]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgp]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"5,000.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgs]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgs]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgs]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgs]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Spl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Spl]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Spl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Spl]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lap]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lap]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lap]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lap]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Grd]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Grd]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Grd]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Grd]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"5,000.00 EUR"}},{"$f":"SUM(MarketingVariances[[#This Row],[Sau]:[Grd]])","v":{"v":18300,"d":"18,300.00 EUR"}}]
[null,"Įvairios išlaidos",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sau]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sau]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sau]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sau]],MarketingActual[#Headers],0))","v":{"v":55,"d":"55.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Vas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Vas]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Vas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Vas]],MarketingActual[#Headers],0))","v":{"v":44,"d":"44.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kov]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kov]],MarketingActual[#Headers],0))","v":{"v":77,"d":"77.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bal]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bal]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bal]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bal]],MarketingActual[#Headers],0))","v":{"v":-23,"d":"-23.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Geg]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Geg]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Geg]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Geg]],MarketingActual[#Headers],0))","v":{"v":13,"d":"13.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bir]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bir]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Bir]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Bir]],MarketingActual[#Headers],0))","v":{"v":-45,"d":"-45.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lie]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lie]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lie]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lie]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgp]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgp]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgs]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgs]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Rgs]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Rgs]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Spl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Spl]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Spl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Spl]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lap]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lap]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lap]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lap]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Grd]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Grd]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Grd]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Grd]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 EUR"}},{"$f":"SUM(MarketingVariances[[#This Row],[Sau]:[Grd]])","v":{"v":1321,"d":"1,321.00 EUR"}}]
[null,"Tarpinė suma",{"$f":"SUBTOTAL(109,MarketingVariances[Sau])","v":{"v":555,"d":"555.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingVariances[Vas])","v":{"v":-456,"d":"-456.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingVariances[Kov])","v":{"v":-23,"d":"-23.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingVariances[Bal])","v":{"v":-123,"d":"-123.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingVariances[Geg])","v":{"v":113,"d":"113.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingVariances[Bir])","v":{"v":-825,"d":"-825.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingVariances[Lie])","v":{"v":8100,"d":"8,100.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingVariances[Rgp])","v":{"v":6100,"d":"6,100.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingVariances[Rgs])","v":{"v":3100,"d":"3,100.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingVariances[Spl])","v":{"v":8100,"d":"8,100.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingVariances[Lap])","v":{"v":3100,"d":"3,100.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingVariances[Grd])","v":{"v":6900,"d":"6,900.00 EUR"}},{"$f":"SUBTOTAL(109,MarketingVariances[METAI])","v":{"v":34641,"d":"34,641.00 EUR"}}]
[]
[null,"Mokymas / kelionės","Sau","Vas","Kov","Bal","Geg","Bir","Lie","Rgp","Rgs","Spl","Lap","Grd","METAI"]
[null,"Mokymo klasės",{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Sau]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Sau]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Sau]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Sau]],TrainingAndTravelActual[#Headers],0))","v":{"v":400,"d":"400.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Vas]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Vas]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Vas]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Vas]],TrainingAndTravelActual[#Headers],0))","v":{"v":-400,"d":"-400.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Kov]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Kov]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Kov]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Kov]],TrainingAndTravelActual[#Headers],0))","v":{"v":600,"d":"600.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Bal]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Bal]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Bal]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Bal]],TrainingAndTravelActual[#Headers],0))","v":{"v":400,"d":"400.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Geg]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Geg]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Geg]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Geg]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"800.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Bir]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Bir]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Bir]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Bir]],TrainingAndTravelActual[#Headers],0))","v":{"v":-800,"d":"-800.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Lie]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Lie]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Lie]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Lie]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Rgp]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Rgp]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Rgp]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Rgp]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Rgs]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Rgs]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Rgs]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Rgs]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Spl]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Spl]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Spl]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Spl]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Lap]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Lap]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Lap]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Lap]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Grd]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Grd]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Grd]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Grd]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"SUM(TrainingAndTravelVariances[[#This Row],[Sau]:[Grd]])","v":{"v":13000,"d":"13,000.00 EUR"}}]
[null,"Su mokymu susijusios kelionių išlaidos",{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Sau]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Sau]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Sau]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Sau]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"800.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Vas]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Vas]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Vas]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Vas]],TrainingAndTravelActual[#Headers],0))","v":{"v":-200,"d":"-200.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Kov]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Kov]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Kov]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Kov]],TrainingAndTravelActual[#Headers],0))","v":{"v":600,"d":"600.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Bal]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Bal]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Bal]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Bal]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"800.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Geg]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Geg]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Geg]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Geg]],TrainingAndTravelActual[#Headers],0))","v":{"v":1200,"d":"1,200.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Bir]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Bir]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Bir]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Bir]],TrainingAndTravelActual[#Headers],0))","v":{"v":-1500,"d":"-1,500.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Lie]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Lie]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Lie]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Lie]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Rgp]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Rgp]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Rgp]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Rgp]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Rgs]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Rgs]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Rgs]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Rgs]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Spl]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Spl]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Spl]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Spl]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Lap]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Lap]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Lap]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Lap]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Grd]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Grd]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Grd]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Grd]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"SUM(TrainingAndTravelVariances[[#This Row],[Sau]:[Grd]])","v":{"v":13700,"d":"13,700.00 EUR"}}]
[null,"Tarpinė suma",{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Sau])","v":{"v":1200,"d":"1,200.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Vas])","v":{"v":-600,"d":"-600.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Kov])","v":{"v":1200,"d":"1,200.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Bal])","v":{"v":1200,"d":"1,200.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Geg])","v":{"v":2000,"d":"2,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Bir])","v":{"v":-2300,"d":"-2,300.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Lie])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Rgp])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Rgs])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Spl])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Lap])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Grd])","v":{"v":4000,"d":"4,000.00 EUR"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[METAI])","v":{"v":26700,"d":"26,700.00 EUR"}}]
[]
[null,"BENDROSIOS SUMOS","Sau","Vas","Kov","Bal","Geg","Bir","Lie","Rgp","Rgs","Spl","Lap","Grd","Metai"]
[null,"Faktinės mėnesio išlaidos",{"$f":"TrainingAndTravelVariances[[#Totals],[Sau]]+MarketingVariances[[#Totals],[Sau]]+OfficeVariances[[#Totals],[Sau]]+EmployeeVariances[[#Totals],[Sau]]","v":{"v":1738,"d":"1,738.00 EUR"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Vas]]+MarketingVariances[[#Totals],[Vas]]+OfficeVariances[[#Totals],[Vas]]+EmployeeVariances[[#Totals],[Vas]]","v":{"v":-984,"d":"-984.00 EUR"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Kov]]+MarketingVariances[[#Totals],[Kov]]+OfficeVariances[[#Totals],[Kov]]+EmployeeVariances[[#Totals],[Kov]]","v":{"v":1255,"d":"1,255.00 EUR"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Bal]]+MarketingVariances[[#Totals],[Bal]]+OfficeVariances[[#Totals],[Bal]]+EmployeeVariances[[#Totals],[Bal]]","v":{"v":301,"d":"301.00 EUR"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Geg]]+MarketingVariances[[#Totals],[Geg]]+OfficeVariances[[#Totals],[Geg]]+EmployeeVariances[[#Totals],[Geg]]","v":{"v":1440,"d":"1,440.00 EUR"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Bir]]+MarketingVariances[[#Totals],[Bir]]+OfficeVariances[[#Totals],[Bir]]+EmployeeVariances[[#Totals],[Bir]]","v":{"v":-3744,"d":"-3,744.00 EUR"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Lie]]+MarketingVariances[[#Totals],[Lie]]+OfficeVariances[[#Totals],[Lie]]+EmployeeVariances[[#Totals],[Lie]]","v":{"v":134695,"d":"134,695.00 EUR"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Rgp]]+MarketingVariances[[#Totals],[Rgp]]+OfficeVariances[[#Totals],[Rgp]]+EmployeeVariances[[#Totals],[Rgp]]","v":{"v":138918,"d":"138,918.00 EUR"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Rgs]]+MarketingVariances[[#Totals],[Rgs]]+OfficeVariances[[#Totals],[Rgs]]+EmployeeVariances[[#Totals],[Rgs]]","v":{"v":135918,"d":"135,918.00 EUR"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Spl]]+MarketingVariances[[#Totals],[Spl]]+OfficeVariances[[#Totals],[Spl]]+EmployeeVariances[[#Totals],[Spl]]","v":{"v":140918,"d":"140,918.00 EUR"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Lap]]+MarketingVariances[[#Totals],[Lap]]+OfficeVariances[[#Totals],[Lap]]+EmployeeVariances[[#Totals],[Lap]]","v":{"v":136218,"d":"136,218.00 EUR"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Grd]]+MarketingVariances[[#Totals],[Grd]]+OfficeVariances[[#Totals],[Grd]]+EmployeeVariances[[#Totals],[Grd]]","v":{"v":140018,"d":"140,018.00 EUR"}},{"$f":"TrainingAndTravelVariances[[#Totals],[METAI]]+MarketingVariances[[#Totals],[METAI]]+OfficeVariances[[#Totals],[METAI]]+EmployeeVariances[[#Totals],[METAI]]","v":{"v":826691,"d":"826,691.00 EUR"}}]
[null,"Faktinių išlaidų BENDROJI SUMA",{"$f":"SUM($C$36:C36)","v":{"v":1738,"d":"1,738.00 EUR"}},{"$f":"SUM($C$36:D36)","v":{"v":754,"d":"754.00 EUR"}},{"$f":"SUM($C$36:E36)","v":{"v":2009,"d":"2,009.00 EUR"}},{"$f":"SUM($C$36:F36)","v":{"v":2310,"d":"2,310.00 EUR"}},{"$f":"SUM($C$36:G36)","v":{"v":3750,"d":"3,750.00 EUR"}},{"$f":"SUM($C$36:H36)","v":{"v":6,"d":"6.00 EUR"}},{"$f":"SUM($C$36:I36)","v":{"v":134701,"d":"134,701.00 EUR"}},{"$f":"SUM($C$36:J36)","v":{"v":273619,"d":"273,619.00 EUR"}},{"$f":"SUM($C$36:K36)","v":{"v":409537,"d":"409,537.00 EUR"}},{"$f":"SUM($C$36:L36)","v":{"v":550455,"d":"550,455.00 EUR"}},{"$f":"SUM($C$36:M36)","v":{"v":686673,"d":"686,673.00 EUR"}},{"$f":"SUM($C$36:N36)","v":{"v":826691,"d":"826,691.00 EUR"}}]

{"sheet":"IŠLAIDŲ ANALIZĖ","index":4,"n_rows":10,"n_cols":16,"rows_kept":10,"merged":[[2,4,2,6],[11,1,11,5]]}
[{"$nulls":6}," ",{"$nulls":8}," "]
[null,{"$f":"'SUPLANUOTOS IŠLAIDOS'!B2:D3","v":"Įmonės pavadinimas"}]
[{"$nulls":4},{"$f":"darbalapio_pavadinimas","v":"Išsamios apskaičiuotos išlaidos"}]
[]
[null,"Išlaidų kategorija","Suplanuotos išlaidos","Faktinės išlaidos","Išlaidų nuokrypiai","Nuokrypio procentai"]
[null,"Darbuotojų išlaidos",{"$f":"EmployeePlan[[#Totals],[METAI]]","v":{"v":1355090,"d":"1,355,090.00 EUR"}},{"$f":"EmployeeActual[[#Totals],[METAI]]","v":{"v":659130,"d":"659,130.00 EUR"}},{"$f":"C6-D6","v":{"v":695960,"d":"695,960.00 EUR"}},{"$f":"E6/C6","v":{"v":0.5135895032802249,"d":"51%"}}]
[null,{"$f":"'SUPLANUOTOS IŠLAIDOS'!B10","v":"Biuro išlaidos"},{"$f":"OfficePlan[[#Totals],[METAI]]","v":{"v":138740,"d":"138,740.00 EUR"}},{"$f":"OfficeActual[[#Totals],[METAI]]","v":{"v":69350,"d":"69,350.00 EUR"}},{"$f":"C7-D7","v":{"v":69390,"d":"69,390.00 EUR"}},{"$f":"E7/C7","v":{"v":0.5001441545336601,"d":"50%"}}]
[null,{"$f":"'SUPLANUOTOS IŠLAIDOS'!B21","v":"Rinkodaros išlaidos"},{"$f":"MarketingPlan[[#Totals],[METAI]]","v":{"v":67800,"d":"67,800.00 EUR"}},{"$f":"MarketingActual[[#Totals],[METAI]]","v":{"v":33159,"d":"33,159.00 EUR"}},{"$f":"C8-D8","v":{"v":34641,"d":"34,641.00 EUR"}},{"$f":"E8/C8","v":{"v":0.510929203539823,"d":"51%"}}]
[null,{"$f":"'SUPLANUOTOS IŠLAIDOS'!B30","v":"Mokymas / kelionės"},{"$f":"TrainingAndTravelPlan[[#Totals],[METAI]]","v":{"v":48000,"d":"48,000.00 EUR"}},{"$f":"TrainingAndTravelActual[[#Totals],[METAI]]","v":{"v":21300,"d":"21,300.00 EUR"}},{"$f":"C9-D9","v":{"v":26700,"d":"26,700.00 EUR"}},{"$f":"E9/C9","v":{"v":0.55625,"d":"56%"}}]
[null,{"$f":"'SUPLANUOTOS IŠLAIDOS'!B35","v":"BENDROSIOS SUMOS"},{"$f":"'SUPLANUOTOS IŠLAIDOS'!O36","v":{"v":1609630,"d":"1,609,630.00 EUR"}},{"$f":"'FAKTINĖS IŠLAIDOS'!O36","v":{"v":782939,"d":"782,939.00 EUR"}},{"$f":"C10-D10","v":{"v":826691,"d":"826,691.00 EUR"}},{"$f":"E10/C10","v":{"v":0.5135907009685455,"d":"51%"}}]