tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 327682d1403643420-after-concatenateing-need-to-get-rid-of-last-comma-formula-with-errors
Sheet: Sheet1

Title 1 | Title 2 | Title 3 | Title 4 | Title 5 | Title 7 | Title 6 | Title 7 | Title 8
GIRLS IN HATS I, | GIRLS IN HATS II, |  |  |  |  |  |  |  | TITLES: | GIRLS IN HATS I, GIRLS IN HATS II, | TITLES:  GIRLS IN HATS I, GIRLS IN HATS II, | TITLES:  GIRLS IN HATS I & GIRLS IN HATS II
[NAME], | ENCHILADA, | RAVIOLI, | SUSHI, |  |  |  |  |  | TITLES: | [NAME], ENCHILADA, RAVIOLI, SUSHI, | TITLES:  SALAD NICOISE, ENCHILADA, RAVIOLI, SUSHI, | TITLES:  SALAD NICOISE, ENCHILADA, RAVIOLI & SUSHI
[NAME], | LOS FELIZ, | VIA NOGALES, | SAN MIGUEL, |  |  |  |  |  | TITLES: | [NAME], LOS FELIZ, VIA NOGALES, SAN MIGUEL, | TITLES:  [NAME], LOS FELIZ, VIA NOGALES, SAN MIGUEL, | TITLES:  [NAME], LOS FELIZ, VIA NOGALES & SAN MIGUEL
NIGHT VIEW OF LOWER MANAHATTAN, | EMPIRE STATE BUILDING, | BROOKLYN BRIDGE & WORLD TRADE CENTER, |  |  |  |  |  |  | TITLES: | NIGHT VIEW OF LOWER MANAHATTAN, EMPIRE STATE BUILDING, BROOKLYN BRIDGE & WORLD TRADE CENTER, | TITLES:  NIGHT VIEW OF LOWER MANAHATTAN, EMPIRE STATE BUILDING, BROOKLYN BRIDGE & WORLD TRADE CENTER, | TITLES:  NIGHT VIEW OF LOWER MANAHATTAN, EMPIRE STATE BUILDING & BROOKLYN BRIDGE & WORLD TRADE CENTER
FRESH BUTTER, | FRESH EGGS, |  |  |  |  |  |  |  | TITLES: | FRESH BUTTER, FRESH EGGS, | TITLES:  FRESH BUTTER, FRESH EGGS, | TITLES:  FRESH BUTTER & FRESH EGGS
SYCAMORE LEAF, | OAK LEAF, | SWEET GUM, | MAPLE LEAF, |  |  |  |  |  | TITLES: | SYCAMORE LEAF, OAK LEAF, SWEET GUM, MAPLE LEAF, | TITLES:  SYCAMORE LEAF, OAK LEAF, SWEET GUM, MAPLE LEAF, | TITLES:  SYCAMORE LEAF, OAK LEAF, SWEET GUM & MAPLE LEAF
SCRUB BRUSHES, | SOAP DISH, | TOOTH BRUSHES, | [NAME], |  |  |  |  |  | TITLES: | SCRUB BRUSHES, SOAP DISH, TOOTH BRUSHES, [NAME], | TITLES:  SCRUB BRUSHES, SOAP DISH, TOOTH BRUSHES, [NAME], | TITLES:  SCRUB BRUSHES, SOAP DISH, TOOTH BRUSHES & TOOTH PASTER
AFRICAN PALM I, |  |  |  |  |  |  |  |  | TITLE: | AFRICAN PALM I, | TITLE:  AFRICAN PALM I, | #N/A
AFRICAN PALM II, |  |  |  |  |  |  |  |  | TITLE: | AFRICAN PALM II, | TITLE:  AFRICAN PALM II,
SUMMER BLOOMS I, | SUMMER BLOOMS II, | [NAME], | [NAME], |  |  |  |  |  | TITLES: | SUMMER BLOOMS I, SUMMER BLOOMS II, SUMMER BLOOMS III, [NAME], | TITLES:  SUMMER BLOOMS I, SUMMER BLOOMS II, SUMMER BLOOMS III, [NAME], | TITLES:  SUMMER BLOOMS I, SUMMER BLOOMS II, SUMMER BLOOMS III & SUMMER BLOOMS IV
1951 MURRAY CHAMPION DIPSIDE, | 1948 MURRAY ROADMASTER, | 55 CHEVY, | 1937 CARTON FORD FIRE CHIEF, |  |  |  |  |  | TITLES: | 1951 MURRAY CHAMPION DIPSIDE, 1948 MURRAY ROADMASTER, 55 CHEVY, 1937 CARTON FORD FIRE CHIEF, | TITLES:  1951 MURRAY CHAMPION DIPSIDE, 1948 MURRAY ROADMASTER, 55 CHEVY, 1937 CARTON FORD FIRE CHIEF, | TITLES:  1951 MURRAY CHAMPION DIPSIDE, 1948 MURRAY ROADMASTER, 55 CHEVY & 1937 CARTON FORD FIRE CHIEF
HATS I, |  |  |  |  |  |  |  |  | TITLE: | HATS I, | TITLE:  HATS I, | #N/A
Spreadsheet: 22815513-2e61-45ab-9c32-473b5c4525fc
Sheet: Sheet1

Aus der Turnierdatenbank von Chess-Results http://chess-results.com | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
4. [NAME]
[NAME] wurde [NAME] 20.02.2012 14:03:23
[NAME]
Rd. | Br. | Snr |  | Name | Elo | FED | Pkt. | Erg.
1 | 49 | 51 |  | [NAME] | 1889 | AUT | 4 | w 0
2 | 50 | - |  | spielfrei | - | - | - | - 1
3 | 35 | 48 |  | [NAME] | 1946 | AUT | 4 | s 0
4 | 41 | 64 |  | [NAME] | 1827 | AUT | 3.5 | w 0
5 | 45 | 77 |  | [NAME] | 1713 | AUT | 3.5 | s 1
6 | 38 | 66 |  | Goelles Walter | 1809 | AUT | 4 | w 0
7 | 42 | 74 |  | Taupe Richard | 1742 | AUT | 4.5 | s 0
8 | 46 | 96 |  | Stage Harry | 1200 | AUT | 2 | w 1
9 | 40 | 80 |  | [NAME] | 1691 | AUT | 4 | s 0
Sie finden [NAME] zu diesem Turnier unter  http://chess-results.com/tnr56725.aspx?lan=0
[NAME]: Chess-Results
Spreadsheet: 235060d1368311639-please-help-with-multiple-dependant-drop-down-lists-drop-down-list
Sheet: Salesman

Subsidiaries |  | HA |  | HB |  | HC |  | HF |  | HG |  | HH |  | HI |  | HK |  | HM |  | HN |  | HO |  | HQ |  | HR |  | HS |  | [NAME] | Subsidiaries | Sales
HA |  | JDV |  |  |  |  |  |  |  |  |  |  |  | FC |  |  |  |  |  | CJE |  | TCU |  | DGN |  | MH |  | [NAME] |  | DME | HA | JDV
HB |  | RUC |  |  |  |  |  |  |  |  |  |  |  | LCI |  |  |  |  |  | DTE |  | RWE |  | MWE |  | SBO |  | KeyAcc |  | NBE
HC |  | CSR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JKC |  |  |  | ETE |  | MBA |  | DGN
HF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MOS |  | MWE
HG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MZG
HH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PGE
HI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UFR
HK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WBU
HM
HN
HO
HQ
HR
HS
[NAME]
Spreadsheet: 821064d1678424609-need-a-formula-to-count-down-hours-worked-vs-next-pay-increase-on-excel-timesheet-beamer2
Sheet: Mar 16-31

[NAME]
 |  | 330 | STS-Thomas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Period 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March 16 - 31
 |  |  |  |  |  |  |  |  |  |  |  |  | Next Step | Next Step | Next Step | Next Step | Next Step | Next Step | Next Step | Next Step | Running Total
 |  |  |  |  |  |  |  |  |  |  |  | Next Step | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800
 |  |  |  |  |  |  |  |  |  |  |  | Hours Remaining
 |  |  |  |  |  |  |  |  |  |  | Current Step |  |  |  |  | Hours Until Next Step |  |  |  |  |  | 2023
 |  |  |  | REG | COMP USED | SICK | VAC | HOL USED | WORK HOL | WORK HOL OT | OT | Built in OT |  | EARN COMP | OTHER |  | OT Premium | COACH | TRAINER | COACH OT | TRAINER OT
 | JAB | Thur | 14 | 12
 | sns | Fri | 15 | 10 |  |  |  |  |  |  |  | 2
 | JAB | Sat |  | Off
 | JAB | Sat | 16 | Off
 | JAB | Sun | 17 | Off
 | JAB | Mon | 18 | Holiday |  |  |  |  |  | 6
 | JAB | Tue |  | Off |  |  |  |  |  |  | 14
 | JAB | Wed |  | 12
 | JAB | Thur |  | 12
 | JAB | Fri |  | 12
 | JAB | Sat |  | 4 |  |  |  |  |  |  |  | 2
 | JAB | Sat | 23 | 6
 | DLE | Sun | 24 | Off
 | DLE | Mon | 25 | Off |  |  |  |  |  |  | 12
 | DLE | Tue |  | Off |  |  |  |  |  |  | 12
 |  | Tue
 |  | TOTALS
 |  |  |  | REG | COMP USED | SICK | VAC | HOL USED | WORK HOL | WORK HOL OT | OT | Built in OT |  | EARN COMP | OTHER | DAILY TOTAL | OT Premium | COACH | TRAINER | COACH OT | TRAINER OT
 |  |  | reg hours forward |  |  |  |  |  |  |  |  |  |  |  |  |  | 50% | 3% | 9%
 |  |  | available leave
 |  |  | I certify that the foregoing payroll is just, true and correct; that the person whose name appears [NAME]
 |  |  | actually worked or was on authorized leave as shown; and that the salaries are due and unpaid.
 |  | EMPLOYEE SIGNATURE |  |  |  |  |  |  |  |  | DATE |  |  |  |  | AUTHORIZING SIGNATURE |  |  |  |  |  | DATE
Spreadsheet: 690943d1597387163-lookup-trying-to-deglitch-repeats-in-data-smalladviced-1-
Sheet: Sheet1

 | 2020-01-01 00:00:00 | 2020-04-07 00:00:00 | 2020-04-13 00:00:00 | 2020-05-01 00:00:00 | 2020-05-08 00:00:00 | Age at reading: | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | Weeks
Week in year read: |  | 13.85714285714286 | 14.71428571428571 | 17.28571428571428 | 18.28571428571428 |  | 1st half | 2nd half | 1st half | 2nd half | 1st half | 2nd half | 1st half | 2nd half | 1st half | 2nd half | 1st half | 2nd half | 1st half | 2nd half | .
 | DOB
Mouse A | 2020-02-07 00:00:00 |  |  | 40 | 50
[NAME] | 2020-02-07 00:00:00 |  | 30 | 40 | 50
C | 2020-02-07 00:00:00 | 20 | 30 | 640 | 50
D | 2020-02-07 00:00:00 | 20 | 30 | 1 | 50
E | 2020-02-07 00:00:00 | 20 | 30 | 0 | 50
F | 2020-02-07 00:00:00 | 20 | 30 |  | 50
G | 2020-02-07 00:00:00 | 20 |  | 40 | 50
H | 2020-02-07 00:00:00 | 20 | 30
I | 2020-02-10 00:00:00 | 20 | 30 | 40 | 50
 |  |  |  |  |  | SUM
 |  |  |  |  |  | AVERAGE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 |  | 50
 |  |  |  |  |  |  |  |  |  |  | 30 |  | (empty) |  | (empty) |  | 40 |  | 50
 |  |  |  |  |  |  |  |  |  |  | 20, 30 |  | (empty) |  | (empty) |  | 640 |  | 50
 |  |  |  |  |  |  |  |  |  |  | 20, 30 |  | (empty) |  | (empty) |  | 1 |  | 50
 |  |  |  |  |  |  |  |  |  |  | 20, 30 |  | (empty) |  | (empty) |  | 0 |  | 50
 |  |  |  |  |  |  |  |  |  |  | 20, 30 |  | (empty) |  | (empty) |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  | 40 |  | 50
 |  |  |  |  |  |  |  |  |  |  | 20, 30 |  | (empty) |  | (empty)
 |  |  |  |  |  |  |  |  | 20 |  | 30 |  | (empty) |  | (empty) |  | 40 |  | 50
Spreadsheet: 151504d1334946311-using-vlookup-funtion-within-if-statement-test_1
Sheet: reliance

 |  |  | 2 LAKH |  |  | SERVICE TAX EXTRA
MEMBER | 0-25YRS | 26-35YRS | 36-40YRS | 41-45YRS | 46-50 YRS | 51-55 YRS | 56-60 YRS | 61-65 YRS
MEMBER-1 | 2575 | 3075 | 3575 | 4275 | 6625 | 7275 | 9074 | 10123
MEMBER-2 | 3353 | 4073 | 4733 | 5573 | 9288 | 10198 | 13164 | 14985
MEMBER-3 | 4016 | 4944 | 5749 | 6665 | 11108 | 12200 | 15759 | 17944
MEMBER-4 | 4612 | 6007 | 6876 | 7975 | 13292 | 14602 | 18562 | 21140
 |  |  | 3 LAKH |  |  | SERVICE TAX EXTRA
MEMBER | 0-25YRS | 26-35YRS | 36-40YRS | 41-45YRS | 46-50 YRS | 51-55 YRS | 56-60 YRS | 61-65 YRS
MEMBER-1 | 3625 | 4275 | 4775 | 5715 | 7992 | 8779 | 10545 | 13250
MEMBER-2 | 4718 | 5363 | 6129 | 7445 | 11202 | 12303 | 15817 | 19874
MEMBER-3 | 5420 | 6413 | 7332 | 8764 | 13404 | 14726 | 18943 | 23812
MEMBER-4 | 6227 | 7547 | 8631 | 10322 | 16048 | 17634 | 22694 | 28064
Spreadsheet: benjamin_rogers__1175__Bernsteins's LM6000 Model
Sheet: SUMMARY

 | PROJECT SUMMARY
 | VALUATION BASIS |  |  |  |  | VARIABLE O&M
 |  | EXPECTED RUN HOURS | 1200 | Per Year |  |  | MAJOR MAINT ACCRUAL | 50 | $/TURBINE HOUR |  | see calc in SOURCEDATA
 |  | VALUATION CAPACITY |  | Temp. |  |  | [NAME] | 18 | $/TURBINE HOUR
 |  | NET PLANT CAPACITY |  | MW |  |  | WATER |  | $/MWh |  | see calc in SOURCEDATA
 |  | NET PLANT HEAT RATE |  | Btu/kWh |  |  | TOTAL VARIABLE O&M |  | $/MWh
 | USES OF FUNDS |  |  |  |  | FIXED O&M
 | True | TOTAL EPC PROJECT COST |  | '$(000) |  | True | Direct Labor & Burden |  | $1000/yr |  | cost scale factor |  | 0.3
 |  | CONSTRUCTION PERIOD | 9 | MONTHS |  |  | [NAME] |  | $1000/yr
 |  | INTEREST DURING CONSTRUCTION |  | '$(000) |  |  | [NAME] |  | $1000/yr
 |  | BOND FEES % | 0 | % |  |  | Misc Tools & Supplies |  | $1000/yr
 | True | BOND ISSUANCE CHARGE |  | '$(000) |  |  | SCR | 0 | $1000/yr |  | not turned on yet
 |  | TOTAL USE OF FUNDS |  | '$(000) |  |  | LM6000 lease program |  | $1000/yr
 |  |  |  |  |  | True | Subcontracts |  | $1000/yr
 | SOURCES OF FUNDS |  |  |  |  |  | TOTAL FIXED O&M |  | $-kW month
 |  | EQUITY | 0.5 | % |  |  |  | BRUCE, HEATHER HAS AN OEC ESTIMATE THAT ADDS UP TO 56¢ PER KW-MONTH
 |  | EQUITY CONTRIBUTION |  | '$(000) |  | TOTAL OPERATING COST
 |  | DEBT ISSUANCE |  | '$(000) |  | True
 |  | TERM | 20 | Years
 |  | INTEREST RATE - MO. COMP. | 0.08 | Per Year
 |  | ANNUAL DEBT SERVICE |  | '$(000)
 |  | ANNUAL DEBT SERVICE |  | Kw-month |  | True
 | RETURN ON EQUITY
 |  | TOTAL FIXED CHARGES (FOM & DEBT SRVC)
 |  | PROPOSED CAPACITY PAYMENT | 6.37
 |  | SALVAGE VALUE | 0.25
Spreadsheet: 813393d1673715531-if-table-column-5-header-offset-2-0-low-then-sum-table-column-5-header-offset-1-0-samplewb
Sheet: Ark1

 |  |  |  |  |  |  |  |  |  |  |  |  | Get the below value
 |  |  |  |  |  |  |  |  |  |  |  |  | 100000
 |  |  |  |  |  |  |  |  | Kolonne1 | Kolonne2 | [NAME] | Kolonne4 | Kolonne5 | Kolonne6 | Kolonne7 | Kolonne8 | Kolonne9 | Kolonne10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 | low
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300 | low
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 | high
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | Get the below value
 |  |  |  |  |  |  |  |  |  |  |  |  | 100000
 |  |  |  |  |  |  |  |  | Kolonne1 | Kolonne2 | [NAME] | Kolonne4 | Kolonne5 | Kolonne6 | Kolonne7 | Kolonne8 | Kolonne9 | Kolonne10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | high
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | low
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | low
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 | high
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 | low
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300
Spreadsheet: 40026d1238340284-two-way-interpolation-is-it-possible-677749-bilinear-interp
Sheet: Sheet1

y \ x | 0 | 0.5 | 1 | 1.5 | 2 | 2.5 |  | x | y | z
0 | 1 | 2 | 5 | 8 | 13 | 19 |  | 2.19777133095816 | 1.73072925941034 | 11.42582265034883
0.4 | 0.9 | 2.3 | 4.7 | 8.5 | 13.5 | 18.5
0.8 | 0.6 | 1.9 | 4.1 | 7.5 | 11.86 | 15.7
1.2 | 0.3 | 1.5 | 3.7 | 7.5 | 11.6466666666667 | 14.4333333333333
1.6 | 0 | 1.1 | 3.25 | 7.25 | 11.0766666666667 | 12.7833333333333
2 | -0.3 | 0.7 | 2.8 | 7 | 10.5066666666667 | 11.1333333333333
Spreadsheet: 377528d1424036408-calculating-total-weight-in-the-shown-data-shown-total-weight
Sheet: Sayfa1

fruit | weight |  | total weight |  | total shown weight | ???
apple | 2
grapes | 3
melon | 6
melon | 5
peach | 4
apple | 5
[NAME] | 1
[NAME] | 4
peach | 2
melon | 8
[NAME] | 3
[NAME] | 5
melon | 4
grapes | 2
peach | 1
[NAME] | 4
melon | 3
grapes | 2
peach | 1
melon | 6
Spreadsheet: 31757d1227709227-add-cells-with-color-only-generic-hours-and-miles_2008
Sheet: September

SEPTEMBER | Month Total | Month Total | 08XXXX | City
CD? Then "Y" |  | CD
 | HOURS | [NAME] | HOURS | CD [NAME]
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
AB Hours /Job | 0 |  | 0
AB-CD /Job |  | 0
 | 0
Spreadsheet: 55158d1255299636-ranking-a-w-l-record-win-loss-book10
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Team | Record |  |  | Team | W/L | Rank Column Q |  | Team | W/L | Rank
 | W |  |  | L |  |  |  | W | L
Team A |  |  |  | L | L | L |  | 0 | 3 |  | Team A | 0-3 |  |  | Team A | 0-3 |  |  | Team A | 0-3 | 11
Team B |  |  |  | L | L |  |  | 0 | 2 |  | Team B | 0-2 |  |  | Team B | 0-2 |  |  | Team B | 0-2 | 9
Team C | W | W |  | 0 |  |  |  | 2 | 0 |  | Team C | 2-0 |  |  | Team C | 2-0 |  |  | Team C | 2-0 | 2
Team D | W |  |  | L | L |  |  | 1 | 2 |  | Team D | 1-2 |  |  | Team D | 1-2 |  |  | Team D | 1-2 | 7
Team E | W | W |  | L |  |  |  | 2 | 1 |  | Team E | 2-1 |  |  | Team E | 2-1 |  |  | Team E | 2-1 | 3
Team F | W | W |  | L |  |  |  | 2 | 1 |  | Team F | 2-1 |  |  | Team F | 2-1 |  |  | Team F | 2-1 | 3
Team G |  |  |  | L | L |  |  | 0 | 2 |  | Team G | 0-2 |  |  | Team G | 0-2 |  |  | Team G | 0-2 | 10
Team H | W | W | W |  |  |  |  | 3 | 0 |  | Team H | 3-0 |  |  | Team H | 3-0 |  |  | Team H | 3-0 | 1
Team I | W |  |  | L |  |  |  | 1 | 1 |  | Team I | 1-1 |  |  | Team I | 1-1 |  |  | Team I | 1-1 | 6
Team J | W |  |  | L |  |  |  | 1 | 1 |  | Team J | 1-1 |  |  | Team J | 1-1 |  |  | Team J | 1-1 | 6
Team K | W | W |  | L |  |  |  | 2 | 1 |  | Team K | 2-1 |  |  | Team K | 2-1 |  |  | Team K | 2-1 | 3
Spreadsheet: cara_semperger__1458__ENA_PGE_DEC22_2001
Sheet: LOSSES

From: | EPMI
To: | PGE System Transactions
Date:
HE
ENDING | TOTAL |  | TOTAL
Pacific
Prevailing
Time | NO SCHEDULE POSTED
(PPT)
0100 |  | 1
0200 |  | 1
0300 |  | 1
0400 |  | 1
0500 |  | 1
0600 |  | 1
0700 |  | 4
0800 |  | 4
0900 |  | 4
1000 |  | 4
1100 |  | 4
1200 |  | 4
1300 |  | 4
1400 |  | 4
1500 |  | 4
1600 |  | 4
1700 |  | 4
1800 |  | 4
1900 |  | 4
2000 |  | 4
2100 |  | 4
2200 |  | 4
2300 |  | 1
2400 |  | 1
 | PGE | PGE | PGE
 | REAL POWER LOSSES | PGE LOSSES | [NAME] [NAME]
 | PGE | PGE | PGE
 | 640902
 | 640903
 | NEW COLUMN
Spreadsheet: 0982cd3b-180f-43e7-933e-bdee0a78a68a
Sheet: จก3

จก - ๓
แบบฟอร์มสรุปจำนวนราย จำนวนพื้นที่ ขนาดความโตเฉลี่ย และขนาดความสูงเฉลี่ย ของไม้เศรษฐกิจในประเทศไทย
ที่ได้ทำการสำรวจตั้งแต่ปีงบประมาณ พ.ศ. ๒๕๕๑ [NAME] ๒๕๕๕
สำนักจัดการทรัพยากรป่าไม้ ที่……………………………………...........
ท้องที่อำเภอ........................................จังหวัด....................................
ปีปลูก | ชนิดไม้ที่ ๑ |  |  |  | ชนิดไม้ที่ ๒ |  |  |  | ชนิดไม้ที่ ๓ |  |  |  | ชนิดไม้ที่ ๔ |  |  |  | ชนิดไม้ที่ ๕
(พ.ศ.) | [NAME] | จำนวนไร่ | ความโตเฉลี่ย | ความสูงเฉลี่ย | [NAME] | จำนวนไร่ | ความโตเฉลี่ย | ความสูงเฉลี่ย | [NAME] | จำนวนไร่ | ความโตเฉลี่ย | ความสูงเฉลี่ย | [NAME] | จำนวนไร่ | ความโตเฉลี่ย | ความสูงเฉลี่ย | [NAME] | จำนวนไร่ | ความโตเฉลี่ย | ความสูงเฉลี่ย
 |  |  | (ซม.) | (เมตร) |  |  | (ซม.) | (เมตร) |  |  | (ซม.) | (เมตร) |  |  | (ซม.) | (เมตร) |  |  | (ซม.) | (เมตร)
2537
2538
2539
2540
2541
2542
2543
2544
2545
2546
2547
2548
2549
2550
2551
2552
2553
2554
2555
รวม
Spreadsheet: 327941d1403726962-match-and-index-function-with-repeated-values-sample-jacc2
Sheet: Sheet1

 |  | 5 | 3 | 1 |  |  |  | 5 | 3 | 1 |  |  |  | 5 | 3 | 1
 |  | Often | Sometimes | Seldom |  |  |  | Often | Sometimes | Seldom |  |  |  | Often | Sometimes | Seldom
 | Question # | Visual |  |  |  |  | Question # | Auditory |  |  |  |  | Question # | Tactile
 | 2 |  |  |  |  |  | 1 |  |  |  |  |  | 4
 | 3 |  |  |  |  |  | 5 |  |  |  |  |  | 6
 | 7 |  |  |  |  |  | 8 |  |  |  |  |  | 9
 | 10 |  |  |  |  |  | 11 |  |  |  |  |  | 12
 | 14 |  |  |  |  |  | 13 |  |  |  |  |  | 15
 | 16 |  |  |  |  |  | 18 |  |  |  |  |  | 17
 | 19 |  |  |  |  |  | 21 |  |  |  |  |  | 20
 | 22 |  |  |  |  |  | 24 |  |  |  |  |  | 23
 |  |  |  | VPS= |  |  |  |  |  | APS= |  |  |  |  |  | TPS=
 |  |  |  |  |  | Visual [NAME].
 |  |  |  |  |  | [NAME].
 |  |  |  |  |  | [NAME].
 |  |  |  |  | Visual [NAME]
 |  |  |  |  | Audio Learner
 |  |  |  |  | [NAME]
Spreadsheet: 267958d1380315263-help-sorting-two-tiered-and-if-forumula-use-tie-breaker
Sheet: Helper with RANK.EQ

F Name | Surname | Other info 1 | Other info 2 | No. | Laps | Time In | Rank Helper | Position | DNF?
A | Bloggs |  |  | 1 | 2 | 13:31:30
B | Bloggs |  |  | 2 | 3 | 14:31:30
C | Bloggs |  |  | 3 | 4 | 13:44:32
d | Bloggs |  |  | 4 | 5 | 13:30:25
e | Bloggs |  |  | 5 | 2 | 13:31:20
f | Bloggs |  |  | 6 | 3 | 13:41:54
g | Bloggs |  |  | 7 | 4 | 13:43:32
h | Bloggs |  |  | 8 | 5 | 13:31:30
i | Bloggs |  |  | 9 | 6 | 13:51:23
j | Bloggs |  |  | 10 | 7 | 13:56:23
k | Bloggs |  |  | 11 | 8 | 13:32:17
l | Bloggs |  |  | 12 | 1 | 12:32:14
m | Bloggs |  |  | 13 | 2 | 13:20:45
n | Bloggs |  |  | 14 | 3 | 13:35:45
o | Bloggs |  |  | 15 | 4 | 13:45:32
p | Bloggs |  |  | 16 | 5 | 14:01:34
q | Bloggs |  |  | 17 | 4 | 13:56:45
r | Bloggs |  |  | 18 | 3 | 13:24:54
s | Bloggs |  |  | 19 | 2 | 11:12:32
t | Bloggs |  |  | 20 | 6 | 13:43:56
u | Bloggs |  |  | 21 | 5 | 13:30:11
v | Bloggs |  |  | 22 | 4 | 1900-01-02 15:08:00
w | Bloggs |  |  | 23 | 3 | 13:43:56
x | Bloggs |  |  | 24 | 3 | 13:43:58
y | Bloggs |  |  | 25 | 4 | 13:42:45
z | Bloggs |  |  | 26 | 4 | 13:42:46
EVENT FINISH TIME | 13:30:00
 |  |  |  |  |  |  |  | ^^^^^
 |  |  |  |  |  |  |  | Enter a position
 |  |  |  |  |  |  |  | Ie. 1, 2, 3. for 1st,
 |  |  |  |  |  | Primary |  | 2nd, 3rd.
 |  |  |  |  |  | Sort |  | Based on No of
 |  |  |  |  |  |  |  | laps.
 |  |  |  |  |  | Secondary |  | If Tied on laps.
 |  |  |  |  |  | Sort |  | Lowest time wins
Spreadsheet: mark_taylor__25023__Option Valuation N0x
Sheet: Assumptions

 | ASSUMPTIONS
 | average unit:
1 | unit size (MW) |  | 150
2 | heat rate: |  | 10000
3 | capacity: |  | 0.75
4 | heat input:
 |  | annual
 |  | O3 season
5 | generation:
 |  | annual
 |  | O3 season
6 | control technology: |  | [NAME]
7 | destruction efficiency: |  | 0.8
8 | NOx rate:
 |  | uncontrolled | 0.45
 |  | post-control
9 | qty. NOx removed:
 | (tons)
 |  |  |  | CapEx $/kw | CapEx $/kw | CapEx $/kw
 |  |  |  | 30 | 45 | 60
Estimated Capital Cost
Estimated O&M Cost |  |  |  |  |  | [NAME] reduced
Gas | Usage | Price
 | 0.015 | 4.5 | per mmbtu
Ammonia | 1.65 | 200 | per ton
HR | 0.005 | 1.3 | per mmbtu (coal)
Spreadsheet: 754159d1635972437-single-formula-to-average-numbers-based-on-percentile-quintile-beta-quintiles
Sheet: Summary

 |  | Average Beta
0 - 20% | 1st Quintile | a single formula to pull from the "Data" tab
20% - 40% | 2nd Quintile | a single formula to pull from the "Data" tab
40% - 60% | 3rd Quintile | a single formula to pull from the "Data" tab
60% - 80% | 4th Quintile | a single formula to pull from the "Data" tab
80% - 100% | 5th Quintile | a single formula to pull from the "Data" tab
Spreadsheet: 820134d1677872662-formulas-in-table-change-when-adding-new-lines-create-unique-entry
Sheet: Sheet1

Total Distinct
Week Closed | 2023-01-01 00:00:00
Object | Observation | Datapoint | Datapoint2 | Week Closed
ABC
ABC
ABC
DEF
GHI
GHI
Spreadsheet: 538945d1505905024-auto-populate-data-from-an-existing-sheet-auto-populate
Sheet: Answer Sheet

Division | A |  |  |  |  | B |  |  |  |  | C |  |  |  |  | D |  |  |  |  | E |  |  |  |  |  |  |  |  |  | G
Year | April'17 | May'17 | June'17 | July'17 | Aug'17 | April'17 | May'17 | June'17 | July'17 | Aug'17 | April'17 | May'17 | June'17 | July'17 | Aug'17 | April'17 | May'17 | June'17 | July'17 | Aug'17 | April'17 | May'17 | June'17 | July'17 | Aug'17 | April'17 | May'17 | June'17 | July'17 | Aug'17 | April'17 | May'17 | June'17 | July'17 | Aug'17
Apple
Orange
Spreadsheet: 803252d1667333919-max-formula-with-two-criteria-test
Sheet: Sheet1

Person | Fruit | Amount |  | Fruit | Person | Min Fruit | Min Person | Min Fruit/Person | [NAME] | [NAME] | Max Fruit/Person
[NAME] | Bananas | 10 |  | Bananas | [NAME]
[NAME] | Oranges | 25 |  | Oranges | [NAME]
Carol | Mango | 6 |  | Mango | [NAME]
[NAME] | Bananas | 9 |  | Bananas | [NAME]
[NAME] | Oranges | 24 |  | Oranges | [NAME]
[NAME] | Mango | 7 |  | Mango | [NAME]
Carol | Bananas | 11 |  | Bananas | Carol
[NAME] | Oranges | 28 |  | Oranges | Carol
[NAME] | Mango | 5 |  | Mango | Carol
[NAME] | Bananas | 12 |  | Bananas | [NAME]
Carol | Oranges | 32 |  | Oranges | [NAME]
[NAME] | Mango | 8 |  | Mango | [NAME]
[NAME] | Bananas | 14
[NAME] | Oranges | 39 |  |  |  |  |  |  |  |  | =MAX(IF(AND($L$2:$L$29=Q2,$M$2:$M$29=P2),$N$2:$N$29))
Carol | Mango | 9 |  |  |  |  |  | =MIN(IF(AND($L$2:$L$29=Q2,$M$2:$M$29=P2),$N$2:$N$29))
[NAME] | Bananas | 8
[NAME] | Oranges | 21
[NAME] | Mango | 4
Carol | Bananas | 7
[NAME] | Oranges | 22
[NAME] | Mango | 5
[NAME] | Bananas | 16
Carol | Oranges | 24
[NAME] | Mango | 6
[NAME] | Bananas | 19
[NAME] | Oranges | 26
Carol | Mango | 10
[NAME] | Bananas | 7
Spreadsheet: 46515d1245346959-compare-two-columns-text-to-date-rental_quotes_withsummery_dummy
Sheet: Cold

 | Company Name | Req. Date | Salesmen | Equip.1 | # | Equip.2 | # | Status | Req. by | Reason | Comments
Total:s | 1 |  |  |  | 3 |  | 0
 | Customer Name | 2009-01-19 00:00:00 | Roper | Walkie 8300 | 3 |  |  | Cold | Roper |  | [NAME].
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Perlowin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Young
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shively
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roper
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aurand
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cummings
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Heichemer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yerdon
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Coordinator