Hi all,
I have problem and need your help.
i want to use Solver in Xcelsius, but i don’t know how to implement it.
please help me.
thanks.
Aan
aan99 (BOB member since 2011-07-16)
Solver is a type of add-on for Excel. It uses VBA forms and internal macros. Dashboards end up as SWF files, which is based on Actionscript3.
VBA does not port 100% into Actionscript. This is one reason you cannot use pivot tables in xcelsius, and some functions.
You can achieve the functionality of solver with the xcelisus what-if components, the most common being the slider, which can be interacted with to send real time variable values to a function you created in Excel.
Hard to say if your req’s will be met with the slider component, but thats as good as it will get. I know you can do some complex analysis with it, but you are limited (or not limited) by the depth of your Excel knowledge.
See the samples that come with xcelsius for a example file. (reading the help entry on sliders isnt a bad idea either)
Cairmor 
(BOB member since 2008-06-05)