tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 217506d1362084670-consolidate-by-two-factors-new-problem
Sheet: April2012

 |  |  |  |  |  |  |  |  |  |  |  | 0.28
Customer | Name | Product | Description | Qty | m2 | Value | Av Price | Matl Cost | Yield AdJ | Purch Cost | Tot Matl Cost | ES Cost
1054 | Customer A | 512147 | energiKare(TM) | 1 | 2.55 | 158.38 | 62.11 | 14.62 | 19.23684210526316 | 0 | 19.23684210526316 | 7.140000000000001
1054 | Customer A | 99999999 | Energy Surcharge | 0 | 0 | 14.28 | 0 | 0 | 0 | 0 | 0 | 0
3152 | Customer C | 101514 | 4mm Oriel Texture Canterbury | 4 | 11.28 | 700.92 | 62.14 | 357.69 | 470.6447368421053 | 0 | 470.6447368421053 | 31.584
3152 | Customer C | 102614 | 4mm Oriel Texture Laurel stk | 2 | 5.64 | 350.46 | 62.14 | 178.84 | 235.3157894736842 | 0 | 235.3157894736842 | 15.792
3152 | Customer C | 500044 | Insulight(TM) | 295 | 174.66 | 3444.11 | 19.72 | 837.15 | 1101.513157894737 | 0 | 1101.513157894737 | 489.0480000000001
3152 | Customer C | 500045 | Insulight(TM) | 23 | 11.37 | 323.09 | 28.42 | 82.8 | 108.9473684210526 | 0 | 108.9473684210526 | 31.836
3152 | Customer C | 500144 | Insulight(TM) Protect | 118 | 50.98 | 1440.06 | 28.25 | 256.71 | 337.7763157894736 | 0 | 337.7763157894736 | 142.744
3152 | Customer C | 500145 | Insulight(TM) Protect | 10 | 4.4 | 153.4 | 34.86 | 32.73 | 43.06578947368421 | 0 | 43.06578947368421 | 12.32
3152 | Customer C | 500166 | Insulight(TM) Protect | 10 | 9.58 | 466.41 | 48.69 | 64.87 | 85.35526315789474 | 0 | 85.35526315789474 | 26.824
3152 | Customer C | 500264 | Insulight(TM) Protect1 | 24 | 23.9 | 1049.58 | 43.92 | 27.12 | 35.68421052631579 | 44.16 | 79.84421052631578 | 66.92
3152 | Customer C | 500280 | Insulight(TM) Protect | 6 | 5.34 | 245.01 | 45.88 | 32.79 | 43.14473684210526 | 0 | 43.14473684210526 | 14.952
3152 | Customer C | 512167 | energiKare(TM) | 3 | 7.85 | 376.8 | 48 | 66.22 | 87.13157894736842 | 0 | 87.13157894736842 | 21.98
3152 | Customer C | 512246 | energiKare(TM) | 15 | 17.32 | 1083.44 | 62.55 | 124.88 | 164.3157894736842 | 67.31 | 231.6257894736842 | 48.496
3152 | Customer C | 512247 | energiKare(TM) | 4 | 2.53 | 142.68 | 56.4 | 14.4 | 18.94736842105263 | 0 | 18.94736842105263 | 7.084000000000001
3152 | Customer C | 512267 | energiKare(TM) | 1 | 0.34 | 21.46 | 63.12 | 2.5 | 3.289473684210526 | 0 | 3.289473684210526 | 0.9520000000000002
3152 | Customer C | 512272 | energiKare(TM) | 8 | 27.74 | 1753.16 | 63.2 | 295.68 | 389.0526315789474 | 0 | 389.0526315789474 | 77.672
3152 | Customer C | 99999999 | Energy Surcharge | 0 | 0 | 2145.02 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: d3acb330-61e8-4e61-865e-3540adc82de0
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FPCFG | Test | FPCFG | Pecan Food IgG | Pecan Food IgG | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | < 2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:  Viracor-IBT Laboratories                               1001 NW Technology Dr.                               Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FPCFG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FPCFG | Result | FPCFG | Pecan Food IgG | Pecan Food IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 819233d1677329204-formula-to-move-from-selected-column-cells-to-row-cells-based-on-criteria-sample2
Sheet: Sheet2

Row Labels | Sum of ARGENTINA W1 | Sum of ARGENTINA W2 | Sum of ARGENTINA W3 | Sum of ARGENTINA W4 | Sum of ARGENTINA TTL | Sum of BRAZIL W1 | Sum of BRAZIL W2 | Sum of BRAZIL W3
DH1RV1050 | 1346 | 1682 | 2019 | 1682 | 6729 | 874 | 728 | 874
DH1SV2000 | 204 | 255 | 305 | 254 | 1018 | 45 | 38 | 45
DH1U6A050 | 1338 | 1673 | 2008 | 1673 | 6692 | 798 | 665 | 798
DH1U6B050 | 607 | 759 | 910 | 758 | 3034 | 1 | 1 | 0
DH1U91050 | 108 | 135 | 162 | 136 | 541 | 29 | 25 | 29
DH1U98050 | 351 | 439 | 526 | 438 | 1754 | 50 | 42 | 50
DH1VV5050 | 59 | 74 | 89 | 74 | 296 | 39 | 32 | 39
DH1VY2050 | 138 | 173 | 208 | 173 | 692 | 0 | 0 | 0
DH1VY3050 | 432 | 540 | 648 | 541 | 2161 | 213 | 178 | 213
DH1VY8050 | 249 | 312 | 374 | 312 | 1247 | 103 | 86 | 103
Grand Total | 4832 | 6042 | 7249 | 6041 | 24164 | 2152 | 1795 | 2151
Spreadsheet: 121b66e9-db4f-4a3c-aeee-2152db8d79f2
Sheet: 2

 | Jan 4 |  | Jan 11 |  | Jan 18 |  | Jan 25
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rate* | 370621611 | 370621611 | 380218108 | 380218108 | 385395440 | 385395440 | 386073161 | 386073161
SD/MSPs | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 16574252 | 16574252 | 16747192 | 16747192 | 17016046 | 17016046 | 16743138 | 16743138
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | 20276576 | 20276576 | 20595813 | 20595813 | 20654755 | 20654755 | 20848248 | 20848248
Dealers** | 17189842 | 17164316 | 17437094 | 17423164 | 17466814 | 17468028 | 17607027 | 17604488
Buyside | 3086734 | 3112260 | 3158719 | 3172648 | 3187941 | 3186727 | 3241221 | 3243760
Total Equity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, estimated gross notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, and participant types, cleared and uncleared. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL]
Spreadsheet: 73674d1274289813-sum-formula-in-multiple-worksheets-example
Sheet: March 2010

Broker ID | Broker Name | ePCG Submitted Lines | Total Submitted Lines
4117 | The Rule Company Inc | 4 | 55
9243 | Sullivan Insurance Group Inc. | 8 | 23
10714 | Fred Rhodes & Company | 3 | 4
4742 | Insurica Ins [NAME] | 0 | 21
4750 | Gunn Steers & Company, LLC | 2 | 15
Spreadsheet: 124619d1318512888-help-with-sumif-sumproduct-formulas-sample
Sheet: Jan

Acct | Consolidated | Location 1 | Location 2 | Location 3
supplies |  | 2 | 5 | 8
insurance |  | 4 | 6 | 9
office |  | 8 | 7 | 9
Spreadsheet: 874778d1721297439-pulling-specific-lines-from-a-list-based-on-a-cell-value-terminal-id-sample
Sheet: 06321792

Transaction date | Transaction time | Terminal ID | Transaction type | Currency | Transaction amount | Reconciled
2024-07-12 00:00:00 | 11:59:00 | 06321792 | Sale | GBP | 140
2024-07-12 00:00:00 | 11:06:00 | 06321792 | Sale | GBP | 140
2024-07-11 00:00:00 | 16:31:00 | 06321792 | Sale | GBP | 85
2024-07-11 00:00:00 | 16:05:00 | 06321792 | Sale | GBP | 55
2024-07-11 00:00:00 | 14:25:00 | 06321792 | Sale | GBP | 95
2024-07-11 00:00:00 | 10:29:00 | 06321792 | Refund | GBP | -25
2024-07-10 00:00:00 | 11:18:00 | 06321792 | Sale | GBP | 120 | Yes
2024-07-09 00:00:00 | 14:00:39 | 06321792 | Sale | GBP | 70.8 | Yes
2024-07-09 00:00:00 | 13:46:00 | 06321792 | Sale | GBP | 28 | Yes
2024-07-09 00:00:00 | 11:44:00 | 06321792 | Sale | GBP | 20 | Yes
2024-07-09 00:00:00 | 10:06:00 | 06321792 | Sale | GBP | 25 | Yes
2024-07-08 00:00:00 | 14:07:00 | 06321792 | Sale | GBP | 79 | Yes
2024-07-08 00:00:00 | 10:52:00 | 06321792 | Sale | GBP | 539 | Yes
2024-07-06 00:00:00 | 13:38:00 | 06321792 | Sale | GBP | 85 | Yes
2024-07-06 00:00:00 | 10:19:00 | 06321792 | Sale | GBP | 25 | Yes
2024-07-05 00:00:00 | 17:27:00 | 06321792 | Sale | GBP | 75 | Yes
2024-07-05 00:00:00 | 14:28:00 | 06321792 | Sale | GBP | 85 | Yes
2024-07-05 00:00:00 | 12:15:00 | 06321792 | Sale | GBP | 20 | Yes
2024-07-04 00:00:00 | 15:28:00 | 06321792 | Sale | GBP | 489 | Yes
2024-07-03 00:00:00 | 13:05:00 | 06321792 | Sale | GBP | 529 | Yes
2024-07-03 00:00:00 | 13:02:00 | 06321792 | Sale | GBP | 211.2 | Yes
2024-07-03 00:00:00 | 12:04:00 | 06321792 | Sale | GBP | 120 | Yes
2024-07-03 00:00:00 | 10:35:00 | 06321792 | Sale | GBP | 69.99 | Yes
2024-07-03 00:00:00 | 09:57:00 | 06321792 | Sale | GBP | 10 | Yes
2024-07-02 00:00:00 | 17:23:00 | 06321792 | Sale | GBP | 319 | Yes
2024-07-02 00:00:00 | 16:03:00 | 06321792 | Sale | GBP | 85 | Yes
2024-07-02 00:00:00 | 15:03:00 | 06321792 | Sale | GBP | 160 | Yes
2024-07-02 00:00:00 | 14:40:00 | 06321792 | Sale | GBP | 95 | Yes
2024-07-02 00:00:00 | 09:15:00 | 06321792 | Sale | GBP | 49 | Yes
2024-07-01 00:00:00 | 15:02:00 | 06321792 | Sale | GBP | 160 | Yes
2024-07-01 00:00:00 | 14:57:00 | 06321792 | Sale | GBP | 160 | Yes
2024-07-01 00:00:00 | 14:41:00 | 06321792 | Sale | GBP | 35 | Yes
2024-07-01 00:00:00 | 14:40:00 | 06321792 | Sale | GBP | 160 | Yes
Spreadsheet: 733cbd19-6d1c-41b4-98d8-5b65d15579f1
Sheet: Sheet1

Step 1- Create the route(s) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Type of approval |  | Method of Procurement |  |  | Level 1 Approver Name |  | Level 2 Approver Name |  | Level 3 Approver
temporary ID of approval route | Solicitation | Award | Small Purchase | Competitive Sealed Bidding | Competitive Sealed Proposals | first (L1) | last (L1) | first (L2) | last (L2) | first (L3) | last (L3)
1
2
3
Spreadsheet: 762093d1641393701-combine-columns-datas-for-identical-values-in-first-column-test5-1-ans
Sheet: FORMULAS

POINT | TYPE | TEXT1 | [NAME] |  |  | C | D |  | Expected
 |  |  |  |  |  | t1 | t1
 |  |  |  |  |  | t3 | t2|t3
 |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  | t6 | t5|t6
 |  |  |  |  |  | t8 | t7|t8
Spreadsheet: 144061d1330698806-finding-a-string-in-an-array-and-return-the-cell-without-vba-vlookup
Sheet: Sheet1

 |  |  | <- cell C2 points to News2
 | Its should give me the values to the right of what is pointed at in Cell C2. So far so good, it finds [NAME] and gives 0 because the cell to the right is blank, however I also want it the values to the right for as long as column G contains what is in C2 (Translation12 to Translation 17)
 | My VLOOKUP below
 |  |  |  |  |  | News1 |  | 5000
 |  |  |  |  |  | News1 | Translation1 | 1000
 |  |  |  |  |  | News1 | Translation2 | 900
 |  |  |  |  |  | News1 | Translation3 | 800
 |  |  |  |  |  | News1 | Translation4 | 700
 |  |  |  |  |  | News1 | Translation5 | 500
 |  |  |  |  |  | News1 | Translation6 | 400
 |  |  |  |  |  | News1 | Translation7 | 300
 |  |  |  |  |  | News1 | Translation8 | 100
 |  |  |  |  |  | News1 | Translation9 | 100
 |  |  |  |  |  | News1 | Translation10 | 100
 |  |  |  |  |  | News1 | Translation11 | 100
 |  |  |  |  |  | News2 |  | 3000
 |  |  |  |  |  | News2 | Translation12 | 1500
 |  |  |  |  |  | News2 | Translation13 | 600
 |  |  |  |  |  | News2 | Translation14 | 300
 |  |  |  |  |  | News2 | Translation15 | 200
 |  |  |  |  |  | News2 | Translation16 | 200
 |  |  |  |  |  | News2 | Translation17 | 200
 |  |  |  |  |  | News3 |  | 70
 |  |  |  |  |  | News3 | Translation18 | 10
 |  |  |  |  |  | News3 | Translation19 | 10
 |  |  |  |  |  | News3 | Translation20 | 10
 |  |  |  |  |  | News3 | Translation21 | 10
 |  |  |  |  |  | News3 | Translation22 | 10
 |  |  |  |  |  | News3 | Translation23 | 10
 |  |  |  |  |  | News3 | Translation24 | 10
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 15a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | 90 | 1010
Index
Asia | 0 | 1045
Europe | 91585 | 36150
North America | 101029 | 115016
Other | 1138 | 7425
OTHER* | 3250
Exotic | 0 | 286
Swaptions | 3250 | 24171
Total Return Swap | 0 | 49
TOTAL
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 849816d1700200849-need-to-check-an-array-for-a-value-in-another-sheet-and-then-return-first-cell-in-that-row-excelheadscratcher-aligw
Sheet: Sheet2

Cohort | Year | Team Name | Member 1 | Member 2 | Member 3 | Member 4 | Member 5 | Member 6 | Member 7 | Member 8 | Member 9 | Member 10
C23 | 1st | The Super Awesomes | Student 1 Student 1 Last | Student 2 Student 2 Last | Student 4 | Student 5 | Student 9 | Student 8 | Student 6 | Student 10 | Student 3 Student 3 Last | Student 11
C24 | 2nd | The Team Electric | Student 3 Student 3 Last | Student 4 | Student 7 | Student 2 Student 2 Last
C23 | 2nd | Butts for Eyeballs | Student 10 | Student 8 | Student 1 Student 1 Last | Student 9
C23 | 1st
C24
C24
C25
C23
C24
C24
C25
Spreadsheet: 647202d1572332747-vlookup-or-formula-to-return-a-number-related-to-a-word-that-is-typed-into-a-cell-pq-reshaping-tennis-data-aligw
Sheet: Processed Data

DATA | PLAYER 1 | PLAYER 2
Name | [NAME] | [NAME]
Country | Croatia | Poland
Birthdate | 28.09.88, 31 years | 11.02.97, 22 years
Height | 195 cm
Weight | 79 kg
Profi since | 2005
Right-handed | Right-handed
ATP ranking | 23 | 35
TOP ranking's position | 3 (16.04.18, 4985 points) | 33 (14.10.19, 1298 points)
Points | 1545 | 1298
Prize money | 27.022.364 $ | 1.517.157 $
Matches total | 931 | 356
Win | 612 | 217
% | 65.74 % | 60.96 %
PLAYER | Year | Summary | Hard | Clay | I. hard | Carpet | Grass | Acrylic |  |  | PLAYER | Summary | Hard | Clay | I. hard | Carpet | Grass | Acrylic | Best
PLAYER 1 | 2019 | 21/19 | 43809 | 43590 | 43498 | 0/0 | 43498 | 0/0 |  |  | PLAYER 1 | 0.6574 | 0.6471 | 0.6418 | 0.6872 | 0.5263 | 0.6972 | 0
PLAYER 1 | 2018 | 45/20 | 20/8 | 15/6 | 43560 | 0/0 | 43617 | 0/0 |  |  | PLAYER 2 | 0.6096 | 0.6735 | 0.6098 | 0.4808 | 0.6 | 0.4286 | 0
PLAYER 1 | 2017 | 46/22 | 43807 | 14/4 | 43684 | 0/0 | 43802 | 0/0
PLAYER 1 | 2016 | 49/24 | 21/11 | 43558 | 17/7 | 0/0 | 43649 | 0/0
PLAYER 1 | 2015 | 35/19 | 15/8 | 43652 | 43618 | 0/0 | 43649 | 0/0
PLAYER 1 | 2014 | 54/21 | 24/9 | 43775 | 15/4 | 0/0 | 43557 | 0/0
PLAYER 1 | 2013 | 26/13 | 43650 | 43651 | 43648 | 0/0 | 43587 | 0/0
PLAYER 1 | 2012 | 41/20 | 14/9 | 16/7 | 43498 | 0/0 | 43710 | 0/0
PLAYER 1 | 2011 | 44/23 | 14/9 | 13/7 | 15/5 | 0/0 | 43498 | 0/0
PLAYER 1 | 2010 | 40/22 | 19/10 | 43713 | 43774 | 0/0 | 43467 | 0/0
PLAYER 1 | 2009 | 49/23 | 22/12 | 43775 | 14/3 | 0/0 | 43498 | 0/0
PLAYER 1 | 2008 | 38/26 | 20/10 | 43623 | 43560 | 43466 | 43649 | 0/0
PLAYER 1 | 2007 | 50/22 | 43683 | 22/7 | 43773 | 43587 | 43558 | 0/0
PLAYER 1 | 2006 | 41/29 | 43588 | 15/15 | 43803 | 43560 | 43587 | 0/0
PLAYER 1 | 2005 | 30/13 | 43618 | 16/6 | 43588 | 0/1 | 43525 | 0/0
PLAYER 1 | 2004 | 43527 | 43466 | 43466 | 43466 | 0/0 | 0/0 | 0/0
PLAYER 2 | 2019 | 36/26 | 23/11 | 43653 | 43501 | 0/0 | 43558 | 0/0
PLAYER 2 | 2018 | 52/30 | 22/15 | 16/4 | 43714 | 43526 | 43499 | 0/0
PLAYER 2 | 2017 | 56/32 | 33/13 | 43811 | 43529 | 43679 | 0/0 | 0/0
PLAYER 2 | 2016 | 48/28 | 43713 | 29/14 | 43745 | 0/2 | 0/0 | 0/0
PLAYER 2 | 2015 | 20/17 | 43740 | 43685 | 43469 | 43467 | 0/1 | 0/0
PLAYER 2 | 2014 | 43590 | 43498 | 43526 | 0/0 | 0/0 | 0/1 | 0/0
PLAYER 2 | 2012 | 0/1 | 0/0 | 0/1 | 0/0 | 0/0 | 0/0 | 0/0
Spreadsheet: 086dfbcd-baaf-4983-839e-15b94d7253db
Sheet: Sheet1

Instructions for completing Budget Forms. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
1.  Please insert data only in | shaded cells.
2.  Please start by inserting the Application Date and Project Name and Project Address at the top of the
"Sources & Uses Table"spreadsheet.
3.  [NAME] the number of Units, Bedrooms, and [NAME] at the top right of the "Sources & Uses Table" spreadsheet.
4.  [NAME] the names of any Other Sources besides MOH in the shaded cells to the right of the "MOH" column.
5.  Use the line items to describe all the uses of funds proposed to be paid by each identified Source.  Use the
"Comments" column to describe how the amounts are derived, i.e., whether costs are estimated or bid and
provide any other relevant information which justifies the budgeted expense, such as cost per square foot,
an applicable percentage of other costs (e.g. construction contingency as a percentage of construction costs),
or an estimated number of work hours.   Explain any costs that are not consistent with MOH/SFRA
underwriting guidelines.
6.  When necessary to add new lines or columns to a spreadsheet, place the cursor on a |  |  |  |  |  | shaded cell
adjacent to where you want to add the line or column.   After inserting a new line or column check
whether any formulas (in unshaded cells) need to be copied to that new line or column.
Spreadsheet: 102635d1300608513-automate-new-sheets-in-workbook-stock
Sheet: 1

Name Product: | Staple |  | Report
Code: | 4543345 | Supplier: | Staples
Colour: | Green | [NAME]: | Large
Price/Unit: | 500 | Price Sale/Unit: | 600
Date | Description | Inv.No. | Receive | Sale | Balance | Remark
2011-02-21 00:00:00 | Staple | 345345234 | 10 | 5
2011-02-28 00:00:00 | Staple | 345345234 | 10 | 3
2011-03-01 00:00:00 | Staple | 345345234 | 10 | 5
2011-02-21 00:00:00 | Staple | 345345234 | 30 | 20
2011-02-28 00:00:00 | Staple | 345345234 | 50 | 40
2011-03-01 00:00:00 | Staple | 345345234 | 10 | 40
2011-02-21 00:00:00 | Staple | 345345234 | 10 | 15
2011-02-28 00:00:00 | Staple | 345345234 | 10 | 12
2011-03-01 00:00:00 | Staple | 345345234 | 10 | 4
Spreadsheet: kate_symes__18114__Deal Correction 1-17
Sheet: Current Day

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2001-01-17 00:00:00 | 2001-01-17 00:00:00 | 2000-10-10 00:00:00 | LTSW | MM | Houston | APB | Broker fee added: 0.005 |  | 432054 | PV | Q1-01 | On [NAME] | 100 | 50 | Avista
 |  |  |  | MM Count
 | 2001-01-17 00:00:00 | 2001-01-17 00:00:00 | 2001-01-17 00:00:00 | STSW | MF | Houston | Natsource | Broker: from APB to Natsource |  | 498837 | PV | 2001-01-18 00:00:00 | [NAME] | 25 | 225 | Tucson
 |  |  |  | [NAME]
 |  |  |  | Grand Count
Spreadsheet: 80825d1281010412-count-repeated-vaule-and-total-sum-repeated-rows-sum-1
Sheet: Sheet2

Information | 6819 | 23 | 9 | 6787 | 1570 | 316
IT | 19164 | 71 | 58 | 19035 | 2519 | 240
Marketing | 74507 | 411 | 145 | 73951 | 9128 | 2118
Spreadsheet: 287422d1388782385-converting-a-spreadsheet-into-a-heirarchical-display-of-the-data-fruit
Sheet: Category Details

Event Categories and Sub-Categories
Main Category | Sub-Cat 1 | Sub-Cat 2 | Sub-Cat 3 | Sub-Cat 4 | Form sub-section  (for NextDocs)
Fruit | Apples | Red |  |  | 2
Fruit | Apples | Green |  |  | 2
Fruit | Pineapples |  |  |  | 2
Fruit | Oranges | Tangerine |  |  | 2
Fruit | Oranges | Naval |  |  | 2
Fruit | Oranges | Orange |  |  | 2
Fruit | Pears | Green |  |  | 2
Fruit | Pears | [NAME] |  |  | 2
Fruit | Pears | Yellow |  |  | 2
Fruit | Blueberries | Big |  |  | 2
Fruit | Blueberries | Small |  |  | 2
Fruit | Blueberries | Blue |  |  | 2
Fruit | Blueberries | Sweet |  |  | 2
Fruit | Blueberries | Sour |  |  | 2
Main Category | Sub-Cat 1 | Sub-Cat 2 | Sub-Cat 3 | Sub-Cat 4
Fruit | Apples | Green | (blank) | (blank)
 |  | Red | (blank) | (blank)
 | Blueberries | Big | (blank) | (blank)
 |  | Blue | (blank) | (blank)
 |  | Small | (blank) | (blank)
 |  | Sour | (blank) | (blank)
 |  | Sweet | (blank) | (blank)
 | Oranges | Naval | (blank) | (blank)
 |  | Orange | (blank) | (blank)
 |  | Tangerine | (blank) | (blank)
 | Pears | [NAME] | (blank) | (blank)
 |  | Green | (blank) | (blank)
 |  | Yellow | (blank) | (blank)
 | Pineapples | (blank) | (blank) | (blank)
Grand Total
Spreadsheet: 77805d1278316030-summing-several-amounts-of-worksheets-in-one-workbook-and-in-multiple-workbooks-sumsheets
Sheet: Table2

41 | 45 | 40 | 10 | 27 | 19 | 19 | 13 |  | Total | 11807
44 | 19 | 48 | 35 | 29 | 39 | 42 | 37
12 | 42 | 27 | 39 | 37 | 38 | 11 | 39
26 | 11 | 12 | 45 | 26 | 47 | 45 | 21
30 | 16 | 19 | 47 | 26 | 11 | 39 | 42
25 | 28 | 23 | 35 | 33 | 44 | 12 | 36
30 | 50 | 30 | 35 | 44 | 32 | 20 | 41
15 | 16 | 17 | 44 | 37 | 45 | 46 | 37
23 | 11 | 25 | 17 | 20 | 34 | 40 | 32
32 | 22 | 32 | 35 | 37 | 48 | 10 | 12
30 | 24 | 32 | 44 | 46 | 23 | 50 | 37
28 | 26 | 50 | 14 | 19 | 14 | 11 | 23
23 | 46 | 27 | 32 | 36 | 36 | 41 | 32
22 | 27 | 28 | 14 | 38 | 12 | 16 | 28
37 | 11 | 38 | 45 | 35 | 40 | 22 | 27
40 | 31 | 46 | 15 | 11 | 33 | 26 | 22
38 | 42 | 28 | 20 | 18 | 33 | 30 | 11
49 | 15 | 32 | 27 | 50 | 15 | 43 | 39
48 | 10 | 38 | 28 | 30 | 41 | 34 | 47
40 | 21 | 18 | 41 | 45 | 16 | 40 | 16
38 | 35 | 35 | 26 | 47 | 14 | 11 | 36
30 | 30 | 44 | 25 | 44 | 21 | 28 | 16
16 | 17 | 27 | 22 | 37 | 17 | 15 | 42
40 | 13 | 36 | 30 | 35 | 40 | 42 | 30
32 | 43 | 18 | 33 | 16 | 39 | 43 | 11
45 | 26 | 15 | 22 | 47 | 34 | 24 | 14
37 | 22 | 24 | 50 | 28 | 20 | 16 | 27
37 | 20 | 40 | 17 | 32 | 12 | 13 | 21
31 | 31 | 46 | 33 | 27 | 26 | 16 | 28
18 | 20 | 32 | 10 | 19 | 45 | 31 | 37
28 | 45 | 47 | 43 | 44 | 38 | 19 | 33
12 | 47 | 20 | 38 | 35 | 34 | 24 | 27
35 | 48 | 36 | 47 | 27 | 40 | 21 | 50
10 | 18 | 11 | 47 | 11 | 30 | 48 | 15
47 | 12 | 49 | 21 | 45 | 43 | 45 | 14
27 | 25 | 35 | 11 | 29 | 27 | 38 | 48
18 | 11 | 41 | 44 | 48 | 30 | 49 | 36
32 | 14 | 21 | 45 | 33 | 30 | 18 | 44
37 | 50 | 10 | 42 | 16 | 28 | 38 | 25
45 | 47 | 17 | 16 | 37 | 25 | 26 | 20
24 | 15 | 29 | 39 | 21 | 21 | 17 | 46
15 | 12 | 47 | 40 | 17 | 20 | 50 | 43
44 | 20 | 23 | 29 | 41 | 32 | 24 | 27
23 | 23 | 38 | 45 | 42 | 45 | 14 | 27
10 | 29 | 38 | 49 | 24 | 37 | 17 | 39
45 | 14 | 13 | 34 | 10 | 19 | 14 | 37
13 | 49 | 18 | 48 | 11 | 12 | 14 | 10
17 | 11 | 44 | 27 | 38 | 30 | 30 | 12
16 | 21 | 39 | 25 | 34 | 36 | 45 | 13
24 | 38 | 19 | 12 | 17 | 18 | 16 | 33