tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 79344d1279633245-numerical-date-and-time-ontime
Sheet: Sheet1

 | Allowance (min) | 15
2468144 | 2010-01-04 00:00:00 | 06:00:00 | 2010-01-04 00:00:00 | 06:14:00 | 00:14:00 | On Time
2468164 | 2010-01-04 00:00:00 | 06:00:00 | 2010-01-04 00:00:00 | 09:40:00 | 03:40:00 | Late
2427813 | 2010-01-04 00:00:00 | 07:00:00 | 2010-01-04 00:00:00 | 07:00:00 | 1900-01-01 00:00:00 | On Time
2443952 | 2010-01-04 00:00:00 | 07:00:00 | 2010-01-04 00:00:00 | 06:45:00 | 00:15:00 | On Time
2451442 | 2010-01-04 00:00:00 | 07:00:00 | 2010-01-04 00:00:00 | 09:08:00 | 02:08:00 | Late
2451530 | 2010-01-04 00:00:00 | 07:00:00 | 2010-01-04 00:00:00 | 07:00:00 | 1900-01-01 00:00:00 | On Time
2455964 | 2010-01-04 00:00:00 | 07:00:00 | 2010-01-04 00:00:00 | 07:24:00 | 00:24:00 | Late
Spreadsheet: 871765d1718188509-march-fishing-xls-hpe-needed-sac-league
Sheet: 3

Name | lbs | oz | Oz (total) | Points
 | 96 | 2
 | 46 | 10
 | 34 | 2
 | 0 | 0
 | 57 | 7
 | 77 | 2
 | 60 | 7
 | 0 | 0
 | 14 | 1
 | 45 | 6
 | 88 | 9
 | 77 | 3
 | 22 | 7
 | 51
Spreadsheet: 741870d1627392020-find-column-of-last-valid-number-in-a-row-help
Sheet: Sheet1

 | Ref
weight | A12 | A13 | A14 | A15 | A16 | A17 | A18
100 | 4.6 | 4.5 | 4.3 | 4.1 | 3.9 | 3.7 | 3.5
200 | 4.3 | 4.2 | 4.1 | 3.8 | 3.6 | 3.5 | 3.6
300 | 4.1 | 4 | 3.9 | 3.7 | 3.5 | 3.3
400 | 3.9 | 3.8 | 3.7 | 3.5 | 3.2
500 | 3.7 | 3.6 | 3.5 | 3.3 | 3.1
600 | 3.6 | 3.5 | 3.4 | 3.2
700 | 3.5 | 3.4 | 3.3
800 | 3.4 | 3.5
problem:
what is "Ref" for the last value at weight "600"
Answer is "A15"
for "200"  it would be "A18"
Spreadsheet: 677139d1589210928-populate-calendar-and-summary-invercargill-leave-copy
Sheet: PivotLeaveCalendar

Location | [NAME]
Month | All
Year | 2020
Sum of Hours |  | Employee
Date (Month) | Date | Name1 | [NAME] | Name3 | Name4 | Name5 | Name6 | Name7
Jan
Feb
Mar
Apr
May |  | 30 | 40 | 36
Jun |  | 10 |  |  | 30 | 44 | 30 | 32
Jul
Aug
Sep
Oct
Nov
Dec
Grand Total |  | 40 | 40 | 36 | 30 | 44 | 30 | 32
Spreadsheet: mary_fischer__25749__CalPERS-OTP Transaction
Sheet: Note2

EES, LLC
Warrant Monetization
Per Unit Value Allocation
Common Stock |  | 2226.52
Special Warrant |  | 591.16
Investor Warrant |  | 0
 |  |  | Special Warrants
Warrants and Common Stock Issued to EES and Outside Investors |  |  | Number
EES's interest in EMW after additional issuance |  |  | 225000
EMW Shares sold to outside investors |  |  | 75000
Value of EMW Warrants before Buyout=225,000 *$591.16
Less:  warrants distributed for Buyout =14,329 *591.16
Net (Income)/Loss Before Tax
Permanent Adjustments |  |  | 0
Temporary Adjustments
FAS 125 Monetization of Warrants
Taxable (Income)/Loss
Current Tax Expense/(Benefit)
Deferred Tax Expense/(Benefit)
Total Tax Expense
Spreadsheet: 9fd3dd05-a3c3-4b06-b886-fcdbc92f0782
Sheet: 1.5

Cuadro 1.5
[NAME]
Nacimientos ocurridos, por sexo, según [NAME], 2010
[NAME] | Total | Sexo
 |  | Hombre | Mujer
Total país
Distrito Nacional |  | 14839 | 14426
Azua |  | 1815 | 1696
Baoruco |  | 573 | 539
Barahona |  | 1598 | 1563
Dajabón |  | 238 | 216
Duarte |  | 2114 | 1970
[NAME] |  | 189 | 217
El Seibo |  | 346 | 333
Espaillat |  | 1216 | 1123
[NAME] |  | 239 | 216
[NAME] |  | 1564 | 1507
[NAME] |  | 1653 | 1552
[NAME] |  | 2312 | 2268
María [NAME] |  | 855 | 789
Monte Cristi |  | 373 | 354
Pedernales |  | 85 | 93
Peravia |  | 970 | 968
Puerto Plata |  | 1502 | 1373
[NAME] |  | 573 | 563
Samaná |  | 571 | 524
San Cristóbal |  | 3401 | 2996
San Juan |  | 1426 | 1323
[NAME] |  | 2147 | 2092
[NAME] |  | 940 | 860
Santiago |  | 7413 | 7031
Santiago Rodríguez |  | 460 | 448
[NAME] |  | 833 | 888
[NAME] |  | 1053 | 1104
[NAME] |  | 527 | 488
Hato Mayor |  | 239 | 228
[NAME] |  | 251 | 236
Santo [NAME] |  | 9651 | 9199
No Especificado |  | 9 | 1
Nota: Elaborado con datos registrados en las Oficialías del Estado Civil. Junta Central Electoral.
Fuente: Oficina Nacional de Estadística, (ONE).
Spreadsheet: 38117d1236242767-how-to-count-the-sums-of-repetitive-cells-and-then-remove-the-duplicates-pivottable-example
Sheet: Sheet1

Articles | Qty |  |  | Sum of Qty
3RD125070442H | 10 |  |  | Articles | Total
3RD125070442H | 10 |  |  | 3RD125070442H | 30
3RD125070442H | 10 |  |  | 3RE071870493H | 4
3RE071870493H | 4 |  |  | 3RI100009624T | 15
3RI100009624T | 12 |  |  | 3RKB0624484WH | 16
3RI100009624T | 3 |  |  | 3S1250030J42H | 12
3RKB0624484WH | 8 |  |  | Grand Total | 77
3RKB0624484WH | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 505 | 100
3S1250030J42H | 12
Spreadsheet: 45482d1244213110-rearranging-data-and-putting-into-a-league-style-table-ramtech
Sheet: League

CHH | # of Alarm incidents | Total # of Alerts
175 | 1 | 1
168 | 5 | 24
182 | 1 | 1
129 | 2 | 6
114 | 1 | 12
128 | 1 | 1
207 | 2 | 5
MOBILE 1 | 1 | 1
190 | 3 | 25
209 | 1 | 10
233 | 2 | 2
083 | 1 | 1
161 | 2 | 2
233 | 2 | 2
082 | 1 | 1
239 | 1 | 1
214 | 2 | 2
138 | 1 | 2
MOBILE 2 | 4 | 22
102 | 2 | 2
220 | 3 | 18
154 | 1 | 1
161 | 2 | 2
187 | 1 | 2
084 | 1 | 2
074 | 1 | 1
171 | 1 | 1
220 | 3 | 18
211 | 1 | 4
204 | 1 | 18
085 | 1 | 3
219 | 1 | 1
107 | 1 | 2
102 | 2 | 2
129 | 2 | 6
Spreadsheet: 02c5f0e3-48a3-48d0-9027-7f1ee76b3c94
Sheet: Chart Data $

 | FY 2001 | FY 2002 | FY 2003 | FY 2004 | FY 2005 | FY 2006 | FY 2007 | FY 2008 | FY 2009 | FY 2003 | FY 2009
General Appropriations | 260462406 | 284424252 | 259752769 | 265294531 | 272448581 | 279528229 | 296920896 | 314296445
Federal Grants & Contracts | 165310852 | 166085229 | 178913318 | 202523068 | 228699250 | 235123059 | 233666485.53 | 248253778
Student Fees | 63037365 | 66938853 | 82205720 | 97183448 | 108825988 | 119816276 | 125411912 | 127109732
Sales & Serv of Aux Ent | 41532762 | 52722258 | 77991479 | 80666240 | 89412979 | 95170625 | 94717922 | 100955358
Other Student Fees | 41998721 | 46463382 | 49115959 | 51933422 | 52006853 | 49669497 | 60248455 | 53727411
Sales & Serv of Educ Act | 58761565 | 63640344 | 42815556 | 41214167 | 40369744 | 41522693 | 41496881 | 53922434
Private Gifts, Grts & Contr | 30551190 | 35898977 | 35616693 | 31506726 | 35258587 | 41039617 | 42875927.64 | 43797552
State Grants & Contracts | 16419445 | 18775001 | 18708628 | 27032818 | 33309177 | 26981445 | 28005012.71 | 29078797
Indirect Costs | 7232824 | 8697766 | 8751975 | 12821860 | 14806379 | 14866709 | 16807325 | 17022432
Other | 11536532 | 10342031 | 10749057 | 10864130 | 11187283 | 9270699 | 20173732 | 18696177
Endowment Funds | 13011300 | 15906700 | 13635900 | 11964700 | 10020500 | 9519600 | 7624800 | 7851500
Federal Approp | 4594600 | 4594600 | 4599500 | 4599500 | 4599500 | 4599500 | 4599500 | 4782000
One-time Funds |  |  |  |  |  | 5605383 | 4912300 | 3927600
Total Revenue
Instruction | 211664903 | 235376162 | 240661809 | 249655901 | 260771739 | 266669177 | 287421565.53 | 295923196
Scholarships & Fellowships | 141681428 | 138472486 | 142553439 | 152827088 | 164407479 | 170763376 | 163651500 | 169710847
Auxiliary Enterprises | 84674266 | 101038914 | 104131051 | 114611377 | 124022367 | 124290665 | 123868963.69 | 135638947
Research | 74587722 | 83439636 | 83451720 | 98250969 | 116516484 | 121991399 | 120728803.12 | 129378452
Institutional Support | 53666156 | 57631458 | 56483517 | 60013218 | 61335256 | 69124860 | 79086293 | 82296849
Physical Plant |  |  |  | 43035888 | 46553292 | 49227111 | 66870061 | 65154483
Academic Support | 39761895 | 42003868 | 41083229 | 43926747 | 45847818 | 38362697 | 40169689 | 45332876
Public Service | 25956234 | 27280224 | 28038546 | 31177083 | 34587177 | 36561461 | 40459200.23 | 47059968
Student Services | 23161858 | 24874419 | 24114179 | 24655340 | 25932656 | 28582295 | 29736732 | 32972253
Libraries | 17541720 | 18601380 | 17968834 | 18428901 | 19466184 | 20092873 | 20792704 | 21454773
One-time Expenditures |  |  |  |  |  | 6336879 | 5323400 | 4363300
Total Uses
Spreadsheet: 0780fbf6-4f13-4b6d-988d-932b43f206e1
Sheet: Supplies and Materials (600)

Part II Budget Detail
Amounts paid for items of an expendable nature that are consumed, worn out, or deteriorated in use; or items that lose their identity through fabrication or
incorporation into different or more complex units or substances are considered supply expenditures.  Amounts paid for non-equipment items and with
reasonable care and use may be expected to last for more than one year, are considered material expenditures.  Includes computer programs (software).
Supplies and Materials (600)
Description | Project Year 1 | Project Year 2 | Project Year 3 | Total
Spreadsheet: 491623d1480565817-getting-cells-to-show-the-formulas-behind-their-values-eimas-example
Sheet: Sheet1

 |  |  |  |  |  |  |  | 15011152.33436307
 |  |  |  |  | 574875
 |  |  |  |  | 574875
 |  |  |  |  | 574875
 |  |  |  |  | 574875
 |  |  |  |  | 574875
 |  |  |  |  | 574875
 |  |  |  |  | 574875
 |  |  |  |  | 574875
 |  |  |  |  | 574875
 |  |  |  |  | 574875
Spreadsheet: 818637d1676982095-how-to-set-up-expiry-date-expiry-date-test
Sheet: Sheet1

 | LP. | Name | Training 1 | Valid to | Training 2 | Valid to2 | Training 3 | Valid to3 | Training 4 | Valid to4 |  | Closest training center
 |  |  | 2022-02-27 00:00:00 |  | 2023-02-24 00:00:00 |  | 2023-02-22 00:00:00 |  | 2023-02-24 00:00:00
 |  |  | 2023-02-27 00:00:00 |  | 2023-02-27 00:00:00 |  | 2023-02-27 00:00:00 |  | 2023-02-27 00:00:00
 |  |  | 2023-03-03 00:00:00 |  | 2023-03-03 00:00:00 |  | 2023-03-03 00:00:00 |  | 2023-03-03 00:00:00
 |  |  | 2023-03-03 00:00:00 |  | 2023-03-03 00:00:00 |  | 2023-03-03 00:00:00 |  | 2023-03-03 00:00:00
 |  |  | 2023-03-03 00:00:00 |  | 2023-03-03 00:00:00 |  | 2023-03-03 00:00:00 |  | 2023-03-03 00:00:00
 |  |  | 2023-03-03 00:00:00 |  | 2023-03-03 00:00:00 |  | 2023-03-03 00:00:00 |  | 2023-03-03 00:00:00
 |  |  | 2023-03-11 00:00:00 |  | 2023-03-09 00:00:00 |  | 2023-03-12 00:00:00 |  | 2023-03-09 00:00:00
 |  |  | 2023-03-20 00:00:00 |  | 2023-03-20 00:00:00 |  | 2023-03-20 00:00:00 |  | 2023-03-20 00:00:00
 |  |  | 2023-03-20 00:00:00 |  | 2023-03-20 00:00:00 |  | 2023-03-20 00:00:00 |  | 2023-03-20 00:00:00
 |  |  | 2023-03-30 00:00:00 |  | 2023-03-30 00:00:00 |  | 2023-03-30 00:00:00 |  | 2023-03-30 00:00:00
 |  |  | 2023-04-07 00:00:00 |  | 2023-04-07 00:00:00 |  | 2023-04-07 00:00:00 |  | 2023-04-07 00:00:00
 |  |  | 2023-04-10 00:00:00 |  | 2023-04-10 00:00:00 |  | 2023-04-10 00:00:00 |  | 2023-04-10 00:00:00
 |  |  | 2023-04-17 00:00:00 |  | 2023-04-13 00:00:00 |  | 2023-04-15 00:00:00 |  | 2023-04-13 00:00:00
 |  |  | 2022-02-27 00:00:00 |  | 2023-04-16 00:00:00 |  | 2023-04-17 00:00:00 |  | 2023-04-17 00:00:00
 |  |  | 2023-04-21 00:00:00 |  | 2023-04-21 00:00:00 |  | 2023-04-21 00:00:00 |  | 2023-04-21 00:00:00
 |  |  | 2023-04-27 00:00:00 |  | 2023-04-27 00:00:00 |  | 2023-04-27 00:00:00 |  | 2023-04-27 00:00:00
 |  |  | 2023-05-08 00:00:00 |  | 2023-05-08 00:00:00 |  | 2023-05-08 00:00:00 |  | 2023-05-08 00:00:00
 |  |  | 2023-05-08 00:00:00 |  | 2023-05-08 00:00:00 |  | 2023-05-08 00:00:00 |  | 2023-05-08 00:00:00
Spreadsheet: 488753d1478804517-template-to-calculate-monthly-reduction-by-fixed-percentage-cost
Sheet: Sheet1

MONTH | COST | REDUCTION | BALANCE
Jan | 100
Feb |  | 8.333333333333334
Mar |  | 8.333333333333334
Apr |  | 8.333333333333334
May |  | 8.333333333333334
Jun |  | 8.333333333333334
Jul |  | 8.333333333333334
Aug |  | 8.333333333333334
Sep |  | 8.333333333333334
Oct |  | 8.333333333333334
Nov |  | 8.333333333333334
Dec |  | 8.333333333333334
Spreadsheet: 466090d1466003519-formula-to-stop-count-hours-once-it-reaches-maximum-paid-time-off-work-sheet
Sheet: Sheet1

Hire Date | Years of Service | Annual Accrual Days | Annual Accrual Hours | Accrual Per Hour | Maximum Accrual | Accrual Per Bi-Weekly PP | Hours Accrual | Hours Used | Available Hours |  |  |  |  |  |  |  |  |  | Years of Service | annual Accrual Days | annual Accrual Hours | Accrual Per Hour | Maximum Accrual | accrual Per  Bi-Weekly PP
2008-02-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 10 | 80 |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 12 | 96 |  | 96 |  |  | PTO-A
 |  |  |  | CODE |  | COUNT |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 15 | 120 |  | 120 |  |  | PTO-E
 |  |  |  | PTO-A | =Accrual |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 20 | 160 |  | 160 |  |  | PTO-U
 |  |  |  | PTO-E | =Early Out |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 25 | 200 |  | 200
 |  |  |  | PTO-U | =Used
Date | Hours | Accrual | Early Out | Used | Code | Balance | Notes
 | Beginning Balance |  |  |  |  | 113.24
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 |  |  | 2 |  | PTO-E
 |  |  | 2 |  | PTO-E
 |  |  | 1 |  | PTO-E
 |  |  |  | 40 | PTO-U
 |  |  |  | 40 | PTO-U
 |  |  |  | 8 | PTO-U
 |  |  |  | 8 | PTO-U
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 | 80 |  |  |  | PTO-A
 |  |  |  | 40 | PTO-U
 |  |  |  | 40 | PTO-U
Spreadsheet: 08c24110-aa86-47ff-bc5e-4fb6f4da0394
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Business, Management and Administration: Administrative and Information Support
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Administrative and Information Support Pathway of the Business, Management and Administration Career Cluster) can serve as a guide, along with other career planning materials, as learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study, used for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for              Administrative and Information Support Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | ►Administrative Assistant ►Communications Equipment Operator ►Computer Operator ►Court Reporter ►Customer Service Assistant ►Data Entry Specialist ►Desktop Publisher ►Dispatcher ►Executive Assistant ►Information Assistant ►Legal Secretary ►Library Assistant and Order                       .   Processor ►Medical Front Office Assistant ►Medical Transcriptionist ►Office Manager ►Paralegal ►Receptionist ►Records Processing Assistant ►Shipping and [NAME] ►Stenographer ►Typist ►Word Processor
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 477914d1472568688-tough-problem-how-can-i-average-different-columns-based-on-student-names-monthly-mastery-tracker_example
Sheet: NHM Data

September |  |  |  | October |  |  |  | November |  |  |  | December |  |  |  | January |  |  |  | February |  |  |  | March |  |  |  | April |  |  |  | May |  |  |  | June
Name | OSIS # | NHM |  | Name | OSIS # | NHM |  | Name | OSIS # | NHM |  | Name | OSIS # | NHM |  | Name | OSIS # | NHM |  | Name | OSIS # | NHM |  | Name | OSIS # | NHM |  | Name | OSIS # | NHM |  | Name | OSIS # | NHM |  | Name | OSIS # | NHM
Student x | 1 | 4 |  | Student x | 1 | 7 |  | Student x | 1 | 3 |  | Student x | 1 | 0 |  | Student x | 1 | 11 |  | Student x | 1 | 4 |  | Student x | 1 | 2 |  | Student x | 1 | 33 |  | Student x | 1 | 1 |  | Student x | 1 | 8
Student y | 2 | 5 |  | Student y | 2 | 4 |  | Student y | 2 | 8 |  | Student y | 2 | 0 |  | Student y | 2 | 2 |  | Student y | 2 | 5 |  | Student y | 2 | 87 |  | Student y | 2 | 35 |  | Student y | 2 | 3 |  | Student y | 2 | 9
Student z | 3 | 6 |  | Student z | 3 | 2 |  | Student z | 3 | 9 |  | Student z | 3 | 1 |  | Student z | 3 | 45 |  | Student z | 3 | 6 |  | Student z | 3 | 5 |  | Student z | 3 | 64 |  | Student z | 3 | 2 |  | Student z | 3 | 3
Spreadsheet: 868240d1714986460-how-to-calculate-an-automatic-payrise-every-x-months-after-a-variable-employee-start-date-excel-forum-sample-data
Sheet: Sheet1

 | Raise rate | 0.1
 | Months raise applies after starting month, and then every, how many months? | 8
 | Months | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48
 | Employee 1 |  |  | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000
 | Employee 2 |  |  |  | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000
 | Employee 3 |  |  |  |  |  | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000
 | Employee 4 |  |  |  |  |  |  | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000
 | Employee 5 |  |  |  |  |  |  |  |  | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000
 | Employee 6 |  |  |  |  |  |  |  |  |  |  | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500 | 5500
Spreadsheet: 680038d1590757672-count-number-of-rows-where-the-month-is-the-same-in-col-a-and-the-integer-in-col-c-is-0-callregister
Sheet: CallRegister

[NAME]
Date of the call | GAVA rep on duty | Duration /min/ | Type of the call | Gender | Age group | Product | Cust. ID | Issue/question raised by Customer | Respons given by Rep
2020-05-04 00:00:00 | Gerencsér Gábor | 0 | No-call day
2020-05-05 00:00:00 | Gerencsér Gábor | 15 | Product feedback | male | under 30 | Folder
2020-05-06 00:00:00 | [NAME] | 10 | Product feedback | male | under 30 | Electric
2020-05-07 00:00:00 | [NAME] | 5 | Warranty issue | male | 30-50 | Electric
2020-05-08 00:00:00 | [NAME] | 5 | Warranty issue | male | over 50 | Electric
2020-05-11 00:00:00 | Gerencsér Gábor | 5 | Technical question | male | under 30 | Electric
2020-05-11 00:00:00 | Gerencsér Gábor | 10 | Appointment req. | female | 30-50 | Folder
2020-05-11 00:00:00 | Gerencsér Gábor | 10 | Appointment req. | female | 30-51 | Folder
2020-05-13 00:00:00 | [NAME] | 0 | No-call day
2020-05-14 00:00:00 | [NAME] | 5 | Promotion | female | 30-53 | Cross/trekking
2020-05-15 00:00:00 | [NAME] | 2 | Other | male | under 30 | Cross/trekking
2020-05-15 00:00:00 | [NAME] | 10 | Sales feedback | male | under 30 | MTB
2020-05-18 00:00:00 | Gerencsér Gábor | 0 | No-call day
2020-05-18 00:00:00 | Gerencsér Gábor | 15 | Product feedback | male | under 30 | Folder
2020-05-19 00:00:00 | [NAME] | 10 | Product feedback | male | under 30 | Electric
2020-05-19 00:00:00 | [NAME] | 5 | Warranty issue | male | 30-50 | Electric
2020-05-20 00:00:00 | [NAME] | 5 | Warranty issue | male | over 50 | Electric
2020-05-21 00:00:00 | Gerencsér Gábor | 5 | Technical question | male | under 30 | Electric
2020-05-21 00:00:00 | Gerencsér Gábor | 10 | Appointment req. | female | 30-50 | Folder
2020-05-21 00:00:00 | Gerencsér Gábor | 10 | Appointment req. | female | 30-51 | Folder
2020-05-22 00:00:00 | [NAME] | 0 | No-call day
2020-05-22 00:00:00 | [NAME] | 5 | Promotion | female | 30-53 | Cross/trekking
2020-05-25 00:00:00 | [NAME] | 2 | Other | male | under 30 | Cross/trekking
2020-05-25 00:00:00 | [NAME] | 10 | Sales feedback | male | under 30 | MTB
 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 89001d1288798551-controling-pivot-filters-from-another-page-pvt-control-test
Sheet: Report

 |  |  |  |  | Indoor Sports |  | 1
 |  |  |  |  | Action/Extreme Sports
Department | Date |  |  |  | Camp/Travel
Indoor Sports |  |  |  |  | Games
PID | Desc | Revenue |  |  | Team Sports
Spreadsheet: 840289d1692624782-returning-a-value-from-a-table-chart-1-aligw
Sheet: Lists

 | Minimum number of twin sockets per room
Room Types | Up to 12m^2 | 12-25m^2 | over 25m^2
NA
Main Living Room | 4 | 6 | 8
Dining Room | 3 | 4 | 5
[NAME] | 2 | 3 | 4
Double Bedroom | 3 | 4 | 5
Bedsitting Room | 4 | 5 | 6
Study | 4 | 5 | 6
Utility Room | 3 | 4 | 5
Kitchen | 6 | 8 | 10
Garages | 2 | 3 | 4
Conservatory | 3 | 4 | 5
Hallway and Landings | 1 | 2 | 3
[NAME] | 1 | 2 | 3
Location Containing a Shower
Electric vehicle charging
Cloke Room | 0 | 0 | 0
in the cell below want to get a number from the table based on the room type and size eg input kitchen and over 25m^2, to return the value in cell D11 eg 10
Kitchen
over 25m^2