tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 3492b226-20ac-456c-bf29-642aa556f09c
Sheet: Sheet1

Unnamed: 0 | GENERAL ELECTION - BELKNAP COUNTY OFFICES | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
2010-11-02 00:00:00 | Sheriff |  |  | Attorney |  | Treasurer
 | Wiggin, r&d | Others |  | Carroll, d&r | Others | Muzzey, r | Ahlgren, d | [NAME]
Alton | 2049 | 4 |  | 2035 | 3 | 1471 | 591
Barnstead | 1382 | 2 |  | 1371 |  | 875 | 526
Belmont | 1973 | 3 |  | 1986 |  | 1288 | 659
Center Harbor | 488 | 1 |  | 384 |  | 321 | 161
Gilford | 2844 | 16 |  | 2884 | 8 | 1942 | 900 | 3
Gilmanton | 1391 | 3 |  | 1401 |  | 943 | 459
[NAME] | 1047 | 3 |  | 1059 |  | 720 | 332
[NAME] | 668 | 4 |  | 687 | 2 | 437 | 243 | 2
[NAME] 3 | 775 | 5 |  | 797 | 1 | 497 | 271
[NAME] | 720 | 2 |  | 737 |  | 477 | 254
[NAME] | 534 | 4 |  | 545 | 2 | 353 | 188
[NAME] 6 | 983 | 6 |  | 991 | 4 | 697 | 302
Meredith | 2588 | 7 |  | 2569 | 5 | 1655 | 918
New Hampton | 838 | 1 |  | 832 | 3 | 500 | 345 | 1
Sanbornton | 1147 | 3 |  | 1157 | 3 | 665 | 513 | 1
[NAME] | 1093 | 7 |  | 1103 |  | 612 | 509
TOTALS | 20520 | 71 |  | 20538 | 31 | 13453 | 7171 | 7
 | Register of Deeds |  |  |  | Register of Probate
 | Luther, r | Chong, d | [NAME] |  | Brickner, r | [NAME], d | [NAME]
Alton | 1557 | 520 |  |  | 1498 | 560
Barnstead | 950 | 461 |  |  | 969 | 464
Belmont | 1414 | 566 |  |  | 1270 | 677
Center Harbor | 352 | 140 |  |  | 342 | 149
Gilford | 2090 | 810 | 2 |  | 1902 | 941 | 3
Gilmanton | 1009 | 407 | 1 |  | 963 | 439
[NAME] | 760 | 303 |  |  | 692 | 361
[NAME] | 482 | 207 | 1 |  | 414 | 265 | 1
[NAME] 3 | 538 | 240 |  |  | 481 | 290
[NAME] | 524 | 220 |  |  | 424 | 297
[NAME] | 394 | 158 |  |  | 347 | 193
[NAME] 6 | 755 | 249 |  |  | 683 | 313
Meredith | 1776 | 829 |  |  | 1677 | 890
New Hampton | 534 | 313 |  |  | 510 | 326
Sanbornton | 764 | 437 |  |  | 698 | 478
[NAME] | 688 | 443 | 1 |  | 627 | 499
TOTALS | 14587 | 6303 | 5 |  | 13497 | 7142 | 4
 | BELKNAP COUNTY COMMISSIONERS
 | District 1 | District 2 |  |  |  | Dist. 3
 | NO ELECTION | [NAME], r | Livernois, d | [NAME] |  | Nedeau, r | Copithorne, d | [NAME]
Alton |  |  |  |  |  | 1577 | 513 | 1
Barnstead |  | 932 | 471
Belmont |  | 1326 | 675
Center Harbor |  |  |  |  |  | 367 | 129
Gilford |  |  |  |  |  | 1976 | 886 | 8
Gilmanton |  | 920 | 501 | 1
[NAME]
[NAME]
[NAME] 3
[NAME]
[NAME]
[NAME] 6
Meredith |  |  |  |  |  | 1935 | 717
New Hampton |  |  |  |  |  | 543 | 302 | 2
Sanbornton |  | 632 | 605 | 1
[NAME] |  | 608 | 529 | 1
TOTALS |  | 4418 | 2781 | 3 |  | 6398 | 2547 | 11
Spreadsheet: 598525d1542571433-inventory-aging-fifo-inventory-age-updated
Sheet: Sheet2

 |  |  |  |  |  | [NAME]
 |  | Buffer In | Buffer Out | Daily Buffer Amount |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1-3 Days | 4 - 11 Days | 12 - 17 Days | 18+ Days
 | 2017-10-15 00:00:00 | 0 | 0
 | 2017-10-16 00:00:00 | 414 | -22
 | 2017-10-17 00:00:00 | 270 | 0
 | 2017-10-18 00:00:00 | 395 | 0
 | 2017-10-19 00:00:00 | 191 | 0
 | 2017-10-20 00:00:00 | 289 | 0
 | 2017-10-21 00:00:00 | 187 | -30
 | 2017-10-22 00:00:00 | 30 | 0
 | 2017-10-23 00:00:00 | 216 | 0
 | 2017-10-24 00:00:00 | 190 | 0
 | 2017-10-25 00:00:00 | 64 | -96
 | 2017-10-26 00:00:00 | 4 | -28
 | 2017-10-27 00:00:00 | 14 | 0
 | 2017-10-28 00:00:00 | 33 | 0
 | 2017-10-29 00:00:00 | 0 | 0
 | 2017-10-30 00:00:00 | 33 | -30
 | 2017-10-31 00:00:00 | 0 | -32
Spreadsheet: 220f0954-326c-4af6-823e-c662bed273a0
Sheet: Sheet1

Unnamed: 0 | Undergraduate Majors | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
 | Undeclared Arts
 | Study Year | Major [NAME] |  |  |  |  | Enrolment Headcount
 |  |  | 1999-00 | 2000-01 | 2001-02 | 2002-03 | 2003-04 | 2004-05 | 2005-06 | 2006-07 | 2007-08 | 2008-09 | 2009-10 | 2010-11
 |  | Single | 565 | 618 | 609 | 597 | 793 | 982 | 1089 | 513 | 244 | 262 | 351 | 323
 |  | Combined | 0 | 0 | 0 | 0 | 0 | 0
 | Year I | Sub-Total: | 565 | 618 | 609 | 597 | 793 | 982 | 1089 | 513 | 244 | 262 | 351 | 323
 |  | Gen/Integ. Studies | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total: | 565 | 618 | 609 | 597 | 793 | 982 | 1089 | 513 | 244 | 262 | 351 | 323
 |  | Single | 272 | 436 | 442 | 414 | 426 | 378 | 392 | 379 | 267 | 231 | 258 | 258
 |  | Combined | 0 | 0 | 0 | 0 | 0 | 0
 | Year II | Sub-Total: | 272 | 436 | 442 | 414 | 426 | 378 | 392 | 379 | 267 | 231 | 258 | 258
 |  | Gen/Integ. Studies | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total: | 272 | 436 | 442 | 414 | 426 | 378 | 392 | 379 | 267 | 231 | 258 | 258
 |  | Single | 84 | 149 | 138 | 186 | 210 | 99 | 84 | 76 | 91 | 77 | 90 | 66
 |  | Combined | 0 | 0 | 0 | 0 | 0 | 0
 | Year III | Sub-Total: | 84 | 149 | 138 | 186 | 210 | 99 | 84 | 76 | 91 | 77 | 90 | 66
 |  | Gen/Integ. Studies | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total: | 84 | 149 | 138 | 186 | 210 | 99 | 84 | 76 | 91 | 77 | 90 | 66
 |  | Single |  |  |  |  |  |  |  | 10 | 4 | 10 | 6 | 9
 |  | Combined
 | Year IV | Sub-Total: |  |  |  |  |  |  |  | 10 | 4 | 10 | 6 | 9
 |  | Gen/Integ. Studies
 |  | Total: |  |  |  |  |  |  |  | 10 | 4 | 10 | 6 | 9
 |  | Single | 921 | 1203 | 1189 | 1197 | 1429 | 1459 | 1565 | 978 | 606 | 580 | 705 | 656
 |  | Combined | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL: | Sub-Total: | 921 | 1203 | 1189 | 1197 | 1429 | 1459 | 1565 | 978 | 606 | 580 | 705 | 656
 |  | Gen/Integ. Studies | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total: | 921 | 1203 | 1189 | 1197 | 1429 | 1459 | 1565 | 978 | 606 | 580 | 705 | 656
 | Male |  | 433 | 558 | 529 | 492 | 651 | 665 | 712 | 473 | 348 | 327 | 353 | 360 | 0.5487804878048781
 | Female |  | 488 | 645 | 660 | 705 | 778 | 794 | 853 | 505 | 258 | 253 | 352 | 296 | 0.451219512195122
 | Full-Time |  | 586 | 800 | 755 | 791 | 991 | 1019 | 1138 | 802 | 494 | 489 | 576 | 521 | 0.7942073170731707
 | Part-Time |  | 335 | 403 | 434 | 406 | 438 | 440 | 427 | 176 | 112 | 91 | 129 | 135 | 0.2057926829268293
 | Codes:
 | ARTS code in Faculty of Social Sciences
Spreadsheet: 22538d1211484002-transpose-row-in-one-sheet-to-column-in-another-columntorow
Sheet: Sheet1

 |  |  |  |  |  |  | 50 | 77 | 87 | 29 | 39 | 55 | 41 | 51 | 80 | 15 | 66 | 10 | 88 | 15 | 73 | 25 | 59 | 76 | 70 | 4 | 91 | 52 | 28 | 16 | 6 | 96 | 28 | 45 | 30 | 21 | 77 | 22 | 21 | 83 | 93 | 71 | 61 | 92 | 26 | 36 | 92 | 23 | 73 | 4 | 85 | 43 | 62 | 22 | 39 | 52 | 49 | 43 | 81 | 1 | 39 | 32 | 40 | 76 | 13 | 97
Spreadsheet: 37535d1235576180-add-secondary-axis-without-stacking-columns-673273
Sheet: Sheet1

 | AA | BB
a | 1
 |  | 5
b | 2
 |  | 4
c | 3
 |  | 3
d | 4
 |  | 2
e | 5
 |  | 1
 |  | AA | BB
a |  | 0 | 0
 |  | 1 | 0
 |  | 0 | 5
 |  | 0 | 0
b |  | 0 | 0
 |  | 2 | 0
 |  | 0 | 4
 |  | 0 | 0
c |  | 0 | 0
 |  | 3 | 0
 |  | 0 | 3
 |  | 0 | 0
d |  | 0 | 0
 |  | 4 | 0
 |  | 0 | 2
 |  | 0 | 0
e |  | 0 | 0
 |  | 5 | 0
 |  | 0 | 1
 |  | 0 | 0
Spreadsheet: 374127d1422666818-i-need-to-create-a-number-of-rows-based-on-one-single-number-in-one-cell-hardy-har-har
Sheet: Sheet1

PARENTAL
p = frequency of A =
q = frequency of B = |  |  |  |  |  |  | number of each genotype
 |  |  |  | gametes |  | zygote | AA | AB | BB
 | sums for each genotype |  |  |  |  |  |  |  |  |  | <--Take this
 |  |  |  |  |  |  | A |  | B
 | number of each allele
 |  |  |  |  |  |  | p |  | q
 | allele frequency next generation
 | And multiply K16 with row 29 so we have 10 row 29's.
Spreadsheet: 789294d1659028019-representing-numbers-as-characters-representing-numbers-as-characters-
Sheet: Sheet1

No. | Student Name | Notes | Subject 1 | Subject 2 | Subject 3 | Subject 4 | Subject 5 | Subject 6 | Subject 7 | Subject 8 | Subject 9 | Subject 10 | Subject 11 | Subject 12 | Subject 13 | Subject 14 |  | A | 90-100
 | Units |  | 3 | 3 | 4 | 4 | 2 | 3 |  |  |  |  |  |  | 4 | 3 |  | B | 80-89
1 | Student 1 |  | 56 | 40 | 38 | 37 | 56 | 47 |  |  |  |  |  |  |  | 70 |  | C | 70-79
2 | Student 2 |  | 53 | 70 | 61 | 67 | 64 | 66 |  |  |  |  |  |  |  |  |  | D | 60-69
3 | Student 3 |  | 41 | 57 | 50 | 66 | 48 | 47 |  |  |  |  |  |  |  |  |  | E | 50-59
4 | Student 4 |  | 28 | 36 | 57 | 44 | 57 | 44 |  |  |  |  |  |  |  |  |  | F | <50
No. | Student Name | Notes | Subject 1 | Subject 2 | Subject 3 | Subject 4 | Subject 5 | Subject 6 | Subject 7 | Subject 8 | Subject 9 | Subject 10 | Subject 11 | Subject 12 | Subject 13 | Subject 14
 | Units |  | 3 | 3 | 4 | 4 | 2 | 3 |  |  |  |  |  |  | 4 | 3
1 | Student 1 |  | E | F | F | F | E | F |  |  |  |  |  |  |  | C
2 | Student 2 |  | E | C | D | D | D | D
3 | Student 3 |  | F | E | E | D | F | F
4 | Student 4 |  | F | F | E | F | E | F
Spreadsheet: 769918d1645723833-index-and-march-array-formula-with-approximate-match-index_match_approximate-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  | Hotel | C
 |  | Hotel | Room | Date | Price |  |  | Room | Double
 |  | A | Single | 2022-04-30 00:00:00 | 1000 |  |  | Date | 2022-05-16 00:00:00
 |  | A | Single | 2022-05-15 00:00:00 | 1500
 |  | A | Double | 2022-05-16 00:00:00 | 1700
 |  | A | Double | 2022-05-20 00:00:00 | 1900
 |  | B | Single | 2022-04-30 00:00:00 | 1000 |  |  | Price
 |  | B | Single | 2022-05-15 00:00:00 | 1500
 |  | C | Double | 2022-05-14 00:00:00 | 1700 |  |  | I want the approxmate match for Hotel C, when the date is approxmate, as 16 May)
 |  | C | Double | 2022-05-20 00:00:00 | 1900 |  |  | Expect the answer is 1700.
Spreadsheet: 758083d1638633855-return-value-based-on-more-or-less-than-0-sample-workbook_12042021
Sheet: Data

Company | Account | AU | Sub Acct | CAAS | Currency | Amount
00000 | 4033531 | 0011483 | 0000000 | [PHONE]-0011483-0000000 | USD | -100
02047 | 4033531 | 0211742 | 0000000 | [PHONE]-0211742-0000000 | USD | -1000
00323 | 4033531 | 0042255 | 0000000 | [PHONE]-0042255-0000000 | USD | -1500
00894 | 4033531 | 0027238 | 0000000 | [PHONE]-0027238-0000000 | USD | -800
02043 | 4033531 | 0218851 | 0000000 | [PHONE]-0218851-0000000 | USD | 0
00000 | 4033531 | 0055547 | 0000000 | [PHONE]-0055547-0000000 | USD | 0
00323 | 4033531 | 0211738 | 0000000 | [PHONE]-0211738-0000000 | USD | 0
00894 | 4033531 | 0218848 | 0000000 | [PHONE]-0218848-0000000 | USD | 500
02039 | 4033531 | 0211321 | 0000000 | [PHONE]-0211321-0000000 | USD | 0
00894 | 4033531 | 0023313 | 0000000 | [PHONE]-0023313-0000000 | USD | 0
00000 | 4033531 | 0103852 | 0000000 | [PHONE]-0103852-0000000 | USD | -1200
00000 | 4033531 | 0228023 | 0000000 | [PHONE]-0228023-0000000 | USD | -1300
00000 | 4033531 | 0233107 | 0000000 | [PHONE]-0233107-0000000 | USD | -900
00014 | 4033531 | 0053571 | 0000000 | [PHONE]-0053571-0000000 | USD | 780
02047 | 4032509 | 0211742 | 0000000 | [PHONE]-0211742-0000000 | USD | 845
00323 | 4032509 | 0042255 | 0000000 | [PHONE]-0042255-0000000 | USD | 652
Spreadsheet: 64949d1265745791-multiplying-formulas-together-test
Sheet: Sheet2

 | [NAME] | Length | Area
Roof area (ft) | 15 | 27 | 405
Panels (ft) | 5.67 | 3.42 | 19.3914
# Panels | 2 | 7 | 21
Maximum | 14
 | 2.645502645502646 |  | 7.894736842105264
 | 6
Spreadsheet: 738663d1625162899-formula-to-calculate-total-amount-of-previous-invoice-total-amount-of-previous-invoice
Sheet: Sheet1

Name | SEQUENCE |  | Note No. | LF No |  | Number | Note No. | LF No | Invoice Total Amount |  |  | Name | Total value project |  | Name selection | LF No | Total Amount of previous invoice | Balance value
L45678990743 | 1 | 1 | LD1 | [NAME] |  | 45678990743 | LD1 | [NAME] | 1000 |  |  |  | 8280 |  | L45678990743 | [NAME]
L45678990743 | 2 | 2 | LD2 | LF2 |  | 45678990743 | LD2 | LF2 | 1010 |  |  | L45678990745 | 8370 |  | L45678990743 | LF2
L45678990743 | 3 | 3 | LD3 | LF3 |  | 45678990743 | LD3 | LF3 | 1020 |  |  | [NAME] | 10220 |  | L45678990743 | LF3
L45678990743 | 4 | 4 | LD4 | LF4 |  | 45678990743 | LD4 | LF4 | 1030 |  |  |  |  |  | L45678990743 | LF4
L45678990743 | 5 | 5 | LD5 | LF5 |  | 45678990743 | LD5 | LF5 | 1040 |  |  |  |  |  | L45678990743 | LF5
L45678990743 | 6 | 6 | LD6 | LF6 |  | 45678990743 | LD6 | LF6 | 1050 |  |  |  |  |  | L45678990743 | LF6
L45678990743 | 7 | 7 | [NAME] | LF7 |  | 45678990743 | [NAME] | LF7 | 1060 |  |  |  |  |  | L45678990743 | LF7
L45678990743 | 8 | 8 | LD8 | LF8 |  | 45678990743 | LD8 | LF8 | 1070 |  |  |  |  |  | L45678990743 | LF8
L45678990745 | 1 | 1 | LD1 | [NAME] |  | 45678990745 | LD1 | [NAME] | 1370
L45678990745 | 2 | 2 | LD2 | LF2 |  | 45678990745 | LD2 | LF2 | 1380
L45678990745 | 3 | 3 | LD3 | LF3 |  | 45678990745 | LD3 | LF3 | 1390
L45678990745 | 4 | 4 | LD4 | LF4 |  | 45678990745 | LD4 | LF4 | 1400
L45678990745 | 5 | 5 | LD5 | LF5 |  | 45678990745 | LD5 | LF5 | 1410
L45678990745 | 6 | 6 | LD6 | LF6 |  | 45678990745 | LD6 | LF6 | 1420
[NAME] | 1 | 1 | LD1 | [NAME] |  | 45678990747 | LD1 | [NAME] | 1430
[NAME] | 2 | 2 | LD2 | LF2 |  | 45678990747 | LD2 | LF2 | 1440
[NAME] | 3 | 3 | LD3 | LF3 |  | 45678990747 | LD3 | LF3 | 1450
[NAME] | 4 | 4 | LD4 | LF4 |  | 45678990747 | LD4 | LF4 | 1460
[NAME] | 5 | 5 | LD5 | LF5 |  | 45678990747 | LD5 | LF5 | 1470
[NAME] | 6 | 6 | LD6 | LF6 |  | 45678990747 | LD6 | LF6 | 1480
[NAME] | 7 | 7 | [NAME] | LF7 |  | 45678990747 | [NAME] | LF7 | 1490
Spreadsheet: 159793d1338844860-vlookup-on-another-sheet-cerca-2-oeldere-
Sheet: Foglio2

 |  |  | 2012-05-01 00:00:00 | 1
MATTINA=  MORNING
ADDETTI | Cod. turno | Turno | Straordinario | FERIE | [NAME] |  |  |  |  | By changing the date in E1, must enter their data in the columns ABF from sheet1 automatically.  The column C, I set myself.  The column D and E do not need  Only formulas thanks for your help
MANUELA | R | Riposo |  |  | MANUELA |  | M
EVELINA | 32 | 06.00-14.00
SERENA | 43 |  |  |  |  |  | 39
GIOVANNI | 42 |  |  |  |  |  | 30
LORENZO | 35 | 08.00-16.00 |  |  |  |  | 32
GIACOMO | 530 | 05.30-11.30 |  |  |  |  | 56
FRANCESCO | R | Riposo |  |  | FRANCESCO |  | 35
PAOLA | 31 |  |  |  |  |  | 530
DALILA | 56 | 05.00-13.00 |  |  |  |  | 532
VALENTINA | 51 |  |  |  |  |  | 539
ANNA | 34
MARIA | R | Riposo |  |  | MARIA
POMERIGGIO= AFTERNOON
ADDETTI | Cod. turno | Turno | Straordinario | MALATTIA
SERENA | 43 | 15.00-23.00 |  |  |  |  | P
GIOVANNI | 42 | 13.30-21.30
PAOLA | 31 | 22.00-06.00 |  |  |  |  | 43
VALENTINA | 51 | 15.30-23.30 |  |  |  |  | 34
ANNA | 34 | 14.00-22.00 |  |  |  |  | 51
 |  |  |  |  |  |  | 42
 |  |  |  |  |  |  | 31
 |  |  |  |  |  |  | 551
 |  |  |  |  |  |  | 545
 |  |  |  |  |  |  | 544
Spreadsheet: 183823-how-to-connect-the-data-in-two-sheets-in-one-book-show
Sheet: Sheet2

Name | CSN | Country | Partner Name | Partner Type | Tier | Job
aa | 1 | X | A | IVAR | [NAME] | Sales
bb | 1 | X | A | IVAR | [NAME] | Marketing
cc | 2 | Y | B | IVAR | [NAME] | Sales
dd | 3 | Y | C | IVAR | [NAME] | IT
Spreadsheet: 1810054e-bb78-4d09-97d6-3d06ba8458ee
Sheet: Sheet1

Table 1--Soybeans:  Annual U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | Area |  | Yield | Supply |  |  |  |  | Use
Year beginning | Planted | Harvested |  | Beginning |  |  |  |  | Crush | Seed, feed |  |  | Ending
September 1 |  |  |  | stocks | Production | Imports | Total |  |  | & residual | Exports | Total | stocks
 | Million acres |  | Bu./acre |  |  |  |  |  | --------------------------------------------------Million bushels--------------------------------------------------
2011/12 | 75.046 | 73.776 | 41.93130557362828 | 215.013 | 3093.524 | 16.1352383836245 | 3324.672238383625 |  | 1703 | 90.4538823855737 | 1361.848355998051 | 3155.302238383625 | 169.37
2012/131 | 77.198 | 76.104 | 39.61681383370125 | 169.37 | 3014.998 | 25 | 3209.368 |  | 1660 | 94.36799999999994 | 1330 | 3084.368 | 125
2013/142 | 77.126 | 76.2 | 44.48818897637795 | 125 | 3390 | 15 | 3530 |  | 1695 | 120 | 1450 | 3265 | 265
Soybeans:  Quarterly U.S. supply and disappearance
 |  |  |  | Supply |  |  |  |  | Use
 |  |  |  | Beginning |  |  |  |  | Crush, seed |  |  |  | Ending
 |  |  |  | stocks | Production | Imports | Total |  | & residual |  | Exports | Total | stocks
2011/12 |  |  |  |  |  |  |  |  | --------------------------------------------------Million bushels--------------------------------------------------
September-November |  |  |  | 215.013 | 3093.524 | 2.8441205983722 | 3311.381120598372 |  | 516.5955746809718 |  | 424.9005459174001 | 941.4961205983718 | 2369.885
December-February |  |  |  | 2369.885 | --- | 3.1416916574442 | 2373.026691657445 |  | 523.9961548514923 |  | 474.5425368059524 | 998.5386916574446 | 1374.488
March-May |  |  |  | 1374.488 | --- | 5.3307780169035 | 1379.818778016903 |  | 453.9034791290034 |  | 258.4502988879 | 712.3537780169034 | 667.465
June-August |  |  |  | 667.465 | --- | 4.818648110904601 | 672.2836481109047 |  | 298.958673724106 |  | 203.9549743867986 | 502.9136481109047 | 169.37
Total |  |  |  |  | 3093.524 | 16.1352383836245 | 3324.672238383625 |  | 1793.453882385574 |  | 1361.848355998051 | 3155.302238383624
2012/13
September-November |  |  |  | 169.37 | 3014.998 | 4.2863493307698 | 3188.65434933077 |  | 602.9483867095553 |  | 619.5449626212146 | 1222.49334933077 | 1966.161
December-February |  |  |  | 1966.161 | --- | 4.7181036423045 | 1970.879103642304 |  | 440.6512322404433 |  | 530.9478714018612 | 971.5991036423045 | 999.28
Total to date |  |  |  |  | 3014.998 | 9.004452973074299 | 3193.372452973074 |  | 1043.599618949999 |  | 1150.492834023076 | 2194.092452973075
1 Estimated. 2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Grain Stocks and U.S. Department of Commerce, U.S. Census Bureau,
Foreign Trade Statistics.
Last update: | 2013-06-13 10:58:37.630000
Spreadsheet: ec99c247-be76-48c6-80fd-3b8d7f7fd82e
Sheet: Sheet1

Release: ADP National Employment Report | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=194
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2013-05-23 2:20 PM CDT
 | Real-Time | Period
Name: | Start | End
ADP National Employment Report | 2011-02-02 00:00:00 | Current
Link:
http://www.adpemploymentreport.com/ | 2011-02-02 00:00:00 | Current
Source:
Automatic Data Processing, Inc. | 2011-02-02 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-02-02 00:00:00
2011-03-02 00:00:00
2011-03-30 00:00:00
2011-05-04 00:00:00
2011-06-01 00:00:00
2011-07-07 00:00:00
2011-08-03 00:00:00
2011-08-31 00:00:00
2011-10-05 00:00:00
2011-11-02 00:00:00
2011-11-30 00:00:00
2012-01-05 00:00:00
2012-02-01 00:00:00
2012-03-07 00:00:00
2012-04-04 00:00:00
2012-05-02 00:00:00
2012-05-31 00:00:00
2012-07-05 00:00:00
2012-08-01 00:00:00
2012-09-06 00:00:00
2012-10-03 00:00:00
2012-10-24 00:00:00
2012-11-01 00:00:00
2012-12-05 00:00:00
2013-01-03 00:00:00
2013-01-30 00:00:00
2013-03-06 00:00:00
2013-04-03 00:00:00
2013-05-01 00:00:00
Spreadsheet: 64213d1265108046-generating-a-dynamic-list-using-lookup-book1
Sheet: Sheet1

User ID | test | Car | Registration
11 | 1 | AB71 | 7GA
11 | 2 | RT62 | 2GH
11 | 3 | AH10 | 8IC
12 | 1 | AA1 | 0GH
15 | 1 | BR51 | 4NU
15 | 2 | YBU1 | 3GH
16 | 1 | KK77 | 8QV
16 | 2 | SY98 | 9GS
16 | 3 | VV46 | 8UH
16 | 4 | VA7 | 2GK
Spreadsheet: lynn_blair__24412__Proposed Storage Points
Sheet: Sheet1

Proposed Storage Points
 |  |  |  | Primary Firm | Primary Firm
Location | POI Number | Capacity (MMBtu) |  | Sold (MMBtu) | Available (MMBtu) | Comments
TW/NNG Gray | Rec 60667 |  | Rec. | 20000 | 40000 | Will be Bi-Directional Nov. 1, 2001
 | Del 60668 |  | Del.
Transok Arapahoe | 35111 |  | Rec. | 29325 | 25675 | Bi-Directional
 |  |  | Del. | 0 | 55000
[NAME] | 179 |  | Rec. | 52137 | 0 | Bi-Directional
 |  |  | Del. | 0 | 80000
[NAME] | 1907 |  | Rec. | 0 | 55000 | Bi-Directional
 |  |  | Del. | 0 | 55000
Westar Seagraves | 1504 |  | Rec. | 8008 | 91992 | Bi-Directional
 |  |  | Del. | 0 | 60000
[NAME] | 229 |  | Rec. | 56000 | 6000 | Can be Bi-Directional, but
 |  |  | Del. | 0 |  | very labor intensive
El Paso Dumas | 186 |  | Rec. | 0 | 154782 | Receipt Pt. Only
[NAME] | 200 |  | Rec. | 20000 | 30000 | Bi-Directional
 |  |  | Del. | 0 | 50000
El Paso Keystone | 169 |  | Del. | 50000 | 0 | Delivery Pt. Only
PEPL Mullinville | 173 |  | Rec. |  |  | Bi-Directional
 |  |  | Del. |  | 150000
Pony Express | 71214 |  | Rec. | 80000 | 0 | Bi-Directional
 |  |  | Del.
Spreadsheet: 690146d1596894291-formula-to-extract-account-number-where-ref-and-amount-are-the-same-account-numbers
Sheet: Sheet1

Reference | Sub Reference | Source | Run | A/C | Date | Code | Description
 |  | Cash Book |  |  | 2018-07-19 00:00:00 | 114100 | Bank Current Account
 |  | Cash Book |  |  | 2018-07-19 00:00:00 | 127003 | InterBranch SL Control
10525A |  | Cash Book |  |  | 2018-07-23 00:00:00 | 114100 | Bank Current Account
9054 |  | Cash Book |  |  | 2018-07-23 00:00:00 | 127003 | InterBranch SL Control
9054 |  | Sales Ledger |  |  | 2018-07-30 00:00:00 | 122460 | CONTRA Control
12535 |  | Sales Ledger |  |  | 2018-07-30 00:00:00 | 127003 | InterBranch SL Control
12535 |  | Sales Ledger |  |  | 2018-07-30 00:00:00 | 122460 | CONTRA Control
 |  | Sales Ledger |  |  | 2018-07-30 00:00:00 | 127003 | InterBranch SL Control
Spreadsheet: gerald_nemec__11555__TPALIST _ENAUP
Sheet: EDI Testing Plan

Assumptions:
 |  | TPA in place
 |  | Pipe has coded per GISB standards and is compliant
 |  | Pipe will devote resources to correct errors if found by ENA test team
 |  | Pipe will make v1.4 changes in November 2000, which may require another test cycle, data analysis, etc...
Initial Test Plan
 | 1 | Initialize TPA with all pipelines and receive fully executed agreements for all Capacity Release Datasets.
 | 2 | Coordinate test dates with Pipes.  Once data is successfully translated though HUB, will move code into production the following day.  Must have fully executed TPA to move into production.  Note:  some pipes may want to move into production immediately.
 | 3 | Once pipe is in production, the ENA test team will analyze data.  Analysis will include verification of data in data dictionary ensure information is captured in the appropriate GISB field.  Ensure Manadatory data is sent; discover which optional fields pipe will be using; blah, blah, blah; basically comparing guide to data sent and documenting any variances and different usages.
 | 4 | Development of a GUI interface will need to take place to determine with data is intrograted for all reports (download & upload).
 | 5 | Data intregity will need to be verfied.  Analysis team will obtain access to EBB Capacity Release arena.  Comparisions will take place for all data.
 | 6 | Development of a systematic way to request reports and downloads.  Each pipeline posts this information on different time tables.  Discovery of these posting times will need to take place
 | 7 | Work with pipelines in developing a test plan to do interactive testing.  Initial idea is to do testing in production.  ENA would submit an upload with zero volume associated (check EBB to ensure accuracy of upload & correct any errors); ENA would then submit bids to that upload.  Pipe would confirm and award to best applicant (ENA).
 | 8 | Development of a monitoring system in production.  This would require a fully dedicated person (user support).
 |  | costs from EDI Hub set up perspective:  Initial set up requires time; individuals assigned include DN, DG, GP.  Will be using resource provided by [NAME] (business analyst).  Hiring 1 GISB support person to replace [NAME] on project and 2 full time business analyst; there is a charge for EDI tranlation service.  ([NAME] works w/ [NAME] and will be our business analyst.
 |  | Would also need to get w/ EDI Hub - they will need to identify costs associated w/ capacity release.