Overwriting data in columns

Similar to overwriting descriptions, you can use the overwrite mechanism to overwrite other data in the structure. The following is an example of creating different values for the cost_estimate attribute in an Impact Analysis form in the same line in the Excel file.

Header1	Item	Item	Item	Item	Attribute	Attribute	Attribute
Header2	Item	Item	Item	Item	ImpactAnalysis Form	ImpactAnalysis Form	ImpactAnalysis Form
Header3	Item	Item	Item	Item	cost_estimate	cost_estimate	cost_estimate
Header4	Level1	Level2	Level3	Level4	ALL	Level3	Level4
Title					Attr: Cost	Attr: Cost	Attr: Cost
	Product- Root				0.00
		P1	P1.1	P1.1.1	1.00	100.50	111
				P1.1.2			112
				P1.1.3			113
			P1.2	P1.2.1		123.45	121
				P1.2.2			122
		P2	P2.1	P2.1.1	2.00	90.00	211
			P2.1	P2.1.2			212
			P2.2	P2.2.1		200.00	221
			P2.3	P2.3.1		222.88	231

The resulting output shows the cost_estimate attribute set to 2.00. This is specified by the Header4 entry for the Attribute column that contains the keyword ALL (shown in white in the spreadsheet).

The Header4 entry for the next Attribute column, Level3 (shown in red), specifies that the cost_estimate value for P2.1 is set to 90.00. This overwrites the value 2.00 that was set by the ALL entry in the previous figure.

The Header4 entry for the next Attribute column, Level4 (shown in cyan), specifies that the cost_estimate value for P2.1.1 is set to 211. This overwrites the value 2.00 that was set by the ALL entry and the 90.00 set by the Level3 entry in the previous column.