tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 863163d1710761566-create-dynamic-list-based-on-blank-cells-list-based-on-blank-cells-etaf
Sheet: Sheet1

 | 74540084 | Daveon | Collazo | Warehouse Section Leader | [EMAIL] | Federico, [NAME] | Warehouse | Foods | Site 4 | Grade 13 | 44847 |  |  | 0 | GDPR Enhanced | Training and Assessment complete | Active | [NAME] | 0 |  |  | 0 | 0 | 45382 | 1
Brock Shanahan | 74537721 | Brock | Shanahan | Customer Service Coordinator | [EMAIL] | Keagan, Hood | [NAME] | Primary | Site 2 | Grade 13 | 44508 |  |  | Completed | GDPR Enhanced | 0 | Active | [NAME] | 0 |  |  | 45107 | 0 | 0 | 2
[NAME] | 74504103 | Ramsey | Driscoll | [NAME] | [EMAIL] | Cailin, Bachman | Warehouse | Foods | Site 8 | Non banded | 37928 |  |  | 0 | GDPR Basic | Training and Assessment complete | Active | Bachman [NAME] | 0 |  |  | 0 | 0 | 45322 | 1
[NAME] | 74540636 | [NAME] | Winkler | Service & Operations Manager | [EMAIL] | [NAME], [NAME] | Foods central | Head Office Functions | Site 10 | Grade 17 | 44990 |  |  | 0 | GDPR Enhanced | 0 | Active | [NAME] | 0 |  |  | 0 | 0 | 0 | 3
Daquan Foote | 74508553 | Daquan | Foote | Modelling Lead | [EMAIL] | Brandon, Halstead | Solutions | Head Office Functions | Site 3 | [NAME] | 41155 |  | Transport | Completed | GDPR Enhanced | 0 | Active | [NAME] | 0 |  |  | 45230 | 0 | 0 | 2
Spreadsheet: 823117d1679718638-lookup-multiple-values-from-a-table-cmms
Sheet: Drill Drop Downs

 | TblEquipCat
 | [NAME]
 | Light Vehicle
 | [NAME]
 | [NAME]
 | Water Truck
 | TblServiceSizes
 | 250
 | 500
 | 750
 | 1000
 | 1250
 | 1500
 | 1750
 | 2000
 | TblComponentLife
 | Carousel
 | Compressor
 | [NAME]
 | Engine
 | [NAME]
 | Final Drive - CS
 | Final Drive - OCS
 | Final Drive Motor - CS
 | Final Drive Motor - OCS
 | Func Box
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Pump - Auxillary
 | Pump - Charge
 | Pump - Feed
 | Pump - Rotation
 | Ropes - Hoist
 | Ropes - Pulldown
 | Rotary Head
 | [NAME]
 | [NAME]
 | TblDrillNumbers
Spreadsheet: 876684d1723406681-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.10.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-10 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 6 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 27 | 0 | 4 | 1 | 1 | 0 | 1 | 2 | 0
 | 5TH FL | 34 | 20 | 19 | 0 | 3 | 1 | 1 | 0 | 1 | 2 | 0
 | ABC | 27 | 18 | 20 | 0 | 5 | 0 | 1 | 1 | 1 | 2 | 0
 | MNO | 12 | 6 | 6 | 0 | 3 | 0 | 0 | 1 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 5 | 0 | 0 | 1 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-10 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 24 | 0 | 4 | 1 | 0 | 0 | 1 | 2 | 0
 | 5TH FL | 34 | 20 | 19 | 0 | 4 | 2 | 1 | 0 | 0 | 1 | 0
 | ABC | 27 | 18 | 21 | 0 | 5 | 0 | 2 | 0 | 0 | 1 | 0
 | MNO | 12 | 6 | 6 | 0 | 4 | 0 | 1 | 1 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 3 | 0 | 1 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 1 | 0 | 5 | 3 | 0 | 0 | 0 | 1 | 0
 | Total House Census
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Joe Benning

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
I'd like to explain my position
Explain your fair share position, if you choose.
As a general rule I believe agency fees are equivalent to a closed shop.  That concept runs contrary to my view of what Vermont
is all about. I take issue with the claim that non-union employees are "standing in the way."  There is another side to that
discussion. One of the drawbacks to being a non-union teacher is that you are limited to whatever benefits/salary the union bargains
for.  There are teachers I know who put in far more time than most, who have a proven record of good class scores, that would much
prefer to be paid based on merit.  They cannot be paid based on merit because they are forced to accept the contract the union has
negotiated.  I think it is insulting to accuse those who choose not to join the union, for whatever reason, of
standing in the way of anything.  Leading off your position with that statement only tends to polarize and alienate, making those of
us searching for a compromise very uncomfortable..
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
I'd like to explain my position
Explain your health care reform position, if you choose
I agree with the first concept that employees should be insulated as much as possible from potential economic loss.  The second
contention, regarding continuing ability to negotiate health care benefits, runs counter to the current administration's push for "universal"
health care.  Although I did not support that push, in order for it to be done in a way that saves the money projected by Dr. [NAME], every
Vermonter will have to be part of the insurance pool.  Carving out exceptions for segments of Vermonters will only threaten the integrity
of that system and lead to different forms of coverage for different people.  So if the state chooses to go in a "universal" direction, I don't
see how providing negotiating rights to employees will fit within that system.  (Again, I did not vote for this system, but it appears that is
the direction we are heading in.  If that does NOT happen, then I would agree with this second contention as well.)
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
I'd like to explain my position
Explain your relicensing position, if you choose
As a licensed professional myself, I'd like to know what changes you are proposing before I decide whether to support them or not.
Conceptually I am generally in favor of simplifying any process that is duplicative or needlessly cumbersome.
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | [NAME] 142, Lyndonville, VT 05851 | State Senate, Caledonia District | Yes |  | Caledonia
Spreadsheet: 787898d1658144797-help-separate-text-cell-of-terms-into-pairs-pairs-sample
Sheet: Sheet1

apple,orange,banana,coconut,dragon fruit,papaya
 | apple,banana | orange,banana | apple,coconut | orange,coconut | banana,coconut | apple,dragon fruit | orange,dragon fruit | banana,dragon fruit | coconut,dragon fruit | apple,papaya | orange,papaya | banana,papaya | coconut,papaya | dragon fruit,papaya
 | apple,banana | apple,coconut | apple,dragon fruit | apple,papaya | orange,banana | orange,coconut | orange,dragon fruit | orange,papaya | banana,coconut | banana,dragon fruit | banana,papaya | coconut,dragon fruit | coconut,papaya | dragon fruit,papaya
Spreadsheet: 142321d1329773033-need-to-identify-if-values-are-formatted-as-tax-ein-ssn-or-not-idendtify-tid
Sheet: Sheet1

Vendor | Tax Number | Type Of Business | SSN/EIN/Needs Corrected
3000000 | 12-3456789 | Corporation | EIN
3000001 | 23-4567891 | Partnership | EIN
3000002 | 345-67-8912 | Individual | SSN
3000003 | bunk |  | [NAME]
3000004 | 456-78-9123 | Bunk | SSN
Spreadsheet: 792318d1660838166-sumifs-and-lookup-function-resulted-to-null-value-sampleproblemsumifsandlookup-hd
Sheet: Data 1

Posting Date | Assignment | G/L Account | Document Number | Document type | Segment | Profit Center | Cost Center | Amount in local currency
2021-01-04 00:00:00 | 1000001417 | 21200101 | 1500000551 | KZ | CBGD | 2039-000 |  | 10204222.23
2021-01-04 00:00:00 | 1000001417 | 21200101 | 1500000552 | KZ | CBGD | 2039-000 |  | 5644233.2
2021-01-04 00:00:00 | 1000001417 | 21200101 | 1500000553 | KZ | CBGD | 2039-000 |  | 3397125.43
2021-01-04 00:00:00 | 1000001417 | 21200101 | 1500000554 | KZ | CBGD | 2039-000 |  | 2218822.07
2021-01-04 00:00:00 | 1700000100 | 21200101 | 2000040584 | ZP | OHLD | 1963-000 |  | 10047.51
2021-01-04 00:00:00 | 1700000100 | 21200101 | 2000040585 | ZP | OHLD | 1963-000 |  | 21668.4
2021-01-05 00:00:00 | EM00009109 | 21300502 | 2000040586 | ZP | HOFC | HOFC-000 |  | 15000
2021-01-05 00:00:00 | EM09008320 | 21300502 | 2000040587 | ZP | HOFC | HOFC-000 |  | 32691
2021-01-05 00:00:00 | EM09017409 | 21300502 | 2000040588 | ZP | HOFC | HOFC-000 |  | 960
2021-01-05 00:00:00 | EM09017417 | 21300502 | 2000040589 | ZP | HOFC | HOFC-000 |  | 50000
2021-01-05 00:00:00 | EM00003217 | 21300502 | 2000040590 | ZP | HOFC | HOFC-000 |  | 17291.55
2021-01-05 00:00:00 | EM00003217 | 21300502 | 2000040590 | ZP | IPD | 2063-000 |  | 8428
2021-01-05 00:00:00 | EM00009109 | 21300502 | 2000040591 | ZP | HOFC | HOFC-000 |  | 29093.03
2021-01-05 00:00:00 | EM09003978 | 21300502 | 2000040592 | ZP | IPD | 2111-000 |  | 3961.64
2021-01-05 00:00:00 | EM09003978 | 21300502 | 2000040592 | ZP | HOFC | HOFC-000 |  | 15060
2021-01-05 00:00:00 | 1000000943 | 21200101 | 2000040593 | ZP | HOFC | 1997-000 |  | 13979.23
2021-01-05 00:00:00 | 1000000943 | 21200101 | 2000040593 | ZP | IPD | 2053-000 |  | 5715.77
2021-01-05 00:00:00 | 1000000943 | 21200101 | 2000040593 | ZP | HOFC | HOFC-000 |  | 53855.94
Spreadsheet: 777931d1650678859-merging-list-information-from-multiple-sheets-that-may-have-added-rows-full-outer-merge-using-power-query-hacohen15-
Sheet: Q2

 |  |  |  | YTD |  | YTD |  |  |  |  | Name | Hire Date | [NAME] to 6/30/2022 | [NAME] to 3/31/2022 | [NAME]
 |  | Hire |  | Info to |  | Info to |  | Quarterly |  |  | Abbott, [NAME] | 1995-12-02 00:00:00 | 8000
NAME |  | Date |  | 2022-06-30 00:00:00 |  | 2022-03-31 00:00:00 |  | [NAME] |  |  | [NAME], [NAME] | 2020-08-10 00:00:00 | 5000
(these are made up names and info |  |  |  |  |  |  |  |  |  |  | Baybott, [NAME] | 2022-05-05 00:00:00 | 1500
 |  |  |  |  |  |  |  |  |  |  | Cabott, Fred | 2007-08-01 00:00:00 | 6000
Abbott, [NAME] |  | 1995-12-02 00:00:00 |  | 8000 |  |  |  |  |  |  | Dabott, [NAME] | 2002-05-15 00:00:00 | 10000
[NAME], [NAME] |  | 2020-08-10 00:00:00 |  | 5000
Baybott, [NAME] |  | 2022-05-05 00:00:00 |  | 1500
Cabott, Fred |  | 2007-08-01 00:00:00 |  | 6000
Dabott, [NAME] |  | 2002-05-15 00:00:00 |  | 10000
Spreadsheet: 357006d1415278385-need-help-for-people-planner-demo1
Sheet: Sheet1

Operations Staff |  |  |  |  |  |  |  |  | Future Projects | 2
 | Name | Position | Project End | Manager | Available |  |  |  | Project Name | Start Date | Staff needs | Name | Position | Date Avalible | If Available
PM's | [NAME] | PM | 2014-11-06 00:00:00 | [NAME] | Project A |  |  |  | Project D | 2014-11-09 00:00:00 | PM
 | [NAME] | PM | 2014-11-07 00:00:00 | [NAME] | Project B |  |  |  |  |  | FOC
 | [NAME] | PM | 2014-11-08 00:00:00 | [NAME] | Project B |  |  |  |  |  | PE
 | [NAME] | PM | 2014-11-09 00:00:00 | [NAME] | Project A
 | [NAME] | PM | 2014-11-10 00:00:00 | [NAME] | Project A
FOC's | [NAME] | FOC | 2014-11-11 00:00:00 | [NAME] | Project B
 | [NAME] | FOC | 2014-11-12 00:00:00 | [NAME] | Project A
 | [NAME] | FOC | 2014-11-13 00:00:00 | [NAME] | Project B
 | [NAME] | FOC | 2014-11-14 00:00:00 | [NAME] | Project B
PE's | [NAME] | PE | 2014-11-15 00:00:00 | [NAME] | Project A
 | [NAME] | PE | 2014-11-16 00:00:00 | [NAME] | Project B
 | [NAME] | PE | 2014-11-17 00:00:00 | [NAME] | Project A
 | [NAME] | PE | 2014-11-18 00:00:00 | [NAME] | Project A
 | Noah Gilbert | PE | 2014-11-19 00:00:00 | [NAME] | Project B
Spreadsheet: 117305d1312652491-statiscal-information-count-students
Sheet: Sheet1

sex | over 12 | under 12 | 1 | 2 | 3 | total
f | 0 | 1 | 1 | 0 | 1 |  |  |  | females
f | 1 | 0 | 1 | 1 | 0 |  |  |  | males
m | 1 | 0 | 1 | 0 | 2
f | 1 | 0 | 2 | 1 | 0
m | 0 | 1 | 0 | 2 | 2
f | 1 | 0 | 1 | 0 | 2
m | 1 | 0 | 2 | 0 | 1
f | 0 | 1 | 1 | 2 | 2
m | 1 | 0 | 0 | 0 | 1
f | 1 | 0 | 0 | 2 | 0
f | 0 | 1 | 1 | 1 | 2
m | 1 | 0 | 0 | 0 | 0
f | 1 | 0 | 1 | 2 | 0
m | 1 | 0 | 0 | 1 | 2
m | 0 | 1 | 1 | 0 | 0
f | 1 | 0 | 2 | 1 | 1
f | 0 | 1 | 2 | 2 | 0
m | 0 | 1 | 2 | 2 | 0
f | 1 | 0 | 0 | 1 | 0
m | 1 | 0 | 2 | 2 | 0
f | 1 | 0 | 1 | 0 | 2
m | 1 | 0 | 0 | 2 | 1
m | 1 | 0 | 2 | 2 | 2
f | 0 | 1 | 2 | 2 | 2
f | 0 | 1 | 1 | 1 | 2
m | 1 | 0 | 0 | 0 | 1
f | 0 | 1 | 1 | 0 | 1
f | 0 | 1 | 1 | 1 | 1
m | 0 | 1 | 1 | 1 | 1
f | 1 | 0 | 0 | 1 | 2
f | 1 | 0 | 0 | 0 | 0
f | 0 | 1 | 0 | 0 | 1
m | 0 | 1 | 0 | 1 | 2
m | 0 | 1 | 0 | 2 | 2
f | 1 | 0 | 2 | 0 | 0
m | 1 | 0 | 0 | 1 | 1
m | 0 | 1 | 2 | 2 | 0
m | 0 | 1 | 1 | 2 | 1
m | 1 | 0 | 2 | 0 | 2
m | 0 | 1 | 0 | 2 | 2
m | 0 | 1 | 2 | 1 | 0
m | 1 | 0 | 2 | 2 | 0
f | 0 | 1 | 0 | 1 | 0
m | 0 | 1 | 2 | 0 | 2
f | 1 | 0 | 0 | 2 | 2
m | 0 | 1 | 2 | 1 | 0
m | 1 | 0 | 1 | 0 | 0
f | 1 | 0 | 2 | 0 | 2
m | 1 | 0 | 2 | 2 | 2
f | 0 | 1 | 0 | 0 | 2
m | 1 | 0 | 2 | 1 | 1
m | 1 | 0 | 1 | 2 | 2
m | 1 | 0 | 0 | 0 | 2
f | 0 | 1 | 2 | 0 | 1
f | 1 | 0 | 0 | 0 | 2
m | 1 | 0 | 1 | 0 | 0
f | 0 | 1 | 0 | 0 | 1
f | 0 | 1 | 2 | 1 | 1
f | 0 | 1 | 0 | 1 | 0
f | 1 | 0 | 0 | 0 | 2
m | 1 | 0 | 0 | 1 | 1
m | 0 | 1 | 0 | 1 | 1
f | 0 | 1 | 1 | 0 | 1
f | 1 | 0 | 1 | 1 | 2
f | 1 | 0 | 0 | 1 | 2
m | 1 | 0 | 2 | 0 | 0
m | 0 | 1 | 2 | 1 | 2
m | 1 | 0 | 2 | 2 | 2
m | 0 | 1 | 0 | 0 | 2
m | 1 | 0 | 0 | 0 | 2
m | 1 | 0 | 0 | 0 | 2
m | 1 | 0 | 1 | 2 | 2
m | 0 | 1 | 2 | 0 | 0
m | 1 | 0 | 0 | 1 | 0
f | 1 | 0 | 1 | 0 | 0
Spreadsheet: 279494d1385135113-calculate-headcount-by-department-based-on-hire-date-and-termination-date-sample-headcount
Sheet: Sheet1

Employee Name | Hire Date | Termination Date | Department |  |  |  | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00
afaf | 2012-02-01 00:00:00 |  | sales |  |  | sales
sgsg | 2012-04-01 00:00:00 | 2013-03-30 00:00:00 | production |  |  | production
gv | 2012-06-12 00:00:00 |  | sales |  |  | administrative
rgrhg | 2012-08-01 00:00:00 | 2013-07-31 00:00:00 | administrative |  |  | finance
bfuebv | 2013-10-25 00:00:00 |  | finance
rgs | 2012-12-03 00:00:00 |  | production
byj | 2013-02-01 00:00:00 | 2013-10-01 00:00:00 | production
kyhye | 2013-04-14 00:00:00 |  | sales
agvb | 2013-10-01 00:00:00 |  | finance
Spreadsheet: 677884d1589565681-start-login-hour-of-agent-report-alexxl-
Sheet: Help

 | [NAME]
BUCATARU.MADALINA1
CEAPA.BIANCA1
FARCAS.ALINA1
GROSU.IONUT1
GROZDEA.MIHAELA1
IACOB.GEORGIANA1
LUCA.MANUEL1
LUNGU.IULIAN1
[NAME]
MOIZE.ROBERT1
OPREA.ANDREEA1
PUSCUTA.BOGDANN1
SANDU.ADRIAN1
[NAME]
Spreadsheet: hunter_shively__12668__Nov_01 Volume Changes
Sheet: Nov 10-12

Pipeline | Producer | Deal | Zone | Current Volume | New Volume | Change | Index | GDA | Fixed
ANR | Ralaco | 969536 | Gath | 2840 | 2330 |  | -120 | -390
ANR | Panaco | 1135527 | Off | 1099 | 917 |  |  | -182
CGLF | Forest | 1109818 | [NAME] | 2256 | 576 |  | -1680
[NAME] | Forest | 1131239 | Zone 2 | 280 | 235 |  |  | -45
NGPL | KCS | 1143959 | Midcon | 2348 | 2649 |  |  | 301
SNAT | Stone | 1054822 | Uncnstrnd WH | 4032 | 4332 |  | 300
STRY | MMS | 1103008 | RCPTS | 66342 | 64892 |  |  | -1450
TENN | Shoreline | 1129078 | Zone 0 | 761 | 385 |  |  | -376
TENN | Pioneer | 1135749 | Zone 500 | 1731 | 1223 |  |  | -508
TENN | Cabot | 1138914 | Zone 500 | 16000 | 14800 |  | -1200
TENN | Torch | 1059789 | Zone 800 | 809 | 660 |  |  | -149
TENN | Westport | 1143232 | Zone 800 | 8000 | 10000 |  |  | 2000
TENN | [NAME] | 1132292 | Zone 800 | 11000 | 10000 |  |  | -1000
TGT | Unimark | 1146397 | ELA | 4267 | 1570 |  |  | -2697
TRCO | Torch | 1059003 | Zone 2 | 11 | 2 |  |  | -9
TRCO | Torch | 1085947 | Zone 2 | 62 | 500 |  |  | 438
TRCO | Torch | 1059107 | Zone 2 | 536 | 863 |  |  | 327
TRCO | Tristar | 1139955 | Zone 3 | 848 | 728 |  |  | -120
TRKL | Torch | 1058639 | ELA | 137 | 104 |  |  | -33
TRKL | Forest | 1109804 | ELA | 22250 | 21075 |  |  | -1175
TRKl | Forest | 1127986 | ELA | 2300 | 2500 |  |  | 200
 |  |  |  |  |  | Daily Total
 |  |  |  |  |  | MTD Total | -20772 | 5052 | 282
Spreadsheet: 99963d1298476114-count-on-multiple-criteria-within-spcified-range-excel-2003-book1
Sheet: Sheet1

Start Period | 2010-01-01 00:00:00
End Period | 2010-05-10 00:00:00
Name (not important) | type | Mono# | Date Complete
1 | a | 25 | 2010-12-13 00:00:00
2 | b | 26 | 2010-12-09 00:00:00
3 | a | 27 | 2010-12-14 00:00:00
4 | b | 28 | 2010-12-11 00:00:00
5 | a | 29 | 2010-12-15 00:00:00
6 | b | 30 | 2010-12-13 00:00:00
7 | a | 31 | 2011-01-03 00:00:00
8 | b | 32 | 2010-12-14 00:00:00
9 | a | 33 | 2011-01-03 00:00:00
10 | b | 34 | 2010-12-15 00:00:00
11 | a | 35 | 2011-01-04 00:00:00
12 | b | 36 | 2010-12-16 00:00:00
13 | a | 37 | 2011-01-07 00:00:00
14 | b | 38 | 2011-01-03 00:00:00
15 | a | 39 | 2011-01-07 00:00:00
 | #
Range 25-31 A |  |  | [NAME] needed
Range 25-31 B
Range 31-39 A
Range 31-39 B
Spreadsheet: 800727d1665832753-if-certain-word-then-sum-in-specific-cells-book1
Sheet: Sheet1 (3)

AGENCY | AMMOUNT | PAID
airbnb | 4452 | paid
KOLENIA | 540 | Paid
KOLENIA | 202.5 | pending
KOLENIA | 351 | Paid
SUNHOTELS | 1183.84 | pending
Sunhotels | 1275.96 | pending
 | Pending | Paid
Kolenia
Airbnb
Hotelbeds
Travelhands
Sunhotels
Spreadsheet: 148396d1333386915-creating-a-report-to-show-vehicle-tax-due-tax-disc-log
Sheet: MF51 LLR

 |  |  |  |  | MF51 LLR
Registration number : | MF51 LLR |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | DAF |  | 2007-06-29 00:00:00 | 12 Months | 2008-07-01 00:00:00 | 165 | Private HGV
Specification : | 4 x 2 RV |  | 2008-06-30 00:00:00 | 12 Months | 2009-07-01 00:00:00 | 165
Type : | FACF65.250 |  | 2009-06-30 00:00:00 | 12 Months | 2010-07-01 00:00:00 | 165
1st Registered : | 14.01.02 |  | 2010-06-30 00:00:00 | 12 Months | 2011-07-01 00:00:00 | 165
Engine : | DAF 5.9 litre (250 BHP) |  | 2011-06-30 00:00:00 | 12 Months | 2012-07-01 00:00:00 | 165
[NAME] : | 17,000kg
Back To Index
Spreadsheet: 58973d1259273121-use-drop-menu-to-control-data-708779-use-drop-menu-to-control-data
Sheet: Audit Board

 |  |  |  | Update Period |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sihn & Date |  |  | Status
 |  |  |  | Bi-Annually |  |  | PERIOD1 |  |  |  |  |  |  |  | PERIOD 2
 |  |  |  | Quaterly |  |  | Q1 |  |  |  | Q2 |  |  |  | Q3 |  |  | Q4
 |  |  |  | Monthly |  |  | Month 1 |  |  | Month 2 |  |  | Month 3 |  |  | Month 4 |  |  | Month 5
 |  |  |  | Monthly |  |  | Month 1 |  |  | Month 2 |  |  | Month 3 |  |  | Month 4 |  |  | Month 5
 |  |  |  | Weekly |  |  | Week 1 |  |  | Week 2 |  |  | Week 3 |  |  | Week 4 |  |  | Week 5
 |  |  |  | Daily |  |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday
 |  |  |  |  |  | ""=AND(COUNTA(INDIRECT("'PSE'!$k$11:$k$19"))< 9, COUNTA(INDIRECT("'PSE'!$k$11:$k$19"))>= 1)""
Spreadsheet: 225108d1364899826-i-want-to-change-datetime-format-in-excel-calls_demo
Sheet: Calls_demo

date_entered | date_modified | date_start | date_end
2012-12-12 00:00:00 | 16-01-2013 14:41 | 2012-12-12 05:30:00 | 1970-01-01 00:00:00
2012-12-12 00:00:00 | 16-01-2013 14:42 | 2012-12-12 05:30:00 | 1970-01-01 00:00:00
2012-12-12 00:00:00 | 16-01-2013 14:43 | 2012-12-12 05:30:00 | 1970-01-01 00:00:00
2012-12-12 00:00:00 | 16-01-2013 14:44 | 2012-12-12 05:30:00 | 1970-01-01 00:00:00
23-01-2013  12:08:00 PM | 28-02-2013 16:28 | 23-01-2013 12:15 | 23-01-2013
Spreadsheet: 745026d1629690413-group-by-using-filter-array-and-then-join-columnn-and-rows-hansolu-pq-and-formula-filter-group-by
Sheet: Sheet1

RAW DATA |  |  |  |  | [NAME] | 1 |  |  | PQ Result
Date | Machine | Scrap | Reason |  |  |  |  |  | Date | Machine | Sum | ScrapTextCombined
2021-08-22 00:00:00 | A | 20 | mix |  |  |  |  |  | 2021-08-21 00:00:00 | A | 73 | [NAME], full=5
2021-08-22 00:00:00 | A | 3 | test |  |  |  |  |  | 2021-08-21 00:00:00 | B | 60 | [NAME], full=26
2021-08-22 00:00:00 | A | 5 | full |  |  |  |  |  | 2021-08-22 00:00:00 | A | 28 | mix=20, full=5, test=3
2021-08-22 00:00:00 | B | 1 | mix |  |  |  |  |  | 2021-08-22 00:00:00 | B | 6 | full=5
2021-08-22 00:00:00 | B | 5 | full
2021-08-21 00:00:00 | A | 12 | mix
2021-08-21 00:00:00 | A | 55 | test |  |  |  |  |  | Date | Machine
2021-08-21 00:00:00 | B | 21 | full |  |  |  |  |  | 2021-08-21 00:00:00 | B
2021-08-21 00:00:00 | B | 22 | mix
2021-08-21 00:00:00 | A | 5 | full
2021-08-21 00:00:00 | A | 1 | mix
2021-08-21 00:00:00 | B | 5 | full |  |  |  |  | That my filterd list, I need to group them somehow | Filtered list, using the scrap  limit and only showing the 2 columns I need to join
2021-08-21 00:00:00 | B | 12 | mix |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  | full | 21
 |  |  |  |  |  |  |  |  | mix | 12
 |  |  |  |  |  |  |  |  | full | 5
 |  |  |  |  |  |  |  | That my result so far, using LET to make it easier to read
 |  |  |  |  |  |  |  | That’s what I need (from PQ) but I cant get it with formulas | [NAME], full=26
 |  |  |  |  |  |  |  | That’s how my filtered table should look like, then I can use textjoin,.. To create my list
 |  |  |  |  |  |  |  | mix | 34
 |  |  |  |  |  |  |  | full | 26
Spreadsheet: 692025d1598020249-should-i-use-a-vlookup-or-if-formula-commission-calculator-
Sheet: Sheet1

COMMISSION CALCULATOR
Weekly discoveries per 1 sales rep
 | Total Discoveries |  |  |  | Total Commission
 | 18
 | From | To | Commission per discovery
 | 10 | 15 | 10
 | 16 | 25 | 12
 | 26 | 50 | 15
When a number is entered into cell [NAME], I need the result to be automatically calculated in cell F6 using the data within the yellow grid.
So if the total number of discoveries is 18, the total commission is £216.00 (18 x £12.00)
Spreadsheet: 188680d1350962515-calendar-creation-from-dates-on-various-worksheets-excelforum-help
Sheet: Adam

Options | Range 1 |  | Range 2 |  | Range 3 |  | Range 4 |  | Single Date
False
False
True
False
False