Using Microsoft Excel, create a spreadsheet to simulate a finite element analysis of heat transfer in a sheet of metal which is heated to soldering temperature at one corner. Assume that the temperature of any single cell is equal to the average of the temperatures of the four cells which share a side with it. Create a 10 by 10 cell finite element model with the temperature of the top edge (all 10 cells) is held to 20 degrees C, and the temperature along the right side is also held to 20 degrees. Make the lower left corner "hot" -- you can pick a value similar to a that of a soldering iron (look up temperatures of soldering iron tips). You can then add values long the bottom going from high down to 20 degrees, decreasing from left to right -- choose any starting rate you like. You can do the same for the left side, going from 20 degrees at the top and going up to the high temperature you have assigned in the lower left corner. Once you have made sure your spread sheet model works, make a "heat map" -- to do this, select all the cells in your spreadsheet model. Then, on the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click Color Scales. Select a two-color scale. -- Make the lower temperatures blue, and higher temperature red. You should then see a lovely heat map!
Using Microsoft Excel, create a spreadsheet to simulate a finite element analysis of heat transfer in a sheet of metal which is heated to soldering temperature at one corner. Assume that the temperature of any single cell is equal to the average of the temperatures of the four cells which share a side with it. Create a 10 by 10 cell finite element model with the temperature of the top edge (all 10 cells) is held to 20 degrees C, and the temperature along the right side is also held to 20 degrees. Make the lower left corner "hot" -- you can pick a value similar to a that of a soldering iron (look up temperatures of soldering iron tips). You can then add values long the bottom going from high down to 20 degrees, decreasing from left to right -- choose any starting rate you like. You can do the same for the left side, going from 20 degrees at the top and going up to the high temperature you have assigned in the lower left corner. Once you have made sure your spread sheet model works, make a "heat map" -- to do this, select all the cells in your spreadsheet model. Then, on the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click Color Scales. Select a two-color scale. -- Make the lower temperatures blue, and higher temperature red. You should then see a lovely heat map!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
