tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 05b9f583-7e4d-42cc-bdce-1092a0f60b56
Sheet: Commodity Vendor

 | ROLES
key | [NAME] | Commodity & Service - All Activities - CVN | Commodity Offer - Vendor - CVN | Corporate Vendor [NAME] | Freight - All Activities - CVN | [NAME] | Inspection Results - Vendor - CVN | Invoice Processor - Vendor - CVN | first_name | last_name | form_of_address | company | email | fax | phone | mobile_phone | street_address1 | street_address2 | city | state_province | zip_code | country | time_zone
sample | X |  | X | X |  |  | X |  | [NAME] | [NAME] | Mrs. | ABC Corp | [EMAIL] | [PHONE] | [PHONE] |  | 123 Main St. | [NAME] 456 | Topeka | KS | 66612-1505 | US | EST
1
2
3
4
5
6
7
8
9
10
…
Spreadsheet: 772229d1647096293-get-the-most-occurrences-from-an-area-and-sort-from-largest-to-smallest-forum3-12
Sheet: Sheet1

1 | 2 | 3 | 4
5 | 6 | 7 | 8
9 | 0 | 1 | 2
1 | 2 | 3 | 4
7 | 8 | 9 | 0
 |  |  |  | 2 | 1 | 9 | 8 | 7 | 4 | 3 | 0 | 6 | 5
 |  |  |  |  | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1
 |  |  |  | 1 | 2 | 3 | 4 | 7 | 8 | 9 | 0 | 5 | 6
Spreadsheet: 704582d1605630829-formula-to-sum-variable-number-of-values-in-a-column-variable-by-date-lookup-snp529example
Sheet: Sheet1

Reporting | Points | Rolling Last
Date | that Day | 7 Day Total
2020-03-05 00:00:00 | 4 | n/a
2020-03-08 00:00:00 | 2 | n/a
2020-03-09 00:00:00 | 6 | n/a
2020-03-11 00:00:00 | 6 | 18
2020-03-12 00:00:00 | 8 | 26
2020-03-13 00:00:00 | 10 | 32
2020-03-18 00:00:00 | 2 | 26
2020-03-20 00:00:00 | 2 | 14
2020-03-21 00:00:00 | 0 | 4
2020-03-24 00:00:00 | 4 | 8
2020-03-26 00:00:00 | 6 | 14
2020-03-27 00:00:00 | 6 | 18
2020-03-30 00:00:00 | 8 | 24
2020-04-02 00:00:00 | 13 | 33
2020-04-03 00:00:00 | 6 | 27
2020-04-05 00:00:00 | 7 | 34
Spreadsheet: 148982d1333638848-excel-2007-removing-rows-after-counting-subtotaling-a-data-in-a-column-request-for-help-excel-2007
Sheet: Sheet 1

 | Customer ID | Date | Action | Last Name | City | State
 | 100384021 | 2010-12-04 00:00:00 | 02 - Lost | ROGERS | TAMPA | FL
100384021 Count | 1
 | 100384033 | 2011-06-24 00:00:00 | 02 - Lost | SMITH | PLANTATION | FL
100384033 Count | 1
 | 100384038 | 2010-07-08 00:00:00 | 02 - Lost | WILLS | BUNNELL | FL
 | 100384038 | 2011-01-03 00:00:00 | 02 - Lost | WILLS | BUNNELL | FL
 | 100384038 | 2011-02-05 00:00:00 | 02 - Lost | WILLS | BUNNELL | FL
100384038 Count | 3
Spreadsheet: 187206d1350378887-totalling-after-filtering-sample-customer-spreadsheet
Sheet: Customers

 |  | week | 2 |  | Total Boxes
Customer | Boxes ordered (£1.25 per box) | No delivery due to vacation this wk? (any character = 'yes') | Delivery due this week? (1,2,3,4 = weekly; 1,3 and 2,4 = fortnightly, etc. in 4-week cycle)
Customer 1 | 1.25 |  | 1,2,3,4
Customer 2 |  |  | 2,4
Customer 3 | 1.25 |  | 1,2,3,4
Customer 4 | 1.25 | 1 | 1,2,3,4
Customer 5 |  |  | 1,3
Customer 6 |  |  | 1,3
Customer 7 |  |  | 1
Customer 8 | 2.5 | 2 | 1,2,3,4
Customer 9 |  |  | 1,3
Customer 10 | 1.25 | 1 | 1,2,3,4
Customer 11 |  |  | 2,4
Customer 12 |  |  | 1,3
Customer 13 |  | 1 | 1,3
Customer 14 |  |  | 1,2,3,4
Customer 15 |  |  | 1,3
Customer 16 |  |  | 1,2,3,4
Customer 17 |  |  | 2,4
Customer 18 | 1.25 | 5 | 1,2,3,4
Customer 19 | 2.5 |  | 1,3
Customer 20 | 1.25 | 2 | 1,2,3,4
Spreadsheet: 705792d1606310684-matching-and-searching-book11
Sheet: Sheet1

Transaction Id | Party | Amount
IMPS by SHANMUGAMP/XX7039/[PHONE]/Shanmugam | AMMAN STORES - KARUR | 46172
CS/AVINA/MANOHARAN | KEERTHI - AVINASHI | 34414
UPI/[PHONE]/PALTHANGAM/SBIN/palthangam | MEGALA - KARAMADAI | 2395
UPI/[PHONE]/D SRINIVASAN/SYNB/preethiseeni71@ | [NAME] | 15697
RTGS/JAYAGNANKIRUBA | R.J NOTES | 450000
UPI/[PHONE]/MUBEEN | S A S - MTP | 7515
IMPD by MANIKANDANS/XX2779/[PHONE]/Billpayment | THIRUPATHI SUPER MARUTHUR | 18255
UPI/[PHONE]/SHOUKATHALI/SBIN/aliayisha1983@ | V H - AGALI | 9440
Spreadsheet: 886115d1736151239-sorting-data-from-a-dynamic-list-excel-help
Sheet: Sheet1

Number of Stops | Road Name | Stops effected | Closure Type
 | data from 'stops list'  tab column E | data to 'text join' from 'stops list' column C | data from 'stop list' column H
EXAMPLE OF OUTCOME
Number of Stops | Road Name | Stops effected | Closure Type
1 | station road | 25118 | Publicity only
1 | edgwarebury lane | 15760 | Publicity only
1 | gloucester place | 29797 | publicity & hood
2 | [NAME] | 15758, 14702 | Publicity only
1 | [NAME] | 16105 | publicity & hood
Spreadsheet: 0268e56d-5d3b-4893-8a66-beaa9a99bb88
Sheet: SONET Ring - Kansas

Vendor Information
 | AT&T |  |  | Address: 12851 [NAME], St. Louis, MO 63131 |  |  | Contact Name: [NAME] | GSA Region 6 LSA         Solicitation # 6QTC-11-SH-001
Phone number:         [PHONE] |  |  | Fax number:  NA |  |  |  | Email: [EMAIL]
CLIN | Services Offered | Geographic Area Served | MINUS 10%   Month To Month | Month To Month | One-Time Installation Price | MINUS 10% One-Time Installation Price | Service Pricing Notes | Tariff
 | Dedicated Sonet Ring Service
 | Dedicated Sonet Ring OC3
K002L-PN | [NAME] [NAME] (USOC-FP5CX) | Kansas | 1415 |  | ICB | ICB | Per node
K002L-CON | OC3 Central Office [NAME] (USOC-FC5CX) | Kansas | 800 |  | ICB | ICB | Per node
K002L-DS1-N | DS1 at OC3 Node (USOC-SPRAX) | Kansas | 45 |  | N/C | N/C | Per port
K002L-DS3-N | DS3 at OC3 Node (USOC-SPRBX) | Kansas | 110 |  | N/C | N/C | Per port
K002L-MI | MILEAGE 1YAZX | Kansas | 220 |  | N/C | N/C | Per mile
 | Dedicated Sonet Ring OC12
K002M-PN | OC12 Customer [NAME] (USOC-FPDCX) | Kansas | 3080 |  | ICB | ICB | Per node
K002M-CON | OC12 Central Office [NAME] (USOC-FC5DX) | Kansas | 2095 |  | ICB | ICB | Per node
K002M-DS3-N | DS3 at OC12 [NAME] (USOC-SPRCX) | Kansas | 110 |  | N/C | N/C | Per port
K002M-0C3 | [NAME]  at OC12 [NAME] (USOC-SPREX) | Kansas | 135 |  | N/C | N/C | Per port
K002M-DS1-N | DS1 at OC12 [NAME] (USOC-SPRGX) | Kansas | 45 |  | N/C | N/C | Per port
K002M-MI | Mileage (USOC-1YAZX) | Kansas | 220 |  | N/C | N/C | Per mile
 | Dedicated Sonet Ring OC48
K002N-PN | OC48 Customer [NAME] (USOC-FPDEX) | Kansas | 4715 |  | ICB | ICB | Per node
K002N-CON | OC48 Central Office [NAME] (USOC-FC5EX) | Kansas | 4190 |  | ICB | ICB | Per node
K002N-0C12-N | OC12 at OC48 [NAME] (USOC-SPRHX) | Kansas | 360 |  | N/C | N/C | Per port
K002N-0C3-N | [NAME]  at OC48 [NAME] (USOC-SPRJX) | Kansas | 135 |  | N/C | N/C | Per port
[NAME] | DS3 at OC48 [NAME] (USOC-SPRKX) | Kansas | 110 |  | N/C | N/C | Per port
[NAME] | DS1 at OC48 [NAME] (USOC-SPRLX) | Kansas | 45 |  | N/C | N/C | Per port
K002N-MI | Mileage 1YAZX | Kansas | 220 |  | N/C | N/C | Per mile
[NAME] | Optical to Electrical add/drop mux (USOC-MXJDX) | Kansas | 550 |  | N/C | N/C | Per port
Note 1:
Spreadsheet: 55878d1256048630-comparing-columns-of-text-and-calculating-a-value-points-award-system
Sheet: Sheet1

 | Subject 1 |  | Points workings |  |  | Subject 1 Points | Subject 2 |  | Points workings |  |  | Subject 1 Points |  |  | Workings Explanation
Pupil | Predicted | Actual | Predicted points | Actual Points | Difference | Points Score | Predicted | Actual | Predicted points | Actual Points | Difference | Points Score | Total Points |  | Grade | Scores
A Pupil | A* | A |  |  |  |  | A* | A |  |  |  |  |  |  | A* | 7
 | A | B |  |  |  |  | A | B |  |  |  |  |  |  | A | 6
 | B | A |  |  |  |  | B | A |  |  |  |  |  |  | B | 5
 | C | A |  |  |  |  | C | A |  |  |  |  |  |  | C | 4
 | A | C |  |  |  |  | A | C |  |  |  |  |  |  | D | 3
 | E | C |  |  |  |  | E | C |  |  |  |  |  |  | E | 2
 | U | A |  |  |  |  | U | A |  |  |  |  |  |  | F | 1
 | B | B |  |  |  |  | B | B |  |  |  |  |  |  | U | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Point Score |  | Points Awarded
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | At target | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 or more | Above target | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1 or more | Below target | -1
Spreadsheet: 0927203e-8fbf-4adf-b2b4-4c759f692eeb
Sheet: Sheet1

Engineering and Electronics Technology* | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Associate of Applied Science Degree
Name |  |  | Student ID Number |  |  |  | Date Entered:
Address |  |  | Phone: |  |  |  | Proposed Graduation Date:
 |  |  | [NAME]:
 |  |  | Student Signature: |  |  |  |  | Date:
 |  |  | Advisor Signature: |  |  |  |  | Date:
 |  |  | Authorizing Signature: |  |  |  |  | Date:
Remedial Courses As Needed |  |  |  | Grade | Semester Taken
010 RDG + 12 DRE - Intro. to [NAME]
020 RDG + 101 GE - Improved College Reading
030 RDG + 101 GE (if not already completed)
090 ENC - Foundations of College Writing I
091 ENC - Foundations of College Writing II
055 MT - Pre-Algebra
065 MT - Elemtary Algebra
120 MT - Intermediate Algebra
General Education Courses (Core Curiculum) |  |  |  |  | Credit  Hours | Grade | Semester Taken | Note
ENG101 - Writing I |  |  |  |  | 3
Communications Course |  |  |  |  | 3
Mathematics Course (MT 150 or MAT 126) |  |  |  |  | 3
Heritage/Humanities Course |  |  |  |  | 3
Social Science Course |  |  |  |  | 3
Physics Course (PHY 171 or higher level) |  |  |  |  | 3-4
Total Gen. [NAME]. Semester Hours |  |  |  |  | 18-19
Technical Core Courses |  |  |  |  | Credit  Hours | Grade | Semester Taken | Note
ELT 110 | Circuits I |  |  |  | 5
ELT 114 | Circuits II |  |  |  | 5
ELT 210 | Devices I |  |  |  | 4
ELT 120 | Digital I |  |  |  | 3
CAD 100 | Introduction to Computer Aided Design OR |  |  |  | 3
 | Equivalent course with consent of APC |  |  |  | 3
 | Computer Literacy Course |  |  |  | 3
ELT289 | ELT Capstone Course |  |  |  | 1
Total Technical Core Hours |  |  |  |  | 24
Robotics and Automation Specialization Courses |  |  |  |  | Credit Hours | Grade | Semester Taken | Note
ELT 118 | Computer Numerical Control OR |  |  |  | 3 |  |  | Technical Electives:
MTT 132 | Manual Programming CAD/CAM/CNC |  |  |  | 3 |  |  | See Advisor
ELT 265 | Applied Fluid Power |  |  |  | 3
ELT 260 | Robotics and Industrial Automation |  |  |  | 5
ELT244 | Electrical Machinery and Controls |  |  | OR | 4
EET270 | Electrical Motor Controls |  |  | AND | 3
EET271 | Electrical Motor Controls Lab |  |  |  | 2
ELT250 | Programmable Logic Controllers |  |  | OR | 4
ELT276 | Programmable Logic Controllers |  |  | AND | 3
ELT277 | Programmable Logic Controllers Lab |  |  |  | 2
Technical Electives - see program coordinator |  |  |  |  | 5
Total Specialization Hours |  |  |  |  | 22-24
*This curriculum is to be followed by students entering this program beginning Fall 2011 or after.
Spreadsheet: 685653d1594128780-how-to-create-a-list-including-all-options-options
Sheet: Sayfa1

Car Type | Color | Package | Shift | Engine
Sedan | White | Sport | Automatic | Hybrid
Coupe | Gray | Full | Manual | Diesel
SUV | Black | Economic |  | Electric
Hatchback | Red
 | Blue
Spreadsheet: 328304d1403864125-counting-red-text-colour-when-applied-by-conditional-formatting-tester-spreadsheet
Sheet: TESTER

 |  |  | Item | Date of PAT Test | [NAME]
 |  |  | 1 | 2013-10-03 00:00:00 | 2014-10-03 00:00:00
 |  |  | 2 | 2013-10-03 00:00:00 | 2014-10-03 00:00:00
 |  |  | 3 | 2013-10-03 00:00:00 | 2014-10-03 00:00:00
 |  |  | 4 | TBA
 |  |  | 5 | 2013-10-03 00:00:00 | 2014-10-03 00:00:00
 |  |  | 6 |  | 2013-02-24 00:00:00
 |  |  | 7 |  | 2014-10-03 00:00:00
 |  |  | 8 |  | 2014-10-03 00:00:00
 |  |  | 9 |  | 2014-10-03 00:00:00
 |  |  | 10 | TBA
 |  |  | 11 |  | 2014-10-03 00:00:00
 |  |  | 12 |  | 2013-08-17 00:00:00
Spreadsheet: b973160c-3300-4e99-afcf-7b7ba5742b43
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
FRECM | Test | FRECM | Recombx MaTa Antibody Test | Recombx MaTa Antibody | Western blot | Plain, Red-Top Tube: Red |  |  | 2 | mL | Collect red-top no additive blood, separate and submit 2 mL serum in screw cap plastic vial, shipped refrigerate. | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | A final report will be attached in MayoAccess.   Test Performed by:	Athena Diagnostics 			377 Plantation Street 			Four Biotech Park 			Worcester, MA 01605 |  | 7 - 14 days | 9 - 18 days | 1 | 84182 |  |  |  |  | Athena Diagnostics
FRECM | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
FRECM | Result | Z2038 | Recombx MaTa Antibody | Recombx MaTa Antibody | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 008004b1-ee48-4eba-b44e-56f367e695e0
Sheet: 2005

DIEZ CAUSAS PRINCIPALES DE MUERTE
2 0 0 5
CODIGO | CLASIFICACIÓN INTERNACIONAL | CAUSA | TOTAL | MASCULINO | FEMENINO
1 | P00-P04 | Ciertas afecciones originadas en el periodo perinatal | 360 | 207 | 153
2 | J10-J18 | Neumonía | 129 | 74 | 55
3 | A09 | Diarrea y gastroenteritis de presunto origen infeccioso | 99 | 56 | 43
4 | Q24 | Otras malformaciones congénitas del corazón | 65 | 35 | 30
5 | A41 | Otras septicemias | 43 | 27 | 16
6 | E86 | Depleción del volumen | 21 | 12 | 9
7 | Q03 | Hidrocéfalo congénito | 14 | 10 | 4
8 | Q00 | Anencefalia y malformaciones congénitas similares | 11 | 3 | 8
9 | J81 | Edema pulmonar | 10 | 7 | 3
10 | [NAME] | Síndrome de la muerte súbita infantil | 10 | 7 | 3
FUENTE: DIGESTYC - ANUARIO ESTADÍSTICO 2009
Spreadsheet: kate_symes__18206__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-06 00:00:00 |  | 338.57 | 2800 | 269.58 | 960
 | 2001-03-05 00:00:00 |  | 327 | 2000 | 306.25 | 800 | 344.21 | 4538 | 365.1 | 1235
 | 2001-03-04 00:00:00 |  |  |  |  |  |  |  | 330 | 1125 |  | 306.25 | 2400
 | 2001-03-03 00:00:00 |  | 298.33 | 4800 | 223.97 | 584 | 350 | 75 | 350 | 600
 | 2001-03-02 00:00:00 |  | 298.33 | 4800 | 223.97 | 584 | 365 | 200 | 350 | 285
 | 2001-03-01 00:00:00 |  | 292.12 | 6800 | 280 | 200 | 429.4 | 1762 | 326.61 | 930
 | 2001-02-28 00:00:00 |  | 200.76 | 5152 | 183.49 | 1328 | 338.36 | 10459 | 285.21 | 1523
 | 2001-02-27 00:00:00 |  | 202.25 | 2912 | 135 | 200 | 275.53 | 4475 | 267.2 | 795
 | 2001-02-26 00:00:00 |  | 248.21 | 5600 | 195 | 240 | 258.41 | 5480 | 226.05 | 950
 | 2001-02-25 00:00:00 |  |  |  |  |  |  |  | 181.6 | 2500 |  | 200 | 360
 | 2001-02-24 00:00:00 |  | 196.43 | 2800 | 140 | 200 | 214.05 | 4252 | 232.89 | 760
 | 2001-02-23 00:00:00 |  | 196.43 | 2800 | 140 | 200 | 296.91 | 1345 | 300 | 400
 | 2001-02-22 00:00:00 |  | 261 | 4000 | 200 | 200 | 233.22 | 2500 | 222.69 | 1730
 | 2001-02-21 00:00:00 |  | 283.75 | 4800 | 240 | 200 | 425 | 1050 | 372 | 750
 | 2001-02-20 00:00:00 |  | 326.82 | 4400 | 300 | 600 | 324.71 | 8650 | 350.06 | 1975
 | 2001-02-19 00:00:00 |  | 326.15 | 5200 | 300 | 600 | 382.2 | 4390 | 356.1 | 1540
 | 2001-02-18 00:00:00 |  |  |  |  |  |  |  | 399.12 | 4290 |  | 320 | 600
 | 2001-02-17 00:00:00 |  | 346.07 | 3360 | 320 | 200 | 397.33 | 8623 | 394.97 | 2510
 | 2001-02-16 00:00:00 |  | 448.85 | 5200 | 425 | 200 | 444.06 | 5450 | 419.61 | 1985
 | 2001-02-15 00:00:00 |  | 448.85 | 5200 | 425 | 200 | 436.92 | 5630 | 480.72 | 1815
 | 2001-02-14 00:00:00 |  | 323 | 2000 | 300 | 0 | 601.45 | 2755 | 404.44 | 1970
 | 2001-02-13 00:00:00 |  | 307.5 | 2400 | 315 | 0 | 400.85 | 9115 | 379.49 | 2005
 | 2001-02-12 00:00:00 |  | 287.5 | 2400 | 277.5 | 0 | 380.82 | 9260 | 330.18 | 1690
 | 2001-02-11 00:00:00 |  |  |  |  |  |  |  | 398.34 | 5105 |  | 250 | 0
 | 2001-02-10 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.49 | 9007 | 373.04 | 3310
 | 2001-02-09 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.64 | 9525 | 391.75 | 2705
 | 2001-02-08 00:00:00 |  | 360.63 | 3200 | 300 | 48 | 407.79 | 7436 | 402.59 | 2830
 | 2001-02-07 00:00:00 |  | 301.25 | 4800 | 231.43 | 1400 | 415.92 | 7768 | 431.28 | 1750
 | 2001-02-06 00:00:00 |  | 211.67 | 3600 | 200 | 600 | 458.43 | 2225 | 373.4 | 1560
 | 2001-02-05 00:00:00 |  | 200 | 4400 | 200 | 200 | 346.5 | 4395 | 308.59 | 2105
 | 2001-02-04 00:00:00 |  |  |  |  |  |  |  | 339.43 | 4946 |  | 206.67 | 1800
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 796492d1663312442-worksheet-and-import-data-from-previous-worksheet-rotation-schedule-test
Sheet: 2023

Work Rotation Schedule
Year |  | Month |  |  |  |  |  |  |  |  |  | Shift Schedule |  |  |  |  |  |  |  | 1 | 2 |  |  |  |  | Pay Days
 |  | 1
Non Working Days |  | Start Day |  |  |  |  |  |  |  | Pattern |  |  |  |  | 11xxx11xx111xx22xxx22xx222xx |  |  |  |  |  |  |  |  |  |  |  |  | Period | 28 |  |  | days
Holidays only |  | 2 |  |  | 1:Sun, 2:Mon |  |  |  |  | Starting |  |  |  |  | 2022-01-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Starting | 2022-01-10 00:00:00
 |  | Work Rotation Schedule
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [42]
Work Days
Pay Day
Work Days
Pay Day
Work Days
Pay Day
Work Days
Pay Day
Work Days
Pay Day
Work Days
Pay Day
Work Days
Pay Day
Work Days
Pay Day
Work Days
Pay Day
Work Days
Pay Day
Work Days
Pay Day
Work Days
Pay Day
Non Working Days | Code | Weekend1 | Weekend2
Holidays only | 0000000 | 0 | 0
Saturday, Sunday | 1 | 7 | 1
Sunday, Monday | 2 | 1 | 2
Monday, Tuesday | 3 | 2 | 3
Tuesday, Wednesday | 4 | 3 | 4
Wednesday, Thursday | 5 | 4 | 5
Thursday, Friday | 6 | 5 | 6
Friday, Saturday | 7 | 6 | 7
Sunday only | 11 | 1 | 0
Monday only | 12 | 2 | 0
Tuesday only | 13 | 3 | 0
Tuesday only | 13 | 4 | 0
Wednesday only | 14 | 5 | 0
Thursday only | 15 | 6 | 0
Friday only | 16 | 7 | 0
Tuesday only | 13 | 8 | 0
Saturday only | 17 | 9 | 0
CHOSEN
Spreadsheet: 790685d1659950156-chance-of-rolling-multiple-dice-and-getting-a-sum-higher-than-a-number-probabilty-sum-dicces-hd
Sheet: Distribution

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 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 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120 | 121 | 122 | 123 | 124 | 125 | 126 | 127 | 128 | 129 | 130 | 131 | 132 | 133 | 134 | 135 | 136 | 137 | 138 | 139 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 | 151 | 152 | 153 | 154 | 155 | 156 | 157 | 158 | 159 | 160 | 161 | 162 | 163 | 164 | 165 | 166 | 167 | 168 | 169 | 170 | 171 | 172 | 173 | 174 | 175 | 176 | 177 | 178 | 179 | 180 | 181 | 182 | 183 | 184 | 185 | 186 | 187 | 188 | 189 | 190 | 191 | 192 | 193 | 194 | 195 | 196 | 197 | 198 | 199 | 200 | 201 | 202 | 203 | 204 | 205 | 206 | 207 | 208 | 209 | 210 | 211 | 212 | 213 | 214 | 215 | 216 | 217 | 218 | 219 | 220 | 221 | 222 | 223 | 224 | 225 | 226 | 227 | 228 | 229 | 230 | 231 | 232 | 233 | 234 | 235 | 236 | 237 | 238 | 239 | 240 | 241 | 242 | 243 | 244 | 245 | 246 | 247 | 248 | 249 | 250 | 251 | 252 | 253 | 254 | 255 | 256 | 257 | 258 | 259 | 260 | 261 | 262 | 263 | 264 | 265 | 266 | 267 | 268 | 269 | 270 | 271 | 272 | 273 | 274 | 275 | 276 | 277 | 278 | 279 | 280 | 281 | 282 | 283 | 284 | 285 | 286 | 287 | 288 | 289 | 290 | 291 | 292 | 293 | 294 | 295 | 296 | 297 | 298 | 299 | 300 | 301 | 302 | 303 | 304 | 305 | 306 | 307 | 308 | 309 | 310 | 311 | 312 | 313 | 314 | 315 | 316 | 317 | 318 | 319 | 320 | 321 | 322 | 323 | 324 | 325 | 326 | 327 | 328 | 329 | 330 | 331 | 332 | 333 | 334 | 335 | 336 | 337 | 338 | 339 | 340 | 341 | 342 | 343 | 344 | 345 | 346 | 347 | 348 | 349 | 350 | 351 | 352
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Spreadsheet: 832573d1686444472-sum-up-until-a-blank-cell-appears-summations
Sheet: Sheet1

All the red zeros are cells that reference another worksheet. Aka, they have formulas.
This summation forward I would like to not see. I have been trying to play around with my current formula to somehow detect the blank row and no longer continue with the summation.
What I currently have |  |  |  |  |  |  | What I want
Room # | Room Name | Individual Size | Group size |  |  |  | Room # | Room Name | Individual Size | Group size
1-a | KITCHEN LEVEL 1 | 1300.888888888888 |  |  |  |  | 1-a | KITCHEN LEVEL 1 | 1300.888888888888 | 1300.888888888888
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
1-b | KITCHEN LEVEL 2 | 405.555555555555 |  |  |  |  | 1-b | KITCHEN LEVEL 2 | 405.555555555555 | 405.555555555555
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
1-c | KITCHEN LEVEL 3 | 833.3333333333352 |  |  |  |  | 1-c | KITCHEN LEVEL 3 | 833.3333333333352 | 833.3333333333352
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
1-04 | PROGRAM LEVEL 1 | 309.9999999999972 |  |  |  |  | 1-04 | PROGRAM LEVEL 1 | 309.9999999999972 | 619.9999999999944
 | PROGRAM LEVEL 1 | 309.9999999999972 |  |  |  |  |  | PROGRAM LEVEL 1 | 309.9999999999972
0 | 0 | 0 |  |  |  |  | 0
1-d | PROGRAM LEVEL 2 | 1379.999999999999 |  |  |  |  | 1-d | PROGRAM LEVEL 2 | 1379.999999999999 | 1379.999999999999
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
1-e | PROGRAM LEVEL 3 | 309.9999999999997 |  |  |  |  | 1-e | PROGRAM LEVEL 3 | 309.9999999999997 | 309.9999999999997
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
1-f | LOBBY LEVEL 1 | 613.3333333333319 |  |  |  |  | 1-f | LOBBY LEVEL 1 | 613.3333333333319 | 613.3333333333319
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
1-g | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  | 1-g | LOBBY LEVEL 2 | 275.555555555558 | 1102.222222222232
 | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  | LOBBY LEVEL 2 | 275.555555555558
 | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  | LOBBY LEVEL 2 | 275.555555555558
 | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  | LOBBY LEVEL 2 | 275.555555555558
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
1-h | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  | 1-h | LOBBY LEVEL 2 | 275.555555555558 | 551.111111111116
 | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  | LOBBY LEVEL 2 | 275.555555555558
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
0 | 0 | 0 |  |  |  |  | 0 | 0 | 0