How to Create your PF e Passbook

First open the following link

http://members.epfoservices.in/

Register you by filling your information

Follow the steps as per instructions

How to recover the password of excel sheet

In Excel, select Tools --> Macro --> Visual Basic Editor. In the blank sheet copy the code below and then push the Play button. It should retrieve your password quickly.
The code is lengthy but works really well.
<---Debut of Code - Copy/Paste in between only--->
Public Sub AllInternalPasswords()
'Breaks worksheet and workbook structure passwords.
'Bob McCormick probably originator of base code algorithm
'Modified for coverage of workbook structure / windows
'passwords and for multiple passwords
'Norman Harker and JE McGimpsey 27-Dec-2002
'Reveals passwords NOT "the" passwords
Const DBLSPACE As String = vbNewLine & vbNewLine
Dim Mess As String, Header As String
Dim Authors As String, Version As String
Dim RepBack As String, AllClear As String
Dim PWord1 As String
Dim ShTag As Boolean, WinTag As Boolean
Dim w1 As Worksheet, w2 As Worksheet
Dim i As Integer, j As Integer, k As Integer, l As Integer
Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer
Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer
Application.ScreenUpdating = False
Header = "AllInternalPasswords User Message"
Authors = DBLSPACE & vbNewLine & "Adapted from Bob " & _
"McCormick base code by Norman Harker " & _
"and JE McGimpsey"
Version = DBLSPACE & "Version 1.1 27-Dec-2002"
RepBack = DBLSPACE & "Please report success or " & _
"failure back to newsgroup."
AllClear = DBLSPACE & "The workbook should now " & _
"be free of all password protection so " & _
"make sure you:" & DBLSPACE & _
"SAVE IT NOW!" & DBLSPACE & _
"and also" & DBLSPACE & _
"BACKUP!, BACKUP!!, BACKUP!!!" & DBLSPACE & _
"Also, remember that the password " & _
"was put there for a reason. Don't " & _
"stuff up crucial formulas or data." & _
DBLSPACE & "Access and use of some data may" & _
"be an offence. If in doubt, don't."
With ActiveWorkbook
WinTag = .ProtectStructure Or .ProtectWindows
End With
ShTag = False
For Each w1 In Worksheets
ShTag = ShTag Or w1.ProtectContents
Next w1
If Not ShTag And Not WinTag Then
Mess = "There were no passwords on sheets, or workbook " & _
"structure or windows." & Authors & Version
MsgBox Mess, vbInformation, Header
Exit Sub
End If
Mess = "After pressing OK button this will take some time." & _
DBLSPACE & "Amount of time depends on how " & _
"many different passwords, the passwords, and" & _
"your computer's specification." & DBLSPACE & _
"Just be patient! Make me a coffee!" & _
Authors & Version
MsgBox Mess, vbInformation, Header
If Not WinTag Then
Mess = "There was no protection to workbook structure " & _
"or windows." & DBLSPACE & _
"Proceeding to unprotect sheets." & _
Authors & Version
MsgBox Mess, vbInformation, Header
Else
On Error Resume Next
Do 'dummy do loop
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
With ActiveWorkbook
.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If .ProtectStructure = False And _
.ProtectWindows = False Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Mess = "You had a Worksheet Structure or " & _
"Windows Password set." & DBLSPACE & _
"The password found was: " & DBLSPACE & _
PWord1 & DBLSPACE & "Note it down for " & _
"potential future use in other " & _
"workbooks by same person who set this " & _
"password." & DBLSPACE & _
"Now to check and clear other passwords." & _
Authors & Version
MsgBox Mess, vbInformation, Header
Exit Do 'Bypass all for...nexts
End If
End With
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
If WinTag And Not ShTag Then
Mess = "Only structure / windows protected with " & _
"the password that was just found." & _
AllClear & Authors & Version & RepBack
MsgBox Mess, vbInformation, Header
Exit Sub
End If
On Error Resume Next
For Each w1 In Worksheets
'Attempt clearance with PWord1
w1.Unprotect PWord1
Next w1
On Error GoTo 0
ShTag = False
For Each w1 In Worksheets
'Checks for all clear ShTag triggered to 1 if not.
ShTag = ShTag Or w1.ProtectContents
Next w1
If Not ShTag Then
Mess = AllClear & Authors & Version & RepBack
MsgBox Mess, vbInformation, Header
Exit Sub
End If
For Each w1 In Worksheets
With w1
If .ProtectContents Then
On Error Resume Next
Do 'Dummy do loop
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If Not .ProtectContents Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Mess = "You had a Worksheet password set." & _
DBLSPACE & "The password found was: " & _
DBLSPACE & PWord1 & DBLSPACE & _
"Note it down for potential future use " & _
"in other workbooks by same person who " & _
"set this password." & DBLSPACE & _
"Now to check and clear other passwords." & _
Authors & Version
MsgBox Mess, vbInformation, Header
'leverage finding Pword by trying on other sheets
For Each w2 In Worksheets
w2.Unprotect PWord1
Next w2
Exit Do 'Bypass all for...nexts
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
End With
Next w1
Mess = AllClear & Authors & Version & RepBack
MsgBox Mess, vbInformation, Header
End Sub
<---End of Code - Copy/Paste in between only--->

Procedure to connect PPM server

1.     Connect the Ethernet Cable of the Printer to the LAPTOP

2.     Open LAN Connection Setup.

3.     Go to the Properties menu

4.     Click Internet Protocol(TCP/IP)

5.     Type IP address as following

 IP address                  10.35.156.20

Subnet Mask             255.255.0.0

6.     Then Click OK.

7.     Go to Start Menu Run  and type cmd ,Then Enter

8.     New Window Opens, Type cd\ and enter

9.     Type ping 10.35.156.111

10.                        If connected ,you will get Reply from 10.35.156.111

11.                        Connect to the PPM server.

Procedure to Copy or Backup 1 GB and 4 GB Flash Cards on PPM Server of Regioman Press

1.   Go to Service Menu in the PPM Server

2.   Enter the password as brx

3.   Remote back up screen opens

4.   Insert the flash card and click restore

5.   Select 1GB or 4GB

6.     Click start and download starts

Procedure to Replacement of Load Cell Measuring Amplifier

1. Disconnect all connectors
2. Remove the load cell measuring amplifier and connect new Amplifier
3. Connect all the connectors
4. Check the position of DP switch and make it similar with the old one
5. Check Filter position-similar with old one
6. Check voltage at terminal no. 16 and 17 and adjust to 10 V by using speise spannung (span pot- located at downside)
7. Check voltage at terminal no 12 and 13 and adjust to 0 V by using Null Punkt ( (pot-located on top)
8. Push White button and check voltage at terminal 12 and 13 and adjust to 5 V by using verstarkung (pot-located in middle)

Calibration of Ink Key of Baker Perkin Press

1	FIRST DO MECHANICAL ZERO SETTING.
2	OPEN THE INKING WINDOW BY INKING BUTTON.
3	SELECT THE UNIT AND SECTTION WHICH YOU WANT TO CALIBRATE.
4	CLICK ON CALIBRATE.
5	PASSWORD WINDOW OPEN, ENTER USER NAME : htmedia AND PASSWORD : 123
	FOR ADMIN. USER NAME : administrator AND PASSWORD : wonderware
6	CLICK ON OK, THE 0-10 SPAN AND CALIBRATION BUTTON SHOWN AT BOTTON OF SCREEN.
7	CLICK ON 0-10 SPAN BUTTON, THEN CLICK ON CALIBRATION.
8	CALIBRATION PROCESS COMPLETED.

How To Calculate The Rated Frequency of AC Motor

Use following formula to calculate the frequency.

        (120*F)
NS = -------------
                   P
NS- Rated speed of Motor
F   - Rated frequency of Motor
P   - No. of Pole of Motor 

Procedure to Change the DPO-1 Card of Central Encoder Rack of Regioman Press

1	Switch OFF the supply power.
2	Disconnect the module RTI 3 module.
3	Connect the ROD-3 module.
4	Connect the new DPO-1 card and check the jumper position must be on WRE.
5	Connect the cable to laptop and new DPO module.
6	Switch ON the supply power.
7	Open the Hyper terminal.
8	New connection window open. Type the name and select the COM1.
9	Setting of connection window open.
10	Follow procedure of A of page 2.
11	Press Reset button onthe new DPO-1 module.
12	Display B of page 3.
13	Give the speed 0 5 (5000) on the ROD-3 module by toggle switch.
14	Display C of page 3.
15	Type MONI for selection of program DPO-1, it is necessary.
16	Display D of page 3.
17	SIGNAL-NUMBER : 00 display, then type the 00.
18	SETTING OK? (Y/N) display, then type Y.
19	END display.
20	Press CTRL-E for display press speed.
21	Display E of page 4.
22	Press CTRL-R for reset counter.
23	Display F of page 4.
24	Press CTRL-D for clear reset-counter.
25	Disconnect into Hyper terminal.
26	Switch OFF the supply power.
27	Remove the ROD-3 module.
28	Connect the RTI 3 module.
29	Switch ON the supply power.

Procedure for Replacement of Turner Bar Encoder of Regioman Press

        1. Switch Off M Drive power (24 V) from drive cabinet

        2. Disconnect Encoder connector from M Drive

        3. Hold roller from other side and remove Encoder

        4. Connect New Encoder and encoder connector

        5. Switch ON power

        6. Go to Baudis PC and restart sercos ring (MLC Section)

        7. Go to the Drive cabinet and Connect Calibration keypad

        8. Switch ON test mode for particular drive

        9. On Calibration keypad, orange light indicates no safe stop and green   light indicates safe stop

       10. Press button for Latch position (bottom button) - sound comes and button light starts   flashing

        11. After some time press latch button again

    12. After some time light on latch button goes Off –it means latching finished

 13. No need to do calibration

 14. Note: Latching is required for Turner bar, Plow folder, Folder Superstructure motors

 15. Switch Off test mode

 16. Remove Calibration keypad

Manual of Oil Pressure Switch of IFM Make

Setting of Oil Pressure Switch of Units of Regioman Press

--------------------------------------------------------------------

SP1 1,8bar
rP1 0,8bar
OU1 Hno
COF 0
dS1 0
dr1 0
dAP 500
diS d2
Uni bar

1

Procedure to take back up of UC 100 flash cards of Regioman Press

1.  Connect laptop to machine network

2.  Open Total Commander Software

3.  On the Left side of the window select the particular UC/HMI of

     which backup has to be taken

4.  Highlight right side file path.

5.  Click on Connect to FTP icon in the panel window

6.  New window opens “Connect to FTP Server”

7.  Select Unit number and click on Connect button

8.  All files inside the flash card of UC-100 are displayed on the

     Right side of the window

9.  Select All Files of the flash card (right side) and press  F5 for

     copying

10. New window opens and it asks for storage location for the files

11. Confirm the selected location and press OK

12. Select Overwrite all

13. File copying starts

14. After copying is finished click on Disconnect tab in panel

      window

Upload and Download Parameter of Lenze 8200 Vector

01 Press right arrow button

02 Press 1<->2 button             Display: 1 flashing

03 Press right arrow button               Display: USER ^0001000 flashing

04 Press up arrow button                  Display: ALL ^0002000 flashing

05 Press 1<->2 button             Display: 0 ^0001000 flashing

06 Press up arrow button                  Display: 0 ^0002000 flashing

07 Press right arrow button               Display: 0 flashing ^0002000

08 For Upload:

    
Press 20times up arrow button    Display: 20 flashing ^0002000

     
For Download:

     
Press 10times up arrow button    Display: 10 flashing ^0001000

09 Press Enter button                         Display: for Upload: Save

                                                                          for Download: Load

10 Restart the drive

Now the follow steps to identify the right motor

• Make conveyor belt 1 in operating panel
• After down loading follow these steps:

01 Press Stop button

02 According steps 1 to 5 Up/Download (complete steps 1 to 5 up/down load)

03 Press up arrow button until u gets the parameter 148    Display: 0 ^0148000 flashing

04 Press right arrow button               Display: 0 flashing ^0148000

05 Press up arrow button                  Display: 1 flashing ^0148000

06 Press Enter button

07 Start the belt from the DCP-2 panel

08 Press Run button                           Display: The Imp Symbol goes off for ~ 10sec

09 Restart the drive

10 Steps 1-3 again but go to parameter 015 and change from 50 to 87Hz by pressing right

      arrow

11 Restart again

Manual of Oil Flow Switch of IFM

1

Setting oil flow switch of units of Regioman Press

- Switch on the oilpump

- Press the right arrow button and hold it on

- LED 9 is on, and after 5sec its flashing

- Release the right arrow button

- Now the switch is set to the right flow

Manual of Air Pressure Switch (NORGREN HERION)

Pressure Switches Series 33D

Setting air pressure switch units regioman
------------------------------------------
SP1 6,05bar
rP1 6,00bar
SP2 5,05bar
rP2 5,00bar

1

Programming Lenze Drive 9300 Series Main, Aux and Pick Up G2G3G4 by Keypad

1. Press Program key
2. Press Left Arrow(user mode) key
3. Press Up Arrow (code list) key
4. Press Right Arrow(enter) key
5. Use Up and Down Arrow keys to see different parameters
6. To change parameters first go to parameter no. C002
7. Initially the C002 parameter is always 1. if we want to change the parameters, then first we have to make C002 as 0 otherwise it does not allow to change parameters.
8. But be careful because once we make C002 as 0, all the parameters in the drive goes to factory set values. i.e. default values
9. Then go to the parameters we want to change as per our requirement (press “Shift + Program” key for fast switching between parameters)
10. Press Program key to set new value( set new values using Up and Down Arrow keys)
11. To save the new value press “Shift + Program” key, then OK message appears on the display.
12. Again press program key to return to last menu
13. After changing all  parameters, go to C003 parameter
14. Make C003 parameter as 1 to save and load all changes we made.

Downloading Software to PanelWare(PW) of Muller Martini

1. Remove cable from port-2
2. Connect RS-232 cable to laptop
3. Open Download Tool software (installed in the laptop)
4. Click on OPEN PROJECT option and select “NGR3_PW.dip” file and press OK
5. Path for NGR3_PW.dip file:- C:\Daten\MMVZ\DLT\CFG
6. Computer will ask for drive 1/4
7. Insert floppy disk 1/4 and press OK and wait for next message
8. Again Computer will ask to load disk 2/4.
9. Insert floppy disk 2/4 and press OK and wait for the next message
10. Message-switch off the panel, (disconnect the power supply)
11. Message-connect the RS-232 cable to port-0 of the panel(connect the cable to port-0)
12. Message-turn mode switch of the panel to position-6(turn mode switch to position-6 from original position-5)
13. Message- switch on the panel(connect the power supply)
14. Message-reset the panel(press reset button on the panel)
15. New window appears on the screen and it showing

Try connection…….

Start download …… (0%....97%)

(Window will close automatically after download finish)

 wait for the next message

16. Message-turn mode switch to position-7( turn mode switch to position-7)
17. Press OK.
18. Message-press reset button at panel( press reset button and press OK)
19. New window “Project Wizard” appears on the screen           
20. In project wizard window select the Application download option and press START button.
21. New window “State Window” appears on the screen and it will confirm some actions.
• check cable connected (recheck and press OK)
• check mode position-7 (recheck and press OK)
• check press reset button at panel (if reset button was pressed in step no-17 then no need to press it again, press OK)
22. Communication between computer and panelware starts
23. Downloading starts.
24. Wait for 10-20 minutes and next message
25. Message-Turn Mode Switch to position-5( turn switch to position-5 & press OK)
26. Message-Press Reset button( Press reset button & press OK)
27. Green message comes on the Download tool window-it means download application finished successfully.
28. Then disconnect power and connect port-2 cable and connect power again
29. Restart the whole system.
30. Software installation Finished.

Programming Lenze Drive 9300 Series Main, Aux and Pick Up G2G3G4 by Laptop

	TO TAKE BACKUP FROM LENZE DRIVE TO LAPTOP
1	Connect LECOM to drive and RS232 cable to Laptop
2	Connect 24 Vdc supply to connector no. 39(-) and 59(+)
3	Open GDC ( Global Drive Controller) software from desktop
4	It starts searching, 'IF not' Press F4 and then F2, select search
5	Automatically reading parameter from drive
6	Short commissioning 93XX window open
7	Select code list
8	Select Drive parameters and select write all parameters set to "File"
9	Type file name e.g. 05ngr1.GDC and check the saving path.
10	Press OK
11	Select F4 before quit the program GDC
12	Please check saved file in saving path positon.
	TO TAKE BACKUP OF LENZE DRIVE AT FOLDER A AND B
1	Put jumper in 2 and 3 then connect LECOM
2	Follow above 1 to 12 steps
	TO TAKE BACKUP FROM LAPTOP TO LENZE DRIVE
1	Connect LECOM to drive and RS232 cable to Laptop
2	Connect 24 Vdc supply to connector no. 39(-) and 59(+)
3	Open GDC ( Global Drive Controller) software from desktop
4	It starts searching, 'IF not' Press F4 and then F2, select search
5	Automatically reading parameter from drive
6	Short commissioning 93XX window open
7	Select Drive parameters and select read all parameter set from file
8	Read parameter set from file window open, select the file to be load, press OK
9	GDC warning window open, Press Yes, Code list display on window
10	Select drive parameters and select write all parameter set to drive
11	Warning parameter set transfer window open, Press OK
12	Transfer variant selection-parameter set to drive window open
	Press exchange unit
13	Parametersatztransfer window open
14	Start writing parameter to drive, after finish
15	Press F4
16	Close GDC
17	OFF/ON the power of drive
	UPLOAD AND DOWNLOAD PARAMETER FROM 2 IN 1 PLC TO PC
1	Connect 24 VDC supply to connector no. 3(-) and 2(+)
2	Connect cable to RS232 and PC
3	Choose program PVI
4	Transfer pvi file
5	Select execute.
6	Downloading starts
7	Finish successfully
8	Path D:mullermartini\_mm software 2009\2 in 1\2 in 1 transfer