tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 744060d1628890956-array-formula-help-sample-budget
Sheet: Sheet1

 |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL
Total Sales | Product 1 | [NAME]
 | Product 2 | Racket
 | Product 3 | Net
 | Product 4 | Gloves
 | Product 5 | Shoes
 | Product 6 | Bicycle
 |  |  |  | QTY BUDGET IN UNITS
 |  | ITEM | Price ea | JAN | FEB | MAR | APR | MAY | JUN | JUL
Store 1 | Product 1 | [NAME] | 5 | 50 | 51
 | Product 2 | Racket | 4 | 10 | 15
 | Product 3 | Net | 5 | 5 | 8
 | Product 4 | Gloves
 | Product 5 | Shoes
 | Product 6 | Bicycle
Store 2 | Product 1 | [NAME] | 6 | 8 | 3
 | Product 2 | Racket | 3 | 52 | 25
 | Product 3 | Net
 | Product 4 | Gloves | 2 | 32
 | Product 5 | Shoes
 | Product 6 | Bicycle
Store 3 | Product 1 | [NAME] | 8 | 54 | 50
 | Product 2 | Racket
 | Product 3 | Net | 5 | 55 | 20
 | Product 4 | Gloves | 5 | 21 | 15
 | Product 5 | Shoes
 | Product 6 | Bicycle
Store 4 | Product 1 | [NAME] | 1 | 5 | 8
 | Product 2 | Racket
 | Product 3 | Net | 5 | 66 | 10
 | Product 4 | Gloves | 3 | 20 | 15
 | Product 5 | Shoes | 3 | 1
 | Product 6 | Bicycle | 2 | 25 | 30
Spreadsheet: 455897d1460554158-scheduling-production-orders-proj_nivelservico
Sheet: A3

 | [NAME]04-2016 a 18-04-2016 (Week 15)   Acerto
 | Day | Ordem | Qtd Req | Qtd Rem | Material | Descricao | Bulk | Bulk Qty | Packaging | Setup | Rem Prod Hrs | Data Inic. | [NAME] | Data Fim | [NAME] | Em falta | 1ª Prod.
 | 2ª Feira | 3000079725 | 42 | 17.304 | 31-48657 | AF 52X132 SF. WIL.PEAU SENSIBLE 9071280 | SF5152787 | 8348.634 | SHR 6 & TRY 6 | 1.5 | 4.964 | 2016-04-11 00:00:00 | 11:48:35 | 2016-04-12 00:00:00 | 10:36:39
 | 3ª Feira | 3000080010 | 42 | 42 | 31-48657 | AF 52X132 SF. WIL.PEAU SENSIBLE 9071280 | SF5152787 | 0 | SHR 6 & TRY 6 | 0.25 | 9.545 | 2016-04-12 00:00:00 | 10:36:39 | 2016-04-13 00:00:00 | 12:54:23
 | 4ª Feira | 3000079127 | 64.4 | 64.4 | 31-49560 | AF 45x190 200ML VO5 [NAME]) | HM5144757 | 10604.942 | SHR 6 & TRY 6 | 1.5 | 18.58 | 2016-04-13 00:00:00 | 12:54:23 | 2016-04-15 00:00:00 | 08:29:13
 | 6ª Feira | 3000080746 | 25 | 25 | 51-49122 | AF 53X110 150ML SUN CARE MOUSSE SPF50    (W15) | OU5149124 | 3366.555 | SHR 6 | 5.5 | 7.631 | 2016-04-15 00:00:00 | 08:29:13 | 2016-04-18 00:00:00 | 15:07:06 | 6301986;5149123;
 | LINHA PROGRAMADA A HORÁRIO NORMAL MAS; 4ª Feira o 2º TURNO DA A6 VÊM CÁ. DESPROGRAMADA 4H NO SUN CARE (CLIENTE VEM ASSISTIR)
 | Day | Ordem | Qtd Req | Qtd Rem | Material | Descricao | 6ª Feira |  | 2ª Feira | 3ª Feira | 4ª Feira | 5ª Feira | 6ª Feira | Total
 | 2ª Feira | 3000079725 | 42 | 17.304 | 31-48657 | AF 52X132 SF. WIL.PEAU SENSIBLE 9071280
 | 3ª Feira | 3000080010 | 42 | 42 | 31-48657 | AF 52X132 SF. WIL.PEAU SENSIBLE 9071280
 | 4ª Feira | 3000079127 | 64.4 | 64.4 | 31-49560 | AF 45x190 200ML VO5 [NAME])
 | 6ª Feira | 3000080746 | 25 | 25 | 51-49122 | AF 53X110 150ML SUN CARE MOUSSE SPF50    (W15)
 | OEE [NAME]
 | Total de Unidades Por Dia
 | Total de Unidades Na Semana
Spreadsheet: benjamin_rogers__1023__pwr data
Sheet: Capacity

NEW CAPACITY ( MW)
 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003/Unk. | TOTAL
ECAR | 42 | 1205 | 3360 | 5335 | 5192 | 5219
ERCOT | 180 | 1454 | 6909 | 10400 | 3310 | 3090
FRCC | 541 | 249 | 1969 | 1897 | 4417 | 11938
MAAC | 214 | 469 | 507 | 1522 | 6665 | 1313
MAIN |  | 1989 | 2192 | 3739 | 3806 | 3000
MAPP | 31 | 507 | 98 | 896 | 100 | 590
NPCC | 473 | 508 | 3801 | 12266 | 7379 | 540
NYPP |  |  |  | 3730 | 2490 | 4197
SERC | 838 | 2461 | 6104 | 7908 | 5738 | 3150
SPP | 47 | 1387 | 1969 | 3093 | 6908 | 1103
WSCC | 285 | 841 | 516 | 8151 | 9656 | 23371
TOTAL
Spreadsheet: 814286d1674252883-looking-for-formula-that-shows-upcoming-due-dates-for-different-types-of-forms-due-date-calendar
Sheet: Sheet1

 | Today's Date
 |  |  |  | Upcoming Forms Due | Today's Date
Form # | Submitted | Due Date |  | Form # | Submitted | Due Date
Form 1 | NO | 2023-01-30 00:00:00 |  | [NAME] Here | [NAME] Here | [NAME] Here
Form 29 | YES | 2023-01-30 00:00:00
Form 100 | NO | 2023-01-22 00:00:00
Form 1005 | YES | 2023-01-30 00:00:00
Form 1120 | NO | 2023-02-05 00:00:00
Form 9982 | NO | 2023-02-15 00:00:00
Form 220x | NO | 2023-02-01 00:00:00
Form 1111 | YES | 2023-02-01 00:00:00
Form 45 | NO | 2023-03-15 00:00:00
 |  |  |  | Answers … | Today's Date
 |  |  |  | Form # | Submitted | Due Date
 |  |  |  | Form 100 | NO | 2023-01-22 00:00:00
 |  |  |  | Form 1 | NO | 2023-01-30 00:00:00
 |  |  |  | Form 220x | NO | 2023-02-01 00:00:00
 |  |  |  | Form 1120 | NO | 2023-02-05 00:00:00
 |  |  |  | Form 9982 | NO | 2023-02-15 00:00:00
 |  |  |  | Form 45 | NO | 2023-03-15 00:00:00
Spreadsheet: 44765d1243523966-random-number-not-more-than-4-times-rand
Sheet: Sheet1

 |  | 1st |  | 2nd |  | 3rd |  | 4th
Name 1 | 0.562866402759477 | 2 | 3 | 2 | 3 | 2 | 3 | 2
Name 2 | 0.7574842936600619 | 1 | 4 | 1 | 4 | 1 | 4 | 1
Name 3 | 0.6485106079762535 | 2 | 3 | 2 | 3 | 2 | 3 | 2
Name 4 | 0.3821452359920512 | 3 | 2 | 3 | 2 | 3 | 2 | 3
Name 5 | 0.6046156477738427 | 2 | 3 | 2 | 3 | 2 | 3 | 2
Name 6 | 0.6665274393195695 | 2 | 3 | 2 | 3 | 2 | 3 | 2
Name 7 | 0.9303157720082773 | 1 | 4 | 1 | 4 | 1 | 4 | 1
Name 8 | 0.02689912351438783 | 4 | 1 | 4 | 1 | 4 | 1 | 4
Name 9 | 0.983918772494806 | 1 | 4 | 1 | 4 | 1 | 4 | 1
Name 10 | 0.1577500660645601 | 4 | 1 | 4 | 1 | 4 | 1 | 4
Name 11 | 0.9800357296290763 | 1 | 4 | 1 | 4 | 1 | 4 | 1
Name 12 | 0.7429854948839667 | 1 | 4 | 1 | 4 | 1 | 4 | 1
Name 13 | 0.7910481499488409 | 1 | 4 | 1 | 4 | 1 | 4 | 1
Name 14 | 0.5085091154617212 | 3 | 2 | 3 | 2 | 3 | 2 | 3
Name 15 | 0.5290813710342803 | 3 | 2 | 3 | 2 | 3 | 2 | 3
Name 16 | 0.5860610924009422 | 2 | 3 | 2 | 3 | 2 | 3 | 2
Name 17 | 0.3310990199155426 | 4 | 1 | 4 | 1 | 4 | 1 | 4
Name 18 | 0.5319827915248245 | 3 | 2 | 3 | 2 | 3 | 2 | 3
Name 19 | 0.0300516826929984 | 4 | 1 | 4 | 1 | 4 | 1 | 4
Name 20 | 0.444747890805834 | 3 | 2 | 3 | 2 | 3 | 2 | 3
Name 21 | 0.6419284319067498 | 2 | 3 | 2 | 3 | 2 | 3 | 2
Name 22 | 0.2543334040174652 | 4 | 1 | 4 | 1 | 4 | 1 | 4
Name 23 | 0.1841760667996908 | 4 | 1 | 4 | 1 | 4 | 1 | 4
Name 24 | 0.4716092108977243 | 3 | 2 | 3 | 2 | 3 | 2 | 3
Group 1 |  | 6 |  | 6 |  | 6 |  | 6
Group 2 |  | 6 |  | 6 |  | 6 |  | 6
Group 3 |  | 6 |  | 6 |  | 6 |  | 6
Group 4 |  | 6 |  | 6 |  | 6 |  | 6
 |  | 24 |  | 24 |  | 24 |  | 24
Spreadsheet: 858358d1707078206-harvey-balls-not-showing-color-in-drop-down-list-student-attendance-1
Sheet: 3rd Period

Attendance
2nd Semester | February
3rd Period | [NAME] 8:40-8:45 |  |  |  | Key: |  | Red | Math |  | Gray | English |  | Yellow | Other Subject |  |  | Green | Lunch |  | Blue | After-School
 | [NAME] (Wed) 8:45-9:20
 | Instruction 9:40-10:36 / 9:25-9:55 |  | Week 1 |  |  |  |  | Week 2 |  |  |  |  | Week 3 |  |  |  |  | Week 4 |  |  |  |  | Week 5
 |  |  | M | T | W | Th | F | M | T | W | Th | F | M | T | W | Th | F | M | T | W | Th | F | M | T | W | Th | F
 |  |  |  |  |  | 1 | 2 | 5 | 6 | 7 | 8 | 9 | 12 | 13 | 14 | 15 | 16 | 19 | 20 | 21 | 22 | 23 | 26 | 27 | 28 | 29
# | Students | Picture |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Unexcused Absences | Total Excused Absences | Total Tardies | Total
ATND-001 | Annalise Vasquez | 8vaWRtiSTRq-duJAAlL4eA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gray | Red | Yellow | Red | Red
ATND-002 | Cherish Grant | uyroswpESFmXIRFzDiv7cQ |  |  |  |  | Red
ATND-003 | [NAME] | RYO2sTrFQvqfqFsy3PYl1A | Gray |  |  | Gray |  |  |  | Gray |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yellow
ATND-004 | Dashawn Meyers | Jc2mdZqcTayMppkcrz_1mQ
ATND-005 | [NAME] | XGyLJCulSfa9FFqm-EXXYg |  |  | Gray |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yellow
ATND-006 | [NAME] | sCeD04bLTqqtcQbBWXLCeg |  |  |  |  |  |  |  |  | Red
ATND-007 | Ivy Li | uZ_B1f2hRWSNVCwU2Yavpw |  |  |  |  |  |  | Gray |  |  |  |  |  |  | Yellow | Yellow | Red |  |  | Yellow
ATND-008 | [NAME] | 7PPIyj5BQAmUrv0faFO85Q
ATND-009 | Keagan [NAME] | rRxo0vRDTwmnufXwwInPlw
ATND-010 | King Holt | OT8NiJv0RT68zanyQUb5Ag | Yellow |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gray
ATND-011 | [NAME] | fkDgXJXdTvaH2ej0W_yA1Q |  |  |  |  |  |  |  |  |  |  |  |  | Yellow
ATND-012 | [NAME] | KthEBR88S-uDW7thePXnbA | Gray
ATND-013 | [NAME] | eeeXhbCdQheKpufaA4yY3A |  |  |  |  |  | Yellow
ATND-014 | [NAME] | UalAcv1gRH2VkjW28ju5Kw
ATND-015 | Marques Klein | LnWV1okLQ36LP86VvI2wzw
ATND-016 | [NAME] | Z1Yk3GThTcitJJl1Iy5asw |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Red
ATND-017 | [NAME] | 2IH2SBE4RwCSFvpKqmSYKQ
ATND-018 | Mya Page | J1yr6JXdQ9udQ964XOpYNg | Red
ATND-019 | Quinn Baird | rGfigAc7R46qKv_aTV_Qcg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gray
ATND-020 | [NAME] | CWP2a5mJQcOcpPkGIwsciw
ATND-021 | [NAME] | FzfrbrM6TICkb9f2fv2AFA |  |  | Red |  | Red |  |  |  | Gray |  | Gray |  |  |  | Gray |  |  | Gray
ATND-022 | [NAME] | t4uYxZcgRP-OWWj5orMX-g |  |  |  |  |  |  |  |  |  | Yellow
ATND-023 | [NAME] | Yyt8ysQrTc-dWn9-2uLcOw
ATND-024 | Scarlet Harper | U6YOR9oVT5C4z6X3HaG1fg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yellow
ATND-025 | [NAME] | yZDVsqmVQiWHeAAfvwHm_g
ATND-026 | Total Unexcused Absences
ATND-027 | Total Excused Absences
ATND-028 | Total Tardies
Spreadsheet: e3981382-f651-4018-a091-72109a919a0b
Sheet: Sheet1

VICE-PRESIDENT OF THE UNITED STATES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Democratic Presidential Primary
1996-02-20 00:00:00
Summary By
Counties | [NAME] | [NAME] | [NAME] | Chimento | [NAME] | [NAME] | Dornan | Forbes
Belknap | 10 | 0 | 15 | 5 | 30 | 14 | 0 | 7
Carroll | 1 | 0 | 1 | 1 | 26 | 3 | 0 | 0
Cheshire | 7 | 0 | 7 | 2 | 7 | 14 | 1 | 7
Coos | 9 | 11 | 28 | 3 | 8 | 10 | 3 | 12
[NAME] | 8 | 0 | 13 | 3 | 10 | 8 | 0 | 10
Hillsborough | 57 | 0 | 56 | 8 | 22 | 43 | 0 | 20
Merrimack | 9 | 0 | 18 | 3 | 14 | 16 | 0 | 13
Rockingham | 26 | 0 | 49 | 7 | 25 | 39 | 0 | 36
[NAME] | 16 | 0 | 16 | 7 | 13 | 16 | 0 | 8
[NAME] | 5 | 0 | 16 | 3 | 17 | 8 | 0 | 6
Totals | 148 | 11 | 219 | 42 | 172 | 171 | 4 | 119
Summary By
Counties | [NAME] | Gramm | Harder | [NAME] | Keyes | [NAME] | LaRouche
Belknap | 734 | 1 | 1 | 0 | 13 | 3 | 3
Carroll | 470 | 0 | 4 | 0 | 0 | 1 | 0
Cheshire | 1495 | 0 | 0 | 0 | 10 | 2 | 3
Coos | 480 | 1 | 2 | 0 | 2 | 2 | 1
[NAME] | 1699 | 2 | 3 | 0 | 12 | 5 | 1
Hillsborough | 2919 | 8 | 3 | 0 | 44 | 2 | 1
Merrimack | 2290 | 0 | 4 | 0 | 17 | 1 | 1
Rockingham | 3474 | 4 | 5 | 4 | 20 | 8 | 6
[NAME] | 1897 | 1 | 4 | 0 | 12 | 4 | 3
[NAME] | 952 | 0 | 4 | 0 | 9 | 1 | 1
Totals | 16410 | 17 | 30 | 4 | 139 | 29 | 20
Summary By
Counties | Lugar | [NAME] | [NAME] | Paulsen | Perot | [NAME] | [NAME]
Belknap | 7 | 0 | 1 | 5 | 4 | 15 | 1
Carroll | 0 | 1 | 0 | 2 | 1 | 5 | 0
Cheshire | 6 | 0 | 10 | 4 | 0 | 19 | 1
Coos | 3 | 1 | 0 | 3 | 1 | 12 | 5
[NAME] | 3 | 1 | 5 | 10 | 3 | 31 | 3
Hillsborough | 7 | 1 | 13 | 5 | 5 | 90 | 6
Merrimack | 5 | 0 | 6 | 4 | 1 | 32 | 0
Rockingham | 7 | 0 | 13 | 12 | 5 | 72 | 5
[NAME] | 3 | 0 | 8 | 7 | 3 | 27 | 1
[NAME] | 1 | 0 | 1 | 0 | 0 | 9 | 6
Totals | 42 | 4 | 57 | 52 | 23 | 312 | 28
There were no democratic candidates for Vice President. The above tables show
the candidates who received write-in votes for Vice President in alphabetical order
Spreadsheet: 746182d1630563903-validated-data-list-based-on-a-returned-value-eba-pay-details
Sheet: AMWU - Metal Eng Major

 | Work Group | Rates |  | ECWA1 | ECWA2 | ECWA3 | ECWA4 | ECW1 | ECW2 | ECW3 | ECW4 | ECW5 | ECW6 | ECW7 | ECW8 | ECW9
 | Description |  |  | 1st Yr Apprentice | 2nd Yr Apprentice | 3rd Yr Apprentice | 4th Yr Apprentice | Trades Assistance | Eng Const. [NAME] | Base Trades | Above Base Trades | Special Class 1 | Special Class 2 | Special Class 3 - Eng. Constr. Trade L3 | Advance Eng. Trade L1 | Advance Eng. Trade L2
 | Wage Rate
 | Weekly Rate |  |  | 1000 | 1050 | 1100 | 1150 | 1200 | 1250 | 1300 | 1350 | 1400 | 1450 | 1500 | 1550 | 1600
 | No. Hours |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | [NAME]
 | Overtime Rate
 | Casual Loading | 0.25 | Per Hour
 | Allowances
 | Tool Allowance | 20 | Per Week
 | [NAME] | 50 | Per Week
 | Meal Allowance | 0 | Per day (OT)
 | Multi-Ticket Allowance | 15 | Per Week
 | First Aid Allowance | 21.54 | Per Week
 | Travel Allowance | 49.29
 | Site Allowance | 6.63 | Per Hour
 | Overtime Productivity Allowance | 0 | Per Hour
 | Union - OnCosts
 | Protect | 5.83 | Per Hour
 | NEST
 | WageGuard | 0.026
 | Superannuation | 0.1 | 250
 | CoInvest | 0
 | Per EBA
 | Admin - OnCosts
 | Payroll Tax | 0.0485
 | Workers Comp | 0.048
 | Medical | 1 | Per Hour
 | Phone Allowance | 0.25 | Per Hour
 | Workwear | 1 | Per Hour
 | Total Hourly Charge
 | [NAME]
 | Leading Hand Staff |  | No.
 | Leading Hand Allowance | 2.4% - 9% | Per Hour
 | LAFHA |  | Days
 | Day Rate | 175
 | Weekly Rate | 905
Spreadsheet: 764758d1642962066-checking-validity-of-vaccination-records-vaccination-records
Sheet: Sheet1

Name | 1st doze | 2nd | 3rd | Status
[NAME] | 2021-01-01 00:00:00 | 2021-02-02 00:00:00 |  |  | Expired
[NAME] | 2021-03-03 00:00:00 | 2021-03-24 00:00:00 | 2021-12-22 00:00:00 |  | Valid
[NAME] | 2021-04-19 00:00:00 | 2021-05-09 00:00:00 |  |  | Valid
[NAME]
Esther | 2021-05-27 00:00:00 | 2021-08-25 00:00:00
[NAME] | 2021-04-05 00:00:00 | 2021-04-26 00:00:00 | 2022-01-10 00:00:00 |  | Valid
George | 2021-02-13 00:00:00 | 2021-04-10 00:00:00 |  |  | Expired
Spreadsheet: 765790d1643602578-formula-for-missing-numbers-in-a-range-based-on-criteria-missing-number-wider-range-ans3
Sheet: Sheet1

Report # | Version # | Item # |  |  | Missing numbers till next occurance.
20-A-1 | 0 | 1
20-A-1 | 0 | 3
20-A-1 | 1 | 1
20-A-1 | 1 | 5
21-B-2 | 0 | 1
21-B-2 | 0 | 2
21-B-2 | 1 | 1
21-B-2 | 1 | 3
21-B-2 | 1 | 13
Spreadsheet: 877982d1724931945-how-to-list-column-without-duplicates-by-formula-list-all-sn-without-duplicates
Sheet: Sheet1

 | 203217303051017418151142 |  |  |  | in this way I do not know why not all SN added there are 3 not exist |  | this way it is working to add all but if there is duplicate values it is removing all of it I want to keep just 1
 | 202917303051017417549365
 | 190802203051017408043796
 | 190802203051017408042864
 | 320612455
 | 320693287
 | 332303365
 | 202967303051017417658014
 | 190802203051017408043425
 | 190802203051017408043681
 | 211417303061211220933148
 | 190552203051017407962314
 | CND1202BT5
 | 211437303061211220954484
 | 202917303051017417549365
 | 202967303051017417658014
 | 202917303051017417549365
Spreadsheet: 131410d1323038328-how-to-create-an-inventory-spreadsheet-sample-inventory-record
Sheet: Part Listing

Part Listing
Part No. | Description | Mfg | Serial No. | Firmware version | location | qty
45612-001 | Main X-axis motor | Putman |  |  | r1s3 | 1
127886 | Main board | IBM | 56789123 | 67v1 | r3s1 | 1
45612-001 | Main X-axis motor | Putman |  |  | r1s3 | 1
127886 | Main board | IBM | 56789124 | 67v1 | r3s1 | 1
45612-001 | Main X-axis motor | Putman |  |  | r1s3 | 1
45612-001 | Main X-axis motor | Putman |  |  | r1s3 | 1
127886 | Main board | IBM | 56789125 | 67v1 | r3s1 | 1
45612-001 | Main X-axis motor | Putman |  |  | r1s3 | 1
127886 | Main board | IBM | 56789126 | 67v1 | r3s1 | 1
127886 | Main board | IBM | 56789127 | 67v1 | r3s1 | 1
127886 | Main board | IBM | 56789128 | 67v1 | r3s1 | 1
127886 | Main board | IBM | 56789129 | 67v1 | r3s1 | 1
Spreadsheet: 01b90e8f-286c-412f-ab87-0ad0976561d5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
7'S MEETING AGENDA
Date:
Time:
Venue:
Objective: | Teams update and action items
Agenda
1 | Attendance register
2 | Explanation of oval & running of games – note end of game and timing re hooter & ref whistle
3 | Complementary programs for teams
4 | Match reports – 5 copies hand in. Report to ground manager 10 minutes before kick off
5 | Ensure jersey numbers are per program
 | For team sheets, player of tournament selection, complete & check team change sheets at Ops room)
6 | Food, photos and DVD’s
7 | Scrum engagement, Code of Conduct & Tackling
8 | Player Movement, Match Officials general
9 | Medical
10 | [NAME]
Spreadsheet: 703547d1605039202-extract-rows-from-table-that-match-criteria-in-one-column-team-book-example
Sheet: Ushers

 | Name | [NAME] | Phone | Team
 |  | 0 | 1231231234 | Ushers
 | [NAME] | 0 | 1111111111 | Ushers
 | Mark | 0 | 2222222222 | Ushers, Safety
 | [NAME] | 0 | 3333333333 | Prayer Partners, Ushers
 | [NAME] | 0 | 6666666666 | Safety, Ushers
Spreadsheet: 162577d1339986951-excel-2007-how-can-i-join-two-formulas-mjc-registro-interactivo
Sheet: DistNotas

[NAME]
[NAME] A Mayo
Por Grupo
2do R
NOTAS |  | 100-90 |  | 89-80 |  | 79-70 |  | 69-60 |  | 59-0 |  | TOTAL ESTUDIANTES
Género |  | M | F | M | F | M | F | M | F | M | F
ESTUDIANTES
Porcientos |  |  |  |  |  |  |  |  |  |  |  | %ABC
TOTAL % |  |  |  |  |  |  |  |  |  |  |  | %DF
2do M
NOTAS |  | 100-90 |  | 89-80 |  | 79-70 |  | 69-60 |  | 59-0 |  | TOTAL ESTUDIANTES
Género |  | M | F | M | F | M | F | M | F | M | F
ESTUDIANTES
TOTAL
POR CIENTOS
3ro R
NOTAS |  | 100-90 |  | 89-80 |  | 79-70 |  | 69-60 |  | 59-0 |  | TOTAL ESTUDIANTES
Género |  | M | F | M | F | M | F | M | F | M | F
ESTUDIANTES
TOTAL
POR CIENTOS
3ro D
NOTAS |  | 100-90 |  | 89-80 |  | 79-70 |  | 69-60 |  | 59-0 |  | TOTAL ESTUDIANTES
Género |  | M | F | M | F | M | F | M | F | M | F
ESTUDIANTES
TOTAL
POR CIENTOS
4to G
NOTAS |  | 100-90 |  | 89-80 |  | 79-70 |  | 69-60 |  | 59-0 |  | TOTAL ESTUDIANTES
Género |  | M | F | M | F | M | F | M | F | M | F
ESTUDIANTES
TOTAL
POR CIENTOS
[NAME]
2do R-M
NOTAS |  | 100-90 |  | 89-80 |  | 79-70 |  | 69-60 |  | 59-0 |  | TOTAL ESTUDIANTES
Género |  | M | F | M | F | M | F | M | F | M | F
ESTUDIANTES
TOTAL
POR CIENTOS
3ro R-D
NOTAS |  | 100-90 |  | 89-80 |  | 79-70 |  | 69-60 |  | 59-0 |  | TOTAL ESTUDIANTES
Género |  | M | F | M | F | M | F | M | F | M | F
ESTUDIANTES
TOTAL
POR CIENTOS
Spreadsheet: 65738d1266422497-changing-horizontal-data-to-be-shown-vertically-book1
Sheet: Sheet2

 | Q1 | Q2 | Q3 | Q4
2008 | 5 | 10 | 2 | 3
2009 | 6 | 8 | 12 | 14
2010 | 3 | 5 | 2 | 9
2008 Q1 | 2008 Q2 | 2008 Q3 | 2008 Q4 | 2009 Q1 | 2009 Q2 | 2009 Q3 | 2009 Q4 | 2010 Q1 | 2010 Q2 | 2010 Q3 | 2010 Q4
5 | 10 | 2 | 3 | 6 | 8 | 12 | 14 | 3 | 5 | 2 | 9
Spreadsheet: 0d075884-7ddc-4130-a474-22ca7ff30064
Sheet: Sheet1

2012 Minnesota Test of Academic Skills (MTAS) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
2012 MTAS Grade 3
Grade 3 Reading |  |  |  | Grade 3 Mathematics
Raw Score | Scale Score* | Level |  | Raw Score | Scale Score** | Level
0 | 50 | D |  | 0 | 100 | D
1 | 78 | D |  | 1 | 119 | D
2 | 96 | D |  | 2 | 131 | D
3 | 108 | D |  | 3 | 139 | D
4 | 118 | D |  | 4 | 145 | D
5 | 128 | D |  | 5 | 152 | D
6 | 136 | D |  | 6 | 158 | D
7 | 146 | D |  | 7 | 164 | D
8 | 155 | D |  | 8 | 171 | D
9 | 163 | D |  | 9 | 177 | D
10 | 170 | D |  | 10 | 183 | D
11 | 176 | D |  | 11 | 190 | P
12 | 182 | D |  | 12 | 192 | P
13 | 186 | D |  | 13 | 195 | P
14 | 190 | P |  | 14 | 198 | P
15 | 194 | P |  | 15 | 200 | M
16 | 197 | P |  | 16 | 204 | M
17 | 200 | M |  | 17 | 206 | M
18 | 204 | M |  | 18 | 209 | M
19 | 207 | M |  | 19 | 211 | M
20 | 211 | M |  | 20 | 214 | M
21 | 215 | M |  | 21 | 217 | M
22 | 219 | M |  | 22 | 220 | E
23 | 222 | E |  | 23 | 224 | E
24 | 230 | E |  | 24 | 228 | E
25 | 238 | E |  | 25 | 234 | E
26 | 251 | E |  | 26 | 243 | E
27 | 275 | E |  | 27 | 260 | E
Notes:
*2007 and 2008/2009/2010/2011  MTAS scale metrics are not comparable
**2011/2012 and 2008/2009/2010  Grades 3-8 Mathematics MTAS scale metrics are not comparable
Spreadsheet: 791521d1660408683-to-count-consecutive-more-6-days-with-a-result-return-of-yes-or-no-abc-2-
Sheet: Sheet2

 |  | Name | Date |  | Name | Consecutive more 6 days (Y/N)
 |  | ANTHONY AMALAN | 2022-07-03 00:00:00 |  | ANTHONY AMALAN
 |  | ANTHONY AMALAN | 2022-07-04 00:00:00 |  | RAMASAMI SURESH
 |  | ANTHONY AMALAN | 2022-07-04 00:00:00
 |  | ANTHONY AMALAN | 2022-07-05 00:00:00
 |  | ANTHONY AMALAN | 2022-07-06 00:00:00
 |  | ANTHONY AMALAN | 2022-07-07 00:00:00
 |  | ANTHONY AMALAN | 2022-07-08 00:00:00
 |  | ANTHONY AMALAN | 2022-07-09 00:00:00
 |  | ANTHONY AMALAN | 2022-07-09 00:00:00
 |  | ANTHONY AMALAN | 2022-07-09 00:00:00
 |  | ANTHONY AMALAN | 2022-07-10 00:00:00
 |  | RAMASAMI SURESH | 2022-07-03 00:00:00
 |  | RAMASAMI SURESH | 2022-07-04 00:00:00
 |  | RAMASAMI SURESH | 2022-07-04 00:00:00
 |  | RAMASAMI SURESH | 2022-07-04 00:00:00
 |  | RAMASAMI SURESH | 2022-07-05 00:00:00
 |  | RAMASAMI SURESH | 2022-07-06 00:00:00
 |  | RAMASAMI SURESH | 2022-07-07 00:00:00
Spreadsheet: 48843d1248141653-pivot-table-of-subtotal-pivot-table-of-subtotal-929a
Sheet: Dry Pivot

 |  |  |  |  |  | Request
Site | GA1 |  |  |  |  | 1) Get a % of "Demand" by "family recipe" as shown below.   BUT, I want to show mulitple "Site"s, which
 |  |  |  |  |  | messes up my % field.  I am uncertain how to get column C this way with multiple "Site"s?  Make sense?
Sum of Demand
Family recipe | Family Rate | Total |  |  |  | 2) I want the pivot table to do the following calculation for me,
A | 6.3 | 0.03418803418803419 |  |  |  | 0.2153846153846154 |  | - If I use "calculated field" it will take the raw "Demand" number versus the % I want
B | 8.5 | 0.2606837606837607 |  |  |  | 2.215811965811966 |  | - I could do this in the database, but I am only showing a small portion of the database.
C | 10 | 0.7051282051282052 |  |  |  | 7.051282051282052 |  | It will be quite large and will be changing, so difficult to keep up w/ calculations in database
Grand Total |  | 1 |  |  |  | 9.482478632478633 |  | I am hoping the pivot table can do the work for me?
 |  |  |  |  |  | Request
 |  |  |  |  |  | 1) Here is where my % is not what I want.  I would want Row 27 and row 31 equal to 100%
 |  |  | Data |  |  | This is what I want the pivot table to do,
Site | Family recipe | Family Rate | Sum of Demand | Sum of Demand2 |  | "Sum of Demand2" |  |  | Average Output Rate
GA1 | A | 6.3 | 800 | 0.02622950819672131 |  | 0.03418803418803419 |  |  | 0.2153846153846154
 | B | 8.5 | 6100 | 0.2 |  | 0.2606837606837607 |  |  | 2.215811965811966
 | C | 10 | 16500 | 0.5409836065573771 |  | 0.7051282051282052 |  |  | 7.051282051282052
GA1 Total |  |  | 23400 | 0.7672131147540984 |  | 1 |  |  | 9.482478632478633
CA2 | A | 6.3 | 1000 | 0.03278688524590164 |  | 0.1408450704225352 |  |  | 0.8873239436619719
 | B | 8.5 | 2600 | 0.08524590163934426 |  | 0.3661971830985916 |  |  | 3.112676056338028
 | C | 10 | 3500 | 0.1147540983606557 |  | 0.4929577464788732 |  |  | 4.929577464788732
CA2 Total |  |  | 7100 | 0.2327868852459016 |  | 1 |  |  | 8.929577464788732
Grand Total |  |  | 30500 | 1
Spreadsheet: 110874d1307454608-help-with-advanced-filtering-data-formatting-sample1
Sheet: Sheet1

Jones | [NAME] | N |  | City: Charleston | State: South Carolina | Zip Code: 29201
Jones | [NAME] | K |  | City: Arlington | State: Texas | Zip Code: 29201
Smith | [NAME] | E |  | State: Virginia | Receiving aid: Yes | Anticpate receiving aid: Yes
Smythe | [NAME] | J |  | State: North Dakota | Receiving aid: Yes | Anticpate receiving aid: Yes
Spreadsheet: 755591d1636982199-matching-repetitive-numbers-that-are-in-sequential-order-ask-q-matching-nos-that-repeat
Sheet: Matching nos that repeat

 |  |  |  |  |  |  |  |  |  | Matching Numbers |  |  | Data Set |  |  |  | No. of matching nos in 1st sequence
 |  |  |  |  |  |  |  |  |  | 0 |  |  | 11 | 37 | 44 |  |  |  | Here we have formula to return the number of Matching numbers in sequential order appearing in the data set
 |  |  |  |  |  |  |  |  |  | 22 |  |  | 44 | 42 | 49 |  |  |  | In this example, there are four Matching numbers in sequential order (yellow highlighted), so the formular returns "4"
 |  |  |  |  |  |  |  |  |  | 44 |  |  | 45 | 69 | 131
 |  |  |  |  |  |  |  |  |  | 69 |  |  | 67 | 91 | 81
 |  |  |  |  |  |  |  |  |  | 81 |  |  | 69 | 93 | 154 |  | No. of matching nos in 2nd sequence
 |  |  |  |  |  |  |  |  |  | 93 |  |  | 124 | 157 | 167
 |  |  |  |  |  |  |  |  |  | 101 |  |  | 165 | 88 | 56 |  | 3 |  | Some Matching numbers appear more than once in the Data Set. i.e., they repeat themselves
 |  |  |  |  |  |  |  |  |  | 133 |  |  | 88 | 130 | 133 |  |  |  | In this example: 44,69,81  (green highlighted) are the repetitive Matching numbers in sequential order
 |  |  |  |  |  |  |  |  |  | 210 |  |  | 210 | 81 | 141 |  |  |  | We like a formula to return the number of repetitive Matching numbers that are in sequential order
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Can this be done?