tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 852589d1702572272-how-to-sumif-with-dynamic-variable-number-of-criteria-ranges-excel-example
Sheet: FollowUp

 |  |  |  |  |  | Master [NAME] |  |  | Value Array |  |  | Unique Master Array |  |  | [NAME] |  |  | Desired Outcome
 |  |  |  |  |  |  | Red | True |  | 25 |  |  | Red | True
 |  |  |  |  |  | A | Blue | True | 40 | 10 |  | A | Blue | True |  | 1.201288806025515e+25
 |  |  |  |  |  | B | Blue | False | 450 | 100 |  | B | Blue | False |  | 4.00429602008505e+24
 |  |  |  |  |  | A | Blue | True | 100 | 250 |  | C | Blue | False |  | 4.00429602008505e+24
 |  |  |  |  |  | A | Blue | True | 600 | 300 |  | A | Yellow | True |  | 4.00429602008505e+24
 |  |  |  |  |  | C | Blue | False | 25 | 0
 |  |  |  |  |  | A | Red | True | 400 | 150
 |  |  |  |  |  | A | Red | True | 150 | 75
 |  |  |  |  |  | A | Yellow | True | 400 | 50
 |  |  |  |  |  | [NAME] | Working, but as the size of array is dynamic the number of criteria ranges and criteria will change.
 |  |  |  |  |  | Sometimes the data will be like this |  |  |  |  | Or like this etc.
 |  |  |  |  |  | Master [NAME] |  | Value Array |  |  | Master [NAME] |  |  |  | Value Array
 |  |  |  |  |  |  | Red |  |  |  |  | Red | True | Int
 |  |  |  |  |  | A | Blue | 40 |  |  | A | Blue | True | Int | 40
 |  |  |  |  |  | B | Blue | 450 |  |  | B | Blue | False | Int | 450
 |  |  |  |  |  | A | Blue | 100 |  |  | A | Blue | True | Ext | 100
 |  |  |  |  |  | A | Blue | 600 |  |  | A | Blue | True | Ext | 600
 |  |  |  |  |  | C | Blue | 25 |  |  | C | Blue | False | Ext | 25
 |  |  |  |  |  | A | Red | 400 |  |  | A | Red | True | Ext | 400
 |  |  |  |  |  | A | Red | 150 |  |  | A | Red | True | Int | 150
 |  |  |  |  |  | A | Yellow | 400 |  |  | A | Yellow | True | Ext | 400
Spreadsheet: 829234d1684057528-multi-criteria-search-across-several-tabs-grid-lookup-etaf
Sheet: Sheet1

model | size |  | a | b | c | d
one | XS |  | 1 | 2 | 3 | 4 |  |  | Model | Size | Colour
one | S |  | 10 | 20 | 30 | 40 |  |  | two | L | C
one | M |  | 19 | 38 | 57 | 76 |  |  | one | XS | D
one | L |  | 28 | 56 | 84 | 112 |  |  | one | XS | A
one | XL |  | 37 | 74 | 111 | 148 |  |  | one | XL | D
Two | XS |  | 55 | 110 | 165 | 220
Two | S |  | 64 | 128 | 192 | 256
Two | M |  | 73 | 146 | 219 | 292
Two | L |  | 82 | 164 | 246 | 328
Two | XL |  | 91 | 182 | 273 | 364
Spreadsheet: 809435d1671091715-match-copy-cell-to-current-month-column-book1
Sheet: Sheet1

 |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | 123456 |  | 11 | 22 | 33 | 44 | 55 | 66 | 77 | 88 | 99 | 110 | 121 | 132
Spreadsheet: 4cffecd6-d316-4f1b-a7e6-5c663a3504a2
Sheet: Sheet1

Australian Bureau of Statistics | Unnamed: 1 | Unnamed: 2
87310DO001_201203 Building Approvals, Australia, March 2012
Released at 11:30 am (Canberra time) Fri 11 May 2012
 | Contents
 | Tables
 | 1 | ASGS Data Items, by Statistical Area 2 (SA2)
 | 2 | ASGS Data Items, by Local Government Area (LGA) (a)
 | 3 | ASGS Data Items, by Greater Capital City Statistical Area (GCCSA), State and Australia
 | More information available from the ABS website
 | Building Approvals, Australia, March 2012
 | Summary
 | Explanatory Notes
 | Inquiries
 | For further information about these and related statistics, contact the National Information and Referral Service on 1300 135 070.
 | © Commonwealth of Australia 2012
Spreadsheet: 020c3628-c4d0-45bf-ba73-3370464c053f
Sheet: Sheet1

 | Witts July CMH Number Served | Witts July AMH Number Served
IDHW, DBH, Region 1 | 68 | 323
IDHW, DBH, Region 2 | 67 | 219
IDHW, DBH, Region 3 | 70 | 438
IDHW, DBH, Region 4 | 125 | 599
IDHW, DBH, Region 5 | 53 | 301
IDHW, DBH, Region 6 | 54 | 268
IDHW, DBH, Region 7 | 167 | 478
Total | 604 | 2626
Spreadsheet: 170497d1343301913-dependent-lists-but-one-with-a-condition-test-ccernat-oeldere-
Sheet: Sheet1

Nr. FPO | Articol | Cantitate | Data | Status | Operatie inventar
[NAME] |  |  |  |  |  |  |  |  | FPO NO | Item No_ | Description | Unit of Measure Code | Expected Quantity | REPLESNIHMENT
 |  |  |  |  |  |  |  |  | RC46285 | BA379955 D-07 OLD | TEAVA D42x3,25 - S235 | PCES | 53 | 0
 |  |  |  |  |  |  |  |  | RC46285 | BA379955 D-08 | OTEL 8    -    S235 JR | PCES | 53
 |  |  |  |  |  |  |  |  | RC46285 | BA379955 D-09 | TEAVA 30x30x2 - S235 | PCES | 53 | 0
 |  |  |  |  |  |  |  |  | RC46285 | BA379955 D-10 | OTEL 2    -    S235 JR | PCES | 53
 |  |  |  |  |  |  |  |  | RC46285 | BA379955 D-11 | OTEL 5    -    S235 JR | PCES | 53
 |  |  |  |  |  |  |  |  | RC46285 | BA379955 D-12 | TEAVA 30x30x2 - S235 | PCES | 53
 |  |  |  |  |  |  |  |  | FPO31942 | BA487341 D-01 | OTEL 3   -    S235 JR | PCES | 50
 |  |  |  |  |  |  |  |  | [NAME] | BA387602 D-01 | OTEL 4    -    S235 JR | PCES | 30 | 0
 |  |  |  |  |  |  |  |  | [NAME] | BA387602 D-02 | OTEL 4    -    S235 JR | PCES | 30 | 0
 |  |  |  |  |  |  |  |  | [NAME] | BA387602 [NAME] | OTEL 8    -    S235 JR | PCES | 60
 |  |  |  |  |  |  |  |  | [NAME] | BA387602 D-04 | OTEL 8    -    S235 JR | PCES | 60
 |  |  |  |  |  |  |  |  | RC0330911 | CN54660 H-30 | OTEL 5    -    CREUSABRO | PCES | 8
 |  |  |  |  |  |  |  |  | RC2190311 | CN54658 D-08 | BARA 60x30 | PCES | 9 | 0
 |  |  |  |  |  |  |  |  | RC2190311 | CN54658 D-16 | OTEL 8    -    S235 JR | PCES | 3
 |  |  |  |  |  |  |  |  | RC0310911 | TABLA 080 | OTEL 8    -    S235 JR | MP | 0.033
 |  |  |  |  |  |  |  |  | RC0310911 | TABLA 080 | OTEL 8    -    S235 JR | MP | 0.151
 |  | REPLESNIHMENT | 0
 |  | Rijlabels | Aantal van REPLESNIHMENT
 |  | [NAME] | 2
 |  | RC2190311 | 1
 |  | RC46285 | 2
 |  | Eindtotaal | 5
Spreadsheet: 544193d1508794875-drop-down-list-from-table-w-data-validation-copy-format-of-table-too-character-tracking
Sheet: Characters

http://easydamus.com/alignment.html
 | Names | Names | Names | Names | Names | Names | Names | Names | Names | Names | Names | Names | Names
Alignment | [NAME] | Neutral Good | Chaotic Good | [NAME] | Neutral | Chaotic Neutral | [NAME] | Neutral Evil | Chaotic Evil | Neutral | Neutral | Neutral | Neutral
Relevance
Characteristics
Personal Goal(s)
Spreadsheet: 722734d1615388627-input-cell-value-from-another-sheet-and-have-it-output-another-cells-value-in-other-sheet-master-st-albans-carpentry-and-lofts-work-sheetb
Sheet: Master

Job Number: |  |  |  |  |  |  |  |  | Parts & Sub-Contractor Invoices
Date | Office Notes | Attendance Date | ID | Employee | Description of Works | Hours on Site | Parking Cost | Congestion Charge | Date of Invoice | Supplier/Sub-Contractor Name | Description of Works/Materials | Invoice Number | Parts Cost | Total Cost??
 |  | 2021-03-10 00:00:00 | 1 |  | Installed garden fence | 28 | 12 | 23 | 10 | BNQ | FENCE PANELS |  | 34234
 |  |  | 3
Spreadsheet: 540514d1506718299-drop-down-list-with-conditionals-websphere-test-cheat-sheet
Sheet: WebSphere Single

WebSphere Single Variable Selection
Application Name: | Free Text
Hostname: | Free Text
Management IP: | Free Text
Requestor: | Free Text
System Owner: | Free Text
System Owner Backup: | Free Text
Type of Installation:
WebSphere Version:
Number of Nodes:
Add to Existing DMGR:
DMGR Hostname: | Free Text
Number of IHS:
Spreadsheet: mike_carson__27520__11-30-2001cf
Sheet: Sheet1

 | Nov 30, 2001 |  | Amerex Power - East - Closing Prices
 | CINERGY |  |  | ENTERGY |  |  | TVA |  |  | COM ED |  |  | ERCOT |  |  | PJM
Z1 | DEC 01 |  |  | DEC 01 |  |  | DEC 01 |  |  | DEC 01 |  |  | DEC 01 |  |  | DEC 01 | 29.7 | 29.85 | Z1
F2-G2 | WIN 02 | 25.15 | 25.4 | WIN 02 |  |  | WIN 02 |  |  | WIN 02 |  |  | WIN 02 |  |  | WIN 02 | 29.65 | 29.8 | F2-G2
H2-J2 | MAR-APR 02 |  |  | MAR-APR 02 |  |  | MAR-APR 02 |  |  | MAR-APR 02 |  |  | MAR-APR 02 |  |  | MAR-APR 02 |  |  | H2-J2
K2 | MAY 02 |  |  | MAY 02 |  |  | MAY 02 |  |  | MAY 02 |  |  | MAY 02 |  |  | MAY 02 |  |  | K2
M2 | JUNE 02 |  |  | JUNE 02 | 32 | 32.5 | JUNE 02 |  |  | JUNE 02 |  |  | JUNE 02 |  |  | JUNE 02 | 40.75 | 41 | M2
N2-Q2 | SUMMER 02 | 46 | 46.5 | SUMMER 02 | 40.5 | 41 | SUMMER 02 |  |  | SUMMER 02 |  |  | SUMMER 02 |  |  | SUMMER 02 | 52.95 | 53.2 | N2-Q2
U2 | SEPT 02 |  |  | SEPT 02 |  |  | SEPT 02 |  |  | SEPT 02 |  |  | SEPT 02 |  |  | SEPT 02 | 27.5 | 28 | U2
V2-Z2 | Q4 02 | 25 | 25.5 | Q4 02 |  |  | Q4 02 |  |  | Q4 02 |  |  | Q4 02 |  |  | Q4 02 |  |  | V2-Z2
F3-G3 | WIN 03 |  |  | WINTER 03 |  |  | WINTER 03 |  |  | WINTER 03 |  |  | WINTER 03 |  |  | WINTER 03 |  |  | F3-G3
H3-J3 | MAR-APR 03 |  |  | MAR-APR 03 |  |  | MAR-APR 03 |  |  | MAR-APR 03 |  |  | MAR-APR 03 |  |  | MAR-APR 03 |  |  | H3-J3
K3 | MAY 03 |  |  | MAY 03 |  |  | MAY 03 |  |  | MAY 03 |  |  | MAY 03 |  |  | MAY 03 |  |  | K3
M3 | [NAME] 03 |  |  | [NAME] 03 |  |  | [NAME] 03 |  |  | [NAME] 03 |  |  | [NAME] 03 |  |  | [NAME] 03 |  |  | M3
N3-Q3 | SUMMER 03 |  |  | SUMMER 03 | 39.5 | 40.5 | SUMMER 03 |  |  | SUMMER 03 |  |  | SUMMER 03 |  |  | SUMMER 03 |  |  | N3-Q3
U3 | SEPT 03 |  |  | SEPT 03 |  |  | SEPT 03 |  |  | SEPT 03 |  |  | SEPT 03 |  |  | SEPT 03 |  |  | U3
V3-Z3 | Q4 03 |  |  | Q4 03 |  |  | Q4 03 |  |  | Q4 03 |  |  | Q4 03 |  |  | Q4 03 |  |  | V3-Z3
N4-Q4 |  |  |  | JUNE 04 | 33 | 34 |  |  |  |  |  |  |  |  |  | SUMMER 04 |  |  | N4-Q4
F2-Z2 | CAL 02 |  |  | CAL 02 |  |  | CAL 02 |  |  | CAL 02 |  |  | CAL 02 |  |  | CAL 02 |  |  | F2-Z2
F3-Z3 | CAL 03 |  |  | CAL 03 |  |  | CAL 03 |  |  | CAL 03 |  |  | CAL 03 |  |  | CAL 03 |  |  | F3-Z3
F4-Z4 | CAL 04 |  |  | CAL 04 |  |  | CAL 04 |  |  |  |  |  | CAL 04 |  |  | CAL 04 |  |  | F4-Z4
F5-Z5 | CAL 05 |  |  | CAL 05 |  |  | CAL 05 |  |  |  |  |  | CAL 02 OFF |  |  | CAL06-10 |  |  | F5-Z5
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | NORTH ZONE |  |  | GAS CLOSE:
 | CAL 02 OFF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JAN: | 2.69
 | CAL03 OFF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB: | 2.78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAR: | 2.78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APR: | 2.75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY: | 2.815
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUN: | 2.87
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUL: | 2.925
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUG: | 2.94
Spreadsheet: fbffd965-e97c-44a2-aef6-8ab5f7827a11
Sheet: Sheet1

search pat: | (GTTGT)(.{3,45}?)(ATTGTA) | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
[NAME]. [NAME] |  |  |  | [NAME]. 3UTR |  | putative D. pseudo. 3UTR |  | [NAME]. 3UTR seq locatoin in genome
gene | name | FBgn | transcripts | length | pattern match | length | pattern match | coordinates | strand | chr
CG1725 | dlg1 | FBgn0001624 | CG1725-RA_RD | 1572 | 1491-1534 (GTTGT..33..ATTGTA)a1 | 1778 | 1707-1740(GTTGT..23..ATTGTA), | 11148115-11149686, | + | chrX
CG18069 | CaMKII | FBgn0004624 | CG18069-RA_RB_RC | 1258 | 248-274 (GTTGT..16..ATTGTA) | 1306 | NO_MATCH | 1055475-1056732, | - | chr4
CG4427 | EP2237 | FBgn0043364 | CG4427-RA_RB | 553 | 401-443 (GTTGT..32..ATTGTA) | 611 | NO_MATCH | 478102-478654, | - | chr2L
CG8118 | mam | FBgn0002643 | CG8118-RA_RB | 2445 | 716-735 (GTTGT..9..ATTGTA)n |  | NO_SEQ | 9122626-9125070, | + | chr2R
CG9113 | AP-1gamma | FBgn0030089 | CG9113-RA_RB_RC_RD | 257 | 122-141 (GTTGT..9..ATTGTA)n |  | NO_SEQ | 8855244-8855500, | + | chrX
Notations for some columns
FBgn: FlyBase gene ID
transcripts: the transcripts that share the same 3UTR. For example, CG6395-RB_RC means CG6395-RB and CG6395-RC, whose 3UTR are identical.
pattern match: represented as "start-end coordinates (matched sequence)". The number between the dots represents the length of the sequence between the two boxes. Coordinates are referred to the stop codon (the first nucleotide of the stop codon as coordinate 1).
The suffix in D. mel. pattern match represents the conservation between D. mel. and D. pseudo. Example: a2 - the predicted site is aligned with the second predicted site in D. pseudo. o1 - the predicted site overlaps with the first predicted site in D. pseudo.  n - correspondent 3'UTR sequence in D. pseudo is not available.
Spreadsheet: 704835d1605771464-find-start-and-end-month-based-multiple-conditions-example
Sheet: Sheet1

Status | Client | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Existing | PT A | 1000 | 1000 | 1000 | 1000 | 1000
Keep-1 | PT B |  | 3000 | 3000 | 3000 | 3000 | 3000 | 3000
Keep-1 | PT A |  |  |  |  |  | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
Keep-2 | PT B |  |  |  |  |  |  |  | 4000 | 4000 | 4000 | 4000
 |  | Start | End
PT A | Existing | Jan | May |  | To find start and end month with multiple condition
PT A | Keep 2 | Jun | Dec
PT B | Keep 1 | Feb | Jul
PT B | Keep 2 | Aug | Nov
Spreadsheet: 196670d1354063478-find-out-how-many-days-to-code-from-one-table-to-another-ef279_esempio
Sheet: Foglio2

Tab - A |  |  |  | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
start | end | Cod
2010-01-01 00:00:00 | 2010-03-12 00:00:00 | 1
 | 2010-06-10 00:00:00 | 40
 | 2010-08-03 00:00:00 | 50
 | 2010-09-13 00:00:00 | 50
 | 2010-10-04 00:00:00 | 1
 | 2010-10-07 00:00:00 | 50
 | 2010-10-15 00:00:00 | 64
 | 2010-10-25 00:00:00 | 40
 | 2010-11-08 00:00:00 | 1
 | 2011-08-28 00:00:00 | 1
 | 2011-08-31 00:00:00 | 50
 | 2011-09-11 00:00:00 | 40
 | 2011-09-20 00:00:00 | 50
 | 2011-09-26 00:00:00 | 40
 | 2011-09-29 00:00:00 | 50
 | 2011-10-03 00:00:00 | 40
 | 2011-10-07 00:00:00 | 50
 | 2011-12-23 00:00:00 | 1
 | 2012-01-20 00:00:00 | 40
 | 2012-02-15 00:00:00 | 40
 | 2012-03-17 00:00:00 | 40
 | 2012-04-16 00:00:00 | 50
 | 2012-07-31 00:00:00 | 64
 | 2012-10-31 00:00:00 | 64
 |  |  | COD | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
 |  |  | 1
 |  |  | 40
 |  |  | 50
 |  |  | 64
Spreadsheet: 57096d1257267539-display-if-help
Sheet: Sheet1

 |  |  | Running Sum of B when A = 9
9 | 1 | 0 |  | 17 | 20
9 | 5 | 0 |  | 17 | 21
9 | 3 | 0 |  | 17 | 22
9 | 10 | 15 |  | 17 | 23
9 | 5 | 0 |  | 17 | 24
9 | 2 | 0 |  | 17 | 25
8 | 1 | 0 | Running Sum of B when A = 8 | 20 | 29
8 | 5 | 0 |  | 20 | 30
8 | 2 | 0 |  | 20 | 31
8 | 7 | 9 |  | 20 | 32
8 | 4 | 0 |  | 20 | 33
8 | 2 | 0 |  | 20 | 34
 |  |  |  |  | Display Colum E - Column F when the row in Column B's running sum >= the row in Column C's running sum
Spreadsheet: 50824d1250314843-keeping-track-of-payments-test
Sheet: 3

 |  |  |  | Job Name
 |  |  |  | Plot No./Type | 3
 |  |  |  | Labour Times |  | Plot / Type | Labour price
 |  |  |  |  | hrs | Joists 1st floor
 |  |  |  |  | hrs | Joists 2nd floor
 |  |  |  |  | hrs | Roof
 |  |  |  |  | hrs | Low Level
 |  |  |  |  | hrs | Garage Roof
 |  |  |  |  | hrs | First Fix
 |  |  |  |  | hrs | External doors
 |  |  |  |  | hrs | Second Fix
 |  |  |  |  | hrs | Final fix
 |  |  |  |  | hrs | Snag
 |  |  |  |  | hrs | Total
 |  |  |  | Price Quote for plot/type | Total | Profit | Fixings
 |  |  |  | Joists 1st floor
 |  |  |  | Joists 2nd floor
 |  |  |  | Roof
 |  |  |  | Low Level
 |  |  |  | Garage Roof
 |  |  |  | First Fix
 |  |  |  | External doors
 |  |  |  | Second Fix
 |  |  |  | Final fix
 |  |  |  | Snag
 |  |  |  | Extra add on's (see notes)
 |  |  |  | Total
Notes
Job Name |  |  |  |  | Plot No.
Gr | 1st | 2nd | Qty | Item | labour total | my total | fixings | Time
92 |  |  |  | Joist & Decking TJI psm 1st floor
 |  |  |  | Total Joist 1st floor
 |  |  |  | Joist & Decking TJI psm 2nd floor
 |  |  |  | Total Joist 2nd floor
92 |  |  |  | Trusses psm
 |  |  |  | Pediment [NAME]
8 |  |  |  | Dormer hand cut
 |  |  |  | [NAME]made Fibreglass
 |  |  |  | Attic Trusses psm
 |  |  |  | Velux
 |  |  |  | Valley pr/m Trusses
 |  |  |  | Hip pr/m
7 |  |  |  | Hand cut section
 |  |  |  | Total Roof
20 |  |  |  | Low Levels
 |  |  |  | Garage Roof
 |  |  |  | Stairs -Straight Flight
 |  |  |  | Stairs -Kite over Garage wall
1 |  |  |  | Stairs-Double kite
 |  |  |  | Stairs-Kite
6 |  |  |  | Block casing
 | 7 |  |  | [NAME] casing
1 | 1 |  |  | Plasterboard catch noggins(per floor)
1 | 1 |  |  | Soil boxing
 |  |  |  | Metal Studding pm
 | 35 |  |  | Studding pm
11 | 8 |  |  | Window board
 |  |  |  | Temp handrail
 |  |  |  | Protect Stairs
 |  |  |  | Total 1st Fix
2 |  |  |  | Front/Back Door & Frame & Lock
 |  |  |  | Fire door
6 | 7 |  |  | Standard door
77 | 80 |  |  | Skirting
2 | 3 |  |  | Pipe Boxings p/m
 |  |  |  | Furniture
 |  |  |  | Arcs
 |  |  |  | Drilling and cutting latches
 |  |  |  | Strings hand rails, spindles per flight
 |  |  |  | Total 2nd Fix
 | 1.5 |  |  | Bath/Shower Panel
 | 1 |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Door furniture
 |  |  |  | Intumescent strips
 |  |  |  | Re-hang doors
 |  |  |  | Total Final Fix
 |  |  |  | Snag price
Spreadsheet: 863903d1711300104-not-sure-whether-to-use-vlookup-or-if-and-then-or-combo-rental-payments-sample-aligw
Sheet: Results

WHAT I WANT
Month | Rent | Water | Sewer | Late Fee | Total
2019-11-01 00:00:00 | 334 | 10.3 | 8.92
2019-12-01 00:00:00 | 334 | 8.49 | 6.45
 | Dollar value from Column 7
Month |  | Rent | Water | Sewer | Late Fee | Total
2019-11-01 00:00:00
2019-12-01 00:00:00
Spreadsheet: 206d2740-96ad-47ec-a92b-cc7f52b74c12
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
08/24/2013 | Volleyball | Gold/Blue Scrimmage | Gold, 3-1
08/31/2013 | Volleyball | vs. Eastern Illinois (Blue/Gold Invitational at Toledo) | W, 3-1
08/31/2013 | Volleyball | vs. Loyola-Chicago (Blue/Gold Invitational at Toledo) | W, 3-0
09/01/2013 | Volleyball | at Toledo (Blue/Gold Invitational at Toledo) | W, 3-0
09/06/2013 | Volleyball | Norfolk State (Mountaineer Invitational) | W, 3-0
09/06/2013 | Volleyball | Canisius (Mountaineer Invitational) | W, 3-0
09/07/2013 | Volleyball | [NAME] (Mountaineer Invitational) | W, 3-0
09/07/2013 | Volleyball | Navy (Mountaineer Invitational) | W, 3-0
[NAME] | Volleyball | at Morehead State (Eagle Challenge at Morehead State) | W, 3-1
09/14/2013 | Volleyball | vs. Campbell (Eagle Challenge at Morehead State) | W, 3-0
09/14/2013 | Volleyball | vs. [NAME] (Eagle Challenge at Morehead State) | W, 3-2
[NAME] | Volleyball | at Duquesne | L, 0-3
09/20/2013 | Volleyball | Liberty (WVU Gold and Blue Players Challenge) | W, 3-0
09/20/2013 | Volleyball | Georgetown (WVU Gold and Blue Players Challenge) | W, 3-2
09/22/2013 | Volleyball | UMBC (WVU Gold and Blue Players Challenge) | W, 3-1
[NAME] | Volleyball | Kansas State* | W, 3-1
10/02/2013 | Volleyball | at TCU* | L, 1-3
10/05/2013 | Volleyball | at Texas Tech* | W, 3-1
10/09/2013 | Volleyball | Baylor* | L, 0-3
10/12/2013 | Volleyball | at Iowa State* | L, 0-3
10/16/2013 | Volleyball | [NAME] | W, 3-0
10/19/2013 | Volleyball | No. 23 Kansas* | L, 1-3
10/23/2013 | Volleyball | No. 1 Texas* | L, 0-3
10/26/2013 | Volleyball | at Oklahoma* | L, 0-3
10/29/2013 | Volleyball | [NAME] | L, 1-3
11/02/2013 | Volleyball | Texas Tech* | W, 3-2
[NAME] | Volleyball | at No. 24 Kansas* | L, 0-3
11/09/2013 | Volleyball | at Kansas State* | L, 0-3
11/13/2013 | Volleyball | Iowa State* | L, 0-3
11/16/2013 | Volleyball | TCU* | W, 3-0
11/21/2013 | Volleyball | at No. 1 Texas* | L, 0-3
11/23/2013 | Volleyball | at Baylor* | W, 3-1
11/27/2013 | Volleyball | Oklahoma* | L, 1-3
11/30/2013 | Volleyball | at Buffalo | W, 3-0
Spreadsheet: 881171d1729095777-if-no-value-in-multiple-cells-then-show-empty-if-no-value-for-multiple-cells
Sheet: Sheet1

 |  |  |  |  |  | Example
 | Item | Qty | KG/unit | KG/Total |  | Item | Qty | KG/unit | KG/Total
 | Widget 1 | 20 | 0.5 |  |  | Widget 1 |  | 0.5
 | Widget 2 |  | 0.78 |  |  | Widget 2 |  | 0.78
 | Widget 3 | 12 | 1 |  |  | Widget 3 |  | 1
 | Widget 4 |  | 65 |  |  | Widget 4 |  | 65
 | Pallet | 1 | 15 |  |  | Pallet | 1 | 15
 | If no value in B4:B7 then E8 shows no value.
Spreadsheet: 690724d1597253221-last-man-standing-adding-additional-users-and-checking-formulas-preacher79-last-man-standing-template-3-1
Sheet: Setup

Carried over: |  |  | Cost to enter: | 10 |  | Pot: |  |  |  | Number of lives:
Teams |  | # | Player Name | Paid |  | Game 1 | Win, [NAME], Draw | Game 2 | Win, [NAME], Draw | Game 3 | Win, [NAME], Draw | Game 4 | Win, [NAME], Draw | Game 5 | Win, [NAME], Draw | Game 6 | Win, [NAME], Draw | Game 7 | Win, [NAME], Draw | Game 8 | Win, [NAME], Draw | Game 9 | Win, [NAME], Draw | Game 10 | Win, [NAME], Draw | Game 11 | Win, [NAME], Draw | Game 12 | Win, [NAME], Draw | Game 13 | Win, [NAME], Draw | Game 14 | Win, [NAME], Draw | Game 15 | Win, [NAME], Draw | Game 16 | Win, [NAME], Draw | Game 17 | Win, [NAME], Draw | Game 18 | Win, [NAME], Draw | Game 19 | Win, [NAME], Draw | Game 20 | Win, [NAME], Draw
AFC Bournemouth |  | 1 | Player 01
Arsenal |  | 2 | Player 02
Brighton & Hove Albion |  | 3 | Player 03
Burnley FC |  | 4 | Player 04
Cardiff City |  | 5 | Player 05
Chelsea |  | 6 | Player 06
Crystal Palace |  | 7 | Player 07
Everton |  | 8 | Player 08
Fulham |  | 9 | Player 09
Huddersfield Town |  | 10 | Player 10
Leicester City |  | 11 | Player 11
Liverpool |  | 12 | Player 12
Manchester City |  | 13 | Player 13
[NAME] |  | 14 | Player 14
Newcastle United |  | 15 | Player 15
Southampton |  | 16 | Player 16
[NAME] |  | 17 | Player 17
Watford |  | 18 | Player 18
West Ham United |  | 19 | Player 19
[NAME] |  | 20 | Player 20
Team 21 |  | 21 | Player 21
Team 22 |  | 22 | Player 22
Team 23 |  | 23 | Player 23
Team 24 |  | 24 | Player 24
Team 25 |  | 25 | Player 25
Team 26 |  | 26 | Player 26
Team 27 |  | 27 | Player 27
Team 28 |  | 28 | Player 28
Team 29 |  | 29 | Player 29
Team 30 |  | 30 | Player 30
 |  | 31 | Player 31
 |  | 32 | Player 32
 |  | 33 | Player 33
 |  | 34 | Player 34
 |  | 35 | Player 35
 |  | 36 | Player 36
 |  | 37 | Player 37
 |  | 38 | Player 38
 |  | 39 | Player 39
 |  | 40 | Player 40
 |  | 41 | Player 41
 |  | 42 | Player 42
 |  | 43 | Player 43
 |  | 44 | Player 44
 |  | 45 | Player 45
 |  | 46 | Player 46
 |  | 47 | Player 47
 |  | 48 | Player 48
 |  | 49 | Player 49
 |  | 50 | Player 50
 |  | 51 | Player 51
 |  | 52 | Player 52
 |  | 53 | Player 53
 |  | 54 | Player 54
 |  | 55 | Player 55
 |  | 56 | Player 56
 |  | 57 | Player 57
 |  | 58 | Player 58
 |  | 59 | Player 59
 |  | 60 | Player 60
 |  | 61 | Player 61
 |  | 62 | Player 62
 |  | 63 | Player 63
 |  | 64 | Player 64
 |  | 65 | Player 65
 |  | 66 | Player 66
 |  | 67 | Player 67
 |  | 68 | Player 68
 |  | 69 | Player 69
 |  | 70 | Player 70
 |  | 71 | Player 71
 |  | 72 | Player 72
 |  | 73 | Player 73
 |  | 74 | Player 74
 |  | 75 | Player 75
 |  | 76 | Player 76
 |  | 77 | Player 77
 |  | 78 | Player 78
 |  | 79 | Player 79
 |  | 80 | Player 80
 |  | 81 | Player 81
 |  | 82 | Player 82
 |  | 83 | Player 83
 |  | 84 | Player 84
 |  | 85 | Player 85
 |  | 86 | Player 86
 |  | 87 | Player 87
 |  | 88 | Player 88
 |  | 89 | Player 89
 |  | 90 | Player 90