{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["main","VBA Manual","VBA Dynamic"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"main","index":0,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Automate Goal Seek in Excel"]
[]
[null,"Base Price",86.956521739130423]
[null,"VAT",{"$f":"C4*10%","v":8.695652173913043}]
[null,"Service Charge",{"$f":"C4*5%","v":4.3478260869565215}]
[null,"Total Price",{"$f":"SUM(C4:C6)","v":99.999999999999986}]

{"sheet":"VBA Manual","index":1,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,5,1,6],[1,1,1,3]]}
[]
[null,"Using VBA Macro",null,null,null,"Practice"]
[]
[null,"Base Price",100,null,null,"Base Price",86.956521739130423]
[null,"VAT",{"$f":"C4*10%","v":10},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=C4*10%"},null,"VAT",{"$f":"G4*10%","v":8.695652173913043}]
[null,"Service Charge",{"$f":"C4*5%","v":5},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=C4*5%"},null,"Service Charge",{"$f":"G4*5%","v":4.3478260869565215}]
[null,"Total Price",{"$f":"SUM(C4:C6)","v":115},"=SUM(C4:C6)",null,"Total Price",{"$f":"SUM(G4:G6)","v":99.999999999999986}]
[]
[null,"Target Price",null,null,null,"Target Price"]

{"sheet":"VBA Dynamic","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,5,1,6],[1,1,1,3]]}
[]
[null,"Automate Goal Seek When Value Changes",null,null,null,"Practice"]
[]
[null,"Base Price",869.56521739130437,null,null,"Base Price",86.956521739130423]
[null,"VAT",{"$f":"C4*10%","v":86.956521739130437},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=C4*10%"},null,"VAT",{"$f":"G4*10%","v":8.695652173913043}]
[null,"Service Charge",{"$f":"C4*5%","v":43.478260869565219},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=C4*5%"},null,"Service Charge",{"$f":"G4*5%","v":4.3478260869565215}]
[null,"Total Price",{"$f":"SUM(C4:C6)","v":1000},"=SUM(C4:C6)",null,"Total Price",{"$f":"SUM(G4:G6)","v":99.999999999999986}]
[]
[null,"Target Price",1000,null,null,"Target Price"]