tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 328398d1403886940-solver-error-in-maximizing-a-correlation-coefficient-y-index-index-correlations-excelforum
Sheet: Soc. P.+Y

 | Y |  |  |  | Soc. P. |  |  |  |  | CORRELATION (rank):
 |  |  |  |  | Soc.P Score | Rank | Standard Rank | Standard Score |  | Correlation (score):
ALGERIA |  |  |  |  |  |  |  |  |  | [NAME]:
ARGENTINA
AUSTRALIA
AUSTRIA
AZERBAIJAN
BANGLADESH
BELGIUM
[NAME]
BRAZIL
BULGARIA
CANADA
CHILE
CHINA
COLOMBIA
COSTA RICA
CROATIA
CZECH REPUBLIC
DENMARK
DOMINICAN REPUBLIC
ECUADOR
EGYPT
EL SALVADOR
ESTONIA
FINLAND
FRANCE
GEORGIA
GERMANY
GREECE
HONDURAS
HUNGARY
ICELAND
INDIA
INDONESIA
IRAN
IRELAND
ISRAEL
ITALY
JAMAICA
JAPAN
JORDAN
KAZAKHSTAN
KOREA, REP. OF
LATVIA
LITHUANIA
MACEDONIA, FYR
MALAYSIA
MAURITIUS
MEXICO
MOLDOVA
MOROCCO
NETHERLANDS
NEW ZEALAND
NICARAGUA
NORWAY
PAKISTAN
PANAMA
PARAGUAY
PERU
PHILIPPINES
POLAND
PORTUGAL
ROMANIA
RUSSIAN FEDERATION
SAUDI ARABIA
SERBIA
SLOVAKIA
SLOVENIA
SOUTH AFRICA
SPAIN
SRI LANKA
SWEDEN
THAILAND
TRINIDAD & TOBAGO
TUNISIA
TURKEY
UKRAINE
UNITED KINGDOM
UNITED STATES
URUGUAY
UZBEKISTAN
VENEZUELA
 |  |  |  |  | NOTE: Soc. P. scored countries as highest score being most well off (Y is the opposite). Rank was constructed similar to the Y index with least well off country (lowest score) given rank=1.
 |  |  |  |  | Standard score constructed with average-observeration in order to compensate for oppositely constructed scores.
Spreadsheet: mary_fischer__25378__Montfort Trb2Feb02
Sheet: Sheet2

Wind |  | Mesured | Ref
Speed | Number | Power | Power
(m/s) | Points | (kW) | (kW)
Spreadsheet: kim_ward__20844__2001 Toll
Sheet: Start Gas

 |  |  |  | [NAME]
 |  |  |  | 3.2
 | Time to Start Execute |  |  |  |  |  |  | Time | Event
 |  | Backfeed | [NAME] | Net
 | Time |  |  | Net Power
 | -30 | -0.3 | 0 |  |  |  |  | 0 | Start Execute
 | -29 | -0.3 | 0 |  |  |  |  | 8 | Finish Purge, first fire
 | -28 | -0.3 | 0 |  |  |  |  | 20 | Synchronize
 | -27 | -0.3 | 0 |  |  |  |  | 60 | [NAME]
 | -26 | -0.3 | 0
 | -25 | -0.3 | 0
 | -24 | -0.3 | 0
 | -23 | -0.3 | 0
 | -22 | -0.3 | 0
 | -21 | -0.3 | 0
 | -20 | -0.3 | 0
 | -19 | -0.3 | 0
 | -18 | -0.3 | 0
 | -17 | -0.3 | 0
 | -16 | -0.3 | 0
 | -15 | -1.8 | 0
 | -14 | -1.8 | 0
 | -13 | -1.8 | 0
 | -12 | -1.8 | 0
 | -11 | -1.8 | 0
 | -10 | -1.8 | 0
 | -9 | -1.8 | 0
 | -8 | -1.8 | 0
 | -7 | -1.8 | 0
 | -6 | -1.8 | 0
 | -5 | -1.8 | 0
 | -4 | -1.8 | 0
 | -3 | -1.8 | 0
 | -2 | -1.8 | 0
 | -1 | -1.8 | 0
 | 0 | -1.8 | 0
 | 1 | -2.5 | 0
 | 2 | -2.2 | 0
 | 3 | -2.2 | 0
 | 4 | -2.2 | 0
 | 5 | -2.2 | 0
 | 6 | -2.2 | 0
 | 7 | -2.2 | 0
 | 8 | -2.2 | 0
 | 9 | -2.2 | 0
 | 10 | -2.2 | 0
 | 11 | -2.2 | 0
 | 12 | -2.2 | 0
 | 13 | -2.2 | 0
 | 14 | -2.2 | 0
 | 15 | -2.2 | 0
 | 16 | -2.2 | 0
 | 17 | -2.2 | 0
 | 18 | -2.2 | 0
 | 19 | -2.2 | 0
 | 20 | -2.2 | 0
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
Spreadsheet: 130320d1322186791-sheet-sum-based-on-cell-reference-start_to-end-sheet-sum
Sheet: Sheet1

 |  |  |  |  |  | $A$1
 |  | Sales by Product |  |  | 1:5 | 3
 |  |  |  |  |  | Sales (Excl ES) £000s
 | Product Group | Spacer Type | TGH / ANN | Textured ? | Georgian ? | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | FY12
 | EnergiKare | Aluminium | Toughened | No Textured | No Georgian | 5
Spreadsheet: 77196d1277722697-displaying-the-colour-of-a-conditional-format-in-another-cell-forum-excel
Sheet: Score Sheet

 |  | KEY PERFORMANCE INDICATORS
 |  |  |  | SCORE SHEET
 |  |  |  |  | 2010
 | 1 ACCESS |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | ASSESSMENT
 | COURT TEAM
 | OUTREACH
 | TELEPHONE
 | 2 CASEWORK |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | DISCRIMINATION
 | FIF DEBT
 | NEW LEGAL AID
 | RENT ARREARS
 | 3 CLIENTS |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | COMPLAINTS
 | DAY 1
 | NO SHOW RATE
 | WAITING RATE
 | 4 QUALITY |  | Quarter 4 |  |  | Quarter 1 |  |  | Quarter 2 |  |  | Quarter 3
 | ADVICE CHECKED
 | FILE REVIEWS
 | LSC KPI
 | RESILIENCE TEST
 | 5 STAKEHOLDERS |  | Quarter 4 |  |  | Quarter 1 |  |  | Quarter 2 |  |  | Quarter 3
 | CLIENT SATISFACTION
 | EXTERNAL PANEL
 | MEETINGS HELD
 | NEW RECRUITS
 | 6 SOCIAL POLICY |  | Quarter 4 |  |  | Quarter 1 |  |  | Quarter 2 |  |  | Quarter 3
 | EVIDENCE RATE
 | LINK DELIVERY
 | MEDIA [NAME]
 | PRODUCTS
 | 7 COMPLIANCES |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | FILING LIVE
 | FIRE TESTS
 | FIRST AIDERS
 | INSURANCES LIVE
 | 8 PEOPLE |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | CONTRACTS ISSUED
 | APPRAISALS
 | SICKNESS RATE
 | TRAINED RECRUITS
 | 9 MONEY |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | CASH TO PLAN
 | EXPENDITURE
 | INCOME TO PLAN
 | SIGNED CONTRACTS
Spreadsheet: 90179d1289936686-sum-total-question-yesterdays-totals
Sheet: 1105

11/05/2010  Performance Data
 |  | 1st Work |  |  |  |  | QC |  |  |  | SC | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT | MMIG, RSCH & UPDT | All Other DA | IA  Forms Pkgs | IA  Trans | EDIT w/pass | PASS | FAIL | IA QC | SURINQ  &  Death Cert
 |  |  |  |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint |  | 14 | 1 |  |  |  |  |  |  |  | 101 | 0.5 | pc issues | 7.5 | 13.46666666666667
 | Dustin |  | 19 | 11 |  |  |  |  |  |  |  | 166 | 0.5 | trending | 7.5 | 22.13333333333333
 | Sharron |  |  |  |  |  |  |  |  |  | 0 | 0 |  | Out of Office | 0 | #N/A
 | Roxy |  | 11 | 18 |  |  |  |  |  |  |  | 131 |  |  | 8.5 | 15.41176470588235
 | [NAME] |  |  |  |  |  | 6 | 14 |  |  |  | 120 |  |  | 8 | 15
 | Ana |  | 8 | 18 |  |  |  |  |  |  |  | 110 | 2 | PVC | 5 | 22
 | Maria |  |  | 60 |  |  |  |  |  |  | 70 | 292 |  |  | 13 | 22.46153846153846
 | [NAME] | 1 | 5 | 9 | 8 | 3 |  |  |  |  |  | 105 |  |  | 4 | 26.25
 | Petra |  |  |  |  |  |  | 9 | 4 |  |  | 78 |  |  | 8 | 9.75
 | Regina |  |  |  |  |  |  | 9 | 1 |  |  | 60 |  |  | 7.5 | 8
 | Noy |  |  |  |  |  | 5 | 8 | 1 |  |  | 84 |  |  | 8 | 10.5
 | [NAME] | * | * | * | * | * |  | * | * | * | * | #N/A | * | Out of Office / Paternity | * | #N/A
 | [NAME] |  |  |  |  |  |  |  |  |  | 66 | 105.6 |  |  | 8 | 13.2
 | Michelle |  |  |  |  |  |  |  |  |  |  | 0 |  | IA distribution | 0 | #N/A
 | Keisha |  |  |  | 12 |  |  |  |  |  |  | 36 | 3 | Out of Office | 5 | 7.2
 | [NAME] |  |  |  | 4 | 14 |  |  |  |  |  | 96 | 1 | pc issues/email review | 7.5 | 12.8
TEAM TOTALS | Pts Earned: | 1 | 7 | 3 | 3 | 6 | 6 | 6 | 6 | 3 | 1.6 |  |  |  |  | #N/A
 | TASK VOLUME: | 1 | 57 | 117 | 24 | 17 | 11 | 40 | 6 | 0 | 136 | 1484.6 | 7 |  | 97.5 | 15.22666666666667
 | Pts Earned: | 1 | 399 | 351 | 72 | 102 | 66 | 240 | 36 | 0 | 217.6
Spreadsheet: c8fa9a8c-7c82-46db-80e0-ba4085c5b1fc
Sheet: 2014-2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Legal Studies
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 329631d1404371758-date-in-text-format-average-to-be-plotted-average-1-
Sheet: average

2014-02-22 00:00:00 | 10 |  |  | 2014-02-01 00:00:00 |  |  | Average in Yellow cells to be plotted by formula
2014-02-23 00:00:00 |  |  |  | 2014-03-01 00:00:00
2014-02-24 00:00:00 |  |  |  | 2014-04-01 00:00:00
2014-02-25 00:00:00
2014-02-26 00:00:00 |  |  |  | Date is in Text Format, Average to be plotted
2014-02-27 00:00:00
2014-02-27 00:00:00
2014-03-01 00:00:00
02-03-14
07-03-14
08-03-14
09-03-14
01-04-14
03-04-14
25-04-14
27-04-14
Spreadsheet: 60146d1260688571-auto-sort-values-in-drop-down-list-testsortedlist
Sheet: Sheet1

BOOKS LIST | Sorted List |  | Drop Down List
Advice and Consent | A Secular Agenda
[NAME] | Advice and Consent
Birth and Evolution of the soul | Airport
Beach Boy | Alchemist
Athenian Constitution | Altered States
Airport | [NAME]
Arrival and Departure | Anandmath
Arrow in the Blue | Arrival and Departure
A Secular Agenda | Arrow in the Blue
Bofors: The Ambassador's Evidence | Athenian Constitution
Baburnama | Baburnama
Anandmath | Beach Boy
Alchemist | Between Hope and History
Between Hope and History | Between Hope and History
Between Hope and History | Birth and Evolution of the soul
Blind Beauty | Blind Beauty
Altered States | Bofors: The Ambassador's Evidence
Spreadsheet: 137772d1327352403-how-to-do-ucls-and-lcls-in-the-chart-mode-cl
Sheet: Sheet1

Months | 2011-01-08 00:00:00 | 2011-02-08 00:00:00 | 2011-03-08 00:00:00 | 2011-04-08 00:00:00 | 2011-05-08 00:00:00 | 2011-06-08 00:00:00 | 2011-07-08 00:00:00 | 2011-08-08 00:00:00 | 2011-09-08 00:00:00 | 2011-10-08 00:00:00 | 2011-11-08 00:00:00
Value | 300
CL
UCL
LCL
Spreadsheet: 477901d1472564358-tough-problem-how-can-i-average-different-columns-based-on-student-names-monthly-mastery-tracker
Sheet: Pivot Table 2

AVERAGE of NHM | Column Labels
Row Labels | 7 | 4 | 2 |  | Grand Total
Student x | 4 |  |  |  | 4
Student y |  | 5 |  |  | 5
Student z |  |  | 6 |  | 6
(blank) |  |  |  | #[NAME]! | #[NAME]!
Grand Total | 4 | 5 | 6 | #[NAME]! | 5
Spreadsheet: 108612d1305645680-collating-data-from-multiple-sheets-wages
Sheet: SUMMARY

Date Due | Total Due | Employee Due | CIS Due | Paid Employee | Paid CIS | Overdue
Spreadsheet: 140253d1328661137-pivot-table-formula-workaround-needed-for-2007-limitation-for-sum-of-pivot-table-percenatge
Sheet: Totals 

Employee | CompletionDate | Wrk QueuesWorked | Hours Worked | MinRequirement | InstructionsWorked | Sum of % Met
[NAME] | 2012-01-30 00:00:00 | DCMEZ | 0.18 | 326 | 13 | 0.03987730061349693
[NAME] |  | DFMEZ | 1.03 | 326 | 20 | 0.06134969325153374
[NAME] |  | DMEZ | 1.02 | 326 | 54 | 0.1656441717791411
[NAME] | 2012-02-02 00:00:00 | DCMEZ | 0.14 | 326 | 9 | 0.02760736196319018
[NAME] |  | DFMEZ | 0.23 | 326 | 13 | 0.03987730061349693
[NAME] |  | DMEZ | 0.53 | 326 | 29 | 0.08895705521472393
[NAME] | 2012-02-03 00:00:00 | DCMEZ | 0.49 | 326 | 36 | 0.1104294478527607
[NAME] |  | DFMEZ | 1.4 | 326 | 62 | 0.1901840490797546
[NAME] |  | DMEZ | 1.05 | 326 | 49 | 0.1503067484662577
[NAME] | 2012-02-01 00:00:00 | DCMEZ | 0.04 | 326 | 7 | 0.02147239263803681
[NAME] |  | DFMEZ | 0.49 | 326 | 13 | 0.03987730061349693
[NAME] |  | DMEZ | 1.07 | 326 | 20 | 0.06134969325153374
Employee | (All) |  | Pivot table
 | Values
Row Labels | Sum of Hours Worked | Sum of MinRequirement | Sum of InstructionsWorked | % Met | % Met is my Calculated field
2012-01-30 00:00:00
DCMEZ | 0.18 | 326 | 13 | 0.03987730061349693
DFMEZ | 1.03 | 326 | 20 | 0.06134969325153374
DMEZ | 1.02 | 326 | 54 | 0.1656441717791411 | Should be
1/30/2012 Total | 2.23 | 978 | 87 | 0.08895705521472393
2012-02-01 00:00:00
DCMEZ | 0.04 | 326 | 7 | 0.02147239263803681
DFMEZ | 0.49 | 326 | 13 | 0.03987730061349693
DMEZ | 1.07 | 326 | 20 | 0.06134969325153374
2/1/2012 Total | 1.6 | 978 | 40 | 0.0408997955010225
2012-02-02 00:00:00
DCMEZ | 0.14 | 326 | 9 | 0.02760736196319018
DFMEZ | 0.23 | 326 | 13 | 0.03987730061349693
DMEZ | 0.53 | 326 | 29 | 0.08895705521472393
2/2/2012 Total | 0.9 | 978 | 51 | 0.05214723926380368
2012-02-03 00:00:00
DCMEZ | 0.49 | 326 | 36 | 0.1104294478527607
DFMEZ | 1.4 | 326 | 62 | 0.1901840490797546
DMEZ | 1.05 | 326 | 49 | 0.1503067484662577
2/3/2012 Total | 2.94 | 978 | 147 | 0.1503067484662577
Grand Total | 7.670000000000001 | 3912 | 325 | 0.08307770961145194
Spreadsheet: 214211d1360846770-data-in-8-columns-should-reflect-in-8-rows-there-are-27-labes-to-be-made-with-8-rows-sample-file
Sheet: Data

Associate ID | Associate Name | Circle | Sub Cirlcle | Location | URN No | Card No | Load Value
Associate ID1 | Associate Name1 | Circle1 | Sub Cirlcle1 | Location1 | URN No1 | Card No1 | Load Value1
Associate ID2 | Associate Name2 | Circle2 | Sub Cirlcle2 | Location2 | [NAME] | [NAME] | Load Value2
Associate ID3 | Associate Name3 | Circle3 | Sub Cirlcle3 | Location3 | URN No3 | Card No3 | Load Value3
Associate ID4 | Associate Name4 | Circle4 | Sub Cirlcle4 | Location4 | URN No4 | Card No4 | Load Value4
Associate ID5 | Associate Name5 | Circle5 | Sub Cirlcle5 | Location5 | URN No5 | Card No5 | Load Value5
Associate ID6 | Associate Name6 | Circle6 | Sub Cirlcle6 | Location6 | URN No6 | Card No6 | Load Value6
Associate ID7 | Associate Name7 | Circle7 | Sub Cirlcle7 | [NAME] | URN No7 | Card No7 | Load Value7
Associate ID8 | Associate Name8 | Circle8 | Sub Cirlcle8 | Location8 | URN No8 | Card No8 | Load Value8
Associate ID9 | Associate Name9 | Circle9 | Sub Cirlcle9 | Location9 | URN No9 | Card No9 | Load Value9
Associate ID10 | Associate Name10 | Circle10 | Sub Cirlcle10 | Location10 | URN No10 | Card No10 | [NAME]
Associate ID11 | Associate Name11 | Circle11 | Sub Cirlcle11 | Location11 | URN No11 | Card No11 | [NAME]
Associate ID12 | Associate Name12 | Circle12 | Sub Cirlcle12 | Location12 | URN No12 | Card No12 | [NAME]
Associate ID13 | Associate Name13 | Circle13 | Sub Cirlcle13 | Location13 | URN No13 | Card No13 | Load Value13
Associate ID14 | Associate Name14 | Circle14 | Sub Cirlcle14 | Location14 | [NAME] | Card No14 | [NAME]
Associate ID15 | Associate [NAME] | Circle15 | Sub Cirlcle15 | Location15 | URN No15 | Card No15 | [NAME]
Associate ID16 | Associate Name16 | Circle16 | Sub Cirlcle16 | Location16 | URN No16 | Card No16 | [NAME]
Associate ID17 | Associate Name17 | Circle17 | Sub Cirlcle17 | Location17 | [NAME] | Card No17 | Load Value17
Associate ID18 | Associate Name18 | Circle18 | Sub Cirlcle18 | Location18 | URN No18 | Card No18 | Load Value18
Associate ID19 | Associate Name19 | Circle19 | Sub Cirlcle19 | Location19 | [NAME] | Card No19 | [NAME]
Associate ID20 | Associate Name20 | Circle20 | Sub Cirlcle20 | Location20 | [NAME] | Card No20 | [NAME]
Associate ID21 | Associate Name21 | Circle21 | Sub Cirlcle21 | Location21 | URN No21 | Card No21 | [NAME]
Associate ID22 | Associate Name22 | Circle22 | Sub Cirlcle22 | [NAME] | URN No22 | Card No22 | [NAME]
Associate ID23 | Associate Name23 | Circle23 | Sub Cirlcle23 | Location23 | URN No23 | Card No23 | [NAME]
Associate ID24 | Associate Name24 | Circle24 | Sub Cirlcle24 | Location24 | URN No24 | Card No24 | [NAME]
Associate ID25 | Associate Name25 | Circle25 | Sub Cirlcle25 | Location25 | URN No25 | Card No25 | [NAME]
Associate ID26 | Associate Name26 | Circle26 | Sub Cirlcle26 | Location26 | URN No26 | Card No26 | Load Value26
Associate ID27 | Associate Name27 | Circle27 | Sub Cirlcle27 | Location27 | URN No27 | Card No27 | [NAME]
Spreadsheet: 20cf9255-8118-4b7b-998e-039cd897087d
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
HDHS | Test | HDHS | House Dust/H-S Lab, IgE | House Dust/H-S Lab, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. -8 p.m., Saturday; 8 a.m. -3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
HDHS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
HDHS | Result | HDHS | House Dust/H-S Lab, IgE | House Dust/H-S Lab, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7425-2 | House dust [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 800948d1666007593-help-with-if-with-3-options-including-one-could-be-0-but-should-not-be-added-to-get-help-with-if
Sheet: Sheet1

Price from local shop | Price from GrandMall | Price from Europe | Min formula | Choose place formula, I need help with when I have 0 or null
5 | 4 | 2
10 | 25 | 60
15 | 12 | 60
0 | 2 | 5 |  |  | the 0 here means they dont have it. how can i Get rid of it)
Spreadsheet: 873644d1720147292-adding-a-border-to-a-dynamic-range-of-cells-and-border-to-dynamic-range-of-cells
Sheet: Sheet1

 |  |  | 2 | 3 | 4 |  |  | 2 | 3 | 4
 |  |  | 3 | 5 | 7 |  |  | 3 | 5 | 7
 |  |  | 4 | 7 | 10 |  |  | 4 | 7 | 10
 |  |  | 5 | 9 | 13 |  |  | 5 | 9 | 13
 |  |  | 6 | 11 | 16 |  |  | 6 | 11 | 16
 |  |  | 7 | 13 | 19 |  |  | 7 | 13 | 19
 |  |  | 8 | 15 | 22 |  |  | 8 | 15 | 22
 |  |  | 9 | 17 | 25 |  |  | 9 | 17 | 25
 |  |  | 10 | 19 | 28 |  |  | 10 | 19 | 28
 |  |  | 11 | 21 | 31 |  |  | 11 | 21 | 31
 |  |  | 12 | 23 | 34 |  |  | 12 | 23 | 34 |  | row count | 15
 |  |  | 13 | 25 | 37 |  |  | 13 | 25 | 37
 |  |  | 14 | 27 | 40 |  |  | 14 | 27 | 40
 |  |  | 15 | 29 | 43 |  |  | 15 | 29 | 43
Spreadsheet: 765672d1643477302-index-match-formula-only-works-for-a-portion-of-columns-cocktail-cost-calculator
Sheet: Settings

Settings
Country Specific Settings
Currency Symbol |  |  | $
Volume Conversion Table
 | ML | CL | [NAME] | Oz | Pt
ML | 1 | 0.01 | 0.001 | 0.0338140225589194 | 0.00211337640993
CL | 10 | 1 | 0.01 | 0.338140225589 | 0.0211337640993
[NAME] | 1000 | 100 | 1 | 33.8140225589194 | 2.11337640993246
Oz | 29.5735296875 | 2.95735296875 | 0.0295735296875 | 1 | 0.0625
Pt | 473.176475 | 47.3176475 | 0.473176475 | 16 | 1
Spreadsheet: e84bfcac-220d-497e-b962-1f594f994f19
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 15 | 6619 | 6393 | 5862 | 5158
15 - 65 | 37676 | 34489 | 30085 | 26846
65 und mehr | 14542 | 15273 | 16941 | 17569
Insgesamt | 58837 | 56155 | 52888 | 49573
%
unter 15 | 11.24972381324677 | 11.38456059122073 | 11.08379972772652 | 10.404857482904
15 - 65 | 64.03453609123511 | 61.41750511975781 | 56.88435940099834 | 54.15447925281908
65 und mehr | 24.71574009551813 | 27.19793428902146 | 32.03184087127514 | 35.44066326427692
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 17.56821318611318 | 18.5363449215692 | 19.48479308625561 | 19.21329062057662
Altenquotient | 38.5975156598365 | 44.28368465307779 | 56.31045371447565 | 65.4436415108396
Gesamtquotient | 56.16572884594968 | 62.82002957464699 | 75.79524680073126 | 84.65693213141623
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: 546628d1510137935-average-if-cell-shows-up-in-column-a-or-b-last-3-times-only-book2-1-
Sheet: Sheet1

AA | CC | 4
BB | AA | 5
CC | BB | 7
AA | CC | 8
BB | AA | 3
CC | BB | 2 |  |  | AA | 4 |  | Column G to display the average  from Column C for only the last 3 times Column F appears in column A OR B
AA | CC | 4 |  |  | BB | 5
BB | AA | 1 |  |  | CC | 4.66
CC | BB | 5
AA | CC | 5
BB | AA | 6
CC | BB | 4
Spreadsheet: 861880d1709722053-complex-number-of-days-in-a-month-formula-test-number-of-days
Sheet: 51998

 | Description of change: |  | LEAVER
 | Date: |  | 2024-04-01 00:00:00
 | Number of Days in Period: |  | 29 |  |  |  | 29
 | Days at Salary Point: |  |  |  | 26 |  |  | =
 | Calculations for Current Month |  |  |  |  | + |  | = |  |  | =IF(D21="New Hire",DAYS(EOMONTH(D22,0),D22)+1)),IF(AND(D21="LEAVER",EOMONTH(D22,-1)+1=D22),1,IF(D21="LEAVER",DAY(EOMONTH(D22,0)+1-DAY(EOMONTH(D22,0)-D22+1),IF(AND(D21="INCREMENT",EOMONTH(D22,-1)+1=D22),0,IF(D21="INCREMENT",DAY(EOMONTH(D22,0)-1-DAY(EOMONTH(D22,0)-D22))))
Spreadsheet: 025cde35-9307-43a7-b3a9-783cebfb446a
Sheet: Sheet1

TOTAL [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | 1993 | 2004 | 2006 | % change 1993-2006
URI | 4705571 | 5103165 | 5200620 | 0.1052048731174176
UNH | 4136855 | 9278866 | 8795825 | 1.12621061168448
U Maine | 4333979 | 5885782 | 6620209 | 0.5275129390336224
TOTAL VOLUMES
 | 1993 | 2004 | 2006 | % change 1993-2006
URI | 1019029 | 1237735 | 1378261 | 0.352523824150245
UNH | 1024911 | 1762922 | 1803574 | 0.7597371869362315
U Maine | 826648 | 1298208 | 1342092 | 0.6235350475655902
[NAME]
 | 1993 | 2004 | 2006 | % change 1993-2006
URI | 1941708 | 2318834 | 1989005 | 0.02435845142524005
UNH | 2184015 | 5003043 | 4797567 | 1.196673099772666
U Maine | 2255103 | 3513134 | 4348390 | 0.9282445192082136
EXPENDITURES ON MONOGRAPHS
 | 1993 | 2004 | 2006 | % change 1993-2006
URI | 421694 | 346850 | 348430 | -0.1737373545746442
UNH | 219763 | 795804 | 784145 | 2.56813931371523
U Maine | 534366 | 487759 | 575553 | 0.077076385847902
EXPENDITURES ON SERIALS
 | 1993 | 2004 | 2006 | % change 1993-2006
URI | 1456782 | 1959130 | 1622313 | 0.1136278454840875
UNH | 1798506 | 4161181 | 3891356 | 1.163660282478902
U Maine | 1619104 | 2949288 | 3590270 | 1.217442486708698
PROFESSIONAL STAFF
 | 1993 | 2004 | 2006 | % change 1993-2006
URI | 20 | 24 | 17.5 | -0.125
UNH | 21 | 27 | 24 | 0.1428571428571428
U Maine | 23 | 22 | 21 | -0.08695652173913043
SUPPORT STAFF
 | 1993 | 2004 | 2006 | % change 1993-2006
URI | 48 | 29 | 30 | -0.375
UNH | 56 | 63 | 60 | 0.07142857142857142
U Maine | 45 | 38 | 38 | -0.1555555555555556
TOTAL STAFF
 | 1993 | 2004 | 2006 | % change 1993-2006
URI | 68 | 53 | 47.5 | -0.3014705882352941
UNH | 77 | 90 | 84 | 0.09090909090909091
U Maine | 68 | 60 | 59 | -0.1323529411764706
INSTITUTIONAL FACULTY
 | 1993 | 2004 | 2006 | % change 1993-2006
URI | 657 | 653 | 679 | 0.0334855403348554
UNH | 581 | 682 | 662 | 0.1394148020654045
U Maine | 596 | 503 | 540 | -0.09395973154362416
PhD DEGREES AWARDED
 | 1993 | 2004 | 2006 | % change 1993-2006
URI | 102 | 79 | 67 | -0.3431372549019608
UNH | 39 | 46 | 55 | 0.4102564102564102
U Maine | 40 | 41 | 38 | -0.05
Source:
ACRL, Academic Library Trends and Statistics.
Spreadsheet: 682328d1592009254-conditional-sum-with-multiple-criteria-new-microsoft-excel-worksheet-rachelwahid-
Sheet: Summary

Buyer | Department | Season | Qty | Total Qty | Live qty | Hold Qty | [NAME]
Buyer | Department | Season | QTY | TOTALQTY | Live Qty | Hold Qty | [NAME]
George | BT Boys | AW20 PH-05 | 196829 | 226373 | 226373 | 0 | 226373
 |  | AW20 PH-07 | 247010 | 266300 | 266300 | 0 | 266300
 | Ladies | SS20 PH-03 | 276332 | 414140 | 414140 | 0 | 414140
 |  | SS20 PH-04 | 374424 | 509340 | 509340 | 0 | 509340
 |  | SS20 PH-05 | 465888 | 699620 | 699620 | 0 | 699620
 | Men's | AW20 PH-05 | 25000 |  | 0 | 0 | 0
 |  | SS20 PH-04 | 249260 |  | 0 | 0 | 0
 | OL Girls | AW20 PH-05 | 438531 | 566631 | 566631 | 0 | 566631
 |  | AW20 PH-07 | 151488 | 137692 | 137692 | 0 | 137692
 |  | SS20 PH-03 | 37670 | 39190 | 39190 | 0 | 39190
 |  | SS20 PH-04 | 327377 | 515731 | 515731 | 0 | 515731