{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Semiautomated","Sample"],"not_rendered":{"charts":7,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Semiautomated","index":0,"n_rows":1000,"n_cols":6,"rows_kept":1000,"cut":false,"hidden":false,"merged":[[0,2,0,3]]}
["x","y","y = f(x) = a*x + b",null,"# data points","Test input"]
[0,0,"a","b",{"$f":"COUNT(A:A)","v":7},2.5]
[1,9,{"$f":"IF(A3<>\"\",(B3-B2)/(A3-A2),\"\")","v":9},{"$f":"IF(A3<>\"\",B2-C3*A2,\"\")","v":0},"Slope increasing?","Minimax formula"]
[2,16,{"$f":"IF(A4<>\"\",(B4-B3)/(A4-A3),\"\")","v":7},{"$f":"IF(A4<>\"\",B3-C4*A3,\"\")","v":2},{"$f":"AND(C3:INDEX(C:C,E2)<=C4:INDEX(C:C,E2+1))","v":false},{"$f":"REPT(\"=MAX(F2*{\"&sbCat(C3:INDEX(C:C,E2+1))&\"}+{\"&sbCat(D3:INDEX(D:D,E2+1))&\"})\",E4)","v":""}]
[3,21,5,6,"Slope decreasing?","Minimax formula"]
[4,24,3,12,{"$f":"AND(C3:INDEX(C:C,E2)>=C4:INDEX(C:C,E2+1))","v":true},{"$f":"REPT(\"=MIN(F2*{\"&sbCat(C3:INDEX(C:C,E2+1))&\"}+{\"&sbCat(D3:INDEX(D:D,E2+1))&\"})\",E6)","v":"=MIN(F2*{9,7,5,3,-2,-3}+{0,2,6,12,32,37})"}]
[5,22,-2,32,null,{"$f":"REPT(\"No solution: slopes need to increase or to decrease monotonously!\",NOT(E4+E6))","v":""}]
[6,19,-3,37,null,"Test output"]
[null,null,"","",null,{"$f":"IF(E4,sbEval(F4),IF(E6,sbEval(F6),\"\"))","v":18.5}]
[null,null,"","",null,"All-in-one with helper columns"]
[null,null,"","",null,{"$f":"IF(AND(C3:INDEX(C:C,COUNT(A:A))<=C4:INDEX(C:C,COUNT(A:A)+1)),\"=MAX(F2*{\"&sbCat(C3:INDEX(C:C,COUNT(A:A)+1))&\"}+{\"&sbCat(D3:INDEX(D:D,COUNT(A:A)+1))&\"})\",IF(AND(C3:INDEX(C:C,COUNT(A:A))>=C4:INDEX(C:C,COUNT(A:A)+1)),\"=MIN(F2*{\"&sbCat(C3:INDEX(C:C,COUNT(A:A)+1))&\"}+{\"&sbCat(D3:INDEX(D:D,COUNT(A:A)+1))&\"})\",\"No solution: slopes need to increase or to decrease monotonously!\"))","v":"=MIN(F2*{9,7,5,3,-2,-3}+{0,2,6,12,32,37})"}]
[null,null,"","",null,"All-in-one formula without helper columns"]
[null,null,"","",null,{"$f":"REPT(\"{\",sbGetCell(F11,\"IsArray\"))&sbGetCell(F11,\"ShowFormula\")&REPT(\"}\",sbGetCell(F11,\"IsArray\"))","v":"{=WENN(UND(C3:INDEX(C:C;ANZAHL(A:A))<=C4:INDEX(C:C;ANZAHL(A:A)+1));\"=MAX(F2*{\"&sbCat(C3:INDEX(C:C;ANZAHL(A:A)+1))&\"}+{\"&sbCat(D3:INDEX(D:D;ANZAHL(A:A)+1))&\"})\";WENN(UND(C3:INDEX(C:C;ANZAHL(A:A))>=C4:INDEX(C:C;ANZAHL(A:A)+1));\"=MIN(F2*{\"&sbCat(C3:INDEX(C:C;ANZAHL(A:A)+1))&\"}+{\"&sbCat(D3:INDEX(D:D;ANZAHL(A:A)+1))&\"})\";\"No solution: slopes need to increase or to decrease monotonously!\"))}"}]
[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":"IF(A68<>\"\",(B68-B67)/(A68-A67),\"\")","v":""},{"$f":"IF(A68<>\"\",B67-C68*A67,\"\")","v":""}]
[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":"IF(A132<>\"\",(B132-B131)/(A132-A131),\"\")","v":""},{"$f":"IF(A132<>\"\",B131-C132*A131,\"\")","v":""}]
[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":"IF(A196<>\"\",(B196-B195)/(A196-A195),\"\")","v":""},{"$f":"IF(A196<>\"\",B195-C196*A195,\"\")","v":""}]
[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":"IF(A260<>\"\",(B260-B259)/(A260-A259),\"\")","v":""},{"$f":"IF(A260<>\"\",B259-C260*A259,\"\")","v":""}]
[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":"IF(A324<>\"\",(B324-B323)/(A324-A323),\"\")","v":""},{"$f":"IF(A324<>\"\",B323-C324*A323,\"\")","v":""}]
[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":"IF(A388<>\"\",(B388-B387)/(A388-A387),\"\")","v":""},{"$f":"IF(A388<>\"\",B387-C388*A387,\"\")","v":""}]
[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":"IF(A452<>\"\",(B452-B451)/(A452-A451),\"\")","v":""},{"$f":"IF(A452<>\"\",B451-C452*A451,\"\")","v":""}]
[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":"IF(A516<>\"\",(B516-B515)/(A516-A515),\"\")","v":""},{"$f":"IF(A516<>\"\",B515-C516*A515,\"\")","v":""}]
[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":"IF(A580<>\"\",(B580-B579)/(A580-A579),\"\")","v":""},{"$f":"IF(A580<>\"\",B579-C580*A579,\"\")","v":""}]
[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":"IF(A644<>\"\",(B644-B643)/(A644-A643),\"\")","v":""},{"$f":"IF(A644<>\"\",B643-C644*A643,\"\")","v":""}]
[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":"IF(A708<>\"\",(B708-B707)/(A708-A707),\"\")","v":""},{"$f":"IF(A708<>\"\",B707-C708*A707,\"\")","v":""}]
[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":"IF(A749<>\"\",(B749-B748)/(A749-A748),\"\")","v":""},{"$f":"IF(A749<>\"\",B748-C749*A748,\"\")","v":""}]
[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":"IF(A813<>\"\",(B813-B812)/(A813-A812),\"\")","v":""},{"$f":"IF(A813<>\"\",B812-C813*A812,\"\")","v":""}]
[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":"IF(A877<>\"\",(B877-B876)/(A877-A876),\"\")","v":""},{"$f":"IF(A877<>\"\",B876-C877*A876,\"\")","v":""}]
[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":"IF(A941<>\"\",(B941-B940)/(A941-A940),\"\")","v":""},{"$f":"IF(A941<>\"\",B940-C941*A940,\"\")","v":""}]
[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,"",""]

{"sheet":"Sample","index":1,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,5,1,6],[11,5,11,6],[21,5,21,6],[33,5,33,6]]}
[]
[null,null,null,null,null,"f(x) = a*x + b"]
[null,null,"x","y",null,"a","b",null,"Formula"]
[null,null,0,0]
[null,null,100000,1100,null,{"$f":"(D5-D4)/(C5-C4)","v":1.0999999999999999E-2},{"$f":"D4-F5*C4","v":0},null,{"$f":"REPT(\"=MIN(C\"&ROW()&\"*{\"&sbCat(F5:F9)&\"}+{\"&sbCat(G5:G9)&\"})\",AND(F5:F8>=F6:F9))","v":"=MIN(C5*{0,011,0,007,0,0035,0,0025,0}+{0,400,1275,1775,3212,5})"}]
[null,null,250000,{"$f":"D5+(C6-C5)*0.7%","v":2150},null,{"$f":"(D6-D5)/(C6-C5)","v":7.0000000000000001E-3},{"$f":"D5-F6*C5","v":400},null,{"$f":"REPT(\"=MAX(C\"&ROW()&\"*{\"&sbCat(F5:F9)&\"}+{\"&sbCat(G5:G9)&\"})\",AND(F5:F8<=F6:F9))","v":""}]
[null,null,500000,{"$f":"D6+(C7-C6)*0.35%","v":3025},null,{"$f":"(D7-D6)/(C7-C6)","v":3.5000000000000001E-3},{"$f":"D6-F7*C6","v":1275},null,{"$f":"IF(LEN(I5&I6),\"\",\"Slopes need to increase or to decrease monotonously!\")","v":""}]
[null,null,575000,{"$f":"D7+(C8-C7)*0.25%","v":3212.5},null,{"$f":"(D8-D7)/(C8-C7)","v":2.5000000000000001E-3},{"$f":"D7-F8*C7","v":1775}]
[null,null,600000,{"$f":"D8+(C9-C8)*0%","v":3212.5},null,{"$f":"(D9-D8)/(C9-C8)","v":0},{"$f":"D8-F9*C8","v":3212.5}]
[]
[]
[null,null,null,null,null,"f(x) = a*x + b"]
[null,null,"x","y",null,"a","b",null,"Formula"]
[null,null,0,3]
[null,null,1,0,null,{"$f":"(D15-D14)/(C15-C14)","v":-3},{"$f":"D14-F15*C14","v":3},null,{"$f":"REPT(\"=MIN(C\"&ROW()&\"*{\"&sbCat(F15:F19)&\"}+{\"&sbCat(G15:G19)&\"})\",AND(F15:F18>=F16:F19))","v":""}]
[null,null,2,3,null,{"$f":"(D16-D15)/(C16-C15)","v":3},{"$f":"D15-F16*C15","v":-3},null,{"$f":"REPT(\"=MAX(C\"&ROW()&\"*{\"&sbCat(F15:F19)&\"}+{\"&sbCat(G15:G19)&\"})\",AND(F15:F18<=F16:F19))","v":"=MAX(C16*{-3,3,4,6,12}+{3,-3,-5,-11,-35})"}]
[null,null,3,7,null,{"$f":"(D17-D16)/(C17-C16)","v":4},{"$f":"D16-F17*C16","v":-5},null,{"$f":"IF(LEN(I15&I16),\"\",\"Slopes need to increase or to decrease monotonously!\")","v":""}]
[null,null,4,13,null,{"$f":"(D18-D17)/(C18-C17)","v":6},{"$f":"D17-F18*C17","v":-11}]
[null,null,5,25,null,{"$f":"(D19-D18)/(C19-C18)","v":12},{"$f":"D18-F19*C18","v":-35}]
[]
[]
[null,null,null,null,null,"f(x) = a*x + b"]
[null,null,"x","y",null,"a","b",null,"Formula"]
[null,null,0,{"$f":"-((C24-5)^2)+25","v":0}]
[null,null,1,9,null,{"$f":"(D25-D24)/(C25-C24)","v":9},{"$f":"D24-F25*C24","v":0},null,{"$f":"REPT(\"=MIN(C\"&ROW()&\"*{\"&sbCat(F25:F30)&\"}+{\"&sbCat(G25:G30)&\"})\",AND(F25:F29>=F26:F30))","v":"=MIN(C25*{9,7,5,3,-2,-3}+{0,2,6,12,32,37})"}]
[null,null,2,16,null,7,2,null,{"$f":"REPT(\"=MAX(C\"&ROW()&\"*{\"&sbCat(F25:F30)&\"}+{\"&sbCat(G25:G30)&\"})\",AND(F25:F29<=F26:F30))","v":""}]
[null,null,3,21,null,5,6,null,{"$f":"IF(LEN(I25&I26),\"\",\"Slopes need to increase or to decrease monotonously!\")","v":""}]
[null,null,4,24,null,3,12]
[null,null,5,22,null,-2,32]
[null,null,6,19,null,-3,37]
[]
[]
[]
[null,null,null,null,null,"f(x) = a*x + b"]
[null,null,"x","y",null,"a","b",null,"Formula"]
[null,null,0,0]
[null,null,1,2,null,{"$f":"(D37-D36)/(C37-C36)","v":2},{"$f":"D36-F37*C36","v":0},null,{"$f":"REPT(\"=MIN(C\"&ROW()&\"*{\"&sbCat(F37:F42)&\"}+{\"&sbCat(G37:G42)&\"})\",AND(F37:F41>=F38:F42)*SIGN(AND(F37:F42>=0)+AND(F37:F42<=0)))","v":""}]
[null,null,2,3,null,1,1,null,{"$f":"REPT(\"=MAX(C\"&ROW()&\"*{\"&sbCat(F37:F42)&\"}+{\"&sbCat(G37:G42)&\"})\",AND(F37:F41<=F38:F42)*SIGN(AND(F37:F42>=0)+AND(F37:F42<=0)))","v":""}]
[null,null,3,5,null,2,-1,null,{"$f":"IF(LEN(I37&I38),\"\",\"Slopes need to increase or to decrease monotonously!\")","v":"Slopes need to increase or to decrease monotonously!"}]
[null,null,4,6,null,1,2]
[null,null,5,7,null,1,2]
[null,null,6,{"$f":"D41","v":7},null,0,7]