Printable View
Bill, what sort of work do you do anyway? I don't think I've ever asked that.
I miss my attic fan though. And at his house, its a 1 bedroom, have 21k btu in the living room and 5050btu in the bedroom. Just guessing I'd say its 68-72* in here. Feels great. :) And just to egg on Bill, the heat wave left here a bit. We're back in the low 90s high 80s range :D
It's 130 and I havent had lunch yet. Go to the fridge, or wait till after work? Hmmm
We are only supposed to see brutal heat for two days. If that's the best you can do.. you are a fraile, weak, girlish looking dude. :cool: (Or I've seen pics...lol)
I spend most of my day working in Excel and finance reporting systems. Basically I monitor expenses and create some cool stuff for people. Here's an example of a formula I wrote one day to grab data from a big messed up sheet and stuff it into a certain format.
=IF(ISERROR(INDEX('Data from Mgrs'!$B$8:$AY$36,MATCH($C11,INDIRECT("'" & $E$2 & "'!"&E$3&":"&E$4),0),MATCH(E$9,'Data from Mgrs'!$B$8:$AY$8,0)+1)),0,INDEX('Data from Mgrs'!$B$8:$AY$36,MATCH($C11,INDIRECT("'" & $E$2 & "'!"&E$3&":"&E$4),0),MATCH(E$9,'Data from Mgrs'!$B$8:$AY$8,0)+1))
Different language...you speak it... :DQuote:
Originally Posted by BillBoost37
I've done like the BABY version of that stuff before bill lol
creating spreadsheets of data for call centre logging.
also i can make fun stuff like a random dice tool lol
Would you prefer I posted some VB from an Excel macro that I wrote? It's more like broken English than anything else.
'Copy Company Function and Melob to staging area
Range("A9").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Range("Company").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("B9").Select
Range(Selection, Selection.End(xlDown)).Select
Application.CutCopyMode = False
Selection.Copy
Range("Function").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("C9").Select
Range(Selection, Selection.End(xlDown)).Select
Application.CutCopyMode = False
Selection.Copy
Range("Melob").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
'Copy Dept number down to staging area
Application.Goto Reference:="DeptNum"
Selection.Copy
Lastrow = Range("A65536").End(xlUp).Row
Range("DeptNum" & ":B" & Lastrow).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Hey before you go calling people frail and girly and what not, *ahem*, keep in mind we just had the heat wave you're having now. We are strong people in this jiggaboo town :DQuote:
Originally Posted by BillBoost37
And cool beans, but I didn't understand a thing you said after formula, but I get what you're saying. Do you have a degree in finance or business or you just gifted sir?
Yes, BS in Business Admin. aka Accounting.
Those that work with it will see some stuff and say "cool" typically. Most of the people I work around don't understand anything beyond the workload got easier and was done fast. Dunno, I learned most MS stuff on my own, based on a need to do something at that time. I commonly Google stuff for Excel. Index is technically just a cooler version of Vlookup.
I'm the only person in my department that knows excel. Boss thinks I'm some kind of spreadsheet magician. "A pie chart! Nobody else did a pie chart! We should make this the new standard!" They really all just think it's a convenient grid-making program. :th_scratchhead:
Of course, I'm not in Acc/Fin/AP/whatever... just IT.
I've always laughed when people say they know various stuff and they mean..they know how to launch the app. lol
I used to write my own HTML script for Myspace back in the day when it was popular. After some research it was just easier to write it out than to try and use a "web page program" that writes it for you.
... but that has been many moons since Myspace was "the thing"
Man you guys must be made of money to have your heat and ac at such extreme temps. In the summer my ac is on 78 and in the winter my heat is on 62. I like saving money and can put up with the heat/ cold.
I only have AC in my car.
Chicken in the oven. Will it be ready in 2 hours? Ahh we will see.
Quote:
Originally Posted by mechguy
dont trust that stupid meat popper in the bird, use a thermometer to know when it's done, i do all the time, and im always taking it out before the popper goes pop.
who likes dry chicken????? not me.
yeah i do all the cooking around here, yes i do.
i locked my keys in the trunk just now. where is my spare?
suppose the car is locked too lol
yeah, ill have to wait till my wife gets home with the key that only opens the doors lol
your lucky, i had to borrow a car and drive 25 miles both ways last time i locked the keys in the car.
that sucks. hard.
It actually worked out, i was suppose to go somewhere i didnt want to go. Now i have an excuse