• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

OT - To all stat-makers [like WinR, Confused, GeoffS...]

D347h

Senior member
Hey guys !!

I'm making stats for DPAD, and have some questions to you..
1. How do you obtain data? Manually or with script?
2. In what program you prepare your stats?
3. Spaces - how you fill them - with dots, minuses or what?
4. How you know it will be in place you want it to be [I mean position from left margin]?

Could you answer these questions? Please...
 
The Seventeen or Bust stats are done from a script, which was written by MereMortal.

It is all done in PHP, which connects to the server, downloads a text file dump of all the stats, processes it, and outputs to a plain .txt file. The "spaces" are filled with dots, as FuseTalk doesn't allow you to have more than 1 space bewteen words 🙂

Getting the layout is just trial and error! Sitting there, running the script, seeing how it looks in FT (go to "new topic", paste the stuff, and hit "Preview" and take a look. If it looks good, then you're onto a winner, if not, edit the script and try again 🙂


Garry
 
Errr... I also have a stats page (currently the server is down for a month or so.. 🙁)

I also use a script, it fetches all the stats and dumps it in a database.. So it's not really what your looking for.
Script language is perl..

You should not obtain your data manually, it might be doable, but after a few days I don't think you can bring that effort up anymore..
For you spaces, in the forums you'll have to fill 'm up indeed, so dots are the most commonly used around here.

Do you have any experience with some kind of scripting or programming language?
I might be able to help, if time wasn't the enemy...
 
My stats for ClimatePrediction.NET are all hand made. So far I haven't found a possibility to get a file or a team dump that I can work with.

I prepare them in Notepad. If u want to be sure about margins just use the [ NUM ] or [ BULLET ] along with
[ LI ] tags. So u get a nice list for each member. 😀
 
CyGoR, sorry, I used to write simple things in C++, but about two years ago, so no programming skill 🙁

If anybody could help, I will be thankful.. If no, I will try to do them manually as long as I could...

Thanks in advance for any help...

And, BMC, could you send me a PM with link to one thread with ClimatePredi. stats, so I can see them? These dots are VERY stupid... :///
 
I wrote an application to do the SETI race stats for me. I use Excel and VBA. It's really quite simple in VBA to connect to an Internet site and transfer data from a webpage into an Excel spreadsheet. From that point, the code calculates production, formats the thread, generates a text file and loads it into notepad. Then I add some "decorations" and copy and paste that into my daily race post.

🙂
 
Hey D347h.
I use an Excel macro to post CB.
Get back to me and lets see what we can come up with.



🙂
 
Hey guys !!

Thx for such alot of replies..
OD & WinR - would you be so cool and send me your macros to d347h@o2.pl ?? TIA. I want to see how they works, maybe I would be able to edit them a bit and get my work done...

BMC, you have luck you only have 2 coulmns.. Thx for PM. YGR.

Anybody else want to reply ? Maybe GeoffS? Thanks for all in advance !
 
D347h the reason i pm'd you the other day was because I saw your stats post and your comment, "Im doing them manually...etc", and ive been working on a script for you.

Im in the process of searching for a txt dump on the dpad site, but cant find it.

Anyone care to help out?

Cheers,
Dan
 
AFAIK a teams name is the text in [], so yes, [TA] somewhere in the name should indicate TeAm Anandtech 😛
 
hey... just returned from visiting the folks in Montreal.

I have a process that downloads stats pages from Sengent and then parses them into .CSV files. Those get loaded into an Excel sheet that has about 10 pages in it and tons of lookup formulae, and then I cut and paste 🙂 Pretty low-tech!

Geoff
 
@DannyBoy
Whoa, THANKS! And YES, all members of TA in DPAD need to have [TA] before or after nickname to be in Team - currently all members have it before nick...

@GeoffS
So, kind of manually done stats...

@OD
Got e-mail, reply sent 🙂

OK, somebody else want to add something ?? We're waiting for it! 😉
 
I would just like to bump in with a ton of thank you's to one and all here for all the help provided by everyone in this forum.

once again you guys prove this is the BEST team out there.

Thank You

-rob
 
Originally posted by: D347h
@GeoffS
So, kind of manually done stats...

Well... I just dump the csv data into the sheets, and it does all the calculating. I suppose I could even have macros do the loading part for me. I have forumae set up to generate the required formatting for posting here and filters to pick the data I want. I plan on something a little more hands off, but I'm not there yet. I'd love to build something with mySQL and php, but I just don't have the time.

Geoff

 
DPAD is a bit of a PITA, but it's not too bad. I produce a text dump of team stats for it every day. But then, again, I do that for 25 other projects, too. If you have any questions, LMK.
 
@WinR
It is as DannyBoy said.

@DannyBoy
Thanks in advance for all you have and will have done !

@MereMortal
What means PITA?
 
Back
Top