tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 123705d1317818628-formula-for-small-theatre-seating-plan-copy-of-copy-of-seating-plan-sample-1-1
Sheet: Sheet1

2010/11 | Hon/Patron | 2009/10 | 2008/09 | 2007/08 | 2006/07 | 2005/06 | 2004/05 | 2003/04 | 2002/03 | 2001/02 | 2000/01 | TITLE/STYLE | NAME
 |  |  |  |  | 926 |  |  |  |  |  |  | [NAME] | A'Bear
99 |  | 255 | 112 | 763 | 518 | 233 | 105 | 161 | 387 | 500 | 212 | [NAME] | Adams
756 |  | 498 | 485 | 525 | 193 | 647 | 642 | 751 | 322 |  |  | [NAME] | Adams
729 |  | 931 |  |  |  |  |  |  |  |  |  | [NAME] | Adams
299 |  | 102 | 296 | 99 | 533 | 375 | 603 | 902 | 290 | 848 |  | Mr E. | Adlington
 |  |  |  |  |  | 520 |  |  |  |  |  | [NAME] | Agar
 |  | 628 | 735 | 865 | 487 | 334 | 614 | 639 | 526 | 711 |  | [NAME] | Akers
 |  |  | 730 | 274 | 739 | 847 |  |  |  |  |  | Mr R. | Aldred
 |  |  | 731 | 275 | 740 | 846 |  |  |  |  |  | Mrs R | Aldred
 |  |  | 226 |  |  |  |  |  |  |  |  | [NAME] | [NAME]
186 |  | 555 | 273 | 734 | 516 | 594 | 280 | 352 | 583 | 775 | 397 | Mr W. | [NAME]
187 |  | 556 | 274 | 735 | 517 | 595 | 281 | 353 | 584 | 776 | 398 | [NAME] | [NAME]
 |  |  | N/J | 377 | 690 | 538 | 473 | 629 | 740 | 475 | 913 | Mr D. | [NAME]
 |  |  | N/J | 378 | 691 | 539 | 472 | 630 | 741 | 476 | 914 | [NAME] | [NAME]
 |  |  |  |  |  |  | 816 | 293 | 123 |  | 242 | Mr E. | [NAME]
 |  |  |  |  |  |  | 817 | 294 | 124 |  | 243 | [NAME] | [NAME]
Spreadsheet: 818338d1676746132-dynamic-formula-to-copy-the-data-from-one-sheet-to-another-in-a-table-example-02
Sheet: Sheet - 01

Go to Sheet - 01 sheet to understand the question
Employee ID | Business | Hire Date | [NAME] | Area | Operating Region | Business Unit | Cost Center | Company Code | Company_Code_Desc | Primary_Industry_Desc
199034590 | ABC | 2016-03-29 00:00:00 | 1 | GHI | PQR | GHI | JKL | GHI | PQR | GHI
199034589 | DEF | 2010-02-18 00:00:00 | 0 | JKL | STU | JKL | MNO | JKL | STU | JKL
199034591 | GHI | 2018-05-22 00:00:00 | 0 | MNO | JKL | MNO | ABC | MNO | JKL | MNO
199034594 | JKL | 2015-02-19 00:00:00 | 1 | PQR | MNO | ABC | MNO | PQR | MNO | ABC
199034596 | MNO | 2011-04-28 00:00:00 | 0 | STU | MNO | MNO | JKL | MNO | MNO | JKL
199034599 | PQR | 2017-02-20 00:00:00 | 2 | ABC | STU | PQR | MNO | STU | PQR | MNO
199056767 | STU | 2019-03-21 00:00:00 | 1 | DEF | ABC | STU | DEF | ABC | DEF | PQR
Spreadsheet: 38835d1236968343-help-with-averaging-formula-average-test-workbook
Sheet: Feb 

 |  |  | Date & Time | Date & Time | Ordered To Complete | Date & Time | Date & Time
 |  |  | Ordered | Completed | Days Hours & Minutes | Ordered | Ordered
 |  |  | 2009-02-02 12:15:00 | 2009-02-02 15:47:00 |  | 2009-02-02 19:18:59.995000 | 2009-02-02 19:18:59.995000
 |  |  | 2009-02-02 11:45:00 | 2009-02-02 15:15:00 |  | 2009-02-02 18:44:59.990000 | 2009-02-02 18:44:59.990000
 |  |  | 2009-01-31 13:15:00 | 2009-02-02 11:31:00 |  | 2009-02-04 09:46:59.990000 | 2009-02-04 09:46:59.990000
 |  |  | 2009-02-02 05:15:00 | 2009-02-02 13:44:00 |  | 2009-02-02 22:13:00 | 2009-02-02 22:13:00
 |  |  | 2009-02-02 17:00:00 | 2009-02-02 17:11:00 |  | 2009-02-02 17:21:59.990000 | 2009-02-02 17:21:59.990000
 |  |  | 2009-02-01 06:45:00 | 2009-02-02 10:55:00 |  | 2009-02-03 15:04:59.990000 | 2009-02-03 15:04:59.990000
 |  |  | 2009-02-02 02:00:00 | 2009-02-02 15:06:00 |  | 2009-02-03 04:11:59.990000 | 2009-02-03 04:11:59.990000
 |  |  | 2009-02-01 09:30:00 | 2009-02-02 12:05:00 |  | 2009-02-03 14:39:59.990000 | 2009-02-03 14:39:59.990000
 |  |  | 2009-02-02 13:00:00 | 2009-02-02 14:22:00 |  | 2009-02-02 15:44:00.005000 | 2009-02-02 15:44:00.005000
 |  |  | 2009-02-01 10:00:00 | 2009-02-02 09:56:00 |  | 2009-02-03 09:52:00.005000 | 2009-02-03 09:52:00.005000
 |  |  | 2009-01-31 10:45:00 | 2009-02-02 16:04:00 |  | 2009-02-04 21:22:59.995000 | 2009-02-04 21:22:59.995000
 |  |  | 2009-02-01 05:00:00 | 2009-02-02 11:22:00 |  | 2009-02-03 17:44:00 | 2009-02-03 17:44:00
 |  |  | 2009-02-02 04:15:00 | 2009-02-02 09:23:00 |  | 2009-02-02 14:31:00 | 2009-02-02 14:31:00
 |  |  | 2009-01-31 01:15:00 | 2009-02-02 10:39:00 |  | 2009-02-04 20:02:59.990000 | 2009-02-04 20:02:59.990000
 |  |  | 2009-01-31 18:00:00 | 2009-02-02 13:30:00 |  | 2009-02-04 09:00:00 | 2009-02-04 09:00:00
 |  |  | 2009-02-02 12:00:00 | 2009-02-02 15:14:00 |  | 2009-02-02 18:28:00 | 2009-02-02 18:28:00
 |  |  | 2009-01-30 15:30:00 | 2009-02-02 13:52:00 |  | 2009-02-05 12:13:59.990000 | 2009-02-05 12:13:59.990000
 |  |  | 2009-01-31 16:30:00 | 2009-02-02 11:28:00 |  | 2009-02-04 06:26:00 | 2009-02-04 06:26:00
 |  |  | 2009-01-31 11:15:00 | 2009-02-02 13:37:00 |  | 2009-02-04 15:59:00 | 2009-02-04 15:59:00
Spreadsheet: chris_dorland__1612__Forwards Detail-ZARGON_JAN17
Sheet: Pivot

Sum of Value
Deal Num | Period | Total
(blank) | (blank)
(blank) Total
Y16576.1 | 01-APR-2002 | -33076.1675
 | 01-AUG-2002 | -22248.6733
 | 01-JUL-2002 | -24449.1668
 | 01-JUN-2002 | -27117.246
 | 01-MAY-2002 | -30905.2559
 | 01-OCT-2002 | -19982.3583
 | 01-SEP-2002 | -21448.3183
Y16576.1 Total |  | -179227.1861
Y39286.1 | 01-APR-2002 | -30686.3638
 | 01-AUG-2002 | -19796.6792
 | 01-JUL-2002 | -21992.5774
 | 01-JUN-2002 | -24735.7104
 | 01-MAY-2002 | -28439.9345
 | 01-OCT-2002 | -17539.7766
 | 01-SEP-2002 | -19079.9273
Y39286.1 Total |  | -162270.9692
Grand Total |  | -341498.1553
Spreadsheet: d85cbe96-aa83-4b17-9225-49d5f4fb7cb9
Sheet: Sheet1

Alcohol-Induced Deaths by Year, Maine, 1999-2009 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Year | Number of Deaths | Crude Rate |  | Age-adjusted Rate
 |  | Rate | 95% CI | Rate | 95% CI
1999 | 106 | 8.4 | 6.8 - 10 | 7.7 | 6.2-9.2
2000 | 97 | 7.6 | 6.2 - 9.3 | 6.9 | 5.6-8.5
2001 | 94 | 7.3 | 5.9 - 9.0 | 6.5 | 5.3-8.0
2002 | 101 | 7.8 | 6.3 - 9.3 | 7 | 5.6-8.3
2003 | 117 | 9 | 7.3 - 10.6 | 7.7 | 6.3-9.1
2004 | 106 | 8 | 6.5 - 9.6 | 6.8 | 5.5-8.1
2005 | 131 | 9.9 | 8.2 - 11.6 | 8.1 | 6.7-9.5
2006 | 114 | 8.6 | 7.0 - 10.2 | 7.4 | 6.0-8.8
2007 | 133 | 10.1 | 8.4 - 11.8 | 8.1 | 6.7-9.5
2008 | 99 | 7.5 | 6.1 - 9.2 | 6.1 | 5.0-7.5
2009 | 133 | 10.1 | 8.4 - 11.8 | 8.4 | 6.9-9.9
Data Source: Centers for Disease Control and Prevention, National Center for Health Statistics. Underlying Cause of Death 1999-2009 on CDC WONDER Online Database, released 2012 Program, [NAME].
Alcohol-Induced Deaths: Deaths with alcohol-induced causes as the underlying cause of death.
Alcohol-Induced causes: ICD-10 codes: E24.4, [NAME], G31.2, G62.1, G72.1, I42.6, K29.2, K70, K85.2, K86.0, R78.0,X45, X65, and Y15.
Crude rates are deaths  per 100,000 population
Age-adjusted rates are deaths per 100,000 population age-adjusted to the U.S. 2000 standard population
95% CI: 95% confidence interval of the rate.
Spreadsheet: 220039d1363038663-counting-days-formula-formulas
Sheet: Pepe's Version (Formula1)

Date 1 | 2012-07-27 00:00:00
2012-06-17 00:00:00 |  | Doubt: B1-A2 gives me the same number if "counting the number of days from 27th of July to the 17th of June? Is the same using DAYS360 formula? |  | SEEMS WORKING!!!
2012-06-18 00:00:00 |  |  |  | SEEMS WORKING!!!
2012-06-19 00:00:00 |  |  |  | SEEMS WORKING!!!
2012-06-20 00:00:00 |  |  |  | SEEMS WORKING!!!
2012-06-21 00:00:00 |  |  |  | SEEMS WORKING!!!
2012-06-22 00:00:00 |  |  |  | SEEMS WORKING!!!
2012-07-08 00:00:00 |  |  |  | SEEMS WORKING!!!
2012-07-09 00:00:00 |  |  |  | SEEMS WORKING!!!
2012-07-10 00:00:00 |  |  |  | SEEMS WORKING!!!
2012-07-11 00:00:00 |  |  |  | SEEMS WORKING!!!
Spreadsheet: 146786d1332349433-find-value-in-one-column-and-return-another-value-in-the-same-row-to-another-cell-help-excel
Sheet: Sheet1

Location | Employee name | Employee number |  |  |  |  | Name | Location | Employee number | Sales
London | [NAME] | 33 |  |  |  |  | [NAME] | Dublin | 77 | 230
Dublin | [NAME] | 77 |  |  |  | Here | [NAME] | Dublin | 1 | 200
Dublin | [NAME] | 1
New York | [NAME] | 400
London | [NAME] | 24 |  |  |  |  |  | Location | Employee number | Sales
 |  |  |  |  |  |  | [NAME] | London | 33 | 450
 |  |  |  |  |  |  |  |  | 24 | 25
 |  |  |  |  |  |  |  | Location | Employee number | Sales
 |  |  |  |  |  |  | [NAME] | New York | 400 | 260
 | I need to get these names
 | I cant use [NAME], I know that this will work with some [NAME] formula, but I can't get it to work.
 | Please help!
 | BR / Christofer
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 13c

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche / Index | 3834461 | 8389051 | 1107802 | 2321552
Asia | 0 | 174706 | 0 | 48016
Europe | 1638791 | 4233773 | 541854 | 1015975
North America | 2173116 | 3600771 | 561029 | 1202391
Other | 22554 | 379801 | 4919 | 55170
Other | 0 | 1094217 | 0 | 500375
Exotic/Total Return Swap | 0 | 56301 | 0 | 31389
Swaptions | 0 | 1037916 | 0 | 468986
TOTAL | 3834461 | 9483268 | 1107802 | 2821927
Spreadsheet: 44534d1243302323-auto-allocate-pallet-numbers-test
Sheet: Sheet1

 |  | Purchase Order Number | Part Number | Carton Quantity | Pallet Number
 |  | 540262 | ZAR-B089A01B43 | 1 | 1
 |  | 540262 | ZV43-T33J09P | 1 | 1
 |  | 540262 | 701-294 | 7 | 2
 |  | 540262 | 701-291 | 20 | 3
 |  | 540262 | 701-896 | 8 | 4
 |  | 540262 | 700-693 | 8 | 5
 |  | 540262 | 700-902 | 4 | 1
 |  | 540262 | 700-947 | 8 | 6
 |  | 540262 | 700-993 | 7 | 7
 |  | 540262 | 700-957 | 12 | 8
 |  | 540262 | 701-004 | 4 | 1
 |  | 540262 | 701-039 | 6 | 9
 |  | 540262 | 700-907 | 2 | 1
 |  | 540262 | 700-953 | 2 | 1
 |  | 540262 | 701-319 | 39 | 10
 |  | 540902 | ZAR-B089A01B43 | 1 | 11
 |  | 540902 | 700-993 | 4 | 11
 |  | 540902 | 700-957 | 2 | 11
 |  | 540902 | 701-004 | 9 | 12
 |  | 540902 | 702-597 | 3 | 11
 |  | 540902 | 701-354 | 10 | 13
Spreadsheet: 800591d1665748909-sumifs-combined-with-index-match-book6
Sheet: Sheet1

 |  |  |  |  |  |  |  | SOLUTION
 |  | A | B | C | A | B |  |  | A | B | C
 | 2022-01-01 00:00:00 | 1 | 2 | 3 | 4 | 5 |  | 2022-01-01 00:00:00 | 5 | 7 | 3
 | 2022-02-01 00:00:00 | 1 | 2 | 3 | 4 | 5 |  | 2022-02-01 00:00:00 | 5 | 7 | 3
 | 2022-03-01 00:00:00 | 1 | 2 | 3 | 4 | 5 |  | 2022-03-01 00:00:00 | 5 | 7 | 3
 | 2022-04-01 00:00:00 | 1 | 2 | 3 | 4 | 5 |  | 2022-04-01 00:00:00 | 5 | 7 | 3
 | 2022-05-01 00:00:00 | 1 | 2 | 3 | 4 | 5 |  | 2022-05-01 00:00:00 | 5 | 7 | 3
 | 2022-06-01 00:00:00 | 1 | 2 | 3 | 4 | 5 |  | 2022-06-01 00:00:00 | 5 | 7 | 3
 | 2022-07-01 00:00:00 | 1 | 2 | 3 | 4 | 5 |  | 2022-07-01 00:00:00 | 5 | 7 | 3
 | 2022-08-01 00:00:00 | 1 | 2 | 3 | 4 | 5 |  | 2022-08-01 00:00:00 | 5 | 7 | 3
 | 2022-09-01 00:00:00 | 1 | 2 | 3 | 4 | 5 |  | 2022-09-01 00:00:00 | 5 | 7 | 3
Spreadsheet: 128178d1320839833-excel-2007-looking-up-a-min-value-based-on-input-forum1
Sheet: Sheet1

 | Sales | A | B | C | D | E | F | G | H | I
KM |  | Rate in €, ex fuel | Rate in €, ex fuel | Rate in €, ex fuel | Rate in €, ex fuel | Rate in €, ex fuel | Rate in €, ex fuel | Rate in €, incl fuel | Rate in €, ex fuel | Rate in €, ex fuel
0-19 |  | 1100 | 1050 | 1075 | 900 | 980 | 940 | 932 | 1098 | 1100
20-39 |  | 2300 | 2100 | 1928 | 2938 | 2029 | 2080 | 2100 | 2300 | 2200
40-59 |  | 3000 | 3100 | 3090 | 3000 | 3400 | 3900 | 3840 | 3100 | 2100
60-79
80-99
100-119
120-139
140-159
160-179
180-199
200-219
220-239
240-259
260-279
280-299
300-319
320-339
340-359
360-379
380-399
400-419
420-439
440-459
460-479
480-499
500-519
520-539
540-559
560-579
580-599
600-619
620-639
640-659
660-679
680-699
700-719
720-739
740-759
760-779
780-799
800-819
820-839
840-859
860-879
880-899
900-919
920-939
940-959
960-979
980-999
>1000
 |  |  |  |  |  |  |  | 5400 | 5400
 |  |  |  | MIN | DRIVER
Spreadsheet: 112953d1308918920-league-table-spreadsheet-help-football-stats-current-
Sheet: Thursdays

 | Rank |  |  |  | Played | Won | [NAME] | Lost |  | Points |  | Win Average |  |  |  | * 2 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-06-02 00:00:00 | 2011-06-09 00:00:00 | 2011-06-16 00:00:00 | 2011-06-23 00:00:00
 | 1 |  | [NAME] |  | 4 | 2 | 2 | 0 |  | 12 |  | 0.5 |  | W | W | d | D
 | 1 |  | [NAME] |  | 4 | 2 | 2 | 0 |  | 12 |  | 0.5 |  | W | W | D | D
 | 3 |  | [NAME] |  | 4 | 1 | 2 | 1 |  | 9 |  | 0.25 |  | L | W | D | d
 | 3 |  | [NAME] |  | 4 | 1 | 2 | 1 |  | 9 |  | 0.25 |  | W | L | d | D
 | 3 |  | [NAME] |  | 4 | 1 | 2 | 1 |  | 9 |  | 0.25 |  | W | L | D | D
 | 6 |  | [NAME] |  | 4 | 0 | 2 | 2 |  | 6 |  | 0 |  | L | L | D | d
 | 6 |  | [NAME] |  | 4 | 0 | 2 | 2 |  | 6 |  | 0 |  | L | L | d | d
 | 8 |  | Adam |  | 3 | 0 | 2 | 1 |  | 5 |  | 0 |  | L |  | d | d
 | 9 |  | [NAME] |  | 2 | 0 | 2 | 0 |  | 4 |  | 0 |  |  |  | d | d
 | 9 |  | [NAME] |  | 1 | 1 | 0 | 0 |  | 4 |  | 1 |  | W
 | 9 |  | [NAME] |  | 1 | 1 | 0 | 0 |  | 4 |  | 1 |  |  | W
 | 9 |  | Tariq |  | 1 | 1 | 0 | 0 |  | 4 |  | 1 |  |  | W
 | 13 |  | [NAME] |  | 2 | 0 | 1 | 1 |  | 3 |  | 0 |  | L |  | d
 | 13 |  | Olly |  | 2 | 0 | 1 | 1 |  | 3 |  | 0 |  |  | L | D
 | 15 |  | Mark |  | 1 | 0 | 1 | 0 |  | 2 |  | 0 |  |  |  |  | d
 | 15 |  | Martin |  | 1 | 0 | 1 | 0 |  | 2 |  | 0 |  |  |  |  | D
 | 15 |  | Nich |  | 1 | 0 | 1 | 0 |  | 2 |  | 0 |  |  |  | D
 | 15 |  | [NAME] |  | 1 | 0 | 1 | 0 |  | 2 |  | 0 |  |  |  | D
 | 15 |  | [NAME] |  | 1 | 0 | 1 | 0 |  | 2 |  | 0 |  |  |  |  | D
 |  |  | Notes:
 |  | * | Uneven teams
 |  | 1 | Played on Tuesday
 |  | 2 | No gloves for [NAME]'s team
 |  | 3 | No gloves for other team
 |  |  | Captains in bold
Spreadsheet: 878704d1725960407-excel-time-sheet-needs-to-work-out-hours-but-take-off-30-mins-if-a-break-was-taken-gss-labour-sheet
Sheet: Weekend

Attention: - SUTTI / MARTIN / DANNY |  |  |  | Date-: Sat 7th Sept 2024
[NAME] To :-  AHLMARK SHIPPING (UK) Ltd
Vessel / Job =
*- Crane Driver Always No.1 - If No Crane Driver Ordered Leave No.1 Empty
Men | Name | Start | Finish | Break | Total Hrs | O/T Hrs | [NAME]
1
2 | J SYLVESTER | 06:00:00 | 14:30:00 | y | 8
3 | M [NAME] | 06:00:00 | 14:30:00 |  | 8.5
4 | T SMITH | 06:00:00 | 14:30:00 |  | 8.5
5 | E GRAY | 06:00:00 | 14:30:00 |  | 8.5
6 | N PARKER | 06:00:00 | 14:30:00 |  | 8.5
7 | J SAINSBURY | 06:00:00 | 14:30:00 |  | 8.5
8 | L ZEIMSKI | 06:00:00 | 14:30:00 |  | 8.5
9 | N SHIPLEY | 06:00:00 | 14:30:00 |  | 8.5
10 | S NICHOLLS | 06:00:00 | 14:30:00 |  | 8.5
11 |  |  |  |  | 0
12 |  |  |  |  | 0
13 |  |  |  |  | 0
14 |  |  |  |  | 0
15 |  |  |  |  | 0
16 |  |  |  |  | 0
17 |  |  |  |  | 0
18 |  |  |  |  | 0
19 |  |  |  |  | 0
20 |  |  |  |  | 0
21 |  |  |  |  | 0
22 |  |  |  |  | 0
 | Goole Men Travel | 2
 |  |  |  | Total Hrs | 76
 | Costs For Invoicing
 | [NAME] | 0 |  | 0
 | Stevedores | 76 |  | 1630.2
 | Travel | 2 |  | 20
Please Sign E-Mail Back To:                                                                     [EMAIL]; [EMAIL]; [NAME] |  |  |  | Total | 1650.2
Signed:
Spreadsheet: 877b542f-2777-40f0-b16f-7daff1c08285
Sheet: Sheet1

F/Y 2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Justice of the Peace Authorized Bail Bond Agencies
Bail Bond Agencies | Address | Telephone  Number | Counties | Registered Agents | Authorized Agents to Pick Up Refunds
1st Choice Bail Bonds | 2800 Lancaster Avenue, Suite 4 | [PHONE] | All | [NAME] | [NAME]
 | [NAME], DE  19805
2nd Chance Bail Bonds | 25675 Covert Street |  | Kent | [NAME] | [NAME]
 | Seaford, DE  19973 | [PHONE] | Sussex
A Bail Bond by Resto & Co. | 1200 Northeast Boulevard, Unit B | [PHONE] | All | [NAME], [NAME], [NAME] | [NAME], [NAME], [NAME]
 | [NAME], DE  19802
Above and Beyond Bail Bonds | 94A Quigley Boulevard
 | New Castle, DE  19720-4150 | [PHONE] | All | [NAME] | [NAME]
 |  |  |  | [NAME] | [NAME]
Absolute Bail Bonds | 104 [NAME] | [PHONE] | Kent | [NAME] | [NAME]
 | Milford, DE  19963 |  | Sussex
Ace Bail Bonds | 475 Bowers Beach Road | [PHONE] | Kent | [NAME] | [NAME]
 | Frederica, DE  19946
American Funding Services Corp. | 2062 New Castle Ave, Suite A |  |  | [NAME], [NAME], [NAME], [NAME] | [NAME]
CASH ONLY | New Castle, DE  19720 | [PHONE] | All |  | [NAME]
Axe Bail Bonds | 977 Lochmeath Way
 | Dover, DE  19901 | [PHONE] | All | [NAME] | [NAME]
 |  |  |  | Trinity Goldsborough | Trinity Goldsborough
Bail Bond Agency, Inc. | 102 Larch Avenue, Suite 302 | [PHONE] | All | [NAME] | [NAME]
 | Newport, DE  19804 |  |  | Khyon Church
Bovell Bail Bond, Inc. | 1900 W. 4th Street | [PHONE] | All | [NAME] | [NAME]
 | [NAME], DE  19805 |  |  | [NAME]
Bruny's Bail Bonds | 1927 W. 4th Street | [PHONE] | All | Brunilda Mercado | Brunilda Mercado
 | [NAME], DE  19805
Cutting Edge Bail Bonds, LLC | 315 South State Street
 | Dover, DE  19901 | [PHONE] | All* | [NAME] | [NAME]
 |  |  | *Cannot post in JP 7
Dale's Bail Bonds LLC | 11 E. Market Street, Suite 1 | [PHONE] | Kent | R. [NAME] | R. [NAME]
 | Georgetown, DE  19947 | [PHONE] | Sussex | [NAME] | [NAME]
[NAME], Jr. Bail Bonds | 411 S. Queen Street | [PHONE] | Kent | [NAME], Jr. | [NAME], Jr.
 | Apt. 213
 | Dover, DE  19904
Fast Bail Bonds LLC | 1224 [NAME] | [PHONE] | All* | [NAME] | [NAME]
 | [NAME], DE  19801 |  | *Cannot post in JP 7
Lorenzo's Bail Bonds, Inc. | 5 E. Market Street | [PHONE] | Kent | [NAME] | [NAME]
 | Georgetown, DE  19947 |  | Sussex | [NAME]
No Bars Bail Bonds LLC | 1224 [NAME]
 | [NAME], DE  19801 | [PHONE] | All | [NAME] | [NAME]
Paragon Associates of Delaware | 583 N. Commerce Street | [PHONE] | Kent
 | Townsend, DE  19734 |  | Sussex | [NAME] | [NAME]
T&H Bail Bond, Inc. | 625 [NAME] | [PHONE] | All | [NAME], [NAME], [NAME], [NAME] | [NAME], [NAME], [NAME], [NAME]
 | [NAME], DE  19801
[NAME]'s Bail Bonds, LLC | 424 S. State Street | [PHONE] | Kent | [NAME] | [NAME]
 | Dover, DE  19901
Top Bail Surety, Inc. | 2800 Lancaster Avenue, Suite 4 | [PHONE] | All | [NAME], [NAME] | [NAME]
 | [NAME], DE  19805 |  |  |  | [NAME]
Spreadsheet: 0cf71512-40ea-41d3-8236-c36c263413bf
Sheet: Sheet1

Insulin | [NAME] | Number of Evidences | Evidences
GSK3B | TP53 | 2 | PPI | PPI_low_plus_0.3
PTEN | TP53 | 2 | PPI | PPI_low_plus_0.3
MAPK8 | TP53 | 2 | PPI | PPI_low_plus_0.3
KRAS | HSPD1 | 2 | PPI | PPI_low_plus_0.3
PRKCZ | PRKCA | 2 | KEGG_complexes | PPI
PCK1 | PCK2 | 2 | BiGG_complexes | KEGG_complexes
SRC | ESR1 | 2 | PPI | Corum_complexes
PRKAR2A | WASF1 | 1 | PPI_low_plus_0.3
RPS6 | TUFM | 1 | PPI_low_plus_0.3 | Corum_complexes
YWHAG | ATP5B | 1 | PPI_low_plus_0.3
YWHAG | HSPD1 | 1 | PPI_low_plus_0.3
YWHAG | C1QBP | 1 | PPI_low_plus_0.3
PRKAR2A | AKAP10 | 1 | PPI
PRKAR1A | AKAP10 | 1 | PPI
[NAME] | UCP3 | 1 | PPI
[NAME] | UCP2 | 1 | PPI
INSR | PRKCA | 1 | PPI
AKT1 | MTCP1NB | 1 | PPI
PPP1CA | BCL2L1 | 1 | PPI
[NAME] | TP53 | 1 | PPI
CAPN1 | BID | 1 | PPI
ACACA | BRCA1 | 1 | PPI
MKNK2 | ESR2 | 1 | PPI
GSK3B | DNM1L | 1 | PPI
[NAME] | SCP2 | 1 | PPI
[NAME] | BCL2 | 1 | PPI
PRKACA | BCL2 | 1 | PPI
PRKAR2A | AKAP1 | 1 | PPI
PPP1CA | BCL2 | 1 | PPI
RHOA | TGM2 | 1 | PPI
MAPK8 | BCL2 | 1 | PPI
PRKAR1A | AKAP1 | 1 | PPI
YWHAG | KIF1B | 1 | PPI
CALM2 | ESR2 | 1 | PPI
[NAME] | ESR2 | 1 | PPI
FOXO1 | ESR1 | 1 | PPI
AKT2 | ESR1 | 1 | PPI
RASA1 | DNAJA3 | 1 | PPI
MAPK8 | SH3BP5 | 1 | PPI
MAPK10 | SH3BP5 | 1 | PPI
PPP1CA | TP53 | 1 | PPI
[NAME] | ESR1 | 1 | PPI
PIK3R3 | [NAME] | 1 | KEGG_pathway
AKT2 | [NAME] | 1 | KEGG_pathway
MAPK10 | TP53 | 1 | KEGG_pathway
AKT2 | BCL2L1 | 1 | KEGG_pathway
FOXO1 | PCK2 | 1 | KEGG_pathway
SFN | TP53 | 1 | KEGG_pathway
TSC2 | TP53 | 1 | KEGG_pathway
PIK3CG | [NAME] | 1 | KEGG_pathway
SOS2 | BCL2L1 | 1 | KEGG_pathway
MAPK3 | BCL2 | 1 | KEGG_pathway
AKT2 | MAP3K5 | 1 | KEGG_pathway
[NAME] | PCK2 | 1 | KEGG_pathway
PKLR | AK2 | 1 | KEGG_paired
PKLR | AK3L1 | 1 | KEGG_paired
PKLR | POLG | 1 | KEGG_paired
STX4 | VAMP1 | 1 | Corum_complexes
PRKCI | ARHGAP17 | 1 | Corum_complexes
PIK3R1 | ESR1 | 1 | Corum_complexes
FOXO3 | TP53 | 1 | Corum_complexes
NOLC1 | SLC25A5 | 1 | Corum_complexes
NOLC1 | TUFM | 1 | Corum_complexes
RPS6 | SLC25A5 | 1 | Corum_complexes
IKBKB | MTIF2 | 1 | Corum_complexes
YWHAQ | C1QBP | 1 | Corum_complexes
[NAME] | ESR1 | 1 | Corum_complexes
[NAME] | VDAC1P1 | 1 | Corum_complexes
SLC2A4 | HK2 | 1 | BiGG_paired
SLC2A4 | HK1 | 1 | BiGG_paired
Spreadsheet: 849904d1700260896-how-to-vlookup-into-a-dataset-when-value-being-searched-has-multiple-values-that-you-need-vlookup-question
Sheet: Sheet1

Code | Value 1 | Value 2
123 | A | 1
124 | B | 2
125 | C | 3
126 | D | 4
127 | E | 5
123 | F | 6
124 | G | 7
Spreadsheet: darrell_schoolcraft__7825__imbalsumm0109
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-08-31 00:00:00 |  | 1328416.64
2001-09-22 00:00:00
60874 | 3651
78169
500235
500248 | -1
500251
500254
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2001-08-31 00:00:00 |  | 275313.72
2001-09-22 00:00:00
9164
9167
Duke Energy Trading and Marketing |  |  |  | CBS Volume | 24268 | 24693 | 24361
Contract  24361 |  |  |  |  | 281142 | 117857 | 148659
2001-08-31 00:00:00 |  | 760779.86
2001-09-22 00:00:00
500241
500391 | 5148
500392 | 1752
Duke Energy Trading and Marketing
21665 | oba | 73449.16 | POI 9109 Mobil Waha Plant |  |  |  | 21665 | 36403
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant |  |  |  | 22664 | 18932
Spreadsheet: 329768d1404400987-specific-criteria-for-subtotals-query
Sheet: Sheet1

 |  |  |  |  | Total crew
 |  |  |  |  | Department 1 INVOICED
 |  |  |  |  | Department 1 QUOTE
 |  |  |  |  | Department 1 RESERVATION
 |  |  |  |  | Department 2 INVOICED
 |  |  |  |  | Department 2 QUOTE
 |  |  |  |  | Department 2 RESERVATION
 |  |  |  |  | Department 3 INVOICED
 |  |  |  |  | Department 3 QUOTE
 |  |  |  |  | Department 3 RESERVATION
# | Order at | CREW ID | Department | start date | End date | 2014-01-01 00:00:00 | 2014-01-02 00:00:00 | 2014-01-03 00:00:00 | 2014-01-04 00:00:00 | 2014-01-05 00:00:00 | 2014-01-06 00:00:00 | 2014-01-07 00:00:00 | 2014-01-08 00:00:00 | 2014-01-09 00:00:00
1 |  | PLUMBER | DEPARTMENT 1 | 2014-01-01 00:00:00 | 2014-01-02 00:00:00
1 |  | ELECTRICIAN | DEPARTMENT 2 | 2014-01-01 00:00:00 | 2014-01-03 00:00:00
1 |  | ELECTRICIAN | DEPARTMENT 2 | 2014-01-01 00:00:00 | 2014-01-03 00:00:00
1 |  | CARPENTER | DEPARTMENT 3 | 2014-01-01 00:00:00 | 2014-01-03 00:00:00
1 |  | PLUMBER | DEPARTMENT 1 | 2014-01-01 00:00:00 | 2014-01-03 00:00:00
1 |  | PLUMBER | DEPARTMENT 1 | 2014-01-01 00:00:00 | 2014-01-03 00:00:00
1 | RESERVATION | ELECTRICIAN | DEPARTMENT 2 | 2014-01-03 00:00:00 | 2014-01-09 00:00:00
1 |  | ELECTRICIAN | DEPARTMENT 2 | 2014-01-03 00:00:00 | 2014-01-08 00:00:00
1 | RESERVATION | CARPENTER | DEPARTMENT 3 | 2014-01-03 00:00:00 | 2014-01-07 00:00:00
1 |  | PLUMBER | DEPARTMENT 1 | 2014-01-01 00:00:00 | 2014-01-06 00:00:00
1 | RESERVATION | PLUMBER | DEPARTMENT 1 | 2014-01-01 00:00:00 | 2014-01-06 00:00:00
1 |  | CARPENTER | DEPARTMENT 3 | 2014-01-03 00:00:00 | 2014-01-03 00:00:00
1 | RESERVATION | CARPENTER | DEPARTMENT 3 | 2014-01-04 00:00:00 | 2014-01-06 00:00:00
1 |  | CARPENTER | DEPARTMENT 3 | 2014-01-03 00:00:00 | 2014-01-05 00:00:00
1 |  | CARPENTER | DEPARTMENT 3 | 2014-01-08 00:00:00 | 2014-01-09 00:00:00
Spreadsheet: chris_dorland__1622__Forwards Detail-MIRANT_JAN171
Sheet: Pivot

Sum of Value
Deal Num | Total
(blank)
QP7039.1 | 1412483.943
V64794.1 | -1916702.3328
V67831.1 | -1515640.2129
V70968.1 | -1215838.6376
V92532.1 | -177402.1558
V98653.1 | 2138412.0759
VB4050.1 | 5590792.149700002
VC5783.3 | 10278647.8339
VD3558.1 | 8705790.764500001
VF2542.1 | -277112.6837999999
[NAME] | -1659928.8316
VG9103.1 | 4154.881499999994
VH0021.1 | 1652510.4869
VQ9540.1 | -962604.4136999999
VT2543.1 | 370662.6251
VT5299.1 | 157667.7328
Y46805.1 | 10540790.6786
Y92833.1 | -496165.6835
YA7382.1 | -274862.2512
YA7382.2 | 203354.7106
YA7593.1 | -441921.3773000001
YA7593.2 | 378335.4583
YA8854.1 | -431323.7418
YA8854.2 | 378335.4583
YC1650.1 | -20372.8808
YE3026.1 | -673904.0021999999
YF5957.1 | -66856.56880000001
YF5957.2 | 56150.8605
Y52420.1 | -3595.979600000001
Y52471.1 | -2696.8499
Y81297.1 | -6665.2745
Grand Total | 31724495.7818