"Crystall Ball" and "@Risk" Users using Gnumeric
- From: "Gideon Butalid" <gbutalid gmail com>
- To: gnumeric-list gnome org
- Subject: "Crystall Ball" and "@Risk" Users using Gnumeric
- Date: Fri, 27 Jul 2007 13:35:09 +0800
I am dual booting Ubuntu and Windows XP in my laptop. As an "analyst" I build my spreadsheet models (including random numbers) in Gnumeric in Ubuntu, then I revert back to Windows XP so I could run my model in Crystal Ball (Excel add-in). I was able to cope in a way that probability distributions of inputs and their correlations are embedded in the model--thus I can easily build a spreadsheet model in Gnumeric. The only use for Crystal Ball is for me to capture the distribution of the OUTPUT and study how it is distributed.
This is my question:
Is it possible to capture the set of outputs in a particular cell in Gnumeric, and study them later? For instance, a cell will generate a new output after I press F9 because a new set of random numbers are generated. Using the Gnumeric simulation tool will give the mean, variance etc, but I need the final outputs, that is output per trial, so I could study how they are distributed.
Thanks in advance.
--
gbutalid
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]