www.sefindia.org

STRUCTURAL ENGINEERING FORUM OF INDIA [SEFI]

 Forum SubscriptionsSubscriptions DigestDigest Preferences   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  RegisterRegister FAQSecurity Tips FAQDonate
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log in to websiteLog in to websiteLog in to websiteLog in to forum 
Warning: Make sure you scan the downloaded attachment with updated antivirus tools  before opening them. They may contain viruses.
Use online scanners
here and here to upload downloaded attachment to check for safety.

Link For Spreadsheets
Goto page Previous  1, 2, 3, 4, 5, 6, 7, 8  Next
 
Post new topicReply to topic Thank Post    www.sefindia.org Forum Index -> SEFI General Discussion
View previous topic :: View next topic  
Author Message
raghav_krishan_chadha
SEFI Member
SEFI Member


Joined: 27 May 2016
Posts: 1

PostPosted: Sun Mar 04, 2018 5:10 pm    Post subject: Link For Spreadsheets Reply with quote

Dear Sir,



A warm regards from your formal student of m-tech Batch (2012-2014).




Acc. to my point of view the parameters which i think are missing for this excel as professional are  :-


1.   As we are placing the foundation 1mt. below NSL for the Safe bearing capacity load, so we need to add the additional soil load which will act on it.
2.  There is no check for sliding, overturning.
3.  To make excel more effective we can use like the image below to make it user friendly. 











A Very Warm thanks to you and rest Faculty Members for making me what i Am.




-- 


(With Regards)


Raghav Krishan Chadha

raghav.krisha.chadha@gmail.com (raghav.krisha.chadha@gmail.com)
(C) 9464718014




























On Thu, Mar 1, 2018 at 5:21 PM, hsrai <forum@sefindia.org (forum@sefindia.org)> wrote:
Quote:
           A spreadsheet to Design RC Wall Footing may be explored and used at:

http://bit.ly/dcsWallFooting

If you suggest anything to make it more useful for:

a) Students
b) Professionals

then I would like to incorporate that changes there.
     


H.S.Rai
     



     


Posted via Email



image.png
 Description:
 Filesize:  106.13 KB
 Viewed:  78 Time(s)

image.png


Back to top
View user's profile Send private message
PushkarKokane
General Sponsor
General Sponsor


Joined: 18 Dec 2017
Posts: 17

PostPosted: Mon Mar 12, 2018 10:31 am    Post subject: Re: Excel design sheets Reply with quote

PPK wrote:
Sir. how to unprotect those files ?


respected Sir
follow this site

https://uknowit.uwgb.edu/page.php?id=28850


Sub PasswordBreaker()

'Breaks worksheet password protection.

Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub
Back to top
View user's profile Send private message
anas_a
General Sponsor
General Sponsor


Joined: 24 Feb 2017
Posts: 4
Location: Kollam, Kerala

PostPosted: Tue Mar 13, 2018 2:38 am    Post subject: Reply with quote

Dear sir,

The excel file is protected with some password. How can i use it for designing?
Back to top
View user's profile Send private message
hsrai
...
...


Joined: 26 Jan 2003
Posts: 136
Location: Ludhiana, Punjab, India

PostPosted: Thu Mar 15, 2018 12:57 am    Post subject: Reply with quote

anas_a wrote:
Dear sir,

The excel file is protected with some password. How can i use it for designing?

If your email is for me, then in my spreadsheet all data can be changed. So you may use it for design.

_________________
H.S.Rai
Back to top
View user's profile Send private message Visit poster's website
hsrai
...
...


Joined: 26 Jan 2003
Posts: 136
Location: Ludhiana, Punjab, India

PostPosted: Thu Mar 15, 2018 1:00 am    Post subject: Re: Excel design sheets Reply with quote

PushkarKokane wrote:
PPK wrote:
Sir. how to unprotect those files ?


respected Sir
follow this site

https://uknowit.uwgb.edu/page.php?id=28850


Sub PasswordBreaker()
'Breaks worksheet password protection.
<snip>



Has anyone tried and found success?

Is it right to post such things on this forum?

IIMO, one should avoid unethical and illegal things.

_________________
H.S.Rai
Back to top
View user's profile Send private message Visit poster's website
hsrai
...
...


Joined: 26 Jan 2003
Posts: 136
Location: Ludhiana, Punjab, India

PostPosted: Thu Mar 15, 2018 2:17 am    Post subject: Re: Link For Spreadsheets Reply with quote

raghav_krishan_chadha wrote:

Acc. to my point of view the parameters which i think are missing for this excel as professional are  :-

This is Google Sheet, not the Microsoft Excel sheet.

raghav_krishan_chadha wrote:

1.   As we are placing the foundation 1mt. below NSL for the Safe bearing capacity load, so we need to add the additional soil load which will act on it.

That can be considered in "self weight of footing (assumed).

raghav_krishan_chadha wrote:

2.  There is no check for sliding, overturning.

It is for wall transferring axial load. That is the scope of this sheet. One can extent it, if wishes.

raghav_krishan_chadha wrote:

3.  To make excel more effective we can use like the image below to make it user friendly.

Good point.

Thank you for your review and suggestions.

Have you made any spreadsheet?

_________________
H.S.Rai
Back to top
View user's profile Send private message Visit poster's website
hsrai
...
...


Joined: 26 Jan 2003
Posts: 136
Location: Ludhiana, Punjab, India

PostPosted: Thu Mar 15, 2018 2:22 am    Post subject: Reply with quote

Rabinder Shekher wrote:

It is wonderful work. It takes hard work and patience to collect and upload useful information on the forum.



Thank you Er. Rabinder Shekher for appreciating. Only those can appreciate who have done the similar thing and gauge the efforts involved.

This forum has gems of structural engineers, and salute to their efforts to make this forum a precious forum.

_________________
H.S.Rai
Back to top
View user's profile Send private message Visit poster's website
hsrai
...
...


Joined: 26 Jan 2003
Posts: 136
Location: Ludhiana, Punjab, India

PostPosted: Thu Mar 15, 2018 2:31 am    Post subject: Re: Password protected Reply with quote

Noor ul haq wrote:

Kindly can i get the password.


The password was set to avoid inadvertent changes in the sheet and thus to void mess.

Even that has happened with this sheet. Currently it is not working. Someone has changed something. If anyone can find issue, may repair it.

Anyway, find unprotected file at:

http://bit.ly/hsrWallF2

@ All

Better download it (and see it works, I am not sure) or make a copy.

If you wish to enhance it, please so do, but make sure not to break it.

Always watch what you are doing.

_________________
H.S.Rai
Back to top
View user's profile Send private message Visit poster's website
ranitt.sarkar@gmail.com
SEFI Member
SEFI Member


Joined: 04 Feb 2019
Posts: 2

PostPosted: Mon Feb 04, 2019 6:57 pm    Post subject: The links are not opening Reply with quote

Links are not opening after click its showing 404 notefound
Back to top
View user's profile Send private message
srinivasa rao palla
SEFI Member
SEFI Member


Joined: 13 Apr 2010
Posts: 7
Location: Hyderabad

PostPosted: Tue Feb 05, 2019 5:30 pm    Post subject: Link For Spreadsheets Reply with quote

same problem here also, please clarify

Posted via Email
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topicReply to topic Thank Post    www.sefindia.org Forum Index -> SEFI General Discussion All times are GMT
Goto page Previous  1, 2, 3, 4, 5, 6, 7, 8  Next
Page 7 of 8

 

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


© 2003, 2008 SEFINDIA, Indian Domain Registration
Publishing or acceptance of an advertisement is neither a guarantee nor endorsement of the advertiser's product or service. advertisement policy