{"text_format":"1","workbook":"xlsx","n_sheets":28,"sheets":["Cover","Steps","Efficiency","Words","W(1)","Retail","Retail (an)","W(2)","W(2an)","W(3)","W(3an)","W(4)","W(4an)","HW ==>>","HW(1)","HW(1an)","HW(2)","HW(2an)","HW(3)","HW(3an)","HW(4)","HW(4an)","HW(5)","HW(5an)","HW(6)","HW(6an)","HW(7)","HW(7an)"],"not_rendered":{"charts":0,"images":6,"macros":0,"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":"Cover","index":0,"n_rows":25,"n_cols":47,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel & Business Math 09"]
[null,"Five Steps to Solve Math Word Problems in Excel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Math Operators used in Excel",{"$f":"AN5&\") \"&AO5","v":"1) Math Operators used in Excel"}]
[null,null,"Topics:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Math Order of Operations","2) Math Order of Operations"]
[null,null,"1) Five Steps To Solve Math Word Problems:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PROPER(AE7)","v":"Five Steps To Solve Math Word Problems:"},"Five Steps To Solve Math Word Problems:",{"$f":"ROWS(AF$7:AF7)&\") \"&AE7","v":"1) Five Steps To Solve Math Word Problems:"},null,null,null,null,null,null,null,3,"Comparative Operators used in Excel","3) Comparative Operators used in Excel"]
[null,null,"2) Translating English Words Into Math Symbols",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Translating English Words Into Math Symbols","Translating English Words Into Math Symbols",{"$f":"ROWS(AF$7:AF8)&\") \"&AE8","v":"2) Translating English Words Into Math Symbols"},null,null,null,null,null,null,null,4,"Types of Formulas seen in this class","4) Types of Formulas seen in this class"]
[null,null,"3) Formula Efficiency Rules From Video 07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formula Efficiency Rules From Video 07","Formula Efficiency Rules From Video 07",{"$f":"ROWS(AF$7:AF9)&\") \"&AE9","v":"3) Formula Efficiency Rules From Video 07"},null,null,null,null,null,null,null,5,"How to Build Formulas for Business Math","5) How to Build Formulas for Business Math"]
[null,null,"4) Terms Used In Retail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Terms Used In Retail","Terms Used In Retail",{"$f":"ROWS(AF$7:AF10)&\") \"&AE10","v":"4) Terms Used In Retail"}]
[null,null,"5) Four Math Word Examples",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Four Math Word Examples","Four Math Word Examples",{"$f":"ROWS(AF$7:AF11)&\") \"&AE11","v":"5) Four Math Word Examples"},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"REPLACE(AU21,1,SEARCH(\"=\",AU21)-1,\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROWS(AF$7:AF12)&\") \"&AE12","v":"6) "},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"REPLACE(AU22,1,SEARCH(\"=\",AU22)-1,\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROWS(AF$7:AF13)&\") \"&AE13","v":"7) "},null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"REPLACE(AU23,1,SEARCH(\"=\",AU23)-1,\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"REPLACE(AU24,1,SEARCH(\"=\",AU24)-1,\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"REPLACE(AU25,1,SEARCH(\"=\",AU25)-1,\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"REPLACE(AU16,1,SEARCH(\"=\",AU16)-1,\"\")","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"REPLACE(AU17,1,SEARCH(\"=\",AU17)-1,\"\")","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1)","Five Steps To Solve Math Word Problems:",1,null,null,null,null,null,null,{"$f":"REPLACE(AU18,1,SEARCH(\"=\",AU18)-1,\"\")","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2)","Translating English Words Into Math Symbols",1,null,null,null,null,null,null,{"$f":"REPLACE(AU19,1,SEARCH(\"=\",AU19)-1,\"\")","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3)","Formula Efficiency Rules From Video 07:",2,null,null,null,null,null,null,{"$f":"REPLACE(AU20,1,SEARCH(\"=\",AU20)-1,\"\")","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4)","Terms Used In Retail",3,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5)","Math Word Problem 01 From Video:",4,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6)","Math Word Problem 02 From Video:",5,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7)","Math Word Problem 03 From Video:",6,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8)","Math Word Problem 04 From Video:",7,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Steps","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Five Steps to Solve Math Word Problems in Excel:"]
[null,"1) List all relevant facts and numbers with proper labels"]
[null,"2) State the goal of the problem"]
[null,"3) Solve problem using Efficient Excel Methods"]
[null,"4) Check answer"]
[null,"5) Answer the question with a written statement"]

{"sheet":"Efficiency","index":2,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,"Formula Types:"]
[null,"1) Number formulas that deliver a single number answers such as a tax deduction or  a insurance expense."]
[null,"2) Logical formulas (Boolean Formulas) deliver a TRUE or FALSE."]
[]
[null,"Excel's Golden Rule: If a formula input can change, put it in cell, label it and refer to it with a cell reference."]
[]
[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) Comparative operators, >, <, >=, <=, =, <>"]
[]
[null,"Math order of operations"]
[null," ( )"]
[null," ^"]
[null," * / Left to Right"]
[null," + - Left to Right"]
[]
[null,"When to use ROUND Function"]
[null,"1) You are required to round, like with Money."]
[null,"2) You have extraneous decimals, like past the penny position."]
[null,"3) You will use formula result in a subsequent formula."]
[]
[null,"SUM Function Hints:"]
[null,"1) Use SUM Function rather than many plus symbols."]
[null,"2) Do not wrap SUM Function around a calculation when the SUM Function is not necessary:"]

{"sheet":"Words","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Translate Words Into Math Symbols"]
[null,"Add","Subtract","Multiply","Divide","Equal","Powers"]
[null,"plus","less","product","divided by","is","squared"]
[null,"more","subtract","double","divided into","the same as","raised to"]
[null,"more than","subtracted from","triple","quotient","equals","to the second power"]
[null,"added to ","difference","times","goes into","equal to","cubed"]
[null,"increased by","less than","of","divide","yields","to the 12th power"]
[null,"sum","fewer","twice","divided equally","results in"]
[null,"total","decreased by","twice as much","per","are"]
[null,"sum of","loss of"]
[null,"increase of","minus"]
[null,"gain of","take away"]
[null,"add","reduced by"]

{"sheet":"W(1)","index":4,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
["See Word Document at people web site named \"ExcelBusinessMathVideo09WordProblem01.docx\""]

{"sheet":"Retail","index":5,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Some of the terms used in Retail:"]
["Retail Store = Store that sells items to final customer, like Target or Safeway"]
["Retail Price = List Price = Price = Amount collected from customer"]
["Wholesale Cost = Net Cost = Cost = Amount business paid to get the item"]
["Number of Units Sold = Count of number of products sold to customer "]
["Gross Profit per Unit = Price - Cost"]
["Revenue = Price * Number of Units Sold"]
["Cost of Good Sold = COGS = Cost * Number of Units Sold"]
["Gross Profit = Revenue - COGS or Gross Profit per Unit * Number of Units Sold"]
[]
["Example:"]
["Quad Price =",32]
["Quad Cost = ",17.75]
["Number Units Sold =",5]
[]
["Gross Profit per Unit = Price - Cost",null,null,{"$f":"IF(_xlfn.ISFORMULA(B16),_xlfn.FORMULATEXT(B16),\"\")","v":""}]
["Gross Profit = Gross Profit per Unit * Number of Units Sold ",null,null,""]
["Revenue = Price * Number of Units Sold",null,null,""]
["COGS = Cost * Number of Units Sold",null,null,""]
["Gross Profit = Revenue - COGS",null,null,"","Check ü"]

{"sheet":"Retail (an)","index":6,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Some of the terms used in Retail:"]
["Retail Store = Store that sells items to final customer, like Target or Safeway"]
["Retail Price = List Price = Price = Amount collected from customer"]
["Wholesale Cost = Net Cost = Cost = Amount business paid to get the item"]
["Number of Units Sold = Count of number of products sold to customer "]
["Gross Profit per Unit = Price - Cost"]
["Revenue = Price * Number of Units Sold"]
["Cost of Good Sold = COGS = Cost * Number of Units Sold"]
["Gross Profit = Revenue - COGS or Gross Profit per Unit * Number of Units Sold"]
[]
["Example:"]
["Quad Price =",32]
["Quad Cost = ",17.75]
["Number Units Sold =",5]
[]
["Gross Profit per Unit = Price - Cost",{"$f":"B12-B13","v":14.25},null,{"$f":"IF(_xlfn.ISFORMULA(B16),_xlfn.FORMULATEXT(B16),\"\")","v":"=B12-B13"}]
["Gross Profit = Gross Profit per Unit * Number of Units Sold ",{"$f":"B16*B14","v":71.25},null,"=B16*B14"]
["Revenue = Price * Number of Units Sold",{"$f":"B12*B14","v":160},null,"=B12*B14"]
["COGS = Cost * Number of Units Sold",{"$f":"B13*B14","v":88.75},null,"=B13*B14"]
["Gross Profit = Revenue - COGS",{"$f":"B18-B19","v":71.25},null,"=B18-B19","Check ü"]

{"sheet":"W(2)","index":7,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["If you sell 5 Quad boomerangs for $32.00 each and the cost for each was $17.75 and you sell 2",null,null,null,null,null,null,null,null,null,"Carlota"]
["Carlota boomerangs for $22 each and the cost for each was $13, what was the Total Gross Profit that you made?"]
["The companies prices never include decimals past the penny position."]
[]
["1) List all relevant facts and numbers with proper labels",null,null,null,"2) State the goal of the problem"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Quad:"]
[]
[]
[]
[]
["3) Solve problem using Efficient Excel Methods",null,null,null,"4) Check answer"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["5) Answer the question with a written statement"]

{"sheet":"W(2an)","index":8,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["If you sell 5 Quad boomerangs for $32.00 each and the cost for each was $17.75 and you sell 2",null,null,null,null,null,null,null,null,null,"Carlota:"]
["Carlota boomerangs for $22 each and the cost for each was $13, what was the Total Gross Profit that you made?"]
["The companies prices never include decimals past the penny position."]
[]
["1) List all relevant facts and numbers with proper labels",null,null,null,"2) State the goal of the problem"]
[]
["# Quad Boomerangs Sold",5,null,null,"Goal: Calculate Total Gross Profit"]
["Price for one Quad",32]
["Cost of Quad",17.75]
["# Carlota Boomerangs Sold",2,null,null,null,null,null,null,null,null,"Quad:"]
["Price for one Carlota",22]
["Cost of Carlota",13]
["Note: The companies prices never include decimals past the penny position. This means I do not have to round if I am multiplying whole units times dollars and cents."]
[]
["3) Solve problem using Efficient Excel Methods",null,null,null,"4) Check answer"]
[]
["Total Revenue for Quad",{"$f":"B8*B9","v":160},null,{"$f":"IF(_xlfn.ISFORMULA(B18),_xlfn.FORMULATEXT(B18),\"\")","v":"=B8*B9"},"Gross Profit for One Quad",{"$f":"B9-B10","v":14.25},null,{"$f":"IF(_xlfn.ISFORMULA(F18),_xlfn.FORMULATEXT(F18),\"\")","v":"=B9-B10"}]
["Total Revenue for Carlota",{"$f":"B11*B12","v":44},null,"=B11*B12","Gross Profit for One Carlota",{"$f":"B12-B13","v":9},null,"=B12-B13"]
["Total Revenue",{"$f":"SUM(B18:B19)","v":204},null,"=SUM(B18:B19)","Total Gross Profit",{"$f":"SUM(F18*B8,F19*B11)","v":89.25},null,"=SUM(F18*B8,F19*B11)"]
["Total COGS for Quad",{"$f":"B8*B10","v":88.75},null,"=B8*B10",null,null,null,""]
["Total COGS for Carlota",{"$f":"B11*B13","v":26},null,"=B11*B13",null,"Check ü",null,""]
["Total COGS",{"$f":"SUM(B21:B22)","v":114.75},null,"=SUM(B21:B22)",null,null,null,""]
["Total Gross Profit",{"$f":"B20-B23","v":89.25},null,"=B20-B23",null,null,null,""]
[null,null,null,null,null,null,null,""]
["5) Answer the question with a written statement"]
[]
["The Total Gross Profit was $89.25."]

{"sheet":"W(3)","index":9,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["A federal law requires that all residential toilets sold is the USA use no more than 1.5 gallons of water per flush."]
["Prior to this legislation, conventional toilets used 3.2 gallons of water per flush."]
["Find the amount of water saved in one year by a family flushing the toilet 20 times each day (1 year = 365 days)."]
[]
["1) List all relevant facts and numbers with proper labels",null,null,null,"2) State the goal of the problem"]
[]
[]
[]
[]
[]
[]
[]
[]
["3) Solve problem using Efficient Excel Methods",null,null,null,"4) Check answer"]
[]
[]
[]
[]
[]
[]
["5) Answer the question with a written statement"]

{"sheet":"W(3an)","index":10,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["A federal law requires that all residential toilets sold is the USA use no more than 1.5 gallons of water per flush."]
["Prior to this legislation, conventional toilets used 3.2 gallons of water per flush."]
["Find the amount of water saved in one year by a family flushing the toilet 20 times each day (1 year = 365 days)."]
[]
["1) List all relevant facts and numbers with proper labels",null,null,null,"2) State the goal of the problem"]
[]
["Required gallons per flush for residential toilets",1.5,"gallons",null,"Goal: Calculate the amount of water saved in one year by family flushing 20 times per day"]
["Conventional toilet gallons per flush",3.2,"gallons"]
["Number of flushes per day",20]
["Number days in year",365]
[]
[]
[]
["3) Solve problem using Efficient Excel Methods",null,null,null,"4) Check answer"]
[]
["Number gallons saved with new residential toilets for 1 flush",{"$f":"B9-B8","v":1.7000000000000002},"gallons",{"$f":"IF(_xlfn.ISFORMULA(B17),_xlfn.FORMULATEXT(B17),\"\")","v":"=B9-B8"},"Amount of water saved in one year",{"$f":"(B9-B8)*B10*B11","v":12410},"gallons",{"$f":"IF(_xlfn.ISFORMULA(F17),_xlfn.FORMULATEXT(F17),\"\")","v":"=(B9-B8)*B10*B11"}]
["Total Flushes in one year",{"$f":"B11*B10","v":7300},null,"=B11*B10",null,null,null,""]
["Amount of water saved in one year",{"$f":"B18*B17","v":12410.000000000002},"gallons","=B18*B17"]
[null,null,null,null,null,"Check ü"]
[null,null,null,null,null,null,null,""]
["5) Answer the question with a written statement"]
[]
["If a family flushes 20 time a day and switches from a conventional toilet to the new residential toilet they can expect to save about 12,410 gallons of water in one year."]

{"sheet":"W(4)","index":11,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["Timmy Pham drives a truck for Mad Dog Trucking. On a recent long haul, he drove 423 miles in 6.5 hours without a stop."]
["What was the average miles per hour that Timmy drove?"]
["Round to the nearest mile per hour"]
[]
["1) List all relevant facts and numbers with proper labels",null,null,null,"2) State the goal of the problem"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3) Solve problem using Efficient Excel Methods",null,null,null,"4) Check answer"]
[]
[]
[]
[]
[]
[]
["5) Answer the question with a written statement"]

{"sheet":"W(4an)","index":12,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["Timmy Pham drives a truck for Mad Dog Trucking. On a recent long haul, he drove 423 miles in 6.5 hours without a stop."]
["What was the average miles per hour that Timmy drove?"]
["Round to the nearest mile per hour"]
[]
["1) List all relevant facts and numbers with proper labels",null,null,null,"2) State the goal of the problem"]
[]
["Total Miles driven",423,"Miles",null,"Goal: Calculate average miles per hour that Timmy drove"]
["Hours driven",6.5,"Hours"]
["Miles per hours = miles / hour"]
[]
[]
["Note: Anytime we do division with different units in Numerator and Denominator we can leave units in both Numerator and Denominator"]
["and leave a one (1) in the Denominator to help us decipher what the meaning of the ratio is."]
[]
["3) Solve problem using Efficient Excel Methods",null,null,null,"4) Check answer"]
[]
["miles per hour = miles/hour = 423 miles/6.5 hours",{"$f":"B8/B9","v":65.07692307692308},"Miles / Hour",{"$f":"IF(_xlfn.ISFORMULA(B18),_xlfn.FORMULATEXT(B18),\"\")","v":"=B8/B9"},"Check answer with unrounded numbers",{"$f":"B18*B9","v":423},"Check ü",{"$f":"IF(_xlfn.ISFORMULA(F18),_xlfn.FORMULATEXT(F18),\"\")","v":"=B18*B9"}]
["65 Miles / 1 Hour",{"$f":"ROUND(B18,0)","v":65},"Miles / Hour","=ROUND(B18,0)","Check answer with rounded number",{"$f":"B19*B9","v":422.5},"Incorrect","=B19*B9"]
[null,null,null,""]
[]
[null,null,null,null,null,null,null,""]
["5) Answer the question with a written statement"]
[]
["Average miles per hour that Timmy drove was 65 miles per hour"]

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

{"sheet":"HW(1)","index":14,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["On a normal weekday, the vending machines at Juniper College dispense 900 sodas, 400 candy bars, 500 snack items and 200 cups of coffee."]
["If it takes Sioux Chin four hours to restock the vending machines, how many items does he restock per hour?"]

{"sheet":"HW(1an)","index":15,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["On a normal weekday, the vending machines at Juniper College dispense 900 sodas, 400 candy bars, 500 snack items and 200 cups of coffee."]
["If it takes Sioux Chin four hours to restock the vending machines, how many items does he restock per hour?"]
[]
[]
["1) List all relevant facts and numbers with proper labels",null,null,null,"2) State the goal of the problem"]
[]
["# of Sodas",900,null,null,"Goal: Find how many items Sioux can re-stock in 1 hour"]
["# candy bars",400]
["# of Snack items",500]
["# Cups of coffee",200]
["There are more than one vending machine"]
["Time to restock all machines",4,"hours"]
["Hours considered",1]
[]
["3) Solve problem using Efficient Excel Methods",null,null,null,"4) Check answer"]
[]
["Total items",{"$f":"SUM(B8:B11)","v":2000},null,{"$f":"IF(_xlfn.ISFORMULA(B18),_xlfn.FORMULATEXT(B18),\"\")","v":"=SUM(B8:B11)"},"# of Items per hour",{"$f":"SUM(B8:B11)/B13","v":500},null,{"$f":"IF(_xlfn.ISFORMULA(F18),_xlfn.FORMULATEXT(F18),\"\")","v":"=SUM(B8:B11)/B13"}]
["# of Items per hour",{"$f":"B18/B13","v":500},null,"=B18/B13",null,null,null,""]
[null,null,null,""]
[null,null,null,null,null,"Check ü"]
[null,null,null,null,null,null,null,""]
["5) Answer the question with a written statement"]
[]
["Sioux can restock 500 items per hour."]

{"sheet":"HW(2)","index":16,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["The federal Highway Administration estimates that total miles driven fell from 3020 billion miles last year to 2920 billion miles this year. "]
["Find the reduction in miles driven."]

{"sheet":"HW(2an)","index":17,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["The federal Highway Administration estimates that total miles driven fell from 3020 billion miles last year to 2920 billion miles this year. "]
["Find the reduction in miles driven."]
[]
[]
["1) List all relevant facts and numbers with proper labels",null,null,null,"2) State the goal of the problem"]
[]
["# miles driven last year",3020,"billion",null,"Goal: Find reduction in miles driven"]
["# Miles driven this year",2920,"billion"]
[]
[]
["3) Solve problem using Efficient Excel Methods",null,null,null,"4) Check answer"]
[]
["Reduction in miles driven this year as compared to last year",{"$f":"B9-B8","v":-100},"billion miles",{"$f":"IF(_xlfn.ISFORMULA(B14),_xlfn.FORMULATEXT(B14),\"\")","v":"=B9-B8"},"Add reduction to # miles this year",{"$f":"-B14+B9","v":3020},null,{"$f":"IF(_xlfn.ISFORMULA(F14),_xlfn.FORMULATEXT(F14),\"\")","v":"=-B14+B9"}]
[null,null,null,""]
[null,null,null,null,null,"Check ü"]
[null,null,null,null,null,null,null,""]
["5) Answer the question with a written statement"]
[]
["Reduction in miles driven this year as compared to last year was 100 billion miles"]

{"sheet":"HW(3)","index":18,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["According to the Department of Veterans Affairs, U.S. World War II veterans are dying at a rate of 607 per day."]
["How many World War II veterans are projected to die in the next 365 days (one year)?"]

{"sheet":"HW(3an)","index":19,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["According to the Department of Veterans Affairs, U.S. World War II veterans are dying at a rate of 607 per day."]
["How many World War II veterans are projected to die in the next 365 days (one year)?"]
[]
[]
["1) List all relevant facts and numbers with proper labels",null,null,null,"2) State the goal of the problem"]
[]
["WW II veterans deaths per day",607,null,null,"Goal: Project how many WW II veterans will die in next year"]
["Days in year",365]
[]
["3) Solve problem using Efficient Excel Methods",null,null,null,"4) Check answer"]
[]
["Projected deaths next year",{"$f":"B8*B9","v":221555},null,{"$f":"IF(_xlfn.ISFORMULA(B13),_xlfn.FORMULATEXT(B13),\"\")","v":"=B8*B9"},"Total Projected # of deaths/# deaths per day =  # of days",{"$f":"B13/B8","v":365},null,{"$f":"IF(_xlfn.ISFORMULA(F13),_xlfn.FORMULATEXT(F13),\"\")","v":"=B13/B8"}]
[null,null,null,""]
[null,null,null,null,null,"Check ü"]
[null,null,null,null,null,null,null,{"$f":"IF(_xlfn.ISFORMULA(F16),_xlfn.FORMULATEXT(F16),\"\")","v":""}]
["5) Answer the question with a written statement"]
[]
["The projected number of WW II veterans that will die in the next year is 221,555"]

{"sheet":"HW(4)","index":20,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["A fishing boat weighs 8,375 pounds. If its 762-pound engine is removed and replaced with a 976-pound engine,"]
["what is the new weight of the boat after the engine change?"]

{"sheet":"HW(4an)","index":21,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["A fishing boat weighs 8,375 pounds. If its 762-pound engine is removed and replaced with a 976-pound engine,"]
["what is the new weight of the boat after the engine change?"]
[]
[]
["1) List all relevant facts and numbers with proper labels",null,null,null,"2) State the goal of the problem"]
[]
["Boat weight",8375,"lbs.",null,"Goal: Calculate new weight of the boat after the engine change"]
["Engine removed weight",762,"lbs."]
["New Engine weight",976,"lbs."]
[]
["3) Solve problem using Efficient Excel Methods",null,null,null,"4) Check answer"]
[]
["Boat weight after engine change",{"$f":"B8-B9+B10","v":8589},null,{"$f":"IF(_xlfn.ISFORMULA(B14),_xlfn.FORMULATEXT(B14),\"\")","v":"=B8-B9+B10"},"New Weight - new engine + old engine",{"$f":"B14-B10+B9","v":8375},null,{"$f":"IF(_xlfn.ISFORMULA(F14),_xlfn.FORMULATEXT(F14),\"\")","v":"=B14-B10+B9"}]
[null,null,null,"",null,null,null,""]
[null,null,null,""]
[null,null,null,null,null,"Check ü"]
[null,null,null,null,null,null,null,""]
["5) Answer the question with a written statement"]
[]
["The new weight of the boat after the engine change is 8,589 lbs."]

{"sheet":"HW(5)","index":22,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["At one Safeway the price of T-bone steak is $6.71 per pound, while at QFC the price of chicken was $1.39 per pound."]
["How much more per pound is the price of T-bone streak than chicken?"]

{"sheet":"HW(5an)","index":23,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["At one Safeway the price of T-bone steak is $6.71 per pound, while at QFC the price of chicken was $1.39 per pound."]
["How much more per pound is the price of T-bone streak than chicken?"]
[]
[]
["1) List all relevant facts and numbers with proper labels",null,null,null,"2) State the goal of the problem"]
[]
["price of T-bone steak per pound",6.71,null,null,"Goal: Find how much more per pound the price of T-bone streak is than Chicken"]
["price of chicken steak per pound",1.39]
[]
["3) Solve problem using Efficient Excel Methods",null,null,null,"4) Check answer"]
[]
["Difference between price per pound of T-Bone than chicken",{"$f":"B8-B9","v":5.32},null,{"$f":"IF(_xlfn.ISFORMULA(B13),_xlfn.FORMULATEXT(B13),\"\")","v":"=B8-B9"},"Difference + Price 1 pound chicken",{"$f":"B13+B9","v":6.71},null,{"$f":"IF(_xlfn.ISFORMULA(F13),_xlfn.FORMULATEXT(F13),\"\")","v":"=B13+B9"}]
[null,null,null,""]
[null,null,null,null,null,"Check ü"]
["5) Answer the question with a written statement"]
[]
["T-bone is $5.32 more per pound than is turkey."]

{"sheet":"HW(6)","index":24,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["To reduce his driving costs as a salesperson, Iesha Smith bought a Toyota Prius. "]
["In her first week she drive 519 miles in and around the city and used 10.2 gallons of gas. "]
["Find the miles per gallon to the nearest tenth."]

{"sheet":"HW(6an)","index":25,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["To reduce his driving costs as a salesperson, Iesha Smith bought a Toyota Prius. "]
["In her first week she drive 519 miles in and around the city and used 10.2 gallons of gas. "]
["Find the miles per gallon to the nearest tenth."]
[]
["1) List all relevant facts and numbers with proper labels",null,null,null,"2) State the goal of the problem"]
[]
["Miles in 1 week",519,"miles",null,"Goal: Find miles per gallon to the nearest tenth"]
["Gas used",10.199999999999999,"gallon of gas"]
["Note: miles per gallon = Miles per one gallon = miles/gallon "]
[]
[]
["3) Solve problem using Efficient Excel Methods",null,null,null,"4) Check answer"]
[]
["Divide Miles/Gallons to get: miles per 1 gallon",{"$f":"B8/B9","v":50.882352941176471},"miles/gallon",{"$f":"IF(_xlfn.ISFORMULA(B15),_xlfn.FORMULATEXT(B15),\"\")","v":"=B8/B9"},"Check answer with unrounded numbers",{"$f":"B15*B9","v":519},"Check ü",{"$f":"IF(_xlfn.ISFORMULA(F15),_xlfn.FORMULATEXT(F15),\"\")","v":"=B15*B9"}]
["Round to the tenth (1)",{"$f":"ROUND(B15,1)","v":50.9},"miles/gallon","=ROUND(B15,1)","Check answer with rounded number",{"$f":"B16*B9","v":519.17999999999995},"Incorrect","=B16*B9"]
[null,null,null,""]
[]
[null,null,null,null,null,null,null,""]
["5) Answer the question with a written statement"]
[]
["The auto got 50.9 miles per gallon"]

{"sheet":"HW(7)","index":26,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["Each dose of a medication contains 1.62 milligrams of a certain ingredient."]
["Find the number of doses that can be made from 57.13 milligrams of that certain ingredient."]

{"sheet":"HW(7an)","index":27,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Use the Five Steps to Solve Math Word Problems for this problem."]
["Each dose of a medication contains 1.62 milligrams of a certain ingredient."]
["Find the number of doses that can be made from 57.13 milligrams of that certain ingredient."]
[]
[]
["1) List all relevant facts and numbers with proper labels",null,null,null,"2) State the goal of the problem"]
[]
["Amount of certain ingredient for one dose of medication",1.62,"milligrams",null,"Goal: Find the total number of doses of medication that can be made"]
["Total amount of certain ingredient",57.13,"milligrams"]
["Note:"]
["Because it asks for \"Number of doses\", we know that we are counting, 1, 2, 3, 4 and so on."]
["When we make our calculation, we must use just the integer part of the quotient"]
[]
["3) Solve problem using Efficient Excel Methods",null,null,null,"4) Check answer"]
[]
["Number of doses = Total amount of ingredient / Amount of ingredient for 1 dose",{"$f":"B9/B8","v":35.26543209876543},null,{"$f":"IF(_xlfn.ISFORMULA(B16),_xlfn.FORMULATEXT(B16),\"\")","v":"=B9/B8"},"Check answer with unrounded numbers",{"$f":"B16*B8","v":57.13},"Check ü",{"$f":"IF(_xlfn.ISFORMULA(F16),_xlfn.FORMULATEXT(F16),\"\")","v":"=B16*B8"}]
["We must use just the integer part of the quotient",{"$f":"QUOTIENT(B9,B8)","v":35},null,"=QUOTIENT(B9,B8)","Check answer with rounded number",{"$f":"B17*B8","v":56.7},"Incorrect","=B17*B8"]
[null,null,null,null,null,null,null,""]
["5) Answer the question with a written statement"]
[]
["The total number of doses of medication that can be made is 35"]