tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 100559d1298909810-help-with-a-debit-credit-table-attachment
Sheet: Trees Within Site_NEW

TREE CREDIT TABLE
TREES WITHIN BUILDING SITE
TREE NO | DBH SIZE | TYPE | PROTECTED | TBR | Credit | Debit |  | TREE NO | DBH SIZE | TYPE | PROTECTED | TBR | Credit | Debit |  | TREE NO | DBH SIZE | TYPE | PROTECTED | TBR | Credit | Debit |  |  | tree value COL 1 | Tree Value Col 2 | Tree Value Col 3 | TREE Size Min | Credit | Protected
 | 14 |  | NO |  | 0 |  |  |  |  |  | NO |  | #N/A |  |  |  |  |  | NO |  | #N/A |  |  |  | 0 | #N/A | #N/A | 2 | 1 | NO | 17
 | 21 |  | YES |  | 8 |  |  |  |  |  | NO |  | #N/A |  |  |  |  |  | NO |  | #N/A |  |  |  | 8 | #N/A | #N/A | 4 | 2 | YES
 | 23 |  | YES |  | 8 |  |  |  |  |  | NO |  | #N/A |  |  |  |  |  | NO |  | #N/A |  |  |  | 8 | #N/A | #N/A | 7 | 4
 | 34 |  | YES |  | 16 |  |  |  |  |  | NO |  | #N/A |  |  |  |  |  | NO |  | #N/A |  |  |  | 16 | #N/A | #N/A | 13 | 6
 | 24 |  | YES |  | 8 |  |  |  |  |  | NO |  | #N/A |  |  |  |  |  | NO |  | #N/A |  |  |  | 8 | #N/A | #N/A | 19 | 8
 | 2 |  | NO |  | 0 |  |  |  |  |  | NO |  | #N/A |  |  |  |  |  | NO |  | #N/A |  |  |  | 0 | #N/A | #N/A | 25 | 10
 | 12 |  | NO |  | 0 |  |  |  |  |  | NO |  | #N/A |  |  |  |  |  | NO |  | #N/A |  |  |  | 0 | #N/A | #N/A | 31 | 16
 | 36 |  | YES |  | 16 |  |  |  |  |  | NO |  | #N/A |  |  |  |  |  | NO |  | #N/A |  |  |  | 16 | #N/A | #N/A | 37 | 20
 | 24 |  | YES |  | 8 |  |  |  |  |  | NO |  | #N/A |  |  |  |  |  | NO |  | #N/A |  |  |  | 8 | #N/A | #N/A | 43 | 24
 | 23 |  | YES |  | 8 |  |  |  |  |  | NO |  | #N/A |  |  |  |  |  | NO |  | #N/A |  |  |  | 8 | #N/A | #N/A | 49 | 28
 | 22 |  | YES |  | 8 |  |  |  |  |  | NO |  | #N/A |  |  |  |  |  | NO |  | #N/A |  |  |  | 8 | #N/A | #N/A | 61 | 40
 | 23 |  | YES |  | 8 | 0 |  |  |  |  | NO |  | #N/A |  |  |  |  |  | NO |  | #N/A |  |  |  | 8 | #N/A | #N/A
TOTAL |  |  |  |  | #N/A | #N/A |  |  |  |  |  |  | #N/A | #N/A |  |  |  |  |  |  | #N/A | #N/A |  |  | #N/A
TOTAL CREDITS
TOTAL DEBITS
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 24

CONSOLIDATED STATEMENT OF OPERATIONS | 4Q11 | 4Q10 | YTD 11 | YTD 10
R$ million
Net sales | 8378.441 | 7455.344000000002 | 27126.719 | 25233.31
Cost of sales | -2537.354 | -2452.421 | -8793.307 | -8449.047
Gross profit | 5841.087 | 5002.923000000003 | 18333.412 | 16784.263
Sales and marketing expenses | -1682.277 | -1670.487 | -6250.957 | -6038.544000000001
Administrative expenses | -369.943 | -260.624 | -1180.566 | -1196.95
Other operating income/(expenses) | 320.535 | 253.199 | 784.451 | 624.9300000000001
Normalized EBIT | 4109.402 | 3325.011000000003 | 11686.34 | 10173.699
Special items | -13.492 | -66.528 | 23.104 | -150.825
Income from operations (EBIT) | 4095.91 | 3258.483000000003 | 11709.444 | 10022.91
Net finance results | -90.959 | -75.398 | -468.1439999999999 | -319.4110000000001
Share of results of associates | 0.251 | 0.157 | 0.479 | 0.184
Profit before income tax | 4005.202 | 3183.242000000003 | 11241.779 | 9703.683
Income tax expense | -940.992 | -570.456 | -2521.995 | -2084.45
Profit | 3064.21 | 2612.786000000003 | 8719.784000000001 | 7619.243000000002
Attributable to: | 0 | 0 | 0 | 0
Equity holders of Ambev | 3032.492 | 2585.798000000003 | 8640.996000000003 | 7561.397000000003
Non-controlling interest | 31.718 | 26.988 | 78.788 | 57.846
Nº of basic shares outstanding | 3117.104333333334 | 3089.812 | 3111.378083333334 | 3092.496509166667
Nº of diluted shares outstanding | 3129.743333333333 | 3102.505 | 3123.968083333334 | 3102.505
Basic earnings per share (preferred) | 1.025194489800054 | 0.8839999999999999 | 2.926657762316509 | 2.58
Basic earnings per share (common) | 0.9319949907273216 | 0.7979999999999999 | 2.660597965742281 | 2.34
Diluted earnings per share (preferred) | 1.028832603198029 | 0.875 | 2.914230652681111 | 2.571
Diluted earnings per share (common) | 0.9189296214547621 | 0.795 | 2.649301141401966 | 2.331
Spreadsheet: 695093d1600049301-need-help-to-insert-a-value-after-multiple-occurrences-of-a-value-sample-1-
Sheet: Sheet1

 |  |  |  |  |  |  | Tq
 |  |  |  |  |  |  | DA
 |  |  |  |  |  |  | WA
 |  |  |  |  |  |  | CH
 |  |  |  |  |  |  | CH
 |  |  |  |  |  |  | KA
 |  |  |  |  |  |  | BA
 |  |  |  |  |  |  | ST
 |  |  |  |  |  |  | NW
 |  |  |  |  |  |  | NY
 |  |  |  |  |  |  | NY
 |  |  |  |  |  |  | NY
 |  |  |  |  |  |  | CA
 |  |  |  |  |  |  | NO
 |  |  |  |  |  |  | GN
 |  |  |  |  |  |  | OA
 |  |  |  |  |  |  | BU
 |  |  |  |  |  |  | IN
 |  |  |  |  |  | 2009.4.14 | CI
 |  |  |  |  |  | 2009.5.1 | CI
 |  |  |  |  |  | 2009.5.1 | CI
 |  |  |  |  |  |  | TE
 |  |  |  |  |  |  | AR
 |  |  |  |  |  |  | PH
 |  |  |  |  |  |  | AT
 |  |  |  |  |  |  | AT
 |  |  |  |  |  |  | MI
 |  |  |  |  |  |  | NY
 |  |  |  |  |  |  | TA
 |  |  |  |  |  |  | TA
 |  |  |  |  |  |  | DE
 |  |  |  |  |  |  | SE
 |  |  |  |  |  |  | JA
 |  |  |  |  |  |  | JA
 |  |  |  |  |  |  | SF
 |  |  |  |  |  |  | SF
 |  |  |  |  |  |  | CL
 |  |  |  |  |  |  | CL
 |  |  |  |  |  |  | PI
 |  |  |  |  |  |  | PI
 |  |  |  |  |  |  | PI
Spreadsheet: 812146d1672996025-extract-data-example-of-data-2-
Sheet: Weekly Data Pull

Product Name | Unit Cost | [NAME] | [NAME] | Revenue
TV | 11.53 | 1 | Online | 100
Camera | 1.02 | 15 | Instore | 23
Phone | 85.2 | 56 | In-Store | 1524
Computer | 1256 | 11 | Online | 10526
Tablet | 19.56 | 4 | Online | 952
Spreadsheet: lisa_gang__22279__ENA_PGE_APRIL_30_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 2002-04-30 00:00:00
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  | Total In To PGE Trans
0100 |  | 0 | 0 | 0
0200 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0
0700 | 125 | 25 | 25 | 25
0800 | 125 | 25 | 25 | 25
0900 | 125 | 25 | 25 | 25
1000 | 125 | 25 | 25 | 25
1100 | 125 | 25 | 25 | 25
1200 | 125 | 25 | 25 | 25
1300 | 125 | 25 | 25 | 25
1400 | 125 | 25 | 25 | 25
1500 | 125 | 25 | 25 | 25
1600 | 125 | 25 | 25 | 25
1700 | 125 | 25 | 25 | 25
1800 | 125 | 25 | 25 | 25
1900 | 125 | 25 | 25 | 25
2000 | 125 | 25 | 25 | 25
2100 | 125 | 25 | 25 | 25
2200 | 125 | 25 | 25 | 25
2300 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0
 | AVISTA(G)CHELAN | AVISTA(G)CHELAN | BPA(G) | EWEB(G)
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AVISTA(PSE) | AVISTA(PSE) | AVISTA(PSE) | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AVISTA(PSE) | AVISTA(PSE) | AVISTA(PSE) | AEP
 | PGE | TEMU | DUKE | PPM
 | MORGAN | SNCL | MORGAN | CDWR
 | APX | ISO(T)CPJK/SNCL SYS | MIRANT | ISO(T)MALIN/NP15
 | ISO(T)MALIN/NP15 | SNCL(L,FS)SYS | ISO(T)MALIN/NP15 | CERS(L,FS) SYS (CA)
 | APX(L,FS)NP15 (CA) |  | MIRANT(L,FS)NP15 (CA)
Spreadsheet: 815448d1674952632-dynamic-average-of-top-values-in-specific-ranges-test-sample
Sheet: Test

 | test
Date | test | test/Hr
2023-01-01 00:00:00
 | 138
 | 137
 | 72
 | 71
 | 64
 | 11
 | 29
 | 39
 | 71
 | 86
 | 36
 | 13
 | 1
 | 89
 | 107
 | 91
 | 20
 | 108
 | 130
 | 102
 | 78
 | 117
 | 102
 | 56
 | 84
 | 37
 | 65
 | 5
 | 78
 | 112
 | 114
 | 112
 | 95
 | 48
 | 15
 | 64
 | 72
 | 98
 | 104
 | 45
 | 2
 | 39
 | 114
 | 89
 | 60
 | 66
 | 94
 | 94
 | 76
 | 51
 | 103
 | 96
 | 81
 | 42
 | 110
 | 93
 | 43
 | 60
 | 74
 | 98
 | 106
 | 47
 | 120
 | 70
 | 103
 | 62
 | 42
 | 64
 | 76
 | 62
 | 126
 | 93
 | 75
 | 95
 | 51
 | 24
 | 72
 | 18
 | 57
 | 74
 | 86
 | 73
 | 31
 | 98
 | 103
 | 86
 | 55
 | 64
 | 4
 | 142
 | 132
 | 80
 | 102
 | 32
 | 1
 | 63
 | 106
 | 98
 | 75
 | 98
 | 118
 | 20
 | 129
 | 109
 | 124
 | 142
 | 95
 | 114
 | 81
 | 117
 | 109
 | 121
 | 78
 | 87
 | 149
 | 106
 | 116
 | 108
 | 60
 | 96
 | 96
 | 129
 | 164
 | 80
 | 56
 | 76
 | 155
 | 131
 | 94
 | 112
 | 74
 | 149
 | 63
 | 3
 | 69
 | 52
 | 61
 | 105
 | 155
 | 33
Spreadsheet: 707483d1607317712-power-query-power-pivot-conditional-column-creation-and-chart-conditional-column_previous-month-avg
Sheet: Sheet2

1.Question how to get the last 3 months average excluding the current month from the rate column with conditional column percentages in power query or power pivot |  |  | Fields need to be populated in the highlighted column below with a pivot table
Row Labels | Rate |  | last 3 months average excluding the current month | Conditional Column 1(green) if last 3 months average greater than or equal to current month or NA | Conditonal Column 2 (Yellow) if greater than or equal to 95 to 100% or NA | Conditional Column 3 (Red)=if last 3 months average is less than current month or NA
Oct-2019 | 0.9699999999999995 |  | % | % | % | %
[NAME] | 0.9800000000000003 |  | % | % | % | %
Dec-2019 | 0.9499999999999995 |  | % | % | % | %
Jan-2020 | 0.9499999999999995 |  | % | % | % | %
Feb-2020 | 0.6499999999999999 |  | % | % | % | %
Mar-2020 | 0.5 |  | % | % | % | %
Apr-2020 | 0.6999999999999996 |  | % | % | % | %
May-2020 | 0.6400000000000002 |  | % | % | % | %
Jun-2020 | 0.6499999999999999 |  | % | % | % | %
Jul-2020 | 0.8500000000000004 |  | % | % | % | %
Aug-2020 | 0.7600000000000005 |  | % | % | % | %
Sep-2020 | 0.7899999999999995 |  | % | % | % | %
Oct-2020 | 0.7199999999999999 |  | % | % | % | %
Spreadsheet: 143290d1330352211-extract-a-same-reference-list-sample_slp
Sheet: Sheet1

Reference | Amount | Date
AB4502 | 12000 | 2012-01-10 00:00:00
CE4467 | 9000 | 2012-02-10 00:00:00
NE1450 | 6500 | 2012-03-13 00:00:00
NE1450 | 7800 | 2012-04-18 00:00:00
AB4502 | 15000 | 2012-05-15 00:00:00
CE4467 | 8000 | 2012-06-13 00:00:00
CE4467 | 6000 | 2012-07-14 00:00:00
NE1450 | 4000 | 2012-07-14 00:00:00
CE4467 | 5000 | 2012-08-15 00:00:00
NE1450 | 14000 | 2012-09-16 00:00:00
AB4502 | 16000 | 2012-09-30 00:00:00
AB4502 | 3000 | 2012-12-25 00:00:00
What formula can I use to make a list of all the same reference rows by typing the reference in a cell and it will populate a list eg:
AB4502 |  |  | (Type Refence Here)
List all for AB
AB4502 | 12000 | 2012-01-10 00:00:00
AB4502 | 15000 | 2012-05-15 00:00:00
AB4502 | 16000 | 2012-09-30 00:00:00
AB4502 | 3000 | 2012-12-25 00:00:00
Spreadsheet: benjamin_rogers__1024__TLR Analysis
Sheet: Jun

 | TLR Max Level | Number of Incidents
 | 1 | 0
 | 2a | 12
 | 2b | 11
 | 2c | 0
 | 3 | 13
 | 4 | 0
 | 5 | 0
 | 6 | 0
 | Total
 | Curtailment | TLR level | MW Curtailed | Controller | Start Time | End Time | Total Time
1 | 1999-06-01 00:00:00 | 3 | 5 | MAIN | 08:05:00 | 18:14:00
1 | 1999-06-02 00:00:00 | 3 | 20 | MAIN | 07:01:00 | 13:57:00
1 | 1999-06-03 00:00:00 | 3 | 1121 | EES | 07:05:00 | 16:07:00
1 | 1999-06-07 00:00:00 | 3 | 100 | AEP | 09:59:00 | 23:23:00
1 | 1999-06-07 00:00:00 | 2b | 30 | MAIN | 06:05:00 | 23:30:00
1 | 1999-06-08 00:00:00 | 3 | 15 | MAIN | 07:42:00 | 22:32:00
1 | 1999-06-10 00:00:00 | 3 | 683 | IMO | 08:26:00 | 22:12:00
1 | 1999-06-21 00:00:00 | 3 | 25 | MAIN | 07:25:00 | 22:20:00
1 | 1999-06-22 00:00:00 | 3 | 17.5 | MAIN | 06:30:00 | 22:10:00
1 | 1999-06-25 00:00:00 | 3 | 611 | SPP | 13:05:00 | 19:18:00 | 15:22:00
Spreadsheet: 857548d1706548707-if-and-right-formula-example-file
Sheet: Sheet1

Pay Group | Worked Department | Location | Pay Level
LA3 | 170734 - LAX Taxi/TNC - Hourly Billing (R08) | 100122
LA3 | 170728 - Beverly Hilton - Fees | 100122
LA3 | 170895 - Century Plaza - Fairmont Hotel (R11) | 100122
@9T | 100122 - Data Entry | 100122
@9T | 100122 - Enforcement | 100122
CTO | 100122 - Enforcement | 100122
PA9 | 100122 - Enforcement | 100122
SOW | 140455 - Del Mar Plaza | 100122
SOW | 140112 - 714 E. San Ysidro Blvd (RSD)
Spreadsheet: 328522d1403933034-matching-the-values-between-two-columns-match_values-1-ans
Sheet: Sheet1

Column 1 | Column 2 | All Matching values | Non Matching values From A & B Columns
1112333 | 1111111
1121233 | 1111333
1121333 | 1112333
1122333 | 1113333
1123333 | 1122311
1133333 | 1123333
1232333 | 1133333
1233333 | 1232121
1333111 | 1232311
1333211 | 1233321
1333311 | 1233333
1333331 | 1333211
1333332 | 1333311
1333333 | 1333321
2111333 | 1333331
2112333 | 1333332
2113333 | 1333333
2122333 | 2111211
2123333 | 2111223
2212121 | 2111333
2212123 | 2112311
2212221 | 2112322
2212233 | 2112333
2212333 | 2113333
2213333 | 2121323
2222121 | 2122311
2222123 | 2122333
2222133 | 2123311
2222221 | 2123333
2222223 | 2212111
2222233 | 2212123
2222333 | 2212133
2223332 | 2212211
2223333 | 2212221
2232111 | 2212223
2232211 | 2212233
2232333 | 2212321
2233331 | 2212333
2233333 | 2213333
2323111 | 2222111
2323331 | 2222211
2323333 | 2222221
2332111 | 2222311
2332211 | 2222321
2333211 | 2223311
2333221 | 2223331
2333231 | 2223333
2333233 | 2232111
2333311 | 2232121
2333321 | 2232123
2333331 | 2233311
2333332 | 2233321
2333333 | 2233333
3111211 | 2322121
3111233 | 2322221
3111311 | 2323133
3111323 | 2323231
3111333 | 2323233
3113333 | 2323321
3212121 | 2323333
3212123 | 2332111
3212133 | 2332121
3212211 | 2332221
3212221 | 2333111
3212223 | 2333121
3212233 | 2333211
3212311 | 2333221
3212321 | 2333231
3212333 | 2333232
3213333 | 2333233
3222233 | 2333311
3223333 | 2333321
3312111 | 2333331
3312233 | 2333332
3313331 | 2333333
3313333 | 3111333
3322121 | 3112333
3322221 | 3113333
3322233 | 3211233
3323111 | 3212121
3323121 | 3212123
3323133 | 3212133
3323221 | 3212223
3323231 | 3212233
3323233 | 3212321
3323321 | 3212322
3323331 | 3212333
3323332 | 3213321
3323333 | 3213333
3332121 | 3222133
3332133 | 3222221
3332221 | 3222233
3333111 | 3223333
3333121 | 3312111
3333132 | 3312121
3333133 | 3312221
3333211 | 3312233
3333221 | 3313321
3333231 | 3313331
3333233 | 3313333
3333311 | 3322111
3333321 | 3322121
3333331 | 3322122
3333332 | 3322133
3333333 | 3322211
 | 3322233
 | 3323133
 | 3323211
 | 3323221
 | 3323231
 | 3323233
 | 3323311
 | 3323321
 | 3323331
 | 3323332
 | 3323333
 | 3332211
 | 3332221
 | 3332233
 | 3333111
 | 3333121
 | 3333211
 | 3333221
 | 3333231
 | 3333232
 | 3333233
 | 3333311
 | 3333321
 | 3333331
 | 3333332
 | 3333333
Spreadsheet: 493a73fb-9b9b-4aa3-ad05-ff492f9d523c
Sheet: Equipment Request 1 

SFA ID# | SFA Name | Equipment Approval Request: Complete all sections and send to [EMAIL] ; Multiple requests may be included on one page. |  |  |  |  |  |  |  |  |  |  |  | CDE USE
School Site # | School Name | Equipment | Expected Cost/Quote | Spec attached? | # of quotes obtained | Replacement  (Yes or No) | Funding Source | Date Received | Purpose (if not replacement) | Planned Installation Date | Date Submitted | Submitted by | Notes | Approved Date | Approved by | Notes
Spreadsheet: 769954d1645730689-developing-conditional-running-totals-sample_workbook
Sheet: Sheet1

 | Sample Data
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | <- Attempts/Trials
Test1 | 1 | 1 | 1
Test2 |  | 1 | 1
Test3 |  |  |  |  | 1 | 1
Test4 |  |  |  |  |  | 1 | 1 | 1 | 1
2 in a row
All
 | Desired Solution
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | <- Attempts/Trials
Apple | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 1
Orange |  | 1 | 1 |  |  |  |  |  |  |  |  | 1
Pineapple | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Mango |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Blueberry |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Score1 | 3 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
Score2 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 6
Score1: Any word recorded starting with 2 consecutive scores across 12 trials; this is cumulative
Score2: Any word remembered consecutively across 12 trials
Detailed Explanation
Score1
Cell B25 calculates a score of 3 because the student recalled Apple, Pineapple, and [NAME] twice in row (across Trials 1 and 2)
Cell C25 calculates a score of 5 because the student now recalled Orange and Blueberry across Trials 2 and 3. The two in a row rule is a running total, so Apple, Pineapple, and [NAME] from Trials 1 and 2 get added to to the total in C25
Score2
Cell B26 calculates a score of 2 because Pineapple and [NAME] were recalled from Trial 1 to Trial 12
Cell C26 calculates a score of 3 because the student has now recalled Blueberry across all trials (now from Trial 2 to Trial 12), in addition to Pinapple and [NAME] being recalled between Trials 1 and 12
Spreadsheet: 0101610e-c42c-4579-9155-2d7a13cff6ed
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
3944 | 12442 | [NAME] | Peck | GBR | 835 | 00:56:47 | 00:02:02 | 01:31:41 | 00:03:10 | [NAME] | 1 | 03:04:56
3944 | 13354 | [NAME] | [NAME] | GBR | 834 | 01:04:36 | 00:02:09 | 01:30:09 | 00:02:20 | 00:31:06 | 2 | 03:10:22
3944 | 26152 | Ray | [NAME] | NZL | 836 | 01:07:46 | 00:02:18 | 01:33:21 | 00:01:55 | 00:35:32 | 3 | 03:20:54
3944 | 14124 | [NAME] | D'Erbee | BEL | 831 | 01:00:51 | 00:11:56 | [NAME] | 00:01:58 | 00:31:36 | 4 | 03:45:04
Spreadsheet: 686671d1594744886-sumifs-by-month-and-year-newworkbookname
Sheet: Sheet1

EST Close Date | AMOUNT |  |  | 2020
2017-10-16 00:00:00 | 180000 |  | January
2017-10-17 00:00:00 | 238000
2017-10-31 00:00:00 | 311250
2017-12-26 00:00:00 | 360000
2018-01-26 00:00:00 | 251250
2018-01-29 00:00:00 | 365735
2018-05-07 00:00:00 | 313625
2018-07-26 00:00:00 | 205000
2018-07-26 00:00:00 | 410125
2018-08-06 00:00:00 | 412153
2018-09-04 00:00:00 | 240000
2018-10-09 00:00:00 | 297220
2018-10-09 00:00:00 | 333000
2018-10-16 00:00:00 | 309765
2018-10-23 00:00:00 | 240000
2018-10-30 00:00:00 | 300000
2018-12-18 00:00:00 | 230000
2018-12-31 00:00:00 | 414950
2019-01-17 00:00:00 | 210680
2019-03-21 00:00:00 | 378000
2019-03-22 00:00:00 | 290000
2019-04-29 00:00:00 | 273000
2019-06-03 00:00:00 | 306000
2019-06-11 00:00:00 | 255000
2019-06-11 00:00:00 | 415850
2019-07-05 00:00:00 | 416100
2019-07-22 00:00:00 | 233750
2019-08-26 00:00:00 | 361517
2019-08-30 00:00:00 | 425000
2019-08-31 00:00:00 | 272000
2019-09-23 00:00:00 | 252000
2019-10-31 00:00:00 | 255000
2019-12-08 00:00:00 | 420000
2020-01-06 00:00:00 | 266260.5
2020-01-07 00:00:00 | 277000
2020-04-21 00:00:00 | 340826
2020-04-23 00:00:00 | 650000
2020-04-24 00:00:00 | 667814.76
2020-04-27 00:00:00 | 435870
2020-04-30 00:00:00 | 501549.34
2020-04-30 00:00:00 | 742750
2020-06-07 00:00:00 | 343500
2020-06-23 00:00:00 | 397000
2020-07-14 00:00:00 | 380000
2020-07-17 00:00:00 | 174740
2020-07-17 00:00:00 | 260000
2020-07-17 00:00:00 | 291000
2020-07-17 00:00:00 | 412000
2020-07-17 00:00:00 | 440000
2020-07-24 00:00:00 | 332000
2020-07-31 00:00:00 | 540000
2020-08-05 00:00:00 | 305500
2020-08-06 00:00:00 | 225000
2020-08-15 00:00:00 | 695382.5
2020-08-16 00:00:00 | 417000
2020-08-30 00:00:00 | 135000
2020-08-30 00:00:00 | 680000
2020-09-03 00:00:00 | 312085
2020-10-08 00:00:00 | 426000
 | 65162.5
 | 100000
 | 100000
 | 105000
 | 185000
 | 191000
 | 197395
 | 203080
 | 226100
 | 240014
 | 252000
 | 254750
 | 260000
 | 260000
 | 260000
 | 260000
 | 264127.7375
 | 273095
 | 275000
 | 279537.5
 | 281801.14
 | 284000
 | 284620
 | 290014
 | 291442.86
 | 291442.86
 | 291442.86
 | 294750
 | 295000
 | 295000
 | 302974.1
 | 304486.875
 | 329000
 | 338000
 | 338318.75
 | 340000
 | 341100
 | 345404
 | 345950
 | 346442.86
 | 349365.62
 | 350000
 | 352939.2075
 | 354642.82
 | 356000
 | 356000
 | 356650
 | 361617.66
 | 362000
 | 363000
 | 364750
 | 364943.04165
 | 367580
 | 368207.8125
 | 368207.8125
 | 370452
 | 380000
 | 383025.76
 | 386270
 | 390000
 | 393000
 | 400000
 | 400000
 | 407000
 | 407000
 | 408405
 | 408405
 | 417000
 | 417000
 | 434551.14
 | 483312.5
 | 495000
 | 495000
 | 521000
 | 531000
 | 532174
 | 536000
 | 536000
 | 536000
 | 536000
 | 536000
 | 551900
 | 558352
 | 560000
 | 580000
 | 592250
 | 592250
 | 606550
 | 609900
 | 609900
 | 613679.6875
 | 638226.875
 | 645192
 | 654864.76
 | 695868.75
Spreadsheet: 675074d1588151435-holidays-over-midnight-holidays_3
Sheet: Sheet1

 |  | Total hours:
 |  |  | weekdays |  |  |  | weekend hours |  |  | Holidays hours
 |  |  | 22:00:00 | 17:00:00 | 06:00:00 |  | Tot hours Saturday + Tot hours Sunday | Tot hours Holiday |  |  | 2020-01-01 00:00:00
 |  |  | 06:00:00 | 22:00:00 | 08:30:00 |  |  |  |  |  | 2020-01-06 00:00:00
 | start date&time | end date&time |  |  |  |  |  |  |  |  | 2020-04-10 00:00:00
 | 2020-01-01 22:00:00 | 2020-01-02 16:00:00 |  |  |  |  |  |  |  |  | 2020-04-13 00:00:00
 | 2020-01-02 22:00:00 | 2020-01-03 04:00:00 |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00
 | 2020-01-03 20:00:00 | 2020-01-03 21:00:00 |  |  |  |  |  |  |  |  | 2020-06-21 00:00:00
 | 2020-01-06 09:00:00 | 2020-01-07 18:00:00 |  |  |  |  |  |  |  |  | 2020-06-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2020-06-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2020-10-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2020-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2020-12-26 00:00:00
Spreadsheet: 149357d1333877031-help-with-pivot-tables-example-7-
Sheet: Sheet4

Row Labels | Sum of Supp | Sum of App | Sum of %
Leeds | 20 | 163 | 0.1226993865030675
Liverpool | 19 | 189 | 0.1005291005291005
London | 32 | 250 | 0.128
[NAME] | 15 | 176 | 0.08522727272727272
Grand Total | 86 | 778 | 0.4364557597594407
Spreadsheet: 112610d1308682752-index-match-combination-for-two-variables-indexmatch
Sheet: Sheet1

D
DOG |  | cow | pig | dog
 | a | 2 | 4 | 6
 | b | 66 | 55 | 44
 | c | 23 | 32 | 79
 | d | 11 | 14 | 111
 | e | 3 | 4 | 5
 |  | 111
Spreadsheet: 746371d1630666721-get-best-match-for-a-description-where-is-doesnt-exactly-match-best-match
Sheet: Sheet1

List A |  |  |  | List B
Code | Description |  |  | Description
ITM001 | Copper Tube Terminal 10mm M10 |  |  | CT6M8 Crimp-Pak Copper Tube Terminal
ITM002 | Copper Tube Terminal 10mm M12 |  |  | CT10M6 Crimp-Pak Copper Tube Terminal
ITM003 | Copper Tube Terminal 10mm M5 |  |  | CT10M8 Crimp-Pak Copper Tube Terminal
ITM004 | Copper Tube Terminal 10mm M6 |  |  | CT10M10 Crimp-Pak Copper Tube Terminal
ITM005 | Copper Tube Terminal 10mm M8 |  |  | CT16M6 Crimp-Pak Copper Tube Terminal
ITM006 | Copper Tube Terminal 16mm M10 |  |  | CT16M8 Crimp-Pak Copper Tube Terminal
ITM007 | Copper Tube Terminal 16mm M12 |  |  | CT16M10 Crimp-Pak Copper Tube Terminal
ITM008 | Copper Tube Terminal 16mm M14 |  |  | CT25M6 Crimp-Pak Copper Tube Terminal
ITM009 | Copper Tube Terminal 16mm M16 |  |  | CT25M8 Crimp-Pak Copper Tube Terminal
ITM010 | Copper Tube Terminal 16mm M20 |  |  | [NAME]
ITM011 | Copper Tube Terminal 16mm M8 |  |  | CT25M12 Crimp-Pak Copper Tube Terminal
 |  |  |  | CT35M6 Crimp-Pak Copper Tube Terminal
 |  |  |  | CT35M8 Crimp-Pak Copper Tube Terminal
 |  |  |  | CT35M10 Crimp-Pak Copper Tube Terminal
Spreadsheet: 50973d1250585596-hyperlink-function-help-excel
Sheet: RAPS

PRODUCT DEVELOPMENT INGREDIENT DATABASE
SUPPLIER | [NAME] | WEIGHT | QUANTITY | NO. | CODE | ALLERGEN | DATE IN | DATE OUT | F.A.O. | [NAME]
RAPS | AUTHENTIC PEPPERONI | 1KG | 2 | 59 | 1846UK |  | 2008-05-28 00:00:00 | 2009-04-01 00:00:00 | CH | LAB
RAPS | ACCELERATED PEPPERONI | 1KG | 2 | 60 | 01850KAN |  | 2008-05-28 00:00:00 | 2009-04-01 00:00:00 | CH | LAB
RAPS | [NAME] | 1KG | 2 | 61 | 4060D |  | 2008-05-28 00:00:00 | 2009-04-01 00:00:00 | CH | LAB
RAPS | SUPERQUICK GOLD | 1KG | 2 | 62 | _00100 |  | 2008-05-28 00:00:00 | 2009-04-01 00:00:00 | CH | LAB
RAPS | BUTTER BASTE INJECTION | 2KG | 1 | 63 | 77622/01 |  | 2009-03-27 00:00:00 | 2009-09-01 00:00:00 | GS | C/LAB
RAPS | CLIVIA - BOURBON & VANILLA | 1KG | 1 | 64 | 01154d |  | 2009-04-16 00:00:00 | 2010-06-01 00:00:00 | PH | LAB
RAPS | FETTFAX TOP - EMULSIFER FOR PATE | 1KG | 1 | 65 | 00757 |  | 2009-04-16 00:00:00 | 2010-01-01 00:00:00 | PH | LAB
RAPS | TOASTED ONIONS | 1KG | 1 | 66 | 00874 |  | 2009-04-16 00:00:00 | 2009-07-01 00:00:00 | PH | LAB
RAPS | COLO FIX | 1KG | 1 | 67 | 00785 |  | 2009-04-16 00:00:00 | 2009-07-01 00:00:00 | PH | LAB
RAPS | ALPINI SALTLESS SEASONING | 1KG | 1 | 68 | 00257 |  | 2009-04-16 00:00:00 | 2010-08-01 00:00:00 | PH | LAB
RAPS | APPLE GRANULES | 1KG | 1 | 69 | 00891 |  | 2009-04-16 00:00:00 | 2010-01-01 00:00:00 | PH | LAB