[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Month Of May Accounting



Carolynn, not a problem!  Actually, I'm doing both, placing your info in my own Excel spreadsheet and using a calculator on your sheet.  I do believe there is a problem in your formula.  I'm not good with multiple sheets in Excell and defining a formula adding cells from different sheets.  I can do an all on one sheet formula adding, subtracing, or multiplying columns, but not on multiple sheets (I just haven't tried).  Thanks for letting me move the 31 May time to the June paycheck!  I'll watch for final days in a month being in the next month's time card from now on.  Thanks!  
Have a great rest of the week! 
Sincerely, 
Marcy 
Marcelyn Atwood
Business Manager 

The Law Firm of Puckett & Faraj, PC
1800 Diagonal Road, Suite 210
Alexandria, VA 22314 

888-970-0005 ; 703-706-9566 ; FAX 202-318-7652 ; marcy@puckettfaraj.com
Please View our Website:  www.puckettfaraj.com
The information contained in this electronic message is confidential, and is intended for the use of the individual or entity named above. If you are not the intended recipient of this message, you are hereby notified that any use, distribution, copying of disclosure of this communication is strictly prohibited. If you received this communication in error, please notify Puckett & Faraj, P.C. at 888-970-0005 or via a return the e-mail to sender.  You are required to purge this E-mail immediately without reading or making any copy or distribution.

On Jun 9, 2010, at 12:29 PM, Carolynn Beck wrote:

Yikes, sorry for the miscalculations and thanks for taking your time to correct those. That is so weird. I guess math isn't my strong suit.. Ha ha.. Can I blame my blurry vision this time around? :-) But my bad math and vision aside, I'm wondering if some of the formulas in certain portions of my spreadsheets are incorrect. I was just adding up the totals at the end of each day's spreadsheet to double check so maybe the errors are in the formulas calculating the sums. (?) (or it could have just been something I was simply overlooking). Are you just copy-pasting the times that I inputted and using your own formula to calculate my times to the tenth of an hour?

Either way, thank you for catching my bad math. I hope I'm not causing extra work for you... Please let me know if there's anything I can change my spreadsheet formulas to make things easier for you... and it's fine with me if you just add the May 31-June 5 to June's paycheck. :-)

Thank you,

Carolynn Beck
(202) 316-1367



On Jun 9, 2010, at 12:11 PM, Marcy wrote:

Hi Carolynn, Sorry for the delay in responding to you.  Marcy

Here's what I have from your Time Sheets (week days + weekend work if applicable):

May 3 - 7:  Time = 0
May 10-14: Time = .3 (GoodFellas)
May 17-21:  Time = 3.4 + 4.2+7.4+0.2= 15.2 (GoodFellas)
May 23:  Time = 0.8 (Overhead)
May 24-28:  Time = 1.8+0.1=1.9 (GoodFellas)

Total:  18.2 x 25 = $455.00 (GoodFellas)
Travel 10 mi x $0.50 = $5.00 (Overhead)
Toner Expense = $56.69

Total Ck # 1128 = $516.69

Your calculations for the week of 17th May still don't match what is on the spread sheet.  I show 15.2 Hrs for clients plus the .8 for overhead to equal a total of 16 hours instead of the 15.8 you show.

The May 31st (Memorial Day) time was not received until 6/7/10.  It did not occur to me that work would have happened on a Federal Holiday, so I didn't wait for the time card for the 31st of May work to show up prior to closing out my May books.

June Work by Week:
May 31:  Time = 5.1 (GoodFellas)
Jun 1-4:  Time = (0.7 GoodFellas) + (.5 + 3.3 + 2.0 + .3 = 6.1 Hamama)

We will include the 31st of May work in the June Consultant Check if that's OK with you.

Sincerely,
Marcy
Marcelyn Atwood
Business Manager

The Law Firm of Puckett & Faraj, PC
1800 Diagonal Road, Suite 210
Alexandria, VA 22314

888-970-0005 ; 703-706-9566 ; FAX 202-318-7652 ; marcy@puckettfaraj.com
Please View our Website:  www.puckettfaraj.com
The information contained in this electronic message is confidential, and is intended for the use of the individual or entity named above. If you are not the intended recipient of this message, you are hereby notified that any use, distribution, copying of disclosure of this communication is strictly prohibited. If you received this communication in error, please notify Puckett & Faraj, P.C. at 888-970-0005 or via a return the e-mail to sender.  You are required to purge this E-mail immediately without reading or making any copy or distribution.