Excel and Google Sheets Automation Consultant

Excel and Google Sheets Automation Consultant

Does it take too much time for your desk jobs like data entry, calculation, preparing presentation, searching required information and preparing reports, sending emails, status and notifications etc? Why don’t we automate most of those tasks and save our time?

You can do things in minutes instead of days using proper automations. Even you can do many things without spending a single second! Yes, you heard it right. Let’s have a consultation session and find out the opportunities for automation with all Microsoft office and google products in your organization.

Md. Jahurul Islam
Excel Automation Consultant (3rd percentile in international test)
jahurulislam@gmail.com
10 years experience in Planning and IE
B.Sc. (BUET)

Auto Medical Services and Hospitals

Auto Medical Services and Hospitals

At Auto Medical, we believe in our people. With a small but dynamic team of 15 peoples, we are committed to providing flexible, tailor made offerings that will delight our customers. We have number of human resource programs coupled by our spiriting of ‘winning’ in place dedicated to keep our staff motivated, diligent and provide you with excellent customer service at all time.

Hemayetpur, Savar, Dhaka.
• Floor Area – 2,500 sq. ft.
• Services and Initiatives –
o Outdoor Service
o Specialist Service
o Pathological Service
o Minor Operations
o Fair Priced Pharmacy
o Executive Health Check up
o Health Package for Factory
o Free Health Camps at Schools and Villages
o Yearly Blood Donation Programme
o Day-care Service (Sick Bed)
o EPI Programme for Child and Mother

ERP software for Small Business 100% Web Based

ERP software for Small Business 100% Web Based

This is the first time we are selling ERP software for Small Business with very cheapest price in bangladesh. There are 10,000 company are using this software arround 150 countries in the world.

This ERP is integrated with following module

  1. Employee Management System Software Module
  2. Leave Management System Software
  3. Contact Management System Module
  4. Notice Management Information System Module

Applicable Rules For Payroll Software

Applicable Rules For Payroll Software


Personnel software/ Payroll Software

  1. Age calculation: (Ref: BLL-2006 section-2 sub sec.8 & Labor rules -34) as per date of joining below 18 years will not posting.
  2. Salary break down: Ref: (Minimum wages gazette on 5th December, 2013, Schedule-A) Gross= (Basic + House rent +Medical + Transport+ Food allowance)
  3. Basic calculation: Grade- Gross-13000– (Medical-250 + Transport-200+ Food allowance-650=1100) /1.4= basic-8500*40% = House rent-3400.
  4. O T calculation: (Ref: BLR -102) Basic /208*2= 1 hour OT amount * Total OT hour = Total OT amount.
  5. Incomplete month (New joiner or resign/ discharge/dismissed employee) salary calculation: (Ref: BLR-114) Gross /days of month*working day including weekend & holiday = Net pay
  6. Absent deduction: (Ref: BLR-115) Basic /30 * absent days = absent amount.
  7. Earn leave calculation: (Ref: BLR-107) Last 12 month actual working days (physical attendance) /18= earn leave days) payment calculation: Last month net pay salary- (OT & bonus) / 30 * earn leave days= earn leave amount. Note: If any employee completes one year service then he /she will be entitled for Earn leave. Earn leave payment will yearly once, payment will maximum half, (January to December will calendar year) payment will every January.
  8. Increment: Ref: (Minimum wages gazette on 5th December, 2013, Schedule-A) Increment will be every month that means if any workmen complete one year then he /she will get minimum 5% increment based on basic.

NEW WORKER
• New workers refer to those who worked less or up to three months in the facility.
• Include workers with or without previous work experience.
• Actual days worked not day per week, month etc
Collection and formula:
How: It is up to facilities to decide which is the best calculation method to measure how much time is needed for a new worker to become fully productive linked to what is possible within their operations and a balance between accuracy and cost/time of collection. No matter which calculation is used, the facility should be consistent in calculating and reporting this data point each month. Below are guidelines in order of preference and accuracy:
1. If your facility measures efficiency (%) per worker, this is the time it takes for new workers to reach the average efficiency of the facility, excluding new hires.
2. If workers are paid according to an individual piece rate system, it can be based on the number of days a typical new worker needs to reach the productivity level of an experienced worker (e.g. meeting the standard output per day/hour for each position).
3. It can be based on the rework/defect rate data to measure how long it takes for a new worker to reach the same level of experienced workers.
4. It can be based on workers’ self-reflection results gained through worker interview and/worker surveys.
Unit: Number of days
Responsible staff:
• The production manager of each department provides the data, which is compiled by responsible Human Resources personnel for the average level.
Data Source:
Production sheet, individual production records and rework record
Example:
• Utilize piece rate system to measure the number of days required for a new sewer to become fully productive.
• Step 1: Monitor the number of pieces sewed by a new sewer on a daily basis;
• Step 2: Compare the daily output with standard output by an experienced sewer. Assuming the standard output per day is 250 pieces. Worker 1 takes 17 days to achieve, whereas worker 2 needs 21 days.
• Step 3: Calculate the average days needed for a new worker to become fully productive = (17+21)/2=19 days. personnel software

What is a Chemical Inventory Management System ?

What is a Chemical Inventory Management System ?

Chemical Inventory Management System

This is the feasibility study of chemical inventory management system software. Detailed procedures of chemical inventory management system software and necessary documentations for receiving of stores, storing, consumption and accounting contained in this procedure have been drawn up on the basis of existing practice. We sale e all types Garment ERP software  in cheapest price. E.g. Computerized Inventory Control System Pdf ManualBilling and Inventory Management Software, Chemical Management System, All ERP.  For any queries, please Contact Us.

Function of Chemical Inventory Management System

Functions of Chemical Stores management system software and for which Departmental Heads is accountable are broadly as under:

  • To receive and issue stock and to maintain records of stock receiving, issuing and balancing in both quantity and value,
  • To keep stock in proper condition,
  • To carry out periodical physical verification of stores and reconcile with the book balances,
  • To ensure proper segregation of high value items,
  • To ensure optimum inventory level is maintained and informed to the Merchandising Department and Commercial Department for making fresh supplies in a timely manner,
  • To carry out such other activity as would be necessary for proper management of stores.

Raising of Purchase Requisition (PR) for procuring items for Chemical Store/ Re-order level

  • Based on the closing balance of the store items and their volume of usage, Chemical Store will go for raising requisition. The following procedures are followed in this connection.
  • Information about current stock shall also be informed through a report, the requirement of items is raised by the Manager through e-mail, to the sellers asking for price quotation.
  • Commercial Department negotiates the price and selects the supplier and e-mail these to Chemical Store for raising Purchase Requisition (PR).In case of Import, PD forwards the quotation raised by foreign suppliers to the Chemical Store.
  • PR is signed by requesting person, Manager and is forwarded to BOD for approval.
  • Then Chemical Store forwards PR to Purchasing Department (PD) along with the e-mailed copy regarding fixation of price and selection of supplier by PD.
  • The Commercial department also inform the Auto C&F agent about the estimated date of arrival. The C&F agent release the items from the port & sends the same to factory gate

Keeping of Lead Time Consumption

  • In case of import, lead time consumption shall be maintained. For that a standard lead time for several items should be pre-set based on the consumption pattern etc.
  • A  re-order level is also determined based on the prior experience for the respective items.

Procedure for receiving stores

  • Upon arrival at the factory gate, Security Guard counts the goods and after necessary documentation passes the goods to the Chemical Store.
  • Chemical Store re-counts goods and quality is also checked. Chemical Store matches the attributes of the goods with the same mentioned in Delivery Challan, Bill, Invoice and PO. Delivery Challan is also sealed as Received.
  • In case of Local Purchase, a copy of Delivery Challan is signed and sealed by representative of Chemical Store and sent back to the supplier as a token of acknowledgement.
  • Original copies of these documents are forwarded to Finance Dept. and one photocopied copy is kept at the Chemical Store.
  • Chemical Store may be informed prior to arrival of the items.
  • Sometimes, Chemical Store has to collect very insignificant amount of stores by itself on emergency basis as loan from the suppliers.

Inspection Procedure

  • Items procured for are inspected on test basis while receiving at the Chemical Stores. MRR is done in the in-house laboratory.
  • If testing result is satisfactory, then Delivery Challan will be sent to Finance Dept. and should be sealed as Inspected.
  • During the inspection, if any items are found not in accordance with the Delivery Challan, in terms of quantity or quality, then these items will not be received unless the dispute is settled or decision in this regard is obtained from higher authority (Departmental Heads)
  • A photocopy of these documents is maintained in the Chemical Store.

Issuing Procedure

  • Dying department prepares a recipe sheet which is actually the requisition sheet to the chemical inventory management system.
  • Information like Style NO., Operator‘s name, Machine no., Shift, standard time and quantity of unwashed garments should be mentioned on the recipe slip.
  • The requisition slip is signed by the Operator and Supervisor of the Floor.
  • Based on that slip total requisitioned quantity of chemicals is issued several times.
  • If the total requisitioned quantities of chemicals are issued entirely, then the slip is signed by the SManager Plant and marked as OK. Requisition should be signed by  Manager production before commencing delivery against such requisition.
  • At the end of the day, all the requisitions under which all the chemicals are issued, will be entered into a excel sheet to track the issue of chemicals.

Stock Keeping system for chemical stores

  • Chemical Items are kept in drums and packets as considered necessary for the items to reduce the risk of evaporation and others.
  • Racks of store department are set up in a way that enables easy movement of stock.
  • Separate number for each rack and shelf is mentioned physically on the rack.
  • Items procured for different styles are kept in a separate place.

Normal Loss-recommended procedure

  • There may be some chemical stores items which are subject to normal loss due to evaporation, handling etc. A standard shall be set up to determine the percentage of normal loss.
  • Efficiency of usage of various chemical stores should be checked on regular basis compared to standard percentage to determine any abnormal loss.
  • At times, the standard should be reviewed to bring any change in the standard, if require

Inventory Auto report

  • At the end of the day, a report containing details of all issue during the day, is printed out from the computer.
  • And all the recipe sheets against which stores were issued during the day is attached with the report. The report is signed by preparer and approved by Manager and is kept serially.

Daily Chemical Consumption Report

  • Daily consumption of various chemical is prepared in excel sheet and be printed out at the end of the day.
  • The report is cross checked with reference to all the requisition slips against which chemical items were issued during the day.
  • The report is signed by preparer, checked by anyone other than preparer and finally by Manager.
  • The report is kept in a file serially attaching all the requisition slips for the respective day.

Safety Measure

  • For safety, sufficient fire extinguisher and others are in place.
  • CC TV Camera is well located to monitor the activities of Chemical Store.

Physical Verification of Stores

To ensure accuracy of quantitative book balances, physical verification of stores is essential. Physical verification of stores saves auto  from incurring losses arising from theft, pilferage, obsolescence, misappropri­ation etc.

Periodical chemical inventory management system:

All stocks at the Stores Department are checked physically at least once a year, preferably at the end of the year. The Audit Officer who will be overall in charge of stock taking may decide to check the stock at any time during the year, if he considers it convenient and more appropriate. Before commencement, the Audit Officer should prepare a program of stock taking, allocate exact duties to his staff members in this respect, send a circular notifying them that stock records are made up to date and that during the stock taking no stores shall be issued.

Before commencing the physical verification of stores, the following preliminary work is essential:

  • Chemical inventory management system Sheet should be prepared at every store in order of rack and location mentioning the name, classi­fication, code number, etc.
  • All stores must ensure that stocks are so arranged that they can be checked in the shortest possible time.
  • Both Stores and Stores Accounting Section should ensure that stock records are up to date.
  • Program should be prepared by the Audit Department for stock taking, allocating the exact duties to the staff members. Specific person should also be deputed from the Stores for identification of items.
    • To ensure smooth and efficient stock taking certain measures are suggested below:
  • Each page of chemical inventory management system Sheet must be signed by the checking persons as well as the members of store staff assisting in checking.
  • Overwriting or erasing should be avoided and, if any, must be initiated.
  • Checking should be well coordinated and done systematically so that responsibility for each item can be placed on individual stock taker when necessary.
  • While checking, if any item is detected which does not appear on the list, then its name, quantity, condition etc. must be noted.
  • An effective marking of items physically checked should be arranged to avoid:
    • Counting of items twice
    • Omission of items
  • During checking, if any item looks obsolete or deteriorated, a note to that effect shall be made.
  • The Inventory Sheet should be checked against the Stores Ledger and Bin Card and discrepancies looked into. As soon as, it is convenient, the completed chemical inventory management system Sheets must be handed over to the stock taking authority.

Non-routine Physical Verification

  • Without year end Physical Verification of Stock, there is no obligation of the Chemical Stores to take physical verification at times.
  • But still Chemical Store may wilfully carry on physical verification of general items on weekly basis. For the verification, they can select ten valuable items at random. Other than that, sometimes a team lead by Manager- Main Store goes for surprise physical verification of Chemical Store. And the result of which is documented and forwarded to Head of Sourcing.

Reporting of Obsolete Items

If any store items which is identified at the store during physical verification or any time as obsolete should be reported to the Manager to take decision about such items. As this has a financial impact, there should be a pre-set clear and complete reporting procedure of chemical inventory management system.

Engr. Kh. Mashiur Rahman, Garments Auto Machine Technologist, Web: www.autogarment.com, Email: sales@autogarment.com, Cell: +88 017 92 52 53 54
How To Install Datacolor Tools Colour Analysis Calibration Software

How To Install Datacolor Tools Colour Analysis Calibration Software

Datacolor Tools 1.0

Before installing datacolor tools colour analysis software ensure the optimum computer configuration. Database should check and backup before installing the software.  The installation program will prompt you to back up the data on the Datacolor TOOLS desktop before you proceed.  We strongly recommend you do this to protect your unique color information. Please click the link to know the installation procedure of older version Datacolor Tools Software .

We are the largest Garment and Textile ERP software collector in Bangladesh. We sale customized ERP for the factories.  We are agent of all Garment and Textile ERP software company. We will forward you to the best ERP software company based on your requirements.  We are trouble shooter of fashion industrial software like Willcom, Barudan, Lectra, Gerber, iEcho, Datacolor, Shedomaster, Batch, Qc etc. Email: autogarments@gmail.com, Cell: +88 017 92 52 53 54

Requirements:

ComponentsMinimum RequirementRecommended
ProcessorPentium 4  1.4 GHzPentium 4   2.5 GHz
RAM1 Gigabyte4 Gigabyte
Free Hard Drive Space40 Gigabyte120 Gigabyte
Resolution1024 x 768 True Color1280 x 1024 True Color
Monitor Size19”21” 16:9 widescreen
VGA4 Megabyte128 Megabyte
CD/DVD RomCD ReaderCD Writer
Diskette1.44 Megabyte1.44 Megabyte
Available Port(1) RS-232 Serial
(1) USB
(1) RS-232 Serial
(3) USB
Printer PortParallel or USBParallel and USB
Operating System- OSWindows® XP Pro, SP 2,Windows XP Pro, SP 2, Windows Vista, Windows 7
E-mail SupportOutlook 2003 or above, POP3Outlook 2003 or above, POP3
Database, suppliedSybase 9.0.2. EBF 3924Sybase 9.0.2. EBF 3924
Optional DatabaseMicrosoft SQL Server 2005,
Microsoft SQL Server 2008
Microsoft SQL Server 2005,
Microsoft SQL Server 2008

Colour Analysis Software Installation Procedure:

  1. At first click the Start button.
  2. From the Start menu, choose and click Run.
  3. In the Run dialog box, type D:/MENU and click OK.  (If your CD drive is a letter other than D, use that letter in the dialog box.)
  4. Then Click on the Install Datacolor TOOLS.
  5. Select appropriate language and click OK.
  6. Upgrading TOOLS.  For upgrading  from an earlier version of TOOLS you will see the following messageDatacolor Tools Upgrade
  7. Then click Yes to continue the installation.
  8. Or click No to stop the installation.
  9. After the above question you will see the following messageDatacolor tools upgrade confirmation
  10. Then click Yes for removing the older version and install the new version.
  11. Or click No to stop the installation. The installation  wizard will be aborted and the current TOOLS system will be preserved
  12.  Make your selection and click Next.
  13. The  installation wizard will opencolour analysis sfotware start
  14. Click Next to continue.
  15. Now software license agreement will prompt.
  16. Then click Yes after prompt of license agreement.
  17. Select the folder where you want to install Colour Analysis Software.calibration software install
  18. Then click Next to accept the default location.
  19. The program will prompt for a setup type:
  20. SETUP TYPE SELECTION IS IMPORTANT!  The most common choices are Textile Setup, and Paint Plastic Ink Setup.  These refer to the types of materials you use.
  21. Make a setup selection and click Next.
  22. Now select the components of Colour Analysis Software that you want to install.
  23. The optional program features of datacolor tools that you can choose to install on the system include:
  24. Form Editor. This is a separate program that allows you to customize Datacolor TOOLS forms.  The default selection places a check in this box and automatically installs the Form Editor program.  We strongly suggest that you install this program.  If you do not and decide to use it later, you must repeat the entire program installation to install it.  This option is not available with Datacolor TOOLS or TOOLS
  25. Database Conversion.  This is a program that converts data stored using ColorTOOLS1.3.x (Paradox format database) to Sybase format, which allows you to continue using the data with Datacolor TOOLS.
  26. To continue with the installation you must click Yes.  This will delete all data from the TOOLS desktop.
  27. Click No to stop the installation. Launch the existing version of Datacolor TOOLS and save the desktop data to the database.  You can then install the program update.
  28. Click next button from the software
  29. If you are upgrading from Color Tools, or Datacolor TOOLS version running under Sybase 6.x or 7.x, the program will also prompt you to upgrade the database.
  30. To perform this upgrade during the installation, place a check in the box and click Finish.
  31. The program will continue the installation.  Below is the final installation screenFinish colour analysis software
  32. The installation is now complete.
  33. Click Finish. To run Datacolor TOOLS, you must restart the system.  After you have restarted the system, launch Datacolor TOOLS immediately.

Update Spectrophotometer Calibration Tools: 

When you are updating Spectrophotometer Calibration Tools, please consider the following: 

Database Updates.  Updating the database software is a separate function from upgrading/rebuilding the database itself.  An existing database generated under Sybase v.7 will run under Sybase v.9, but it may degrade the database access speed. We recommend that an update to Sybase 9 program software should always include the step to Upgrade/Rebuild the Database.  This upgrades the Sybase database structure from v.7 to v.9 format.  This option can be accessed from the Datacolor TOOLS installation menu or the Sybase installation menu.

License for Calibration Software:

This number is provided by Datacolor calibration software and can be obtained one of three ways:

Direct web connection:  If you have internet access, you can use the link provided in the Datacolor Security Client window. This procedure is documented in the Licensing Procedure section of this guide of calibration software.

Email:  For each product, send the Serial Number found on the CD case, and Computer Validation Number found on the Datacolor Security Client window, to SoftwareLicense@Datacolor.Com>. You will receive an Unlock Response Number via e-mail.  You must enter this into the Datacolor Security Clientwindow.

Questionaries of Datacolor Tools:

Where is you Datacolor tools database located?

  1. On computer on the local network
  2. Every computer has its own Datacolor Tools installation and database
  3. We use x-rite IQC

What operating system does the computer that holds the Datacolor Tools database have?

  1. Microsoft Windows XP (SP2 required, SP3 preferred)
  2. Microsoft Windows Vista or 7 (SP1 preferred)
  3. Microsoft Windows 7

What version of the operating system do you have installed? (only applies to Windows Vista and 7)

  1. 32bit
  2. 64bit

Can the computer that holds the Datacolor Tools database access internet thru a web browser?

  1. Yes
  2. No

Is a proxy used for accessing Internet?

  1. Yes
  2. No

What language does the computer that holds the Datacolor Tools database use?

  1. English
  2. Chinese (simplified / traditional; please underline)
  3. Mandarin
  4. Other:_________

Is the computer that holds the Datacolor tools database always online?

  1. Yes – always
  2. Only during opening hours
  3. Only when used.

How is the computer that holds the Datacolor Tools database use connected to the internet?

  1. Via LAN
  2. Via Dial-up
  3. Not connected

How many computers are connected to the Datacolor Tools Database?

  1. 1
  2. 2-5
  3. 5-10
  4. 11 or more

Is the database backed up?

  1. Yes
  2. No
  3. Don’t know

Do you have a firewall installed?

  1. Yes
  2. No

How many computers do you use for measuring production lots for the CAP retailer?

  1. 1
  2. More: ___

What version of Datacolor Tools or IQC do you use?

__datacolor Tools version- 2.0.1

Brief infrmation in connection with the natific M3K installation:

-natific M3K uses Microsoft .NET Framework 2.0. Please make sure this is installed before the M3K installation. No other versions of the framework are suitable, only the exact 2.0 version (SP2 is available for .NET 2.0)

-If you use Datacolor Tools, please empty the Tools desktop. You should store the measurements there into the database or export them into a QTX for the time of the installation.

-natific M3K needs access to the following servers:

m3k.coloraccreditation.com

asap.natific.com

-Please note, that in case you use Datacolor Tools on multiple machine for the CAP retailer, we need to install the CAP form to every of those computers. natific M3K should be installed only on one.

-If you use x-rite IQC on multiple machines for the CAP retailer, we will need to install the eJob template and natific M3K on each computer.

-You are obliged to enter the following additional information during the measurement:

FabricID / YarnID

Machine name

Machine port (depends on protocol type)

Sample Position (depends on protocol type)

Total length (depends on protocol type)

LOT number

Submission Type (Lab Dyeing; Approved Lab Dyeing; Production Sample Dyeing; First Approved Bulk Lot; Production; Scale-up sample; VCS – Virtual Color Submission)

Telephone: Finally you make telephone call for getting license of datacolor tools colour analysis calibration software.

Engr. Kh. Mashiur Rahman, Garments Auto Machine Technologist, Web: www.autogarment.com, Email: autogarments@gmail.com, Cell: +88 017 92 52 53 54