Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Seattle, WA - USA
    Posts
    21
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Internet usage chart

    Hello,
    I have COMCAST as my ISP.
    Trying to set up a spreadsheet of my daily used amount of GB's (Max 250GB/month).
    Any help is appreciated to get the data on the right side updated automatically when I enter the daily usage.

    Thanks,
    Albert
    Attached Files Attached Files

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Does your month always go from the second of the month to the second? (and if so, can you rearrange your dates?) Are you only wanting to monitor the latest month, or historical data too?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    New Lounger
    Join Date
    Dec 2009
    Location
    Seattle, WA - USA
    Posts
    21
    Thanks
    17
    Thanked 0 Times in 0 Posts
    Hello Rory,
    Thanks for the reply. Month starts at the first.
    I would like historical data as well.

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    So how come the first of the month has a higher number than the second?
    Also, how exactly do you want it displayed - just the amount used per day?
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    New Lounger
    Join Date
    Dec 2009
    Location
    Seattle, WA - USA
    Posts
    21
    Thanks
    17
    Thanked 0 Times in 0 Posts
    That higher number is the previous month total.
    What I like to have displayed in the available/day (K5) field: An automatically generated amount after I enter the daily usage. (Column D).
    I now decrease the remaining days of the month in (K5) manually.

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Your data still doesn't seem to me to tie up with your stated aims, so this is the closest I can come up with. I've broken the steps down into individual cells so that you can hopefully adjust it as necessary.
    Attached Files Attached Files
    Regards,
    Rory

    Microsoft MVP - Excel

  7. The Following User Says Thank You to rory For This Useful Post:

    abaas (2011-11-09)

  8. #7
    New Lounger
    Join Date
    Dec 2009
    Location
    Seattle, WA - USA
    Posts
    21
    Thanks
    17
    Thanked 0 Times in 0 Posts
    Thank You Rory.
    This is what I had in mind.

  9. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Great!
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •