tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 490081d1479652968-profit-and-loss-fifo-stock-trading-fifo-winner-test
Sheet: FIFO

BOS Trans Number | Date | Symbol | Buy | Sell | Price | [NAME]. | Net Qty. | Amt | Differential cost | [NAME] | [NAME] | [NAME] | Buy Seq | [NAME] | Profit/Loss | Match |  | Bal. Stock
111111111 | 2014-01-01 00:00:00 | AAPL | 25 |  | 100
111111112 | 2014-01-02 00:00:00 | AAPL | 25 |  | 101
111111113 | 2014-01-02 00:00:00 | AAPL | 32 |  | 98.25
111111114 | 2014-01-02 00:00:00 | AAPL |  | 47 | 98
111111115 | 2014-01-03 00:00:00 | AAPL | 49 |  | 99.73
111111116 | 2014-01-03 00:00:00 | AAPL |  | 53 | 100.91
111111117 | 2014-01-03 00:00:00 | CSCO | 30 |  | 31.25
111111118 | 2014-01-03 00:00:00 | CSCO | 32 |  | 30
111111119 | 2014-01-03 00:00:00 | CSCO |  | 42 | 28.23
111111120 | 2014-01-03 00:00:00 | IBM | 10 |  | 150.63
111111121 | 2014-01-03 00:00:00 | IBM | 48 |  | 145.32
111111122 | 2014-01-04 00:00:00 | IBM | 10 |  | 145.68
111111123 | 2014-01-04 00:00:00 | IBM | 100 |  | 146.02
111111124 | 2014-01-04 00:00:00 | IBM |  | 21 | 151.89
111111125 | 2014-01-04 00:00:00 | IBM |  | 65 | 132.16
111111126 | 2014-01-04 00:00:00 | TSLA | 40 |  | 182.55
111111127 | 2014-01-05 00:00:00 | TSLA | 84 |  | 179.63
111111128 | 2014-01-05 00:00:00 | TSLA |  | 68 | 154.22
Spreadsheet: 786126d1657005047-using-the-large-function-without-considering-duplicate-values-book2
Sheet: Sheet1

365127190 |  |  |  | 9145510622
915816692 |  |  |  | 8878032468
365127190 |  |  |  | 7797758785
595169365 |  |  |  | 7086006865
38119217 |  |  |  | 4996689978
159202626 |  |  |  | 3217419368
342296082 |  |  |  | 1488670241
365127190 |  |  |  | 1343356468
7872490 |  |  |  | 1317376948
31122055 |  |  |  | 1303593960
440787986 |  |  |  | 1118096063
202891144 |  |  |  | 1098062724
30940017 |  |  |  | 1086793117
49525218 |  |  |  | 1085254096
49525218 |  |  |  | 915816692
32265352 |  |  |  | 901666701
191621737 |  |  |  | 783891480
90187210 |  |  |  | 763111536
0 |  |  |  | 751522124
0 |  |  |  | 650784770
0 |  |  |  | 608017387
0 |  |  |  | 595169365
0 |  |  |  | 583448488
251726531 |  |  |  | 524845955
116310275 |  |  |  | 505282225
77192542 |  |  |  | 440883438
141096578 |  |  |  | 440787986
17244384 |  |  |  | 439968851
80307709 |  |  |  | 365127190
41656295 |  |  |  | 342296082
41656295 |  |  |  | 321449766
41656295 |  |  |  | 316261499
99214949 |  |  |  | 315953693
107403574 |  |  |  | 251726531
27713602 |  |  |  | 202891144
30487576 |  |  |  | 191621737
12778228 |  |  |  | 159202626
24331257 |  |  |  | 141096578
0 |  |  |  | 116310275
0 |  |  |  | 107403574
0 |  |  |  | 99214949
0 |  |  |  | 90187210
0 |  |  |  | 80307709
12194397 |  |  |  | 78408252
12509571 |  |  |  | 77192542
0 |  |  |  | 68382806
7664497 |  |  |  | 49525218
9677781 |  |  |  | 41656295
10405862 |  |  |  | 38119217
107403574 |  |  |  | 32265352
3307167 |  |  |  | 31122055
4483842 |  |  |  | 30940017
3560026 |  |  |  | 30487576
1620740 |  |  |  | 27713602
302142 |  |  |  | 24331257
2180982 |  |  |  | 17244384
295391 |  |  |  | 12778228
193142 |  |  |  | 12509571
204385 |  |  |  | 12194397
115744 |  |  |  | 10405862
8878032468 |  |  |  | 9677781
7086006865 |  |  |  | 7872490
9145510622 |  |  |  | 7664497
9145510622 |  |  |  | 4483842
9145510622 |  |  |  | 3560026
7797758785 |  |  |  | 3307167
4996689978 |  |  |  | 2813019
3217419368 |  |  |  | 2180982
1086793117 |  |  |  | 1620740
78408252 |  |  |  | 302142
1303593960 |  |  |  | 295391
901666701 |  |  |  | 204385
650784770 |  |  |  | 193142
1488670241 |  |  |  | 115744
439968851
0
68382806
2813019
440883438
440883438
1343356468
751522124
1085254096
763111536
783891480
0
0
1317376948
321449766
1118096063
524845955
315953693
315953693
1098062724
583448488
0
608017387
316261499
505282225
107403574
Spreadsheet: 00f787bf-68b9-42b6-9b7f-c82b4ccd81c3
Sheet: Participant

Reserve Market Customer Charges Report
SR_RSVCHG_<customer [NAME]
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 |  | [NAME] |  |  |  |  | Forward Reserve |  | RT Reserve
Trading Interval | Product Type | [NAME] | [NAME] | Participant Real-Time Load Obligation | Reserve Designation - ARDs | Reserve Charge Allocation MWs | Forward Reserve Charge Rate | Forward Reserve Charge | Real-Time Reserve Charge Rate | Real-Time Reserve Charge | External Sale Load Obligation MW (CETICZ or FCA Cleared Export)
Hour End | String | Number | String | MWh | MWh | MWh | $/MWh | $ | $/MWh | $ | MWh
Spreadsheet: 830685d1685033018-2-or-more-same-numbers-counting-2-or-more-same-numbers
Sheet: Φύλλο1

total |  |  | total
4 |  |  | 3
1 |  |  | 2
0 |  |  | 2 | 1
1 | 1 |  | 2
1 |  |  | 1
2 |  |  | 0
2 | 2 |  | 0 | 2
2 |  |  | 1
2 |  |  | 2
1 | 3 |  | 1
1 |  |  | 2
2 |  |  | 0
1 |  |  | 1
0 | 4 |  | 1 | 3
0 |  |  | 1
Spreadsheet: 88939d1288743480-how-to-compare-6-columns-and-identify-matches-excel-example-workbook
Sheet: Sheet1

Student ID | First Name | Last Name |  | Student ID | First Name | Last Name
1234567 | [NAME] | Smith |  | 7654321 | [NAME] | Jones
2345678 | [NAME] | Adams |  | 1234567 | [NAME] | Smith
3456789 | Chad | [NAME] |  | 9876543 | Trevor | [NAME]
4567890 | [NAME] | Jones |  | 987654 | [NAME] | [NAME]
5678901 | [NAME] | Tripp |  | 1098765 | [NAME] | [NAME]
6789012 | [NAME] | [NAME] |  | 5678901 | [NAME] | Tripp
7890123 | Greg | Finley |  | 3210987 | Greg | Watts
8901234 | [NAME] | [NAME] |  | 4321098 | Chad | [NAME]
9012345 | [NAME] | Watts |  | 8901234 | [NAME] | [NAME]
Spreadsheet: 771590d1646748027-look-up-a-column-with-duplicates-and-return-from-multiple-specified-columns-book1
Sheet: Sheet1

Product ID | Colour | Weight | # ID | % Value | Origin |  |  | Desired Results
111 | Green |  |  |  |  |  |  | Proudct ID | Colour | # ID | % Value | Weight | Origin
222 | Blue |  |  |  |  |  |  | 111
333 | Red |  |  |  |  |  |  | 222
444 | Yellow |  |  |  |  |  |  | 333
555 |  | 1mg | #6543 |  |  |  |  | 444
222 |  | 2mg | #655 |  |  |  |  | 555
333 |  | 3mg | #656
111 |  | 4mg | #657
444 |  | 5mg | #658
111 |  |  |  | 0.5 | China
333 |  |  |  | 0.3 | Australia
444 |  |  |  | 0.4 | USA
555 |  |  |  | 0.55 | UK
222 |  |  |  | 0.99 | UAE
Spreadsheet: 139691d1328384818-excel-2007-conditional-summary-of-prices-healthy-texas-coverage-rate-spreadsheet-ee-and-dep-contributions
Sheet: Sheet1

Medical Rates | Percent ER Contribution | Employee Class | FTEs | PTEs | HSA2500/80% | BAL25/2500/70% | BAL20/2000/80% | BAL25/1500/80% | TRAD25/500/80%
FT EE Premium | 0.5 | Single Employee (EE) | 2 | 0 | 139.23 | 154.6 | 169.67 | 186.84 | 228.25
FT Dep. Premium | 0.5 | Employee + Spouse (ES) | 0 | 0 | 306.31 | 340.12 | 373.27 | 411.04 | 502.15
PT EE Premium | 0.5 | Employee + Child(ren) (EC) | 1 | 0 | 264.54 | 293.74 | 322.37 | 355 | 433.68
PT Dep. Premium | 0.5 | Employee + Family (EF) | 2 | 0 | 456.12 | 506.46 | 555.82 | 612.08 | 747.74
Dental Rates | Percent ER Contribution | Employee Class | FTEs | PTEs | A8016 | A7976 | A7977
FT EE Premium | 0.5 | Single Employee (EE) |  |  | 23.2 | 26.71 | 39.79
FT Dep. Premium | 0.5 | Employee + Spouse (ES) |  |  | 46.4 | 53.42 | 79.58
PT EE Premium | 0.5 | Employee + Child(ren) (EC) |  |  | 48.55 | 55.9 | 83.27
PT Dep. Premium | 0.5 | Employee + Family (EF) |  |  | 74.11 | 85.32 | 127.1
Vision Rates | Percent ER Contribution | Employee Class | FTEs | PTEs | V1012 | V1010
FT EE Premium | 1 | Single Employee (EE) |  |  | 7.6 | 8.57
FT Dep. Premium | 1 | Employee + Spouse (ES) |  |  | 15.58 | 17.57
PT EE Premium | 1 | Employee + Child(ren) (EC) |  |  | 16.34 | 18.43
PT Dep. Premium | 1 | Employee + Family (EF) |  |  | 23.56 | 26.57
Basic Life/AD&D Rates | Percent ER Contribution | Employee Class | FTEs | PTEs | Flat $20,000 | Flat $30,000 | Flat $40,000 | Flat $50,000 | 2X Salary
EE Premiums | 0.25 | All Employees |  |  | 30.8 | 70 | 119 | 168 | 198
Withholding | / Employee Class | Employee Class | FTEs | PTEs | HSA2500/80% | BAL25/2500/70% | BAL20/2000/80% | BAL25/1500/80% | TRAD25/500/80%
 |  | Single Employee (EE)
 |  | Employee + Spouse (ES)
 |  | Employee + Child(ren) (EC)
 |  | Employee + Family (EF)
 |  | Employer (ER)
 |  | Total Monthly Invoice Amt.
 |  | Checksum
Spreadsheet: 676006d1588603957-counting-a-row-if-a-word-repeats-3-or-more-times-in-the-cells-of-that-row-asn-playabout
Sheet: Sheet1

Forename | Surname | School name | ASN Need Level 1 | ASN Need Level 2 | ASN Need Level 3 | ASN Need Level 4 | ASN Need Level 5
[NAME] | Bing | [NAME] | High | Medium | High | High | High
[NAME] | Hinge | Drum Academy | Medium | Low | Medium | Medium | Low
Ivor | Biggun | Synth Secondary | Low | High | Low | Low | High
Betty | Swallocks | [NAME] | High | Low | High | High | Low
Candice | Spenser | Synth Secondary | Medium | Medium | Medium | High | High
[NAME] | Morrow | Drum Academy | High | Low |  | High | High
[NAME] | Day | Synth Secondary | High | High | High | High | Medium
[NAME] | Jams | Drum Academy | High | Medium | High | Medium | High
[NAME] | Less | [NAME] | Low | Low | Medium | Medium | Medium
Ewan | King | [NAME] | High | High | High |  | High
Jo | King | Synth Secondary |  | Medium |  | Medium | Medium
Rose | [NAME] | [NAME] | High | High | High | Low | Low
[NAME] | Yup | Drum Academy | High | Low | Medium | Medium | Medium
[NAME] | Neave | Synth Secondary | Medium | Medium |  | Medium | Medium
Hugh | [NAME] | [NAME] | Low | Low | Low |  | Low
 | Bing | [NAME]
Betty | Swallocks | [NAME]
[NAME] | Morrow | Drum Academy
[NAME] | Day | Synth Secondary
[NAME] | Jams | Drum Academy
Ewan | King | [NAME]
Rose | [NAME] | [NAME]
Spreadsheet: chris_germany__2912__Plant Fuel 02 2000
Sheet: Nov 99

Date | lbs 1CT oil | lbs 1 DB oil | lbs 2 CT oil | lbs 2 DB oil | lbs Aux. Blr oil | daily oil mmbtu | daily oil gallons | Fuel Tank Level | Oil Deliv. Gallons | Trucks | lbs 1 CT gas | lbs 1 DB gas | lbs 2 CT gas | lbs 2 DB gas | lbs Aux. Blr gas | Daily gas mmbtu
1999-11-01 00:00:00
1999-11-02 00:00:00
1999-11-03 00:00:00
1999-11-04 00:00:00
1999-11-05 00:00:00
1999-11-06 00:00:00
1999-11-07 00:00:00
1999-11-08 00:00:00
1999-11-09 00:00:00
1999-11-10 00:00:00
1999-11-11 00:00:00
1999-11-12 00:00:00
1999-11-13 00:00:00
1999-11-14 00:00:00
1999-11-15 00:00:00
1999-11-16 00:00:00
1999-11-17 00:00:00
1999-11-18 00:00:00
1999-11-19 00:00:00
1999-11-20 00:00:00
1999-11-21 00:00:00
1999-11-22 00:00:00
1999-11-23 00:00:00
1999-11-24 00:00:00
1999-11-25 00:00:00
1999-11-26 00:00:00
1999-11-27 00:00:00
1999-11-28 00:00:00
1999-11-29 00:00:00
1999-11-30 00:00:00
mmbtu
gallons
Spreadsheet: chris_stokley__3986__Enron True-Upcorrect
Sheet: Sheet1

Harbor True-Up Action Itens
 |  |  |  |  |  | Day Ahead less Gas | ISO | Services Desk Profit | Total | Payments | Net
July '00
 |  |  |  |  |  |  | 1683012.18 |  |  | 3179331.16
 |  |  |  | Gas Annuity = |  | 1336995.67
 |  |  |  | Services Desk Annuity = |  | 12843.83
 |  |  |  | EnPower Net
Aug
1.  Enter annuity deal for Services Desk Profit |  |  |  |  |  |  | 2033138.06 | 143934.91 |  | 3412253.44
 |  |  |  | Gas Annuity = |  | 2211292.1
 |  |  |  | Services Desk Annuity =
 |  |  |  | EnPower Net
Sep
1  Wait on ISO completion later this week and enter in |  |  |  |  |  |  | 760530.99 | 73284.24 |  | 1032095.36
ISO deal |  |  |  | Gas Annuity = |  | 1696221.18
2.  Recalc Services Profit |  |  |  | Services Desk Annuity =
2.  Reverse annuity in system (#442268) |  |  |  | EnPower Net
3.  Enter annuity deal for Services Desk Profit
Oct |  |  |  |  |  |  | 192228.4 | 6000.2 |  | 371091.21
1.  Pay Day Ahead Amount less gas
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
Nov |  |  |  |  |  |  | -413255 | 11678.68 |  | 410000
1.  Pay Day Ahead Amount less gas
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
5.  Reverse Annuity Deals(# 460487, 460482, 482864, 461206, 462174)
Dec
1.  Pay Day Ahead Amount less gas |  |  |  |  |  |  |  | 0 |  | 0
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
Jan
1.  Pay Day Ahead Amount less gas |  |  |  |  |  |  | 16401.56 | 20495.69 |  | 669376.7
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
Feb
1.  Pay Day Ahead Amount less gas |  |  |  |  |  |  | 11787 | 0 |  | 27298.16
2.  Complete ISO True-Up
3.  Recalc. Services Profit
4.  Enter Services Annuity
Spreadsheet: 88712d1288572706-creating-monthly-cost-schedule-dummy-workbook
Sheet: Annual

Development Costs |  | 2010 | Start | 2011 | Start | 2012 | Start | 2013 | Start | 2014 | Start |  | Total
Analysis |  | 20000 | Q2 | 0 | Q3 | 90000 | Q3 | 50000 | Q2 | 150000 | Q3
Development |  | 1000000 | Q2 | 1200000 | Q4 | 1200000 | Q3 | 0 | Q3 | 0 | Q4
Total Development Costs
Spreadsheet: 777998d1650768747-work-shifts-with-monthly-update-works-berna11-
Sheet: Foglio1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Networkdays | Start | End
 |  |  | M | M | P | P | N | N |  | R | R | M |  | M1 |  | 1 |  | N2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | M2 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | P1 |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | P2 |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | N1 |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | N2 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | R1 |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | R2 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
Spreadsheet: 795057d1662480812-sum-range-between-two-index-matched-values-from-column-index-and-match-help-ans
Sheet: Sheet1

 | ABC | DEF | GHI | JKL |  |  |  | GHI | ABC | JKL | DEF |  |  |  |  |  | GHI | ABC | JKL | DEF
900000 | 1 | 2 | 3 | 4 |  | 900000 | 900200 |  |  |  |  |  |  |  | 900000 | 900200 | 21 | 15 | 24 | 18
900100 | 5 | 6 | 7 | 8
900200 | 9 | 10 | 11 | 12 |  | 900100 | 900500 |  |  |  |  |  |  |  | 900100 | 900500 | 75 | 65 | 80 | 70
900300 | 13 | 14 | 15 | 16
900400 | 17 | 18 | 19 | 20
900500 | 21 | 22 | 23 | 24
Spreadsheet: 026c1086-3e9a-4797-8d97-27a87012f827
Sheet: Sheet1

Schedule B (Sample Worksheet) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  |  | Commercial Run Contract
 |  |  | (Taxi, UTA)
 | First Semester/Quarter |  |  |  | Second Semester/Quarter
Student Name | Date | [NAME] | Dollar Amount | Vendor/ Check Number | Date | [NAME] | Dollar Amount | Vendor/ Check Number | Total
 |  |  |  |  |  |  |  |  | Grand Total:
Spreadsheet: 36385d1234273016-count-cells-if-they-contain-a-month-sample
Sheet: Sheet1

2009-02-10 11:53:08
2009-02-10 11:53:08 |  |  |  | Number
2009-02-11 11:53:08 |  |  | 2009-01-01 00:00:00 | 0
2009-02-12 11:53:08 |  |  | 2009-02-01 00:00:00 | 4
2009-03-08 11:53:08 |  |  | 2009-03-01 00:00:00 | 6
2009-03-09 11:53:08 |  |  | 2009-04-01 00:00:00 | 4
2009-03-10 11:53:08 |  |  | 2009-05-01 00:00:00 | 0
2009-03-11 11:53:08 |  |  | 2009-06-01 00:00:00 | 0
2009-03-12 11:53:08 |  |  | 2009-07-01 00:00:00 | 0
2009-03-13 11:53:08 |  |  | 2009-08-01 00:00:00 | 0
2009-04-03 11:53:08 |  |  | 2009-09-01 00:00:00 | 0
2009-04-04 11:53:08 |  |  | 2009-10-01 00:00:00 | 1
2009-04-05 11:53:08 |  |  | 2009-11-01 00:00:00 | 0
2009-04-06 11:53:08 |  |  | 2009-12-01 00:00:00 | 0
2009-10-06 12:54:00
Spreadsheet: 146863d1332389019-count-if-help-countif
Sheet: HaiPhong

 | Product and Code | Price
 | Bike
 | HaiPhongB01 | 1000
 | HaiPhongB02 | 4000
 | HaiPhongB03 | 10000
 | Car
 | HaiPhongC01 | 50000
 | HaiPhongC02 | 80000
 | HaiPhongC03 | 90000
 | BMWHaiPhongC04
 | HuyndaiHaiPhongC05
 | House
 | HaiPhongH01 | 2000000
 | HaiPhongH02 | 10000000
 | HaiPhongH03 | 4000000
Spreadsheet: ae7f66b1-1278-44c4-85a9-1923e7aaca04
Sheet: SLUR-2

FORM SLUR-2 |  |  |  |  | Slurry and Sludge Application Field Records
 |  |  |  |  | One Form for Each Field per Crop Cycle
 | Tract # |  |  |  |  | Field #
 | Field Size(Wetted Acres)=(A) |  |  |  |  | Facility Number
 | Farm Owner |  |  |  |  | Spreader Operator
 | Owner's Address |  |  |  |  | and Address
 | Owner's Phone # |  |  |  |  | Operator's Phone #
 |  |  |  |  | From Animal Waste Management Plan
 | Crop Type |  |  |  |  | Recommended PAN
 |  |  |  |  |  | Loading (lb/acre) = (B)
 | (1) | (2) | (3) | (4) | (5) | (6) | (7) | (8)
 |  | Number | Volume of | Total Volume | Volume per Acre | Waste Analysis | PAN Applied | [NAME]***
****Nutrient | Date | of Loads | each Load* | (gallons) | (gallons/acre) | PAN** | (lb/acre) | (lb/acre)
Source | (mm/dd/yr) | per Field | (gallons) | (2) x (3) | (4) / (A) | ([NAME] gal) | (6) x (5) / 1000 | (B) - (7)
 |  |  |  |  |  |  |  | B=
 |  |  | Crop Cycle Totals:
 | Owners Signature |  |  |  |  | Spreader Operator's Signature
 | Certified Operator (print) |  |  |  |  | Operator Certification No.
*  Can be found in operator's manual for the spreader.  Contact a local dealer if you do not have your owner's manual.
** See your waste management plan for sampling frequency.  At a minimum, waste analysis is required within 60 days of land application events.
***Enter the value received by subtracting column (7) from (B).  Continue subtracting column (7) from column (8) following each application event.
***Enter nutrient source (ie. Lagoon/Storage Pond ID, commerical fertilizer, dry litter, etc.) |  |  |  |  |  |  |  |  | 2006-12-20 00:00:00
Spreadsheet: 273638d1382809382-solved-ignoring-error-cells-in-final-sum-formula-product-table-dbz-err-1-
Sheet: OBJEKT (2)

PRODUCT | NUMBER OF PRODUCTS ON SHELF | PERCENTAGE OF  TAKEN SHELVES | POINTS | SPACE TAKEN BY PACKAGES IN STOREHOUSE (m²) | PERCENTAGE OF TAKEN SPACE IN STOREHOUSE | P      O        I        N       T        S | HAS CONTENT  I. | P      O        I        N       T        S | PRICE | P      O        I        N       T        S
TOTAL
PRODUCT A | 4 |  |  | 1.5 |  |  | YES |  | 2.98
PRODUCT B | 13 |  |  | 0 |  |  | NO |  | 6.79
PRODUCT C | 10 |  |  | 4 |  |  | NOT YET |  | 5.29
PRODUCT D | 0 |  |  | 0.1 |  |  |  |  | 3.99
PRODUCT E | 42 |  |  | 1 |  |  | YES |  | 3.99
PRODUCT F | 2 |  |  | 0 |  |  | YES |  | 4.49
PRODUCT G | 7 |  |  | 7 |  |  |  |  | 4.45
 |  |  |  |  |  |  |  |  | OR
How to give points: | EXPLANATION |  |  |  |  |  | POINTS
PERCENTAGE OF  TAKEN SHELVES                      (D column) | 1 - 10% |  |  |  |  |  | 0.5 |  | 6.79 | 0
 | 10 - 50% |  |  |  |  |  | 1 |  | 6.79 | 0
 | 50 - 100% |  |  |  |  |  | 1.5 |  | 5.29 | 0
PERCENTAGE OF TAKEN SPACE IN STOREHOUSE  (G column) | 1 - 25% |  |  |  |  |  | 0.5 |  | 3.49 | 1
 | 25 - 50% |  |  |  |  |  | 1 |  | 3.99 | 0
 | 50 - 100% |  |  |  |  |  | 1.5 |  | 4.49 | 0
HAS [NAME] (I column) | 'YES'' |  |  |  |  |  | 1 |  | 4.45 | 0
 | ANYTHING EXCEPT  ''YES'' |  |  |  |  |  | 0
PRICE  (K column) | LOWEST PRICE THAT IS LOWER BY LESS THAN 1 OF NEXT  LOWEST PRICE |  |  |  |  |  | 1 |  | OR
 | LOWEST PRICE THAT IS LOWER BY MORE THAN 1 OF NEXT  LOWEST PRICE |  |  |  |  |  | 2
HAS CONTENT II.   (M column) | WHATEVER IS WRITTEN |  |  |  |  |  | 0.5
 | IF IT'S EMPTY |  |  |  |  |  | 0
HAS CONTENT III.   (O column) | WHATEVER IS WRITTEN |  |  |  |  |  | 1
 | IF IT'S EMPTY |  |  |  |  |  | 0 |  | 6.79 | 0
 |  |  |  |  |  |  |  |  | 6.79 | 0
 |  |  |  |  |  |  |  |  | 5.29 | 0
 |  |  |  |  |  |  |  |  | 3.99 | 1
 |  |  |  |  |  |  |  |  | 3.99 | 1
 |  |  |  |  |  |  |  |  | 4.49 | 0
 |  |  |  |  |  |  |  |  | 4.45 | 0
 |  |  |  |  |  |  |  |  | OR
 |  |  |  |  |  |  |  |  | 2.98 | 2
 |  |  |  |  |  |  |  |  | 6.79 | 0
 |  |  |  |  |  |  |  |  | 5.29 | 0
 |  |  |  |  |  |  |  |  | 3.99 | 0
 |  |  |  |  |  |  |  |  | 3.99 | 0
 |  |  |  |  |  |  |  |  | 4.49 | 0
 |  |  |  |  |  |  |  |  | 4.45 | 0
Spreadsheet: 454646d1459929010-organizing-data-from-one-sheet-to-others-organize_data
Sheet: TODOS

Color | Shift | Date | Brand | Cars | Liters
Orange | W | 2015-01-09 00:00:00 | RENAULT | 8 | 10
- | B | 2015-01-29 00:00:00 | VW | 4 | 6
Blue | C | 2015-02-05 00:00:00 | VW | 7 | 10
Orange | W | 2015-02-13 00:00:00 | SEAT | 9 | 10
- | A | 2015-03-06 00:00:00 | VW | 3 | 7
Red | A | 2015-03-20 00:00:00 | SEAT | 8 | 9
Yellow | W | 2015-04-17 00:00:00 | RENAULT | 10 | 10
Orange | B | 2015-04-28 00:00:00 | MERCEDES | 8 | 8
- | A | 2015-05-19 00:00:00 | VW | 5 | 9
Blue | B | 2015-06-09 00:00:00 | RENAULT | 9 | 9
Orange | A | 2015-06-18 00:00:00 | VW | 4 | 4
Blue | A | 2015-07-09 00:00:00 | RENAULT | 10 | 4
Yellow | A | 2015-07-10 00:00:00 | SEAT | 8 | 8
- | A | 2015-07-17 00:00:00 | VW | 8 | 9
Blue | A | 2015-07-21 00:00:00 | RENAULT | 10 | 10
Yellow | B | 2015-08-07 00:00:00 | MERCEDES | na | 7
Orange | A | 2015-08-20 00:00:00 | MERCEDES | 5 | 5
Red | W | 2015-08-21 00:00:00 | SEAT | 8 | 10
- | B | 2015-08-31 00:00:00 | VW | 10 | 10
Red | C | 2015-09-10 00:00:00 | SEAT | 9 | 9
Red | B | 2015-09-30 00:00:00 | RENAULT | 8 | 10
Red | B | 2015-09-30 00:00:00 | SEAT | 9 | 10
Yellow | A | 2015-10-19 00:00:00 | MERCEDES | 7 | 9
Yellow | A | 2015-10-19 00:00:00 | VW | 9 | 9
Yellow | A | 2015-10-29 00:00:00 | RENAULT | 10 | 10
Green | A | 2015-11-18 00:00:00 | SEAT | 9 | 9
Green | A | 2015-11-26 00:00:00 | RENAULT | 8 | 8
Spreadsheet: 28a74028-99c6-4bf5-b100-357f9c23dd33
Sheet: VAR Settlement

OATT Schedule 2 - VAR Settlement Summary Report
SR_VARSTL_<customer id>_<settlement_date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Credits |  |  |  | Charges
Customer Cost of Energy Produced Credits | Customer Cost of Energy Consumed Credits | Customer Lost Opportunity Cost Credits | Customer VAR Capacity Cost Credits | Customer VAR Variable Cost Charges | Customer VAR Capacity Cost Charges | Net Settlement
$ | $ | $ | $ | $ | $ | $
Spreadsheet: 44789a19-ea23-45cf-af53-327e1b442ad3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  |  |  | extension.psu.edu/fruit-production
 |  |  |  |  |  |  | Apple Target Fruit Calculator
 |  |  |  |  |  |  | by [NAME]
 |  |  |  | Directions:
 |  |  |  | 1) | enter values in red text only
 |  |  |  | 2) | enter the values for your desired yield in bu/acre and desire % field cullage
 |  |  |  | 3) | designate the row spacing for the block being studied and indicate the desired return on investment
 |  |  |  | 4) | in column D '% target fruit' indicate your desired size distribution
 |  |  |  | 5) | in column I 'FOB price' indicate the price you expect your apples to sell for in the specified sizes
 |  |  |  | 6) | in the column 'Pack Chage', enter the amount charged for packing/handling specified fruit sizes
 |  |  |  | 6) | view economic analysis provided in the light yellow box
 |  |  |  | 7) | the 'graph' tab graphs the size distribution you specified
 |  | Disclaimer: The accuracy and predictions of fruit production calculators are based on certain cost measures and practices, all results may not be applicable to all opeartions. For more information contact [NAME], [EMAIL], or [NAME], [EMAIL].