tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 852913d1702903257-bring-uniq-names-from-multiple-rows-01-bolt-list_abc_drafting-aligw
Sheet: Sheet1

 |  | ABC Drafting |  |  |  |  |  |  |  |  |  | Description | Length | Retail Price
 |  | Client: |  |  |  | Job No: |  |  |  |  |  | AS 1252 24 | 85 | 3.7
 |  | Project: |  |  |  |  |  |  |  |  |  | AS 1252 20 | 70 | 4.4
 |  | Detailer: |  |  |  | Date: |  | 17-Nov-23 |  |  |  | [NAME] bolts 12 | 30 | 1.8
Quantity | Description |  |  | Length | Grade |  | Part weight |  | Total weight | Price per unit. AUD |  | [NAME] bolts 12 | 40 | 1.9
 |  |  |  | ([NAME]) |  |  | (kg) |  | (kg) |  |  | AS 1252 16 | 50 | 2.7
80 | AS 1252 24 |  |  | 85 | 8.8/TB |  |  | 0.7 | 52.6 |  |  | AS 1252 16 | 55 | 2.8
50 | AS 1252 20 |  |  | 75 | 8.8 |  |  | 0.4 | 18 |  |  | XOX 16 | 45 | 2.6
128 | XOX 20 |  |  | 55 | 8.8 |  |  | 0.3 | 34.3 |  |  | XOX 16 | 55 | 2.7
4 | AS 1252 16 |  |  | 70 | 8.8 |  |  | 0.2 | 0.9 |  |  | XOX 20 | 55 | 2.9
128 | XOX 16 |  |  | 55 | 8.8 |  |  | 0.2 | 21
8 | AS 1252 16 |  |  | 55 | 8.8 |  |  | 0.2 | 1.5
8 | AS 1252 16 |  |  | 50 | 8.8 |  |  | 0.2 | 1.6
256 | XOX 16 |  |  | 45 | 8.8 |  |  | 0.1 | 37.9
76 | [NAME] bolts 12 |  |  | 40 | 4.6 |  |  | 0 | 1.2
338 | [NAME] bolts 12 |  |  | 30 | 4.6 |  |  | 0.1 | 18.9
 | TOTAL QUANTITY |  |  | 1076
 | TOTAL WEIGHT |  |  | 188 | [NAME]
List produced by AUTODESK Advance Steel |  |  |  |  |  |  |  |  |  |  | Page | 1 | / | 1
Spreadsheet: 734577d1622242929-split-breakdown-time-between-shifts-split-time-between-shifts-over-multiple-days-krzysiekpirat-
Sheet: Sheet1

 |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C
Machine | Date | [NAME] | Time Broken Down | helper | A | B | C | A | B | C | A | B | C | A | B | C | A | B | C | A | B | C |  | 2021-05-20 00:00:00
machine 1 | 2021-05-20 00:00:00 | 75 | 11:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-21 00:00:00
 | 2021-05-20 00:00:00 | 7 | 17:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-22 00:00:00
 | 2021-05-21 00:00:00 | 2 | 03:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-23 00:00:00
 | 2021-05-22 00:00:00 | 17 | 15:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-25 00:00:00
Spreadsheet: 135518d1326108793-pivot-sorting-of-report-filter-pivot_arrange-in-ascending-order
Sheet: Pivot

Quarter | (All)
Month | (All)
Customer (All) | (All)
Count of Gross_Sales | Column Labels
Row Labels | 2009 | 2010 | 2011
Week 45 | 23 | 18 | 15
Week 46 | 27 | 17 | 15
Week 48 | 24 | 17 | 14
Week 51 | 25 | 16 | 19
Week 52 | 28 | 15 | 18
Week 53 |  |  | 6
Grand Total | 127 | 83 | 87
Spreadsheet: 781311d1653210760-help-with-determining-the-right-formula-to-use-sample-worksheet-bar-tab
Sheet: Bar Tab

Date | Product | Quantity | Happy Hour | Category | Price | Line Item Price | Method of Payment | Guest/Room |  |  |  | Method of Payment | [NAME]
2022-05-22 00:00:00 | Beer (can) | 1 | Yes |  |  |  | [NAME] | Room 2 |  |  |  | Guest/Room | Room 2
2022-05-22 00:00:00 | Long Island Ice tea | 2 | No |  |  |  | Cash
2022-05-22 00:00:00 | Beer (Can) | 2 | No |  |  |  | [NAME] | Room 2 |  |  |  | Date | Product | Happy Hour | Price | Som van Quantity | Som van Line Item Price
 |  |  |  |  |  |  |  |  |  |  |  | 2022-05-22 00:00:00 | Beer (can) | No | 1 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | 0.75 | 1 | 0.75
 |  |  |  |  |  |  |  |  |  |  |  | Eindtotaal |  |  |  | 3 | 2.75
Spreadsheet: 221572d1363614768-countif-formula-blank-names-and-sessions
Sheet: Sheet2

[NAME] | Bannister | 05/03/2008
[NAME] | Blake | 04/09/2007
Jan | Bukowski | 22/12/2007
[NAME] | Cann | 08/05/2008
Isabelle | [NAME] | 15/03/2008
Ebony 'Ava | Chedzoy | 06/12/2007
Lewis | Chilcott | 29/06/2008
[NAME] | Clarke | 28/03/2008
Tyler | Close
Kingston | Cocks | 18/11/2008
Sophie Ella | [NAME] | 18/11/2008
[NAME] | Difford
[NAME] | Drabble
Poppy | Doney | 16/12/2007
[NAME] John | Elsley | 21/12/2007
Finley | Frampton | 09/06/2008
Chloe | Galley | 02/05/2008
Leah | Garforth | 15/10/2008
[NAME] | Guard | 06/05/2008
[NAME] | Hall | 24/09/2007
[NAME] | [NAME] | 03/11/2008
[NAME] | Hardwidge | 24/09/2008
[NAME] | [NAME] | 20/06/2008
Hope | [NAME] | 01/10/2007
Lola | Hellings | 09/04/2008
[NAME] | Hill | 29/11/2007
[NAME] | Hill | 17/09/2008
Steven (Junior) | Hooper | 04/09/2007
Alfie | James-Stone | 15/11/2008
Ava | [NAME] | 31/08/2008
[NAME] | Jones | 21/01/2008
Castor | Kavanagh | 29/01/2008
[NAME] | Leonard | 27/10/2008
Nikola | Lupiezowiec | 20/08/2008
[NAME] | [NAME] | 20/07/2008
Imogen | McCready-Burnell | 18/12/2008
[NAME] | McKay | 06/03/2008
[NAME] | [NAME]
Keisha | Mills | 19/09/2008
Archie | Mitchell | 27/10/2008
[NAME] | [NAME] | 21/04/2008
Cyrus | Nicholls | 27/03/2008
Tyra | O'Neill
Lyla | Patten | 12/05/2008
[NAME] | Petteford | 01/06/2008
Lloyd | Poole | 09/07/2008
[NAME] | Prowse | 23/02/2008
Olivia | Prowse | 25/08/2008
[NAME] | [NAME] | 31/03/2008
Georgia | Riddle | 01/01/2009
Erin | [NAME] | 11/02/2008
[NAME] | Rodd | 24/10/2007
Marius | Savage | 05/03/2008
[NAME] | Savage | 05/03/2008
Ellie | Scollan | 02/05/2008
Leah | Sherriff | 05/02/2008
Brooke | Smith | 21/12/2007
Amelia | Speed | 22/11/2008
[NAME] | [NAME] | 22/10/2007
Saskia | Tennent | 25/08/2008
[NAME] | [NAME] | 09/11/2007
Ellie | [NAME] (Ward) | 30/09/2008
Grace | Thorne | 11/05/2008
[NAME] | White | 19/09/2008
[NAME] | Wood | 02/02/2008
Keisha | Woodrow | 27/05/2008
Spreadsheet: 2635ae9a-2b55-4077-95f7-c6fdf476cd8f
Sheet: Sheet1

1089 Battonya–Szarvas–Kecskemét–Budapest | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
(Érvényes: 2011. december 11-től)
Km | Km | Km | Km | VOLÁNBUSZ Zrt. | 2 | 4
 |  |  |  |  |  | 82
 |  |  |  |  | N | E
0 | .. | .. | .. | Battonya, aut. vt. | 03:50:00 | [NAME]
1.2 | .. | .. | .. | Battonya, alsó | 03:52:00 | 13:12:00
17.2 | .. | .. | .. | Mezőkovácsháza, aut. vt. | 04:10:00 | 13:30:00
27.8 | .. | .. | .. | Kaszaper, kh. | 04:20:00 | 13:40:00
46.6 | .. | .. | .. | Orosháza, aut. áll. | [NAME] | 14:00:00
46.6 | .. | .. | .. | Orosháza, aut. áll. | 04:41:00 | 14:00:00
50.3 | .. | .. | .. | Orosháza, üveggyár ltp. | 04:45:00 | 14:04:00
60.6 | .. | .. | .. | Nagyszénás, aut. vt. | 05:00:00 | 14:19:00
86.6 | .. | .. | .. | Szarvas, aut. áll. | 05:25:00 | 14:45:00
86.6 | .. | .. | .. | Szarvas, aut. áll. | 05:30:00 | 14:55:00
87.7 | .. | .. | .. | Szarvas, főiskola | 05:31:00
92.7 | .. | .. | .. | Békésszentandrás, aut. vt. | 05:38:00 | 15:03:00
101.4 | .. | .. | .. | Öcsöd, aut. vt. | 05:47:00 | 15:12:00
112.2 | .. | .. | .. | Kunszentmárton, aut. áll. | 05:59:00
121.5 | .. | .. | .. | Cserkeszőlő, posta | 06:12:00 | 15:32:00
160.2 | .. | .. | .. | Kecskemét, Repülőtér | 06:49:00
165.3 | .. | .. | .. | Kecskemét, aut. áll. | 06:54:00 | 16:15:00
165.3 | .. | .. | .. | Kecskemét, aut. áll. | 07:10:00 | 16:25:00
167.2 | .. | .. | .. | Kecskemét, Széchenyiváros | 07:13:00 | 16:28:00
245.4 | .. | .. | .. | Budapest, Népliget aut. pu. | 08:30:00 | 17:35:00
[NAME]:
A járatok az [NAME], de a mezőben fel [NAME]
[NAME] megállóhelyeknél [NAME] állnak meg.
[NAME]: 82 XII. 26.
N | munkaszüneti nap kivételével naponta
E | a hetek első munkanapját megelőző [NAME]
 | a járat érinti a megállóhelyet, de nem áll meg
Spreadsheet: 124233d1318262604-conditional-formatting-based-upon-absolute-values-cf-close-to-zero
Sheet: Sheet1

Number
Spreadsheet: 54291d1254310053-min-and-max-values-w-in-specific-date-range-book3
Sheet: Sheet2

 |  | Min |  |  |  |  |  | [NAME]
 |  |  | A | B | C | D | E |  | A | B | C | D | E
2006-02-09 00:00:00 | 2006-02-28 00:00:00 |  | 1.473 | 1.627604166666667 | 12.97 | 5.62 | 22.64 |  | 11.19 | 20.5371875 | 54.08 | 67.52 | 132.7
Spreadsheet: 829245d1684066037-concat-formula-returns-serial-date-quickbooks-payroll-journal-entries-import-template
Sheet: Payroll JE

SAMPLE COMPANY
Semi-monthly Payroll Journal Entry
Tax Period: | 6/01-6/15/2023
[NAME] |  | DEBIT | CREDIT | REFERENCE
Salaries |  | 9375
Empr Social Security Expense
[NAME] Expense
SUTA Expense |  | 432
FUTA Expense |  | 63
FWH Payable |  |  | -1357.55
Emp Social Security Payable
Emp Medicare Payable
Empr Social Security Payable
[NAME]
State WH Payable |  |  | -535.3
Local WH Payable |  |  | -200
SUI Payable
FUI Payable
Disability Insurance |  |  | -2.33
Checking
Spreadsheet: 538996d1505919096-sort-by-month-into-two-separate-columns-sample-workbook
Sheet: Sheet1

Item Code | PO Date |  | Unit Cost | Qty Received
APT171750 | 2017-08-02 00:00:00 |  | 93.5 | 20
APT84 | 2017-08-10 00:00:00 |  | 100.03 | 2
APT84BD | 2017-07-18 00:00:00 |  | 112.53 | 20
APT84BD | 2017-08-02 00:00:00 |  | 112.53 | 20
APT84BD | 2017-08-23 00:00:00 |  | 112.53 | 10
APT8626S | 2017-07-18 00:00:00 |  | 100.02 | 20
APT8626S | 2017-08-02 00:00:00 |  | 100.02 | 20
APT8626S | 2017-08-23 00:00:00 |  | 100.02 | 20
APT88RENEW | 2017-08-23 00:00:00 |  | 126.19 | 10
APTBIONOVUSE | 2017-07-13 00:00:00 |  | 85 | 48
APTEZBIO14 | 2017-07-13 00:00:00 |  | 110 | 36
APTEZBIO14 | 2017-07-18 00:00:00 |  | 110 | 144
APTEZBIO14 | 2017-08-09 00:00:00 |  | 110 | 72
APTEZBIO14 | 2017-08-24 00:00:00 |  | 110 | 72
APTFP17A | 2017-07-13 00:00:00 |  | 83 | 80
APTFP17A | 2017-08-15 00:00:00 |  | 83 | 10
APTFP17A | 2017-08-15 00:00:00 |  | 83 | 80
APTMPDCB | 2017-08-08 00:00:00 |  | 90 | 60
APTMPDCB | 2017-08-15 00:00:00 |  | 90 | 10
APTMPDCB | 2017-08-29 00:00:00 |  | 90 | 60
B1150CT-A | 2017-07-14 00:00:00 |  | 38 | 50
B1150CT-A | 2017-08-15 00:00:00 |  | 38 | 10
BB12231 | 2017-07-24 00:00:00 |  | 34.45 | 4
BB1517I | 2017-08-16 00:00:00 |  | 129 | 0
BB1517I | 2017-08-16 00:00:00 |  | 129 | 1
BB45 | 2017-08-02 00:00:00 |  | 32 | 1
BB685I | 2017-08-07 00:00:00 |  | 16.4 | 35
BB685I | 2017-07-05 00:00:00 |  | 18 | 50
BB685I | 2017-08-16 00:00:00 |  | 18 | 16
BB685I | 2017-08-16 00:00:00 |  | 18 | 34
BB685I | 2017-08-29 00:00:00 |  | 18 | 60
BB685P | 2017-07-19 00:00:00 |  | 39.1 | 10
BB685P | 2017-08-23 00:00:00 |  | 41.054 | 20
BB912I | 2017-08-07 00:00:00 |  | 13.9 | 100
BB912I | 2017-07-24 00:00:00 |  | 15 | 10
BB912I | 2017-08-02 00:00:00 |  | 15 | 20
BB912I | 2017-08-11 00:00:00 |  | 15 | 20
BB912I | 2017-08-16 00:00:00 |  | 15 | 30
BB912I | 2017-08-29 00:00:00 |  | 14.55 | 10
Spreadsheet: louise_kitchen__22701__Netco Credit Limits
Sheet: Sheet1

Counterparty | Credit Limit | Tenor Limit
Aquila, Inc. | 20000000 | 36
AEP | 150000000 | 60
Dynegy, Inc. | 50000000 | 60
Duke Trading & Marketing LLC | 150000000 | 60
Reliant Resources, Inc. | 50000000 | 60
Mirant Corp | 20000000 | 36
Coral | 100000000 | 60
Sempra Energy | 85000000 | 60
Cook Inlet Energy Supply, LLC | 500000 | 12
El Paso Energy Corp | 125000000 | 60
[NAME] | 100000000 | 60
Texaco Natural Gas, Inc. | 20000000 | 36
TransCanada Pipelines Ltd. | 40000000 | 60
Entergy-Koch | 30000000 | 48
BP Energy Company | 200000000 | 84
Cinergy Services | 75000000 | 60
MidAmerican Energy Company | 40000000 | 36
BP Corporation North America, Inc. | 200000000 | 84
Calpine Corp | 50000000 | 60
Enserco Energy Inc. | 0 | 3
Constellation Power Source, Inc. | 22500000 | 60
Conectiv Energy Supply, Inc. | 35000000 | 36
e Prime, Inc. | 10000000 | 24
CMS Marketing, Services and Trading Company | 50000000 | 36
TXU Energy Trading Company | 50000000 | 60
Koch Energy Trading, Inc. | 150000000 | 60
J. Aron & Company | 100000000 | 84
Oneok Energy Marketing and Trading Company LP | 30000000 | 60
Engage Energy Canada LP | 80000000 | 60
Nexen Marketing | 25000000 | 36
[NAME] | 75000000 | 60
PanCanadian Energy Services, Inc. | 12000000 | 24
Mieco, Inc. | 7500000 | 6
Cargill Energy | 100000000 | 60
Morgan Stanley Capital Group, Inc. | 100000000 | 84
Virginia Power Energy Marketing, Inc. | 100000000 | 60
OGE Energy Resources | 25000000 | 36
Allegheny Energy Supply Company LLC | 30000000 | 60
IDACORP Energy LP | 35000000 | 36
PSEG Energy Resources & Trade LLC | 35000000 | 36
Texla Energy Mangement, Inc. | 0 | 3
Spreadsheet: 66468d1267113674-copying-conditional-formatting-conditionalformatting
Sheet: Conditional

Projected Collections
Year Ending December 31, 2010
Office | PFR | Region | Collections
Alva | Adams | North | 370000
Okarche | Adams | North | 623000
Texhoma | Adams | North | 455000
[NAME] | [NAME] | North | 397000
[NAME] | [NAME] | North | 432000
[NAME] | [NAME] | North | 312000
Anadarko | Yates | South | 209000
Blanchard | Yates | South | 664000
[NAME] | Yates | South | 188000
Antlers | Zing | South | 551000
Seminole | Zing | South | 433000
Tishomingo | Zing | South | 508000
 |  | TOTAL | 5142000
Spreadsheet: 164521d1340803223-vlookup-using-the-current-cell-as-the-look-up-value-example
Sheet: Sheet1

STATE ID | STATE NAME
1 | State 1
2 | State 2
3 | State 3
4 | State 4
5 | State 5
6 | State 6
7 | State 7
8 | State 8
9 | State 9
10 | State 10
11 | State 11
Spreadsheet: 851856d1701975150-seeking-help-need-guidance-on-creating-a-dynamic-calendar-in-excel-with-categorized-tasks-2024-event-calendar-silentia-
Sheet: Month View

 | EVENTS | WEEK VIEW
 | Select Month: | Enter Year:
 | January | 2024
 | MONTH VIEW
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
Spreadsheet: 777387d1650363736-excel-formula-contains-function-test
Sheet: GAZ (2)

[NAME] | Contains text?
19, PG45LR |  |  |  |  |  |  |  | ROAD
[NAME] ROAD @ |  |  |  |  |  |  |  | STREET
LTHYME ROAD |  |  |  |  |  |  |  | CLOSE
BISHOPS BRIDGE ROAD @ |  |  |  |  |  |  |  | AVENUE
FLAT 1, SHEPHERD |  |  |  |  |  |  |  | COURT
2 , ROSE COTTAGES COURTLAND |  |  |  |  |  |  |  | !
 |  |  |  |  |  |  |  | RD
Spreadsheet: 85430d1285534453-change-row-color-after-filling-one-cell-excel-forum-color
Sheet: sheet1

pending/canceled | Client | # invoice | amount
p/t
C | [NAME] |  | 100
P | [NAME] |  | 300
P | [NAME] |  | 200
P | Fred |  | 150
after I change the value in A3 with "C" I would like cells A:D to be as below:
C | [NAME] |  | 100
P | [NAME] |  | 300
P | [NAME] |  | 200
P | Fred |  | 150
Spreadsheet: 758181d1638724216-vlookup-across-multiple-sheets-kod195-129-commercial-road
Sheet: V (8)

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Instructed
 |  | Variations |  |  |  |  |  |  |  |  |  |  |  | Cost Provided
Item | Column2 | Description | Qty | Unit | Rate | Extension |  |  |  |  |  |  |  | Subcontractor Only |  |  |  |  |  |  | Column1 | Column2 | Column3 | Column4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cancelled
 | Variations
Item | Description |  | Qty | Unit | Rate | Extension
 |  |  |  |  |  |  |  | HOME TO VARIATIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBCONTRACTOR OUTPUT SECTION |  |  | [NAME] CONSTRIUCTION SECTION
Item | Description |  | Qty | Unit | Rate | Extension |  | Subcontractor | Status | Rate | Extension | Margin % | Margin £/p | Provided | Sub Only | Instructed | Provided | Sub Only | Instructed
Note
V
*
8.01
8.02
8.03
8.04 |  |  |  |  |  |  |  |  |  | 0
8.05 |  |  |  |  |  |  |  |  |  | 0
8.06 |  |  |  |  |  |  |  |  |  | 0
8.07 |  |  |  |  |  |  |  |  |  | 0
8.08 |  |  |  |  |  |  |  |  |  | 0
8.09 |  |  |  |  |  |  |  |  |  | 0
8.1 |  |  |  |  |  |  |  |  |  | 0
8.11 |  |  |  |  |  |  |  |  |  | 0
8.12 |  |  |  |  |  |  |  |  |  | 0
8.13 |  |  |  |  |  |  |  |  |  | 0
8.14 |  |  |  |  |  |  |  |  |  | 0
8.15 |  |  |  |  |  |  |  |  |  | 0
8.16 |  |  |  |  |  |  |  |  |  | 0
8.17 |  |  |  |  |  |  |  |  |  | 0
8.18 |  |  |  |  |  |  |  |  |  | 0
8.19 |  |  |  |  |  |  |  |  |  | 0
8.2 |  |  |  |  |  |  |  |  |  | 0
8.21 |  |  |  |  |  |  |  |  |  | 0
8.22 |  |  |  |  |  |  |  |  |  | 0
8.23 |  |  |  |  |  |  |  |  |  | 0
8.23999999999999 |  |  |  |  |  |  |  |  |  | 0
8.24999999999999 |  |  |  |  |  |  |  |  |  | 0
8.25999999999999 |  |  |  |  |  |  |  |  |  | 0
8.26999999999999 |  |  |  |  |  |  |  |  |  | 0
8.27999999999999 |  |  |  |  |  |  |  |  |  | 0
8.28999999999999 |  |  |  |  |  |  |  |  |  | 0
8.29999999999999 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | To Collection
Spreadsheet: 124195d1318234759-multiple-text-options-to-one-text-string-795756-multiple-text-options-example
Sheet: CT

Old Name | New Name
bread buns | bread buns
bread | bread buns
buns | bread buns
bbuns | bread buns
small bread buns | bread buns
apples | fruit
bananas | fruit
cherries | fruit
tomatos | fruit
motors | cars
cars | cars
wagons | cars
cabs | cars
autos | cars
Spreadsheet: 824854d1680893156-help-with-creating-formula-to-meet-3-different-criterias-2-duplicate-1-unique-formula-help
Sheet: Open Positions

Job ID | Store | Job Title
9144583 | 3012 | Service Advisor
9163658 | 3012 | Service Advisor
9198747 | 3012 | Tire Technician
1504215 | 3013 | Mechanic
1619873 | 3013 | Service Advisor
1620573 | 3013 | Store Manager
1597093 | 3013 | Tire Technician
1597093 | 3013 | Tire Technician
1597093 | 3013 | Tire Technician
9163661 | 3014 | Tire Technician
Spreadsheet: 798374d1664452325-using-xlookup-while-avoiding-blanks-to-instead-return-adjacent-column-xlookup-with-or
Sheet: Sheet1

ID | Date
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
Spreadsheet: 882354d1730731653-trying-to-customize-the-excel-template-attendance-record-employee-attendance-record1
Sheet: Company Holidays

 | Company holidays
 | Company holidays | Description
 |  | Independence Day
 |  | Victory Day
 |  | Labor Day
 |  | Columbus Day
 |  | Veterans Day
 |  | Thanksgiving
 |  | Christmas
 |  | New Year's Day
 |  | MLK
 |  | Memorial Day
 |  | Juneteenth
Spreadsheet: 203527d1357152655-conditional-format-118-conditional-format
Sheet: Sheet1

56 T45 |  |  |  | T45
56 T45 |  |  | 56
56 T45
56 T45
56 T45
57 T45
58 T45
59 T45
60 T45
61 T45
62 T45
63 T45
64 T45
56 T45
56 T45
56 T45
56 T45
56 T45
Spreadsheet: 119515d1314478399-stuck-on-a-large-nested-function-kspan31105_excel_ques082711
Sheet: Lookup Table

ORIGINAL COLOR CODE | NEW COLOR CODE
0 | WHI
6 | SKY
7 | BLA
30 | IRC
33 | MES
47 | ALM
55 | INB
58 | THG
72 | AUR
74 | NIG
75 | WEB
79 | VER
95 | ICG
96 | BIS
7B | BLB
7U | BBR
7W | WHB
8W | JDW
B11 | ICE
B8 | BIA
BR1 | BR1
DAW | DAW
DP1 | DAP
[NAME] | BUR
F11 | VEL
F2 | BLF
F25 | SAP
F29 | WEN
F3 | NAM
F34 | BLM
F35 | TRA
F39 | OXF
F4 | BLW
F40 | CIN
F41 | WES
F42 | FLR
F44 | LIL
F45 | SAD
F5 | WHO
F59 | OST
F60 | CAP
F62 | BRB
F63 | BRA
F64 | SHA
F65 | MAN
F69 | WOO
F7 | NUT
F8 | SEA
F80 | COC
F9 | SIE
FD | CSU
FE | FRO
FF | SES
FP | CAV
FT | [NAME]
G9 | SAN
GR1 | MEG
HV | BOT
HW | BOM
HW1 | HOW
K1 | CAG
K2 | GRF
K3 | CIT
K4 | CAS
K5 | TRC
KA | BNT
KC | VAB
KE | VAO
KF | VAP
KG | VAG
LAW | LAW
LT | BLL
M3 | COV
MF | MFG
MP1 | MEP
NG | TGR
NM | NMB
NY | DUN
P5 | IRB
R1 | ROR
RR | EMB
S8 | SER
ST | ST
TF | TUB
TH | GTM
TXB | TXB
V7 | OLE
V9 | [NAME]
[NAME] | EAW
WA | WA
WB | WB
WC | WC
WD | WD
WH | WCA
XL | OXL
Y2 | SUN
YM | RAF
Spreadsheet: stacey_white__39126__LatestWestApplicationForNewESTATEAlias
Sheet: WaitingList

 | Problem | Worked By | Application | Requested By | Date Requested | Estimate Hours | Solution
1 | Build [NAME] report (WEST) |  | Excel | WEST | 2001-06-05 00:00:00 | 10 | retrieve data directely from database. Fill the data to two tabs based on the fixed format
2 | Create new WEST/Alberta Position report based on East and new add more regions |  | Excel | WEST/Alberta | N/A | 8 | [NAME] and add more regions, may need another 8 hours
3 | DprAutomation can't roll demand deal type data |  | Excel | Albaerta | N/A | 1 | [NAME] package and DprAutomation
4 | New West price report |  | Excel | West | N/A | 20 | based on East Price report and change the formular since West treat Sat as working day
5 | New Alberta price report |  | Excel | Alberta | N/A | 16 | based on East Price report and change the formular
6 | running time of Price report is too long and is not  stable |  | Excel | EAST/West/Albaerta | N/A | 24 | need to change the way to get price from to update link to open the files and copy and paste
7 | Current year of average price for [NAME] may be wrong and need add last day's of second month records to the tabs |  | Excel | East | N/A | 4 | Heat-rate swap is a new deal type. Previously no swap deals have gas component, and gas position of report struct is set to zeroes for swap deals. I set gas positions to the right values.
8 | DprAutomation does pull right data for SVCE portfolio |  | Excel | East | N/A | N/A | need meeting with [NAME] first to see which part has problem and need more information
9 | New  Ercot Automations |  | Excel | East | N/A | 8 | Create Automation based on requests
10 | Maitainter Access Cuve database regulely and  run curve_ld daily |  | Excel | West | N/A | N/A | worked to get her request approved  by Security as urgent
11 | new Curve_maker |  | Excel | New position manager | N/A | N/A
12 | a pplication to compare price data from the new real time manager system and old system |  | Excel | New position manager | N/A | N/A | modify the query to do so
13 | an application to show [NAME] and other |  | Excel | East(Donald) | N/A | 24/56 | Use pivot table to show dynamic data set(24 hrs). May have ablility to let user change  pivot table structure without knowledge of pivot table(32 hrs)
14 | need a option to run Pl/Toppage/BrokerFee and PCS/PID/Preminm at the same time for DprAutomation |  | Excel | East(Casey) | N/A | 2(N/A) | If just simplely merger two option together , may need 2 hr. However, we can do a lot of optimas since there are so many redudence, how much it can be done is depent on how much time we spent on this project
15 | Sometimes records in Curve database are lucked then cause database crush |  | Excel | Min | N/A | 1 | Need PC Id for all  Desk
16 | Need separate financial information to forward and liquidation financial |  | Excel | EAST | 2001-06-15 00:00:00 | N/A | [NAME] and Zhiyun will work on that
Spreadsheet: 817828d1676462721-formula-help-linking-other-workbooks-with-changing-names-summary
Sheet: Sheet1

Name | Age | City | Country | CellNos |  | Choose FileName |  |  |  |  |  |  |  |  | FileName
 |  |  |  |  |  | Data1 |  |  |  |  |  |  |  |  | Data1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data2
Spreadsheet: 0f05b788-4497-4e9e-a8d7-71ed8a579a37
Sheet: 15a

Product |  | Transactions
Single - Name* | Corporate | 33535
 | Loans | <100
 | Municipal | <100
 | Recovery | <100
 | Sovereign | 2084
Index Tranche | Asia | <100
 | Europe | <100
 | North America | 1111
Index | Asia | 216
 | Europe | 4021
 | North America | 4527
TOTAL |  | 45494
Estimated swap transaction volumes, week ending November 30, by product type (in number of transactions), all tenors and currencies. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product 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: 817149d1676026310-conditional-formatting-to-colour-graph-1
Sheet: Table

0.5 | 0
1 | 0
1.5 | 0
2 | 0
2.5 | 0
3 | 0
3.5 | 0
4 | 15
4.5 | 15
5 | 15
5.5 | 15
6 | 22
6.5 | 22
7 | 22
7.5 | 22
8 | 30
8.5 | 30
9 | 30
9.5 | 30
10 | 30
10.5 | 30
11 | 30
11.5 | 30
12 | 30
12.5 | 30
13 | 30