tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 220270d1363111178-complex-data-extraction-from-a-table-dinners-example1
Sheet: Sheet1

Type of Dinner | Week Ending: |  |  |  |  | 2012-09-07 00:00:00 |  | Week Ending: |  |  |  |  | 2012-09-14 00:00:00 |  | Week Ending: |  |  |  |  | 2012-09-21 00:00:00 |  | Week Ending: |  |  |  |  | 2012-09-28 00:00:00
Class | M | T | W | Th | F | Weekly Total |  | M | T | W | Th | F | Weekly Total |  | M | T | W | Th | F | Weekly Total |  | M | T | W | Th | F | Weekly Total |  | To Print
Absent (O) | 0 | 0 | 8 | 9 | 12 | 29 |  | 9 | 9 | 8 | 8 | 11 | 45 |  | 13 | 14 | 11 | 11 | 13 | 62 |  | 12 | 11 | 8 | 10 | 10 | 51 |  | 2012-09-14 00:00:00 | Dinners | S & G
Dinner (/) | 0 | 0 | 60 | 56 | 56 | 172 |  | 58 | 59 | 50 | 57 | 60 | 284 |  | 56 | 52 | 49 | 55 | 59 | 271 |  | 56 | 58 | 52 | 54 | 62 | 282 |  | Monday
Pack up (P) | 0 | 0 | 0 | 3 | 2 | 5 |  | 0 | 2 | 0 | 3 | 0 | 5 |  | 0 | 5 | 0 | 0 | 0 | 5 |  | 0 | 4 | 0 | 2 | 0 | 6 |  | Tuesday
Sandwiches (S) | 0 | 0 | 11 | 11 | 10 | 32 |  | 10 | 9 | 11 | 10 | 10 | 50 |  | 8 | 10 | 10 | 10 | 9 | 47 |  | 10 | 10 | 10 | 10 | 10 | 50 |  | Wednesday
[NAME] (G) | 0 | 0 | 10 | 10 | 9 | 29 |  | 8 | 9 | 9 | 8 | 8 | 42 |  | 8 | 8 | 8 | 8 | 8 | 40 |  | 7 | 6 | 8 | 8 | 7 | 36 |  | Thursday
College (C) | 0 | 0 | 0 | 0 | 0 | 0 |  | 2 | 1 | 11 | 2 | 0 | 16 |  | 0 | 0 | 11 | 2 | 0 | 13 |  | 0 | 0 | 11 | 3 | 0 | 14 |  | Friday
Cooking (CK) | 0 | 0 | 0 | 0 | 0 | 0 |  | 2 | 0 | 0 | 0 | 0 | 2 |  | 4 | 0 | 0 | 1 | 0 | 5 |  | 4 | 0 | 0 | 0 | 0 | 4 |  | Totals
 | Paid Dinner Totals |  |  |  |  |  |  | Paid Dinner Totals |  |  |  |  |  |  | Paid Dinner Totals |  |  |  |  |  |  | Paid Dinner Totals
Paid Totals | 0 | 0 | 89 | 89 | 89 | 267 |  | 89 | 89 | 89 | 89 | 89 | 445 |  | 89 | 89 | 89 | 89 | 89 | 445 |  | 89 | 89 | 89 | 89 | 89 | 445
Spreadsheet: 130574d1322472229-lookup-sumif
Sheet: YEARLY COMPARISON

 | 2008 | 2009
NAMES | VALUES | VALUES
AB | 2000 | 150
C | 300 | 2580
D | 4000 | 5582
F | 4100 | 8202.66666666667
G | 5100 | 10918.6666666667
HK | 6100 | 13634.6666666667
L | 7100 | 16350.6666666667
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 |  | 173680
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 |  | 159121 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 |  | 200740
500293 |  | 102156
500302 | 1865
500303 |  | 55565
500305 |  | 226685
500307 |  | 11055
500313 |  | 525
500314
500655 | 98146
500657 |  | 30000
INDEX
2001-05-31 00:00:00 |  |  | 149635.26
2001-06-05 00:00:00
Spreadsheet: 48563d1247778412-how-to-if-calculation-result-show-dropdown-list-data-validation-demo
Sheet: USer Sheet

Material | Density | Volume | Weight
B | 2 | 5 | 10
B | 2 | 5 | 10
A | 1 | 5 | 5
C | SHOW DROPDOWN | 5 | #N/A
 |  | 5 | #N/A
 |  | Note volume is user entered and is arbitrary for this example
Spreadsheet: 874504d1721117253-sort-list-of-dates-times-wont-work-sorting-times-and-dates
Sheet: Blad2

tijdstip
27-09-2023 15:43:29.197
27-09-2023 15:43:18.289
27-09-2023 15:43:00.143
27-09-2023 15:43:00.127
27-09-2023 15:42:45.059
27-09-2023 15:40:43.185
27-09-2023 15:39:44.949
27-09-2023 15:38:42.447
27-09-2023 15:38:24.786
27-09-2023 15:34:56.638
27-09-2023 15:34:42.888
27-06-2024 09:35:35.355
26-09-2023 11:06:44.532
26-09-2023 11:02:00.758
26-09-2023 11:01:24.184
25-09-2023 17:55:08.623
25-09-2023 17:31:34.926
25-09-2023 17:31:03.177
22-09-2023 10:47:03.157
22-09-2023 10:39:17.101
22-09-2023 09:50:27.105
22-09-2023 09:50:27.100
22-09-2023 09:50:27.099
22-09-2023 09:50:27.084
22-09-2023 09:50:27.082
22-09-2023 09:50:27.019
22-09-2023 09:50:27.017
22-09-2023 09:50:27.017
22-09-2023 09:50:26.241
22-09-2023 09:50:26.116
22-09-2023 09:50:26.116
20-02-2023 14:13:00.211
20-02-2023 14:12:25.940
20-02-2023 14:12:25.938
20-02-2023 14:12:25.938
20-02-2023 14:12:25.913
20-02-2023 14:12:25.913
20-02-2023 14:12:25.910
20-02-2023 14:12:25.877
20-02-2023 14:12:25.877
20-02-2023 14:12:25.877
20-02-2023 14:12:23.014
20-02-2023 14:12:23.012
20-02-2023 14:12:22.908
20-02-2023 14:12:22.905
20-02-2023 14:12:22.870
20-02-2023 14:12:22.870
20-02-2023 14:12:22.870
20-02-2023 14:12:20.546
20-02-2023 14:12:20.544
20-02-2023 14:12:20.502
20-02-2023 14:12:20.500
20-02-2023 14:12:20.466
20-02-2023 14:12:20.466
20-02-2023 14:12:20.466
20-02-2023 14:12:20.412
20-02-2023 14:12:20.396
20-02-2023 14:12:19.384
20-02-2023 14:12:19.355
20-02-2023 14:12:19.355
20-02-2023 14:12:19.355
20-02-2023 14:12:11.964
20-02-2023 14:12:11.964
20-02-2023 14:12:00.714
20-02-2023 14:12:00.675
20-02-2023 14:12:00.671
20-02-2023 14:12:00.671
20-02-2023 14:12:00.668
20-02-2023 14:12:00.661
20-02-2023 14:12:00.087
20-02-2023 14:11:59.990
20-02-2023 14:11:59.990
20-02-2023 11:58:59.478
20-02-2023 11:56:34.193
19-09-2023 09:57:18.153
19-09-2023 09:57:18.140
19-09-2023 09:57:17.122
19-09-2023 09:57:17.100
19-09-2023 09:57:17.100
19-09-2023 09:57:17.100
19-09-2023 09:56:39.187
19-09-2023 09:56:39.183
19-09-2023 09:56:39.182
19-09-2023 09:56:39.160
19-09-2023 09:56:39.160
19-09-2023 09:56:39.100
19-09-2023 09:56:39.097
19-09-2023 09:56:39.097
19-09-2023 09:56:38.202
19-09-2023 09:56:38.065
19-09-2023 09:56:38.065
12-31-2018 10:19:00.000
12-31-2018 10:19:00.000
12-31-2018 10:19:00.000
12-31-2018 10:19:00.000
12-31-2018 10:19:00.000
12-31-2018 10:19:00.000
12-30-2021 09:52:31.747
12-30-2021 09:52:31.747
Spreadsheet: 833eba10-4ffa-4667-87c2-22b0536d5841
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5217 | 25148 | [NAME] | Mosquera | USA | 0 | 01:05:50 | 00:03:30 | [NAME] | [NAME] | 00:48:45 | 1 | 03:33:03
Spreadsheet: 70649d1271352391-bring-scattered-data-to-correct-columns-sample1
Sheet: Sheet1

PARCEL/ACCT # | CERTIFICATE ID | YEAR | APPROVAL | DATE | CD | NAME | REASON | COMMENT | Prior Assmt | New Assmt | Difference
 |  |  | LB     06/16/2009 |  |  |  |  |  | 0 | 11813 | 11813
10072 |  |  |  |  | P | CALDWELL REBEKAH
9887 |  | 2007 | 2009-06-16 00:00:00 |  |  | TDS   TAX DATA SOLUTIONS |  |  | 0 | 10479
 |  | TVAL |  |  |  |  |  |  | 0 | 0
 |  |  | LB     06/16/2009 |  |  |  |  |  | 0 | 10479 | 10479
10072 |  |  |  |  | P | CALDWELL REBEKAH
9888 |  | 2008 | 2009-06-16 00:00:00 |  |  | TDS   TAX DATA SOLUTIONS |  |  | 0 | 6454
 |  | TVAL |  |  |  |  |  |  | 0 | 0
 |  |  | LB     06/16/2009 |  |  |  |  |  | 0 | 6454 | 6454
Spreadsheet: d06a01c0-d37f-4180-9a44-96c79ad1e65c
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify in which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2005-06 |  |  | FY 2006-07
 | General Fund |  |  | $ | 220000 |  | $ | 0
 | Special Revenue |  |  | $ |  |  | $
 | Enterprise |  |  | $ |  |  | $
 |  |  | Total: | $ | 220000 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known or, if grant revenue, please identify source of funds (federal or state) and duration of grant support.)
 | Property tax
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | X | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2005-06 |  |  | FY 2006-07
 | General Fund |  |  | $ | 220000 |  | $
 | Special Revenue |  |  | $ |  |  | $
 | Enterprise/Other |  |  | $ |  |  | $
 |  |  | Total: | $ | 220000 |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
 | Increase in appropriation from Property Tax revenue; the remaining $830,000 is transferred from the Contingent
 | Appropriation to the Police Department.
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimated number of people to be served, who is currently delivering services to that population, service
 | performance expectations and, if grant supported, provisions for support if grant support ends.)
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
0ffice of Management and Budget |  |  |  |  |  | OMB Approval Date
Spreadsheet: 465005d1465402773-tally-counters-observ
Sheet: Hoja1

 |  | Variables | [NAME] | [NAME] | Ítem
 |  | ([NAME]) [NAME] propuesto por [NAME] | Elementos del proceso de comunicación en el aula | Circuito multidireccional | Número de eventos
 |  |  |  | Actividades interactivas en clase
 |  |  |  | Eventos de autoaprendizaje
 |  |  |  | Uso de herramientas adicionales de comunicación
 |  |  |  | Uso de información adicional
 |  |  |  | Reglas en clase
 |  |  |  | Retroalimentación
 |  | (VI) [NAME] | Elementos tradicionales | Paternalismo
 |  |  |  | [NAME]
 |  |  |  | Ruido
 |  |  |  | Imposición del maestro
 |  |  |  | Castigo
Spreadsheet: 138079d1327508207-excel-2007-need-help-til-net
Sheet: Sheet1

Work.Number. | Name | Date | MBM   -1- | Date | MBM   -2- | Status | Missing
 | Service
x | x |  | 1 |  | 5 | 6 | 0
x | x |  | 1 |  | 2 | 3 | 1
x | x |  | 2 |  | 7 | 9 | 0
x | x |  |  |  | 1 | 1 | 1
x | x |  |  |  |  | 0 | 1
x | x |  |  |  |  | 0 | 1
x | x |  |  |  |  | 0 | 1
x | x |  |  |  |  | 0 | 1
x | x |  |  |  |  | 0 | 1
x | x |  | 7 |  | 4 | 11 | 0
x | x |  |  |  |  | 0 | 1
x | x |  |  |  |  | 0 | 1
x | x |  |  |  |  | 0 | 1
x | x |  |  |  |  | 0 | 1
x | x |  |  |  |  | 0 | 1
x | x |  |  |  |  | 0 | 1
x | x |  |  |  |  | 0 | 1
Spreadsheet: 887154d1737364932-find-all-matched-vlookup-returned-first-or-last-occurrence-i-need-all-matched-results-penalty
Sheet: Sheet1

 |  |  | =[@Registered]-[@Attended] | REQUIRED RESULTS HERE | =[@Penalty]*[@Absent]
Branch | Registered | Attended | Absent | Penalty | Plenty Amount |  | Branch | From | To | Penalty |  | Branch
A |  |  | 0 |  |  |  | A | 3 | 5 | 300 |  | A
A |  |  | 1 |  |  |  | A | 6 | 7 | 500 |  | B
A |  |  | 2 |  |  |  | A | 8 |  | 700 |  | C
A |  |  | 3 |  |  |  | B | 2 | 5 | 250 |  | D
A |  |  | 4 |  |  |  | B | 6 | 7 | 350 |  | E
A |  |  | 5 |  |  |  | B | 8 |  | 400 |  | F
A |  |  | 6 |  |  |  | C | 1 | 3 | 150
A |  |  | 7 |  |  |  | C | 4 | 6 | 270
A |  |  | 8 |  |  |  | C | 7 |  | 325
A |  |  | 9 |  |  |  | D | 1 | 2 | 75
A |  |  | 10 |  |  |  | D | 3 | 5 | 180
A |  |  | 11 |  |  |  | D | 6 | 8 | 225
A |  |  | 12 |  |  |  | D | 9 |  | 300
A |  |  | 13 |  |  |  | E | 1 | 5 | 900
A |  |  | 14 |  |  |  | E | 6 | 8 | 200
A |  |  | 15 |  |  |  | E | 9 | 12 | 800
A |  |  | 16 |  |  |  | E | 13 |  | 600
A |  |  | 17 |  |  |  | F | 1 | 6 | 500
B |  |  | 0 |  |  |  | F | 7 | 8 | 400
B |  |  | 1 |  |  |  | F | 9 | 11 | 100
B |  |  | 2 |  |  |  | F | 12 | 16 | 700
B |  |  | 3 |  |  |  | F | 17 |  | 300
B |  |  | 4
B |  |  | 5
B |  |  | 6
B |  |  | 7
B |  |  | 8
B |  |  | 9
B |  |  | 10
B |  |  | 11
B |  |  | 12
B |  |  | 13
B |  |  | 14
B |  |  | 15
B |  |  | 16
B |  |  | 17
C |  |  | 0
C |  |  | 1
C |  |  | 2
C |  |  | 3
C |  |  | 4
C |  |  | 5
C |  |  | 6
C |  |  | 7
C |  |  | 8
C |  |  | 9
C |  |  | 10
C |  |  | 11
C |  |  | 12
C |  |  | 13
C |  |  | 14
C |  |  | 15
C |  |  | 16
C |  |  | 17
D |  |  | 0
D |  |  | 1
D |  |  | 2
D |  |  | 3
D |  |  | 4
D |  |  | 5
D |  |  | 6
D |  |  | 7
D |  |  | 8
D |  |  | 9
D |  |  | 10
D |  |  | 11
D |  |  | 12
D |  |  | 13
D |  |  | 14
D |  |  | 15
D |  |  | 16
D |  |  | 17
E |  |  | 0
E |  |  | 1
E |  |  | 2
E |  |  | 3
E |  |  | 4
E |  |  | 5
E |  |  | 6
E |  |  | 7
E |  |  | 8
E |  |  | 9
E |  |  | 10
E |  |  | 11
E |  |  | 12
E |  |  | 13
E |  |  | 14
E |  |  | 15
E |  |  | 16
E |  |  | 17
F |  |  | 0
F |  |  | 1
F |  |  | 2
F |  |  | 3
F |  |  | 4
F |  |  | 5
F |  |  | 6
F |  |  | 7
F |  |  | 8
F |  |  | 9
F |  |  | 10
F |  |  | 11
F |  |  | 12
F |  |  | 13
F |  |  | 14
F |  |  | 15
F |  |  | 16
F |  |  | 17
Spreadsheet: michelle_lokay__26750__imball0112
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -23046 | -20000 |  |  |  |  |  |  |  | San Juan
2 | -75534 | -75068 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
3 | -83709 | -75300 |  |  |  | 2001-02-01 00:00:00 | -537 | -5933 |  | 5.62
4 | -83059 | -80207 |  |  |  | 2001-03-01 00:00:00 | -80533 | -96000 |  | 4.98
5 | -83684 | -85233 |  |  |  | 2001-04-01 00:00:00 | -819833 | -1020974 |  | 4.87
6 | -69154 | -85233 |  |  |  | 2001-05-01 00:00:00 |  | -1252019 |  | 3.82
7 | -66976 | -58000 |  |  |  | 2001-06-01 00:00:00 |  | -1589467 |  | 3.2
8 | -80299 | -76101 |  |  |  | 2001-07-01 00:00:00 | -2051914 | -1898771 |  | 2.77
9 | -90279 | -85236 |  |  |  | 2001-08-01 00:00:00 | -2021619 | -1999977 |  | 2.77
10 | -88269 | -85551
11 | -87855 | -85279
12
13
14 |  |  |  |  |  | 9/1 - 9/25
15
16
17
18
19 |  |  |  |  |  | Accumulated @ 9/25/01
20
21 |  |  |  |  |  | Equilalent volumes at 9/25/01
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 51989
2001-12-11 00:00:00
CBS Volume
 |  |  | 116707
Spreadsheet: 4445fe5f-61c7-494c-9168-08899020cdd9
Sheet: Formative Assessment

Grant: |  | Title 1A School Improvement - Formative Assessment
CFDA # |  | 84.010
GRANT NUMBER: |  | 5010
FISCAL YEAR: |  | 2011-12
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]   [PHONE] or [EMAIL]
Questions regarding grant: |  | [NAME]6905 or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - August 15, 2012
Code | District Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JULY 2011 | AUGUST 2011 | SEPTEMBER 2011 | OCTOBER 2011 | NOVEMBER 2011 | DECEMBER 2011 | JANUARY 2012 | FEBRUARY 2012 | MARCH 2012 | APRIL 2012 | MAY 2012 | JUNE 2012 | JULY 2012 | AUGUST 2012 | SEPTEMBER 2012 | OCTOBER 2012
0030-9 | Adams County 14 | 81117 |  |  |  |  |  |  | 38811 | 2453 | 55 |  | 1163 | 1048 |  |  |  |  | 2607
0070-9 | Adams 50 | 150000 |  |  |  |  |  |  |  |  |  | 150000
0480-9 | Boulder Valley RE-2 | 147993 |  |  |  |  |  |  | 94619 | 788 |  | 205 | 297 | 351 |  | 587 |  | 49064 |  | 177
3080-9 | Weld RE-1 | 15978 |  |  |  |  |  |  |  |  | 14096 |  |  |  |  | 1874
3120-9 | [NAME] | 150000 |  |  |  |  |  |  |  | 91306 | 10474 | 6693 | 6490 | 6123 | 6802 | 6489 | 6472 | 6824
Spreadsheet: 34709d1232026232-filter-one-list-by-another-for-contains-example
Sheet: Sheet1

[EMAIL] |  |  |  | [NAME] |  | All addresses from A that include contain the name in E
[EMAIL] |  |  |  | mitchell
[EMAIL] |  |  |  | [NAME]
[EMAIL] |  |  |  | michelle
[EMAIL] |  |  |  | [NAME]
[EMAIL] |  |  |  | ming
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[NAME]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[NAME]
[NAME]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[NAME]
[EMAIL]
[NAME]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[NAME]
[EMAIL]
[EMAIL]
[NAME]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[NAME]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[NAME]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
Spreadsheet: 840043d1692372948-nested-if-and-offset-and-cell-sample
Sheet: Sheet1

 |  | year | 2001
 |  | no of items | 1
 |  | %age | 0.1
 |  | Total
reduction start year | 2006
No supply from year | 2009
Spreadsheet: b9fbeb14-d37b-4163-bdc0-38bbf5e13854
Sheet: Setup

Filename : | UEFA EURO 2012 [NAME] Players.xlsx
Player # | Player Name |  | RULE |  | POINT SYSTEM
1 |  |  |  |  | GROUP | QUARTER FINAL | SEMI FINAL | FINAL
2 |  |  | o | Point for correct match winner/draw and correct score result >> | 100 | 400 | 800 | 1600
3 |  |  | o | Point for correct match winner/draw and correct score difference result >> | 75 | 300 | 600 | 1200
4 |  |  | o | Point for correct match winner/draw result only >> | 50 | 200 | 400 | 800
5
6 |  |  | LEADERBOARD TIE REGULATION
7 |  |  | If two or more players are sharing the same score, the highest ranking will be determined by counting the highest number of correct prediction
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Spreadsheet: 829394d1684178468-formula-to-sum-based-condition-and-range-of-account-numbers-sample-for-forum-etaf
Sheet: Dashboards

 |  |  | ICF/MR | CLA/Waiver Residential | Community Services | Adoption | Maternity | Mother/ Infant | Pantry | Outpatient | Trinity | Foundation |  | Total
 | EXPENSES
 | Wages
 | Benefits |  |  |  | Benefits
 | Patient Care
 | Plant Operations
 | General & Administrative
 | Equipment Related
 | Interest Expense
 | Depreciation/Amortization
 | Miscellaneous
 | Assessment
 | Total Expenses
 | I am trying to create a formula that sums in each category based on two criteria:
 | The expense category
 | The department
 | The data is sourced from the [NAME] worksheet. Column M (Projection with Adjustments) is the total column that will be referenced for the dashboard.
 | Column H (Cost Center) contains the department, so that is fairly straightforward.
 | Column D (Pay Period) contains a number that falls into a range.
 | The CostCenLookup table in the Data worksheet contains a lookup table for what expense category the pay periods correlate with.
 | So basically, I need a formula that only sums the program and the expense category. For example, if we look at cell D4 in the Dashboards worksheet, it should look at column M in Expenditures and sum only if column H is equal to "ICF/MR" and column D contains numbers that fall into the "Wages" category, as defined by the CostCenLookup table.
 | Hopefully that makes sense. I of course realize this will require a lot of variations of a formula, but I am only looking for one example that I can modify appropriately.
 | Any help with this is much appreciated!
Spreadsheet: 165870d1341374980-search-values-in-data-table-that-are-greater-than-cell-value-premier-quick-help
Sheet: Quick Search

 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Product: |  |  |  |  |  | [NAME]:
Country: |  |  |  |  |  | Vendor:
Region: |  |  |  |  |  | BTG Min: |  |  | Need to have filtered by greater than / equal to in column G
Appellation: |  |  |  |  |  | BTG Max: |  |  | Need to have filtered by less than / equal to in column G
Item ID | Product Name | Size | Pk | Front | Level 3 | BTG | Varietal | Country | Region | Appellation | Vendor | Inv | Order | Date
Spreadsheet: 07d05e02-6e5b-446d-ac16-1f98d621f695
Sheet: SUMMARY

KETCHIKAN GATEWAY BOROUGH
Department of Assessment, 1900 First Avenue, Suite 219, Ketchikan, AK 99901
Phone: [PHONE] Fax: [PHONE] [NAME]: [EMAIL]
The Business Personal Return is also available for electronic filing (Excel) at www.kgbak.us
2015 BUSINESS/PERSONAL PROPERTY RETURN
I HEREBY DECLARE OWNERSHIP OR CONTROL OF THE FOLLOWING TAXABLE BUSINESS PROPERTY
NO CHANGE FROM PREVIOUS YEAR? |  |  | (Enter "No Change" at right, sign & date return)
NO LONGER IN BUSINESS? |  |  | (Complete lines 1,2,&3 below, sign & date return)
1
2
3
ASSETS
 |  | ACQUISITION COST | ACCRUED DEPRECIATION | MARKET VALUE | FOR OFFICE USE ONLY
Pages 3 & 4 | OFFICE EQUIPMENT AND COMPUTERS
Page 5 | FURNITURE, FIXTURES AND LEASEHOLD
Page 6 | MACHINERY AND EQUIPMENT
 | TOTAL (RND $100)
Page 7 | LEASED ASSETS | SEE PAGE 6
Page 7 | SOLD OR DISPOSED ASSETS | SEE PAGE 6
AIRCRAFT & HELICOPTERS
 |  |  |  |  | MARKET VALUE
Page 8 | AIRCRAFT
 | SOLD AIRCRAFT
 | TRANSFER PRICE (AIRCRAFT) |  | BUYERS NAME
 | TRANSFER DATE |  | MAILING ADDRESS
SIGNATURE/TITLE OF PERSON PREPARING RETURN |  |  |  | DATE
Spreadsheet: 0321a413-3be0-4d27-a768-4f6419525ce2
Sheet: Form

 | Division of School Finance |  | S C H O O L   T A X   A B A T E M E N T   R E P O R T C A L E N D A R   Y E A R   2 0 1 2 |  |  |  |  | ED-02009-24
 | 1500 Highway 36 West |  |  |  |  |  |  | DUE: 02/01/2013
 | Roseville, MN  55113-4266
GENERAL INFORMATION AND INSTRUCTIONS: Please read the INSTRUCTIONS FOR COMPLETION on the Instructions tab before completing this report. |  |  |  |  |  |  | THIS REPORT APPLIES TO: January 1, 2012 - December 31, 2012
NOTES OR COMMENTS BY PREPARER:
I D E N T I F I C A T I O N   A N D   G E N E R A L   I N F O R M A T I O N
District Number and Name |  | County Name | County Auditor's Office Contact Person |  | Telephone Number |  | Date
P A R T   A :     N E T   T A X   C A P A C I T Y
 |  | (1) | (2) | (3) | (4) | (5) | (6) | (7)
COUNTY NAME | COUNTY NUMBER | NET TAX CAPACITY ABATED | SCHOOL TAXES ABATED | NET TAX CAPACITY ADDED | SCHOOL TAXES ADDED | NET CHANGE IN NET TAX CAPACITY | NET CHANGES IN SCHOOL TAXES | TOTAL INTEREST PAYMENTS
 |  | (Dollars Only) | (Dollars & Cents) | (Dollars Only) | (Dollars & Cents) | (Columns 1 + 3) | (Columns 2 + 4) | (Dollars & Cents)
 |  | Enter Negative Amount | Enter Negative Amount
P A R T   B :     R E F E R E N D U M   M A R K E T   V A L U E
 |  | (1) | (2) | (3) | (4) | (5) | (6) | (7)
COUNTY NAME | COUNTY NUMBER | REF MKT VALUE ABATED | SCHOOL TAXES ABATED | REF MKT VALUE ADDED | SCHOOL TAXES ADDED | NET CHANGE IN REF MKT VALUE | NET CHANGES IN SCHOOL TAXES | TOTAL INTEREST PAYMENTS
 |  | (Dollars Only) | (Dollars & Cents) | (Dollars Only) | (Dollars & Cents) | (Columns 1 + 3) | (Columns 2 + 4) | (Dollars & Cents)
 |  | Enter Negative Amount | Enter Negative Amount
TOTAL ALL COUNTIES (Part A and B)
Spreadsheet: 162543d1339959184-balance-cash-in-register-osa-00-answer
Sheet: Sheet1

 |  |  |  |  | Treasury inventory model in the restaurant
 |  |  |  |  |  | Category of cash | Money | G  * H
 |  |  |  |  |  | 50 | 12 |  | <<600
 |  |  |  |  |  | 20 | 15 |  | <<300
 |  |  |  |  |  | 10 | 33 |  | <<330
 |  |  |  |  |  | 5 | 84 |  | <<420
 |  |  |  |  |  | 1 | 17 |  | <<17
 |  |  |  |  |  |  |  |  |  |  |  |  | <<Sum of money from the cell to the i 9 i 13
 |  |  |  |  |  |  |  |  |  |  |  |  | <<<<Amount to be reached
 |  |  |  |  |  |  |  |  |  |  |  |  | <<<Amount of the increase and decrease in the number of coins
Spreadsheet: mark_haedicke__24600__105655 - O&M 053101
Sheet: Headcount - 105659

 | ENRON NORTH AMERICA
 | CC 105659
 | HEADCOUNT AS OF 05-31-01
EMPLOYEE |  |  | TOTAL
BENNICK,KIMBERLEE A |  | hOther Non-Commercial | 1
BRABAND, SANDI M. |  | hOther Non-Commercial | 1
[NAME], KATHLEEN |  | hOther Non-Commercial | 1
DICKSON,STACY E |  | hOther Non-Commercial | 1
FARRELL, KEEGAN |  | hOther Non-Commercial | 1
FERGUSON, SAMANTHA M |  | jTemp/Contractor | 1
FLYNN,SHAWNA |  | hOther Non-Commercial | 1
GRAY,BARBARA N |  | aExecutive | 1
HODGE,JEFFREY T |  | hOther Non-Commercial | 1
HYVL,DANIEL J |  | hOther Non-Commercial | 1
MEADOWS, RAE |  | hOther Non-Commercial | 1
NACHAWATI, NABIL | ** | Summer intern | 1
NEMEC,[NAME] R |  | hOther Non-Commercial | 1
OGDEN,[NAME] |  | hOther Non-Commercial | 1
PERLINGIERE,[NAME] A |  | hOther Non-Commercial | 1
RADFORD,PATRICIA A |  | kAdmin Assistant | 1
SOLE, CARLOS |  | hOther Non-Commercial | 1
VAN HOOSER,[NAME] |  | hOther Non-Commercial | 1
WALKER,[NAME] |  | hOther Non-Commercial | 1
WHITE,[NAME] |  | hOther Non-Commercial | 1