Doing multiple calculations in R similar to Data table in excel
<p>I am looking for a similar function/package in R to that of Data Table in MS Excel (What-If calculations). Currently I use Data tables in Excel extensively to do multiple calculations on thousands of rows of input data. I have attached a snapshot of the calculations being done in Excel Data Table:</p>

<p><a href="https://i.stack.imgur.com/z7Cvu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/z7Cvu.png" alt="enter image description here"></a></p>

<p>In other words, all my formulae/calculations are in a single tab of spreadsheet, and all the input data in another tab (several thousand of rows). I use data table operation to calculate results for each row of this data set. This makes my spreadsheet tidy with all the calculations in only single tab. Now I am looking to implement the same using R. Any help on this is deeply appreciated. </p>