tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 144325d1330922889-rolling-totals-calculated-based-on-two-maybe-3-variables-order-countsum-test2
Sheet: orders breakdown

Year | Order Date | Customer ID | Order Number | Product Type | ProductCategory | Order Amount | Status | Sum Of Product Type |  | [NAME] | Count of transactions | Dollar Amounts
 | 2010-09-08 00:00:00 | 12345678 | 4523549 | B | FD | 122.25 | X |  |  | Order Totals Per Customer By Product Type | 16
 | 2011-07-13 00:00:00 | 12345678 | 4523549 | A | MN | 10.5 | C |  |  | Order Totals Per Customer By Category Type | 15
 | 2012-01-18 00:00:00 | 12345678 | 4523550 | C | FD | 16.25 | S |  |  | Order Totals Per Order Number By Product Type | 16
 | 2011-09-14 00:00:00 | 09876543 | 4523552 | B | FD | 20.5 | S |  |  | Order Totals Per Order By Category Type | 15
 | 2011-09-14 00:00:00 | 09876543 | 4523552 | B | DP | 62.75 | S
 | 2011-08-22 00:00:00 | 09876543 | 4523576 | C | MN | 100.1 | X |  |  | Product Category | Count Of Category | Total Order Amount Of Product Category By Order
 | 2012-01-11 00:00:00 | 09876543 | 4523579 | D | DP | 10.25 | C |  |  | MN
 | 2011-02-23 00:00:00 | 88223344 | 4523580 | A | KE | 22.75 | C |  |  | FD
 | 2011-07-06 00:00:00 | 88223344 | 4523580 | A | CC | 18.5 | S |  |  | DP
 | 2011-08-31 00:00:00 | 66453322 | 4523583 | B | MN | 150.25 | X |  |  | CC
 | 2012-03-01 00:00:00 | 66453322 | 4523585 | D | OW | 157.25 | O |  |  | KE
 | 2012-03-04 00:00:00 | 66453322 | 4523590 | C | NO | 9.75 | O |  |  | OW
 | 2011-05-04 00:00:00 | 00652231 | 4523603 | C | KE | 32.5 | S |  |  | NO
 | 2011-11-07 00:00:00 | 00652231 | 4523614 | D | NU | 68.5 | S |  |  | NU
 | 2011-10-18 00:00:00 | 00652231 | 4523633 | A | FT | 68.5 | C |  |  | FT
 | 2011-10-18 00:00:00 | 00652231 | 4523633 | C | DP | 15.25 | O |  |  | NR
 | 2011-10-18 00:00:00 | 00652231 | 4523633 | A | FT | 68.5 | X
 | 2012-03-04 00:00:00 | 22565511 | 4523636 | D | DP | 44.5 | O |  |  | Product Type | Count Of Type | Total Order Amount Of Product Type By Order
 | 2011-08-19 00:00:00 | 65229899 | 4523637 | C | NU | 22.5 | S |  |  | A
 | 2012-03-02 00:00:00 | 65229899 | 4523637 | A | NU | 22.5 | O |  |  | B
 |  |  |  |  |  |  |  |  |  | C
Total Orders Count By Order Number |  |  |  |  |  |  |  |  |  | D
Each order number only counted once
 |  |  |  |  |  |  |  |  |  | X in the status column should not be counted in the dollar totals.
Spreadsheet: 772433d1647272700-combining-a-counta-range-with-a-counta-single-cell-statement-excel-formulas
Sheet: Analysis

1
2
4 | [NAME]
5 | Shaded =  Stock Owned | Symbol |  | Number Of Daily 'U' Results | Number Of Daily "D" Results | [NAME] | Time Period
6
7 | Allegheny Technologies Inc (0) | ATI |  |  |  |  | 2/1 To Date
31 | Chevron Corporation Common Stock (4) | CVX |  |  |  |  | 2/1 To Date
51 |  | PFE |  |  |  |  | 3/1 To Date
 |  | The formulas in E7 & F7 are to bring data
 |  | relating to C7 from the tab "ClosingStockPrices'
 |  | to this tab .. which it does!
 |  | What I want to do is to have the formulas
 |  | in E7 & F7 do the counting directly from
 |  | the 'ClosingStockTab' and eliminate the
 |  | need for formulas in the 'ClosingStockPrices' tab
 |  | by combining the 'VLookUp' and the 'CountA' functions
 |  | in cells E7 & F7
Spreadsheet: 728887d1618766569-how-to-sumif-with-criteria-sumif-with-criteria
Sheet: Sheet1

 | Qty | Pur / Sold | Sold / not sold | Con | Comment
 | 75 | Pur | Sold | [NAME] 15000  75
 | -75 | Sold | Sold | [NAME] 15000  75
 | 75 | Pur | Sold | [NAME] 15000  75
 | -75 | Sold | Sold | [NAME] 15000  75
 | 75 | Pur | Sold | [NAME] 15000  75
 | 75 | Pur | Not Sold | [NAME] 15000  75
 | -75 | Sold | Sold | [NAME] 15000  75
Spreadsheet: d2b72306-30d3-4b4a-ab27-7797dd00b55e
Sheet: Sheet1

Judgeship Number 4 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 4/24/2014 1:15:58 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
District | [NAME] | TOTALS
District 04 | 456 | 456
District 31 | 702 | 702
District 36 | 4705 | 4705
Results provided by the Office of North Dakota Secretary of State | 6028 | 6028
District 39 | 3922 | 3922
TOTAL | 15813 | 15813
Spreadsheet: mike_carson__27592__KOCH
Sheet: Sheet1

 | Power for delivery
 | On-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit | EPMI | Total
 |  | Postion | Price |  | Fee | COST | Dollars
 | Entergy | 100 | 17.8 |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -700 | 18 |  | 1
 | Comed | -100 | 18 |  | 1
 | Off-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit |  | Total
 |  | Postion | Price |  | Fee |  | Dollars
 | Entergy | 0 |  |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -50 | 13.5 |  | 1
 | Comed | 0 |  |  | 1
 |  |  |  |  | Total
 |  |  |  |  | Prepay Wire AMT |  | -250000 | <<< Payed due to MLK holiday on 1/18/02
 |  |  |  |  |  | Net AMT |  | << EPMI will subtract Amt from wire payment on 1/22/02
Spreadsheet: 49374d1248720986-transpose-help-test
Sheet: Sheet1

Number | Month | Monthly Factor
1 | Jan | 0.8365126050420167
1 | Feb | 0.9049159663865547
1 | Mar | 0.9096218487394959
1 | Apr | 0.9262184873949579
1 | May | 1.113319327731092
1 | Jun | 1.202983193277311
1 | Jul | 1.040168067226891
1 | Aug | 1.116176470588235
1 | Sep | 1.163403361344538
1 | Oct | 1.089831932773109
1 | Nov | 0.9122268907563025
1 | Dec | 0.7583193277310925
2 | Jan | 0.8728571428571429
2 | Feb | 0.9203061224489797
2 | Mar | 0.9414285714285715
2 | Apr | 0.9813775510204084
2 | May | 1.108826530612245
2 | Jun | 1.223061224489796
2 | Jul | 1.087551020408163
2 | Aug | 1.040663265306122
2 | Sep | 1.161785714285714
2 | Oct | 1.009795918367347
2 | Nov | 0.9745918367346937
2 | Dec | 0.8939795918367346
Spreadsheet: 06b7426d-b82d-44fe-9135-8b2e7fb21ace
Sheet: Alternating Block Example

 | Return to Index Page
 | Period | Minutes
 | 1A | 89
 | 1B | 89
 | 2A | 90
 | 2B | 90
 | 3A | 88
 | 3B | 88
 | 4A | 87
 | 4B | 87
 | OJT | 60
 | Seminar | 3
 | Course |  | Number | Period | Class
Approved Class Name | Code | Teacher | Period | Enrolled | Minutes | Total | Notes
Accounting I | 12345 |  | 3A | 26
Accounting II | 12346 |  | 2B | 12
Computer Applications I | 21435 |  | 4A | 15
Computer Applications I | 21435 |  | 4B | 14
Computer Applications I | 21435 |  | 2A | 16
Computer Applications I | 21435 |  | 2B | 16
Computer Applications II | 21436 |  | 3A | 15
Computer Applications II | 21436 |  | 3B | 15
Advanced Drafting | 30111 |  | 1B | 12
Cabinet Making III | 41234 |  | 1B | 4
Cabinet Making IV | 41235 |  | 3B | 3
Business OJT | 50011 |  | OJT | 3
Seminar Period |  |  | Seminar | 148
 |  |  |  |  | TOTAL MINUTES
 |  |  |  |  | TOTAL HOURS
 | Return to Top
Spreadsheet: 584019d1532929525-format-rows-on-last-digit-being-odd-or-even-book1
Sheet: 3GEE-03 Import 

Action | Submission ID | Job Number | ADA | Address | DPU_EQUIPMENT_ID | PORT<br>NUMBER
 | 4.05366794251249e+18 | 93601 | 3GEE-03-09 | UNIT|1||||1||229A|HOPE|ST|||GEELONG WEST|||VIC | 3GEE-03-09-DPU-001 | 2
 | 4.0536679425146e+18 | 93601 | 3GEE-03-09 | |||||2||233|HOPE|ST|||GEELONG WEST||3218|VIC | 3GEE-03-09-DPU-001 | 4
 | 4.05366794251924e+18 | 93601 | 3GEE-03-09 | UNIT|1||||||218|HOPE|ST|||GEELONG WEST|||VIC | 3GEE-03-09-DPU-002 | 1
 | 4.0536679425189e+18 | 93601 | 3GEE-03-09 | |||||||216|HOPE|ST|||GEELONG WEST|||VIC | 3GEE-03-09-DPU-002 | 2
 | 4.05366794251842e+18 | 93601 | 3GEE-03-09 | |||||||229|HOPE|ST|||GEELONG WEST|||VIC | 3GEE-03-09-DPU-002 | 3
 | 4.05366794251387e+18 | 93601 | 3GEE-03-09 | UNIT|2||||||218|HOPE|ST|||GEELONG WEST|||VIC | 3GEE-03-09-DPU-002 | 4
 | 4.05366794251139e+18 | 93601 | 3GEE-03-09 | [NAME] | 3GEE-03-09-DPU-003 | 1
 | 4.05366794251537e+18 | 93601 | 3GEE-03-09 | UNIT|2||||||225|HOPE|ST|||GEELONG WEST|||VIC | 3GEE-03-09-DPU-003 | 2
 | 4.05366794251228e+18 | 93601 | 3GEE-03-09 | UNIT|3||||||225|HOPE|ST|||GEELONG WEST|||VIC | 3GEE-03-09-DPU-003 | 3
 | 4.05366794251883e+18 | 93601 | 3GEE-03-09 | UNIT|2||||||223|HOPE|ST|||GEELONG WEST|||VIC | 3GEE-03-09-DPU-004 | 1
 | 4.05366794251247e+18 | 93601 | 3GEE-03-09 | UNIT|3||||||223|HOPE|ST|||GEELONG WEST|||VIC | 3GEE-03-09-DPU-004 | 2
 | 4.05366794251251e+18 | 93601 | 3GEE-03-09 | UNIT|4||||||223|HOPE|ST|||GEELONG WEST|||VIC | 3GEE-03-09-DPU-004 | 3
 | 4.05366794251974e+18 | 93601 | 3GEE-03-09 | |||||||212|HOPE|ST|||GEELONG WEST|||VIC | 3GEE-03-09-DPU-005 | 1
 | 4.05366794251581e+18 | 93601 | 3GEE-03-09 | |||||||210|HOPE|ST|||GEELONG WEST|||VIC | 3GEE-03-09-DPU-005 | 2
 | 4.05366794251222e+18 | 93601 | 3GEE-03-09 | |||||||213|HOPE|ST|||GEELONG WEST|||VIC | 3GEE-03-09-DPU-005 | 3
 | 4.05366794251907e+18 | 93601 | 3GEE-03-09 | |||||||208|HOPE|ST|||GEELONG WEST|||VIC | 3GEE-03-09-DPU-006 | 1
Spreadsheet: 135873d1326288521-is-there-better-way-to-write-this-if-statement-ind-and-matc110112
Sheet: Sheet2

Names | Values
Beauchamp, Suzanne | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Beauchamp, Suzanne
Gamble, [NAME] | 15
[NAME], [NAME] | 50
Maxwell, [NAME] | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gamble, [NAME]
Mead, Chloe | 35
[NAME], [NAME] | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Park, [NAME] | 45
Park, [NAME] | 45
Philip, Troy | 50 |  |  |  |  | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME]
Rodriguez, [NAME] | 55
[NAME], Kade | 60
Scinocca, [NAME] | 65 |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maxwell, [NAME]
Su, [NAME] | 70
Tavares, [NAME] | 75
Turner, Sydney | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mead, Chloe
[NAME], Adam | 85 |  |  |  |  | 50
Watts, Alannah | 90
Woo, Janice | 95 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME]
Young, Maura | 100 |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Park, [NAME]
 |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Philip, Troy
 |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rodriguez, [NAME]
 |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Kade
 |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scinocca, [NAME]
 |  |  |  |  |  | 55
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Su, [NAME]
 |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tavares, [NAME]
 |  |  |  |  |  | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Turner, Sydney
 |  |  |  |  |  | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Adam
 |  |  |  |  |  | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Watts, Alannah
 |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Woo, Janice
 |  |  |  |  |  | 85
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Young, Maura
 |  |  |  |  |  | 90
 |  |  |  |  |  | 95
 |  |  |  |  |  | 100
Spreadsheet: 29011d1223636614-sumifs-life-ruining-value-message-copy-of-exceltip2
Sheet: BOM & Explode

Material | Used in | Qty Used per Batch | Purchasing Overage | Purchasing Qty per Lot | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
Raw Material 1 | Product 1 | 1800 | 1.05 | 1890 | 17955 | 44887.5 | 112218.75 | 280546.875 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Raw Material 1 | Product 2 | 1000 | 1.05 | 1050 | 0 | 0 | 0 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Total Raw Material 1 Usage |  |  |  |  | 17955 | 44887.5 | 112218.75 | 280546.875 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 803352d1667406061-formula-to-calculate-annual-semi-annual-and-quarterly-dates-frequency-schedule-function-dates
Sheet: Function Dates

Function Months |  |  |  |  | Change Function Months
MONTHS WORK TO BE SCHEDULED IN |  |  |  |  | MONTHS WORK IS DUE TO BE PERFORMED IN |  |  |  |  |  | Thru: | 2022-11-01 00:00:00 | LAST DATE WORK ORDERS WERE GENERATED
A | Q | S | Q |  | A | Year | S | Year | Q | Year | M | Year
JAN | APR | JUL | OCT |  | JAN | 2022 | JUL | 2022 | OCT | 2022 | NOV | 2022
FEB | MAY | AUG | NOV |  | FEB | 2022 | AUG | 2022 | NOV | 2022 | NOV | 2022
MAR | JUN | SEP | DEC |  | MAR | 2022 | SEP | 2022 | SEP | 2022 | NOV | 2022
APR | JUL | OCT | JAN |  | APR | 2022 | OCT | 2022 | OCT | 2022 | NOV | 2022
MAY | AUG | NOV | FEB |  | MAY | 2022 | NOV | 2022 | NOV | 2022 | NOV | 2022
JUN | SEP | DEC | MAR |  | JUN | 2022 | JUN | 2022 | SEP | 2022 | NOV | 2022
JUL | OCT | JAN | APR |  | JUL | 2022 | JUL | 2022 | OCT | 2022 | NOV | 2022
AUG | NOV | FEB | MAY |  | AUG | 2022 | AUG | 2022 | NOV | 2022 | NOV | 2022
SEP | DEC | MAR | JUN |  | SEP | 2022 | SEP | 2022 | SEP | 2022 | NOV | 2022
OCT | JAN | APR | JUL |  | OCT | 2022 | OCT | 2022 | OCT | 2022 | NOV | 2022
NOV | FEB | MAY | AUG |  | NOV | 2022 | NOV | 2022 | NOV | 2022 | NOV | 2022
DEC | MAR | JUN | SEP |  | DEC | 2021 | JUN | 2022 | SEP | 2022 | NOV | 2022
 |  |  |  |  | Generators
 |  |  |  |  | Q | YEAR | M | YEAR
 | 1 | M | JAN |  | SEP | 2022 | NOV | 2022
 | 2 | M | FEB
 | 3 | Q | MAR
 | 4 | M | APR
 | 5 | M | MAY
 | 6 | Q | JUN
 | 7 | M | JUL
 | 8 | M | AUG
 | 9 | Q | SEP
 | 10 | M | OCT
 | 11 | M | NOV
 | 12 | Q | DEC
Spreadsheet: 685296d1593887871-new-to-excel-formulas-and-in-need-of-help-price-calculation-formula-request
Sheet: Sheet1

Price | Service fee | Total price | Times multiples of price (A2) dependant on price (see table below) plus service fee
19.355 | 17.5 |  | Under £25.00 x 3
19.355 | 17.5 |  | £25.00 to £35.00 x 2.9
19.355 | 17.5 |  | £35.00 to £45.00 x 2.8
19.355 | 17.5 |  | £45.00 to £60.00 x 2.7
63.59500000000001 | 17.5 |  | £60.00 to £8.000 x 2.6
59.25 | 17.5 |  | Over £80.00 x 2.5
63.59500000000001 | 17.5
63.59500000000001 | 17.5
67.15 | 17.5
67.15 | 17.5
63.59500000000001 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
14.615 | 17.5
14.615 | 17.5
68.33500000000001 | 17.5
63.99 | 17.5
68.33500000000001 | 17.5
68.33500000000001 | 17.5
71.89 | 17.5
71.89 | 17.5
68.33500000000001 | 17.5
82.555 | 17.5
82.555 | 17.5
82.555 | 17.5
82.555 | 17.5
82.555 | 17.5
82.555 | 17.5
60.04000000000001 | 17.5
52.14 | 17.5
60.04000000000001 | 17.5
74.26 | 17.5
74.26 | 17.5
66.36 | 17.5
66.36 | 17.5
74.26 | 17.5
Spreadsheet: 835084d1688287465-select-automatic-range-for-average-sum-automatic-range-average-sum-formula-1-
Sheet: Sheet1

 | Product Value
19000
Table Value | Product Value |  |  | I want to select automatic range for Average Sum
18000 | 20
18050 | 50 |  |  | If A5 column change the value than Range also be changed based on A5 Value and Average Value to be mention in B5 Column
18100 | 100 |  |  | For Example A5 Column Shows 18800 than Range to be select as Column B29 to B52 and answerd should be 91.25
18150 | 80 |  |  | If A5 column Shows 18600 than Range to be select as [NAME] to B52 and answered should be 92.32
18200 | 70 |  |  | Negative and Zero Values in Product Value column should be consider as Positive Value
18250 | 50
18300 | 20
18350 | 50
18400 | 30
18450 | 50
18500 | 20
18550 | 50
18600 | 60
18650 | 120
18700 | 110
18750 | 90
18800 | 75
18850 | 30
18900 | 50
18950 | 60
19000 | 80
19050 | 130
19100 | 140
19150 | 50
19200 | 80
19250 | 90
19300 | 100
19350 | 80
19400 | 70
19450 | 60
19500 | 80
19550 | 60
19600 | 150
19650 | 120
19700 | 130
19750 | 140
19800 | 110
19850 | 80
19900 | 90
19950 | 100
20000 | 110
Spreadsheet: 549021d1511423210-dynamic-cell-reference-creation-example
Sheet: Datadrop

Internal ID | Item Name
8279 | 8000342
8280 | 8000343
8281 | 8000344
8282 | 8000345
8283 | 8000346
8284 | 8000347
8285 | 8000348
8286 | 8000373
8288 | 8000380
Spreadsheet: tracy_geaccone__40293__CAPITAL WORKSHEET
Sheet: Marketing

MARKETING
2002 CAPITAL PLAN
($ [NAME])
 |  | 2002
 |  | NNG |  | TW |  | FGT |  | NBP |  | Midwestern |  | TOTAL
GROUP |  | [NAME] | Disc | [NAME] | Disc | [NAME] | Disc | [NAME] | Disc | [NAME] | Disc | [NAME] | Disc
Shared Systems:
Electronic Tariff Filing |  | 21605 |  | 6200 |  | 11165 |  | 10325 |  | 705
NNG Partial Cycle FDD |  | 65000
NNG Automate Storage "Book" |  |  | 87000
NNG Rate Case Reporting |  | 108000
NNG Form 567 Reporting |  | 65000
Blanket - Depts |  |  |  |  | 40000
Blanket - Depts |  |  | 118400
Blanket - Depts |  |  |  |  |  |  | 30000
Total Marketing
rev 8/27/01
Spreadsheet: 152989d1335664898-count-with-variable-cells-bijlage-1
Sheet: Blad1

 | TABEL 1 |  |  | TABEL 2
 | DatumAangemaakt | DatumOpgeheven |  | [NAME] | AantalAangemaakt | AantalOpgeheven
 |  |  |  | 2012-01-31 00:00:00 | 0 | 0
 |  | 2012-08-02 00:00:00 |  | 2012-02-01 00:00:00 | 1 | 0
 | 2012-02-02 00:00:00 |  |  | 2012-03-01 00:00:00 | 0 | 0
 |  |  |  | 2012-04-01 00:00:00 | 0 | 0
 |  |  |  | 2012-05-01 00:00:00 | 0 | 0
 |  |  |  | 2012-06-01 00:00:00 | 0 | 0
 |  |  |  | 2012-07-01 00:00:00 | 0 | 0
 |  |  |  | 2012-08-01 00:00:00 | 0 | 1
 |  |  |  | 2012-09-01 00:00:00 | 0 | 0
 |  |  |  | 2012-10-01 00:00:00 | 0 | 0
 |  |  |  | 2012-11-01 00:00:00 | 0 | 0
 |  |  |  | 2012-12-01 00:00:00 | 0 | 0
Spreadsheet: afbb0ef0-1b12-4400-ba57-7856915f5446
Sheet: Sheet1

Securities | % of Assets
Veresen Inc. | 3.78%
Freehold Royalties Ltd | 3.66%
Crescent Point Energy Crp | 3.17%
TransAlta Corp. | 3.03%
Extendicare Inc | 2.93%
Lightstream Resources | 2.81%
Great-West Life Company | 2.64%
Enbridge Income Fund Hld | 2.52%
Power Financial Corp. | 2.52%
IGM Financial Inc. | 2.51%
Sun Life Financial Inc. | 2.50%
Transcontinental Inc Cl A | 2.50%
BCE Inc. | 2.48%
Northland Power Inc | 2.42%
Capital Power Corp | 2.34%
Baytex Energy Corp. | 2.32%
Thomson Reuters Corp | 2.32%
Granite REIT Stapled UN | 2.29%
AGF Management Ltd Cl B | 2.23%
Power Corporation Canada | 2.23%
[NAME] | 2.06%
Bank of Montreal | 2.06%
Reitmans (Cda) Ltd Cl A | 2.04%
Vermilion Energy, Inc. | 2.02%
Shaw Communicatn Cl B Nvs | 1.95%
First Capital Realty Inc | 1.95%
TELUS Corp. | 1.89%
Royal Bank of Canada | 1.78%
Industrial All Ins & Fin | 1.76%
Emera Inc. | 1.75%
[NAME] Cl B Nvs | 1.72%
Toronto-Dominion Bank | 1.66%
TransCanada Corp. | 1.66%
Rogers Communications Inc | 1.60%
Fortis Inc. | 1.55%
Brookfield Office Prop | 1.54%
Canexus Corp | 1.53%
Pembina Pipeline Inc | 1.42%
Genworth MI Canada Inc | 1.42%
Dorel Industries Inc Cl B | 1.38%
Enbridge Inc. | 1.38%
ARC Resources Ltd | 1.34%
Ensign Energy Srvcs Inc | 1.30%
Wajax Corporation | 1.26%
Pason Systems Inc | 1.22%
Keyera Corp | 1.18%
Laurentian Bank of Canada | 0.99%
Sherritt Intl Corp | 0.97%
Cdn Imperial Bk of Commrc | 0.97%
Cash | 0.75%
Atlantic Power Corp | 0.71%
Total Holdings in Portfolio | 51
Spreadsheet: 132863d1323984195-hyperlink-to-take-me-on-a-worksheet-when-selected-sample
Sheet: sample client001

[NAME] Record |  |  | RO NUMBER | 6446
 | TOTAL PARTS/SERVICE |  | VEHICLE MAKE: | Nissan
 | TOTAL RECIVABLE | 0 | MODEL: | Pathfinder | OWNER NAME:
 | DEDUCTABLE |  | YEAR: | 1999 | VIN NO:
 | CUSTOMER PAY |  | LICENSE NO: |  | INSURANCE:
 | BALANCE DUE
 | [NAME] | OPEN |  | IN | OUT | DATE
 |  | OPEN | MILEAGE |  |  | DROPPED OFF | PICKED UP
 |  | CLOSED |  |  |  | 2011-11-28 00:00:00
DATE | INVOICE No. | SUPPLIER | PART DESCRIPTION | USED/NEW/SVC | CHECK NO. | AMOUNT PAID | CUST PAY | DEDUCT | PYMNT RCVD
2011-11-28 00:00:00 |  | rolando towing | towing services | service |  | 60
2011-12-01 00:00:00 | 198522 | universal city nissan | apron, [NAME], over fender, duct, mudguard, extenion | new | 21800 | 707.13
2011-11-30 00:00:00 | 31741308 | lkq | l-fender | used | 21789 | 210
2011-12-01 00:00:00 | 198522 | universal city nissan | bumper fr | new | 21806 | 219.65
2011-12-02 00:00:00 | 335 | rsr wheel repair | wheel repair and refinish, mount and balance | service | 21830 | 99
2011-12-05 00:00:00 | 31741320 | lkq | L- knee | used | 21866 | 100
2011-12-06 00:00:00 | 747493-1 | universal city nissan | [NAME] - turn | new | 21868 | 38.48
2011-12-06 00:00:00 | 747763 | universal city nissan | [NAME] | new | 21868 | 147.32
2011-12-06 00:00:00 | 747974 | universal city nissan | SLIDER BUMPER | new | 21878 | 11.39
2011-12-08 00:00:00 | 748010 | universal city nissan | sensor assy | new | 21901 | 113.88
2011-12-13 00:00:00 | 748254 | universal city nissan | clip, bmpr front, protector, over fender assy | new | 21963 | 268.11
2011-12-13 00:00:00 | 88274 | american tire depot | tire, balance, installation | sublet service |  | 195
2011-12-13 00:00:00 | 96557 | prime auto parts & sal | undercarriage crossmember | used |  | 150
Spreadsheet: 886503d1736521636-count-how-many-items-each-person-has-example-counting
Sheet: Sheet1

ID | Pencil | Pen | Rubber
10124 |  | 0 | 1 |  |  |  | Pen | Pencil | Rubber
10125 | 0 | 2 | 1 |  |  | 10124 |  | 1 | 1
10126 | 0 | 2 | 1 |  |  | 10125 | 2 |  | 1
10127 | 1 | 0 | 0 |  |  | 10126 | 2 |  | 1
10128 | 1 | 1 | 1 |  |  | 10127 |  | 1
10129 | 0 | 1 | 2 |  |  | 10128 | 1 | 1 | 1
10130 | 1 | 0 | 0 |  |  | 10129 | 1 |  | 2
10131 | 1 | 0 | 2 |  |  | 10130 |  | 1
10132 | 1 | 0 | 2 |  |  | 10131 |  | 1 | 2
 |  |  |  |  |  | 10132 |  | 1 | 2
Spreadsheet: 92020d1291694479-data-layout-between-row-and-column-test
Sheet: How it looks

Applicant |  | This
Application ID |  | is
Contact |  | Testing
Project title |  | using
Program |  | another
Proposed Project Area |  | column
Project type |  | with
Funding Round |  | some
Grant request* |  | extra
Loan request |  | data.
Status
Description
Public Notice Response
Spreadsheet: 30187d1225542489-automation-of-variables-xls
Sheet: Flight Lines

Flight Line | E Start | N Start | E Finish | N Finish
1 | 287307.6 | 87000 | 298692.4 | 87000
2 | 287307.6 | 87346.2 | 298692.4 | 87346.2
3 | 287307.6 | 87692.4 | 298692.4 | 87692.4
4 | 287307.6 | 88038.59999999999 | 298692.4 | 88038.59999999999
5 | 287307.6 | 88384.79999999999 | 298692.4 | 88384.79999999999
6 | 287307.6 | 88730.99999999999 | 298692.4 | 88730.99999999999
7 | 287307.6 | 89077.19999999998 | 298692.4 | 89077.19999999998
8 | 287307.6 | 89423.39999999998 | 298692.4 | 89423.39999999998
9 | 287307.6 | 89769.59999999998 | 298692.4 | 89769.59999999998
 |  |  | 2688231.6
Spreadsheet: 292630d1390699436-automated-posting-from-journals-to-ledgeraccounts-accounts
Sheet: IncStatement

Income statement - 31 December, 2008
Income
Income - StudyLink |  | 552.51
Income - other |  | 30
Total income |  |  | 582.51
Expenses
Grocery |  | 138.25
Genesis - power |  | 105
Petrol |  | 50
Car - other |  | 15
[NAME] expense
Total expenses |  |  | 308.25
Net income |  |  | 274.26