InterceptRadio.com Forums

The radio website that doesn’t support communism.
It is currently Thu Mar 28, 2024 10:56 pm

All times are UTC - 8 hours


Forums       Map Search       Database Search       Live Audio       Alerts       Wiki




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Graphing radio usage
PostPosted: Sun Apr 09, 2017 11:35 am 
Offline

Joined: Thu Apr 08, 2004 7:10 pm
Posts: 123
I have DSD+ data dumped into excel. I want to make a graph illustrating how busy the repeater is.

how do I do it?


Attachments:
radio usage.png
radio usage.png [ 30.87 KiB | Viewed 1224 times ]
Top
 Profile  
 
 Post subject: Re: Graphing radio usage
PostPosted: Sun Apr 09, 2017 5:38 pm 
Offline

Joined: Mon Jan 03, 2005 1:17 am
Posts: 2591
Location: Not Gulfport
Nice try, but the data you suggest is nothing related to a system's capacity -- only that this channel was active at X:XX time. You'd need to dump the CC log into a text file and parse any relevant data. Then you'd have to find data that would prove your "system capacity usage" theory -- so the on/off time of each voice channel -- and then map the times that those channels are active.

It's not impossible but it's a lot more complex than you think. Also, I'm not even sure if DSD provides a "TIME OFF" value.


Top
 Profile  
 
 Post subject: Re: Graphing radio usage
PostPosted: Sun Apr 09, 2017 5:44 pm 
Offline

Joined: Mon Jan 03, 2005 1:17 am
Posts: 2591
Location: Not Gulfport
The data you suggest could be used to "imply" that X channel most active at X:XX time of day (in a 24 hour period) -- however, it's not capacity or time usage -- it'd be more like "channel hits" at X:XX time of day. I guess that would indirectly imply that there's voice activity on X channel.

So instead of a graph, you'd be looking more at a "heat map" kind of layout. (Except that the red color would indicate the most traffic...)

Something like this:

Image

The data values on the left would represent "hits per hour" on X voice channel... but you'd have to do it for each voice channel. This is where it gets more complex... ;o)


Top
 Profile  
 
 Post subject: Re: Graphing radio usage
PostPosted: Fri May 12, 2017 1:29 pm 
Offline

Joined: Thu Apr 08, 2004 7:10 pm
Posts: 123
Solved.
I figured it out.

Convert the time to an integer INT
Use a pivot table to Count vs Integer.
Than just graph what the pivot table spat out

this video helped a ton
https://www.youtube.com/watch?v=BvUwyP6oUYg

Attachment:
radio use.JPG
radio use.JPG [ 67.64 KiB | Viewed 1099 times ]


Top
 Profile  
 
 Post subject: Re: Graphing radio usage
PostPosted: Fri May 12, 2017 3:21 pm 
Offline

Joined: Mon Jan 03, 2005 1:17 am
Posts: 2591
Location: Not Gulfport
What exactly are you using for your Y data?


Top
 Profile  
 
 Post subject: Re: Graphing radio usage
PostPosted: Sun May 14, 2017 1:39 pm 
Offline

Joined: Thu Apr 08, 2004 7:10 pm
Posts: 123
DSD+ spits out a "DSDPlus.srt" file

it contains an entry for every second the repeater is lit up:

22003
06:06:42,000 --> 06:06:43,000
2017/03/22 07:24:00
-DMR CC=11 Slot 1
---

22004
06:06:43,000 --> 06:06:44,000
2017/03/22 07:24:00
-DMR CC=11 Slot 1
---

22005
06:06:44,000 --> 06:06:45,000
2017/03/22 07:24:01
-DMR CC=11 Slot 1
---

22006
06:06:45,000 --> 06:06:46,000
2017/03/22 07:24:02
-DMR CC=11 Slot 1
---

22007
06:06:46,000 --> 06:06:47,000
2017/03/22 07:24:03
-DMR CC=11 Slot 1
---


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 11 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by electricity. Copyright © 2013 Interceptradio.com