Akron/Cleveland 8 Owners.
#3127
TeethNThings.com
iTrader: (10)
Join Date: Mar 2008
Location: Mere seconds behind the leader...Doh!
Posts: 1,322
Likes: 0
Received 0 Likes
on
0 Posts
Per Marlin on the NORA site:
http://www.noraracing.net/forum/view...p=24086#p24086
[quote]
Wait guys there's more! I met with the powers that be @ Montrose Auto Group, formerly Westside and they want in!!! They will be offering us parts, service and accessory discount not only at Westside, but any amd all of their dealerships. So no matter what you drive, they will hook you up.
I will be finalizing things on Monday to put some packages together with Chris Dunn, he 's the Accessories Manager @ Westside and has connections to a number of aftermarket companies as well.[quote]
http://www.noraracing.net/forum/view...p=24086#p24086
[quote]
Wait guys there's more! I met with the powers that be @ Montrose Auto Group, formerly Westside and they want in!!! They will be offering us parts, service and accessory discount not only at Westside, but any amd all of their dealerships. So no matter what you drive, they will hook you up.
I will be finalizing things on Monday to put some packages together with Chris Dunn, he 's the Accessories Manager @ Westside and has connections to a number of aftermarket companies as well.[quote]
#3128
"13B vs. Renesis" Discuss
iTrader: (28)
Per Marlin on the NORA site:
http://www.noraracing.net/forum/view...p=24086#p24086
Wait guys there's more! I met with the powers that be @ Montrose Auto Group, formerly Westside and they want in!!! They will be offering us parts, service and accessory discount not only at Westside, but any amd all of their dealerships. So no matter what you drive, they will hook you up.
I will be finalizing things on Monday to put some packages together with Chris Dunn, he 's the Accessories Manager @ Westside and has connections to a number of aftermarket companies as well.
http://www.noraracing.net/forum/view...p=24086#p24086
Wait guys there's more! I met with the powers that be @ Montrose Auto Group, formerly Westside and they want in!!! They will be offering us parts, service and accessory discount not only at Westside, but any amd all of their dealerships. So no matter what you drive, they will hook you up.
I will be finalizing things on Monday to put some packages together with Chris Dunn, he 's the Accessories Manager @ Westside and has connections to a number of aftermarket companies as well.
I'm probably awful at autoX and/or on a track anyway.
Stupid money.
#3131
TeethNThings.com
iTrader: (10)
Join Date: Mar 2008
Location: Mere seconds behind the leader...Doh!
Posts: 1,322
Likes: 0
Received 0 Likes
on
0 Posts
I need help with an excel spreadsheet function. If a cell contains the letters "OH" (for ohio), then cell =another cell.
I've got "=IF(U7282=OH, =J7282,"") But it's not working. Anybody know the correct semantics.
I've got "=IF(U7282=OH, =J7282,"") But it's not working. Anybody know the correct semantics.
#3134
TeethNThings.com
iTrader: (10)
Join Date: Mar 2008
Location: Mere seconds behind the leader...Doh!
Posts: 1,322
Likes: 0
Received 0 Likes
on
0 Posts
check out the videos;
http://drdomo.com/ElSalvadorVideo.aspx
http://drdomo.com/ElSalvadorVideo.aspx
#3135
"13B vs. Renesis" Discuss
iTrader: (28)
Doc; you're lucky you do something that actually ads value to society.
No one ever requests a meeting with human resources, and managing benefits doesn't really enhance anyone's life
... Plus I had to beg just to get time off to go to Germany and China (for my MBA) Stupid tether attaching me to my desk...
No one ever requests a meeting with human resources, and managing benefits doesn't really enhance anyone's life
... Plus I had to beg just to get time off to go to Germany and China (for my MBA) Stupid tether attaching me to my desk...
#3138
The devil made me do it
iTrader: (1)
Join Date: Jul 2007
Location: Colorado Springs, CO
Posts: 3,708
Likes: 0
Received 2 Likes
on
2 Posts
Jon has asked that everyone call him in the morning to verify if the move is a go. With the weather the way things are he wants to see what it is like before we all drive down there. He has no internet at the house and his cell phone does not allow him to read txt messages. Please call him.
#3141
TeethNThings.com
iTrader: (10)
Join Date: Mar 2008
Location: Mere seconds behind the leader...Doh!
Posts: 1,322
Likes: 0
Received 0 Likes
on
0 Posts
Doesn't' like that. Error message with "Ohio"
EDIT- Never mind, was just missing the " after oh above. Figured it out. Tnx
Will that work if there's other data in the cell, like city or zip code. Or only if only state data is present?
EDIT- Never mind, was just missing the " after oh above. Figured it out. Tnx
Will that work if there's other data in the cell, like city or zip code. Or only if only state data is present?
Last edited by docgatorx8er; 01-10-2009 at 07:07 AM.
#3142
The devil made me do it
iTrader: (1)
Join Date: Jul 2007
Location: Colorado Springs, CO
Posts: 3,708
Likes: 0
Received 2 Likes
on
2 Posts
It will only trigger if the cell contains OH or Ohio...nothing else. Best bet is to go through the data and clean it up. Best way to do that would be to go to Tools >> Filter >> Auto Filter and find the weird data and correct it.
#3143
TeethNThings.com
iTrader: (10)
Join Date: Mar 2008
Location: Mere seconds behind the leader...Doh!
Posts: 1,322
Likes: 0
Received 0 Likes
on
0 Posts
Each venue provides data in a different format. Some provide the state as a separate entry, others combine city, state, zip in a single cell. I really can't remove the extraneous data, because I need that record. Unless you can suggest a way to.
#3146
TeethNThings.com
iTrader: (10)
Join Date: Mar 2008
Location: Mere seconds behind the leader...Doh!
Posts: 1,322
Likes: 0
Received 0 Likes
on
0 Posts
I think that works!!! Now. the only false answer is if the city has "oh" in it somewhere. Any way to also highlight the cell so I can go back and verify data. (I know, I'm pushing it here) I really appreciate it!
BTW - I owe you a non-alcoholic umbrella drink!
BTW - I owe you a non-alcoholic umbrella drink!
Last edited by docgatorx8er; 01-10-2009 at 07:41 AM.
#3150
Grasshopper
iTrader: (1)
Well I'm at my dad's now.
Obviously snow was HORRIBLE and I had to get the U-Haul today because they are closed tomorrow, will charge me a $50 fine for canceling, AND my utilities are being shut off Monday.
But with the Akron streets so horrible I drove the U-Haul to my dad's and he is going to bring it down tomorrow morning.
I have no choice but to move tomorrow, so hopefully the weather & roads are better.
Then to make matters worse, my snow blower started back-firing!
I replaced the spark plug because it was bad looking, but that didn't work.
So I took it to my dad's and we took it apart.
It runs better, but I'll need to take it apart again to tweak it more (which I can do in my new garage).
Anyway... if anyone still wants to help tomorrow, give me a call.
If its still bad out, I would rather you guys be safe and stay off the roads.
I'll be back online Monday night... so I'll talk to everyone then.
Obviously snow was HORRIBLE and I had to get the U-Haul today because they are closed tomorrow, will charge me a $50 fine for canceling, AND my utilities are being shut off Monday.
But with the Akron streets so horrible I drove the U-Haul to my dad's and he is going to bring it down tomorrow morning.
I have no choice but to move tomorrow, so hopefully the weather & roads are better.
Then to make matters worse, my snow blower started back-firing!
I replaced the spark plug because it was bad looking, but that didn't work.
So I took it to my dad's and we took it apart.
It runs better, but I'll need to take it apart again to tweak it more (which I can do in my new garage).
Anyway... if anyone still wants to help tomorrow, give me a call.
If its still bad out, I would rather you guys be safe and stay off the roads.
I'll be back online Monday night... so I'll talk to everyone then.