{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Otpad na dan ",null,null,null,null,"2018-08-21"]
["Masina",null,"I Smena","II Smena","III Smena"]
["M1","Proizvod II",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$D$3:$D$13\"),MATCH($A3&$B3,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$E$3:$E$13\"),MATCH($A3&$B3,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$F$3:$F$13\"),MATCH($A3&$B3,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["M1","Proizvod IV",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$D$3:$D$13\"),MATCH($A4&$B4,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$E$3:$E$13\"),MATCH($A4&$B4,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$F$3:$F$13\"),MATCH($A4&$B4,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["M1","Proizvod III",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$D$3:$D$13\"),MATCH($A5&$B5,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$E$3:$E$13\"),MATCH($A5&$B5,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$F$3:$F$13\"),MATCH($A5&$B5,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["M1","Proizvod I",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$D$3:$D$13\"),MATCH($A6&$B6,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$E$3:$E$13\"),MATCH($A6&$B6,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$F$3:$F$13\"),MATCH($A6&$B6,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["M2","Proizvod III",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$D$3:$D$13\"),MATCH($A7&$B7,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$E$3:$E$13\"),MATCH($A7&$B7,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$F$3:$F$13\"),MATCH($A7&$B7,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["M2","Proizvod I",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$D$3:$D$13\"),MATCH($A8&$B8,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$E$3:$E$13\"),MATCH($A8&$B8,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$F$3:$F$13\"),MATCH($A8&$B8,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["M2","Proizvod II",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$D$3:$D$13\"),MATCH($A9&$B9,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$E$3:$E$13\"),MATCH($A9&$B9,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$F$3:$F$13\"),MATCH($A9&$B9,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["M3",null,{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$D$3:$D$13\"),MATCH($A10&$B10,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$E$3:$E$13\"),MATCH($A10&$B10,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$F$3:$F$13\"),MATCH($A10&$B10,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["M4","Proizvod II",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$D$3:$D$13\"),MATCH($A11&$B11,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$E$3:$E$13\"),MATCH($A11&$B11,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$F$3:$F$13\"),MATCH($A11&$B11,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["P1","Proizvod I",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$D$3:$D$13\"),MATCH($A12&$B12,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$E$3:$E$13\"),MATCH($A12&$B12,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$F$3:$F$13\"),MATCH($A12&$B12,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["P2","Proizvod I",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$D$3:$D$13\"),MATCH($A13&$B13,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$E$3:$E$13\"),MATCH($A13&$B13,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$F$3:$F$13\"),MATCH($A13&$B13,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$D$3:$D$13\"),MATCH($A14&$B14,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$E$3:$E$13\"),MATCH($A14&$B14,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($F$1)&\"'!$F$3:$F$13\"),MATCH($A14&$B14,INDIRECT(\"'\"&DAY($F$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($F$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
[]
[null,null,null,null,null,null,"1. Postavi file Proizvodnja.xlsx na ispravnu putanju (tj. izmjeni Path u VBA ) (pazi na format datoteke *.xlsx ili *.xls)"]
[null,null,null,null,null,null,"2. Pokreni VBA"]
[null,null,null,null,null,null,"3. Imaš rezultate za dotični dan"]