5 SOLUTION DEVELOPMENT (CALCULATOR) ALCULATOR)
5.1 CONCEPTUALIZING 5.1 CONCEPTUALIZING
In this process the concept of the calculator was developed. The inputs and and In this process the concept of the calculator was developed. The inputs and and outputs required for the calculator have been designed in a way to reduce errors in outputs required for the calculator have been designed in a way to reduce errors in calculation to maximum extent.
calculation to maximum extent.
The inputs
The inputs required in required in the calculator the calculator are limited to are limited to that of that of seam length,operatiseam length,operationon bulletin and number of seams. Combo-box list provide a more easy way of machine bulletin and number of seams. Combo-box list provide a more easy way of machine selection for particular seam type.The selection of threads for needle ,bobbin and selection for particular seam type.The selection of threads for needle ,bobbin and spreader
spreader have have also also been been provided provided with with comcombo bo lists to lists to enable enable easy, easy, fast fast andand accurate selections.
accurate selections.
Formulas in corresponding columns of needle, bobbin/looper,spreader and total Formulas in corresponding columns of needle, bobbin/looper,spreader and total consumption provide automatic calculations by retrival of factors automatically from consumption provide automatic calculations by retrival of factors automatically from the factor sheet.
the factor sheet.
Automatic consumption report is generated as the consumption or data for Automatic consumption report is generated as the consumption or data for consumption is entered. This report is developed in a way that it reduces the consumption is entered. This report is developed in a way that it reduces the compiling work of t
compiling work of the merchandiser.he merchandiser.
5.2 DESIGNING 5.2 DESIGNING
The calculator has been developed by keeping in mind a user friendly interface that The calculator has been developed by keeping in mind a user friendly interface that can easily be understood and used by
can easily be understood and used by anyone.anyone.
The calculator has been
The calculator has been designed in workshdesigned in worksheets eets using various linking , formusing various linking , formula andula and programming features of excel.
programming features of excel.
Consumptions for up to 15 Thread types can be determined by entering their Consumptions for up to 15 Thread types can be determined by entering their description in the
description in the thread description table.thread description table.
Seventy five (75) row
Seventy five (75) rows have been provs have been provided to ided to cover long opecover long operation bulletins.ration bulletins.
Option for saving the consumption calculation file in user determined named location Option for saving the consumption calculation file in user determined named location has been provided.
has been provided.
Reset field option has been provided for instantly clearing field entries.
Reset field option has been provided for instantly clearing field entries.
A generate
A generate report option report option has also has also been pbeen provided for rovided for the the purpose of purpose of automatic reportautomatic report generation.
generation.
Combo box controls have been used i
Combo box controls have been used in columns of machine type ,needle,bobbin andn columns of machine type ,needle,bobbin and spreader
spreader thread dthread description, escription, wastage wastage selection selection for the for the purpose purpose of of easy easy and and quickquick selection.
selection.
Linking between factor sheet and the main interface has been done using formulas Linking between factor sheet and the main interface has been done using formulas such that
such that automatic automatic retrieval of facretrieval of factors is tors is possible thupossible thus reducs reducing the ing the need for need for referencing the
referencing the thread consumthread consumption ratio table and mption ratio table and mismatch in values.ismatch in values.
The report has been designed on lines of
The report has been designed on lines of the real life report the real life report made by a merchandiser made by a merchandiser for calculating consumption per thread for
for calculating consumption per thread for an order quantity for an order quantity for booking purposes.booking purposes.
Fi
Fi 5.3 5.3.1. .1.1: 1:- - Th Thre read ad co cons nsum um tio tion n fac facto tor r sh shee eett
5.3 DEVELOPMENT 5.3 DEVELOPMENT
5.3.1 FACTOR SHEET 5.3.1 FACTOR SHEET
The development of the calculator started with the data collection of the The development of the calculator started with the data collection of the factors/thread consumption ratios for different machines. This data was provided by factors/thread consumption ratios for different machines. This data was provided by the IE dept of Alok industries Garments division.
the IE dept of Alok industries Garments division.
A separate worksheet named “factors“ had been developed for the purpose of A separate worksheet named “factors“ had been developed for the purpose of tabulating the data of
tabulating the data of thread consumption ratios.thread consumption ratios.
Fig
Fig 5.3.2.1:- 5.3.2.1:- Welcome Welcome screen screen
Fig 5.3.3.1 – Consumption Fig 5.3.3.1 – Consumption
5.3.2
5.3.2 WELCOME WELCOME SCREENSCREEN
The welcome screen contains a calculate button connected to the calculator The welcome screen contains a calculate button connected to the calculator worksheet. This screen is purely a start-up screen meant for introductory display worksheet. This screen is purely a start-up screen meant for introductory display purposes.
purposes.