-- Firm Author Help --
-- Reference --

Cells in Letters

Common Cells

You can use the following common cells when drafting the letter:

Cell Description Cell Name Cell Calculation

Letterhead

Name of firm

ACFIRM1

cvdata("CQ010010_010")

Address 1

ACFIRM2

cvdata("CQ010010_020")

Address 2

ACFIRM3

cvdata("CQ010010_030")

City ACFIRM4 cvdata("CQ010010_040")
Province/State ACFIRM5 cvdata("CQ010010_300")
Postal/Zip Code ACFIRM6 cvdata("CQ010010_060")
Firm Designation CAFIRM10 cvdata("CQ010010_100")

Singular

”our” vs ”my” used in a letter (lower case form). Option is triggered from the menu to use singular or plural tense

WEI2

iif(SING1=0,"our","my")

”we” vs ”I” used in a letter (lower case form). Option is triggered from the menu to use singular or plural tense

WEI3

iif(SING1=0,"we","I")

”We” vs ”I” used in a letter (capitalized form). Option is triggered from the menu to use singular or plural tense.

WEI4

iif(SING1=0,"We","I")

”Our” vs ”My” used in a letter (capitalized case form). Option is triggered from the menu to use singular or plural tense

WEI5

iif(SING1=0,"Our","My")

”us” vs ”me” used in a letter (lower case form). Option is triggered from the menu to use singular or plural tense

WEI6

iif(SING1=0,"us","me")

Consolidated

Cell to be refer to consolidated when selected from the menu.

CONSOL

iif(CONSOLID1," consolidated "," ")

Other

Client name as defined in Engagement Properties

CLIENT

Clp2

Other Cells

You can populate external data entries from EP7 document. The following entries include:

Cell Description Cell Calculation
Country cvdata("CQ010010_045")
Telephone number cvdata("CQ010010_070")
Facsimile number cvdata("CQ010010_080")
E-mail address cvdata(" CQ010010_085")
Practicing unit is referred to as cvdata("CQ010010_090")

This online help system applies to all CaseWare Audit, Review, and Compilation products. Not all features are available in all products.