Spreadsheet: 708492d1607871817-using-text-in-one-cell-keep-a-running-total-in-another-of-the-amount-in-out-of-item-pth-test-inventory-v3-shareable
Sheet: In_Out Inventory

 |  |  | Tests Incoming/Outgoing |  |  |  |  |  |  |  |  |  |  |  |  | Retests
Trans ID | Date Created | Contractor | Region | In_Out | Amount | Test | Cost/Test | Total Cost Tests | Out Running Total | In Running Total | Running Total | Running Total by Region | Running by Item | Tests Completed | Test Left over | Region2 | Positive Confirmation Test | Confirmation Amount | Cost/Per Confirmation | Confirmation Cost | Confirmation Running Total | Confirmation Running Total by Region | Confirmation Running Total By Item | Initals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IN  / OUT | Total
1 |  |  |  | Out | 10 |  | 45 |  |  |  |  |  |  | 7 |  |  |  | 2 | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IN
2 |  |  |  | Out | 10 |  | 45 |  |  |  |  |  |  | 10 |  |  |  | 2 | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OUT
3 |  |  |  | In | 10 |  | 45
4 |  |  |  | Out | 10 |  | 45 |  |  |  |  |  |  | 10 |  |  |  | 1 | 45
5 |  |  |  | In | 10 |  | 45
6 |  |  |  | In | 10 |  | 45
7 |  |  |  | In | 10 |  | 45
8 |  |  |  | In | 10 |  | 45
9 |  |  |  | In | 10 |  | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row Labels | FemaleBeakers | Instacup | MaleCups | SumUrine | SumOral | HairFollicle | SpecimenLabels | FEDEX/SpecimenBags
10 |  |  |  | In | 10 |  | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost/Item | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
11 |  |  |  | Out | 10 |  | 45 |  |  |  |  |  |  | 10 |  |  |  | 2 | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Initial Stock | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
12 |  |  |  | Out | 10 |  | 45 |  |  |  |  |  |  | 10 |  |  |  | 2 | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Value of Invent. | 1045 | 1045 | 1045 | 1045 | 1045 | 1045 | 1045 | 1045
13 |  |  |  | In | 10 |  | 45
14 |  |  |  | Out | 10 |  | 45 |  |  |  |  |  |  | 6 |  |  |  | 2 | 45
15 |  |  |  | Out | 10 |  | 45 |  |  |  |  |  |  | 10 |  |  |  | 2 | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In
16 |  |  |  | Out | 10 |  | 45 |  |  |  |  |  |  | 7 |  |  |  | 5 | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Out
17 |  |  |  | Out | 10 |  | 45 |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Balance
18 |  |  |  | Out | 10 |  | 45 |  |  |  |  |  |  | 5
19 |  |  |  | Out | 10 |  | 45 |  |  |  |  |  |  | 2
20 |  |  |  | In | 10 |  | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hair
21 |  |  |  | In | 50 |  | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
22 |  |  |  | In | 250 |  | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oral
23 |  |  |  | Out | 150 |  | 45 |  |  |  |  |  |  | 65
24 |  |  |  | In | 100 |  | 45
25 |  |  |  | Out | 125 |  | 45 |  |  |  |  |  |  | 122 |  |  |  | 2 | 45
26 |  |  |  | In | 175 |  | 45