The next steps MUST be followed carefully, ensure you name everything exactly as specified or the formulas will not work.
Open both files in a spreadsheet application. Paste the 30day recommendations into one worksheet, and the 7day recommendations into another worksheet called 7Day Rec, in the same spreadsheet.
Create a new column called RI ID to the left of the Recommended Instance Quantity Purchase column on both 30Day and 7Day sheets, which is a unique identifier of the RI Type, the formula for this cell will concatenate the columns: Instance Type, Location,OS and Tenancy. On row 2 of the sample files, paste the formula below into the first row of data and fill the remaining rows below.
If using your own data, modify the U$48 component to the number of rows in your data.
We will now create a Fully Paid Day column. This shows us how long it will take to pay off the full term of the RI, and will help to measure risk. The closer to 12months the fully paid day is, the higher the risk. The break even is the wrong measure, as it only shows how quickly you pay off the upfront component, and not the full amount. Paste the following formula into the last column z:
The formula for the fully paid day is: (yearly RI cost) / (monthly on-demand cost)
You have compiled a complete set of recommendations with the required data to be able to analyse and make low risk high return recommendations.