search

FocusedObjective / FocusedObjective.Resources

Various
706 stars 140 forks source link

Request: no more IFNA #36

Closed lunivore closed 7 years ago

lunivore commented 7 years ago

Hi Troy, the IFNA formula (Montecarlo sheet column B, "Throughput Forecaster") isn't supported by older versions of Excel, so it results in a #NAME error. Any chance we can get rid of it and use something else, since it's the only thing causing an issue? I am happy to test and have an Office & Business version of Excel 2010.

FocusedObjective commented 7 years ago

OK. I've made fix I think. Apologies, sometimes i get a rush of blood and use a newer formula.

If you could give it a check i'd appreciate it.

https://github.com/FocusedObjective/FocusedObjective.Resources/blob/master/Spreadsheets/Throughput%20Forecaster.xlsx

lunivore commented 7 years ago

Fantastic, that works! Thanks Troy!