Since design is an iterative process, the first thing I would do after doing the setup work is to create a very simple macro to loop through the altitude increase and copy-paste the results. Exposing min, max and height delta as variables in the second sheet created here gives a lot of flexibility to the user. Similar steps could be taken for the airspeed table on the first sheet to address the stepping discussed. Only thing I would add is, use a straight line between points on a graph, and, show points. This isn't as pretty, but it is accurate for the data you are displaying, as you haven't calculated the data between points. (18 years as a stressman working airliners, UAVs mostly).
@scott_aero Excellent observation. I have a code that does exactly what you're suggesting. That said, please keep in mind the audience this is intended for; undergraduate students. This 12-min video replaces a 1.5 hr lecture in class (that includes Q&A) and, thus, saves a lot of time. Astute students write VBA code for this task although this is not asked for in the class plan. Best wishes.
@@dr.gudmundssonaircraftdesign Yep, I remember being in the undergrad students shoes and having to do very similar tasks without years of experience and personal molding into the shape of a stressman! This was not a knock on your presentation btw, just some helpful hints for interested viewers - things I wish I knew!
I really like your book, it’s very helpful and informative. Being an engineer in a different field, I started out doing a lot of things in excel, but more and more I’ve come to the conclusion that excel is really the wrong tool for most things. It quickly becomes either a buggy mess, but more likely unwieldy to maintain and improve. I would suggest it is far better in my opinion to use an actual programming language not excel. You can always use it to generate tables and plots. Doing manual steps like copy-paste is both fraught with potential error(no way to know if it’s up to date), but also very manual and slow.
@brandonhicks7549 Thank you for your kind words about my book. Also, thank you for your comment. I used to say the following to my students: "Regard your computational tools like a carpenter regards his/her toolbox. There is a right tool for each situation. Don't pick a sledgehammer to put a nail in the wall for grandma's picture. And don't pick a ball-peen hammer to break down that wall." Engineer's preferences are as many as there are engineers. Some engineers prefer to only use Python, others only VB, C++, and even Fortran. Other engineers prefer to only use Excel, and yet others only use Powerpoint and Word for writing/presentation purposes. Then, there are engineers that use tools from all categories. I am that kind of an engineer. I use that which I deem to be the most practical for each situation. Sometimes, I write examples in Excel that I use to validate my code. At other times, I write code to spit out numbers that I plot in Excel to display in Powerpoint. Yes, many people write impossible-to-understand, under-remarked spaghetti-spreadsheets. But then again, many people write impossible-to-understand, under-remarked spaghetti-codes. Neither speaks to either tool, only to the writer. To me, Excel is one of the most useful engineering tool I use. Nothing can change that. One of its strengths is that most engineers know it. The problem with code writing can occur when the boss has no exposure to the engineer's favorite programming language. One's boss may have a business degree and not have any coding exposure, but can still use Excel. That universality is unmatched by any programming language. Excel is well known by most. Programming languages aren't.
Thank you very much for the video, it was very helpful! It seems there is a small heading error for the Vr in the envelope sheet: it should be "best range" and the 4th parameter should be R, nm. Also, is it possible to calculate Vmin for level flight using this workflow? Thank!
@bleauchot Thanks for that comment. Good catch. Consequence of a rapid copy-paste action on my part. Yes, you can add Vmin using the same workflow. Best wishes.
thank you professor for the tutorial, recently i bought a Chinese version of you book and i just keep coming to your channel for tutorials. i'm interested to know do you have any plan to record as a course like those usually we buy from Udemy. it would be really helpful for us. alongside the book and tutorials would be a great resource for aircraft design enthusiasts.
@star man Thank you for your comment. No, I have no plans to record complete courses. I simply don't have the time currently. So, I will stick with this format (occasional release of videos) for the time being. Sorry about that.
Good day Dr. Gudmundsson. Thanks for your educative content sir. My question is off this particular topic but i need your idea sir. Please in performing the load test of an aluminium wing, I'll like to know the time frame used in simulating the aerodynamic loading conditions at 2G, 2.5G 3G, 3.5G, 4G and ultimate of 6G. Thanks.
Hi Israel. I am not sure if I understand you correctly. Are you asking for how much time to apply loads on a wing, when load testing? Can you be more specific, please?
I believe Parasite drag is produced by VERTICAL surfaces and Induced drag is created by HORIZANTAL surfaces ONLY, please let me know if you think I am correct. Thanks
Thank you for your reply, can you confirm the following statement using your spreadsheet with just one number? When the Flaps are at 0 degrees they produce Max Induced drag and Min Parasite drag, at 90 degrees Min Induced and Max Parasite drag and at 45 degrees in middle of both. @@dr.gudmundssonaircraftdesign
Thank you Dr. Gudmundsson for the content. Your approach and insights are truly great and we benefit a lot from it. Thanks
@ Geoffrey Nyaga Thank you for your kind words. I appreciate it :-)
Good work professor please keep it up....
Thank you, I will :-)
Since design is an iterative process, the first thing I would do after doing the setup work is to create a very simple macro to loop through the altitude increase and copy-paste the results. Exposing min, max and height delta as variables in the second sheet created here gives a lot of flexibility to the user. Similar steps could be taken for the airspeed table on the first sheet to address the stepping discussed. Only thing I would add is, use a straight line between points on a graph, and, show points. This isn't as pretty, but it is accurate for the data you are displaying, as you haven't calculated the data between points. (18 years as a stressman working airliners, UAVs mostly).
@scott_aero Excellent observation. I have a code that does exactly what you're suggesting. That said, please keep in mind the audience this is intended for; undergraduate students. This 12-min video replaces a 1.5 hr lecture in class (that includes Q&A) and, thus, saves a lot of time. Astute students write VBA code for this task although this is not asked for in the class plan. Best wishes.
@@dr.gudmundssonaircraftdesign Yep, I remember being in the undergrad students shoes and having to do very similar tasks without years of experience and personal molding into the shape of a stressman! This was not a knock on your presentation btw, just some helpful hints for interested viewers - things I wish I knew!
@@scott_aero3915 No worries. We're on the same page. Best wishes.
I really like your book, it’s very helpful and informative.
Being an engineer in a different field, I started out doing a lot of things in excel, but more and more I’ve come to the conclusion that excel is really the wrong tool for most things. It quickly becomes either a buggy mess, but more likely unwieldy to maintain and improve. I would suggest it is far better in my opinion to use an actual programming language not excel. You can always use it to generate tables and plots.
Doing manual steps like copy-paste is both fraught with potential error(no way to know if it’s up to date), but also very manual and slow.
@brandonhicks7549 Thank you for your kind words about my book. Also, thank you for your comment.
I used to say the following to my students: "Regard your computational tools like a carpenter regards his/her toolbox. There is a right tool for each situation. Don't pick a sledgehammer to put a nail in the wall for grandma's picture. And don't pick a ball-peen hammer to break down that wall."
Engineer's preferences are as many as there are engineers. Some engineers prefer to only use Python, others only VB, C++, and even Fortran. Other engineers prefer to only use Excel, and yet others only use Powerpoint and Word for writing/presentation purposes. Then, there are engineers that use tools from all categories. I am that kind of an engineer. I use that which I deem to be the most practical for each situation. Sometimes, I write examples in Excel that I use to validate my code. At other times, I write code to spit out numbers that I plot in Excel to display in Powerpoint. Yes, many people write impossible-to-understand, under-remarked spaghetti-spreadsheets. But then again, many people write impossible-to-understand, under-remarked spaghetti-codes. Neither speaks to either tool, only to the writer. To me, Excel is one of the most useful engineering tool I use. Nothing can change that. One of its strengths is that most engineers know it. The problem with code writing can occur when the boss has no exposure to the engineer's favorite programming language. One's boss may have a business degree and not have any coding exposure, but can still use Excel. That universality is unmatched by any programming language. Excel is well known by most. Programming languages aren't.
Thank you very much for the video, it was very helpful!
It seems there is a small heading error for the Vr in the envelope sheet: it should be "best range" and the 4th parameter should be R, nm.
Also, is it possible to calculate Vmin for level flight using this workflow?
Thank!
@bleauchot Thanks for that comment. Good catch. Consequence of a rapid copy-paste action on my part. Yes, you can add Vmin using the same workflow. Best wishes.
thank you professor for the tutorial, recently i bought a Chinese version of you book and i just keep coming to your channel for tutorials. i'm interested to know do you have any plan to record as a course like those usually we buy from Udemy. it would be really helpful for us. alongside the book and tutorials would be a great resource for aircraft design enthusiasts.
@star man Thank you for your comment. No, I have no plans to record complete courses. I simply don't have the time currently. So, I will stick with this format (occasional release of videos) for the time being. Sorry about that.
Good day Dr. Gudmundsson. Thanks for your educative content sir. My question is off this particular topic but i need your idea sir. Please in performing the load test of an aluminium wing, I'll like to know the time frame used in simulating the aerodynamic loading conditions at 2G, 2.5G 3G, 3.5G, 4G and ultimate of 6G. Thanks.
Hi Israel. I am not sure if I understand you correctly. Are you asking for how much time to apply loads on a wing, when load testing? Can you be more specific, please?
@@dr.gudmundssonaircraftdesign yes sir, How much time to apply load on wing when testing at 1G, 2G's, 3G's up to the ultimate load.
@@israeloluwagbemi825 A common rule-of-thumb is to let load less than limit load rest for three minutes and above limit load to rest three seconds.
@@dr.gudmundssonaircraftdesign thanks alot sir. I really appreciate your help.
I believe Parasite drag is produced by VERTICAL surfaces and Induced drag is created by HORIZANTAL surfaces ONLY, please let me know if you think I am correct. Thanks
@ShonMardani Thank you for your message. You are wrong. Why would you think so?
Thank you for your reply, can you confirm the following statement using your spreadsheet with just one number?
When the Flaps are at 0 degrees they produce Max Induced drag and Min Parasite drag, at 90 degrees Min Induced and Max Parasite drag and at 45 degrees in middle of both.
@@dr.gudmundssonaircraftdesign
@@ShonMardani No, the spreadsheet shown in the video is super simple and is intended for teaching only. It does not feature changes due to flaps.
Does anyone have this spreadsheet ready??
Not yet.