Here's what I'm working on:
Time SVL% Number Number Good
500
530
600 100.00% 4 4
630 100.00% 15 15
700 100.00% 20 20
730 100.00% 32 32
800 100.00% 49 49
830 100.00% 49 49
900 100.00% 52 52
930 100.00% 71 71
1000 100.00% 53 53
1030 100.00% 60 60
1100 100.00% 54 54
1130 100.00% 63 63
1200 100.00% 74 74
1230 100.00% 75 75
1300 100.00% 68 68
1330 100.00% 80 80
1400 100.00% 77 77
1430 100.00% 81 81
1500 100.00% 74 74
1530 100.00% 80 80
1600 67.00% 68 46
1630 67.00% 64 43
1700 67.00% 68 45
1730 67.00% 56 37
1800 67.00% 48 32
1830 67.00% 45 30
1900 67.00% 31 20
1930 67.00% 25 17
2000 67.00% 27 18
2030 67.00% 21 14
2100 67.00% 16 11
2130 67.00% 18 12
2200 67.00% 10 7
2230 67.00% 1 0
2300 67.00% 0 0
2330 #DIV/0! 0 0
1617 1456 90.08%
GOAL 67.00%
What I need is for the GOAL # (Cell E41) to update automaticalyy so that the number directly above it (Cell E40) is exactly equal to 90%, or 95%, etc. With all of the other formulas and queries in this workbook, it takes it about 30 seconds to calculate per page. We also need to be able to change the "Goal" number so that we can evaulate different scenarios. .such as if Goal was 85%, what would the actual be at the end of the day? So. .a Macro would be happiest. I have looked and looked, and picked a few brains, and have not been able to come up with something that will easily preform this much needed time saving task! Any assistance that could be provided would be greatly appreciated!
Thank you!
Keely K.
Time SVL% Number Number Good
500
530
600 100.00% 4 4
630 100.00% 15 15
700 100.00% 20 20
730 100.00% 32 32
800 100.00% 49 49
830 100.00% 49 49
900 100.00% 52 52
930 100.00% 71 71
1000 100.00% 53 53
1030 100.00% 60 60
1100 100.00% 54 54
1130 100.00% 63 63
1200 100.00% 74 74
1230 100.00% 75 75
1300 100.00% 68 68
1330 100.00% 80 80
1400 100.00% 77 77
1430 100.00% 81 81
1500 100.00% 74 74
1530 100.00% 80 80
1600 67.00% 68 46
1630 67.00% 64 43
1700 67.00% 68 45
1730 67.00% 56 37
1800 67.00% 48 32
1830 67.00% 45 30
1900 67.00% 31 20
1930 67.00% 25 17
2000 67.00% 27 18
2030 67.00% 21 14
2100 67.00% 16 11
2130 67.00% 18 12
2200 67.00% 10 7
2230 67.00% 1 0
2300 67.00% 0 0
2330 #DIV/0! 0 0
1617 1456 90.08%
GOAL 67.00%
What I need is for the GOAL # (Cell E41) to update automaticalyy so that the number directly above it (Cell E40) is exactly equal to 90%, or 95%, etc. With all of the other formulas and queries in this workbook, it takes it about 30 seconds to calculate per page. We also need to be able to change the "Goal" number so that we can evaulate different scenarios. .such as if Goal was 85%, what would the actual be at the end of the day? So. .a Macro would be happiest. I have looked and looked, and picked a few brains, and have not been able to come up with something that will easily preform this much needed time saving task! Any assistance that could be provided would be greatly appreciated!
Thank you!
Keely K.