tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 676936d1589087908-pull-contact-info-from-multiple-rows-and-deliver-across-multiple-columns-based-on-company-excelforumexamplev2
Sheet: #2

First Name | Last Name | [NAME] | Company Name
[NAME] | Smith | [EMAIL] | 1 Plus 2 Architecture
Fred | Ward | [EMAIL] | 1 Plus 2 Architecture
Georgina | [NAME] | [EMAIL] | 10 Design
[NAME] |  | [EMAIL] | 11 Dimensions Pty Ltd
[NAME] |  | [EMAIL] | 11 Dimensions Pty Ltd
Sue | Borleis | [NAME] | 16 bays design
Spreadsheet: 672525d1586896801-function-to-pull-entire-row-based-on-criteria-example-month
Sheet: Example

 |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00
[NAME] | [NAME]
[NAME] | Project A | [NAME] | 5
[NAME] | Project B | [NAME] |  | 20
[NAME] | Project C | [NAME] |  |  | 80
A012345 | [NAME]
A012345 | Project A | [NAME] | 55
A012345 | Project B | [NAME] | 93 | 2090
A012345 | Project C | [NAME]
[NAME] | [NAME]
A009876 | Project C | [NAME] |  |  | 87
A009876 | Project C | [NAME] |  |  | 87
A009876 | Project C | [NAME] |  |  | 87
Spreadsheet: 874099d1720666901-reshaping-data-reshaping-data-in-excel-1-
Sheet: Input

Name of the training | The training was interesting and engaging | The training content was clear to understand | The training was relevant to your work/job role | The instructor(s) demonstrated command over the subject | Queries were responded in a timely manner | I felt part of a learning community | I am likely to apply this new knowledge to my current/future work. | I am likely to recommend this course to a colleague.
XYZ | Agree | Agree | Agree | Strongly agree | Strongly agree | Strongly agree | Agree | Agree
XYZ | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree
XYZ | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree
XYZ | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree
XYZ | Agree | Agree | Agree | Agree | Strongly agree | Strongly agree | Strongly agree | Agree
XYZ | Agree | Strongly agree | Agree | Strongly agree | Agree | Agree | Strongly agree | Agree
XYZ | Agree | Strongly agree | Agree | Strongly agree | Agree | Agree | Strongly agree | Agree
XYZ | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree
XYZ | Strongly agree | Strongly agree | Agree | Agree | Agree | Strongly agree | Strongly agree | Agree
XYZ | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree
XYZ | Agree | Agree | Strongly agree | Agree | Agree | Agree | Agree | Agree
XYZ | Strongly agree | Agree | Strongly agree | Agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree
XYZ | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree
XYZ | Neither agree nor disagree | Agree | Agree | Agree | Agree | Neither agree nor disagree | Agree | Agree
XYZ | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree
XYZ | Strongly agree | Strongly agree | Strongly agree | Agree | Strongly agree | Agree | Strongly agree | Strongly agree
XYZ | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree
XYZ | Strongly agree | Strongly agree | Strongly agree | Agree | Strongly agree | Strongly agree | Strongly agree | Strongly agree
XYZ | Agree | Agree | Strongly agree | Agree | Agree | Agree | Agree | Agree
XYZ | Agree | Agree | Agree | Agree | Agree | Agree | Agree | Agree
XYZ | Strongly disagree | Strongly disagree | Strongly disagree | Strongly disagree | Agree | Strongly agree | Strongly agree | Strongly agree
XYZ | Strongly agree | Strongly agree | Agree | Strongly agree | Agree | Agree | Strongly agree | Strongly agree
XYZ | Strongly agree | Strongly agree | Strongly agree | Agree | Strongly agree | Strongly agree | Strongly agree | Agree
Spreadsheet: chris_dorland__1627__FUZZY_SWAP
Sheet: $CND OPTIONS

 |  | Strike Price | 2.5 | Start Date | 2000-02-01 00:00:00
 |  |  |  | End Date | 2000-02-01 00:00:00
 |  | Volatility | 0.265
 |  | Today's Date |  | Volume | 5000
 |  | CALL |  | PUT
 |  | Revenue |  | Revenue
 |  |  | STRADDLE
 |  |  | Revenue
0 |  | DATE | DAYS/ MONTH | STRIKE PRICE | UNDERLYING  GAS PRICE | (r) | DF | TIME  (t) | ANNUAL VOL.(V) | h | h-(v(t)^(1/2)) | (v(t)^1/2)-h | N(h) | N(-h) | N(h-(v(t)^(1/2)) | N((v(t)^1/2)-h) | C | P | VOLUME | CALL REVENUE | PUT REVENUE | TOTAL VOLUME | DAYS | Call Delta | Put Delta | Call/Put Gamma | Call Theta | Put Theta | Call/Put Vega | Call Rho | Put Rho
 |  | 2000-02-01 00:00:00 |  |  | 2.7
 |  | 2000-03-01 00:00:00 |  |  | 2.725
 |  | 2000-04-01 00:00:00 |  |  | 2.73
 |  | 2000-05-01 00:00:00 |  |  | 2.74
 |  | 2000-06-01 00:00:00 |  |  | 2.76
 |  | 2000-07-01 00:00:00 |  |  | 2.78
 |  | 2000-08-01 00:00:00 |  |  | 2.81
 |  | 2000-09-01 00:00:00 |  |  | 2.83
 |  | 2000-10-01 00:00:00 |  |  | 2.89
 |  | 2000-11-01 00:00:00 |  |  | 3.032794661347194
 |  | 2000-12-01 00:00:00 |  |  | 3.209548733526568
 |  | 2001-01-01 00:00:00 |  |  | 3.254599607203379
 |  | 2001-02-01 00:00:00 |  |  | 3.101069478148668
 |  | 2001-03-01 00:00:00 |  |  | 2.954720692396941
 |  | 2001-04-01 00:00:00 |  |  | 2.79462579723933
 |  | 2001-05-01 00:00:00 |  |  | 2.760442878065909
 |  | 2001-06-01 00:00:00 |  |  | 2.778205644883618
 |  | 2001-07-01 00:00:00 |  |  | 2.793341886561756
 |  | 2001-08-01 00:00:00 |  |  | 2.809924278772679
 |  | 2001-09-01 00:00:00 |  |  | 2.822444953043836
 |  | 2001-10-01 00:00:00 |  |  | 2.862392037588574
 |  | 2001-11-01 00:00:00 |  |  | 3.042937872333538
 |  | 2001-12-01 00:00:00 |  |  | 3.212568418029543
 |  | 2002-01-01 00:00:00 |  |  | 3.248604141432681
 |  | 2002-02-01 00:00:00 |  |  | 3.103997744308898
 |  | 2002-03-01 00:00:00 |  |  | 2.959356826279589
 |  | 2002-04-01 00:00:00 |  |  | 2.813458295238945
 |  | 2002-05-01 00:00:00 |  |  | 2.783586924459917
 |  | 2002-06-01 00:00:00 |  |  | 2.7917830848283
 |  | 2002-07-01 00:00:00 |  |  | 2.79871959799452
 |  | 2002-08-01 00:00:00 |  |  | 2.808436795049851
 |  | 2002-09-01 00:00:00 |  |  | 2.811372818734086
 |  | 2002-10-01 00:00:00 |  |  | 2.855141647930209
 |  | 2002-11-01 00:00:00 |  |  | 3.046876600725663
 |  | 2002-12-01 00:00:00 |  |  | 3.212765384396113
 |  | 2003-01-01 00:00:00 |  |  | 3.252403093250132
 |  | 2003-02-01 00:00:00 |  |  | 3.139050903746784
 |  | 2003-03-01 00:00:00 |  |  | 2.995287016108036
 |  | 2003-04-01 00:00:00 |  |  | 2.762207104758045
 |  | 2003-05-01 00:00:00 |  |  | 2.732565936936132
 |  | 2003-06-01 00:00:00 |  |  | 2.740803219975988
 |  | 2003-07-01 00:00:00 |  |  | 2.747750245748909
 |  | 2003-08-01 00:00:00 |  |  | 2.757399760448643
 |  | 2003-09-01 00:00:00 |  |  | 2.760291121988637
 |  | 2003-10-01 00:00:00 |  |  | 2.803773779085064
 |  | 2003-11-01 00:00:00 |  |  | 3.028170034954003
Spreadsheet: 40c8ad4f-32b0-4d39-9e52-467370c95fad
Sheet: Gems

Color | Best gem | AEP | Socket value
Red
Yellow
Blue
Any
Gem | STR | AGI | STA | AP | Hit | Crit | AEP | R-AEP | Y-AEP | B-AEP | Gem(again)
Bold Living Ruby | 8
Delicate Living Ruby |  | 8
Bright Living Ruby |  |  |  | 16
Smooth Dawnstone |  |  |  |  |  | 8
Rigid Dawnstone |  |  |  |  | 8
[NAME] of Elune |  |  | 12
Glinting Noble Topaz |  | 4 |  |  | 4
Inscribed Noble Topaz | 4 |  |  |  |  | 4
Wicked Noble Topaz |  |  |  | 8 |  | 4
Shifting Nightseye |  | 4 | 6
[NAME] | 4 |  | 6
[NAME] |  |  | 6 | 8
Jagged Talasite |  |  | 6 |  |  | 4
GEM SELECTION | Socket 1 | Socket 2 | Socket 3 | Bonus |  | Total AEP
Color | Yellow | Yellow |  | 6 | STA
Best matching
Best nomatch |  |  |  | 0
Best overall
Spreadsheet: 74556d1275046914-autopopulate-text-autopopulate-1-
Sheet: Sheet1

Product |  |  | Autopopulate |  | LIST
AUDCAD | 1
CHFUSD | 0
JPYUSD | -1
GBPCAD | 1
EUROGBP | 0
[NAME] | -1
Spreadsheet: 874973d1721497915-lotto-number-checker-wont-work-lottery-checker-by-henry
Sheet: Lottery Checker

Draw # | #1 | #2 | #3 | #4 | #5 | #6 | # [NAME] |  | Check number | #1 | #2 | #3 | #4 | #5 | #6 |  | # | [NAME]
1 | 3 | 19 | 20 | 29 | 66 | 16 |  |  |  | 10 | 17 | 23 | 50 | 67 | 3 |  | 1
2 | 5 | 14 | 20 | 22 | 26 | 11 |  |  |  |  |  |  |  |  |  |  | 2
3 | 22 | 29 | 51 | 52 | 58 | 16 |  |  | Match? | 1 | 2 | 3 | 4 | 5 | 6 |  | 3
4 | 19 | 26 | 41 | 52 | 58 | 12 |  |  |  |  |  |  |  |  |  |  | 4
5 | 22 | 26 | 29 | 38 | 51 | 16 |  |  |  |  |  |  |  |  |  |  | 5
6 | 3 | 38 | 51 | 52 | 66 | 11 |  |  |  |  |  |  |  |  |  |  | 6
7 | 5 | 9 | 20 | 22 | 66 | 11 |  |  |  |  |  |  |  |  |  |  | 7
8 | 19 | 22 | 29 | 51 | 58 | 11 |  |  |  |  |  |  |  |  |  |  | 8
9 | 3 | 5 | 9 | 26 | 41 | 21 |  |  |  |  |  |  |  |  |  |  | 9
10 | 3 | 22 | 41 | 51 | 66 | 12 |  |  |  |  |  |  |  |  |  |  | 10
11 | 4 | 24 | 45 | 61 | 70 | 0 |  |  |  |  |  |  |  |  |  |  | 11
12 | 23 | 36 | 46 | 69 | 70 | 0 |  |  |  |  |  |  |  |  |  |  | 12
13 | 1 | 17 | 54 | 69 | 70 | 0 |  |  |  |  |  |  |  |  |  |  | 13
14 | 14 | 18 | 48 | 65 | 66 | 0 |  |  |  |  |  |  |  |  |  |  | 14
15 | 7 | 25 | 29 | 43 | 62 | 0 |  |  |  |  |  |  |  |  |  |  | 15
16 | 11 | 17 | 53 | 58 | 67 | 0 |  |  |  |  |  |  |  |  |  |  | 16
17 | 6 | 31 | 39 | 41 | 68 | 0 |  |  |  |  |  |  |  |  |  |  | 17
18 | 1 | 27 | 36 | 41 | 68 | 0 |  |  |  |  |  |  |  |  |  |  | 18
19 | 28 | 29 | 31 | 58 | 70 | 0 |  |  |  |  |  |  |  |  |  |  | 19
20 | 21 | 33 | 53 | 59 | 69 | 0 |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42
Spreadsheet: 855373d1704966682-if-with-averageifs-returning-value-sample-data
Sheet: Sheet1

Month | Project Name | Cash Out Periodic | Forecast Cash Out 3 months rolling | Forecast Cash Out - 3 months rolling YTD
January | Ninja | 4990
February | Ninja | 576
March | Ninja | 0
April | Ninja | 18445
May | Ninja | 20783
June | Ninja | 53402
July | Ninja | 3127
August | Ninja | 8919
September | Ninja | 53512
October | Ninja | 78109
November | Ninja | 70641
December | Ninja
Spreadsheet: 4445fe5f-61c7-494c-9168-08899020cdd9
Sheet: HOMELESS

Grant: |  | McKinney-Vento Homeless |  |  |  |  |  |  | McKinney-Vento Homeless
CFDA # |  | 84.196 |  |  |  |  |  |  | FY 2011-12
GRANT NUMBER: |  | 5196
FISCAL YEAR: |  | July 1, 2011 - June 30, 2012
[NAME]: |  | Limited to 15%
Question regarding payments: |  | [NAME]  [PHONE] or [EMAIL]
Questions regarding grant: |  | Marti Rodriguez [PHONE] or [EMAIL]
LAST DAY TO SUBMIT REQUEST FOR THIS GRANT  - November 15, 2012
IMPORTANT NOTE:  Funds approved for carryover are included in the Allocation Amount-please refer to comments.
Code | District/Agency 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 | NOVEMBER 2012 | DECEMBER 2012 | JANUARY 2013 | Transfer to FY12-13 | [NAME] to CDE
0020 | Adams 12 | 50750 |  |  |  |  |  |  |  |  |  |  | 12135 | 2642 | 5010 | 2086 |  |  | 565 |  |  |  |  | 20271
0030 | Adams 14 | 43500 |  |  |  |  |  |  |  | 5780 | 29441 | -20635 | 2945 | 2457 | 3380 | 6456 |  |  | 5274 | 6237 |  |  |  | 2165
0070 | Adams 50 | 38513 |  |  |  |  |  |  |  | 3301 | 4702 | 3651 | 3541 | 3465 | 3332 | 3540 | 3230 |  | 3156 |  |  |  |  | 6595
0123 | [NAME] | 19500 |  |  |  |  |  |  |  |  | 5888 |  |  |  |  |  |  |  | 13612 |  |  |  |  | 0
0180 | APS | 42704 |  |  |  |  |  |  | 10639 | 2534 | 2820 | 2633 | 3403 | 3160 | 3250 | 2922 | 5845 | 3854 | 696 |  |  |  |  | 948
0470 | St Vrain | 36000 |  |  |  |  |  |  |  |  |  | 7893 | 7544 |  | 3382 | 8813 |  |  | 7316 |  |  |  |  | 1052
0480 | BVSD |  |  |  |  |  |  |  | 5392 |  | 10459 | 6120 | 94 | 7285 | 4317 | 4621 | 9129 |  |  | 322 |  |  |  | 0
0880 | DPS | 44000 |  |  |  |  |  |  |  |  | 26364 | 10572 |  |  |  | 7064 |  |  |  |  |  |  |  | 0
1000 | Fountain | 24500 |  |  |  |  |  |  | 4048 | 2024 | 2026 | 2038 | 2038 | 2039 | 2038 | 4076 | 4173 |  |  |  |  |  |  | 0
1420 | Jeffco |  |  |  |  |  |  |  |  | 15364 | 1078 | 6459 | 4587 | 3456 | 3978 |  |  |  |  |  |  |  | 1469 | 3005
1550 | Poudre |  |  |  |  |  |  |  |  |  |  | 13901 | 2813 |  | 6436 |  | 3661 |  |  | 10959 |  |  |  | 7612 | 5368
2000 | Mesa 51 |  |  |  |  |  |  |  | 2524 | 3888 | 5329 | 4146 | 9849 | 6148 | 1144 | 1158 | 4017
2690 | Pueblo 60 |  |  |  |  |  |  |  |  |  | 5257 | 23019 |  |  |  |  | 22474
2790 | Mt. Valley | 9800 |  |  |  |  |  |  |  |  | 5000 |  |  |  | 4800
3120 | [NAME] 6 |  |  |  |  |  |  |  |  | 10664 |  | 4971 | 2410 | 384 | 5150 | 1874 | 2424 | 131 | 737 |  |  |  |  | 2380
9035 | CBOCES | 44500 |  |  |  |  |  |  | 17800 | 3800 | 4000 | 2500 | 5800 | 3200 | 3100 | 2900 | 450 | 950
9055 | SLVBOCES | 43000 |  |  |  |  |  |  | 8313 |  | 9576 |  | 12288 |  | 3696 | 9127 |  |  | -8336 | 7351 |  |  |  | 985
Spreadsheet: 134801d1325635137-help-with-if-statement-mockup1
Sheet: 1

ID | Name | Class | ID | Name | Date | Gross Period BNAV | Beginning Net Capital Change | [NAME] BNAV
Smith_P | [NAME] | A_A2 | Smith_P | [NAME] | 2011-01-31 00:00:00 | 54541 | 0 | 54541
Jones_A | [NAME] | A_B | Jones_A | [NAME] | 2011-01-31 00:00:00 | 56163 | 0 | 56163
Andrews_W | [NAME] | A_B | Andrews_W | [NAME] | 2011-01-31 00:00:00 | 12 | 0 | 12
Smith_P | [NAME] | A_SP2 | Smith_P | [NAME] | 2011-01-31 00:00:00 | 6546 |  | 6546
Jones_A | [NAME] | A_SP2
Andrews_W | [NAME] | A_SP5 | Andrews_W | [NAME] | 2011-01-31 00:00:00 | 21161 | 0 | 21161
Smith_P | [NAME] | A_SP6 | Smith_P | [NAME] | 2011-01-31 00:00:00 | 56165 | 0 | 56165
Jones_A | [NAME] | A_SP7 | Jones_A | [NAME] | 2011-01-31 00:00:00 | 2132 | 0 | 2132
Andrews_W | [NAME] | A_SP7 | Andrews_W | [NAME] | 2011-01-31 00:00:00 | 1651 | 0 | 1651
Blue will remain constant from sheet to sheet
Spreadsheet: 887152d1737363974-is-this-a-job-for-a-take-sort-formula-emanresu96-formula-tms
Sheet: Sheet1

20 |  | A | 30 |  |  |  |  |  |  | TMS |  | TMS |  |  | [NAME] |  |  |  | [NAME] (Modified)
 |  | B | 10
 |  | C | 68 |  |  |  |  |  |  | 18 |  |  |  |  | 22 | 22 | 21 |  | 21
 |  | D | 46 |  |  |  |  |  |  | 20 |  |  |  |  | 21 | 21 | 20 |  | 20
 |  | E | 41 |  |  |  |  |  |  | 21 |  |  |  |  | 20 | 20 | 20 |  | 18
 |  | F | 40 |  |  |  |  |  |  | 22 |  |  |  |  | 20 | 20 | 18 |  | 17
 |  | G | 51 |  |  |  |  |  |  |  |  |  |  |  | 18 | 18
 |  | H | 76 |  |  |  |  |  |  |  |  |  |  |  | 17 | 17
 |  | I | 29
 |  | J | 95
 |  | K | 86
 |  | L | 69
 |  | M | 38
 |  | N | 15
 |  | O | 100
 |  | P | 75
 |  | Q | 22
 |  | R | 52
 |  | S | 40
 |  | T | 96
 |  | U | 49
 |  | V | 41
 |  | W | 2
 |  | X | 78
 |  | Y | 63
 |  | Z | 78
 |  | [ | 57
 |  | \ | 70
 |  | ] | 46
 |  | ^ | 54
 |  | _ | 94
 |  | ` | 49
 |  | a | 90
 |  | b | 47
 |  | c | 39
 |  | d | 91
 |  | e | 97
 |  | f | 72
 |  | g | 93
 |  | h | 4
 |  | i | 31
 |  | j | 66
 |  | k | 82
 |  | l | 13
 |  | m | 58
 |  | n | 14
 |  | o | 77
 |  | p | 22
 |  | q | 70
 |  | r | 17
 |  | s | 56
 |  | t | 73
 |  | u | 12
 |  | v | 20
 |  | w | 70
 |  | x | 83
 |  | y | 50
 |  | z | 74
 |  | { | 25
 |  |  | 62
 |  | } | 49
 |  | ~ | 44
 |  |  | 14
 |  | Ä | 32
 |  | Å | 49
 |  | Ç | 81
 |  | É | 45
 |  | Ñ | 18
 |  | Ö | 23
 |  | Ü | 88
 |  | á | 14
 |  | à | 90
 |  | â | 75
 |  | ä | 79
 |  | ã | 48
 |  | å | 1
 |  | ç | 69
 |  | é | 30
 |  | è | 8
 |  | ê | 92
 |  | ë | 63
 |  | í | 61
 |  | ì | 6
 |  | î | 86
 |  | ï | 21
 |  | ñ | 9
 |  | ó | 78
 |  | ò | 41
 |  | ô | 7
 |  | ö | 13
 |  | õ | 88
 |  | ú | 94
 |  | ù | 11
 |  | û | 3
 |  | ü | 29
 |  | † | 94
 |  | ° | 84
 |  | ¢ | 84
 |  | £ | 39
 |  | § | 71
Spreadsheet: 105252d1302682378-array-or-pivot-make-a-sum-if-the-value-of-one-cell-falls-within-a-date-range-sumifvaluewithindate
Sheet: Sheet2

 |  | Project Name | Size | First Step Complete Date | Second Step Complete Date | Third Step Complete Date |  | Before 2013? 1 = Y | Size At End 2012
 |  | Project 1 | 5 | 2011-03-29 08:00:00 | 2011-07-18 17:00:00 |  |  | 1
 |  | Project 2 | 6 | 2011-04-05 17:00:00 | 2011-07-26 17:00:00 |  |  | 1
 |  | Project 3 | 7 | 2011-04-06 17:00:00 | 2011-07-27 17:00:00 |  |  | 1
 |  | Project 4 | 8 | 2011-04-25 17:00:00 | 2011-11-03 17:00:00 | 2012-02-23 17:00:00 |  | 1
 |  | Project 5 | 9 | 2011-04-25 17:00:00 | 2011-12-14 17:00:00 | 2012-03-27 17:00:00 |  | 1
 |  | Project 6 | 10 | 2011-05-02 17:00:00 | 2011-12-21 17:00:00 | 2012-04-03 17:00:00 |  | 1
 |  | Project 7 | 1 | 2011-05-02 17:00:00 | 2011-12-21 17:00:00 | 2012-04-03 17:00:00 |  | 1
 |  | Project 8 | 2 | 2011-05-16 17:00:00 | 2011-12-21 17:00:00 | 2012-04-11 17:00:00 |  | 1
 |  | Project 9 | 3 | 2011-06-13 17:00:00 | 2013-02-01 17:00:00 | 2014-04-01 00:00:00
 |  | Project 10 | 4 | 2011-06-28 17:00:00 | 2012-02-16 17:00:00 | 2012-05-30 17:00:00 |  | 1
 |  | Project 11 | 5 | 2011-06-28 17:00:00 | 2012-02-16 17:00:00 | 2012-05-30 17:00:00 |  | 1
 |  | Project 12 | 6 | 2011-06-28 17:00:00 | 2012-02-16 17:00:00 | 2012-05-30 17:00:00 |  | 1
 |  | Project 13 | 7 | 2011-07-04 17:00:00 | 2012-02-22 17:00:00 | 2013-06-05 17:00:00
 |  | Project 14 | 8 | 2011-07-12 17:00:00 | 2012-03-01 17:00:00 | 2013-06-13 17:00:00
 |  | Project 15 | 11 | 2011-07-12 17:00:00 | 2012-03-01 17:00:00 | 2013-06-13 17:00:00
 |  | Project 16 | 12 | 2011-07-12 17:00:00 | 2012-03-01 17:00:00 | 2013-06-13 17:00:00
 |  | Project 17 | 13 | 2011-08-29 17:00:00 | 2011-12-19 17:00:00
 |  | Project 18 | 14 | 2011-08-29 17:00:00 | 2011-12-19 17:00:00
 |  | Project 19 | 15 | 2011-08-29 17:00:00 | 2012-04-18 17:00:00 | 2013-07-31 17:00:00
 |  | Project 20 | 15 | 2011-09-12 17:00:00 | 2012-05-02 17:00:00 | 2013-08-14 17:00:00
 |  | Q1 2011 | Q2 2011 | Q3 2011 | Q4 2012 |  |  |  | this array formula doesn't work
 |  | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 |  |  |  | it also needs to be date dependent
 |  | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 |  |  |  | i.e. add to the sum if step 3 before 2013
 |  | Q1 2012 | Q2 2012 | Q3 2012 | Q4 2013
 |  | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2012-07-01 00:00:00
 |  | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2012-09-30 00:00:00
Spreadsheet: gerald_nemec__11309__Nom Summary - June 2001 Final
Sheet: Sheet1

Nomination Summary - Powder River
2001-06-01 00:00:00
 | Mcf |  |  |  | Mmbtu | MMBtu |  | Purchase Summary |  | Total Purchases
 | Wellhead | Add'l Prod. |  |  | Wellhead | Less fuel
 | Nomination | Mcf | IT | Btu Factor | Confirmation | to Glennrock | NGPL | CIG | CIG GD |  | note:
[NAME]/So. Kitty/Maverick
[NAME] | 5865 |  |  | 0.9579423868
Kennedy South Kitty | 16135 |  |  | 0.94940763492
Wellstar | 1950 |  |  | 0.93905266644 |  |  |  | 0 | 0
Box Draw/Maverick Total
Bear Paw
Citation | 0 |  |  |  | 0 | 0 |  | 0 | 0
[NAME] |  |  |  |  | 0
Clydesdale
Phillips | 12500 | 5078 |  | 0.946
Phillips (Non Dedicated)
Clydesdale Total
Caballo
MTG | 140 | 0 |  | 0.957
[NAME] | 0 | 0 |  | 0.94
Phillips | 0 | 0 |  | 0.938
Quantum | 1000 |  |  | 0.971 |  |  | 0
Independent | 15104 | (18000) |  | 0.939 |  |  | 10000 |  |  |  | settle on actual production NOT nomination
Caballo Total
TOTAL ENA
 |  |  |  |  |  |  |  |  |  | 49053 | Firm Transport
 |  |  |  |  |  |  |  |  |  |  | Position
 |  | [NAME]. | [NAME].
ADDITIONAL PURCHASES: |  | at Wellhead | at Glenrock
Kennedy - CIG Gas Daily -.1738 #816489 | 1153 |  |  | 0.957 |  |  |  | 980
Kennedy - CIG Index -.34 #812680 | 5143 |  |  | 0.957 |  |  |  | 4369
Kennedy - CIG Gas Daily -.34 #812687 | 6645 |  |  | 0.949 |  |  |  |  | 5735
Citation -CIG Gas Daily -.50 #816247 | 750 |  |  | 0.966 |  |  |  |  | 652
[NAME] #818868 | 660 |  |  | 0.94 |  |  |  |  | 557
Quantum -CIG Gas Daily -.50 #816515 | 514 |  |  | 0.971 |  |  |  |  | 448
[NAME] -.70 #749888 | 882 |  |  | 0.94 |  |  |  | 739
 |  |  |  |  |  |  |  |  |  | MARKETS:
 |  |  |  |  |  |  |  |  |  | 49053 | Firm Transport
 |  |  |  |  |  |  |  |  |  | 980 | [NAME]
 |  |  |  |  |  |  |  |  |  | 5000 | CMS
 |  |  |  |  |  |  |  |  |  | 5000 | Retex
 |  |  |  |  |  |  |  |  |  |  | Position
Spreadsheet: 1364d387-3504-4681-a05e-076ee2ab9424
Sheet: Step 4 - Non-Salary

 |  | - Enter in White Cells - |  |  | Step 4 - Non-Salary Expenses
 |  |  |  |  | Identify the necessary non-salary expenses for years 0-5
 |  |  |  |  | Don't forget about costs that may be required based on the funding
 |  |  |  |  | source ([NAME] textbooks, ECE supplies, etc.) Review the uses of
 |  |  |  |  | funding in Step 2, or the Budget Guidance Manual for more information.
 |  |  |  | 3% Growth | 3% Growth | 3% Growth | 1% Growth | 1% Growth
[NAME] |  |  | YEAR 0 | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5
GENERAL SUPPLIES |  |  |  | 50000 | 40000 | 21218 | 21430.18 | 21644.4818
LIBRARYGENERAL SUPPLIES |  |  | 0 | 2000 | 2060 | 2121.8 | 2143.018 | 2164.44818
COPYING |  |  | 0 | 14000 | 14420 | 14852.6 | 15001.126 | 15151.13726
TRANSPORTATION/FIELD TRIPS |  |  | 0 | 5000 | 5150 | 5304.5 | 5357.545 | 5411.12045
NON-CAPITAL EQUIPMENT |  |  | 0 | 20000 | 20600 | 21218 | 21430.18 | 21644.4818
BOOKS AND PERIODICALS |  |  | 0 | 63847 | 59853 | 27583.4 | 27859.234 | 28137.82634
OTHER PROFESSIONAL |  |  | 0 | 35000 | 35000 | 36050 | 25235 | 25487.35
REPAIRS AND [NAME] |  |  | 0 | 5000 | 5150 | 5304.5 | 5357.545 | 5411.12045
TRAVEL AND REGISTRATION |  |  | 0 | 1500 | 1545 | 1591.35 | 1607.2635 | 1623.336135
DUES AND FEES |  |  | 0 |  | 0 | 0 | 0 | 0
ENROLLMENT HOLDING |  |  | 0 |  | 0 | 0 | 0 | 0
STAFF DEVELOPMENT/Staff year zero |  |  | $ | 25000 | 25000 | 7956.75 | 8036.3175 | 8116.680675000001
MILEAGE |  |  | 0 |  | 0 | 0 | 0 | 0
GUEST TEACHERS (SUBSTITUTES) |  |  | 0 | 19000 | 19570 | 20157.1 | 20358.671 | 20562.25771
OVERTIME |  |  | 0 |  | 0 | 0 | 0 | 0
EXTRA PAY |  |  | 0 | 150000 | 150000 | 106090 | 107150.9 | 108222.409
STAFF DEVELOPMENT |  |  | 0 |  | 0 | 0 | 0 | 0
PARENT INVLOVEMENT |  |  | 0 | 15000 | 15450 | 15913.5 | 16072.635 | 16233.36135
NON-SALARY ACCOUNTS TOTAL
OTHER TOTAL
CAPITAL COSTS
NON-SALARY BUDGET TOTAL