Forza-Tuning.net
September 04, 2010, 08:11:24 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: The home of Targa Forza  Check it out!!
 
   Home   Help Search Calendar Login Register  
Pages: [1]
  Print  
Author Topic: Do The Vertical!  (Read 78 times)
Blooze
Administrator
Muscle Car Guru
*****
Posts: 2579


...metaphysically wrinkle free.


View Profile
« on: July 26, 2010, 08:23:32 AM »

Vertical?  As opposed to Horizontal, I suppose.  So, what is this Vertical, and how do you do it?

Wow, I am so glad you asked that!  Otherwise this was gonna be a tuff thread to finish out...

My "rollup" spreadsheet for the various classes is set up with the classes in Rows and the Environments in columns.  The times for the environments are totaled across the spreadsheet, from I3 to AG3 is F Class
Code:
=SUM(I3:AG3)
If all is right with the world and I haven't interpolated a number someplace, the results of that function should be equal to the aggrigate found on the leaderboards.

However, a time we don't have is an aggrigate by environment.  My total time for all classes on Camino Viejo is... ? ? ?  But if I were to add the following function, say... to Row 15 of my spreadsheet
Code:
=SUM(K3:K14)
that is exactly what I would have.

Running Horizontal is taking on all environments in a single class.

Running Vertical is taking on a single environment in all classes.  (incidentally, vertical is how my gaposis program is laid out)

We have a number of spreadsheets all set up along with the programs to run with them, "Chasing Blooze", RWT or FIL, QR2, Targa - they are all Horizontal.

So, in a fit of boredom t'other day I decided to run Vertical for a while.  As you can no doubt guess, the Old Road is the environment that I have chosen for this inaugural run.

"Okay, what is the big deal?  Ya grab an F class car and run all the Camino Viejo tracks, then ya grab an E class car and ya run all the Camino tracks..."

 Embarrassed

Well yeah, it is sort of like that.  But then, if one is a tad OCD, and prone to devising complications where none exist - then it can be a bit different.

There is a template attached to this post - VTrax.xls.  You can use that to track the times of many cars on the Camino Viejo Ribbons.  It has all the aminities of doing totals, hilighting the best times, tracking the money if you care to run them in a Private room...  all that stuff.  You could run all the classes on this single sheet, or duplicate the sheet and have one for each class... put 'em in a workbook.

One thing about running vertical is that you move through the classes quicker, more building... more tuning... more stress on your driving skills.  A change of pace...

You can even set yourself up with a Gaposis Goal if you want to.
  • Set the best F Class aggrigate that you can, in this case, for Camino Viejo.
  • Now do the same thing in R1.  There is a rather extreme adjustment to be made doing this, but it is good for you Wink
  • Now subtract the R1 total from the F Class total and divide the result by 9.
Code:
(711.325 - 479.887) / 9 = 25.715
This is a slope, if you will, of 25 seconds per class.  If you were to subtract 25.715 from your F Class total, you would have a number for your E Class total that would conform to that slope.  And so on...  subtract 25.715 from the E Class goal and you have your D Class goal... etc.

If you want, you can create a graph with proposed and actual on it... that is cool to see.  All sorts of stuff you can do.  

Or you can just grab a D Class car and run all the Camino Ribbons...

there is a law, kind of like Murphy's rule about luck...  You only get out of it what you're willing to put into it...

Smiley $

BTW - my current Vertical Total (VT) for Camino Viejo is 6531.417 seconds.  That translates into 1:48:51.417.  My slope or gap indicates that I can lose 103 seconds if I can hit it in all 10 classes.  Many of you will drop quite a few more seconds - there's eight ribbons per class.  We'll see how it turns out.
« Last Edit: July 26, 2010, 08:25:31 AM by Blooze » Logged

Watch out for my Dots...
GT = blooze46
Warped Passage
Sheet Metal Fabricator
**
Posts: 68


View Profile
« Reply #1 on: July 26, 2010, 10:15:44 AM »

I have considered something sort of like this, when I have been bored with just going through a single class. I will run the same track in multiple classes as a change of pace. I just have not tracked it on a spread sheet.
Logged
Blooze
Administrator
Muscle Car Guru
*****
Posts: 2579


...metaphysically wrinkle free.


View Profile
« Reply #2 on: July 26, 2010, 11:00:01 AM »

Gasp  No Spreadsheet??!   Shocked
Logged

Watch out for my Dots...
GT = blooze46
Warped Passage
Sheet Metal Fabricator
**
Posts: 68


View Profile
« Reply #3 on: July 26, 2010, 01:11:37 PM »

Since the PI gap is not the same per class shouldn't your actual/projected gap per environment reflect that difference?
Logged
Blooze
Administrator
Muscle Car Guru
*****
Posts: 2579


...metaphysically wrinkle free.


View Profile
« Reply #4 on: July 26, 2010, 02:18:02 PM »

I have it calculated both ways in the actual Gaposis program.  I was trying to keep it simple... Smiley

If one were to want to do it that way, then the gap is calculated at 9% of the overall gap for classes F thru B, and 13% for the B thru R1 gaps.

Grin $
Logged

Watch out for my Dots...
GT = blooze46
TheJohnNewton
Engineer
*****
Posts: 918


View Profile
« Reply #5 on: July 30, 2010, 07:00:59 AM »

So are you using the new Microsoft Gaposis 2010?
Logged

GT: Qmole
Blooze
Administrator
Muscle Car Guru
*****
Posts: 2579


...metaphysically wrinkle free.


View Profile
« Reply #6 on: July 30, 2010, 12:24:41 PM »

Them Sons-a-bitches!!!  Did they steal another one of my Ideas???

Grin $
Logged

Watch out for my Dots...
GT = blooze46
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
Page created in 0.106 seconds with 18 queries.