tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 834894d1688137737-need-some-help-with-index-match-functions-for-single-criteria-lookup-sample
Sheet: Sheet1

ID | Chemical Name
Blk1 | Iron |  |  |  |  |  |  |  |  |  | filter for "x"
Blk1 | Copper |  |  | Sample1 |  |  |  |  |  |  | sample
Blk2 | Mangesium |  |  | Sample1
Unknown3 | Mangesium |  |  | Sample1
sample1 | Iron |  |  | Sample1
Sample1 | Copper |  |  | Sample1
Sample1 | Mangesium |  |  | Sample1
Sample1 | Bromide |  |  | Sample2
Sample1 | Chloride |  |  | Sample2
Sample1 | Arsenic |  |  | Sample2
Sample1 | Lead |  |  | Sample2
Sample2 | Iron |  |  | Sample2
Sample2 | Copper |  |  | Sample2
Sample2 | Mangesium |  |  | Sample2
Sample2 | Bromide
Sample2 | Chloride
Sample2 | Arsenic
Sample2 | Lead
Spreadsheet: 114132d1309966527-excel-2007-summing-rows-if-data-in-column-a-matches-may-2009-dt
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer |  |  |  |  |  | Retail
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan - June 2011 |  |  | Sept 10 - June 11 |  |  | Jan - June 2011 |  |  | Sept 10 - June 11
Item # | Item Description | Cat 1 | Cat 2 | Cat 3 | 1900-01-04 00:00:00 | Item Type | Disco |  | Category Codes | Dealer Sell Price | Min Order QTY | Quantity    On Hand | Inventory Value | Orders | Pieces | $ | Orders | Pieces | $ | Orders | Pieces | $ | Orders | Pieces | $ | Orders | Pieces | $ | Orders | Pieces | $
6 | [NAME] SET | MKT |  | 611 |  | F | N |  |  | 48.45 | 0 | 20 | 12 | 0 | 0 | 0 | 0 | 0 | 0
41 | PINK RIBBON [NAME] | MKT | LAD |  |  | F | N |  |  | 8.95 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 2503 | 201.85
41 | PERSONALIZED PINK RIBBON | MKT | LAD |  |  | C | N |  |  | 8.95 | 0 | 0 | 0 | 0 | 0 | 0 | 32 | 1709 | 195.55
44 | PERFORMANCE FLEX FIT CAP | CAP | MKT | 211 |  | F | N |  |  | 5.95 | 0 | 0 | 0 | 104 | 734 | 43.3 | 14 | 734 | 47.3
995 | SPRING BUNDLE #2 | KIT |  | 211 |  | F | N |  | KITSTEVWG | 22 | 0 | 0 | 0 | 7 | 24 | 52 | 7 | 24 | 528
997 | SPRING BUNDLE #1 | KIT |  | 211 |  | F | N |  |  | 25 | 0 | 0 | 0 | 9 | 20 | 50 | 9 | 20 | 500
999 | VALENTINE DAY BUNDLE | KIT |  | 111 |  | F | N |  |  | 19.95 | 0 | 0 | 0 | 20 | 74 | 14.3 | 20 | 74 | 16.3
2222 | GTI RUBBER LOOP KEYCHAIN | LIF |  |  |  | F | N |  |  | 3.25 | 0 | 0 | 0 | 1 | 1 | 3.25 | 1 | 1 | 3.25
3400 | NAVY MESH BACK CAP | CAP |  |  |  | F | N |  |  | 5 | 576 | 0 | 0 | 0 | 0 | 0 | 14 | 51 | 250
3415 | NAVY CAP |  |  |  |  | C | N |  | DPEIWH | 7.95 | 36 | 0 | 0 | 0 | 0 | 0 | 6 | 234 | 1860.3
3415 | NAVY CAP | CAP |  |  |  | F | N |  | HATLHEMHESTE | 3.75 | 1008 | 2237 | 83.75 | 167 | 1437 | 53.13 | 293 | 3064 | 452.18
3416 | BLACK CAP | CAP |  |  |  | F | N |  | HATLHEMHESTE | 3.75 | 1008 | 2537 | 95.75 | 215 | 815 | 75.63 | 364 | 3230 | 461.88
3416 | BLACK CAP |  |  |  |  | C | N |  | DPEIWH | 7.95 | 36 | 0 | 0 | 1 | 100 | 79 | 1 | 100 | 95
3500 | PINK PICCOLO COOLER TOTE | BAG |  |  |  | F | N |  | EOEESSGRNLAD | 8.95 | 25 | 54 | 483.3 | 127 | 254 | 22.55 | 185 | 360 | 59.35
3501 | BLACK PICCOLO COOLER TOTE | BAG |  |  |  | F | N |  | CCEEOEESSGRN | 8.95 | 25 | 31 | 277.45 | 84 | 162 | 14.05 | 130 | 240 | 3.25
3502 | GREEN PICCOLO COOLER TOTE | BAG |  |  |  | F | N |  | GRNLADVBAVWG | 8.95 | 25 | 101 | 90.95 | 89 | 149 | 13.6 | 130 | 210 | 52.65
Spreadsheet: a8e532a1-f72c-4452-87e1-2c88efa66ff6
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5207 | 30796 | [NAME] | Cooke | GBR | 0 | 00:28:04 | 00:02:07 | 01:40:32 | 00:01:41 | 00:42:00 | 1 | 02:54:24
5207 | 30672 | [NAME] | Goddard | GBR | 0 | 00:00:00 | 00:00:00 | 01:41:11 | 00:02:35 | 00:38:46 | 2 | 02:57:11
5207 | 30318 | Rafael | Lopez Ordoñez | ESP | 0 | 00:33:41 | 00:03:27 | 01:40:42 | [NAME] | 00:36:39 | 3 | [NAME]
5207 | 30387 | [NAME] | Wiegman | NED | 0 | [NAME] | 00:02:53 | 01:47:21 | 00:03:58 | 00:38:16 | 4 | 03:00:20
Spreadsheet: 287690d1388942669-creating-a-specific-list-from-large-data-set-loan-payments
Sheet: Check

Date | 2013-12-25 00:00:00
 |  |  | Last pymt | Last pymt btwn?
Spreadsheet: 964fd814-35a9-4522-9d5c-0e9d144adfec
Sheet: Sheet1

CSI kWh Calculations for Future Load Growth | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  |  |  |  | Annual kWh usage before remodel | =
CSI Application Number |  |  |  |  |  |  | Total Additional kWh per year | = | 0
Host Customer Name |  |  |  |  |  |  | Annual kWh w/Additions | = | 0
Address |  |  |  |  |  |  | Estimated Annual Production (EPBB) | =
 |  |  |  |  |  |  | Applicant Notes:
[NAME] | Amps*Volts=Watts |  | 1000 Watts=1kW |  | 1HP=0.75kW
 | Tonnage is OK for Air Conditioning
 | Horsepower is OK for Pumps
ADDITIONAL Appliances and Usage ONLY
Equipment Description/ Make/Model# |  |  | Hours Used per Week (Include Weekends) |  |  |  | Total  kWh/year |  | Adjustments  (for office use)
 | Qty | Watts per Appliance | Winter | Spring | Summer | Fall
 |  |  |  |  |  |  | 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
Notes:
*Ratings may be found on appliance label or via Energy Star website.  If not found on label, must use Energy Star Ratings (more conservative) values.
For Utility Use Only
Reviewed by:
Approved? |  | Yes |  | No
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: Methanol

Raw Material |  | Methanol
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 84254.976
2023-10-18 00:00:00 |  |  |  |  | 22785
2023-12-05 00:00:00 |  |  |  |  | 61310
2024-01-27 00:00:00 |  | 10 | 160 |  |  |  | Bilty # 4273, Lahore
2024-02-01 00:00:00 |  |  |  |  | 800 |  | SRN # 7602
2024-02-15 00:00:00 | [NAME] |  |  |  | 170 |  | SRN # 7603
Total
Spreadsheet: mary_fischer__25723__1572 MTM Summary
Sheet: June

EES Energy Asset Mgmt
MTM Summary
Company 1572
 |  |  |  | Beginning |  |  |  | Ending
Date |  | Account MSA/SAP |  | Balance |  | Change |  | Balance
 |  | 2106-0000 Asset-C |  | 0 |  |  |  | 0
 |  | 3030-0000 Liab-C |  | 0 |  |  |  | 0
 |  | 2510-0200 Prudency |  | 0 |  |  |  | 0
 |  | 2510-0300 Prudency |  | 0 |  |  |  | 0
 |  | 2510-0100 Credit Reserve |  | 0 |  | 0 |  | 0
 |  | 2510-0000 Asset-NC |  | 0 |  |  |  | 218413044
 |  | 3310-0000 Liab-NC |  | 0 |  |  |  | 0
 |  | 2003-2500 Liquidation |  | 0 |  |  |  | 0
 |  |  |  |  |  | Ending
Date |  | Account |  |  |  | Balance
 |  | Recorded on company 890 |  |  |  | -171865699
 |  | Recorded on company 20Q |  |  |  | -25414240
 |  | Recorded on company 20R |  |  |  | -56249878
 |  | Reclass to N/R (need to talk to [NAME] about) |  |  |  | 35116773
 |  | Difference
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 8a

Product1 | Cleared2 | Uncleared | TOTAL
Basis | 7 | 69 | 76
Cap/Floor | - | 208 | 208
Debt Option | - | - | -
Exotic | - | - | -
Fixed-Fixed | - | 33 | 33
Fixed-Float | 11283 | 2842 | 14125
FRA | 26 | 184 | 210
Inflation | - | 194 | 194
OIS | 38 | 192 | 230
Swaption | - | 1045 | 1045
TOTAL | 11354 | 4767 | 16121
Spreadsheet: 65178d1265895404-print-range-of-cells-factory-kpis-2010-2011new
Sheet: CNC Rolling Average

Weeks |  | CNC Routed Mins | (H) to (Min) Converter |  | Available Hours | Available Minutes
1 | 03.05.10 | 0 |  |  |  | 0 |  | * denotes an input cell
2 | 10.05.10 | 0 |  |  |  | 0
3 | 17.05.10 | 0 |  |  |  | 0 |  | CNC Rolling Average
4 | 24.05.10 | 0 |  |  |  | 0
5 | 31.05.10 | 0 |  |  |  | 0
6 | 07.06.10 | 0 |  |  |  | 0 |  | % Uptime | #N/A |  |  |  |  |  | Total Hours Worked: |  | 0
7 | 14.06.10 | 0 |  |  |  | 0 |  | % Downtime | #N/A |  |  |  |  |  | Total Available Hours: |  | 0
8 | 21.06.10 | 0 |  |  |  | 0
9 | 28.06.10 | 0 |  |  |  | 0
10 | 05.07.10 | 0 |  |  |  | 0
11 | 12.07.10 | 0 |  |  |  | 0
12 | 19.07.10 | 0 |  |  |  | 0
13 | 26.07.10 | 0 |  |  |  | 0
14 | 02.08.10 | 0 |  |  |  | 0
15 | 09.08.10 | 0 |  |  |  | 0
16 | 16.08.10 | 0 |  |  |  | 0
17 | 23.08.10 | 0 |  |  |  | 0
18 | 30.08.10 | 0 |  |  |  | 0
19 | 06.09.10 | 0 |  |  |  | 0
20 | 13.09.10 | 0 |  |  |  | 0
21 | 20.09.10 | 0 |  |  |  | 0
22 | 27.09.10 | 0 |  |  |  | 0
23 | 04.10.10 | 0 |  |  |  | 0
24 | 11.10.10 | 0 |  |  |  | 0
25 | 18.10.10 | 0 |  |  |  | 0
26 | 25.10.10 | 0 |  |  |  | 0
27 | 01.11.10 | 0 |  |  |  | 0
28 | 08.11.10 | 0 |  |  |  | 0
29 | 15.11.10 | 0 |  |  |  | 0
30 | 22.11.10 | 0 |  |  |  | 0
31 | 29.11.10 | 0 |  |  |  | 0
32 | 06.12.10 | 0 |  |  |  | 0
33 | 13.12.10 | 0 |  |  |  | 0
34 | 20.12.10 | 0 |  |  |  | 0
35 | 27.12.10 | 0 |  |  |  | 0
36 | 03.01.11 | 0 |  |  |  | 0
37 | 10.01.11 | 0 |  |  |  | 0
38 | 17.01.11 | 0 |  |  |  | 0
39 | 24.01.11 | 0 |  |  |  | 0
40 | 31.01.11 | 0 |  |  |  | 0
41 | 07.02.11 | 0 |  |  |  | 0
42 | 14.02.11 | 0 |  |  |  | 0
43 | 21.02.11 | 0 |  |  |  | 0
44 | 28.02.11 | 0 |  |  |  | 0
45 | 07.03.11 | 0 |  |  |  | 0
46 | 14.03.11 | 0 |  |  |  | 0
47 | 21.03.11 | 0 |  |  |  | 0
48 | 28.03.11 | 0 |  |  |  | 0
49 | 04.04.11 | 0 |  |  |  | 0
50 | 11.04.11 | 0 |  |  |  | 0
51 | 18.04.11 | 0 |  |  |  | 0
52 | 25.04.11 | 0 |  |  |  | 0
 |  | Total | 0 |  | 0
Spreadsheet: 865274d1712319087-countif-and-conditional-formatting-workdays-mounir75-
Sheet: Sheet1

 |  |  |  |  |  | only count AG5:AG12 that equals 14 if cells from B5:AF5 contains Y or Z or T or S
 |  |  |  | highlight cells from B5:AF5 if it contains Y or Z or T or S and cells AG5:AG12 equals 14
April | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Work Days
 | 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
Name | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | Y
Name | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Name | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Name | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Name | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Name | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Name | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Name | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Spreadsheet: 812421d1673130264-hour-minute-conversion-s666-pq-hour-minute-conversion
Sheet: Sheet1

src |  | src | Total Hours
5 hours 28 mins |  | 5 hours 28 mins | 5.47
19 mins |  | 19 mins | 0.32
23 mins |  | 23 mins | 0.38
25 mins |  | 25 mins | 0.42
39 mins |  | 39 mins | 0.65
19 mins |  | 19 mins | 0.32
19 mins |  | 19 mins | 0.32
1 hour 20 mins |  | 1 hour 20 mins | 1.33
1 hour 41 mins |  | 1 hour 41 mins | 1.68
18 mins |  | 18 mins | 0.3
1 hour 39 mins |  | 1 hour 39 mins | 1.65
1 hour 29 mins |  | 1 hour 29 mins | 1.48
38 mins |  | 38 mins | 0.63
Spreadsheet: michelle_lokay__26631__imbalsumm0102
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 33193 | 30049 | 10503 | 10000 | 23795 | 25000
2 | 33037 | 33666 | 10371 | 10000 | 24097 | 25000
3 | 32947 | 33000 | 10032 | 10000 | 24103 | 24718
4 | 32790 | 33000 | 10136 | 10000 | 23821 | 24718 | 212
5 | 32630 | 33000 | 10383 | 10000 | 24847 | 24718
6 | 32514 | 33000 | 10151 | 10000 | 24836 | 25666
7 | 32413 | 33000 | 8698 | 10000 | 24612 | 25666
8 | 32007 | 33000 | 9376 | 10000 | 24321 | 25666
9 | 32107 | 33000 | 9984 | 10000 | 23481 | 25666
10 | 32027 | 33000 | 10120 | 10000 | 24602 | 25666
11 | 31888 | 33000 | 10053 | 10000 | 23838 | 25666
12 | 31809 | 33000 | 10157 | 10000 | 24848 | 25666
13 | 31071 | 33000 | 10407 | 10000 | 24581 | 25666
14 | 31384 | 33000 | 10166 | 10000 | 24323 | 25666
15 | 31242 | 29441 | 9578 | 10000 | 24544 | 25666
16 | 31111 | 33000 | 9907 | 10000 | 24021 | 25666
17 | 30969 | 32000 | 10154 | 10000 | 23772 | 23666
18 | 30822 | 32000 | 9731 | 10000 | 24675 | 23666
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00 |  |  |  |  |  |  |  |  | -341459.71
2001-02-18 00:00:00
 |  |  | 516.78
 |  |  | 212.08
 |  |  | 58.33
 |  |  | 25
Spreadsheet: phillip_allen__29449__lakeside villas_proforma_gthorse
Sheet: Sheet1

Project | Lakeside Villa
Asking Price | 14500000 |  |  | Estimate of Income
Existing Debt |  | 0.8
Year Built | 1985
Age |  |  |  |  | No. Of | Living Area | % Of | % Type |  |  | Rent ($) | Total Rentable | Unit Rent | Total Monthly
Units | 292 |  |  | Unit Type | Living Units | (Sq. Ft.) | Unit Mix | By Bed | Composition of Units |  | Per Sq. Ft. | Sq. Ft. | Per Mo. ($) | Unit Rent ($)
[NAME]. Ft.
 | Annual | Per Unit | Per Foot | 1-1 | 20 | 574 |  |  |  |  |  |  | 595
Gross Income |  |  |  | 1-1 | 20 | 701 |  |  |  |  |  |  | 650
Vacancy and Lease Loss (5%) |  |  |  | 1-1 | 92 | 819 |  |  |  |  |  |  | 695
Net Collected Income |  |  |  | 1-1 | 32 | 851 |  |  |  |  |  |  | 740
Other Income |  |  |  | 1-1 | 24 | 887 |  |  |  |  |  |  | 735
Total Income |  |  |  | 1-1 den | 16 | 1073 |  |  |  |  |  |  | 860
Expenses |  |  |  | 2-1 den | 28 | 1104 |  |  |  |  |  |  | 915
Net Operating Income |  |  |  | 2-1 | 20 | 1144 |  |  |  |  |  |  | 880
Debt Service Estimate |  |  |  | 2-2 | 40 | 1211 |  |  |  |  |  |  | 935
Cash Flow
Tot. Cost Per Gross Unit |  |  |  |  |  |  |  |  |  | Monthly Rentals for All Living Units
Tot. Cost Per Rentable Sq. Ft.
 |  |  |  | Other Income (Not Included in Rent)
Debt |  |  |  | Open Park | 0 | @ $ | 0 |  | per month =
Equity |  |  |  | Garages | 0 | @ $ | 0 |  | per month = |  | Detached Garage Rent
Interest Rate With MIP/Constant |  |  |  | Carport | 0 | @ $ | 0 |  | per month = |  | Carport Charge
Amort. Term. |  | 25 | year | Other |  | @ $ | 20 |  | per month = |  | Cable TV/Phone/Laundry
 |  |  |  |  |  |  |  |  |  | Total Ancillary Income
 |  |  |  |  | Revenue Growth |  | 0.02
 |  |  |  |  | Expense Growth |  | 0.02 |  |  | Total Monthly Gross Income
 | Year 1 |  | Year 2 |  | Year 3 |  | Year 4 |  | Year 5 |  | Year 6 |  | Year 7
Gross Rental Income
Vacancy/Lease Loss |  | -0.07
Other Income
Total Income
Personnel | 240000
Marketing | 100000
Maint./Repair | 167000
Utilities | 120000
Administrative | 50000
Management Fee (3%)
Insurance | 40000
Tax | 400000
Replacement Reserve | 75000
Total Expense
Net Operating Income
Capital Requirements | 0
Debt Service
Refinance Proceeds
Cash Flow
Project Capitalization Rate
Project Cash On Cash
Sales Value Cap. NOI |  | 0.09 |  | 0.09 |  | 0.09 |  | 0.09 |  | 0.09 |  | 0.09 |  | 0.09
 | Annual Cash | ROI % | Cum ROI % |  | IRR
Investment Yr. 0 |  | 0 |  |  | NPV
Year 1 |  |  |  |  | GRM
Year 2 |  |  |  |  | [NAME]. [NAME]. 1
Year 3
Year 4 |  |  |  |  | Refinance | Year 2
Year 5 |  |  |  |  | Value
Year 6 |  |  |  |  | Percent | 0.8
Year 7 |  |  |  |  | Rate Constant | 0.0775
 |  |  |  |  | Amort. Term | 30
 |  |  |  |  | New Debt
Total Net Cash Receipts
Internal Rate Of Return
 | Sale Value | Purchase | App. Per Yr. |  | Economic Life | 60
 |  |  |  |  | Age
Value Per Unit |  |  |  |  | Todays = Value
Value Per Foot |  |  |  |  | Sale Year Value
Spreadsheet: 749703d1632974203-ranking-without-duplicates-using-3-criteria-ranking-without-duplicates-using-3-criteria
Sheet: Tab1

Name | Games Correct | Margin Difference | Log points | Log Position | Actual Ranking | Hash Total | Rank
Player 1 | 6 | 92 | 6.5 |  | 27
Player 2 | 6 | 76 | 9 |  | 7 |  |  |  | Ranking by
Player 3 | 3 | 123 | 4.5 |  | 35 |  |  |  | 1) Log Points - highest to lowest
Player 4 | 5 | 86 | 7.5 |  | 20 |  |  |  | 2) Games Correct - highest to lowest
Player 5 | 6 | 81 | 8 |  | 14 |  |  |  | 3) Margin Difference - lowest to highest
Player 6 | 6 | 94 | 9 |  | 8
Player 7 | 6 | 74 | 7 |  | 23 |  |  |  | Last part of formula added as a tiebreaker
Player 8 | 6 | 94 | 8.5 |  | 10 |  |  |  | if all 3 criteria above are the same.
Player 9 | 6 | 82 | 8 |  | 15
Player 10 | 5 | 91 | 7.5 |  | 21
Player 11 | 5 | 137 | 5.5 |  | 32 |  |  |  | https://www.excelforum.com/newreply.php?do=postreply&t=1360345
Player 12 | 7 | 62 | 10.5 |  | 2
Player 13 | 7 | 74 | 9 |  | 6
Player 14 | 7 | 42 | 10 |  | 3
Player 15 | 8 | 53 | 11 |  | 1
Player 16 | 4 | 96 | 5.5 |  | 33
Player 17 | 6 | 89 | 8 |  | 18
Player 18 | 3 | 116 | 3 |  | 36
Player 19 | 6 | 99 | 8.5 |  | 11
Player 20 | 6 | 52 | 8.5 |  | 9
Player 21 | 6 | 74 | 7 |  | 23
Player 22 | 4 | 114 | 5.5 |  | 34
Player 23 | 7 | 80 | 8 |  | 12
Player 24 | 6 | 61 | 8 |  | 13
Player 25 | 6 | 99 | 7 |  | 25
Player 26 | 5 | 85 | 6 |  | 30
Player 27 | 3 | 114 | 6 |  | 31
Player 28 | 5 | 98 | 7 |  | 26
Player 29 | 6 | 81 | 7.5 |  | 19
Player 30 | 7 | 79 | 9.5 |  | 5
Player 31 | 5 | 93 | 7.5 |  | 22
Player 32 | 5 | 74 | 6.5 |  | 28
Player 33 | 7 | 65 | 10 |  | 4
Player 34 | 6 | 75 | 8 |  | 17
Player 35 | 5 | 85 | 6.5 |  | 29
Player 36 | 3 | 163 | 3 |  | 37
Player 37 | 6 | 83 | 8 |  | 16
Spreadsheet: 168758d1342561587-arranging-information-into-tables-example
Sheet: Sheet1

"Helper" | Unit/Process | Rating |  |  | A | B | C | D
 | Inlet works | A |  | 1
 | [NAME] | A
 | Grit removal | B
 | Quality of grit | B
 | Flow | C
 | Sampling | D
 | Channels | D
Spreadsheet: 4793e94d-1f03-4f4b-96bd-ad5cf2777016
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Project: | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Owner:
 |  | Date:
 |  | Contact:
Section | Component | Size/Notes | Weight | Range | Price | Notes
Frame | Frame |  | 0 | 0 | 0
 | Cable guides
 | Barrel adjusters
Headset | Headset
 | Expander
 | [NAME]
 | [NAME]
 | Spacers
Fork | Fork
Cranks | Arms
 | BB
 | [NAME]
 | Mid chainring
 | Sm Chainring
 | Chainring bolts
Derailleurs | Front
 | Rear
 | Clamp adapter
Chain | Chain
Cassette | Cassette
 | Lockring
Wheels | Frt hub
 | Frt rim
 | Rear hub
 | Rear rim
 | spokes front
 | spokes rear |  |  |  |  | [NAME] or Aerolite, 4.54gr each avg with nipple.  44spokes&nips=200gr
 | nipples front
 | nipples rear
 | skewers
 | rims strips/glue
Pedals | Pedals
Brakes | Front
 | Pad holders
 | Front pads
 | Rear
 | Pad holders
 | Rear pads
levers | shft lever
 | brk lever
Handlebars | Bars
 | Bar tape/Grips
 | Bar end plugs
Stem | Stem
Seating | Saddle
 | Seatpost
 | Seat collar
cab/hous | Brake cables
 | Brake housing
 | Shift cables
 | Shift housing
Tires | [NAME] tire
 | Rear tire
 | Tube front
 | Tube rear
 | valve extender
Misc | Bottle cage 1
 | Bottle cage 2
 | Cage bolts 1
 | Cage bolts 2
 | Computer head
 | computer mount
Di2 extras | Battery
 | Wire kit frt
 | Wire kit rear
[NAME] extra |  | grease and such averaged | 22 | 4
Total in grams |  |  | 22 | 4 | 0
Total in pounds |  |  | 0.04850173724404311
Total low range |  |  |  | 18
Total low, lbs |  |  |  | 0.03968341453735753
Enter high stock weight in weight column and low est weight or tuned weight in range column.  Yellow total = high weight, Green totals = low weight.  Do not enter info in colored cells.
Spreadsheet: 129132d1321463658-vlookup-over-multiple-sheets-2011-barter-and-trade-test
Sheet: March

Customer | Net | [NAME] | Size | Rep
Another Broken Egg Cafe | 1 | 1 | 1/3 Page Square | [NAME]
[NAME]'s Bakery | 2 | 2 | 1/3 Page Square | [NAME]
Spectrum Resorts/See Beach Club | 3 | 3 | 1/2 Page | [NAME]
Central Alabama Walk for Epilepsy | 4 | 4 | 1/6 Page | [NAME]
California Pizza Kitchen | 5 | 5 | 1/2 Page | [NAME]
[NAME] Center | 6 | 6 | 1/3 Page Vertical | [NAME]
Watercolor Inn & Resort | 7 | 7 | 1/2 Page | [NAME]
McWane Science Center | 8 | 8 | 1/2 Page | [NAME]
Alabama Public Television | 9 | 9 | 1/3 Page Square | [NAME]
Books A Million | 10 | 10 | 1/3 Page Vertical | [NAME]
JAMM Entertainment Services | 11 | 11 | 1/3 Page Square | [NAME]
Al.com | 12 | 12 | 2/3 Page | [NAME]
Digital Signage 3 | 13 | 13 | 1/3 Page Square | [NAME]
[NAME] | 14 | 14 | 1/3 Page Square | [NAME]
Birmingham Mountain Radio | 15 | 15 | [NAME] | [NAME]
Cultural Alliance of Greater Birmingham - Birmingham 365 | 16 | 16 | [NAME] | [NAME]
Greater [NAME] Society | 17 | 17 | [NAME] | [NAME]
The Birmingham News | 18 | 18 | [NAME] | [NAME]
New South Research Inc | 19 | 19 | [NAME] | [NAME]
Zoom Motor Sports c/o Bruno Event Team | 20 | 20 | [NAME] | [NAME]
Spreadsheet: 2f076e3b-4128-478c-93ad-70535e4d27f0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | U.S. EXPORTS OF RAISINS
 | Marketing Year (August/July) 1998/99 - 2000/01
 | and 2000/01-2001/02 August/March Comparisons
 |  |  | ([NAME] )
 | Destination | 1998/99 | 1999/00 | 2000/1 | August/March  2000/01 | August/March  2001/02 | Percent Changed
 | North America
 | Canada | 12121 | 10721.9 | 11792.9 | 8257.4 | 8121.2 | -0.0165
 | Mexico | 896 | 1172.6 | 629.5 | 578.8 | 270 | -0.5335176226675881
 | Subtotal | 13017 | 11894.5 | 12422.4 | 8836.199999999999 | 8391.2 | -0.05036101491591388
 | European Union
 | Sweden | 4367.9 | 3526.9 | 4805.1 | 3492.9 | 3236.1 | -0.07352057029975097
 | Finland | 2270 | 1725 | 1614.2 | 1317.7 | 1371.4 | 0.04075282689534799
 | Denmark | 5148.1 | 3176.6 | 3852 | 2749.6 | 2052.3 | -0.2536005237125399
 | United Kingdom | 22195.1 | 11515.6 | 24101.2 | 15901 | 16457.2 | 0.03497893214263258
 | Netherlands | 3471.1 | 2811.8 | 5551.2 | 4037.5 | 2852.9 | -0.2933993808049535
 | France | 669 | 624.7 | 274.8 | 161 | 275.6 | 0.711801242236025
 | Germany | 5091.6 | 3279.8 | 7095.3 | 4418.4 | 4259.5 | -0.03596324461343465
 | Spain | 586.8 | 499 | 504.6 | 294.1 | 572.3 | 0.945936756205372
 | Belgium-Lux. | 926.3 | 691.3 | 888.7 | 593.6 | 631.1 | 0.06317385444743935
 | Italy | 220.5 | 116.9 | 320.1 | 278.4 | 56.8 | -0.7959770114942528
 | Ireland | 110.1 | 74.8 | 71.7 | 46.9 | 46.1 | -0.01705756929637521
 | Subtotal | 45056.5 | 28042.4 | 49078.89999999999 | 33291.1 | 31811.3 | -0.04445031855360751
 | Asia
 | Singapore | 2775.6 | 2161.6 | 2025.3 | 1470 | 1285.2 | -0.1257142857142857
 | Malaysia | 686 | 576.5 | 907 | 476.3 | 1209.3 | 1.538946042410246
 | Korea, Republic of | 1654 | 1122.4 | 2303.6 | 1723.4 | 1998.6 | 0.1596843448996169
 | Hong Kong | 1762.9 | 1368.1 | 2436.4 | 1955.7 | 2022.4 | 0.0341054353939766
 | Taiwan | 3886.5 | 2638.6 | 3834.7 | 2772.4 | 2786.3 | 0.005013706535853445
 | Japan | 30014.3 | 22759.7 | 22840 | 15058.6 | 15131.5 | 0.004841087484892329
 | Subtotal | 40779.3 | 30626.9 | 34347 | 23456.4 | 24433.3 | 0.04164748213707124
 | Other Countries
 | New Zealand | 1312.2 | 1003.2 | 1318.5 | 928.6 | 724.1 | -0.2202239931079044
 | Norway | 2309.4 | 2045.4 | 2383.7 | 1730.1 | 1616.8 | -0.06548754407259694
 | All Others | 8117 | 6383 | 9504 | 6632 | 8950 | 0.3495174909529554
 | Grand Total | 110591.3 | 79994.8 | 109054.9 | 74873.6 | 75927.1 | 0.01407037994700402
 | Others | 102474.4 | 73612.39999999998 | 99550.49999999999 | 68242.40000000001 | 66976.7