create spreadsheet for lintel design to BS5977

The task is to create MS Excel spreadsheet for lintel design to BS5977 including Amendment No 1. The end requirement is quite simple: to calculate equivalent UDL on lintel. The spreadsheet is to cover up to three storey buildings, as per the code. A good example of calculation steps can be found in CSC Tedds software, and four printouts are attached for your information only. Also attached is a spreadsheet listing all required user input cells. VBA is not allowed for calculations. You are required to include simplified diagram showing the wall/lintel in elevation. The diagram is to be either an Excel chart or created with VBA. The diagram is to be 'live' i.e. change in accordance with input cells (element location, size etc). Ideally dimensions should be included on the diagram. The spreadsheet is to include only one tab, is to be comprehensive and easy to use. Note: you must have experience in developing structural engineering spreadsheets to be considered. You will have to follow BS5977 and the Tedds examples yourself, you will NOT be give a set of equations. The spreadsheet must work correctly, the results will be checked with Tedds software or similar. You are expected to be able to deliver error free spreadsheet with no supervision in the time as per your bid. Any errors in calculations will result in a lower feedback, so make sure there are no errors. At the end of the project you will have to send PDFs of how your created spreadsheet deals with the attached four cases from Tedds. You may be asked to provide more PDFs printouts for other cases. If you have not bid on one of my previous projects then make sure to send a PDF file of your most recent spreadsheet so that I know that you have adequate experience. If you worked for me before (or are working at present) then feel free to bid on this project as well. If you having access to Tedds then mention it in the bid description as this is advantageous. By bidding for this project you agree that you will transfer all rights to the created spreadsheet to me - so that I have not problems with officially using the spreadsheet etc. You will have to sign a non-disclosure agreement where you agree to this (e.g. that you will not give away, sell, pass on etc anything that you create under this project). This is one of a several spreadsheets that I need developing in the nearest months (already had several developed on freelancer.com). Therefore if we both find this co-operation satisfactory you will be asked to price on other projects. Let me know if you have any questions. Thanks.