Spreadsheet: 871193d1717591838-load-a-txt-file-from-an-erp-system-into-separate-columns-smaller-forum-sample
Sheet: Sheet1

Column1
Plant		0600			Analysis date		05.06.2024
Analysis based on Requirement value ;;
Material                                 Description                   ABC-ind. new old
Value in USD              Qty             Un      %  cml.
 | Material | Description | New | Old | Value in USD | QTY | Un | % | cml
[PHONE]					GANTRY & STAND (2.7/3.0/4.0 120 MLC)					A	C | 10004700012 | GANTRY & STAND (2.7/3.0/4.0 120 MLC) | A | C | 49072014 | 90 | EA | 6.95 | 6.95
49,072,014.00	           90.000				EA	  6.95	  6.95
[PHONE]					3.0 TrueBeam 120 MLC, w/CG					A	C
40,676,786.54	           59.000				EA	  5.76	 12.70
P1050343017					CPS COMPLETED, 3.0 W/ 120 LEAF MLC					A	C
32,396,845.73	           47.000				EA	  4.59	 17.29
P1036941011					CPS TESTED, 3.0 w/ 120 LEAF MLC					A	C
31,350,624.26	           46.000				EA	  4.44	 21.72
P1035678011					CELL TESTED, 3.0 w/ 120 LEAF MLC					A	C
30,704,397.86	           46.000				EA	  4.35	 26.07
P1035677017					3.0 w/ 120 LEAF MLC					A	A
29,341,186.94	           46.000				EA	  4.15	 30.22
P1050343011					CPS COMPLETED, 4.1 W/ 120 LEAF MLC					A	C
19,571,538.48	           24.000				EA	  2.77	 32.99
P1052547001					PU KV Motion System cpl. 3.0					A	A
18,395,672.40	          189.000				EA	  2.60	 35.60
P1036941020					CPS TESTED, 4.1 w/ 120 LEAF MLC					A	C
17,015,188.63	           23.000				EA	  2.41	 38.00
P1035678020					CELL TESTED, 4.1 w/ 120 LEAF MLC					A	C
16,132,816.63	           23.000				EA	  2.28	 40.29
P1035677032					CAGE TESTED, 4.1 w/ 120 LEAF MLC					A	A
14,091,405.24	           22.000				EA	  1.99	 42.28
P1000847005					SLED ASSEMBLY					A	C
12,551,867.00	          145.000				EA	  1.78	 44.06
P1052044001					MLC/COLLIMATOR ASSY,HET 120 LEAF					A	C
10,318,931.10	           90.000				EA	  1.46	 45.52
[PHONE]					TRUEBEAM 2.7 MLC 120 W/CG					A	C
9,815,539.58	           14.000				EA	  1.39	 46.91
P1050343002					CPS COMPLETED, 120 LEAF MLC					A	C
9,112,577.50	           13.000				EA	  1.29	 48.20
P1036941005					2.7 w/ 120 LEAF MLC CPS Tested					A	C
8,999,631.16	           13.000				EA	  1.27	 49.47
P1036941012					CPS TESTED, 3.0 w/ HD 120 LEAF MLC					A	C
8,565,350.88	           12.000				EA	  1.21	 50.68
[PHONE]					GANTRY & STAND (2.7/3.0/4.0 HD 120 MLC)					A	C
8,555,757.00	           15.000				EA	  1.21	 51.89
P1035678012					CELL TESTED, 3.0 w/ HD 120 LEAF MLC					A	C
8,396,858.64	           12.000				EA	  1.19	 53.08
P1050343014					CPS COMPLETED, 4.0 W/ 120 LEAF MLC					A	C
8,295,701.04	           12.000				EA	  1.17	 54.26
P1036941023					CPS TESTED, 4.0 w/ 120 LEAF MLC					A	C
8,202,589.68	           12.000				EA	  1.16	 55.42
P1035678023					CELL TESTED, 4.0 w/ 120 LEAF MLC					A	C
8,034,008.88	           12.000				EA	  1.14	 56.55
P1050343018					CPS COMPLETED, 3.0 W/ HD 120 LEAF MLC					A	C
7,873,400.81	           11.000				EA	  1.11	 57.67
P1035677029					CAGE TESTED, 4.0 w/ 120 LEAF MLC					A	A
7,678,388.64	           12.000				EA	  1.09	 58.75
P1035678005					2.7 w/ 120 LEAF MLC					A	C
7,467,129.78	           11.000				EA	  1.06	 59.81
P1035677018					3.0 w/ HD 120 LEAF MLC					A	A
7,371,135.20	           11.000				EA	  1.04	 60.85
P1048469001					RTI4343iL-C7A					A	A
7,278,703.68	          272.000				EA	  1.03	 61.89
P1035677011					2.7MR4 w/ 120 LEAF MLC					A	A
7,141,144.56	           11.000				EA	  1.01	 62.90
[PHONE]					KIT, GANTRY & STAND COVERS (VOS)					A	A
7,050,923.23	          221.000				EA	  1.00	 63.89
P1000985005					HET FINAL DRESS ASSY					A	C
6,949,075.90	          130.000				EA	  0.98	 64.88
[PHONE]					MAJOR MECHANICAL ASSY HET 2.7/3.0/4.0					A	A
6,910,155.45	           99.000				EA	  0.98	 65.86
P1000984003					BAKEOUT ASSEMBLY					A	A
6,709,065.10	          134.000				EA	  0.95	 66.80
[PHONE]					3.0 Edge, w/CG					A	C
5,819,500.48	            8.000				EA	  0.82	 67.63
TM68500018					Couch Pedestal General Assy, T B (V2.7+)					A	C
5,737,632.11	          107.000				EA	  0.81	 68.44
[PHONE]					SPECIFICATION, KLYSTRON					A	C
5,237,614.20	          130.000				EA	  0.74	 69.18
P1050343003					CPS COMPLETED, HD120 LEAF MLC					A	C
5,184,078.90	            7.000				EA	  0.73	 69.92
P1036941006					2.7 w/ HD 120 LEAF MLC CPS Tested					A	C
5,123,261.64	            7.000				EA	  0.73	 70.64
P1035678006					2.7 w/ HD 120 LEAF MLC					A	C
5,029,116.26	            7.000				EA	  0.71	 71.35
[PHONE]					3.0 VitalBeam 120 MLC, w/CG					A	C
4,834,467.05	            7.000				EA	  0.68	 72.04
[PHONE]					MODULATOR, TB, 60HZ, 480V					A	A
4,289,980.96	          107.000				EA	  0.61	 72.64
P1054805005					MODULATOR, IN-HOUSE CONFIG (60HZ/480V)					A	C
4,209,794.40	          105.000				EA	  0.60	 73.24
P1015093001					SOLENOID PULSE TANK ASSY					A	A
4,166,580.60	          139.000				EA	  0.59	 73.83
P1035677012					2.7MR4 w/ HD 120 LEAF MLC					A	A
4,132,860.96	            6.000				EA	  0.58	 74.41
[PHONE]					4.1 TrueBeam 120MLC					A	C
4,078,116.25	            5.000				EA	  0.58	 74.99
[PHONE]					CAROUSEL ASSY					A	C
4,076,184.83	          103.000				EA	  0.58	 75.57
P1029567001					OSMS DOLLIS HILL TB SYSTEM 230V					A	C
3,592,680.00	           20.000				EA	  0.51	 76.08