tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 110910d1307470088-trigger-and-target-references-break-with-insert-ref_macro
Sheet: CDE

CDE
Data Requirements | [NAME] | Additional Comments | Server 2 Detail | Server 2 Additional Comments | Server 3 [NAME] | Server 3 Additional Comments | Server 4 [NAME] | Server 4 Additional Comments | Server 5 [NAME] | Server 5 Additional Comments | Server 6 [NAME] | Server 6 Additional Comments | Server 7 [NAME] | Server 7 Additional Comments | Server 8 [NAME] | Server 8 Additional Comments | Server 9 [NAME] | Server 9 Additional Comments | Server 10 [NAME] | Server 10 Additional Comments | Server 11 [NAME] | Server 11 Additional Comments | Server 12 [NAME] | Server 12 Additional Comments | Server 13 [NAME] | Server 13 Additional Comments | Server 14 [NAME] | Server 14 Additional Comments | Server 15 [NAME] | Server 15 Additional Comments
General Information
Project number | 123456
PRID Number | 789
Project Manager (PM) Name | [NAME]
PM Phone | [PHONE]
PM Email Address | [EMAIL]
Tech Lead Name | [NAME]
Tech Lead Phone | [PHONE]
Tech Lead Email Address | [EMAIL]
Basic Info
Number of Servers | 1
Is this a DR server? | Yes
Is this a database server? | Yes
Does this server have external storage (SAN)? | Yes
Is this server clustered? | No
How many other servers in the cluster?
Do they already exist or are they new?
Do you require a new Cluster VIP?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes/No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Manager | Project Manager
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Manager | Project Manager
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Manager | Project Manager
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 128
Spreadsheet: 740073d1626174110-tracking-countif-sample-2-1-
Sheet: Zusatzzeiten

Datum
 |  |  |  |  |  |  |  |  | Break Even Tarif | inkl. [NAME] | Tarif pro Stunde
Name des Kindes |  |  |  |  |  |  |  | UG | 14
 |  |  |  |  |  |  |  | OG | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Runden
zusätzliche Betreuungszeit | Kind 1 - 3 Jahre (untere [NAME]) |  |  | Kind 3 - 6 Jahre (obere Gruppe) |  |  |  | Kalkulation neu |  |  |  |  |  |  |  |  |  | UG |  | OG
07:00 bis 12:30 | 31 |  |  | 29 |  |  |  | 5.5 |  |  |  |  |  |  |  | 0.6
07:00 bis 14:00 | 39 |  |  | 36 |  |  |  | 7 |  |  |  |  |  |  |  | 0.6
07:00 bis 17:00 | 56 |  |  | 52 |  |  |  | 10
12:30 bis 14:00 | 8 |  |  | 8 |  |  |  | 1.5
12:30 bis 17:00 | 25 |  |  | 23 |  |  |  | 4.5
14:00 bis 17:00 | 17 |  |  | 16 |  |  |  | 3
 |  |  |  |  |  |  |  | zusätzliche Betreuungszeit | Kind 1 - 3 Jahre (untere [NAME]) |  |  | Kind 3 - 6 Jahre (obere Gruppe)
 |  |  |  |  |  |  |  | 07:00 bis 12:30 | 25 |  |  | 23
 |  |  |  |  |  |  |  | 07:00 bis 14:00 | 29 |  |  | 27
Unterschrift des Erziehungsberechtigten: |  |  |  |  |  |  |  | 07:00 bis 17:00 | 33 |  |  | 31
 |  |  |  |  |  |  |  | 12:30 bis 14:00 | 8 |  |  | 6
 |  |  |  |  |  |  |  | 12:30 bis 17:00 | 14 |  |  | 12
 |  |  |  |  |  |  |  | 14:00 bis 17:00 | 10 |  |  | 8
 |  |  |  |  |  |  |  | Letztstand | 2019-09-17 00:00:00
Datum
Name des Kindes
zusätzliche Betreuungszeit | Kind 1 - 3 Jahre (untere [NAME]) |  |  | Kind 3 - 6 Jahre (obere Gruppe)
07:00 bis 12:30 | 31 |  |  | 29
07:00 bis 14:00 | 39 |  |  | 36
07:00 bis 17:00 | 56 |  |  | 52
12:30 bis 14:00 | 8 |  |  | 8
12:30 bis 17:00 | 25 |  |  | 23
14:00 bis 17:00 | 17 |  |  | 16
Unterschrift des Erziehungsberechtigten:
Spreadsheet: 9238ee00-4770-4571-abe7-0dabb9e664c4
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8531 | 63794 | [NAME] | Uzcategui | VEN | 0 | 00:17:49 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:59:46
8531 | 63670 | Frutos | [NAME] | ARG | 0 | 00:19:04 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 01:03:40
Spreadsheet: 772765d1647457069-conditional-formatting-with-partial-static-and-dynamic-text-excel-tms
Sheet: Sheet1 (JT)

< |  |  | After | I wanted this text to be highlighted |  | Using =AND(LEFT($A1,5)="10 00",ISNUMBER(SEARCH("not updated",$A1)))
 |  |  |  |  |  | Applied from Row 1 down
Day 1 |  |  | Day 1
10 00 3 not updated |  |  | 10 00 3 not updated
10 01 1 not updated |  |  | 10 01 1 not updated
Day 2 |  |  | Day 2
10 00 4 not updated |  |  | 10 00 4 not updated
10 01 1 not updated |  |  | 10 01 2 not updated
Day 3 |  |  | Day 3
10 00 5 not updated |  |  | 10 00 5 not updated
10 01 1 not updated |  |  | 10 03 1 not updated
Spreadsheet: 844296d1696008753-some-excel-tasks-forecast-and-demand-tasks
Sheet: Zad.5

Zad.5 | Below we have 4 indexes of materials, based on the tab with BOMs (Data for task.5) give what SKU codes they are used for.
INDEX RM | SKU codes
36270 | 1122 | 1132 | 1492 | CE811
36313 | 1612 | 1672 | 1682 | 1786 | CE182
36315 | 1252 | 1402 | 1572 | CE132 | CE232
36369 | 1142 | 1172 | 1482 | 1642
INDEX RM | SKU codes
36270
36313
36315
36369
Spreadsheet: 797477d1663916695-sum-of-product-sales-from-start-month-to-end-month-sum-of-product-sales-from-start-month-to-end-month
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | <- select start month
Product Sales | 2022-01-01 00:00:00 |  |  |  |  |  |  | Product Sales | 2022-04-01 00:00:00 | <- select end month
Product Sales 1 | 568 | 323 | 848 | 366 | 411 | 500 |  | Product Sales 1
Product Sales 2 | 887 | 992 | 422 | 391 | 667 | 757 |  | Product Sales 2
Product Sales 3 | 337 | 738 | 314 | 192 | 454 | 219 |  | Product Sales 3
Product Sales 4 | 960 | 150 | 190 | 872 | 206 | 670 |  | Product Sales 4
Product Sales 5 | 770 | 794 | 188 | 404 | 990 | 906 |  | Product Sales 5
Product Sales 6 | 923 | 209 | 686 | 559 | 906 | 709 |  | Product Sales 6
Product Sales 7 | 317 | 350 | 781 | 667 | 399 | 124 |  | Product Sales 7
Product Sales 8 | 980 | 715 | 590 | 717 | 544 | 107 |  | Product Sales 8
Product Sales 9 | 140 | 973 | 837 | 713 | 939 | 933 |  | Product Sales 9
Product Sales 10 | 181 | 204 | 850 | 746 | 296 | 224 |  | Product Sales 10
Product Sales 11 | 503 | 304 | 275 | 595 | 841 | 752 |  | Product Sales 11
Spreadsheet: 453950d1459533090-help-with-functions-for-a-novice-excel-user-sales-brackets
Sheet: Tables

From | To |  | 3 | 4 | 5 |  |  |  |  |  | Increment: | 500
8000 |  |  | 27.86 | 29.1 | 30.71
 |  |  | 28.45 | 29.66 | 31.39
 |  |  | 29.04 | 30.79 | 32.07
 |  |  | 29.63 | 30.79 | 32.74
 |  |  | 30.13 | 31.35 | 33.21 |  |  |  |  | 10750 | 30.75
 |  |  | 30.62 | 31.9 | 33.68
 |  |  | 31.12 | 32.46 | 34.15
 |  |  | 31.61 | 33.01 | 34.61
 |  |  | 32.02 | 33.41 | 35.07
 |  |  | 32.42 | 33.8 | 35.52
 |  |  | 32.82 | 34.2 | 35.52
 |  |  | 33.22 | 34.59 | 36.43
 |  |  | 33.47 | 34.84 | 36.67
 |  |  | 33.72 | 35.08 | 36.91
 |  |  | 33.97 | 35.32 | 37.15
 |  |  | 34.21 | 35.56 | 37.38
 |  |  | 34.45 | 35.78 | 37.59
 |  |  | 34.69 | 36 | 37.8
 |  |  | 34.93 | 36.22 | 34.93
 |  |  | 35.34 | 36.69 | 38.58
 |  |  | 35.34 | 36.69 | 38.58
 |  |  | 35.42 | 36.82 | 38.77
 |  |  | 35.5 | 36.94 | 38.95
 |  |  | 35.66 | 37.2 | 39.32
 |  |  | 35.82 | 37.45 | 39.68
 |  |  | 36 | 37.64 | 39.81
 |  |  | 36.18 | 37.82 | 39.94
 |  |  | 36.36 | 38 | 40.07
 |  |  | 36.54 | 38.18 | 40.19
 |  |  | 36.74 | 38.3 | 40.22
 |  |  | 36.93 | 38.41 | 40.24
 |  |  | 37.13 | 38.53 | 40.26
 |  |  | 37.32 | 38.64 | 40.28
 |  |  | 37.43 | 38.85 | 40.53
 |  |  | 37.53 | 39.05 | 40.78
 |  |  | 37.63 | 39.25 | 41.03
 |  |  | 37.73 | 39.45 | 41.27
 | 28000 |  | 39.73
Spreadsheet: louise_kitchen__22552__Hot List Update 07-11-01
Sheet: E-Commerce 50+

Deal Description Sheet - 7/9/01
[NAME]
Project Name | Lead Originator | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
Preston | [NAME] | Preston Energy | Sale of ATS software and/or ASP.  Enron commision from ATS. | 40000 | 2001-06-19 00:00:00 | 0.8 | 2001-09-01 00:00:00 | Preston is expected to purchase several of the ATS products.
Columbia Natural Resources | ?? |  | Application Service Provider, gas and liquids, E&P accounting, forecasting. | *$250,000 | 2001-04-16 00:00:00 | 0.5 | 2001-09-30 00:00:00 | ENA missed the supply deal, but is working on the outsourcing.  Lost to AEP who hid 3 1/4 for the pool gas.  ENA bid 1/4. CMR will start trading this summer.
Mariner | ?? | Mariner | Integrated outsourcing products. | *$100,000 | 2001-01-17 00:00:00 | 0.5 | 2001-10-01 00:00:00 | Follow up meeting in July, 2001.
Project Deep Blue Sea | [NAME] ? | Ocean Energy | Integrated outsourcing products and operations. | *$500,000 | 2001-06-11 00:00:00 | 0.5 | 2001-11-01 00:00:00 | Met with manager of operations on June 13th.  Met with Sr. Production Engineer regarding Harve Pipeline System and Field outsourcing on June 15th.  Additional data on pipeline and field will be made available in early July.
 |  |  |  |  |  |  |  | * Accrual
Spreadsheet: 390227d1429555425-sumif-while-finding-a-sum_range-sumif-example
Sheet: AggregatedDATA

Location Number | Day | Location | [NAME]
 | Sun | MNS - 205 | 3648.75
 | Sun | MNS - 211 | 1124.98
 | Mon | MNS - 105 | 1486.64
 | Mon | MNS - 106 | 866.35
 | Mon | MNS - 106 | 2221.12
 | Mon | MNS - 107 | 1688.66
 | Mon | MNS - 109 | 1790.72
 | Mon | MNS - 111 | 1427.93
 | Mon | MNS - 114 | 1607.35
 | Mon | MNS - 115 | 1008.48
 | Mon | MNS - 143 | 2343.51
 | Mon | MNS - 143 | 1001.72
 | Mon | MNS - 144 | 1394.4
 | Mon | MNS - 145 | 2548.37
 | Mon | MNS - 145 | 1922.08
 | Mon | MNS - 146 | 2258.21
 | Mon | MNS - 146 | 278.95
 | Mon | MNS - 201 | 742.96
 | Mon | MNS - 202 | 1321.04
 | Mon | MNS - 203 | 1112.43
 | Mon | MNS - 205 | 3048.31
 | Mon | MNS - 206 | 1874.6
 | Mon | MNS - 207 | 547.77
 | Mon | MNS - 208 | 447.32
 | Mon | MNS - 209 | 1159.77
 | Mon | MNS - 211 | 1409.51
 | Mon | MNS - 211 | 1866.75
 | Mon | MNS - 211 | 1485.45
 | Mon | MNS - 211 | 1856.06
 | Mon | MNS - 212 | 1657.28
 | Mon | MNS - 213 | 1634.97
 | Mon | MNS - 213 | 865.79
 | Mon | MNS - 213 | 1074.94
 | Mon | MNS - 214 | 1180.57
 | Mon | MNS - 215 | 250.94
 | Mon | MNS - 216 | 835.26
 | Mon | MNS - 217 | 273.7
 | Mon | MNS - 218 | 468.04
 | Mon | MNS - 219 | 1261.81
 | Tue | MNS - 105 | 1654.54
 | Tue | MNS - 106 | 785.68
 | Tue | MNS - 106 | 2601.04
 | Tue | MNS - 107 | 1576.45
 | Tue | MNS - 109 | 1886.05
 | Tue | MNS - 111 | 1342.19
 | Tue | MNS - 112 | 4285.36
 | Tue | MNS - 114 | 1739.71
 | Tue | MNS - 115 | 1214.82
 | Tue | MNS - 143 | 2275.26
 | Tue | MNS - 143 | 1250.47
 | Tue | MNS - 144 | 1671.57
 | Tue | MNS - 145 | 2170.56
 | Tue | MNS - 145 | 1853.75
 | Tue | MNS - 146 | 2759.05
 | Tue | MNS - 146 | 359.64
 | Tue | MNS - 201 | 874.28
 | Tue | MNS - 202 | 1432.84
 | Tue | MNS - 203 | 1154.53
 | Tue | MNS - 205 | 2055.37
 | Tue | MNS - 206 | 1722.78
 | Tue | MNS - 207 | 472.18
 | Tue | MNS - 208 | 403.62
 | Tue | MNS - 209 | 1096.25
 | Tue | MNS - 211 | 1304.45
 | Tue | MNS - 211 | 1593.69
 | Tue | MNS - 211 | 496.86
 | Tue | MNS - 211 | 1750.42
 | Tue | MNS - 212 | 1750.84
 | Tue | MNS - 213 | 1890.3
 | Tue | MNS - 213 | 635.01
 | Tue | MNS - 213 | 1099.68
 | Tue | MNS - 214 | 1230.08
 | Tue | MNS - 215 | 318.3
 | Tue | MNS - 216 | 802.55
 | Tue | MNS - 217 | 220.23
 | Tue | MNS - 218 | 562.9
 | Tue | MNS - 219 | 1268.34
Spreadsheet: michelle_lokay__27347__EOLTWdeals
Sheet: EOLDec01

 |  |  |  |  | New This Week
 | PRODUCTION  MONTH : |  |  |  | 2001-12-01 00:00:00 |  |  |  | Transwestern Pipeline Company
 | Contract | Shipper |  | Non | Term | Term | Monthly | # |  | Demand | Demand | Commodity | Total | Monthly | Monthly | Total Monthly | NOTES
 | # |  | Daily | [NAME] | Start | End | Volume | Days | MDQ | Monthly $ | Daily $ | per [NAME] | Rate | Demand | Commodity | Revenue
 | Total Deals
 |  |  |  |  |  |  | MMBtu |  | MMBtu |  |  |  |  | Monthly Demand | Commodity | Total Revenue
Spreadsheet: 707207d1607097085-how-to-return-results-of-a-top-5-lowest-price-top-5-highest-price-and-price-difference-clean-data
Sheet: FRANCE

Country | FRANCE
End user price in EUR after VAT | (Multiple Items)
Average of End user price in EUR after VAT | Column Labels
Row Labels | AB | MedEL | OM
Antenna cable | 65 |  | 80
Charger |  | 68.58
Drying kit |  | 45.37
Full swim kit |  | 45
Country | FRANCE
End user price in EUR after VAT | (Multiple Items)
Average of End user price in EUR after VAT | Column Labels
Row Labels | AB | Cochlear | MedEL | OM
[NAME] |  |  | 379.8
Charger |  |  |  | 310
Full swim kit | 490
Recheargable battery | 310
Streamer (outside sound processor) |  |  | 395
Wireless Mic |  | 332.3
Country | FRANCE
End user price in EUR after VAT | (Multiple Items)
Average of End user price in EUR after VAT | Column Labels
Row Labels | AB | Cochlear | MedEL | OM
[NAME] | -13.59999999999999 |  | 197.2 | -62.59999999999999
Charger | 83 |  | -37.42 | 204
Drying kit | -8.599999999999994 |  | -62.23 | -7.599999999999994
Full swim kit | 298.2 |  | -146.8 | 108.2
Recheargable battery | 51.5 |  | -45.85000000000001 | 78.1
Spreadsheet: 693753d1599133593-lookup-multiple-solutions-values-and-list-them-excel-help
Sheet: Prüfprotokoll

 |  |  |  | Prüfprotokoll
Kunde: | AB: |  |  |  |  |  | Lieferort:
Prüf-Nr. | Länge | Länge | Breite | Breite | Diagonal | Diagonal | [NAME] | Kanten | gepr. durch | Datum
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Spreadsheet: 136187d1326465042-how-to-merge-multiple-lines-on-a-time-sheet-sched-time-sheet-integration
Sheet: Schedule

Site 1 |  | 2012-01-01 00:00:00 |  | 2012-01-02 00:00:00 |  | 2012-01-03 00:00:00 |  | 2012-01-04 00:00:00 |  | 2012-01-05 00:00:00 |  | 2012-01-06 00:00:00 |  | 2012-01-07 00:00:00
Random Location, Anytown |  | Sun |  | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Sat |  |  | S | M | T | W | T | F | S | Totals
14327 | Doe, [NAME] | 19:00:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00
14327 | Doe, [NAME] |  |  | 21:30:00 | 23:59:00 | 00:01:00 | 07:00:00
13940 | Smith, [NAME] | 13:00:00 | 19:00:00 |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00 | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00
13940 | Smith, [NAME] |  |  |  |  |  |  |  |  |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 00:30:00
15434 | Jones, [NAME] | 00:01:00 | 13:00:00
15427 | Random, Name |  |  | 17:30:00 | 21:30:00 |  |  |  |  |  |  |  |  | 16:30:00 | 23:59:00
14327 | Doe, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 00:30:00 | 09:00:00
Spreadsheet: 620101d1555330064-rota-in-excel-formula-for-creating-daily-overview-based-on-shifts-times-rota-example-aligw
Sheet: CC rota

 |  | Holidays |  | Advisor 1 | Advisor 2 | Advisor 3 | Advisor 4 | Advisor 5 | Advisor 6 | Advisor 7 | Advisor 8 | Advisor 9 | Advisor 10 | Advisor 11 | Advisor 12 | Advisor 13 | Advisor 14 | Advisor 15 | Advisor 16 | Advisor 17 | Advisor 18 | Advisor 19 | Advisor 20 |  |  |  |  | 6-2 | 7-3 | 8-4 | 9-5 | 10-6 | 12-8 | 1-9 | 2-10 | 3-11 | 4-12 | 5-11 | 6-11
2019-05-06 00:00:00 | Monday |  |  | 12-8 | 10-6 | R6 | 8-4 | 6-2 | 10-6 | H | 9-5 | R7 | 2-10 | H | 9-5 | 10-6 | 12-8 | OFF | 4-12 | 10-6 | 7-3 | 1-9 | H
2019-05-07 00:00:00 | Tuesday |  |  | OFF | OFF | R6 | 8-4 | 6-2 | 10-6 | H | OFF | R7 | 2-10 | 8-4 | 9-5 | 12-8 | 12-8 | R8 | 4-12 | 4-12 | 7-3 | 1-9 | OFF
2019-05-08 00:00:00 | Wednesday |  |  | 1-9 | 12-8 | R6 | 8-4 | 6-2 | 3-11 | OFF | OFF | R7 | 2-10 | 8-4 | 9-5 | OFF | OFF | R8 | 4-12 | 4-12 | 7-3 | OFF | OFF
2019-05-09 00:00:00 | Thursday |  |  | 1-9 | 12-8 | H | 8-4 | 6-2 | 3-11 | OFF | 10-6 | R7 | 2-10 | 8-4 | 9-5 | OFF | OFF | R8 | 4-12 | 10-6 | 7-3 | OFF | 10-6
2019-05-10 00:00:00 | Friday |  |  | OFF | OFF | H | 8-4 | 6-2 | H | 8-4 | 10-6 | R7 | 2-10 | 8-4 | 9-5 | 12-8 | 8-4 | OFF | 4-12 | 10-6 | 7-3 | 9-5 | 10-6
2019-05-11 00:00:00 | Saturday |  |  | 2-10 | 8-4 | R6 | OFF | OFF | OFF | 6-2 | 8-4 | R7 | OFF | OFF | OFF | 6-2 | 8-4 | R8 | OFF | OFF | OFF | 7-3 | 8-4
2019-05-12 00:00:00 | Sunday |  |  | 2-10 | 8-4 | R6 | OFF | OFF | OFF | 6-2 | 8-4 | R7 | OFF | OFF | OFF | H | OFF | R8 | OFF | OFF | OFF | 7-3 | 8-4
2019-05-13 00:00:00 | Monday |  |  | 10-6 | R6 | 8-4 | 6-2 | 3-11 | 12-8 | 9-5 | R7 | 2-10 | 8-4 | 9-5 | 10-6 | 4-12 | R8 | OFF | 10-6 | 7-3 | 1-9 | H | R9
2019-05-14 00:00:00 | Tuesday |  |  | OFF | R6 | 8-4 | 6-2 | 3-11 | 12-8 | OFF | R7 | 2-10 | 8-4 | 9-5 | OFF | 4-12 | R8 | 4-12 | 10-6 | 7-3 | 1-9 | OFF | R9
2019-05-15 00:00:00 | Wednesday |  |  | 12-8 | R6 | 8-4 | 6-2 | 3-11 | OFF | OFF | R7 | 2-10 | 8-4 | 9-5 | OFF | OFF | R8 | 4-12 | 10-6 | 7-3 | OFF | OFF | R9
2019-05-16 00:00:00 | Thursday |  |  | 12-8 | R6 | 8-4 | 6-2 | 3-11 | OFF | 10-6 | R7 | 2-10 | 8-4 | 9-5 | 12-8 | OFF | R8 | 4-12 | 10-6 | 7-3 | OFF | H | R9
2019-05-17 00:00:00 | Friday |  |  | OFF | R6 | 8-4 | 6-2 | 3-11 | 8-4 | 10-6 | R7 | 2-10 | 8-4 | 6-2 | 8-4 | 8-4 | R8 | OFF | 10-6 | 7-3 | 9-5 | H | R9
2019-05-18 00:00:00 | Saturday |  |  | 8-4 | R6 | OFF | OFF | OFF | 6-2 | 8-4 | R7 | OFF | OFF | OFF | 8-4 | 6-2 | R8 | 4-12 | OFF | OFF | 7-3 | H | R9
2019-05-19 00:00:00 | Sunday |  |  | 8-4 | R6 | OFF | OFF | OFF | 6-2 | 8-4 | R7 | OFF | OFF | OFF | 8-4 | 6-2 | R8 | 4-12 | OFF | OFF | 7-3 | H | R9
Spreadsheet: 80363d1280522426-summing-across-specific-rows-given-criteria-example
Sheet: Sheet1

First workbook. |  |  |  |  |  |  |  | "Data base" work book
 | P3 | P1-P3 | Total
[NAME] |  | 15
billy |  | 12
adam |  | 9 |  |  |  |  |  | B4 | B5 | P1 | P2 | P3 | P4 | P5 | Total
so on |  |  |  |  |  |  | [NAME] | 5 | 5 | 5 | 5 | 5 | 5 | 5
 |  |  |  |  |  |  | Billy | 4 | 4 | 4 | 4 | 4 | 4 | 4
 | How do I get this year-to-date data (in yellow)?  I can get P3 and Total columns with a vlookup. I'm a little stumped on how to get this sum.  Also, I need it to update, so if I put P4 in column B, I get the sum for P1-P4.  Any ideas? |  |  |  |  |  | adam | 3 | 3 | 3 | 3 | 3 | 3 | 3
 |  |  |  |  |  |  | [NAME] | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  |  |  |  |  | so on | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 785769d1656680687-i-want-to-return-multiple-values-against-a-series-of-values-sample-for-forum-transpose-aligw
Sheet: Returned Values

Identification Digit | Lender | Lender | Lender | Lender
 |  | ABC | CBC
2
3 |  | CBC | DBC | ABC
4 |  | ABC
5 |  | JKL | GHI
6
7
Spreadsheet: 546269d1509975236-cascading-drop-down-data-validation-lists-with-only-unique-items-dependant-lists3
Sheet: Sheet1

Citrix | BR
DBMW | CA
DBMW Control-M | DE
DBMW DSM | MY
FS AS400 | NL
FS OS390 | SK
FS-DC | UK
FS-LAN | US
FS-LB
GADM misc.
GCDM misc.
GPD Projects
HS-Hosting-Classic
HS-Hosting-Dynamic
HS-Storage-Classic
HS-Storage-Dynamic
LCM
MS Azure
NOCOA Projects
OG-Butagaz
OG-Dansk Shell
OG-DCC [NAME]
OG-HANA test
OG-NCOC
OG-SRC
OG-Statoil
Other
Sales
SAP
Security
SGA [NAME].
shell.com
SP-CoE
SP-K2
SP-Mig
SP-Ops
SP-UDR
TAM
Tools & Automation
(blank)
Spreadsheet: 097d9474-9856-4419-9307-f6a9c83076bf
Sheet: PPI 002

Permit No.: |  | WQ0034162 |  | Facility Name: |  | Wanchese Seafood Industrial Park |  |  |  |  | County: | Dare |  | Month: |  |  | Year:
PPI: |  | 002 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 31616 | 00610 | 00625 | 00620 | 00400 | 00530 | 00076
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Recorder
Monthly Limit: |  |  | 13500 | 10 | 14 | 4 |  |  |  | 5
Daily Limit: |  |  |  | 15 | 25 | 6 |  |  | 6-9 | 10 | 10
Sample Frequency: |  |  | [NAME] | Monthly | Monthly | Monthly | Monthly | Monthly | 5 x Week | Monthly | [NAME]
Spreadsheet: 649029d1573410264-data-from-one-range-to-another-return-an-error-if-more-than-1-entry-per-column-book100
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 |  | 1 | 0 | 3 | 2 | 4 | 1 | 5 | 2 | 2
 | 1 |  |  |  |  |  |  |  |  |  |  |  | A1 |  |  | A2
 | 2 |  |  |  |  |  |  | K7 |  | F3
 | 3 |  |  |  |  |  |  |  |  |  | D4 |  |  |  | [NAME]
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
Spreadsheet: phillip_m_love__30150__9907_OA
Sheet: WE-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  WEST
 |  |  | Total |  | Reclasses |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8614 | 41005
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2476 | -28399
7 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -6138 | -12810
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 8060 |  |  |  |  |  | -216225
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 793559d1661535237-percentage-profit-where-no-cost-involved-sadie-excel-forum-q
Sheet: Sheet1

 |  |  |  |  | Platform | Selling price | Cost price | Profit |  | Vinted | LAL | E Bay | Facebook | Web Site
 |  |  |  |  | Facebook | 5 | 2.6
 |  |  |  |  | Facebook | 8 | 0
 |  |  |  |  | Facebook | 7 | 0
 |  |  |  |  | Facebook | 30 | 6.36
 |  |  |  |  | Facebook | 25 | 12
 |  |  |  |  | Facebook | 20 | 11.06
 |  |  |  |  | Facebook | 5 | 1.41
 |  |  |  |  | Facebook | 8 | 4
Spreadsheet: 729745d1619301165-help-with-countif-formula-for-calendar-countif-any-date-in-table-present-schedule-workbook-stat-holiday-help
Sheet: STATS

Schedule
STATS
Employee | Shifts | Car 1 | Car 2 | Weekends | Stats