Season 6 Points

burnsy · July 25th, 2007, 03:30 AM

Gearing up for the new season, season 6 is zipped up for download if needed.
Season 6 overall points and per race points - 3.31 MB/60 KB upload = <1 min
Season 6 Points excel sheet
Season 6 replays - 79.2 MB/60KB = 22.5 min
Season 6 stats - 1.45 MB/60KB = <1 min

burnsy · July 27th, 2007, 12:06 AM

what about something different like this below?
test

sweetreid - 29
burnsy1882 - 25
laanp - 21
Slartibartfast - 20
phatdragonx - 16
Knight_Atack - 11
frostystclair - 11
neo-truth - 9
Dr3vil - 8
Spinjack - 6
leadtail - 3
cwmax - 2
Cargo - 1

Race Results

Track: Autocross Autocross
Date: 7/3/2007 12:30:00 PM
Laps: 18
Drivers: 10 / 13

phatdragonx
burnsy1882
sweetreid
Slartibartfast
Knight_Atack
neo-truth
laanp
Dr3vil
Spinjack
frostystclair

Track: Autocross Autocross
Date: 7/3/2007 12:29:56 PM
Laps: 18
Drivers: 10 / 13

laanp
sweetreid
burnsy1882
Slartibartfast
phatdragonx
Dr3vil
Spinjack
leadtail
cwmax
Cargo

Track: Autocross Autocross
Date: 7/3/2007 12:29:52 PM
Laps: 18
Drivers: 7 / 13

sweetreid
frostystclair
burnsy1882
laanp
Slartibartfast
Knight_Atack
neo-truth

pdanev · July 27th, 2007, 12:28 AM

Does that make the task of keeping points easier? You would still need to add up the points per player and make a list of it, or am I misunderstanding your post? images/smilies/dunno.gif

burnsy · July 27th, 2007, 12:34 AM

true, never mind. there's nothing wrong with the above spreadsheet, was just playing around with other stuff.

pdanev · July 27th, 2007, 12:47 AM

Well to be honest I don't mind which way the results are shown, one way or the other doesn't really matter. I'm glad you took over this work, so whichever way you deliver the results is up to your preference. It's just that I don't think there is a way to speed up the process. The only way I can imagine it is to make the process somehow automated, getting data from server (e.g. by running lfs stat while race) which is then automatically transformed into points, giving the results in an html table for instance. But I don't know the current progress of lfs stat and what happened to it since the new insim. Maybe you can work out something with FireFox to make things automated, you guys are quite familiar with servers scripts insim etc. images/smilies/smile.gif

burnsy · July 27th, 2007, 03:11 AM

might be a good idea, been looking at maybe mySQL too, but we'll see.

ESPNSTI · July 27th, 2007, 03:35 AM

Another option may be to import / query against the .csv and/or html files that are produced by lfsstats.

Mischief007 · September 19th, 2007, 06:35 PM

What extra points do you guys want to count. Is it just fastest lap this time around?

ESPNSTI · September 19th, 2007, 07:31 PM

Yes, 1 point for fastest lap between the two races.

I worked on creating an excel spreadsheet that uses data from the stats files (manually copied using IE's export to excel function at this point).
It's nothing fancy yet, and I'm not sure I'll have any time to work on it, but here it is.

EDIT: Changed it so that it uses a web query against the stat files inside the spread sheet.

Points:
http://espnsti.iridiumonline.info/LF...FGS6Points.htm

Excel files:
http://espnsti.iridiumonline.info/LF...GS6Points.xlsx
http://espnsti.iridiumonline.info/LF...FGS6Points.xls (97-2003 format)

Mischief007 · September 19th, 2007, 10:35 PM

What do you guys think? Entered into a SQL database and then a report made images/smilies/smile.gif

.

http://files.phyrefile.com/file/2007.../FinalGear.pdf

epp_b · September 22nd, 2007, 01:42 PM

Dang, I'm just outside the points bracket! images/smilies/sad.gif

ESPNSTI · September 22nd, 2007, 08:31 PM

Updated my points page, but I still used the (10, 8, 6) style points and not the (10, 9, 8) format that Burnsy used.
Which one did we decide to use this season?

Points:
http://espnsti.iridiumonline.info/LF...FGS6Points.htm

Excel files:
http://espnsti.iridiumonline.info/LF...GS6Points.xlsx
http://espnsti.iridiumonline.info/LF...FGS6Points.xls (97-2003 format)

pdanev · September 22nd, 2007, 08:35 PM

A1GP style - 10 9 8, just like last season.

edit: I looked at the times, and it looks like I'm getting the 1 extra point. images/smilies/vampire.gif

ESPNSTI · September 22nd, 2007, 08:43 PM

Quote:

Originally Posted by pdanev

A1GP style - 10 9 8, just like last season.

I must be losing my memory, I thought we used the old style points last season.
Ok, I'll change it to use that.

Quote:

Originally Posted by pdanev

edit: I looked at the times, and it looks like I'm getting the 1 extra point. images/smilies/vampire.gif

Ehm.. no, GraemeH ran a faster lap in the second race.

pdanev · September 22nd, 2007, 08:46 PM

1st race:
GraemeH 1:26.40
Me 1:25.79

2nd race:
GraemeH 1:25.75
Me 1:26.07

Combined my times are faster.

Btw, apparently we're using A1GP points from 2005, they use something different now.

edit: Wait, are we taking the best lap from both races, or are we adding them up? I thought we add up from both races and look at that total. Either way is ok with me, just that we should make thing clear, maybe I don't remember well...

ESPNSTI · September 22nd, 2007, 08:49 PM

Oh we're doing combined times, and not outright fastest lap across the races like in A1GP?

GraemeH · September 22nd, 2007, 08:50 PM

Then it's not a point for the fastest lap, it's a point for the fastest average :p

But if that's how it was calculated for the first race then that's fair.

July 25th, 2007, 03:30 AM	#1
burnsy Joined: Mar 25th, 2005 Last Online: 04:27 AM Location: Indiana, USA Age: 26 Posts: 635 Car: 2006 Ford Ranger FX4 LFS Status: Rep Power: 14	Season 6 Points Gearing up for the new season, season 6 is zipped up for download if needed. Season 6 overall points and per race points - 3.31 MB/60 KB upload = <1 min Season 6 Points excel sheet Season 6 replays - 79.2 MB/60KB = 22.5 min Season 6 stats - 1.45 MB/60KB = <1 min __________________ Top Gear Episode Guide & More \| Top Gear DVDs \| Team FinalGear.com \| Photo Gallery LOTA Grand Touring Cup Squad Champions: FinalGear Racing Last edited by burnsy; December 28th, 2007 at 02:49 AM. Reason: new points images

July 27th, 2007, 12:06 AM	#2
burnsy Joined: Mar 25th, 2005 Last Online: 04:27 AM Location: Indiana, USA Age: 26 Posts: 635 Car: 2006 Ford Ranger FX4 LFS Status: Rep Power: 14	what about something different like this below? test sweetreid - 29 burnsy1882 - 25 laanp - 21 Slartibartfast - 20 phatdragonx - 16 Knight_Atack - 11 frostystclair - 11 neo-truth - 9 Dr3vil - 8 Spinjack - 6 leadtail - 3 cwmax - 2 Cargo - 1 Race Results Track: Autocross Autocross Date: 7/3/2007 12:30:00 PM Laps: 18 Drivers: 10 / 13 phatdragonx burnsy1882 sweetreid Slartibartfast Knight_Atack neo-truth laanp Dr3vil Spinjack frostystclair Track: Autocross Autocross Date: 7/3/2007 12:29:56 PM Laps: 18 Drivers: 10 / 13 laanp sweetreid burnsy1882 Slartibartfast phatdragonx Dr3vil Spinjack leadtail cwmax Cargo Track: Autocross Autocross Date: 7/3/2007 12:29:52 PM Laps: 18 Drivers: 7 / 13 sweetreid frostystclair burnsy1882 laanp Slartibartfast Knight_Atack neo-truth __________________ Top Gear Episode Guide & More \| Top Gear DVDs \| Team FinalGear.com \| Photo Gallery LOTA Grand Touring Cup Squad Champions: FinalGear Racing

July 27th, 2007, 12:34 AM	#4
burnsy Joined: Mar 25th, 2005 Last Online: 04:27 AM Location: Indiana, USA Age: 26 Posts: 635 Car: 2006 Ford Ranger FX4 LFS Status: Rep Power: 14	true, never mind. there's nothing wrong with the above spreadsheet, was just playing around with other stuff. __________________ Top Gear Episode Guide & More \| Top Gear DVDs \| Team FinalGear.com \| Photo Gallery LOTA Grand Touring Cup Squad Champions: FinalGear Racing

July 27th, 2007, 03:11 AM	#6
burnsy Joined: Mar 25th, 2005 Last Online: 04:27 AM Location: Indiana, USA Age: 26 Posts: 635 Car: 2006 Ford Ranger FX4 LFS Status: Rep Power: 14	might be a good idea, been looking at maybe mySQL too, but we'll see. __________________ Top Gear Episode Guide & More \| Top Gear DVDs \| Team FinalGear.com \| Photo Gallery LOTA Grand Touring Cup Squad Champions: FinalGear Racing

July 27th, 2007, 03:35 AM	#7
ESPNSTI Your Guide to TG/FG Joined: Dec 9th, 2003 Last Online: August 28th, 2008 Location: Decorah, IA Age: 36 Posts: 4,291 Car: 2004 Subaru Impreza WRX STI (USDM) LFS Status: Rep Power: 34	Another option may be to import / query against the .csv and/or html files that are produced by lfsstats. __________________ Top Gear Episode Guide (Excel) \| Top Gear Episode Guide (HTML) \| Top Gear Classic Episode Guide (HTML) Other Top Gear Guides \| Fifth Gear Guides \| Clarkson's TV/Video List \| Tiff Needell's TV/Video List

July 27th, 2007, 12:28 AM	#3
pdanev Joined: Oct 4th, 2004 Last Online: Yesterday Location: Netherlands Age: 25 Posts: 5,642 LFS Status: Rep Power: 23	Does that make the task of keeping points easier? You would still need to add up the points per player and make a list of it, or am I misunderstanding your post?

July 27th, 2007, 12:47 AM	#5
pdanev Joined: Oct 4th, 2004 Last Online: Yesterday Location: Netherlands Age: 25 Posts: 5,642 LFS Status: Rep Power: 23	Well to be honest I don't mind which way the results are shown, one way or the other doesn't really matter. I'm glad you took over this work, so whichever way you deliver the results is up to your preference. It's just that I don't think there is a way to speed up the process. The only way I can imagine it is to make the process somehow automated, getting data from server (e.g. by running lfs stat while race) which is then automatically transformed into points, giving the results in an html table for instance. But I don't know the current progress of lfs stat and what happened to it since the new insim. Maybe you can work out something with FireFox to make things automated, you guys are quite familiar with servers scripts insim etc.

September 19th, 2007, 06:35 PM	#8
Mischief007 Joined: Dec 3rd, 2004 Last Online: August 22nd, 2008 Location: London, Ontario, Canada Age: 27 Posts: 4,333 Car: 2004 GP GTP CompG Rep Power: 23	What extra points do you guys want to count. Is it just fastest lap this time around? __________________ 2004 Pontiac Grand Prix GTP CompG - 3800 Gen 3 Supercharged V6 55,965 km - 34,775 miles

September 19th, 2007, 07:31 PM	#9
ESPNSTI Your Guide to TG/FG Joined: Dec 9th, 2003 Last Online: August 28th, 2008 Location: Decorah, IA Age: 36 Posts: 4,291 Car: 2004 Subaru Impreza WRX STI (USDM) LFS Status: Rep Power: 34	Yes, 1 point for fastest lap between the two races. I worked on creating an excel spreadsheet that uses data from the stats files (manually copied using IE's export to excel function at this point). It's nothing fancy yet, and I'm not sure I'll have any time to work on it, but here it is. EDIT: Changed it so that it uses a web query against the stat files inside the spread sheet. Points: http://espnsti.iridiumonline.info/LF...FGS6Points.htm Excel files: http://espnsti.iridiumonline.info/LF...GS6Points.xlsx http://espnsti.iridiumonline.info/LF...FGS6Points.xls (97-2003 format) __________________ Top Gear Episode Guide (Excel) \| Top Gear Episode Guide (HTML) \| Top Gear Classic Episode Guide (HTML) Other Top Gear Guides \| Fifth Gear Guides \| Clarkson's TV/Video List \| Tiff Needell's TV/Video List Last edited by ESPNSTI; September 20th, 2007 at 12:22 AM.

September 19th, 2007, 10:35 PM	#10
Mischief007 Joined: Dec 3rd, 2004 Last Online: August 22nd, 2008 Location: London, Ontario, Canada Age: 27 Posts: 4,333 Car: 2004 GP GTP CompG Rep Power: 23	What do you guys think? Entered into a SQL database and then a report made . http://files.phyrefile.com/file/2007.../FinalGear.pdf __________________ 2004 Pontiac Grand Prix GTP CompG - 3800 Gen 3 Supercharged V6 55,965 km - 34,775 miles Last edited by Mischief007; September 19th, 2007 at 10:38 PM.

September 22nd, 2007, 01:42 PM	#11
epp_b n00b of the year Joined: Jun 23rd, 2006 Last Online: 04:34 AM Location: Canadaland :) Posts: 4,147 Car: 1995 Nissan 240SX Rep Power: 28	Dang, I'm just outside the points bracket!

September 22nd, 2007, 08:31 PM	#12
ESPNSTI Your Guide to TG/FG Joined: Dec 9th, 2003 Last Online: August 28th, 2008 Location: Decorah, IA Age: 36 Posts: 4,291 Car: 2004 Subaru Impreza WRX STI (USDM) LFS Status: Rep Power: 34	Updated my points page, but I still used the (10, 8, 6) style points and not the (10, 9, 8) format that Burnsy used. Which one did we decide to use this season? Points: http://espnsti.iridiumonline.info/LF...FGS6Points.htm Excel files: http://espnsti.iridiumonline.info/LF...GS6Points.xlsx http://espnsti.iridiumonline.info/LF...FGS6Points.xls (97-2003 format) __________________ Top Gear Episode Guide (Excel) \| Top Gear Episode Guide (HTML) \| Top Gear Classic Episode Guide (HTML) Other Top Gear Guides \| Fifth Gear Guides \| Clarkson's TV/Video List \| Tiff Needell's TV/Video List

September 22nd, 2007, 08:35 PM	#13
pdanev Joined: Oct 4th, 2004 Last Online: Yesterday Location: Netherlands Age: 25 Posts: 5,642 LFS Status: Rep Power: 23	A1GP style - 10 9 8, just like last season. edit: I looked at the times, and it looks like I'm getting the 1 extra point. Last edited by pdanev; September 22nd, 2007 at 08:38 PM.

September 22nd, 2007, 08:46 PM	#15
pdanev Joined: Oct 4th, 2004 Last Online: Yesterday Location: Netherlands Age: 25 Posts: 5,642 LFS Status: Rep Power: 23	1st race: GraemeH 1:26.40 Me 1:25.79 2nd race: GraemeH 1:25.75 Me 1:26.07 Combined my times are faster. Btw, apparently we're using A1GP points from 2005, they use something different now. edit: Wait, are we taking the best lap from both races, or are we adding them up? I thought we add up from both races and look at that total. Either way is ok with me, just that we should make thing clear, maybe I don't remember well...

September 22nd, 2007, 08:49 PM	#16
ESPNSTI Your Guide to TG/FG Joined: Dec 9th, 2003 Last Online: August 28th, 2008 Location: Decorah, IA Age: 36 Posts: 4,291 Car: 2004 Subaru Impreza WRX STI (USDM) LFS Status: Rep Power: 34	Oh we're doing combined times, and not outright fastest lap across the races like in A1GP? __________________ Top Gear Episode Guide (Excel) \| Top Gear Episode Guide (HTML) \| Top Gear Classic Episode Guide (HTML) Other Top Gear Guides \| Fifth Gear Guides \| Clarkson's TV/Video List \| Tiff Needell's TV/Video List

September 22nd, 2007, 08:50 PM	#17
GraemeH Joined: Apr 19th, 2005 Last Online: Yesterday Location: Scotland, UK Posts: 1,824 Car: Toyota Corolla. Rawrr. LFS Status: Rep Power: 18	Then it's not a point for the fastest lap, it's a point for the fastest average :p But if that's how it was calculated for the first race then that's fair. __________________

September 22nd, 2007, 08:51 PM	#18
pdanev Joined: Oct 4th, 2004 Last Online: Yesterday Location: Netherlands Age: 25 Posts: 5,642 LFS Status: Rep Power: 23