tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 124f8d6e-23eb-4709-bbaa-5063d39e60ed
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-02-04 09:19:16.980000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.706 | 102.581 | 102.456 | 102.081
4.5 | 102.055 | 101.93 | 101.805 | 101.43 |  | Note: | Refer To Price [NAME]
4.375 | 101.259 | 101.134 | 101.009 | 100.634 |  |  | For all Price Adjs
4.25 | 100.707 | 100.582 | 100.457 | 99.832
4.125 | 99.908 | 99.783 | 99.658 | 99.033
4 | 98.923 | 98.798 | 98.673 | 98.048
3.875 | 97.892 | 97.767 | 97.642 | 97.017
3.75 | 97.017 | 96.892 | 96.767 | 96.142
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.815 | 102.69 | 102.565 | 102.19
3.75 | 102.436 | 102.311 | 102.186 | 101.811
3.625 | 102.036 | 101.911 | 101.786 | 101.411
3.5 | 101.462 | 101.337 | 101.212 | 100.587
3.375 | 100.709 | 100.584 | 100.459 | 99.834
3.25 | 99.906 | 99.781 | 99.656 | 99.031 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-02-18 09:19:16.980000
30 DAY | 2014-03-05 09:19:16.980000
45 DAY | 2014-03-20 09:19:16.980000
60 DAY | 2014-04-04 09:19:16.980000
90 DAY | 2014-05-04 09:19:16.980000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 24315d1214500704-linking-adjacent-cells-to-each-other-nms2130sample
Sheet: Sheet1

Linked =A6 in another sheet | Vlookup(A6,alternate table,2,false) | Needs to be typed in somewhere
Phone | Name | Notes
6555222 | NICK
6555235 | NICK
6555248 | NICK
6555261 | NICK |  |  | the problem is that when new phone numbers are added in the "alternate sheet" the position of the phone numbers and names no longer matches up with the notes.  The names and numbers do not come in sorted nor can they be sorted in the alternate sheet.
6555274 | NICK
6555287 | NICK
6555300 | NED
6555313 | NED
6555326 | NED
6555339 | NED
6555352 | [NAME]
6555365 | [NAME]
6555378 | [NAME]
6555391 | [NAME]
6555404 | [NAME]
6555417 | MARY
6555430 | MARY
6555443 | MARY
6555456 | OSCAR
6555469 | OSCAR
6555482 | OSCAR
6555495 | OSCAR
6555508 | OSCAR
Spreadsheet: 797481d1663918550-sum-of-product-sales-from-start-month-to-end-month-2022-09-23-oeldere-josephteh-sum-of-product-sales-from-start-month-to-end-month
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | <- select start month
Product Sales | 01-2022 | 02-2022 | 03-2022 | 04-2022 | 05-2022 | 06-2022 |  | Product Sales | 2022-04-01 00:00:00 | <- select end month
Product Sales 1 | 568 | 323 | 848 | 366 | 411 | 500 |  | Product Sales 1
Product Sales 2 | 887 | 992 | 422 | 391 | 667 | 757 |  | Product Sales 2
Product Sales 3 | 337 | 738 | 314 | 192 | 454 | 219 |  | Product Sales 3
Product Sales 4 | 960 | 150 | 190 | 872 | 206 | 670 |  | Product Sales 4
Product Sales 5 | 770 | 794 | 188 | 404 | 990 | 906 |  | Product Sales 5
Product Sales 6 | 923 | 209 | 686 | 559 | 906 | 709 |  | Product Sales 6
Product Sales 7 | 317 | 350 | 781 | 667 | 399 | 124 |  | Product Sales 7
Product Sales 8 | 980 | 715 | 590 | 717 | 544 | 107 |  | Product Sales 8
Product Sales 9 | 140 | 973 | 837 | 713 | 939 | 933 |  | Product Sales 9
Product Sales 10 | 181 | 204 | 850 | 746 | 296 | 224 |  | Product Sales 10
Product Sales 11 | 503 | 304 | 275 | 595 | 841 | 752 |  | Product Sales 11
Spreadsheet: 740935d1626707376-separate-address-into-separate-lines-within-a-cell-addresses-copy
Sheet: Sheet1

 | 1234 Anydrive Dr. [NAME], AT 12345 | 1234 Anydrive Dr.   Anytown, AT 12345
Beverly Bowers | 5410 Raven Dr.  Charleston, WV 25306
[NAME] | 24 Macconnachy Sq.  Baltimore, MD 21207
[NAME] | 332 [NAME][NAME], MD 21146
[NAME] | 336 [NAME][NAME], MD 21146
Felix & Danette Padilla | 114 Daventry Ln.  Warner Robins, GA 31088
[NAME] | 2430 Lake Worth Rd. Apt. 3106  Lake Worth, FL 33461
[NAME] | 1550 [NAME]Shadyside, MD 20764-4503
[NAME] | 18435 Shanna Dr.  Accokeek, MD 20607
Hakim & Leslie Rashid | 104 Valley View Dr.  Coatesville, PA 10320
Harry & Zakiya Allen | 10306 Prince [NAME] Marlboro, MD 20772
Husain & Nikki Rashid | 1515 Baby Baer Ct  [NAME], MD 21061
[NAME] | 3603 Hannan Rd.  Apt. 108  Wayne, MI  48184
[NAME] | 5327 Raven Dr.  Charleston, WV 25306-6246
[NAME] | 5528 Channing Rd  Baltimore, MD 21229
[NAME] | 1226 12th St.  Nitro, WV 25143-1922
[NAME] | 338 Jennings Rd.  [NAME], MD 21146
Lawrence & Wilma Harris | 15981 Meandering Dr.  [NAME], MD 20613
[NAME] & [NAME] | 4105 Maine Ave.  Baltimore, MD 21207
[NAME] | 410 [NAME]. 401  Baltimore, MD 21244
[NAME] | 3001 Macon Ct.  The Villages, FL 32162
Nym & Vivian Kufuo | 105 Lovorn Cr  [NAME], GA 31088
[NAME] | 919 Fleming Ave.  Muskegon, MI 49442-5109
[NAME] | 530 Ridge Rd.  Fair Haven, NJ 07704
Zakiyyah Rashid | 7466 E. Furnace Branch Rd.  Apt. 316  Glen Burnie, MD 21060
Spreadsheet: 773711d1648021598-textjoin-with-multiple-if-conditions-in-same-range-textjoin-issue
Sheet: Sheet1

 | Field Name | FieldType |  | Require to Text Join Fieldnames if Field Type is "Manfatory" or "Oponal" only ignoring all blanks and other fields types. The range to select is C3:C200
 | [NAME] | Mandatory
 | Card Design | Optional |  | Single Criteria working OK
 | [NAME] | Mandatory
 | Delivery | Mandatory
 | To [NAME] | Mandatory |  | Two if criteria with following formula is not working
 | From | Optional |  | TEXTJOIN(" | ",TRUE,IF((C3:C200="Mandatory")*(C3:C200="Optional"),B3:B200,""))
 | Message | Optional
 | Quantity | Optional |  | Any suggestions?
 | Delivery Date | Optional
 | Cart Validate | Validation
 | Submit | PMandatory
 | PositiveMsg | ValidationP
 | Negative Msg | ValidationN
Spreadsheet: 723751d1615882497-excel-help-with-index-and-match-view-test-ans
Sheet: Sheet3

 | 43
Cust No | Date Of Report | Driver reporting Issue | Leader on duty | Description of Defect | Comments
Spreadsheet: richard_ring__31564__Enron_MayJune_1999
Sheet: Commnwlth

 | Commonwealth Sale
 | Commitment: |  | 30 aMW
 | Term: |  | July 15, 1999 through July 14, 2000
 | 1999 MWh Commitment:
 |  |  | Days | Hrs | Adj. * | Adj. Hrs | Energy (MWh's)
 | July |  | 17
 | August |  | 31
 | September |  | 30
 | October |  | 31 |  | 1
 | November |  | 30
 | December |  | 31
 | Total
 | * Change from DST to Standard Time
 | Summary of Resources Dedicated:
 |  |  | Black Canyon | Hills Creek | Big Cliff | Cougar | [NAME] | [NAME] | Monthly Subtotal
 |  |  | (MWh) | (MWh) | (MWh) | (MWh) | (MWh) | (MWh) | (MWh)
 | Jul-99 (2nd Half)
 | 1999-08-01 00:00:00
 | 1999-09-01 00:00:00
 | 1999-10-01 00:00:00
 | 1999-11-01 00:00:00
 | 1999-12-01 00:00:00
 | Subtotals, 5 1/2 mo.:
 | Tentative Dedicated to Commonwealth:
 | Amt Dedicated: ROUNDED
 | Net Amount Undedicated
Spreadsheet: 184293d1349203576-list-data-from-cells-in-a-single-table-row-into-a-multi-column-and-multi-row-range-example_verydetailedexplainations
Sheet: Sheet with Table

Recipe Name | Sensative | Data | Ingredient | Quantity | UOM | Sensative2 | Data3 | Table Header 9 | Table Header 10 | Table Header 11 | Sensative3 | Data4 | Table Header 14 | Table Header 15 | Table Header 16 | Sensative4 | Data5 | Table Header 18
Pot Roast | No | Touchy | Potatoe | 2 | Per | No | Touchy | Roast Beef | 2 | Lbs | No | Touchy | Gravy | 1 | Pint | No | Touchy | etc…
[NAME] | No | Touchy | [NAME] | 2 | Quarts | No | Touchy | Chicken | 0.5 | Lbs | No | Touchy | [NAME] | 2 | Packs | No | Touchy | etc…
Salad | No | Touchy | Lettuce | 1 | Head | No | Touchy | Tomtatoe | 1 | Per | No | Touchy | Fave Dressing | 8 | Ounces | No | Touchy | etc…
etc… | etc… | etc… | etc… | etc… | etc… | etc… | etc… | etc… | etc… | etc… | etc… | etc… | etc… | etc… | etc… | etc… |  | etc…
 |  | The table that the above sample represents stretches across many columns and will have at least 50 rows down eventually.                                                                             THIS IS PURELY FOR DATA ENTRY
Spreadsheet: 716896d1612408747-dynamic-indirect-substitutes-all-default-to-errors-dynamic-dependent-issues-v3
Sheet: FINISHING SCHEDULE

 |  | Using Dynamic "Row" Ranges - works perfectly
 |  |  | OFFSET(ROWRANGES!$D$4,,MATCH(C11,ROWRANGES!$D$3:$F$3,)-1,COUNTA(INDEX(ROWRANGES!$D$4:$F$9,,MATCH(C11,ROWRANGES!$D$3:$F$3,))))
 |  | CATEGORY | PRODUCT | Brand | Type/Range | Type/Range
 |  | Exterior Paint | Exterior Walls | Brand B Exterior Walls | Brand B [NAME]
 |  | Using Dynamic "Column" Ranges not working.
 |  |  | D21 DropList is picking up rows 5 - 5 in Cols C, D or e , not C5:E5, C6:E6 or C7:H7.
 |  |  | OFFSET('COLRANGES'!$C$5,,MATCH(C21,COLRANGES!$B$5:$B$7,)-1,COUNTA(INDEX(COLRANGES!$C$5:$H$7,,MATCH(C21,COLRANGES!$B$5:$B$7,))))
 |  | CATEGORY | PRODUCT | Brand | Type/Range | Type/Range
 |  | Interior Paint | Internal Woodwork
 |  | Exterior Paint | Internal Woodwork
 |  | Exterior Paint | Internal Woodwork
Spreadsheet: 153576d1335964199-values-showing-up-as-letter-how-eks2
Sheet: Ark1

 | [NAME] | [NAME]
2001-08-01 00:00:00 | 7.25 | 0 |  |  | 7.25 | D
2 | 0 | 14 |  |  | 14 | V
3 | 7.25 | 0 |  |  | 0 | F
4 | 14 | 0
5 | 0 | 7.25
6 | 0 | 7.25
7 | 7.25 | 7.25
total
norm | 37 | 37
balance
Spreadsheet: 124669d1318530735-if-statement-with-absolutes-copy-of-manipulationa-1-1
Sheet: Sheet1

Measured Time | Measued Time as dec | Measured Time Rounded | Measured Dist | IF E>0 | If are = only disp one | Subtraction of sec. | [NAME] | AVG Dist/Sec | Calculated dist | Expected Calculated Dist | Continous time
00:00:00.283 | 0 | 1900-01-01 00:00:00 | 198.5 | 198.5 | 0 | 4 | 10.90000000000001 | 2.725000000000001 | 198.5 | 198.5 | 1900-01-01 00:00:00 | 1
00:00:00.283 | 0 | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 195.775 | 195.775 | 00:00:01 |  | 4 | 2.725000000000001 | 187.6 | 4 | 2.725000000000001 | 187.6
00:00:00.283 | 0 | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 193.05 | 193.05 | 00:00:02 |  | 1 | 2.300000000000011 | 189.9 | 5 | 2.725000000000001 | 187.6
00:00:03.5 | 4 | 00:00:04 | 187.6 | 187.6 | 4 | 1 | 2.300000000000011 | 2.300000000000011 | 190.325 | 190.325 | 00:00:03 | 2 | 1 | 0.9000000000000057 | 189 | 6 | 2.725000000000001 | 187.6
00:00:03.585 | 4 | 00:00:04 | 0 |  |  |  |  |  | 187.6 | 187.6 | 00:00:04 |  | 1 | 15.30000000000001 | 204.3 | 7 | 2.725000000000001 | 187.6
00:00:03.5 | 4 | 00:00:04 | 0 |  |  |  |  |  | 189.9 | 189.9 | 00:00:05 |  | 1 | 14.60000000000002 | 189.7 | 8 | 2.300000000000011 | 189.9
00:00:04.587 | 5 | 00:00:05 | 189.9 | 189.9 | 5 | 1 | 0.9000000000000057 | 0.9000000000000057 | 189 | 189 | 00:00:06 | 3 | 1 | 0.1999999999999886 | 189.5 | 9 | 0.9000000000000057 | 189
00:00:04.5 | 5 | 00:00:05 | 0 |  |  |  |  |  | 204.3 | 204.3 | 00:00:07 |  | 3 | 0.06666666666666288 | 189.3 | 12 | 15.30000000000001 | 204.3
00:00:04.5 | 5 | 00:00:05 | 0 |  |  |  |  |  | 189.7 | 189.7 | 00:00:08 |  |  |  |  | 12 | 14.60000000000002 | 189.7
00:00:06 | 6 | 00:00:06 | 189 | 189 | 6 | 1 | 15.30000000000001 | 15.30000000000001 | 189.5 | 189.5 | 00:00:09 | 4 |  |  |  | 12 | 0.1999999999999886 | 189.5
00:00:06 | 6 | 00:00:06 | 0 |  |  |  |  |  | 189.4333333333334 | 189.433333 | 00:00:10 |  |  |  |  | 12 | 0.06666666666666288 | 189.3
00:00:06 | 6 | 00:00:06 | 0 |  |  |  |  |  | 189.3666666666667 | 189.3666667 | 00:00:11 |  |  |  |  | 12 | 0.06666666666666288 | 189.3
00:00:07 | 7 | 00:00:07 | 204.3 | 204.3 | 7 | 1 | 14.60000000000002 | 14.60000000000002 | 189.3 | 189.3 | 00:00:12 | 5 |  |  |  | 12 | 0.06666666666666288 | 189.3
00:00:07 | 7 | 00:00:07 | 0 |  |  |  |  |  |  |  | 00:00:13 |  |  |  |  | 12
00:00:07 | 7 | 00:00:07 | 0 |  |  |  |  |  |  |  | 00:00:14 |  |  |  |  | 12
00:00:08 | 8 | 00:00:08 | 189.7 | 189.7 | 8 | 1 | 0.1999999999999886 | 0.1999999999999886 |  |  | 00:00:15 | 6 |  |  |  | 12
00:00:08 | 8 | 00:00:08 | 0 |  |  |  |  |  |  |  | 00:00:16 |  |  |  |  | 12
00:00:08 | 8 | 00:00:08 | 0 |  |  |  |  |  |  |  | 00:00:17 |  |  |  |  | 12
00:00:09 | 9 | 00:00:09 | 189.5 | 189.5 | 9 | 3 | 0.1999999999999886 | 0.06666666666666288 |  |  | 00:00:18 | 7 |  |  |  | 12
00:00:09 | 9 | 00:00:09 | 0 |  |  |  |  |  |  |  | 00:00:19 |  |  |  |  | 12
00:00:09 | 9 | 00:00:09 | 0
00:00:12 | 12 | 00:00:12 | 189.3 | 189.3 | 12 |  |  |  |  |  |  | 8
00:00:12 | 12 | 00:00:12
00:00:12 | 12 | 00:00:12
Spreadsheet: theresa_staab__39603__Wellstar email
Sheet: Summary

 |  | [NAME] To: |  |  | Remit To:
 |  |  |  |  |  | Verification Date:
 |  | Enron North America Corp. |  |  | Wellstar Corporation | 2001-12-17 00:00:00
 |  |  |  |  | Bank:  First National Bank of Longmont
 |  |  |  |  | ABA:  107000628 | Due Date:
 |  |  |  |  | Acct:  14-9039 | 2001-12-31 00:00:00
 |  |  |  |  |  | Payment Method:
 |  | Contact:  [NAME] |  |  | Contact:  [NAME] | Wire
 |  | Tel:  (303) 575-6485 |  |  | Tel:  (303) 280-4516 | Terms:
Enron North America Corp. |  | Fax: (303) 534-0552 |  |  | Fax: (303) 280-4523 | On or before last day of month
2001-12-17 09:40:00.320000
Delivery Period: | Contract # | Meter # / Meter Name
2001-11-01 00:00:00 | 96027277 | 0814005-Wellstar Screw #1 Discharge Mtr
 |  | 0814004-Wellstar Screw #2 Discharge Mtr
 | Index | Discount / Premium | Price/MMBtu | Mcf Quantity | MMBtu Quantity | Amount Due
11/01/01 - 11/30/01 | FOM CIG GD | -0.4654 | 1.272508286403861 | 4017.603949160236 | 3729 | 4745.1834
11/01/01 - 11/30/01 | FOM IF NGPL-Midcont. | -0.715 | 2.325 | 49124.87789378121 | 45596 | 106010.7
11/01/01 - 11/30/01 | FOM IF CIG - Rockies | -0.4924 | 0 | 0 | 0 | 0
11/01/01 - 11/30/01 | Add'l IF CIG | -0.6004 | #[NAME]! | 0 | 0 | 0
11/01/01 - 11/30/01 |  | Fuel Loss | $             0.00 | 3821.518157058556 | 3547 | $                                        0.00
11/01/01 - 11/30/01 |  |  |  | 56964 | 52872 | 110755.8834
 |  |  | TOTAL PAYMENT |  |  | 110755.8834
Spreadsheet: b3237de8-33d8-467b-b66d-b8403b4aed23
Sheet: Sheet1

Table S4. Sequence features of FL-L1s analyzed using the online L1Base program (refer to http://l1base.molgen.mpg.de/ for further details) | Unnamed: 1 | Unnamed: 2
Investigated feature | Region | Description
A. General characteristics
Ta1-nd/d | 5' UTR | Checks for the family determining [NAME]/nd deletion in the 5'UTR of the L1 Element identified.
GC content | Whole | Calculates the %GC of the L1 Element in a 50 nt window.
Intactness score |  | This score is calculated through the classifications. Every intact feature known to affect the activity are awarded with one point.
Find TSDs | Whole | Searches for target-site-duplications flanking the L1 Element. TSDs of a length greater than 10 are considered as valid TSDs.
Kimura distance | Whole | Alignes L1 Element to L1.2 and calculates [NAME] distance to L1.2.
PolyA signal | 3' UTR | Test the sequence for an intact Poly-A signal. The consensus AATAAA or AATTAAA are considered as valid signals.
Poly-A | 3' UTR | Identifies the position of the Poly-A signal and determines the length of the pure Poly-A tail, as well as the length of an estimated Poly-A tail (containing mutations). Calculates as well a Kimura distance to a pure Poly-A tail of the length of the estim
B. Promoter and transcription factor binding sites
% promoter identities | 5' UTR | Calculates percentage of promoter sequence identities to the 155 bp consensus sequence.
CPG islands | 5' UTR | Annotates CPG-islands in the L1.
SRY site 1 | 5' UTR | Checks for the presence of an intact first [NAME] binding motif in the 5'UTR of the L1 Element.
SRY site 2 | 5' UTR | Checks for the presence of an second first [NAME] binding motif in the 5'UTR of the L1 Element.
Runx3 site | 5' UTR | Checks for the presence of an intact RUNX3 binding motif in the 5'UTR of the L1 Element.
Runx3 site 2 | 5' UTR | Checks for the presence of an intact second RUNX3 binding motif in the 5'UTR of the L1 Element.
Runx3 ASP | 5' UTR | Checks for the presence of an intact RUNX3 anti-sense-promoter binding motif in the 5'UTR of the L1 Element.
[NAME] | 5' UTR | Checks for the presence of an intact YY1 binding motif at the very beginning of the L1 Element.
TF nkx-2.5 | 5' UTR | Checks the sequences for intactness of the putative nkx2-5 site.
C. Open reading frames
ORF1 %A | ORF1 | Evaluates the A-content of ORF1
ORF1 %T | ORF1 | Evaluates the T-content of ORF1
ORF1 CAI | ORF1 | Evaluates the codon adaptation index of ORF1
[NAME]A | [NAME] | Evaluates the A-content of ORF2
[NAME]T | [NAME] | Evaluates the T-content of ORF2
[NAME] | [NAME] | Evaluates the codon adaptation index of ORF1
Amino acid sequence conservation | ORFs | Checks the intactness of the amino acid residues. Mutations such as I1220M, R363G, and S1259L are known to limit retrotransposition rate.
Spreadsheet: 879465d1727006184-list-the-missing-number-in-2-columns-vice-versa-allanortiz-btk-spill-365-aligw
Sheet: Sheet1

 |  |  |  |  |  | Need formula to list numbers here | Need formula to list numbers here |  | Need formula to list numbers here | Need formula to list numbers here
Column 1 | Column 2 |  | Column 3 | Column 4 |  | Missing - what numbers in Col 1 but not Col 3 | Missing - what numbers in Col 3 but not Col 1 |  | Missing - what numbers in Col 2 but not Col 4 | Missing - what numbers in Col 4 but not Col 2
2500 | 2678 |  | 0 | 0
555 | 17856 |  | 0 | 0 |  | 456 |  |  |  | 4639
0 | 0 |  | 2500 | 2678
0 | 2678 |  | 966 | 0
649 | 0 |  | 0 | 14607
2500 | 0 |  | 0 | 2678
0 | 2678 |  | 2500 | 0
0 | 14607 |  | 649 | 0
2500 | 0 |  | 0 | 12828
966 | 0 |  | 0 | 2678
0 | 2678 |  | 2500 | 0
0 | 12828 |  | 910 | 0
456 | 0 |  | 0 | 13933
2500 | 0 |  | 0 | 2678
0 | 2678 |  | 2500 | 0
0 | 13933 |  | 597 | 0
910 | 0 |  | 0 | 3386
2500 | 0 |  | 0 | 2678
0 | 2678 |  | 2500 | 0
0 | 3386 |  | 745 | 0
597 | 0 |  | 0 | 2678
2500 | 0 |  | 0 | 16683
0 | 16683 |  | 2500 | 0
0 | 2678 |  | 815 | 0
745 | 0 |  | 0 | 5038
2500 | 0 |  | 0 | 2678
0 | 5038 |  | 2500 | 0
0 | 2678 |  | 924 | 0
2500 | 0 |  | 0 | 14797
815 | 0 |  | 0 | 750
924 | 14797 |  | 0 | 0
2500 | 0 |  | 0 | 4639
0 | 0 |  | 2500 | 2678
0 | 2678 |  | 796 | 0
Diff |  |  |  |  |  | Diff |  |  | Diff
Spreadsheet: 119353d1314348304-help-with-function-to-interleave-2-columns-to-1-row-with-blank-cells-example
Sheet: CERTS components

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | aaaa | 31I | 40A_40B | bbbb | 45A_45B | 46A_46D | 610_640 | 700_702 | cccc | 710_730
 | aaaa | 620_07 | 700_21 | 701_09 | 702_00 | bbbb | 710_01 | 711_22 | 720_03
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 |  | Software | Release | From | To | And | Components |  |  | Support | Packages | Support | Release | Package
 |  | Component |  | Release | Release | subsequent | results |  |  | results |  | Packages |  | Name
1 |  | aaaa | 30 | 31I | 31I |  | aaaa | 31I |  | aaaa | 620_07 | aaaa | 620 | xxxxx62007
2 |  | aaaa | 40 | 40A | 40B |  |  | 40A_40B |  |  | 700_21 | aaaa | 700 | xxxxx70021
3 |  | bbbb | 45 | 45A | 45B |  | bbbb | 45A_45B |  |  | 701_09 | aaaa | 701 | xxxxx70109
4 |  | bbbb | 46 | 46A | 46D |  |  | 46A_46D |  |  | 702_00 | aaaa | 702 | xxxxx70200
5 |  | bbbb | 60 | 610 | 640 |  |  | 610_640 |  | bbbb | 710_01 | bbbb | 710 | xxxxx70201
6 |  | bbbb | 70 | 700 | 702 |  |  | 700_702 |  |  | 711_22 | bbbb | 711 | xxxxx71122
7 |  | cccc | 71 | 710 | 730 |  | cccc | 710_730 |  |  | 720_03 | bbbb | 720 | [NAME]
8 |  |  |  |  |  |  |  |  |  |  | _
9 |  |  |  |  |  |  |  |  |  |  | _
10 |  |  |  |  |  |  |  |  |  |  | _
11 |  |  |  |  |  |  |  |  |  |  | _
12 |  |  |  |  |  |  |  |  |  |  | _
13 |  |  |  |  |  |  |  |  |  |  | _
14 |  |  |  |  |  |  |  |  |  |  | _
15 |  |  |  |  |  |  |  |  |  |  | _
16 |  |  |  |  |  |  |  |  |  |  | _
17 |  |  |  |  |  |  |  |  |  |  | _
18 |  |  |  |  |  |  |  |  |  |  | _
Spreadsheet: 36272619-91d4-4f6a-afcf-7b48169875a8
Sheet: Sheet1

PENGUMUMAN | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
RENCANA UMUM PENGADAAN BARANG/JASA PEMERINTAH
 |  |  |  |  |  |  | [NAME] :
 |  |  |  |  |  |  | Tanggal :
 |  |  |  |  |  |  | PA/KPA Kementerian/Lembaga/Pemerintah Daerah/Institusi Lainnya (K/L/D/I)
 |  |  |  |  |  |  | Alamat
mengumumkan Rencana Umum Pengadaan Barang/Jasa untuk pelaksanaan kegiatan [NAME] 2013, seperti tersebut dibawah ini:
NO | SATUAN KERJA |  | KEGIATAN SWAKELOLA | KEGIATAN PENGADAAN |  |  |  | LOKASI PEKERJAAN | [NAME] (APBN/APBD/PHLN) | PELAKSANAAN LELANG/SELEKSI |  | PELAKSANAAN PEKERJAAN |  | [NAME]
 |  |  |  | LELANG / SELEKSI |  |  | KEGIATAN PENGADAAN LAINNYA |  |  | Awal ([NAME]) | Selesai ([NAME]) | Awal ([NAME]) | Selesai ([NAME])
 | KODE | NAMA |  | NILAI  (Rp.) | VOLUME
(1) | (2) | (3) | (4) | (5) | (6) |  | (7) | (8) | (9) | (10) | (11) | (12) | (13) | (14)
1
Spreadsheet: 50681d1250162109-matrix-transpose-ex-1-
Sheet: Sheet2

500 | 203 | 120 | 320 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
121 | 232 | 0.2222 | 303 | 233 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
353 | 1231 | 42342 | 121 | 454 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2321 | 123 | 124 | 145 | 675 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
21 | 12 | 1242 | 41 | 896 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A