# Excel data formula help

Highlighted
Occasional Contributor

# Excel data formula help

I have this paper I would like to input into a excel sheet so when someone add the number to the "pcs ran" it automatically completes the rest.
"Ind 1 X 2" would be pcs ran time 2 added to the current number in the line above it. How can I do this.
"
7 Replies
Highlighted

# Re: Excel data formula help

would you kindly explain further your query.

like, what is the unit of  "PC RAN"?

the value of row above it:  "71516" - what is this?

what is the meaning of "IND 1 X 2"?

how is the "TOTAL" computed?

and so on, so that people here at the forum can have a better view of your problem.

thanks..

Highlighted

# Re: Excel data formula help

Pcs run is just the number of product that was ran
Ind 1 X 2 means it runs 2 times per product ran
Ind 2 X 4 means it runs 4 times per product ran
Ind 3 X 3 means it runs 3 times per product ran
Ind 4 X 2 means it runs 2 times per product ran
Ind 5 X 1 means it runs 1 time per product ran
Ind 6 X 1 means it runs 1 time per product ran

So say 10 products are ran
Ind 1 is (10 x 2) then added the current total located above
Ind 2 is (10 x 4) then added the current total located above
Ind 3 is (10 x 3) then added the current total located above
Ind 4 is (10 x 2) then added the current total located above
Ind 5 is (10 x 1) then added the current total located above
Ind 6 is (10 x 1) then added the current total located above

I want it so when someone adds a new total to the "pcs ran" it will automatically fill out the rest of the row.

Let me know if I need to give anymore and Thanks too
Highlighted

# Re: Excel data formula help

pls see attached file..

Highlighted

# Re: Excel data formula help

The cell c3... 2862 was the starting number on the previous page. So it is (30 x 2) plus 2862.
"Total" is just the pieces ran added together so on the previous page it was at 18 so we added 30 to 18 and got the total number.
Again thanks for helping
Highlighted

# Re: Excel data formula help

pls see attached file..

Highlighted

# Re: Excel data formula help

The Blue numbers are not important they are just the serial number of the different inductors.

Yes there are previous pages. Each of the inductors started at 0 at one point.
Highlighted

# Re: Excel data formula help

pls see attached file..