**E133: Fall 2023 Assignments** |[home](index.md.html)|[assignments](assignments.md.html)|[final project](FinProj.md.html)|[notes and code](notecode.md.html)| # Assignment 1 – Due 05 September 2023 [Assignment 1](PS/assign1.md.html) [Excel Numerical Integration and Root Finding Example](PS/NumIntRootFindExample.xlsx) - [PDF of solution](PS/E133_F23_PS_1_Solution.pdf) - [Spreadsheet of solution](PS/PS1_Soln.xlsx) - [Mathematica solution](PS/PS1P2Soln.nb) # Assignment 2 – Due 12 September 2023 [Assignment 2](PS/assign2.md.html) - [PDF of solution](PS/E133_F23_PS_2_Solution.pdf) - [Spreadsheet of solution](PS/PS2_Soln.xlsx) - Prob 1 Mathematica solution: [.nb](PS/PS2_Prob1soln.nb), [PDF](PS/PS2_Prob1soln.pdf) - Prob 2 Mathematica solution: [.nb](PS/PS2_Prob2AsGiven.nb), [PDF](PS/PS2_Prob2AsGiven.pdf) - Prob 3 Mathematica solution: [.nb](PS/PS2_Prob3soln.nb), [PDF](PS/PS2_Prob3soln.pdf) # Assignment 3 – Due 19 September 2023 Hill & Root: Problem 3.3, Problem 3.12, Problem 3.21, Problem 3.23 b, j, l - [Tables from problems in Microsoft Excel format](PS/PS3Tables.xlsx) - [Example Problem (3-20) from Levenspiel](notes/LevenspielP3-20.pdf) - [Solution to Example Problem from Levenspiel](notes/ExampleKineticAnal3-20.xlsx) - [PDF of Solution](PS/E133_F23_PS_3_Solution.pdf) - [Spreadsheet of solution](PS/PS3_Solutions.xlsx) # Assignment 4 – Due 03 October 2023 Hill & Root: Problem 8.33 - [PDF of Solution](PS/E133_F23_PS4_Solution.pdf) - [Spreadsheet of solution](PS/PS4_Soln.xlsx) # Assignment 5 – Due 10 October 2023 Hill & Root: Problem 8.23, Problem 8.28, Problem 8.42 - [PDF of Solution](PS/E133_F23_PS5_Solution.pdf) - [Spreadsheet of solution](PS/PS5_Soln.xlsx) - Prob 8.23 Mathematica solution: [.nb](PS/PS5_Soln8-23.nb), [PDF](PS/PS5_Soln8-23.pdf) - Prob 8.28 Mathematica solution: [.nb](PS/PS5_Soln8-28.nb), [PDF](PS/PS5_Soln8-28.pdf) # Assignment 6 – Due 24 October 2023 Hill & Root: Problem 9.3, Problem 9.12, Problem 9.22, Problem 10.4 - [PDF of Solution](PS/E133_F23_PS_6_Solution.pdf) - [Spreadsheet of Solution](PS/PS6_Soln.xlsx) - Prob 9.3 Mathematica solution: [.nb](PS/PS6_9_3_Soln.nb), [PDF](PS/PS6_9_3_Soln.pdf) - Prob 9.12 (a), (b), (c) Mathematica solution: [.nb](PS/PS6_9_12_Soln.nb), [PDF](PS/PS6_9_12_Soln.pdf) - Prob 9.12 (d) Mathematica solution: [.nb](PS/PS6_9_12_d_Soln.nb), [PDF](PS/PS6_9_12_d_Soln.pdf) - Prob 9.22 Mathematica solution: [.nb](PS/PS6_9_22_Soln.nb), [PDF](PS/Prob10-23PFR.pdf) # Assignment 7 – Due 07 November 2023 [Assignment 7](PS/assign7.md.html) - [PDF of Solution](PS/E133_F2023_PS_7_Solution.pdf) - Problem 3 Mathematica Solution [.nb](PS/Prob10-23PFR.nb), [PDF](PS/PS6_9_22_Soln.pdf) # Assignment 8 – Due 16 November 2023 Hill & Root: Problem 6.1, Problem 6.9, Problem 6.12 - [Tables from problems in Microsoft Excel format](PS/PS8Tables.xlsx) - [PDF of Solution](PS/E133_F2023_PS_8_Solution.pdf) - [Spreadsheet of Solution](PS/PS8_Soln.xlsx) # Assignment 9 – Due 30 November 2023 Levenspiel 18.20, 18.21, 18.22, 18.23, 18.24 [PDF](PS/Assignment9.pdf) - [PDF of Solution](PS/LevenspielSolutions.pdf) - [Spreadsheet of Solution](PS/LevenspielSolutions.xlsx) ************************************** # Spreadsheet Helps - Never enter a given formulat by hand more than once. Either copy and paste it or drag it across or down. Learn how to use absolute and relative references to make this easy. - Learn the key shortcut to toggle absolute and relative references: Platform | Spreadsheet | Key Shortcut ---------|--------------|------------- Windows | Excel | F4 Windows | Google Sheets| F4 macOS | Excel | ⌘–T or fn–F4 macOS | Google Sheets| fn–F4 - Learn to create an [linear][art] or [growth][gro] (Growth is Excel only) series of numbers. - Use Goal Seek or Solver to solve nonlinear equations (Excel or [Libre Office][lo] only). [Scholarly Paper][gs], [E82 Goal Seek video][e82gs], [E82 Solver video][e82s] - Use Solver to perform nonlinear least-squares regression (Excel or [Libre Office][lo] only), [Scholarly Paper][so], [E82 Solver video][e82s] [art]: https://support.office.com/en-us/article/automatically-number-rows-76ce49e3-d8d2-459b-bd85-ee1d3973e6e6#__toc305685490 [gro]: https://support.office.com/en-us/article/project-values-in-a-series-5311f5cf-149e-4d06-81dd-5aaad87e5400 [gs]: http://www.math.odu.edu/~bogacki/epictcm/VOL26/C024/paper.pdf [so]: https://people.chem.ucsb.edu/laverman/leroy/Chem116/PDF116CL/Solver.pdf [lo]: https://www.libreoffice.org/ [e82s]: https://youtu.be/X-168Nu-muk [e82gs]: https://youtu.be/fCNcfZePbIM