tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 218249d1362408734-transfer-data-from-one-format-to-another-test2
Sheet: Sheet2

a5 | 1996-11-17 00:00:00 | 48.67874955559051
a2 | 1997-04-05 00:00:00 | 6.357276157220824
a1 | 1997-05-21 00:00:00 | 13.51675843187451
a1 | 1997-08-03 00:00:00 | 68.4330429172872
a5 | 1997-08-04 00:00:00 | 78.87760947265129
a7 | 1997-10-21 00:00:00 | 7.248534909166509
a6 | 1997-10-22 00:00:00 | 14.77142052193823
a7 | 1998-06-02 00:00:00 | 39.40248288758312
a1 | 1998-09-06 00:00:00 | 11.370286824254
a6 | 1998-09-14 00:00:00 | 72.9264971296947
a2 | 1998-11-08 00:00:00 | 64.8563980881697
a5 | 1998-12-19 00:00:00 | 19.24119885964105
a6 | 1999-02-23 00:00:00 | 29.03379351185601
a10 | 1999-02-27 00:00:00 | 75.94262441017216
a1 | 1999-04-14 00:00:00 | 7.409494809951269
a2 | 1999-11-03 00:00:00 | 39.54958804192092
a5 | 1999-12-20 00:00:00 | 38.11649637496561
a2 | 2000-01-19 00:00:00 | 75.01204837192941
a10 | 2000-10-02 00:00:00 | 59.99582494239938
a6 | 2000-10-21 00:00:00 | 40.05140021807772
a10 | 2001-01-02 00:00:00 | 3.806962501948448
a10 | 2002-12-03 00:00:00 | 58.47627194576297
Spreadsheet: 877257d1724037187-chart-formatting-goes-away-when-i-make-slicer-selections-slicer-1-
Sheet: Pivot

 | Column Labels
Values | Blue | Green | Orange | Purple | Red | Grand Total
Jan Earth | 1 | 2 | 4 | 3 | 7 | 17
Feb Earth | 3 | 4 | 5 | 4 | 9 | 25
[NAME] | 5 | 6 | 6 | 5 | 11 | 33
Apr Earth | 7 | 8 | 7 | 6 | 13 | 41
May Earth | 9 | 10 | 8 | 7 | 15 | 49
[NAME] | 11 | 12 | 9 | 8 | 17 | 57
Jul Earth | 13 | 14 | 10 | 9 | 19 | 65
Aug Earth | 15 | 16 | 11 | 10 | 21 | 73
Sep Earth | 17 | 18 | 12 | 11 | 23 | 81
Oct Earth | 19 | 20 | 13 | 12 | 25 | 89
Nov Earth | 21 | 22 | 14 | 13 | 27 | 97
Dec Earth | 23 | 24 | 15 | 14 | 29 | 105
Spreadsheet: 678394d1589866778-matching-values-in-two-columns-clearing-eftpos-transactions
Sheet: Clearing - Eftpos Transact

Clearing - Eftpos Transactions
Date | Type | Transaction | Reference | Debit | Credit
2019-06-30 00:00:00 |  | Opening Balance |  | 972.4
2019-07-01 00:00:00 | INV | Daily totals - '-' | INV-0286 | 4215.5
2019-07-01 00:00:00 | PAY | EFTPOS - EFTPOS | MERCHANT [NAME] |  | 1132 | Skipped
2019-07-02 00:00:00 | INV | Daily totals - '-' | INV-0287 | 3178.2
2019-07-02 00:00:00 | PAY | EFTPOS - EFTPOS | MERCHANT [NAME] |  | 4215.5 | Match
2019-07-03 00:00:00 | INV | Daily totals - '-' | INV-0288 | 1457.6
2019-07-03 00:00:00 | PAY | EFTPOS - EFTPOS | MERCHANT [NAME] |  | 3178.2 | Match
2019-07-04 00:00:00 | INV | Daily totals - '-' | INV-0289 | 2073.2
2019-07-04 00:00:00 | PAY | EFTPOS - EFTPOS | MERCHANT [NAME] |  | 1457.6 | Match
2019-07-05 00:00:00 | INV | Daily totals - '-' | INV-0290 | 1611.6
2019-07-05 00:00:00 | PAY | EFTPOS - EFTPOS | MERCHANT [NAME] |  | 2073.2 | Match
2019-07-08 00:00:00 | INV | Daily totals - '-' | INV-0291 | 1892.5
2019-07-08 00:00:00 | PAY | EFTPOS - EFTPOS | MERCHANT [NAME] |  | 1611.6 | Match
2019-07-09 00:00:00 | INV | Daily totals - '-' | INV-0292 | 1426
2019-07-09 00:00:00 | PAY | EFTPOS - EFTPOS | MERCHANT [NAME] |  | 1892.5 | Match
Total |  |  |  | 15854.6 | 15560.6
 |  | Closing Balance |  | 2910.15
Spreadsheet: 714053d1611072287-how-to-limit-the-number-of-rows-returned-by-filter-formula-limit-rows-returned-by-filter-3-
Sheet: Sheet1

Planned Events |  |  |  |  |  | Currently Active Events
Title | Start | End |  |  |  | Title | Start | End
Event1 | 2020-12-01 00:00:00 | 2021-04-01 00:00:00
Event2 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00
Event3 | 2021-01-17 00:00:00 | 2021-04-01 00:00:00
Event4 | 2021-01-11 00:00:00 | 2021-04-01 00:00:00 |  |  |  |  |  |  |  | Would like to make it so only 3 rows are given by the formula, preferebly the 3 with the most recent start dates
Event5 | 2021-01-16 00:00:00 | 2021-04-01 00:00:00
Event6 | 2021-06-01 00:00:00 | 2021-04-01 00:00:00
Event7 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00
Event8 | 2021-08-01 00:00:00 | 2021-04-01 00:00:00
Event9 | 2021-09-01 00:00:00 | 2021-04-01 00:00:00
Event10 | 2021-10-01 00:00:00 | 2021-04-01 00:00:00
Spreadsheet: 692880d1598619416-lookup-that-looks-down-then-across-dynamic-rows-excel-help-lookup-down-then-across
Sheet: Sheet1

 | Item | ab101
 | Region | NE
 | Price
 | Item | NE | NW | SE | SW
 | AB101 | 5.5 | 5.75 | 4.25 | 4.79
 | AB200 | 6.95 | 6.99 | 7.5 | 5.29
 | TN300 | 10.45 | 10.75 | 9.5 | 9.75
 | TN301 | 8.75 | 8.99 | 8.22 | 8.37
 | [NAME] | 11.2 | 11.25 | 11.95 | 12.01
 | XY201 | 4.33 | 4.75 | 4.95 | 3.75
Spreadsheet: 1dab41f3-4ee3-4cea-a4e5-665b5b791aab
Sheet: General Info

General Information - Service Center Application
Instructions
Fill in the yellow highlighted areas
New Application
Renewal
 | (Indicate one of the above)
College/Division
Department
Service Center Name
Contact Information (Worksheet preparer)
Name
[NAME]
Phone #
College Fiscal Contact
Name
[NAME]
Phone #
Financially Responsible Person for the Service Center
Name
Title
[NAME]
Phone #
Percent of use by customer category
UI Departments including your own
External to UI
Are grants and contracts (K accounts) ever charged for this service?
No
Yes |  | If Yes, what percent?
Description of the product(s) or service(s) to be provided
Do competitors exist outside of the UI?
No
Yes
If yes, briefly describe how the service center rates compare to market rates
Does the service center provide services to certain users at discounted rates or free of charge?
Same fee charged to everyone
Different fees to differnent users
If different fees, please elaborate
When is your service center expected to break even?
Sept 30
Dec 31
March 31
June 30
Source of start-up (seed) money.  ([NAME] this field if reporting a new service center.  Include budget numbers and dollar amounts.
Budget
Amount
Identify the source of funds to be used to absorb the entire deficit if it exceeds 15% of the service center's total annual expense
Budget
Spreadsheet: 878655d1725891159-comprhensive-formula-needed-need-formula
Sheet: Sheet1

Amount | 100000 | -50000 | 40000 |  |  | -25000
Rate | 0.1 | 0.05 | 0.2
Result |  |  |  |  |  | Try, in B5, copy across:
Total sum
Rank | 1st | 2nd | 3rd
Amount
Deduct
Balance
Combined formula
Spreadsheet: 6c8b757f-41c0-4bd6-ad02-247d2de77ef3
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
CMIL | Test | CMIL | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
CMIL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CMIL | Result | CMIL | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6175-4
Spreadsheet: 124012d1317997936-excel-2007-join-multiple-field-and-ignore-blank-false-fields-sample-for-excel-forum
Sheet: Programming Tab

Medical History:
Condition | Client | If Stmts | Outcome Statements | Report Link Statement
Stoke | False |  | No chronic medical conditions were identified.
High Blood Pressure | False |  | has a medical history of:
Alzheimers | True
Cancer | True
Heart Problems | True
Dementia | False
Smoker | False
Spreadsheet: 141060d1329063470-vlookup-with-two-tables-double-vlookup
Sheet: Sheet1

range 1 |  |  | range 2
shoes | 80 |  | jeans | 70
skirt | 30 |  | t-shirt | 10
socks | 5 |  | sneakers | 100
item to lookup: | Shoes
number: | 1
price: | 80
Spreadsheet: 98711d1297554190-meeting-booker-meetings
Sheet: 16 feb

 | Room |  | Start | End | Length | Comments | Meeting booker
07:30:00 |  |  | 07:30:00 | 08:30:00
07:40:00 |  |  | 10:10:00 | 12:10:00
07:50:00 |  |  | 13:40:00 | 17:00:00
08:00:00
08:10:00
08:20:00
08:30:00
08:40:00
08:50:00
09:00:00
09:10:00
09:20:00
09:30:00
09:40:00
09:50:00
10:00:00
10:10:00
10:20:00
10:30:00
10:40:00
10:50:00
11:00:00
11:10:00
11:20:00
11:30:00
11:40:00
11:50:00
12:00:00
12:10:00
12:20:00
12:30:00
12:40:00
12:50:00
13:00:00
13:10:00
13:20:00
13:30:00
13:40:00
13:50:00
14:00:00
14:10:00
14:20:00
14:30:00
14:40:00
14:50:00
15:00:00
15:10:00
15:20:00
15:30:00
15:40:00
15:50:00
16:00:00
16:10:00
16:20:00
16:30:00
16:40:00
16:50:00
17:00:00
17:10:00
17:20:00
17:30:00
17:40:00
17:50:00
18:00:00
18:10:00
18:20:00
18:30:00
18:40:00
18:50:00
19:00:00
19:10:00
19:20:00
19:30:00
Spreadsheet: 218174d1362386112-match-conditional-formatting-from-sheet-1-to-sheet-2-excel-1
Sheet: Sheet1 (2)

 | 2013-01-04 00:00:00 | 2013-01-11 00:00:00 | 2013-01-18 00:00:00 | 2013-01-25 00:00:00 | 2013-02-01 00:00:00 | 2013-02-08 00:00:00 | 2013-02-15 00:00:00 | 2013-02-22 00:00:00 | 2013-03-01 00:00:00 | 2013-03-08 00:00:00 | 2013-03-15 00:00:00 | 2013-03-22 00:00:00 | 2013-03-29 00:00:00 | 2013-04-05 00:00:00 | 2013-04-12 00:00:00 | 2013-04-19 00:00:00 | 2013-04-26 00:00:00 | 2013-05-03 00:00:00 | 2013-05-10 00:00:00 | 2013-05-17 00:00:00 | 2013-05-24 00:00:00 | 2013-05-31 00:00:00 | 2013-06-07 00:00:00 | 2013-06-14 00:00:00 | 2013-06-21 00:00:00 | 2013-06-28 00:00:00 | 2013-07-05 00:00:00 | 2013-07-12 00:00:00 | 2013-07-19 00:00:00 | 2013-07-26 00:00:00 | 2013-08-02 00:00:00 | 2013-08-09 00:00:00 | 2013-08-16 00:00:00 | 2013-08-23 00:00:00 | 2013-08-30 00:00:00 | 2013-09-06 00:00:00 | 2013-09-13 00:00:00 | 2013-09-20 00:00:00 | 2013-09-27 00:00:00 | 2013-10-04 00:00:00 | 2013-10-11 00:00:00 | 2013-10-18 00:00:00 | 2013-10-25 00:00:00 | 2013-11-01 00:00:00 | 2013-11-08 00:00:00 | 2013-11-15 00:00:00 | 2013-11-22 00:00:00 | 2013-11-29 00:00:00 | 2013-12-06 00:00:00 | 2013-12-13 00:00:00 | 2013-12-20 00:00:00 | 2013-12-27 00:00:00 | 2014-01-03 00:00:00 | 2014-01-10 00:00:00 | 2014-01-17 00:00:00 | 2014-01-24 00:00:00 | 2014-01-31 00:00:00 | 2014-02-07 00:00:00 | 2014-02-14 00:00:00 | 2014-02-21 00:00:00 | 2014-02-28 00:00:00 | 2014-03-07 00:00:00 | 2014-03-14 00:00:00 | 2014-03-21 00:00:00 | 2014-03-28 00:00:00 | 2014-04-04 00:00:00 | 2014-04-11 00:00:00 | 2014-04-18 00:00:00 | 2014-04-25 00:00:00 | 2014-05-02 00:00:00 | 2014-05-09 00:00:00 | 2014-05-16 00:00:00 | 2014-05-23 00:00:00 | 2014-05-30 00:00:00 | 2014-06-06 00:00:00 | 2014-06-13 00:00:00 | 2014-06-20 00:00:00 | 2014-06-27 00:00:00 | 2014-07-04 00:00:00 | 2014-07-11 00:00:00 | 2014-07-18 00:00:00 | 2014-07-25 00:00:00 | 2014-08-01 00:00:00 | 2014-08-08 00:00:00 | 2014-08-15 00:00:00 | 2014-08-22 00:00:00 | 2014-08-29 00:00:00 | 2014-09-05 00:00:00 | 2014-09-12 00:00:00 | 2014-09-19 00:00:00 | 2014-09-26 00:00:00 | 2014-10-03 00:00:00 | 2014-10-10 00:00:00 | 2014-10-17 00:00:00 | 2014-10-24 00:00:00 | 2014-10-31 00:00:00 | 2014-11-07 00:00:00 | 2014-11-14 00:00:00 | 2014-11-21 00:00:00 | 2014-11-28 00:00:00 | 2014-12-05 00:00:00 | 2014-12-12 00:00:00 | 2014-12-19 00:00:00 | 2014-12-26 00:00:00 | 2015-01-02 00:00:00 | 2015-01-09 00:00:00 | 2015-01-16 00:00:00 | 2015-01-23 00:00:00 | 2015-01-30 00:00:00 | 2015-02-06 00:00:00
Spreadsheet: 480205d1473822201-scheduling-scheduling
Sheet: Sheet1

 | Teaching schedule
Index | Week Commencing (Monday):
 | Course Code | Course No. | Course Description |  |  |  |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | w | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S
 |  |  |  | In-house External | Facilitator | Duration (days) | [NAME] class size
1 | A |  | Algebra | In-house |  | 3 | 10
2 | B |  | Binary | In-house |  | 1.5 | 10
3 | C |  | Coefficients | External |  | 1 | 10
4 | D |  | Diagonals | External |  | 5 | 8
5 | E |  | E=MC | External |  | 5 | 8
6 | F |  | Feet | External |  | 3 | 7
7 | G |  | Graph | External |  | 1 | 7
8 | H |  | Hypotenuse | External |  | 1 | 10
9 | I |  | Index | External |  | 3 | 7
 |  |  | Weekend or holiday
 | Course Code | Course No. |  | Start Date | End Date
 | A | 1/16N | Algebra | 2016-09-07 00:00:00
 | C | 1/16D | Coefficients | 2016-09-06 00:00:00
 | D | 1/16D | Diagonals | 2016-09-09 00:00:00
 | A | 2/16N | Algebra
 | B | 3/16N | Binary | 2016-09-11 00:00:00
 | A | 3/16D | Algebra
 | F | 5/16D | Feet | 2016-10-03 00:00:00
 | D | 2/16N | Diagonals | 2016-09-14 00:00:00
 | D | 3/16D | Diagonals | 2016-09-15 00:00:00
 | A | 4/16N | Algebra
 | C | 2/16D | Coefficients
 | F | 6/16D | Feet | 2016-09-13 00:00:00
 | Solution sought: | Place the Course Number in the appropriate date cell. E.g.'1/16N' in range K6:M6
 |  | New courses will be constantly added, existing dates will be changed.
Spreadsheet: 36568d1234449921-how-to-do-two-logical-tests-for-a-conditional-statement-roi-with-energy-calculator
Sheet: Mt. Morris Hallway

 | ECOlighting Solutions |  | Telephone: [PHONE]
 | 2000 Commerce Pkwy |  | Fax: [PHONE]
 | Lancaster, NY 14086 |  | E-Mail: [EMAIL]
Base information
Customer | [NAME]
Project Name | Mt. Morris Hallway |  |  | [NAME]. | 021009A
Address |  |  |  | Type of Old Technology | 175 W HPS
Contact | [NAME] |  | ` | Type of LED | LED Retro
Phone |  |  |  | Voltage | 277
Technical Information | 175 W HPS | LED Retro
Old Technology / LED, lifetime in hours | 5000 | 120000 |  | Qty Lights / Daily usage | 17 | 17
Old Technology/ LED, lifetime in years | 0.8058017727639001 | 19.3392425463336 |  | Usage in / day's per month / day's per year | 30 | 360
Install. costs for the first installation | 175 W HPS | LED Retro |  |  | 175 W HPS | LED Retro
Costs each (Entire Fixture) | 250 | 369
Install Costs (Per Fixture) | 20 | 20
 |  |  | Cost for the Lights |  | 6273
Lifetime Maintenance Cost (After Installation) | 175 W HPS | LED Retro
Lifetime changes | 23 |  |  |  | 175 W HPS | LED Retro
Bulb Cost | 25 | 0 | Bulb Savings (Lifetime) |  | 0 | 9775
Labor Rate | 16 | 0 | [NAME] (Lifetime) |  | 0 | 6256
Service cost including; Labor, and bulb | 41 | 0 | Bulb and [NAME] (lifetime) |  | 0 | 16031
Power consumption costs | 175 W HPS | LED Retro |  |  | 175 W HPS | LED Retro
Bulb consumption (wattage) | 175 | 40 | Total power consumption in watts per day |  | 60690 | 11560
Ballast consumption (wattage) | 35 | 0 | Power cost per day |  | 7.2828 | 1.3872
Consumption total (wattage) | 210 | 40 | Power cost per month |  | 218.484 | 41.616
Cost's per kWh | 0.12 | 0.12 | Power cost per year |  | 2621.808 | 499.392
Project [NAME] (sq. ft.) |  |  |  | Annual Power Savings | 2122.416
 |  |  |  | Lifetime Power Savings | 41045.91780821918
Results
 |  |  |  | Results
 |  |  |  | Bulb Cost (Lifetime) |  | 9775
 |  |  |  | Lifetime Power Savings |  | 41045.91780821918
 |  |  |  | Combined Lifetime savings (bulb and power) |  | 50820.91780821918
 |  |  |  | Combined Annual savings (bulb and power) |  | 2547.416
 |  |  |  | Break even after (Years) |  | 2.462495328599648
 |  |  |  | Potential Federal Incentives |  | 0
 |  |  |  | Potential NYSERDA Incentives |  | 2122.415999999999
 |  |  |  | Break Even After Incentives (Years) |  | 1.343303142382853
Energy Calculations
 |  |  |  |  | Old Technology | New Technology
 |  |  |  | Total Annual Coal Consumption (lbs.) | 17762.92682926829 | 3383.414634146342
 |  |  |  | Total Annual CO2 emissions (lbs.) | 49137.0516 | 9359.438400000001
 |  |  |  | Total Annual SO2 emissions (lbs) | 284.0291999999999 | 54.1008
 |  |  |  | Total Acres of Trees needed to fix this much CO2 (acres) | 6.700811618709941 | 1.276345070230465
 |  |  |  | Total annual energy consumption in kWh (lbs.) | 21848.4 | 4161.6
 |  |  |  | *Figures based on electricity coming from coal burning
Spreadsheet: 169196d1342723349-complicated-matching-issues-matching-issue
Sheet: Orginal

wRVU | Adj wRVU | Flag | MRN | CPT
2.43 |  |  | 1001 | 99204OB
0.97 |  |  | 1001 | 99213OB
1.01 |  |  | 1001 | 99214
0.97 |  |  | 1001 | 99213OB
1.01 |  |  | 1001 | 99214
0.97 |  |  | 1001 | 99213OB
0.97 |  |  | 1001 | 99213OB
3.56 |  |  | 1001 | 99698
0.97 |  |  | 1001 | 99213OB
0.97 |  |  | 1001 | 99213OB
0.97 |  |  | 1001 | 99213OB
28.69 |  |  | 1001 | 59400
0.97 |  |  | 1002 | 99213OB
3.56 |  |  | 1002 | 99698
1.01 |  |  | 1002 | 99214
0.97 |  |  | 1002 | 99213OB
0.97 |  |  | 1002 | 99213OB
0.97 |  |  | 1002 | 99213OB
0.97 |  |  | 1002 | 99213OB
28.69 |  |  | 1002 | 59400
0.97 |  |  | 1003 | 99213OB
1.01 |  |  | 1003 | 99214
0.97 |  |  | 1003 | 99213OB
0.97 |  |  | 1003 | 99213OB
0.97 |  |  | 1003 | 99213OB
1.01 |  |  | 1003 | 99214
0.97 |  |  | 1003 | 99213OB
0.97 |  |  | 1003 | 99213OB
Spreadsheet: 300172d1393406220-how-to-place-a-cell-boarder-over-a-shape-992261
Sheet: Sheet1

 | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual
 | 2012-01-15 00:00:00 | 2012-02-14 10:48:00 | 2012-03-14 10:48:00 | 2012-04-14 10:48:00 | 2012-05-14 10:48:00 | 2012-06-14 10:48:00 | 2012-07-14 10:48:00 | 2012-08-14 10:48:00 | 2012-09-13 21:36:00 | 2012-10-14 08:24:00 | 2012-11-13 19:12:00 | 2012-12-14 06:00:00 | 2013-01-13 16:48:00 | 2013-02-13 03:36:00 | 2013-03-15 14:24:00
Spreadsheet: 791824d1660627407-calculation-formula-problem-more-efficient-formula-aligw
Sheet: Sheet1

A | Cancel | 0 | Complete | 8 | Complete | 7 | Cancel | 4 | sa | Member |  |  | You: | AliGW:
C | Complete | 0 | Complete | 8 | Complete | 7 | Complete | 4 | ds | Claim
B | Complete | 0 | Complete | 8 | Complete | 7 | Complete | 4 | fd | Member
D | Panding | 1 | Panding | 8 | Panding | 7 | Panding | 4 | sa | Member
A | Complete | 1 | Complete | 3 | Panding | 5 | Panding | 0 | rf | Claim
C | Complete | 1 | Complete | 3 | Cancel | 5 | Complete | 0 | hg | Member
B | Panding | 5 | Panding | 3 | Panding | 5 | Cancel | 0 | fd | Claim
D | Complete | 5 | Cancel | 3 | Complete | 9 | Complete | 2 | gg | Member
B | Cancel | 5 | Cancel | 2 | Cancel | 9 | Cancel | 2 | rr | Member
C | Complete | 5 | Complete | 2 | Complete | 9 | Complete | 2 | tt | Other
Spreadsheet: 742459d1627765046-forecasting-start-dates-by-production-line-number-test
Sheet: Sheet1

Product ID | Production Line | Start Date | Build Rate in Days | End Date
111 | Line 1 | 2021-07-28 00:00:00 | 2
222 | Line 2 | 2021-07-28 00:00:00 | 2
333 | Line 3 | 2021-07-29 00:00:00 | 2
444 | Line 1 |  | 2
555 | Line 2 |  | 2
666 | Line 3 |  | 2
777 | Line 1 |  | 2
888 | Line 2 |  | 2
999 | Line 3 |  | 2
123 | Line 1 |  | 2
1234 | Line 2 |  | 2
12345 | Line 3 |  | 2
Spreadsheet: 78412d1278759387-determine-if-duplicate-with-value-in-adjacent-cell-considered-humblepie
Sheet: Sheet1

Name | Group | expected | my absolutely wrong  function | I think this is the one tho!
[NAME] | 1 | Yes | yes | yes
Smith | 0 | No | yes | no
McDonald | 2 | No | yes | yes
martin | 3 | Yes | no | no
Smith | 2 | No | yes | no
[NAME] | 1 | Yes | yes | yes
McDonald | 1 | No | yes | yes
[NAME] | 3 | Yes | yes | yes
Smith | 1 | No | yes | no
Spreadsheet: john_arnold__15212__Guggenheim attendees
Sheet: Guggenheim attendees

NAME OF GUEST | COMPANY
[NAME] | ConEd
[NAME] | ConEd
[NAME] | ConEd
[NAME] | ConEd
[NAME] | ConEd
[NAME] | OPG
[NAME] | 1st Rochdale
Lori-Smith Schell | Trigen Energy
[NAME] | [NAME]
[NAME] | LIPA
[NAME] | Enron
[NAME] | Enron
[NAME] | Enron
[NAME] | Enron
Unamed policy person
[NAME] | [NAME]
[NAME] | AIG
[NAME] | UBS O'Connor
[NAME]
[NAME]
[NAME] | GMR Comoditites
[NAME] | Soros Funds Management
[NAME] | Soros Funds Management
[NAME] | ANZ
Commonwealth Bank - ???
[NAME] | Westpac
[NAME] | NAB
[NAME] | Enron | [NAME]
[NAME] | Enron | [NAME]
[NAME] | Enron | [NAME]
[NAME] and [NAME] | New York Times
[NAME] and guest | [NAME], Inc
[NAME] and guest | Advance Publications
[NAME] and [NAME] | Advance Publications
[NAME] and [NAME] | Advance Publications
[NAME] and Guest | Newscorp
[NAME] and Guest | Wall Street Journal
[NAME] and Guest | Enron Industrial Markets
[NAME] and [NAME] | Enron Industrial Markets
[NAME] and [NAME] | Advance Publications
[NAME] and [NAME] | Advance Publications
[NAME] and Guest | Newscorp
[NAME] and Guest | Wall Street Journal
[NAME] and Guest | Enron Industrial Markets
[NAME] and [NAME] | Enron Industrial Markets
Mr. [NAME] +  Ms. [NAME] | Enron
Mr. + Mrs. [NAME] | Verizon
Mr. + Mrs. [NAME] | ( Durst Organization) V.P.
Mr. [NAME] +Ms. [NAME] | (Seaboard Corp) Bd. of Directors
[NAME] | New York Times
[NAME] | Brant Allen
Peter Brant & Guest | Brant Allen
[NAME] | J Crew
[NAME] | J Crew
Mark Eisner & Guest | Hachette Filipacci Magazines
Leon Hertz & Guest | Newscorp
John Ovanessian & Guest | Enron
Wendy King & Guest | Enron
[NAME] and spouse | CEO & President, Oppidan Group
[NAME] and guest | Vice President, Milcom
[NAME] and guest | Vice President, Abstract Spectrum
[NAME] and guest | Vice President, FPL
[NAME] and spouse | Vice President, Pennzoil/Quaker |  | waiting for final confirmation
[NAME] and guest | Enron
[NAME] | Financial Times | [NAME] | wants to bring a date
editor - name to come | Reuters | [NAME]
[NAME] |  | [NAME]
Per and [NAME] | Enron
[NAME] and Caroline Abramo | Enron
[NAME] and guest | Tudor Investments
[NAME] and guest | Tudor Investments
[NAME] and guest | Global Advisors UK
[NAME] and guest | SAC Capital
[NAME] and guest | SAC Capital
[NAME] and guest | Catequil Asset Management
[NAME] and guest | Catequil Asset Management
[NAME] and guest | Harvard Management Company, Inc.
[NAME] and guest | Enron
Robyn and [NAME] | Enron
[NAME] and guest | Catequil Asset Management
[NAME] and guest | Duquesne Capital Management
[NAME] | Enron
[NAME] | Enron
Spreadsheet: 538182d1505442226-pulling-unique-data-from-a-table-a-certain-number-of-times-advanced-s666v2-interpretting-data
Sheet: Sandy's Table

Name | Job 1 | Code 1
[NAME] | 247 - Dixon Stage 5 | 08-Other
 | 250 - 132 Kay Rd Subdivision | 02-Roading
 |  | 03-Stormwater
 | 252 - Kay Rd Cutdown | 03-Stormwater
[NAME] | 001 - Office | 08-Other
 | 247 - Dixon Stage 5 | 08-Other
 | 250 - 132 Kay Rd Subdivision | 02-Roading
 |  | 03-Stormwater
 |  | 08-Other
 | 253 - 116 Kay Rd Subdivision | (blank)
[NAME] | 250 - 132 Kay Rd Subdivision | 06-Concrete
 |  | 08-Other
 | 252 - Kay Rd Cutdown | 02-Roading
 |  | 07-Environmental
 |  | 08-Other
Jury [NAME] | 250 - 132 Kay Rd Subdivision | 02-Roading
 |  | 03-Stormwater
 | 250 [NAME] | (blank)
 | 252 - Kay Rd Cutdown | 02-Roading
 |  | 07-Environmental
[NAME] | 250 - 132 Kay Rd Subdivision | 02-Roading
Spreadsheet: 773158d1647658196-return-the-five-consecutive-numbers-from-a-range-that-total-the-most-when-summed-max-tot-of-5-consecutive-numbers
Sheet: Sheet1

Numbers | Running 5 Sums | Unique 5 | [NAME] |  | Answer?
 |  |  |  |  | Press F9 until you get your answer above.
 |  |  |  |  | Then look down the range to find a [NAME]-Min =4
 |  |  |  |  | and a Unique 5 = 1
 |  |  |  |  | The total of the consecutive range will appera in F2!!
Spreadsheet: 386416d1427786139-sumifs-two-criterias-from-different-columns-book100-gk
Sheet: Days

Month | No of Days | Format Month
2014-05-01 00:00:00 |  | 2014-05-01 00:00:00