The Siccness Network

Go Back   The Siccness Network > >

Open Forum Over a Million posts and counting!


User Tag List

Reply
 
Thread Tools
Old 08-11-2017, 11:33 AM   #1
Hood Rat Matt
aka Goodfella (since '02)
 
Hood Rat Matt's Avatar
 
Join Date: Oct 2009
Location: East Oakland (Hills)
Posts: 2,398
Propped 7,191 Times in 2,171 Posts
Question Could use help in Excel (creating a pivot table)

Ok I'm really bad with Microsoft Excel. I am trying to create a pivot table to analyze a group of aircraft and determine whether or not they've had their proper scheduled maintenance checks based on their date of manufacture. For those of you who are familiar with pivot tables, can you please help me? These are the fields I need to include (i just don't know where to put what):
MSN (Manufacturer Serial Number)
DOM (Date of Manufacture)
Aircraft Type (Boeing or Airbus)
SV (Shop Visit...Boeings go for 8, 10 and 12 year checks..while Airbus only has a 6 and 12 year visit
I already have a nicely formatted worksheet...I just need to make the pivot table that shows which aircraft have had their visits and which are overdue and for what kind of check.

I know you're not getting paid to do my job, but I figure lots of you guys are way smarter than I am, so it shouldn't take a whole lot of time/brainpower for one of youse.

Thanks in advance!!
__________________
People who say they don't care what people think are usually desperate to have people think they don't care what people think.
Hood Rat Matt is offline   Reply With Quote
Old 08-11-2017, 11:40 AM   #2
infinity
( o )( o )
 
infinity's Avatar
 
Join Date: May 2005
Location: UOENO, CA
Posts: 8,448
Propped 35,231 Times in 19,521 Posts
Quote:
Quote Originally Posted by Hood Rat Matt View Post
Ok I'm really bad with Microsoft Excel. I am trying to create a pivot table to analyze a group of aircraft and determine whether or not they've had their proper scheduled maintenance checks based on their date of manufacture. For those of you who are familiar with pivot tables, can you please help me? These are the fields I need to include (i just don't know where to put what):
MSN (Manufacturer Serial Number)
DOM (Date of Manufacture)
Aircraft Type (Boeing or Airbus)
SV (Shop Visit...Boeings go for 8, 10 and 12 year checks..while Airbus only has a 6 and 12 year visit
I already have a nicely formatted worksheet...I just need to make the pivot table that shows which aircraft have had their visits and which are overdue and for what kind of check.

I know you're not getting paid to do my job, but I figure lots of you guys are way smarter than I am, so it shouldn't take a whole lot of time/brainpower for one of youse.

Thanks in advance!!
I'd recommend asking on reddit. You'll probably find a better & faster answer over there. Good luck

Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
infinity is offline   Reply With Quote
The Following Users Gave Props To infinity:
Old 08-11-2017, 11:55 AM   #3
Hood Rat Matt
aka Goodfella (since '02)
 
Hood Rat Matt's Avatar
 
Join Date: Oct 2009
Location: East Oakland (Hills)
Posts: 2,398
Propped 7,191 Times in 2,171 Posts
Thumbs up

Quote:
Quote Originally Posted by infinity View Post
I'd recommend asking on reddit. You'll probably find a better & faster answer over there. Good luck

Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
thanks bro...I just posted there
__________________
People who say they don't care what people think are usually desperate to have people think they don't care what people think.
Hood Rat Matt is offline   Reply With Quote
The Following Users Gave Props To Hood Rat Matt:
Old 08-11-2017, 04:22 PM   #4
lungsfull
Sicc OG
 
lungsfull's Avatar
 
Join Date: Jun 2014
Posts: 565
Propped 876 Times in 378 Posts
Quote:
Quote Originally Posted by Hood Rat Matt View Post
thanks bro...I just posted there

did u get it figured out?
lungsfull is offline   Reply With Quote
Old 08-11-2017, 05:06 PM   #5
Mac Jesus
Girls send me your nudes
 
Mac Jesus's Avatar
 
Join Date: May 2003
Posts: 2,379
Propped 31,394 Times in 11,217 Posts
I used to know how to use pivot tables but I tried looking at excel and I'm all confused. I forgot all that stuff since I don't use it anymore. It was like 2010 when I had to use that a lot and that shouldn't seem that long ago but it's like 7 years. I'm way to old.
__________________




Mac Jesus is offline   Reply With Quote
Old 08-11-2017, 05:23 PM   #6
StillHustlin
FROM DUSK TIL DAWN
 
StillHustlin's Avatar
 
Join Date: May 2013
Location: 33
Posts: 2,267
Propped 6,411 Times in 3,037 Posts
I use them often but this was hella lazy

PayPal me a hundo and I'll do it
StillHustlin is offline   Reply With Quote
Old 08-12-2017, 10:46 AM   #7
Hood Rat Matt
aka Goodfella (since '02)
 
Hood Rat Matt's Avatar
 
Join Date: Oct 2009
Location: East Oakland (Hills)
Posts: 2,398
Propped 7,191 Times in 2,171 Posts
Quote:
Quote Originally Posted by StillHustlin View Post
I use them often but this was hella lazy

PayPal me a hundo and I'll do it
lol I'd rather just learn how to do it. I've been playing around with the data and getting some good results. It's pretty straightforward I just need to slow my crazy brain down and focus. I get overwhelmed and then go full mixerr
__________________
People who say they don't care what people think are usually desperate to have people think they don't care what people think.
Hood Rat Matt is offline   Reply With Quote
Old 08-12-2017, 11:12 AM   #8
Banned!TA90011
Banned
 
TA90011's Avatar
 
Join Date: Apr 2016
Posts: 629
Propped 1,361 Times in 561 Posts
youtube
TA90011 is offline   Reply With Quote
Old 08-12-2017, 01:03 PM   #9
lungsfull
Sicc OG
 
lungsfull's Avatar
 
Join Date: Jun 2014
Posts: 565
Propped 876 Times in 378 Posts
Quote:
Quote Originally Posted by Hood Rat Matt View Post
lol I'd rather just learn how to do it. I've been playing around with the data and getting some good results. It's pretty straightforward I just need to slow my crazy brain down and focus. I get overwhelmed and then go full mixerr
heres the book i used from my excel class

Microsoft Excel 2013: Comprehensive - Steven M. Freund, Mali Jones, Joy L. Starks - Google Books

it might have pivot tables
lungsfull is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
OFF HIS PIVOT-DucefaceD DucefaceD B.A.R.T. 0 05-02-2017 02:51 PM
DucefaceD-Off His Pivot DucefaceD 9-1-Siccness 0 05-02-2017 09:57 AM
Starsky Ft Troy Ave - On My Pivot Gabe505 Hip-Hop Central 0 01-07-2014 02:21 PM
microsoft excel????? drunkaholic707 Open Forum 7 08-28-2006 03:43 PM
The Bernard Pivot Questionnaire - Inside the Actors Studio ColdBlooded Gathering of Minds 1 03-11-2003 09:25 PM




All times are GMT -8. The time now is 04:16 AM.


Powered by vBulletin
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Parts of this site powered by vBulletin Mods & Addons from DragonByte Technologies Ltd. (Details)
2017 Siccness Network. All rights reserved.
Back to Top