Information Communication Technology Applications used to Enhance Knowledge Management in the University Libraries of Pakistan

Arshad, Sadia; Rehman, Hafiz Abdur; Rahoo, Liaquat Ali; Nagar, Muhammad Ali Khan

doi:10.1109/icetas.2018.8629133

2018 IEEE 5th International Conference on Engineering Technologies and Applied Sciences (ICETAS) 2018

DOI: 10.1109/icetas.2018.8629133

|View full text |Cite

Information Communication Technology Applications used to Enhance Knowledge Management in the University Libraries of Pakistan

Sadia Arshad

Hafiz Abdur Rehman

Liaquat Ali Rahoo

et al.

Help me understand this report

Search citation statements

Order By: Relevance

Paper Sections

Select...

Citation Types

Supporting

Mentioning

Contrasting

Year Published

2023

Publication Types

Select...

Article1

Relationship

Self Cite0

Independent1

Authors

Journals

Cited by 1 publication

References 7 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

Automation of production plan generating workbook at leather footwear company of Lahore Pakistan by using VBA in Microsoft Excel

Kalwar,

Wassan,

Khan

et al. 2023

J APPL RES TECH ENG

View full text Add to dashboard Cite

In Small and Medium Enterprises (SMEs), all the reporting tasks are carried out in Microsoft Excel. The employees spend all of their time working on the reports and in the case of an error in the report; a tremendous amount of their time is incurred on the detection of that error. At one of the leather footwear companies in Lahore, Pakistan, report automation was carried out using visual basic for Application (VBA) in Microsoft Excel. The purpose of automation was to increase the reporting efficiency and minimize the chance of error. The authors automated the generation of production plan papers, which used to take 3.11 minutes to be made per plan paper. 3.11 minutes were required just for a single order of only one footwear article). This research provides the framework for the automation of manual reporting in Microsoft Excel. This automation was conducted by using VBA in Microsoft Excel. In the VBA code, the loops and conditional statements were used to program the manual activities to be performed in the report. Initially, the manual method was demonstrated in detail then way of report automation was the focus of discussion. The comparison of both methods was conducted in terms of time utilization. The manual method encompassed a series of activities whereas; the automated template included the buttons with few clicks. A time study of report-making by manual and automated method was conducted which indicated that the automated method was 1.36 minutes faster than the manual method. This research contributes to the provision of a detailed framework, with the help of which any manual work in Microsoft Excel can be automated. It was also indicated by this research that SMEs who cannot afford the implementation of Enterprise Resource Planning (ERP) software, have the option of VBA in Microsoft Excel by which they can enhance their reporting efficiency and office employees` productivity.

show abstract

Automation of production plan generating workbook at leather footwear company of Lahore Pakistan by using VBA in Microsoft Excel

Kalwar,

Wassan,

Khan

et al. 2023

J APPL RES TECH ENG

View full text Add to dashboard Cite

show abstract

scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.

Contact Info

customersupport@researchsolutions.com

10624 S. Eastern Ave., Ste. A-614

Henderson, NV 89052, USA

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Blog Terms and Conditions API Terms Privacy Policy Contact Cookie Preferences Do Not Sell or Share My Personal Information

Made with 💙 for researchers

Part of the Research Solutions Family.

Information Communication Technology Applications used to Enhance Knowledge Management in the University Libraries of Pakistan

Cited by 1 publication

References 7 publications

Automation of production plan generating workbook at leather footwear company of Lahore Pakistan by using VBA in Microsoft Excel

Automation of production plan generating workbook at leather footwear company of Lahore Pakistan by using VBA in Microsoft Excel

Contact Info

Product

Resources

About