Re: $$Excel-Macros$$ payback Period Formula / Macro
Hi Shekar, Payback is basically a financial tool to see how much it takes to recover your invest, in other words break even. If I invest Rs. 100 in one project which gives me following returns - 1 year Rs. 30, 2 year Rs. 40, 3 year Rs. 60. We can see that I recover my investment / break even in somewhere in 3 year. We can assume that Rs. 60 occur evenly throughout the year and we come to payback period of 2.5 years For more on this topic, you can simply do a google search. There is no in-build function for this in Excel. Regards, Sharad On Friday, August 10, 2012 2:13:04 PM UTC+5:30, shekar wrote: Hi Sharad, can u explain in brief??, Unable to get what exactly you want On 10 August 2012 11:32, sharad jain jains...@gmail.com javascript:wrote: Hi, I need a formula or macro for calculating payback period which is dynamic. I mean that it can calculate the payback period for series of data without changing the formula itself again again. I am attaching an example sheet with 3 scenarios where we can have same formula / macro. Will appreciate any type of help here. Thanks, Sharad -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. -- Making a million friends is not a miracle, the miracle is to make a friend who will stand by you when a million are against you. Have a Smileness Day With A Smile Rs. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Run a Macro in a give time
Paul, Thank you for the explanations. I think now I'm on right way to solve the problem. Cheers!! Regards, Dilan On Wed, Aug 8, 2012 at 3:30 PM, Paul Schreiner schreiner_p...@att.netwrote: I may not be 100% accurate with this, because programming capabilities change, but... VBA is written WITHIN Applications. Visual Basic is written AS an Application. (VBScript would be a scaled-down version of VB) That is to say, if you want to run a VBA macro, you have to have an Application (like Word, Excel, PowerPoint) to provide the application platform. If you don't want to open the workbook, then you're limited to Visual Basic, VBScript or some other Application-level programming language like C++ Even with those, you'll need to have your database accessible. HOWEVER... You said: I don't want to open the (work)book every day. Why not? You COULD have the scheduled task run at 4:00am every day and, if your macro determines that a specific criteria is met, send you an email. the macro itself would close the workbook, so you'll never actually see it open. *Paul* - *“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* Dilan De Silva dila...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Wed, August 8, 2012 1:48:16 AM *Subject:* Re: $$Excel-Macros$$ Run a Macro in a give time Paul, Thank for your reply. You answer is acceptable up to some extend. But I don't wan't to open the book every day, I just want to execute the macro only. ** ** I have a data base of Insurance expiring dates. I wan't to get a message before the insurance expired. See the attached sheet for the macro. ** ** Are they any method to open the workbook, when a insurance expiring?NO need to open excel sheet every day.** ** ** Regards, Dilan On Tue, Aug 7, 2012 at 2:14 PM, Paul Schreiner schreiner_p...@att.netwrote: I would set up the macro as either a Workbook_open event or name the macro Auto_Open. then, create a Scheduled Task in Windows to open the workbook at 9:00am daily. I do this with several very large macros (and have them run at 11:00pm or 4:00am so they are complete before I come in) and they have worked relatively dependably for several years. *Paul* - *“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* Dilan De Silva dila...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, August 7, 2012 5:42:48 AM *Subject:* $$Excel-Macros$$ Run a Macro in a give time Friends, I want to run a macro* every day in a give time(say 9.00AM)* when the work book not open. Then open the work book and show a message if the given conditions(say two cells have same value) fulfil. see the below written macro for further explanation. But the given below macro not working at the given time. However when I run it manually (go to VB editor and click run button)it's working at any time. Please correct the error and explain. -- Private Sub time2() If TimeValue(09:00:00) Then If Cells(1, A).Value = Cells(1, B).Value Then MsgBox Both are equal Else End If Else End If End Sub --- Regards, Dilan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+
RE: $$Excel-Macros$$ FW: Excel Formula challenge [Solved]
Well said Paul, But I think Objective of group discussion on any tool (Excel here) is not just helping peoples to complete their project it's also to make them expert so that they can use Excel more smartly . so the challenges gives them opportunity to improve their skills and to understand how Array and other formulas works. Yes, I said that I don't think helper column is required. but nobody said that it's not possible without helper column. The Objective behind is to make them think deeply about the situation and post accordingly. That's why I said I was expecting many replies from you. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: 11 August 2012 12:56 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ FW: Excel Formula challenge [Solved] A couple of observations: #1) I was expecting many replies from you Many of us don't consider this a game We're trying to help others with problems with their projects. So, if it's simply a problem posed as a challenge, I for one ignore it. #2) You specifically said: I don't think helper column is required The result utilizes a helper column (E) and therefore doesn't meet the criteria. Paul - Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can. - John Wesley - _ From: Rajan_Verma rajanverma1...@gmail.com To: excel-macros@googlegroups.com Sent: Fri, August 10, 2012 2:43:23 PM Subject: $$Excel-Macros$$ FW: Excel Formula challenge [Solved] Hi Guys, I was expecting many replies from you. Well you can see the attached sheet. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: 09 August 2012 8:22 To: excel-macros@googlegroups.com Subject: FW: Excel Formula challenge Any Reply??? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: 08 August 2012 9:33 To: excel-macros@googlegroups.com Subject: Excel Formula challenge Hi group, Hope you will post an excellent solution here : Let suppose you have a string like below : A|A|A|B|B|C|A|B|C|D As you can see the characters are being repeat in this string output should be : A|B|C|D I don't think helper column is required J You can comment here also http://excelpoweruser.wordpress.com/2012/08/08/excel-formula-challenge/ Regards Rajan verma +91 7838100659 [IM-Gtalk] -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To
$$Excel-Macros$$ Fwd: Data Entry - Need insert rows when i press enter button
Brothers please help me Thanks N.Sundarvelan 9600160150 -- Forwarded message -- From: Sundarvelan N nsund...@gmail.com Date: Wed, Aug 8, 2012 at 2:32 PM Subject: Data Entry - Need insert rows when i press enter button To: excel-macros@googlegroups.com Hello Friends, I need to complete a projec. The requirement as follows 1. When i press ENTER button in the INPUT sheet the data should add in the DATA sheet 2. The cursor should automatically go to the next tex box when i hit enter button I would be thankfull if it is done as soon as possible. Thanks N.Sundarvelan 9600160150 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Sundarvelan_Project_Data_Entry.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Fwd: Data Entry - Need insert rows when i press enter button
This looks like school homework to me. If we do your homework for you, you learn nothing. Use the resource materials you have no doubt been given, read the book. Try to do it yourself - even if you can only do part of it. Than come back to the group to help you with any specific aspect that is causing you problems. On 11 August 2012 20:10, Sundarvelan N nsund...@gmail.com wrote: Brothers please help me Thanks N.Sundarvelan 9600160150 -- Forwarded message -- From: Sundarvelan N nsund...@gmail.com Date: Wed, Aug 8, 2012 at 2:32 PM Subject: Data Entry - Need insert rows when i press enter button To: excel-macros@googlegroups.com Hello Friends, I need to complete a projec. The requirement as follows 1. When i press ENTER button in the INPUT sheet the data should add in the DATA sheet 2. The cursor should automatically go to the next tex box when i hit enter button I would be thankfull if it is done as soon as possible. Thanks N.Sundarvelan 9600160150 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Regards David Grugeon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ BullsEye Chart
Thanks Raj Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Rajan_Verma rajanverma1...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 11 Aug 2012 16:49:30 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ BullsEye Chart Hi Group, Just sharing the bulls Eye chart. Bulls Eye chart can be used to see weather parameter is in its desired range or not . I have created this chart by using Radar and PIE , hope you can make use of it .. All Suggestion and comments are welcome ! J Regards Rajan verma +91 7838100659 [IM-Gtalk] -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ payback Period Formula / Macro
Hi Sharad Use the following function in a general module. Then use =Payback(range) See attached '= Function PayBack(ByRef rng As Range) As Variant 'check that the range has only one dimension If rng.Rows.Count 1 And rng.Columns.Count 1 Then PayBack = error Else Dim t As Double 'The total value Dim t1 As Double Dim t2 As Double Dim x As Long 'cell counter Dim p As Double 'the part of the following year ' find the period Do Until t 1 x = x + 1 t = t + rng.Cells(x).Value Loop PayBack = x - (t / rng.Cells(x).Value) End If End Function '= Regards David Grugeon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Example.xlsm Description: Binary data
Re: $$Excel-Macros$$ What is the future of VBA?
It's not easy to say, what with all the changes in that side of the world, but we have to agree that computation in a spreadsheet will remain as long as industries and scenarios need analysis and data interpretation. So I am assuming Excel will be one of the leading spreadsheet application. If VBA isn't there, something will be there that will be similar. And as software evolves, people evolve. So, I for one, don't tend to be apprehensive about changes, or rather, potential changes, such as those. Regards, Sam Mathai Chacko On Sun, Aug 12, 2012 at 2:01 AM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Dear All, What is the future of VBA? Or will it be killed suddenly like VB6? Do write back all your thoughts on given subject Regards Yogananda Muthaiah -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Sam Mathai Chacko -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.