Welcome to the Second Life Forums Archive

These forums are CLOSED. Please visit the new forums HERE

Excel sales spreadsheet
Max Herzog
Cloudy
Join date: 9 Jul 2006
Posts: 1,073
08-12-2008 13:14
When you're done sorting Excel out, people, I have a major PowerPoint presentation that needs putting together. It must have all manner of fancy graphics, whooshing noises to accompany same, and frankly, I can't be arsed doing it myself. Someone here do it, please, and don't let me hear any complaints. Deadline is midnight SLT, so get cracking. And don't expect me to give any details, either. Some help forum this is.:mad:
_____________________
I do not like your tone. It has an ephemeral, whinging aspect.


Gratuitous Flickrage
http://www.flickr.com/photos/24213150@N04
Ordinal Malaprop
really very ordinary
Join date: 9 Sep 2005
Posts: 4,607
08-12-2008 13:15
_____________________
http://ordinalmalaprop.com/forum/ - visit Ordinal's Scripting Colloquium for scripting discussion with actual working BBCode!

http://ordinalmalaprop.com/engine/ - An Engine Fit For My Proceeding, my Aethernet Journal

http://www.flickr.com/groups/slgriefbuild/ - Second Life Griefbuild Digest, pictures of horrible ad griefing and land spam, and the naming of names
Amaranthim Talon
Voyager, Seeker, Curious
Join date: 14 Nov 2006
Posts: 12,032
08-12-2008 13:16
Trout and Max- I am taking up sculpty making so I might erect a suitable homage to your worthiness :)
_____________________
"Yield to temptation. It may not pass your way again. "
Robert A. Heinlein




http://talonfaire.blogspot.com/

Visit Talon Faire Main:
http://slurl.com/secondlife/Misto%20Presto/216/21/155- Main Store

XStreets: http://tinyurl.com/6r7ayn
Chris Norse
Loud Arrogant Redneck
Join date: 1 Oct 2006
Posts: 5,735
08-12-2008 13:16
From: Wildefire Walcott
I contacted Gary in-world and asked to take a look at his worksheet. We figured out the issue he was having with the Date column:




And Wildefire wins the interweb's Post of the Day.
_____________________
I'm going to pick a fight
William Wallace, Braveheart

“Rules are mostly made to be broken and are too often for the lazy to hide behind”
Douglas MacArthur

FULL
Max Herzog
Cloudy
Join date: 9 Jul 2006
Posts: 1,073
08-12-2008 13:16
From: Ordinal Malaprop


Brilliant.

Do you do PowerPoint presentations for ungrateful so-and-so's too?
_____________________
I do not like your tone. It has an ephemeral, whinging aspect.


Gratuitous Flickrage
http://www.flickr.com/photos/24213150@N04
Damien1 Thorne
Registered User
Join date: 26 Aug 2007
Posts: 4,877
08-12-2008 13:17
From: Amaranthim Talon
Ann- you and Cheery are up for canonization- I have packed my beaten up angel wings and halo and moved to the dark side- Damien (knock knock.. let me in please- I am feeling impish).

Come on dear, let's get out of this thread. ;) It's better on the dark side.
_____________________
As we fade into the darkness...
Cael Merryman
Brain in Neutral
Join date: 5 Dec 2007
Posts: 380
08-12-2008 13:17
From: Wildefire Walcott
I contacted Gary in-world and asked to take a look at his worksheet. We figured out the issue he was having with the Date column:



Hey, I'm sympathetic. When I was single and totalled the date column, it kept coming up zero.
Amaranthim Talon
Voyager, Seeker, Curious
Join date: 14 Nov 2006
Posts: 12,032
08-12-2008 13:17
/me starts an Ordinal Malaprop Fan Club
_____________________
"Yield to temptation. It may not pass your way again. "
Robert A. Heinlein




http://talonfaire.blogspot.com/

Visit Talon Faire Main:
http://slurl.com/secondlife/Misto%20Presto/216/21/155- Main Store

XStreets: http://tinyurl.com/6r7ayn
Amaranthim Talon
Voyager, Seeker, Curious
Join date: 14 Nov 2006
Posts: 12,032
08-12-2008 13:19
From: Damien1 Thorne
Come on dear, let's get out of this thread. ;) It's better on the dark side.

/me adjusts horns, straightens tail and joins the Dark One :) Yay - Happiness at last- being good is just not worth the effort :)
_____________________
"Yield to temptation. It may not pass your way again. "
Robert A. Heinlein




http://talonfaire.blogspot.com/

Visit Talon Faire Main:
http://slurl.com/secondlife/Misto%20Presto/216/21/155- Main Store

XStreets: http://tinyurl.com/6r7ayn
Cael Merryman
Brain in Neutral
Join date: 5 Dec 2007
Posts: 380
08-12-2008 13:20
From: Max Herzog
When you're done sorting Excel out, people, I have a major PowerPoint presentation that needs putting together. It must have all manner of fancy graphics, whooshing noises to accompany same, and frankly, I can't be arsed doing it myself. Someone here do it, please, and don't let me hear any complaints. Deadline is midnight SLT, so get cracking. And don't expect me to give any details, either. Some help forum this is.:mad:


I have a Powerpoint for yer...

Standard presentation, without the Italian modifications...

(Damn, there is no appropriate emoticon - are we in a PG area?)
Damien1 Thorne
Registered User
Join date: 26 Aug 2007
Posts: 4,877
08-12-2008 13:21
From: Max Herzog
When you're done sorting Excel out, people, I have a major PowerPoint presentation that needs putting together. It must have all manner of fancy graphics, whooshing noises to accompany same, and frankly, I can't be arsed doing it myself. Someone here do it, please, and don't let me hear any complaints. Deadline is midnight SLT, so get cracking. And don't expect me to give any details, either. Some help forum this is.:mad:

I'll do it for you, Max. Let's see... where are those pics from the nude beach?
_____________________
As we fade into the darkness...
Max Herzog
Cloudy
Join date: 9 Jul 2006
Posts: 1,073
08-12-2008 13:22
From: Cael Merryman
I have a Powerpoint for yer...

Standard presentation, without the Italian modifications...

(Damn, there is no appropriate emoticon - are we in a PG area?)


Can't say I appreciate your attitude, fella. Standard presentation? I want bells and whistles, damn it!
_____________________
I do not like your tone. It has an ephemeral, whinging aspect.


Gratuitous Flickrage
http://www.flickr.com/photos/24213150@N04
Pserendipity Daniels
Assume sarcasm as default
Join date: 21 Dec 2006
Posts: 8,839
08-12-2008 13:24
From: Max Herzog
Can't say I appreciate your attitude, fella. Standard presentation? I want bells and whistles, damn it!


Whoosh, whoosh!

Pep (Well you asked for whooshing noises before you asked for bells and whistles)
_____________________
Hypocrite lecteur, — mon semblable, — mon frère!
ConductorX Nieuport
NO LONGER RELEVANT
Join date: 29 Nov 2007
Posts: 86
08-12-2008 13:25
From: Gary Glimmer
I just get a blank square


You have to highlight the data that you want to chart.

If your square is blank then you didn't select any data to chart.

A month only has 31 days, at A1 put a 1 then down the page number cells until you get to the number of days you want to chart.

In the cell next to the day, put in the amount of the sale.

When it is all filled out Highlight both columns. Select Chart Wizard and follow the instructions to get the type of chart you want.

"CX" (Excel and MS-Access Programer)
_____________________
Ann Launay
Neko-licious™
Join date: 8 Aug 2006
Posts: 7,893
08-12-2008 13:26
zomg, pivot tables...I think someone made me do one of those once. :(

We're not talking about a huge amount of data here, though, especially if the OP tends to it every day or two, so I see no reason why the more basic approach wouldn't work. *shrug*
_____________________
~Now Trout Re-Re-Re-Certified!~
From: someone
I am bumping you to an 8.5 on the Official Trout Measuring Instrument of Sluttiness. You are an enigma - on the one hand a sweet, gentle, intelligent woman who we would like to wrap up in our arms and protect, and on the other, a temptress to whom we would like to do all sorts of unmentionable things.

Congratulations and shame on you! You are a bit of a slut.
Ordinal Malaprop
really very ordinary
Join date: 9 Sep 2005
Posts: 4,607
08-12-2008 13:32
From: Max Herzog
Brilliant.

Do you do PowerPoint presentations for ungrateful so-and-so's too?

I do.

http://www.slideshare.net/guestc0306a/how-not-to-get-help-with-a-technical-issue/
_____________________
http://ordinalmalaprop.com/forum/ - visit Ordinal's Scripting Colloquium for scripting discussion with actual working BBCode!

http://ordinalmalaprop.com/engine/ - An Engine Fit For My Proceeding, my Aethernet Journal

http://www.flickr.com/groups/slgriefbuild/ - Second Life Griefbuild Digest, pictures of horrible ad griefing and land spam, and the naming of names
Max Herzog
Cloudy
Join date: 9 Jul 2006
Posts: 1,073
08-12-2008 13:33
From: Ordinal Malaprop
I do.

http://www.slideshare.net/guestc0306a/how-not-to-get-help-with-a-technical-issue/


<Tumultuous applause>
_____________________
I do not like your tone. It has an ephemeral, whinging aspect.


Gratuitous Flickrage
http://www.flickr.com/photos/24213150@N04
Trout Recreant
Public Enemy No. 1
Join date: 24 Jul 2007
Posts: 4,873
08-12-2008 13:33
From: Amaranthim Talon
Trout and Max- I am taking up sculpty making so I might erect a suitable homage to your worthiness :)


Well, don't ask for help here! You know how we get.
_____________________
From: Jerboa Haystack

A Trout Rating (tm) is something to cherish. To flaunt and be proud of. It is something all women should aspire to obtain!
Cheree Bury
ChereeMotion Owner
Join date: 6 Jun 2007
Posts: 666
08-12-2008 13:35
From: Ann Launay
zomg, pivot tables...I think someone made me do one of those once. :(

We're not talking about a huge amount of data here, though, especially if the OP tends to it every day or two, so I see no reason why the more basic approach wouldn't work. *shrug*



I did mine for the last month and had over 900 sales. That is an average of 30 sales per day. Those need to be summed together per day. The easiest way to do that is to use either a PivotTable or a PivotChart. In this case, a PivotChart is called for. Once you get used to using these tools they are easy. It took me about two minutes to create the chart that the OP wants.
_____________________
Visit ChereeMotion - Life's Best Pinup Poses
http://slurl.com/secondlife/Wild%20Rice/38/230/51
3Ring Binder
always smile
Join date: 8 Mar 2007
Posts: 15,028
08-12-2008 13:38
From: Trout Recreant
Well, don't ask for help here! You know how we get.

HELP!
Ordinal Malaprop
really very ordinary
Join date: 9 Sep 2005
Posts: 4,607
08-12-2008 13:45
I dare say, by the way, that this is likely to be the most read thread ever in the history of the Aethernet with the title "Excel sales spreadsheet".
_____________________
http://ordinalmalaprop.com/forum/ - visit Ordinal's Scripting Colloquium for scripting discussion with actual working BBCode!

http://ordinalmalaprop.com/engine/ - An Engine Fit For My Proceeding, my Aethernet Journal

http://www.flickr.com/groups/slgriefbuild/ - Second Life Griefbuild Digest, pictures of horrible ad griefing and land spam, and the naming of names
Tex Nasworthy
Udder Disgrace
Join date: 2 Sep 2006
Posts: 1,330
08-12-2008 13:48
Only when an OP gets pissy does the true brilliance (and twisted sense of humor) of the RA forum regulars shine through.

No wonder I love it here! :)
_____________________
.

Forums Users Love Lustfully
Lindal Kidd
Dances With Noobs
Join date: 26 Jun 2007
Posts: 8,371
08-12-2008 13:49
GG (must stand for Grumpy Guy).

Pay attention.

1. Enter "DATE" in cell A1.
2. Enter "SALES" in cell A2
3. Enter the first day of the month in cell B1, under DATE
4. Highlight that cell
5. Drag the handle at the lower right corner of the cell downward. The column will auto-populate with succeeding dates. Stop at the last day of the month

6. Enter sales for each day in the SALES column.
7. Place cursor in the cell under the last entry in SALES. Click the Summation symbol (the capital Greek letter Sigma, looks like a funny E). Hit Return.

That's the data entry part. You can do it with an exported transaction history if you want.

Now the chart.

1. Highlight all the entries and the column headers by dragging the mouse over them. (Note: Don't select the Totals row. Stop at the last day of the month)
2. In the top menu row, select Insert/Chart
3. The first chart choice will probably be Column. Stick with that.
4. Hit NEXT three times, then FINISH.

You are done.

Can we all have cookies now?
_____________________
It's still My World and My Imagination! So there.
Lindal Kidd
Cristalle Karami
Lady of the House
Join date: 4 Dec 2006
Posts: 6,222
08-12-2008 13:51
Nice try, Lin, but he needs a pivot chart. I didn't know it off the top of my head but I would have figured it out by... reading the help.
_____________________
Affordable & beautiful apartments & homes starting at 150L/wk! Waterfront homes, 575L/wk & 300 prims!

House of Cristalle low prim prefabs: secondlife://Cristalle/111/60

http://cristalleproperties.info
http://careeningcristalle.blogspot.com - Careening, A SL Sailing Blog
Elora Lunasea
Mrs. Llama
Join date: 28 Aug 2007
Posts: 4,828
08-12-2008 13:53
You people are just too smart! Hehe


_____________________
eloralunasea.blogspot.com
Have you hugged a llama today?
1 2 3 4 5 6