Spreadsheet: 680524d1591077703-if-formula-with-time-function-raport-auchan-copy
Sheet: New loading plan

 | Transport |  |  |  |  |  | Estimated Volume |  |  | Real volume |  |  | Loaded Volume |  |  | Persentage loaded |  |  |  | Wearhouse |  |  |  |  | Transit time |  |  | Store
 | Data | Truck number | Day of deliveri | Truck number for each store | Departure | Destination | Vegetables | Chilled | Frozen | Vegetables | Chilled | Frozen | Vegetables | Chilled | Frozen | Vegetables % | Chilled % | [NAME] | Planned hour to load | Arrival hour to load | Status arrival truck | Departure Hour | Maximum departure hour | Status departure from the wearhouse | Time it takes to reach the store | estimated hour of arrival at the store | Status arrival at the store | Real hour of arrival at the store | Maximum hour to reach the store | Status arrival at the store | Hour of departure from the store | reception duration
 | 2020-06-02 00:00:00 | B52TBL | D0 | FT | [NAME] | Militari |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:15:00 |  | 16:40:00
 | 2020-06-02 00:00:00 | B214TBL | D0 | FT | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:20:00 |  | 18:25:00
 | 2020-06-02 00:00:00 | B98WVU | D0 | FT | Crangasi | Cotroceni |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 |  | 18:30:00 |  |  |  |  |  | 01:00:00
 | 2020-06-02 00:00:00 | B98WVU | D0 | FT | [NAME] | Crangasi |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 |  | 18:30:00
 | 2020-06-02 00:00:00 | BV04DXD | D1 | FT | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:55:00 |  | 21:30:00
 | 2020-06-02 00:00:00 | BV20DXD | D1 | FT | Ploiesti | Brasov Vest |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00 |  | 23:20:00
 | 2020-06-02 00:00:00 | B57TBL | D1 | ST | Crangasi | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00 |  | 1900-01-01 06:10:00
 | 2020-06-02 00:00:00 | B57TBL | D1 | ST | [NAME] | Crangasi |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00 |  | 1900-01-01 06:10:00
 | 2020-06-02 00:00:00 | B98WVU | D1 | ST | Cotroceni | Militari |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00 |  | 1900-01-01 06:00:00
 | 2020-06-02 00:00:00 | B98WVU | D1 | ST | [NAME] | Cotroceni |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00 |  | 1900-01-01 06:00:00
 | 2020-06-02 00:00:00 | B201TBL | D1 | ST | Brasov Vest | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 |  | 1900-01-01 05:30:00
 | 2020-06-02 00:00:00 | B201TBL | D1 | ST | Ploiesti | Brasov Vest |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 |  | 1900-01-01 05:30:00 |  |  |  |  |  | 01:00:00
 | 2020-06-02 00:00:00 | IL75NSF | D0 | FT | [NAME] | Militari |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00 |  | 16:00:00
 | 2020-06-02 00:00:00 | B98WVU | D0 | FT | [NAME] | Cotroceni |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:40:00 |  | 16:40:00
 | 2020-06-02 00:00:00 | B27TIP | D0 | FT | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:35:00 |  | 18:30:00
 | 2020-06-02 00:00:00 | B52TBL | D0 | FT | [NAME] | Crangasi |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 |  | 18:40:00
 | 2020-06-02 00:00:00 | BV20DXD | D1 | FT | Brasov Vest | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00 |  | 20:45:00
 | 2020-06-02 00:00:00 | BV20DXD | D1 | FT | Ploiesti | Brasov Vest |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00 |  | 20:45:00
 | 2020-06-02 00:00:00 | B98WVU | D1 | ST | Cotroceni | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:30:00 |  | 06:10:00
 | 2020-06-02 00:00:00 | B98WVU | D1 | ST | Militari | Cotroceni |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:30:00 |  | 06:10:00
 | 2020-06-02 00:00:00 | B98WVU | D1 | ST | [NAME] | Militari |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:30:00 |  | 06:10:00
 | 2020-06-02 00:00:00 | B104DNE | D1 | ST | [NAME] | Crangasi |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:20:00 |  | 05:40:00
 | 2020-06-02 00:00:00 | [NAME] | D1 | ST |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:30:00 |  | 03:05:00
 | 2020-06-02 00:00:00 | BV30DXD | D1 | ST |  | Brasov Vest |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:30:00 |  | 01:10:00
 | 2020-06-02 00:00:00 | B57TBL | D0 | FT | [NAME] | Militari |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:50:00 |  | 18:05:00
 | 2020-06-02 00:00:00 | B52TBL | D0 | FT | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00 |  | 18:45:00
 | 2020-06-02 00:00:00 | B98WVU | D0 | FT | [NAME] | Cotroceni |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:30:00 |  | 18:15:00
 | 2020-06-02 00:00:00 | B27TIP | D0 | FT | [NAME] | Crangasi |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:30:00 |  | 19:10:00
 | 2020-06-02 00:00:00 | BV86DXD | D1 | FT | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 01:50:00 |  | 1900-01-01 05:50:00
 | 2020-06-02 00:00:00 | BV12DXD | D1 | FT | Ploiesti | Brasov Vest |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:30:00 |  | 1900-01-01 05:00:00
 | 2020-06-02 00:00:00 | B98WVU | D1 | ST | Crangasi | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 04:00:00 |  | 1900-01-01 05:50:00
 | 2020-06-02 00:00:00 |  | D1 | ST | [NAME] | Militari
 | 2020-06-02 00:00:00 | BV04DXD | D1 | ST | [NAME] | Brasov Vest |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 03:00:00 |  | 1900-01-01 05:45:00
 | 2020-06-02 00:00:00 | BV04DXD | D1 | ST | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 03:00:00 |  | 1900-01-01 05:45:00
 | 2020-06-02 00:00:00
 | 2020-06-02 00:00:00
 | 2020-06-02 00:00:00
 | FLOW | ESTIMAT | REALIZAT | INCARCAT | PROCENT
 | F&V
 | Chill
 | Frozen