tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 830550d1684968796-convert-count-comma-separated-values-into-columns-with-boolean-values-example_optionlist
Sheet: Sheet1

Source | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
1
1
2
2,3
1,3
3
2,3
1,4
2,3,11
2,3,4
1,5
3,5
2,4,5
1,9,10
3,11
Result should look like…
Source | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2.3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1.3 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2.3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1,4 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2,3,11 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
2,3,4 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1.5 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
3.5 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
2,4,5 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
1,9,10 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
3.11 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
Spreadsheet: 165634d1341308507-lock-protect-another-cell-a-range-of-cells-for-specific-value-of-one-cell-development_swing-ticket-20120703_beta
Sheet: SwingTicketOrderForm

Ship To Name |  |  |  |  |  |  | Contact
Address 1 |  |  |  |  |  |  | Phone
Address 2 |  |  |  |  |  |  | Fax
Address 3 |  |  |  |  |  |  | [NAME]
City |  |  |  |  |  |  | Order Date: |  | 2012-06-01 00:00:00
State |  |  |  |  |  |  | Ship Method: |  | REGULAR
Zip |  | 000000 |  |  |  |  | Date Required:
Country |  | ANTARCTICA |  |  |  |  | Total Order Qty: |  | 32
Department No. |  | T32 Shapewear & Separates |  |  |  |  | Stroke No. |  | 5089
[NAME] |  | DIR FOOK WAH CHINA |  |  |  |  | Supplier No. |  | 05254
Lead Factory |  |  | ABC Factory
Contract Number |  |  | 1063710
Ticket/Label Name |  |  | ST/L2101OT - Standard Barcode Swing Ticket
Country of Origin |  |  | China
Line# | Colour |  | Primary Size |  | Pantone | Secondary [NAME] |  | UPC |  | [NAME] |  |  | Part Set | MSRP (GBP) | Qty
1 | T2 - BLUE MIX |  | 8 |  | 2716C | SHORT FIT |  | 86535763 |  | Story Desc Test |  |  |  | 99.99 | 20
2 | T2 - BLUE MIX |  | 30 |  | 702C | MEDIUM/LONG |  | 77987689 |  |  |  |  | 2 |  | 12
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: a984cf02-7510-4d84-b18e-4f9086984606
Sheet: QTD Recon Q3FY11

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended December 31, 2010
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Restructuring Charges |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 1053 |  | 0 |  | 357 |  | 0 |  | 0 |  | 0 |  | 1410
Cost of goods sold | 586 |  | -3 |  | 0 |  | 0 |  | -1 |  | 0 |  | 582
Gross profit | 467 |  | 3 |  | 357 |  | 0 |  | 1 |  | 0 |  | 828
Operating expenses:
Marketing and sales | 253 |  | 0 |  | 0 |  | 0 |  | -6 |  | 0 |  | 247
General and administrative | 75 |  | 0 |  | 0 |  | 0 |  | -10 |  | 0 |  | 65
Research and development | 273 |  | 0 |  | 0 |  | 0 |  | -29 |  | 0 |  | 244
Acquisition-related contingent consideration | 1 |  | -1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 14 |  | -14 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring charges | 154 |  | 0 |  | 0 |  | -154 |  | 0 |  | 0 |  | 0
Total operating expenses | 770 |  | -15 |  | 0 |  | -154 |  | -45 |  | 0 |  | 556
Operating income (loss) | -303 |  | 18 |  | 357 |  | 154 |  | 46 |  | 0 |  | 272
Interest and other income, net | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Income (loss) before provision for income taxes | -303 |  | 18 |  | 357 |  | 154 |  | 46 |  | 0 |  | 272
Provision for income taxes | 19 |  |  |  |  |  |  |  |  |  | 57 |  | 76
Net income (loss) | -322 |  | 18 |  | 357 |  | 154 |  | 46 |  | -57 |  | 196
Loss per share |  |  |  |  |  |  |  |  | Earnings per share
Basic and diluted | -0.97 |  |  |  |  |  |  |  | Basic |  |  |  | 0.59
 |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.59
Number of shares used in computation |  |  |  |  |  |  |  |  | Number of shares used in computation
Basic and diluted | 332 |  |  |  |  |  |  |  | Basic |  |  |  | 332
 |  |  |  |  |  |  |  |  | Diluted |  |  |  | 335
Spreadsheet: 888531d1739035481-update-needed-to-formula-to-only-show-data-for-month-example
Sheet: YTD Survey Data

Exclude Survey "Yes or No" | Notes from CM Review | [NAME] or Replaced | Roof Decision Correct? | Estimator | Claim # | Cat Code | [NAME] | Sub Peril | [NAME] | Zip Code | County | City | Survey Month Completed | CSAT Answer | Call back requested | Comments
No |  | N/A | N/A | [NAME] |  | 2472CO | Wind | [NAME] | MD | 21222-1114 | BALTIMORE | BALTIMORE | 2025-01 | Somewhat satisfied | No |  |  |  | Yes |  | Replaced
No |  | N/A | N/A | [NAME] |  | 2477AL | Wind | Hurricane | GA | 31798-4011 | [NAME] | WRAY | 2025-01 | Extremely satisfied | No |  |  |  | No | Not Handled by Rep | Repaired
No |  | N/A | N/A | [NAME] |  | 2477AL | Wind | Hurricane | GA | 31023-5613 | DODGE | EASTMAN | 2025-01 | Extremely satisfied | No |  |  |  | N/A | Proper [NAME], but insured not happy with settlement | N/A
No |  | Repaired | Yes | [NAME] |  | 2484AL | Wind | Tropical Storm | MS | 39047-4514 | RANKIN | BRANDON | 2025-01 | Extremely dissatisfied | Yes, from a manager |  |  |  |  | Result of DA handling
No |  | Repaired | Yes | [NAME] |  | ASIGEN | Wind | [NAME] | OH | 44089 | ERIE | VERMILION | 2025-01 | Extremely satisfied | No |  |  |  |  | Result of Supplement handling
No |  | Repaired | Yes | [NAME] |  | 2484AL | Wind | [NAME] | TX | 77357-2643 | MONTGOMERY | NEW CANEY | 2025-01 | Somewhat dissatisfied | No
No | ITEL repair report used | Repaired | Yes | [NAME] |  | 2484AL | Wind | [NAME] | MS | 39044-2938 | SIMPSON | BRAXTON | 2025-01 | Somewhat dissatisfied | Yes, from my representative
No |  | N/A | N/A | [NAME] |  | ASIGEN | Water | Flood | OH | 44450-9703 | TRUMBULL | NORTH BLOOMFIELD | 2025-01 | Somewhat satisfied | No
No |  | N/A | N/A | [NAME] |  | ASIGEN | Water | Water Backup Overflow | OH | 44067-3048 | SUMMIT | NORTHFIELD | 2025-01 | Extremely satisfied | No
Yes | Not Handled by Rep | N/A | N/A | [NAME] |  |  | Water | Water Backup Sewer | OH | 44425-3106 | TRUMBULL | HUBBARD | 2025-01 | Somewhat dissatisfied | No
Yes | Not Handled by Rep | N/A | N/A | [NAME] |  | 2484AL | Wind | Tornado | TX | 77357-2644 | MONTGOMERY | NEW CANEY | 2025-02 | Extremely dissatisfied | No
No |  | Repaired | Yes | [NAME] |  | 2484AL | Wind | Tornado | TX | 77357-2644 | MONTGOMERY | NEW CANEY | 2025-02 | Extremely dissatisfied | No
No |  | Repaired | Yes | Ricardo Herrera |  | 2478FL | Wind | Hurricane | FL | 33884-1331 | POLK | Winter Haven | 2025-02 | Extremely dissatisfied | Yes, from a manager
Spreadsheet: 127046d1320147724-excel-2007-how-to-populate-a-cell-via-various-selections-from-two-other-cells-transport-control-sheet-test-working-1
Sheet: Transport costing October 2011

2011-10-01 00:00:00
 | Toll |  | Region |  | Border Express |  | StarTrack |  | TNT |  | [NAME]
Trip | [NAME] | Rate | [NAME] | Rate | [NAME] | Rate | [NAME] | Rate | [NAME] | Rate | [NAME] | Rate
Melbourne to Sydney | 0.12 | 2000 | 0 | 1 | 0.115 | 10 | 0 | 50 | 0 | 90 | 0.5 | 130
Melbourne to Adelaide | 0.12 | 1800 | 0.1 | 2 | 0 | 20 | 0 | 60 | 0 | 100 | 0.1 | 140
Melbourne to Brisbane | 0.12 | 0 | 0 | 3 | 0.126 | 30 | 0 | 70 | 0 | 110 | 0 | 10000
Melbourne to Perth | 0.12 | 0 | 0 | 4 | 0 | 40 | 0 | 80 | 0 | 120 | 0 | 20000
Sydney to Melbourne | 0.065 | 1300 | 0 | 5 | 0 | 41 | 0 | 3 | 0 | 4 | 0.01 | 2100
Sydney to Adelaide | 0.065 | 3000 | 0 | 6 | 0 | 42 | 0 | 0 | 0 | 0 | 0 | 0
Sydney to Brisbane | 0.065 | 2000 | 0 | 7 | 0 | 43 | 0 | 0 | 0 | 0 | 0 | 0
Adelaide to Melbourne | 0 | 0 | 0.106 | 849.91 | 0 | 44 | 0 | 0 | 0 | 0 | 0 | 0
Adelaide to Sydney | 0 | 0 | 0 | 0 | 0 | 45 | 0 | 0 | 0 | 0 | 0 | 0
Adelaide to Perth | 0 | 0 | 0 | 0 | 0 | 46 | 0 | 0 | 0 | 0 | 0 | 0
Brisbane to Melbourne | 0 | 0 | 0 | 0 | 0 | 47 | 0 | 0 | 0 | 0 | 0 | 0
PM Melb to Nhill | 0 | 0 | 0 | 0 | 0 | 48 | 0 | 0 | 0 | 0 | 0 | 0
PM Melb to Tarcutta | 0 | 0 | 0 | 0 | 0 | 49 | 0 | 0 | 0 | 0 | 0 | 0
PM Melb to [NAME] | 0 | 0 | 0 | 0 | 0 | 49.1 | 0 | 0 | 0 | 0 | 0 | 0
PM Melb to Bordertown | 0 | 0 | 0 | 0 | 0 | 49.2 | 0 | 0 | 0 | 0 | 0 | 0
PM Melb to Holbrook | 0 | 0 | 0 | 0 | 0 | 49.3 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 49.4 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 49.5 | 0 | 0 | 0 | 0 | 0 | 0
NOTE: DO NOT MODIFY COSTINGS. MODIFYING THE COSTS ON THIS WORKSHEET WILL ALSO UPDATE THE COST ON THE DAILY BOOKINGS WORKSHEET FOR THE WHOLE MONTH.
Spreadsheet: 78338d1278696949-index-match-lookup-thru-multiple-columns-sample
Sheet: Weekly Total

 | Packaging Line "A" |  |  |  |  |  |  |  |  |  | Packaging Line "B" |  |  |  |  |  |  |  |  |  | L&G Packing
 | Packaging Date |  | [NAME] to pack |  | # of kits expected to pack |  | Actual Units Packed |  | Employees |  | Packaging Date |  | [NAME] to pack |  | # of kits expected to pack |  | Actual Units Packed |  | # of Employees needed |  | Packaging Date |  | [NAME] to pack |  | # of kits expected to pack |  | Actual Units Packed |  | # of Employees needed
 | 2010-07-05 00:00:00 |  | Captain's Loft II #3272 |  |  |  | 36 |  |  |  | 2010-07-05 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-05 00:00:00
 | 2010-07-06 00:00:00 |  | Costco (2009) Box #3200 |  |  |  | 6 |  |  |  | 2010-07-06 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-06 00:00:00 |  | Captain's Loft II #3272 |  |  |  | 366
 | 2010-07-07 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-07 00:00:00 |  | Captain's Loft II #3272 |  |  |  | 96 |  |  |  | 2010-07-07 00:00:00
 | 2010-07-08 00:00:00 |  | Captains Loft II #3272 |  |  |  | 36 |  |  |  | 2010-07-08 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-08 00:00:00
 | 2010-07-09 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-09 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-09 00:00:00
 | 2010-07-10 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-10 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-10 00:00:00
 | 2010-07-12 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-12 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-12 00:00:00
 | 2010-07-13 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-13 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-13 00:00:00
 | 2010-07-14 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-14 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-14 00:00:00
 | 2010-07-15 00:00:00 |  | Captains Loft II #3272 |  |  |  | 96 |  |  |  | 2010-07-15 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-15 00:00:00
 | 2010-07-16 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-16 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-16 00:00:00
 | 2010-07-17 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-17 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-17 00:00:00
 | 2010-07-19 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-19 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-19 00:00:00
 | 2010-07-20 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-20 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-20 00:00:00
 | 2010-07-21 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-21 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-21 00:00:00
 | 2010-07-22 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-22 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-22 00:00:00
 | 2010-07-23 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-23 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-23 00:00:00
 | 2010-07-24 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-24 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-24 00:00:00
Spreadsheet: 05a736a3-7b5a-4238-a833-54cfdb7dca6c
Sheet: Exhibit XVII, Sheet 5, pg 2

Owners Forms
USAA-CIC
Pennsylvania
Claims, Losses, & Expense Summary
 |  | Paid Loss & LAE
 |  | (incl [NAME])
Accident Year | as of | 15 Months | 27 Months | 39 Months | 51 Months
2001-06-30 00:00:00 |  | 3170880 | 3847614 | 3956456 | 4030352
2002-06-30 00:00:00 |  | 3376932 | 3710809 | 3886191 | 3938337
2003-06-30 00:00:00 |  | 3947533 | 4450754 | 4488243 | 4556462
2004-06-30 00:00:00 |  | 5348660 | 6387143 | 7068846 | 7096905
2005-06-30 00:00:00 |  | 7709265 | 8747799 | 8434729 | 8970657
2006-06-30 00:00:00 |  | 6190310 | 7161211 | 7569637 | 7788990
2007-06-30 00:00:00 |  | 7291545 | 8074454 | 8258189 | 8303555
2008-06-30 00:00:00 |  | 9681719 | 10648074 | 10912952 | 11168362
2009-06-30 00:00:00 |  | 9572691 | 10569867 | 11165159 | 11343100
2010-06-30 00:00:00 |  | 15508373 | 18304802 | 18864155
2011-06-30 00:00:00 |  | 12767611 | 15957022
2012-06-30 00:00:00 |  | 16931254
 |  | Paid Loss & LAE
 |  | (excl [NAME])
Accident Year | as of | 15 Months | 27 Months | 39 Months | 51 Months
2001-06-30 00:00:00 |  | 3033673 | 3686745 | 3795347 | 3869243
2002-06-30 00:00:00 |  | 3311004 | 3637432 | 3811782 | 3863927
2003-06-30 00:00:00 |  | 3520167 | 3985771 | 4023260 | 4091479
2004-06-30 00:00:00 |  | 4322039 | 5168299 | 5821946 | 5850006
2005-06-30 00:00:00 |  | 6905731 | 7894915 | 7581845 | 8117772
2006-06-30 00:00:00 |  | 5645933 | 6572422 | 6978942 | 7198296
2007-06-30 00:00:00 |  | 6335657 | 7103977 | 7287472 | 7326951
2008-06-30 00:00:00 |  | 9403431 | 10326372 | 10591212 | 10846622
2009-06-30 00:00:00 |  | 8925134 | 9762878 | 10255388 | 10432458
2010-06-30 00:00:00 |  | 10655608 | 11842874 | 12205014
2011-06-30 00:00:00 |  | 11023250 | 13476679
2012-06-30 00:00:00 |  | 12594681
Spreadsheet: 707684d1607422309-excel-2016-vlookup-issue-with-dropdown-raid-log
Sheet: Risks

2
RISKS
Risk No. | Date Identified | Description | Type | Probability | Impact | [NAME] | Preventative Actions | Contingent Actions | Owner | Actions by | Target  Date | Status | Notes
1 | 2020-12-03 00:00:00 | Development costs are currently estimates only
2 | 2020-12-03 00:00:00 | 1500 pilot service users may not be available for launch
3 | 2020-12-03 00:00:00 | [NAME] capability unknown.  Requirement is to initiate in app calls for service users, its currently unknown if this is possible or what the cost of same will be
4 | 2020-12-03 00:00:00 | Google Nest Development may not be available
5 | 2020-12-07 00:00:00 | PM Availability for Soft Launch | Operational | Likely | Moderate | Medium |  | PM Works Remotely |  |  |  |  | PM May need to take Paternity Leave in May/June 2021
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
Spreadsheet: 818471d1676865837-allocate-amount-by-matching-month-s-with-percentages-distribution-by-month-by-percentage
Sheet: Sheet1

 |  |  | At Month | 2 Months After | 4 Months After | 8 Months After
 |  |  | 0.1 | 0.2 | 0.3 | 0.4
 | Amount | Start |  | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00
 |  | 2023-01-31 00:00:00
 | 130 | 2023-04-30 00:00:00
 | 1000 | 2023-02-28 00:00:00
 | 398 | 2023-06-30 00:00:00
Spreadsheet: 485247d1476796937-conditional-formatting-help-please-available-cross-comparison-sheet
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | once a number is put place black every other cell before or after and highlight in "red" numbers if any other numbers are shown
 |  |  |  |  |  |  |  |  | highlight any row where there is no number put in
 | Project | Owner | Funds available |  |  | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2016 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00 | 2017 | QA
 | Location1 | Apple | -50000 |  |  | 50000
 | Location1 | Apple | -50000 |  |  |  |  | 50000
 | Location1 | [NAME] | -50000 |  |  |  |  | 10000
 | Location3 | Orange | 20000 |  |  |  |  | 90000
 | Location3 | Kiwi | 20000 |  |  |  |  |  |  | 90000
 | Location11 | Brownie | 30000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20000
 | Location11 | Hot Cakes | 30000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15000
 | [NAME] | [NAME] | 700000 |  |  |  |  |  |  |  |  | 40000
 | Location8 | [NAME] | 1000 |  |  |  |  |  |  |  |  | 1000
 | Location9 | Coco |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 700000
 | Location10 | Vinalla |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9000
 | Location12 | Carmel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100000
 | Location2 | Brownie |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90000
 | Location2 | Brownie |  |  |  |  | 3000
 | Location2 | Brownie |  |  |  |  |  |  | 84500
 | Location2 | Brownie |  |  |  |  |  |  | 43234
 | Location13 | Blueberry |  |  |  |  |  |  |  |  | 3000
 | Location13 | Blueberry |  |  |  |  |  |  |  |  | 23434
 | Location13 | Blueberry |  |  |  |  |  |  |  |  |  |  | 9000
 | Location13 | Blueberry |  |  |  |  |  |  |  | 40000
 | Location13 | Pie |  |  |  |  |  |  |  |  |  |  |  |  |  | 60000
 | Location13 | Pie |  |  |  |  |  |  |  |  |  |  |  |  |  | 60000
 | Location4 | Cinnamon |  |  |  |  |  |  |  |  |  |  |  |  |  | 60000
 | Location4 | Cinnamon |  |  |  |  |  |  |  |  |  |  |  |  |  | 5700
 | Location4 | Pie |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50000
 | Location4 | Pie |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40000
 | Location4 | Blueberry |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500000
Spreadsheet: 728014d1618248641-moving-letters-from-the-middle-of-digits-example
Sheet: Example data

7.15 | 7.15 | 22.45 | 23.3 | 23.4 | 23.45
7.18 | 7.18 | 22.48 | 23.33 | 23.43 | 23.48
. . | . . | . . | . . | . . | . .
7.24 | 7.24 | 22.54 | 23.39 | 23.49 | 23.54
7.4 | 7.4 | 23.1 | 23.56 | . . | 0.1
. . . . | . . . . | . . . . | . . . . | . . . . | . . . .
7.5 | 7.5 | 23.2 | 0.06 | 0.13 | 0.2
. . . . | . . . . | . . . . | 0.12 | . . . . | . . . .
7.58 | 7.58 | 23.28 | 0.16 | 0.21 | 0.28
8 | 8 | 23.29 | 0.17 | 0.22 | 0.29
8.06 | 8.06 | 23.35 | 0.24 | . . | 00s35
8.09 | 8.09 | 23.39 | 0.28 | . . . . | 0.4
8.1 | 8.1 | 23.4 | . . | . . | 0.41
8.15 | 8.15 | 23s45 | . . . . | . . . . | 00s45
8.2 | 8.2 | 23s49 | . . | . . | 00s50
8.26 | 8.26 | 23s56 | . . . . | . . . . | 00s56
8.3 | 8.3 | 23s59 | . . | . . | 01s01
8.34 | 8.34 | 00s04 | . . . . | . . . . | 01s05
8.42 | 8.42 | 00s12 | . . | . . | 01s13
8.46 | 8.46 | 00s16 | . . . . | . . . . | 01x17
8.52 | 8.52 | 00s21 | . . | . . | 01x22
Spreadsheet: 685906d1594261158-can-someone-help-me-create-a-count-in-column-d-of-different-numbers-in-colum-c-roulette-system
Sheet: Blad1

 |  |  | [NAME].
Spin Number | Spin Result | Total Unhit Nrs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: e81b5e50-33aa-43d1-8e3f-e33e37f9277c
Sheet: Sheet1

mutation | number of programs | [NAME] | validated ? (1=yes, 0=no, -1=inconclusive) | Validated by [NAME] sequencing | Validated by RNA-Seq | [NAME] | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
chr10:7309982 | 1 | 0.1-0.2 | 1 | yes |  | 0.15263498 |  | number of programs | number of validated mutations per program category
chr2:143814359 | 1 | 0.1-0.2 | 0 |  |  | 0.196579776 |  | 1 | 3
chr4:115001564 | 1 | 0.1-0.2 | 0 |  |  | 0.196579776 |  | 2 | 4
chr1:172898154 | 1 | 0.2-0.3 | 0 |  |  | 0.258860137 |  | 3 | 8
chr12:86315114 | 1 | 0.2-0.3 | 0 |  |  | 0.258860137
chr5:87894457 | 1 | 0.2-0.3 | 0 |  |  | 0.260020474
[NAME] | 1 | 0.3-0.4 | 0 |  |  | 0.384279447 |  | [NAME] | number of validated mutations per [NAME]
chr16:59329156 | 1 | 0.3-0.4 | 0 |  |  | 0.384279447 |  | 0.1-0.2 | 4
chr2:166401264 | 1 | 0.3-0.4 | 1 | yes |  | 0.384279447 |  | 0.2-0.3 | 0
chr1:36996142 | 1 | 0.4-0.5 | -1 |  |  | 0.407170814 |  | 0.3-0.4 | 5
[NAME] | 1 | 0.4-0.5 | 0 |  |  | 0.407170814 |  | 0.4-0.5 | 6
chr12:4107898 | 1 | 0.4-0.5 | 1 |  | yes | 0.407170814 |  | 0.5-0.6 | 1
chr13:49242592 | 1 | 0.5-0.6 | -1 |  |  | 0.524538509
[NAME] | 1 | 0.5-0.6 | 0 |  |  | 0.524538509
chr11:78364096 | 1 | 0.5-0.6 | 0 |  |  | 0.524538509
[NAME] | 2 | 0.1-0.2 | 1 |  | yes | 0.15263498
chr12:29334505 | 2 | 0.1-0.2 | -1 |  |  | 0.155719987
chr2:54732484 | 2 | 0.1-0.2 | 0 |  |  | 0.190394511
[NAME] | 2 | 0.2-0.3 | 0 |  |  | 0.211125898
chr9:109778461 | 2 | 0.2-0.3 | -1 |  |  | 0.258860137
chr15:101293986 | 2 | 0.2-0.3 | 0 |  |  | 0.258860137
chr11:109652956 | 2 | 0.3-0.4 | 0 |  |  | 0.306949659
chr8:73304304 | 2 | 0.3-0.4 | 1 |  | yes | 0.306949659
chr5:104888831 | 2 | 0.3-0.4 | -1 |  |  | 0.398243044
chr10:116813997 | 2 | 0.4-0.5 | -1 |  |  | 0.407170814
chr4:130037447 | 2 | 0.4-0.5 | 0 |  |  | 0.407170814
chr5:28493156 | 2 | 0.4-0.5 | 1 | yes | yes | 0.407170814
chr17:32768505 | 2 | 0.5-0.6 | 0 |  |  | 0.524538509
chr5:117565778 | 2 | 0.5-0.6 | 1 |  | yes | 0.524538509
chr9:98856813 | 2 | 0.5-0.6 | -1 |  |  | 0.566177089
chr13:21575766 | 3 | 0.1-0.2 | 1 | yes |  | 0.128325951
chr4:138990033 | 3 | 0.1-0.2 | 1 |  | yes | 0.131525671
chr16:43871852 | 3 | 0.1-0.2 | 0 |  |  | 0.15263498
chr7:110709904 | 3 | 0.2-0.3 | -1 |  |  | 0.284157833
chr1:154671388 | 3 | 0.2-0.3 | 0 |  |  | 0.284157833
chr4:151534480 | 3 | 0.2-0.3 | 0 |  |  | 0.284157833
chr17:30823395 | 3 | 0.3-0.4 | 1 | yes |  | 0.305451314
chr7:125321913 | 3 | 0.3-0.4 | 1 | yes | yes | 0.306949659
chr19:37061108 | 3 | 0.3-0.4 | 1 | yes | yes | 0.306949659
chr5:138038195 | 3 | 0.4-0.5 | 1 |  | yes | 0.407170814
chr1:187235084 | 3 | 0.4-0.5 | 1 |  | yes | 0.407170814
chr2:111098016 | 3 | 0.4-0.5 | 1 | yes |  | 0.524156321
chr5:82075712 | 3 | 0.5-0.6 | 0 |  |  | 0.535315981
chr2:92208002 | 3 | 0.5-0.6 | 0 |  |  | 0.535315981
chr6:22974726 | 3 | 0.5-0.6 | 0 |  |  | 0.535559551