{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Úkoly","Data","Kódy"],"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":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1]]}
["VBA úkol"]
["Celkem 30 bodů"]
[]
[]
["Provést úpravy - do jednoho tlačítka"]
["pokud vám nebude fungovat můžete rozdělit"]
["Doporučení: data si zálohujte třeba do dalšího listu "]
[]
["Úpravit tabulku (promazat prazdné řádky, sloupce)","5 b"]
["prázdný: pokud buňka - sloupec A, nebo řádek 1 je prázdná"]
[]
["Promazat řádky obsahující ve sloupci G text \"SMAŽ\"","5 b"]
["Pozor: po promázení sloupců se může daný sloupec přesunout"]
[]
["Odstranit barvy pozadí na bezbarvé","5 b"]
["lze i bílé pozadí"]
[]
["První řádek (zahlaví) - změn na kurzívu a pozadí modré","5 b"]
["odstín barvy je na vás"]
[]
["Označit řádky kdy den ve sloupci F (Datum) je starší než dnešní den ","7 b"]
["Lze využít vzorec pro zadání dnešního dne)"]
[]
["Vše v jednom tlačítku ","3 b"]

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

{"sheet":"Kódy","index":2,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Kódy"]
[]
[null,"Cyklus",null,null,"Podmínky"]
[]
[null,null,"For i = 1 to 5",null,"if ……. Then"]
[null,null,null,null,"   else"]
[null,null,"Next i",null,"End if"]
[]
[]
[null,"Poslední řádek",null,null,"Zapiš vzorec do buňky"]
[null,null,"PosledniPlnyRadek = Cells(Rows.Count, \"A\").End(xlUp).Row ' Ve sloupci A "]
[null,null,"MsgBox \"Poslední obsazený řádek má číslo: \" & PosledniPlnyRadek",null,"Cells(2, 2).Formula = \"=A1\""]
[]
[null,null,null,null,"Range(\"B4\").Formula = \"=A1\""]
[null,"Poslední sloupec"]
[null,null,"PosledniPlnySloupec = Cells(1, Columns.Count).End(xlToLeft).Column ' V řádku 1",null,"Zapiš vzorec do buňky dynamicky"]
[null,null,"MsgBox \"Poslední obsazený sloupec má číslo: \" & PosledniPlnySloupec"]
[null,null,null,null,"k = 1"]
[null,"Smazání prázdných řádku",null,null,"Range(\"A4\").Formula = \"=D\" & (k)"]
[]
[null,null,"For i = 7 To 1 Step -1 "]
[null,null,"  If StrComp(\"\", Cells(i, \"A\").Value) = 0 Then ",null,"Zapiš vzorec do buňky dynamicky"]
[null,null,"      MsgBox i "]
[null,null,"      Rows(i).Delete ",null,"Hodnota = \"E2\" "]
[null,null,"  End If ",null,"Range(\"I3\").Formula = \"=SUM(D2:\" & Hodnota & \")\""]
[null,null,"Next i",null,"Range(\"I3\").FormulaLocal = \"=SUMA(D2:\" & Hodnota & \")\""]
[null,null,null,null,"    Cells(i, 12).FormulaLocal = \"=DNES()\""]
[null,null,null,null,"    Cells(i, 11).FormulaR1C1 = \"=RC[1]-RC[-5]\""]
[]
[null,"Smazání řádku splňující  podmínku",null,null,"Barva pozadí"]
[]
[null,null,"For i = 30 To 27 Step -1"]
[null,null,"    If StrComp(\"smazat\", Cells(i, \"A\").Value) = 0 Then",null,"Range(\"B21\").Interior.Color = RGB(255, 0, 0)"]
[null,null,"        MsgBox i"]
[null,null,"        Rows(i).Delete",null,"Range(\"L16\").Interior.Color = RGB(50, 50, 50)"]
[null,null,"    End If",null,"Range(\"L17\").Interior.Color = RGB(100, 100, 100)"]
[null,null,"Next i"]
[null,null,null,null,"tučné písmo"]
[]
[null,null,null,null," Range(\"B4\").Font.Bold = True"]