tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 270194d1381412789-if-date-is-in-future-return-no-value-otherwise-return-in-a-new-cell-the-month-i-e-june-6-test-spreadsheet
Sheet: Operator Entry

When participants dial into their call they are greeted by an operator who will take the callers password and any other information (Name, location, department etc)
Country | Phone Number | DNIS | Country Code
China N BoA | 10 800 7141 862 | 4056 | 86
China N BoA | 10 800 7141 863 | 4068 | 86
China S & N BoA | 10 800 1401 892 | 4056 | 86
France BoA | 0800 914 103 | 4048 | 33
Germany BoA | [PHONE] | 4049 | 49
Hong Kong BoA | 800 962 782 | 4055 | 852
India BoA | [PHONE] 758 | 4054 | 91
Ireland BoA | 1800 948 862 | 4053 | 353
Italy BoA | 800 859 045 | 4052 | 39
Spain BoA | 900 834 811 | 4050 | 34
SWI BoA | 0800 848 883 | 4051 | 41
UK BoA | [PHONE] | 4046 | 44
UK Local BoA | 020 3478 5921 | 4047 | 44
USA BoA | 18554420876 | 4045 | 1
Spreadsheet: sally_beck__33998__6th floor EB South
Sheet: Sheet2

Generation Dev. | [NAME].
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME].
[NAME].
[NAME]
Spreadsheet: 36461d1234355546-pivot-same-data-in-two-columns-pivot_example
Sheet: Sheet1

Item | FixFloat | BlackWhite | Value
A | Fix | B | 100
B | Float | B | 200
C | Float | B | 100
D | Float | W | 150
E | Fix | W | 300
F | Fix | W | 400
G | Fix | W | 500
This is what I get... |  |  |  |  |  |  |  |  | This is what I'd like to see and how I manage it now...
Sum of Value | FixFloat | BlackWhite |  |  |  |  |  |  | Sum of Value | FixFloat |  |  | Sum of Value | BlackWhite
 | Fix |  | Fix Total | Float |  | Float Total | Grand Total |  | Item | Fix | Float | Grand Total | Item | B | W | Grand Total
Item | B | W |  | B | W |  |  |  | A | 100 |  | 100 | A | 100 |  | 100
A | 100 |  | 100 |  |  |  | 100 |  | B |  | 200 | 200 | B | 200 |  | 200
B |  |  |  | 200 |  | 200 | 200 |  | C |  | 100 | 100 | C | 100 |  | 100
C |  |  |  | 100 |  | 100 | 100 |  | D |  | 150 | 150 | D |  | 150 | 150
D |  |  |  |  | 150 | 150 | 150 |  | E | 300 |  | 300 | E |  | 300 | 300
E |  | 300 | 300 |  |  |  | 300 |  | F | 400 |  | 400 | F |  | 400 | 400
F |  | 400 | 400 |  |  |  | 400 |  | G | 500 |  | 500 | G |  | 500 | 500
G |  | 500 | 500 |  |  |  | 500 |  | Grand Total | 1300 | 450 | 1750 | Grand Total | 400 | 1350 | 1750
Grand Total | 100 | 1200 | 1300 | 300 | 150 | 450 | 1750
Spreadsheet: 820457d1678114125-share-performance-mix-of-controllables-vs-non-excel-help
Sheet: Sheet1

 | Category | Do we play in this Category? | [NAME] | [NAME] | YoY Growth
 | TOTAL MARKET |  |  |  |  |  |  | [NAME] | [NAME]
 | 1 | Y | 83392139 |  |  |  | Y
 | 2 | N | 19817031.8 |  |  |  | N
 | 3 | N | 7171678.9
 | 4 | Y | 45250297.9
 | 5 | N | 3496846.7
 | 6 | Y | 23238982.6
 | 7 | Y | 32640179.7
 | 8 | N | 527490.5
 | 9 | N | 7606827.399999999
 | 10 | N | 27942513.2
 | 11 | N | 7282975
 | 12 | N | 13357998
 | 13 | N | 4555307.5
 | 14 | Y | 4259653.899999999
 | 15 | N | 21588100.6
 | 16 | Y | 151923722
 |  |  |  |  |  | [NAME] | Share TY | Share Change
 | TOTAL SUPPLIER
 | 1 |  | 22354958 | 25645244.2
 | 4 |  | 7406040.199999999 | 8640378.6
 | 6 |  | 1095761.4 | 1219208
 | 7 |  | 3208409.5 | 4273522.7
 | 14 |  | 4063261.699999999
 | 16 |  | 3436371.2
Spreadsheet: 61067d1261659243-transfer-sums-in-one-column-based-on-date-to-another-cell-exception-sample-4-
Sheet: Sheet1

 |  |  |  | Tracking Calendar for Rolling 6 Months
 |  |  |  | Month | Exceptions | Points
 |  |  |  | 2009-01-01 00:00:00
 |  |  |  | 2009-02-01 00:00:00
 |  |  |  | 2009-03-01 00:00:00
 |  |  |  | 2009-04-01 00:00:00
 |  |  |  | 2009-05-01 00:00:00
 |  |  |  | 2009-06-01 00:00:00
 |  |  |  | 2009-07-01 00:00:00
 |  |  |  | 2009-08-01 00:00:00
 |  |  |  | 2009-09-01 00:00:00
 |  |  |  | 2009-10-01 00:00:00
 |  |  |  | 2009-11-01 00:00:00
 |  |  |  | 2009-12-01 00:00:00
Exception Date | Tracking
2009-04-01 00:00:00
2009-05-05 00:00:00 | 1
2009-06-03 00:00:00
2009-07-18 00:00:00
2009-08-24 00:00:00
2009-09-05 00:00:00
2009-09-11 00:00:00 | 1
2009-09-25 00:00:00
2009-10-02 00:00:00
2009-10-04 00:00:00
2009-12-01 00:00:00
2009-12-04 00:00:00
Spreadsheet: 194846d1353346051-depuping-a-list-for-names-and-emails-parents-2012-2013-sample-workbook
Sheet: Yr2012_DirectoryQuery

Grade | _Last Name | SName | Email Address 1 | EMail Address  2 | ULEmail
5 | Zucga | Kristen | [EMAIL] | [EMAIL]
4 | Zubbman | [NAME] | [EMAIL] | [EMAIL]
10 | Zubbman | Rachel | [EMAIL] | [EMAIL]
8 | Zimmerman | Biil
7 | Zimmerman | [NAME] | [EMAIL] | [EMAIL]
3 | Zerouali | [NAME] | [EMAIL]
3 | Zerouali | [NAME]
6 | [NAME] | Ziyi | [EMAIL]
11 | [NAME] | Zijian | [EMAIL]
5 | [NAME] | Olivia | [EMAIL]
1 | [NAME] | Reese | [EMAIL]
3 | [NAME] | Juwayria |  | [EMAIL]
9 | [NAME] | Hamza |  | [EMAIL]
6 | [NAME] | Yusuf |  | [EMAIL]
2 | Young | Riley | [EMAIL] | [EMAIL]
1 | Young | [NAME] | [EMAIL]
Spreadsheet: 483405d1475645740-i-want-to-combine-4-columns-data-into-one-but-without-extra-sign-book1
Sheet: Sheet1

School1 | School2 | School3 | School4 | Result | I want this way
 | School2 |  | School4 |  | School2+School4
School1 | School2 | School3 |  |  | School1+School2+School3
 |  | School3 | School4 |  | School3+School4
School1 |  |  |  |  | School1
 |  |  | School4 |  | School4
 | School2 |  |  |  | School2
Spreadsheet: 475959d1471537058-help-with-expanding-this-workbook-powerpost-example-file
Sheet: 1-300

 |  |  | ACCT # |  |  | [NAME]
 |  |  | 332P |  |  | Example File
 |  |  | put control # and amount on sheet 2
 |  |  | CHECK FIGURE
 |  |  | COUNT
 |  |  | SUM
Spreadsheet: d762a02a-beb5-40e8-911f-ce0f69886faf
Sheet: Sheet1

Transaction Posting Date | Merchant Name | Transaction Amount
2012-04-03 00:00:00 | WWW.NEOPOST.CO.UK | 2472
2012-04-04 00:00:00 | INFORMATION SYSTEMS AUDI | 510.94
2012-04-04 00:00:00 | WWW.NEOPOST.CO.UK | 2472
2012-04-11 00:00:00 | WWW.NEOPOST.CO.UK | 3090
2012-04-16 00:00:00 | HAMPSHIREFL | 921.59
2012-04-18 00:00:00 | TO-AN-FRO CAR & VAN HIRE | 810
2012-04-18 00:00:00 | BOUNDRY SCAFFOLDING LT | 1173
2012-04-19 00:00:00 | OUT-TAKES LTD | 660
Spreadsheet: phillip_m_love__30147__9910_OA
Sheet: WE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 30511507 | 77372482
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 16114174 | 43985024
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 46625681 | 121357506
 | Purchases:
6 |  | 3rd Party / Inter Enron | -31688679 | -77791801
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -14820932 | -40713579
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 270716 | 705468
 | Total Purchases: |  | -46238895 | -117799912
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | -33906 | -92962
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | -313014 | -885054
 | Total Imbalances: |  | -346920 | -978016
 | Storage:
17 |  | Injection (Sales to Stg) | 53828 | 127611
18 |  | W/D (Purchase from Stg) | -93773 | -259254
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -93773 | -259254
 | Total Storage: |  | -39945 | -131643
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 95 | 227.0360369336665
23 | Fuel: |  | -270716 | -705468
 | Transport Expense:
24 |  | Commodity | 0 | -1711
25 |  | Demand | 0 | -1336060.51
 | Total Transport Expense: |  | 0 | -1337771.51
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | -1343082
31 |  | Prior Month Book Balance | 0 | -2316418
 |  | Total MTM Income | 0 | -3659500
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 4339471.5
34 |  | Originations | 0 | 11284
35 |  | Broker Fees | 0 | -18099
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -109060
 |  | TOTAL INTRA-MTH
FT-West
 |  | Current Month MTM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 116103d1311604248-index-match-formula-new_user_data
Sheet: Pax data

Company ID | Company Name | Company ID | Company Name | Full Name | Role | User ID | Email address |  |  | First Name | Last Name | ADDRESS1 | CITY | STATE | ZIP1
041231 | ABC Industiral | 41231 | #N/A | [NAME] | Mgr | 043017La
041503 | MILLS Manufacturing | 41231 | #N/A | [NAME] | Associate | 041231Stev
041516 | Solid Rock Co. | 41503 |  | [NAME] | Mgr | 041503malcan
041525 | XYC Co. | 41503 |  | [NAME] | Mgr | 041503ddun
041534 | SuperAwesome Company | 41503 |  | [NAME] | Mgr | 041503dham
 |  | 41503 |  | [NAME] | Mgr | 041503aleo
 |  | 41503 |  | [NAME] | Associate | 041503llop
 |  | 41503 |  | [NAME] | Associate | 041503dman
 |  | 41503 |  | [NAME] | Associate | 041503mma
 |  | 41503 |  | [NAME] | Associate | 041503mpars
 |  | 41503 |  | [NAME] | Associate | 041503dper
 |  | 41503 |  | [NAME] | Associate | 041503jschu
 |  | 41503 |  | [NAME] | Associate | 041503mstec
 |  | 41503 |  | Cat Vera | Associate | 041503cviramon
 |  | 41503 |  | [NAME] | Associate | 041503swas
 |  | 41503 |  | [NAME] | Associate | 041503blk
 |  | 41516 |  | [NAME] | Mgr | 041516ma
 |  | 41516 |  | [NAME] | Mgr | 041516pri
 |  | 41516 |  | June Price | Associate | 041516agthpkp
 |  | 41525 |  | [NAME] | principal | 041525prkp
 |  | 41534 |  | [NAME] | Associate | 041534cabl
 |  | 41534 |  | [NAME] | Associate | 041534lcla
 |  | 41534 |  | Amber [NAME] | Associate | 041534eeng
 |  | 41534 |  | nicole [NAME] | Associate | 041534merc
 |  | 41534 |  | [NAME] | Associate | 041534rr
 |  | 41534 |  | [NAME] | Mgr | 041534sraypk
 |  | 41534 |  | [NAME] | Associate | 041534bsaun
Spreadsheet: 155105d1336669442-merge-multiple-spreadsheets-easily-copy-of-tt404l-12-04-09
Sheet: Sheet1

POG # | LINE | P/N | CAPACITY
TT404L | POG | TT404L | 1
TT404L | CPE | 97018 | 1
TT404L | CPS | 82475 | 2
TT404L | CPS | 82476 | 2
TT404L | CPS | 82477 | 2
TT404L | CPS | 82478 | 2
TT404L | CPS | 82486 | 2
TT404L | CPS | 82488 | 2
TT404L | CPS | 82489 | 2
TT404L | CPS | 82493 | 2
TT404L | CPS | 82495 | 2
TT404L | CPS | 82496 | 2
TT404L | CPS | 82497 | 2
TT404L | CPS | 82505 | 2
TT404L | CPS | 82506 | 2
TT404L | CPS | 82508 | 2
TT404L | CPS | 82509 | 2
TT404L | CPS | 82510 | 2
TT404L | CPS | 82515 | 2
TT404L | CPS | 82516 | 2
TT404L | CPS | 82521 | 2
TT404L | CPS | 82530 | 2
TT404L | CPS | 82536 | 2
TT404L | CPS | 82538 | 2
TT404L | CPS | 82546 | 2
TT404L | CPS | 82548 | 2
TT404L | CPS | 82644 | 2
TT404L | CPS | 83020 | 2
TT404L | CPS | 83021 | 2
TT404L | CPS | 83030 | 2
TT404L | CPS | 83031 | 2
TT404L | CPS | 83032 | 2
TT404L | CPS | 83040 | 2
TT404L | CPS | 83080 | 1
TT404L | [NAME] | 35310 | 1
TT404L | [NAME] | 35335 | 1
TT404L | [NAME] | 35336 | 1
TT404L | [NAME] | 35620 | 1
TT404L | [NAME] | 35630 | 1
TT404L | [NAME] | 35634 | 1
TT404L | [NAME] | 35635 | 1
TT404L | [NAME] | 35657 | 1
TT404L | [NAME] | 35659 | 1
TT404L | [NAME] | 35690 | 1
Spreadsheet: 882364d1730733768-excel-extend-series-larsp123-skyttelstatestikk-summering-2023-spill-365-aligw
Sheet: Oppsummering

Uke | Totalt morgen | [NAME] | [NAME] | Totalt Uke
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
49
50
51
52
Spreadsheet: 69797d1270462770-unable-to-sort-range-sorting
Sheet: Sheet1

AVS0003 | 350 | 40 | x | 90 | White 90 gsm | 120000 | 2010-03-25 00:00:00
LCF 0002 | 210 | 39 | x | 93 | White 90 gsm | 7000 | 2010-03-22 00:00:00
RMP0004 | 275 | 50 | x | 95 | White 90 gsm | 30000 | 2010-04-12 00:00:00
CAL0008 | 560 | 50 | x | 95 | White 90 gsm | 60000 | 2010-03-29 00:00:00
HSS0006 | 235 | 50 | x | 95 | White 90 gsm | 60000 | 2010-04-19 00:00:00
LCF 0004 | 235 | 39 | x | 93 | White 90 gsm | 60000 | 2010-03-30 00:00:00
HSS0001 | 235 | 50 | x | 95 | White 90 gsm | 90000 | 2010-04-01 00:00:00
AVS0001 | 235 | 40 | x | 90 | White 90 gsm | 100000 | 2010-04-07 00:00:00
C5ENV-TNT | 235 | 45 | x | 90 | White 90 gsm | 100000 | 2010-04-12 00:00:00
EQU0005 | 220 | 40 | x | 95 | White 90 gsm | 100000 | 2010-04-09 00:00:00
PFE0004 | 440 | 45 | x | 90 | White 90 gsm | 100000 | 2010-04-19 00:00:00
RML4276 | 235 | 40 | x | 90 | White 90 gsm | 100000 | 2010-04-07 00:00:00
TNT0001 | 238 | 45 | x | 90 | White 90 gsm | 120000 | 2010-04-06 00:00:00
AVS0005 | 235 | 40 | x | 90 | White 90 gsm | 250000 | 2010-04-19 00:00:00
Spreadsheet: 38309d1236428857-data-sorting-example
Sheet: Sheet1

User Name | Login atamps | Last login
abdul09471 | 4 | 2009-03-06 16:05:21 | karachi | 021-556679
abdul09471 | 8 | 2009-03-06 09:20:35 | karachi | 021-556679
abdul293 | 3 | 2009-03-06 09:25:17 | karachi | 021-66998877
abid1689 | 2 | 2009-03-06 14:51:04 | karachi | 021-66998877
[NAME] | 2 | 2009-03-06 09:29:56 | karachi | 021-66998877
adnan390 | 1 | 2009-03-06 09:17:18 | karachi | 021-66998877
[NAME] | 5 | 2009-03-06 09:20:54 | karachi | 021-66998877
ahmed1184 | 1 | 2009-03-06 09:31:07 | karachi | 021-66998877
ahmer1911 | 1 | 2009-03-06 10:03:41 | karachi | 021-66998877
ajeet521 | 1 | 2009-03-06 10:04:50 | karachi | 021-66998877
ali09533 | 12 | 2009-03-06 09:35:40 | karachi | 021-66998877
[NAME] | 1 | 2009-03-06 10:05:19 | karachi | 021-66998877
ali550 | 3 | 2009-03-06 14:26:15 | karachi | 021-66998877
amir09483 | 3 | 2009-03-06 09:47:19 | #N/A | #N/A
amir09540 | 4 | 2009-03-06 09:13:38 | #N/A | #N/A
amir1632 | 1 | 2009-03-06 09:35:44 | #N/A | #N/A
anwar1985 | 2 | 2009-03-06 09:47:12 | #N/A | #N/A
arif594 | 2 | 2009-03-06 10:30:12 | #N/A | #N/A
Spreadsheet: 473866d1470445273-ocean-tides-calculator-tide-test
Sheet: Tide Calculation

A Day of Tides
Location: |  |  | Input Tide data
Latitude Longitude:
 |  | Date | Military Time | Tide (High or Low) | Tide level (ft)
 |  | 2016-08-05 00:00:00 | 05:44:00 | Low | 0.01
 |  | 2016-08-05 00:00:00 | 11:30:00 | High | 2.52
 |  | 2016-08-05 00:00:00 | 18:02:00 | Low | -0.03
 |  | 2016-08-05 00:00:00 | 23:53:00 | High | 2.55
 |  | Mean High Tide
 |  | Mean Low Tide
 |  | Mean Tide Level
Current Date and Time
High Tide Table |  |  |  | Low Tide Table
Spreadsheet: 157074d1337610453-excel-2007-lookup-to-return-multiple-rows-of-data-test-template
Sheet: Job 1

 | # | Date | Description | Requested | Spent
 | 1 | 2011-01-04 00:00:00 | Expense | 20000 | 20000
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 2 | 2011-02-22 00:00:00 | Expense | 4000 | 4000
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 3 | 2011-05-09 00:00:00 | Expense | 4000 | 4000
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 4
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 5
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 6
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 7
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 8
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 9
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 10
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 11
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 12
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 13
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 14
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 15
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 16
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 17
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 18
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 19
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 20
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 21
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 22
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 23
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 24
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
Spreadsheet: 64477d1265314263-problems-with-distributions-book1
Sheet: Unit Calculator

 | Project | Sample 1
 | Building SF | 100000
 | Common Area (%) | 0.3
 | Usable Area | 70000
 | Building Composition |  |  |  |  |  |  |  |  |  |  | Hide Unused Rows
 | Unit Type | Unit Varation | Number of Units | Unit [NAME] | Unit Totals | Unit Cost (PSF) | Per Unit Cost | Gross Cost | Unit Price (PSF) | Per Unit Sale Price | Gross Sales
1 | Studio | Type 1 | 57 | 1000 | 57000 | 110 | 110000 | 6270000 | 205 | 205000 | 11685000 | -
2 | 2 Bedroom | Type 1 | 11 | 1000 | 11000 | 163 | 163000 | 1793000 | 248 | 248000 | 2728000 | -
3 | Penthouse | Type 1 | 1 | 2000 | 2000 | 219 | 438000 | 438000 | 318 | 636000 | 636000 | -
4 | Select Type | Select Type | # of Units | Unit [NAME] | 0 | Unit Cost | 0 | 0 | Unit Cost | 0 | 0 | hide
5 | Select Type | Select Type | # of Units | Unit [NAME] | 0 | Unit Cost | 0 | 0 | Unit Cost | 0 | 0 | hide
6 | Select Type | Select Type | # of Units | Unit [NAME] | 0 | Unit Cost | 0 | 0 | Unit Cost | 0 | 0 | hide
7 | Select Type | Select Type | # of Units | Unit [NAME] | 0 | Unit Cost | 0 | 0 | Unit Cost | 0 | 0 | hide
8 | Select Type | Select Type | # of Units | Unit [NAME] | 0 | Unit Cost | 0 | 0 | Unit Cost | 0 | 0 | hide
9 | Select Type | Select Type | # of Units | Unit [NAME] | 0 | Unit Cost | 0 | 0 | Unit Cost | 0 | 0 | hide
10 | Select Type | Select Type | # of Units | Unit [NAME] | 0 | Unit Cost | 0 | 0 | Unit Cost | 0 | 0 | hide
11 | Select Type | Select Type | # of Units | Unit [NAME] | 0 | Unit Cost | 0 | 0 | Unit Cost | 0 | 0 | hide
 |  |  |  | SF Total | 70000 |  | Total: | 8501000 |  | Total: | 15049000 | -
 |  |  |  | SF Remaining | 0 |  |  |  |  |  |  | -
Spreadsheet: 08453559-78fa-4519-a58d-fe57fafa857d
Sheet: Labor Rates

UOM | Category | Base Rate | Overtime Rate
HR | Technician Base Labor | 77.69 | 94.79
HR | Project Management | 88.69 | 108.21
HR | Engeering Design | 85.39 | 104.18
HR | Installers | 74.39 | 90.76
Spreadsheet: 756407d1637521935-dynamic-array-with-total-and-subtotals-filterxml-formula-with-total-and-subtotals-in-a-dynamic-array
Sheet: Totalização horizontal

 |  |  |  |  |  |  |  |  |  |  |  | 1 | 5 | 9 | 13
 |  | x> 0 ; x < 5 |  |  |  |  |  |  |  |  | 0 | 49 | 53 | 57 | 61
 |  | Condition |  | Matrix 5 x 4 |  |  |  |  |  |  | 0 | 65 | 69 | 73 | 77
 |  | 1 |  |  | 5 | 9 | 13 |  |  |  | Subtotal | 115 | 127 | 139 | 151
 |  | 0 |  | 17 | 21 | 25 | 29 |  |  |  | 0 | 17 | 21 | 25 | 29
 |  | 0 |  | 33 | 37 | 41 | 45 |  |  |  | 0 | 33 | 37 | 41 | 45
 |  | 1 |  | 49 | 53 | 57 | 61 |  |  |  | Subtotal | 50 | 58 | 66 | 74
 |  | 1 |  | 65 | 69 | 73 | 77 |  |  |  | Total | 165 | 185 | 205 | 225
 |  |  |  |  | 127 | 139 | 151
 |  |  |  |  | 58 | 66 | 74
 |  |  |  |  | 185 | 205 | 225
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <-- | Inicialization of the formula
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <-- | First subtotal part
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <-- | Second subtotal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <-- | Last grand totalization and closing of the FILTERXML function
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <-- | Number of lines and columns in the array managed by INDEX function
Spreadsheet: 123535d1317722114-recall-data-from-sheet1-to-sheet2-sample-1-
Sheet: SHOP ID

SHOP ID | Name
SH101 | ShopABC
SH102 | shopDFR
SH103 | shopFRE
SH104 | ShopRWW
SH105 | ShopRRE
SH106 | ShopPPQ
SH107 | ShopEWW
SH108 | ShopWEW
SH109 | ShopRER
SH110 | ShopFDD
SH111 | ShopRWP
SH112 | ShopEPW
Spreadsheet: 119434d1314384711-excel-2007-finding-a-value-based-on-4-criteria-example
Sheet: Sheet1

FAKE DATA SET
Username | Project ID | Phase ID | Date | Time
[NAME] | 123456 | B | 2011-01-01 00:00:00 | 6
[NAME] | 123457 | E | 2011-01-01 00:00:00 | 4
[NAME] | 123456 | C | 2011-03-01 00:00:00 | 8
[NAME] | 123456 | G | 2011-02-01 00:00:00 | 10
[NAME] | 123456 | H | 2011-03-01 00:00:00 | 8
[NAME] | 123457 | E | 2011-02-01 00:00:00 | 4
[NAME] | 123457 | A | 2011-02-01 00:00:00 | 2
[NAME] | 123456 | F | 2011-01-01 00:00:00 | 6
[NAME] | 123457 | B | 2011-03-01 00:00:00 | 8
[NAME] | 123456 | A | 2011-04-01 00:00:00 | 8
[NAME] | 123456 | F | 2011-05-01 00:00:00 | 8
INPUT |  |  |  | OUTPUT
Username | Project ID | Phase ID | Date | Time
[NAME] | 123457 | A | 2011-02-01 00:00:00 | 2
[NAME] | 123456 | B | 2011-01-01 00:00:00
[NAME] | 123457 | E | 2011-03-01 00:00:00
[NAME] |  | C | 2011-02-01 00:00:00
[NAME] |  | G | 2011-04-01 00:00:00
 |  | H | 2011-05-01 00:00:00
 |  | A
 |  | F
Spreadsheet: 861152d1709116420-add-up-specific-numbers-from-a-cell-sample-freight-data
Sheet: Sales Proposal Master

ID | Cargo Description | Weight (KG) | Volume (m3) | Chargeable Weight (KG CW)
1898382 | 1 PKG |  234 Kg | 0.811 m3 | 234 [NAME]252 Kg | 0.883 m3 | 252 Kg CW  | 1 PKG |  44 Kg | 0.164 m3 | 44 Kg CW
1898120 | 1 PKG |  297 Kg | 0.975 m3 | 297 Kg CW
1897910 | 1 PKG |  247 Kg | 0.6 m3 | 247 Kg CW
1895872 | 1 PKG |  238 Kg | 0.69 m3 | 238 [NAME] |  384 Kg | 1.123 m3 | 384 Kg CW
1891128 | 2 PLT |  400 Kg | 4.8 m3 | 0 Kg CW
1891528 | 1 PKG |  418 Kg | 0.509 m3 | 418 Kg CW  | 1 PKG |  799 Kg | 0.691 m3 | 799 Kg CW
1889744 | 2 PLT |  300 Kg | 3.84 m3 | 640 Kg CW
1889991 | 2 PLT |  1,300 Kg | 3.84 m3 | 0 Kg CW
1887574 | 1 PKG |  352 Kg | 1.123 m3 | 352 Kg CW  | 1 PKG |  [NAME] | 0.975 m3
1887624 | 1 PLT |  280 Kg | 2.4 m3 | 0 Kg CW