Ok this is actually a school project but im having trouble with one of the questions...
So here is the picture
http://aycu11.webshots.com/image/272...6455633_fs.jpg
it basically asks me that if i save $200 a month and my rate of return is 8.5% then what wud i have at age 65? Im 20 now.....so the age diffference left till i reach 65 is 45
Basically I want to know..is it asking that you do 2400*1.085% which is 2604...then you carry over 2604 to the next year and add 2400 more to it and then add 8.5% again to that....and so on...so even though its an annual interest rate it compounds because its more than one year?
or wud i just do 2400 * 1.085% which is 2604 and then multiply times 45 (years left till 65)
Greetings:
I'm attempting to set up a forecasted savings plan in Excel (fyi Tax Sheltered Annuity). Parameters would include current age, salary, salary growth, contribution rate, rate of return and retiring age. I've got down the basics, but I can't seem to formulate each column correctly. Also, I wouuld need to calculate a "what if" analysis. Does anyone have advice? Please help!
-Desperate
Doea anyone have VBA code that determines the start and stop of daylight savings time in the US? I've searched and only found a page with multiple modules, but I can't eletronically transfer the code to the machine in question (it's sequestered) so I will have to retype it. Thus, I'm in need of the simplest method possible.
My ultimate goal is if I have a start date and a stop date is to determine if (and when) a time change occurs in that range.
Thanks!
I want to be able to see at a glance the number of people I have in at a specific time on a certain duty. I give the example of how it should appear
******** ******************** ************************************************************************>
Microsoft Excel - Book1
___Running: 11.0 : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
A4
=
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
4
Duty 1
Time
to
Duty 2
Time
to
Time
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
5
Employee 1
Alpha
07:00
13:00
Confs
13:00
18:00
6
Employee 2
Alpha
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
7
Employee 3
Client Adv
8
Employee 4
Confs
1
1
1
1
9
Employee 5
Phone
10
Employee 6
Phone Urg
11
Employee 7
Problem
12
Employee 8
Quotes
13
Employee 9
Alpha
13:00
18:00
Rep Fee
14
Employee 10
Urgent
15
Employee 11
16
Employee 12
17
Employee 13
18
Employee 14
Alpha
10:00
21:00
Sheet2
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
The user would enter the duty and the time the employee would be doing the duty, I simply need the number of people who are doing the duty to appear in the table from column J onwards, any ideas, my problem are between counting the number of times the duty happens and working out the from and to times ?
I have a worksheet that lists the times for numerous events in PT (not specified if DST or standard time). I have had a request to insert another column with GMT equivalents for each event. I can run the code where I specify the offset from PT but haven't figured out how to set it up automatically to check whether we are in standard or daylight savings time to correct the offset. I have created a table with the start and end dates for 2011 to 2015 but am not sure how to have it check the specified date to see if it falls in or out of that range or if there is a better way...it is not usually the system date but instead a date chosen by the user from a calendar control (called "DSSEDate" declared as date elsewhere in the code).
Any thoughts?
Thanks,
Judy
I've spent all day writing code to copy a worksheet and manipulate data. I have just finish writing the code to get data from other sources. Now when I run the macros all together, the part of the code that copies the existing sheet fails. and I get the error code '1004'
Here is the code I'm using:
Code:
'create copy of PPG Daten and Populate with new test data
Sheets("PPG Daten").Copy After:=Sheets(9)
'Process each step individually for 54 steps only
NewPPGDatenStep1
NewPPGDatenStufennr1
NewPPGDatenStep2
NewPPGDatenStufennr2
NewPPGDatenStep3
NewPPGDatenStufennr3
NewPPGDatenStep4
NewPPGDatenStufennr4
NewPPGDatenStep5
NewPPGDatenStufennr5
NewPPGDatenStep6
NewPPGDatenStufennr6
NewPPGDatenStep7
NewPPGDatenStufennr7
NewPPGDatenStep8
NewPPGDatenStufennr8
NewPPGDatenStep9
NewPPGDatenStufennr9
NewPPGDatenStep10
NewPPGDatenStufennr10
NewPPGDatenStep11
NewPPGDatenStufennr11
NewPPGDatenStep12
NewPPGDatenStufennr12
NewPPGDatenStep13
NewPPGDatenStufennr13
NewPPGDatenStep14
NewPPGDatenStufennr14
NewPPGDatenStep15
NewPPGDatenStufennr15
NewPPGDatenStep16
NewPPGDatenStufennr16
NewPPGDatenStep17
NewPPGDatenStufennr17
NewPPGDatenStep18
NewPPGDatenStufennr18
NewPPGDatenStep19
NewPPGDatenStufennr19
NewPPGDatenStep20
NewPPGDatenStufennr20
NewPPGDatenStep21
NewPPGDatenStufennr21
NewPPGDatenStep22
NewPPGDatenStufennr22
NewPPGDatenStep23
NewPPGDatenStufennr23
NewPPGDatenStep24
NewPPGDatenStufennr24
NewPPGDatenStep25
NewPPGDatenStufennr25
NewPPGDatenStep26
NewPPGDatenStufennr26
NewPPGDatenStep27
NewPPGDatenStufennr27
NewPPGDatenStep28
NewPPGDatenStufennr28
NewPPGDatenStep29
NewPPGDatenStufennr29
NewPPGDatenStep30
NewPPGDatenStufennr30
NewPPGDatenStep31
NewPPGDatenStufennr31
NewPPGDatenStep32
NewPPGDatenStufennr32
NewPPGDatenStep33
NewPPGDatenStufennr33
NewPPGDatenStep34
NewPPGDatenStufennr34
NewPPGDatenStep35
NewPPGDatenStufennr35
NewPPGDatenStep36
NewPPGDatenStufennr36
NewPPGDatenStep37
NewPPGDatenStufennr37
NewPPGDatenStep38
NewPPGDatenStufennr38
NewPPGDatenStep39
NewPPGDatenStufennr39
NewPPGDatenStep40
NewPPGDatenStufennr40
NewPPGDatenStep41
NewPPGDatenStufennr41
NewPPGDatenStep42
NewPPGDatenStufennr42
NewPPGDatenStep43
NewPPGDatenStufennr43
NewPPGDatenStep44
NewPPGDatenStufennr44
NewPPGDatenStep45
NewPPGDatenStufennr45
NewPPGDatenStep46
NewPPGDatenStufennr46
NewPPGDatenStep47
NewPPGDatenStufennr47
NewPPGDatenStep48
NewPPGDatenStufennr48
NewPPGDatenStep49
NewPPGDatenStufennr49
NewPPGDatenStep50
NewPPGDatenStufennr50
NewPPGDatenStep51
NewPPGDatenStufennr51
NewPPGDatenStep52
NewPPGDatenStufennr52
NewPPGDatenStep53
NewPPGDatenStufennr53
NewPPGDatenStep54
NewPPGDatenStufennr54
NewPPGDatenOtherColumns
The individual macros (NewPPGDaten...) work fine on their own, its the first line: Sheets("PPG Daten").Copy After:=Sheets(9) thats giving me difficulty.
Any ideas?
I really do hope I'm posting this in the correct forum.
My boss has requested that I set up a program to track our company's employee savings program. We're a small company and have probably only about 20-30 people in the savings program. My boss thinks I know more about Excel than I do, although I am willing to learn.
Our company is currently using a program to track the employee savings but the program is quite old and no longer supported.
I've been asked to set up an Excel file to show quite simply the employee's name, the date and amount of contribution, running balance, and also calculate simple daily interest which is compounded monthly. He also wants to be able to print off "statements" each month for each employee in the plan.
I'm not sure Excel is the correct program to use. I can't even begin to think of how the data could be entered easily.
What I'm looking for is any advice/suggestions about whether you think Excel can be used for this and also any other programs or sites out there where I can possibly find more information and/or help in getting this set up and going. Or any existing programs which can perform this function?
Thanks in advance for any help you can provide.
~martih
Hi all,
First post here...I hope I've come to the right place...
I have an Excel sheet with an Add-in that worked fine in 2003 until someone opened it up with Excel 2007. Now, I get an error in both 2007 and 2003.
- Run-time error 1004, Unable to get Object Property of OLEObject class
The error occurs as I'm looping through the objects on a sheet that becomes the active sheet, and assigning a combo box to an object. Here's the code
In a class module : CExcelEvents
Code:
Public Sub WBk1_SheetActivate(ByVal Sh As Object)
Set WKs = Sh
Call EnableCombo
... other code
End Sub
Code:
Public Sub EnableCombo()
Dim obj As Object
Set gclsSheet = New CSheetEvents
For Each obj In WKs.OLEObjects
Select Case obj.Name
Case "cboSort1"
---> Error happens twice, when setting object
Set gclsSheet.SortCombo1 = WKs.OLEObjects("cboSort1").Object
Case "cboSort2"
Set gclsSheet.SortCombo2 = WKs.OLEObjects("cboSort2").Object
End Select
Next obj
' get last open row value on sheet with activation, assign to global lastrow value
lastShtRow = LastRowVal(WKs)
End Sub
In a class module : CSheetEvents
Code:
Public WithEvents CboSort1 As ComboBox
Public WithEvents CboSort2 As ComboBox
Public Property Get SortCombo1() As ComboBox
Set SortCombo1 = CboSort1
End Property
Public Property Set SortCombo1(objProductCombo1 As ComboBox)
Set CboSort1 = objProductCombo1
End Property
Public Property Get SortCombo2() As ComboBox
Set SortCombo2 = CboSort2
End Property
Public Property Set SortCombo2(objProductCombo2 As ComboBox)
Set CboSort2 = objProductCombo2
End Property
Anyone able to help with this?
I'm interested in programming Conway's Life using Excel. I'm wondering how to display the life cells. 1 Life cell per worksheet cell seems like "not the best". If I could do graphics at the bit-map level, I could use that.
Does anyone have tips on how to diplay Life using Excel?
I've been wanting to learn excel for quite some time now. Not just basic usage but up to the expertise level. I'm out of school for the summer and this is one of my goals. Here are a couple questions
1. How has knowing excel helped you in life? (career, daily life etc)
2. What are some resources that you would recommend for someone that knows the basics?
Thanks!
