tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 97c2d818-be76-40b9-9bcf-4e8da936ebf0
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
8001 | 55766 | Davide | Ambrosini | ITA | 122 | 00:21:23 | 00:00:00 | 00:26:15 | 00:00:00 | 00:32:02 | 1 | 01:19:41
Spreadsheet: 5af859d7-e9c1-4eb3-8dd2-7be3a10eb477
Sheet: EBSCO Change format

RB9700200
2011 Renewal
Format changes for EBSCO titles
Current as of : 9/30/2010
Title | ISSN | Current Format | Print cost | New Format | EBSCO Title # | ILS Number | Publisher | Price | HEGIS | Why | EBSCO Account No.
Journal of Beckett Studies | 0309-5207 | print only | 159.9 | online only | 471-552-010 | o1274454 | [NAME]. | 128 | ENGP | Atypon. Access back to 2000 where available. Subscriber only retains access to content published during subscription period if the subscription lapses. | RB97002 (AA)
Contemporary French Civilization | 0147-9156 | print only | 95 | print + online | 235-582-012 | o1895138 | [NAME]. | 95 | LANP | MetaPress | RB97002 (AA)
Perceptual and [NAME] | 0031-5125 | print only | 541.5 | online only | 684-171-039 | o126929x | Ammons Scientific | 541.5 | PSYP | http://ejournalsignup.ammonsscientific.com/ (Atypon) | RB97002 (AA)
Psychological Reports | 0033-2941 | print only | 541.5 | online only | 735-405-040 | o126929x | Ammons Scientific | 541.5 | PSYP | http://ejournalsignup.ammonsscientific.com/ (Atypon) | RB97002 (AA)
French 17 | 0191-9199 | print only | 24.95 | print + online | 354-665-006 | o1294489 | French 17 | 24.95 | LANP | ALL WITH CURRENT - Includes access from 1995 to current. | RB97002 (AA)
Journal of Neuroscience Nursing | 0888-0395 | print only | 279.86 | online only | 489-171-377 | o130401x | LWW | 329 | NURP | Journals@OVID | RB97002 (AA)
ACSMS Health & Fitness Journal | 1091-5397 | print only | 131.7 | online only | 006-960-561 | [NAME] | LWW | 278 | KINP | Journals@OVID | RB97002 (AA)
Hearing Journal | 0745-7472 | print only | 234 | online only | 388-705-480 | o1292286 | LWW | 107 | CMDP | Journals@OVID | RB97002 (AA)
Journal of Cardiopulmonary Rehabilitation and Prevention | 1932-7501 | print only | 415.49 | online only | 472-937-408 | o2435226 | LWW | 492 | KINP | Journals@OVID | RB97002 (AA)
Journal of Strength and Conditioning Research | 1064-8011 | print only | 544 | online only | 497-728-569 | o2441949 | LWW | 637 | KINP | Journals@OVID | RB97002 (AA)
Strength and Conditioning Journal | 1524-1602 | print only | 195.05 | online only | 855-890-920 | o2456515 | LWW | 215 | KINP | Journals@OVID | RB97002 (AA)
[NAME] | 0034-9631 | print only |  | print + online | 772-434-007 | o1245260 | [NAME] | 208.46 | LANP | Free online available. Bridget sent them Ips 12/2010. "D-Scribe" platform. | RB97002 (AA)
Spreadsheet: 0304112c-c921-43b9-92df-d48bcebc4130
Sheet: Sheet1

AFLAC INC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
8-K
02/14/2014
CURRENT REPORT
Georgia |  | 001-07434 |  | 58-1167100
(State or other jurisdiction |  | (Commission |  | (IRS Employer
of incorporation) |  | File Number) |  | Identification No.)
1932 Wynnton Road, Columbus, Georgia |  |  |  | 31999
(Address of principal executive offices) |  |  |  | (Zip Code)
Spreadsheet: 752452d1634759659-sumproduct-multiplying-based-on-multiple-conditions-hop_inv_tracking_example
Sheet: Recipes

 |  | - | Beer 1 | Beer 2 | Beer 3 | Beer 4
 |  | Hop 1 | 55 |  | 11 | 5
 |  | Hop 2 | 55
 |  | Hop 3 | 55 |  |  | 11
 |  | Hop 4 |  | 33 |  | 11
 |  | Hop 5 | 11 |  | 11 | 11
 |  | Hop 6 |  |  |  | 11
 |  | Hop 7 |  |  | 11 | 11
 |  | Hop 8 | 11 | 22 | 33 | 11
 |  | Hop 9 |  |  | 11 | 22
 |  | Hop 10
Spreadsheet: 3d9ceeae-d3e0-4692-919c-b651c82c6004
Sheet: Sheet1

 | Wed 29 7.30 | Thurs 30 2.00 | Thurs 30 7.30 | Fri 31 7.30 | Sat 01 2.00 | Sat 01 7.30
ACT ONE
[NAME] | Peasgood | Vigier | Laurence | Vigier | Peasgood | Laurence
Gretel | Garner | Martin | [NAME] | Martin | Garner | [NAME]
Witch | Ravizzi | Mutso | Martin | Mutso | Ravizzi | Martin
Mother | Mutso | Ravizzi | Hersh | Ravizzi | Mutso | Hersh
Father | Cavallari | [NAME] | Andreoni | [NAME] | Cavallari | Andreoni
Tramps | Zanardini | [NAME] | Zanardini | [NAME] | Zanardini | Zanardini
 | Loudon | Loudon | [NAME] | Loudon | Loudon | [NAME]
Streetgirls | Brangan | [NAME] | [NAME] | [NAME] | Brangan | [NAME]
 | Watson | Webb | Watson | Webb | Watson | Watson
Streetmen | Thorne | Thorne | [NAME] | Thorne | Thorne | [NAME]
 | Laurence | Patron | [NAME] | Patron | Laurence | [NAME]
Sandman | [NAME] | [NAME] | Cavallari | Peasgood | [NAME] | [NAME]
Ravens 1 | [NAME] | Zarallo | Vigier | Zarallo | [NAME] | Kendall
2 | Patron | [NAME] | Peasgood | [NAME] | Patron | Peasgood
3 | Edwards | Andreoni | Loudon | Andreoni | Edwards | Loudon
Chefs 1 | [NAME] | Peasgood | Edwards | Edwards | [NAME] | Edwards
[NAME] | Kendall | Laurence | Zarallo | Laurence | Kendall | Zarallo
Waitress / Parent 1 | Oddi | Oddi | Oddi | Oddi | Oddi | Oddi
Waitress / Parent 2 | Hadley | Hadley | Hadley | Hadley | Hadley | Hadley
Waitress / Parent 3 | Joffre | Rogers | Joffre | Rogers | Joffre | Joffre
Waitress / Parent 4 | Souet | [NAME] | Souet | [NAME] | Souet | [NAME]
Waitress / Parent 5 | Hersh | Hersh | Watson | Watson | Hersh | Watson
Waitress / Parent 6 | Brangan | Brangan | Brangan | Brangan | Brangan | Brangan
Waiter / Parent 1 | Laurence | Edwards | [NAME] | [NAME] | Laurence | Vigier
Waiter / Parent 2 | Zarallo | Kendall | [NAME] | Kendall | Zarallo | [NAME]
Waiter / Parent 3 | [NAME] | Patron | Patron | Patron | [NAME] | Patron
Waiter / Parent 4 | Zanardini | Loudon | Zanardini | Loudon | Zanardini | Zanardini
Waiter / Parent 5 | Andreoni | [NAME] | [NAME] | [NAME] | Andreoni | [NAME]
Waiter / Parent 6 | Loudon | Thorne | [NAME] | Thorne | Loudon | [NAME]
ACT TWO
Dew Drop Fairy | [NAME] | Joffre | Garner | Garner | [NAME] | Garner
[NAME] 1 | Hadley | Hadley | Hadley | Brangan | Brangan | Hadley
2 | Joffre | [NAME] | Joffre | Joffre | Joffre | Joffre
3 | Souet | Souet | Souet | [NAME] | Souet | Souet
4 | Hersh | Oddi | Hersh | Oddi | Hersh | Oddi
[NAME] | Webb | Laplane | Webb | Laplane | Webb | Webb
 | Laurence | Zarallo | [NAME] | Zarallo | Laurence | [NAME]
Sweet - Treats 1 | Brangan | Brangan | Brangan | Brangan | Brangan | Brangan
2 | [NAME] | [NAME] | [NAME] | [NAME] | Souet | [NAME]
3 | Watson | Watson | Watson | Watson | Watson | Watson
4 | Hersh | Hersh | Joffre | Hadley | Hadley | Hersh
5 | Oddi | Oddi | Ravizzi | Brangan | Oddi | Ravizzi
6 | Rogers | Rogers | Rogers | Rogers | Rogers | Rogers
Spreadsheet: 10e81dfe-85cc-4a09-9176-926011ab846c
Sheet: Instructions

 | Colorado Department of Health and Environment (CDPHE)
 | How to use the Budget Revision Form
 | Purpose: | Budget Revisions are required in most cases for CUMULATIVE changes in excess of 25% of the total budget for direct costs or $250,000, whichever is less, between approved budget categories. Budget revisions are also required to incur expenses against a budget category not previously approved. To open a new budget category line, one must seek approval PRIOR to incurring expenditures against the new line. In addition, when requesting a line be opened for Contracts or Personnel Services, additional approvals and review of your contract scope of work  will be required and could take longer for approval. Please plan accordingly.
 | Contact Information
 | Complete the top portion of the form by providing your Agency Name, Contract Period, Contract/Encumbrance Number, contact information for the Program and Fiscal contacts, and Project Name.
 | [NAME]: Enter your agency name |  |  |  |  |  |  | Program Contact Name, Title, Phone and [NAME]
 | Contract Period:  Enter contract period dates |  |  |  |  |  |  | Enter your agency's program contact information here
 | Contract/Encumbrance Number:  Enter contract/encumbrance number. |  |  |  |  |  |  | Fiscal Contact Name, Title, Phone and [NAME]
 |  |  |  |  |  |  |  | Enter your agency's fiscal contact information here
 |  |  |  |  |  |  |  | Project Name:  Enter the  project name
 |  |  |  |  |  |  |  | Effective Date of Budget Revision: Effective date of a budget revision must be a date after the signature/approval date of the revision. No purchases under the revised budget can be made prior to receiving CDPHE approval.
 | Budget Revision Form Instructions:
 | If any budget category in your original budget will increase or decrease by more than 25% of your direct costs or $250,000, whichever is less, a budget revision request is required.
 | For each line item decrease, explain the reason for savings in the "justification for revision" section.
 | For each line item increase, explain and justify how it is still within the original program objectives and within the contract agreement.
 | Provide the signature from authorizing agency representative at bottom of page.
 | See sample budget revision form for an example of a budget revision.
 | Submit the signed budget revision form to your assigned PSD program manager for review, preferably via e-mail.
 | If the revisions are appropriate and justified, the CDPHE program manager and fiscal officer will approve with signatures at the bottom of the justification page and return to your agency.
 | If the revision request received by CDPHE has been determined to be outside the scope of the agreement by either the program manager or fiscal officer, a revised scope of work and budget will need to be submitted to CDPHE to initiate an amendment. Your agency will be informed by CDPHE if this is needed.
Spreadsheet: 811075d1672264991-count-rows-if-formula-doesnt-equal-blank-testing
Sheet: Data Needed

 | Cadet | Squadron
 |  | 1F
 |  | 5F
 |  | 126
 |  | 138
 |  | 198
 |  | 209
 |  | 348
 |  | 378
 |  | 422
 |  | 497
 |  | 504
 |  | 858
 |  | 1084
 |  | 1101
 |  | 1188
 |  | 1211
 |  | 1279
 |  | 1359
 |  | 1360
 |  | 1461
 |  | 1936
 |  | 1947
 |  | 2070
 |  | 2071
 |  | 2195
 |  | 2229
 |  | 2248
 |  | 2418
 |  | 2425
 |  | 2502
Spreadsheet: daren_farmer__5704__HPL_Noms0201
Sheet: Sheet1

Nominations on Houston Pipeline for February 2001
 |  |  | MMBTU/D
HPL Meter # | [NAME] | Supplier | Baseload | Swing
1394 | Houston Refinery | Enron | 5000 | 15000
1233 | Texas City | Enron | 10000 | 15000
8018 | Celanese | Enron | 10000 | 15000
8018 | Celanese | BP Energy | 7000
Total Allowable:
1394 | Houston Refinery | 20000
1233 | Texas City | 25000
8018 | Celanese | 32000
Spreadsheet: 758701d1639022853-sum-formula-based-on-column-criteria-sum
Sheet: Sheet1

 |  | Sales | Cost A | Cost B | Cost C
 |  | 10 | 1
 |  | 20 | 2 |  | 5
 |  | 30 |  | 10
 |  | 40 |  |  | 9
 |  | 50 |  | 12
 |  | Total Sales |  |  |  | <----- Expected result
 |  | What is the formula for highlighted in yellow color row. I wanted to sum the figure in Sales column (Column C) based on Cost A, Cost B & Cost C excluded empty cell
Spreadsheet: 815460d1674962996-insert-blank-row-if-cell-value-sequence-is-incorrect-e-g-if-a-c-then-insert-row-sample-data-fields-sequence
Sheet: Sheet1

Current Irregular sequence ($ is the record Delimiter) |  | Desired Sequence |  |  | What I'd like Column A to look like after formula or VBA
TN |  | TN |  |  | TN
CN |  | CN |  |  | CN
TI |  | ST |  |  | TI
G |  | SS
SP |  | TI
ES |  | OT
DR |  | G |  |  | G
PR |  | SP |  |  | SP
PT |  | ES |  |  | ES
PD |  | DR |  |  | DR
CH |  | PR |  |  | PR
CD |  | PT |  |  | PT
RC |  | PD |  |  | PD
DE |  | CH |  |  | CH
K |  | CD |  |  | CD
MP |  | RC |  |  | RC
$ |  | DE |  |  | DE
TN |  | K |  |  | K
CN |  | MP |  |  | MP
ST |  |  |  |  | $
SS
TI
OT
G
SP
ES
DR
PR
PT
PD
CH
CD
RC
DE
K
MP
$
TN
CN
ST
SS
TI
G
SP
ES
DR
PR
PT
PD
CH
CD
RC
DE
K
MP
$
TN
CN
ST
SS
TI
OT
G
SP
ES
DR
PR
PT
PD
CH
CD
RC
DE
K
MP
$
TN
CN
ST
SS
TI
G
SP
ES
DR
PR
PT
PD
CH
CD
RC
DE
K
MP
$
Spreadsheet: 703815d1605186219-use-formulas-to-show-visibility-of-employees-shift-visibility-test-my-solution
Sheet: Trained on Task

Data Entry | Sales | After Sales Care
[NAME] | [NAME] | [NAME]
Sophie | Sophie | [NAME]
Janice | [NAME] | [NAME]
[NAME] |  | [NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 7a

Product1 | Cleared2 | Uncleared | TOTAL
Fixed-Float | 118961993 | 68499425 | 187461418
FRA | 52318958 | 6369366 | 58688324
OIS | 28109772 | 6854652 | 34964424
Swaption | - | 16584131 | 16584131
OTHER* | 5630904 | 25588239 | 31219143
TOTAL | 205021627 | 123895813 | 328917440
* OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 682614d1592228355-populate-specific-cell-practive-date
Sheet: Sheet1

Start Date | Due Date | Hours |  | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | 2020-06-03 00:00:00 | 2020-06-04 00:00:00 | 2020-06-05 00:00:00 | 2020-06-06 00:00:00 | 2020-06-07 00:00:00 | 2020-06-08 00:00:00 | 2020-06-09 00:00:00 | 2020-06-10 00:00:00 | 2020-06-11 00:00:00 | 2020-06-12 00:00:00 | 2020-06-13 00:00:00 | 2020-06-14 00:00:00 | 2020-06-15 00:00:00 | 2020-06-16 00:00:00 | 2020-06-17 00:00:00 | 2020-06-18 00:00:00 | 2020-06-19 00:00:00 | 2020-06-20 00:00:00 | 2020-06-21 00:00:00 | 2020-06-22 00:00:00 | 2020-06-23 00:00:00 | 2020-06-24 00:00:00 | 2020-06-25 00:00:00 | 2020-06-26 00:00:00 | 2020-06-27 00:00:00 | 2020-06-28 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00 | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | 2020-07-03 00:00:00 | 2020-07-04 00:00:00 | 2020-07-05 00:00:00 | 2020-07-06 00:00:00 | 2020-07-07 00:00:00 | 2020-07-08 00:00:00
2019-06-25 00:00:00 |  | 8
2020-06-26 00:00:00 |  | 8
2020-06-27 00:00:00 |  | 8
2020-06-29 00:00:00 |  | 8
 |  | 8
Spreadsheet: tracy_geaccone__40235__enron corp infomation request-egas
Sheet: details of asset sale proceeds

ENRON GLOBAL ASSETS & SERVICES
2002 Assets Sale
Cash Proceeds Estimate
$(Millions)
 |  |  |  |  |  |  |  | 4Q 2002 Estimated
 |  |  | 1Q | 2Q | 3Q | 4Q |  | Cash Proceed
Asset
 | SK Enron |  |  | -77.5 |  |  |  | 220
 | Gaspart |  |  |  | 12.5 |  |  | 206.5
 | TBG/GTB |  |  |  | -14.9 |  |  | 29.4
 | Transredes |  |  |  | -35.1 |  |  | 115
 | Accroven |  |  |  |  | 1 |  | 52
 | Bond Portfolio |  |  |  |  | 0 |  | 23.5
 | Calife |  |  |  |  | -28 |  | 7
 | [NAME] |  |  |  |  | -21.9 |  | 48
 | [NAME] |  |  |  |  | 8.2 |  | 42.1
 | Procaribe |  |  |  | -4.9 |  |  | 0
 | Total
Spreadsheet: 56620d1256761636-sum-and-rank-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Pull in the new Level 1 (rank) after Q4 sales are summed up across months for each name
 | Quarters | Month | Level | Name | Sales |  | Name | Sales |  | Conditions: | Q4
 | 1 | 2009-01-01 00:00:00 | 1 | [NAME] | 2947 |  | [NAME] | [NAME] |  |  | [NAME]
 | 1 | 2009-01-01 00:00:00 | 2 | Rachel | 885
 | 1 | 2009-02-01 00:00:00 | 1 | [NAME] | 2345
 | 1 | 2009-02-01 00:00:00 | 2 | [NAME] | 456
 | 1 | 2009-03-01 00:00:00 | 1 | [NAME] | 1223
 | 2 | 2009-04-01 00:00:00 | 1 | Rachel | 2567
 | 2 | 2009-04-01 00:00:00 | 2 | [NAME] | 987 |  | [NAME] should show this
 | 2 | 2009-04-01 00:00:00 | 3 | [NAME] | 546 |  | Name | Sales
 | 2 | 2009-05-01 00:00:00 | 1 | [NAME] | 226 |  | [NAME] | 2879
 | 2 | 2009-05-01 00:00:00 | 2 | [NAME] | 60 |  | [NAME] | 2558
 | 2 | 2009-05-01 00:00:00 | 3 | [NAME] | 36 |  | [NAME] | 1401
 | 2 | 2009-05-01 00:00:00 | 4 | Rachel | 25 |  | Rachel | 1319
 | 2 | 2009-06-01 00:00:00 | 1 | [NAME] | 215 |  | [NAME] | 865
 | 2 | 2009-06-01 00:00:00 | 2 | [NAME] | 134
 | 3 | 2009-07-01 00:00:00 | 3 | Rachel | 120
 | 3 | 2009-07-01 00:00:00 | 4 | [NAME] | 24
 | 3 | 2009-07-01 00:00:00 | 5 | [NAME] | 13
 | 3 | 2009-08-01 00:00:00 | 1 | [NAME] | 2445
 | 3 | 2009-08-01 00:00:00 | 2 | [NAME] | 123
 | 3 | 2009-08-01 00:00:00 | 3 | [NAME] | 65
 | 3 | 2009-09-01 00:00:00 | 1 | [NAME] | 3457
 | 3 | 2009-09-01 00:00:00 | 2 | [NAME] | 1145
 | 3 | 2009-09-01 00:00:00 | 3 | [NAME] | 989
 | 3 | 2009-09-01 00:00:00 | 4 | [NAME] | 887
 | 3 | 2009-09-01 00:00:00 | 5 | Rachel | 776
 | 3 | 2009-09-01 00:00:00 | 6 | [NAME] | 456
 | 3 | 2009-09-01 00:00:00 | 7 | Todd | 123
 | 3 | 2009-09-01 00:00:00 | 8 | [NAME] | 43
 | 4 | 2009-10-01 00:00:00 | 1 | [NAME] | 1287
 | 4 | 2009-10-01 00:00:00 | 2 | [NAME] | 1134
 | 4 | 2009-10-01 00:00:00 | 3 | [NAME] | 676
 | 4 | 2009-10-01 00:00:00 | 4 | Rachel | 345
 | 4 | 2009-10-01 00:00:00 | 5 | [NAME] | 234
 | 4 | 2009-10-01 00:00:00 | 6 | [NAME] | 118
 | 4 | 2009-10-01 00:00:00 | 7 | [NAME] | 8
 | 4 | 2009-11-01 00:00:00 | 1 | [NAME] | 1190
 | 4 | 2009-11-01 00:00:00 | 2 | [NAME] | 1006
 | 4 | 2009-11-01 00:00:00 | 3 | Rachel | 974
 | 4 | 2009-11-01 00:00:00 | 4 | [NAME] | 631
 | 4 | 2009-11-01 00:00:00 | 5 | [NAME] | 408
 | 4 | 2009-11-01 00:00:00 | 6 | Todd | 345
 | 4 | 2009-11-01 00:00:00 | 7 | [NAME] | 264
 | 4 | 2009-11-01 00:00:00 | 8 | [NAME] | 113
 | 4 | 2009-11-01 00:00:00 | 9 | [NAME] | 9
 | 4 | 2009-12-01 00:00:00 | 1 | [NAME] | 876
 | 4 | 2009-12-01 00:00:00 | 2 | [NAME] | 402
 | 4 | 2009-12-01 00:00:00 | 3 | [NAME] | 3
Spreadsheet: 288880d1389331871-need-to-automate-find-delete-process-master_list
Sheet: Final list

List of Items Not available in Exception list
 | formula used here is array formula
 | Instead of pressing control and enter
 | you need to hold control and shift together and then hit enter and release all three keys
 | once formula is entered as array you can see curly braces surrounding your formula
 | "click A2 once and see the formula bar"
Spreadsheet: 766236d1643814801-multiple-if-statement-that-contains-a-search-and-lookup-element-test-1
Sheet: Raw1

PAC Job | Title | Job Type | Product Code
S167222 | [NAME] | AMD | DO - Door
[NAME] | [NAME] | NTR | BQ - PVC-U Barge, Facia or Soffit Board
S265086 | [NAME] and Precast – 00/3674 Inclusion of precast lintels - TRE | NTR | LP - PVC-U Cladding
S266193 | sdsdsssdsdsssssssssssssssssssssssssssss | REV | AF - Window and Door Hardware
S266224 | DFDF | STD | AW - Window & Door Accessories
S266605 | sdsdsssdsdsssssssssssssssssssssssssssss00/3665 | RVA | AW - Window & Door Accessories
S264890 | sdsdsssdsdsssssssssssssssssssssssssssss | ASS | WZ - Window Fabricators
S266803 | DFDF | STD | AF - Window and Door Hardware
S267009 | DFDF00/3675 | REV | RO - Rooflight
S266559 | DFDF | REV | AF - Window and Door Hardware
S167349 | DFDF | WER | WQ - A PVC-U system supplier that also fabricates
S266589 | sdsdsssdsdsssssssssssssssssssssssssssss | CTC | DZ - Door Fabricator
S265525 |  | ASS | RO - Rooflight
S266358 | sdsdsssdsdsssssssssssssssssssssssssssss | APS | VC - Vapour Control Layer
S266280 | fdsff | TRE | LA - Roofing (liquid-applied)
S167072 | sdsdsssdsdsssssssssssssssssssssssssssss00/3668 | ASS | SS - Sealing Strip
S266678 | sdsdsssdsdsssssssssssssssssssssssssssss | ASS | LA - Roofing (liquid-applied)
S167195 | sdsdsssdsdsssssssssssssssssssssssssssss | REV | LA - Roofing (liquid-applied)
S266434 | sdsdsssdsdsssssssssssssssssssssssssssss | ASS | SF - Roof Tile Underlay
S266701 | DGF | TRE | LA - Roofing (liquid-applied)
S265710 | sdsdsssdsdsssssssssssssssssssssssssssss | STD | LA - Roofing (liquid-applied)
S167009 | DFDF | NTR | SF - Roof Tile Underlay
S167116 | sdsdsssdsdsssssssssssssssssssssssssssss | ASS | SF - Roof Tile Underlay
S267061 | DFDF | TRE | RP - Roofing (roll form-polymeric)
S167265 | sdsdsssdsdsssssssssssssssssssssssssssss | TRE | RT - Roofing Tile
S266355 | sdsdsssdsdsssssssssssssssssssssssssssss | TRE | SF - Roof Tile Underlay
Spreadsheet: 147646d1332907061-separating-names-from-numbers-and-searching-for-key-words-help-example
Sheet: Sheet1

Report
Employee Name | Total Outstanding | Fixes | Less: Fix |  |  | Name | Date | Retailer | Comments
Employee AAA |  |  |  |  |  | Employee AAA (2 Outstanding)
Employee B
Employee CC |  |  |  |  |  | [NAME] | 2012-03-22 17:08:51 | Retailer | http://youtube.com cow chicken fix elephant spanner
Employee DDD |  |  |  |  |  | [NAME] | 2012-03-22 20:43:13 | Retailer | cow chicken elephant spanner
Employee E
Employee F |  |  |  |  |  | Employee B (4 Outstanding)
 |  |  |  |  |  | [NAME] | 2012-03-11 12:28:56 | Retailer | cow chicken elephant spanner
 |  |  |  |  |  | [NAME] | 2012-03-01 13:57:04 | Retailer | cow chicken elephant spanner
 |  |  |  |  |  | [NAME] | 2012-02-16 10:08:39 | Retailer | cow chicken elephant spanner
 |  |  |  |  |  | [NAME] | 2012-03-22 20:25:28 | Retailer | cow chicken fix elephant spanner http://youtube.com
 |  |  |  |  |  | Employee CC (4 Outstanding)
 |  |  | Data ------>
 |  |  |  |  |  | [NAME] | 2012-01-13 20:01:15 | Retailer | cow chicken elephant spanner
 |  |  |  |  |  | [NAME] | 2012-03-23 19:13:21 | Retailer | cow chicken elephant spanner
 |  |  |  |  |  | [NAME] | 2012-03-04 15:44:12 | Retailer | cow chicken fix elephant spanner http://youtube.com
 |  |  |  |  |  | [NAME] | 2012-01-09 12:55:53 | Retailer | cow chicken elephant spanner
 |  |  |  |  |  | Employee DDD (3 Outstanding)
 |  |  |  |  |  | [NAME] | 2012-03-10 13:09:39 | Retailer | cow chicken elephant spanner
 |  |  |  |  |  | [NAME] | 2012-03-09 19:27:40 | Retailer | http://youtube.com cow chicken fix elephant spanner
 |  |  |  |  |  | [NAME] | 2012-03-10 09:44:18 | Retailer | cow chicken elephant spanner
 |  |  |  |  |  | Employee E (1 Outstanding)
 |  |  |  |  |  | [NAME] | 2012-02-27 10:19:35 | Retailer | cow chicken fix elephant spanner http://youtube.com
 |  |  |  |  |  | Employee F (2 Outstanding)
 |  |  |  |  |  | [NAME] | 2012-03-19 14:27:29 | Retailer | cow chicken elephant spanner
 |  |  |  |  |  | [NAME] | 2012-01-31 09:36:41 | Retailer | cow chicken fix elephant spanner http://youtube.com
Spreadsheet: 5ccfeb2f-e042-4e2a-a0f3-d3a30c37a61b
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  |  |  |  |  |  |  |  | Protected Cells
Expected Yield |  |  |  |  | 200 |  |  |  |  | Data entry Cells
Measured ppm N in 4' of soil |  |  |  |  | 4
Percent of Organic Matter in soil |  |  |  |  | 0.02 |  |  |  | Table 1: Estimated Nitrozen Credit from Legumes and Other Crops
Legume Nitrozen Credits1 ([NAME] table 1) |  |  |  |  | 45 |  |  |  | Crops |  | N Fertilizer Reduction (lbs/acre)
Application Timing Adjustment Factor2 ([NAME] table 2) |  |  |  |  | 0.95 |  |  |  |  |  | Medium and Fine Textured Soils | [NAME]
Nitrogen Needed |  |  |  |  | 187.568 |  |  |  | Soybean |  | 45 | 35
Expected Price of Corn ($/bu) |  |  |  |  | 3.5 | Corn-Nitrozen price ratio |  | 7 | Dry Bean |  | 25 | 25
Fertilizer Cost ($/lb) |  |  |  |  | 0.5 |  |  |  | Alfalfa(70-100% stand, >4 plants/Sq.ft |  | 150 | 100
Given the Price [NAME] to Apply3 |  |  |  |  | 0.9359099999999999 |  |  |  | Alfalfa(30-69% stand, 1.5-4 plants/Sq.ft
 |  |  |  |  |  |  |  |  | Alfalfa(0-29% stand, <1.5 plants/Sq.ft
Amount of Nitrogen to Apply |  |  |  |  | 175.54676688 |  |  |  | Sweet clover and red clover |  | 80% of credit allowed for alfalfa
 |  |  |  |  |  |  |  |  | Sugar beets |  | 50 | 50
Difference Between Recomenndation and Needed (lbs) |  |  |  |  | 12.02123312000001
Difference in value |  |  |  |  | 6.010616560000003
Loss apptroximation |  |  |  |  | 2.003538853333334 |  |  |  | Table 2: Timing Adjustment Factors
Acres fertilized |  |  |  |  | 100 |  |  |  | Timing | Definition | Timing Ajustment Factor
 |  | Estimated loss |  |  | 200.3538853333334 |  |  |  | Split | At least 30 % of N  applied by sidedress and fertigation N | 0.95
 |  |  |  |  |  |  |  |  | Mostly pre plant | Less than 30 % sidedress and fertigation N and preplant N greater than fall N | 1
 |  |  |  |  |  |  |  |  | Mostly fall | Mostly fall applic N and less than 30 % sidedress and fertigation N | 1.05
1 | Preceding legume crops result in an imporved N supply. When corn follows a legume crop in rotation, the requirement of N is reduced by the legume N credit.
 | Estimated N credit from preceeding legume crop for medium and fine textured soils is 45 lbs/acre and for sandy soils 35 lbs/acre (table 1)
2 | Timing adjustment factor is used to adjust for either fall or split application, with spring application as the reference.  Use the adjacent table to pick the value reflecting your N application timing (table 2)
3 | Price factor is based on the diminishing effect of increasing N rate on corn yields. As N becomes less expensive raltive to corn price more N per busel yield increase can be profitably applied
 | Source: The calculator is based on Shapiro. C. A., [NAME], [NAME], [NAME] and [NAME]. " Fertilizer Suggestions for Corn". Unviversity of Nebraska-Lincoln Extension Publications EC 117.