Page 1 of 1
Is this PB file working?
Posted: Tue Dec 11, 2007 2:44 am
by yesok
Hello,
Could someone confirm that this PB file(see
https://www.hifi-remote.com/forums/dload ... le_id=1398) is working file?
Under Korean and Spanish version of MS Excel 2003, PB 4.0 and 3.12 shows on the upper right corner rows of #NAME?. It is the same whether Use Assembled Protocol Code is selected or not.
Yesok Yoon
Posted: Tue Dec 11, 2007 2:26 pm
by The Robman
It opens fine for me using PB 4.0, but I did notice that the line breaks were corrupted in the file, so I fixed that.
If you want to re-create the file using the Korean Excel, here are the settings...
Remote Type: S3C8 Generic Code
Protocol ID: 01 99
Frequency (Khz): 38.400
Duty Cycle %: 33
Signal Structure: dev-cmd
[Device] Bytes: 2
Bits/Dev1: 6
Bits/Dev2: 6
Dev Bit Doubling: None
[Command] Bytes: 1
Bits/Cmd: 8
Cmd Bit Doubling: None
[Repeat] Value: 3
Type: Minimum
Hold: Yes
[Check Byte] Style: None
# Bytes Checked:
Mini-Combiner: None
['1' Burst] ON (uSec): 564
OFF (uSec): 1692
['0' Burst] ON (uSec): 564
OFF (uSec): 564
Xmit '0' Reversed: No
[Lead-In] Style: Same every frame
Burst Mid-Frame: No
After # of bits:
[Lead-In] ON (uSec): 4512
OFF (uSec): 4512
[Lead-Out] Style: 2 = [OneOn, -LO]
[Lead-Out] OFF (uSec): 58617
OFF as Total: Yes
Posted: Tue Dec 11, 2007 8:56 pm
by binky123
I believe the issue is that the Assembly Tabsheet doesn't have any S3C8 assembly code to include but I'm not really sure. I also am seeing #NAME? sprinkled in various cells with this PB file.
Upgrade codes
Posted: Tue Dec 11, 2007 11:46 pm
by yesok
Hello Robman,
The Robman wrote:It opens fine for me using PB 4.0, but I did notice that the line breaks were corrupted in the file, so I fixed that.
Do you mean you have proper upgrade codes displayed in the upper right corner of PB?
If yes, could you send me the upgrade code?
Yesok
Excel version
Posted: Tue Dec 11, 2007 11:50 pm
by yesok
Hello Binky.
binky123 wrote:I believe the issue is that the Assembly Tabsheet doesn't have any S3C8 assembly code to include but I'm not really sure. .
Is this normal?
Is the generation of S3C8 assembly code automatic?
binky123 wrote: I also am seeing #NAME? sprinkled in various cells with this PB file.
You have same result with me.
May I ask the version of Excel you are using?
Yesok
Re: Excel version
Posted: Wed Dec 12, 2007 2:57 pm
by mr_d_p_gumby
yesok wrote:binky123 wrote:I believe the issue is that the Assembly Tabsheet doesn't have any S3C8 assembly code to include but I'm not really sure. .
Is this normal?
Is the generation of S3C8 assembly code automatic?
No, it is not normal. The generation of S3C8 assembly code is not automatic. Checking the Use Assembled Code box when no assembled code is available will simply cause an error message (Assembled Code Not Available), and the generated code will display in the code box.
yesok wrote:binky123 wrote: I also am seeing #NAME? sprinkled in various cells with this PB file.
You have same result with me.
May I ask the version of Excel you are using?
Curious. I've checked this file with XL97, XL2K & XL03, and I don't get any #NAME? errors.
yesok wrote:If yes, could you send me the upgrade code?
You don't mention what type of remote you are using, but assuming you need the S3C8+ code:
Code: Select all
Upgrade protocol 0 = 01 99 (S3C8+) Samsung-20 (PB v4.00)
43 89 21 8B 14 C7 55 06 08 01 1A 03 3A 01 1A 01
06 72 7C 08 D0 08 BC FF 03 8D 01 46
End
Posted: Wed Dec 12, 2007 3:41 pm
by binky123
I fixed my problem by doing Tools->Add-Ins->Analysis Toolpak and loading in the Toolpak for functions such as HEX2DEC(). Now, I don't see the #NAME? in the cells anymore on startup or when loading this PB file.
Me too
Posted: Wed Dec 12, 2007 8:44 pm
by yesok
Hello Binky,
binky123 wrote:I fixed my problem by doing Tools->Add-Ins->Analysis Toolpak and loading in the Toolpak for functions such as HEX2DEC(). Now, I don't see the #NAME? in the cells anymore on startup or when loading this PB file.
I did the same and have same result as you with Korean Excel and Korean MS Win XP. But file save is not possible with Korean Excel/Win XP environment.
Yesok
Posted: Thu Dec 11, 2008 2:53 am
by madmattla
I fixed my problem by doing Tools->Add-Ins->Analysis Toolpak and loading in the Toolpak for functions such as HEX2DEC(). Now, I don't see the #NAME? in the cells anymore on startup or when loading this PB file.
Same here.
I think this should go into PB readme, or at least in a sticky ...
I have had my arse bitten from this same issue ... took me all of a night, three excel installs (I started with excel 2002 English, tried 2003 Italian and 2003 English ...) to no avail until I stumbled over this post, just minutes from posting a silly question and wasting people's time ...