1. Welcome to PlowSite. Notice a fresh look and new features? It’s now easier to share photos and videos, find popular topics fast, and enjoy expanded user profiles. If you have any questions, click HELP at the top or bottom of any page, or send an email to help@plowsite.com. We welcome your feedback.

    Dismiss Notice

Anyone care to share a NICE log sheet 4 Snow ?

Discussion in 'Business Fundamentals' started by Grass_n_Trees, Jan 13, 2009.

  1. Grass_n_Trees

    Grass_n_Trees Junior Member
    Messages: 23

    If you have a good one and could share it ? mine stinks and I'm banging my head trying to make it easy to use, read and keep track of stuff.

    HELP! and many thanks

    -Dean
     
  2. Woodland

    Woodland Senior Member
    Messages: 269

    Here is what I use. Pretty simple really. Info about the storm goes at the top, along the side under the "Property" heading I have a list of all the accounts I plow. Across the top where it reads "Date/Start/End" I can account for multiple passes during a storm. In the blanks for each column there is ample space to make notes if necessary, but generally I just put an x when I plow. Total the pushes at the end. This info then gets moved via summary to another form I use for billing at the end of the month.

    Plow Sheet.jpg
     
  3. AboveTheCut

    AboveTheCut Junior Member
    Messages: 25

    im looking for one too

    preferably in excel that has formulas in place where all you had to do is enter your rate and times and it would do the math for you. one sheet for each site, multiple columns for dates in case storm went multiple days. the operator would fill out his sheet on the pc and email it to the office. columns may be for labor and material (50lb bags), other col like plow, spread, snow blower, manual spread, shovel. maybe a place for notes/comments, etc. anyone using anything like this??
    thanks
    ATC
     
  4. 4u2nv

    4u2nv Member
    Messages: 78

    Is that all you want? How about someone to do the plowing, shoveling, salting and such for you? Then they can send the bill to... will that work for you?
     
  5. AboveTheCut

    AboveTheCut Junior Member
    Messages: 25

    thanks for your sarcasm

    and being so unprofessional. i have a log sheet, there are things i think could be better about it. i am currently working on a new one and would be happy to share it with someone asking for it. your comments are not helpful at all and you should keep them to yourself.
     
  6. got-h2o

    got-h2o 2000 Club Member
    Messages: 2,439

    Yeah aint it? Doesn't this site exist to help eachother out? I'd be happy to share mine if I had a good one. I'm sure someone will chime in and actually help you out.
     
  7. MattR

    MattR Senior Member
    Messages: 218

    oh my... lets see if I got this right. You have a log sheet, do not like it. So instead of just making a new one, you ask somebody to do the work for you with specific sections in it for FREE? If you want it done right, do it yourself. You might learn something in the process. Google search has TONS of links to teach you how to write your own excel files. That way you can have exactly what you want and the pride in doing it yourself.

    One other option that you can do is ask your workers if they have a scanner and a printer. Make yourself a nice log sheet with everything you need on it. Send it to your workers. They can print off copies when needed and fill them out while out working. Then when the day is done, they can scan the log sheet, and email them to you. Very simple and professional as well.

    Matt
     
  8. AboveTheCut

    AboveTheCut Junior Member
    Messages: 25

    sorry i asked

    its a shame that you cant ask a simple question without people berating you over it. oh well......
     
    SeasonalMatt17 likes this.
  9. MattR

    MattR Senior Member
    Messages: 218

    You are right, it would be a shame if it was a simple question/request. Just so you know, you asked for a very detailed excel file. I am guessing you have no knowledge on creating an excel template. That is why I was nice enough to let you know that there is plenty of online tutorials regarding writing/creating your own excel files. I even mentioned an alternative way to aquire log sheets from your workers. So in one way, yeah it is a shame that I wasted some time trying to give advice regarding such a detailed request for something you wanted for free.

    Like I said before, if you want it done right, do it yourself. That way you can have every single column and section that you need. Yes, you might learn something. Especially how to change some things in the excel file to suit any changes in your business services/costs. You would even know how to write/create any future files that you may need in the future as well instead of asking somebody for their files that they have probably worked hard at creating.

    If you think I am "berating" you still, I think you need to step away from the pc a bit and once you have a clear and open mind, reread what I wrote. I have been trying to help you with what you need.


    Matt
     
  10. Shop's Lawn

    Shop's Lawn Senior Member
    Messages: 147

    This post is pretty lame. A guy is just looking for a simple- yes simple question and answer! All he is looking for are to see what you use. I'm sure he will put them together and take what works for him the best. So many have a bad day?
     
    SeasonalMatt17 likes this.
  11. maelawncare

    maelawncare Senior Member
    Messages: 871

    heres what i use. tons of room to add things.
     

    Attached Files:

  12. MattR

    MattR Senior Member
    Messages: 218

    Giving advice on how to learn to do it yourself is lame?
    If it was such a simple request, then why not share yours with them?

    He was not asking for a few to take bits and pieces from to make one file to suit his needs, he wanted something so he did not have to make the extra columns and sections that he wants. Chances are is that he will have to learn how to adjust/edit the files to add those extra things he requires. That is why I mentioned the idea of trying to learn how to do it himself. YES, how lame of me to even suggest trying to learn something.

    Anyways, that is all I have to say. Have a great day.

    Matt
     
  13. the new boss 92

    the new boss 92 2000 Club Member
    Messages: 2,989

    i just write it down in my notebook as i go and just keep and the times start to finish unless i do a flat rate then just write down how ever much it is!
     
  14. Woodland

    Woodland Senior Member
    Messages: 269

    I think everyone has overlooked the fact that the poster who asked for the sophisticated excel spreadsheet that would do everything for him was not the original poster. The OP simply wanted to see some examples of what people use. So, original poster: good question, good way to learn and better yourself... second poster: try doing a little homework first, you might learn something.
     
  15. MattR

    MattR Senior Member
    Messages: 218

    Hi Woodland.

    I noticed it was not the original poster from the start. BTW, nice looking log sheet.

    Matt
     
  16. HULK2184

    HULK2184 Member
    Messages: 77

    Here is a little thing i made up quick one night :redbounce

    its kinda messed up since i moved it from excel to pdf
     

    Attached Files:

  17. AboveTheCut

    AboveTheCut Junior Member
    Messages: 25

    Here is the sheet i use

    its in Excell and has all the formulas in it (some are hidden). basically, i use one sheet for each site. i write my times (in and out) in a notebook during the storm and fill these sheets out on the pc when i get home and fax them in for billing. there are multiple columns to take care of the times you return to the same site more than once during the storm. all the sub needs to do with this sheet/template is enter times and rates and everything else is done automatically, nice and neat. im sure there is room for improvement so im open to suggestions. hope this helps. i would be happy to send my excell file to you if you want.

    General_Snow_Removal_Log_Sheet2.jpg
     
  18. MattR

    MattR Senior Member
    Messages: 218

    Hi AboveTheCut,

    The layout of it looks fine. The only thing I noticed right away though was your "Summary" section. It only shows 3 things, yet above it is more specific as to what service they are getting. The other thing is the Signature part, not sure how it can be signed by you unless it is printed out first or have one of those electronic pen things. If you do not have a way to sign it, maybe reword it to something else. I have no ideas yet on what word to use in place of "signature" but will let you know if I get an idea. Perhaps "Employee Name" or something like that. Maybe somebody else might have an idea too. Also if multiple dates on the log sheet, possibly change the "Date" part by the signature to "Dated", "Signed On", or something that does not sound like it is only for one day in the event of a multiple day storm.

    Other than what I mentioned, it looks great.

    Matt
     
  19. AboveTheCut

    AboveTheCut Junior Member
    Messages: 25

    more clarification

    maybe i should have explained better how i use it. i keep all my in and out times during the storm hand written in a spiral notebook. when i get home i fill these sheets out in excell (my times) and print them out. i sign and date them and then fax them in. this is how we report our hours to get paid. no sheet, no pay. i realized the summary part you were talking about when making it. the way it is set up right now (since i get the same rate for everything) is the summary of the manual work (man spread, man shovel, snow blower) is all added up and displayed in one spot under manual. i will try to edit this to make it more friendly and repost.
     
  20. Playboy

    Playboy Senior Member
    Messages: 335

    Here's one I through together that has been working for us. In the (extra) column, we put if it needs to be shoveled or if it's gravel. In the billing sheet we put all the prices so we can have everything at a glance while making the invoices in QB.
     

    Attached Files:

    Last edited: Jan 31, 2009