tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1fe98130-b1a4-471d-85f9-88d59326acaf
Sheet: 13d

 | Swap Dealers/MSPs5 |  |  | Others
Product1 | HY6 | IG | Other | HY | IG | Other
Index Tranche | 66879 | 722600 | 702405 | 16877 | 80145 | 109445
Europe | 0 | 0 | 695262 | 0 | 0 | 105046
North America/Asia | 66879 | 722600 | 7143 | 16877 | 80145 | 4399
Other | - | - | - | - | - | -
Index | 910163 | 4004206 | 5898528 | 367071 | 1253784 | 1552138
Asia | 0 | 0 | 175299 | 0 | 0 | 46463
Europe | 0 | 0 | 5149440 | 0 | 0 | 1394671
North America | 910163 | 4004206 | 167945 | 367071 | 1253784 | 47992
Other | 0 | 0 | 405844 | 0 | 0 | 63012
OTHER* | 0 | 0 | 940786 | 0 | 0 | 417233
TOTAL | 977042 | 4726806 | 7541719 | 383948 | 1333929 | 2078816
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: daren_farmer__5285__buydef
Sheet: Sheet1

BUYBACK & DEFICIENCY DEALS
 |  |  |  | Buyback | Type
Counterparty | Undertake | Sale | Swing | K # | of deal | Term | [NAME] | VM
AirProducts, Inc. | 414092 | 414025 | 414090 | 96023739 | Deficiency | 10/00-9/01 | 1418
BASF Corporation | 133000 | 120266 | 122310 | 96022419 | Buyback | 11/1/99-10/31/01 | 1437
Beaumont Methanol Limited Partnership | 696599 | 696585 | 696594 | 96000279 | Buyback | April | 1428
Beaumont Methanol Limited Partnership | 749794 | 749785 | 749792 | 96000279 | Buyback | May | 1428
Chevron Phillips Chemical | 413472 | 413447 | 413462 |  | Buyback | 10/00-9/01 | 1024
[NAME] | 544392 |  | 544388 | 96018826 | Buyback | 1/1/01-12/31/01 | 8216 | Fred
Enron Methanol Co | 544402 |  | 544395 | 96018827 | Buyback | 1/1/01-12/31/01 | 8291 | Fred
Equistar Chemicals LP | 586534 |  | 586537 | 96000240 | Buyback | 2/01-5/01 | 1552, 1373, 1553, 1334, 1399, 1062, 1384 | [NAME]
Formosa Hydrocarbons | 487064 | 446661 |  |  | Buyback | 11/00-10/01 | 1000, 1383
Global Octanes Texas LP | 373580 | 276461 | 373590 | 96019673 | Deficiency | 9/00-8/01 | 1528 | Thu
Lyondell-Citgo | 542915 | 542893 |  | 96008792 | Buyback | 1/1/01-12/31/01 | 1063
Marathon-Ashland | 513826 | 454436 |  | 96019644 | Buyback | 12/00-11/01 | 1431
Mobil Oil Corp. | 586400 | 538950 | 413351 | 96055715 | Buyback | 11/00-9/02 | 1040
Petrofina Gas Pipeline | 695692 |  | 695702 | 96019331 | Buyback | 4/01-10/01 | 1484
Rohm & Haas | 703325 | 703318 |  | 96019546 | Buyback | April | 1506 | Thu
Rohm & Haas | 752864 | 752860 |  | 96019546 | Buyback | May | 1506 | Thu
Shell Oil Company | 359274 | 284905 |  | 96019720 | Buyback | 7/00-6/01 | 1095, 1060, 1581, 1061
Union Carbide | 63576 | 15765 | 34825 | 96019676 | Deficiency | 2/1/99-12/31/01 | 1308 | [NAME]….ENA
Union Carbide | 63573 |  | 34832 | 96019676 | Deficiency | 1/1/00-12/31/01 | 1332 | Fred….ENA
Union Carbide |  | 699730 |  | 96019676 | Deficiency | April | 1332 | Fred….ENA
Valero Marketing & Supply | 478227 | 454447 |  | 96023591 | Buyback | 11/00-4/01 | 1394
Valero Marketing & Supply | 478229 | 454452 |  | 96023591 | Buyback | 11/00-4/01 | 1233
Valero Marketing & Supply | 478230 | 454455 |  | 96023591 | Buyback | 11/00-4/01 | 8018
Westvaco | 692934 | 692912 |  |  | Buyback | April | 1020
Westvaco | 749832 | 692912 |  |  | Buyback | 5/01-8/04 | 1020
 |  |  |  |  |  |  |  |  | ENA
 |  |  |  |  |  |  |  |  | ENA
Spreadsheet: kim_ward__20804__Feb Basis
Sheet: Sheet1

 | Basis |  |  |  | Corresponding Fixed-Price
 | Volume | Price | Date |  | Volume | Price | Date | Confirm #
1.) | 50000 | -0.65 | 2001-01-10 00:00:00 |  | 50000 | 8.2 | 2001-01-03 00:00:00 | EU8529.1/67851
2.) | 50000 | -0.65 | 2001-01-10 00:00:00 |  | 50000 | 8.61 | 2001-01-02 00:00:00 | EU8529.1/67851
3.) | 100000 | -0.65 | 2001-01-10 00:00:00 |  | 100000 | 9.72 | 2001-01-10 00:00:00 | EU8529.G-L/67851
Spreadsheet: b78a6b95-1c96-4b6d-b622-4ee29d4be39a
Sheet: Sheet1

 | [NAME] and Number: OCED 3520E/7233E
 | Course Title: Teaching Methods: Reserched Based
 | Instructor: [NAME]
 | Location: Essex Ag
 | Student Name: | School: | FSC | MAVA | Check #
1 | Denufrio, Vinny | Dracut
2 | Brown, [NAME] | Putnam
3 | Whiteley, [NAME] | Waltham
4 | Piantedosi, [NAME] | Waltham
5 | [NAME], [NAME] | Waltham
6 | Nihan, [NAME] | [NAME]
7 | Holman, [NAME] | North Shore
8 | Rafter, [NAME] | Minuteman
9 | Fielding, [NAME] | Lowell
10 | Membreno, Sheri | [NAME] | Paid | Paid | Online
11 | Adams, [NAME] | [NAME] | Paid | Paid | Online
12 | Devlin, [NAME] | Gloucester
13 | Payne, [NAME] | Marblehead
14 | Rogol, [NAME] | Essex
15 | Gurner, [NAME] | Brookline | Paid | Paid | Online
16 | Welch, [NAME] | Quincy
17 | [NAME], [NAME] | Quincy
18 | Kierstead, [NAME] | Plymouth South
19 | Adragna, [NAME] | Plymouth South
20 | Strassel, [NAME] | Plymouth South
21 | [NAME], [NAME] | Plymouth South
22 | Medeiros, Stephen | Plymouth South
23 | [NAME], [NAME] | Plymouth South
24 | [NAME], [NAME] | Norfolk
25 | Stackhouse, [NAME] | Essex | Paid | Paid | Online
26 | Shanahan, [NAME] | BVT
27 | Depace, Janice | Medford
28 | [NAME], [NAME] | Shawsheen | Paid | Paid | Online
29 | Brogan, [NAME] | [NAME]
30 | Conway, [NAME] | [NAME]
31 | Ciampa, [NAME] | [NAME]
32 | Pero, [NAME] | New | Paid | Paid | Online
Spreadsheet: 189367d1351171480-sum-if-month-of-a-date-jan-feb-etc-sumif-date
Sheet: Sheet1

 |  | Day | Category | $ [NAME] | Description |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  | 2012-01-01 00:00:00 | Ex A | 5000 |  |  |  |  | Ex A | 5000
 |  | 2012-02-02 00:00:00 | Ex B | 5000 |  |  |  |  | Ex B |  | 5000
 |  | 2012-03-03 00:00:00 | Ex C | 5000 |  |  |  |  | Ex C |  |  | 5000
 |  | 2012-04-04 00:00:00 | Ex D | 5000 |  |  |  |  | Ex D |  |  |  | 5000
 |  | 2012-05-05 00:00:00 | Ex E | 5000 |  |  |  |  | Ex E |  |  |  |  | 5000
 |  | 2012-06-06 00:00:00 | Ex F | 5000 |  |  |  |  | Ex F |  |  |  |  |  | 5000
 |  | 2012-07-07 00:00:00 | Ex G | 5000 |  |  |  |  | Ex G |  |  |  |  |  |  | 5000
 |  | 2012-08-08 00:00:00 | Ex H | 5000 |  |  |  |  | Ex H |  |  |  |  |  |  |  | 5000
 |  | 2012-09-09 00:00:00 | Ex I | 5000 |  |  |  |  | Ex I |  |  |  |  |  |  |  |  | 5000
 |  | 2012-10-10 00:00:00 | Ex J | 5000 |  |  |  |  | Ex J |  |  |  |  |  |  |  |  |  | 5000
 |  | 2012-11-11 00:00:00 | Ex K | 5000 |  |  |  |  | Ex K |  |  |  |  |  |  |  |  |  |  | 5000
 |  | 2012-12-12 00:00:00 | Ex L | 5000 |  |  |  |  | Ex L |  |  |  |  |  |  |  |  |  |  |  | 5000
Spreadsheet: 208408d1358814358-commits-getting-info-from-another-page-twst
Sheet: Stats

 |  | Tom's Nutrition Plan!
 | Name: | tom |  |  | Weight Training (Hours per Week): | Five Hours (Ideal)
 | Sex: | Male |  |  | Muscle Maintenance:
 | Height: | 160 |  | cms | [NAME]: |  | calories
 | Weight: | 68 |  | kgs | Body type: | Meso-Endo
 | Age: | 30 |  | years
 | Goal: | fat loss
Spreadsheet: 69908d1270576817-need-helping-adding-rows-2009-8teams-
Sheet: WEEK 1B

MUV | BET TEAM | VS TEAM | GAME 1 | [NAME] | G1 $ Win | [NAME] | G1 $ Risk | G1   Result | GAME 2 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G2 Result | GAME 3 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G3 Result | TOT Units Risked | TOT Units Won | TOT Units Lost | TOT Unit Profit | TOT $$$ Profit
0 | NYY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | BOS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | MIN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | CHC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | WAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | PIT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | KC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | SD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
RETURN TO MLB OVERALL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOT L | 0
WEEK 1B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOT W | 0
Spreadsheet: 104113d1301754213-replicating-formula-excelit-_replicate_test
Sheet: PrSales_12

 |  |  |  |  |  |  | PrSales_10 | PrSales_11 | PrSales_10 | PrSales_11 |  |  |  | 2012
 |  |  |  | Numbers below represent the number sold per product
 | Product | Cost | Selling Price | jan | feb | [NAME] | apr | may | jun | jul | aug | sept | oct | nov | dec
 | 1 | 4.9 | 6.125 | 55 | 53.04 | 300.9 | 361.08 | 390.66 | 399.84 | 117.3 | 156.06 | 394.74 | 188.7 | 297.84 | 227.46
 | 2 | 2.87992 | 3.5999 | 47.94 | 6.12 | 169.32 | 44.88 | 47.94 | 350.88 | 64.26 | 40.8 | 59.16 | 69.36 | 324.36 | 338.64
 | 3 | 2.87992 | 3.5999 | 315.18 | 119.34 | 193.8 | 147.9 | 315.18 | 228.48 | 143.82 | 59.16 | 375.36 | 331.5 | 336.6 | 306
 | 4 | 2.75 | 3.4375 | 274.38 | 171.36 | 232.56 | 202.98 | 274.38 | 45.9 | 395.76 | 221.34 | 105.06 | 63.24 | 341.7 | 313.14
 | 5 | 1.36 | 1.7 | 194.82 | 113.22 | 255 | 5.1 | 194.82 | 81.6 | 346.8 | 182.58 | 120.36 | 263.16 | 320.28 | 362.1
 | 6 | 2.4 | 3 | 406.98 | 55.08 | 384.54 | 231.54 | 406.98 | 251.94 | 133.62 | 72.42 | 12.24 | 127.5 | 220.32 | 315.18
 | 7 | 2.08 | 2.6 | 342.72 | 267.24 | 127.5 | 272.34 | 342.72 | 223.38 | 88.74 | 118.32 | 69.36 | 230.52 | 25.5 | 180.54
 | 8 | 2.09 | 2.6125 | 114.24 | 353.94 | 119.34 | 130.56 | 114.24 | 389.64 | 114.24 | 218.28 | 60.18 | 199.92 | 57.12 | 145.86
 | 9 | 3.02 | 3.775 | 144.84 | 246.84 | 330.48 | 52.02 | 144.84 | 119.34 | 297.84 | 115.26 | 75.48 | 286.62 | 206.04 | 302.94
 | 10 | 3.99992 | 4.9999 | 181.56 | 232.56 | 4.08 | 241.74 | 181.56 | 268.26 | 336.6 | 341.7 | 132.6 | 361.08 | 174.42 | 41.82
 | 11 | 4.8 | 6 | 13.26 | 335.58 | 330.48 | 266.22 | 13.26 | 295.8 | 145.86 | 273.36 | 359.04 | 324.36 | 343.74 | 282.54
 | 12 | 1.12 | 1.4 | 9.18 | 205.02 | 381.48 | 404.94 | 9.18 | 150.96 | 211.14 | 355.98 | 95.88 | 315.18 | 308.04 | 194.82
 | 313 | 1.24 | 1.55 | 211.14 | 391.68 | 201.96 | 181.56 | 211.14 | 94.86 | 222.36 | 401.88 | 378.42 | 277.44 | 393.72 | 142.8
 | 14 | 1.4 | 1.75 | 196.86 | 233.58 | 184.62 | 162.18 | 196.86 | 376.38 | 190.74 | 59.16 | 327.42 | 86.7 | 253.98 | 129.54
 | 15 | 1.44 | 1.8 | 220.32 | 82.62 | 297.84 | 10.2 | 220.32 | 325.38 | 286.62 | 97.92 | 112.2 | 263.16 | 361.08 | 51
 | 16 | 3.2 | 4 | 328.44 | 130.56 | 40.8 | 237.66 | 328.44 | 252.96 | 100.98 | 170.34 | 66.3 | 113.22 | 358.02 | 265.2
 | 17 | 1.24 | 1.55 | 16.32 | 68.34 | 279.48 | 65.28 | 16.32 | 38.76 | 253.98 | 153 | 337.62 | 380.46 | 4.08 | 401.88
 | 18 | 1.68 | 2.1 | 237.66 | 85.68 | 345.78 | 311.1 | 237.66 | 113.22 | 394.74 | 48.96 | 110.16 | 76.5 | 133.62 | 14.28
 | 19 | 1.8 | 2.25 | 376.38 | 220.32 | 200.94 | 118.32 | 376.38 | 25.5 | 311.1 | 27.54 | 109.14 | 19.38 | 21.42 | 403.92
 | 20 | 1.96 | 2.45 | 168.3 | 215.22 | 218.28 | 6.12 | 168.3 | 337.62 | 310.08 | 336.6 | 393.72 | 100.98 | 345.78 | 72.42
 | 21 | 2.04 | 2.55 | 240.72 | 75.48 | 311.1 | 255 | 240.72 | 106.08 | 215.22 | 261.12 | 67.32000000000001 | 363.12 | 121.38 | 123.42
 | 22 | 1.68 | 2.1 | 139.74 | 20.4 | 137.7 | 332.52 | 139.74 | 323.34 | 385.56 | 134.64 | 273.36 | 71.4 | 387.6 | 227.46
 | 23 | 3.4 | 4.25 | 216.24 | 17.34 | 81.6 | 34.68 | 216.24 | 345.78 | 231.54 | 60.18 | 302.94 | 156.06 | 164.22 | 395.76
Spreadsheet: 875748d1722353897-search-formula-not-working-sample-workbook
Sheet: SEARCH

 | VARNISH
SAGEID | VENDOR | GL_ACCOUNT | INVOICE_DESCRIPTION | ORGANIZATION_UNIT | [NAME] | PAYMEN T | COMMENTS | PORTAL | USERNAM E | PASSWORD | INV_NO.
Spreadsheet: sally_beck__34369__FallonDelaneyrpt
Sheet: Pickering

Retain Pickering
GIS ID | Formatted Name | Company Name | Job Title | [NAME] | Level1 Full Name | Level2 [NAME] | Level3 [NAME] | Level4 [NAME] | Company | BU Supported: EGM, EIM, EBS, EES or ENA
90104733 | PICKERING, MARK R | ENRON NET WORKS LLC(CNEN) | CHIEF TECHNOLOGY OFFICER | PIPER, GREGORY F | WHALLEY, [NAME] | PIPER, GREGORY | PICKERING, MARK |  | Estate
90006380 | COSTELLO, LISA A | ENRON NET WORKS LLC(CNEN) | COORD ADMIN | PICKERING, MARK R | WHALLEY, [NAME] | PIPER, GREGORY | PICKERING, MARK | COSTELLO, LISA | Estate
 |  |  |  | 2
Spreadsheet: 474094d1470642676-vlookup-and-sum-based-on-a-criteria-test2
Sheet: Index

Company | Select Month
J | 2015-07-01 00:00:00 | 1
C | 2015-08-01 00:00:00 | 2
 | 2015-09-01 00:00:00 | 3
 | 2015-10-01 00:00:00 | 4
 | 2015-11-01 00:00:00 | 5
 | 2015-12-01 00:00:00 | 6
 | 2016-01-01 00:00:00 | 7
 | 2016-02-01 00:00:00 | 8
 | 2016-03-01 00:00:00 | 9
 | 2016-04-01 00:00:00 | 10
 | 2016-05-01 00:00:00 | 11
 | 2016-06-01 00:00:00 | 12
Spreadsheet: 36677d1234542855-pivoting-text-test
Sheet: Data1

Part Number | Competitor No | [NAME]
Part1 | CompPart1 | XRef1
Part2 | [NAME] | XRef2
Part3 | CompPart3 | XRef3
Part4 | [NAME] | XRef4
Part5 | CompPart5 | XRef5
Part6 | [NAME] | XRef6
Part7 | CompPart7 | XRef7
Part8 | CompPart8 | XRef8
Part9 | CompPart9 | XRef9
Part10 | CompPart10 | XRef10
Part11 | CompPart11 | XRef11
Part12 | CompPart12 | XRef12
Part13 | CompPart13 | XRef13
Part14 | CompPart14 | [NAME]
Part15 | CompPart15 | XRef15
Part16 | CompPart16 | XRef16
Part17 | CompPart17 | XRef17
Part18 | CompPart18 | XRef18
Part19 | CompPart19 | XRef19
Spreadsheet: 64257d1265132910-search-tabs-and-return-results-kc-environmental-aspects-and-impacts-worksheet-questions
Sheet: Process - Activity 13

Operating Condition | Process Evaluated |  | Date |  |  |  |  | Team
 | Aspect | Impact | NR | RD | KC | L&R | Total Score | Significant? | Objective and Target? | Operational Controls
Normal | Polymer [NAME] | Resource Preservation | 3 | 3 | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
Spreadsheet: 156100d1337179168-page-break-preview-vs-print-preview-do-not-match-help
Sheet: Particle Size Table For Report

EFFECTIVE |  | Mass (mg) obtained on different stages of cascade impactor (a) |  |  |  | study xxxxxx
CUTOFF DIA. |  |  | xxx mg/L Exposure on xxxxx
µm |  | Mean (b) | Sample A | Sample B
17
11
6.1
3
1.3
0.68
0.45
SUM
EFFECTIVE |  | Cumulative Percent of Aerosol Particles Less Than Stated Size
CUTOFF DIA.
µm |  | Mean (c) | Sample A | Sample B
17
11
6.1
3
1.3
0.68
MMAD (µm) (d)
SIGMA G (d)
a The samples were obtained at a flow rate of 3 l/minute for 3 minutes at 22 and 370 minutes into the exposure
for samples A and B, respectively.
b Mean of samples A and B.
c Percent calculated using the 8.40 mg mean.
d The MMAD was calculated by converting the cumulative percentages to probit values and performing a interpolation of
log particle size vs. probit value.  The MMAD is equivalent to a probit of 5, and the geometric standard
deviation is equal to (Probit 6/Probit 4)0.5
Spreadsheet: 159107d1338495839-nesting-formulas-weekly-sales1
Sheet: ASHFORD

 | ASHFORD
ref | clientname | wk1 | wk2 | wk3 | wk4 | wk5 | wk6 | wk7 | wk8 | wk9 | wk10 | wk11 | wk12 | wk13 | wk14 | [NAME] | wk16 | wk17 | wk18 | wk19 | wk20 | wk21 | wk22 | wk23 | wk24 | wk25 | wk26 | wk27 | wk28 | wk29 | wk30 | wk31 | wk32 | wk33 | wk34 | [NAME] | wk36 | wk37 | wk38 | wk39 | wk40 | wk41 | wk42 | wk43 | [NAME] | wk45 | wk46 | wk47 | wk48 | wk49 | wk50 | wk51 | wk52 | wk53
AHARVE | 1 HARVEST WAY |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AOWENM | 8 ADMIRALTY MEWS
AABBEY | ABBEY LODGE RESIDENTIAL HOME
AACACI | ACACIA HOUSE NURSING HOME
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: fb5de3e9-54b9-463b-b41b-b250348123f6
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
EBVA | Test | EBVA | [NAME] (EBV), IgA, Serum | [NAME] (EBV), IgA, S | Immunofluorescence Assay (IFA) | Serum Gel Tube: SGT |  |  | 0.2 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.2 mL | 0.15 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | <1:10 | Wednesday; 9 a.m. | 1 day | 7 days | 1 | 86665 |  |  |  |  | Rochester
EBVA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EBVA | Result | 8891 | [NAME] (EBV), IgA, S | [NAME] (EBV), IgA, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 716295d1612163820-how-to-organise-multiple-reference-data-to-use-in-invoice-template-q-invoices
Sheet: Sheet1

Current referenc sheet for working out invoices: |  | PAYER | [NAME] | ITEM CODE | ITEM RATE | GST | PAYEE EMAIL
 |  | Payer 1 | Description 1 | a | 1 | N | [EMAIL] |  | What's working well with current set-up | 1) Description drop-down list is limited to the descriptions associated with the payer (no irrelevant items displayed)
 |  | Payer 1 | Description 3 | b | 2 | N | [EMAIL] |  |  | 2) Item code and item rate is automatically inserted based on payer and description
 |  | Payer 1 | Description 4 | a | 1 | N | [EMAIL]
 |  | Payer 1 | Description 6 | a | 2 | Y | [EMAIL]
 |  | Payer 2 | Description 2 | b | 1 | N | [EMAIL]
 |  | Payer 2 | Description 3 | a | 2 | N | [EMAIL]
 |  | Payer 2 | Description 6 | a | 12 | N | [EMAIL]
 |  | Payer 3 | Description 2 | b | 12 | Y | [EMAIL] |  | Issues with current setup | Reference table will become huge and very time conduming to add a row for each possible description (may be up to 50 descriptos) that they may pay for and to do repeat this for each individual payer (which is a limitless number)
 |  | Payer 3 | Description 3 | a | 2 | N | [EMAIL]
 |  | Payer 3 | Description 6 | a | 1 | N | [EMAIL]
 |  | Payer 4 | Description 2 | b | 1 | N | [EMAIL] |  | Solutions | Is there another way of organising the reference table to gather all this information. Have a list for payers and a list of all description codes and somehow link the relevant decription and payer and rate together???
 |  | Payer 4 | Description 3 | a | 2 | Y | [EMAIL]
 |  | Payer 4 | Description 6 | a | 1 | N | [EMAIL]
 |  | Payer 5 | Description 2 | b | 2 | N | [EMAIL]
 |  | Payer 5 | Description 3 | a | 1 | N | [EMAIL]
 |  | Payer 5 | Description 6 | a | 2 | Y | [EMAIL]
 |  | Payer 6 | Description 1 | b | 1 | N | [EMAIL]
Scroll down for example invoice |  | Payer 6 | Description 5 | a | 2 | N | [EMAIL]
 |  | Payer 6 | Description 6 | a | 1 | N | [EMAIL]
 |  | Payer 7 | Description 1 | b | 2 | Y | [EMAIL]
 |  | Payer 7 | Description 3 | a | 1 | N | [EMAIL]
 |  | Payer 7 | Description 5 | a | 2 | N | [EMAIL]
 |  | Payer 7 | Description 6 | b | 1 | N | [EMAIL]
 |  | Payer 8 | Description 2 | a | 2 | Y | [EMAIL]
 |  | Payer 8 | Description 3 | b | 1 | N | [EMAIL]
 |  | …
 |  | Payer50 | ...Decription 50
Where I currently use above data in invoice |  | Service Delivery Date | ITEM CODE | Description | Unit Qty (item/Hr) | Unit price | Net | GST | Line Total
 |  | manually entered | use index & match to automatically update | Dropdown box limited to decsription linked with payer (i.e. Payer 1 has 4 options, [NAME] has 3 options) | manually entered | use index & match to automatically update | In row formula | use index & match to automatically update | In row formula
Spreadsheet: 856376d1705629943-require-formula-to-search-multiple-keywords-with-a-match-outputing-the-associated-category-banking-for-help-forum_jasontaylor1985
Sheet: for help forum

Transactions | Category |  | Keywords | Transaction Type
Direct Debit QBE Insurance |  |  | alinta energy | Utilities
BWS LIQUOR 5029 GLENELG AU AUS Card xx7405 Value Date: 06/04/2023 |  |  | amazon | Shopping
WOOLWORTHS 5798 BRIGHTON AU AUS Card xx7405 Value Date: 06/04/2023 |  |  | amphol | Petrol
JUST THE THING PRE-L BEVERLEY SA AUS Card xx7405 Value Date: 06/04/2023 |  |  | anaconda | Shopping
LEISURELY COFFEE ADELAIDE SA AUS Card xx7405 Value Date: 06/04/2023 |  |  | APPLE.COM/BILL | Utilities
Prince [NAME] Fulham Garden AU AUS Card xx7405 Value Date: 06/04/2023 |  |  | battery world | Cars
5 STAR BARBER AND HA GLENELG SA AUS Card xx7405 Value Date: 06/04/2023 |  |  | [NAME] | Eat Out / takeaway
CARIFY VEHICLE HISTORY LIDCOMBE NS AUS Card xx7405 Value Date: 08/04/2023 |  |  | body fit | Gym
BOUNCE HOLDINGS AUSTRA GLEN IRIS AUS Card xx7405 Value Date: 09/04/2023 |  |  | boxing room | Gym
BRIGHTON JETTY BAKER BRIGHTON SA AUS Card xx7306 Value Date: 10/04/2023 |  |  | BP | Petrol
COLES 0458 OAKLANDS PARKAU |  |  | bunnings | Shopping
LEISURELY COFFEE ADELAIDE AU |  |  | bws | Liquor
ADELAIDE METRO ADELAIDE AUS Card xx7405 Value Date: 11/04/2023 |  |  | car wash | Cars
BWS LIQUOR 5029 GLENELG AU AUS Card xx7306 Value Date: 11/04/2023 |  |  | coles | Groceries
WOOLWORTHS 5311 GLENELG AU AUS Card xx7306 Value Date: 11/04/2023 |  |  | cotton on | Shopping
Dominos Estore Glenelg dominos.com.a AU AUS Card xx7306 Value Date: 11/04/2023 |  |  | direct debit | Utilities
KMART 1005 KURRALTA PARK AU AUS Card xx7306 Value Date: 11/04/2023 |  |  | dominos | Eat Out / takeaway
KMART 1151 OAKLANDS PARK AU AUS Card xx7306 Value Date: 11/04/2023 |  |  | electric | Utilities
Royal Copenhagen BRIGHTON AU |  |  | f45 | Gym
[NAME] |  |  | garage | Cars
WOOLWORTHS 5798 BRIGHTON AU AUS Card xx7306 Value Date: 12/04/2023 |  |  | gas | Utilities
ZLR*Burgertec Torrensvi Torrensville AU |  |  | giff gaff | Utilities
SQ *BLUE BIRD BAKERY Brighton AU |  |  | hair | Shopping
APPLE.COM/BILL |  |  | kmart | Shopping
 |  |  | [NAME] | Liquor
 |  |  | metrolink | Parking / travel
 |  |  | more telecom | Utilities
 |  |  | nails | Shopping
 |  |  | netflix | Utilities
 |  |  | OTR | Petrol
 |  |  | Packham Property Management | Rent
 |  |  | [NAME] | Pub
 |  |  | rebel | Shopping
 |  |  | [NAME] | Salary
 |  |  | sportsgirl | Shopping
 |  |  | super cheap | Cars
 |  |  | target | Shopping
 |  |  | tyres | Cars
 |  |  | upark | Parking / travel
 |  |  | water | Utilities
 |  |  | wdl atm | Cash withdrawal
 |  |  | woolworths | Groceries
 |  |  | zurich | Utilities
You can use the following formula in cell B2 to search for keywords from column D in each cell of column A and return the corresponding category from column E:
Make sure to adjust the range $E$2:$E$10 to match the range of categories in column E, and adjust the range $D$2:$D$10 to match the range of keywords in column D.
Here's how the formula works:
`COUNTIF(A2, "*" & $D$2:$D$10 &
Spreadsheet: bill_williams_iii__1399__xxxdealenterySeptember
Sheet: 9-13

Thursday
Deal #s | 772238 |  | 772248 | 772251 | 772252 | 772258
2001-09-13 00:00:00 |  |  | NP | SP | SP | NP
Delivery Pt. | EPMI CA Pool |  | Sale | Sale | Buy | Sale
Counterparty | NP | SP | EES | EES | EES | Ca imbal
Totals | -4128 | 4128 | -5840 | -1224 | 3664 | -200
1 | -181 | 181 | -290 | -153 |  | -25
2 | -181 | 181 | -290 | -153 |  | -25
3 | -181 | 181 | -290 | -153 |  | -25
4 | -181 | 181 | -290 | -153 |  | -25
5 | -181 | 181 | -290 | -153 |  | -25
6 | -181 | 181 | -290 | -153 |  | -25
7 | -155 | 155 | -220 |  | 229
8 | -155 | 155 | -220 |  | 229
9 | -155 | 155 | -220 |  | 229
10 | -155 | 155 | -220 |  | 229
11 | -155 | 155 | -220 |  | 229
12 | -155 | 155 | -220 |  | 229
13 | -155 | 155 | -220 |  | 229
14 | -155 | 155 | -220 |  | 229
15 | -155 | 155 | -220 |  | 229
16 | -155 | 155 | -220 |  | 229
17 | -155 | 155 | -220 |  | 229
18 | -155 | 155 | -220 |  | 229
19 | -155 | 155 | -220 |  | 229
20 | -155 | 155 | -220 |  | 229
21 | -155 | 155 | -220 |  | 229
22 | -155 | 155 | -220 |  | 229
23 | -181 | 181 | -290 | -153 |  | -25
24 | -181 | 181 | -290 | -153 |  | -25
TIE POINTS