Sharing My NVR / HDD Monitoring Spreadsheet (MacOS)

slicker55

Here is a spreadsheet I created using macOS Numbers to monitor usage of NVR / HDD storage capacity.
[size=1][/size]
The default settings appertain to my specific system but these settings can be easily changed to accommodate other system setups.
[size=1][/size]
My system consists of 1 x NVR, 2 x 4TB HDD’s and 8 x PoE cameras recording 24/7
[size=1][/size]
Specification:
[size=1][/size]
NVR:
1 x RLN8-410 (e)
2 x HDD (Western Digital Purple 4TB)
1 x eSATA enclosure
[size=1][/size]
Cameras:
6 x B800 (8MP )
1 x D800 (8MP)
1 x RLC-420 (5MP)
[size=1][/size]
Configuration:
[size=1][/size]
All cameras recording 24/7
[size=1][/size]
Resolution, Frame Rate and Bitrate of each camera set to maximum values
[size=1][/size]
Audio enabled on one B800 (8MP) camera
[size=1][/size]
Additional settings will be provided on request
[size=1][/size]
Reolink Software:
[size=1][/size]
MacOS Desktop Client (required to monitor HDD free space)
Substitute references to Reolink according to your preferred software
[size=1][/size]
Realtime Testing
[size=1][/size]
The spreadsheet was used to monitor realtime tests until there was no more free space available on the HDD’s (17 days)
[size=1][/size]
The HDD’s were then reinitialised prior to above test being repeated
[size=1][/size]
The results of these two tests was consistent (17 days) verified by the dates (highlighted in green) in the 'Playback Calendar' of the Reolink MacOS Desktop Client
[size=1][/size]
How does the spreadsheet work?
[size=1][/size]
The spreadsheet contains formulas which calculate the number of days the system will continuously record before the earliest recording is over-written.
[size=1][/size]
By default, this is set to 7424
[size=1][/size]
This value relates to the combined HDD storage capacity (GB) after initialisation on my specific system.
[size=1][/size]
However, this value can be changed by double-clicking on Cell H2.
[size=1][/size]
By default, the number of rows will accommodate 21 days but this can be adjusted by adding or deleting rows accordingly.
[size=1][/size]
What do I have to do?
[size=1][/size]
Day 1
[size=1][/size]
Open Reolink
Make a note of what each HDD is called for easy identification later
Initialise your HDD’s
Immediately after initialisation, make a note of available free space of each HDD (current value)
[size=1][/size]
Open Spreadsheet
Double-click on Cell B2 - enter current date and time
The date and time you enter will be automatically copied to the cells below and will require no further maintenance
Double-click on Cell E2 - enter current value for HDD1
Double-click on Cell F2 - enter current value for HDD2
[size=1][/size]
Day 2
[size=1][/size]
Open Reolink
Make a note of available free space of HDD1 (current value)
The available free space on HDD2 should remain unchanged at this stage
[size=1][/size]
Open Spreadsheet
[size=1][/size]
Double-click on Cell C1 - enter current date and time
Double-click on Cell E2 - enter current value for HDD1
[size=1][/size]
Other cells will populate automatically and the number of days the system will record will be displayed in the end cell in column K
[size=1][/size]
Subsequent Days
[size=1][/size]
Open Reolink
Make a note of available free space for the active HDD (current value)
The available free space on HDD2 should remain unchanged at this stage
[size=1][/size]
Open Spreadsheet
[size=1][/size]
Double-click on next available ‘End Date’ Cell - enter current date and time
Double-click on next available ‘HDD1’ Cell - enter current value for HDD1
[size=1][/size]
Other cells will populate automatically and the number of days the system will record will be displayed in the end cell in column K
[size=1][/size]
What do I do when the HDD1 is full?
[size=1][/size]
Open Reolink
Free space on the HDD1 should read (0)
The system will now be writing to HDD2
Make a note of available free space on the HDD2 (current value)
[size=1][/size]
Open Spreadsheet
[size=1][/size]
Double-click on next available ‘End Date’ Cell - enter current date and time
Double-click on next available ‘HDD2’ Cell - enter current value for HDD2
[size=1][/size]
Other cells will populate automatically and the number of days the system will record will be displayed in the end cell in column K
[size=1][/size]
Update daily until HDD2 is full
[size=1][/size]
Testing is complete
[size=1][/size]
Delete any unused rows
[size=1][/size]
The average number of days is highlighted in green
[size=1][/size]
[size=1][/size]
[size=1][/size]
Adding Rows:
[size=1][/size]
Highlight Row 22
[size=1][/size]
Click on ‘Add Row Below’
[size=1][/size]
Row 23 will appear
[size=1][/size]
Click on Cell B21
[size=1][/size]
Press and Hold Shift Key (Arrow Up)
[size=1][/size]
Click on Cell B21
[size=1][/size]
Release Shift Key (Arrow Up)
[size=1][/size]
A blue rectangle highlights the selected cells
[size=1][/size]
Hover the mouse pointer over the centre of this rectangle
[size=1][/size]
When a yellow dot appears on the bottom line of the rectangle, hold your mouse button down and pull the rectangle downwards
[size=1][/size]
This will copy the data and formulas to the row below
[size=1][/size]
Double-click on the bottom cell in Column K (Total Days)
[size=1][/size]
The currently selected cells are highlighted and there is a circle in the bottom right-hand corner
[size=1][/size]
Hover the mouse pointer over the circle and pull the rectangle downwards to include the new cell
[size=1][/size]
Click the green ’tick’ button to confirm the change
[size=1][/size]
Finally, add the next sequential value in the ‘Day’ column (Cell A23)
[size=1][/size]
[size=1][/size]
All done - I hope these instructions were not too confusing - I will do my best to answer any question?
[size=1][/size]

slicker55

NVR / HDD Monitor (V1.0)
[size=1][/size]

[size=1][/size]
[size=1][/size]
slicker55

slicker55

Cynthia,
[size=1][/size]
I have uploaded the spreadsheet (219KB) but it isn't available for others to download?
[size=1][/size]
Will you have a look at this please?

Cynthia

Hi, thank you for your feedback, and sorry for the inconvenience. we have forwarded this issue to our engineer to check, we will see if it's possible to fix this issue as soon as possible.

slicker55

Apologies to anyone who has been waiting to download the spreadsheet.
[size=1][/size]
The spreadsheet cannot be uploaded to the forum because it is in Mac format (.numbers)
[size=1][/size]
Where there's a will, there's a way!
[size=1][/size]
Here is a workaround...
[size=1][/size]
I have appended .jpg to the end of the filename to 'fool' the system.
[size=1][/size]
You can now download the spreadsheet but you will need to remove the .jpg before opening it.
[size=1][/size]
Some users may not be familiar with this process, so I have prepared a series of 10 screenshots.
[size=1][/size]
Hope this helps - enjoy!
Reolink-NVR-HDD-Monitor-V1.0.numbers.jpg
step1.jpg
step2.jpg
step3.jpg
step4.jpg
step5.jpg

slicker55

... and screenhots 6-10
step6.jpg
step7.jpg
step8.jpg
step9.jpg
step10.jpg

timbercreek

First, convert it, for those of us that use excel. -> https://cloudconvert.com/numbers-to-xls
Second, upload it, -> https://gofile.io/?t=uploadFiles
Third, share download link -> https://gofile.io/?c=ikR6ii

timbercreek

I'm curios to see this spreadsheet, I have 16 cameras filling up my drives!

slicker55

From a personal point of view, this spreadsheet has now served it purpose and I have no further use for it.
[size=1][/size]
Feel free to convert it - no point in me trying as I am a Mac user and have no way of testing it

timbercreek

The issue is downloading, as your .jpg does not function for windows users. Upload it and paste the dl link.
I have never used a mac, curious to see if a conversion keeps functionality.

slicker55

This file is not intended for windows users
[size=1][/size]
I can tell you that in the past I have tried exporting Mac spreadsheets to Excel format and embedded formulas haven't worked properly afterwards.
[size=1][/size]
Please don't keep on at me... I'm sharing the file as is and that's it!

jenaericaca

That's great information I was looking for, can you share more about it. girls games