Is this PB file working?

[yesok]

Hello,

Could someone confirm that this PB file(see http://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

[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

[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.

[yesok]

Hello 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.

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

[yesok]

Hello Binky.

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?

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

[mr_d_p_gumby]

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.

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.

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

[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.

[yesok]

Hello Binky,

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

[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 ...