tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 890003fb-27ec-497c-9132-70af3ab9bca2
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
GRAP | Test | GRAP | Grape, IgE | Grape, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
GRAP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
GRAP | Result | GRAP | Grape, IgE | Grape, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6841-1
Spreadsheet: 769095d1645287429-how-many-unique-areas-have-been-visited-by-vehicle-in-date-range-report
Sheet: Report

Weekly Number of DO per vehicle
From | To | 11/17055 | 1/63335 | 1/64134 | 1/67031 | 11/69228 | 13/51504 | 13/51623 | 13/51814 | 13/54318 | 13/807714 | 13/80774 | 13/80857 | 15/70824 | 2/98435 | 3/15531 | 8/12539
2021-11-01 00:00:00
Monthly
In below table I would like to count no of area delivered by each vehicle on the specific date
 | To | 11/17055 | 1/63335 | 1/64134 | 1/67031 | 11/69228 | 13/51504 | 13/51623 | 13/51814 | 13/54318 | 13/807714 | 13/80774 | 13/80857 | 15/70824 | 2/98435 | 3/15531 | 8/12539
 | 2021-11-01 00:00:00 | 2
 | 2021-11-02 00:00:00 | 2
 | 2021-11-03 00:00:00 | 2
 | 2021-11-04 00:00:00 | 2
 | 2021-11-06 00:00:00 | 2
 | 2021-11-07 00:00:00 | 4
 | 2021-11-08 00:00:00 | 4
 | 2021-11-09 00:00:00 | 2
 | 2021-11-10 00:00:00 | 3
 | 2021-11-11 00:00:00 | 3
 | 2021-11-13 00:00:00 | 2
 | 2021-11-14 00:00:00 | 2
 | 2021-11-15 00:00:00 | 2
 | 2021-11-16 00:00:00 | 2
 | 2021-11-17 00:00:00 | 2
 | 2021-11-18 00:00:00 | 2
 | 2021-11-20 00:00:00 | 2
 | 2021-11-21 00:00:00 | 3
 | 2021-11-22 00:00:00 | 2
 | 2021-11-23 00:00:00 | 2
 | 2021-11-24 00:00:00 | 2
 | 2021-11-25 00:00:00 | 4
 | 2021-11-27 00:00:00 | 2
 | 2021-11-28 00:00:00 | 2
 | 2021-11-29 00:00:00 | 2
 | 2021-11-30 00:00:00 | 2
Spreadsheet: rick_buy__32661__1204_Violation
Sheet: Sheet1

 |  |  | To: |  | [NAME], [NAME] |  |  |  |  | Risk Policy Notification Requirements
 |  |  | Copy to: |  | Distribution |  |  |  |  |  |  |  | Skilling |  | Lay |  |  | Finance Committe Chairman
 |  |  |  |  |  |  |  |  |  | Daily Loss |  |  | 50% of VaR |  | 75% of VaR |  |  | Aggregate Loss > 100% Aggregate VaR Limit
 |  |  | From: |  | Global Risk Management Operations |  |  |  |  | Cumulative 5-day Loss |  |  | 75% of VaR |  | 100% of VaR
 |  |  |  |  |  |  |  |  |  | NOP, M/G, VaR |  |  | 105% of VaR |  | 110% of VaR |  |  | Aggregate VaR > 100% Aggregate VaR Limit
 |  |  | Date: |  | 2000-12-04 00:00:00
 |  |  | Re: |  | Limit Violations
 |  |  |  |  |  |  | Loss Notification or Limit Violation |  |  |  |  |  | P/L RESULTS
 |  |  |  |  |  |  |  |  |  | Violation/
 | Occurrence |  |  |  |  |  | VaR | NOP or M/G | Type | Notification | Number |  | QTD |  | YTD
 | Date |  | Business Unit |  | Commodity Group |  | Limit | Limit | Violation | Amount | YTD |  | P/L |  | P/L |  |  | Explanation
 |  |  |  |  |  |  | ($MMs) |  |  | ($MMs) |  |  | ($MMs) |  | ($MMs)
BOARD OF DIRECTORS VIOLATIONS
1 | 2000-12-04 00:00:00 |  | Enron |  | Total Trading |  | 85 | n/a | VaR | 104 | 1 |  | 822 |  | 2910 |  |  | The Enron aggregate VaR of $104 Million mainly consists of $72 Million in Enron North America Gas trading VaR and $33.2 Million in Enron North America Power trading VaR
Lay Level Violations
1 | 2000-12-04 00:00:00 |  | Enron North America |  | Gas Trading |  | 60 | n/a | VaR | 73 | 19 |  | 397 |  | 1108 |  |  | Natural gas price spikes, increased volatility in the NYMEX and physical markets, and strong covering of short positions to mitigate potential losses in the gas book
RAC COMMENTS:
 | Distribution: |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 01712fd9-2ef6-49b8-91e5-be4ca5ecbe1d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Bench | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
[NAME] | 55 | 60 | 60 | 60 | 65 | 70 | 75 | 75
Keiran Bench | 55 | 55 | 55 | 60 | 60 | 65 | 65 | 70
 |  |  |  |  |  |  |  |  |  |  | 65 | 95.58823529411765
Squat | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 68
[NAME] | 50 | 50 | 60 | 60 | 60 | 60 | 60
[NAME] | 60 | 65 | 70 | 75 | 75 | 75 | 75
Deadlift | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
[NAME] | 60 | 70 | 85 | 85 | 85 | 85 | 85
[NAME] | 70 | 75 | 85 | 85 | 90 | 90 | 100
OH Press | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
[NAME] | 16 | 18 | 20 | 20 | 20 | 22 | 22 | 24
Keiran OH | 14 | 16 | 16 | 18 | 18 | 20 | 20 | 20
Pull Ups | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 85
[NAME] | 55 | 60 | 60 | 65 | 70 | 85 | 70 | 85 |  |  | 68
Keiran Pull | 53 | 58 | 68 | 68 | 74 | 76 | 74 | 78
[NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
[NAME] | 85 | 85 | 85 | 85 | 85 | 99 | 99 | 101
[NAME] | 78 | 78 | 78 | 80 | 80 | 82 | 82 | 84
Spreadsheet: 889475d1740286453-using-vlookup-to-match-a-partial-code-across-a-row-all-year-levels-test
Sheet: School List

Student | ID | Class 1 | Class 2 | Class 3 | Class 4 | Class 5 | Class 6 | Class 7 | Class 8 | Class 9 | Class 10
Al, [NAME] | 123 | ANR071B | ATS071B | ENG071B | HPE071B | HSS071B | JPS071B | MAT071B | SCI071B | TCY071B
Be, [NAME] | 1234 | ANR071C | ATS071C | CVE071V | ENG071C | [NAME] | HSS071C | JPS071C | MAT071C | SCI071C | TCY071C
Ce, Cyrus | 12345 | ANR071E | ATS071E | ENG071E | HPE071E | HSS071E | JPS071E | MAT071E | SCI071E | TCY071E
Spreadsheet: 525211d1498599596-match-and-index-test
Sheet: Sheet 1

AR1 |  | 1
AR2 |  | 2
[NAME] |  | #N/A
AR4 |  | 4
AR5 |  | 5
AR6 |  | 6
AR7 |  | 7
AR8 |  | 8
AR9 |  | 9
AR10-DBGA5 |  | #N/A
AR11 |  | 11
AR12 |  | 12
AR13 |  | 13
AR14 |  | 14
AR15 |  | 15
AR16 |  | 16
AR17 |  | 17
AR18 |  | 18
AR19 |  | 19
AR20 |  | 20
AR21 |  | 21
AR22
AR23
AR24
AR25
AR26
AR27
AR28
AR29
[NAME]
AR31
AR32
AR33
AR34
AR35
AR36
AR37
AR38
AR39
AR40
AR41
AR42
AR43
AR44
AR45
AR46
AR47
AR48
AR49
Spreadsheet: shelley_corman__38710__INGAA Data Template
Sheet: TW Capacity

Location | Location | Location | Capacity | Unsubscribed Capacity | Heat Content
POI | DRN | Name | (MDth/d) | (MDth/d) | (Dth/Mcf)
10487 | 208 | Socal Needles | 750 | 0 | 1.006
56696 | 68288 | Mojave Topock | 300 | 280 | 1.006
56697 | 68283 | Socal Topock | 200 | 200 | 1.006
56698 | 39815 | PG&E Topock | 300 | 11 | 1.006
 | - | Gallup Compressor Station | 850 | 0 | 1.007
Spreadsheet: 047dcd46-64fc-49d6-8e31-1a3b8061f879
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
SLC1O | Test | SLC1O | Solute Carrier Organic Anion Transporter Family Member 1B1 (SLCO1B1) [NAME], [NAME], [NAME] | SLCO1B1 [NAME], [NAME], [NAME] | Polymerase Chain Reaction (PCR) 5'-Nuclease End-Point Allelic Discrimination Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | [NAME] DNA Self-Collection Kit (Supply T651) |  |  | 4 | mL | Multiple genotype tests can be performed on a single specimen after a single extraction. See Multiple Saliva Genotype Tests in Special Instructions for a list of tests that can be ordered together.   Container/Tube: [NAME] DNA Self-Collection Kit (Supply T651)  [NAME]: Full tube  Collection Instructions:  1. Fill to tube line. 2. Send specimen in original container per kit instructions. Forms: 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. | 1 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday | 1 day | 8 days | 1 | 81400 |  |  |  |  | Rochester
SLC1O | [NAME] | SALIVA | Saliva |  |  |  | Ambient
SLC1O | Result | 34698 | SLCO1B1 [NAME] | SLCO1B1 [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
SLC1O | Result | 34699 | SLCO1B1 Interpretation | SLCO1B1 Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
SLC1O | Result | 34700 | Reviewed by | Reviewed by | Numeric
Spreadsheet: 77565d1278007170-countif-productsmonth
Sheet: Sheet1

DATE | PRODUCT |  | MONTH | PRODUCT | COUNT
2010-01-01 00:00:00 | A |  | 1 | A | 3
2010-01-02 00:00:00 | B |  | 2 | A | 0
2010-01-02 00:00:00 | A |  | 3 | A | 2
2010-01-02 00:00:00 | A |  | 4 | A | 0
2010-01-02 00:00:00 | B |  | 5 | A | 0
2010-01-03 00:00:00 | B |  | 6 | A | 0
2010-03-07 00:00:00 | A |  | 7 | A | 0
2010-03-08 00:00:00 | A |  | 8 | A | 0
 |  |  | 9 | A | 0
 |  |  | 10 | A | 0
 |  |  | 11 | A | 0
 |  |  | 12 | A | 0
 |  |  | 1 | B | 3
 |  |  | 2 | B | 0
 |  |  | 3 | B | 0
 |  |  | 4 | B | 0
 |  |  | 5 | B | 0
 |  |  | 6 | B | 0
 |  |  | 7 | B | 0
 |  |  | 8 | B | 0
 |  |  | 9 | B | 0
 |  |  | 10 | B | 0
 |  |  | 11 | B | 0
 |  |  | 12 | B | 0
Spreadsheet: eric_saibi__9934__103001R
Sheet: Beckjord 06

Owner Name |  | Cinergy Corp.
Station Name |  | [NAME] Power Station
Unit Name |  | W C Beckjord 06
NERC Region |  | ECAR
State |  | OH
Fuel Type |  | Coal
Capacity |  | 434 MW
Start Date |  | 2001-09-30 00:00:00
End Date |  | 2001-11-23 00:00:00
Prv. Start Date |  | 2001-10-14 00:00:00
Prv. End Date |  | 2001-11-10 00:00:00
Comments |  | Turb,boiler
SIC |  | 4911
Plant ID |  | 1013762
Unit ID |  | 1003875
Outage ID |  | 16875
Spreadsheet: 751600d1634205427-look-up-and-return-book-1
Sheet: 2

Pallet |  |  |  |  | 2
 | PART NUMBER | [NAME] | QUANITY | DATE SENT | REG OF TRANSPORT
2 | 72100131 | TRI KIT WARNING BAG | 20009
2 | 72100212 | TRI WARNING BAG | 2417
2 | 72100216 | TRI ADHESIVE STRIP | 14400
2 | 72100106 | TRI CLR DUAL LENS | 1600
2 | 72100224 | TRI IDKER GEAR AMALA | 1872
2 | 72100112 | AAR WHT LOCATION BODY | 6632
Spreadsheet: sara_shackleton__37364__Credit Terms
Sheet: Sheet1

MASTER AGREEMENT AMENDMENT INFORMATION SHEET
 |  | ATTORNEY: | [NAME]
DATE: | 2000-11-22 00:00:00 | DEAL MAKER: | Morten-Erik Pettersen
COUNTERPARTY: | Nippon Chemi-con | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State |  | S&P Rating | n/a
STRUCTURE | COUNTERPARTY | Enron Japan
GUARANTOR (RATING) |  | Enron Corp.
LIMIT $ MILLIONS | n/a | 1.5Bn yen
Incorporation State
COLLATERAL  THRESHOLD
 | [NAME] | [NAME]
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | x | x
Cash | x | x
MINIMUM TRANSFER $ | 0 | 0
COLLATERAL ROUNDING
Delivery Amount | 25MM Yen | 25MM Yen
Return Amount
HOLDING and USE OF COLLATERAL
Permitted | x | x
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty | X
Guarantor
Debt Ratings Change |  | Enron Corp.
-Below = S&P/Moody's |  | BBB-
Financial Covenants
-Funded debt/Worth | Greater than 1:1
-Minimum Net Worth | 55Bn yen
Current Assets/Curret Liabs. | Less than .7:1
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt
-Counterparty ($[NAME]) | [NAME] | 10Bn Yen
-Guarantor ($[NAME])
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: x | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: x | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: x | NO:
OTHER COMMENTS:
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x3-0906
Spreadsheet: 700901d1603392641-researching-formula-value-copy
Sheet: x

 | 3rd |  | B2
 |  |  | -0.2 | -0.15 | -0.1 | -0.05 | 0 | 0.05 | 0.1 | 0.15 | 0.2
 | C2 | -0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100
 |  | -0.15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 100
 |  | -0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 100 | 500
 |  | -0.05 | 0 | 0 | 0 | 100 | 100 | 100 | 500 | 1000 | 1000
 |  | 0 | 0 | 0 | 100 | 100 | 100 | 500 | 1000 | 1000 | 5000
 |  | 0.05 | 0 | 100 | 100 | 100 | 500 | 1000 | 1000 | 5000 | 5000
 |  | 0.1 | 100 | 100 | 100 | 500 | 1000 | 1000 | 5000 | 5000 | 5000
 |  | 0.15 | 100 | 100 | 500 | 1000 | 1000 | 5000 | 5000 | 5000 | 5000
 |  | 0.2 | 100 | 500 | 1000 | 1000 | 5000 | 5000 | 5000 | 5000 | 5000
 | 2nd |  | B2
 |  |  | -0.2 | -0.15 | -0.1 | -0.05 | 0 | 0.05 | 0.1 | 0.15 | 0.2
 | C2 | -0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | -0.15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 250 | 250
 |  | -0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 250 | 250 | 1250
 |  | -0.05 | 0 | 0 | 0 | 250 | 250 | 250 | 1250 | 2500 | 2500
 |  | 0 | 0 | 0 | 250 | 250 | 250 | 1250 | 2500 | 2500 | 12500
 |  | 0.05 | 0 | 250 | 250 | 250 | 1250 | 2500 | 2500 | 12500 | 12500
 |  | 0.1 | 250 | 250 | 250 | 1250 | 2500 | 2500 | 12500 | 12500 | 12500
 |  | 0.15 | 250 | 250 | 1250 | 2500 | 2500 | 12500 | 12500 | 12500 | 12500
 |  | 0.2 | 250 | 1250 | 2500 | 2500 | 12500 | 12500 | 12500 | 12500 | 12500
 | 1st |  | B2
 |  |  | -0.2 | -0.15 | -0.1 | -0.05 | 0 | 0.05 | 0.1 | 0.15 | 0.2
 | C2 | -0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 600
 |  | -0.15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 600 | 600
 |  | -0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 600 | 600 | 3000
 |  | -0.05 | 0 | 0 | 0 | 600 | 600 | 600 | 3000 | 6000 | 6000
 |  | 0 | 0 | 0 | 600 | 600 | 600 | 3000 | 6000 | 6000 | 30000
 |  | 0.05 | 0 | 600 | 600 | 600 | 3000 | 6000 | 6000 | 30000 | 30000
 |  | 0.1 | 600 | 600 | 600 | 3000 | 6000 | 6000 | 30000 | 30000 | 30000
 |  | 0.15 | 600 | 600 | 3000 | 6000 | 6000 | 30000 | 30000 | 30000 | 30000
 |  | 0.2 | 600 | 3000 | 6000 | 6000 | 30000 | 30000 | 30000 | 30000 | 30000
Spreadsheet: 856414d1705663616-transpose-with-conditions-example-1-6-aligw
Sheet: Sheet1

ID | Prio | Code | String |  |  | ID | Code4 | Code1 | Code1 | Code1 | Code1 | Code2 | Code3 | Code3 | Code5 | Code5 | Code5
1000 | 2 | Code1 | String0 |  |  | 1000 | String3 | String0 | String1 | String2
1000 | 3 | Code2 | String1 |  |  | 1001 |  | String4 | String5 |  |  | String6
1000 | 4 | Code3 | String2 |  |  | 1002 |  | String7 | String8 | String9 | String10
1000 | 1 | Code4 | String3 |  |  | 1003 |  | String11 |  |  |  |  | String12 | String13
1001 | 2 | Code1 | String4 |  |  | 1004 | String15 | String14 |  |  |  |  |  |  | String16 | String17 | String18
1001 | 2 | Code1 | String5
1001 | 3 | Code2 | String6
1002 | 2 | Code1 | String7 |  |  | Result |  |  |  |  | AliGW
1002 | 2 | Code1 | String8 |  |  |  |  |  |  |  |  | String0|String1|String2|String3
1002 | 2 | Code1 | String9 |  |  |  |  |  |  |  | 1001 | String4|String5|String6
1002 | 2 | Code1 | String10 |  |  |  |  |  |  |  | 1002 | String7|String8|String9|String10
1003 | 2 | Code1 | String11 |  |  |  |  |  |  |  | 1003 | String11|String12|String13
1003 | 4 | Code3 | String12 |  |  |  |  |  |  |  | 1004 | String14|String15|String16|String17|String18
1003 | 4 | Code3 | String13
1004 | 2 | Code1 | String14
1004 | 1 | Code4 | String15 |  |  | String4|String5|String6
1004 | 5 | Code5 | String16 |  |  | String7|String8|String9|String10
1004 | 5 | Code5 | String17 |  |  | String11|String12|String13
1004 | 5 | Code5 | String18 |  |  | String15|String14|String16|String17|String18
Spreadsheet: 109192d1306132305-excel-2007-formulas-in-pivot-table-example
Sheet: Sheet1

Country | Month | Year | Tipe | Cost | Place | Amount |  | Sum of Amount | Column Labels |  |  |  |  |  |  |  | RESULT!!!
a | Jan | 2011 | bud | [NAME] | Logistika | 20 |  |  | Jan |  | Feb |  | Mar |  | Apr |  | Jan | Feb | Mar | Apr
a | Feb | 2011 | bud | [NAME] | Logistika | 5 |  | Row Labels | bud | act | bud | act | bud | act | act |  | diff. | diff. | diff. | diff.
a | Mar | 2011 | bud | [NAME] | Logistika | 24 |  | a | 20 | 15 | 5 | 20 | 24 | 20 | 56
a | Apr | 2011 | act | Vanredni | Logistika | 56 |  | [NAME] | 20 |  |  |  | 24
a | Mar | 2011 | act | [NAME] rashodi | Centrala | 20 |  | [NAME] |  |  | 5
a | Jan | 2011 | act | [NAME] rashodi | Centrala | 15 |  | [NAME] rashodi |  | 15 |  | 20 |  | 20
a | Feb | 2011 | act | [NAME] rashodi | Centrala | 20 |  | Vanredni |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  | Grand Total | 20 | 15 | 5 | 20 | 24 | 20 | 56
Spreadsheet: 869262d1715870789-meet-two-different-crieria-to-find-value-temp
Sheet: Sheet1

Reference | 2024-04-01 00:00:00 | 2024-04-02 00:00:00 | 2024-04-03 00:00:00 | 2024-04-04 00:00:00 | 2024-04-05 00:00:00 | 2024-04-07 00:00:00 | 2024-04-08 00:00:00 | 2024-04-09 00:00:00 | 2024-04-10 00:00:00 | 2024-04-11 00:00:00 | 2024-04-12 00:00:00 | 2024-04-15 00:00:00 | 2024-04-16 00:00:00 | 2024-04-17 00:00:00 | 2024-04-18 00:00:00 | 2024-04-19 00:00:00 | 2024-04-21 00:00:00 | 2024-04-22 00:00:00 | 2024-04-23 00:00:00 | 2024-04-24 00:00:00 | 2024-04-25 00:00:00 | 2024-04-26 00:00:00 | 2024-04-28 00:00:00 | 2024-04-29 00:00:00 | 2024-04-30 00:00:00
Test1
Test2
Test3
Test4
Test5
Test6
[NAME]
Test8
Spreadsheet: 137097d1326956092-return-a-list-of-names-in-a-column-based-on-an-x-in-one-of-several-other-columns-return-a-list-of-names-in-a-column
Sheet: Sheet1

Name | Male | Female | Dog | Drunk | Employed
Homer | x |  |  | x | x
Marge |  | x
[NAME] | x
[NAME] |  | x
[NAME] |  | x
SantasLittleHelper | x |  | x
Barney | x |  |  | x | x
Moe | x |  |  |  | x
Spreadsheet: 148610d1333481318-automating-multiple-sheets-data-display-racetest123
Sheet: Sheet1

Contestant # | [NAME] | Car Model | Time | TieBreakBy# | [NAME] | car model | time
1 | [NAME] | Eclipse | 15.345 |  |  |  |  | <----- | this line would look like this automatically
2 | [NAME] | M3 | 16.348
3 | [NAME] | Escalade | 15.059
4 | [NAME] | Speed3 | 14.908
5 | [NAME] | [NAME] | 16.348
6 | [NAME] | excel | 14.685
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: C20

Local 12
Nom: | [NAME]
Numéro de téléphone: | [PHONE]
[NAME]: | 40
Paiement dû le: | 2013-03-23 00:00:00
[NAME]: | 26
Réservé:
Prix: | 75
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 272542d1382428274-how-to-join-two-worksheets-into-one-based-on-the-data-they-contain-workbook1
Sheet: corrective actions

# defect | corrective action | responsible person | date of completion
23456 | aaa | A | 12.12.12
23456 | bbb | V | 13.1.11
23457 | [NAME] | W | 4.9.13
23458 | aac | A | 23.5.12
23459 | asdf | N | 5.7.12
23460 | asde | P | 6.1.12
23460 | jyjt | E | 3.6.13
23460 | asd | B | 23.9.11
23461 | nydz | N | 1.1.13
23462 | afeef | P | 9.9.12
23463 | kuud | A | 5.7.12
23464 | sgfsgr | W | 7.3.13
23465 | [NAME] | R | 13.1.11
23466 | xcvcx | Z | 6.3.12
23467 | ewgt | L | 25.2.12
23468 | kggjy | P | 3.6.13
Spreadsheet: 855438d1704992313-timesheet-database-sample-timesheet
Sheet: 15-Jan-24

 | Staff Name | Project | Project Number | Project Name | Mon | Tue | Wed | Thu | Fri
 | Employee 1 | 23001 - Project 1 |  |  |  |  |  |  | 7.5
 | Employee 1 | 23002 - Project 2
 | Employee 1 | 23003 - Project 3
 | Employee 1 | 23004 - Project 4 |  |  |  |  |  | 7.5
 | Employee 1 | 23005 - Project 5 |  |  | 7.5 | 7.5 | 7.5
 | Employee 1 | 23006 - Project 6
 | Employee 1 | 23007 - Project 7
 | Employee 1 | 23008 - Project 8
 | Employee 1 | 23009 - Project 9
 | Employee 1 | 23010 - Project 10
Spreadsheet: 865875d1712844089-formula-to-calculate-against-2-columns-to-produce-a-figure-rag-calculation
Sheet: Portfolio Extract current

Categorisation | Collective | Stage | Project Name | Short Description | Project Outcomes | Benefits | Sponsor | Decision Maker | External Suppliers | Baseline Start Date | Baseline End Date | [NAME]
 |  | Closed |  |  |  |  |  |  |  |  |  | Green
 |  | Discovery |  |  |  |  |  |  |  |  |  | Green
 |  | Approved Pipeline
 |  | Paused |  |  |  |  |  |  |  |  |  | Green
 |  | Service Improvement |  |  |  |  |  |  |  |  |  | Green
 |  | Closed - completed |  |  |  |  |  |  |  |  |  | Green
 |  | Closed |  |  |  |  |  |  |  |  |  | Green
 |  | Paused |  |  |  |  |  |  |  |  |  | Amber
 |  | Closed - early |  |  |  |  |  |  |  |  |  | Amber
 |  | Delivery |  |  |  |  |  |  |  |  |  | Green
 |  | Closed |  |  |  |  |  |  |  |  |  | Green
 |  | Approved Pipeline
 |  | Approved Pipeline
 |  | Stopped - rescoping |  |  |  |  |  |  |  |  |  | Red
 |  | Approved Pipeline
 |  | Closed - completed |  |  |  |  |  |  |  |  |  | Green
 |  | Closed - completed |  |  |  |  |  |  |  |  |  | Green
 |  | Closed - benefits realisation |  |  |  |  |  |  |  |  |  | Green
 |  | Delivery |  |  |  |  |  |  |  |  |  | Green
 |  | Closed - completed |  |  |  |  |  |  |  |  |  | Green
 |  | Discovery |  |  |  |  |  |  |  |  |  | Green
 |  | Approved Pipeline
 |  | Discovery |  |  |  |  |  |  |  |  |  | Amber
 |  | Closed - completed |  |  |  |  |  |  |  |  |  | Green
 |  | Delivery |  |  |  |  |  |  |  |  |  | Green
 |  | Closed |  |  |  |  |  |  |  |  |  | Green
 |  | Closed |  |  |  |  |  |  |  |  |  | Green
 |  | Closed - benefits realisation |  |  |  |  |  |  |  |  |  | Green
 |  | Delivery |  |  |  |  |  |  |  |  |  | Amber
 |  | Delivery |  |  |  |  |  |  |  |  |  | Amber
 |  | Closed |  |  |  |  |  |  |  |  |  | Green
 |  | Initial Assessment |  |  |  |  |  |  |  |  |  | Green
 |  | Discovery |  |  |  |  |  |  |  |  |  | Green
 |  | Closed - completed |  |  |  |  |  |  |  |  |  | Green
 |  | Discovery |  |  |  |  |  |  |  |  |  | Red
 |  | Delivery |  |  |  |  |  |  |  |  |  | Red
 |  | Discovery |  |  |  |  |  |  |  |  |  | Amber
 |  | Closed - completed |  |  |  |  |  |  |  |  |  | Green
 |  | Discovery |  |  |  |  |  |  |  |  |  | Green
 |  | Paused |  |  |  |  |  |  |  |  |  | Red
 |  | Delivery |  |  |  |  |  |  |  |  |  | Red
 |  | Initial Assessment |  |  |  |  |  |  |  |  |  | Green
 |  | Initial Assessment |  |  |  |  |  |  |  |  |  | Green
 |  | Closed |  |  |  |  |  |  |  |  |  | Green
 |  | Initial Assessment |  |  |  |  |  |  |  |  |  | Green
 |  | Service Improvement |  |  |  |  |  |  |  |  |  | Green
 |  | Discovery |  |  |  |  |  |  |  |  |  | Green
 |  | Approved Pipeline
 |  | Stopped - rescoping |  |  |  |  |  |  |  |  |  | Green
 |  | Initial Assessment |  |  |  |  |  |  |  |  |  | Green
 |  | Discovery |  |  |  |  |  |  |  |  |  | Green
 |  | Delivery |  |  |  |  |  |  |  |  |  | Red
 |  | Closed |  |  |  |  |  |  |  |  |  | Green
 |  | Discovery |  |  |  |  |  |  |  |  |  | Green
 |  | Closed |  |  |  |  |  |  |  |  |  | Green