{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Pirkimams","Rangovui","Support"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Pirkimams","index":0,"n_rows":100,"n_cols":3,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
[]
[null,"********:",0.25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"########:","NE"]

{"sheet":"Rangovui","index":1,"n_rows":14,"n_cols":26,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,1,12,5],[13,1,13,5],[11,1,11,5],[10,1,10,5]]}
["Darbų sritis","Bendrastastybiniai"]
["PVM statusas","PVM moketojas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Pirkimams!$C$2<0.1,\"∆∆∆∆∆∆\",\"\")","v":""}]
["Rangovo siūloma suma, EUR be PVM"]
["Ar taikomas garantinis laikotarpis (draudimas)?*","Taikomas garantinis sulaikymas"]
["Garantijos suma, sulaikoma rangovui",{"$f":"IF(AND(Support!$C$19=\"TAIP\",Support!$C$20=\"TAIP\"),IF($B$4=Support!$F$7,ROUND(Support!$C$11*Support!$G$16,2),0),0)","v":0}]
["Paketo kaina, EUR su PVM",{"$f":"IF(AND(Support!$C$19=\"TAIP\",Support!$C$20=\"TAIP\"),IFERROR(Support!$F$16,0),0)","v":0},null,null,"Laukai pildymui:"]
["Susigrąžinama PVM dydžio suma, EUR",{"$f":"IF(AND(Support!$C$19=\"TAIP\",Support!$C$20=\"TAIP\"),IFERROR(IF($B$2=Support!$B$3,Support!$E$16,0),0),0)","v":0}]
[]
[]
[]
[null,{"$f":"IF(Support!$C$19=\"TAIP\",\"\",\"* Pasirinktos netinkamos darbų garantijos sąlygos !!!\")","v":""}]
[]
[null,{"$f":"IF(Support!$C$19=\"TAIP\",\"\",\"Paslaugoms yra netaikomas nei garantinis sulaikymas, nei draudimas\")","v":""}]
[null,{"$f":"IF(Support!$C$19=\"TAIP\",\"\",\"Bendrastatybiniams darbams turi būti taikomas arba garantinis sulaikymas, arba draudimas\")","v":""}]

{"sheet":"Support","index":2,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":true,"merged":[[1,6,1,8]]}
[]
[null,"Pasirinkti PVM moketojo statusa"]
[null,"PVM moketojas"]
[null,"Ne PVM moketojas"]
[]
[null,"Pasirinkti darbu tipa",1,null,null,0,1,null,null,"Į kurį garantinio sulaikymo (draudimo) pasirinkimų rėžį patenka pasirinktas darbas?"]
[null,"Bendrastastybiniai",0,null,null,"Taikomas garantinis sulaikymas","Netaikoma",null,null,{"$f":"VLOOKUP(Rangovui!$B$1,Support!$B$6:$C$8,2,FALSE)","v":0}]
[null,"Paslaugos",1,null,null,"Darbų garantinių trūkumų (defektų) pašalinimo draudimas"]
[]
[]
[null,"Garantinio sulaikymo procentas",0.04]
[]
[]
[]
[null,"Savikaina (plika rangovo kaina)","PVM (tariamas PVM) nuo savikainos","Mūsų komisiniai","PVM nuo komisinių","Paketo kaina","Rangovo išrašoma sąskaita (užsakovui, be pvm)","PVM nuo rangovo išrašomos sąskaitos","Rangovo išrašoma sąskaita su pvm"]
[null,{"$f":"Rangovui!$B$3","v":0},{"$f":"ROUND(IF(Rangovui!$B$2=Support!$B$3,0.21*Support!$B$16,0),2)","v":0},{"$f":"ROUND($B$16*Pirkimams!$C$2,2)","v":0},{"$f":"ROUND($D$16*0.21,2)","v":0},{"$f":"ROUND($D$16+$E$16,2)","v":0},{"$f":"ROUND(IF(Rangovui!$B$2=Support!$B$3,Support!$B$16+Support!$D$16,IF(Rangovui!$B$2=Support!$B$4,SUM(Support!$B$16,Support!$C$16,$D$16,$E$16),\"\")),2)","v":0},{"$f":"ROUND(IF(Rangovui!$B$2=Support!$B$3,0.21*$G$16,0),2)","v":0},{"$f":"ROUND($G$16+$H$16,2)","v":0}]
[]
[]
[null,"Ar pasirinktos tinkamos garantijos sąlygos?",{"$f":"IF(OR(AND(Rangovui!$B$1=Support!$B$7,OR(Rangovui!$B$4=Support!$F$7,Rangovui!$B$4=Support!$F$8)),AND(OR(Rangovui!$B$1=Support!$B$8,Rangovui!$B$1=Support!$B$6),Rangovui!$B$4=Support!$G$7)),\"TAIP\",\"NE\")","v":"TAIP"}]
[null,"Ar pasirinkta darbų sritis ir PVM mokėtojos statusas?",{"$f":"IF(AND(OR(Rangovui!$B$1=Support!$B$7,Rangovui!$B$1=Support!$B$8),OR(Rangovui!$B$2=Support!$B$3,Rangovui!$B$2=Support!$B$4)),\"TAIP\",\"NE\")","v":"TAIP"}]