tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 3095224b-dd75-4d25-9727-63fb36d5e550
Sheet: Sheet1

High scoring CNC pairs | Unnamed: 1
target gene | microRNA
ACTR2 | hsa-let-7c
ABCA1 | hsa-miR-183
ABCB9 | hsa-let-7d
ABCD1 | hsa-miR-9
ADCY6 | hsa-miR-19b
ADCY6 | hsa-miR-19a
[NAME] | hsa-miR-96
AMFR | hsa-miR-96
APOD | hsa-miR-15b
ARID3B | hsa-let-7c
ATXN1 | hsa-miR-15b
BACE1 | hsa-miR-425
BATF | hsa-miR-99a
BCL6 | hsa-miR-183
BICD2 | hsa-miR-199a
C1QB | hsa-miR-15a
CIB2 | hsa-miR-134
CLU | hsa-miR-19b
[NAME] | hsa-miR-218
CPD | hsa-miR-181a
CSE1L | hsa-miR-29c
CSF1 | hsa-miR-19a
CTDSP1 | hsa-miR-124
CTSO | hsa-miR-18a
DNAJB9 | hsa-miR-93
EDEM1 | hsa-miR-125b
EDEM1 | hsa-miR-23b
EDEM1 | hsa-miR-125a
EDEM1 | hsa-miR-124
EDG2 | hsa-miR-25
EIF2S3 | hsa-miR-125b
ELF3 | hsa-miR-9
EPS8 | hsa-miR-181a
ESRRA | hsa-miR-214
EZH1 | hsa-miR-34a
F3 | hsa-miR-19a
FAM50A | hsa-miR-145
FAM8A1 | hsa-let-7f
FBXW2 | hsa-miR-125b
FHL1 | hsa-miR-425
FLT1 | hsa-miR-130b
FLT1 | hsa-miR-20a
GFER | hsa-miR-143
GUCY1A3 | hsa-miR-106b
HCLS1 | hsa-miR-27b
HIPK1 | hsa-miR-28
HLA-DOA | hsa-miR-134
HLF | hsa-miR-19a
HLF | hsa-miR-21
HLF | hsa-miR-20a
HMGCL | hsa-miR-744
HSD17B4 | hsa-miR-196a
[NAME] | hsa-miR-144
HSPA8 | hsa-miR-144
IDE | hsa-miR-93
IGF1 | hsa-miR-19a
IGF1 | hsa-miR-186
IKBKG | hsa-miR-34a
ILVBL | hsa-miR-708
IQGAP1 | hsa-miR-124
IRF2 | hsa-miR-93
IRF4 | hsa-miR-124
ITGB7 | hsa-let-7c
KIAA0415 | hsa-miR-145
KIAA0415 | hsa-miR-199a
LCP1 | hsa-miR-93
LRRFIP1 | hsa-miR-124
LRRFIP1 | hsa-let-7e
LRRFIP1 | hsa-let-7c
LRRFIP1 | hsa-miR-9
LYPLA2 | hsa-miR-27b
MAPK14 | hsa-miR-124
MCL1 | hsa-miR-125a
MECP2 | hsa-miR-99a
MET | hsa-miR-106b
MLYCD | hsa-miR-19b
MYH9 | hsa-miR-124
NCALD | hsa-miR-19b
NCALD | hsa-miR-19a
NDRG1 | hsa-miR-20a
NFATC1 | hsa-miR-99a
NFIB | hsa-miR-32
NFIB | hsa-miR-186
NFYC | hsa-miR-122
NMT1 | hsa-miR-125b
NR3C1 | hsa-miR-377
OLFM1 | hsa-miR-19b
PAFAH1B1 | hsa-miR-96
PAFAH1B1 | hsa-miR-25
PAFAH1B1 | hsa-miR-32
PAFAH1B1 | hsa-miR-106b
PARP3 | hsa-miR-134
PIK3R1 | hsa-miR-182
PLCL2 | hsa-miR-130a
[NAME] | hsa-miR-214
PLEK | hsa-miR-196a
PLLP | hsa-miR-21
PPM1B | hsa-miR-32
PPP1R3C | hsa-miR-19b
PPP1R3C | hsa-miR-19a
PPP2CA | hsa-miR-125b
PRSS23 | hsa-miR-19a
PSMC4 | hsa-miR-125b
PTPN18 | hsa-miR-9
PTPRE | hsa-miR-93
PTRF | hsa-miR-210
RAB11FIP2 | hsa-miR-155
RAC1 | hsa-miR-130a
RELA | hsa-miR-124
RGS10 | hsa-miR-22
RGS10 | hsa-miR-379
RNF141 | hsa-miR-218
RPIA | hsa-miR-124
RPP21 | hsa-miR-125b
SCAMP1 | hsa-miR-19b
SCAMP2 | hsa-miR-124
SEL1L | hsa-miR-181a
SEMA6A | hsa-let-7f
SEPT8 | hsa-let-7g
SESN1 | hsa-miR-183
SIGIRR | hsa-miR-125b
SLC25A4 | hsa-let-7c
SLC35E1 | hsa-miR-10a
SLC4A4 | hsa-miR-15b
SLC4A4 | hsa-miR-15a
SPARCL1 | hsa-miR-130b
SRI | hsa-miR-20a
SSH3 | hsa-miR-15a
TAPBPL | hsa-miR-9
TGFBRAP1 | hsa-miR-136
TGFBRAP1 | hsa-miR-379
TIA1 | hsa-miR-23a
TIMM17B | hsa-miR-125b
TNC | hsa-miR-425
TOM1L2 | hsa-miR-34a
TRIM2 | hsa-miR-21
TRIM2 | hsa-miR-19b
TSTA3 | hsa-miR-125b
[NAME] | hsa-miR-20a
[NAME] | hsa-miR-130b
UBL3 | hsa-miR-19b
UBN1 | hsa-miR-381
USP33 | hsa-miR-378
VAV3 | hsa-miR-9
Spreadsheet: 65950d1266576356-lookup-formula-demo-v2
Sheet: GHNO3

 | Name | Birthday |  |  | Address | phone | Start date
 |  |  |  |  | Job | Cell | Quit Date
Jan | MrZ | 1976 | Jan | 12 | Don't know street | 55223222 | 2007-03-02 00:00:00
Jan |  |  |  |  | Secretary | 905555221
Mar | MrX | 1978 | Mar | 23 | Have not a clue Rd | 22555 | 2008-04-06 00:00:00
Mar |  |  |  |  | Manager | 905555221
Apr | MrT | 1979 | Apr | 24 | Wouldn't know how to to get there Street | 552222552 | 2010-01-02 00:00:00
Apr |  |  |  |  | sales clerk | 905555221
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Spreadsheet: 95561d1295141766-formula-total-up-the-percentage-regectiongivenpercent
Sheet: Sheet1

 | Output | Rejection | Rejection % |  | % Calc | [NAME]
 | 1000 | 211 | 0.21
 | 2040 | 11 | 0.01
 | 2545 | 487 | 0.19
 |  |  | 0.13
 | if I don't have the rejection value that was marked with yellow color, what formula
 | can get the 13% rejection ?
 | The calculation of the Regection number is rounded because the % number is rounded
 | The % Calc colum is formatted as Percent with zero digits.
Spreadsheet: 59175d1259654899-summing-across-multiple-sheets-summary-report
Sheet: Aug-09

 | Trip details
Name | From | To | Number Of Days | Destination | Total ammount | reason of trip
[NAME] | 2009-08-04 00:00:00 | 2009-08-08 00:00:00 | 5 | Amman | 0
[NAME] | 2009-08-05 00:00:00 | 2009-08-08 00:00:00 | 5 | Amman | 0
[NAME] | 2009-08-16 00:00:00 | 2009-08-17 00:00:00 | 2 | Riyadh | 132.093
[NAME] | 2009-08-19 00:00:00 | 2009-08-20 00:00:00 | 2 | Dubai | 15.67
[NAME] | 2009-08-19 00:00:00 | 2009-08-20 00:00:00 | 2 | Dubai | 41.3
[NAME] | 2009-08-26 00:00:00 | 2009-08-27 00:00:00 | 2 | Dubai | 120.083
Mohd Shakeel | 2009-08-28 00:00:00 | 2009-09-05 00:00:00 | 9 | Iraq | 574.02
[NAME] | 2009-08-26 00:00:00 | 2009-08-27 00:00:00 | 2 | Dubai | 6.4
 | Total Days |  | 29 |  | 889.5659999999999
 |  | Saving |  | #N/A
Spreadsheet: 862060d1709839409-inserting-lines-and-counting-the-last-or-add
Sheet: Planilha1

 | Take the last | Add 1 to last
12345
24586
54355
15483
12345-1
12345-2
24586-1
24586-2
24586-3
24586-4
54355-1
15483-1
15483-2
15483-3
Spreadsheet: 683513d1592804274-adding-indirect-function-to-an-existing-if-statement-sample-file_indirect-lookup
Sheet: Injury Status

3
Spreadsheet: mark_taylor__24991__Week 4 Results
Sheet: Sheet1

College Football Pool
2001-2002
 | Name | Paid | Wk 1 | Wk 2 | Wk 4 | Wk 5 | Wk 6 | Wk 7 | Wk 8 | Wk 9 | Wk 10 | Wk 11 | Wk 12 | Wk 13 | Wk 14 | Cumulative
1 | [NAME] | x | 15 | 15 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 43
2 | [NAME] | x | 15 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35
3 | [NAME] | x | 12 | 13 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 31
4 | [NAME] | x | 9 | 15 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 31
5 | [NAME] |  | 8 | 12 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30
6 | [NAME] | x | 11 | 5 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30
7 | [NAME] | x | 11 | 11 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 26
8 | [NAME] | x | 12 | 5 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 26
9 | [NAME] | x | 7 | 4 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 26
10 | [NAME] | x | 14 | 3 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24
11 | [NAME] | x | 5 | 13 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23
12 | [NAME] | x | 6 | 10 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23
13 | [NAME] | x | 4 | 11 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23
14 | [NAME] | x | 7 | 5 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23
15 | [NAME] | x | 8 | 9 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22
16 | [NAME] | x | 4 | 10 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22
17 | [NAME] | x | 12 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22
18 | [NAME] |  | 13 | 1 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21
19 | [NAME] | x | 5 | 9 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21
20 | [NAME] | x | 5 | 7 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
21 | [NAME] | x | 6 | 5 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19
22 | [NAME] | x | 3 | 5 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19
23 | [NAME] |  | 0 | 10 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18
24 | Pennix II |  | 3 | 5 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18
25 | [NAME] | x | 4 | 2 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15
26 | [NAME] |  | 2 | 3 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9
 | Total Paid | 21 | 15 | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 43
Spreadsheet: 764476d1642762824-search-keyword-in-description-and-return-value-sample
Sheet: data

ID | Short Desc |  | VLOOKUP |  |  | Keywords | Grouped Issue |  | Keywords | Grouped Issue |  |  |  | [NAME]
INC0106553 | VIP Access (Lock) |  |  |  |  | vip | VIP Issue |  | "*"&vip&"*" | VIP Issue
INC0106493 | VIP Access Lock |  |  |  |  | password | Password Issue |  | "*"&password&"*" | Password Issue
INC0106216 | VIP Access (Not Sync)
INC0106121 | VIP Access Not Sync - stuck at 80% after enter the security code
INC0106052 | VIP Access (Lock)
[NAME] | VIP Access Lock
INC0106445 | Windows Account Lock & Password Reset
INC0106442 | Windows Account (Password Reset )
INC0106409 | [NAME] password
INC0106406 | Windows Account Lock after change password - unable to connect vpn
INC0106401 | Password expired - user is in UAE
INC0106399 | Windows Account (Password Reset)
INC0106527 | assist user to add printer
INC0106504 | need assistance to install printer
INC0106475 | PRINTER
 | password
 |  |  | IFERROR(VLOOKUP("*"&B2&"*",G2:H3,2,FALSE),"Others") |  |  |  |  |  |  |  |  | IFERROR(VLOOKUP(B2,J2:K3,2,FALSE),"Others")
 |  |  | IFERROR(VLOOKUP("*"&B2&"*",issue,2,FALSE),"Others") |  |  |  |  |  |  |  |  | IFERROR(VLOOKUP(B2,problem,2,FALSE),"Others")
 |  |  |  |  |  |  |  |  |  |  |  | XLOOKUP("*"&B2&"*","*"&issue[Keywords]&"*",issue[Grouped Issue])
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]])
Spreadsheet: 852012d1702114501-including-leading-zeros-in-number-format-cells-navex-planner-oc
Sheet: Sheet1

 | STEP 1 -  Enter checkpoint details in the Blue fields
 | For planning [NAME] Exercises using a set of checkpoints/waypoints/locations.
 | Enter GRs / labels / comments for each checkpoint in the BLUE fields (6, 8 or 10 figure GRs can be used)
 | Check point label | GR | Comments
 | A | 123456 | Example - enter checkpoint data in these blue fields
 | B | 123466 | Example - enter checkpoint data in these blue fields
 | C | 133466 | Example - enter checkpoint data in these blue fields
 | D | 133456 | Example - enter checkpoint data in these blue fields
 | STEP 2 -  Enter variables and routes in the sheet below.
 | Yellow fields: Enter Grid/Mag Angle. Select units (Mils/Degs, Metres/Yards). [NAME] speed, paces/100m and callsign are optional.
 | Green fields: Enter route (using Step 1 checkpoint labels) for each leg eg  'A' to 'B' to 'C' etc. From point only required for Serial 1.
 | You can save a copy of this sheet and edit the routes at Step 2 eg for mutiple callsigns using the same checkpoints.
NAV DATA SHEET |  |  |  |  | CALLSIGN |  |  |  |  |  |  | km/h
 |  |  |  |  |  |  |  |  |  |  |  | miles/h |  | .
 |  |  | Magnetic North is: | 180 | Mils | EAST | of Grid Nth | on | Mils | Degrees | EAST | WEST |  | .
 |  |  |  |  | Est Speed: | 3 | km/h |  | On | Off | [NAME] | Yards |  | .
 |  |  | FROM GR | TO GR | GRID BRG | MAG BRG | DIST | PACES | TIME | REMARKS / GOING |  |  |  | .
 | FROM | TO |  |  | Mils |  | [NAME] |  |  |  |  |  |  | .
SERIAL |  |  | (a) | (b) | (c) | (d) | (e) | (f) | (f) |  | (g) |  |  | .
1 | A | B
2 |  | C |  |  |  |  |  |  |  |  |  |  |  | .
3 |  | D |  |  |  |  |  |  |  |  |  |  |  | .
4 |  | A |  |  |  |  |  |  |  |  |  |  |  | .
5 |  |  |  |  |  |  |  |  |  |  |  |  |  | .
6 |  |  |  |  |  |  |  |  |  |  |  |  |  | .
7 |  |  |  |  |  |  |  |  |  |  |  |  |  | .
8 |  |  |  |  |  |  |  |  |  |  |  |  |  | .
9 |  |  |  |  |  |  |  |  |  |  |  |  |  | .
10 |  |  |  |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  | TOTAL |  | [NAME] |  | hours:mins |  |  |  | .
Spreadsheet: 328967d1404149074-vlookup-and-if-function-exact
Sheet: Sheet1

A81001 | 2
A81002 | 12
A81003 | 3
A81004 | 4
A81005 | 7
A81006 | 6
A81007 | 8
A81008 | 3
A81009 | 4
A81011 | 6
A81012 | 3
A81001 | 4
A81002 | 4
A81003 | 6
A81004 | 6
A81005 | 4
A81006 | 5
A81007 | 8
A81008 | 5
A81009 | 3
A81010 | 3
A81011 | 7
Spreadsheet: phillip_m_love__30695__July_Sithe_PriceBasisIndex_revised
Sheet: Index

850603
 |  |  |  |  |  |  |  |  | Totals
 |  | Phy/ |  |  | Monthly | PV | Discount | Mid | Fixed |  | Mid
Counterparty | Deal Num | Fin | Pub Code | Period | Quantity | Quantity | Factor | Price | Price | Cash | Value
FT-CENTRAL | N38268.U | P | CGPR-ST.CLAIR | 01-JUL-2000 | 559484.001 | 0 | 1 | 0 | 1e-07 | 0 | -0.0559
FT-ONTARIO | NO7825.1 | P | CGPR-ST.CLAIR | 01-JUL-2000 | 155000 | 0 | 1 | 0 | 1e-07 | 0 | -0.0155
FT-CENTRAL | NQ0697.2 | P | CGPR-FARWELL | 01-JUL-2000 | 20870.998 | 0 | 1 | 0 | 1e-07 | 0 | -0.0021
FT-CENTRAL | NQ0697.4 | P | CGPR-FARWELL | 01-JUL-2000 | -20870.998 | 0 | 1 | 0 | 1e-07 | 0 | 0.0021
Spreadsheet: 214391d1360889205-creating-a-dynamic-range-based-on-a-test-rainfall
Sheet: Sheet1

[NAME] (dd/mm/yyyy) | Precipitación Total (Lluvia + Nieve) ([NAME])
2009-01-01 00:00:00 | 2.8
2009-01-02 00:00:00 | 5.7
2009-01-03 00:00:00 | 12.1
2009-01-04 00:00:00 | 5.2
2009-01-05 00:00:00 | 1.5
2009-01-06 00:00:00 | 2.8
2009-01-07 00:00:00 | 5.1
2009-01-08 00:00:00 | 2.2
2009-01-09 00:00:00 | 9.5
2009-01-10 00:00:00 | 18.4
2009-01-11 00:00:00 | 3.2
2009-01-12 00:00:00 | 7.1
2009-01-13 00:00:00 | 12.3
2009-01-14 00:00:00 | 11.5
2009-01-15 00:00:00 | 2.6
2009-01-16 00:00:00 | 3.4
2009-01-17 00:00:00 | 6.2
2009-01-18 00:00:00 | 10.6
2009-01-19 00:00:00 | 1.9
2009-01-20 00:00:00 | 0
2009-01-21 00:00:00 | 4
2009-01-22 00:00:00 | 0.7
2009-01-23 00:00:00 | 0.2
2009-01-24 00:00:00 | 1.3
2009-01-25 00:00:00 | 3.8
2009-01-26 00:00:00 | 8.4
2009-01-27 00:00:00 | 5.2
2009-01-28 00:00:00 | 7.4
2009-01-29 00:00:00 | 13.3
2009-01-30 00:00:00 | 7.1
2009-01-31 00:00:00 | 9.699999999999994
2009-02-01 00:00:00 | 2.1
2009-02-02 00:00:00 | 21.2
2009-02-03 00:00:00 | 2
2009-02-04 00:00:00 | 4.4
2009-02-05 00:00:00 | 4
2009-02-06 00:00:00 | 7.5
2009-02-07 00:00:00 | 4.9
2009-02-08 00:00:00 | 0
2009-02-09 00:00:00 | 12.5
2009-02-10 00:00:00 | 15.9
2009-02-11 00:00:00 | 2.7
2009-02-12 00:00:00 | 4
2009-02-13 00:00:00 | 9.2
2009-02-14 00:00:00 | 14.1
2009-02-15 00:00:00 | 6.9
2009-02-16 00:00:00 | 3.6
2009-02-17 00:00:00 | 8.4
2009-02-18 00:00:00 | 4.5
2009-02-19 00:00:00 | 7.4
2009-02-20 00:00:00 | 9.1
2009-02-21 00:00:00 | 4
2009-02-22 00:00:00 | 12.5
2009-02-23 00:00:00 | 3.4
2009-02-24 00:00:00 | 0.9
2009-02-25 00:00:00 | 0
2009-02-26 00:00:00 | 11.3
2009-02-27 00:00:00 | 2.7
2009-02-28 00:00:00 | 2.4
2009-03-01 00:00:00 | 2.5
2009-03-02 00:00:00 | 5.5
2009-03-03 00:00:00 | 10.6
2009-03-04 00:00:00 | 1.3
2009-03-05 00:00:00 | 7.1
2009-03-06 00:00:00 | 14.9
2009-03-07 00:00:00 | 14.4
2009-03-08 00:00:00 | 2
2009-03-09 00:00:00 | 2.4
2009-03-10 00:00:00 | 6.2
2009-03-11 00:00:00 | 18.7
2009-03-12 00:00:00 | 6.9
2009-03-13 00:00:00 | 14.3
2009-03-14 00:00:00 | 4.7
2009-03-15 00:00:00 | 13.2
2009-03-16 00:00:00 | 0.6
2009-03-17 00:00:00 | 0.5
2009-03-18 00:00:00 | 0.2
2009-03-19 00:00:00 | 0.5
2009-03-20 00:00:00 | 0.8
2009-03-21 00:00:00 | 0.4
2009-03-22 00:00:00 | 4.4
2009-03-23 00:00:00 | 13.6
2009-03-24 00:00:00 | 2
2009-03-25 00:00:00 | 10.9
2009-03-26 00:00:00 | 12.1
2009-03-27 00:00:00 | 6.5
2009-03-28 00:00:00 | 2
2009-03-29 00:00:00 | 14.3
2009-03-30 00:00:00 | 9
2009-03-31 00:00:00 | 14
2009-04-01 00:00:00 | 8.8
2009-04-02 00:00:00 | 0
2009-04-03 00:00:00 | 6.9
2009-04-04 00:00:00 | 0.6
2009-04-05 00:00:00 | 4.8
2009-04-06 00:00:00 | 4.8
2009-04-07 00:00:00 | 7.4
2009-04-08 00:00:00 | 16.9
2009-04-09 00:00:00 | 4.2
2009-04-10 00:00:00 | 13.2
2009-04-11 00:00:00 | 16
2009-04-12 00:00:00 | 4.9
2009-04-13 00:00:00 | 13.5
2009-04-14 00:00:00 | 8.4
2009-04-15 00:00:00 | 5.8
2009-04-16 00:00:00 | 0
2009-04-17 00:00:00 | 0
2009-04-18 00:00:00 | 4
2009-04-19 00:00:00 | 0
2009-04-20 00:00:00 | 0.3
2009-04-21 00:00:00 | 1
Spreadsheet: b569ad9e-ed53-4083-88b7-f51c16fc63f9
Sheet: Sheet1

Table S5. Non-uniform distribution of transcription factor binding sites relative half-EREs in ChIP-PET clusters. | Unnamed: 1
MatrixID | KS p-value
V$PAX2_01 | 5.85721e-05
V$SF1_Q6 | 0.0003337
V$DR4_Q2 | 0.004232081
V$OCT1_Q6 | 0.005147194
V$SPZ1_01 | 0.007458799
V$LEF1_Q2 | 0.007761855
V$OCT_Q6 | 0.01866698
V$AP2REP_01 | 0.02342517
V$TTF1_Q6 | 0.02586975
V$SRY_01 | 0.03242134
V$DBP_Q6 | 0.03447907
V$EVI1_04 | 0.0427063
V$OCT1_Q5_01 | 0.04858161
V$CHCH_01 | 0.04926352
V$HNF1_Q6_01 | 0.05475865
Spreadsheet: 599545d1543175871-list-of-sundays-and-holidays-feste
Sheet: Foglio1

2018-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Giorno | Mese | Data | Ricorrenze
 |  |  |  |  |  |  |  |  |  | 1 | 1 |  | Capodanno
 |  |  |  |  |  |  |  |  |  | 6 | 1 |  | Epifania
 |  |  |  |  |  |  |  |  |  |  |  |  | Pasqua
 |  |  |  |  |  |  |  |  |  |  |  |  | Lunedì d.A
 |  |  |  |  |  |  |  |  |  | 25 | 4 |  | Liberazione
 |  |  |  |  |  |  |  |  |  | 1 | 5 |  | 1°Maggio
 |  |  |  |  |  |  |  |  |  | 2 | 6 |  | Festa Rep.
 |  |  |  |  |  |  |  |  |  | 15 | 8 |  | Ferragosto
 |  |  |  |  |  |  |  |  |  | 1 | 11 |  | Tutti i Santi
 |  |  |  |  |  |  |  |  |  | 8 | 12 |  | Immacol. C.
 |  |  |  |  |  |  |  |  |  | 25 | 12 |  | Natale
 |  |  |  |  |  |  |  |  |  | 26 | 12 |  | S.Stefano
Spreadsheet: 70490d1271222754-excel-2007-sumif-array-question-sumif-array-example
Sheet: Sheet1

202
203
103 | 1000
104 | 5000
104 | 3000
104 | 2000
104 | 10000
104 | 1000
104 | 8000
201 | 8000
202 | 3400
204 | 5400
108 | 6566
109 | 9000
110 | 1000
101
102 | 2000
101 | 1000
107 | 13000
Spreadsheet: 837344d1690075789-how-do-you-provide-points-based-on-a-defined-lookup-targets-table-points-based-on-value
Sheet: Test

 | Test | Pts | Points Want |  | Test2 | Pts | Points want |  | Test3 | Pts | Points want
[NAME] | 0.2285714285714286 |  | 0 |  | 28 |  | 10 |  | 110 |  | 10
[NAME] | 0.1568627450980392 |  | 2 | 2 | 30 |  | 10 | 10 | 72 |  | 5 | 5
[NAME] | 0.0967741935483871 |  | 10 | 10 | 35 |  | 5 | 5 | 35 |  | 0 | 0
[NAME] | 0.2051282051282051 |  | 0 | 0 | 20 |  | 10 | 10 | 100 |  | 10 | 10
[NAME] | 0.06521739130434782 |  | 10 | 10 | 10 |  | 10 | 10 | 46 |  | 2 | 2
[NAME] |  |  |  |  | 5 |  | 10 | 10 | 5 |  | 0 | 0
Area2 | 0.09302325581395349 |  | 10 | 10 | 20 |  | 10 | 10 | 110 |  | 10 | 10
Area2 | 0.09090909090909091 |  | 10 | 10 | 30 |  | 7 | 7 | 60 |  | 7 | 7
Area2 | 0.15 |  | 7 | 7 | 15 |  | 10 | 10 | 35 |  | 1 | 1
Area2 | 0.19 |  | 4 | 4 | 35 |  | 4 | 4 | 20 |  | 0 | 0
Spreadsheet: 207187d1358387977-finding-2-numbers-in-a-field-book2
Sheet: Sheet1

value 1 |  | 1
value 2 |  | 4
19 | 6 | 12 | 20 | 15 | 12 | 7 | 18 | 19 | 18 | 2 | 9 | 7 | 1 | 9 | 11 | 2 | 10 | 6 | 9
11 | 18 | 5 | 14 | 13 | 8 | 12 | 17 | 17 | 18 | 17 | 1 | 8 | 4 | 20 | 12 | 11 | 11 | 2 | 14
18 | 7 | 6 | 16 | 3 | 2 | 14 | 6 | 20 | 4 | 17 | 12 | 1 | 16 | 17 | 7 | 13 | 13 | 17 | 16
14 | 14 | 20 | 6 | 4 | 15 | 17 | 19 | 11 | 3 | 6 | 10 | 1 | 17 | 14 | 8 | 4 | 16 | 16 | 2
5 | 17 | 2 | 4 | 3 | 10 | 20 | 18 | 14 | 11 | 13 | 17 | 20 | 9 | 6 | 4 | 5 | 20 | 7 | 18
19 | 5 | 1 | 4 | 11 | 12 | 14 | 1 | 7 | 10 | 14 | 8 | 1 | 5 | 15 | 5 | 1 | 1 | 13 | 4
9 | 1 | 16 | 9 | 11 | 3 | 15 | 14 | 9 | 17 | 4 | 1 | 11 | 6 | 9 | 5 | 13 | 6 | 1 | 13
9 | 18 | 10 | 10 | 13 | 16 | 1 | 5 | 13 | 18 | 7 | 4 | 9 | 17 | 19 | 18 | 17 | 12 | 20 | 8
17 | 6 | 10 | 17 | 8 | 14 | 4 | 10 | 16 | 8 | 3 | 17 | 16 | 4 | 4 | 5 | 14 | 16 | 5 | 7
9 | 6 | 15 | 9 | 12 | 16 | 14 | 17 | 12 | 3 | 17 | 20 | 6 | 18 | 10 | 11 | 9 | 11 | 6 | 5
9 | 1 | 14 | 20 | 7 | 4 | 12 | 15 | 18 | 20 | 3 | 13 | 11 | 10 | 10 | 3 | 9 | 20 | 3 | 18
18 | 17 | 15 | 8 | 5 | 8 | 11 | 15 | 19 | 6 | 3 | 10 | 13 | 1 | 5 | 6 | 12 | 16 | 1 | 10
10 | 12 | 17 | 14 | 1 | 14 | 8 | 18 | 18 | 2 | 15 | 2 | 15 | 2 | 19 | 3 | 11 | 3 | 14 | 10
6 | 13 | 18 | 12 | 8 | 6 | 19 | 11 | 19 | 17 | 6 | 9 | 6 | 17 | 18 | 16 | 16 | 12 | 11 | 10
19 | 14 | 2 | 15 | 16 | 13 | 18 | 4 | 1 | 16 | 19 | 17 | 19 | 10 | 10 | 8 | 17 | 10 | 8 | 16
7 | 9 | 8 | 9 | 2 | 10 | 3 | 12 | 3 | 13 | 13 | 3 | 8 | 14 | 1 | 16 | 2 | 17 | 12 | 13
8 | 8 | 7 | 12 | 5 | 4 | 15 | 9 | 8 | 16 | 7 | 13 | 7 | 10 | 13 | 16 | 6 | 3 | 17 | 5
6 | 19 | 2 | 19 | 18 | 7 | 4 | 7 | 6 | 6 | 5 | 12 | 4 | 20 | 11 | 14 | 4 | 8 | 4 | 2
7 | 15 | 17 | 10 | 4 | 11 | 19 | 17 | 14 | 11 | 19 | 20 | 9 | 5 | 1 | 12 | 2 | 5 | 14 | 6
11 | 20 | 1 | 6 | 15 | 11 | 6 | 16 | 4 | 18 | 8 | 16 | 12 | 15 | 16 | 6 | 20 | 3 | 15 | 5
13 | 3 | 3 | 7 | 6 | 13 | 12 | 10 | 15 | 18 | 3 | 17 | 6 | 13 | 7 | 17 | 17 | 16 | 19 | 8
10 | 9 | 2 | 11 | 6 | 9 | 6 | 12 | 4 | 20 | 11 | 10 | 12 | 10 | 9 | 8 | 14 | 9 | 6 | 6
14 | 19 | 4 | 18 | 7 | 16 | 14 | 18 | 13 | 8 | 9 | 5 | 10 | 17 | 20 | 9 | 19 | 3 | 5 | 7
17 | 11 | 14 | 13 | 11 | 5 | 12 | 8 | 1 | 5 | 8 | 17 | 6 | 18 | 5 | 7 | 11 | 3 | 15 | 3
5 | 15 | 13 | 10 | 15 | 3 | 3 | 12 | 3 | 7 | 7 | 15 | 8 | 7 | 10 | 18 | 20 | 2 | 20 | 5
3 | 19 | 14 | 5 | 13 | 10 | 20 | 11 | 5 | 20 | 8 | 5 | 7 | 9 | 7 | 18 | 9 | 10 | 20 | 4
13 | 13 | 11 | 4 | 7 | 19 | 17 | 6 | 3 | 6 | 18 | 13 | 8 | 1 | 18 | 7 | 10 | 14 | 18 | 2
2 | 20 | 17 | 12 | 12 | 7 | 5 | 9 | 16 | 14 | 8 | 10 | 3 | 12 | 4 | 7 | 7 | 6 | 4 | 16
10 | 19 | 19 | 11 | 16 | 20 | 7 | 2 | 11 | 4 | 6 | 6 | 2 | 9 | 6 | 10 | 16 | 6 | 16 | 11
15 | 17 | 4 | 15 | 13 | 20 | 11 | 7 | 10 | 6 | 4 | 15 | 1 | 2 | 16 | 1 | 12 | 3 | 17 | 6
7 | 11 | 14 | 20 | 13 | 20 | 6 | 15 | 13 | 12 | 9 | 12 | 9 | 8 | 17 | 8 | 5 | 17 | 18 | 7
Spreadsheet: 880603d1728410221-sumiffs-by-date-range-and-customer-rt-open-hours-date-change-test
Sheet: RT OJ

JOB# | CUSTOMER | PART# | PART NAME | PO# | FINISH | QTY | HRS EST | DUE DATE
24J21392 | AGL | 1111622 | 1.5 Hex Hub | 77504 |  | 2 | 4.25 | 2024-10-18 00:00:00
24J21369 | AGR | WHITE BUSHING | WHITE BUSHING | emailed |  | 50 | 5.0833 | 2024-10-16 00:00:00 |  |  | CUSTOMER
24J21357 | APT | AKN13 87210 122 die | AKN13 87210 122 die | 240054s |  | 1 | 7.0833 | 2024-10-18 00:00:00
24J21255 | BS | 51948939 | CAM LOCK ASSEMBLY TITANIUM | 7000482147 | trk 64580 | 2 | 7.6833 | 2024-10-09 00:00:00
24J21257 | BS | 51948941 | CAM LOCK BRACKET | 7000482147 | trk 64580 | 18 | 32.5833 | 2024-10-09 00:00:00
24J21280 | BS | 90046309 | Helicoid, 4 Flow | 7000483488 | trk 64440 | 10 | 102.6667 | 2024-10-18 00:00:00
24J21282 | BS | 91060963 | 1.5in BREAKER PLATE | 7000483489 | trk 64410 | 6 | 8.75 | 2024-10-18 00:00:00
24J21372 | BS | 51904851 | [NAME] Insert A= .300 | 7000486940 | trk 64689 | 1 | 5.1667 | 2024-10-30 00:00:00
24J21373 | BS | 51905332 | VACUUM BUSHING MACRO-PULLER INLET LARGE DIM A= .300 | 7000486940 | trk 64689 | 1 | 3.75 | 2024-10-30 00:00:00
24J21416 | BS | 50633952 | AGL Breaker Plate | 7000489081 | trk 64892 | 3 | 6.25 | 2024-10-31 00:00:00
24J21417 | BS | 90048188 | .125 OUTLET ADAPTER | 7000489081 | trk 64892 | 2 | 9.7 | 2024-10-31 00:00:00
24J21375 | BS | 90048193 | Adapter, Melt Filter W/O Pump | 7000487447 | trk 64747 | 5 | 12 | 2024-11-08 00:00:00
24J21376 | BS | 90063991 | HELICOID, OUTER SPIRAL | 7000487451 | trk 64685 | 8 | 58.8333 | 2024-11-08 00:00:00
24J21415 | BS | 90056240 | Helicoid, Middle Spiral | 7000489070 | trk 64838 | 8 | 56.8333 | 2024-11-22 00:00:00
24J21177 | DP | M0199531-01 (60873) | M0199531-01 TRACK CAM 304 SS (60873 RAPIDPACK) | 5071954 |  | 4 | 9.6667 | 2024-09-24 00:00:00
24J21275 | DP | M0454862-01 | [NAME]: Rammer | 5095508 | 29.5"  14mm 304ss | 16 | 33.4167 | 2024-11-01 00:00:00
 |  |  |  |  |  |  |  |  | LGC TOTALS | PAST DUE TO 30 DAYS OUT | 30-60 DAYS OUT
24J21242 | LGCG | 9924271 | FRAME TOP | 712080653 | CA | 1 | 3 | 2024-09-27 00:00:00
24J21388 | LGCG | 9924398 | TOP GUARD | 712093223 |  | 2 | 1.25 | 2024-10-18 00:00:00
24J21362 | LGCG | 9924231 | FRAME BASE | 712089616 | CA | 1 | 2.9667 | 2024-10-22 00:00:00
24J21363 | LGCG | 9924348 | SIDE WINDOWS | 712089616 | CA | 2 | 1.05 | 2024-10-22 00:00:00
24J21167 | LGCG | 9920294 | PH LH REAR GRIPPER FINGER | 712074797 | BA | 2 | 3.2 | 2025-01-31 00:00:00
24J21168 | LGCG | 9921046 | PH SHuttle Mount Bracket | 712074797 | BA | 2 | 5.0167 | 2025-01-31 00:00:00
24J21395 | LGCG | 192X-1-085 | Multi Manifold Tube Guide | 712093868 | ca | 2 | 2.9333 | 2025-02-07 00:00:00
24J21396 | LGCG | 9923716 | HC2 FRAME FRONT UPRIGHT | 712093868 |  | 2 | 0.9833 | 2025-02-07 00:00:00
24J21398 | LGCG | KBS-28-027 | KBS-28-027 BASKET MOUNT PLATE | 712093868 | CA | 10 | 5.3667 | 2025-02-07 00:00:00