Thread Killer Mk IX

[Ike_009]

Playing the new Guild Wars 2 content, really good this time around.

So what are you gents up to?

Trying to figure this excel bad boy out

=IF($I11<=$H11,0,(IF(($I11-SUM($O11:Y11)-$H11)>(IF(((($G11-$H11)*((100/$F11)/100))/12)>($I11-$H11),($I11-$H11),((($G11-$H11)*((100/$F11)/100))/12))),(IF(((($G11-$H11)*((100/$F11)/100))/12)>($I11-$H11),($I11-$H11),((($G11-$H11)*((100/$F11)/100))/12))),($I11-SUM($O11:Y11)-$H11))))

 

[DieGrootHammer]

Trying to figure this excel bad boy out

=IF($I11<=$H11,0,(IF(($I11-SUM($O11:Y11)-$H11)>(IF(((($G11-$H11)*((100/$F11)/100))/12)>($I11-$H11),($I11-$H11),((($G11-$H11)*((100/$F11)/100))/12))),(IF(((($G11-$H11)*((100/$F11)/100))/12)>($I11-$H11),($I11-$H11),((($G11-$H11)*((100/$F11)/100))/12))),($I11-SUM($O11:Y11)-$H11))))

Ah, that cute ...I see your formula, and raise you THIS:

=IF(E2="Hyper PnP", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,3), IF(E2="Super PnP", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,4), IF(E2="Super Checkers", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,5), IF(E2="Super Spar", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,6), IF(E2="Super Shoprite", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,7), IF(E2="Franchise PnP", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,8), IF(E2="Franchise Spar", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,9), "NONE FOUND")))))))

 

[Crableg]

I got just got my first haircut in awhile, feels weird having short hair again... please support me during this difficult time

 

[Dohc-WP]

damn still an hour and a half left

 

[Ike_009]

Ah, that cute ...I see your formula, and raise you THIS:

=IF(E2="Hyper PnP", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,3), IF(E2="Super PnP", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,4), IF(E2="Super Checkers", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,5), IF(E2="Super Spar", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,6), IF(E2="Super Shoprite", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,7), IF(E2="Franchise PnP", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,8), IF(E2="Franchise Spar", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,9), "NONE FOUND")))))))

Eish that's big but at least all the tab names breaks it up so I can figure it out, my one was for monthly depreciation. I wish excel could split of these long formulas though.

 

[Mister 44]

Trying to figure this excel bad boy out

=IF($I11<=$H11,0,(IF(($I11-SUM($O11:Y11)-$H11)>(IF(((($G11-$H11)*((100/$F11)/100))/12)>($I11-$H11),($I11-$H11),((($G11-$H11)*((100/$F11)/100))/12))),(IF(((($G11-$H11)*((100/$F11)/100))/12)>($I11-$H11),($I11-$H11),((($G11-$H11)*((100/$F11)/100))/12))),($I11-SUM($O11:Y11)-$H11))))

^^^^^
This is the type of shit that happens when accountants become computer literate.

Somebody once told me his boss at a new job greeted him like this:
Inside every company, no matter how tech savvy the employees or how efficient their systems, there will always be a number of excel sheets drifting around. These sheets will have formulas, be integral to the workings of at least two separate systems and the existence of each sheet will be known to only one person.
Your mission, as a business analyst (should you choose to accept), will be to locate these sheets, standardize it and integrate it into the existing systems.
Good luck and be careful out there.

 

[Ike_009]

I got just got my first haircut in awhile, feels weird having short hair again... please support me during this difficult time

Here you go

 

[Mister 44]

I got just got my first haircut in awhile, feels weird having short hair again... please support me during this difficult time

So you walked into a barber and said: "Keep cutting till you hit pube length"?

 

[Ike_009]

^^^^^
This is the type of shit that happens when accountants become computer literate.

Thanks, but I know what you mean. I miss uni and simple calculators

 

[DieGrootHammer]

Eish that's big but at least all the tab names breaks it up so I can figure it out, my one was for monthly depreciation. I wish excel could split of these long formulas though.

Nice!!! I used mine to lookup various values and compare it to a number of elements, and return the optimal pack out rate of stock.

^^^^^
This is the type of shit that happens when accountants become computer literate.

Somebody once told me his boss at a new job greeted him like this:
Inside every company, no matter how tech savvy the employees or how efficient their systems, there will always be a number of excel sheets drifting around. These sheets will have formulas, be integral to the workings of at least two separate systems and the existence of each sheet will be known to only one person.
Your mission, as a business analyst (should you choose to accept), will be to locate these sheets, standardize it and integrate it into the existing systems.
Good luck and be careful out there.

This is such an accurate description of corporation around the country. I know I make myself quite guilty of rather creating a formula that will get the job done than standardising some existing documents. This is the reason why company wide information system integration is a must.

 

[Crableg]

Here you go

So you walked into a barber and said: "Keep cutting till you hit pube length"?

Ike got it right, I say the usual "just want it abit shorter and neater" and cause your hair is wet when they cut it looks longer,

Its not terribly short, just shorter than Im used to...

3rd world problems

 

[Wenzdayz]

Yeah man. I got the note last week. Went there this morning, they couldn't find it. So I got the manager out (who seems mildly competent) to look for the parcel and phone me when they have located it. They're even listed as the last scanned location.

ja, that's never gonna happen... you will have to phone him cause he stoped looking for that parcel the moment you were out the door

 

[Ike_009]

Ike got it right, I say the usual "just want it abit shorter and neater" and cause your hair is wet when they cut it looks longer,

Its not terribly short, just shorter than Im used to...

3rd world problems

You should have seen my hair cut going from student length to professional work length. I swear my head felt bald

 

[Crableg]

You should have seen my hair cut going from student length to professional work length. I swear my head felt bald

 

[Hiro]

Futher mucking load shedding!

 

[InSanity]

Ah, that cute ...I see your formula, and raise you THIS:

=IF(E2="Hyper PnP", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,3), IF(E2="Super PnP", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,4), IF(E2="Super Checkers", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,5), IF(E2="Super Spar", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,6), IF(E2="Super Shoprite", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,7), IF(E2="Franchise PnP", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,8), IF(E2="Franchise Spar", VLOOKUP(I2,'Pack Out Rate Data Sheet'!A$2:I$58,9), "NONE FOUND")))))))

pffft noobs

 

[brendanvb]

Futher mucking load shedding!

Just as our power returned our internet went off. Suffice to say it has been a very unproductive day at the office...

 

[Solitude]

Luckily power back home is back on. At work we had power the whole day in Boskruin.

I just really hope we have power tonight because I still have to make my rugby picks.

 

[InSanity]

ok im gonna post this /b/ style

>go to renew license for car
>wait in massive line for days
>get to front of the line get told photocopier isn't working i must go and get a copy of my ID made
>begrudgingly leave and on a adventure to find somewhere i can make a photo copy
>return get told have to wait in even massiver line
>finally get to the front copy of ID in hand and ready
>chicks starts capturing
>mfw

>place goes dark ... load shedding

 

[MalicE]

Aaaaand our power is off again