Finance 3.0 - Social Network for Finance
Smart financial thinking
-
Shakeel
- Male
- Pakistan
- Petroleum Economist
- Share
- Share on Twitter
- Share on Facebook
- Blog Posts
- Discussions (12)
- Events
- Groups (1)
- Charts
- Chart Portfolios
- Videos
- Shakeel's Apps (1)
Shakeel's Discussions
Excel Model (Need Help)
Dear Sacha, This technique is simple but very valuable. Thank you very much. Regards, Shakeel
Replied Feb 10
Excel Model (Need Help)
2 Replies
Hi All,I need to develop a time based model that i want to be expired after a certain amount of time. Kind of like a trial version. After a certain date the excel workbook will not run and the spread…
Started this discussion. Last reply by Shakeel Feb 10.
Expiration of Excel Model
Thank You Agrawal, But a smart guy can easily break it. He just have to reverse the time of his computer and will use it again. I was thinking what if he/she open the spreadsheet and find it absolut…
Replied Oct. 23, 2009
Shakeel's Page
Gifts Received
Shakeel has not received any gifts yet
Latest Activity
Dear Sacha,
This technique is simple but very valuable. Thank you very much.
Regards,
Shakeel
Supose yoiu do not wish the model to run after 20 Feb 2010. This is 40229 in Excel date series. Enter Today() in any cell, say in A1. Mkae the key operations subject to A1
Hi All,I need to develop a time based model that i want to be expired after a certain amount of time. Kind of like a trial version. After a certain date the excel workbook will not run and the spreadsheet will be blank. How can I formulate it or how…
Hi Sharma,
You probably want to calculate the interest payment at the rate of 11% (annual rate) per month.
In Excel write a formula i.e. =(1+0.11)^(1/12) and =(5)^30. You will get your answer. The Symbol ^ denotes "Power Of".
I hope you got your a…
Thank You Agrawal,
But a smart guy can easily break it. He just have to reverse the time of his computer and will use it again. I was thinking what if he/she open the spreadsheet and find it absolutely blank??
What you think!!!
Regards,
Shakeel
This should work.
However there is no security in Excel, be it Protection or the above that will prevent a clever person from getting to the data. Unless someone knows better?
Guess this should block the workbook from being opened from 25th October onwards.
Private Sub Workbook_Open()
Dim ExpDate As Date
ExpDate = DateSerial(2009, 10, 24)
If Date > ExpDate Then
MsgBox "Workbook Expired"
ActiveWorkbook.Close
End If
End Su…
Hi All,
I need to develop a time based model that i want to be expired after a certain amount of time. Kind of like a trial version. After a certain date the excel workbook will not run and the spreadsheet will be blank. How can I formulate it or h…
Dear Anand,
Thank you for your time. It's really helpful. It solve my problem.
Regards,
Shakeel
Hi..
how did you worked out the year and month calculation in PT
hi..
Here is your file. Hope this will solve your issue. You can hide the columns which are not required.
regards,
Anand
Create a formula in Col C on the Daily sheet showing just Month/Year i.e. DATE(YEAR(C8),MONTH(C8),1), then use the SUMIF and COUNTIF formula on the Monthly sheet.
I got the same answers and no I wont upload it, by working it out for yourself you wil…
Thank you Anand. The file using Pivot Table is attached for your information.
Dear lilolee
I appreciate your response but the problem is, I couldn't able to compose that formula. I tried it so many times but there is a problem with the values on the back of each date. (e.g. Just to sumup the values of December 93, if i use t…
hi...
Can you pls upload the file wherein you have done the calculation vai Pivot Table. That would help me quickly giving you the solution.
regards
Anand
Isn't Average=Sum/Count or to put it another way AverageIf=SumIF/CountIF
Profile Information
- Profession:
- Petroleum Economist
- Current Role:
- Petroleum Economist
- Education:
- Master in Finance & Economics
- Professional Skills & Interests Summary:
- Upstream Petroleum Economics
Upstream Oil & Gas Economic Modeling
- Current Location:
- Islamabad
- Interested In:
- career opportunities, consulting offers, expertise requests
Sign in
Badge
Continuing Education
 |
Accounting |
 |
Banking Regulations |
 |
Certification Training |
 |
Commercial Bank Management |
 |
Corporate Finance & Valuation |
 |
Treasury Management |
 |
Credit Risk Management |
 |
Financial Derivatives |
 |
Financial Institution Management |
 |
Financial Markets |
 |
Financial Modeling |
 |
Financial Planning |
 |
Market Risk Management |
 |
Operational Risk Management |
 |
Operations & Compliance |
 |
Quantitative Analysis |
 |
Strategic Financial Management |
Newsletter
Linkedin
RSS
Facebook
Widgets
Twitter© 2010 Created by Finance 3.0
