tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 81528d1281660520-random-word-generator-scratch
Sheet: Sheet1

Cum: | 10098 | 198 | 11 | [NAME] columns to left as needed
Cnt: | 51 | 18 | 11
 | Bin1 | Bin2 | Bin3
 | ad- | archaeo | omni-
 | -al | aster/astra | -ous
 | [NAME] | audi | pan-
 | ante- | bene | per-
 | anti- | bio | peri-
 | -arium | [NAME] | poly-
 | auto- | chloro | post-
 | centi- | chrono | pre-
 | circum- | derm | pro-
 | con- | dic/dict | re-
 | de- | fer | retro-
 | deci- | fix
 | di- | gen
 | dis- | geo
 | -dom | graph
 | ex- | hemo
 | hetero- | herb
 | hypo- | hydro
 | -ic
 | -ile
 | in-
 | inter-
 | intra-
 | -ism
 | -ist
 | [NAME]
 | micro-
 | milli-
 | mis-
 | mono-
 | nano-
 | neo-
 | -ology
 | omni-
 | -ous
 | -ous
 | pan-
 | per-
 | peri-
 | poly-
 | post-
 | pre-
 | pro-
 | re-
 | retro-
 | sub-
 | super-
 | sym-
 | -tion
 | -ular
 | un-
# | Permutations
1 | ad- | archaeo | omni- | ad-archaeoomni-
2 | ad- | archaeo | -ous | ad-archaeo-ous
3 | ad- | archaeo | pan- | ad-archaeopan-
4 | ad- | archaeo | per- | ad-archaeoper-
5 | ad- | archaeo | peri- | ad-archaeoperi-
6 | ad- | archaeo | poly- | ad-archaeopoly-
7 | ad- | archaeo | post- | ad-archaeopost-
8 | ad- | archaeo | pre- | ad-archaeopre-
9 | ad- | archaeo | pro- | ad-archaeopro-
10 | ad- | archaeo | re- | ad-archaeore-
11 | ad- | archaeo | retro- | ad-archaeoretro-
12 | ad- | aster/astra | omni- | ad-aster/astraomni-
13 | ad- | aster/astra | -ous | ad-aster/astra-ous
14 | ad- | aster/astra | pan- | ad-aster/astrapan-
15 | ad- | aster/astra | per- | ad-aster/astraper-
16 | ad- | aster/astra | peri- | ad-aster/astraperi-
17 | ad- | aster/astra | poly- | ad-aster/astrapoly-
18 | ad- | aster/astra | post- | ad-aster/astrapost-
19 | ad- | aster/astra | pre- | ad-aster/astrapre-
20 | ad- | aster/astra | pro- | ad-aster/astrapro-
21 | ad- | aster/astra | re- | ad-aster/astrare-
22 | ad- | aster/astra | retro- | ad-aster/astraretro-
23 | ad- | audi | omni- | ad-audiomni-
24 | ad- | audi | -ous | ad-audi-ous
25 | ad- | audi | pan- | ad-audipan-
26 | ad- | audi | per- | ad-audiper-
27 | ad- | audi | peri- | ad-audiperi-
28 | ad- | audi | poly- | ad-audipoly-
29 | ad- | audi | post- | ad-audipost-
30 | ad- | audi | pre- | ad-audipre-
31 | ad- | audi | pro- | ad-audipro-
32 | ad- | audi | re- | ad-audire-
33 | ad- | audi | retro- | ad-audiretro-
34 | ad- | bene | omni- | ad-beneomni-
35 | ad- | bene | -ous | ad-bene-ous
36 | ad- | bene | pan- | ad-benepan-
37 | ad- | bene | per- | ad-beneper-
38 | ad- | bene | peri- | ad-beneperi-
39 | ad- | bene | poly- | ad-benepoly-
40 | ad- | bene | post- | ad-benepost-
41 | ad- | bene | pre- | ad-benepre-
42 | ad- | bene | pro- | ad-benepro-
43 | ad- | bene | re- | ad-benere-
44 | ad- | bene | retro- | ad-beneretro-
45 | ad- | bio | omni- | ad-bioomni-
46 | ad- | bio | -ous | ad-bio-ous
47 | ad- | bio | pan- | ad-biopan-
48 | ad- | bio | per- | ad-bioper-
Spreadsheet: 888202d1738673575-sumproduct-value-error-sumproduct-value-error
Sheet: Fcast $

 |  |  |  | TOTALS REVENUE
 |  |  |  | SUBTOTALS REVENUE
Ref | Desc. | WBS | Item | Rates | Current Budget | To 24-Jan 25 | 2025-01-31 00:00:00
10 | PM/PS - SD | 00 | Planner ([NAME] ) | 103.69
11 | PM/PS - SD | 00 | [NAME] ([NAME]) | 154.18
12 | PM/PS - SD | 00 | Fleming,[NAME] | 140.51
Spreadsheet: 859650d1707967226-trying-to-pull-data-from-two-sheets-with-formulas-vlookup-array-formula-test-excel-5
Sheet: PRICING ANALYZER

NO HISTORY ITEMS |  | SIM List - HAS HISTORY | SIM Description | [NAME] Months | Sales - 24 Months | Market Cost | Margin | Sell | [NAME] | Contract Start Date | Contract Stop Date | Cost-Side Claim | Authorization Name | Market Cost (Includes WTT) | Replacement Cost (NET cost)
 | J
[PHONE] | g
[PHONE] | g
[PHONE] | g
[PHONE] | g
[PHONE] | g
[PHONE] | g
[PHONE] | f
[PHONE] | dsds
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: 4332cf73-4313-49f9-a3a4-0827c79ebb3b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261355 | 7981 | [NAME] | [NAME] | USA | 33 | 00:12:58 | 00:01:40 | 00:38:31 | 00:00:34 | 00:21:39 | 1 | 01:15:21
261355 | 43854 | [NAME] | Vogtsberger | USA | 34 | 00:13:07 | 00:02:39 | 00:35:58 | 00:01:22 | 00:23:58 | 2 | 01:17:02
261355 | 74260 | [NAME] | Power | CAN | 35 | 00:17:51 | 00:05:29 | 01:20:58 | 00:02:26 | 00:49:18 | 3 | [NAME]
Spreadsheet: 170134d1343165109-finding-min-max-and-subtracting-or-adding-based-on-condition-fixedit
Sheet: worksheet

 |  |  |  | 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
 |  |  | 57 | Sizes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  | 3 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 0 | 3 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 0 | 0 | NEW PASTE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Total
LOC | LOC NAME | SLS | Qty | 30104 | 30106 | 30108 | 30110 | 30112 | 30114 | 30116 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 4 | 6 | 8 | 10 | 12 | 14 | 16
1 | A |  | 21 | 2 | 3 | 4 | 4 | 3 | 3 | 1 | 0 | 1 | #N/A | 4 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 4 | 0 | 0 | 4 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 4 | 0 | #N/A | #N/A | #N/A | 8 | 15 | 20 | 20 | 15 | 15 | 7 |  |  |  | 21 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
2 | B |  | 24 | 2 | 4 | 5 | 3 | 4 | 3 | 2 | 0 | 1 | #N/A | 6 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 0 | 0 | 6 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 0 | #N/A | #N/A | #N/A | 9.9 | 15.7 | 20.5 | 14.4 | 16.3 | 13.2 | 10 |  |  |  | 24 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
3 | C |  | 12 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 0 | 1 | #N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | #N/A | #N/A | #N/A | 11.4 | 11.2 | 13 | 13.6 | 17.4 | 19.3 | 14.2 |  |  |  | 12 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 764685d1642879423-how-to-increment-the-number-of-a-row-unless-the-previous-row-does-not-contain-a-number-if-or-index-a-a-row-1-__-not-isnumber-index-a-a-row-1-max-a-7-index-a-a-row-1-tms
Sheet: Sheet1

CH
1 | 8
2 | 9
 | 10
3 | 11
4 | 12
x | 13
y | 14
z | 15
5 | 16
a | 17
b | 18
c | 19
6 | 20
7 | 21
8 | 22
9 | 23
10 | 24
11 | 25
12 | 26
13 | 27
14 | 28
15 | 29
16 | 30
17 | 31
18 | 32
19 | 33
20 | 34
21 | 35
22 | 36
23 | 37
24 | 38
25 | 39
26 | 40
Spreadsheet: 546461d1510063131-multiple-data-validation-with-indirect-not-working-correctly-example
Sheet: Sheet2

Product Type | Product | Recipe
Yellow & Orange Fruit
ProductList
Red Fruit | RedFruit
Yellow & Orange Fruit | YOFruit
Green Fruit | GreenFruit
RedFruitList
[NAME] | Mac
Bing Cherries | Bing
YOFruitList
[NAME] | [NAME]
[NAME] | Meyer
GreenFruitList
Key Lime | KeyLime
Grapes | Grapes
Spreadsheet: 792960d1661246068-function-displaying-the-right-values-of-dates-and-moneyamounts-function
Sheet: function

name | date | Moneyamount | function | Preferred function result
[NAME] | 2022-06-19 00:00:00 | 100 |  | [NAME] | 19-6-2022 | €100
[NAME] | 2022-06-20 00:00:00 | 101 |  | [NAME] | 19-6-2022 | €101
[NAME] | 2022-06-21 00:00:00 | 102 |  | [NAME] | 19-6-2022 | €102
[NAME] | 2022-06-22 00:00:00 | 103 |  | [NAME] | 19-6-2022 | €103
[NAME] | 2022-06-23 00:00:00 | 104 |  | [NAME] | 19-6-2022 | €104
[NAME] | 2022-06-24 00:00:00 | 105 |  | [NAME] | 19-6-2022 | €105
[NAME] | 2022-06-25 00:00:00 | 106 |  | [NAME] | 19-6-2022 | €106
Spreadsheet: 009cd8c5-229a-4c09-9c0a-88478dfa914e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 31. LEASE FINANCE COMMITMENTS, By Purpose: State (NSW), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413975X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413976A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413977C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413978F | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413979J | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413980T | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413981V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413982W | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413983X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413984A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413985C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413986F | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413987J | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413988K | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413989L | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413990W | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 77858d1278355033-excel-2007-averaging-no-blanks-and-no-zeros-over-several-sheets-test-monthly-1
Sheet: WK1 Mon

 | Monthly Total
 | Desktop |  | Network |  |  |  | Install | Add |  |  | Total
 | Opened |  | Opened
 | Closed |  | Closed
 | Backlog |  | Backlog
 | Frozen |  | Frozen
 | Active Install Tickets
 | Install Tickets Frozen |  | 15
 | Install Tickets in Responded
Spreadsheet: 858384d1707108356-copying-data-from-daily-time-break-sheet-test-3
Sheet: Mon

 | 2024-01-01 00:00:00 | 2024-01-08 00:00:00 | 2024-01-15 00:00:00 | 2024-01-22 00:00:00 | 2024-01-29 00:00:00
TimeSlice | Monday | Monday | Monday | Monday | Monday
08:15:00
08:30:00
08:45:00
09:00:00
09:15:00
09:30:00
09:45:00
10:00:00
10:15:00
10:30:00
10:45:00
11:00:00
11:15:00
11:30:00
11:45:00
12:00:00
12:15:00
12:30:00
12:45:00
13:00:00
13:15:00
13:30:00
13:45:00
14:00:00
14:15:00
14:30:00
14:45:00
15:00:00
15:15:00
15:30:00
15:45:00
16:00:00
16:15:00
16:30:00
16:45:00
17:00:00
17:15:00
17:30:00
17:45:00
18:00:00
18:15:00
18:30:00
18:45:00
19:00:00
19:15:00
19:30:00
19:45:00
20:00:00
20:15:00
20:30:00
20:45:00
21:00:00
21:15:00
21:30:00
21:45:00
22:00:00
22:15:00
22:30:00
22:45:00
23:00:00
23:15:00
23:30:00
23:45:00
00:00:00
00:15:00
00:30:00
00:45:00
01:00:00
01:15:00
Spreadsheet: 156449d1337290786-excel-2007-pick-a-region-from-a-list-and-return-all-territories-of-that-region-forum
Sheet: Arkusz1

 | 1001
1001 | 100101 | 100102 | 100103 | 100104 | 100105 | 100106 | 100107
1002 | 100111 | 100112 | 100113 | 100114 | 100115 | 100116 | 100117
1003 | 100222 | 100223 | 100224 | 100225 | 100226 | 100227 | 100228
Spreadsheet: 298342d1392760567-count-and-provide-value-of-colored-cells-in-a-row-ex_count_colored_cells
Sheet: Sheet1

Date | ID | Job Name | Description | Track | Name Errors | Description Errors | Track Errors
2014-01-15 00:00:00 | ID123 | Name 1 | Description 1 | Fast
2014-02-07 00:00:00 | ID124 | Name 2 | Standard Work bites | Fast
2014-02-05 00:00:00 | ID125 | Name 3 | Description 3 | Normal
2014-01-14 00:00:00 | ID126 | Name 4 | Description 4 | Fast
2014-01-07 00:00:00 | ID127 | My Job | Description 5 | Fast
2014-02-11 00:00:00 | ID128 | Name 6 | Description 6 | Real Fast
2014-01-17 00:00:00 | ID129 | Name 7 | I want this yesterday | Faster
2014-02-09 00:00:00 | ID130 | Name 8 | Description 8 | Fast
Spreadsheet: 777472d1650402793-sum-is-off-by-01-according-to-calculator-sheet-shared-1
Sheet: Net Strip

Green Forest Industries
 |  |  |  |  |  |  |  |  | Enter footage in cell C12 and enter the additional footage in C13. All cells require input that effect the formulas. There are dropdowns for each category that require you to select one or input their own info.
Net Strip Cost |  | 25
Thickness |  | 1
[NAME] |  | 2
Margin |  | 0.9
Set up |  | 50
Run Charge |  | 0.55
Knife Charge |  | 85
Freight Charge |  | 0.8
Freight Cost |  | 0
[NAME] |  | Glue | 30 |  |  | list all items used to calculate this total
Footage |  | 800
Footage + |  | 20
Total footage
Sub total |  |  |  |  |  | 0
Added cost or tax etc.. |  |  |  |  |  | 0
Sell Price
Spreadsheet: 702494d1604387444-index-match-using-multiple-worksheets-where-index-is-aplhanumeric-index-match-multi-worksheet-problem
Sheet: Employees & Contractors

Index | Employee ID Number | Employee Surname | Employee Given Name | Employment Status | ABN or TFN | Tax Threshold | Hourly Pay Rate | Tax Table
1 | AF1000 | Able | [NAME] | Adult - Part-time | 111111111 | Yes | 18.24
2 | AP1000 | Bravo | Indigo | Adult - Part-time | 222222222 | No | 21.16
3 | J1000 | Tango | Victor | Junior | 333333333 | Yes | 14.22
4 | C1000 | Lima | [NAME] | Contractor |  | No | 35
Spreadsheet: 0dd97f25-fb77-4cc2-a7d3-0631445fb21e
Sheet: Exhibit A - Year 2

Section L - Attachment 7 - Price Schedule
DE-SOL-0003816
Option Year 1 (February 1, 2014 - January 31, 2015)
Amendment 000006
Total Contract
 | DPLH |  |  | Labor |  |  | Direct Labor Costs |  |  | Fringe Benefits |  |  | [NAME] |  |  | Onsite Overhead |  |  | Onsite | Total Costs
Cost Element |  |  |  | Straight | Over | Double | Straight | Over | Double |  |  |  |  |  |  |  |  |  | Overhead
 | Straight | Over | Double | Time | Time | Time | Time | Time | Time | Straight | Over | Double | Straight | Over | Double | Straight | Over | Double |  | Straight | Over | Double | Total
 | Time | Time | Time | Rate | Rate | Rate | Costs | Costs | Costs | Time | Time | Time | Time | Time | Time | Time | Time | Time | Rate | Time | Time | Time | Costs
Cost Plus Fixed Fee (CPFF) Tasks
**Prime Contractor Labor
Bargaining Employee:
Mechanic | 3630 | 100 | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mobile Crane Inspector | 120
Laborer | 5625 | 150 | 90
Heavy Equipment Operator | 5625 | 150 | 90
Truck Driver | 5625 | 150 | 90
(Itemize each additional position)
Non-Bargaining Employees:
Program Manager | 1775 | 0
Operations & Maintenance Manager | 1775 | 0
Administrative Assistant | 1775
Shop Manager | 1775 | 0
Supply Technician | 1875 | 20
Construction Technician | 0 | 0 | 0
(Itemize each additional position)
Subtotal (Provide Subtotals for Each) |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subcontractor Labor (If Applicable)
(Itemize for Each Position)
Subtotal (Provide Subtotals for Each) | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subtotal CPFF Labor Related Costs | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
Other Direct Costs:
Material |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500000
Construction |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500000
Subtotal CPFF Costs | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
G&A (Identify G&A Rate)
Total CPFF Proposed Costs
Reserve Fee
Total  Proposed CPFF Fee
Total [NAME] | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
A 3% increase to be added to all labor for the following options.  (All hours and material/subcontracts remain the same)
*Note:  Fuel - Contractor shall not charge in excess of $.10 per gallon surcharge for sold fuel applicable to reservation activities.  No additional G&A, handling fee, or other direct or indirect charges will apply to this cost.
**The labor categories and hours may be adjusted at the discretion of the offeror in order to comply with the offeror's position in meeting the requirements of the solicitation.
Spreadsheet: 133860d1324712750-parse-text-separated-by-to-next-row-parse-email-ids-in-two-rows
Sheet: Sheet1

Before |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sub Splt()
account_no | BAL | Mail IDs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], i As Long
977265891 | 1865 | [EMAIL];[EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] [NAME]
977356854 | 346 | [EMAIL];[EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Application.ScreenUpdating = False
978433979 | 699 | [EMAIL];[EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LR = Range("A" & Rows.Count).End(xlUp).Row
977653720 | 427 | [EMAIL];[EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Columns("A").Insert
977225589 | 532 | [EMAIL];[EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | For i = LR To 1 Step -1
978472614 | 276 | [EMAIL];[EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | With Range("B" & i)
977402692 | 257 | [EMAIL];[EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If InStr(.Value, ",") = 0 Then
977313572 | 1154 | [EMAIL];[EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .Offset(, -1).Value = .Value
977225774 | 541 | [EMAIL];[EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Else
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X = Split(.Value, ",")
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .Offset(1).Resize(UBound(X)).EntireRow.Insert
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .Offset(, -1).Resize(UBound(X) - LBound(X) + 1).Value = Application.Transpose(X)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End If
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End With
After |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Next i
account_no | BAL | Mail IDs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Columns("B").Delete
977265891 | 1865 | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LR = Range("A" & Rows.Count).End(xlUp).Row
977265891 | 1865 | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | With Range("B1:C" & LR)
977356854 | 346 | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On Error Resume Next
977356854 | 346 | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[-1]C"
978433979 | 699 | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On Error GoTo 0
978433979 | 699 | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .Value = .Value
977653720 | 427 | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End With
977653720 | 427 | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Application.ScreenUpdating = True
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End Sub
Spreadsheet: 108871d1305818521-does-a-particular-number-appear-workbook26
Sheet: Sheet1

0 | 5 | 4
6 | 7 | 4 | YES |  | LOOKING FOR ANY 3, 6 OR 9'S
8 | 8 | 7
0 | 8 | 6
1 | 7 | 8 | NO
5 | 6 | 8
5 | 0 | 2
8 | 1 | 9 | YES
2 | 8 | 3
2 | 1 | 2
2 | 2 | 5
3 | 3 | 5
6 | 1 | 1
8 | 0 | 1
2 | 4 | 4 | NO
5 | 5 | 6
0 | 3 | 6
1 | 6 | 9 | YES
6 | 1 | 6
9 | 3 | 0
5 | 6 | 9 | YES
1 | 5 | 4
5 | 1 | 2
9 | 2 | 8
6 | 1 | 3
5 | 7 | 6
5 | 3 | 3
8 | 6 | 4
2 | 7 | 9
3 | 1 | 4
5 | 2 | 2
0 | 2 | 0
8 | 5 | 7 | NO
0 | 8 | 9
2 | 4 | 0
2 | 7 | 5 | NO
Spreadsheet: 813eacd2-1f9f-47ef-94f7-cbbbad8dd34e
Sheet: Sheet1

Supplemental Table 3 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
vs A2_1RKPM |  |  |  | vs Background
Database | PWM | p-value |  | Database | PWM | p-value
Jaspar | ZNF354 | 7.30851377144e-13 |  | Jaspar | ZNF354 | 1.02096640952e-11
Jaspar | YY1 | 2.72842883351e-11 |  | Jaspar | Myb | 4.94381124735e-10
Jaspar | Arnt-Ahr | 2.64637823846e-05 |  | Jaspar | Arnt-Ahr | 8.13199271041e-09
Jaspar | ELF5 | 0.000489884723512 |  | Jaspar | TFAP2A | 6.21441700242e-08
Jaspar | BRAC1 | 0.000901443728836 |  | Jaspar | Fos | 1.35920783231e-06
Jaspar | Fos | 0.00680574105268 |  | Jaspar | [NAME] | 1.79367248387e-05
Jaspar | USF1 | 0.0079072335067 |  | Jaspar | Klf4 | 0.000218357590825
Transfac | GEN_INI3_B | 4.6829670601e-18 |  | Jaspar | USF1 | 0.000624334885937
Transfac | GEN_INI2_B | 3.39275478634e-17 |  | Jaspar | Arnt | 0.00131897922786
Transfac | GEN_INI_B | 5.92229223629e-14 |  | Jaspar | Mycn | 0.00218362547642
Transfac | [NAME] | 2.41460117156e-12 |  | Transfac | GEN_INI3_B | 7.7511630285e-32
Transfac | AR_Q6 | 2.73290399853e-10 |  | Transfac | AR_Q6 | 4.14737406106e-29
Transfac | AP2REP_01 | 6.75926714726e-10 |  | Transfac | GEN_INI2_B | 5.85901296314e-29
Transfac | EBOX_Q6_01 | 5.62336582716e-08 |  | Transfac | GEN_INI_B | 5.64503875681e-24
Transfac | SMAD_Q6 | 1.44619964645e-07 |  | Transfac | [NAME] | 4.61305197322e-23
Transfac | KID3_01 | 1.83068649973e-07 |  | Transfac | P53_02 | 1.49047364363e-21
Transfac | MOVOB_01 | 3.48300612374e-07 |  | Transfac | AP2REP_01 | 4.23908860835e-18
Transfac | ETS_Q6 | 5.63224591718e-07 |  | Transfac | RFX_Q6 | 5.92270518029e-18
Transfac | USF2_Q6 | 1.6566013334e-06 |  | Transfac | P53_DECAMER_Q2 | 1.04990109049e-11
Transfac | AML1_01 | 5.62292758159e-06 |  | Transfac | LEF1_Q2 | 4.62165960047e-11
Transfac | PU1_Q6 | 7.00999036622e-06 |  | Transfac | AP4_Q6_01 | 5.76023362846e-11
Transfac | SREBP2_Q6 | 1.03198234663e-05 |  | Transfac | AP1_Q6_01 | 3.71142113434e-10
Transfac | AML1_Q6 | 1.45582519122e-05 |  | Transfac | AP1_Q4_01 | 1.4591307347e-09
Transfac | PEA3_Q6 | 1.68561841169e-05 |  | Transfac | AML1_01 | 2.28026996066e-09
Transfac | AP4_Q6_01 | 6.74066028985e-05 |  | Transfac | ER_Q6_02 | 6.51774151273e-09
Transfac | CHCH_01 | 8.33157931107e-05 |  | Transfac | SMAD_Q6_01 | 3.31186142718e-07
Transfac | RFX_Q6 | 9.93886473846e-05 |  | Transfac | USF2_Q6 | 6.06273550314e-07
Transfac | P53_DECAMER_Q2 | 0.000656786743771 |  | Transfac | SMAD_Q6 | 1.04423650658e-06
Transfac | YY1_Q6_02 | 0.000699368985336 |  | Transfac | SREBP2_Q6 | 1.24135892753e-05