tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 593529d1539191474-populate-cell-based-on-previous-cells-formula-kopa_samsu
Sheet: Sheet1

DATA EXAMPLE #1 |  |  |  |  |  |  |  |  |  | TABLE 1 |  |  |  | TABLE 2
 |  |  |  |  |  |  |  |  |  | 1 | 11 | 111 |  | A | AA | AAA
 |  |  |  |  |  |  |  |  |  | 2 | 22 | 222 |  | B | BB | BBB
 |  |  |  |  |  |  |  |  |  | 3 | 33 | 333 |  | C | CC | CCC
 |  |  |  |  |  |  |  |  |  | 4 | 44 | 444 |  | D | DD | DDD
 |  |  |  |  |  |  |  |  |  | 5 | 55 | 555 |  | E | EE | EEE
 |  |  |  |  |  |  |  |  |  | 6 | 66 | 666 |  | F | FF | FFF
 |  |  |  |  |  |  |  |  |  | 7 | 77 | 777 |  | G | GG | GGG
 |  |  |  |  |  |  |  |  |  | 8 | 88 | 888 |  | H | HH | HHH
 |  |  |  |  |  |  |  |  |  | 9 | 99 | 999 |  | I | II | III
DATA EXAMPLE #2
DATA EXAMPLE #2
Spreadsheet: 93413d1292993629-excel-2007-splitting-checkbox-choice-data-in-pivot-table-2011-objectives-engagement-report
Sheet: Engagements

Account ID | Client Name | CA Resource | Attendance Date | # [NAME] | Web/Onsite/Project | Training/SC | Training/Engagement Type | Notes | Item Type | Path | Status | Group | Regional-Vertical | Sales Rep | [NAME] | Initial Request Date | Renewal Date | Revenue Expectation | Current Contract Amt | Renewal Amt | Off-cycle Revenue | Initial Objectives | Completed Objectives | Executive Summary | Notes2 | Last Updated
103+393 | Test Data 1 | [NAME] | 2011-01-02 00:00:00 | 1 | Onsite | SC Engagement | Benchmarking;#Account Review |  | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Engagements
230-23 | Test Client 2 | [NAME] | 2011-01-03 00:00:00 | 5 | Webinar | Training | CAN |  | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Engagements
230-23 | Test Client 2 | [NAME] | 2011-01-02 00:00:00 | 3 | Onsite | Training | [NAME] Demo;#Diversity |  | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Engagements
230-23 | Test Client 2 | [NAME] | 2011-02-03 00:00:00 | 19 | Onsite | Training | [NAME] |  | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Engagements
334+3T | new client 2 | [NAME] | 2011-07-01 00:00:00 | 3 | Webinar | Training | [NAME] |  | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Engagements
393+3t | Client 3 | [NAME] | 2011-01-04 00:00:00 | 9 | Onsite | SC Engagement | Job Posting Best Practices;#Job Posting Analysis |  | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Engagements
393+3t | Client 3 | [NAME] | 2011-01-04 00:00:00 | 29 | Webinar | Training | [NAME] Demo;#Job Posting Best Practices |  | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Engagements
4939-39 | Client 4 | [NAME] | 2011-01-03 00:00:00 | 4 | Webinar | Training | [NAME] |  | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Engagements
4a6-444 | new client 1 | [NAME] | 2011-04-01 00:00:00 | 39 | Onsite | Training | Job Posting Analysis;#Cloud Training;#Crazy stuff |  | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Engagements
642+39 | client 6 | [NAME] | 2011-01-04 00:00:00 | 5 | Webinar | SC Engagement | Job Posting Best Practices;#Job Posting Analysis |  | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Engagements
753+09 | client 7 | [NAME] | 2011-01-04 00:00:00 | 1 | Webinar | SC Engagement | Job Posting Best Practices;#Job Posting Analysis |  | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Engagements
999+999 | added client 99 | [NAME] | 2011-04-01 00:00:00 | 37 | Onsite | Training | [NAME] |  | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Engagements
Spreadsheet: 221707d1363645045-trying-to-get-dynamic-shading-removing-shading-if-conditions-are-met-table-plan-sheet
Sheet: Sheet1

 |  |  | Name (Alphabetical) | Table
 |  |  | Name | Table
 |  |  | Name | Table
Spreadsheet: 159272d1338565474-fill-cell-color-due-to-referenced-cell-value-sample
Sheet: break Down

OPERATION BULLETIN
BUYER |  | ITEM
STYLE |  | NO OF WORKERS
 |  | TARGET
 |  | S/N
 |  | O/L
 |  | 3T O/L
 |  | 4T O/L
 |  | 5T O/L
 |  | F/L
 |  | PICOT
 |  | HEL
 |  | D/N
NO | OPERATION | M/C | S.M.V | [NAME] | MAN | [NAME]
 |  |  |  | Hr | LVL | 8 Hr
1 | SDSDSDSA | 380 | 0.45
2
3
4 | dfdfdfdsfds | S/N | 0.25 |  |  |  |  |  | I need to highlight that |  | gray colored cell (column)  if I use that [NAME] raw in the layout worksheet
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
50
I | IRON
F | FOLDING
P | POLY BAGGING
C | CHECKING
S | SPC
 | TOTAL
 | ________________________ |  | ________________________
 | WORK STUDY EXECUTIVE |  | WORK STUDY MANAGER
NO | MACHINE TYPE | FEEDING TIME
1 | S/N | 3
2 | 522 | 4
3 | 380 | 4
4 | O/L | 3
5 | 3T O/L | 5
6 | 4T O/L | 5
7 | F/L HEM | 6
8 | F/L CY | 6
9 | F/L COV | 6
10 | F/L BIN | 6
11 | F/L FLAT | 6
12 | D/N | 6
13 | B/ATT | 5
14 | B/HOLE | 5
15 | B/TACK | 5
16 | SNAP
17 | IRON
18 | HEL | 3
Spreadsheet: 261cf056-6afd-44f8-b4a2-7099c43f89f1
Sheet: Sheet1

COURSE ASSESSMENT MATRIX | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
COURSE: ANTH 213 TRIBAL SOCIETIES IN TODAY'S WORLD
Objective | Assessment Method | Desired Result | Corrective Action
Describe different indigenous groups, including their cultures, histories, and current struggles | Participation Reading reports Oral report Midterm & final exams | Pass rate in said assignments: 70% | Revise reading assignments Revise lecture/online class content Revise exams
Explain strategies for recognition and involvement at the local, national and interational level. | Participation Reading reports Midterm & final exams | Pass rate in said assignments: 70% | Revise reading assignments Revise lecture/online class content Revise exams
Describe the ethnography research method. | Participation Reading reports Midterm & final exams | Pass rate in said assignments: 70% | Revise reading assignments Revise lecture/online class content Revise exams
Spreadsheet: 169560d1342950100-finding-nth-character-in-a-cell-book1_rinocerinho
Sheet: Sheet1

 | Sum of Number and letter count |  | Number |  | First Letter | Number of Letters
2WW | 4 |  | 2 |  | W | 2
BBR | 3 |  |  |  | B | 3
12 | 12 |  | 12 |  |  | 0
11UB | 13 |  | 11 |  | U | 2
5RGW | 8 |  | 5 |  | R | 3
Spreadsheet: 841664d1693839812-date-and-time-matching-between-2-sheets-match-date-and-time
Sheet: Sheet2

Date | Time | Value | Desired result
2023-08-02 00:00:00 | 20:15:00.000000 | 15477.75
2023-08-02 00:00:00 | 20:16:00.000000 | 15474.5
2023-08-02 00:00:00 | 20:17:00.000000 | 15472
2023-08-02 00:00:00 | 20:18:00.000000 | 15470
2023-08-02 00:00:00 | 20:19:00.000000 | 15468.5
2023-08-02 00:00:00 | 20:21:00.000000 | 15468.5
2023-08-02 00:00:00 | 20:22:00.000000 | 15469
2023-08-02 00:00:00 | 20:23:00.000000 | 15470.5
2023-08-02 00:00:00 | 20:24:00.000000 | 15467.75
2023-08-02 00:00:00 | 20:25:00.000000 | 15467.25
2023-08-02 00:00:00 | 20:26:00.000000 | 15469.5
2023-08-02 00:00:00 | 20:27:00.000000 | 15469
2023-08-02 00:00:00 | 20:28:00.000000 | 15468.25
2023-08-02 00:00:00 | 20:29:00.000000 | 15468.5
2023-08-02 00:00:00 | 20:30:00.000000 | 15468.25
2023-08-03 00:00:00 | 20:31:00.00000000 | 15470
Spreadsheet: 843220d1695135004-looking-for-a-formula-to-exclude-rows-from-a-filtered-table-workqueue-template-colbyjackqueso-
Sheet: Month YYYY

ID | Beneficiary ID | Last Name | First Name | DOB | Contract Num | State Code | County Code | TRC | TRC Short Name | File Name
25 | RAND0M1D-085/154/305 | JONES | MIKE | 19630226 | CONTRACT | SC | 0CC | 085 | NEW SCC | EFTO.RH6328.DTRRD.D230901
26 | RAND0M1D-085/154/306 | JONES | MIKE | 19630226 | CONTRACT | SC | 0CC | 154 | OUT OF AREA | EFTO.RH6328.DTRRD.D230901
27 | RAND0M1D-085/154/307 | JONES | MIKE | 19630226 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH6328.DTRRD.D230901
57 | TH1515ANMB1-305 | DUCK | [NAME] | 19510915 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH2171.DTRRD.D230902
87 | B3N3F1C1@RY-085/154/305 | [NAME] | MICKEY | 19500205 | CONTRACT | SC | 0CC | 085 | NEW SCC | EFTO.RH6328.DTRRD.D230907
88 | B3N3F1C1@RY-085/154/306 | [NAME] | MICKEY | 19500205 | CONTRACT | SC | 0CC | 154 | OUT OF AREA | EFTO.RH6328.DTRRD.D230907
89 | B3N3F1C1@RY-085/154/307 | [NAME] | MICKEY | 19500205 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH6328.DTRRD.D230907
107 | RUNN1NG0UT-305 | [NAME] | MINNIE | 19560804 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH2171.DTRRD.D230907
161 | 2M0R3EXMPL5-085/305 | JACOB | [NAME] | 19701008 | CONTRACT | SC | 0CC | 085 | NEW SCC | EFTO.RH2171.DTRRD.D230912
163 | 2M0R3EXMPL5-085/305 | JACOB | [NAME] | 19701008 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH2171.DTRRD.D230912
164 | [NAME] | WOMAN | WONDER | 19551108 | CONTRACT | SC | 0CC | 085 | NEW SCC | EFTO.RH2171.DTRRD.D230912
166 | [NAME] | WOMAN | WONDER | 19551108 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH2171.DTRRD.D230912
Spreadsheet: 812288d1673043078-lookup-cell-values-and-find-the-corresponding-missing-values-missing
Sheet: Sheet1

Task | Group |  |  |  |  |  | Missing
 | QC | QA | MM | MT | SC | OP
1 | R |  | A |  |  | I
2 | A |  |  | C
3 | A&R |  |  | C |  | A
4 |  | C | A/R |  | I
Spreadsheet: 82765d1282781623-extract-data-to-different-workbook-example-workbook
Sheet: 7

 |  |  | 2008-01-07 00:00:00
Location | Trips | Liters | Gallons
[NAME] | 1 | 378.5 | 100
Centurion | 2 | 757 | 200
Dragon | 3 | 1135.5 | 300
Bldg 0039 | 4 | 1514 | 400
Fac 1 | 5 | 1892.5 | 500
Man | 6 | 2271 | 600
Dog Pen | 7 | 2649.5 | 700
Canal | 8 | 3028 | 800
Hot | 9 | 3406.5 | 900
Fac2 | 10 | 3785 | 1000
 | 55 | 20817.5 | 5500
 | 385 | 145722.5 | 38500
Spreadsheet: darrell_schoolcraft__7335__imball0203
Sheet: DEFS

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled | Totals
1 | 674 |  | 34705 | 34133
2 | 318 |  | 34620 | 34133
3 | 423 |  | 34786 | 34133
4 | 713 |  | 34587 | 34133
5 | 772 |  | 34764 | 33120
6 | 596 |  | 34664 | 33120
7 | 408 |  | 34690 | 34133
8 | 294 |  | 33684 | 33120
9 | 239 |  | 33588 | 33120
10 | 273 |  | 33588 | 33120
11 | 223 |  | 33597 | 33120
12 | 246 |  | 33591 | 33120
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  | CBS Volume | 23995 | 22051
31 |  |  |  |  |  |  |  | -183022 | -164488
2002-02-28 00:00:00 | Balance | -1033420.01 |  | -647086.22
2002-03-12 00:00:00 | Balance
 |  |  |  | Contract #
 |  |  |  | 22864 | 0 | Zia |  |  | 22864
 |  |  |  | 20379 | -51695.87 | Grayco/Artesia |  |  | 20379 | 2979
 |  |  |  | 26357 |  | [NAME] |  |  | 26357
 |  |  |  | 21544 | 61340.16 | [NAME], [NAME] |  |  | 21544 | 36108
 |  |  |  | 24532 | -1200266.6 | 500211,500212,500219,500230 - Coburn points |  |  | 24532 | -169549
 |  |  |  | Duke
20379
24532
21544
26357
22864
23995
22051
21665
22664
24361
26393
24268
Spreadsheet: 788061d1658245019-sumifs-with-derived-criteria-sumifs_derived_criteria_exampleand-indexaggregate
Sheet: Reference Data

Sales Reps | Sales Areas | Region | Unique Region
[NAME] | Area 1 | North
[NAME] | Area 2 | North | South
Cath | Area 3 | South | East
[NAME] | Area 4 | South | West
Emma | Area 5 | East
Fred | Area 6 | East
Gemma | Area 7 | West
[NAME] | Area 8 | West
Ingrid
Spreadsheet: 111745d1308063251-linking-multiple-sheets-to-a-summary-sheet-client-marketing-endorsements
Sheet: Cumulative List

 |  |  |  |  |  | Client | Company | Term | Compensation | Commitment
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | Adrian Clayborn | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | Logan Payne | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
 |  |  |  |  |  | [NAME] | 0 | #N/A | #N/A | #N/A
Spreadsheet: 190635d1351723076-array-question-example
Sheet: Sheet1

 |  |  |  |  |  |  | US |  |  |  | AUS
 |  |  |  |  |  | Value |  | Number Of Values |  | Value |  | Number Of Values
 |  |  |  |  |  | > or = 1 |  | 4 |  | > or = 1 |  | 4
 |  |  |  |  |  | > or = 2 |  | 3 |  | > or = 2 |  | 4
 |  |  |  |  |  | > or = 3 |  | 2 |  | > or = 3 |  | 3
 |  |  |  |  |  | > or = 4 |  | 1 |  | > or = 4 |  | 3
 |  |  |  |  |  | > or = 5 |  | 1 |  | > or = 5 |  | 3
 |  |  |  |  |  | > or = 6 |  | 1 |  | > or = 6 |  | 3
 |  |  |  |  |  | > or = 7 |  | 1 |  | > or = 7 |  | 3
 |  |  |  |  |  | > or = 8 |  | 1 |  | > or = 8 |  | 3
 |  |  |  |  |  | > or = 9 |  | 1 |  | > or = 9 |  | 2
 |  |  |  |  |  | > or = 10 |  | 1 |  | > or = 10 |  | 2
value | country
1 | US
2 | US
12 | US
3 | US
4 | AUS
4 | AUS
8 | AUS
2 | AUS
Spreadsheet: 744707d1629386631-need-help-averaging-the-lowest-16-scores-out-of-20-while-discarding-an-entry-of-0-zero-scoresheet-for-excel-forum
Sheet: Susie Wergers Test Page

Date | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | Total Score | Total Putts
 | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts
2021-05-11 00:00:00 | 4 | 2 | 6 | 3 | 3 | 2 | 5 | 3 | 3 | 2 | 4 | 1 | 4 | 1 | 5 | 3 | 5 | 2
2021-05-18 00:00:00 | 6 | 2 | 5 | 2 | 5 | 2 | 4 | 2 | 4 | 2 | 3 | 0 | 3 | 2 | 3 | 2 | 5 | 3
2021-05-25 00:00:00 | 4 | 2 | 4 | 2 | 3 | 2 | 4 | 2 | 3 | 2 | 6 | 2 | 5 | 2 | 4 | 1 | 5 | 2
2021-06-01 00:00:00 | 3 | 2 | 3 | 2 | 3 | 2 | 3 | 2 | 3 | 3 | 3 | 1 | 3 | 2 | 3 | 2 | 3 | 2
2021-06-08 00:00:00 | 3 | 2 | 3 | 2 | 3 | 3 | 3 | 2 | 2 | 1 | 3 | 2 | 3 | 2 | 3 | 2 | 3 | 1
2021-06-15 00:00:00 | 3 | 3 | 3 | 2 | 3 | 2 | 3 | 1 | 3 | 3 | 2 | 1 | 3 | 3 | 3 | 3 | 3 | 3
2021-06-22 00:00:00 | 4 | 2 | 6 | 2 | 4 | 2 | 6 | 3 | 5 | 2 | 4 | 2 | 4 | 2 | 3 | 2 | 5 | 3
2021-06-29 00:00:00 | 4 | 2 | 4 | 2 | 5 | 2 | 5 | 2 | 4 | 2 | 5 | 2 | 3 | 2 | 4 | 2 | 4 | 2
2021-07-06 00:00:00 | 3 | 2 | 3 | 1 | 2 | 1 | 3 | 1 | 4 | 2 | 4 | 3 | 4 | 2 | 4 | 3 | 4 | 2
2021-07-13 00:00:00 | 4 | 1 | 4 | 1 | 4 | 2 | 5 | 3 | 4 | 2 | 2 | 1 | 4 | 2 | 4 | 2 | 5 | 2
2021-07-20 00:00:00 | 3 | 2 | 3 | 2 | 3 | 2 | 3 | 1 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 2 | 3 | 2
2021-07-27 00:00:00 | 5 | 2 | 4 | 2 | 4 | 3 | 3 | 2 | 3 | 2 | 3 | 1 | 3 | 2 | 4 | 3 | 4 | 2
2021-08-03 00:00:00 | 4 | 2 | 7 | 3 | 3 | 2 | 4 | 3 | 3 | 2 | 3 | 2 | 7 | 2 | 3 | 1 | 5 | 3
2021-08-10 00:00:00
2021-08-17 00:00:00 | 3 | 2 | 3 | 1 | 2 | 1 | 3 | 1 | 4 | 2 | 4 | 3 | 4 | 2 | 4 | 3 | 4 | 2
2021-08-24 00:00:00 | 4 | 2 | 5 | 2 | 4 | 2 | 3 | 2 | 5 | 3 | 3 | 1 | 4 | 2 | 4 | 2 | 3 | 2
2021-08-31 00:00:00 | 3 | 2 | 3 | 1 | 2 | 1 | 3 | 1 | 4 | 2 | 4 | 3 | 4 | 2 | 4 | 3 | 4 | 2
2021-09-07 00:00:00 | 3 | 2 | 3 | 1 | 2 | 1 | 3 | 1 | 4 | 2 | 4 | 3 | 4 | 2 | 4 | 3 | 4 | 2
2021-09-14 00:00:00 | 5 | 2 | 4 | 2 | 4 | 3 | 3 | 2 | 3 | 2 | 3 | 1 | 3 | 2 | 4 | 3 | 4 | 2
2021-09-21 00:00:00 | 3 | 2 | 4 | 2 | 5 | 3 | 4 | 2 | 2 | 1 | 4 | 2 | 4 | 2 | 3 | 2 | 3 | 1
[NAME] strokes per hole
Total strokes per hole
# of 0 putts |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total ->
Birdies |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total ->
Pars |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total ->
# of games played |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 87665d1287557763-time-calcs-wtih-decimal-results-time-logs_example
Sheet: Auto Calc

 | Name Here
 |  |  |  |  |  |  |  |  | 2010 Comp Time Balance Sheet
 |  |  |  |  |  |  |  |  | Month here
Date | Time In | Time Out | Lunch? | Required Work Hours | Total Hours | O/T Earned | Comments |  | Date | Hours Used | Comments | Balance
 |  |  |  |  |  |  | Previous Month Balance
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 | 06:00:00 | 19:00:00 | :30 | 1900-01-08 00:00:00
 | 06:00:00 | 19:00:00 | 01:00:00 | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  |  | 1900-01-08 00:00:00
 |  |  | Total O/T |  |  |  |  |  |  |  | TOTAL Balance Remaining
Spreadsheet: 779175d1651612562-issue-creating-a-dependent-drop-down-list-with-indirect-function-dependent-dropdown
Sheet: Sheet1

Club |  | BV | Makray |  |  | Club | Tee
Bull Valley Golf Club | BV | Tip of the Horn | Black |  |  | [NAME]
[NAME] | Makray | Grey | Gold
 |  | White | Silver
 |  | Green | Green
 |  | Greenhorn | [NAME]
Spreadsheet: 741011d1626771894-how-to-calculate-compound-annual-growth-rate-cagr-with-negative-ending-cagr
Sheet: Sheet2

I'm kindly asking for help on my formula below is not producing a solution if there is negative percentsge, It produces = #[NAME]
Compound annual growth rate (CAGR) |  |  |  | Year | Returns
2010 | 0.3 |  |  | 2010
2015 | -0.02
YEARS
CAGR
Using RRI function
 |  |  |  |  |  | Expected result per cell B5
Spreadsheet: 730112d1619550991-need-help-finding-duplicate-values-on-separate-sheets-to-add-value-of-another-cell-book-for-forum
Sheet: Sheet2

Company | Main Industry
Fedex | Postal
Lowes | Hardware
[NAME] | Hardware
Home Depot | Hardware
Goldman Sachs | Finance
USPS | Postal
Capital One | Finance
Discover Card | Finance
Walmart | Grocery
Food Lion | Grocery
Spreadsheet: 866454d1713363547-two-separate-large-databases-that-need-to-be-merged-exce-problem
Sheet: Sheet1

INCIDENT | DATE TIME | ADDRESS | ZIP | RPT AREA |  |  | INCIDENT | [NAME] | DATE TIME | ADDRESS | ZIP | RPT AREA
DATABASE I
20200014146 | 01/07/2020  20:25 | HICKORY TRACE DR |  | 8655 |  |  | 20200013982 | Psychological Evaluation | 01/07/2020  14:08 | 931 ILAWOOD DR | 37013 | 8757
20200013982 | 01/07/2020  14:08 | 931 ILAWOOD DR | 37013 | 8757 |  |  | 20200011746 | Matter of Record | 01/06/2020  17:55 | 779 HUNTINGTON PKWY | 37211 | 8653
20200011746 | 01/06/2020  17:55 | 779 HUNTINGTON PKWY | 37211 | 8653 |  |  | 20200010720 | Shoplifting | 01/06/2020  08:48 | 5824 NOLENSVILLE PIKE | 37013 | 8757
20200010720 | 01/06/2020  08:48 | 5824 NOLENSVILLE PIKE | 37013 | 8757 |  |  | 20200009768 | Intimidation | 01/05/2020  19:47 | NOLENSVILLE PIKE |  | 8757
20200009768 | 01/05/2020  19:47 | NOLENSVILLE PIKE |  | 8757 |  |  | 20200009575 | Matter of Record | 01/05/2020  16:51 | 5824 NOLENSVILLE PIKE | 37013 | 8757
20200009575 | 01/05/2020  16:51 | 5824 NOLENSVILLE PIKE | 37013 | 8757 |  |  | 20200009207 | Motor Vehicle Theft | 01/05/2020  11:17 | HUNTINGTON PKWY |  | 8653
20200009207 | 01/05/2020  11:17 | HUNTINGTON PKWY |  | 8653 |  |  | 20200008814 | Simple Assault | 01/05/2020  04:49 | 5319 NOLENSVILLE PIKE | 37211 | 8655
20200009067 | 01/05/2020  09:06 | 637 MONTE CARLO DR | 37013 | 8757
20200008814 | 01/05/2020  04:49 | 5319 NOLENSVILLE PIKE | 37211 | 8655
DATABASE II
INCIDENT | CODE | NIBRS | CRIME
20200008814 | 09 | 13B | Simple Assault
20200009207 | 16 | 240 | Motor Vehicle Theft
20200009575 | 17 | 740 | Matter of Record
20200009768 | 17 | 13C | Intimidation
20200010720 | 09 | 23C | Shoplifting
20200011746 | 17 | 740 | Matter of Record
20200013982 | 13 | 770 | Psychological Evaluation
Spreadsheet: 770103d1645809579-sum-up-in-one-colomn-from-2-different-colomn-sumifs-qs-v2
Sheet: Google Analytics

 | Channel | Sub-Channel | Sessions | Transactions | Revenue
 | B7 | C16 | 95 | 0 | 0
 | B43 | C10 | 14 | 0 | 0
 | B43 | C10 | 1 | 0 | 0
 | B33 | C17 | 30 | 0 | 0
 | B7 | C16 | 60 | 1 | 169.7531111111111
 | B43 | C10 | 1 | 0 | 0
 | B37 | C26 | 66 | 0 | 0
 | B5 | C15 | 53992 | 1144 | 100183.9622222222
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 4

 | October 11 | October 18 | October 25 | November 1 | November 8
Total Interest Rate*
SDs and MSPs** | 17423 | 13448 | 8267 | 13277 | 13773
Other | 18234 | 15445 | 13663 | 19632 | 21885
Total Cross-Currency
SDs and MSPs | 840 | 436 | 444 | 802 | 1115
Other | 330 | 158 | 260 | 330 | 607
Total Credit
SDs and MSPs | 11603 | 11740 | 8707 | 8815 | 9221
Other | 8668 | 9490 | 6909 | 6932 | 7004
Total FX | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL
Weekly total, swap ticket volumes by asset class and participant type (number of new trades), all products and tenors, cleared and uncleared. For cleared swaps, the creation of each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, each trade is attributed to both swap counterparties. All price-forming trade events, including new trades, terminations, amendments, and novations, are included in ticket volumes. Because this table shows transactions by participant, the totals on this table are twice those displayed on the "Transaction Ticket Volume by Cleared Status" table.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 121651d1316216759-transferring-and-transposing-data-2011test
Sheet: 2-Team Schedule

 |  | Home (vs) or    Away (at) | Opponent | Line | Pts For | Pts Ag'st | ATS | SU
TEAM A | 2011-09-03 00:00:00 | vs | TEAM D | 27.5 | 19 | 54 | L | L |  | 40789TEAM A
TEAM A | 2011-09-08 00:00:00 | at | TEAM E | -11 | 28 | 23 | L | W |  | 40794TEAM E
TEAM B | 2011-09-03 00:00:00 | vs | TEAM E | -6 | 36 | 29 | W | W |  | 40789TEAM B
TEAM B | 2011-09-08 00:00:00 | vs | TEAM C | -13.5 | 37 | 14 | W | W |  | 40794TEAM B
TEAM C | 2011-09-03 00:00:00 | vs | TEAM F | -35.5 | 51 | 17 | L | W |  | 40789TEAM C
TEAM C | 2011-09-08 00:00:00 | at | TEAM B | 13.5 | 14 | 37 | L | L |  | 40794TEAM B
TEAM D | 2011-09-03 00:00:00 | at | TEAM A | -27.5 | 54 | 19 | W | W |  | 40789TEAM A
TEAM D | 2011-09-08 00:00:00 | vs | TEAM F | -4 | 17 | 24 | L | L |  | 40794TEAM D
TEAM E | 2011-09-03 00:00:00 | at | TEAM B | 6 | 29 | 36 | L | L |  | 40789TEAM B
TEAM E | 2011-09-08 00:00:00 | vs | TEAM A | 11 | 23 | 28 | W | L |  | 40794TEAM E
TEAM F | 2011-09-03 00:00:00 | at | TEAM C | 35.5 | 17 | 51 | W | L |  | 40789TEAM C
TEAM F | 2011-09-08 00:00:00 | at | TEAM D | 4 | 24 | 17 | W | W |  | 40794TEAM D