Construction Calculator

**MAXIM** · 04-16-2010, 03:54 PM

I have am trying to construct a construction calculator where I have E15 input values of 5, & E16 =2
F17=SUM(E15*E16) (10m2 Area)

The building components for 10m2 are as follows
E24=545 (kg) E25=22 (kg) F24=155 (bags) F25=7 (bags)
F27=1050 . I only want input in E15 & E16 I have others to do in other trades but like some help to start off. Can anyone help me with the formula to keep the same proportions in the other cells, ideally uneditable.

Many Thanks in advance

**ratcat** · 04-17-2010, 03:44 AM

G'day

With limited information I have constructed this

**royUK** · 04-17-2010, 03:51 AM

Why F17=SUM(E15*E16)?

This should do the same

F17=E15*E16

**MAXIM** · 04-21-2010, 05:26 PM

Thank you both very much for your help, got the spreadsheet built.

The sheet has one last problem to solve in relation to a triangle trigonometry problem, on a roof calculator.

**MAXIM** · 04-21-2010, 05:48 PM

I have two problems to solve on this workbook Index & a Trig problem.

Index ; I have entered the following syntax in the VBA editor but get error message

Private Sub Worksheet_Activate()

Dim wSheet As Worksheet

Dim l As Long

l = 1

With Me

.Columns(1).ClearContents

.Cells(1, 1) = "INDEX"

.Cells(1, 1).Name = "Index"

End With

For Each wSheet In Worksheets

If wSheet.Name <> Me.Name Then

l = l + 1

With wSheet

.Range("B1").Name = "Start_" & wSheet.Index

.Hyperlinks.Add Anchor:=.Range("A1"), Address:="",

SubAddress:="Index", TextToDisplay:="Back to Index"

End With

Me.Hyperlinks.Add Anchor:=Me.Cells(l, 1), Address:="", _

SubAddress:="Start_" & wSheet.Index, TextToDisplay:=wSheet.Name

End If

Next wSheet

End Sub

: