Aviation Charter Price Spreadsheet

[connan]

I am in the process of trying to write an Excel Spreadsheet to assist with pricing for an airline charter company that I work for.

We would like to provide our pilots with an A5 sized booklet with all the tracks, distances, times and charter prices from Point A to Point B, Point C, etc.


The idea is as follows:

This first Worksheet lists all the locations we fly into with their tracks, distances and charter costs fpr each aircraft type.



The TIME is calculated by the formula =(C4/'Aircraft Data'!B5)*60



The COST is currently calculated by the formula =ROUND(((((C4/'Aircraft Data'!B5)*2)+0.2)*'Aircraft Data'!C5)/5,0)*5

This second Worksheet has the Aircraft Data - speeds and hourly rate.



Is there a way of setting up the Spreadsheet so that if a formula changes, particularly for the cost, we don't have to change the formula in each cell? Is it possible to write a formula/macro that references another cell/formula from, for instance, the second Worksheet (Aircraft Data)?



Thanks very much!

 

[connan]

I now have this spreadsheet working, but I have changed some column information and now one of the columns is showing "#N/A" rather than the correct calculation results. The cells use the same formula and work correctly in previous cells, but not the remainder.

Can I please get some assistance?

The file can be downloaded here.

Corrections can be emailed to derby@bushflight.com

Thanks very much!