tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 126281d1319615234-using-reference-with-inserting-rows-sample
Sheet: plan

task | planned | 2011-10-04 00:00:00
task 1 - draw |  | 8
task 2 - build |  |  | 8 | 8 | 8
task 3 - assemble something |  |  |  |  | 8 | 8 | 8
task 4 - some task again |  |  |  |  |  | 8 | 8 | 8 | 8
Spreadsheet: 271915d1382108303-vlookup-to-reference-cell-not-column-number-vlookup
Sheet: CURRENT SALES

ITEM | ItemCodeDesc | OLD Ord's | 2013-10-19 00:00:00 | 2013-10-26 00:00:00 | 2013-11-02 00:00:00 | 2013-11-09 00:00:00 | 2013-11-16 00:00:00 | 2013-11-23 00:00:00 | 2013-11-30 00:00:00 | 2013-12-07 00:00:00 | 2013-12-14 00:00:00 | 2013-12-21 00:00:00 | 2013-12-28 00:00:00 | 2014-01-04 00:00:00 | 2014-01-11 00:00:00 | 2014-01-18 00:00:00 | 2014-01-25 00:00:00 | 2014-02-01 00:00:00 | 2014-02-08 00:00:00 | 2014-02-15 00:00:00 | 2014-02-22 00:00:00 | 2014-03-01 00:00:00 | 2014-03-08 00:00:00 | 2014-03-15 00:00:00 | 2014-03-22 00:00:00 | 2014-03-29 00:00:00 | 2014-04-05 00:00:00 | 2014-04-12 00:00:00 | 2014-04-19 00:00:00 | 2014-04-26 00:00:00 | 2014-05-03 00:00:00 | 2014-05-10 00:00:00 | 2014-05-17 00:00:00 | 2014-05-24 00:00:00 | 2014-05-31 00:00:00 | 2014-06-07 00:00:00 | 2014-06-14 00:00:00 | 2014-06-21 00:00:00 | 2014-06-28 00:00:00 | 2014-07-05 00:00:00 | 2014-07-12 00:00:00 | 2014-07-19 00:00:00 | 2014-07-26 00:00:00 | 2014-08-02 00:00:00 | 2014-08-09 00:00:00 | 2014-08-16 00:00:00 | 2014-08-23 00:00:00 | 2014-08-30 00:00:00 | 2014-09-06 00:00:00 | 2014-09-13 00:00:00 | 2014-09-20 00:00:00 | 2014-09-27 00:00:00 | 2014-10-04 00:00:00 | 2014-10-11 00:00:00 | 2014-10-18 00:00:00 | 2014-10-25 00:00:00 | 2014-11-01 00:00:00 | 2014-11-08 00:00:00 | 2014-11-15 00:00:00 | 2014-11-22 00:00:00 | 2014-11-29 00:00:00
^20125
^20135
^20180
^20181
^20198
^20201
^20340
^20341
^20390
^20400
^20410
^20582
[NAME]
^20760
^20770
^20772
^20820
^20850
^20860
^20862
^20885
^20890
Spreadsheet: 4d50c8e8-6d70-4d66-a722-e03c68c7d226
Sheet: Iraq

IRAQ | Unshipped Balance |  | Accumulated Exports |  | Total Commitments
EXPORT SALES, Egypt | this year | last year | this year | last year | this year | last year
Spreadsheet: 147747d1332952418-index-and-match-to-combine-data-from-several-workbooks-class-2-scores
Sheet: Sheet1

 | Class: | SEVERN
 |  |  |  |  |  | Test No.
 | Student Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | Cooper | 0.2350730029040813 | 0 | 0.3937045452782011 | 0.8106032744459428 | 0.9640631314153503 | 0.1771835357328122 | 0.3463721080069908 | 0.8102473781919128 | 0.1220312989479808 | 0.7123514750652697
 | [NAME] |  | 0.04061713987088122 | 0.3688092109021319 |  |  | 0.9307814201906872 |  | 0 |  | 0
 | [NAME] |  |  |  |  |  |  | 0.6027379597757039 | 0 | 0.463773831770709 | 0.9231072231444424
 | Iverson | 0.50015065450454 | 0.2597155371664737 | 0.5243409681375417 | 0.7014874739634316 | 0.7136446797022735 |  | 0.195577846523888 |  | 0.9434367699877275
 | Bell | 0.614839996172653 | 0.4569810058481298 |  |  | 0.3187622773091068 | 0.6562949028691731 |  |  |  | 0.9310293853653171
 | Hardy |  |  | 0.7025953096763624 | 0.330300285582565 | 0 | 0.9074508713263372 | 0.6565119491440132 | 0.7875833538788017 | 0.3876534355263326 | 0.8730893856850539
 | [NAME] | 0 | 0.4479253356453841 | 0 |  |  | 0.9742442434902245 |  | 0 | 0.07561673430141114
 | Park | 0.2142865291416514 | 0 | 0.9991438575396885 | 0.770839683130184 | 0.4004971190860056 |  |  | 0.1320034167467115 |  | 0.4874531672093569
 | [NAME] | 0 |  |  | 0 | 0.8441014541539709 | 0.1561398435452013 |  |  | 0 | 0.4419449658038568
 | [NAME]
 | Walters | 0.1187599319808612 | 0.739031572463819 | 0.7223981020837826 | 0.6312224363759427 |  |  |  | 0.4612078135740525 | 0.9712998355250635 | 0
Spreadsheet: 28419d1222692748-macro-needed-to-help-attach-data-example
Sheet: Sheet1

Name | Distribution | Team
[NAME] | Systems | 351 Sup
Pchorely | Commercial | 251 Com
[NAME] | Systems | 351 Sup
Psmith | Commercial | 251 Com
Mpeople | Systems | 351 Sup
Jfive | Commercial | 251 Com
Lbean | Systems | 351 Sup
Htowes | Commercial | 251 Com
Bncos | Gambit | 250 Gam
Jkow | Commercial | 255 Com
Nmcall | Systems | 351 Sup
[NAME] | Commercial | 251 Com
Twerp | Systems | 351 Sup
Hsmith | Gambit | 250 Gam
[NAME] | Commercial | 255 Com
Blop | Systems | 351 Sup
Hgammy | Commercial | 251 Com
Frudd | Systems | 351 Sup
Ljackson | Gambit | 250 Gam
Asamba | Commercial | 255 Com
Spreadsheet: 695682d1600341454-help-with-pulling-average-for-a-number-of-specific-cells-quality-checks
Sheet: September 2020

Monitor | Advisor | Type | Date | Critical Failure | Customer Experience | Minor Failure | Minor Failure | Minor Failure | Minor Failure | Total Score | Comments | Case Number
[NAME] | 1 | Call | 2020-09-17 00:00:00 | Pass | A |  |  |  |  | 100 |  |  |  | Advisor | Score | Call | Chat | [NAME] | Graded | [NAME] | B
[NAME] | 1 | Call | 2020-09-17 00:00:00 | Pass | A |  |  |  |  | 100 |  |  |  | 1
[NAME] | 1 | Call | 2020-09-18 00:00:00 | Pass | A |  |  |  |  | 100 |  |  |  | 2
[NAME] | 1 | Call | 2020-09-19 00:00:00 | Pass | A |  |  |  |  | 100
[NAME] | 1 | Chat | 2020-09-20 00:00:00 | Pass | B |  |  |  |  | 80
[NAME] | 1 | Chat | 2020-09-21 00:00:00 | Pass | B |  |  |  |  | 80
[NAME] | 1 | Chat | 2020-09-22 00:00:00 | Pass | B |  |  |  |  | 80
[NAME] | 1 | [NAME] | 2020-09-23 00:00:00 | Pass | [NAME] | [NAME] |  |  |  | 75
[NAME] | 1 | [NAME] | 2020-09-24 00:00:00 | Pass | [NAME] | [NAME] |  |  |  | 75
[NAME] | 2 | Call | 2020-09-25 00:00:00 | Pass | B |  |  |  |  | 80
[NAME] | 2 | Call | 2020-09-26 00:00:00 | Pass | B |  |  |  |  | 80
[NAME] | 2 | Call | 2020-09-27 00:00:00 | Pass | B |  |  |  |  | 80
[NAME] | 2 | Call | 2020-09-28 00:00:00 | Pass | B |  |  |  |  | 80
[NAME] | 2 | Chat | 2020-09-29 00:00:00 | Pass | C+ |  |  |  |  | 65
[NAME] | 2 | Chat | 2020-09-30 00:00:00 | Pass | C+ |  |  |  |  | 65
[NAME] | 2 | Chat | 2020-10-01 00:00:00 | Pass | C+ |  |  |  |  | 65
[NAME] | 2 | [NAME] | 2020-10-02 00:00:00 | Pass | [NAME] | Spelling | P's & Q's |  |  | 50
[NAME] | 2 | [NAME] | 2020-10-03 00:00:00 | Pass | [NAME] | Spelling | P's & Q's |  |  | 50
[NAME] | Ava | Renewal |  |  |  |  |  |  |  | 100
[NAME] | Ava | WineBank |  |  |  |  |  |  |  | 100
[NAME] | Ava | Voucher |  |  |  |  |  |  |  | 100
[NAME] | Ava | Service |  |  |  |  |  |  |  | 100
[NAME] | Ava | Chat |  |  |  |  |  |  |  | 80
[NAME] | Ava | Chat |  |  |  |  |  |  |  | 80
[NAME] | Ava | Chat |  |  |  |  |  |  |  | 80
[NAME] | Ava | [NAME] |  |  |  |  |  |  |  | 75
[NAME] | Ava | [NAME] |  |  |  |  |  |  |  | 75
[NAME] | [NAME] | Renewal |  |  |  |  |  |  |  | 80
[NAME] | [NAME] | WineBank |  |  |  |  |  |  |  | 80
[NAME] | [NAME] | Voucher |  |  |  |  |  |  |  | 80
[NAME] | [NAME] | Service |  |  |  |  |  |  |  | 80
[NAME] | [NAME] | Chat |  |  |  |  |  |  |  | 65
[NAME] | [NAME] | Chat |  |  |  |  |  |  |  | 65
[NAME] | [NAME] | Chat |  |  |  |  |  |  |  | 65
[NAME] | [NAME] | [NAME] |  |  |  |  |  |  |  | 50
[NAME] | [NAME] | [NAME] |  |  |  |  |  |  |  | 50
Spreadsheet: 1530e4b1-b0d4-40c9-a1f7-8805b395ab8f
Sheet: Sheet1

Local Advisor
Chapter Name | First | Last | Title | Phone | [NAME]
National/International Advisor
 | First | Last | Title | Phone | [NAME]
Other Advisor 1
Chapter Name | First | Last | Title | Phone | [NAME]
Other Advisor 2
 | First | Last | Title | Phone | [NAME]
House Corporation Board
Chapter Name | First | Last | Title | Phone | [NAME]
Spreadsheet: 26651d1218950177-game-using-excel-footballgame-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 10 | 15 | 20 | 25 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | Los Angeles
 |  | RESULTS
 |  | Los Angeles | San Diego | San Francisco |  |  |  |  |  |  |  |  | San Diego
 |  | 20 | 5 | 10
 |  | -5 | 10 | -5 |  |  |  |  |  |  |  |  | San Francisco
 |  | 20 | -5 | 10
 |  | -10 | 20 | 20
 |  | 5
 |  | 10
Spreadsheet: 01ac88e6-5d70-408b-8e2c-54d2124615a2
Sheet: Sheet1

Machine Shop Purchase Request Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
P.O. #: |  |  |  |  | Professor:
Supplier: |  |  |  |  | Account #:
Date: |  |  |  | Order requested by:
 |  |  |  | Contact Ext. #
Source cheaper supplier?
 |  |  |  |  | Price
Item No. | Catalogue No. | Description |  | Quantity | Each | Total | Availability
1
2
3
4
5
6
7
8
 |  |  |  |  |  | 0
 |  | Date ordered
 | Contact Name or [NAME]
 | Confirmation # |  |  | Machine Shop Approval
Additional Charges (Dry Ice, Shipping etc.)
 |  |  |  | Signature
Spreadsheet: 776633d1649835490-returning-array-for-use-in-sumifs-formula-example
Sheet: Sheet1

Group | Type | Value |  | Item | Group |  | Type | Item A
Group A | Type A | 10 |  | Item A | Group A |  | Type A
Group A | Type A | 15 |  | Item A | Group B |  | Type B
Group A | Type B | 12 |  | Item B | Group B
Group B | Type A | 14 |  | Item C | Group C
Group C | Type A | 2
Group C | Type B | 7
Spreadsheet: 7d3c6f02-477b-47a6-96d7-cbee1c0ded82
Sheet: Sheet1

CERTIFICATION TEST PASS RATES*  ([NAME] and Updated 11/7/11)
 | COMPLETION YEAR 2005 |  |  |  |  |  | COMPLETION YEAR 2006 |  |  |  |  |  | COMPLETION YEAR 2007 |  |  |  |  |  | COMPLETION YEAR 2008 |  |  |  |  |  | COMPLETION YEAR 2009 |  |  |  |  |  | COMPLETION YEAR 2010 |  |  | COMPLETION YEAR 2011
 | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | FINAL |  |  | FINAL
Name of Test | Tests Taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate
Superintendent | 5 | 2 |  | 9 | 6 |  | 9 | 7 |  | 9 | 7 |  | 37 | 35 |  | 39 | 36 |  | 16 | 16 |  | 22 | 21 | 0.955 | 18 | 18 | 1 | 18 | 18 | 1 | 18 | 17 | 0.944 | 10 | 10 | 1
*Data obtained from Texas Education Agency's Accountability System for Educator Preparation (ASEP) report on pass rates sorted by Test.
*2010 Texas Education Agency starting using one yearly pass rate.
90
Spreadsheet: 587884d1535370613-off-day-schedule-schedulerotation
Sheet: Employees

Employees | Weekly Off |  | Key Date
Employee1 | 1 |  | 2018-08-27 00:00:00
Employee2 | 2
Employee3 | 3
Employee4 | 4
Employee5 | 5
Employee6 | 1
Employee7 | 2
Employee8 | 3
Employee9 | 4
Spreadsheet: 0a43f52b-e0d7-4c77-87ed-aa72f6280bdb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6202.0 Labour Force, Australia
 | Table 10. Labour force status by Sex - Northern Territory - Trend and Original
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Employed - full-time ;  [NAME] ; |  |  | Trend | A184131L | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Employed - full-time ;  Females ; |  |  | Trend | A184148J | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Employed - full-time ;  Persons ; |  |  | Trend | A184165K | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Employed - total ;  [NAME] ; |  |  | Trend | A184133T | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Employed - total ;  Females ; |  |  | Trend | A184150V | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Employed - total ;  Persons ; |  |  | Trend | [NAME] | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Unemployed - total ;  [NAME] ; |  |  | Trend | A184136X | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Unemployed - total ;  Females ; |  |  | Trend | A184153A | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Unemployed - total ;  Persons ; |  |  | Trend | A184170C | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Unemployment rate ;  [NAME] ; |  |  | Trend | A184143W | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | Percent | PERCENT | Month | 1
Unemployment rate ;  Females ; |  |  | Trend | A184160X | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | Percent | PERCENT | Month | 1
Unemployment rate ;  Persons ; |  |  | Trend | A184177V | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | Percent | PERCENT | Month | 1
Participation rate ;  [NAME] ; |  |  | Trend | A184142V | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | Percent | PERCENT | Month | 1
Participation rate ;  Females ; |  |  | Trend | A184159R | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | Percent | PERCENT | Month | 1
Participation rate ;  Persons ; |  |  | Trend | A184176T | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | Percent | PERCENT | Month | 1
Civilian population ;  [NAME] ; |  |  | Original | A163486J | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Civilian population ;  Females ; |  |  | Original | A163503X | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
Civilian population ;  Persons ; |  |  | Original | A163520A | 1978-02-01 00:00:00 | 2011-01-01 00:00:00 | 396 | 000 | STOCK | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 216629d1361826434-identify-duplicates-and-non-duplicates-within-an-array-match-identify-non-duplicates-bb-
Sheet: Sheet1

 |  | Helper column 1 | Helper column 2 | % from 1st "Y" in each series
 |  |  |  |  |  | In column "C" I need the percentage from column "A" only for the first "Y" in each series.
 |  |  |  |  |  | As an alternative, counting the duplicate "Y" in each series, I can then use a simple formula to pull
 |  |  |  |  |  | the correct percentages over to the next column.
 | N
 |  |  |  |  |  | In column "D", here are the examples of the percentages/non-duplicate indicators that I would need:
-0.02091503267973858 | Y |  |  |  |  | 0
0.1212574850299402 | Y |  |  |  |  | 1
 | N
 | N
 | N
0.04004711425206123 | Y |  |  |  |  | 0
 | N
-0.1400966183574879 | Y |  |  |  |  | 0
-0.06192358366271407 | Y |  |  |  |  | 1
0.1177394034536892 | Y |  |  |  |  | 2
 | N
0.07583774250440913 | Y |  |  |  |  | 0
 | N
 | N
 | N
0.1286644951140065 | Y |  |  |  |  | 0
 | N
 | N
 | N
0.03630862329803318 | Y |  |  |  |  | 0
Spreadsheet: andy_zipper__162__DYNEGY-ICE VOL Apr4
Sheet: ICE-ECC

Enron Canada Corporation
Activity on ICE
UOM | Deals | Volume
 |  |  |  |  |  |  | START | END
Enron Canada Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-4-01 thru Apr-4-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
No Activity
Spreadsheet: 162439d1339876877-search-multiple-spreadsheets-d-report-log-2012-2
Sheet: October 2012

NHSP-W DISCIPLINARY REPORT LOG
D-Report Number | Date | Inmate | Reporting Staff | Violation(s) |  |  |  |  | Date of Disposition | Date of Hearings | Outcome | Sanctions (in days) |  |  |  |  |  |  |  |  |  |  |  | Notes
 |  |  |  |  |  |  |  |  |  |  | PG, FWOP, BS, Inc, FG, FNG | P/S | [NAME] | XD | Lost Cant | Lost Rec | Lost Radio | Lost TV | Lost Phone | Lost Radio | Good Time | Lost Visit | Restitution
10-01
10-02
10-03
10-04
10-05
10-06
10-07
10-08
10-09
10-10
10-11
10-12
10-13
10-14
10-15
10-16
10-17
10-18
10-19
10-20
10-21
10-22
10-23
10-24
10-25
10-26
10-27
10-28
10-29
10-30
10-31
10-32
10-33
10-34
10-35
10-36
10-37
10-38
10-39
10-40
10-41
10-42
10-43
10-44
10-45
10-46
10-47
10-48
10-49
10-50
10-51
10-52
10-53
10-54
10-55
10-56
10-57
10-58
10-59
10-60
10-61
10-62
10-63
10-64
10-65
10-66
10-67
10-68
10-69
10-70
10-71
10-72
10-73
10-74
10-75
10-76
10-77
10-78
10-79
10-80
10-81
10-82
10-83
10-84
10-85
10-86
10-87
10-88
10-89
10-90
10-91
10-92
10-93
10-94
10-95
10-96
10-97
10-98
10-99
Spreadsheet: 90134d1289908657-selecting-last-n-unique-entries-in-range-b5298_test-2-
Sheet: Lookups

Teams
Atlanta
Boston
Charlotte
Chicago
Cleveland
Dallas
Denver
Detroit
Golden State
Houston
Indiana
Los Angeles
Memphis
Miami
Milwaukee
Minnesota
New Jersey
New Orleans
New York
Oklahoma City
Orlando
Philadelphia
Phoenix
Portland
Sacramento
San Antonio
Toronto
Utah
Washington
Spreadsheet: 679152d1590226311-return-ids-of-account-managers-data-source
Sheet: Activities

[NAME] | Contact_Date | Activity_Type | Account_Manager
1 | 2020-05-15 00:00:00 | Meeting | [NAME]
2 | 2020-02-24 00:00:00 | Meeting | [NAME]
3 | 2020-04-01 00:00:00 | [NAME] | Erasmo Morales
4 | 2020-04-18 00:00:00 | [NAME] | Erasmo Morales
5 | 2020-03-24 00:00:00 | [NAME] | Erasmo Morales
6 | 2020-05-05 00:00:00 | [NAME] | Erasmo Morales
7 | 2020-04-04 00:00:00 | [NAME] | Erasmo Morales
8 | 2020-03-03 00:00:00 | [NAME] | Erasmo Morales
9 | 2020-05-10 00:00:00 | [NAME] | Erasmo Morales
10 | 2020-02-20 00:00:00 | [NAME] | Erasmo Morales
11 | 2020-03-09 00:00:00 | LM or VM | [NAME]
12 | 2020-04-12 00:00:00 | [NAME] | [NAME]
13 | 2020-05-14 00:00:00 | [NAME] | [NAME]
14 | 2020-05-05 00:00:00 | [NAME] | [NAME]
15 | 2020-03-07 00:00:00 | [NAME] | [NAME]
16 | 2020-05-06 00:00:00 | [NAME] | [NAME]
17 | 2020-05-10 00:00:00 | [NAME] | [NAME]
18 | 2020-04-25 00:00:00 | [NAME] | [NAME]
19 | 2020-04-21 00:00:00 | [NAME] | [NAME]
Spreadsheet: 821815d1678906612-using-sumproduct-to-calculate-sales-based-on-date-time-and-product-sample-data
Sheet: Sample Data

DASHBOARD |  |  |  |  | 06:00:00
 |  |  |  |  | 05:59:59
Date | Time | Product | Sales |  |  | Sales
2021-10-01 00:00:00 | 23:38:24 | A | 120 |  | 2021-10-01 00:00:00
2021-10-01 00:00:00 | 23:40:38 | B | 125 |  | 2021-10-02 00:00:00
2021-10-01 00:00:00 | 23:43:58 | D | 100 |  | 2021-10-03 00:00:00
2021-10-01 00:00:00 | 23:47:56 | B | 0 |  | 2021-10-04 00:00:00
2021-10-01 00:00:00 | 23:49:59 | D | 0 |  | 2021-10-05 00:00:00
2021-10-01 00:00:00 | 23:51:41 | C | 0
2021-10-02 00:00:00 | 23:31:26 | A | 0 |  | Optimal Table
2021-10-02 00:00:00 | 23:32:49 | D | 102 |  | Date | A | B | C | D
2021-10-02 00:00:00 | 23:33:56 | C | 50 |  | 2021-10-01 00:00:00
2021-10-02 00:00:00 | 23:35:33 | B | 0 |  | 2021-10-02 00:00:00
2021-10-02 00:00:00 | 23:36:02 | A | 0 |  | 2021-10-03 00:00:00
2021-10-02 00:00:00 | 23:36:35 | D | 0 |  | 2021-10-04 00:00:00
2021-10-02 00:00:00 | 23:38:33 | D | 0
2021-10-02 00:00:00 | 23:42:20 | A | 0
2021-10-02 00:00:00 | 23:46:42 | A | 0
2021-10-02 00:00:00 | 23:49:18 | A | 20
2021-10-02 00:00:00 | 23:54:35 | D | 22
2021-10-02 00:00:00 | 23:55:24 | C | 50
2021-10-03 00:00:00 | 23:47:45 | C | 164
2021-10-04 00:00:00 | 23:37:58 | B | 2500
2021-10-04 00:00:00 | 23:39:15 | C | 15
2021-10-04 00:00:00 | 23:45:29 | B | 100
2021-10-04 00:00:00 | 23:46:47 | D | 20
2021-10-04 00:00:00 | 23:52:16 | B | 0
2021-10-04 00:00:00 | 23:53:10 | A | 0
2021-10-05 00:00:00 | 23:36:55 | C | 30
2021-10-05 00:00:00 | 23:45:10 | C | 40
2021-10-05 00:00:00 | 23:56:38 | B | 200
2021-10-05 00:00:00 | 23:59:46 | A | 58
Spreadsheet: 0de0dfcd-f881-4f1a-9a41-c12d95c6f30a
Sheet: Sheet1

 |  |  |  | STAFF AND PHONE RELOCATION FORM
 | DATE:   ____________________ |  |  | DEPARTMENT NAME: ____________________________________
 | Name | Functional Title | Group (by PI | Current Location  (Bldg/Floor/Room(s) | Space Type (Lab, office, etc) | Current Phone #(s) | Future Location (Bldg/Floor/Room(s) | Comment: Status, Sequence
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: c1f9402c-4d68-44c5-b2ca-34d16114abeb
Sheet: UVA CME Import

NPI# | FNAME | LNAME | CREDENTIAL (MD, DO, PhD, RN, etc. ) | AFFILIATION | ZIP | [NAME] | BIRTHDATE (MUST BE FORMATTED with no slashes: MMDDYYYY) | EVENT NAME | EVENT DATE | NUMBER OF CREDITS | Are you a Resident or Fellow? (use caps Y or N) | Are you a UVA Employee?  (use caps Y or N) | Event ID (completed by CME office)
xxxxxxxxxxx | Test | Document | MD | University of Virginia | 22908 | [EMAIL] | 01021975 | Medical Grand Rounds | 2009-07-08 00:00:00 | 1 | N | Y
Spreadsheet: f46cdfee-2e95-49eb-8db7-af3234079053
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4195 | 25761 | Laarni | Anenias | PHI | 0 | [NAME] | 00:00:00 | [NAME] | 00:00:00 | [NAME] | 1 | 10:20:10
Spreadsheet: 886420d1736440902-automatically-pull-rows-to-top-of-sheet-that-contain-matching-cell-information-forum-example-1
Sheet: Re-Schedules

 | Date | Building Name | Reason for rescheudle | Tech
 | 2024-08-07 00:00:00 | KONE | CR was needed to help EE @ Genesis E/W/PAVII to get pumps tested. | CR
 | 2024-08-06 00:00:00 | Bowe Machine | CR went home early, not feeling good. | CR
 | 2024-08-09 00:00:00 | Genesis West (all 3) | Fire pump test flooded basement/1st floor rooms. | EE/CR
 | 2024-08-19 00:00:00 | Macus Theatre (Cedar Rapids) | [NAME] called in sick. | EE
 | 2024-08-19 00:00:00 | Signature Aviation | [NAME] called in sick. | EE
 | 2024-08-19 00:00:00 | Tanager Place - Terry Cottage | [NAME] called in sick. | EE
 | 2024-08-19 00:00:00 | Tanager Place - Sinclair Cottage | [NAME] called in sick. | EE
 | 2024-08-19 00:00:00 | [NAME] | [NAME] called in sick. | EE
 | 2024-08-22 00:00:00 | Von Maur E-Commerce | [NAME] said he could not do both buildings in an 8 hour period. | CR
 | 2024-08-27 00:00:00 | PakSource | [NAME] said he cannot get the pump to work…partial inspection compelted but needs rescheduled. | CR
Spreadsheet: darrell_schoolcraft__7665__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | 2002-01-15 00:00:00
 |  |  | SoCal Gas Price |  | 2.17
 |  |  | San Juan Gas Price |  | 2.05
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
California Gas Day
he 6 | 07:00:00 |  | 0 | 0 | 0 | 505 | 7
he 7 | 08:00:00 |  | 0 | 0 | 0 | 540 | 7
he8 | 09:00:00 |  | 0 | 0 | 0 | 540 | 7
he9 | 10:00:00 |  | 0 | 0 | 0 | 540 | 7
he10 | 11:00:00 |  | 0 | 0 | 0 | 540 | 7
he11 | 12:00:00 |  | 0 | 0 | 0 | 540 | 7
he12 | 13:00:00 |  | 0 | 0 | 0 | 540 | 7
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 540 | 7
he14 | 15:00:00 |  | 0 | 0 | 0 | 540 | 7
he15 | 16:00:00 |  | 0 | 0 | 0 | 540 | 7
he16 | 17:00:00 |  | 0 | 0 | 0 | 540 | 7
he17 | 18:00:00 |  | 0 | 0 | 0 | 540 | 7
he18 | 19:00:00 |  | 0 | 0 | 0 | 540 | 7
he19 | 20:00:00 |  | 0 | 0 | 0 | 540 | 7
he20 | 21:00:00 |  | 0 | 0 | 0 | 540 | 7
he21 | 22:00:00 |  | 0 | 0 | 0 | 540 | 7
he22 | 23:00:00 |  | 0 | 0 | 0 | 540 | 7
he23 | 12:00:00 |  | 0 | 0 | 0 | 505 | 7
he24 | 01:00:00 |  | 0 | 0 | 0 | 505 | 7
he1 | 02:00:00 |  | 0 | 0 | 0 | 505 | 7
he2 | 03:00:00 |  | 0 | 0 | 0 | 505 | 7
he3 | 04:00:00 |  | 0 | 0 | 0 | 505 | 7
he4 | 05:00:00 |  | 0 | 0 | 0 | 505 | 7
[NAME] | 06:00:00 |  | 0 | 0 | 0 | 505 | 7