tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 153194d1335799565-how-to-get-the-total-number-of-days-of-each-person-per-week-number-days-person-week_jpr73
Sheet: Data

Person | Date | Days |  |  | Week 2 | Week 3 | Week 4 | Week 5
[NAME] | 2012-01-02 00:00:00 | 7.5 |  | [NAME]
[NAME] | 2012-01-02 00:00:00 | 4 |  | [NAME]
[NAME] | 2012-01-02 00:00:00 | 1.5 |  | [NAME]
Rachel | 2012-01-02 00:00:00 | 0.5 |  | Rachel
[NAME] | 2012-01-02 00:00:00 | 0.5 |  | [NAME]
Phoebe | 2012-01-02 00:00:00 | 1 |  | Phoebe
[NAME] | 2012-01-03 00:00:00 | 1
[NAME] | 2012-01-03 00:00:00 | 3
[NAME] | 2012-01-03 00:00:00 | 1
Rachel | 2012-01-03 00:00:00 | 7.5
[NAME] | 2012-01-03 00:00:00 | 4
Phoebe | 2012-01-03 00:00:00 | 1
[NAME] | 2012-01-04 00:00:00 | 0.5
[NAME] | 2012-01-04 00:00:00 | 0.5
[NAME] | 2012-01-04 00:00:00 | 1.5
Rachel | 2012-01-04 00:00:00 | 7.5
[NAME] | 2012-01-04 00:00:00 | 5
Phoebe | 2012-01-04 00:00:00 | 0.5
[NAME] | 2012-01-05 00:00:00 | 5.5
[NAME] | 2012-01-05 00:00:00 | 8.5
[NAME] | 2012-01-05 00:00:00 | 6
Rachel | 2012-01-05 00:00:00 | 1
[NAME] | 2012-01-05 00:00:00 | 4
Phoebe | 2012-01-05 00:00:00 | 1
[NAME] | 2012-01-06 00:00:00 | 6.5
[NAME] | 2012-01-06 00:00:00 | 2
[NAME] | 2012-01-06 00:00:00 | 3
Rachel | 2012-01-06 00:00:00 | 1
[NAME] | 2012-01-06 00:00:00 | 0.5
Phoebe | 2012-01-06 00:00:00 | 7.5
[NAME] | 2012-01-09 00:00:00 | 6
[NAME] | 2012-01-09 00:00:00 | 0.5
[NAME] | 2012-01-09 00:00:00 | 1.5
Rachel | 2012-01-09 00:00:00 | 1
[NAME] | 2012-01-09 00:00:00 | 1.5
Phoebe | 2012-01-09 00:00:00 | 1.5
[NAME] | 2012-01-10 00:00:00 | 4
[NAME] | 2012-01-10 00:00:00 | 3.5
[NAME] | 2012-01-10 00:00:00 | 1
Rachel | 2012-01-10 00:00:00 | 1.5
[NAME] | 2012-01-10 00:00:00 | 2
Phoebe | 2012-01-10 00:00:00 | 7.5
[NAME] | 2012-01-18 00:00:00 | 1.5
[NAME] | 2012-01-18 00:00:00 | 1
[NAME] | 2012-01-18 00:00:00 | 1.5
Rachel | 2012-01-18 00:00:00 | 2
[NAME] | 2012-01-18 00:00:00 | 7.5
Phoebe | 2012-01-18 00:00:00 | 1.5
[NAME] | 2012-01-20 00:00:00 | 3
[NAME] | 2012-01-20 00:00:00 | 1
[NAME] | 2012-01-20 00:00:00 | 4
Rachel | 2012-01-20 00:00:00 | 7.5
[NAME] | 2012-01-20 00:00:00 | 7
Phoebe | 2012-01-20 00:00:00 | 3
[NAME] | 2012-01-24 00:00:00 | 5.5
[NAME] | 2012-01-24 00:00:00 | 6
[NAME] | 2012-01-24 00:00:00 | 2
Rachel | 2012-01-24 00:00:00 | 3.5
[NAME] | 2012-01-27 00:00:00 | 1.5
Phoebe | 2012-01-27 00:00:00 | 1
Spreadsheet: 2a5f8741-6d77-4cb2-9577-12bbf80745fd
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Curb Records | [PHONE] | [NAME] | Be Still My Soul | 2001-01-16 | Compact Disc | Ac Pop | 7.99 | Y | Available
Curb Records | [PHONE] | [NAME] | Press On | 2001-05-29 | Compact Disc | Insp | 5.99 | Y | Available
Curb Records | [PHONE] | [NAME] | Hiding Place | 2004-05-25 | Compact Disc | Insp | 7.99 | Y | Available
Curb Records | [PHONE] | [NAME] | Hiding Place | 2004-09-28 | Distributed CD Trax | Ac | 9.98 | N | To Be Retired
Curb Records | [PHONE] | [NAME] | Greatest Hymns ([NAME]) | 2005-08-23 | Compact Disc | Ac | 9.99 | Y | Available
Curb Records | [PHONE] | [NAME] | Bless The Broken Road: The Duets Album | 2006-08-08 | Compact Disc | Insp | 9.99 | Y | Available
Curb Records | [PHONE] | [NAME] | Bless The Broken Road | 2006-06-27 | Distributed CD Trax | Ac | 9.98 | N | To Be Retired
Curb Records | [PHONE] | [NAME] | Rescue Me | 2008-02-12 | Distributed CD Trax | Insp | 9.99 | N | To Be Retired
Curb Records | [PHONE] | [NAME] | You Deliver Me | 2009-08-25 | Compact Disc | Insp | 9.99 | Y | Available
Curb Records | [PHONE] | [NAME] | Beautiful Terrible Cross | 2009-08-25 | Distributed CD Trax | Insp | 9.99 | N | To Be Retired
Print Music, Word Owned * | [PHONE] | [NAME] | You Deliver Me | 2009-12-08 | Vocal Folio | Na | 24.95 | Y | Available
Print Music, Word Owned * | [PHONE] | [NAME] | [NAME], The | 2008-05-03 | Vocal Folio | Na | 24.95 | Y | Available
Print Music, Word Owned * | [PHONE] | [NAME] | Greatest Hymns | 2005-09-24 | Vocal Folio | Na | 22.95 | Y | Available
Print Music, Word Owned * | [PHONE] | [NAME] | [NAME], The | 2002-01-23 | Vocal Folio | Na | 24.95 | Y | Available
Print Music, Word Owned * | [PHONE] | [NAME] | Bless The Broken Road: The Duets Album | 2006-10-06 | Vocal Folio | Na | 22.95 | Y | Available
Curb Records | [PHONE] | [NAME] | Hope Of The Broken World | 2011-08-23 | Compact Disc | Insp | 13.99 | Y | Available
Print Music, Word Owned * | [PHONE] | [NAME] | Hope Of The Broken World | 2011-10-25 | Vocal Folio | Na | 22.95 | Y | Available
Curb Records | 715187872028BB | [NAME] | Rose Of Bethlehem (Bargain Bin) | 2014-10-28 | Compact Disc | Ac Pop | 5.99 | N | Available
Curb Records | [PHONE] | [NAME] | You [NAME] | 2014-08-19 | Compact Disc | Insp | 13.99 | Y | Available
Spreadsheet: 866868d1713791668-false-result-from-deeply-nested-if-formula-financial-chart-example-v1
Sheet: Proj A

PoP Start | PoP End |  | Proj A
2022-08-10 00:00:00 | 2023-12-31 00:00:00
Today Fx
Today Month
Today Year
Delete those dates that do not align to any data |  |  | Placeholder, change formula when ready | Placeholder, change formula when ready | fix top formula by deleting +REF! | fix top formula by deleting +REF! | fix by choosing last cell visible in top formula | Placeholder, change formula when ready | Placeholder, change formula when ready
Month | FY Date of Occurrence | Qtr / FY Date of Occurrence | Contracted / Obligated | Expenditures | Obligated | Expended | Unexpended | APPN | APPN FY | APPN Life | Period of Availability | APPN Status
2022-08-31 00:00:00 |  |  |  | 0 |  |  |  | RDT&E
2022-09-30 00:00:00 |  |  |  | 0
2022-10-31 00:00:00 |  |  |  | 0
2022-11-30 00:00:00 |  |  |  | 0
2022-12-31 00:00:00 |  |  |  | 0 |  |  |  | RDT&E
2023-01-31 00:00:00 |  |  |  | 0
2023-02-28 00:00:00 |  |  |  | 0
2023-03-31 00:00:00 |  |  |  | 0
2023-04-30 00:00:00 |  |  |  | 1137451.26
2023-05-31 00:00:00 |  |  |  | 1137451.25 |  |  |  | RDT&E
2023-06-30 00:00:00 |  |  |  | 0
2023-07-31 00:00:00 |  |  |  | 0 |  |  |  | O&M
2023-08-31 00:00:00 |  |  |  | 1549976.48 |  |  |  | RDT&E
2023-09-30 00:00:00 |  |  |  | 774988.24 |  |  |  | RDT&E
2023-10-31 00:00:00 |  |  |  | 853594.67
2023-11-30 00:00:00 |  |  |  | 869410.28 |  |  |  | RDT&E
2023-12-31 00:00:00 |  |  |  |  |  |  |  | RDT&E
2024-01-31 00:00:00 |  |  |  | 1707189.33
2024-02-29 00:00:00
2024-03-31 00:00:00
2024-04-30 00:00:00
2024-05-31 00:00:00
2024-06-30 00:00:00
2024-07-31 00:00:00
2024-08-31 00:00:00
2024-09-30 00:00:00
2024-10-31 00:00:00
2024-11-30 00:00:00
2024-12-31 00:00:00
Spreadsheet: 438087d1451743056-putting-data-in-another-worksheet-another-worksheet
Sheet: Sheet1

Day | Date | Day Off
vrijdag | 2016-01-01 00:00:00
zaterdag | 2016-01-02 00:00:00 |  |  |  |  | zaterdag
zondag | 2016-01-03 00:00:00 |  |  |  |  | zondag
maandag | 2016-01-04 00:00:00 |  |  |  |  | 2016-01-01 00:00:00
dinsdag | 2016-01-05 00:00:00 |  |  |  |  | 2016-12-25 00:00:00
woensdag | 2016-01-06 00:00:00
donderdag | 2016-01-07 00:00:00
vrijdag | 2016-01-08 00:00:00
zaterdag | 2016-01-09 00:00:00
zondag | 2016-01-10 00:00:00
maandag | 2016-01-11 00:00:00
dinsdag | 2016-01-12 00:00:00
woensdag | 2016-01-13 00:00:00
donderdag | 2016-01-14 00:00:00
vrijdag | 2016-01-15 00:00:00
zaterdag | 2016-01-16 00:00:00
zondag | 2016-01-17 00:00:00
maandag | 2016-01-18 00:00:00
dinsdag | 2016-01-19 00:00:00
woensdag | 2016-01-20 00:00:00
donderdag | 2016-01-21 00:00:00
vrijdag | 2016-01-22 00:00:00
zaterdag | 2016-01-23 00:00:00
zondag | 2016-01-24 00:00:00
maandag | 2016-01-25 00:00:00
dinsdag | 2016-01-26 00:00:00
woensdag | 2016-01-27 00:00:00
donderdag | 2016-01-28 00:00:00
vrijdag | 2016-01-29 00:00:00
zaterdag | 2016-01-30 00:00:00
zondag | 2016-01-31 00:00:00
maandag | 2016-02-01 00:00:00
dinsdag | 2016-02-02 00:00:00
woensdag | 2016-02-03 00:00:00
donderdag | 2016-02-04 00:00:00
Spreadsheet: 77075d1277507635-sort-by-number-of-repeating-values-sortrepeatrms
Sheet: Sheet2

Last name | First name | Room # | Repeat Rms
a | b1 | 1 | 3
b | b2 | 2 | 2
c | b3 | 1 | 3
d | b4 | 4 | 4
e | [NAME] | 1 | 3
f | b6 | 6 | 1
g | b7 | 7 | 1
h | b8 | 8 | 1
i | b9 | 2 | 2
j | b10 | 10 | 2
k | b11 | 11 | 1
l | b12 | 3 | 2
m | b13 | 13 | 1
n | b14 | 3 | 2
o | b15 | 15 | 1
p | b16 | 4 | 4
q | b17 | 4 | 4
r | b18 | 4 | 4
s | b19 | 19 | 1
t | b20 | 10 | 2
Spreadsheet: louise_kitchen__24241__July Orig w notes
Sheet: All Originators by Value

Enron North America
Originations
For the Month Ended July 31, 2001
Originator |  | Commodity |  | Team |  | Total |  | %Total
[NAME] |  | Power |  | West Power |  | 6410047
[NAME] |  | Power |  | Development |  | 2438000
Kroll |  | Power |  | Southeast Power |  | 1689520
Valderama |  | Power |  | Midwest Power |  | 189300
Davies |  | Power |  | Canada |  | 173000
[NAME] |  | Power |  | Northeast Power |  | 80000
Sewell |  | Power |  | Midwest Power |  | 62000
Schener |  | Power |  | Northeast Power |  | 50000
Curry |  | Power |  | [NAME] |  | 40000
[NAME] |  | Power |  | Southeast Power |  | 23632
[NAME] |  | Power |  | Northeast Power |  | 20000
Wheeler |  | Power |  | Northeast Power |  | 10000
Wheeler |  | Power |  | Midwest Power |  | 8800
Valderama |  | Power |  | Northeast Power |  | 8200
Wood |  | Power |  | Northeast Power |  | 5000
Acevedo |  | Power |  | Southeast Power |  | 4500
Braddock |  | Power |  | Southeast Power |  | 3500
[NAME] |  | Power |  | Southeast Power |  | -54615
Tycholiz |  | Gas |  | West Gas |  | 1245865
[NAME] |  | Gas |  | Derivatives |  | 958135
[NAME] |  | Gas |  | West Gas |  | 622091
Ward |  | Gas |  | West Gas |  | 572651
[NAME] |  | Gas |  | Mexico |  | 504604
Smith, [NAME] |  | Gas |  | Derivatives |  | 482838
Lucci |  | Gas |  | West Gas |  | 363933
[NAME] |  | Gas |  | Canada |  | 334057
Abramo |  | Gas |  | Derivatives |  | 312911
Black |  | Gas |  | Derivatives |  | 259026
Smith. Sara |  | Gas |  | Gas Assets |  | 247870
Sangwine |  | Gas |  | Canada |  | 227075
[NAME] |  | Gas |  | Derivatives |  | 214634
Otto |  | Gas |  | Derivatives |  | 200816
Fuller |  | Gas |  | West Gas |  | 137683
Le Dain |  | Gas |  | Canada |  | 129997
Whitt |  | Gas |  | West Gas |  | 125272
Lagrasta |  | Gas |  | Derivatives |  | 105950
Ferries |  | Gas |  | East Gas |  | 99787
Pollan |  | Gas |  | Central Gas |  | 87663
[NAME] |  | Gas |  | Canada |  | 78971
Hrap |  | Gas |  | Canada |  | 56305
Oh |  | Gas |  | Canada |  | 50042
Breslau |  | Gas |  | Derivatives |  | 38668
Titus |  | Gas |  | Derivatives |  | 36430
Shipos |  | Gas |  | Derivatives |  | 30332
Figueroa |  | Gas |  | Derivatives |  | 29726
[NAME] |  | Gas |  | Derivatives |  | 29707
Depaolis |  | Gas |  | East Gas |  | 29515
Barbe |  | Gas |  | East Gas |  | 28298
Burnham |  | Gas |  | Canada |  | 26409
Frihart |  | Gas |  | Central Gas |  | 25620
Goodell |  | Gas |  | East Gas |  | 20657
Singer |  | Gas |  | East Gas |  | 12630
Ortiz |  | Gas |  | Derivatives |  | 11505
Barbe |  | Gas |  | Derivatives |  | 7600
Laporte |  | Gas |  | Canada |  | 4021
Staab |  | Gas |  | West Gas |  | 3013
Singer |  | Gas |  | Derivatives |  | 1812
[NAME] |  | Gas |  | East Gas |  | 1317
Giron |  | Gas |  | Central Gas |  | 1250
[NAME] |  | Gas |  | Texas Gas |  | 1240
Smith, [NAME] |  | Gas |  | East Gas |  | 574
Breglam |  | Gas |  | Derivatives |  | 273
Martinez |  | Gas |  | East Gas |  | 232
[NAME] |  | Gas |  | East Gas |  | 62
Total
Spreadsheet: 852654d1702610197-excel-formula-to-separate-name-in-two-columns-separating-names-2-
Sheet: Tax schedule

KINDLY ASKING FOR EXCEL FORMULA TO SEPARATE NAME INTO SURNAME AND FIRST NAME IN TWO COLUMNS AND MATCH THE I.D NUMBR, FISCAL YEAR AND DATE OF BIRTH
USE INFORMATION IN EMPLOYEES SHEEET
Surname | First Name | I.D | Fiscal Year | Date of Birth
 | [NAME] | 08-965660 G73 | 2023 | [NAME]
[NAME] | [NAME] | 79-2013160 T79 | 2023 | 03/03/2003
Johns | Cain | 08-2101012 E39 | 2023 | 10/06/2003
Spreadsheet: 133299d1324322891-data-summary-by-date-copy-of-data-example
Sheet: Sheet3

 | M | T | W | T | F | S
Date: | 2011-12-05 00:00:00 | 2011-12-06 00:00:00 | 2011-12-07 00:00:00 | 2011-12-08 00:00:00 | 2011-12-09 00:00:00 | 2011-12-10 00:00:00
SKU's On Hand
Inventory On Hand
Cycle Count Accuracy
Orders not filled
Lines not filled
Controllable ship error
Non-controllable ship error
Spreadsheet: 0f29956d-9ad3-441b-8ebc-9f56c0c8e62f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
No | Service | Destination |  |  |  |  | Frequency
1 | Korea | Pusan, Pyongtaek |  |  |  |  | Wed | Thu | Sat
 |  | Kwangyang |  |  |  |  | Wed | Thu | Sat
 |  | Inchon |  |  |  |  | Thu | Sat
2 | Singapore | Singapore |  |  |  |  | Sun
3 | China | Hongkong |  |  |  |  | Thu | Sat
 |  | Qingdao |  |  |  |  | Sat
 |  | Shanghai |  |  |  |  | Wed | Thu | Sat
4 | Taiwan | KAOHSIUNG |  |  |  |  | Wed | Thu
 |  | Taichung, Keelung |  |  |  |  | Tue
5 | Thailand | [NAME] |  |  |  |  | Sat
6 | Malaysia | [NAME] |  |  |  |  | Sun
7 | Philippines | Manila |  |  |  |  | Thu
8 | Japan | Shibushi, Niigata |  |  |  |  | Wed | Sat
 |  | Himeji,[NAME], Tokuyama, Tokyo, Yokkaichi,
 |  | Naoetsu, Toyama Shinko, Osaka, Kobe,
 |  | Yokohama, Nagoya
9 | South China | Dalian, Shantou, Xiamen, Huizhou, Foshan |  |  |  |  | Wed | Sat
 |  | Huangpu, Quanzhou, Fuqing, Shunde, Fangcheng
9 | India | [NAME], Karachi, [NAME] |  |  |  |  | Sun
9 | Taiwan | Taichung, Keelung |  |  |  |  | Fri
10 | Australia | Brisbane , Sydney , & Meibourne |  |  |  |  | Sun
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R47

Ime artikla
Spreadsheet: 159134d1338510031-count-the-number-of-unique-values-given-certain-conditions-count-of-unique-phone-numbers
Sheet: Sheet1

Name | Month | direction of call | Number |  |  | how many unique calls were made by each person in August? | description of results
[NAME] | August | Outbound | 5551234567 |  | [NAME] | 6 | [NAME] made 7 total calls in august to 6 unique phone numbers ([NAME], August, outbound)
[NAME] | August | Outbound | 5551234567 |  | [NAME] | 3 | [NAME] made 3 total calls in august to 3 unique phone numbers ([NAME], August, outbound)
[NAME] | August | Outbound | 6661234567 |  | erin | 2 | erin made 5 total calls in august to 2 unique phone numbers (erin, August, outbound)
[NAME] | August | Outbound | 8881234567
[NAME] | August | Outbound | 9991234567
[NAME] | August | Outbound | 4441234567
[NAME] | August | Outbound | 3331234567
[NAME] | August | Inbound | 2221234567
[NAME] | August | Inbound | 2221234567
[NAME] | August | Inbound | 2221234567
[NAME] | August | Inbound | 8881234567
[NAME] | August | Inbound | 9991234567
[NAME] | August | Inbound | 4441234567
[NAME] | August | Inbound | 3331234567
[NAME] | August | Outbound | 8591234567
[NAME] | August | Outbound | 4041234567
[NAME] | August | Outbound | 2141234567
[NAME] | August | Inbound | 8591234567
[NAME] | August | Inbound | 8591234567
[NAME] | August | Inbound | 2141234567
erin | August | Outbound | 5131234567
erin | August | Outbound | 5131234567
erin | August | Outbound | 6141234567
erin | August | Outbound | 6141234567
erin | August | Outbound | 6141234567
erin | August | Inbound | 2221234567
erin | August | Inbound | 5131234567
erin | August | Inbound | 6141234567
erin | August | Inbound | 6141234567
erin | August | Inbound | 6141234567
[NAME] | September | Outbound | 5551234567
[NAME] | September | Outbound | 5551234567
[NAME] | September | Outbound | 6661234567
[NAME] | September | Outbound | 8881234567
[NAME] | September | Outbound | 9991234567
[NAME] | September | Outbound | 4441234567
[NAME] | September | Outbound | 3331234567
[NAME] | September | Inbound | 2221234567
[NAME] | September | Inbound | 2221234567
[NAME] | September | Inbound | 2221234567
[NAME] | September | Inbound | 8881234567
[NAME] | September | Inbound | 9991234567
[NAME] | September | Inbound | 4441234567
[NAME] | September | Inbound | 3331234567
[NAME] | September | Outbound | 8591234567
[NAME] | September | Outbound | 4041234567
[NAME] | September | Outbound | 2141234567
[NAME] | September | Inbound | 8591234567
[NAME] | September | Inbound | 8591234567
[NAME] | September | Inbound | 2141234567
erin | September | Outbound | 5131234567
erin | September | Outbound | 5131234567
erin | September | Outbound | 6141234567
erin | September | Outbound | 6141234567
erin | September | Outbound | 6141234567
erin | September | Inbound | 2221234567
erin | September | Inbound | 5131234567
erin | September | Inbound | 6141234567
erin | September | Inbound | 6141234567
erin | September | Inbound | 6141234567
Spreadsheet: 476799d1472032567-assistance-with-multiple-if-conditions-time-test
Sheet: Sheet1

 | Dept | LAB or GEN |  | Currently I'm worling of prefix Dept using [NAME] based on the employe name
Note: Employee - please update the yellow cells only |  | RECORD OF HOURS OF |  |  |  |  | RECORD OF HOURS PAID AND LEAVE TAKEN
 |  | [NAME] |  |  |  |  | Normal |  |  | Overtime
Day | Date | Start Time (In) | Finish Time (Out) | Total Hours of Attendance | Allocated Meal Break | Rostered On (Y/N) | Normal Hours | [NAME],  If any? (+ or _) | Total Ordinary Hours to be Paid | Total Approved Overtime (Hours)
Wednesday | 2016-08-17 00:00:00 | 08:00:00 | 16:36:00 |  | 1 | Yes |  | 0 |  | 0 | Mon - Sat houre 8
Thursday | 2016-08-18 00:00:00 | 08:00:00 | 16:36:00 |  | 1 | Yes |  | 0 |  | 0 | Sat 2  ovt  8 + 2 OT
Friday | 2016-08-19 00:00:00 | 08:00:00 | 16:36:00 |  | 1 | Yes |  | 0 |  | 0 | Sun -6 hrs
Saturday | 2016-08-20 00:00:00 | 00:00:00 | 00:00:00 |  | 0 | No |  | 0 |  | 0
Sunday | 2016-08-21 00:00:00 | 00:00:00 | 00:00:00 |  | 0 | No |  | 0 |  | 0
Monday | 2016-08-22 00:00:00 | 08:00:00 | 16:36:00 |  | 1 | Yes |  | 0 |  | 0
Tuesday | 2016-08-23 00:00:00 | 08:00:00 | 16:36:00 |  | 1 | Yes |  | 0 |  | 0
 | Conditions to build
 |  | if they are on Roaster | the are paid on the below  else  0
 |  | Dept | Reg- Hr | Reg- Hr | Reg- Hr | any additional HR
 |  |  | Mon - Fri | Mon - Sat | Sun | Overtime
 | 1 | LAB | 0 | 8 | 6 | YES
 | 2 | GEN | 7.6 | 0 | 0 | NIL - OT
 | 3 | FIN | 7.6 | 0 | 0 | NIL - OT
 | 4 | MGT | 7.6 | 0 | 0 | NIL - OT
Spreadsheet: 811145d1672309775-apply-formula-only-filtered-data-sample
Sheet: Sheet1

 | NAME | FORMULA | AFTER FILTER RESULT SHOULD BE LIKE BELOW
 | ABDUL |  | 1
 | AFAAQ |  | 2
 | DEVID |  | 1
 | SMITH
 | SMITH
 | SMITH
 | CHAND |  | 2
 | CHAND |  | 2
 | YUSUF |  | 1
 | YUSUF |  | 1
 | YUSUF |  | 1
 | YUSUF |  | 1
 | BARNER |  | 2
 | BARNER |  | 2
 | EXTRA
 | EXTRA
 | EXTRA
 | EXTRA
 | EXTRA
 | FAIZ |  | 1
Spreadsheet: 776502d1649764003-index-and-match-to-search-column-headers-and-return-total-example
Sheet: Data

 | PAYMENTS
 | Basic Payments (Salary etc)
 | PE ID 7000 | PE ID 5005 | PE ID 5006 | PE ID 5010 | PE ID 5011 | PE ID 5200 | PE ID 5220 | PE ID 7500 | PE ID 7500
 | Example 1 | Example 2 | Example 3 | Example 4 | Example 1 | Example 2 | Example 5 | Example 6 | Example 10
Total | 1000 | 2000 | 3000 | 4000 | 5000 | 6000 | 7000 | 8000 | 10000
Spreadsheet: 116524d1311878402-selective-columns-handicapscorecards-master
Sheet: Cards

Baxter. [NAME] |  | Handicap |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Handicap | Exact | Category | Buffer Zone | CSS | Nett Differential | Adjustment | Adjustment | Reduction per Shot
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tee |  |  |  | Current
HOLE > |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IN | OUT | Total
Par |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New |  |  |  | sss | css adj
Stroke Index |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SSS
Handicap Adjusted Par
Strokes added for Handicap
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett
Strokes
Nett Par
[NAME]
PAR 3 points
Tie breakers by S/I
INDEX 1
INDEX 2
INDEX 3
INDEX 4
INDEX 5
INDEX 6
INDEX 7
INDEX 8
INDEX 9
INDEX 10
INDEX 11
INDEX 12
INDEX 13
INDEX 14
INDEX 15
INDEX 16
INDEX 17
INDEX 18
Spreadsheet: chris_dorland__1627__FUZZY_SWAP
Sheet: SWAPTIONS

SWAPTION MODEL
 | INPUTS |  |  | OUTPUTS
 | STRIKE | 1.9 |  | CALL |  | CALL DELTA
 | SWAP MID | 1.94 |  | Premium
 | VOLATILITY | 0.15 |  | PV Value
 | EXP. DATE | 2001-12-15 00:00:00
 | USD=1, [NAME] | 1 |  | PUT |  | PUT DELTA
 | Swap Start | 2002-01-01 00:00:00 |  | Premium
 | Swap End | 2002-06-01 00:00:00 |  | PV Value
 | TIME TO MAT.
 | TODAY
 | Volume | 5000
 | CND R | CDN DF | USD R | USD DF | VOLUME | PV VOLUME | DAYS | TOGGLE |  | DAYS
 |  |  |  |  |  |  |  |  | DAYS
 |  |  |  |  | SUM PV VOL
CALL SWAPTION |  |  |  |  |  | PUT SWAPTION
d1 | d2 | Nd1 | Nd2 | Premium | PV Value | N(-d1) | N(-d2) | Premium | PV Value
USD R |  | TIME YRS
CND R |  | h
R
Spreadsheet: 05019691-cbe7-4251-9629-d1b7e4ad416c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | First term | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | Speaker | Affiliation | Host | Title
October | 5 | [NAME] | Academia Sinica | [NAME] | Genes and Speciation: What can we learn from yeast?
 | 12 | CEE grant symposium |  |  | TBA
 | 19 | Galton Inaugural Lecture to be given by Prof Nick Wood (Venue: Cruciform LT 1) | UCL | [NAME]/[NAME] | Neurological disease: Nature and Nurture
 | 26 | Susane Ozanne | Cambridge | Lazaros Foukas | The developmental origins of metabolic health'
November | 2 | [NAME] | Hull York Medical School | [NAME] | ‘Evolutionary, ecological and biogeographic influences on the radiation of red colobus monkeys in Africa’
 | 9 | [NAME] | Exeter | [NAME] | Understanding microbial evolution: system-specific models do produce general insights'
 | 16 | Grant lecture ([NAME]) | UCL
 | 23 | [NAME] | Oxford | [NAME] | Comparative genomics and animal evolution'
December | 7 | [NAME] lecture ([NAME])
 | 14 | [NAME] | Bristol | [NAME] | Restoration Ecology: fact, fantasy and reality'
Spreadsheet: 268320d1380563812-sum-of-the-working-hours-for-a-person-total-working-hours
Sheet: Sheet1

User | Work Time | need the total output of [NAME]
[NAME] | 0.3
 | 0.5
 | 1
 | 1.5
 | 2.5
 | 3
[NAME] | 5
 | 4.5
[NAME] | 0.25
 | 0.25
 | 0.75
 | 0.3
 | 2.5
 | 3.5
Spreadsheet: 328726d1404048091-excel-cell-color-background-shading-using-if-statements-calendar-months
Sheet: Sheet2

 | Month | School Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. of Students:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days:
 |  |  |  | M | T | W | TH | F | M | T | W | TH | F | M | T | W | TH | F | M | T | W | TH | F | M | T | W | TH | F
Name (Boys) |  |  |  | 2014-06-02 00:00:00 | 2014-06-03 00:00:00 | 2014-06-04 00:00:00 | 2014-06-05 00:00:00 | 2014-06-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-06-30 00:00:00 |  |  |  |  |  | Absents | Tardy
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
Total Enrollment for year to date:
Total Enrollment for month to date:
Attendance Totals: |  |  | AM
 |  |  | PM
 | Month | School Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. of Students:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days:
 |  |  |  | M | T | W | TH | F | M | T | W | TH | F | M | T | W | TH | F | M | T | W | TH | F | M | T | W | TH | F
Name (Boys) |  |  |  | 2014-06-02 00:00:00 | 2014-06-03 00:00:00 | 2014-06-04 00:00:00 | 2014-06-05 00:00:00 | 2014-06-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-06-30 00:00:00 |  |  |  |  |  | Absents | Tardy
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
Total Enrollment for year to date:
Total Enrollment for month to date:
Attendance Totals: |  |  | AM
 |  |  | PM