tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 201306d1355941162-inventory-files-combing-example-1-solution
Sheet: Inventory

1. RSR Stock Number | 2. UPC Code (if available or blank filler) | 3. Product Description | 4. Department Number | 5. Manufacturer Id | 6. Retail Price (if available or .00) | 7. RSR Regular Price | 8. [NAME] (oz.) | 9. Inventory Quantity | 10. Model | 11. [NAME] | 12. Manufacturer Part Number | 14. Expanded Product Description | 15. Image name
21976 | 26495074906 | MARLIN 60 22LR AUTO 14RD TUBE 70620 | 5 | MARLIN | 196.83 | 143.34 | 118 | 92 | 60 | Marlin | 70620 | [NAME] 22LR 19" Blue Wood Right Hand 14Rd Adjustable Sights 70620 | MAR60_1.jpg
511-40011-010-L | 844802016148 | 5.11 HOLSTER SHIRT L WHITE | 33 | 511 | 74.99 | 50.88 | 5 | 14 | [NAME] | 5.11 Tactical | 40011 | 5.11 Tactical Short Sleeve Shirt L White Holster Shirt Crew 40011 | 511-40011-010-L_1.jpg
Spreadsheet: 50036e48-5ce9-45b6-ad29-bd9db2dee2e2
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FFRWB | Test | FFRWB | Friedreich Ataxia, Frataxin, Quantitative, [NAME] | Frataxin, Quant, WB | Luminex Immunoassay | EDTA (lavender-top) tube: EDTA |  |  | 1 | mL | Collection Container/Tube:  Preferred: Lavender top (EDTA) Acceptable: Green top (sodium or lithium heparin) Submission Container/Tube: Plastic vial [NAME]: 2 mL Additional Information: Provide a reason for referral with each specimen.  Forms: 1.   1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2.   2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 1.25 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | Pediatric (<18 years) normal frataxin: > or =19 ng/mL  Adults (> or =18 years) normal frataxin: > or =21 ng/mL | Tuesday; 8 a.m. | 8 days | 16 days | 1 | 83520 |  |  |  |  | Rochester
FFRWB | [NAME] | BLOOD | Whole blood |  |  |  | Frozen | 70 days
FFRWB | Result | 32253 | Reason for Referral | Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
FFRWB | Result | 32254 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9
FFRWB | Result | 32255 | Frataxin | Frataxin | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
FFRWB | Result | 32256 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
Spreadsheet: 134602d1325510568-copy-if-formula-upload
Sheet: Sheet 11 - Table 1 - Table 1

 | Asset 1 |  | Asset 2 |  | Asset 3
 | Units | Price | Units | Price | Units | Price
2012-12-01 00:00:00
2012-12-02 00:00:00
2012-12-03 00:00:00
2012-12-04 00:00:00
2012-12-05 00:00:00
2012-12-06 00:00:00
2012-12-07 00:00:00
2012-12-08 00:00:00
2012-12-09 00:00:00
2012-12-10 00:00:00
2012-12-11 00:00:00
2012-12-12 00:00:00
2012-12-13 00:00:00
2012-12-14 00:00:00
2012-12-15 00:00:00
2012-12-16 00:00:00
2012-12-17 00:00:00
2012-12-18 00:00:00
2012-12-19 00:00:00
2012-12-20 00:00:00
2012-12-21 00:00:00
2012-12-22 00:00:00
2012-12-23 00:00:00
2012-12-24 00:00:00
2012-12-25 00:00:00
2012-12-26 00:00:00
2012-12-27 00:00:00
2012-12-28 00:00:00
2012-12-29 00:00:00
2012-12-30 00:00:00
2012-12-31 00:00:00
Spreadsheet: 778135d1650887608-display-from-string-highlights
Sheet: Sheet1

 | Jersey # | Players Name |  | 1st Qtr Goals | 1st Qtr Behinds | 2nd Qtr Goals | 2nd Qtr Behinds | [NAME] | 3rd Qtr Behinds | [NAME] | 4th Qtr Behinds | Total Goals | Total Behinds |  |  | 1
 | 22 | [NAME] |  |  |  | 1
 | 12 | [NAME] |  |  |  |  |  |  | 1
Spreadsheet: 156225d1337233926-contribution-of-an-account-to-overall-market-shrinkage-growth-help-test
Sheet: Sheet2

 | Account contribution to overall market shrinkage/growth from Jan to Feb
 | Account Name | Jan | Feb | Weight | var% | % contribution | Difference
 | ABC | 37547 | 32664 |  |  | ?
 | BCA | 7870 | 6501 |  |  | ?
 | ZAB | 7635 | 9365 |  |  | ?
 | BAF | 7395 | 7434
 | FAR | 6757 | 2455
 | TRA | 6425 | 6846
 | TSG | 6107 | 6643
 | HDK | 5964 | 4966
 | OKK | 5527 | 6625
 | KTA | 5503 | 7939
 | TNSS | 5439 | 5459
 | TBASDR | 5199 | 3446
 | AJET | 5181 | 4967
 | TJJA | 5151 | 5344
 | TAN | 5083 | 6843
 | DKA | 4427 | 5788
 | IRR | 4340 | 5676
 | Total
Spreadsheet: benjamin_rogers__924__NY ISO LOAD AND STACK INFORMATION Version 2
Sheet: Gen

Coal | 3411.89 |  |  | Coal
Gas | 8420.95 |  |  | Gas
Hydro | 5334.02 |  |  | Hydro
Nuclear | 2853 |  |  | Nuclear
Oil | 6468.9 |  |  | Oil
Spreadsheet: 598571d1542608525-creating-a-list-from-cross-referenced-data-sample-27-ans
Sheet: Sheet1

Person | A | B | C | D | E | F | G | RESULTS | Person | Type |  | Person | Type
#1 | 2 |  |  |  |  | 3 |  |  |  |  |  | #1 | A
#2 |  | 2 |  | 1 |  |  |  |  |  |  |  | #1 | A
#3 |  |  |  |  |  |  |  |  |  |  |  | #2 | D
#4 |  |  |  |  |  |  |  |  |  |  |  | #5 | G
#5 |  |  |  |  |  |  | 2 |  |  |  |  | #5 | G
 |  |  |  |  |  |  |  |  |  |  |  | How ARRAY formula is entered
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] in the cell.
 |  |  |  |  |  |  |  |  |  |  |  | Press F2
 |  |  |  |  |  |  |  |  |  |  |  | Hold Shift+ [NAME] and hit Enter key.
 |  |  |  |  |  |  |  |  |  |  |  | Now  the formula is surrounded by {} by excel.
Spreadsheet: 160421d1339081116-conditional-sum-with-linked-conditions-in-different-tables-conditionalsum3
Sheet: Result

Job \ Week number > | 1 | 2 | 3
Architect | 0 | 1 | 0
Driver | 2 | 2 | 1
Salesperson | 1 | 2 | 3
 |  |  |  |  |  |  |  | Person | Job | Person
 |  |  |  |  |  |  |  | Chelsea | Architect | Chelsea
 |  |  |  |  |  |  |  | [NAME] | Driver | [NAME]
 |  |  |  |  |  |  |  | [NAME] | Driver | [NAME]
 |  |  |  |  |  |  |  | Nina | Salesperson | Nina
 |  |  |  | Attempt |  |  |  | [NAME] | Salesperson | [NAME]
 |  |  |  | Driver
 |  |  |  | 0
 |  |  |  | 1
 |  |  |  | 0 |  |  |  | Given input
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  |  |  |  |  | Person \ Week number | 1 | 2 | 3
 |  |  | Vectors we are looking for |  |  |  |  | [NAME] | 1 | 1 | 1
 |  |  | Architect | Driver | Salesperson |  |  | [NAME] | 1 | 1
 |  |  | 0 | 1 | 0 |  |  | Chelsea |  | 1
 |  |  | 0 | 1 | 0 |  |  | Nina |  |  | 1
 |  |  | 1 | 0 | 0 |  |  | [NAME] |  | 1 | 1
 |  |  | 0 | 0 | 1 |  |  | [NAME] | 1 | 1 | 1
 |  |  | 0 | 0 | 1
 |  |  | 0 | 0 | 1
 |  | Current situation: To get the table B2:D4 we have the orange vectors, which represent the people belonging to a job in the order of I20:I25. These ones were calculated manually (an automatic attempt in green has been made)
 |  | Goals:
 |  | 1 Calculate the orange vectors
 |  | 2 Calculate B2:D4 without the orange vectors being written down
Spreadsheet: 145745d1331728308-recognise-textdate-on-one-worksheet-as-a-proper-date-on-another-worksheet-sample-workbook-13-3-2012
Sheet: Invoice

a
 |  |  | Invoice No.
Home code
Name:
Address1: |  |  |  | Date:
Address2:
Town/County:
Postcode:
 |  | Date | Class Location | Cost of Class | VAT
 | _
 |  |  |  | Total Cost of Classes
 |  |  |  | VAT
 |  |  |  | Invoice Total
Spreadsheet: frank_ermis__11103__West NatGas Prices 1025
Sheet: Gas Average PhyIdx

PhyIdx Curves
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEST NATURAL GAS PRICES- Phy Idx
 |  | AS OF
 |  |  |  |  |  |  |  |  |  | Last-Day | Cash | Cash | Change | BOM | BOM | Change | Prompt Month | Change | Q4 | Change | Winter 2001-02 | Change | Q1 | Change | Q2 | Change | Summer 2002 | Change | Q3 | Change | Q4 | Change | Winter 2002-03 | Change
 |  |  |  |  |  |  |  |  |  | Cash Settle | Price | Spread |  | Price | Spread |  |  |  | 2001 |  | Nov-01/Mar-02 |  | 2002 |  | 2002 |  | Apr-02/Oct-02 |  | 2002 |  | 2002 |  | Nov-02/Mar-03
 |  | California Region Notional
 |  |  |  |  | Sheet Name | Row Num for CurveName | Column Letter for Date
 |  |  |  | Basis | IndexCurves | 13 | B
 |  | Gas Trading |  | IntraMonth | CurveFetch | 4 | D
 |  |  |  |  |  |  |  |  | IntraMonth
 |  |  |  | IntraMonth Hub Curve | IF-HEHUB
 |  |  |  | IntraMonth Month | 2001-10-01 00:00:00
 |  |  |  |  | 2001-10-31 00:00:00 |  |  |  | Date Start |  |  |  |  |  |  |  | 2001-11-01 00:00:00 |  | 2001-10-01 00:00:00 |  | 2001-11-01 00:00:00 |  | 2002-01-01 00:00:00 |  | 2002-04-01 00:00:00 |  | 2002-04-01 00:00:00 |  | 2002-07-01 00:00:00 |  | 2002-10-01 00:00:00 |  | 2002-11-01 00:00:00
 |  |  |  |  |  |  |  |  | Date End |  |  |  |  |  |  |  |  |  | 2001-12-01 00:00:00 |  | 2002-03-01 00:00:00 |  | 2002-03-01 00:00:00 |  | 2002-06-01 00:00:00 |  | 2002-10-01 00:00:00 |  | 2002-09-01 00:00:00 |  | 2002-12-01 00:00:00 |  | 2003-03-01 00:00:00
 |  | WEST REGION BASIS NOTIONAL |  | Intra-Month | Basis |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IntraMonth Match |  | Basis Match
 |  | NGI-PGE/CG |  | NGI-PGE/CG | NGI-PGE/CG |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.043 |  |  |  | -0.0483 |  | -0.01 |  |  |  | -0.045 |  | -0.03
 |  | NGI-PGE/TOPOCK |  | NGI-PGE/TOPOCK | NGI-PGE/TOPOCK
 |  | NGI-MALIN |  | NGI-MALIN | NGI-MALIN
 |  | NGI-SOCAL |  | NGI-SOCAL | NGI-SOCAL
 |  | Southwest Region Notional
 |  | SAN JUAN |  | IF-ELPO/SJ | IF-ELPO/SJ
 |  | ELPO/PERMIAN |  | IF-ELPO/PERMIAN | IF-ELPO/PERMIAN
 |  | WAHA |  | IF-WAHA-TX | IF-WAHA-TX
 |  | NGPL/MIDCON |  | IF-NGPL/MIDCON | IF-NGPL/MIDCON
 |  | Northwest Region Notional
 |  | OPAL |  | IF-NWPL_ROCKY_M | IF-NWPL_ROCKY_M
 |  | STANFIELD |  | NW-STANFIELD | NW-STANFIELD
 |  | SUMAS |  | IF-NWPL/CNBR-US | IF-NTHWST/CANBR
 |  | AECO |  | CGPR-AECO/USIM | CGPR-AECO/BASIS
 |  | CIG |  | IF-CIG/RKYMTN | IF-CIG/RKYMTN
 |  | Ontario Region Notional
 |  | Central Region Notional
 |  | East & Texas Region Notional
 |  | Nymex
 |  | Nymex |  | IF-HEHUB | NG |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
Spreadsheet: 9224507f-ddee-4b7d-8bae-bb6cde0e996c
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FHER | Test | FHER | HER-2/neu, Quantitative, ELISA | HER-2/neu Quantitative ELISA | Enzyme Linked Immunosorbent Assay (ELISA) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Draw blood in a plain, red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 1 mL serum in a screw-capped vial, shipped frozen. | 0.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | Reference Range:  0.0 - 15.0 ng/mL  Note: Graph attached as a supplemental report in MayoAccess   Test Performed By:  LabCorp Burlington                               1447 York Court                               Burlington, NC 27215-2230 | Tuesday, Friday | 3 days | 4-8 days | 1 | 83950 |  |  |  |  | LabCorp Burlington
FHER | [NAME] | SERUM | Serum |  |  |  | Frozen
FHER | Result | Z0985 | HER-2/neu Quantitative | HER-2/neu Quantitative | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 32996-1
Spreadsheet: 686004d1594309979-find-last-date-in-row-and-return-header-return-header-index-match-lookup
Sheet: Table

 |  |  |  |  |  | KEY | Issued                           Date unknown     Allocated Pending   Problem With Issue  Allocated Undated |  | DD/MM/YY    BLANK  DD/MM/YY  DD/MM/YY     Allocated
Section | Issued To | Route | OM Area | Results | Comments | - | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ | BA | BB | BC | BD | BE | BF | BG
 |  |  |  |  |  | Unknown | Unknown | Unknown | Unknown | 2008-07-25 00:00:00 | Unknown | 2007-02-02 00:00:00 | 2008-02-02 00:00:00 | Unknown | Unknown | 2008-07-25 00:00:00 | 2011-10-28 00:00:00 |  |  |  | Not Used
 |  |  |  |  |  | Unknown | Unknown | 2007-02-02 00:00:00 | 2008-01-01 00:00:00 | 2008-01-02 00:00:00 | 2011-10-28 00:00:00 |  |  |  | Not Used |  |  |  |  |  | Not Used
 |  |  |  |  |  | Unknown | Unknown | Unknown | Unknown | 2007-02-02 00:00:00 | 2008-01-01 00:00:00 | 2008-01-02 00:00:00 | 2008-01-13 00:00:00 | 2008-01-13 00:00:00 | Unknown | Unknown | 2008-07-25 00:00:00 | 2010-12-09 00:00:00 | 2011-10-28 00:00:00 |  | Not Used
 |  |  |  |  |  | Unknown | Unknown | Unknown | Unknown | Unknown | 2007-02-02 00:00:00 | 02/0108 | 2008-01-13 00:00:00 | Unknown | Unknown | 2008-07-25 00:00:00 | 2011-10-28 00:00:00 |  |  |  | Not Used
 |  |  |  |  |  | Unknown | Unknown | Unknown | 2007-02-02 00:00:00 | 2008-01-02 00:00:00 | Unknown | 2008-07-25 00:00:00 | 2011-10-28 00:00:00 |  | Not Used |  |  |  |  |  | Not Used
 |  |  |  |  |  | Unknown | Unknown | Unknown | Unknown | Unknown | Unknown | Unknown | Unknown | 2007-02-02 00:00:00 | Not Used |  |  |  |  |  | Not Used
Spreadsheet: 1db54e07-7ae8-4297-94b8-0e7d53509b80
Sheet: 2008-09

Table L2
Graduate Students - Taught/Research Analysis by Fee Status
2008-09
Department | Taught Courses |  |  | Research |  |  | Total
 | Home | Overseas | Total | Home | Overseas | Total
Total
Faculty | Taught Courses |  |  | Research |  |  | Total
 | Home | Overseas | Total | Home | Overseas | Total
Total
The Clinical Sciences total includes the Graduate Institutes of Child Health, Neurology and Ophthalmology and the Eastman Dental Institute.
Spreadsheet: eric_saibi__9675__121701R
Sheet: South Bay 04

Owner Name |  | Duke Energy South Bay LLC
Station Name |  | South Bay Power Station
Unit Name |  | South Bay 04
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Natural Gas
Capacity |  | 240 MW
Start Date |  | 2001-09-29 00:00:00
End Date |  | 2001-12-23 00:00:00
Prv. Start Date |  | 2001-09-29 00:00:00
Prv. End Date |  | 2001-12-14 00:00:00
Comments |  | Running behind; hoping to be done by the holiday.
SIC |  | 4931
Plant ID |  | 1013339
Unit ID |  | 1007052
Outage ID |  | 15337
Spreadsheet: 747528d1631554557-formula-to-automatically-calculate-the-current-pto-accrual-by-paycheck-date-pto-for-year-to-last-pay-date-chocolista-
Sheet: Pay Periods

Employee | Vacation Rate | 2021-01-08 00:00:00
AUSTIN |  | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken | Accrued | Taken
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -8 |  | -8
 |  |  |  |  |  |  |  |  |  |  | -4 |  |  |  |  |  |  |  | -8 |  |  |  |  |  |  |  | -8
 |  |  | -2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -16 |  |  |  | -8
 |  |  | -3.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -4 |  | -8 |  | -24 |  | -8 |  | -4 |  |  |  | -8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -8 |  |  |  | -8
 |  |  |  |  |  |  |  |  |  |  | -8 |  | -24 |  |  |  | -8
 |  |  |  |  |  |  | -6 |  |  |  |  |  | -12 |  |  |  |  |  |  |  | -16 |  | -8 |  | -40 |  |  |  | -8
 |  |  |  |  |  |  |  |  | -4 |  | -16 |  |  |  |  |  |  |  | -4 |  |  |  |  |  | -12 |  |  |  | -24
 |  |  | -2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -8 |  |  |  | -6 |  | -10
 |  |  | -2
 |  |  |  |  |  |  | -4 |  |  |  |  |  |  |  |  |  | -40 |  |  |  |  |  |  |  |  |  | -8
 |  |  | -8 |  | -8 |  |  |  | -4 |  | -8 |  | -4 |  | -24 |  |  |  |  |  | -12 |  |  |  |  |  |  |  | -8 |  |  |  | -12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unpaid
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -40
 |  |  |  |  |  |  |  |  |  |  |  | May - Dec | Year 1 is the following year
 |  |  |  |  |  |  |  |  |  |  |  | Jan - Apr | Year 1 is this year
 |  |  |  |  |  |  |  |  |  |  |  | 50% can roll over
 |  |  |  |  |  |  |  |  |  |  |  | 8 mos calendar
 |  |  |  |  |  |  |  |  |  |  |  | 5.5 for first year
 |  |  |  |  |  |  |  |  |  |  |  | .5 for every year after the first
 |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hrs per PP | [NAME] | [NAME] | Pay Per | Hrs per Yr | PTO Days | PTO Wks
 |  |  |  |  |  |  |  |  |  |  |  | >1 | < | 12 | 80 | 1 |  | 26
 |  |  |  |  |  |  |  |  |  |  |  | >12 | < | 24 | 80 | 2 |  | 26
 |  |  |  |  |  |  |  |  |  |  |  | >24 | < | 36 | 80 | 3 |  | 26
 |  |  |  |  |  |  |  |  |  |  |  | >36 | < | 48 | 80 | 4 |  | 26
 |  |  |  |  |  |  |  |  |  |  |  | >48 | < | 60 | 80 | 5 |  | 26
Spreadsheet: 85427d1285529905-autofill-vlookup-function-stats-aggregate-example
Sheet: Week 10

TEAM AWESOME | ACW | Not Ready | Transfers | Hold | [NAME] | Unplanned Break |  | CSAT
1-2-1 = Done
1-2-1 = Ready
Week 10       Targets: | 00:00:20 | 0.15 | 0.15 | 00:01:10 | 0.07 | 0.005 |  | 4
user 1
user 2 | 0:00:25.549000 | 0.109681273865496 | 0.1355932203389831 | 0:01:25.393000 | 0.07941398031015404 | 0.01779878951606619
user 3 | 0:00:39.553000 | 0.0797726892241299 | 0.2793296089385475 | 0:01:40.581000 | 0.07063933480905522 | 0
user 4
user 5 | 0:00:21.256000 | 0.1756262605319209 | 0.2114537444933921 | 0:01:03.608000 | 0.07085367462725953 | 0.04307956194748647
user 6 | 0:00:59.093000 | 0.1529816061519394 | 0.2777777777777778 | 0:01:34 | 0.09216641784738458 | 0.00622517675558435
user 7 | 0:00:19.073000 | 0.09574301912103868 | 0.2359550561797753 | 0:02:01.101000 | 0.07059439692005184 | 0.005853004143963689 |  |  |  | Customer Install:
user 8 | 0:00:20.321000 | 0.375858648936561 | 0.2385321100917431 | 0:00:46.780000 | 0.06777357381625831 | 0.002840735162668822 |  |  |  | ACW=20s
user 9 | 0:00:28.895000 | 0.1016617331516547 | 0.2380952380952381 | 0:00:37.219000 | 0.07398706322730192 | 0.0108067471691021 |  |  |  | Not Ready=15%
user 10 | 0:00:19.290000 | 0.249885549547766 | 0.1741935483870968 | 0:00:23.439000 | 0.04743816582323901 | 0.01025723512453446 |  |  |  | Total Transfers=15% or less
user 11 | 0:00:03.884000 | 0.1286024794719047 | 0.07260726072607261 | 0:00:39.277000 | 0.08165620136317286 | 0.007178124832286803 |  |  |  | Hold=1min, 10sec
user 12 | 0:00:08.612000 | 0.1290563521173725 | 0.1940700808625337 | 0:01:07.407000 | 0.07510948093809047 | 0.02034900522396354
user 13 | 0:00:45.160000 | 0.1014914153198068 | 0.38 | 0:02:42.404000 | 0.06027360343812718 | 0.006361386314154617
user 14 | 0:00:08.416000 | 0.13117592775007 | 0.2922374429223744 | 0:01:03.311000 | 0.0831579274804807 | 0.003888307082940182
user 15 | 0:01:37.755000 | 0.1211345766612331 | 0.2884615384615384 | 0:03:32.260000 | 0.0754506664109694 | 0.02048974014766516
user 16 | 0:00:37.412000 | 0.1288264197936074 | 0.130718954248366 | 0:02:02.876000 | 0.0745735551072025 | 0
user 17
user 18 | 0:00:17.792000 | 0.1033419305273555 | 0.3153846153846154 | 0:03:13.031000 | 0.0635680184382374 | 0.02430993799045163
user 19 | 0:00:39.489000 | 0.1129471032745592 | 0.3043478260869565 | 0:02:43.864000 | 0.06861460957178842 | 0.005152932709607773
user 20
Spreadsheet: 826016d1681738415-change-price-depending-on-customer-work-carried-out-testsheet-help-aligw
Sheet: After

ID | Start time | Completion time | [NAME] | Name | Customer | Make | Model | [NAME] | BMW Model | [NAME] | [NAME] | Mercedes Model | Nissan Model | Volkswagen Model | New Model | Registration No | Mileage | VIN No | JOB NO | Vehicle scan documents | Systems that have been calibrated | Within specified Limits for manufacturer | Coded Control Unit | Outstanding safety defects | Notes | Work Carried Out | Equipment Used | ADAS Safety Status | Reason for calibration | Calibrated by | Price
6 | 2023-04-05 22:21:20 | 2023-04-05 22:21:48 | [EMAIL] | Leaf Heap | AGL | Mercedes |  |  |  |  |  | A-Class |  |  |  | RDHH | 4553 | RDHGERHEBHR | 4535 | Pre and Post Scan | Radar; | Yes | None; |  |  | ADAS Calibration | Texa; | Calibration Complete | Panel/bumper removal & refit; | Leaf Heap | 300
7 | 2023-04-05 22:22:45 | 2023-04-05 22:23:11 | [EMAIL] | Leaf Heap | DLG | Citroen |  |  |  | C1 |  |  |  |  |  | BXFGHBDRH | ET4TE4 | DRHXTJHTJFTXJTFXJ | 5EY5EY | Pre and Post Scan | Radar; | Yes | None; |  |  | ADAS Calibration | Texa; | Calibration Complete | Panel/bumper removal & refit; | Leaf Heap
8 | 2023-04-05 22:24:33 | 2023-04-05 22:25:16 | [EMAIL] | Leaf Heap | KC | Nissan |  |  |  |  |  |  | Juke |  |  | GDZSH | 43443 | ESTGHZERHDHXH | 45E454 | Pre and Post Scan | 360 Camera; | Yes | None; |  |  | ADAS Calibration | Autel; | Calibration Complete | Component removal & refit;Panel/bumper removal & refit; | [NAME]
9 | 2023-04-05 22:26:22 | 2023-04-05 22:26:56 | [EMAIL] | Leaf Heap | [NAME] | Ford |  |  |  |  | Puma |  |  |  |  | [NAME] | 5345 | TDSRGSERHZT | 4744 | Pre and Post Scan | Radar; | Yes | Radar; |  |  | Coding & Calibration | Texa;Manufacture Software; | Calibration Complete | Component removal & refit;Panel/bumper removal & refit; | [NAME]
10 | 2023-04-12 22:31:03 | 2023-04-12 22:31:34 | [EMAIL] | Leaf Heap | Komoo | BMW |  |  | X5 |  |  |  |  |  |  | DSG | GDGS | GSDGS | GGSD | Pre and Post Scan | Radar; | Yes | Airbag; |  |  | Coding & Calibration | Texa;Manufacture Software; | Calibration Complete | Component replacement;Presence of an error;Panel/bumper removal & refit; | [NAME]
11 | 2023-04-12 22:35:08 | 2023-04-12 22:43:33 | [EMAIL] | Leaf Heap | Stoneacre | Volkswagen |  |  |  |  |  |  |  | Polo |  | FEWG | GDSG | FDHD | HDFHDFH | Pre and Post Scan | Radar; | Yes | None; |  |  | ADAS Calibration | Texa; | Calibration Complete | Presence of an error;Panel/bumper removal & refit; | [NAME]
12 | 2023-04-17 13:11:19 | 2023-04-17 13:11:46 | anonymous |  | AGL | Volkswagen |  |  |  |  |  |  |  | Golf |  | dwafgesg | sgxdfgh | hfdhdfh | gjgfjmg | Pre and Post Scan | Radar; | Yes | None; |  |  | Coding & Calibration | Texa; | Calibration Complete | Panel/bumper removal & refit; | Leaf Heap | 420
Spreadsheet: 853376d1703246024-issue-qty-equals-to-purchase-qty-xl-help
Sheet: Sheet1

TRAN TYPE | ITEM CODE | RECEIPT QTY | ISSUE QTY |  | DESIRED RESULT (ISSUE QTY)
PURC | A | 10 |  |  | 0
PURC | A | 20 |  |  | 0
PURC | A | 60 |  |  | 0
SALE | A | 0
PURC | A | 120 |  |  | 0
SALE | A | 0
TRFR | A | 0 |  |  | 0
PURC | B | 40 |  |  | 0
PURC | B | 50 |  |  | 0
PURC | B | 45 |  |  | 0
TRFR | B | 0
SALE | B | 0 |  |  | 0
PURC | B | 95 |  |  | 0
SALE | B | 0
PURC | C | 70 |  |  | 0
PURC | C | 80 |  |  | 0
PURC | C | 75 |  |  | 0
SALE | C | 0
PURC | C | 101 |  |  | 0
PURC | C | 123 |  |  | 0
SALE | C | 0
TRFR | C | 0 |  |  | 0
PURC | D | 100 |  |  | 0
PURC | D | 110 |  |  | 0
PURC | D | 101 |  |  | 0
SALE | D | 0
PURC | D | 211 |  |  | 0
SALE | D | 0
TRFR | D | 0 |  |  | 0
PURC | E | 130 |  |  | 0
TRFR | E | 0
PURC | E | 140 |  |  | 0
PURC | E | 77 |  |  | 0
SALE | E | 0
PURC | E | 99 |  |  | 0
SALE | E | 0