Thursday, June 18, 2009

Flight Logs Being Upgraded (Again)

I had a few requests for some improvements in flight log management and have decided to tackle them. Seems I've learned something since I last wrote the algorithm 9 years ago.

Request: "I think the estimated impulse EMRR calculates based on designation may be off - especially on very large motors. I've submitted Gorilla motors files to you in the past so know the format, but obviously don't want to add my motors to the global motor listing, especially since experimentation will result in dozens of different types. Just wondering if there was an easy way to indicate the impulse of any ONE particular motor as it was entered into the flight log."

Request: "I entered a couple of my cluster flights and the flight logs don't seem to be logging them correctly. One is a cluster of 7x EST SU E9-6 + 12x EST SU D12-5 + 12x EST SU C6-5, another is a cluster of 1x EST SU E9-6 + 6x EST SU D12-5 + 6x EST SU C6-5, and the last is a cluster of 1x EST SU D12-7 + 6x EST SU C6-5. I have also flown one other C, D, and E motor this year which should bring the total of C's to 25, D's to 20, and E's to 9. The logs currently read 13 C's, 9 D's, and 9 E's. Please let me know if I'm entering things incorrectly."

So while thinking through these I decided to add some new fields that should speed up some reporting and maintenance of the flight logs.

The four fields that have been added are:

1) Configuration: this is for reporting to categorize, single, cluster, and staged configuration easily
2) MotorLetters: this is for building the graphs faster because instead of having to search and read at time of graphing, this is generated upon flight log entry. This also adds a "z" motor to allow me to quickly ID and maintain "unknown" motors
3) TotalImpulse: this was driven by the request above and will be allow guests to edit the total impulse for their single or cluster of motors. It will also help in the profile/statistic page because instead of having to search, read and calculate at time of reporting, this is generated upon flight log entry.
4) TotalDollars: this was a derivative of the request above and will allow guests to edit the total dollars for their single or cluster of motors. It will also help in the profile/statistic page for the same reason as above.

I have also addressed the old algorithm so that those complex motor configurations are easily captured and reported on correctly.

So, where am I at?

Phase I: Today, I downloaded and converted all 31,000+ Logs into the new database with the additional calculated fields.

I also modified all scripts (reviews, search, profiles, etc) that read from the flight log databases so they split out the new fields (they do not presently do anything with that data).

Lastly, I modified the entry forms to perform the automatic population of the new fields (and within minutes of me turning them back on, I received 10 flight logs that all worked!)

Phase II: Tomorrow, I plan on addressing the edit featured in Flight Log Management.

Phase III: Then over the next 2 months I will be updating all the graphing scripts, flight profile, and new customized flight profile.

Yeee-haaaa!

EMRR Corner 06-15-09


CLICK TO ENLARGE

As seen in:
Apogee Components' Free Peak of Flight Newsletter #237

Subscribe HERE

EMRR Corner 05-19-09


CLICK TO ENLARGE

As seen in:
Apogee Components' Free Peak of Flight Newsletter #235

Subscribe HERE