Excel Macro for CRC Calculation
Budget: £20 – £250 GBP
I'm looking for a Microsoft Excel expert to create a macro-enabled workbook for me. This workbook should have the capability to calculate CRC8 and CRC16 on user-specified hexadecimal strings.
Key Requirements:
- The CRC8 polynomial is x8 + x2 + x + 1.
- The CRC16 polynomial is X16+X12+X5+1.
- The workbook should be semi-automated, meaning it prompts users at certain stages but doesn't require constant interaction.
- I want the hexadecimal strings to be inputted in user-specified cells upon execution, rather than fixed cells or a designated input sheet.
As an example, this input string 20 00 00 C1 58 99 7D 3B 9F 00 01 yields a CRC8 value of 51 (all in hex)
This input string 31 AF 20 00 00 C1 58 99 7D 3B 9F 00 01 51 yields a CRC16 value of FE 81
(both can be checked using online tools e.g. https://www.lddgo.net/en/encrypt/crc as plain CRC8 option and CRC16 XMODEM)
Ideal Skills and Experience:
- Proficient in creating macro-enabled workbooks in Microsoft Excel.
- Strong understanding of CRC calculations and polynomials.
- Experience in designing semi-automated Excel workbooks.
Key Requirements:
- The CRC8 polynomial is x8 + x2 + x + 1.
- The CRC16 polynomial is X16+X12+X5+1.
- The workbook should be semi-automated, meaning it prompts users at certain stages but doesn't require constant interaction.
- I want the hexadecimal strings to be inputted in user-specified cells upon execution, rather than fixed cells or a designated input sheet.
As an example, this input string 20 00 00 C1 58 99 7D 3B 9F 00 01 yields a CRC8 value of 51 (all in hex)
This input string 31 AF 20 00 00 C1 58 99 7D 3B 9F 00 01 51 yields a CRC16 value of FE 81
(both can be checked using online tools e.g. https://www.lddgo.net/en/encrypt/crc as plain CRC8 option and CRC16 XMODEM)
Ideal Skills and Experience:
- Proficient in creating macro-enabled workbooks in Microsoft Excel.
- Strong understanding of CRC calculations and polynomials.
- Experience in designing semi-automated Excel workbooks.