PLEASE SHOW ALL STEPS TO GET THE NUMBER OF MOLES WITH VARIOUS PRESSURES!! AND IF YOU COULD, PLEASE HELP ME WITH THE VBA

A mixture of carbon monoxide, hydrogen, and carbon dioxide is produced by steam reforming, a process in which natural gas and steam are mixed and reacted in a reformer operated at 1.6 MPa. Natural gas may be assumed to consist entirely of methane (CH4), although other compounds may be present in small concentrations. In the present process, steam and natural gas are fed to the reformer in a ratio of 3.0 moles of steam per mole of methane. The reformer consists of an arrangement of vertical tubes filled with nickel-impregnated ceramic catalyst. Rows of these tubes are located inside an insulated firebox, where they are headed by the combustion of natural gas. The natural gas and steam that are blended to become the reformer feed enter the process at 30C and 210C respectively. The mixture is preheated to 450C by exhaust gas from the firebox, and it is introduced to the reformer through a header that distributes the mixture evenly among the parallel reformer tubes. Two key reactions occur: the steam-reforming reaction itself, CH4+H2O(g)CO+3H2 Equation.1 And the water-gas shift reaction CO+H2OCO2+H2 Equation.2 The product gas leaves the reformer at 855C and 1.6MPa. The primary purpose of the reformer is to convert methane and water to carbon monoxide and hydrogen (Equation.1). The extent of this reaction is limited by chemical equilibrium. KP1=yH4yH2OyCoyH23P2log10KP1=T(K)11769+13.1927Equation.3Equation.4 Where the subscript 1 refers to the steam-reforming reaction (Equation.1), yi is the mole fraction of species i,P is the system pressure (atm), and T is the temperature (K). The water gas shift reaction (Equation 2) occurs in the reformer also controlled by chemical equilibrium as follows. KP2=yCOyH2OyCO2yH2log10KP2=T(K)1197.81.6485Equation.5Equation.6 Develop a VBA simulation to calculate the number of moles of CH4,H2O,CO,CO2 and H2 with various pressure ranging from 1.2 to 2MPa, temperature ranging from 750C to 950C and methane to steam ratio ranging from 2 to 4 . The simulation also should plot graphs for the number of moles of CH4,H2O,CO,CO2 and H2 (y-axis) with temperature (x-axis) (Note: have multiple lines in each graph for different pressures). Provide flexibility for the unit options for temperature and pressure