Collector Force Spreadsheet
Collector Force Spreadsheet
(OP)
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.
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.
RE: Collector Force Spreadsheet
It would be more useful if you didn't have the code hidden.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Collector Force Spreadsheet
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.
RE: Collector Force Spreadsheet
Tunalover
RE: Collector Force Spreadsheet
You may now be official malware beta testers.
I hope otherwise.
Mike Halloran
Pembroke Pines, FL, USA
RE: Collector Force Spreadsheet
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