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

Dragstrip and Launch Techniques Discussion 1/4 mile, 1/8 mile, launch discussions.

Reply
 
Thread Tools
Old 11-05-2013, 03:28 PM   #1
Merc
COTW 12/5/11
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 7,789
Exel Spreadsheet Experts

Do we have any exel spread sheet experts? I'm working with Google Doc's spread sheet to redo and bring the 60' fast list up to date. While I was data entering on the drag radial sheet out of the blue it would not accept zero's at the end of the 60' time and gear ratio. I had to use O's. Can anybody out there help?
__________________
Merc is offline   Reply With Quote
Old 11-05-2013, 03:46 PM   #2
blazzin1


 
blazzin1's Avatar
 
Drives: 2010 2SS/RS R6P
Join Date: Nov 2008
Location: Seffner, FL
Posts: 4,254
Highlight all the blocks that you want to change the formatting on. Then, on the "Home" tab at the top, change the number format from "General" to "Text" using the pull-down menu. Also, right below that number format pull-down menu is an option to increase the decimal place of your numbers. Just make sure that all the cells you want to change the formatting on are highlighted when selecting these options.
__________________
ARH 1-7/8" LT Headers w/HF Cats, Stainless Works 3" Retro-Chambered Cat Back, New Era OTR CAI, AAM 3.91 R&P, Eaton TrueTrac Posi,
JRE Billet Caps, LPW Diff Cover, BMR Drag Race Suspension Package (DRP007), BMR Toe Rods (TR004), BMR Xtreme Drag Bar (XSB004),
BMR Sway Bar End Links (ELK004), BMR Driveshaft Safety Loop (DSL014), Farks No-Hop UCA Bushings, Pfadt Solid Subframe Bushings,
QA1 DA Front Coilovers, Strange Engineering DA Rear Coilovers, Mike Norris Catch-Can, V-Max CNC PTB, Aeromotive Fuel Rails.
blazzin1 is offline   Reply With Quote
Old 11-05-2013, 03:48 PM   #3
Merc
COTW 12/5/11
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 7,789
Thanks I'll go have a look.
__________________
Merc is offline   Reply With Quote
Old 11-05-2013, 03:49 PM   #4
GunnyG
Da WHALE
 
GunnyG's Avatar
 
Drives: 2014 Stingray, 2012 Panamera
Join Date: Dec 2011
Location: Oceanside, Ca - Originally from KCMO
Posts: 8,763
Inside Excel, right-click on any of the cells. Click on Format Cells... On the number tab, highlight "Number" and tell how many decimals you want. Click Ok to apply that to your cell. Grab the right/lower corner of the cell. Drag that down to copy the format onto your other cells. DONE! I think your number tab was set to General or Text.
__________________
GunnyG is offline   Reply With Quote
Old 11-05-2013, 03:57 PM   #5
Merc
COTW 12/5/11
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 7,789
Thanks Guy's I tried blazzin's method and it's all fixed.

__________________
Merc is offline   Reply With Quote
Old 11-05-2013, 04:24 PM   #6
blazzin1


 
blazzin1's Avatar
 
Drives: 2010 2SS/RS R6P
Join Date: Nov 2008
Location: Seffner, FL
Posts: 4,254
Glad I could help!!!
__________________
ARH 1-7/8" LT Headers w/HF Cats, Stainless Works 3" Retro-Chambered Cat Back, New Era OTR CAI, AAM 3.91 R&P, Eaton TrueTrac Posi,
JRE Billet Caps, LPW Diff Cover, BMR Drag Race Suspension Package (DRP007), BMR Toe Rods (TR004), BMR Xtreme Drag Bar (XSB004),
BMR Sway Bar End Links (ELK004), BMR Driveshaft Safety Loop (DSL014), Farks No-Hop UCA Bushings, Pfadt Solid Subframe Bushings,
QA1 DA Front Coilovers, Strange Engineering DA Rear Coilovers, Mike Norris Catch-Can, V-Max CNC PTB, Aeromotive Fuel Rails.
blazzin1 is offline   Reply With Quote
Old 11-05-2013, 07:53 PM   #7
etmx183

 
etmx183's Avatar
 
Drives: 2012 Camaro 2LT RS, 04 Turbo Busa
Join Date: Mar 2012
Location: Baltimore, Maryland
Posts: 1,004
People think it's only car stuff shared on here. We have all areas covered. The Forum proves to be great again in more areas than just cars!!!
__________________
CAI intake, RX catch can, NYTREX Nitrous,RX Ported Throttle body, APEX air scoop & washer relocation kit,, BMR diff bushings, cradle bushings, driveshaft loop and tunnel brace, trailing arms, toe arms, Hurst Roll control, Flex-a-lite transmission cooler, SOLO HFCs, M/T 20" D/Rs, FTI 3400 stall converter, JacFab ported intake manifold and upper intake isolator (12/13) Solo cat back Mach X system (2/14), SS diff 3.91 gears (11/2013) Weld RT-S 17x10 & 17x5 (4/2014)
TUNING BY: HP Tuners /MATT@FSP
( 1.63 60' / 12.238@107.62 10/25/2013 )
Refusing to grow older, I just go faster.
etmx183 is offline   Reply With Quote
Old 11-05-2013, 09:15 PM   #8
Merc
COTW 12/5/11
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 7,789
Quote:
Originally Posted by etmx183 View Post
People think it's only car stuff shared on here. We have all areas covered. The Forum proves to be great again in more areas than just cars!!!
Very COOOOOOOL! I have another question to ask tomorrow
about spread sheets. I'm sure it will get answered.




__________________

Last edited by Merc; 11-07-2013 at 10:21 PM.
Merc is offline   Reply With Quote
Old 11-05-2013, 10:56 PM   #9
grocerygetter
instigator
 
grocerygetter's Avatar
 
Drives: 2010 SS (2ss/rs, auto, SW/IOstripe)
Join Date: Jan 2010
Location: 72034
Posts: 3,768
I can help too if needed...I live in excel.
__________________
-John S.

2014 GMC CC Z71
2004 CTS-V
2010 Camaro 2ss/rs---SOLD 4/15/14
-654whp with a few cosmetic things, Pfadt suspension, Vortech, CircleD, GPI ss3 vvt bump stick, gears, stuff in between,18" TSW N'rings for drag duty, 20" Forgestar F14s for street.

Thanks to:
Tony@ dv8motoring
rhino@ Gwatney Chevrolet/GPI Jacksonville AR
TCAudio in Benton AR
grocerygetter is offline   Reply With Quote
Old 11-06-2013, 10:15 AM   #10
Merc
COTW 12/5/11
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 7,789
Quote:
Originally Posted by grocerygetter View Post
I can help too if needed...I live in excel.
Nice! Here is my Question:

When I have to move a member up the fast list I adjust his time in the current spot that he holds, then I insert a row in the correct place on the list. Then go back to he corrected row and copy and paste that row into blank row that I inserted. Then back to the original row and delete it and then copy and paste all the info below and move it up a row.

Is there a way that once I delete that row that exel would automatically move it up on it's own?

__________________
Merc is offline   Reply With Quote
Old 11-06-2013, 10:28 AM   #11
pancherj
Account Suspended
 
Drives: 2010 Camaro SS
Join Date: Aug 2013
Location: Central PA
Posts: 54
Yes. Highlight the column that is getting sorted by lowest to highest (If it is column "A", just click on the A at top and it will select everything in that row). Go up to the top right and there is a "Sort & Filter" tool. Click on that. Choose Smallest to Largest. It will bring up a window that says "Sort Warning". Pick the option for "Expand the Selection". This will drag the adjacent cells along with the 60' cell.
pancherj is offline   Reply With Quote
Old 11-07-2013, 03:37 PM   #12
Merc
COTW 12/5/11
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 7,789
Quote:
Originally Posted by pancherj View Post
Yes. Highlight the column that is getting sorted by lowest to highest (If it is column "A", just click on the A at top and it will select everything in that row). Go up to the top right and there is a "Sort & Filter" tool. Click on that. Choose Smallest to Largest. It will bring up a window that says "Sort Warning". Pick the option for "Expand the Selection". This will drag the adjacent cells along with the 60' cell.
Sounds scary. I know just enough to be dangerous with Exel.

__________________
Merc is offline   Reply With Quote
Old 11-07-2013, 04:25 PM   #13
Pro Stock John
Shizzler
 
Pro Stock John's Avatar
 
Drives: 2010 SS / 1951 Mercury
Join Date: May 2009
Location: Chicago, IL
Posts: 4,200
For your lists I would shorten "Converter" to "TC."

Great work btw, lists take more work than folks realize.
__________________
PROJECT HEAVY CHEVY: 2010 Camaro SS/RS |1SS | L99 | CGM
13.15@106 1.95 | Stock
12.06@110 1.70 | Bolt-Ons
Mods: GPI Tune | Bo White PTP | Kooks Headers | Circle D 3200 | New Era OTR | RCR Ported Intake | 305/45R18 NT05R | Powerbond UDP

LSX Record List: http://motorhed.com/xf/threads/lsx-r...the-list.6022/
Pro Stock John is offline   Reply With Quote
Old 11-07-2013, 06:42 PM   #14
SSE 4 2SS
Boosted Moderator
 
SSE 4 2SS's Avatar
 
Drives: LS-3 429 TT with other odds-n-ends
Join Date: Sep 2009
Location: Kyle Tx
Posts: 13,085
Send a message via AIM to SSE 4 2SS Send a message via Yahoo to SSE 4 2SS
Quote:
Originally Posted by pancherj View Post
Yes. Highlight the column that is getting sorted by lowest to highest (If it is column "A", just click on the A at top and it will select everything in that row). Go up to the top right and there is a "Sort & Filter" tool. Click on that. Choose Smallest to Largest. It will bring up a window that says "Sort Warning". Pick the option for "Expand the Selection". This will drag the adjacent cells along with the 60' cell.
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...
__________________
SSE 4 2SS is offline   Reply With Quote
Old 11-07-2013, 09:27 PM   #15
Merc
COTW 12/5/11
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 7,789
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 offline   Reply With Quote
Old 11-07-2013, 10:20 PM   #16
Merc
COTW 12/5/11
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 7,789
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 offline   Reply With Quote
Old 11-07-2013, 10:26 PM   #17
mlee
H-Town Camaro Club
 
mlee's Avatar
 
Drives: Number Twenty-Three
Join Date: Oct 2008
Location: Conroe, TX
Posts: 22,774
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
COTW 12/5/11
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 7,789
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 offline   Reply With Quote
Old 11-11-2013, 12:00 PM   #19
Sales @ CAI Inc



 
Sales @ CAI Inc's Avatar
 
Drives: 2010 SS/RS CAI Inc. CAI, Cam, Tune
Join Date: Nov 2010
Location: Michigan
Posts: 3,680
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!
__________________
Call Us: 810.531.0121 (Click Sig Pic for Website)
Sales @ CAI Inc is offline   Reply With Quote
Old 11-12-2013, 03:13 PM   #20
Merc
COTW 12/5/11
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 7,789
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 offline   Reply With Quote
Old 11-13-2013, 12:52 PM   #21
Sales @ CAI Inc



 
Sales @ CAI Inc's Avatar
 
Drives: 2010 SS/RS CAI Inc. CAI, Cam, Tune
Join Date: Nov 2010
Location: Michigan
Posts: 3,680
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:


__________________
Call Us: 810.531.0121 (Click Sig Pic for Website)
Sales @ CAI Inc is offline   Reply With Quote
Old 11-13-2013, 12:59 PM   #22
mlee
H-Town Camaro Club
 
mlee's Avatar
 
Drives: Number Twenty-Three
Join Date: Oct 2008
Location: Conroe, TX
Posts: 22,774
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



 
The Stig's Avatar
 
Drives: out of the ashes
Join Date: Aug 2009
Location: Northern VA
Posts: 26,649
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
COTW 12/5/11
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 7,789
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 offline   Reply With Quote
Old 11-13-2013, 01:21 PM   #25
Merc
COTW 12/5/11
 
Merc's Avatar
 
Drives: 2010 Camaro 2SSRS IOM
Join Date: May 2009
Location: Abbotsford BC Canada
Posts: 7,789
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 offline   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:36 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.