![]() WtyParts: are parts under warranty? Yes or blank. ![]() WtyLbr: is labor under warranty? Yes or blank.ReqDate: date the work order was entered in system.Service: type of work to be done - Assess, Deliver, Install, Repair, Replace.LeadTech: head technician at the work location.District: geographic area where work will be done.There are 1000 rows of data in the work orders table.Įach row shows these 13 manual entry fields:.There are 22 columns of data, including 9 columns with a calculation.This sample file has fake work orders data. The zipped Excel file is in xlsx format, and does not contain any macros. Workplace Safety: Click here to get the workplace safety data file. Year: year number (calculation, based on Date).Month: month number (calculation, based on Date).WkDay: 3-letter code for day of the week (calculation, based on Date).Incident Cost: total cost of safety incident.Department: work department where incident occurred.Shift: work shift when incident occurred - Afternoon, Day, Night.Report Type: Type of safety report filed - First Aid, Lost Time, Medical Claim, Near Miss.Plant: manufacturing location were incident occurred.Days Lost: number of days employee off work.Incident Type: Type of safety incident, e.g.Injury Location: location on body where injury occurred.There are 514 rows of data in the workplace safety report table.There are 14 columns of data, including 3 columns with a calculation.This sample file has fake workplace safety report data. TotalPrice: total price of order - calculation - Quantity x UnitPriceįood Sales: Click here to get the food sales data file.UnitPrice: product selling price per unit.Category: product category - Bars, Cookies, Crackers or Snacks.Region: geographic region where order will be shipped.There are 244 rows of data in the food sales table.There are 8 columns of data, including 1 column with a calculation.This sample file has food sales data, from an imaginary food company. Insurance Policies: Click here to get the insurance policy data file. Flood: Is flood coverage included? Y or N.Earth: Is earthquake coverage included? Y or N. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |