Calculating number of additional lights per sq ft, to supplement existing lights

[jcneedshelp]

Hi

I am doing some planning for the amount of additional lights I need in a building, on top of what already exists

For Example the data I have is

Sq footage of the floor -100,000
1 light per 1000 sq ft currently

I need to know how many extra lights I would need to get the average down 1 per to 500 sq ft

I know this single calculation is easy, but I used round figures, I need to do this with a larger data set.

Thank you in advance

 

[FormR]

Hi, perhaps this will point you in the right direction.

Book3
	A	B
1	Sq footage floor	100000
2	Current 1 per	1000
3	Needed 1 Per	500
4	Current Lights	100
5	Needed Lights	200
6	Extra Lights needed	100
Sheet1

Cell Formulas
Range	Formula
B4	B4	=B1/B2
B5	B5	=B1/B3
B6	B6	=B5-B4

 

[jcneedshelp]

Thank you