888-820-TREE (8733)

Job Board

Weekend Events - July 22-24, 2016 - Tulsa & OKC

July 22
Saturday –
·         Tulsa Dodge Brawl – BOK Center.  Too late to play, but free to watch.  Events starts at 11 am.  Party zone next to the court. http://tulsadodgebrawl.com/event/217/
July 22
The Lauren Barth Band with Jessica Price at the Colony
Dante and the Hawks at Hunt Club
John Calvin Abney & Kalyn Fay at Soul City
Brother Dege at Mercury Lounge
Fitz & The Tantrums at Cain’s Ballroom

July 23
Cowboy Jones at the Colony
Alan Doyle at Hunt Club
Jacob Tovar and the Saddle Tramps
Wink Burcham at Mercury Lounge
American Shadows, Greater Than Planes and The Danner Party at Billy & Renee's
Aaron Lewis at Cain’s Ballroom
The Jumpshots – RiverWalk Amphitheater

July 24
as always…
Paul Benjamin’s Sunday Nite Thing
Brandon Clark at Mercury Lounge

·         OKC Dodgers vs New Orleans Zephyrs – Friday/Saturday at 7:05, Sunday at 6:05 and Monday 7:05  http://www.milb.com/schedule/index.jsp?sid=t238      
·         OKC Energy FC Vs Tulsa Roughnecks – Saturday  Taft Stadium 7:30  http://www.energyfc.com/#0
·         Rumble at Remington - Live Fights pro boxing. Remington Park at 7 pm.  Bo Gibbs, Aaron Chavers, Rob Ivins  http://hdboxing.net/event/live-fights-pro-boxing-oklahoma-20160723/              
July 22
Callahan Divide at the Wormy Dog Saloon
Jason Boland & The Stragglers  - Great Lawn at Myriad Botanical Gardens
Kelly Pickler – Frontier City
Ali Harter and Erik the Viking – Hillbilly’s
The Tooth w/Souls and Forty Fathoms – 89th Street Collective
Kestrel & Kite – Bin 73
Chris Isaak at Firelake Grand Casino
Zane Williams at the Wormy Dog Saloon  
Clear the Shelter Weekend
o   City of Tulsa Animal Welfare  and at Woodland Hills Mall near Dillards Noon-6 pm
o   Animal Aid of Tulsa at Alta vista Pet Lodge 10-3
o   Sapulpa Furry Friends at Southern Ag in Tulsa Hills 11-4
o   OKC animal Welfare – 10-8
Read More

Raspberry Pi Temperature Sensor Project: Using Sinch to Retrive Data Via SMS: Part 1

Read More

RaspberryPi Temperature Sensor Project: Using Web API To Retrieve Data

Read More

Weekend Events - July 15-17, 2016 - Tulsa & OKC

Read More

How To Create A Formula To Reference An Offset Row Or Column in Excel Macro

The Power of the R1C1 Formula in Excel Macro

Video Transcript:

Hi - Jim Hudson, OakTree.com. If you've ever needed to create a formula in Excel Macro and you needed to reference an offset row or an offset column, the method that you're looking for -- excuse me, the property that you're looking for is called formula R1C1. So, for example, I have my current cell here in B8, but I want to reference row 1, which would be right here, but I want to reference column -1. In other words, I want to go left 1. So, if I say, "ActiveCell.FormulaR1C1=R1C-1", what it's going to do is it's going to give me 2 because it's going to the current -- it's going to row 1 and it's going to the current column, but it's counting over 1.

Another way you can use this is is you can use this to dynamically build formulas using functions. So, here we're saying, "Hey, I want to sum some numbers in the column immediately to the left." So, if we run this, then we can see that it gives us 5 because it goes to row 1 through row 2, but it offsets to the left because we've decremented here with -1, offsets to the left the column that we're on and we get our total of 5. Jim Hudson, oaktreeit.com. 

Read More

Weekend Events in Tulsa & OKC - July 8-10, 2016

Here's what to do this weekend in Tulsa & OK, Oklahoma!

Read More

4th of July Weekend 2016 Events in Tulsa, OKC, & Bartlesville, OK

Read More

Tech Tutorial: REST & Python On Raspberry Pi

Read More

VIDEO: Microsoft Azure SQL Databases - Jim Hudson

Read More

Weekend Events For June 24-26, 2016 - Tulsa & OKC, Oklahoma

Read More