Author Topic: Do The Vertical!  (Read 453 times)

Blooze

  • Administrator
  • Muscle Car Guru
  • *****
  • Posts: 3388
  • ...It's never too early to Panic.
    • View Profile
Do The Vertical!
« 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: [Select]
=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: [Select]
=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..."

 :-[

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 ;)
  • Now subtract the R1 total from the F Class total and divide the result by 9.
Code: [Select]
(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...

:) $

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 »
GTs: Blooze46 / GICheeze

Proud Owner: Perfect Drift = 0 Badge

EXOR Warpedo

  • Dyno Technician
  • ***
  • Posts: 173
    • View Profile
Re: Do The Vertical!
« 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.

Blooze

  • Administrator
  • Muscle Car Guru
  • *****
  • Posts: 3388
  • ...It's never too early to Panic.
    • View Profile
Re: Do The Vertical!
« Reply #2 on: July 26, 2010, 11:00:01 AM »
Gasp  No Spreadsheet??!   :o
GTs: Blooze46 / GICheeze

Proud Owner: Perfect Drift = 0 Badge

EXOR Warpedo

  • Dyno Technician
  • ***
  • Posts: 173
    • View Profile
Re: Do The Vertical!
« 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?

Blooze

  • Administrator
  • Muscle Car Guru
  • *****
  • Posts: 3388
  • ...It's never too early to Panic.
    • View Profile
Re: Do The Vertical!
« 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... :)

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.

;D $
GTs: Blooze46 / GICheeze

Proud Owner: Perfect Drift = 0 Badge

TheJohnNewton

  • Muscle Car Guru
  • *****
  • Posts: 1106
    • View Profile
Re: Do The Vertical!
« Reply #5 on: July 30, 2010, 07:00:59 AM »
So are you using the new Microsoft Gaposis 2010?
GT: Qmole
GT: TheJohnNewton - Muscle Cars Only
Proud Owner: Perfect Drift = 0 Badge

Blooze

  • Administrator
  • Muscle Car Guru
  • *****
  • Posts: 3388
  • ...It's never too early to Panic.
    • View Profile
Re: Do The Vertical!
« Reply #6 on: July 30, 2010, 12:24:41 PM »
Them Sons-a-bitches!!!  Did they steal another one of my Ideas???

;D $
GTs: Blooze46 / GICheeze

Proud Owner: Perfect Drift = 0 Badge