Slicing pictures (4) using it for IRremote

The slicing of pictures of a remote control and using it for InfraRed remotes with IRcodes measured with IRsensor on ESP8266 ( or Arduino ).
Currently i store the IR remote codes from each remote control in a spreadsheet with tabs/pages for each remote control.

There are columns in the spreadsheet with

• The IR code
• The location A01 B01 etc on the remote control
• Text on the remote control button (As text, for numbers enter ‘1 to force 1 as text
• Remote control function without special characters ( FF,  not >> etc.)

From this you can make in other columns the HTML code for a table:

Use something like this as a starting point.  

<table>

<tr><td> A01.jpg </td>

<td>       B01.jpg </td>

<td>       C01.jpg </td>

<td>       D01.jpg </td></tr>

<tr><td> A02.jpg </td>

<td>       B02.jpg </td>

<td>       C02.jpg </td>

<td>       D02.jpg </td></tr>

</table>

Change code to display the picture  <img src="A01.jpg" > with formulas in your spreadsheet.  

Add the IRcontrol code and the function description as output in your table. You can also use the spreadsheet to create ( ESP8266Basic ) programming code like

Let IRcode_Power = “012435”

Let IRcode_Mute = “013335”

Let IRcode_CannelPlus  = “022435”

Let IRcode_CannelPlus  = “025535”

Let IRcode_VolumePlus  = “062235”

Let IRcode_VolumeMinus  = “061135”

Let IRcode_1 = “014435”

Let IRcode_2 = “015535”

Let IRcode_3 = “016635”

Let IRcode_FF  = “051135”

Let IRcode_FB  = “052235”

To avoid programming code like  Let IRcode_>>  = “051135” i included in the spreadsheet not only >> >| but also a column with the function without special characters (  FF Play , Pause,  Stop.)

The data from the spreadsheet can also be pushed an ( MySQL ) database to use it with a home automation system.