tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 746742d1630997359-sumifs-with-table-references-results-in-value-error-exceld-and-c
Sheet: Summary

Month | DEMAND (Expected to have) | CAPACITY (Actually have) | What I would expect the capacity to be
2020-08-01 00:00:00 | 8 |  | 5.2
2020-09-01 00:00:00 | 8 |  | 5.2
2020-10-01 00:00:00 | 7 |  | 4.8
2020-11-01 00:00:00 | 7 |  | 3
2020-12-01 00:00:00 | 7 |  | 3
2021-01-01 00:00:00 | 7 |  | 5
2021-02-01 00:00:00 | 7 |  | 6
2021-03-01 00:00:00 | 7 |  | 6
2021-04-01 00:00:00 | 7 |  | 8.37
2021-05-01 00:00:00 | 7 |  | 8.37
2021-06-01 00:00:00 | 7 |  | 8.87
2021-07-01 00:00:00 | 7 |  | 11.37
2021-08-01 00:00:00 | 9 |  | 8.37
2021-09-01 00:00:00 | 7 |  | 8.87
2021-10-01 00:00:00 | 7 |  | 8.87
2021-11-01 00:00:00 | 7 |  | 8.87
2021-12-01 00:00:00 | 7 |  | 8.87
2022-01-01 00:00:00 | 7 |  | 9.87
2022-02-01 00:00:00 | 7 |  | 9.87
2022-03-01 00:00:00 | 7 |  | 9.87
2022-04-01 00:00:00 | 7 |  | 9.87
Spreadsheet: 707885d1607525196-how-to-assign-a-country-to-a-specific-area-dashboard
Sheet: CANADA

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 203236d1356988763-automatically-populate-data-to-multiple-sheets-populate-data
Sheet: Upgrade

Date | Day | Time | Content Pillar | Platform | Program | Status Update | Approval Date | Social Comments | Product Team Comments
2013-01-05 00:00:00 | Saturday | 11AM CST | Upgrade | 1 | 1 | [NAME] | [NAME] yada |  |  |  | Loyalty
2013-01-06 00:00:00 | Sunday | 11AM CST | Upgrade | 1 | 3 | [NAME] | [NAME] yada
2013-01-12 00:00:00 | Saturday | 6PM CST | Upgrade | 1 | 1 | [NAME] | [NAME] yada
Spreadsheet: 92635d1292228710-creating-a-multi-criteria-drop-down-temp_test
Sheet: Sheet1

Point | Criteria | Rating
Sales Value | > 1 mio < 2 mio | 1
 | > 2 mio < 3 mio | 2
 | > 3 mio < 5 mio | 3
 | > 5 mio | 4
Inventory Value | > 1 mio < 2 mio | 1
 | > 2 mio < 3 mio | 2
 | > 3 mio < 5 mio | 3
 | > 5 mio | 4
Impact on Product or Service quality | Marginal | 1
 | Low | 2
 | Medium | 3
 | High | 4
 | Extreme | 5
Impact on financial statement & reporting | Marginal | 1
 | Low | 2
 | Medium | 3
 | High | 4
 | Extreme | 5
Spreadsheet: 809210d1670956239-vlookup-help-example
Sheet: Pay Items

Pay Item Number | UOM | Description | Running Total | Forecasted Qty | Pay Qty | ∆ [NAME] vs. Field Measured
1 | EA | CONCRETE WASHOUT STRUCTURE
2 | EA | BRIDGE DRAIN
3 | LF | PIPE RAILING (BOX) (On Wall 5 & WW on 8x8 Box & WW 5x6 Box)
4 | LF | PEDESTRIAN RAILING (SPECIAL)
5 | SY | WATERPROOFING (MEMBRANE)
6 | SY | CONCRETE SEALER
7 | LF | BRIDGE EXPANSION DEVICE (0-4 INCH)
8 | CY | CONCRETE CLASS D
9 | CY | CONCRETE CLASS D (BRIDGE)
10 | LB | REINFORCING STEEL
11 | LB | REINFORCING STEEL (EPOXY COATED)
12 | LF | GUARDRAIL TYPE 9 (STYLE CA)
13 | EA | TRANSITION TYPE BR9-GR9
14 | LF | BRIDGE RAIL TYPE 9
15 | LF | PRESTRESSED CONCRETE I (CBT 72)
Pay Item Number | UOM | Description | Quantity Installed | Date Installed | Details/Location | Complete? | Notes
Spreadsheet: 649d3811-70a0-4449-8bce-80ca42025838
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (12 Entries):
 | 7 Biotechnology 7.7 Biosensors [NAME] and chemosensory analysis
No. | Company | Country | City | [NAME] | Hall/Booth
1 | 3T analytik GmbH & Co. KG | Germany | Tuttlingen | 78532 | A3.210
2 | Biametrics GmbH | Germany | Tübingen | 72076 | A3.460B
3 | Dynamic Biosensors GmbH | Germany | Garching | 85748 | A3.251/350
4 | Fraunhofer-Institut (ISIT) für [NAME] | Germany | Itzehoe | 25524 | A1.433/530
5 | GE Healthcare | Germany | München | 80807 | A3.331/430
6 | getAMO Ltd. | Bulgaria | Sofia | 1784 | A2.423
7 | IONICON Analytik GmbH | Austria | Innsbruck | 6020 | A2.425
8 | Leibniz-Institut für Pflanzengenetik und Kulturpflanzenforschung (IPK) Gatersleben | Germany | Gatersleben | 06466 | A3.371
9 | new_diagnostics GmbH bioanalytical solutions for food, the environment & medical applications | Germany | Freising | 85356 | A3.540/8
10 | Sentronic GmbH | Germany | Dresden | 01217 | A2.423
11 | Stratophase Ltd. | United Kingdom | [NAME], [NAME] | SO51 9DL | A3.261
12 | Technische Universität Dresden Fakultät Maschinenwesen Institut für Lebensmittel- und [NAME] | Germany | Dresden | 01069 | A3.371
Spreadsheet: sally_beck__33863__Implementation Schedule
Sheet: Implementation

Implementation Schedule for London
Risktrack XL Exposure feed [NAME]
Sheet ID | Book | Counterparty | Person Responsible | Manager | Spreadsheet Template | Officialization Time
1 | UK Gas | Derby Cogeneration Limited | Olivier Peltier/Helen Read | [NAME] | Done | 10.00 h
2 | UK Gas | London Electricity | Olivier Peltier/Helen Read | [NAME] | Done | 10.00 h
3 | UK Gas | Northern Electric & Gas Limited | Olivier Peltier/Helen Read | [NAME] | Done | 10.00 h
4 | UK Gas | Northumbrian Water Limited | Olivier Peltier/Helen Read | [NAME] | Done | 10.00 h
5 | UK Gas | CalEnergy Gas (UK) Limited | Olivier Peltier/Helen Read | [NAME] | Done | 10.00 h
6 | UK Gas | Innogy PLC | Olivier Peltier/Helen Read | [NAME] | Done | 10.00 h
7 | UK Power | ECTRL - Enron J Block | [NAME] | [NAME] | Done | 10.00 h
8 | UK Power | EGPTL - Enron UK Gas | [NAME] | [NAME] | Not Done
9 | UK Power | ECTRL - NP | [NAME] | [NAME] | Not Done
10 | E1 | TXU Europe Energy Trading Limited | Alroy D'Cruz | [NAME] | Done | 10.00 h
11 | E1 | EGPTL - UK Gas | Alroy D'Cruz | [NAME] | Done | 10.00 h
12 | E1 | EGPTL - UK Power | Alroy D'Cruz | [NAME] | Done | 10.00 h
13 | E2 | TXU Europe Energy Trading Limited | Alroy D'Cruz | [NAME] | Done | 10.00 h
14 | E2 | ECTRL - UK Gas | Alroy D'Cruz | [NAME] | Done | 10.00 h
15 | E2 | ECTRL - UK Power | Alroy D'Cruz | [NAME] | Done | 10.00 h
Spreadsheet: 588382d1535594838-find-specific-month-names-that-fall-in-between-a-date-range-copy-of-mmr_example-tomolsen-
Sheet: Sheet1

Min_Date_Missing | Max_Date_Missing | Mult_Mth_Missing
2018-01-01 00:00:00 | 2018-07-31 00:00:00
2017-12-22 00:00:00 | 2018-01-23 00:00:00
2018-04-01 00:00:00 | 2018-07-31 00:00:00
2017-10-01 00:00:00 | 2018-07-31 00:00:00
2018-03-01 00:00:00 | 2018-05-31 00:00:00
2018-07-01 00:00:00 | 2018-07-31 00:00:00
Spreadsheet: 45a48f2d-4f87-4651-aaff-addce01af70d
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0004750 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Oak Lane Elementary | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Person | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Estimate
Monthly Limit: |  |  | 5370
Daily Limit:
Sample Frequency: |  |  | Monthly
Spreadsheet: 771038d1646394893-how-to-open-any-horse-race-in-main-page-from-form-asctt0503form
Sheet: Table 18

CarPM/s     12mPM/s | API | RTC/km | RDistTC | DLS | DLW | DOD | Car | 12m | Crs | Dist | ClockW | AClockW
$1,462        $2,300 | 2.3 | SU/1.1 | 0 | 10 | 219 | 21.5 | 2012-01-01 00:00:00 | 1-1-7 | 0-0-1 | 0-0-3 | - | 2012-01-01 00:00:00
 |  |  |  |  |  |  | 8%-16% | 14%-28% | 0%-0% | 0%-0% |  | 8%-16%
G1              G2 | G3 | LR | FU | 2U | 3U | Firm | Good | Soft | Heavy | AW | Turf
-                  - | - | - | 0-0-3 | 0-0-2 | 1-0-2 | - | 0-0-4 | 1-1-7 | 0-0-1 | - | 2012-01-01 00:00:00
 |  |  | 0%-0% | 0%-0% | 50%-50% |  | 0%-0% | 14%-28% | 0%-0% |  | 8%-16%
18.0         9th of 9  23/02/2022 ASCOT Margin 10.6 Lengths Distance 1100m [NAME] Race Ascot Carnival 19/3-25/4 (C1) Prize $25,000 API 1.4 Race Time 1:04.76 Sec Time 0:35.35 (600) Sec Time Adj 1.56 [NAME] Weight 59.5 CD 59.5 BP 4 Odds 40-1 - 60-1 Prize Won $250 Trainer Hector [NAME] Winners 00-00-01 Rail Out 15m Cutaway applies. (Pent: 6.4). Track Direction Anti-Clockwise Winner [NAME] 58.5 (8) Second Nuhad 57 (5) Third Aunty Jean 57 (7) Settled 9th 800m 9th Turn 9th 35.5         3rd of 9  2/09/2021 NORTHAM Margin 2.6 Lengths Distance 2200m SOT S RST CL1 Race Kindred Spirit Boutique (C1) Prize $25,000 API 1.8 Race Time 2:20.53 Sec Time 0:37.91 (600) Sec Time Adj 2.52 [NAME] Weight 59.5 CD 59.5 BP 7 Odds 7-2 - 9-2 Prize Won $2,250 Trainer Hector [NAME] Winners 02-02-07 Rail Out 7m [NAME]. Track Direction Anti-Clockwise Winner Surf Point 57 (9) Second Time Stands Still 54 (6) Settled 7th 800m 7th Turn 5th 35.5       7th of 11  21/08/2021 BELMONT PARK Margin 3.6 Lengths Distance 1600m SOT S RST NMW1Y Race Iron Jack (Rs0ly) Prize $30,000 API 0.08 Race Time 1:40.50 Sec Time 0:37.14 (600) Sec Time Adj 2.00 [NAME] Weight 55.0 CD 55.0 BP 2 Odds 15-1 - 10-1 Prize Won $300 Trainer Hector [NAME] Winners 00-02-14 Rail Out 3m [NAME]. (Pent: 6.6). Track Direction Anti-Clockwise Winner Porphyrio 56 (6) Second Salon Du Cheval 60.5 (4) Third Al Mahalo 58 (7) Settled 7th 800m 7th Turn 7th 35.5       6th of 12  14/08/2021 BELMONT PARK Margin 4.1 Lengths Distance 1600m SOT S RST 1MW Race Happy 60th Bday M Walker-Rs1mw Prize $50,000 API 2.67 Race Time 1:38.70 Sec Time 0:37.02 (600) Sec Time Adj 1.88 [NAME] Yuill Weight 55.0 CD 55.0 BP 2 Odds 40-1 - 80-1 Prize Won $500 Trainer Hector [NAME] Winners 01-03-08 Rail True. (Pent: 6.5). Track Direction Anti-Clockwise Winner Brave Dream 55 (9) Second Mr Delegator 56 (11) Third Seminole Brave 58 (5) Settled 9th 800m 9th Turn 7th 34.0        1st of 11  29/07/2021 NORTHAM Margin 0.4 Lengths Distance 1400m SOT S RST MDN Race Fizzero Mdn Prize $20,000 API 0 Race Time 1:26.89 Sec   Time 0:35.90 (600) Sec Time Adj 2.25 [NAME] Weight 57.0 CD 57.0 BP 6 Odds 9-1 - 7-1 Prize Won $11,800 Trainer Hector [NAME] Winners 00-02-12 Rail Out 3m Entire. Track Direction Anti-Clockwise Second Steel's The Deel 57 (5) Third Surveillance 57 (1) Settled 6th 800m [NAME] 5th Poor career SR;  Poor SR over this distance; Up 500m in distance; Prefers soft footing;  ;
Spreadsheet: darrell_schoolcraft__7622__imball0201
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -80749 | -80287 |  |  |  |  |  |  |  | San Juan
2 | -84767 | -80299 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
3 | -83988 | -90299 |  |  |  | 2001-02-01 00:00:00 | -537 | -5933 |  | 5.62
4 | -99040 | -90299 |  |  |  | 2001-03-01 00:00:00 | -80533 | -96000 |  | 4.98
5 | -88188 | -70519 |  |  |  | 2001-04-01 00:00:00 | -819833 | -1020974 |  | 4.87
6 | -84068 | -85299 |  |  |  | 2001-05-01 00:00:00 |  | -1252019 |  | 3.82
7 | -87540 | -86191 |  |  |  | 2001-06-01 00:00:00 |  | -1589467 |  | 3.2
8 |  |  |  |  |  | 2001-07-01 00:00:00 | -2051914 | -1898771 |  | 2.77
9 |  |  |  |  |  | 2001-08-01 00:00:00 | -2021619 | -1999977 |  | 2.77
10
11
12
13
14 |  |  |  |  |  | 9/1 - 9/25
15
16
17
18
19 |  |  |  |  |  | Accumulated @ 9/25/01
20
21 |  |  |  |  |  | Equilalent volumes at 9/25/01
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 181805
2002-01-07 00:00:00
CBS Volume
 |  |  | 174403
Spreadsheet: 797139d1663737703-powerquery-date-and-time-extraction-power-query-help
Sheet: Sheet1

Resolved |  | Resolved Date (Expected) | Resolved Time (Expected)
01.10.2020 08:42:59 |  | 2020-10-01 00:00:00 | 8:42:59
01.10.2020 09:14:36 |  | 2020-10-01 00:00:00 | 9:14:36
01.10.2020 09:15:00 |  | 2020-10-01 00:00:00 | 9:15:00
01.10.2020 10:34:16 |  | 2020-10-01 00:00:00 | 10:34:16
01.10.2020 14:35:33 |  | 2020-10-01 00:00:00 | 14:35:33
01.10.2020 14:50:20 |  | 2020-10-01 00:00:00 | 14:50:20
01.10.2020 15:11:55 |  | 2020-10-01 00:00:00 | 15:11:55
01.10.2020 16:01:07 |  | 2020-10-01 00:00:00 | 16:01:07
01.10.2020 17:05:12 |  | 2020-10-01 00:00:00 | 17:05:12
02.10.2020 08:49:34 |  | 2020-10-02 00:00:00 | 8:49:34
02.10.2020 09:04:27 |  | 2020-10-02 00:00:00 | 9:04:27
02.10.2020 09:44:36 |  | 2020-10-02 00:00:00 | 9:44:36
02.10.2020 09:45:00 |  | 2020-10-02 00:00:00 | 9:45:00
02.10.2020 10:44:34 |  | 2020-10-02 00:00:00 | 10:44:34
02.10.2020 11:03:16 |  | 2020-10-02 00:00:00 | 11:03:16
02.10.2020 11:07:01 |  | 2020-10-02 00:00:00 | 11:07:01
02.10.2020 11:36:23 |  | 2020-10-02 00:00:00 | 11:36:23
02.10.2020 11:56:35 |  | 2020-10-02 00:00:00 | 11:56:35
02.10.2020 12:00:47 |  | 2020-10-02 00:00:00 | 12:00:47
02.10.2020 12:14:22 |  | 2020-10-02 00:00:00 | 12:14:22
02.10.2020 12:34:58 |  | 2020-10-02 00:00:00 | 12:34:58
02.10.2020 12:49:54 |  | 2020-10-02 00:00:00 | 12:49:54
02.10.2020 12:56:28 |  | 2020-10-02 00:00:00 | 12:56:28
Spreadsheet: 114036e5-27a6-4f7b-a125-6d5d8b5c375c
Sheet: JEV'S

JOURNAL ENTRY LOG
2004-03-04 00:00:00
TRANSACTION |  |  |  |  | POSTED
NUMBER | [NAME] |  |  |  | DATE | INITIALS
909039
909040
909041
909042
909043
909044
909045
909046
909047
909048
909049
909050
909051
909052
909053
909054
909055
909056
909057
909058
909059
909060
909061
909062
909063
909064
909065
909066
909067
909068
909069
909070
909071
909072
909073
909074
909075
909076
Spreadsheet: 334549d1406187156-irr-in-reverse-irr-example
Sheet: Sheet1

Time | Cash Flow | IRR | Check | New IRR | New starting CF | < This is what you much change the first CF to in order to achieve a 20% IRR
0 | -40000 |  |  | 0.2
1 | 5000 |  |  |  | New ending CF | < This is what you must change the last CF to in order to achieve 20% IRR
2 | 5000
3 | 5000
4 | 5000
5 | 5000
6 | 5000
7 | 5000
8 | 5000
9 | 5000
10 | 5000
11 | 5000
12 | 5000
13 | 30000
 |  | IRR | New IRR | New starting CF | < This is what you much change the first CF to in order to achieve a 20% IRR
2014-01-01 00:00:00 | 1000000 |  | 0.15
2014-06-30 00:00:00 | -1100000 |  |  | New ending CF | < This is what you must change the last CF to in order to achieve 20% IRR
Spreadsheet: 739163d1625563558-assigning-randomly-mentors-and-mentees-people-allocation-temp
Sheet: Mentees

Teacher (Mentee) | Faculty 1 | Faculty 2 | Faculty 3 | Faculty 4 | Subject | Mentor (Rand) | Mentor (Assign 1 1st)
Concetta C | Religious Education | Languages
[NAME] | Religious Education | Commerce | Information Technology
[NAME] | Religious Education | Mathematics
[NAME] | Religious Education | English | Literacy | Humanities
Shannon D | Religious Education | Humanities
Amanda D | Physical Educatioon | Health
[NAME] | English | Humanities | Performing Arts
[NAME] | Mathematics | Science
[NAME] | Languages
[NAME] | Visual Arts
[NAME] | Religious Education
[NAME] | English | Languages
[NAME] | Literacy | Languages
Sonia G | Mathematics | Science
[NAME] | Physical Educatioon | Health
[NAME] | Religious Education | English
[NAME] | English | Humanities | Commerce
Bridget H | Literacy
[NAME] | Religious Education | English | Humanities
[NAME] | Religious Education | Humanities
Alyce H | Science
Tania H | Commerce
[NAME] | English | Performing Arts
[NAME] | Mathematics | Numeracy | Information Technology
[NAME] Y | Mathematics | Numeracy
Helen Z | Literacy | Languages
[NAME] | English | Humanities
Spreadsheet: 685159d1593768490-move-column-after-another-column-with-power-query-test
Sheet: Sheet1

Part1 | 123 | Part25 | 5494
Part2 | 456 | Part26 | 8549
Part3 | 789 | Part27 | 11604
Part4 | 1122 | Part28 | 14659
Part5 | 1455 | Part29 | 17714
Part6 | 1788 | Part30 | 20769
Part7 | 2121 | Part31 | 23824
Part8 | 2454 | Part32 | 26879
Part9 | 2787 | Part33 | 29934
Part10 | 3120 | Part34 | 32989
Part11 | 3453 | Part35 | 36044
Part12 | 3786 | Part36 | 39099
Part13 | 4119 | Part37 | 42154
Part14 | 4452 | Part38 | 45209
Part15 | 4785 | Part39 | 48264
Part16 | 5118 | Part40 | 51319
Part17 | 5451 | Part41 | 54374
Part18 | 5784 | Part42 | 57429
Part19 | 6117 | Part43 | 60484
Part20 | 6450 | Part44 | 63539
Part21 | 6783 | Part45 | 66594
Part22 | 7116 | Part46 | 69649
Part23 | 7449 | Part47 | 72704
Part24 | 7782 | Part48 | 75759
 |  | Part49 | 78814
 |  | Part50 | 81869
Spreadsheet: michelle_lokay__27356__oasisimb
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -89582 | -90050
2 | -89081 | -90000
3 | -84203 | -85000
4 | -85082 | -86388
5 | -80771 | -80000
6 | -82815 | -87500
7 | -88685 | -87500
8 | -89097 | -87500
9 | -112921 | -111893
10 | -108354 | -108062
11 | -93600 | -93858
12 | -122074 | -121623
13 | -111218 | -112200
14 | -111370 | -112200
15 | -111886 | -112200
16 | -78363 | -80000
17 | -78316 | -80000
18 | -79900 | -85100
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-09-30 00:00:00 |  | 58685
 | 2001-10-18 00:00:00
Spreadsheet: 856368d1705617889-help-using-a-lookup-function-with-mutiple-criteria-job-schedule-dataset
Sheet: Sheet4

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Parameters
 |  |  |  | Job # | Bay # | Phase 60 | Phase 65 | Phase 70 | Phase 80 | Phase 90 |  | Bay # | Date
 |  |  |  | 8000 | 25 | 2023-01-31 00:00:00 | 2023-02-02 00:00:00 | 2023-02-12 00:00:00 | 2023-02-28 00:00:00 | 2023-03-14 00:00:00 |  | 25 | 2023-01-31 00:00:00 |  |  |  | Output
 |  |  |  | 7999 | 24
 |  |  |  | 7998 | 5
 |  |  |  | 7997 | 4 |  |  |  |  |  |  | Job # | Bay # | Attribute | Value
 |  |  |  | 7996 | 3 |  |  |  |  |  |  | 8000 | 25 | Phase 60 | 2023-01-31 00:00:00
 |  |  |  | Lookup Values |  | Return Values
 |  |  |  | Bay # |  | Job #
 |  |  |  | Date |  | Phae #
Spreadsheet: 783963d1655313828-summary-page-that-automatically-adds-new-row-when-a-new-tab-is-created-2022-06-15-oeldere-stefaniejordan87-wip-metrc-submission-forms-sample
Sheet: Summary

Distillate Biomass Liability |  |  |  |  |  |  |  |  | G3 | L5 | R5
 | UID | Weight (g) | Total Biomass (g) | Biomass Liability (g) | Conversion to Lbs
 | 6425 | 8636.81 | 182000 | 122309.5750715269
 | 6428 | 6480.05 | 609000 | 345655.6407112202
 | 6425 |  |  |  |  |  |  |  | ** Cells that need to be referenced from template are:
 |  |  |  |  |  |  |  |  | UID - E3
 |  |  |  |  |  |  |  |  | Weight (g) - G3
 |  |  |  |  |  |  |  |  | Total Biomass (g) - L5
 |  |  |  |  |  |  |  |  | Biomass Liabilty - R5
 |  |  |  |  |  |  |  | ** I somehow need to be able to add information from the same set of cells to a new row in this table each time a new tab is created and the template is copied over**
Spreadsheet: 732700d1621174305-dynamic-lookup-number-of-rows-vary-each-day-unique_list
Sheet: Sheet1

 | Unique List | Sorted A-Z |  | List 1 | List 2 |  | CORRECT RESULT TO BE PRODUCED
 |  |  |  | [NAME] | [NAME] |  | [NAME]
 |  |  |  | [NAME] | [NAME] |  | [NAME]
 |  |  |  | [NAME] | [NAME] |  | [NAME]
 |  |  |  | [NAME] | [NAME] |  | [NAME]
 |  |  |  | [NAME] | [NAME] |  | [NAME]
 |  |  |  | [NAME] | [NAME] |  | [NAME]
 |  |  |  | [NAME] | Cameron |  | [NAME]
 |  |  |  | Dominic | [NAME] |  | Cameron
 |  |  |  | Eddy | Dominic |  | [NAME]
 |  |  |  | [NAME] | [NAME] |  | Dominic
 |  |  |  |  | Eddy |  | [NAME]
 |  |  |  |  | [NAME] |  | Eddy
 |  |  |  |  |  |  | [NAME]
Spreadsheet: 81529d1281660866-sorting-placing-data-by-three-variables-tournament-software-template
Sheet: Sheet1

Name | TT | Tee | Course
[NAME] | 07:30:00 | 1 | C1
Jake | 09:30:00 | 1 | C2
[NAME] | 08:00:00 | 10 | C1
[NAME] | 08:30:00 | 10 | C2
george | 07:30:00 | 1 | C2
[NAME] | 07:00:00 | 10 | C1
Spreadsheet: 107632d1304761274-lookup-function-mixed-with-sumif-month-x-product
Sheet: Sheet1-B

Product | Month | Qty
Product1 | 1 | 2
Product1 | 1 | 3
Product1 | 2 | 3
Product1 | 2 | 4
Product1 | 2 | 5
Product2 | 1 | 5
Product2 | 1 | 5
Product2 | 2 | 3
Product2 | 2 | 3
Product2 | 2 | 3
Spreadsheet: 685709d1594150063-how-to-show-the-values-on-pivot-table-context
Sheet: Sheet1

Col.1 | Col.2
1-2 | 1-2
1-2 | 1-b2
1-2 | 1-#2
2-3 | 2-b3
2-3 | 2-3
2-3 | 2-#3
2-3 | b2-b3
2-3 | b2-3
2-3 | b2-#3
2-3 | #2-b3
2-3 | #2-3
2-3 | #2-#3
3-4 | 3-b4
3-4 | 3-4
3-4 | 3-#4
3-4 | b3-b4
3-4 | b3-4
3-4 | b3-#4
3-4 | #3-b4
3-4 | #3-4
3-4 | #3-#4
4-5 | 4-b5
4-5 | 4-5
4-5 | 4-#5
4-5 | b4-b5
4-5 | b4-5
4-5 | b4-#5
4-5 | #4-b5
4-5 | #4-5
4-5 | #4-#5
5-6 | 5-b6
5-6 | 5-6
5-6 | 5-#6
5-6 | [NAME]
5-6 | [NAME]
5-6 | b5-#6
5-6 | #5-b6
5-6 | #5-6
5-6 | #5-#6
6-7 | 6-b7
6-7 | 6-7
6-7 | 6-#7
6-7 | b6-b7
6-7 | b6-7
6-7 | b6-#7
6-7 | #6-b7
6-7 | #6-7
6-7 | #6-#7
7-8 | 7-8
7-8 | b7-8
7-8 | #7-8
Spreadsheet: 876630d1723360629-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.25.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-25 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 6 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 18 | 0 | 3 | 0 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 18 | 0 | 4 | 2 | 0 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 20 | 0 | 5 | 0 | 2 | 0 | 0 | 3 | 0
 | MNO | 12 | 6 | 4 | 0 | 2 | 1 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 6 | 1 | 0 | 1 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-25 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 9 | 0 | 2 | 1 | 0 | 1 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 21 | 0 | 4 | 1 | 0 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 21 | 0 | 4 | 0 | 3 | 0 | 0 | 1.5 | 0
 | ABC | 27 | 18 | 21 | 0 | 5 | 0 | 2 | 0 | 0 | 3 | 0
 | MNO | 12 | 6 | 5 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 3 | 0 | 1 | 0 | 1 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 5 | 2 | 0 | 1 | 0 | 2 | 0
 | Total House Census
Spreadsheet: 381111b6-a220-4a35-98f1-7cdb79d46bbc
Sheet: 2014-2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Environmental Studies
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C