Collector Force Spreadsheet

[india1978]

Hello Everyone,
I have created a spreadsheet, which employs a macro to calculate the Maximum Collector Force. I wanted to share it with everyone. The spreadsheet is self explanatory, but please let me know if you have any questions.
Thanks.

 

[IDS]

How do you define the "collector force"?

It would be more useful if you didn't have the code hidden.

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[corus]

I had a compile error in a hidden module when trying to change the wall to opening, whatever that means.
I think that in spreadsheets there should be an 'introduction' sheet that explains the purpose of the sheet and some explanation of the calculations, particularly if they're hidden in macros somewhere. Otherwise you can't check the results and have little confidence in the same.

 

[Tunalover]

Good point corus!

Tunalover

 

[MikeHalloran]

OP has been here ~five days, and you guys ran his code without inspecting all of it first.

You may now be official malware beta testers.

I hope otherwise.


Mike Halloran
Pembroke Pines, FL, USA

 

[india1978]

Hi,
Attached is an example of a Collector Force calculation, which is also shown on the spreadsheet as Wall 1.
What it means by 'Wall' or 'Opening' is that the first section could be a solid section or not, so it gives you the option. You may leave it as 'Wall' and even if you have the first section as an opening, then put the first value as 0. And I'm also not sure why you're getting a compile error.

This spreadsheet is really intended for Structural Engineers. Furthermore, my intentions are altruistic, for I have no desire to spread viruses or malware!
Sincerely,
india1978