{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["OneWayDataTable","OneWayDataTableSoln"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"OneWayDataTable","index":0,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Build a table and graph of the function: Y = X^2 + 3X + 4"]
["MODEL:"]
["X",4,"<-- Column Input Cell!"]
["Y",null,{"$f":"getformula(B4)","v":"<--  "}]
[]
[]
[null,"X","Y"]
[null,-5,null,{"$f":"getformula(C8)","v":"<--  "}]
[null,{"$f":"B8+1","v":-4}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Using the MODEL above build an Excel Data Table to replicate the table above:"]
[]
["Yellow-fill: Data Table Range [Formula(s) at TOP]"]
[null,"X","Y"]
[null,null,null,{"$f":"getformula(C24)&\": Data Table Formula Cell!\"","v":"<--  : Data Table Formula Cell!"}]
[null,-5,null,{"$f":"getformula(C25)","v":"<--  "}]
[null,{"$f":"B25+1","v":-4}]

{"sheet":"OneWayDataTableSoln","index":1,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Build a table and graph of the function: Y = X^2 + 3X + 4"]
["MODEL:"]
["X",4,"<-- Column Input Cell!"]
["Y",{"$f":"B3^2+3*B3+4","v":32},{"$f":"getformula(B4)","v":"<--  =B3^2+3*B3+4"}]
[]
[]
[null,"X","Y"]
[null,-5,{"$f":"B8^2+3*B8+4","v":14},{"$f":"getformula(C8)","v":"<--  =B8^2+3*B8+4"}]
[null,{"$f":"B8+1","v":-4},{"$f":"B9^2+3*B9+4","v":8},"<--  =B9^2+3*B9+4"]
[null,{"$f":"B9+1","v":-3},4,"<--  =B10^2+3*B10+4"]
[null,-2,2,"<--  =B11^2+3*B11+4"]
[null,-1,2,"<--  =B12^2+3*B12+4"]
[null,0,4,"<--  =B13^2+3*B13+4"]
[null,1,8,"<--  =B14^2+3*B14+4"]
[null,2,14,"<--  =B15^2+3*B15+4"]
[null,3,22,"<--  =B16^2+3*B16+4"]
[null,4,32,"<--  =B17^2+3*B17+4"]
[null,5,44,"<--  =B18^2+3*B18+4"]
[]
["Using the MODEL above build an Excel Data Table to replicate the table above:"]
[]
["Yellow-fill: Data Table Range [Formula(s) at TOP]"]
[null,"X","Y"]
[null,null,{"$f":"B4","v":32},{"$f":"getformula(C24)&\": Data Table Formula Cell!\"","v":"<--  =B4: Data Table Formula Cell!"}]
[null,-5,14,{"$f":"getformula(C25)","v":"<--  {=TABLE(,B3)}"}]
[null,{"$f":"B25+1","v":-4},8,"<--  {=TABLE(,B3)}"]
[null,{"$f":"B26+1","v":-3},4,"<--  {=TABLE(,B3)}"]
[null,-2,2,"<--  {=TABLE(,B3)}"]
[null,-1,2,"<--  {=TABLE(,B3)}"]
[null,0,4,"<--  {=TABLE(,B3)}"]
[null,1,8,"<--  {=TABLE(,B3)}"]
[null,2,14,"<--  {=TABLE(,B3)}"]
[null,3,22,"<--  {=TABLE(,B3)}"]
[null,4,32,"<--  {=TABLE(,B3)}"]
[null,5,44,"<--  {=TABLE(,B3)}"]