Theoretical Average Computation

**J-Roc** · 11-11-2009, 02:19 PM

I was hoping someone could help me with programming the functions to compute the following numbers.

Please see attached PDF file to see table of what I am trying to get.

Many thanks in advance.

**shg** · 11-11-2009, 03:04 PM

If you want help with pictures or PDFs, post pictures or PDFs.

If you want help with workbook, please post workbooks.

Thanks.

**J-Roc** · 11-11-2009, 04:16 PM

Originally Posted by shg

If you want help with pictures or PDFs, post pictures or PDFs.

If you want help with workbook, please post workbooks.

Thanks.

I'm not sure what you mean. The attached PDF was just for purposes of showing a visual of the type of workbook I want to create and need help with.

Are you suggesting to post a workbook that reads the same way as the table I showed but without any function formulas? Please advise...

**jerger** · 11-11-2009, 04:18 PM

jroc...

please convert to an excel spread sheet. also explain what you are trying to average.

what do you mean by theoretical average? what columns/data is it averaging?

to many know what i'm sayings jroc
(sorry trailer park boys referance)

**smartcap72** · 11-11-2009, 08:09 PM

jroc...
I'm still working on this form, but at least the "Theoretical Average" column is complete. The cells highlighted with red borders are for user-entered data. The rest are formulas. Still working on formulas for the expectancy and avg points per contract closed. Any help would be appreciated.