Having difficulty transposing data from an excel column into separate fillable form fields
Hi,
I must preface that I cannot change the design or function of this form.
There is an excel column of salutation containing mr, mrs, miss, ms & dr; that I’d like to transpose into the fillable PDF into four checkable boxes "mr, mrs, miss, ms" and "other" fillable input field (dr):

I’ve grouped them under "Salutation", but they cannot be individually named as form fields to delineate them and the fillable field "other" cannot be grouped/linked into the salutation.

The script would interpret the excel "Salutation" column and check the box thusly:

Is any of this possible?
The next two fields are a work/home number:

The excel column contains the 10 interger number with the 2 integer prefix followed by the rest of the number containing 8 integers.

How can I link these two separate fields so that the first field transposes only the first two numbers (prefix) followed by the second field with the next 8?
Lastly is a single integer percent value with two decimal places. There is two fields, the first with the integer and the second with the two numbers following the decimal place.

The decimal place is part of the PDF design, but the decimal is also contained within the excel column, which I understand only adds to the difficulty.

Again, much like the phone number, how can I link these two separate fields so that the first field inputs the first integer and the second inputs the two integers following/ignoring the decimal place contained within the excel column?
I fully understand how complex my request is and may require serious javascript beyond my skillset. Any help would be greatly appreciated.
