Thu Feb 05, 2004 12:15 am
My experience has been that pasting PICT content into AC or PM can get messed up depending on the user. If the user does not consistantly set the scale of the work area before pasting then the infomation is often out of scale.
The Camera method in Excel will give you a PICT version of the Excel table. This information then pasted into AC can then be scaled incorrectly based on the percentage the person is then set to when viewing the work area.
Also a user might be frustated in Excel when trying to make a table/schedule which is a certain size. This is important when you are working with office standards and determined grids on your layout sheets. The schedules need to fit the grid. In Excel, there is no way to size the columns base on inches.
Here I draw a bounding box. This box can be set in size to inches. I can be moved and snapped to the cells of the schedule and prevented from resizing when the columns are moved and changed.
Now I have control over the informatin coming from Excel.
Lately, I have been just copying a selection of cells and pasting them into a Plotmaker Drawing. Then saving this file as a PMK. This PMK is then linked to a layout. All the schedule's information can be edited if need be. The schedule can be moved around the layout without losing any of its parts. It can be added to any number of projects. So for offices where a schedule of abbreviations is used. This schedule can be done once and then used again and again.
The Camera process may still be necessary for some people. I find that getting to this tool in Excel is very difficult for some people. And the process much more involved than the method I have tried to describe.
If someone wants, I can post pictures of my process.
Terrence Sturm, Architect -- Seeking Freelance work
Mac OSX 10.6.9 Intel Core 2 Duo 2.53hz
AC 10 build 1188
AC 11 build 1210
AC 14 build 4044
AC 15 build 3267
AC 17 build 5019