Callout: Nostrum
 

http://i.imgur.com/pyziZfz.jpg

:smug:

:myeyesbleed: jfc amateur hour

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

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

:frog: the other things are the hallmark of the desperately unlearned


I need OP8 to weigh in here :coffee:

Trap sprung

You know I thought it was suspicious they didn't mention merging.

I've always been displeased with the aesthetics of pivot tables

Nostrumsay: my pivot tables brings all the boys to the yard

Imp verified

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

:gun:

:lippy:

What's wrong with column coloring or coloring subtotals? :dunno:

:ohdear:

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)

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

^ pre-coffee btw

But I like a little "pop" and "pizzazz" in my spreadsheets. :colbert:



:teef:

...figures...

:lust:

:awesome:

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 mega-nerd spotted ITT

Hey nostrum



How do you feel about lots of formulas in your spreadsheets? :giddy:

Hawt

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

:style:

I thought I was being artsy, the nerds could care less if font ranged from pink to chartreuse with and olive drab background

:ohmy:

Good god nonscience data ina spreadsheet makes my butthole pucker

your displeasure gave you away :bili:

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 :stuckup: