Does anyone know how to set up a payroll spreadsheet that not only calculates
hours and wages, but also tips?
I need it it to do all of the taxes as well.
Pretty much the normal payroll spreadheet, but claiming earned tips as well.
I have need to show dates as follows: 1/1/05 = 1st Saturday of January...any
ideas out there?
I have a table (with 655K rows and growing) that has a 11 fields. The first four fields are Code, Group, Month ("MMMYYYY") and State. The remaining fields have counts and dollar amounts. I need to calculate a 12 month moving or 12 month trailing value for each combination of Code, Group, Month and State. How could I do this? (My first thought is a sub query.)
Hi team,
I have a spreadsheet that has columns of monthly values for three years of financial data and where the values for the latest month are added to the last column. Months that have not been completed will have a zero value (e.g. Jul-09).
Jan-09
Feb-09
Mar-09
Apr-09
May-09
Jun-09
Jul-09
Aug-09
Sep-09
1
2
3
4
5
6
0
0
0
I want to indicate a trend based on the last three months and I am using the formula below. The absolute references (e.g. $AP$1) are to cells containing these symbols ▼, ▲, ▬ to indicate that the latest month is trending up, down or staying the same compared to the average of the last three months.
=IF(AD11>(SUM(AB11:AD11)/3),$AP$1,IF(AD11
Hi,
A1, B1, C1 and D4 are cell in Excel worksheet and values are 2, 4 and 6 in A1, b1 and c1 respectively.
A1 B1 C1 D4
2 4 6 C1-Formula is: =sum(A1+B1)
Now I have to write formula for D4-cell:
i.e. =sum(C1/Total days remaining of the month)
Suppose Today is April 01, 2009, C1/should be devided by 30,
Tomorrow will be April 02, 2009, C1/should be devided by 29.
Please advise about formula for cell-D4. Thanks.
Help!,
I would like to return the end of the month date based on the selection of the short month name. ie, if they select Jan, then it returns in another cell 1-31-2010 or 1-31-2011 once the new year begins. i know its out there but the brain just will not work. help please
Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards
J-O
What is the easy way to create forms in different sheets.......
In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......
Hy guys,
I still work with excel 2007, so, can someone tell me please if the 2010 version shows the formula tips, when we are tipping a formula in the "name manager box", and in the "conditional formating box".(when you use a formula to do conditional formating), like they are shown when we tipe a formula in a spreadsheet cell??
I think that would be a great help
Hello. I recorded the code below to convert pages of workbook to pdf. It works well on my computer but on a co-worker's computer the pdf produced has header and footer pictures shifted slightly down and to the right, showing small areas of white area on his pdf and I do not see this on my pdf produced.
-Any idea what might cause this situation?
-If I have pictures in the header and footer and the pictures are inserted from my desktop,
does this cause Excel issues with those headers/footers on another computer? Is a better
way to load and link the pictures somewhere in the Excel document?
-Is Excel not the best tool to convert to pdf? Would it be better to use Publisher
or even Powerpoint linked to Excel sheets? How about one of the many Excel to
PDF softwares out there?
Thank you.
Sub convpdf()
Sheets(Array("sheet1", "sheet2", "sheet3", "sheet4", "sheet5")).Select
Sheets("sheet1").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Documents and Settings\myname\Desktop\pdf_file.pdf", Quality:= _
xlQualityHigh, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub
