Stats and Graph HELP needed

[Fabrik]

Hi guys
I am playing TS with some friends on LAN and we are keeping our local server's log files
we tried to make a graph and a stats spreadsheet to keep our championsheep update but we have failed

- in log file we see this data under GRAPH DATA:
Winner laps: 4, total time: 48.477, average lap: 12.119
"killer" 0 1.744 1.489 1.202 0.942
"SIMPSONBEBOP" 0 2.495 1.929 1.556 1.209
"KukKaBubBa" 0 1.315 0.895 0.490 0.000

but we do not succeed in using this in excell

most of all when copy and past those line in excell the are pasted in 4 lines bunt only one row
For example: "killer" 0 1.744 1.489 1.202 0.942 is in 1 single cell

and so the data are un-usable for a common graph application..

In few words, can you help us to make a graph and stats for race and championship?

[dede]

most of all when copy and past those line in excell the are pasted in 4 lines bunt only one row
For example: "killer" 0 1.744 1.489 1.202 0.942 is in 1 single cell

I guess you are using Excel 2007. If so, you have to use "special paste" and then select "Text". After this, there is an icon displaying right next to the area, click it and select the wizard. It should split that data into columns.

If you know anything about php/mysql, there might be a script made by a TS player that could work nicely as a ranking (demo - downloads).

Obviously I would suggest you to join our community and play online with us Cya!

[Fabrik]

Ciao Dede
uso Excel 2003, alla fine sono riuscito ad importare il file txt di log ma allestire le formule è un po palloso, anche se non sono pratico di SQL imparo in fretta quindi mi volevo mettere a trafficare col TSSTATS se non fosso che dal sito fi YANNICK non si riesce a scaricare, prendo solo file incompleti, non c'è su rapidshare o simili?

[Pingu]

Thnx for talking English so we can understand it too...............

[dede]

Yeah, the forum is english-only. Use PM otherwise.

The download link seems broken indeed. I have no copies apparently on my hd.

[Fabrik]

Ciao Dede
uso Excel 2003, alla fine sono riuscito ad importare il file txt di log ma allestire le formule è un po palloso, anche se non sono pratico di SQL imparo in fretta quindi mi volevo mettere a trafficare col TSSTATS se non fosso che dal sito fi YANNICK non si riesce a scaricare, prendo solo file incompleti, non c'è su rapidshare o simili?

OK sorry

this is it!:

Hi Dede
I am using Excel 2003 and I managed to import txt log file
but I have found too that make alle the needed formula to ge a nice spreadsheet is too long so I would try TSSTATS but I cannot download it from the YANNICK websit because link seems broken
(i get 248kb insteam of 1.5 mb of file)
is there a rapidshare link?

[iBlaze²]

Ok, I do this using Excel 2003 too and this is how to do it:

> Open log file and copy relevant data (shown below).

"killer" 0 1.744 1.489 1.202 0.942
"SIMPSONBEBOP" 0 2.495 1.929 1.556 1.209
"KukKaBubBa" 0 1.315 0.895 0.490 0.000

> Paste this data into a new .txt file and save (I'll call this example.txt)

> Open Excel and go to File > Open > example.txt

> A box will appear, make sure 'Delimited' is selected and click next.

> Where it says delimiters, deselect 'Tab' and select 'Space' instead. Then click finish.

> Now the relevant data is seperated into seperate rows and columns so the graph is easy to make

[Fabrik]

Ye thanks
I managed to import log file in excel but after seeing what can do YANNICK SQL script I would try it, does anyone has still the files to send me?
on yannick website download section is down

[Fabrik]

Can some one please share the gold?
or contact YANNICK to fix his download page problem?

[dede]

Can some one please share the gold?
or contact YANNICK to fix his download page problem?

I doubt that somebody has this script. Y4nn1ck disappeared quite long ago, together with his server. You can try to contact him using the contact information in his page. If he doesn't answer, we can't do anything.

[Fabrik]

Umm
I saw many people messing up wit Yannick Scripts
I wonder if no one kept a copy on his pc :/

[dede]

I saw many people messing up wit Yannick Scripts

So ask them directly? Maybe they aren't reading the forum.

[Buraczek]

Sometimes you need to be like Holmes

here is the script or this is the way to script

copy this to your browser

http://y4nn1ck.org/turbostats/

delete /turbostats/

go to Divers/autostats/

[dede]

Looks like he changed the website then