If you are doing the design work, you should be using data from laboratory performance tests of the catalyst you will be using. Don't use values from articles and websites. Are you sure conversion values of 85%, 95% etc are even from articles? They look so nice that I suspect you are simply making assumptions. You will have a hard time convincing your client on your reformer design with assumed values for catalyst performance.
To be frank, your simple spreadsheet cannot be be the basis for your design, and it is not completely correct either.
The water gas shift reaction takes some CO and H2O and makes CO2 and H2. As you can see, the molecules you are balancing are also in it and your outlet will not simply be the outcome from the reaction of just the hydrocarbons. The equilibrium reaction will play a part. What abbas has pointed out is to imply the use in this reaction which apparently you have not fully understood.
Anyway, such design work should be based upon actual catalyst kinetics and not simple balance of molecular species. I'm guessing you and your company are very new to the engineering industry and since reformers are already very widely used in the world, you have alot of expertise and experience to catch up on.
If you are really just a student in school, perhaps only the 2nd paragraph would really be very applicable to you.
Edited by thorium90, 01 June 2013 - 12:34 AM.