We need to transfer raw/handwritten data into an excel spreadsheet. Data represents our physical inventory of food and beverage items we have in stock. Job is to identify the pertinent data from each page, and input this information into an excel spreadsheet. There is a total of 79 pages of raw data, that you will need to extract the information we need from. There is a total of 878 items that need to be entered into the excel spreadsheet.
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td> <td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td>
| |
| |
| |
## Deliverables
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td> <td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td> <td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td> <td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td> <td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td>
<td style="border-style: solid none; border-color: windowtext rgb(236, 233, 216); border-width: 1pt medium; background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">
Name</td> <td style="border-style: solid none; border-color: windowtext rgb(236, 233, 216); border-width: 1pt medium; background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">5 or 6 digit item number</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext rgb(236, 233, 216); border-width: 1pt 1pt 1pt medium; background-color: transparent;" mce_style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Actual physical count</td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">
found on the top of each page</td> <td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">found throughout the page</td> <td style="border-style: none solid none none; border-color: rgb(236, 233, 216) windowtext rgb(236, 233, 216) rgb(236, 233, 216); border-width: medium 1pt medium medium; background-color: transparent;" mce_style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">found throughout the page</td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td> <td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td> <td style="border-style: none solid none none; border-color: rgb(236, 233, 216) windowtext rgb(236, 233, 216) rgb(236, 233, 216); border-width: medium 1pt medium medium; background-color: transparent;" mce_style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">
</td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">
Cecilia</td> <td align="right" style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">236576</td> <td align="right" style="border-style: none solid none none; border-color: rgb(236, 233, 216) windowtext rgb(236, 233, 216) rgb(236, 233, 216); border-width: medium 1pt medium medium; background-color: transparent;" mce_style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">18</td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">
Cecilia</td> <td align="right" style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">226236</td> <td align="right" style="border-style: none solid none none; border-color: rgb(236, 233, 216) windowtext rgb(236, 233, 216) rgb(236, 233, 216); border-width: medium 1pt medium medium; background-color: transparent;" mce_style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">4</td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">
Cecilia</td> <td align="right" style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">201714</td> <td align="right" style="border-style: none solid none none; border-color: rgb(236, 233, 216) windowtext rgb(236, 233, 216) rgb(236, 233, 216); border-width: medium 1pt medium medium; background-color: transparent;" mce_style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">6</td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">
Cecilia</td> <td align="right" style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">202622</td> <td align="right" style="border-style: none solid none none; border-color: rgb(236, 233, 216) windowtext rgb(236, 233, 216) rgb(236, 233, 216); border-width: medium 1pt medium medium; background-color: transparent;" mce_style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">371</td>
<td style="border-style: none none solid; border-color: rgb(236, 233, 216) rgb(236, 233, 216) windowtext; border-width: medium medium 1pt; background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">
</td> <td style="border-style: none none solid; border-color: rgb(236, 233, 216) rgb(236, 233, 216) windowtext; border-width: medium medium 1pt; background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent"> </td> <td style="border-style: none solid solid none; border-color: rgb(236, 233, 216) windowtext windowtext rgb(236, 233, 216); border-width: medium 1pt 1pt medium; background-color: transparent;" mce_style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent"> </td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td> <td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td> <td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;" mce_style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></td>
| Expectation is to have a, 4 column spreadsheet, with 878 rows. |
| The four column headers will be: Page Number, Name, 5 or 6 Digit Item Number & Actual physical count |
| |
| Here sample entry, with pointers on where to find the pertinent data. |
| |
| Page Number |
| As specified on the pdf file |
| |
| 1 of 79 |
| 1 of 79 |
| 1 of 79 |
| 1 of 79 |
| |
| |
| Only item numbers with hand written counts need to be entered. |
| There is no need to enter item numbers that do not have a corresponding actual physical count written next to them. |
| |
| If the data is un-readable to you. You may indicate with an asterisk that you are unsure of your input. |
| An example of this would be if you cannot determine if the number is a 5 or a 2. |
| We are also willing to answer any questions you may have in trying to complete this job. |