tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 113274d1309226865-help-with-if-with-a-few-added-queries-formula-query
Sheet: Sheet1

 |  |  |  | QUAL "Y" | 5
 |  |  |  | TOTAL "Y" |  | 0.15 |  | 50 | 0.075
 | "O" Order, "C" Carry, "D" Deliver | GP 1 | GP 2 | EST Grand Total | [NAME] | COMM METAL | BONUS COMM | FINANCE COMM | C/C COMM | TOTAL COMM
 | D | 950 | 450 |  | Y |  |  |  |  |  |  |  |  |  | O
 | D | 950 | 450 |  | Y |  |  |  |  |  |  |  |  |  | C
 | D | 950 | 450 |  | Y |  |  |  |  |  |  |  |  |  | D
 | D | 950 | 450 |  | Y
 | D | 950 | 450 |  | Y
 | D | 950 | 450 |  | Y
 | O | 950 | 450 |  | Y
 | C | 950 | 450 |  | Y
 | C | 950 | 450 |  | Y
 | IF B6 = "D" AND F6 = Y, PROVIDED F4 = OR > F3 THEN INSERT VALUE IN I4 INTO I6
Spreadsheet: 04eae716-7760-4dec-95ab-8ec800de0f46
Sheet: Sheet1

Who is doing What and Where (3W) - WASH Cluster - Floods 2011 Response | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] of beneficiaries reached (Individuals) |  |  |  |  |  |  | Contact Details
Funding Organization | Implementing Organization | Project code | Project Title | Activity Type | Activity Description/ Name of items distributed | Quantity to Date (in Liters if applicable) | Unit (kit, bottle, tanker, etc.) | Capacity of Unit (eg tanker or bladder size, etc. - if applicable) | Activity Start Date/Items Distribution Start Date | Activity/Items Distribution Planned End Date | Province | District | Tehsil | Pcode | Union Council | Camp Name (if applicable) | Longitude (if known) | Latitude (if known) | Total Individuals | Total Number of Beneficiaries Reached | Beneficiaries Type (Individuals, Families/HH) | Date of Latest Information on Beneficiaries Reached | Total Number of Target Beneficiaries | Male | Female | Children  (0-2 years) | Children < 5 | Children 5-15 years | CBA Women | PL Women | Name | Mobile | [NAME] | Comments (Constraints Only)
Spreadsheet: gerald_nemec__11343__Exec Contract Payment
Sheet: Sheet1

 |  | ENA Executory Contract Payment History
 | Service Month |  | Billing Amount |  | Payment Received
 | 2000-10-01 00:00:00 |  |  |  | 2000-11-02 00:00:00
 | 2000-11-01 00:00:00 |  |  |  | 2000-12-04 00:00:00
 | 2000-12-01 00:00:00 |  |  |  | 2001-01-02 00:00:00
 | 2001-01-01 00:00:00 |  |  |  | 2001-02-05 00:00:00
 | 2001-02-01 00:00:00 |  |  |  | 2001-03-01 00:00:00
 | 2001-03-01 00:00:00 |  |  |  | 2001-04-01 00:00:00
 | 2001-04-01 00:00:00 |  |  |  | 2001-05-01 00:00:00
 | 2001-05-01 00:00:00 |  |  |  | 2001-06-01 00:00:00
 | 2001-06-01 00:00:00 |  |  |  | 2001-07-01 00:00:00
 | 2001-07-01 00:00:00 |  |  |  | 2001-08-01 00:00:00
 | 2001-08-01 00:00:00 |  |  |  | 2001-09-01 00:00:00
 | 2001-09-01 00:00:00 |  |  |  | 2001-10-01 00:00:00
 | 2001-10-01 00:00:00
 | 2001-11-01 00:00:00
 | 2001-12-01 00:00:00
 |  |  |  | Balance Due
 |  |  | -50000 | Settlement Discount
 |  |  |  | Settlement Payment Due NBP
 |  |  | 1158642 | 20/20 Closing Payment Due ENA
 |  |  |  | Net Payment to NBP
 |  |  | 669600 | Payment week of Oct.1
 |  |  |  | Payment on Nov. 1
Spreadsheet: 272814d1382521163-looking-up-earliest-and-latest-time-values-copy-of-201310-ans
Sheet: Sheet3

Time IN | Shift Start | 2013-10-01 00:00:00 | 2013-10-02 00:00:00 | 2013-10-03 00:00:00 | 2013-10-07 00:00:00 | 2013-10-08 00:00:00 | 2013-10-09 00:00:00 | 2013-10-10 00:00:00 | 2013-10-11 00:00:00 | 2013-10-14 00:00:00 | 2013-10-15 00:00:00 | 2013-10-16 00:00:00 | 2013-10-17 00:00:00 | 2013-10-18 00:00:00 | 2013-10-19 00:00:00 | 2013-10-20 00:00:00 | 2013-10-21 00:00:00 | 2013-10-22 00:00:00 | 2013-10-23 00:00:00 | 2013-10-24 00:00:00 | 2013-10-25 00:00:00 | 2013-10-26 00:00:00 | 2013-10-27 00:00:00 | 2013-10-28 00:00:00 | 2013-10-29 00:00:00 | 2013-10-30 00:00:00 | 2013-10-31 00:00:00
Employee 1 | 20:00:00
Employee 2 | 20:00:00
Employee 3 | 20:00:00
Employee 4 | 20:00:00
Employee 5 | 20:00:00
Employee 6 | 20:00:00
Employee 7 | 20:00:00
Employee 8 | 20:00:00
Employee 9 | 20:00:00
Employee 10 | 20:00:00
Employee 11 | 20:00:00
Employee 12 | 20:00:00
Employee 13 | 20:00:00
Employee 14 | 20:00:00
Employee 15 | 20:00:00
Employee 16 | 20:00:00
Employee 17 | 20:00:00
Employee 18 | 20:00:00
Employee 19 | 20:00:00
Employee 20 | 20:00:00
Employee 21 | 20:00:00
Employee 22 | 20:00:00
Employee 23 | 20:00:00
Employee 24 | 20:00:00
Spreadsheet: 722482d1615293393-formula-to-pick-up-most-recent-date-against-reference-code-document-index
Sheet: Index Database

 | Document Date | Ref | Project | Total Capital Value (£'000) | Total Revenue Value (£'000)
 | 2020-08-04 00:00:00 | PR00A-01 | Document A1 | 116.321796 | 347.23092
 | 2020-08-04 00:00:00 | PR00X-15 | Document X15 | 170.673 | 4.32
 | 2020-08-19 00:00:00 | PR00A-01 | Document A1 | 116.321796 | 347.23092
 | 2020-08-19 00:00:00 | PR00X-07 | Document X7 | 0 | 0
 | 2020-09-09 00:00:00 | PR00X-07 | Document X7 | 100.9923536 | 257.6
 | 2020-10-21 00:00:00 | PR00B-02 | Document B2 | 0 | 0
 | 2020-10-21 00:00:00 | PR00B-03 | [NAME] | 0 | 0
 | 2020-10-21 00:00:00 | PR00B-08 | [NAME] | 1100 | 0
 | 2020-10-21 00:00:00 | PR00X-07 | [NAME] | 100.9923536 | 257.6
 | 2020-10-21 00:00:00 | PR00X-16 | [NAME] | 919.39896 | 0
 | 2020-11-04 00:00:00 | PR00B-03 | [NAME] | 0 | 0
 | 2020-11-04 00:00:00 | PR00B-08 | [NAME] | 0 | 0
 | 2020-11-18 00:00:00 | PR00B-02 | Document B2 | 276.2 | 730.1
 | 2020-11-18 00:00:00 | PR00X-16 | [NAME] | 455.7 | 463.7
 | 2020-12-16 00:00:00 | PR00J-09 | Document J9 | 2527.9886128 | 2749.18761642
 | 2020-12-16 00:00:00 | PR00X-15 | Document X15 | 1462.41936 | 7585.70898
 | 2021-01-20 00:00:00 | PR00J-09 | Document J9 | 0 | 0
Spreadsheet: 214190d1360841520-sum-without-repetition-sample
Sheet: Data

Date | Station | Site | Job | Item | Description | Dimensions | Dimensions | Length | Unit | Thickness | Quantity | Area | Weight | Time Start | Time Finished | Skilled worker | Unskilled worker | Manufacturing time | MH | Total manhours
2013-02-02 00:00:00 | Hammering | 535 | 395 | SMS | Square to Round | 500x300 | 355 | 425 | [NAME] | 0.7 | 2 | 0.706 | 3.984 | 11:32:00 | 11:58:00 | 2 | 0
2013-02-02 00:00:00 | Hammering | 535 | 395 | SMS | [NAME] | 250 | 250 | 600 | [NAME] | 0.55 | 7 | 0.692 | 3.06 | 07:40:00 | 08:05:00 | 2 | 3
2013-02-02 00:00:00 | Hammering | 535 | 395 | SMS | Square to Round | 310x250 | 300 | 325 | [NAME] | 0.55 | 8 | 0.434 | 1.918 | 11:22:00 | 11:31:00 | 2 | 3
2013-02-02 00:00:00 | Manual Bending | 533 | 394 | SME | Straight | 500x200 |  | 610 | [NAME] | 1.2 | 1 | 0.866 | 8.398 | 06:42:00 | 06:47:00 | 1 | 2
2013-02-02 00:00:00 | Manual Bending | 533 | 394 | SME | Radius Offset | 1900x450 | 1900x450 | 390 | [NAME] | 1.2 | 1 | 1.911 | 18.532 | 06:48:00 | 07:05:00 | 0 | 2
2013-02-02 00:00:00 | Manual Bending | 533 | 394 | SME | Elbow | 2650x450 | 2650x450 | 10 | Deg | 1.2 | 2 | 7.135 | 69.206 | 07:25:00 | 08:05:00 | 0 | 2
2013-02-02 00:00:00 | Manual Bending | 535 | 395 | SMS | Square to Round | 500x300 | 355 | 425 | [NAME] | 0.7 | 1 | 0.706 | 3.984 | 07:40:00 | 07:45:00 | 0 | 2
2013-02-02 00:00:00 | Manual Bending | 535 | 395 | SMS | [NAME] | 250 | 250 | 600 | [NAME] | 0.55 | 1 | 0.692 | 3.06 | 07:45:00 | 07:50:00 | 0 | 2
2013-02-02 00:00:00 | Manual Bending | 535 | 395 | SMS | Square to Round | 310x250 | 300 | 325 | [NAME] | 0.55 | 1 | 0.434 | 1.918 | 07:50:00 | 07:55:00 | 0 | 2
 |  |  |  |  | You will notice here that A2 and A8 are the same product, but it is mentioned twice because it passed on two sations
 |  |  |  |  | The same goes for A3 and A9
Spreadsheet: mark_taylor__24741__EOL_Countries&Products_Status_10-27
Sheet: Cancelled Requests

 |  | CANCELLED PRODUCT REQUESTS |  |  |  | as of:
 | TRANSACTION  PRODUCTS
# | Commodity | Product | Country/Location | Business Unit | Business Unit  Contact | Process Manager | Responsibility |  |  | Scheduled for | Comments
 | Propane | Phy Index Purity | US | Petchems |  | [NAME] | [NAME] | Cancelled | Cancelled | TBD | 08/31 Working on initial draft. 09/06 [NAME] in progress. 9/22 Cancelled
 | Nat-Gasoline | Phy Index | US | Petchems |  | [NAME] | [NAME] | Cancelled | Cancelled | TBD | 08/31 Working on initial draft.  9/22 Cancelled
 | Isobutane | Phy Index | US | Petchems |  | [NAME] | [NAME] | Cancelled | Cancelled | N/A | 08/31 Working on initial draft. 09/06 [NAME] in progress. 9/14 Cancelled
 | AUCTION PRODUCTS
# | Commodity | Product | Country/Location | Business Unit | Business Unit  Contact | Process Manager | Responsibility |  |  | Scheduled for | Comments
Spreadsheet: 92757d1292319647-select-next-blank-row-tictoc131210
Sheet: Family Details

 | Family ID |  | Given Name | Other Name | Surname | Address 1 | Address 2 | Address 3 | City | Post Code | Home Phone | Work Phone | Mobile 1 | Mobile 2 | Email 1 | [NAME]
Hend/3 | Hend/3 | Alden Henderson | Alden | [NAME] | Henderson | 6 Ailesbury Road |  |  | Belfast | BT7 3FH | 028 90 293029 | 028 90 890866 | 07714 204088 | none | [EMAIL] | [EMAIL]
Davi/4 | Davi/4 | Other Davison | Other | Family | Davison | 1 Old Road |  |  | Belfast | BT12 1AB
/5
/6
[NAME]
/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
/59
/60
/61
/62
/63
/64
/65
/66
/67
/68
/69
/70
/71
/72
/73
/74
/75
/76
/77
/78
/79
/80
/81
/82
/83
/84
/85
/86
/87
/88
/89
/90
/91
/92
/93
/94
/95
/96
/97
/98
/99
/100
/101
/102
/103
/104
/105
/106
/107
/108
/109
/110
/111
/112
/113
/114
/115
/116
/117
/118
/119
/120
/121
/122
/123
/124
/125
/126
/127
/128
/129
/130
/131
/132
/133
/134
/135
/136
/137
/138
/139
/140
/141
/142
/143
/144
/145
/146
/147
/148
/149
/150
/151
/152
/153
/154
/155
/156
/157
/158
/159
/160
/161
/162
/163
/164
/165
/166
/167
/168
/169
/170
/171
/172
/173
/174
/175
/176
/177
/178
/179
/180
/181
/182
/183
/184
/185
/186
/187
/188
/189
/190
/191
/192
/193
/194
/195
/196
/197
/198
/199
/200
/201
/202
Spreadsheet: 767766d1644609750-how-to-calculate-accessories-left-with-formula-stock
Sheet: Sheet1

IN STOCK |  |  |  | GIVEN TO USERS
Date | Item | Qty |  | Given Date | User | Item | Qty | Left in stock
2022-02-01 00:00:00 | Earpods | 30 |  | 2022-01-01 00:00:00 | [NAME] | Earpods | 2
2022-02-01 00:00:00 | HDMI Cable | 50 |  | 2022-01-02 00:00:00 | [NAME] | HDMI Cable | 4
 |  |  |  | 2022-02-01 00:00:00 | User | Earpods | 1
 |  |  |  | 2022-02-05 00:00:00 | User | HDMI Cable | 5
Spreadsheet: 877139d1723815819-filter-function-to-extract-selected-columns-filter-by-selected-columns
Sheet: Sheet1

Data | County | Region | Support Coordinator | Supervisor |  | Criteria | Select Column names |  | Derised outcome | Support Coordinator | Supervisor
 | Walker | Region 1 | Diane Parsons | [NAME] |  |  | Support Coordinator |  |  | Diane Parsons | [NAME]
 | [NAME] | Region 3 | [NAME] | [NAME] |  |  | Supervisor |  |  | [NAME] | [NAME]
 | Fulton | Region 3 | [NAME] | [NAME] |  |  |  |  |  | [NAME] | [NAME]
 | Newton | Region 3 | [NAME] | [NAME] |  |  |  |  |  | [NAME] | [NAME]
 | [NAME] | Region 3 | [NAME] | [NAME] |  |  |  |  |  | [NAME] | [NAME]
 | [NAME] | Region 3 | [NAME] | [NAME] |  |  |  |  |  | [NAME] | [NAME]
Spreadsheet: 708267d1607699966-help-to-maybe-use-vlookup-to-quickly-copy-prices-from-table-b-to-a-sample
Sheet: b

SUPPLIERP/N | SEL-PRICE |  |  | duplicate check
EMK105B7104KVHF | 1
EMK107B7474KAHT | 3
HMJ212BB7223KGHT | 4
HMJ316BB7224KLHT | 9
HMJ325KC7475KMHPE | 10
HMK107B7223KAHT | 11
HMK212B7104KGHT | 12
HMK212BC7105KGHTE | 13
[NAME] | 14
TMJ316BB7106KLHT | 15
TMK105B7103KVHF | 16
TMK107AB7105KAHT | 28
TMK212B7225KGHT | 2
UMJ325KB7106KMHP | 3
UMK105B7102KVHF | 1
UMK105B7103KVHF | 5
UMK105B7104KVHF | 6
UMK105B7222KVHF | 8
UMK105B7223KVHF | 3
UMK105B7473KVHF | 9
UMK105B7682KVHF | 8
UMK105CG101JVHF | 9
UMK105CG220JVHF | 0
UMK105CG221JVHF | 2
UMK105CG271JVHF | 5
UMK105CG471JVHF | 7
UMK107B7103KAHT | 9
UMK107C7224KAHTE | 6
Spreadsheet: 155911d1337101609-how-to-add-rank-to-pivot-table-pe_list-test-edited-
Sheet: Pivot

 | Values
Row Labels | Average Company | Average Opportunities | Average People | Average R&R | Average WOrk | Average Work Env.
CM | 2 | 1 | 6 | 4 | 3 | 5 |  | Instead of the sum it should reflect as Ranks like below
Exit | 4 | 2.666666666666667 | 4 | 3.444444444444445 | 2.555555555555555 | 4.333333333333333 |  | Exit | 2 | 5 | 2 | 4 | 6 | 1
HRT | 3.5 | 2.785714285714286 | 4 | 3.142857142857143 | 3.785714285714286 | 3.785714285714286 |  | HRT | 4 | 6 | 1 | 5 | 2 | 2
Onboarding | 4.714285714285714 | 2.714285714285714 | 2.857142857142857 | 3.285714285714286 | 2.857142857142857 | 4.5
Scheduling | 2.75 | 1.75 | 3.5 | 4.25 | 3.75 | 5
Screening | 3.142857142857143 | 2.857142857142857 | 4.428571428571429 | 3.285714285714286 | 2.857142857142857 | 4.428571428571429
Securities | 3.5 | 2.5 | 5.5 | 2 | 4 | 3.5
10040 | 1 | 2 | 6 | 3 | 4 | 5
10041 | 6 | 3 | 5 | 1 | 4 | 2
Grand Total | 3.784313725490196 | 2.627450980392157 | 3.803921568627451 | 3.313725490196079 | 3.176470588235294 | 4.274509803921569
Spreadsheet: 81862d1282001894-excel-2008-numbers-in-range-workbook2
Sheet: Sheet1

 | FROM | TO | Missing | No.
 | 6 | 9 | 1 | 3 | no
 | 11 | 13 | 2 | 4 | no
 | 17 | 19 | 3 | 5 | no
 | 21 | 23 | 4 | 6 | yes
 | 26 | 29 | 5 | 7 | yes
 |  |  | 10 | 8 | yes
 |  |  | 14 | 9 | yes
 |  |  | 15 | 10 | no
 |  |  | 16 | 11 | yes
 |  |  | 20 | 12 | yes
 |  |  | 24 | 13 | yes
 |  |  | 25 | 14 | no
 |  |  |  | 15 | no
 |  |  |  | 16 | no
 |  |  |  | 17 | yes
 |  |  |  | 18 | yes
 |  |  |  | 19 | yes
 |  |  |  | 20 | no
 |  |  |  | 21 | yes
 |  |  |  | 22 | yes
 |  |  |  | 23 | yes
 |  |  |  | 24 | no
 |  |  |  | 25 | no
 |  |  |  | 26 | yes
 |  |  |  | 27 | yes
 |  |  |  | 28 | yes
 |  |  |  | 29 | yes
 |  |  |  | 30 | no
 |  |  |  | 31 | no
 |  |  |  | 32 | no
 |  |  |  | 33 | no
Spreadsheet: 841364d1693552207-match-date-on-two-different-pages-and-paste-data-in-columns-copy-of-copy-of-ef-file-
Sheet: 1-26 Night

 | CR1 | Priority | Headcount
1 | Alinity RV | 18 | 0.25
2 | Alinity RV | 17 | 0.25
3 | Alinity RV | 16 | 0.25
4 | Alinity RV | 15 | 0.25
5 | Alinity RV | 14 | 0.25
12 | [NAME] | 20 | 0.25
13 | [NAME] | 21 | 0.25
9 | Architect RV | 13 | 0.25
15 | Alinity SC | 12 | 0.25
16 | Architect RV | 19 | 0.25
17 | Alinity RV | 11 | 0.25
50 | Baxter SIV Assy | 22 | 3
31 | Architect RV | 10 | 0.25
8 | Alinity RV | 9 | 0.25
10 | Architect RV | 8 | 0.25
11 | [NAME] | 23 | 0.25
18 | Architect RV | 7 | 0.25
19 | Architect RV | 6 | 0.25
20 | Siemens Bases tray | 24 | 0.5
21 | Architect RV | 5 | 0.25
22 | Architect RV | 4 | 0.25
23 | Architect RV | 3 | 0.25
30 | Architect RV | 2 | 0.25
7 | Architect SC | 1 | 0.25
Total
 | CR2 | Priority
73 | PP4 | 3 | 0.25
74 | PP3 | 2 | 0.25
77 | Base Cassette B mold ES
78 | Side Cassette A mold | 1 | 0.25
79 | E/O Piston - ES
87 | [NAME] | 4 | 0.25
52 | Architect RV | 6 | 0.25
53 | Architect RV | 7 | 0.25
61 | [NAME] | 12 | 0.5
66 | [NAME] | 11 | 0.5
83 | Ceph OM#1
84 | Ceph MB#1 | 8 | 0.25
86 | [NAME] | 9 | 0.25
62 | NP227 | 10 | 0.25
63 | NP Birdcage
64 | Siemens 1ML | 13 | 0.25
67 | [NAME]
69
88 | [NAME] | 5 | 0.25
89 | Top Frame B mold
106
107
108
109
Total
Spreadsheet: 828436d1683486387-moved-from-libreoffice-to-excel-365-i-dont-know-why-formula-broke-oekonomi-marstal-ophold-help-me
Sheet: Offdays Automatic

Offday Calculator
Start |  |  |  | Salery Period |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacationdays spend |  | Paid Offdays |  | Result
Start date | 2022-12-21 00:00:00 |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Balance | 78.58 |  |  | To
Vacation days |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | To
Total | 42
Spend |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 0
Result |  |  |  | To
Rates
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 0
Hjemme | -1 |  |  | To
Mønstring | 0.82
[NAME] | 0.82 |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 80
Sygdom | 0 |  |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 0
 | From | To |  | To
Mønstring | 2023-01-11 00:00:00 | 2023-03-12 00:00:00 |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Mønstring | 2023-04-04 00:00:00 | 2023-05-20 00:00:00 |  | To
Mønstring | 2023-06-27 00:00:00 | 2023-08-08 00:00:00
Mønstring | 2023-09-19 00:00:00 | 2023-10-17 00:00:00 |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 0
Mønstring | 2023-11-16 00:00:00 | 2023-12-18 00:00:00 |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 0
 |  |  |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | To
Spreadsheet: 36785d1234732286-list-matching-with-dates-using-dates-as-filters-dates-3-question
Sheet: Sheet1

Start Employment Contract | End Employment Contract
<=3/5/1996 | >=3/5/1996
Start Employment Contract | End Employment Contract | Case | Result
1996-02-01 00:00:00 | 1996-05-01 00:00:00 | Case 1: The date is in the middle. | Remains
1996-03-05 00:00:00 | 1996-05-01 00:00:00 | Case 2: The Cutoff Date is at the start date. | Remains
1996-04-01 00:00:00 | 1996-05-01 00:00:00 | Case 3: The Cutoff Date is prior to the start date. | Filtered Out
1996-02-01 00:00:00 | 1996-03-05 00:00:00 | Case 4: The Cutoff Date is at the end date. | Remains
1996-02-01 00:00:00 | 1996-02-15 00:00:00 | Case 5: The Cutoff Date is after the end date. | Filtered Out
1996-03-05 00:00:00 | 1996-03-05 00:00:00 | Case 6: The Cutoff Date falls exactly on single day of employment. | Remains
Spreadsheet: kim_ward__20844__2001 Toll
Sheet: Sheet2

 |  | [NAME] |  | Mid Peak |  | On [NAME]
 |  | Energy | Demand | Energy | Demand | Energy | Demand
2000-07-01 00:00:00
2000-07-02 00:00:00 |  | 2000 | 2500
2000-07-03 00:00:00
2000-07-04 00:00:00
2000-07-05 00:00:00
2000-07-06 00:00:00
2000-07-07 00:00:00
2000-07-08 00:00:00
2000-07-09 00:00:00
2000-07-10 00:00:00
2000-07-11 00:00:00
2000-07-12 00:00:00
2000-07-13 00:00:00
2000-07-14 00:00:00
2000-07-15 00:00:00
2000-07-16 00:00:00
2000-07-17 00:00:00
2000-07-18 00:00:00
2000-07-19 00:00:00
2000-07-20 00:00:00
2000-07-21 00:00:00
2000-07-22 00:00:00
2000-07-23 00:00:00
2000-07-24 00:00:00
2000-07-25 00:00:00
2000-07-26 00:00:00
2000-07-27 00:00:00
2000-07-28 00:00:00
2000-07-29 00:00:00
2000-07-30 00:00:00
2000-07-31 00:00:00
Spreadsheet: 862852d1710431563-help-with-stack-bar-gantt-gantt_mrshorty
Sheet: after4

 | Task | Start Date | Duration | End Date |  |  | Start Date | End date |  | add data for dummy series
 | Task 1 | 2024-02-01 00:00:00 | 37
 | Task 2 | 2024-02-09 00:00:00 | 379 |  |  |  |  |  |  | 2025-01-01 00:00:00 | 3
 | Task 3 | 2024-02-09 00:00:00 | 405
 | Task 4 | 2024-07-10 00:00:00 | 268
 | Task 5 | 2024-07-10 00:00:00 | 16
 | Task 6 | 2024-12-09 00:00:00 | 16
 | Task 7 | 2025-03-20 00:00:00 | 15 |  |  | dummy series added to chart (green bar stacked on task 1)
 | Task 8 | 2025-04-04 00:00:00 | 7 |  |  | dummy series changed to line chart.
 |  |  |  |  |  | secondary horizontal axis added (defaults to a single day).
Spreadsheet: errol_mclaughlin_jr__10058__Budget Temp
Sheet: CC 103846 - Upload

SAP PROFIT CENTER:
PROFIT CENTER OWNER:
SAP COST CATEGORY:
SAP COST | SAP COST |  |  |  |  |  |  |  |  |  |  |  |  | Annual
CENTER | ELEMENT | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | Expense
 | 52000500
 | 52001000
 | 59003000
 | 52001500
 | 52002000
 | 52002500
 | 52003000
 | 52003500
 | 52004000
 | 52004500
 | 52503500
 | 52502000
 | 52507400
 | 52507000
 | 52507100
 | 52507200
 | 52507300
 | 52507500
 | 52507600
 | 52507700
 | 52508000
 | 52508100
 | 52508500
 | 53500000
 | 53500500
 | 53600000
 | 52500500
 | 52504100
 | 53800000
 | 53801000
 | 52504500
 | 54000000
 | 52502500
 | 52505500
 | 54005000
 | 52504200
 | 52506500
 | 52506000
 | 52503000
 | 52504000
 | 57200000
 | 57000000
 | 59099900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 82613d1282667731-swapping-of-cells-under-certain-condition-demo-file-2
Sheet: Sheet1

YNBD1a/s1 | HJRD1b/s1
HAQD1a/s2 | YNBD1a/s2
YNBD1a/s3 | HJRD1b/s1
YNBD1a/s1 | HAQD1a/s2
HJRD1b/s5 | YNBD1a/s2
YNBD1a/s1 | HAQD1a/s3
The desired table is following after swapping of cells.
YNBD1a/s1 | HJRD1b/s1
YNBD1a/s2 | HAQD1a/s2
YNBD1a/s3 | HJRD1b/s1
YNBD1a/s1 | HAQD1a/s2
YNBD1a/s2 | HJRD1b/s5
YNBD1a/s1 | HAQD1a/s3
Spreadsheet: 167507d1342014555-excel-2003-date-formatting-error-date-appears-one-way-but-is-read-another-way-excel-date-changer
Sheet: File that Needs dates changing

CSR Name | ActionDate
SMITH, BOB | 2011-12-01 00:00:00 | 2011-12
SMITH, BOB | 2011-11-18 00:00:00 | 2011-11
SMITH, BOB | 2011-11-17 00:00:00 | 2011-11
SMITH, BOB | 2011-10-10 00:00:00 | 2011-10
SMITH, BOB | 2011-10-05 00:00:00 | 2011-10
SMITH, BOB | 2011-10-03 00:00:00 | 2011-10
SMITH, BOB | 2011-09-13 00:00:00 | 2011-09
SMITH, BOB | 2011-08-16 00:00:00 | 2011-08
SMITH, BOB | 2011-08-09 00:00:00 | 2011-08
ROGERS, [NAME] | 2011-09-23 00:00:00 | 2011-09
ROGERS, [NAME] | 2011-09-13 00:00:00 | 2011-09
ROGERS, [NAME] | 2011-07-19 00:00:00 | 2011-07
ROGERS, [NAME] | 2011-06-14 00:00:00 | 2011-06
ROGERS, [NAME] | 2011-04-06 00:00:00 | 2011-04
ROGERS, [NAME] | 2011-01-24 00:00:00 | 2011-01
ROGERS, [NAME] | 2011-01-21 00:00:00 | 2011-01
ROGERS, [NAME] | 2011-01-14 00:00:00 | 2011-01
ROGERS, [NAME] | 2011-01-14 00:00:00 | 2011-01
CORDOVA, MARTY | 2011-12-28 00:00:00 | 2011-12
CORDOVA, MARTY | 2011-12-13 00:00:00 | 2011-12
CORDOVA, MARTY | 2011-11-18 00:00:00 | 2011-11
CORDOVA, MARTY | 2011-11-18 00:00:00 | 2011-11
CORDOVA, MARTY | 2011-10-04 00:00:00 | 2011-10
CORDOVA, MARTY | 2011-09-29 00:00:00 | 2011-09
CORDOVA, MARTY | 2011-09-09 00:00:00 | 2011-09
CORDOVA, MARTY | 2011-08-26 00:00:00 | 2011-08
CORDOVA, MARTY | 2011-07-05 00:00:00 | 2011-07
CORDOVA, MARTY | 2011-07-05 00:00:00 | 2011-07
CORDOVA, MARTY | 2011-05-20 00:00:00 | 2011-05