tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 01d90fe8-3b88-404f-8cf2-3d272f038a3e
Sheet: Sheet1

JANUARY | Units are no longer allowed to bring their own firewood to camp | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
CHARTS ARE UPDATED DAILY. FOR UP TO THE MINUTE AVAILABILITY CALL (716) 891-4073 OR E-MAIL [EMAIL] |  |  |  |  |  |  | 2014-01-24 00:00:00
SCHOELLKOPF |  |  |  | 2014 | 2014 | 2014 | 2014
 | Capacity | Code | FEE | JAN 3 - 5 | JAN 10 - 12 | JAN 17 - 19 | JAN 24 - 26
District/Council Events
**Phillip (Lower) | 8 | S,W,E | 48 |  | T513 1/4W | T659
**Schoellkopf (Upper) | 12 | S,W,E | 72 |  | T513 1/4W | T523
Schwartz | 14 | S,W | 70 |  | T107 | T816 W
Score | 18 | S,W,E | 108 | [NAME] | T864 W | T510 W
**Self | 12 | S,W,E | 72 |  | T401 OC W | [NAME]
Sikes | 16 | S,W,E,C | 96 | [NAME] | T507 W | T890 W
**Toulmin | 18 | S,W,E | 108 | T599 W | T58 W | [NAME]
Lean-To's
**Art Wood (Flats) | 12 | W | 48
**[NAME] (Northwoods) | 12 | W | 48
**Seibel (Northwoods) | 12 | W | 48
**Faso (Meyer Village) | 12 | W | 48 |  |  | T352 W
**[NAME] (Meyer Village) | 12 | W | 48 |  |  | T352
**[NAME] (Meyer Village) | 12 | W | 48 |  |  | T6064 (Sat)
Troop 7 Shelter | 20 | S,W,E | 96 |  | T593 W | T659 W
**Szymkowiak lean-to | 12 | W, E | 72
Tenting $2 per person, per night
Tenting $2 per person, per night
Tenting $2 per person, per night
Day Hike $2 per person
**SEASONAL [NAME] MAY BE CLOSED FOR VEHICLE TRAFFIC, PLEASE CONTACT THE RANGER AT [PHONE]
SCOUTHAVEN |  |  |  | 2014 | 2014 | 2014 | 2014
 | Capacity | CODE | FEE | JAN 3 - 5 | JAN 10 - 12 | JAN 17 - 19 | JAN 24 - 26
District/Council Events |  |  |  |  |  |  | OKPIK
[NAME] | 20 | S,W,E | 120 |  |  | T506 1/4W
Loegler 1 | 20 | C,S,W,E | 120 | [NAME] | [NAME] | T411 W | OKPIK (F)
Loegler 2 | 20 | C,S,W,E | 120 | P416 | T735 W |  | OKPIK (F)
[NAME] | 30 | C,S,W,E | 180 | P416 | T85 W | T286 W | P620 W
Lean-To's
#1 Eagle | 12 | W | 48 |  | T184 W | T539 W | T500 W
#2 Whitetail | 12 | W | 48 |  |  |  | T500 W
#3 Dziedzic | 12 | W | 48 |  |  | [NAME] 1/4 W
Moose | 10 | W | 40 |  |  | T664 W
Boss | 12 | W | 48 | T416
Lakeside |  |  |  |  |  |  | OKPIK
Tenting $2 per person, per night |  |  |  |  |  |  |  |  | 4
Tenting $2 per person, per night
Day Hike $2 per person
 |  |  |  | 2014 | 2014 | 2014 | 2014
[NAME] | Capacity | CODE | FEE | JAN 3 - 5 | JAN 10 - 12 | JAN 17 - 19 | JAN 24 - 26
District/Council Events
Cabin #1  (Porch) | 24 | S,W,E | 144 |  | P3044 1/4W
Cabin #2 | 24 | S,W,E | 144 |  | P3044 1/4W
Leader's Lodge | 28 | S,W,E | 168 | [NAME] | T618 W | [NAME]
[NAME] | 30 | C,S,W,E | 180 |  | T92 W | T483 W | P539 W
Stone Lean-To | 6 | [NAME] | 24
Troop 107 Lean-To | 8 | W | 30 |  | T931 W
*New  Ganosote Lean-To | 12 | W | 48 |  |  | T431 W | T824 W
*New Tuscarora Lean-To | 12 | W | 48 |  |  | T431
Tenting $2 per person, per night
Tenting $2 per person, per night
Tenting $2 per person, per night
Day Hike $2 per person
Code: S=Cooking Stove; W=Wood Heating Stove; E=Electricity; C=Co-Ed Ready
Firewood is $50.00 per 1/2 face cord.
Spreadsheet: 685798d1594205072-last-6-months-rolling-sum-2020-07-08-oeldere-willhh3-pbi-685717d1594152040-last-6-months-rolling-sum-rolling-sum
Sheet: Blad2

Name | month | value
[NAME] | 2020-01-01 00:00:00 | 1
[NAME] | 2020-02-01 00:00:00 | 0
[NAME] | 2020-03-01 00:00:00 | 0
[NAME] | 2020-04-01 00:00:00 | 0 |  |  |  |  |  | Rijlabels | Som van value | Som [NAME]
[NAME] | 2020-05-01 00:00:00 | 1 |  |  |  |  |  | jan | 6 | 6
[NAME] | 2020-06-01 00:00:00 | 0 |  |  |  |  |  | feb | 10 | 16
[NAME] | 2020-07-01 00:00:00 | 0 |  |  |  |  |  | mrt | 35 | 51
[NAME] | 2020-08-01 00:00:00 | 0 |  |  |  |  |  | apr | 46 | 97
[NAME] | 2020-09-01 00:00:00 | 0 |  |  |  |  |  | mei | 33 | 130
[NAME] | 2020-10-01 00:00:00 | 0 |  |  |  |  |  | jun | 16 | 146
[NAME] | 2020-11-01 00:00:00 | 0 |  |  |  |  |  | jul | 0 | 146
[NAME] | 2020-12-01 00:00:00 | 0 |  |  |  |  |  | aug | 0 | 146
Sue | 2020-01-01 00:00:00 | 0 |  |  |  |  |  | sep | 0 | 146
Sue | 2020-02-01 00:00:00 | 5 |  |  |  |  |  | okt | 0 | 146
Sue | 2020-03-01 00:00:00 | 0 |  |  |  |  |  | nov | 0 | 146
Sue | 2020-04-01 00:00:00 | 0 |  |  |  |  |  | dec | 0 | 146
Sue | 2020-05-01 00:00:00 | 0 |  |  |  |  |  | Eindtotaal | 146
Sue | 2020-06-01 00:00:00 | 0
Sue | 2020-07-01 00:00:00 | 0
Sue | 2020-08-01 00:00:00 | 0
Sue | 2020-09-01 00:00:00 | 0
Sue | 2020-10-01 00:00:00 | 0
Sue | 2020-11-01 00:00:00 | 0
Sue | 2020-12-01 00:00:00 | 0
[NAME] | 2020-01-01 00:00:00 | 2
[NAME] | 2020-02-01 00:00:00 | 1
[NAME] | 2020-03-01 00:00:00 | 0
[NAME] | 2020-04-01 00:00:00 | 1
[NAME] | 2020-05-01 00:00:00 | 1
[NAME] | 2020-06-01 00:00:00 | 5
[NAME] | 2020-07-01 00:00:00 | 0
[NAME] | 2020-08-01 00:00:00 | 0
[NAME] | 2020-09-01 00:00:00 | 0
[NAME] | 2020-10-01 00:00:00 | 0
[NAME] | 2020-11-01 00:00:00 | 0
[NAME] | 2020-12-01 00:00:00 | 0
[NAME] | 2020-01-01 00:00:00 | 3
[NAME] | 2020-02-01 00:00:00 | 0
[NAME] | 2020-03-01 00:00:00 | 35
[NAME] | 2020-04-01 00:00:00 | 0
[NAME] | 2020-05-01 00:00:00 | 0
[NAME] | 2020-06-01 00:00:00 | 1
[NAME] | 2020-07-01 00:00:00 | 0
[NAME] | 2020-08-01 00:00:00 | 0
[NAME] | 2020-09-01 00:00:00 | 0
[NAME] | 2020-10-01 00:00:00 | 0
[NAME] | 2020-11-01 00:00:00 | 0
[NAME] | 2020-12-01 00:00:00 | 0
Sara | 2020-01-01 00:00:00 | 0
Sara | 2020-02-01 00:00:00 | 0
Sara | 2020-03-01 00:00:00 | 0
Sara | 2020-04-01 00:00:00 | 0
Sara | 2020-05-01 00:00:00 | 0
Sara | 2020-06-01 00:00:00 | 0
Sara | 2020-07-01 00:00:00 | 0
Sara | 2020-08-01 00:00:00 | 0
Sara | 2020-09-01 00:00:00 | 0
Sara | 2020-10-01 00:00:00 | 0
Sara | 2020-11-01 00:00:00 | 0
Sara | 2020-12-01 00:00:00 | 0
[NAME] | 2020-01-01 00:00:00 | 0
[NAME] | 2020-02-01 00:00:00 | 4
[NAME] | 2020-03-01 00:00:00 | 0
[NAME] | 2020-04-01 00:00:00 | 45
[NAME] | 2020-05-01 00:00:00 | 31
[NAME] | 2020-06-01 00:00:00 | 10
[NAME] | 2020-07-01 00:00:00 | 0
[NAME] | 2020-08-01 00:00:00 | 0
[NAME] | 2020-09-01 00:00:00 | 0
[NAME] | 2020-10-01 00:00:00 | 0
[NAME] | 2020-11-01 00:00:00 | 0
[NAME] | 2020-12-01 00:00:00 | 0
Spreadsheet: 168982d1342646416-autofill-table-in-sheet-a-with-conditional-entries-in-sheet-b-z-autofill-table
Sheet: Master

 |  | Product # | Quote Request # | Product #1 | Column7 | Product #2 | Column6 | Column13 | Company Code | Customer | Date | Column72 | Column8 | Column9 | Column2 | Column1 | Total Cost | Column10 | Column11 | Column3 | Column12 | Column133 | Column14 | Column15 | Column16 | Column17 | Notes | Completed
 |  | 1112200 | Rate - 1 | 111 |  | 22 |  |  | AA | ZZ | 2012-07-18 00:00:00 | 0 | 0 |  |  |  | 5
 |  | 1113300 | Rate - 1 | 111 |  | 33 |  |  | AA | ZZ | 2012-07-18 00:00:00 | 0 | 0 |  |  |  | 10
 |  | 1112200 | Rate - 1 | 111 |  | 22 |  |  | BB | ZZ | 2012-07-18 00:00:00 | 0 | 0 |  |  |  | 15
 |  | 1113300 | Rate - 1 | 111 |  | 33 |  |  | BB | ZZ | 2012-07-18 00:00:00 | 0 | 0 |  |  |  | 20
 |  | 1112200 | Rate - 1 | 111 |  | 22 |  |  | CC | ZZ | 2012-07-18 00:00:00 | 0 | 0 |  |  |  | 25
 |  | 1113300 | Rate - 1 | 111 |  | 33 |  |  | CC | ZZ | 2012-07-18 00:00:00 | 0 | 0 |  |  |  | 30
 |  | 4442200 | Rate - 2 | 444 |  | 22 |  |  | AA | ZZ | 2012-07-18 00:00:00 | 0 | 0 |  |  |  | 5
 |  | 5552200 | Rate - 2 | 555 |  | 22 |  |  | AA | ZZ | 2012-07-18 00:00:00 | 0 | 0 |  |  |  | 10
 |  | 6662200 | Rate - 2 | 666 |  | 22 |  |  | AA | ZZ | 2012-07-18 00:00:00 | 0 | 0 |  |  |  | 15
 |  | 4442200 | Rate - 2 | 444 |  | 22 |  |  | BB | ZZ | 2012-07-18 00:00:00 | 0 | 0 |  |  |  | 20
 |  | 5552200 | Rate - 2 | 555 |  | 22 |  |  | BB | ZZ | 2012-07-18 00:00:00 | 0 | 0 |  |  |  | 25
 |  | 6662200 | Rate - 2 | 666 |  | 22 |  |  | BB | ZZ | 2012-07-18 00:00:00 | 0 | 0 |  |  |  | 30
Spreadsheet: 835015d1688228597-need-help-with-excel-file-and-slicer-calculation-issue-dvg_inventory_tracker_reports
Sheet: pivot_products

Order Type | (All)
Row Labels | Sum of Amount | Sum of Quantity
Butterscotch FLV Sauce | 75893 | 29
Caramel FLV Sauce | 195375 | 75
Chocolate FLV Sauce | 310386 | 102
Cheese Cake FLV Sauce | 36470 | 14
Caramel FLV Syrup | 127584 | 96
[NAME] FLV Syrup | 378195 | 285
Vanilla FLV Syrup | 158151 | 119
Blue Ocean FLV Syrup | 125866 | 94
Fragnant Lychee FLV Syrup | 44121 | 33
Green Apple Campagna FLV Syrup | 125960 | 94
Lemon FLV Syrup | 44220 | 33
Majestic Mango FLV Syrup | 48240 | 36
Menta CUBANO FLV Syrup | 110473 | 83
Peach Garden FLV Syrup | 48240 | 36
ITALIAN Dolce FLV Syrup | 31704 | 24
Lemonade FLV Syrup | 51604 | 28
[NAME] BEV Mix | 54880 | 28
White Peach Fruit BEV Mix | 56840 | 29
Mango Fruit BEV Mix | 88065 | 45
Passionfruit FRUIT BEV Mix | 58650 | 30
Strawberry Fruit BEV Mix | 90022 | 46
[NAME] BEV Mix | 35190 | 18
[NAME] FLV Syrup | 47328 | 34
Tropical Passionfruit FLV Syrup | 96480 | 72
White Chocolate FLV Sauce | 161945 | 56
European Strawberry FLV Syrup | 126242 | 94
Spreadsheet: 50314d1249675800-sales-sheet-advanced-if-sumif-question-sample-sales
Sheet: Contact

CONTACT LIST
Last | First | [NAME] | Total Purchase
[NAME] | [NAME] | rn6
[NAME] | [NAME] | tj3
Lincoln | [NAME] | al8
Roosevelt | Teddy | tr9
Roosevelt | Franklin | fr4
Spreadsheet: 680794d1591196649-finding-all-the-non-empty-rows-in-a-column-depending-on-user-input-simple-thebeastslayer-
Sheet: Sheet1

 |  |  |  |  |  | DATE |  |  | 2020-06-01 00:00:00 |  |  |  | 2020-06-02 00:00:00 |  |  |  | 2020-06-03 00:00:00 |  |  |  | 2020-06-04 00:00:00
[NAME] | 2020-06-02 00:00:00 |  |  |  |  | NAME |  |  | AGE | BLOOD GRP |  |  | AGE | BG |  |  | AGE | BLOOD GRP |  |  | AGE | BG
 |  |  |  |  |  | A |  |  |  |  |  |  | 2 | AB |  |  | 1 | A
NAME | AGE | BG |  |  |  | B |  |  | 5 | A |  |  |  |  |  |  | 2 | B
 |  |  |  |  |  | C |  |  |  |  |  |  | 3 | O
 |  |  |  |  |  | D |  |  | 6 | O |  |  |  |  |  |  |  |  |  |  | 4 | C
 |  |  |  |  |  | E |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | D
 |  |  |  |  |  | F |  |  |  |  |  |  | 5 | B
Output Expected if Cell B2= 02-JUN then
NAME | AGE | BG
 |  |  | Finding all the non empty rows in a column depending on user input.
 |  |  | I have attached a sample file with expected output. Number of rows may extend upto 200 . I want to extract data based on user input with non blank cells . My target column is age column to find the non empty rows. If age column is blank then blood group will also be blank.
Spreadsheet: 89973d1289730736-combination-sum-solver102
Sheet: Sheet1

109800 | 1 |  | 109800 |  | 10870.2 |  | 43920 |  | 43920 |  | 10980
115200 | 0 |  | 115200 |  | 11404.8 |  | 46080 |  | 46080 |  | 11520
119700 | 0 |  | 119700 |  | 11850.3 |  | 47880 |  | 47880 |  | 11970
126900 | 0 |  | 126900 |  | 12563.1 |  | 50760 |  | 50760 |  | 12690
125100 | 0 |  | 125100 |  | 12384.9 |  | 50040 |  | 50040 |  | 12510
111600 | 0 |  | 111600 |  | 11048.4 |  | 44640 |  | 44640 |  | 11160 | Combination needed:
114300 | 0 |  | 114300 |  | 11315.7 |  | 45720 |  | 45720 |  | 11430 | 188280
10870.2 | 0 |  |  |  |  |  |  |  |  |  |  | 188280
11404.8 | 0
11850.3 | 0
12563.1 | 0
12384.9 | 0
11048.4 | 0
11315.7 | 0
43920 | 0
46080 | 0
47880 | 0
50760 | 0
50040 | 0
44640 | 0
45720 | 0
43920 | 1
46080 | 0
47880 | 0
50760 | 0
50040 | 0
44640 | 0
45720 | 0
10980 | 0
11520 | 0
11970 | 1
12690 | 0
12510 | 0
11160 | 1
11430 | 1
Spreadsheet: 25279d1216414732-unblank-characters-that-i-have-to-remove-book2
Sheet: Sheet1

Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2007 | 0 | 0 | 0 | 0 | 0 | 3,071 | 2,541 | 3,590 | 3,447 | 4,213 | 3,974 | 2,731
2008 | 3,945 | 3,403 | 3,205 | 3,641 | 3,426 | 3,711 | 2,120 | 4,064 | 3,357 | 4,064 | 3,711 | 3,534
2009 | 4,151 | 3,584 | 3,962 | 3,773 | 4,339 | 3,962 | 2,264 | 4,339 | 3,584 | 4,339 | 3,962 | 3,773
2010 | 4,370 | 3,774 | 4,171 | 3,973 | 4,569 | 4,171 | 2,383 | 4,569 | 3,774 | 4,569 | 4,171 | 3,973
2011 | 4,456 | 3,849 | 4,254 | 4,051 | 4,659 | 4,254 | 2,431 | 4,659 | 3,849 | 0 | 0 | 0
 | #N/A
Spreadsheet: vkaminski__40842__665 Team Project--Tracy Pan Part 1
Sheet: 2. Black

Formula 6.5 Black Fomula for European futures option
 |  |  |  |  | Put-Call Parity
 |  |  |  |  |  |  |  | =
 |  | 0.25 |  | Inputs |  |  |  |  | Inputs
 | t | 0 |  |  |  | t
 | T | 0.5 |  |  |  | T
 | s | 1 |  |  |  | s
 | r | 0.05 |  |  |  | r
 |  | 0.01
 | S | 100 |  |  |  | S
 | K | 100 |  |  |  | K
 | F(t,s) |  |  |  |  | F(t,s)
 | P(t,T) |  |  |  |  | P(t,T)
 | h1 |  |  |  |  | h1
 | N(h1) |  |  |  |  | N(-h1)
 | h2 |  |  |  |  | h2
 | N(h2) |  |  |  |  | N(-h2)
 | c(t,T,s) |  |  | Value |  | p(t,T,s) |  |  | Value
Spreadsheet: 841452d1693621561-data-from-invoice-generate-into-statement-invoice-to-statement
Sheet: Sheet1

ENTRY ACCORDING TO DAILY INVOICE |  |  |  |  |  | STATEMENT (auto display, expected result, maybe use pivot or auto filter?)
Date | Invoice # | Company Name | Deposit | Withdrawal |  | Date | Invoice # | Company Name | Deposit | Withdrawal | Balance
2023-08-01 00:00:00 | INV001 | Com A |  | 100 |  | 2023-08-01 00:00:00 | INV001 | Com A |  | 100 | 100
2023-08-02 00:00:00 | INV002 | Com A |  | 200 |  | 2023-08-02 00:00:00 | INV002 | Com A |  | 200 | 300
2023-08-04 00:00:00 | INV001 | Com B |  | 1000 |  | 2023-09-01 00:00:00 | Payment | Com A | 300 |  | 0
2023-08-05 00:00:00 | INV002 | Com B |  | 2000
2023-09-01 00:00:00 | Payment | Com B | 2000 |  |  | Date | Invoice # | Company Name | Deposit | Withdrawal | Balance
2023-09-01 00:00:00 | Payment | Com A | 300 |  |  | 2023-08-04 00:00:00 | INV001 | Com B |  | 1000 | 1000
 |  |  |  |  |  | 2023-08-05 00:00:00 | INV002 | Com B |  | 2000 | 3000
 |  |  |  |  |  | 2023-09-01 00:00:00 | Payment | Com B | 2000 |  | 1000
Spreadsheet: 79281d1279561629-disappearing-info-advanced-filters-running-down-the-page-with-macro-new-cost-centre-rev2
Sheet: Q1305

Cost Centre | Activity Code
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
[NAME] | 301 | 1235 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A
[NAME] | 301 | 1235 | [NAME] | 2010-07-18 00:00:00 | 2010-07-18 00:00:00 | 4 | 10 | Robins | B
Cost Centre | Activity Code
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
[NAME] | 302 | 1235 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A
[NAME] | 302 | 1235 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 3 | 10 | Robins | B
Cost Centre | Activity Code
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
[NAME] | 303 | 1235 | [NAME] | 2010-07-18 00:00:00 | 2010-07-18 00:00:00 | 5 | 200 | Robins | B
Cost Centre | Activity Code
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
[NAME] | 304 | 1235 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A
Cost Centre | Activity Code
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
[NAME] | 306 | 1234 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A
Spreadsheet: 782395d1654014751-lookup-value-in-one-column-if-not-there-lookup-in-another-column-to-return-value-in-a-3rd-test-file
Sheet: Sheet2

MFG-Model-# | PN | PN#2 | PN#3 | Description | Warranty
[NAME] | 700653 |  |  |  | Tank 10yr
PRO+G50S-36P RH61 |  |  |  |  | Tank 8yr
PROE38-S2 RH95-B | 660479 |  |  | Rheem PROE38 S2 RH95 B Professional Classic Water Heater, Insulation Blanket, Electric, 240 VAC, 38 Gallon, Short | Tank 6yr
PROE40-M2 RH95 | 650265 |  |  | Rheem  PROE40 M2 RH95 Professional Classic Water Heater, Electric, Dual Element, 240 VAC, 40 Gallon, Medium | Tank 6yr
[NAME] RH95 | 656854 |  |  | Rheem PROE40-T2-RH95 656854 40 GALLON 240V/1P/0A 4500W 4500W Electric WATER HEATER DRY FIRE RE SS UPR/RE SS LWR | Tank 12yr
PROE47-S2 RH95 | 691800 |  | 3554562 | Rheem PROE47 S2 RH95 Professional Classic Water Heater, Electric, 47 Gallon, Short, Dual Element, 240 Volts | Tankless
PROG40-32P RH62 | 641317 | 3540893 | 2487250 | Rheem PROG40-32P-RH62 641317 40 GALLON 32000 BTU LIQUID PROPANE WATER HEATER | Lifetime
Spreadsheet: 03dbe0c4-a774-485a-b7a8-661fb6dc16e9
Sheet: 2012 math grade 3

[NAME] |  | Total Number | [NAME]
[NAME] |  |  | Inconclusive | Exploring | Emerging | Developing | Novice | No Score
2010 | All Students | 687 | 8 | 17 | 21 | 24 | 23 | 7
2011 |  | 660 | 10 | 18 | 23 | 23 | 23 | 4
2012 | All Students | 686 | 9 | 21 | 25 | 16 | 23 | 6
 | Asian | 25 | 12 | 32 | 20 | 16 | 16 | 4
 | Black or African American | 40 | 5 | 18 | 33 | 20 | 18 | 8
 | Hispanic or Latino | 242 | 10 | 24 | 24 | 14 | 24 | 4
 | White | 344 | 8 | 19 | 24 | 19 | 23 | 6
 | Two or more races | 25 | 8 | 24 | 36 | 8 | 16 | 8
 | Minority | 342 | 9 | 23 | 26 | 14 | 23 | 5
 | English Learners | 106 | 6 | 25 | 34 | 14 | 18 | 3
 | Free/Reduced Lunch | 385 | 6 | 22 | 25 | 17 | 25 | 4
 | Female | 246 | 7 | 26 | 22 | 17 | 24 | 4
 | Male | 438 | 10 | 19 | 27 | 16 | 23 | 6
Spreadsheet: kam_keiser__17854__quotesheet
Sheet: 12-12 morning

Large Deal Quote Sheet (Generic)
Date & Time of Quote | Prompt Merc price, and commodity | Dealer/Third Party | Market/Location | Term | Notional Amount | Bid/Ask
 | Jan '02 | Natsource | Permian | Jan - Mar '02 | 10,000/d
 | Jan '02 | Natsource | Waha | Jan - Mar '02 | 10,000/d
2001-12-12 08:50:08.760000 | Jan '02 | Natsource | HSC | Cal '04 | 10,000/d | +.0025 @ +.0075
2001-12-12 08:50:08.760000 | Jan '02 | Natsource | HSC | Cal '02 | 10,000/d | +.005 @ +.0075
2001-12-12 08:50:08.760000 | Jan '02 | Natsource | Waha | Ap - Oct '02 | 10,000/d | -.115 @ -.1075
2001-12-12 08:50:08.760000 | Jan '02 | Natsource | Permian | Ap - Oct '02 | 10,000/d | -.155 @ -.15
 | Jan '02 | Natsource | Permian | Cal '04 | 10,000/d
2001-12-12 08:56:10.010000 | Jan '02 | APB | Permian | Jan - Mar '02 | 10,000/d | -.16 @
2001-12-12 08:56:10.010000 | Jan '02 | APB | Waha | Jan - Mar '02 | 10,000/d | -.125 @
2001-12-12 08:56:10.010000 | Jan '02 | APB | HSC | Jan - Mar '02 | 10,000/d | -.05 @ -.0125
2001-12-12 08:56:10.010000 | Jan '02 | APB | HSC | Cal '02 | 10,000/d | +.005 @ .0075
2001-12-12 08:56:10.010000 | Jan '02 | APB | HSC | Cal '03 | 10,000/d | +.0025 @ .0075
2001-12-12 08:56:10.010000 | Jan '02 | APB | HSC | Cal '04 | 10,000/d | +0.0025 @ +.005
2001-12-12 08:56:10.010000 | Jan '02 | APB | Permian | Cal '04 | 10,000/d | -.10 @
2001-12-12 08:56:10.010000 | Jan '02 | APB | Permian | Cal '05 | 10,000/d | -.095 @
2001-12-12 08:52:52.250000 | Jan '02 | Prebon | Permian | Jan - Mar '02 | 10,000/d | -.155 @ -.15
2001-12-12 08:52:52.250000 | Jan '02 | Prebon | Waha | Jan - Mar '02 | 10,000/d | -.125 @ -.115
2001-12-12 08:52:52.250000 | Jan '02 | Prebon | HSC | Jan - Mar '02 | 10,000/d | -.015 @ -.0125
2001-12-12 08:52:52.250000 | Jan '02 | Prebon | HSC | Ap - Oct '02 | 10,000/d | +.03 @ .0325
2001-12-12 08:52:52.250000 | Jan '02 | Prebon | HSC | Cal '03-06 | 10,000/d | 0 @ .005
2001-12-12 08:52:52.250000 | Jan '02 | Prebon | Permian | Ap - Oct '02 | 10,000/d | -.155 @ -.15
2001-12-12 08:52:52.250000 | Jan '02 | Prebon | Waha | Ap - Oct '02 | 10,000/d | -.115 @ -.105
2001-12-12 08:52:52.250000 | Jan '02 | Prebon | HSC | Cal '02 | 10,000/d | +.005 @ +.0075
Spreadsheet: 273009d1382573512-sumif-function-117
Sheet: Trends by Day

 |  | Target | Actual | Target | Actual | Target | Actual | Target | Actual | Target | Actual | Target | Actual
Date |  | Daily Budget |  | Travalos |  | Premiers |  | Mailouts |  | Trans |  | Units
Store Goals
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Spreadsheet: 0dfb7d12-5b04-47fc-b4bc-22d13598cc38
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Spot Barge Rates, 2001 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
DATE | TWC | MM | ILL | ST LOUIS | CINC | LOH | CAR-MEM | MEM-NO
010301 | 0 | 0 | 255 | 176 | 151 | 150 | 121 | 165
011001 | 0 | 0 | 233 | 171 | 178 | 174 | 156 | 188
011701 | 0 | 0 | 238 | 186 | 200 | 198 | 168 | 190
012401 | 0 | 0 | 240 | 208 | 183 | 180 | 171 | 218
013101 | 0 | 0 | 204 | 155 | 151 | 149 | 141 | 188
020701 | 0 | 0 | 209 | 143 | 134 | 141 | 136 | 175
021401 | 0 | 0 | 184 | 145 | 138 | 140 | 133 | 180
022101 | 0 | 0 | 167 | 135 | 140 | 140 | 131 | 170
022801 | 0 | 198 | 193 | 172 | 155 | 156 | 152 | 191
030701 | 0 | 201 | 198 | 173 | 170 | 200 | 162 | 212
031401 | 0 | 201.25 | 195 | 173.75 | 172.5 | 193.75 | 157.5 | 183.3333333333333
032101 | 0 | 208 | 206 | 169 | 169 | 182 | 158 | 200
032801 | 0 | 213 | 208 | 155 | 170 | 173 | 146 | 178
040401 | 0 | 178 | 178 | 147 | 156 | 160 | 141 | 183
041101 | 0 | 158 | 158 | 133 | 139 | 146 | 128 | 167
041801 | 0 | 153 | 153 | 126 | 136 | 136 | 121 | 157
042501 | 0 | 155 | 145 | 114 | 127 | 128 | 113 | 155
050201 | 0 | 162 | 140 | 110 | 123 | 121 | 108 | 150
050901 | 0 | 170 | 136 | 112 | 115 | 116 | 107 | 163
051601 | 0 | 185 | 151 | 120 | 116 | 120 | 109 | 165
052301 | 0 | 189 | 168 | 129 | 128 | 130 | 123 | 179
053001 | 208 | 173 | 164 | 126 | 128 | 128 | 120 | 182
060601 | 204 | 186 | 161 | 141 | 119 | 123 | 122 | 175
061301 | 227 | 195 | 180 | 143 | 130 | 134 | 135 | 180
062001 | 213 | 183 | 168 | 133 | 129 | 128 | 125 | 169
062701 | 220 | 185 | 171 | 123 | 124 | 123 | 115 | 160
070501 | 214 | 179 | 169 | 123 | 123 | 121 | 114 | 161
071101 | 214 | 182 | 171 | 118 | 122 | 122 | 111 | 160
071801 | 231 | 203 | 181 | 137 | 145 | 149 | 123 | 185
072501 | 223 | 186 | 175 | 138 | 154 | 168 | 128 | 175
080101 | 225 | 185 | 168 | 138 | 155 | 158 | 126 | 178
080801 | 215 | 180 | 163 | 135 | 151 | 149 | 123 | 178
081501 | 230 | 206 | 187 | 168 | 173 | 173 | 162 | 223
082201 | 226 | 196 | 178 | 168 | 173 | 174 | 162 | 222
082901 | 228 | 201 | 198 | 191 | 198 | 198 | 185 | 268
090501 | 235 | 213 | 209 | 208 | 217 | 219 | 204 | 260
091201 | 214 | 193 | 185 | 174 | 199 | 199 | 168 | 273
091901 | 198 | 184 | 178 | 169 | 186 | 186 | 163 | 227
092601 | 216 | 211 | 209 | 201 | 241 | 243 | 202 | 273
100301 | 237 | 228 | 218 | 219 | 248 | 258 | 213 | 275
101001 | 220 | 208 | 204 | 205 | 221 | 220 | 197 | 245
101701 | 205 | 204 | 198 | 170 | 202 | 202 | 163 | 220
102401 | 226 | 238 | 248 | 231 | 231 | 229 | 230 | 295
103101 | 264 | 260 | 260 | 258 | 254 | 255 | 251 | 330
110701 | 200 | 185 | 179 | 165 | 203 | 200 | 161 | 220
111401 | 186 | 196 | 136 | 135 | 183 | 169 | 128 | 173
112101 | 200 | 168 | 153 | 123 | 135 | 135 | 118 | 170
112801 | 0 | 167 | 150 | 118 | 129 | 129 | 114 | 151
120501 | 0 | 173 | 165 | 120 | 124 | 127 | 114 | 160
121201 | 0 | 200 | 180 | 141 | 139 | 139 | 125 | 165
121901 | 0 | 0 | 167 | 130 | 138 | 137 | 119 | 161
122601 | 0 | 0 | 195 | 143 | 153 | 152 | 131 | 175
Spreadsheet: 154745d1336544776-display-data-from-calculation-learn
Sheet: Sheet1

DATA
Milestone Progress | 0.1 | 0.1 | 0.4 | 0.2 | 0.2 |  |  | CALCULATION TABLE
 |  |  |  |  |  |  |  | Engineering | 1 | M1 |  | M2 | M3 | M4 | M5
Description | M1 | M2 | M3 | M4 | M5 | Total |  |  | Process
Process | 1 | 1 | 1 | 1 |  |  |  |  | Mechanical
Process | 1 | 1 | 1 | 1 |  |  |  |  | Piping
Process | 1 | 1 |  |  |  |  |  |  | Pipeline
Process | 1 | 1
Mechanical | 1 | 1 | 1 | 1 | 1
Mechanical | 1
Mechanical | 1
Mechanical | 1
Mechanical | 1
Mechanical | 1
Piping | 1 | 1 | 1
Piping | 1 | 1 | 1
Piping | 1 | 1 | 1
Piping | 1 | 1 | 1
Piping | 1 | 1 | 1 | 1
Piping | 1 | 1 | 1 | 1
Pipeline | 1 | 1
Pipeline | 1 | 1
Pipeline | 1 | 1
Pipeline | 1 | 1
Pipeline | 1 | 1
Pipeline | 1 | 1
Pipeline | 1 | 1
Pipeline | 1 | 1
Pipeline | 1 | 1
Spreadsheet: 838575d1691149478-maximum-drawdown-in-percentage-max-dd
Sheet: Sheet1

Total R2 | [NAME] DD%
-0.005
-0.01
0
0.01
0.005
0.015
0.025
0.035
0.04500000000000001
0.02
Spreadsheet: darrell_schoolcraft__7299__imball0112
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1 |  | -7000
2 |  | -4786
3 | -20568 | -4786
4 | -6999 | -10000
5 | -5845 | -10000
6 | -8331 | -10000
7 | -8430 | -10000
8 | -35058 | -17270
9 | -565 | -17270
10 | -7231 | -17270
11 | -8566 | -2270
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00
2001-12-11 00:00:00 |  |  |  | 2.12
CBS Dollars
 |  |  | 159102
Spreadsheet: 67487d1268105893-selecting-2-different-values-from-the-1-spreadsheet-customer-data
Sheet: Sheet1

Customer Purchased | Product Type
[NAME] | Milk
[NAME] | Bread
[NAME] | Sugar
Charlotte | Butter
[NAME] | [NAME]
[NAME] | Honey
[NAME] | Bread
[NAME] | Honey
[NAME] | Sugar
[NAME] | Sugar
[NAME] | Butter
[NAME] | [NAME]
Charlotte | Sugar
Charlotte | Bread
Charlotte | [NAME]
Charlotte | Milk
[NAME] | Sugar
I want to be able to count how many times [NAME] has purchased Sugar