tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 41321d1239804257-nested-if-limit-exceeded-nestediflimit
Sheet: Sheet1

 |  |  |  |  | Data | O/p
 |  |  |  |  |  | 1
 |  |  |  |  | 20 | 1
 |  |  |  |  | 20 | 1
 |  |  |  |  | 0 | 0
 |  |  |  |  | 20 | -1
 |  | The formula in the cells in column G make the O/p figure change from 1 to -1 (or vice versa) after a 0 is encountered in column F. However, if there are 2 consecutive zeros in F then the formula fails (see F26 & F27) and all subsequent figures in column G are zero. |  |  | 20 | -1
 |  |  |  |  | 20 | -1
 |  |  |  |  | 20 | -1
 |  |  |  |  | 0 | 0
 |  |  |  |  | 20 | 1
 |  |  |  |  | 20 | 1
 |  |  |  |  | 0 | 0
 |  |  |  |  | 20 | -1
 |  |  |  |  | 20 | -1
 |  |  |  |  | 0 | 0
 |  |  |  |  | 18 | 1
 |  | I've tried allowing for consectutive zeros but then come up against the nested IF limit. Ideally I would like this to work with any number of consecutive zeros, although in reality 5 would probably be the maximum. I could sort this with a macro but would prefer to make it automatic so that no user intervention is necessary. |  |  | 20 | 1
 |  |  |  |  | 20 | 1
 |  |  |  |  | 20 | 1
 |  |  |  |  | 0 | 0
 |  |  |  |  | 20 | -1
 |  |  |  |  | 20 | -1
 |  |  |  |  | 20 | -1
 |  |  |  |  | 20 | -1
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 20 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 20 | 0
 |  |  |  |  | 20 | 0
 |  |  |  |  | 20 | 0
Spreadsheet: 833486d1687006018-calculate-multiple-start-and-end-time-start-and-end-time-ans
Sheet: Sheet1

DATE |  |  | Start | End
2023-01-06 00:00:00
2023-01-06 00:01:00
2023-01-06 00:02:00
2023-01-06 00:03:00
2023-01-06 00:04:00
2023-01-06 00:05:00
2023-01-06 00:06:00
2023-01-06 00:07:00
2023-01-06 00:08:00
2023-01-06 00:10:00
2023-01-06 00:11:00
2023-01-06 00:12:00
2023-01-06 00:13:00
2023-01-06 00:14:00
2023-01-06 00:15:00
2023-01-06 00:16:00
2023-01-06 00:17:00
2023-01-06 00:18:00
2023-01-06 00:19:00
2023-01-06 00:20:00
2023-01-06 00:22:00
2023-01-06 00:23:00
2023-01-06 00:24:00
2023-01-06 00:25:00
2023-01-06 00:26:00
2023-01-06 00:27:00
2023-01-06 00:28:00
2023-01-06 00:29:00
2023-01-06 00:30:00
2023-01-06 00:31:00
2023-01-06 00:32:00
2023-01-06 00:33:00
2023-01-06 00:34:00
2023-01-06 00:35:00
2023-01-06 00:36:00
2023-01-06 00:37:00
2023-01-06 00:38:00
2023-01-06 00:39:00
2023-01-06 00:40:00
2023-01-06 00:41:00
2023-01-06 00:42:00
2023-01-06 00:43:00
2023-01-06 00:44:00
2023-01-06 00:45:00
2023-01-06 00:46:00
2023-01-06 00:47:00
2023-01-06 00:48:00
2023-01-06 00:49:00
2023-01-06 00:50:00
2023-01-06 00:51:00
2023-01-06 00:52:00
2023-01-06 00:53:00
2023-01-06 00:54:00
2023-01-06 00:55:00
2023-01-06 00:56:00
2023-01-06 00:57:00
2023-01-06 00:58:00
2023-01-06 00:59:00
Spreadsheet: 62df7b57-2586-4dc4-814e-4dfb95db3673
Sheet: Sheet1

2014 General Election - UNOFFICIAL RESULTS | Unnamed: 1 | Unnamed: 2
State of North Dakota Results
Precincts Reporting: 0/427 - Total Ballots Cast: 0
Downloaded at 10/2/2014 7:26:07 AM
 | Yes - | No -
Constitutional Measure No. 1 Relating to the inalienable rights to life of every human being at every stage of development. | 0 | 0
 | Yes - | No -
Constitutional Measure No. 2 Relating to the prohibition of the imposition of mortgage taxes or any sales or transfer taxes on the mortgage or transfer of real property. | 0 | 0
 | Yes - | No -
Constitutional Measure No. 3 Relating to repealing the existing Board of Higher Education and to creating a three member commission of higher education appointed by the Governor. | 0 | 0
 | Yes - | No -
Constitutional Measure No. 4 Relating to the fiscal impact of measures to initiate constitutional amendments and to the placing of initiated measures on the ballot | 0 | 0
 | Yes - | No -
Initiated Constitutional Measure No. 5 Constitutional Petition Related to a Clean Water, Wildlife, and Parks Trust and a Clean Water, Wildlife, and Parks Fund | 0 | 0
 | Yes - | No -
Initiated Statutory Measure No. 6 Relating to Parental Rights and Responsibilities | 0 | 0
 | Yes - | No -
Initiated Statutory Measure No. 7 Relating to the Operation of a Pharmacy | 0 | 0
 | Yes - | No -
Initiated Statutory Measure No. 8 Statutory Petition Related to School Classes Beginning After Labor Day | 0 | 0
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 005be912-0fbe-4bcd-9a20-ffef1cadcc27
Sheet: Sheet1

Unnamed: 0 | FRI 9:45 | FRI 17:30 | SAT 9:45 | SAT 17:30 | SUNDAY 9:45 | SUN 16:30
Referee | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Referee | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Shadow Referee |  |  | [NAME] | [NAME]
Starter | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Stroke Judge | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Stroke Judge | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Stroke Judge | June Traill | June Traill | Hilary Idzikowska | Hilary Idzikowska | [NAME] | [NAME]
Stroke Judge | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Turn Judge [NAME] | UCD | Aer Lingus | Ennis | Waterford Crystal | [NAME] | [NAME]
Turn Judge [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Turn Judge [NAME] | [NAME] | [NAME] | Nichola Power | Nichola Power | [NAME] | [NAME]
Turn Judge [NAME] | Hilary Idzikowska | Hilary Idzikowska | [NAME] | [NAME] | [NAME] | [NAME]
Turn Judge [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Turn Judge [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | June Traill
Turn Judge [NAME] | [NAME] | Castlebar | June Traill | June Traill | June Traill | [NAME]
Turn Judge T8 | Waterford Crystal | Athlone | [NAME] | [NAME] | [NAME] | Aer Lingus
Turn Judge [NAME] | Ards | Ennis | Bangor | UCD | UCD | Ards
Turn Judge [NAME] | [NAME] | [NAME] | [NAME] | Trojan | [NAME] | [NAME]
Turn Judge [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Turn Judge [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Turn Judge S5 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Turn Judge S6 | [NAME] | Invictus | [NAME] | [NAME] | [NAME] | [NAME]
Turn Judge S7 | Ennis | ESB | Banbridge | Templeogue | Nichola Power | Banbridge
Turn Judge S8 | Banbridge | Galway | Athlone | Tallaght | Ennis | Bangor
Timekeeper L1 | Bangor | Glenalbyn | Ards | Shark | Athlone | Invictus
Timekeeper L2 | Invictus | Trojan | Aer Lingus | NAC | Galway | [NAME]
Timekeeper L3 | [NAME] | Limerick | Castlebar | Limerick | Bangor | [NAME]
Timekeeper L4 | [NAME] | Longford | Coolmine | Invictus | Limerick | Lisburn
Timekeeper L5 | Lisburn | Mallow | Kilkenny | Templemore | Longford | Templemore
Timekeeper L6 | NAC | [NAME] | [NAME] | Sundays Well | Shark | ESB
Timekeeper L7 | Galway | Shark | Longford | Lisburn | Mallow | Glenalbyn
Timekeeper L8 | Glenalbyn | Sundays Well | Mallow | [NAME] | Sundays Well | Tallaght
Call Steward | [NAME] | Tallaght | [NAME] | Glenalbyn | Waterford Crystal | Templeogue
Call Steward | Lisburn | Templeogue | Aer Lingus | Galway | Aer Lingus | Trojan
Results | Sundays Well | Galway | Trojan | ESB | Ards | NAC
Spreadsheet: sara_shackleton__36751__OTC Trades
Sheet: Sheet1

Book | Counterparty | Trade Date | Maturity | Reference | Trade Type | Rate | B/S | Notional
Credit | DBKS | 2000-04-05 00:00:00 | 2002-02-28 00:00:00 | Asia Pulp & Paper | Default Swap | 0.195 | S | 5000000
Credit | DBKS | 2000-03-07 00:00:00 | 2003-03-15 00:00:00 | Level 3 | Default Swap | 0.036 | S | 3000000
Credit | GSCO | 2000-03-03 00:00:00 |  | NE Utility 8 7/8% | Default Swap | 0.014 |  | 25000000
Credit | DBKS | 2000-03-08 00:00:00 | 2006-08-01 00:00:00 | Republic of Indonesia | Default Swap | 0.055 | B | -5000000
Credit | DBKS | 2000-02-24 00:00:00 | 2004-06-15 00:00:00 | Telmex-4.25% 6/04 | Default Swap | 0.03 | S | 5000000
Credit | DBKS | 2000-04-19 00:00:00 | 2005-05-02 00:00:00 | Triplet | Portfolio Default Swap | 0.064 | S | 5000000
Credit | DBKS | 2000-01-05 00:00:00 | 2001-01-01 00:00:00 | Lehman High Yield Index | Total Return Index Swap | 0.0682 | Rec TR | -5000000
Credit | Enron Credit | 2000-08-03 00:00:00 | 2001-08-03 00:00:00 | Emmis Communication | Default Swap | 0.02125 | B | -2500000
Credit | First Union | 2000-08-03 00:00:00 | 2001-08-03 00:00:00 | Emmis Communication | Default Swap | 0.02125 | S | 10000000
Credit | Enron Credit | 2000-08-01 00:00:00 | 2004-02-01 00:00:00 | At Home Corp | Default Swap | 0.0635 | S | 2000000
Convertible | DBKS | 2000-07-14 00:00:00 | 2007-09-15 00:00:00 | Loews Corp | Default Swap | 0.0175 | B | -4000000
Convertible | Enron Credit | 2000-06-19 00:00:00 |  | Diamond Offshore | Default Swap | 0.0085 | B | -4000000
Convertible | Enron Credit | 2000-06-26 00:00:00 |  | NBR Default Swap | Default Swap | 0.0085 | B | -4000000
Convertible | Enron Credit | 2000-05-25 00:00:00 |  | [NAME] | Default Swap | 0.0075 | B | -4000000
Spreadsheet: 755121d1636667662-can-you-use-vlookup-to-return-value-if-conditions-are-met-timeline-2021_test-copy
Sheet: Summary

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <-------- | this row needs to be a rolling 7 days starting with one day before today
 |  |  |  | Activity |  |  |  |  |  |  |  |  |  |  |  | So if today was 11/27, then the first day to show would be 11/26  and of course the weekday would need to reflect that correct day of the week as well
 |  | This needs to be any activity that has a count  greater than or equal to 1 in the 7 days that are being displayed here | ----> |  |  |  |  |  |  |  |  |  |  |  | <-------- | This row needs to reflect the count shown for that day if there is one Since the raw data tab has a formula to calculate that number, this  summary needs to be just the value
 |  |  |  | Activity
 |  |  |  | HOURS
 |  |  |  | FULFILLMENT HOURS
 |  |  |  | OPPERATION HOURS
 |  |  |  | COMMUNICATION
 |  |  |  | BRIDGE DETAILS
 |  |  |  | HOLIDAY SUPPORT
Spreadsheet: 868219d1714975499-date-wise-bank-balance-statement-required-sample
Sheet: Sheet2

 |  |  |  | 1525324308.87 | 1498034019.93
Date | Chq./Ref.No. | Value Dt | Withdrawal Amt. | Deposit Amt. | Closing Balance |  | Required
******** | ************ | ******** | ****************** | ****************** | ****************** |  | ******************
2024-04-01 00:00:00 | [NAME] | 2024-04-01 00:00:00 | 0 | 800000 | -81997915.44 |  | -81997915.44
2024-04-01 00:00:00 | BARBR52024040100725425 | 2024-04-01 00:00:00 | 0 | 200000 | -81797915.44 |  | -81797915.44
2024-04-01 00:00:00 | BARBR52024040100725433 | 2024-04-01 00:00:00 | 0 | 200000 | -81597915.44 |  | -81597915.44
2024-04-01 00:00:00 | IB01144537073548 | 2024-04-01 00:00:00 | 0 | 2010000 | -79587915.44 |  | -79587915.44
2024-04-01 00:00:00 | 0000409214298370 | 2024-04-01 00:00:00 | 0 | 300000 | -79287915.44 |  | -79287915.44
2024-04-01 00:00:00 | IB01162358713772 | 2024-04-01 00:00:00 | 0 | 6500000 | -72787915.44 |  | -72787915.44
2024-04-01 00:00:00 | IB01162416095917 | 2024-04-01 00:00:00 | 0 | 25000000 | -47787915.44 |  | -47787915.44
2024-04-01 00:00:00 | MAHBR52024040116949141 | 2024-04-02 00:00:00 | 0 | 350000 | -47437915.44 |  | -47787915.44
2024-04-01 00:00:00 | IB01175209338484 | 2024-04-03 00:00:00 | 0 | 225000 | -47212915.44 |  | -47787915.44
2024-04-02 00:00:00 | xyz | 2024-04-02 00:00:00 |  | 1 |  |  | -47437914.44
2024-04-03 00:00:00 | xyz | 2024-04-03 00:00:00 |  | 1 |  |  | -47437914.44
Spreadsheet: 136142d1326432223-autofill-a-cell-based-on-selection-in-drop-down-menu-validationdropdownvlookup-corrected
Sheet: Sheet1

Vendor | Address | City | State | Zip |  |  |  |  |  |  | Vendor | Address | City | State | Zip
Fred | 321 | Seattle | WA | 54321 |  |  |  |  |  |  | [NAME] | 123 | Vegas | NV | 12345
 |  |  |  |  |  |  |  |  |  |  | Fred | 321 | Seattle | WA | 54321
 |  |  |  |  |  | Fill in the yellow area to see formulas work
Spreadsheet: 29391d1224386201-excel-pick-column-a-distinct-value-and-corresponding-column-c-max-value-copy-of-library-report-oct-18-2008-1
Sheet: Report

 | ID # | Class Id | Owner's Name | [NAME] Id | Branch ID | Start Date | End Date | [NAME] | Transaction Code | Next in Line
111 | 111 | 42 | Thomson | 87447 | 14 | 2008-08-01 00:00:00 | 2008-08-31 00:00:00 | 2008-09-18 00:00:00 | END | [NAME]
222 | 222 | 41 | Piers | 76257 | 7 | 2008-07-01 00:00:00 | 2008-07-31 00:00:00 | 2008-09-24 00:00:00 | END | [NAME]
 | 333 | 41 | National | 87447 | 14 | 2008-08-01 00:00:00 | 2008-08-31 00:00:00 | 2008-09-18 00:00:00 | END | [NAME]
333 | 444 | 41 | Contract | 57938 | 7 | 2008-08-01 00:00:00 | 2008-08-31 00:00:00 | 2008-09-18 00:00:00 | END | [NAME]
444 | 555 | 41 | Seasonal | 90413 | 14 | 2008-08-01 00:00:00 | 2008-08-31 00:00:00 | 2008-09-12 00:00:00 | END | [NAME]
 | 666 | 41 | Building Corp | 57938 | 7 | 2008-08-01 00:00:00 | 2008-08-31 00:00:00 | 2008-09-18 00:00:00 | END | Sue
555 | 777 | 41 | Logon | 77148 | 7 | 2008-05-15 00:00:00 | 2009-05-15 00:00:00 | 2008-09-09 00:00:00 | REN | [NAME]
666 | 888 | 41 | Oser | 53053 | 5 | 2008-05-01 00:00:00 | 2009-05-01 00:00:00 | 2008-09-26 00:00:00 | REN | [NAME]
777 | 999 | 41 | Sample | 87447 | 14 | 2008-08-01 00:00:00 | 2008-08-31 00:00:00 | 2008-09-18 00:00:00 | END | [NAME]
888
999
 | ID # | Class Id | Owner's Name | [NAME] Id | Branch ID | Start Date | End Date | [NAME] | Transaction Code | Next in Line
 | 111 | 42 | Thomson | 87447 | 14 | 2008-08-01 00:00:00 | 2008-08-31 00:00:00 | 2008-09-18 00:00:00 | END | [NAME]
 | 222 | 41 | Piers | 76257 | 7 | 2008-07-01 00:00:00 | 2008-07-31 00:00:00 | 2008-09-24 00:00:00 | END | [NAME]
 | 333 | 41 | National | 87447 | 14 | 2008-08-01 00:00:00 | 2008-08-31 00:00:00 | 2008-09-18 00:00:00 | END | [NAME]
 | 444 | 41 | Contract | 57938 | 7 | 2008-08-01 00:00:00 | 2008-08-31 00:00:00 | 2008-09-18 00:00:00 | END | [NAME]
 | 555 | 41 | Seasonal | 90413 | 14 | 2008-08-01 00:00:00 | 2008-08-31 00:00:00 | 2008-09-12 00:00:00 | END | [NAME]
 | 666 | 41 | Building Corp | 57938 | 7 | 2008-08-01 00:00:00 | 2008-08-31 00:00:00 | 2008-09-18 00:00:00 | END | Sue
 | 777 | 41 | Logon | 77148 | 7 | 2008-07-17 00:00:00 | 2008-08-16 00:00:00 | 2008-09-26 00:00:00 | END | [NAME]
 | 888 | 41 | Oser | 53053 | 5 | 2008-07-01 00:00:00 | 2008-07-31 00:00:00 | 2008-09-26 00:00:00 | END | [NAME]
 | 999 | 41 | Sample | 87447 | 14 | 2008-08-01 00:00:00 | 2008-08-31 00:00:00 | 2008-09-18 00:00:00 | END | [NAME]
Spreadsheet: 846071d1697368930-returning-true-on-every-value-in-an-array-if-appeared-within-the-last-3-months-ben1232-example
Sheet: Sheet1

Column1 | Column2 | Last 3 Months?
2023-10-01 00:00:00 | red
2023-09-01 00:00:00 | blue
2023-08-01 00:00:00 | purple
2023-07-01 00:00:00 | red
2023-06-01 00:00:00 | black
2023-05-01 00:00:00 | black
2023-04-01 00:00:00 | purple
2023-03-01 00:00:00 | yellow
2023-02-01 00:00:00 | red
2022-12-01 00:00:00 | purple
2022-11-01 00:00:00 | yellow
2022-10-01 00:00:00 | blue
Intended result
2023-10-01 00:00:00 | red | True
2023-09-01 00:00:00 | blue | True
2023-08-01 00:00:00 | purple | True
2023-07-01 00:00:00 | red | True
2023-06-01 00:00:00 | black | False
2023-05-01 00:00:00 | black | False
2023-04-01 00:00:00 | purple | True
2023-03-01 00:00:00 | yellow | False
2023-02-01 00:00:00 | red | True
2022-12-01 00:00:00 | purple | True
2022-11-01 00:00:00 | yellow | False
2022-10-01 00:00:00 | blue | True
Spreadsheet: 854246d1704198561-adding-blank-columns-demo-data
Sheet: Sheet3

 | 2 | 3 | 4 |  |  |  |  | 18P | sa | 17S | 11CL
 |  | 75 | The American Insurance Company Limited. |  |  |  |  | 41 |  | 52000 | 300000
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland |  |  |  |  | 25 |  | 30000
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd |  |  |  |  | 325.3 |  | 0 | 0
 | 7 | 9 | [NAME] ([NAME] (Main)) |  |  |  |  | 4000 |  | 45500 | 600000
 | 8 |  | Myselfi & Associates Trading Pvt.Ltd |  |  |  |  | 11000 |  | 900 | 20000
 |  |  | [NAME].Ltd. |  |  |  |  | 105300 |  | 80900
 |  |  | Agraj Foods Pvt.Ltd,Kathmandu |  |  |  |  | 75430.4 |  | 354000
 |  |  | Alive Pharmaceutical Pvt. Ltd.,Nrt |  |  |  |  | 98430.6 |  | 46005
 |  |  | Nirvana Plastic Corp |  |  |  |  | 190000 |  | 0
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 11d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | - | 202 | - | 88
Cross-Currency Fixed-Fixed | - | 17 | - | 17
Cross-Currency Fixed-Float | - | 80 | - | 42
TOTAL | - | 299 | - | 147
Spreadsheet: 117383d1312752055-filtering-lookup-array-question-filtered
Sheet: 44020

CONTROL CABLE
CORE CARD
Location
Cable Number |  | 44020
Number of cores |  | 4
Spare cores |  | 2
Core size |  | 2.5mm2
Cable Type |  | Cu, PVC, SWA
Drawing References
Cable Service |  | CB482 Local trip & close supply
Panel Number | T44 PP |  | Panel Number |  | [NAME]
Cable Insulation resistance >100MΩ
Core Number | Ferrule Number |  | T44 PP | INITIAL | [NAME] | INITIAL
1 | 20/ADY441260 |  | TBX5:64 |  | B7
2 | 20/ADY441261 |  | TBX5:66 |  | B10
3 | Spare
4 | Spare
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Termination Notes | 2011-08-02 00:00:00 | DC supply cable, could use 2 cores instead? |  |  |  | DJC
Edition Notes | 2011-08-02 00:00:00 | Was cable 4520 |  |  |  | DJC
 |  | On G6 this cable was 2141, existing cable - renumber
 |  | G4 sheet has this cable as 12 cores
Spreadsheet: 87817d1287675891-filtering-duplicates-latetest
Sheet: Sheet1

OrdNbr | PO | OrdDate | Ship Date | Product#
1 | 1251 | 2010-09-01 00:00:00 | 2010-09-02 00:00:00 | A110
2 | 1251 | 2010-09-01 00:00:00 | 2010-09-20 00:00:00 | A111 | Late
3 | 1251 | 2010-09-01 00:00:00 | 2010-09-04 00:00:00 | A112
4 | 551 | 2010-09-02 00:00:00 | 2010-09-20 00:00:00 | A111 | Late
5 | 551 | 2010-09-02 00:00:00 | 2010-09-05 00:00:00 | A112
6 | 551 | 2010-09-02 00:00:00 | 2010-09-20 00:00:00 | A113
Spreadsheet: 00fbadb4-45a0-4853-89ea-362eab8bb900
Sheet: Sheet1

North American Association of Central Cancer Registries
2013 ANNUAL CONFERENCE
NCRA Event Number  2013-067
It is your responsibility to document the session that you attended.
Please keep this form for your credential submission.
Name: |  |  | Total Hours:
 | TOPIC | SPEAKER | CE HOURS APPROVED | HOURS ATTENDED
2013-06-11 00:00:00 | Conference Day 1, Tuesday
08:30:00 | Plenary Session 1: Thinking Big: Vision & Future Directions |  | 1.5
 | How will the future be measured? | [NAME], PhD
 | Accelerating Oncology Research: How Baylor Health Care System is Using Registries to Improve Cancer Research Analytics | [NAME], MD
10:30:00 | Plenary Session 2: Doing the NAACCR Two-Step: Health & Information Technology |  | 1.5
 | The ONC Vision for Health Information Technology & Public Health | [NAME], MPH
 | IBM Watson: Transforming Cancer Data & Healthcare | [NAME], IBM Fellow
13:30:00 | Concurrent Session 1 |  | 1.5
15:30:00 | Concurrent Session 2 |  | 1.5
2013-06-12 00:00:00 | Conference Day 2, Wednesday
08:00:00 | NAACCR Now | [NAME] | 1
09:00:00 | Plenary Session3: Standing Tall After Cancer: Survivorship & Care Plans |  | 1.5
 | A Vision for Using Health IT To Meet Cancer Survivors' Needs | [NAME]
 | Survivorship & Passport to Care | [NAME]
10:45:00 | Concurrent Session 3 |  | 1.5
2013-06-13 00:00:00 | Conference Day 3, Thursday
08:00:00 | Birds of a Feather: The Future of Cancer Surveillance….or Not? | [NAME]; [NAME] | 1
09:00:00 | Plenary Session 4: Remember the Patient! Comparative Effectiveness & Outcomes |  | 1.25
 | Comparative Effectiveness Research & Cancer Screening | [NAME], MD
 | Comparative Effectiveness of Granulocyte Growth Factors Among elderly Patients with Non-Hodgkin's Lymphoma | [NAME], DrPH
10:30:00 | Concurrent Session 4 |  | 1.5
13:00:00 | Plenary Session 5: NAACCR Update on Steering Committees | [NAME], BS, MS, PhD; Maureen MacIntyre MHSA | 0.75
13:45:00 | Concurrent Session 5 |  | 1.5
15:30:00 | NAACCR Showcase |  | 1
 | Virtual Pooled Data Project | [NAME], DrPH
 | Development & Demonstration of CI* Rank | [NAME], PhD
Total Hours |  |  | 17
Spreadsheet: 127408d1320338824-vlookup-index-offset-and-match-question-indirectmatchtwosheets
Sheet: Sheet2

Date | Payment | Interest | Principal | New Balance
2011-01-01 00:00:00 | 2000 | 1000 | 1000 | 100000
2011-02-01 00:00:00 | 2000 | 1000 | 1000
2011-03-01 00:00:00 | 2000 | 1000 | 1000
2011-04-01 00:00:00 | 2000 | 1000 | 1000
2011-05-01 00:00:00 | 2000 | 1000 | 1000
2011-06-01 00:00:00 | 2000 | 1000 | 1000
2011-07-01 00:00:00 | 2000 | 1000 | 1000
2011-08-01 00:00:00 | 2000 | 1000 | 1000
2011-09-01 00:00:00 | 2000 | 1000 | 1000
2011-10-01 00:00:00 | 2000 | 1000 | 1000
2011-11-01 00:00:00 | 2000 | 1000 | 1000
2011-12-01 00:00:00 | 2000 | 1000 | 1000
2012-01-01 00:00:00 | 2000 | 1000 | 1000
2012-02-01 00:00:00 | 2000 | 1000 | 1000
2012-03-01 00:00:00 | 2000 | 1000 | 1000
2012-04-01 00:00:00 | 2000 | 1000 | 1000
2012-05-01 00:00:00 | 2000 | 1000 | 1000
2012-06-01 00:00:00 | 2000 | 1000 | 1000
2012-07-01 00:00:00 | 2000 | 1000 | 1000
2012-08-01 00:00:00 | 2000 | 1000 | 1000
2012-09-01 00:00:00 | 2000 | 1000 | 1000
2012-10-01 00:00:00 | 2000 | 1000 | 1000
2012-11-01 00:00:00 | 2000 | 1000 | 1000
2012-12-01 00:00:00 | 2000 | 1000 | 1000
2013-01-01 00:00:00 | 2000 | 1000 | 1000
2013-02-01 00:00:00 | 2000 | 1000 | 1000
2013-03-01 00:00:00 | 2000 | 1000 | 1000
2013-04-01 00:00:00 | 2000 | 1000 | 1000
2013-05-01 00:00:00 | 2000 | 1000 | 1000
2013-06-01 00:00:00 | 2000 | 1000 | 1000
2013-07-01 00:00:00 | 2000 | 1000 | 1000
2013-08-01 00:00:00 | 2000 | 1000 | 1000
2013-09-01 00:00:00 | 2000 | 1000 | 1000
2013-10-01 00:00:00 | 2000 | 1000 | 1000
2013-11-01 00:00:00 | 2000 | 1000 | 1000
2013-12-01 00:00:00 | 2000 | 1000 | 1000
2014-01-01 00:00:00 | 2000 | 1000 | 1000
2014-02-01 00:00:00 | 2000 | 1000 | 1000
Spreadsheet: 856446d1705680139-counting-cells-that-meet-multiple-criteria-book1
Sheet: Sheet1

DWANEY MILLS |  |  |  |  |  |  |  |  |  | DM
[NAME] |  |  |  |  |  |  |  |  |  | RM |  |  |  |  | V |  |  | V
[NAME] |  |  |  |  |  |  |  |  |  | SW |  |  |  |  | V |  |  | V
[NAME] |  |  |  |  |  |  |  |  |  | JM |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO
[NAME] |  |  |  |  |  |  |  |  |  | DL |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO
HAYDEN JACKSON |  |  |  |  |  |  |  |  |  | HJ
JAQUAN MASON |  |  |  |  |  |  |  |  |  | JM
[NAME] |  |  |  |  |  |  |  |  |  | HC
BRUCE MELTON |  |  |  |  |  |  |  |  |  | BM |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55
[NAME] |  |  |  |  |  |  |  |  |  | CC |  | 55 |  |  | V |  |  | V |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55
DONNIE NALLEY |  |  |  |  |  |  |  |  |  | DN |  |  |  |  | V
[NAME] |  |  |  |  |  |  |  |  |  | TB |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55
MARTY BROOME |  |  |  |  |  |  |  |  |  | MB
CRANE OPERATOR |  |  |  |  |  |  |  |  |  | C
UNASSIGNED |  |  |  |  |  |  |  |  |  | X
Spreadsheet: 882240d1730510360-copying-rows-with-retaining-data-recruiting-spreadsheet-challenge-sample-recruiting-sheet
Sheet: Recruiting Job 1

Date Entered | [NAME] | ID# | First Name | Last Name | Phone Number | [NAME] | Computer Assessment | Criminial BG | Date Updated | Education Verification | Adobe Pre-Hire Forms | Paperwork | Everify
2024-10-30 00:00:00 | 85827 JA | 20336713 | Semaiyah | [NAME]
2024-10-30 00:00:00 | 85058 JS | 20344262 | [NAME] | [NAME]
2024-10-22 00:00:00 | 85058 KS | 16119223 | STACY | Smith
2024-10-28 00:00:00 | 85058 JS | 19308064 | [NAME] | [NAME]
2024-10-30 00:00:00 | 85058 JS | 20344884 | Kasheka | [NAME]
2024-10-30 00:00:00 | 85058 KS | 12336 | [NAME] | Doe