8/2/2019 Plc Data Logger (Version 1)

1/32

INCOMING VALUE 1 > 1

INCOMING VALUE 2 > 2

INCOMING VALUE 3 > 3

INCOMING VALUE 4 > 4

INCOMING VALUE 5 > 5

INCOMING VALUE 6 > 6

INCOMING VALUE 7 > 7

INCOMING VALUE 8 > 8

INCOMING VALUE 9 > 9

INCOMING VALUE 10 > 10

CON

DESCRIPTION :

This file was created with the int

logging a continuous data strea

PLC at a high rate using a macr

minimum speed the data will cha

cell is determined by the DDE lin

rate that the data in the cell can

and logged is determined by the

in the macro.

The macro checks the incoming

sheet 1, and records each value

determined by the speed setting

INSTRUCTIONS:

1. Create a Hot DDE link to the d

logged, linking only to the follo

B3,B6,B9,B12,B15,B18,B21,BNote: If data is not to be logge

these cell, it can be left blank.

prevents a whole column of u

data being written

2. Change the rate of logging in

( Sheet 1 > "Timer Seconds =

The minimum value that can

here is 0.001 ( 1 millisecond )

In reality you will never get it t

fast.

3. Save and close the file, and th

Enable macros and click "Star

4. This data can now charted.

Tip: Select a column in any sh

and press F11 to create an in

the recorded data.

Cells with text "Incoming Value"

START

STOP L

8/2/2019 Plc Data Logger (Version 1)

2/32

respective sheet can be rename

friendly names

Feel free to modify, copy, chang

or improve in any way you want.

Contact: aaron@gloriavale.co.nz

8/2/2019 Plc Data Logger (Version 1)

3/32

8/2/2019 Plc Data Logger (Version 1)

4/32

8/2/2019 Plc Data Logger (Version 1)

5/32

8/2/2019 Plc Data Logger (Version 1)

6/32

8/2/2019 Plc Data Logger (Version 1)

7/32

ROL

ntion of

from a

. The

nge in the

k, but the

e copiedspeed setting

values on

onto its respective sheet at a rate

in the macro.

ata to be

wing cells.

24,B27,B30d on one of

This

wanted

the macro.

1 " )

e entered

.

o write that

en reopen.

t Logging"

eet

stant chart of

and their

OGGING

OGGING

8/2/2019 Plc Data Logger (Version 1)

8/32

with user

, deconstruct

8/2/2019 Plc Data Logger (Version 1)

9/32

8/2/2019 Plc Data Logger (Version 1)

10/32

8/2/2019 Plc Data Logger (Version 1)

11/32

8/2/2019 Plc Data Logger (Version 1)

12/32

8/2/2019 Plc Data Logger (Version 1)

13/32

VALUE 1

1

8/2/2019 Plc Data Logger (Version 1)

14/32

8/2/2019 Plc Data Logger (Version 1)

15/32

VALUE 2

2

8/2/2019 Plc Data Logger (Version 1)

16/32

8/2/2019 Plc Data Logger (Version 1)

17/32

VALUE 3

3

8/2/2019 Plc Data Logger (Version 1)

18/32

8/2/2019 Plc Data Logger (Version 1)

19/32

VALUE 4

4

8/2/2019 Plc Data Logger (Version 1)

20/32

8/2/2019 Plc Data Logger (Version 1)

21/32

VALUE 5

5

8/2/2019 Plc Data Logger (Version 1)

22/32

8/2/2019 Plc Data Logger (Version 1)

23/32

VALUE 6

6

8/2/2019 Plc Data Logger (Version 1)

24/32

8/2/2019 Plc Data Logger (Version 1)

25/32

VALUE 7

7

8/2/2019 Plc Data Logger (Version 1)

26/32

8/2/2019 Plc Data Logger (Version 1)

27/32

VALUE 8

8

8/2/2019 Plc Data Logger (Version 1)

28/32

8/2/2019 Plc Data Logger (Version 1)

29/32

VALUE 9

9

8/2/2019 Plc Data Logger (Version 1)

30/32

8/2/2019 Plc Data Logger (Version 1)

31/32

VALUE 10

10

8/2/2019 Plc Data Logger (Version 1)

32/32