Excel Spreadsheets

buckley12 · 14-02-2012 01:40PM #1

I'm trying to create a generic design/analysis calculation in Excel for vertically and laterally loaded masonry walls. It would be a basic spreadsheet that would work for any question. Any help on this topic would be much appreciated.

breadmonkey · 14-02-2012 01:46PM

IMO your post is far too vague to get any decent feedback. You need to give more details.

buckley12 · 14-02-2012 01:56PM

Oh right thanks! Basically I need to create an excel spreadsheet for single leaf, cavity, single leaf piered and cavity leaf piered walls. I need to be able to take a basic masonry question, input the details from the question into the spreadsheet and have it generate the results. I need to create separate excel sheets for each type of wall that are generic.

breadmonkey · 14-02-2012 01:59PM

I see. Is this for college or something? Are you looking for help with the calculations or their imelementation in Excel?

chris85 · 14-02-2012 03:29PM

I will presume you know the formula required to calculate what you are looking for? If so it is a problem on how to write it into Excel?

I take it you will have parameters and want four results for each wall type using the same parameters.

Need to be a bit more specific.

yourpics · 14-02-2012 07:45PM

I have some spreadsheets for designing slabs, columns, retaining walls etc

PM me if you want further info.

buckley12 · 15-02-2012 03:41PM

Below I have attached the three spreadsheets I have already created. I used calculations I had to create these.
However they are not completed fully as I don't know how to proceed with them. They are not generic enough as some other questions don't work in them.
I also need to create more spreadsheets for cavity and cavity leaf piered walls but I do not have calculations for these.
Would anyone know how I could alter these spreadsheets to make them work?

Excel Spreadsheets

Comments