tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1e6989b8-7270-4dd2-8278-057cfe0e7bd8
Sheet: 2008-09

Table C
Graduate Student Numbers by Faculty and Year Group
2008-09
Faculty | Year 1 | Year 2 | Year 3 | Year 4 | Year 5+ | Year 6+ | Total
Arts and Humanities | 528 | 172 | 88 | 21 | 10 | 9
Biomedical Sciences | 891 | 462 | 261 | 150 | 185 | 13
Built Environment | 661 | 134 | 96 | 28 | 12 | 11
Engineering Sciences | 817 | 137 | 104 | 56 | 62 | 5
Laws | 462 | 22 | 1 | 2 | 2 | 0
Life Sciences | 612 | 235 | 169 | 45 | 21 | 8
Mathematical and Physical Sciences | 241 | 120 | 125 | 33 | 24 | 1
Social and Historical Sciences | 1106 | 210 | 81 | 30 | 18 | 11
Total
The Biomedical Sciences total includes the Graduate Institutes of Child Health, Neurology and Ophthalmology and the Eastman Dental Institute.
Spreadsheet: 754482d1636244856-how-to-generate-a-range-of-values-between-2-points-with-a-given-average-rough-example
Sheet: Sheet1

 |  | High End: | 96
 |  | Low End: | 5
 |  | Approx. Average: | 60
 |  | # of Data Points: | 15
 |  | List of Values
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
Spreadsheet: 844644d1696399118-need-a-formulae-mentioned-in-enclosed-sheet-sample
Sheet: Sheet7 (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
2023-08-23 00:00:00
DAY-1 | P | P | P | P | P | R | P | P | P | R | P | P | P | SD | P | r | R | P | R | P | P | P | P | R | P | P | P | P | P | P | R | P
DAY-2 | P | P | SD | P | P | R | P | P | P | SD | P | SD | P | SD | P | P | R | P | P | P | P | P | P | R | P | P | P | P | P | P | R | P
 |  |  | Number of Presents
 |  |  | September | October | 01 TO 07
 |  | Day-1 |  |  |  |  | NEED TO COUNT in F13
 |  | Day-2 |  |  |  |  | IF | row one is equal to october
 |  |  |  |  |  |  | IF | B3:AG3 is >= 1 and <=7
 |  |  |  |  |  |  | IF | B4:AG4 is = P
Spreadsheet: stacey_white__38981__East Curves with Dependencies
Sheet:  East dependencies

NORTHEAST |  |  |  |  |  |  |  |  |  | SOUTHEAST
West Hub | R1E |  | Nepool | R1B |  | NY Zone A | R1C |  |  | SOCO | R3 |  | Entergy | R5
PJM | R1A |  | UI System Border | B30 |  | [NAME] | R1 |  |  | FLA_GA | R3A |  | Entergy Financial | F5
First Energy | R1R |  | Boston | R1P |  | NY Zone J | R1Z |  |  | FPL_FRCC | R3C |  | Associated | R5A
VEPCO | R1V |  | Maine | R1Q |  |  |  |  |  | GTC | R3G
WestHub financial | F1E |  | WestMass | R1W |  |  |  |  |  | Duke | R3D
East Hub | R1D |  | Nepool Financial | [NAME]
FirmLD | R1F |  | 10MinSpin | R1K
 |  |  | 10MinNonSpin | R1J
 |  |  | 30MinOpResv | R1L
 |  |  | 4hourReserve | R1G
 |  |  | AGC | R1M
 |  |  | OPCAP | R1N
MIDWEST |  |  |  |  |  |  |  |  |  | ERCOT
Cinergy | R4 |  |  |  |  |  |  |  |  | [NAME] | R6
Cinergy Financial | F4 |  |  |  |  |  |  |  |  | North Texas | R6A
OPPD_NPPD | R4B |  |  |  |  |  |  |  |  | West Texas | R6B
Comed | R4C |  |  |  |  |  |  |  |  | Central Texas | R6C
Comed Financial | F4C |  |  |  |  |  |  |  |  | Valley_Texas | R6D
Manitoba | [NAME] |  |  |  |  |  |  |  |  | Tex_Mex_Border | R6E
NSP | R4N |  |  |  |  |  |  |  |  | Regulation_Up | R6W
AEP | R2A |  |  |  |  |  |  |  |  | Regulation_Down | R6X
TVA | R3B |  |  |  |  |  |  |  |  | Responsive_Reserve | R6Y
Ameren | B10 |  |  |  |  |  |  |  |  | Non_Spinning_Reserve | R6Z
Michigan | B12 |  |  |  |  |  |  |  |  | REC_ERCOT | R6R
Illinois | B37
Key
Parent
Dependant
Renewable Energy Credit
Ancillary
Spreadsheet: 138867d1327971793-q-creating-a-timeline-from-a-list-of-events-event-timeline
Sheet: Sheet2

Person | Date | Event
P1 | 2010-01-01 00:00:00 | A |  |  |  |  |  | Person | Jan 2010 | Feb 2010 | Mar 2010
P1 | 2010-01-20 00:00:00 | B |  |  |  |  |  | P1 | A, B
P1 | 2010-01-20 00:00:00 | A |  |  |  |  |  | P2 | A | C | C
P2 | 2010-01-13 00:00:00 | A
P2 | 2010-02-15 00:00:00 | C
P2 | 2010-02-16 00:00:00 | C
P2 | 2010-03-01 00:00:00 | C
Spreadsheet: 550bce12-19b0-49e6-88f8-a2f1aedca0cb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 2014-03-01 00:00:00 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 |  | City of Taylor Organizational Chart
 |  | City Council- Boards and Commissions
 |  |  |  |  |  |  | CITY COUNCIL
 |  |  |  |  |  |  | [NAME], Jr., Mayor
 |  |  |  |  |  |  | [NAME], Mayor [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  | AIRPORT BOARD |  | TEDC |  |  | TREE ADVISORY BOARD |  |  | HOUSING AUTHORITY |  | [NAME] |  |  |  | CPIC
 |  | [NAME] |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  | [NAME] |  |  |  | [NAME]
 |  | [NAME] |  | Cecil [NAME] |  |  | [NAME] |  |  | [NAME] |  | [NAME] |  |  |  | [NAME]
 |  | Darrell Reiley |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  | [NAME] |  |  |  | Holly vanScoy
 |  | Efrain Lopez |  | [NAME] |  |  | [NAME] |  |  | [NAME] (HR) |  | [NAME] |  |  |  | [NAME]
 |  | [NAME] |  | [NAME] |  |  |  |  |  | [NAME] |  | [NAME] |  |  |  | [NAME]
 |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | MAIN ST ADVISORY |  | MOODY MUSEUM |  |  | ZONING BOARD OF ADJUSTMENTS |  | PARKS & RECREATION |  |  | PLANNING & ZONING |  |  |  | [NAME]
 |  | [NAME] |  | [NAME], Chairman |  |  |  |  |  |  |  | [NAME], Chairman |  |  |  | [NAME]
 |  | Holly vanScoy |  | [NAME] |  |  |  |  | Duane Danek | [NAME] |  | [NAME] |  |  |  | [NAME]
 |  | [NAME] |  | [NAME] |  |  | [NAME], Chairman |  | [NAME] | [NAME] |  | [NAME] |  |  |  | [NAME]
 |  | [NAME] |  | [NAME] |  |  | [NAME] |  | Alma Holiday | [NAME] |  | [NAME]
 |  | [NAME], Jr. |  | [NAME] |  |  | [NAME] |  | [NAME] | [NAME] |  | [NAME]
 |  | [NAME] |  | Samye Turner |  |  | [NAME] |  | [NAME] | [NAME] |  | [NAME]
 |  | [NAME] |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  | Leland Stevens
 |  | [NAME] |  | [NAME] |  |  |  |  |  | [NAME]
 |  | [NAME] |  | [NAME] |  |  | ANIMAL CONTROL |  |  | [NAME] |  | BUILDING & STDS
 |  | [NAME] |  | [NAME] |  |  | APPEALS BOARD |  |  | H. Daniel Philhower |  | [NAME]
 |  | [NAME] |  |  |  |  | [NAME], DVM |  |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  | [NAME] |  |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  | [NAME] |  |  | [NAME] (Student) |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
Spreadsheet: 94150d1294032229-formula-for-sport-rankings-wrestlingleage
Sheet: 130

Weight | Ranking | First Name | Last Name | School | Section | Grade
130 | 1 | [NAME] | Cisneros | Selma | CS | 11
130 | 2 | [NAME] | Mecate | Redlands East Valley | SS | 12
130 | 3 | [NAME] | [NAME] | Union Mine | SJ | 12 | 2010 CIF 6
130 | 4 | [NAME] | Lizarrago | Brawley | SD | 12 | 2010 CIF 7
130 | 5 | Shayne | [NAME] | [NAME] | SJ | 10 | reno 1
130 | 6 | [NAME] | Villarreal | Gilroy | CC | 9 | reno 3
130 | 7 | [NAME] | Egleston | Turlock | SJ | 12 | reno 8
130 | 8 | Connor | Larson | Clovis East | CS | 12
130 | 9 | [NAME] | Rodriguez | Righetti | SS | 12 | zink 1
130 | 10 | Masato | [NAME] | North Torrance | SS | 12
130 | 11 | [NAME] | [NAME] | Casa Roble | SJ | 12
130 | 12 | [NAME] | Coss | Vacaville | SJ | 12 | reno t12
Spreadsheet: 748198d1631957166-finding-low-and-high-in-a-range-book1
Sheet: Sheet1

apples | 69.34616002927055 | 21.63659164550723 | 58.9048059802335
apples | 100.889282055968 | 29.08427731529175 | 26.20379094800099
apples | 20.68544609498277 | 13.45575477089806 | 13.55567158724631
apples | 53.42818496203298 | 77.86095343486038 | 80.1373752338965
apples | 3.61816940247998 | 45.83017090804932 | 44.64544402668453
apples | 21.4969221982745 | 91.33935769637503 | 67.13139465205195
apples | 59.40949753382066 | 89.9774787689327 | 51.87298324746138
apples | 73.82941653824531 | 41.36378118995969 | 96.15028527276803
apples | 7.867240280580851 | 59.82351315800349 | 56.02426410291925
apples | 51.70400402765592 | 31.46468527220317 | 81.10568989522362
apples | 21.44901764291366 | 52.82170908639381 | 100.0236669227151
apples | 56.65592589208699 | 86.36140306985902 | 31.33216085743755
apples | 58.64563681124528 | 79.04612938704958 | 32.31615655804492
apples | 13.03748680338894 | 26.98041550866596 | 38.08471988462228
apples | 27.58515571450457 | 26.12292341623409 | 95.9119851245137
apples | 81.27737568369051 | 87.77255395070395 | 45.57421557612989
apples | 11.91544305687389 | 23.98432884452899 | 70.54069789100447
apples | 56.09667219968933 | 15.65718972714841 | 95.4381624579995
oranges | 55.16580770490797 | 43.32435509050218 | 72.3061626886806
oranges | 95.16665850211608 | 74.25944999509818 | 68.36815570799055
oranges | 21.04220788692028 | 3.336501731958756 | 93.3940739549093
oranges | 80.29892095171198 | 86.66715750924602 | 45.56911431550438
oranges | 17.14580634873294 | 18.60051519925971 | 12.71707136094224
oranges | 79.49923970420937 | 21.42312821290573 | 8.611834595680705
oranges | 54.46625377787721 | 54.32800583686303 | 59.47425187128172
Spreadsheet: 782810d1654282532-vlookup-function-with-a-barcode-scanner-scann-test-v3222
Sheet: requete

 | Projet ou Bon de Travail | B21R036
 | Demandeur | À PRÉCISER
 | Date de réquisition | 2022-05-11 00:00:00
 | Date de livraison | 2022-06-06 00:00:00
 | Endroit
 | Spécification1
 | Spécification2
 | Fournisseur | INVEN002
code universelle | Code d'inventaire | Unité | PU | Quantité | Caract. | Description | Activité | Groupe | Date | Document | Description longue | Identification | No réservation | Fournisseur | No appel | Companie | Emplacement
12792 |  |  |  | 1
1013
Spreadsheet: 4a1b0562-0edf-4fcd-b1e0-fdb2fcc934d8
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
SCRYR | Test | SCRYR | [NAME], Serum | Cryptococcus Ag, S | Latex Agglutination | Plain, Red-Top Tube: Red |  |  |  |  | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.3 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild reject; Gross reject Icterus	NA Other	NA | Negative If positive, results are titered. | Monday through Sunday; 2 p.m. | Same day/1 day | 2 days | 1 | 86403 |  |  |  |  | Rochester
SCRYR | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SCRYR | Result | 8245 | Cryptococcus Ag, S | Cryptococcus Ag, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38391-9 | Cryptococcus neoformans Ag:ACnc:Pt:Ser:Ord:
Spreadsheet: 57034d1257207096-creating-a-report-from-a-table-bullwinkle
Sheet: Sheet1

AcctNum | AcctDescr | Year | Month | Scenario | Amount
10110 | Food | 2009 | 1 | Actuals | 1000
10115 | Travel | 2009 | 1 | Actuals | 1100
10110 | Food | 2009 | 2 | Actuals | 2000
10115 | Travel | 2009 | 2 | Actuals | 2100
10133 | Gifts | 2009 | 2 | Actuals | 2200
10110 | Food | 2009 | 1 | Budgets | 1500
10115 | Travel | 2009 | 1 | Budgets | 900
10133 | Gifts | 2009 | 1 | Budgets | 1200
10110 | Food | 2009 | 2 | Budgets | 2500
10115 | Travel | 2009 | 2 | Budgets | 1900
10133 | Gifts | 2009 | 2 | Budgets | 2200
Summary
2009-02-01 00:00:00
 |  | Actuals | Budgets
10110 | Food | 2000 | 2500
10133 | Gifts | 2200 | 2200
10115 | Travel | 2100 | 1900
Total |  | 6300 | 6600
Spreadsheet: e7051b1c-6284-45ae-823d-b0cb74d55a9e
Sheet: Teams

Team | OPR | QS | QS+CP | RS | Extra Match (0 or Match Number) | Sort by me! | OPR | OPR High | OPR Norm
987 |  |  |  |  | 0 |  |  |  |  |  | You should paste in the team numbers so that funky things don't happen when you sort.
341 |  |  |  |  | 0 |  |  |  |  |  | I don't remember where I got the OPR High and OPR Norm from…
1507 |  |  |  |  | 0
624 |  |  |  |  | 0 |  |  |  |  |  | Search for a team by entering in their number here:
58 |  |  |  |  | 0 |  |  |  |  |  | 254
3205 |  |  |  |  | 0
1986 |  |  |  |  | 0
254 |  |  |  |  | 3
3098 |  |  |  |  | 0
3970 |  |  |  |  | 0
78 |  |  |  |  | 0
2474 |  |  |  |  | 0
51 |  |  |  |  | 0
4265 |  |  |  |  | 0
3528 |  |  |  |  | 0
3711 |  |  |  |  | 0
3950 |  |  |  |  | 0
836 |  |  |  |  | 0
971 |  |  |  |  | 0
1477 |  |  |  |  | 0
1511 |  |  |  |  | 0
3419 |  |  |  |  | 0
27 |  |  |  |  | 0
4269 |  |  |  |  | 0
3288 |  |  |  |  | 0
233 |  |  |  |  | 0
2960 |  |  |  |  | 31
525 |  |  |  |  | 0
3965 |  |  |  |  | 0
830 |  |  |  |  | 0
2164 |  |  |  |  | 0
4226 |  |  |  |  | 0
2626 |  |  |  |  | 0
3860 |  |  |  |  | 0
1678 |  |  |  |  | 8
1885 |  |  |  |  | 0
694 |  |  |  |  | 0
3940 |  |  |  |  | 0
4069 |  |  |  |  | 0
1985 |  |  |  |  | 0
1690 |  |  |  |  | 0
537 |  |  |  |  | 0
4130 |  |  |  |  | 0
192 |  |  |  |  | 0
279 |  |  |  |  | 0
2500 |  |  |  |  | 0
1828 |  |  |  |  | 0
2130 |  |  |  |  | 0
4203 |  |  |  |  | 0
2180 |  |  |  |  | 0
1319 |  |  |  |  | 0
2881 |  |  |  |  | 0
3929 |  |  |  |  | 0
1143 |  |  |  |  | 4
1391 |  |  |  |  | 0
3951 |  |  |  |  | 0
1741 |  |  |  |  | 0
116 |  |  |  |  | 0
2522 |  |  |  |  | 0
597 |  |  |  |  | 0
85 |  |  |  |  | 0
503 |  |  |  |  | 0
3115 |  |  |  |  | 0
3132 |  |  |  |  | 31
461 |  |  |  |  | 6
1817 |  |  |  |  | 9
564 |  |  |  |  | 0
3880 |  |  |  |  | 0
604 |  |  |  |  | 0
4161 |  |  |  |  | 0
3941 |  |  |  |  | 0
1912 |  |  |  |  | 1
706 |  |  |  |  | 10
3936 |  |  |  |  | 0
293 |  |  |  |  | 0
2914 |  |  |  |  | 5
1501 |  |  |  |  | 0
415 |  |  |  |  | 0
702 |  |  |  |  | 0
1266 |  |  |  |  | 12
1683 |  |  |  |  | 0
3807 |  |  |  |  | 0
1764 |  |  |  |  | 0
1649 |  |  |  |  | 0
2844 |  |  |  |  | 0
244 |  |  |  |  | 0
207 |  |  |  |  | 2
2591 |  |  |  |  | 7
288 |  |  |  |  | 0
2757 |  |  |  |  | 0
433 |  |  |  |  | 0
120 |  |  |  |  | 0
4253 |  |  |  |  | 0
2102 |  |  |  |  | 11
1778 |  |  |  |  | 0
3847 |  |  |  |  | 0
932 |  |  |  |  | 0
571 |  |  |  |  | 0
178 |  |  |  |  | 0
1033 |  |  |  |  | 0
Spreadsheet: 172757d0-463d-48ee-b549-ba20e4de7536
Sheet: Sheet1

UTAH STATE OFFICE OF EDUCATION | Unnamed: 1 | At the bottom of your screen you will find the names of each section of this application.  To OPEN or PRINT, DOUBLE CLICK on each one.
STANDARD APPLICATION FOR FINANCIAL ASSISTANCE
1.  CHARTER SCHOOL NAME and ADDRESS (zip code)
 | Department / Division
 | Area Code and Telephone Number
2.  DATE APPLICATION SUBMITTED |  | As you develop budgets, they are generally for the months July through June of any fiscal year.  Budgets, therefore, should support months during this period.         Example:  if you begin in October, your budget should support  Oct - June.   There may be exceptions to this - check with the appropriate USOE staff member/budget officer.
3.  EXPENDITURE PERIOD                  Beginning Date of Project:
Ending Date of Project:
4.  PROJECT DIRECTOR
Name of Person Responsible for Supervising This Project:
E-Mail Address:
Phone Number:  (include area code)
Fax Number:       (include area code)
5.  IMMEDIATE SUPERVISOR
Name of Person To Whom The Project Director Reports
6.  DESCRIPTIVE NAME OF PROGRAM: Charter School Revolving Loan
7.  AMOUNT REQUESTED FOR FUNDING                               (for continued financial support for subsequent years, USOE reserves the right to renew pending successful performance and availability of funding)
The agency certifies to the best of its knowledge and belief, the data in this application is true and correct.  The agency will agree to meet all of the requirements, including the project's objectives outlined within the narrative section of this application.  The agency will also agree to comply with all other applicable State Finance Regulations as well as applicable Federal EDGAR Administrative Regulations.
______________________________________________________________
Signature of Charter School Board Chair (not designee)
Mailing Address -  Return application electronically to: | FOR USOE USE ONLY
[NAME], State Director of Charter Schools | Date Application Received:
Utah State Office of Education
[EMAIL] | Program Content Reviewed By/Date:
Phone:  (801) 538-7817   Fax: (801) 538-7750
 | Budget Reviewed By/Date:
Location:  250 East 500 South
"Revolving Loan Application for Discretionary Funds"
Spreadsheet: 83374d1283360284-counting-text-in-fields-missing-out-blanks-sample
Sheet: Sheet1

manager | employee | Hours
Manager 1 | Employee 1 | 30
Manager 1 | Employee 2 | 30
Manager 1 | Employee 3 | 25
Manager 1 | Employee 4 | 25
Manager 1 | Employee 5 | 25
Manager 1 | Employee 6 | 20
Manager 1 | Employee 7 | 37.5
Manager 1 | Employee 8 | 30
Manager 1 | Employee 9 | 15
Manager 1 | Employee 10 | 25
Manager 1 | Employee 11 | 30
Manager 2 | Employee 12 | 37.5
Manager 2 | Employee 13 | 37.5
Manager 2 | Employee 14 | 37.5
Manager 2 | Employee 15 | 37.5
Manager 2 | Employee 16 | 16
Manager 2 | Employee 17 | 37.5
Manager 2 | Employee 18 | 16
Manager 2 | Employee 19 | 37.5
Manager 2 | Employee 20 | 37.5
Manager 2 | Employee 21 | 16
Manager 2 | Employee 22 | 37.5
Spreadsheet: 2532feeb-5693-4fe6-b857-1662c8e9ccec
Sheet: 1ED OUT OF 64

ANON# | RANK
11134 | 2
18331 | 13
20533 | 15
31794 | 3
47596 | 9
50488 | 12
50527 | 5
55031 | 1
56371 | 8
74088 | 14
74711 | 15
85323 | 10
85615 | 11
91138 | 4
96087 | 7
97317 | 6
Spreadsheet: 839102d1691660719-different-values-corresponding-to-chosen-data-catering
Sheet: List1

Poskytnuté stravování zaměstnavatelem / Provided catering
(označte "x", mark "x")
 |  | Snídaně / Breakfast | Oběd / Lunch | Večeře / Dinner |  | Od |  | Od |  | [NAME] | Sazba | Dle doby | Krácení | Celkem v EUR | Kurz CZK/EUR | Celkem v CZK
1. den / day |  | x |  |  |  | 9 | 12 | 24 | 0 |  | 60 |  |  |  | 23.5 |  |  | Could you help me out solving simple request? In the attached shet is a table (columns A:E) where yellow field to be filled by an "x" if any of the catering have occured on the given date. I would like a formula in cell N4 which would give me this result: If only one cell (either breakfast, lunch or dinner) is selected the result is 25% (or 0,25), if two cells are sellected (either breakfast and lunch or breakfast and dinner or lunch and dinner) the result is 35% and if all are selected the result is 75%.
2. den / day |  | x |  |  |  | 0 | 0 | 17 | 24 |  | 60
3. den / day |  | x |  | x |  |  |  |  |  |  | 60
4. den / day |  | x | x | x |  |  |  |  |  |  | 60
5. den / day |  |  | x |  |  |  |  |  |  |  | 60
Spreadsheet: 142402d1329824728-processing-data-from-multiple-sheets-and-making-report-sample-file
Sheet: Sheet2

Quantity | Product/Item Code. | Description. | Unit Price. | Extended. | Remarks.
5 | MH-A0770B | Elbow Protection | 25
3 | MH-A0770 | Elbow Protection | 25
10 | MH-A0800B | Guantlets. [NAME]: 11 . | 57
4 | MH-H0913 | Helmet. [NAME]: L . | 28
2 | MH-H0924 | Helmet.  [NAME]
5 | MH-B1510 | Leather [NAME]: [NAME] | 7.75
5 | MH-B1511 | Leather [NAME]: [NAME] | 6.5
5 | MH-B1512 | Leather [NAME]: [NAME] | 4
5 | MH-B1513 | Leather [NAME]: [NAME] | 4.5
 |  | Freight: |  | 270
 |  | G.Total:
 |  | Packing List
CTNS # | Product/Item Code. | Description.
E3-1 | MH-A0770B | 5 Pair. Elbow Protection
 | MH-A0800B | 4 Pair. Guantlets. [NAME]: 11 .
E3-2 | MH-A0800B | 6 Pair. Guantlets. [NAME]: 11 .
 | MH-A0770B | 3 Pair. Elbow Protection | Wrong labels and packing list Marked as regular.
E3-3 | MH-H0913 | 4 Pcs. Helmet. [NAME]: L .
 | MH-H0924 | 2 Pcs. Helmet. [NAME]: Standred
 | MH-B1510 | 5 Pcs. Leather [NAME]: [NAME]
 | MH-B1511 | 5 Pcs. Leather [NAME]: [NAME]
 | MH-B1512 | 5 Pcs. Leather [NAME]: [NAME]
 | MH-B1513 | 5 Pcs. Leather [NAME]: [NAME]
Spreadsheet: 62288d1263255493-complex-matrix-count-and-rollup-matrix-count
Sheet: Sheet1

 |  |  |  | Audi |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BMW
 |  |  |  | AM |  |  |  |  | EU |  |  |  |  | AS |  |  |  |  | AM |  |  |  |  | EU |  |  |  |  | AS
User ID | Make | Region | Rating | 5 | 4 | 3 | 2 | 1 | 5 | 4 | 3 | 2 | 1 | 5 | 4 | 3 | 2 | 1 | 5 | 4 | 3 | 2 | 1 | 5 | 4 | 3 | 2 | 1 | 5 | 4 | 3 | 2 | 1
1 | Audi | AM | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | BMW | EU | 3 | 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
2 | Audi | AM | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | Audi | EU | 3 | 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
3 | BMW | AM | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | Audi | AM | 2 | 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
5 | BMW | AS | 1 | 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 | 1
6 | BMW | AM | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | Audi | EU | 4 | 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
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: Penta

Raw Material |  | Penta
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 1573.5
Total
Spreadsheet: darrell_schoolcraft__7633__NNG LAMAR NOMNATION
Sheet: 01-(10)

 |  |  |  | Time/Date
 |  |  |  | Beginning Gas Day: | 2002-01-10 00:00:00
 |  |  |  | Ending Gas Day: | 2002-01-10 00:00:00
 |  | [NAME] |  |  | 45000
 |  | Hour
 |  | Ending | [NAME] | Accumulated | Remaining | Daily Burn
 |  | CST |  |  |  | Rate
 |  | 10 | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3000
 |  |  | 0
 |  |  | 0
 |  | 1 | 0
 |  | 2 | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0