Camaro5 Chevy Camaro Forum / Camaro ZL1, SS and V6 Forums - Camaro5.com
 
ADM PERFORMANCE
Go Back   Camaro5 Chevy Camaro Forum / Camaro ZL1, SS and V6 Forums - Camaro5.com > Technical Camaro Topics > Dragstrip and Launch Techniques Discussion


Reply
 
Thread Tools
Old 11-07-2013, 09:27 PM   #15
Merc
In The Circle
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM M6
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 10,380
Quote:
Originally Posted by SSE 4 2SS View Post
This, it will also prevent you from having to insert new rows and delete old ones... When you get a new fast list member just go to the bottom row... 30 I think, and type in the new member and data right over the old slowest listed time row, then sort them... It'll automatically place them in order...

If you get an upgraded time from someone already in the list, find their row, type in the new info, then sort... It'll again automatically place all of them in order...

Here's a trick for those with enough knowledge to be hazardous... Open the spread sheet, make the changes... Do not save it yet... Look to make sure everything is as you want it... Then save it...

If you screw up along the way and can't fix it, or are not sure what happened, then just close it and reopen it and it'll be back to original... Now if the settings on the puter are set to auto save periodically, this may create an issue...

Another way to do this is excel, file, open save as... Save the doc as a new sheet, makes the changes then when all is good, save it as the original doc with the same title.., it'll ask if you want to replace it... Click yes and carry on...

One more... In this type of sheet where you have a constant number of rows... Top 30 or whatever, new info can be typed over the top of old...

There is never a reason to delete info in a cell or in a row... If you just want to clear the info from a cell or a row, highlight it, right click, and clear contents...

Not terribly important in a sheet with no links, but a good habit never the less...
Sounds good Bud, but the spread sheet link is a record of all runs. So in other words when I add a fast time the list expands then I screen shot the top 30 and attach that. So the member that was #30 gets pushed to #31 and so on. Like I said earlier I know just enough to be dangerous.

__________________

Last edited by Merc; 11-07-2013 at 10:35 PM.
Merc is online now   Reply With Quote
Old 11-07-2013, 10:20 PM   #16
Merc
In The Circle
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM M6
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 10,380
Quote:
Originally Posted by Pro Stock John View Post
For your lists I would shorten "Converter" to "TC."

Great work btw, lists take more work than folks realize.
THX for your input, but I would have to go back and change all the list's from converter to TC. I appreciate your kind words.

__________________
Merc is online now   Reply With Quote
Old 11-07-2013, 10:26 PM   #17
mlee
Charter Circle Member
 
mlee's Avatar
 
Drives: Number Twenty-Three
Join Date: Oct 2008
Location: Conroe, TX
Posts: 27,555
Looks like you have it under control now.

I was unaware you had problems with the new sheets.
__________________
.
mlee is offline   Reply With Quote
Old 11-07-2013, 10:31 PM   #18
Merc
In The Circle
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM M6
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 10,380
Quote:
Originally Posted by mlee View Post
Looks like you have it under control now.

I was unaware you had problems with the new sheets.
No problems, just trying to work smarter and save time. Once again the C5 community comes through in flying colours.


__________________
Merc is online now   Reply With Quote
Old 11-11-2013, 12:00 PM   #19
Sales @ CAI Inc



 
Sales @ CAI Inc's Avatar
 
Drives: 2010 SS/RS Supercharged 427 Build
Join Date: Nov 2010
Location: Michigan
Posts: 4,791
Quote:
Originally Posted by Merc View Post
THX for your input, but I would have to go back and change all the list's from converter to TC. I appreciate your kind words.

Just an FYI, you may already know this, but you can use the "Search & Replace" or "Find & Replace" function which will find the word "converter" and change it to "TC" everywhere in the entire sheet for you with one click. Rather than changing each one individually it will find them all and replace them all at one time. If you had to go in and find that word and replace it on 10 sheets, the entire process should take no more than 2-3 minutes, if that. You tell them what word to find and in which cells, rows, or columns, and what to replace it with and bam its done!
Sales @ CAI Inc is offline   Reply With Quote
Old 11-12-2013, 03:13 PM   #20
Merc
In The Circle
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM M6
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 10,380
Quote:
Originally Posted by Sales @ CAI Inc View Post
Just an FYI, you may already know this, but you can use the "Search & Replace" or "Find & Replace" function which will find the word "converter" and change it to "TC" everywhere in the entire sheet for you with one click. Rather than changing each one individually it will find them all and replace them all at one time. If you had to go in and find that word and replace it on 10 sheets, the entire process should take no more than 2-3 minutes, if that. You tell them what word to find and in which cells, rows, or columns, and what to replace it with and bam its done!
I gave it a go just to see, but it didn't seem to work.
__________________
Merc is online now   Reply With Quote
Old 11-13-2013, 12:52 PM   #21
Sales @ CAI Inc



 
Sales @ CAI Inc's Avatar
 
Drives: 2010 SS/RS Supercharged 427 Build
Join Date: Nov 2010
Location: Michigan
Posts: 4,791
Quote:
Originally Posted by Merc View Post
I gave it a go just to see, but it didn't seem to work.
Hmmm, not sure what you are doing wrong. Maybe watching this short video on YouTube will help:


Sales @ CAI Inc is offline   Reply With Quote
Old 11-13-2013, 12:59 PM   #22
mlee
Charter Circle Member
 
mlee's Avatar
 
Drives: Number Twenty-Three
Join Date: Oct 2008
Location: Conroe, TX
Posts: 27,555
Quote:
Originally Posted by Merc View Post
I gave it a go just to see, but it didn't seem to work.
I can format them for you if you need. Not sure if I still have access or not.
__________________
.
mlee is offline   Reply With Quote
Old 11-13-2013, 01:14 PM   #23
The Stig
knows 2 facts about ducks
 
The Stig's Avatar
 
Drives: ...and they're both wrong
Join Date: Aug 2009
Location: The HMS Invincible
Posts: 26,132
Quote:
Originally Posted by mlee View Post
I can format them for you if you need. Not sure if I still have access or not.
I have Access and can do it if you can't.

I'd also recommend putting all of the rows/columns inside of a table - that way new rows are added automatically whenever a time gets added updated
__________________
Click to view my build thread
The Stig is offline   Reply With Quote
Old 11-13-2013, 01:19 PM   #24
Merc
In The Circle
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM M6
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 10,380
Quote:
Originally Posted by mlee View Post
I can format them for you if you need. Not sure if I still have access or not.
No need for that right now. Speaking of access I want to give you access just in case something happens to me. I don't want the next person to have to start from scratch like I did. As well if I stepped away from this I would give access to the next member and they could just carry on where I left off with the current Google Doc spread sheets.

__________________
Merc is online now   Reply With Quote
Old 11-13-2013, 01:21 PM   #25
Merc
In The Circle
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM M6
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 10,380
Quote:
Originally Posted by Sales @ CAI Inc View Post
Hmmm, not sure what you are doing wrong. Maybe watching this short video on YouTube will help:


THX Bud. I'll have a look.

__________________
Merc is online now   Reply With Quote
Old 11-13-2013, 08:10 PM   #26
Merc
In The Circle
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM M6
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 10,380
Quote:
Originally Posted by The Stig View Post
I have Access and can do it if you can't.

I'd also recommend putting all of the rows/columns inside of a table - that way new rows are added automatically whenever a time gets added updated
You have access to my Google Doc account?
__________________
Merc is online now   Reply With Quote
Old 11-13-2013, 08:11 PM   #27
The Stig
knows 2 facts about ducks
 
The Stig's Avatar
 
Drives: ...and they're both wrong
Join Date: Aug 2009
Location: The HMS Invincible
Posts: 26,132
Quote:
Originally Posted by Merc View Post
You have access to my Google Doc account?
No.
__________________
Click to view my build thread
The Stig is offline   Reply With Quote
Old 11-13-2013, 09:26 PM   #28
Merc
In The Circle
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM M6
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 10,380
Quote:
Originally Posted by The Stig View Post
I have Access and can do it if you can't.

I'd also recommend putting all of the rows/columns inside of a table - that way new rows are added automatically whenever a time gets added updated
That would be cool if I could get that feature working.

__________________
Merc is online now   Reply With Quote
 
Reply

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

Forum Jump


All times are GMT -5. The time now is 05:40 PM.


Powered by vBulletin® Version 3.8.9 Beta 4
Copyright ©2000 - 2016, vBulletin Solutions, Inc.