tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 219908d1363011609-auto-reapply-autofilter-test
Sheet: PartMark

 |  |  |  |  |  |  |  |  |  |  |  |  | INDENTER
Detail No. | Quantity | Change Part Number | Check Part Number | [NAME] | Marking up (Stamps) | Marking up (Indenter) | Marking up (Vibro etch) | Paint Infilled | Remove & Reapply Labelling | Stencil Part Number | Vibro Etch | Machine Time | Single Line Straight | Single Line Radio | Multi-Line Straight | Multi-Line Radio | Set up Label Fixtures | Trial Run on Labels | Turn Head Column (180 Degrees) | Bag & Tag | Other | Total Time (hours) | NOTES
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  | 0
Spreadsheet: 274822d1383230129-max-value-mult-criteria-excel-max-value
Sheet: Data

Cat | Customers
1 | 7611
2 | 28749
5 | 4173
7 | 72258
8 | 1
10 | 83226
11 | 42297
12 | 17254
13 | 67615
15 | 5355
16 | 68441
17 | 48289
18 | 10973
21 | 1211
25 | 8
26 | 47
Spreadsheet: 819831d1677707209-put-multiple-matching-rows-into-one-row-on-another-sheet-sample
Sheet: Sheet1

1 | white | b | c |  | 1 | white | b | c | red | a | c | orange | a | d
1 | red | a | c |  | 3 | red | c | a | orange | a | f | yellow | d | d
1 | orange | a | d |  | 4 | orange | c | c | blue | a | d | purple | e | c
1 | yellow | e | g
1 | green | a | d |  |  |  | b | c | red | a | c | orange | a | d | yellow | e | g | green | a | d
3 | red | c | a |  | 3 |  | c | a | orange | a | f | yellow | d | d | green | c | d | blue | d | c | purple | f | a
3 | orange | a | f |  | 4 |  | c | c | blue | a | d | purple | e | c
3 | yellow | d | d
3 | green | c | d
3 | blue | d | c
3 | purple | f | a
4 | orange | c | c
4 | blue | a | d
4 | purple | e | c
Spreadsheet: 64164d1265045536-annualizing-data-annualizing-expenses
Sheet: Sheet1

Month | 2009 Expenses | 2010 Expenses
January | 100 | 200
February | 100 | 225
March | 200
April | 250
May | 300
June | 350
July | 375
August | 300
September | 400
October | 450
November | 500
December | 500
Spreadsheet: 61442d1262285338-pulling-from-one-sheet-to-another-based-on-date-dc
Sheet: Entertainment Center Budget

Item | Price | Source | Number needed
HDMI + RCA Jacks | 10.99 | Amazon.com | 1
Dual HDMI Jack | 9.55 | Amazon.com | 1
Single HDMI [NAME] | 4.74 | Amazon.com | 1
Speaker Wall Panel | 16 | Home Technology Store | 1
[NAME] repeater | 89.99 | Smarthome | 1
Yamaha 5.1 Speakers | 137.98 | Vanns | 1
Satalite Mounts |  | [NAME] | 4
Center Channel Mount | 24 | Amazon.com | 1
[NAME] | 28 | Amazon.com
Spreadsheet: 8b160305-a88f-4887-870c-4a85bf085f1a
Sheet: Sheet1

[NAME]/koudeopslag, in bedrijf zijnde projecten met een vergunning [NAME]. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
[NAME] | aantal | vergund maximaal [NAME] (mln [NAME]) | Vermogen (MW) | Vermeden [NAME] fossiele primaire energie (TJ) | Vermeden emissie CO2 ([NAME])
1990 | 4 | 0.62294 | 1.095397 | 2.762782464770206 | 0.1851995630312311
1991 | 4 | 0.62294 | 1.095397 | 2.762782464770206 | 0.1851995630312311
1992 | 5 | 1.12294 | 2.745397 | 3.658782429484257 | 0.249199562554394
1993 | 10 | 2.63294 | 8.271569 | 9.894428324076303 | 0.6619817600742208
1994 | 16 | 3.53102 | 10.90003821081543 | 13.69295691127328 | 0.916372608107746
1995 | 25 | 5.59502 | 21.40850321081543 | 20.40134071625595 | 1.368886202467347
1996 | 34 | 13.15282 | 34.28991859777832 | 37.44462211561936 | 2.533468612294048
1997 | 55 | 20.96722 | 55.3892716022461 | 66.16964550493677 | 4.441221220774048
1998 | 85 | 33.00294 | 87.64193403903808 | 99.95089726469206 | 6.722170725204499
1999 | 120 | 44.1456 | 126.8173892925097 | 134.6823255291163 | 9.056312701583527
2000 | 151 | 57.8306 | 164.9659511735217 | 167.1255550898852 | 11.27376387493089
2001 | 189 | 74.958497 | 213.4467825112453 | 209.1202181080797 | 14.13506791708377
2002 | 242 | 104.411772 | 314.9602101755041 | 269.2487303919184 | 18.29606714203415
2003 | 309 | 126.872881 | 384.0871424728011 | 320.125949172622 | 21.80417394348497
2004 | 351 | 144.14228 | 435.9920151958011 | 361.9140692494194 | 24.65875457475792
2005 | 396 | 156.54508 | 473.8359227306154 | 388.3947315276234 | 26.45972204608108
2006 | 489 | 198.51296 | 602.5687794906154 | 500.2617704677266 | 34.07409809124376
Bron:CBS
Spreadsheet: 174110d1344935318-sumifs-with-date-range-help-please-sumifs
Sheet: Sheet1

 |  |  |  |  |  |  |  | 2012-08-11 00:00:00 | 2012-08-18 00:00:00
 |  | 2012-08-04 00:00:00 | 2012-08-11 00:00:00 | 2012-08-18 00:00:00 | 2012-08-25 00:00:00 |  | 2012-08-04 00:00:00 | 2012-08-18 00:00:00
 | Guinness | 22 | 11 | 0 | 11 |  | 33
 | Heineken | 0 | 33 | 0 | 11 |  | 33 |  |  | Guinness | 2012-08-04 00:00:00 | 22
 | [NAME] | 44 | 0 | 11 | 33 |  | 55 |  |  | Guinness | 2012-08-11 00:00:00 | 11
 | Guest Ale | 11 | 11 | 33 | 0 |  | 55 |  |  | Guinness | 2012-08-18 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  | Guinness | 2012-08-25 00:00:00 | 11
 | Stock take from | 2012-08-04 00:00:00
 | Stock take to | 2012-08-18 00:00:00
 | I want a formula that will take the from and to dates and sum the numbers by product within the date range
 | eg for Guiness these dates would return 33
 | The answer sheet will look like
 |  | Total delivered
 | Guiness | formula in here
 | Product | Delivery | Total
 | a | 2012-08-04 00:00:00 | 1
 | b | 2012-08-04 00:00:00 | 2
 | c | 2012-08-04 00:00:00 | 3
 | d | 2012-08-04 00:00:00 | 4
 | a | 2012-08-11 00:00:00 | 5
 | b | 2012-08-11 00:00:00 | 6
 | c | 2012-08-11 00:00:00 | 7
 | d | 2012-08-11 00:00:00 | 8
 | a | 2012-08-18 00:00:00 | 9
 | b | 2012-08-18 00:00:00 | 10
 | c | 2012-08-18 00:00:00 | 11
 | d | 2012-08-18 00:00:00 | 12
Spreadsheet: 700008d1602889057-totalizing-a-resetting-flow-totalizer-totalizer
Sheet: Sheet1

Water Flow Totalizer Resets at 1000
Time | Gallons
2020-09-01 03:17:32.304000 | 351.576751708984
2020-09-01 03:21:32.313000 | 381.161987304688
2020-09-01 03:35:32.344000 | 410.539154052734
2020-09-01 03:41:02.357000 | 442.389282226563
2020-09-01 04:04:32.408000 | 585.518920898438
2020-09-01 04:15:32.449000 | 654.015441894531
2020-09-01 05:04:02.557000 | 953.42529296875
2020-09-01 05:11:32.573000 | 1000.01324462891
2020-09-01 05:12:02.574000 | 3.09936356544495
2020-09-01 06:02:32.686000 | 319.671691894531
2020-09-01 06:09:01.703000 | 360.282806396484
2020-09-01 06:13:02.714000 | 368.174743652344
2020-09-01 06:16:02.721000 | 373.216247558594
2020-09-01 06:17:02.707000 | 381.340362548828
2020-09-01 06:18:32.713000 | 383.075134277344
2020-09-01 10:18:33.255000 | 384.034271240234
2020-09-01 10:21:03.260000 | 401.569702148438
2020-09-01 10:52:33.315000 | 651.609252929688
2020-09-01 10:54:03.318000 | 653.385314941406
2020-09-01 14:54:03.898000 | 654.36767578125
2020-09-01 14:56:03.902000 | 668.088439941406
2020-09-01 15:28:03.973000 | 922.477783203125
2020-09-01 15:29:33.976000 | 924.231750488281
2020-09-01 19:29:34.509000 | 925.020690917969
2020-09-01 19:32:04.514000 | 942.639587402344
2020-09-01 19:39:04.531000 | 998.196594238281
2020-09-01 19:39:34.532000 | 2.15320706367493
2020-09-01 20:03:34.583000 | 193.247116088867
2020-09-01 20:05:04.588000 | 195.05583190918
2020-09-02 00:05:05.104000 | 196.043395996094
2020-09-02 00:07:05.109000 | 209.730590820313
2020-09-02 00:39:05.165000 | 464.772430419922
2020-09-02 00:40:35.168000 | 466.624114990234
2020-09-02 02:30:05.444000 | 467.273284912109
2020-09-02 02:31:05.446000 | 471.907440185547
2020-09-02 02:34:35.453000 | 497.817932128906
2020-09-02 02:48:35.465000 | 527.336853027344
2020-09-02 02:55:05.474000 | 565.77197265625
2020-09-02 03:38:05.593000 | 830.579406738281
2020-09-02 04:04:35.653000 | 997.686157226563
2020-09-02 04:05:05.655000 | 0.829764604568481
2020-09-02 05:09:05.778000 | 404.721282958984
2020-09-02 06:27:35.956000 | 895.378845214844
2020-09-02 06:34:35.970000 | 907.222412109375
2020-09-02 06:35:35.973000 | 915.160827636719
2020-09-02 06:37:05.976000 | 917.126159667969
2020-09-02 10:37:06.555000 | 917.847473144531
2020-09-02 10:38:36.558000 | 927.435974121094
2020-09-02 10:47:36.572000 | 998.373474121094
2020-09-02 10:48:06.573000 | 2.29338359832764
2020-09-02 11:11:06.617000 | 184.965133666992
2020-09-02 11:12:36.621000 | 186.950592041016
2020-09-02 14:42:37.117000 | 187.629516601563
2020-09-02 14:43:37.118000 | 192.408721923828
2020-09-02 15:17:37.180000 | 462.393005371094
2020-09-02 15:18:37.182000 | 465.375244140625
2020-09-02 19:19:07.746000 | 466.418731689453
2020-09-02 19:20:07.748000 | 471.239471435547
2020-09-02 19:53:07.822000 | 733.456726074219
2020-09-02 19:54:07.825000 | 736.405456542969
2020-09-02 23:54:38.402000 | 737.257141113281
2020-09-02 23:55:38.403000 | 741.990661621094
Spreadsheet: 63579d1264469805-checkbox-checkbox-dummy-file
Sheet: CF

BEFORE
Category | Action | Target Date | Priority | Notes: Projected revenue gain & cost, risks, progres/ sales to date. | Check Boxes
GV | Write an dummy Action List for ExcelForum.com | 2010-01-22 00:00:00 | A |  | 1
VN | Watch [NAME] Panda | 2010-01-25 00:00:00 | A
TF | Blind nearby badguys with your awesomeness | 2010-01-26 00:00:00 | A |  | 1
GV | Learn the [NAME] fingerhold | 2010-01-27 00:00:00 | A
TF | SKADOOSH! | 2010-01-29 00:00:00 | A
AFTER
Category | Action | Target Date | Priority | Notes: Projected revenue gain & cost, risks, progres/ sales to date. | Check Boxes
GV | Write an dummy Action List for ExcelForum.com | 2010-01-22 00:00:00 | A |  | 1
VN | Watch [NAME] Panda | 2010-01-25 00:00:00 | A | Best enjoyed with a bowl of cereal.
TF | Blind nearby badguys with your awesomeness | 2010-01-26 00:00:00 | A
GV | Learn the [NAME] fingerhold | 2010-01-27 00:00:00 | A |  | 1
TF | SKADOOSH! | 2010-01-29 00:00:00 | A
Spreadsheet: 874778d1721297439-pulling-specific-lines-from-a-list-based-on-a-cell-value-terminal-id-sample
Sheet: 06524883

Transaction date | Transaction time | Terminal ID | Transaction type | Currency | Transaction amount | Reconciled
2024-07-12 00:00:00 | 11:59:52 | 06524883 | Sale | GBP | 59
2024-07-11 00:00:00 | 16:39:00 | 06524883 | Sale | GBP | 95
2024-07-09 00:00:00 | 14:31:00 | 06524883 | Sale | GBP | 49 | Yes
2024-07-04 00:00:00 | 12:09:24 | 06524883 | Sale | GBP | 85 | Yes
2024-07-03 00:00:00 | 14:07:18 | 06524883 | Sale | GBP | 49 | Yes
2024-07-03 00:00:00 | 12:13:27 | 06524883 | Sale | GBP | 59 | Yes
2024-07-02 00:00:00 | 18:28:11 | 06524883 | Sale | GBP | 49 | Yes
Spreadsheet: 726700d1617378013-simple-subtract-time-not-working-clock-subtraction
Sheet: Sheet1

Start | Stop | Elapsed
7:35 | 7:56
11:53 | 12:09
5:49 | 6:13
8:41 | 9:39
3:47 | 5:23
6:49 | 7:14
6:39 | 7:06
12:36 | 12:52
5:40 | 5:52
6:52 | 7:53
9:21 | 9:31
11:07 | 11:18
13:42 | 13:57
15:06 | 16:15
6:09 | 7:13
7:57 | 8:16
10:27 | 10:45
14:10 | 14:44
18:07 | 18:36
Spreadsheet: 67345d1267978508-category-calculations-sample
Sheet: Daily Spending

Daily Spending
Date | Transaction Type | Description | Amount | Paid By
2010-02-01 00:00:00 | Food | Lunch from Co-Op | 3.88 | Credit Card
2010-02-01 00:00:00 | Travel | Train to Reading | 42.1 | Credit Card |  |  |  | Clothes | Cash
2010-02-01 00:00:00 | General Purchases | [NAME] | 149.77 | Credit Card |  |  |  | Electric | Credit Card
2010-02-02 00:00:00 | Food | Upper Crust | 4.78 | Credit Card |  |  |  | Food | Debit Card
2010-02-03 00:00:00 | Food | Lunch from Co-Op | 4.13 | Credit Card |  |  |  | Fuel | Cheque
2010-02-03 00:00:00 | Fuel | BP Solihull | 51 | Credit Card |  |  |  | Gas
2010-02-04 00:00:00 | General Purchases | Warriors DVD (Play) | 2.99 | Credit Card |  |  |  | General Purchases
2010-02-04 00:00:00 | Food | Lunch from Co-Op | 4.11 | Credit Card |  |  |  | Going Out
2010-02-05 00:00:00 | General Purchases | Sony Style - PS3 Pads | 36 | Credit Card |  |  |  | Groceries
2010-02-05 00:00:00 | Food | Lunch from Co-Op | 3.49 | Credit Card |  |  |  | Gym Membership
2010-02-08 00:00:00 | Fuel | Sainsbury's Petrol | 53 | Credit Card |  |  |  | Insurance
2010-02-08 00:00:00 | Food | Lunch from Co-Op | 3 | Credit Card |  |  |  | Insurance (Home)
2010-02-09 00:00:00 | General Purchases | Sport Relief Donation | 7.52 | Credit Card |  |  |  | Internet
Spreadsheet: 2cab6d4c-22cd-4c65-be5f-f1521e702be0
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Inception Media | 815300010105 | Various | Flight Of Faith | 2010-11-09 | DVD | Family | 9.98 | Y | Available
Inception Media | 815300010082 | Various | Growing The Big One | 2011-09-13 | DVD | Family | 9.99 | Y | Available
Inception Media | 617742220797 | [NAME] | [NAME]: [NAME], A | 2011-06-07 | DVD | Gospel | 19.98 | Y | Available
Inception Media | 617742218794 | Various | Soul Of The Church | 2011-06-07 | DVD | Gospel | 14.98 | Y | Available
Inception Media | 815300011928 | Various | Danger In The Manger | 2013-11-19 | DVD | Christmas | 26.98 | Y | Available
Inception Media | 815300011300 | Various | Junior High Spy | 2013-04-23 | DVD | Video | 26.98 | Y | Available
Inception Media | 815300011720 | Various | Wiener Dog Nationals | 2013-07-02 | DVD | Video | 12.98 | Y | Available
Inception Media | 815300012222 | Various | Abner The Invisible Dog | 2014-03-11 | DVD | Film | 12.98 | Y | Available
Spreadsheet: 809744d1671277484-data-cleansing-query-compare-lookup-return-standard-value-data-cleansing-query
Sheet: Sheet1

 | Current Data Example | DESIRED Result |  | RETURN THIS | For ANY of These
 | [NAME] | Floor 01 |  | Floor 01 | [NAME] | Flr 1 | [NAME] | Flr One | 1 | 1
 | Flr 1 | Floor 01
 | [NAME] | Floor 01
 | Flr One | Floor 01
 | [NAME] | Floor 01
 | [NAME] | Floor 01
 | [NAME] | Floor 01
 | 1 | Floor 01
 | 1 | Floor 01
 | 1 | Floor 01
 | 1 | Floor 01
 | 1 | Floor 01
 | 1 | Floor 01
 | 1 | Floor 01
Spreadsheet: 739253d1625590672-vlookup-help-wildcard-maybe-needed-eh_vlookup
Sheet: Sheet2

 |  | Product Description |  |  |  | Barcode
 |  | KRKLND   BLGCHBRWBTSISC     50 |  |  |  | '[PHONE] | MR K     ALM         SL      6
 |  | MR K     ALM         SL      6 |  |  |  | '[PHONE] | MR K     ANG SNKPK   SL      4
 |  | MR K     ALMN BTNBMN SC      5 |  |  |  | '[PHONE] | MR K     FLAMINGO    SL      6
 |  | MR K     ANG         CC      1 |  |  |  | '[PHONE] | MR K     FRNC FNC    SC      8
 |  | MR K     ANG         SL      6 |  |  |  | '[PHONE] | MR K     HLWNORFNDFNCSC      8
 |  | MR K     ANG SNKPK   SL      2 |  |  |  | '[PHONE] | MR K     HLWTFTRRWHRLSC      6
 |  | MR K     ANG SNKPK   SL      4 |  |  |  | '[PHONE] | MR K     ICD MINC    MP      6
 |  | MR K     ANG SNKPK   SL      6 |  |  |  | '[PHONE] | MR K     ICD MINC    MP      6
 |  | MR K     ANG SNKPK   SL      8 |  |  |  | '[PHONE] | MR K     SLTDCRCHWHRLSC      4
 |  | MR K     ANG SNKPK   SL      9 |  |  |  | '[PHONE]
 |  | MR K     ANG SNKPK   SL     12 |  |  |  | '[PHONE]
 |  | MR K     ANG SNKPK   SL    4+4 |  |  |  | '[PHONE]
 |  | MR K     AP          SFP     6 |  |  |  | '[PHONE]
 |  | MR K     AP          SFP     6 |  |  |  | '[PHONE]
 |  | MR K     AP          SFP     6 |  |  |  | '[PHONE]
 |  | MR K     AP          SFP     6 |  |  |  | '[PHONE]
 |  | MR K     AP          SFP     6 |  |  |  | '[PHONE]
 |  | MR K     AP          SFP     6 |  |  |  | '[PHONE]
 |  | MR K     AP          SFP   6+2 |  |  |  | '[PHONE]
 |  | MR K     AP+BLCRT    SFP     6 |  |  |  | '[PHONE]
 |  | MR K     AP+BLKCRNT  SFP   6+2 |  |  |  | '[PHONE]
 |  | MR K     APL PIE     CC      1 |  |  |  | '[PHONE]
 |  | MR K     APLPRCSTCRMBST      6 |  |  |  | '[PHONE]
 |  | MR K     AST         CC     12 |  |  |  | '[PHONE]
 |  | MR K     AST FT      SFP     6 |  |  |  | '[PHONE]
 |  | MR K     AST JAM     ST      6 |  |  |  | '[PHONE]
 |  | MR K     AST MN BKWL ST      9 |  |  |  | '[PHONE]
 |  | MR K     AST MNI FT  SFP     9 |  |  |  | '[PHONE]
 |  | MR K     AST SPNGMNI ST      9 |  |  |  | '[PHONE]
 |  | MR K     AWSM APL    SL      6 |  |  |  | '[PHONE]
 |  | MR K     BKWL        LT      1 |  |  |  | '[PHONE]
Spreadsheet: 687282d1595077160-looking-to-count-status-based-on-cell-color-count-color
Sheet: Sheet1

 |  |  |  |  |  |  | LOOKING FOR A FORMULA TO CALCULATE BELOW YELLOW PART
 |  | STAFF NO | NAME | START DATE | END DATE | BID TYPE | STATUS? | APPROVED DAYS | REJECTED DAYS | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | 2020-07-03 00:00:00 | 2020-07-04 00:00:00 | 2020-07-05 00:00:00 | 2020-07-06 00:00:00 | 2020-07-07 00:00:00 | 2020-07-08 00:00:00 | 2020-07-09 00:00:00 | 2020-07-10 00:00:00
 |  | 1 | ALEX | 2020-07-01 00:00:00 | 2020-07-05 00:00:00 | PRIMARY | APPROVED | 4 | 0 | L | L | L | L
 |  | 2 | ADAM | 2020-07-04 00:00:00 | 2020-07-05 00:00:00 | PRIMARY | REJECT | 0 | 2 |  |  |  | L | L
 |  | 3 | RON | 2020-07-07 00:00:00 | 2020-07-09 00:00:00 | PRIMARY | REJECT | 0 | 3 |  |  |  |  |  |  | L | L | L
 |  | 4 | RON | 2020-07-04 00:00:00 | 2020-07-05 00:00:00 | [NAME] | PARTIAL | 2 | 1 |  |  |  | L | L | L
 |  |  |  |  |  | 1) Looking For Approved, Reject Or Partial Status In Column H.   Green Color Denotes Approved, Red Is Rejected, And If Both Are Present In One Row Is Partial
 |  |  | 2 ) [NAME] Applied 2 Bids, [NAME] And Secondary
 |  |  | Based On The Color Primary One Should Come As Rejected In Cell H5
 |  |  | And Based On Both Green And Red Color Secondary (Cell H6) Should Come As Partial
 |  | 3) Number of  accepted or rejected bids should be counted in Column I and J respectively based on the color.
Spreadsheet: 843891d1695720406-dyn-arr-fx-for-sub-totals-byrow-book3-21-
Sheet: Sheet1

 | Totals |  |  |  |  | Values
 | S | M | L | XL |  | S | M | L | XL | S | M | L | XL | S | M | L | XL
 |  | 17 | 13 | 20 |  | 7 | 9 | 3 | 3 | 7 | 6 | 6 | 9 | 8 | 2 | 4 | 8
 | 23 | 10 | 16 | 14 |  | 6 | 1 | 2 | 9 | 10 | 5 | 4 | 3 | 7 | 4 | 10 | 2
 | 19 | 11 | 19 | 20 |  | 1 | 5 | 5 | 6 | 9 | 5 | 10 | 8 | 9 | 1 | 4 | 6
 | 19 | 19 | 20 | 16 |  | 9 | 5 | 8 | 5 | 1 | 7 | 5 | 3 | 9 | 7 | 7 | 8
Spreadsheet: 114971d1310630962-automatically-updating-data-from-one-sheet-to-another-june1
Sheet: 8788

Date | Trip Details | Amount | Toll | Other | Party | Payment Yes/N0 | [NAME]
2011-06-01 00:00:00
2011-06-02 00:00:00
2011-06-03 00:00:00
2011-06-04 00:00:00
2011-06-05 00:00:00
2011-06-06 00:00:00
2011-06-07 00:00:00
2011-06-08 00:00:00
2011-06-09 00:00:00
2011-06-10 00:00:00
2011-06-11 00:00:00
2011-06-12 00:00:00
2011-06-13 00:00:00
2011-06-14 00:00:00
2011-06-15 00:00:00
2011-06-16 00:00:00
2011-06-17 00:00:00
2011-06-18 00:00:00 | [NAME]
2011-06-19 00:00:00 | [NAME]
2011-06-20 00:00:00 | [NAME]
2011-06-21 00:00:00
2011-06-22 00:00:00
2011-06-23 00:00:00
2011-06-24 00:00:00
2011-06-25 00:00:00
2011-06-26 00:00:00 | Hill Palace
2011-06-27 00:00:00
2011-06-28 00:00:00
2011-06-29 00:00:00
2011-06-30 00:00:00
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
2011-07-08 00:00:00
2011-07-09 00:00:00
2011-07-10 00:00:00 | Kumarakam
2011-07-11 00:00:00
2011-07-12 00:00:00
2011-07-13 00:00:00
2011-07-14 00:00:00
2011-07-15 00:00:00
2011-07-16 00:00:00
2011-07-17 00:00:00
2011-07-18 00:00:00
2011-07-19 00:00:00
2011-07-20 00:00:00
2011-07-21 00:00:00
2011-07-22 00:00:00
2011-07-23 00:00:00
2011-07-24 00:00:00
2011-07-25 00:00:00
2011-07-26 00:00:00
2011-07-27 00:00:00
2011-07-28 00:00:00
2011-07-29 00:00:00
2011-07-30 00:00:00
2011-07-31 00:00:00
Spreadsheet: benjamin_rogers__1034__Shortlist2
Sheet: PG&E

PG&E GENERATING (USGEN)
Activity/Strategy: | * Develops, constructs, acquires, owns, and operates IPP and cogeneration facilities
 | * Initiates new projects, acquires new interests in projects begun by others, and purchases existing utility and non-utility plants
 | * Uses a variety of fuels, including coal, natural gas, waste coal, hydro and oil, in technologies ranging from combined cycle natural gas to pulverized coal and circulating fluidized-bed combustion
Comments: | * Focus on domestic market
 | * Generally retains a management role in project development and handles siting, permitting, contracting and construction management, plant operations and overall asset management
 | * Currently negotiating rate increases for electricity and gas with California Public Utilities Commission (PUC)
 | * PG&E reported 30 plants in operation, 2 plants in construction, 8500 MW generation portfolio, and more than 9000 MW in development
 | North America |  |  |  |  |  |  |  |  |  |  | North America (Net Equity) |  |  | International (Net Equity)
Summary: | Net Equity (Op & Construction) | Operation |  |  | Construction |  |  | Development |  |  | Operation | Construction | Development | Operation | Construction | Development
 | (MW) | Plants | MW | Net Equity | Plants | MW | Net Equity | Plants | MW | Net Equity | MW | MW | MW | MW | MW | MW
 | 5673.9755 | 18 | 6563 | 5303.9755 | 1 | 370 | 370 | 10 | 8632 | 8632 | 5303.9755 | 370 | 8632 | 0 | 0 | 0
 | Subsidiary of public utility, PG&E Corp.
Company Type :
 | Na
Stock Exchange:
 | Na
[NAME]:
 | PG&E Corp. (traded as PCG in NYSE)
Holding Company:
 | Pacific Gas & Electric, PG&E Energy Trading, PG&E Energy Services, PG&E Gas Transmission
Subsidiary/ Affiliate:
 | www.pgecorp.com
Web Page:
Spreadsheet: 883796d1732516611-returning-1-when-it-should-be-0-rows-unique-filter-function-returning-1-when-it-should-be-0-rows-unique-filter-function
Sheet: Backend

Company | 3 |  |  | Company |  | Department |  | Training Topics |  | Month
Department | 1
Training Topics | 1
Month | 1
Total Participant per month |  |  |  |  |  |  |  |  | Problem:
 |  |  |  |  |  |  |  |  | if I choose the month [NAME], how to show Jan-June?
 |  |  |  |  |  |  |  |  | also how to show the Mar: 0, May: 0, which not on rawdata?
Total topic by skill type
 |  |  | Problem:
 |  |  | if I choose Company Z, Dept ALL, Topics ALL, Month January --> Hardskill 1 which should be 0
 |  |  | if I choose company Z, Dept ANS --> #[NAME]?
Spreadsheet: 790205d1659597697-lookup-the-text-in-one-column-into-other-column-with-criteria-matching-strings-aligw
Sheet: Accouting Data

No | Desc | Memo
344 |  | ID 346 TEST
344
345
345
346
346
346
400
400
400 |  | ID 345 TEST
 |  | ID 344 TEST