{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Sheet1","index":0,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Formula 1",null,"IF(VALUE>=85,0.0599999999999677*VALUE + 169.800000000004,IF(VALUE>=50,0.000171428571427157*VALUE^2 - 0.297428571428412*VALUE + 198.942857142853,-2.4195*VALUE + 305.475))"]
["Formula 2",null,"IF(VALUE<=85,0.00760000000000005*VALUE^2 - 1.306*VALUE + 226.7,0.1867*VALUE + 154.73)"]
["Formula 3",null,"0.0000094095238095*VALUE^4 - 0.0024483809523768*VALUE^3 + 0.231833333333307*VALUE^2 - 9.74919047618003*VALUE + 334.614285714366"]
["Formula 4",null,"-0.0000373333333341108*VALUE^3 + 0.016640000000125*VALUE^2 - 1.96466666667158*VALUE + 249.599999999957"]

{"sheet":"Sheet2","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Formula 1"]
[]
["Value 1",20,{"$f":"\"=\"&SUBSTITUTE(VLOOKUP(Sheet2!$A$1,Sheet1!A$1:C$4,3),\"VALUE\",B3)","v":"=IF(20>=85,0.0599999999999677*20 + 169.800000000004,IF(20>=50,0.000171428571427157*20^2 - 0.297428571428412*20 + 198.942857142853,-2.4195*20 + 305.475))"},null,{"$f":"TextToFormula1","v":257.08500000000004}]
["Value 2",30,{"$f":"\"=\"&SUBSTITUTE(VLOOKUP(Sheet2!$A$1,Sheet1!A$1:C$4,3),\"VALUE\",B4)","v":"=IF(30>=85,0.0599999999999677*30 + 169.800000000004,IF(30>=50,0.000171428571427157*30^2 - 0.297428571428412*30 + 198.942857142853,-2.4195*30 + 305.475))"},null,232.89000000000001]
["Value 3",40,{"$f":"\"=\"&SUBSTITUTE(VLOOKUP(Sheet2!$A$1,Sheet1!A$1:C$4,3),\"VALUE\",B5)","v":"=IF(40>=85,0.0599999999999677*40 + 169.800000000004,IF(40>=50,0.000171428571427157*40^2 - 0.297428571428412*40 + 198.942857142853,-2.4195*40 + 305.475))"},null,208.69500000000002]
["Value 4",50,{"$f":"\"=\"&SUBSTITUTE(VLOOKUP(Sheet2!$A$1,Sheet1!A$1:C$4,3),\"VALUE\",B6)","v":"=IF(50>=85,0.0599999999999677*50 + 169.800000000004,IF(50>=50,0.000171428571427157*50^2 - 0.297428571428412*50 + 198.942857142853,-2.4195*50 + 305.475))"},null,184.50000000000028]
["Value 5",60,{"$f":"\"=\"&SUBSTITUTE(VLOOKUP(Sheet2!$A$1,Sheet1!A$1:C$4,3),\"VALUE\",B7)","v":"=IF(60>=85,0.0599999999999677*60 + 169.800000000004,IF(60>=50,0.000171428571427157*60^2 - 0.297428571428412*60 + 198.942857142853,-2.4195*60 + 305.475))"},null,181.71428571428604]
["Value 6",70,{"$f":"\"=\"&SUBSTITUTE(VLOOKUP(Sheet2!$A$1,Sheet1!A$1:C$4,3),\"VALUE\",B8)","v":"=IF(70>=85,0.0599999999999677*70 + 169.800000000004,IF(70>=50,0.000171428571427157*70^2 - 0.297428571428412*70 + 198.942857142853,-2.4195*70 + 305.475))"},null,178.96285714285722]
["Value 7",80,{"$f":"\"=\"&SUBSTITUTE(VLOOKUP(Sheet2!$A$1,Sheet1!A$1:C$4,3),\"VALUE\",B9)","v":"=IF(80>=85,0.0599999999999677*80 + 169.800000000004,IF(80>=50,0.000171428571427157*80^2 - 0.297428571428412*80 + 198.942857142853,-2.4195*80 + 305.475))"},null,176.24571428571386]

{"sheet":"Sheet3","index":2,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Value 1","Value 2","Value 3","Value 4","Value 5","Value 6","Value 7"]
[]
[]
[20,30,40,50,60,70,80]
[{"$f":"\"=\"&SUBSTITUTE(VLOOKUP(Sheet2!$A$1,Sheet1!$A$1:C$4,3),\"VALUE\",A4)","v":"=IF(20>=85,0.0599999999999677*20 + 169.800000000004,IF(20>=50,0.000171428571427157*20^2 - 0.297428571428412*20 + 198.942857142853,-2.4195*20 + 305.475))"},{"$f":"\"=\"&SUBSTITUTE(VLOOKUP(Sheet2!$A$1,Sheet1!$A$1:D$4,3),\"VALUE\",B4)","v":"=IF(30>=85,0.0599999999999677*30 + 169.800000000004,IF(30>=50,0.000171428571427157*30^2 - 0.297428571428412*30 + 198.942857142853,-2.4195*30 + 305.475))"},{"$f":"\"=\"&SUBSTITUTE(VLOOKUP(Sheet2!$A$1,Sheet1!$A$1:E$4,3),\"VALUE\",C4)","v":"=IF(40>=85,0.0599999999999677*40 + 169.800000000004,IF(40>=50,0.000171428571427157*40^2 - 0.297428571428412*40 + 198.942857142853,-2.4195*40 + 305.475))"},{"$f":"\"=\"&SUBSTITUTE(VLOOKUP(Sheet2!$A$1,Sheet1!$A$1:F$4,3),\"VALUE\",D4)","v":"=IF(50>=85,0.0599999999999677*50 + 169.800000000004,IF(50>=50,0.000171428571427157*50^2 - 0.297428571428412*50 + 198.942857142853,-2.4195*50 + 305.475))"},{"$f":"\"=\"&SUBSTITUTE(VLOOKUP(Sheet2!$A$1,Sheet1!$A$1:G$4,3),\"VALUE\",E4)","v":"=IF(60>=85,0.0599999999999677*60 + 169.800000000004,IF(60>=50,0.000171428571427157*60^2 - 0.297428571428412*60 + 198.942857142853,-2.4195*60 + 305.475))"},{"$f":"\"=\"&SUBSTITUTE(VLOOKUP(Sheet2!$A$1,Sheet1!$A$1:H$4,3),\"VALUE\",F4)","v":"=IF(70>=85,0.0599999999999677*70 + 169.800000000004,IF(70>=50,0.000171428571427157*70^2 - 0.297428571428412*70 + 198.942857142853,-2.4195*70 + 305.475))"},{"$f":"\"=\"&SUBSTITUTE(VLOOKUP(Sheet2!$A$1,Sheet1!$A$1:I$4,3),\"VALUE\",G4)","v":"=IF(80>=85,0.0599999999999677*80 + 169.800000000004,IF(80>=50,0.000171428571427157*80^2 - 0.297428571428412*80 + 198.942857142853,-2.4195*80 + 305.475))"}]
[{"$f":"TextToFormula2","v":257.08500000000004},232.89000000000001,208.69500000000002,184.50000000000028,181.71428571428604,178.96285714285722,176.24571428571386]