tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 218836d1362591690-excel-magic-regression-with-intercept-specified-excel-regression-non-zero-intercept-data-shifted
Sheet: Straightening Profile

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sin[pi * (rad / pi)^A] |  | P13 | =SIN(O13*PI())
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sin<{cos[(pi - r) / 2] * r}^A> = 1 |  | O13 | =([NAME]/PI())^$O$11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | {cos[(pi - r) / 2] * r}^A = pi / 2 |  |  | =SIN((L13/PI())^$O$11*PI())
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cos[(pi - r) / 2] * r = (pi / 2)^(1/A)
 |  | Converge to Zero |  |  |  |  |  |  |  |  |  |  |  |  | cos[(pi - r) / 2] = (pi / 2)^(1/A) / r |  | [NAME] | =K13*B13
 |  | Converge to Zero |  |  |  |  |  |  |  |  |  |  |  |  | (pi - r) / 2 = acos[(pi / 2)^(1/A) / r] |  | K13 | =COS(J13)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pi - r = 2 * acos[(pi / 2)^(1/A) / r] |  |  | =COS(J13)*B13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r = pi - 2 * acos[(pi / 2)^(1/A) / r]
 | 31.54722131866483 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =SIN(((COS(J13)*B13)/PI())^$O$11*PI())
 | 43.13362752078178
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A: | 3 |  |  | 2
 | degrees | radians | [NAME] | atan |  | radians/2 | cos |  | 180-degrees | radians/2 | cos | cos(radians/2) * (pi - radians) | [NAME] |  | (cos(radians/2) * (pi - radians) / pi)^A | sin * pi |  | (cos(radians/2) * (pi - radians) / pi)^A | sin * pi
 | 0
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | 97
 | 98
 | 99
 | 100
 | 101
 | 102
 | 103
 | 104
 | 105
 | 106
 | 107
 | 108
 | 109
 | 110
 | 111
 | 112
 | 113
 | 114
 | 115
 | 116
 | 117
 | 118
 | 119
 | 120
 | 121
 | 122
 | 123
 | 124
 | 125
 | 126
 | 127
 | 128
 | 129
 | 130
 | 131
 | 132
 | 133
 | 134
 | 135
 | 136
 | 137
 | 138
 | 139
 | 140
 | 141
 | 142
 | 143
 | 144
 | 145
 | 146
 | 147
 | 148
 | 149
 | 150
 | 151
 | 152
 | 153
 | 154
 | 155
 | 156
 | 157
 | 158
 | 159
 | 160
 | 161
 | 162
 | 163
 | 164
 | 165
 | 166
 | 167
 | 168
 | 169
 | 170
 | 171
 | 172
 | 173
 | 174
 | 175
 | 176
 | 177
 | 178
 | 179
 | 180
Spreadsheet: 46035d1244816713-excel-fill-command-solved-haffy-numbering
Sheet: Sheet1

9.45 | 12.41 | 10 | 124.1 |  | 372.3
9.45 | 12.41 | 20 | 248.2 |  | 372.3
11.15 | 14 | 10 | 140 |  | 350
11.15 | 14 | 15 | 210 |  | 350
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: West Power A&A

 | West Power Analyst & Associate
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  | % of |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  | Total Exp |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  |  | Compensation | 0 | 64
 | Special Pays |  |  |  |  | 0
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense |  |  |  |  | 27648
ENAMKTEX | Marketing |  |  |  |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  | 0 |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  | 0 |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  | 12000 |  |  |  | Analyst | 66000
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  |  | Associate | 97200
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  |  | Manager | 120000 | 0
 |  |  |  |  |  |  |  |  |  | Director | 156000 | 0
 | Headcount |  |  |  |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  |  |  |  | VP | 216000 | 0
 | Analyst & Associate Headcount |  |  |  |  |  |  |  |  | MD | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 677322
 |  |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 160324d1339050308-vlookup-with-multiple-criteria-lookupjnnewton
Sheet: Sheet1

Date | ID | Qty | Price |  |  |  |  | Qty | 2 |  | Def Price | 100
2011-07-22 00:00:00 | 1013 | 25 | 24.12
2012-01-31 00:00:00 | 1013 | 2 | 32.5 |  |  |  |  | ID | Price | PRICE |  | MAX DATE
2012-01-31 00:00:00 | 850 | 2 | 45 | ???? | you have 100 here |  |  | 1013 | 32.5
2012-01-31 00:00:00 | 1013 | 9 | 37.5 |  |  |  |  | 850 | 100
2012-05-21 00:00:00 | 869 | 2 | 3.42 | ????? | You have price here 3.42 ----> |  |  | 869 | 3.42
2012-05-21 00:00:00 | 877 | 25 | 0.008666666666666666 | ????? | You have 100 here |  |  | 877 | 100
2012-05-21 00:00:00 | 888 | 765 | 0.0131 |  | How is that?? |  |  | 888 | 1.3
2011-07-22 00:00:00 | 1013 | 25 | 16.31
2012-05-21 00:00:00 | 888 | 1 | 1.3
2011-10-01 00:00:00 | 1013 | 1 | 37.5
 |  |  |  |  |  |  |  | 888 |  | Gets the first instance with correct ID without regard for date or qty
 |  |  |  |  |  |  |  | 888 |  | gets the [NAME] date for the id without checking qty
Spreadsheet: 73866d1274414553-another-look-up-question-example
Sheet: Sheet1

 |  |  | Application Date | Amount
 |  | 1 | 2010-07-01 00:00:00 | -3000
 |  | 2 | 2011-02-01 00:00:00 | -1500
 |  | 3
 |  | 4
 |  | 5
 | Date | Amount | Running Balance |  | These columns would be hidden
 | 2009-02-01 00:00:00 |  | 2500 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2009-03-01 00:00:00 |  | 2700 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2009-04-01 00:00:00 |  | 2900 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2009-05-01 00:00:00 |  | 3100 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2009-06-01 00:00:00 |  | 3300 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2009-07-01 00:00:00 |  | 3500 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2009-08-01 00:00:00 |  | 3700 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2009-09-01 00:00:00 |  | 3900 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2009-10-01 00:00:00 |  | 4100 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2009-11-01 00:00:00 |  | 4300 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2009-12-01 00:00:00 |  | 4500 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2010-01-01 00:00:00 |  | 4700 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2010-02-01 00:00:00 |  | 4900 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2010-03-01 00:00:00 |  | 5100 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2010-04-01 00:00:00 |  | 5300 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2010-05-01 00:00:00 |  | 5500 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2010-06-01 00:00:00 |  | 5700 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2010-07-01 00:00:00 | 3000 | 2900 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2010-08-01 00:00:00 |  | 3100 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2010-09-01 00:00:00 |  | 3300 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2010-10-01 00:00:00 |  | 3500 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2010-11-01 00:00:00 |  | 3700 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2010-12-01 00:00:00 |  | 3900 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2011-01-01 00:00:00 |  | 4100 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2011-02-01 00:00:00 | 1500 | 2800 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2011-03-01 00:00:00 |  | 3000 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2011-04-01 00:00:00 |  | 3200 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2011-05-01 00:00:00 |  | 3400 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2011-06-01 00:00:00 |  | 3600 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
 | 2011-07-01 00:00:00 |  | 3800 |  | 2010-07-01 00:00:00 | -3000 | 2011-02-01 00:00:00 | -1500
Spreadsheet: 866381d1713303610-counting-the-number-of-each-letter-present-in-a-cell-best-explained-by-sample-sheet-data
Sheet: data

 |  |  | T | J | S | O | T | J | S | O
NEG | POS | Diff | negT | [NAME] | negS | negO | posT | [NAME] | posS | posO | sumneg | sumpos | diff2
J O O T | T | -3
S |  | -1
 | S S S S T | 5
J J J S S S S S S S S | T | -10
J | T T | 1
J S | J J J | 1
J S S S S S S S S S T |  | -11
J J J | T T | -1
J S S | O | -2
J S S S S S S S S S S S S |  | -13
J S | O | -1
J T T | S S | -1
Spreadsheet: joe_parks__14715__POSTION05_02
Sheet: SEP_SWAP

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  | 15.5
 |  |  |  |  |  |  |  |  |  |  | 15.5
 |  |  |  |  |  |  |  |  |  |  | 15
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 1ed2bb6e-a76d-40fd-a5a0-2ac34206c1a6
Sheet: 12 people

[NAME], Inc.
419 Palmer Avenue
Falmouth, [NAME]. 02540
[PHONE]
[PHONE] Fax
[EMAIL]
CONTACT PERSONS: [NAME] or [NAME]
12 people:
BREAKFAST:
Fruit for 12 @ 1.75 per person
12 Assorted bagels, cut
Cream Cheese 1#
Plain 1/2
Scallion & Chive 1/2
Muffins- mini 24 @.60
Danish- 3 large cut in half @1.70 ea
Preparation fee |  |  |  | 10
Total w/o delivery |  |  |  | 66.96 |  | or $5.58 per person
The price above does not include plastic plates, silverware, or napkins.
If you would like them priced in please let me know.
SANDWICH PLATTERS:
12 sandwiches from our menu, cut in half
our selection or yours |  |  |  |  |  | or 7.50 per person
12 small bags of chips
OR
10 sandwiches cut in half |  |  |  |  |  | or 7.50 per person
12 small bags of chips
4 1/2 garden salads/dressing
DESSERTS:
[NAME], [NAME]
Pecan Triangles- 36 pieces |  |  |  |  | 18 | or 1.50 per person
12 medium sized cookies |  |  |  |  | 9.6 | or .80 per person
Fruit bowls @ 1.75 pp |  |  |  |  | 21
Granola- 1 large silver bowl 2/3 full |  |  |  |  | 5
Yogurt- 1 large Stoneyfield in silver bowl |  |  |  |  | 4
Breakfast: We use wicker baskets, pretty glassware, and decorative platters.
Everything is fully decorated and overwrapped in plastic. You just need to take the
plastic off to enjoy the morning.
Baskets and all service items need to be returned in the following days.
Mon-Sat 6:30-5:30 or Sunday by 3:30
Lunch: We use disposable plastic platters.
Spreadsheet: 762429d1641554932-problem-with-changing-numbers-test
Sheet: Sheet1

 | Cost Price | 1
 | Gross Margin | 0.01
 | Selling Price(After Discount)
 | Voucher | 0
 | Total Selling Price
 | Shipping Fee | 10
 | Buyer Paying Price
 | Transaction Fee Rate (incl. SST 6%): | 0.0212
 | Service Fee Rate (incl. SST 6%): | 0.0742
 | Commision Fee (incl. SST 6%): | 0.0212
 | Take Home Pay
 | [NAME]
 | Recommended Ads Budget | 0
 | Actual Profit
 | Break Even Margin
Spreadsheet: darrell_schoolcraft__7586__Dec01pnr
Sheet: PNM 500617

 | [NAME]
 | INVOICE DETAIL - DECEMBER, 2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Inventory Calculation
DAY | NAME | CONTRACT NUMBER | MONTH | POI # | type_poi | SCHEDULED INJECTION | SCHEDULED WITHDRAWAL | NET SCHEDULED QTY | Carryover GIP | NET GIP | DAILY INJECTION   PRICE                (Inj + MIC) | DAILY WITHDRAWAL  PRICE               (Wd + MIC) | INJECTION AMOUNT       (Inj + MIC) | WITHDRAWAL  AMOUNT          (Wd + MIC) | Positive Inventory | Negative Inventory | Positive Inventory Components | Negative Inventory Components | [NAME] | Ride Amount
 | PNM | 27267 | 2001-11-01 00:00:00 | 500617 | PnR
1 |  |  |  | PNM-Rio Puerto |  |  |  |  |  |  | 0.3883 | 0.1
2 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
3 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
4 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
5 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
6 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
7 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
8 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
9 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
10 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
11 | TOTAL RATE of $0.09/Dth per TK Lohman |  |  |  |  | 15000 |  |  |  |  | 0.09 | 0.1
12 |  |  |  |  |  |  | -7500 |  |  |  |  | 0.1
13 |  |  |  |  |  |  | -7500 |  |  |  |  | 0.1
14 |  |  |  |  |  |  |  |  |  |  |  | 0.1
15 |  |  |  |  |  |  |  |  |  |  |  | 0.1
16 |  |  |  |  |  |  |  |  |  |  |  | 0.1
17 |  |  |  |  |  |  |  |  |  |  |  | 0.1
18 |  |  |  |  |  |  |  |  |  |  |  | 0.1
19 |  |  |  |  |  |  | -10000 |  |  |  |  | 0.1
20 |  |  |  |  |  |  |  |  |  |  |  | 0.1
21 |  |  |  |  |  |  |  |  |  |  |  | 0.1
22 |  |  |  |  |  | 10000 |  |  |  |  |  | 0.1
23 |  |  |  |  |  |  |  |  |  |  |  | 0.1
24 |  |  |  |  |  |  |  |  |  |  |  | 0.1
25 |  |  |  |  |  |  |  |  |  |  |  | 0.1
26 |  |  |  |  |  |  |  |  |  |  |  | 0.1
27 |  |  |  |  |  |  |  |  |  |  |  | 0.1
28 |  |  |  |  |  |  |  |  |  |  |  | 0.1
29 |  |  |  |  |  |  |  |  |  |  |  | 0.1
30 |  |  |  |  |  |  |  |  |  |  |  | 0.1
31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absolute [NAME]
 |  |  |  | Total Injection |  |  |  |  |  |  | Total Invoice Amount
 |  |  |  | Total W/D
 |  |  |  |  |  |  |  |  |  |  | System Generated |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Inj Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Wd Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | MIC Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | BILL AMOUNT
Spreadsheet: edeb6029-834d-42ba-8076-47e76ae1686e
Sheet: Sheet1

State of New Hampshire - Primary Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | State Senate District 7 - Democratic
2012-09-11 00:00:00 | Hosmer, d | Grimm, r | Youssef, r | [NAME]
Andover | 222
Belmont | 282 | 1 | 1
[NAME] | 185
Canterbury | 299
[NAME] | 145 | 1
[NAME] | 89 |  | 1
[NAME] | 148 | 3 | 1 | 1
Gilford | 547 |  | 3 | 1
[NAME] | 115 |  | 2
[NAME] | 117
[NAME] 3 | 167 |  | 1
[NAME] | 119 |  | 1 | 1
[NAME] | 106 | 1 | 1
[NAME] 6 | 170 |  | 1 | 1
Northfield | 220
Salisbury | 91
[NAME] | 154
Totals | 3176 | 6 | 12 | 4
 | State Senate District 8 - Democratic
 | Wallenstein, d | Odell, r | [NAME]
Acworth | 63
Antrim | 175
Bennington | 90 |  | 1
Bradford | 141 | 1 | 4
Croydon | 21
Deering | 112
Francestown | 147 | 1 | 3
Goshen | 32 | 3
Grantham | 295 | 2 | 1
Hillsborough | 250 | 1 | 1
Langdon | 34
Lempster | 42 | 8 | 1
Marlow | 55 | 1
New London | 416 | 7 | 1
Newbury | 146 | 1
Newport | 255 | 7 | 3
Springfield | 88
Stoddard | 81 | 1
Sunapee | 214 | 2
Sutton | 162 |  | 3
Unity | 74 | 1 | 1
Weare | 369 | 3 | 2
Windsor | 12
Washington | 46
Totals | 3320 | 39 | 21
Spreadsheet: 5b41311c-4805-4da9-90e9-80126a4edaa2
Sheet: Sheet1

Fare | Current | New Fare | Difference | % Increase
[NAME] | 1 | 1 | 0 | 0
Child Fare <10 years | 0 | 0 | 0 | 0
Student Fare | 0.35 | 0.35 | 0 | 0
Honored [NAME] | 0.35 | 0.35 | 0 | 0
[NAME] Pass | 28 | 30 | 2 | 0.071
[NAME] Pass | 80 | 75 | -5 | -0.063
[NAME] 6-Month Pass | 160 | 125 | -35 | -0.219
[NAME] 12-Month Pass | 320 | 225 | -95 | -0.297
[NAME] Monthly Pass | 14 | 15 | 1 | 0.071
Student & Honored Citizen Silver 1-Month Pass | 12 | 12 | 0 | 0
Student & Honored Citizen Silver 3-Month Pass | 33 | 30 | -3 | -0.091
Student & Honored Citizen Silver 6-Month Pass | 66 | 50 | -16 | -0.242
Student & Honored Citizen Silver 12-Month Pass | 132 | 90 | -42 | -0.318
Student & Honored Citizen Silver Pro-Rated Monthly Pass | 6 | 6 | 0 | 0
College-Vocational 1-Month Pass | 12 | 12 | 0 | 0
College-Vocational 3-Month Pass | 33 | 30 | -3 | -0.091
College-Vocational 6-Month Pass | 66 | 50 | -16 | -0.242
College-Vocational 12-Month Pass | 132 | 90 | -42 | -0.318
College-Vocational Pro-Rated Monthly Pass | 6 | 6 | 0 | 0
Transfer (NOTE: No longer used) | 0 | 0 | 0 | 0
One-Day Pass | 0 | 2 | 2 | New
Two-Day Pass | 0 | 4 | 4 | New
Three-Day Pass | 4 | 6 | 2 | 0.5
[NAME] per roll (NOTE: Not issued after January 31, 2009)
Student Tokens - 20 per roll (NOTE: Not issued after January 31, 2009)
Transportation Management (TMA TANF) Pass | 20 | 20 | 0 | 0
Indigent Assistance Pass | 12 | 10 | -2 | -0.167
Indigent One-Day Pass | 0 | 1 | 1 | New
Indigent Tokens - 20 per roll (NOTE: Not issued after January 31, 2009)
Discounted Monthly Pass for Qualified Passengers | 0 | 10 | 10 | New
Sun Van Para-Transit One Way | 2 | 2 | 0 | 0
Sun Van Para-Transit 10 Coupon Book | 18 | 18 | 0 | 0
Summer Fun Pass | 13 | 13 | 0 | 0
City Employee Pass | 14 | 14 | 0 | 0
Spreadsheet: gerald_nemec__11503__010501 HPL
Sheet: HPL OneCalls OnCall

Houston Region
HPL Weekly Report
 | ONE CALLS
 |  | No. of Tickets Received | No. of Tickets Responded To
 | [NAME] | 0 | 0
 | Liberty | 513 | 58
 | [NAME] | 78 | 23
 | Pearland | 710 | 167
 | [NAME] | 35 | 8
 | Corpus | 130
 | Edna | 38 | 3
 | Lockhart | 43 | 11
 | South Texas | 56 | 8
 | ON CALL
 |  | Dates | Contact |  |  | Back-up
 | [NAME]
 | Liberty | 01/04-01/11 | [NAME] |  |  | [NAME]
 | [NAME] | 01/04-01/11 | [NAME] |  |  | [NAME]
 | Pearland | 01/03-01/10 | [NAME] |  |  | [NAME]
 | [NAME] | 01/04-01/11 | [NAME]
 | Corpus | 01/03-01/10 | [NAME]
 | Edna | 01/04-01/11 | [NAME]
 | South Texas  (North) | 01/02-01/09 | [NAME]
 | South Texas  (South | 01/02-01/09 | [NAME]
 | Tivoli | 01/07-01/14 | [NAME]
Spreadsheet: 707163d1607077445-matching-a-substring-returning-value-from-matched-row-but-different-column-test_sheet
Sheet: Sheet1

INPUTS |  |  |  |  |  |  |  |  |  | OUTPUTS
Default | d01 | d02 | d03 | d04 |  |  |  |  |  | tom_version_1 |  |  |  |  | version_1 values
version_1 | v101 | v102 | v103 | v104 |  |  |  |  |  | kate_version_4 |  |  |  |  | version_4 values
version_2 | v201 | v202 | v203 | v204 |  |  |  |  |  | maria_new_version |  |  |  |  | Default values
version_3 | v301 | v302 | v303 | v304
version_4 | v401 | v402 | v403 | v404
Spreadsheet: 474072d1470614023-trying-to-sum-count-from-multiple-worksheets-sampleforecasting-2
Sheet: V

Toshiba
Account Code | Customer Name | Sales Rep | Part Number | Description |  |  |  |  |  | Comments
 |  |  |  |  | August | September | October | November | December
MBI001 | example: MBIE | PCH | PT251A-00C002 | Toshiba Portege Z30-B, Intel Core i5-5300U 2.3/2.7GHz, 13.3" Widescreen HD Backlit Display (1366x768), 4GB DDR3L 1600Mhz memory (one slot used, one slot free) to to 16GB (service technician required), 128GB mSATA SSD, Intel Graphics Media Accelerator, 1Gbps LAN + AM10.0, Intel a/g/n  Bluetooth, [NAME], 4 Cell [NAME], Microsoft Windows 7 Pro 64Bit, with Microsoft Windows 8.1 Pro 64Bit Pro Media in the Box, 3 year warranty | 15 | 15 | 20 |  |  | For building move
 | Earthquake Commission | VJE | Z50  PT577A-00L006 |  | 1 | 2 | 3
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
 |  | VJE
Spreadsheet: 119696d1314666311-if-function-dummy
Sheet: Sheet1

 | Company | Selected | Fee |  |  |  |  |  | yes
 | FIRE ENGINEER |  |  |  |  |  |  |  | no
 | abc |  | 10000
 | def | yes | 5000 |  |  | I want this
 | hij |  | 6000
 | CIVIL ENGINEER
 | lkj | yes | 4000 |  |  | and this added together
 | hgf |  | 6000
 | dsa |  | 4500
TOTAL |  |  |  | and for the total to be in here
 | Also is the following possible
Number of weeks: |  | 5 |  | leading to |  |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5
Start: |  | 2011-08-29 00:00:00 |  |  |  |  | AUG | SEP | SEP | SEP | SEP
End: |  | 2011-10-03 00:00:00
Spreadsheet: 148c3456-74a0-426b-8719-0b3e05aff34d
Sheet: D

 | Appendix D: Reservoir Evaporation Data
Year | Reservoir Evaporation (m3/yr) | Reservoir Evaporation ([NAME]/yr)
1941 | 0
1942 | 0
1943 | 0
1944 | 0
1945 | 0
1946 | 0
1947 | 0
1948 | 0
1949 | 0
1950 | 0
1951 | 0
1952 | 0
1953 | 0
1954 | 6343787.64
1955 | 7873302.84
1956 | 7715417.4
1957 | 5950307.52
1958 | 7236827.16
1959 | 6776739.12
1960 | 8290219.08
1961 | 5154712.92
1962 | 5571629.16
1963 | 6447399.96
1964 | 7156650.96
1965 | 5814624.72
1966 | 6042818.52
1967 | 5731981.560000001
1968 | 5613567.48
1969 | 5280527.88
1970 | 5340968.4
1971 | 4800704.16
1972 | 4493567.64
1973 | 4039647
1974 | 5088105
1975 | 5139911.16
1976 | 4935153.48
1977 | 4294977.36
1978 | 4629250.44
1979 | 8634.36
1980 | 100000
1981 | 100000
1982 | 100000
1983 | 100000
1984 | 100000
1985 | 100000
1986 | 100000
1987 | 100000
1988 | 100000
1989 | 100000
1990 | 100000
1991 | 100000
1992 | 100000
1993 | 100000
1994 | 100000
1995 | 100000
1996 | 66607.92
1997 | 62907.48
1998 | 56740.08
1999 | 53039.64
2000 | 60440.52
2001 | 55506.6
2002 | 62907.48
2003 | 19735.68
2004 | 10000
2005 | 10000
2006 | 10000
2007 | 10000
2008 | 10000
2009 | 10000
Spreadsheet: 113823d1309706258-pull-column-from-one-sheet-to-another-affiliated-new-order-book
Sheet: Condiment Isle

Order | Item # | UPC # | Name | Cost | % |  | # of Items | SRP
1 |  | 46760 | VC PORK & BEANS 8oz
0 | 46732 | 0-52000-01172 | VC PORK & BEANS 8oz | 20.48 | 0.35 |  | 24
0 | 55332 | 0-51500-24128 | JIF PNTBTR CREAMY | 33.86 | 0.25 |  | 12
0 | 60372 | 0-70152-71112 | BM OKRA PICKLED - need to get smaller jar | 30.76 | 0.25 |  | 6
0 | 57630 | 0-28239-00032 | HEAD COUNTRY BBQ SAUCE 32 oz | 59.48 | 0.25 |  | 12
0 | 56149 | 0-72736-04004 | BUDWEISER HONEY BBQ SAUCE | 15.77 | 0.25 |  | 6
0 | 57806 | 0-41500-00700 | FRENCHS MUSTARD SQUEEZE 8 oz | 34.67 | 0.25 |  | 24
0 | 57291 | 0-13000-00640 | HNZ KETCHUP EASY SQUEEZE 20 oz | 25.81 | 0.25 |  | 12
0 | 58401 | 0-21000-02688 | KRAFT MIRACLE WHIP SQUEEZE 12oz | 35.8 | 0.25 |  | 12
0 | 58026 | pg 189 | [NAME] |  | 0.25 |  | 1
0 | 57442 | pg 190 | PACE PICANTE SCE MEDIUM - 12 ct/16 oz | 31.52 | 0.25 |  | 1
0 | 50996 | 0-20000-10745 | G GNT MUSHROOM PIECES 24 ct/4 oz | 31.78 | 0.25 |  | 24
 |  |  | Kraft Zesty Italian Dressing 8 oz
 |  |  | Hidden Valley Orgin Ranch 8 oz
 |  |  | Hidden Valley Orgin Ranch Mix 16 oz
 |  |  | Parade Lg Pitted Blck Olives 6 oz
 |  |  | [NAME] n Water 8 oz
 |  |  | [NAME] in cottonseed oil 3.75 oz
 |  |  | Green Giant Sliced Mushrooms 6 oz
 |  |  | Old El Paso Chopped [NAME] oz
 |  |  | Rotel Orginal Tom/G Chiles 10 oz
 |  |  | Pace Picante Sce Mild 8 oz
 |  |  | Pace Picante Sce Mild 16 oz
 |  |  | Prego Traditional Sauce 14 oz
 |  |  | Minute White Rice 14 oz
 |  |  | [NAME] 4.5 oz
 |  |  | [NAME] 4.5 oz
 |  |  | Kraft Mac & Cheese 7.25 oz
 |  |  | [NAME] Lng Grain Wild Rice 6.2 oz
 |  |  | Skimer Wide Egg Noodles 8 oz
 |  |  | Parade Thin Spaghetti 12 oz
1 |  |  | [NAME] 5 oz
 |  |  | [NAME] 3 oz
 |  |  | Spam Classic 12 oz
 |  |  | [NAME] [NAME] 12 oz
 |  |  | Bama Grape Jelly 16 oz
 |  |  | Parade [NAME] Pickles 16 oz
 |  |  | Parade Manzanilla Olives 5 oz
 |  |  | French's Worcestershire Extra Tendering 5 oz
 |  |  | La Choy Soy Sauce 5 oz
 |  |  | Heinz 57 Sauce 5 oz
 |  |  | [NAME] Sauce 5 oz
 |  |  | McIlhenny Co. Tobasco Pepper Sauce 2 oz
 |  |  | Heinz Ketchup 36 oz
 |  |  | Best Maid Hamburger Slices Dill 32 oz
 |  |  | Parade Bread and Butter Swt Slices 16 oz
 |  |  | Heinz Apple Cider Vinegar 32 oz
 |  |  | Heinz Distilled White Vinegar 21 oz
 |  |  | Heinz Distilled White Vinegar 1 Gal
 |  |  | Chicken of the Sea Tuna in Water 5 oz
 |  |  | [NAME] 24 oz
 |  |  | Hormel [NAME] in Chili Sauce 15 oz
 |  |  | Old El Paso Enchilada Sauce Mild 10 oz
 |  |  | Old El Paso Refried Beans Traditional 16 oz
 |  |  | Casserole Pinto Beans 32 oz