how would u do this
Create functions in Excel that allow the user to determine and apply ideal gas properties of two assigned gases without using property tables. The properties must account for variable specific heats, which are a function of the temperature. A template has been created for this project. It includes two spreadsheets (one for air and the other for carbon dioxide) and a macro. Each spreadsheet has five tasks specified. You must use functions to populate all the cells on each spreadsheet except for the second column in Task #3. The functions include both the ones in the macro and the ones you configure in the spreadsheets. As examples for you to follow, the macro has a portion of functions done for you, leaving the rest for you to complete. In a similar way, a portion of cells in the spreadsheet for air are populated already, and you need to finish the rest Open the project template (Project Template 2018.xlsm) and select the "View" tab at the top of the spreadsheet (see step 1 in the screenshot below). Select "View Macros" (step 2 below) and "Edit" Macro 1 according to the instructions highlighted in green in the Macro file. The appropriate formulae for each property to be calculated are given below; you need to use them to complete the macro Return to the spreadsheet and make appropriate calls to the functions (step 4 below) in each cell to complete the spreadsheet Project Template 2018-Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEWVIEW ADD-INS TEAM Vingchen Yang Formula Bar ama Ba New Window: Split Arrange All Hide range Alow DPage Layout Ruler 2 -Hide Page Break?Custom Views [x1 Gridlines Zoom 100% Zoom to Selectio, Freeze Panes Urthide?Windows . Headings Workbook Views View Macros G9 Use Relative References 1 Thermodynamics I Term Project: Gasi-Air 3 Task #1: With a specified gas(air) 4 and a given temperature 5 determine other 6 Gas TaskE Expand the effort in Task #1 tocreate a property table for the same gas in a |ask #4: A piston cylinder assembly contains a fixed of a gas at a given temperature and pressure. The gas is brought to a final given temperature at constant pressure defined below ?? Find 1.09780285 k/kg-K 1 kJ/ 300 1.004151 4.5 350 1.007521 kPa Ideal Gas (Air) Ideal Gas (CH4) +100% 3 45 u=h-RT Create functions in Excel that allow the user to determine and apply ideal gas properties of two assigned gases without using property tables. The properties must account for variable specific heats, which are a function of the temperature. A template has been created for this project. It includes two spreadsheets (one for air and the other for carbon dioxide) and a macro. Each spreadsheet has five tasks specified. You must use functions to populate all the cells on each spreadsheet except for the second column in Task #3. The functions include both the ones in the macro and the ones you configure in the spreadsheets. As examples for you to follow, the macro has a portion of functions done for you, leaving the rest for you to complete. In a similar way, a portion of cells in the spreadsheet for air are populated already, and you need to finish the rest Open the project template (Project Template 2018.xlsm) and select the "View" tab at the top of the spreadsheet (see step 1 in the screenshot below). Select "View Macros" (step 2 below) and "Edit" Macro 1 according to the instructions highlighted in green in the Macro file. The appropriate formulae for each property to be calculated are given below; you need to use them to complete the macro Return to the spreadsheet and make appropriate calls to the functions (step 4 below) in each cell to complete the spreadsheet Project Template 2018-Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEWVIEW ADD-INS TEAM Vingchen Yang Formula Bar ama Ba New Window: Split Arrange All Hide range Alow DPage Layout Ruler 2 -Hide Page Break?Custom Views [x1 Gridlines Zoom 100% Zoom to Selectio, Freeze Panes Urthide?Windows . Headings Workbook Views View Macros G9 Use Relative References 1 Thermodynamics I Term Project: Gasi-Air 3 Task #1: With a specified gas(air) 4 and a given temperature 5 determine other 6 Gas TaskE Expand the effort in Task #1 tocreate a property table for the same gas in a |ask #4: A piston cylinder assembly contains a fixed of a gas at a given temperature and pressure. The gas is brought to a final given temperature at constant pressure defined below ?? Find 1.09780285 k/kg-K 1 kJ/ 300 1.004151 4.5 350 1.007521 kPa Ideal Gas (Air) Ideal Gas (CH4) +100% 3 45 u=h-RT
