tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 28016308-112a-4e37-81a6-e70866bf9f67
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
9273 | Test | 9273 | Subcutaneous Fat Aspirate | Subcutaneous Fat Aspirate |  |  |  |  |  | Varies | Container/Tube: [NAME] slides or sterile container [NAME] Minimum of 4 slides or 1 cubic mm Collection Instructions: 1. Sterilize and anesthetize a small area of the anterior abdominal wall. 2. Aspirate subcutaneous fat through a large bore needle. 3. Apply the fat obtained in the syringe directly to a glass slide and crush with a second slide. 4. Air dry the slides and send without fixative. 5. Alternately, send fat in small container of saline. Additional Information: The following information is required: a. Patient's date of birth [NAME] and telephone number of ordering physician c. Pertinent clinical information | 1 cubic mm fat/4 slides | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Negative (reported as positive or negative) | Monday through Friday; Varies | 1 day | 4 days | 1 | 88313 |  |  |  |  | Rochester
9273 | [NAME] | MIXED | Mixed |  |  |  | Ambient
9273 | Result | 18712 | Accession Number | Accession Number
9273 | Result | 18713 | Referring Pathologist/Physician | Referring Pathologist/Physician |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46608-6 | Primary referring physician ID:ID:Pt:Provider:Nom:
9273 | Result | 18714 | Ref Path/Phys Address | Ref Path/Phys Address |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
9273 | Result | 18715 | Material: | Material:
9273 | Result | 18748 | Tissue: | Tissue: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
9273 | Result | 18717 | Interpretation: | Interpretation: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
9273 | Result | 18948 | Comment: | Comment: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8 | Annotation comment:Imp:Pt:{system}:Nar:
9273 | Result | 18718 | SP Signing Pathologist: | SP Signing Pathologist:
9273 | Result | 18719 | *Previous Report Follows* | *Previous Report Follows*
9273 | Result | 18720 | [NAME]: | [NAME]: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35265-8 | Path report.addendum:Find:Pt:[NAME]:Nar:
9273 | Result | 19191 | [NAME] Comment: | [NAME] Comment: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22638-1 | Path report.comments:Imp:Pt:[NAME]:Nar:
9273 | Result | 18721 | [NAME] Pathologist: | [NAME] Pathologist: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19139-5 | Pathologist name:PN:Pt:Provider:Nom:
Spreadsheet: harry_arora__12174__Vol Book Daily Market
Sheet: Summary Nepool

Daily Option Payoff |  |  |  | 1998 | 1998 |  |  |  | 1999 | 1999 |  |  |  | 2000 | 2000 |  |  |  | 2001 | 2001
 |  |  |  | C | P |  |  |  | C | P |  |  |  | C | P |  |  |  | C | P
35 |  | 2001-01-01 00:00:00
35 |  | 2001-02-01 00:00:00
30 |  | 2001-01-01 00:00:00
30 |  | 2001-02-01 00:00:00
25 |  | 2001-01-01 00:00:00
25 |  | 2001-02-01 00:00:00
20 |  | 2001-01-01 00:00:00
20 |  | 2001-02-01 00:00:00
100 |  | 2001-07-01 00:00:00
100 |  | 2001-08-01 00:00:00
50 |  | 2001-07-01 00:00:00
50 |  | 2001-08-01 00:00:00
40 |  | 2001-07-01 00:00:00
40 |  | 2001-08-01 00:00:00
30 |  | 2001-09-01 00:00:00
25 |  | 2001-09-01 00:00:00
20 |  | 2001-09-01 00:00:00
30 |  | 2001-10-01 00:00:00
30 |  | 2001-11-01 00:00:00
30 |  | 2001-12-01 00:00:00
30 |  | Q4
25 |  | 2001-10-01 00:00:00
25 |  | 2001-11-01 00:00:00
25 |  | 2001-12-01 00:00:00
25 |  | Q4
20 |  | 2001-10-01 00:00:00
20 |  | 2001-11-01 00:00:00
20 |  | 2001-12-01 00:00:00
20 |  | Q4
Cash Market |  |  |  | [NAME] | Gas | Gas | [NAME] |  | [NAME] | Gas | Gas | [NAME] |  | [NAME] | Gas | Gas | [NAME] |  | [NAME] | Gas | Gas | [NAME]
 |  |  |  | Daily | Daily | Heat | over |  | Daily | Daily | Heat | over |  | Daily | Daily | Heat | over |  | Daily | Daily | Heat | over
 |  |  |  | Nepool | HH | Rate | Capacity |  | Nepool | HH | Rate | Capacity |  | Nepool | HH | Rate | Capacity |  | Nepool | HH | Rate | Capacity
 |  |  |  | 1998 | 1998 | 1998 | 1998 |  | 1999 | 1999 | 1999 | 1999 |  | 2000 | 2000 | 2000 | 2000 |  | 2001 | 2001 | 2001 | 2001
 |  | Price
 |  | 2001-01-01 00:00:00
 |  | 2001-02-01 00:00:00
 |  | 2001-07-01 00:00:00
 |  | 2001-08-01 00:00:00
 |  | 2001-09-01 00:00:00
 |  | 2001-10-01 00:00:00 | 22 |  |  |  |  | 21 |  |  |  |  | 22
 |  | 2001-11-01 00:00:00 | 19 |  |  |  |  | 20 |  |  |  |  | 21
 |  | 2001-12-01 00:00:00 | 22 |  |  |  |  | 21 |  |  |  |  | 20
 |  | Q4
 |  | Actualized Vol
 |  | 2001-01-01 00:00:00
 |  | 2001-02-01 00:00:00
 |  | 2001-07-01 00:00:00
 |  | 2001-08-01 00:00:00
 |  | 2001-09-01 00:00:00
 |  | 2001-10-01 00:00:00 | 22 |  |  |  |  | 21 |  |  |  |  | 22
 |  | 2001-11-01 00:00:00 | 19 |  |  |  |  | 20 |  |  |  |  | 20
 |  | 2001-12-01 00:00:00 | 22 |  |  |  |  | 21 |  |  |  |  | 20
 |  | Q4
Spreadsheet: 828166d1683275594-get-spilling-counts-ranks-get_spilling_rank
Sheet: Feuil1

type |  |  |  |  |  |  |  | type |  | rank copy down (works) |  | rank spilling (does not work)
A
A |  |  |  |  |  |  |  | A |  |  |  | #REF! | 2 |  | 2 | 2
B |  |  |  |  |  |  |  | B |  |  |  | #REF! | 1 |  | 1 | 1
B |  |  |  |  |  |  |  | B |  |  |  | #REF! | 2 |  | 2 | 2
B |  |  |  |  |  |  |  | B |  |  |  | #REF! | 3 |  | 3 | 3
C |  |  |  |  |  |  |  | C |  |  |  | #REF! | 1 |  | 1 | 1
C |  |  |  |  |  |  |  | C |  |  |  | #REF! | 2 |  | 2 | 2
Spreadsheet: 174271d1344981379-excel-math-calculations-calculation-example
Sheet: Sheet1

 | SUBTOTALS | TOTALS | A1 | A2 | A4 | A5 | A6 | A9-1(U)
 |  |  | 540 | 3 | 55 | 293 | 95 | 7
Insulator - C-Neck Pin Type | 37 | TOTAL | 1 |  |  |  | 1 | 1
Insulator - F-Neck Pin Type | 20 | TOTAL
Insulator [NAME] | 30 | TOTAL | 1 | 2 | 1 | 1 | 2 | 1
Insulator [NAME] | 0 | TOTAL
Insulator - Hetherlite | 19 | TOTAL |  | 2 | 1 | 1 | 2
Insulator - Porclain | 0 | TOTAL
Washer - 5/8" DBL Coil Spring Lock | 223 | TOTAL | 4 | 7 | 4 | 1 | 7 | 6
Washer - 1/2" DBL Coil Spring Lock | 24 | TOTAL |  |  |  |  |  | 2
Washer - 3/8" DBL Coil Spring Lock | 0 | TOTAL
Washer - 3/4" DBL Coil Spring Lock | 0 | TOTAL
Washer - Curver - 3" x 3" x 5/8" | 119 | TOTAL | 6 | 10 | 6 | 6 | 8 | 4
Washer - Square - 2-1/4" x 2-1/4" x 5/8" | 192 | TOTAL |  |  |  |  |  | 6
Washer - Square - 2" x 2" x 1/2" | 24 | TOTAL |  |  |  |  |  | 2
Washer - Square - 3" x 3" x 3/4" | 12 | TOTAL
Spreadsheet: sally_beck__35334__cashcoll0901(1)
Sheet: Panama

Panama - Balances >$50,000
Counterparty | Amount | Due Dates | Paid | Desk
Egeminsa | 211628 | 2001-09-02 00:00:00 | 2001-09-07 00:00:00 | [NAME]
Egeminsa | 211628 | 2001-09-04 00:00:00 | 2001-09-07 00:00:00 | [NAME]
Egeminsa | 211628 | 2001-09-06 00:00:00 | 2001-09-07 00:00:00 | [NAME]
Egeminsa | 276861 | 2001-09-04 00:00:00 | 2001-09-07 00:00:00 | [NAME]
Egeminsa | 276861 | 2001-09-06 00:00:00 | 2001-09-07 00:00:00 | [NAME]
Egeminsa | 211628 | 2001-09-07 00:00:00 |  | [NAME]
Egeminsa | 105661.5 | 2001-09-10 00:00:00 |  | [NAME]
Egeminsa | 105661.5 | 2001-09-10 00:00:00 |  | [NAME]
Egeminsa | 276605 | 2001-09-10 00:00:00 |  | [NAME]
Egeminsa | 211323 | 2001-09-12 00:00:00 |  | [NAME]
Egeminsa | 276605 | 2001-09-12 00:00:00 |  | [NAME]
Egeminsa | 327034.5 | 2001-09-10 00:00:00 |  | [NAME]
Egeminsa | 211323 | 2001-09-17 00:00:00 |  | [NAME]
Egeminsa | 276605 | 2001-09-17 00:00:00 |  | [NAME]
Egeminsa | 211323 | 2001-09-18 00:00:00 |  | [NAME]
Egeminsa | 276605 | 2001-09-19 00:00:00 |  | [NAME]
Egeminsa | 276605 | 2001-09-21 00:00:00 |  | [NAME]
Egeminsa | 85993.6 | 2001-09-24 00:00:00 |  | [NAME]
Egeminsa | 124878.4 | 2001-09-24 00:00:00 |  | [NAME]
Egeminsa | 279761 | 2001-09-24 00:00:00 |  | [NAME]
Egeminsa | 279761 | 2001-09-25 00:00:00 |  | [NAME]
Egeminsa | 210872 | 2001-09-26 00:00:00 |  | [NAME]
Egeminsa | 279761 | 2001-09-28 00:00:00 |  | [NAME]
PetroPeru S.A. | 59222.25 | 2001-09-27 00:00:00 |  | [NAME]
Total
Unpaid @ 09/30/01
excludes intercompany
Spreadsheet: 51079d1250643578-excel-2007-summing-coloured-cells-junk
Sheet: Sheet1

 |  | Current | 1 - 30 | 31 - 60 | 61 - 90 | 91 - 120 | TOTAL
 |  | 0 | 0 | 0 | 0 | 116.6
 |  | 0 | 0 | 3829.05 | 0 | 0
 |  | 0 | 109.92 | 0 | 2543.49 | 774.54
 |  | 0 | 0 | 0 | 0 | 76.84
 |  | 0 | 0 | 484.05 | 0 | 0
 |  | 0 | 0 | 0 | 27.7 | 0
 |  | 0 | 0 | 110 | 308 | 462
 |  | 0 | 373.42 | 2366.33 | 2327.48 | 0
 |  | 0 | 0 | 0 | 0 | 99.86
 |  | 0 | 0 | 0 | 0 | 613.8
 |  | 0 | 0 | 0 | 0 | 723.66
 |  | 0 | 0 | 281.71 | 381.95 | 110.64
 |  | 0 | 1200.21 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 451
 |  | 0 | 0 | 0 | 23.1 | 0
 |  | 0 | 480.05 | 447.25 | 0 | 0
 |  | 0 | 0 | 0 | 247.6 | 595.2
 |  | 0 | 0 | 0 | 428.8 | 978.24
 |  | 0 | 0 | 1815 | 0 | 0
 |  | 0 | 0 | 0 | 122.21 | 0
 |  | 0 | 324.86 | 218.46 | 350.6 | 2912.85
 |  | 0 | 0 | 0 | 560 | 0
 |  | 0 | 0 | 0 | 1144 | 0
 |  | 0 | 0 | 0 | 0 | 865.7
 |  | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 1775.85 | 0 | 0
 |  | 0 | 0 | 663.6 | 0 | 0
 |  | 0 | 0 | 110 | 0 | 0
 |  | 0 | 0 | 0 | 5 | 0
 |  | 0 | 0 | 0 | 0 | 125.5
 |  | 0 | 1741.54 | 0 | 0 | 0
 |  | 0 | 0 | 318.08 | 0 | 0
 |  | 0 | 0 | 180 | 0 | 0
 |  | 0 | 612.3 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 1072.33 | 0 | 0
 |  | 0 | 0 | 338.31 | 1037.88 | 0
TOTAL
 |  |  | August | July | June | May | Total
 | Construction
 | Demands
 | Urgent
 | Key Accounts Due
Spreadsheet: 776871d1649950958-how-to-write-a-formula-to-repeat-and-exclude-empty-correspondences-to-get-the-qty-hforum414-example2
Sheet: Sheet1

TYPE A | TYPE B |  | TYPE A | QTY |  | RESULT
延 | a |  | 延 | 2 | [NAME] |  |  | << formula
辽 | d |  | 辽 | 1 |  | 辽 |  | << formula
吉 | a |  | 吉 | 3 |  | 吉 |  | << formula
延 |  |  | 长 | 3 |  | 长 |  | << formula
延 | d |  | 四 | 1 |  | 四 |  | << formula
长 | b |  | 通 | 2 |  | 通 |  | << formula
四 | a |  | 重 | 1 |  | 重 |  | << formula
吉 | b
延 | a
通 | c
通
通 | d
长 | e
长
吉
吉 | f
重 | a
长
长 | g
长
吉 | a
吉 | a
Spreadsheet: 158061d1337964782-excel-send-email-using-outlook-03-automatically-when-expiry-date-is-coming-up-test_
Sheet: Calibration due

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Equipment number | Equipment name | Person responsible | [NAME] | Calibration due date | [NAME] sent
FWB130 | 6HP Engine | [NAME] | [EMAIL] | 2012-05-23 00:00:00 | 2012-05-25 19:51:22 |  | FWB123 | 15HP engine | [NAME]
FWB001 | 7HP Engine | [NAME] | [EMAIL] | 2012-05-26 00:00:00 | 2012-05-25 19:51:23 |  | FSD789 | 89hp | Martin
Spreadsheet: frank_ermis__11228__West NatGas Prices 1121
Sheet: Gas Average FinIdx

FinIdx Curves
 |  | WEST NATURAL GAS PRICES- Fin 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
 |  |  |  |  |  |  |  |  | Date Start |  |  |  |  |  |  |  |  |  | 2001-10-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 | GD-PG&E/CITIGAT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.043 |  |  |  | -0.0483 |  | -0.01 |  |  |  | -0.045 |  | -0.03
 |  | NGI-PGE/TOPOCK |  | NGI-PGE/TOPOCK | GDP-PGE/TOPOCK
 |  | NGI-MALIN |  | NGI-MALIN | GDP-MALIN-CTYGA
 |  | NGI-SOCAL |  | NGI-SOCAL | GDP-CAL BORDER
 |  | Southwest Region Notional
 |  | SAN JUAN |  | IF-ELPO/SJ | GDP-ELPO/SANJUA
 |  | ELPO/PERMIAN |  | IF-ELPO/PERMIAN | GDP-ELPO/PERM2
 |  | WAHA |  | IF-WAHA-TX | GDP-WAHA
 |  | NGPL/MIDCON |  | IF-NGPL/MIDCON | GDP-NGPL/OK
 |  | Northwest Region Notional
 |  | OPAL |  | IF-NWPL_ROCKY_M | GDP-KERN/OPAL
 |  | STANFIELD |  | NW-STANFIELD | GD-NW STANFIELD
 |  | SUMAS |  | IF-NWPL/CNBR-US | GDP-NTHWST/CANB
 |  | AECO |  | CGPR-AECO/USIM | [NAME]
 |  | CIG |  | IF-CIG/RKYMTN | GDP-CIG/RKYMTN
 |  | Ontario Region Notional
 |  | Central Region Notional
 |  | East & Texas Region Notional
 |  | Nymex
 |  | Nymex |  | GDP-HEHUB | NG
Spreadsheet: 267346d1380050067-returning-matching-keywords-answer
Sheet: Sheet1

Title | Result |  |  |  | Keyword
CEO | 1 |  |  |  | Chief
CEO | 1 |  |  |  | Vice
CEO | 1 |  |  |  | Director
Chief Executive Officer | 1 |  |  |  | Manager
Director | 1 |  |  |  | General
Director | 1 |  |  |  | CEO
Director | 1 |  |  |  | CFO
Executive | False |  |  |  | COO
Managing Director | 1 |  |  |  | CTO
Owner | False
Senior Partner | False
Spreadsheet: 777474d1650404382-can-a-date-update-itself-based-off-the-expiring-date-can-a-date-update-itself-based-off-the-expiring-date
Sheet: Simple Customer Contact List

 |  | Client List
 |  | Company Name | CONTACT NAME | CONTACT TITLE | EFFECTIVE DATE | Expiration Date | PHONE 1 | EMAIL ADDRESS | MAILING ADDRESS | NOTES
 |  | Insurance Co. | [NAME] | Mrs. [NAME] | 2021-08-21 00:00:00 |  | 1234567891 | [EMAIL] | 123 Road, Washington D.C. | Policy
 |  | Other Insurance Co. | [NAME] | [NAME] | 2021-10-15 00:00:00 |  | 1112223333 | [EMAIL] | [NAME], Washington D.C. | Policy
 |  | http://bit.ly/3iJLFFV
Spreadsheet: 58849d1259112529-refer-to-previous-sheet-worksheets
Sheet: Sheet1

Sheet name fun |  |  |  |  |  |  |  | list of worksheets in this book
 | This workbook has | 7 | sheets |  |  |  | This cell must be refreshed when the workbook names or order is changed >> | Sheet1
 |  |  |  |  |  |  |  | Mother
 | the previous sheet is |  |  |  |  |  |  | Grandmother
 | I am on sheet | Sheet1 |  |  |  |  |  | Daughter
 | the next sheet is | Mother |  |  |  |  |  | Father
 |  |  |  |  |  |  |  | Grandfather
 |  |  |  |  |  |  |  | Son
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
Spreadsheet: 464583d1465217357-draging-info-from-master-sheet-to-other-sheets-draging-info-prc
Sheet: Broken

Date | Animal | Owner | Contact #
Date | Animal | Illness | Owner | Contact #
2015-12-12 00:00:00 | Cat | [NAME] | Owner3 | 222222
2016-05-01 00:00:00 | Cat | [NAME] | Owner1 | 1258423
Grand Total
Spreadsheet: mary_fischer__25634__31Q
Sheet: E12.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  031Q
COMPANY NAME    Limbach Constructors
ANALYSIS OF LONG-TERM DEBT
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  | ** Credit Positive Liability  (Debit Negative Liability) **
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-12
 |  |  |  |  |  |  |  | ORIGINAL |  | BEGINNING BALANCE |  |  |  |  |  |  |  |  |  | OTHER (NON-CASH) |  |  |  | ENDING BALANCE
PAYEE AND [NAME] |  | HYPERION |  | DUE |  | INTEREST |  | AMOUNT |  | CURRENT |  | LONG-TERM |  |  |  | ADDITIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | CURRENT |  | LONG-TERM
 |  | ACCOUNT |  | DATE |  | RATE |  | AUTHORIZED |  | PORTION |  | PORTION |  | TOTAL |  | DR (CR) |  | DR (CR) |  | DR (CR) |  |  |  | PORTION |  | PORTION |  | TOTAL
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Current:
Current Maturities of Long-Term Debt * |  | 0450 |  |  |  | 0
Notes Payable - Other |  | TOT_NP_OTHER
Total Short-Term
Long-Term:
Long-Term Debt (Hyperion Accts. 0705, 0770)
Notes (list by name of payee or issue):
Total (Hyperion Accts 0705 & 0770)
Current Maturities of L/T Debt (Contra) * |  | 0775
Unamortized Premium on L/T Debt |  | 0765
Total Long-Term Debt
Total Debt  DR/(CR)
!!DO NOT INCLUDE INTERCOMPANY DEBT!!
*  HYPERION ACCOUNTS 0450 & 0775 MUST BE THE SAME AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-12
 |  |  |  | Income Accts:  (DR)/CR Reverse signs from Hyperion
 |  |  |  |  |  |  | Income Accts: (DR)/CR  Reverse signs from Hyperion
Spreadsheet: 71573d1272354774-vlookup-if-blank-do-vlokup-to-a-different-column-test-file
Sheet: List

Service Number | System.Name
8221KN7Z202V | A00748
CZC34603ZS | A00822
CZC34603V2 | A02592
CZC347106Q
CZC3471069 | A04306
8134FHGZ0DTT | [NAME]
8944CV620246 | A04683
8938CV623896 | A04695
8944CV620246 | A04699
8938CV623896
5TZK92J | A03355
7F6JL2J | A03356
40KGK3J
3VPGK3J | A0456
2WPGK3J
Spreadsheet: 73767d1274353661-index-match-formular-multiple-answers-cello
Sheet: Data

 |  |  | [NAME] | BTYOYY | 2010-03-12 00:00:00
 |  |  | [NAME] | BTYOYY | 2010-03-13 00:00:00
` |  |  | [NAME] | BTYOYY | 2010-03-14 00:00:00
 |  |  | [NAME] | TTRDFF | 2010-03-14 00:00:00
 |  |  | [NAME] | TTRDFF | 2010-03-15 00:00:00
 |  |  | [NAME] | TTRDFF | 2010-03-14 00:00:00
 |  |  | [NAME] | TTRDFF | 2010-03-12 00:00:00
 |  |  | [NAME] | UYHGFF | 2010-03-12 00:00:00
Spreadsheet: 6600eefc-ac78-4cf9-a5d8-841b7bd4f932
Sheet: Sheet1

n | Unnamed: 1 | Unnamed: 2
Target Genomes | Core* | Specific**
N. fischeri | 8676 | 956
A. clavatus | 7514 | 818
A. terreus | 6460 | 728
A. oryzae | 6029 | 643
A.nidulans | 5683 | 616
A. niger | 5424 | 595
*Number of Af293 gene that have orthologs in target genomes in this row and all the rows above
**Number of Af293 gene that have no orthologs in target genomes in this row and all the rows above
Spreadsheet: 542528d1507904220-how-to-get-series-of-progressive-date-error-in-going-to-next-year-progessive-date
Sheet: Sheet1

Dates ---progressive with 5units | Day
2017-10-01 00:00:00
 | Until this, it is ok
 | <---Here expected value is 4/1/2018
Spreadsheet: 825802d1681542242-substitute-issue-sub-example-v2
Sheet: Sheet1

Item | Sub |  | Item | Sub |  | First 4 digits | item | 1st row | Last row | Subs
8000 2BKA GRW | 8000 4XSE AXC |  | 8000 2BKA GRW | 8000 4XSE AXC |  |  |  |  |  |  | 8000 4XS NDW | 8000 4XSJCZ SLP | 8000-2NBE3C3 QGA
8000 2BKA GRW | 8000 4XS NDW |  | 8000 2BKA GRW | 8000 4XS NDW |  | 2208 |  |  |  |  | 2208-6SB MNS
8000 2BKA GRW | 8000 4XSJCZ SLP |  | 8000 2BKA GRW | 8000 4XSJCZ SLP |  | 4857 |  |  |  |  | 4857HHB4/EB WRE | 4857-HHD-B4 YER
8000 2BKA GRW | 8000-2NBE3C3 QGA |  | 8000 2BKA GRW | 8000-2NBE3C3 QGA
8000 4XSE AXC | 8000 2BKA GRW |  | 2208-6SB B2A | 2208-6SB GWG
8000 4XSE AXC | 8000 4XS NDW |  | 2208-6SB B2A | 2208-6SB MNS
8000 4XSE AXC | 8000 4XSJCZ SLP |  | 4857HHB4 RTE | 4857HHB4 VBN
8000 4XSE AXC | 8000-2NBE3C3 QGA |  | 4857HHB4 RTE | 4857HHB4/EB WRE
8000 4XS NDW | 8000 4XSE AXC |  | 4857HHB4 RTE | 4857-HHD-B4 YER
8000 4XS NDW | 8000 2BKA GRW
8000 4XS NDW | 8000 4XSJCZ SLP
8000 4XS NDW | 8000-2NBE3C3 QGA
8000 4XSJCZ SLP | 8000 4XSE AXC
8000 4XSJCZ SLP | 8000 4XS NDW
8000 4XSJCZ SLP | 8000 2BKA GRW
8000 4XSJCZ SLP | 8000-2NBE3C3 QGA
8000-2NBE3C3 QGA | 8000 4XSE AXC
8000-2NBE3C3 QGA | 8000 4XS NDW
8000-2NBE3C3 QGA | 8000 2BKA GRW
8000-2NBE3C3 QGA | 8000 2BKA GRW
2208-6SB B2A | 2208-6SB GWG
2208-6SB B2A | 2208-6SB MNS
2208-6SB GWG | 2208-6SB B2A
2208-6SB GWG | 2208-6SB MNS
2208-6SB MNS | 2208-6SB GWG
2208-6SB MNS | 2208-6SB B2A
4857HHB4 RTE | 4857HHB4 VBN
4857HHB4 RTE | 4857HHB4/EB WRE
4857HHB4 RTE | 4857-HHD-B4 YER
4857HHB4 VBN | 4857HHB4 RTE
4857HHB4 VBN | 4857HHB4/EB WRE
4857HHB4 VBN | 4857-HHD-B4 YER
4857HHB4/EB WRE | 4857HHB4 RTE
4857HHB4/EB WRE | 4857HHB4 VBN
4857HHB4/EB WRE | 4857-HHD-B4 YER
4857-HHD-B4 YER | 4857HHB4 VBN
4857-HHD-B4 YER | 4857HHB4/EB WRE
4857-HHD-B4 YER | 4857HHB4 RTE
Spreadsheet: 875192d1721768012-time-card-leave-time-cards-for-modules
Sheet: Time Card

 | NAME | {1}
 |  | TIME REPORT FOR WORK PERIOD BEGINNING |  |  |  |  |  | {3}
 | DATE |  |  |  | Other | Leave Hours | CALL BACK |  | Total Call Back | Total Hrs.
 |  | In | Out | Total Hrs |  |  | In | Out
 | {3} | {4} | {5} | 1900-01-01 00:00:00 | {8} |  | {9} | {10} | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | #N/A | {11} | {12} | 1900-01-01 00:00:00 | {15} |  | {16} | {17} | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | #N/A | {18} | {19} | 1900-01-01 00:00:00 | {22} |  | {23} | {24} | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | #N/A | {25} | {26} | 1900-01-01 00:00:00 | {29} |  | {30} | {31} | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | #N/A | {32} | {33} | 1900-01-01 00:00:00 | {36} |  | {37} | {38} | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | #N/A | {39} | {40} | 1900-01-01 00:00:00 | {43} |  | {44} | {45} | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | #N/A | {46} | {47} | 1900-01-01 00:00:00 | {50} |  | {51} | {52} | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | #N/A | {53} | {54} | 1900-01-01 00:00:00 | {57} |  | {58} | {59} | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | #N/A | {60} | {61} | 1900-01-01 00:00:00 | {64} |  | {65} | {66} | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | #N/A | {67} | {68} | 1900-01-01 00:00:00 | {71} |  | {72} | {73} | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | #N/A | {74} | {75} | 1900-01-01 00:00:00 | {78} |  | {79} | {80} | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | #N/A | {81} | {82} | 1900-01-01 00:00:00 | {85} |  | {86} | {87} | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | #N/A | {88} | {89} | 1900-01-01 00:00:00 | {92} |  | {93} | {94} | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | #N/A | {95} | {96} | 1900-01-01 00:00:00 | {99} |  | {100} | {101} | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | Total Hrs | 1900-01-01 00:00:00
 | Other Codes
H | H - Holiday |  |  | {104.signature}
V | V- Vacation |  |  | Emploee Signature
S | S - Sick
FSL | FSL - Family Sick Leave |  |  | Reviewing/Approving Supervisor
PL | PL - Personal Leave
ML | ML - Military Leave |  |  | {105}
DO | DO - Day Off |  |  | Supervisor
ATD | ATD - AT Day
ATH | ATH - AT
BL | BL - Bereavement Leave |  |  |  |  | Check one box
UL | UL - Union Leave |  |  |  |  | {102} | Pay straight hours
DO/H | DO/H - Day Off Holiday
ATH/H | ATH/H AT hours on Holiday |  |  |  |  | {103} | Bank straight hours
 | AT Used | #N/A |  | Vacation
 | or |  |  | Sick |  | #N/A
 | AT Banked | #N/A |  | Personal |  | #N/A
 |  |  |  | Holiday
 |  |  |  | Military |  | #N/A
 |  | 80 hours |  | Bereave. |  | #N/A
 | Straight | #N/A |  | Fam Sick |  | #N/A
 | Overtime | #N/A |  | Union |  | #N/A
Spreadsheet: 270781d1381656951-excel-formula-need-help-understanding-formula-countif
Sheet: Sheet1

a | b | c | =COUNTIF(A1:C23,"><-") |  | --> only count the red
d | e | f | =COUNTIF(A1:C23,"<>-")
g | h | i
j | k | l
m | n | o
p | q | r
s | t | u
v | w | x
y | z | `
~ | ! | @
# | $ | %
^ | & | *
( | ) | -
_ | = | +
{ | } | [
] |  | \
: | ; | "
 | < | >
, | . | ?
/ | 1 | 2
3 | 4 | 5
6 | 7 | 8
9 | 0
Spreadsheet: 748735d1632319356-work-out-daily-amount-to-target-31-day-figures
Sheet: 11th

 |  |  |  | TURNOVER |  |  |  |  | REVENUE
 | AREA 3 |  |  | Target | Needed Daily | Actual | [NAME] |  | Target | Needed Daily | Actual | [NAME] |  | [NAME]'s | ATV |  | [NAME] | SALT £ |  | TMC |  | BB+ |  | Errors
 | Asda - Aintree
 | Asda - Huyton
 | Asda - Hunts Cross
 | Asda - Horwich
 | Asda - Leigh
 | Asda - Burnley
 | Asda - Westbrook
 | Asda - Widnes
 | Asda - Bromborough
 | Asda - Accrington
 | Asda - Colne
 | Asda - Clayton Green
 | Asda - Runcorn
 | Asda - Blackburn
 | Asda - Walton
 | Asda - Blackpool
 | Asda - Wigan
 | Asda - Preston