tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__23028__EWS Trading Margin Breakout
Sheet: Summary

 |  | Consolidated Summary
 |  |  | Americas |  |  | EES  Wholesale |  |  | Europe |  |  | Global  Markets |  |  | Industrial  Markets |  |  | Net  Works |  |  | Global  Assets |  |  | EBS |  |  | EEOS |  |  | EPI |  |  | Wholesale Office  of Chairman |  |  | Total Wholesale
 |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual
Gas |  | $ |  |  | $ |  |  | $ |  |  | $ |  |  | $ |  |  | $ |  |  | $ |  |  | $ |  |  | $ |  |  | $ |  |  | $ |  |  | $
Power
Metals
Crude & Products
Tariff Risk Management
Emerging (LNG)
Coal
Financial
Weather
Pulp & Paper
Lumber
Europe
Steel
Australia
E Commerce
Drift
Bandwidth
[NAME]
J-Block
Eastern 1 & 2
Watershed
Credit Trading
Other
 | Trading Margin
Gas
Power
Peakers
Other
 | Origination Margin
Public Portfolio
Private Valuation
EES 50%
Equity Earnings
Asset/Accrual Margin
CATS/Margaux
 | Assets & Investments
 | TOTAL MARGIN
Spreadsheet: 816900d1675878151-extract-multiple-text-fields-from-strings-of-various-lengths-sample-renewal-items
Sheet: Sheet1

STRING | 2 Space | 4th last space | 3rd Last Space | 2nd Last Space | Position of Last Space | Client Reference | S&S Part | Part Description | Qty | S&S Start Date | S&S End Date | S&S Reference Price
DCC E01MJLL IBM Rational Application Developer for WebSphere Software Authorized User Annual SW Subscription & Support Renewal 777 11/1/2022 10/31/2023 $144.44
DCC E01MKLL IBM Rational Application Developer for WebSphere Software Floating User Single Install Annual SW Subscription & Support Renewal 2 11/1/2022 10/31/2023 $337.55
DCC E020VLL IBM Optim High Performance Unload for Db2 Processor Value Unit (PVU) Annual SW Subscription & Support Renewal 3,650 11/1/2022 10/31/2023 $4.33
ACME E029TLL IBM Business Monitor Processor Value Unit (PVU) Annual SW Subscription & Support Renewal 590 11/1/2022 10/31/2023 $62.08
ACME E02K5LL IBM Db2 Connect Enterprise Edition 25 Authorized User Annual SW Subscription & Support Renewal 9 11/1/2022 10/31/2023 $176.54
 |  | Character | Word to Find | Place to [NAME] ^
 |  | ^ | 3 | 2
I am attempting to separate the 7 pieces of data contained in each [NAME] (Column A) into the corresponding columns (G - M).
I have been successful in extracting the first 2 columns of data, and the last, but struggling with the middle 4.
I have formulas to identify the spaces I think I need to pull the data, but am stumped on how to use that information.
I have 500+ lines similar to the sample in Column A to apply this to.
Spreadsheet: 1305aee5-2454-4427-9c7f-1ae08e992ba0
Sheet: 8 Communications

8 | Chapter communications:  Maintain active communications within the chapter.
 |  | Have and follow a written chapter communication plan |  |  | [NAME] | 25
 |  | Communicate regularly with unit OA representatives |  |  | Silver | 50
 |  | Contribute to the lodge and/or council newsletter or website |  |  | Gold | 100
 |  | Provide a brief overview of the chapter's written communication plan.  Include how the chapter will communicate regularly with the unit OA representatives.  Provide a plan for contributing to the lodge and/or council newsletter or website.  Attach the actual plan to the annual lodge report.
 | Describe the Plan
 |  | How will the chapter remain accountable for following its communication plan?
 | Plan for Success
 | Evaluate Achievement | Did the chapter maintain a communication plan?
 |  | Did the chapter follow the communication plan?
 |  | Did the chapter regularly communicate with unit OA representatives?
 |  | Did the chapter contribute to the lodge and/or council newsletter or website?
 |  | What obstacles did the chapter face when trying to follow its communication plan?
 | Reflect on Difficulties
 |  | What should the chapter do differently next year?  What additional support is needed?
 | Plan for Next Year
Spreadsheet: 2b3c2f87-f1fc-4f5d-a311-01eea6d5ac95
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: |  |  | 2013-08-28 09:39:09.580000
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.875 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.75 | 101.766 | 101.641 | 101.516 | 101.141
4.625 | 101.049 | 100.924 | 100.799 | 100.424 |  | Note: | Refer To Price [NAME]
4.5 | 100.157 | 100.032 | 99.907 | 99.532 |  |  | For all Price Adjs
4.375 | 99.226 | 99.101 | 98.976 | 98.351
4.25 | 98.539 | 98.414 | 98.289 | 97.664
4.125 | 97.749 | 97.624 | 97.499 | 96.874
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.125 | 102 | 101.875 | 101.5
3.875 | 101.595 | 101.47 | 101.345 | 100.97
3.75 | 100.947 | 100.822 | 100.697 | 100.322
3.625 | 100.575 | 100.45 | 100.325 | 99.95
3.5 | 100.068 | 99.943 | 99.818 | 99.193
3.375 | 99.325 | 99.2 | 99.075 | 98.45
3.25 | 98.594 | 98.469 | 98.344 | 97.719 |  | Minimum loan amount:
3.125 | 97.685 | 97.56 | 97.435 | 96.81 |  | 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 | 2013-09-11 09:39:09.580000
30 DAY | 2013-09-26 09:39:09.580000
45 DAY | 2013-10-11 09:39:09.580000
60 DAY | 2013-10-26 09:39:09.580000
90 DAY | 2013-11-25 09:39:09.580000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 23972d1213887422-vlookup-problem-diesel-backup
Sheet: Front

Company & Town | Product | 2008-06-07 00:00:00 | 2008-06-10 00:00:00 | 2008-06-11 00:00:00 | 2008-06-12 00:00:00 | 2008-06-13 00:00:00 | 2008-06-14 00:00:00 | 2008-06-17 00:00:00 | 2008-06-18 00:00:00 | 2008-06-19 00:00:00 | 2008-06-20 00:00:00
Company 1 | P1 | 0.99 | 2.97
Town 1 | P2 | 0 | 0
 | P3 | 0 | 0
 | P4 | 0 | 0
 | P5 | 0 | 0
 | P6 | 0 | 0
Company 2 | P1 | 0.99 | 2.97
Town 1 | P2 | 0 | 0
 | P3 | 0 | 0
 | P4 | 0 | 0
 | P5 | 0 | 0
 | P6 | 0 | 0
Spreadsheet: 48669d1247895457-vlookup-401-ded-worksheet-upload
Sheet: 401 DED WORKSHEET

File # | Dept | Last Name First Name | SSN | 401K (K) | 401K (R) | TOTAL DEDS | voucher # | Rate Amount | Type | pay date
1 | R-F | Doe, [NAME] | 231548649 | 0 | 40 | 40 | 4321 | 25 | H | 2009-07-17 00:00:00
2 | GA-F | [NAME], [NAME] | 456898794 | 100 | 0 | 100 | 2134 | 25 | H | 2009-07-17 00:00:00
2 | GA-F | [NAME], [NAME] | 456898794 | 100 | 0 | 100 | 2135 | 25 | H | 2009-07-17 00:00:00
4 | NASH-F | [NAME], [NAME] | 907599084 | 0 | 40 | 40 | 2136 | 25 | H | 2009-07-17 00:00:00
4 | NASH-F | [NAME], [NAME] | 907599084 | 0 | 40 | 40 | 2137 | 25 | H | 2009-07-17 00:00:00
6 | NASH-O | Thompson, Jake | 135829934 | 0 | 40 | 40 | 2138 | 25 | H | 2009-07-17 00:00:00
7 | M-F | Garner, [NAME] | 158364959 | 80 | 0 | 80 | 2139 | 25 | H | 2009-07-17 00:00:00
8 | M-F | Holland, Maria | 180899664 | 90 | 0 | 90 | 2140 | 25 | H | 2009-07-17 00:00:00
9 | M-F | Graft, Scott | 203449809 | 110 | 0 | 110 | 2141 | 25 | H | 2009-07-17 00:00:00
10 | SD-F | Topper, [NAME] | 225999954 | 0 | 0 | 0 | 2142 | 25 | H | 2009-07-17 00:00:00
11 | LOUIS-F | [NAME], [NAME] | 248550099 | 0 | 40 | 40 | 2143 | 25 | H | 2009-07-17 00:00:00
12 | CORP | Trully, [NAME] | 271040244 | 120 | 0 | 120 | 2144 | 25 | H | 2009-07-17 00:00:00
13 | D-O | Fanta, [NAME] | 293750389 | 0 | 40 | 40 | 2145 | 25 | H | 2009-07-17 00:00:00
14 | UDS | Shelton, [NAME] | 311100534 | 0 | 40 | 40 | 2146 | 25 | H | 2009-07-17 00:00:00
15 | R-O | Edwards, [NAME] | 336450679 | 0 | 32 | 32 | 2147 | 20 | H | 2009-07-17 00:00:00
16 | M-F | Earhardt, Dale | 361800824 | 75 | 0 | 75 | 2148 | 20 | H | 2009-07-17 00:00:00
17 | M-F | [NAME], [NAME] | 383750969 | 55 | 0 | 55 | 2149 | 20 | H | 2009-07-17 00:00:00
18 | M-F | Frontal, [NAME] | 406201114 | 0 | 32 | 32 | 2150 | 20 | H | 2009-07-17 00:00:00
19 | AL-O | Edon, [NAME] | 428781259 | 65 | 0 | 65 | 2151 | 20 | H | 2009-07-17 00:00:00
20 | CORP | [NAME], [NAME] | 451301404 | 100 | 0 | 100 | 2152 | 30 | H | 2009-07-17 00:00:00
21 | CORP | Bing, [NAME] | 473821549 | 45 | 0 | 45 | 2153 | 32 | S | 2009-07-17 00:00:00
22 | CORP | [NAME], [NAME] | 496341694 | 0 | 76.93 | 76.93 | 2154 | 48.08 | S | 2009-07-17 00:00:00
23 | CORP | [NAME], [NAME] | 518861839 | 0 | 14.4 | 14.4 | 2155 | 15 | S | 2009-07-17 00:00:00
24 |  |  |  | 0 | 0 | 0 | 0 | 0
25 |  |  |  | 0 | 0 | 0 | 0 | 0
26 |  |  |  | 0 | 0 | 0 | 0 | 0
27 |  |  |  | 0 | 0 | 0 | 0 | 0
28 |  |  |  | 0 | 0 | 0 | 0 | 0
29 |  |  |  | 0 | 0 | 0 | 0 | 0
30 |  |  |  | 0 | 0 | 0 | 0 | 0
Spreadsheet: 832480d1686348482-lookup-to-return-values-if-asterix-is-present-test
Sheet: Format Data

Todays Date | Schedule | Colour | Name | Address
 |  | blue | [NAME] | 13 Fiddle St, Couch, Italy
 |  | yellow | [NAME] | 312 Carpet Road, Furniture, Germany
 |  | orange | July Jules | 31 Television Road, Watching, England
 |  | red | [NAME] | 543 Stove Street, Kitchen, Ireland
This is how I would like it to look - so only rows with an asterix are selected and there are no gaps between rows. Note "Todays Date" Is only populated if there is an asterix. B to E is a table (doesn’t include A):
Todays Date | Schedule | Colour | Name | Address
 | ID_21321 | Mon, 01-May-2023, from 09:00 to 11:00 | blue | [NAME] | 13 Fiddle St, Couch, Italy
 | ID_42133 | [NAME], 12-May-2023, from 13:00 to 15:00 | yellow | [NAME] | 312 Carpet Road, Furniture, Germany
 | ID_12322 | Tue, 09-May-2023, from 10:00 to 15:00 | orange | July Jules | 31 Television Road, Watching, England
 | ID_54324 | Mon, 22-May-2023, from 11:00 to 16:00 | red | [NAME] | 543 Stove Street, Kitchen, Ireland
 | Table auto increases if more rows have *
Spreadsheet: 0e1e1658-bcaf-4fb3-83a9-f243fa9d7570
Sheet: Sheet1

2014 General Election - UNOFFICIAL RESULTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
State of North Dakota Results
Precincts Reporting: 390/427 - Total Ballots Cast: 20833
Downloaded at 10/20/2014 4:42:08 AM
 | [NAME] | [NAME] | [NAME] | write-in  - NON
Representative in Congress | 2088 | 2048 | 2091 | 3798
 | [NAME] (Al) Jaeger  - REP | Roland  Riemers  - LIB | April  Fairfield  - DEM | write-in  - NON
Secretary of State | 2051 | 2104 | 2052 | 3799
 | [NAME] | [NAME]  - DEM | write-in  - NON
Attorney General | 1662 | 1675 | 2904
 | [NAME] | [NAME] | write-in  - NON
Agriculture Commissioner | 1621 | 1715 | 2906
 | [NAME] | [NAME] | write-in  - NON
Public Service Commissioner | 1651 | 1691 | 2905
 | Tyler  Axness  - DEM | [NAME] | write-in  - NON
Public Service Commissioner [NAME] | 1706 | 1637 | 2898
 | [NAME] | [NAME] | [NAME] | write-in  - NON
Tax Commissioner | 2045 | 2081 | 2075 | 3799
 | [NAME] | write-in  - NON
Justice of the Supreme Court | 1273 | 2001
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 468950d1467693654-time-difference-time-difference
Sheet: Sheet3

Tare Weight Date | Tare Weight Time | PGI Date | Packing Time | time diff
2016-04-01 00:00:00 | 21:12:56 | 2016-04-02 00:00:00 | 00:09:20 | 02:56:24
2016-04-01 00:00:00 | 19:07:22 | 2016-04-02 00:00:00 | 00:10:55 | 05:03:33
2016-04-01 00:00:00 | 20:32:19 | 2016-04-02 00:00:00 | 00:12:07 | 03:39:48
Spreadsheet: 745562d1629999343-calculate-fiscal-year-based-on-todays-date-fy-lookup
Sheet: Sheet1

FY Start (Month #) | Current FY | Next FY | Today's Date
1
2
3
4
5
6
7
8
9
10
11
12
Spreadsheet: 803557d1667553710-win-loss-formula-in-excel-win_losshd
Sheet: Sheet2

 |  | Match |  |  | SET 1 |  | SET 2 |  | SET 3 |  | SET 4 |  | SET 5 |  | Winner
 |  | a | vs | b | 4 | 11 | 11 | 4 | 11 | 4 | 5 | 11 | 3 | 11
 |  | c | vs | d | 3 | 11 | 3 | 11 | 3 | 11
 |  | e | vs | f | 11 | 3 | 11 | 3 | 11 | 3
Spreadsheet: 707205d1607096701-extracting-a-portion-from-a-text-extract
Sheet: Sheet1

Material Group | Material | Obsolete | Material Name
A6001020 | 0340R03 | Y | *OBS* NORTH STAR NSL FRONT NAGM65
A6001020 | 0341R03 | Y | *OBS* NORTH STAR DATER NSL NAGM65
A6001020 | 2-0247 | Y | * OBSOLETE *
A6001020 | 2-0250 | Y | * OBSOLETE *
A6001020 | 3-0999 | Y | * OBSOLETE-REPLACED BY 4-3165 *
A6001020 | 3-3218 | Y | * OBSOLETE-REPLACED BY 4-3410 *
A6001020 | 3-3323 | Y | OBSOLETE
A6001020 | 3-3324 | Y | OBSOLETE
A6001020 | 3-3344 | Y | OBSOLETE
A6001020 | 3-3594 | Y | * OBSOLETE-REPLACED BY 4-3052 *
A6001020 | 3-3598 | Y | * OBSOLETE-REPLACED BY 4-0519 *
A6001020 | 3-4053 | Y | *OBSOLETE-REPLACED BY 4-2056*
A6001020 | 3-4054 | Y | * OBSOLETE REPLACED BY 4-2055 *
A6001020 | 3-4193 | Y | *OBSOLETE*
A6001020 | 3-4206 | Y | *OBSOLETE-REPLACED BY 4-3785*
A6001020 | 3-4304 | Y | * OBSOLETE-REPLACED BY 4-2950 *
A6001020 | 3-4305 | Y | *OBSOLETE*COMMERCIAL STARTING
A6001020 | 3-4441 | Y | * OBSOLETE- REPLACED BY 4-2762 *
A6001020 | 3-4442 | Y | * OBSOLETE-REPLACED BY 4-2763 *
A6001020 | 3-4443 | Y | *OBS**LBL FR/ENG CORROSIVE/BLANK D/P TOP
Spreadsheet: 330818d1404867229-need-sumif-formula-help-formula-help-v2
Sheet: Sheet2

[NAME] | Exp | Total | [NAME] | Exp | Total | [NAME] | Exp | Total | [NAME] | Exp | Total |  | [NAME] | Exp | Total
12639.5 | 8000 | 20639.5 | 1263.95 | 800 | 2063.95
700 | 400 | 1100 | 70 | 40 | 110
61751 | 34000 | 95751 | 6175.1 | 3400 | 9575.1
227.35 | 50 | 277.35 | 22.735 | 5 | 27.735
0 | 9000 | 9000 | 0 | 900 | 900
 |  |  |  |  |  | 65639.44 | 16409.84 | 82049.28
 |  |  |  |  |  | 0 | 32202.48 | 32202.48
 |  |  |  |  |  | 106617.81 | 34427.79 | 141045.6
 |  |  |  |  |  | 0 | 24975.01 | 24975.01
 |  |  |  |  |  | 0 | 109275.1 | 109275.1
 |  |  |  |  |  |  |  |  | 0 | 4788 | 4788
 |  |  |  |  |  |  |  |  | 221839.94 | 25934.29 | 247774.23
 |  |  |  |  |  |  |  |  | 739190.67 | 152123.96 | 891314.63
 |  |  |  |  |  |  |  |  | 364195.94 | 176159.6 | 540355.54
 |  |  |  |  |  |  |  |  | 3520.35 | 4302.65 | 7823
 |  |  |  |  |  |  |  |  | 243390.74 | 62966.62 | 306357.36
 |  |  |  |  |  |  |  |  | 59921.58 | 16737.06 | 76658.64
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  | 80000 | 20000 | 100000
 |  |  | 120000 | 30000 | 150000
 |  |  | 160000 | 40000 | 200000
 |  |  | 100000 | 25000 | 125000
 |  |  | 0 | 50000 | 50000
Spreadsheet: 49246d1248486015-sumif-formula-with-2-criteria-book4
Sheet: Sheet1

Inv | Invoice | Customer |  |  | Order
Number | Date | Number | Customer Name | Address | Number | Sale Price
------ | ----------- | ---------- | ------------------------------ | ---------- | -------- | --------------------
60580 | 2009-06-09 00:00:00 | 111 | Mexico LTD | ADDR1 | 36369 | 4800
61038 | 2009-06-16 00:00:00 | 222 | England LTD | ADDR2 | 36509 | 2875
60200 | 2009-06-01 00:00:00 | 333 | Black International | ADDR1 | 35752 | 4715
60283 | 2009-06-02 00:00:00 | 333 | England LTD | ADDR2 | 36220 | 8954
60284 | 2009-06-02 00:00:00 | 333 | Mexico LTD | ADDR2 | 36244 | 3191
60340 | 2009-06-03 00:00:00 | 333 | Black International | ADDR1 | 36284 | 1048
 |  |  | England LTD |  |  | 11829
 |  |  | Mexico LTD |  |  | 7991
 |  |  | Black International |  |  | 5763
 | WANT THE RESULT BELOW:
 |  |  | England LTD | ADDR1 |  | 0
 |  |  | Mexico LTD | ADDR1 |  | 4800
 |  |  | Black International | ADDR1 |  | 5763
Spreadsheet: 770901d1646327057-i-need-the-sum-of-costs-in-between-date-ranges-using-a-reference-sample-tco
Sheet: Sheet1

TCO Comparison LTD
Unit | Operation | Engine Type | Hours | Fuel+DEF/Energy | Maintenance | Equipment | [NAME] | Total Cost of Operation | Total Cost Per Hour | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10
R94908 | T230 | Diesel |  |  |  |  | 0
R94902 | T437 | Diesel |  |  |  |  | 0
R94910 | T539 | Diesel |  |  |  |  | 0
R94914 | T568 | Diesel |  |  |  |  | 0
R94906 | T630 | Diesel |  |  |  |  | 0
[NAME] | T630 | Diesel |  |  |  |  | 0
R94904 | T644 | Diesel |  |  |  |  | 0
R94912 | T667 | Diesel |  |  |  |  | 0
R94900 | T779 | Diesel |  |  |  |  | 0
R04300 | T550 | Electric
R11432 | T539 | Electric |  |  |  |  | 0
Spreadsheet: 697070d1601139164-sum-if-function-returning-0-similar-sumifs-working-fine-portfolio-tracker
Sheet: Equity Summary

 | STOCKS | ETF
 | #[NAME]!
 | EQUITY SUMMARY
 | Company | Category | Sector | Account | Trade Currency | Value (Trade Currency) | Value (CAD) | Value (USD) | Total Value (CAD Equiv) | Total Value (USD Equiv) | Shares | Current Price | Change (%) | MER (%) | Beta | Volume
 | #[NAME]! | North America Equity | ETF | Questrade - TFSA |  |  |  |  |  |  | 5
 | #[NAME]! | North America Equity | ETF | Questrade - TFSA |  |  |  |  |  |  | 16
 | #[NAME]! | North America Equity | ETF | Questrade - TFSA |  |  |  |  |  |  | 11
 | #[NAME]! | Intl. Equity | ETF | Questrade - TFSA |  |  |  |  |  |  | 19
 | #[NAME]! | North America Equity | Financals | TD - RRSP |  |  |  |  |  |  | 12
 | #[NAME]! | North America Equity | Energy | Questrade - TFSA |  |  |  |  |  |  | 100
 | #[NAME]! | North America Equity | ETF | Questrade - TFSA |  |  |  |  |  |  | 2
 | #[NAME]! | North America Equity | ETF | Questrade - TFSA |  |  |  |  |  |  | 10
 | #[NAME]! | North America Equity | ETF | Questrade - TFSA |  |  |  |  |  |  | 0
 | Total CAD Value
 | Sector Weighting
 | Sector | Value USD | Value CAD | Weight % | Target Weight %
 | Basic Materials |  |  |  | 0.02
 | Communications |  |  |  | 0.1
 | Consumer, Cyclical |  |  |  | 0.1
 | Consumer, Non-Cylical |  |  |  | 0.1
 | Energy |  |  |  | 0.04
 | ETF Cash Component |  |  |  | 0
 | Financals |  |  |  | 0.1
 | HealthCare |  |  |  | 0.07
 | Industrials |  |  |  | 0.1
 | Other |  |  |  | 0.01
 | Real Estate |  |  |  | 0.03
 | Technology |  |  |  | 0.3
 | Utilities |  |  |  | 0.03
 | Total
 | ETF Index Weighting
 | Ticker | Value USD | Value CAD | Weight % | Target Weight %
 | QQQ |  |  |  | 0.35
 | SPY |  |  |  | 0.65
 | VO
 | VTV |  |  |  | 0
 | Total
 | Stock Type | Value USD | Value CAD | Weight % | Target Weight %
 | Dividend
 | Value
 | Growth
 | ETF
 | Total
Spreadsheet: 57398d1257513050-reporting-from-a-basic-table-mike-m-sample-table-and-report
Sheet: Sheet1

 |  | Sample Table and proposed report
 |  | Cient | Bid/Service Description | RADAR | Pipeline | End Date | Value | Per Annum | Target | Actual | Balance | Target | Target | Activity | Mine | Budget | CC | ROS | MY PM | PM | Project Description | Start Date | End Date | Pipeline Description | Comment
 |  | Client1 | IT enabled Change - CCTV & ParkingSystems | 4 |  | 2014-09-01 00:00:00 |  | 5000000 |  |  |  |  |  |  |  | 1500000 | 45000 | 0.11 | [NAME] |  | 5 Workstreams in year 1 |  |  |  | Complete DD, agree Ts&Cs, complete commercials.  Contract signature Dec 22nd.
 |  | Client2 |  |  |  | 2014-09-01 00:00:00 |  |  |  |  |  |  |  | P | P | 500000 | 20000 | 0.15 | [NAME] |  | DeskTop Thin Client Rollout +
 |  | Client3 |  |  |  |  |  |  |  |  |  |  |  |  | P | 2500000 | 750000 | 0.16 | [NAME] |  | DeskTop Thin Client Rollout +
 |  | Client4 |  |  |  |  |  |  |  |  |  |  |  |  | P | 2000000 | 50000 | 0.17 | [NAME] |  | Sundry PDFs
 |  | Client5 | IT Outsource |  |  | 2014-03-01 00:00:00 |  |  | 3050000 | 2698000 |  |  |  | P | P | 16000000 | 250000 | 0.1 | [NAME] | [NAME] | Sundry PDFs |  |  |  | 1200 Users Project closed end of November 2009
 |  | Client6 |  |  |  |  |  |  |  |  |  |  |  |  | P | 3000000 | 35000 | 0.09 | [NAME] c |  | Sundry PDFs
 |  | Client7 | IT Outsource |  |  | 2011-10-01 00:00:00 | 8000000 |  | 6884000 | 5407000 |  |  |  | P |  | 240000 | 15000 | 0.16 | [NAME] | [NAME] | Churn - generally 3 PMs
 |  | Client8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3000000 | 1200000 | 0.11 | [NAME] |  | Sundry PDFs
 |  | Client9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1250000 | 650000 | 0.09 | [NAME] |  | DeskTop Thin Client Rollout +
 |  | Client10 |  |  |  | 2018-03-01 00:00:00 |  |  | 4608000 | 3350000 |  |  |  | P |  | 350000 | 10000 | 0.07 | [NAME] |  | DeskTop Thin Client Rollout + |  |  |  | Relies on Projects to achieve ROS
 |  | Report should be based upon "MY PM" where the content is =D23.
 |  | Should reproduce the contents of relevant cells from columns "Client", "Project Description", "Budget", "CC", "ROS"
 |  | The report for say "Carolyne O'Connor" would be as follows;
 |  |  | [NAME] |  |  | Input from drop down list
 |  | Cient | Project Description | Budget | CC | ROS
 |  | Client2 | DeskTop Thin Client Rollout + | 500000 | 20000 | 0.15
 |  | Client3 | DeskTop Thin Client Rollout + | 2500000 | 750000 | 0.16
 |  | Client5 | Sundry PDFs | 16000000 | 250000 | 0.1
Spreadsheet: be0b3ba4-8697-4e4c-b689-02e3eb62b0f5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
3841 | 19979 | [NAME] | Beardslee | AUS | 0 | 00:41:10 | 00:01:00 | 01:31:35 | 00:01:03 | 00:22:19 | 1 | 02:37:09
3841 | 26096 | Belinda | Sharpless | AUS | 0 | [NAME] | 00:01:03 | 01:30:02 | 00:01:19 | 00:26:59 | 2 | 02:45:48
3841 | 26097 | [NAME] | Sheil | AUS | 0 | 00:49:19 | 00:01:21 | 01:40:17 | 00:01:26 | [NAME] | 3 | 02:59:37
3841 | 26095 | Eleanor | Dally | AUS | 0 | 00:47:49 | 00:01:05 | 01:46:40 | 00:01:12 | 00:26:08 | 4 | 03:02:56
3841 | 26094 | Margot | Capper | AUS | 0 | 00:53:28 | 00:01:07 | 01:38:32 | 00:01:27 | 00:29:59 | 5 | 03:04:36
Spreadsheet: 814728d1674568134-i-need-a-formula-to-copy-a-cell-from-a-specific-column-range-of-values-when-4-other-cond-exemple
Sheet: SCN ALD

Control Port Cabinet No. | Control Port Subrack No. | Control Port Slot No. | Control Port No. | Result | ALD Device Type | Vendor Code | Serial No.
0 | 4 | 1 | R0A | SUCCESS | SINGLE_RET | HW | N3879NB026303CLy2
0 | 4 | 1 | R0A | SUCCESS | SINGLE_RET | HW | N3879NB026401CRy3
0 | 4 | 1 | R0A | SUCCESS | STMA | HW | F10182211930020
0 | 4 | 1 | R0A | SUCCESS | SINGLE_RET | HW | N3879NB0265051Lr1
0 | 4 | 1 | R0A | SUCCESS | SINGLE_RET | HW | N3879NB0266017Rr2
0 | 4 | 1 | R0A | SUCCESS | SINGLE_RET | HW | N3879NB0261014Ly1
0 | 4 | 1 | R0A | SUCCESS | SINGLE_RET | HW | N3879NB0262044Ry4
0 | 4 | 3 | R0A | SUCCESS | SINGLE_RET | HW | N3879NB00KQ07CLy2
0 | 4 | 3 | R0A | SUCCESS | SINGLE_RET | HW | N3879NB00KR05CRy3
0 | 4 | 3 | R0A | SUCCESS | STMA | HW | F4164908193001C
0 | 4 | 3 | R0A | SUCCESS | SINGLE_RET | HW | N3879NB00KS043Lr1
0 | 4 | 3 | R0A | SUCCESS | SINGLE_RET | HW | N3879NB00KT046Rr2
0 | 4 | 3 | R0A | SUCCESS | SINGLE_RET | HW | N3879NB00KN093Ly1
0 | 4 | 3 | R0A | SUCCESS | SINGLE_RET | HW | N3879NB00KP096Ry4
0 | 4 | 5 | R0A | SUCCESS | SINGLE_RET | HW | [NAME]
0 | 4 | 5 | R0A | SUCCESS | SINGLE_RET | HW | N3879NB01BA03CRy3
0 | 4 | 5 | R0A | SUCCESS | STMA | HW | F3341271193005E
0 | 4 | 5 | R0A | SUCCESS | SINGLE_RET | HW | N3879NB01BB047Lr1
0 | 4 | 5 | R0A | SUCCESS | SINGLE_RET | HW | N3879NB01BC022Rr2
0 | 4 | 5 | R0A | SUCCESS | SINGLE_RET | HW | N3879NB01B7095Ly1
0 | 4 | 5 | R0A | SUCCESS | SINGLE_RET | HW | N3879NB01B8022Ry4
0 | 5 | 1 | R0A | SUCCESS | STMA | KA | H8D2437139
0 | 5 | 3 | R0A | SUCCESS | STMA | KA | H8D2437185
0 | 5 | 5 | R0A | SUCCESS | STMA | KA | H8D2437174
0 | 90 | 0 | R0A | SUCCESS | STMA | HW | [NAME]
0 | 91 | 0 | R0A | SUCCESS | STMA | HW | J888812420600CE
0 | 92 | 0 | R0A | SUCCESS | STMA | HW | J888812420600E0
0 | 210 | 0 | NULL | FAILURE | NULL | NULL | NULL
0 | 211 | 0 | NULL | FAILURE | NULL | NULL | NULL
0 | 212 | 0 | NULL | FAILURE | NULL | NULL | NULL