A

B

C

D

E

F

G

H

I

J

2

SHEET TAB

FORM

COMMAND

DESCRIPTION

RESULT

DEFAULT RESULTS

RESULT FORMULAS

3

102

Master Bid

Check Box 10

Is this Project Taxible?

FALSE

FALSE

4

102

Master Bid

Value Formula

Sales Tax Rate for Installation?

FALSE

FALSE

1

2

5

101.A

For Master Bid

Value Formula

Quote Section One Sales Tax Rate

1

1

$          -

6

101.A

For Master Bid

Value Formula

Quote Section Two Sales Tax Rate

1

1

$          -

7

101.A

For Master Bid

Value Formula

Quote Section Three Sales Tax Rate

1

1

$          -

8

101.A

For Master Bid

Value Formula

Quote Section Four Sales Tax Rate

1

1

$          -

9

101.A

For Master Bid

Value Formula

Quote Sales Tax Value: 1=Retail; 2=Installed

-

-

$          -

$          -

10

102

Master Bid

Option Button 40-43

Determine Number of Categories Visible on Quote

1

1

11

102

Master Bid

Option Button 40

Quote Category One Format

TRUE

TRUE

12

102

Master Bid

Check Box 80

Quote Category One: Add Header to Section One

TRUE

TRUE

13

102

Master Bid

Check Box 14

Quote Category One: Add Sub-Total for Section One

TRUE

TRUE

14

102

Master Bid

Option Button 41

Quote Category Two Format

FALSE

FALSE

15

102

Master Bid

Check Box 81

Quote Category Two: Add Header to Section Two

TRUE

TRUE

16

102

Master Bid

Check Box 46

Quote Category Two: Add Sub-Total for Section Two

TRUE

TRUE

17

102

Master Bid

Option Button 42

Quote Category Three Format

FALSE

FALSE

18

102

Master Bid

Check Box 82

Quote Category Three: Add Header to Section Three

TRUE

TRUE

19

102

Master Bid

Check Box 56

Quote Category Three: Add Sub-Total for Section Three

TRUE

TRUE

20

102

Master Bid

Option Button 43

Quote Category Four Format

FALSE

FALSE

21

102

Master Bid

Check Box 83

Quote Category Four: Add Header to Section Four

TRUE

TRUE

22

102

Master Bid

Check Box 64

Quote Category Four: Add Sub-Total for Section Four

TRUE

TRUE

23

301-307

Master Bid

Hidden Check Box

Attached Layout

FALSE

FALSE

NEW ORDER TRUE/FALSE STATEMENTS

24

301-307

Master Bid

Hidden Check Box

Attached Components

#VALUE!

#VALUE!

1=YES; 2=NO

25

301-307

Master Bid

Hidden Check Box

Attached Net Items

FALSE

FALSE

Import Quote Data

1

26

301-307

Master Bid

Hidden Check Box

Attached Bradley

FALSE

FALSE

Edit Project Info

1

27

301-307

Master Bid

Hidden Check Box

Attached Bobrick

FALSE

FALSE

Edit Order Info

1

28

301-307

Master Bid

Hidden Check Box

Attached BradCross

FALSE

FALSE

Edit TP/TA Pricing

1

29

301-307

Master Bid

Hidden Check Box

Attached General

FALSE

FALSE

Edit Gen Pricing

1

30

301-307

Master Bid

Hidden Check Box

Attached Metpar

#VALUE!

#VALUE!

31

301-307

Master Bid

Hidden Check Box

Attached Toilet Accessories

FALSE

FALSE

32

301

Master Bid

Value Formula

Includes Lien

TRUE

TRUE

33

304

Master Bid

Value Formula

Includes Lien

TRUE

TRUE

34

305

Master Bid

Value Formula

Includes Lien

TRUE

TRUE

35

306

Master Bid

Value Formula

Includes Lien

TRUE

TRUE

36

307

Master Bid

Value Formula

Includes Lien

TRUE

TRUE

37

305

Master Bid

Check Box

Convert to BradCross

FALSE

FALSE

38

39

40

41