Forum Discussion

Josh Moulton's avatar
Josh Moulton
Copper Contributor
Oct 28, 2018

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...
excel
Formulas and Functions
Josh Moulton's avatar
Josh Moulton
Copper Contributor
Oct 29, 2018
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
  • Josh Moulton's avatar
    Josh Moulton
    Copper Contributor
    Oct 29, 2018
    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
      • Josh Moulton's avatar
        Josh Moulton
        Copper Contributor
        Oct 29, 2018
        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.

Resources