{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Problem","Solution"],"not_rendered":{"charts":0,"images":1,"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":"Problem","index":0,"n_rows":125,"n_cols":8,"rows_kept":125,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Excel VBA Projects for Practice"]
[]
[null,"Project 01: Spell Dollar Amount in Words"]
[]
[null,"Invoice","Date","Amount","Dollar Amount in Words"]
[null,"I-ID-01","2022-07-11",500]
[null,"I-ID-02","2022-07-11",599.99]
[null,"I-ID-03","2022-07-11",2000]
[null,"I-ID-04","2022-07-11",520]
[null,"I-ID-05","2022-07-11",1775]
[null,"I-ID-06","2022-07-12",0.99]
[null,"I-ID-07","2022-07-13",0.01]
[null,"I-ID-08","2022-07-14",0]
[null,"I-ID-09","2022-07-15",25]
[null,"I-ID-10","2022-07-15",75.010000000000005]
[null,"I-ID-11","2022-07-15",20005]
[null,"I-ID-12","2022-07-16",452]
[null,"I-ID-13","2022-07-17",9999]
[null,"I-ID-14","2022-07-17",10001]
[null,"I-ID-15","2022-07-17",500000]
[null,"I-ID-16","2022-07-18",1000000000]
[null,"I-ID-17","2022-07-18",99]
[null,"I-ID-18","2022-07-18",63]
[null,"I-ID-19","2022-07-18",2723]
[null,"I-ID-20","2022-07-19",2824]
[]
[null,"Project 02: Send Email to a List of Recipients"]
[]
[null,"Date Joined","First Name","Last Name","Email Address"]
[null,"2022-07-11","Brian","Lara","brian.lara@demomail.com"]
[null,"2022-07-11","Christopher","Gayle","christopher.gayle@demomail.com"]
[null,"2022-07-11","Ricky","Ponting","ricky.ponting@demomail.com"]
[null,"2022-07-11","George","Welles","george.welles@demomail.com"]
[null,"2022-07-11","Henry","Perot","henry.perot@demomail.com"]
[null,"2022-07-12","Keith","Murdoch","keith.murdoch@demomail.com"]
[null,"2022-07-13","Joseph","Kipling","joseph.kipling@demomail.com"]
[null,"2022-07-14","John","Coolidge","john.coolidge@demomail.com"]
[null,"2022-07-15","William","Porter","william.porter@demomail.com"]
[null,"2022-07-15","Thomas","Connery","thomas.connery@demomail.com"]
[null,"2022-07-15","Henry","Beatty","henry.beatty@demomail.com"]
[null,"2022-07-16","Robyn","Fenty","robyn.fenty@demomail.com"]
[null,"2022-07-17","Mary","Fanning","mary.fanning@demomail.com"]
[null,"2022-07-17","Walter","Willis","walter.willis@demomail.com"]
[null,"2022-07-17","James","McCarthy","james.mccarthy@demomail.com"]
[null,"2022-07-18","Hannah","Fanning","hannah.fanning@demomail.com"]
[null,"2022-07-18","William","Pitt","william.pitt@demomail.com"]
[null,"2022-07-18","John","Depp","john.depp@demomail.com"]
[null,"2022-07-18","David","Schwimmer","david.schwimmer@demomail.com"]
[null,"2022-07-19","Lisa","Kudrow","lisa.kudrow@demomail.com"]
[]
[null,"Project 03: Create a Basic Calculator"]
[]
[null,"Number1",null,"Number2"]
[null,"Output"]
[]
[]
[]
[]
[]
[]
[]
[null,"Project 04: Prepare a Digital Clock"]
[]
[]
[]
[null,"Project 05: Display All Possible Permutations"]
[]
[null,"Permutations"]
[]
[]
[]
[]
[]
[null,null,null,"Input"]
[null,null,null,"ACDS","<<< Input the String here and Run Module"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Project 06: Count Cells by Fill Color"]
[]
[null,"Name","Physics","Chemistry"]
[null,"Ron",37,87]
[null,"Sam",88,48]
[null,"Bob",79,85,null,"Color","Count"]
[null,"Emma",76,44,null,null,null,"<<< use user defined function here"]
[null,"Sara",82,72]
[null,"Tim",95,69]
[null,"Arteus",50,66]
[null,"Baldur",39,83]
[null,"Amelia",59,75]
[null,"Heather",38,81]
[null,"Jacob",51,41]
[null,"Ben",93,51]
[null,"Ross",67,43]
[null,"Joey",45,88]
[null,"Chandler",93,45]
[null,"Phoebe",83,91]
[null,"Monica",67,43]
[null,"Rachel",81,82]
[null,"Targamus",93,68]
[null,"Gilberto",62,83]
[]
[null,"Project 07: Create VBA Date Picker"]
[]
[]
[]
[]
[]
[null,null,"<<< Return the Date here"]

{"sheet":"Solution","index":1,"n_rows":125,"n_cols":7,"rows_kept":125,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Excel VBA Projects for Practice"]
[]
[null,"Project 01: Spell Dollar Amount in Words"]
[]
[null,"Invoice","Date","Amount","Dollar Amount in Words"]
[null,"I-ID-01","2022-07-11",500,{"$f":"Dollar_To_Words(D7)","v":"Five Hundred Dollars"}]
[null,"I-ID-02","2022-07-11",599.99,{"$f":"Dollar_To_Words(D8)","v":"Five Hundred Ninety Nine Dollars and Ninety Nine Cents"}]
[null,"I-ID-03","2022-07-11",2000,{"$f":"Dollar_To_Words(D9)","v":"Two Thousand Dollars"}]
[null,"I-ID-04","2022-07-11",520,{"$f":"Dollar_To_Words(D10)","v":"Five Hundred Twenty Dollars"}]
[null,"I-ID-05","2022-07-11",1775,{"$f":"Dollar_To_Words(D11)","v":"One Thousand Seven Hundred Seventy Five Dollars"}]
[null,"I-ID-06","2022-07-12",0.99,{"$f":"Dollar_To_Words(D12)","v":"No Dollars and Ninety Nine Cents"}]
[null,"I-ID-07","2022-07-13",0.01,{"$f":"Dollar_To_Words(D13)","v":"No Dollars and One Cent"}]
[null,"I-ID-08","2022-07-14",0,{"$f":"Dollar_To_Words(D14)","v":"No Dollars"}]
[null,"I-ID-09","2022-07-15",25,{"$f":"Dollar_To_Words(D15)","v":"Twenty Five Dollars"}]
[null,"I-ID-10","2022-07-15",75.010000000000005,{"$f":"Dollar_To_Words(D16)","v":"Seventy Five Dollars and One Cent"}]
[null,"I-ID-11","2022-07-15",20005,{"$f":"Dollar_To_Words(D17)","v":"Twenty Thousand Five Dollars"}]
[null,"I-ID-12","2022-07-16",452,{"$f":"Dollar_To_Words(D18)","v":"Four Hundred Fifty Two Dollars"}]
[null,"I-ID-13","2022-07-17",9999,{"$f":"Dollar_To_Words(D19)","v":"Nine Thousand Nine Hundred Ninety Nine Dollars"}]
[null,"I-ID-14","2022-07-17",10001,{"$f":"Dollar_To_Words(D20)","v":"Ten Thousand One Dollars"}]
[null,"I-ID-15","2022-07-17",500000,{"$f":"Dollar_To_Words(D21)","v":"Five Hundred Thousand Dollars"}]
[null,"I-ID-16","2022-07-18",1000000000,{"$f":"Dollar_To_Words(D22)","v":"One Billion Dollars"}]
[null,"I-ID-17","2022-07-18",99,{"$f":"Dollar_To_Words(D23)","v":"Ninety Nine Dollars"}]
[null,"I-ID-18","2022-07-18",63,{"$f":"Dollar_To_Words(D24)","v":"Sixty Three Dollars"}]
[null,"I-ID-19","2022-07-18",2723,{"$f":"Dollar_To_Words(D25)","v":"Two Thousand Seven Hundred Twenty Three Dollars"}]
[null,"I-ID-20","2022-07-19",2824,{"$f":"Dollar_To_Words(D26)","v":"Two Thousand Eight Hundred Twenty Four Dollars"}]
[]
[null,"Project 02: Send Email to a List of Recipients"]
[]
[null,"Date Joined","First Name","Last Name","Email Address"]
[null,"2022-07-11","Brian","Lara","brian.lara@demomail.com"]
[null,"2022-07-11","Christopher","Gayle","christopher.gayle@demomail.com"]
[null,"2022-07-11","Ricky","Ponting","ricky.ponting@demomail.com"]
[null,"2022-07-11","George","Welles","george.welles@demomail.com"]
[null,"2022-07-11","Henry","Perot","henry.perot@demomail.com"]
[null,"2022-07-12","Keith","Murdoch","keith.murdoch@demomail.com"]
[null,"2022-07-13","Joseph","Kipling","joseph.kipling@demomail.com"]
[null,"2022-07-14","John","Coolidge","john.coolidge@demomail.com"]
[null,"2022-07-15","William","Porter","william.porter@demomail.com"]
[null,"2022-07-15","Thomas","Connery","thomas.connery@demomail.com"]
[null,"2022-07-15","Henry","Beatty","henry.beatty@demomail.com"]
[null,"2022-07-16","Robyn","Fenty","robyn.fenty@demomail.com"]
[null,"2022-07-17","Mary","Fanning","mary.fanning@demomail.com"]
[null,"2022-07-17","Walter","Willis","walter.willis@demomail.com"]
[null,"2022-07-17","James","McCarthy","james.mccarthy@demomail.com"]
[null,"2022-07-18","Hannah","Fanning","hannah.fanning@demomail.com"]
[null,"2022-07-18","William","Pitt","william.pitt@demomail.com"]
[null,"2022-07-18","John","Depp","john.depp@demomail.com"]
[null,"2022-07-18","David","Schwimmer","david.schwimmer@demomail.com"]
[null,"2022-07-19","Lisa","Kudrow","lisa.kudrow@demomail.com"]
[]
[null,"Project 03: Create a Basic Calculator"]
[]
[null,"Number1",5,"Number2",5]
[null,"Output",1]
[]
[]
[]
[]
[]
[]
[]
[null,"Project 04: Prepare a Digital Clock"]
[]
[]
[]
[null,"Project 05: Display All Possible Permutations"]
[]
[null,"Permutations"]
[null,"ACDS"]
[null,"ACSD"]
[null,"ADCS"]
[null,"ADSC"]
[null,"ASCD"]
[null,"ASDC",null,"Input"]
[null,"CADS",null,"ACDS"]
[null,"CASD"]
[null,"CDAS"]
[null,"CDSA"]
[null,"CSAD"]
[null,"CSDA"]
[null,"DACS"]
[null,"DASC"]
[null,"DCAS"]
[null,"DCSA"]
[null,"DSAC"]
[null,"DSCA"]
[null,"SACD"]
[null,"SADC"]
[null,"SCAD"]
[null,"SCDA"]
[null,"SDAC"]
[null,"SDCA"]
[]
[null,"Project 06: Count Cells by Fill Color"]
[]
[null,"Name","Physics","Chemistry"]
[null,"Ron",37,87]
[null,"Sam",88,48]
[null,"Bob",79,85,null,"Color","Count"]
[null,"Emma",76,44,null,null,{"$f":"CountCellBy_FillColor(C98:D117,F101)","v":16}]
[null,"Sara",82,72]
[null,"Tim",95,69]
[null,"Arteus",50,66]
[null,"Baldur",39,83]
[null,"Amelia",59,75]
[null,"Heather",38,81]
[null,"Jacob",51,41]
[null,"Ben",93,51]
[null,"Ross",67,43]
[null,"Joey",45,88]
[null,"Chandler",93,45]
[null,"Phoebe",83,91]
[null,"Monica",67,43]
[null,"Rachel",81,82]
[null,"Targamus",93,68]
[null,"Gilberto",62,83]
[]
[null,"Project 07: Create VBA Date Picker"]
[]
[]
[]
[]
[]
[null,"2022-12-28","<<< Return the Date here"]