{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Overview","Dataset","EvaluateFormula_VBA","String_Formula_Mid_VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Overview","index":0,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Overview to Evaluate String as Formula with Excel VBA"]
[]
[null,"Text 1","Text 2","Formula Text","Formula Result"]
[null,"45","13","=B5*C5",{"$f":"EvaluateFormula(D5)","v":585}]
[null,"23","3","=B6/C6",{"$f":"EvaluateFormula(D6)","v":7.666666666666667}]
[null,61,9,"=B7-C7",{"$f":"EvaluateFormula(D7)","v":52}]
[null,85,21,"=B8+C8",{"$f":"EvaluateFormula(D8)","v":106}]
[null,"50",25,"=B9/C9",{"$f":"EvaluateFormula(D9)","v":0.04}]
[null,"21",36,"=B10/C10",{"$f":"EvaluateFormula(D10)","v":0.58333333333333337}]
[null,109,"10","=B11+C11",{"$f":"EvaluateFormula(D11)","v":119}]
[null,133,44,"=B12/C12",{"$f":"EvaluateFormula(D12)","v":3.0227272727272729}]
[null,"43",52.5,"=B13*C13",{"$f":"EvaluateFormula(D13)","v":2257.5}]
[null,"65","24","=B14/C14",{"$f":"EvaluateFormula(D14)","v":2.7083333333333335}]
[null,157,69.5,"=B15*C15",{"$f":"EvaluateFormula(D15)","v":10911.5}]
[null,181,"59.5","=B16/C16",{"$f":"EvaluateFormula(D16)","v":3.0420168067226889}]

{"sheet":"Dataset","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset to Evaluating String as Formula"]
[]
[null,"Text 1","Text 2","Formula Text","Formula Result"]
[null,"45","13","=B5*C5"]
[null,"23","3","=B6/C6"]
[null,61,9,"=B7-C7"]
[null,85,21,"=B8+C8"]
[null,"50",25,"=B9/C9"]
[null,"21",36,"=B10/C10"]
[null,109,"10","=B11+C11"]
[null,133,44,"=B12/C12"]
[null,"43",52.5,"=B13*C13"]
[null,"65","24","=B14/C14"]
[null,157,69.5,"=B15*C15"]
[null,181,"59.5","=B16/C16"]

{"sheet":"EvaluateFormula_VBA","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Creating User Defined Function with VBA Evaluate Function"]
[]
[null,"Text 1","Text 2","Formula Text","Formula Result"]
[null,"45","13","=B5*C5",{"$f":"EvaluateFormula(D5)","v":585}]
[null,"23","3","=B6/C6",{"$f":"EvaluateFormula(D6)","v":7.666666666666667}]
[null,61,9,"=B7-C7",{"$f":"EvaluateFormula(D7)","v":52}]
[null,85,21,"=B8+C8",{"$f":"EvaluateFormula(D8)","v":106}]
[null,"50",25,"=B9/C9",{"$f":"EvaluateFormula(D9)","v":0.04}]
[null,"21",36,"=B10/C10",{"$f":"EvaluateFormula(D10)","v":0.58333333333333337}]
[null,109,"10","=B11+C11",{"$f":"EvaluateFormula(D11)","v":119}]
[null,133,44,"=B12/C12",{"$f":"EvaluateFormula(D12)","v":3.0227272727272729}]
[null,"43",52.5,"=B13*C13",{"$f":"EvaluateFormula(D13)","v":2257.5}]
[null,"65","24","=B14/C14",{"$f":"EvaluateFormula(D14)","v":2.7083333333333335}]
[null,157,69.5,"=B15*C15",{"$f":"EvaluateFormula(D15)","v":10911.5}]
[null,181,"59.5","=B16/C16",{"$f":"EvaluateFormula(D16)","v":3.0420168067226889}]

{"sheet":"String_Formula_Mid_VBA","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Creating User Defined Function with VBA Mid Function"]
[]
[null,"Text 1","Text 2","Formula Text","Formula Result"]
[null,"45","13","\"45+13\"",{"$f":"EVALUATE_FORMULA(D5)","v":58}]
[null,"23","3","\"B6/C6\"",{"$f":"EVALUATE_FORMULA(D6)","v":7.666666666666667}]
[null,61,9,"\"B7-C7\"",{"$f":"EVALUATE_FORMULA(D7)","v":52}]
[null,85,21,"\"B8/C8\"",{"$f":"EVALUATE_FORMULA(D8)","v":4.0476190476190474}]
[null,"1",25,"\"B9+C9\"",{"$f":"EVALUATE_FORMULA(D9)","v":26}]
[null,"21",36,"\"B10*C10\"",{"$f":"EVALUATE_FORMULA(D10)","v":756}]
[null,109,"10","\"B11+C11\"",{"$f":"EVALUATE_FORMULA(D11)","v":119}]
[null,133,44,"\"B12/C12\"",{"$f":"EVALUATE_FORMULA(D12)","v":3.0227272727272729}]
[null,"43",52.5,"\"B13+C13\"",{"$f":"EVALUATE_FORMULA(D13)","v":95.5}]
[null,"65","24","\"B14-C14\"",{"$f":"EVALUATE_FORMULA(D14)","v":41}]
[null,157,69.5,"\"B15-C15\"",{"$f":"EVALUATE_FORMULA(D15)","v":87.5}]
[null,181,"59.5","\"B16/C16\"",{"$f":"EVALUATE_FORMULA(D16)","v":3.0420168067226889}]