{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Button","Combobox","Check Box","Spin","List","Option","Group Box","Scroll Bar","List (2)"],"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":"Button","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Form Control: Button"]

{"sheet":"Combobox","index":1,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,2,1,5],[1,14,1,17]]}
[]
[null,null,"Form Control: Combo Box",null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,null,"Month","Investment","Sales ","Profit/Loss",null,null,null,null,null,null,null,null,"Month","Investment","Sales ","Profit/Loss"]
[null,1,"January",1000,2500,{"$f":"E5-D5","v":1500},null,null,null,null,null,null,null,1,"January",1000,2500,{"$f":"Q5-P5","v":1500}]
[null,2,"February",1200,2900,{"$f":"E6-D6","v":1700},null,null,null,null,null,null,null,2,"February",1200,2900,{"$f":"Q6-P6","v":1700}]
[null,3,"March",1900,3700,1800,null,null,null,null,null,null,null,3,"March",1900,3700,1800]
[null,4,"April",1400,2500,1100,null,null,null,null,null,null,null,4,"April",1400,2500,1100]
[null,5,"May",2500,3100,600,null,null,null,null,null,null,null,5,"May",2500,3100,600]
[null,6,"June",3100,2740,-360,null,null,null,null,null,null,null,6,"June",3100,2740,-360]
[null,7,"July",1700,1800,100,null,null,null,null,null,null,null,7,"July",1700,1800,100]
[null,8,"August",1650,1900,250,null,null,null,null,null,null,null,8,"August",1650,1900,250]
[null,9,"September",2800,3650,850,null,null,null,null,null,null,null,9,"September",2800,3650,850]
[null,10,"October",3400,4000,600,null,null,null,null,null,null,null,10,"October",3400,4000,600]
[null,11,"November",1100,2400,1300,null,null,null,null,null,null,null,11,"November",1100,2400,1300]
[null,12,"December",2000,1650,-350,null,null,null,null,null,null,null,12,"December",2000,1650,-350]
[]
[]
[]
[null,null,"Month","Profit/Loss"]
[null,2,{"$f":"VLOOKUP($B$21,$B$5:$F$16,2,TRUE)","v":"February"},{"$f":"VLOOKUP($B$21,$B$5:$F$16,5,TRUE)","v":1700}]

{"sheet":"Check Box","index":2,"n_rows":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,13,1,16]]}
[]
[null,"Form Control: Check Box",null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Month","Investment","Sales ","Profit/Loss",null,null,null,null,null,null,null,null,"Month","Investment","Sales ","Profit/Loss"]
[null,"January",1000,2500,{"$f":"D5-C5","v":1500},null,null,null,null,null,null,null,null,"January",1000,2500,{"$f":"P5-O5","v":1500}]
[null,"February",1200,2900,{"$f":"D6-C6","v":1700},null,null,false,null,null,null,null,null,"February",1200,2900,{"$f":"P6-O6","v":1700}]
[null,"March",1900,3700,1800,null,null,null,null,null,null,null,null,"March",1900,3700,1800]
[null,"April",1400,2500,1100,null,null,false,null,null,null,null,null,"April",1400,2500,1100]
[null,"May",2500,3100,600,null,null,null,null,null,null,null,null,"May",2500,3100,600]
[null,"June",3100,2740,-360,null,null,null,null,null,null,null,null,"June",3100,2740,-360]
[null,"July",1700,1800,100,null,null,null,null,null,null,null,null,"July",1700,1800,100]
[null,"August",1650,1900,250,null,null,null,null,null,null,null,null,"August",1650,1900,250]
[null,"September",2800,3650,850,null,null,null,null,null,null,null,null,"September",2800,3650,850]
[null,"October",3400,4000,600,null,null,null,null,null,null,null,null,"October",3400,4000,600]
[null,"November",1100,2400,1300,null,null,null,null,null,null,null,null,"November",1100,2400,1300]
[null,"December",2000,1650,-350,null,null,null,null,null,null,null,null,"December",2000,1650,-350]

{"sheet":"Spin","index":3,"n_rows":19,"n_cols":18,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,2,1,5],[1,14,1,17]]}
[]
[null,null,"Form Control: Spin Button",null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,null,"Month","Investment","Sales ","Profit/Loss",null,null,null,null,null,null,null,null,"Month","Investment","Sales ","Profit/Loss"]
[null,1,"January",1000,2500,{"$f":"E5-D5","v":1500},null,null,null,null,null,null,null,1,"January",1000,2500,{"$f":"Q5-P5","v":1500}]
[null,2,"February",1200,2900,{"$f":"E6-D6","v":1700},null,null,null,null,null,null,null,2,"February",1200,2900,{"$f":"Q6-P6","v":1700}]
[null,3,"March",1900,3700,1800,null,null,null,null,null,null,null,3,"March",1900,3700,1800]
[null,4,"April",1400,2500,1100,null,null,null,null,null,null,null,4,"April",1400,2500,1100]
[null,5,"May",2500,3100,600,null,null,null,null,null,null,null,5,"May",2500,3100,600]
[null,6,"June",3100,2740,-360,null,null,null,null,null,null,null,6,"June",3100,2740,-360]
[null,7,"July",1700,1800,100,null,null,null,null,null,null,null,7,"July",1700,1800,100]
[null,8,"August",1650,1900,250,null,null,null,null,null,null,null,8,"August",1650,1900,250]
[null,9,"September",2800,3650,850,null,null,null,null,null,null,null,9,"September",2800,3650,850]
[null,10,"October",3400,4000,600,null,null,null,null,null,null,null,10,"October",3400,4000,600]
[null,11,"November",1100,2400,1300,null,null,null,null,null,null,null,11,"November",1100,2400,1300]
[null,12,"December",2000,1650,-350,null,null,null,null,null,null,null,12,"December",2000,1650,-350]
[]
[null,null,"Month","Profit/Loss"]
[null,4,{"$f":"VLOOKUP($B$19,$B$5:$F$16,2,TRUE)","v":"April"},{"$f":"VLOOKUP($B$19,$B$5:$F$16,5,TRUE)","v":1100}]

{"sheet":"List","index":4,"n_rows":16,"n_cols":19,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,2,1,5],[1,15,1,18]]}
[]
[null,null,"Form Control: List Box",null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,null,"Month","Investment","Sales ","Profit/Loss",null,null,null,null,null,null,null,null,null,"Month","Investment","Sales ","Profit/Loss"]
[null,1,"January",1000,2500,{"$f":"E5-D5","v":1500},null,null,null,null,null,null,null,null,null,"January",1000,2500,{"$f":"R5-Q5","v":1500}]
[null,2,"February",1200,2900,{"$f":"E6-D6","v":1700},null,null,null,9,null,null,null,null,null,"February",1200,2900,{"$f":"R6-Q6","v":1700}]
[null,3,"March",1900,3700,1800,null,null,null,null,null,null,null,null,null,"March",1900,3700,1800]
[null,4,"April",1400,2500,1100,null,null,null,null,null,null,null,null,null,"April",1400,2500,1100]
[null,5,"May",2500,3100,600,null,null,null,null,null,null,null,null,null,"May",2500,3100,600]
[null,6,"June",3100,2740,-360,null,null,null,null,null,null,null,null,null,"June",3100,2740,-360]
[null,7,"July",1700,1800,100,null,null,null,null,null,null,null,null,null,"July",1700,1800,100]
[null,8,"August",1650,1900,250,null,null,null,null,null,null,null,null,null,"August",1650,1900,250]
[null,9,"September",2800,3650,850,null,null,null,null,null,null,null,null,null,"September",2800,3650,850]
[null,10,"October",3400,4000,600,null,null,null,null,null,null,null,null,null,"October",3400,4000,600]
[null,11,"November",1100,2400,1300,null,null,null,null,null,null,null,null,null,"November",1100,2400,1300]
[null,12,"December",2000,1650,-350,null,null,null,null,null,null,null,null,null,"December",2000,1650,-350]

{"sheet":"Option","index":5,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,13,1,17]]}
[]
[null,"Form Control: Option Button",null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,null,"Month","Investment","Sales ","Profit/Loss",null,null,null,null,null,null,null,null,"Month","Investment","Sales ","Profit/Loss"]
[null,1,null,1000,2500,{"$f":"E5-D5","v":1500},1,null,null,null,null,null,null,1,null,1000,2500,{"$f":"Q5-P5","v":1500}]
[null,2,null,1200,2900,{"$f":"E6-D6","v":1700},null,null,null,null,null,null,null,2,null,1200,2900,{"$f":"Q6-P6","v":1700}]
[null,3,null,1900,3700,1800,null,null,null,null,null,null,null,3,null,1900,3700,1800]
[null,4,null,1400,2500,1100,null,null,null,null,null,null,null,4,null,1400,2500,1100]
[null,5,null,2500,3100,600,null,null,null,null,null,null,null,5,null,2500,3100,600]
[null,6,null,3100,2740,-360,null,null,null,null,null,null,null,6,null,3100,2740,-360]
[null,7,null,1700,1800,100,null,null,null,null,null,null,null,7,null,1700,1800,100]
[null,8,null,1650,1900,250,null,null,null,null,null,null,null,8,null,1650,1900,250]
[null,9,null,2800,3650,850,null,null,null,null,null,null,null,9,null,2800,3650,850]
[null,10,null,3400,4000,600,null,null,null,null,null,null,null,10,null,3400,4000,600]
[null,11,null,1100,2400,1300,null,null,null,null,null,null,null,11,null,1100,2400,1300]
[null,12,null,2000,1650,-350,null,null,null,null,null,null,null,12,null,2000,1650,-350]

{"sheet":"Group Box","index":6,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Form Control: Group Box"]
[]
[null,"Month","Investment","Sales ","Profit/Loss"]
[null,"January",1000,2500,{"$f":"D5-C5","v":1500}]
[null,"February",1200,2900,{"$f":"D6-C6","v":1700},null,null,false]
[null,"March",1900,3700,1800]
[null,"April",1400,2500,1100,null,null,false]
[null,"May",2500,3100,600]
[null,"June",3100,2740,-360]
[null,"July",1700,1800,100]
[null,"August",1650,1900,250]
[null,"September",2800,3650,850]
[null,"October",3400,4000,600]
[null,"November",1100,2400,1300]
[null,"December",2000,1650,-350]

{"sheet":"Scroll Bar","index":7,"n_rows":19,"n_cols":18,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,2,1,5],[1,14,1,17]]}
[]
[null,null,"Form Control: Scroll Bar",null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,null,"Month","Investment","Sales ","Profit/Loss",null,null,null,null,null,null,null,null,"Month","Investment","Sales ","Profit/Loss"]
[null,1,"January",1000,2500,{"$f":"E5-D5","v":1500},null,null,null,null,null,null,null,1,"January",1000,2500,{"$f":"Q5-P5","v":1500}]
[null,2,"February",1200,2900,{"$f":"E6-D6","v":1700},null,null,null,null,null,null,null,2,"February",1200,2900,{"$f":"Q6-P6","v":1700}]
[null,3,"March",1900,3700,1800,null,null,null,null,null,null,null,3,"March",1900,3700,1800]
[null,4,"April",1400,2500,1100,null,null,null,null,null,null,null,4,"April",1400,2500,1100]
[null,5,"May",2500,3100,600,null,null,null,null,null,null,null,5,"May",2500,3100,600]
[null,6,"June",3100,2740,-360,null,null,null,null,null,null,null,6,"June",3100,2740,-360]
[null,7,"July",1700,1800,100,null,null,null,null,null,null,null,7,"July",1700,1800,100]
[null,8,"August",1650,1900,250,null,null,null,null,null,null,null,8,"August",1650,1900,250]
[null,9,"September",2800,3650,850,null,null,null,null,null,null,null,9,"September",2800,3650,850]
[null,10,"October",3400,4000,600,null,null,null,null,null,null,null,10,"October",3400,4000,600]
[null,11,"November",1100,2400,1300,null,null,null,null,null,null,null,11,"November",1100,2400,1300]
[null,12,"December",2000,1650,-350,null,null,null,null,null,null,null,12,"December",2000,1650,-350]
[]
[null,null,"Month","Profit/Loss"]
[null,1,{"$f":"VLOOKUP($B$19,$B$5:$F$16,2,TRUE)","v":"January"},{"$f":"VLOOKUP($B$19,$B$5:$F$16,5,TRUE)","v":1500}]

{"sheet":"List (2)","index":8,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":true,"merged":[[1,2,1,5]]}
[]
[null,null,"Overview of Excel Form Controls"]
[]
[null,null,"Month","Investment","Sales ","Profit/Loss"]
[null,1,"January",1000,2500,{"$f":"E5-D5","v":1500}]
[null,2,"February",1200,2900,{"$f":"E6-D6","v":1700},null,null,null,8]
[null,3,"March",1900,3700,1800]
[null,4,"April",1400,2500,1100]
[null,5,"May",2500,3100,600]
[null,6,"June",3100,2740,-360]
[null,7,"July",1700,1800,100]
[null,8,"August",1650,1900,250]
[null,9,"September",2800,3650,850]
[null,10,"October",3400,4000,600]
[null,11,"November",1100,2400,1300]
[null,12,"December",2000,1650,-350]
[]
[]
[]
[]
[null,6,"Month","Profit/Loss"]
[null,8,{"$f":"VLOOKUP($B$22,$B$5:$F$16,2,TRUE)","v":"August"},{"$f":"VLOOKUP($B$22,$B$5:$F$16,5,TRUE)","v":250}]