80 likes | 292 Views
Tier 2: Case Studies. Case Studies. Table of Contents Chapter 1 Introduction Useful Computer Tools for Data Reconciliation Chapter 2 Case Study #1 Steady-State Nonlinear DR and Detection of Gross Errors through Analysis Chapter 3 Case Study #2
E N D
Tier 2: Case Studies
Case Studies Table of Contents Chapter 1 Introduction Useful Computer Tools for Data Reconciliation Chapter 2 Case Study #1 Steady-State Nonlinear DR and Detection of Gross Errors through Analysis Chapter 3 Case Study #2 A Gross Error Detection Problem Using Observability and Redundancy Analysis Chapter 4 Case Study #3 An Unsteady-State Problem
Introduction: Useful Computer Tools for Data Reconciliation
Introduction Jumping Jiminy Cricket! Excel and MATLAB!?
Introduction Matrix Algebra Data Reconciliation MATLAB EXCEL
Introduction Some useful syntax in MATLAB: A = AB AT A-1 QR factorization of A QR factorization with permutation A = [1 0 0 1; 0 1 1 0; 1 0 1 1] A*B A’ inv(A) [Q,R] = qr(A) [Q,R,E] = qr(A)
Introduction Some useful syntax in Excel: Suppose A = (cells A1:B2) B = (cells D1:E2) Then AB AT A-1 MMULT(A1:B2, D1:E2) TRANSPOSE(A1:B2) MINVERSE(A1:B2)
Introduction A (2x2), B (2x2) AB = C C (2x2) • In order to calculate C and place it in cells G1:H2: • Highlight cells G1:H2 • Type “= MMULT(A1:B2, D1:E2)” • Press Control, Shift and Enter simultaneously