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