(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-P9GDNR3'); window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'UA-119995916-1');

MS EXCEL analysis and production calculation (download ready to use spreadsheet).

This year a “bunny rabbit” got you a special Easter treat in a form of calculation spreadsheet, thanks to which data collected with PRODIO, will help you to reach conclusions and make better decisions.

MS EXCEL analyses and calculation of production – why use a spreadsheet not Prodio ?

Prodio allows you to check (and probably some of the users even don’t know it) the real cost of labour of each detail (resulting from the cost of man-hours), compare planned time with lead time, sum things up using filters, compare any given data in hundreds of ways and many more…

Each of the tens of companies that use Prodio, analyse data in a unique way—  that’s why while creating the software we wanted to give the opportunity to export information to Excel in an easy way.

MS Excel spreadsheets were created to analyse data — giving great possibilities to visualize and accounting, so contrary to registration and managing production, using spreadsheets for calculating makes more sense.

You don’t have to be an “Excel mastermind” because to make data analysis easier (which can be a very lengthy and complicated process) we prepared some ready files (like this one), even when you are familiar with only basic Excel function thanks to them you will be able to handle quite sophisticated calculations.

 

 

Start now!
Try Prodio without any commitments - you have 14 days to check all of its functions in practice. After your trial period ends you can simply leave your account or continue work as our Client.

 

 

 

Start a test - no credit card needed

IMPORTANT ANNOUNCEMENTS REGARDING PRODUCTION ANALYSE IN MS EXCEL

1.OUR TARGET IS TO MOVE MAJORITY OF ANALYSES TO PRODIO, SO LET US KNOW WHICH ANALYSES SHOULD BE DIRECTLY IN THE SYSTEM.

Apart from helping you, we would like to use the present form of spreadsheet to collect opinions and ideas, which reports should go to Prodio itself.

This is very important for us to have your insight on how it should look. If any comments repeat we will try to implement them. So far we considered adding many new parameters (including OEE, shifts division or machines occupancy forecast).

2. THE SPREADSHEET IS UPDATED CONSTANTLY

The current spreadsheet is a tested and developing version, so it can contain some mistakes / or some elements that might be missing. We will make it better and work on real-time updates on receiving your comments – the newest version can be found when you click on the link below  

3. Equipment requirements

We intentionally used MS Office 2007 to create a spreadsheet (this is the oldest version possible to use) –  and to assure compatibility with older versions of spreadsheets. To make analyses an older computer model is also sufficient.

Analyse and production calculation in MS Excel

Available analyses:

1. Machine and operation – graph:

A single machine/operation occupation history (with efficiency and graphs).

    Analiza obłożenia i wydajności maszyny MS Excel

In this bookmark you can learn:

  •  how much worked a SINGLE machine/operation weekly/monthly (ex. to check occupancy and see if all working stations are used well)
  •  how long would it take if the machine/operation was doing the same job, but accordingly to norms set in products technology  (to see which machines/operations are the weakest or underestimated in your technological processes)
  • compare in percentages planned times with lead times from the point of the improvement process. 

2. Machines and operations occupancy

The total summary of all machines/operations occupancy.

Maszyny łaczne oblozenia - analiza

In this bookmark you can learn how to:

  • easily sum and compare how much worked machines /operations in a particular month (ex. to check occupancy and see if all working stations are used well);
  • easily sum and compare how much worked machines /operations in a particular week (ex. to check occupancy and see if all working stations are used well);
  • this summary is used mainly to see whether there are any discrepancies in particular processes

 3. Employee’s efficiency:

Work occupational history for the particular employee (with efficiency and graphs).

Analiza pracownika MS ExcelIn this bookmark you can learn:

  • how much an employee worked monthly / weekly
  • how long would it take if an employee was doing the same job, but accordingly to norms set in products technology  (to see which employees  are the weakest);
  • compare in percentages planned times with lead times from the point of the improvement process.

4. EXTERNAL CALCULATIONS, ORDERS: 

A comprehensive analyses of multi-position orders (by external order number), very useful, when you need quickly summarize a whole ex. 20 position order, without dividing it into single items. 

In this bookmark you can learn:

  • how long it took, in total, to complete the whole (multi-position) order
  • what was the total time conditioned by the production technology and norms
  • compare planned timed with lead times
  • see which machines/operations had  the biggest discrepancies
  • see which employees contributed the most to appearing of those discrepancies while completing the order
  • how many pieces were completed and how many shortages were in the process

5.PRODUCT ANALYSES:
A comprehensive analyses of production for a given assortment regarding the whole product making – the best knowledge compendium on your products.

Analiza i rozlczenie produkcji produktu MS Excel

In this bookmark you can learn:

  • how long on average it takes to make a product by particular machines/operations;
  • which operations are underestimated, and which can cut from the calculations;
  • compare planned times and lead times for each product;
  • which processes generate the most shortages
  • which employees are the best at completing a given product (in total);
  • how efficiently particular employees work on given product/operation;
  • how many pieces were made and when (in which months) the production was the biggest;

How to use it – Spreadsheet preparation:

  1. Download and open an updated version of the spreadsheet by clicking here
  2. Go to a bookmark Working history in Prodio, then click „Export the history of operations”.Data analyses
  3. Open the downloaded file with a working history, mark columns A to T and press “Copy”.
  4. In the analyses file go to bookmark “Pasting”, position mouse in A1 cell and then click “Paste”. The software will ask if you want to change content, to which we mark “YES”, as an answer.
  5. It’s ready 🙂

 

Update 1.08.2019 🙂

A BONUS: WORKING TIME AND WORK CHECK INS / CHECK OUTS ANALYSES SPEADSHEET.

We added the present file to analyses and calculation of working time (RCP) based on Prodio’s data, where there are among others 

  • working time division on Saturdays, Sundays and weekdays 
  • overtime and basic working time division
  • clear list of working hours by days 

Click (HERE) to download or click the graphic below:

Rozliczenie czasu pracy (RCP) Ms Excel plik

Do you have any questions?

We are glad to help?

Let’s chat (the right-hand corner of the screen)  or talk on the phone, call us: +48 32 746 61 62

We are happy to hear from you from Monday to Saturday from 9.00 am to 5 pm.

Start now!
Try Prodio without any commitments - you have 14 days to check all of its functions in practice. After your trial period ends you can simply leave your account or continue work as our Client.

 

 

 

Start a test - no credit card needed
(function(d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) return; js = d.createElement(s); js.id = id; js.src = 'https://connect.facebook.net/pl_PL/sdk.js#xfbml=1&version=v2.12'; fjs.parentNode.insertBefore(js, fjs); }(document, 'script', 'facebook-jssdk')); !function(e,t,n,s,u,a){e.twq||(s=e.twq=function(){s.exe?s.exe.apply(s,arguments):s.queue.push(arguments); },s.version='1.1',s.queue=[],u=t.createElement(n),u.async=!0,u.src='//static.ads-twitter.com/uwt.js', a=t.getElementsByTagName(n)[0],a.parentNode.insertBefore(u,a))}(window,document,'script'); // Insert Twitter Pixel ID and Standard Event data below twq('init','o36fm'); twq('track','PageView');