Server:Server Status

Surfrock66’s Weekly Tweets for 2010-08-01

Posted in Tweets on August 1st, 2010 by Surfrock66

Powered by Twitter Tools

Tags: , , ,
Leave A Comment »

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Tour Of The New House

Posted in Homes on July 26th, 2010 by Surfrock66

So, in case you didn't know, Jenn and I bought a house! Our first house, it's a townhouse located at 13 Georgetown Green, Charlottesville, VA 22901. Now we have a pool, 4 beds, 3.5 baths, and a bunch of extra space. Bigger yard for Rygel, more common green space, a second living area (so a tv room and a living room), a bigger kitchen, just everything is awesome.

I made some videos with a brief tour, so check it out:


Tags: , ,
Leave A Comment »

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Surfrock66’s Weekly Tweets for 2010-07-25

Posted in Tweets on July 25th, 2010 by Surfrock66

Powered by Twitter Tools

Tags: , , ,
Leave A Comment »

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Excel Formula: Double (And More) Conditional Sums

Posted in Geek on July 23rd, 2010 by Surfrock66

Let's say you have an excel spreadsheet for guys that sell billboard space with 3 columns: Seller, Billboard Location, and number of days. Let's say you wanted to find out how many days John sold a certain billboard for. Excel doesn't have an elegant way built in for double-conditional sums. There's a plugin you can install, but the formula is UGLY, and really doesn't work past 2 variables. If you wanted to do a triple-conditional sum, you're basically out of luck.

The solution I've come up with uses 3 features:

  1. SUMIF: SUMIF is a conditional sum formula based on a single variable. It takes 3 arguments: The range of cells to check against, the value you're searching for, and the corresponding range of cells to add if the first cell meets the conditions. Read about it here.
  2. CONCATENATE: This function just combines text into one big text. If A2="Joe" and B2="South St." then CONCATENATE(A2,B2)="JoeSouth St."
  3. Filter Uniques: Excel can take a list of items and separate it out into JUST the unique entries; this will be critical to pare down the unnecessary data. Select your range, go to the Data menu, then advanced filter, then choose your range (just the Unique ID column) and check the box for "Unique Records Only." This feature doesn't work on formulas; what you must to is select your whole column with the formula in it, copy it, then instead of pasting it in the same place chose "paste special" and select values...this just leaves the formula's result in place.

First, we need to take all of our indexes and concatenate them, so that we have a unique field for each possible combination. This works for any number of indexes. In this case, like I showed above, we're concatenating the name and location. Then, you can run the SUMIF command with the unique column we created being the range to check. Let me create an example below:

RepBoardDays
Sold		Unique IDSUM
JoeOne5=CONCATENATE(A2,B2)=SUMIF(D:D,D2,C:C)
JoeOne10=CONCATENATE(A3,B3)=SUMIF(D:D,D3,C:C)
JoeOne12=CONCATENATE(A4,B4)=SUMIF(D:D,D4,C:C)
JoeThree6=CONCATENATE(A5,B5)=SUMIF(D:D,D5,C:C)
ChrisTwo8=CONCATENATE(A6,B6)=SUMIF(D:D,D6,C:C)
ChrisOne9=CONCATENATE(A7,B7)=SUMIF(D:D,D7,C:C)
DaveOne4=CONCATENATE(A8,B8)=SUMIF(D:D,D8,C:C)
DaveTwo2=CONCATENATE(A9,B9)=SUMIF(D:D,D9,C:C)
DaveTwo7=CONCATENATE(A10,B10)=SUMIF(D:D,D10,C:C)

This produces a table like this:

RepBoardDays
Sold		Unique IDSUM
JoeOne5JoeOne27
JoeOne10JoeOne27
JoeOne12JoeOne27
JoeThree6JoeThree6
ChrisTwo8ChrisTwo8
ChrisOne9ChrisOne9
DaveOne4DaveOne4
DaveTwo2DaveTwo9
DaveTwo7DaveTwo9

which you can then use the "Filter Uniques" function on the Unique ID column to pare down to this:

RepBoardDays
Sold		Unique IDSUM
JoeOne5JoeOne27
JoeThree6JoeThree6
ChrisTwo8ChrisTwo8
ChrisOne9ChrisOne9
DaveOne4DaveOne4
DaveTwo2DaveTwo9

So, finally, once we remove the unnecessary columns and re-title the result column:

RepBoardDays Sold Per User, Per Board
JoeOne27
JoeThree6
ChrisTwo8
ChrisOne9
DaveOne4
DaveTwo9

Tags:
Leave A Comment »

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Surfrock66’s Weekly Tweets for 2010-07-18

Posted in Tweets on July 18th, 2010 by Surfrock66

  • Two Fall UFC Matchups Reported, Mark Hunt Returns #
  • Jay White vs Chris Barnett - XFC 11 - The Next Generation #
  • Bruce Connors vs Micah Miller - XFC 11 - The Next Generation #
  • Kim Couture vs Marianna Kheyfets - XFC 11 - The Next Generation #
  • Gegard Mousasi - Post-Fight Interview - DREAM.15 #
  • Rashad Evans Talks Torres, Shogun, and Rampage #
  • Dustin Rhodes vs Jeremy Smith - XFC 11 - The Next Generation #
  • James Toney On MMA Fight Preparations #
  • Ryan Ford Talks Resigning With MFC #
  • Nate Diaz Talks UFC 118 And Marcus Davis #
  • INSIDE MMA 07/09/2010 #
  • So...being out in public makes me self conscious that everyone's staring at my hideous ear and nose bandages. #
  • Victor Valimaki Discusses His Injury And Plans For Returning To Action #
  • Jimi Manuwa - Lions Eat First, Final Promo http://bit.ly/dpOr33 #
  • Fight Nerd Vlog: Evolution AMMA 7/10/2010 #
  • Jon Fitch Does Ladder Drill: In-In Out-Out Fwd Bwd http://bit.ly/d5GzZm #
  • Freddie Roach Talks About GSP And Hints Possible Appearance On TUF 12 #
  • Quick Interview With Bibiano Fernandez http://bit.ly/bpCfc6 #
  • Wandy Talks UFC 116, Leben, More #
  • Jose Canseco vs. Gary Hogan http://bit.ly/9uCtGz #
  • Sean McCorkle Coming To The UFC To Fight Mark Hunt http://bit.ly/cOdaxd #
  • “UFC Fight Night” To Feature Demian Maia vs. Alan Belcher Live From Austin #
  • Minnesota’s Travis Reddinger Added To Bellator’s Bantamweight Tournament http://bit.ly/aUHUSb #
  • First Look At Round 5 “Versus” Series Prototype Images http://bit.ly/byLH4p #
  • Ryan Ford Talks Re-Signing With MFC #
  • World Extreme Fighting Results From July 10 http://bit.ly/aP0V2W #
  • DREAM 15 Recap And Results http://bit.ly/aYePDo #
  • I don't feel so great today. Throat hurts, a little light headed. Hope it's not from the surgery... #
  • Effing gross...a huge scab just fell out, but was woven with stitching so it wouldn't fall off, and if I pulled it pulled my stitches. Sick #
  • Fight News: DREAM.15 Recap #
  • DREAM 15 Manhoef - The Most Intense Entrance In MMA http://bit.ly/a3H7bl #
  • UFC Tom Lawlor: Anal Colonic During Interview With Aaron Tru #
  • XFC 11 Recap http://bit.ly/bc6GdC #
  • War Machine’s Last Interview Before Jail http://bit.ly/cd1rJX #
  • Mom andmeg didn't believe I had surgery...so here's a semi-healed less gross pic. http://twitpic.com/250jfw #
  • Bellator Signs British Heavyweight Neil “Goliath” Grove #
  • Cage Fighting Travels To Salamanca, N.Y. For “Raging Wolf VIII: Cage Supremacy” http://bit.ly/bTiutF #
  • Strikeforce Houston Press Conference Quotes And Photos http://bit.ly/bsIx6n #
  • umm...I'm pretty sure the bloody cottonball stitched to my head has given me an ear infection. This is not pleasant. #
  • Cottonball is out, still swollen, still visible stitches. http://twitpic.com/25am0n #
  • Josh Barnett Impact FC Interview #
  • MMA Comes To Manitoba With “MFC 26: Retribution” http://bit.ly/dyT8vu #
  • Backstage With Joe Rogan http://bit.ly/bC9OmM #
  • UCMMA - What We Do. http://bit.ly/aiwrs0 #
  • Big John McCarthy Impact FC Interview http://bit.ly/bcTpbX #
  • Karo “The Heat” Parisyan Impact FC Interview http://bit.ly/dhFIR3 #
  • Chael Sonnen Calls Out Anderson Silva At UFC Fan Expo http://bit.ly/aeBaUb #
  • Scott Coker Talks Batista, Lashley, Fedor, And More. http://bit.ly/cYDVd4 #
  • New UFC Fighter Vitor Vianna Highlight http://bit.ly/bSkZug #
  • Laimon vs. Drysdale http://bit.ly/a7FGVK #
  • Keith Jardine Gets Chance At Redemption, Eyes Trevor Prangley Bout http://bit.ly/cQqYr3 #
  • Chute-Boxe Honors Instructors, Introduces UFC Singee Vinicius Queiroz http://bit.ly/bOkRlj #
  • American Forces Network To Broadcast Bellator Fighting Championships http://bit.ly/b47rmz #
  • Butterbean On Pudzianowski: He Punches Like A Girl #
  • Last Chance to Vote for the UFC 117 Tequila Cazadoes Spirit Award Winner http://bit.ly/cWQI7c #
  • Steroid And Drug Testing Results Released For UFC 116 http://bit.ly/d8QC46 #
  • Hector Lombard To Face Herbert “Whisper” Goodman At Bellator 24 http://bit.ly/9oC8ep #
  • Closeup of my cool new ear scar. Contrary to this pic, it'll be hidden when it heals. http://twitpic.com/25dhgp #
  • Cole ‘Magrinho’ Miller http://bit.ly/9IK8jz #
  • Wow...at 1 PM tomorrow afternoon I become a homeowner. And Jenn will be working til 11 PM. Anyone wanna get a beer to celebrate (til 11)? #
  • Fabricio Werdum Highlight #
  • Ricco Rodriguez vs. Scott Peters at Grapplers Quest http://bit.ly/bRCjNF #
  • George Sotiropoulos With Submissions 101 http://bit.ly/9oF9w2 #
  • Ken Shamrock On UFC 9, Frank Shamrock Retiring & Mainstream Athletes In MMA http://bit.ly/cMkCXe #
  • Stephan Bonnar Bruised And Bloodied http://bit.ly/9IVZJp #
  • When you realize that Miss Piggy and Yoda were voiced by the same guy, it jumps out at you. #
  • Tickets On Sale Tomorrow For Bellator 27 At San Antonio’s Majestic Theater http://bit.ly/dgExB0 #
  • U.S. Army Vet And Matt Hume Protégé Caros Fodor To Face Cung Le Pupil Thomas Diagne http://bit.ly/aU4fYa #
  • MMA Future Stars: Welterweight Edition #
  • Vladimir Putin Shows Support At Sochi Open European Championships http://bit.ly/b3GyWj #
  • UFC 116 Attendance And Ticket Revenue Released http://bit.ly/9VlddE #
  • TFC Owner Mark Sinclair Comments On Ryan Ford Depature And Next Event http://bit.ly/dsNMUp #
  • I'm at Arch's Frozen Yogurt (1232 Emmet Street North, Charlottesville). http://4sq.com/bonks1 #
  • Remaining Bouts For “UFC 117: Silva vs. Sonnen” Confirmed http://bit.ly/bKxhXu #
  • Fujii vs. Magana, Alvarez vs. Aguilar To Kick Off Bellator Women’s Tournament http://bit.ly/cjBUdg #
  • Yes. Move to a real city. RT @outskirts: earthquake, blazing heat, not ranked in top 100 cities....is cville at end of existence? #
  • Left Hook….Good Night! #
  • Fight News: Impact FC 2 Preview http://bit.ly/b5WEpx #
  • Jon Bone Jones Discusses His Upcoming Fight With Matyushenko http://bit.ly/aqt77I #
  • Paul Daley Impact FC Interview http://bit.ly/b56p1p #
  • Dana White On Boxing And Brock Lesnar http://bit.ly/cy6rhP #
  • Vinny Magalhaes: Flower Sweep To Triangle Choke http://bit.ly/cbCv8m #
  • UFC 117: Silva Pre-fight Interview http://bit.ly/d9K9rV #
  • Dan Hardy: If You Like Josh Koscheck, Then You’ve Not Met the Guy http://bit.ly/9EYliV #
  • UFC 117: Sonnen Pre-fight Interview http://bit.ly/cd3uHm #
  • The words I want to use right now are of the classification that would make people unfriend me on facebook. Think "Next Tuesday." #
  • The English language is so dumb that it's proliferation calls into question my faith in natural selection. Let's wipe it and start over. #
  • Cole Miller vs Ross Pearson Set For UFN 22 http://bit.ly/aoTPhp #
  • Full “UFC Live On Versus” Card Confirmed http://bit.ly/9qt0XE #
  • Media Alert: Tonight On HDNet http://bit.ly/93XxSw #
  • Top European Heavyweight Rogent Lloret Signs With Bellator http://bit.ly/cUEUDh #
  • “Tuff-N-Uff: Xtreme Couture vs. Team Quest” Set For Aug. 6 http://bit.ly/btNVJM #
  • Eddie Sanchez Officially Added To Bellator Heavyweight Tournament http://bit.ly/dilIS3 #
  • Cole Miller vs. Ross Pearson Set For UFN 22 http://bit.ly/aoTPhp #
  • UFC Signs Imagery Distribution Partnership With Heavyweight Getty Images http://bit.ly/a2Ta4D #
  • Bobby Lashley vs. Chad Griggs Slated For “Strikeforce: Houston” http://bit.ly/b5pFtv #
  • Lyoto Machita & Anderson Silva Talk About Upcoming Fights http://bit.ly/9iEs83 #
  • UFC on Versus: Jones vs. Matyushenko http://bit.ly/diJiP7 #
  • Jake Shields Chokes Out Dave Farra http://bit.ly/a56qJe #
  • Chris Lytle Receives Undisclosed Bonus For UFC 116 Performance http://bit.ly/d4n6Vy #
  • UFC On Versus: Jones vs. Matyushenko http://bit.ly/diJiP7 #
  • So not only is closing delayed to next week...$800 car repair bill. Zoloft is a miracle drug! #owlbear #dumbassahedrotron #
  • So when did spencers start selling full on explicit sex toys? I remember blacklights & stupid stuff..now full on dildos? With kids in there? #
  • MMA Live: 7/15/10 #
  • Wanderlei Silva Training Center http://bit.ly/bM3wrQ #

Powered by Twitter Tools

Tags: , , ,
Leave A Comment »

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
« Previous Page — « Previous Entries
Next Entries » — Next Page »