db3f3648-4291-44e3-bda7-8e70ababd778 12 2 5 decimal

&[DATE] &[TIME] - &[FILENAME]

EXCEL Goal Seek:

Set cell to value by changing a given cell, where:

- a# - initial guess

- n# - number of iterations

- p# - calculation precision; i.e. calculation is terminated when sought value does not change by more than $10^{-p#}*100%$

]]>

xlpath# xlsheet# SETCELL# TOVALUE# CHANGECELL# a# n# p# excel_GS XLGoalSeekCode### :

XLGoalSeekCode### x f# xlpath# xlsheet# CHANGECELL# x SETCELL# excel_IO eval 11 line : xi a# eval : xii 1.001 xi * eval : fi xi f# TOVALUE# - eval : fii xii f# TOVALUE# - eval : df fii fi - xii xi - / eval : i 1 n# range xii xi fi df / - eval : fii xii f# TOVALUE# - eval : df fii fi - xii xi - / eval : xii xi - xii / abs 10 p# -^< break if xi xii : fi fii : 61 line for xii 81 line :

path GSTEST.xlsx :

root_dir CurrentDirectory :

path root_dir path concat : C:\Users\almk\Documents\Work\HandyStuff\Smath\ExcelGoalSeek\GSTEST.xlsx

no path GSTEST B7 100030006031 mat eval excel_IN 1

path GSTEST J20 0 C18 10010007 excel_GS 529.97