excel instructions

step 1 copy the data into columns so you have at least 3 columns of the same data

step 2 delete and shift data up one cell up for every column over from the original, i.e. one cell up for the first column over, two cells up for the second column, etc.

step 3, select the whole sheet and sort by the first column

step 4 delete every row of data that does not start with the writ number.

step 5 insert several (like 6) blank columns.

step 6 we need to insert a good delimiter, like } using find and replace. Study the data for patterns where you think you can fairly reliably insert the delimiter.
If you have a hard time replacing certain items, like spaces, with the delimiter, try highlighting the item you want to replace and copying and pasting into the 'find' box in the find and replace dialog box.
Once you have inserted the delimiter, select the column and go to Tools>Text to columns and follow the wizard to break the column apart based on the delimiter you have inserted.
Repeat the insertion of delimiters and using text to column function until you have your data segmented the way you wish.

Finding Assignment Instructions

Is there any resource where we can get all of the assignmnet sheets? I am a bit behind on the database stuff in particular and would like to get the most step-by-step info available. It seems like there must be some stuff missing from the assignment lists. Thanks

Access: Entering STFIDs for the Bainbridge Survey

If our block on Bainbridge has multiple STFIDs, how can we look up which area has which STFID?

Additional Office Hours

Hi all you 543ers,
I will be having additional office hours this Monday (10/9) from 12:30-2 in Meyerson on the third floor. Please let me know if any of your are interested in coming.

-Meghan

First CAD assignment

I don't know what I am doing wrong but everytime i try to create a line by offsetting, my line ends up much farther away than it should be. I enter the offset distance as 17.5 feet, but the line created shows up halfway in the block. I am not sure whether the problem is with the way my external reference is scaled or whether it is due to the way i created my units. Has anyone else had this problem?