tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 774608d1648563322-sum-formula-with-condition-excel-formula
Sheet: Sheet1

 | Country | Country weight |  | Country to select | Country weight
 | Canada | 0.5 |  | Cape Verde
 | Cape Verde | 0.5 |  | Cape Verde
 | Cayman Islands | 0.5 |  | Cape Verde
 | Chad | 1
 | Chile | 1 |  | Sum
 | China | 1.5
 | Colombia | 1.5
Spreadsheet: 117dc2bf-25c4-4d03-a9f1-420f0f59fc21
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Meeting: |  |  | [use 22 pt font]
Chairman/Facilitator: |  |  | [use first/last name … not initials]
Recorder: |  |  | [use first/last name … not initials]
Members: |  |  | [list all with first/last name … not initials]
Staff: |  |  | [add appropriate staff … first/last names … not initials]
Date/Time:
Location:
 |  | AV: | [list equipment requested for mtg, flipchart, etc.]
Distribution: |  |  | [include appropriate staff]
Item # | Start Time | Dur. (hr:min.) | Description | Desired Results | Person Responsible
1 | 00:00:00 | 00:00:00 | CALL TO ORDER
2 | 00:00:00 | 00:05:00 | REVIEW & APPROVAL OF AGENDA | Revise & adopt
3 | 00:05:00 | 00:05:00 | APPROVAL OF MINUTES | Approve & adopt
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME] |  | REVIEW OPEN ACTION LIST - [include as attachment]
 | [NAME] |  | NEXT MEETING - [include date/location]
 | [NAME] |  | ADJOURNMENT
Spreadsheet: 733250d1621455411-building-a-workbook-for-work-help-activity-workbook-sample-master
Sheet: MASTER

Employee ID | Last Name | First Name | Qualifying/Hire/Request Date | Actions to Perform | Tyler Deductions | Leaves | [NAME] | SISC Enrollment Form | AFEnroll | Spousal Overlay Complete | Rejection of Health Ins Benefits | Life Ins Beneficiary Designation | Life Insurance Census | Disability Census (tab on Life Ins Census) | ST/LT Disability Policy | Benefits Letter | Initial Cobra Letter | Notify BUDGET - Part time enroll/term benfts | SISC Change MAR | SISC Term MAR / Term in SISC | Life Ins. Conversion Letter | [NAME] | Benefits [NAME] | Mid-Year Contribution Notice (District Pd. Retirees) | Contribution Notice (Self Pd. Retirees) | 65 DROP LIST | Update Binder | Notes
Spreadsheet: 59336d1259831528-updating-old-data-and-adding-new-data-to-a-sheet-master
Sheet: Sheet1

Key | Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6
CY-001 | 100 | 200 | 0 | AAA | BBB | CCC
CY-002 | 1000 | 2000 | 400 | DDD | EEE | FFF
CY-003 | 1 | 5 | 7 | GGG | HHH | III
CY-004 | 5 | 10
CY-005 | 25 | 35
Spreadsheet: 88135d1288049766-setting-max-value-but-continuing-with-proportionate-calculation-series-help
Sheet: Sheet1

 |  | Years | 1 | 2 | 3 | 4 | 5
Percentage Increase |  | Series A | 75
0.2 |  | Series B | 50
 |  | Total
IDEALLY This Should be the Table
 |  | Years | 1 | 2 | 3 | 4 | 5
Percentage Increase |  | Series A | 75
0.2 |  | Series B | 50
 |  | Total
 |  |  |  |  |  | **Notice how G9 and G10 will continue to calculate until the sum of them both =250 and remain at that maximum
 |  |  |  |  |  | So, how do I get G2 and G3 to do the same thing?
Spreadsheet: joe_parks__14715__POSTION05_02
Sheet: POSTION

 | MTM |  | POSTION | ROLL OFF | NEW DEAL | MTM | NET |  | ROLLOFF VALUE |  | change | PRIOR POSTION | CHANGE
 | 3.459 | JUN |  |  |  |  |  |  |  | 3.591 |  | -46.5 |  | 2001-06-01 00:00:00
 |  | JUL |  |  |  |  |  |  |  | 3.615 |  | -9.3 |  | 2001-06-02 00:00:00
 |  | AUG |  |  |  |  |  |  |  | 3.645 |  | -3.1 |  | 2001-06-03 00:00:00
 |  | Sep |  |  |  |  |  |  |  | 3.675 |  | 0 |  | 2001-06-04 00:00:00
 |  | M-V |  |  |  |  |  |  |  | 3.6416 |  | 0 |  | 2001-06-05 00:00:00
 |  | X-H |  |  |  |  |  |  |  | 4.0026 |  | 1
 |  | CAL3 |  |  |  |  |  |  |  | 3.8716 |  | 2
 |  | HH_SWAP |  |  |  |  |  | 3.37 | 3.735 | 3.591 |  | -69.7 |  | 2001-06-06 00:00:00
 |  | HSC_SWAP |  |  |  |  |  |  | 3.709 | 3.571 |  | 0 |  | 2001-06-07 00:00:00
 |  | TOTAL |  |  |  |  |  |  |  |  |  | -54.2 |  | 2001-06-12 00:00:00
 |  | Oct |  |  |  |  |  |  |  |  |  | 0 |  | 2001-06-13 00:00:00 |  | 30 | 3.62
 |  |  |  |  |  |  |  |  | 3.447 |  |  | 0 |  | 2001-06-14 00:00:00 |  | 20 | 3.695
 |  | Jan |  |  |  |  |  |  | 3.51 |  |  | 0 |  | 2001-06-15 00:00:00
 |  |  |  |  |  |  |  |  | 3.475 | `` |  |  |  | 2001-06-16 00:00:00
 |  | TOTAL |  |  |  |  |  |  | 3.39 |  |  | 75.65 |  | 2001-06-17 00:00:00 | 25000
 |  |  |  |  |  |  |  |  | 3.39 |  |  |  |  | 2001-06-18 00:00:00 | 25000
 |  | NUMBER OF DAYS |  | 11 | 1 |  |  |  | 3.475 |  |  |  |  | 2001-06-19 00:00:00 | 25000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-06-20 00:00:00 | 25000
 |  |  |  |  |  |  |  | PRIOR |  |  |  |  |  | 2001-06-21 00:00:00 | 25000
 |  |  |  |  |  |  |  | 3.397 |  |  |  |  |  | 2001-06-22 00:00:00 | 25000
1 | 3.446 |  |  |  |  |  | 2.552 | 2.369 |  |  |  |  |  | 2001-06-23 00:00:00 | 25000
2 | 3.397 | 2002-06-01 00:00:00 | 3.459 |  |  |  | 2.902 | 2.753 |  |  |  |  |  | 2001-06-24 00:00:00 | 25000
3 | 3.422 | 2002-07-01 00:00:00 | 3.537 |  |  |  | 3.252 | 3.125 |  |  |  |  |  | 2001-06-25 00:00:00 | 25000
 |  | 2002-08-01 00:00:00 | 3.594 |  |  |  | 3.422 | 3.303 |  |  |  |  |  | 2001-06-26 00:00:00 | 25000
 |  | 2002-09-01 00:00:00 | 3.62 |  |  |  | 3.394 | 3.28 |  |  |  |  |  | 2001-06-27 00:00:00 | 25000
 |  | 2002-10-01 00:00:00 | 3.651 |  |  |  | 3.325 | 3.215 |  |  |  |  |  | 2001-06-28 00:00:00 | 25000
 |  | 2002-11-01 00:00:00 | 3.909 |  |  |  | 3.232 | 3.125 |  |  |  |  |  | 2001-06-29 00:00:00 | 25000
 |  | 2002-12-01 00:00:00 | 4.134 |  |  |  | 3.252 | 3.15 |  |  |  |  |  | 2001-06-30 00:00:00 | 25000
 |  | 2003-01-01 00:00:00 | 4.229 |  |  |  | 3.285 | 3.185 |  |  | ,30 |  |  |  | 25000
 |  | 2003-02-01 00:00:00 | 4.167 |  |  |  | 3.325 | 3.225
 |  | 2003-03-01 00:00:00 | 4.029 |  |  |  | 3.362 | 3.262
 |  | 2003-04-01 00:00:00 | 3.834 |  |  |  | 3.36 | 3.26
 |  | 2003-05-01 00:00:00 | 3.809 |  |  |  | 3.372 | 3.272
 |  | 2003-06-01 00:00:00 | 3.831 |  |  |  | 3.532 | 3.432
 |  | 2003-07-01 00:00:00 | 3.869 |  |  |  | 3.695 | 3.595
Spreadsheet: 676407d1588790358-match-multiple-values-across-several-sheets-and-enter-results-on-a-different-sheet-example-match-multiple-sheets
Sheet: MissingMaintReport

[NAME] | SERIALNO | [NAME] | LocNum | LOCATIONDATE | Missing Maintenance Card | Issued | MaintPartNumbner | MaintCompReport
[NAME] | 26-AAV | everywhere | E00014 | 2020-03-19 00:00:00 | Mouse-1
[NAME] | 26-AAV | everywhere | E00014 | 2015-03-19 00:00:00 | Mouse-2
Med Mask | [PHONE] | here | E11708 | 2020-03-19 00:00:00 | MaskClean-1
Med Mask | [PHONE] | here | E11708 | 2020-03-19 00:00:00 | MaskClean-2
[NAME] | 25-F2R | home | [NAME] | 2020-01-01 00:00:00 | Mouse-1
[NAME] | 25-F2R | home | [NAME] | 2020-03-19 00:00:00 | Mouse-2
Med Mask | [PHONE] | there | E44587 | 2020-03-19 00:00:00 | MaskClean-1
Med Mask | [PHONE] | there | E44587 | 2020-03-19 00:00:00 | MaskClean-2
Spreadsheet: 08e5587b-18b8-4f9e-8964-2c3158002c3e
Sheet: list2

DO NOT DELETE ANY OF THESE COLUMNS PLEASE
Organisation |  | Governorate | Kadaa |  | Governorate | North | MountLebanon | Bekaa | Beirut | South |  |  | WASH |  | Project status |  | Areas of Need
ACF |  |  |  |  | North | [NAME] | Aley | [NAME] | Beirut | [NAME] |  |  | School WASH |  | Planned |  | Addressed
ACTED |  |  |  |  | Mount Lebanon | Bcharre | Baabda | El Hermel |  | El Nabatieh |  |  | Aqua tab Distribution |  | Not yet Started |  | Partially Addressed
CISP |  |  |  |  | Bekaa | El Batroun | Chouf | Rachaya |  | [NAME] |  |  | Water trucking |  | Work in Progress |  | Not Addressed
CLMC |  |  |  |  | Beirut Governorate | El Koura | El Meten | West Bekaa |  | Jezzine |  |  | Water trucking (Voucher System) |  | Completed
DRC |  |  |  |  | South | El MiniehDennie | [NAME] | Zahle |  | [NAME] |  |  | Rehabilitation of Latrines |  | Cancelled
Handicap International |  |  |  |  |  | Tripoli | Kesrwane | Zahre |  | Saida |  |  | Water Tank Distribution (1,000 litre)
IOCC |  |  |  |  |  | Zgharta |  |  |  | Sour |  |  | Water Tank Distribution (1,500 litre)
IRD |  |  |  |  |  |  |  |  |  |  |  |  | Water tank repair
Islamic Relief |  |  |  |  |  |  |  |  |  |  |  |  | Ceramic Filter Distribution
Min. of Water Min. of Energy &Water |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Moviemiento por la Paz |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
NRC |  |  |  |  |  |  |  |  |  |  |  |  | School WASH
PU-AMI |  |  |  |  |  |  |  |  |  |  |  |  | De-sludging of Latrines
Save the Children |  |  |  |  |  |  |  |  |  |  |  |  | NFI Kit Distribution
UNDP |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
UNFPA |  |  |  |  |  |  |  |  |  |  |  |  | WASH Assessment
UNHCR |  |  |  |  |  |  |  |  |  |  |  |  | Jerrycan Distribution
UNICEF |  |  |  |  |  |  |  |  |  |  |  |  | Bucket Distribution
WAR Child Holland |  |  |  |  |  |  |  |  |  |  |  |  | Bladder Tank Distribution
WHO |  |  |  |  |  |  |  |  |  |  |  |  | Construction of Latrines
 |  |  |  |  |  |  |  |  |  |  |  |  | Rehabilitation of Latrines
 |  |  |  |  |  |  |  |  |  |  |  |  | Construction of Handwashing station
 |  |  |  |  |  |  |  |  |  |  |  |  | Distribution of SOAP
 |  |  |  |  |  |  |  |  |  |  |  |  | Shelter construction
 |  |  |  |  |  |  |  |  |  |  |  |  | Construction of Showers
 |  |  |  |  |  |  |  |  |  |  |  |  | Connection to WATER Network
 |  |  |  |  |  |  |  |  |  |  |  |  | Construction Septic Tanks
 |  |  |  |  |  |  |  |  |  |  |  |  | Well repairs
 |  |  |  |  |  |  |  |  |  |  |  |  | New sewage lines
 |  |  |  |  |  |  |  |  |  |  |  |  | New water system
Spreadsheet: darrell_schoolcraft__7321__imball0202
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 46181 | 46125
2 | 45310 | 45501
3 | 45365 | 45393
4 | 45289 | 45501
5 | 29956 | 32422
6 | 44104 | 43943
7 | 28135 | 28260
8 | 40218 | 40777
9 | 54635 | 54792
10 | 55177 | 54792
11 | 54989 | 54792
12 | 26436 | 25267
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 1526.04
2002-02-12 00:00:00
CBS Volume
 |  |  | 549
Spreadsheet: 98422d1297325529-dynamic-data-tables-book2
Sheet: Sheet1

 |  | unit |  | 1 | 2 | 3
 |  | income |  | 3 | 4 | 5
 |  | expense |  | 0.5 | 0.4 | 0.4
 |  | revenue
 |  | tax |  | 0.1 | 0.14 | 0.15
 |  | NI
 |  | unit | 1 | <-- drop-down list
 |  |  | expense and tax effect on NI
 |  |  |  | expense
 |  |  |  | 0.4 | 0.5 | 0.6
 |  | tax | 0.05 |  | 2.375 | 2.28
 |  |  | 0.1 | 2.34 | 2.25 | 2.16
 |  |  | 0.15 | 2.21 | 2.125 | 2.04
Spreadsheet: joe_parks__14987__BridgeDPR0521
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 2274.263608099998 | 4277.263608099998 | 9568.263608099998
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 2274.263608099998 | 4277.263608099998 | 9568.263608099998
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: michelle_lokay__26740__imball0203
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -19997 | -19960
2 | -20003 | -19960
3 | -19992 | -19793
4 | -20005 | -19793
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
31
2002-02-28 00:00:00 |  |  | 0
2002-03-04 00:00:00
CBS Dollars
 |  |  | 0
Spreadsheet: 133168d1324242350-counting-the-matching-ones-letter-searching
Sheet: Sayfa1

 | number matching |  | Sunday
apple | 1
newyork | 2 |  |  |  | I do searching by entering any letters in cell D1.And those that match become red.What I am tring to achieve is to find out the number  of matchings and display the results in col [NAME] it is clear.Thanks.
london | 3
washington | 4
orange | 2
yellow | 1
blue | 1
green | 1
black | 1
white | 0
Sunday | 6
Monday | 4
Wednesday | 6
Friday | 3
Saturday | 6
spring | 2
summer | 2
winter | 1
january | 5
september | 1
december | 1
april | 1
may | 2
june | 2
july | 2
twenty | 2
eleven | 1
six | 1
seven | 2
nine | 2
ten | 1
Spreadsheet: 54612d1254655055-excel-accounting-help-pm-tracking
Sheet: Travel

Date | Odo Start | Odo End | Reason | Total
2009-07-29 00:00:00 | 123456 | 123567 | ABC Supplier | 111
2009-08-14 00:00:00 | 123567 | 123678 | ABC Supplier | 111
2009-08-29 00:00:00 | 123678 | 123789 | ABC Supplier | 111
2009-09-14 00:00:00 | 123789 | 123900 | ABC Supplier | 111
2009-09-29 00:00:00 | 123900 | 124011 | ABC Supplier | 111
2009-10-04 00:00:00 | 124011 | 124022 | ABC Supplier | 11
Spreadsheet: 200770d1355760630-splitting-sales-in-the-least-amount-of-deliveries-splitting-sales-solution
Sheet: Sheet1

 |  |  |  |  |  | Delivery #
 |  |  |  |  |  | 1 | 2 | 3
 | Type 1 | 228
 | Type 2 | 241
 | Type 3 | 129
 | Type 4 | 312
 | Type 5 | 4
 | Type 6 | 1
 | Total
 | [NAME] | 360
 | # of Deliveries
Spreadsheet: 57140d1257291908-count-data-705705-count-data
Sheet: Sheet1

NO | REF | CASE NAME | SUBJECTS | INVESTIGATOR | TEAM BRANCH | DATE OF REFERRAL | DATE REGISTERED/CLOSED | color | TODAY | REVIEW MONTHS | ADOPTED MONTHS
1 | 100 | [NAME] | [NAME] | Mr [NAME] | LONDON | 2006-11-15 00:00:00 | 2007-04-25 00:00:00 | 1 | 2009-11-04 00:00:00 | 35.63333333333333 | 30.3
2 | 101 | [NAME] | [NAME] | Miss [NAME] | PORTSMOUTH | 2006-11-20 00:00:00 |  | 2 | 2009-11-04 00:00:00 | 35.46666666666667
3 | 103 | [NAME] | [NAME] | Mr [NAME] | LONDON | 2007-01-25 00:00:00 | 2007-03-01 00:00:00 | 3 | 2009-11-04 00:00:00 | 33.3
4 | 189469 | [NAME] | [NAME] | Mr [NAME] | LONDON | 2007-02-02 00:00:00 |  | 4 | 2009-11-04 00:00:00 | 33.06666666666667
5 | 189582 | [NAME] | [NAME] | Miss [NAME] | PORTSMOUTH | 2007-02-15 00:00:00 | 2007-05-02 00:00:00 | 1 | 2009-11-04 00:00:00 | 32.63333333333333 | 30.06666666666667
6 | 189598 | [NAME] | [NAME] | Miss [NAME] | PORTSMOUTH | 2007-02-19 00:00:00 | CLOSED | 4 | 2009-11-04 00:00:00 | 32.5
7 | 189616 | [NAME] | [NAME] | Miss [NAME] | PORTSMOUTH | 2007-02-21 00:00:00 | CLOSED | 4 | 2009-11-04 00:00:00 | 32.43333333333333
8 | 189608 | [NAME] | [NAME] | Mr [NAME] | LONDON | 2007-02-21 00:00:00 | 2007-04-30 00:00:00 | 1 | 2009-11-04 00:00:00 | 32.43333333333333 | 30.13333333333333
9 | 189724 | [NAME] | [NAME] | Mr [NAME] | BOLTON | 2007-03-05 00:00:00 | CLOSED | 4 | 2009-11-04 00:00:00 | 31.96666666666667
10 | 189722 | [NAME] | [NAME] | Miss [NAME] | BOLTON | 2007-03-05 00:00:00 |  | 4 | 2009-11-04 00:00:00 | 31.96666666666667
 |  |  |  |  |  |  |  |  |  | 33
Spreadsheet: 687701d1595354566-randomly-picked-names-from-overall-list-need-to-pick-those-chosen-and-group-names
Sheet: Sheet1

 |  |  |  |  |  |  | General Playes |  |  |  |  |  |  | 28th July Maxies
 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | [NAME] | 5 |  |  |  |  |  | Red
 |  |  | [NAME] |  |  |  | [NAME] | 5 |  |  |  |  |  | Blue
 |  |  | [NAME] |  |  |  | [NAME] | 5 |  |  |  |  |  | Green
 |  |  | [NAME] |  |  |  | [NAME] | 5 |  |  |  |  |  | Black
 |  |  | [NAME] |  |  |  | [NAME] | 5 |  |  |  |  |  | Yellow
 |  |  | [NAME] |  |  |  | [NAME] | 5 |  |  |  |  |  | Orange
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Dr [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  | [NAME] | 5
 |  |  | [NAME] |  |  |  | [NAME] | 5
Spreadsheet: 23548535-5de9-4162-a048-a3aeb0dc240c
Sheet: 10's

10 UNDER
TEAM | Championships | Tourny's | Overall | Overall | Overall |  | Bracket | Bracket
2013-12-09 00:00:00 | Won | played | Win | Loss | Ties |  | Won | Lost
Bartow Intimidators 02 | 1 | 4 | 11 | 8 |  |  | 6 | 3
Blazers 02 |  | 1 | 2 | 3 |  |  | 1 | 1
Cruisers Piranhas |  | 1 | 0 | 4 |  |  | 0 | 1
Diamonds 02 |  | 1 | 0 | 4 |  |  | 0 | 1
Florida Gold | 1 | 2 | 6 | 4 |  |  | 3 | 1
Florida Red Rage |  | 2 | 6 | 3 |  |  | 1 | 2
Ft Myers Fillies |  | 1 | 0 | 4 |  |  | 0 | 1
[NAME] |  | 1 | 3 | 2 |  |  | 2 | 1
Haines City Storm |  | 3 | 5 | 7 |  |  | 0 | 3
Lady Angels 02 |  | 6 | 6 | 18 |  |  | 0 | 7
Lady Bobcats | 1 | 2 | 7 | 1 |  |  | 2 | 1
Lady Phantoms | 2 | 2 | 3 | 1 |  |  | 2 | 0
Lakeland [NAME] |  | 1 | 0 | 4 |  |  | 0 | 2
Maniacs |  | 3 | 8 | 5 |  |  | 2 | 3
Manatee Twisters 03 | 1 | 2 | 3 | 4 |  |  | 1 | 1
Palmetto Pride/Tropic Wave | 4 | 7 | 21 | 10 | 1 |  | 7 | 3
Plant City Black Widows |  | 1 | 0 | 4 |  |  | 0 | 1
Riptide |  | 1 | 1 | 3 |  |  | 0 | 1
[NAME] 10U |  | 1 | 0 | 4
[NAME] | 1 | 1 | 4 | 0
Tampa Bay Velocity 10U | 1 | 4 | 10 | 7 |  |  | 4 | 4
USA Patriots |  | 1 | 3 | 1 | 1 |  | 1 | 1
Spreadsheet: 714390d1611208229-formula-to-check-date-range-timeline_ex
Sheet: Sheet1

 | Component | Phases |  |  |  |  |  |  | 2020 |  |  |  |  |  |  |  |  |  |  |  | 2021
 |  | A | B | C | D | E … | END |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00
 | X | 2020-05-25 00:00:00 | 2020-06-30 00:00:00 | 2020-08-05 00:00:00 |  |  | 2020-09-09 00:00:00
 | Y | 2020-03-04 00:00:00 | 2020-04-09 00:00:00 | 2020-04-29 00:00:00 |  |  | 2020-05-18 00:00:00
 | Z | 2020-09-24 00:00:00 | 2020-10-06 00:00:00 | 2020-12-01 00:00:00 |  |  | 2021-01-25 00:00:00
 | S | 2020-01-24 00:00:00 | 2020-03-09 00:00:00 | 2020-04-23 00:00:00 |  |  | 2020-07-31 00:00:00
 | T | 2020-07-08 00:00:00 | 2020-08-07 00:00:00 | 2020-09-06 00:00:00 |  |  | 2020-12-14 00:00:00
 | Component | Phases |  |  |  |  |  |  | 2020 |  |  |  |  |  |  |  |  |  |  |  | 2021
 |  | A |  | B |  | C |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00
 | X | 2020-05-25 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00 | 2020-08-04 00:00:00 | 2020-08-05 00:00:00 | 2020-09-09 00:00:00
 | Y | 2020-03-04 00:00:00 | 2020-04-08 00:00:00 | 2020-04-09 00:00:00 | 2020-04-28 00:00:00 | 2020-04-29 00:00:00 | 2020-05-18 00:00:00
 | Z | 2020-09-24 00:00:00 | 2020-10-05 00:00:00 | 2020-10-06 00:00:00 | 2020-11-30 00:00:00 | 2020-12-01 00:00:00 | 2021-01-25 00:00:00
 | S | 2020-01-24 00:00:00 | 2020-03-08 00:00:00 | 2020-03-09 00:00:00 | 2020-04-22 00:00:00 | 2020-04-23 00:00:00 | 2020-07-31 00:00:00
 | T | 2020-07-08 00:00:00 | 2020-08-06 00:00:00 | 2020-08-07 00:00:00 | 2020-09-05 00:00:00 | 2020-09-06 00:00:00 | 2020-12-14 00:00:00
Spreadsheet: 731772d1620572061-formatting-large-numbers-to-3-figures-exfor004
Sheet: Sheet1

population | 66796807 | 331633848 | 8667100 | 25793524 | 38448143 | 125410000 | 1407852680 | 1376680867 | 146171015 | 447206135
area (mi2) | 93628 | 3677649 | 15940 | 2969907 | 3855100 | 145937 | 3705407 | 1269219 | 6601670 | 1634472
pop per mi2
GDP ($) | 3124650000000 | 22675271000000 | 824734000000 | 1617543000000 | 1883487000000 | 5378136000000 | 16642318000000 | 3049704000000 | 1710734000000 | 16033000000000
GDP pc ($)
Spreadsheet: 46123d1245015286-want-to-automate-the-recording-of-data-from-one-worksheet-to-another-fruitexample2
Sheet: All Fruit

Date | Fruit | Units | Cost | Bananas | Oranges | Pears | Apples
2009-02-15 00:00:00 | Bananas | 3 | 30 | 1 | 0 | 0 | 0
2009-02-15 00:00:00 | Bananas | 7 | 70 | 2 | 0 | 0 | 0
2009-02-15 00:00:00 | Bananas | 2 | 20 | 3 | 0 | 0 | 0 |  | LIST function turned on, as you add rows to the bottom of the list,
2009-02-15 00:00:00 | Oranges | 4 | 32 | 3 | 1 | 0 | 0 |  | all the formulas in E:H are added down for you automatically.
2009-02-16 00:00:00 | Bananas | 9 | 90 | 4 | 1 | 0 | 0
2009-02-16 00:00:00 | Oranges | 7 | 56 | 4 | 2 | 0 | 0 |  | You can hide these columns if you wish now that the indexes are active.
2009-02-16 00:00:00 | Oranges | 7 | 56 | 4 | 3 | 0 | 0 |  | Use the plus icon above row I to hide/unhide key columns for each fruit.
2009-02-16 00:00:00 | Pears | 4 | 60 | 4 | 3 | 1 | 0
2009-02-16 00:00:00 | Pears | 5 | 75 | 4 | 3 | 2 | 0
2009-02-16 00:00:00 | Pears | 7 | 105 | 4 | 3 | 3 | 0
2009-02-16 00:00:00 | Pears | 1 | 15 | 4 | 3 | 4 | 0
2009-02-17 00:00:00 | Pears | 2 | 30 | 4 | 3 | 5 | 0
2009-02-17 00:00:00 | Apples | 2 | 14 | 4 | 3 | 5 | 1
2009-02-17 00:00:00 | Apples | 4 | 28 | 4 | 3 | 5 | 2
2009-02-17 00:00:00 | Bananas | 8 | 80 | 5 | 3 | 5 | 2
2009-02-18 00:00:00 | Apples | 3 | 21 | 5 | 3 | 5 | 3
2009-02-18 00:00:00 | Bananas | 7 | 70 | 6 | 3 | 5 | 3
2009-02-19 00:00:00 | Bananas | 8 | 80 | 7 | 3 | 5 | 3
2009-02-19 00:00:00 | Pears | 9 | 135 | 7 | 3 | 6 | 3
2009-02-19 00:00:00 | Oranges | 3 | 24 | 7 | 4 | 6 | 3
2009-02-19 00:00:00 | Apples | 3 | 21 | 7 | 4 | 6 | 4
2009-02-20 00:00:00 | Apples | 5 | 35 | 7 | 4 | 6 | 5
2009-02-20 00:00:00 | Oranges | 1 | 8 | 7 | 5 | 6 | 5
2009-02-21 00:00:00 | Bananas | 3 | 30 | 8 | 5 | 6 | 5
2009-02-22 00:00:00 | Bananas | 6 | 60 | 9 | 5 | 6 | 5
2009-02-22 00:00:00 | Bananas | 5 | 50 | 10 | 5 | 6 | 5
Spreadsheet: 47071d1245964558-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: LGH - CS-SPD PACKS (#1)

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS-SPD PACKS #1
FACILITY: | LEDUC GENERAL HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: |  |  | X |  |  |  |  | X
** If more/less linen required please fax in this order by 7:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
LAPAROTOMY PACK |  |  |  | CP0005 |  | 10
L-LG SPLIT PACK |  |  |  | CP0030 |  | 30
L-SM SPLIT PACK |  |  |  | CP0031 |  | 10
T.U.R. PACK |  |  |  | CP0013 |  | 6
LITHO PLUS PACK |  |  |  | CP0003 |  | 8
UPDATED:
June 17th 2009
Spreadsheet: 826760d1682254274-let-me-add-values-to-an-array-book1
Sheet: Sheet1

Q | 1 |  |  | A | 11
W | 2 |  |  | S | 22
E | 3 |  |  | D | 33
R | 4 |  |  | F | 44
T | 5 |  |  |  |  |  |  |  |  | 1
Y | 6 |  |  |  |  |  |  |  | W | 2
 |  |  |  |  |  |  |  |  | E | 3
 |  |  |  |  |  |  |  |  | R | 4
 |  |  |  |  |  |  |  |  | T | 5
 |  |  |  |  |  |  |  |  | Y | 6
 |  |  |  |  |  |  |  |  | A | 11
 |  |  |  |  |  |  |  |  | S | 22
 |  |  |  |  |  |  |  |  | D | 33
 |  |  |  |  |  |  |  |  | F | 44