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.

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.

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.