Author Topic: What's Bothering You? (The thread about what is bothering you.)  (Read 4982557 times)

tp4tissue and 16 Guests are viewing this topic.

Offline bcredbottle

  • Posts: 695
  • Location: Seattle, Washington
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10000 on: Mon, 23 November 2015, 19:12:37 »
omfg 10k time


EDIT: AHHAHAHA that's the second time I ring in a thread's 10k mark

More
10k replies!!!!!!!

 :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:    :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:    :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:
« Last Edit: Mon, 23 November 2015, 19:14:44 by bcredbottle »

Offline inanis

  • Truly Literally The Cloud
  • * Destiny Supporter
  • Posts: 790
  • Location: Dark Places
    • SEALWoodworking
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10001 on: Mon, 23 November 2015, 19:21:39 »
I have a feeling you don't need me for that! The ladies love demik.
( ͡° ͜ʖ ͡°)

they dont o͡͡͡╮༼ • ʖ̯ • ༽╭o͡͡͡
Then they're dumb.
Some hearts are gallows, I'm not here for hangin' around

Offline HoffmanMyster

  • HOFF, smol MAN OF MYSTERY
  • * Senior Moderator
  • Posts: 11539
  • Location: WI
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10002 on: Mon, 23 November 2015, 19:24:32 »
omfg 10k time


EDIT: AHHAHAHA that's the second time I ring in a thread's 10k mark

Don't make me remove your post.

I'll do it, man.  I'll do it.

Offline demik

  • Pronounced "demique"
  • Posts: 11159
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10003 on: Mon, 23 November 2015, 19:25:10 »
omfg 10k time


EDIT: AHHAHAHA that's the second time I ring in a thread's 10k mark

More
10k replies!!!!!!!

 :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:    :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:    :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:

u bastard.

CONGRATS.
No, he’s not around. How that sound to ya? Jot it down.

Offline njbair

  • Posts: 2825
  • Location: Cleveland, Ohio
  • I love the Powerglove. It's so bad.
    • nickbair.net
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10004 on: Mon, 23 November 2015, 19:35:30 »
omfg 10k time


EDIT: AHHAHAHA that's the second time I ring in a thread's 10k mark

More
10k replies!!!!!!!

 :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:    :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:    :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:   :llama:
Was expecting 10K llamas. Amateur.

Alpine Winter GB | My Personal TMK Firmware Repo
IBM Rubber Band "Floss" Mod | Click Modding Alps 101 | Flame-Polishing Cherry MX Stems
Review: hasu's USB to USB converter
My boards:
More
AEKII 60% | Alps64 HHKB | Ducky Shine 3, MX Blues | IBM Model M #1391401, Nov. 1990 | IBM SSK #1391472, Nov. 1987, screw modded, rubber-band modded | Noppoo EC108-Pro, 45g | Infinity 60% v2 Hacker, Matias Quiet Pros | Infinity 60% v2 Standard, MX Browns | Cherry G80-1800LPCEU-2, MX Blacks | Cherry G80-1813 (Dolch), MX Blues | Unicomp M-122, ANSI-modded | Unicomp M-122 (Unsaver mod in progress) | 2x Unitek K-258, White Alps | Apple boards (IIGS, AEKII) | Varmilo VA87MR, Gateron Blacks | Filco Zero TKL, Fukka White Alps | Planck, Gateron Browns | Monarch, click-modded Cream Alps

Offline demik

  • Pronounced "demique"
  • Posts: 11159
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10005 on: Mon, 23 November 2015, 19:39:51 »
I have a feeling you don't need me for that! The ladies love demik.
( ͡° ͜ʖ ͡°)

they dont o͡͡͡╮༼ • ʖ̯ • ༽╭o͡͡͡
Then they're dumb.

No, he’s not around. How that sound to ya? Jot it down.

Offline swimmingbird

  • * Elevated Elder
  • Posts: 2119
  • Location: Sydney, Australia
  • keyset hoarder
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10006 on: Mon, 23 November 2015, 20:01:45 »
Can not for the life of me figure out how to do this excel problem

If any of you are feeling generous here's a link to the problem
https://www.reddit.com/r/excel/comments/3u0ru7/how_to_count_and_sum_an_item_only_if_it_appears/

Offline Glenmael

  • Posts: 671
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10007 on: Mon, 23 November 2015, 20:23:13 »
Can not for the life of me figure out how to do this excel problem

If any of you are feeling generous here's a link to the problem
https://www.reddit.com/r/excel/comments/3u0ru7/how_to_count_and_sum_an_item_only_if_it_appears/

Sort by SKU and count pairs?

Offline swimmingbird

  • * Elevated Elder
  • Posts: 2119
  • Location: Sydney, Australia
  • keyset hoarder
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10008 on: Mon, 23 November 2015, 20:25:55 »

Can not for the life of me figure out how to do this excel problem

If any of you are feeling generous here's a link to the problem
https://www.reddit.com/r/excel/comments/3u0ru7/how_to_count_and_sum_an_item_only_if_it_appears/

Sort by SKU and count pairs?

Thanks for taking a look at it

I'll give this a shot when I get back from lunch bit daunting as I'll have to do this 17x(17-1)/2 times :/

Offline Glenmael

  • Posts: 671
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10009 on: Mon, 23 November 2015, 20:31:49 »

Can not for the life of me figure out how to do this excel problem

If any of you are feeling generous here's a link to the problem
https://www.reddit.com/r/excel/comments/3u0ru7/how_to_count_and_sum_an_item_only_if_it_appears/

Sort by SKU and count pairs?

Thanks for taking a look at it

I'll give this a shot when I get back from lunch bit daunting as I'll have to do this 17x(17-1)/2 times :/

Does your output need to look something like:
118179-0
« Last Edit: Mon, 23 November 2015, 20:37:44 by Glenmael »

Offline Glenmael

  • Posts: 671
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10010 on: Mon, 23 November 2015, 20:32:23 »
shut! double post.... :|

Offline beehatch

  • baehatch
  • * Exquisite Elder
  • Posts: 1811
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10011 on: Mon, 23 November 2015, 20:33:05 »
Naw, DMK jelly , he didn't get in on the internet flirt action.
(☞゚ヮ゚)☞
I have a feeling you don't need me for that! The ladies love demik.
( ͡° ͜ʖ ͡°)

they dont o͡͡͡╮༼ • ʖ̯ • ༽╭o͡͡͡

*****

Offline demik

  • Pronounced "demique"
  • Posts: 11159
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10012 on: Mon, 23 November 2015, 20:34:22 »
Naw, DMK jelly , he didn't get in on the internet flirt action.
(☞゚ヮ゚)☞
I have a feeling you don't need me for that! The ladies love demik.
( ͡° ͜ʖ ͡°)

they dont o͡͡͡╮༼ • ʖ̯ • ༽╭o͡͡͡

*****
bbbmmmmmmmmmm
No, he’s not around. How that sound to ya? Jot it down.

Offline swimmingbird

  • * Elevated Elder
  • Posts: 2119
  • Location: Sydney, Australia
  • keyset hoarder
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10013 on: Mon, 23 November 2015, 20:42:01 »


Can not for the life of me figure out how to do this excel problem

If any of you are feeling generous here's a link to the problem
https://www.reddit.com/r/excel/comments/3u0ru7/how_to_count_and_sum_an_item_only_if_it_appears/

Sort by SKU and count pairs?

Thanks for taking a look at it

I'll give this a shot when I get back from lunch bit daunting as I'll have to do this 17x(17-1)/2 times :/

Does your output need to look something like:
(Attachment Link)

Not exactly the numbers would ideally look like

France / Indonesia:

Number of shared skus / total skus

Shared sku revenue / total combined revenue

Offline Sent

  • Simplistic Serenity
  • * Exquisite Elder
  • Posts: 2141
  • Location: :thinking:
  • ¯\_(ツ)_/¯
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10014 on: Mon, 23 November 2015, 21:17:45 »
Hrrrm.. well do they know ur always ordering the latest hot electronics ?

They shouldn't but who knows. @__________@

Offline jbondeson

  • Posts: 470
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10015 on: Mon, 23 November 2015, 21:24:34 »

;___;

Show Image


Mine did that a while back. I wrapped in tape to "fix" it. Now it just sits in a drawer so i dont see it :|

Epoxy in the hole (the two part kind) and that sucker won't move again.

Offline swimmingbird

  • * Elevated Elder
  • Posts: 2119
  • Location: Sydney, Australia
  • keyset hoarder
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10016 on: Mon, 23 November 2015, 21:29:06 »

Can not for the life of me figure out how to do this excel problem

If any of you are feeling generous here's a link to the problem
https://www.reddit.com/r/excel/comments/3u0ru7/how_to_count_and_sum_an_item_only_if_it_appears/

Sort by SKU and count pairs?

Thanks for taking a look at it

I'll give this a shot when I get back from lunch bit daunting as I'll have to do this 17x(17-1)/2 times :/

Does your output need to look something like:
(Attachment Link)

Just figured it out dude

I know it has some redundancy but its pretty easy replicated

Pivot table with 2 countries selected on filter
skus as columns
sum of revenue as row
sum of gross margin as row
count of sku as row

Now anything that shows up as two is a shared SKU and just do sumifs off that :D

Your thinking lead me to the answer - thank you so much!  :D

Offline Glenmael

  • Posts: 671
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10017 on: Mon, 23 November 2015, 21:40:58 »

Can not for the life of me figure out how to do this excel problem

If any of you are feeling generous here's a link to the problem
https://www.reddit.com/r/excel/comments/3u0ru7/how_to_count_and_sum_an_item_only_if_it_appears/

Sort by SKU and count pairs?

Thanks for taking a look at it

I'll give this a shot when I get back from lunch bit daunting as I'll have to do this 17x(17-1)/2 times :/

Does your output need to look something like:
(Attachment Link)

Just figured it out dude

I know it has some redundancy but its pretty easy replicated

Pivot table with 2 countries selected on filter
skus as columns
sum of revenue as row
sum of gross margin as row
count of sku as row

Now anything that shows up as two is a shared SKU and just do sumifs off that :D

Your thinking lead me to the answer - thank you so much!  :D

No problems at all :D

That's exactly right, pivot tables are key, I just had a problem visualising what you were after :P

You can do some serious magic with sumifs, and a little bit of redundancy never hurt nobody!

Offline swimmingbird

  • * Elevated Elder
  • Posts: 2119
  • Location: Sydney, Australia
  • keyset hoarder
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10018 on: Mon, 23 November 2015, 22:50:30 »

Can not for the life of me figure out how to do this excel problem

If any of you are feeling generous here's a link to the problem
https://www.reddit.com/r/excel/comments/3u0ru7/how_to_count_and_sum_an_item_only_if_it_appears/

Sort by SKU and count pairs?

Thanks for taking a look at it

I'll give this a shot when I get back from lunch bit daunting as I'll have to do this 17x(17-1)/2 times :/

Does your output need to look something like:
(Attachment Link)

Just figured it out dude

I know it has some redundancy but its pretty easy replicated

Pivot table with 2 countries selected on filter
skus as columns
sum of revenue as row
sum of gross margin as row
count of sku as row

Now anything that shows up as two is a shared SKU and just do sumifs off that :D

Your thinking lead me to the answer - thank you so much!  :D

No problems at all :D

That's exactly right, pivot tables are key, I just had a problem visualising what you were after :P

You can do some serious magic with sumifs, and a little bit of redundancy never hurt nobody!

I love me some sumifs - I just wish that they built in other functions with if functions instead of me having to do array formulas

e.g. stdevIF

Offline Glenmael

  • Posts: 671
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10019 on: Mon, 23 November 2015, 22:52:49 »

Can not for the life of me figure out how to do this excel problem

If any of you are feeling generous here's a link to the problem
https://www.reddit.com/r/excel/comments/3u0ru7/how_to_count_and_sum_an_item_only_if_it_appears/

Sort by SKU and count pairs?

Thanks for taking a look at it

I'll give this a shot when I get back from lunch bit daunting as I'll have to do this 17x(17-1)/2 times :/

Does your output need to look something like:
(Attachment Link)

Just figured it out dude

I know it has some redundancy but its pretty easy replicated

Pivot table with 2 countries selected on filter
skus as columns
sum of revenue as row
sum of gross margin as row
count of sku as row

Now anything that shows up as two is a shared SKU and just do sumifs off that :D

Your thinking lead me to the answer - thank you so much!  :D

No problems at all :D

That's exactly right, pivot tables are key, I just had a problem visualising what you were after :P

You can do some serious magic with sumifs, and a little bit of redundancy never hurt nobody!

I love me some sumifs - I just wish that they built in other functions with if functions instead of me having to do array formulas

e.g. stdevIF

Haha tell me about it.

Ps. Grats on the 1k post wise elder :D

Offline swimmingbird

  • * Elevated Elder
  • Posts: 2119
  • Location: Sydney, Australia
  • keyset hoarder
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10020 on: Mon, 23 November 2015, 23:22:47 »

Can not for the life of me figure out how to do this excel problem

If any of you are feeling generous here's a link to the problem
https://www.reddit.com/r/excel/comments/3u0ru7/how_to_count_and_sum_an_item_only_if_it_appears/

Sort by SKU and count pairs?

Thanks for taking a look at it

I'll give this a shot when I get back from lunch bit daunting as I'll have to do this 17x(17-1)/2 times :/

Does your output need to look something like:
(Attachment Link)

Just figured it out dude

I know it has some redundancy but its pretty easy replicated

Pivot table with 2 countries selected on filter
skus as columns
sum of revenue as row
sum of gross margin as row
count of sku as row

Now anything that shows up as two is a shared SKU and just do sumifs off that :D

Your thinking lead me to the answer - thank you so much!  :D

No problems at all :D

That's exactly right, pivot tables are key, I just had a problem visualising what you were after :P

You can do some serious magic with sumifs, and a little bit of redundancy never hurt nobody!

I love me some sumifs - I just wish that they built in other functions with if functions instead of me having to do array formulas

e.g. stdevIF

Haha tell me about it.

Ps. Grats on the 1k post wise elder :D

Holy crap didn't even notice it I need to be more productive during working hours lol

Offline Glenmael

  • Posts: 671
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10021 on: Mon, 23 November 2015, 23:29:46 »
My cap came in today! So impressed with the quality and it looks awesome. Matching space invader is a nice touch :)

Show Image
Mine came in :D


Can not for the life of me figure out how to do this excel problem

If any of you are feeling generous here's a link to the problem
https://www.reddit.com/r/excel/comments/3u0ru7/how_to_count_and_sum_an_item_only_if_it_appears/

Sort by SKU and count pairs?

Thanks for taking a look at it

I'll give this a shot when I get back from lunch bit daunting as I'll have to do this 17x(17-1)/2 times :/

Does your output need to look something like:
(Attachment Link)

Just figured it out dude

I know it has some redundancy but its pretty easy replicated

Pivot table with 2 countries selected on filter
skus as columns
sum of revenue as row
sum of gross margin as row
count of sku as row

Now anything that shows up as two is a shared SKU and just do sumifs off that :D

Your thinking lead me to the answer - thank you so much!  :D

No problems at all :D

That's exactly right, pivot tables are key, I just had a problem visualising what you were after :P

You can do some serious magic with sumifs, and a little bit of redundancy never hurt nobody!

I love me some sumifs - I just wish that they built in other functions with if functions instead of me having to do array formulas

e.g. stdevIF

Haha tell me about it.

Ps. Grats on the 1k post wise elder :D

Holy crap didn't even notice it I need to be more productive during working hours lol

:D you get a star now ;)

Offline swimmingbird

  • * Elevated Elder
  • Posts: 2119
  • Location: Sydney, Australia
  • keyset hoarder
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10022 on: Tue, 24 November 2015, 05:03:58 »

:D you get a star now ;)

Just want one of these bad boys  :))

« Last Edit: Tue, 24 November 2015, 05:09:36 by swimmingbird »

Offline pr0ximity

  • Posts: 2708
  • Location: Maine
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10023 on: Tue, 24 November 2015, 06:10:50 »
Trading for some nice caps, found an amazing alternative but the person I'm already trading with has committed a lot so I can't back out.

I probably deserve this.
| Flickr | KMAC 1.2 | GON NeRD TKL | GSKT-00-Z | GSKT-00-AEK | GON NeRD 60 | Jane V2 CE | Whale | J80S | 356CL DGE | G80-5000 HAMDE | IBM 1390120 | IBM F AT | IBM F122 | IBM 3101 | Zenith Z-150

Offline HoffmanMyster

  • HOFF, smol MAN OF MYSTERY
  • * Senior Moderator
  • Posts: 11539
  • Location: WI
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10024 on: Tue, 24 November 2015, 07:43:04 »
No problems at all :D

That's exactly right, pivot tables are key, I just had a problem visualising what you were after :P

You can do some serious magic with sumifs, and a little bit of redundancy never hurt nobody!

I love me some sumifs - I just wish that they built in other functions with if functions instead of me having to do array formulas

e.g. stdevIF

Mmmmmmmm, sumifs...  ^-^

That, vlookup, index, and a few others are why my coworkers think I'm an Excel genius.  :))

Offline alienman82

  • * Elevated Elder
  • Posts: 4051
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10025 on: Tue, 24 November 2015, 08:21:09 »
removed.
« Last Edit: Thu, 01 March 2018, 16:55:39 by alienman82 »

Offline HoffmanMyster

  • HOFF, smol MAN OF MYSTERY
  • * Senior Moderator
  • Posts: 11539
  • Location: WI
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10026 on: Tue, 24 November 2015, 08:28:14 »
http://www.ebay.com/itm/WEY-Modular-Keyboard-WEYRAY-US-030B-WP-WEY-RAY-KYBD-0040-/151329423091?ssPageName=ADME:X:RTQ:US:1123

Seller will only go down to 350 and I can't find another one of these...  Plus the shipping price.  I wish it was $100 or so or less  :(

Whoa, that seems really expensive.  Did the price of these go up?

Offline alienman82

  • * Elevated Elder
  • Posts: 4051
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10027 on: Tue, 24 November 2015, 08:36:12 »
removed.
« Last Edit: Thu, 01 March 2018, 16:55:36 by alienman82 »

Offline alienman82

  • * Elevated Elder
  • Posts: 4051
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10028 on: Tue, 24 November 2015, 08:37:29 »
removed.
« Last Edit: Thu, 01 March 2018, 16:55:33 by alienman82 »

Offline HoffmanMyster

  • HOFF, smol MAN OF MYSTERY
  • * Senior Moderator
  • Posts: 11539
  • Location: WI
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10029 on: Tue, 24 November 2015, 08:42:10 »
http://www.ebay.com/itm/WEY-Modular-Keyboard-WEYRAY-US-030B-WP-WEY-RAY-KYBD-0040-/151329423091?ssPageName=ADME:X:RTQ:US:1123

Seller will only go down to 350 and I can't find another one of these...  Plus the shipping price.  I wish it was $100 or so or less  :(

Whoa, that seems really expensive.  Did the price of these go up?

From sold listings, there were a couple of non-hebrew legend ones that sold around 100.  Seller is a little unreasonable I think.

Ahhh, I missed the hebrew legends on this one.  :thumb:  That makes sense.  Cool board.  :D

Offline iri

  • Posts: 1031
  • Location: England
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10030 on: Tue, 24 November 2015, 08:44:03 »
wife found a giant house spider in a bath yesterday. it was at least 10cm in size.

(...)Whereas back then I wrote about the tyranny of the majority, today I'd combine that with the tyranny of the minorities. These days, you have to be careful of both. They both want to control you. The first group, by making you do the same thing over and over again. The second group is indicated by the letters I get from the Vassar girls who want me to put more women's lib in The Martian Chronicles, or from blacks who want more black people in Dandelion Wine.
I say to both bunches, Whether you're a majority or minority, bug off! To hell with anybody who wants to tell me what to write. Their society breaks down into subsections of minorities who then, in effect, burn books by banning them. All this political correctness that's rampant on campuses is b.s.

-Ray Bradbury

Offline jdcarpe

  • * Curator
  • Posts: 8852
  • Location: Odessa, TX
  • Live long, and prosper.
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10031 on: Tue, 24 November 2015, 08:45:18 »
wife found a giant house spider in a bath yesterday. it was at least 10cm in size.

(Attachment Link)

Nice! Did you give him a name?
KMAC :: LZ-GH :: WASD CODE :: WASD v2 :: GH60 :: Alps64 :: JD45 :: IBM Model M :: IBM 4704 "Pingmaster"

http://jd40.info :: http://jd45.info


in memoriam

"When I was a kid, I used to take things apart and never put them back together."

Offline ccarlitos2

  • Posts: 879
  • Location: Not in the Tardis
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10032 on: Tue, 24 November 2015, 08:49:55 »
wife found a giant house spider in a bath yesterday. it was at least 10cm in size.

(Attachment Link)

Looks like it should be pretty harmless. Do you have a picture of the dorsal view of the spider?
HHKB Pro 1| Poker 2(MX Browns)| Leopold FC200R (MX Blue)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Yup, that tasted purple" -Lulu

Flickr: https://www.flickr.com/photos/138889771@N05/

Offline Computer-Lab in Basement

  • The needs of the many outweigh the needs of the few.
  • * Elevated Elder
  • Posts: 3026
  • Location: NCC-1701, USS Enterprise
  • Live long and prosper
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10033 on: Tue, 24 November 2015, 08:52:09 »
wife found a giant house spider in a bath yesterday. it was at least 10cm in size.

(Attachment Link)

tp thread is tp thread
Sometimes it's like he accidentally makes a thread instead of a google search.

IBM Model M SSK | IBM Model F XT | IBM Model F 122 | IBM Model M 122 | Ducky YOTD 2012 w/ blue switches | Poker II w/ Blue switches | Royal Kludge RK61 w/ Blue switches

Offline HoffmanMyster

  • HOFF, smol MAN OF MYSTERY
  • * Senior Moderator
  • Posts: 11539
  • Location: WI
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10034 on: Tue, 24 November 2015, 08:57:02 »
wife found a giant house spider in a bath yesterday. it was at least 10cm in size.

(Attachment Link)

Nice! Did you give him a name?

:confused:

Dude, you don't name something that you're about to kill.

Offline iri

  • Posts: 1031
  • Location: England
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10035 on: Tue, 24 November 2015, 09:07:46 »
wife found a giant house spider in a bath yesterday. it was at least 10cm in size.

(Attachment Link)

Looks like it should be pretty harmless. Do you have a picture of the dorsal view of the spider?
All giant house spiders are not aggressive.

And according to my coworker, its name is Platon.
(...)Whereas back then I wrote about the tyranny of the majority, today I'd combine that with the tyranny of the minorities. These days, you have to be careful of both. They both want to control you. The first group, by making you do the same thing over and over again. The second group is indicated by the letters I get from the Vassar girls who want me to put more women's lib in The Martian Chronicles, or from blacks who want more black people in Dandelion Wine.
I say to both bunches, Whether you're a majority or minority, bug off! To hell with anybody who wants to tell me what to write. Their society breaks down into subsections of minorities who then, in effect, burn books by banning them. All this political correctness that's rampant on campuses is b.s.

-Ray Bradbury

Offline inanis

  • Truly Literally The Cloud
  • * Destiny Supporter
  • Posts: 790
  • Location: Dark Places
    • SEALWoodworking
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10036 on: Tue, 24 November 2015, 09:36:18 »
My cat is sick. He is old and I'm going to have to take him to the vets. In my experience when you take an old cat to the vets they don't usually come home with you, so right now I'm pretty worried.
Some hearts are gallows, I'm not here for hangin' around

Offline heedpantsnow

  • * Esteemed Elder
  • Posts: 3692
  • Location: Orlando, FL
  • Old enough to know better
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10037 on: Tue, 24 November 2015, 09:56:06 »

My cat is sick. He is old and I'm going to have to take him to the vets. In my experience when you take an old cat to the vets they don't usually come home with you, so right now I'm pretty worried.

so sorry to hear that.
I'm back.

Espresso machine overhaul: https://geekhack.org/index.php?topic=78261.0

Carbon Fiber keyboard base: https://geekhack.org/index.php?topic=54825

Offline ccarlitos2

  • Posts: 879
  • Location: Not in the Tardis
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10038 on: Tue, 24 November 2015, 09:58:32 »
My cat is sick. He is old and I'm going to have to take him to the vets. In my experience when you take an old cat to the vets they don't usually come home with you, so right now I'm pretty worried.

Good luck :(
HHKB Pro 1| Poker 2(MX Browns)| Leopold FC200R (MX Blue)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Yup, that tasted purple" -Lulu

Flickr: https://www.flickr.com/photos/138889771@N05/

Offline HoffmanMyster

  • HOFF, smol MAN OF MYSTERY
  • * Senior Moderator
  • Posts: 11539
  • Location: WI
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10039 on: Tue, 24 November 2015, 10:05:33 »
My cat is sick. He is old and I'm going to have to take him to the vets. In my experience when you take an old cat to the vets they don't usually come home with you, so right now I'm pretty worried.

:(  Hope everything turns out okay.

Offline absyrd

  • CPT HYPE PADAWAN
  • Posts: 3300
  • Location: Philly Burbs
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10040 on: Tue, 24 November 2015, 10:15:41 »
Hope the kitty comes right back home feeling better.
My wife I a also push her button . But now she have her button push by a different men. So I buy a keyboard a mechanicale, she a reliable like a Fiat.

Offline inanis

  • Truly Literally The Cloud
  • * Destiny Supporter
  • Posts: 790
  • Location: Dark Places
    • SEALWoodworking
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10041 on: Tue, 24 November 2015, 10:31:13 »
Thanks guys. He is going to the vets after I get out of work, so we'll see how it goes. I'll know more soon. I also have no idea how I'm going to get him into the cat carrier.  :confused: Probably with some kind of treat, but he can be a real ass when put into situations he doesn't like. I have the bite marks to prove it.
Some hearts are gallows, I'm not here for hangin' around

Offline trizkut

  • * Global Moderator
  • Posts: 1207
  • Location: MA
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10042 on: Tue, 24 November 2015, 10:33:44 »
Deadlines quickly approaching and client requesting multiple last-minute changes.  Departing on a solo 16-hr drive tomorrow

 :confused:

Best of luck, bro.  Hopefully that job improves for you.  :-*

Thanks.  Information Security finished their audit 5 days ago, but I have yet to receive a report of their findings despite them telling me there are several flaws I need to fix.  :-X  I think the client sprung these last-minute requirements on me this week so they wouldn't have to do any work before thanksgiving  :(

My cat is sick. He is old and I'm going to have to take him to the vets. In my experience when you take an old cat to the vets they don't usually come home with you, so right now I'm pretty worried.


 :'( I hope things work out for your cat!  My dog absolutely HATES going to the vet; the minute we step in there he's already clawing at the floor.  When he got neutered he knocked out his IV and blood shot everywhere.  My vet said it looked like a murder scene in there


Offline mogo

  • Posts: 592
  • handshoes and horse grenades
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10043 on: Tue, 24 November 2015, 10:36:09 »
I think I must have kicked a puppy recently because I feel like the world really just proverbially kicked sand in my face.

My boyfriend made some delicious hazelnut coffee this morning and poured me a cup because he saw how slowly I was moving.
I put it in my travel mug and take off to work.
Fifteen minutes later, I'm in the parking lot and I set my coffee on top of the car as i get out because I had to gather up a couple other things.
when i closed the door, it bumped everything hard enough to send the mug rolling down the windshield and hood, spilling all over my car
then it hits the pavement and the lid pops off and all my tasty coffee pours into the brown-grey detritus of dead leaves and parking lot scuzz.
the lid goes rolling RIGHT into the center of the storm drain next to where I parked.
and i pick up the mug and the plastic is a spiderweb of shattered pieces. All I wanted this morning, coffee.
rip cool flecked starbucks mug.

Offline iamtootallforthis

  • Something a lot Funnier
  • * Global Moderator
  • Posts: 4745
  • Location: West Palm Beach, FL
  • I like green stuffs.
    • WTB/WTTF Thread
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10044 on: Tue, 24 November 2015, 10:38:49 »
I think I must have kicked a puppy recently because I feel like the world really just proverbially kicked sand in my face.
Show Image

My boyfriend made some delicious hazelnut coffee this morning and poured me a cup because he saw how slowly I was moving.
I put it in my travel mug and take off to work.
Fifteen minutes later, I'm in the parking lot and I set my coffee on top of the car as i get out because I had to gather up a couple other things.
when i closed the door, it bumped everything hard enough to send the mug rolling down the windshield and hood, spilling all over my car
then it hits the pavement and the lid pops off and all my tasty coffee pours into the brown-grey detritus of dead leaves and parking lot scuzz.
the lid goes rolling RIGHT into the center of the storm drain next to where I parked.
and i pick up the mug and the plastic is a spiderweb of shattered pieces. All I wanted this morning, coffee.
rip cool flecked starbucks mug.

That is a ****ty way to start the day.

Offline alienman82

  • * Elevated Elder
  • Posts: 4051
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10045 on: Tue, 24 November 2015, 10:40:22 »
removed.
« Last Edit: Thu, 01 March 2018, 16:55:30 by alienman82 »

Offline HoffmanMyster

  • HOFF, smol MAN OF MYSTERY
  • * Senior Moderator
  • Posts: 11539
  • Location: WI
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10046 on: Tue, 24 November 2015, 10:43:12 »
I think I must have kicked a puppy recently because I feel like the world really just proverbially kicked sand in my face.
Show Image

My boyfriend made some delicious hazelnut coffee this morning and poured me a cup because he saw how slowly I was moving.
I put it in my travel mug and take off to work.
Fifteen minutes later, I'm in the parking lot and I set my coffee on top of the car as i get out because I had to gather up a couple other things.
when i closed the door, it bumped everything hard enough to send the mug rolling down the windshield and hood, spilling all over my car
then it hits the pavement and the lid pops off and all my tasty coffee pours into the brown-grey detritus of dead leaves and parking lot scuzz.
the lid goes rolling RIGHT into the center of the storm drain next to where I parked.
and i pick up the mug and the plastic is a spiderweb of shattered pieces. All I wanted this morning, coffee.
rip cool flecked starbucks mug.

That is a ****ty way to start the day.

Yeah that would just make me feel defeated...  :|

Hoff hasn't accepted my steam friend invite

* HoffmanMyster hasn't been on steam for steam things in days  :P

Offline alienman82

  • * Elevated Elder
  • Posts: 4051
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10047 on: Tue, 24 November 2015, 10:46:32 »
removed.
« Last Edit: Thu, 01 March 2018, 16:55:26 by alienman82 »

Offline Steezus

  • Keeper of Facts
  • * Elevated Elder
  • Posts: 2497
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10048 on: Tue, 24 November 2015, 10:50:56 »
I thought I was going to slow down spending money after these past few boards but it's only progressing. My plans now is a camera, 1440p G-sync monitor, and then all the Christmas gifts I'll have to buy. I need to start selling some of the stuff I don't use.
TGR-Jane CE | TGR-Tris CE | Lyn Montage | LZ PhysiX | Exclusive e8.5

Offline Fire Brand

  • Keeper of Rainbows
  • * Esteemed Elder
  • Posts: 2439
  • Location: West Yorkshire, United Kingdom
  • BISCUITS!
Re: What's Bothering You? (The thread about what is bothering you.)
« Reply #10049 on: Tue, 24 November 2015, 11:08:16 »
FLUCK SAKE

I JUST MADE A REALLY WELL THOUGHT OUT AND PLANNED POST AND IT CRASHES


;~;

I shall now TLDR; it for you lovely people.

The seller for the Parcel I returned to Germany got back to me finally they got in contact with GLS and confirmed they have not gotten the parcel apparently GLS are looking into it.

In the meantime I tweeted at Royal Mail to see if they can help me out, never tweeted at anyone before I think so see how it goes.



PS: Firetrucking paragraphs people so THERE
My Youtube Channel ~
More
Keyboards owned
More
Poker II - MX Black, Poker II ISO - MX Blue :c QFR ISO - MX Black, HHKB Pro 2 Black, VA68M - Gat Blacks w/68g Gold springs
My classified thread :3
More