tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 859687d1707989465-array-formula-for-sum-across-row-dynamtic-ytd-1-
Sheet: Sheet1

Type | Amount | Period |  | Type | 2023.04.30 | 2023.05.31 |  |  |  |  |  |  |  |  | YTD
Toy | 50 | 2023-04-30 00:00:00 |  | Computer | 70 | 100 |  |  |  |  |  |  |  |  |  | *how to I add a dynamtic [NAME] across here?
Food | 60 | 2023-04-30 00:00:00 |  | Food | 60 | 90
Computer | 70 | 2023-04-30 00:00:00 |  | Toy | 50 | 80
Toy | 80 | 2023-05-31 00:00:00
Food | 90 | 2023-05-31 00:00:00
Computer | 100 | 2023-05-31 00:00:00
Spreadsheet: 791330d1660286441-help-with-sumproduct-countif-countifs-index-match-what-to-choose-2022-08-12-oeldere-charliechaz-count-help-with-expected-results
Sheet: Sheet2

Select Doc_ID | Year | # of Rev | Total Training Events | Total Training Time
All | 2015 |  |  |  |  | All |  | Cell | [NAME]
 | 2016 |  |  |  |  |  |  | A2 | Helper Cell- I created a drop down with unique Doc_ID values from column A of sheet 1 and added a value of "All".  If "All" is selected, I'd like all the formulas to perform the caluculations below for all document versions.  [NAME] in column G UNIQUE(Sheet1!A2:A810,FALSE) added "All" and hid it.  I also created a drop -down in A2 via Data Validation.
 | 2017 |  |  |  |  | SOP-04077 |  | C2 | Count of revisions (Doc_Ver) per Doc_ID.  Example: There are 5 rows for SOP-02659, version 1.0.  This would be a count of "1".  Version 2.0 has 6 rows.  This will be count # 2 and so on.  There are many doc_ids with many versions.  This is where the helper cells come in play.
 | 2018 |  |  |  |  | WRK-00479 |  | D2 | Total Training Events- This is the count of how many unique users per Doc_ID and Doc_Ver.  Note: the users in column F are made up to protect their names.  There are possible duplicate user names per doc_ID and Doc_Version, hence "unique".
 | 2019 |  |  |  |  | WRK-00577 |  | E2 | Total Training Time- This is a calculation of the total hours spent on training per Doc_ID and Doc_Ver.  Each user spends 0.2 hours per page.  I assume the training events per Doc_ID and Doc_Ver multiplied by Pages
 | 2020 |  |  |  |  | WRK-01610
 | 2021 |  |  |  |  | WRK-01777
 | 2022 |  |  |  |  | WRK-02123
 |  |  |  |  |  | WRK-03109
 |  |  |  |  |  | WRK-03575
 |  |  |  |  |  | WRK-04933
Spreadsheet: 0c55b145-ca83-4f26-b4e9-d4b3a7efc542
Sheet: Sheet1

Cigarette Smoking Prevalence by Ethnic Group: 2010-2011 | Unnamed: 1
Prevalence Percentage, UK
Ethnic group | Cigarette smoking prevalence percentage
Asian or Asian British | 13
Black or Black British | 15
Chinese | 15
Mixed | 27
Other ethnic group | 18
White | 22
Please include the citation provided in our Frequently Asked Questions when reproducing this chart: http://info.cancerresearchuk.org/cancerstats/faqs/#How
Prepared by Cancer Research UK
Original data source:
Office for National Statistics. Integrated Household Survey, April 2010 to March 2011. Available from http://www.ons.gov.uk/ons/rel/integrated-household-survey/integrated-household-survey/index.html.
Spreadsheet: 717890d1612890475-trying-to-alphabetically-sort-data-for-literary-review-references-in-excel-literary-review-reference-table-list
Sheet: Sheet1

 | Yr published (YYYY)
 | Article/story title (in italics) [online]
 | Publication name
 | Accessed [February, 2021]
 | www.weblinkURLhere.com
Richards, C. | Yr published (YYYY)
 | Article/story title (in italics) [online]
 | Publication name
 | Accessed [February, 2021]
Sokolsky, R. | Yr published (YYYY)
 | Article/story title (in italics) [online]
 | Publication name
 | Accessed [February, 2021]
 | www.weblinkURLhere.com
Source/Author name | Yr published (YYYY)
 | Article/story title (in italics) [online]
 | Publication name
 | Accessed [February, 2021]
 | www.weblinkURLhere.com
Source/Author name | Yr published (YYYY)
 | Article/story title (in italics) [online]
 | Publication name
 | Accessed [February, 2021]
 | www.weblinkURLhere.com
Source/Author name | Yr published (YYYY)
 | Article/story title (in italics) [online]
 | Publication name
 | Accessed [February, 2021]
 | www.weblinkURLhere.com
Spreadsheet: 39bafd33-e51a-43c9-af6a-348e4107f870
Sheet: Regional Definition Template

A "Regional Definition Sheet" must be provided with any offer that contains regional pricing. Any specific regional rates must be depicted on the Vendors Commercial Pricelist and supported by evidence (e.g. invoices) of the various regional rates being sold.  Regional pricing must be all inclusive for CONUS and/or OCONUS coverage (i.e. can not leave any part of CONUS and/or OCONUS unaccounted for). The suggested format and required fields for providing regional pricing is as follows:
if both CONUS and OCONUS are offered and contain regional pricing:
Geographic Coverage (i.e. CONUS or OCONUS) | Region Code* (consecutive numbering, beginning with 1 for both CONUS and OCONUS areas) | Specific Regional Definition
CONUS | 1 | California
CONUS | 2 | Alaska
CONUS | 3 | Washington D.C.
CONUS | 4 | All other CONUS areas.
OCONUS | 1 | Mexico
OCONUS | 2 | Canada
OCONUS | 3 | All other OCONUS areas.
if both CONUS and OCONUS, but only CONUS (or OCONUS) contains regional pricing:
Geographic Coverage (i.e. CONUS or OCONUS) | Region Code* (consecutive numbering, beginning with 1 for both CONUS and OCONUS areas) | Specific Regional Definition
CONUS | 1 | California
CONUS | 2 | Alaska
CONUS | 3 | Washington D.C.
CONUS | 4 | All other CONUS areas.
OCONUS | N/A
if only CONUS (or OCONUS) is offered and contains regional pricing:
Geographic Coverage (i.e. CONUS or OCONUS) | Region Code* (consecutive numbering, beginning with 1 for both CONUS and OCONUS areas) | Specific Regional Definition
CONUS | 1 | California
CONUS | 2 | Alaska
CONUS | 3 | Washington D.C.
CONUS | 4 | All other CONUS areas.
* This is the number that should be entered on column "Y" of the FPL.
Spreadsheet: 845412d1696943419-rearranging-text-in-one-table-based-on-another-table-data-cleansing1
Sheet: Data

Table Name - Cnvrt |  | Table Name - List
Find |  | List For Cleaning |  | Desired output |  | test
ArmChair |  | 3 legs,Chair |  | Chair, 3 legs |  |  |  | -
Cabinet |  | 40" black frame,Television |  | Television, 40" black frame | Television, 40" black frame | False
Carpet |  | ArmChair - Orthopedic with backrest |  | ArmChair, Orthopedic with backrest | ArmChair, Orthopedic with backrest | False
Chair |  | Color Printer |  | Color Printer | Color Printer | False
Curtain |  | Colored Boxes |  | Colored Boxes | Colored Boxes | False
Lampshade |  | Curtain Synthetic, with rail |  | Curtain, Synthetic, with rail | Curtain, Synthetic with rail | False
Sofa |  | [NAME] |  | [NAME] | [NAME] | False
Stool |  | Metal leg/Lampshade |  | Lampshade, Metal leg | Lampshade, Metal leg | False
Table |  | Plate Set |  | Plate Set | Plate Set | False
Television |  | Rectangular in different sizes Carpet |  | Carpet, [NAME], different sizes | Carpet, Rectangular in different sizes | False
 |  | Self assembly,Stool |  | Stool, Self-Assembly | Stool, Self assembly | False
 |  | Sofa,Wood white color |  | Sofa, Wood, white color | Sofa, Wood white color | False
 |  | standard old model,Cabinet |  | Cabinet, standard, old model | Cabinet, standard old model | False
 |  | Table,[NAME], 3 meters long |  | Table, [NAME], 3 meters long | Table, Brown 3 meters long | False
 |  | [NAME] |  | [NAME] | [NAME] | False
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: David Deen

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
I'd like to explain my position
Explain your health care reform position, if you choose
I am unsure of hte ramifications of this approach in reaching a unified single payer health care system.
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
I'd like to explain my position
Explain your relicensing position, if you choose
But not at the expense of standards. This is a constant refrain that I hear in the environmental protection world - half the time the
call for simplification means lower protection standards. You have to define your terms better.
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 5607 Westminster West Rd Putney, VT 05346 | Representative Windham -4 | Yes |  | Windham
Spreadsheet: 7a47489a-0c94-469b-9ca6-c8ae0a07f906
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | [NAME] A- KC FREE Case Mgmt
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  | FY 11
 | General Fund
 | Special Revenue |  | 0
 | Enterprise
 |  | Total: | 0
 | This is the contract amendment with KC Free for the Ryan White Case Management services
 | from 4/1/2010 thru 2/28/2011
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  | FY 11
 | General Fund
 | Special Revenue |  | 0
 | Enterprise/Other
 |  | Total: | 0
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 230287d1366730498-is-it-possible-to-have-an-output-cell-of-an-activex-combo-box-link-to-a-named-range-example
Sheet: TEST DATA

Date | MFI | FLEX | IZOD
2013-01-15 00:00:00 | 8.2 | 150 | 2.5
2013-01-28 00:00:00 | 20 | 225 | 1.5
2013-02-25 00:00:00 | 5.6 | 199 | 1.5
2013-02-15 00:00:00 | 10.5 | 175 | 6
Spreadsheet: 67797d1268322170-sorting-by-month-sample
Sheet: Sheet1

Month of Year | RTC - Damage Only | RTC - Fatal | RTC - Minor Injury | RTC - Other | RTC – Serious Injury | Traffic Collision | Grand Total
Apr 2006 |  |  |  |  |  | 1 | 1
Apr 2007 | 5 |  | 2 |  |  | 1 | 8
Apr 2008 | 6 |  |  |  | 1 |  | 7
Apr 2009 | 5 |  |  |  | 1 |  | 6
Aug 2006 |  |  | 3 |  |  | 1 | 4
Aug 2007 | 3 |  |  |  | 1 |  | 4
Aug 2008 | 5 |  | 1 |  | 2 |  | 8
Aug 2009 | 2 |  |  |  |  |  | 2
Dec 2006 | 2 |  | 2 |  | 1 |  | 5
Dec 2007 | 5 |  |  |  |  |  | 5
Dec 2008 | 6 |  | 1 |  | 1 |  | 8
Dec 2009 | 9 |  |  |  |  |  | 9
Feb 2006 | 1 |  |  |  |  | 1 | 2
Feb 2007 | 3 | 1 | 1 |  | 1 |  | 6
Feb 2008 | 8 |  | 1 |  | 1 |  | 10
Jan 2007 | 4 |  |  | 1 | 1 |  | 6
Jan 2008 | 1 | 1 |  |  |  |  | 2
Jan 2009 | 2 |  | 2 |  |  |  | 4
Jul 2006 | 1 |  | 1 |  |  |  | 2
Jul 2007 | 4 |  | 3 |  |  |  | 7
Jul 2008 | 2 |  |  |  |  |  | 2
Jul 2009 | 4 |  | 3 |  |  |  | 7
Jun 2006 | 1 |  |  |  |  |  | 1
Jun 2007 | 2 |  |  |  |  |  | 2
Jun 2008 | 5 |  | 1 |  |  |  | 6
Jun 2009 | 3 |  | 1 |  |  |  | 4
Mar 2006 |  |  |  |  | 2 | 3 | 5
Mar 2007 | 2 |  |  |  | 1 |  | 3
Mar 2008 | 3 |  |  |  | 1 |  | 4
Mar 2009 | 2 |  | 3 |  | 1 |  | 6
May 2006 | 1 |  |  |  |  | 1 | 2
May 2007 | 5 |  |  |  | 1 |  | 6
May 2008 | 9 |  | 1 |  |  |  | 10
May 2009 | 3 |  |  |  |  |  | 3
Nov 2006 | 4 |  |  |  |  |  | 4
Spreadsheet: 2914faa6-3626-40d0-a0e3-e9924c9f8253
Sheet: Sheet1

Unnamed: 0 | 62nd Cherokee National Holiday Fast-Pitch Softball Tournament | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | August 22 - 24, 2014
 | Cherokee Nation Softball Complex |  |  |  | WOMEN
 | Tahlequah, Oklahoma |  |  |  | 5 TEAMS
 | WINNERS |  |  |  | FIELD 3
 |  | WARRIORS
 |  | Saturday   10:30am   (2
 |  | AFTERSHOCK
 | HUSTLERS |  | Saturday   3:00pm   (5
 | Saturday   9:00am   (1
 | SGA-SDI-YU | Saturday   Noon   (3
 |  | RED NATION |  |  | Saturday   7:30pm   (8
 |  |  |  |  |  | Winner
 | LOSERS |  |  | Loser 5
 |  | Loser 1
 |  | Saturday   1:30pm   (4 |  | Saturday   6:00pm   (7
 |  |  |  |  |  | Saturday   9:00pm   (9
 |  |  |  |  |  | If necessary | Winner
 |  | Loser 2
 |  |  | Saturday   4:30pm   (6
 |  |  | Loser 3
 |  |  |  |  |  | Loser 8 if 1st loss
Spreadsheet: 1f1b1ce4-f60b-448a-a481-66d9dff26d29
Sheet: CIAO

CIAO
2004-2005
Metric | 2004-07-01 00:00:00 | 2004-08-01 00:00:00 | 2004-09-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-01 00:00:00 | 2004-12-01 00:00:00 | 2005-01-01 00:00:00 | 2005-02-01 00:00:00 | 2005-03-01 00:00:00 | 2005-04-01 00:00:00 | 2005-05-01 00:00:00 | 2005-06-01 00:00:00 | Total | 2004-2005 Price | Price per search
TOTAL
Sessions | 4 | 3 | 30 | 43 | 144 | 83 | 31 | 161 | 337 | 487 | 74 | 14
Searches | 0 | 0 | 0 | 0 | 153 | 159 | 50 | 643 | 955 | 1352 | 204 | 30 |  | 901
[NAME] | 0 | 1 | 23 | 10 | 131 | 153 | 48 | 544 | 1154 | 1712 | 189 | 29 |  | 901
Spreadsheet: 889966d1741048685-xlookup-with-varying-dates-xlookup-with-varying-dates
Sheet: Lookup

Date | Home Team | Visiting Team |  |  |  |  | 2025-04-01 00:00:00 | Phillies
2025-04-03 00:00:00 | Phillies | Dodgers |  |  |  |  | 2025-04-02 00:00:00 | Dodgers
 |  |  |  |  |  |  | 2025-04-03 00:00:00 | Reds
 |  |  | Player | Starter? | Player | Starter? | 2025-04-04 00:00:00 | Cardinals
 |  |  |  |  |  |  | 2025-04-05 00:00:00 | Mets
 |  |  | [NAME] | [NAME] | George | [NAME] | 2025-04-06 00:00:00 | Yankees
 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | 2025-04-07 00:00:00
 |  |  | Sandy | [NAME] | [NAME] | Ned | 2025-04-08 00:00:00
 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | 2025-04-09 00:00:00
 |  |  | [NAME] |  | [NAME] |  | 2025-04-10 00:00:00
 |  |  | [NAME] |  | Ned |  | 2025-04-11 00:00:00
 |  |  |  |  | [NAME] |  | 2025-04-12 00:00:00
 |  |  |  |  |  |  | 2025-04-13 00:00:00
 |  |  |  |  |  |  | 2025-04-14 00:00:00
 |  |  |  |  |  |  | 2025-04-15 00:00:00
Spreadsheet: 153100d1335769957-back-count-10-cells-book1-14-
Sheet: table

day | Close
2012-03-07 00:00:00 | 0.56
2012-03-08 00:00:00 | 0.565
2012-03-09 00:00:00 | 0.57
2012-03-12 00:00:00 | 0.57
2012-03-13 00:00:00 | 0.57
2012-03-14 00:00:00 | 0.58
2012-03-15 00:00:00 | 0.58
2012-03-16 00:00:00 | 0.58
2012-03-19 00:00:00 | 0.575
2012-03-20 00:00:00 | 0.585
2012-03-21 00:00:00 | 0.58
2012-03-22 00:00:00 | 0.58
2012-03-23 00:00:00 | 0.575
2012-03-26 00:00:00 | 0.575
2012-03-27 00:00:00 | 0.575
2012-03-28 00:00:00 | 0.575
2012-03-29 00:00:00 | 0.575
2012-03-30 00:00:00 | 0.575
2012-04-02 00:00:00 | 0.58
2012-04-03 00:00:00 | 0.58
2012-04-04 00:00:00 | 0.585
2012-04-05 00:00:00 | 0.585
2012-04-09 00:00:00 | 0.58
2012-04-10 00:00:00 | 0.58
2012-04-11 00:00:00 | 0.575
2012-04-12 00:00:00 | 0.575
2012-04-13 00:00:00 | 0.58
2012-04-16 00:00:00 | 0.58
2012-04-17 00:00:00 | 0.58
2012-04-18 00:00:00 | 0.58
2012-04-19 00:00:00 | 0.58
2012-04-20 00:00:00 | 0.58
2012-04-23 00:00:00 | 0.58
2012-04-24 00:00:00 | 0.58
2012-04-25 00:00:00 | 0.575
2012-04-26 00:00:00 | 0.58
2012-04-27 00:00:00 | 0.575
Spreadsheet: 702225d1604178182-formula-calculate-commission-according-the-criteria-formula-help
Sheet: Sheet1

 | Value | Amount | Deduct Commision
 | 1 | 5000
 |  |  |  |  |  |  |  | Value Cirteria commision deduction citeria
 |  |  |  |  |  |  |  | 1 to 2 | 0.05
 |  |  |  |  |  |  |  | 2 to 5 | 0.1
 |  |  |  |  |  |  |  | 6 | 0.12
 |  |  |  |  |  |  |  | 7 | 0.13
 |  |  |  |  |  |  |  | 8 | 0.14
 |  |  |  |  |  |  |  | 9 | 0.15
 |  |  |  |  |  |  |  | 10 | 0.16
 |  |  |  |  |  |  |  | 11 | 0.17
 |  |  |  |  |  |  |  | 12 | 0.18
 |  |  |  |  |  |  |  | 13 | 0.19
 |  |  |  |  |  |  |  | 14 | 0.2
 |  |  |  |  |  |  |  | 15 and greater than 15 | 0.21
Spreadsheet: 346495d1411150978-9-box-grid-copy-of-9x9-ndm-v2
Sheet: Sheet1

Employee Name | Rating |  |  |  |  |  |  |  |  |  |  | DATA VALIDATION CHOICE LIST
Name1 | Under Performer |  |  |  |  |  |  |  |  |  |  | Under Performer
[NAME] | Satisfactory Contributor |  |  |  |  |  |  |  |  |  |  | Satisfactory Contributor
Name3 | Good Performer |  |  |  |  |  |  |  |  |  |  | Good Performer
Name4 | Future Achiever |  |  |  |  |  |  |  |  |  |  | Future Achiever
Name5 | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME]
Name6 | Strong Performer |  |  |  |  |  |  |  |  |  |  | Strong Performer
Name7 | Early Promise |  |  |  |  |  |  |  |  |  |  | Early Promise
Name8 | High Potential |  |  |  |  |  |  |  |  |  |  | High Potential
Name9 | Star Performer |  |  |  |  |  |  |  |  |  |  | Star Performer
Name10 | Under Performer
Name11 | Satisfactory Contributor
Name12 | Good Performer |  |  |  |  |  |  | This will show the first 4 or 5 names, til the box designed is full.
Name13 | Future Achiever |  |  |  |  |  |  | Each group has unique indexing formulas.
Name14 | [NAME]
Name15 | Strong Performer
[NAME] | Early Promise
Name17 | High Potential
Name18 | Star Performer
Name19 | Under Performer
[NAME] | Satisfactory Contributor
Name21 | Good Performer
Name22 | Future Achiever
Name23 | [NAME]
Name24 | Strong Performer
Name25 | Early Promise
Name26 | High Potential
Name27 | Star Performer
Name28 | Under Performer
Name29 | Satisfactory Contributor
Name30
Name31
Name32
Name33
[NAME]
Name35
Name36
Name37
Name38
[NAME]
Name40
Name41
Name42
Name43
Name44
Name45
Name46
[NAME]
Name48
Name49
Name50
Name51
[NAME]
Name53
Name54
Name55
Name56
Name57
Name58
Name59
Name60
Name61
Name62
Name63
Name64
Name65
Name66
[NAME]
[NAME]
Name69
Name70
Name71
Name72
[NAME]
Name74
Name75
Name76
Name77
Name78
Name79
Name80
Name81
Name82
Name83
Name84
Name85
Name86
Name87
[NAME]
Name89
Name90
Name91
Name92
[NAME]
[NAME]
Name95
Name96
Name97
Name98
Name99
Name100
Name101
Name102
Name103
Name104
Name105
Name106
[NAME]
Name108
Name109
Name110
Name111
[NAME]
Name113
Name114
Name115
Name116
[NAME]
Name118
Name119
Name120
Name121
Name122
Name123
[NAME]
Name125
Name126
Name127
Name128
Name129
Name130
Name131
Name132
Name133
Name134
Name135
Name136
Name137
Name138
Name139
Name140
Name141
Name142
Name143
Name144
[NAME]
Name146
[NAME]
Name148
Name149
Name150
Name151
Name152
Name153
Name154
Name155
Name156
Name157
Name158
Name159
Name160
Name161
Name162
Name163
Name164
Name165
Name166
Name167
Name168
Name169
Name170
Name171
Name172
Name173
Name174
Name175
Name176
Name177
Name178
Name179
[NAME]
Name181
Name182
Name183
Name184
Name185
Name186
Name187
Name188
Name189
Name190
Name191
Name192
[NAME]
Name194
Name195
[NAME]
Name197
Name198
Spreadsheet: 330436d1404747934-how-to-return-0-if-there-is-text-but-calculate-otherwise-efsvaeth
Sheet: PG

hello
0.12
0.5
0.8
whatever
0.05
more text
0.25
0.9
0.52
Spreadsheet: 676007d1588603983-eliminating-rounding-errors-in-a-data-set-roundingsample
Sheet: Sheet1

 |  | Starting Number |  | Simple multiplication |  | Rounded |  | Attempt 1
 | Tranche A | 20
 | Tranche B | 24
 | Tranche C | 30
 | Tranche D | 16
 | Tranche E | 10
 | Total
 | Reduction Factor | 0.05
 | Reduction of total
 | Rounded
Spreadsheet: 52021d1251709241-changing-the-value-of-cells-book-2
Sheet: Players Positions

 | Players | WK 1 | WK 2 | WK 3 | WK 4
1 | [NAME] | 1
2 | [NAME] | 4
3 | [NAME] | 5
4 | [NAME] | 0
5 | Retief Goosen | 19
6 | [NAME] | 0
7 | [NAME] | 0
8 | [NAME] | 0
9 | [NAME] | 0
10 | [NAME] | 9
11 | [NAME] | 0
12 | [NAME] Poulter | 0
13 | [NAME] | 12
14 | [NAME] | 0
15 | [NAME] | 0
16 | [NAME] | 21
17 | [NAME] | 0
18 | [NAME] | 0
19 | [NAME] | 3
20 | [NAME] | 0
21 | [NAME] | 0
22 | [NAME] | 0
23 | [NAME] | 0
24 | [NAME] | 0
25 | [NAME] | 10
26 | [NAME] | 4
27 | [NAME] | 2
28 | [NAME] | 0
29 | [NAME] | 0
30 | [NAME] | 0
31 | [NAME] | 0
32 | [NAME] | 0
33 | [NAME] | 0
34 | [NAME] | 0
35 | [NAME] | 0
36 | [NAME] | 0
37 | [NAME] | 0
38 | [NAME] | 0
39 | [NAME] | 0
40 | [NAME] | 3
41 | [NAME] | 7
42 | [NAME] | 6
43 | [NAME] | 0
44 | [NAME] | 0
45 | Anders [NAME] | 0
46 | [NAME] | 20
47 | [NAME] | 0
48 | [NAME] | 0
49 | [NAME] | 0
50 | [NAME] | 0
51 | [NAME] | 0
52 | Pablo Larrazabal | 0
53 | [NAME] | 0
Spreadsheet: 100231d1298636913-top-2-for-multiple-columns-sample
Sheet: Sheet1

 | Week1 | Week2
A | 2266 | 228 |  | Top1
B | 643 | 661 |  | HH
C | 3629 | 1625 |  | Top2
D | 299 | 2047 |  | BB
E | 4390 | 4907
F | 3864 | 784
G | 2637 | 3676
H | 670 | 1495
I | 688 | 3531
J | 210 | 4844
K | 3098 | 2372
L | 3572 | 327
M | 243 | 2612
N | 2189 | 4300
O | 52 | 3932
P | 3378 | 1087
Q | 903 | 2262
R | 3737 | 995
S | 1408 | 4721
T | 2008 | 2582
U | 62 | 3538
V | 609 | 2124
W | 1510 | 3563
X | 3699 | 2290
Y | 4329 | 4007
Z | 4071 | 2840
AA | 3336 | 3764
BB | 4668 | 1969
CC | 223 | 4048
DD | 4595 | 4888
EE | 474 | 1808
FF | 964 | 3826
GG | 1591 | 3080
HH | 4941 | 3631
Spreadsheet: 50400d1249835174-copying-formulas-between-cells-example
Sheet: Her house

Brue Farm, Highbridge
Invoice | January | SFP Date | February | SFP Date | March | SFP Date | April | SFP Date | May | SFP Date | June | SFP Date | July | SFP Date | August | SFP Date | September | SFP Date | October | SFP Date | November | SFP Date | December | SFP Date | Total
Company 1 |  |  |  |  |  |  | 897.66 | 2009-04-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 897.66
Company 2 |  |  |  |  |  |  |  |  | 1380 | 2009-05-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1380
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  | 0 |  | 0 |  | 897.66 |  | 1380 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 2277.66
Spreadsheet: 698656d1602096980-solved-conditional-formatting-formula-to-highlight-duplicate-values-only-if-conditions-condformatex
Sheet: Temp

Visit Date | Client Name | Billing Codes | Units | Service | Client ID
10/07/2020 | Doe, [NAME] |  | 3 | IHCS Level 2 (1:1) | 1450 | These rows should be highlighted because two instances of client 1450 occur twice on the same day.
10/07/2020 | Doe, [NAME] |  | 5 | IHCS Level 2 (1:1) | 1450
2020-10-07 00:00:00 | [NAME], [NAME] |  | 11 | IHCS Level 2 (1:1) | 1220 | These rows should not be highlighted because even though client 1220 occurs twice, the date is different.
2020-10-09 00:00:00 | [NAME], [NAME] |  | 6 | Companion (1:1) | 1220
2020-10-10 00:00:00 | Doe, [NAME] |  | 9 | IHCS Level 2 (1:1) | 1450
2020-10-11 00:00:00 | [NAME], [NAME] |  | 33 | Companion (1:1) | 1220
Spreadsheet: 737781d1624603156-leave-calendar-to-count-number-of-days-of-leave-left-leave-plan-draft-v6-ans-2
Sheet: September

Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Monday |  | Tuesday
1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7
8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14
15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21
22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28
29 |  | 30