Excel Spreadsheets

buckley12

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

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

buckley12

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

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

chris85

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

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

PM me if you want further info.

buckley12

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?