tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 6ff473a4-053a-4562-bd67-3c303a0baca2
Sheet: TF enrichment

 |  | Clover |  |  |  | Absolute TF site numbers
 | Enriched  [NAME] 2-fold in CYD-1/CDK-4 |  |  |  |  | Dataset | Promoters analyzed | E2F1 sites | E2F1 sites/promoter | EFL-1 sites | EFL-1 sites/promoter
 | Rank | TF | Raw-score | p-value |  | Enriched in CYD-1/CDK-4 | 378 | 1276 | 3.375661375661376 | 614 | 1.624338624338624
 | 1 | E2F1 | 306 | <0.001 |  | Enriched in CYE-1/CDK-2AF | 211 | 781 | 3.701421800947867 | 375 | 1.777251184834123
 | 2 | SPT23 | 279 | <0.001 |  | Enriched only in CYD-1/CDK-4 | 139 | 386 | 2.776978417266187 | 200 | 1.438848920863309
 | 3 | RSC3 | 259 | <0.001 |  | Whole genome | 18362 | 49126 | 2.675416621283085 | 18941 | 1.03153251279817
 | 4 | SUM1 | 234 | 0.033
 | 5 | EFL-1 | 222 | <0.001
 | Enriched  [NAME] 2-fold in CYE-1/CDK-2AF
 | Rank | TF | Raw-score | p-value
 | 1 | E2F1 | 231 | <0.001
 | 2 | RSC3 | 207 | <0.001
 | 3 | EFL-1 | 185 | <0.001
 | 4 | SPT23 | 157 | <0.001
 | 5 | SUM1 | 149 | <0.001
 | Enriched only in CYD-1/CDK-4, not in CYE-1/CDK-2AF
 | Rank | TF | Raw-score | p-value
 | 1 | CHA4 | 53 | <0.001
 | 2 | SUT1 | 47 | <0.001
 | 3 | E2F1 | 44 | 0.012
 | 4 | RSC3 | 41 | <0.001
 | 5 | btd | 38 | 0.003
 | 12 | EFL-1 | 24 | <0.001
 | Subset of 143 genes from both enriched >2-fold, 100 randomizations
 | TF | Average Raw-score |  | Average p-value
 | E2F1 | 167.32 ± 7.25 |  | <0.001
 | EFL-1 | 136.46 ± 10.78 |  | <0.001
Spreadsheet: 107424d1304599166-need-formula-for-a-macro-function-example
Sheet: 23

1590
Name | Amount
Name 2 | 133
Name 3 | 149
Name 3 | 196
Name 2 | 121
Name 3 | 170
Name 1 | 157
Name 2 | 112
Name 1 | 102
Name 1 | 123
Name 2 | 155
Name 3 | 181
Name 1 | 177
Name 2 | 108
Name 3 | 179
Name 1 | 175
Name 3 | 109
Name 2 | 190
Name 3 | 123
Name 1 | 180
Name 1 | 100
Name 1 | 137
Name 1 | 133
Name 2 | 189
Name 1 | 179
Name 1 | 127
Spreadsheet: tracy_geaccone__40248__C0366-111726
Sheet: Dept_100196

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
PARKING - Dept. 100196
January, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Requisitioner Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 111726
2001-01-19 00:00:00 | PAR01/01-57491 |  | [NAME],[NAME] | Green | 1 | 56.83 | /EACH | 56.83
 |  |  |  |  |  |  | Ticket Total |  | 56.83
 |  |  |  |  |  |  | Total for R/C: 111726 |  | 56.83
 |  |  |  |  |  |  | Total for Dept_100196 |  | 56.83
Spreadsheet: 152932d1335613003-countif-multiple-criteria-and-multiple-sheets-sample_1
Sheet: Sheet 5

Statement Number | Status | Business
1 | Active | Ebay
2 | Non Active | Unknown
3 | Non Active | Ebay
4 | Active | Amazon
5 | Active | Amazon
6 | Non Active | Ebay
7 | Non Active | Firefox
8 | Non Active | Google
9 | Active | Google
10 | Active | Google
11 | Active | Ebay
Spreadsheet: 689573d1596525459-shade-cells-in-staff-rota-if-staff-are-at-work-rota-copy-copy
Sheet: Rota

WEEK A |  |  |  |  |  |  |  |  | WEEK B
Name |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
Staff A | 7 | x | x | x | x | x | x | 11.15-6.45 | x | x | x | x | x | x | 11.15-6.45
Staff B | 13.5 | 9-4.15 | x | x | x | x | x | 11.30-6.45 | 9-4.15 | x | x | x | x | x | 11.30-6.45
Staff C | 37.5 | x | x | 8.15-4.45 | 8-4.30 | 10.15-6.45 | 8-4.30 | 8.15-4.45 | x | 10.15-6.45 | 8.15-4.45 | 8-4.30 | 10.15-6.45 | 8-4.30 | x
Staff D | 6 | 9-4.15 | x | x | x | x | x | x | 9-4.15 | x | x | x | x | x | x
Staff E | 37.5 | x | 8-5 | 8.30-5.30 | 9.45-6.45 | 8.15-5.15 | 8.30-5.30 | x | x | 8-5 | x | 9.45-6.45 | 8.15-5.15 | 9.45-6.45 | 8.15-5.15
Staff F | 30 | x | 11.30-6.45 | 9.45-5 | 8-3.15 | 10.30-5 | x | 8.15-4.45 | x | 11.30-6.45 | 11.30-6.45 | 8-3.15 | 10.30-5 | x | x
Staff G | 37.5 | x | 9-5.30 | 10.15-6.45 | 8.30-5 | 10.15-6.45 | 8-4.30 | x | x | 8-4.30 | 10.15-6.45 | x | 8.15-16.45 | 9-5.30 | 8.15-4.45
Staff H | 25 | x | 8-1.30 | 9-2.30 | x | 9.30-3.30 | 1.15-6.45 | 9-2 | x | 9-2.30 | 9.30-3.30 | 9-2 | 1.15-6.45 | 8-1.30 | x
Staff I | 20 | x | 3.45-6.45 | 8.15-1.45 | 3.45-6.45 | 8.15-12.15 | 9-2.30 | x | x | x | 8.15-12.45 | 2.45-6.45 | 9.30-2 | 10-2.30 | 9-1
Staff J | 24 | x | x | 9.45-6.45 | 9-6 | x | 9.45-6.45 | x | x | x | 9-6 | 9-6 | x | 9.45-6.45 | x
Staff K | 37.5 | x | 9.30-6 | 8.30-5 | x | 9-5.30 | 10.15-6.45 | 10.15-6.45 | 10-4.15 | x | 10.30-6.45 | 9-5.30 | 8.30-5 | 8-4.30 | x
 |  |  | 6 | 8 | 6 | 7 | 7 | 6 |  | 5 | 7 | 7 | 7 | 7 | 5
Spreadsheet: 699413d1602594053-vlookup-via-dropdown-from-second-sheet-sampledata2
Sheet: Sheet2

 | Examples | Duration | Cost | Deposit |  |  |  | Monthly Payment Period |  | Weekly Payment Period
 | Example 1 Weekly | 12 Months | 2000 | 100 |  |  |  | 2 Months | 2 | 4 Weeks | 4
 | Example 2 Weekly | 13 Months | 3000 | 100 |  |  |  | 3 Months | 3 | 6 Weeks | 6
 | Example 3 Monthly | 14 Months | 4000 | 100 |  |  |  | 4 Months | 4 | 8 Weeks | 8
 | Example 4 Monthly | 15 Months | 5000 | 100 |  |  |  | 5 Months | 5 | 10 Weeks | 10
 | Example 5 Monthly | 16 Months | 6000 | 100 |  |  |  | 6 Months | 6 | 12 Weeks | 12
 | Example 6 Monthly | 17 Months | 7000 | 100 |  |  |  | 7 Months | 7 | 14 Weeks | 14
 | Example 7 Monthly | 18 Months | 5000 | 100 |  |  |  | 8 Months | 8 | 16 Weeks | 16
 | Example 8 Monthly | 19 Months | 9000 | 100 |  |  |  | 9 Months | 9 | 18 Weeks | 18
 | Example 9 Monthly | 20 Months | 1000 | 100 |  |  |  | 10 Months | 10 | 20 Weeks | 20
 | Example 10 Monthly | 21 Months | 2500 | 500 |  |  |  | 11 Months | 11
 | Example 11 Monthly | 22 Months | 3500 | 100 |  |  |  | 12 Months | 12
 | Example 12 Monthly | 23 Months | 4750 | 100
Spreadsheet: 149059d1333666161-finding-second-to-minimum-number-in-array-tissue-culture-sal-1
Sheet: Sheet3

 | Culture Dishes
Vendor | 35mm |  |  | 60mm |  |  | 100mm |  |  | 150mm
 | Price | Dishes/cs | $/tube | Price | Dishes/cs | $/tube | Price | Dishes/cs | $/tube | Price | Dishes/cs | $/tube
Corning | 90.79 | 500 |  | 84.06 | 500 |  | 159.25 | 500 |  | 89.66 | 60
BD | 106 | 500 |  | 89 | 500 |  | 79.6 | 200 |  | 95.2 | 100
Denville | 74.99 | 500 |  | 74.99 | 500 |  | 69.99 | 300 |  | 69.99 | 100
?
 | Cell Culture Plates
 | 6 well |  |  | 12 well |  |  | 24 well |  |  | 96 well
 | Price | Plates/cs | $/plate | Price | Plates/cs | $/plate | Price | Plates/cs | $/plate | Price | Plates/cs | $/plate
Corning | 100.8 | 100 |  | 131.9 | 100 |  | 173.51 | 100 |  | 101.34 | 100
BD | 47.5 | 50 |  | 57 | 50 |  | 55 | 50 |  | 59.5 | 50
Denville | 46.99 | 50 |  | 53.99 | 50 |  | 49.99 | 50 |  | 89.99 | 100
?
 | Cell Culture Flasks
 | 25cm2 (Plug Cap) |  |  | 25cm2 ([NAME]) |  |  | 75cm2 (Plug Cap) |  |  | 75cm2 ([NAME]) |  |  | 175cm2 (Plug Cap) |  |  | 175cm2 ([NAME])
 | Price | Plates/cs | $/plate | Price | Plates/cs | $/plate | Price | Plates/cs | $/plate | Price | Plates/cs | $/plate | Price | Plates/cs | $/plate | Price | Plates/cs | $/plate
Corning | 206.5 | 500 |  | 121.54 | 200 |  | 82.12 | 100 |  | 102.58 | 100 |  | 80.07 | 50 |  | 87.43 | 50
BD | 76.8 | 200 |  | 79.6 | 200 |  | 83.6 | 100 |  | 86.4 | 100 |  | 62.64 | 40 |  | 68 | 40
Denville | 81.99 | 200 |  | 89.99 | 200 |  | 81.99 | 100 |  | 89.99 | 100 |  | 69.99 | 40 |  | 79.99 | 40
?
Spreadsheet: be4da6bb-b2ca-4730-b079-e5f77c6de701
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6819 | 8131 | Tiare | Lund | NZL | 2078 | 00:32:08 | 00:03:41 | 01:21:23 | 00:02:09 | 00:53:16 | 1 | 02:52:35
6819 | 52615 | Sue | [NAME] | USA | 2080 | 00:38:23 | 00:03:30 | 01:24:09 | 00:02:28 | 01:00:56 | 2 | 03:09:24
6819 | 8109 | [NAME] | Beecroft | COK | 2075 | 00:36:50 | [NAME] | 01:31:48 | 00:01:53 | 01:04:57 | 3 | 03:18:19
6819 | 7456 | Peggy | Crome | GBR | 2077 | 00:40:24 | 00:03:25 | 01:36:21 | 00:02:33 | 01:07:01 | 4 | 03:29:42
6819 | 29831 | Carole | [NAME] | USA | 2079 | 00:42:54 | 00:05:49 | 01:33:57 | 00:02:50 | 01:06:35 | 5 | 03:32:04
6819 | 52614 | Sandra | Abrams | GBR | 2076 | 00:44:08 | 00:04:08 | 01:41:23 | 00:02:05 | 01:03:51 | 6 | 03:35:35
Spreadsheet: 92315d1291912859-macro-to-sort-data-by-columns-excel-poly-orders
Sheet: Sheet1

Order Date | Order No. | Description | Due Date | Ack No | Machine | Date | Date Sent | [NAME] | Con No | Comments
2010-12-09 00:00:00 | 11145 | Poly Bags | wc 20/10/11 | 14637 | 90 | 2011-08-02 00:00:00 | 2010-12-17 00:00:00 | van | 555 | Order ok
2010-12-07 00:00:00 | 11444 | poly sheet | 2011-01-10 00:00:00 | 15678 | 80 | 2011-02-03 00:00:00 | 2010-12-18 00:00:00 | van | 898 | all ok
2010-11-04 00:00:00 | 15567 | bags | 2011-03-10 00:00:00 | 16789 | 40 | 2011-03-04 00:00:00 | 2011-11-16 00:00:00 | collect | 999 | ok
Spreadsheet: 168725d1342550983-lookup-values-between-two-files-view-items-by-ad-code-for-dm-multiple-keycodes
Sheet: View_Items_By_Ad_Code_for_DM___

ITEM_NO | INV_ID | SumOfORDER_QTY | Cost | Price
17893 | 17936 | 291
19330 | 17922 | 70
1296630 | 5513 | 25
12215 | 18519 | 22
19554 | 18489 | 14
11118 | 79 | 7
12215-10 | 18521 | 5
12215-20 | 18522 | 3
15788 | 3954 | 3
10924 | 19543 | 2
47894 | 19771 | 2
19836 | 18229 | 2
14255 | 3497 | 2
19105F | 19554 | 2
16789 | 7314 | 2
19285 | 17552 | 2
10659 | 10564 | 1
12922 | 11651 | 1
13129 | 14489 | 1
13041 | 715 | 1
47893 | 17938 | 1
23500 | 13842 | 1
19552 | 18487 | 1
19550 | 18485 | 1
19454 | 18538 | 1
18925 | 18496 | 1
1879OMSD-NO-BU | 11048 | 1
17808 | 17555 | 1
16789T4 | 19719 | 1
15872 | 19264 | 1
15345 | 16419 | 1
14102S | 12981 | 1
13992 | 8554 | 1
1921DMSD-DE-BU | 11206 | 1
13785 | 19178 | 1
12966 | 690 | 1
11127 | 82 | 1
11870 | 18213 | 1
11343-C | 18345 | 1
11013 | 44 | 1
11028 | 49 | 1
14650 | 3286
Spreadsheet: 214182d1360840228-lowest-code-first-followed-by-name-and-dollar-amount-example-1-
Sheet: Sheet1

Code | ADD_1 | ADD_2 | ADD_3 | Name | Amount |  |  | [NAME] |  |  |  |  | Min
1 |  |  |  | Tri. | 1000 |  | 1 |  |  |  |  | 1
1 |  |  |  | [NAME]. | 600 |  | 2 |  |  |  |  | 2
1 |  |  |  | [NAME]. | 250 |  | 3 |  |  |  |  | 3
1 |  |  |  | [NAME]. | 900 |  | 4 |  |  |  |  | 4
1 |  |  |  | Hector. | 150 |  | 5 |  |  |  |  | 5
1 |  |  |  | Nick. | 75 |  | 6 |  |  |  |  | 6
1 |  |  |  | [NAME]. | 850
2 |  |  |  | [NAME]. | 3000
2 |  |  |  | [NAME]. | 200
2 |  |  |  | [NAME]. | 450
2 |  |  |  | [NAME]. | 375
2 |  |  |  | [NAME]. | 225
3 |  |  |  | [NAME]. | 123
4 |  |  |  | Sue | 254
5 |  |  |  | [NAME] | 642
6 |  |  |  | [NAME] | 179
3 |  |  |  | [NAME] | 217
4 |  |  |  | Sylvie | 305
5 |  |  |  | [NAME] | 300
6 |  |  |  | [NAME] | 100
Spreadsheet: 793273d1661371690-if-cell-is-the-same-equal-adjacent-value-and-sort-alphabetically-in-one-cell-sample
Sheet: Sheet1

 |  | Desired Output
Apple | Promo 1 | Apple, [NAME], Pear
[NAME] | Promo 1 | Apple, [NAME], Pear
Pear | Promo 1 | Apple, [NAME], Pear
Orange | Promo 2 | Apple, Orange
Apple | Promo 2 | Apple, Orange
[NAME] | Promo 3 | Banana, Orange, Pear
Pear | Promo 3 | Banana, Orange, Pear
Orange | Promo 3 | Banana, Orange, Pear
Spreadsheet: 118145d1313492209-excel-formula-help-for-timesheets-timesheet-template
Sheet: Sheet1

20/06/2011 - 03/07/2011
Date | Start |  | Finish |  | Hours | SINGLE | Hours | Tea money | O/T 1.5 | Hours | O/T 2.0 | TOTAL $
2011-06-20 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-06-21 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-06-22 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-06-23 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-06-24 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-06-25 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-06-26 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-06-27 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-06-28 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-06-29 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-06-30 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-07-01 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-07-02 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-07-03 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | sub total | 0
 |  |  |  |  |  |  |  |  |  |  | total | 0
A1 enter date range and populate A3:A16
B3 specific start times and notes from drop downs (which I can do)
D3 range of finish times from drop downs ( also can do)
F1 calculate hours worked from selected times in B3 and [NAME], but F3 = 8 hours only. I would like to spread hours greater than 8 over H3 and K3, eg single hours = 8, o/t 1.5 upto and including 2 hours and anthing beyond 10 hours = o/t 2.0
I3 tea money is paid after 9 hours work, eg 8 hours in F3 and 1 hour in H3
Then all that’s left is to enter hourly wage into G3, J3, L3 and tea money amount in I3, then total all relevent cells for totals.
Spreadsheet: phillip_m_love__30146__200002_OA
Sheet: CE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  CENTRAL
 |  |  | Total |  | Reclasses |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 237 | 568.89
2 |  | Liquidations |  |  |  |  |  |  |  | 17400.02 |  |  |  |  |  |  |  | -130500
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -14221
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | -5000 | -13099.99 | 3006 | 7411.6
7 |  | Liquidations |  |  |  |  |  |  |  | -45531.36
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -167332 | -430210.57 |  |  | 16 | 41.14
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 167095 | 429601.25 |  |  | 13820 | 35531.22
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -17180 |  | -10 | -0.01
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1117 | 7271.67
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17180 | 44169.78 | 5010 | 12880.71 | -17959 | -46172.59
23 | Fuel: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 167332 | 430210.57 |  |  | -16 | -41.14
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.24 | -35715 | -386.56 | 14238 | -3243.85
25 |  | Demand |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1553.69 |  | -103.35
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  | 107880.96 |  |  |  |  |  | -209660 |  |  |  | 92974
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 778083d1650854326-compilation-of-work-shifts-with-monthly-updates-dynamic-calendar-shifts-eba
Sheet: mese

Anno | 2022 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sáb
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sáb
 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sáb
 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sáb
 |  | 3
 |  | 4
 |  | 5
Spreadsheet: 235760d1368589582-simple-data-extraction-size-help
Sheet: Sheet1

Name | Size
funclothing-504-Black-red flame print two-piece swimwear
funclothing-504-Black-red flame print two-piece swimwear - Large | Large
funclothing-504-Black-red flame print two-piece swimwear - Medium | Medium
funclothing-504-Black-red flame print two-piece swimwear - Small | Small
funclothing-570-blue checkered racing print two-piece swimwear
funclothing-570-blue checkered racing print two-piece swimwear - Large | Large
funclothing-570-blue checkered racing print two-piece swimwear - Medium | Medium
funclothing-570-blue checkered racing print two-piece swimwear - Small | Large
funclothing-570-pink checkered racing print two-piece swimwear
funclothing-570-pink checkered racing print two-piece swimwear - Large | Large
funclothing-570-pink checkered racing print two-piece swimwear - Medium | Medium
funclothing-570-pink checkered racing print two-piece swimwear - Small | Large
funclothing-570-red-Black checkered racing print two-piece swimwear
funclothing-570-red-Black checkered racing print two-piece swimwear - 1X | 1X
funclothing-570-red-Black checkered racing print two-piece swimwear - 2X | 2X
funclothing-570-red-Black checkered racing print two-piece swimwear - 3X | 3X
Spreadsheet: 220772d1363262708-if-function-lom3_daten_pfeiffer_gruppe3_v2
Sheet: C+C

Abkürzung | Bezeichnung | PLZ | Nördliche Breite | Östliche Länge
CCTR | C+C Pfeiffer Traun | 4050 | 48.2346627 | 14.2706716
CCWE | C+C Pfeiffer Wels | 4600 | 48.1609616 | 14.0456752
CCSA | C+C Pfeiffer Salzburg | 5020 | 47.8139547 | 12.9959709
CCSP | C+C [NAME] | 8724 | 47.202115 | 14.7849303
CCGR | C+C [NAME] | 8055 | 47.0146189 | 15.4091522
CCBR | C+C Pfeiffer Brunn | 2345 | 48.1057915 | 16.3109879
CCWN | C+C [NAME] | 1220 | 48.2578892 | 16.4729459
CCVI | C+C [NAME] | 9500 | 46.5904196 | 13.8384229
CCNB | C+C [NAME] | 8600 | 47.4076164 | 15.2758711
CCNF | C+C Nussbaumer Feldbach | 8330 | 46.9569042 | 15.889439
CCNG | C+C [NAME] | 8020 | 47.0738752 | 15.4227955
Spreadsheet: 68926d1269458084-negative-number-changes-result-comission-rate-check
Sheet: Sheet1

 |  | Dealer # | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD | <1000000 | >1000000 |  | Commission
[NAME] |  |  | 200000 | 250000 | 250000 | 250000 | 200000 | 200000 | 200000 | 876820 |  |  |  |  | 2426820 | 0.01 | 0.015 |  | 13152.3
 |  |  |  |  |  |  |  |  |  |  |  |  | 13152.3
Spreadsheet: c875e5b2-4848-4e89-9954-dbc6686c58d8
Sheet: Sheet1

参考表 ２ 　　総合，生鮮食品を除く総合，食料（酒類を除く）及びエネルギーを除く総合（全国） | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Reference Table 2 　 General, General excluding fresh food, General excluding food
(excluding alcoholic beverages) and energy for Japan
 |  |  |  |  |  |  | 平成12年＝100
 |  |  |  |  |  |  | 2000＝100
 |  |  |  |  | 食料（酒類を除く）及び
 | 総　　　合 |  | 生鮮食品を除く総合 |  | エネルギーを除く総合※
 |  |  |  |  | （試算値）
 | General |  | General, excluding fresh food |  | General, excluding food (excluding
 |  |  |  |  | alcoholic beverages) and energy |  | Year
年　月 |  |  |  |  | (tentative figures) |  | and
 |  |  |  |  |  |  | month
 | 指  数 | 前年同月比 | 指  数 | 前年同月比 | 指  数 | 前年同月比
 | Index | Change over | Index | Change over | Index | Change over
 |  | the year |  | the year |  | the year
 |  | （％） |  | （％） |  | （％）
[NAME] | 97.8 | -0.5 | 98.1 | -0.1 | 97.9 | -0.3 | Nov. 2003
12 | 97.9 | -0.4 | 98.2 | 0 | 97.9 | -0.4 | Dec.
平成16年 1月 | 97.7 | -0.3 | 97.5 | -0.1 | 97.1 | -0.5 | Jan. 2004
2 | 97.7 | 0 | 97.5 | 0 | 96.9 | -0.4 | Feb.
3 | 97.9 | -0.1 | 97.7 | -0.1 | 97.3 | -0.4 | Mar.
4 | 97.9 | -0.4 | 97.9 | -0.2 | 97.5 | -0.5 | Apr.
5 | 98 | -0.5 | 97.9 | -0.3 | 97.5 | -0.8 | May
6 | 98.2 | 0 | 98 | -0.1 | 97.5 | -0.6 | June
7 | 97.9 | -0.1 | 97.9 | -0.2 | 97.4 | -0.7 | July
8 | 98 | -0.2 | 98 | -0.2 | 97.6 | -0.7 | Aug.
9 | 98.3 | 0 | 98.2 | 0 | 97.6 | -0.6 | Sep.
10 | 98.8 | 0.5 | 98.2 | -0.1 | 97.7 | -0.6 | Oct.
11 | 98.6 | 0.8 | 97.9 | -0.2 | 97.3 | -0.6 | Nov.
12 | 98.1 | 0.2 | 98 | -0.2 | 97.3 | -0.6 | Dec.
平成17年 1月 | 97.6 | -0.1 | 97.2 | -0.3 | 96.4 | -0.7 | Jan. 2005
2 | 97.4 | -0.3 | 97.1 | -0.4 | 96.2 | -0.7 | Feb.
3 | 97.7 | -0.2 | 97.4 | -0.3 | 96.6 | -0.7 | Mar.
4 | 97.9 | 0 | 97.7 | -0.2 | 97 | -0.5 | Apr.
5 | 98.2 | 0.2 | 97.9 | 0 | 97.3 | -0.2 | May
6 | 97.7 | -0.5 | 97.8 | -0.2 | 97.1 | -0.4 | June
7 | 97.6 | -0.3 | 97.7 | -0.2 | 97 | -0.4 | July
8 | 97.7 | -0.3 | 97.9 | -0.1 | 97.1 | -0.5 | Aug.
9 | 98 | -0.3 | 98.1 | -0.1 | 97.4 | -0.2 | Sep.
10 | 98.1 | -0.7 | 98.2 | 0 | 97.4 | -0.3 | Oct.
11 | 97.8 | -0.8 | 98 | 0.1 | 97.1 | -0.2 | Nov.
※　総合から食料(酒類を除く)及びエネルギー(電気代，都市ガス代，プロパンガス，灯油，ガソリン(レギュラー)及びガソリン(プレミアム))を
除いて試算した。
The series are calculated tentatively by excluding food (excluding alcoholic beverages) and energy (“Electricity”,
“Gas, manufactured & piped”, “Liquefied propane”, “[NAME]”, “Gasoline (regular)”, “Gasoline (premium)”) from the general.
Spreadsheet: 829069d1683894268-return-values-from-table-rx-and-ry-from-table
Sheet: Hoja 1

a' (meter) | 10.5 | 10.5 | 9 | 9 | 12 | 12 | 10.5 | 10.5 | 9 | 9 | 9 | 9 | 7.5 | 7.5 | 6 | 6
b' (meter) | 15 | 15 | 15 | 15 | 12 | 12 | 12 | 12 | 12 | 12 | 9 | 9 | 7.5 | 7.5 | 6 | 6
 | Rx | Ry | Rx | Ry | Rx | Ry | Rx | Ry | Rx | Ry | Rx | Ry | Rx | Ry | Rx | Ry
Speed≤ 1,1m/s Up to 2000kg | 19,7 | 14,4 | 16,1 | 11,4 | 23,3 | 16,6 | 17,9 | 17,5 | 17,6 | 17,3 | 21,3 | 15 | 23,55 | 13,85 | 25,8 | 12,7
a=b/2 | 16,3 | 11,6 | 16,3 | 11,6 | 15,7 | 10,7 | 15,7 | 10,7 | 15,7 | 10,7 | 18,5 | 9,5 | 22,2 | 8,4 | 25,8 | 7,3
Speed≤ 1,1m/s 2000kg to 3000kg | 19.7 | 14.0 | ** | ** | ** | ** | 21.3 | 15.1 | – | – | 21.3 | 15.0 | ** | ** | 29.4 | 12.7
a=b/2 | 16.3 | 11.6 | ** | ** | ** | ** | 16.9 | 10.7 | – | – | 20.3 | 9.5 | ** | ** | 29.4 | 7.3
Speed≤ 1,67m/s 2501kg to 3000kg | * | * | 18.3 | 13.0 | ** | ** | ** | ** | 19.6 | 13.8 | 22.2 | 15.3 | 26.2 | 14.3 | ** | **
a=b/2 | * | * | 16.6 | 11.8 | ** | ** | ** | ** | 18.0 | 10.9 | 22.2 | 9.7 | 26.2 | 10.0 | ** | **
 | INPUTS |  |  |  |  | RESULTS
 | "a" | "b" | "speed" | "kg" |  | Rx | Ry
 | 10.6 | 11 | 0.9 | 1900 |  | 17.9 | 17.5
Spreadsheet: 708808d1608036456-extract-and-sum-numerical-values-using-string-matching-from-single-multi-value-cell-submission
Sheet: Sheet4

 |  |  |  | Case 1: 2 people 2 different tasks
Jake |  |  |  | 2675_Mechanism Drive_Guard Bottom_Fit _02
Liam |  |  |  | 2675_Mechanism Drive_Guard Bottom_Weld_04, 2675_Mechanism Drive_Guard Bottom_Fit _04
[NAME] |  |  |  | 2675_Mechanism Drive_Guard Bottom_Fit _05
1 | 2675 | Term | lenghth
1.1 | Mechanism Drive |  |  | With Index, [NAME] (doesn’t work) | With If
1.1.1 | Guard Bottom |  |  |  | if | if search
1.1.1.1 | Fit
1.1.1.2 | Weld
1.1.2 | Guard Top
1.1.2.1 | Fit
1.1.2.2 | Weld
 |  |  |  | do the index with match or if | This doesn’t work, need to sub if (string = string) to a search if (string = search string)
 |  | From Internet
 |  | THIS WILL WORK WITH OLD METHOD WITH MANY SEARCH FINDS
1.1 | Mechanism Drive
1.1.1 | Guard Bottom
1.1.1.1 | Jake
1.1.1.2 | [NAME]
1.1.1.3 | [NAME]
1.1.2 | Guard Top
1.1.3.1 | Jake
1.1.3.2 | [NAME]
1.1.3.3 | [NAME]
Spreadsheet: 100652d1298961124-list-of-duplicate-values-from-several-sheets-example
Sheet: Sheet2

 | SpriteName | COLOR | BASENAME
fx |  | 001 | glow
fx |  | 001 | foodbits
fx |  | 001 | star
fx |  | 001 | fire
fx |  | 002 | fire
Spreadsheet: 793303d1661407477-using-iferror-to-sort-data-into-groups-not-working-grouping-test-non-365-aligw
Sheet: Batching

No. per group | 30
A | B | C | D | E | F