mon tue wed thur fri
daily sales target: 2000.00 2500 1750
actual 1500 2750
as the figures are put in the actual line the progressive target autopopulates on the daily target line
have uploaded a sample via link above.
hello Flopcat, my idea is that the sales personnel can load their daily actuals in and the calculator then gives them the following days target according to what they have inserted. If the daily target is $2000 and the actual is $1500, then the next days target will be $2500, or if the actual is $2500 the next days target will be $1500.