tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 115828d1311323959-editing-condtional-formating-rules-to-change-if-xxx-apears-roneltest
Sheet: Studio Measures

TRACC | Languages | Suite | Product | Title | Component |  | Languages | Angelique | Chantel | [NAME] | [NAME] | [NAME] | Toni | Vicky
**Manuf.** | English US | Manuf. | Manual | **Manual** | FG |  | Chinese | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25
LMC | English UK | SC | Training | [NAME] | WB |  | Dutch | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75
EHS | Chinese | Enabling |  | [NAME]. | Slides |  | English UK | 1 | 1 | 1 | 1 | 1 | 1 | 1
TW | Dutch |  |  | Glossary | Support Docs |  | English US | 1 | 1 | 1 | 1 | 1 | 1 | 1
5S | French |  |  | **Training** |  |  | French | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25
VM | German |  |  | Multisite Inter. |  |  | German | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
FI | Hungarian |  |  | Specialist WS |  |  | Hungarian | 1 | 1 | 1 | 1 | 1 | 1 | 1
AM | Itlian |  |  | TL WS |  |  | Indonesian | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25
AC | Indonesian |  |  | TT WS |  |  | Itlian | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
STR | Korean |  |  | BP |  |  | Korean | 1 | 1 | 1 | 1 | 1 | 1 | 1
QU | Polish |  |  | Awareness |  |  | Polish | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25
**SC** | Portuguese |  |  | IS |  |  | Portuguese | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
SCA | Russina |  |  | ITF |  |  | Russina | 1 | 1 | 1 | 1 | 1 | 1 | 1
DP | Spanish |  |  |  |  |  | Spanish | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75
S&OP
SP |  |  |  |  |  |  | Measure | Pages pd
PROC |  |  |  |  |  |  | 0.25 | 15
TM |  |  |  |  |  |  | 0.5 | 30
WM |  |  |  |  |  |  | 0.75 | 45
OF |  |  |  |  |  |  | 1 | 60
IBP
**Enabling**
ES
H&S
TE
HC
AE
LIA1
Spreadsheet: ryan_slinger__33685__8_8act
Sheet: Proj

2001-08-07 00:00:00 | Tuesday
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | Total
768 | 744 | 723 | 726 | 754 | 798 | 888 | 974 | 1054 | 1096 | 1133 | 1164 | 1184 | 1190 | 1196 | 1192 | 1156 | 1117 | 1089 | 1113 | 1105 | 1010 | 906 | 830 | 23908
Spreadsheet: 861538d1709410750-populate-an-amount-into-the-correct-column-based-on-a-weekly-paycheck-test-budget-formulas
Sheet: Sheet1

 |  |  | PayDay >>>> | 2024-03-08 00:00:00 | 2024-03-15 00:00:00 | 2024-03-22 00:00:00 | 2024-03-29 00:00:00 | 2024-04-05 00:00:00
 | expense | amount | due date
 | donation | 256.54 | weekly | 256.54 | 256.54 | 256.54 | 256.54 | 256.54
 | Best Egg | 428.11 | 8th | 428.11 |  |  |  | 428.11
 | IRS | 400 | 12th | 400
 | Mortgage | 4000 | 1st |  |  |  | 4000
 | gas budget | 150 | weekly | 150 | 150 | 150 | 150 | 150
 | [NAME] | 60 | 1st |  |  |  | 49
 | Synchrony | 375 | 18th |  | 375
 | Kia lease | 311.9 | 5th |  |  |  |  | 311.9
 | Progressive | 437.77 | 5th |  |  |  |  | 570
 | Groceries | 350 | Weekly | 350 | 350 | 350 | 350 | 350
 |  |  | Total | 1584.65 | 1131.54 | 756.54 | 4805.54 | 2066.55
Spreadsheet: 681997d1591869927-conditional-sum-with-multiple-criteria-sample_1
Sheet: Sheet1

Buyer | Department | Season | Date | Qty | Total Qty |  | Buyer | Department | Season | Qty | Total Qty | Live qty | Hold Qty | [NAME]
George | OL Girls | AW20 PH-05 | 2020-05-30 00:00:00 | 100 | 100 |  | George | OL Girls | AW20 PH-05 | 2800 | 1800 | 1400 | 400 | 1000
George | OL Girls | AW20 PH-05 | 2020-05-21 00:00:00 | 500 | 500
George | OL Girls | SS20 PH-03 & 04 | 2020-06-30 00:00:00 | 300 | 300
George | OL Girls | SS20 PH-05 |  | 200
George | OL Girls | AW20 PH-05 |  | 400 | 400
George | OL Girls | AW20 PH-05
George | Ladies | SS20 PH-04 |  | 150 | 150
George | BT Boys | AW20 PH-07 |  | 200
George | Men's | SS20 PH-04 | 2020-05-30 00:00:00
George | OL Girls | AW20 PH-05 | 2020-05-21 00:00:00 | 500 | 500
George | OL Girls | AW20 PH-05 | 2020-05-20 00:00:00 | 500
George | OL Girls | AW20 PH-05
George | OL Girls | AW20 PH-05 | 2020-06-15 00:00:00 | 500
George | OL Girls | AW20 PH-05 | 2020-06-20 00:00:00 | 300 | 300
Spreadsheet: 465866d1465920719-aligning-half-rowws-of-data-with-common-cell-bank-statement-vrs-cashbook1
Sheet: Sheet2

 |  | BEFORE
1 | 2016-03-02 00:00:00 | PARTIAL SF REDISCOUNT [NAME] | 4000 | 1 | 2016-03-29 00:00:00 | Evans  Agyenim Boateng | 4000
2 | 2016-03-15 00:00:00 | SF REDEMPTION IFO AUGUSTINE KINGSFORD AIDOO | 4000 | 2 | 2016-03-01 00:00:00 | [NAME] | 4000
3 | 2016-03-31 00:00:00 | PAYMENT FOR SF Agyenim Boateng | 4000 | 3 | 2016-03-14 00:00:00 | [NAME] | 4000
4 | 2016-02-03 00:00:00 | DEAFT ISSUED TO GLOBAL EVANGELICAL CO-OP CRED | 4178.49 | 4 | 2016-03-30 00:00:00 | [NAME] | 4000
5 | 2016-03-24 00:00:00 | CASH DEPOSIT BY SUSSANA ADUMATIA | 4192.38 | 5 | 2015-11-30 00:00:00 | [NAME] Dwaah [NAME]  Beatrice Boakye | 4015.72
6 | 2016-03-01 00:00:00 | DRAFT ISSUED TO YAA KONADU ADU GYAMFI | 4348.78 | 6 | 2016-02-23 00:00:00 | UPPER AMENFI RURAL BANK LTD	JOHN [NAME] KUBI | 4019.4
7 | 2016-02-26 00:00:00 | s.f protocol by valentine bruku [PHONE] | 4365.27 | 7 | 2016-02-22 00:00:00 | [NAME] | 4029.18
 |  |  |  | 8 | 2016-02-26 00:00:00 | [NAME] | 4065.39
 |  |  |  | 9 | 2016-03-11 00:00:00 | [NAME] | 4167.83
 |  |  |  | 10 | 2016-02-02 00:00:00 | Global Evangelical Coop Credit Union-Amakom | 4178.49
 |  |  |  | 11 | 2015-12-02 00:00:00 | Osei  Anane Adutwum | 4183.4
 |  |  |  | 12 | 2016-03-24 00:00:00 | Sussana  Adumatta | 4192.39
 |  | AFTER
3 | 2016-03-31 00:00:00 | PAYMENT FOR SF Agyenim Boateng | 4000 | 1 | 2016-03-29 00:00:00 | Evans  Agyenim Boateng | 4000
 |  |  |  | 2 | 2016-03-01 00:00:00 | [NAME] | 4000
1 | 2016-03-02 00:00:00 | PARTIAL SF REDISCOUNT [NAME] | 4000
2 | 2016-03-15 00:00:00 | SF REDEMPTION IFO AUGUSTINE KINGSFORD AIDOO | 4000 | 3 | 2016-03-14 00:00:00 | [NAME] | 4000
 |  |  |  | 4 | 2016-03-30 00:00:00 | [NAME] | 4000
 |  |  |  | 5 | 2015-11-30 00:00:00 | [NAME] Dwaah [NAME]  Beatrice Boakye | 4015.72
 |  |  |  | 6 | 2016-02-23 00:00:00 | UPPER AMENFI RURAL BANK LTD	JOHN [NAME] KUBI | 4019.4
 |  |  |  | 7 | 2016-02-22 00:00:00 | [NAME] | 4029.18
 |  |  |  | 8 | 2016-02-26 00:00:00 | [NAME] | 4065.39
 |  |  |  | 9 | 2016-03-11 00:00:00 | [NAME] | 4167.83
4 | 2016-02-03 00:00:00 | DEAFT ISSUED TO GLOBAL EVANGELICAL CO-OP CRED | 4178.49 | 10 | 2016-02-02 00:00:00 | Global Evangelical Coop Credit Union-Amakom | 4178.49
 |  |  |  | 11 | 2015-12-02 00:00:00 | Osei  Anane Adutwum | 4183.4
5 | 2016-03-24 00:00:00 | CASH DEPOSIT BY SUSSANA ADUMATIA | 4192.38 | 12 | 2016-03-24 00:00:00 | Sussana  Adumatta | 4192.39
6 | 2016-03-01 00:00:00 | DRAFT ISSUED TO YAA KONADU ADU GYAMFI | 4348.78
7 | 2016-02-26 00:00:00 | s.f protocol by valentine bruku [PHONE] | 4365.27
Spreadsheet: benjamin_rogers__1256__Turbine Availability sheet
Sheet: 2000 Turbines

2000 Turbine Availability Sheet
 |  |  |  |  |  |  |  |  |  |  | Potential Deals -
Turbine Type | Quantity | MW/unit SC | Total MW | Hz | HR (Btu/kWh) HHV | Emissions PPM | New/Used | Schedule | Cost/unit (000) | Total Cost (000) | # of Turbines
GE LM6000 | 24 | 48.58 | 1166 | 60 | 9805 | 25 | N | 1-3 July 2000,           4-6 Aug 2000,         7-8 Sept 2000,       9-11 Oct 2000,    12-13 Nov 2000,    14-15 Dec 2000,    16-18 Jan 2001,    19-20 Feb 2001,       21-22 March 2001,     23-24 April 2001 | $13,9500 avg   1-8 $13,800        9-16 $13,500   17-24 $13,200        Sprint option @ $450 per | 333500 | Peoples - 6,          Rochester - 1,          Santee Cooper - 5-6,          Austin - 4,               TECO - 2,        Madison - 2,          Michigan - 2,          Springfield - 1-3,          Lakeland - 2,          JEA - 3-5,          SMUD - 1,              UAE - 4,             Calpine - 4,               EES Shorts - 4
GE 6B | 2 | 38.34 |  | 50 | 12050 | 25 | U | On Hand | 12400
GE 7FA | 1 | 156.5 |  | 60 | 10610 | 9 | N | 1 - 8/31/2000, 2 - 9/30/00 | 32429
S/W 501 D5A | 1 | 119.845 |  | 60 | 11656 | 25 | N
F/W 501C-GT50 | 5 | 85.3 |  | 50 | 12761 | 25 | U |  | 10600
ABB 11N1 | 2 |  | 157.8 | 60 |  | < 25 | U
GE 7 EA | 1 |  |  |  |  | < 25 | N | On Hand
Spreadsheet: phillip_m_love__30151__9906_OA
Sheet: EAST-LRC-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  LRC
REGION:  SOUTHEAST
 |  |  | 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 | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -5387 |  | 0 |  | 0 |  | 0 |  | 0
 | 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:
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
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  |  |  | 0
 |  | TOTAL
Spreadsheet: 192450d1352409326-using-index-to-reference-sheets-am-i-doing-it-wrong-working
Sheet: Sheet2

Description | A | Spec Section
Vendor Part # | A1 | Facility #
Manufacturer | A2
MFG Part # | A3 | QTY Required |  |  | QTY Received
QTY Provided | A4
Unit Value | A5
Total Value | A6
Associated Asset | A7
Description | B | Spec Section
Vendor Part # | B1 | Facility #
Manufacturer | B2
MFG Part # | B3 | QTY Required |  |  | QTY Received
QTY Provided | B4
Unit Value | B5
Total Value | B6
Associated Asset | B7
Description | C | Spec Section
Vendor Part # | C1 | Facility #
Manufacturer | C2
MFG Part # | [NAME] | QTY Required |  |  | QTY Received
QTY Provided | C4
Unit Value | C5
Total Value | C6
Associated Asset | C7
Spreadsheet: 022e72a2-3423-42ad-b5b7-b257377a2ed8
Sheet: Sheet1

[NAME]
[NAME]:
Camp/ Program Name:
Dates of CPM:
Primary Contact Name:
[NAME] [NAME]:
Primary Contact Phone #:
Day | Date | Time In | Time Out | Total Hours | [NAME] | Supervisor Initial
Monday | 2013-08-03 00:00:00 | [NAME] | 5:00PM | 9
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
 |  |  | Grant Total:
Spreadsheet: 488997d1478974206-extract-data-from-the-worksheet-and-display-copy-of-quotation-files
Sheet: Sheet1

S/N | QTN DATE | MONTH | QTN REF | AMOUNT (AED) | INVOICE NO. | INV. DT | JOB  STATUS | REMARKS |  | Start | 2016-06-27 00:00:00
 |  |  |  |  |  |  |  |  |  | End | 2016-07-29 00:00:00
Spreadsheet: 163693d1340397841-identify-records-where-sales-order-contains-multiple-items-1
Sheet: Sheet1

[NAME] | Item ID | Accessory | Multiple?
ABC100 | 302 | 1A | Yes | ABC100-302
ABC100 | 443 | 2A | Yes | ABC100-443
EFG200 | 105 | 1A | Yes | EFG200-105
EFG200 | 105 | 1B | Yes | EFG200-105
HIJ300 | 790 | 3A | Yes | HIJ300-790
EFG200 | 523 | 1B | Yes | EFG200-523
ABC100 | 302 | 2C | Yes | ABC100-302
HIJ300 | 523 | 3A | Yes | HIJ300-523
XYZ100 | 302 | 2C | No | XYZ100-302
Spreadsheet: 757396d1638232145-stabilisation-in-values-adding-start-point-time-to-stabilisation-functions
Sheet: Sheet2

 | Average (first 10) |  | Value | 7
 | 97.5% average (lower)
 | 102.5% average (upper)
 | Time (s) | Value | 97.5% average (lower) | 102.5% average (upper) | Both
 | 0 | 2 |  |  |  |  | Time to Stabilisation
 |  | 3 |  |  |  |  |  |  |  |  |  |  |  | <------------ 2nd question
 |  | 2
 |  | 2
 |  | 2.38
 |  | 2.38
 |  | 2.38 |  |  |  |  | I would like C29 to represent the point in which the forumla in K7 recognises as the starting point
 |  | 2.38
 |  | 2.38
 |  | 3
 |  | 3
 |  | 2
 |  | 2
 |  | 1
 |  | 0.5
 |  | 0.2
 |  | 0.4
 |  | 0.5
 |  | 0.8
 |  | 1
 |  | 2
 |  | 3
 |  | 7
 |  | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 2.38
 |  | 2.38
 |  | 2.38
 |  | 2.38
 |  | 2.38
 |  | 3
 |  | 2
 |  | 4
 |  | 3
 |  | 2.38
 |  | 2.37
 |  | 2.38
 |  | 2.38
 |  | 2.37
 |  | 2.38
 |  | 2.38
 |  | 2.38
 |  | 2.39
 |  | 2.39
 |  | 2.38
Spreadsheet: eric_saibi__9724__010902R
Sheet: Arthur Kill 02

Owner Name |  | [NAME]
Station Name |  | [NAME]
Unit Name |  | Unit 02
NERC Region |  | NPCC
State |  | NY
Fuel Type |  | Natural Gas
Capacity |  | 376 MW
Start Date |  | 2002-01-09 00:00:00
End Date |  | 2002-03-26 00:00:00
Prv. Start Date |  | 2002-01-26 00:00:00
Prv. End Date |  | 2002-04-26 00:00:00
Comments |  | Having problems with the unit and had to start planned maintenance early.
SIC |  | 4931
Plant ID |  | 1016006
Unit ID |  | 1004416
Outage ID |  | 1717
Spreadsheet: 106594d1303836600-unique-phone-numbers-yp-incoming-calls
Sheet: Volume of Calls

 | Is the number of unique Descriptions in column E on the All Calls Sheet
Spreadsheet: 0ae707b8-065a-43fb-8bdb-00955e6fc8ae
Sheet: Page1_1

 |  |  | Colorado Department of Education |  |  | Page: 1
 |  |  | Business Rules
School Year: | 2012-13 | Dataset: | 11th Grade Alt Assessment | File Type: | Demographics
Data Element Name | Error/Warning Code | Error Type | Message | Status | Tier | Last Updated User | Last Updated Date
TEST_SCORE_STATUS | E10 | Error | Invalid Test score status | Active | 1 | System | 2012-12-14 12:48:44.999000
Spreadsheet: 869384d1715952359-count-unique-using-2-criteria-unique-number-per-sport
Sheet: Sheet1

[NAME] | Football
[NAME] | Golf
[NAME] | Rugby
[NAME] | Golf |  |  |  | Sport | Unique of Players
[NAME] | Cricket |  |  |  | Football
[NAME] | Football |  |  |  | Rugby
[NAME] | Golf |  |  |  | Golf
[NAME] | Rugby |  |  |  | Cricket
[NAME] | Football |  |  |  | Bowls
[NAME] | Rugby |  |  |  | [NAME]
[NAME] | Rugby |  |  |  | Tennis
Ringo | Football
Ringo | Bowls
Ringo | Golf
Ringo | Cricket
Ringo | Bowls
George | Rugby
George | [NAME]
George | Rugby
George | Tennis
Spreadsheet: 127068d1320154466-conditional-sum-example-16-
Sheet: Pivot

Sum of Amount | Period
Paid | 1 | 2 | 3 | 4 | Grand Total
X | 602.29 | 758 | 512.96 |  | 1873.25
(blank) |  |  | 150 | 768 | 918
Grand Total | 602.29 | 758 | 662.96 | 768 | 2791.25
Spreadsheet: 268384d1380613300-dsum-add-up
Sheet: Sheet1

UNIT 2 - SCRAP DETAILS |  |  |  |  |  |  | Poly | Paper | Foil Poly | Bare Foil |  | Machine | Scrap Type
 |  |  |  |  |  | Slitter 1 |  | 0 | 0 | 0 |  | Slitter 1 | Poly
Date | Machine | Scrap Type | Product Name | Quantity |  | [NAME] | 5 | 0 | 0 | 0
2013-09-26 00:00:00 | [NAME] | Poly | [NAME] | 5 |  | Slitter 3 | 0 | 0 | 0 | 34.6
2013-09-26 00:00:00 | Slitter 1 | Poly | [NAME] | 40.2 |  | [NAME] | 19 | 0 | 0 | 0
2013-09-26 00:00:00 | [NAME] 9 | Poly | [NAME] | 13.6 |  | Slitter 5 | 0 | 60 | 0 | 0
2013-09-26 00:00:00 | Slitter 5 | Paper | Boomer | 32.8 |  | [NAME] 6 | 26.4 | 0 | 0 | 0
2013-09-26 00:00:00 | EX 1 | Paper |  | 46.2 |  | Slitter 7 | 0 | 0 | 0 | 0
2013-09-26 00:00:00 | EX 1 | Paper |  | 21.8 |  | [NAME] 8 | 0 | 0 | 0 | 0
2013-09-26 00:00:00 | Doctor 5 | Paper | Boomer | 83 |  | Doctor 1 | 0 | 0 | 0 | 0
2013-09-26 00:00:00 | C5 | Foil Poly | BR Foil | 14.4 |  | Doctor 2 | 0 | 0 | 0 | 0
2013-09-26 00:00:00 | [NAME] | Poly | [NAME] | 19 |  | Doctor 3 | 0 | 0 | 0 | 0
2013-09-26 00:00:00 | [NAME] 6 | Poly | Zinetac | 26.4 |  | Doctor 4 | 0 | 0 | 0 | 0
2013-09-26 00:00:00 | Slitter 1 | Poly | [NAME] | 25.6 |  | Doctor 5 | 0 | 83 | 0 | 0
2013-09-26 00:00:00 | Slitter 5 | Paper | Boomer | 27.2 |  | EX 1 | 0 | 68 | 0 | 0
2013-09-26 00:00:00 | P1 | Paper | Boomer | 133.8 |  | P1 | 0 | 133.8 | 0 | 0
2013-09-26 00:00:00 | Slitter 3 | Bare Foil | Cadbury Silk | 34.6 |  | p2 | 0 | 0 | 0 | 0
Spreadsheet: 683835d1592976857-avergaes-over-multiple-cells-references-data-help
Sheet: Sheet1

Ref | quote |  | expected values
J22Y93 | 1 |  | J22Y93 | 1
J2G7Jf | 1 |  | J2G7Jf | 3
J2G7Jf | 1 |  | J2GPFR | 1
J2G7Jf | 1 |  | [NAME] | 2
J2GPFR | 1 |  | J4E6L0 | 4
[NAME] | 1
[NAME] | 1
J4E6L0 | 1
J4E6L0 | 1
J4E6L0 | 1
J4E6L0 | 1
Spreadsheet: f1991e90-409d-48e9-b9b2-0456b0aa399e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4146 | 24565 | Innokentiy | Yuzhakov | RUS | 0 | 00:18:08 | 00:07:02 | 00:46:06 | 00:04:15 | 00:28:35 | 1 | 01:44:09
4146 | 27997 | Klaus | Steckel | GER | 0 | 00:25:50 | 00:08:33 | 00:59:47 | 00:04:43 | 00:38:52 | 2 | 02:17:45
Spreadsheet: 4ca24ecb-0e03-4dfc-8e31-cdd07622bb7f
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Canaan | 811649001927 | The Hoppers | North America Live | 2009-01-27 | Compact Disc | Gospel | 13.99 | Y | Available
Canaan | 80688768126 | The [NAME] | Nothin' But Good | 2008-08-12 | Compact Disc | [NAME] | 13.99 | Y | Available
Canaan | 80688769123 | [NAME] | I Just Wanted You To Know | 2008-08-12 | Compact Disc | [NAME] | 13.99 | Y | Available
Canaan | 80688775223 | Mike & Kelly Bowling | Faith To Believe | 2008-08-12 | Compact Disc | [NAME] | 13.99 | Y | Available
Spreadsheet: 708997d1608124402-extract-and-convert-value-julian-date-to-calendar-date-date
Sheet: Sheet1

Serial Number | Step 1 | Step 2 | Step 3 - Convert | Column1
N119178025
N119178081
NL16362157
NL16082016
NL16015026
NL16089199
Spreadsheet: 112613d1308683327-need-help-to-consolidate-and-print-from-multiple-sheets-df-pullsheet
Sheet: TABLES & LINENS

TABLES AND CHAIRS | ✓ |  | (FISH WEIGHTS?)
chair, NATURAL wood chivari
30"
36"
48"
54"
60"
72"
60" square
72" square
18" x 6' skinny
8' x 30"
6' x 30" - work tables
6' x 30"
tabletops, 8' banquet x 36" wide
tabletops, 6' banquet x 36" wide
bar top, 6`
4' x 30"
bar top, 4`
serpentine - 8'
serpentine - 12'
[NAME], slight curve
[NAME], extreme curve
cocktail table, 42" tall - 30" rnd
top
base
pole
children's banquet
LINENS | ✓
cushion, white chivari
cushion, black chivari
table pad, 72" round
table pad, 10' long rectangle
table pad, 36" fitted
cocktail, hemstitched, white
cocktail, hemstitched, ecru (aka:  ivory)
tea, hemstitched, white
placemat, hemstitched, white
placemat, hemstitched, ecru
underliner, hemstitched white
underliner, hemstitched ecru
dinner, hemstitched, white
dinner, hemstitched, ecru (aka:  ivory)
dinner, hemstitched, black
dinner, ADMIRAL, white
dinner, ADMIRAL, ecru (aka ivory or champagne)
dinner, ADMIRAL, black
linen bags, ADMIRAL
linen bags, JCO
[NAME]
96" Claret
108" Claret
120" Claret
90x132" Claret
90x156" Claret
55" Green Bengaline Overlay
90x96" Green Bengaline
90x132" Green Bengaline
Spreadsheet: 736402d1623600208-conditional-formatting-only-working-with-1-formula-in-progress-formatting
Sheet: Sheet1

Training Frequency | 3 Y | 5 Y
Personal Information | Equipment
Full Name | Ride-On | Scissor
A N Other | 2017-05-26 00:00:00 | 2017-05-26 00:00:00
A N Other B | 2016-06-12 00:00:00 | 2016-06-12 00:00:00
A N Other C | 2019-06-12 00:00:00 | 2019-06-12 00:00:00
A N Other D | 2018-05-12 00:00:00 | 2015-05-12 00:00:00
A N Other E | 2018-04-12 00:00:00 | 2018-04-12 00:00:00
Spreadsheet: 676154d1588682060-inserting-or-criteria-along-with-countifs-function-dummy-data
Sheet: Data Sheet

Dummy Data
Control ID | Entity | Status | Family
1 | Entity1 | Active | BC
2 | Entity1 | Completed | CC
3 | Entity1 | Closed | BC
4 | Entity1 | Active | CC
5 | Entity1 | Active | DP
6 | Entity2 | Active | DP
7 | Entity2 | Active | DP
8 | Entity2 | Active | BC
9 | Entity2 | Active | CC
10 | Entity2 | Active | DP
11 | Entity3 | Active | BC
12 | Entity3 | Closed | BC
13 | Entity3 | Completed | CC
14 | Entity3 | Active | DP
15 | Entity3 | Active | DP |  |  |  | Requirement Table |  |  |  |  | Solved Table
 |  |  |  |  |  |  | Entity | Family |  |  |  | Entity | Family
 |  |  |  |  |  |  |  | BC | CC | DP |  |  | BC | CC | DP
 |  |  |  |  |  |  | Entity1 | Counts no of controls which belongs to "BC" family, belongs to Entity 1, and is in Completed or Closed status. [NAME] to be defined ?? | Counts no of controls which belongs to "CC" family, belongs to Entity 1, and is in Completed or Closed status.  [NAME] to be defined ?? | Counts no of controls which belongs to "DP" family, belongs to Entity 1, and is in Completed or Closed status.  [NAME] to be defined ?? |  | Entity1 | 1 | 1 | 0
 |  |  |  |  |  |  | Entity2 | Counts no of controls which belongs to "BC" family, belongs to Entity 2, and is in Completed or Closed status.  [NAME] to be defined ?? | Counts no of controls which belongs to "CC" family, belongs to Entity 2, and is in Completed or Closed status.  [NAME] to be defined ?? | Counts no of controls which belongs to "DP" family, belongs to Entity 2, and is in Completed or Closed status.  [NAME] to be defined ?? |  | Entity2 | 0 | 0 | 0
 |  |  |  |  |  |  | Entity3 | Counts no of controls which belongs to "BC" family, belongs to Entity 3, and is in Completed or Closed status.  [NAME] to be defined ?? | Counts no of controls which belongs to "CC" family, belongs to Entity 3, and is in Completed or Closed status.  [NAME] to be defined ?? | Counts no of controls which belongs to "DP" family, belongs to Entity 3, and is in Completed or Closed status.  [NAME] to be defined ?? |  | Entity3 | 1 | 1 | 0
Spreadsheet: 152666d1335465966-summing-a-range-of-grades-grade-calculation-sample
Sheet: tables

A+ | 13
A | 12
A- | 11
[NAME] | 10
B | 9
B- | 8
C+ | 7
C | 6
C- | 5
[NAME] | 4
D | 3
D- | 2
F | 1
Spreadsheet: 691576d1597763561-return-site-based-on-client-example1
Sheet: Mapping

Client | Site
Apple | AA |  | 1 | Apple
Apple | aaa |  | 2 | [NAME]
Apple | ab |  | 3 | [NAME]
Apple | sssss
Apple | aaaa
Apple | iiouoi
Apple | ddddd
Apple | eeee
Apple | ggggg
Apple | ggffg
[NAME] | bbbb
[NAME] | fggg
[NAME] | wwwww
[NAME] | wrrrrr
[NAME] | qqqqq
[NAME] | tttt
[NAME] | eeee
[NAME] | tttt
[NAME] | uuuu
[NAME] | mmmm
[NAME] | [NAME]
[NAME] | ttttttt
[NAME] | AA
[NAME] | aaa
[NAME] | ab
[NAME] | sssss
[NAME] | aaaa
[NAME] | iiouoi
[NAME] | ddddd
[NAME] | eeee
[NAME] | ggggg
Spreadsheet: 718090d1612979934-extract-from-tables-from-multiple-tabs-one-workbook-excel-help
Sheet: ABC I 2020

 |  |  |  |  |  |  |  | Title 2020
 | Date Range |  | 2020-01-01 00:00:00 | to | 2020-12-31 00:00:00
Account | Description |  | Period 1 - 2020 | Period 2 - 2020 | Period 3 - 2020 | Period 4 - 2020 | Period 5 - 2020 | Period 6 - 2020 | Period 7 - 2020 | Period 8 - 2020 | Period 9 - 2020 | Period 10 - 2020 | Period 11 - 2020 | Period 12 - 2020 | Total
01-999-12345 | First Row |  | 16597 | 66414 | 62090 | 9630 | 43440 | 39250 | 29980 | 7293 | 7556 | 35495 | 64818 | 10998 | 393561
01-999-11223 | Second Row |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
01-999-99883 | [NAME] |  | 673 | 574 | 934 | 809 | 1051 | 2815 | 3027 | 1511 | 1693 | 1686 | 1522 | 4848 | 21143
01-999-77443 | Middle Row |  | 3398 | 4668 | 1674 | 726 | 1832 | 567 | 4530 | 2884 | 2288 | 4283 | 862 | 3145 | 30857
01-888-12345 | First Row |  | 20480 | 5977 | 18946 | 62717 | 33958 | 28523 | 51190 | 8658 | 5549 | 23283 | 12831 | 9779 | 281891
01-888-11223 | Second Row |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
01-888-99883 | [NAME] |  | 4844 | 2850 | 102 | 4215 | 3978 | 1291 | 4288 | 2130 | 4367 | 3311 | 790 | 4706 | 36872
01-888-77443 | Middle Row |  | 2295 | 3711 | 4861 | 4077 | 1007 | 1717 | 1764 | 2411 | 2265 | 369 | 1377 | 2079 | 27933