test

[Matt_Chelmsford]

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1
2														MONDAY
3
4															TUESDAY	WEDNESDAY	THURSDAY	FRIDAY	SATURDAY	SUNDAY
5
6
7
8					Customer Breakout (Max 20)							RESOURCES					Load	Lay/Plough	Plib	Weather
9			-1		1	BRUCE						RISING		TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	FALSE
10					2	NILS						DARKNESS		FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE
11					3	CHARLIE						MAGIC		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
12					4	JAKE						USA		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
13					5	MAX						RUN		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
14			#		6	ROY						GREETINGS		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
15			#		7	STEVE						THE WILD		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
16			#		8	GARRY
17					9
18					10							Other Resources
19					11							RIVER		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
20					12							NEBRASKA		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
21					13							TUNNEL		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
22			#		14							WORKING		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
23					15							THE GHOST		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
24					16							DEVILS		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
25					17							LUCKY		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
26					18
27			a		19
28					20
29
30
31
32				Total	BRUCE	NILS	CHARLIE	JAKE	MAX	ROY	STEVE	GARRY
33	Breakdown
34	RISING MONDAY		a	0.00
35	RISING TUESDAY		a	0.00
36	RISING WEDNESDAY		a	0.00
37	DARKNESS SATURDAY		a	0.00
38	Total Days	0.00	a	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Inputs (2)

Cell Formulas
Range	Formula
C9	=-((90-(B9-B4))/90)
C14	=ABS((USDGBP-1.6)/1.6)
C15	=ABS((EURGBP-1.2)/1.2)
C16	=ABS((EURUSD-1.333333333)/1.3333333)
C22	=ABS((Fuel-1100)/1100)
C27	=IF(B27=B38,"a","r")
C34	=IF(B34=D34,"a","r")
C35	=IF(B35=D35,"a","r")
C36	=IF(B36=D36,"a","r")
C37	=IF(B37=D37,"a","r")
C38	=IF(B38=D38,"a","r")
E32	=IF(F9<>"",F9,"")
E38	=IF(E32<>"",SUM(E34:E37),"")
F32	=IF(F10<>"",F10,"")
F38	=IF(F32<>"",SUM(F34:F37),"")
G32	=IF(F11<>"",F11,"")
G38	=IF(G32<>"",SUM(G34:G37),"")
H32	=IF(F12<>"",F12,"")
H38	=IF(H32<>"",SUM(H34:H37),"")
I32	=IF(F13<>"",F13,"")
I38	=IF(I32<>"",SUM(I34:I37),"")
J32	=IF(F14<>"",F14,"")
J38	=IF(J32<>"",SUM(J34:J37),"")
K32	=IF(F15<>"",F15,"")
K38	=IF(K32<>"",SUM(K34:K37),"")
L32	=IF(F16<>"",F16,"")
L38	=IF(L32<>"",SUM(L34:L37),"")
M32	=IF(F17<>"",F17,"")
M38	=IF(M32<>"",SUM(M34:M37),"")
N32	=IF(F18<>"",F18,"")
N38	=IF(N32<>"",SUM(N34:N37),"")
O32	=IF(F19<>"",F19,"")
O38	=IF(O32<>"",SUM(O34:O37),"")
P32	=IF(F20<>"",F20,"")
P38	=IF(P32<>"",SUM(P34:P37),"")
Q32	=IF(F21<>"",F21,"")
Q38	=IF(Q32<>"",SUM(Q34:Q37),"")
R32	=IF(F22<>"",F22,"")
R38	=IF(R32<>"",SUM(R34:R37),"")
S32	=IF(F23<>"",F23,"")
S38	=IF(S32<>"",SUM(S34:S37),"")
T32	=IF(F24<>"",F24,"")
T38	=IF(T32<>"",SUM(T34:T37),"")
U32	=IF(F25<>"",F25,"")
U38	=IF(U32<>"",SUM(U34:U37),"")
V32	=IF(F26<>"",F26,"")
V38	=IF(V32<>"",SUM(V34:V37),"")
W32	=IF(F27<>"",F27,"")
W38	=IF(W32<>"",SUM(W34:W37),"")
X32	=IF(F28<>"",F28,"")
X38	=IF(X32<>"",SUM(X34:X37),"")
D34	=SUM(E34:W34)
D35	=SUM(E35:W35)
D36	=SUM(E36:W36)
D37	=SUM(E37:W37)
D38	=SUM(D34:D37)
A35	=IF(O9=TRUE,L9&" "&O4,"")
A36	=IF(P9=TRUE,L9&" "&P4,"")
B38	=SUM(B34:B37)

Named Ranges
Name	Refers To	Cells
'Inputs (2)'!EURGBP	='Inputs (2)'!$B$15
'Inputs (2)'!EURUSD	='Inputs (2)'!$B$16
'Inputs (2)'!Fuel	='Inputs (2)'!$B$22
'Inputs (2)'!USDGBP	='Inputs (2)'!$B$14