tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 761212d1640723251-need-formula-to-output-multiple-data-in-one-cell-from-workbook-copy-of-2022-reston-team-vacation-calendar
Sheet: April

 |  | 2022-03-28 00:00:00 | 2022-03-29 00:00:00 | 2022-03-30 00:00:00 | 2022-03-31 00:00:00 | 2022-04-01 00:00:00 | 2022-04-02 00:00:00
 |  | 2022-04-04 00:00:00 | 2022-04-05 00:00:00 | 2022-04-06 00:00:00 | 2022-04-07 00:00:00 | 2022-04-08 00:00:00 | 2022-04-09 00:00:00
 |  | 2022-04-11 00:00:00 | 2022-04-12 00:00:00 | 2022-04-13 00:00:00 | 2022-04-14 00:00:00 | 2022-04-15 00:00:00 | 2022-04-16 00:00:00
 |  | 2022-04-18 00:00:00 | 2022-04-19 00:00:00 | 2022-04-20 00:00:00 | 2022-04-21 00:00:00 | 2022-04-22 00:00:00 | 2022-04-23 00:00:00
 |  | 2022-04-25 00:00:00 | 2022-04-26 00:00:00 | 2022-04-27 00:00:00 | 2022-04-28 00:00:00 | 2022-04-29 00:00:00 | 2022-04-30 00:00:00
 |  | 2022-05-02 00:00:00 | Notes
Spreadsheet: 189123d1351091891-help-formula-to-show-a-value-depending-on-the-value-of-two-other-lists-example
Sheet: Sheet1

Name | Today
[NAME] | Online
[NAME] | Online
[NAME] | Quotes
Anna | Online
Michelle | Noteam
[NAME] | Online
[NAME] | Online
[NAME] | Online
[NAME] | Online
Overview
Online | 7
Quotes
Noteam
Spreadsheet: 176028d1345711170-use-data-from-combobox-movie_details_combo
Sheet: Sheet2

 |  | Name | Stars rating | Stars | Satisfaction
 |  | Titanic | 1 | All | YES
 |  | Home Alone | 2 | [NAME] | NO
 |  | The Expendables 2 | 3 | [NAME]
 |  | Total Recall | 4 | [NAME]
 |  | The Bourne Legacy | 5 | [NAME]
 |  | Create a range | Create a range | Create a range | Create a range
 |  | called | called | called | called
 |  | [NAME] | Stars | Stars Names | Happy
 | Choosen: | The Expendables 2 | 1 | [NAME] | YES
Spreadsheet: 44459d1243231948-want-to-add-list-and-the-formula-for-this-excel-order-list
Sheet: Order

Order | Weight | Price | Quantity | Total | Weight |  | Total Weight
a | 1 | 12 | 30 |  |  |  | 0
d | 4 | 1 | 2 |  |  |  | Total Price | Weight Price | Sum
e | 1 | 1 | 3 |  |  |  | 0 | #N/A | #N/A
aa | 1 | 12 | 30
dd | 4 | 1 | 2
ff | 2 | 131 | 1
Spreadsheet: 835049d1688240746-transposing-data-and-splitting-cells-s666-pq-transposing-data-and-splitting-cells
Sheet: Sample

Type |  |  | Score 2
AA | BB
0-7 | 0-5 |  | 1
8-10 | 6-7 |  | 2
11-14 | 8-9 |  | 3
15-19 | 10-11 |  | 4
20-24 | 12-13 |  | 5
25-29 | 14-15 |  | 6
30-35 | 16-18 |  | 7
36-40 | 19-20 |  | 8
41-44 | 21-22 |  | 9
45-48 | 23-23 |  | 10
49-53 | 24-25 |  | 11
54-56 | 26-26 |  | 12
57-58 | 27-28 |  | 13
59-60 | 29-29 |  | 14
61-62 | 30-30 |  | 15
63-63 | 31-31 |  | 16
64-64 | 32-32 |  | 17
65-65 | 33-33 |  | 18
66-66 | 34-36 |  | 19
Spreadsheet: 192737-edit-update-data-on-a-range-using-combobox-fakehealer-form-to-change-value
Sheet: Sheet1

Student Name | Student Number
Help Me This | 20
I Need Help | 10
Ances [NAME] | 3
[NAME] | 4
[NAME] | 5
Art | 6
Ark | 7
[NAME] | 8
[NAME] | 9
Boy | 10
[NAME] | 11
[NAME] | 12
Cris | 13
Fabian | 14
Fabrice | 15
Fabron | 16
Fadil | 17
Fagan | 18
Fairfax | 19
[NAME] | 20
[NAME] | 21
Falgun | 22
Falk | 23
Falkner | 24
Fallon | 25
Fane | 26
[NAME] | 27
Farand | 28
[NAME] | 29
Fariel | 30
Farkas | 31
Farley | 32
Farman | 33
Farnell | 34
Farnley | 35
Farook | 36
Farquhar | 37
Farrar | 38
[NAME] | 39
Farriss | 40
Faulkner | 41
Faust | 42
Favian | 43
Faxon | 44
[NAME] | 45
Fear | 46
Februus | 47
Fedele | 48
Federico | 49
Felipe | 50
Felix | 51
Felton | 52
Fenn | 53
Fenton | 54
Fenwick | 55
Feodore | 56
Ferdinand | 57
Ferenc | 58
Fergal | 59
Fergus | 60
Ferguson | 61
[NAME] | 62
Fernleigh | 63
Fernley | 64
Feroz | 65
Ferran | 66
Ferrand | 67
Ferrer | 68
[NAME] | 69
Feste | 70
Festus | 71
Ffionn | 72
Fiachra | 73
Fidel | 74
Fielding | 75
Fife | 76
Figaro | 77
[NAME] | 78
Filip | 79
Filippo | 80
Finbar | 81
Fineas | 82
Fingal | 83
Finian | 84
Finlay | 85
Finley | 86
[NAME] | 87
Finnegan | 88
Fionn | 89
Firdos | 90
Firmin | 91
Firth | 92
Fisk | 93
Fitch | 94
Fitz | 95
Fitzgerald | 96
Fitzhugh | 97
Fitzjames | 98
Fitzpatrick | 99
Fitzroy | 100
Fjodor | 101
Flannan | 102
Flannery | 103
Flavian | 104
Flavius | 105
Maaka | 106
Maarten | 107
[NAME] | 108
Mac | 109
Macarius | 110
[NAME] | 111
[NAME] | 112
[NAME] | 113
Macey | 114
Macy | 115
[NAME] | 116
Maddock | 117
Madhusudhana | 118
[NAME] | 119
Magnus | 120
Magus | 121
Mahavira | 122
[NAME] | 123
Mahir | 124
Mahmood | 125
Mahomet | 126
Mahon | 127
[NAME] | 128
[NAME] | 129
Major | 130
Maka | 131
Makani | 132
Makepeace | 133
Makis | 134
[NAME] | 135
Maksim | 136
Makya | 137
Malcom | 138
Malden | 139
Malik | 140
Malin | 141
Malise | 142
[NAME] | 143
Mallory | 144
Malone | 145
Malvern | 146
[NAME] | 147
Manik | 148
Manley | 149
Manuel | 150
Marama | 151
Marcade | 152
Marcell | 153
Marcellus | 154
Marcin | 155
[NAME] | 156
Marcus | 157
Marian | 158
Marino | 159
Mario | 160
Marion | 161
Marius | 162
Mark | 163
Markandeya | 164
[NAME] | 165
Marlow | 166
Martin | 167
[NAME] | 168
[NAME] | 169
Mason | 170
Masud | 171
Matanga | 172
[NAME] | 173
Maxwell | 174
Maynard | 175
Mead | 176
Mearann | 177
Melancton | 178
Melburn | 179
[NAME] | 180
Menecrates | 181
Menelaus | 182
Menteith | 183
[NAME] | 184
Mercade | 185
Mercer | 186
[NAME] | 187
[NAME] | 188
Merlin | 189
[NAME] | 190
Mert | 191
Merten | 192
Mick | 193
[NAME] | 194
Miguel | 195
Mihaly | 196
Mihir | 197
Mikael | 198
[NAME] | 199
[NAME] | 200
Mikkel | 201
Mikko | 202
Miko | 203
Milan | 204
[NAME] | 205
Millard | 206
Milo | 207
Mingma | 208
Miro | 209
Mitch | 210
Mitcham | 211
Mohin | 212
Mohit | 213
Monro | 214
Spreadsheet: 68130d1268682102-excel-2007-dropdown-menu-peacocks-planner-01
Sheet: Schedule

Weekly Employee Shift Schedule [Peacocks Ltd]
Period Start Date : | 2010-03-22 00:00:00
 |  |  |  |  |  |  |  | Paid |  |  | Shift Hours | Shift Hours | Shift Hours | Shift Hours | Shift Hours | Shift Hours | Shift Hours |  | Labor Cost | Labor Cost | Labor Cost | Labor Cost | Labor Cost | Labor Cost | Labor Cost
Employee |  |  |  |  |  |  |  | Hours
Janice
Angie
[NAME]
Katrice
[NAME]
Caroline
[NAME]
[NAME]
[NAME]
Nikki
[NAME]
April
Zoe
Total Paid Hours
Notes:
1) This worksheet is protected to prevent accidental deletion of the underlying formulas in summary cells. The password used is "password"
2) Using this workbook, you can create a weekly work schedule for up to 20 employees and 9 shifts.  Employee names and labor rates are defined in the Employees worksheet. Shifts and shift durations are defined in the Shifts worksheet.  To assign a shift to an employee, click on the corresponding schedule cell and pick a shift from the drop-down list.  Work hours and labor costs are automatically computed based on shift assignments and labor rates.  If your scheduling needs are more than just creating a weekly work schedule, you should use a scheduling program like [NAME].
Spreadsheet: darrell_schoolcraft__7414__imball0201
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -108258 | -77140
9238 | -14493 | -30000 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -2879781 | -2926567
58710 | -190943 | -197084
60921 | -1328045 | -1260629
78026
500084 | -71420 | -90000
500085 | -12987
500097 | -105000 | -120000
INDEX
2001-12-31 00:00:00 |  |  | 766914.32
2002-01-30 00:00:00
CBS Volume
 |  |  | 307322
Spreadsheet: 767413d1644452367-creating-exception-report-excelexceptionreport-example-kpowzz-
Sheet: EXCEPTION REPORT

EMP ID | NAME | [NAME] | HOURS | MANAGER ID | MANAGER [NAME] | [NAME] | [NAME] | [NAME] |  |  |  |  |  | Location | Location Code
1001 | [NAME] | HOME | 40 | 2001 | [NAME] |  |  |  |  |  |  |  |  | Home | 1
1002 | STEVE | OFFICE | 40 | 2002 | [NAME] |  |  |  |  |  |  |  |  | Office | 2
1003 | [NAME] | HOME | 40 | 2003 | [NAME]
1004 | DIANA | HOME | 30 | 2004 | [NAME]
1005 | NEIL | HOME | 40 | 2005 | REBECCA
1006 | GRAHAM | HOME | 40 | 2006 | REBECCA
1007 | KAREN | OFFICE | 40 | 2007 | REBECCA
1008 | KIRSTY | HOME | 40 | 2008 | [NAME]
1009 | STUART | HOME | 40 | 2009 | [NAME]
1010 | NICOLA | OFFICE | 34 | 2010 | [NAME]
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: SAP

 | SAP
 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  |  |  | Per HC | New HC | Adj Comp |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  |  | Compensation | 0
 | Analysts & Associates | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  | Other |  | 12
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services |  |  |  |  |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  | 0
ENACONTR | Charitable Contributions |  |  |  |  | 0 |  |  | [NAME] | 49200 | 0
ENARENT | Rent |  |  |  |  | 0 |  |  | [NAME] | 57600 | 0
ENATECH | Technology |  |  |  |  |  |  |  | Staff | 60000 | 0
ENATRANS | Transportation |  |  |  |  | 0 |  |  | Specialist | 78000 | 2
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Sr. Specialist | 102000 | 2
ENATAXES | Taxes Other than Income |  |  |  |  | 0 |  |  | Analyst | 0 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Associate | 0 | 0
 |  |  |  |  |  |  |  |  | Manager | 144000 | 3
 | Headcount |  |  | 111 |  | 12 |  |  | Director | 168000 | 2
 |  |  |  |  |  |  |  |  | Sr. Director | 216000 | 3
 | Analysts & Associate Headcount |  |  | 0 |  | 0 |  |  | VP | 222000 | 0
 |  |  |  |  |  |  |  |  | MD | 300000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance |  |  |  |  |  |  |  | Consultants | 160000 | 0
ENASYSDV | System Development |  |  | 0
ENACORIT | Controllable Infrastructure |  |  | 0
ENACORRN | Corporate Rent |  |  | 0
ENAOTHAL | Other Allocated Direct  Expenses |  |  | 0 |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization |  |  | 0
 |  |  |  |  |  |  |  | Based on information from ENW accounting.
Spreadsheet: 80172d1280374057-lookup-or-match-index-archery_again
Sheet: Input sheet

 | Bow | Category | Round | Score |  | Classification |  | F-Row | L-Row | Col | Match
 | Compound | Gentlemen | York | 890 |  | 2nd Class |  | 80 | 85 | 4 | 5
 | Archery classifications explained.
 | Every time you shoot one of the 59 rounds (which vary in the numbers of arrows, distance, and target size) in addition to a handicap score you earn a classification. They Range from Grand Master Bowman (GMB) to unclassified. You need to achieve or exceed a particular score to get the respective classification.  Some rounds are less demanding and the higher classification cannot be earned by shooting them.  There are 40 Categories of archer depending on age, gender and bow type with varying ‘thresholds’ for the awards.
 | In the table for example looking at the recurve gents ‘Hereford Round’ |  |  |  |  |  |  | Score | Clasification
 |  |  |  |  |  |  |  | 900 | 1st class |  | Bows | Categories
 |  |  |  |  |  |  |  | 883 | 2nd class |  | Recurve Compound | Ladies
 |  |  |  |  |  |  |  |  |  |  | Compound | J Ladies U-18
 |  |  |  |  |  |  |  |  |  |  | [NAME] | J Ladies U-16
 |  |  |  |  |  |  |  |  |  |  | Barebow | J Ladies U-14
 |  |  |  |  |  |  |  |  |  |  |  | J Ladies U-12
 |  |  |  |  |  |  |  |  |  |  |  | Gentlemen
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-18
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-16
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-14
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-12
Spreadsheet: 877756d1724655768-filter-by-first-8-digits-and-oldest-date-excelnewbie92-test2-14-365-aligw
Sheet: Sheet1

 | BR746241 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wanted Result
 |  | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2020-12-08 00:00:00 | 1 | 1 |  | BR745706401402 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-02-02 00:00:00 | 1 | 1
 |  | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2020-08-18 00:00:00 | 1 | 1 |  | BR745333401402 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2022-04-05 00:00:00 | 1 | 1
 |  | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2020-03-17 00:00:00 | 1 | 1 |  | [NAME] |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2021-04-06 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-12-17 00:00:00 | 1 | 1
 |  | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-12-17 00:00:00 | 1 | 1 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-02-02 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-09-09 00:00:00 | 1 | 1 |  | BR745333401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2022-04-05 00:00:00 | 1 | 1
 |  | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-09-09 00:00:00 | 1 | 1 |  | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2021-04-06 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-05-21 00:00:00 | 1 | 1
 |  | BR746241501402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-05-21 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2019-02-25 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2018-10-29 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2018-07-18 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2018-04-18 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2018-01-09 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-09-26 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2017-04-04 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-12-06 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-08-09 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-04-25 00:00:00 | 1 | 1
 |  | BR745706401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2016-02-02 00:00:00 | 1 | 1
 |  | BR745333401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2022-09-26 00:00:00 | 1 | 1
 |  | BR745333401402 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2022-04-05 00:00:00 | 1 | 1
 |  | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2021-10-19 00:00:00 | 1 | 1
 |  | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2021-04-06 00:00:00 | 1 | 1
 |  | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2021-07-27 00:00:00 | 1 | 1
Spreadsheet: scott_neal__37865__STOR9795
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9795
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2000-09-01 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 529 | 532
(TX, LA, OK, KS, MS)
Market Area - East |  | 1254 | 1294
Market Area - West |  | 361 | 360
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 1335 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871
Spreadsheet: 249685d1373580571-producing-secondary-table-based-on-drop-down-menu-value-excel-table
Sheet: July 2013

Completed
In Progress
[NAME] | Completed | 2000
[NAME] | Completed | 1500
[NAME] | Completed | 3000
Client Name | Column1 | Potential Value
[NAME] | Completed | 2000
[NAME] | Not Started | 2000
[NAME] | In Progress | 2000
[NAME] | Completed | 1500
[NAME] | Not Taken Up | 3000
[NAME] | Not Started | 2000
[NAME] | Completed | 3000
[NAME] | Not Started | 1000
Spreadsheet: 155116d1336672641-converting-multiple-sets-of-rows-to-a-single-row-example
Sheet: after

Name | Birth date | Cust # | H or M | [NAME] | Order Total | Ship Date | Tracking # | phone | phone 2 | fax | Other | H or M | [NAME] | Order Total | Ship Date | Tracking # | phone | phone 2 | fax | Other | H or M | [NAME] | Order Total | Ship Date | Tracking # | phone | phone 2 | fax | Other | H or M | [NAME] | Order Total | Ship Date | Tracking # | phone | phone 2 | fax | Other | H or M | [NAME] | Order Total | Ship Date | Tracking # | phone | phone 2 | fax | Other | H or M | [NAME] | Order Total | Ship Date | Tracking # | phone | phone 2 | fax | Other | H or M | [NAME] | Order Total | Ship Date | Tracking # | phone | phone 2 | fax | Other | H or M | [NAME] | Order Total | Ship Date | Tracking # | phone | phone 2 | fax | Other | H or M | [NAME] | Order Total | Ship Date | Tracking # | phone | phone 2 | fax | Other
RICHARDS, ROBERT N | 1985-10-30 00:00:00 | ILD4714E | M | 10 | 275 | 2012-01-03 00:00:00 | 6014988586 | 1383860418 | 4308125325 | 2688699779 | 2 | M | 7 | 354 | 2011-10-09 00:00:00 | 1840515674 | 7126620155 | 4745390203 | 7334265844 | 38 | M | 5 | 322 | 2011-06-07 00:00:00 | 7965441650 | 6642886488 | 5872514179 | 4335513102 | 41
HORSEMAN, ROSA M | 1963-03-05 00:00:00 | MXX3495C | H | 11 | 42 | 40702 | 1094926239 | 4345625993 | 6611977007 | 6563550835 | 26 | H | 9 | 206 | 2011-06-09 00:00:00 | 3904255266 | 1481819134 | 2690397875 | 1546743646 | 15 | M | 13 | 176 | 2011-06-10 00:00:00 | 5404463549 | 7644028052 | 1450198516 | 4015202335 | 38 | M | 9 | 173 | 2011-06-11 00:00:00 | 3809666780 | 1359441169 | 3353123390 | 2728869047 | 40 | M | 2 | 227 | 2011-06-12 00:00:00 | 1302872858 | 4457524656 | 3893250956 | 2692583149 | 24 | M | 4 | 360 | 2011-06-13 00:00:00 | 7790726904 | 5200105911 | 2697013468 | 6777598607 | 5 | M | 6 | 201 | 2011-06-14 00:00:00 | 1194988931 | 5066469949 | 3095384507 | 3097684047 | 9 | M | 14 | 139 | 2011-06-15 00:00:00 | 1890826314 | 4963908508 | 3389606388 | 5689208312 | 36
LISA, TONI S | 1948-10-06 00:00:00 | SP300P5W | H | 14 | 177 | 2011-06-16 00:00:00 | 4486607982 | 2351265618 | 3605825395 | 5522566466 | 29 | H | 6 | 172 | 2011-06-17 00:00:00 | 1462946787 | 3574135240 | 1891544822 | 1821589273 | 18 | H | 13 | 27 | 2011-06-18 00:00:00 | 6756070661 | 5186333454 | 2076506151 | 4431812940 | 26 | H | 14 | 352 | 2011-06-19 00:00:00 | 5863083236 | 4767429857 | 5844078332 | 3605922138 | 11 | H | 17 | 226 | 2011-06-20 00:00:00 | 9189908165 | 6776724953 | 1697013797 | 6375117588 | 17 | M | 12 | 174 | 2011-06-21 00:00:00 | 1559810227 | 5777559166 | 6027224382 | 1387522228 | 20
Spreadsheet: d6c8b299-49db-4592-b2e8-fbdf679926b1
Sheet: Sheet1

American Recovery and Reinvestment Act of 2009: Tax Credit Assistance Program (TCAP) [NAME] | Unnamed: 1
State Housing Finance Agency | TCAP Recovery Grant Amount
ALASKA | 5490631
ALABAMA | 31952086
ARKANSAS | 20463053
ARIZONA | 32308066
CALIFORNIA | 325877114
COLORADO | 27349670
CONNECTICUT | 26170888
DISTRICT OF COLUMBIA | 11644346
DELAWARE | 6608893
FLORIDA | 101134952
GEORGIA | 54481680
HAWAII | 9861610
IOWA | 18978542
IDAHO | 8753622
ILLINOIS | 94676979
INDIANA | 38048333
KANSAS | 17121110
KENTUCKY | 31616176
LOUISIANA | 39383397
MASSACHUSETTS | 59605630
MARYLAND | 31701696
MAINE | 10690750
MICHIGAN | 63974711
MINNESOTA | 28434123
MISSOURI | 38687026
MISSISSIPPI | 21881803
MONTANA | 7818360
NORTH CAROLINA | 52152687
NORTH DAKOTA | 4860574
NEBRASKA | 11380566
NEW HAMPSHIRE | 8269787
NEW JERSEY | 61243670
NEW MEXICO | 13876558
NEVADA | 15184795
NEW YORK | 252659616
OHIO | 83484547
OKLAHOMA | 25723568
OREGON | 27343971
PENNSYLVANIA | 95050396
PUERTO RICO | 42646082
RHODE ISLAND | 11933403
SOUTH CAROLINA | 25384973
SOUTH DAKOTA | 5405055
TENNESSEE | 39032515
TEXAS | 148354769
UTAH | 11639074
VIRGINIA | 44247749
[NAME] | 5416546
WASHINGTON | 43010192
WISCONSIN | 35594904
WEST VIRGINIA | 16541848
WYOMING | 4846908
Spreadsheet: 239966d1370101642-inexperienced-needs-some-major-help-on-writing-tiered-structure-formula-bonustierstructure
Sheet: Sheet1

 |  | up to  $25,000 | up to  $50,000 | up to  $75,000 | up to  $100,000 | over $100,000
 | 0 | N/A | N/A | N/A | N/A | N/A
 | 0.05 | 50 | 75 | 100 | 115 | 125
 | 0.1 | 100 | 150 | 200 | 230 | 250
 | 0.15 | 150 | 225 | 300 | 345 | 375
 | 0.2 | 200 | 300 | 400 | 460 | 500
 | 0.25 | 250 | 375 | 500 | 575 | 625
 |  | LY | 0.05 | 0.1 | 0.15 | 0.2 | 0.25
 | Jan
 | Feb
 | Mar
 | Apr
 | May
 | Jun
 | Jul
 | Aug
 | Sep
 | Oct
 | Nov
 | Dec | 40000 | 180 | 260 | 340 | 420 | 500
 | Year Total
 |  |  | 40000
 |  | plus 5 % increase =
 |  |  | 42000
 |  | Then take 1/4% of sales (0.25% of 42,000)
 |  | Equals 105  (Bonus payout for 1/4% of total sales)
 |  | Then add growth bonus based on chart above
 |  | Falls in the greater than 25k but less than 50k tier of 5 %
 |  | Add $75 to the 105 bonus for total bonus equaling 180 and so on for each growth %
Spreadsheet: a0e58767-0c09-4269-ba4d-213da7090b9c
Sheet: Sheet1

CAPITAL PROJECT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Ordinance Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Transferring appropriations to Old Santa Fe Trail - Oak to Wornall Construction (Project No. 89020062).
Is  this ordinance for the following: |  |  |  |  | New Construction
 |  |  |  |  | Replacement
 |  |  |  |  | Repair
Was this project programmed in the Five-Year Capital Improvement Plan? |  |  |  |  |  |  |  | No |  |  | Yes
 | If yes, please identify year in which this project was funded.
 | If no, please detail the reasons why this project was not included and need for present funding request.
Does this project leverage non-city funds for design/construction? |  |  |  |  |  |  |  | No |  |  | Yes
 | If yes, please identify source and amount.
 | If no, please identify source and amount of city funds.
 | 07-3090-708609-B-70071301 (Old Santa Fe Trail-Oak to Wornall). $377,000.00
If ordinance is for construction or replacement of asset please provide the following information:
 | Total estimated costs (design through construction): |  |  |  | 377000
 | Estimated lifespan of project in years
 | Estimated annual operating and maintenance costs
 | (Please detail type of maintenance or operating costs needed, additional staffing, capital maintenance costs, utilities, etc.)
Are these O&M costs reflected in the current budget? |  |  |  |  |  |  |  | No |  |  | Yes
 | If yes, please provide source of funds. |  |  |  | General Funds
 | If no, please identify year in which additional operating and maintenance costs will be needed.
Reference Numbers: (Previously approved legislation):
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 219914d1363013011-counting-unique-values-with-an-if-statement-as-well-fursmanm
Sheet: Sheet1

Age | Event
0 | 0 |  |  | 3
1 | 0
2 | 0
3 | 1
4 | 0
5 | 0
6 | 0
7 | 0
8 | 0
9 | 0
10 | 0
Spreadsheet: 229308d1366364530-dependent-drop-down-lists-based-on-dynamic-data-range-book1-2-
Sheet: Static Data For Dropdowns

Quarter1 | Qtr 1 | Qtr 2 | Qtr 3 | Qtr 4 | Year1
Qtr 1 | Jan | Apr | Jul | Oct | 2013
Qtr 2 | Feb | May | Aug | Nov | 2012
Qtr 3 | Mar | Jun | Sep | Dec | 2011
Qtr 4 |  |  |  |  | 2010
Spreadsheet: 763902d1642449322-search-string-of-characters-sample
Sheet: Sample

Column A | Name | Column B | Column C
Data | dfasdf asdfasdf, sadfasdf | Data | Data
Data | [EMAIL] | Data | Data
Data | asdfasdf-asdfasdf | Data | Data
Data | sadfsdf.sdfsdfsd.sfdsdf | Data | Data
Data | sdfsdfsdfsdf/asdfasdfasd | Data | Data
Spreadsheet: 674080d1587652584-assistance-with-array-example
Sheet: Source

Project Name | Week End Date | Employee Name
Client1 | 02-29-2020 | [NAME]
Client1 | 02-29-2020 | [NAME]
Client1 | 02-29-2020 | [NAME]
Client1 | 02-29-2020 | [NAME]
Client1 | 03-07-2020 | [NAME]
Client1 | 03-07-2020 | [NAME]