Friday, 12 September 2014

INTRODUCTION TO EXCEL FOR LARGE DATA ANALYSIS – LOOKING AT SIMPLE/COMPLEX FORMULAS, FUNCTIONS, MACROS & VISUAL BASIC APPLICATION (VBA) PROGRAMMING


Date : 28 OCTOBER 2014 (TUESDAY)  
Venue : COMPUTER LAB 1, PERPUSTAKAAN TUN ABD RAZAK (PTAR 1), UiTM SHAH ALAM 
Time : 9.00 AM – 5.00 PM
Speaker : DR. MD. YUNUS AB. WAHAB 



* HRDF Claimable – SBL 



28 OCTOBER 2014 (TUESDAY)



TIME and PROGRAMME

8.30 am – 9.00 am : Registration / Refreshment

9.00 am – 10.00 am : Understanding Excel Spreadsheet 
: Understanding Excel Formulas and Functions  

10.00 am – 11.00 am : Understanding Excel Macros 

11.00 am – 1.00 pm : Excel Spreadsheet Visual Basic Application (VBA) and Macros Basic Editor (VBE) in Excel 

1.00 pm – 2.00 pm :  Lunch break

2.00 pm – 5.00 pm : Application of Formulas, Functions and Macros for data processing and analaysis using real large quantity data  
: Understanding data import/data export using Excel & Mail Merge
  : Q & A 
: End &  Coffee break



REGISTRATION FORM

1) TITLE :  

2) FULL NAME :

3) ADDRESS :

 4) E-MAIL      :

 5) PHONE :

 6) ORGANIZATION/FACULTY

 7) DESIGNATION :



*Registration is confirmed when participant submit or send in this Registration Form to the organizer.

Fee/Payment Method:

1) Crossed Cheque /Local Order (L.O)/ Bank draft/ Money Order to:

 Name : BENDAHARI UITM
 Address : Malaysia Institute of Transport (MITRANS)
   : Universiti Teknologi MARA
   : 40450 Shah Alam
   : SELANGOR DARUL EHSAN

2) Cash Deposit/ Transfer online to:

Account Name : BENDAHARI UITM
No. Acc. : 105140003422
Bank Name : AFFIN BANK BERHAD


* Email the Receipt to:  baizah@salam.uitm.edu.my or norzaihan938@salam.uitm.edu.my 

Subject : Fee For INTRO TO EXCEL FOR LARGE DATA ANALYSIS – LOOKING AT SIMPLE/COMPLEX FORMULAS, FUNCTIONS, MACROS & VBA PROGRAMMING

*Cancellations: Cancellation must notify in writing. 50% of the registration fee will be charged for cancellation made less than three (3) working days. Cancellation within 24 hours will be charged at 100% of the registration. We regret that cancellation cannot be accepted thereafter. The organizer reserves the right to make any amendments, cancel and/or change the programme, speaker, date or venue should circumstances beyond our control arise. We shall inform the participant(s) if any changes arise.
MITRANS must receive your registrations via fax OR email, not later than 10 OCTOBER 2014 in order to make a reservation.

Monday, 8 September 2014

MAI-Lafarge Automotive and Logistics Exhibition, 5-7 September 2014, MATRADE, Kuala Lumpur

MITRANS was provided an opportunity to set up its booth at this trade fair and we accepted the opportunity with glee. The gave us a chance to promote the consultancy, research, training and education services in our portfolio for transport and logistics. It also gave us a chance to distribute questionnaires on a proposed mixed mode master's programme and halal certificate programme which should tell us how the industry feels about the new 'products'.


Here are pictures of the busy bees of MITRANS, hard at work promoting the Institute and meeting new customers:

















































Thursday, 4 September 2014

Green Logistics and Eco-Driving Workshop, Shah Alam Convention Centre (SACC), 4 September 2014

This is a pilot programme which was conducted by Green Logistics Guru, Prof Ir Ruslan Hassan FASc., FASCE, FIEM (Senior Research Fellow at MITRANS and legendary Industry Consultant). The learned professor started the seminar with a sharing session on some baseline data such as:

  • Emission of greenhouse gases from logistics.
  • Emission costs of Heavy Goods Vehicles (HGVs).
  • Impact of Vehicle Speed on CO2 emissions.
  • Carbon monoxide monitoring.
  • Satellite data from sources such as NOAA, Gallileo, ASTER, MODIS, Landsat, Spot, Ikonos.



Later on, Prof Ruslan talked about transportation sustainability, air pollution modelling, behavioural science modelling, mitigation measures (decarbonisation) and policy measures. The seminar's final two sessions were reserved for various aspects of eco-driving.




















































Green Logistics Committee Meets at Ministry of Transport, Blok D, Level 3, Putrajaya, 3 September 2014

The meeting was Chaired by Dato’ Rohaini Mohd Yusof (Setisusaha Bahagian Dasar dan Antarabangsa, Kementrian Pengangkutan, i.e. Secretary for Policy and International Relations at the Ministry of Transport, MOT). Officially this committee is known as 'Jawatankuasa Kerja Pengangkutan Hijau dan Perubahan Iklim' @ Working Committee on Green Transportation / Logistics and Climate Change.


This was the last time that this committee would be meeting in this building. Later this week, MOT will be moving to its new premises near the Palace of Justice in Putrajaya.


The Committee is tasked with coordinating green logistics initiatives in Malaysia. Among the low hanging fruits which could be accessed almost immediately is the organising of an awareness programme for green transportation, which also incorporates eco-driving.


Officially, the terms of reference for this committee are as follows:


  • Identify the needs of development in the transport sector from a green transportation / logistics perspective.
  • Identify strategic issues in the field of green technology for development in the transportation / logistics sector.
  • Streamline and monitor projects in the transportation / logistics sector in the field of green technology.
  • Identify target areas and targets for the adoption of green technology in transportation and logistics.
  • Identify alternative energy sources which are environmentally friendly for use in the transportation and logistics sector.
  • Identify mechanisms and initiatives to encourage the use of green technology in transportation and logistics.






















Reviewing Samples of Corporate Videos, 29 August 2014

MITRANS is in the process of shooting its latest corporate video. This meeting was held to discuss what approach to take and also what should be in the video. Thank you to Assoc Prof Dr Jasmee (Deputy Director of MITRANS) for hosting the meeting.
















THE 6TH INTERNATIONAL CONFERENCE ON LOGISTICS & TRANSPORT 2014 (ICLT 2014) “INNOVATION IN GLOBAL SUPPLY CHAIN MANAGEMENT”

The Prestigious ICLT 2014 was hosted by MITRANS from 26 to 29 August 2014 at Berjaya Times Square Hotel, Kuala Lumpur, Malaysia. This is another feather in the cap for UiTM. Co-organisers for the event include the Centre for Logistics Research at Thammasat Business School, Thammasat University and Supply Chain and Engineering Management Research Unit, Chiang Mai University.


There were to co-chairs for the organising committee, Assoc. Prof. Dr. Ruth Banomyong Thammasat University, Thailand and Assoc. Prof. Dr. Apichat Sopadang Chiang Mai University, Thailand. Prof Dr Saadiah Yahya, Director of MITRANS, held the local chair in order to be in a position to efficiently organise the conference. The learned professor was ably assisted by the following persons from MITRANS: Assoc.Prof.Dr. Sariwati Sharif, Azlina Muhammad, Norasyura Abdul Aziz, Faizal Mohd Amin Sharifuldin, Azmin Faranaz Mohd Fahmy and Shahida Dahlan.


This is a major event for researchers in transport, logistics, supply chain and value chain management and successful conferences have been held at the following places in the preceding years:

  • Chiang Mai (Thailand), ICLT2009;

  • Queenstown (New Zealand), ICLT2010;

  • MalĂ© (the Republic of the Maldives), ICLT2011;

  • Chiang Mai (Thailand), ICLT2012; and

  • Kyoto (Japan), ICLT2013.



Papers for the following areas were submitted for consideration for this conference:

  • Procurement & Supply Management
  • Supply Chain Design/Configuration
  • Planning & Forecasting
  • Supply Chain Risk
  • Relationship & Collaboration
  • Sustainable Supply Chain
  • Production Planning & Operations
  • Production & Inventory
  • Inventory Fulfilment
  • Supply Chain Performance
  • International Logistics
  • Global Supply Chain
  • Humanitarian Logistics
  • Multimodal transport
  • Maritime Logistics
  • Freight Logistics
  • Logistics Service Providers
  • E-Logistics
  • Logistics Development Policies
  • Logistics Facilitation


The conference best paper will be invited and considered for publication in the International Journal of Physical Distribution and Logistics Management [ABS: 2*, Impact Factor: 2.617] and there will be a special ICLT2014 issue in the International Journal of Logistics Research and Applications [ABS: 2*, Impact Factor: 0.357]. and Chiang Mai University Journal of Natural Science.


The panel of evaluators for the papers submitted is a very distinguished panel, consisting of the the big wigs and heavyweights of the transport and logistics world:

  • Prof.Dr. Prem Chhetri, RMIT University, Australia
  • Prof. Dr. James H. Bookbinder, University of Waterloo, Canada
  • Dr. Jyri Vilko, Lappeenranta University of Technology, Finland
  • Prof.Dr. Yacine Outrouz, University of Lyon II, France
  • Prof.Dr. Ing. Hartmut Zadek, Germany
  • Prof.Dr. Manouchehr Vaziri, Sharif University of Technology, Iran
  • Dr. Graham Heaslip, National University of Ireland, Ireland
  • Dr. Pietro Evangelista, IRAT-CNR and the University of Naples Federico II, Italy
  • Prof.Dr. Nobuhiro Ishida, Doshisha University, Japan
  • Prof. Takayuki Mori, University of Marketing & Distribution Sciences, Japan
  • Assoc.Prof.Dr. Yokomi Muneki, Osaka University of Commerce, Japan
  • Dr. Harlina Suzana Jaafar, Universiti Technolog MARA, Malaysia
  • Prof.Dr. Paul Childerhouse, Massey University, New Zealand
  • Assoc.Prof. Tan Yan Weng, SIM University, Singapore
  • Asst.Prof Dr. Polin Lai, Chung Ang University, South Korea
  • Asst.Prof.Dr. Magnus Andersson, Lund University, Sweden
  • Assoc. Prof.Dr. Yenming J. Chen, National Kaohsiung University of Science &Technology, Taiwan
  • Assoc.Prof.Dr. Ted T.C. Lirn, National Taiwan Ocean University, Taiwan
  • Assoc.Prof.Dr. Nakorn Indra-Payoong, Burapha University, Thailand
  • Asst.Prof. Dr.Sakgasem Ramingwong, Chiangmai University, Thailand
  • Prof.Dr. Anthony Beresford, Cardiff Business School, UK
  • Prof.Dr. David Grant, Hull University Business School, UK
  • Prof.Dr. Chee Yew Wong, Leeds University Business School, UK
  • Dr. Adrian E Coronado Mondragon, Royal Holloway University of London, UK
  • Dr. Trinh Thi Thu Huong, Foreign Trade University, Vietnam



For a full schedule of the conference, click on this link.


Here are photos taken at an earlier pre-conference postgraduate on transport and logistics research workshop hosted by MITRANS at its premises in UiTM:















Here are some photos taken at the conference at Berjaya Times Square Hotel, Kuala Lumpur: