Hi.

I am glad with this portal therefore here is another file I created as a complement to Audit.

I hope it helps you.

NOTE: Revised file is in post 4 below in this thread. Original file removed to reduce confusion. -- Marc

thank you for your file, it's great.

I moved this thread from the TS forum as this is where other 5S topics have been dicussed.

:bigwave:

It is great. Thx.
Venkat

It is great. Thx.
Venkat

Thanks for your post.

Lately i truly looking for an example and reference to guide me implement and improve our 5S activity.
Thanks for your help

Spreadsheet is great thanks for sharing :)

I created this free 5S Audit form file based on previosly Word documents of this site and I converted it to Excel with Automatic Formulas and Graphics.

The idea is Let the spreadsheet work for you.

Regards and hope it helps you.

thanks.. have seen many forms but i think this one is top of the line.
good work.:applause:

I've tried customizing it and I can't is the cells locked?


thanks,
quality-misfit

I've tried customizing it and I can't is the cells locked?


thanks,
quality-misfit

No the file is open you need a little concepts of Visual Basic to modify it only I painted a few fonts cells in white . i.e
S!....S5 Sheets Column E

The check box use this code in VBA:

for evey checkbox only this code. You can copy and Paste.

Enable See Visual Basic Bar in Exel. Press Design mode and you may see the code for every checkbox

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
Range("E3").Value = 0
Else
Range("E3").Value = 1
End If
End Sub

If press checkbox1 E3 Will be 0 Else 1

bellow the file with the fonts in black.

Regards from Seville, Spain Europe

May be an introduction Course of VBA in Exel will be required....

http://www.excel-vba.com/excel-vba-contents.htm



regards,

I doubt whether we will implement 5S per se, but this is certainly food for thought and a useful spreadsheet. Thanks for sharing!

Thanks for your attach.
Best regards,
npnguyen

:bigwave:

This is a great help.
Thanx a lot.
Umang Vidyarthi :thanx:

This is real amazing stuff.
Thanks for the excel sheet. I also wanted to get some more detailed information for implementing 5S in a manufacturing environment.

Please help!

Clear, concise and simple to use, thanks for sharing, what will be a valuable tool.

Love your forms. I look forward to them.:D

[thanks .. this i svery usefull for me....

[thanks .. this i svery usefull for me....

Welcome to the Cove, AS Nur. We're happy that you have found both the site and the information posted to be helpful.

Thanks, Nice Job

This spreadsheet will do nicely

The spread sheet works well :applause:. However some of the audit questions need to be rephrased because the OK condition would be the yes answer, which leads to a reduction of the 5S score. Just one thing to look out for.

Joachim

Thanx,agree::
u hv done a gr8 job:bigwave:

It is great. Thx

i hope the thread starter would not mind. i would like to share my audit sheet that i compiled after surfing similar sites and of course by my experience.

it has got only 1s and 2s. because, i need time to get on to 3s.

Thanks for the post. Best of luck for 5 S implemetation.:thanx:

the spreadsheet is very good! Well done:agree:

Spreadsheet is great, thanks for sharing it!

Greetz, Moniekje

:agree1:
Spreadsheet is helpfull, Thanks

:) Excellent tool. Thks. It will save me a lot of time.

I was quite impressed with the form and your willingness to share it with us. The form shows that it is an exemplary piece of work. Thanks for sharing your knowledge.

In the scored audit form, on the S2 sheet it refers to:

"Are all containers, recipients, pallets and NTMs stored in an appropriate manner?"

I was just wondering what the acronym NTMs stands for, I have tried a google search and a search on this forum but not turned up what would seem to be a reasonable result. If anyone here could shed some light on this for me it would be much appreciated.

Gianfranco

In the scored audit form, on the S2 sheet it refers to:

"Are all containers, recipients, pallets and NTMs stored in an appropriate manner?"

I was just wondering what the acronym NTMs stands for, I have tried a google search and a search on this forum but not turned up what would seem to be a reasonable result. If anyone here could shed some light on this for me it would be much appreciated.

Gianfranco


Welcome,

Remember that we tagged materials or items that had not been used/not to be used in foreseeable future and they need to be moved out and be stored properly. I am guessing that NTM refers to 'Notice to Move' materials/items.

Tanx for the files, good help!!

Jrubio,
This is a good audit form

Hi it's great,

Siva

Thanks for the information.:D

I was looking exactlyfor something like this. Thanks a lot

Very good, thank you for the sharing.

This will be very useful for my company too!

Thanks a lot...

very useful. Thanks:thanx:

Thanks for your post.
Dear Sir

TQ. Its help me a lot as I'm appointed to be one of the Auditor. ;):agree::thanx:

:thanks::magic:

Quite useful info shared.
Thanks alot:)

Regards
Sreenu

I am having problem in saving most of the attached files under this sub-forum. Invalid file name always show up. I don't encounter any problem in saving attached files in other forums. Can someone help me to avoiding having to rename most the files? Thanks in adance!

Eric Ng

Hello Dear,

Wonderfool. One word WOW.

Regards,

Subash

Very helpfull the information, thanks

Thank you.

Always it is a pleasure to help people to improve.

Best regards from Spain. :bigwave:

Hi Javier,

:thanks: Thank you for the audit form!

Our company has implemented all 5S's and we conduct every second month an audit in all the work areas. Can we use your form to conduct audits to see whether the departments are sustaining the 5S programme?

Thanks a lot.

Best regards,

Maria

:agree:THANKS and NICE

M.RAJ

Thanks for your sharing!

Thank you for the spreadsheet.:)