tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: jason_wolfe__13354__Rpt PMA Log Gas Three RM
Sheet: Variances

Risk Profit & Loss vs General Ledger Variances
As of December 31, 2000
Bookcode | Month | Code | Type | Description | Risk | Description
Firm Trade - South Texas (GB) | Dec | RM | E | Gas Daily Variances | 20671 | See [NAME] tab for deal level variances.
 |  |  |  | Book Admin:  Denver Plachy
FT Denver (W5) | Dec | RM | E | Broker Fee Adjustment | -155
 |  |  |  | Book Admin:  [NAME]
FT HPL Transport (A$, B{, B} ) | Nov | RM | O | Broker Fee Adjustment | -606
 |  |  |  | Book Admin:  [NAME]
FT HPLC (NB) | Jul | RM | O | Broker Fee Adjustment | -458
 |  |  |  | Book Admin:  [NAME]
FT Intra Central | Nov | RM | E | Broker Fee Adjustment | 2579
FT Intra Central | Nov | RM | E | Misc. Rounding | 1232
 |  |  |  | Book Admin:  [NAME]
FT Intra Ontario (43) | Dec | RM | E | Broker Fee Adjustment | -1220
FT Intra Ontario (43) | Various | RM | E | Misc. Rounding | 3593
 |  |  |  | Book Admin:  [NAME]
Intra Texas (PA) | Dec | RM | E | Gas Daily Variances | -32523 | See PA tab for deal level variances.
 |  |  |  | Book Admin:  [NAME]
Management West | Jul - Sep | RM | T | Pricing Variances | 234338 | July = (12,630) on gas daily deals due to rounding and decimal place differences in g/l & p&l calcs
 |  |  |  |  |  | August = 111,531 due to doubling of basis swap values in risk p&l
 |  |  |  |  |  | September = 135,437 on gas daily deals due to rounding and decimal place differences in g/l & p&l calcs
Management West | Jul | RM | E | Misc. Rounding | -1018
 |  |  |  | Book Admin:  [NAME]
GRAND TOTAL
Note:  Amounts in brackets ( ) would be a hurt to income on the risk p&l.
Amounts without brackets would be a help to income on the risk p&l.
Spreadsheet: 857140d1706196692-dependent-dropdowns-matching-dates-with-names-test_bookings-morphy-
Sheet: Calendar

 |  |  |  | [NAME] |  |  | [NAME] |  |  | MARY |  |  | ANNA |  |  | GREG
 |  |  |  | GFX |  |  | Producer |  |  | Producer |  |  | Lights |  |  | Audio
 |  |  |  | Yes/No | Note |  | Yes/No | Note |  | Yes/No | Note |  | Yes/No | Note |  | Yes/No | Note
JANUARY
01.01.2024 | Monday |  |  | yes |  |  | yes |  |  | no |  |  | yes |  |  | no
02.01.2024 | Tuesday |  |  | yes |  |  | yes |  |  | no |  |  | yes |  |  | no
03.01.2024 | Wednesday |  |  | yes |  |  | yes |  |  | no |  |  | yes |  |  | yes
04.01.2024 | Thursday |  |  | yes |  |  | yes |  |  | no |  |  | yes |  |  | yes
05.01.2024 | Friday |  |  | yes |  |  | yes |  |  | no |  |  | yes |  |  | no
06.01.2024 | Saturday |  |  | yes |  |  | yes |  |  | no |  |  | yes |  |  | no
07.01.2024 | Sunday |  |  | yes |  |  | yes |  |  | no |  |  | yes |  |  | yes
08.01.2024 | Monday |  |  | yes |  |  | yes |  |  | no |  |  | yes |  |  | yes
09.01.2024 | Tuesday |  |  | no |  |  | yes |  |  | no |  |  | yes |  |  | no
10.01.2024 | Wednesday |  |  | no |  |  | yes |  |  | no |  |  | yes |  |  | no
11.01.2024 | Thursday |  |  | no |  |  | no |  |  | no |  |  | yes |  |  | yes
12.01.2024 | Friday |  |  | no |  |  | no |  |  | no |  |  | yes |  |  | yes
13.01.2024 | Saturday |  |  | yes |  |  | no |  |  | no |  |  | yes |  |  | no
14.01.2024 | Sunday |  |  | yes |  |  | no |  |  | no |  |  | yes |  |  | no
15.01.2024 | Monday |  |  | yes |  |  | no |  |  | no |  |  | yes |  |  | yes
16.01.2024 | Tuesday |  |  | yes |  |  | no |  |  | no |  |  | yes |  |  | yes
17.01.2024 | Wednesday |  |  | yes |  |  | no |  |  | yes |  |  | yes |  |  | no
18.01.2024 | Thursday |  |  | no |  |  | no |  |  | yes |  |  | yes |  |  | no
19.01.2024 | Friday |  |  | no |  |  | no |  |  | yes |  |  | yes |  |  | yes
20.01.2024 | Saturday |  |  | no |  |  | no |  |  | yes |  |  | yes |  |  | yes
21.01.2024 | Sunday |  |  | no |  |  | no |  |  | yes |  |  | yes |  |  | no
22.01.2024 | Monday |  |  | yes |  |  | no |  |  | yes |  |  | yes |  |  | no
23.01.2024 | Tuesday |  |  | yes |  |  | no |  |  | yes |  |  | yes |  |  | yes
24.01.2024 | Wednesday |  |  | yes |  |  | no |  |  | yes |  |  | yes |  |  | yes
25.01.2024 | Thursday |  |  | yes |  |  | no |  |  | yes |  |  | yes |  |  | no
26.01.2024 | Friday |  |  | yes |  |  | no |  |  | yes |  |  | yes |  |  | no
27.01.2024 | Saturday |  |  | yes |  |  | no |  |  | yes |  |  | yes |  |  | yes
28.01.2024 | Sunday |  |  | yes |  |  | yes |  |  | yes |  |  | yes |  |  | yes
29.01.2024 | Monday |  |  | yes |  |  | yes |  |  | yes |  |  | yes |  |  | no
30.01.2024 | Tuesday |  |  | yes |  |  | yes |  |  | yes |  |  | yes |  |  | no
31.01.2024 | Wednesday |  |  | yes |  |  | yes |  |  | yes |  |  | yes |  |  | yes
Spreadsheet: 865353d1712390420-make-a-list-from-information-on-different-sheets-bestellijst-aligw
Sheet: Weekly orderlist

week | 14 | Sluipwespen |  | Roofvliegen
Reseller | Client | Groot | Klein | Groot | Klein
Spreadsheet: 129308d1321544332-error-detection-formula-detecting-256-char-cells-why-example
Sheet: SunGard HP9000 Test Plan Items

 |  |  |  |  |  |  | This is an example of a error-detection formula that lights up a header cell should there be an #error in any of the detail cells directly below it.  It work well, except it also picks up cells with more than 255 characters -- which is not an error.  Can you solve how to fix this so that true errors are detected, but these non-errors are not?
 | 3 | title | Helper column |  | Helper column
 | Item # | Description | #N/A | Other Description | 767 |  | <--- the conditional formatting fiormula of cell [NAME] seems to pick cells without error.  I put the formula in cell C8 so that you can see it. note:  the offset might look a bit confusing, but is only so that detail can be added and removed without causing #REF errors, and because the same formula is used on different spreadsheets with different numbers of header & details rows.  If you find the offsets confusing, you can replace them with cell references.
 | 1 | 12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234A | 255 | 12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234A | 255 |  | <--- if filtered on item 1, c7 correctly lights up.
 | 2 | 123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345A | 256 | 123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345A | 256 |  | <--- if filtered on item 2, c7 incorrectly lights up, yet has no #error
 | 3 | #N/A | #N/A | 123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345A | 256 |  | <-- if filtered on item 2, c7 correctly lights up because error is correctly detected
Spreadsheet: robin_rodrigue__33273__Sunil
Sheet: Sheet1

BOOK ID | DATE | RESERVE | EXPLANATION
GD-NEW | 2000-08-24 00:00:00 | -35000000 | Liquidity Risk due to Socal positions
 | 2000-08-25 00:00:00 | -50000000 | Liquidity Risk due to Socal positions
 | 2000-09-05 00:00:00 | 15000000 | Release Income
 | 2000-09-26 00:00:00 | 34200000 | Release Income
MGMT-WEST | 2000-08-21 00:00:00 | -50000000 | Liquidity Risk due to Socal positions
 | 2000-08-25 00:00:00 | -25000000 | Liquidity Risk due to Socal positions
 | 2000-08-30 00:00:00 | -40000000 | Liquidity Risk due to Socal positions
 | 2000-09-01 00:00:00 | 15000000 | Release Income
 | 2000-09-29 00:00:00 | 38000000 | Release Income
MANAGEMENT | 2000-08-07 00:00:00 | -10000000 | Reserve
 | 2000-08-08 00:00:00 | -10000000 | Reserve
 | 2000-08-11 00:00:00 | -10000000 | Reserve
 | 2000-08-21 00:00:00 | -45000000 | Reserve
 | 2000-09-29 00:00:00 | 73949000 | Release Income
Spreadsheet: 106535d1303815172-match-cell-contents-display-difference-in-another-cell-book1_gsisbay
Sheet: Workings

A | B |  |  |  |  |  |  |  | C(result)
Seattle, Washington, USA | Washington USA |  | Seattle Washington | Washington |  | Seattle |  |  | Seattle
Washington Seattle USA | Washington USA |  | Washington Seattle | Washington |  | Seattle |  |  | Seattle
Washington, USA | Seattle Washington USA |  | Washington | Seattle Washington |  | Seattle |  |  | Seattle
Washington USA | Washington Seattle USA |  | Washington | Washington Seattle |  | Seattle |  |  | Seattle
Seattle Washington | Seattle USA |  | Seattle Washington | Seattle |  | Washington |  | USA | Washington USA
Spreadsheet: louise_kitchen__22856__Netco Commercial4122pm
Sheet: East

Trading |  | Marketing
Ballato, [NAME]
Baughman, [NAME] |  | [NAME], [NAME]
[NAME], [NAME] |  | [NAME], [NAME]
Lowell, [NAME] |  | [NAME], [NAME]
Broderick, [NAME] |  | Rorshock, [NAME]
Benson, [NAME] |  | Braddock, [NAME]
[NAME], Gautum |  | Meyn, [NAME]
[NAME], [NAME] |  | Hiemstra, Nick
Makkai, [NAME] |  | Herrera, [NAME]
Rogers, [NAME] |  | [NAME], [NAME]
[NAME], [NAME] |  | Abler, [NAME]
Matthews, [NAME] |  | [NAME], [NAME]
[NAME], [NAME] |  | Trefz, Greg
[NAME], [NAME] |  | Munoz, Victor
[NAME], [NAME] |  | McCralen, Greg
[NAME], [NAME] |  | Forster, [NAME]
Saibi, [NAME] |  | Wood, George
Forney, [NAME] |  | Pacheco, [NAME]
Taek Oh, [NAME] |  | Aucoin, [NAME]
King, [NAME] |  | [NAME], [NAME]
Schiavon, [NAME] |  | Cross, [NAME]
[NAME], [NAME] |  | Jones, [NAME]
[NAME], [NAME] |  | Pan, Liqun
Stalford, [NAME] |  | Simoes, Catherine
Wang, [NAME] |  | Furrow, Dale
[NAME], [NAME] |  | Jafry, [NAME]
Seely, [NAME] |  | Mitro, Fred
Gualy, Jaime |  | [NAME], Terrell
May, [NAME]
Missa, Narsimha
Pedron, [NAME]
Wagner, [NAME]
Rust, [NAME]
Kaniss, [NAME]
Giron, Gustavo
Benchluch, Moises
Marquez, [NAME]
[NAME], [NAME]
[NAME], [NAME]
TJ Black | admin | Trading
[NAME] | admin | Trading
[NAME] | admin | Trading
[NAME] | admin | Marketing
[NAME] | admin | Marketing
[NAME] | admin | Marketing
May, [NAME]
Acevedo, [NAME]
Missa, Narsimha
Pedron, [NAME]
Wagner, [NAME]
[NAME], [NAME]
Santucci, [NAME]
Rust, [NAME]
Kaniss, [NAME]
Imai, Rika
Giron, Gustavo
Benchluch, Moises
Marquez, Maurico
[NAME], [NAME]
Cline, [NAME]
[NAME], [NAME]
[NAME], [NAME]
[NAME], [NAME]
Symms, [NAME]
[NAME], [NAME]
Comeaux, [NAME]
Serio, [NAME]
[NAME], [NAME]
Spreadsheet: e9db6eca-82dd-46a0-9f44-d406da16985b
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FMDMC | Test | FMDMC | Complete DMD Evaluation-Males | Complete DMD Evaluation-Males | DMD Deletion/duplication: Dosage analysis of all exons on the DMD gene | EDTA (lavender-top) tube: EDTA |  |  | 20 | mL | 20 mL whole blood collected in a lavender top (EDTA) tube(s). Send whole blood at ambient temperature. | 10 mL | Specimens other than	Whole blood Anticoagulants other than	EDTA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | A final report will be faxed under separate cover.   Test Performed by Athena Diagnostics                                       377 Plantation Street                                       Four Biotech Park                                       Worcester, MA 01605 | Monday, Thursday | 6-8 weeks | 6-8 weeks |  | Profile |  |  |  |  | Athena Diagnostics
FMDMC | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
FMDMC | Result | Z0089 | Partial DMD Del/Dup | Partial DMD Del/Dup | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FMDMC | Result | Z0090 | Partial DMD Sequencing | Partial DMD Sequencing | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FMDMC | Billing Component | FMDMC |  | UNLISTED MOLECULAR PATHOLOGY |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81479
FMDMC | Billing Component | FMDMC |  | UNLISTED MOLECULAR PATHOLOGY |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81479
Spreadsheet: louise_kitchen__23061__0111MarginRequirements
Sheet: 1121

FUTURES MARGIN REQUIREMENTS
2001-11-23 00:00:00
2001-11-21 00:00:00
 | US $$$ |  |  |  |  |  |  |  |  |  |  |  | CANADIAN $$$
Broker | TE | Credit Facility Covering TE | TE Less CreditCoverage | Net Option Value | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin |  | Daily Facility Movement Inc/(Dec) Line |  | Wire Day Cash In/(Out) |  | OTE | Initial Margin
ABN-Amro Inc | 421300.0260000248 |  |  | 0 | 421300
ADM INVESTOR | -0.3009999946807511 |  |  | 0 | 0
BANK ONE | 0.2200000286102295 |  |  | 0 | 0
CARR FUTURES (NG) | 0 |  |  | 0 | 0
CARR FUTURES INC. | 4925089 |  |  | 0 | 4833284
CREDIT SUISSE FIRST BOSTON | 684450.820000004 |  |  | 0 | 484191
EDF MAN   (see note below) |  |  |  | -32637730 | 15320613
FIMAT * | 10949678.99999999 | 3723267.560000005 |  | 0 | 10949679 | 0 |  | 1
HSBC - US$ | 661636.318591 |  |  | 0 | 370311
HSBC - Canadian | 0 |  |  | 0 |  |  |  |  |  |  |  |  | 196189.5 | 199720
JP Morgan | 1210447.6 |  |  | 0 | 917620
[NAME] | 0 |  |  | 0 | 0
PARIBAS | 104036809.1800001 |  |  | 0 | 150063397
PRUDENTIAL SI | 0.111421209294349 |  |  | 0 | 0
REFCO, INC | 0.2590000069403686 |  |  | 0 | 0
R J O'BRIEN | 38320.28 |  |  | 0 | 26000
SAUL STONE & COMPANY | 78302 |  |  | 0 | 58500
SMITH BARNEY, INC ** | 5882652.379999993 |  |  | 0 | 5882652 | 5882652 |  |  | 0
SMITH BARNEY, INC ** (Financial) | 115199.71 |  |  | 0 | 347700 |  | 347700
TOTAL EXCLUDING MID-DAY CALLS |  |  |  |  |  |  |  |  |  |  |  |  | 196189.5 | 199720
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann | 0
TOTAL INCLUDING MID-DAY CALLS | 173791246.9666202
 |  | Used Line
Credit Lines: | Line | OTE | Initial Margin | Total Line Used | Total Line Unused
Smith Barney | 50000000 | 0 | 5882652
 |  |  |  |  |  |  |  |  |  |  |  |  | -46111262.62767977
Fimat | 20000000 | 3723267.560000005 | 0
1 Includes amounts withheld from payments due Enron.  Fimat's customer agreement states that excess margin including OTE due to Enron must first be used to pay down advances on the facility.
Spreadsheet: 167896d1342145870-sorting-and-grouping-problem-example-problem
Sheet: Sheet1

 | Sets | Reps | Weight (kg) per Set | Set Total (kg) | Exercise Total  (kg) | No. of Sets | Number of Reps per Exercise | Average Weight Per Rep | Set % of 1RM | Exercise Average  % of 1RM | Intensity Zone | % of Sets at Zones of 1RM
Squats | 1 | 5 | 60 |  |  |  |  |  |  |  | <30%
1RM | 1 | 5 | 100 |  |  |  |  |  |  |  | 30-39% | 0
300 | 1 | 5 | 140 |  |  |  |  |  |  |  | 40-49%
 | 1 | 5 | 180 |  |  |  |  |  |  |  | 50-59% | 0
 | 1 | 5 | 180 |  |  |  |  |  |  |  | 60-69%
 | 1 | 15 | 140 |  |  |  |  |  |  |  | 70-79% | 0
 | 1 | 15 | 140 |  |  |  |  |  |  |  | 80-89%
 | 1 | 12 | 140 |  |  |  |  |  |  |  | 90-100% | 0
 | 1 | 12 | 140 |  |  |  |  |  |  |  | >100% | 0
 | 1 | 12 | 140
 | 1 | 12 | 140
 | 1 | 12 | 140
 | 1 | 10 | 140
 | 1 | 10 | 140
 | 1 | 10 | 140
Spreadsheet: 878459d1725541418-return-value-based-on-product-name-excel_forum_question
Sheet: Products

[NAME] name | Product category
Pre-order: Wielershirt "Domstadrijder" - heren - Wit M
Cadeauverpakking
Daklei [NAME]
Themawandelingen bundel
Daklei [NAME]
Cadeauverpakking
Cadeauverpakking
Daklei [NAME]
Mesjokke Dommetjes Chocola Puur of Melk - Melk
DomKopjes - Licht [NAME]
Domkaars 22cm - Gele tint / 22cm
T-Shirt "UUUUUU" - Groen - L
Utrechtse speelkaarten
Cadeauverpakking
A Piece of Me: [NAME]
Daklei [NAME]
T-Shirt "UUUUUU" - Zwart - XL
Daklei [NAME]
Spreadsheet: 135417d1326041021-lists-and-max-indexrank
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Author | Total Pages | rank unique | 261 | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME] | 26 | 1 | 261 | fred blogs
 |  |  |  |  |  |  |  |  |  | [NAME] | 261 | 4 | 245 | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME] | 245 | 2 | 26 | [NAME]
 |  |  |  |  |  |  |  |  |  | fred blogs | 261 | 3
Spreadsheet: 780798d1652787787-matching-name-address-and-party-by-id-sample
Sheet: 2021

StateVoterID | FirstName | MiddleName | LastName | OfficialParty | RegistrationAddr1
3000804 | [NAME] | FULLER | CHAPMAN | D | 7 MOONEY ST
6000005 | KEITH | EDWARD | CORBETT | U | 255 HALLS HILL RD
6000009 | RACHEL |  | PALUCH | R | 63 MEADERBORO RD
6000011 | [NAME] | [NAME] | [NAME] | U | 70 ANTHON RD
6000012 | [NAME] | BRUCE | GORDON | R | 8 KEEWAYDIN DR
6000013 | IRENE | ROSE | GRIFFIN | D | 349 ROUTE 11D
6000015 | A. | PATRICIA | [NAME] | U | 311 MAIN ST
6000016 | THOMAS | E. | [NAME] | R | 311 MAIN ST
6000024 | [NAME] | FREDERICK | BRIGGS | D | 1345 MOUNT MAJOR HWY
6000025 | FRANCES | ELEANOR | WASHBURN | R | 20 FRANK C GILMAN HWY
6000027 | EDWARD | HARVEY | [NAME] | R | 175 STOCKBRIDGE CORNER RD
6000028 | [NAME] | HIESTER | [NAME] | R | 175 STOCKBRIDGE CORNER RD
6000029 | WAYNE | A. | GASSETT | R | 20 STAR LN
6000030 | EDWARD | EMILE | NORLING | U | 176 NEW DURHAM RD
6000032 | [NAME] | BRENT | GOSSELIN | R | 48 LETTER S RD
6000033 | GAYLE | BARBARA | GOSSELIN | R | 48 LETTER S RD
6000035 | CONSTANCE | M. | [NAME] | R | 321 HALLS HILL RD
6000036 | RICHARD | ALAN | [NAME] | R | 321 HALLS HILL RD
6000037 | FRANCES | M. | GUTTORMSEN | R | 148 OLD WOLFEBORO RD
6000038 | KRISTINA | LYNN | SAALFRANK | U | 175 FRANK C GILMAN HWY
6000039 | MELVILLE | BERNHARD | GUTTORMSEN | R | 148 OLD WOLFEBORO RD
6000040 | [NAME] | MICHELE | JOHNSTON | R | 246 MAIN ST
6000043 | ALLEN | ELDRED | GILES | U | 22 RIVERLAKE ST
Spreadsheet: 9e414cc2-8625-4b08-b540-f2258b0bfe6a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
C4 | Test | C4 | [NAME], Serum | [NAME], S | Nephelometry | Serum Gel Tube: SGT Plain, Red-Top or serum gel tube: Red |  |  | 1 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | 14-40 mg/dL | Monday through Saturday; 3 p.m. | 1 day | 2 days | 1 | 86160 |  |  |  |  | Rochester
C4 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
C4 | Result | C4 | [NAME], S | [NAME], S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 4498-2 | Complement C4:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 698061d1601716897-extract-specific-numbers-and-text-from-long-string-product-codes
Sheet: Test

 | Product Codes (Manual) |  |  |  |  |  | Model Version Code Table
 | Product | List of Codes | Model Version Code | Model Version |  |  | Model Version Code | Model Version
 | Product 1 | 6P5 ,800 ,810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,V50 | 800 | 2020 |  |  | 800 | 2020
 | Product 1 | 6P5 ,801 ,810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,V50 | 801 | 2021 |  |  | 801 | 2021
 | Product 2 | 6P5 ,777, 810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,XY0 | XY0 | 2020 |  |  | XY0 | 2020
 | Product 2 | 6P5 ,777, 810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,XY1 | XY1 | 2021 |  |  | XY1 | 2021
 | Product 3 | 6P5 ,777, 810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,XZ9 | XZ9 | 2020 |  |  | XZ9 | 2020
 | Product 3 | 6P5 ,777, 810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,X20 | X20 | 2021 |  |  | X20 | 2021
 | Product Codes (Auto - Required Formulas)
 | Product | List of Codes | Model Version Code | Model Version
 | Product 1 | 6P5 ,800 ,810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,V50
 | Product 1 | 6P5 ,801 ,810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,V50
 | Product 2 | 6P5 ,777, 810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,XY0
 | Product 2 | 6P5 ,777, 810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,XY1
 | Product 3 | 6P5 ,777, 810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,XZ9
 | Product 3 | 6P5 ,777, 810 ,818 ,840 ,900 ,926 ,B03 ,B59 ,H50 ,K11 ,K17 ,P49 ,P59 ,R01 ,R66 ,U22 ,U59 ,X20
Spreadsheet: 92456d1292005749-sum-values-when-criteria-matches-more-than-one-cell-sumif
Sheet: Sheet1

 |  |  | A | B |  |  |  | SUM OF A | SUM OF B
 |  | 2010-12-10 00:00:00 | 25 | 45 |  |  | 2010-12-10 00:00:00
 |  | 2010-12-10 00:00:00 | 41 | 15 |  |  | 2010-12-11 00:00:00
 |  | 2010-12-10 00:00:00 | 75 | 25 |  |  | 2010-12-12 00:00:00
 |  | 2010-12-10 00:00:00 | 12 | 45
 |  | 2010-12-10 00:00:00 | 35 | 65
 |  | 2010-12-10 00:00:00 | 63 | 35
 |  | 2010-12-10 00:00:00 | 25 | 48
 |  | 2010-12-10 00:00:00 | 85 | 59
 |  | 2010-12-10 00:00:00 | 15 | 75
 |  | 2010-12-10 00:00:00 | 12 | 25
 |  | 2010-12-10 00:00:00 | 45 | 15
 |  | 2010-12-10 00:00:00 | 35 | 35
 |  | 2010-12-11 00:00:00 | 3 | 26
 |  | 2010-12-11 00:00:00 | 65 | 24
 |  | 2010-12-11 00:00:00 | 37 | 54
 |  | 2010-12-11 00:00:00 | 42 | 52
 |  | 2010-12-11 00:00:00 | 51 | 65
 |  | 2010-12-11 00:00:00 | 25 | 72
 |  | 2010-12-11 00:00:00 | 24 | 11
 |  | 2010-12-12 00:00:00 | 62 | 42
 |  | 2010-12-12 00:00:00 | 20 | 33
 |  | 2010-12-12 00:00:00 | 33 | 36
 |  | 2010-12-12 00:00:00 | 42 | 39
 |  | 2010-12-12 00:00:00 | 42 | 26
 |  | 2010-12-12 00:00:00 | 25 | 35
 |  | 2010-12-12 00:00:00 | 62 | 4
 |  | 2010-12-12 00:00:00 | 23 | 65
 |  | 2010-12-12 00:00:00 | 44 | 35
Spreadsheet: 845236d1696755030-hotel-planner-room-availability-eliminating-booked-rooms-from-drop-down-hotel
Sheet: Data

Direct |  | 1 |  | BACS
Booking |  | 2 |  | Cheque |  | 2 [NAME] |  | 2
 |  | 3 |  | Cash |  | 3 [NAME]
 |  | 4 |  |  |  | 4 Karen Douglas
 |  | 5 |  |  |  | 5 [NAME]
 |  | 6 |  |  |  | 6 [NAME]
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
Spreadsheet: e9332b52-b697-48d2-8faa-cbfcf8dd19c3
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Curb Records | 715187915329 | [NAME] & [NAME] | Pilgrimage | 2009-11-03 | Compact Disc | Country | 13.99 | N | To Be Retired
Spreadsheet: 695351d1600169116-sorting-data-that-only-has-value-greater-than-1-times-etaf-1-3-
Sheet: Code

 |  | Delays In Numbers | Time Final | Time 1
 | Shop | Number Of Delays | Longest Delay
 | Aldi | 1 | 07:55:00
 | Lidl | 2 | 01:55:00
 | Morrisons | 3 | 05:55:00
 | Sofa World | 2 | 07:03:00
 | Burger King | 3 | 09:40:00
 | Shop | Number Of Delays | Longest Delay
Spreadsheet: 772053d1646988043-horizontal-vertical-data-vertical-data-2-
Sheet: Vertical

# Invoice | 3 | 2 | 4 | 6 | 8
Manager | [NAME] | [NAME] | Sherrie | [NAME] | Sherrie
Name | [NAME] | Juanita | Christina | [NAME] | Christina
Status | Closed | Open | Closed | Open | Closed
Date Event | 2022-01-02 00:00:00 | 2021-11-15 00:00:00 | 2022-01-10 00:00:00 | 2021-12-12 00:00:00 | 2022-01-10 00:00:00
Eating Score | 4 | 1 | 4 | 2 | 4
Mobility | 4 | 5 | 6 | 5 | 6
Self-Care | 3 | 2 | 3 | 2 | 3
BSP | 1 | 2 | 1 | 1 | 1
Vendor | Harprove LIVING, INC | GHVS, INC | Tomac International | UCFC | Tomac International
Comments | Emailed 2/1/22 | Still open |  | None