{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Invoice Template","Customers","Record Of Invoices","KUPAC"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":5,"comments":0,"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":"Invoice Template","index":0,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[18,1,18,4],[33,1,33,4],[45,6,45,8],[45,2,45,4],[39,1,39,4],[2,5,4,6],[43,7,43,8],[44,7,44,8],[2,2,2,3],[3,2,3,3],[4,2,4,3],[44,2,44,4],[8,1,8,2],[43,2,43,4],[37,1,38,4],[44,5,44,6],[17,1,17,4],[7,2,7,5]]}
[null,"    FSG KRAGUJEVCA"]
[]
[null,"Broj računa",493,null,null,"RAČUN br."]
[null,"Način plaćanja","BEZGOTOVINSKI",null,null,null,null,{"$f":"C3","v":493}]
[null,"Datum",{"$f":"TODAY()","v":"2022-05-12"}]
[null,"Poziv na broj",null,{"$f":"H4","v":493}]
[]
[null,"Kupac:","Arsenijević Petar"]
[]
[null,"Šifra kupca",{"$f":"IF(C8<>\"\",VLOOKUP($C$8,KUPAC[],5,0),\"\")","v":7}]
[null,"PIB",{"$f":"IF(C8<>\"\",VLOOKUP($C$8,KUPAC[],8,0),\"\")","v":"1111111117"}]
[null,"Adresa",{"$f":"IF(C8<>\"\",VLOOKUP($C$8,KUPAC[],2,0),\"\")","v":"Desimirovac bb"}]
[null,"Mesto",{"$f":"IF(C8<>\"\",VLOOKUP($C$8,KUPAC[],3,0),\"\")","v":"Kragujevac"},null,{"$f":"IF(E12<>\"\",VLOOKUP($C$8,KUPAC[],5,0),\"\")","v":""}]
[null,"kontakt telefon",{"$f":"IF(C8<>\"\",VLOOKUP($C$8,KUPAC[],6,0),\"\")","v":0}]
[null,"tekući račun",{"$f":"IF(C8<>\"\",VLOOKUP($C$8,KUPAC[],4,0),\"\")","v":0}]
[null,"e mail adresa",{"$f":"IF(C8<>\"\",VLOOKUP($C$8,KUPAC[],7,0),\"\")","v":"abaccc@gmail.vcom"}]
[]
[null,"OPIS",null,null,null,"Kol.","Cena ","NAPOMENA","UKUPNO"]
[null,"3.GRADSKA LIGA - Taksa za suđenje",null,null,null,2,{"$f":"IF(B19<>\"\",VLOOKUP($B$19,Cust_Tbl[],4,0),\"\")","v":320},"Lazović, Milikić",{"$f":"IF(F19<>\"\",F19*G19,\"\")","v":640}]
[null,null,null,null,null,null,null,null,{"$f":"IF(F20<>\"\",F20*G20,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(B21<>\"\",VLOOKUP($B$21,Cust_Tbl[],4,0),\"\")","v":""},null,{"$f":"IF(F21<>\"\",F21*G21,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(B22<>\"\",VLOOKUP($B$21,Cust_Tbl[],4,0),\"\")","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(B23<>\"\",VLOOKUP($B$21,Cust_Tbl[],4,0),\"\")","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(B24<>\"\",VLOOKUP($B$21,Cust_Tbl[],4,0),\"\")","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(B25<>\"\",VLOOKUP($B$21,Cust_Tbl[],4,0),\"\")","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(B26<>\"\",VLOOKUP($B$21,Cust_Tbl[],4,0),\"\")","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(B27<>\"\",VLOOKUP($B$21,Cust_Tbl[],4,0),\"\")","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(B28<>\"\",VLOOKUP($B$21,Cust_Tbl[],4,0),\"\")","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(B29<>\"\",VLOOKUP($B$21,Cust_Tbl[],4,0),\"\")","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(B30<>\"\",VLOOKUP($B$21,Cust_Tbl[],4,0),\"\")","v":""},null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F32<>\"\",G32*0%,\"\")","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(F33<>\"\",G33*20%,\"\")","v":""},""]
[null,null,null,null,null,null,null,"",""]
[]
[null,"NAPOMENA:"]
[]
[null,"Fudbalski savez grada Kragujevca nije u sistemu PDV-a",null,null,null,null,"Ukupno",null,{"$f":"SUM(I19:I34)","v":640}]
[null,null,null,null,null,null,"PDV",null,{"$f":"SUM(H19:H34)","v":0}]
[null,"PRILIKOM UPLATE OBAVEZNO NAPISATI\nPOZIV NA BROJ",null,null,null,null,"Total:",null,{"$f":"SUM(I38:I39)","v":640}]
[]
[null,"Company Details"]
[null,"NAZIV","FUDBALSKI SAVEZ GRADA KRAGUJEVCA"]
[null,null,"Dragoslava Srejovića br 29,",null,null,"Kragujevac"]
[null,"ŽIRO RAČUN","160-51335-10",null,null,"Inteza banka"]
[null,"Tel / Fax","034/334-990",null,null,"Email","fsgkg@sbb.rs"]
[null,"Ovaj račun je punovažan bez potpisa i pečata"]

{"sheet":"Customers","index":1,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Customer Name","Address 1","Address 2","Address 3","Address 4","Address 5","Email"]
["1.GRADSKA LIGA - Taksa za suđenje","Sudijska taksa - 1.GRADSKA LIGA","Crown Industrial Estate",440,"Wiltshire","BA1 1GQ","abc@bluepecan.co.uk"]
["2.GRADSKA LIGA - Taksa za suđenje","XYZ House","Kings Rd",400,"Kent","TN1 1BF","xyz@bluepecan.co.uk"]
["3.GRADSKA LIGA - Taksa za suđenje",null,null,320]
["C licenca -ČLANARINA TRENERA",null,null,1000]
["B licenca - ČLANARINA TRENERA",null,null,2000]
["LEGITIMACIJA TRENERA",null,null,300]
["LEGITIMACIJA IGRAČA",null,null,50]
["Overa ugovora - trener",null,null,1000]
["Overa ugovora - igrač",null,null,3000]
["Članarina igrača -super liga seniori",null,null,6000]

{"sheet":"Record Of Invoices","index":2,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Broj računa","Prezime i ime ","UPLATA","Datum računa","JMBG","Paid","Invoice saved as pdf","Invoice saved as Excel file","Invoice Emailed"]
[454,"Jevtić Jovan",1320,"2022-05-06",0,"Yes"]
[457,"Jevtić Jovan",960,"2022-05-06",0,"Yes"]
[458,"Aksentijević Anđelko",1320,"2022-05-06",0,"Yes"]
[459,"Ivanović Petar",1320,"2022-05-06",0,"Yes"]
[461,"Šifra kupca",0,"2022-05-09",44690,null,"461 - Šifra kupca.pdf",null,"2022-05-09T09:04:07"]
[460,"Milić Luka",1200,"2022-05-09",0,"Yes"]
[461,"Arsenijević Petar",1200,"2022-05-09",0,"Yes"]
[463,"Krasić Marko",2300,"2022-05-09",0,"Yes"]
[465,"Petrović Darko",1200,"2022-05-09",0,"Yes"]
[466,"Tomović Vladimir",1320,"2022-05-09",0,"Yes"]
[467,"Jevtić Jovan",1200,"2022-05-09",0,"Yes"]
[468,"Perišić Nikola",1320,"2022-05-09",0,"Yes"]
[469,"Simić Jovan",1200,"2022-05-09",0,"Yes"]
[470,"Radić Lazar",1320,"2022-05-10",0,"Yes"]
[471,"Radić Lazar",1320,"2022-05-10",0,"Yes"]
[472,"Aksentijević Anđelko",1320,"2022-05-10",0,"Yes"]
[482,"Petrović Darko",1320,"2022-05-11",0,"Yes","C:\\Users\\Ćure\\Desktop\\E - RAČUNI482 - Petrović Darko.pdf"]
[490,"Milunović Bojan",1320,"2022-05-12",0,null,"c:\\Users\\Ćure\\Desktop\\E - RAČUNI\\490 - Milunović Bojan.pdf"]
[491,"FK RADNIČKI 1923",3000,"2022-05-12",0,null,"c:\\Users\\Ćure\\Desktop\\E - RAČUNI\\491 - FK RADNIČKI 1923.pdf"]
[492,"FK RADNIČKI 1923",15000,"2022-05-12",0,null,"c:\\Users\\Ćure\\Desktop\\E - RAČUNI\\492 - FK RADNIČKI 1923.pdf"]
[493,"FK RADNIČKI 1923",12000,"2022-05-12",0,null,"c:\\Users\\Ćure\\Desktop\\E - RAČUNI\\493 - FK RADNIČKI 1923.pdf"]
[493,"FK RADNIČKI 1923",12000,"2022-05-12","2022-05-12",null,"c:\\Users\\Ćure\\Desktop\\E - RAČUNI\\493 - FK RADNIČKI 1923.pdf",null,"2022-05-12T10:52:04"]
[493,"Petrović Darko",0,"2022-05-12","2022-05-12",null,"c:\\Users\\Ćure\\Desktop\\E - RAČUNI\\493 - Petrović Darko.pdf"]

{"sheet":"KUPAC","index":3,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["NAZIV KUPCA","Address 1","Mesto","Žiro - račun","Šifra kupca","telefon","Email","JMBG/PIB",null,null,null,null,null,"JMBG"]
["Petrović Darko","Crvenog Krsta 43/22","Kragujevac",null,1,null,"abaccc@gmail.vcom","1111111111",null,null,null,null,null,"PIB"]
["Milić Luka","Dragiše Mihailovića 18","Kragujevac",null,2,null,"abaccc@gmail.vcom","1111111112"]
["Đoković Dušan","Vladimira Jerosimića 4","Kragujevac",null,3,null,"abaccc@gmail.vcom","1111111113"]
["Jevtić Jovan","Ilindenska 85","Kragujevac",null,4,null,"abaccc@gmail.vcom","1111111114"]
["Aksentijević Anđelko","Košutnjačko brdo 007","Kragujevac",null,5,null,"abaccc@gmail.vcom","1111111115"]
["Ivanović Petar","Živadina Stevanović a23","Kragujevac",null,6,null,"abaccc@gmail.vcom","1111111116"]
["Arsenijević Petar","Desimirovac bb","Kragujevac",null,7,null,"abaccc@gmail.vcom","1111111117"]
["Krasić Marko","Braće Petkovića 5/31","Kragujevac",null,8,null,"abaccc@gmail.vcom","1111111118"]
["Tomović Vladimir","25 SRPSKE DIVIZIJE 11 2","Kragujevac",null,9,null,"abaccc@gmail.vcom","1111111119"]
["Perišić Nikola","Milatovac bb","Milatovac",null,10,null,"abaccc@gmail.vcom","1111111120"]
["Simić Jovan","Marka Zagorca 25","Kragujevac",null,11,null,"abaccc@gmail.vcom","1111111121"]
["Radić Lazar","Kraljević Marka 23/A","Kragujevac",null,12,null,"abaccc@gmail.vcom","1111111122"]
["FK OLIMP 2015","Janka Veselinovića 78","Kragujevac",null,13,null,"abaccc@gmail.vcom","1111111123"]
["Milunović Bojan","Mladena Miloradovića 30","Kragujevac",null,14,null,"abaccc@gmail.vcom","1111111124"]
["FK RADNIČKI 1923","Kralja Milana IV , br.21","Kragujevac",null,15,null,"abaccc@gmail.vcom","1111111125"]