tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 57347d1257446372-extracting-information-within-a-merged-combined-cell-poc-lookup
Sheet: Sheet1

System Name | Location | POC
a | b | Name
 |  | [NAME]
 |  | [NAME]
 |  | POC Subtotal: 2
b | a | Name
 |  | [NAME]
 |  | [NAME]
 |  | POC Subtotal: 2
c | d
d | c | Name
 |  | [NAME]
 |  | POC Subtotal: 1
Spreadsheet: 328832d1404110214-help-with-data-validation-and-list-with-formula-teachers-schedule
Sheet: Avaliability

Date | 2014-07-01 00:00:00 | 2014-07-02 00:00:00 | 2014-07-03 00:00:00 | 2014-07-04 00:00:00 | 2014-07-05 00:00:00 | 2014-07-06 00:00:00 | 2014-07-07 00:00:00 | 2014-07-08 00:00:00 | 2014-07-09 00:00:00 | 2014-07-10 00:00:00 | 2014-07-11 00:00:00 | 2014-07-12 00:00:00 | 2014-07-13 00:00:00 | 2014-07-14 00:00:00 | 2014-07-15 00:00:00 | 2014-07-16 00:00:00 | 2014-07-17 00:00:00 | 2014-07-18 00:00:00 | 2014-07-19 00:00:00 | 2014-07-20 00:00:00 | 2014-07-21 00:00:00 | 2014-07-22 00:00:00 | 2014-07-23 00:00:00 | 2014-07-24 00:00:00 | 2014-07-25 00:00:00 | 2014-07-26 00:00:00 | 2014-07-27 00:00:00 | 2014-07-28 00:00:00 | 2014-07-29 00:00:00 | 2014-07-30 00:00:00 | 2014-07-31 00:00:00 | 2014-08-01 00:00:00 | 2014-08-03 00:00:00
Day | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Sunday
[NAME]
Harley | Harley | Harley | Harley |  | Harley |  | Harley |  | Harley | Harley
Heloisa |  |  |  |  |  |  |  |  |  |  |  | Heloisa |  | Heloisa | Heloisa |  | Heloisa |  | Heloisa |  |  | Heloisa |  | Heloisa |  |  |  |  | Heloisa |  | Heloisa
Lidia | Lidia | Lidia | Lidia |  | Lidia |  | Lidia |  | Lidia | Lidia |  | Lidia |  | Lidia | Lidia | Lidia | Lidia |  | Lidia |  | Lidia | Lidia | Lidia | Lidia |  | Lidia |  | Lidia | Lidia | Lidia | Lidia
[NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] | [NAME] |  | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
Thais | Thais | Thais | Thais |  | Thais |  | Thais |  | Thais | Thais |  | Thais |  | Thais | Thais | Thais | Thais |  | Thais |  | Thais | Thais | Thais | Thais |  | Thais |  | Thais | Thais | Thais | Thais
Salete | Salete |  | Salete |  |  |  |  |  |  | Salete |  |  |  |  | Salete |  | Salete
[NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] | [NAME] |  | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME]
New 1
New2-Klaus
Spreadsheet: 141432d1329260068-creating-a-list-using-data-validation-can-i-create-a-subcategory-list-sonepar-technology-team-pos-and-invoices-2012
Sheet: Associates - Prepd Terms

ASSOCIATES |  | PRE-PAID TERMS |  | OpCo
[NAME] |  | 1yr - Software |  | Brook
[NAME] |  | 1 yr - Hardware |  | Capital Tristate
[NAME] |  | 2 yr - Software |  | Cooper Electric
[NAME] |  | 2 yr - Hardware |  | Crawford (CESCO)
[NAME] |  | 3 yr - Software |  | Eoff
[NAME] |  | 3 yr - Hardware |  | Essco
[NAME] |  | 4 yr - Software |  | Friedman Electric
[NAME] |  | 4 yr - Hardware |  | Hagemeyer USA
[NAME] |  | 5 yr - Software |  | Irby
Heather Kelly |  | 5 yr - Hardware |  | NorthEast Electric
[NAME] |  |  |  | Sonepar USA (Corporate)
[NAME] |  |  |  | Sonepar USA ([NAME])
[NAME] |  |  |  | Sonepar USA (Maitland)
[NAME] |  |  |  | Viking Electric
[NAME] |  |  |  | [NAME]
[NAME] |  |  |  | World Electric
[NAME]
[NAME] Thrune
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 274225d1383053979-calculate-kpi-penalty-kpi-penalty
Sheet: Sheet1

Service Cost | KPI | Actual | Panelty
1200 | 99.98 | 99.98
 |  | 99.97
 |  | 99.96
Spreadsheet: 145d192e-b3f6-4abc-8069-52f213d489ca
Sheet: Publishers

Publisher | Titles | Percentage
AmazonCrossing | 24
[NAME] | 19
Europa Editions | 10
Open Letter | 10
[NAME] | 10
FSG | 9
Penguin | 9
Archipelago | 8
New Directions | 8
Yale University Press | 7
[NAME] | 6
Houghton [NAME] | 6
Ugly Duckling | 6
[NAME] | 5
[NAME] | 5
Other Press | 5
Zephyr Press | 5
Bitter Lemon | 4
Melville House | 4
New York Review Books | 4
Pegasus | 4
And Other Stories | 3
Atria | 3
Biblioasis | 3
Black Cat | 3
Glas | 3
Grove | 3
K A Nitz | 3
Knopf | 3
Minotaur | 3
University of Chicago | 3
White Pine | 3
[NAME] | 2
Anvil Press | 2
BOA Editions | 2
Chelsea Editions | 2
Coach House Books | 2
Copper Canyon | 2
Crown | 2
DISQUIET | 2
[NAME] | 2
Indiana University Press | 2
Pantheon | 2
Random House | 2
Simon & Schuster | 2
Soho Press | 2
Stockholm Text | 2
Talonbooks | 2
Tavern Books | 2
Two Lines Press | 2
University of Nebraska | 2
University of Texas | 2
[NAME] | 2
American University at Cairo | 1
Aqueduct Press | 1
Arsenal Pulp Press | 1
Bellevue Literary Press | 1
Bitter Oleander Press | 1
Black Balloon | 1
Bloodaxe | 1
Burning Deck Press | 1
Calypso Editions | 1
Carnegie Mellon Press | 1
Chin Music Press | 1
Columbia University Press | 1
Counterpath Press | 1
[NAME] | 1
[NAME] and [NAME] | 1
Feminist Press | 1
Frisch & Co. | 1
[NAME] | 1
Graywolf | 1
HarperCollins | 1
Harvard University Press | 1
[NAME] | 1
House of Anansi | 1
Interlink | 1
Last Gasp | 1
Le French | 1
[NAME] | 1
[NAME] | 1
[NAME]'s Books | 1
New Vessel Press | 1
Northwestern University Press | 1
Otis Books | 1
Overlook | 1
Persea | 1
Picador | 1
Pleasure Boat Studio | 1
Process | 1
Quercus | 1
Santa Fe Writers Project | 1
[NAME] | 1
Serpent's Tail | 1
Seven Stories Press | 1
Small Beer | 1
St. Martin's | 1
Stork Press | 1
Strategic Book Publishing | 1
Syracuse University Press | 1
Telegram | 1
Tin House | 1
Tor | 1
University of Minnesota Press | 1
University of Oklahoma Press | 1
Verso | 1
Vertical | 1
Vintage | 1
W.W. Norton | 1
Wave Books | 1
Spreadsheet: 135694d1326189344-connections-or-import-source
Sheet: Sheet1

 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11
 | 1 | 34 | 87 | 45 | 3 | 1 | 5 | 8 | 10 | 24 | 36
 | ab | [NAME] | 34d | 6fs | fg56 | h678 | dr5 | 3da | fd | 43 | ddf
 | 5 | ef | 3 | 234 | 45f | gh | j | f | ds | sd4 | fd
 | gh | e | 4 | fg65 | fg | h | j | k | fg54 | 3 | 1
 | 89 | fgh | f | d | fd | 45h | gh4 | gh45 | 32 | 4 | 321
 | 876 |  | df98 | 45f | df45 | gh | hg98 | gh45 | 54 | 6 | 45
 | 45f | jh | v |  |  | asd | 456 |  | fd | gh | h
 | [NAME] | hj | bhj | 786 |  | fd5 | 1 | 4 | rfk | gh
 | 56 |  |  |  | ghj | k89g | 54f |  |  | dds
 | hj8 |  | d |  |  |  |  |  |  | df | df
 | 9kh |  | er | q | df6 | 35 |  | fdf | df | sd4
 | df4 |  |  | q | 456 |  | r |  | fd
 | fghj8 | dfs | df98 | fg65 | ew | 33 | df45 | fd | fd |  | df
 | 34g6 |  |  |  | d |  | ddf |  | c
 | 45fd | c | d |  | d |  | df | f | s
Spreadsheet: 666c404c-356a-4376-b290-418ac0630096
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Bransje:Regnskapstjenester
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Abaci AS | Grini Næringspark 1 | 1361 | Østerås | 67 14 10 30 | 67 14 32 33
[NAME] | Bogstadv. 30 | 0355 | Oslo | 22 20 04 00 | 22 20 04 10
[NAME] | Rådhusg. 23B | 0158 | Oslo | 22 47 76 70 | 22 42 09 52
[NAME] | Kongsv. 91 | 1177 | Oslo | 23 03 11 40 | 22 42 09 52
[NAME] AS | Rådyrv. 2A | 3370 | Vikersund | 32 78 86 03 | 32 78 89 40
Aurskog Regnskapskontor AS | [NAME] | 1930 | [NAME] | 63 85 38 50
Vardens Revisjonskontor AS | Skipperg. 33 | 0154 | Oslo | 24 14 12 00 | 22 42 67 72
Steen & Jensen Økonomi AS | [NAME] 59 | 3036 | Drammen | 32 88 90 10
Consis AS | [NAME]. 107 | 0663 | Oslo | 21 99 22 40
Pedersen & Skogholt | Idrettsv. 9 | 1400 | Ski | 64 85 15 00
Erøy Regnskap AS | Idrettsv. 9 | 1400 | Ski | 64 91 14 00 | 64 87 57 01
[NAME] | Ant H Mysens g 13 | 1850 | Mysen | 69 84 60 90 | 69 84 60 99
Hallingdal Økonomiservice AS | Elvevegen 4 | 3550 | Gol | 32 02 93 20 | 32 07 32 30
TomCon AS | [NAME]. 15 | 3117 | [NAME] | 33 00 48 80 | 33 31 02 77
Sjølyst Regnskap ANS | Drammensv. 126A | 0277 | Oslo | 22 55 59 78 | 22 55 66 96
Revisor Cirkelen Stokke AS | Storg. 1 | 3160 | Stokke | 33 33 65 40 | 33 33 64 04
[NAME] | Storg. 49 | 2870 | Dokka | 61 11 88 50 | 61 11 88 51
Økonor [NAME] (Skarpens Regnskapskontor AS) | Ringv. 26 | 2815 | Gjøvik | 61 14 63 30 | 61 14 63 31
Tune Regnskaps Consult AS | [NAME] g 52 | 1706 | Sarpsborg | 69 14 83 30 | 69 14 83 31
Olsen Thor Gudmund AS | Kjøstadv. 42 | 2340 | Løten | 62 59 04 40 | 62 59 19 16
Råd & Regnskap Oslo AS | Tullins g 6 | 0166 | Oslo | 22 98 21 31 | 22 98 21 21
Øko-Rom AS |  | 2013 | [NAME] | 63 84 41 50 | 63 84 54 80
Regnskapsbyrået AS | Øvre Storg. 37 | 3018 | Drammen | 32 21 35 70 | 32 21 35 71
[NAME] [NAME] | Malmøg. 7 | 0566 | Oslo | 22 35 60 20 | 22 35 50 40
Økonomitjenester Ørje AS | Storg. 57 | 1870 | Ørje | 69 81 22 45 | 69 81 18 95
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 1933e041-6c50-4b1b-bdc9-423325685289
Sheet: Sheet1

CCE PUBLIC OE TIER 2 COURSE COST WORKSHEET | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  |  |  | Updated for August 2012
(for internal use only)
 |  |  |  |  | *Input figures in blue shaded areas only
Course Name:
Course #:
Term Beginning:
Worksheet Prepared by:
Date Prepared: |  |  | 2013-02-08 00:00:00
Expenses/Costs |  |  |  |  |  | Notes: |  | Recommendations:
Course Development
1. Instructor Rate for Development (Labor, Prep) |  |  |  |  |  | Flat Fee (or P/Hour below) |  | (If applicable)
 | (*Either Flat Fee OR Per Hour, Not both) |  |  |  |  | Instructor Fee per Hour |  | (If applicable)
 |  |  |  |  |  | Development Hours |  | (If applicable)
 | TOTAL Development |  |  | 0
Instruction |  |  | Part Time Instructor
2a.  [NAME] |  |  |  | 0 |  | CCE Cost per Hour | 0 | *REQUIRED
 | (*modify formula in E22 if flat fee) |  |  |  |  | Contact Hours: | 0 | *REQUIRED
2b.  Instructor Benefits |  |  |  | 0 |  | Based on PT Instructor (7.65%)
 | TOTAL Instruction |  |  | 0
Equipment Fees
3a. Computer Lab Fees |  |  |  |  |  |  |  | (If applicable)
3b. Other Equipment Fees (installation, setup, etc) |  |  |  |  |  |  |  | (If applicable)
 | TOTAL Fees |  |  | 0
Cost of Material Goods
4a.  Instructor Packet and/or Materials |  |  |  |  |  |  |  | *REQUIRED
4b.  Certificates |  |  |  | 0 |  | Price PP |  | *REQUIRED
4c.  Book Cost |  |  |  | 0 |  | List Cost PP |  | *REQUIRED
4d.  Shipping & Handling (total) |  |  |  | 0 |  |  |  | *REQUIRED
4e. Tax |  |  |  | 0 |  | (NOTE: Delete formula in field if not used) |  | (If applicable)
4f.  Other Materials (CDs, guides, handouts, etc) |  |  |  |  |  |  |  | (If applicable)
[NAME] (if applicable) |  |  |  |  |  |  |  | (If applicable)
 | TOTAL Cost of Goods |  |  | 0
Marketing & Promotion
5. Marketing Costs |  |  | Printing | 0
 |  |  | Mail Prep | 0
 |  |  | Postage | 0
 |  |  | Advertising | 0
 |  |  | Other | 0
 | TOTAL Marketing |  |  | 0
 |  |  | Total Costs | 0
Potential FTE
 |  |  | Contact Hours | 0
 |  |  | Anticipated # Students | 10
 |  |  | Potential FTE | 0
Potential OE Funding Earned |  |  |  | 0
OE funding needed to reimburse expenses |  |  |  | 0
 | (includes percentage of admin expenses)
 |  |  | Total Surplus | 0
Spreadsheet: 155652d1337002236-excel-2007-simplify-multiple-vlookups-and-countifs-possible-example2
Sheet: Sheet2

Actor1 | 90 | John1
Actor2 | 11 | [NAME]
Actor3 | 25 | John3
Actor4 | 87 | John4
Actor5 | 34 | [NAME]
Actor6 | 38 | John6
Actor7 | 23 | [NAME]
Actor8 | 41 | John8
Actor9 | 42 | John9
Actor10 | 51 | [NAME]
Actor11 | 26 | John11
Actor12 | 88 | John12
Actor13 | 78 | [NAME]
Actor14 | 89 | [NAME]
Actor15 | 35 | John15
Actor16 | 15 | John16
Actor17 | 18 | John17
Actor18 | 10 | John18
Actor19 | 48 | John19
Actor20 | 36 | [NAME]
Actor21 | 20 | John21
Actor22 | 22 | John22
Actor23 | 53 | John23
Actor24 | 30 | [NAME]
Actor25 | 17 | [NAME]
Actor26 | 19 | [NAME]
Actor27 | 73 | [NAME]
Actor28 | 33 | [NAME]
Actor29 | 99 | John29
Actor30 | 29 | John30
Actor31 | 21 | [NAME]
Actor32 | 12 | John32
Actor33 | 40 | John33
Actor34 | 31 | John34
Actor35 | 81 | John35
Actor36 | 56 | John36
Actor37 | 43 | [NAME]
Actor38 | 54 | John38
Actor39 | 13 | [NAME]
Actor40 | 14 | [NAME]
Actor41 | 77 | John41
Actor42 | 45 | John42
Actor43 | 32 | John43
Actor44 | 16 | [NAME]
Actor45 | 28 | John45
Actor46 | 37 | John46
Actor47 | 27 | John47
Actor48 | 74 | [NAME]
Spreadsheet: 141069d1329069028-get-sheet-vlookup-function
Sheet: Users database

 | First Name | Last Name | Phone number | Postal address | email address | Date of birth
1 | Graig | [NAME] | 35698713 | 52 ballsbridge | [EMAIL] | 1985-06-14 00:00:00
2 | Sara | Mccook | 21651652 | 33 [NAME] | [EMAIL] | 1984-12-16 00:00:00
Spreadsheet: 60347d1260903387-sumif-multiple-criteria-excel-2003-sum-if-multiple-criterias
Sheet: Sheet1

Merchant | Date Paid | Project | Cost
acme | 2009-05-05 00:00:00 | Project A | 35.64
came | 2008-02-06 00:00:00 | Project B | 5
[NAME] | 2008-08-07 00:00:00 | Project C | 35.64
eacm | 2009-05-08 00:00:00 | Project A | 19.95
acem | 2009-05-09 00:00:00 | Project B | 15
acem | 2008-03-10 00:00:00 | Project D | 16
Total Cost of Project A |  | 55.59
Total Cost of Project B |  | 20
Total Cost of Project C |  | 35.64
Total Cost of Project D |  | 16
 |  | Desired Result
Total Cost of Project A for 2009 |  | 56
Total Cost of Project B for 2009 |  | 15
Total Cost of Project C for 2009 |  | 0
Total Cost of Project D for 2009 |  | 0
Spreadsheet: 765303d1643275644-find-result-in-data-table-by-multiple-conditions-cooling-power-ans
Sheet: Calculation form

 |  | Warehouse size | 25 | ㎡
 |  | Warehouse height | 2.2 | m
 |  | Panel thickness | 100 | [NAME]
 |  | Outside air temp. | 35 | ℃
 |  | Desirable Internal temp. | 5 | ℃
TODO | How to? -> | Required power |  | kw
Spreadsheet: 60592d1261093370-sorting-datasort
Sheet: Sheet1

I need to sort the fields so that the phone number attaches to the correct customer first last
CustomerId | FirstName | LastName |  | CustomerId | PhoneId |  | PhoneId | PhoneNumber
1001 |  |  |  | 1003 | 130598 |  | 1 | [PHONE]
1002 | bob | checking |  | 1004 | 118289 |  | 2 | [PHONE]
1003 | [NAME] | Cottle |  | 1005 | 1 |  | 3 | [PHONE]
1004 | Michael & Patty | Harrod |  | 1006 | 2 |  | 4 | [PHONE]
1005 | Hugh | Coley |  | 1006 | 3 |  | 5 | [PHONE]
1006 | [NAME] | Mitchell |  | 1008 | 4 |  | 6 | [PHONE]
1007 | [NAME] | Hulon |  | 1008 | 5 |  | 7 | [PHONE]
1008 | [NAME] | [NAME] |  | 1009 | 6 |  | 8 | [PHONE]
1009 | Scott | Mclain |  | 1010 | 7 |  | 9 | [PHONE]
1010 | [NAME] | Cannon |  | 1010 | 304 |  | 10 | [PHONE]
1011 | Marlow | [NAME] |  | 1011 | 8 |  | 11 | [PHONE]
1012 | Willie | Parker |  | 1012 | 9 |  | 12 | [PHONE]
1013 | [NAME] | Jennings |  | 1013 | 10 |  | 13 | [PHONE]
1014 | Colby | [NAME] |  | 1013 | 11 |  | 14 | [PHONE]
1015 | Melvin | Jones |  | 1014 | 71549 |  | 15 | [PHONE]
1016 | Marylinn & Michael | Shykes |  | 1016 | 357 |  | 16 | [PHONE]
Spreadsheet: 847037d1698142564-discounting-blank-in-a-countif-formula-test-3
Sheet: SAM

 |  | JOB NO | DATE RECEIVED | DATE COMPLETED | Job Type | Depot | CUSTOMER | DAY RECEIVED | DAY COMPLETED | DAYS | INVOICED DATE | TOTAL COST | TOTAL CHARGED | PROFIT | MARGIN
 |  | 75611 | 2023-05-23 00:00:00 | 2023-05-30 00:00:00 | Small Works | South West | CUSTOMER 1 | Tue | Tue | 6 | Jun-2023 | 735.09 | 1654.46 | 919.37 | 0.5556918873831945
 |  | 75714 | 2023-05-24 00:00:00 | 2023-05-30 00:00:00 | DDL - Quote | South | CUSTOMER 2 | Wed | Tue | 5 |  |  |  |  | 0
 |  | 75690 | 2023-05-24 00:00:00 | 2023-05-30 00:00:00 | Quote | South East | CUSTOMER 3 | Wed | Tue | 5 |  |  |  |  | 0
 |  | 75716 | 2023-05-24 00:00:00 | 2023-05-30 00:00:00 | Quote | South | CUSTOMER 4 | Wed | Tue | 5 |  |  |  |  | 0
 |  | 75755 | 2023-05-24 00:00:00 | 2023-05-30 00:00:00 | Supply Only | South | CUSTOMER 5 | Wed | Tue | 5 | Jun-2023 | 160.2 | 375.5 | 215.3 | 0.5733688415446072
 |  | 75820 | 2023-05-24 00:00:00 | 2023-05-30 00:00:00 | Small Works | South | CUSTOMER 6 | Wed | Tue | 5 | Jul-2023 | 435.5 | 1124.61 | 689.1099999999999 | 0.612754643832084
 |  | 74861 | 2023-05-15 00:00:00 | 2023-05-30 00:00:00 | Quote | South | CUSTOMER 7 | Mon | Tue | 12 |  |  |  |  | 0
 |  | 75825 | 2023-05-24 00:00:00 | 2023-05-30 00:00:00 | Small Works | South East | CUSTOMER 8 | Wed | Tue | 5 | Jul-2023 | 778.32 | 873.06 | 94.7399999999999 | 0.1085148787024946
 |  | 75909 | 2023-05-25 00:00:00 | 2023-05-30 00:00:00 | Small Works | South East | CUSTOMER 9 | Thu | Tue | 4 | Jul-2023 | 640 | 6340.03 | 5700.03 | 0.8990541054222141
 |  | 75869 | 2023-05-25 00:00:00 | 2023-05-30 00:00:00 | Small Works | South | CUSTOMER 10 | Thu | Tue | 4 | Jun-2023 | 152.6 | 482.91 | 330.3100000000001 | 0.683999088857137
 |  | 75879 | 2023-05-25 00:00:00 | 2023-05-30 00:00:00 | Small Works | South East | CUSTOMER 11 | Thu | Tue | 4 | Jun-2023 | 333.43 | 967.81 | 634.3799999999999 | 0.6554798979138466
 |  | 75872 | 2023-05-25 00:00:00 | 2023-05-30 00:00:00 | Small Works | South | CUSTOMER 12 | Thu | Tue | 4 | Jul-2023 | 80.58 | 368.88 | 288.3 | 0.781554977228367
Spreadsheet: 745071d1629726750-apurar-valores-count-of-maximum-number-of-overlaps-trindade97-
Sheet: Folha1

Data | Viatura | [NAME] | [NAME] |  | Viatura A | Viatura B | Viatura C | Viaura D | Viatura E |  | [NAME]
2021-08-01 00:00:00 | Viatura A | 10:00:00 | 10:20:00
2021-08-01 00:00:00 | Viatura B | 10:05:00 | 10:45:00
2021-08-01 00:00:00 | Viatura C | 10:10:00 | 10:45:00
2021-08-01 00:00:00 | Viatura A | 10:30:00 | 11:00:00
2021-08-01 00:00:00 | Viaura D | 10:35:00 | 11:25:00
2021-08-01 00:00:00 | Viatura E | 10:45:00 | 13:00:00
2021-08-01 00:00:00 | Viatura B | 11:00:00 | 11:30:00
2021-08-01 00:00:00 | Viatura C | 12:00:00 | 14:00:00
2021-08-01 00:00:00 | Viatura A | 12:30:00 | 14:00:00
2021-08-01 00:00:00 | Viatura D | 13:00:00 | 13:10:00
2021-08-01 00:00:00 | Viatura E | 13:30:00 | 15:00:00
2021-08-01 00:00:00 | Viatura A | 15:00:00 | 18:00:00
2021-08-01 00:00:00 | Viatura B | 15:50:00 | 16:00:00
2021-08-01 00:00:00 | Viatura C | 17:00:00 | 17:15:00
2021-08-01 00:00:00 | Viatura D | 17:30:00 | 18:00:00
Spreadsheet: 727607d1617979991-validate-values-within-a-string-based-on-a-reference-string-data-validation-string
Sheet: Sheet1

Article ID | Available Sizes | Selected Sizes | Validation (manual)
WR2639 | [XXS][XS][S][M][L][XL][XXL][3XL][4XL] | [XS][S][M][L][XL] | VALID
EY2567 | [3][3-][4][4-][5][4-][6][6-][7][7-][8][8-][9][9-][10][10-][11][11-][12][12-][13][13-][14][14-][15][16][17] | [3][3-][4][4-][5][5-][6][6-][7][7-][8][9] | VALID
AD7968 | [XXS][XS][S][M][L][XL][XXL][3XL][4XL] | [3][3-][4][4-][5][5-][6][6-][7][7-][8][9] | INVALID
PU3496 | [3][4][5][6][7][8][9][10][11][12][13][14][15][16][17] | [3][3-][4][4-][5][5-][6][6-][7][7-][8][9] | INVALID
GH1265 | [XXS][XS][S][M][L][XL][XXL] | [S][M][L] | VALID
FR8563 | [S][M][L] | [XS][S][M][L][XL] | INVALID
GH2147 | [3][3-][4][4-][5][4-][6][6-][7][7-][8][8-][9][9-][10][10-][11][11-][12][12-][13][13-][14][14-][15][16][17] | [XS][S][M][L][XL] | INVALID
WR9636 | [XXS][XS][S][M][L][XL][XXL] | [3][3-][4][4-][5][5-][6][6-][7][7-][8][9] | INVALID
Example with fixed lengths:
Article ID | Available Sizes | Selected Sizes | Validation (formula)
KM4555 | [3][4][5][6][7][8][9] | [3][4][5][6][7]
LF4988 | [3][4][5][6][7][8][9] | [1][2][3][4][5]
DG8859 | [3][4][5][6][7][8][9] | [3][4][5]
KL4950 | [3][4][5][6][7][8][9] | [1][2][3][4][5]
Spreadsheet: 546383d1510018761-multiple-budget-files-summary-budget-test
Sheet: Budget C

Budget C
Line Item | Amount | Budget Code 1 | Budget Code 2 | Budget Code 3
Line Item 1 | 500 | 250 | 100 | 150
Line Item 2 | 1000 |  | 1000
Line Item 3 | 750 | 250 |  | 500
Total
Spreadsheet: 36685d1234546059-pivoting-text-morespeed
Sheet: Result

 | XRef1 | XRef2 | XRef3 | XRef4 | XRef5 | XRef6 | XRef7 | XRef8 | XRef9 | XRef10 | XRef11 | XRef12 | XRef13 | [NAME] | XRef15 | XRef16 | XRef17 | XRef18 | XRef19
Part1 | CompPart1, [NAME]
Part2
Part3 |  |  | CompPart3
Part4 |  |  |  | [NAME]
Part5 |  |  |  |  | CompPart5
Part6 |  |  |  |  |  | [NAME]
Part7 |  |  |  |  |  |  | CompPart7
Part8 |  |  |  |  |  |  |  | CompPart8
Part9 |  |  |  |  |  |  |  |  | CompPart9
Part10 |  |  |  |  |  |  |  |  |  | CompPart10
Part11 |  |  |  |  |  |  |  |  |  |  | CompPart11
Part12 |  |  |  |  |  |  |  |  |  |  |  | CompPart12
Part13 |  |  |  |  |  |  |  |  |  |  |  |  | CompPart13
Part14 |  |  |  |  |  |  |  |  |  |  |  |  |  | CompPart14
Part15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CompPart15
Part16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CompPart16
Part17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CompPart17
Part18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CompPart18
Part19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CompPart19
Spreadsheet: 150172d1334321773-exceed-7-max-logic-statements-cant-work-out-fix-exampleifs
Sheet: Sheet1

 |  |  |  |  |  | [NAME] |  |  |  |  |  |  | Lookup table
 |  |  |  |  | % | 4 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
 |  | List for Drop down |  | A | 0.04 |  |  |  |  |  | A | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04
 |  | 1 |  | B | 0.06 |  |  |  |  |  | B | 0.08 | 0.08 | 0.06 | 0.06 | 0.06 | 6.41
 |  | 2 |  | C | 0.34 |  |  |  |  |  | C | 0.08 | 0.34 | 0.34 | 0.34 | 0.34 | 0.55
 |  | 3 |  | D | 0.06 |  |  |  |  |  | D | 0.48 | 0.04 | 0.06 | 0.06 | 0.06 | 0.31
 |  | 4 |  | E | 0.04 |  |  |  |  |  | E | 0.04 | 0.48 | 0.04 | 0.04 | 0.04 | 0.21
 |  | 5 |  | F | 0.04 |  |  |  |  |  | F | 0.04 | 6.86 | 0.04 | 0.04 | 0.04 | 0.21
 |  | 6 |  | G | 2.43 |  |  |  |  |  | G | 0.04 | 2.43 | 2.43 | 2.43 | 0.01 | 2.43
 |  |  |  | H | 2.11 |  |  |  |  |  | H | 0.48 | 0.04 | 0.04 | 2.11 | 0.04 | 0.04
 |  |  |  | I | 0.34 |  |  |  |  |  | I | 0.34 | 6.84 | 0.34 | 0.34 | 0.34 | 0.34
 |  |  |  | J | 5.46 |  |  |  |  |  | J | 0.06 | 0.05 | 0.04 | 5.46 | 0.06 | 0.06
 |  |  |  | K | 9.84 |  |  |  |  |  | K | 0.04 | 0.04 | 0.04 | 9.84 | 0.04 | 0.04
 |  |  |  | L | 6.54 |  |  |  |  |  | L | 0.04 | 0.04 | 0.04 | 6.54 | 0.04 | 0.04
 |  |  |  | M | 0.04 |  |  |  |  |  | M | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04
 |  |  |  | N | 0.06 |  |  |  |  |  | N | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06
 |  |  |  | O | 0.06 |  |  |  |  |  | O | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06
 |  |  |  | P | 0.04 |  |  |  |  |  | P | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04
 |  |  |  | Q | 0.04 |  |  |  |  |  | Q | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04
 |  |  |  | R | 0.06 |  |  |  |  |  | R | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06
 |  |  |  | S | 0.03 |  |  |  |  |  | S | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03
Spreadsheet: 197005d1354184982-keeping-the-first-and-last-rows-of-every-unique-value-00__fotis_10sample
Sheet: Sheet1

Code | Date | Weight |  | weight result | Days difference | gr-increase
AAAA051000 | 2006-06-15 00:00:00 | 143 | 1
AAAA051000 | 2006-08-23 00:00:00 | 205
AAAA051000 | 2006-10-04 00:00:00 | 239
AAAA051000 | 2006-12-11 00:00:00 | 319
AAAA051000 | 2007-02-21 00:00:00 | 370
AAAA051000 | 2007-04-24 00:00:00 | 416
AAAA0516 | 2006-06-15 00:00:00 | 219
AAAA0516 | 2006-08-23 00:00:00 | 289
AAAA0516 | 2006-10-04 00:00:00 | 323
AAAA0516 | 2006-12-11 00:00:00 | 396
AAAA0521 | 2006-06-15 00:00:00 | 221
AAAA0521 | 2006-08-23 00:00:00 | 302
AAAA0521 | 2006-10-04 00:00:00 | 335
AAAA0521 | 2006-12-11 00:00:00 | 422
AAAA0521 | 2007-02-21 00:00:00 | 488
AAAA05323 | 2006-06-15 00:00:00 | 155
AAAA05323 | 2006-08-23 00:00:00 | 218
AAAA05359 | 2006-06-15 00:00:00 | 153
AAAA05359 | 2006-08-23 00:00:00 | 220
AAAA05359 | 2006-10-04 00:00:00 | 263
AAAA05359 | 2006-12-11 00:00:00 | 339
AAAA05359 | 2007-02-21 00:00:00 | 411
[NAME] | 2012-05-08 00:00:00 | 230
[NAME] | 2012-06-11 00:00:00 | 235
[NAME] | 2012-07-24 00:00:00 | 255