tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 794061d1661864938-financial-statement-ytd-12-month-rolling-average-based-on-dropdown-copy-of-kopi-av-handlingsplaner-2022-1-aligw
Sheet: Ark1

Avdeling DG%
 | Nybygg |  |  |  |  |  |  |  | HMS
 | Rehab |  |  |  |  |  |  |  | Kvalitet
 |  |  |  |  |  |  |  |  | Miljø
 | Service |  |  |  |  |  |  |  | [NAME]
Prosjekt DG% |  |  |  |  |  |  |  |  | [NAME]
 | Nybygg (individuelt)
 | Rehab (KIWI + mindre) samlet
 | Rehab (individuelt)
Prosjekt HMS
Inn i prosjektsprosess - kalenderutine. | 100% gjennomføring vernerunder
 | 0 fraværsskader
Prosjekt leveranse
 | Fremdriftsutførelses% målt mot fremdriftsplan
 | Endre til de som står ovenfor
 | Overlevering med 0-10 feil
HMS | FDV leveres til forhåndsbefaring |  |  |  |  |  |  |  |  |  |  | Bemanning
Miljø - legge inn på hver avdeling. | Sorteringsgrad per prosjekt |  |  |  |  |  |  |  |  |  |  |  | Nyansettelser/lærlinger.
 |  |  |  |  |  |  |  |  |  |  |  |  | Akkord/Jobbe med [NAME] opp mot produksjonsarbeiderne
 |  |  |  |  |  |  |  |  |  |  |  |  | Høyere effektivitet på produksjonsarbeidere.
 |  |  |  |  |  |  |  |  |  |  |  |  | Akkord/Jobbe med [NAME] opp mot produksjonsarbeiderne
HMS |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 0 skader med fravær |  |  |  |  |  |  |  |  |  |  |  | [NAME] større prosjekter. (Min. 5 mill.)
Avventer [NAME] er på plass | 20 RUH |  |  |  |  |  |  |  |  |  |  |  | Treffprosent i kalkulasjon. (%)
[NAME] i prosjektprosess | 100% gjennomføring vernerunder |  |  |  |  |  |  |  |  |  |  |  | Treffprosent i kalkulasjon. (Kr.)
[NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | DG
 | Reklamasjonskost rullerende 12 mnd |  |  |  |  |  |  |  |  |  |  |  | Produksjonsoppfølging BO.
 | Omsetning |  |  |  |  |  |  |  |  |  |  |  | Godkjente endringsmeldinger per prosjekt mot kontrakt.
Kvalitet
 | 90% feilfrie overleveringer
 | FDV leveres til forhåndsbefaring
 | % [NAME] avtalt tid
Læringskultur |  |  |  |  |  |  |  |  |  |  |  | SMART modellen à spesifikt, [NAME], akseptabelt, realistisk og tidsbestemt.
 | 4 interne prosjektsamlinger bolig
Tomteutvikling
 | Kjøp eller oppsjon 40 boenheter pr år
[NAME] og innkjøp
 | Byggekost må ned (10% i dag)
 | 80% gjenbruk [NAME] produkter
 | [NAME] (80% gjenbruk)
Kvalitet - rydde opp etterpå | Ikke dagmulkt/ ikke brukstillatelse
 | Kategorisere denne 0-10 feil (feilfri - 78%, 80 % bolig), (1-10), [NAME] på næring og bolig
Spreadsheet: kimberly_watson__20552__imbalsumm0108
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 87555 | 87075
2 | 98252 | 97649
3 | 78608 | 77218
4 | 101009 | 100503
5 | 90729 | 89600
6 | 91681 | 90563
7 | 105225 | 103990
8 | 109389 | 107112
9 | 96923 | 96695
10 | 62710 | 62247
11 | 98145 | 100814
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 21602.9
2001-08-11 00:00:00
CBS Volume
 |  |  | -43475
Spreadsheet: joe_parks__14715__POSTION05_02
Sheet: JUL_SWAP

 | SELL |  |  |  | BUY
BEGINNING | 107.5 | 3.473 |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: bae22c41-3a7e-4562-b64a-afe062fb48c5
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
DHTS | Test | DHTS | Dihydrotestosterone, Serum | Dihydrotestosterone, S | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Plain, Red-Top Tube: Red OR |  |  | 2 | mL | Container/Tube:  Preferred: Red top  Acceptable: Serum gel [NAME]: 1 mL | 0.6 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | [NAME] blood: < or =100 pg/mL < or =6 months: < or =1,200 pg/mL Tanner Stages	 Mean	Age	Reference Range (pg/mL) Stage I (>6 months and prepubertal)	7.1 years	< or =50 Stage II	12.1 years	< or =200 Stage III	13.6 years	80-330 Stage IV	15.1 years	220-520 Stage V	18 years	240-650 >19 years: 112-955 pg/mL  Females [NAME] blood: < or =50 pg/mL < or =6 months: < or =1,200 pg/mL Tanner Stages	 Mean	Age	Reference Range (pg/mL) Stage I (>6 months and prepubertal)	7.1 years	< or =50 Stage II	10.5 years	< or =300 Stage III	11.6 years	< or =300 Stage IV	12.3 years	< or =300 Stage V	14.5 years	< or =300 20-55 years: < or =300 pg/mL >55 years: < or =128 pg/mL  1. [NAME], Levine LS, [NAME], et al: Dihydrotestosterone and its relationship to testosterone in infancy and childhood. J [NAME] 1979;48:821-826 2. Stanczyk FZ: Diagnosis of hyperandrogenism: biochemical criteria. Best Pract Res Clin Endocrinol Metab 2006;20(2):177-191 | Monday, Wednesday, Friday; 10 a.m. | 2 days | 6 days | 1 | 82651 |  |  |  |  | Rochester
DHTS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
DHTS | Result | 81479 | Dihydrotestosterone, S | Dihydrotestosterone, S | Numeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | 1848-1 | Androstanolone:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 42cd56c3-b650-40c9-9738-1f254cea38c0
Sheet: ClassificationWeb

ClassificationWeb
2008-2009
 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | Total | 2008-2009 Price | Price per unit
ClassificationWeb
Sessions (no. days used) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Maximum users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total records | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |  | 594.69
Next/prev records | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
COUNTER-Compliant?: | No
Spreadsheet: benjamin_rogers__1001__BR New York Ticker backup version
Sheet: ZONE A DAY AHEAD

 |  |  |  | Zone A DAY- AHEAD SPREAD SHEET
Day Ahead Prices
HE 1 | HE 2 | HE 3 | HE 4 | HE 5 | HE 6 | HE 7 | HE 8 | HE 9 | HE 10 | HE 11 | HE 12 | HE 13 | HE 14 | HE 15 | HE 16 | HE 17 | HE 18 | HE 19 | HE 20 | HE 21 | HE 22 | HE 23 | HE 24
25.55 | 20.96 | 20.27 | 19.73 | 20.06 | 23.94 | 29.43 | 31.79 | 35.37 | 34.21 | 34.26 | 34.83 | 34.83 | 36.87 | 39.98 | 39.87 | 39.84 | 36.63 | 34.25 | 34.54 | 35.46 | 33.82 | 28.98 | 29.45
Real Time Prices
HE 1 | HE 2 | HE 3 | HE 4 | HE 5 | HE 6 | HE 7 | HE 8 | HE 9 | HE 10 | HE 11 | HE 12 | HE 13 | HE 14 | HE 15 | HE 16 | HE 17 | HE 18 | HE 19 | HE 20 | HE 21 | HE 22 | HE 23 | HE 24
33.76 | 26.85 | 27.44 | 23.98 | 24.02 | 44.8 | 87.21 | 73.8 | 60.59 | 97.19 | 81.73 | 55.04 | 62.99 | 63.85
ON PEAK |  |  |  | HOUR | BUY(MW) | SELL(MW) | PRICE | FILLED |  | AVERAGES
OFF PEAK |  |  |  | 1
RTC |  |  |  | 2 |  |  |  |  |  | ON PEAK
 |  |  |  | 3
 |  |  |  | 4 |  |  |  |  |  | OFF PEAK
 |  |  |  | 5
 |  |  |  | 6 |  |  |  |  |  | RTC
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9 |  |  |  |  |  | PRICE TO BEAT
 |  |  |  | 10
 |  |  |  | 11 |  |  |  |  |  | ON PK | 45.2
 |  |  |  | 12 |  |  |  |  |  | OFF PK | 26
 |  |  |  | 13
 |  |  |  | 14
 |  |  |  | 15
 |  |  |  | 16
 |  |  |  | 17
 |  |  |  | 18
 |  |  |  | 19
 |  |  |  | 20
 |  |  |  | 21
 |  |  |  | 22
 |  |  |  | 23
 |  |  |  | 24
Spreadsheet: 799078d1664902163-insert-graphs-that-automatically-update-based-on-variables-chart-eba
Sheet: 1a

Index | Level
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: 5x10-1

Local 20
Nom: | [NAME] | Restaurant Tsunami
Numéro de téléphone: | [PHONE] | [PHONE]
[NAME]: | 40
Paiement dû le: | 2013-11-12 00:00:00
[NAME]:
Réservé: | Réservé
 | 40
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 675746d1588454764-create-summary-list-from-multiple-worksheets-create_summary_images
Sheet: Sheet1

Manufacturer | Model | Image | Store location
A | xx |  | Box 1
B | yy |  | Box 1
C | zz |  | [NAME]
D | yy |  | [NAME]
E | xxx
F | yyy
G | zzz |  | [NAME]
H | yy |  | [NAME]
Spreadsheet: 864504d1711644644-find-another-row-in-a-table-whose-first-two-columns-match-and-determine-value-of-third-sampleboltnail
Sheet: Roster

Name | Empl# | Nom Workday
[NAME] | 2 | 10
[NAME] | 12 | 10
[NAME] | 14 | 8
[NAME] | 17 | 8
[NAME] | 23 | 10
[NAME] | 35 | 10
Mac | 39 | 10
Fred | 51 | 9
Derek | 58 | 9
Brenden | 36 | 8
Spreadsheet: d5268c5a-d39b-493e-ae3d-0bdf87b10476
Sheet: BU14

Date | Day | Start Time | Field | Home | Visitor |  | Date | Day | Start Time | Field | Home | Visitor
2013-02-10 00:00:00 | Sunday | 1:30PM | PVF 18 | BU14 | BU14 |  | 2013-03-10 00:00:00 | Sunday | 1:30PM | PVF 18 | BU14 | BU14
2013-02-17 00:00:00 | Sunday | 1:30PM | PVF 18 | BU14 | BU14 |  | 2013-03-17 00:00:00 | Sunday | 1:30PM | PVF 18 | BU14 | BU14
2013-02-24 00:00:00 | Sunday | 1:30PM | PVF 18 | BU14 | BU14 |  | 2013-04-07 00:00:00 | Sunday | 1:30PM | PVF 18 | BU14 | BU14
2013-03-03 00:00:00 | Sunday | 1:30PM | PVF 18 | BU14 | BU14 |  | 2013-04-14 00:00:00 | Sunday | 1:30PM | PVF 18 | BU14 | BU14
Spreadsheet: sally_beck__33811__ICE New User Enrollment Form
Sheet: Location 1

 | The ICE
 | New User Enrollment Form
 |  |  |  | Precious Metals
 |  |  |  | Oil
 |  |  |  | Natural Gas
 |  |  |  | Electric Power
 |  |  | Company | Commodity Type(s) |  | Location 1:
 |  |  |  | All |  | Address: |  |  | What is your favorite sports team?
 |  |  | Commodity 1 |  |  | Company: |  |  | What is your favorite sports team?
 |  |  | Commodity 2 |  |  | City: |  |  | What is your library card number?
 |  |  | Commodity 3 |  |  | State/Prov./Postal Code: |  |  | Who was your favorite teacher?
 |  |  | Commodity 4 |  |  | Country |  |  | What is your dream vacation destination?
 |  |  |  |  |  |  |  |  | What is your favorite movie?
User | Primary Contact for | First Name | Last Name | Commodity Type(s) | User Type | Title | Phone | E-mail Address | Secret Question (Choose One) | Secret Question Answer (Minimum 5 characters)
1 * | User Enrollment (Administrator)
2 * | Credit
3 * | Invoicing
4 * | Technical
5
 |  |  |  |  | View-Only
* Users 1-4 are required before any user can be given access to trade on The ICE. |  |  |  |  | Trader
 |  |  |  |  | Risk Manager
 |  |  |  |  | Super User
 |  |  |  |  | Accounting-Only
Spreadsheet: 93961d1293721200-picking-out-part-of-a-text-thismaywork4u
Sheet: Ark1

Beliggenhed | [NAME] | [NAME] | Ejer | Ejer_Post_adresse
A.H.Winges Vej 1 | 751000014 | Område 3 | Ejerfor.A.H.Winges [NAME] | A.H.Winges [NAME] Århus N
A.H.Winges [NAME] | 751000014 | Område 3 | Ejerfor.A.H.Winges [NAME] | A.H.Winges [NAME] Århus N
A.H.Winges Vej 5 | 751000251 | Område 3 | ABF A H WINGES VEJ 5-7-9 | c/o BOLIQ Ejendomsadministration Ap  Grenåvej 117  8240 Risskov
Abelvej 1 | 751000375 | Område 3 | Else Uldall Bøgh | Havkærvej 36  8381 Tilst
Abildgade 1 | 751434383 | Område 3 | [NAME] | v/Ejendomsforvaltningen  Jorder og landbrugsarealer  [NAME] Stræde 3-5  8100 Århus C
Abildgade 10 | 751000480 | Område 3 | Abild Invest Aps | c/o [NAME]  Julivej 5  8210 Århus V
Abildgade 11 | 751000499 | Område 3 | Boligforeningen Bo&Liv | Viby Andelsboligforening  Vestergårdsvej 15  8260 Viby J
Abildgade 12 | 751000510 | Område 3 | [NAME] | v/ [NAME]Forteleddet 14  8240 Risskov
Abildgade 14 | 751000529 | Område 3 | [NAME] | Elmehaven 65  8520 Lystrup
Abildgade 16 | 751000537 | Område 3 | [NAME] | Hirtshalsvej 11A  8250 Egå
Abildgade 18 | 751000545 | Område 3 | [NAME] | Ericavej 58  7470 Karup J
Abildgade 2 | 751000383 | Område 3 | Ejerfor.Abildgade 2 | V/Hans Nielsen  Assensgade 19, 5., [NAME].  8000 Århus C
Abildgade 20 | 751000553 | Område 3 | Ejerfore.Abildgade 20 | 852-13  c/o Kuben Ejendomsadm. a/s  Åboulevarden 70 01  8000 Århus C
Abildgade 22 | 751000618 | Område 3 | BRUUN EJENDOMME ApS | Silkeborgvej 201 A  8230 Åbyhøj
Abildgade 23 | 751896905 | Område 3 | Boligforeningen Bo&Liv | Viby Andelsboligforening  Vestergårdsvej 15  8260 Viby J
Abildgade 24 | 751000626 | Område 3 | Per Kaiser Rasmussen | Abildgade 24  8200 Århus N
Abildgade 26 | 751000634 | Område 3 | Abild Invest Aps | c/o [NAME]  Julivej 5  8210 Århus V
Abildgade 28 | 751000642 | Område 3 | [NAME] | Marselis Boulevard 20, 4., [NAME].  8000 Århus C
Spreadsheet: 3f7b42e2-5e33-48e8-b49c-079723856672
Sheet: Sheet1

[NAME]: | Unnamed: 1 | Unnamed: 2 | [NAME] | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Pořadatel: | MO ČRS Tábor | Unnamed: 18 | Unnamed: 19 | Unnamed: 20
Konáno dne: |  | 15.-16.9.2012 | Garant závodu: |  |  |  | Ing. [NAME] |  |  |  |  |  |  |  |  | Hlavní rozhodčí: | Ing. [NAME]
 |  |  | Závod č.1 |  |  |  |  |  | [NAME] |  |  |  |  |  | Jednotlivci |  |  | Družstvo
 | Družstvo (kraj) | Závodník | Los-číslo | Sektor | Počet ryb | Bodů celkem (milimetrů) | Umístění jednotlivci | Součet umístění družstvo | Los-číslo | Sektor | Počet ryb | Bodů celkem (milimetrů) | Umístění jednotlivci | Součet umístění družstvo | Součet umístění jednotlivci | Součet bodů ([NAME]) jednotlivci (1.+ 2.závod) | Celkové umístění  jednotlivci | Součet umístění družstvo | Součet bodů ([NAME]) (1.+ 2.závod) družstvo | Celkové umístění  družstvo
1 | ÚS Města Prahy | Čáha František
2 | ÚS Města Prahy | Hakl Libor
3 | ÚS Města Prahy | Bohuněk jan
4 | ÚS Města Prahy | [NAME]
5 | Středočeský ÚS | Špáda [NAME]
6 | Středočeský ÚS | [NAME]
7 | Středočeský ÚS | [NAME]
8 | Středočeský ÚS | Vokál Pavel, Dr.
9 | Jihočeský ÚS | [NAME]
10 | Jihočeský ÚS | [NAME], [NAME].
11 | Jihočeský ÚS | Straka Jan
12 | Jihočeský ÚS | Měsíček Milan
13 | Východočeský ÚS | [NAME]
14 | Východočeský ÚS | [NAME]
15 | Východočeský ÚS | [NAME]
16 | Východočeský ÚS | [NAME].
17 | Severočeský ÚS | [NAME]
18 | Severočeský ÚS | [NAME]
19 | Severočeský ÚS | [NAME]
20 | Severočeský ÚS | [NAME]
21 | Západočeský ÚS | Abrahám [NAME]
22 | Západočeský ÚS | Ráža Aleš
23 | Západočeský ÚS | [NAME]
24 | Západočeský ÚS | [NAME]
25 | [NAME] a Slezsko | [NAME].
26 | [NAME] a Slezsko | Němec Jan
27 | [NAME] a Slezsko | Kácel Petr
28 | [NAME] a Slezsko | [NAME]
29 | MRS | [NAME]
30 | MRS | [NAME]
31 | MRS | Vojáček David
32 | MRS | Němec Roman
33 | Slovensko | [NAME]
34 | Slovensko | [NAME]
35 | Slovensko | [NAME]
36 | Slovensko | [NAME]
Spreadsheet: 136875d1326859682-auto-populate-on-different-sheet-from-lowest-total-bidder-dollars-and-name-fee-tabulation-example
Sheet: Cont. #

Discipline | Company | Phase I                                        Survey     Design Development |  | Phase II                                         CD's | Phase III                                         CA | Reimbursables | TOTAL
Architectural
 | Architect | 1200 | 4000 | 14700 | 9800 | 1800 | 29700
 | Estimated Reimbursables | 100 | 200 | 750 | 750
Engineering
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Structural
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Fire Protection / Fire Alarm
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Functional Commissioning
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Civil Engineering
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Bldg. Dept. Plan Review Fees
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
GeoTech
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Skylight Energy Modeling
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Expediter & Third Party Reviewer
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Landscaping
 |  |  |  | 800 |  | 0 | 800
 | Estimated Reimbursables
 | Reimbursable Sub-total Per Phase | 100 | 200 | 750 | 750
 | SUB-TOTALS PER PHASE | 1200 | 4000 | 15500 | 9800 | 1800 | 30500
 |  |  | Additional Services NOT INCLUDED in Base Contract
SUB TOTAL | 30500
REIMBURSABLS | 1800
GRAND TOTAL | 32300
Spreadsheet: 827269d1682586249-replace-any-number-from-0-to-9-in-an-alphanumeric-text-with-nothing-test2
Sheet: 工作表1

PUNE 1
PUNE 2
PUNE 4
PUNE 5
PUNE 6
PUNE 7
PUNE1
PUNE2
PUNE3
[NAME]
PUNE5
PUNE6
PUNE7
[NAME]
PUNE-2
[NAME]
MUMBAI (1)
MUMBAI-1
MUMBAI-[1]
MUMBAI-{2}
MUMBAI [1]
MUMBAI {2}
MUMBAI [1] WESTERN
Spreadsheet: 108963d1305890524-use-excel-to-update-stock-levels-for-my-products-bruder-stock-update-test
Sheet: Sheet2

B10/1081 | Home > Toys | 4745 | BRUDER TOYS, [NAME] tractor w/claas disc mower |  | 3
B10/2001 | Home > Toys | 4748 | BRUDER TOYS, Twin tyres with grey rims for tractor Series 02000 |  | 3
B10/2005 | Home > Toys | 4751 | BRUDER TOYS, Front loader for tractor series 02000 |  | 3
B10/20060 | Home > Toys | 4754 | BRUDER TOYS, [NAME] |  | 3
B10/2010 | Home > Toys | 4757 | BRUDER TOYS, [NAME] tipping trailer with removeable top |  | 3
B10/20102 | Home > Toys | 4760 | BRUDER TOYS, Roadmax tractor with front loader |  | 3
B10/20105 | Home > Toys | 4763 | BRUDER TOYS, Roadmax Loader Backhoe |  | 3
B10/2017 | Home > Toys | 4766 | BRUDER TOYS, [NAME] |  | 3
B10/2019 | Home > Toys | 4769 | BRUDER TOYS, Tipping trailer with grey sides |  | 3
B10/2026 | Home > Toys | 4775 | BRUDER TOYS, Lemken Solitair 9 Sowing combination |  | 3
B10/2028 | Home > Toys | 4778 | BRUDER TOYS, Horse trailer including 1 horse |  | 3
B10/2029 | Home > Toys | 4781 | BRUDER TOYS, Cattle trailer including 1 cow |  | 3
B10/2031 | Home > Toys | 4784 | BRUDER TOYS, [NAME] |  | 3
Spreadsheet: 585107d1533632880-deleting-lines-from-a-list-test-6-
Sheet: Sheet1

email | Match
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
Spreadsheet: 113899d1309789014-nested-if-statement-help-example
Sheet: Sheet1

Name | Score | Points |  |  |  | min | [NAME] | Stars
[NAME] | 1.666666666666667 |  | I need a formula in the column to the left of this cell, that tests the data in column B against this matrix to the right.  In plain english, the formula would read " if the value in cell B2, falls between the min and [NAME] limit, then put the corresponding star in the cell.  i.e in the cell b2 example, it should say 2 stars (as the value 1.7 is between1.7 and 2.24 (cells highlited to right) |  |  | 0 | 0.24 | 0
[NAME] | 1.872340425531915 |  |  |  |  | 0.25 | 0.74 | 0.5
[NAME] | 2.477272727272727 |  |  |  |  | 0.75 | 1.24 | 1
Fred | 2.772727272727273 |  |  |  |  | 1.25 | 1.74 | 1.5
Julie | 2.895833333333333 |  |  |  |  | 1.75 | 2.24 | 2
Trevor | 2.958333333333333 |  |  |  |  | 2.25 | 2.74 | 2.5
Etc | 2.979166666666667 |  |  |  |  | 2.75 | 3.24 | 3
Etc | 3 |  |  |  |  | 3.25 | 3.74 | 3.5
Etc | 3 |  |  |  |  | 3.75 | 4.24 | 4
 |  |  |  |  |  | 4.25 | 4.74 | 4.5
 |  |  |  |  |  | 4.75 | 5 | 5
Spreadsheet: 80186d1280391093-retrieve-values-on-multiple-conditions-packages
Sheet: Customers Order

Customer | Material code | Day of shipment | Quantity orderded
A | 123 | 2010-08-02 00:00:00 | 15000
A | 133 | 2010-08-02 00:00:00 | 30000
B | 124 | 2010-08-03 00:00:00 | 50000
B | 134 | 2010-08-04 00:00:00 | 100000
C | 125 | 2010-08-04 00:00:00 | 13
D | 126 | 2010-08-05 00:00:00 | 250000
D | 136 | 2010-08-05 00:00:00 | 500
I | 141 | 2010-08-05 00:00:00 | 19
Spreadsheet: 8e9e4932-4143-4d9c-a48d-d9845a3748d2
Sheet: Sheet1

Tähän kilp. järjestäjä | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Klo 10:00-11:30 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | <- tähän punnitusaika
Tähän kilpailun nimi
Tähän kilpailupaikka
Tähän pvm. [NAME]. alkamisaika
 |  |  |  |  | Kehon-
Nro | Ikäl. | Sarja kg | Nimi / SV. | Seuran lyh. | paino | JK. ap. | PP. ap. | MN. ap. | Ryhmä | Täytä vain tämä "[NAME]" taulukko. Syötetyt tiedot menevät automaattisesti muihin taulukoihin.
1 | M | 120+ | [NAME] 75 | SeuRa1 |  |  |  |  | 1
2 | N | 84+ | [NAME] 80 | [NAME] |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | Täytä sarakkeet A - E ilmoittautumisten perusteella.                [NAME] mainitut tiedot voidaan täyttää  myös koneellisesti punnituksessa, [NAME] siirtyvät automaattisesti kilpailijakortteihin, [NAME] ne voidaan tulostaa [NAME].           Huom! Ilmoittautumisajan päättymisen jälkeen taulukko on lajiteltava nousevaan järjestykseen A -sarakkeeseen syötettyjen arpanumeroiden perusteella. Lajittelu tapahtuu klikkaamalla "Lajittele" -makroa.
 |  |  |  |  |  |  |  |  |  | Huom! [NAME] juoksevaa
 |  |  |  |  |  |  |  |  |  | [NAME] (arpan.).
 |  |  |  |  |  |  |  |  |  | Alkuun
 |  |  |  |  |  |  |  |  |  | Alkuun
 |  |  |  |  |  |  |  |  |  | <- viimeinen rivi
Spreadsheet: 217331d1362046686-if-with-vlookup-if-with-vlookup-1-
Sheet: IF WITH VLOOKUP

Sl.No | NL NO | Nature Of Claim | Amount Claimed (Rs) | Approved Amt |  |  |  | REMAINING | PC 71
1 | NL22447 | NEW MACHINE COMMISSIONING | 4000 |  |  | NEW MACHINE COMMISSIONING | 1 | 5000 | 4000
6 | NL31467 | 3000 HOURS MANDATORY SERVICE | 5000 |  |  | 250 HOURS MANDATORY SERVICE | 2 | 3000 | 3000
3 | NL22447 | 500 HOURS MANDATORY SERVICE | 4000 |  |  | 500 HOURS MANDATORY SERVICE | 3 | 3500 | 3000
4 | NL31578 | 1000 HOURS MANDATORY SERVICE | 5000 |  |  | 1000 HOURS MANDATORY SERVICE | 4 | 3500 | 3000
5 | NL2285 | 2000 HOURS MANDATORY SERVICE | 4000 |  |  | 2000 HOURS MANDATORY SERVICE | 5 | 3500 | 3000
2 |  | 250 HOURS MANDATORY SERVICE |  |  |  | 3000 HOURS MANDATORY SERVICE | 6 | 3500 | 3000
 |  | IF(B2="NL22",VLOOKUP(C2,$G$2:$J$7,4,0),IF(C2="","",VLOOKUP(C2,$G$2:$J$7,3,0)))
 |  | 4000
MY POINT IS : |  | IF(B2,STARTS WITH NL22, VLOOKUP,C2,G2:[NAME],C2,G2:J7,3,0)
Spreadsheet: 748698d1632303014-new-formulas-sort-and-sortby-can-i-use-it-with-not-neighboring-columns-zeszyt1
Sheet: Arkusz1

name | DRST | TYPE | DATE | PRICE |  | xxx
xxx | DRST05658PL10001 | OHO 213 080070080 S23 0 GN B 0 | 2021-09-01 00:00:00 | 0.9409678298898129 |  |  |  | OHO 213 100080100 S23 0 BL 0 0
yyy | DRST05655PL10001 | OHO 213 080070080 S23 0 RD B 0 | 2021-09-02 00:00:00 | 0.9216978732937106 |  |  | DRST00738PL10004 | THO 216 080070080 W23 0 RD B 0
ooo | DRST05655PL10003 | OHO 213 080070080 S23 0 RD B 0 | 2021-09-03 00:00:00 | 0.7535139630712563 |  |  | DRST09717PL10001 | THO 216 100080100 W23 0 BL B C
ttt | DRST05618PL10001 | OHO 213 100080100 S23 0 BK 0 0 | 2021-09-04 00:00:00 | 0.5125855840769149 |  |  | DRST01517PL10002 | THO 216 100080100 W23 0 RD 0 0
xxx | DRST05616PL10004 | OHO 213 100080100 S23 0 BL 0 0 | 2021-09-05 00:00:00 | 0.8787610191227516
yyy | DRST05612PL10001 | OHO 213 100080100 S23 0 RD B 0 | 2021-09-06 00:00:00 | 0.8558042951245319
ooo | DRST05619PL10001 | OHO 213 100080100 S23 0 WH 0 0 | 2021-09-07 00:00:00 | 0.198637630591553
ttt | [NAME] | OHO 213 100090100 C20 0 BL 0 0 | 2021-09-08 00:00:00 | 0.05388230231598057
xxx | DRST00738PL10004 | THO 216 080070080 W23 0 RD B 0 | 2021-09-09 00:00:00 | 0.8015899088002002
yyy | DRST00738PL10002 | THO 216 080070080 W23 0 RD B 0 | 2021-09-10 00:00:00 | 0.06846588705697942
ooo | DRST02138PL10001 | THO 216 080080080 W20 0 RD B 0 | 2021-09-11 00:00:00 | 0.240623326200189
ttt | DRST00699PL10003 | THO 216 100080100 W23 0 BL B 0 | 2021-09-12 00:00:00 | 0.3033700107041997
xxx | DRST09717PL10001 | THO 216 100080100 W23 0 BL B C | 2021-09-13 00:00:00 | 0.5751464777153367
yyy | DRST09717PL10002 | THO 216 100080100 W23 0 BL B C | 2021-09-14 00:00:00 | 0.2846522966957304
ooo | DRST02058PL10001 | THO 216 100080100 W23 0 OR B 0 | 2021-09-15 00:00:00 | 0.8020376955302118
ttt | DRST01517PL10001 | THO 216 100080100 W23 0 RD 0 0 | 2021-09-16 00:00:00 | 0.5427677925214598
xxx | DRST01517PL10002 | THO 216 100080100 W23 0 RD 0 0 | 2021-09-17 00:00:00 | 0.206771443645289
yyy | DRST00830PL10001 | THO 216 100080100 W23 0 WH 0 0 | 2021-09-18 00:00:00 | 0.577008090738554
ooo | DRST05561PL10001 | ZZO ZZZ 999999999 ZZZ Z ZZ Z Z | 2021-09-19 00:00:00 | 0.9693344446118984