{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Ugovori 2014 godina","Rešenja","Potr.materijala","Kooperanti"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":19,"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":"Ugovori 2014 godina","index":0,"n_rows":8,"n_cols":117,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,9,3,9],[2,108,3,108],[3,11,3,12],[3,15,3,16],[3,19,3,20],[3,23,3,24],[3,62,3,66],[3,67,3,71],[3,27,3,31],[3,32,3,36],[3,37,3,41],[3,42,3,46],[2,107,3,107],[3,25,3,26],[2,106,3,106],[3,94,3,95],[2,82,2,97],[2,98,2,100],[2,104,3,104],[2,105,3,105],[3,82,3,83],[3,96,3,97],[3,84,3,85],[3,86,3,87],[3,88,3,89],[3,90,3,91],[3,92,3,93],[3,72,3,76],[3,77,3,81],[2,11,2,81],[3,47,3,51],[3,52,3,56],[3,57,3,61],[3,13,3,14],[3,17,3,18],[3,21,3,22],[0,0,0,116],[2,3,3,3],[2,115,3,115],[2,10,3,10],[2,0,3,0],[2,1,3,1],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,109,3,109],[2,2,3,2],[2,4,3,4],[3,111,3,114],[2,116,3,116],[2,110,3,110]]}
["Ugovori 2013 - 2014"]
[]
["R.br.","Tr.mY421-","Objekat","Investitor","Korespodencija sa investitorom/projektantom","Broj\nugovora","Datum ugovora\n(ponude)","Broj \nponude","Ugovoreno bez PDV-a","Kooperanti","Vrednost ugovora sa kooperantom bez PDV-a","Izvršena količina radova",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,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,null,null,null,null,null,null,null,null,null,null,null,null,"Materijalno zaduženje gradilišta",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"materijal","zarade","ostalo","Ukupno    troškovi","Dobit","Broj poslednje ispostavljene fakture","Datum poslednje ispostavljene fakture","Vrednost poslednje ispostavljenje situacije bez PDV-a","Kumulativna vrednost ispostavljenih faktura\nbez PDV-a","Kumulativna vrednost ispostavljene fakture kooperanata",null,null,null,null,"Faza izvršenja radova na objektu","Ugovorena vrednost umanjena za vrednost ispostavljenih faktura"]
[null,null,null,null,null,null,null,null,null,null,null,"Ivična traka",null,"behaton ploče",null,"Beton",null,"saobraćajni\nznakovi",null,"Šljunak",null,"0-63 mm \nII klasa",null,"0-63 mm",null,"0-31.5 mm",null,"BHNS - 16\nm2             d           t",null,null,null,null,"BNS - 22\nm2             d           t",null,null,null,null,"BNS - 22sA\nm2             d           t",null,null,null,null,"BNS - 32\nm2             d           t",null,null,null,null,"BNS - 32sA\nm2             d           t",null,null,null,null,"AB - 4\nm2             d           t",null,null,null,null,"AB - 8\nm2             d           t",null,null,null,null,"AB - 11\nm2             d           t",null,null,null,null,"AB - 11s\nm2             d           t",null,null,null,null,"AB - 16\nm2             d           t",null,null,null,null,"AB - 16s\nm2             d           t",null,null,null,null,"Ivična traka",null,"behaton ploče",null,"Beton",null,"saobraćajni znak",null,"Šljunak",null,"0-63 mm II klasa",null,"0-63 mm",null,"0-31.5 mm",null,"asfalt","mašine","prevozi",null,null,null,null,null,null,null,null,null,null,"Radovi izvedeni u periodu"]
[1]
[2]
[3]
[null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,I5:I7)","v":0},null,{"$f":"SUBTOTAL(109,K5:K7)","v":0},{"$f":"SUBTOTAL(109,L5:L7)","v":0},"m'",{"$f":"SUBTOTAL(109,N5:N7)","v":0},"m³",{"$f":"SUBTOTAL(109,P5:P7)","v":0},"m³",{"$f":"SUBTOTAL(109,R5:R7)","v":0},"m³",{"$f":"SUBTOTAL(109,T5:T7)","v":0},"m³",{"$f":"SUBTOTAL(109,V5:V7)","v":0},"m³",{"$f":"SUBTOTAL(109,X5:X7)","v":0},"m³",{"$f":"SUBTOTAL(109,Z5:Z7)","v":0},"m³",{"$f":"SUBTOTAL(109,AB5:AB7)","v":0},"m²",null,{"$f":"SUBTOTAL(109,AE5:AE7)","v":0},"t",{"$f":"SUBTOTAL(109,AG5:AG7)","v":0},"m²",null,{"$f":"SUBTOTAL(109,AJ5:AJ7)","v":0},"t",{"$f":"SUBTOTAL(109,AL5:AL7)","v":0},"m²",null,{"$f":"SUBTOTAL(109,AO5:AO7)","v":0},"t",{"$f":"SUBTOTAL(109,AQ5:AQ7)","v":0},"m²",null,{"$f":"SUBTOTAL(109,AT5:AT7)","v":0},"t",{"$f":"SUBTOTAL(109,AV5:AV7)","v":0},"m²",null,{"$f":"SUBTOTAL(109,AY5:AY7)","v":0},"t",{"$f":"SUBTOTAL(109,BA5:BA7)","v":0},"m²",null,{"$f":"SUBTOTAL(109,BD5:BD7)","v":0},"t",{"$f":"SUBTOTAL(109,BF5:BF7)","v":0},"m²",null,{"$f":"SUBTOTAL(109,BI5:BI7)","v":0},"t",{"$f":"SUBTOTAL(109,BK5:BK7)","v":0},"m²",null,{"$f":"SUBTOTAL(109,BN5:BN7)","v":0},"t",{"$f":"SUBTOTAL(109,BP5:BP7)","v":0},"m²",null,{"$f":"SUBTOTAL(109,BS5:BS7)","v":0},"t",{"$f":"SUBTOTAL(109,BU5:BU7)","v":0},"m²",null,{"$f":"SUBTOTAL(109,BX5:BX7)","v":0},"t",{"$f":"SUBTOTAL(109,BZ5:BZ7)","v":0},"m²",null,{"$f":"SUBTOTAL(109,CC5:CC7)","v":0},"t",{"$f":"SUBTOTAL(109,CE5:CE7)","v":0},null,{"$f":"SUBTOTAL(109,CG5:CG7)","v":0},null,{"$f":"SUBTOTAL(109,CI5:CI7)","v":0},null,{"$f":"SUBTOTAL(109,CK5:CK7)","v":0},null,{"$f":"SUBTOTAL(109,CM5:CM7)","v":0},null,{"$f":"SUBTOTAL(109,CO5:CO7)","v":0},null,{"$f":"SUBTOTAL(109,CQ5:CQ7)","v":0},null,{"$f":"SUBTOTAL(109,CS5:CS7)","v":0},null,{"$f":"SUBTOTAL(109,CU5:CU7)","v":0},0,0,0,0,0,0,0,null,null,{"$f":"SUBTOTAL(109,DE5:DE7)","v":0},{"$f":"SUBTOTAL(109,DF5:DF7)","v":0},{"$f":"SUBTOTAL(109,DG5:DG7)","v":0},null,null,null,null,null,{"$f":"SUBTOTAL(109,DM5:DM7)","v":0}]

{"sheet":"Rešenja","index":1,"n_rows":105,"n_cols":20,"rows_kept":105,"cut":false,"hidden":false,"merged":[[2,2,3,2],[2,3,2,7],[2,9,3,9],[2,1,3,1],[2,0,3,0]]}
[]
[]
[null,"Naziv ugovora","Broj ugovora","Objekat",null,null,null,null,null,"Korektivne mere"]
[null,null,null,"Reš. o odgov. Izvođ.radova","Rešenje o nadzoru","Reš. o šefu radilišta","Građ. Dozvola","Prijava radova","Zapisnik uvođenja u posao"]
[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]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[64]
[65]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[87]
[88]
[89]
[90]
[91]
[92]
[93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AB-4","BNS-22","m³","AB-4"]
[94,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AB-8","BNS-22s(A)","m²","AB-8"]
[95,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AB-11","BNS-32","t","AB-11"]
[96,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AB-11s","BNS-32s(A)",null,"AB-11s"]
[97,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AB-16","BNHS-16",null,"AB-16"]
[98,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AB-16s",null,null,"AB-16s"]
[99,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BNHS-16",null,null,"BNHS-16"]
[100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BNS-22s(A)"]
[101,null,null,null,null,null,null,null,null,null,null,null,"Arvaji Suzana",null,null,null,null,null,null,"BNS-32"]
[102,null,null,null,null,null,null,null,null,null,null,null,"Korać Vladimir",null,null,null,null,null,null,"BNS-32s(A)"]
[103,null,null,null,null,null,null,null,null,null,null,null,"Luković Željko"]
[104,null,null,{"$f":"IF(#REF!=\"\",\"X\",\"√\")","v":{"$error":"#REF!"}},"X","X","X","X","X","X",null,null,"Korać Vladimir"]
[105,null,null,{"$f":"IF(#REF!=\"\",\"X\",\"√\")","v":{"$error":"#REF!"}},"X","X","X","X","X","X",null,null,"Majtenji Silvija"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Dragan Svetozarević"]

{"sheet":"Potr.materijala","index":2,"n_rows":13,"n_cols":44,"rows_kept":13,"cut":false,"hidden":false,"merged":[[14,5,14,8],[1,25,1,29],[1,20,1,24],[12,20,12,21],[1,38,2,38],[1,39,2,39],[1,40,2,40],[1,41,2,41],[1,42,2,42],[1,32,2,32],[1,33,2,33],[1,34,2,34],[1,35,2,35],[1,36,2,36],[1,43,2,43],[0,0,0,42],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,1,7],[1,8,1,10],[1,11,1,13],[1,14,1,15],[1,37,2,37],[1,16,1,17],[1,18,1,19],[1,30,2,30],[1,31,2,31]]}
[]
["Redni\nbroj","Gradilište","Investitor","Broj ugovora","Broj ponude","Šljunak",null,null,"0-31.5mm",null,null,"0-63mm",null,null,"Ivičnjaci",null,"Betonske ploče",null,"Cevi",null,"Noseći",null,null,null,null,"Habajući",null,null,null,null,"AB-4","AB-6","AB-8","AB-11","AB-11S","AB-16","AB-16s","BNHS-16","BNS-22","BNS-22s(A)","BNS-32","BNS-32s(A)","∑","Naplaćeno"]
[null,null,null,null,null,"Ponuda","Naplaćeno","Razlika","Ponuda","Naplaćeno","Razlika","Ponuda","Naplaćeno","Razlika","Tip","m¹","Tip","m¹","Ø","m¹","Vrsta","d","m²","Uradjen","Razlika","Vrsta","d","m²","Naplaćeno","Razlika"]
[1,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":"IF(AE$2=$U4,$W4*($V4*0.025),IF(AE$2=$Z4,$AB4*($AA4*0.025),\"\"))","v":""},null,{"$f":"IF(AG$2=$U4,$W4*($V4*0.025),IF(AG$2=$Z4,$AB4*($AA4*0.025),\"\"))","v":""},"","","","","","","","","",{"$f":"SUM(AE4:AP4)","v":0}]
[2,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,"",null,"","","","","","","","","","",0]
[3,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,"",null,"","","","","","","","","","",0]
[4,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,"",null,"","","","","","","","","","",0]
[5,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,"",null,"","","","","","","","","","",0]
[6,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":"IF(AE$2=$U9,$W9*($V9*0.025),IF(AE$2=$Z9,$AB9*($AA9*0.025),\"\"))","v":""},null,"","","","","","","","","","",0]
[7,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,"",null,"","","","","","","","","","",0]
[8,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,"",null,"","","","","","","","","","",0]
[9,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,"",null,"","","","","","","","","","",{"$f":"SUM(AE12:AP12)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F4:F12)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(P4:P12)","v":0},null,{"$f":"SUM(R4:R12)","v":0},null,{"$f":"SUM(T4:T12)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,AE4:AE12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Kooperanti","index":3,"n_rows":4,"n_cols":20,"rows_kept":4,"cut":false,"hidden":false,"merged":[[19,0,19,6],[19,10,19,15],[4,2,6,2],[4,3,6,3],[4,4,6,4],[4,5,6,5],[8,1,10,1],[8,2,10,2],[8,3,10,3],[8,4,10,4],[8,5,10,5],[15,0,15,6],[15,10,15,15],[16,0,18,0],[16,1,18,1],[16,2,18,2],[4,20,5,21],[6,20,19,21],[7,12,7,15],[4,15,6,15],[4,14,6,14],[4,13,6,13],[4,12,6,12],[8,15,10,15],[8,14,10,14],[8,13,10,13],[8,12,10,12],[11,10,11,15],[12,13,13,13],[12,11,13,11],[16,13,18,13],[16,14,18,14],[16,15,18,15],[12,12,13,12],[4,1,6,1],[12,14,13,14],[12,15,13,15],[16,3,18,3],[16,4,18,4],[16,5,18,5],[16,11,18,11],[16,12,18,12],[11,1,11,6],[12,1,14,1],[12,2,14,2],[12,3,14,3],[12,4,14,4],[12,5,14,5],[12,0,14,0],[0,0,1,19],[2,0,3,0],[2,1,2,10],[2,11,2,19],[7,1,7,6],[4,11,10,11],[4,0,6,0],[8,0,10,0]]}
[]
[]
["Investitor ",null,null,null,null,null,null,null,null,null,null,"PODIZVOĐAČI"]
[null,"Br.\nUgovora","Datum ugovora","Objekat","Vrednost\nugovora bez PDV-a","Vrednost\nugovora sa PDV-om","Situacije","Broj i datum situacije","Iznos situacije\n(bez PDV-a)","Iznos situacije\n(sa PDV-om)","Plaćanje ","Podizvođač","Br.\nUgovora","Datum ugovora","Vrednost\nugovora bez PDV-a","Vrednost\nugovora sa PDV-om","Broj i datum\n situacije/računa","Iznos situacije\n(bez PDV-a)","Iznos situacije \n(sa PDV-om)","Plaćanje "]