tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 3021382e-04e6-4475-9bf4-437d6a544e0a
Sheet: Totals

Totals Worksheet
Potential Contractor's Proposed Annual Solid Waste Collection Fee Revenue
Base Proposal |  | Key Service Enhancements Proposals |  |  |  |  | Total Proposal |  | New Service Options Proposals
 | Annual Revenue for Solid Waste Collection & Other Services | Annual Revenue Increase/(Decrease) for Key Service Enhancements |  |  |  |  | Total |  | Annual Revenue Increase/(Decrease)
 |  | Saturday | Single-family | Multifamily On-Call |  |  | Annual Revenue |  |  | Organics | In-City Customer
 |  | Collection | Additional | Small Appliance, | On-Line Account | 6 Days a Week | for Base Proposal |  | Unlimited | Recycling - | Service
 |  | for Friday | Recyclables | Electronics, | Management & | Staffed | & Key |  | Commercial | 1 96 Gallon | Opportunities
 |  | Single-family | Where | & Textiles | Electronic | Call Center | Enhancements |  | Recycling | Cart/Week | per Contract
 |  | Misses | Feasible | Recycling | Billing |  | Proposals |  |  | Limit | Section 3.3.2.1
SF Residential - COS Rates |  |  |  | Not Applicable |  |  |  |  | Not Applicable | Not Applicable
Commercial/Multifamily Cart/Container |  | Not Applicable | Not Applicable
Commercial/Multifamily Drop-box |  | Not Applicable | Not Applicable
Proposal  Total
Note: Green shaded cell shows proponent's total revenue for proposal cost scoring comparison.
Residential Linear Rates [NAME] |  | Key Service Enhancements Proposals for Residential Linear Rates Structure |  |  |  |  | Total Proposal |  | New Service Options Proposals for Residential Linear Rates Structure
SF Residential - Linear Rates |  |  |  | Not Applicable |  |  |  |  | Not Applicable | Not Applicable
Spreadsheet: 584947d1533546634-translating-if-todays-price-is-than-previous-high-price-replace-with-todays-to-function-tom1234-excel-problem-1
Sheet: Sheet1

Input name | constantly changing  Price (external bloomberg input) | base high x year manual input | highest price of input
Man Utd |  | 12.25
Chelsea |  | 5.5
Man City |  | 6.2
Arsenal |  | 8.9
Liverpool |  | 2.4
Tottenham |  | 10.8
Southampton |  | 3.7
Derby |  | 0.7
 |  |  | when the yellow highlighted cell is true, that higher number needs to be locked in that cell or another until a higher number (as the inputs in collumn B can go down as well as up) from column B replaces it and then that is locked in a cell etc etc.
 |  |  | The base high is just used to start this condition off
Spreadsheet: 707406d1607251206-using-a-list-to-reduce-worksheets-midshires-master
Sheet: JMa

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 34398d1231628978-list-of-numbers-as-percentage-of-total-numbersaspercentoftotal
Sheet: Sheet1

 |  | Num | %
 |  | 2
 |  | -3 |  |  | [NAME] column D as a percentage hilight cells, [NAME] in this example,  right click, format cells, number, choose percentage
 |  | 1
 |  | -7
 |  | -12
 |  | 15 |  |  | Add all the numbers up, divide each individual number in the list by the sum, then display that number as a percentage by formatting the cells as percentages. To check it, add the percentages up and you should get 100
 |  | 19
Sum of numbers
 |  | 2 |  |  | Or you can display the numbers as percentages this way, look at the formulas in column D, in this example Column D is not formatted as a percentage.
 |  | -3
 |  | 1
 |  | -7
 |  | -12 |  |  | add all the numbers up, divide each individual number in the list by the sum then multiply that by 100 to get the percentage that number is of the sum. To check it, add the percentages up you should get 100
 |  | 15
 |  | 19
Sum of Numbers
Spreadsheet: 85753d1285786889-sorting-womens-grand-prix-2010
Sheet: 3.5 Singles

Rank | Name | Total | Average | ISS/LG Open | SOCC Spring Classic | Kern County | Tournament 4 | Tournament 5 | Tournament 6 | Tournament 7 | Tournament 8 | Tournament 9 | Tournament 10
1 | [NAME] | 80 | 13.33333333333333 | 40 | 0 | 40
2 | [NAME] | 40 | 6.666666666666667 | 0 | 40 | 0
3 | [NAME] | 20 | 6.666666666666667 | 20 | 0 | 0
4 | [NAME] | 20 | 6.666666666666667 | 0 | 20 | 0
5 | [NAME] | 15 | 5 | 0 | 15 | 0
6 | [NAME] | 20 | 6.666666666666667 | 10 | 0 | 10
7 | [NAME] | 10 | 3.333333333333333 | 10 | 0 | 0
8 | Roneva Monreal | 10 | 3.333333333333333 | 0 | 10 | 0
9 | [NAME] | 20 | 6.666666666666667 | 0 | 0 | 20
10 | [NAME] | 80 | 26.66666666666667 | 0 | 0 | 80
11 | [NAME] | 15 | 5 | 0 | 0 | 15
12 |  | 0 | 0 | 0
13 |  | 0 | 0 | 0
14 |  | 0 | 0 | 0
15 |  | 0 | 0 | 0
16 |  | 0 | 0 | 0
17 |  | 0 | 0 | 0
18 |  | 0 | 0 | 0
19 |  | 0 | 0 | 0
20 |  | 0 | 0 | 0
21 |  | 0 | 0 | 0
22 |  | 0 | 0 | 0
23 |  | 0 | 0 | 0
24 |  | 0 | 0 | 0
25 |  | 0 | 0 | 0
26 |  | 0 | 0 | 0
27 |  | 0 | 0 | 0
28 |  | 0 | 0 | 0
29 |  | 0 | 0 | 0
30 |  | 0 | 0 | 0
31 |  | 0 | 0 | 0
32 |  | 0 | 0 | 0
33 |  | 0 | 0 | 0
34 |  | 0 | 0 | 0
35 |  | 0 | 0 | 0
36 |  | 0 | 0 | 0
37 |  | 0 | 0 | 0
38 |  | 0 | 0 | 0
39 |  | 0 | 0 | 0
40 |  | 0 | 0 | 0
41 |  | 0 | 0 | 0
42 |  | 0 | 0 | 0
43 |  | 0 | 0 | 0
44 |  | 0 | 0 | 0
45 |  | 0 | 0 | 0
46 |  | 0 | 0 | 0
47 |  | 0 | 0 | 0
48 |  | 0 | 0 | 0
49 |  | 0 | 0 | 0
50 |  | 0 | 0 | 0
51 |  | 0 | 0 | 0
52 |  | 0 | 0 | 0
53 |  | 0 | 0 | 0
54 |  | 0 | 0 | 0
55 |  | 0 | 0 | 0
56 |  | 0 | 0 | 0
57 |  | 0 | 0 | 0
58 |  | 0 | 0 | 0
59 |  | 0 | 0 | 0
60 |  | 0 | 0 | 0
61 |  | 0 | 0 | 0
62 |  | 0 | 0 | 0
63 |  | 0 | 0 | 0
64 |  | 0 | 0 | 0
65 |  | 0 | 0 | 0
66 |  | 0 | 0 | 0
67 |  | 0 | 0 | 0
68 |  | 0 | 0 | 0
69 |  | 0 | 0 | 0
70 |  | 0 | 0 | 0
71 |  | 0 | 0 | 0
72 |  | 0 | 0 | 0
73 |  | 0 | 0 | 0
74 |  | 0 | 0 | 0
Spreadsheet: 488803d1478839258-text-number-separator-tool-text-seperation
Sheet: Final_Working

Initial Data | Denomination | # | Debit Mov. | Credit Mov. | Debit Balance | Credit Balance
1213 sdajkasd 23123 23123 5435 97887
1 MEIOS FINANCEIROS LÍQUIDOS 124.128,30 117.265,40 6.862,90
11 Caixa 2.099,28 2.099,28
111 Caixa Sede 2.099,28 2.099,28
2 CONTAS A RECEBER E A PAGAR 244.498,58 340.819,10 96.320,52
21 Clientes 58.482,85 31.622,05 26.860,80
211 Clientes c/c 58.482,85 31.622,05 26.860,80
2111 Clientes gerais 58.482,85 31.622,05 26.860,80
21111 Clientes Nacionais 57.832,85 31.297,05 26.535,80
[NAME]
Spreadsheet: 881606d1729716425-rounding-column-values-rounding-to-forum
Sheet: Sheet1

 |  |  | round this column "I" be rounded
 |  |  |  |  |  |  |  |  |  |  |  | -2.100000000000364
 |  |  |  |  |  |  |  |  |  |  | -2.099999999999909
 |  |  |  |  |  |  |  |  |  |  | -20.59999999999991
 |  |  |  |  |  |  |  |  |  |  | -8
 |  |  |  |  |  |  |  |  |  |  |  | -23.30000000000018
 |  |  |  |  |  |  |  |  |  |  | -3.700000000000273
 |  |  |  |  |  |  |  |  |  |  |  | -6.699999999999818
 |  |  |  |  |  |  |  |  |  |  | -11.79999999999973
 |  |  |  |  |  |  |  |  |  |  | -9.200000000000273
 |  |  |  |  |  |  |  |  |  |  |  | -9.899999999999636
 |  |  |  |  |  |  |  |  |  |  | -1.400000000000091
 |  |  |  |  |  |  |  |  |  |  |  | -11.40000000000009
 |  |  |  |  |  |  |  |  |  |  | -6.799999999999727
 |  |  |  |  |  |  |  |  |  |  | -29.5
Spreadsheet: 815013d1674690519-return-top-x-number-of-results-example
Sheet: Sheet1

 | Store | Name | Units |  |  | Page | Query | Units |  | Store | Custom.Data.Name | Custom.Data.Units
 | A | Apple | 5 |  |  | A | Tomato | 15 |  | A | Tomato | 15
 | A | Orange | 10 |  |  | A | Grapes | 13 |  | A | Grapes | 13
 | B | Watermelon | 9 |  |  | B | Mango | 20 |  | B | Mango | 20
 | B | Mango | 20 |  |  | B | Berries | 11 |  | B | Berries | 11
 | A | Grapes | 13 |  |  | C | Pineapple | 10 |  | C | Pineapple | 10
 | C | Pineapple | 10
 | A | Tomato | 15
 | B | Berries | 11
Spreadsheet: 812927d1673461287-get-unique-computer-names-across-several-sheets-columns-computer-names
Sheet: Sheet2

[NAME] 1
Machine name
Computer1
computer2
Computer3
Computer4
Computer5
Computer6
Computer7
Computer8
Computer9
Computer10
Computer11
Computer12
Computer13
Computer14
Computer15
Computer16
Computer17
Computer18
Computer19
Computer20
Computer21
Computer22
Computer23
Computer24
Computer25
Computer26
Computer27
Computer28
Computer29
Computer30
Computer31
Computer32
Computer33
Computer34
Computer35
Computer36
Computer37
Computer38
Computer39
Computer40
Computer41
Computer42
Computer43
Computer44
Computer45
Computer46
Computer47
Computer48
Computer49
Computer50
Computer51
Computer52
Computer53
Computer54
Computer55
Computer56
Computer57
Computer58
Computer59
Computer60
Computer61
Computer62
Computer63
Computer64
Computer65
Computer66
Computer67
Computer68
Computer69
Computer70
Computer71
Computer72
Computer73
Computer74
Computer75
Computer76
Computer77
Computer78
Computer79
Computer80
Computer81
Computer82
Computer83
Computer84
Computer85
Computer86
Computer87
Computer88
Computer89
Computer90
Computer91
Computer92
Computer93
Computer94
Computer95
Computer96
Computer97
Computer98
Computer99
Computer100
Computer101
Computer102
Computer103
Computer104
Computer105
Computer106
Computer107
Computer108
Computer109
Computer110
Computer111
Computer112
Computer113
Computer114
Computer115
Computer116
Computer117
Computer118
Computer119
Computer120
Computer121
Computer122
Computer123
Computer124
Computer125
Computer126
Computer127
Computer128
Computer129
Computer130
Computer131
Computer132
Computer133
Computer134
Computer135
Computer136
Computer137
Computer138
Computer139
Computer140
Computer141
Computer142
Computer143
Computer144
Computer145
Computer146
Computer147
Computer148
Computer149
Computer150
Computer151
Computer152
Computer153
Computer154
Computer155
Computer156
Computer157
Computer158
Computer159
Computer160
Computer161
Computer162
Computer163
Computer164
Computer165
Computer166
Computer167
Computer168
Computer169
Computer170
Computer171
Computer172
Computer173
Computer174
Computer175
Computer176
Computer177
Computer178
Computer179
Computer180
Computer181
Computer182
Computer183
Computer184
Computer185
Computer186
Computer187
Computer188
Computer189
Computer190
Computer191
Computer192
Computer193
Computer194
Computer195
Computer196
Computer197
Computer198
Computer199
Computer200
Computer201
Computer202
Computer203
Computer204
Computer205
Computer206
Computer207
Computer208
Computer209
Computer210
Computer211
Computer212
Spreadsheet: 272317d1382356301-ranking-with-criteria-ranking_expect-result
Sheet: Over Due

Central | Over [NAME] (column D)
Rank | Customer ID | Sum of OD
1 | A3929 | 21274345.07999999 |  |  | cell B3 = A customer who has highest Sum of OD amount, ranking within group of Central region.
2 | A3930 | 17999528.77999999
3 | A0085 | 8614815.970000006 |  |  | Column B = listing of Customer who has highest sum of OD within region
4 | A1150 | 7816132.029999999
5 | A0907 | 3138122.71
6 | A3932 | 2725086.660000001
7 | A3931 | 2597092.89
8 | A0612 | 2586055.51
9 | A1165 | 2402455.28
10 | A6326 | 1350806.79
East | [NAME] (column C)
Rank | Customer ID | Sum of OD
1 | [NAME] | 387318.6
2 | A6547 | 265509.8
3 | A1879 | 260844.6
4 | A7131 | 254157.1
5 | A1824 | 205097.6
6 | A4358 | 172921.83
7 | A3954 | 167660.59
8 | A3298 | 105341.5
9 | A3089 | 80046.7
10 | A2342 | 63729.2
Spreadsheet: 224999d1364850102-data-challenge-turning-massive-amounts-of-sales-order-data-into-summarized-customer-data-eforum-example-solution
Sheet: Desired

Account |  | JAN | FEB | MAR | 2012 | 2011 | 2010
100000 | Total
100000 | # of Orders
100000 | [NAME]
100000 | Orders of $99+
100000 | Orders of $199+
100000 | Orders of $499+
100005 | Total
100005 | # of Orders
100005 | [NAME]
100005 | Orders of $99+
100005 | Orders of $199+
100005 | Orders of $499+
100010 | Total
100010 | # of Orders
100010 | [NAME]
100010 | Orders of $99+
100010 | Orders of $199+
100010 | Orders of $499+
100018 | Total
100018 | # of Orders
100018 | [NAME]
100018 | Orders of $99+
100018 | Orders of $199+
100018 | Orders of $499+
Spreadsheet: 886217d1736252943-linking-two-sheets-with-data-specific-information-sample-register-2025-copy-
Sheet: Job Book

Job  Number | Client | Order Number | Job Details | Date recieved | Due Date | Client Advised Due Date | Reported | Job Turnaround Time | Sample No | Prep | CL | HAC | A/C | MIX | A/S SO3 | W/S SO4 | tS | S2- | MCHW Sulphate Suite | [NAME] | Alkalis | Volhard | Paint | Water | C/S | pH | W/S CL- Potentiometric | Petrogrpahic Analysis | Carbonate Content | Other 1 | Other 2 | Other 3 | Invoiced | Invoice No | Total Job Cost | Total Tests
22992 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
22993 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 712.8
22994 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 367.5
22995 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 128
22996
22997
Spreadsheet: 86679d1286633811-combo-box-lookup-only-projectdatadb
Sheet: Contractors

Date | Name | InvoiceNo | InvoiceAmount | Hours
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  | 0 | 0
Spreadsheet: 694272d1599494602-how-to-use-vlookup-with-changing-table-array-sample-1-
Sheet: Sheet2

country | year | Code | value |  |  | Sum of value | Column Labels
BE | 1 | A | 13.14949645 |  |  |  | 1 |  | 2
BG | 1 | A | 7.10063264 |  |  | Row Labels | A | B | A | B
CZ | 1 | A | 3.2657067 |  |  | BE | 13.14949645 | 15.50549587 | 20.03528441 | 2
DK | 1 | A | 9.70402683 |  |  | BG | 7.10063264 | 13.07703133 |  | 24
DE | 1 | A | 3 |  |  | CZ | 3.2657067 | 4 | 18.16884898 | 6
EE | 1 | A | 12.99360932 |  |  | DE | 3 | 1 | 11.71710219 | 3
BE | 2 | A | 20.03528441 |  |  | DK | 9.70402683 | 2 | 13.95231504 | 5
BG | 2 | A |  |  |  | EE | 12.99360932 | 1 | 10.15221192 | 18
CZ | 2 | A | 18.16884898
DK | 2 | A | 13.95231504
DE | 2 | A | 11.71710219
EE | 2 | A | 10.15221192
BE | 1 | B | 15.50549587
BG | 1 | B | 13.07703133
CZ | 1 | B | 4
DK | 1 | B | 2
DE | 1 | B | 1
EE | 1 | B | 1
BE | 2 | B | 2
BG | 2 | B | 24
CZ | 2 | B | 6
DK | 2 | B | 5
DE | 2 | B | 3
EE | 2 | B | 18
Spreadsheet: 0228cd57-2075-45bf-a9b6-5b7fd9d07203
Sheet: 8x

HEAVY TRUCKS, 24,000 GVWR AND OVER
Vehicles with capital values greater than $75K will receive a unique rate; please contact FSR for details
 | 24,000-27,999 GVWR |  |  | 28,000-31,999 GVWR |  |  |  | 32,000-34,999 GVWR |  |  | 35,000 GVWR And Over
 | Equip. | Monthly | Mileage | Equip. | Monthly | Mileage |  | Equip. | Monthly | Mileage | Equip. | Monthly | Mileage
Vehicle Description | Code | Rate | Rate | Code | Rate | Rate |  | Code | Rate | Rate | Code | Rate | Rate
GASOLINE, [NAME] AND 4X4
Stake and Platform, [NAME] | - | - | - | - | - | - |  | 8012 | 411 | 0.95 | - | - | -
DIESEL, [NAME] AND 4X4
Cab and Chassis, [NAME] | 8500 | 379 | 0.54 | - | - | - |  | 8502 | 424 | 0.59 | 8503 | 446 | 0.61
Cab and Chassis, 4X4 | 8600 | 581 | 0.545 | - | - | - |  | 8602 | 636 | 0.61 | - | - | -
Stake and Platform, [NAME] | 8510 | 379 | 0.54 | - | - | - |  | 8512 | 424 | 0.59 | - | - | -
Stake and Platform, 4X4 | 8610 | 581 | 0.545 | - | - | - |  | 8612 | 625 | 0.61 | - | - | -
Van Body, [NAME] | 8530 | 458 | 0.59 | - | - | - |  | 8532 | 502 | 0.655 | - | - | -
Van Body, Refrigerated, [NAME] | 8540 | 543 | 0.665 | - | - | - |  | - | - | - | 8543 | 608 | 0.71
Dump Body, [NAME] | 8550 | 458 | 0.59 | - | - | - |  | 8552 | 502 | 0.655 | 8553 | 525 | 0.665
Dump Body, 4X4 | 8650 | 615 | 0.61 | - | - | - |  | 8652 | 671 | 0.65 | 8653 | 696 | 0.69
Tractor, [NAME] | - | - | - | 8561 | 508 | 0.62 |  | 8562 | 531 | 0.655 | 8563 | 541 | 0.665
DIESEL, 6X4 AND OTHER | Under 46,000 [NAME] |  |  | 46,000-53,999 GVWR |  |  |  | 54,000-63,999 GVWR |  |  | 64,000 GVWR And Over
Cab and Chassis, 6X4 | 8700 | 680 | 0.59 | 8701 | 705 | 0.62 |  | - | - | - | - | - | -
Cab and Chassis, All Other | - | - | - | - | - | - |  | 8802 | 741 | 0.705 | - | - | -
Stake and Platform, 6X4 | 8710 | 680 | 0.59 | - | - | - |  | - | - | - | - | - | -
Stake and [NAME], All Other | 8810 | 684 | 0.65 | - | - | - |  | - | - | - | - | - | -
Dump Body, 6X4 | - | - | - | 8751 | 741 | 0.66 |  | 8752 | 756 | 0.675 | - | - | -
Dump Body, All Other | - | - | - | 8851 | 745 | 0.715 |  | 8852 | 762 | 0.74 | - | - | -
Tractor, 6X4 | 8760 | 737 | 0.69 | 8761 | 776 | 0.735 |  | 8762 | 812 | 0.77 | - | - | -
Tractor, All Other | - | - | - | - | - | - |  | - | - | - | 8863 | 859 | 0.86
Spreadsheet: 72922d1273611584-excel-2007-isna-vlookup-example
Sheet: Results

1 | 0
2 | 950
3 | 1209*
4 | 2354
5 | 825
6 | 233
7 | 1429
8 | 936
9 | 1335
10 | 1141
Spreadsheet: 1743df55-28ee-488b-814e-e61ed10e7c32
Sheet: 50m & m+ bracket

ISA SENIOR WORLD
JULY 26-27-28, 2013
ALL GAMES ARE AT LINCOLN PARK.
50 MAJOR BRACKET
 |  | S12 Team Ohio          12
 |  | SAT. |  | Chicago Prime         27
 |  | 2 PM # 1 | (2
 |  | S3 Chicago Prime       13 |  | SAT. |  | [NAME]
 |  |  |  | 5 PM # 1 | (5
S4   OKI                           19
SAT. |  | OKI                               16
 | (1 | SAT. |  | OKI                            33
S5 Brickyard Classics    18 |  | 3:30 PM # 1 | (3
 |  | [NAME] 10 Softball     10 |  |  |  | SUNDAY | (7 | [NAME]
 |  |  |  |  |  | 12:30 PM # 1
 |  | LOSER'S BRACKET
 |  |  |  | [NAME]. Prime           22 |  |  |  | IF GAME
 |  |  |  | SUNDAY |  |  |  |  | (8
 |  | L1 Brickyard Classics 17 |  | 11 AM  # 1 | (6 | Chicago Prime       3 |  | SUNDAY
 |  | SAT. |  | Team Ohio               11 |  |  |  | 2 PM # 1
 |  | 6:30 PM # 1 | (4
 |  | L2 Team Ohio            18
 |  |  |  |  |  |  |  | L6
 |  |  |  |  |  |  |  | LOSER OF 6
 |  |  |  |  |  |  |  | IF 1ST LOSS
 |  | 50 MAJOR +     BEST 2 OF 3 @ LINCOLN PARK
 |  | SATURDAY
 |  | Game #1---12:30 PM DIAMOND # 1--AMR________ vs [NAME] _______
 |  | SUNDAY
 |  | Game #2---8 AM DIAMOND # 1--AMR _______ vs [NAME] _______
 |  | IF GAME---9:30 AM DIAMOND # 1--AMR _______ vs [NAME] _______
Spreadsheet: kay_mann__19198__MDEA - Credit Work Sheets
Sheet: ENA&Clarksdale - Master Gas

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY:
DATE: |  | ENA CONTACT: | [NAME] Rorschach x5-3363
COUNTERPARTY: | City of Clarksdale, Mississippi, | CONTACT: | [NAME]
ADDRESS: | Clarksdale Public Utilities | TITLE: | General Manager
 | Commission | PHONE: | [PHONE]
 |  | FAX:
INCORPORATION STATE: | Municipality | MOODY'S RATING: | A3 (Electric Revenue Bond)
STRUCTURE | COUNTERPARTY | ENA ENTITY
COLLATERAL
THRESHOLD  in $ | N/A | N/A
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
COLLATERAL  MULTIPLE | N/A | N/A
GUARANTOR (RATING) | N/A | Enron Corp. (Baa1) | See EPMI and MDEA
LIMIT in $[NAME] |  | $10MM | credit worksheet, below.
Incorporation State: |  | OR
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change | X | X
-Below = | Baa2 - Tied to Clarksdale PUC's existing and future electric revenue and utility revenue bonds. | Baa3 | Moody's
Financial Covenants | X
-Funded Debt/Net Worth
-Minimum Net worth | Tied to Clarksdale PUC - $24MM ($27.5 at 9/30/00)
-Cash Flow/CMLTD
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt
-Counterparty | 250000
-Guarantor |  | 200000000
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES: | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
OTHER COMMENTS
CREDIT REVIEW  PREPARED BY: |  | [NAME]
Spreadsheet: louise_kitchen__24242__JulYTD Orig w notes
Sheet: Canada Gas

Canada Gas
Originator |  | Commodity |  | Team |  | Total |  | %Total
Le Dain |  | Gas |  | Canada
Sangwine |  | Gas |  | Canada
Oh |  | Gas |  | Canada
[NAME] |  | Gas |  | Canada
[NAME] |  | Gas |  | Canada |  | 334057
[NAME] |  | Gas |  | Canada |  | 272578.7369761885
Hrap |  | Gas |  | Canada
Burnham |  | Gas |  | Canada |  | 26409
Abramo |  | Gas |  | Canada |  | 9043
Laporte |  | Gas |  | Canada |  | 4021
[NAME] |  | Gas |  | Canada |  | 3273
Cowan |  | Gas |  | Canada |  | 2863.164572278276
Total
Spreadsheet: 43877d1242508168-creating-a-list-from-across-sheets-problem
Sheet: LIST

A | A1 |  |  |  |  |  |  | K | K1 |  | K3
B | B1 | B2 |  |  |  |  |  | L | L1 | L2 | L3
C | C1 |  |  |  |  |  |  | M |  | M2
D |  | D2 | D3
E | E1
F | F1
G | [NAME]
H |  | H2 | H3
I |  |  | I3
J | J1
I need a formula(s) on each of the previous sheets (or on this sheet) that will result in this sheet.
[NAME] can be by cell or if using  a range then by rows.  I CANNOT use macros.
Each previous sheet has 6 data cell rows with cells that may or may not be empty.
The first cell in each of the rows that have any data at all will always have a value.
Empty rows will NEVER be before rows that contain data.  They'll always be last if there's any at all.
The cell ranges on the Data sheets will always be consistent across sheets(ie. they'll all be A1:D6)
There's no calculations done on any of the data sheets or on this sheet.  (At least, for the purspose of this problem)
The cell ranges on the Data sheets are only a part of their full sheet but the other information has no influence on this problem.
Assume the Data sheets are being done on a daily basis and the List sheet is the monthly tally if it helps.
The main purpose of this sheet is just to correlate the previous Data sheets into a coherent listing.
Spreadsheet: 138548d1327704962-help-with-nested-ifs-mgd_finals
Sheet: Round 2

 | Team | Bowler | Game 4 | Game 5 | Game 6 | Series
 | 3 | CR Black
 |  | [NAME]
 |  | Team Total
Match 4 |  | Bonus
 |  | Total w/Bonus
 | 6 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus
 | 9 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus
 | 1 | [NAME]
 |  | [NAME]
 |  | Team Total
Match 5 |  | Bonus
 |  | Total w/Bonus
 | 4 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus
 | 7 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus
 | 2 | Damon Peratt
 |  | [NAME]
 |  | Team Total
Match 6 |  | Bonus
 |  | Total w/Bonus
 | 6 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus
 | 8 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus