{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ID","OKTOBAR","OKTOBAR Formule"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":32,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,32],[5,0,6,0]]}
["Godina",2013]
["Mesec",10]
[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,"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",{"$f":"DATE($B$1,$B$2,1)","v":"2013-10-01"},{"$f":"B6+1","v":"2013-10-02"},{"$f":"C6+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,{"$f":"B6","v":"2013-10-01"},{"$f":"C6","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,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,1,3,null,2,2,3,3,null,1]
[103,1,1]
[104,1,2]
[105,2,1]
[106,1,1]
[107,1,2]
[108,2,1]
[110,1,3]
[112,3,2]
[154,3,2]
[114,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":63,"n_cols":32,"rows_kept":63,"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,102,101,null,null,null,null,null,null,101,101,null,null,null,null,null,null,101,101,null,null,null,null,null,null,101,101]
[null,103,103,null,null,null,null,null,null,102]
["1 SMJENA",104,105]
[null,106,106]
[null,107,108]
[null,110]
[null,101,104,null,101,101,null,null,null,null,null,null,101,101,null,null,null,null,null,null,101,101,null,null,null,null,null,null,101,101]
[null,105,107,null,102,102]
["2 SMJENA",108,112]
[null,114,154]
[]
[]
[null,112,102,null,null,null,101,101,null,null,null,null,null,null,101,101,null,null,null,null,null,null,101,101,null,null,null,null,null,null,101,101]
[null,154,110,null,null,null,102,102]
[null,null,114]
["3 SMJENA"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"       ID brojevi","Ime "]
[null,null,null,null,101,"dejan"]
[null,null,null,null,102,"momo"]
[null,null,null,null,103,"slavko"]
[null,null,null,null,104,"mirko"]
[null,null,null,null,105,"petar"]
[null,null,null,null,106,"dusan"]
[null,null,null,null,107]
[null,null,null,null,108]
[null,null,null,null,109]
[null,null,null,null,110]
[null,null,null,null,111]
[null,null,null,null,112]
[null,null,null,null,113]
[null,null,null,null,114]
[null,null,null,null,115]
[null,null,null,null,116]
[null,null,null,null,117]
[null,null,null,null,118]
[null,null,null,null,119]
[null,null,null,null,120]
[null,null,null,null,121]
[null,null,null,null,122]
[null,null,null,null,123]
[null,null,null,null,124]
[null,null,null,null,125]
[null,null,null,null,126]
[null,null,null,null,127]
[null,null,null,null,128]
[null,null,null,null,129]
[null,null,null,null,130]
[null,null,null,null,131]
[null,null,null,null,132]
[null,null,null,null,133]
[null,null,null,null,134]
[null,null,null,null,135]
[null,null,null,null,136]
[null,null,null,null,137]
[null,null,null,null,138]
[null,null,null,null,139]

{"sheet":"OKTOBAR Formule","index":2,"n_rows":63,"n_cols":34,"rows_kept":63,"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":"Nth_Occurrence(ID!B$7:B$413,$B2,$C2,0,3-COLUMN())","v":102},{"$f":"Nth_Occurrence(ID!C$7:C$413,$B2,$C2,0,3-COLUMN())","v":101},103,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":"Nth_Occurrence(ID!B$7:B$413,$B3,$C3,0,3-COLUMN())","v":103},{"$f":"Nth_Occurrence(ID!C$7:C$413,$B3,$C3,0,3-COLUMN())","v":103},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]
["1 SMJENA",1,2,{"$f":"Nth_Occurrence(ID!B$7:B$413,$B4,$C4,0,3-COLUMN())","v":103},{"$f":"Nth_Occurrence(ID!C$7:C$413,$B4,$C4,0,3-COLUMN())","v":103},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,1,3,{"$f":"Nth_Occurrence(ID!B$7:B$413,$B5,$C5,0,3-COLUMN())","v":104},{"$f":"Nth_Occurrence(ID!C$7:C$413,$B5,$C5,0,3-COLUMN())","v":105},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,1,4,{"$f":"Nth_Occurrence(ID!B$7:B$413,$B6,$C6,0,3-COLUMN())","v":106},{"$f":"Nth_Occurrence(ID!C$7:C$413,$B6,$C6,0,3-COLUMN())","v":106},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,1,5,{"$f":"Nth_Occurrence(ID!B$7:B$413,$B7,$C7,0,3-COLUMN())","v":107},{"$f":"Nth_Occurrence(ID!C$7:C$413,$B7,$C7,0,3-COLUMN())","v":108},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,2,1,{"$f":"Nth_Occurrence(ID!B$7:B$413,$B8,$C8,0,3-COLUMN())","v":101},{"$f":"Nth_Occurrence(ID!C$7:C$413,$B8,$C8,0,3-COLUMN())","v":104},103,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":"Nth_Occurrence(ID!B$7:B$413,$B9,$C9,0,3-COLUMN())","v":105},{"$f":"Nth_Occurrence(ID!C$7:C$413,$B9,$C9,0,3-COLUMN())","v":107},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]
["2 SMJENA",2,3,{"$f":"Nth_Occurrence(ID!B$7:B$413,$B10,$C10,0,3-COLUMN())","v":108},{"$f":"Nth_Occurrence(ID!C$7:C$413,$B10,$C10,0,3-COLUMN())","v":112},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,2,4,{"$f":"Nth_Occurrence(ID!B$7:B$413,$B11,$C11,0,3-COLUMN())","v":114},{"$f":"Nth_Occurrence(ID!C$7:C$413,$B11,$C11,0,3-COLUMN())","v":154},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,2,5,{"$f":"Nth_Occurrence(ID!B$7:B$413,$B12,$C12,0,3-COLUMN())","v":101},{"$f":"Nth_Occurrence(ID!C$7:C$413,$B12,$C12,0,3-COLUMN())","v":104},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,2,6,{"$f":"Nth_Occurrence(ID!B$7:B$413,$B13,$C13,0,3-COLUMN())","v":105},{"$f":"Nth_Occurrence(ID!C$7:C$413,$B13,$C13,0,3-COLUMN())","v":107},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,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]
[]
[]
[]
[]
[null,null,null,null,null,null,"       ID brojevi","Ime "]
[null,null,null,null,null,null,101,"dejan"]
[null,null,null,null,null,null,102,"momo"]
[null,null,null,null,null,null,103,"slavko"]
[null,null,null,null,null,null,104,"mirko"]
[null,null,null,null,null,null,105,"petar"]
[null,null,null,null,null,null,106,"dusan"]
[null,null,null,null,null,null,107]
[null,null,null,null,null,null,108]
[null,null,null,null,null,null,109]
[null,null,null,null,null,null,110]
[null,null,null,null,null,null,111]
[null,null,null,null,null,null,112]
[null,null,null,null,null,null,113]
[null,null,null,null,null,null,114]
[null,null,null,null,null,null,115]
[null,null,null,null,null,null,116]
[null,null,null,null,null,null,117]
[null,null,null,null,null,null,118]
[null,null,null,null,null,null,119]
[null,null,null,null,null,null,120]
[null,null,null,null,null,null,121]
[null,null,null,null,null,null,122]
[null,null,null,null,null,null,123]
[null,null,null,null,null,null,124]
[null,null,null,null,null,null,125]
[null,null,null,null,null,null,126]
[null,null,null,null,null,null,127]
[null,null,null,null,null,null,128]
[null,null,null,null,null,null,129]
[null,null,null,null,null,null,130]
[null,null,null,null,null,null,131]
[null,null,null,null,null,null,132]
[null,null,null,null,null,null,133]
[null,null,null,null,null,null,134]
[null,null,null,null,null,null,135]
[null,null,null,null,null,null,136]
[null,null,null,null,null,null,137]
[null,null,null,null,null,null,138]
[null,null,null,null,null,null,139]