Links
Portal |  Forum | Core Values | 
MindRomp Forum  

FAQ Janitors Arcade
Go Back   MindRomp Forum > Community > Rompus Room

Rompus Room Bring all your toys to share

Reply
 
Thread Tools Display Modes
Old 9th September 2015, 12:58 AM   #285477  /  #1
Majiffy
I'll have you know I'm popular on many web forums
 
Majiffy's Avatar
 

Read my posts with the following stupid accent: Buffalo, NY
Callout: Nostrum





Spoiler
__________________
Herpy derpy jerfy!


ʘᴥʘ
pledged my daily allegiance to Satan and pear-shaped air hockey turntable earth
Vivere diu rebellionus!

Proud propagator of the "fire for warmth" myth
Majiffy is offline   Reply With Quote topbottom
Yay from
Adenosine (9th September 2015), SR71 (7th November 2015)
Old 9th September 2015, 01:02 AM   #285478  /  #2
nostrum
too boring to be considered weird
 
nostrum's Avatar
 

jfc amateur hour

ffs it's INDEX and not VLOOKUP (as vlookup is a weaksauce spreadsheet-bloating function)

if you need to told to use a pivot table the IT people should come and quietly uninstall Excel before you do more damage

the other things are the hallmark of the desperately unlearned


I need OP8 to weigh in here

Spoiler
__________________
I thought I was in a bad mood but it's been a few years so I think this is who I am now
nostrum is offline   Reply With Quote topbottom
Yay from
Adenosine (9th September 2015), borealis (9th September 2015), ffejrxx (12th June 2018), Majiffy (9th September 2015), SR71 (7th November 2015), Supernaut (6th April 2018)
Old 9th September 2015, 01:03 AM   #285479  /  #3
OmicronPersei8
Declared candidate for Best Poster 2017 of the fuckin decade
 
OmicronPersei8's Avatar
 

Read my posts with the following stupid accent: Gib's
Trap sprung
__________________
I am Lrrr, ruler of the planet OmicronPersei8.

Jerome: My mistake.
OmicronPersei8 is offline   Reply With Quote topbottom
Yay from
Adenosine (9th September 2015), borealis (9th September 2015), Majiffy (9th September 2015), nostrum (9th September 2015)
Old 9th September 2015, 01:03 AM   #285480  /  #4
Majiffy
I'll have you know I'm popular on many web forums
 
Majiffy's Avatar
 

Read my posts with the following stupid accent: Buffalo, NY
You know I thought it was suspicious they didn't mention merging.
__________________
Herpy derpy jerfy!


ʘᴥʘ
pledged my daily allegiance to Satan and pear-shaped air hockey turntable earth
Vivere diu rebellionus!

Proud propagator of the "fire for warmth" myth
Majiffy is offline   Reply With Quote topbottom
Old 9th September 2015, 01:04 AM   #285482  /  #5
OmicronPersei8
Declared candidate for Best Poster 2017 of the fuckin decade
 
OmicronPersei8's Avatar
 

Read my posts with the following stupid accent: Gib's
I've always been displeased with the aesthetics of pivot tables
__________________
I am Lrrr, ruler of the planet OmicronPersei8.

Jerome: My mistake.
OmicronPersei8 is offline   Reply With Quote topbottom
Yay from
nostrum (9th September 2015)
Old 9th September 2015, 01:06 AM   #285483  /  #6
OmicronPersei8
Declared candidate for Best Poster 2017 of the fuckin decade
 
OmicronPersei8's Avatar
 

Read my posts with the following stupid accent: Gib's
Nostrumsay: my pivot tables brings all the boys to the yard
__________________
I am Lrrr, ruler of the planet OmicronPersei8.

Jerome: My mistake.
OmicronPersei8 is offline   Reply With Quote topbottom
Yay from
Adenosine (9th September 2015), borealis (9th September 2015), Majiffy (9th September 2015), nostrum (9th September 2015)
Old 9th September 2015, 01:06 AM   #285484  /  #7
OmicronPersei8
Declared candidate for Best Poster 2017 of the fuckin decade
 
OmicronPersei8's Avatar
 

Read my posts with the following stupid accent: Gib's
Imp verified
__________________
I am Lrrr, ruler of the planet OmicronPersei8.

Jerome: My mistake.
OmicronPersei8 is offline   Reply With Quote topbottom
Yay from
Majiffy (9th September 2015)
Old 9th September 2015, 01:07 AM   #285485  /  #8
nostrum
too boring to be considered weird
 
nostrum's Avatar
 

yes, PT's are awful-looking

the posers here colour all the sub-totals and put in column colouring as well as selecting the most eye-offending theme for the overall table

I mean, my ex-mgr managed to get a spreadsheet to have > 65000 different styles which causes file corruption

__________________
I thought I was in a bad mood but it's been a few years so I think this is who I am now
nostrum is offline   Reply With Quote topbottom
Old 9th September 2015, 01:07 AM   #285486  /  #9
nostrum
too boring to be considered weird
 
nostrum's Avatar
 

Quote:
Originally Posted by OmicronPersei8 View Post
Nostrumsay: my pivot tables brings all the boys to the yard
__________________
I thought I was in a bad mood but it's been a few years so I think this is who I am now
nostrum is offline   Reply With Quote topbottom
Old 9th September 2015, 01:09 AM   #285488  /  #10
Majiffy
I'll have you know I'm popular on many web forums
 
Majiffy's Avatar
 

Read my posts with the following stupid accent: Buffalo, NY
Quote:
Originally Posted by nostrum View Post
the posers here colour all the sub-totals and put in column colouring as well as selecting the most eye-offending theme for the overall table
What's wrong with column coloring or coloring subtotals?
__________________
Herpy derpy jerfy!


ʘᴥʘ
pledged my daily allegiance to Satan and pear-shaped air hockey turntable earth
Vivere diu rebellionus!

Proud propagator of the "fire for warmth" myth
Majiffy is offline   Reply With Quote topbottom
Old 9th September 2015, 01:09 AM   #285489  /  #11
nostrum
too boring to be considered weird
 
nostrum's Avatar
 

Quote:
Originally Posted by OmicronPersei8 View Post
Imp verified


shhh he's asleep and hopefully this thread will fall off the front page of New Posts (seeing as this is such a busy forum)
__________________
I thought I was in a bad mood but it's been a few years so I think this is who I am now
nostrum is offline   Reply With Quote topbottom
Yay from
Majiffy (9th September 2015)
Old 9th September 2015, 01:10 AM   #285490  /  #12
nostrum
too boring to be considered weird
 
nostrum's Avatar
 

Quote:
Originally Posted by Majiffy View Post
Quote:
Originally Posted by nostrum View Post
the posers here colour all the sub-totals and put in column colouring as well as selecting the most eye-offending theme for the overall table
What's wrong with column coloring or coloring subtotals?
why the fuck do you need to slap the eyeballs? People who can read pivot tables (thus the only ones who should be creating them or be the audience for them) are just put off by the puffery
__________________
I thought I was in a bad mood but it's been a few years so I think this is who I am now
nostrum is offline   Reply With Quote topbottom
Old 9th September 2015, 01:10 AM   #285491  /  #13
nostrum
too boring to be considered weird
 
nostrum's Avatar
 

^ pre-coffee btw
__________________
I thought I was in a bad mood but it's been a few years so I think this is who I am now
nostrum is offline   Reply With Quote topbottom
Yay from
borealis (9th September 2015)
Old 9th September 2015, 01:11 AM   #285492  /  #14
Majiffy
I'll have you know I'm popular on many web forums
 
Majiffy's Avatar
 

Read my posts with the following stupid accent: Buffalo, NY
Quote:
Originally Posted by nostrum View Post
Quote:
Originally Posted by Majiffy View Post
Quote:
Originally Posted by nostrum View Post
the posers here colour all the sub-totals and put in column colouring as well as selecting the most eye-offending theme for the overall table
What's wrong with column coloring or coloring subtotals?
why the fuck do you need to slap the eyeballs? People who can read pivot tables (thus the only ones who should be creating them or be the audience for them) are just put off by the puffery
But I like a little "pop" and "pizzazz" in my spreadsheets.



__________________
Herpy derpy jerfy!


ʘᴥʘ
pledged my daily allegiance to Satan and pear-shaped air hockey turntable earth
Vivere diu rebellionus!

Proud propagator of the "fire for warmth" myth
Majiffy is offline   Reply With Quote topbottom
Yay from
nostrum (9th September 2015)
Old 9th September 2015, 01:12 AM   #285493  /  #15
nostrum
too boring to be considered weird
 
nostrum's Avatar
 

...figures...

__________________
I thought I was in a bad mood but it's been a few years so I think this is who I am now
nostrum is offline   Reply With Quote topbottom
Old 9th September 2015, 01:12 AM   #285494  /  #16
Majiffy
I'll have you know I'm popular on many web forums
 
Majiffy's Avatar
 

Read my posts with the following stupid accent: Buffalo, NY
__________________
Herpy derpy jerfy!


ʘᴥʘ
pledged my daily allegiance to Satan and pear-shaped air hockey turntable earth
Vivere diu rebellionus!

Proud propagator of the "fire for warmth" myth
Majiffy is offline   Reply With Quote topbottom
Old 9th September 2015, 01:14 AM   #285498  /  #17
nostrum
too boring to be considered weird
 
nostrum's Avatar
 

Quote:
Originally Posted by OmicronPersei8 View Post
I've always been displeased with the aesthetics of pivot tables
r: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; } table.sample td { border-width: 1px 1px 1px 1px; padding: 1px 1px 1px 1px; border-style: inset inset inset inset; border-color: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; }
Tagmega-nerd spotted ITT
__________________
I thought I was in a bad mood but it's been a few years so I think this is who I am now
nostrum is offline   Reply With Quote topbottom
Old 9th September 2015, 01:19 AM   #285500  /  #18
Majiffy
I'll have you know I'm popular on many web forums
 
Majiffy's Avatar
 

Read my posts with the following stupid accent: Buffalo, NY
Hey nostrum



How do you feel about lots of formulas in your spreadsheets?
__________________
Herpy derpy jerfy!


ʘᴥʘ
pledged my daily allegiance to Satan and pear-shaped air hockey turntable earth
Vivere diu rebellionus!

Proud propagator of the "fire for warmth" myth
Majiffy is offline   Reply With Quote topbottom
Old 9th September 2015, 01:21 AM   #285504  /  #19
OmicronPersei8
Declared candidate for Best Poster 2017 of the fuckin decade
 
OmicronPersei8's Avatar
 

Read my posts with the following stupid accent: Gib's
Hawt
__________________
I am Lrrr, ruler of the planet OmicronPersei8.

Jerome: My mistake.
OmicronPersei8 is offline   Reply With Quote topbottom
Yay from
nostrum (9th September 2015)
Old 9th September 2015, 01:22 AM   #285506  /  #20
nostrum
too boring to be considered weird
 
nostrum's Avatar
 

r: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; } table.sample td { border-width: 1px 1px 1px 1px; padding: 1px 1px 1px 1px; border-style: inset inset inset inset; border-color: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; }
Tag=IFERROR(IF(OR([@recruit]="y",VALUE(MID([@[CSOF_Y0]],5,1))>7),[@[CSOF_Y0]], INDEX(salary[For step or reclass],MATCH("step"&[@[CSOF_Y0]],salary[inc lookup],0),)),[@[CSOF_Y0]])


r: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; } table.sample td { border-width: 1px 1px 1px 1px; padding: 1px 1px 1px 1px; border-style: inset inset inset inset; border-color: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; }
Tag=SUM(INDEX((stafflist[Program]=D$8)*(stafflist[Y0$]),0))+SUM(INDEX((stafflist[Program]=D$8)*(LEFT(stafflist[EmpGroup],4)="Inde")*(stafflist[FY term]="Y0")*(stafflist[Term$]),0))-SUM(INDEX((stafflist[Program]=D$8)*(stafflist[FY commenced]="Y0")*(stafflist[Recruit$]),0))-SUM(INDEX((stafflist[Program]=D$8)*(stafflist[term ext end]="Y0")*(stafflist[term ext $]),0))


and these are just a couple of ones in a little old something I am updating right now

__________________
I thought I was in a bad mood but it's been a few years so I think this is who I am now
nostrum is offline   Reply With Quote topbottom
Old 9th September 2015, 01:23 AM   #285508  /  #21
OmicronPersei8
Declared candidate for Best Poster 2017 of the fuckin decade
 
OmicronPersei8's Avatar
 

Read my posts with the following stupid accent: Gib's
Quote:
Originally Posted by nostrum View Post
Quote:
Originally Posted by OmicronPersei8 View Post
I've always been displeased with the aesthetics of pivot tables
r: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; } table.sample td { border-width: 1px 1px 1px 1px; padding: 1px 1px 1px 1px; border-style: inset inset inset inset; border-color: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; }
Tagmega-nerd spotted ITT

I thought I was being artsy, the nerds could care less if font ranged from pink to chartreuse with and olive drab background
__________________
I am Lrrr, ruler of the planet OmicronPersei8.

Jerome: My mistake.
OmicronPersei8 is offline   Reply With Quote topbottom
Yay from
Majiffy (9th September 2015)
Old 9th September 2015, 01:24 AM   #285509  /  #22
nostrum
too boring to be considered weird
 
nostrum's Avatar
 

Quote:
Originally Posted by OmicronPersei8 View Post
Hawt


Spoiler
:nostrum:
__________________
I thought I was in a bad mood but it's been a few years so I think this is who I am now
nostrum is offline   Reply With Quote topbottom
Old 9th September 2015, 01:24 AM   #285510  /  #23
OmicronPersei8
Declared candidate for Best Poster 2017 of the fuckin decade
 
OmicronPersei8's Avatar
 

Read my posts with the following stupid accent: Gib's
Quote:
Originally Posted by nostrum View Post
r: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; } table.sample td { border-width: 1px 1px 1px 1px; padding: 1px 1px 1px 1px; border-style: inset inset inset inset; border-color: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; }
Tag=IFERROR(IF(OR([@recruit]="y",VALUE(MID([@[CSOF_Y0]],5,1))>7),[@[CSOF_Y0]], INDEX(salary[For step or reclass],MATCH("step"&[@[CSOF_Y0]],salary[inc lookup],0),)),[@[CSOF_Y0]])


r: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; } table.sample td { border-width: 1px 1px 1px 1px; padding: 1px 1px 1px 1px; border-style: inset inset inset inset; border-color: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; }
Tag=SUM(INDEX((stafflist[Program]=D$8)*(stafflist[Y0$]),0))+SUM(INDEX((stafflist[Program]=D$8)*(LEFT(stafflist[EmpGroup],4)="Inde")*(stafflist[FY term]="Y0")*(stafflist[Term$]),0))-SUM(INDEX((stafflist[Program]=D$8)*(stafflist[FY commenced]="Y0")*(stafflist[Recruit$]),0))-SUM(INDEX((stafflist[Program]=D$8)*(stafflist[term ext end]="Y0")*(stafflist[term ext $]),0))


and these are just a couple of ones in a little old something I am updating right now

Good god nonscience data ina spreadsheet makes my butthole pucker
__________________
I am Lrrr, ruler of the planet OmicronPersei8.

Jerome: My mistake.
OmicronPersei8 is offline   Reply With Quote topbottom
Yay from
nostrum (9th September 2015)
Old 9th September 2015, 01:25 AM   #285511  /  #24
nostrum
too boring to be considered weird
 
nostrum's Avatar
 

Quote:
Originally Posted by OmicronPersei8 View Post
Quote:
Originally Posted by nostrum View Post
Quote:
Originally Posted by OmicronPersei8 View Post
I've always been displeased with the aesthetics of pivot tables
r: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; } table.sample td { border-width: 1px 1px 1px 1px; padding: 1px 1px 1px 1px; border-style: inset inset inset inset; border-color: gray gray gray gray; -moz-border-radius: 0px 0px 0px 0px; }
Tagmega-nerd spotted ITT

I thought I was being artsy, the nerds could care less if font ranged from pink to chartreuse with and olive drab background
your displeasure gave you away
__________________
I thought I was in a bad mood but it's been a few years so I think this is who I am now
nostrum is offline   Reply With Quote topbottom
Old 9th September 2015, 01:27 AM   #285513  /  #25
nostrum
too boring to be considered weird
 
nostrum's Avatar
 

I have to confess that the google sheet that I have to work with for GMing with a known paid killer has formulae that even I find ugly
__________________
I thought I was in a bad mood but it's been a few years so I think this is who I am now
nostrum is offline   Reply With Quote topbottom
Reply

  MindRomp Forum > Community > Rompus Room

Tags
bishop with the nice red hat, penis, penis penis penis

Thread Tools
Display Modes

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 Thread Killed By
Battle Royale: Survival Kit Mafia [THIRD DAWN/ NIGHTFALL] Gonzo Mafia 707 26th July 2015 05:45 AM
Callout: Nostrum OmicronPersei8 Science and Information Technology 130 13th December 2014 11:02 PM
Robbery At The Casino! [Day 4 Deadline: 2 PM EST 8/19] Majiffy Mafia 229 20th August 2014 01:09 PM
Mafia Players in Cars Getting Coffee: Episode 4: nostrum spruce Mafia 7 8th August 2014 09:34 AM
CALLOUT: Nostrum the "smilie czar" Supernaut Rompus Room 16 19th January 2012 01:26 AM


All times are GMT +1. The time now is 05:47 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Copyright 2011-2018 MindRomp.org