How can the Load drawn by a set of lights be less than the total rating?

I have a set of lamps, around 200 LED tubes all rated at 20watts each, another set of around 100 LED lights rated at 17watts each and some other LED lamps on the same circuit. The total rated kWh consumption should be in the region of 9.5kWh. My data loggers are only reading 6.5kWh. Power factor is 0.97, volts are 220 to 230. The lights are burning brightly as test to their rated lux.

There are various circuits feeding the lamps, all off the same DB, which is in turn fed from the Main site DB.

How can the Load only be 2/3 of what it should be? We have had two sets of data capture from 2 different teams.

Many thanks

You have not specified the consumption of the some other LED lamps on the same circuit...
200 LED tubes of 20 W each = 4000 W (4 kW)
100 LED lights of 17 W each = 1700 W (1.7 kW)
Total = 5.7 kW, which, over an hour equals 5.7 kWh. So the logged reading of 6.5 kWh seems to be correct considering a PF of 0.97 and factoring in the unknown LED lamps.

You need to let the lamps run for at least an hour to know the actual energy being consumed. The kWh that you get for less than one hour will be less than the expected value. kWh = kW x hours

Sorry I was lazy. Here you go:

123 x 1 x 22w LED T8
62 x 1 x 18w LED T8
24 x 1 x 10w LED T8
152 x 17w LED
c. 100 x 1 x 10W LED

Based on this, the total load is about 7.65kW. With a PF of 0.97 the actual kVA drawn from the mains will be about 7.9kVA. However since the meter is only reporting kWh and not kVAh, the reading should be around 7.65kWh when the lights are run for exactly 1 hour.

Assuming that you are measuring the kWh after exactly an hour, the lower reading to me would appear simply because the lamps are drawing less than the stated power. In other words the lamp will draw a maximum power not exceeding the stated rating.

I agree with Rohit's last comment.

The specified power rating of some electrical equipment is not necessarily precise, it may be a maximum, and individual units may take somewhat less.

Have you tested some of the lamp units individually, to discover the actual power they are taking ?