pancakes

MicrostockGroup Sponsors


Author Topic: My small gift to you  (Read 4899 times)

0 Members and 1 Guest are viewing this topic.

« on: January 14, 2011, 18:01 »
0
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.
« Last Edit: January 14, 2011, 18:15 by Suljo »


« Reply #1 on: January 14, 2011, 18:25 »
0
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.
Aww, i know its little to zero comforting but im your fan!  You have your very own 'expressive' style which always makes me laugh (take that as a compliment please).

Thanks for this present, im checking it out.  :)
(i think re-quoting your post entirely would be useless, the ones having you on ignore probably wont check this thread anyway and the ones who do check will see whats under the 'show' button)

grp_photo

« Reply #2 on: January 14, 2011, 18:53 »
0
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 :-)


 

Related Topics

  Subject / Started by Replies Last post
25 Replies
6336 Views
Last post September 26, 2009, 18:29
by Dan
8 Replies
3775 Views
Last post January 01, 2010, 14:28
by Kngkyle
27 Replies
12918 Views
Last post December 16, 2010, 18:58
by cathyslife
30 Replies
6271 Views
Last post January 03, 2015, 12:59
by fmarsicano
21 Replies
5636 Views
Last post January 31, 2017, 08:50
by photog-teo

Sponsors

Microstock Poll Results