Request for squad AC chart

[Viper61]

A request to the CM's:

  It would be extremely helpful in the planning cycle if the CM's could post a running spreadsheet or list of what squad flew what over the last 6 frames.  This would be a rolling roster with the newest Frame posted dropping off the oldest.  Posting the last 6 frames better set's up the Frame 01 rides.

  Intent is to give the CIC's assistant's in planning missions and AC to squads in a more balanced approach.  The few times that Daddog did this I found it very helpful.  Also it allows a Squad personnel to see publicly and quickly what the other squads have been flying without having to go into the logs and conduct a lengthy research.

  What this would hope to avoid is squad getting a higher percentage of bomber or fighter missions than the other squads with the idea to keep it close to a 50/50 split of bomber and fighter rides.  Again with the intent in making it fair to all of the squads.

  I say 50/50 because in nearly every FSO there is an equal amount of Attacking and Defending targets per frame so a squads ratio should stay near the 50/50 ratio give or take.  Yes JABO runs would not be taken into account fully.  A simple "Bomber" or "Fighter" notation would work.

  I know I am asking for a ADMIN tool from the folks that are already over tasked and working for free here.  But it would be very helpful and appreciated.  Nothing fancy just the data.

Viper 61

[AKKuya]

That's a good idea for the vast majority of FSo squads.

Except my squad the 132 DW Bomber Group.  We prefer flying bombers 100% of the time.

[APDrone]

It would be helpful, indeed.. BUT.. not an easy task.

All the information is in the logs, however, so if there are any folks who like to play with numbers, they would be able do dig in and compose such a list.

I would imagine that many of the squads, such as our own, maintain a running list of ride assignments and would be willing to provide their squads data to whomever asks.

You could make that request, and then only worry about those squads that bother to respond, for if they don't, then ride selection, obviously, isn't important to them.

[oneway]

It would be helpful, indeed.. BUT.. not an easy task.

It is very simple for me to do this and actually turn it into a BBS table automatically...at the push of a button. I already have a program that handles exactly this sort of thing.

A request to the CM's:

  It would be extremely helpful in the planning cycle if the CM's could post a running spreadsheet or list of what squad flew what over the last 6 frames.  This would be a rolling roster with the newest Frame posted dropping off the oldest.  Posting the last 6 frames better set's up the Frame 01 rides.

  I know I am asking for a ADMIN tool from the folks that are already over tasked and working for free here.  But it would be very helpful and appreciated.  Nothing fancy just the data.

Viper 61

Viper

I already have this tool.

Can you please describe how you want the table laid out in terms of rows and columns?

Can you describe what if any additional detail such as the number pilots perhaps?

Any and all manner of information can be included.

I have the entire game rendered as an object library and can plug in event data and spit back out any and all style of output

Be specific

If the CM's are interested I can provide this information on an ongoing basis and maintain the list or simply provide them already formatted BBS code in a PM each week so they can simply plop the data into a sticky if desired.

Oneway

[ImADot]

That's very cool Oneway.  For the first blush, I'd suggest FSO title (or just month), Frame #, Squad name, Pilot name, Plane name (G4M1, P40, etc.) - based on just looking at the event logs site layout.

I for one would like to be able to not have to fly bombers 4 out of 6 frames.   

[oneway]

The granularity of choices are numerous.

I can include information on aircraft such as how many engines the bomber has (if a bomber), whether its a drone enabled aircraft (if a bomber), its nationality, its alliance,  its status in terms of early war, mid war and late war, whether the squad flying it attacked strats or field objects etc...

I just need some guidance on what all to include and I will gladly post a sample of the table right in this thread so you all can look at it and comment.

All free of charge and I would be happy to provide this service/report to the FSO community on an ongoing basis.

And I don't even fly the FSO because my squad doesn't.

Salute

Oneway

Edit: Its a simple matter to deductively reason if a squad was Jabo based on the results it achieves based on the type of aircraft it flew, and the types of targets it hit...rather simple

[FiLtH]

 Somebody would have to do the work inputting it. The couple times I had the chance to CIC I looked back 3 frames to see who flew what. Didnt take long,but having it done for us would be nice,as long as it wasnt too much work for the guy.

[oneway]

Somebody would have to do the work inputting it. The couple times I had the chance to CIC I looked back 3 frames to see who flew what. Didnt take long,but having it done for us would be nice,as long as it wasnt too much work for the guy.

Their is no input time at all for what I have/do.

My program sends a Post request with a Get param to the log servers and listens for and  receives a response that is a block of text (string) in the form of an html page ( the same page a user visiting the log site would see if they right clicked and viewed the source code of the page ).

It strips out the HTML tags, headers and function references and then parses the actual remaining text which is the data and folds it into an abstract object model representing the game.

Subsequently it takes this data and stores it locally so the log never is hit again, then post processes the request and runs a series of report requests against the data block and spits out a result.

In this particular case it would spit out the table the OP is requesting.

Their is absolutely no manual intervention whatsoever and once a log is posted by the CM's...it takes all of about 1/100'th of second to complete the request, process the response and spit out the information.

Its even faster than that once a log has been stored locally...about 1/10000 of a second to be precise.

Oneway

        public void LoadPage(EventLog log)
        {
            
            if (wc.IsBusy) return;
            Uri uri = new Uri(_LogIndexPage);
            NameValueCollection nvc = new NameValueCollection();
            nvc.Add("event_id", log.ID);
            nvc.Add("action", "Get " + log.Type + " Logs");
            wc.UploadValuesAsync(uri, nvc);
            timer.Enabled = true;            
        }

[APDrone]

Very cool, oneway!

How about columns for each frame of each FSO for previous 6 ( 18 data columns ) 
Row would be squad.. With possiblity of 2 rows per frame ( for when squads get multiple rides , such as B25s/P40s )

So.. my squad's last 6 months would look like this:

                        1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18         1 - 5/20/2011   
332nd Flying Mongrels:  F F B F F F F F B  B  F  F  F  F  F  B  F  B     18 - 12/3/2010
332nd Flying Mongrels:  F    F        F    F      F       F    F                     

Screwy proportional fonts.. but I think you get the idea..

Give it a shot.. I look forward to seeing the results!

[oneway]

Very cool, oneway!

How about columns for each frame of each FSO for previous 6 ( 18 data columns ) 
Row would be squad.. With possiblity of 2 rows per frame ( for when squads get multiple rides , such as B25s/P40s )

So.. my squad's last 6 months would look like this:

                        1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18         1 - 5/20/2011   
332nd Flying Mongrels:  F F B F F F F F B  B  F  F  F  F  F  B  F  B     18 - 12/3/2010
332nd Flying Mongrels:  F    F        F    F      F       F    F                     

Screwy proportional fonts.. but I think you get the idea..

Give it a shot.. I look forward to seeing the results!

Now your getting somewhere...

At first blush it occurred to me as I pondered this that simply looking at the past two events as blocks was not adequate. The frame count should be a reasonable number...and as frames are rolled out and completed the back frame drops off and the new frame is tacked on at the top of the list.

Further the data should look at and list Allied vs Axis...so consideration can be given to that as well...

If the idea is to balance game play and give squads and players an even look at all facets...

I want the blessing of a CM before I proceed so... you FSO heavy weight squad leaders, if you want it...I got it...but I won't do it unless I get a CM blessing

I have the last 9 frames already stored locally ready for processing and output...

Just let me know...

Out

Oneway

[APDrone]

rgr oneway.. I understand with your reluctance until a CM approves.. and that's fine.

Couple things..   this AC chart would be a tool for the CiCs to use.. so the availability is, in all reality, outside the CM jurisdiction ( except for if the admin CM needs to step in for some corrections )

The data about which side ( axis vs. allied ) would be for the CMs and not really necessary for the CiC level.

I know the CMs used to keep track of side history with each squad, but since I haven't been a CM for a number of years, I cannot attest to its usage.

Figure out a way to turn it into a graph, and maybe Lusche  would step up...lol  j/k

So.. I agree.. wait and see what the CM team has to say about it before going too much farther.  I would give them a good week or so, unless there are some pretty strong opinions involved.

Thanks!

 

[oneway]

Standing by

[daddog]

Will have time later this weekend to respond to PM's and this thread.

<S>

[CRYPTIC]

It would be nice to have this kind of info for people that like looking at stats by squad and yours. This would be nice for FSO and Senario's. It could be posted frame by frame or at the end. I know it would help the CO's to see which plane or group is preforming and which ones might need some help.

Of course this would be left up to the CM's to decide weather they want it posted or just given to the CIC or CO's. I know this would save a lot of time digging through the logs like I do.

[potsNpans]

 I recall vaguely, TheBug started some time back a AH Wiki page(?) that tracked bomber sorties flow by Squads per frame. It would save CiC's some time to decide who to throw into bombers.