Aging Power Delivery Infrastructures, 2nd Edition

Appendix A. Notes on a Spreadsheet-Based Model for Aging Trends

A.1 Introduction

A.2 The Basic Concept: Incrementing an Age Distribution

A.3 Multi-Sheet Structure of a More Practical Model

A.4 Fitting and Calibrating a Model

A.5 Real-World Data Situations: Getting a Solution

A.6 Comments on Application

Reference

A.1 INTRODUCTION

This appendix presents the recommended layout for an electronic spreadsheet template that implements a simulation of electrical equipment set’s aging/deterioration over time. This first section gives some basic definitions used throughout this Appendix as well as throughout the book. Section A.2 describes the central concept– the staged use of rows representing years and columns accounting for annual age distributions. ...