tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 462327d1464009252-selecting-data-according-to-text-and-placing-in-graph-capital-expense-2016-2017
Sheet: Leeds

[NAME] 2016-2017
Improment/Equipment | In-house/ Subcontract | time scale | Expense | possible Savings
Workshop and parts Heating | Sub contract | Q3 | 15430
Led light program | internal |  | 24616 | 8208 |  | Leeds
Revamp canteen units/appliances | 1nhouse |  | 2900 |  |  | expense | Potential Saving
gate fencing | inhouse |  | 2500
parts mezzanine floor | Sub contract |  | 40000
wheel balancer |  |  | 2800
adblue tank |  |  | 3200
[NAME] | in house |  | 3000
Totals
Spreadsheet: 480885d1474127132-need-something-like-a-vlookup-but-matches-two-different-cells-and-averages-the-numbers-doublematchexample
Sheet: Sheet1

Name | Number | Color | Shape
TestA | 1 | Blue | Square
TestB | 2 | Red | Triangle
TestC | 3 | Yellow | Circle
TestD | 4 | Red | Triangle
TestE | 2 | Yellow | Circle
TestF | 4 | Blue | Square
TestG | 5 | Blue | Triangle
TestH | 3 | Red | Circle
TestI | 1 | Red | Triangle
TestJ | 1 | Yellow | Square
TestK | 2 | Red | Triangle
TestL | 3 | Blue | Square
TestM | 3 | Yellow | Circle
TestN | 4 | Red | Triangle
TestO | 3 | Blue | Square
TestP | 2 | Red | Circle
TestQ | 3 | Yellow | Triangle
TestR | 5 | Blue | Square
TestT | 3 | Red | Triangle
TestU | 1 | Red | Circle
TestV | 2 | Yellow | Triangle
TestW | 3 | Yellow | Triangle
TestX | 2 | Red | Circle
TestY | 2 | Blue | Square
TestZ | 3 | Red | Square
Spreadsheet: darron_c_giron__7977__midland_cogen
Sheet: Feb00

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
2000-02-01 00:00:00
IFGMR (TRKL/TX) |  |  | 2.52 |  |  | No. of Days: | 29
IFGMR (TRKL/LA) |  |  | 2.56
IFGMR (PEPL/TX/OK) |  |  | 2.5
IFGMR (ANR/LA) |  |  | 2.56
IFGMR (HENRY HUB) |  |  | 2.61
NX3 |  |  | 2.583
Sitara 10227
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001
 | 1993 | 2.4 | 2002
 | 1994 | 2.51 | 2003
 | 1995 | 2.61 | 2004
 | 1996 | 2.53 | 2005
 | 1997 | 2.65 | 2006
 | 1998 |  | 2007 | 6.37
 | 1999
 | 2000
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
Sitara 10226
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* (TX) |  | 2.5 |  | BASIS DIFFERENTIAL
TRIGGER* (LA) |  | 2.5 |  | IFGMR (HENRY HUB)
DIFFERENTIAL (TX) |  |  |  | LESS AVG IFGMR (TRKL/LA)
DIFFERENTIAL (LA) |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D | BASIS DIFFERENTIAL
 |  |  |  | IFGMR (HENRY HUB)
*Customer prefers rounding to nearest penny. |  |  |  | LESS AVG IFGMR(TRKL/TX)
 |  |  |  | BASIS DIFFERENTIAL
Spreadsheet: 143607d1330481664-data-color-change-when-same-data-entered-in-same-column-3x-6x-9x-slot-formating
Sheet: Sheet1

Date | Location
2011-12-22 00:00:00 | D2104
2011-12-23 00:00:00 | D2104
2012-01-04 00:00:00 | G1503
2012-01-08 00:00:00 | D2104
2012-01-13 00:00:00 | A0708
2012-01-13 00:00:00 | A0708
2012-01-17 00:00:00 | D2104
2012-01-20 00:00:00 | D2104
2012-01-20 00:00:00 | A0708
2012-01-24 00:00:00 | D2104
2012-01-27 00:00:00 | D2104
2012-01-27 00:00:00 | D2104
2012-01-28 00:00:00 | D2104
2012-01-30 00:00:00 | A0708
2012-01-31 00:00:00 | A0708
2012-01-31 00:00:00 | G1503
2012-02-04 00:00:00 | D2104
2012-02-06 00:00:00 | A0708
2012-02-10 00:00:00 | D2104
2012-02-16 00:00:00 | G1503
2012-02-18 00:00:00 | A0708
2012-02-19 00:00:00 | G1503
2012-02-19 00:00:00 | A0708
2012-02-20 00:00:00 | D2104
Spreadsheet: a48760dc-ae8e-4fca-9b02-56eab5916a2a
Sheet: Sheet1

Unnamed: 0 | [NAME] | 1.1 | Datum | 2004-11-26 00:00:00
 | Nahlášení zásilky …………….
ID_CU | Identifikační číslo zásilky (CÚ)
INSP | Inspektorát SZPI
DAT | Datum sdělení dovozcem
CAS | Čas sdělení dovozcem
[NAME] | Kód celního úřadu
[NAME] | Název a adresa celního úřadu, vč. [NAME] pracoviště
KONT | Kontaktní osoba
TEL | Telefonní číslo
MAIL | E-mail
VYSKYT | Identifikace místa výskytu výrobku, adresa (místo vykládky)
OBCH_NAZ | Obchodní název potraviny nebo suroviny
POPIS | [NAME] popis (charakteristika potraviny nebo suroviny)
KN | KN (osmimístný číselný kód)
KOD_ZAS | Kód zásilky (shodný s kódem na osvědčení)
SARZE | Číslo šarže
SPZ | RZ dopravního prostředku, označení kontejneru
FAKTURA | Evidenční čísla faktur, příp. jiných průvodních dokladů
MNOZ | Množství - hodnota
JEDNOTKA | Množství - jednotka
BALENI | Způsob balení
DOV_NAZEV | Identifikace dovozce (název)
DOV_DIC | IČ dovozce
DOV_ADR | Adresa dovozce
[NAME] | Identifikace příjemce
PRIJ_DIC | IČ příjemce
PRIJ_ADR | Adresa příjemce
ODES_NAZEV | Identifikace [NAME] subjektu, který výrobek odesílá
[NAME] | Země původu
OT1 | Zásilka potravin nebo surovin vykazuje určité znaky, které vyvolávají podezření [NAME] a bezprostředního ohrožení zdraví a bezpečnosti při použití tohoto výrobku za běžných a předvidatelných podmínek. |  | ne
OT2 | Zásilka potravin [NAME] doprovázena příslušnými doklady a osvědčením. |  | ano
OT3 | Zásilka odpovídá předloženým dokladům nebo osvědčením. |  | neurčeno
OT4 | Zásilka potravin [NAME] původu. |  | ne
OT5 | Zásilka potravin [NAME] RASFF. |  | ne
OT6 | [NAME] o zásilku potravin nebo surovin podléhajících dle předpisů ES zvláštnímu režimu úřední kontroly. |  | ano
 | Doplňující textové informace
DOPLN
 |  | Možné odpovědi:
 |  |  | neurčeno
 |  |  | ano
 |  |  | ne
Spreadsheet: 864105d1711425560-concise-formulas-to-make-excel-file-smaller-sample-results
Sheet: Working File

After Sales | Strongly Disagree | Disagree | Neutral | Agree | Strongly Agree |  |  | Legend
Easy |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
Prompt
Expertise
Clear
After Sales | Strongly Disagree | Disagree | Neutral | Agree | Strongly Agree
Easy
Prompt
Expertise
Clear
Sales | Strongly Disagree | Disagree | Neutral | Agree | Strongly Agree
Suitable
Responsiveness
Expectations
Satisfied
Sales | Strongly Disagree | Disagree | Neutral | Agree | Strongly Agree
Suitable
Responsiveness
Expectations
Satisfied
Spreadsheet: 42563d1241103502-employee-schedule-help-schedule09d-bargraph
Sheet: Sunday

 |  | Area |  |  | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | Total Hours
 |  | Service Desk | IN | OUT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
1 | 62 | [NAME] | 07:00:00 | 13:00:00 | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  | 6
2 | 74 | Hayley | 18:00:00 | 22:00:00 |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X |  |  | 4
3 | 9 | [NAME] | 09:00:00 | 16:00:00 |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  | 7
4 | 26 | [NAME] | 13:00:00 | 18:00:00 |  |  |  |  |  |  | X | X | X | X | X |  |  |  |  |  |  | 5
5 | 43 | Ramsay | 11:00:00 | 18:00:00 |  |  |  |  | X | X | X | X | X | X | X |  |  |  |  |  |  | 7
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
20
21
22
Spreadsheet: 140886d1328923648-large-database-yfeb-food-total-values
Sheet: Shopping List

Shopping List | Cost | Location | Date Purchased |  | Total Spent
2 Bananas @.165 | 0.33 | Costco | 2012-01-30 00:00:00
Honey Nut Cheerios | 6.59 | Costco | 2012-01-30 00:00:00
[NAME] | 7.73 | Costco | 2012-01-30 00:00:00
Organic Milk | 3 | Costco | 2012-01-30 00:00:00
1 Jar Peaches | 2.25 | Costco | 2012-01-30 00:00:00
1/2 [NAME] | 3.67 | Costco | 2012-01-30 00:00:00
1/2 Bag Carrots | 3.5 | Costco | 2012-01-30 00:00:00
1/2 English Muffin | 2.5 | Costco | 2012-01-30 00:00:00
1 Cucumber | 3.99 | Costco | 2012-01-30 00:00:00
8 Eggs | 2.33 | Costco | 2012-01-30 00:00:00
1/3 [NAME] | 6.8 | Costco | 2012-01-30 00:00:00 | 740 grams total |  | $0.411 for 50 grams
1 Chicken thigh | 4.75 | Costco | 2012-01-30 00:00:00
1/3 Celllery Root | 1.4 | WF | 2012-02-01 00:00:00
1/3 [NAME] | 0.66 | TJ | 2012-02-01 00:00:00
1/3 Thai Red Curry Cooking | 1.79 | TJ | 2012-02-01 00:00:00
Sliced Turkey Roasted | 2.99 | TJ | 2012-02-01 00:00:00 | $0.015 for 1 gram
1 Zucchini | 1.71 | GW | 2012-02-01 00:00:00
Chinese Noodle | 1.69 | GW | 2012-02-01 00:00:00
[NAME] | 3.53 | GW | 2012-02-01 00:00:00
Sesame Sauce | 3.99 | GW | 2012-02-01 00:00:00
[NAME] | 2.49 | GW | 2012-02-01 00:00:00
Pinto Beans | 1.09 | Target | 2012-02-03 00:00:00
[NAME] | 0.67 | Target | 2012-02-03 00:00:00
Pretzels | 1.33 | Target | 2012-02-03 00:00:00 | Full Bag= $3.99
Vermont Organic Multi-Grain Bread | 4.39 | WF | 2012-02-07 00:00:00
Tomatoes on the Vine | 2.9 | WF | 2012-02-07 00:00:00
Bagels | 6 | Sonja | 2012-02-08 00:00:00 | 12
1Lache-Crème Suppe |  | German | 2012-02-10 00:00:00
2 Champignon-Crmeme Suppe |  | German | 2012-02-10 00:00:00
2 Spargel-Crème Suppe |  | German | 2012-02-10 00:00:00
Milchreis |  | German | 2012-02-10 00:00:00
2 Sun Flower Bread |  | German | 2012-02-10 00:00:00
[NAME] |  | German | 2012-02-10 00:00:00
Haribo Pfirsiche |  | German | 2012-02-10 00:00:00
[NAME] |  | German | 2012-02-10 00:00:00
RotKohl |  | German | 2012-02-10 00:00:00
[NAME] |  | German | 2012-02-10 00:00:00
1/3 SourKrout |  | German | 2012-02-10 00:00:00
1/3 Vinigar |  | German | 2012-02-10 00:00:00
1/3 Badedas |  | German | 2012-02-10 00:00:00
2 Meica Deutschalender Sausages |  | German | 2012-02-10 00:00:00
1/3 [NAME] |  | German | 2012-02-10 00:00:00
1/3 [NAME] dressing |  | German | 2012-02-10 00:00:00
2 Chipsfrisch |  | German | 2012-02-10 00:00:00
Milka Daim |  | German | 2012-02-10 00:00:00
Milka [NAME] | 1.33 | German | 2012-02-10 00:00:00
Milka Haselnuss |  | German | 2012-02-10 00:00:00
Dr. [NAME] Crème Schokolade |  | German | 2012-02-10 00:00:00
2 Sauce Hollondaise |  | German | 2012-02-10 00:00:00
1 Quark |  | German | 2012-02-10 00:00:00
[NAME] Potato Bag | 1.99 | TJ | 2012-02-10 00:00:00
2 Tangelos |  | TJ | 2012-02-10 00:00:00
English Cotswold Cheese | 3.99 | TJ | 2012-02-10 00:00:00
4 Bananas | 0.76 | TJ | 2012-02-10 00:00:00
[NAME] | 2.99 | TJ | 2012-02-10 00:00:00
1/3 Beef Stew Meat |  | Costco | 2012-02-10 00:00:00
3 Cucumbers | 3.99 | Costco | 2012-02-10 00:00:00
1 Milk |  | Costco | 2012-02-10 00:00:00
Spreadsheet: 751986d1634494348-needing-help-with-matching-ir-rollup-12oct21
Sheet: BII

NIIN | Nomenclature | U of I | Batch | QTY | Unit Price | Total Price | Location
016057303 | WRENCH,BOX AND OPEN END,COMBINAT | EA | A | 1 | 19.28 |  | L1D
016568889 | SOCKET,SOCKET WRENCH | EA | A | 1 | 24.02 |  | L2C
001746865 | PANEL MARKER | EA | A | 53 | 30.12 |  | W3D2
001489546 | REFLECTOR SET,HIGHWAY WARNING,TRI | EA | G | 10 | 23.09 |  | W3G11
Spreadsheet: 57107d1257275395-how-to-get-circular-reference-to-work-in-2007-exceldummyworkbook
Sheet: P=0 (2)

 |  |  |  |  |  |  |  |  | 2 | 3 | 5 | 3
 |  |  |  |  |  |  |  |  | 5 |  |  | 700
 |  |  |  |  |  |  |  |  | 2 | 1 | 2 | 20
 |  |  |  |  |  |  |  |  | 2 | 3 | 5 | 3
 |  |  |  |  |  |  |  |  | 5 |  |  | 700
 |  |  |  |  |  |  |  |  | 2 | 1 | 2 | 20
Spreadsheet: tori_kuykendall__39972__WESTJ
Sheet: West

3 | Today's Date | 2001-01-23 00:00:00 |  |  |  |  |  | West Desk's Positions
Region Code | Gas Daily Index Location | WACOG | Total Volume Traded (MMbtu /day) | Low Trade | High Trade | Low Mkt | High Mkt | Financial Gas Daily | Physical | Net (Financial+Physical) | Trade Check | Mkt. Check
 | TEXAS:  WEST WAHA
W | El Paso Day 2 | 6.875 | 600000 | 6.8 | 7 | 6.85 | 6.9
W | [NAME] ([NAME])
 | NEW MEXICO:  SAN JUAN BASIN
W | El Paso, [NAME] | 6.89 | 150000 | 6.85 | 7 | 6.85 | 7
W | El Paso, Bondad | 6.85 | 35000 | 6.8 | 6.9 | 6.8 | 6.9
W | NW Ignacio
W | TW San Juan
W | TW Central Pool
W | TW Thoreau
 | ROCKIES
W | CIG (North System) | 6.8 | 32500 | 6.7 | 6.9 | 6.75 | 6.85
W | Questar | 6.75 | 20000 | 6.65 | 6.8 | 6.7 | 6.8
W | Opal/Kern River | 6.875 | 420000 | 6.75 | 7.1 | 6.8 | 6.95
W | NW, Wyoming Pool | 6.85 | 10000 | 6.7 | 6.95 | 6.8 | 6.9
W | NW, Stanfield | 6.95 | 5000 | 6.95 | 6.95 | 6.95 | 6.95
W | South of Green River | 6.5 | 20000 | 6.45 | 6.58 | 6.5 | 6.58
w | [NAME] | 7.01 | 12500 | 6.92 | 7.07 | 6.97 | 7.05
 | CANADIAN GAS
W | NW - Sumas | 6.85 | 20000 | 6.8 | 6.95 | 6.8 | 6.9
W | PGT/Kingsgate
W | West Coast, St. 2
 | CITYGATES/Others
W | SoCal, large packages | 16.07 | 900000 | 15 | 17.4 | 15.5 | 16.6
 | SoCal, small packages
W | PGE Topok
W | Cal border Kern River St. (PGE)
W | Malin | 12.41 | 350000 | 11.55 | 13.3 | 12 | 12.95
W | PGE/Citygate | 12.52 | 350000 | 11.65 | 13.65 | 12 | 13
W | Wheeler Ridge
W | Intrastate gas
Spreadsheet: 885674d1735483075-column-of-referring-row-numbers-of-found-celvalue-question_rownumbers
Sheet: Blad1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Named ranges | Row number |  | Named ranges | Row number |  | Named ranges | Row number |  | ALS(H9=-1;-1;
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kop_rij_tbl1 |  |  | Kop_rij_tbl2 |  |  | Kop_rij_tbl3 |  |  | ALS(H9<max_rij_tbl_1;AGGREGAAT(15;3;(Blad2!$E$7:$E$32="HCAT")/(Blad2!$E$7:$E$32="HCAT")*(RIJ(Blad2!$E$7:$E$32));RIJEN($G$10:G10));
 |  |  |  |  |  |  | Formule kolom |  |  |  | Wanted result |  |  |  |  |  |  |  |  |  |  |  |  |  | ALS(H9<Totaal_rij_tbl_1;AGGREGAAT(15;3;(Blad2!$E$7:$E$32="TOTAAL")/(Blad2!$E$7:$E$32="TOTAAL")*(RIJ(Blad2!$E$7:$E$32));RIJEN($G$10:G10));
 |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | MAX_rij_tbl1 |  |  | MAX_rij_tbl2 |  |  | MAX_rij_tbl3 |  |  | ALS(H9=Totaal_rij_tbl_1;"/1";
 |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  | Totaal_rij_tbl1 |  |  | Totaal_rij_tbl2 |  |  | Totaal_rij_tbl3 |  |  | ALS(H9="/1";Kop_rij_tbl_2;
 |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALS(H9<Totaal_rij_tbl_2;AGGREGAAT(15;3;(Blad2!$E$7:$E$32="HCAT")/(Blad2!$E$7:$E$32="HCAT")*(RIJ(Blad2!$E$7:$E$32));RIJEN($G$10:G10));
 |  |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALS(H9=Totaal_rij_tbl_2;"/2";
 |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALS(H9="/2";Kop_rij_tbl_2;
 |  |  |  |  |  |  |  |  |  |  | /1 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALS(H9<Totaal_rij_tbl_2;AGGREGAAT(15;3;(Blad2!$E$7:$E$32="HCAT")/(Blad2!$E$7:$E$32="HCAT")*(RIJ(Blad2!$E$7:$E$32));RIJEN($G$10:G10));
 |  |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALS(H9=Totaal_rij_tbl_2;"/2"
 |  |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  | ))))))))))
 |  |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  | /2
 |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
Spreadsheet: 773693d1648008825-vlookup-multiple-criteria-example-v3
Sheet: All Task Orders

[NAME]
ID | Name | TO01 | TO02 | TO03
1001 | [NAME], [NAME]
2403 | Doe, [NAME]
2050 | Fisher, Mary
1920 | [NAME], [NAME]
Answer
ID | Name | TO 01 | TO 02 | TO 03
1001 | [NAME], [NAME] | 10 | 30
2403 | Doe, [NAME] | 9 | 60
2050 | Fisher, Mary | 15
1920 | [NAME], [NAME] | 0
 | SUMs hours based on employee ID and TO from the "by task order" tab.
Spreadsheet: 0d196bec-54b8-473a-93e8-168c36ce7865
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
FRISP | Test | FRISP | Risperidone (Risperdal) and 9-Hydroxyrisperidone | Risperidone and Metabolite | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 3 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s). ([NAME] is not acceptable.)  Spin down and send 3 mL sodium heparin plasma refrigerated. Note:		1. Indicate plasma on request form.    		2.  [NAME] specimen appropriately (plasma).  		3. Trough levels are most reproducible   Serum Draw blood in a plain, red-top tube(s).  (Serum gel tube is not acceptable.)  Spin down and send 3 mL of serum refrigerated. Note:		1. Indicate serum on request form. 		2. Label specimen appropriately (serum). 	3. Trough levels are most reproducible. | 0.6 mL NOTE: Submission of the m | Specimens other than	Plasma, serum Anticoagulants other than	Sodium heparin, EDTA, plain red-top Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Expected steady state concentrations of risperidone and 9-hydroxyrisperidone (combined total) in patients receiving recommended daily dosages: 10-120 ng/mL.   Test Performed By: Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN 55112 | Monday through Sunday | 3 days | 5-7 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc
FRISP | [NAME] | VARIES | Varies |  |  |  | Refrigerated
FRISP | Result | Z1183 | Risperidone (Risperdal) | Risperidone (Risperdal) | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
FRISP | Result | Z1056 | 9-Hydroxyrisperidone | 9-Hydroxyrisperidone | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
FRISP | Result | Z1057 | Combined Total | Combined Total | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 329785d1404403849-copying-largest-value-in-a-range-to-specific-cell-training-grade
Sheet: Sheet1

#[NAME] | Grade |  | #[NAME] | Grade |  | #[NAME] | Grade |  | #[NAME] | Grade |  | #[NAME] | Grade |  | #[NAME] | Grade |  | #[NAME] | Grade |  | #[NAME] | Grade |  | #[NAME] | Grade |  | #[NAME] | Grade |  | Total | Highest grade | Required grade
1 | 1 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 3 |  | 1 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | < Current Formula
1 | 1A |  | 1 | 2A |  | 1 | 2A |  | 1 | 2A |  | 1 | 3A |  | 1 | 3A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3A | 3A |  | < How it needs to work
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I have use array formula on yellow colored cell
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | So please [NAME] enter to enter formula..
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Don't use only enter..
Spreadsheet: 839636d1692122146-nesting-logic-inside-of-a-countifs-sample
Sheet: data

Date | Town
2023-05-10 00:00:00 | Smithtown
2023-06-22 00:00:00 | Pines
2023-07-10 00:00:00 | Smithtown
2023-05-05 00:00:00 | Smithtown
2023-05-15 00:00:00 | Pines
2023-06-01 00:00:00 | Pines
2023-07-17 00:00:00 | Smithtown
2023-07-20 00:00:00 | Pines
2023-05-19 00:00:00 | Smithtown
2023-06-02 00:00:00 | Willow
2023-06-27 00:00:00 | Willow
2023-07-28 00:00:00 | Seashore
2023-01-17 00:00:00 | Pines
2023-06-29 00:00:00 | Pines
2023-08-10 00:00:00 | Pines
2023-08-03 00:00:00 | Collts
2023-06-26 00:00:00 | Collts
2023-08-02 00:00:00 | Seashore
2023-05-19 00:00:00 | Smithtown
Spreadsheet: 840870d1693081218-calculate-of-months-each-year-in-a-date-range-forum-solution-
Sheet: Alternative Solution

Start | End | # of Months | # of Months Each Year
Date | Date | to Forecast | 2023
2024-04-30 00:00:00 | 2024-04-30 00:00:00
2024-04-30 00:00:00 | 2024-04-30 00:00:00
2024-04-30 00:00:00 | 2024-04-30 00:00:00
2023-07-31 00:00:00 | 2024-04-30 00:00:00
2023-07-31 00:00:00 | 2026-10-31 00:00:00
2023-07-31 00:00:00 | 2026-10-31 00:00:00
Spreadsheet: 39960d1238187902-sumproduct-help-sumproduct_sample
Sheet: Sheet2

detail | PROD | Style | size | DATE | OFFER | ORDER QTY | Bal of Projected | snapshot net inv | snapshot need by sz
detail | [NAME] | SLE | 28/30+ |  |  | 0 | 0
detail | [NAME] | SLE | 33 |  |  | 0 | 0 |  | 0
detail | [NAME] | SLE | 35/36 |  |  | 0 | 0 |  | 0
detail | [NAME] | SLE | 42 |  |  | 0 | 0 |  | 0
detail | [NAME] | SLE | 48 |  |  | 0 | 3500 |  | 3500
detail | [NAME] | 2L | 40/44+ |  |  | 0 | 0 |  | 0
detail | [NAME] | 2L | 48/50 |  |  | 0 | 0 |  | 0
detail | [NAME] | 2L | 54/56- |  |  | 0 | 0 |  | 0
detail | [NAME] | 2L | OP |  |  | 0 | 0 |  | 0
detail | [NAME] | 2LE | 2LE |  |  | 0 | 0 |  | 0
detail | [NAME] | VF29 | VF29 |  |  | 0 | 0 |  | 0
detail | [NAME] | VF | 40/44+ |  |  | 0 | 0 |  | 0
detail | [NAME] | VF | 48/50 |  |  | 0 | 50000 |  | 50000
detail | [NAME] | VF | 54/56 |  |  | 0 | 0 |  | 0
detail | [NAME] | VF | 60/64 |  |  | 0 | 0 |  | 0
detail | [NAME] | VF | 70/72- |  |  | 0 | 0 |  | 0
detail | [NAME] | Costco | Costco |  |  | 0 | 0 |  | 0
detail | [NAME] | VF | SV |  |  | 0 | 0 |  | 0
Spreadsheet: 838691d1691258090-transpose-rows-data-into-multiple-columns-data-transpose_rows_to_multicolumns
Sheet: Sheet1

Group | Value |  |  | Group
Group_01 | Val_A |  |  | Group_01 | Val_A | Val_B | Val_C
Group_01 | Val_B |  |  | Group_02 | Val_X | Val_Y | Val_Z
Group_01 | Val_C |  |  | Group_03 | Val_L | Val_M | Val_N
Group_02 | Val_X |  |  | Group_04 | Val_Z
Group_02 | Val_Y |  |  | Group_05 | Val_L | Val_X
Group_02 | Val_Z
Group_03 | Val_L
Group_03 | Val_M
Group_03 | Val_N
Group_04 | Val_Z
Group_05 | Val_L
Group_05 | Val_X