{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Intro","step 1","step 2","step 3 ","step 4","step 5","step 6","step 7","step 8","step 9","step 10"],"not_rendered":{"charts":6,"images":4,"macros":0,"external_links":0,"defined_names":0,"comments":2,"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":"Intro","index":0,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Sinex 2003"]

{"sheet":"step 1","index":1,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"a = ",1,"b =",1,"c = ",1]
[]
["x"]
[-10]
[-8]
[-6]
[-4]
[-2]
[0]
[2,null,null,null,"The yellow cells will be the ones that can be changed!!"]
[4]
[6]
[8]
[10]

{"sheet":"step 2","index":2,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"a = ",1,"b =",1,"c = ",1]
[]
["x","y"]
[-10,{"$f":"$E$2*(A5)^2+$G$2*A5+$I$2","v":91}]
[-8,{"$f":"$E$2*(A6)^2+$G$2*A6+$I$2","v":57}]
[-6,31]
[-4,13]
[-2,3,null,null,"The use of $E$2 locks this cell into the formula."]
[0,1]
[2,7]
[4,21]
[6,43]
[8,73]
[10,111]

{"sheet":"step 3 ","index":3,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Highlight the two columns"]
["of data, and then select the",null,null,"a = ",1,"b =",1,"c = ",1]
["chart wizard."]
["x","y"]
[-10,{"$f":"$E$2*(A5)^2+$G$2*A5+$I$2","v":91}]
[-8,57]
[-6,31]
[-4,13,null,null,null,null,null,null,null,null,"pick this one!"]
[-2,3]
[0,1]
[2,7]
[4,21]
[6,43]
[8,73]
[10,111]

{"sheet":"step 4","index":4,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"a = ",1,"b =",0,"c = ",0]
[]
["x","y"]
[-10,{"$f":"$E$2*(A5)^2+$G$2*A5+$I$2","v":100}]
[-8,64]
[-6,36]
[-4,16]
[-2,4]
[0,0]
[2,4]
[4,16]
[6,36]
[8,64]
[10,100]
[]
[]
[null,null,null,"Now change the values in the yellow boxes; hit enter or click on another cell, "]
[null,null,null,"and see the graph respond."]

{"sheet":"step 5","index":5,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"a = ",1,"b =",1,"c = ",1]
[]
["x","y","y ref"]
[-10,{"$f":"$E$2*(A5)^2+$G$2*A5+$I$2","v":91},91]
[-8,57,57]
[-6,31,31]
[-4,13,13]
[-2,3,3]
[0,1,1]
[2,7,7]
[4,21,21]
[6,43,43]
[8,73,73]
[10,111,111]
[]
[null,null,null,"Now change the values in the yellow boxes; hit enter or click on another cell, "]
[null,null,null,"and see the graph respond."]

{"sheet":"step 6","index":6,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Comment box, move cursor over C4"]
[null,null,null,"a = ",{"$f":"E3-100","v":5},"b =",{"$f":"G3-100","v":1},"c = ",{"$f":"I3-100","v":-24}]
[null,null,null,null,105,null,101,null,76]
["x","y","y ref"]
[-10,{"$f":"$E$2*(A5)^2+$G$2*A5+$I$2","v":466},91,null,null,null,null,null,null,null,"spinner"]
[-8,288,57,null,null,null,null,null,null,null,"right click on"]
[-6,150,31,null,null,null,null,null,null,null,"the spinner"]
[-4,52,13,null,null,null,null,null,null,null,"and select"]
[-2,-6,3,null,null,null,null,null,null,null,"Format Control…"]
[0,-24,1,null,null,null,null,null,null,null,"then click on the"]
[2,-2,7,null,null,null,null,null,null,null,"Control tab."]
[4,60,21]
[6,162,43,null,null,null,null,null,null,null,"The spinner is "]
[8,304,73,null,null,null,null,null,null,null,"linked to the cell"]
[10,486,111,null,null,null,null,null,null,null,"below (I3)."]
[]
[null,null,null,"Now use the spinners to raise and lower the values of the coefficients."]
[null,null,null,"Since the spinner is linked to a formula in the blue box, you cannot type the values in now!"]
[]
[null,null,null,"Without the use of a formula, both typing in the cell or using the spinner will function."]
[]
[null,null,null,"The spinners and scroll bars can only handle POSITIVE and whole numbers!"]

{"sheet":"step 7","index":7,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,"negative values",{"$f":"H6-100","v":-15}]
[]
[null,null,null,null,"decimal values",{"$f":"(H6-100)/10","v":-1.5},null,85,null,"scroll bar linked to this cell"]
[null,null,null,null,null,null,null,null,null,"you would hide this value"]
[null,null,null,null,null,null,null,null,null,"limits: 0 - 200"]
[]
[]
[]
[null,null,null,null,null,"For spinners and scroll bars, the values can only be positive"]
[null,null,null,null,null,"and whole increments.  So formulas must be used to get around"]
[null,"vertical scroll bar can be resized ",null,null,null,"this shortcoming."]
[null,"to display horizontally"]
[]
[null,"Scroll bars (through the Format Control and select control tab) have lower and upper limits"]
[null,"plus the increment (every 1 or 2 or 10) can be set."]

{"sheet":"step 8","index":8,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null," ","slope = ",1.3,null,"intercept =",3,null,"regression "]
[null,null,null,null,null,null,null,null,null,null,"equation"]
["x","y"]
[0,{"$f":"$F$2*A5+$I$2","v":3}]
[1,{"$f":"$F$2*A6+$I$2","v":4.3}]
[2,5.6]
[3,6.9,null,null,null,null,null,null,null,null,"Move the"]
[4,8.1999999999999993,null,null,null,null,null,null,null,null,"scroll bar and"]
[5,9.5,null,null,null,null,null,null,null,null,"watch the graph!"]
[6,10.8]
[7,12.1,null,null,null,null,null,null,null,null,"The orange line"]
[8,13.4,null,null,null,null,null,null,null,null,"is a linear"]
[9,14.700000000000001,null,null,null,null,null,null,null,null,"regression line"]
[10,16,null,null,null,null,null,null,null,null,"and will respond"]
[null,null,null,null,null,null,null,null,null,null,"as the data are"]
[{"$f":"G19","v":5.5},{"$f":"$F$2*A17+$I$2","v":10.15},null,null,null,null,null,null,null,null,"changed."]
[]
[null,null,null,null,"What is y when x = ",null,{"$f":"(G21-100)/10","v":5.5},"y = ",{"$f":"B17","v":10.15}]
[]
["You would hide the cells in gray.",null,null,"This is the vertical line.",null,null,155,null,"This is the horizontal line."]
[null,null,null,{"$f":"A17","v":5.5},0,null,null,null,0,{"$f":"B17","v":10.15}]
["Step 9 explains how to do this",null,null,{"$f":"A17","v":5.5},{"$f":"B17","v":10.15},null,null,null,{"$f":"A17","v":5.5},{"$f":"B17","v":10.15}]

{"sheet":"step 9","index":9,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"With the chart active, go to Chart on the menu"]
[null,"bar and select Add Data…"]

{"sheet":"step 10","index":10,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Restricting the input values "]
[]
["x","y1=k1x2","y2=k2x2",null,"k1 =",1,null,"k2 =",3]
[0,{"$f":"$F$3*A4^2","v":0},{"$f":"$I$3*A4^2","v":0}]
[1,{"$f":"$F$3*A5^2","v":1},{"$f":"$I$3*A5^2","v":3}]
[2,{"$f":"$F$3*A6^2","v":4},{"$f":"$I$3*A6^2","v":12}]
[3,9,27]
[4,16,48]
[5,25,75]
[6,36,108]
[7,49,147]
[8,64,192]
[9,81,243]
[10,100,300]
[]
[]
[]
[]
[]
[null,null,null,null,"Yellow boxes have a limit set using Data Validation"]
[]
[null,null,null,null,"Click on cell, the select Data from the menu bar, and then Validation…"]