tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 123475d1317673017-if-formula-test
Sheet: T&O Pay Scale - 350

Grade/Niveaux Minimum/Minimum Midpoint/Milieu Maximum/Maximum
21 | 17300 | 20300 | 23300
22 | 18900 | 22200 | 25500
23 | 20800 | 24500 | 28200
24 | 22800 | 26800 | 30800
25 | 25100 | 29500 | 33900
26 | 27400 | 32200 | 37000
27 | 27800 | 34800 | 41800
28 | 29800 | 37300 | 44800
29 | 33800 | 42200 | 50600
30 | 36300 | 45400 | 54500
31 | 39600 | 49500 | 59400
32 | 43200 | 54000 | 64800
33 | 47100 | 58900 | 70700
34 | 52600 | 65800 | 79000
35 | 57400 | 71800 | 86200
36 | 62600 | 78300 | 94000
37 | 69100 | 86400 | 103700
38 | 78600 | 98300 | 118000
39 | 86600 | 108300 | 130000
40 | 98600 | 123300 | 148000
41 | 107000 | 133700 | 160400
Spreadsheet: e5e7a48a-96b7-4ac6-a57f-c53bf9f4217f
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
GASCA | Test | GASCA | Saccharomyces cerevisiae Antibody, IgG, Serum | Saccharomyces cerevisiae [NAME], IgG, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | Negative: 0.0-20.0 U Equivocal: 20.1-24.9 U Weakly positive: 25.0-34.9 U Positive: > or =35.0 U | Monday through Friday; 5 p.m. | Same day/1 day |  | 1 | 83520 |  |  |  |  | Rochester
GASCA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
GASCA | Result | GASCA | Saccharomyces cerevisiae [NAME], IgG, S | Saccharomyces cerevisiae [NAME], IgG, S | Numeric |  |  |  |  | U |  |  |  |  |  |  |  |  |  | 47321-5 | Saccharomyces cerevisiae [NAME].IgG:ACnc:Pt:Ser:Qn:EIA
Spreadsheet: 767214d1644340352-allocate-amount-into-monthly-columns-formula-fails-for-specific-years-networkdays-issue-allocation1
Sheet: Visual

Visual
Click Consulting
Purpose | To demonstrate the days logic visually
Settings
 | The allocation period is from 1/1 to 3/31
 | StartDate = 1/1
 | EndDate = 3/31
Case 1
 | The current period is one month into the allocation period (CurPer = 1/31)
 | 2013-11-30 00:00:00 | 2013-01-01 00:00:00 | 2014-01-31 00:00:00 | 2014-02-28 00:00:00 | 2014-03-31 00:00:00 | 2014-04-30 00:00:00 | 2014-05-31 00:00:00 | 2014-06-30 00:00:00
 | • | ◊ | • | • | ◊ | • | • | •
 |  | A
 | The number of days to be allocated in the current period is simply represented by segment A.
 | Segment A is easily computed by subtracting the date endpoints.
 | A=CurPer - StartDate
 | A=1/31-1/1
 | (Techically, it will be off by 1 day, but we'll address this at the end.)
Case 2
 | The current period is earlier than the allocation start date (CurPer = 11/30)
 | A
 | In this case, our standard formula (CurPer - StartDate) will result in a negative number.
 | To prevent this, we'll wrap a MAX function around it, so the function will return zero instead of a negative.
 | A=MAX(CurPer - StartDate,0)
 | A=MAX(11/30-1/1,0)
 | A=0
Case 3
 | The current period is more than one month into the allocation period (CurPer = 2/28)
 |  | A
 |  | B
 |  | C
 | The desired segment, C, can be computed by taking segment A and subtracting from it segment B.
 | C=A-B
 | A = CurPer-StartDate = 2/28-1/1
 | B = PriorPer-StartDate = 1/31-1/1
 | We will compute the PriorPer value with the EOMONTH function.
 | Again, to avoid negative days, we'll use MAX functions
Case 4
 | The current period is after the end of the allocation period (CurPer = 5/31)
 | All that remains is to adjust our formula developed above to remove the days past the end of the allocation period.
 | To accomplish this, we'll simply subtract the excess days, or, the number of days past the end date.
 |  | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | F
 | C=A-B
 | This is our standard formula, but results in a non-zero number of days even though the current period is outside of the allocation period.
 | Thus, we subtract from its result the number of days in the current period that are in excess of the EndDate, represented by Segment F.
 | The desired result is C-F, or zero days.
 | [NAME]
 | D=MAX(CurPer-EndDate,0)
 | E=MAX(PriorPer-EndDate,0)
Spreadsheet: 215775d1361476979-matching-identical-entries-example
Sheet: Sheet1

Player 1 | Player 2 | Player 3 | Player 4 | Player 5 | Player 6
1 | 1 | 1 | 2 | 1 | 2
1 | 2 | 1 | 2 | 2 | 2
1 | 1 | 1 | 2 | 1 | 2 |  | <<<<< All if this data would be in sheet 1
1 | 2 | 1 | 2 | 2 | 2
1 | 1 | 1 | 2 | 1 | 1
 |  |  |  |  |  | All of the data below would be in sheet 2, if possible
 |  |  | Identical entries listed together >>>> |  |  |  | Player 1, Player 3 |  |  | <<< Also it would be good if the entries could be listed beside each one, ideally vertically
 |  |  |  |  |  |  | Player 2, Player 5
 |  |  | Unique entries listed separately>>>>>>> |  |  |  | Player 4
 |  |  |  |  |  |  | Player 6
Spreadsheet: 43149d1241723669-how-can-i-make-a-macro-to-add-data-from-2-different-columns-example
Sheet: My Orders

Item | Left Over | Difference |  | Order 1 | T# |  | Order 2 | T# |  | Order 3 | T# |  | OTW + Here
Status |  |  |  | WIP |  |  | WIP |  |  | WIP
Item | 0 |  |  | 3
Item | 1 |  |  | 2 |  |  | 5
Item | 0 |  |  | 0 |  |  | 7 |  |  | 1
Item | 3 |  |  | 5 |  |  | 2
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 1
Item |  |  |  | 0
Item | 1 |  |  | 5 |  |  |  |  |  | 3
Item | 0 |  |  | 2
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 2 |  |  | 4 |  |  |  |  |  | 1
Item | 0 |  |  | 0 |  |  |  |  |  | 4
Item | 0 |  |  | 0 |  |  |  |  |  | 1
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 1
Item | 0 |  |  | 3
Item | 3 |  |  | 4
Item | 6 |  |  | 4
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Ieam | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 0
Item | 0 |  |  | 2
Total |  |  |  | 214
Spreadsheet: 57871d1258073675-cell-references-between-sheets-sampleaugust2009
Sheet: BRENT

PRIORITY (1-3) | ASSIGNED TO | UTlLITY | STATUS | BB | HRS ESTIMATE
1 | BB | G | A | -        Complile Walterville chevron notes from 2006 & ?
2 | BB | G | C | Shoot Chevron drops [NAME] request low H20 near end of summer+topo Lisa/Cheri
3 | BB | E | C | -        Pin RP Timberline/Timberline for Vlt retaining wall/[NAME], done, wait til job over (July 09)
1 | BB | E | C | -        Rewrite Triangle 5/Millican easement – description to [NAME]
1 | bb | O | f | Stay up to date with any requests from Property management section
Spreadsheet: 108289d1305303311-excel-2007-pivot-table-formulas-with-custom-subtotals-sample
Sheet: pivot1

 |  | year | month
 |  | 2010 |  | Toplam 2010 | 2011 |  | Toplam 2011 | Genel Toplam
name | Değerler | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00
[NAME] | Toplam balance | 10 | 32 | 42 | 14 | 24 | 38 | 80
 | Toplam quantity | 2 | 5 | 7 | 2 | 4 | 6 | 13
 | Toplam tax | 2 | 2 | 4 | 2 | 2 | 4 | 8
 | Toplam % | 0.2 | 0.0625 | 0.09523809523809523 | 0.1428571428571428 | 0.08333333333333333 | 0.1052631578947368 | 0.1
item2 | Toplam balance | 24 | 26 | 50 | 52 | 53 | 105 | 155
 | Toplam quantity | 3 | 3 | 6 | 4 | 4 | 8 | 14
 | Toplam tax | 5 | 6 | 11 | 7 | 8 | 15 | 26
 | Toplam % | 0.2083333333333333 | 0.2307692307692308 | 0.22 | 0.1346153846153846 | 0.1509433962264151 | 0.1428571428571428 | 0.167741935483871
item3 | Toplam balance | 100 | 102 | 202 | 107 | 108 | 215 | 417
 | Toplam quantity | 5 | 5 | 10 | 5 | 5 | 10 | 20
 | Toplam tax | 22 | 23 | 45 | 24 | 25 | 49 | 94
 | Toplam % | 0.22 | 0.2254901960784314 | 0.2227722772277228 | 0.2242990654205607 | 0.2314814814814815 | 0.2279069767441861 | 0.2254196642685851
Toplam balance Toplamı |  | 134 | 160 | 294 | 173 | 185 | 358 | 652
Toplam quantity Toplamı |  | 10 | 13 | 23 | 11 | 13 | 24 | 47
Toplam tax Toplamı |  | 29 | 31 | 60 | 33 | 35 | 68 | 128
Toplam % Toplamı |  | 0.2164179104477612 | 0.19375 | 0.2040816326530612 | 0.1907514450867052 | 0.1891891891891892 | 0.1899441340782123 | 0.196319018404908
Spreadsheet: 724376d1616137015-vlookup-or-index-match-need-help-book1-5-
Sheet: RECON (2)

 |  |  |  |  |  |  |  |  |  |  |  | OTHER FEE
NUMBER | UNIT | AMOUNT | OTHER FEE | AMT |  | NUMBER | UNITS | AMOUNT | OTHER FEE | TOTAL |  | FEE 1 | Amount | FEE 2 | Amount | TOTAL FEE
2020-022401-088 |  |  | FEE 1 |  |  | 2020-022401-088 |  |  |  |  |  |  | 100 |  | 300
2020-022401-088 |  |  | FEE 2 |  |  | 18-020899-43 |  |  |  |  |  |  | 100 |  | 300
18-020899-43 |  |  | FEE 1
18-020899-43 |  |  | FEE 2
 |  |  |  |  |  |  |  |  |  |  |  | OTHER FEE
NUMBER | UNIT | AMOUNT | OTHER FEE | AMT |  | NUMBER | UNITS | AMOUNT | OTHER FEE | TOTAL |  |  | FEE 1 | FEE 2 | TOTAL FEE
2020-022401-088 | 3 | 600 | FEE 1 | 100 |  | 2020-022401-088 | 6 | 1200 | 400 | 1600 |  | 2020-022401-088 | 100 | 300 | 400
2020-022401-088 | 3 | 600 | FEE 2 | 300 |  | 18-020899-43 | 6 | 1200 | 400 | 1600 |  | 18-020899-43 | 100 | 300 | 400
18-020899-43 | 3 | 600 | FEE 1 | 100
18-020899-43 | 3 | 600 | FEE 2 | 300
Spreadsheet: 193942d1352993417-comparision-of-data-if-excel-question-11-15-12
Sheet: NEW

[NAME] | Description | Components | Validation (Legacy) | Number of Components (Legacy) | Percentage of B.O.M. | Validation percentage (Legacy)
901374 | Chicken | 801041 |  |  | 0.001111
901374 | Chicken | 801224 |  |  | 0.002244
901374 | Chicken | 1000711 |  |  | 0.000556
901450 | Beef | 101927 |  |  | 0.041667
901450 | Beef | 801041 |  |  | 0.001754
901450 | Beef | 801541 |  |  | 0.042083
901450 | Beef | 801758 |  |  | 1.03
901450 | Beef | 901450_RETORT |  |  | 1
901451 | Lemon | 101927 |  |  | 0.041667
901451 | Lemon | 801041 |  |  | 0.001122
901451 | Lemon | 801753 |  |  | 1.02
901451 | Lemon | 801759 |  |  | 0.042083
901451 | Lemon | 901451_RETORT |  |  | 1
901452 | Sesame | 101927 |  |  | 0.041667
901452 | Sesame | 801041 |  |  | 0.001122
901452 | Sesame | 801755 |  |  | 1.02
901452 | Sesame | 801759 |  |  | 0.042083
901452 | Sesame | 901452_RETORT |  |  | 1
Spreadsheet: 806022d1669054305-can-you-have-excel-highlight-specific-years-in-a-spreadsheet-anniv
Sheet: LSS Years Of Svc

 | Calculation Date:
 |  |  |  |  |  | Notable Anniversary Year
 |  | Hire Date | MO | Service [NAME] | Years | 5TH | 10TH | 15TH | 20TH | 25TH | 30TH
 |  | 1/24/2022 | 1
 |  | 1994-02-01 00:00:00 | 2
 |  | 2007-02-20 00:00:00 | 2
 |  | 2015-03-02 00:00:00 | 3
 |  | 2009-03-23 00:00:00 | 3
 |  | 2016-03-01 00:00:00 | 3
 |  | 2017-04-18 00:00:00 | 4
 |  | 1995-04-24 00:00:00 | 4
 |  | 2020-05-04 00:00:00 | 5
 |  | 2004-05-10 00:00:00 | 5
 |  | 2012-05-02 00:00:00 | 5
 |  | 2018-05-14 00:00:00 | 5
 |  | 2018-06-01 00:00:00 | 6
 |  | 2007-06-25 00:00:00 | 6
 |  | 1994-06-10 00:00:00 | 6
 |  | 2017-06-19 00:00:00 | 6
 |  | 2017-06-19 00:00:00 | 6
 |  | 1997-06-23 00:00:00 | 6
 |  | 2007-06-11 00:00:00 | 6
 |  | 2008-07-07 00:00:00 | 7
 |  | 2011-07-25 00:00:00 | 7
 |  | 2002-07-22 00:00:00 | 7
 |  | 2003-07-28 00:00:00 | 7
 |  | 2011-07-11 00:00:00 | 7
 |  | 2006-07-31 00:00:00 | 7
 |  | 2014-08-11 00:00:00 | 8 |  |  |  |  |  |  |  |  | ????? OLD START DATE?
 |  | 2020-08-24 00:00:00 | 8
 |  | 2021-10-11 00:00:00 | 10
 |  | 2011-10-24 00:00:00 | 10
 |  | 2006-10-09 00:00:00 | 10
 |  | 2022-11-14 00:00:00 | 11
 |  | 2007-11-01 00:00:00 | 11
 |  | 2000-12-04 00:00:00 | 12
 |  | 1998-12-24 00:00:00 | 12
 | *Gave 10 Year card in 2014 due to miscalculation of years in service
 | Notable Ann Year
 | 2020
 | 2021
 | 2022
 | 2023
 | LAYOFFS
 | Employee | Hire Date | MO | Service [NAME] | Years | LAID OFF ON
 | ***[NAME], [NAME] | 2006-07-31 00:00:00 | 7 |  |  | 2016-10-31 00:00:00
Spreadsheet: 150002d1334244074-sumif-formula-that-looks-at-specific-names-across-two-seperate-ranges-and-4-different-sheets-excel-help-example
Sheet: Sheet2

PAYEE 19T66: |  |  |  |  |  |  |  | Reclassification |  |  |  |  |  |  | Issue Identification
Tran | [NAME] | Date | Amount | Esc Payee | C/A Payee | RSN | Description | Date | Amount | Esc Payee | C/A Payee | RSN | Description | Adjustment | Category | Avoidance | SubClassification
 |  |  |  |  |  |  |  |  | 500 |  |  |  |  | 500 |  |  | [NAME] fee
 |  |  |  |  |  |  |  |  | 50 |  |  |  |  | 50 |  |  | Prop ins
 |  |  |  |  |  |  |  |  | 250 |  |  |  |  | 250 |  |  | Prop appr
Total Deposits: |  |  | 0 |  |  |  |  | Deposits: |  |  |  |  |  | 800
 |  |  |  |  |  |  |  |  | 100 |  |  |  |  | 100 |  |  | BPO
 |  |  |  |  |  |  |  |  | 350 |  |  |  |  | 350 |  |  | Title
 |  |  |  |  |  |  |  |  | 150 |  |  |  |  | 150 |  |  | Prop pres
Total Disbursement: |  |  | 0 |  |  |  |  | Disbursement: |  |  |  |  |  | 600
Balance: |  |  | 0 |  |  |  |  | Balance: |  |  |  |  |  | 1400
Grand Deposits: |  |  | 0 |  |  |  |  | Grand Deposits: |  |  |  |  |  | 800
Grand Disbursement: |  |  | 0 |  |  |  |  | Grand Disbursement: |  |  |  |  |  | 600
Grand Balance: |  |  | 0 |  |  |  |  | Grand Balance: |  |  |  |  |  | 1400
Spreadsheet: 799780d1665284941-3-games-in-4-nights-excelforum-hd
Sheet: Sheet1

date | home | away | 3in4-B2B Home | 3in4-B2B Away | 3in4 hometeam | 3in4 away team
2022-10-07 00:00:00 | Nashville Predators | San Jose Sharks
2022-10-08 00:00:00 | San Jose Sharks | Nashville Predators
2022-10-11 00:00:00 | Los Angeles Kings | [NAME] Knights
2022-10-11 00:00:00 | New York Rangers | Tampa Bay Lightning
2022-10-12 00:00:00 | Anaheim Ducks | [NAME]
2022-10-12 00:00:00 | Carolina Hurricanes | Columbus Blue Jackets
2022-10-12 00:00:00 | Colorado Avalanche | Chicago Blackhawks
2022-10-12 00:00:00 | Edmonton Oilers | [NAME]
2022-10-12 00:00:00 | Montreal Canadiens | Toronto Maple Leafs
2022-10-12 00:00:00 | Washington Capitals | [NAME]
2022-10-13 00:00:00 | Buffalo Sabres | Ottawa Senators
2022-10-13 00:00:00 | Calgary Flames | Colorado Avalanche
2022-10-13 00:00:00 | Los Angeles Kings | [NAME]
2022-10-13 00:00:00 | Minnesota Wild | New York Rangers
2022-10-13 00:00:00 | Nashville Predators | Dallas Stars
2022-10-13 00:00:00 | New York Islanders | Florida Panthers
2022-10-13 00:00:00 | Philadelphia Flyers | New Jersey Devils
2022-10-13 00:00:00 | Pittsburgh Penguins | Arizona Coyotes
2022-10-13 00:00:00 | Toronto Maple Leafs | Washington Capitals
2022-10-13 00:00:00 | [NAME] Knights | Chicago Blackhawks
2022-10-14 00:00:00 | Columbus Blue Jackets | Tampa Bay Lightning
2022-10-14 00:00:00 | Detroit Red Wings | Montreal Canadiens
2022-10-14 00:00:00 | San Jose Sharks | Carolina Hurricanes
2022-10-14 00:00:00 | Winnipeg Jets | New York Rangers
2022-10-15 00:00:00 | [NAME] | Arizona Coyotes
2022-10-15 00:00:00 | Buffalo Sabres | Florida Panthers
2022-10-15 00:00:00 | Dallas Stars | Nashville Predators
2022-10-15 00:00:00 | Edmonton Oilers | Calgary Flames
2022-10-15 00:00:00 | Minnesota Wild | Los Angeles Kings
2022-10-15 00:00:00 | New Jersey Devils | Detroit Red Wings
2022-10-15 00:00:00 | New York Islanders | Anaheim Ducks
2022-10-15 00:00:00 | Philadelphia Flyers | [NAME]
2022-10-15 00:00:00 | Pittsburgh Penguins | Tampa Bay Lightning
2022-10-15 00:00:00 | [NAME] | [NAME] Knights
2022-10-15 00:00:00 | San Jose Sharks | Chicago Blackhawks
Spreadsheet: 730566d1619771850-count-if-max-threshold-book2
Sheet: Sheet1

Student | Year | Subject | Score
1 | 2020 | English | 33
1 | 2020 | Math | 45 |  |  |  |  |  | I want to count how many students have a maximum score < 30 by year
1 | 2020 | Science | 30
1 | 2020 | Humanities | 31
2 | 2020 | English | 21 |  |  |  |  | Year | 2019 | 2020
2 | 2020 | Math | 22 |  |  |  |  | Count | 1 | 1
2 | 2020 | Science | 20
2 | 2020 | Humanities | 21
2 | 2020 | Sport | 24
3 | 2019 | English | 21
3 | 2019 | Math | 20
3 | 2019 | Science | 20
3 | 2019 | Humanities | 21
3 | 2019 | Sport | 19
4 | 2019 | English | 50
4 | 2019 | Math | 21
4 | 2019 | Science | 44
4 | 2019 | Humanities | 31
Spreadsheet: 64641d1265430261-comparing-two-lists-and-copying-difference-to-a-third-problem-example
Sheet: Sheet1

UNFILTERED LIST | AVOID LIST | FILTERED LIST
shopper events | top us food retailers | shopper events
heart month 2010 | supermarket | heart month 2010
schwarz group | publix bogo | news articles on canadian tire corporation and frozen grocery
supermarket | demoulas market basket | brookshires fresh
demoulas market basket supermarket | schwarz group
delhaize america | demoulas market basket supermarket
news articles on canadian tire corporation and frozen grocery | delhaize america
brookshires fresh
top us food retailers
Spreadsheet: 109941d1306755376-excel-2007-changing-legend-as-per-the-likert-scale-graph-777605
Sheet: Sheet2

 | KAM is a fad! | AM meetings  - useful | AMA attendance add value
[NAME] | -2 | -1 | -3
Disagree | -9 | -4 | -4
Neutral | 1 | 4 | 4
Agree | 3 | 4 | 7
St Agree | 4 | 9 | 5
Positive neutral | 0.5 | 2 | 2
Negative neutral | -0.5 | -2 | -2
Pad | 19.5 | 18 | 18
Spreadsheet: darrell_schoolcraft__7304__imball0201
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 165610 | 167344
2 | 166480 | 167796
3 | 137938 | 137645
4 | 125026 | 124963
5 | 146499 | 137011
6 | 145029 | 145160
7 | 142059 | 140564
8 | 158164 | 152788
9 | 146091 | 145561
10 | 170217 | 161989
11 | 155187 | 155406
12 | 142391 | 140202
13 | 133550 | 132844
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  |  |  |  | 20
2001-12-31 00:00:00 |  |  | 47594.94 |  |  |  | 530
2002-01-13 00:00:00
 |  |  |  |  |  |  | 5989
CBS Volume
 |  |  | 20411
Spreadsheet: 082ab19e-d528-4892-b350-a135e66cb00b
Sheet: Sheet1

Table 5--USDA-calculated world market rice prices (rough basis) 1/ | 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
 | 2012/13 |  |  | 2011/12 |  |  | 2010/11
 |  | Medium/ |  |  | Medium/ |  |  | Medium/
Month | Long | short |  | Long | short |  | Long | short
 | $/cwt
August | 11.91 | 12.13 |  | 14.08 | 14.4 |  | 9.58 | 9.68
September | 12.57 | 12.81 |  | 15.09 | 15.44 |  | 10.51 | 10.62
October | 12.72 | 12.97 |  | 15.63 | 15.99 |  | 12.15 | 12.29
November | 12.92 | 13.17 |  | 14.93 | 15.28 |  | 13.4 | 13.58
December | 12.62 | 12.86 |  | 13.9 | 14.21 |  | 14.5 | 14.67
January | 12.35 | 12.59 |  | 12.61 | 12.88 |  | 13.98 | 14.15
February | 11.77 | 12.43 |  | 11.81 | 12.2 |  | 12.68 | 13.35
March | 12.16 | 12.84 |  | 11.52 | 11.92 |  | 12.13 | 12.76
April | 12.18 | 12.86 |  | 11.15 | 11.54 |  | 11.76 | 12.36
May  2/ | 12.13 | 12.8 |  | 11.42 | 11.82 |  | 11.58 | 12.17
June |  |  |  | 11.93 | 12.35 |  | 11.78 | 12.39
July |  |  |  | 11.97 | 12.4 |  | 12.49 | 13.14
Market-year
average 1/ | 12.333 | 12.746 |  | 13.00333333333334 | 13.36916666666666 |  | 12.21166666666667 | 12.59666666666666
1/ Simple average of the U.S. Department of Agriculture's weekly adjusted world market price.  2/  Preliminary.
Source: [NAME] and Rice Weekly Prices (ftp://ftp.fsa.usda.gov/public/cotton/default.htm), Farm Service Agency, USDA.
Last updated May 10, 2013.
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: Oasis

POI  8516
 | Scheduled | Measured | Imbal
1 | 106094 | 103793
2 | 97525 | 95166
3 | 97475 | 95009
4 | 97525 | 97000
5 | 102135 | 101639
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-05-31 00:00:00 |  | -4369
 | 2001-06-05 00:00:00
Spreadsheet: 685186d1593792449-dynamic-range-return-values-based-on-other-cell-value-pricing-tool-redacted
Sheet: Data

 |  |  |  |  | Service Groups |  |  | Service Options
 |  |  |  |  | Group Name | Group ID |  | Group ID | Option Name
 |  |  |  |  | Group 1 | 1 |  | 1 | Option 1
 |  |  |  |  | Group 2 | 2 |  | 1 | Option 2
 |  |  |  |  | Group 3 | 3 |  | 1 | Option 3
 |  |  |  |  |  |  |  | 2 | Option 4
 |  |  |  |  |  |  |  | 3 | Option 5
Spreadsheet: 270168d1381408485-taking-remaining-value-and-sharing-across-remaining-months-book2
Sheet: Sheet5

IGNORE THIS.
 | Year Total to budget |  |  | Extra | Total | P1 | P1 Actual | P2 | P2 Actual | P3 | P4 | P5 | P6 | P7 | P8 | EnvelopeTotal
250000 | 239700 |  | 17% of Envelope | 35700
How to resolve this problem?
 | Year Total |  |  |  | Total | P1 | P1 Actual | P2 | P2 Actual | P3 | P4 | P5 | P6 | P7 | P8 | Total
250000 |  |  |  |  |  |  | 55 |  | 56
Spreadsheet: 115097d1310725040-need-list-of-unique-values-for-sumiffed-records-unique-invoice-sample
Sheet: Sheet1

entry | Start | end | hrs. | task# | invoice#
1 | 12:30:00 | 13:00:00 |  | 3 | 4415 |  |  | Summary
2 | 08:00:00 | 12:00:00 |  | 5 | 4476
3 | 12:30:00 | 13:00:00 |  | 7 | 4435 |  |  | Task # | hrs. | Invoiced On:
4 | 08:30:00 | 10:45:00 |  | 4 | 4420 |  |  | 1
5 | 08:00:00 | 10:30:00 |  | 1 | 4415 |  |  | 2
6 | 14:30:00 | 15:30:00 |  | 5 | 4470 |  |  | 3
7 | 08:00:00 | 12:00:00 |  | 3 | 4418 |  |  | 4
8 | 12:30:00 | 13:30:00 |  | 4 | 4420 |  |  | 5
9 | 08:00:00 | 08:30:00 |  | 2 | 4476 |  |  | 6
10 | 08:00:00 | 11:00:00 |  | 6 | 4430 |  |  | 7
11 | 08:00:00 | 11:00:00 |  | 5 | 4470 |  |  | Total
12 | 08:00:00 | 18:00:00 |  | 3 | 4415
13 | 07:30:00 | 13:30:00 |  | 7 | 4430
14 | 07:45:00 | 18:45:00 |  | 6 | 4430
15 | 07:30:00 | 09:30:00 |  | 1 | 4476
16 | 08:00:00 | 10:30:00 |  | 2 | 4476
17 | 11:00:00 | 14:30:00 |  | 4 | 4420
18 | 07:30:00 | 08:15:00 |  | 4 | 4420
19 | 15:30:00 | 15:45:00 |  | 3 | 4415
20 | 08:00:00 | 11:00:00 |  | 6 | 4430
21 | 08:00:00 | 09:30:00 |  | 7 | 4433
22 | 10:30:00 | 11:00:00 |  | 4 | 4420
23 | 11:30:00 | 13:30:00 |  | 3 | 4415
24 | 07:30:00 | 09:30:00 |  | 6 | 4430
25 | 17:00:00 | 17:30:00 |  | 1 | 4476
26 | 15:15:00 | 18:00:00 |  | 5 | 4470
27 | 08:15:00 | 15:15:00 |  | 7 | 4433
28 | 16:45:00 | 17:45:00 |  | 2 | 4417
29 | 10:45:00 | 12:00:00 |  | 5 | 4470
30 | 12:30:00 | 15:30:00 |  | 4 | 4420
31 | 08:45:00 | 09:30:00 |  | 2 | 4476
32 | 13:30:00 | 17:45:00 |  | 3 | 4415
33 | 07:45:00 | 08:30:00 |  | 3 | 4415
34 | 13:30:00 | 16:30:00 |  | 2 | 4476
35 | 16:30:00 | 17:45:00 |  | 5 | 4470
36 | 13:30:00 | 17:00:00 |  | 6 | 4430
37 | 09:30:00 | 09:45:00 |  | 1 | 4476
38 | 15:45:00 | 16:00:00 |  | 7 | 4433
39 | 08:30:00 | 13:30:00 |  | 2 | 4476
40 | 07:30:00 | 11:30:00 |  | 5 | 4470
41 | 16:00:00 | 16:45:00 |  | 1 | 4476
42 | 07:30:00 | 08:45:00 |  | 5 | 4420
43 | 09:30:00 | 10:30:00 |  | 7 | 4433
44 | 10:30:00 | 11:00:00 |  | 3 | 4415
45 | 08:00:00 | 09:00:00 |  | 4 | 4420
46 | 08:00:00 | 08:30:00 |  | 2 | 4476
47 | 09:45:00 | 15:30:00 |  | 6 | 4430
48 | 17:45:00 | 18:15:00 |  | 3 | 4415
49 | 15:30:00 | 16:30:00 |  | 6 | 4430
50 | 11:00:00 | 12:00:00 |  | 7 | 4433
 | Total
Spreadsheet: 41280d1239775628-entering-a-payment-and-seeing-a-new-balance-new-20monthly-20payment-20sheet-202-1-
Sheet: Sheet1

Choose a Month |  |  | Car |  | Truck |  | Credit Card
July |  | Beginning Balance | 1000 |  | 2000 |  | 1500
 |  |  | Payment | Car New Balance | Payment | Truck New Balance | Payment | Credit Card New Balance
 |  | January | 50 | 950 | 50 | 1950 | 50 | 1450
 |  | February | 25 | 925 | 25 | 1925 | 25 | 1425
 |  | March | 100 | 825 | 100 | 1825 | 100 | 1325
 |  | April | 25 | 800 | 25 | 1800 | 25 | 1300
 |  | May | 50 | 750 | 50 | 1750 | 50 | 1250
Choose a Creditor |  | June | 25 | 725 | 25 | 1725 | 25 | 1225
Credit Card |  | July | 100 | 625 | 100 | 1625 | 100 | 1125
 |  | August | 50 | 575 | 50 | 1575 | 50 | 1075
Enter Payment | 100 | September | 25 | 550 | 25 | 1550 | 25 | 1050
999 |  | October | 25 | 525 | 25 | 1525 | 25 | 1025
New Balance | 1075 | November | 25 | 500 | 25 | 1500 | 25 | 1000
 |  | December | 50 | 450 | 50 | 1450 | 50 | 950
0
 |  |  |  |  | You choose a month,
 |  |  |  |  | You choose a creditor,
 |  |  |  |  | Enter a payment,
 |  |  |  |  | A new Balance appears.
 |  |  |  |  | I have the calculations and everything but I don't know how to link or look up or hook up the month, to the creditor to get to the payment in which that payment cell goes to a new balance.