Ctrl+K
Great Start , nice setup.. Now maintain this build , and add two More pages. 1. Ai training and management, 2. The DeepCAL, a Powerful Freight Analyser (Logistics Calculator), that has shipping components and allows users to add and analyze more freight forwarder , it uses the engine the algorim to run it - Follow Up Deployment
bbc7de7
verified
-
1.52 kB
initial commit
-
205 Bytes
Develop a powerful talking and symbolically strong, the best ever seen. The In-App base data, see here: date_of_greenlight_to_pickup date_of_collection request_reference cargo_description item_category origin_country origin_latitude origin_longitude destination_country destination_latitude destination_longitude carrier freight_carrier+cost kuehne_nagel scan_global_logistics dhl_express dhl_global bwosi agl siginon frieght_in_time weight_kg volume_cbm initial_quote_awarded final_quote_awarded_freight_forwader_Carrier comments date_of_arrival_destination delivery_status mode_of_shipment 11-Jan-24 SR_24-001_NBO hub_Zimbabwe Cholera kits and Tents Emergency Health Kits Kenya 36.990054 1.2404475 Zimbabwe 31.08848075 -17.80269125 Kenya Airways 18,681 18,681 0 0 0 0 0 0 0 7,352.98 24.68 Kuehne Nagel Kenya Airways Kenya Airways via Kuehne Nagel 17-Jan-24 Delivered Air 11-Jan-24 SR_24-002_NBO hub_Zambia_(SR_23-144) Cholera kitsORSBody bagsMasks and Glucometers Emergency Health Kits Kenya 36.990054 1.2404475 Zambia 28.3174378 15.4136414 Kenya Airways 35,000 59,500 0 0 0 0 0 0 29,972 14,397.00 50.88 Kuehne Nagel Kenya Airways Kenya Airways via Kuehne Nagel 01-Dec-24 Delivered Air 02-Feb-24 SR_24-004_NBO hub_Zambia Tents GlovesPPEs and Drugs Field Support Material Kenya 36.990054 1.2404475 Zambia 28.3174378 15.4136414 Kenya Airways 56,800 0 0 0 0 0 0 0 0 10,168.00 59.02 KQ:Direct charter KQ:Direct charter KQ:Direct charter 02-Jun-24 Delivered Air 02-Feb-24 SR_24-005A_NBO hub_Zimbabwe Cholera kits TentsBody bags and Gowns Emergency Health Kits Kenya 36.990054 1.2404475 Zimbabwe 31.08848075 -17.80269125 Other Agents 0 0 0 0 0 0 0 0 0 9,087.24 44.97 KQ:Direct charter KQ:Direct charter KQ:Direct charter 02-Jun-24 Delivered Air 02-Feb-24 SR_24-005_NBO hub_Zimbabwe Cholera kits TentsBody bags and Gowns Emergency Health Kits Kenya 36.990054 1.2404475 Zimbabwe 31.08848075 -17.80269125 Other Agents 0 0 0 0 0 0 0 0 0 30 0.25 KQ:Direct charter KQ:Direct charter KQ:Direct charter 02-Jun-24 Delivered Air 03-Feb-24 SR_24-005B_NBO hub_Zimbabwe Cholera kits and Tents Emergency Health Kits Kenya 36.990054 1.2404475 Zimbabwe 31.08848075 -17.80269125 Kenya Airways 9,115 0 0 0 0 0 0 0 8,694 3,506.00 12.17 Kuehne Nagel Kenya Airways Kenya Airways via Kuehne Nagel 02-May-24 Delivered Air 08-Feb-24 SR_24-008_NBO hub_Madagascar Laboratory Items Lab & Diagnostics Kenya 36.990054 1.2404475 Madagascar 47.50866443 -14.71204234 Kenya Airways 466 466 1,029 0 0 0 0 0 574 179.33 2.71 Kuehne Nagel Kenya Airways Kenya Airways via Kuehne Nagel 02-Sept-24 Delivered Air 15-Feb-24 SR_24-011_NBO hub_Comoros Laboratory itemsKit Cholera and Sprayers Lab & Diagnostics Kenya 36.990054 1.2404475 Comoros 43.2413774 11.7209701 Kenya Airways 3,480.00 679 781 0 0 0 0 0 521 1,289.00 5.93 Freight in Time Kenya Airways Kenya Airways via Freight in Time 16-Feb-24 Delivered Air 19-Feb-24 SR_24-012_NBO hub_South Sudan KIT MAJOR TRAUMA backpack Wellbeing Kenya 36.990054 1.2404475 South Sudan 29.69490516 7.86237248 Kenya Airways 308 248 668 0 0 0 0 0 261 126 0.57 Kuehne Nagel Kenya Airways Kenya Airways 20-Feb-24 Delivered Air 23-Feb-24 SR_24-016_NBO hub_Mayotte Cholera RDTs Lab & Diagnostics Kenya 36.990054 1.2404475 Mayotte 45.1557827 -12.80654985 Other Agents 0 323 511 0 0 0 0 0 527 16.9 0.17 Kuehne Nagel Kuehne Nagel Kuehne Nagel 27-Feb-24 Delivered Air 28-Feb-24 SR_24-017_NBI hub_Mauritius Mosquito Nets Repellant and Masks Field Support Material Kenya 36.990054 1.2404475 Mauritius 59.0191111 15.42579385 Other Agents 0 0 0 0 0 0 0 0 10,867 3,377.04 12.73 Freight In Time Freight In Time Freight In Time 03-Jan-24 Delivered Air 11-Mar-24 SR_24-014_NBO hub_Ethiopia (IEHK 2017 SUPPLEMENTARY) MODULE MALARIA Emergency Health Kits Kenya 36.990054 1.2404475 Ethiopia 38.7675998 9.0146129 Other Agents 0 14,853 15,098 0 0 0 0 0 12,148 3,365.00 17.35 Freight In Time Freight In Time Freight In Time 16-Mar-24 Delivered Air 12-Mar-24 SR_24-020_NBO hub_Congo Brazzaville RDT Covid 19 Kits Lab & Diagnostics Kenya 36.990054 1.2404475 Congo Brazzaville 15.26485068 4.2809844 Other Agents 0 573 586 0 0 0 0 0 633 178 0.23 Kuehne Nagel Kuehne Nagel Kuehne Nagel 16-Mar-24 Delivered Air 06-Mar-24 SR_24-018_NBO hub_Malawi TMDs Cold Chain Equipment Kenya 36.990054 1.2404475 Malawi 33.7929271 -13.9622973 Other Agents 0 0 0 50 0 0 0 0 0 0.04 0 Kuehne Nagel Kuehne Nagel Kuehne Nagel 03-Nov-24 Delivered Air 16-Mar-24 SR_24-024_NBO hub_Burundi IEHK Kits and Tents Emergency Health Kits Kenya 36.990054 1.2404475 Burundi 29.3731839 -3.3806734 Other Agents 0 0 4,828 0 0 0 0 0 3,616 1,561.75 6.61 Freight In Time Freight In Time Freight In Time 23-Mar-24 Delivered Air 15-Mar-24 SR_24-021_NBO hub_Mauritius Mosquito Repellant and Masks Field Support Material Kenya 36.990054 1.2404475 Mauritius 59.0191111 15.42579385 Kenya Airways 6,349.20 7,512 0 0 0 0 0 0 10,867 2,886.00 7.64 Kuehne Nagel Kuehne Nagel Kuehne Nagel 17-Mar-24 Delivered Air 20-Mar-24 SR_24-025_NBO hub_Senegal Hub TMDs & Radio Motorola Cold Chain Equipment Kenya 36.990054 1.2404475 Senegal -17.51361271 14.74267265 Other Agents 0 0 0 0 0 0 0 0 1,257 17.92 0.09 Freight In Time Freight In Time Freight In Time 22-Mar-24 Delivered Air 17-Apr-24 SR_24-030_NBO hub_Congo Kinshasa RDT COVID-19 Kits Lab & Diagnostics Kenya 36.990054 1.2404475 Congo Kinshasa 27.4727998 11.6564198 Other Agents 0 1,452 2,324 0 0 0 0 0 2,004 388 2.93 Kuehne Nagel Kuehne Nagel Kuehne Nagel 19-Apr-24 Delivered Air 22-Apr-24 SR_24-031_NBO hub_Zimbabwe Boots Cholera kitsBody bags and Sprayers PPE Kenya 36.990054 1.2404475 Zimbabwe 31.08848075 -17.80269125 Kenya Airways 4,397.84 6,395 6,775 0 0 0 0 0 5,615 1,448.73 10.2 Freight In Time Freight In Time Freight In Time 26-Apr-24 Delivered Air 23-Apr-24 SR_24-027_NBO hub_Zambia Cholera kits IEHK Kits and Tents Emergency Health Kits Kenya 36.990054 1.2404475 Zambia 28.3174378 15.4136414 Kenya Airways 27,307.00 30,803 27,965 0 0 0 0 0 33,498 10,113.91 40.67 Kuehne Nagel Kuehne Nagel Kuehne Nagel 05-Mar-24 Delivered Air 06-May-24 SR_24-029_NBO hub_Madagascar IEHK KitsKit PED-SAMCholera kits and Tents Emergency Health Kits Kenya 36.990054 1.2404475 Madagascar 47.50866443 -14.71204234 Kenya Airways 46,250.00 50,943 41,185 0 0 0 0 0 74,431 14,250.50 54.18 Scan Global Scan Global Scan Global 14-May-24 Delivered Air 02-May-24 SR_24-035_NBO hub_Comoros Cholera kitsORSTentsKIT TRAUMA (IFAK) and Visibility Items Emergency Health Kits Kenya 36.990054 1.2404475 Comoros 43.2413774 11.7209701 Kenya Airways 32,116.00 0 0 0 0 0 0 0 25,770 9,618.95 46.33 Freight In Time Freight In Time Freight In Time 05-Aug-24 Delivered Air 14-May-24 SR_24-033_NBO hub_Burundi Tents Field Support Material Kenya 36.990054 1.2404475 Burundi 29.3731839 -3.3806734 Other Agents 0 3,948 5,496 0 0 0 0 0 4,933 1,856.00 13.1 Freight In Time Freight In Time Freight In Time 30-May-24 Delivered Air 28-May-24 SR_24-038_NBO hub_Guinea Conakry Kits and PPEs Emergency Health Kits Kenya 36.990054 1.2404475 Guinea 13.683989 8.40829457 Other Agents 0 2,383 9,588 3,887 0 0 0 0 2,238 341 1.33 Freight In Time Freight In Time Freight In Time 31-May-24 Delivered Air 04-Jun-24 SR_24-043_NBO hub_Benin RDT Covid-19 Kits Lab & Diagnostics Kenya 36.990054 1.2404475 Benin 9.30733826 2.30941937 Other Agents 0 518 0 540 0 0 0 0 0 33 0.22 DHL Express DHL Express DHL Express 06-Oct-24 Delivered Air 14-Jun-24 SR_24-041_NBO hub_Zimbabwe Kit Cholera Hardware and Tents Emergency Health Kits Kenya 36.990054 1.2404475 Zimbabwe 31.08848075 -17.80269125 Other Agents 0 8,505 7,445 0 0 0 12,570 0 9,742 6,640.00 31.51 AGL AGL AGL 25-Jul-24 Delivered Sea 02-Jul-24 SR_24-047_NBO hub_Burundi Tents Field Support Material Kenya 36.990054 1.2404475 Burundi 29.3731839 -3.3806734 Other Agents 0 5,478 4,411 0 0 0 4,246 0 4,117 1,604.00 6.68 Freight In Time Freight In Time Freight In Time 07-Oct-24 Delivered Air 08-Jul-24 SR_24-049_NBO hub_Zimbabwe ORSINFUSION SET AND MEDICINES Pharmarceuticals Kenya 36.990054 1.2404475 Zimbabwe 31.08848075 -17.80269125 Other Agents 0 10,446 10,285 0 0 0 0 0 9,233 3,417.00 8.69 Freight In Time Freight In Time Freight In Time 15-Jul-24 Delivered Air 05-Jul-24 SR_24-050_NBO hub_Chad RDT Covid 19 Kits Lab & Diagnostics Kenya 36.990054 1.2404475 Chad 14.984082 12.128668 Other Agents 0 0 3,703 4,739 0 0 0 0 3,815 412 2.64 Scan Global Scan Global Scan Global Delivered Air 18-Jul-24 SR_24-059_NBI hub_GUINEA BISSAU RDT Covid 19 Kits Lab & Diagnostics Kenya 36.990054 1.2404475 Guinea Bissau 15.5843227 11.8632196 Other Agents 0 0 0 942 0 0 0 0 0 88 0.58 DHL Express DHL Express DHL Express 30-Jul-24 Delivered Air 22-Jul-24 SR_24-060_NBO hub_Chad TESK KITS Emergency Health Kits Kenya 36.990054 1.2404475 Chad 14.984082 12.128668 Other Agents 0 0 0 0 0 0 0 0 11,706 2,663.75 9.61 Freight In Time Freight In Time Freight In Time 25-Jul-24 Delivered Air 23-Jul-24 SR_24-053_NBO hub_Chad Kit cholera laboratory Lab & Diagnostics Kenya 36.990054 1.2404475 Chad 14.984082 12.128668 Other Agents 0 750 744 0 0 0 0 0 0 35.27 0.3 Kuehne Nagel Kuehne Nagel Kuehne Nagel 27-Jul-24 Delivered Air 23-Jul-24 SR_24-054_NBO hub_Togo TESK KIT Emergency Health Kits Kenya 36.990054 1.2404475 Togo 8.61028306 0.83263997 Other Agents 0 0 0 1,775 0 0 0 0 0 13 0.13 DHL Express DHL Express DHL Express 31-Jul-24 Delivered Air 24-Jul-24 SR_24-051_NBO hub_Madagascar IEHKTESK Kits and assorted Items Emergency Health Kits Kenya 36.990054 1.2404475 Madagascar 47.50866443 -14.71204234 Kenya Airways 3,131 4,470 0 0 0 0 0 3,575 1230 7.47 Kuehne Nagel Kuehne Nagel Kuehne Nagel 08-Mar-24 Delivered Air 06-Aug-24 SR_24-061_NBO hub_DR Congo Cold chain Items and Goggles Emergency Health Kits Kenya 36.990054 1.2404475 DR Congo 15.2726097 4.3161726 Other Agents 0 3,425 3,990 0 0 0 0 0 4,438 267.24 6.01 Kuehne Nagel Kuehne Nagel Kuehne Nagel 08-Aug-24 Delivered Air 09-Aug-24 SR_24-048_NBO hub_Ethiopia Cholera kitsORS and Ringer Lactate Emergency Health Kits Kenya 36.990054 1.2404475 Ethiopia 38.7675998 9.0146129 Other Agents 0 98,758 140,909 0 0 0 0 0 105,531 48,092.00 134.06 Freight In Time Freight In Time Freight In Time 15-Aug-24 Delivered Air 22-Aug-24 SR_24-065_NBO hub_Cote d'lvoire PPEs PPE Kenya 36.990054 1.2404475 Cote d'lvoire 5.3835193 3.9929962 Other Agents 0 762 0 0 0 0 0 0 897 32 0.27 Kuehne Nagel Kuehne Nagel Kuehne Nagel 24-Aug-24 Delivered Air 22-Aug-24 SR_24-064_NBO hub_Central Africa Republic PPEs PPE Kenya 36.990054 1.2404475 Central Africa Republic 18.5773703 4.3720473 Other Agents 0 8,345 7,997 0 0 0 0 0 0 1,666.00 6.41 Kuehne Nagel Kuehne Nagel Kuehne Nagel 27-Sept-24 Delivered Air 02-Sept-24 SR_24-068_NBO hub_Comoros Cholera Laboratory and Investigation kits Emergency Health Kits Kenya 36.990054 1.2404475 Comoros 43.2413774 11.7209701 Other Agents 0 966 0 0 0 0 0 0 1,227 56.22 0.46 Kuehne Nagel Kuehne Nagel Kuehne Nagel 09-Jul-24 Delivered Air 05-Sept-24 SR_24-070_NBO hub_Togo OXYGEN ANALYSER Biomedical Equipments Kenya 36.990054 1.2404475 Togo 8.61028306 0.83263997 Other Agents 0 563 0 0 0 0 0 0 682 8.66 0.07 Kuehne Nagel Kuehne Nagel Kuehne Nagel 16-Sept-24 Delivered Air 05-Sept-24 SR_24-072_NBO hub_Burundi FREEZER Cold Chain Equipment Kenya 36.990054 1.2404475 Burundi 29.3731839 -3.3806734 Other Agents 0 0 2,723 0 0 0 0 0 2,028 664 1.82 Freight In Time Freight In Time Freight In Time 13-Sept-24 Delivered Air 05-Sept-24 SR_24-071_NBO hub_DR Congo ORSRinger lactate and PPEs Pharmarceuticals Kenya 36.990054 1.2404475 DR Congo 15.2726097 4.3161726 Other Agents 0 65,393 0 0 0 0 0 0 62,010 14,500.00 75 Kuehne Nagel Kuehne Nagel Kuehne Nagel 09-Jul-24 Delivered Air 16-Sept-24 SR_24-074_NBO hub_Sudan Cholera Laboratory and RDT kits Emergency Health Kits Kenya 36.990054 1.2404475 Sudan 30.25399485 15.69090937 Other Agents 0 0 0 0 0 0 0 0 0 33.9 0.22 UNHAS UNHAS UNHAS 19-Sept-24 Delivered Air 24-Sept-24 SR_24-081_NBO hub_Burundi MPOX supplies Emergency Health Kits Kenya 36.990054 1.2404475 Burundi 29.3731839 -3.3806734 Other Agents 0 0 0 0 0 0 0 0 0 29 0.28 Mary Nzemya Mary Nzemya Hand carried 25-Sept-24 Delivered Air 30-Sept-24 SR_24-088_NBO hub_Rwanda PPEs PPE Kenya 36.990054 1.2404475 Rwanda 29.88043595 -1.94365675 Other Agents 0 2,139 0 0 0 0 0 0 3,300 664 7.53 Kuehne Nagel Kuehne Nagel Kuehne Nagel 10-Jan-24 Delivered Air 03-Oct-24 SR_24-086_NBO hub_Comoros Tents and Cholera kits Field Support Material Kenya 36.990054 1.2404475 Comoros 43.2413774 11.7209701 Other Agents 0 29,032 26,627 0 0 0 0 0 26,107 10,202.00 44.13 Freight in time Freight in time Freight in time 10-Dec-24 Delivered Air 02-Oct-24 SR_24-089_NBO hub_Uganda Vests Visibility Kenya 36.990054 1.2404475 Uganda 32.3032312 1.36815764 Other Agents 0 0 0 59 0 0 0 0 0 2.4 0 DHL Express DHL Express DHL Express 10-Mar-24 Delivered Air 03-Oct-24 SR_24-082_NBO hub_Burundi Ringer lactate ORS and PPEs Pharmarceuticals Kenya 36.990054 1.2404475 Burundi 29.3731839 -3.3806734 Other Agents 0 1,720 2,951 4,377 0 0 0 0 2,494 722.34 3.28 Kuehne Nagel Kuehne Nagel Kuehne Nagel 10-May-24 Delivered Air 07-Oct-24 SR_24-093_NBO hub_Rwanda PPEs and Antifog PPE Kenya 36.990054 1.2404475 Rwanda 29.88043595 -1.94365675 Other Agents 0 26,518 0 0 0 0 0 0 22,794 7,445.00 45.65 Freight In time Freight In time Freight In time 10-Oct-24 Delivered Air 07-Oct-24 SR_24-094_NBO hub_Rwanda Thermometers Piccolo and Glove Box Biomedical Equipments Kenya 36.990054 1.2404475 Rwanda 29.88043595 -1.94365675 Other Agents 0 0 0 0 0 0 0 0 0 180 1.52 Freight In time Freight In time Freight In time 10-Oct-24 Delivered Air 10-May-24 SR_24-095_NBO hub_Rwanda Marburg Emergency Health Kits Kenya 36.990054 1.2404475 Rwanda 29.88043595 -1.94365675 Other Agents 0 1,240 0 0 0 0 0 0 1,576 369 1.72 Kuehne Nagel Kuehne Nagel Kuehne Nagel 16-Oct-24 Delivered Air 14-Oct-24 SR_24-097_NBO hub_Burundi Tents Field Support Material Kenya 36.990054 1.2404475 Burundi 29.3731839 -3.3806734 Other Agents 0 2,297 0 0 0 0 0 0 2,541 1,051.00 4.33 Freight In Time Freight In Time Freight In Time 26-Oct-24 Delivered Air 14-Oct-24 SR_24-098_NBO hub_Rwanda Viral RNA kits Lab & Diagnostics Kenya 36.990054 1.2404475 Rwanda 29.88043595 -1.94365675 Other Agents 0 0 0 286 0 0 0 0 811 22.54 0.21 Freight in Time Freight in Time Freight in Time 24-Oct-24 Delivered Air 16-Oct-24 SR_24-099_NBO hub_Burundi Fuel Dispenser Field Support Material Kenya 36.990054 1.2404475 Burundi 29.3731839 -3.3806734 Other Agents 0 1,177 0 0 0 0 0 0 1,619 283 0.99 Freight In Time Freight In Time Freight In Time 11-Jan-24 Delivered Air 18-Oct-24 SR_24-100_NBO hub_Uganda DEFIBRILLATORS Biomedical Equipments Kenya 36.990054 1.2404475 Uganda 32.3032312 1.36815764 Other Agents 0 354 0 822 0 0 0 0 654 51.18 0.46 Kuehne Nagel Kuehne Nagel Kuehne Nagel 24-Oct-24 Delivered Air 22-Oct-24 SR_24-101_NBO Hub_Rwanda Mpox supplies Emergency Health Kits Kenya 36.990054 1.2404475 Rwanda 29.88043595 -1.94365675 Other Agents 0 454 0 0 0 0 0 0 0 57.16 0.32 Kuehne Nagel Kuehne Nagel Kuehne Nagel 26-Oct-24 Delivered Air 22-Oct-24 SR_24-102_NBO hub_Uganda Mpox supplies Emergency Health Kits Kenya 36.990054 1.2404475 Uganda 32.3032312 1.36815764 Other Agents 0 403 0 0 0 0 0 0 0 57.16 0.32 Kuehne Nagel Kuehne Nagel Kuehne Nagel 26-Oct-24 Delivered Air 22-Oct-24 SR_24-103_NBO Hub_Burundi Mpox supplies Emergency Health Kits Kenya 36.990054 1.2404475 Burundi 29.3731839 -3.3806734 Other Agents 0 395 0 0 0 0 0 0 0 52.9 0.3 Kuehne Nagel Kuehne Nagel Kuehne Nagel 26-Oct-24 Delivered Air 23-Oct-24 SR_24-104_NBO hub_Malawi Mpox supplies Emergency Health Kits Kenya 36.990054 1.2404475 Malawi 33.7929271 -13.9622973 Other Agents 0 373 0 0 0 0 0 0 0 20.62 0.14 Kuehne Nagel Kuehne Nagel Kuehne Nagel 26-Oct-24 Delivered Air 23-Oct-24 SR_24-105_NBO hub_Rwanda Vests Visibility Kenya 36.990054 1.2404475 Rwanda 29.88043595 -1.94365675 Other Agents 0 340 0 0 0 0 0 0 583 27 0.14 Kuehne Nagel Kuehne Nagel Kuehne Nagel 29-Oct-24 Delivered Air 23-Oct-24 SR_24-106_NBO hub_Rwanda Feezer Aucma Cold Chain Equipment Kenya 36.990054 1.2404475 Rwanda 29.88043595 -1.94365675 Other Agents 0 729 971 0 0 0 0 0 865 92 1.01 Freight in Time Freight in Time Freight in Time 11-Feb-24 Delivered Air 23-Oct-24 SR_24-109_NBO hub_Comoros Mpox supplies Emergency Health Kits Kenya 36.990054 1.2404475 Comoros 43.2413774 11.7209701 Other Agents 0 356 0 0 0 0 0 0 0 10.92 0.08 Kuehne Nagel Kuehne Nagel Kuehne Nagel 11-Jul-24 Delivered Air 31-Oct-24 SR_24-110_NBO hub_Madagascar Mpox supplies Emergency Health Kits Kenya 36.990054 1.2404475 Madagascar 47.50866443 -14.71204234 Other Agents 0 396 0 0 0 0 0 0 0 20.62 0.14 Kuehne Nagel Kuehne Nagel Kuehne Nagel 11-Jun-24 Delivered Air 11-Jan-24 SR_24-112_NBO hub_Benin Mpox supplies Emergency Health Kits Kenya 36.990054 1.2404475 Benin 9.30733826 2.30941937 Other Agents 0 492 0 0 0 0 0 0 0 19.36 3.21 Kuehne Nagel Kuehne Nagel Kuehne Nagel 11-Oct-24 Delivered Air 11-May-24 SR_24-115_NBO hub_Ghana Mpox supplies Emergency Health Kits Kenya 36.990054 1.2404475 Ghana 5.6128722 0.1871217 Other Agents 0 541 0 0 0 0 0 0 0 48 0.4 Kuehne Nagel Kuehne Nagel Kuehne Nagel 13-Nov-24 Delivered Air 11-May-24 SR_24-114_NBO hub_DR Congo Glove examination PPE Kenya 36.990054 1.2404475 DR Congo 15.2726097 4.3161726 Other Agents 0 4,328 0 0 0 0 0 0 0 899.84 4.1 Kuehne Nagel Kuehne Nagel Kuehne Nagel 11-Oct-24 Delivered Air 11-Nov-24 SR_24-116_NBO hub_Rwanda Extraction kits Lab & Diagnostics Kenya 36.990054 1.2404475 Rwanda 29.88043595 -1.94365675 Other Agents 0 458 395 0 0 0 0 0 633 14.89 0.21 Kuehne Nagel Kuehne Nagel Kuehne Nagel 11-Dec-24 Delivered Air 18-Nov-24 SR_24-117_NBO hub_DR Congo Mpox Emergency Health Kits Kenya 36.990054 1.2404475 DR Congo 15.2726097 4.3161726 Other Agents 0 429 0 0 0 0 0 0 0 6.03 0.03 Kuehne Nagel Kuehne Nagel Kuehne Nagel 19-Nov-24 Delivered Air 18-Nov-24 SR_24-120_NBO hub_ Rwanda Ringers Lactate Pharmarceuticals Kenya 36.990054 1.2404475 Rwanda 29.88043595 -1.94365675 Other Agents 0 6,589 5,592 0 0 0 0 0 6,318 2,330.00 5.65 Kuehne Nagel Kuehne Nagel Kuehne Nagel 19-Nov-24 Delivered Air 14-Nov-24 SR_24-119_NBO Hub_Nigeria Cold Chain Equipment Emergency Health Kits Kenya 36.990054 1.2404475 Nigeria 9.0357943 7.4647231 Other Agents 0 0 0 455 0 0 0 0 0 10 0.1 DHL Express DHL Express DHL Express 25-Nov-24 Delivered Air 26-Nov-24 SR_24-092_NBO hub_Ethiopia CholeraIEHKPEDSAM and TESK kits Emergency Health Kits Kenya 36.990054 1.2404475 Ethiopia 38.7675998 9.0146129 Other Agents 0 25,898 27,461 0 0 0 0 0 0 10,209.00 28.8 Scan Global Scan Global Scan Global 12-Mar-24 Delivered Air 18-Nov-24 SR_24-123_NBO hub_DR Congo IEHK Kits Emergency Health Kits Kenya 36.990054 1.2404475 DR Congo 15.2726097 4.3161726 Other Agents 0 6,253 7,478 0 0 0 0 0 6,787 1,865.00 10.16 Kuehne Nagel Kuehne Nagel Kuehne Nagel 22-Nov-24 Delivered Air 19-Nov-24 SR_24-134_NBO hub_Uganda Mpox Kits Emergency Health Kits Kenya 36.990054 1.2404475 Uganda 32.3032312 1.36815764 Other Agents 0 336 0 0 0 0 0 0 0 12 0.1 Kuehne Nagel Kuehne Nagel Kuehne Nagel 22-Nov-24 Delivered Air 22-Nov-24 SR_24-135_NBO hub_Eritrea Cholera RDT Lab & Diagnostics Kenya 36.990054 1.2404475 Eritrea 39.83225616 15.18756436 Other Agents 0 0 0 0 0 0 0 0 0 Mr.Ali Mr.Ali Hand Carried Delivered Air 27-Nov-24 SR_24-136_NBO hub_Burundi Ampilicilin Pharmarceuticals Kenya 36.990054 1.2404475 Burundi 29.3731839 -3.3806734 Other Agents 0 0 0 167 0 0 0 0 0 12 0.02 DHL Express DHL Express DHL Express 29-Nov-24 Delivered Air 28-Nov-24 SR_24-137_NBO hub_Malawi TESK Kits Emergency Health Kits Kenya 36.990054 1.2404475 Malawi 33.7929271 -13.9622973 Other Agents 0 13,670 13,050 0 0 0 0 8,250 0 8,646.00 35.6 Siginon Logistics Siginon Logistics Siginon Logistics 31-Dec-24 Delivered Road 03-Dec-24 SR_24-144_NBO hub_Madagascar Kits and Wash items WASH/IPC Kenya 36.990054 1.2404475 Madagascar 47.50866443 -14.71204234 Other Agents 0 13,560 11,104 0 0 0 0 0 0 4,754.00 22.5 Kuehne Nagel Kuehne Nagel Kuehne Nagel 29-Dec-24 Delivered Air 03-Dec-24 SR_24-146_NBO hub_Zimbabwe Mpox supplies Emergency Health Kits Kenya 36.990054 1.2404475 Zimbabwe 31.08848075 -17.80269125 Other Agents 0 367 0 0 0 0 0 0 0 18.42 0.2 Kuehne Nagel Kuehne Nagel Kuehne Nagel 12-Nov-24 Delivered Air 13-Dec-24 SR_24-118A_NBO hub_South Sudan Cholera Investigation and Bed Emergency Health Kits Kenya 36.990054 1.2404475 South Sudan 29.69490516 7.86237248 Other Agents 0 4,401 3,911 0 0 0 0 0 4,689 2,864.50 10.6 Scan Global Scan Global Scan Global 19-Dec-24 Delivered Road 17-Dec-24 SR_24-150_NBO hub_Zambia Cholera Lab Kits Lab & Diagnostics Kenya 36.990054 1.2404475 Zambia 28.3174378 15.4136414 Other Agents 0 412 723 0 0 0 0 0 0 41.32 0.45 Kuehne Nagel Kuehne Nagel Kuehne Nagel 08-Jan-25 Delivered Air 17-Dec-24 SR_24-151_NBO hub_Comoros Cholera and Dengue RDTs Lab & Diagnostics Kenya 36.990054 1.2404475 Comoros 43.2413774 11.7209701 Other Agents 0 678 877 0 0 0 0 0 0 149.22 0.54 Kuehne Nagel Kuehne Nagel Kuehne Nagel 24-Dec-24 Delivered Air 17-Dec-24 SR_24-126_NBO hub_Eswatini ISOTHERMAL BOX Cold Chain Equipment Kenya 36.990054 1.2404475 Eswatini 31.46277335 26.517661 Other Agents 0 5,930 0 0 0 0 0 0 4,019 316 5.85 Freight in Time Freight in Time Freight in Time 27-Dec-24 Delivered Air 20-Dec-24 SR_24-153_NBO hub_Burundi Dextrose Pharmarceuticals Kenya 36.990054 1.2404475 Burundi 29.3731839 -3.3806734 Other Agents 0 1,218 0 0 0 0 0 0 0 533 2.09 Kuehne Nagel Kuehne Nagel Kuehne Nagel 31-Dec-24 Delivered Air 31-Dec-24 SR_24-154_NBO hub_Malawi Mpox supplies and freezer Emergency Health Kits Kenya 36.990054 1.2404475 Malawi 33.7929271 -13.9622973 Other Agents 0 1,517 0 0 0 0 0 0 0 369 1.89 Kuehne Nagel Kuehne Nagel Kuehne Nagel 14-Jan-25 Delivered Air 13-Dec-24 SR_24-118B_NBO hub_South Sudan Cholera Kits and Tents Emergency Health Kits Kenya 36.990054 1.2404475 South Sudan 29.69490516 7.86237248 Other Agents 0 0 0 0 0 0 0 0 8,600 11,097.00 49.93 Freight in Time Freight in Time Freight in Time 12-Jan-25 Delivered Road 19-Nov-24 SR_24-133_NBO hub_South_Sudan Filovirus Kits Emergency Health Kits Kenya 36.990054 1.2404475 South Sudan 29.69490516 7.86237248 Other Agents 0 366 0 0 0 0 0 0 895 10.36 0.04 Kuehne Nagel Kuehne Nagel Kuehne Nagel 15-Jan-25 Delivered Air 17-Jan-25 SR_25-008_NBO hub_DR Congo PPEs PPE Kenya 36.990054 1.2404475 DR Congo 15.2726097 4.3161726 Other Agents 0 7,360 0 0 0 0 0 0 9,656 2,203.00 16.04 Kuehne Nagel Kuehne Nagel Kuehne Nagel 10-Mar-25 Delivered Air 22-Jan-25 SR_25-010_ NBO hub_Tanzania VHF Kits Lab & Diagnostics Kenya 36.990054 1.2404475 Tanzania 39.2968217 6.8122141 Other Agents 0 2,783 0 0 0 0 0 0 0 1,444.00 16.5 Kuehne Nagel Kuehne Nagel Kuehne Nagel 07-Feb-25 Delivered Air 24-Jan-25 SR_25-013_ NBO hub_Tanzania Lab PPEs Lab & Diagnostics Kenya 36.990054 1.2404475 Tanzania 39.2968217 6.8122141 Other Agents 0 1,099 0 0 0 0 0 0 0 486 2.5 Kuehne Nagel Kuehne Nagel Kuehne Nagel 28-Jan-25 Delivered Air 01-Jun-25 SR_25-001_NBO hub_Ethiopia Malaria Kits Lab & Diagnostics Kenya 36.990054 1.2404475 Ethiopia 38.7675998 9.0146129 Other Agents 0 678 877 0 0 0 0 0 0 805 7.7 Kuehne Nagel Kuehne Nagel Kuehne Nagel 31-Jan-25 Delivered Air 24-Jan-25 SR_25-014_NBO hub_Tanzania VHF Kits Lab & Diagnostics Kenya 36.990054 1.2404475 Tanzania 39.2968217 6.8122141 Other Agents 0 1,588 0 0 0 0 0 0 0 758 3.33 Kuehne Nagel Kuehne Nagel Kuehne Nagel 29-Jan-25 Delivered Air 01-Feb-25 SR_25-019_NBO hub_Uganda EVD Kits Lab & Diagnostics Kenya 36.990054 1.2404475 Uganda 32.3032312 1.36815764 Other Agents 0 2,204 0 0 0 0 0 2,204 0 1,422.96 16.48 Siginon Logistics Siginon Logistics Siginon Logistics 02-Mar-25 Delivered Air 01-Feb-25 SR_25-020_NBO hub_Uganda EVD Kits Lab & Diagnostics Kenya 36.990054 1.2404475 Uganda 32.3032312 1.36815764 Other Agents 0 2,204 0 0 0 0 0 2,204 0 1,472.26 16.97 Siginon Logistics Siginon Logistics Siginon Logistics 04-Mar-25 Delivered Air 01-Feb-25 SR_25-021_NBO hub_Uganda EVD Kits Lab & Diagnostics Kenya 36.990054 1.2404475 Uganda 32.3032312 1.36815764 Other Agents 0 2,204 0 0 0 0 0 2,204 0 1,436.58 16.58 Siginon Logistics Siginon Logistics Siginon Logistics 05-Feb-25 Delivered Air 01-Feb-25 SR_25-022_NBO hub_Uganda EVD Kits Lab & Diagnostics Kenya 36.990054 1.2404475 Uganda 32.3032312 1.36815764 Other Agents 0 2,204 0 0 0 0 0 2,204 0 1,411.78 16.57 Siginon Logistics Siginon Logistics Siginon Logistics 06-Feb-25 Delivered Air 01-Feb-25 SR_25-023_NBO hub_Uganda EVD Kits Lab & Diagnostics Kenya 36.990054 1.2404475 Uganda 32.3032312 1.36815764 Other Agents 0 2,204 0 0 0 0 0 2,204 0 1,411.78 16.57 Siginon Logistics Siginon Logistics Siginon Logistics 06-Feb-25 Delivered Air 30-Jan-25 SR_25-018_NBO hub_Sierra Leone PPEs and pharmaceuticals PPE Kenya 36.990054 1.2404475 Sierra Leone -11.83748596 8.42228531 Other Agents 0 7,350 0 0 0 0 0 0 7,936 1,965.54 9.81 Kuehne Nagel Kuehne Nagel Kuehne Nagel 18-Feb-25 Delivered Air 30-Jan-25 SR_25-017_NBO hub_DR Congo PPEs PPE Kenya 36.990054 1.2404475 DR Congo 15.2726097 4.3161726 Other Agents 0 8,552 0 0 0 0 0 0 10,648 2,566.08 17.67 Kuehne Nagel Kuehne Nagel Kuehne Nagel 14-Feb-25 Delivered Air 24-Jan-25 SR_25-015_NBO hub_Sao Tome PPEs PPE Kenya 36.990054 1.2404475 Sao Tome 6.84570896 0.24103452 Other Agents 0 0 0 307 0 0 0 0 0 11.72 0.12 DHl Express DHl Express DHl Express 25-Feb-25 Delivered Air 10-Jan-25 SR_25-026_NBO hub_Uganda Biosafety cabinets Lab & Diagnostics Kenya 36.990054 1.2404475 Uganda 32.3032312 1.36815764 Other Agents 0 590 0 0 0 0 0 0 964 191.28 1.29 Kuehne Nagel Kuehne Nagel Kuehne Nagel 11-Feb-25 Delivered Air 10-Feb-25 SR_25-025_NBO hub_Eritrea Lab supplies Lab & Diagnostics Kenya 36.990054 1.2404475 Eritrea 39.83225616 15.18756436 Other Agents 0 0 0 0 0 0 0 0 0 21.76 0.21 Nonso Nonso Hand carried 13-Feb-25 Delivered Air 05-Feb-25 SR_25-024_NBO hub_DR Congo TESKIEHK Kits and TENTS ?ÿ PPES Emergency Health Kits Kenya 36.990054 1.2404475 DR Congo 15.2726097 4.3161726 Other Agents 0 8,400 0 0 0 0 0 10,000 0 12,700.00 63.68 Siginon Logistics Siginon Logistics Siginon based on contractual history and performance 26-Feb-25 Delivered Road 24-Feb-25 SR_25-032_NBO hub_Sao Tome Remel swabs Lab & Diagnostics Kenya 36.990054 1.2404475 Sao Tome 6.84570896 0.24103452 Other Agents 0 0 0 270 0 0 0 0 0 20 0.23 DHL Express DHL Express DHL Express 12-Mar-25 Delivered Air 24-Feb-25 SR_25-031_NBO hub_Guinea Remel swabs Lab & Diagnostics Kenya 36.990054 1.2404475 Guinea 13.683989 8.40829457 Other Agents 0 0 0 270 0 0 0 0 0 20 0.23 DHL Express DHL Express DHL Express 06-Mar-25 Delivered Air 24-Feb-25 SR_25-033_NBO hub_DR Congo PPEs and Lab Supplies PPE Kenya 36.990054 1.2404475 DR Congo 15.2726097 4.3161726 Other Agents 0 798 0 0 0 0 0 0 990 192.7 0.94 Kuehne Nagel Kuehne Nagel Kuehne Nagel 06-Mar-25 Delivered Air .DeepCAL Documentation & Implementation Blueprint Version: 1.0 Date: 30 March 2025 Developed by Mostar Industries ________________________________________ Table of Contents 1. Introduction & Overview 2. PHASE 1: Data-First Protocol o 2.1 The “No Data, No Feature” Lockdown o 2.2 DeepCAL Input Layer (Strict Boot Order) o 2.3 Versioned Intake & Data Lineage 3. PHASE 2: Core Algorithm & Engine Implementation o 3.1 Data Architecture & Preprocessing o 3.2 Analytics Engine o 3.3 Decision Engine (Grey / Neutrosophic AHP-TOPSIS) o 3.4 Feedback Loop & Continuous Learning o 3.5 Training + Inference Model (CNN/RNN/Transformer) 4. PHASE 3: UI & Frontend Integration o 4.1 Algorithm-First, Then Visualization o 4.2 Suggested Next.js + Services Architecture o 4.3 DeepCAL Startup Prompt o 4.4 DeepTalk Conversational AI Layer 5. Offline-First & Edge Constraints 6. Live Tracking Integration 7. System Architecture (Consolidated) 8. Scientific Rigor & Publishability 9. DeepCAL Data Dictionary 10. Implementation Artifacts • 10.1 Python “deepcal_core.py” (Neutrosophic/Grey AHP-TOPSIS) • 10.2 SQL Schema for Supabase • 10.3 Example Supabase Edge Function • 10.4 Sample Data Refresh & Caching Strategy • 10.5 Error Handling & Fallbacks 11. Conclusion ________________________________________ 1. Introduction & Overview DeepCAL is an Intelligent Emergency Logistics Decision-Support System that optimizes humanitarian supply chains under uncertainty. It merges: • Data-First Protocol ensuring all features, charts, and decisions are locked behind verified data. • Analytics Engine generating key performance indicators (cost, transit time, disruption risk) from a shared data store. • Decision Engine employing a Grey or Neutrosophic AHP-TOPSIS approach to handle uncertain, partial, or fuzzy judgments in multi-criteria decision-making. • Conversational AI Layer (DeepTalk) that allows non-technical staff to query the system. • Offline-First architecture for low-bandwidth or remote deployment scenarios. • Feedback Loop for continuous learning, adjusting risk scores, route reliability, and forwarder performance with each shipment. DeepCAL ensures scientific rigor via a separation of concerns: 1. Data: Must be validated and versioned (no data, no feature). 2. Core Engine: The system’s algorithmic “brain” is implemented before hooking up any UI. 3. UI & Visualization: Strictly a reflection layer, connecting only once the engine is stable and tested. ________________________________________ 2. Deep 1: Data-First Protocol 2.1 The “No Data, No Feature” Lockdown “Nothing Moves Without the Core.” All features—charts, APIs, decisions—remain locked until the base dataset is loaded, validated, and version-tagged. Concretely: ts CopyEdit if (!BaseDataStore.hasSyncedFrom('deeptrack_2.csv')) { throw new Error("Base algorithmic data not loaded – system locked."); } Why? Because in emergency logistics, data completeness is crucial. We cannot produce half-baked analyses. This ensures: • No computation is performed on partial or unverified datasets. • Every chart or recommendation traces back to a validated input file or record. 2.2 DeepCAL Input Layer (Strict Boot Order) 1. Load deeptrack_2.csv (base logistic data file). 2. Validate the shape, columns, missing values, data types. 3. Initialize the global/base state (e.g., Redux, Zustand, or server memory store). 4. Boot the analytics + decision engine only after data is confirmed valid. Versioned Intake: json CopyEdit { "version": "v1.0.0-deepbase", "hash": "sha256-XYZ", "source": "deeptrack_2.csv" } Every transformed dataset references the original hash & version, ensuring lineage. 2.3 Versioned Intake & Data Lineage All data passes through a versioning pipeline: • Each CSV or JSON upload is hashed with sha256. • The system logs an entry with (version, hash, source). • Any derived dataset inherits that lineage, ensuring traceability for compliance and audits. ________________________________________ 3. Deep 2: Core Algorithm & Engine Implementation Implement the entire decision-support algorithm from scratch, ensuring we have a credible, auditable logic core. The UI is not permitted to do heavy-lift or decision logic. 3.1 Data Architecture & Preprocessing Data Flow: 1. Intake CSV or ERP feed → 2. Validation (units, missing fields, outliers) → 3. Normalization (e.g., unify weight to kg, volume to cbm, cost to USD) → 4. Computation (transit durations, distance calculations, disruptions). Supabase or a local DB (Postgres) stores: • shipments table: id, origin, destination, weight_kg, volume_cbm, cost, forwarder, etc. • forwarders table: forwarder metadata, performance stats. • routes table: route-level metrics (distance, average delay, risk factor). • criteria_weights: storing AHP or Grey/Neutrosophic weight sets, etc. 3.2 Analytics Engine Aggregates raw data into KPIs: • Average Transit Time per route/forwarder. • Cost metrics (cost per kg, cost per route). • Reliability Index (on-time performance). • Disruption/Risk (frequency of delays, cancellations). Dynamic Truck Selection: • A simple heuristic picks the smallest truck type that can handle the cargo’s weight & volume. • If new data arrives (e.g., an updated volumetric weight), it recalculates in real-time. 3.3 Decision Engine (Grey / Neutrosophic AHP-TOPSIS) Multi-Criteria Decision-Making in uncertain, real-world humanitarian ops: • Triangular Neutrosophic (or Grey) AHP to derive criterion weights under partial or uncertain judgments. • TOPSIS to rank alternatives (routes, carriers, or resource allocations) with those weights. 3.3.1 AHP with Neutrosophic or Grey Ratings • Each pairwise comparison might be expressed as a range or a fuzzy triple (T, I, F) or (Lower, Mid, Upper). • Crispify or use a “score function” e.g. Score( T, I, F ) = T – F, or a Grey range approach if minimal info is known. 3.3.2 TOPSIS Ranking 1. Construct a decision matrix of alternatives × criteria. 2. Normalize & weight by the AHP-derived vector. 3. Identify ideal and anti-ideal solutions. 4. Compute distances & closeness: Ci=Di−Di++Di−. C_i = \frac{D_i^-}{D_i^+ + D_i^-}.Ci=Di++Di−Di−. 5. Rank by CiC_iCi descending. 3.4 Feedback Loop & Continuous Learning After each shipment: • Compare actual vs. predicted performance. • Update route/forwarder reliability (if consistent underperformance, reliability is downgraded). • Adjust TNN or Grey intervals for cost/time. • Log “overrides” or new ground truth. This ensures the system self-improves as data accumulates. 3.5 Training + Inference Model (CNN/RNN/Transformer) (Optional advanced layer.) DeepCAL can incorporate a machine-learning model for forecasting disruptions or cost overruns: • CNN or RNN for time-series data (historical shipments). • Transformer for sequences with many features. Outputs: • Route-time disruption probability • Confidence of plan success • Risk of cost overrun All plugged in after the core MCDM is stable. ________________________________________ 4. PHASE 3: UI & Frontend Integration 4.1 Algorithm-First, Then Visualization UI is a “reflection layer”: • All decisions must already be computed by the engine. • No on-the-fly logic in the React (or any) front-end. • The UI calls something like getRankedAlternatives() or a RESTful endpoint returning the pre-processed results. 4.2 Suggested Next.js + Services Architecture bash CopyEdit /pages /dashboard.tsx => Visualizes data from the engine /ranking.tsx => Displays plan scores, closeness coefficients /analytics.tsx => Summaries, charts from analytics /services /deepcalEngine.ts => Core AHP + TOPSIS + learning logic /dataIntake.ts => CSV loader & validator /modelTrainer.ts => CNN/RNN training /context/global.ts => Live context store /components /DossierCard.tsx => Detailed forwarder profile /ResilienceChart.tsx => Visualization of route disruption over time 4.3 DeepCAL Startup Prompt “Build a supply chain resilience engine strictly rooted in deeptrack_2.csv and the Neutrosophic/Grey AHP-TOPSIS methodology from the doc. Do not allow any UI, predictive, or decision modules unless they derive from validated data + model. Start with data, build the engine, then expose an API for visualization. UI is reflection only.” 4.4 DeepTalk Conversational AI Layer A chat-based interface: • Intent classification (e.g., “fastest route,” “compare forwarders,” “explain ranking”). • Response generation that references actual data (transit times, risk scores). • Personality: “smart, tactical, blunt-honest,” or as configured. • Nudges user for clarifications if data is ambiguous. ________________________________________ 5. Offline-First & Edge Constraints Many humanitarian field sites have low connectivity. DeepCAL is designed so that: • In-App base data or offline storage is used; no persistent internet needed. • On-device AI & logic (no external calls for the core). • Minimal external APIs for optional weather or traffic data. • Graceful degradation if real-time feeds are unavailable (it uses historical data or best guess). • Data sync or triggers happen asynchronously when a connection is available. ________________________________________ 6. Live Tracking Integration RFID/GPS or even SMS-based tracking: • Each location or checkpoint scan updates the DB. • If an anomaly (e.g., stuck in transit for 12 extra hours) occurs, the analytics engine raises risk. • The decision engine can either alert or auto-suggest re-routing if feasible. Workflow: 1. Truck departs warehouse, triggers status = Departed. 2. Mid-route RFID scans log timestamps → if behind schedule, reliability for that route dips. 3. On arrival, system calculates actual transit time → updates route stats, forwarder performance. ________________________________________ 7. System Architecture (Consolidated) In-App Data → Firebase DB → Map → Analytics → AHP-TOPSIS → DeepTalk (UI or Chat) Key Modules: • In-App base data (json, csv) • Map (Shipment tracking, live tracking, geotagging, geolocation, geographical area) • Analytics (KPI calculations, historical stats). • Decision (Neutrosophic/Grey AHP + TOPSIS + truck assignment). • Conversational (DeepTalk AI). Modules operate in a feedback loop: 1. New shipments → analytics updates metrics → decision engine recalculates best route → user sees updated recommendation. 2. After actual performance arrives, learning adjusts the next decisions. ________________________________________ 8. Scientific Rigor & Publishability DeepCAL stands on well-known MCDM expansions: • Analytic Hierarchy Process (AHP) from Saaty. • Grey or Neutrosophic logic for partial/inconsistent data. • TOPSIS from Hwang & Yoon. We maintain consistency checks (Saaty’s CR < 0.1) for the pairwise matrix. Every numeric formula is documented & reproducible: • Crispification of TNN or Grey intervals. • Weighted normalization in TOPSIS. • Distances to ideal solutions. Hence, each recommendation is traceable, replicable, and can be published in an academic setting. The system logs both input data and final scoring, facilitating audit or peer review. ________________________________________ 9. DeepCAL Data Dictionary A quick reference for key fields used in the system: Field Data Type Description shipment_id Text Unique ID for each shipment (e.g., “SR_24-001_NBO_Zimbabwe”) – Primary Key date_of_collection Date Date cargo is picked from origin hub date_of_arrival_destination Date Actual or expected arrival date at destination origin_country Text Country/hub of origin (e.g., “Kenya”) destination_country Text Country/hub of destination (e.g., “Zimbabwe”) weight_kg Numeric Weight in kilograms volume_cbm Numeric Volume in cubic meters mode_of_shipment Text Mode (Air, Sea, Road, Rail, etc.) cost Numeric Overall cost or quote for the shipment forwarder Text Assigned freight forwarder or carrier risk_level Text Categorical risk (“Low,” “Med,” “High”) computed or updated by the engine final_quote_awarded Text Which forwarder ended up with the final contract delivery_status Text E.g., “Delivered,” “In Transit,” “Delayed” disruption_score Numeric A numeric estimate of route disruption probability criteria_weights JSON AHP or Grey/Neutrosophic weighting sets for cost, time, risk, reliability forwarders (table) - Holds each forwarder’s ID, name, average cost, reliability index, on-time rate, etc. routes (table) - Route-level data (distance, typical cost, typical time, historical incident rates) tracking_events (table) - Timestamps & statuses for real-time location tracking, used for risk adjustment ________________________________________ 10. Implementation Artifacts 10.1 Python “deepcal_core.py” (Neutrosophic/Grey AHP-TOPSIS) [Full Code—Excerpt below; see earlier consolidated reference or the “Methodology” doc section for the entire listing.] python CopyEdit import numpy as np class TNN: def __init__(self, T, I, F): self.T = float(T) self.I = float(I) self.F = float(F) def score(self): return self.T - self.F # Simple: S(N) = T - F # Build pairwise matrix from judgments, etc. # ... # Then do TOPSIS with normalizations, distances, closeness. Key Steps: 1. Build pairwise matrix from TNN or Grey ranges. 2. Crispify & compute weights (AHP). 3. Construct the decision matrix from route/forwarder data. 4. Normalize, weight, find ideal solutions (TOPSIS). 5. Calculate closeness & rank. 10.2 SQL Schema for Firebase sql CopyEdit -- shipments table CREATE TABLE shipments ( id SERIAL PRIMARY KEY, shipment_id TEXT UNIQUE NOT NULL, date_of_collection DATE NOT NULL, date_of_arrival_destination DATE, origin_country TEXT NOT NULL, destination_country TEXT NOT NULL, weight_kg NUMERIC, volume_cbm NUMERIC, mode_of_shipment TEXT, cost NUMERIC, forwarder TEXT, risk_level TEXT, final_quote_awarded TEXT, delivery_status TEXT, disruption_score NUMERIC, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- forwarders table CREATE TABLE forwarders ( id UUID PRIMARY KEY, name TEXT NOT NULL, avg_cost_per_kg NUMERIC, avg_transit_days NUMERIC, on_time_rate NUMERIC, performance_score NUMERIC, preferred BOOLEAN, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- routes table CREATE TABLE routes ( id SERIAL PRIMARY KEY, origin TEXT NOT NULL, destination TEXT NOT NULL, distance_km NUMERIC, typical_transit_days NUMERIC, disruption_probability NUMERIC, forwarder_id UUID REFERENCES forwarders(id), created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- tracking_events table CREATE TABLE tracking_events ( id SERIAL PRIMARY KEY, shipment_id TEXT REFERENCES shipments(shipment_id), event_time TIMESTAMP WITH TIME ZONE NOT NULL, location TEXT, status TEXT, raw_data JSONB, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); 10.3 Example Firebase Edge Function js CopyEdit import { serve } from "https://deno.land/[email protected]/http/server.ts"; import { createClient } from "https://esm.sh/@supabase/supabase-js@2"; const supabaseUrl = Deno.env.get("SUPABASE_URL"); const supabaseAnonKey = Deno.env.get("SUPABASE_ANON_KEY"); const supabase = createClient(supabaseUrl, supabaseAnonKey); serve(async (req) => { try { const { shipment_id } = await req.json(); if (!shipment_id) { return new Response(JSON.stringify({ error: "Missing shipment_id" }), { status: 400 }); } // Minimal example: fetch shipment, forwarder, run a simplified decision const { data: shipment, error } = await supabase .from('shipments') .select('*') .eq('shipment_id', shipment_id) .single(); if (error || !shipment) throw new Error("Shipment not found"); // Suppose we just pick the best forwarder by cost const { data: forwardersData } = await supabase .from('forwarders') .select('*'); // (In real usage, run the entire AHP-TOPSIS flow.) // For demonstration, return the forwarder with min avg_cost_per_kg const best = forwardersData.reduce((prev, curr) => (prev.avg_cost_per_kg < curr.avg_cost_per_kg) ? prev : curr ); return new Response(JSON.stringify({ recommended_forwarder: best.name, reason: "Lowest average cost" }), { status: 200 }); } catch (err) { return new Response(JSON.stringify({ error: err.message }), { status: 500 }); } }); 10.4 Sample Data Refresh & Caching Strategy • Static reference data (location coords, forwarder baseline) → refreshed daily. • Dynamic pricing or risk → refreshed every 4 hours. • Real-time tracking → updated event-driven or every 15 minutes. • Cache in memory with TTL, e.g., 240 minutes for forwarder quotes. • Invalidate or forcibly re-fetch if a user triggers a “sync” or we detect updated CSV source. 10.5 Error Handling & Fallbacks • Missing fields → 'No Quote' or large penalty in the model. • Inconsistent numeric data → auto-correct or user alert. • Default for cost if route not found → No Quote. • Default transit times if unlisted route → based on typical mode multipliers. ________________________________________ 11. Conclusion By strictly enforcing data validity (“No Data, No Feature”), building a robust multi-criteria engine (Grey/Neutrosophic AHP-TOPSIS), and layering a UI that purely reflects the verified model outputs, DeepCAL ensures: • Explainable Decisions (traceable to each row of data and each step of the algorithm). • Reproducibility (same input yields the same route/forwarder ranking). • Scientific Validity (publishable methodology, references to established MCDM expansions). • Resilience Under Audit (perfect for NGOs, field ops, or government compliance). • Plug-and-Play Intelligence (UI can be replaced or updated; the engine remains consistent). This single consolidated documentation merges all previous references—Data Architecture, Methodology (Neutrosophic AHP-TOPSIS), Implementation Blueprint—plus the new phased approach. It forms a comprehensive, end-to-end blueprint for DeepCAL deployment and usage. Next Steps? • Implement local or Firebase DB following the provided schema. • Extend the Phase 2 engine with advanced ML if required. • Build minimal front-end dashboards that merely call getRankedAlternatives() or “DeepCAL_Engine” APIs. • Deploy offline-first to field offices with large local caches. DeepCAL has been carefully and meticulously crafted by Mostar Industries and stands ready to revolutionize emergency logistics decisions with rigor, transparency, and real-time adaptability—always starting from a rock-solid data core. - Initial Deployment
-
37.8 kB
Great Start , nice setup.. Now maintain this build , and add two More pages. 1. Ai training and management, 2. The DeepCAL, a Powerful Freight Analyser (Logistics Calculator), that has shipping components and allows users to add and analyze more freight forwarder , it uses the engine the algorim to run it - Follow Up Deployment
-
46.3 kB
Great Start , nice setup.. Now maintain this build , and add two More pages. 1. Ai training and management, 2. The DeepCAL, a Powerful Freight Analyser (Logistics Calculator), that has shipping components and allows users to add and analyze more freight forwarder , it uses the engine the algorim to run it - Follow Up Deployment
-
388 Bytes
initial commit