{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Robin","Test","Test_Bilinear"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Robin","index":0,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Tax Table","Income","Tax"]
[null,0,-300]
[null,300,0]
[null,600,0]
[null,900,300]
["Prince John",1000,{"$f":"sbInterp(B2:B5,C2:C5,B6:B8)","v":400}]
["Sheriff",800,200]
["Brother Tuck",50,-250]

{"sheet":"Test","index":1,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["X","Y"]
[1,0]
[2,1]
[3,2]
[4,3]
[]
[null,"sType:","Const","Linear","LinearInVariance"]
[null,"bExtrapolate:",true,true,true]
["New X","sExtraType:","Const","Linear","LinearInVariance",null,"Expected correct results:"]
[0,"New Y:",{"$f":"sbInterp($A$2:$A$5,$B$2:$B$5,$A10:$A18,C7,C8,C9)","v":0},{"$f":"sbInterp($A$2:$A$5,$B$2:$B$5,$A10:$A18,D7,D8,D9)","v":-1},{"$f":"sbInterp($A$2:$A$5,$B$2:$B$5,$A10:$A18,E7,E8,E9)","v":0},null,0,-1,0]
[1,null,0,0,0,null,0,0,0]
[1.5,null,0,0.5,0.70710678118654757,null,0,0.5,0.70710678118654757]
[2,null,1,1,1,null,1,1,1]
[2.5,null,1,1.5,1.5811388300841898,null,1,1.5,1.5811388300841898]
[3,null,2,2,2,null,2,2,2]
[3.5,null,2,2.5,2.5495097567963922,null,2,2.5,2.5495097567963922]
[4,null,3,3,3,null,3,3,3]
[5,null,3,4,3.7416573867739413,null,3,4,3.7416573867739413]
[]
[null,"sType:","Const","Linear","LinearInVariance"]
[null,"bExtrapolate:",false,false,false]
["New X","sExtraType:","Const","Linear","LinearInVariance",null,"Expected correct results:"]
[0,"New Y:",{"$f":"sbInterp($A$2:$A$5,$B$2:$B$5,$A23:$A31,C20,C21,C22)","v":{"$error":"#NUM!"}},{"$f":"sbInterp($A$2:$A$5,$B$2:$B$5,$A23:$A31,D20,D21,D22)","v":{"$error":"#NUM!"}},{"$f":"sbInterp($A$2:$A$5,$B$2:$B$5,$A23:$A31,E20,E21,E22)","v":{"$error":"#NUM!"}},null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[1,null,0,0,0,null,0,0,0]
[1.5,null,0,0.5,0.70710678118654757,null,0,0.5,0.70710678118654757]
[2,null,1,1,1,null,1,1,1]
[2.5,null,1,1.5,1.5811388300841898,null,1,1.5,1.5811388300841898]
[3,null,2,2,2,null,2,2,2]
[3.5,null,2,2.5,2.5495097567963922,null,2,2.5,2.5495097567963922]
[4,null,3,3,3,null,3,3,3]
[5,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[]
[null,"sType:","Const","Linear","LinearInVariance"]
[null,"bExtrapolate:",true,true,true]
["New X","sExtraType:","Const","Const","Linear",null,"Expected correct results:"]
[0,"New Y:",{"$f":"sbInterp($A$2:$A$5,$B$2:$B$5,$A36:$A44,C33,C34,C35)","v":0},{"$f":"sbInterp($A$2:$A$5,$B$2:$B$5,$A36:$A44,D33,D34,D35)","v":0},{"$f":"sbInterp($A$2:$A$5,$B$2:$B$5,$A36:$A44,E33,E34,E35)","v":-1},null,0,0,-1]
[1,null,0,0,0,null,0,0,0]
[1.5,null,0,0.5,0.70710678118654757,null,0,0.5,0.70710678118654757]
[2,null,1,1,1,null,1,1,1]
[2.5,null,1,1.5,1.5811388300841898,null,1,1.5,1.5811388300841898]
[3,null,2,2,2,null,2,2,2]
[3.5,null,2,2.5,2.5495097567963922,null,2,2.5,2.5495097567963922]
[4,null,3,3,3,null,3,3,3]
[5,null,3,3,4,null,3,3,4]

{"sheet":"Test_Bilinear","index":2,"n_rows":30,"n_cols":277,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Interpolate","Start","Increment","End","Method","Extrapolate?"]
["x",0,1,10,"Linear",false]
["y",0,1,10,"Linear",false]
[]
[]
["Input"]
["y \\ x",0,10]
[0,0,10]
[10,10,20]
[]
[]
["Intermediate table: interpolate x"]
["y \\ x",{"$f":"$B$2+(COLUMN()-COLUMN($B$2))*$C$2","v":0},{"$f":"$B$2+(COLUMN()-COLUMN($B$2))*$C$2","v":1},2,3,4,5,6,7,8,9,10]
[{"$f":"A8","v":0},{"$f":"IFERROR(sbInterp($B$7:$C$7,$B8:$C8,B$13:L$13,$E$2,$F$2),\"\")","v":0},1,2,3,4,5,6,7,8,9,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M8","v":0}]
[{"$f":"A9","v":10},{"$f":"IFERROR(sbInterp($B$7:$C$7,$B9:$C9,B$13:L$13,$E$2,$F$2),\"\")","v":10},11,12,13,14,15,16,17,18,19,20]
[null,{"$f":"IFERROR(sbInterp($H$7:$M$7,#REF!,B$13:JQ$13,$E$2,$F$2),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
["Output table: interpolate y"]
["y \\ x",{"$f":"$B$2+(COLUMN()-COLUMN($B$2))*$C$2","v":0},{"$f":"$B$2+(COLUMN()-COLUMN($B$2))*$C$2","v":1},2,3,4,5,6,7,8,9,10]
[{"$f":"$B$3+(ROW()-ROW($B$20))*$C$3","v":0},{"$f":"IFERROR(sbInterp($A$14:$A$15,B$14:B$15,$A20:$A30,$E$3,$F$3),\"\")","v":0},{"$f":"IFERROR(sbInterp($A$14:$A$15,C$14:C$15,$A20:$A30,$E$3,$F$3),\"\")","v":1},{"$f":"IFERROR(sbInterp($A$14:$A$15,D$14:D$15,$A20:$A30,$E$3,$F$3),\"\")","v":2},{"$f":"IFERROR(sbInterp($A$14:$A$15,E$14:E$15,$A20:$A30,$E$3,$F$3),\"\")","v":3},{"$f":"IFERROR(sbInterp($A$14:$A$15,F$14:F$15,$A20:$A30,$E$3,$F$3),\"\")","v":4},{"$f":"IFERROR(sbInterp($A$14:$A$15,G$14:G$15,$A20:$A30,$E$3,$F$3),\"\")","v":5},{"$f":"IFERROR(sbInterp($A$14:$A$15,H$14:H$15,$A20:$A30,$E$3,$F$3),\"\")","v":6},{"$f":"IFERROR(sbInterp($A$14:$A$15,I$14:I$15,$A20:$A30,$E$3,$F$3),\"\")","v":7},{"$f":"IFERROR(sbInterp($A$14:$A$15,J$14:J$15,$A20:$A30,$E$3,$F$3),\"\")","v":8},{"$f":"IFERROR(sbInterp($A$14:$A$15,K$14:K$15,$A20:$A30,$E$3,$F$3),\"\")","v":9},{"$f":"IFERROR(sbInterp($A$14:$A$15,L$14:L$15,$A20:$A30,$E$3,$F$3),\"\")","v":10}]
[1,1,2,3,4,5,6,7,8,9,10,11]
[2,2,3,4,5,6,7,8,9,10,11,12]
[3,3,4,5,6,7,8,9,10,11,12,13]
[4,4,5,6,7,8,9,10,11,12,13,14]
[5,5,6,7,8,9,10,11,12,13,14,15]
[6,6,7,8,9,10,11,12,13,14,15,16]
[7,7,8,9,10,11,12,13,14,15,16,17]
[8,8,9,10,11,12,13,14,15,16,17,18]
[9,9,10,11,12,13,14,15,16,17,18,19]
[10,10,11,12,13,14,15,16,17,18,19,20]