Spreadsheet: 552591d1513671465-power-query-two-way-data-moving-projektijuhtimine
Sheet: Sheet4

 | Projekti number | Tellimuse kategooria | Tellimuse esitamise number | Tellimuse kirjeldus | [NAME] / Positsioon | Tellimuse esitamise kuupäev | Soovitud tellija poolt tarneks valmis kuupäev | Tellimuse sihtkoht | Tellimuse esitaja | Märkused | Tellitud kogus | Ühik | Tarneks valmis kinnituskuupäev | Kinnituskp seotud muutused | Staatus ostust ja tootmisest | Staatus (logistika) | Tegelik laadimiskuupäev |  | Soovitud koormakuupäev
 | F206 | OT | 206/1 | [NAME] [NAME] | JL1.5 | 2017-12-08 00:00:00 | 2017-12-10 00:00:00 | 1602 | J.J | - | 1500 | tk | 2017-12-13 00:00:00 | 15.12.2017 - uus kinnituskp Anna | Ootel | Tarneks valmis
 | F206 | OT | 206/3 | Kips | 1500A | 2017-12-09 00:00:00 | 2017-12-20 00:00:00 | Objekt | J.J | [NAME] | 100 | m2 | 2017-12-19 00:00:00 | 0 | Ootel | 0
 | F206 | OO | 206/2 | ZN 3,0[NAME] | JL1.5 | 2017-12-09 00:00:00 | 2017-12-11 00:00:00 | Objekt | J.J | - | 5 | m2 | 2017-12-14 00:00:00 | 0 | Päringus | 0
 | F0148 | TT | 148/1 | Kübar R=150 | JL1.5 | 2017-12-10 00:00:00 | 2017-12-12 00:00:00 | Objekt | J.J | - | 120 | jm | 2017-12-16 00:00:00 | 17.12.2017 - kinnituskp muudetud | Tarneks valmis | Tarneks valmis
 | F0148 | OO | 148/3 | Proov | Proov | 2017-12-11 00:00:00 | 2017-12-15 00:00:00 | Objekt | J.J | v | 35 | tk | 2017-12-26 00:00:00 | 0 | Päringus | 0
 | E219 | OT | 219/11 | Paneelid | 1200A | 2017-12-11 00:00:00 | 2017-12-15 00:00:00 | Objekt | Üks Kaks | Üks [NAME] | 35 | tk | 2017-12-25 00:00:00 | 0 | Ootel | 0
 | E219 | OO | 219/9 | Paneelid | 1200A | 2017-12-11 00:00:00 | 2017-12-15 00:00:00 | Objekt | Üks Kaks | Üks [NAME] | 35 | tk | 2017-12-24 00:00:00 | 0 | Tellitud | 0
 | F0148 | OO | 148/4 | Proov | Proov | 2017-12-11 00:00:00 | 2017-12-15 00:00:00 | Objekt | J.J | v | 35 | tk | 2017-12-26 00:00:00 | 0 | Tellitud | 0
 | E219 | TT | 219/7 | Paneelid | 1200A | 2017-12-11 00:00:00 | 2017-12-15 00:00:00 | Objekt | Üks Kaks | Üks [NAME] | 35 | tk | 2017-12-16 00:00:00 | 0 | Tarneks valmis | Tarneks valmis
 | E219 | TT | 219/10 | Paneelid | 1200A | 2017-12-11 00:00:00 | 2017-12-15 00:00:00 | Objekt | Üks Kaks | Üks [NAME] | 35 | tk | 2017-12-16 00:00:00 | 0 | Tarneks valmis | Tarnitud | 2017-12-20 00:00:00 |  | 2017-12-19 00:00:00
 | E219 | TT | 219/3 | Paneelid | 1200A | 2017-12-11 00:00:00 | 2017-12-15 00:00:00 | Objekt | Üks Kaks | Üks [NAME] | 35 | tk | 2017-12-16 00:00:00 | 0 | Tarneks valmis | Tarnitud | 2017-12-20 00:00:00 |  | 2017-12-19 00:00:00
 | E219 | OO | 219/4 | Paneelid | 1200A | 2017-12-11 00:00:00 | 2017-12-15 00:00:00 | Objekt | Üks Kaks | Üks [NAME] | 35 | tk | 2017-12-20 00:00:00 | 0 | Päringus | 0
 | E219 | OO | 219/1 | [NAME] 5,0x55 | JL1.5 | 2017-12-11 00:00:00 | 2017-12-13 00:00:00 | Objekt | J.J | - | 1500 | tk | 2017-12-15 00:00:00 | 0 | Tellitud | 0
 | E219 | OO | 219/5 | Paneelid | 1200A | 2017-12-11 00:00:00 | 2017-12-15 00:00:00 | Objekt | Üks Kaks | Üks [NAME] | 35 | tk | 2017-12-21 00:00:00 | 0 | Tellitud | 0
 | E219 | OO | 219/8 | Paneelid | 1200A | 2017-12-11 00:00:00 | 2017-12-15 00:00:00 | Objekt | Üks Kaks | Üks [NAME] | 35 | tk | 2017-12-23 00:00:00 | 0 | Päringus | 0
 | E219 | OO | 219/6 | Paneelid | 1200A | 2017-12-11 00:00:00 | 2017-12-15 00:00:00 | Objekt | Üks Kaks | Üks [NAME] | 35 | tk | 2017-12-22 00:00:00 | 0 | Ootel | 0
 | E219 | OT | 219/2 | Vineer 9mm | JL1.5 | 2017-12-12 00:00:00 | 2017-12-14 00:00:00 | 1602 | J.J | - | 15 | m2 | 2017-12-16 00:00:00 | 0 | Ootel | 0
 | F0157 | OO | 157/1 | Vineer 12mm | JL1.5 | 2017-12-13 00:00:00 | 2017-12-15 00:00:00 | Objekt | J.J | - | 12 | m2 | 2017-12-17 00:00:00 | 0 | Päringus | 0
 | F0148 | TT | 148/5 | Test | Test | 2017-12-14 00:00:00 | 2017-12-15 00:00:00 | 1602 | J.J | v | 15 | tk | 2017-12-16 00:00:00 | 0 | Tarneks valmis | Tarnitud | 2017-12-20 00:00:00 |  | 2017-12-19 00:00:00
 | E17013 | TT | 17013/1 | Kübar R=150 | JL1.5 | 2017-12-14 00:00:00 | 2017-12-16 00:00:00 | Objekt | J.J | - | 99 | tk | 2017-12-16 00:00:00 | 0 | 0 | 0
 | F0148 | OO | 148/2 | Silikoon | JL1.6 | 2017-12-14 00:00:00 | 2017-12-16 00:00:00 | Objekt | J.J | - | 100 | tk | 2017-12-18 00:00:00 | 0 | Tellitud | 0
 | F0148 | TT | 148/6 | Test1 | Test1 | 2017-12-14 00:00:00 | 2017-12-15 00:00:00 | Objekt | J.J | V | 20 | tk | 2017-12-16 00:00:00 | 0 | Tarneks valmis | Tarnitud | 2017-12-20 00:00:00 |  | 2017-12-19 00:00:00