Welcome to iPadForums.net Guest - Click Here to Register

Numbers: My Apple Service Log (Because I Could)

This is a discussion on Numbers: My Apple Service Log (Because I Could) within the iWork Forum forums, part of the iPad App Store category; I'm not sure why I did this, other than I had the idea, and then I couldn't get it out of my mind until I ...

iPadForums.net is the original Apple iPad Forum! Registered Users do not see these ads. Please Register - It's Free!
+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    iPF Legend
    Member #
    28530
    Liked
    1546 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,471

    Numbers: My Apple Service Log (Because I Could)

    I'm not sure why I did this, other than I had the idea, and then I couldn't get it out of my mind until I figured out how to make it work.

    This is a down time tracking spreadsheet that uses a daily log, a timeline, and gives a basic report of downtime hours and percentage of up time from the beginning to current date. It is based on Apple's System Status page, the Timeline part at the bottom. The rest is just me seeing what I could do with that basic table's information.

    The idea is pretty simple. You have a date/issue column, a popup menu column for the service type, and a long series of cells that represent blocks of time. You select and paste a previous downtime cell into the new ones, because it's easier than trying to enter them over an over. Each cell actually contains the value .5 (to represent half an hour). I made the text the same color as the background, because it's prettier that way.

    The second table is all computation. It checks the entries for each date, matches it with a service, and sums the hours. There is probably a neater, much more complicated formula, way to do this.

    And then, just for the heck of it, I made an uptime chart.

    Extending each table is a matter of adding rows and using the fill option. I think I got all the formulas working so that filling down will work without a hitch. I hope so. The service table can not be bigger than the timeline table, or the formulas will break for those rows.

    Anyway, I built the darn think so I feel like it would be a waste not to share it. Even if no one ever uses it, it might offer some ideas for building own timeline style tracking spreadsheet.

    My Apple Service Log.

    If you look it over. Let me know what you think.

    Ok, it's late, and my minds a bit fuzzy. I should probably wind down and go to bed. Right after I check all my news, blogs, and forums; again.

  2. Ads


  3. #2
    iPF Legend
    Member #
    28530
    Liked
    1546 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,471
    Is it wrong for me to want the Apple servers to go down, just so I can enter interesting data in my spreadsheet?
    Last edited by twerppoet; 02-03-2013 at 06:51 PM.


Home | Forum | Active Topics | What's New

Links

Posting Permissions

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

Similar Threads

  1. Apple Mobile Device service
    By ricmid8546 in forum Forum Rules, Help and Info
    Replies: 3
    Last Post: 12-03-2011, 03:34 AM
  2. apple service very disappointed
    By pkarem in forum iPad General Discussions
    Replies: 7
    Last Post: 07-25-2011, 08:24 AM
  3. Poor Apple Customer service
    By khoyle in forum iPad 2 Forum
    Replies: 16
    Last Post: 05-28-2011, 03:33 PM
  4. Apple Number one in customer service
    By IpadOne in forum iPad General Discussions
    Replies: 3
    Last Post: 02-24-2010, 03:37 AM

Search tags for this page

contact appleservices.com loc:us

,

info appleservices com loc:us

Click on a term to search for related topics.