create spreadsheet for column base plate design to BS5950

Closed Posted Nov 6, 2014 Paid on delivery
Closed Paid on delivery

The task is to create MS Excel spreadsheet for steel column base plate design to BS5950. The spreadsheet is to cover the following column section types: UC, UB, SHS, CHS, RHS - all selectable from one dropdown menu. 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. The steel columns are subject to moment, shear and compression/tension. VBA is not allowed. You are not required to create the diagrams, this should make it a lot quicker task. The spreadsheet is to include only one tab, is to be comprehensive and easy to use.

'Joints in Steel Construction - Simple Connections' and 'Joints in Steel Construction - Moment Connections' books by SCI give easy to follow examples. Let me know if you do not have access to these two books.

Note: you must have experience in developing structural engineering spreadsheets to be considered. You will have to follow BS5950 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 [url removed, login to view]). 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.

Civil Engineering Engineering Excel Structural Engineering

Project ID: #6694571

About the project

11 proposals Remote project Active Dec 13, 2014

11 freelancers are bidding on average £87 for this job

c4chamod

Hi, We are a team of Structural engineers providing solutions for your jobs. we have experts in Structural engineering for your Job. . We have done lot of projects worldwide(Aus, NZ, UK, Etc.) we are looking forward More

£100 GBP in 3 days
(37 Reviews)
5.1
Atique1988

I am civil engineering graduate student with extensive experience in spreadsheet creation. You are going to be satisfied with my service for sure. will be waiting for your response. Thanks.

£100 GBP in 3 days
(8 Reviews)
3.8
chaks03

I am a structural engineer and can help you with you. I have my designed excel sheets for BS code so this would be easy for me. Thanks and Regards, Chakshu Gautam

£70 GBP in 3 days
(7 Reviews)
3.2
renesontiongson

Hi! excel automation is my masterpiece. It is my pleasure to help your project. Feel free to message me with your actual data.

£100 GBP in 3 days
(3 Reviews)
2.3
Excellentlancer

A proposal has not yet been provided

£60 GBP in 3 days
(2 Reviews)
2.0
AlexandrK1

please send details .

£100 GBP in 4 days
(5 Reviews)
1.7
sabirshah4545

I can do it perfectly. I have experience in this filed from long time. Just send me message to discuss more about your project and hopefully we can make a reasonable deal thanks.

£52 GBP in 3 days
(2 Reviews)
1.3
owususarfov

As team of high knowledge and experience if such project is pass unto us, there will be no mistakes committed since we know how best we are when it comes to a project like creating spreadsheet. Ple More

£80 GBP in 2 days
(0 Reviews)
0.0
ciphertechnology

I can develop a spread sheet to do anything...I am the expert. I have many degrees including Mechanical Engineering (hon) from England. I can do this work.

£83 GBP in 3 days
(0 Reviews)
0.0
Mostafa2414

A proposal has not yet been provided

£83 GBP in 3 days
(0 Reviews)
0.0
valarmathi22

Hi i worked as a software Engineer and a professor so i am sure that i could full the task assigned as per your norms and also i would promise you that i would finish the jobs given in stipulated time period

£100 GBP in 3 days
(0 Reviews)
0.0
khed

Dear Sir, I am a structural design engineer with working experience in Singapore's consultancy. Currently, I work on project basis for a consulting firm. I do design and drafting of RC and steel structures based on More

£88 GBP in 3 days
(0 Reviews)
0.0
sadlockj

I am a structural engineer with experience designing spreadsheets for structural calculations. The most recent spreadsheets I have developed at work are for rating corrugated metal pipes and rating gusset plates on tr More

£83 GBP in 3 days
(0 Reviews)
0.0