tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18490__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-01-23 00:00:00 |  | 352.69 | 5200 | 237.5 | 400
 | 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
 | 2001-01-02 00:00:00 |  | 185 | 800 | 176.58 | 584 | 149.75 | 2900 | 144.12 | 170
 | 2001-01-01 00:00:00 |  |  |  |  |  |  |  | 138.83 | 1790 |  | 175.74 | 2112
 | 2000-12-31 00:00:00 |  |  |  |  |  |  |  | 147.02 | 3015 |  | 150 | 600
 | 2000-12-30 00:00:00 |  | 165.5 | 4000 | 150 | 200 | 154.23 | 1750 | 155.43 | 460
 | 2000-12-29 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 213.59 | 745 | 172.12 | 353
 | 2000-12-28 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 205.42 | 300 | 181.32 | 285
 | 2000-12-27 00:00:00 |  | 396.43 | 2800 | 255 | 200 | 176.08 | 3130 | 186.7 | 684
 | 2000-12-26 00:00:00 |  | 461.25 | 1600 | 442.5 | 0 | 185 | 65 | 200 | 0
 | 2000-12-25 00:00:00 |  |  |  |  |  |  |  | 300 | 600
 | 2000-12-24 00:00:00 |  |  |  |  |  |  |  | 336.11 | 450
 | 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: 883446d1732071680-trying-to-customize-the-excel-template-attendance-record-employee-attendance-record-jul-to-jun-v2
Sheet: Employee Leave Tracker

 | Employee leave tracker
 | Employee name | Start date | End date | Type of leave | Days | Calendar Year
 | Aldayani, [NAME] | 2024-07-01 00:00:00 | 2024-07-05 00:00:00 | Vacation
 | Aldayani, [NAME] | 2024-09-23 00:00:00 | 2024-09-23 00:00:00 | Sick leave
 | [NAME], [NAME] | 2024-07-02 00:00:00 | 2024-07-02 00:00:00 | Sick leave |  |  |  |  |  |  |  | **=DATE(Year(TODAY())+1-1,M,D)
 | Long, [NAME] | 2024-09-30 00:00:00 | 2024-10-04 00:00:00 | Vacation |  |  |  |  |  |  |  | **=[NAME],d)
 | Job, Manna | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 | Vacation
 | Job, Manna | 2024-10-21 00:00:00 | 2024-10-25 00:00:00 | Vacation
 | Ngo, Ivy | 2024-07-05 00:00:00 | 2024-07-08 00:00:00 | Vacation
 | Ngo, Ivy | 2024-09-23 00:00:00 | 2024-09-23 00:00:00 | Sick leave
Spreadsheet: larry_campbell__20984__PCB Graphs
Sheet: 84.10A

Sample location |  |  | Date collected |  |  | PCB result (ppm) |  | Lab
PGE Mile pt. |  |  | 2000-03-22 00:00:00 |  |  | 21 |  | Sherwood
84.10 A Side |  |  | 2000-07-05 00:00:00 |  |  | 21 |  | Sherwood
 |  |  | 2000-08-09 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-08-23 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-09-06 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-10-04 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-10-18 00:00:00 |  |  | 14 |  | Sherwood
0 data values = ND or  less than a detection limit of 1ppm
Spreadsheet: 680733d1591170724-finding-all-the-non-empty-rows-in-a-column-depending-on-user-input-simple-thebeastslayer-re
Sheet: Sheet1

 |  |  |  |  |  | DATE |  |  | 2020-06-01 00:00:00 |  |  |  | 2020-06-02 00:00:00 |  |  |  | 2020-06-03 00:00:00 |  |  |  | 2020-06-04 00:00:00
[NAME] | 2020-06-01 00:00:00 |  |  |  |  | NAME |  |  | AGE | BLOOD GRP |  |  | AGE | BG |  |  | AGE | BLOOD GRP |  |  | AGE | BG
 |  |  |  |  |  | A |  |  |  |  |  |  | 2 | AB |  |  | 1 | A
NAME | AGE | BG |  |  |  | B |  |  | 5 | A |  |  |  |  |  |  | 2 | B
 |  |  |  |  |  | C |  |  |  |  |  |  | 3 | O
 |  |  |  |  |  | D |  |  | 6 | O |  |  |  |  |  |  |  |  |  |  | 4 | C
 |  |  |  |  |  | E |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | D
 |  |  |  |  |  | F |  |  |  |  |  |  | 5 | B
Output Expected if Cell B2= 02-JUN then
NAME | AGE | BG
A | 2 | AB
C | 3 | O
F | 5 | B
 |  |  | Finding all the non empty rows in a column depending on user input.
 |  |  | I have attached a sample file with expected output. Number of rows may extend upto 200 . I want to extract data based on user input with non blank cells . My target column is age column to find the non empty rows. If age column is blank then blood group will also be blank.
Spreadsheet: 75264d1275855306-finding-data-within-data-finding-data-within-data
Sheet: Sheet1

D48 | Paris
B25 | Baku |  |  |  |  |  |  | A | New York
J33 | Tbilisi |  |  |  |  |  |  | B | Baku
Y12 | Nagasaki |  |  |  |  |  |  | C | Amsterdam
G27 | Luxembourg |  |  |  |  |  |  | D | Paris
I46 | Moscow |  |  |  |  |  |  | E | [NAME]
I22 | Moscow |  |  |  |  |  |  | F | Madrid
R39 | Mexico |  |  |  |  |  |  | G | Luxembourg
[NAME] | Barcelona |  |  |  |  |  |  | H | Barcelona
G44 | Luxembourg |  |  |  |  |  |  | I | Moscow
K48 | Istambul |  |  |  |  |  |  | J | Tbilisi
N32 | [NAME] |  |  |  |  |  |  | K | Istambul
M28 | London |  |  |  |  |  |  | L | [NAME]
H41 | Barcelona |  |  |  |  |  |  | M | London
F12 | Madrid |  |  |  |  |  |  | N | [NAME]
C19 | Amsterdam |  |  |  |  |  |  | O | Oxford
C29 | Amsterdam |  |  |  |  |  |  | P | Petersbourgh
N17 | [NAME] |  |  |  |  |  |  | Q | Los Angeles
W33 | Willisbourgh |  |  |  |  |  |  | R | Mexico
H48 | Barcelona |  |  |  |  |  |  | S | Tegusicalpa
Q47 | Los Angeles |  |  |  |  |  |  | T | [NAME]
J48 | Tbilisi |  |  |  |  |  |  | U | Beijing
H15 | Barcelona |  |  |  |  |  |  | V | Vancouver
U37 | Beijing |  |  |  |  |  |  | W | Willisbourgh
H39 | Barcelona |  |  |  |  |  |  | X | Herosima
C13 | Amsterdam |  |  |  |  |  |  | Y | Nagasaki
G29 | Luxembourg |  |  |  |  |  |  | Z | Zimbabwe
N36 | [NAME]
C46 | Amsterdam
E44 | [NAME]
O19 | Oxford
Spreadsheet: 803102d1667254181-sumproduct-for-2-criteria-example
Sheet: Sheet1

Date | Description 1 | Description 2 | Amount
2022-07-01 00:00:00 | 1 | Foods | 2
2022-07-22 00:00:00 | 1 | Pet | 3
2022-07-22 00:00:00 | 1 | Food | 2
2022-08-15 00:00:00 | 2 | Pets | 3
2022-08-19 00:00:00 | 2 | Food | 3
Column1 | Criteria 1 | [NAME] | [NAME]
July | 1 | Food |  |  |  | Q1 | If there is a null answer for one crieria (e.g. there were no food purchases in a month), how do just ignore it, rather than get a zero answer (as it is [NAME] for food)?
August | 2 | Pet* |  |  |  | Q2 | I want to sum ALL descriptions where they are single or plural. Using * e.g. Pet* didn't work for me. How do I do this?
Spreadsheet: john_griffith__16135__1_24_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HU G2 | 56 | 200 | 275 | 42.7 | 58.8 | 1.79 | 2002-01-24 10:46:00
 | [NAME] | 57 | 625 | 725 | 46.6 | 54 | 1.8 | 2002-01-24 10:46:00
 | [NAME] | 64 | 950 | 1050 | 46.2 | 51.1 | 1.96 | 2002-01-24 10:46:00
 | [NAME] | 65 | 1125 | 1225 | 43.9 | 47.9 | 1.88 | 2002-01-24 10:46:00
 | [NAME] | 65 | 1275 | 1375 | 42.9 | 46.2 | 1.82 | 2002-01-24 10:46:00
 | HU N2 | 64 | 1340 | 1450 | 41.5 | 44.9 | 1.74 | 2002-01-24 10:46:00
 | [NAME] | 63 | 1400 | 1500 | 40.3 | 43.2 | 1.65 | 2002-01-24 10:46:00
 | HU U2 | 61 | 1380 | 1500 | 38 | 41.3 | 1.52 | 2002-01-24 10:46:00
 | [NAME] | 59 | 1375 | 1550 | 36.9 | 41.6 | 1.46 | 2002-01-24 10:46:00
 | [NAME] |  |  |  | 35.9 | 39.8 | 1.36 | 2002-01-22 15:03:00
 | [NAME] |  |  |  | 35.4 | 40.3 | 1.4 | 2001-11-29 15:00:00
 | HU F3 |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU H3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 046c2dc0-2670-42bd-89fc-5c4ce973d942
Sheet: Sheet1

Artist | Title | SubTitle | CatalogNumber | Category | Discs | [NAME] | Label | RetailPrice | UPC
VPI | Single Motor/ Flywheel Assembly |  | S VPI MTRFLY | Turntable Upgrade |  |  | Equipment | 900
VPI | Scoutmaster Turntable Upgrade Package A |  | S SCOUTPKGA | Turntable Upgrade |  |  | Equipment | 150
Spreadsheet: 9a0f5b9c-4ff5-4dce-8cd9-eb074941d4c5
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
DESIP | Test | DESIP | Desipramine, Serum | Desipramine, S | High-Performance Liquid Chromatography (HPLC) | Plain, Red-Top Tube: Red OR |  |  | 3 | mL | Container/Tube: Red top [NAME]: 3 mL Collection Instructions:  1. Draw specimen immediately before next scheduled dose (minimum 12 hours after last dose).  2. Serum must be separated from cells within 2 hours of draw. | 1.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | Therapeutic concentration: 100-300 ng/mL Toxic concentration: > or =300 ng/mL Note: Therapeutic ranges are for specimens drawn at trough (ie, immediately before next scheduled dose). Levels may be elevated in non-trough specimens. | Monday through Saturday; Varies | 2 days | 4 days | 1 | 80160 |  |  |  |  | Rochester
DESIP | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
DESIP | Result | 81854 | Desipramine, S | Desipramine, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3531-1
Spreadsheet: darrell_schoolcraft__7638__imball0201
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 5553 | 5741 | 1041 | 1125 | 1062 | 872 | 1490 | 1123
2 | 5431 | 5741 | 815 | 1125 | 1031 | 872 | 1504 | 1123
3 | 5364 | 5741 | 762 | 1125 | 986 | 872 | 1644 | 1123
4 | 3429 | 5741 | 400 | 1125 | 953 | 872 | 1516 | 1123
5 | 5207 | 5741 |  | 1125 | 927 | 872 | 1465 | 1123
6 | 5669 | 5741 | 358 | 1125 | 921 | 872 | 1438 | 1123
7 | 6151 | 5741 |  | 1125 | 821 | 872 | 1413 | 1123
8 | 6131 | 5741 | 678 | 1125 | 1002 | 872 | 1398 | 1123
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  | 406899.92
2002-01-08 00:00:00
CBS Volume
 |  |  | 166968
Spreadsheet: 720371d1614120213-formula-curve-workbook3
Sheet: Sheet1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 93d7ba5d-3d01-45f9-8ff0-bd2387b4bb1a
Sheet: Budget Adjustment

BUDGET ADJUSTMENT
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  | Approval Deadline |  |  | Reason
HEDFC Property Maintenance Ordinance |  |  |  |  | Mowing, utility and other maintenance costs
 |  |  |  |  | associated with HEDFC properties.
Details |  |  |  |  | Department, Program, or Accounts Affected
Reason for Adjustment |  |  |  |  | Sponsor
 |  |  |  |  | From/Transferor(s) or Fund Title(s)
 |  |  |  |  | 11-1000-179990-619960
 |  |  |  |  | To/Transferee(s) or [NAME])
 |  |  |  |  | 1000-552266
 |  |  |  |  | Policy / Program Impact
 |  |  |  |  | Policy or Program | No | Yes
 |  |  |  |  | Emphasis Change
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Council Committee Actions
 |  |  |  |  | Do Pass |  | Hold
 |  |  |  |  | Do Pass (as amended) |  | w/o Recommendation
 |  |  |  |  | Committee Sub. |  | Do Not Pass
 |  |  |  |  | Fact Sheet prepared by: |  | Date
 |  |  |  |  | [NAME] |  | 2011-01-31 00:00:00
 |  |  |  |  | Fact Sheet reviewed by: |  | Date
 |  |  |  |  | Reference Numbers
Spreadsheet: 759332d1639496626-automatically-copy-data-into-summary-summary-example
Sheet: Sheet1

 |  | [NAME] range |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summary
 |  | Date | Name |  |  |  |  | Score |  |  |  |  | Chit |  |  |  |  |  | Shift | Date | Chit | Score
 |  |  | [NAME] | Here are details that are irrelevant to the |  |  |  |  | All other cell content can be ignored
 |  |  | [NAME] | summary. Only C5, D5, I5 and N5 go |  |  |  |  |  |  |  |  |  | Data is entered daily into the detail
 |  | 2021-01-04 00:00:00 | [NAME] | into the summary. |  |  |  | 2614.75 |  |  |  |  | 73 | range, left.
 |  |  | [NAME] | Here are details that are irrelevant to the |  |  |  |  |  |  |  |  |  | How to automatically add new cell
 |  |  | [NAME] | summary. Only C9, D9, I9 and N9 go |  |  |  |  |  |  |  |  |  | content from the detail range (left)
 |  |  | [NAME] | into the summary. |  |  |  |  |  |  |  |  |  | into the summary (right)?
 |  | 2021-01-12 00:00:00 | [NAME] |  |  |  |  | 1899.18 |  |  |  |  | 74
 |  |  | [NAME]
 |  | 2022-04-01 00:00:00 | [NAME] |  |  |  |  | 1899.18 |  |  |  |  | 1
Spreadsheet: 172909fb-bf08-42ea-9c8a-c275f0289967
Sheet: Ethnicity - Fall Caucasian

Return to Contents
Ethnicity - Caucasian
 |  |  |  | UH | UH COMMUNITY COLLEGES
 |  | UH | UH | WEST
 | TOTAL | MĀNOA | HILO | O‘AHU | SUBTOTAL | Hawaii | Honolulu | Kapi‘olani | Kaua‘i | Leeward | Maui | [NAME]
1977 | 9440 | 4304 | 592 | 65 | 4479 | 419 | 718 | 638 | 399 | 1192 | 546 | 567
1978 | 9745 | 4639 | 579 | 72 | 4455 | 378 | 743 | 639 | 365 | 1143 | 597 | 590
1979 | 9840 | 4652 | 491 | 71 | 4626 | 392 | 836 | 648 | 309 | 1133 | 665 | 643
1980 | 10059 | 4608 | 594 | 79 | 4778 | 427 | 758 | 741 | 306 | 1237 | 706 | 603
1981 | 10764 | 5096 | 559 | 114 | 4995 | 380 | 850 | 783 | 351 | 1329 | 687 | 615
1982 | 11394 | 5381 | 558 | 140 | 5315 | 461 | 720 | 936 | 382 | 1322 | 831 | 663
1983 | 10961 | 5322 | 537 | 152 | 4950 | 416 | 688 | 881 | 328 | 1281 | 732 | 624
1984 | 10307 | 4961 | 495 | 158 | 4693 | 396 | 610 | 935 | 332 | 1121 | 731 | 568
1985 | 10182 | 4753 | 455 | 151 | 4823 | 427 | 583 | 960 | 342 | 1148 | 721 | 642
1986 | 10201 | 4662 | 521 | 180 | 4838 | 415 | 539 | 1035 | 329 | 1152 | 696 | 672
1987 | 10238 | 4410 | 584 | 180 | 5064 | 438 | 575 | 1078 | 359 | 1281 | 651 | 682
1988 | 10244 | 4415 | 639 | 192 | 4998 | 460 | 556 | 1181 | 327 | 1222 | 658 | 594
1989 | 10317 | 4410 | 751 | 203 | 4953 | 563 | 537 | 1163 | 360 | 1125 | 684 | 521
1990 | 10886 | 4467 | 919 | 191 | 5309 | 523 | 566 | 1235 | 408 | 1149 | 825 | 603
1991 | 11021 | 4445 | 939 | 185 | 5452 | 430 | 555 | 1301 | 436 | 1211 | 891 | 628
1992 | 11527 | 4525 | 1033 | 175 | 5794 | 528 | 629 | 1370 | 446 | 1198 | 986 | 637
1993 | 11410 | 4529 | 1130 | 189 | 5562 | 505 | 669 | 1365 | 372 | 1151 | 933 | 567
1994 | 10998 | 4342 | 961 | 209 | 5486 | 577 | 627 | 1297 | 429 | 1012 | 985 | 559
1995 | 10309 | 4243 | 896 | 198 | 4972 | 573 | 565 | 1162 | 372 | 914 | 907 | 479
Note: Data may not match [NAME] reports due to changes in enrollment counting methodology.
Spreadsheet: 269162d1380997924-if-then-condition-met-then-copy-content-of-cells-into-anther-sheet-1billable-nonbillabletime
Sheet: Daily Time

 | Billable Time |  |  |  |  |  | Non-Billed Time
 |  | Start | End | C/M | To Bill |  |  | Start | End | C/M
 |  | 08:00:00 | 08:50:00 |  |  |  |  | 11:00:00 | 12:00:00
 |  | 09:00:00 | 09:10:00 |  |  |  |  | 15:20:00 | 16:40:00
 |  | 09:35:00 | 10:50:00
 |  | 14:00:00 | 15:00:00
 | Date |  |  |  |  |  | Date
 | Oct 1 | Total: Billable |  |  |  |  | Oct 1 | Total: Non-Billable
Increments
Up to 6 min= | .1
7-12 min= | .2
13-18 min= | .3
19-24 min= | .4
25-30 min= | .5
31-36 min= | .6
37-42 min= | .7
43-48 min= | .8
49-54 min= | .9
55-60 min= | 1
Spreadsheet: 215212d1361306301-add-increment-identifier-to-unique-values-book4
Sheet: Sheet1

Sports | Sports 1 | Sports 2
Food & Nutrition | Food & Nutrition 1 | Food & Nutrition 2
Food & Nutrition | Food & Nutrition 2 | Food & Nutrition 3
Health & Fitness | Health & Fitness 1 | Health & Fitness 2
Food & Nutrition | Food & Nutrition 3 | Food & Nutrition 4
Food & Nutrition | Food & Nutrition 4 | Food & Nutrition 5
Food & Nutrition | Food & Nutrition 5 | Food & Nutrition 6
Food & Nutrition | Food & Nutrition 6 | Food & Nutrition 7
Food & Nutrition | Food & Nutrition 7 | Food & Nutrition 8
Food & Nutrition | Food & Nutrition 8 | Food & Nutrition 9
Food & Nutrition | Food & Nutrition 9 | Food & Nutrition 10
Food & Nutrition | Food & Nutrition 10 | Food & Nutrition 11
Food & Nutrition | Food & Nutrition 11 | Food & Nutrition 12
Food & Nutrition | Food & Nutrition 12 | Food & Nutrition 13
Food & Nutrition | Food & Nutrition 13 | Food & Nutrition 14
Sports | Sports 2 | Sports 3
Sports | Sports 3 | Sports 4
Sports | Sports 4 | Sports 5
Spreadsheet: 89514d1289302556-how-to-get-div-0-to-show-as-zero-averagesforum
Sheet: Agent 4

Agent Name: | 0
 | Monday | Tuesday | Wednesday | Thursday | Friday | Average | Sum
PNC | 0 | 0 | 0 | 0 | 22 | 22 | 22
CONFLICTS | 0 | 0 | 0 | 0 | 0 | #N/A | 0
ID'S | 0 | 0 | 0 | 0 | 0 | #N/A | 0
ISA | 0 | 124 | 124 | 120 | 28 | 99 | 396
Spreadsheet: 674537d1587901009-need-formula-to-post-payments-with-different-dates-frequency-than-column-headers-date-range
Sheet: CASH FLOW FORECAST

Each Payment= | 500
 | Year | 2019 | 2019 | 2019 | 2019 | 2019-2020 | 2020 | 2020 | 2020 | 2020 | 2020
 | Date: FROM | 2019-11-01 00:00:00 | 2019-11-15 00:00:00 | 2019-11-29 00:00:00 | 2019-12-13 00:00:00 | 2019-12-27 00:00:00 | 2020-01-10 00:00:00 | 2020-01-24 00:00:00 | 2020-02-07 00:00:00 | 2020-02-21 00:00:00 | 2020-03-06 00:00:00
 | TO Date | 2019-11-14 00:00:00 | 2019-11-28 00:00:00 | 2019-12-12 00:00:00 | 2019-12-26 00:00:00 | 2020-01-09 00:00:00 | 2020-01-23 00:00:00 | 2020-02-06 00:00:00 | 2020-02-20 00:00:00 | 2020-03-05 00:00:00 | 2020-03-19 00:00:00
Pay Frequency | Start Date
Weekly | 2019-12-02 00:00:00
Bi-Weekly | 2019-12-02 00:00:00
Monthly | 2019-12-02 00:00:00
[NAME] | 2019-12-02 00:00:00 |  |  |  |  |  |  |  |  |  |  | <<<Not working
Quarterly | 2019-12-02 00:00:00
Spreadsheet: eric_saibi__9765__012302R
Sheet: Pittsburg 02

Owner Name |  | Mirant California LLC
Station Name |  | Pittsburg Power Station
Unit Name |  | Pittsburg 02
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Natural Gas
Capacity |  | 156 MW
Start Date |  | 2002-01-11 00:00:00
End Date |  | 2002-01-28 00:00:00
Prv. Start Date |  | 2002-01-11 00:00:00
Prv. End Date |  | 2002-01-22 00:00:00
Comments |  | Multiple tube leak repairs
SIC |  | 4931
Plant ID |  | 1507901
Unit ID |  | 1004728
Outage ID |  | 19485
Spreadsheet: 478868d1473122240-display-last-10-games-form-win-draw-loss-ef969_league
Sheet: League

# | Teams | P | W | D | L | GA | GF | G +/- | Pnts
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 139568d1328304051-select-and-display-a-list-of-values-based-on-a-criteria-display-a-list-of-values-based-on-a-criteria
Sheet: Sheet1

Column 1 | Column 2
A1 | B1
A2 | B2
A1 | B3
A3 | B4
A3 | B1
A1 | B2
A2 | B5
Output Format
Spreadsheet: 264716d1378958840-possible-to-auto-populate-the-data-that-i-wanted-from-a-main-list-to-specific-template-excelforum
Sheet: Sample Main List

P/MI Recommendation | Perno | Full Name | Position | JG | Current Title
 | 11111 | aaa | zzz | 1 | zzz
 | 22222 | bbb | yyy | 2 | yyy
P | 33333 | [NAME] | www | 3 | www
 | 44444 | ddd | xxx | 4 | xxx
 | 55555 | eee | vvv | 5 | vvv
 | 66666 | [NAME] | uuu | 6 | uuu
P | 77777 | ggg | ttt | 7 | ttt
 | 88888 | hhh | sss | 8 | sss
 | 99999 | iii | rrr | 9 | rrr
Spreadsheet: 758186d1638728202-count-identical-patches-of-digits-vertically-book1
Sheet: Sheet1

 | Scenario 1 |  | Scenario 2
A
B
C
C
C
A
B
B
A
B
B
B
Spreadsheet: michelle_lokay__26699__imball0112
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 6802 | 5488 |  |  | 1020 | 1011 | 1891 | 1414
2 | 6013 | 5488 |  |  | 1005 | 1011 | 577 | 1414
3 | 5928 | 5488 |  |  | 2066 | 1011 | 1908 | 1414
4 | 6177 | 5488 |  |  | 1045 | 856 | 1668 | 1414
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  | 423029
2001-12-04 00:00:00
CBS Volume
 |  |  | 174129
Spreadsheet: 30549d1226074155-lookup-value-based-on-if-daddy_lookup
Sheet: Sheet1

 | Dog | Cat | Apple
 | 1 | 3 | 5
 | 3 | 5 | 7
 | MIX1
X | 965 | 580 | 658
Y | 568 | 432 | 745
Z | 325 | 486 | 423
 | MIX2
X | 220 | 256 | 856
Y | 623 | 246 | 875
Z | 260 | 456 | 623
 | MIX3
X | 658 | 756 | 985
Y | 123 | 732 | 432
Z | 638 | 754 | 231
 | ref1 | ref2 | ref3 | Result
 | 6 | MIX2 | Y | 875
Spreadsheet: 728359d1618415398-get-total-sum-based-on-dates-book1
Sheet: Activity

 |  |  | Mo1 | Mo2 | Mo3 | Mo4 | Mo5 | Mo6 | Mo7 | Mo8 | Mo9 | Mo10 | Mo11 | Mo12
 |  | income | 600 | 599 | 200
 |  |  | Month 1 is the first earliest date entered in Data tab
Spreadsheet: 765722d1643548181-how-to-average-sales-data-based-on-a-matching-date-bh-performance-tracker-january-copy-22
Sheet: Core Tracking

Sales Rep | Year | Vehicle | Client | Counter? | Status |  | RDR Date | Del Date | Total RDR
 |  |  |  | Yes
 |  |  |  | Yes
 |  |  |  | Yes |  |  | 2022-01-06 00:00:00
 |  |  |  | Yes
 |  |  |  | Yes |  |  | 2022-01-13 00:00:00
 |  |  |  | Yes
 |  |  |  |  |  |  | 2022-01-13 00:00:00 | BLANKJ NVIS PRINTED
 |  |  |  | Yes
 |  |  |  | Yes |  |  | 2022-01-19 00:00:00
 |  |  |  | Yes
 |  |  |  | Yes
 |  |  |  | Yes
 |  |  |  |  |  |  |  | BLANKJ NVIS PRINTED
 |  |  |  | Yes
 |  |  |  | Yes |  |  |  |  |  | HACC DEMO / Advanced Registrations / SLC's
 |  |  |  |  |  |  |  |  |  | YEAR | MODEL | STOCK# | Date | Counter?
 |  |  |  | Yes |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  | Yes |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  | yes |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  | Yes |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  | Yes |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  | Yes |  |  |  |  |  |  |  | ferri  ant find on the sheet
 |  |  |  | Yes
 |  |  |  | Yes |  |  | 2022-01-11 00:00:00
 |  |  |  | Yes |  |  | 2022-01-13 00:00:00
 |  |  |  | Yes |  |  | 2022-01-13 00:00:00
 |  |  |  | Yes |  |  | 2022-01-13 00:00:00
 |  |  |  | Yes
 |  |  |  | Yes
 |  |  |  | Yes
 |  |  |  | Yes
 |  |  |  | Yes
 |  |  |  |  |  |  |  | blank nvis printed
 |  |  |  |  |  |  |  | blank nvis printed
Spreadsheet: 271328d1381914320-countifs-a-b-c-or-d-0a1ab-testing-stats-master-1
Sheet: Data

Date | Country | Promotion | Link | Platform | Text A |  | Text B |  | Winner
 |  |  |  |  | Type |  | Type
2013-07-27 00:00:00 | Canada | [NAME] | http://www.goo.gl/2EsgFY | Android | Historic | 4 | Quotation | 2
2013-07-05 00:00:00 | Canada | Book of Heroes | http://www.goo.gl/8rJ97p | Android | Geek Culture | 2 | AppStore Rating | 7