{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Racun-Ponuda","Partneri","Arhiva_predracuna","Arhiva_racuna","brojač"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":2,"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":"Racun-Ponuda","index":0,"n_rows":39,"n_cols":24,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,11,1,18],[16,6,34,6],[4,11,4,13],[11,6,12,6],[46,12,47,12],[4,8,5,8],[4,9,5,9],[0,3,1,6],[2,1,2,3],[16,1,34,2],[16,3,34,3],[16,4,34,4],[16,5,34,5],[47,1,47,3],[9,5,9,6],[6,1,6,3],[48,1,54,3],[35,1,35,3],[35,4,35,5],[36,1,38,3],[36,4,36,5],[37,4,37,5],[39,1,46,3],[38,4,38,6],[47,4,50,6],[51,4,54,6],[5,1,5,3],[8,5,8,6],[14,1,14,2],[11,1,12,4],[11,5,12,5]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"za više pogledaj",null,null,"https://ic.ims.hr/office/excel2003/razno/faktura.html"]
[null,"KUPAC",null,null,null,null,null,null,null,null,null,null,null,null,null,"RAČUN BR:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH(J7,Partneri!B10:AC10)","v":27},null,null,null,"PONUDA BR:"]
[null,{"$f":"VLOOKUP($I$7,Partneri!$A$8:$R$25,3,0)","v":"Zet"},null,null,null,"Datum računa: ",{"$f":"TODAY()","v":"2021-10-20"},null,"naziv partnera","mjesec ",null,"postavke za račun/predračun"]
[null,{"$f":"VLOOKUP($I$7,Partneri!$A$8:$R$25,5,0)","v":"Ilica 236"},null,null,null,"Rok plaćanja: ",{"$f":"G5+7","v":"2021-10-27"},null,null,null,null,"mjesec","godina",null,null,{"$f":"CONCATENATE(\"Poziv na broj: \",F12,\"-10-21\")","v":"Poziv na broj: 7-10-21"}]
[null,{"$f":"VLOOKUP($I$7,Partneri!$A$8:$R$25,6,0)","v":1111111111},null,null,null,"Datum isporuke: ",{"$f":"G5","v":"2021-10-20"},null,5,2205,null,"11",21,{"$f":"CONCATENATE(\" /\",L7,\"/\",M7)","v":" /11/21"}]
[]
[null,null,null,null,null,"Model / Poziv na broj:"]
[null,null,null,null,null,{"$f":"VLOOKUP(I7,Partneri!$A$10:$AC$25, MATCH(J7,Partneri!T10:AC10)+19, FALSE)","v":"258-0051-2205"}]
[]
[null,"PONUDA BR:",null,null,null,{"$f":"IF(B12=\"PONUDA BR:\",brojač!A3+1,brojač!B3+1)","v":7},{"$f":"CONCATENATE(\" -\",L7,\"-\",M7)","v":" -11-21"}]
[null,null,null,null,null,null,null,null,null,null,null,"B12 se mjenja u ponudu ili račun"]
[null,null,null,null,12]
[null,"NAZIV",null,"KOLIČINA","CIJENA","UKUPNO","PDV"]
[]
[null,{"$f":"VLOOKUP($I$7,Partneri!$A$8:$R$25,18,0)","v":"kolicina"},null,{"$f":"VLOOKUP(I7,Partneri!$A$10:$AC$25,MATCH(J7,Partneri!H10:Q10)+7,0)","v":5},{"$f":"VLOOKUP($I$7,Partneri!$A$10:$AC$25,7,0)","v":300},{"$f":"SUM(D17*E17)","v":1500},0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," ",null,null,"UKUPNO",null,{"$f":"F17","v":1500}]
[null,null,null,null,"PDV",null,{"$f":"G17","v":0}]
[null,null,null,null,"Ukupno za platiti",null,{"$f":"SUM(G36:G37)","v":1500}]
[null,null,null,null,{"$f":"CONCATENATE(\"Slovima: \",ConvertCurrencyToEnglish(G38))","v":"Slovima: jedna tisuća pet stotina kuna i nula lipa"}]

{"sheet":"Partneri","index":1,"n_rows":70,"n_cols":30,"rows_kept":70,"cut":false,"hidden":false,"merged":[[39,2,39,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[56,2,56,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[54,2,54,3],[28,2,28,3],[29,2,29,3],[68,2,68,3],[69,2,69,3],[57,2,57,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[63,2,63,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[67,2,67,3],[55,2,55,3],[40,2,40,3],[41,2,41,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[1,3,2,13],[1,14,2,17],[3,1,5,2],[3,6,3,10],[3,11,3,12],[3,13,3,17],[4,6,4,10],[5,13,5,17],[16,2,16,3],[17,2,17,3],[3,29,4,29],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[7,8,7,16],[5,6,5,10],[5,11,5,12],[14,2,14,3],[15,2,15,3],[4,11,4,12],[4,13,4,17]]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[]
[]
[null,258,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mjesec "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2109]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH(AD6,T10:AC10)","v":1}]
[null,null,null,null,null,null,null,null,"BROJ OSOBA"]
[]
[null,"ŠIFRA","PREZIME I IME",null,"ADRESA","OIB","Cjena",2109,2110,2111,2112,2201,2202,2203,2204,2205,2206,"OPASKE",null,2109,2110,2111,2112,2201,2202,2203,2204,2205,2206]
[1,"0019","Ina",null,"Ilica 236",null,300,null,1,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(B$4,\"-\",$B11,\"-\",H$10)","v":"258-0019-2109"},{"$f":"CONCATENATE($B4,\"-\",$B11,\"-\",I$10)","v":"258-0019-2110"},{"$f":"CONCATENATE($B$4,\"-\",$B11,\"-\",J$10)","v":"258-0019-2111"},{"$f":"CONCATENATE($B$4,\"-\",$B11,\"-\",K$10)","v":"258-0019-2112"},{"$f":"CONCATENATE($B$4,\"-\",$B11,\"-\",L$10)","v":"258-0019-2201"},{"$f":"CONCATENATE($B$4,\"-\",$B11,\"-\",M$10)","v":"258-0019-2202"},{"$f":"CONCATENATE($B$4,\"-\",$B11,\"-\",N$10)","v":"258-0019-2203"},{"$f":"CONCATENATE($B$4,\"-\",$B11,\"-\",O$10)","v":"258-0019-2204"},{"$f":"CONCATENATE($B$4,\"-\",$B11,\"-\",P$10)","v":"258-0019-2205"},{"$f":"CONCATENATE($B$4,\"-\",$B11,\"-\",Q$10)","v":"258-0019-2206"}]
[2,"0027","Mol",null,"Ilica 236",45434922757,300,null,11,null,null,null,null,null,null,null,null,null,null,"258-0027-2109",{"$f":"CONCATENATE(B$4,\"-\",$B12,\"-\",I$10)","v":"258-0027-2110"},"258-0027-2111","258-0027-2112","258-0027-2201","258-0027-2202","258-0027-2203","258-0027-2204","258-0027-2205","258-0027-2206"]
[3,"0035","Supernova",null,"Ilica 236",null,300,null,1,null,null,null,null,null,null,null,null,null,null,"258-0035-2109","258-0035-2110","258-0035-2111","258-0035-2112","258-0035-2201","258-0035-2202","258-0035-2203","258-0035-2204","258-0035-2205","258-0035-2206"]
[4,"0043","Shell",null,"Ilica 236",null,300,null,1,null,null,null,null,null,null,null,null,"ej",null,"258-0043-2109","258-0043-2110","258-0043-2111","258-0043-2112","258-0043-2201","258-0043-2202","258-0043-2203","258-0043-2204","258-0043-2205","258-0043-2206"]
[5,"0051","Zet",null,"Ilica 236",1111111111,300,9,10,11,12,1,2,3,4,5,6,"kolicina",null,"258-0051-2109","258-0051-2110","258-0051-2111","258-0051-2112","258-0051-2201","258-0051-2202","258-0051-2203","258-0051-2204","258-0051-2205","258-0051-2206"]
[6,"0060",null,null,null,null,300,null,null,null,null,null,null,null,null,null,null,null,null,"258-0060-2109","258-0060-2110","258-0060-2111","258-0060-2112","258-0060-2201","258-0060-2202","258-0060-2203","258-0060-2204","258-0060-2205","258-0060-2206"]
[7,"0078",null,null,null,null,300,null,null,null,null,null,null,null,null,null,null,null,null,"258-0078-2109","258-0078-2110","258-0078-2111","258-0078-2112","258-0078-2201","258-0078-2202","258-0078-2203","258-0078-2204","258-0078-2205","258-0078-2206"]
[8,"0086",null,null,null,null,300,null,null,null,null,null,null,null,null,null,null,null,null,"258-0086-2109","258-0086-2110","258-0086-2111","258-0086-2112","258-0086-2201","258-0086-2202","258-0086-2203","258-0086-2204","258-0086-2205","258-0086-2206"]
[9,"0094",null,null,null,null,300,null,null,null,null,null,null,null,null,null,null,null,null,"258-0094-2109","258-0094-2110","258-0094-2111","258-0094-2112","258-0094-2201","258-0094-2202","258-0094-2203","258-0094-2204","258-0094-2205","258-0094-2206"]
[10,"0108",null,null,null,null,300,null,null,null,null,null,null,null,null,null,null,null,null,"258-0108-2109","258-0108-2110","258-0108-2111","258-0108-2112","258-0108-2201","258-0108-2202","258-0108-2203","258-0108-2204","258-0108-2205","258-0108-2206"]
[11,"0116",null,null,null,null,300,null,null,null,null,null,null,null,null,null,null,null,null,"258-0116-2109","258-0116-2110","258-0116-2111","258-0116-2112","258-0116-2201","258-0116-2202","258-0116-2203","258-0116-2204","258-0116-2205","258-0116-2206"]
[12,"0124",null,null,null,null,300,null,null,null,null,null,null,null,null,null,null,null,null,"258-0124-2109","258-0124-2110","258-0124-2111","258-0124-2112","258-0124-2201","258-0124-2202","258-0124-2203","258-0124-2204","258-0124-2205","258-0124-2206"]
[13,"0132",null,null,null,null,300,null,null,null,null,null,null,null,null,null,null,null,null,"258-0132-2109","258-0132-2110","258-0132-2111","258-0132-2112","258-0132-2201","258-0132-2202","258-0132-2203","258-0132-2204","258-0132-2205","258-0132-2206"]
[14,"0140",null,null,null,null,300,null,null,null,null,null,null,null,null,null,null,null,null,"258-0140-2109","258-0140-2110","258-0140-2111","258-0140-2112","258-0140-2201","258-0140-2202","258-0140-2203","258-0140-2204","258-0140-2205","258-0140-2206"]
[15,"0159",null,null,null,null,300,null,null,null,null,null,null,null,null,null,null,null,null,"258-0159-2109","258-0159-2110","258-0159-2111","258-0159-2112","258-0159-2201","258-0159-2202","258-0159-2203","258-0159-2204","258-0159-2205","258-0159-2206"]
[null,167]
[null,175]
[null,183]
[null,191]
[null,205]
[null,213]
[null,221]
[null,230]
[null,248]
[null,256]
[null,264]
[null,272]
[null,280]
[null,299]
[null,302]
[null,310]
[null,329]
[null,337]
[null,345]
[null,353]
[null,361]
[null,370]
[null,388]
[null,396]
[null,400]
[null,418]
[null,426]
[null,434]
[null,442]
[null,450]
[null,469]
[null,477]
[null,485]
[null,493]
[null,507]
[null,515]
[null,523]
[null,531]
[null,540]
[null,558]
[null,566]
[null,574]
[null,582]
[null,590]
[null,604]

{"sheet":"Arhiva_predracuna","index":2,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["broj ponude","KUPAC","Datum računa: ","Rok plaćanja: ","Datum isporuke: ","Ukupan iznos"]
["1 -11-21","Zet","2021-10-19","2021-10-26","2021-10-19",1500]
["2 -11-21","Zet","2021-10-19","2021-10-26","2021-10-19",1500]
["3 -11-21","Zet","2021-10-19","2021-10-26","2021-10-19",1500]
["4 -11-21","Zet","2021-10-20","2021-10-27","2021-10-20",1500]
["5 -11-21","Zet","2021-10-20","2021-10-27","2021-10-20",1500]
["6 -11-21","Zet","2021-10-20","2021-10-27","2021-10-20",1500]

{"sheet":"Arhiva_racuna","index":3,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["broj računa","KUPAC","Datum računa: ","Rok plaćanja: ","Datum isporuke: ","Ukupan iznos"]
["1 -11-21","Zet","2021-10-19","2021-10-26","2021-10-19",1500]
["2 -11-21","Zet","2021-10-19","2021-10-26","2021-10-19",1500]
["3 -11-21","Zet","2021-10-19","2021-10-26","2021-10-19",1500]

{"sheet":"brojač","index":4,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Ponude","Računi"]
[{"$f":"INDEX(Arhiva_predracuna!A:A,MATCH(REPT(\"Z\",255),Arhiva_predracuna!A:A))","v":"6 -11-21"},{"$f":"INDEX(Arhiva_racuna!A:A,MATCH(REPT(\"Z\",255),Arhiva_racuna!A:A))","v":"3 -11-21"}]
[{"$f":"VALUE(TRIM(IFERROR(IF(LEN(A2>10),LEFT(A2,SEARCH(\"-\",A2)-1),A2),A2)))","v":6},{"$f":"VALUE(TRIM(IFERROR(IF(LEN(B2>10),LEFT(B2,SEARCH(\"-\",B2)-1),B2),B2)))","v":3}]