{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["RevComm"],"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":"RevComm","index":0,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["x",0]
["f(x) = exp(-x)-x",{"$f":"EXP(-B1)-B1","v":1},null,"An illustration of reverse communication"]
[]
[null,null,null,"To avoid passing a function argument, the underlying NAG routine"]
[null,null,null,"is called repeatedly to take one step of the algorithm."]
[]
[null,null,null,"The user supplies the starting point in cell B1. Cell B2 contains the specification of the function."]
[null,null,null,"Between calls the algorithm sets the value of x until it reaches the solution."]
[null,null,null,"If no solution is found in the given interval, then a message is displayed."]
[]
[null,null,null,"NAG routine in use: C05AZF"]
[null,null,null,"Zero in interval [x, x+1] of continuous function by Brent algorithm (reverse communication)"]
[null,null,null,"Chapter C05 – Roots of One or More Transcendental Equations"]
[null,null,null,"Documentation:"]
[null,null,null,null,"https://www.nag.com/numeric/nl/nagdoc_latest/flhtml/c05/c05azf.html"]
[]
[null,null,null,"For details please view the VBA code which consists of 2 modules:"]
[null,null,null,null,"Module \"Declarations_C05AZF\" contains declaration statements needed when using the NAG Library"]
[null,null,null,null,"Module \"RevComm\" contains subroutine that finds the zero of a function using the NAG Library"]