Adding A Certain Number of Rows w/ Prefilled Cells

I am hoping to automate my spreadsheet to add rows as needed for testing upon failure.
In my example, if my result hits 0.19 or higher, I need it to add a number of rows equal to the value of the sample number that failed. Following the example, since row 6 was 0.2, it added 6 rows and prefilled the Sample Number cells with the equation to determine the sample number.
I understand macros in theory, but I'm not sure how to piece all of this together. I appreciate any help you can provide!