Đã hoàn thành

Simple Function for Excell to calculate a Checksum of a string that contain a range of Bytes

I need a function for an excell worksheet that takes the data from a string containing several bytes and calculates the sum of all bytes.

Assumptions:

The number of bytes may vary.

The Sum must be in hexadecimal;

The return must be in hexdecimal;

The string contains spaces as shown below:

01 30 00 CA 00 00 02 00 52 4A 5B 29 5D 1F 00 03 25 54 5B EC 02 00 00 00 0A 78 69 10 21 AE 27 04

The sum cannot count either the first byte or the last two Bytes, given the example above:

Example:

It will be disregarded from the sum:

01

What will be sum

30 00 CA 00 00 02 00 52 4A 5B 29 5D 1F 00 03 25 54 5B EC 02 00 00 00 0A 78 69 10 21 AE

The last two bytes of the sum will be disregarded.

27 04

Function Return = 06 27

Kĩ năng: Excel, Visual Basic, Xử lí dữ liệu, Kiến trúc phần mềm, Nhập liệu

Xem nhiều hơn: calculator function javascript calculate different window, checksum string data vba, creating function excel calculate cidr, mysql calculate difference string, simple function assignment, simple order form calculate total java netbean, simple javascript form calculate budget, simple function php wordpress, simple function python application, calculate time within therapeutic range inr, add simple function magento, wordpress add simple function, access vba simple function, calculate reduction efficiency cooktop range hood, checksum string java, vb6 simple function, algorithm checksum string java, string contain

Về Bên Thuê:
( 0 nhận xét ) Fortaleza, Brazil

ID dự án: #22841274

Được trao cho:

nagyzoltan68

Hello, I would like to work on your project. I have great experience using excel macros / vba, formulas. I intend to do this task using a short custom vba code, within a macro enabled file, it can be made either as a u Thêm

$15 USD trong 1 ngày
(121 Đánh Giá)
6.5

10 freelancer đang chào giá trung bình $23 cho công việc này

writingapp

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Thêm

$25 USD trong 1 ngày
(32 Nhận xét)
4.9
Bobkov

Hello. I've read your project details. I am very familiar to Excel. And I can finish this in 1 hour. Let's discuss details over chat. Thank you.

$50 USD trong 1 ngày
(9 Nhận xét)
3.8
dheerajjshetty19

Hello!! Am very interested in ur project and I'm an expert in Word/Excel/Excel Marcos/VBA/Visual basic/Data Entry/Data processing and would like to help you with your project. Please ping me for further discussion.

$10 USD trong 1 ngày
(4 Nhận xét)
1.7
InnovativeHub

Hello Sir/Madam, My name is FATIMA and writing is my passion “When I say work, I only mean writing. Everything else is just an odd job”. From my early age, I enjoyed reading novels and stories, as I was growing up it Thêm

$10 USD trong 1 ngày
(0 Nhận xét)
0.0
anilbaghel060

I'm expert at excel sheet. And i want to earn somd money.

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
$25 USD trong 1 ngày
(0 Nhận xét)
0.0
mdsarojmolla7878

Hello, I am expart of exel. Like Microsoft exel. So I can complete your project normaly. So you can give me this projects to complete. I am new. Thank you.

$20 USD trong 2 ngày
(0 Nhận xét)
0.0
Admjorge

Soy experto en Excel Relevant Skills and Experience He realizado varios proyectos en Excel solucionando problemas que de otra manera tomaba horas de trabajo a solo minutos, solo con Excel

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
kasthoori1

I will do it Relevant Skills and Experience excel

$25 USD trong 1 ngày
(0 Nhận xét)
0.0