Prepare and upload the Excel data source

- [Instructor] We'll create our final app from scratch.…Before we begin here's a little orientation…to the service call report.…This is an empty version of a spreadsheet used at KinetEco.…The spreadsheet is used to track issues,…problems that have come up that are discovered…because a customer reports them…or because someone from the quality assurance staff…has discovered an issue with an installation…or perhaps one service call generates another call.…These are our headings, Install Type, Reported by,…Date Reported, and so on.…

These first four columns are typically filled out…by the person who spots the problem,…the Install Type, Reported by, Date Reported, and Problem.…The first column is a drop-down,…Geothermal, Hybrid, Solar, Wind.…That drop-down list is found here…is in fact a named range called Install Type.…So that can be modified at any time.…After the problem has been reported…it is then assigned to someone…and that service technician…then types a report of their resolution…and records the date on which the problem was resolved.…