Spreadsheet: 680521d1591074982-if-formula-with-time-function-raport-auchan-
Sheet: New loading plan

 | Transport |  |  |  |  |  | Volume  estimate |  |  | Volume reale |  |  | Volume incarcate |  |  | Procent incarcat |  |  |  | Depozit |  |  |  |  | Transport |  |  | Magazin
 | Data | Auto | Zi Livrare | [NAME] camion | Plecare | Magazin | Legume | Chilled | Frozen | Legume | Chilled | Frozen | Legume | Chilled | Frozen | [NAME] | Chilled % | [NAME] | Ora planificata | Ora sosire | Status sosire camion | Ora plecare | Ora maxima plecare | Status plecare | Durata Cursa (Timp/Hr) | Estimare sosire transport | Status sosire magazin | Ora sosire magazin | Ora maxima [NAME] | Status livrare Magazin | Ora plecare magazin | Durata receptie
 |  | B52TBL | D0 | FT | [NAME] | Militari | 31 |  |  | 38 |  |  | 32 |  |  |  |  |  |  | 14:15:00 |  | 16:40:00
 |  | B214TBL | D0 | FT | [NAME] | [NAME] | 18 |  |  | 26 | 14 |  | 26 | 7 |  |  |  |  |  | 14:20:00 |  | 18:25:00
 |  | B98WVU | D0 | FT | Crangasi | Cotroceni | 7 |  |  | 15 |  |  | 9 |  |  |  |  |  |  | 15:30:00 |  | 18:30:00 |  |  |  |  |  | 01:00:00
 |  | B98WVU | D0 | FT | [NAME] | Crangasi | 13 |  |  | 15 |  |  | 15 |  |  |  |  |  |  | 15:30:00 |  | 18:30:00
 |  | BV04DXD | D1 | FT | [NAME] | [NAME] | 26 |  |  | 22 |  |  | 22 |  |  |  |  |  |  | 15:55:00 |  | 21:30:00
 |  | BV20DXD | D1 | FT | Ploiesti | Brasov Vest | 15 |  |  | 17 |  |  | 17 |  |  |  |  |  |  | 18:00:00 |  | 23:20:00
 |  | B57TBL | D1 | ST | Crangasi | [NAME] |  | 7 |  |  | 7 |  |  | 7 |  |  |  |  |  | 23:00:00 |  | 1900-01-01 06:10:00
 |  | B57TBL | D1 | ST | [NAME] | Crangasi |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00 |  | 1900-01-01 06:10:00
 |  | B98WVU | D1 | ST | Cotroceni | Militari | 6 | 7 |  |  | 10 |  | 6 | 10 |  |  |  |  |  | 23:00:00 |  | 1900-01-01 06:00:00
 |  | B98WVU | D1 | ST | [NAME] | Cotroceni | 3 | 10 |  |  | 4 |  | 3 | 4 |  |  |  |  |  | 23:00:00 |  | 1900-01-01 06:00:00
 |  | B201TBL | D1 | ST | Brasov Vest | [NAME] |  | 8 |  |  | 8 |  |  | 8 |  |  |  |  |  | 22:00:00 |  | 1900-01-01 05:30:00
 |  | B201TBL | D1 | ST | Ploiesti | Brasov Vest |  | 5 |  |  | 5 |  |  | 5 |  |  |  |  |  | 22:00:00 |  | 1900-01-01 05:30:00 |  |  |  |  |  | 01:00:00
 |  | IL75NSF | D0 | FT | [NAME] | Militari | 16 | 8 |  | 20 | 16 |  | 20 | 12 |  |  |  |  |  | 13:00:00 |  | 16:00:00
 |  | B98WVU | D0 | FT | [NAME] | Cotroceni | 4 | 3 |  | 6 | 7 |  | 6 | 3 |  |  |  |  |  | 14:40:00 |  | 16:40:00
 |  | B27TIP | D0 | FT | [NAME] | [NAME] | 15 | 8 |  | 16 | 15 |  | 16 | 11 |  |  |  |  |  | 16:35:00 |  | 18:30:00
 |  | B52TBL | D0 | FT | [NAME] | Crangasi | 10 | 6 |  | 14 | 13 |  | 14 | 8 |  |  |  |  |  | 15:00:00 |  | 18:40:00
 |  | BV20DXD | D1 | FT | Brasov Vest | [NAME] | 9 |  |  | 11 |  |  | 11 |  |  |  |  |  |  | 13:00:00 |  | 20:45:00
 |  | BV20DXD | D1 | FT | Ploiesti | Brasov Vest | 8 |  |  | 11 |  |  | 11 |  |  |  |  |  |  | 13:00:00 |  | 20:45:00
 |  | B98WVU | D1 | ST | Cotroceni | [NAME] |  | 4 |  |  | 4 |  |  | 4 |  |  |  |  |  | 04:30:00 |  | 06:10:00
 |  | B98WVU | D1 | ST | Militari | Cotroceni |  | 3 |  |  | 3 |  |  | 3 |  |  |  |  |  | 04:30:00 |  | 06:10:00
 |  | B98WVU | D1 | ST | [NAME] | Militari |  | 8 |  |  | 8 |  |  | 8 |  |  |  |  |  | 04:30:00 |  | 06:10:00
 |  | B104DNE | D1 | ST | [NAME] | Crangasi |  | 3 |  |  | 3 |  |  | 3 |  |  |  |  |  | 05:20:00 |  | 05:40:00
 |  | [NAME] | D1 | ST | [NAME] | [NAME] |  | 5 |  |  | 10 |  |  | 10 |  |  |  |  |  | 01:30:00 |  | 03:05:00
 |  | BV30DXD | D1 | ST | [NAME] | Brasov Vest |  | 13 |  |  | 14 |  |  | 14 |  |  |  |  |  | 23:30:00 |  | 01:10:00
 |  | B57TBL | D0 | FT | [NAME] | Militari | 32 |  |  | 33 |  |  | 33 |  |  |  |  |  |  | 14:50:00 |  | 18:05:00
 |  | B52TBL | D0 | FT | [NAME] | [NAME] | 26 |  |  | 28 |  |  | 28 |  |  |  |  |  |  | 18:00:00 |  | 18:45:00
 |  | B98WVU | D0 | FT | [NAME] | Cotroceni | 8 | 4 |  | 12 | 2 |  | 12 | 2 |  |  |  |  |  | 14:30:00 |  | 18:15:00
 |  | B27TIP | D0 | FT | [NAME] | Crangasi | 13 | 6 |  | 14 | 5 |  | 14 | 5 |  |  |  |  |  | 14:30:00 |  | 19:10:00
 |  | BV86DXD | D1 | FT | [NAME] | [NAME] | 25 |  |  | 25 |  |  | 25 |  |  |  |  |  |  | 1900-01-01 01:50:00 |  | 1900-01-01 05:50:00
 |  | BV12DXD | D1 | FT | Ploiesti | Brasov Vest | 13 |  |  | 13 |  |  | 13 |  |  |  |  |  |  | 23:30:00 |  | 1900-01-01 05:00:00
 |  | B98WVU | D1 | ST | Crangasi | [NAME] |  | 14 |  |  | 14 |  |  | 14 |  |  |  |  |  | 1900-01-01 04:00:00 |  | 1900-01-01 05:50:00
 |  | B98WVU | D1 | ST | [NAME] | Militari |  | 10 |  |  | 10 |  |  | 10
 |  | BV04DXD | D1 | ST | [NAME] | Brasov Vest |  | 6 | 4 |  | 7 | 4 |  | 7 | 4 |  |  |  |  | 1900-01-01 03:00:00 |  | 1900-01-01 05:45:00
 |  | BV04DXD | D1 | ST | [NAME] | [NAME] |  | 7 | 13 |  | 8 | 13 |  | 8 | 13 |  |  |  |  | 1900-01-01 03:00:00 |  | 1900-01-01 05:45:00
 | FLOW | ESTIMAT | REALIZAT | INCARCAT | PROCENT
 | F&V
 | Chill
 | Frozen