Calculating Linear Feet to Saw Cut

[HardRockMike]

Im trying to find a formula or way to enter dimensions of trenches (rectangles) or squares that we bid to concrete saw cut.
then calculate how much linear footage there is to saw cut.

Example:
20' x 1' trench saw cut into 2' x 1' pieces. (that's cutting perimeter and making cross cuts every 1')

or

25' x 25' area cut into 2' x 1' pieces.

any help would be great!

thank you

 

[shg]

Got it now?

If you want to visualize how the formula works,

o Select a cell and apply left and top borders. Those are cuts at the top and left edge of one of the cut pieces -- one width and one length.

o Drag that cell down and right and look at the borders. The only cuts missing are the bottom and right of the big block. The last two terms of the formula add those.

 

[HardRockMike]

It works now, Im not sure what I did but its working.

thank you again!!

 

[shg]

You're welcome.

 

[shg]

Oops -- that calculates high if the pieces don't divide the trench dimensions evenly. This is accurate, I think:

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][td]

G​

[/td][td]

H​

[/td][/tr][tr][td]

4​

[/td][td]

Trench​

[/td][td]

​

[/td][td]

Piece​

[/td][td]

​

[/td][td]

Total Cut Length​

[/td][td][/td][td][/td][/tr]
[tr][td]

5​

[/td][td]

Len1​

[/td][td]

Wid1​

[/td][td]

Len2​

[/td][td]

Wid2​

[/td][td]

​

[/td][td][/td][td][/td][/tr]
[tr][td]

6​

[/td][td]

20​

[/td][td]

1​

[/td][td]

2​

[/td][td]

1​

[/td][td]

51​

[/td][td][/td][td]F6: =IFERROR(B6 * CEILING(C6/E6 + 1, 1) + C6 * CEILING(B6/D6 + 1, 1), "- - -")[/td][/tr]
[tr][td]

7​

[/td][td]

100​

[/td][td]

10​

[/td][td]

5​

[/td][td]

5​

[/td][td]

510​

[/td][td][/td][td][/td][/tr]
[tr][td]

8​

[/td][td]

25​

[/td][td]

25​

[/td][td]

2​

[/td][td]

1​

[/td][td]

1000​

[/td][td][/td][td][/td][/tr]
[tr][td]

9​

[/td][td]

25​

[/td][td]

25​

[/td][td]

4​

[/td][td]

4​

[/td][td]

400​

[/td][td][/td][td][/td][/tr]
[tr][td]

10​

[/td][td]

26​

[/td][td]

12​

[/td][td]

2​

[/td][td]

1​

[/td][td]

506​

[/td][td][/td][td][/td][/tr]
[tr][td]

11​

[/td][td]

44​

[/td][td]

7​

[/td][td]

5​

[/td][td]

5​

[/td][td]

202​

[/td][td][/td][td][/td][/tr]
[tr][td]

12​

[/td][td][/td][td][/td][td][/td][td][/td][td]

- - -​

[/td][td][/td][td][/td][/tr]
[tr][td]

13​

[/td][td][/td][td][/td][td][/td][td][/td][td]

- - -​

[/td][td][/td][td][/td][/tr]
[tr][td]

14​

[/td][td][/td][td][/td][td][/td][td][/td][td]

- - -​

[/td][td][/td][td][/td][/tr]
[tr][td]

15​

[/td][td][/td][td][/td][td][/td][td][/td][td]

- - -​

[/td][td][/td][td][/td][/tr]
[/table]