EIDAA From Ireland, joined Oct 2006, 831 posts, RR: 16
Reply 1, posted (6 years 7 months 3 weeks 3 days 19 hours ago) and read 21487 times:
I would also like to know what other software people use.
I currently just use MS Excel, tracking the operator, type, registration, MSN, date, location and "comments". Unfortunately with around 4,000 entries at this point, auto-filters tend to drop certain data from searches, so I would be interested to know what others use.
Ketko2 From Japan, joined Sep 2006, 107 posts, RR: 0
Reply 2, posted (6 years 7 months 3 weeks 3 days 16 hours ago) and read 21479 times:
I started using Access recently. I have created a set of tables, one for airframes which includes ID, which is the CN with a prefix, so I can set it as a unique value (for eg. A32S.2143), then it has the CN itself, LN, Manufacturer, Type and Subtype. It also includes frame type (jet, prop,...) and the registration it was wearing when last seen.
The second table is called Sightings and it includes data about each sightings of a particular airframe - ID to relate it to the previous table, Registration, Operator, Location, Date, Remark and a * if it is first time seen.
Last main table is table Photos, which is unrelated to the other two, however I have an auto-fill on my form, so it automatically fills remaining data after entering registration of the plane on the photos. It also contains location of the photo on the disc, so it can display it.
Beside that, I have a couple of forms and reports, which help me organizing/browsing the data.
Firstly there is the main form, which just has buttons to go to the others.
Then there is the 'logging tool', which I use to input data about the sightings. The upper part contains detail about the frame selected in the bottom part. The default data for the new sightings can be set on the main page for the ease of inputting frames from one trip.
Finally, there are two forms for managing/browsing the photos table.
First is a form for adding them. And the second is for browsing. The browsing form isnt great, but Im working on making it better.
I also have created some report, for the ease of browsing.
That's it. Firstly I wanted to buy ADU or some other commercial product, but then, I found iout, that I dont need tens of thousands of airframes already in, so I decided to craete my own one and Im happy with that decision to say.
Now I only have to input three years worth of frames/sightings/photos.
NWADC9 From United States of America, joined May 2004, 4899 posts, RR: 9
Reply 3, posted (6 years 7 months 3 weeks 3 days 7 hours ago) and read 21462 times:
The word "used" to describe the condition of my copy is an absolute understatement. Page after page of my markings on the reg numbers-sightings, aircraft I flew on, additions, retirements. It's WEEEEEEEEEEEEEEEEEEEELLLLLLLLLLLLLLLLLLLLLLLLLLLLLL used!!!
Flying an aeroplane with only a single propeller to keep you in the air. Can you imagine that? -Capt. Picard
They have their own database so you don't need to enter the information yourself - just enter the reg and it will look it up for you.
It's also a great site just for looking up registrations, they have one of the largest databases of regs on the net - pretty much every aircraft that's ever been built since the end of WWII. They've got everything from Comets to 787's. Even the Space Shuttle and Spruce Goose are in there!