Item13572Test < Tasks/Testcases

Mostly copied from Tasks.Item13572

Set FORMULAFROMHELL = $EVAL( ($T(R$ROW():C4)+0) * $GET(MTSCAB2) + ($T(R$ROW():C5)+0) * $GET(MTSCAB4) + ( ( ($T(R$ROW():C4)+0) + ($T(R$ROW():C5)+0) ) * ($T(R$ROW():C6)+0) + ($T(R$ROW():C7)+0) ) * $GET(BR) + ($T(R$ROW():C8)+0) * $GET(XCVR) + ($T(R$ROW():C9)+0) * $GET(PA) + ( ( ($T(R$ROW():C4)+0) + ($T(R$ROW():C5)+0) ) * ($T(R$ROW():C10)+0) * $GET(SC) ) + ( ($T(R$ROW():C4)+0) + ($T(R$ROW():C5)+0) ) * ($T(R$ROW():C11)+0) * $GET(PSU) + ($T(R$ROW():C4)+0) * $GET(RFDS2) + ($T(R$ROW():C5)+0) * $GET(RFDS4) )

Customer	Pass	Purpose	Product 1	Product 2	Item per Product	Extra 1	Component A	Component B	Component 3 (per)	Component 4 (per)	Acces for P1	Access for P2	Cost (USD)	When (Q)
Group 1	P1	Something					10	3					6045	Q2-15
Group 2	P1	Something					5						2400	Q2-15
Group 3	P1	Something					4						1920	Q2-15
Group 4	P1	Something	3		4	4			2	1	3		26915	Q2-15
Group 5	P1	Something		2	2	2			1	1		2	27354	Q2-15
Total			3	2	16	6	41	25	8	5	3	2	64634

Customer	Pass	Purpose	Product 1	Product 2	Item per Product	Extra 1	Component A	Component B	Component 3 (per)	Component 4 (per)	Acces for P1	Access for P2	Cost (USD)	When (Q)
Group 1	P2	Something				5	20	6					16915	Q4-15
Group 2	P2	Something					8						3840	Q4-15
Group 3	P2	Something					4						1920	Q4-15
Group 4	P2	Something	2		4	4			2	1	2		19230	Q4-15
Group 5	P2	Something		1	2	2			1	1		1	14642	Q4-15
Total			2	1	10	11	53	27	5	3	2	1	56547