10,000 Posts in the Technical Library!

Today we exceeded the 10,000 document mark in our technical library. Many thanks and much respect are due to Kenan Stewart for handling all of the library data and Mike Sharpe of Infinet Technologies for creating the website front end and back end. When we launched the revamped website with the technical library Mike asked me how many items would finally end up in the library and I guessed at around 6000. We passed that mark some months ago and have surpassed my most optimistic predictions of reaching 10,000 items by the end of this year.

Our aim is to create the leading on-line Aerospace and General Technical Engineering Reference Library and the best free software tools and references.  We are well on the way to doing that.

 

XL-Viking Excel Equation Add-in: New Look and Improved Trial Version with No Expiry!

We are happy to announce that our partner company XL-Viking has an improved website and also has a new free trial version that has enhanced functionality with no expiry.

The free trial version now has the fully functioning menu with easy to use ways to add mathematic symbols and Greek letters as well as the subscript and superscript characters and convert functions.

The free trial version now has the XLN function that displays excel in-cell equations with the values used in the math expression.

What’s even better is that the all of this functionality in the free trial version now never expires. It is yours to use for free for as long as you want.

XL-Viking is the tool that we use to display the math in all of our Abbott Aerospace standard spreadsheet methods. We developed XL-Viking for that purpose and XL-Viking is now used by a major aircraft OEM and a leading global engineering service supplier to help them enhance their use of Microsoft Excel as an analysis and reporting tool.

The Abbott Aerospace Spreadsheets have been downloaded over a hundred thousand times and are used to develop and certify aircraft all over the world. Our spreadsheet methods are defined and referenced to the source material in our Free Engineering Textbook.

XL-Viking, our Spreadsheet Tools and our Engineering Textbook places you at the forefront of aircraft development and certification with the best tools in the industry.

 

 

Cost Engineering – for Engineers.

In our office, we have been discussing how to implement effective design cost control and/or monitoring. We have had the good fortune to have worked on many different levels of projects from multi-billion dollar high-performance  jet program to much more humble part 23 prototypes. We have learned the importance of asking the following questions: Why use a NAS or MS bolt when AN bolt will do?, what is the true cost delta of a weldment vs a CNC machining? a metal fabrication vs a CNC machining? What cost driver triggers the move to composite materials? Which composite material offers the best cost/performance compromise?

The answer, as always, is “it depends”. It depends on the number of parts to be made/procured, it depends on the tolerances required, the strength requirements, supply chain security, the in-house skills available vs using an outside contractor, does the company quality system have the facility to support your choice? The relative cost impact on certification of the available choices, the cost of labor,  etc etc

There are universally acknowledged cost drivers – the cost/weight trade off, the idea that at a certain point weight reduction means the introduction of additional complexity and therefore cost – although a few years ago I was sat in a meeting with a leading aircraft company president and he denied that the cost/weight relationship existed. “Universally acknowledged” may be an overstatement…..

Regardless, most designers and analysts have a vague notion of whether something is more expensive than something else. On occasion, if they design something particularly egregious the manufacturing engineer will send them a nasty email about how expensive it is going to be.

On a part by part basis and on a sub-assembly basis engineers are used to tracking part count and weight in the Bill of Material – either on the face of the drawing or in a separate material and weight accounting system. One thing we have never seen (please let us know if this is done at any organizations we have not worked with) is a cost column included on the bill of material that the engineer creates. Typically, the engineer is blind to the unit cost of each of the items.

Engineering is a discipline that should and does include cost control, whether or not the engineer realizes it. Product development means developing a product that can be sold at a competitive price point and make a profit. Engineers generally do not deal with cost on as regular basis as they deal with strength, weight, durability – but they should have an intimate understanding of cost. We have noticed a lack of cost consciousness in ourselves and with the projects we work with – and in some cases, our cost consciousness has been improved through significant cost constraints placed on projects by our clients.

So what cost goes on the drawing? – the cost of a prototype part can be many times the cost of a production part and the numbers involved in an initial production run may be many times lower than the number of parts produced in the overall life of the product.early-production-economics

The most egregious example of this is the development of the Eclipse aircraft program where the final price point of the aircraft was predicated on the assumption that they would sell 1000 aircraft per year. While optimism is a very important aspect of getting a new product or company off the ground, an excess of optimism creates an excess of ‘undesirable outcomes’. The costing done in Eclipse was likely unrealistic even if they had reached their desired production rate.

This is especially critical if the program tends to run beyond the intended schedule. The first aircraft orders placed are at the initial offering price. The price of the aircraft tends to increase over time as reality bites. If the development schedule extends this problem is worsened because there are additional development costs to recoup in addition to the basic (and increasing) manufacturing cost. There are many aircraft that were initially offered to the market at sub $1M prices that end up at over $2M.

The effect of this on the OEM can be catastrophic. After the expensive development process has been completed an OEM often has to face the harsh reality of selling the first year or more of aircraft at a loss. The initial customers end up paying less than the cost of manufacture of the aircraft.

This often will drive a company into bankruptcy a few months into serial production. Just when you think they should be beginning to reap the benefits of the many years of expensive development, the financial backers have to dig deeper and sometimes this is too much for the corporation.

Understanding the true cost of the aircraft and how the cost changes during development may not avoid this issue but it will put companies in a position of

  1. Controlling the cost, or at the very least having visibility of the cost
  2. Being able to plan to cope with the first few months or years of production and work with the investors to manage expectations and keep the company solvent

I know that many larger companies do understand these issues and manage them effectively. For smaller aircraft companies it often looks like these issues are either unexpected or mismanaged in some way. This is understandable, smaller companies have a smaller talent pool and  less experience to draw on within the management team. There is
a greater probability that some issues will fall through the cracks and this issue seems to be one that has proven fatal for many companies and aircraft programs.

In smaller aircraft companies there is a need for all staff to be multi-disciplined some extent. It is time that engineering started to pay more attention to the critical commercial aspects of the work they do and help management by making better choices and communicating the kind of commercial information that allows management to improve planning and make better decisions. It is common for engineering to blame management for commercial failures.

Including detailed cost breakdowns in the data produced and used by engineering will be useful only if the information is realistic. Realistic costing helps in two major ways.

  1. an accurate absolute cost per unit lets the corporation set a realistic price point and understand the margin on the finished product vs the sale price- and all of point 2. below
  2. an accurate relative cost per unit lets the product development team make rational choices between alternatives and understand what is driving cost into the product but does not help set the price point or calculate the profit margin.

I suggest that unit cost for the realistic production rate is put in the  Bill of Material and on the drawing. A realistic  production rate will be a bone of contention. It is not just Eclipse that is guilty of blue-sky thinking in that arena.

For low volume production, an approximate relationship between the volume ordered and the difference in cost should be established and used to estimate the higher cost per
aircraft.

To conclude – should we regard cost control like weight control? We spend the extra time to get the last gram or ounce out of part – should we do the same to get the last cent, penny or rupee out of a part? Is an  aircraft that has great performance and payload capacity but no profit margin any better or worse than an aircraft that fails to meet its performance marks but can be made at a profit?

To access more exclusive content like this subscribe to our mailing list


Open Letter Regarding Google

It is risky as a business owner to make a comment that could be interpreted as political. Especially in North America where anything and everything is interpreted as political. This comment is apolitical. If you choose to interpret it as a political comment I can’t stop you.

We have been using Google since we started our business and I have been using it since the days of Altavista and I really like the service they provide. There are some downsides – the way Google Adwords is structured is ‘suspect’ in terms of providing real value for cost. We have used it from time to time and have ended giving money to Google for results that were not great and potentially questionable. So we don’t use Adwords anymore for any part of our business and we are happy.

We don’t let Google place adverts on our website. This is to keep the experience ‘clean’ for our users but it means that we will not do as well as we could when people use the Google search engine, but that is OK. Google provides a lot of useful free services and they have to fund that somehow.

In the recent US presidential election Google has been showing clear political bias which has been confirmed in their weighting of search results and also how youtube videos are promoted and also how monetization is being applied or denied – and I see that as a problem. I understand that the people running Google have strong political preferences. They also have very good reasons to maintain a good relationship with the political establishment. This takes on much more importance as the regulatory reach and the size of government grows. We have all granted the government the power to pick winners and losers (for good or for bad) and Google wants to be one of the winners.

The problem of government overreach is intensified when government selectively applies the legal and regulatory codes based on political expediency. This can be seen with the US federal government non-enforcement of immigration legal statutes (in direct opposition to the government’s legal obligations to the citizens of the US) and tacit approval of restrictions on freedom of speech on many university campuses in the US in open contradiction to the US constitution.

Google taking a particular political position, when it serves a market from the entire political spectrum, means that Google must have decided that the benefits of maintaining a favorable relationship with the political establishment have a greater benefit than the downside created by a negative reaction from a potentially significant proportion of their user base.

This may be a purely commercial decision by Google. i.e. government in the US has such a large potential commercial impact for large organizations that it is, by some measure, more important to have a good relationship with government that the market they serve. They also may be relying on the apathy of the user base and the fact that they do not advertise their bias so much of their market are just not aware of it.

This should worry all people who are not in government. The government has such power that large corporations will choose to side with the government rather than their market. In the past legislation would have to be drafted to force companies to behave in certain ways. Now it is voluntary, presumably for preferential treatment in exchange. Quid pro quo. This has been happening since the beginning of human civilization, but it is a form of soft corruption. The concern is that as government grows (US tax receipts are at an all-time high and the deficit is still very, very large) the level of corruption grows at least proportional to the size of the government.

I do not believe this is a left vs right argument. It is a large government vs small government argument. No matter the political persuasion as government gets larger corporations have to adopt the government point of view or find itself in ideological opposition to the government. When you want that tax credit, grant or interest-free loan from the state, when you want a tweak to the regulations to hinder a new competitor, who do you go to? Once companies realize this they will align their political interests with their commercial interests and act accordingly. It is just survival.

I also don’t think that any of the parties or candidates  in the current election cycle represent a political will to significantly reduce the size of government.

As a business owner who pays Google for their services should I stop and find an alternative that is truly apolitical? Will it matter in the end? At this point is there any practical way to escape the matrix of large corporations and government? Do we all just have to play along? Should we all just line up at the trough and wait for our turn? Or do we just carry on giving money to corporations who use that money to consolidate political power rather than serving their market?

I don’t mind politics – knowledge of and participation in the political system is healthy. Where does politics stop and corruption begin?

 

Market Information

We have started to catalog and upload our collection of market information to our technical library. There are many thousands of documents and this process will take some time to complete.

You can get the latest list of market information documents in the section of the library at this link.

Over the coming weeks and months, we will be adding more and as we complete the upload of each major collection we will post an update. First, we are working on uploading our FAA data collection, this comprises of Air Travel Consumer Reports, Airlines Financial Information, Airlines Quarterly Financial Reviews and Consumer Air Fare Reports.

Fly safe!

 


New Stress Analysis Spreadsheets – Von Mises and Principal Stresses

I have been working on the new sections for our free engineering textbook and over the weekend I began writing the chapter for stress tensors (principal stresses, Von-Mises) and failure envelopes (Maximum principal Stress, Von Mises, Tresca).

As a report writing stress engineer you seldom get the chance to stop and consider how these measures of stress came about – and for those of us a significant distance from our college years the reason for using these methods and how they came about can blur somewhat….

This weekend was a very useful refresher for me and I updated and created some new spreadsheets to accompany the new sections for the book. As always, we share those with you.

This set is not yet complete – I have yet to create and upload the Tresca envelope, – but it is Monday morning and a good time to share what we have done.

These spreadsheets fit into the AA-SM-041 series that also include the calculation of shear stress distributions over common cross sections.

Let us know what you think and if you spot any errors be sure to let us know so we can share the corrected versions.

AA-SM-041-000: Stress Analysis – 2D Principal Stresses
AA-SM-041-001 Stress Analysis   3D Principal Stresses
AA-SM-041-020 Stress Analysis – 2D Von Mises Stress
AA-SM-041-021 Stress Analysis – 3D Von Mises Stress
AA-SM-041-025 Stress Analysis – Von Mises Stress Rectangular section, No Torsion
AA-SM-041-026 Stress Analysis   Von Mises Stress Rectangular section, Incl. Torsion
AA-SM-041-027 Stress Analysis – Von Mises Stress Circular Tube section, Incl. Torsion
AA-SM-041-030 Stress Analysis – Mohrs Circle

Free Structures Engineering Textbook

After a month restricted to limited release to the members of our mailing list we are now distributing our free structures engineering textbook to the rest of the world.

This book is free for you, your friends and your colleagues to use without limitation. The book links to free spreadsheet methods and all references used within the text.

Our aim is to create a new paradigm in engineering references – giving the best methods, textbooks, tools and references away for free.

By keeping it free and in an electronic form we can issue regular updates, make corrections and improvement as and when they are needed. Every edition will carry an ISBN number and will be referenceable from technical reports.

The book is structured to be future proof and will maintain the same section and subsection numbering through all of the future editions.

We hope you find it useful.

 

 

Time and Cost to Market

An old colleague of mine (Dave Robinson) recently posted an article on linked in. It was a video of an AIAA discussion panel on why aircraft take more than 4 years to bring to market. I have to admit that I did not watch the whole video. It was over 2 hours long and I have things to do – not least of which is to create some content for the newsletter and the website.

In the 25 years I have been involved in the industry (and growing up – both my parents are engineers and both started their careers at Avro in Woodford, just south of Manchester in the UK) I have seen projects take longer and longer. From military aircraft to commercial to part 23 GA projects there is a disease in the industry. we understand the major symptoms; budget and schedule overruns. However, we do not understand the underlying illness – the malaise at the heart of the industry.

It may better to use a more appropriate medical term – the industry suffers from a syndrome rather than a specific illness. There are multiple symptoms and causes. Some causes look like symptoms and some symptoms look like causes.

No company is immune. Until recently the doughty Cessna had an excellent track record of well-defined products, good price points and well-executed certification and development programs. Then the Skycatcher came along and showed that the infection had spread even to Cessna.

We have been working on part 23 GA and light jet and part 25 business jet programs for nearly 10 years. Almost every program (I say almost. there are several programs we are currently engaged on and we work towards and hope for a better outcome for those) has suffered from what I call the ABSOS – Aircraft Budget and Schedule Over-run Syndrome.

There are several key factors that contribute toward an acute incidence of ABSOS.

  1. Executive Paralysis
  2. Hollowing out of Middle Management and the use of Professional Project Managers
  3. Organizational Confusion – IPDT, Matrix Management, etc
  4. Overuse and Misuse of Subcontractors
  5. Overuse and Misuse of Digital tools in the development process

Before I lay into the industry, it has to be said all of these criticisms are general, there are excellent individuals I have worked with in executive, technical management and project management positions – in particular, Warren Wishart, a professional project manager who was essential in keeping a team together against the odds. It also has to be said that the right person in the wrong position is the wrong person. For those of you have worked with me, this article is not a criticism of any individual. Everyone I have worked with has been honest and hardworking – the problem comes when honest and hardworking people are put into an inappropriate position or a dysfunctional environment. Something I am sure most of us have first-hand experience of .

It should be pointed out that the boundaries between these 5 points are blurred and none of these points exist without all of the others.

Let us start at the top………………

To read more of this free content subscribe to our mailing list

Beam Analysis – Spreadsheets and Sources

For the next issue of the book, (the current issue will be available to the general public for free at the end of September) we will be adding a beam analysis section. However, as with the rest of the content for the book, we want to give reference to a trusted external source for the methods we use. In this case, and after some deliberation, we have settled on the NASA-TM-X-73305 Structures Manual. It covers some beam configurations I have not seen covered elsewhere and the whole beam analysis section is excellent.

We have started by creating the spreadsheets for cantilever beams and these have now been posted, you can access a list of them here:

If you find any errors or have any comments we would love to hear from you. The link to the contact form is in the footer of this web page.


Section Property Spreadsheet for Common Shapes – Update

Today we uploaded a corrected version of our section property spreadsheet for common sections. This corrects some errors in the calculation of the first moment of area and the plastic bending shape factors. Revision C is the corrected version. We have also added more plastic shape factors and changed the term for First Moment of Area from ‘S’ to ‘Q’.

AA-SM-001-000