tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 744710d1629387585-need-help-averaging-the-lowest-16-scores-out-of-20-while-discarding-an-entry-of-0-zero-scoresheet-for-excel-forum_2
Sheet: Summary Sheet

Table 1
 | 2021-05-11 00:00:00 |  | 2021-05-18 00:00:00 |  | 2021-05-25 00:00:00 |  | 2021-06-01 00:00:00 |  | 2021-06-08 00:00:00 |  | 2021-06-15 00:00:00 |  | 2021-06-22 00:00:00 |  | 2021-06-29 00:00:00 |  | 2021-07-06 00:00:00 |  | 2021-07-13 00:00:00 |  | 2021-07-20 00:00:00 |  | 2021-07-27 00:00:00 |  | 2021-08-03 00:00:00 |  | 2021-08-10 00:00:00 |  | 2021-08-17 00:00:00 |  | 2021-08-24 00:00:00 |  | 2021-08-31 00:00:00 |  | 2021-09-07 00:00:00 |  | 2021-09-14 00:00:00 |  | 2021-09-21 00:00:00 |  | # of "0" Putts (Chip Ins) | Birdies | Pars | Avg. Score | Avg. Putts | Total # of strokes for the year | Total # of Putts for the year | Lowest Score for one game | Highest Score for one game | Lowest # of Putts for one game | Highest # of Putts for one game | Diff between 1st game & ending avg. | Games played
 | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts | Score | Putts
[NAME]
[NAME]
[NAME]
Barb Buschle
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Lois Holt
[NAME]
[NAME]
Doña Neiheisel
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 167540d1342020867-excel-2003-tranposing-and-summing-cells-by-month-name-and-changing-name-formatting-excel-cell-transpose-and-name-change
Sheet: What I want it to look like

Name | Month | [NAME]
[NAME] | JAN 2011 | 78.6
[NAME] | FEB 2011 | 126.4
[NAME] | MAR 2011 | 193.9
[NAME] | APR 2011 | 149.3
[NAME] | MAY 2011 | 148.9
[NAME] | JUN 2011 | 158.9
[NAME] | JUL 2011 | 132.5
[NAME] | AUG 2011 | 167.8
[NAME] | SEP 2011 | 118.3
[NAME] | OCT 2011 | 148.5
[NAME] | NOV 2011 | 162.5
[NAME] | DEC 2011 | 138.2
[NAME] | YTD | 1723.8
Spreadsheet: 12ee045c-98ca-4278-a5d0-fdee57393d7f
Sheet: ClassificationDescr

Site Classification | Classification Description
10 | [NAME] (PK-6)
20 | Middle School (5-8)
31 | Junior High (7-8 or 7-9)
32 | Senior High (9-12)
33 | Secondary (7-12)
40 | Elem/Sec Combo (K-12)
41 | ALC
42 | ALP
43 | Private Alternative Program
44 | Reserved
45 | Targeted Services
46 | Distance Learning Program (state approved)
50 | Special Education
51 | Special Education  ESY (Extended School Year)
55 | Combined Spec Ed & Voc Ed Program
60 | Secondary Vocational Program
70 | Delinquent Student/Correctional Program
71 | Miscellaneous Program (assignment is now limited)
72 | Neglected Student Program, Title 1
73 | Homeless Student Program, Title 1
74 | Hospital/Medical/Partial Hospitalization Program
75 | Telecommuncations District
76 | Educational Oversight to Private Residential Care & Treatment
77 | Educational Oversight to Public Residential Care & Treatment
78 | Educational Oversight to Private Day Treatment Program
79 | Educational Oversight to Public Day Treatment Program
80 | Technical Colleges (PSEO)
81 | Post Secondary School/Program
82 | Communty & Adult Education Program
83 | Early Childhood Screening
90 | Administrative Program
Spreadsheet: 875683d1722297890-weather-data-report-help-consolidated-chester-county-weather-sample-2-
Sheet: Today's Record

 | Period | Input |  |  | high | low | Avg. Temp | precip | snow | Sn cover
 | Year | 2024 |  | ATGLEN | 34.5 | 31.4 | 32.95 | 0 | 0 | 0
 | Month | January |  | CHESTER SPRINGS | 35.9 | 31.6 | 33.75 | 0 | 0 | 0 |  | With Year in C3, Month in C4 and Day in C5,
 | Day | 30 |  | EAST NANTMEAL 1 SSW | 80 | 60 | 70 | 0.8 | 0 | 0 |  | E2: =VSTACK(CHOOSECOLS(Table1[#Headers],1,5,6,7,8,9,10),CHOOSECOLS(FILTER(Table1,(Table1[Year]=C3)*(Table1[Month]=C4)*(Table1[Day]=C5)),1,5,6,7,8,9,10))
 |  |  |  | KMQS (COATESVILLE) AIRPORT | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | WEST GROVE 2S | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | SADSBURYVILLE | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | COATESVILLE 2W | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | GLENMOORE 2SW | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | GLENMOORE | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | MORGANTOWN/ELVERSON | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | [NAME] /ELVERSON | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | KOQN (WEST CHESTER) AIRPORT | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | LONGWOOD GARDENS | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | WEST GROVE | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | NOTTINGHAM | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | WEST CHESTER 2NW | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | WARWICK | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | DEVAULT 1W | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | WESTTOWN | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | KENNETT SQUARE 2S | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | COATESVILLE 1SW | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | KENNETT SQUARE | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | WEST BRADFORD | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | WEST CHESTER 2SE | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | SPRING CITY | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | DOWNINGTOWN 3SE | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | DEVAULT  1SE | 80 | 60 | 70 | 0.8 | 0 | 0
 |  |  |  | PHOENIXVILLE 1E | 80 | 60 | 70 | 0.8 | 0 | 0
Spreadsheet: 65591d1266316320-understanding-how-this-factor-is-calculated-correction
Sheet: temp correction

 | Temp | 17.362
 | Correction
 | Corr. Curve
 | Temp(x) | °C | 34 | 33 | 32 | 31 | 30.5 | 30 | 29 | 28 | 27 | 26 | 25.5 | 25 | 24.5 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9
 | correction(y) |  | 1.06280243421613 | 1.05578615902926 | 1.04845588806701 | 1.031183997383186 | 1.02672070094287 | 1.024371308378185 | 1.018050188986899 | 1.012286214789809 | 1.007537943660338 | 1.003333588006641 | 1.001608009951706 | 1 | 0.9985100709248589 | 0.9971381872245121 | 0.9949642081103467 | 0.9931632199585045 | 0.9920123670164718 | 0.9910714566903372 | 0.9903306406956988 | 0.9897784582534002 | 0.9894019927724257 | 0.989146630000986 | 0.9889225320010581 | 0.9887225282984441 | 0.9885237776015761 | 0.9883113668162781 | 0.988078311045766 | 0.987825553590648 | 0.9875619659489241
Spreadsheet: 486119d1477332753-can-i-average-and-vlookup-vlookup-average
Sheet: 3 Weekly

Name | WK1 | WK2 | WK3 | AVG TIME | Sum | Count | Average | [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Fred
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Sidney
Spreadsheet: 782962d1654471061-film-biz-union-timecard-tc-example
Sheet: WEEK 1

[NAME] (12 HR GUAR) |  |  |  |  |  | [NAME]: | 65 | 1.5x: |  | 2.0x: |  |  | WEEK END | 2022-06-11 00:00:00
 |  |  |  |  |  | MP 1: | 7.5 | MP 2: | 10 | MP 3: | 12.5
DAYS |  | HOURS |  |  |  |  |  | RATE CALCULATIONS |  |  |  |  | DAILY ADJUSTMENTS
DATE | DAY | CALL | 1st MEAL |  | 2nd MEAL |  | WRAP | BREAK DOWN |  |  | MEAL PENALTIES |  | HOURS | AMOUNT | DAY | 6th & 7th ADJ
 |  |  | OUT | IN | OUT | IN |  | 1X | 1.5X | 2X | MP1 | MP2 |  |  |  | 6th | 7th | IDLE
2022-06-05 00:00:00 | S |  |  |  |  |  |  |  |  |  |  |  |  |  | S
2022-06-06 00:00:00 | M |  |  |  |  |  |  |  |  |  |  |  |  |  | M
2022-06-07 00:00:00 | T | 8 |  |  |  |  | 16 |  |  |  |  |  |  |  | T
2022-06-08 00:00:00 | W | 7 | 13 | 14 |  |  | 20 |  |  |  |  |  |  |  | W | X
2022-06-09 00:00:00 | T | 7 | 13 | 14 |  |  | 21 |  |  |  |  |  |  |  | T
2022-06-10 00:00:00 | F | 7 | 13 | 14 |  |  | 21 |  |  |  |  |  |  |  | F
2022-06-11 00:00:00 | S | 7 | 13.5 | 14 |  |  | 21 |  |  |  |  |  |  |  | S
 |  |  |  |  |  |  |  |  | TOTALS:
 |  | Per Diem: | 125 |  | WRKD HRS:
 |  | Passcard: | 25
 |  | Box: | 0 |  | MPI HRS:
 |  | Additional Fees Accrued
 |  | Test Reimbursement |  |  | 250
 |  |  |  |  |  |  |  |  |  |  | EST CHECK GROSS:
 |  |  |  |  |  |  |  |  |  |  | EST DEDUCTIONS (45%):
 |  |  | Total: |  |  |  |  |  |  |  | EST CHECK NET:
Spreadsheet: 713483d1610732444-count-unique-long-strings-systemids
Sheet: Sheet1

System ID | Needed Results | countif fail
9400111895351822782516 | 1
[PHONE] | 1
9400111895351822780208 | 1
9400111895351822780260 | 1
9400111895351822780239 | 1
9400111895351822780246 | 1
9400111895351822780246 | 0
9400111895351822767612 | 1
9400111895351822768565 | 1
9400111895351822780246 | 1
[PHONE] | 1
9400111895351822766868 | 1
9400111895351822766714 | 1
9400111895351822767377 | 1
9400111895351822767032 | 1
9400111895351822766905 | 1
9400111895351822766769 | 1
[PHONE] | 1
9400111895351822767940 | 1
9400111895351822766783 | 1
9400111895351822767940 | 0
Spreadsheet: 5414f1aa-7d1c-4cfd-ab52-310bf5c9f44f
Sheet: Sheet1

FIFTH THIRD BANCORP | Unnamed: 1 | Unnamed: 2
8-K/A
06/05/2014
OHIO
001-33653 |  | 31-0854434
(Commission |  | (IRS Employer
File Number) |  | Identification No.)
Fifth Third Center |  | 45263
38 Fountain Square Plaza, Cincinnati,
Ohio
(Address of Principal Executive Offices) |  | (Zip Code)
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 680097d1590775320-data-horizontal-to-vertical-with-one-condition-q1
Sheet: Sheet1

 |  | 12345678 | BX12345 | 55667788 | 11332266 | 99114433 |  | 12345678
 |  |  |  |  |  |  |  | 55667788
 |  | x | x | x | n/a |  |  | 11332266
 |  | k |  | x | n/a
 |  | x | k | x | n/a
 |  | n/a |  | x | n/a
 |  | x | n/a | x | k
 |  | x |  | x | x
Spreadsheet: 1e5b4365-85b0-4f77-8d8a-1d39c36d8cb5
Sheet: 14-Gj-Jo

UNIVERSITETI I PRISHTINËS
Nr. 120
Prishtinë , më 18 . 1 . 2012.
 | Komisioni për lirim nga pagesa e semestrit të studentëve të Universitetit të Prishtinës,në mbledhjen e mbajtur më 16.1. 2012, mori
 | V E N D I M
 | Mbi mos lirimin nga pagesa e semestrit për [NAME] 2011/2012
 | [NAME] 2011/2012 [NAME] nga pagesa e semestrit këta studentë nga
 | Fakulteti i Edukimit Gjakovë
Nr. | Emri, emri i prindit dhe mbiemri | Komuna | Kategoria
1 | [NAME] | [NAME] | Prindi i vrarë
2 | [NAME] | Gjakovë | Invalid i luftës
3 | [NAME] | Gjakovë | Invalid i luftës
 | VËREJTJE:
 | Kundër këtij [NAME] të parashtrohet ankesa e argumentuar në afat prej 8 ditësh nga dita e publikimit të këtij vendimi. Ankesa dorëzohet në fakultetin përkatës.
 |  | K O M I S I O N I:
 |  | Prof.Dr.[NAME],kryetar              ________________
 |  | [NAME], anëtar                           ________________
 |  | [NAME], anëtar                         ________________
 |  | [NAME] Samadraxha(MASHT), anëtar ________________
 |  | Fehmi Ibrahimi(MPMS), anëtar          ________________
Spreadsheet: vkaminski__40901__CASH_EPE_0400MyCopy
Sheet: PLRisk

POLITICAL RISK CALCULATION / DEBT SERVICE COVERAGE RATIOS
Current Year
Calendar Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
Months Of Operation - Phase I
Months Of Operation - Phase II
Months Of Operation - Phase III
Total Number Of Months
Political Risk Calculation - Common Equity @ Risk
 | Beginning Balance - Common Equity |  |  | 0
 | Current Year Common Equity Issued
 | Current Year Earnings
 | Current Year Dividends
 | Ending Balance - Common Equity
Political Risk Calculation - Common Equity @ Risk
 | Total Common Equity Balance (BOY)
 | Times: Enron's Ownership %
 | Enron's Common Equity Balance (BOY) |  | a
 | Total Common Equity Balance (EOY)
 | Times: Enron's Ownership %
 | Enron's Common Equity Balance (EOY) |  | b
 | [NAME] (a & b) > 0 |  | c
 | Min Of (a & b) > 0 |  | d
 | Enron Common Equity @ Risk [ (c x 2) + d ] / 3
 | Political Risk Rate
 | Political Risk Insurance - Enron's Common Equity
Political Risk Calculation - Preferred Equity @ Risk
 | Beginning Balance - Preferred Equity |  |  | 0
 | Current Year Preferred Equity Issued
 | Ending Balance - Preferred Equity
Political Risk Calculation - Preferred Equity @ Risk
 | Total Preferred Equity Balance (BOY)
 | Times: Enron's Ownership %
 | Enron's Preferred Equity Balance (BOY) |  | a
 | Total Preferred Equity Balance (EOY)
 | Times: Enron's Ownership %
 | Enron's Preferred Equity Balance (EOY) |  | b
 | [NAME] (a & b) > 0 |  | c
 | Min Of (a & b) > 0 |  | d
 | Enron Preferred Equity @ Risk [ (c x 2) + d ] / 3
 | Political Risk Rate
 | Political Risk Insurance - Enron's Preferred Equity
Political Risk Calculation - Bridge Loan
 | Enron Bridge Loan Balance (BOY) |  | a
 | Enron Bridge Loan Balance (EOY) |  | b
 | [NAME] (a & b) > 0 |  | c
 | Min Of (a & b) > 0 |  | d
 | Enron @ Risk Equity [ (c x 2) + d ] / 3
 | Political Risk Rate
 | Political Risk Insurance - Enron Bridge Loan (Cash Payment)
Political Risk Calculation - Subordinated Debt
 | Enron Subordinated Debt Balance (BOY) |  | a
 | Enron Subordinated Debt Balance (EOY) |  | b
 | [NAME] (a & b) > 0 |  | c
 | Min Of (a & b) > 0 |  | d
 | Enron @ Risk Equity [ (c x 2) + d ] / 3
 | Political Risk Rate
 | Political Risk Insurance - Enron Subordinated Debt (Cash Payment)
Debt Service Coverage Ratios
 | Earnings Before Depr, Int & Taxes (EBDIT)
 | Current Year Debt Service
 | Pre-Tax Debt Coverage Ratio | (EBDIT / Current Year Debt Service)
 | Earnings Before Depr, Int & Taxes (EBDIT)
 | Less: Cash Taxes
 | Earnings Before Depr, Int & Taxes (EBDIT) - Less Cash Taxes
 | Current Year Debt Service
 | After-Tax Debt Coverage Ratio | (EBDIT-AT / Current Year Debt Service)
Spreadsheet: 586881d1534706474-basketball-table-and-best-second-places-womens-eb-qualifier-tables
Sheet: GroupD

GROUP D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS | rank
Team name | Bonus/penalty points
Greece
Great Britain
Israel
Portugal
ROUND 1 |  |  |  |  |  |  | Table
 |  | 61 | : | 59
 |  | 90 | : | 87 |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS
 |  | 81 | : | 59
 |  | 65 | : | 63
 |  |  | :
 |  |  | :
ROUND 2
 |  |  | :
 |  | 74 | : | 76
 |  | 60 | : | 66
 |  |  | :
 |  | 59 | : | 56
 |  | 56 | : | 64
ROUND 3
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
ROUND 4
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
Spreadsheet: 212290d1360085288-create-a-sub-list-into-another-sheet-based-on-multiple-criteria-ef350_copy_data_2_criteria
Sheet: Listing

Code 1 | 3A
Code 2 | AC
[NAME] | Location | Prod Code | Product | Qty
Spreadsheet: 758776d1639061221-if-statement-with-three-criteria-sample-file-excelforum
Sheet: LISTS

Doable Trade | Length | PMC | SPREAD | BIAS | TYPE | PRICE IMPACT | OPENING SIDE | ACTION | STATUS | Results
Valid | Long | Right | Back Ratio | Bearish | Call | Debit | Buy | Open | Open | Win
Invalid | Short | Wrong | Butterfly | Bullish | Put | Credit | Sell | Close | Closed | Loss
 | Neutral |  | Calendar | Neutral | Both |  |  |  | Roll
 |  |  | Dbl Diagonal
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | RiskTwistSpread
 |  |  | Single
 |  |  | Vertical
Spreadsheet: 823068d1679677985-creating-links-in-excel-pontaj-2023-draft
Sheet: FEBRUARI

 |  | DATE | 2023-02-01 00:00:00
 | Nr. [NAME]. | ID | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NORM HOURS | WORK HOURS | SCREEN HOURS | WEEK HOURS | NIGHT HOURS | CO | CM
GR. 1 | 1 | 111 | Jhon
 | 2 | 112 | [NAME]
 | 3 | 113 | Adalyn
 | 4 | 114 | [NAME]
 | 5 | 115 | Beverly
GR. 2 | 6 | 116
 | 7 | 117
 | 8 | 118
 | 9 | 119
 | 10 | 120
GR. 3 | 11 | 121
 | 12 | 122
 | 13 | 123
 | 14 | 124
 | 15 | 125
GR. 4 | 16 | 126
 | 17 | 127
 | 18 | 128
 | 19 | 129
 | 20 | 130
.... | .... | ....
 | .... | ....
 | .... | ....
 | .... | ....
 | .... | ....
.... | .... | ....
 | .... | ....
 | .... | ....
 | .... | ....
 | .... | ....
.... | .... | ....
 | .... | ....
 | .... | ....
 | .... | ....
 | .... | ....
.... | .... | ....
 | .... | ....
 | .... | ....
 | .... | ....
 | .... | ....
GR. ”n” | .... | ....
 | .... | ....
 | .... | ....
 | .... | ....
 | .... | ....
Spreadsheet: 855685d1705182898-dispaying-names-based-on-ranking-scores-from-another-sheet-champ-scoring
Sheet: Day 1 Top 10

CLUB CHAMPIONSHIP DAY 1
 | CATEGORY | [NAME] |  |  |  | CATEGORY | [NAME]
 | MEN'S GROSS |  | GROSS |  |  | MEN'S NET | OLYMPIC VIEW | NET
RANK | LAST | FIRST | SCORE |  | RANK | LAST | FIRST | SCORE
 |  | Mohammed | 154
2 | [NAME] | [NAME] | 157
3 | Campbell | [NAME] | 158
4 | [NAME] | Lance | 161
5 | Mason | Cory | 164
6 | Sparrow | [NAME] | 166
7 | Creamer | Shawn | 174
8 | Christy | [NAME] | 178
9 | Elson | [NAME] ([NAME]) | 179
9 | Shea | Scott | 179
Spreadsheet: 229505d1366409640-finding-student-grades-in-multiple-sheets-students_grades
Sheet: Physics

Student ID | Name | Grade
10001 | CC | 90
10002 | DD | 87
10003 | EE | 91
10004 | FF | 96
10005 | GG | 90
10006 | HH | 66
10007 | II | 56
10008 | JJ | 90
10009 | KK | 81
10010 | LL | 101
10011 | MM | 100
10012 | NN | 71
10013 | OO | 99
10014 | PP | 88
Spreadsheet: 08147bb7-5126-41e4-82a2-752c4fe8f9ec
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Winners Bracket
 | 2) Dunbar Transfer
 | 9:00  Blue  (3
 | 7) Convicts |  |  |  |  | 9 Teams
 |  | 11:00  Red  (9
 | 3) Polecatz
 | 9:00  Yellow  (2 |  |  |  | 9 Teams
 | 6) Amish Mafia
 |  |  | 1:00  Yellow  (13
 | 1) Shockers
8) Bears Den
 | 10:00  Red  (5
9:00 Red  (1
9) Warped |  | 12:00  Blue (10
 | 5) S&S Tire
 | 10:00  Yellow (4
 | 4) Road Dawgs |  |  |  | 3:00  [NAME] (16
 | Loser's | Bracket
 |  |  |  | L-13
L-1 |  | L-10 |  |  |  | 4:00 (17
10:00  Blue (6 |  | 12:00  Yellow (12 |  | 2:00  [NAME] (15
L-2 | 11:00  Yellow  (8
 | [NAME] |  | 1:00  Red (14
 |  | L-9
 | L-4 | 12:00  Red (11
 | 11:00  Red  (7 |  |  |  |  | [NAME]
 | [NAME]
Spreadsheet: 168370d1342429468-excel-2007-retrieving-unique-values-from-a-list-by-index-match-countif-sample-file
Sheet: Sheet1

 |  |  | Fotis1991 | zbor
 | POST CODE SECTOR | UNIQUE POSTCODES | UNIQUE POSTCODES | UNIQUE POSTCODES
 | KA8 0
 | G33 3
 | [NAME]
 | KA8 9
 | G43 4
 | G32 8
 | G32 8
 | G32 8
 | KA8 0
 | KA9 7
 | KA8 8
 | KA8 8
 | G40 2
 | G40 2
 | G40 2
 | G40 2
 | G31 2
 | G71 8
 | KA11 1
 | KA11 1
 | KA11 1
 | G71 8
 | G71 8
 | G71 8
 | G71 8
 | G71 8
 | KA11 1
 | KA11 1
 | KA11 1
 | KA11 1
 | KA11 1
 | KA11 1
 | G71 8
 | ML9 2
 | G71 8
 | KA11 4
 | KA11 1
 | KA11 3
 | KA11 3
 | G71 8
 | G71 8
 | G71 8
 | KA11 4
 | KA11 3
 | KA11 4
 | G20 9
 | G71 8
 | KA11 1
 | KA11 1
 | KA11 1
 | KA11 1
 | KA11 3
 | KA11 3
 | KA11 3
 | G69 9
 | KA11 1
 | KA11 1
 | KA11 1
 | KA11 1
 | KA11 1
 | KA11 1
 | ML6 0
 | ML6 0
 | ML6 0
 | ML6 0
 | KA15 1
 | KA15 2
 | KA15 1
 | KA14 3
 | KA14 3
 | KA15 2
 | ML9 3
 | ML9 3
 | ML9 3
 | ML9 3
 | ML9 3
 | ML5 6
 | KA15 1
 | KA15 1
 | ML6 0
 | ML6 0
 | ML6 0
 | ML6 0
 | ML6 0
 | ML6 0
 | ML9 3
 | ML9 3
 | ML9 3
 | ML9 3
 | ML9 3
 | ML9 3
 | ML9 3
 | ML6 0
 | ML6 0
 | ML6 0
 | ML6 0
 | ML6 0
 | ML9 3
Spreadsheet: 831520d1685696580-offset-not-returning-answer-im-looking-for-runout-test-1-1-
Sheet: Run Out

FG Code | Description | Case Qty | Infor FG Stock | Packaging SKU Short | Sage Packaging On Hand (cases) | WIP Stock @ Supplier (units) | FG Stock @ Supplier (units) | Stock & [NAME] (cases) | Total No Cases & FG Stock |  | Run Out Date Against Forecast
ASBAKED101 | [NAME] |  | 2000 | [NAME] | 0 | 0 | 0 |  | 2500
Spreadsheet: 58583d1258822472-need-help-making-excel-distribute-hours-differently-after-working-40-hours-correct-pay-worksheet
Sheet: Sheet2

 |  |  | Worked | Regular | Overtime | Doubletime | No Lunch | Call | Holiday | Vacation | Sick
 |  | Saturday | 15 | 8 | 4 | 3
 |  | Sunday | 15 | 8 | 4 | 3
 |  | Monday | 15 | 8 | 4 | 3
 |  | Tuesday | 15 | 8 | 4 | 3
 |  | Wednesd | 15 | 8 | 4 | 3
 |  | Thursday | 15
 |  | Friday | 15
 |  | Saturday | 15
 |  | Sunday | 15
 |  | Monday | 15
 |  | Tuesday | 15
 |  | Wednesd | 15
 |  | Thursday | 15
 |  | Friday | 15
Spreadsheet: 870433d1716952570-show-value-blank-or-please-select-slicers-when-some-of-slicer-not-selected-example
Sheet: Pvt

Row Labels | Sum of Degree | Sum of s1 | Sum of s2 | Sum of s3 | Sum of s4 | Sum of s5 | Sum of s6 | Sum of s7 | Sum of s8
Type 1 | 4 | 8096 | 3850 | 990 | 2843 | 15779
yes | 4 | 8096 | 3850 | 990 | 2843 | 15779
Grand Total | 4 | 8096 | 3850 | 990 | 2843 | 15779
Spreadsheet: 827410d1682678627-get-position-value-returns-a-spilling-range-get_rank-aligw
Sheet: Feuil1

ref | price |  |  |  | ref | price | position (expected_result) |  |  | AliGW:
A | 50 |  |  |  |  |  | 1 |  |  |  | 50 | 1
A | 300 |  |  |  | A | 300 | 3 |  |  | A | 300 | 3
A | 250 |  |  |  | A | 250 | 2 |  |  | A | 250 | 2
A | 500 |  |  |  | A | 500 | 4 |  |  | A | 500 | 4
A | 1000 |  |  |  | A | 1000 | 5 |  |  | A | 1000 | 5
B | 250 |  |  |  | B | 250 | 3 |  |  | B | 250 | 3
B | 100 |  |  |  | B | 100 | 2 |  |  | B | 100 | 2
B | 25 |  |  |  | B | 25 | 1 |  |  | B | 25 | 1
Spreadsheet: 148276d1333319734-excel-2007-unable-to-make-totals-balance-both-up-and-down-sample
Sheet: Sheet1

 | Weight(Lbs) | Weight(MT)
 | 42500
 | 42500
 | 42500
 | 42500
 | 42500
 | 42500
 | 42500
 | 0
Spreadsheet: 99626d1298241226-need-to-change-the-cell-to-refer-to-subscription-test
Sheet: 1

Item to Send: | Date to Send Product | Sent? | Item ready?
A | 2010-05-10 00:00:00 | yes | yes
B | 2010-07-21 00:00:00 | no | Yes
C | 2010-07-23 00:00:00 | no | No
 |  | Not Sent Out | Not Complete
 |  | Sent Out | Complete
Spreadsheet: 137972d1327447643-vlookup-or-hlookup-dummy-book1vlookup
Sheet: Sheet1

 | Date | Invoice Ref | Payment Method | Payment Details | Bank | Cash | Drawings | Entertainment | Office | Motor Expenses | Utilities
 | 2010-04-06 00:00:00 | gs001 | Debit card | Dell Boy Motors | 250 |  |  |  |  | 250
 | 2010-04-06 00:00:00 | gs003 | Cheq #0020 | N.Power Electric | 175 |  |  |  |  |  | 175
 | 2010-04-07 00:00:00 | gs005 | Credit card | Amazon | 50 |  |  |  | 50
 | 2010-04-08 00:00:00 | gs010 | Debit card | [NAME] shop | 10 |  |  | 10
 | 2010-04-09 00:00:00 | [NAME] | Cheq #0021 | Rolls Royce Ltd | 25000 |  | 25000
 | 2010-04-10 00:00:00 | gs020 | Cash | [NAME] shop |  | 7.5 |  | 7.5
 | 2010-04-10 00:00:00 | gs025 | Credit card | Rolls Royce Ltd | 150 |  |  |  |  | 150
 | 2010-04-12 00:00:00 | [NAME] | Cheq #0022 | Dell Boy Motors | 40 |  |  |  |  | 40
 | 2010-04-15 00:00:00 | gs035 | Cheq #0023 | Dell Boy Motors | 175 |  |  |  |  | 175
 | 2010-04-15 00:00:00 | gs033 | Cheq #0024 | N.Power Electric | 75 |  |  |  |  |  | 75
 |  |  |  | Totals |  |  |  |  |  |  |  |  | Totals by
 |  |  |  |  |  |  |  |  |  |  |  |  | Cash
IF(SUMPRODUCT(--($A$2:$A$7=E$1))>=ROWS(E$2:E2),INDEX($B$2:$B$7,SMALL(IF($A$2:$A$7=E$1,ROW($A$2:$A$7)-ROW($A$2)+1),ROWS(E$2:E2))),"") |  |  |  |  |  |  |  |  |  |  |  |  | Cheques
 |  |  |  |  |  |  |  |  |  |  |  |  | Credit Card
 |  |  |  |  |  |  |  |  |  |  |  |  | Debit Card
 |  | N.Power Electric | Dell Boy Motors | Rolls Royce Ltd | Amazon | [NAME] shop | Want to achieve this from data in G4:[NAME] While I would like to keep the condition formating the list of individual payments is whats important |  |  | N.Power Electric | Dell Boy Motors | Rolls Royce Ltd | Amazon | [NAME] shop
 |  |  |  |  |  | This is my attempt so far
Spreadsheet: chris_germany__1710__coh2000-2001
Sheet: SST

CES Storage Allotment on TCO for COH Choice 2000/2001
 | FSS-SCQ | 6050607.12
 | SST-MDQ-W
 | SST-MDQ-S
 |  |  | S | W
 | COH-03 PORTSMOUTH | 22-15 | 887 | 1773
 | COH-05 PARMA | 23N-2 | 7377 | 14754
 | COH-05 SANDUSKY | 23N-7 | 2977 | 5954
 | COH-07 COLUMBUS | 23-5 | 14119 | 28238
 | COH-07 [NAME] | 23-4 | 1763 | 3526
 | COH-07 DAYTON | 23-6 | 2405 | 4809
 | COH-07 TOLEDO | 23-1 | 15138 | 30275
 | COH-07 [NAME] | 23-3 | 2273 | 4546
 | COH-07 MANSFIELD | 23-8 | 2573 | 5145
 | COH-07 OHIO MISC | 23-9 | 3128 | 6256
 | COH-08 PITTSBURGH | 24-35 | 1654 | 3307
 | COH-08 NEWCASTLE | 24-39 | 33 | 65