HFBoards

Go Back   HFBoards > NHL Western Conference > Central Division > Colorado Avalanche
Mobile Hockey's Future Become a Sponsor Site Rules Support Forum vBookie Page 2
Notices

OT: Shermy and Bricky's Thread

Closed Thread
 
Thread Tools
Old
03-07-2013, 08:28 AM
  #751
RockLobster
Moderator
Beatles Guru
 
RockLobster's Avatar
 
Join Date: Jul 2003
Location: Kansas
Country: Germany
Posts: 12,026
vCash: 905
Quote:
Originally Posted by Bubba Thudd View Post
Happy Birthday, Ronaldo!
Happy Birthday Ronaldo!

__________________


Thought I'd been in love before, but in my heart I wanted more. Seems like all I really was doing was waiting for you - John Lennon/The Beatles
RockLobster is online now  
Old
03-07-2013, 09:01 AM
  #752
ChibiPooky
Moderator
Caps/Avs/Bills fan
 
ChibiPooky's Avatar
 
Join Date: May 2011
Location: Fairfax, VA
Country: United States
Posts: 9,328
vCash: 50
Quote:
Originally Posted by Bubba Thudd View Post
Happy Birthday, Ronaldo!
Happy birthday Ronaldo! May your pillow fights be numerous and frequent!

ChibiPooky is offline  
Old
03-07-2013, 11:24 AM
  #753
Lonewolfe2015
Registered User
 
Lonewolfe2015's Avatar
 
Join Date: Dec 2007
Country: United States
Posts: 11,354
vCash: 239
So.... I wrote a 660 character long excel formula today. I feel so ashamed of myself, because it works really well but I can't even really sift through it visually and I wrote the damn thing. It's indexing data in a manner that's even complicated to explain.

Needless to say, I'm finding it difficult to even break the thing down into its individual components to try and shrink it.

If anyone tries to edit this one day, they are going to feel like they are looking for a needle in a hay stack.

Lonewolfe2015 is online now  
Old
03-07-2013, 11:28 AM
  #754
Bubba Thudd
Moderator
#AvsNewAge
 
Bubba Thudd's Avatar
 
Join Date: Jul 2005
Location: Avaland
Posts: 12,667
vCash: 50
I wrote an Excel spreadsheet that was used to roll up D&D characters.
It took race, gender, age, etc into consideration when applying attributes. It was a freaking nightmare -- but it worked great! I later re-did it in VB.

__________________
Call for the Priest, I'm Dying!
Bubba Thudd is offline  
Old
03-07-2013, 11:35 AM
  #755
Lonewolfe2015
Registered User
 
Lonewolfe2015's Avatar
 
Join Date: Dec 2007
Country: United States
Posts: 11,354
vCash: 239
Quote:
Originally Posted by Bubba Thudd View Post
I wrote an Excel spreadsheet that was used to roll up D&D characters.
It took race, gender, age, etc into consideration when applying attributes. It was a freaking nightmare -- but it worked great! I later re-did it in VB.
I don't like to design spreadsheet 100% in VB because people don't know how to interact with it and it's resource intensive to write loops to append data rather than design a formula to parse data.

I already designed the VB backend so that it prompts the user to open various Workbooks of raw data from a couple directories with the filename inputted (through a few input box strings rolled up, aka Part Number + Revision Number, open .csv files, copy/paste data and close).

So I then designed a formula I'm working on that indexes said raw data and determines the max/min of a multi-dimensionally determined dynamic range.

The user selects the rows they want to Min/Max parse out via two data validation dropdown lists and the formula determines its column height via those lists. Then it finds its row coordinates for this dynamic table (created via a dynamic named range that updates itself when new data is appended) and gets its proper value.

If you followed all that, it's been about 25 hours of work so far and I'm quite pleased.

The worst part was writing a VB script which formatted the Form's Wrapped/Merged cells, because merging is terrible for code and in 2007 Excel can't autofit a Wrap/Merged cell so I had to make a loop manually determine ideal cell height in a copy/pasted dummy workbook for each cell.

Lots of work...

Lonewolfe2015 is online now  
Old
03-07-2013, 11:54 AM
  #756
Bubba Thudd
Moderator
#AvsNewAge
 
Bubba Thudd's Avatar
 
Join Date: Jul 2005
Location: Avaland
Posts: 12,667
vCash: 50
I'm eating Taco Bell -- Doritos Cool Ranch tacos for lunch.

Bubba Thudd is offline  
Old
03-07-2013, 12:02 PM
  #757
Duchene2MacKinnon
BELIEVE
 
Duchene2MacKinnon's Avatar
 
Join Date: Aug 2006
Country: Canada
Posts: 14,540
vCash: 250
Quote:
Originally Posted by Bubba Thudd View Post
Happy Birthday, Ronaldo!
Quote:
Originally Posted by RockLobster View Post
Happy Birthday Ronaldo!
Quote:
Originally Posted by ChibiPooky View Post
Happy birthday Ronaldo! May your pillow fights be numerous and frequent!
Awww thank you. You guys are awesome.

Duchene2MacKinnon is online now  
Old
03-07-2013, 12:04 PM
  #758
Bubba Thudd
Moderator
#AvsNewAge
 
Bubba Thudd's Avatar
 
Join Date: Jul 2005
Location: Avaland
Posts: 12,667
vCash: 50
Quote:
Originally Posted by Ronaldo View Post
Awww thank you. You guys are awesome.
Damn skippy, hippie

Bubba Thudd is offline  
Old
03-07-2013, 12:17 PM
  #759
Ceremony
Moderator
Ten Tons
 
Ceremony's Avatar
 
Join Date: Jun 2012
Posts: 73,513
vCash: 499
Here ya go Ronaldo


__________________
ďItís embarrassing. Iím embarrassed to be here right now. Itís not even funny. And itís just embarrassing, the way we, you know, the energy we have in the room and the way we approach practices and the way we approach this game. Itís not how youíre going to win any games in this league." - Jean-Sebastien Giguere, April 8 2013
Ceremony is online now  
Old
03-07-2013, 09:42 PM
  #760
The Shermanator
Regular Sized Rudy
 
The Shermanator's Avatar
 
Join Date: Jul 2011
Location: Ottawa
Country: Canada
Posts: 9,106
vCash: 50
What do you all think RockLobster's real name is?

I say it's it's George.

The Shermanator is online now  
Old
03-07-2013, 09:50 PM
  #761
RockLobster
Moderator
Beatles Guru
 
RockLobster's Avatar
 
Join Date: Jul 2003
Location: Kansas
Country: Germany
Posts: 12,026
vCash: 905
Quote:
Originally Posted by The Shermanator View Post
What do you all think RockLobster's real name is?

I say it's it's George.
LOL...

Why do you think it's George? (That's actually a good name imo, if I have a baby boy it's on my list)

RockLobster is online now  
Old
03-07-2013, 09:58 PM
  #762
BrickAHL
#NotUs
 
BrickAHL's Avatar
 
Join Date: Mar 2011
Location: Vancouver
Country: Canada
Posts: 10,062
vCash: 432
I have officially broken up with Jeff Petry.

BrickAHL is offline  
Old
03-07-2013, 09:59 PM
  #763
RockLobster
Moderator
Beatles Guru
 
RockLobster's Avatar
 
Join Date: Jul 2003
Location: Kansas
Country: Germany
Posts: 12,026
vCash: 905
Quote:
Originally Posted by BrickAHL View Post
I have officially broken up with Jeff Petry.
I saw that...I hope that you'll be strong and not go back to him.

RockLobster is online now  
Old
03-07-2013, 10:11 PM
  #764
S E P H
@Krzysztof_WHL
 
S E P H's Avatar
 
Join Date: Mar 2010
Location: Avs Country!
Country: Poland
Posts: 4,527
vCash: 50
How do we know it's D2M's birthday? He could be a lying cheat.

S E P H is online now  
Old
03-07-2013, 10:13 PM
  #765
The Shermanator
Regular Sized Rudy
 
The Shermanator's Avatar
 
Join Date: Jul 2011
Location: Ottawa
Country: Canada
Posts: 9,106
vCash: 50
My other guess was Daniel.

But you also look like a Nathan.

The Shermanator is online now  
Old
03-07-2013, 10:15 PM
  #766
RockLobster
Moderator
Beatles Guru
 
RockLobster's Avatar
 
Join Date: Jul 2003
Location: Kansas
Country: Germany
Posts: 12,026
vCash: 905
Quote:
Originally Posted by The Shermanator View Post
My other guess was Daniel.

But you also look like a Nathan.
I "look like" a Nathan?

How do you know what I look like?

RockLobster is online now  
Old
03-07-2013, 10:16 PM
  #767
The Shermanator
Regular Sized Rudy
 
The Shermanator's Avatar
 
Join Date: Jul 2011
Location: Ottawa
Country: Canada
Posts: 9,106
vCash: 50
Quote:
Originally Posted by RockLobster View Post
I "look like" a Nathan?

How do you know what I look like?

The Shermanator is online now  
Old
03-07-2013, 10:18 PM
  #768
Flow
Registered User
 
Flow's Avatar
 
Join Date: Jul 2011
Posts: 847
vCash: 542
Quote:
Originally Posted by Bubba Thudd View Post
I'm eating Taco Bell -- Doritos Cool Ranch tacos for lunch.
They need to bring back the chicken flatbreads.

Flow is offline  
Old
03-07-2013, 10:20 PM
  #769
RockLobster
Moderator
Beatles Guru
 
RockLobster's Avatar
 
Join Date: Jul 2003
Location: Kansas
Country: Germany
Posts: 12,026
vCash: 905
Quote:
Originally Posted by The Shermanator View Post

RockLobster is online now  
Old
03-07-2013, 10:21 PM
  #770
The Shermanator
Regular Sized Rudy
 
The Shermanator's Avatar
 
Join Date: Jul 2011
Location: Ottawa
Country: Canada
Posts: 9,106
vCash: 50
Quote:
Originally Posted by RockLobster View Post
Give me a hint.




Then I'll tell you my name

The Shermanator is online now  
Old
03-07-2013, 10:21 PM
  #771
BrickAHL
#NotUs
 
BrickAHL's Avatar
 
Join Date: Mar 2011
Location: Vancouver
Country: Canada
Posts: 10,062
vCash: 432
I also know how RockLobster looks.


BrickAHL is offline  
Old
03-07-2013, 10:24 PM
  #772
The Shermanator
Regular Sized Rudy
 
The Shermanator's Avatar
 
Join Date: Jul 2011
Location: Ottawa
Country: Canada
Posts: 9,106
vCash: 50
I just remembered he is German....


Franz? Lars? Klaus? Adolf?

The Shermanator is online now  
Old
03-07-2013, 10:25 PM
  #773
RockLobster
Moderator
Beatles Guru
 
RockLobster's Avatar
 
Join Date: Jul 2003
Location: Kansas
Country: Germany
Posts: 12,026
vCash: 905
Quote:
Originally Posted by The Shermanator View Post
Give me a hint.


Then I'll tell you my name
Here's your hint: It's not Franz, Lars, Klaus or Adolph.

Quote:
Originally Posted by BrickAHL View Post
I also know how RockLobster looks.

This might be true....though I'm not sure how.

RockLobster is online now  
Old
03-07-2013, 10:27 PM
  #774
The Shermanator
Regular Sized Rudy
 
The Shermanator's Avatar
 
Join Date: Jul 2011
Location: Ottawa
Country: Canada
Posts: 9,106
vCash: 50
Quote:
Originally Posted by RockLobster View Post
Here's your hint: It's not Franz, Lars, Klaus or Adolph.
But it might be Adolf?

Is it a stereotypical German name?

The Shermanator is online now  
Old
03-07-2013, 10:29 PM
  #775
RockLobster
Moderator
Beatles Guru
 
RockLobster's Avatar
 
Join Date: Jul 2003
Location: Kansas
Country: Germany
Posts: 12,026
vCash: 905
Quote:
Originally Posted by The Shermanator View Post
But it might be Adolf?

Is it a stereotypical German name?
First name: No, not stereotypical

Last name: Probably one of the more common German names (and most likely "Americanized")

I am a US Citizen

RockLobster is online now  
Closed Thread

Forum Jump


Bookmarks

Thread Tools

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



All times are GMT -5. The time now is 04:27 PM.

monitoring_string = "e4251c93e2ba248d29da988d93bf5144"
Contact Us - HFBoards - Archive - Privacy Statement - Terms of Use - Advertise - Top - AdChoices

vBulletin Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
HFBoards.com is a property of CraveOnline Media, LLC, an Evolve Media, LLC company. ©2014 All Rights Reserved.