{"text_format":"1","workbook":"xlsx","n_sheets":30,"sheets":["Topics","Rules","Entering Percents","Entering Percents (an)","Conversions","Conversions (an)","Rounding %","Rounding % (an)","P=BR","P=BR (an)","Part","Part (an)","Base","Base (an)","Rate","Rate (an)","RateOfChange","RateOfChange (an)","ROC","ROC (an)","IncreaseDecrease","IncreaseDecrease (an)","Stocks","Stocks (an)","HW ==>>","3(1)","3(2)","3(3)","3(4)","3(5)"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":1,"comments":3,"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":"Topics","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Textbook","Chapter 3 Topics:"]
["Section 2.1","What Is A Percent"]
["Section 2.1","Ways To Enter Percents In Excel"]
["Section 2.1","Rules For Percents"]
["Section 2.1","Conversions: Write A Decimal As A Percent"]
["Section 2.1","Conversions: Write A Percent As A Decimal"]
["Section 2.1","Conversions: Write A Fraction As A Percent"]
["Section 2.1","Conversions: Write A Percent As A Fraction"]
["Section 2.1","Conversions: Write A Fractional Percent As A Number"]
["Section 2.2","Part = Base * Rate"]
["Section 2.3","Base = Part/Rate"]
["Section 2.4","Rate = Part/Base"]

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

{"sheet":"Entering Percents","index":2,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["What is percent, Really?"]
["Parts",2]
["Whole / Total / Base",100]
[{"$f":"B2&\" out of \"&B3&CHAR(10)&\" = \"&B2&\"/\"&B3","v":"2 out of 100\n = 2/100"},null,"or"]
[]
["Convert Decimal To Percent \"By Hand\" Rules:"]
["Step 1:","Multiply Decimal by 100 (or slide decimal 2 places to right)"]
["Step 2:","Add a % symbol"]
[]
["Step 0:","0.02"]
["Step 1:",".02*100 = 2",null,"<<== As soon as we do this step in the by"]
["Step 2:","2%",null,"hand, we lose the original number: 2 does not"]
[null,null,null,"equal 0.02"]
["In Excel, we just type the decimal (number) in the cell and use the Percent Number Format"]
["Try it:",null,null,null,"General:","Ctrl + Shift = ~"]
[null,null,null,null,null,"Ctrl + Shift = `"]
["0.02 will display as 2.00%, but the 0.02 is still in the cell"]
["Be careful of this:",null,null,"Invoice","Tax1","Tax2"]
["Try it:"]
[]
["2 will display as 200.00%: Not What You Want"]
[]
["Formula evaluate this formula to see that Excel sees decimal underneath formatting, not the percent formatted representation",null,{"$f":"(100+300)*2%","v":8}]
[]
["Situation 1:","Type .02 in cell, then add % format"]
["Situation 2:","Type 2 in cell, then add % format"]
["Situation 3:","Add % format, then type 2, Enter"]
["Situation 4:","Add % format, then type .02, Enter"]
["Situation 5:","Add % format as you type"]
["Situation 6:","Type .025, then add % from ribbon"]
[]
[null,null,100]

{"sheet":"Entering Percents (an)","index":3,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["What is percent, Really?"]
["Parts",2]
["Whole / Total / Base",100]
[{"$f":"B2&\" out of \"&B3&CHAR(10)&\" = \"&B2&\"/\"&B3","v":"2 out of 100\n = 2/100"},{"$f":"B2/B3","v":0.02},"or",{"$f":"B2/B3","v":0.02}]
[]
["Convert Decimal To Percent \"By Hand\" Rules:"]
["Step 1:","Multiply Decimal by 100 (or slide decimal 2 places to right)"]
["Step 2:","Add a % symbol"]
[]
["Step 0:","0.02",0.02]
["Step 1:",".02*100 = 2",{"$f":"C10*100","v":2},"<<== As soon as we do this step in the by"]
["Step 2:","2%","2%","hand, we lose the original number: 2 does not"]
[null,null,null,"equal 0.02"]
["In Excel, we just type the decimal (number) in the cell and use the Percent Number Format"]
["Try it:",null,null,null,"General:","Ctrl + Shift = ~"]
[0.02,null,0.02,null,null,"Ctrl + Shift = `"]
["0.02 will display as 2.00%, but the 0.02 is still in the cell"]
["Be careful of this:",null,null,"Invoice","Tax1","Tax2"]
["Try it:",null,null,200,{"$f":"D19*A16","v":4},{"$f":"D19*A20","v":400}]
[2,null,2]
["2 will display as 200.00%: Not What You Want"]
[]
["Formula evaluate this formula to see that Excel sees decimal underneath formatting, not the percent formatted representation",null,{"$f":"(100+300)*2%","v":8}]
[]
["Situation 1:","Type .02 in cell, then add % format",0.02]
["Situation 2:","Type 2 in cell, then add % format",2]
["Situation 3:","Add % format, then type 2, Enter",0.02]
["Situation 4:","Add % format, then type .02, Enter",0.02]
["Situation 5:","Add % format as you type",2.5000000000000001E-2]
["Situation 6:","Type .025, then add % from ribbon",2.5000000000000001E-2]
[]
[null,null,100]
[null,null,{"$f":"C32*C30","v":2.5}]

{"sheet":"Conversions","index":4,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Go From Decimal To Percent:"]
["Decimal","Formatted Symbolic Representation of Decimal Number"]
[0.06]
[5.0000000000000001E-3]
[6.2E-2]
[]
["Go From Percent To Decimal:"]
["Decimal","Formatted Symbolic Representation of Decimal Number",null,"General N. F."]
[null,7.4999999999999997E-3,null,"Ctrl + Shift + ~"]
[null,0.25]
[]
["Go From Fraction To Percent:"]
["Percent","Fraction"]
[null,{"$f":"1/2","v":0.5}]
[null,{"$f":"1/3","v":0.33333333333333331}]
[]
["Go From Mixed Number To Percent: 2 1/2 ==> 250.00%"]
["Percent","Mixed Number"]
[null,{"$f":"2+1/2","v":2.5}]
[]
["Go From Percent To Fraction:"]
["Percent","Fraction"]
[null,0.12]
[]
["Go From Fractional Percent To a Fraction:"]
["Fraction","Fractional %"]
[null,7.4999999999999997E-3]
[]
["End of Section 3.1"]

{"sheet":"Conversions (an)","index":5,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Go From Decimal To Percent:"]
["Decimal","Formatted Symbolic Representation of Decimal Number"]
[0.06,0.06,null,null,null,null,10000]
[5.0000000000000001E-3,5.0000000000000001E-3]
[6.2E-2,6.2E-2]
[]
["Go From Percent To Decimal:"]
["Decimal","Formatted Symbolic Representation of Decimal Number",null,"General N. F."]
[7.4999999999999997E-3,7.4999999999999997E-3,null,"Ctrl + Shift + ~"]
[0.25,0.25]
[]
["Go From Fraction To Percent:"]
["Percent","Fraction"]
[{"$f":"1/2","v":0.5},{"$f":"1/2","v":0.5}]
[{"$f":"1/3","v":0.33333333333333331},{"$f":"1/3","v":0.33333333333333331}]
[{"$f":"1/3","v":0.33333333333333331}]
["Go From Mixed Number To Percent: 2 1/2 ==> 250.00%"]
["Percent","Mixed Number"]
[{"$f":"2+1/2","v":2.5},{"$f":"2+1/2","v":2.5}]
[]
["Go From Percent To Fraction:"]
["Percent","Fraction"]
[0.12,0.12]
[]
["Go From Fractional Percent To a Decimal:"]
["Percent","Fraction"]
[{"$f":"3/400","v":7.4999999999999997E-3},7.4999999999999997E-3]
[]
["End of Section 3.1"]

{"sheet":"Rounding %","index":6,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Decimal","convert","%"]
[1.2500000000000001E-2," ==>>",null,null," <<== If someone says, \"round percentage to the nearest tenth\" or"]
[null,null,null,null,"\"round to the nearest tenth of a percent\""]
[]
["You look at the percent:"]
[null,null," <<== The 2 is in the tenth position"]
[]
["so this becomes:"]
[]
[]
[]
["But if you use the ROUND function, and formulas don't look at"]
["formatting, you must consider the underlying number:"]
[]
[null,null," <<== The 2 is in the thousandths position in the underlying number 0.0125"]
[]
[]
["Instructions: Round to the nearest percent"]
[null,null,"<<== %"]
[null,null,"<< == Decimal"]
[null,null," <<== use ROUND"]
[]
["Instructions: Round to the hundredth of a percent"]
[null,null,"<<== %"]
[null,null,"<< == Decimal"]
[null,null," <<== use ROUND"]

{"sheet":"Rounding % (an)","index":7,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Decimal","convert","%"]
[1.2500000000000001E-2," ==>>",{"$f":"A2","v":1.2500000000000001E-2},null," <<== If someone says, \"round percentage to the nearest tenth\" or"]
[null,null,null,null,"\"round to the nearest tenth of a percent\""]
[]
["You look at the percent:"]
[1.2500000000000001E-2,null," <<== The 2 is in the tenth position"]
[]
["so this becomes:"]
[]
[1.2999999999999999E-2]
[]
["But if you use the ROUND function, and formulas don't look at"]
["formatting, you must consider the underlying number:"]
[]
[1.2500000000000001E-2,{"$f":"A15","v":1.2500000000000001E-2}," <<== The 2 is in the thousandths position in the underlying number 0.0125"]
[{"$f":"ROUND(A15,3)","v":1.2999999999999999E-2}]
[]
["Instructions: Round to the nearest percent"]
[5.5E-2,null,"<<== %"]
[{"$f":"A19","v":5.5E-2},null,"<< == Decimal"]
[{"$f":"ROUND(A19,2)","v":0.06},null," <<== use ROUND"]
[]
["Instructions: Round to the hundredth of a percent"]
[1.455E-2,1.46E-2,"<<== %"]
[{"$f":"A24","v":1.455E-2},null,"<< == Decimal"]
[{"$f":"ROUND(A24,4)","v":1.46E-2},null," <<== use ROUND"]

{"sheet":"P=BR","index":8,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["If your total earnings were $750 and the tax rate was 12%, what is the tax paid?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["If last year’s sales were $500,000 and this year’s sales were 110% of last year’s sales, how much are this year’s sales?"]

{"sheet":"P=BR (an)","index":9,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["If your total earnings were $750 and the tax rate was 12%, what is the tax paid?"]
["Step 1:"]
["Total Earnings",750,"Base"]
["Tax Rate",0.12,"Rate"]
["Tax Paid","??","Part"]
["Goal: Calculate Tax Paid"]
[]
["Step 2:"]
[{"$f":"A3","v":"Total Earnings"},{"$f":"B3","v":750},null,"Base * Rate = Part"]
[{"$f":"A4","v":"Tax Rate"},{"$f":"B4","v":0.12}]
["Tax Paid",{"$f":"B9*B10","v":90}]
[]
["Step 3:"]
["If our earnings were $750 and the tax rate was 12%, our tax paid was $90."]
[]
[]
[]
[]
[]
[]
["If last year’s sales were $500,000 and this year’s sales were 110% of last year’s sales, how much are this year’s sales?"]
["Step 1:"]
["Last Year's Sales",500000,"Base","Starting Point"]
["This year's sales as a % of last year's sales",1.1000000000000001,"Rate","%*Last Year's Sales = This years Sales"]
["This Year's Sales","???","Part"]
["Goal: Calculate This Year's Sales"]
[]
["Step 2:"]
[{"$f":"A23","v":"Last Year's Sales"},{"$f":"B23","v":500000},{"$f":"C23","v":"Base"}]
[{"$f":"A24","v":"This year's sales as a % of last year's sales"},{"$f":"B24","v":1.1000000000000001},"Rate"]
[{"$f":"A25","v":"This Year's Sales"},{"$f":"B30*B29","v":550000},"Part"]
[]
["Step 3:"]
["If last year's sales were $500,000 and this year's sales were 110% of last year's sales, then this years sales are $550,000."]

{"sheet":"Part","index":10,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["The Pop Advertising Institute says that 55% of all supermarket shoppers have a written list of their needs. If there are 3,680 shoppers entering the supermarket that you manage in one day, what number of shoppers would you expect to have a written shopping list?"]

{"sheet":"Part (an)","index":11,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["The Pop Advertising Institute says that 55% of all supermarket shoppers have a written list of their needs. If there are 3,680 shoppers entering the supermarket that you manage in one day, what number of shoppers would you expect to have a written shopping list?"]
["Step 1:"]
["% of Shoppers who have a list",0.55000000000000004,"Rate"]
["All Shoppers In One Day",3360,"Base"]
["# Shoppers you expect to have list","???","Part"]
["Goal: Calculate # Shoppers you expect to have list"]
[]
["Step 2:",null,null,"Check:"]
[{"$f":"A3","v":"% of Shoppers who have a list"},{"$f":"B3","v":0.55000000000000004},{"$f":"C3","v":"Rate"},"Rate 2",{"$f":"1-B9","v":0.44999999999999996}]
[{"$f":"A4","v":"All Shoppers In One Day"},{"$f":"B4","v":3360},{"$f":"C4","v":"Base"},"Part 2",{"$f":"B10*E9","v":1511.9999999999998}]
["# Shoppers you expect to have list",{"$f":"B10*B9","v":1848.0000000000002},"Part","Total",{"$f":"E10+B11","v":3360}]
[]
["Step 3:"]
["If we assume that 55% of shoppers have a list, then if we have 3,680 shoppers in our store in one day, we would estimate that 1,848 of them had a shopping list."]
[]
[]
[]
["End of Section 3.2"]

{"sheet":"Base","index":12,"n_rows":47,"n_cols":1,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["If your payroll deductions (tax) paid was $90 and the tax rate was 12%, what was the gross pay for the paycheck?"]
["Step 1:"]
[]
[]
[]
[]
[]
["Step 2:"]
[]
[]
[]
[]
["Step 3:"]
[]
[]
[]
["18 1/2% of ____?______ circuits is 370 circuits?"]
["Step 1:"]
[]
[]
[]
[]
[]
["Step 2:"]
[]
[]
[]
[]
["Step 3:"]
[]
[]
["Ren Hoke earns a monthly interest rate of 1/2%. If he earned $251 in interest for the month, what was the amount invested for the month?"]
["Step 1:"]
[]
[]
[]
[]
[]
["Step 2:"]
[]
[]
[]
[]
["Step 3:"]
[]
[]
["End of Section 3.3"]

{"sheet":"Base (an)","index":13,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["If your payroll deductions (tax) paid was $90 and the tax rate was 12%, what was the gross pay for the paycheck?"]
["Step 1:"]
["Tax Paid",90,"Part"]
["Tax Rate",0.12,"Rate"]
["Gross Pay","??","Base"]
["Formula: B = P/R"]
["Goal: Solve for Gross Pay (Base)"]
["Step 2:"]
[{"$f":"A3","v":"Tax Paid"},{"$f":"B3","v":90},null,"Check:"]
[{"$f":"A4","v":"Tax Rate"},{"$f":"B4","v":0.12},null,"P = B * R"]
["Gross Pay",{"$f":"B9/B10","v":750},null,{"$f":"B11*B10","v":90}]
[]
["Step 3:"]
["If the tax paid was $90 and the tax rate was 12%, then the Gross Pay would be $750."]
[]
[]
["18 1/2% of ____?______ circuits is 370 circuits?"]
["Step 1:"]
["18 1/2% * (?? Circuits ) = 370 Circuits",null,null,18.5,0.185]
["Rate",0.185]
["Base Circuits","??"]
["Part Circuits",370]
["Formula: B = P/R","Goal: Calculate Base Circuits"]
["Step 2:"]
[{"$f":"A20","v":"Rate"},{"$f":"B20","v":0.185},null,"Check:"]
[{"$f":"A21","v":"Base Circuits"},{"$f":"B27/B25","v":2000},null,"P = B * R"]
["Part Circuits",{"$f":"B22","v":370},null,{"$f":"B25*B26","v":370}]
[]
["Step 3:"]
["The Base Number of Circuits is 2000, given that the part was 370 and the rate was 18 1/2%."]
[]
["Ren Hoke earns a monthly interest rate of 1/2%. If he earned $251 in interest for the month, what was the amount invested for the month?"]
["Step 1:"]
["Monthly Interest Rate",5.0000000000000001E-3,null,"1/2",0.5,5.0000000000000001E-3]
["Monthly Interest Earned",251]
["Amount invested for Month","??"]
["Formula: B = P/R"]
["Goal: Find amount invested for month"]
["Step 2:"]
[{"$f":"A34","v":"Monthly Interest Rate"},{"$f":"B34","v":5.0000000000000001E-3},null,"Check"]
[{"$f":"A35","v":"Monthly Interest Earned"},{"$f":"B35","v":251},null,"P = R * B"]
["Amount invested for Month",{"$f":"B41/B40","v":50200},null,{"$f":"B42*B40","v":251}]
[]
["Step 3:"]
["Ren had $50,200 invested for the month, given that he earned a rate of 1/2% and interest of $251."]
[]
["End of Section 3.3"]

{"sheet":"Rate","index":14,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["If Suix Radcoolinator earned $27.25 in interest for the quarter and she had $1362.50 invested for the quarter, what was the quarterly interest rate?"]
["Step 1:"]
[]
[]
[]
[]
[]
["Step 2:"]
[]
[]
[]
[]
["Step 3:"]
[]
[]
["Barbara's Antiquary says that of its 3800 items in inventory, 3344 are just plain junk, while the rest are antiques. What percent of the total inventory is antiques?"]
["Step 1:"]
[]
[]
[]
[]
[]
["Step 2:"]
[]
[]
[]
[]
["Step 3:"]
[]
[]
["End of Section 3.4"]

{"sheet":"Rate (an)","index":15,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["If Suix Radcoolinator earned $27.25 in interest for the quarter and she had $1362.50 invested for the quarter, what was the quarterly interest rate?"]
["Step 1:"]
["Interest earned for the quarter",27.25,"Part"]
["Amount Invested",1362.5,"Base"]
["Quarterly interest rate","??"]
["Formula: R = P/B"]
["Goal: calculate Quarterly Rate"]
["Step 2:"]
[{"$f":"A3","v":"Interest earned for the quarter"},{"$f":"B3","v":27.25}]
[{"$f":"A4","v":"Amount Invested"},{"$f":"B4","v":1362.5}]
["Quarterly interest rate",{"$f":"B9/B10","v":0.02},{"$f":"B11","v":0.02}]
[]
["Step 3:"]
["Given that we had $1362.50 invested for the quarter and we earned $27.25, the quarterly interest rate was 2%."]
[]
["Barbara's Antiquary says that of its 3800 items in inventory, 3344 are just plain junk, while the rest are antiques. What percent of the total inventory is antiques?"]
["Step 1:"]
["Total # items in inventory",3800,"Base"]
["# Items that are junk",3344,"Part 1"]
["# Items that are antiques","??","Part 2"]
["Percent of Antiques","??","Rate"]
["Goal: Find Percent of antiques",null,"Formula: R = P/B"]
["Step 2:"]
[{"$f":"A18","v":"Total # items in inventory"},{"$f":"B18","v":3800},null,"Check:","Check:","Check:"]
[{"$f":"A19","v":"# Items that are junk"},{"$f":"B19","v":3344},null,"B = P/R","% of Junk","B = P/R"]
["# Items that are antiques",{"$f":"B24-B25","v":456},null,{"$f":"B26/B27","v":3800},{"$f":"1-B27","v":0.88},{"$f":"B25/E26","v":3800}]
["Percent of Antiques",{"$f":"B26/B24","v":0.12},{"$f":"B27","v":0.12}]
["Step 3:"]
["The percent of antiques in the inventory is 12%."]
[]
["End of Section 3.4"]

{"sheet":"RateOfChange","index":16,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["New Formulas"]
["Example 1: Rate of Change / Increase Problem"]
["Stock Value Year 1",10,"Beg"]
["Stock Value Year 2",12.5,"End"]
[]
[]
[]
[]
[]
["New Formulas"]
["Example 2: Rate of Change / Decrease Problem"]
["Stock Value Year 1",10,"Beg"]
["Stock Value Year 2",7.5,"End"]

{"sheet":"RateOfChange (an)","index":17,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["New Formulas"]
["Example 1: Rate of Change / Increase Problem"]
["Stock Value Year 1",10,"Beg"]
["Stock Value Year 2",12.5,"End"]
["Rate = Part/Base = End/Beg =",{"$f":"B4/B3","v":1.25},{"$f":"B5","v":1.25}]
["Part = Rate*Base = End = Rate*Beg =",{"$f":"B5*B3","v":12.5}]
["Amount of Change = AOC = End - Beg =",{"$f":"B4-B3","v":2.5}]
["Rate of Change = End/Beg - 1",{"$f":"B4/B3-1","v":0.25},{"$f":"B8","v":0.25}]
["Rate of Change = Rate - 1",{"$f":"B5-1","v":0.25},{"$f":"B9","v":0.25}]
["New Formulas"]
["Example 2: Rate of Change / Decrease Problem"]
["Stock Value Year 1",10,"Beg"]
["Stock Value Year 2",7.5,"End"]
["Rate = Part/Base = End/Beg =",{"$f":"B13/B12","v":0.75},{"$f":"B14","v":0.75}]
["Part = Rate*Base = End = Rate*Beg =",{"$f":"B14*B12","v":7.5}]
["Amount of Change = AOC = End - Beg =",{"$f":"B13-B12","v":-2.5}]
["Rate of Change = End/Beg - 1",{"$f":"B13/B12-1","v":-0.25},{"$f":"B17","v":-0.25}]
["Rate of Change = Rate - 1",{"$f":"B14-1","v":-0.25},{"$f":"B18","v":-0.25}]

{"sheet":"ROC","index":18,"n_rows":34,"n_cols":1,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["If last years sales were $125,000 and this years sales were $190,000, what is the percentage change from last year to this year?"]
[]
["Step 1: List Variables and details"]
[]
[]
[]
[]
[]
[]
["Step 2: Set up and Solve"]
[]
[]
[]
[]
[]
["Step 3: Write Answer in Words"]
[]
[]
["If last years sales were $125,000 and this years sales were $110,000, what is the percentage change from last year to this year?"]
[]
["Step 1: List Variables and details"]
[]
[]
[]
[]
[]
[]
["Step 2: Set up and Solve"]
[]
[]
[]
[]
[]
["Step 3: Write Answer in Words"]

{"sheet":"ROC (an)","index":19,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["If last years sales were $125,000 and this years sales were $190,000, what is the percentage change from last year to this year?"]
[]
["Step 1: List Variables and details"]
["Last Years Sales",125000,"Beg"]
["This Years Sales",190000,"End"]
["Goal: Find % Rate of Change ==> Rate of Change",null,"ROC"]
["Formual 1: Rate = End/Beg"]
["Formula 2: AOC = End - Beg"]
["Formula 3: ROC = End/Beg - 1"]
["Step 2: Set up and Solve"]
[{"$f":"A7","v":"Formual 1: Rate = End/Beg"},{"$f":"B5/B4","v":1.52},null,"Check:"]
[{"$f":"A8","v":"Formula 2: AOC = End - Beg"},{"$f":"B5-B4","v":65000},null,"Rate -1"]
[{"$f":"A9","v":"Formula 3: ROC = End/Beg - 1"},{"$f":"B5/B4-1","v":0.52},null,{"$f":"B11-1","v":0.52}]
["Check 1: Beg*Rate = End",{"$f":"B11*B4","v":190000}]
["Check 2: AOC = ROC*Beg ",{"$f":"B4*B13","v":65000}]
["Step 3: Write Answer in Words"]
["The percentage change from last year to this year is 52%"]
[]
["If last years sales were $125,000 and this years sales were $110,000, what is the percentage change from last year to this year?"]
[]
["Step 1: List Variables and details"]
["Last Years Sales",125000,"Beg"]
["This Years Sales",110000,"End"]
["Goal: Find % Rate of Change ==> Rate of Change","??","ROC"]
["Formula 1: Rate = End/Beg"]
["Formula 2: AOC = End - Beg"]
["Formula 3: ROC = End/Beg -1"]
["Step 2: Set up and Solve"]
[{"$f":"A25","v":"Formula 1: Rate = End/Beg"},{"$f":"B23/B22","v":0.88}]
[{"$f":"A26","v":"Formula 2: AOC = End - Beg"},{"$f":"B23-B22","v":-15000}]
[{"$f":"A27","v":"Formula 3: ROC = End/Beg -1"},{"$f":"B23/B22-1","v":-0.12},{"$f":"B31","v":-0.12}]
["Check 1: End = Rate*Beg",{"$f":"B29*B22","v":110000}]
["Check 2: AOC = Beg*ROC =",{"$f":"B31*B22","v":-15000}]
["Step 3: Write Answer in Words"]
["The percentage change from last year to this year is -12%."]

{"sheet":"IncreaseDecrease","index":20,"n_rows":77,"n_cols":1,"rows_kept":77,"cut":false,"hidden":true,"merged":[]}
["After spending $3450 for tuition and $4350 for dorm fees, Edgar finds that 35% of his original savings remains. Find the amount of his savings that remain."]
["Step 1: List Variables and details"]
[]
[]
[]
[]
[]
[]
["Step 2: Set up and Solve"]
[]
[]
[]
[]
[]
[]
[]
["Step 3: Write Answer in Words"]
[]
[]
[]
["The value of Iowa farmland increased 4.3% this year to a statewide average value of $1857 per acre. How much per acre did the Iowa farmland increase this year (Round to the dollar)."]
[]
["Step 1: List Variables and details"]
[]
[]
[]
[]
[]
[]
["Step 2: Set up and Solve"]
[]
[]
[]
[]
[]
[]
[]
["Step 3: Write Answer in Words"]
[]
[]
["Markup"]
[]
["The original price of the Lego set was $10.50. If the markdown was 10%, what was the reduced price?"]
[]
["Step 1: List Variables and details"]
[]
[]
[]
[]
[]
["Step 2: Set up and Solve"]
[]
[]
[]
[]
["Step 3: Write Answer in Words"]
[]
[]
[]
["The original price for the generator before the Seattle storm was $600. After the storm a 20% markup was added. What is the new price?"]
[]
["Step 1: List Variables and details"]
[]
[]
[]
[]
[]
["Step 2: Set up and Solve"]
[]
[]
[]
[]
["Step 3: Write Answer in Words"]
[]
[]
[]
["End of Section 3.5"]

{"sheet":"IncreaseDecrease (an)","index":21,"n_rows":77,"n_cols":7,"rows_kept":77,"cut":false,"hidden":true,"merged":[]}
["After spending $3450 for tuition and $4350 for dorm fees, Edgar finds that 35% of his original savings remains. Find the amount of his savings that remain."]
["Step 1: List Variables and details"]
["Tuition",3450]
["Dorm fees",4350]
["Original savings = Beg","???","Base"]
["Amount of savings that remain = End","??","Part"]
["Goal: Find Amount of savings that remain"]
["Rate = % of savings that remain",0.35,"Rate"]
["Step 2: Set up and Solve"]
["ROC = Rate - 1",{"$f":"E14-1","v":-0.65}]
["AOC = Tuition + Dorm Fee",{"$f":"-SUM(B3:B4)","v":-7800},"Beg","AOC",{"$f":"B10","v":-0.65},"ROC"]
["Base = Beg = AOC/ROC",{"$f":"D12/E11","v":12000},{"$f":"B12","v":12000},{"$f":"B11","v":-7800}]
["Part = End = Beg*Rate",{"$f":"C12*E14","v":4200}]
["Check 1: End/Rate = Beg",{"$f":"D15/E14","v":12000},null,"End",{"$f":"B8","v":0.35},"Rate"]
[null,null,null,{"$f":"B13","v":4200}]
[]
["Step 3: Write Answer in Words"]
["Amount of savings that remain is $4,200."]
[]
[]
["The value of Iowa farmland increased 4.3% this year to a statewide average value of $1857 per acre. How much per acre did the Iowa farmland increase this year (Round to the dollar)."]
[]
["Step 1: List Variables and details"]
["ROC = Increase in property value",4.2999999999999997E-2,"ROC"]
["End = Value at end of year",1857,"End"]
["Goal: AOC = Amount land increased",null,"AOC"]
["ROC = Rate -1"]
["ROC + 1 = Rate"]
[]
["Step 2: Set up and Solve"]
[{"$f":"A28","v":"ROC + 1 = Rate"},{"$f":"E32+1","v":1.0429999999999999}]
["Base = Beg = P/R = End/Rate",{"$f":"B25/B31","v":1780.4410354745926},"End",null,{"$f":"B24","v":4.2999999999999997E-2},"ROC","Rate"]
["AOC = End - Beg",{"$f":"ROUND(B25-B32,0)","v":77},{"$f":"B25","v":1857},null,1,null,{"$f":"E33+E32","v":1.0429999999999999}]
["Check 1: End = Beg * Rate",{"$f":"B32*B31","v":1857}]
[]
[]
[]
["Step 3: Write Answer in Words"]
["The land increased by $77 (that is given our 4.3% increase)"]
[]
["Markup"]
[]
["The original price of the Lego set was $10.50. If the markdown was 10%, what was the reduced price?"]
[]
["Step 1: List Variables and details"]
["Beg = Original Price",10.5,null,"Beg = Base"]
["ROC = Markdown",-0.1,{"$f":"B47","v":-0.1},"ROC"]
["Goal: Find reduced Price"]
["Rate = 1 - ROC or 1 + -ROC"]
["End (Part) = Beg * Rate = Base * Rate ="]
["Step 2: Set up and Solve"]
[{"$f":"A49","v":"Rate = 1 - ROC or 1 + -ROC"},{"$f":"1+B47","v":0.9},{"$f":"B52","v":0.9}]
[{"$f":"A50","v":"End (Part) = Beg * Rate = Base * Rate ="},{"$f":"B46*B52","v":9.4500000000000011}]
["check 1: Beg = End/Rate",{"$f":"B53/B52","v":10.500000000000002}]
[]
["Step 3: Write Answer in Words"]
["The reduced Price is $9.45."]
[]
[]
["The original price for the generator before the Seattle storm was $600. After the storm a 20% markup was added. What is the new price?"]
[]
["Step 1: List Variables and details"]
["Beg = Original Price =",600,"Beg"]
["Markup = ROC",0.2,{"$f":"B64","v":0.2}]
["Goal: Find New Price"]
["Formula 1: Rate = 1 + ROC"]
["End = Beg * Rate = Base * Rate"]
["Step 2: Set up and Solve"]
[{"$f":"A66","v":"Formula 1: Rate = 1 + ROC"},{"$f":"1+B64","v":1.2},{"$f":"C64+1","v":1.2}]
[{"$f":"A67","v":"End = Beg * Rate = Base * Rate"},{"$f":"B69*B63","v":720}]
["Check1: Beg = End/Rate = Part/Rate",{"$f":"B70/B69","v":600}]
[]
["Step 3: Write Answer in Words"]
["The Marked Up Price is $720.00."]
[]
[]
["End of Section 3.5"]

{"sheet":"Stocks","index":22,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["My Stocks"]
["Company Name","Stock Symbol","March 1, 2007 Price","Current Price","Rate of Change or % Over Period",null,"Check"]
["Amazom.com","AMZN",38.85]
["Krispy Kreme","KKD",10.25]
["McDonald's","MCD",44.1]
["Merck","MRK",43.99]
["Citigroup","C",51.08]
["Microsoft","MSFT",28.09]
["Bank of America","BAC",50.38]
["Pepsi Bottling","PBG",31.12]
["Wal-Mart","WMT",47.89]
["Yahoo","YHOO",30.86]

{"sheet":"Stocks (an)","index":23,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":true,"merged":[[13,0,13,15],[14,0,14,15],[30,0,30,15],[26,2,26,4],[26,6,26,8],[29,0,29,15],[27,2,27,4],[27,6,27,8]]}
["My Stocks"]
["Company Name","Stock Symbol","March 1, 2007 Price","Current Price","Rate of Change or % Over Period",null,"Check"]
["Amazom.com","AMZN",38.85,{"$f":"D17","v":246.71},{"$f":"D3/C3-1","v":5.3503217503217506},null,{"$f":"(D3-C3)/C3","v":5.3503217503217506}]
["Krispy Kreme","KKD",10.25,{"$f":"D18","v":7.16},-0.30146341463414628,null,{"$f":"(D4-C4)/C4","v":-0.30146341463414633}]
["McDonald's","MCD",44.1,89.94,1.0394557823129249,null,1.0394557823129251]
["Merck","MRK",43.99,32.979999999999997,-0.25028415548988414,null,-0.2502841554898842]
["Citigroup","C",51.08,28.4,-0.44400939702427566,null,-0.44400939702427566]
["Microsoft","MSFT",28.09,27.27,-2.9191883232467131E-2,null,-2.9191883232467082E-2]
["Bank of America","BAC",50.38,6.19,-0.87713378324732039,null,-0.87713378324732039]
["Wal-Mart","WMT",47.89,55.46,0.15807057840885363,null,0.15807057840885363]
["Yahoo","YHOO",30.86,15.91,-0.48444588464031102,null,-0.48444588464031108]
[]
[]
["Stock Quotes Provided by MSN Money"]
["Click here to visit MSN Money"]
[null,null,null,"Last","Previous Close","High","Low","Volume","Change","% Change","52 Wk High","52 Wk Low","Market Cap","EPS","P/E Ratio","# Shares Out"]
["Amazon.com Inc ","Chart","News",246.71,246.71,0,0,39685,"unch",0,246.71,156.57,111990380911,2.27,108.8,453935300]
["Krispy Kreme Doughnuts Inc ","Chart","News",7.16,7.16,0,0,700,"unch",0,10.08,5.0599999999999996,486393324,0.26,27,67932030]
["McDonald's Corp ","Chart","News",89.94,89.94,0,0,5520,"unch",0,91.22,72.14,92795777399,4.95,18.2,1031752000]
["Merck & Co Inc ","Chart","News",32.979999999999997,32.979999999999997,0,0,900,"unch",0,37.68,29.47,101604683650,1.38,23.9,3080797000]
["Citigroup Inc ","Chart","News",28.4,28.4,0,0,3703697,"unch",0,51.5,21.4,82869750487,3.26,8.6,2917949000]
["Microsoft Corp ","Chart","News",27.27,27.27,0,0,16392,"unch",0,29.46,23.65,230136551543,2.7,10.1,8439184000]
["Bank of America Corp ","Chart","News",6.19,6.19,0,0,3031790,"unch",0,15.31,5.13,62796003080,-1.65,0,10144750000]
["Wal-Mart Stores Inc ","Chart","News",55.46,55.46,0,0,900,"unch",0,57.9,48.31,191150484865,4.7,12.5,3446637000]
["Yahoo! Inc ","Chart","News",15.91,15.91,0,0,121735,"unch",0,18.84,11.09,20088156727,0.88,18.100000000000001,1262612000]
[]
["Symbol Lookup",null,"MSN Money Home",null,null,null,"Microsoft Office Tools on the Web"]
["Find stocks, mutual funds, options, indices, and currencies.",null,"Discover MSN Money's tools, columns, and more!",null,null,null,"Get the latest from Microsoft Office"]
[]
["Terms of Use. © 2011 Microsoft Corporation and/or its suppliers. All rights reserved."]

{"sheet":"HW ==>>","index":24,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[3.1,{"$f":"'3(1)'!A1&\", \"&'3(1)'!A2&\", \"&'3(1)'!A3&\", \"&'3(1)'!A4&\", \"&'3(1)'!A7&\", \"&'3(1)'!A8&\", \"&'3(1)'!A9","v":"13, 15, 21, 29, 35, 37, 39"}]
[3.2,{"$f":"'3(2)'!A1&\", \"&'3(2)'!A8&\", \"&'3(2)'!A14&\", \"&'3(2)'!A32","v":"3, 11, 25, 31"}]
[3.3000000000000003,{"$f":"'3(3)'!A1&\", \"&'3(3)'!A15&\", \"&'3(3)'!A41","v":"11, 29, 31"}]
[3.4000000000000004,{"$f":"'3(4)'!A1&\", \"&'3(4)'!A11&\", \"&'3(4)'!A29","v":"13, 22, 25"}]

{"sheet":"3(1)","index":25,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[5,10,6,10],[5,12,6,12],[8,10,9,10],[8,12,9,12]]}
[13,3.45," ==>>",{"$f":"B1","v":3.45}]
[15,3.0800000000000001E-2," ==>>",3.0800000000000001E-2]
[21,{"$f":"1/8","v":0.125}," ==>>",{"$f":"1/8","v":0.125}]
[29,{"$f":"1+3/4","v":1.75}," ==>>",{"$f":"1+3/4","v":1.75}]
[]
[null,"Fraction",null,"Decimal",null,"Percent",null,"check:",null,8," =","2*2*2"," =",1]
[35,{"$f":"1/125","v":8.0000000000000002E-3}," <<==",8.0000000000000002E-3," <<==",8.0000000000000002E-3,null,8.0000000000000002E-3,null,1000,null,"2*5*2*5*2*5",null,125]
[37,{"$f":"10+1/2","v":10.5}," ==>>",{"$f":"10+1/2","v":10.5}," ==>>",10.5]
[39,{"$f":"13/20","v":0.65}," <<==",0.65," ==>>",0.65,null,null,null,65," =","5*13"," =",13,null,"Check:",{"$f":"5*13","v":65}]
[null,null,null,null,null,null,null,null,null,100,null,"2*5*2*5",null,20]

{"sheet":"3(2)","index":26,"n_rows":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[3,"Round to nearest 100th (same as penny position)"]
[null,"75.5% of $800 = ??",null,"Note: you can't type an equal sign in a cell unless you type a space before it or a use a lead apostrophe"]
[null,"translates into:"]
[null,0.755,"*",800," =","??"]
[null,"Rate","*","Base"," =","Part"]
[null,"Part =",{"$f":"ROUND(B4*D4,2)","v":604}]
[]
[11,"118% of 125.8 yards",null,"Note: you can't type an equal sign in a cell unless you type a space before it or a use a lead apostrophe"]
[null,"translates into:"]
[null,1.18,"*",125.8," =","??","Unit = yards"]
[null,"Rate","*","Base"," =","Part"]
[null,"Part =",{"$f":"ROUND(B10*D10,2)","v":148.44},"Yards"]
[]
[25]
["Step 1:"]
["Rate =","% of auto accidents that are caused by Distracted Drivers (DD)",0.29499999999999998]
["Base =","Total # of Drivers in Study",16450]
["Part =","Estimate of # of drivers in study that were in accident because of DD","??"]
["Goal:","Estimate of # of drivers in study that were in accident because of DD"]
["Formula: P = B*R"]
["Requirement: round to nearest whole number"]
["Step 2:",null,null,"Check1:",null,"Check1:"]
[{"$f":"A16","v":"Rate ="},{"$f":"C16","v":0.29499999999999998},null,{"$f":"A23","v":"Rate ="},{"$f":"E25/E24","v":0.29499999999999998},{"$f":"D23","v":"Rate ="},{"$f":"C16","v":0.29499999999999998}]
["Base =",{"$f":"C17","v":16450},null,{"$f":"A24","v":"Base ="},{"$f":"C17","v":16450},"Base =",{"$f":"G25/G23","v":16450}]
["Part =",{"$f":"ROUND(B24*B23,0)","v":4853},null,{"$f":"A25","v":"Part ="},{"$f":"B24*B23","v":4852.75},"Part =",{"$f":"E25","v":4852.75}]
["Step 3:"]
["The estimate for the # of drivers in study that were in accidents because of Distracted Driving is 4,853."]
[]
[]
[]
[]
[31]
["Step 1:"]
["Base =","New products introduced last year",15401]
["Rate","% of products that failed to meet objective",0.86]
["Part 1:","# of products that failed to meet objective","??"]
["Part 2:","# of products that DID NOT fail to meet objective","??"]
["Goal:","calculate # of products that DID NOT fail","Calculate the number of products that did reach their business objectives"]
["Formula 1: P = B*R"]
["Formula 2: 1 - Part 1 % = Part 2 %"]
["Requirement: Round to nearest whole number"]
["Step 2:",null,null,null,null,"Check1:"]
[{"$f":"A34","v":"Base ="},"New products introduced last year",15401]
["Rate","% of products that failed to meet objective",0.86]
["Rate 2","% of products that DID NOT fail to meet objective (meet objectives)",{"$f":"1-C44","v":0.14000000000000001}]
[{"$f":"A36","v":"Part 1:"},{"$f":"B36","v":"# of products that failed to meet objective"},{"$f":"ROUND(C43*C44,0)","v":13245},"Check1:"]
[{"$f":"A37","v":"Part 2:"},{"$f":"B37","v":"# of products that DID NOT fail to meet objective"},{"$f":"ROUND(C43-C46,0)","v":2156},{"$f":"ROUND(C43*C45,0)","v":2156}]
[]
["Step 3:"]
["The number of products that did reach their business objectives was 2156."]

{"sheet":"3(3)","index":27,"n_rows":71,"n_cols":6,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
[11,"Round to nearest 100th (same as penny position)"]
[null,"50 doors is .25% of 20,000 doors"]
[null,"doors is unit"]
[null,2.5000000000000001E-3," ==>",{"$f":"B4","v":2.5000000000000001E-3}," ==>",{"$f":"D4","v":2.5000000000000001E-3}]
[]
[null,50,"is",2.5000000000000001E-3,"of","??"]
[null,50," =",{"$f":"D6","v":2.5000000000000001E-3}," *","??"]
[null,"Part"," =","Rate"," *","Base"]
[null,"Formula = B = P/R"]
[null,"Rate",2.5000000000000001E-3]
[null,"Part (Doors) =",50]
[null,"Base (Doors) =",{"$f":"ROUND(C11/C10,2)","v":20000}]
[]
[]
[29]
["Step 1:"]
["Part","Monthly Loan PMT",1350]
["Statement from problem:"]
[{"$f":"\"Requirement: \"&B17&\" NOT exceed \"&TEXT(C27,\"0.00%\")&\" of Buyer's monthly income\"","v":"Requirement: Monthly Loan PMT NOT exceed 30.00% of Buyer's monthly income"}]
["Exceed means BIGGER or MORE THAN"]
["So it can't be bigger - which means it must be smaller or equal 30% of buyer's monthly income"]
["Break it diown:"]
[null,{"$f":"B17","v":"Monthly Loan PMT"}," <=",0.3,"of","buyer's monthly income"]
[null,{"$f":"C17","v":1350},{"$f":"C23","v":" <="},{"$f":"D23","v":0.3}," *",{"$f":"F23","v":"buyer's monthly income"}]
[null,"Part"," <=","Rate"," *","Base"]
["So Base is what we are solving for"]
["Rate","Upper Limit For % of monthly income",0.3]
["Base","Minimum buyer's monthly income"]
["Goal: Find Buyer's minimum monthly income"]
["Formula = B = P/R"]
["Requirement: it is money so must round to penny."]
["Step 2:"]
[{"$f":"A17","v":"Part"},{"$f":"B17","v":"Monthly Loan PMT"},{"$f":"C17","v":1350},null,"Check:"]
[{"$f":"A27","v":"Rate"},{"$f":"B27","v":"Upper Limit For % of monthly income"},{"$f":"C27","v":0.3},null,{"$f":"B34","v":"Upper Limit For % of monthly income"},{"$f":"C34","v":0.3}]
[{"$f":"A28","v":"Base"},{"$f":"B28","v":"Minimum buyer's monthly income"},{"$f":"ROUND(C33/C34,2)","v":4500},null,{"$f":"B35","v":"Minimum buyer's monthly income"},{"$f":"C35","v":4500}]
[null,null,null,null,{"$f":"B33","v":"Monthly Loan PMT"},{"$f":"ROUND(F35*F34,2)","v":1350}]
[]
["Step 3:"]
["The minimum amount that the homebuyer must make each month is $4,500."]
[]
[31]
["Step 1:"]
["Rate 1","% spent on housing",0.28000000000000003]
["Rate 2","% spent on Food",0.15]
["Rate 3","% spent on clothing",0.11]
["Rate 4","% spent on transportation",0.15]
["Rate 5","% spent on education",0.11]
["Rate 6","% spent on recreation",7.0000000000000007E-2]
["Rate 7","% spent on misc.",7.0000000000000007E-2]
["Rate 8","% saved","??"]
["Part for Savings","Savings per month",200]
["Base","Monthly Earnings","??"]
["Requirement: it is money so must round to penny."]
[]
["Step 2:"]
[{"$f":"A43","v":"Rate 1"},"% spent on housing",0.28000000000000003]
["Rate 2","% spent on Food",0.15]
["Rate 3","% spent on clothing",0.11]
["Rate 4","% spent on transportation",0.15]
["Rate 5","% spent on education",0.11]
[{"$f":"A48","v":"Rate 6"},"% spent on recreation",7.0000000000000007E-2]
[{"$f":"A49","v":"Rate 7"},"% spent on misc.",7.0000000000000007E-2]
["Total","Total of 7 rates",{"$f":"SUM(C56:C62)","v":0.94000000000000017}]
[{"$f":"A50","v":"Rate 8"},{"$f":"B50","v":"% saved"},{"$f":"1-C63","v":5.9999999999999831E-2},null,"Since sum of all 8 rates = 100% or 1, then 1 - 94% = Savings rate"]
[{"$f":"A51","v":"Part for Savings"},"Savings per month",200]
["Base","Monthly Earnings",{"$f":"ROUND(C65/C64,2)","v":3333.33}]
[]
[null,"check:",{"$f":"ROUND(C66*C64,2)","v":200}]
[]
["Step 3:"]
["The monthly earnings are $3,333.33, given that the sum of the expense % was 94% and savings per month were $200.00."]

{"sheet":"3(4)","index":28,"n_rows":52,"n_cols":6,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[13,"??% of 600 acres is 7.5 acres?"]
[null,"transalte:"]
[null,"% * Base = Part"]
[null,"Formula: P/B = R"]
["Rate",{"$f":"B7/B6","v":1.2500000000000001E-2}," ==>>",{"$f":"B5","v":1.2500000000000001E-2}," ==>> Rounded to tenth of a percent"]
["Base Acres",600,null,{"$f":"ROUND(D5,3)","v":1.2999999999999999E-2},"Because the number underneath 1.25% is .0125, you must use ROUND(1.25%, 3) or ROUND(.0125,3)"]
["Part Acres",7.5]
[]
[]
[]
[22]
["Step 1:"]
["Part","# of workers laid off",80]
["Base","Total # of workers",760]
["Rate","Percent of workers laid off","??"]
["Goal:",{"$f":"\"Find the \"&B15","v":"Find the Percent of workers laid off"}]
["Formula:","R = P/B"]
["Requirement: Round to tenth of a percent"]
["Step 2:"]
[{"$f":"A13","v":"Part"},{"$f":"B13","v":"# of workers laid off"},80,null,"Check:"]
[{"$f":"A14","v":"Base"},"Total # of workers",760,null,{"$f":"B21","v":"Total # of workers"},{"$f":"C21","v":760}]
["Rate","Percent of workers laid off",{"$f":"ROUND(C20/C21,3)","v":0.105},null,{"$f":"B22","v":"Percent of workers laid off"},0.105]
[null,null,"R = P/B",null,{"$f":"B20","v":"# of workers laid off"},{"$f":"F21*F22","v":79.8}]
[null,null,null,null,null,"P = B/R"]
[]
["Step 3:"]
["The percent of workers laid off was 10.5%"]
[]
[25]
["Step 1:"]
["Part 1","Newspaper",2250]
["Part 2","Radio",954]
["Part 3","Outdoor",1950]
["Part 4","TV",1425]
["Part 5","Yellow Pages",1605]
["Part 6","Misc.",2775]
["Base","Total Expenses","??"]
["Rate","Radio Ad Expense as a % of the Total Ad Expenses","??"]
["Goal:",{"$f":"\"Calculate \"&B38","v":"Calculate Radio Ad Expense as a % of the Total Ad Expenses"}]
["Requirement: Round to tenth of a percent"]
["Step 2:"]
[{"$f":"A31","v":"Part 1"},{"$f":"B31","v":"Newspaper"},2250]
[{"$f":"A32","v":"Part 2"},"Radio",954]
["Part 3","Outdoor",1950]
["Part 4","TV",1425]
["Part 5","Yellow Pages",1605]
["Part 6","Misc.",2775]
["Base","Total Expenses",{"$f":"SUM(C42:C47)","v":10959}]
["Rate","Radio Ad Expense as a % of the Total Ad Expenses",{"$f":"ROUND(C43/C48,3)","v":8.6999999999999994E-2},{"$f":"C49","v":8.6999999999999994E-2}]
[]
["Step 3:"]
["8.7% of the total advertising expenses was spent of radio ads."]

{"sheet":"3(5)","index":29,"n_rows":62,"n_cols":12,"rows_kept":62,"cut":false,"hidden":true,"merged":[[1,8,7,8],[1,9,2,9],[1,10,2,10],[1,11,7,11],[3,9,7,9],[3,10,7,10],[26,6,33,6],[14,8,21,8],[14,9,15,9],[14,10,21,10],[14,11,15,11],[16,9,21,9],[16,11,21,11],[28,8,33,8],[26,8,27,8],[26,9,27,9],[28,9,33,9],[26,10,33,10],[47,9,53,9],[47,10,48,10],[49,10,53,10],[47,11,48,11],[49,11,53,11]]}
[3,null,null,"Formula","or","Formula"]
["End = Part","End = Part after increase",30.7,null,null,null,null,null,"End = Part After Increase 30.7","Amount of Change","Rate of Change (Increase) + 10%","Rate = 100% + 10%"]
["AOC","Amount of Change","??"]
["ROC","Rate of Change (Increase)",0.1,null,null,null,null,null,null,"Base ","Beg = Base = 100%"]
["Beg = Base","Beg = Part Before increase","??","B = End P/R","or","Beg = AOC/ROC"]
["Rate","Rate","??","R = End P/B","or","R = 100% + ROC","End/Beg"]
["Requirement: Round To Cent"]
[]
[null,{"$f":"B6","v":"Rate"},{"$f":"C4+1","v":1.1000000000000001},{"$f":"F6","v":"R = 100% + ROC"}]
[{"$f":"A5","v":"Beg = Base"},{"$f":"B5","v":"Beg = Part Before increase"},{"$f":"ROUND(C2/C9,2)","v":27.91},{"$f":"D5","v":"B = End P/R"}]
[null,"Check",{"$f":"(C2-C10)/C4","v":27.899999999999991},{"$f":"F5","v":"Beg = AOC/ROC"},null,null,null,null,"End Part and Rate can be used in division"]
[]
[]
[7]
["End Part","End Part after decrease",598.15,"End",null,null,null,null,"Beg = Base","Amount of Change","Beg = Base = 100%","Rate of Change (Decrease) -30%"]
["Rate","Rate of Decrease",-0.3]
["Beg = Base","Beg = Amount before decrease",null,"Beg",null,null,null,null,null,"End = Part after Decrease",null,"Rate = 100% -30%"]
["Requirement: Round To Cent"]
[]
[null,"Rate",{"$f":"1+C16","v":0.7},{"$f":"D9","v":"R = 100% + ROC"}]
[{"$f":"A17","v":"Beg = Base"},{"$f":"B17","v":"Beg = Amount before decrease"},{"$f":"ROUND(C15/C20,2)","v":854.5},{"$f":"D5","v":"B = End P/R"}]
[null,"Check",{"$f":"(C21-C15)/-C16","v":854.50000000000011},{"$f":"F5","v":"Beg = AOC/ROC"}]
[]
[13]
["Step 1:",null,null,null,null,null,null,null,null,"End Part and Rate can be used in division"]
["ROC","Sales Tax Rate (Rate of change above sales)",0.08]
["AOC","Sales Tax Amount","??",null,null,null,"End Part = Sales + Tax Total Amount = $1,026",null,"Amount of Tax $","ROC = Tax Rate = 8%","Rate = 100% + 8% = 108%"]
["Rate ","Rate = ROC + 1",{"$f":"1+C26","v":1.08},"Sales % + Sales Tax %"]
["Beg = Base","Sales Amount Before Tax","??","Formula = P/R",null,null,null,null,"Beg = Sales Amount","Sales = 100%"]
["End = Part","Sales Amount + Tax Amount",1026]
["Goal 1: Find Sales Amount Before Tax, and Find the "]
["Goal 2: Find the Amount of Sales Tax"]
["Round to Penny because this is money"]
[]
["Step 2:"]
[{"$f":"A28","v":"Rate "},{"$f":"B28","v":"Rate = ROC + 1"},{"$f":"C28","v":1.08},"Sales % + Sales Tax %"]
[{"$f":"A30","v":"End = Part"},{"$f":"B30","v":"Sales Amount + Tax Amount"},{"$f":"C30","v":1026},null,null,null,"End Part and Rate can be used in division"]
[{"$f":"A29","v":"Beg = Base"},{"$f":"B29","v":"Sales Amount Before Tax"},{"$f":"ROUND(C37/C36,2)","v":950},"End P/R"]
[{"$f":"A27","v":"AOC"},"Sales Tax Amount",{"$f":"ROUND(C37-C38,2)","v":76},"subtract"]
[]
["Check",{"$f":"B38","v":"Sales Amount Before Tax"},{"$f":"ROUND(C39/C26,2)","v":950},"Beg = AOC/ROC"]
["Check",{"$f":"B39","v":"Sales Tax Amount"},{"$f":"ROUND(C38*C26,2)","v":76},"Beg B*ROC"]
[]
["Step 3:"]
["The amount of the original sales was $950 and the tax paid was $76."]
[]
[25]
["Step 1:",null,null,null,null,null,null,null,null,"Beg = Sales before drop","AOC = Amount of drop","ROC = -16%"]
["ROC","% drop in earnings",-0.16,"enter as a negative"]
["End = Part","Amount of earnings after drop",122,"millions",null,null,null,null,null,null,"End Part = Sales at end = $122. M.","Rate = 1 - 16% = 84%"]
["Rate","Rate = 1 + -ROC",{"$f":"1+C49","v":0.84},"Number multiplied by Beg (original) to get end amount"]
["Goal: Find earnings before drop (beg amount)"]
["Round to the nearest ten-thousands - because in millions, use ROUND with a 2."]
[]
["Step 2:"]
[{"$f":"A50","v":"End = Part"},{"$f":"B50","v":"Amount of earnings after drop"},{"$f":"C50","v":122},"millions"]
[{"$f":"A51","v":"Rate"},{"$f":"B51","v":"Rate = 1 + -ROC"},{"$f":"C51","v":0.84},"Number multiplied by Beg (original) to get end amount",null,null,null,null,null,"End Part and Rate can be used in division"]
["Beg","Find earnings before drop (beg amount)",{"$f":"ROUND(C56/C57,2)","v":145.24},"End P/R"]
[null,"Check",{"$f":"C58*C57","v":122.0016},"Beg B*R"]
[]
["Step 3:"]
["The earnings before drop were $145.24 million."]