{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Solving Mortgage Problem","Finding Unknown Value","Finding Breakeven Point","Solving Equation","Effective Interest Rate","Goal Seek for Multiple Cells","Goal Seek Precision"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dataset","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2]]}
[]
[null,"Using Goal Seek"]
[]
[null,"Amount Details"]
[null,"Loan",30000]
[null,"Term in Month",36]
[null,"Interest Rate",0.15]
[]
[null,"Payment",{"$f":"PMT(C7/12,C6,C5)","v":-1039.9598551258241}]

{"sheet":"Solving Mortgage Problem","index":1,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2],[1,5,1,6],[3,5,3,6]]}
[]
[null,"Solving Mortgage Problem",null,null,null,"Do it Yourself"]
[]
[null,"Amount Details",null,null,null,"Amount Details"]
[null,"Loan",30000,null,null,"Loan",30000]
[null,"Term in Month",36,null,null,"Term in Month",36]
[null,"Interest Rate",0.12248938803263348,null,null,"Interest Rate",0.15]
[]
[null,"Payment",{"$f":"PMT(C7/12,C6,C5)","v":-1000},null,null,"Payment",{"$f":"PMT(G7/12,G6,G5)","v":-1039.9598551258241}]

{"sheet":"Finding Unknown Value","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Finding Unknown Value",null,null,null,"Do it Yourself"]
[]
[null,"Candy A (Pounds)","x",null,null,"Candy A (Pounds)","x"]
[null,"Equation for Average Cost","(10x + (40-x)*6)/40",null,null,"Equation for Average Cost","(10x + (40-x)*6)/40"]
[]
[null,"Candy A (Pounds)",20,null,null,"Candy A (Pounds)"]
[null,"Candy A Unit Price",10,null,null,"Candy A Unit Price",10]
[null,"Candy B Unit Price",6,null,null,"Candy B Unit Price",6]
[]
[null,"Average Cost",{"$f":"(C7*C8+(40-C7)*C9)/40","v":8},null,null,"Average Cost",{"$f":"(G7*G8+(40-G7)*G9)/40","v":6}]

{"sheet":"Finding Breakeven Point","index":3,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,1,3,2],[1,1,1,2],[1,6,1,7],[3,6,3,7]]}
[]
[null,"Finding Breakeven Point",null,null,null,null,"Do it Yourself"]
[]
[null,"Amount Details",null,null,null,null,"Amount Details"]
[null,"Fixed Cost",15000,null,null,null,"Fixed Cost",15000]
[null,"Pay for Union",300,null,null,null,"Pay for Union",300]
[null,"Pay for each speaker",700,null,null,null,"Pay for each speaker",700]
[null,"Number of speakers",10,null,null,null,"Number of speakers",10]
[null,"Charge for each non-speaker",900,null,null,null,"Charge for each non-speaker",900]
[null,"Number of non-speakers",24.777777777777779,null,null,null,"Number of non-speakers"]
[]
[null,"Profit",{"$f":"C9*C10-C5-C6-C7*C8","v":0},null,null,null,"Profit",{"$f":"H9*H10-H5-H6-H7*H8","v":-22300}]

{"sheet":"Solving Equation","index":4,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Solving Equation",null,null,null,null,"Do it Yourself"]
[]
[null,"Equation","x^2+10x+25",null,null,null,"Equation","x^2+10x+25"]
[null,"Variable (x)",4.9999926927205456,null,null,null,"Variable (x)"]
[]
[null,"Solution",{"$f":"C5^2-10*C5+25","v":5.3393733878692728E-11},null,null,null,"Solution",{"$f":"H5^2-10*H5+25","v":25}]

{"sheet":"Effective Interest Rate","index":5,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2],[1,6,1,7],[3,6,3,7]]}
[]
[null,"Effective Interest Rate",null,null,null,null,"Do it Yourself"]
[]
[null,"Amount Details",null,null,null,null,"Amount Details"]
[null,"Nominal Interest Rate",0.1,null,null,null,"Nominal Interest Rate",0.1]
[null,"Compounding Periods Per Year",1.3164980532825581,null,null,null,"Compounding Periods Per Year",12]
[]
[null,"Effective Interest Rate",{"$f":"((1+C5/C6)^C6)-1","v":0.10118188174364162},null,null,null,"Effective Interest Rate",{"$f":"((1+H5/H6)^H6)-1","v":0.10471306744129683}]

{"sheet":"Goal Seek for Multiple Cells","index":6,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Using Goal Seek for Multiple Cells",null,null,null,null,null,"Do it Yourself"]
[]
[null,"Product","Total Cost","Selling Price","Profit Percentage",null,null,"Product","Total Cost","Selling Price","Profit Percentage"]
[null,"Mobile",4000,5400,{"$f":"((D5-C5)/C5)*100%","v":0.35},null,null,"Mobile",4000,4800,{"$f":"((J5-I5)/I5)*100%","v":0.2}]
[null,"Headphone",3000,4050,{"$f":"((D6-C6)/C6)*100%","v":0.35},null,null,"Headphone",3000,4000,{"$f":"((J6-I6)/I6)*100%","v":0.33333333333333331}]
[null,"Router",3500,4725,0.35,null,null,"Router",3500,4000,0.14285714285714285]
[null,"Camera",5000,6750,0.35,null,null,"Camera",5000,5500,0.1]
[null,"Printer",2500,3375,0.35,null,null,"Printer",2500,2800,0.12]

{"sheet":"Goal Seek Precision","index":7,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7],[3,1,3,2],[3,6,3,7]]}
[]
[null,"Goal Seek Precision",null,null,null,null,"Do it Yourself"]
[]
[null,"Amount Details",null,null,null,null,"Amount Details"]
[null,"Nominal Interest Rate",0.1,null,null,null,"Nominal Interest Rate",0.1]
[null,"Compounding Periods Per Year",1.6738209524479966,null,null,null,"Compounding Periods Per Year",12]
[]
[null,"Effective Interest Rate",{"$f":"((1+C5/C6)^C6)-1","v":0.10199999999518394},null,null,null,"Effective Interest Rate",{"$f":"((1+H5/H6)^H6)-1","v":0.10471306744129683}]