custom 8 1/2 x 11 schedule

[cliff collins]

We are trying to create a Scehdule for Materials that will fit nicely on 8 1/2 x 11 sheets-
actually only a portion of the sheet.

As we add all the required fields the schedule grows horizontally, but the schedule can only be "split" horizontally.

We know we can make duplicate schedules, hide columns and add more than one schdule to the sheet--but this is very inefficient, and prone to errors.

We'd like to have one schedule, and make it fit within the margins of the 8 1/2 x 11 sheets
comfortably.

Is there any way to break/split the schedules VERTICALLY? Anything in the API
that allows schedule customization?

Cheers...................

[twiceroadsfool]

I just make a copy and use a filter at a certain value. As long as schedule 1 filters less than or equal to, and filter 2 filters greater than, nothing gets lost.

I do it with drawing lists for tracking revisions... That way i dont have to keep reissuing the full sized sheet with the drawing list on it.

[DaveP]

Cliff, if I'm reading you correctly, you want a schedule split like this:
!!!!! !!!!!
!!!!! !!!!!
!!!!! !!!!!
!!!!! !!!!!
not like this:
!!!!!!!!!!
!!!!!!!!!!
!!!!!!!!!!


!!!!!!!!!!
!!!!!!!!!!

I believe the only way you can do that is with multiple schedules.
Make a master schedule with columns 1,2,3,4,5,6,7,8,9, duplicate it, and make one with
1,2,3,4,5 and another with 1,6,7,8,9. Do all your editing in the master, and place the two "split" schedules on the sheet
Not sure why you're worrying about being "inefficient and error-prone", though. You don't need to edit all of the schedules. Just work in the Master. Since all the data is in the model, it WILL be correct on the two splits. Nothing error-prone there. and your only inefficiency is setting them up in the first place.

[twiceroadsfool]

Oh, whoops. I misunderstood. But yeah, i handle that the same way Dave does too. A master for editing, and the split and hidden ones on the sheet.

Its just like dependant views...

[cliff collins]

Thanks for the replies, will give the Master Schedule a shot.

cheers..............

[cliff collins]

Hmmmm....

Tried the Master Schedule with duplicate copies...
Duplicate as dependent is greyed out, can't seem to make it work.

????????

cheers....

[twiceroadsfool]

You dont have to duplicate as dependant. Just duplicate. Schedules are all tracking live data, theyre going to show identical data anyway.

Duplicate, hide the columns on the left half.
Duplicate, hide the columns on the right half.

Place dupes on the sheets.

Edit the original.

[cliff collins]

We are using these schedules for individual pages of an 8.5 x 11 interior
finish/FFE control book, which may be 50-100 pages long.

Do not want to make 300 schedules! ( 3 per page )

It would be much better to be able to split the schedule vertically......

LOL

I'll check the Wishlist--and if it's not there I'll submit it.

cheers..........

[aggockel50321]

May not be what you want to do, but you could always export the schedule out as a delimited file, and then bring it into Excel or some other spreadsheet program, and do your formatting there...

[cliff collins]

Appreciate that, but---

That is not what we want to do--we are actually trying to re-create a document
developed in Excel!

We need to be able to split schedules vertically.

cheers..........

[DaveP]

I'm still not sure what Splitting a schedule Vertically is going to get you.
You still can't place one Schedule on multiple sheets, so you're either going to have to have multiple Schedules, or fake multiple Title Blocks on one Sheet & play games when printing.

All this said, I can see where having a really wide schedule would be handy to be able to split it vertically. I'll bet you, though, as soon as you split it, you're going to want to see Column 1 in all of the split views & that, the only way you'll be able to do is with multiple Schedules.

[twiceroadsfool]

Im with Dave. Splitting them wont do anything.

Youre basically saying you want a schedule that uses different filters, but keeps everything else the same, on different sheets.

I guess if we coupld split and use different sheets it makes sense, but if your workflow is sound the 300 schedules takes very little time to set up, and if the formatting is done in the master BEFORE you split them, its a non issue.

Yeah, it might suck if you have an add a column in the 11th hour, but even then id just remake the 300 schedules. I think it took longer typing my responses here than it would to actually do it, lol.

[cliff collins]

The issue is:

We need to be able to split the schedule vertically so it fits on an 8.5 x 11 sheet.

When you add fields, the schedule grows horizontally.

You can only split it horizontally. This causes you to have to make duplicates, and hide columns. A lot of extra unneeded steps. If I can split a SINGLE schedule VERTICALLY, then I can make it fit comfortably on the letter sized sheet? Get it?

Anyway, it can't be done so this thread is over. LOL.

cheers..............