**U.S. DEPARTMENT OF THE INTERIOR**

**BUREAU OF LAND MANAGEMENT**

**Oregon State Office**

![](media/image1.png){width="6.5in" height="5.701388888888889in"}

**CRAM**

**C**ADASTRAL **R**ETURNS **A**ND **M**ACROS

**\_\_\_\_\_\_\_\_\_\_\_\_\_**

**Version 7.0**

**\_\_\_\_\_\_\_\_\_\_\_\_\_**

**DISCLAIMER**

**CRAM is not warranted or that the operation will be uninterrupted or
error free. In fact if it works, I will be amazed.**

**Version 7.0 April 2007**

**CRAM**

**CADASTRAL RETURNS AND MACROS**

[C]{.underline}adastral [R]{.underline}eturns [A]{.underline}nd
[M]{.underline}acros (CRAM) is an effort to assist the Cadastral
Surveyor in word processing within Microsoft Word (MW) software. CRAM is
a collection of macros and documents that serves as a base on which to
build your own personalized set of macros and documents to assist in the
compilation of field notes, weekly reports and etc. Cram 7.0 is for the
typing of corner only style of field notes.

These documents and macros are designed for utilization by the Bureau of
Land Management's Oregon State Office surveyors, however, effort was
made to allow other users to modify the data to meet their needs.

Please read this document through before you utilize the macros.

For assistance call Aaron Graham 541-751-4248.

**Changes from Cram 6.0**

1\. Change directory structure to run from the C:\\tmp directory due to
BLM IRM security issues.

2\. Fix check box issue on survey request form.

3\. Added check box to Returns Status Sheet to indicate a BIA survey.

4\. The only real noticeable change between versions 6.0 and 7.0 is to
"The survey" statement on page one. More options have been added to this
macro in an attempt to standardize the first page of the field notes,
thus requiring less time to review.

4\. Added Plat marginal data templates for both plat and notes format
and plat only format.

5\. Added the document "Review Check List" to the Cadastral Docs menu.
This is to be used as a record of what items have been checked during
survey review to eliminate any possible duplication of effort.

**[CONTENTS]{.underline}**

Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

Getting Started . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5

Cadastral Documents . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . 6

Cadastral Field Notes . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7

Alternate Key Board . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . 9

General Information . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . 10

Macro List . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11

**Installation**

Unzip the file CRAM7.zip to the following directory: **C:\\tmp\\cram7**.

The result will be 4 files and one subdirectory in the CRAM7 directory:

CRAM7.dot -- this is the macro template

CRAM7.zip -- The zipped cram file

ReadMe.doc -- Documentation file for CRAM7

StartCram.doc -- base Cram document

Template folder -- document form folder

**Setting up Microsoft Word (MW)**

Before starting any macros, set the following in MW.

Tools

Options

Security

MacroSecurity

Medium, OK, OK

Tools

AutoCorrect

AutoCorrect

Turn off capitalize first letter of sentences

Look at all the other items in AutoCorrect to be sure they are set to
your needs? For example, under AutoFormat As You Type do you want:

Fractions 1/ 2 to ^1^/~2~

**Getting Started**

To access CRAM7, open the StartCram.doc in the C:\\CRAM7 directory.

You will be asked with a prompt to [Disable]{.underline} or
[Enable]{.underline} macros. Select **[Enable]{.underline}**.

You are now at the Cadastral Returns and Macros welcome screen Your menu
bar should now include two pull down menus, Cadastral Docs and CRAM 7.0,
located at the end of your menu bar.

Cadastral Docs is a collection of documents which may be useful to a
Cadastral Surveyor. See the Cadastral Documents Section for a complete
list of documents.

CRAM 7.0 is a collection of macros designed to assist the Cadastral
Surveyor with the writing of field notes. See the Cadastral Field Note
Section.

**Cadastral Documents**

This is a collection of documents often utilized by Cadastral Surveyors.

These documents are accessed by clicking on the Cadastral Docs tab on
the menu bar. Highlight the desired document title and click to open.

The following is a list of documents and a brief description:

BLMLetter Memorandum with BLM letterhead

BLMBCLetter Memorandum with Cadastral Cap letterhead

DOIBLMLetter Memorandum with DOI and BLM logos

DI105 Property transfer form

IndexFN Index diagram for field notes

ProgressTp Progress Diagram for a township

ProgressSec Progress Diagram for a section

ProgressContinueSht Continuation Sheet for Progress Diagrams

ReportSurvey Form for reporting the condition of previous surveys

RequestSurvey Request survey form

Specials Sample of Special Instructions

CheckListSpecials Check list when creating Special Instructions

ReturnStatusSheet Survey Tracking form for submitted surveys

SecDiagram Section Diagram

SecDiag256 Section Diagram to 1/256 corner

TpDiagram Township Diagram

VerbalDoc Verbal Document form to print and fill in longhand

VerbalDoc2 Verbal Document to fill out in Microsoft Word

WeeklyReport Cadastral Surveyor's weekly report form

When these documents are opened through the CadastralDocs menu they are
read only, consequently they must be saved with a different name.
However if you need to edit any of these base documents to meet your
needs, for example to change the address on the BLM letter head to your
offices address. Open the document BLM.doc in C:\\tmp\\CRAM7\\Template\\
directory and if you get a run time error '5825' the best thing to do is
get up from you desk close your eyes turn in a circle a couple of times
and run full speed until you hit something solid, or select
[E]{.underline}nd and edit the document as needed and save it with same
BLM.doc name. Now the next time you run the BLMletter macro the edits
you made should be apparent. This method should work for any of the
Cadastral documents.

**Cadastral Field Notes**

A compilation of macros have been assembled to assist the surveyor in
the creation of cadastral field notes. These macros are designed to take
advantage of the functionality provided in the Microsoft Word software
and to create a consistent set of field notes within themselves and not
to create generic field notes. So edit these macros and create your own
to assist in the creation of your field notes. Most of the macros will
prompt the user for information with a box in the middle of the screen.
Macros are accessed by clicking on the CRAM 7.0 tab on the end of the
menu bar. Highlight the desired macro and click to execute. Some macros
can be executed by hot keys, see the Alternate Key Board for the list.

The following is a list of available macros on the pull down menu and a
brief explanation:

SetupT.R.Gp This macro is usually the first macro ran at the start of a
new set of field notes. It sets several variables, which are [anchored
to the document]{.underline}. The variables include Township, Range, Gp
No., State, Meridian, and the units of measure. These variables are
utilized by numerous macros for the cover page data, headers, brass cap
markings, field note paper, and formatting. This macro will also call
the field note paper.

CoverPage Usually the second macro to run which types the cover page,
prompting the user for input and sets up formatting and creates the
first header and the field note paper.

SurveyStatement After the history is typed, if desired, run this macro
to insert the remainder of data pertinent to page one, with prompts for
user input.

BrassCapMark A macro which has the ability to create: 1) a brass cap
stamp,

> 2\) A monument description, 3) bearing trees, and 4) magnet
> descriptions. Tab through the 4 above mentioned tabs and select the
> items you wish to insert for your particular corner. Note that from
> the township diagram you can pick a section, a ¼ section corner, a
> 1/16 corner, a 1/64 etc down to a 1/1024 corner. This macro will
> require you to set the township and range in the brass cap stamp tab.
> The macro will retain the township and range values while the
> particular document is open only. In other words it does not utilize
> the values set in the "SetUpT.R.Gp" macro. However this is a very
> powerful macro which is very well laid out by a surveyor and I think
> you will like it. This macro was created by Red, Thanks Red for
> sharing this macro with us.

BearingDegree To create a bearing with degrees only

DegreesMinutetoSecond To create a bearing degree, minutes and seconds

FromCor From this point statement with bearing

SetASSP To create a monument description without cap markings

BearingTreeNew To create new bearing tree including formatting

BearingTreeRecovered To create a recovered bearing tree

ReferenceMonument To create a reference monument

DepositAMagnet Deposit a magnet at base of stainless steel post

Lines To create long or short lines to divide the body of the field
notes

Topo A list of 19 macros to insert topography calls in the field notes.
Run this macro after the FromCor macro

FieldAssistants Document at end of field notes to list the assistants

SurveyCertificate Surveyor's Certificate document

**Alternate Key Board**

The alternate key board includes some special characters and hot keys
which execute

macros for field note creation. The following is a list and short
description.

**Characters**

Alt + \~ (top row #s) Hard Space

Alt + 1 (top row #s) Degree symbol

Alt + 2 (top row #s) ¼ symbol

Alt + 3 (top row #s) ½ symbol

Alt + 4 (top row #s) ¾ symbol

The above keys do not work when any other macro is running.

**Hot Keys to Macros**

Alt + a Bearing in degree min secs.

Alt + b New bearing tree

Alt + c Brass Cap mark

Alt + d Deposit magnet statement

Alt + f From this point statement

Alt + s Set a stainless steel post

**General Information**

As mentioned in the SetupT.R.Gp macro, when the save changes is accepted
in this macro the variables are stored with the document. As a result,
you can have several documents with different stored variables. If you
need to check or reset the variable settings within a document, run this
macro to reset of change the values. Most of the macros are designed to
be run from the 1^st^ column, the ones that are inserted at the cursor
position are both bearing macros and all the topography macros. To enter
a distance tab once (to decimal align), tab again (to left align) and
you can run a topography macro or enter text manually.

The body of the notes has only two basic paragraph settings, these
settings are automatically created. Here are the settings created for
your information:

> 1\) For most text
>
> 0.5" Left Tab
>
> 0.2" Left Tab
>
> 1.0 Left Tab
>
> 1.5 Left Tab
>
> 3.1 Center Tab

2)  For bearing trees

> 0.5 First line

2.  Hanging indent

These format settings are automatic when the macros are utilized.

The FNbaseCorOnly.doc file, located in the template directory, is a
sample document which can be utilized if there are problems with
formatting or to check how the document should look. For example to
check how headers are formatted.

The macros are stored in a template file called cram.dot. To edit the
macros be in any document utilizing the cram.dot template in MW and
select:

Tools

Macro

Macros

Highlight the macro to edit and

> Edit You should now be in the Microsoft Visual Basic editor.

Store your field note files in your CRAM6 directory.

While a macro is running no other software operations are available. If
you have executed a macro erroneously it is best to complete the macro
and delete the text it has entered.

**Macro list**

BearingDeg Types bearing in degrees only

BearingDegLast Types bearing in degrees and in minutes and seconds

BLMCapLetter Calls up memo with cadastral cap markings

BTANew A new bearing tree

Btmargins Sets format for bearing trees

BTRecovered A recovered bearing tree

CheckListSpecials The check form for Special Instructions

CoverPages Tthe cover page for field notes

DegreeMinuteSecond Bearing in degree, minutes and seconds

DepositAMagnet Deposit a magnet statement

DOI105 DI105 Form

DOILetter Department of the Interior memorandum

FieldAssistants Field assistants page near end of field notes

FNPaperChains Field Note paper in chains

FNPaperFeet Field Note paper in feet

Footchainssetup Checks variable to insert field note paper

GetBearing Returns bearing to quadrant

GetDegMinSec Input box for degree, minute and second

GetDegrees Input box for degrees

HeaderSetup Header set up macro

HeaderSetupInsertion Insert header

HeaderSetupTab Format for headers

IndexforFN Index diagram for field note paper

Initoptions Set up configuration

InitTab Tab insert

Initvars Activate variables

LongLine Long line in field notes

PickALine Input fox for line selections

ProgressContinueSht Continuation form for progress diagram

ProgressSec Programs diagram for a section

ProgressTP Programs diagram for a township

ReferenceMonument Reference monument statement

ReportSurvey Report the condition of a survey form

RequestSurvey Request survey form

ReturnStatusSheet Job tracking form for Groups submitted

SCert Certificate of a survey page

SecDiagram Diagram of a section

SecDiagram2 Diagram of a section

SecDiagram256 Diagram of a section to ^1^/~256~

SetASSP Set a stainless steel post

**Macro list** (cont.)

SetDefFont Set default font

Setmargins Set margins

Setup Set up township, range, group number, state, and meridian

Setupvars Variable values

Setwidemargins Set outside margins for documents

Shortline Short line on field notes

Showcom Show active variable values

Specials Basic set of Special Instructions

SurveyorsCertificate Surveys Certificate, last page of field notes

SurveyStatement Survey Statement on page number one

ThisDocument.Document_Open Opens document variables

TopoAsphaltRoad

TopoBottomofDescent

TopoCreek

TopoDirtRoad

TopoGraveledRoad

TopoHeadOfRavine

TopoLeftBankOfRiver

TopoNamedCreek

TopoORStateHighway

TopoPowerLines Topography calls in field notes

TopoRavine

TopoRidge

RopoRightBankOfRiver

TopoRiver

TopoSpur

TopoTopofAscent

TopoUSHighway

TopoUtilityLines

TopoWireFence

TpDiagram

VerbalDoc Verbal documentation form to print

VerbalDoc2 Verbal documentation form to fill out in MW

WeeklyReport Weekly Report form for Cadastral Surveyors

zzRectMon Corner description including cap markings, bearing trees and
magnets