tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 775957d1649412366-return-value-from-multiple-sources-return-date-value-aligw
Sheet: Sheet1

Item code | 2022-07-04 00:00:00 | 2022-07-11 00:00:00 | 2022-07-18 00:00:00 | 2022-07-25 00:00:00 | 2022-08-01 00:00:00 | 2022-08-08 00:00:00 | 2022-08-15 00:00:00 | 2022-08-22 00:00:00 | 2022-08-29 00:00:00 | 2022-09-05 00:00:00 | SIW
1 | 0 | 35010 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 0 | 0 | 0 | 0 | 0 | 0 | 25006 | 0 | 0 | 0
3 | 0 | 0 | 0 | 0 | 25006 | 0 | 0 | 0 | 0 | 0
4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25006 | 0
5 | 0 | 0 | 16030 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | 16030 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | 0 | 0 | 0 | 0 | 0 | 18026 | 0 | 0 | 0 | 0
8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20020 | 0 | 0
9 | 0 | 0 | 0 | 0 | 16030 | 0 | 0 | 0 | 0 | 0
10 | 0 | 0 | 0 | 30000 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 5663a481-0426-4502-a1ad-27847dc3f4d3
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
TOBT | Test | TOBT | Tobramycin, Trough, Serum | Tobramycin, Trough, S | Enzyme-Multiplied Immunoassay Technique (EMIT) | Plain, Red-Top Tube: Red OR |  |  | 1 | mL | Collection Container/Tube: Red top  Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions:  1. Draw blood no more than 30 minutes before next scheduled dose. 2. Spin down within 2 hours of draw. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | <2.0 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 2 days | 1 | 80200 |  |  |  |  | Rochester
TOBT | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
TOBT | Result | 81594 | Tobramycin, Trough, S | Tobramycin, Trough, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 797114d1663712117-find-the-coverage-and-return-the-corresponding-value-example
Sheet: Sheet1

 | Coverage1 | Coverage2 | Coverage3 | Coverage4 | Coverage5 | Coverage6 | Coverage7
Start Date
End Date
Return value | A | B | C | D | E | F | G
Test Date | 2021-11-01 00:00:00 | 2022-06-15 00:00:00 | 2023-01-27 00:00:00 | 2023-09-10 00:00:00 | 2024-04-23 00:00:00 | 2024-12-05 00:00:00 | 2025-07-19 00:00:00 | 2026-03-02 00:00:00 | 2026-10-14 00:00:00 | 2027-05-28 00:00:00 | 2028-01-09 00:00:00 | 2028-08-22 00:00:00
Test Result |  |  | A | B | B | C | D | D | E | E | F | G
Spreadsheet: 725706d1616804230-customer-onboarding-schedule-across-months-cumulative-totals-ryanyvr-
Sheet: Sheet1

 |  |  | 2022 | 2023 | 2024
 | Inputs | Retailers Added | 4 | 6 | 10
 |  |  | Schedule
 |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Ongoing
 |  | Retailers | 1 |  |  | 1
 |  | Wholesale Sales |  | 200 | 100 | 40 | 30 | 30 | 30
 |  | Retail Sales |  |  | 50 | 100 | 75 | 30 | 30
 | Hardcoded - needs to be formula based
 |  | [NAME] | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
 |  | [NAME] |  |  |  |  |  | 2 |  |  | 3 |  |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10
 |  | Monthly Wholesale Sales
 |  | Monthly Retail Sales
 |  | Wholesales Sales per Retailer
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | Retail Sales per Retailer
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
Spreadsheet: 647a3375-d506-4c4e-ace5-8c21f77abd78
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6619 | 46850 | [NAME] | [NAME] | USA | 340 | 00:24:18 | 00:03:04 | 01:50:46 | 00:01:39 | 00:41:25 | 1 | 03:01:13
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 8b

Product1 | EUR3 | GBP | [NAME] | USD | AUD | CAD | OTHER | TOTAL
Basis | - | 11 | 18 | 82 | 2 | - | - | 113
Cap/Floor | 13 | 13 | 1 | 227 | - | 1 | - | 255
Debt Option | - | - | - | - | - | - | - | -
Exotic | - | - | - | - | - | - | - | -
Fixed-Fixed | 6 | - | 4 | 9 | - | - | 1 | 20
Fixed-Float | 2028 | 2453 | 1335 | 8399 | 1201 | 1540 | 985 | 17941
FRA | 16 | - | - | 82 | 15 | 14 | 15 | 142
Inflation | 156 | 80 | - | 43 | 26 | - | - | 305
OIS | 19 | 4 | - | 21 | 12 | 18 | 86 | 160
Swaption | 181 | 95 | 73 | 478 | 8 | 17 | 53 | 905
TOTAL | 2419 | 2656 | 1431 | 9341 | 1264 | 1590 | 1140 | 19841
Spreadsheet: 189012d1351064390-how-to-calculate-average-based-on-text-bwct-na-formula
Sheet: Sheet1

1.  WORKING WITH OTHERS
 | Competency and Definition | Rating
 | Exceed Customer Expectations | Exceeds expectation |  |  | Failed
 | Communicate with Others | Exceeds expectation |  |  | Did Not Meet Expectation
 | Demonstrate Team Spirit & Cooperation | Meets Expectation |  |  | Meets Expectation
 | Act with Professionalism & Integrity | Meets Expectation |  |  | Exceeds expectation
 | [NAME] | Meets Expectation |  |  | Outstanding
2.  TAKING RESPONSIBILITY
 | Competency and Definition | Rating
 | Take Ownership | Meets Expectation
 | Learn, Develop, & Adapt to Change | Exceeds expectation
 | Work Independently | Exceeds expectation
 | Manage Time | Meets Expectation
 | Attend to [NAME] | Meets Expectation
3.  DELIVERING RESULTS
 | Competency and Definition | Rating
 | Demonstrate Functional Excellence | Meets Expectation
 |  | Failed
 | Commit to Quality | Meets Expectation
 |  | Failed
 | Follow Policies & Procedures | Exceeds expectation
 |  | Failed
 | Follow Direction | Exceeds expectation
 |  | Failed
 | Multitask | Exceeds expectation
4. [NAME]
 | Competency and Definition | Rating
 | Leadership | Meets Expectation
TOTAL RATING
Spreadsheet: 738247d1624922037-formula-that-returns-a-1-when-text-1st-and-letter-e-in-specified-columns-stock-short-term-comparison-8
Sheet: Sheet1

13c/15c/18c/21c/23c/25c/33c/35c/39c/44c/49c/51c/55c/59c/61c/67c/70c(1 ext 1u/1d,1st of alm [NAME]) |  | 1 ext 1u/1d,1st of alm [NAME] |  |  | 3 |  |  |  |  | D |  |  |  |  |  |  | 13 | 15 | 18 | 21 | 23 | 25 | 33 | 35 | 39 | 44 | 49 | 51 | 55 | 0 | 0 | 1 | 4 | -2 | 0 | 0 | -1 | 3 | 0 | -2 | 0 | 1 | 5 | 0,0,1,4,-2,0,0,-1,3,0,-2,0,1 | 0 | 0 | 1 | 5 | 3 | 3 | 3 | 2 | 5 | 5 | 3 | 3 | 4
12c/14c/18c/23c/28c/30c/34c/38c/40c/46c/50c/54c/59c/61c/65c/68c(1pt 1u/2d,1st alm a3/a5) |  | 1pt 1u/2d,1st alm a3/a5 |  |  | 5 | 2 |  |  |  |  | E |  |  | A |  |  | 12 | 14 | 18 | 23 | 28 | 30 | 34 | 38 | 40 | 46 | 50 | 54 | 59 | -1 | 1 | 1 | -2 | 1 | 0 | 1 | 2 | -2 | 2 | -1 | 0 | 1 | 3 | -1,1,1,-2,1,0,1,2,-2,2,-1,0,1 | -1 | 0 | 1 | -1 | 0 | 0 | 1 | 3 | 1 | 3 | 2 | 2 | 3 | a | b
12c/16c/19c/24c/27c/29c/33c/40c/43c/47c/50c/55c/60c/63c(1pt 1u/2d,1st alm a5/a6) |  | 1pt 1u/2d,1st alm a5/a6 |  |  |  |  |  |  |  |  | E |  |  |  |  |  | 12 | 16 | 19 | 24 | 27 | 39 | 33 | 40 | 43 | 47 | 50 | 55 | 60 | -1 | 1 | 2 | -1 | 0 | 3 | 0 | -2 | 1 | 3 | -1 | 1 | 2 | 6 | -1,1,2,-1,0,3,0,-2,1,3,-1,1,2 | -1 | 0 | 2 | 1 | 1 | 4 | 4 | 2 | 3 | 6 | 5 | 6 | 8
14c/21c/24c/27c/31c/36c/41c/44c/51c/54c/60c/63c/68c/70c(1 sml ext 1u/2d) |  | 1 sml ext 1u/2d |  |  | 4 |  |  |  |  | D |  |  |  |  |  | #[NAME]! | 14 | 21 | 24 | 27 | 31 | 36 | 41 | 44 | 51 | 54 | 60 | 63 | 68 | 1 | 4 | -1 | 0 | 1 | 0 | -1 | 0 | 0 | 0 | 2 | 1 | 0 | 4 | 1,4,-1,0,1,0,-1,0,0,0,2,1,0 | 1 | 5 | 4 | 4 | 5 | 5 | 4 | 4 | 4 | 4 | 6 | 7 | 7
14c/19c/21c/24c/28c/36c/39c/50c/55c/58c/66c/70c(1 ext 1u,2d) |  | 1 ext 1u,2d |  |  | 3 |  |  |  |  |  | E |  |  | A |  | #[NAME]! | 14 | 19 | 21 | 24 | 28 | 36 | 39 | 50 | 55 | 58 | 66 | 70 | 70 | 1 | 2 | 4 | -1 | 1 | 0 | 3 | -1 | 1 | 0 | 0 | 2 | 2 | 10 | 1,2,4,-1,1,0,3,-1,1,0,0,2,2 | 1 | 3 | 7 | 6 | 7 | 7 | 10 | 9 | 10 | 10 | 10 | 12 | 14
13c/18c/20c/25c/28c/32c/34c/37c/41c/49c/58c/63c/69c(1 ext almost solo,1u/5d) |  | 1 ext almost solo,1u/5d |  |  | 3 |  |  |  |  |  | E |  |  | A |  | #[NAME]! | 13 | 18 | 20 | 25 | 28 | 32 | 34 | 37 | 41 | 49 | 58 | 63 | 69 | 0 | 1 | 3 | 0 | 1 | -1 | 1 | 1 | -1 | -2 | 0 | 1 | 1 | 3 | 0,1,3,0,1,-1,1,1,-1,-2,0,1,1 | 0 | 1 | 4 | 4 | 5 | 4 | 5 | 6 | 5 | 3 | 3 | 4 | 5
Spreadsheet: 135580d1326131113-how-to-make-summary-from-many-sheets-students
Sheet: Science

No | Student Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Average
1 | Student1 | 85 | 68 | 38 | 4 | 97 | 39 | 60 | 47 | 92 | 8 | 23 | 47
2 | Student2 | 93 | 78 | 24 | 84 | 86 | 11 | 66 | 96 | 53 | 78 | 83 | 15
3 | Student3 | 8 | 80 | 68 | 36 | 27 | 10 | 3 | 61 | 10 | 15 | 6 | 49
4 | Student4 | 96 | 52 | 20 | 48 | 79 | 35 | 20 | 3 | 60 | 61 | 9 | 7.000000000000001
5 | Student5 | 30 | 60 | 17 | 53 | 59 | 6 | 55.00000000000001 | 94 | 82 | 18 | 80 | 75
6 | Student6 | 20 | 54 | 78 | 73 | 49 | 23 | 89 | 73 | 79 | 21 | 29 | 46
7 | Student7 | 95 | 6 | 33 | 67 | 25 | 91 | 32 | 60 | 32 | 57.99999999999999 | 13 | 74
8 | Student8 | 67 | 90 | 38 | 1 | 91 | 49 | 36 | 57.99999999999999 | 27 | 47 | 45 | 76
9 | Student9 | 30 | 64 | 67 | 1 | 1 | 82 | 72 | 75 | 82 | 60 | 64 | 34
10 | Student10 | 92 | 1 | 39 | 34 | 47 | 9 | 37 | 45 | 33 | 18 | 54 | 96
11 | Student11 | 82 | 13 | 11 | 26 | 75 | 49 | 24 | 93 | 78 | 40 | 88 | 33
12 | Student12 | 66 | 8 | 37 | 42 | 23 | 90 | 55.00000000000001 | 77 | 99 | 26 | 25 | 97
13 | Student13 | 54 | 46 | 68 | 96 | 97 | 12 | 51 | 40 | 72 | 45 | 60 | 74
14 | Student14 | 4 | 42 | 17 | 39 | 90 | 97 | 74 | 12 | 56.99999999999999 | 28 | 38 | 5
15 | Student15 | 66 | 30 | 91 | 61 | 34 | 45 | 17 | 88 | 33 | 83 | 81 | 28
16 | Student16 | 38 | 68 | 64 | 1 | 45 | 56.00000000000001 | 4 | 35 | 75 | 12 | 86 | 40
17 | Student17 | 76 | 60 | 26 | 73 | 19 | 69 | 94 | 28 | 41 | 63 | 93 | 62
18 | Student18 | 19 | 78 | 95 | 79 | 24 | 17 | 56.00000000000001 | 89 | 59 | 33 | 21 | 71
19 | Student19 | 17 | 48 | 31 | 67 | 69 | 41 | 64 | 22 | 59 | 39 | 96 | 17
20 | Student20 | 31 | 40 | 7.000000000000001 | 23 | 23 | 59 | 52 | 96 | 28 | 55.00000000000001 | 75 | 3
Average
Spreadsheet: 122107d1316617137-what-if-scenarios-used-twice-with-an-adding-sum-at-the-end-bookxyz
Sheet: Sheet1

 |  |  |  | 3
 |  |  | yes | 3
 |  |  |  | 1
 |  |  |  | 4
 |  |  |  | 5
 |  |  | yes | 6
 |  |  |  | 3
 |  |  | yes | 3
 |  |  | yes | 1
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 1
 |  |  | yes | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  | yes | 3
 |  |  |  | 3
 |  |  |  | 1
 |  |  |  | 4
 |  |  | yes | 5
 |  |  |  | 6
 |  |  | yes | 3
 |  |  | yes | 3
 |  |  |  | 1
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 3
 |  |  |  | 3
 |  |  | yes | 1
 |  |  |  | 4
 |  |  |  | 5
 |  |  | yes | 6
 |  |  |  | 3
 |  |  |  | 3
 |  |  | yes | 1
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  | yes | 3
 |  |  |  | 3
 |  |  | yes | 1
 |  |  | yes | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 1
 |  |  |  | 4
 |  |  | yes | 5
 |  |  |  | 6
 |  |  |  | 3
 |  |  | yes | 3
 |  |  |  | 1
 |  |  |  | 4
 |  |  | yes | 5
 |  |  |  | 6
 |  |  |  | 3
 |  |  | yes | 3
 |  |  |  | 1
 |  |  |  | 4
 |  |  |  | 5
 |  |  | yes | 6
 |  |  |  | 3
 |  |  | yes | 3
 |  |  | yes | 1
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 1
 |  |  | yes | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 1
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 1
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
Spreadsheet: 704067d1605342373-in-a-summary-sheet-different-ways-sum-up-all-values-as-per-criteria-from-multiple-sheets-sum-up-all-amounts-as-per-different-criterias
Sheet: May

Date | Name | Amount
2020-05-01 00:00:00 | ABC | 100
2020-05-01 00:00:00 | BCD | 20
2020-05-02 00:00:00 | ASD | 145
2020-05-01 00:00:00 | ABC | 100
2020-05-03 00:00:00 | BCD | 20
2020-05-05 00:00:00 | ABV | 65
2020-05-05 00:00:00 | ABV | 25
2020-05-05 00:00:00 | ABV | 145
Spreadsheet: 163849d1340492228-cell-reference-problem-with-offset-and-large-large-5
Sheet: Summary

 | Construction Campaign Call Tracker
 | WeekNumber |  |  |  |  |  |  |  | Top 5 Accounts Called This Week (Starting  Each Monday)
 | 26 |  |  |  |  |  |  |  |  | Account Name | By Revenue ($ million) | By # of Employees
 |  |  |  |  |  |  |  |  | [NAME] | Patmar Developments Limited | 1.19509 | 4
 |  |  |  |  |  |  |  |  |  | Callaway Contracting Inc | 1.19508 | 6
 |  |  |  |  |  |  |  |  |  | Quality Wireline & Cable Inc | 1.19508 | 5
 |  |  |  |  |  |  |  |  |  | K L M Contracting Ltd | 1.19508 | 4
 |  |  |  |  |  |  |  |  |  | [NAME]'s Seismic Ltd | 1.19508 | 10
Spreadsheet: 7f1d2053-7ad4-4a18-b17d-1c0fa7a3aaa0
Sheet: Sheet1

Erneuerungswahl | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
des Gemeindepräsidenten der Gemeinde Mels
(Amtsdauer 2013-2016)
vom 23. September 2012
Kandidatur
Name |  |  |  | *
Vorname |  |  |  | *
[NAME] (m/w)
Geburtsdatum (Tag Monat Jahr)
ggf. Titel |  |  |  | *
[NAME](Nachträgliche Änderungswünsche können nicht [NAME]) |  |  |  | *
[NAME]
PLZ
Ort |  |  |  | *
Heimatort(e) mit Kanton(e)
Partei (Kurzbezeichnung) |  |  |  | *
Unterschrift
Mit der Unterschrift erklärt die [NAME] oder der [NAME] die Zustimmung zur Kandidatur sowie die [NAME] und Richtigkeit der Angaben [NAME]. Für die Angaben massgebend sind die Verhältnisse am [NAME]. |  |  |  | *
Spreadsheet: 147553d1332855002-if-and-vlookup-help-example-2
Sheet: Sheet1

[NAME] | [NAME] | [NAME] | Sup Bookings |  | Vlookup | [NAME] | [NAME] | Sup Bookings
Avon | Lithuanian | 1 |  |  |  | Avon | Lithuanian | 3
Avon | Polish | 1 |  |  |  | Avon | Polish | 13
Avon | Russian | 7 |  |  |  | Avon | Russian | 7
Bedfordshire | Albanian | 14 |  |  |  | Bedfordshire | Albanian | 8
Bedfordshire | Arabic | 63 |  |  |  | Bedfordshire | Arabic | 10
Bedfordshire | Bengali | 24 |  |  |  | Bedfordshire | Bengali | 8
Bedfordshire | Cantonese | 3 |  |  |  | Bedfordshire | Cantonese | 2
Berkshire | Croatian | 13 |  |  |  | Berkshire | Croatian | 2
Berkshire | Czech | 7 |  |  |  | Berkshire | Czech | 20
Berkshire | French | 8 |  |  |  | Berkshire | French | 2
Buckinghamshire | Gujarati | 10 |  |  |  | Buckinghamshire | Gujarati | 9
Buckinghamshire | Hindi | 8 |  |  |  | Buckinghamshire | Cantonese | 24
Buckinghamshire | Hungarian | 2 |  |  |  | Buckinghamshire | Croatian | 1
Cambridgeshire | Indonesian | 2 |  |  |  | Cambridgeshire | Czech | 199
Cambridgeshire | Italian | 20 |  |  |  | Cambridgeshire | French | 42
Cambridgeshire | Kurdish (Sorani) | 2 |  |  |  | Cambridgeshire | Gujarati | 32
Cambridgeshire | Kurdish(Bahdini) | 9 |  |  |  | Cambridgeshire | Hindi | 13
Cambridgeshire | Lithuanian | 24 |  |  |  | Cambridgeshire | Hungarian | 8
Cheshire | Mandarin | 1 |  |  |  | Cheshire | Indonesian | 2
Cheshire | Pashto | 199 |  |  |  | Cheshire | Italian | 6
Cheshire | Portuguese | 42 |  |  |  | Cheshire | Portuguese | 152
Cheshire | Punjabi | 32 |  |  |  | Cheshire | Punjabi | 1
Spreadsheet: f8c8d7df-752a-43fa-af1f-7c6da0568c00
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
8918 | 68536 | [NAME] | Sulbi | EST | 283 | 00:24:41 | 00:00:45 | 00:58:00 | 00:02:05 | 00:36:25 | 1 | 02:01:56
Spreadsheet: 453088d1459165776-text-movement-based-on-values-text-on-values
Sheet: Sheet1

Questions |  |  | Look for |  | Result |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
Question 1 | 4 |  | 5
Question 2 | 8
Question 3 | 1
Question 4 | 1
Question 5 | 3
Question 6 | 10
Question 7 | 3
Question 8 | 9
Question 9 | 8
Question 10 | 6
Question 11 | 10
Question 12 | 10
Question 13 | 6
Question 14 | 5
Question 15 | 10
Question 16 | 8
Question 17 | 8
Question 18 | 7
Question 19 | 10
Question 20 | 1
Question 21 | 9
Question 22 | 5
Question 23 | 9
Question 24 | 1
Question 25 | 7
Question 26 | 6
Question 27 | 1
Question 28 | 9
Question 29 | 8
Question 30 | 1
Question 31 | 6
Question 32 | 5
Question 33 | 1
Question 34 | 7
Question 35 | 9
Question 36 | 3
Spreadsheet: 756ddb05-e093-473c-9bbf-7c08caf4432b
Sheet: SD_RTDRESP

Real Time Demand Response Asset Report |  |  |  |  |  |  |  |  | Real Time Demand Response Asset Report
SD_RTDRESP_<customer>_<date>_<version>.CSV |  |  |  |  |  |  |  |  | SD_RTDRESP_<customer>_<date>_<version>.CSV
<[NAME] |  |  |  |  |  |  |  |  | <[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT |  |  |  |  |  |  |  |  | Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 |  | [NAME] |  |  |  |  | Locational Marginal Price | Maximum Interruptable Capacity | Amount Interrupted |  |  | Interruption Payment |  |  | Interruption Event (Y/N)
Trading Date | Trading Interval | Asset Name | Asset ID | Location Id | Location Name | Location Type |  |  | Demand Response | Price Response | Profiled Response | Demand Response | Price Response | Profiled Response |  | Program | Baseline
Date | Hour End | String | Number | Number | String | String | $/MWh | MW | MWh | MWh | MWh | $ | $ | $ | Flag | String | Number
Spreadsheet: 739787d1625931258-non-array-formula-to-extract-unique-values-in-column-a2-a61-and-place-in-b2-b61-non-array-to-extract-unique-values-_1
Sheet: Here

Letter | Unique Values
 | A
 | B
 | C
 | E
 | F
 | H
 | J
 | L
 | M
 | O
 | P
 | R
 | S
 | T
Spreadsheet: 741556d1627131861-how-to-count-cells-only-when-they-have-content-book1
Sheet: Sheet1

 |  |  | RESULT
A | v | B | 2 | - | 1
B | v | D | 1 | - | 0
B | v | C | 3 | - | 2
C | v | B | 0 | - | 1
B | v | D | 1 | - | 0
A | v | C | 4 | - | 1
C | v | D | 2 | - | 2
C | v | A | 1 | - | 0
D | v | A | 2 | - | 3
A | v | D | 3 | - | 1
D | v | C | 2 | - | 2
D | v | B | 1 | - | 0
Spreadsheet: 187845d1350593572-multiple-look-up-testcase
Sheet: Data 2

Contracts | ID | Cust_Name | Key
127650~[NAME] | 100-1 | A |  | <=B2&"_"&COUNTIF($B$2:B2,B2) | [NAME] | CONTRACTS |  |  |  |  |  |  | 0
17960-bbCD-123 | 200-2 | B |  |  | 123_ABCD |  |  |  |  |  |  |  |  | <=SUMPRODUCT(--(LEN($G3:$M3)>0))
1244360-ZZRO~8792x3 | 100-1 | A |  |  | 456_DEFG
1895436-LLGT~90422vT | 100-1 | A |  |  | 789_GHIJ
123960-KbLM-12x3 | 300-3 | C |  |  | 000_JKLM
1244360-ZZRO~872x3 | 100-1 | A |  |  | 111_PPPP
196780-nuLM-2Yx3 | 300-3 | C |  |  | 999_CCCC
1560-Nys-123 | 405-9 | D |  |  | 999_DDDD
123960-KbLM-12x3 | 300-3 | C
1000-Sys-123 | 700-4 | E
Spreadsheet: mark_taylor__25031__annunity
Sheet: Sheet1

15 Year
 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017
Price | 5000
Discount Rate | 0 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
Discount Factor | 1
Price adjusted for time
[NAME] | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350
Price per year adjusted for time
NPV
Regulatory risk | 0.35
Final price
20 Year
 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022
Purchase Price | 4200
Discount Rate | 0 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
Discount Factor | 1
Price adjusted for time
[NAME] | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 351 | 352 | 353 | 354 | 355
Price per year adjusted for time
NPV
 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022
Sale Price | 5000
Discount Rate | 0 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05
Discount Factor | 1
Price adjusted for time
[NAME] | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 351 | 352 | 353 | 354 | 355
Price per year adjusted for time
NPV
P/L
Spreadsheet: 9cd6e4ed-a527-482a-867c-b66454f8f176
Sheet: Sheet1

IMPERIAL VALLEY COLLEGE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
DEPOSIT FORM
Date
Vendor or Department
Transaction Date |  |  |  |  |  | Document Number
Cash  and  Checks  Being  Deposited
 | 0.01 | 0 |  |  | 1 | 0
 | 0.05 | 0 |  |  | 5 | 0
 | 0.1 | 0 |  |  | 10 | 0
 | 0.25 | 0 |  |  | 20 | 0
 | 0.5 | 0 |  |  | 50 | 0
 |  |  |  |  | 100 | 0
 |  |  |  |  | Total Cash |  | 0
Checks(Total Number) |  |  |  |  | Total of  Checks
 |  |  |  |  | Total Deposit |  | 0
FOAPAL  Distribution  of  Deposit
NAME  OF  ACCOUNT |  |  | FUND | ORG | ACCT | PROG | AMOUNT
 |  |  |  |  |  | Total | 0
IVC Department |  |  |  |  |  | Business Office
/
Prepared by (name and signature) |  |  |  | Date |  | Verified by (signature)     Date
 |  | /
Verified by (name and signature) |  |  |  | Date |  | Verified by (print name)
Revised 7/20/2012
Spreadsheet: 716744d1612350333-conditional-formatting-across-multiple-data-example-capacity-planner-v3-3-ans
Sheet: March 2021

 |  |  |  |  |  |  |  |  |  | March 2021
ACTIVITY | Job Start Date | Job Duration | Rest Date | Rest Duration | Team 1 | Team 2 | Team 3 | Team 4 | Rest Days
 |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Test 1 | 1 | 12 | 7 | 2 | 1 | 0 | 0 | 0 | 1
Test 2 | 8 | 5 | 0 | 0 | 0 | 1 | 0 | 0 | 0
Test 3 | 15 | 5 | 0 | 0 | 0 | 0 | 1 | 0 | 0
Test 4 | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 1 | 0
Test 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Test 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Test 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Test 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Test 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Test 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Test 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Test 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Test 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Test 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 220363d1363129524-formula-to-sum-all-unique-critera-and-find-highest-sum-jvbeats_test_ron_v1a
Sheet: Top 5

 | Top 5 IDs | Sum of Value |  |  | Row Labels | Sum of Value | <-Pivot Table is really easier
1 |  |  |  |  | 41-005223 | 122449994.49
2 |  |  |  |  | 41-126640 | 48821604.23
3 |  |  |  |  | 41-049684 | 7803551.899999999
4 |  |  |  |  | 41-107347 | 6946454.5
5 |  |  |  |  | 41-053706 | 4863224.45
 |  |  |  |  | Grand Total | 190884829.57