tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 029f1dc9-b1ca-4ac3-840b-7d40499cc313
Sheet: Sheet1

AMMTOX | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | [NAME]
Control Panel |  |  |  | [NAME] exceeded? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chronic Conditions for January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Acute Conditions for January
Scenario Definition | Entered | In Use
Month | 1 | January
 |  | ELS Present
User-supplied Information
Site Name:
Nominal Reach Length, mi | 0.1
Salmonids present? (Y or N) | Y | Salmonids Present
ELS present? (Y or N) |  |  | Y
Jan | Y | ELS Present
Feb | Y | ELS Present
Mar | Y | ELS Present
Apr | Y | ELS Present |  |  | Enter Source | CHRONIC TOTAL AMMONIA, mg/L
May | Y | ELS Present |  | WWTP | Offset Here | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
Jun | Y | ELS Present |  | Name of WWTF | 1
Jul | Y | ELS Present |  | not in use
Aug | Y | ELS Present |  | not in use
Sep | Y | ELS Present |  | not in use
Oct | Y | ELS Present |  | not in use
Nov | Y | ELS Present |  | not in use
Dec | Y | ELS Present
Rebound Rates
Temperature, oC/mi | 0.7 | Default |  | Acute [NAME] exceeded?
pH, s.u./mi | 0.2 | Default
Velocity Equation
coefficient a, V=aQb | 0.3 | Default
exponent b, V=aQb | 0.4 | Default
Seepage Conditions
Accrual Rate, cfs/mi | 0 | Default
Ammonia conc, mg/L | 0 | Default
Ammonia Removal Rate
K3 at 20 oC | 6 | Default
Temperature Adj Factor | 1.08
 |  |  |  |  | Source | ACUTE TOTAL AMMONIA, mg/L
Minimum Flow, cfs | 0.001 |  |  | WWTP | Offset | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
 |  |  |  | Name of WWTF | 1
 |  |  |  | not in use | 0
 |  |  |  | not in use | 0
 |  |  |  | not in use | 0
Things you can change, but probably shouldn't |  |  |  | not in use | 0
R, acute | 0.275 | Default |  | not in use | 0
R, chronic | 0.0577 | Default
pHT, acute | 7.204 | Default |  | Warnings |  | < - Signifies acute is less than chronic
pHT, chronic | 7.688 | Default |  | Name of WWTF
B, acute | 39 | Default |  | not in use
B, chronic | 2.487 | Default |  | not in use
Fish [NAME] (ELS) | 2.85 | Default |  | not in use
Fish [NAME] (no ELS) | 8.78 | Default |  | not in use
Fish GMCV in use | 2.85 |  |  | not in use
invertebrate GMCV | 1.45 | Default
invertebrate slope | 0.028 | Default
invertebrate reference [NAME] | 25 | Default
invertebrate low temp cutoff | 7 | Default
Spreadsheet: 46939d1245857644-splitting-names-with-inconsistent-formats-split-names
Sheet: Sheet1

 |  |  |  |  |  | What I Have
 |  |  |  |  |  | Name | First Name | Last Name | Other First Name | Other Last Name
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Doe, [NAME]
 |  |  |  |  |  | Doe, J
 |  |  |  |  |  | Doe, [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Doe
 |  |  |  |  |  | Estate of [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Doe Sr, [NAME]
 |  |  |  |  |  | Doe Sr, [NAME]
 |  |  |  |  |  | Doe        ,J
 |  |  |  |  |  | Doe,[NAME]
 |  |  |  |  |  | Doe [NAME]
 |  |  |  |  |  | What I Would Like To Have
 |  |  |  |  |  | Name | First Name | Last Name | Other First Name | Other Last Name
 |  |  |  |  |  | [NAME] | [NAME] | Doe
 |  |  |  |  |  | Doe, [NAME] | [NAME] | Doe
 |  |  |  |  |  | Doe, J | [NAME] | Doe
 |  |  |  |  |  | Doe, [NAME] | [NAME] | Doe
 |  |  |  |  |  | [NAME] | [NAME] | Doe
 |  |  |  |  |  | [NAME] | [NAME] | Doe
 |  |  |  |  |  | Doe | Mr or MRS | Doe
 |  |  |  |  |  | Estate of [NAME] | Estate of John | Doe
 |  |  |  |  |  | [NAME] | [NAME] | Doe | [NAME] | Doe
 |  |  |  |  |  | Doe Sr, [NAME] | [NAME] | Doe Sr
 |  |  |  |  |  | Doe Sr, [NAME] | [NAME] | Doe Sr
 |  |  |  |  |  | Doe        ,J | J | Doe
 |  |  |  |  |  | Doe,[NAME] | [NAME] | Doe
 |  |  |  |  |  | Doe [NAME] | [NAME] | Doe
Spreadsheet: 35712d1233319126-search-word-within-cell-vlookup-search-prob
Sheet: Sheet1

Account Heads | Data | Account Heads Identified
Postage | OpExp-Salary&Wages
Stationery | IncntveComp&VarIncent.Comp
rental | OperatingExpenses-Salaries
Software | ContinuityofService&HCare
Subscription | OpExp-OthEmployeeCosts
Tax | OpExp-CostofSales
salary | OpExps-Postage
Advertising | OpExps-Stationery&OfficeSupplies
Meetings | OpExps-Subscriptions
Telephone | OpExps-Telephone&TelegraphExp
Travel | T&LExpense-RegularTaxRate
cars | OpExp-Travel&LivingNonTx
Equip | OpExp-Travel&Living80%ExCan
Sales | OpExp-Transfer&Living
Operating | OpExp-MeetingsRegTx
incometax | OpExp-MeetingsNonTx
admin | OpExp-NonUSEntertainment-NonTx
cardfee | OpExp-CompanyCars
 | OpExp-LeasedCars
 | OpExp-Rental-Bldg/Facilities
 | OpExp-Rental-Furn/Equip
 | OpExp-Rental-Computers
 | [NAME]
 | OpExp-OtherFurn/Equip/CompExp
 | OtherExp-SoftwareExpense
 | OpExp-AmortIntang-Software
 | OpExp-AmortIntang-Other
 | ComputerSoftwareAmort-Exp
 | OpExp-ELTO-Maint/OtherExp
 | OpExp-CusrServ/Collection
 | CustSvc-FACS
 | CustSvc-CollectAgency
 | CustSvc-CollectAttorney
 | CustSvc-CCCS
 | CustSvc-CreditSvc
 | CustSvc-Repo
 | CustSvc-FilingFee
 | CustSvc-Concessions
 | CardProcessingSvc
 | MasterCardFees
 | OpExp-RetailerInq-ChrgbackRevsl-PLCC
 | OpExp-RetailerInq-ChrgbackRevsl-3rdPty
 | OpExp-RetailerInq-Fraud
 | OpExp-RetailerInq-DropSale
 | OpExp-RetailerInq-CompData
 | OpExp-RetailerInq-RetailerSat
 | OpExp-CusrServ/Collection
 | OpExps-LoanOriginationCosts
 | OpExps-LegalExp
 | OpExps-AdvertisingExp
 | OpExps-SalesPromotionExp
 | OpExps-DirectMail
 | OpExp-Foreclosed/DeededOverRealEstateExps
 | OpExps-TroubledProjectExps
 | OpExps-DataProcessingExp
 | OperatingExpenses
 | OpExp-CharitableContrib
 | OpExp-AssociationExpNonTx
 | OpExp-OutsdeSvcs/Fees-TempSvcs
 | OpExp-OtsdeSvcs/Fees-Consultng
 | OpExp-OtsdeSvcs/Fees-Trn&Edu.
 | OpExp-OtsdeSvcs/Fees-Other
 | OutsideSvcs-GlobalDevelopmentCtr.
 | OperatingExpenses
 | OpExp-S/LTax-Franchise
 | OpExp-S/LTax-AnnualReport
 | OpExp-S/LTax-LicenseFees
 | OpExp-S/LTax-Intangibles
 | OpExp-S/LTax-Sales/Use
 | OpExp-S/LTax-Property
 | OpExp-S/LTax-SalesPenalties
 | OpExp-S/LTax-InterestonStateTx
 | OpExp-S/LTax-InsurancePremiums
 | OpExp-S/LTax-Other
 | OpExp-S/LTax-ReclassIncomeTax
 | OpExp-Non-DeductiblePenalty
 | [NAME]
 | [NAME]
 | OpExp-FgnNonIncTxVATPnltyNonTx
 | [NAME]
 | [NAME]
 | OpExp-AllOther
 | OpExp-LossAdjustment
 | Deprec&AmortofBldgs&Equip
 | ExpAssessments
 | GrossOp&AdminExps-BusSharing
 | GrossOp&AdmNonProductivityExps-BusShar
 | ProductivityExps-BusSharGrossOp&AdmBusSharGECIS
 | GECCorp.Inter-CompanyExps
Spreadsheet: 707474d1607312400-how-to-extract-the-first-uppercase-english-letter-of-blank-words-with-formula-1207
Sheet: Sheet1

Cash On Delivery | COD | COD
Digital Company | DC | DC
Bank Facilities | BF | BF
Because Of You | BOY | BOY
Because of You | BY | BY
[NAME] Of Material | BOM | BOM
Teacher Many Thank You For Your Reply | TMTYFYR | TMTYFYR
Teacher Many Thank You for your reply | TMTY | TMTY
Is this you Want ? | IW | IW
Spreadsheet: 842369d1694464517-if-and-return-value-based-on-2-sets-of-conditions-sample-81-2-3-
Sheet: Sheet1

County | Amount Total | purchased in contract | Blue URL | New GN (Listing) | Renewal GN (Listing) | Payment Type (F, M, Q, S) | New SP | Renewal SP | Payment Type (F, M, Q, S)
Yuma | 1000 | get noticed, social, dues |  |  |  |  |  | 1000 | m
Maricopa | 1500 | power listings/dues |  |  |  |  | 1500 |  | M
Maricopa | 3500 | 3rd tier, dues |  |  |  |  |  | 3500 | M
San Diego | 3000 | Tier 3 |  |  | 3000 | M |  | M
Maricopa | 4500 | bottom banner/4th tier |  |  |  |  |  | 4500 | M
San Diego |  | Torch Awards - SD - Table Sponsor $1,000 | https://bluebbb.org/core/manage/?firm=[PHONE] |  |  |  |  | 1125 | f
San Diego | 2200 | Tier 1 |  |  | 2200 | M |  | M
Orange | 5012 | Tier 1 listing |  | 5012 |  | M
Maricopa | 3000 | tier 2 |  |  | 3000 | M
 | 1000 | Renewal SP
 | 1500 | New SP
 | 3500 | Renewal SP
 | 3000 | Renewal GN (Listing)
 | 4500 | Renewal SP
 | 0 | Renewal SP
 | 2200 | Renewal GN (Listing)
 | 5012 | New GN (Listing)
 | 3000 | Renewal GN (Listing)
Spreadsheet: 05f31921-50fa-4597-bd68-7be67b143a01
Sheet: Sheet1

Unnamed: 0 | State of New Hampshire - Primary Election | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
2012-09-11 00:00:00 | Governor - Republican
Coos County | Ovide Lamontagne, r | [NAME], r | [NAME], r | [NAME], d | [NAME], d | [NAME], d | [NAME]
At. & Gil. Academy Grant | 0 | 0 | 0
Bean's Grant | 0 | 0 | 0
Bean's Purchase | 0 | 0 | 0
Berlin | 436 | 94 | 6 | 11 | 6 | 2
Cambridge | 1 | 1 | 0
Carroll | 46 | 23 | 3
[NAME]'s Purchase | 0 | 0 | 0
[NAME] | 30 | 23 | 0
Colebrook | 154 | 110 | 7 |  |  |  | 1
Columbia | 49 | 39 | 2 |  | 2
Crawford's Purchase | 0 | 0 | 0
Cutt's Grant | 0 | 0 | 0
[NAME] | 59 | 35 | 5
Dix's Grant | 0 | 0 | 0
Dixville | 5 | 1 | 0
Dummer | 34 | 8 | 0
Errol | 49 | 8 | 0 | 1
Erving's Location | 0 | 0 | 0
[NAME] | 186 | 30 | 5 | 8 | 2
Green's Grant
Hadley's Purchase | 0 | 0 | 0
[NAME] | 117 | 45 | 3 | 2 | 5
Kilkenny | 0 | 0 | 0
Lancaster | 274 | 99 | 10 | 3 | 2 |  | 2
Low & Burbank's Grant | 0 | 0 | 0
Martin's Location | 0 | 0 | 0
Milan | 111 | 17 | 0 | 4 | 1
[NAME] | 14 | 2 | 0
Northumberland | 93 | 48 | 4 | 4 | 3 |  | 1
[NAME] | 0 | 0 | 0
[NAME]'s Grant | 0 | 0 | 0
Pittsburg | 115 | 63 | 4 |  | 2
Randolph | 30 | 17 | 0 | 1
Sargent's Purchase | 0 | 0 | 0
Second College Grant | 0 | 0 | 0
Shelburne | 44 | 9 | 0
[NAME] | 37 | 13 | 1 | 3
Stewartstown | 47 | 45 | 2 | 1 | 1
[NAME] | 30 | 10 | 1
Success | 0 | 0 | 0
Thompson & Meserve's Pur. | 0 | 0 | 0
Wentworth's Location | 1 | 0 | 0
[NAME] | 147 | 60 | 4 |  | 1 |  | 2
TOTALS | 2109 | 800 | 57 | 38 | 25 | 2 | 6
Spreadsheet: 467059d1466544259-conditional-format-calendar-5-5-2-2
Sheet: Apr

 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  | Notes
Spreadsheet: 755351d1636804491-averaging-only-some-data-in-a-row-of-cells-golf-group-spreadsheet
Sheet: Purse Payouts

 | No. of Golfers | No. of Teams | CTP #1 | CTP #2 | 1st Place | 2nd Place | Total Purse
 | 6 | 2 | 3 | 3 | 18 | 0
 | 7 | 2 | 3.5 | 2.5 | 21 | 0 | 21
 | 8 | 2 | 4 | 4 | 24 | 0 | 24
 | 9 | 3 | 4.5 | 4.5 | 18 | 9 | 27
 | 10 | 3 | 5 | 5 |  | 10 | 30
 | 11 | 3 | 5.5 | 5.5 |  | 11 | 33
 | 12 | 3 | 6 | 6 |  | 12 | 36
 | 13 | 4 | 6.5 | 6.5 | 26 | 13 | 39
 | 14 | 4 | 7 | 7 | 28 | 14 | 42
 | 15 | 4 | 7.5 | 7.5 | 30 | 15 | 45
 | 16 | 4 | 8 | 8 |  | 16 | 48
 | 17 | 5 | 8.5 | 8.5 |  | 17 | 51
 | 18 | 5 | 9 | 9 |  | 18 | 54
 | 19 | 5 | 9.5 | 9.5 | 32 | 19 | 57
 | 20 | 5 | 10 | 10 | 34 | 20 | 60
 | 21 | 6 | 10.5 | 10.5 | 36 | 21 | 63
 | 22 | 6 | 11 | 11 |  | 22 | 66
 | 23 | 6 | 11.5 | 11.5 |  | 23 | 69
 | 24 | 6 | 12 | 12 |  | 24 | 72
Spreadsheet: f6638bae-5028-4c23-834b-28cb354768bc
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
9943 | Test | 9943 | Warthin-Starry Stain | Warthin-Starry ST | Includes pathology consultation charged separately. | Formalin-fixed, paraffin-embedded tumor tissue block. Include 1 H & E slide: FFPTHE |  |  |  | Varies | Container/Tube:  Preferred: Formalin-fixed, paraffin-embedded tissue block Acceptable: Tissue in formalin Collection Instructions: Include 1 hematoxylin-and-eosin stained slide. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | The laboratory will provide a pathology consultation and stained slide. | Monday through Friday 7 a.m. | 2 days | 5 days | 1 | 88312 |  |  |  |  | Rochester
9943 | [NAME] | TISSUE | Tissue |  |  |  | Ambient
9943 | Result | 9943 | Warthin-Starry ST | Warthin-Starry ST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 679-1 | Microscopic observation:Prid:Pt:[NAME]:Nom:Warthin-Starry stain
Spreadsheet: 740376d1626300654-display-text-dependent-upon-todays-date-eh_date-return
Sheet: Sheet1

 |  |  |  |  |  |  | JULY
 |  |  |  |  |  |  | Mo | [NAME] | We | Th | Fr | Sa | Su
WORKING |  | 26 | 3 | DELIVERING |  | 2 |  |  |  | 1 | 2 | 3 | 4
 |  | 27 | 4 |  |  | 3 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | P8 | 28 | 1 |  |  | 4 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | P8 | 29 | 2 |  | P7 | 1 | 19 | 20 | 21 | 22 | 23 | 24 | 25
 | P8 | 30 | 3 |  | P7 | 2 | 26 | 27 | 28 | 29 | 30 | 31
WORKING:
We are in Working, P8
DELIVERING
We are in Delivering, P7
Spreadsheet: 709735d1608536368-enter-two-conditions-to-query-the-size-forum1221
Sheet: Sheet1

Model | Size | inlet * Outlet |  |  | Model | Size | in
 |  | in | [NAME] |  | T5 | 4
T5 | 1 | 1/2" * 5/8"
T5 | 2 | 1/2" * 5/8"
T5 | 3 | 1/2" * 7/8"
T5 | 4 | 5/8" * 7/8"
T5 | 5 | 7/8" * 1-1/8"
T12 | 1 | 5/8" * 7/8"
T12 | 2 | 5/8" * 7/8"
T12 | 3 | 7/8" * 1"
T12 | 4 | 7/8" * 1"
T12 | 5 | 7/8" * 1-1/8"
T12 | 6 | 7/8" * 1-1/8"
T20 | 1 | 7/8" * 1-1/8"
T55 | 1 | 1-1/8" * 1-3/8"
T55 | 2 | 1-1/8" * 1-3/8"
 |  |  | TABLE
Spreadsheet: 265799d1379410197-copying-date-from-text-l-drr-example1
Sheet: גיליון1

 | date | lab | # | site | notes | QD | SSD | WA | PSD | UCS | PL
2013.6.26,MAGAMA 219641,ZANUAH,QD(2.48),SSD(2.58),WA(3.4)-OK.pdf | 2013.6.26 | [NAME] | 219641 | ZANUAH | OK | 2.48 | 2.58 | 3.4
2013.6.26,MAGAMA 219642,ZANUAH,PSD(NC,136),UCS(26.7),PL(2.9)-OK.pdf | 2013.6.26 | [NAME] | 219642 | ZANUAH | OK |  |  |  | NC,136 | 26.7 | 2.9
2013.6.26,MAGAMA 219641,ZANUAH,QD(2.48),SSD(2.58),WA(3.4)-OK.pdf
2013.6.26,MAGAMA 219642,ZANUAH,PSD(NC,136),UCS(26.7),PL(2.9)-OK.pdf
Spreadsheet: mark_taylor__25008__Week 11 Results
Sheet: Sheet1

College Football Pool
2001-2002
 | Name | Pd | Wk 1 | Wk 2 | Wk 4 | Wk 5 | Wk 6 | Wk 7 | Wk 8 | Wk 9 | Wk 10 | Wk 11 | Wk 12 | Wk 13 | Cumulative | Ave/Week
1 | [NAME] | x | 7 | 5 | 11 | 14 | 9 | 8 | 7 | 14 | 14 | 7 | 0 | 0 | 96 | 9.6
2 | [NAME] | x | 15 | 15 | 13 | 6 | 7 | 7 | 5 | 11 | 8 | 7 | 0 | 0 | 94 | 9.4
3 | [NAME] | x | 11 | 5 | 14 | 11 | 5 | 5 | 15 | 2 | 13 | 11 | 0 | 0 | 92 | 9.2
4 | [NAME] | x | 7 | 4 | 15 | 4 | 8 | 12 | 7 | 12 | 5 | 15 | 0 | 0 | 89 | 8.9
5 | [NAME] | x | 8 | 9 | 5 | 11 | 12 | 6 | 9 | 2 | 9 | 11 | 0 | 0 | 82 | 8.2
6 | [NAME] | x | 9 | 15 | 7 | 3 | 15 | 10 | 2 | 6 | 10 | 3 | 0 | 0 | 80 | 8
6 | [NAME] | x | 5 | 7 | 8 | 10 | 7 | 11 | 7 | 2 | 9 | 14 | 0 | 0 | 80 | 8
8 | [NAME] | x | 6 | 10 | 7 | 15 | 3 | 6 | 6 | 3 | 15 | 6 | 0 | 0 | 77 | 7.7
8 | [NAME] | x | 12 | 13 | 6 | 11 | 6 | 5 | 6 | 5 | 3 | 10 | 0 | 0 | 77 | 7.7
10 | [NAME] | x | 3 | 5 | 11 | 14 | 15 | 4 | 0 | 6 | 9 | 7 | 0 | 0 | 74 | 7.4
11 | [NAME] | x | 14 | 3 | 7 | 10 | 8 | 10 | 5 | 1 | 11 | 4 | 0 | 0 | 73 | 7.3
11 | [NAME] | x | 4 | 2 | 9 | 7 | 15 | 1 | 10 | 12 | 6 | 7 | 0 | 0 | 73 | 7.3
13 | [NAME] | x | 4 | 11 | 8 | 10 | 9 | 3 | 7 | 5 | 7 | 8 | 0 | 0 | 72 | 7.2
14 | [NAME] | x | 4 | 10 | 8 | 5 | 8 | 12 | 9 | 6 | 8 | 1 | 0 | 0 | 71 | 7.1
14 | [NAME] | x | 11 | 11 | 4 | 3 | 15 | 2 | 6 | 6 | 3 | 10 | 0 | 0 | 71 | 7.1
16 | [NAME] | x | 15 | 10 | 10 | 2 | 7 | 3 | 9 | 0 | 4 | 10 | 0 | 0 | 70 | 7
17 | [NAME] | x | 12 | 5 | 9 | 4 | 9 | 9 | 6 | 9 | 0 | 6 | 0 | 0 | 69 | 6.9
18 | [NAME] | x | 12 | 0 | 10 | 5 | 11 | 5 | 6 | 6 | 11 | 2 | 0 | 0 | 68 | 6.8
18 | [NAME] | x | 5 | 9 | 7 | 15 | 8 | 7 | 2 | 4 | 6 | 5 | 0 | 0 | 68 | 6.8
20 | [NAME] | x | 6 | 5 | 8 | 8 | 10 | 3 | 3 | 5 | 9 | 10 | 0 | 0 | 67 | 6.7
21 | [NAME] | x | 0 | 10 | 8 | 11 | 6 | 5 | 3 | 4 | 9 | 10 | 0 | 0 | 66 | 6.6
22 | [NAME] | x | 13 | 1 | 7 | 9 | 6 | 6 | 8 | 3 | 9 | 1 | 0 | 0 | 63 | 6.3
22 | [NAME] | x | 8 | 12 | 10 | 3 | 9 | 8 | 1 | 3 | 6 | 3 | 0 | 0 | 63 | 6.3
24 | [NAME] | x | 5 | 13 | 5 | 6 | 6 | 5 | 10 | 1 | 5 | 6 | 0 | 0 | 62 | 6.2
25 | [NAME] | x | 3 | 5 | 10 | 1 | 10 | 6 | 9 | 7 | 6 | 3 | 0 | 0 | 60 | 6
26 | [NAME] | x | 2 | 3 | 4 | 6 | 8 | 5 | 10 | 0 | 9 | 2 | 0 | 0 | 49 | 4.9
 | Totals | 26 | 15 | 15 | 15 | 15 | 15 | 12 | 15 | 14 | 15 | 15 | 0 | 0 | 96 | 9.6
 | Average Weekly |  | 7.730769230769231 | 7.615384615384615 | 8.5 | 7.846153846153846 | 8.923076923076923 | 6.307692307692307 | 6.461538461538462 | 5.192307692307693 | 7.846153846153846 | 6.884615384615385 | 0 | 0 | 73.3076923076923 | 7.330769230769231
 | Weekly Payout |  | pd | pd | pd | pd | pd | pd | pd | pd | pd
Spreadsheet: 705005d1605843764-conditional-formatting-with-special-conditions-example1
Sheet: Tabelle1

 |  |  | Year |  |  | Year | Quarter # |  | Year | Month # |  | Year | Week # (1st week start at 1st Jan)
 |  |  | 2000 |  |  | 2000 | 4 |  | 2000 | 10 |  | 2000 | 48
Exchange Date | Close |  | Min | [NAME] |  | Min | [NAME] |  | Min | [NAME] |  | Min | [NAME]
2000-10-26 00:00:00 | 237.684725493749
2000-10-27 00:00:00 | 237.64374063874
2000-10-30 00:00:00 | 238.412418458566
2000-10-31 00:00:00 | 236.941951072185
2000-11-01 00:00:00 | 238.889855387626
2000-11-02 00:00:00 | 239.731786879304
2000-11-03 00:00:00 | 239.419944906244
2000-11-06 00:00:00 | 240.564086455401
2000-11-07 00:00:00 | 241.283209897426
2000-11-08 00:00:00 | 243.187068090659
2000-11-09 00:00:00 | 245.563744442296
2000-11-10 00:00:00 | 247.361184941768
2000-11-13 00:00:00 | 250.19186158902
2000-11-14 00:00:00 | 251.907989320189
2000-11-15 00:00:00 | 251.5350135318
2000-11-16 00:00:00 | 253.220736230413
2000-11-17 00:00:00 | 252.900844519084
2000-11-20 00:00:00 | 253.855325626064
2000-11-21 00:00:00 | 253.4223177832
2000-11-22 00:00:00 | 255.285327728249
2000-11-23 00:00:00 | 256.032737376178
2000-11-24 00:00:00 | 248.054458256321
2000-11-27 00:00:00 | 247.604614641218
2000-11-28 00:00:00 | 251.204561653599
2000-11-29 00:00:00 | 249.775895812696
2000-11-30 00:00:00 | 250.143518127015
2000-12-01 00:00:00 | 251.506251887648
2000-12-04 00:00:00 | 252.76232013628
2000-12-05 00:00:00 | 252.708710885586
2000-12-06 00:00:00 | 250.770448230035
2000-12-07 00:00:00 | 250.700012081672
2000-12-08 00:00:00 | 250.475781995675
2000-12-11 00:00:00 | 247.191233856451
2000-12-12 00:00:00 | 248.765026398135
2000-12-13 00:00:00 | 248.413676452821
2000-12-14 00:00:00 | 247.810627295573
2000-12-15 00:00:00 | 246.39522520781
2000-12-18 00:00:00 | 247.003286056009
2000-12-19 00:00:00 | 247.551345865752
2000-12-20 00:00:00 | 250.246831543211
2000-12-21 00:00:00 | 250.928619756428
2000-12-22 00:00:00 | 250.041436630948
2000-12-25 00:00:00 | 249.870001208167
2000-12-26 00:00:00 | 250.850680810449
2000-12-27 00:00:00 | 248.670291168297
2000-12-28 00:00:00 | 248.088812650246
2000-12-29 00:00:00 | 250.498586512674
Spreadsheet: 53ef16c5-7eb5-4a71-a1e0-cfcebc600751
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Wilkau-Haßlau, Stadt - Variante 2
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 1453 | 1512 | 1457 | 1314
20 - 60 | 5405 | 4942 | 4420 | 3797
60 und mehr | 3916 | 3950 | 3906 | 4013
Insgesamt | 10774 | 10404 | 9783 | 9124
%
unter 20 | 13.48617041024689 | 14.53287197231834 | 14.89318205049576 | 14.40157825515125
20 - 60 | 50.16706886950065 | 47.50096116878124 | 45.180415005622 | 41.61551950898728
60 und mehr | 36.34676072025245 | 37.96616685890042 | 39.92640294388224 | 43.98290223586147
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 26.88251618871416 | 30.59490084985836 | 32.96380090497738 | 34.60626810639979
Altenquotient | 72.45143385753931 | 79.92715499797653 | 88.37104072398189 | 105.6887016065315
Gesamtquotient | 99.33395004625348 | 110.5220558478349 | 121.3348416289593 | 140.2949697129313
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 681365d1591529785-reopened-lining-up-row-of-numbers-with-column-of-numbers-using-index-match-vlookup-question
Sheet: Sheet1

LIST 1 | LIST 2 | LIST 3 | LIST 4 | LIST 5 | LIST 6 | LIST 7 | LIST 8 | LIST 9 | LIST 10 | LIST 11 | LIST 12 | LIST 13 | LIST 14 | LIST 15 | LIST 16
1 | 1 | 3 | 2 | 7 | 6 | 3 | 2 | 4
1 | 2 |  |  |  |  |  |  |  |  | 2 |  |  |  | 2
1 | 3 |  |  |  |  |  |  |  | 3 |  |  |  | 3
1 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
1 | 5
1 | 6 |  |  |  |  |  |  |  |  |  |  | 6
1 | 7 |  |  |  |  |  |  |  |  |  | 7
1 | 8
1 | 9
1 | 10
 |  |  |  |  |  |  |  |  | VLOOKUPS
LIST 1 | LIST 2 | LIST 3 | LIST 4 | LIST 5 | LIST 6 | LIST 7 | LIST 8 | LIST 9 | LIST 10 | LIST 11 | LIST 12 | LIST 13 | LIST 14 | LIST 15 | LIST 16
1 | 1 | 3 | 2 | 7 | 6 | 3 | 2 | 4
1 | 2
1 | 3
1 | 4
1 | 5
1 | 6
1 | 7
1 | 8
1 | 9
1 | 10
Spreadsheet: 45806d1244595486-pulling-inventory-number-from-a-range-sandbox
Sheet: Master

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inventory search
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | From |  | To
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | set 1 | 002000 |  | 002020 | 58
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | set 2 | 061001 |  | 061020 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | set 3 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | set 4 |  |  |  | 0
APN
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
Spreadsheet: 767830d1644666117-what-if-analysis-to-calculate-the-effect-of-new-pricing-example-calculation-update
Sheet: Current Sales

 |  |  |  |  |  |  |  |  | Product 1 |  | Product 2 |  | Product 3 |  | Product 4 |  | Sum of Quantity | Sum of Amount
Org. | Product 1 | Product 2 | Product 3 | Product 4 | Last Order # | Last Order Date | # Orders 2021 | Account | Quantity | Amount | Quantity | Amount | Quantity | Amount | Quantity | Amount |  |  | Average Price
Reseller 1 | 18.95 |  | 26.95 |  | 10 | 2021-12-01 00:00:00 |  | AAA | 10 |  |  |  | 10
Reseller 2 |  |  |  | 28.95 | 20 | 2021-04-30 00:00:00 |  | BBB | 20 |  |  |  |  |  | 15
Reseller 3 | 24.95 |  |  |  | 100 | 04/05/2021 |  | CCC | 949
Distributor 1 | 24.95 | 26.95 | 29 |  | 1500 | 07/09/2021 |  | DDD | 29000 |  | 9600 |  | 45000
Distributor 2 |  | 26.95 |  | 30 | 10 | 2021-08-03 00:00:00 |  | EEE | 0 |  | 1200 |  |  |  | 5000
Distributor 3 | 24.95 | 18.95 | 16.95 | 19.95 | 12 | 10/19/2021 |  | FFF | 2800 |  | 162000 |  | 48000 |  | 125000