Sly UK Channels Mega Spreadsheet

B16MCC

Dreambox Gimp & Coder
Joined
Nov 16, 2005
Messages
1,562
Reaction score
8
Points
0
Age
51
My Satellite Setup
2 Dreamboxes..........
---------------------------------------------
--- DM 8000 HD PVR & DM 800 HD ---
Motek SG2100 & Triax 80cm Dual LNB
------ Fixed Dish 28e Quad LNB -------
---- Sly HD Full & 24" Apple iMAC ----
My Location
/var/tuxbox/config
As of Jan 12th 2010 any updates will be in subsequent posts and not in this first thread. For the latest version be sure to read the whole thread.

Spreadsheet Updated Again , several bug fixes. Now version 1.2

Many channel details added.
Done a little work on the CCcam SID ASSIGN code.
Picons was working but I'm not happy with it so I've disabled it for now. (Picons not in the rar, yet)

Enjoy...:-googly

--- ORIGINAL POST ---

Ok guys here's a Satellites collaborated production. This is an excel 2003 spreadsheet detailing the current Sly UK channels. It consists of information regarding the following :-

EPG No.
Channel Name.
Package.
Picture Format.
Beam.
Frequency / SR / Pol / FEC.
SID ( dec & hex )
Namespace
TSID ( dec & hex )
NID
Type
Service Reference ( Used in the Web Interface & Naming Of Picons )
lamedb Service Entry
EPG No in Hex (Experimental)
Unique ID (Experimental)
Nabilo EPG ID
Nabilo /usr/share/dict/channels.uk Reference

It was created and coded by myself.
The basic channel list details where compiled with the help of :-

Wildbit - Andel - Oakey22 - Vampsthevampyre

So a huge thanks to those guys for the help.

So what does this spreadsheet do for us ?

  • It will show the full details of a channel selected from a drop down box list.
  • It will display the service reference which you need to name your picons.
  • It will create the Nabilosat channels.uk file automatically, used for downloading the EPG from HipHop.
  • It will create a CCcam SID assignment string based on the packs you subscribe to on your card. This is used in CCcam.cfg to ensure you never receive ECM's for a service you cannot decrypt.
  • It will create a CCcam.channelinfo file automatically, used with CCcam and CCcamphpinfo to show card usage.
The sheet is very much still in development but I thought it was about time I released it as there's a lot of hard work gone in to producing it and it already has some helpful features to offer.

There's a lot of VBA code in this sheet and I've chosen not to protect it in anyway so that others can learn from how it works if they so desire.


Please check it out and let us have your feedback and any suggestions or problems you may have. Please report bacl if you have any issues opening and operating the spreadsheet properly.
 

Attachments

  • Sky UK Spreadsheet.JPG
    Sky UK Spreadsheet.JPG
    140.9 KB · Views: 173

B16MCC

Dreambox Gimp & Coder
Joined
Nov 16, 2005
Messages
1,562
Reaction score
8
Points
0
Age
51
My Satellite Setup
2 Dreamboxes..........
---------------------------------------------
--- DM 8000 HD PVR & DM 800 HD ---
Motek SG2100 & Triax 80cm Dual LNB
------ Fixed Dish 28e Quad LNB -------
---- Sly HD Full & 24" Apple iMAC ----
My Location
/var/tuxbox/config
Post bumped . Spreadsheet updated to V1.1

Several bug fixes included.
 

zoro25

Attack of the Clones
Joined
Dec 23, 2005
Messages
169
Reaction score
3
Points
16
Age
49
Website
www.thetestmanager.com
My Satellite Setup
Dreambox 800 - Nabilosat Image and 250gig Hard-drive (pointing at 28.2E)
Dreambox 7020 with 120 gig hard-drive disk - running a motorised dish
DM600 +DM500
although only usually the 800 and 7020 are both on.
My Location
UK
Thanks so much for this.
 

B16MCC

Dreambox Gimp & Coder
Joined
Nov 16, 2005
Messages
1,562
Reaction score
8
Points
0
Age
51
My Satellite Setup
2 Dreamboxes..........
---------------------------------------------
--- DM 8000 HD PVR & DM 800 HD ---
Motek SG2100 & Triax 80cm Dual LNB
------ Fixed Dish 28e Quad LNB -------
---- Sly HD Full & 24" Apple iMAC ----
My Location
/var/tuxbox/config
Post bumped. Spreadsheet updated.
Please see the original post.
 

oldfart

Regular Member
Joined
Dec 16, 2008
Messages
208
Reaction score
25
Points
28
My Satellite Setup
laminas 2.7 offset
Invacom Quattro LNB
Chayofa, Tenerife
DM8K
My Location
Tenerife
@B16MCC
Tried to sort the spreadsheet by 'beam' (so I can eliminate those beams I can't get)
got an Excel error:-
Code:
The cell range that you attempted to sort or remove duplicates from includes 
merged cells. However not all cells in the range are merged to the same size.
To complete this operation, unmerge all the merged cells in the range, or make 
each group of merged cells the same size as the largest group.
any ideas??
 

B16MCC

Dreambox Gimp & Coder
Joined
Nov 16, 2005
Messages
1,562
Reaction score
8
Points
0
Age
51
My Satellite Setup
2 Dreamboxes..........
---------------------------------------------
--- DM 8000 HD PVR & DM 800 HD ---
Motek SG2100 & Triax 80cm Dual LNB
------ Fixed Dish 28e Quad LNB -------
---- Sly HD Full & 24" Apple iMAC ----
My Location
/var/tuxbox/config
Rearranging the layout will totally screw up the spreadsheet mate. There's a lot of VB code in the workbook. Unless you're very well versed in excel I'd leave it alone.
 

fintannl

Regular Member
Joined
Jan 11, 2009
Messages
257
Reaction score
0
Points
0
Age
48
My Satellite Setup
Single Sat Dish and DM800
My Location
Ireland
Hi B16MCC, Stupid question but can the files generated be used for all versions of Nabilo or is it only Nabilo 0.12. Thanks
 

B16MCC

Dreambox Gimp & Coder
Joined
Nov 16, 2005
Messages
1,562
Reaction score
8
Points
0
Age
51
My Satellite Setup
2 Dreamboxes..........
---------------------------------------------
--- DM 8000 HD PVR & DM 800 HD ---
Motek SG2100 & Triax 80cm Dual LNB
------ Fixed Dish 28e Quad LNB -------
---- Sly HD Full & 24" Apple iMAC ----
My Location
/var/tuxbox/config
The files can be used with all images that support them. Obviously the CCcam related files are common to all images. The channels.uk file can be used certainly with BH0.12, I think 0.11 too, before that I can't remember. If you're using Nabilo then you should be on 0.12 anyway ! If you're not then you need to flash ASAP . Its an awesome image.
 

B16MCC

Dreambox Gimp & Coder
Joined
Nov 16, 2005
Messages
1,562
Reaction score
8
Points
0
Age
51
My Satellite Setup
2 Dreamboxes..........
---------------------------------------------
--- DM 8000 HD PVR & DM 800 HD ---
Motek SG2100 & Triax 80cm Dual LNB
------ Fixed Dish 28e Quad LNB -------
---- Sly HD Full & 24" Apple iMAC ----
My Location
/var/tuxbox/config
Have you used the channels.uk file created by the spreadsheet in BH 0.11 ?
If so, how does it perform ?
 

B16MCC

Dreambox Gimp & Coder
Joined
Nov 16, 2005
Messages
1,562
Reaction score
8
Points
0
Age
51
My Satellite Setup
2 Dreamboxes..........
---------------------------------------------
--- DM 8000 HD PVR & DM 800 HD ---
Motek SG2100 & Triax 80cm Dual LNB
------ Fixed Dish 28e Quad LNB -------
---- Sly HD Full & 24" Apple iMAC ----
My Location
/var/tuxbox/config
Change Log :-

Several channel additions.
Missing Beam info added.
Added the ability to sort the channel list by :-
EPG Number
Channel Name
Beam
SID
Frequency


Still do to:-
Add Picons
Some low priority channel info still missing.
 

sinjin_smythe

Member
Joined
Feb 27, 2009
Messages
29
Reaction score
0
Points
0
Age
48
My Satellite Setup
DM800 running BH v012, 2 x Sky Minidishes with DiSEqC switch pointing at Astra 28.2E and Hotbird 13E
My Location
Derry, Northern Ireland
Sweet! Exactly what I was looking for, this is brilliant!
 

CEPi

Member
Joined
May 25, 2009
Messages
6
Reaction score
0
Points
0
Age
47
My Satellite Setup
DM8000+IPBox9000HD
13e+16e+19e+28e
1.15cm Dish. 0.2db LNB
My Location
Kosova
Superb, thanks a lot mate.
 

ToneDeff

Member
Joined
Jul 30, 2009
Messages
6
Reaction score
0
Points
0
Age
97
My Satellite Setup
.
My Location
127.0.0.1
thanks for this, for some reason on XP with excel 2k3 i kept getting compile erorrs, tried on 3 different machines, had to install "comdlg32".ocx" to get it working > -http://windowsxp.mvps.org/comdlg32.htm Missing Comdlg32.ocx error while running an application

also i was hoping the channels.uk would work with WeekEPG but it doesn't seem to for me, still a very useful spreadsheet and thanks again :)
 

andyblac

Member
Joined
Mar 29, 2010
Messages
2
Reaction score
0
Points
0
Age
50
My Satellite Setup
Cube Revo HD
My Location
England
any chance you dating this for use with Office 2007 ? ihave installed the above file "Comdlg32.ocx" but it still fails, something to do with the dialog popup.

cheers
andy.
 
Top