tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7339__imball0203
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  | San Juan
1 | 341465 | 329748 |  | 15605 | 36925 | 36557 | 171258 | 176277 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
2 | 333969 | 323101 |  | 10827 | 32325 | 36557 | 128578 | 132874 |  |  |  | [NAME] |  |  | -34361 |  | 25006
3 | 329682 | 320457 |  | 15442 | 35751 | 36557 | 144515 | 142776 |  |  |  | 2000-12-01 00:00:00 | 19698194 | 19662410 |  | 7.95
4 | 342762 | 331995 |  | 15281 | 37608 | 36557 | 142892 | 142891 |  |  |  | 2001-01-01 00:00:00 | 18949781 | 18975457 |  | 8.1
5 | 356704 | 341499 |  | 14075 | 42720 | 36557 | 154730 | 152625 |  |  |  | 2001-02-01 00:00:00 | 15256233 | 15290953 |  | 5.61
6 | 347396 | 339399 |  | 8714 | 42100 | 36557 | 137236 | 137167 |  |  |  | 2001-03-01 00:00:00 | 17049350 | 17089226 |  | 4.87
7 | 311632 | 306676 |  | 5665 | 40058 | 36557 | 142439 | 141867 |  |  |  | 2001-04-01 00:00:00 | 17652369 | 17743987 |  | 4.62
8 | 324740 | 325588 |  | 5802 | 36491 | 36557 | 142898 | 143630 |  |  |  | 2001-05-01 00:00:00 | 16124989 | 16282021 |  | 3.44
9 | 277846 | 274739 |  | 2164 | 33031 | 36557 | 125215 | 121176 |  |  |  | 2001-06-01 00:00:00 | 15928675 | 15936227 |  | 2.58
10 | 293086 | 284913 |  | 4532 | 27174 | 36557 | 127095 | 131638 |  |  |  | 2001-07-01 00:00:00 | 16669639 | 16693576 |  | 2.45
11 | 290783 | 285199 |  | 4298 | 39107 | 36557 | 131827 | 131638 |  |  |  | 2001-08-01 00:00:00 | 17850737 | 17815859 |  | 2.61
12 | 300479 | 288799 |  | 3530 | 35094 | 36557 | 132563 | 151638 |  |  |  | 2001-09-01 00:00:00 | 16552948 | 16508018 |  | 1.73
13 | 305620 | 291299 |  | 6874 | 35761 | 36557 | 129035 | 132597 |  |  |  | 2001-10-01 00:00:00 | 17924814 | 17872479 |  | 2.06
14 | 299448 | 313299 |  |  | 36591 | 36557 | 126552 | 137775 |  |  |  | 2001-11-01 00:00:00 |  |  |  | 1.98
15 | 295747 | 315231 |  | 4227 | 34405 | 36498 | 112796 | 129297 |  |  |  | 2001-12-04 00:00:00
16 | 263231 | 255053 |  | 3809 | 35273 | 35958 | 115231 | 120738
17 | 255722 | 255293 |  |  | 37832 | 39583 | 131257 | 129496
18
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.98
20 |  |  |  |  |  |  |  |  |  |  |  |  | 1378106 | 1316146
21 |  |  |  |  |  |  |  |  |  |  |  |  | 9216070 | 9272400
22 |  |  |  |  |  |  |  |  |  |  |  |  | 3546065 | 3512740
23 |  |  |  |  |  |  |  |  |  |  |  |  | 1623705 | 1620245
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  |  |  |  |  | 0
2002-03-17 00:00:00
CBS Dollars
 |  |  | 84461
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
 |  |  | 2444.99
 |  |  | 250
Spreadsheet: a984cf02-7510-4d84-b18e-4f9086984606
Sheet: TTM Recon Q3FY11

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations - Trailing Twelve Months (TTM)
(in millions, except per share data)
 | Trailing Twelve Months Ended December 31, 2010
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on licensed intellectual property commitment (COGS) |  | Loss on Strategic Investments |  | Restructuring Charges |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 3478 |  | 0 |  | 205 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 3683
Cost of goods sold | 1469 |  | -11 |  | 0 |  | 2 |  | 0 |  | 0 |  | -3 |  | 0 |  | 1457
Gross profit | 2009 |  | 11 |  | 205 |  | -2 |  | 0 |  | 0 |  | 3 |  | 0 |  | 2226
Operating expenses:
Marketing and sales | 724 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -20 |  | 0 |  | 704
General and administrative | 305 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -41 |  | 0 |  | 264
Research and development | 1136 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -114 |  | 0 |  | 1022
Acquisition-related contingent consideration | -23 |  | 23 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 59 |  | -59 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring charges | 182 |  | 0 |  | 0 |  | 0 |  | 0 |  | -182 |  | 0 |  | 0 |  | 0
Total operating expenses | 2383 |  | -36 |  | 0 |  | 0 |  | 0 |  | -182 |  | -175 |  | 0 |  | 1990
Operating income (loss) | -374 |  | 47 |  | 205 |  | -2 |  | 0 |  | 182 |  | 178 |  | 0 |  | 236
Gain on strategic investments | 22 |  | 0 |  | 0 |  | 0 |  | -22 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income, net | 4 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 4
Income (loss) before provison for income taxes | -348 |  | 47 |  | 205 |  | -2 |  | -22 |  | 182 |  | 178 |  | 0 |  | 240
Provision for income taxes | 49 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 18 |  | 67
Net income (loss) | -397 |  | 47 |  | 205 |  | -2 |  | -22 |  | 182 |  | 178 |  | -18 |  | 173
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Basic and diluted | -1.2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  | 0.52
Spreadsheet: kate_symes__18567__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-02 00:00:00 |  | 223.95 | 7600 | 196.25 | 800
 | 2001-02-01 00:00:00 |  | 368.81 | 8400 | 319.17 | 1200 | 507.77 | 2990 | 399.65 | 1410
 | 2001-01-31 00:00:00 |  | 410.67 | 6000 | 330 | 240 | 558.06 | 2700 | 457.58 | 825
 | 2001-01-30 00:00:00 |  | 475 | 3600 | 330 | 200 | 570.15 | 1790 | 441.67 | 900
 | 2001-01-29 00:00:00 |  | 409.94 | 6640 | 387.5 | 0 | 508.72 | 2665 | 432.7 | 925
 | 2001-01-28 00:00:00 |  |  |  |  |  |  |  | 573.46 | 3080 |  | 350 | 600
 | 2001-01-27 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 575 | 1900 | 453.79 | 896
 | 2001-01-26 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 484.63 | 1750 | 475.17 | 757
 | 2001-01-25 00:00:00 |  | 319.3 | 5760 | 300 | 400 | 408.1 | 3642 | 485.29 | 850
 | 2001-01-24 00:00:00 |  | 314.3 | 4560 | 260 | 0 | 466.67 | 1350 | 450 | 600
 | 2001-01-23 00:00:00 |  | 352.69 | 5200 | 237.5 | 400 | 465.24 | 1025 | 237.5 | 0
 | 2001-01-22 00:00:00 |  | 477.5 | 1600 | 325 | 200 | 404.09 | 5165 | 361.14 | 2480
 | 2001-01-21 00:00:00 |  |  |  |  |  |  |  | 475.58 | 3225 |  | 312.5 | 1200
 | 2001-01-20 00:00:00 |  | 600 | 400 | 325 | 0 | 428.07 | 2240 | 404.59 | 1115
 | 2001-01-19 00:00:00 |  | 600 | 400 | 362.5 | 0 | 417.35 | 3625 | 425 | 250
 | 2001-01-18 00:00:00 |  | 479.29 | 5600 | 233.33 | 600 | 475 | 0 | 185 | 225
 | 2001-01-17 00:00:00 |  | 264.55 | 5840 | 196.25 | 800 | 210 | 135 | 250 | 0
 | 2001-01-16 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 450 | 300 | 170 | 235
 | 2001-01-15 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 183.5 | 0 | 165 | 0
 | 2001-01-14 00:00:00 |  |  |  |  |  |  |  | 129.41 | 170 |  | 152.43 | 8400
 | 2001-01-13 00:00:00 |  | 168.69 | 5200 | 154.24 | 3680 | 115 | 33 | 140 | 20
 | 2001-01-12 00:00:00 |  | 176.68 | 10000 | 152.98 | 2080 | 209.62 | 720 | 134.57 | 350
 | 2001-01-11 00:00:00 |  | 176.75 | 9600 | 152.5 | 1680 | 181.82 | 275 | 185 | 50
 | 2001-01-10 00:00:00 |  | 168.05 | 8800 | 150 | 800 | 172.22 | 1360 | 166.03 | 696
 | 2001-01-09 00:00:00 |  | 165.55 | 8000 | 149.11 | 1080 | 175 | 75 | 150 | 65
 | 2001-01-08 00:00:00 |  | 154.06 | 12320 | 139.02 | 2440 | 170.92 | 1100 | 124.59 | 1220
 | 2001-01-07 00:00:00 |  |  |  |  |  |  |  | 120.71 | 2304 |  | 139.02 | 7320
 | 2001-01-06 00:00:00 |  | 146 | 9600 | 142.53 | 3000 | 119.57 | 1585 | 110.85 | 1970
 | 2001-01-05 00:00:00 |  | 146.36 | 10000 | 142.53 | 3000 | 168.87 | 1857 | 148.05 | 1001
 | 2001-01-04 00:00:00 |  | 154.8 | 8000 | 154.29 | 1400 | 172.79 | 3571 | 156.13 | 1435
 | 2001-01-03 00:00:00 |  | 180.29 | 4160 | 172.5 | 800 | 160.85 | 4323 | 147.25 | 922
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 96380d1295797374-sumproduct-issue-sumproduct-2
Sheet: Table2

 |  |  | Jan-10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  | Need to validate - Column M of Test with Column N & Column B & Should return the count
 |  |  | BAU |  |  |  |  |  | 0
 |  |  | Minor |  |  |  |  |  | 0
 |  |  | Standard |  |  |  |  |  | 0
 |  |  | Major |  |  |  |  |  | 0
 |  |  | Emergency |  |  |  |  |  | 0
 |  |  | No Change |  |  |  |  |  | 0
 |  |  | Totals | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: michelle_lokay__26792__imball0203
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -19997 | -19960
2 | -20003 | -19960
3 | -19992 | -19793
4 | -20005 | -19793
5 | -20009 | -19960
6 | -19990 | -19960
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
2002-02-28 00:00:00 |  |  | 0
2002-03-06 00:00:00
CBS Dollars
 |  |  | 0
Spreadsheet: 7dcf57ae-e2e8-45bb-9781-e5b6a2f6cf5e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8216 | 30109 | Christian | Faessler | SUI | 226 | 0:34:19 | 0:01:16 | 4:23:02 | 0:01:25 | 2:07:20 | 1 | 07:07:22
8216 | 63997 | [NAME] | Lang | SUI | 102 | 0:39:25 | 0:01:57 | 4:46:02 | 0:02:14 | 2:28:02 | 2 | 7:57:41
8216 | 60598 | [NAME] | Boderick | NZL | 101 | 0:40:54 | 0:01:37 | 4:50:02 | 0:01:45 | 2:37:07 | 3 | [NAME]
8216 | 53610 | [NAME] | [NAME] | SUI | 103 | 0:45:57 | 0:01:55 | 4:50:05 | 0:03:56 | 2:30:00 | 4 | 8:11:55
8216 | 60600 | Thijs | Van Diepen | NED | 104 | 0:40:24 | 0:01:22 | 5:24:09 | 0:02:16 | 3:15:13 | 5 | 9:23:26
Spreadsheet: 38898d1237080745-referencing-data-set-against-known-good-and-bad-items-shoppingcart
Sheet: Cart

Incoming | OneColumn | Rating | Manual?
Soda | 1 | 1
Crackers | Manual? |  | CHECK
Lettuce | 0 | 0
Bananas | 0 | 0
Apples | 0 | 0
CheezWiz | 1 | 1
Hamburger | 0 | 0
Lard | 1 | 1
Spreadsheet: 710337d1608851861-help-pulling-data-from-a-range-attendance-template
Sheet: Range Totals

 | Range Selection
Employee Name | Beginning | Ending | CI | T | NCNS | Points
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] | January | March |  |  |  |  | <=expected results for this example employee
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Obed Attamah
[NAME]
[NAME]
Keath Grimes
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: lisa_gang__22381__EPMIWE
Sheet: ETS Usernames

Enron North America West (EPMIWE) webTag (ETS) Usernames:
 | Trader | Tagging Username
1 | EPMIWE | cara_semperger
 | EPMIWE | Darren_Cavanaugh
 | EPMIWE | [NAME]
 | EPMIWE | [NAME]
 | EPMIWE | Serena_Bishop
 | EPMIWE | settlements
Spreadsheet: 813942d1674066694-multiple-criteria-conditional-formatting-book4
Sheet: Sheet3

 | ID | Date | Code | Quantity |  |  |  |  | ID | Date | Code | Quantity
 | ABC | 2023-01-04 00:00:00 | Credit | 40 |  | Reference date | 2023-01-04 00:00:00 |  | ABC | 2023-01-04 00:00:00 | Credit | 40
 | ABC | 2023-01-04 00:00:00 | Debit | 41 |  |  |  |  | ABC | 2023-01-04 00:00:00 | Debit | 41
 | ABC | 2022-12-31 00:00:00 | Credit | 40 |  |  |  |  | ABC | 2022-12-31 00:00:00 | Credit | 40
 | ABC | 2022-12-31 00:00:00 | Debit | 41 |  |  |  |  | ABC | 2022-12-31 00:00:00 | Debit | 41
 | ABC | 2022-01-11 00:00:00 | Credit | 40 |  |  |  |  | ABC | 2022-01-11 00:00:00 | Credit | 40
 | ABC | 2022-01-11 00:00:00 | Debit | 41 |  |  |  |  | ABC | 2022-01-11 00:00:00 | Debit | 41
 | DEF | 2023-01-04 00:00:00 | Credit | 50 |  |  |  |  | DEF | 2023-01-04 00:00:00 | Credit | 50
 | DEF | 2023-01-04 00:00:00 | Debit | 50 |  |  |  |  | DEF | 2023-01-04 00:00:00 | Debit | 50
 | DEF | 2022-12-28 00:00:00 | Credit | 90 |  |  |  |  | DEF | 2022-12-28 00:00:00 | Credit | 90
 | DEF | 2022-12-28 00:00:00 | Debit | 93 |  |  |  |  | DEF | 2022-12-28 00:00:00 | Debit | 93
 | GHI | 2023-01-04 00:00:00 | Credit | 50 |  |  |  |  | GHI | 2023-01-04 00:00:00 | Credit | 50
 | GHI | 2022-12-29 00:00:00 | Debit | 89 |  |  |  |  | GHI | 2022-12-29 00:00:00 | Debit | 89
 | GHI | 2022-12-29 00:00:00 | Credit | 50 |  |  |  |  | GHI | 2022-12-29 00:00:00 | Credit | 50
 | GHI | 2022-09-01 00:00:00 | Debit | 78 |  |  |  |  | GHI | 2022-09-01 00:00:00 | Debit | 78
 | JKL | 2023-01-04 00:00:00 | Credit | 50 |  |  |  |  | JKL | 2023-01-04 00:00:00 | Credit | 50
 | JKL | 2023-01-04 00:00:00 | Debit | 60 |  |  |  |  | JKL | 2023-01-04 00:00:00 | Debit | 60
 | JKL | 2022-12-31 00:00:00 | Credit | 75 |  |  |  |  | JKL | 2022-12-31 00:00:00 | Credit | 75
 | JKL | 2022-12-31 00:00:00 | Debit | 35 |  |  |  |  | JKL | 2022-12-31 00:00:00 | Debit | 35
 | JKL | 2022-01-11 00:00:00 | Credit | 50 |  |  |  |  | JKL | 2022-01-11 00:00:00 | Credit | 50
 | JKL | 2022-01-11 00:00:00 | Debit | 60 |  |  |  |  | JKL | 2022-01-11 00:00:00 | Debit | 60
Spreadsheet: 275279d1383430361-need-to-copy-all-data-for-each-week-and-compile-to-one-sheet-for-year-to-date-data-consolodate-weeks-sheets-to-summary-sheet-1-
Sheet: Summary

Date | Employee# | Name | task | # of hour | HIDE
Spreadsheet: 583752d1532622546-conditional-formatting-cell-that-n-book2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hightlight W3 when V3 matches H3:H6500 and W3≠N
 |  |  |  |  |  |  | 317101601 |  |  |  |  |  |  |  |  |  |  |  |  |  | 219107724 | N | Expected result |  |  |  |  |  |  |  |  | 317101601 |  |  |  |  |  |  |  |  |  |  |  |  |  | 219107724 | N
 |  |  |  |  |  |  | 412106286 |  |  |  |  |  |  |  |  |  |  |  |  |  | 315152638 | S |  |  |  |  |  |  |  |  |  | 412106286 |  |  |  |  |  |  |  |  |  |  |  |  |  | 315152638 | S
 |  |  |  |  |  |  | 917178532 |  |  |  |  |  |  |  |  |  |  |  |  |  | 317101601 | S |  |  |  |  |  |  |  |  |  | 917178532 |  |  |  |  |  |  |  |  |  |  |  |  |  | 317101601 | S
 |  |  |  |  |  |  | 315152538 |  |  |  |  |  |  |  |  |  |  |  |  |  | 413106286 | S |  |  |  |  |  |  |  |  |  | 315152538 |  |  |  |  |  |  |  |  |  |  |  |  |  | 413106286 | S
 |  |  |  |  |  |  | 816132470 |  |  |  |  |  |  |  |  |  |  |  |  |  | 417160715 | S |  |  |  |  |  |  |  |  |  | 816132470 |  |  |  |  |  |  |  |  |  |  |  |  |  | 417160715 | S
 |  |  |  |  |  |  | 219107724 |  |  |  |  |  |  |  |  |  |  |  |  |  | 419122036 | S |  |  |  |  |  |  |  |  |  | 219107724 |  |  |  |  |  |  |  |  |  |  |  |  |  | 419122036 | S
 |  |  |  |  |  |  | 618137064 |  |  |  |  |  |  |  |  |  |  |  |  |  | 618104175 | S |  |  |  |  |  |  |  |  |  | 618137064 |  |  |  |  |  |  |  |  |  |  |  |  |  | 618104175 | S
 |  |  |  |  |  |  | 419122036 |  |  |  |  |  |  |  |  |  |  |  |  |  | 618137064 | S |  |  |  |  |  |  |  |  |  | 419122036 |  |  |  |  |  |  |  |  |  |  |  |  |  | 618137064 | S
 |  |  |  |  |  |  | 417169715 |  |  |  |  |  |  |  |  |  |  |  |  |  | 816132470 | S |  |  |  |  |  |  |  |  |  | 417169715 |  |  |  |  |  |  |  |  |  |  |  |  |  | 816132470 | S
 |  |  |  |  |  |  | 618114175 |  |  |  |  |  |  |  |  |  |  |  |  |  | 917178632 | S |  |  |  |  |  |  |  |  |  | 618114175 |  |  |  |  |  |  |  |  |  |  |  |  |  | 917178632 | S
Spreadsheet: 72910d1273606347-first-and-second-place-from-a-data-set-world-cup-tables
Sheet: Knock out

 | The Last 16
 | June 26th 3:00pm |  |  |  |  |  |  | June 26th 7:30pm
 | June 27th 3:00pm |  |  |  |  |  |  | June 27th 7:30pm
 | June 28th 3:00pm |  |  |  |  |  |  | June 28th 7:30pm
 | June 29th 3:00pm |  |  |  |  |  |  | June 29th 7:30pm
 | Quarter Finals
 | July 2nd 3:00pm |  |  |  |  |  |  | July 2nd 7:30pm
 | July 3rd 3:00pm |  |  |  |  |  |  | July 3rd 7:30pm
 | [NAME]
 | July 6th 7:30pm |  |  |  |  |  |  | July 7th 7:30pm
 | Third Place Play-Offs
 | July 10th 7:30pm
 | FINAL
 | July 11th 7:30pm
Spreadsheet: 878874d1726173651-creating-header-from-existing-rows-mezza89-example
Sheet: Sheet1

DISHES | Dishes and their allergen content - July Menu 2024
(Note – Please state the name of the cereal(s) containing gluten* and/or the name of the nut(s)†)
Dishes | Celery | Cereals containing gluten* | Crustaceans | Eggs | Fish | Lupin | Milk | [NAME] | Mustard | Nuts† | Peanuts | Sesame seeds | Soya | [NAME]
White Bread Basket |  | Wheat, Oats |  |  |  |  | ✓
Spreadsheet: richard_sanders__31919__BidOfferIndividualCharts
Sheet: PQ_Pairs

 | Bid-Offer Price Quantity Pairs
 | 1999-05-25 00:00:00
 |  | U |  | U* |  | C |  | C*
 | Hour | P | Q | P | Q | P | Q | P | Q
 | U | Intersection of Unconstrained Supply and Demand Curves
 | U* | Intersection of Shifted Supply and Unconstrained Demand Curve
 | C | Intersection of Constrained Market Clearing Price and Unconstrained Demand Curve
 | C* | Intersection of Constrained Market Clearing Price and Unconstrained Supply Curve
Spreadsheet: 791774d1660582474-calculate-how-many-hours-in-a-time-range-falls-within-a-predef-range-spanning-midnight-battery-time-ans
Sheet: Sheet1

Time | Start | End | Total Hrs | Battery Hrs | FORMULA |  |  |  |  | From | -> | 17:00:00 | (lower)
 |  |  |  |  |  |  |  |  |  | To | -> | 06:00:00 | (upper)
T1 | 17:00:00 | 23:00:00 | 6 | 6 |  |  |  |  |  | Total_Hrs | = | 13 | hrs.
T2 | 18:00:00 | 05:00:00 | 11 | 11
T4 | 00:00:00 | 23:59:00 | 24 | 13
T5 | 10:00:00 | 14:00:00 | 4 | 0
T6 | 18:00:00 | 07:00:00 | 13 | 12
T7 | 01:00:00 | 07:00:00 | 6 | 5
T8 | 14:00:00 | 20:00:00 | 6 | 3
Spreadsheet: 844479d1696261192-counting-the-number-of-matches-from-two-columns-problem-example
Sheet: Sheet1

Data table |  |  | Unique ocurrances |  |  | How many of each are there? | I want to count the number of the unique occurrences that are in the data table
6L | N |  |  | N |  | 1
3L | N |  | 3L | N |  | ?
4L | N |  | 4L | N |  | ?
5L | S |  | 5L | S |  | ?
4L | S |  | 4L | S |  | ?
1L | S |  | 1L | S |  | ?
1L | S
1L | S
3L | N
3L | N
4L | N
5L | S
4L | S
1L | S
1L | S
1L | S
3L | N
3L | N
4L | N
5L | S
4L | S
1L | S
1L | S
1L | S
Spreadsheet: 769501d1645562843-unique-count-average-percentage-and-weekly-breakdown-member-check-ins-average-check-ins-testing-updated
Sheet: Total Members per Age Group

Starting Age | Ending Age | Total Members
13 | 19
20 | 29
30 | 39
40 | 49
50 | 59
60 | 69
70 | 79
80 | 89
90 | 99999
Spreadsheet: 870411d1716927833-sumif-not-returning-correct-cells-example1
Sheet: Sheet2

350243204 | 6 | 4.5
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 2 | 1.5
350243204 | 2 | 1.5
350243204 | 2 | 1.5
350243204 | 1 | 0.75
350243204 | 2 | 1.5
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 3 | 2.25
350243204 | 5 | 3.75
350243204 | 2 | 1.5
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 2 | 1.5
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | #N/A | #N/A
350243204 | #N/A | #N/A
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204 | 1 | 0.75
350243204A | 4 | 3
350243204A | 2 | 1.5
Spreadsheet: 60014d1260534941-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-new-budget-planner1
Sheet: Car Ins Si

Simon Car Insurance
Month | Year | Paymet
January | 2008
February | 2008
March | 2008
April | 2008
May | 2008
June | 2008
July | 2008
August | 2008
September | 2008
October | 2008
November | 2008
December | 2008
January | 2009
February | 2009
March | 2009 | 66.67
April | 2009 | 66.67
May | 2009 | 66.67
June | 2009 | 66.67
July | 2009 | 66.67
August | 2009 | 66.6
September | 2009 | 66.6
October | 2009 | 66.6
November | 2009
December | 2009
January | 2010
February | 2010
March | 2010
April | 2010
May | 2010
June | 2010
July | 2010
August | 2010
September | 2010
October | 2010
November | 2010
December | 2010
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: PSR

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty
P10 HYDRT COCO 12/12Z CN | 10896 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ** Need item activation
P10 HYDRT WTRM 12/12Z CN | 10897
P10 LEAN BODY 12/12Z CN | 10899
P10 MAX ENDURA 12/12Z CN | 10898
PATRIA ORIGINA 12/16Z CN | 10892
PATRIA PINEAPP 12/16Z CN | 10893
PATRIA SF CITR 12/16Z CN | 10894
PATRIA SF GRN 12/16Z CN | 10895
SUEROTIL ALPIN 12/20Z BTL | 10905
SUEROTIL COCON 12/20Z BTL | 10902
SUEROTIL CUCUM 12/20Z BTL | 10904
SUEROTIL PINAP 12/20Z BTL | 10903
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
P10 HYDRT COCO 12/12Z CN | 10896
P10 HYDRT WTRM 12/12Z CN | 10897
P10 LEAN BODY 12/12Z CN | 10899
P10 MAX ENDURA 12/12Z CN | 10898
PATRIA ORIGINA 12/16Z CN | 10892
PATRIA PINEAPP 12/16Z CN | 10893
PATRIA SF CITR 12/16Z CN | 10894
PATRIA SF GRN 12/16Z CN | 10895
SUEROTIL ALPIN 12/20Z BTL | 10905
SUEROTIL COCON 12/20Z BTL | 10902
SUEROTIL CUCUM 12/20Z BTL | 10904
SUEROTIL PINAP 12/20Z BTL | 10903
Spreadsheet: 87430d1287307223-vlookup-formula-vlookup
Sheet: Sheet2

 | File No. | 320
Name: | [NAME]
s.n | Dependent Name | Gender | Birth Date
1 | Raul | Male | 2003-10-15 00:00:00
2 | Nida | Female | 1969-02-07 00:00:00
3
4
5
6
7
8
9
10
Spreadsheet: 767873d1644685652-having-trouble-coming-up-with-combination-lookup-value-based-on-rank-result-2021-auto-update-test
Sheet: TOURNEY3

INDIAN LAKE - May 1st, 2021
GRAND LAKE ST. MARYS - May 2nd, 2021
ANGLER | FISH CT. | WGTS. LBs | BIG BASS | PLACED
 | 8 | 16.32 | 1.87
 | 4 | 6.38 | 0
 | 1 | 1.38 | 0
 | 5 | 9.41 | 2.8
 | 1 | 1.84 | 0
 | 3 | 3.05 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 4 | 5.95 | 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
Spreadsheet: 879021d1726460813-how-to-set-if-formula-in-column-c-as-the-attached-excel-file-excel-help
Sheet: Sheet2

Division | Country | Account Code
Jade | China | Jade CM
Jade | Vietnam | Jade FOB
Jade | Philippines | Jade FOB
Jade | other than China, Vietnam and Philippines | Jade N/A
Madewell | China | Madewell CM
Madewell | Vietnam | Madewell FOB
Madewell | Philippines | Madewell FOB
Madewell | other than China, Vietnam and Philippines | Madewell N/A
How to set "if" formula in column C as the attached excel file ?
Division name is fixed with the name Jade and Madewell
Country name has various country names
when Country is China, it will shows "Jade CM" or "Madewell CM"
When Country is Vietnam or Philippines, it will shows  "Jade FOB" or "Madewell FOB"
When Country is not China, Vietnam or Philippines, it will shows  "Jade N/A" or "Madewell N/A"