+ Reply to Thread
Results 1 to 3 of 3

horizontal calendar

  1. #1
    AH Joe
    Guest

    horizontal calendar

    Why can I have 10k rows but not enough columns to make a full horizontal
    calendar? I realize that I can split the sheet, so instead of 8 pages, I have
    16. But I am not the only one lookng at the sheet plus it requires double
    input of information across pages. My specific application is related to
    rental inventory tracking of equipment that is shared between four companies
    that spread across Texas.


  2. #2
    Dave O
    Guest

    Re: horizontal calendar

    Time to get creative! I suggest you rebuild the whole tracking system
    and impress your boss. Whose idea was it to have an entire year across
    the top of a spreadsheet? Why start with January on the extreme left
    of the spreadsheet, when you have to scroll WAY to the right to find
    December, and probably no longer care about January anyway?

    As an idea, and I admit a lot of this depends on the type of rental
    equipment you have, why not devote a tab of the spreadsheet to each
    piece of gear? That way you can develop and assign usage codes, and
    vertically (and almost limitlessly, since you'd have 65,000 entries per
    machine within the spreadsheet) track each welder / crane / lift
    truck's time out in the field, transit time from location to location
    (I've been to TX, and I know it's a wiiiide place!), days scheduled to
    be out of service for routine maintenance and thereby not available to
    customers, days out of service due to repair, the per day or per hour
    price quoted to the customer, or hours in service, or what have you.
    Then later on, you can tell Boss Man, hey, this company rented this
    machine for X days last year, why don't we leave it at the El Paso
    warehouse so it's easier for them to retrieve, or hey, this machine
    spent so much in repairs last year we should consider replacing it, or
    this machine spent so many days idle we should sell it and cut our
    losses.

    My point is, make the software work for YOU, instead of trying to beat
    your head against the software.


  3. #3
    AH Joe
    Guest

    Re: horizontal calendar

    My creativity allowed me to accomplish what MS is unable to fix. Running a
    sheet vertical does not allow visualization or readability. The northern
    european brain has been trained to function from left to right. If I was
    asian your point would be a reasonable compromise.

    Is my search for a horizontal calendar such a great challenge? This is the
    21st century and we land spacecraft on Mars. Quit making excuses for MS
    laziness in producing a viable platform and their inability to create a new
    one. Get of your haunches and earn your keep. You may find that I am not the
    only one that is willing to buy an upgrade that actually improves product
    performance.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1