tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 116327d1311755508-delete-rows-with-macro-with-an-extra-challenge-test
Sheet: Names

[NAME]
[NAME]
[NAME]
[NAME]
Alvis Zuze
Ana [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Carmen Janse [NAME]
[NAME]
[NAME]
Christian Berrios
[NAME]
Corris Krogscheepers
[NAME]
[NAME]
Dhoods Kaseeparisath
[NAME]
[NAME]
[NAME]
Florian Rivas
Freddie Venter
Gareth Davies
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Niresh Bapoo
[NAME]
[NAME]
Ravenesh Subroyal
[NAME]
[NAME]
[NAME]
Roni Zillig
[NAME]
[NAME]
Sonnette De Lange
[NAME]
[NAME]
Theresa Mazza
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: lynn_blair__24341__Wisc_P&L16daychartinfo_Oct2001
Sheet: Sheet1

Northern Natural Gas Company
Wisconsin Power & Light Zone Point - Poi 3124 - Zone D
Points with 16 day charts that need to be read for 10/2001
Poi # | Station #
4023 | 792041
4026 | 792011
4029 | 792032
4030 | 792071
4034 | 792161
4037 | 792371
4043 | 792511
4046 | 792741
4050 | 792921
4051 | 792941
25067 | 792722
Spreadsheet: michelle_lokay__26697__imball0111rev
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1 |  |  |  | 70
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
2001-10-31 00:00:00 |  |  |  |  | 25057.45
2001-11-30 00:00:00
CBS Volume
 |  |  | -3520
Spreadsheet: 109714d1306495253-auto-populate-pictures-and-count-differences-or-perhaps-another-method-training-matrix-masterblank
Sheet: Cell 1

TRAINING SKILLS MATRIX
Team Leader: |  | A.nother
Value Stream:
Date: |  | 2011-06-01 00:00:00
Process or Operation Name |  |  | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10 | Item 11 | Item 12 | Item 13 | Item 14 | Item 15 | Item 16 | Item 17 | Item 18 | Item 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAPABILITIES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q1 | Q2 | Q3 | Q4
# | NAME | Ideal Number Trained
1 | person 1
2 | person 2
3 | person 3
4 | person 4
5 | person 5
6 | person 6
7 | person 7
8 | person 8
9 | person 9
10 | person 10
11 | person 11
RESULT  OF  TRAINING |  | Q1 | counts
 |  | Q2
 |  | Q3
 |  | Q4
REMARKS
Spreadsheet: 111429d1307796019-merge-two-e-mail-lists-email-lists
Sheet: Sheet3

[NAME] | Name | country
123 | q
546 | e
951 | rty
789 |  | ppp
6987 |  | ZXS
555 | QWW
0 |  | #N/A
0 |  | #N/A
0 |  | #N/A
Spreadsheet: kimberly_watson__20566__010726Al
Sheet: LetterSizeRegionLoc 

ETS Planned And Unplanned Outages - January 1, 2001 Through December, 2001
Albuquerque Region Only - Sorted By Region/Location
The information provided is tentative and may be changed without further notice.  Northern Natural Gas, [NAME] and Florida Gas Transmission are not responsible for any reliance on this information.
Data Extracted July 26, 2001 |  |  |  |  |  |  |  |  |  |  | Est. Flow | Est. Vol. |  |  | Act. | Act. | Act.
No. | ID# | Location | Units | Title | EstStart | EstComp | Duration | Line | Proj. Mgr | W.O. # | Affected | Affected | DescOfWork | DescOfWork2 | Start | Compl. | [NAME]. | P/U | Pub | Ver
 |  |  |  |  |  |  |  |  |  |  | (Mmcfd) | (Mmcf)
1 | 16194 | STATION 1 | 102 | SAFETY DEVICES | 2001-09-18 08:00:00 | 2001-09-20 16:00:00 | 2.3 |  | OPS |  | 50 | 116.7 | Safety devices. |  |  |  | 0 | P | N | N
2 | 16195 | STATION 1 | 101 | SAFETY DEVICES | 2001-09-25 08:00:00 | 2001-09-27 16:00:00 | 2.3 |  | OPS |  | 50 | 116.7 | Safety devices. |  |  |  | 0 | P | N | N
3 | 17090 | STATION 2 | MAINLINE | RED ROCK TIE-IN | 2001-10-22 08:00:00 | 2001-10-26 16:00:00 | 4.3 |  | OPS |  | 130 | 563.3 | New block and side valve assemblies for new compressor and scrubbers will be installed on the suction side main and loop lines at each station. The tie-in will entail isolating a line segment within the plant yard. |  |  |  | 0 | P | N | N
4 | 17091 | STATION 2 | LOOP LINE | RED ROCK TIE-IN | 2001-11-05 08:00:00 | 2001-11-07 16:00:00 | 2.3 |  | OPS |  | 130 | 303.3 | New block and side valve assemblies for new compressor and scrubbers will be installed on the sucton side main and loop lines at each station. The tie-in will entail isolating a line segment within the plant yard. |  |  |  | 0 | P | N | N
5 | 16521 | STATION 3 | 321 | OVERHAUL | 2001-11-05 08:00:00 | 2001-11-23 16:00:00 | 18.3 |  | OPS |  | 0 | 0 | Engine overhaul. |  |  |  | 0 | P | N | N
6 | 16900 | STATION 8 | MAINLINE | MAINLINE BLOCK | 2001-08-28 08:00:00 | 2001-08-31 16:00:00 | 3.3 |  | OPS |  | 0 | 0 | Remove 1 section of mainline from service for 4 days.  Block pipeline for 2 hours to use station compression to lower section pressure by transferring gas from mainline west of station to mainline east of station  then reestablish bypass conditions. |  |  |  | 0 | P | N | N
7 | 16752 | STATION 8 | 2 | AUTOMATION | 2001-09-04 08:00:00 | 2001-10-31 16:00:00 | 57.3 |  | OPS |  | 0 | 0 | Station 8 automation project. 8000 HP |  |  |  | 0 | P | N | N
Spreadsheet: 1b6281b4-c84d-43f7-9397-9112ed685fdd
Sheet: Sheet1

Artist | Title
Amman, [NAME], ca. 1539-1591 | [NAME] (Old Man from Bohemia)
Barnet, Will, born 1911 | Study for the Vogels (Herb with hands on chin)
Barth-White, [NAME] | [NAME]
Barth-White, [NAME] | [NAME]
Burford, [NAME], 1920-2011 | [NAME]
Cezanne, [NAME], 1839-1906 | Self-Portrait
Cone, [NAME], 1891-1965 | Winnifred
Cone, [NAME], 1891-1965 | Winnifred
Cone, [NAME], 1891-1965 | Self Portrait
Cone, [NAME], 1891-1965 | Untitled (Portrait of Winnifred)
Cone, [NAME], 1891-1965 | Untitled
Cone, [NAME], 1891-1965 | Untitled ([NAME])
Cone, [NAME], 1891-1965 | Self Portrait
Coxcie the Elder (attributed to), [NAME], 1499-1592 | Portrait of [NAME]
Easker, [NAME], born 1944 | [NAME]'s [NAME]
Edelinck, [NAME] ([NAME]), 1640-1707 | Portrait of [NAME]
Frantzen, Rose | [NAME]
Frantzen, Rose | [NAME]
Frantzen, Rose | [NAME]
Frantzen, Rose | [NAME]
Frantzen, Rose | Amber [NAME]
Frantzen, Rose | [NAME]
Frantzen, Rose | [NAME]
Frantzen, Rose | Brent Rathje
Frantzen, Rose | [NAME]
Frantzen, Rose | [NAME]
Frantzen, Rose | [NAME]
Frantzen, Rose | [NAME]
Frantzen, Rose | [NAME]
Frantzen, Rose | [NAME]
Frantzen, Rose | [NAME]
Guidry, [NAME], born 1976 | Zachary
Hawthorne, [NAME], 1872-1930 | The Captain, The [NAME] and The First Mate
[NAME], [NAME], born 1923 | Reflections
[NAME], Malvina, 1885-1966 | [NAME]
[NAME], Malvina, 1885-1966 | Mrs. [NAME]
Hooke, [NAME], 1823-1887 | Caroline Stuart Irwin
Kollwitz, Käthe, 1867-1945 | Selbstbildnis (Self Portrait)
Lasansky, Mauricio, born 1914 | Lincoln
Lasansky, Mauricio, born 1914 | Self-Portrait
Liffring-[NAME], [NAME], born 1929 | Grandmother, [NAME], MN; also known as My Grandmother
Liffring-[NAME], [NAME], born 1929 | [NAME]
Liffring-[NAME], [NAME], born 1929 | [NAME]
Liffring-[NAME], [NAME], born 1929 | [NAME]
[NAME] and Hall Portrait Gallery | Wa-Pel-La Chief of the Musquakees
[NAME] and Hall Portrait Gallery | Ne-O-Mon-Ne (Ioway Chief)
Morris, [NAME] | Portrait of Rose Frantzen in Her Studio
Redon, Odilon, 1840-1916 | [NAME]
Rembrandt, [NAME], 1606-1669 | An Elderly Woman (Rembrandt's [NAME] at a Table)
Rockwell, Norman, 1898-1978 | Election Day
Scholder, [NAME], 1937-2005 | Portrait of a Screaming Artist (Self Portrait)
Shahn, [NAME], 1898-1969 | [NAME] [Jr.]
[NAME], [NAME], 1893-1976 | [NAME]
Sterner, [NAME], 1863-1946 | The Artist's Son - Harold
Tibbles, [NAME] | [NAME]
Tibbles, [NAME] | [NAME]
Tibbles, [NAME] | [NAME]
[NAME], [NAME], born 1951 | Lucas
[NAME], Anthony, 1599-1641 | Jan Snellinck
[NAME], [NAME] | [NAME]
[NAME], [NAME] | [NAME]
[NAME], [NAME] | [NAME]
[NAME], [NAME] | [NAME]
[NAME], [NAME] | [NAME]
[NAME], [NAME] | [NAME]
[NAME], [NAME] | Edna St. Vincent Millay
[NAME], [NAME] | [NAME]
[NAME], [NAME], 1928-1987 | [NAME]
[NAME], [NAME], 1834-1903 | Drouet, Sculpteur (Drouet, Sculptor)
Wilson, [NAME], born 1922 | [NAME], Jr.
Wood, Grant | Portrait of Judge [NAME]
Wood, Grant, 1891-1942 | Self Portrait sketch
Wood, Grant, 1891-1942 | Study for Self Portrait
Yuan, Seldon, born 1975 | Thinking of You
Spreadsheet: 777158d1650210781-linest-help-linest-test
Sheet: Sheet1

0.01 | 0.25295 |  |  | 0.2345127510550576 |  |  | -0.007261057170567698
3 | 0.2329500000000001 |  | 0.001010455250804274 | 0.03199331787949038 |  | 6.88388766132117e-07 | 3.282281905387978e-05
40 | 0.31295 |  | 0.8232373088048548 | 0.04396978434046385 |  | 0.9999982538862823 | 0.0001954385775041808
49 | 0.42295 |  | 9.314604832487015 | 2 |  | 286349.6929474541 | 1
 |  |  | 0.01800831613010619 | 0.0038666838698938 |  | 0.02187496180376241 | 3.819623757685769e-08
Spreadsheet: darrell_schoolcraft__7825__imbalsumm0109
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -18474 | -500 |  | -17302
2 | -17798 | -500 |  | -17302
3 | -17797 | -500 |  | -17302
4 | -18510 | -500 |  | -17302
5 | -28067 |  | -19 | -27302
6 | -32603 | -6315 | -4 | -25302
7 | -28184 |  | -2 | -27904
8 | -40209 | -14724 |  | -24700
9 | -40733 | -14724 |  | -24700
10 | -40617 | -14724 | -9 | -24700
11 | -23227 |  |  | -24200
12 | -41150 |  |  | -40658
13 | -30551 | -5000 |  | -27506
14 | -47126 | -6000 |  | -40998
15 | -87040 | -54000 |  | -32608
16 | -68686 | -54000 | -19172 | -32608
17 | -60138 | -54000 | -27411 | -32608
18 | -73176 | -20202 | -186 | -54709
19 | -74991 | -40404 |  | -35391
20 | -62822 | -74648 | -34224 | -25306
21 | -82790 | -57989 | -35804 | -60408
22 | -72527 | -40583 | -251 | -33469
23 | -72983 | -40583 |  | -33469
24
25
26
27
28
29
30
31
 | 2001-08-31 00:00:00 |  |  |  | 73003
 | 2001-09-23 00:00:00
CBS Dollars
 |  |  | 71590.87
Spreadsheet: 758022d1638575741-minor-xirr-question-issue-excel-xirr-question
Sheet: Exhibit 4 - Fund I Invest

 | Exhibit 4
 | Fund I Investments and Performance
 |  |  | CASH FLOWS BY DEAL
 | Year.Quarter | S&P500* |  |  |  |  |  |  |  |  |  |  |  |  | Gross Cash Flow | Gross Investments | Gross Distributions | [NAME] |  | Net Investments | Carried Interest | Net Distributions | Net Cashflow
 | 2011-12-31 00:00:00 | 2158.939941
 | 2012-03-31 00:00:00 | 2430.669922
 | 2012-06-30 00:00:00 | 2363.790039
 | 2012-09-30 00:00:00 | 2513.929932
 | 2012-12-31 00:00:00 | 2504.439941 | -2
 | 2013-03-31 00:00:00 | 2770.050049
 | 2013-06-30 00:00:00 | 2850.659912
 | 2013-09-30 00:00:00 | 3000.179932 |  | -3.5 | -6.317
 | 2013-12-31 00:00:00 | 3315.590088 | -5.295
 | 2014-03-31 00:00:00 | 3375.51001 |  |  |  | -6 | -2
 | 2014-06-30 00:00:00 | 3552.179932 |  |  |  |  |  | -1.7
 | 2014-09-30 00:00:00 | 3592.25 |  |  | -8.49
 | 2014-12-31 00:00:00 | 3769.439941 |  |  |  |  |  |  | -6.5 |  |  | -10 | -7
 | 2015-03-31 00:00:00 | 3805.27002 |  |  |  | -5.5
 | 2015-06-30 00:00:00 | 3811.014839220159 |  |  |  |  | -2 |  |  | -4
 | 2015-09-30 00:00:00 | 3570.192093032013
 | 2015-12-31 00:00:00 | 3821.445060248869 |  | -2.2
 | 2016-03-31 00:00:00 | 4087.721529504281
 | 2016-06-30 00:00:00 | 4323.256908711559 |  |  |  |  |  |  |  |  | -6
 | 2016-09-30 00:00:00 | 4228.581242142424 |  |  |  |  |  | 0.9 | 6.5 | 6.5 | 6 | 16.1 | 7
 | Value at 9/30/16 |  | 25.71 | 17.6 |  |  |  |  | 6.5 | 4 | 6 |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | *S&P 500 Total Return Index
 |  |  |  |  |  |  |  |  |  |  |  |  |  | MOIC |  |  |  |  |  | MOIC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | IRR |  |  |  |  |  | IRR
 | Assumptions
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Capital Invested |  |  |  |  |  | Capital Invested
 | Fund AUM | 100 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME]
 | [NAME] | 0.02
 | Carried Interest | 0.2
Spreadsheet: d6574284-fe51-4d5d-8e32-411330d932d3
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 801193153128 | [NAME] Fortress Fire | I Have No Doubt | 2012-04-17 | Compact Disc | Gospel | 8.99 | Y | Available
Spreadsheet: 769200d1645386742-search-for-data-in-one-table-returning-new-data-from-another-table-ef1566_match_2_columns
Sheet: Sheet1

Level | Start |  |  | End |  | Level | New Start |  |  | New End
3 | 15.02 | 15.25 | 15.51 | 16.32 |  | 3 | 22.53 | 22.88 | 23.27 | 24.48
4 | 16.98 | 17.02 | 17.56 | 18.35 |  | 4 | 25.47 | 25.53 | 26.34 | 27.53
5 | 17.37 | 17.49 | 17.89 | 19.31 |  | 5 | 26.05 | 26.24 | 26.84 | 28.97
6 | 19.02 | 19.59 | 19.98 | 20.55 |  | 6 | 28.53 | 29.39 | 29.97 | 30.83
7 | 20.56 | 20.99 | 21.55 | 21.96 |  | 7 | 30.84 | 31.49 | 32.33 | 32.94
Level | Current | New Current
4 | 18.35
7 | 21.96
 | The yellow table = current level start and end amounts
 | The green table = new level start and end amounts
 | The blue table = my data
 | I need to search the yellow table for the level and current amount using the information in the blue table and return the new amount from the green table.
Spreadsheet: 851854d1701972565-need-help-converting-a-google-sheets-formula-to-excel-scheduling-test1
Sheet: Tauro 1

T1 | 37.63 | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 4 Pass | 2024-01-15 00:00:00 |  | T1 | For production quote- [NAME]
 | 231235 | 1 | Fred | 1 | 45 | 58 | PAP-SO-0017 | 1 | 4 Pass | 2024-01-15 00:00:00 |  | T1
 | 232445 | 2 | [NAME] | 4 | 30 | 30 | PAP-SO-1332 | 1 | 4 Pass | 2024-01-15 00:00:00 |  | T1
 | 243556 | 3 | Gregory | 25 | 33 | 20 | ART-4443 | 1 | 4 Pass | 2024-01-15 00:00:00 |  | T1
 | 243557 | 2 | Gregory | 300 | 24 | 36 | ART-3232 | 1 | 4 Pass | 2024-01-15 00:00:00 |  | T1
 |  |  | [NAME] | 15 | 22 | 22 | PAP-SO-2263 - WHITE STATIC CLING 29.5X20.5 | 1 | FU or [NAME]
 |  |  | [NAME] | 128 | 25 | 27 | PAP-SO-0061 - SINTRA 3MM WHITE 48X96 | 1 | 4 Pass
 |  |  | [NAME] | 552 | 9 | 11 | PAP-SO-2191 - CARDSTOCK 18PT CIS 48X96 | 2 | 4 Pass
Spreadsheet: 168284d1342368612-excel-2007-return-to-next-row-book3
Sheet: Sheet1

fruit | percentage
apple | 0.35
orange | 0.1
banana | 0.1
papaya | 0.1
coconut | 0
[NAME] | 0
mango | 0
kiwi | 0
durian | 0.2
cherry | 0.05
pineapple | 0.05
watermelon | 0.05
Spreadsheet: sally_beck__35539__MSA_Sales_Volumes_01
Sheet: Sheet1

MSA Sales Volumes (GJ's)
 | 2001-12-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00
Birchill | 68417 | 65131 | 27748 | 54746
Enco | 82950 | 77416 | 88554 | 138671
Encounter | 39730 | 39670 | 34705 | 33265
[NAME] | 236449 | 261314 | 225887.4896 | 215758.952
Invasion | 241300 | 331450 | 303600 | 415100
Newquest | 165605 | 263300 | 218900 | 238600
Piper | 137800 | 129000 | 120700 | 108700
Post | 565850 | 495525 | 433800 | 457270
Redeagle | 3685 | 2940 | 2940 | 3065
Startech | 223721 | 335262 | 512312 | 174975
Triquest | 0 | 0 | 10390 | 18740
Cavell | 68622 | 75429 | 73102 | 89753
Raven | 95779 | 82531 | 78834 | 84528
Impact | - | - | 8005 | 12431
Monthly Volumes |  |  |  |  | GJs
Daily Volumes |  |  |  |  | GJs per day
Spreadsheet: 766577d1643950963-pulling-number-values-from-text-string-cover-sheet
Sheet: Target Info

 |  | DATE |  |  |  |  | 2022-01-31 00:00:00 |  |  |  |  |  |  |  |  | DAY OF WEEK
 |  |  | SUMMIT LOUNGE DAILY NUMBERS
 |  | • |  | BATRENDERS
 |  | • |  | CASH IN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 492.25
 |  | • |  | MINUS TIPS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 243
 |  | • |  | CASH DUE B4 RECEIPTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 249.25
 |  | • |  | GROSS AMOUNT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1792.25
 |  | • |  | CREDIT CARD DEP. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1276
 |  | • |  | FOOD SALES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 167.6
 |  | • |  | TAXES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 104.73
 |  | • |  | NET AMOUNT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1549.25
 | PAYOUTS FOR THE DAY
 |  | • |  | ENTERTAINMENT
 |  | • |  | SECURITY
 |  | • |  | OPERATION RECEIPTS
 |  | • |  | OTHER
BANK BAG MOUNT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVER/SHORT
Spreadsheet: 848922d1699530092-i-want-to-pull-out-extract-data-through-excel-formula-excel-solution-request1
Sheet: PVT

 |  | Values
Customer Name | Status | 'Investment Amount | Status
Emma | Matured | 100000 | 1
[NAME] | Matured | 1000000 | 1
[NAME] | Matured | 5000 | 1
[NAME] | Matured | 500000 | 1
Sophia | Matured | 500000 | 1
Grand Total |  | 2105000 | 5
Spreadsheet: 881947d1730196528-number-stored-as-text-lookup-to-number-testd
Sheet: List

Item | Committed | Picked | Packed | Fulfilled | Received | Back Ordered | Quantity | Transfer Price | Amount | Description | Expected Ship Date | [NAME] | Expected Receipt Date | Commit | Commitment Confirmed | Order Priority | Options | Closed | CBM | Total CBM | Weight | Total Weight | QC Inspection | UPI Data | History
123.123 |  |  |  |  |  |  | 9 |  |  | ProductABC
Spreadsheet: 749006d1632457280-conditional-formatting-not-working-for-2nd-line-item-book1233555
Sheet: Master Data

Dates | 2021-10-01 00:00:00
Country
Canada
china
cyprus
hong-kong
macau
nigeria
palau
Holiday Table |  |  |  | =COUNTIF(INDEX($B$13:$B$31,MATCH(A3,$A$13:$A$31,0),0),B1)
FINAL COUNTRY NAMES | Dates
Canada | 2021-10-01 00:00:00
Canada | 2021-10-02 00:00:00
cyprus | 2021-10-01 00:00:00
Hong Kong | 2021-10-01 00:00:00 |  |  | Based on the Holiday Table, its not highligting the color  for 2nd October for Canada. I have used the above formular in conditinal formating.
China | 2021-10-02 00:00:00
nigeria | 2021-10-01 00:00:00
palau | 2021-10-01 00:00:00
China | 2021-10-03 00:00:00
tuvalu | 2021-10-01 00:00:00
uzbekistan | 2021-10-01 00:00:00
venezuela | 2021-10-01 00:00:00
china | 2021-10-02 00:00:00
guinea | 2021-10-02 00:00:00
india | 2021-10-02 00:00:00
macau | 2021-10-02 00:00:00
malaysia | 2021-10-02 00:00:00
tuvalu | 2021-10-02 00:00:00
china | 2021-10-03 00:00:00
germany | 2021-10-03 00:00:00
Spreadsheet: 87862d1287721666-drop-down-menu-result-fills-cell-on-other-sheet-copy-of-test-2
Sheet: Sheet2

DATE | 2010-01-02 00:00:00 |  |  | BL # | 03-99999 |  |  |  | In Transit Tag Used? |  |  | No
DRIVER | [NAME] |  |  | OID | 99999 |  |  |  | DMV [NAME]? |  |  | No
DETAILS OF CUSTOMER VEHICLE
DATE | CITY/STATE | FUEL | TOLLS | WASH | MOTEL | FLIGHT | BUS | CAB | RENTAL | MISC | TOTAL | COMMENTS
2014-01-02 00:00:00 | Cityville, PA | 46 |  |  |  |  |  |  |  |  |  | First Service
 | TOTAL EXPENSES | 46 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DETAILS OF CHASE [Company/Rental]VEHICLE
DATE | CITY/STATE | FUEL | TOLLS | WASH | MOTEL | FLIGHT | BUS | CAB | RENTAL | MISC | TOTAL | COMMENTS
 | TOTAL EXPENSES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10-99999 | GRAND TOTAL EXPENSES | 46 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 46
Spreadsheet: 693454d1598974106-really-need-help-with-sum-going-insane-over-this-counting-pairs
Sheet: Sheet1

B |  | C
1005 | 2488 |  |  | Row Labels | Count of C
1005 | 2488 |  |  | 1005 2488 | 15
1005 | 2488 |  |  | 1016 2488 | 6
1005 | 2488 |  |  | 1005 2489 | 6
1005 | 2488 |  |  | 1005 190 | 4
1005 | 2488 |  |  | 1005 2491 | 3
1005 | 2488 |  |  | 1005 188 | 2
1005 | 2488 |  |  | 1016 796 | 1
1005 | 2488 |  |  | 1016 1395 | 1
1005 | 2488
1005 | 2488
1005 | 2488
1005 | 2488
1005 | 2488
1005 | 2488
1005 | 2489
1005 | 2489
1005 | 2489
1005 | 2489
1005 | 2489
1005 | 2489
1005 | 2491
1005 | 2491
1005 | 2491
1005 | 188
1005 | 188
1005 | 190
1005 | 190
1005 | 190
1005 | 190
1016 | 1395
1016 | 2488
1016 | 2488
1016 | 2488
1016 | 2488
1016 | 2488
1016 | 2488
1016 | 796
Spreadsheet: 297739d1392562580-match-and-lookup-match-and-lookup
Sheet: Sheet1

[NAME] |  |  |  | EX-2
ID# | Amount |  |  | ID# | Amount
4042 | 10 |  |  | 4042 | 10
4042 | 20 |  |  | 2988 | 30
2988 | 30 |  |  | 4042 | 20
5555 | 40 |  |  | 4042 | 50 |  | need formula
4042 | 50 |  |  | 2988 | 70
4444 | 60 |  |  | 2988 | Should be blank
2988 | 70
Spreadsheet: 46678d1245605345-help-with-charting-data-series-with-3-variables-sample-graph
Sheet: Sheet1

X-Axis | [NAME] | DataSeries 1 | Data Series 2 | Data Series 3
0.8 | 0 | 0 | 0.013 | 0
0.85 | 0.25 | 0.01 | 0.0145 | 0
0.9 | 0.5 | 0.015 | 0.02 | 0.035
0.95 | 0.75 | 0.03 | 0.0312 | 0.05
1 | 1 | 0.0315 | 0.04 | 0.0625
Spreadsheet: 113173d1309157833-excel-2007-to-sum-the-number-of-task-preformed-by-1-in-between-the-selected-dates-sample
Sheet: Sheet3

Select Date From | 7/3/2011 | Select Date To | 7/5/2011
DATA
Name | 2011-07-01 00:00:00 | 2011-07-02 00:00:00 | 2011-07-03 00:00:00 | 2011-07-04 00:00:00 | 2011-07-05 00:00:00 | 2011-07-06 00:00:00 | 2011-07-07 00:00:00
AAAA | 1 | 2 | 3 | 4 | 5 | 6 | 7
BBBB | 2 | 3 | 4 | 5 | 6 | 7 | 2
CCCC | 3 | 4 | 5 | 6 | 7 | 8 | 3
Required output
Name | Total
AAAA | (Need AAAA's total between  the selected date)
BBBB | (Need BBBB's total between  the selected date)
CCCC | (Need CCCC's total between  the selected date)
Spreadsheet: 08452d33-02b2-4cb8-9d77-1640d7ef67f4
Sheet: Sheet1

Ref # | Part # | Description | Notes
AG2 | 016338-Z | HANDLEBAR ASSEMBLY | Includes HPS sets and N70 (2)
AN5 | 014926-AB | FRAME CONSOLE ASSEMBLY
CNS | 071875 | CNS FP7 | Includes COS,N11,N12,N13,N60,N65,N68
COS | 062365-ZUP | CONSOLE OVERLAY SET FOLDING PREMIER | Includes overlay, metal panel,N62,N64 only
HPS | 026768-Z | GRIP HEART RATE | Includes G09,G10,and [NAME]
[NAME] | 007806-D | PLATE CONTACT HR
G10 | 004339-00 | [NAME] [NAME]
G11 | 004880-00 | NUT M3
G52 | 004706-A | [NAME]
N01 | 063231-AAX | COVER CONSOLE UPPER FOLDING
N02 | 063232-AAX | COVER CONSOLE LOWER FOLDING
N11 | 001485-BA | REED SWITCH BRACKET
N12 | 001961-D2 | REED SWITCH
N13 | 000890-AA | RACK READING INSERTS
[NAME] | 000799-BA | HOLDER BOTTLE
N16 | 004612-AB | SCREW BH M3X8
N17 | 004612-00 | BOLT BH M3X8 TAPPING
N18 | 004351-00 | [NAME]
N19 | 004612-AB | SCREW BH M3X8
N20 | 005091-Z | WASHER FT 4X10X1.2
N50 | 004369-00 | SCREW BH M5X15
N60 | 057766-AAX | UPPER BOARD PREMIER TCP7
N62 | 056526-A | KEYPAD MEMBRANE 21 KEY
N64 | 056527-A | TOUCH PAD PREMIER SMALL
N65 | 038132-BBX | BOARD RECEIVER HR CONTACT
N68 | 024272-BX | RECEIVER HRT DELUXE/PREMIER
N70 | 002337-A | WIRE HRT CONNECTING TCPD6
V01 | 064225-AX | DECAL VF MOTOR COVER
V10 | 006130-AX | DECAL SAFETY KEY TCPD6
NOT SHOWN | 013860-B | SAFETY KEY ASSEMBLY
NOT SHOWN | [NAME] | TRANSMITTER W/ STRAP KIT
NOT SHOWN | 006719-00 | CARD WARRANTY
NOT SHOWN | 063277-AX | MANUAL ASSEMBLY FOLDING CONSOLE
NOT SHOWN | 056836-AX | MANUAL
NOT SHOWN | 002480-A | CABLE CONSOLE JUMPER 810MM-8 PIN
NOT SHOWN | 002464-B | CABLE CONSOLE JUMPER 750MM-6-PIN
NOT SHOWN | 003567-B2 | JACKS DATA 8-PIN CONSOLE LARGE
NOT SHOWN | 003568-B2 | JACKS DATA 6-PIN CONSOLE SMALL