tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 96315d1295720626-formatting-change-table-either-too-many-zeros-or-not-enough-cngtbl
Sheet: Cng

 | Quantity | Denominations | Amount
 |  | Hundred Dollar Bills | 0 |  |  | 0
 | 1 | Fifty Dollar Bills | 0 | 50 | 0 | 50
 | 50 | Twenty Dollar Bills | 1 | 0 | 0 | 1000
 |  | Ten Dollar Bills | 0 |  |  | 0
 |  | Five Dollar Bills | 0 |  |  | 0
 |  | Two Dollar Bills | 0 |  |  | 0
 |  | One Dollar Bills | 0 |  |  | 0
 |  | Curency Total | 1 | 50 | 0 | 1050
 |  | Standards
 |  | Fifty Cent Pieces | 0 |  |  | 0
 |  | Twenty-five Cent Pieces | 0 |  |  | 0
 |  | Ten Cent Pieces | 0 |  |  | 0
 |  | Five Cent Pieces | 0 |  |  | 0
 |  | One Cent Pieces | 0 |  |  | 0
 |  | Coin Total | 0 |  |  | 0
 |  | Grand Total | 1 | 50 | 0 | 1050
Spreadsheet: 585865d1534033546-reconcile-sheets-with-calendar-dates-in-rows-vs-dates-in-columns-jtakwformula-fruit-example
Sheet: Folha1

Date | Name | Fruit | Quantity |  | Name | Fruit | City | 2018-01-01 00:00:00 | 2018-01-02 00:00:00 | 2018-01-03 00:00:00
2018-01-01 00:00:00 | [NAME] | orange | 6 |  | [NAME] | orange | NY | 3 | 4 | 0
2018-01-01 00:00:00 | [NAME] | lemon | 4 |  | [NAME] | lemon | LA | 0 | 0 | 4
2018-01-01 00:00:00 | Marta | orange | 6 |  | [NAME] | orange | LA | 2 | 4 | 0
2018-01-01 00:00:00 | Marta | lemon | 2 |  | [NAME] | lemon | NY | 4 | 4 | 2
2018-01-02 00:00:00 | [NAME] | orange | 8 |  | Marta | orange | NY | 3 | 2 | 0
2018-01-02 00:00:00 | [NAME] | lemon | 4 |  | Marta | apple | NY | 0 | 0 | 6
2018-01-02 00:00:00 | Marta | orange | 2 |  | Marta | Lemon | LA | 2 | 0 | 0
2018-01-03 00:00:00 | [NAME] | lemon | 4 |  | Marta | orange | LA | 3 | 0 | 3
2018-01-03 00:00:00 | [NAME] | lemon | 2
2018-01-03 00:00:00 | Marta | apple | 6
Spreadsheet: 182133d1348294812-copy-data-from-one-cell-to-another-dependant-on-the-cells-value-between-two-other-cells-copy-data
Sheet: Sheet1

 |  | 20.5 ± 1.5 | 20.5 ± 1.5 | 20.5 ± 1.5 | 20.5 ± 1.5 | 20.5 ± 1.5 | 20.5 ± 1.5 | 20.5 ± 1.5 | 20.5 ± 1.5
 | Upper | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22
 | Lower | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19
 | Value | 19 | 19 | 19
Spreadsheet: 116516d1311875639-area-graph-graphs
Sheet: Graph Trend

 | GRAPH DATA
 |  | 2009-10-31 00:00:00 | 2009-11-30 00:00:00 | 2009-12-31 00:00:00 | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 | 2010-07-31 00:00:00 | 2010-08-31 00:00:00 | 2010-09-30 00:00:00 | 2010-10-31 00:00:00 | 2010-11-30 00:00:00 | 2010-12-31 00:00:00 | 2011-01-31 00:00:00 | 2011-02-28 00:00:00 | 2011-03-31 00:00:00 | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00
 |  | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun
 | Commercial | 57684 | 57219 | 55339 | 54135.60000000001 | 51482.4 | 53435.5 | 53040 | 52656 | 52292.5 | 51916 | 51315 | 51591 | 51360 | 50859 | 50660 | 49779.8 | 49990.4 | 48999.5 | 49504.10000000001 | 49403.5
 | Senior | 8352 | 8349 | 8295 | 7884 | 7980 | 7714 | 7443 | 7277.5 | 7286.5 | 7365 | 7339 | 7238 | 7200 | 6994 | 6751 | 6073 | 6020 | 6014 | 6025 | 5882
 | CareMore | 0 | 0 | 26 | 428 | 581 | 725 | 1001 | 1066 | 1678 | 1714 | 1755 | 1800 | 1893 | 2068 | 2228 | 3070 | 3121 | 3182 | 3211 | 3235
 | BHP w/oCareMore
 | BHP w/CareMore
 |  |  |  |  |  |  |  |  |  |  | My Attempt
Spreadsheet: 0a475467-686b-4915-8c35-a3b819215621
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
 | Time Series Workbook
 | 6345.0 Labour Price Index, Australia
 | Total Hourly Rates of Pay Excluding Bonuses: All Sectors by State, Original (Financial Year Index Numbers for year ended June quarter)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  New South Wales ;  Private and Public ;  All industries ; |  |  | Original | A2704396F | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Victoria ;  Private and Public ;  All industries ; |  |  | Original | A2706258V | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Queensland ;  Private and Public ;  All industries ; |  |  | Original | A2704662K | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  South Australia ;  Private and Public ;  All industries ; |  |  | Original | A2706524X | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Western Australia ;  Private and Public ;  All industries ; |  |  | Original | A2705992V | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Tasmania ;  Private and Public ;  All industries ; |  |  | Original | A2704928J | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Northern Territory ;  Private and Public ;  All industries ; |  |  | Original | A2705726C | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Australian Capital Territory ;  Private and Public ;  All industries ; |  |  | Original | A2705460F | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Private and Public ;  All industries ; |  |  | Original | A2705194A | 1998-06-01 00:00:00 | 2010-06-01 00:00:00 | 13 | Index Numbers | INDEX | Annual | 6
© Commonwealth of Australia  2010
Spreadsheet: 175663d1345602571-dynamic-list-based-on-values-on-a-table-example-dynamic-list-result
Sheet: Sheet1

 |  |  | source of information |  |  |  | Helper column | Helper column | Result
 |  |  |  | Small | Large
 |  |  | Black | Yes | No
 |  |  | Blue | No | No
 |  |  | Purple | Yes | Yes
 |  |  | Yellow | Yes | Yes
 |  |  | Green | No | Yes
Spreadsheet: 220355d1363127397-market-profile-price-info-mp1
Sheet: Sheet1

Date | Time | High | Low |  |  | 2013-01-02 00:00:00 | 2013-01-03 00:00:00
2013-01-02 00:00:00 | 06:00:00 | 55 | 52 |  | 58
2013-01-02 00:00:00 | 06:30:00 | 58 | 55 |  | 57
2013-01-02 00:00:00 | 07:00:00 | 54 | 52 |  | 56
2013-01-02 00:00:00 | 07:30:00 | 57 | 53 |  | 55
2013-01-02 00:00:00 | 08:00:00 | 53 | 51 |  | 54
2013-01-03 00:00:00 | 06:00:00 | 53 | 51 |  | 53
2013-01-03 00:00:00 | 06:30:00 | 56 | 52 |  | 52
2013-01-03 00:00:00 | 07:00:00 | 55 | 50 |  | 51
2013-01-03 00:00:00 | 07:30:00 | 53 | 52 |  | 50
2013-01-03 00:00:00 | 08:00:00 | 55 | 50 |  | 49
Spreadsheet: 713772d1610924636-column-lookup-last-values-previous-value-or-values-book1
Sheet: Sheet1

2 |  | A column |  | B column
3 | u | Last Value | Second to last value | Last Text value | Second to last Text value
0 | -
7 | u
11 | d
0 | -
12 | u
7 | d
1 | d
3 | d
1 | u
10 | u
11 | d
4 | u
2 | u
2 | d
13 | u
9 | d
2 | u
10 | d
5 | u
5 | d
21 | u
19 | d
2 | d
3 | u
1 | d
Spreadsheet: 510064d6-e3f1-4c60-9dd8-126e168aca35
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7191 | 5547 | [NAME] | [NAME] | RSA | 21 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:14:04
7191 | 15849 | Gillian | Sanders | RSA | 22 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:15:55
Spreadsheet: 72968d1273662107-adding-empty-cell-only-if-nothing-else-is-entered-in-referring-cells-time-recording
Sheet: Thursday

 | Name |  |  |  | Date
 | Activity Code | Time | Elapsed Time | Comments |  |  | Toatl Time Recorded for each Category
 | A20 | 08:45:00 | 00:15:00 |  |  |  | Other Building Control Activities |  |  | Non-Chargaeable activities |  |  | Chargeable Activities
 | A19 | 09:00:00 | 03:00:00 |  |  |  | A1 |  |  | B1 |  |  | C1
 | a24 | 12:00:00 | 00:15:00 |  |  |  | A2 |  |  | B2 |  |  | C2
 | end | 12:15:00 |  |  |  |  | A3 |  |  | B3 |  |  | [NAME]
 |  |  |  |  |  |  | A4 |  |  | B4 |  |  | C4
 |  |  |  |  |  |  | A5 |  |  | B5 |  |  | C5
 |  |  |  |  |  |  | A6 |  |  | B6 |  |  | C6
 |  |  |  |  |  |  | A7 |  |  | B7 |  |  | C7
 |  |  |  |  |  |  | A8 |  |  | B8 |  |  | C8
 |  |  |  |  |  |  | A9 |  |  | B9 |  |  | C9
 |  |  |  |  |  |  | A10 |  |  | B10 |  |  | C10
 |  |  |  |  |  |  | A11 |  |  | B11 |  |  | C11
 |  |  |  |  |  |  | A12 |  |  | B12 |  |  | C12
 |  |  |  |  |  |  | A13 |  |  | B13 |  |  | C13
 |  |  |  |  |  |  | A14 |  |  |  |  |  | C14
 |  |  |  |  |  |  | A15 |  |  |  |  |  | C15
 |  |  |  |  |  |  | A16 |  |  |  |  |  | C16
 |  |  |  |  |  |  | A17 |  |  |  |  |  | C17
 |  |  |  |  |  |  | A18
 |  |  |  |  |  |  | A19 | 03:00:00
 |  |  |  |  |  |  | A20 | 00:15:00
 |  |  |  |  |  |  | A21
 |  |  |  |  |  |  | A22
 |  |  |  |  |  |  | A23
 |  |  |  |  |  |  | A24
 |  |  |  |  |  |  | A25
 |  |  |  |  |  |  | A26
 |  |  |  |  |  |  | A27
 |  |  |  |  |  |  | A28
 |  |  |  |  |  |  | A29
 |  |  |  |  |  |  | A30
 | Total Time Recorded |  | 03:30:00 |  |  |  | Total | 03:15:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00
Spreadsheet: 798345d1664435863-run-xlookup-or-similar-to-compare-up-to-5-values-within-the-same-string-book1-36-
Sheet: Sheet1

1 | Q
2 | W |  |  | W E I U |  | <<---
3 | E
4 | R |  |  | W E I U |  | <<---
5 | T
6 | Y
7 | U
8 | I
Spreadsheet: 757d68f8-2e65-4a96-8118-a8b3f65a330e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
6038 | 13354 | [NAME] | [NAME] | GBR | 438 | 00:00:00 | 00:00:00 | 00:20:42 | [NAME] | 00:15:08 | 1 | 00:38:39
Spreadsheet: e75bcda5-60c2-442f-a07a-53efddf9afca
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
FEPHD | Test | FEPHD | Ephedrine, Serum | Ephedrine | Gas Chromatography/Electron Capture Detection (GC-EC) | 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), plasma gel tube is not acceptable. Spin down and send 3 mL sodium heparin plasma refrigerated in a plastic vial. If specimen is not light protected foil wrap specimen to protect from light.   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 in a plastic vial. If specimen is not light protected foil wrap specimen to protect from light. | 0.6 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	EDTA | Reference Range:	35-80 ng/mL   Test Performed by: Medtox Laboratories, Inc.                              402 W. County Road D                              St. Paul, MN 55112 | Monday through Sunday | 7 days | 9 - 11 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc.
FEPHD | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 14 days
FEPHD | Result | Z1142 | Ephedrine | Ephedrine | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 882877d1731355196-dynamic-formula-to-show-the-day-and-the-number-of-cycles-that-can-be-ran-that-day-29th-capacity-notes-for-project-for-submission
Sheet: Product Parameters

Table2
ProdCd | ProdNm | RackWt | Racks/Cycle | CookSetup | CookHrs | CookTtl | ChillSetup | ChillHrs | ChillTtl | CycleTotal | OffsetHrs | DrawdownHrs | CookTemp | SpecTemp
 | None
62001 | Steak | 1200 | 7 |  | 4 |  | 0.3333333333333333 |  |  |  |  |  | 134 | 132
62005 | Carnitas | 1000 | 6 |  | 5 |  | 0.3333333333333333 | 3 |  |  |  |  | 195 | 190
90081 | [NAME] | 860 | 7 |  |  |  | 0.3333333333333333 | 2 |  |  |  |  | 145 | 142
90082 | [NAME] | 860 | 7 |  |  |  | 0.3333333333333333 | 2 |  |  |  |  | 145 | 142
90083 | [NAME] | 860 | 7 |  |  |  | 0.3333333333333333 | 2 |  |  |  |  | 145 | 142
90084 | Fresh realm Thighs | 1015 | 7 |  |  |  | 0.3333333333333333 |  |  |  |  |  | 160 | 155
Spreadsheet: 699897d1602815074-formula-help-countifs-sumproduct-excel-help
Sheet: BEFORE

 |  | LEGEND: W = Work, Wn = hours worked (ex. W10 is 10 hour work day), R = Daily Test, E = Weekly Test, T = Pre Employment Test |  |  |  |  |  | APPLE | [NAME] | CHARLIE | DELTA | EDWARD | FRANKLIN
 |  |  |  |  |  |  | QTY | 4 | 2 | 3 | 1 | 4 | 1
 |  |  |  |  |  |  | ADJ | U | X |  | U | X | Y
Date | DAY | PLACE | Notes |  | T | W | ID | S1 | S2 | S3 | [NAME] | S5 | S6
2020-11-04 00:00:00 | 1 | [NAME] | finish driveway |  |  |  |  | T |  | W10,R |  | W11 | W11
 | 2 | [NAME] | finish driveway |  |  |  |  |  | W11 |  | W
 | 3 | [NAME] | frame house |  |  |  |  |  |  | T |  | W10
 | 4 | [NAME] | frame house |  |  |  |  | W10,E | W11,T |  |  |  | T
 |  | [NAME] | [NAME] steps |  |  |  |  | W10 | W11,T | W10,R
TOTALS: |  |  | Total WORK DAYS |  |  |  |  | # of 10 Hr Days |  |  | # of 11 Hr Days
 |  |  | Total TESTS |  | #
Spreadsheet: sally_beck__33936__SEC VaR
Sheet: 6-30-99

SEC VaR Calc and Reporting Template
Item | Description |  | VaR |  | Application | [NAME] | [NAME] | [NAME] | Data Contacts
1 |  | AGG_ECT | 30444 |  | Trading: Commodities | GRMS | vatr 2 | [NAME] | na
2 |  | AGG_INDEX | 5595 |  | Trading: Commodities | GRMS | vatr 2 | [NAME] | na
3 |  | AGG_EUROPE | 5982 |  | Trading: Commodities | DPR | vatr 2 | RM Group | na
4 |  | Weather | 1995 |  | Trading: Commodities | DPR | historic | RM Group | na |  | Arg Power | Arg Gas | Combined
5 |  | Argentina |  |  | Trading: Commodities | Ad-Hoc | vatr 1 | [NAME] | na |  | 283.309 | 260
6 |  | Australia | 717.588 |  | Trading: Commodities | Ad-Hoc | vatr 1 | [NAME] | na |  | EES Power | EES Gas | Combined
7 |  | EES |  |  | Trading: Commodities | Ad-Hoc | vatr 1 | [NAME] | [NAME] |  |  | 189
8 |  | IR | 139 |  | Trading: IR | Ad-Hoc | vatr 1 | RM Group | [NAME]
9 |  | FX | 26 |  | Trading: FX | Ad-Hoc | vatr 1 | RM Group | [NAME]
10 |  | ECM: Equities |  |  | Trading: Securities | Ad-Hoc | varcov | RM Group | Monty [NAME]
11 |  | Securities | 1582 |  | Trading: Securities | DPR | varcov | RM Group | na
12 |  | Merchant Assets | 15846 |  | Trading: Securities | Ad-Hoc | varcov | [NAME] | [NAME] |  | Aff Gas | Aff Liquids | Combined
13 |  | Total Return Swaps | 3059 |  | Trading: Securities | Ad-Hoc | varcov | [NAME] | na |  | 0 | 0
14 |  | AFFILIATE | 17552 |  | Non-Trading: Commodities | GRMS | vatr 2 | [NAME] | [NAME] |  | PGE Power | PGE Gas | Combined
15 |  | PGE |  |  | Non-Trading: Commodities | Ad-Hoc | vatr 1 | [NAME] | [NAME] |  | 3163.741 | 169.963 | 3126.918
16 |  | ECM: FX | 0 |  | Non-Trading: FX | Ad-Hoc | vatr 1 | RM Group | [NAME]
17 |  | ECM: IR | 2702 |  | Non-Trading: IR | Ad-Hoc | varcov | RM Group | [NAME]
SEC VaR Matrix/Reporting Template As Of 30-JUN-99
 |  | Trading | Non-Trading
 | Commodities
 | Interest Rates
 | Foreign Exchange |  |  |  | SUM SQUARE TOTAL
 | Securities |  | 0
 |  | Change in Trading | Change in Non-Trading
 | Commodities
 | Foreign Exchange
 | Interest Rates
 | Securities
SEC VaR Matrix/Reporting Template As Of 31-MAR-99
 |  | Trading | Non-Trading
 | Commodities | 24778.96851418461 | 9129.554315518364
 | Foreign Exchange | 65.631 | 0 |  | FINAL
 | Interest Rates | 101.433 | 872
 | Securities | 14119.64247649125 | 0
Spreadsheet: 66691d1267369749-vlookup-ignore-first-58-characters-in-cell-return-value-export-xml-copy-of-blacks_silvers_desc2
Sheet: Sheet1

File_Name | [NAME] | Color/Description
ambiance_black_thumb.jpg | Ambiance | Black
ambiance_silver_thumb.jpg | Ambiance | Silver
azalea-black_white_edited_thumb.jpg | Azalea | White on black
chateau_black_gold_thumb.jpg | Chateau | Taffeta material, Gold on Black
black-poly_edited_thumb.jpg | Classic | Poly-cotton, Black
crystal_clover-black_silver_thumb.jpg | Crystal Clover | Black and Silver
Dior_blk_silver.JPG | Dior | Silver with Black stripes
eyelash_black_thumb.jpg | Eyelash | Black
Florance_black675x450.jpg | Florance | Black
florance_silver.jpg | Florance | Silver
galaxy_black.JPG | Galaxy | Black
galaxy_silver.JPG | Galaxy | Silver
hollywood_black_silver.JPG | Hollywood | Silver on Black
infinity_blk-silver675x450.jpg | Infinity | Silver on Black
sheer_black675x450.jpg | Organza | Black
pintuck_black675x450.jpg | Pintuck | Black
pintuck_silver675x450.jpg | Pintuck | Silver
white_polka_dot.JPG | Polka-Dot | White on Black
racing_check_thumb.jpg | Racing Check | Black
Black-satin_thumb.jpg | [NAME] | Black
Satin_Silver675X450.jpg | [NAME] | Silver
satin_voile_black.JPG | [NAME] | Black
sheer_bombay-blk_thumb.jpg | [NAME] | Black
Black_stripe_thumb.jpg | Stripe | Black
sundaze_black_blue.JPG | Sundaze | Blue on Black
Sundaze_silver_pink.JPG | Sundaze | Pink on Silver
DSC02065.JPG | Swirl | Organza material with satin edges, Black
taffeta_black.JPG | Taffeta | Black
taffeta_silver.JPG | Taffeta | Silver
tara-black_edited-1thumb.jpg | Tara | Organza material with satin edges, Black
vegas_black-silver.JPG | Vegas | Silver on Black
Spreadsheet: 812272c0-d17a-4409-934a-83ff41ed8244
Sheet: Sheet1

Patient # | Last Name | First Name | Age | Sex | Resident/Staff | Room #/ Work Area | Date of Onset | Date Resolved | Days of Duration | Elevated Temperature | Highest Temperature | Chills | Cough | Shortness of breath | [NAME] | Hemoptysis | Nasal congestion | Pneumonia | Abnormal Chest X-Ray  (Y, N, ND) | Hospitalized | Days Hospitalized | Treated with Antivirals  (If Yes, please list agent) | Received antiviral prophylaxis | Vaccinated against influenza > 14 days prior to outbreak illness | Vaccinated against Streptococcus pneumoniae > 14 days prior to outbreak illness | Specimen Collection Date | [NAME] | Specimen Collection Type (Naso, Orophr, Throat, [NAME], Other) | Lab Results ( Fax results to Health Dept) | Other? (Describe)
Facility Name: |  |  |  |  |  | Phone #: |  |  |  | Notes:
Address: |  |  |  |  |  | Fax #:
City: |  |  |  |  |  | Contact Person:
Zip: |  |  |  |  |  | [NAME]:
Spreadsheet: mary_hain__25844__4th qtr 2000 GENCO FERC
Sheet: Gleason Operations

Gleason Power I, L.L.C.
FERC Filing
Generation Sales:
Organization Name | Transaction Type | Firm/Interruptable | Volume (MW) | Min Price | [NAME] | Point Name
Enron Power Marketing Inc. | S | F | -1288 | 50 | 53 | ENGL-Gleason(TVA)-EPMI
Total Generation Sales
Spreadsheet: 119905d1314845591-search-function-question-2
Sheet: Sheet1

List
ID&Code | ID | Code | Relationship | Name | Date
1242323 | 12423 | 23 | Father | [NAME] S.(ALM) | 01.12.2010
1242325 | 12423 | 25 | Mother | [NAME] | 03.11.2010
1242327 | 12423 | 27 | Sibling | [NAME] | 09.09.2010
1242327 | 12423 | 27 | Sibling | [NAME] S.(ALM) | 01.05.2011
1242327 | 12423 | 27 | Sibling | [NAME] (ALM) | 01.08.2011
1. Find out [NAME] from list |  | ID | 12423
Code | Relationship | Name |  | Answer
23 | Father | [NAME] S.(ALM) |  | Correct
25 | Mother |  |  | Correct
27 | Sibling | [NAME] (ALM) |  | [NAME] (ALM)
Spreadsheet: 82079d1282135073-data-changes-with-different-number-book-example
Sheet: Figures

Q1 | P1 | S1 | M1 | N1 | Q2 | P2 | S2 | M2 | N2 | Q3 | P3 | S3 | M3 | N3 | Q4 | P4 | [NAME] | M4 | N4 |  | sales person | Q | P | S | M | N
sale 2 | sale 5 | sale 11 | SALE 32 | SALE 14 | sale 11 | sale 2 | sale 8 | sale32 | SALE 38 | sale 39 | SALE 48 | SALE 27 | sale 8 | SALE 68 | sale31 | sale31 | sale 20 | sale 22 | sale 8 |  | [NAME] | 3 | 2 | 1 | 4 | 1
sale 8 | sale 6 | sale31 | SALE 33 | sale31 | sale31 | sale 8 | sale31 | sale 13 | SALE 39 | sale 6 | sale 8 | sale31 | sale 4 | SALE 34 | sale 9 | sale 4 | sale 13 | sale32 | sale31 |  | [NAME] | 1 | 3 | 1 | 2 | 2
sale 4 | sale 2 | sale 4 | SALE 34 | sale 9 | sale 4 | sale 4 | sale 4 | sale 8 | SALE 14 | sale 6 | sale 4 | sale 4 | sale 6 | SALE 35 | sale 8 | sale 8 | sale 24 | sale 13 | sale 4 |  | jonas | 3 | 2 | 2 | 1 | 1
sale 5 | sale 8 | sale 20 | SALE 35 | sale 8 | sale 8 | sale 5 | sale 13 | sale 1 | sale31 | sale 2 | sale 5 | sale 8 | sale 2 | SALE 36 | SALE 34 | sale 4 | sale 1 | sale 8 | SALE95 |  | padear | 4 | 4 | 2 | 1 | 4
sale 6 | sale 9 | sale 13 | SALE 36 | SALE 34 | SALE 34 | sale 11 | sale 8 | sale 11 | sale 9 | sale 8 | sale 6 | sale32 | sale 11 | SALE 37 | sale 2 | sale 5 | sale 11 | sale 1 | sale 5 |  | fran | 2 | 4 | 4 | 3 | 3
sale 2 | sale 1 | sale 24 | SALE 37 | sale 2 | sale 2 | sale31 | sale 4 | sale 39 | sale 8 | sale 9 | SALE 37 | sale 13 | sale 4 | SALE71 | sale 24 | sale 6 | sale 39 | sale 11 | sale 6 |  | oliver | 1 | 1 | 3 | 3 | 2
sale 8 | sale 11 | sale 90 | SALE 38 | sale 24 | sale 11 | sale 4 | sale 5 | sale 6 | SALE 34 | sale 1 | SALE 34 | sale 8 | sale 20 | SALE72 | sale 32 | SALE 37 | sale 6 | SALE 40 | sale 2
sale 9 | sale 4 | sale 8 | SALE 39 | sale 13 | sale 4 | sale 9 | sale 6 | sale 2 | sale 44 | SALE 4 | sale 2 | sale 1 | sale 13 | SALE73 | sale 8 | sale 72 | SALE 37 | sale 33 | sale 8
sale 1 | sale 20 | sale 9 | SALE 40 | SALE 2 | sale 20 | sale 1 | sale 98 | sale 8 | sale 6 | SALE 88 | sale 24 | sale 11 | SALE 42 | SALE 86 | SALE 34 | sale 54 | SALE 34 | sale77 | sale 9
sale 11 | sale 13 | sale 1 | SALE 41 | sale 8 | sale 55 | sale 11 | sale31 | sale 33 | sale 2 | SALE 10 | sale 13 | SALE 40 | SALE 21 | SALE 39 | sale 44 | sale86 | sale 2 | sale 65 | sale 43
Spreadsheet: 707330d1607183159-use-of-filter-grouping-in-the-formula-loop-used-to-find-quartile-inc-excel-query
Sheet: Sheet2

Fund Name | Category | Returns | Desired Result |  |  |  | Original Data |  |  | Data Sorted by Category |  |  | Quartile Rank wihin category
ABLF | LF | 5.2 |  |  |  |  | Fund Name | Category | Returns | Fund Name | Category | Returns
ABLPF | LPF | 6.2 |  |  |  |  | ABLF | LF | 5.2 |  | LF | 5.2
CDLF | LF | 5.3 |  |  |  |  | ABLPF | LPF | 6.2 | CDLF | LF | 5.3
CDLPF | LPF | 6.3 |  |  |  |  | CDLF | LF | 5.3 | EFLF | LF | 5.6
EFLF | LF | 5.6 |  |  |  |  | CDLPF | LPF | 6.3 | GHLF | LF | 4.8
EFLPF | LPF | 6.1 |  |  |  |  | EFLF | LF | 5.6 | IJLF | LF | 3.6
GHLF | LF | 4.8 |  |  |  |  | EFLPF | LPF | 6.1 | KLLF | LF | 4.7
GHLPF | LPF | 5.8 |  |  |  |  | GHLF | LF | 4.8 | MNLF | LF | 5.1
IJLF | LF | 3.6 |  |  |  |  | GHLPF | LPF | 5.8 | OPLF | LF | 5.7
IJLPF | LPF | 5.6 |  |  |  |  | IJLF | LF | 3.6 | ABLPF | LPF | 6.2
KLLF | LF | 4.7 |  |  |  |  | IJLPF | LPF | 5.6 | CDLPF | LPF | 6.3
KLLPF | LPF | 6.8 |  |  |  |  | KLLF | LF | 4.7 | EFLPF | LPF | 6.1
MNLF | LF | 5.1 |  |  |  |  | KLLPF | LPF | 6.8 | GHLPF | LPF | 5.8
MNLPF | LPF | 6 |  |  |  |  | MNLF | LF | 5.1 | IJLPF | LPF | 5.6
OPLF | LF | 5.7 |  |  |  |  | MNLPF | LPF | 6 | KLLPF | LPF | 6.8
OPLPF | LPF | 6.2 |  |  |  |  | OPLF | LF | 5.7 | MNLPF | LPF | 6
 |  |  |  |  |  |  | OPLPF | LPF | 6.2 | OPLPF | LPF | 6.2
I am trying to create some calculations based on the quartile performance in each of the category.
Desired result arrived by sorting the data range using category and finding the quartiles for a specific category
I want to find the quartile ranks of based on the categories using formulas on the entire data range
Spreadsheet: 700212d1603061123-sorting-mixed-list-into-two-separate-lists-index-small-if-exampleindex-and-aggregate
Sheet: Desired Output

 | Casual Employees |  |  | Regular Employees