Hi all,
I have the following table (Input) as an example:
| a | b | c | d | e | f | h | i |
| 1 | 6 | 0 | 1,1 | 2,1 | 0 | 0 | 9 |
| 2 | 0 | 0 | 2,3 | 3,2 | 1 | 29 | 5,8 |
| 3 | 0 | 0 | 3,4 | 4,3 | 0 | 1,25 | 0 |
| 4 | 0 | 0 | 4,5 | 5,4 | 0 | 3,33 | 0 |
| 5 | 0 | 0 | 5,6 | 6,5 | 1 | 0 | 2,43 |
| 6 | 0 | 1 | 6,7 | 7,6 | 0 | 0 | 24,56 |
| 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Desired intermediate output (Table):
respecting those formula:
j=m*c (m: entered value from the user with an input box)
k=n*d (n: entered value from the user with an input box)
l=e
vMAX=MAX(j,k,l)
respecting this formula, desired first output looks like:
P[i][t]=(vMax*t-x)(1-f)+(((t-(1/vMax))/o)+1)*f // x=0 if t=o else x=0,001
| i/t | 1 | 2 | 3 | 4 | 5 | 6 | ... | o |
| 1 | P[1][1] | | | | | | | |
| 2 | | | | | | | | |
| 3 | | | | | | | | |
| 4 | | | | | | | P[i][t] | |
| 5 | | | | | | | | |
| 6 | | | | | | | | P[6][o] |
respecting to this formula, second desired output looks like:
| q |
| SUM(h*Transpose(P[1][t]) |
| |
| |
| |
| |
| SUM(h*Transpose(P[6][t]) |
Any Help please?
Thanks in advance
