{"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":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Otpad na dan ",null,null,null,null,null,"2018-08-21"]
["Masina",null,"I Smena","II Smena","III Smena"]
["M1","Proizvod II",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$D$3:$D$13\"),MATCH($A3&$B3,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$E$3:$E$13\"),MATCH($A3&$B3,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$F$3:$F$13\"),MATCH($A3&$B3,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["M1","Proizvod IV",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$D$3:$D$13\"),MATCH($A4&$B4,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$E$3:$E$13\"),MATCH($A4&$B4,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$F$3:$F$13\"),MATCH($A4&$B4,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["M1","Proizvod III",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$D$3:$D$13\"),MATCH($A5&$B5,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$E$3:$E$13\"),MATCH($A5&$B5,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$F$3:$F$13\"),MATCH($A5&$B5,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["M1","Proizvod I",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$D$3:$D$13\"),MATCH($A6&$B6,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$E$3:$E$13\"),MATCH($A6&$B6,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$F$3:$F$13\"),MATCH($A6&$B6,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["M2","Proizvod III",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$D$3:$D$13\"),MATCH($A7&$B7,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$E$3:$E$13\"),MATCH($A7&$B7,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$F$3:$F$13\"),MATCH($A7&$B7,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["M2","Proizvod I",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$D$3:$D$13\"),MATCH($A8&$B8,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$E$3:$E$13\"),MATCH($A8&$B8,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$F$3:$F$13\"),MATCH($A8&$B8,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["M2","Proizvod II",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$D$3:$D$13\"),MATCH($A9&$B9,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$E$3:$E$13\"),MATCH($A9&$B9,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$F$3:$F$13\"),MATCH($A9&$B9,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["M3",null,{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$D$3:$D$13\"),MATCH($A10&$B10,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$E$3:$E$13\"),MATCH($A10&$B10,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$F$3:$F$13\"),MATCH($A10&$B10,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["M4","Proizvod II",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$D$3:$D$13\"),MATCH($A11&$B11,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$E$3:$E$13\"),MATCH($A11&$B11,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$F$3:$F$13\"),MATCH($A11&$B11,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["P1","Proizvod I",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$D$3:$D$13\"),MATCH($A12&$B12,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$E$3:$E$13\"),MATCH($A12&$B12,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$F$3:$F$13\"),MATCH($A12&$B12,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
["P2","Proizvod I",{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$D$3:$D$13\"),MATCH($A13&$B13,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$E$3:$E$13\"),MATCH($A13&$B13,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$F$3:$F$13\"),MATCH($A13&$B13,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$D$3:$D$13\"),MATCH($A14&$B14,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$E$3:$E$13\"),MATCH($A14&$B14,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$1)&\"'!$B$3:$B$13\"),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'\"&DAY($G$1)&\"'!$F$3:$F$13\"),MATCH($A14&$B14,INDIRECT(\"'\"&DAY($G$1)&\"'!$A$3:A$13\")&INDIRECT(\"'\"&DAY($G$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. Otvori OTPAD.xlsm file"]
[null,null,null,null,null,null,"3. Pokreni VBA"]
[null,null,null,null,null,null,"4. VBA kopira sheet za postavljeni dan ako imaš formulu u G2 (option 1)"]
[null,null,null,null,null,null,"4a. VBA kopira sheet za postavljeni dan iz G1 (option 2 by @bokinet)"]
[null,null,null,null,null,null,"5. Na sheet1 imaš rezultate pretraživanja"]
[]
[]
[null,null,null,null,null,null,"http://ic.ims.hr/excel-2013/kazalo-excel-2013.html"]