glgermain wrote:... it's fairly confusing for someone new like me. I understand the concept, but I need to figure out where in the software I can assign obc numbers to keys.
OK then, here's a "step by step". This will appear long winded because I'm leaving nothing to chance by assuming that you know nothing about KM or Excel. Please don't be insulted by this.
1. Fire up the KM spreadsheet.
In the general Setup sheet
2. Select the URC-6131 as your remote.
3. Select DVD as the device type (as it includes the most buttons)
4. Enter 2001 as the setup code (any number will do, so I picked one for you)
5. Select NEC1 as your protocol.
6. Enter 1 as your main device code.
Assigning the function names to buttons:
7. In the buttons sheet you'll notice that some buttons are greyed out and others have the "@" symbol in front of them. The greyed out buttons do not exist on your remote and the @ buttons are not part of the DVD button set. The next step here is to make a list of the available buttons. To do this, first open up a new Notepad session, then highlight the "vol up" button name (ie, cell B13 in the Buttons sheet), then while holding the SHIFT button, highlight the "thumbs down" button name. Next, use CNTL+C to copy all the button names, then go to Notepad and use CNTL+V to paste them into Notepad. While still in Notepad, use CNTL+A to select all of the list, then go back to the Buttons sheet in Excel, click on the Function cell next to the "vol up" button (ie, cell C13) and do a CNTL+V to paste the names into the cells.
Setting up the list of function names:
8. Next, go back to Notepad and delete all the button names from the list that are greyed out or have @ signs in the Buttons sheet (such as "surround" and "pip"). Now, that the list is reduced to just the function names that are active in DVD mode, so another CNTL+A in Notepad to select them all, then go back to the Functions list in KM, click on the "vol up" function name cell (ie, cell A12), and do a CNTL+V to paste the function names into the list.
Entering the OBC numbers:
9. Click the OBC button to put KM into "OBC" mode.
10. Then enter 0 in the OBC column for the "Num 0" function (ie, cell B2).
11. Enter the following formula into cell C2 "=B2+1" (without the quotes) and tab out.
12. Click on cell B2. Then, while holding down the SHIFT key, click on the OBC cell for the "thumbs down" function (which should be cell B46).
13. Do a CNTL+D (fill down) to populate all of these cells.
So far, what you have just done is create an upgrade file that places OBCs 0 thru 44 onto every button that's available in DVD mode using the URC-6131 remote. Given that we've decided that you're unlikely to find any working functions in the 32-63 OBC range, let's eliminate them from the list that you've just created. To do this, go back to the list and find the cell in the OBC column that displays 32 as it's value. This should be the "stop" entry. Type over that value with 64, which is where we want to pick up the search, and tab out. This should automatically change the rest of the entries to use OBCs 64-76.
14. Now, go back to the Setup tab and enter a description in the F2 cell, let's call it "Dlink test 1".
15. Now, click on the SAVE button (just below where you entered the description) and save the file on your harddrive somewhere (somewhere where you can find it later). You can also cut & paste the generated upgrade over to IR at this point.
Now let's start preparing the 2nd test upgrade
16. Type 2002 into cell C4 as the setup code.
17. Change the description to "Dlink Test 2"
18. In the Functions tab, type 77 in the OBC cell for "num 0" (cell B2)
19. Enter formula "=B2+1" in cell B3.
20. Do a "fill down" to cell B46.
21. To skip OBCs in the range 96-127, find the cell that displays 96 as it's value (which should be the "menu" entry in cell B21) and type 128
22. Go back to the Setup sheet and save the file. You can also cut & paste the generated upgrade over to IR at this point.
23. Back in IR you should now have 2 upgrades loaded, now you should assign them to 2 of the device buttons (let's go with DVD and VCR). Now load this file into your remote and test the buttons.
As I was typing this, I was actually doing the steps myself and the files that I created are here...
http://www.hifi-remote.com/forums/dload ... le_id=3747