Forum Discussion
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 curren...
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..
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
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
pls see attached file..
- 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 helpingpls see attached file..