Hi
As new year started I made my yearly graph for myself in MAC Numbers application (Mac version of Excell) which I want to share with you.

Normally it is nothing special. 2 tables with sums.
First bigger matrix will plot to you Sum of earnings months by months and show it in the left bottom graph and second is you earnings lest years.
Under agency 01 to 16 enter names of youre agencyes and earnings, under days enter the day of the month eg 14.
On the right bottom graph green bar is curently sum of earnings this year compared to last years.

Red bar has simple formula which I named Prediction.
Formula is Sum Current earning of this year by months / number of days x 365
which show you where are you from youre desired earnings at the end of this year.

Again
it is made in Mac Numbers application and it will look like on preview jpg file if you open it in Numbers. I upload as zip file exported excel version of file but when I opened in Open office it opens me as 3 spread sheet. I don have excel so I dont know how it looks like in that.

Excel or Numbers masters PLS tell me you opinions how I can upgrade this sheet in something more usefull.
For now I like watching how red bar is oscilating during day by daily earnings.

PLS Quote this post because I have been ignored by lots of members. OK mostly from godly scared Stokas excluzives and few others before iStock mess how they pop out carrots from they ears to hear when I post something lets say usefull.

Hi
As new year started I made my yearly graph for myself in MAC Numbers application (Mac version of Excell) which I want to share with you.

Normally it is nothing special. 2 tables with sums.
First bigger matrix will plot to you Sum of earnings months by months and show it in the left bottom graph and second is you earnings lest years.
Under agency 01 to 16 enter names of youre agencyes and earnings, under days enter the day of the month eg 14.
On the right bottom graph green bar is curently sum of earnings this year compared to last years.

Red bar has simple formula which I named Prediction.
Formula is Sum Current earning of this year by months / number of days x 365
which show you where are you from youre desired earnings at the end of this year.

Again
it is made in Mac Numbers application and it will look like on preview jpg file if you open it in Numbers. I upload as zip file exported excel version of file but when I opened in Open office it opens me as 3 spread sheet. I don have excel so I dont know how it looks like in that.

Excel or Numbers masters PLS tell me you opinions how I can upgrade this sheet in something more usefull.
For now I like watching how red bar is oscilating during day by daily earnings.

PLS Quote this post because I have been ignored by lots of members. OK mostly from godly scared Stokas excluzives and few others before iStock mess how they pop out carrots from they ears to hear when I post something lets say usefull.

thanks :-)