Online Community of Zenith Builders and Flyers
New Form Link
I have a new way for you to join the spreadsheet
Long term I think it will make it more secure to participate. If you fill out the form, I will be the only one that can see your email address. I will only use your email address to secure the form and map. Only catch is, it has to be Google compatible email address.
Winners Announced See Latest Post!!!
I will contact all the winners and let them know what what they need to do next.
Thanks for Participating !!!
Zenith Aircraft Builder and Pilot Experience Info Sheet
Google Map Topic/Discussion Moved here
Please let me know if you have any questions, suggestions, or concerns.
Thanks for taking any time you can from your project or flying, to fill out the spreadsheet.
John M. Greiner
I agree Jim. I will add this field . thanks for the suggestion.
Fantastic idea John.
Any way to adjust the construct of the sheet to make the data more 'sortable'? For example, let's say I'm interested in researching the climb performance for all 701s flying with Rotax 912 engines and what prop and pitch setting they are using. Would be great to sort for model '701', then 'Flying', then 'Rotax 912', etc.
If a bridge too far at this point no worries. Thanks again for doing this.
That's a great idea too. I have thought about doing it, but not the how to do it. I make my living in IT, so I use Microsoft Excel, even when it doesn't make sense to use Microsoft Excel, LOL. Google Sheets is a little different, but in many ways the same.
Now here is one option for everyone to use, not saying its the best, but its just one option. You can always save a copy of the spreadsheet at any point to your Google Drive or local device drive, and filter or even remove to your hearts content.
What I was worried about was if I added sorting and filtering, when I sorted the master shared spreadsheet, the way I sort it would effect everyone's view. And if 2 of us were you using the sheet we could get into a sorting battle, so to speak. I don't know if this is actually true, because I haven't tried it with another Google User.
Now another similar idea I have had, is the thing is getting really long. I left it one long sheet because its easy to stay in one place. But I thought about breaking up the major categories Like airframe and engine into separate tabs for example, in the same sheet. Still one big shared spreadsheet, but divided a bit by tabs.The first 3 or 4 columns would be automatically be the same on all 3 tabs so you could find your place, ie your aircraft on each tab. This might be easier on the eyes a bit. I am in IT as I said, so I am used to staring at ridiculously long spreadsheets, but that's not fun for everyone necessarily.
Your idea of separate tabs (e.g., engine, airframe, avionics, etc) is right on. I had also been thinking about this. I use this "technique" when I also use excel spreadsheets for other non-financial uses. I then add a new blank "first" tab and then you can paste your columns their to create your personalized spreadsheet. However a better approach is to put a hyperlink from a column in the large spreadsheet to your personalized tab. Thus whenever a column is updated it automatically changes your personalized tab. Just a thought.
You can reference the first three colums, or however many, in the first tab, on the other tabs, so whatever is typed in the first tab, naturally flows to the other tabs. It would be easy on us pilots and builders, and bring the data together without any effort. More or less exactly what you said above.
What's hard is to know what helps most people without doing a survey. What me and you think is a great idea, may not be good for another. But in this case, I think it might be worth the risk and assume our opinion is right. Thanks so much for your ideas and opinions on this, and most of all for contributing to the forum in general. Hope your building/flying is going well!!!
Thanks, John - This is fantastic and filled the details of my build as much as I can. Looking forward to wrapping the building and fly it sooner than later.
We are at 48 participants, so close, I know someone wants a T-Shirt.
Disclaimer - Oh and I have already exempted myself from the T-Shirt prize.
My girlfriend is already tired of all the Zenith stuff I wear already and I quote, "Gee Wiz don't you spend enough time with that plane, do you have to wear it to bed too?" Of course we know the answer to that is a "Resounding Yes". And yes she actually said "Gee Wiz".
TIPS - helpful ideas to promote the spreadsheet usability
T- Shirt Prize
Guys I know its tax time and all, but please make sure you enter real people and real data about real kits and planes.
Unless you can prove your cat or dog actually built 51% of your plane, they are not eligible to win a t-shirt and should not be listed as a builder or pilot.
Now I can prove my dog destroyed 100% of my seat covers, but that is another issue entirely, and no I can't add a column for "pet mods".
Interesting note - the engine tallies after 50 contributors:
3 Engine Choices are tied for 1st.
(All, No cheating, don't make people, planes, or performance up just so your engine wins)
Guys, I hope you realize I am completely kidding on who wins the engine battle, its all about helping people make comfortable informed decisions. All of the engine choices are perfect, for the right person, right plane, and the right mission. Do your homework, its an important decision. But clearly these 3 engines are flying and now you know who to ask with specific questions.
This could grow into a great Reference / Index. Well done!