PAGE 1 FOR USER 1

My Requirement is as belowed

user 1 just go to the form and just fillin the number for year 1until year 4 and total for instance
User 1 will have the form as belowed

user1

year 1   

year 2

year 3

year 4

year 4

 

year 1

A    

B

C

D

E

F

Total E

year 2

 

A    

B

C

D

E

F

Total E

year 3

 

A    

B

C

D

E

F

Total E

 

year 4

 

A    

B

C

D

E

F

Total E

 

 

 

 

 

when user click submit the figure will be displayed at the form belowed on the result page

 

user 2 will be the same way as user 1

RESULT PAGE PAGE 2

 
 

 

user year 1 year 2 year 3 year 4 Total
user 1 95 54 65 87 301
user 2 74 45 47 68 234
user 3 184 116 108 124 532
user 4 137 103 93 107 440
user 5 315 193 159 63 730
user 6 269 226 204 59 758
user 7 645 396 495 207 1,743
user 8 345 210 110 42 707
user 9 38 18 12 9 77
Total 2,102 1,361 1,293 766 5,522
 
 

year 1
User A B C D E F Total
user 1 33 48 4 2 1 7 95
user2 18 56 - - - - 74
user3 43 26 70 9 - 36 184
user4 45 32 45 4 - 11 137
user 5 86 96 103 12 - 18 315
user6 30 11 149 26 1 52 269
user7 88 43 313 129 - 72 645
user 8 48 6 193 44 - 54 345
user 9 - - - 1 7 30 38
Total 391 318 877 227 9 280 2,102

year 2
User A B C D E F Total
user 1 33 48 4 2 1 7 95
user2 18 56 - - - - 74
user3 43 26 70 9 - 36 184
user4 45 32 45 4 - 11 137
user 5 86 96 103 12 - 18 315
user6 30 11 149 26 1 52 269
user7 88 43 313 129 - 72 645
user 8 48 6 193 44 - 54 345
user 9 - - - 1 7 30 38
Total 391 318 877 227 9 280 2,102

year 3
User A B C D E F Total
user 1 33 48 4 2 1 7 95
user2 18 56 - - - - 74
user3 43 26 70 9 - 36 184
user4 45 32 45 4 - 11 137
user 5 86 96 103 12 - 18 315
user6 30 11 149 26 1 52 269
user7 88 43 313 129 - 72 645
user 8 48 6 193 44 - 54 345
user 9 - - - 1 7 30 38
Total 391 318 877 227 9 280 2,102

year 4
User A B C D E F Total
user 1 33 48 4 2 1 7 95
user2 18 56 - - - - 74
user3 43 26 70 9 - 36 184
user4 45 32 45 4 - 11 137
user 5 86 96 103 12 - 18 315
user6 30 11 149 26 1 52 269
user7 88 43 313 129 - 72 645
user 8 48 6 193 44 - 54 345
user 9 - - - 1 7 30 38
Total 391 318 877 227 9 280 2,102
 
TOTAL ( Can you sum the total as above for total year 1 to year 4)
A B E %%% Total
C D
391x4 318x4 9x4 877x4 227x7 SUM ALL=2102x4