{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["filtrirano","Data Table"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":3,"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":"filtrirano","index":0,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":false,"merged":[[17,10,23,18],[13,13,14,18]]}
["sistolni",71,29,"dijastolni",71,29,"puls",70,29,null,"sistolni",71,29,"dijastolni",71,29,"puls",70,29]
["normalan",46,0.647887323943662,"normalan",66,0.92957746478873238,"normalan",65,0.9285714285714286,null,"normalan",46,0.647887323943662,"normalan",66,0.92957746478873238,"normalan",65,0.9285714285714286]
["povišen",2,2.8169014084507043E-2,"povišen",0,"","ubrzan",0,"",null,"povišen",2,2.8169014084507043E-2,"snižen",5,7.0422535211267609E-2,"usporen",6,8.5714285714285715E-2]
["snižen",23,0.323943661971831,"snižen",5,7.0422535211267609E-2,"usporen",6,8.5714285714285715E-2,"filter","snižen",23,0.323943661971831,"<45",2,2.8169014084507043E-2,"<35",1,1.4285714285714285E-2]
["<60",0,"","<45",2,2.8169014084507043E-2,"<35",1,1.4285714285714285E-2,{"$f":"IF(AND(B5>0,E5>0,H5>0),\"da\",\"ne\")","v":"ne"},">85<=90",1,1.4084507042253521E-2,">55<60",3,4.2253521126760563E-2,">50<=55",3,4.2857142857142858E-2]
["60<=65",0,"",">45<=50",0,"","35<=40",0,"",{"$f":"IF(AND(B6>0,E6>0,H6>0),\"da\",\"ne\")","v":"ne"},">95<=100",14,0.19718309859154928,"60<=65",11,0.15492957746478872,">55<60",2,2.8571428571428571E-2]
[">65<=70",0,"",">50<=55",0,"",">40<=45",0,"","ne",">100<105",8,0.11267605633802817,">65<=70",17,0.23943661971830985,60,11,0.15714285714285714]
[">70<=75",0,"",">55<60",3,4.2253521126760563E-2,">45<=50",0,"","ne","105<=110",13,0.18309859154929578,">70<=75",24,0.3380281690140845,">60<=65",20,0.2857142857142857]
[">75<=80",0,"","60<=65",11,0.15492957746478872,">50<=55",3,4.2857142857142858E-2,"ne",">110<=115",13,0.18309859154929578,">75<80",7,9.8591549295774641E-2,">65<=70",14,0.2]
[">80<=85",0,"",">65<=70",17,0.23943661971830985,">55<60",2,2.8571428571428571E-2,"ne",">115<120",5,7.0422535211267609E-2,80,3,4.2253521126760563E-2,">70<=75",11,0.15714285714285714]
[">85<=90",1,1.4084507042253521E-2,">70<=75",24,0.3380281690140845,60,11,0.15714285714285714,"da",120,4,5.6338028169014086E-2,">80<=85",3,4.2253521126760563E-2,">75<80",6,8.5714285714285715E-2]
[">90<=95",0,"",">75<80",7,9.8591549295774641E-2,">60<=65",20,0.2857142857142857,"ne",">120<=125",8,0.11267605633802817,">85<90",1,1.4084507042253521E-2,80,3,4.2857142857142858E-2]
[">95<=100",14,0.19718309859154928,80,3,4.2253521126760563E-2,">65<=70",14,0.2,"da",">125<=130",1,1.4084507042253521E-2]
[">100<105",8,0.11267605633802817,">80<=85",3,4.2253521126760563E-2,">70<=75",11,0.15714285714285714,"da",">130<=135",2,2.8169014084507043E-2,"Ovo  bi trebalo da bude adekvatno filtriranje,opseg K1:S12."]
["105<=110",13,0.18309859154929578,">85<90",1,1.4084507042253521E-2,">75<80",6,8.5714285714285715E-2,"da",140,1,1.4084507042253521E-2]
[">110<=115",13,0.18309859154929578,90,0,"",80,3,4.2857142857142858E-2,"ne",">140<=145",1,1.4084507042253521E-2]
[">115<120",5,7.0422535211267609E-2,">90<=95",0,"",">80<=85",0,"","ne"]
[120,4,5.6338028169014086E-2,">95<=100",0,"",">85<=90",0,"","ne","Neophodno je istovremeno filtriranje B,E i H kolone po kriterijumu \">0\" počevši od 5 reda. Macro koji sam našao ne radi to u ovom slučaju kako treba. U listu Data Table se nalazi originalni macro. Očigledno da nisam ispravio makro kako  treba. Pokušavao sam i sa advanced filterom ali nisam uspeo,nešto ja tu ne kapiram kako treba."]
[">120<=125",8,0.11267605633802817,">100<=105",0,"",">90<=95",0,"","ne"]
[">125<=130",1,1.4084507042253521E-2,">105<=110",0,"",">95<=100",0,"","ne"]
[">130<=135",2,2.8169014084507043E-2,">110<=115",0,"",">100<=105",0,"","ne"]
[">135<140",0,"",">115<=120",0,"",">105<=110",0,"","ne"]
[140,1,1.4084507042253521E-2,">120<=125",0,"",">110<=115",0,"","ne"]
[">140<=145",1,1.4084507042253521E-2,">125<=130",0,"",">115<=120",0,"","ne"]
[">145<=150",0,"",">130<=135",0,"",">120<=125",0,"","ne"]
[">150<=155",0,"",">135<=140",0,"",">125<=130",0,"","ne"]
[">155<=160",0,"",">140<=145",0,"",">130<=135",0,"","ne"]
[">160<=165",0,"",">145<=150",0,"",">135<=140",0,"","ne"]
[">165<=170",0,"",">150<=155",0,"",">140",0,"","ne"]
[">170<=175",0,"",">155<=160",0,"",null,null,null,"ne"]
[">175<=180",0,"",">160<=165",0,"",null,null,null,"ne"]
[">180<=185",0,"",">165<=170",0,"",null,null,null,"ne"]
[">185<=190",0,"",">170<=175",0,"",null,null,null,"ne"]
[">190<=195",0,"",">175<=1800",0,"",null,null,null,"ne"]
[">195<=200",0,"",">180<=185",0,"",null,null,null,"ne"]
[">200<=205",0,"",">185<=190",0,"",null,null,null,"ne"]
[">205<=210",0,"",">190<=195",0,"",null,null,null,"ne"]
[">210<=215",0,"",">195<=200",0,"",null,null,null,"ne"]
[">215<=220",0,"",">200",0,"",null,null,null,"ne"]
[">220<=225",0,"",null,null,null,null,null,null,"ne"]
[">225<=230",0,"",null,null,null,null,null,null,"ne"]
[">230<=235",0,"",null,null,null,null,null,null,"ne"]
[">235<=240",0,"",null,null,null,null,null,null,"ne"]
[">240<=245",0,"",null,null,null,null,null,null,"ne"]
[">245<=250",0,"",null,null,null,null,null,null,"ne"]
[">250",0,"",null,null,null,null,null,null,"ne"]

{"sheet":"Data Table","index":1,"n_rows":101,"n_cols":6,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["SNO","Name","Country","Department","DOJ","Salary"]
[1,"Person 1","US","Sales","2010-06-03",2000]
[2,"Person 2","UK","HR","2010-07-03",3000]
[3,"Person 3","INDIA","Network","2010-08-02",2000]
[4,"Person 4","Australia","Sales","2010-09-01",6000]
[5,"Person 5","UAE","HR","2010-10-01",2000]
[6,"Person 6","Singpore","Network","2010-10-31",3000]
[7,"Person 7","Japan","IT","2010-11-30",5000]
[8,"Person 8","US","HR","2010-12-30",2000]
[9,"Person 9","UK","Network","2011-01-29",5000]
[10,"Person 10","INDIA","IT","2011-02-28",2000]
[11,"Person 11","Australia","HR","2011-03-30",4000]
[12,"Person 12","UAE","Sales","2011-04-29",3000]
[13,"Person 13","Singpore","HR","2011-05-29",6000]
[14,"Person 14","Japan","Network","2011-06-28",5000]
[15,"Person 15","US","IT","2011-07-28",6000]
[16,"Person 16","UK","IT","2011-08-27",4000]
[17,"Person 17","INDIA","Sales","2011-09-26",6000]
[18,"Person 18","Australia","HR","2011-10-26",3000]
[19,"Person 19","UAE","Network","2011-11-25",4000]
[20,"Person 20","Singpore","IT","2011-12-25",4000]
[21,"Person 21","Japan","IT","2012-01-24",5000]
[22,"Person 22","US","Sales","2012-02-23",6000]
[23,"Person 23","UK","HR","2012-03-24",2000]
[24,"Person 24","INDIA","Network","2012-04-23",4000]
[25,"Person 25","Australia","IT","2012-05-23",6000]
[26,"Person 26","UAE","Sales","2012-06-22",4000]
[27,"Person 27","Singpore","HR","2012-07-22",4000]
[28,"Person 28","Japan","Network","2012-08-21",4000]
[29,"Person 29","US","IT","2012-09-20",5000]
[30,"Person 30","UK","Sales","2012-10-20",5000]
[31,"Person 31","INDIA","HR","2012-11-19",6000]
[32,"Person 32","Australia","Network","2012-12-19",2000]
[33,"Person 33","UAE","IT","2013-01-18",4000]
[34,"Person 34","Singpore","Sales","2013-02-17",2000]
[35,"Person 35","Japan","HR","2013-03-19",4000]
[36,"Person 36","US","Network","2013-04-18",5000]
[37,"Person 37","UK","IT","2013-05-18",5000]
[38,"Person 38","INDIA","Sales","2013-06-17",5000]
[39,"Person 39","Australia","HR","2013-07-17",4000]
[40,"Person 40","UAE","Network","2013-08-16",6000]
[41,"Person 41","Singpore","IT","2013-09-15",6000]
[42,"Person 42","Japan","Sales","2013-10-15",3000]
[43,"Person 43","US","HR","2013-11-14",6000]
[44,"Person 44","UK","Network","2013-12-14",4000]
[45,"Person 45","INDIA","IT","2014-01-13",2000]
[46,"Person 46","Australia","Sales","2014-02-12",3000]
[47,"Person 47","UAE","HR","2014-03-14",6000]
[48,"Person 48","Singpore","Network","2014-04-13",6000]
[49,"Person 49","Japan","IT","2014-05-13",2000]
[50,"Person 50","US","Sales","2014-06-12",2000]
[51,"Person 51","UK","HR","2014-07-12",4000]
[52,"Person 52","INDIA","Network","2014-08-11",4000]
[53,"Person 53","Australia","IT","2014-09-10",3000]
[54,"Person 54","UAE","HR","2014-10-10",4000]
[55,"Person 55","Singpore","Network","2014-11-09",5000]
[56,"Person 56","Japan","IT","2014-12-09",4000]
[57,"Person 57","US","Sales","2015-01-08",4000]
[58,"Person 58","UK","HR","2015-02-07",2000]
[59,"Person 59","INDIA","Network","2015-03-09",6000]
[60,"Person 60","Australia","IT","2015-04-08",3000]
[61,"Person 61","UAE","Sales","2015-05-08",2000]
[62,"Person 62","Singpore","HR","2015-06-07",3000]
[63,"Person 63","Japan","Network","2015-07-07",2000]
[64,"Person 64","US","IT","2015-08-06",4000]
[65,"Person 65","UK","Sales","2015-09-05",5000]
[66,"Person 66","INDIA","HR","2015-10-05",6000]
[67,"Person 67","Australia","Network","2015-11-04",3000]
[68,"Person 68","UAE","IT","2015-12-04",5000]
[69,"Person 69","Singpore","Sales","2016-01-03",2000]
[70,"Person 70","Japan","HR","2016-02-02",5000]
[71,"Person 71","US","HR","2016-03-03",2000]
[72,"Person 72","UK","Network","2016-04-02",2000]
[73,"Person 73","INDIA","IT","2016-05-02",4000]
[74,"Person 74","Australia","Sales","2016-06-01",4000]
[75,"Person 75","UAE","HR","2016-07-01",3000]
[76,"Person 76","Singpore","Network","2016-07-31",3000]
[77,"Person 77","Japan","IT","2016-08-30",5000]
[78,"Person 78","US","Sales","2016-09-29",2000]
[79,"Person 79","UK","HR","2016-10-29",4000]
[80,"Person 80","INDIA","Network","2016-11-28",2000]
[81,"Person 81","Australia","IT","2016-12-28",5000]
[82,"Person 82","UAE","Sales","2017-01-27",5000]
[83,"Person 83","Singpore","HR","2017-02-26",6000]
[84,"Person 84","Japan","Network","2017-03-28",4000]
[85,"Person 85","US","IT","2017-04-27",5000]
[86,"Person 86","UK","Sales","2017-05-27",4000]
[87,"Person 87","INDIA","HR","2017-06-26",4000]
[88,"Person 88","Australia","Network","2017-07-26",6000]
[89,"Person 89","UAE","IT","2017-08-25",5000]
[90,"Person 90","Singpore","Sales","2017-09-24",6000]
[91,"Person 91","Japan","HR","2017-10-24",2000]
[92,"Person 92","US","Network","2017-11-23",2000]
[93,"Person 93","UK","IT","2017-12-23",2000]
[94,"Person 94","INDIA","Sales","2018-01-22",5000]
[95,"Person 95","Australia","HR","2018-02-21",4000]
[96,"Person 96","UAE","Network","2018-03-23",5000]
[97,"Person 97","Singpore","IT","2018-04-22",3000]
[98,"Person 98","Japan","Sales","2018-04-22",4000]
[99,"Person 99","US","IT","2018-04-23",6000]
[100,"Person 100","UK","Sales","2018-04-24",6000]