Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Erasing Outlook Calendar from within Excel | Excel Discussion (Misc queries) | |||
How do i set up a calendar in excel? | Excel Discussion (Misc queries) | |||
Calendar and info for that date | Excel Discussion (Misc queries) | |||
Weekly data into Calendar Weeks | Excel Worksheet Functions |