tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 784659d1655893454-lookup-previous-price-in-price-list-previous-price-to-be-troubleshooted
Sheet: Price List

Date | Site | Supplier | P/N | MOQ | Price | Previous Price With Exact MOQ | Previous Price With Exact Or Closest MOQ
2022-06-21 00:00:00 | Paris | S1 | 123 | 10 | 12 |  |  |  | Task:
2022-06-21 00:00:00 | Paris | S1 | 258 | 30 | 16.5 |  |  |  | Lookup previous price matching with Site, [NAME], P/N and MOQ. If MOQ does not match, look for the closest (= smalest difference) salue in the previous price record instead.
2022-06-21 00:00:00 | Paris | S1 | 258 | 60 | 12.6 |  |  |  | If the previous price does not exist for the criteria above, show "-".
2022-06-21 00:00:00 | Prague | S1 | 456 | 100 | 6.8
2022-06-21 00:00:00 | Prague | S1 | 456 | 1000 | 4.5
2022-06-21 00:00:00 | Prague | S1 | 456 | 10000 | 3.8
2022-06-18 00:00:00 | London | S2 | 147 | 100 | 15
2022-06-18 00:00:00 | Paris | S2 | 123 | 20 | 10.6
2022-06-18 00:00:00 | Paris | S2 | 159 | 1000 | 14
2022-06-18 00:00:00 | Prague | S2 | 369 | 4500 | 13
2022-06-18 00:00:00 | Prague | S2 | 369 | 13500 | 10.1
2022-06-18 00:00:00 | Prague | S2 | 369 | 26000 | 8.2
2022-05-15 00:00:00 | Prague | S3 | 369 | 4500 | 12
2022-05-15 00:00:00 | Prague | S3 | 369 | 26000 | 7.4
2022-04-18 00:00:00 | Paris | S1 | 123 | 10 | 14
2022-04-18 00:00:00 | Paris | S1 | 258 | 30 | 17
2022-04-18 00:00:00 | Paris | S1 | 258 | 60 | 13
2022-04-18 00:00:00 | Prague | S1 | 456 | 100 | 6.8
2022-04-18 00:00:00 | Prague | S1 | 456 | 1000 | 4.2
2022-04-18 00:00:00 | Prague | S1 | 456 | 10000 | 3.8
2022-03-30 00:00:00 | Prague | S3 | 369 | 4500 | 13
2022-03-30 00:00:00 | Prague | S3 | 369 | 26000 | 6.5
2022-03-05 00:00:00 | London | S2 | 147 | 100 | 14
2022-03-05 00:00:00 | Paris | S2 | 123 | 20 | 14.3
2022-03-05 00:00:00 | Paris | S2 | 159 | 500 | 13 |  |  | should return 16,5 from F46
2022-03-05 00:00:00 | Prague | S2 | 369 | 6000 | 12 |  |  | should return 12 from F27
2022-03-05 00:00:00 | Prague | S2 | 369 | 13500 | 9.9 |  |  | should return 9,1 from F44
2022-03-05 00:00:00 | Prague | S2 | 369 | 26000 | 7.2
2022-03-05 00:00:00 | Paris | S2 | 159 | 100 | 20
2022-01-14 00:00:00 | Paris | S1 | 123 | 10 | 13
2022-01-14 00:00:00 | Paris | S1 | 258 | 30 | 16.5 |  |  | should return 11,2 from F33
2022-01-14 00:00:00 | Paris | S1 | 258 | 60 | 11.2
2022-01-14 00:00:00 | Prague | S1 | 159 | 200 | 17
2022-01-14 00:00:00 | Prague | S1 | 456 | 100 | 7
2022-01-14 00:00:00 | Prague | S1 | 456 | 1000 | 4.5
2022-01-14 00:00:00 | Prague | S1 | 456 | 10000 | 2.1
2021-12-22 00:00:00 | Prague | S3 | 369 | 4500 | 11
2021-12-22 00:00:00 | Prague | S3 | 369 | 26000 | 6.3
2021-12-19 00:00:00 | London | S2 | 147 | 100 | 16
2021-12-19 00:00:00 | Paris | S2 | 123 | 20 | 10.6
2021-12-19 00:00:00 | Paris | S2 | 159 | 1000 | 12
2021-12-19 00:00:00 | Prague | S2 | 369 | 4500 | 11
2021-12-19 00:00:00 | Prague | S2 | 369 | 10000 | 9.1
2021-12-19 00:00:00 | Prague | S2 | 369 | 26000 | 8.2
2021-12-19 00:00:00 | Paris | S2 | 159 | 100 | 16.5
Spreadsheet: 66564d1267199713-monthly-updates-excel-sheet-what-if-10
Sheet: PIVOT

Team | Dehydration
Count of ID | Date
Reported by | Jan | Feb | Grand Total
[NAME], [NAME] [Mukhaizna] | 2 | 2 | 4
[NAME], [NAME] | 2 | 2 | 4
[NAME], Hussain (Mukh -Operations) |  | 2 | 2
[NAME], Ahmed ([NAME]) | 1 | 1 | 2
[NAME], [NAME] | 2 |  | 2
[NAME], Is'haq S | 3 |  | 3
[NAME], Fahad N | 2 | 2 | 4
[NAME], [NAME] | 2 | 2 | 4
[NAME], [NAME] Mohamed | 2 | 1 | 3
[NAME], [NAME] Luaan |  | 4 | 4
[NAME], [NAME] | 1 |  | 1
[NAME], [NAME] | 4 | 3 | 7
[NAME], Fuad | 3 | 2 | 5
[NAME], [NAME] | 2 | 1 | 3
[NAME], Humaid | 2 |  | 2
[NAME], [NAME] |  | 1 | 1
[NAME], [NAME] | 2 | 1 | 3
[NAME], [NAME] |  | 3 | 3
[NAME], [NAME] | 2 |  | 2
[NAME], [NAME] | 2 | 1 | 3
[NAME], [NAME] |  | 1 | 1
[NAME], [NAME] | 2 | 2 | 4
[NAME], [NAME] | 1 | 1 | 2
[NAME], [NAME] | 2 | 3 | 5
[NAME], Aiman | 2 |  | 2
[NAME], [NAME] | 3 |  | 3
[NAME], [NAME] | 4 |  | 4
[NAME], [NAME] | 2 | 2 | 4
[NAME], [NAME] | 2 |  | 2
[NAME], [NAME] (Ipedex) |  | 2 | 2
[NAME], [NAME] (Ipedex) | 2 | 2 | 4
Baity, [NAME] (Ipedex) | 2 |  | 2
[NAME], Abdelkader | 3 | 2 | 5
Burkhart, [NAME] | 2 | 2 | 4
Dawson, [NAME] |  | 2 | 2
[NAME] ( Ipedex ) | 2 |  | 2
[NAME] | 2 | 2 | 4
Hammerle, [NAME] | 2 |  | 2
Irshad, [NAME] |  | 5 | 5
Irving, [NAME] (Ipedex) | 2 | 2 | 4
Kinney, [NAME] |  | 2 | 2
Legere, [NAME] (Ipedex) |  | 2 | 2
[NAME], [NAME] (Ipedex) | 1 | 3 | 4
Nair, Murali N | 5 | 1 | 6
OMAN\AlMughaN | 2 |  | 2
[NAME], Siluvai M | 2 | 2 | 4
Saeed, Mohammed | 2 |  | 2
Sharma, Omkar | 2 | 6 | 8
Vardarajan, Venkata S | 2 | 2 | 4
Grand Total | 85 | 74 | 159
Spreadsheet: 130700d1322522710-too-much-nesting-like-this
Sheet: Sheet1

62 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
 |  |  |  |  |  | Urethane | 786 | 98 | 164 | 9 | 923 | 939
 |  |  |  |  |  | Splatter | 669 | 84 | 691 | 995 | 359 | 181
 |  |  |  |  |  | Rhino | 744 | 568 | 77 | 284 | 164 | 465
 |  |  |  |  |  | Surlyn | 387 | 109 | 47 | 490 | 382 | 681
 |  |  |  |  |  | [NAME] | 713 | 997 | 757 | 819 | 27 | 737
 |  |  |  |  |  | [NAME] | 464 | 652 | 92 | 156 | 593 | 250
 |  |  |  |  |  | Teflon | 856 | 502 | 656 | 407 | 984 | 736
 |  |  |  |  |  | No-Mar Teflon | 22 | 510 | 73 | 366 | 971 | 867
 |  |  |  |  |  | Green Brush | 553 | 704 | 175 | 200 | 436 | 920
 |  |  |  |  |  | Black Brush | 393 | 254 | 685 | 945 | 476 | 424
 |  | 3 |  |  |  | Electro-Polish | 78 | 962 | 739 | 607 | 589 | 346
 |  |  |  |  |  | Epoxy Paint | 977 | 556 | 62 | 913 | 305 | 556
 |  |  |  |  |  | Rubber | 197 | 82 | 508 | 7 | 853 | 567
 |  |  |  |  |  | UHMW | 951 | 54 | 962 | 231 | 708 | 175
 |  |  |  |  |  | Red Urethane | 236 | 907 | 181 | 476 | 503 | 500
Epoxy Paint
Spreadsheet: 133548d1324476908-formula-for-rolling-back-three-months-sample
Sheet: Employee points and FMLA totals

Employee Name |  | Total Points: (Last Rolling three months as of today's date) | Total FMLA Time Missed (Last rolling 12 months as of today's date) | Today's Date: | 2011-12-16 00:00:00
 | Dept. Number |  |  | Three month rolling period: (points) | 2011-09-16 00:00:00
 |  |  |  | Twelve month rolling period: (FMLA) | 2010-12-16 00:00:00
[NAME] | 1 | 0.5 | 11
[NAME] | 2 | 2 | 0
[NAME] | 3 | 2 | 0
TEST
TEST
TEST
TEST
TEST
TEST
Spreadsheet: 131174d1322772076-creating-a-time-of-day-chart-tigeravatar-example-for-darko1975
Sheet: Sheet1

Date Left | Time Left | Time Returned |  | Hour of Day | %
2010-02-09 00:00:00 | 11:00:00 | 14:00:00 |  | 1
2010-07-09 00:00:00 | 16:00:00 | 18:00:00 |  | 2
2010-08-09 00:00:00 | 08:30:00 | 13:00:00 |  | 3
21/09/2010 | 08:00:00 | 16:05:00 |  | 4
21/09/2010 | 08:45:00 | 16:00:00 |  | 5
2010-06-10 00:00:00 | 09:45:00 | 10:50:00 |  | 6
2010-12-10 00:00:00 | 12:40:00 | 13:55:00 |  | 7
15/10/2010 | 13:00:00 | 15:00:00 |  | 8
16/10/2010 | 12:15:00 | 15:25:00 |  | 9
[NAME] | 09:45:00 | 20:15:00 |  | 10
20/10/2010 | 09:00:00 | 16:20:00 |  | 11
20/10/2010 | 12:00:00 | 19:30:00 |  | 12
25/10/2010 | 14:10:00 | 16:45:00 |  | 13
 |  |  |  | 14
 |  |  |  | 15
 |  |  |  | 16
 |  |  |  | 17
 |  |  |  | 18
 |  |  |  | 19
 |  |  |  | 20
 |  |  |  | 21
 |  |  |  | 22
 |  |  |  | 23
 |  |  |  | 24
Spreadsheet: 683876d1593018406-advanced-filter-how-to-write-formula-onto-the-criteria-cell-table
Sheet: Sayfa1

SalesRep | Sales | Experience |  |  |  | SalesRep
[NAME] | 10 | 1
[NAME] | 15 | 3
[NAME] | 30 | 5
George | 12 | 2
Anna | 25 | 4
Jordan | 13 | 2
Spreadsheet: 852854d1702829180-lookup-and-return-the-dates-falls-between-from-and-to-date-lookup-and-return-the-dates-falls-between-from-and-to-date
Sheet: Sheet1

ID Number | From Date | To Date
30165 | 2021-11-22 00:00:00
 | From Date | To Date | Nos. of Day
 | 2021-11-22 00:00:00 | 2021-11-25 00:00:00
 | 2021-11-26 00:00:00 | 2021-11-30 00:00:00
 | 2021-12-01 00:00:00 | 2021-12-02 00:00:00
 | 2021-12-13 00:00:00 | 2021-12-13 00:00:00
 | 2022-03-19 00:00:00 | 2022-03-31 00:00:00
 | 2022-04-01 00:00:00 | 2022-04-30 00:00:00
 | 2022-05-01 00:00:00 | 2022-05-01 00:00:00
Spreadsheet: 44515d1243268581-vlookup-problem-vlookup-problem
Sheet: Sheet1

w |  | 2a | 3c
1 |  | 1b | 1a
2c |  | 2c | 2b
2b |  | 2b | 2a
2a |  | 2a | 3c
3 |  | 3b | 3a
w | w | 1c | 1c | 1b | 1b
1 | 1b | 1a | 1a | 2c | 2c
2c | 2c | 2b | 2b | 2a | 2a
2b | 2b | 2a | 2a | 3c | 3c
2a | 2a | 3c | 3c | 3b | 3b
3 | 3b | 3a | 3a | 4c | 4c
Spreadsheet: 99267d1297959245-cell-not-duplicated-on-three-rows-but-need-to-use-it-in-function-possible-example1
Sheet: CashFlows

AccountID | CFTYpe | January | February | March | April | May | June | July | August | September | October | November | December
123 | 1 | 123 | 43 | 234 | 5 | 4323 | 45 | 2345 | 23462 | 3623 | 5 | 4234 | 54
123 | 2 | 234 | 2345 | 3215 | 324 | 897 | 86 | 8 | 46 | 864 | 86 | 48 | 48
123 | 3 | 523 | 2345 | 2345 | 5623 | 89 | 746 | 97 | 78 | 789 | 67 | 4 | 87
432 | 1 | 45 | 36 | 235 | 5623 | 9 | 48 | 64 | 3 | 346 | 9 |  | 789
432 | 2 | 2345 | 62 | 2345 | 8 | 8 | 6 | 45 | 34 | 56 | 6 | 987 | 4356
432 | 3 | 234 | 623 | 234 | 978 | 79 | 789 | 534 | 65 | 45 | 345 | 54 | 46
444 | 1 | 523 | 23 | 6235 | 9 | 8 | 648 | 34 | 3456 | 56 | 3456 | 3456 | 26
444 | 2 | 62 | 56 | 64 | 78 | 89 | 8 | 2 | 634 | 5324 | 523 | 452 | 2346
444 | 3 | 4 | 6 | 4562 | 97 | 7 | 68 | 326 | 2345 | 2345 | 325 | 24 | 345
5423 | 1 | 34562 | 234 | 345 | 89 | 789 | 68 | 2346 | 45 | 523 | 324 | 6 | 52
5423 | 2 | 3452 | 2345 | 2345 | 78 | 90 | 4 | 45 | 523 | 6234 | 23 | 26 | 5234
5423 | 3 | 345 | 2345 | 265236 | 0 | 78 | 74 | 2345 | 23 | 4523 | 45 | 2345 | 5234
544 | 1 | 23452 | 45 | 23 | 907 | 8790 | 67 | 234 | 23 | 45 | 34 | 2365 | 234
544 | 2 | 2345 | 23 | 562 | 890 | 90 | 467 | 2 | 2345 | 45 |  | 235 | 235
544 | 3 | 563 | 2345 | 345 | 7890 | 78 | 4 | 452345 | 523 | 324 | 345 | 346 | 52
Spreadsheet: 779249d1651667368-merging-duplicate-rows-duplicate-example
Sheet: Sheet1

Location | Postal Sector
Place 1 | AL10 9
Place 2 | AL10 9
Place 1 | AL2 1
Place 3 | AL2 1
Place 1 | AL4 0
Place 3 | AL4 0
Place 1 | AL7 2
Place 2 | AL7 2
Place 2 | AL7 3
Place 4 | AL7 3
Place 2 | AL7 4
Place 3 | AL7 4
Place 3 | AL9 5
Place 4 | AL9 5
Spreadsheet: 66565d1267199916-chart-charthelp
Sheet: Sheet1

Country | Operator
france | tom
germany | [NAME]
france | rich
uk | jo
brazil | jo
germany | jo
france | tom
germany | [NAME]
uk | rich
uk | jo
uk | jo
uk | rich
uk | [NAME]
holland | tom
sweden | tom
holland | jo
sweden | jo
uk | rich
uk | [NAME]
Spreadsheet: jonathan_mckay__17192__June Index Summary
Sheet: TETCO WLA

EOL Transaction Summary Report
Criteria: | Traders
 | [NAME]
 | Product:
 | US Gas Phy Fwd
EnronOnline Report | All Counterparties |  |  |  | Generated on:   1/31/01 11:09:22 AM
Product | Date-Time | Volume | Price
US Gas Phy       TETCO WLA               Jun01           USD/MM | 05/29/2001 03:26 pm | 1064 | 3.66
US Gas Phy       TETCO WLA               Jun01           USD/MM | 05/30/2001 09:08 am | 5000 | 3.58
US Gas Phy       TETCO WLA               Jun01           USD/MM | 05/30/2001 09:11 am | 1312 | 3.55
US Gas Phy       TETCO WLA               Jun01           USD/MM | 05/30/2001 09:14 am | 1312 | 3.55
US Gas Phy       TETCO WLA               Jun01           USD/MM | 05/30/2001 10:24 am | 5000 | 3.585
 | TOTAL VOLUME
Weighted Average
Spreadsheet: 77059d1277489648-formula-that-brings-data-to-new-tab-if-cell-not-0-blank-cc-example
Sheet: Data

DATE | AMOUNT | Index Value | Index
2010-06-24 00:00:00 | 5 |  | 0
2010-06-24 00:00:00 | 6 |  | 0
2010-06-24 00:00:00 | 6
2010-06-24 00:00:00 | 12 |  | 0
2010-06-24 00:00:00 | 15 |  | 0
2010-06-24 00:00:00 | 18 |  | RCW
2010-06-24 00:00:00 | 6 |  | EVT
2010-06-24 00:00:00 | 6 |  | L&D
2010-06-24 00:00:00 | 37 |  | 0
2010-06-24 00:00:00 | 6
2010-06-24 00:00:00 | 520 |  | 0
Spreadsheet: darron_c_giron__7992__midland_cogen
Sheet: firm9703

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
MARCH 1997
IFGMR (TRKL/TX) |  |  | 1.64 |  |  | No. of Days: | 31
IFGMR (TRKL/LA) |  |  | 1.67
IFGMR (PEPL/TX/OK) |  |  | 1.64
IFGMR (ANR/LA) |  |  | 1.65
IFGMR (HENRY HUB) |  |  | 1.78
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001 | 3.93
 | 1993 | 2.4 | 2002 | 4.23
 | 1994 | 2.51 | 2003 | 4.73
 | 1995 | 2.61 | 2004 | 5.07
 | 1996 | 2.53 | 2005 | 5.43
 | 1997 | 2.65 | 2006 | 5.82 | JAN-SEP
 | 1998 | 2.67 | 2006 | 5.95 | OCT-DEC
 | 1999 | 2.9 | 2007 | 6.37
 | 2000 | 3.33
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-302
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: 818960d1677146002-running-total-formula-using-three-columns-test-running-figure-formula
Sheet: Sheet1

Transaction Date | Debit Amount | Credit Amount | Running
2023-01-03 00:00:00 |  | 69.77 | 500
2023-01-03 00:00:00 | 50
2023-01-03 00:00:00 | 2.5
2023-01-03 00:00:00 | 50
2023-01-03 00:00:00 | 2
2023-01-03 00:00:00 | 43.14
2023-01-03 00:00:00 |  | 60
2023-01-03 00:00:00 | 20
2023-01-03 00:00:00 | 20
Spreadsheet: 847213d1698246726-how-to-dynamically-denote-unique-records-in-filtered-range-or-table-book1
Sheet: Sheet1

Neigh Code | Project Type | Distinct? | Helper
1 | ABC | Distinct
1 | EFG
1 | HIJ
2 | ABC | Distinct
Spreadsheet: 43099d1241698724-vlookup-or-macro-help-book1_may7
Sheet: Sheet2

PART | SITE | QTY |  |  |  | Sum of QTY | SITE
Part 1 | Site 1 | 5 | (from SQL) |  |  | PART | Site 1 | Site 2 | Grand Total
Part 2 | Site 1 | 6 | (from SQL) |  |  | Part 1 | 5 | 7 | 12
Part 1 | Site 2 | 7 | (from SQL) |  |  | Part 2 | 6 | 8 | 14
Part 2 | Site 2 | 8 | (from SQL) |  |  | Grand Total | 11 | 15 | 26
Spreadsheet: 01b456aa-1237-4ef5-87bc-87fe788b1b77
Sheet: Sheet2

9300 | 666.16
9315 | 778.6
9315 | 3689.42
9320 | 74667.01
9325 | 17088
9330 | 48891
9330 | 563375.4
9340 | 38015
9340 | 5685.57
9350 | 500
9350 | 3985.94
9360 | 25
9360 | 1560.26
9370 | 332
9380 | 6471.53
9380 | 13196.44
9390 | 637.37
9390 | 2053.11
9400 | 2258.49
9400 | 450745.91
9445 | 29150.84
9445 | 305141.24
9465 | 92022
9465 | 76601.87
9470 | 135784
9470 | 7525.69
9475 | 124469
9475 | 9546.94
9480 | 309609
9485 | -2602.27
9485 | 216628.43
9495 | 843.28
9495 | 50393.24
9525 | 387
9525 | 162.5
9535 | 84371.64
9535 | 1460594.54
9545 | 359002.57
9555 | 370638
9565 | 115
9565 | 124361
9575 | 3808430.9
9575 | 1012645.17
9585 | 250347.95
9585 | 1602713.01
9590 | 56.6
9595 | 25072.9
9595 | 403705.48
9635 | 100
9635 | 429284.7
9640 | 331960
9640 | 9581.92
9645 | 2247.65
9645 | 919161.47
9650 | 429749.9
9650 | 83448.02
9655 | 85342
9655 | 830.46
9660 | 480982
9665 | 152565
Spreadsheet: 99314d1297977573-picking-up-a-particular-list-workbook22
Sheet: Sheet1

ZERO | ONE | TWO | THREE | FOUR | FIVE | SIX | SEVEN | EIGHT | NINE
080 | 017 | 026 | 350 | 044 | 350 | 026 | 017 | 080 | 090
017 | 611 | 125 | 413 | 413 | 125 | 611 | 072 | 018 | 190
026 | 125 | 242 | 332 | 242 | 405 | 126 | 117 | 028 | 092
350 | 413 | 332 | 342 | 405 | 522 | 046 | 037 | 181 | 309
044 | 018 | 072 | 153 | 342 | 153 | 163 | 721 | 083 | 192
090 | 117 | 522 | 037 | 414 | 550 | 226 | 074 | 218 | 049
018 | 126 | 342 | 163 | 046 | 154 | 056 | 317 | 804 | 319
072 | 153 | 126 | 253 | 154 | 253 | 614 | 272 | 813 | 229
405 | 414 | 028 | 334 | 244 | 056 | 326 | 570 | 282 | 905
190 | 190 | 721 | 083 | 334 | 542 | 066 | 174 | 805 | 419
028 | 181 | 226 | 317 | 074 | 353 | 516 | 273 | 814 | 923
037 | 721 | 253 | 326 | 614 | 570 | 246 | 760 | 382 | 690
046 | 163 | 244 | 353 | 542 | 516 | 363 | 517 | 581 | 159
550 | 154 | 092 | 344 | 344 | 255 | 760 | 472 | 428 | 249
092 | 218 | 218 | 309 | 804 | 543 | 166 | 373 | 383 | 393
083 | 317 | 272 | 813 | 174 | 805 | 256 | 770 | 870 | 907
074 | 614 | 326 | 273 | 246 | 517 | 346 | 176 | 618 | 169
056 | 192 | 542 | 363 | 543 | 256 | 176 | 752 | 528 | 259
309 | 813 | 192 | 543 | 049 | 355 | 266 | 347 | 438 | 089
804 | 174 | 282 | 319 | 814 | 445 | 653 | 870 | 808 | 179
570 | 516 | 273 | 382 | 472 | 905 | 464 | 177 | 187 | 926
066 | 319 | 246 | 373 | 346 | 581 | 690 | 762 | 268 | 593
049 | 814 | 255 | 346 | 445 | 752 | 618 | 357 | 484 | 449
805 | 517 | 229 | 355 | 419 | 653 | 762 | 447 | 089 | 909
760 | 166 | 382 | 923 | 428 | 159 | 366 | 907 | 188 | 189
905 | 419 | 472 | 383 | 347 | 528 | 645 | 187 | 728 | 792
770 | 581 | 256 | 347 | 464 | 357 | 169 | 277 | 638 | 639
690 | 176 | 923 | 653 | 249 | 645 | 268 | 637 | 485 | 954
870 | 159 | 428 | 393 | 438 | 259 | 637 | 475 | 189 | 289
907 | 618 | 752 | 438 | 447 | 475 | 466 | 179 | 378 | 739
808 | 177 | 266 | 357 | 645 | 556 | 556 | 728 | 684 | 496
089 | 169 | 249 | 366 | 484 | 593 | 926 | 377 | 855 | 595
909 | 187 | 528 | 637 | 475 | 485 | 638 | 467 | 289 | 992
 | 179 | 762 | 593 | 466 | 557 | 467 | 557 | 865 | 389
 | 188 | 259 | 638 | 449 | 665 | 665 | 792 | 389 | 497
 | 189 | 268 | 377 | 485 | 954 | 639 | 378 | 848 | 659
 |  | 277 | 639 | 467 | 855 | 684 | 567 | 578
 |  | 926 | 378 | 954 | 567 | 567 | 739 | 866
 |  | 728 | 739 | 684 | 595 | 496 | 577
 |  | 792 | 389 | 496 | 865 | 865 | 766
 |  | 289 |  | 497 | 577 | 766 | 497
 |  | 992 |  | 848 | 659 | 659 | 578
 |  |  |  |  | 578 | 866 | 767
 |  |  |  |  |  | 767
Spreadsheet: 149270d1333796964-excel-2003-how-do-i-copy-contents-of-cells-identified-by-sumproduct-ef74_sample-2-
Sheet: Sheet3

Select Criteria
Actors
Actresses
Male
Female
Shop 1
Shop 2
Shop 3
Shop 4
Shop 5
Shop 6
Shop 7
Shop 8
Shop 9
Shop 10
Shop 11
Shop 12
Shop 13
Shop 14
Shop 15
Shop 16
Shop 17
Shop 18
Shop 19
Shop 20
Pay Numbers <3500000
Pay Numbers >=3500000
Spreadsheet: 167794d1342105043-excel-2007-vlookup-help-2012-bud-help
Sheet: May

Monthly [NAME]
 | [NAME] |  |  | Date Due | Date Paid | Amount Due | Amount Paid | Status | Comment
 | Mortgage |  |  | 2012-05-01 00:00:00 | 2012-05-01 00:00:00 | 875.48 | 875.48
 | Tundra |  |  | 2012-05-15 00:00:00 | 2012-05-15 00:00:00 | 343.92 | 343.92
 | Cruze |  |  | 2012-05-05 00:00:00 | 2012-04-28 00:00:00 | 242.3 | 242.3
 | Verizon Wireless |  |  | 2012-05-23 00:00:00 | 2012-05-19 00:00:00 | 167.42 | 167.42
 | RZMC |  |  | 2012-05-18 00:00:00 | 2012-05-11 00:00:00 | 25 | 100
 | Capital One
 | Household Bank
 | Insurance |  |  | 2012-05-15 00:00:00 | 2012-05-15 00:00:00 | 68.74 | 68.74
 | RG&E |  |  | 2012-05-11 00:00:00 | 2012-05-11 00:00:00 | 99.52 | 99.52
 | Time Warner |  |  | 2012-05-16 00:00:00 | 2012-05-19 00:00:00 | 121.32 | 121.32
 | ACS |  |  | 2012-05-14 00:00:00 | 2012-05-29 00:00:00 | 156.29 | 156.29
 | AES |  |  | 2012-06-01 00:00:00 | 2012-05-21 00:00:00 | 138.27 | 138.27
 | Sallie Mae |  |  | 2012-05-07 00:00:00 | 2012-05-07 00:00:00 | 213.47 | 213.47
 | 1st Financial |  |  | 2012-05-23 00:00:00 | 2012-05-23 00:00:00 | 35 | 50
 | Waste Management
 | Water Authority |  |  | 2012-05-14 00:00:00 | 2012-05-21 00:00:00 | 42.22 | 51.44 |  | paid late
 | Wells Fargo - Furniture |  |  | 2012-05-16 00:00:00 | 2012-05-11 00:00:00 | 40 | 40
 | Doe |  |  | 2012-05-21 00:00:00 | 2012-05-19 00:00:00 | 301.32 | 301.32
 | [NAME]
 | Paychecks
 |  |  |  | Pay Date | Amount
 |  |  |  | 2012-05-04 00:00:00 | 1152.15
 |  |  |  | 2012-05-18 00:00:00 | 1152.15
 |  |  |  | 2012-05-11 00:00:00 | 264.09
 |  |  |  | 2012-05-25 00:00:00 | 420.15
 | Total Bills for month:
 | Total Payments for month:
 | Total Income for the month
Spreadsheet: 462961d1464258910-moving-average-example
Sheet: Sheet1

 |  | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Average |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | [NAME] | 125000 | 150000 | 165000 | 180000 | 195000 | 210000 | 215000
Spreadsheet: 14541f1d-63f5-4af9-8128-c0360cf99263
Sheet: Sheet1

Unnamed: 0 | Project Director | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Project Name
 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Cummunlative
Item
Consultants Services
Consultants Services sub-total
Travel/Conferences
Milage reimbursement
National Travel
Local Conferences
National Conferences
Travel/Conferences sub-total
Equipment
Equipment sub-total
Office/General Supplies or Materials
Office/Gen'l Supplies or Materials sub-total
Instructional/Student Materials
Instructional/Student Materials sub-total
Other
Internal Printing
External Printing
Food Services and Entertainment
Communications-Postage
Communications-Messenger Service
Communications-Phone
Miscellaneous
Other Expenses sub-total
Scholarships & Student Aid
Scholarships & Student Aid sub-total
Subcontracts
Subcontracts sub-total
TOTAL Other Direct | 0 | 0 | 0 | 0 | 0 | 0
Notes:
Spreadsheet: 05b867df-b024-4d6c-b6c2-25625e0b2c73
Sheet: ETHNICITY % GRAPH

BACK TO TABLE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column Labels
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Values | White | Hispanic | African American | Filipino | Asian | Multi-Race | Pacific Islander | Native American | Unknown | Grand Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY 09-10 | 0.5016677785190127 | 0.3435623749166111 | 0.05203468979319546 | 0.04336224149432955 | 0.03202134756504336 | 0.01134089392928619 | 0.008005336891260841 | 0.00733822548365577 | 0.0006671114076051143 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY 08-09 | 0.5252128356254093 | 0.3307138179436804 | 0.045841519318926 | 0.04715127701375246 | 0.01309757694826457 | 0.01702685003274394 | 0.0045841519318926 | 0.0137524557956778 | 0.002619515389652882 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY 07-08 | 0.5078683834048641 | 0.3226037195994277 | 0.0586552217453505 | 0.04721030042918455 | 0.02646638054363376 | 0.02145922746781116 | 0.00357653791130186 | 0.01144492131616595 | 0.0007153075822603494 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY 10-11 | 0.4859514687100894 | 0.3614303959131545 | 0.04533844189016603 | 0.03256704980842912 | 0.03256704980842912 | 0.01979565772669221 | 0.008939974457215836 | 0.01213282247765006 | 0.00127713920817385 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY 11-12 | 0.4859693877551021 | 0.3539540816326531 | 0.05038265306122449 | 0.05102040816326531 | 0.02869897959183674 | 0.01530612244897959 | 0.003188775510204082 | 0.006377551020408163 | 0.005102040816326481 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comparison (Enrolled AY 11-12 + 3 Terms) | 0.41 | 0.3556141672946496 | 0.07 | 0.03 | 0.03 | 0.08 | 0.01 | 0.01 | 0.05 | 1.04561416729465