tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 015be812-c306-4391-97a9-52e8b1b6f249
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-09-20 09:26:58.400000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.755 | 101.63 | 101.505 | 101.13
4.25 | 101.251 | 101.126 | 101.001 | 100.626 |  | Note: | Refer To Price [NAME]
4.125 | 100.349 | 100.224 | 100.099 | 99.724 |  |  | For all Price Adjs
4 | 99.891 | 99.766 | 99.641
3.875 | 99.321 | 99.196 | 99.071
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 101.875 | 101.75 | 101.625 | 101.25
3.625 | 101.571 | 101.446 | 101.321 | 100.946
3.5 | 101.234 | 101.109 | 100.984 | 100.609
3.375 | 100.861 | 100.736 | 100.611 | 100.236
3.25 | 100.324 | 100.199 | 100.074
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-10-04 09:26:58.400000
30 DAY | 2011-10-19 09:26:58.400000
45 DAY | 2011-11-03 09:26:58.400000
60 DAY | 2011-11-18 09:26:58.400000
90 DAY | 2011-12-18 09:26:58.400000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: michelle_lokay__26621__imbalsumm0102
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-01-31 00:00:00 |  | 16766.48
2001-02-07 00:00:00
60874 | 954
500235
500248
500251
500254
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2001-01-31 00:00:00 |  | 275313.72
2001-02-07 00:00:00
9164
9167
Duke Energy Trading and Marketing
Contract  24361
2001-01-31 00:00:00 |  | 467961.61
2001-02-07 00:00:00
500241
500391 | 1648
500392 | 464
Duke Energy Trading and Marketing
21665 |  | 73449.16
22664 |  | 23612.35
20248 |  | -15794
25873 |  | -259
26758 |  | -596
26372 |  | 2997.09
26700 |  | 4077.9
26422 |  | 8155.8
26661 |  | 146862.35
27291 |  | -17965
27123 |  | -6425.19
Spreadsheet: darrell_schoolcraft__7635__SUNFLOWER - NNG - HOURLY - 2002
Sheet: 11

Jan 2002 HOURLY ESTIMATES - NNG - SUNFLOWER S4 & S5
WEEKENDS & AFTER 17:00 -
EMERGENCY CONTACTS: |  | [NAME] (PAGER) |  |  |  | Friday, 01/11/02
 | [NAME] | S5 | HOLCOLM | [NAME] | S5 | S4 & S5 | TOTAL
HOUR | MWH | MWH | MMBTU | MMBTU | MMBTU | MMBTU SUBTOTAL | MMBTU
09:00:00 | 0 | 0 | 6.75
10:00:00 | 0 | 0 | 6.75
11:00:00 | 0 | 0 | 6.75
12:00:00 | 0 | 0 | 6.75
13:00:00 | 0 | 0 | 6.75
14:00:00 | 0 | 0 | 6.75
15:00:00 | 0 | 0 | 6.75
16:00:00 | 0 | 0 | 6.75
17:00:00 | 0 | 0 | 6.75
18:00:00 | 0 | 0 | 6.75
19:00:00 | 0 | 0 | 6.75
20:00:00 | 0 | 0 | 6.75
21:00:00 | 0 | 0 | 6.75
22:00:00 | 0 | 0 | 6.75
23:00:00 | 0 | 0 | 6.75
1900-01-01 00:00:00 | 0 | 0 | 6.75 | 500
1900-01-01 01:00:00 | 0 | 0 | 6.75
1900-01-01 02:00:00 | 0 | 0 | 6.75
1900-01-01 03:00:00 | 0 | 0 | 6.75
1900-01-01 04:00:00 | 0 | 0 | 6.75
1900-01-01 05:00:00 | 0 | 0 | 6.75
1900-01-01 06:00:00 | 0 | 0 | 6.75
1900-01-01 07:00:00 | 0 | 0 | 6.75
1900-01-01 08:00:00 | 0 | 0 | 6.75
DAILY
TOTAL
Spreadsheet: 843474d1695295403-values-rank-occurrence-based-summarised-by-rank-v2-rank-summary
Sheet: Foglio1

 | Given a list of  valus and their rank based on their occurrences |  |  |  |  |  |  |  |  |  |  | The INDEX function used in col J repeats the rank so many times as occurrences of each given value
 | show a summary of ranks and corresponding values |  |  |  |  |  |  |  |  |  |  | Any suggestion to better it?
 |  |  |  |  |  |  |  |  |  |  |  | I'm using the italian version of the 2019 excel.
 | Values | [NAME] |  |  | Rank |  | Multiple (unwanted)  correspondents |  | Desired single corresp. Rank | Desired single corresp. Pair |  | Ranking summary               ? | But No TOP-DOWN | M6                               ↓↓↓
 |  |  |  |  |  |  |  |  |  |  |  |  |  | previously: |  | =CONTA.SE($B$6:$B$15;_xlfn.ANCHORARRAY(N6)) |  |  |  |  | gave the right results but no TopDown.
 | 1417 |  |  |  |  |  |  |  | 4 | 1215 |  |  |  | amended to -> |  | =CONTA.SE($B$6:$B$15,N6#) |  |  | Result: | Error "formula contains an error in N6#"
 | 1215 |  |  |  |  |  |  |  | 2 | 1417 |  | 2 | 1215 |  |  | … It looks as if the CONTA.SE finds the # INDIGESTIVE!
 | 1523 |  |  |  |  |  |  |  | 1 | 1523 |  | 2 | 1523 | amended to -> |  | =CONTA.SE($B$6:$B$15,N6) |  |  | Result: | gives the same ranking, 2,  to all the 6 values!
 | 1215 |  |  |  |  |  |  |  | 1 | 3144 |  | 2 | 3144
 | 3144 |  |  |  |  |  |  |  | 1 | 7788 |  | 2 | 7788 |  |  | EXCEL SOMETIMES MAKES PEOPLE MAD!
 | 1417 |  |  |  |  |  |  |  | 1 | 3355 |  | 2 | 3355
 | 1215
 | 7788
 | 3355
 | 1215
Spreadsheet: 01b0dab7-5107-43e1-a540-039c8f29f2aa
Sheet: Sheet1

Violent Crime | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | 1993
Age Group | Total | Male | Female
12 and under | 23.04087153234148 | 38.94580819342173 | 6.362019312331895
13-14 | 460.7444272145656 | 740.5097146096654 | 166.9335728066848
15 | 828.6470516255671 | 1378.806517934967 | 248.8859235362783
16 | 1030.869354710049 | 1764.325834249075 | 253.1270416778785
17 | 1115.274401622269 | 1944.227537006674 | 232.7631140889711
18 | 1148.667820966142 | 2037.978235622971 | 213.651862474911
19 | 1008.437274729919 | 1781.093415128585 | 202.7056144591316
20 | 919.4070301002794 | 1609.596520685451 | 198.9678409389304
21 | 876.6451956973146 | 1532.49332107596 | 192.1440193875925
22 | 821.4227011441615 | 1428.572328871918 | 193.2523844478227
23 | 781.5116465322203 | 1351.921380142923 | 193.5793547725796
24 | 736.0541967413016 | 1265.995175287361 | 192.1114303968042
25-29 | 660.6479424794368 | 1130.825561966639 | 186.9904066783782
30-34 | 507.2245719425739 | 862.6773443668413 | 153.7272636589447
35-39 | 361.2532763642279 | 617.0989939619717 | 108.2268822832059
40-44 | 230.3746362678673 | 402.8290873744977 | 62.02046006826964
45-49 | 148.5214948041657 | 265.2666633518765 | 35.98188374721871
50-54 | 97.24933959402755 | 176.4177997459386 | 22.3413691735792
55-59 | 63.62207455960912 | 117.4298894791023 | 14.04547115167225
60-64 | 41.07707882857068 | 79.68116884626313 | 6.928545902297863
65 and over | 15.45390186635846 | 34.4714796203239 | 2.488204450585363
Spreadsheet: 858392d1707113146-extract-time-in-a-cell-book2
Sheet: Sheet1

Chat Duration | Hour | Minute | Second
9 Mins 2 Secs
32 Secs
49 Mins 49 Secs
20 Secs
9 Mins 17 Secs
1 Min 20 Secs
5 Secs
1 Min 17 Secs
7 Mins 58 Secs
32 Mins 12 Secs
2 Mins 7 Secs
54 Secs
12 Mins 38 Secs
53 Secs
10 Mins 1 Sec
24 Mins 58 Secs
2 Hours 6 Mins
8 Mins 30 Secs
2 Hours 37 Mins
8 Mins 47 Secs
14 Mins 59 Secs
23 Mins 40 Secs
29 Mins 50 Secs
11 Secs
9 Mins 13 Secs
9 Mins 22 Secs
55 Secs
9 Mins 35 Secs
2 Hours 7 Mins
9 Mins 51 Secs
11 Secs
10 Mins 4 Secs
7 Mins 30 Secs
10 Mins 12 Secs
2 Hours 5 Mins
25 Secs
39 Mins 6 Secs
7 Mins 41 Secs
5 Mins 22 Secs
24 Mins 45 Secs
19 Secs
40 Secs
11 Mins 14 Secs
51 Secs
3 Mins 24 Secs
8 Mins 49 Secs
34 Secs
9 Mins 13 Secs
9 Mins 34 Secs
6 Secs
10 Mins 13 Secs
10 Mins 21 Secs
10 Mins 41 Secs
14 Mins 1 Sec
8 Mins 1 Sec
11 Mins 21 Secs
8 Mins 30 Secs
17 Mins 27 Secs
8 Mins 37 Secs
7 Mins 8 Secs
9 Mins 9 Secs
1 Min 13 Secs
2 Mins 33 Secs
9 Mins 56 Secs
25 Secs
36 Mins 38 Secs
18 Secs
12 Secs
4 Mins 49 Secs
1 Min 18 Secs
Spreadsheet: 57501d1257719357-summing-total-with-pushbutton-testtt4
Sheet: Year 5G

 | Surname | Forename | Gender | Score A | Score B | FSM | Score C
 | One | [NAME] | B | 1 | 1 | Y | 1
 | Two | [NAME] | G | 2 | 2 | N | 2
 | Three | [NAME] | B | 3 | 3 | N | 3
 | Four | Devine | G | 4 | 4 | N | 4
Spreadsheet: 137896d1327424550-two-dimentional-search-for-non-exact-results-prova
Sheet: Foglio1

300 | 200
 | 0 | 915 | 1120 | 1830 | 2135
 | 305 | 1 | 2 | 3 | 4
 | 610 | 2.25 | 3.25 | 4.25 | 5.25
 | 1525 | 3.5 | 4.5 | 5.5 | 6.5
 |  | 3.25
Spreadsheet: 178994d1346975575-information-auto-fill-honey-cupcake
Sheet: Sheet1

Ingredient | Cost | Gross | Recipe | Unit | Cost Per
Stork | 2.1 | 1000 | 115 | g | 0.2415
Caster Sugar | 1.65 | 1000 | 115 | g | 0.18975
S/R Flour | 1.7 | 1000 | 115 | g | 0.1955
Eggs | 1.89 | 18 | 2 |  | 0.21
Honey | 1.86 | 340 | 20 | g | 0.1094117647058824
Butter | 1.6 | 250 | 50 | g | 0.32
Icing Sugar | 1.89 | 1000 | 400 | g | 0.756
[NAME] | 1 | 454 | 100 | g | 0.2202643171806167
Caster Sugar | 1.65 | 1000 | 200 | g | 0.33
Bicarb
 |  |  |  |  | 2.242426081886499 | 0.1868688401572083
Cases | 9.5 | 50 | 0.19 |  |  | 0.3768688401572082
Spreadsheet: 74c7e720-501c-4686-9a82-b61ce5b9648d
Sheet: Blank Emission Calcs

Product Sales into the Greater San Francisco Bay Area*
Insert product sales volumes and technical information into the cells highlighted in yellow.
 | Coating Company
Product | Volume | Density | FF | UF | MF | PF | EF | Coating Sold | Formaldehyde Emissions | Formaldehyde Emissions
 | (gallons) | (lbs/gallon) | (wt %) | (wt %) | (wt %) | (wt %) | (mg/gram) | (grams) | (grams/year) | (pounds/year)
Coating 1
Coating 2
Coating 3
Coating 4
Coating 5
Coating 6
Coating 7
Coating 8
Coating 9
Coating 10
Coating 11
Coating 12
Coating 13
Coating 14
Coating 15
Coating 16
Coating 17
Coating 18
Coating 19
Coating 20
 |  |  |  |  |  |  |  |  | Total
Formaldehyde Emissions during Curing:  EF = Emission Factor in mg/gram of coating
EF = 10 x FF + 1.3438 x [UF + 0.1871 x (MF + PF)] + 0.248
Volume:  in gallons sold into the 9 counties of the Greater Bay Area in 2011*
Density:  in pounds (lbs.) per gallon
FF:  Weight % Free Formaldehyde in the coating mixture**
UF:  Weight % Urea Formaldehyde polymer resins in the coating mixture**
[NAME]:  Weight % Melamine Formaldehyde polymer resins in the coating mixture**
PF:  Weight % Phenol / Cyclohexanone Formaldehyde polymer resins in the coating mixture**
Note:  * - Southern Sonoma County and Southwest portion of Solano county are within the Bay Area Air Quality Management District Jurisdiction.
Note:  ** - coating mixture as sold, excluding any recommended catalyst or thinner
Send formaldehyde emissions report no later than July 1, 2012 to:  Bay Area Air Quality Management District, Attention:  [NAME]; 939 Ellis Street, San Francisco, CA  94109.
Spreadsheet: 56419d1256628834-assigning-numbers-to-letters-book1111
Sheet: Sheet1

ROCK | R | O | C | K
5724 | 5 | 7 | 2 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P | 43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y | 56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z | 5
Spreadsheet: 40482d1238780824-validation-list-formula-question-book1
Sheet: Sheet1

TIME OPTIONS |  | Rep Name | Shift Start | Shift End |  |  |  |  | I have my list of representatives and their shift and end times. The order of listing is dictated by another field - so the names won't be alphabetical, nor will the start or end times be in a chronological order.
1900-01-01 00:00:00 |  | A | 09:00:00 | 17:00:00
00:30:00 |  | C | 08:00:00 | 16:00:00
01:00:00 |  | B | 11:00:00 | 19:00:00
01:30:00
02:00:00 |  |  |  |  |  |  |  | My Problem:  Based on the rep I select from the validation field, I want this next validation to only show me TIME OPTIONS that are => the selected reps [NAME] AND are =< the rep's Shift End.
02:30:00 |  |  |  |  |  | I select my rep via a validation
03:00:00
03:30:00
04:00:00 |  |  |  | validation |  | C
04:30:00
05:00:00
05:30:00 |  | I have a list of times, in a 30 minute increment.  I haven't named this list…but I can if it will help in my problem
06:00:00 |  |  |  |  |  |  |  |  |  |  |  | I would like the red cell to be a validation.
06:30:00 |  |  |  |  |  |  |  |  |  |  |  | I know I can do a validation LIST and put in a formula
07:00:00 |  |  |  |  |  |  |  |  |  |  |  | in the SOURCE field…but I'm kind of stuck with what
07:30:00 |  |  |  |  |  |  |  |  |  |  |  | the formula should be…This is where I need help
08:00:00
08:30:00
09:00:00
09:30:00
10:00:00
10:30:00
11:00:00
11:30:00
12:00:00
12:30:00
13:00:00
13:30:00
14:00:00
14:30:00
15:00:00
15:30:00
16:00:00
16:30:00
17:00:00
17:30:00
18:00:00
18:30:00
19:00:00
19:30:00
20:00:00
20:30:00
21:00:00
21:30:00
22:00:00
22:30:00
23:00:00
23:30:00
Spreadsheet: 02ddc2a1-c136-49e4-9193-4365d42517e7
Sheet: Sheet1

Table 2--Soybean meal:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 | 1,000 short tons
2012/131 | 300 | 39875 | 244.912843584927 | 40419.91284358493 |  | 29030.73884358493 | 11114.174 | 40144.91284358493 | 275
2013/142 | 275 | 40410 | 315 | 41000 |  | 29200 | 11500 | 40700 | 300
2014/152 | 300 | 40735 | 165 | 41200 |  | 29700 | 11200 | 40900 | 300
1 Estimated.  2 Forecast.  Note: 1 metric ton equals 1.10231 short tons.
Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates.
Last update: | 2014-06-13 08:15:15.050000
Spreadsheet: 870571d1717066382-need-to-get-a-summary-of-excel-sheets-main-data-sheet
Sheet: 24016

 | [NAME] (PVT)LTD |  | GOOD RECEIPTS NOTE-STORES |  | PAYMENT VOUCHER COPY
 | VENDOR'S NAME -Nalaka Motors |  | COVERING SRN NO |  | GRN DATE | 15/3/2024
 |  |  |  |  | GRN DATE
 | INVOICE NO -668 |  | GRN NO | 24016 | DATE OF INVOICE | 14/3/2024
 | S/NO: | [NAME] OF ITEM RECEIVED | RECEIVED QTY |  | Unit Price | Amount
 |  |  | Unit | Quantity
 | 1 | Universal Joint For Loader | Nos | 1 | 8000
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | ABOVE ITEMS RESEIVED GOOD ,INSPECTED& PREPARED BY    …............................  (Store EXECUTIVE)                DATE:….................................
 | GOODS RECEIVED & TAKEN TO THE STOCKS                        …............................ (Store Manager)                          DATE:….......................................
 | GOODS RESIVED NOTE APPROVED                                      …............................ (Factory Manager)                       DATE:….......................................
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Canada Support

 | 2002 Plan
 |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation | 0
 | Analysts & Associates | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services |  |  |  | 0
ENASUPP | Supplies Expense |  |  |  |  |  |  |  | EOPs/Risk
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 36000 | 1
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | Staff | 54000 | 2
ENARENT | Rent |  |  |  |  |  |  |  | Specialist | 62400 |  |  | includes 1 Analyst
ENATECH | Technology |  |  |  |  |  |  |  | Sr. Specialist | 79200 | 2
ENATRANS | Transportation |  |  |  |  |  |  |  | Manager | 96000 | 2
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | VP | 216000 | 1
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 |  |  |  |  |  |  |  |  | IT
 | Headcount |  |  | 82 | 32 |  |  |  | Staff | 60000 | 2
 |  |  |  |  |  |  |  |  | Specialist | 78000 | 1
 | Analysts & Associate Headcount |  |  | 5 | 1 |  |  |  | Sr. Specialist | 102000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | Accounting
ENAOUTLG | Outside Legal |  |  |  |  |  |  |  | Staff | 49200 | 0
ENAOUTTX | Outside Tax |  |  |  |  |  |  |  | Specialist | 62400 | 2
ENAINSUR | Insurance |  |  |  |  |  |  |  | Sr. Specialist | 74400 |  |  | Includes 1 HR
ENASYSDV | System Development |  |  |  |  |  |  |  | Manager | 90000 | 1
ENACORIT | Controllable Infrastructure |  |  |  |  |  |  |  | Director | 120000 | 1
ENACORRN | Corporate Rent |  |  |  |  |  |  |  | VP | 216000 | 1
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
 | Outside Services | 5703580 |  |  |  |  |  |  | Legal
 |  |  |  |  |  |  |  |  | [NAME] | 52800 | 1
 |  |  |  |  |  |  |  |  | Sr. Counsel | 195600 |  |  | Includes 1 from Reg Affairs
 |  |  |  |  |  |  |  |  | VP | 217200 | 1
Other Expense Calculation
 |  |  |  |  |  |  |  |  | [NAME]
Total Exp | Old HC | Exp/Old HC |  | New HC |  | Exp/New HC |  |  | [NAME] | 52800 | 3
 |  |  |  |  |  |  |  |  | Toronto
 |  |  |  |  |  |  |  |  | Manager | 90000 | 1
 |  |  |  |  |  |  |  |  | Director | 168000 | 1
Spreadsheet: 860800d1708799102-indexing-issue-pull-historical-data-from-table-and-return-last-five-instances-test-workbook
Sheet: MASTER TABLE

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
Customer Name | Cust Code | Address | City | State | Zip | Lead Time | FP Orders | Shipping Method | Primary Carrier | Trans/DtD | Secondary Carrier | Trans/DtD | Tertiary Carrier | Trans/DtD | Typical Ship Date | Acct Mgr. | Receiving Contact | Title | Phone | [NAME] | How to make Appt | Receiving Restrictions/ Notes | 1 pallet | 2 pallets | 3 pallets | Notes | Where to send confirmations | Where to send Invoice | Additional Accounting Contact |  | Preferred Name
Spreadsheet: 836066d1689075904-cell-will-not-change-format-until-double-clicked-qr-code-test-sheet
Sheet: Sheet1

Manufacturer | Vendor | Part Number | Description | Aisle | Bay | Shelf | Concatenated Data | URL Request | QR Code
Manufacturer | Vendor | [PHONE] | Test Part | AISLE 12 | BAY 1 | SHELF 6
Spreadsheet: 167507d1342014555-excel-2003-date-formatting-error-date-appears-one-way-but-is-read-another-way-excel-date-changer
Sheet: Correct Main File

CSR Name | Month
SMITH, BOB | 2011 Total
SMITH, BOB | 2011-01
SMITH, BOB | 2011-02
SMITH, BOB | 2011-03
SMITH, BOB | 2011-04
SMITH, BOB | 2011-05
SMITH, BOB | 2011-06
SMITH, BOB | 2011-07
SMITH, BOB | 2011-08
SMITH, BOB | 2011-09
SMITH, BOB | 2011-10
SMITH, BOB | 2011-11 | 1
SMITH, BOB | 2011-12
ROGERS, [NAME] | 2011 Total
ROGERS, [NAME] | 2011-01
ROGERS, [NAME] | 2011-02
ROGERS, [NAME] | 2011-03
ROGERS, [NAME] | 2011-04
ROGERS, [NAME] | 2011-05
ROGERS, [NAME] | 2011-06
ROGERS, [NAME] | 2011-07
ROGERS, [NAME] | 2011-08
ROGERS, [NAME] | 2011-09
ROGERS, [NAME] | 2011-10
ROGERS, [NAME] | 2011-11
ROGERS, [NAME] | 2011-12
CORDOVA, MARTY | 2011 Total
CORDOVA, MARTY | 2011-01
CORDOVA, MARTY | 2011-02
CORDOVA, MARTY | 2011-03
CORDOVA, MARTY | 2011-04
CORDOVA, MARTY | 2011-05
CORDOVA, MARTY | 2011-06
CORDOVA, MARTY | 2011-07
CORDOVA, MARTY | 2011-08
CORDOVA, MARTY | 2011-09
CORDOVA, MARTY | 2011-10
CORDOVA, MARTY | 2011-11
CORDOVA, MARTY | 2011-12
Spreadsheet: 27546d1220892198-merging-cells-containing-similar-data-pivot-another
Sheet: Sheet1

ID | Event | Date | Responsible
1 | Processing | 2008-08-12 00:00:00 | Bb
1 | Completed | 2008-08-13 00:00:00 | Bb | Sum of Date |  | Event
2 | Processing | 2008-08-14 00:00:00 | Ba | ID | Responsible | Completed | Processing
2 | Completed | 2008-08-15 00:00:00 | Ba | 1 | Bb | 2008-08-13 00:00:00 | 2008-08-12 00:00:00
 |  |  |  | 2 | Ba | 2008-08-15 00:00:00 | 2008-08-14 00:00:00
Spreadsheet: 65d6e843-7418-4980-a0f7-3e2bf84763cb
Sheet: Fall 2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
School of Business - MBA
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Part of Term | Dates | Days | Times | Credits | Lead Instructor | Lead Instructor ID | Percentage | 2nd Instructor | 2nd Instructor ID | Percentage | Contract Code | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: L Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 01-01) 15-01-2019 | pdf |  | 01-01) 15-01-2019 | pdf |  | 03-01) 19-03-2019 | pdf |  | 02-01) 11-02-2019 | pdf |  | 02-01) 10-03-2019 | pdf
 | 02-01) 12-02-2019 | pdf |  | 02-01) 11-02-2019 | pdf |  | 07-01) 02-07-2019 | pdf |  | 07-01) 16-07-2019 | pdf |  | 03-01) 10-03-2020 | pdf
 | 03-01) 10-03-2019 | pdf |  | 04-01) 09-04-2019 | pdf |  | 08-01) 25-08-2019 | pdf |  | 11-01) 12-11-2019 | pdf
 | 04-01) 09-04-2019 | pdf |  | 07-01) 02-07-2019 | pdf |  | 02-01) 27-02-2020 | pdf
 | 05-01) 23-05-2019 | pdf |  | 08-01) 06-08-2019 | pdf |  | 10-01) 29-10-2019 | pdf
 | 06-01) 25-06-2019 | pdf |  | 01-01) 21-01-2020 | pdf |  | 12-01) 10-12-2019 | pdf
 | 07-01) 16-07-2019 | pdf |  | 03-01) 15-03-2020 | pdf
 | 08-01) 27-08-2019 | pdf |  | 05-01) 05-05-2020 | pdf
 | 09-01) 24-09-2019 | pdf |  | 10-01) 29-10-2019 | pdf
 | 01-01) 21-01-2020 | pdf |  | 11-01) 12-11-2019 | pdf
 | 02-01) 18-02-2020 | pdf
 | 03-01) 17-03-2020 | pdf
 | 04-01) 14-04-2020 | pdf
 | 05-01) 05-05-2020 | pdf
 | 06-01) 04-06-2020 | pdf
 | 06-02) 18-06-2020 | pdf