G
Guest
Hello,
I've got a couple of problems I could use some help with.
I have daily production data for every line we have
Line Date Prod Prod_2
N16 01/04/2006 00:00 0 0
N20 01/04/2006 00:00 752 614921
N28 01/04/2006 00:00 804 562132
N31 01/04/2006 00:00 530 443524
N32 01/04/2006 00:00 1416 951925
N33 01/04/2006 00:00 138 114702
N36 01/04/2006 00:00 327 139235
N38 01/04/2006 00:00 434 627277
We also test these lines to give us an idea of how many solid particles are
in the line (ppm)
Linecode TestDate Duration ppm
N20 19/04/2006 00:04 15 9
N36 06/05/2006 21:44 8.5 10
N44 08/05/2006 18:00 7.94 9
N41 10/05/2006 20:02 6.91 7
N28 12/05/2006 00:00 15.5 19
N16 12/05/2006 12:00 9.39 11
N32 29/05/2006 15:37 19.57 14
N41 10/01/2006 21:05 15.3 10
N31 24/01/2006 17:04 12 10
N33 16/02/2006 10:19 4.6 12
I want to have a spreadsheet where I can type in two dates and the sheet
refers to the most relative test date data and uses the particle test info
and places that next to the production line
i.e Production line N41 returns the test data supplied in January not the
later test data of May as the production date required is April. I think a
VLOOKUP is required but I'm not having much success getting a solution
I'm hoping the solution should look like this:
Line Date Prod Gas Returned Info Here
N16 01/04/2006 00:00 0 0 11
N20 01/04/2006 00:00 752 614921 9
N28 01/04/2006 00:00 804 562132 19
N41 01/04/2006 00:00 500 124506 10
N31 01/04/2006 00:00 530 443524 10
These production lines also run into tanks which is given as a data import
Line Date Tank
NP16 01/04/2006 00:00 A
NP32 01/04/2006 00:00 B
NP38 01/04/2006 00:00 A
NP41 01/04/2006 00:00 A
NP31 01/04/2006 00:00 A
NP33 01/04/2006 00:00 C
NP39 01/04/2006 00:00 B
And I want to be able to calculate how much of these particles are flowing
into each tank between the two dates I stipulated earlier, bearing in mind
that the lines flowing into each tank change day to day, and the line is
referred to as NP rather than N earlier which is throwing VLOOKUP all to pot.
ANY help on any of these requests would be much appreciated.
Thanks
R
I've got a couple of problems I could use some help with.
I have daily production data for every line we have
Line Date Prod Prod_2
N16 01/04/2006 00:00 0 0
N20 01/04/2006 00:00 752 614921
N28 01/04/2006 00:00 804 562132
N31 01/04/2006 00:00 530 443524
N32 01/04/2006 00:00 1416 951925
N33 01/04/2006 00:00 138 114702
N36 01/04/2006 00:00 327 139235
N38 01/04/2006 00:00 434 627277
We also test these lines to give us an idea of how many solid particles are
in the line (ppm)
Linecode TestDate Duration ppm
N20 19/04/2006 00:04 15 9
N36 06/05/2006 21:44 8.5 10
N44 08/05/2006 18:00 7.94 9
N41 10/05/2006 20:02 6.91 7
N28 12/05/2006 00:00 15.5 19
N16 12/05/2006 12:00 9.39 11
N32 29/05/2006 15:37 19.57 14
N41 10/01/2006 21:05 15.3 10
N31 24/01/2006 17:04 12 10
N33 16/02/2006 10:19 4.6 12
I want to have a spreadsheet where I can type in two dates and the sheet
refers to the most relative test date data and uses the particle test info
and places that next to the production line
i.e Production line N41 returns the test data supplied in January not the
later test data of May as the production date required is April. I think a
VLOOKUP is required but I'm not having much success getting a solution
I'm hoping the solution should look like this:
Line Date Prod Gas Returned Info Here
N16 01/04/2006 00:00 0 0 11
N20 01/04/2006 00:00 752 614921 9
N28 01/04/2006 00:00 804 562132 19
N41 01/04/2006 00:00 500 124506 10
N31 01/04/2006 00:00 530 443524 10
These production lines also run into tanks which is given as a data import
Line Date Tank
NP16 01/04/2006 00:00 A
NP32 01/04/2006 00:00 B
NP38 01/04/2006 00:00 A
NP41 01/04/2006 00:00 A
NP31 01/04/2006 00:00 A
NP33 01/04/2006 00:00 C
NP39 01/04/2006 00:00 B
And I want to be able to calculate how much of these particles are flowing
into each tank between the two dates I stipulated earlier, bearing in mind
that the lines flowing into each tank change day to day, and the line is
referred to as NP rather than N earlier which is throwing VLOOKUP all to pot.
ANY help on any of these requests would be much appreciated.
Thanks
R