BMS Key File Editor (Excel) has Problems with Third and Fourth MFD
-
Hi all,
first of all: The Key file from Kolbe is a great utility! I’ve been using it for some years now - even the 4.32 version was great. Especially because BMS lacked the Device Sorting support back then.
Now on to my problem:
I want to configure a third and fourth MFD. While BMS doesn’t have ingame support for the corresponding Callbacks yet, I’d use it for commands like “HSDCourseInc” / “HSDCourseDec” etc. Unfortunately it doesn’t work. The Key file contents won’t be generated in the “Output” page. I’ve tried it with Excel 2010, Excel 2016 and LibreOffice.Steps to reproduce:
- Open the BMS Key File Editor (with Excel)
- Set the locale (German in my case)
- Set “TM Combos” as devices 1 and 2
- Set “T&F MFDs” as devices 3 and 4
- Switch to the “Output” Page and scroll down to Row 1149 - all rows show “#BEZUG” (which is a Formula Error)
The “debugging” functions of Excel won’t help me to track down the problem.
I’ve attached two screenshots:
The DX Editor:
Errors on the Output page:
Additionally I’ve provided the Excel file in my OneDrive account:
https://1drv.ms/u/s!Atn64cdt5O9ypnUUXHSPb6wTVJ8lI’ve used a untouched Excel file from the BMS installation. Didn’t change anything else apart from the steps outlined above.
I would be very grateful if someone could help me or fix the Excel file - maybe even provide a Patch withe the next BMS update if possible or necessary.
Have a Falcon day & thanks in advance,
Sneakpeek -
Confirmed.
Typical copy paste error on my part.
Will be fixed in the next release.Meanwhile:
- Go to “DX Settings” Tab
- Remove Sheet protection
- delete the complete(!) line 1264
- enable sheet protection
- save
Thanks for pointing this out.
-
Wow, it worked! Thank you Kolbe!
Ready to go now!Well - line 1264 … Computers … -I’ll dig deeper into this spreadsheet to figure out where the bug is actually located.
Confirmed.
Typical copy paste error on my part.
Will be fixed in the next release.Meanwhile:
- Go to “DX Settings” Tab
- Remove Sheet protection
- delete the complete(!) line 1264
- enable sheet protection
- save
Thanks for pointing this out.