Home | Community | Message Board


Magic-Mushrooms-Shop.com
Please support our sponsors.

Community >> The Pub

Welcome to the Shroomery Message Board! You are experiencing a small sample of what the site has to offer. Please login or register to post messages and view our exclusive members-only content. You'll gain access to additional forums, file attachments, board customizations, encrypted private messages, and much more!

Jump to first unread post. Pages: 1
Offlinedebianlinux
Myconerd - DBK
Male User Gallery

Folding@home Statistics
Registered: 12/09/02
Posts: 8,329
Loc: Over There
Last seen: 1 month, 21 days
Excel and Pivot Tables
    #4681976 - 09/19/05 03:04 PM (12 years, 9 months ago)

Anybody have any experience in this arena?
I want to arrange my data a certain way and I feel I'm close but I just can't get it to read my mind.

The idea is to have a master list like the one depicted that has entries for ~100 suites. Then, using that data, I want to generate a similar looking list that only displays the items assigned to a specific responsible party per suite.
Any suggestions?


Post Extras: Print Post  Remind Me! Notify Moderator
InvisibleCowgold
Bullshit

Folding@home Statistics
Registered: 04/04/05
Posts: 12,486
Loc: .
Re: Excel and Pivot Tables [Re: debianlinux]
    #4682014 - 09/19/05 03:14 PM (12 years, 9 months ago)

I'll play with it a lil bit and see what I can come up with... it'll be later today though.


Post Extras: Print Post  Remind Me! Notify Moderator
InvisibleKrishna
कृष्ण,LOL
 User Gallery

Registered: 05/08/03
Posts: 23,285
Loc: oakland
Re: Excel and Pivot Tables [Re: debianlinux]
    #4682179 - 09/19/05 03:46 PM (12 years, 9 months ago)

use mysql...


--------------------




Post Extras: Print Post  Remind Me! Notify Moderator
Offlinedebianlinux
Myconerd - DBK
Male User Gallery

Folding@home Statistics
Registered: 12/09/02
Posts: 8,329
Loc: Over There
Last seen: 1 month, 21 days
Re: Excel and Pivot Tables [Re: Krishna]
    #4683621 - 09/19/05 09:50 PM (12 years, 9 months ago)

my frontend to our SQL DB is Prolog running on a solitary Win2k Citrix server that is overloaded with users.

i managed to do it some time later...

unmerge the Suite# cells and fill the empty cells with repeating corresponding #s
Data -> Pivot Table
Select your dataset
create the new Pivot Table in a new worksheet
Once in Pivot view drag the 3 categories onto the Table
Here i just experimented with positioning the different categories on different areas of the Table. this is the part it took me forever to figure out how to do. i killed a bunch of time creating the table only to delete it to change the creation order to note how the different orientations affected the display. once i figured out that i could drag the categories around and watch the changes in "real time" i had it looking the way i wanted rather quickly. a few adjustments to the Table Options turned off the tally #s i didn't need. i'd post a pic but i'm on a linux laptop and the document doesn't display quite the same in OOo.

i've continued messing with Pivot Tables and have decided they are a damn cool way to manipulate .xls data.


Post Extras: Print Post  Remind Me! Notify Moderator
Jump to top. Pages: 1

Community >> The Pub

Similar ThreadsPosterViewsRepliesLast post
* excel help please
( 1 2 all )
LethalX5 1,448 31 09/11/05 01:08 PM
by InsatiableThirst
* This asshole table I served tonight got what they deserved.
( 1 2 3 4 5 6 7 all )
Maverick 7,501 131 06/11/08 09:09 AM
by WhiskeyClone
* A scientific expierement to determine if it is possible to "set dice" at a craps table
( 1 2 all )
ZippoZM 2,422 25 11/02/07 12:30 AM
by kake
* Kitchen Table... or Air Hockey Table? Red 910 3 10/03/04 10:38 PM
by joe666
* Woodsmiths: Table saw advice needed
( 1 2 all )
afoaf 1,990 20 07/06/05 06:55 PM
by afoaf
* 'ganging up' on a poker game/table ZippoZM 2,993 14 01/20/08 02:40 PM
by trepanib
* makin a beer pong table AliceDee 1,070 16 11/02/05 10:33 PM
by daimyo
* Sex on the pool table?
( 1 2 all )
ShroomGoddess 2,609 37 01/28/07 06:35 PM
by AJ4U

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: Entire Staff
435 topic views. 7 members, 59 guests and 15 web crawlers are browsing this forum.
[ Toggle Favorite | Print Topic | Stats ]
Search this thread:
Everything Mushrooms
Please support our sponsors.

Copyright 1997-2018 Mind Media. Some rights reserved.

Generated in 0.033 seconds spending 0.013 seconds on 19 queries.