Hi everyone,
My Question is Mainly Directed at Nick Koutras or an Excel VBA Programmer. Is it Possible to Create a Macro in Excel that Calculates the Statistics for a Wheel like Covermaster does please. Maybe there could be a Box that Appears so you can Enter the Range ( for example "B3:G50" ) that Accommodates the Wheel to be Tested. The Output for the Results will be something like ...
Matched Tested Covered
2 if 2 276 209
2 if 3 2,024 2,008
2 if 4 10,626 10,626
2 if 5 42,504 42,504
2 if 6 134,596 134,596
3 if 3 2,024 300
3 if 4 10,626 5,289
3 if 5 42,504 35,720
3 if 6 134,596 131,922
4 if 4 10,626 225
4 if 5 42,504 4,140
4 if 6 134,596 35,304
5 if 5 42,504 90
5 if 6 134,596 1,635
... and the Rest of the Statistical Information can then be Achieved using Excel Formulas.
Thanks in Advance.
All the Best.
PAB
My Question is Mainly Directed at Nick Koutras or an Excel VBA Programmer. Is it Possible to Create a Macro in Excel that Calculates the Statistics for a Wheel like Covermaster does please. Maybe there could be a Box that Appears so you can Enter the Range ( for example "B3:G50" ) that Accommodates the Wheel to be Tested. The Output for the Results will be something like ...
Matched Tested Covered
2 if 2 276 209
2 if 3 2,024 2,008
2 if 4 10,626 10,626
2 if 5 42,504 42,504
2 if 6 134,596 134,596
3 if 3 2,024 300
3 if 4 10,626 5,289
3 if 5 42,504 35,720
3 if 6 134,596 131,922
4 if 4 10,626 225
4 if 5 42,504 4,140
4 if 6 134,596 35,304
5 if 5 42,504 90
5 if 6 134,596 1,635
... and the Rest of the Statistical Information can then be Achieved using Excel Formulas.
Thanks in Advance.
All the Best.
PAB