Aces High Bulletin Board

Special Events Forums => Friday Squad Operations => Topic started by: Ripsnort on July 17, 2002, 08:07:25 AM

Title: TOD stats are essential to participation
Post by: Ripsnort on July 17, 2002, 08:07:25 AM
I know Exile has alot on his plate, maybe someone can volunteer there services to him...I think its VERY important to have the results posted within 48 hours of an event, we have no kill buffer, only confirmed visuals...we really need the stats posted.
Title: TOD stats are essential to participation
Post by: Nifty on July 17, 2002, 08:24:49 AM
The scripts are on Exile's server.  As far as I know, no one else has permissions to alter them (which is necessary to run for the correct event.)

So I'll go get the raw logs and put them into Excel format.   You can thank the State of Florida for paying for this service.
Title: TOD stats are essential to participation
Post by: Nifty on July 17, 2002, 08:48:28 AM
http://members.cox.net/nifty/todfr1.htm

if first page doesn't show up, click on one of the tabs.  The sheets are there.
Title: TOD stats are essential to participation
Post by: Steven on July 17, 2002, 09:49:16 AM
Dang!  Cheesehead has five maneuver kills on us.  But this made me think of something and it would probably be cool if for at least "special events" (TODs and stuff) AI gets the credit when due.  It would show the battle more accurately.  I for one was never touched by an enemy aircraft and instead was vaporized by the enemy fleet's AI ack.
Title: TOD stats are essential to participation
Post by: Skyfoxx on July 17, 2002, 10:01:12 AM
A big Thanks Nifty! :D

Title: TOD stats are essential to participation
Post by: Nifty on July 17, 2002, 10:57:18 AM
Impossible to separate out ack kills from actual maneuver kills.  Be nice if ack kills were added to the game.
Title: TOD stats are essential to participation
Post by: Ripsnort on July 17, 2002, 11:21:45 AM
Quote
Originally posted by Nifty
The scripts are on Exile's server.  As far as I know, no one else has permissions to alter them (which is necessary to run for the correct event.)

So I'll go get the raw logs and put them into Excel format.   You can thank the State of Florida for paying for this service.


Thanks Nifty, but I am looking for a more permanent solution, surely we cannot burden the tax payers of FL for this work week in and week out ;).
Title: TOD stats are essential to participation
Post by: Flossy on July 17, 2002, 11:41:33 AM
Quote
Originally posted by Nifty
http://members.cox.net/nifty/todfr1.htm

if first page doesn't show up, click on one of the tabs.  The sheets are there.
Thought I would have a go at doing the same for Frame 3 of Malta, going by your format - partly as an exercise in using Excel and partly as something to do while I am at home from work on Official Strike today....  :D  The results of my efforts are here:  http://www.flos.clara.net/storage/Malta3.htm   :)
Title: TOD stats are essential to participation
Post by: Wotan on July 17, 2002, 12:04:28 PM
19 kills for 3./JG2 :)
Title: TOD stats are essential to participation
Post by: Exile on July 17, 2002, 12:10:55 PM
Quote
Originally posted by Ripsnort


Thanks Nifty, but I am looking for a more permanent solution, surely we cannot burden the tax payers of FL for this work week in and week out ;).


well ... you could pay me $125/hr and I'll guarantee the sorties will be ready 30 minutes after each event.  ;)
Title: TOD stats are essential to participation
Post by: Nifty on July 17, 2002, 12:18:03 PM
what exile is saying is when he has time, he's going to make a more permanent solution.  ;)  We've talked about it (I suggested something and he said he'd already thought about it) and really it's just when the poor guy has time to get it done.  Until then, you'd have to pay consultant fees for him to shirk his work duties.  ;)

Me, I don't mind taking a little time here and there to do the MS Excel stuff, but I'm not knowledgeable enough to help Exile with the permanent scripting stuff.  I'd end up screwing up his whole simladder site!  :eek:
Title: TOD stats are essential to participation
Post by: Ripsnort on July 17, 2002, 12:54:04 PM
$125 an hour? No wonder the USA is losing soooo much work to overseas competition :D

Anyway, whatever works, I had folks private me on two separate occasions in the main arena lately asking for them, just thought it'd be nice to see the results in a fairly quick fashion.  I'd love to help, but these two little testosterone trolls living me at the moment needs their daddy alot of the time...tough to do anything without an interruption of some sort anymore...
Title: TOD stats are essential to participation
Post by: Exile on July 17, 2002, 02:48:35 PM
hey ... that's "friendly" pricing ... because I care :p
Title: TOD stats are essential to participation
Post by: Flossy on July 17, 2002, 07:11:07 PM
Quote
Originally posted by Exile
well ... you could pay me $125/hr and I'll guarantee the sorties will be ready 30 minutes after each event.  ;)
$125 an hour?  And here's me on Official Strike today because I barely scrape £5-£6 per hour (about $7.00-$8.00 per hour?)  :rolleyes: ;)
Title: TOD stats are essential to participation
Post by: Exile on July 18, 2002, 06:54:51 AM
hehe ... I wish I got paid $125/hr

I'm salaried like most everyone else and don't even come close to that with the hours I work. $125 is about what we charge for hourly maintenance work though. Ya gotta love America ... time is money!! :D
Title: TOD stats are essential to participation
Post by: Ripsnort on July 18, 2002, 09:28:08 AM
Okay Exile, whats up with the logs?

Note: for example

Pilot XXX
takes off from field 35 in a F4F-4
shoots down a D3A piloted by JimBear
shoots down a D3A piloted by Ripsnort
helps CheezHed shoot down Sundog
maneuver kill awarded as JimBear crashes
shoots down a D3A piloted by dfl8rms
shoots down a D3A piloted by Ozark
shoots down a D3A piloted by Nifty
lands to refuel/rearm

Why giving credit for 2 kills for the same pilot?  This is consistent through out the whole frame.  Over inflated pilot kills suppose to be historical by the Stats guys too?  :D
Title: TOD stats are essential to participation
Post by: Squire on July 18, 2002, 09:33:51 AM
No need to be modest with my ID Rip :)

Ya, I was wondering why the logs show that, can somebody please clarify exactly what a "manuever kill" is in the logs? Im happy enough with my scoring I dont need bonuses for bailing crews. I noticed a lot of pilots getting manuever kill credits as well.  That many guys augering in? or?...

Q.#2. Shot down by unknown gunner, what is that?

Thanks.
Title: TOD stats are essential to participation
Post by: Exile on July 18, 2002, 09:47:53 AM
Quote
Originally posted by Ripsnort
Okay Exile, whats up with the logs?

Note: for example

Pilot XXX
takes off from field 35 in a F4F-4
shoots down a D3A piloted by JimBear
shoots down a D3A piloted by Ripsnort
helps CheezHed shoot down Sundog
maneuver kill awarded as JimBear crashes
shoots down a D3A piloted by dfl8rms
shoots down a D3A piloted by Ozark
shoots down a D3A piloted by Nifty
lands to refuel/rearm

Why giving credit for 2 kills for the same pilot?  This is consistent through out the whole frame.  Over inflated pilot kills suppose to be historical by the Stats guys too?  :D


Do D3As have the "3 plane formation" option? That would account for the multiple kills of the same pilot.

-----------------

The "unknown gunner" is in most cases the Ack. In the logs, the kill is not attributed to a player for whatever reason and this is what I'm showing to reflect that.
Title: TOD stats are essential to participation
Post by: Nifty on July 18, 2002, 01:25:23 PM
man kills can come from a gunner dying (that's what Jimbear was doing when he gave Warloc a man kill) or if you're in the area when a guy gets pinged by ack and goes into the drink.

I'll remove all of the man kills of gunner/observers from my excel file.  Exile would have to tweak his script on the "official" points log, so that's up to him to take care of.

edit: 1 man kill of a gunner was removed from both sides in the above excel link.
Title: TOD stats are essential to participation
Post by: Ripsnort on July 18, 2002, 01:44:43 PM
Hehe Squire, remind me to have CV cap, and to stay very near the CV when they dive in ;)

Thanks Nifty!
Title: TOD stats are essential to participation
Post by: Ripsnort on July 18, 2002, 01:47:59 PM
Wow, only 7 kills difference in that first frame,  Allies had more numbers too.  Very close first frame!
Title: TOD stats are essential to participation
Post by: JimBear on July 18, 2002, 02:11:34 PM
2 Kills awarded for me death?  Just wanted to help out them Yanks. Seeing as how they were slavering to get  me so bad as their CV was going down  :)
Title: TOD stats are essential to participation
Post by: Squire on July 18, 2002, 02:36:00 PM
Well, its a big ocean, get too spunky and you miss the raid entirely, its a tough task to do CAP with no radar.

Actually 1/2 the F4F CAP was engaged with Zeros at C35, with C31 being the NE pos carrier, which is the one your group attacked. I was heading there from C35 when the first wave came in. We really had no good indication as to which CV was going to be hit, despite several sightings of inbound raiders. I didnt think the IJN flight leader was going to be too obvious on the route, and they weren't.

In any case, its not much of a contest, D3A vs F4F, its a tall order to attack a CV and rtb without getting nailed by aaa or fighters.

Salute to all the IJN Dive Bombers, you guys did a good job.
Title: TOD stats are essential to participation
Post by: Replicant on July 18, 2002, 05:48:42 PM
hehe Ripsnort, something like this? :)

Nexx
Sortie #1
takes off from field 1 in a Hurricane Mk IIC
shoots down a Bf 110C-4b piloted by Ripsnort ;)
shoots down a Bf 109F-4 piloted by Fosse
lands to refuel/rearm
 
Sortie #2
takes off after refueling/rearming
shoots down a Bf 109F-4 piloted by dm2
shoots down a Bf 109F-4 piloted by Goofy
lands safely at field 1
Title: TOD stats are essential to participation
Post by: Ripsnort on July 18, 2002, 08:30:13 PM
Hehe Nexx, I was the bait!  I  told the guys over comms, "I'll be the bait, you egress home..." It worked!  However, I intended to live ! :D  Ah well, half the plan worked..:)
Title: TOD stats are essential to participation
Post by: Puck on July 18, 2002, 11:29:47 PM
Quote
Originally posted by Nifty
what exile is saying is when he has time, he's going to make a more permanent solution.  ;)  We've talked about it (I suggested something and he said he'd already thought about it) and really it's just when the poor guy has time to get it done.  Until then, you'd have to pay consultant fees for him to shirk his work duties.  ;)

Me, I don't mind taking a little time here and there to do the MS Excel stuff, but I'm not knowledgeable enough to help Exile with the permanent scripting stuff.  I'd end up screwing up his whole simladder site!  :eek:


If it's in an excel spreadsheet it most likely was in CDF or TDF.  Why not get some uber geek code monkey to write PHP scripts to parse the raw data into an SQL database (MySQL comes to mind) and generate a web page?  No thought required that way; once the log file exists the rest is automatic.

Just a thought as I sit here writing PHP scripts to parse data into an SQL database for work...  :)
Title: TOD stats are essential to participation
Post by: Steven on July 18, 2002, 11:36:20 PM
Flossy, thanks for putting up the stats because I see something ineresting:

"Tilt Assist Awarded Puke Nilsen10 The Wings of Death"

My Wingman got an assist on me!   LOL  Too funny.
Title: TOD stats are essential to participation
Post by: Exile on July 18, 2002, 11:46:26 PM
Quote
Originally posted by Puck


If it's in an excel spreadsheet it most likely was in CDF or TDF.  Why not get some uber geek code monkey to write PHP scripts to parse the raw data into an SQL database (MySQL comes to mind) and generate a web page?  No thought required that way; once the log file exists the rest is automatic.

Just a thought as I sit here writing PHP scripts to parse data into an SQL database for work...  :)


hey ... who you callin "uber"?!  ;)
Title: TOD stats are essential to participation
Post by: Flossy on July 19, 2002, 01:49:09 AM
Quote
Originally posted by Steven
Flossy, thanks for putting up the stats because I see something ineresting:

"Tilt Assist Awarded Puke Nilsen10 The Wings of Death"

My Wingman got an assist on me!   LOL  Too funny.
Quite possible - Killshooter was OFF!  :)
Title: TOD stats are essential to participation
Post by: Nifty on July 19, 2002, 07:59:45 AM
Puck, that IS what Exile does.  However, he's the only one with the keys to his scripts.  He doesn't let me drive 'em.  ;)  So I make do with what I've got available to me when he's busy and can't do the updates.
Title: TOD stats are essential to participation
Post by: Nifty on July 19, 2002, 08:00:46 AM
Quote
Originally posted by Steven
Flossy, thanks for putting up the stats because I see something ineresting:

"Tilt Assist Awarded Puke Nilsen10 The Wings of Death"

My Wingman got an assist on me!   LOL  Too funny.


He just wanted to make you feel like you were flying with the Mongrels.  ;)
Title: TOD stats are essential to participation
Post by: Puck on July 19, 2002, 08:12:46 AM
Quote
Originally posted by Nifty
Puck, that IS what Exile does.  However, he's the only one with the keys to his scripts.  He doesn't let me drive 'em.  ;)  So I make do with what I've got available to me when he's busy and can't do the updates.


Obviously he needs more Dr. Pepper/Mountain Dew (The official soft drinks of Code), Pizza (contains everything needed for a coder to work all night, provided it gets steadily colder), and Doritos.
Title: TOD stats are essential to participation
Post by: Replicant on July 19, 2002, 09:51:21 AM
Quote
Originally posted by Ripsnort
Hehe Nexx, I was the bait!  I  told the guys over comms, "I'll be the bait, you egress home..." It worked!  However, I intended to live ! :D  Ah well, half the plan worked..:)


Ooops! :)  Actually I was the only one with any fuel left, about 1/4 so that's why I didn't hang around much longer either.  My squaddies were all on fumes so we were only told to engage if engaged.... ;)]
Title: TOD stats are essential to participation
Post by: Nifty on July 19, 2002, 11:13:56 AM
I'm not a good coder cuz silly me drinks my home brews with the Doritos!  ;)  Code gets sloppy and eventually I just fall asleep.  :D
Title: TOD stats are essential to participation
Post by: Steven on July 19, 2002, 12:39:04 PM
Quote
Nifty "He just wanted to make you feel like you were flying with the Mongrels."


I know!  That's why it strikes me so funny.  If my guest squad only knew how much ribbing we give each other in the Mongrels about "friendly fire."  Heck, I shot down Ghosth once and Makarov9 had the assist on Ghosth.  (That should tell you that Ghosth dove into our line of fire.  ;))  So far I'm not the leading scorer of friendly kills in the Mongrels....I wonder who that can be??   lol
Title: TOD stats are essential to participation
Post by: daddog on July 19, 2002, 09:35:35 PM
Ah the times and trials of HTC events! :)

Just to give you some background over a year ago exile agreed to help us out and he with the help of some art work of mason put up some excellent events sites.
http://events.simladder.com/snapshots.php is just one of the many pages. Well several months ago he wanted to retire. That started the CM's (me mostly) pushing HTC to take over the events site so exile could retire. Push came to shove and just a few weeks ago HTC pulled everything over. Problem is they choose not to set it up. Sure the information is on the HTC site but we can't add events, edit events, delete events, work with TOD squads, contact C.O.'s or do "anything" with the logs as exile does for us. After month I realized we were in trouble. HTC has put a priority on getting out 1.10, working on 1.11 and several other items on their plate. Who can tell hitech and pyro what should be next on their to-do list? Not me. Nevertheless I have pointed out this last week in a e-mail to both hitech and pyro that the Friday TOD is near 200 a night, the Sunday TOD is about 100 and the Snapshots are about 70 or more. We also have a new event starting Saturday in a few weeks. Those kinds of numbers will speak louder than months of nagging and begging. One can only hope.

In about 2 weeks I look forward to getting together with several other CM's and then meeting with hitech and pyro about some of our more pressing needs. Time well tell. In the mean time I have begged exile to keep working with us and he said he would with what time he has.
Title: TOD stats are essential to participation
Post by: Hamerd on July 20, 2002, 07:09:03 AM
well there is something missing and thats me, I didn't see my name nowhere , not even on the death list, I know I was there makes me think the stats aren't accurate, because I know I shot the hell out of a F4F, got him smoken, Ghosth I believe was on my 6 at the time. Just my thought, I no glory hound but would like to see the results!!
                                    Hamerd
Title: TOD stats are essential to participation
Post by: Flossy on July 20, 2002, 07:52:22 AM
Quote
Originally posted by Hamerd
well there is something missing and thats me, I didn't see my name nowhere , not even on the death list
Are you referring to last night or last week?  These are the results of last week's frame - last night's results aren't out yet.  :)
Title: TOD stats are essential to participation
Post by: Hamerd on July 20, 2002, 08:06:28 AM
Well that explains every thing:o  thanks for the heads up Flossy;)
Title: Punt
Post by: TheBug on August 29, 2002, 09:50:49 AM
This thread still applies, was wondering if we would be seeing results for last Friday/Sunday ToDs?  I can very much understand that people may be too busy to get results parsed and posted, and I very much appreciate it when they do spend the extra work to get it done.

But some squads, mine included, is based in the historical events and would like know and keep tally on how we did.  If there is an issue with people having the time necessary to get this done promptly, could we possibly get the kill messages enabled in the buffer??? As a temporary fix for the time being.

          Thanks