The serial number digital identification letters column output
1 1 A serial number 100 Numbers identify letters column
2 0 1 100 1 A
30 1 2 3 20 0
4 40 0 3 30 1
5 50 0 4 40 0
9 50 0 5 0
10, 500 1 A serial number Numbers identify letters column
11 100 500 1 A
12, 420, 11, 100
13, 1000 12 420 0
14, 600 1 B
15, 300 output
16, 700 1 A 16, 700 1 A
17, 300, 17, 300
18, 600 18 600 0
19 200 0
20 100 0
"When meet the identity column value is 1 and the letter as A when calculating the number of columns sum of the Numbers listed below, and if greater than or equal to identity column 1 output for these lines, when calculating accumulation, identified as 1 case, minus the corresponding numerical values,
For example: the first line identified as 1, obtain the corresponding number listed 100; Down the accumulation (20-30 + 40 + 50) & gt; 100, the output 1-5 lines to the excle
"
CodePudding user response:
Written in python