tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 57170d1257329426-how-to-find-if-new-month-started-between-weeks-705879_nmlnml
Sheet: Sheet1

2009-11-02 00:00:00 | 16 | 2009-10-27 00:00:00 | 2009-11-08 00:00:00 |  | Start | End |  | Result
2009-11-09 00:00:00 | 13 | 2009-11-03 00:00:00 | 2009-11-15 00:00:00 |  | 2009-11-01 00:00:00 | 2009-11-30 00:00:00 |  | 67.57142857142857
2009-11-16 00:00:00 | 18 | 2009-11-10 00:00:00 | 2009-11-22 00:00:00 |  | 2009-12-01 00:00:00 | 2009-12-31 00:00:00 |  | 53.57142857142857
2009-11-23 00:00:00 | 18 | 2009-11-17 00:00:00 | 2009-11-29 00:00:00 |  | 2010-01-01 00:00:00 | 2010-01-31 00:00:00 |  | 56.85714285714286
2009-11-30 00:00:00 | 18 | 2009-11-24 00:00:00 | 2009-12-06 00:00:00 |  | 2010-02-01 00:00:00 | 2010-02-28 00:00:00 |  | 5
2009-12-07 00:00:00 | 13 | 2009-12-01 00:00:00 | 2009-12-13 00:00:00 |  | 2010-03-01 00:00:00 | 2010-03-31 00:00:00 |  | 0
2009-12-14 00:00:00 | 7 | 2009-12-08 00:00:00 | 2009-12-20 00:00:00 |  | 2010-04-01 00:00:00 | 2010-04-30 00:00:00 |  | 0
2009-12-21 00:00:00 | 9 | 2009-12-15 00:00:00 | 2009-12-27 00:00:00 |  | 2010-05-01 00:00:00 | 2010-05-31 00:00:00 |  | 0
2009-12-28 00:00:00 | 16 | 2009-12-22 00:00:00 | 2010-01-03 00:00:00
2010-01-04 00:00:00 | 17 | 2009-12-29 00:00:00 | 2010-01-10 00:00:00
2010-01-11 00:00:00 | 12 | 2010-01-05 00:00:00 | 2010-01-17 00:00:00
2010-01-18 00:00:00 | 2 | 2010-01-12 00:00:00 | 2010-01-24 00:00:00
2010-01-25 00:00:00 | 19 | 2010-01-19 00:00:00 | 2010-01-31 00:00:00
2010-02-01 00:00:00 | 5 | 2010-01-26 00:00:00 | 2010-02-07 00:00:00
Spreadsheet: 265260d1379148877-remove-items-from-dv-list-once-used-display-elsewhere-reset-list-when-filling-across-scheduledemo_ah
Sheet: EMP LIST

Employee | Area | Day 1 | Day 2 |  | NORTH | NTH-EAST | EAST | STH-EAST
RM8083 | NORTH |  |  |  | RM8083 | MR5163 | MB4962 | CH5651
LL7733 | NORTH |  |  |  | LL7733 | [NAME] | EF7853 | CH7564
SS7890 | NORTH |  |  |  | SS7890 | SM1424 | EB7837 | TW8109
MH7886 | NORTH |  |  |  | MH7886 | AB6798 | BM7985 | DL7872
MR5163 | NTH-EAST
[NAME] | NTH-EAST
SM1424 | NTH-EAST
AB6798 | NTH-EAST
MB4962 | EAST
EF7853 | EAST
EB7837 | EAST
BM7985 | EAST
CH5651 | STH-EAST
CH7564 | STH-EAST
TW8109 | STH-EAST
DL7872 | STH-EAST
Spreadsheet: 729349d1619032204-find-maximum-value-matching-specific-names-with-multiple-entries-data-sample-nm
Sheet: Merge1

CourseName | [NAME] | Table1 (2).MarkerName
Achill | 95 | White
Achill | 95 | White B9
Athenry | 122 | White B9
Athlone | 126 | Blue
Athlone | 126 | Blue B9
Athlone | 126 | Blue F9
Athlone | 126 | White F9
Spreadsheet: phillip_m_love__31094__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 10/22/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
AES NewEnergy, Inc. | YB9593.1 YC6350.1 | F | NG | [NAME]
Energy Service Providers, LLC | YC7062.1 | F | C3GC | Credit Previously Provided
Tug Fork Development | VW2256.1/2/4/6 | P | NG | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
BP Amoco Chemical Company | YC6666.1 | F | NG | BP Corporation North America Inc.
Bank One, National Association | YC5591.1 YC4968.1 | F | NG | Bank of America, National Association
Bank of America NA London | YC3243.1 | F | HSFS | Bank of America, National Association
Duke Energy Marketing Limited Partnership | YC7020.1 | F | NG | Duke Energy Marketing Limited Partnership (w/ECC)
Kerr-McGee Corporation | YC6042.1 | F | NG | Kerr-McGee Energy Services Corporation
Louis Dreyfus Plastics Corp | YC7067.1 YC7068.1 | F | NG | Louis Dreyfus Energy Services
TransCanada Energy Financial Products | YC5480.1 YC5486.1 | F | NG | TransCanada Energy Financial Products (w/ECC)
Virginia Electric and Power Company | YC7178.1/2 | F | NG | Virginia Power Energy Marketing
Spreadsheet: 142195d1329723325-how-to-hide-duplicate-rows-in-excel-2003-sample-data-hide-duplicate-rows
Sheet: expected results

Name | Jan | Feb | Mar | Apr
[NAME] | 5 | 1 | 3 | 4
[NAME] | 0 | 0 | 0 | 7
[NAME] | 1 | 0 | 0 | 3
[NAME] | 8 | 6 | 0 | 0
Spreadsheet: 777931d1650678859-merging-list-information-from-multiple-sheets-that-may-have-added-rows-full-outer-merge-using-power-query-hacohen15-
Sheet: Annual Totals

NAME |  | Date |  | Annual total |  |  | Name | Hire Date | Annual Total
(these are made up names and info |  |  |  |  |  |  | Abbott, [NAME] | 1995-12-02 00:00:00 | 8000
 |  |  |  |  |  |  | [NAME], [NAME] | 2020-08-10 00:00:00 | 5000
Abbott, [NAME] |  | 1995-12-02 00:00:00 |  |  |  |  | Baybott, [NAME] | 2022-05-05 00:00:00 | 1500
[NAME], [NAME] |  | 2020-08-10 00:00:00 |  |  |  |  | Cabott, Fred | 2007-08-01 00:00:00 | 6000
Baybott, [NAME] |  | 2022-05-05 00:00:00 |  |  |  |  | Dabott, [NAME] | 2002-05-15 00:00:00 | 10000
Cabott, Fred |  | 2007-08-01 00:00:00
Dabott, [NAME] |  | 2002-05-15 00:00:00
Spreadsheet: 687493d1595250571-extract-date-in-middle-test-sum-date_chris
Sheet: Sheet1

 |  |  |  |  | SUM CONDITION DATE & DES | HANWORTH | WATFORD | BROCKLE
Text | Rate |  | date extract |  | date | sum | sum | sum
BROCKLE CARD TXNS 290520 /SREF/020397 | 30 |  | 2020-05-29 00:00:00 |  | 270520
HANWORTH DUALITY-E 270520 /SREF/123750 | 20 |  | 2020-05-27 00:00:00 |  | 290520
[NAME] /SREF/020121 | 40 |  | 2020-05-30 00:00:00 |  | 300520
HANWORTH DUALITY-E 270520 /SREF/123750 | 15 |  | 2020-05-27 00:00:00 |  | 040620
BROCKLE CARD TRAN 040620 /SREF/010234 | 50 |  | 2020-06-04 00:00:00
Spreadsheet: 743446d1628513910-sort-and-align-2-tables-upload-forum
Sheet: Page 3

Server | Subnet pool | Prefix | [NAME] | Type | Total | Used | Free | Util
172.19.17.116 | WRBNRPCC01-BG01 | 10.217.17.0 | /24 | MTA | 253 | 253 | 0 | 100
172.19.17.116 | WRBNOLMN05-VL100 | 10.217.18.128 | /25 | MTA | 125 | 0 | 125 | 0
172.19.17.116 | WRBNOLMN06-VL100 | 10.217.19.0 | /25 | MTA | 125 | 1 | 124 | 1
172.19.17.116 | WRBNOLMN09-VL100 | 10.217.19.128 | /25 | MTA | 125 | 3 | 122 | 2
172.19.17.116 | WRBNOLMN02-VL100 | 10.217.110.128 | /25 | MTA | 125 | 1 | 124 | 1
172.19.17.116 | HOLTOLMN02-VL100 | 10.217.111.0 | /25 | MTA | 125 | 2 | 123 | 2
172.19.17.116 | WRBNOLMN03-VL100 | 10.217.111.128 | /25 | MTA | 125 | 0 | 125 | 0
172.19.17.116 | HOLTOLMN03-VL100 | 10.217.112.0 | /25 | MTA | 125 | 0 | 125 | 0
172.19.17.116 | WRBNOLMN07-VL100 | 10.217.112.128 | /25 | MTA | 125 | 0 | 125 | 0
172.19.17.116 | HOLTOLMN04-VL100 | 10.217.13.0 | /25 | MTA | 125 | 0 | 125 | 0
172.19.17.116 | WRBNOLTA01-VL100 | 10.217.13.128 | /25 | MTA | 125 | 27 | 98 | 22
172.19.17.116 | WRBNCAPC05-BG01 | 10.217.0.0 | /24 | MTA | 253 | 252 | 1 | 100
172.19.17.125 | CTECOLTA02-VL100 | 10.217.1.0 | /24 | MTA | 253 | 6 | 247 | 2
172.19.17.116 | WRBNCAPC05-BG01 | 10.217.2.0 | /24 | MTA | 253 | 253 | 0 | 100
172.19.17.116 | WRBNCAPC06-BG01 | 10.217.3.0 | /24 | MTA | 253 | 253 | 0 | 100
172.19.17.116 | WRBNOLMN11-VL100 | 10.217.4.128 | /25 | MTA | 125 | 6 | 119 | 5
172.19.17.116 | WRBNOLMN12-VL100 | 10.217.5.0 | /25 | MTA | 125 | 6 | 119 | 5
172.19.17.116 | WRBNRPCC01-BG01 | 10.217.6.0 | /24 | MTA | 253 | 253 | 0 | 100
Spreadsheet: 216949d1361932200-count-stock-from-various-options-in-a-drop-down-list-workbook1
Sheet: Sheet1

Publication | Delivery Method | Quantity | Source |  |  |  | Publication | Delivery Method | Source |  | Stock Remaining |  | Total Stock Given
Brochure | Mail | 5 | Counter |  |  |  | Brochure | Mail | Call Centre |  |  | Brochure | 100
 |  |  |  |  |  |  | desktop | [NAME] | Counter |  |  | Desktop | 100
 |  |  |  |  |  |  | test 3 |  | Phone |  |  | test 3 | 100
 |  |  |  |  |  |  | tesaed |  | [NAME] |  |  | tesaed | 120
Spreadsheet: 777462d1650392824-counting-distinct-values-within-a-date-range-feeod-sample
Sheet: Sheet12

Row Labels
BX0004Z
Visit-1
BX0022WA
Visit-1
CH0077WA
(blank)
DC1067Z
Visit-5
DC1097Z
Visit-4
DN0063WA
Visit-1
HNYJ401A
Visit-1
HNYL801A
Visit-1
IEY5007A
Visit-2
NJ0045Z
(blank)
NJ0048Z
Visit-3
NY0091WA
Visit-1
NY0091Z
Visit-1
PH0113Z
Visit-1
PH0114Z
Visit-1
PH0124Z
Visit-3
PXY8201A
Visit-4
[NAME]
Visit-3
SEY6701A
Visit-1
SFY5042A
Visit-6
SFY5060A
Visit-3
SFYL101A
Visit-4
SFYL601A
Visit-4
Site ID
#N/A
SL0215WA
(blank)
SL0221WA
(blank)
SL0607WA
Visit-2
SVY5014A
Visit-7
SVY5024A
(blank)
[NAME]
Visit-5
TU1624WA
Visit-5
VA1066Z
(blank)
VGY6601A
Visit-2
WI1625WA
Visit-2
(blank)
(blank)
Grand Total
Spreadsheet: 9c15ef6f-9af5-4b13-88a6-6908abb27cac
Sheet: Spring 2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
MAEd
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Part of Term | Dates | Days | Times | Credits | Instructor(s) | Instructor ID | FT or Adj | Contract Code | Percentage | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 28431d1222706925-purchase-order-customer-info-autopopulated-master-order-template-for-excel-help
Sheet: Customer Data List

 | 4
Phone | Invoice Number | Invoice Date | Invoice Time | Name | Address | City | State | Zip
5555551234 | 4 | 2008-09-27 00:00:00 | 23:00:00 | [NAME] | 987 Maple | Anytown | California | 12345
5555554567 | 3 | 2008-09-27 00:00:00 | 23:00:00 | [NAME] | 345 Main Street | Anytown | California | 12345
5555557890 | 2 | 2008-09-27 00:00:00 | 23:00:00 | [NAME] | 123 Elm Street | Anytown | California | 12345
5555559876 | 1 | 2008-09-27 00:00:00 | 23:00:00 | [NAME] | 567 Main Street | Anytown | California | 12345
Spreadsheet: 173938d1344863779-macros-button-help-3m-valley
Sheet: PG USP (2)

[NAME] USP
474 Lbs./Drum
[NAME]
Lot # | CB243940209
Batch # | 999999
PO | USMMMF40D2
Rel. | N/A | 2009-04-20 00:00:00
[NAME] USP
474 Lbs./Drum
[NAME]
Lot # | CB243940209
Batch # | 999999
PO | USMMMF40D2
Rel. | N/A | 2009-04-20 00:00:00
Spreadsheet: 43431d1242112652-formula-to-copy-cell-data-from-another-worksheet-for-a-particular-condition-example
Sheet: 2_1 to 2_20

 | Class | Item # | Color | Area | Sale Date | Date Range
 | A | UPQ451 | Gold | West | 2009-02-01 00:00:00 | 2/1-2/20
 | A | [NAME] | Green | West | 2009-02-02 00:00:00 | 2/1-2/20
 | B | MLP541 | Yellow | East Coast | 2009-02-05 00:00:00 | 2/1-2/20
 | B | MLP547 | Purple | East Coast | 2009-02-06 00:00:00 | 2/1-2/20
 | C | QRP547 | Classic green | Central | 2009-02-09 00:00:00 | 2/1-2/20
 | C | QRP245 | Red | Central | 2009-02-10 00:00:00 | 2/1-2/20
 | Total | 6 |  |  |  | 2/1-2/20
 | Extra |  |  |  |  | 2/1-2/20
 | A | [NAME] | Blue | West | 2009-02-03 00:00:00 | 2/1-2/20
 | A | UPQ157 | Red | Mid West | 2009-02-04 00:00:00 | 2/1-2/20
 | B | MLP689 | Daylight | Northeast | 2009-02-07 00:00:00 | 2/1-2/20
 | B | MLP742 | Yellow | South | 2009-02-08 00:00:00 | 2/1-2/20
 | C | QRP963 | Red | East | 2009-02-11 00:00:00 | 2/1-2/20
 | C | QRP471 | Yellow | Northeast | 2009-02-12 00:00:00 | 2/1-2/20
Spreadsheet: 680280d1590913560-create-a-new-list-with-calculations-example-document
Sheet: Sheet1

Original list |  |  |  | List wanted
Company | Counterparty | Amount |  | Company | Counterparty | Amount
Company 1 | Company 2 | 150 |  | Company 1 | Company 2
Company 1 | Company 3 | 100 |  | Company 1 | Company 3
Company 1 | Company 5 | 50 |  | Company 1 | Company 4
Company 2 | Company 3 | 0 |  | Company 1 | Company 5
Company 2 | Company 3 | 400 |  | Company 2 | Company 3
Company 2 | Company 4 | 500 |  | Company 2 | Company 4
Comapny 2 | Company 1 | 50 |  | Company 2 | Company 5
Company 3 | Company 2 | 200 |  | Company 3 | Company 4
Company 3 | Company 4 | 150 |  | Company 3 | Company 5
Company 3 | Company 1 | 75 |  | Company 4 | Company 5
Company 4 | Company 2 | 300
Company 4 | Company 1 | 400
Company 4 | Company 5 | 800
Company 4 | Company 3 | 400
Company 5 | Company 4 | 300
Company 5 | Company 3 | 400
Company 5 | Company 1 | 500
Company 5 | Company 2 | 0
Company 2 | Company 1 | 300
Company 3 | Company 1 | 12
Spreadsheet: 124299d1318316726-name-based-on-highest-score-maximum-name
Sheet: Test

 | Description | Maximum | Name 1 | Name 2 | Name 3
 | Process
 | Criteria 1 | 10 | 9 | 10 | 9
 | [NAME] | 10 | 10 | 10 | 8
 | Criteria 3 | 5 | 4 | 4 | 4
 | [NAME] | 5 | 4 | 4 | 4
 | Criteria 5 | 5 | 4 | 4 | 4
 | Criteria 6 | 5 | 0 | 0 | 0
 | Criteria 7 | 5 | 4 | 4 | 4
 | Criteria 8 | 5 | 5 | 5 | 5
 | Total
 | Behavioral Attributes
 | Criteria 1 | 5 | 4 | 4.5 | 4
 | [NAME] | 5 | 4 | 4 | 4
 | Criteria 3 | 5 | 4 | 3 | 4
 | [NAME] | 5 | 3.5 | 4 | 4
 | Criteria 5 | 5 | 4 | 3.5 | 4
 | Criteria 6 | 5 | 5 | 5 | 0
 | Criteria 7 | 5 | 0 | 4 | 0
 | Criteria 8 | 5 | 3.5 | 4 | 3.5
 | Criteria 9 | 5 | 3.5 | 4 | 4
 | Criteria 10 | 5 | 4 | 4 | 4
 | TOTAL
 | Grand Total
 | In the above cell I want the name of the person with highest score
Spreadsheet: 122126d1316624298-pivot-table-macro-vba-dummy-file
Sheet: Summary

Supervisor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manager | (All)
Behav 5 Category | 1- Superstar |  |  |  |  | Behav 5 Category | 2 - Performing |  |  |  |  | Behav 5 Category | 3 - Showing Potential |  |  |  |  | Behav 5 Category | 4 - Improvement Needed |  |  |  |  | Behav 5 Category | 5 - Missing All Metrics |  |  |  |  |  | Row Labels | Supervisors
 | Q AHT % to Goal | Q IR % to Goal | Q [NAME] to Goal | Q NCP wo Txf % to Goal |  |  | Q AHT % to Goal | Q IR % to Goal | Q [NAME] to Goal | Q NCP wo Txf % to Goal |  |  | Q AHT % to Goal | Q IR % to Goal | Q [NAME] to Goal | Q NCP wo Txf % to Goal |  |  | Q AHT % to Goal | Q IR % to Goal | Q [NAME] to Goal | Q NCP wo Txf % to Goal |  |  | Q AHT % to Goal | Q IR % to Goal | Q [NAME] to Goal | Q NCP wo Txf % to Goal |  |  | Smith, [NAME] | 14
Agent Name |  |  |  |  |  | Agent Name |  |  |  |  |  | Agent Name |  |  |  |  |  | Agent Name |  |  |  |  |  | Agent Name |  |  |  |  |  |  | Warner, Carlisietta | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 25
Spreadsheet: 687301d1595095615-problem-when-using-index-with-aggregate-help_v2-rayson-chan-
Sheet: BIM Short Term Programme

# | Work by | Target End Date | % of Complete |  | % of Complete | (Multiple Items)
1 | [NAME] | 2020-06-25 00:00:00 | 1 |  | Work by | [NAME]
2 | [NAME] | 2020-06-25 00:00:00 | 1
3 | [NAME] | 2020-06-25 00:00:00 | 1 |  | # | Sum of Target End Date
4 | [NAME] | 2020-06-25 00:00:00 | 1 |  | 38 | 2020-07-15 00:00:00
5 | [NAME] | 2020-06-25 00:00:00 | 1 |  | 46 | 2020-07-17 00:00:00
6 | [NAME] | 2020-06-25 00:00:00 | 1 |  | 47 | 2020-07-17 00:00:00
7 | [NAME] | 2020-06-25 00:00:00 | 1 |  | 49 | 2020-07-19 00:00:00
8 | [NAME] | 2020-06-25 00:00:00 | 1 |  | 50 | 2020-07-20 00:00:00
9 | [NAME] | 2020-06-25 00:00:00 | 1 |  | 52 | 2020-07-20 00:00:00
10 | [NAME] | 2020-06-25 00:00:00 | 1 |  | 53 | 2020-07-20 00:00:00
11 | [NAME] | 2020-06-25 00:00:00 | 1 |  | 51 | 2020-07-20 00:00:00
12 | [NAME] | 2020-06-25 00:00:00 | 1 |  | 54 | 2020-07-20 00:00:00
13 | [NAME] | 2020-06-25 00:00:00 | 1
14 | [NAME] | 2020-06-25 00:00:00 | 1
15 | [NAME] | 2020-06-25 00:00:00 | 1
16 | [NAME] | 2020-06-25 00:00:00 | 1
17 | [NAME] | 2020-06-25 00:00:00 | 1
18 | [NAME] | 2020-06-25 00:00:00 | 1
19 | [NAME] | 2020-06-25 00:00:00 | 1
20 | [NAME] | 2020-06-25 00:00:00 | 1
21 | [NAME] | 2020-06-25 00:00:00 | 1
22 | [NAME] | 2020-06-25 00:00:00 | 1
23 | [NAME] | 2020-06-25 00:00:00 | 1
24 | [NAME] | 2020-06-25 00:00:00 | 1
25 | [NAME] | 2020-06-25 00:00:00 | 1
26 | [NAME] | 2020-06-25 00:00:00 | 1
27 | [NAME] | 2020-06-25 00:00:00 | 1
28 | [NAME] | 2020-06-25 00:00:00 | 1
29 | [NAME] | 2020-06-25 00:00:00 | 1
30 | [NAME] | 2020-06-25 00:00:00 | 1
31 | [NAME] | 2020-06-30 00:00:00 | 1
32 | [NAME] | 2020-06-30 00:00:00 | 1
33 | [NAME] | 2020-07-01 00:00:00 | 1
34 | [NAME] | 2020-07-01 00:00:00 | 1
35 | [NAME] | 2020-07-06 00:00:00 | 1
36 | [NAME] | 2020-07-08 00:00:00 | 1
37 | [NAME] | 2020-07-08 00:00:00 | 1
38 | [NAME] | 2020-07-15 00:00:00 | 0.5
39 | [NAME] | 2020-07-13 00:00:00 | 1
40 | [NAME] | 2020-07-13 00:00:00 | 1
41 | [NAME] | 2020-07-25 00:00:00 | 0
42 | [NAME] | 2020-07-22 00:00:00 | 0
43 | [NAME] | 2020-07-17 00:00:00 | 0
44 | [NAME] | 2020-07-23 00:00:00 | 0
45 | [NAME] | 2020-07-26 00:00:00 | 0
46 | [NAME] | 2020-07-17 00:00:00 | 0
47 | [NAME] | 2020-07-17 00:00:00 | 0
48 | [NAME] | 2020-07-16 00:00:00 | 0
49 | [NAME] | 2020-07-19 00:00:00 | 0
50 | [NAME] | 2020-07-20 00:00:00 | 0
51 | [NAME] | 2020-07-20 00:00:00 | 0
52 | [NAME] | 2020-07-20 00:00:00 | 0
53 | [NAME] | 2020-07-20 00:00:00 | 0
54 | [NAME] | 2020-07-20 00:00:00 | 0
55 | [NAME] | 2020-07-21 00:00:00 | 0
56 | [NAME] | 2020-07-21 00:00:00 | 0
57 | [NAME] | 2020-07-21 00:00:00 | 0
58 | [NAME] | 2020-07-21 00:00:00 | 0
59 | [NAME] | 2020-07-22 00:00:00 | 0
60 | [NAME] | 2020-07-27 00:00:00 | 0
[NAME] |  |  |  | Expected Result
 |  |  |  | 38
 |  |  |  | 46
 |  |  |  | 47
 |  |  |  | 49
 |  |  |  | 50
Spreadsheet: 144554d1331039621-averaging-within-time-zones-timeavg
Sheet: Sheet1

Start between |  | Average Time Taken
06:15:00 | 06:29:00 |  |  | Start Time | 06:25:00 | 06:25:00 | 06:31:00 | 06:32:00 | 07:05:00 | 07:10:00
06:30:00 | 06:44:00 |  |  | Finish Time | 07:00:00 | 07:02:00 | 07:45:00 | 07:48:00 | 07:25:00 | 07:32:00
06:45:00 | 06:59:00 |  |  | Time Taken
07:00:00 | 07:14:00
Spreadsheet: 656719d1578397438-searchable-dropdown-list-using-data-validation-named-ranges-and-offset-formula-sample-searchable-drop-down-list
Sheet: Master Schedule

Date | Public Talk Title | Speaker | Congregation | Chairman | WT Reader
January 2020
5th |  |  | [NAME]
12th |  |  | Penshurst
19th |  |  | Bankstown
26th |  |  | Bethel
February 2020
2nd | CABR
9th |  |  | Riverstone
16th |  |  | Bradbury
23rd | CO TALK |  | N-7
March 2020
1st |  |  | [NAME]
8th | HEADQUARTERS REP VISIT SPECIAL MEETING  (DELAYED STREAM)
15th |  |  | [NAME]
22nd |  |  | [NAME]
29th |  |  | [NAME]
April 2020
5th |  | VIDEO RECORDING | SPECIAL TALK
12th
19th |  |  | Minto
26th
May 2020
3rd |  |  | [NAME]
10th |  |  | Matraville
17th | CACO
24th
31st
June 2020
7th
14th
21st
28th
July 2020
5th
12th
19th
26th
August 2020
2nd
9th
16th
23rd
30th | RC
September 2020
6th
13th
20th
27th
October 2020
4th
11th
18th
25th
November 2020
1st
8th
15th
22nd
29th
December 2020
6th
13th
20th
27th
Spreadsheet: louise_kitchen__24114__KO_Netco Grp _ EEs on 12-19
Sheet: Canada Support

Canada Support
GISID | EMPLOYEE_NAME | [NAME] | JOBGROUP
90152138 | BARDAL, CHELSEA | CAD Analyst | ANL-C
90006320 | CAPPELLETTO, MANUELA | [NAME] | ASSTEX-CS
90130788 | CRAWFORD, SHARON | [NAME] | ASSTEX-CS
90014612 | DAWES, CHERYL T | CAD Dir Accounting | DIR-CS
90144164 | [NAME], KELLY | CAD Spec Sr Accounting | SPECSR-CS
90009576 | GAFFNEY, CHRISTOPHER | CAD Counsel Sr | DIR-ST
90128948 | GILLIS, [NAME] | CAD Mgr Risk Management | MGR-CS
90133238 | HANSLIP, [NAME] | CAD Mgr Acctg | MGR-CS
90012708 | HEDSTROM, PEGGY E | CAD VP Trans Supt | VP-CS
90014636 | HEMSTOCK, ROBERT N | CAD Dir Sr Govt Affairs | DIRSR-CS
90009552 | JOHNSTON, GREG | Counsel SR | DIR-ST
90009551 | KEOHANE, [NAME] | CAD VP & [NAME] Cnsl | VP-ST
90143885 | LIKNES, ANGELA | [NAME] | ADM-CS
90147385 | LUC, ALBERT | CAD Staff Risk Management | SPECJR-CS
90008892 | MARRYOTT, [NAME] | Dir IT | DIR-ST
90042107 | MARTIN, BRAD K | CAD Spec IT Non-Development | SPEC-ST
90006397 | MCCULLOCH, ANGELA | CAD [NAME] | ASST-CS
90151441 | MOSCOSO, MIRNA | CAD Spec Trans Supt | SPEC-CS
90006390 | O'NEIL, CARLA M | CAD [NAME] | ASSTSR-CS
90142850 | PANCHUK, CATHERINE | CAD Spec Acctg | SPEC-CS
90144332 | PATTERSON, GRANT | CAD Spec Acctg | SPEC-CS
90013446 | PRIOR, [NAME] A | CAD Spec Sr Trans Supt | SPECSR-CS
90139796 | PUNJA, KARIM | CAD Staff Volume Mgmt | SPECJR-CS
90157474 | QUON, SANDRA | CAD Spec Sr Accounting | SPECSR-CS
90014699 | REEVES, M. KATHY KATHY | CAD Mgr Risk Management | MGR-CS
90013443 | RIPLEY, DIANNE P | CAD Spec Trans Supt | SPEC-CS
90132395 | RONDEAU, CLAYTON | CAD Staff IT Non-Development | SPECJR-ST
90011530 | SCOTT, LAURA E | CAD VP Accounting | VP-CS
90013445 | SEIB, DIANNE | CAD Spec Sr Trans Supt | SPECSR-CS
90154810 | SLATER, [NAME] | CAD Staff IT Non-Development | SPECJR-ST
90131291 | TACKNEY, CONAL | CAD Staff Logistics | SPECJR-CS
90146200 | TU, MINH | CAD [NAME] | ASST-CS
90151467 | UNGER, CHRIS | CAD Spec Risk Management | SPEC-CS
90014616 | VANDER VELDE, NIKOLE | CAD Spec Sr Accounting | SPECSR-CS
 |  | Employees
Spreadsheet: 218804d1362585279-football-league-table-database
Sheet: Sumário - Tabela 2-3-1-1-1-1

Jornada | 9
[NAME] | 1 | 1 | Norwich City
Arsenal | 1 | 0 | Queen Parks Rangers
Reading | 3 | 3 | Fulham
Stoke City | 0 | 0 | Sunderland
Wigan Athletic | 2 | 1 | West Ham United
Manchester City | 1 | 0 | Swansea City
Everton | 2 | 2 | Liverpool
Newcastle United | 2 | 1 | West Bromwich Albion
Southampton | 1 | 2 | [NAME]
Chelsea | 2 | 3 | [NAME]
Spreadsheet: 854792d1704549363-custom-formula-for-subscription-calculations-as-needed-monthly-annually-subscriptions
Sheet: Subscriptions

PAYEE | AMOUNT | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
CallingCard.com | 10 | x
E-Z Pass | 70 | x
SiriusXM.com | 22.89 | x | x | x | x | x | x | x | x | x | x | x | x
Experian.com | 29.99 | x | x | x | x | x | x | x | x | x | x | x | x
Netflix.com | 22.99 | x | x | x | x | x | x | x | x | x | x | x | x
HomeAgain.com | 24.99 |  |  |  | x
Ring.com | 39.99 |  |  |  |  |  |  | x
MONTH | MONTHLY AMOUNT
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
Spreadsheet: 54885d1254933118-select-from-list-and-it-pulls-data-from-corresponding-sheet-listandworksheet
Sheet: RMA Baseline

RMA Baseline:
SW Publish Assets
 | 0-1MM | 1-3MM | 3-5MM | 5-10MM | 10-25MM | 25MM and Over | All
Type of Statement
Unqualified | #N/A
Reviewed
Compiled
Tax Returns
Other
Number of Statements
ASSETS
Cash & Equivalents
Trade Receivables - (net)
Inventory
All Other Current Assets
Total Current Assets
Fixed Assets (net)
Intangibles (net)
All Other Non-Current Assets
Total Assets
LIABILITIES
Notes Payable-Short Term
Cur. Mat.-L/T/D
Trade Payables
Income Taxes Payable
All Other Current Liabilities
Total Current Liabilities
Long Term Debt
Deferred Taxes
All Other Non-Current Liabilities
Net Worth
Total Liabilities & Net Worth
INCOME DATA
Net Sales
Gross Profit
Operating Expenses
Operating Profit
All Other Expenses (net)
Profit Before Taxes
RATIOS
Current - upper
Current - median
Current - lower
Quick - upper
Quick - median
Quick - lower
Sales / Receivables - upper
Sales / Receivables - median
Sales / Receivables - lower
Cost of Sales / Inventory - upper
Cost of Sales / Inventory - median
Cost of Sales / Inventory - lower
Cost of Sales / Payables - upper
Cost of Sales / Payables - median
Cost of Sales / Payables - lower
Sales / Working Capital - upper
Sales / Working Capital - median
Sales / Working Capital - lower
EBIT / Interest - upper
EBIT / Interest - median
EBIT / Interest - lower
Net Profit + DDA / Curr Mat LTD - upper
Net Profit + DDA / Curr Mat LTD - median
Net Profit + DDA / Curr Mat LTD - lower
Fixed / Worth - upper
Fixed / Worth - median
Fixed / Worth - lower
Debt / Worth - upper
Debt / Worth - median
Debt / Worth - lower
% Profit before Taxes / Tangible Net Worth - upper
% Profit before Taxes / Tangible Net Worth - median
% Profit before Taxes / Tangible Net Worth - lower
% Profit before Taxes / Total Assets - upper
% Profit before Taxes / Total Assets - median
% Profit before Taxes / Total Assets - lower
Sales / Net Fixed Assets - upper
Sales / Net Fixed Assets - median
Sales / Net Fixed Assets - lower
Sales / Total Assets - upper
Sales / Total Assets - median
Sales / Total Assets - lower
% Depr, Depl, Amort / Sales - upper
% Depr, Depl, Amort / Sales - median
% Depr, Depl, Amort / Sales - lower
% Officers', Directors', Owners' Comp / Sales - upper
% Officers', Directors', Owners' Comp / Sales - median
% Officers', Directors', Owners' Comp / Sales - lower
Net Sales ($)
Total Assets ($)