Fun, Learning, Friendship and Mutual Respect
START  HERE


Unregistered
Go Back   HeliFreak > Blogs > The Trials & Tribulations of a Learner



If you are reading this...

Rate this Entry

Heli Crash Calculator - V1.0

Posted 02-16-2010 at 06:18 PM by ted_wears_a_hat

Hi helifreaks, I hope everyone is well.

A recent thread posted by Slyster regarding crash comparison costs got me curious. I have had it quoted to me a number of time "get the biggest you can afford to crash" yet the data Slyster posted appeared to indicate that size may not be entirely indicative of crash costs.

What was also obvious from the thread and the replies is that not every heli crashes the same and what always breaks on one heli may not ever break on another and may break only on occasions on yet another heli!

I started looking at parts sheets and thought this would be a lot easier with a simple Excel sheet to co-ordinate all the parts lists and create comparisons. As I slung a few numbers around I thought this might be a useful tool for a few other folk so put it together with some push buttons so it is easy to use.

Attached is the result of this along with a couple of completed template part lists. I will attach some compiled but not fully complete sheets as well, I wasn't able to complete some parts of the sheet (stock or upgrade, units per pack etc) as I do not own the helis in these sheets.

If you use it and put together a part sheet, either with or without crash ratings, please feel free to share it.

I have also attached a couple of sheets of example output. A crash log for my Blade 400 and a crash cost comparison between the Blade 400 and the MSH Protos.

Below is a list of features and instructions. It was put together really quickly so it is not in any way elegant but it does the job. As it was just pieced together in a couple of hours at night it is unlikely to be error free and I haven't tested the comparison creation with loads of different helis but it all seems to work.

Please feel free to add comments, bugs, criticisms etc.

System Requirements:

  • Microsoft Excel.
  • Best viewed at a minimum screen resolution of 1280 x 720.
Features:
  • Click button to import heli parts data (please use provided template).
  • Click button to delete heli parts data and index references.
  • Rate crash frequency of all user included parts, stock and upgrade.
  • Create crash comparison amongst any or all user imported heli parts collection using the selected crash frequency and a variety of user selected option.
  • Export crash comparison sheet for printing or sharing.
  • Export, share and import heli parts data with additional user created crash ratings.
  • Create your own crash log by model, with a summary output and a more detailed part by part breakdown.
User Instructions:

Importing Files

Use either the "Import Heli Parts Template Data w/o crash rating data" or the "Import Heli Parts Template Data w crash rating data" buttons to import heli parts data or heli parts data with user created crash rating data respectively.

It is imperative that the import file is in the template format and contains a sheet called "Heli Parts Import". This import file template is attached.

Exporting Files

Use either the "Export Heli Parts Template Data w/o crash rating data" or the "Export Heli Parts Template Data w crash rating data" buttons to export heli parts data or heli parts data with your own user created crash rating data respectively.

This export will create a file in the template format, containing a sheet called "Heli Parts Import" allowing this to be imported by other users. Please share your parts compilations with other users here:

Deleting Imported Files

Use the "Delete Part Data Sheet" to remove any user imported data sheets. Please note this deletion is permanent so be sure to export any data you wish to keep.

This deletion process removes all references to the imported data. Please note the deletion process can be stopped after a model has been selected. Please select carefully from the on-screen prompts.

View/Amend Stock Levels and Crash Ratings

Use the "Edit/View Crash Ratings and Parts Stock" button to add, amend or view your crash ratings and parts stock. Select the heli you wish to review or amend data for in the drop down box and click OK.

In the generated sheet enter stock amendments into column J and your average crash ratings into column H. Please note these average crash rating can be any decimal. For example if one piece always breaks in a crash give it a crash rating of 1. If a part is more likely to break every 10 crashes enter a crash rating of 0.1.

These ratings and stock levels are then used in crash comparison and crash log calculations.

Once you are happy with your ratings and stock amendments use the orange button at the top of the sheet to return to the control sheet.

Creating Crash Comparison

To create a crash cost comparison click on the "Create and Export Crash Comparison" button on the control sheet.

Follow the on-screen prompts to select the models you wish to compare. This list is built from all imported heli parts data sheets that have been imported by yourself.

When you have selected the models you wish to compare a new sheet will be generated listing average crash costs by heli area, a total average crash cost and a full list of parts with a crash rating.

Once this is complete use the buttons to the left of the sheet to either delete this sheet and return to the contol sheet or export and save this comparison. If you choose to export and save this sheet the usual save dialogue will be shown, the file will be saved according to your entered filename. This file will then be closed and you will be returned to the control sheet.

Creating Crash Log

To create a crash log click on the "Create a Crash Log" button on the control sheet.

Follow the on-screen prompts to select the model you wish to create a crash log for. This list is built from all imported heli parts data sheets that have been imported by yourself. If a partially completed crash log already exists (WIP log held field on the control sheet = Y) you will be prompted to either return to this sheet or delete it and start a new log.

When you have selected a heli (or a partially complete log) a new sheet will be shown. This sheet has been pre-loaded with parts added to the database as part of the import process. Please complete column H (headed 'actual parts used') with the number of parts needed to return the crashed model to flying order. Please use the same logic as used in the parts per pack column.

If you wish to save this sheet before completing the entire form please use the appropriate button at the top of the sheet.

If you do not wish to complete the sheet and wish to delete it and return to the control sheet please use the appropriate button at the top of the sheet.

To complete the crash log click the "use these values and create a crash log" button, this will check that at least one part has been used and will then export the sheet and allow the user to save this export before returning to the control sheet.
Attached Files
File Type: zip Complete Data Sheets.zip (16.8 KB, 299 views)
File Type: zip Incomplete Data Sheets.zip (73.3 KB, 270 views)
File Type: xls Crash Comparison - B400 & MSH Protos.xls (18.5 KB, 339 views)
File Type: xls Crash Log - Blade 400 - 20100210.xls (20.0 KB, 291 views)
File Type: xls Heli Parts Calculator v1.0.xls (420.0 KB, 287 views)
File Type: xls Heli Parts Import - Template.xls (13.5 KB, 276 views)
Posted in Uncategorized
Views 1835 Comments 0
« Prev     Main     Next »
Total Comments 0

Comments

 


Copyright © 2004-2011 - William James - Helifreak.com