{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Úkoly","Data","Nastavení"],"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":"Úkoly","index":0,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1]]}
["VBA test skupina 02"]
["Celkem 20 bodů"]
[]
[]
["Provést úpravy - do jednoho tlačítka, které provede všechny úpravy",null,{"$f":"SUM(C11:C33)","v":20}]
["pokud vám nebude fungovat můžete rozdělit"]
["Doporučení: data si zálohujte třeba do dalšího listu , Ukládejte průběžně na disk!"]
["Tip tlačíko na listu Data"]
["Pojmenujte tlačítko (tlačítka)"]
[]
["1) Úpravit tabulku (promazat prazdné řádky) list Data",null,4]
["prázdný: pokud buňka - sloupec A, je prázdná(prázdná)"]
["pozor oblast (poslední řádek) přes proměnou dynamicky !!!"]
["neinformovat který řádek se maže (msgbox) !"]
[]
["2) Promazat řádky obsahující ve sloupci Stav text \"SMAZAT\"",null,4]
["pozor oblasti přes proměnou dynamicky !!!"]
[]
["3) Odstranit barvy pozadí na bezbarvé (bílé)",null,3]
["Tip: Lze nabarvit na bílou barvu."]
["pozor oblasti přes proměnou dynamicky !!! Velikost může být jiná! Počet sloupců a řádků."]
[]
["4) Spočítat odměnu v EUR (sečist odměny za 01 a 02 a vydělit kurzem - pozor na závorky)",null,5]
["do buněk vložit vzorec nebo přímo vypočtenou hodnotu!"]
["Hodnota kurzu na listu Nastavení C4"]
[]
["5) První řádek (zahlaví) - změn na kurzívu a pozadí buněk na (např. žlutá)",null,3]
["případně jinou barvu než bílou"]
[]
[]
["6) Vše v jednom tlačítku, kdy na konci bude pouze hláška (informace), že vše proběhlo. Třeba text: \"OK\".",null,1]
["    neinformovat v průběhu, který řádek se maže, atd."]

{"sheet":"Data","index":1,"n_rows":107,"n_cols":12,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
["Id","Jmeno","Prijmeni","Město","Stav","Datum","Email","Heslo","Osobni cislo","Odměna 01 v Kč","Odměna 02 v Kč","Odměna"]
[1,"Dennis","Houston","Le Petit-Quevilly",null,"2016-03-16","velit@ligulaAeneaneuismod.co.uk","TII56GMN2KK","16130120-9720",42,474]
[2,"Zelenia","Rios","Lac Ste. Anne",null,"2015-12-13","sem@sodaleselit.co.uk","PMS18LBZ1WB","16290817-7922",474,0]
[3,"Dolan","Leonard","Embourg",null,"2016-01-15","Quisque@arcu.ca","CIK70JMN7XS","16970211-7301",787,620]
[null,"David","Taylor","Hastings",null,"2017-09-01","enim@luctus.co.uk","TSK19VSW9FV","16300525-4994",620,286]
[5,"Edward","Dillard","Kirkintilloch","SMAZAT","2016-10-23","nonummy.Fusce@suscipitest.com","ONJ93QWT0NX","16640702-7561",286,294]
[6,"Basia","Porter","Kota",null,"2016-09-07","ipsum.dolor@aliquamadipiscing.edu","TXO90LAX3RV","16711206-2448",294,218]
[7,"Lester","Abbott","Sachs Harbour",null,"2017-06-17","gravida.non@turpisvitaepurus.net","RIS65VPE0BR","16380823-9978",218,893]
[8,"Ralph","Waller","Silvan",null,"2015-11-06","sagittis.Duis@non.com","QVK23QUD7SS","16781111-3443",893,0]
[9,"Phelan","Justice","Bochum",null,"2015-10-25","feugiat@liberomaurisaliquam.co.uk","UNB09NMP7UR","16581118-7441",339,437]
[]
[10,"Dalton","Stephens","Buzet",null,"2016-09-11","elit.pellentesque.a@consequatpurus.org","ATH86UYQ3NZ","16321014-5581",646,935]
[11,"Raphael","Page","Isla de Maipo",null,"2017-08-09","dignissim.magna@ornare.net","CVX59LZC5GP","16381105-8274",0,865]
[null,"Clarke","Tucker","Autelbas",null,"2016-04-04","arcu@urnajustofaucibus.co.uk","BUL08VRI5PP","16161213-1480",865,479]
[13,"Scarlett","Deleon","Kitscoty",null,"2016-07-29","sollicitudin.orci.sem@quis.co.uk","EKV84CHE2TW","16921215-3606",479,418]
[14,"Grant","Bradford","Leke","SMAZAT","2017-02-02","velit.Cras.lorem@eget.ca","UOC14PFK2PN","16950407-8925",0,818]
[15,"Whoopi","Mercado","Santa Luzia",null,"2016-07-08","id@sociisnatoque.ca","VZX74QCO2UY","16590210-6136",818,690]
[null,"Hamish","Travis","Embourg",null,"2019-12-25","Donec.non.justo@lobortisnisi.org","LSW65BOC0AQ","16551213-4114",690,60]
[17,"Timothy","Aguilar","Borgomasino",null,"2016-12-13","consectetuer.ipsum@odiovelest.net","DML65EKM8DE","16790528-1338",60,654]
[18,"Virginia","Dunlap","Buti",null,"2017-07-10","eu.neque@nequetellusimperdiet.com","DLJ74AMH7EN","16960305-9750",654,15]
[19,"Lysandra","Sutton","Marbais",null,"2019-10-13","egestas@erat.ca","CGH15IFZ9GO","16220305-6292",15,660]
[20,"Hanae","Gallagher","Dubuisson",null,"2016-02-18","lectus.quis.massa@purus.net","FQQ50RGT8RH","16571124-1108",660,845]
[21,"Ruth","Cox","Hudson Bay",null,"2019-08-04","cursus.purus@lacus.edu","GER10FRP3QC","16750616-0014",845,269]
[22,"Medge","Graves","Diepenbeek",null,"2017-06-07","adipiscing.ligula.Aenean@aneque.ca","JMU34ZGW1JY","16630823-6964",269,427]
[null,"Graiden","Brown","Aachen","SMAZAT","2017-03-29","pede@risusDonecnibh.com","AYG24QTR3UV","16720222-7695",427,679]
[24,"Bethany","Horton","Nazilli",null,"2016-09-06","porta@velnislQuisque.ca","JCT95JXC9JS","16130510-8969",679,446]
[25,"Wallace","Gordon","Catemu",null,"2016-02-06","iaculis.aliquet.diam@amet.com","WPQ15VYG9NP","16620127-5390",446,187]
[26,"Nina","Cunningham","Doetinchem",null,"2019-09-17","nunc.sed@tellusid.com","HJS12OEM3HC","16661110-5054",187,563]
[27,"Lester","Newton","Roccamena",null,"2017-07-21","arcu.ac@Suspendissenonleo.com","AZI30FTU8CP","16780101-0682",563,725]
[28,"Isaac","Beard","Paulista",null,"2025-04-01","ipsum@ornare.co.uk","SRQ38MSP8QV","16200107-8365",725,164]
[29,"Germane","Whitaker","Herstappe",null,"2017-05-08","pede@ornarelectusante.org","JRT53ZER9NO","16300528-0692",164,894]
[null,"Karly","Ashley","Sperlinga",null,"2016-01-08","gravida@magnaetipsum.net","DZZ19IBZ3NP","16650920-8986",894,146]
[31,"Prescott","Pollard","Bognor Regis",null,"2016-10-28","et@egetipsumDonec.edu","ZYC59BIL0TZ","16601009-3513",146,379]
[32,"Claudia","Bruce","Bossuit",null,"2017-09-23","Sed@amet.co.uk","EHH03PHK1ML","16880716-1321",379,904]
[33,"Ursa","Bass","Dégelis",null,"2020-10-02","pellentesque@sodalesnisimagna.edu","QPK44QTJ0NY","16160305-7728",904,927]
[34,"Yardley","Horne","Midway","Pokus","2016-03-24","mauris.elit@variusultrices.ca","JFG54QOB5WN","16421014-8757",927,137]
[35,"Astra","Barlow","Tiruchirapalli",null,"2017-03-17","Nullam.scelerisque@inaliquet.ca","EKL09DGP5GY","16950219-7768",137,453]
[36,"Cherokee","Jacobs","College",null,"2023-03-01","magna@In.com","YPA73GTL5GO","16290124-8225",453,266]
[37,"Avye","Fowler","Krems an der Donau",null,"2017-04-06","metus@purus.com","GYV17ITR6AN","16960203-1255",266,185]
[38,"Jescie","Compton","Sint-Kwintens-Lennik",null,"2016-03-09","ipsum.non.arcu@Utnec.net","BCU65RAT9LT","16660214-5531",185,817]
[39,"Zahir","Bryan","Salvirola",null,"2016-02-18","Quisque.porttitor@dictummagnaUt.ca","UUZ16HQT1HR","16460611-4181",817,344]
[40,"Tashya","Torres","Stewart",null,"2017-08-04","urna@vitaesodales.ca","DSA51OJP1OH","16430324-2665",344,727]
[41,"Kylynn","French","Bear",null,"2019-06-07","Mauris.vestibulum@estNunc.co.uk","FRE53JFF5GF","16850908-7642",727,630]
[42,"Lev","Mcclain","Tufo",null,"2017-03-29","sed.pede@lorem.net","UHR46DRO3PE","16620506-6811",630,563]
[43,"Allegra","Ware","Llanwrtwd Wells",null,"2016-09-06","a@egestas.com","LJQ58YUM1HY","16890909-7803",563,645]
[44,"Mark","Rice","Wolkrange",null,"2016-02-06","at@nisiMauris.edu","CEC50RCP1XW","16471221-1210",645,120]
[45,"Seth","Oneil","Artena",null,"2017-09-17","lacus.varius.et@Donec.ca","KCE83WMT3YG","16750720-7889",120,868]
[46,"Laura","Bradford","Neuss",null,"2017-07-21","elit.pellentesque.a@erosNamconsequat.net","YVB80MZH7TY","16380608-9185",868,172]
[47,"Demetria","Allen","Toruń",null,"2017-04-01","et@nullavulputatedui.edu","DKD34GYR0BM","16860804-7810",172,603]
[48,"Kieran","Mccarty","Vaux-lez-Rosieres",null,"2017-05-08","nec.orci.Donec@luctus.co.uk","UMM60ZXZ8ER","16950505-2952",603,478]
[49,"Damian","Lynn","Düsseldorf",null,"2016-01-08","est.vitae.sodales@elitEtiam.net","ETH83VKG1XF","16790923-7732",478,347]
[50,"Inga","Buck","Tranås",null,"2016-10-28","Fusce@idrisus.ca","JPT48YIW2LV","16380723-0432",347,264]
[51,"Jorden","Mcintosh","Palermo",null,"2017-09-23","sem@adipiscing.co.uk","JID14QPQ3GJ","16950602-3291",264,720]
[52,"Cameron","Armstrong","Teltow",null,"2016-10-02","enim.nisl.elementum@Proinultrices.net","WEE17DKS4KZ","16670910-8226",720,909]
[53,"Hu","Smith","Alençon",null,"2016-03-24","odio.Etiam.ligula@Aenean.co.uk","GII17PRF9HZ","16910303-5987",909,939]
[null,"Rhoda","Roberts","Aurillac",null,"2017-03-17","Donec@non.ca","CDD20YDN0WN","16430512-3384",939,146]
[55,"Raya","Cummings","North Las Vegas","SMAZAT","2017-03-01","eu@duiquis.edu","JQA50SGP6FP","16060209-9160",146,324]
[56,"Victor","Riley","Pinto","SMAZAT","2017-04-06","amet@erat.ca","BRD68ULQ0MM","16551117-3808",324,107]
[57,"Kylan","Nichols","Waver","SMAZAT","2016-03-09","pharetra.sed@Incondimentum.org","HGV63CYT9WR","16780823-1232",107,525]
[58,"Hector","Davenport","Carbonear",null,"2016-02-18","non.sapien@interdumfeugiatSed.net","ECX11HLJ2ND","16231013-5625",525,279]
[59,"Maisie","Strong","Invergordon",null,"2017-08-04","vulputate.ullamcorper.magna@facilisisfacilisis.net","QCN80WRM4WI","16670929-5239",279,975]
[60,"Graham","Morgan","Ferlach",null,"2017-06-07","et.netus.et@Phasellus.org","TPB52MLZ1ZZ","16980919-9111",975,558]
[null,null,null,null,null,null,null,null,null,558,933]
[null,null,null,null,null,null,null,null,null,933,353]
[null,null,null,null,null,null,null,null,null,353,718]
[64,"Clark","Ortiz","Rouen",null,"2017-09-17","eget@mus.net","JKK84SKJ7CJ","16410207-5373",718,771]
[65,"Felicia","Stokes","Joncret",null,"2017-07-21","dapibus.rutrum.justo@risusMorbi.co.uk","HCM62EWY4BT","16830323-1644",771,372]
[66,"Elaine","Hayden","Ransart",null,"2017-04-01","euismod.in.dolor@euarcu.ca","CFN70URB3HH","16730430-6124",372,597]
[67,"Lyle","Nelson","Orlando",null,"2017-05-08","ac.urna.Ut@scelerisquescelerisque.net","TVD19PCR1MO","16270511-6032",597,614]
[68,"Kelsie","Williamson","Caldarola",null,"2016-01-08","eu@vulputatevelit.org","ZNG04JUH4QE","16740430-0704",614,151]
[69,"Anika","Shaffer","Chiguayante",null,"2016-10-28","congue.a@parturientmontesnascetur.com","LWI81LCU9WD","16681005-4715",151,635]
[70,"Lane","Lancaster","Bal‰tre",null,"2017-09-23","dictum.cursus@sedpede.org","WZT94KPV0BE","16551003-6055",635,113]
[71,"Laurel","Moran","Bras",null,"2016-10-02","facilisis@etlacinia.com","DKX28VRN4HK","16690519-5316",113,977]
[72,"Daria","Chavez","Lot",null,"2016-03-24","ligula@Etiam.net","NRT37OJM9FL","16680827-2733",977,262]
[73,"Martena","Richard","Westlock",null,"2017-03-17","eleifend.Cras@dolor.org","MMR39FOQ3YK","16290111-8857",262,377]
[74,"Haviva","Donaldson","Hillsboro",null,"2017-03-01","venenatis.vel@gravidasagittisDuis.co.uk","HAP69SVQ2FX","16170504-8492",377,905]
[75,"Unity","Mathews","Bolton","SMAZAT","2017-04-06","mi.lacinia@enimconsequat.net","GZL03DVA3KP","16710404-6748",905,771]
[76,"Tanek","Morrow","Göksun","SMAZAT","2016-03-09","Quisque@scelerisquelorem.org","XZD98IJE8IE","16260119-7623",771,971]
[77,"Palmer","Stewart","Rotterdam","SMAZAT","2015-12-13","Praesent@ornare.edu","DOM11SMQ7BI","16820803-9662",971,57]
[78,"Velma","Hickman","Whitehorse","SMAZAT","2016-01-15","orci.Ut@id.co.uk","SJC55MLY2YG","16971007-8024",57,360]
[79,"Constance","Pearson","Maunath Bhanjan","SMAZAT","2017-09-01","massa.Suspendisse.eleifend@sed.co.uk","FZW31QRI4ZE","16130910-1333",360,325]
[80,"Alden","Carter","Darıca","SMAZAT","2016-10-23","Nulla@purus.edu","RHT48WEK2BP","16481223-0342",325,33]
[81,"Brody","Daniel","Haverfordwest","SMAZAT","2016-09-07","semper@auctorvelitAliquam.edu","BVH27KGJ9GK","16030812-2167",33,999]
[82,"Adria","Rodriguez","Ramara",null,"2017-06-17","risus.Donec@porttitor.org","XHO41MKJ6IC","16100603-6063",999,941]
[null,null,null,null,null,null,null,null,null,941,658]
[null,null,null,null,null,null,null,null,null,658,670]
[85,"Jarrod","Donovan","Ceyhan",null,"2016-10-28","et.magnis.dis@bibendumfermentummetus.org","TLR66XHN9UE","16670326-3670",670,388]
[86,"Brandon","Nielsen","Noorderwijk",null,"2017-09-23","dictum@a.net","UDO52JWP4HU","16130204-1130",388,526]
[87,"Michelle","Roberts","Duluth",null,"2016-10-02","sodales@sitametnulla.ca","KRP13WPW2CB","16140627-0502",526,670]
[88,"May","Tillman","Minitonas",null,"2016-03-24","tristique.ac@interdumliberodui.edu","MCA97PLH6CK","16811128-6723",670,0]
[89,"Oren","Patrick","Albagiara",null,"2017-03-17","Suspendisse.non@Namtempordiam.co.uk","QMV94XLL3VX","16840611-3590",248,172]
[90,"Ross","Ellison","Böblingen",null,"2017-03-01","orci@ipsum.ca","PHP13EWV2PQ","16210209-0582",172,299]
[91,"Tate","Tyler","Milwaukee",null,"2017-04-06","Nunc@magnaDuisdignissim.org","BBP02EUQ2WK","16310818-7455",299,966]
[92,"Jolie","Rogers","Klemskerke",null,"2016-03-09","vulputate.dui.nec@nuncsed.ca","ZPD55LGI7YX","16120627-9620",966,488]
[93,"Christopher","Melton","Milwaukee",null,"2016-10-28","rutrum@ametdapibus.org","HIK87MHF0NE","16310121-6483",488,176]
[94,"Ulla","Pace","Shreveport",null,"2017-09-23","Curabitur.sed@ante.edu","NPW77OTL7MB","16971011-4696",176,20]
[95,"Jemima","Santana","Sant'Elpidio a Mare",null,"2016-10-02","ridiculus@Mauris.edu","FRV05FIL2GO","16530107-2392",20,578]
[96,"Ezekiel","Flynn","San Nicolás",null,"2016-03-24","rutrum.Fusce.dolor@eutellus.com","UHU49VWS7ED","16991010-1634",578,222]
[97,"Wynter","Houston","Fort Laird",null,"2017-03-17","rhoncus.Proin@suscipitnonummy.ca","REM87LVK2QP","16480828-9575",222,403]
[98,"Boris","Gamble","Bromley",null,"2017-03-01","nibh@fermentumconvallis.co.uk","QNA82BPU5DL","16200619-9745",403,369]
[99,"Macaulay","Puckett","Precenicco",null,"2017-04-06","nec.eleifend.non@utnullaCras.edu","CRW71FKM4KR","16290602-6477",369,312]
[100,"Jocelyn","Elliott","Owensboro",null,"2016-03-09","ante@semperauctorMauris.edu","WDY95YCO4VK","16551218-7823",312,895]
[101,"Cleo","Harmon","Lions Bay",null,"2016-10-28","rutrum@convallisest.com","ZHY72IEJ9FW","16040604-5476",895,154]
[102,"Harding","Waller","Corbara",null,"2017-09-23","congue.a.aliquet@lacus.net","KXI55HNZ2DB","16490704-4905",154,332]
[103,"Phillip","Lindsay","Saint-Médard-en-Jalles",null,"2016-10-02","odio.semper.cursus@acfacilisis.co.uk","YGK42HIJ2KG","16701006-1153",332,315]
[104,"Ferris","Browning","Whitehaven",null,"2016-03-24","justo.faucibus@Maecenasornare.com","BST33LCH3DE","16841117-0320",315,586]
[105,"Tallulah","Hunter","Cervinara",null,"2017-03-17","est@mollisnon.org","WGU30PRF9TQ","16760309-9248",586,77]

{"sheet":"Nastavení","index":2,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Dnešní den",{"$f":"TODAY()","v":"2020-11-24"}]
[]
[null,"Kurz EUR",25,"Kč"]