[HTC Desire 526] BigCountry907:
Walkthrough - Using the Spreadsheet

Using the spreadsheet to make Partition.xml

Since it is imperative to use the spreadsheet correctly lets go over using it.

Open the GPT-Translator-blank.ods spreadsheet.

You should have it located here.

~/Desktop/526-Completed/Get-GPT_Info/GPT-Translator-blank.ods

Open the 526-EMMC-GPT-read2.txt. in a text editor. ( This is our hex dump )

You should have it located here.

~/Desktop/526-Completed/Get-GPT_Info/526-EMMC-GPT-read2.txt

Open the 526-EMMC-GPT-read1.txt. in a text editor. ( This is the file we made with gptparser.pl )

You should have it located here.

/home/bigcountry907/Desktop/526-Completed/Get-GPT_Info/526-EMMC-GPT-read[COLOR="Red"][SIZE="4"]1[/SIZE][/COLOR].txt

Make sure you note the difference between the read1.txt and read2.txt

The read1.txt we use to check the spreadsheet and read2.txt is the one we use to make the spreadsheet

Notice when you Open the 526-EMMC-GPT-read1.txt. in a text editor. ( This is the file we made with gptparser.pl )

We get a warning.

The file you opened has some invalid characters. If you continue editing this file you could corrupt this document.

You can also choose another character encoding and try again.

That means there is a possibility of data corruption.

This is a good reason for us to use the hexdump. (No Data Corruption)

Lets go to this part of the spreadsheet.

THE FIRST SECTION WE NEED TO INPUT DATA

STEP 1

Open another blank spreadsheet.

Right click on the spreadsheet icon and select "New Spreadsheet"

STEP 2

Go to the 526-EMMC-GPT-read2.txt

Select all of the data and copy it to the clipboard.

Right click Select All

Right click Copy

STEP 3

Open the blank spreadsheet and paste the data into it.

This gives us a chance to format the data before we copy it to the generator spreadsheet.

Click on the first cell in the black spreadsheet. Cell A1.

Right Click and select paste.

This format window will appear.

STEP 4

To correctly format the imported text set the following.

Separator Options = FIXED WIDTH

Detect Special Numbers= checked

Now look at the ruler section and make sure you have a RED DOT separating each field.

If you click on the ruler section it will add a new separator.

If you get extra columns don't worry it's ok.

We will delete them after we import the text.

The last thing we need to do is click on the first box that says STANDARD

Hold the shift key and click the last box that says STANDARD.

The whole top section saying standard should be highlighted.

Then click on COLUM TYPE and set it to TEXT.

Your settings should look like this.

Now click OK.

Your spreadsheet will start out looking like this.

Lets clean it up a little.

Select the upper left corner of the spreadsheet to SELECT ALL.

Click the align left button to align all text to the left side of the cells.

Now double click on the line in between the letters at the top of the spreadsheet.

Do this for each cell to shrink the cells to fit the text.

Now your spreadsheet will look like this.

Now one last edit and we are done.

We need to keep the green colored columns that are empty.

We need to delete all the columns that marked in red.

To delete the columns right click on the letter of a red highlighted column and select delete.

AFTER YOU ARE ALL DONE THE SPREADSHEET SHOULD LOOK LIKE THIS

Click in cell A1 then scroll all the way to the bottom of the data.

Hold the shift key and click the last cell.

The last cell in our example is U1088.

Everything should be highlighted.

Right click and select copy.

The spreadsheet will look like this before you copy the data.

After you have copied the data to the clipboard we can now put it into the generator spreadsheet.

Go to that first section of the generator spreadsheet.

Click in cell B5 THEN RIGHT CLICK AND SELECT PASTE ONLY & TEXT

THE GENERATOR HAS TO LOOK LIKE THIS.

If there are any 00 or text in any other place then you did not get the format correct before you pasted the data.

The spreadsheet will not warn you if you paste the wrong format.

So make sure you get the format exact before you copy and paste into the generator.

Also absolutely select paste only and then text.

All of the cells are color coded to match the calculated information.

All the colors match up and you can see what the hex bytes mean.

THE GENERATOR SHOULD LOOK EXACTLY LIKE THIS

In the next post we will add the rest of the data we need into the generator. :victory: