{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ID","OKTOBAR","OKTOBAR Formule"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"ID","index":0,"n_rows":42,"n_cols":33,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,2,3,33],[5,0,6,0],[5,1,6,1]]}
["Godina",2013]
["Mesec",10]
[null,null,null,null,null,null,null,"ovdje unosim rucno smjene zaposlenih, a na drugi sheet bih da se automatski popune istim redosledom, bitno je da se datumski poklapaju za cio mjesec"]
[null,null,"Ima li nacina da se zaposleni ID 101 koji radi 1 oktobra u 1 smjenu, prekopira u drugi sheet \" oktobar\" samo kao ID 101, za istu smjenu i isti datum sve do kraja mjeseca."]
[]
["ID BROJ","Ime",{"$f":"DATE($B$1,$B$2,1)","v":"2013-10-01"},{"$f":"C6+1","v":"2013-10-02"},{"$f":"D6+1","v":"2013-10-03"},"2013-10-04","2013-10-05","2013-10-06","2013-10-07","2013-10-08","2013-10-09","2013-10-10","2013-10-11","2013-10-12","2013-10-13","2013-10-14","2013-10-15","2013-10-16","2013-10-17","2013-10-18","2013-10-19","2013-10-20","2013-10-21","2013-10-22","2013-10-23","2013-10-24","2013-10-25","2013-10-26","2013-10-27","2013-10-28","2013-10-29","2013-10-30","2013-10-31"]
[null,null,{"$f":"C6","v":"2013-10-01"},{"$f":"D6","v":"2013-10-02"},"2013-10-03","2013-10-04","2013-10-05","2013-10-06","2013-10-07","2013-10-08","2013-10-09","2013-10-10","2013-10-11","2013-10-12","2013-10-13","2013-10-14","2013-10-15","2013-10-16","2013-10-17","2013-10-18","2013-10-19","2013-10-20","2013-10-21","2013-10-22","2013-10-23","2013-10-24","2013-10-25","2013-10-26","2013-10-27","2013-10-28","2013-10-29","2013-10-30","2013-10-31"]
[101,"dejan",2,1,null,2,2,3,3,null,1,1,null,2,2,3,3,null,1,1,null,2,2,3,3,null,1,1,null,2,2,3,3]
[102,"momo",1,3,null,2,2,3,3,null,1]
[103,"slavko",1,1]
[104,"mirko",1,2]
[105,"petar",2,1]
[106,"dusan",1,1]
[107,"joca",3,2]
[108,"vlada",2,1]
[110,"čeda",3,3]
[112,null,3,2]
[154,null,3,2]
[114,null,2,3]
[115]
[143]
[153]
[111]
[116]
[161]
[157]
[151]
[152]
[124]
[125]
[118]
[119]
[128]
[118]
[119]
[120]
[133]
[134]
[135]
[136]
[137]
[138]

{"sheet":"OKTOBAR","index":1,"n_rows":17,"n_cols":32,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"2013-10-01","2013-10-02","2013-10-03","2013-10-04","2013-10-05","2013-10-06","2013-10-07","2013-10-08","2013-10-09","2013-10-10","2013-10-11","2013-10-12","2013-10-13","2013-10-14","2013-10-15","2013-10-16","2013-10-17","2013-10-18","2013-10-19","2013-10-20","2013-10-21","2013-10-22","2013-10-23","2013-10-24","2013-10-25","2013-10-26","2013-10-27","2013-10-28","2013-10-29","2013-10-30","2013-10-31"]
[null,"momo","dejan",null,null,null,null,null,null,"dejan","dejan",null,null,null,null,null,null,"dejan","dejan",null,null,null,null,null,null,"dejan","dejan"]
[null,"slavko","slavko",null,null,null,null,null,null,"momo"]
["1 SMJENA","mirko","petar"]
[null,"dusan","dusan"]
[null,null,"vlada"]
[]
[null,"dejan","mirko",null,"dejan","dejan",null,null,null,null,null,null,"dejan","dejan",null,null,null,null,null,null,"dejan","dejan",null,null,null,null,null,null,"dejan","dejan"]
[null,"petar","joca",null,"momo","momo"]
["2 SMJENA","vlada"]
[]
[]
[]
[null,"joca","momo",null,null,null,"dejan","dejan",null,null,null,null,null,null,"dejan","dejan",null,null,null,null,null,null,"dejan","dejan",null,null,null,null,null,null,"dejan","dejan"]
[null,"čeda","čeda",null,null,null,"momo","momo"]
[]
["3 SMJENA"]

{"sheet":"OKTOBAR Formule","index":2,"n_rows":19,"n_cols":34,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"smena","rbr","2013-10-01T02:24:00","2013-10-02","2013-10-03","2013-10-04","2013-10-05","2013-10-06","2013-10-07","2013-10-08","2013-10-09","2013-10-10","2013-10-11","2013-10-12","2013-10-13","2013-10-14","2013-10-15","2013-10-16","2013-10-17","2013-10-18","2013-10-19","2013-10-20","2013-10-21","2013-10-22","2013-10-23","2013-10-24","2013-10-25","2013-10-26","2013-10-27","2013-10-28","2013-10-29","2013-10-30","2013-10-31"]
[null,1,1,{"$f":"IFERROR(Nth_Occurrence(ID!C$7:C$414,$B2,$C2,0,3-COLUMN()), \"\")","v":"momo"},{"$f":"IFERROR(Nth_Occurrence(ID!D$7:D$414,$B2,$C2,0,3-COLUMN()), \"\")","v":"dejan"},{"$f":"IFERROR(Nth_Occurrence(ID!E$7:E$414,$B2,$C2,0,3-COLUMN()), \"\")","v":""},104,105,106,107,108,101,101,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]
[null,1,2,{"$f":"IFERROR(Nth_Occurrence(ID!C$7:C$414,$B3,$C3,0,3-COLUMN()), \"\")","v":"slavko"},{"$f":"IFERROR(Nth_Occurrence(ID!D$7:D$414,$B3,$C3,0,3-COLUMN()), \"\")","v":"slavko"},{"$f":"IFERROR(Nth_Occurrence(ID!E$7:E$414,$B3,$C3,0,3-COLUMN()), \"\")","v":""},104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]
["1 SMJENA",1,3,{"$f":"IFERROR(Nth_Occurrence(ID!C$7:C$414,$B4,$C4,0,3-COLUMN()), \"\")","v":"mirko"},{"$f":"IFERROR(Nth_Occurrence(ID!D$7:D$414,$B4,$C4,0,3-COLUMN()), \"\")","v":"petar"},{"$f":"IFERROR(Nth_Occurrence(ID!E$7:E$414,$B4,$C4,0,3-COLUMN()), \"\")","v":""},104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]
[null,1,4,{"$f":"IFERROR(Nth_Occurrence(ID!C$7:C$414,$B5,$C5,0,3-COLUMN()), \"\")","v":"dusan"},{"$f":"IFERROR(Nth_Occurrence(ID!D$7:D$414,$B5,$C5,0,3-COLUMN()), \"\")","v":"dusan"},{"$f":"IFERROR(Nth_Occurrence(ID!E$7:E$414,$B5,$C5,0,3-COLUMN()), \"\")","v":""},104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]
[null,1,5,{"$f":"IFERROR(Nth_Occurrence(ID!C$7:C$414,$B6,$C6,0,3-COLUMN()), \"\")","v":""},{"$f":"IFERROR(Nth_Occurrence(ID!D$7:D$414,$B6,$C6,0,3-COLUMN()), \"\")","v":"vlada"},{"$f":"IFERROR(Nth_Occurrence(ID!E$7:E$414,$B6,$C6,0,3-COLUMN()), \"\")","v":""},104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]
[null,1,6,{"$f":"IFERROR(Nth_Occurrence(ID!C$7:C$414,$B7,$C7,0,3-COLUMN()), \"\")","v":""},{"$f":"IFERROR(Nth_Occurrence(ID!D$7:D$414,$B7,$C7,0,3-COLUMN()), \"\")","v":""},{"$f":"IFERROR(Nth_Occurrence(ID!E$7:E$414,$B7,$C7,0,3-COLUMN()), \"\")","v":""},104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]
[null,2,1,{"$f":"IFERROR(Nth_Occurrence(ID!C$7:C$414,$B8,$C8,0,3-COLUMN()), \"\")","v":"dejan"},{"$f":"IFERROR(Nth_Occurrence(ID!D$7:D$414,$B8,$C8,0,3-COLUMN()), \"\")","v":"mirko"},{"$f":"IFERROR(Nth_Occurrence(ID!E$7:E$414,$B8,$C8,0,3-COLUMN()), \"\")","v":""},101,101,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]
[null,2,2,{"$f":"IFERROR(Nth_Occurrence(ID!C$7:C$414,$B9,$C9,0,3-COLUMN()), \"\")","v":"petar"},{"$f":"IFERROR(Nth_Occurrence(ID!D$7:D$414,$B9,$C9,0,3-COLUMN()), \"\")","v":"joca"},{"$f":"IFERROR(Nth_Occurrence(ID!E$7:E$414,$B9,$C9,0,3-COLUMN()), \"\")","v":""},104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]
["2 SMJENA",2,3,{"$f":"IFERROR(Nth_Occurrence(ID!C$7:C$414,$B10,$C10,0,3-COLUMN()), \"\")","v":"vlada"},{"$f":"IFERROR(Nth_Occurrence(ID!D$7:D$414,$B10,$C10,0,3-COLUMN()), \"\")","v":""},{"$f":"IFERROR(Nth_Occurrence(ID!E$7:E$414,$B10,$C10,0,3-COLUMN()), \"\")","v":""},104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]
[null,2,4,{"$f":"IFERROR(Nth_Occurrence(ID!C$7:C$414,$B11,$C11,0,3-COLUMN()), \"\")","v":""},{"$f":"IFERROR(Nth_Occurrence(ID!D$7:D$414,$B11,$C11,0,3-COLUMN()), \"\")","v":""},{"$f":"IFERROR(Nth_Occurrence(ID!E$7:E$414,$B11,$C11,0,3-COLUMN()), \"\")","v":""},104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]
[null,2,5,{"$f":"IFERROR(Nth_Occurrence(ID!C$7:C$414,$B12,$C12,0,3-COLUMN()), \"\")","v":""},{"$f":"IFERROR(Nth_Occurrence(ID!D$7:D$414,$B12,$C12,0,3-COLUMN()), \"\")","v":""},{"$f":"IFERROR(Nth_Occurrence(ID!E$7:E$414,$B12,$C12,0,3-COLUMN()), \"\")","v":""},104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]
[null,2,6,{"$f":"IFERROR(Nth_Occurrence(ID!C$7:C$414,$B13,$C13,0,3-COLUMN()), \"\")","v":""},{"$f":"IFERROR(Nth_Occurrence(ID!D$7:D$414,$B13,$C13,0,3-COLUMN()), \"\")","v":""},{"$f":"IFERROR(Nth_Occurrence(ID!E$7:E$414,$B13,$C13,0,3-COLUMN()), \"\")","v":""},104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]
[null,3,1,101,102,103,104,105,101,101,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]
[null,3,2,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]
[null,3,3,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]
["3 SMJENA",3,4,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]
[null,3,5,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]
[null,3,6,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131]