{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Overview","Create a Custom Function","Dataset-1","Function in Cell","Function in Formula","Function in VBA Macro","Without Arguments","Dataset-2","One Argument","Multiple Arguments","Mandatory & Optional Arguments","Dataset-3","Array Argument-Odd","Array Argument-Even","Error Handling"],"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":"Overview","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Comparing Built-in and VBA Custom Functions"]
[]
[null,"Book Name","Excel's Built-in Functions","Custom Function"]
[null,"The Black Swan",{"$f":"IF(TRIM(B5)=\"\",\"\",LEN(B5)-LEN(SUBSTITUTE(B5,\" \",\"\"))+1)","v":3},{"$f":"WordCount(B5)","v":3}]
[null,"Psychology of Money",{"$f":"IF(TRIM(B6)=\"\",\"\",LEN(B6)-LEN(SUBSTITUTE(B6,\" \",\"\"))+1)","v":3},{"$f":"WordCount(B6)","v":3}]
[null,"House of Wisdom",3,{"$f":"WordCount(B7)","v":3}]
[null,"Why Nations Fail",3,{"$f":"WordCount(B8)","v":3}]
[null,"Prisoners of Geography",3,{"$f":"WordCount(B9)","v":3}]
[null,"Never Split the Difference",4,{"$f":"WordCount(B10)","v":4}]
[null,"Thinking, Fast and Slow",4,{"$f":"WordCount(B11)","v":4}]

{"sheet":"Create a Custom Function","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Create a Custom Function in Excel VBA"]
[]
[null,"ISBN","Book Name","Price"]
[null,"978-1-5445-11","The Black Swan",22]
[null,"978-1-5445-12","Psychology of Money",30]
[null,"978-1-5445-13","House of Wisdom",25]
[null,"978-1-5445-14","Why Nations Fail",20]
[null,"978-1-5445-15","Prisoners of Geography",18]
[null,"978-1-5445-16","Never Split the Difference",25]
[null,"978-1-5445-17","Thinking, Fast and Slow",30]
[]
[null,"Book Name","Formatted Output"]
[null,"Why Nations Fail",{"$f":"Get_text_with_format(B14,TRUE)","v":"WHY NATIONS FAIL"}]

{"sheet":"Dataset-1","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Transaction Data"]
[]
[null,"Transaction ID","Date","Amount","Type"]
[null,113725648,"2021-01-09",1212,"Credit"]
[null,112725654,"2021-02-19",4977,"Debit"]
[null,114725649,"2021-03-27",4192,"Debit"]
[null,126725612,"2021-07-25",1296,"Credit"]
[null,127256111,"2021-12-30",4877,"Debit"]
[null,125725603,"2022-04-15",1903,"Credit"]
[null,133725606,"2022-06-18",2796,"Debit"]
[null,133725679,"2022-10-10",1307,"Credit"]
[null,143795629,"2022-11-29",4372,"Debit"]
[null,143715690,"2023-02-24",1133,"Credit"]

{"sheet":"Function in Cell","index":3,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using the Function in a Cell"]
[]
[null,"Transaction ID","Date","Amount","Type"]
[null,113725648,"2021-01-09",1212,"Credit"]
[null,112725654,"2021-02-19",4977,"Debit"]
[null,114725649,"2021-03-27",4192,"Debit"]
[null,126725612,"2021-07-25",1296,"Credit"]
[null,127256111,"2021-12-30",4877,"Debit"]
[null,125725603,"2022-04-15",1903,"Credit"]
[null,133725606,"2022-06-18",2796,"Debit"]
[null,133725679,"2022-10-10",1307,"Credit"]
[null,143795629,"2022-11-29",4372,"Debit"]
[null,143715690,"2023-02-24",1133,"Credit"]
[]
[null,"Start Date","End Date","Type","Total"]
[null,"2021-01-01","2021-12-31","Debit",{"$f":"TransactionTotal(B17,C17,D17)","v":14046}]

{"sheet":"Function in Formula","index":4,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4],[15,3,15,4],[16,3,16,4]]}
[]
[null,"Using the Function in a Formula"]
[]
[null,"Transaction ID","Date","Amount","Type"]
[null,113725648,"2021-01-09",1212,"Credit"]
[null,112725654,"2021-02-19",4977,"Debit"]
[null,114725649,"2021-03-27",4192,"Debit"]
[null,126725612,"2021-07-25",1296,"Credit"]
[null,127256111,"2021-12-30",4877,"Debit"]
[null,125725603,"2022-04-15",1903,"Credit"]
[null,133725606,"2022-06-18",2796,"Debit"]
[null,133725679,"2022-10-10",1307,"Credit"]
[null,143795629,"2022-11-29",4372,"Debit"]
[null,143715690,"2023-02-24",1133,"Credit"]
[]
[null,"Start Date","End Date","Total Transaction"]
[null,"2021-01-01","2021-12-31",{"$f":"SUM(TransactionTotal(B17,C17,\"Debit\"),TransactionTotal(B17,C17,\"Credit\"))","v":16554}]

{"sheet":"Function in VBA Macro","index":5,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying the Function in a VBA Macro"]
[]
[null,"Transaction ID","Date","Amount","Type"]
[null,113725648,"2021-01-09",1212,"Credit"]
[null,112725654,"2021-02-19",4977,"Debit"]
[null,114725649,"2021-03-27",4192,"Debit"]
[null,126725612,"2021-07-25",1296,"Credit"]
[null,127256111,"2021-12-30",4877,"Debit"]
[null,125725603,"2022-04-15",1903,"Credit"]
[null,133725606,"2022-06-18",2796,"Debit"]
[null,133725679,"2022-10-10",1307,"Credit"]
[null,143795629,"2022-11-29",4372,"Debit"]
[null,143715690,"2023-02-24",1133,"Credit"]
[]
[null,"Start Date","End Date","Type"]
[null,"2021-01-01","2022-12-31","Credit"]

{"sheet":"Without Arguments","index":6,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Custom Function without Any Arguments"]
[]
[null,"Worksheet Name"]
[null,{"$f":"GetWsheetName()","v":"Overview"}]
[null,"Create a Custom Function"]
[null,"Dataset-1"]
[null,"Function in Cell"]
[null,"Function in Formula"]
[null,"Function in VBA Macro"]
[null,"Without Arguments"]
[null,"Dataset-2"]
[null,"One Argument"]
[null,"Multiple Arguments"]
[null,"Mandatory & Optional Arguments"]
[null,"Dataset-3"]
[null,"Array Argument-Odd"]
[null,"Array Argument-Even"]
[null,"Error Handling"]

{"sheet":"Dataset-2","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"List of Best Sellers"]
[]
[null,"ISBN","Book Name","Price"]
[null,"978-1-5445-11","The Black Swan",22]
[null,"978-1-5445-12","Psychology of Money",30]
[null,"978-1-5445-13","House of Wisdom",25]
[null,"978-1-5445-14","Why Nations Fail",20]
[null,"978-1-5445-15","Prisoners of Geography",18]
[null,"978-1-5445-16","Never Split the Difference",25]
[null,"978-1-5445-17","Thinking, Fast and Slow",30]

{"sheet":"One Argument","index":8,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Custom Function with One Argument"]
[]
[null,"ISBN","Book Name","Price"]
[null,"978-1-5445-11","The Black Swan",22]
[null,"978-1-5445-12","Psychology of Money",30]
[null,"978-1-5445-13","House of Wisdom",25]
[null,"978-1-5445-14","Why Nations Fail",20]
[null,"978-1-5445-15","Prisoners of Geography",18]
[null,"978-1-5445-16","Never Split the Difference",25]
[null,"978-1-5445-17","Thinking, Fast and Slow",30]
[]
[null,"Book Name","Word Count"]
[null,"Why Nations Fail",{"$f":"WordCount(B14)","v":3}]

{"sheet":"Multiple Arguments","index":9,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Custom Function with Multiple Arguments"]
[]
[null,"Transaction ID","Date","Amount","Type"]
[null,113725648,"2021-01-09",1212,"Credit"]
[null,112725654,"2021-02-19",4977,"Debit"]
[null,114725649,"2021-03-27",4192,"Debit"]
[null,126725612,"2021-07-25",1296,"Credit"]
[null,127256111,"2021-12-30",4877,"Debit"]
[null,125725603,"2022-04-15",1903,"Credit"]
[null,133725606,"2022-06-18",2796,"Debit"]
[null,133725679,"2022-10-10",1307,"Credit"]
[null,143795629,"2022-11-29",4372,"Debit"]
[null,143715690,"2023-02-24",1133,"Credit"]
[]
[null,"Transaction ID","Amount"]
[null,125725603,{"$f":"LookupValue(B17,B5:E14,3)","v":1903}]

{"sheet":"Mandatory & Optional Arguments","index":10,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Custom Function with Mandatory and Optional Argument"]
[]
[null,"ISBN","Book Name","Price"]
[null,"978-1-5445-11","The Black Swan",22]
[null,"978-1-5445-12","Psychology of Money",30]
[null,"978-1-5445-13","House of Wisdom",25]
[null,"978-1-5445-14","Why Nations Fail",20]
[null,"978-1-5445-15","Prisoners of Geography",18]
[null,"978-1-5445-16","Never Split the Difference",25]
[null,"978-1-5445-17","Thinking, Fast and Slow",30]
[]
[null,"Book Name","Formatted Output"]
[null,"Why Nations Fail",{"$f":"Get_text_with_format(B14,TRUE)","v":"WHY NATIONS FAIL"}]
[null,"The Black Swan",{"$f":"Get_text_with_format(B15,FALSE)","v":"The Black Swan"}]

{"sheet":"Dataset-3","index":11,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[4,2,13,2]]}
[]
[null,"List of Numbers"]
[]
[null,"Numbers","Sum of Numbers"]
[null,34]
[null,65]
[null,81]
[null,12]
[null,95]
[null,23]
[null,56]
[null,78]
[null,56]
[null,45]

{"sheet":"Array Argument-Odd","index":12,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[4,2,13,2]]}
[]
[null,"Custom Function with Array as Argument"]
[]
[null,"Numbers","Sum of Odd Numbers"]
[null,34,{"$f":"sum_even_odd_numbers(B5:B14,\"odd\")","v":309}]
[null,65]
[null,81]
[null,12]
[null,95]
[null,23]
[null,56]
[null,78]
[null,56]
[null,45]

{"sheet":"Array Argument-Even","index":13,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[4,2,13,2]]}
[]
[null,"Custom Function with Array as Argument"]
[]
[null,"Numbers","Sum of Even Numbers"]
[null,34,{"$f":"sum_even_odd_numbers(B5:B14,\"even\")","v":236}]
[null,65]
[null,81]
[null,12]
[null,95]
[null,23]
[null,56]
[null,78]
[null,56]
[null,45]

{"sheet":"Error Handling","index":14,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Error Handling to Prevent Errors"]
[]
[null,"Transaction ID","Date","Amount","Type"]
[null,113725648,"2021-01-09",1212,"Credit"]
[null,112725654,"2021-02-19",4977,"Debit"]
[null,114725649,"2021-03-27",4192,"Debit"]
[null,126725612,"2021-07-25",1296,"Credit"]
[null,127256111,"2021-12-30",4877,"Debit"]
[null,125725603,"2022-04-15",1903,"Credit"]
[null,133725606,"2022-06-18",2796,"Debit"]
[null,133725679,"2022-10-10",1307,"Credit"]
[null,143795629,"2022-11-29",4372,"Debit"]
[null,143715690,"2023-02-24",1133,"Credit"]
[]
[null,"Start Date","End Date","Type","Total"]
[null,"2021-01-01","2021-12-31","Credit",{"$f":"TransactionTotal_ErrHandle(B17,C17,D17)","v":2508}]