{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Cover","Golden","FT & FE","FT & FE (an)","HW===>>","HW(1)","HW(1an)","HW(2)","HW(2an)","HW(3)","HW(3an)","HW(4)","HW(4an)","HW(5)","HW(5an)"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"Cover","index":0,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
["Excel Basics 12: Comprehensive  Formula Lesson of Formula Types & Formula Elements (12 Examples)"]
[]
[null,null,null,null,"Office 2016 Video #24"]
[null,null,"Number Formulas?"]
[null,null,"Text Formulas?"]
[null,null,"Logical Formulas?"]
[]
[null,null,"12 Amazing Formulas"]
[null,1,{"$f":"'FT & FE'!B17","v":"Goal: Add calls made a service center last week."},{"$f":"'FT & FE (an)'!D30","v":"=SUM(C23:C29)"},null,null,null,null,null,null,null,null,null,{"$f":"\"Formula \"&TEXT(B10,\"00\")&\": \"&C10&\": \"&D10","v":"Formula 01: Goal: Add calls made a service center last week.: =SUM(C23:C29)"}]
[null,2,{"$f":"'FT & FE'!B32","v":"Goal: Calculate Monthly Insurance Expense."},{"$f":"'FT & FE (an)'!D38","v":"=C37/12"},null,null,null,null,null,null,null,null,null,{"$f":"\"Formula \"&TEXT(B11,\"00\")&\": \"&C11&\": \"&D11","v":"Formula 02: Goal: Calculate Monthly Insurance Expense.: =C37/12"}]
[null,3,{"$f":"'FT & FE'!B40","v":"Goal: Calculate Deduction for Each Employee."},{"$f":"'FT & FE (an)'!E46","v":"=ROUND(C46*$F$46,2)"},null,null,null,null,null,null,null,null,null,"Formula 03: Goal: Calculate Deduction for Each Employee.: =ROUND(C46*$F$46,2)"]
[null,4,{"$f":"'FT & FE'!B52","v":"Goal: Calculate Cost of Goods Sold (COGS) in Accounting"},{"$f":"'FT & FE (an)'!G58","v":"=(C58-D58)*E58"},null,null,null,null,null,null,null,null,null,"Formula 04: Goal: Calculate Cost of Goods Sold (COGS) in Accounting: =(C58-D58)*E58"]
[null,5,{"$f":"'FT & FE'!B64","v":"Goal: Join \"Text \" and an Item Number into One Cell."},{"$f":"'FT & FE (an)'!E70","v":"=\"Item # \"&C70"},null,null,null,null,null,null,null,null,null,"Formula 05: Goal: Join \"Text \" and an Item Number into One Cell.: =\"Item # \"&C70"]
[null,6,{"$f":"'FT & FE'!B76","v":"Goal: Join First & Last Names into One Cell."},{"$f":"'FT & FE (an)'!F82","v":"=C82&\", \"&B82"},null,null,null,null,null,null,null,null,null,"Formula 06: Goal: Join First & Last Names into One Cell.: =C82&\", \"&B82"]
[null,7,{"$f":"'FT & FE'!B90","v":"Goal: Extract State Abbreviation using the RIGHT Function"},{"$f":"'FT & FE (an)'!D96","v":"=RIGHT(B96,2)"},null,null,null,null,null,null,null,null,null,"Formula 07: Goal: Extract State Abbreviation using the RIGHT Function: =RIGHT(B96,2)"]
[null,8,{"$f":"'FT & FE'!B102","v":"Goal: Extract Product Number using the LEFT Function"},{"$f":"'FT & FE (an)'!D108","v":"=LEFT(B108,6)"},null,null,null,null,null,null,null,null,null,"Formula 08: Goal: Extract Product Number using the LEFT Function: =LEFT(B108,6)"]
[null,9,{"$f":"'FT & FE'!B115","v":"Goal: Determine If Debits = Credits"},{"$f":"'FT & FE (an)'!F127","v":"=B127=C127"},null,null,null,null,null,null,null,null,null,"Formula 09: Goal: Determine If Debits = Credits: =B127=C127"]
[null,10,{"$f":"'FT & FE'!B129","v":"Goal: Determine If Employee Gets a Bonus"},{"$f":"'FT & FE (an)'!E135","v":"=C135>=$F$135"},null,null,null,null,null,null,null,null,null,"Formula 10: Goal: Determine If Employee Gets a Bonus: =C135>=$F$135"]
[null,11,{"$f":"'FT & FE'!B142","v":"Goal: Count how many of each product we sold"},{"$f":"'FT & FE (an)'!D156","v":"=COUNTIFS($B$148:$B$153,B156)"},null,null,null,null,null,null,null,null,null,"Formula 11: Goal: Count how many of each product we sold: =COUNTIFS($B$148:$B$153,B156)"]
[null,12,{"$f":"'FT & FE'!B160","v":"Goal: Formula to determine whether we need to reorder?"},{"$f":"'FT & FE (an)'!F166","v":"=$D$173>B166-C166"},null,null,null,null,null,null,null,null,null,"Formula 12: Goal: Formula to determine whether we need to reorder?: =$D$173>B166-C166"]
[null,13,{"$f":"'FT & FE (an)'!B176","v":"Goal: Calculate Net Income"},{"$f":"'FT & FE (an)'!D186","v":"=C181-SUM(C182:C185)"},null,null,null,null,null,null,null,null,null,"Formula 13: Goal: Calculate Net Income: =C181-SUM(C182:C185)"]

{"sheet":"Golden","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"FT & FE","index":2,"n_rows":186,"n_cols":8,"rows_kept":186,"cut":false,"hidden":false,"merged":[]}
[null,"Formula Types:"]
[null,"1) Number formulas that deliver a single number answers such as a tax deduction amount or a budgetary expense amount."]
[null,"2) Text formulas that deliver a text item such as a name or category."]
[null,"3) Logical formulas (Boolean Formulas) deliver a TRUE or FALSE."]
[]
[null,"Formula Elements:"]
[null,"1) Equal sign, ="]
[null,"2) Cell references,   like A1, $A$1, A1:A10, $A$1:$A$10"]
[null,"3) Math operators, -, +, /, *, ^, and ( )"]
[null,"4) Numbers (if they won’t change),   like 12 months"]
[null,"5) Built-in Functions,   like SUM and ROUND"]
[null,"6) Join operator: Ampersand (&),   like First & Last Name"]
[null,"7) Text within quotation marks,   like \", \""]
[null,"8) Comparative operators, >, <, >=, <=, =, <>, like:      Your Sales >= Hurdle"]
[]
[]
["Ex 1","Goal: Add calls made a service center last week."]
[null,"Type of Formula: Number Formula."]
[null,"Formula Elements: Equal Sign, Built-in Function,"]
[null,"Range of Cells"]
[]
[null,"Day","Calls"]
[null,"2017-10-30",671]
[null,"2017-10-31",374]
[null,"2017-11-01",586]
[null,"2017-11-02",637]
[null,"2017-11-03",1007]
[null,"2017-11-04",549]
[null,"2017-11-05",556]
[null,"Total"]
[]
["Ex 2","Goal: Calculate Monthly Insurance Expense.",null,null,null,null,"Math Operators."]
[null,"Type of Formula: Number Formula.",null,null,null,null,"+","Adding."]
[null,"Formula Elements: Equal Sign, Cell Reference,",null,null,null,null,"-","Subtracting or Negation."]
[null,"Math Operator, Number.",null,null,null,null,"*","Multiplying."]
[null,null,null,null,null,null,"/","Dividing."]
[null,"Annual Insurance",13500,null,"** 12 months in year can not change",null,"^","Raising to an exponent."]
[null,"Monthly Allocation",null,null,"We are not violating Excel's Golden Rule",null,"( )","Parentheses."]
[]
["Ex 3","Goal: Calculate Deduction for Each Employee."]
[null,"Type of Formula: Number Formula."]
[null,"Formula Elements: Equal Sign, Built-In Function, Relative Cell Reference, "]
[null,"Math Operator, Absolute Cell Reference, Number"]
[]
[null,"Employee","Gross Pay","Deduction",null,"Tax Rate"]
[null,"Sioux",2830.34,null,null,0.16750000000000001]
[null,"Chin",2239.9299999999998]
[null,"Tyrone",2953.98,null,null,"** 2 for penny will not change"]
[null,"Gigi",2926.74,null,null,"We are not violating Excel's Golden Rule"]
[null,null,"Total"]
[]
["Ex 4","Goal: Calculate Cost of Goods Sold (COGS) in Accounting"]
[null,"Type of Formula: Number Formula."]
[null,"Formula Elements: Equal Sign, Parenthesis, Relative Cell Reference, Math Operator,"]
[null,"Relative Cell Reference, Parenthesis, Math Operator, Relative Cell Reference"]
[]
[null,"Product","Beginning Quantity","End Quantity","Value Each","COGS"]
[null,"Aspen",114,45,10]
[null,"Quad",146,117,20]
[null,"Carlota",108,102,15,null,null,"Remember Order of Operations in Math:"]
[null,"Bellen",61,47,10,null,null,"1) Parentheses"]
[null,"Sunset",54,51,12,null,null,"2) Exponents"]
[null,null,null,null,null,null,null,"3) Multiply & Divide, Left to Right"]
["Ex 5","Goal: Join \"Text \" and an Item Number into One Cell.",null,null,null,null,null,"4) Adding and Subtracting, Left to Right"]
[null,"Type of Formula: Text Formula."]
[null,"Formula Elements: Equal Sign, Text in Double Quotes,"]
[null,"Join Operator (&), Relative Cell Reference"]
[]
[null,"Product","Item Number","Item # & Number",null,"Join Operator = & = Ampersand or And Symbol (Keyboard = Shift + 7)"]
[null,"Aspen",517231,null,null,"Join Operator allows to  join to items together into one cell, like joining First and Last Name"]
[null,"Quad",469890,null,null,"Formula like; =\"Item # \"&C43 joins text in double quotes and a number from a cell"]
[null,"Carlota",162451,null,null,"Anytime you have to put text into a formula, you must use Double Quotes"]
[null,"Bellen",114541,null,null,"\"Item # \" will not change"]
[null,"Sunset",832593]
[]
["Ex 6","Goal: Join First & Last Names into One Cell."]
[null,"Type of Formula: Text Formula."]
[null,"Formula Elements: Equal Sign, Relative Cell Reference"]
[null,"Join Operator, Text In Double Quotes, Join Operator, Relative Cell Reference"]
[]
[null,"First","Last","Join","Last, First"]
[null,"Jimmy","Garza",null,null,null,"\"Text in Double Quotes\" will not change"]
[null,"Emma","Petrov",null,null,null,"We are not violating Excel's Golden Rule"]
[null,"Rolando","Robbins"]
[null,"Abdi","Amari"]
[null,"ShelaDown","Cohen"]
[null,"Sioux","Radcoolinator"]
[null,"Miki","Ito"]
[]
["Ex 7","Goal: Extract State Abbreviation using the RIGHT Function"]
[null,"Type of Formula: Text Formula."]
[null,"Formula Elements: Equal Sign, Built-in Function,"]
[null,"Relative Cell Reference, Number"]
[]
[null,"Product Code","State Abbreviation",null,"** 2 for state abbreviation length will not change"]
[null,"517231 Aspen, CO",null,null,"We are not violating Excel's Golden Rule"]
[null,"469890 Quad, CA"]
[null,"162451 Carlota, WA"]
[null,"114541 Bellen, CA"]
[null,"832593 Sunset, CO"]
[]
["Ex8","Goal: Extract Product Number using the LEFT Function"]
[null,"Type of Formula: Text Formula."]
[null,"Formula Elements: Equal Sign, Built-in Function,"]
[null,"Relative Cell Reference, Number"]
[]
[null,"Product Code","Product Number"]
[null,"517231, Aspen",null,null,"** 6 for product code length will not change"]
[null,"469890, Quad",null,null,"We are not violating Excel's Golden Rule"]
[null,"162451, Carlota"]
[null,"114541, Bellen"]
[null,"832593, Sunset"]
[]
[]
["Ex 9","Goal: Determine If Debits = Credits"]
[null,"Type of Formula: Logical Formula."]
[null,"Formula Elements: Equal sign, Cell Reference,"]
[null,"Equal sign (as Comparative Operator), Cell Reference"]
[null,null,null,null,null,null,"Comparative Operators."]
[null,"Debit (DR)","Credit (CR)",null,null,null,"=","Equal: are two things equal?"]
[null,35.74,35.74,null,null,null,"<>","Not: are two things not equal? Type less than symbol, then greater than symbol."]
[null,73.61,73.61,null,null,null,">","Greater than: is the thing on the left greater than the thing on the right?"]
[null,113.08,113.08,null,null,null,">=","Greater than or equal to: is the thing on the left greater than or equal to the thing on the right?"]
[null,100.49,100.5,null,null,null,"<","Less than: is the thing on the left less than the thing on the right?"]
[null,17.7,17.7,null,null,null,"<=","Less than or equal to: is the thing on the left less than or equal to the thing on the right?"]
[null,107.38,107.38,null,"In Balance?"]
[null,{"$f":"SUM(B121:B126)","v":448},448.01]
[]
["Ex10","Goal: Determine If Employee Gets a Bonus"]
[null,"Type of Formula: Logical Formula."]
[null,"Formula Elements: Equal sign, Relative Cell Reference,"]
[null,"Comparative Operator, Absolute Cell Reference"]
[]
[null,"Employee","Sales","Do they Get Bonus?",null,"Hurdle to Get Bonus"]
[null,"Emma Petrov",55000,null,null,55000]
[null,"Rolando Robbins",41197.980000000003]
[null,"Abdi Amari",74558.649999999994,null,null,"Comparative Operators."]
[null,"ShelaDown Cohen",53741.33,null,null,"=","Equal: are two things equal?"]
[null,"Sioux Radcoolinator",37251.06,null,null,"<>","Not: are two things not equal? Type less than symbol, then greater than symbol."]
[null,"Miki Ito",54999.99,null,null,">","Greater than: is the thing on the left greater than the thing on the right?"]
[null,null,null,null,null,">=","Greater than or equal to: is the thing on the left greater than or equal to the thing on the right?"]
["Ex11","Goal: Count how many of each product we sold",null,null,null,"<","Less than: is the thing on the left less than the thing on the right?"]
[null,"Type of Formula: Number Formula.",null,null,null,"<=","Less than or equal to: is the thing on the left less than or equal to the thing on the right?"]
[null,"Formula Elements: Equal Sign, Built-in Function, Absolute Range of Cells,"]
[null,"Relative Cell Reference",null,null,null,"≥"]
[null,null,null,null,null,"≤"]
[null,"Product","Sales"]
[null,"Quad",43]
[null,"Sunset",23]
[null,"Sunset",23]
[null,"Quad",43]
[null,"Aspen",19.95]
[null,"Quad",43]
[]
[null,"Product","Count"]
[null,"Aspen"]
[null,"Quad"]
[null,"Sunset"]
[]
["Ex12","Goal: Formula to determine whether we need to reorder?",null,null,null,null,1,"Parenthesis ( )"]
[null,"Type of Formula: Logical Formula.",null,null,null,null,2,"Reference Operators: colon, comma"]
[null,"Formula Elements: Equal Sign, Absolute Cell Reference, Comparative Operator,",null,null,null,null,null,"Example of colon in range of cells: =SUM(A1:A4)"]
[null,"Relative Cell Reference, Math Operator, Relative Cell Reference",null,null,null,null,null,"Example of comma (union): =SUM(E10:G10,E14:G14)"]
[null,null,null,null,null,null,3,"Negation (-)"]
[null,"Beginning Quantity","Units Sold","On Hand Units","Do we need to Re-order?",null,null,"Example: = -2^4 = 16"]
[null,114,45,{"$f":"B166-C166","v":69},null,null,null,"Example: = -(2^4) = -16"]
[null,146,121,{"$f":"B167-C167","v":25},null,null,4,"Converts % (1% to .01)"]
[null,108,102,6,null,null,5,"Exponents (^)"]
[null,61,21,40,null,null,null,"Example: 3^2 = 9"]
[null,54,51,3,null,null,6,"Multiplication (*) and Division (/), left to right"]
[null,null,null,null,null,null,7,"Adding (+) and Subtracting (-), left to right"]
[null,null,null,"Reorder Hurdle",null,null,8,"Ampersand (&)"]
[null,null,null,25,null,null,9,"Comparative symbols: =, <>, >=, <=, <, >"]
[null,null,null,{"$f":"\"** If we have \"&D173&\" or more, we do not need to re-order.\"","v":"** If we have 25 or more, we do not need to re-order."}]
[null,null,null,null,"** 24 or less, we need to re-order"]
["Ex13","Goal: Calculate Net Income",null,null,null,"=$D$173>B166-C166"]
[null,"Type of Formula: Number Formula.",null,null,null,"=B166-C166<$D$173"]
[null,"Formula Elements: Equal Sign, Cell Reference, Built-in Function,"]
[null,"Range of Cells"]
[]
[null,"Revenue",125700]
[null,"Rent Expense",12500]
[null,"Wage Expense",22000]
[null,"Operation Expense",11500]
[null,"COGS",69570]
[null,"Net Income"]

{"sheet":"FT & FE (an)","index":3,"n_rows":186,"n_cols":8,"rows_kept":186,"cut":false,"hidden":false,"merged":[]}
[null,"Formula Types:"]
[null,"1) Number formulas that deliver a single number answers such as a tax deduction amount or a budgetary expense amount."]
[null,"2) Text formulas that deliver a text item such as a name or category."]
[null,"3) Logical formulas (Boolean Formulas) deliver a TRUE or FALSE."]
[]
[null,"Formula Elements:"]
[null,"1) Equal sign, ="]
[null,"2) Cell references,   like A1, $A$1, A1:A10, $A$1:$A$10"]
[null,"3) Math operators, -, +, /, *, ^, and ( )"]
[null,"4) Numbers (if they won’t change),   like 12 months"]
[null,"5) Built-in Functions,   like SUM and ROUND"]
[null,"6) Join operator: Ampersand (&),   like First & Last Name"]
[null,"7) Text within quotation marks,   like \", \""]
[null,"8) Comparative operators, >, <, >=, <=, =, <>, like:      Your Sales >= Hurdle"]
[]
[]
["Ex 1","Goal: Add calls made a service center last week."]
[null,"Type of Formula: Number Formula."]
[null,"Formula Elements: Equal Sign, Built-in Function,"]
[null,"Range of Cells"]
[]
[null,"Day","Calls"]
[null,"2017-10-30",671]
[null,"2017-10-31",374]
[null,"2017-11-01",586]
[null,"2017-11-02",637]
[null,"2017-11-03",1007]
[null,"2017-11-04",549]
[null,"2017-11-05",556]
[null,"Total",{"$f":"SUM(C23:C29)","v":4380},{"$f":"IF(_xlfn.ISFORMULA(C30),_xlfn.FORMULATEXT(C30),\"\")","v":"=SUM(C23:C29)"}]
[]
["Ex 2","Goal: Calculate Monthly Insurance Expense.",null,null,null,null,"Math Operators."]
[null,"Type of Formula: Number Formula.",null,null,null,null,"+","Adding."]
[null,"Formula Elements: Equal Sign, Cell Reference,",null,null,null,null,"-","Subtracting or Negation."]
[null,"Math Operator, Number.",null,null,null,null,"*","Multiplying."]
[null,null,null,null,null,null,"/","Dividing."]
[null,"Annual Insurance",13500,null,"** 12 months in year can not change",null,"^","Raising to an exponent."]
[null,"Monthly Allocation",{"$f":"C37/12","v":1125},{"$f":"IF(_xlfn.ISFORMULA(C38),_xlfn.FORMULATEXT(C38),\"\")","v":"=C37/12"},"We are not violating Excel's Golden Rule",null,"( )","Parentheses."]
[]
["Ex 3","Goal: Calculate Deduction for Each Employee."]
[null,"Type of Formula: Number Formula."]
[null,"Formula Elements: Equal Sign, Built-In Function, Relative Cell Reference, "]
[null,"Math Operator, Absolute Cell Reference, Number"]
[]
[null,"Employee","Gross Pay","Deduction",null,"Tax Rate"]
[null,"Sioux",2830.34,{"$f":"ROUND(C46*$F$46,2)","v":474.08},{"$f":"IF(_xlfn.ISFORMULA(D46),_xlfn.FORMULATEXT(D46),\"\")","v":"=ROUND(C46*$F$46,2)"},0.16750000000000001]
[null,"Chin",2239.9299999999998,{"$f":"ROUND(C47*$F$46,2)","v":375.19}]
[null,"Tyrone",2953.98,494.79,null,"** 2 for penny will not change"]
[null,"Gigi",2926.74,{"$f":"ROUND(C49*$F$46,2)","v":490.23},null,"We are not violating Excel's Golden Rule"]
[null,null,"Total",{"$f":"SUM(D46:D49)","v":1834.29}]
[]
["Ex 4","Goal: Calculate Cost of Goods Sold (COGS) in Accounting"]
[null,"Type of Formula: Number Formula."]
[null,"Formula Elements: Equal Sign, Parenthesis, Relative Cell Reference, Math Operator,"]
[null,"Relative Cell Reference, Parenthesis, Math Operator, Relative Cell Reference"]
[]
[null,"Product","Beginning Quantity","End Quantity","Value Each","COGS"]
[null,"Aspen",114,45,10,{"$f":"(C58-D58)*E58","v":690},{"$f":"IF(_xlfn.ISFORMULA(F58),_xlfn.FORMULATEXT(F58),\"\")","v":"=(C58-D58)*E58"}]
[null,"Quad",146,117,20,{"$f":"(C59-D59)*E59","v":580}]
[null,"Carlota",108,102,15,90,null,"Remember Order of Operations in Math:"]
[null,"Bellen",61,47,10,140,null,"1) Parentheses"]
[null,"Sunset",54,51,12,36,null,"2) Exponents"]
[null,null,null,null,null,null,null,"3) Multiply & Divide, Left to Right"]
["Ex 5","Goal: Join \"Text \" and an Item Number into One Cell.",null,null,null,null,null,"4) Adding and Subtracting, Left to Right"]
[null,"Type of Formula: Text Formula."]
[null,"Formula Elements: Equal Sign, Text in Double Quotes,"]
[null,"Join Operator (&), Relative Cell Reference"]
[]
[null,"Product","Item Number","Item # & Number",null,"Join Operator = & = Ampersand or And Symbol (Keyboard = Shift + 7)"]
[null,"Aspen",517231,{"$f":"\"Item # \"&C70","v":"Item # 517231"},{"$f":"IF(_xlfn.ISFORMULA(D70),_xlfn.FORMULATEXT(D70),\"\")","v":"=\"Item # \"&C70"},"Join Operator allows to  join to items together into one cell, like joining First and Last Name"]
[null,"Quad",469890,{"$f":"\"Item # \"&C71","v":"Item # 469890"},null,"Formula like; =\"Item # \"&C43 joins text in double quotes and a number from a cell"]
[null,"Carlota",162451,"Item # 162451",null,"Anytime you have to put text into a formula, you must use Double Quotes"]
[null,"Bellen",114541,"Item # 114541",null,"\"Item # \" will not change"]
[null,"Sunset",832593,{"$f":"\"Item # \"&C74","v":"Item # 832593"}]
[]
["Ex 6","Goal: Join First & Last Names into One Cell."]
[null,"Type of Formula: Text Formula."]
[null,"Formula Elements: Equal Sign, Relative Cell Reference"]
[null,"Join Operator, Text In Double Quotes, Join Operator, Relative Cell Reference"]
[]
[null,"First","Last","Join","Last, First"]
[null,"Jimmy","Garza",{"$f":"B82&\" \"&C82","v":"Jimmy Garza"},{"$f":"C82&\", \"&B82","v":"Garza, Jimmy"},{"$f":"IF(_xlfn.ISFORMULA(E82),_xlfn.FORMULATEXT(E82),\"\")","v":"=C82&\", \"&B82"},"\"Text in Double Quotes\" will not change"]
[null,"Emma","Petrov",{"$f":"B83&\" \"&C83","v":"Emma Petrov"},{"$f":"C83&\", \"&B83","v":"Petrov, Emma"},null,"We are not violating Excel's Golden Rule"]
[null,"Rolando","Robbins","Rolando Robbins","Robbins, Rolando"]
[null,"Abdi","Amari","Abdi Amari","Amari, Abdi"]
[null,"ShelaDown","Cohen","ShelaDown Cohen","Cohen, ShelaDown"]
[null,"Sioux","Radcoolinator","Sioux Radcoolinator","Radcoolinator, Sioux"]
[null,"Miki","Ito","Miki Ito",{"$f":"C88&\", \"&B88","v":"Ito, Miki"}]
[]
["Ex 7","Goal: Extract State Abbreviation using the RIGHT Function"]
[null,"Type of Formula: Text Formula."]
[null,"Formula Elements: Equal Sign, Built-in Function,"]
[null,"Relative Cell Reference, Number"]
[]
[null,"Product Code","State Abbreviation",null,"** 2 for state abbreviation length will not change"]
[null,"517231 Aspen, CO",{"$f":"RIGHT(B96,2)","v":"CO"},{"$f":"IF(_xlfn.ISFORMULA(C96),_xlfn.FORMULATEXT(C96),\"\")","v":"=RIGHT(B96,2)"},"We are not violating Excel's Golden Rule"]
[null,"469890 Quad, CA",{"$f":"RIGHT(B97,2)","v":"CA"}]
[null,"162451 Carlota, WA","WA"]
[null,"114541 Bellen, CA","CA"]
[null,"832593 Sunset, CO",{"$f":"RIGHT(B100,2)","v":"CO"}]
[]
["Ex8","Goal: Extract Product Number using the LEFT Function"]
[null,"Type of Formula: Text Formula."]
[null,"Formula Elements: Equal Sign, Built-in Function,"]
[null,"Relative Cell Reference, Number"]
[]
[null,"Product Code","Product Number"]
[null,"517231, Aspen",{"$f":"LEFT(B108,6)","v":"517231"},{"$f":"IF(_xlfn.ISFORMULA(C108),_xlfn.FORMULATEXT(C108),\"\")","v":"=LEFT(B108,6)"},"** 6 for product code length will not change"]
[null,"469890, Quad",{"$f":"LEFT(B109,6)","v":"469890"},null,"We are not violating Excel's Golden Rule"]
[null,"162451, Carlota","162451"]
[null,"114541, Bellen","114541"]
[null,"832593, Sunset","832593"]
[]
[]
["Ex 9","Goal: Determine If Debits = Credits"]
[null,"Type of Formula: Logical Formula."]
[null,"Formula Elements: Equal sign, Cell Reference,"]
[null,"Equal sign (as Comparative Operator), Cell Reference"]
[null,null,null,null,null,null,"Comparative Operators."]
[null,"Debit (DR)","Credit (CR)",null,null,null,"=","Equal: are two things equal?"]
[null,35.74,35.74,null,null,null,"<>","Not: are two things not equal? Type less than symbol, then greater than symbol."]
[null,73.61,73.61,null,null,null,">","Greater than: is the thing on the left greater than the thing on the right?"]
[null,113.08,113.08,null,null,null,">=","Greater than or equal to: is the thing on the left greater than or equal to the thing on the right?"]
[null,100.5,100.5,null,null,null,"<","Less than: is the thing on the left less than the thing on the right?"]
[null,17.7,17.7,null,null,null,"<=","Less than or equal to: is the thing on the left less than or equal to the thing on the right?"]
[null,107.38,107.38,null,"In Balance?"]
[null,{"$f":"SUM(B121:B126)","v":448.01},448.01,null,{"$f":"B127=C127","v":true},{"$f":"IF(_xlfn.ISFORMULA(E127),_xlfn.FORMULATEXT(E127),\"\")","v":"=B127=C127"}]
[]
["Ex10","Goal: Determine If Employee Gets a Bonus"]
[null,"Type of Formula: Logical Formula."]
[null,"Formula Elements: Equal sign, Relative Cell Reference,"]
[null,"Comparative Operator, Absolute Cell Reference"]
[]
[null,"Employee","Sales","Do they Get Bonus?",null,"Hurdle to Get Bonus"]
[null,"Emma Petrov",55000,{"$f":"C135>=$F$135","v":true},{"$f":"IF(_xlfn.ISFORMULA(D135),_xlfn.FORMULATEXT(D135),\"\")","v":"=C135>=$F$135"},55000]
[null,"Rolando Robbins",41197.980000000003,{"$f":"C136>=$F$135","v":false}]
[null,"Abdi Amari",74558.649999999994,true,null,"Comparative Operators."]
[null,"ShelaDown Cohen",53741.33,false,null,"=","Equal: are two things equal?"]
[null,"Sioux Radcoolinator",37251.06,false,null,"<>","Not: are two things not equal? Type less than symbol, then greater than symbol."]
[null,"Miki Ito",54999.99,false,null,">","Greater than: is the thing on the left greater than the thing on the right?"]
[null,null,null,null,null,">=","Greater than or equal to: is the thing on the left greater than or equal to the thing on the right?"]
["Ex11","Goal: Count how many of each product we sold",null,null,null,"<","Less than: is the thing on the left less than the thing on the right?"]
[null,"Type of Formula: Number Formula.",null,null,null,"<=","Less than or equal to: is the thing on the left less than or equal to the thing on the right?"]
[null,"Formula Elements: Equal Sign, Built-in Function, Absolute Range of Cells,"]
[null,"Relative Cell Reference",null,null,null,"≥"]
[null,null,null,null,null,"≤"]
[null,"Product","Sales"]
[null,"Quad",43]
[null,"Sunset",23]
[null,"Sunset",23]
[null,"Quad",43]
[null,"Aspen",19.95]
[null,"Quad",43]
[]
[null,"Product","Count"]
[null,"Aspen",{"$f":"COUNTIFS($B$148:$B$153,B156)","v":1},{"$f":"IF(_xlfn.ISFORMULA(C156),_xlfn.FORMULATEXT(C156),\"\")","v":"=COUNTIFS($B$148:$B$153,B156)"}]
[null,"Quad",{"$f":"COUNTIFS($B$148:$B$153,B157)","v":3}]
[null,"Sunset",2]
[]
["Ex12","Goal: Formula to determine whether we need to reorder?",null,null,null,null,1,"Parenthesis ( )"]
[null,"Type of Formula: Logical Formula.",null,null,null,null,2,"Reference Operators: colon, comma"]
[null,"Formula Elements: Equal Sign, Absolute Cell Reference, Comparative Operator,",null,null,null,null,null,"Example of colon in range of cells: =SUM(A1:A4)"]
[null,"Relative Cell Reference, Math Operator, Relative Cell Reference",null,null,null,null,null,"Example of comma (union): =SUM(E10:G10,E14:G14)"]
[null,null,null,null,null,null,3,"Negation (-)"]
[null,"Beginning Quantity","Units Sold","On Hand Units","Do we need to Re-order?",null,null,"Example: = -2^4 = 16"]
[null,114,45,{"$f":"B166-C166","v":69},{"$f":"$D$173>B166-C166","v":false},{"$f":"IF(_xlfn.ISFORMULA(E166),_xlfn.FORMULATEXT(E166),\"\")","v":"=$D$173>B166-C166"},null,"Example: = -(2^4) = -16"]
[null,146,121,{"$f":"B167-C167","v":25},{"$f":"$D$173>B167-C167","v":false},null,4,"Converts % (1% to .01)"]
[null,108,102,6,true,null,5,"Exponents (^)"]
[null,61,21,40,false,null,null,"Example: 3^2 = 9"]
[null,54,51,3,{"$f":"$D$173>B170-C170","v":true},null,6,"Multiplication (*) and Division (/), left to right"]
[null,null,null,null,null,null,7,"Adding (+) and Subtracting (-), left to right"]
[null,null,null,"Reorder Hurdle",null,null,8,"Ampersand (&)"]
[null,null,null,25,null,null,9,"Comparative symbols: =, <>, >=, <=, <, >"]
[null,null,null,{"$f":"\"** If we have \"&D173&\" or more, we do not need to re-order.\"","v":"** If we have 25 or more, we do not need to re-order."}]
[null,null,null,null,"** 24 or less, we need to re-order"]
["Ex13","Goal: Calculate Net Income",null,null,null,"=$D$173>B166-C166"]
[null,"Type of Formula: Number Formula.",null,null,null,"=B166-C166<$D$173"]
[null,"Formula Elements: Equal Sign, Cell Reference, Built-in Function,"]
[null,"Range of Cells"]
[]
[null,"Revenue",125700]
[null,"Rent Expense",12500]
[null,"Wage Expense",22000]
[null,"Operation Expense",11500]
[null,"COGS",69570]
[null,"Net Income",{"$f":"C181-SUM(C182:C185)","v":10130},{"$f":"IF(_xlfn.ISFORMULA(C186),_xlfn.FORMULATEXT(C186),\"\")","v":"=C181-SUM(C182:C185)"}]

{"sheet":"HW===>>","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"HW(1)","index":5,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Goal: Calculate Cost of Goods Sold (COGS) in Accounting. COGS = (Beg-End)*Value Each"]
[]
["Product","Beginning Quantity","End Quantity","Value Each","COGS"]
["Aspen",42,0,12.33]
["Quad",239,178,21.37]
["Carlota",174,81,14.87]
["Bellen",136,42,13.65]
["Sunset",194,96,12.82]
[]
[null,null,null,"** There are no extraneous pennies, so we do not need to use the ROUND Function."]

{"sheet":"HW(1an)","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Goal: Calculate Cost of Goods Sold (COGS) in Accounting. COGS = (Beg-End)*Value Each"]
[]
["Product","Beginning Quantity","End Quantity","Value Each","COGS"]
["Aspen",42,0,12.33,{"$f":"(B4-C4)*D4","v":517.86}]
["Quad",239,178,21.37,1303.5700000000002]
["Carlota",174,81,14.87,1382.9099999999999]
["Bellen",136,42,13.65,1283.1000000000001]
["Sunset",194,96,12.82,1256.3600000000001]
[]
[null,null,null,"** There are no extraneous pennies, so we do not need to use the ROUND Function."]

{"sheet":"HW(2)","index":7,"n_rows":53,"n_cols":3,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Goal: Join First & Last Names into One Cell using a formula."]
[]
["First Name","Last Name","Full Name"]
["Coralie","Land"]
["Anjanette","Pickett"]
["Mellie","Berube"]
["Georgene","Haight"]
["Billi","Smalls"]
["Jacqulyn","Jefferies"]
["Nathanial","Church"]
["Leonia","Otero"]
["Marquita","Vance"]
["Mireille","Laney"]
["Haydee","Peralta"]
["Jenelle","Messer"]
["Mason","Mclean"]
["Lidia","Wylie"]
["Darius","Blackman"]
["Lilli","Benefield"]
["Trisha","Warden"]
["Alexander","Dugas"]
["Imogene","South"]
["Margarito","Tinsley"]
["Augustina","Williford"]
["Nanette","Pettit"]
["Brianne","Yoo"]
["Angla","Zhang"]
["Kayleigh","Towns"]
["Calista","Shelby"]
["Freddie","Houghton"]
["Bernardina","Mireles"]
["Odell","Doran"]
["Darlena","Blodgett"]
["Von","Spence"]
["Mike","Redmon"]
["Bea","Burnette"]
["Lesley","Crider"]
["Jerilyn","Muse"]
["Mary","Teague"]
["Elenor","Toro"]
["Zella","Crutcher"]
["Carmelita","Myrick"]
["Jone","Reece"]
["Sharita","Mcgregor"]
["Lesa","Dillon"]
["Nicolle","Campos"]
["Angeline","Snow"]
["Cornelia","Dehart"]
["Jerrod","Zavala"]
["Donnie","Manley"]
["Selma","Pridgen"]
["Lia","Homan"]
["Merissa","Earl"]

{"sheet":"HW(2an)","index":8,"n_rows":53,"n_cols":3,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Goal: Join First & Last Names into One Cell using a formula."]
[]
["First Name","Last Name","Full Name"]
["Coralie","Land",{"$f":"A4&\" \"&B4","v":"Coralie Land"}]
["Anjanette","Pickett",{"$f":"A5&\" \"&B5","v":"Anjanette Pickett"}]
["Mellie","Berube","Mellie Berube"]
["Georgene","Haight","Georgene Haight"]
["Billi","Smalls","Billi Smalls"]
["Jacqulyn","Jefferies","Jacqulyn Jefferies"]
["Nathanial","Church","Nathanial Church"]
["Leonia","Otero","Leonia Otero"]
["Marquita","Vance","Marquita Vance"]
["Mireille","Laney","Mireille Laney"]
["Haydee","Peralta","Haydee Peralta"]
["Jenelle","Messer","Jenelle Messer"]
["Mason","Mclean","Mason Mclean"]
["Lidia","Wylie","Lidia Wylie"]
["Darius","Blackman","Darius Blackman"]
["Lilli","Benefield","Lilli Benefield"]
["Trisha","Warden","Trisha Warden"]
["Alexander","Dugas","Alexander Dugas"]
["Imogene","South","Imogene South"]
["Margarito","Tinsley","Margarito Tinsley"]
["Augustina","Williford","Augustina Williford"]
["Nanette","Pettit","Nanette Pettit"]
["Brianne","Yoo","Brianne Yoo"]
["Angla","Zhang","Angla Zhang"]
["Kayleigh","Towns","Kayleigh Towns"]
["Calista","Shelby","Calista Shelby"]
["Freddie","Houghton","Freddie Houghton"]
["Bernardina","Mireles","Bernardina Mireles"]
["Odell","Doran","Odell Doran"]
["Darlena","Blodgett","Darlena Blodgett"]
["Von","Spence","Von Spence"]
["Mike","Redmon","Mike Redmon"]
["Bea","Burnette","Bea Burnette"]
["Lesley","Crider","Lesley Crider"]
["Jerilyn","Muse","Jerilyn Muse"]
["Mary","Teague","Mary Teague"]
["Elenor","Toro","Elenor Toro"]
["Zella","Crutcher","Zella Crutcher"]
["Carmelita","Myrick","Carmelita Myrick"]
["Jone","Reece","Jone Reece"]
["Sharita","Mcgregor","Sharita Mcgregor"]
["Lesa","Dillon","Lesa Dillon"]
["Nicolle","Campos","Nicolle Campos"]
["Angeline","Snow","Angeline Snow"]
["Cornelia","Dehart","Cornelia Dehart"]
["Jerrod","Zavala","Jerrod Zavala"]
["Donnie","Manley","Donnie Manley"]
["Selma","Pridgen","Selma Pridgen"]
["Lia","Homan","Lia Homan"]
["Merissa","Earl","Merissa Earl"]

{"sheet":"HW(3)","index":9,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Goal: Determine If Employee Gets a Bonus by creating a formula that delivers a TRUE if their Sales are greater than \"&DOLLAR(E4,0)&\".\"","v":"Goal: Determine If Employee Gets a Bonus by creating a formula that delivers a TRUE if their Sales are greater than $275,000."}]
[]
["Employee","Sales","Do they Get Bonus?",null,"Hurdle to Get Bonus"]
["Rufina Gaylord",518255.4,null,null,275000]
["Logan Jett",201697.4]
["Rina Kilpatrick",183485]
["Dakota Mcclain",375968.3]
["Elfreda Lundy",279628.40000000002]
["Tia Briseno",462232.3]
["Rochell Ulrich",370787.8]
["Rosana Alcala",260098.7]
["Deedee Ledoux",461327]
["Dalia Monk",386667.3]
["Xavier Lozano",220681]
["Raina Hollis",195685.1]
["Lajuana Meier",161110]
["Willian Puckett",460737.4]
["Adaline Glass",418287.5]
["Gaylord Forbes",173385.2]
["Miles Tuggle",315896.8]
["Candra Montalvo",414279.1]
["Roxann Lindstrom",228288.9]
["Karon Bivens",467344.7]
["Jannet Putman",480070.8]
["Kenisha Bingham",372549.5]
["Sharlene Dobson",499725.4]
["Toshia Wilbanks",195820]
["Jude Fielder",328958]
["Kelsey Rupp",505408]
["Rebbecca Kay",268865.8]
["Neely Furman",446130.4]
["Edyth Spaulding",492634.3]
["Eugene Felix",175036.3]
["Layla Samson",210474.6]
["Luann Mathews",171539.5]
["Brendon Harkins",201733.5]
["Russel Waller",393559]
["Vincenzo Steadman",394131.6]
["Eldon Heffner",325929.7]
["Theo Arroyo",500054.6]
["Antionette Dunaway",144362.79999999999]
["Dusty Frias",480052.7]
["Yen Marcus",346188.7]
["Fanny Wiggins",204883.6]
["Quyen Westbrook",223180.6]
["Jae Navarro",270623.8]
["Madeleine Vickery",443911.7]
["Florance Lemmon",184445.3]
["Gillian Ferraro",194937.9]
["Sherika Woodcock",392699.1]
["Shavonne Fitts",265833.8]
["Marisela Story",250453.7]
["Sondra Word",395043.5]

{"sheet":"HW(3an)","index":10,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Goal: Determine If Employee Gets a Bonus by creating a formula that delivers a TRUE if their Sales are greater than \"&DOLLAR(E4,0)&\".\"","v":"Goal: Determine If Employee Gets a Bonus by creating a formula that delivers a TRUE if their Sales are greater than $275,000."}]
[]
["Employee","Sales","Do they Get Bonus?",null,"Hurdle to Get Bonus"]
["Rufina Gaylord",518255.4,{"$f":"B4>$E$4","v":true},null,275000]
["Logan Jett",201697.4,{"$f":"B5>$E$4","v":false}]
["Rina Kilpatrick",183485,false]
["Dakota Mcclain",375968.3,true]
["Elfreda Lundy",279628.40000000002,true]
["Tia Briseno",462232.3,true]
["Rochell Ulrich",370787.8,true]
["Rosana Alcala",260098.7,false]
["Deedee Ledoux",461327,true]
["Dalia Monk",386667.3,true]
["Xavier Lozano",220681,false]
["Raina Hollis",195685.1,false]
["Lajuana Meier",161110,false]
["Willian Puckett",460737.4,true]
["Adaline Glass",418287.5,true]
["Gaylord Forbes",173385.2,false]
["Miles Tuggle",315896.8,true]
["Candra Montalvo",414279.1,true]
["Roxann Lindstrom",228288.9,false]
["Karon Bivens",467344.7,true]
["Jannet Putman",480070.8,true]
["Kenisha Bingham",372549.5,true]
["Sharlene Dobson",499725.4,true]
["Toshia Wilbanks",195820,false]
["Jude Fielder",328958,true]
["Kelsey Rupp",505408,true]
["Rebbecca Kay",268865.8,false]
["Neely Furman",446130.4,true]
["Edyth Spaulding",492634.3,true]
["Eugene Felix",175036.3,false]
["Layla Samson",210474.6,false]
["Luann Mathews",171539.5,false]
["Brendon Harkins",201733.5,false]
["Russel Waller",393559,true]
["Vincenzo Steadman",394131.6,true]
["Eldon Heffner",325929.7,true]
["Theo Arroyo",500054.6,true]
["Antionette Dunaway",144362.79999999999,false]
["Dusty Frias",480052.7,true]
["Yen Marcus",346188.7,true]
["Fanny Wiggins",204883.6,false]
["Quyen Westbrook",223180.6,false]
["Jae Navarro",270623.8,false]
["Madeleine Vickery",443911.7,true]
["Florance Lemmon",184445.3,false]
["Gillian Ferraro",194937.9,false]
["Sherika Woodcock",392699.1,true]
["Shavonne Fitts",265833.8,false]
["Marisela Story",250453.7,false]
["Sondra Word",395043.5,true]

{"sheet":"HW(4)","index":11,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Remind yourself about how to add sales for each product by creating this report in two ways; 1) SUMIFS (you can use teplate provided below) and 2) a PivotTable."]
[]
["Date","Employee","Sales","Product",null,"Product","Total Sales"]
["2017-10-28","Tia Briseno",46223.229999999996,"Quad",null,"Aspen"]
["2017-10-27","Jude Fielder",32895.800000000003,"Carlota",null,"Bellen"]
["2017-10-28","Luann Mathews",17153.95,"Quad",null,"Carlota"]
["2017-10-28","Quyen Westbrook",22318.06,"Quad",null,"Quad"]
["2017-10-28","Fanny Wiggins",20488.36,"Bellen",null,"Sunset"]
["2017-10-28","Sherika Woodcock",39269.909999999996,"Carlota"]
["2017-10-28","Kenisha Bingham",37254.949999999997,"Aspen"]
["2017-10-27","Tia Briseno",22828.89,"Bellen"]
["2017-10-28","Jude Fielder",26009.870000000003,"Bellen"]
["2017-10-27","Luann Mathews",46734.47,"Quad"]
["2017-10-27","Quyen Westbrook",41427.909999999996,"Bellen"]
["2017-10-29","Fanny Wiggins",32592.97,"Carlota"]
["2017-10-27","Sherika Woodcock",16111,"Quad"]
["2017-10-27","Kenisha Bingham",46073.740000000005,"Carlota"]
["2017-10-28","Tia Briseno",22068.1,"Aspen"]
["2017-10-28","Jude Fielder",14436.279999999999,"Sunset"]
["2017-10-28","Luann Mathews",20173.349999999999,"Aspen"]
["2017-10-27","Quyen Westbrook",18444.53,"Aspen"]
["2017-10-27","Fanny Wiggins",27962.840000000004,"Sunset"]
["2017-10-27","Sherika Woodcock",20169.739999999998,"Quad"]
["2017-10-29","Kenisha Bingham",34618.870000000003,"Bellen"]
["2017-10-29","Tia Briseno",31589.68,"Quad"]
["2017-10-27","Jude Fielder",19568.510000000002,"Aspen"]
["2017-10-27","Luann Mathews",21047.46,"Quad"]
["2017-10-29","Quyen Westbrook",39355.9,"Aspen"]
["2017-10-29","Fanny Wiggins",51825.54,"Aspen"]
["2017-10-28","Sherika Woodcock",46132.7,"Quad"]
["2017-10-27","Kenisha Bingham",26886.579999999998,"Sunset"]
["2017-10-29","Tia Briseno",19582,"Quad"]
["2017-10-29","Jude Fielder",26583.379999999997,"Bellen"]
["2017-10-27","Luann Mathews",50005.46,"Bellen"]
["2017-10-28","Quyen Westbrook",39504.35,"Quad"]
["2017-10-28","Fanny Wiggins",27062.379999999997,"Quad"]
["2017-10-27","Sherika Woodcock",37596.83,"Bellen"]
["2017-10-28","Kenisha Bingham",17503.629999999997,"Bellen"]
["2017-10-29","Tia Briseno",44613.04,"Quad"]
["2017-10-28","Jude Fielder",37078.78,"Bellen"]
["2017-10-28","Luann Mathews",49263.43,"Bellen"]
["2017-10-28","Quyen Westbrook",48007.08,"Quad"]
["2017-10-28","Fanny Wiggins",48005.270000000004,"Quad"]
["2017-10-27","Sherika Woodcock",17338.52,"Sunset"]
["2017-10-29","Kenisha Bingham",50540.800000000003,"Bellen"]
["2017-10-27","Tia Briseno",18348.5,"Carlota"]
["2017-10-27","Jude Fielder",19493.79,"Quad"]
["2017-10-29","Luann Mathews",25045.370000000003,"Sunset"]
["2017-10-29","Quyen Westbrook",38666.729999999996,"Quad"]
["2017-10-28","Fanny Wiggins",41828.75,"Bellen"]
["2017-10-27","Sherika Woodcock",39413.159999999996,"Quad"]
["2017-10-29","Kenisha Bingham",44391.17,"Aspen"]
["2017-10-28","Tia Briseno",49972.54,"Aspen"]

{"sheet":"HW(4an)","index":12,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Remind yourself about how to add sales for each product by creating this report in two ways; 1) SUMIFS (you can use teplate provided below) and 2) a PivotTable."]
[]
["Date","Employee","Sales","Product",null,"Product","Total Sales",null,"Product","Sum of Sales"]
["2017-10-28","Tia Briseno",46223.229999999996,"Quad",null,"Aspen",{"$f":"SUMIFS($C$4:$C$53,$D$4:$D$53,F4)","v":303054.58999999997},null,"Aspen",303054.58999999997]
["2017-10-27","Jude Fielder",32895.800000000003,"Carlota",null,"Bellen",{"$f":"SUMIFS($C$4:$C$53,$D$4:$D$53,F5)","v":455774.95999999996},null,"Bellen",455774.95999999996]
["2017-10-28","Luann Mathews",17153.95,"Quad",null,"Carlota",{"$f":"SUMIFS($C$4:$C$53,$D$4:$D$53,F6)","v":169180.91999999998},null,"Carlota",169180.91999999998]
["2017-10-28","Quyen Westbrook",22318.06,"Quad",null,"Quad",{"$f":"SUMIFS($C$4:$C$53,$D$4:$D$53,F7)","v":591828.09},null,"Quad",591828.09]
["2017-10-28","Fanny Wiggins",20488.36,"Bellen",null,"Sunset",{"$f":"SUMIFS($C$4:$C$53,$D$4:$D$53,F8)","v":111669.59},null,"Sunset",111669.59]
["2017-10-28","Sherika Woodcock",39269.909999999996,"Carlota",null,null,null,null,"Grand Total",1631508.1500000001]
["2017-10-28","Kenisha Bingham",37254.949999999997,"Aspen"]
["2017-10-27","Tia Briseno",22828.89,"Bellen"]
["2017-10-28","Jude Fielder",26009.870000000003,"Bellen"]
["2017-10-27","Luann Mathews",46734.47,"Quad"]
["2017-10-27","Quyen Westbrook",41427.909999999996,"Bellen"]
["2017-10-29","Fanny Wiggins",32592.97,"Carlota"]
["2017-10-27","Sherika Woodcock",16111,"Quad"]
["2017-10-27","Kenisha Bingham",46073.740000000005,"Carlota"]
["2017-10-28","Tia Briseno",22068.1,"Aspen"]
["2017-10-28","Jude Fielder",14436.279999999999,"Sunset"]
["2017-10-28","Luann Mathews",20173.349999999999,"Aspen"]
["2017-10-27","Quyen Westbrook",18444.53,"Aspen"]
["2017-10-27","Fanny Wiggins",27962.840000000004,"Sunset"]
["2017-10-27","Sherika Woodcock",20169.739999999998,"Quad"]
["2017-10-29","Kenisha Bingham",34618.870000000003,"Bellen"]
["2017-10-29","Tia Briseno",31589.68,"Quad"]
["2017-10-27","Jude Fielder",19568.510000000002,"Aspen"]
["2017-10-27","Luann Mathews",21047.46,"Quad"]
["2017-10-29","Quyen Westbrook",39355.9,"Aspen"]
["2017-10-29","Fanny Wiggins",51825.54,"Aspen"]
["2017-10-28","Sherika Woodcock",46132.7,"Quad"]
["2017-10-27","Kenisha Bingham",26886.579999999998,"Sunset"]
["2017-10-29","Tia Briseno",19582,"Quad"]
["2017-10-29","Jude Fielder",26583.379999999997,"Bellen"]
["2017-10-27","Luann Mathews",50005.46,"Bellen"]
["2017-10-28","Quyen Westbrook",39504.35,"Quad"]
["2017-10-28","Fanny Wiggins",27062.379999999997,"Quad"]
["2017-10-27","Sherika Woodcock",37596.83,"Bellen"]
["2017-10-28","Kenisha Bingham",17503.629999999997,"Bellen"]
["2017-10-29","Tia Briseno",44613.04,"Quad"]
["2017-10-28","Jude Fielder",37078.78,"Bellen"]
["2017-10-28","Luann Mathews",49263.43,"Bellen"]
["2017-10-28","Quyen Westbrook",48007.08,"Quad"]
["2017-10-28","Fanny Wiggins",48005.270000000004,"Quad"]
["2017-10-27","Sherika Woodcock",17338.52,"Sunset"]
["2017-10-29","Kenisha Bingham",50540.800000000003,"Bellen"]
["2017-10-27","Tia Briseno",18348.5,"Carlota"]
["2017-10-27","Jude Fielder",19493.79,"Quad"]
["2017-10-29","Luann Mathews",25045.370000000003,"Sunset"]
["2017-10-29","Quyen Westbrook",38666.729999999996,"Quad"]
["2017-10-28","Fanny Wiggins",41828.75,"Bellen"]
["2017-10-27","Sherika Woodcock",39413.159999999996,"Quad"]
["2017-10-29","Kenisha Bingham",44391.17,"Aspen"]
["2017-10-28","Tia Briseno",49972.54,"Aspen"]

{"sheet":"HW(5)","index":13,"n_rows":53,"n_cols":2,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Goal: Extract zip code using a formula."]
[]
["Addresses","Zip"]
["41 Jackson Drive , Wasilla, AK 99654"]
["100 Albany St. , Pueblo, CO 81001"]
["9600 Devon Court , Houston, TX 77016"]
["24 Beach Street , Mount Holly, NJ 08060"]
["26 Miller Drive , Manassas, VA 20109"]
["8154 North Maple Street , Fayetteville, NC 28303"]
["8089 Ann Lane , Apex, NC 27502"]
["944 Peninsula Street , New Rochelle, NY 10801"]
["375 Virginia Avenue , West Des Moines, IA 50265"]
["4 Edgewood Street , Jamestown, NY 14701"]
["7869 East Peachtree Road , Hicksville, NY 11801"]
["202 Columbia Drive , Torrance, CA 90505"]
["561 West Lakeview Ave. , Bardstown, KY 40004"]
["992 West Street , North Haven, CT 06473"]
["7 Devon St. , Clifton, NJ 07011"]
["186 Cardinal Dr. , Anderson, SC 29621"]
["23 Lincoln Street , Libertyville, IL 60048"]
["43 S. Franklin Ave. , Coventry, RI 02816"]
["283 Briarwood Street , Mokena, IL 60448"]
["17 Franklin Ave. , Winchester, VA 22601"]
["65 Big Rock Cove Avenue , Hamilton, OH 45011"]
["8274 Pleasant Dr. , Voorhees, NJ 08043"]
["468 Pierce St. , Waterbury, CT 06705"]
["94 North Liberty St. , Lilburn, GA 30047"]
["515 Adams Street , Athens, GA 30605"]
["97 Sherwood Street , Dalton, GA 30721"]
["287 Armstrong Drive , Boynton Beach, FL 33435"]
["32 Old Main St. , Sidney, OH 45365"]
["7936 Durham St. , Antioch, TN 37013"]
["7346 Bald Hill Street , Norfolk, VA 23503"]
["8878 N. Mayflower Street , Zanesville, OH 43701"]
["629 Ridge Dr. , Bettendorf, IA 52722"]
["319 Magnolia St. , Langhorne, PA 19047"]
["78 Homewood St. , Flowery Branch, GA 30542"]
["25 East Liberty Ave. , Vienna, VA 22180"]
["181 Halifax St. , Johnson City, TN 37601"]
["956 Gonzales Lane , East Northport, NY 11731"]
["31 Old Dunbar Ave. , Woodstock, GA 30188"]
["9184 Harrison Dr. , Palm City, FL 34990"]
["654 South Glendale Drive , Stamford, CT 06902"]
["7442 Devon Drive , Perth Amboy, NJ 08861"]
["814 Birchwood Avenue , Absecon, NJ 08205"]
["356 Vine Dr. , Cheshire, CT 06410"]
["51 South Mayfair St. , Atlanta, GA 30303"]
["597 Meadow Street , Canal Winchester, OH 43110"]
["89 E. Rockaway St. , Wethersfield, CT 06109"]
["321 Princeton Dr. , Alpharetta, GA 30004"]
["8842 Fieldstone St. , Naugatuck, CT 06770"]
["36 Birchwood Rd. , Montgomery, AL 36109"]
["640 Sulphur Springs St. , Lorain, OH 44052"]

{"sheet":"HW(5an)","index":14,"n_rows":53,"n_cols":2,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Goal: Extract zip code using a formula."]
[]
["Addresses","Zip"]
["41 Jackson Drive , Wasilla, AK 99654",{"$f":"RIGHT(A4,5)","v":"99654"}]
["100 Albany St. , Pueblo, CO 81001",{"$f":"RIGHT(A5,5)","v":"81001"}]
["9600 Devon Court , Houston, TX 77016","77016"]
["24 Beach Street , Mount Holly, NJ 08060","08060"]
["26 Miller Drive , Manassas, VA 20109","20109"]
["8154 North Maple Street , Fayetteville, NC 28303","28303"]
["8089 Ann Lane , Apex, NC 27502","27502"]
["944 Peninsula Street , New Rochelle, NY 10801","10801"]
["375 Virginia Avenue , West Des Moines, IA 50265","50265"]
["4 Edgewood Street , Jamestown, NY 14701","14701"]
["7869 East Peachtree Road , Hicksville, NY 11801","11801"]
["202 Columbia Drive , Torrance, CA 90505","90505"]
["561 West Lakeview Ave. , Bardstown, KY 40004","40004"]
["992 West Street , North Haven, CT 06473","06473"]
["7 Devon St. , Clifton, NJ 07011","07011"]
["186 Cardinal Dr. , Anderson, SC 29621","29621"]
["23 Lincoln Street , Libertyville, IL 60048","60048"]
["43 S. Franklin Ave. , Coventry, RI 02816","02816"]
["283 Briarwood Street , Mokena, IL 60448","60448"]
["17 Franklin Ave. , Winchester, VA 22601","22601"]
["65 Big Rock Cove Avenue , Hamilton, OH 45011","45011"]
["8274 Pleasant Dr. , Voorhees, NJ 08043","08043"]
["468 Pierce St. , Waterbury, CT 06705","06705"]
["94 North Liberty St. , Lilburn, GA 30047","30047"]
["515 Adams Street , Athens, GA 30605","30605"]
["97 Sherwood Street , Dalton, GA 30721","30721"]
["287 Armstrong Drive , Boynton Beach, FL 33435","33435"]
["32 Old Main St. , Sidney, OH 45365","45365"]
["7936 Durham St. , Antioch, TN 37013","37013"]
["7346 Bald Hill Street , Norfolk, VA 23503","23503"]
["8878 N. Mayflower Street , Zanesville, OH 43701","43701"]
["629 Ridge Dr. , Bettendorf, IA 52722","52722"]
["319 Magnolia St. , Langhorne, PA 19047","19047"]
["78 Homewood St. , Flowery Branch, GA 30542","30542"]
["25 East Liberty Ave. , Vienna, VA 22180","22180"]
["181 Halifax St. , Johnson City, TN 37601","37601"]
["956 Gonzales Lane , East Northport, NY 11731","11731"]
["31 Old Dunbar Ave. , Woodstock, GA 30188","30188"]
["9184 Harrison Dr. , Palm City, FL 34990","34990"]
["654 South Glendale Drive , Stamford, CT 06902","06902"]
["7442 Devon Drive , Perth Amboy, NJ 08861","08861"]
["814 Birchwood Avenue , Absecon, NJ 08205","08205"]
["356 Vine Dr. , Cheshire, CT 06410","06410"]
["51 South Mayfair St. , Atlanta, GA 30303","30303"]
["597 Meadow Street , Canal Winchester, OH 43110","43110"]
["89 E. Rockaway St. , Wethersfield, CT 06109","06109"]
["321 Princeton Dr. , Alpharetta, GA 30004","30004"]
["8842 Fieldstone St. , Naugatuck, CT 06770","06770"]
["36 Birchwood Rd. , Montgomery, AL 36109","36109"]
["640 Sulphur Springs St. , Lorain, OH 44052","44052"]