{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["3(2)","3(2an)","3(3)","3(3an)","3(4)","3(4an)","3(5) I","3(5an) I","3(5) D","3(5an) D","3(5) Rate = 1 + ROC","3(5an) Rate = 1 + ROC","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"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":"3(2)","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["If your Gross Pay is $900.00 and you own 15.00% in Tax what is the amount of the tax paid?"]

{"sheet":"3(2an)","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"If your Gross Pay is \"&DOLLAR(B3)&\" and you own \"&TEXT(B4,\"0.00%\")&\" in Tax what is the amount of the tax paid?\"","v":"If your Gross Pay is $900.00 and you own 15.00% in Tax what is the amount of the tax paid?"}]
[]
["Base = Gross Pay =",900]
["Rate = Tax Rate =",0.15]
["Part = Amount of tax paid","??"]
["Formula: P = R * B"]
["Amount of Tax Paid",{"$f":"B3*B4","v":135}]

{"sheet":"3(3)","index":2,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["If the Financial Statement says the Wage Expense was $10,000.00."]
["and the Wage Expenses as a Percentage of Total Revenue was"]
["20.00%, what was Total Revenue?"]

{"sheet":"3(3an)","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"If the Financial Statement says the Wage Expense was \"&DOLLAR(B7)&\".\"","v":"If the Financial Statement says the Wage Expense was $10,000.00."}]
["and the Wage Expenses as a Percentage of Total Revenue was"]
[{"$f":"TEXT(B6,\"0.00%\")&\", what was Total Revenue?\"","v":"20.00%, what was Total Revenue?"}]
[]
["Base = Total Revenue","??"]
["Rate = ",0.2,"Wage Expenses as a Percentage of Total Revenue"]
["Part = Wage Expense =",10000]
["Formula = B = P/R"]
["Total Revenue",{"$f":"B7/B6","v":50000}]

{"sheet":"3(4)","index":4,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["The number of students in the district that missed 20 or more days of school in the year was 4,500"]
["The number of students in the district was 22,500"]
["What is the percentage of students that missed 20 or more days of school in the year"]

{"sheet":"3(4an)","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"The number of students in the district that missed 20 or more days of school in the year was \"&FIXED(B7,0)","v":"The number of students in the district that missed 20 or more days of school in the year was 4,500"}]
[{"$f":"\"The number of students in the district was \"&FIXED(B5,0)","v":"The number of students in the district was 22,500"}]
["What is the percentage of students that missed 20 or more days of school in the year"]
[]
["Base = All Students",22500]
["Rate =","??","percentage of students that missed 20 or more days of school in the year"]
["Part = Students Missed >20 Days",4500]
["Formula = R = P/B"]
["Percentage of students that missed 20 or more days of school in the year",{"$f":"B7/B5","v":0.2}]

{"sheet":"3(5) I","index":6,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["The number of students in the district that missed 20 or more days of school last year was 4,500"]
["The number of students in the district that missed 20 or more days of school this year was 6,750"]
["What was the percentage change?"]
[]
["Begin"]
["End"]
["Rate"]
["AOC",null,null,null,null,"Beg"," +","AOC"," =","End"]
["ROC"]
[null,null,null,null,null,"Beg Rate"," +","ROC",null,"Rate"]
[]
[null,null,null,null,null,"AOC"," /","ROC"," =","Beg"]
[]
[null,null,null,null,null,"End"," /","Rate"," =","Beg"]

{"sheet":"3(5an) I","index":7,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"The number of students in the district that missed 20 or more days of school last year was \"&FIXED(B5,0)","v":"The number of students in the district that missed 20 or more days of school last year was 4,500"}]
[{"$f":"\"The number of students in the district that missed 20 or more days of school this year was \"&FIXED(B6,0)","v":"The number of students in the district that missed 20 or more days of school this year was 6,750"}]
["What was the percentage change?"]
[]
["Begin",4500,"Last Year's # Students Missed School"]
["End",6750,"This Year's # Students Missed School"]
["Rate","End/Beg"]
["AOC","End - Beg",null,null,null,"Beg"," +","AOC"," =","End"]
["ROC","AOC/Beg",null,null,null,null,null,null,null,{"$f":"B14+B12","v":6750}]
[null,null,null,null,null,"Beg Rate"," +","ROC",null,"Rate","Note: 1+ROC + Rate"]
[{"$f":"A6","v":"End"},"AOC","Rate","ROC",null,null,null,null,null,{"$f":"D14+D12","v":1.5},{"$f":"1+D12","v":1.5}]
[{"$f":"B6","v":6750},{"$f":"A12-B14","v":2250},{"$f":"D12+D14","v":1.5},{"$f":"B12/B14","v":0.5},null,"AOC"," /","ROC"," =","Beg"]
[null,"Beg",null,"Beg Rate",null,null,null,null,null,{"$f":"B12/D12","v":4500}]
[null,{"$f":"B5","v":4500},null,1,null,"End"," /","Rate"," =","Beg"]
[null,null,null,null,null,null,null,null,null,{"$f":"A12/C12","v":4500}]

{"sheet":"3(5) D","index":8,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["The number of students in the district that missed 20 or more days of school last year was 4,500"]
["The number of students in the district that missed 20 or more days of school this year was 3,150"]
["What was the percentage change?"]
[]
["Begin"]
["End"]
["Rate"]
["AOC",null,null,null,null,"Beg"," +","AOC"," =","End"]
["ROC"]
[null,null,null,null,null,"Beg Rate"," +","ROC",null,"Rate"]
[]
[null,null,null,null,null,"AOC"," /","ROC"," =","Beg"]
[]
[null,null,null,null,null,"End"," /","Rate"," =","Beg"]

{"sheet":"3(5an) D","index":9,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"The number of students in the district that missed 20 or more days of school last year was \"&FIXED(B5,0)","v":"The number of students in the district that missed 20 or more days of school last year was 4,500"}]
[{"$f":"\"The number of students in the district that missed 20 or more days of school this year was \"&FIXED(B6,0)","v":"The number of students in the district that missed 20 or more days of school this year was 3,150"}]
["What was the percentage change?"]
[]
["Begin",4500,"Last Year's # Students Missed School"]
["End",3150,"This Year's # Students Missed School"]
["Rate","End/Beg"]
["AOC","End - Beg",null,null,null,{"$f":"A11","v":"Beg"}," +",{"$f":"B11","v":"AOC"}," =",{"$f":"B13","v":"End"}]
["ROC","AOC/Beg",null,null,null,null,null,null,null,{"$f":"B12+A12","v":3150}]
[null,null,null,null,null,{"$f":"C11","v":"Beg Rate"}," +",{"$f":"D11","v":"ROC"},null,{"$f":"D13","v":"Rate"},"Note: 1+ROC = Rate"]
["Beg","AOC","Beg Rate","ROC",null,null,null,null,null,{"$f":"C12+D12","v":0.7},{"$f":"1+D12","v":0.7}]
[{"$f":"B5","v":4500},{"$f":"B14-A12","v":-1350},1,{"$f":"B12/A12","v":-0.3},null,{"$f":"B11","v":"AOC"}," /",{"$f":"D11","v":"ROC"}," =",{"$f":"A11","v":"Beg"}]
[null,"End",null,"Rate",null,null,null,null,null,{"$f":"B12/D12","v":4500}]
[null,{"$f":"B6","v":3150},null,{"$f":"B14/A12","v":0.7},null,{"$f":"B13","v":"End"}," /",{"$f":"D13","v":"Rate"}," =",{"$f":"A11","v":"Beg"}]
[null,null,null,null,null,null,null,null,null,{"$f":"B14/D14","v":4500}]

{"sheet":"3(5) Rate = 1 + ROC","index":10,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Invest amount",25000,"Beg"]
["CD Rate for year",3.5000000000000003E-2,"ROC"]
["Rate = Amount to multiply by Beg to get End"]
["Amount at end of year"]
["Amount at end of year"]
[]
["Invest amount",25000,"Beg"]
["Decrease in Value For Year",-0.125,"ROC"]
["Rate = Amount to multiply by Beg to get End"]
["Amount at end of year"]
["Amount at end of year"]
[]
["Note:"]
["Rate = 1 + ROC"]
["ROC = Rate - 1"]

{"sheet":"3(5an) Rate = 1 + ROC","index":11,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Invest amount",25000,"Beg"]
["CD Rate for year",3.5000000000000003E-2,"ROC"]
["Rate = Amount to multiply by Beg to get End",{"$f":"1+B2","v":1.0349999999999999},"Rate = 1 + ROC"]
["Amount at end of year",{"$f":"B1*B3","v":25874.999999999996},"End = Beg * Rate"]
["Amount at end of year",{"$f":"B1*(1+B2)","v":25874.999999999996},"End = Beg *(1+ROC)",null,null,{"$f":"FV(B2,1,,-B1)","v":25874.999999999996}]
[]
["Invest amount",25000,"Beg"]
["Decrease in Value For Year",-0.125,"ROC"]
["Rate = Amount to multiply by Beg to get End",{"$f":"1+B8","v":0.875},"Rate = 1 + ROC"]
["Amount at end of year",{"$f":"B7*B9","v":21875},"End = Beg * Rate"]
["Amount at end of year",{"$f":"B7*(1+B8)","v":21875},"End = Beg *(1+ROC)",null,null,{"$f":"FV(B8,1,,-B7)","v":21875}]
[]
["Note:"]
["Rate = 1 + ROC"]
["ROC = Rate - 1"]

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

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