tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 739916d1626085851-countif-with-choose-value-error-countif-with-choose
Sheet: Sheet1

Parent Code | Child Code | Helper Column | Count | Without Helper
Item No 1 | Part A
Item No 1 | Part B
Item No 1 | Part C
Item No 1 | Part D
Item No 1 | Part E
Item No 1 | Part F
Item No 1 | Part E
Item No 1 | Part A
Spreadsheet: 315ee1fc-10b9-4dd6-a85d-01f8d24e3d8b
Sheet: Pub Date

Month | Titles | Percentage
Jan | 45
Feb | 35
Mar | 30
Apr | 54
May | 48
June | 42
July | 45
Aug | 31
Sept | 47
Oct | 46
Nov | 63
Dec | 31
Spreadsheet: 466122d1466013308-using-drop-down-list-in-excel-2010-recipes
Sheet: Ingredients

Ingredient | Brand | Amount | Calories | Fat | Sat. Fat | Cholesterol | Sodium | Carbs | Fiber | Sugar | Protein
[NAME] | Syntha-6 | 2 scoops (94g) | 400 | 12 | 4 |  | 380 | 30 | 10 | 8 | 44
Sugar Free Instant Vanilla Pudding |  | 1 tbsp | 3 |  |  |  | 40 | 1
Cinnamon | [NAME] | 1/4 tsp | 1 |  |  |  |  | 0.5
Vanilla Extract | [NAME] | 1/4 tsp
Butter Flavor Extract | [NAME] | 1/2 tsp
Water |  | 1 cup
Ice |  | 1 handful
Chocolate Whey Protein | CytoSport | 1 Scoop (36g) | 130 | 1.5 | 1 | 40 | 180 | 3 | 1 | 2 | 27
Spreadsheet: mary_fischer__25619__77L
Sheet: E15.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 077L
COMPANY NAME   PBM Mechanical Inc.
ANALYSIS OF MINORITY INTERESTS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  | E-15
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  | AMOUNT |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | ENRON'S |  | BALANCE |  | PER INCOME |  | OTHER |  |  |  | BALANCE
 |  | OWNERSHIP % |  | DR. (CR.) |  | STATEMENT |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Minority Interest | * |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0855  DR/(CR)
Spreadsheet: 697782d1601523838-how-to-display-qty-given-from-store-with-excessive-stock-sample2
Sheet: Sheet1

 |  |  |  | Stock |  |  |  |  |  | Weekly Sales |  |  |  |  |  | Store Rank |  |  |  |  |  | Qty to Fulfill |  |  |  |  |  |  | In stock rate |  |  |  |  |  | FULFILLMENT |  |  |  |  |  |  | STOCK TO BE |  |  |  |  |  | notification
Article | Sold date | Color | WH Stock | 1 | 2 | 3 | 4 | 5 |  | 1 | 2 | 3 | 4 | 5 |  | 1 | 2 | 3 | 4 | 5 |  | 1 | 2 | 3 | 4 | 5 | EXCESS |  | 1 | 2 | 3 | 4 | 5 |  | 1 | 2 | 3 | 4 | 5 | TOTAL QTY |  | 1 | 2 | 3 | 4 | 5
ABC | 2020-06-02 00:00:00 | X | 100 | 2 | 20 | 2 | 0 | 2 |  | 1 | 5 | 4 | 3 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] qty
ABC | 2020-06-02 00:00:00 | Y | 5 | 0 | 1 | 2 | 2 | 0 |  | 0 | 2 | 2 | 3 | 1
ABC | 2020-06-02 00:00:00 | Z | 0 | 0 | 0 | 3 | 0 | 2 |  | 0 | 0 | 0 | 1 | 2
ABC | 2020-06-02 00:00:00 | X |  |  | 13 | 15 | 2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 3 | 4 | 0 | 0 |  |  |  |  |  |  |  |  | Ambil dari store rank terakhir untuk dikonsol ke store dengan rank teratas
ABC | 2020-06-02 00:00:00 | Y |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | sold date <=2 minggu
ABC | 2020-06-02 00:00:00 | Z |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | positive (+) : qty needed to be fulfilled |  |  |  |  |  |  |  |  |  |  |  |  | display the qty needed to be given from the lowest rank store with excessive stock to the top stores which need the stock
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | minus (-) : excessive stock, need to allocate to store which needs (based on store rank)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stock
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank
Spreadsheet: 46061d1244842185-recurring-meetings-687359-recurring-meeting
Sheet: Meetings

Meeting | Frequency | Week | Day
MBU | Monthly | 2 | 1900-01-02 00:00:00
MMM | Weekly | 1 | 1900-01-02 00:00:00
MMM | Weekly | 3 | 1900-01-02 00:00:00
MMM | Weekly | 4 | 1900-01-02 00:00:00
QBU | Quarterly | 1 | 1900-01-02 00:00:00
Fiscal Close | Last Of Month | 4 | 1900-01-06 00:00:00
BPM | Monthly | 1 | 1900-01-06 00:00:00
Spreadsheet: 46579d1245423937-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: UOFA - CS-SPD PACKS (#1)

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS/SPD PACKS (1)
FACILITY: | UNIVERSITY OF ALBERTA HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: | X | X | X | X | X |  |  | X
** If more/less linen required please fax in this order by 7:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
ENT FREE FLAP |  |  |  | CP0038 |  | 4
2-LEGGINGS |  |  |  | SP0002 |  | 3
MAYO COVER |  |  |  | SP0003 |  | 30
LG SPLIT DRAPE |  |  |  | SP0010 |  | 15
MED BARRIER |  |  |  | SP0016 |  | 60
TABLE COVER |  |  |  | SP0019 |  | 8
HALF SHEET |  |  |  | SP0015 |  | 10
3/4 SHEET |  |  |  | SP0020 |  | 20
2-HUCK TOWEL |  |  |  | SP0081 |  | 60
6-HUCK TOWEL |  |  |  | SP0083 |  | 10
BURN WRAPPER |  |  |  | SP0017 |  | 10
CHEAST/BREAST DRAPE |  |  |  | SP0035 |  | 1
BACK PROTECTOR |  |  |  | GP0017 |  | 16
SM SPLIT DRAPE |  |  |  | SP0009 |  | 3
OPEN HEART DRAPE |  |  |  | SP0024 |  | 6
UPDATED:
June 17th 2009
Spreadsheet: 190013d1351505073-cross-file-capturingupdating-file3powerball
Sheet: File3Powerball.csv

2012-08-17 00:00:00 | 4 | 41 | 3 | 32 | 23 | 14
2012-08-14 00:00:00 | 34 | 14 | 15 | 31 | 20 | 1
2012-08-10 00:00:00 | 12 | 9 | 44 | 21 | 23 | 37
Spreadsheet: 132898d1324011409-how-to-copy-information-from-non-consecutive-lines-into-consecutive-lines-example-v2
Sheet: Result from dilipandey's code

Customer A | 100 | 30 | 40 | 170
Customer A | 200 | 20 | 50 | 270
Customer A | 0 | 30 | 100 | 130
Customer B | 50 | 100 |  | 150
Customer B | 300 | 40 | 60 | 400
Customer B | 0 |  | 0 | 0
Customer C | 20 | 30 | 40 | 90
Customer C | 50 | 60 | 70 | 180
Customer C | 100 | 90 | 80 | 270
Customer D | 90 | 50 | 40 | 180
Customer D | 90 | 20 | 20 | 130
Customer E | 100 | 50 | 30 | 180
Customer E | 20 | 40 | 0 | 60
Customer E | 50 | 40 | 50 | 140
Customer E | 20 | 70 |  | 90
Spreadsheet: 288020d1389066378-create-a-consolidated-list-sales-person
Sheet: Pivot

 | SalespersonNo | BRAD | **Select a Sales Person
 | CustomerName | Customer No
 | Customer 313 | 03-0000112
 | Customer 321 | 03-0000419
 | Customer 328 | 03-0000534
 | Customer 332 | 03-0000540
 | Customer 333 | 03-0000551
 | Customer 334 | 03-0000552
 | Customer 335 | 03-0000554
 | Customer 336 | 03-0000555
 | Customer 337 | 03-0000559
 | Customer 338 | 03-0000561
 | Customer 339 | 03-0000564
 | Customer 342 | 03-0000570
 | Customer 343 | 03-0000572
 | Customer 351 | 03-0000601
 | Customer 356 | 03-0000624
 | Customer 358 | 03-0000634
 | Customer 366 | 03-0000674
 | Customer 375 | 03-0000711
 | Customer 378 | 03-0000721
 | Customer 389 | 03-0000938
 | Customer 392 | 03-0001105
 | Customer 397 | 03-0001256
 | Customer 398 | 03-0001262
 | Customer 399 | 03-0001269
 | Customer 400 | 03-0001280
 | Customer 401 | 03-0001283
 | Customer 409 | 03-0009091
 | Customer 415 | 03-0010271
 | Customer 417 | 03-0010393
 | Grand Total
Spreadsheet: 137383d1327084631-calculation-based-on-cell-colour-change-orders-sheet-example_reply3
Sheet: Stock Dispatched

PREFIX | STYLE NO | COLOR | XS_28 | S_30 | M_32 | L_34 | [NAME] | XXL_38 | TOTAL
UCPJ | ANDERSON-130 | BLUE ASTER
UCPJ | ANDERSON-130 | Peacoat
UCHZ | BURTON-981 | Peacoat
UCHZ | COLIN-885 | White
UCHZ | COLIN-885 | WATERFALL
UCJK | RANDEL-950 | RUDE WINE
UCJK | RANDEL-950 | TWILIGHT BLUE
UCJK | STEPHENS-937 | BLACK
UCJK | STEPHENS-937 | BLUE ASTER
Spreadsheet: 204059d1357329575-how-to-format-dynamic-print-area-to-keep-cells-on-same-page-on-print-out-playback-log
Sheet: LISTS

SOURCES LIST
A
B
A/AA
B/BB
TC IN LIST
KEY ON
FADE UP
CUT ON
TC OUT LIST
KEY OFF
FADE OUT
FREEZE
TAIL PAD
FINAL LIST
YES
NO
NOTES LIST
SOT
TEMP
TEMP VO
TEMP FOR REHERSAL
MOS
UNMIXED
OUTQUE "…
STEREO
MUSIC CON'T AFTER VIDEO
AUDIO ONLY
 | COMMERCIAL #1
 | COMMERCIAL #2
 | COMMERCIAL #3
 | COMMERCIAL #4
 | COMMERCIAL #5
 | COMMERCIAL #6
 | COMMERCIAL #7
 | COMMERCIAL #8
 | COMMERCIAL #9
 | COMMERCIAL #10
 | COMMERCIAL #11
 | COMMERCIAL #12
 | COMMERCIAL #13
 | COMMERCIAL #14
 | COMMERCIAL #15
 | ACT 1
 | ACT 2
 | ACT 3
 | ACT 4
 | ACT 5
 | ACT 6
 | ACT 7
 | ACT 8
 | ACT 9
 | ACT 10
 | ACT 11
 | ACT 12
 | ACT 13
 | ACT 14
 | ACT 15
Spreadsheet: 832178d1686164597-need-help-creating-a-multiple-tab-invoice-from-a-raw-data-file-billing-data
Sheet: EXPENSES  Techs

PROJECT TITLE |  |  | SUV Backup Drivers |  |  |  | INVOICE PERIOD
DTNA REF# |  |  |  |  |  |  | START | END
PURCHASE ORDER# |  |  |  |  |  |  | 2023-05-01 00:00:00 | 2023-05-31 00:00:00
REF# |  |  | 130440
EXPENSE DESCRIPTION |  |  |  |  |  | RATE | QTY | TOTAL
Vehicle
NO ID |  | TYPE | DATE
 |  | Regular Hours |  |  |  | 51 | 760.25
 |  | OT Hours |  |  |  | 73.95 | 93.25
 |  |  |  |  |  |  |  |  |  |  | 43 | 2332.75 |  |  | 43 | 2372.75
 |  |  |  |  |  |  |  |  |  |  |  |  | 37211.69 |  |  |  | 37211.69
 |  |  |  |  |  | TOTAL
 |  |  |  |  | MONTH TOTAL
EXPENSE DESCRIPTION |  |  |  |  |  | RATE | QTY | TOTAL
Vehicle
NO ID |  | TYPE | DATE
 |  |  |  | Travel and Expenses |  | 25592.85 | 1
 |  |  |  |  |  | Total
 |  |  |  |  | MONTH TOTAL
Spreadsheet: 770736d1646237717-index-list-values-that-meet-criteria-list-with-array
Sheet: Master Invoice

 |  | Master [NAME]
Date | Hours | Contract
2022-02-01 00:00:00 | 0.75 | Company 1
2021-05-02 00:00:00 | 1.25 | Company 2
2022-01-02 00:00:00 | 0.5 | Company 2
2021-12-01 00:00:00 | 1 | Company 2
2021-04-01 00:00:00 | 1.75 | Company 2
2021-11-01 00:00:00 | 2 | Company 1
2022-02-08 00:00:00 | 3.5 | Company 1
Spreadsheet: 66310d1266998712-excel-2007-wrapped-text-not-showing-up-sample-problem
Sheet: Project Estimate

PROJECT ESTIMATE
Name: |  | Date:
Address: |  | Job Description:
ITEM | [NAME] | JOB COST | ALLOWANCES | JOB OPTIONS | TOTAL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
 | Total Project Costs
Spreadsheet: 211218d1359686564-find-and-replace-assistance-tester
Sheet: Sheet1

 |  | 16 player | Match 1 | Match 2
 |  | schedule
 |  | Round 1 | 1v16 | 2v15
 |  | Round 2 | 1v15 | 14v16
 |  | Round 3 | 1v14 | 13v15
 |  | Round 4 | 113 | 12v14
 |  | Round 5 | 1v12 | 11v13
 |  | Round 6 | 1v11 | 10v12
 |  | Round 7 | 1v10 | 9v11
 |  | Round 8 | 1v9 | 8v10
 |  | Round 9 | 1v8 | 7v9
 |  | Round 10 | 1v7 | 6v8
 |  | Round 11 | 1v6 | 5v7
 |  | Round 12 | 1v5 | 4v6
 |  | Round 13 | 1v4 | 3v5
 |  | Round 14 | 1v3 | 2v4
 |  | Round 15 | 1v2 | 3v16
 |  | Player list | Player number
 |  | red | 1
 |  | blue | 2
 |  | green | 3
 |  | yellow | 4
 |  | white | 5
 |  | pink | 6
 |  | beige | 7
 |  | [NAME] | 8
 |  | purple | 9
 |  | black | 10
 |  | crimson | 11
 |  | dark | 12
 |  | light | 13
 |  | grey | 14
 |  | sand | 15
 |  | orange | 16
Spreadsheet: frank_ermis__11061__West NatGas Prices 1127
Sheet: Gas Average PhyIdx

PhyIdx Curves
 |  | WEST NATURAL GAS PRICES- Phy Idx
 |  | AS OF
 |  |  |  |  |  |  |  |  |  | Last-Day | Cash | Cash | Change | BOM | BOM | Change | Prompt Month | Change | Q4 | Change | Winter 2001-02 | Change | Q1 | Change | Q2 | Change | Summer 2002 | Change | Q3 | Change | Q4 | Change | Winter 2002-03 | Change
 |  |  |  |  |  |  |  |  |  | Cash Settle | Price | Spread |  | Price | Spread |  |  |  | 2001 |  | Nov-01/Mar-02 |  | 2002 |  | 2002 |  | Apr-02/Oct-02 |  | 2002 |  | 2002 |  | Nov-02/Mar-03
 |  | California Region Notional
 |  |  |  |  | Sheet Name | Row Num for CurveName | Column Letter for Date
 |  |  |  | Basis | IndexCurves | 13 | B
 |  | Gas Trading |  | IntraMonth | CurveFetch | 4 | D
 |  |  |  |  |  |  |  |  | IntraMonth
 |  |  |  | IntraMonth Hub Curve | IF-HEHUB
 |  |  |  | IntraMonth Month
 |  |  |  |  |  |  |  |  | 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 | NGI-PGE/CG |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.043 |  |  |  | -0.0483 |  | -0.01 |  |  |  | -0.045 |  | -0.03
 |  | NGI-PGE/TOPOCK |  | NGI-PGE/TOPOCK | NGI-PGE/TOPOCK
 |  | NGI-MALIN |  | NGI-MALIN | NGI-MALIN
 |  | NGI-SOCAL |  | NGI-SOCAL | NGI-SOCAL
 |  | Southwest Region Notional
 |  | SAN JUAN |  | IF-ELPO/SJ | IF-ELPO/SJ
 |  | ELPO/PERMIAN |  | IF-ELPO/PERMIAN | IF-ELPO/PERMIAN
 |  | WAHA |  | IF-WAHA-TX | IF-WAHA-TX
 |  | NGPL/MIDCON |  | IF-NGPL/MIDCON | IF-NGPL/MIDCON
 |  | Northwest Region Notional
 |  | OPAL |  | IF-NWPL_ROCKY_M | IF-NWPL_ROCKY_M
 |  | STANFIELD |  | NW-STANFIELD | NW-STANFIELD
 |  | SUMAS |  | IF-NWPL/CNBR-US | IF-NTHWST/CANBR
 |  | AECO |  | CGPR-AECO/USIM | CGPR-AECO/BASIS
 |  | CIG |  | IF-CIG/RKYMTN | IF-CIG/RKYMTN
 |  | Ontario Region Notional
 |  | Central Region Notional
 |  | East & Texas Region Notional
 |  | Nymex
 |  | Nymex |  | IF-HEHUB | NG |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
Spreadsheet: 713868d1610988539-looking-for-a-formula-to-return-data-from-several-sheets-based-on-2-criteria-schedule
Sheet: Roster

 | DATE | SHIFT
 | 2021-02-01 00:00:00 | 1
 |  |  |  | I choose the shift (1,2,3)
Stations |  |  |  |  |  |  |  |  | Station
1 |  |  |  |  |  |  |  | [NAME]
2 |  |  |  | I put in a date |  |  |  | [NAME]
3 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  | It then draws the employees that work the specified date and shift and then places their names in the boxes next to the station they are listed to work. Some stations may have no one.
Spreadsheet: 820001d1677811705-how-to-tweak-formula-to-change-calendar-to-include-date-range-book_251717-3
Sheet: Calendar

 |  |  | MIGW 2023 AT A GLANCE
Month: | Year: |  | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY
October | 2023
 |  | 1
January | 2022 | 2
February | 2023 | 3
March | 2024 | 4
April | 2025 | 5
May | 2026 | 6
June | 2027 | 7
July | 2028
August | 2029 | 1
September | 2030 | 2
October | 2031 | 3
November | 2032 | 4
December | 2033 | 5
 |  | 6
 |  | 7
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
Spreadsheet: 687138d1594988634-help-on-formula-search-find-or-other-one-example-chevaleridulys-
Sheet: Sheet1

 | [NAME] |  |  |  | [NAME] |  | All Files
 | Client | Reference Number |  |  |  |  | Client | Reference Number
 | Company A | Luna0001_Luna0004 |  |  |  |  | Company A | Luna0001
 | Company C | Luna0003 |  |  |  |  | Company B | Luna0002
 |  |  |  |  |  |  | Company C | Luna0003
 |  |  |  |  |  |  | Company A | Luna0004
Spreadsheet: 198691d1354867519-ranking-depending-on-several-factors-sales
Sheet: Results

 |  |  |  |  |  | Class I - 75% |  |  |  |  |  |  |  |  |  |  |  | Class B - 25%
Name | Ranking |  | New Deposit 75% |  |  | Insurance   10% |  |  | Investments fund   15% |  |  |  |  | Loan A   15% |  |  |  |  |  | Loan B 75% |  |  |  | New Clients  10%
 |  | Actual | Target | Deviation | Actual | Target | Deviation | Actual | Target | Deviation |  | Actual |  | Target |  | Deviation |  | Actual |  | Target |  | Deviation | Actual | Target | Deviation
 |  |  |  |  |  |  |  |  |  |  | Nr. | Volume | Nr. | Volume | Nr. (40%) | Volume (60%) | Nr. | Volume | Nr. | Volume | Nr. (75%) | Volume (25%) | Nr. | Nr. | Nr.
[NAME] |  | 1261299 | 2000000 |  | 0 | 50000 |  | 250000 | 200000 |  | 0 | 0 | 1 | 100000 |  |  | 5 | 67115 | 3 | 50000 |  |  | 5 | 20
[NAME] |  | 3419000 | 2000000 |  | 0 | 50000 |  | 0 | 200000 |  | 1 | 255000 | 1 | 100000 |  |  | 5 | 93654 | 3 | 50000 |  |  | 2 | 20
[NAME] |  | 2136080 | 2000000 |  | 30000 | 50000 |  | 0 | 200000 |  | 1 | 225000 | 1 | 100000 |  |  | 5 | 127074 | 3 | 50000 |  |  | 2 | 20
Scott |  | 1075000 | 2000000 |  | 0 | 50000 |  | 30000 | 200000 |  | 1 | 258780 | 1 | 100000 |  |  | 5 | 55190 | 3 | 50000 |  |  | 2 | 20
Spreadsheet: 35638d1233237886-macro-code-required-for-calculations-base-on-pivot-tables-sum-pivot-example-a
Sheet: Pivot

Hours | (All)
Sum of Hours
Week No | Description | Name | Total |  | FTE
01 | Duty 12 | [NAME] | 9
 | Duty 12 Sum |  | 9 |  | 0.24
 | Duty 1 | [NAME] | 4
 | Duty 1 Sum |  | 4 |  | 0.1066666666666667
 | Duty 2 | [NAME] | 7.5
 |  | [NAME] | 7.5
 | Duty 2 Sum |  | 15 |  | 0.4
 | Duty 3 | Guy Robets | 7.5
 |  | [NAME] | 7.4
 |  | [NAME] | 7.4
 |  | [NAME] | 8.4
 |  | [NAME] | 1
 |  | [NAME] | 6.5
 |  | [NAME] | 8
 |  | [NAME] | 9
 | Duty 3 Sum |  | 55.2 |  | 1.472
 | Duty 6 | [NAME] | 7
 | Duty 6 Sum |  | 7
01 Sum |  |  | 90.2
Grand Total |  |  | 90.2 |  | 2.405333333333334
Spreadsheet: 109165d1306108647-dropdown-boxes-not-updating-cells-excel-forum-example
Sheet: REPORT

 | Community Report
 | COMMUNITY CENTRE / ORGANISATION: |  |  |  |  | Kids Community
 | TERM |  |  | PRICE AND PAYMENT |  |  |  |  |  |  | NEXT REPORT DUE DATE |  |  | REPORT TYPE
 | Commencement    Date | [NAME] |  | Period |  |  | Date of Invoice | Amount excl. GST
 | 2010-07-01 00:00:00 | 2012-06-30 00:00:00 |  | 2010-07-01 00:00:00 | to | 2010-09-30 00:00:00 | 2010-09-30 00:00:00 | 15000 | #N/A |  | 31/9/2010 | #N/A |  | Yearly | #N/A
 |  |  |  | 2010-10-01 00:00:00 | to | 2010-12-31 00:00:00 | 2010-12-31 00:00:00 | 15000 | #N/A |  | 2010-12-31 00:00:00 | #N/A |  | Yearly | #N/A
 |  |  |  | 2011-03-31 00:00:00 | to | 2011-03-31 00:00:00 | 2011-03-31 00:00:00 | 15000 | #N/A |  | 2011-03-31 00:00:00 | #N/A |  | Yearly | #N/A
 |  |  |  | 2011-04-01 00:00:00 | to | 2011-04-01 00:00:00 | 2011-06-30 00:00:00 | 15000 | #N/A |  | 2011-06-30 00:00:00 | #N/A |  | Yearly | #N/A
 |  |  |  | 2011-07-01 00:00:00 | to | 2011-09-30 00:00:00 | 2011-09-30 00:00:00 | 15000 | #N/A |  | 2011-09-30 00:00:00 | #N/A |  | Daily | #N/A
 |  |  |  | 2011-10-01 00:00:00 | to | 2011-12-31 00:00:00 | 2011-12-31 00:00:00 | 15000 | #N/A |  | 2011-12-31 00:00:00 | #N/A |  | Monthly | #N/A
 |  |  |  | 2012-01-01 00:00:00 | to | 2012-03-31 00:00:00 | 31/2/2012 | 15000 | #N/A |  | 2012-03-31 00:00:00 | #N/A |  | Daily | #N/A
 |  |  |  | 2012-01-01 00:00:00 | to | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 15000 | #N/A |  | 2012-03-31 00:00:00 | #N/A |  | Monthly | #N/A
 | 2011-05-20 00:00:00
 |  |  |  |  |  |  |  | CONTRACTOR / REPRESENTATIVE NAME: |  |  |  |  | [NAME]
Spreadsheet: 864604d1711705725-3-consecutive-vowels-categorise-3-cons-vowels-pull
Sheet: Sheet1

ARCHAEA
ALTHAEA
TAIAHAS
MANAIAS
WAIATAS
COBAEAS
BANDEAU
[NAME]
TABLEAU
BAUERAS
BATTEAU
BATEAUX
FABLIAU
CARDIAE
CADEAUX
FASCIAE
ARCHAEI
CHAPEAU
CHATEAU
COAEVAL
CAEOMAS
COAITAS
AOUDADS
KAIAKED
NAIADES
LEGUAAN
MANGEAO
GATEAUS
GATEAUX
ANTLIAE
SPIRAEA
APNOEAL
PLATEAU
MANTEAU
APNOEAS
KAWAIIS
ANTIAIR
MANOAOS
TATOUAY
BERCEAU
[NAME]
BIVOUAC
TABOOED
[NAME]
SEEABLE
BEAUFET
SUEABLE
BEAUTER
BEAUFIN
WOOABLE
BUREAUS
BUREAUX
BAGUIOS
ACCOIED
CAMEOED
CODEIAS
FAIENCE
OCHREAE
CORNEAE
GOUACHE
PAIOCKE
APNOEIC
PAEONIC
SCORIAE
MORCEAU
PONCEAU
CASEOUS
COTEAUS
COTEAUX
CARIOUS
VACUOUS
DEAIRED
RADIOED
QUAERED
FADEOUT
GEOIDAL
LIAISED
MIAULED
QUAILED
MIAOWED
RADIOES
APPUIED
NAPOOED
RONDEAU
DOUANES
ZOOIDAL
ARDUOUS
HERNIAE
HEAUMES
LEQUEAR
MARQUEE
PERAEON
QUAERES
RESEAUS
RESEAUX
LINGUAE
GLUTAEI
GASEOUS
HAVEOUR
ATHEOUS
LIAISES
LOIASES
[NAME]
TAKEOUT
NOTAEUM
RAMEOUS
[NAME]
TONNEAU
ZOUAVES
FATUOUS
SAGOUIN
HAVIOUR
LIAISON
LOIASIS
TAUIWIS
ROOIKAT
PRONAOI
SANIOUS
ANXIOUS
PAVIOUR
SOUARIS
SAVIOUR
[NAME]
MONOAOS
BEDOUIN
GOBIOID
DUBIOUS
BOUILLI
BILIOUS
[NAME]
[NAME]
ROOIBOS
OBVIOUS
RUBIOUS
COOEYED
RESCUEE
ECHOIER
QUIESCE
[NAME]
MECHOUI
MEIOTIC
[NAME]
[NAME]
VICIOUS
[NAME]
CORIOUS
CURIOUS
NOCUOUS
VIDEOED
RODEOED
QUEENED
QUEERED
UNFEUED
REOILED
MIMEOED
ENNUIED
QUIETED
RONEOED
FOLIOED
QUOIFED
HIKOIED
HIDEOUS
HIDEOUT
TENIOID
QUOINED
OSTEOID
QUOITED
TEDIOUS
DEVIOUS
WIDEOUT
UNWOOED
[NAME]
SIMIOID
OPIOIDS
VIDUOUS
EPEEIST
QUEERER
SQUEEZE
FOUETTE
SEMEION
MEIOSES
REQUIEM
PEREION
QUIETEN
QUIETER
[NAME]
UNQUEEN
OEUVRES
[NAME]
IGNEOUS
ROGUIER
VOGUIER
MILIEUS
MILIEUX
MEIOSIS
INQUIET
ROOINEK
[NAME]
ROUILLE
PILEOUS
PURLIEU
LIQUEUR
TIMEOUS
TIMEOUT
ENVIOUS
NIVEOUS
UNQUIET
PITEOUS
WIPEOUT
QUOITER
SERIOUS
QUIETUS
LUTEOUS
TENUOUS
OSSEOUS
FOLIOUS
FURIOUS
NIMIOUS
IMPIOUS
SIMIOUS
INVIOUS
[NAME]
OSMIOUS
[NAME]
SINUOUS
Spreadsheet: 862501d1710209255-list-winning-teams-name-and-players-based-on-lowest-daily-score-lowest-team-score-spreadsheet-scenario
Sheet: Sheet1

TEAM RED |  |  | TEAM BLUE |  |  | TEAM GREEN |  |  | TEAM ORANGE
[NAME] | -1 |  | Adam | 6 |  | [NAME] | 0 |  | Alfredo | 3
Cordero | 5 |  | Cliff | -4 |  | [NAME] | 1 |  | [NAME] | 3
[NAME] | -2 |  | Curtis | -2 |  | [NAME] | -3 |  | [NAME] | -4
[NAME] | 0 |  | [NAME] | -1 |  | Greg | -3 |  | Garrett | -1
[NAME] | -5 |  | [NAME] T | 0 |  | [NAME] | 6 |  | [NAME] | 1
Kris | -6 |  | [NAME] | 1 |  | Kenny | -4 |  | Justin | 0
[NAME] | 4 |  | [NAME] | 5 |  | Manue; | -1 |  | Mark | -2
[NAME] | -7 |  | [NAME] | -3 |  | [NAME] | 0 |  | [NAME] | -5
[NAME] | -1 |  | [NAME] | 0 |  | [NAME] | 6 |  | Norm | -3
[NAME] | 2 |  | Ruben | -2 |  | [NAME] | 4 |  | [NAME] | 1
[NAME] | 3 |  | Sean | 4 |  | Shane | -6 |  | [NAME] | 4
Travis | 0 |  | [NAME] | -1 |  | [NAME] | -3 |  | [NAME] | -3
Will | -1 |  | Trevor | -2 |  | Troy | -2 |  | [NAME] | 0
[NAME] | -4 |  | Vic | -5 |  | [NAME] | -3 |  | Yonex | 5
Zach | -2 |  | Wink | 1 |  | Xavier | -4 |  | Zach W | -6
TOTAL |  |  | TOTAL |  |  | TOTAL |  |  | TOTAL
TOP 12 GOLFERS |  |  | TOP 12 GOLFERS |  |  | TOP 12 GOLFERS |  |  | TOP 12 GOLFERS
I am looking for a formula that will automatically list the winning team's name in cell N1 and then will list the winning team's player's names in cells N2:N16 once the scores are inputted. The winning team is the team with the lowest Top 12 golfers score which are cells B18, E18, H18, and K18. (In the scenario above, TEAM GREEN is the winner with a score of -28).
Spreadsheet: 101463d1299592679-text-string-problem-in-vlookup-value-example
Sheet: Sheet1

Material | Price |  |  | Diameter | Length | Price
2" x 5' | 1.2 |  |  | 2 | 8 | 2.03
2" x 8' | 2.03 |  |  | 3 | 5 | 5.32
3" x 5' | 5.32 |  |  | 2 | 5 | 1.2
3" x 8' | 8.33 |  |  | 3 | 8 | 8.33
Spreadsheet: 641667db-50a4-4515-aebc-c3e232bbc2a2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: Rappahannock River for 2010
Indicator | 2010
Chlorophyll a | 19.79
Aquatic Grasses | 83.2
[NAME] | 82.592
[NAME] | 20
Water Clarity | 3.907
Phytoplankton Index | 47.16
Water Quality Index | 35.42966667
Biotic Index | 50.12
Bay Health Index | 42.77483333
Spreadsheet: 180593d1347648599-formula-that-averages-percentages-based-on-said-criteria-copy-of-barcode-example
Sheet: Sheet1

SPL | 1 | 0.35
0.1
0.3
0.2
0.8
SPL | 6 | 0.5125
0.15
1
0.6
0.3
SPL | 11 | 0.6333333333333333
1
1
0.5
0.3
0.5
0.5