tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 713594d1610819243-translating-multiple-column-index-to-other-work-sheets-film-tester-1-
Sheet: Actors

Actor | Total | Ave Score | Oscars | Ave Time | Best Film | Score | Worst Film | Score | Bechdel | BOAT
[NAME]
[NAME]
[NAME]
[NAME]
Macaulay Culkin
[NAME]
[NAME]
Sacha Baron [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Mercedes Ruehl
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Heath Ledger
Julia Stiles
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Agnes Moorehead
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Elijah Wood
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Shia LeBeouf
[NAME]
Dakota [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
JK Simmons
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Rashida Jones
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Lamorne [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Hugo Weaving
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Woody Allen
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Val Kilmer
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Cameron Diaz
[NAME]
[NAME]
Rufus Sewell
[NAME]
[NAME]
Eli Wallach
[NAME]
[NAME]
Antonia Thomas
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Chazz Palminteri
[NAME]
Taren Egerton
[NAME]
[NAME]
[NAME]
Celeste Holm
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Giovanni Ribisi
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Rochenda Sandall
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Milly Shapiro
[NAME]
Micheal Ward
[NAME]
[NAME]
[NAME]
Amarah-Jae St. Aubyn
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] Velez
[NAME]
[NAME] Henry
Hailee Steinfeld
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Cybill Shepherd
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Glynn Turman
Colman [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 694729d1599763991-if-formula-help-dschittone-sample
Sheet: 08-09

LIST PROJECT # | DISTRICT SCHOOL - PROPOSED BUILDING PROJECT                                      (List Deficiencies from District Facilities Director and 00-05 District LRFP'S by School and Year)   Note:  Add Rows for Additional Schools | 2008-2009 | Life - Safety  - Priority A | Critical /  Recommended Projects -              Priority B | [NAME]Priority C | Barrier-Free ADA Compliance - Priority H | Energy Efficiency - Priority E | Quantity | Unit Cost
 | SCHOOL NAME: [NAME] Complex
2 | Replace Built-Up Roof System | 321000 | 0 |  | 0 | 0 | 0 | 53700 | 15
3 | Paint Interior Walls | 26800 | 0 | 0 |  | 0 | 0 | 243214 | 0.55
6 | Replace Carpet on Second Floor | 246000 | 0 | 0 |  | 0 | 0 | 49104 | 5
8 | Replace Pumps/Motors @ Cooling Tower/Water Source | 100000 | 0 |  | 0 | 0 | 0 |  | ls
 | SUBTOTAL "A"
 | SCHOOL NAME: [NAME]
10 | Main Low Voltage Distribution 1600, Amps 50ft to Source | 90000 | 0 |  | 0 | 0 | 0 | 1 qty | BEA
11 | Paint Interior Walls | 9500 | 0 |  | 0 | 0 | 0 | 52393 | 0.55
12 | Replace 100 Amp Branch Panel | 40000 | 0 |  | 0 | 0 | 0 | 2 qty | BEA
13 | Replace 200 Amp Branch Panel | 50000 | 0 |  | 0 | 0 | 0 | 2 qty | BEA
14 | Replace 400 Amp Branch Panel | 30000 | 0 |  | 0 | 0 | 0 | 1 qty | BEA
17 | Replace Carpeting (corr, then 1/2 CRs over 2 years) | 45000 | 0 | 0 |  | 0 | 0 | 15361 | 4.1
 |  |  |  |  |  |  | 0
 | SUBTOTAL "B" |  |  |  |  |  | 0
 | SCHOOL NAME: William Davies Middle School
1 | Paint Interior Walls | 7000 | 0 | 0 |  | 0 | 0 | 63380 | 0.55
2 | Replace [NAME] | 21500 | 0 | 0 |  | 0 | 0 | 15622 | 4.1
3 | Air Condition Original Gym | 150000 | 0 | 0 |  | 0 |  |  | ls
5 | Replace Toilet Room Partitions | 56500 | 0 | 0 |  | 0 | 0 | 47 | 1200
 |  |  |  |  |  |  | 0
 | SUBTOTAL "C"
 | SCHOOL NAME:
1 |  | 0 | 0 | 0 | 0 | 0
 | SUBTOTAL "D"
 | SUMMARY SUBTOTALS (Subtotals A-G) :
 | PROJECT SOFT COSTS (A/E Fees, [NAME], Printing x 25%) :
 | PROJECT TOTALS:
Spreadsheet: 801506d1666233839-googlesheets-calendar-that-updates-automatically-when-you-click-either-sunday-or-monday-sample-workbook-calendar
Sheet: Sheet1

 | MONTHLY CALENDAR |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 1
 | MONTH | OCTOBER
 | YEAR | 2022
 | START DAY | SUNDAY
 | BILLS & FIXED EXPENSES
 | [NAME] | DUE DATE | PAID
 | Amazon Prime subscription | 2022-08-11 00:00:00
 | Internet bill | 2022-08-12 00:00:00
 | Amazon Prime US subscription | 2022-08-13 00:00:00
 | Uber Pass | 2022-08-13 00:00:00
 | Funimation subscription | 2022-08-14 00:00:00
 | SPECIAL EVENTS
 | EVENT | EVENT DATE
Spreadsheet: michelle_lokay__26699__imball0112
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 12873 | 10932
2 | 13275 | 10932
3 | 15491 | 10932 | -1
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  | 392389.58
2001-12-03 00:00:00
CBS Volume
 |  |  | -260608
Spreadsheet: 64847d1265679492-how-to-write-a-macro-for-command-button-toggle-two-command-buttons-for-filtering-marc5354-sdg10
Sheet: Sheet1

Sr. # |  |  | On Hold | Search Received
1 | [NAME] | In | Yes | No
2 | [NAME] | In | Yes | No
3 | [NAME] | In | Yes | No
4 | Scott | In | No | No
5 | Rita | Out | No | Yes
6 | Canaan | Out | No | Yes
7 | [NAME] | Out | No | Yes
8 | [NAME] | Out | No | No
9 | [NAME] | In | Yes | No
10 | [NAME] | In | No | No
 |  |  |  |  |  |  |  | Today, 03:58 PM
 |  |  |  |  |  |  |  | marc5354
 |  |  |  |  |  |  |  | Toggle two command buttons for filtering - marc5354 - SDG10.xls
 |  |  |  |  |  |  |  | Registered User   Join Date: 10 Nov 2009
 |  |  |  |  |  |  |  | Location: India
 |  |  |  |  |  |  |  | MS Office Version:Excel 2003
 |  |  |  |  |  |  |  | Posts: 15
 |  |  |  |  |  |  |  | Infractions: 0/1 (1)
 |  |  |  |  |  |  |  | How to write a macro for command button
 |  |  |  |  |  |  |  | http://www.excelforum.com/excel-miscellaneous/717245-how-to-write-a-macro-for-command-button.html
 |  |  |  |  |  |  |  | I am attempting to set up two command buttons for filter using macro, but i dont know how to write code in macro. please help me.
 |  |  |  |  |  |  |  | Hope you can help,
 |  |  |  |  |  |  |  | Regards...
 |  |  |  |  |  |  |  | ...[NAME]
Spreadsheet: 814681d1674551633-sum-unique-values-based-on-multiple-criteria-sample-data
Sheet: Desired Output

Reference ID | Amount | Payment Mode | Date | [NAME]
A001 | 100 | Cash deposit | 2023-01-01 00:00:00
A001 | 100 | Cash deposit | 2023-01-01 00:00:00
A001 | 100 | Cash deposit | 2023-01-01 00:00:00
A002 | 200 | Cash deposit | 2023-12-31 00:00:00 |  | NOTE - this was 2023 so the formula was catching this.
A003 | 250 | EFT | 2023-01-01 00:00:00
A004 | 400 | Cash deposit | 2023-01-04 00:00:00
A004 | 400 | Cash deposit | 2023-01-04 00:00:00
A005 | 1000 | Cash deposit | 2023-01-02 00:00:00
A006 | 800 | Cash deposit | 2023-01-01 00:00:00
[NAME] B where Refernce ID in column A is unique, Payment Mode in column C is "Cash deposit" and Date in column D is after 31 Dec 2023.
Base on the above conditions, only cells highlighted with yellow should be sum.
Output
Spreadsheet: 139136d1328098066-how-to-add-dates-and-day-names-automatically-from-sheets-name-book2
Sheet: Jan 2012

[NAME]
2012-01-01 00:00:00
Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue
2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 | 2012-01-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-01-28 00:00:00 | 2012-01-29 00:00:00 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00 | 31
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 833
833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 24990
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Balance From Prv Month |  |  |  |  |  | =
Advance |  |  |  |  |  |  |  |  |  |  |  |  |  | Total [NAME] |  |  |  |  |  |  |  |  |  | 25000
Date |  |  | Amount |  |  | Reason |  |  |  |  |  |  |  | Per Day Salary |  |  |  |  |  |  |  |  |  | 833 |  |  |  |  |  |  | 24157 | 6000
2011-11-21 00:00:00 |  |  | 1451 |  |  | orders |  |  |  |  |  |  |  | Date Joined |  |  |  |  |  |  |  |  |  | From Start
2011-12-11 00:00:00 |  |  | 3000
2011-12-14 00:00:00 |  |  | 2000 |  |  |  |  |  |  |  |  |  |  | Allowed Off Days |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Working Days |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 Off Days |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Allowed Off Days Amount |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | working days
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous Balance |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Salary Due After deducting off days |  |  |  |  |  |  |  |  |  | 25000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Advance Taken |  |  |  |  |  |  |  |  |  | 6451
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | allowed days
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Final Due Salary |  |  |  |  |  |  |  |  |  | 18549
Total |  |  | 6451
Spreadsheet: 769487d1645554786-unique-count-average-percentage-and-weekly-breakdown-member-check-ins-average-check-ins-testing
Sheet: Total Members per Age Group

Starting Age | Ending Age | Total Members
13 | 19 | 2
20 | 29 | 1 |  | THIS NEEDS TO BE A UNIQUE COUNT OF MEMBERS BETWEEN THE AGE GROUPS
30 | 39 | 0
40 | 49 | 0 |  | THERE ARE TWO UNIQUE MEMBERS FOR 13-19
50 | 59 | 0
60 | 69 | 0 |  | THERE IS ONE UNIQUE MEMBER FOR 20-29
70 | 79 | 0
80 | 89 | 0
90 | 99999 | 0
Spreadsheet: a7d092dc-c9ab-47ff-b76f-000fefe64a17
Sheet: Sheet1

Judgeship Number 6 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 9/2/2014 8:55:39 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
County | [NAME] | TOTALS
[NAME] | 56811 | 56811
Steele | 848 | 848
Traill | 3411 | 3411
TOTAL | 61070 | 61070
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 825575d1681400873-calculate-of-work-days-btwn-date-and-today-do-not-calculate-if-blank-or-if-not-required-calculate-no-of-day-excepts-etaf
Sheet: Sheet1

Date of Meeting | # Days
2023-03-03 00:00:00
Not Required
2023-03-08 00:00:00
2023-03-15 00:00:00
2023-04-04 00:00:00
2023-04-18 00:00:00
2022-10-22 00:00:00
Not Required
2023-04-24 00:00:00
Spreadsheet: scott_neal__38534__Neal Combined Munis Final
Sheet: Enter

(000) |  |  |  |  |  |  | [NAME]. | [NAME]. Call | Par | Pre-Re
Par | DTD | Settlement | Rating | Description | Coupon | Maturity | Call | Price | Call | Y=Yes | Price | SC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL SC
50 | 1992-09-01 00:00:00 | 2001-11-23 00:00:00 | AAA/AAA | ALBUQUERQUE NM | 0.0575 | 2012-07-01 00:00:00 | 2002-07-01 00:00:00 | 102 |  | Y=Yes | 104.042
250 | 1992-05-15 00:00:00 | 2001-11-23 00:00:00 | AAA/ | MIDWAY TX ISD PSF | 0.06125 | 2008-08-01 00:00:00 | 2002-08-01 00:00:00 | 100 |  | Y=Yes | 102.633
50 | 1995-12-01 00:00:00 | 2001-11-23 00:00:00 | AAA/AAA | [NAME] | 0.04375 | 2002-10-01 00:00:00 |  |  |  |  | 101.918
50 | 1998-06-15 00:00:00 | 2001-11-23 00:00:00 | AAA/AAA | UTAH STATE | 0.05 | 2003-07-01 00:00:00 |  |  |  |  | 104.229
300 | 1995-12-15 00:00:00 | 2001-11-23 00:00:00 | AAA/AAA | BUCKS CO PA | 0.0465 | 2003-08-15 00:00:00 |  |  |  |  | 104.123
50 | 1993-04-01 00:00:00 | 2001-11-23 00:00:00 | AAA/AAA | CLEVELAND OHIO | 0.05 | 2003-09-01 00:00:00 |  |  |  |  | 104.475
260 | 1992-08-13 00:00:00 | 2001-11-23 00:00:00 | AA3/AA | DELAWARE CO PA | 0 | 2003-11-15 00:00:00 |  |  |  |  | 95.126
200 | 2001-11-01 00:00:00 | 2001-11-29 00:00:00 | AAA/AAA | PORT HOUSTON | 0.04625 | 2016-10-01 00:00:00 | 2011-10-01 00:00:00 | 100 |  |  | 100.979
200 | 2001-11-01 00:00:00 | 2001-11-29 00:00:00 | AAA/AAA | PORT HOUSTON | 0.0475 | 2017-10-01 00:00:00 | 2011-10-01 00:00:00 | 100 |  |  | 101.566
200 | 2001-11-01 00:00:00 | 2001-11-26 00:00:00 | AAA/AAA | MONROE WISC SCH | 0.04875 | 2018-04-01 00:00:00 | 2011-04-01 00:00:00 | 100 |  |  | 101.309
200 | 2001-11-01 00:00:00 | 2001-11-26 00:00:00 | AAA/AA+ | TROY MICH | 0.046 | 2019-10-01 00:00:00 | 2010-10-01 00:00:00 | 100.5 | 2012-10-01 00:00:00 |  | 99.267
200 | 2001-11-15 00:00:00 | 2001-11-26 00:00:00 | AAA/AAA | PASADENA TX | 0.05 | 2020-02-15 00:00:00 | 2010-02-15 00:00:00 | 100 |  |  | 101.68
200 | 2001-03-15 00:00:00 | 2001-11-26 00:00:00 | AAA/AAA | N.HARRIS MONT CCD | 0.05 | 2021-02-15 00:00:00 | 2010-02-15 00:00:00 | 100 |  |  | 101.002
200 | 1998-12-15 00:00:00 | 2001-11-26 00:00:00 | AAA/AAA | PHILADELPHIA PA SCH | 0.045 | 2023-04-01 00:00:00 | 2009-04-01 00:00:00 | 100 |  |  | 96.012
100 | 1995-12-01 00:00:00 | 2001-11-26 00:00:00 | AAA/AAA | TEXAS TURNPIKE | 0.05 | 2025-01-01 00:00:00 | 2006-01-01 00:00:00 | 102 | 2008-01-01 00:00:00 |  | 100.517
100 | 2001-10-01 00:00:00 | 2001-11-26 00:00:00 | AAA/AAA | FRISCO [NAME] OBL | 0.05 | 2025-02-15 00:00:00 | 2011-02-15 00:00:00 | 100 |  |  | 100.728
200 | 2001-11-01 00:00:00 | 2001-11-26 00:00:00 | AAA/AAA | SEATTLE WASH WTR | 0.05 | 2026-11-01 00:00:00 | 2011-11-01 00:00:00 | 100 |  |  | 100.919
200 | 1997-11-01 00:00:00 | 2001-11-26 00:00:00 | AAA/AAA | SAN ANTONIO ISD | 0.05 | 2027-08-15 00:00:00 | 2008-08-15 00:00:00 | 100 |  |  | 100.561
 |  | Settlement |  | Enter Account/Broker Name: |  | [NAME]:
 |  | 2001-11-26 00:00:00 |  | [NAME] Combined Muni Port |  | 1.538 |  |  |  |  | SC=
Spreadsheet: 678939d1590133238-formula-to-return-a-value-from-a-list-based-upon-two-other-values-projects
Sheet: Sheet1

 |  | Project and Phase | Start Date |  |  | Project | StartDate | Phase
 |  | A - Phase2 |  |  |  | A | 2019-11-10 00:00:00 | Phase1
 |  | B - Phase2 |  |  |  | B | 2020-01-01 00:00:00 | Phase1
 |  | B - Phase1 |  |  |  | A | 2019-11-20 00:00:00 | Phase2
 |  |  |  |  |  | A | 2019-12-05 00:00:00 | Phase3
 |  |  |  |  |  | B | 2020-02-01 00:00:00 | Phase2
 |  |  |  |  |  | B | 2020-03-01 00:00:00 | Phase3
Spreadsheet: 1c43e021-1152-4f80-acf8-d2e0d89aebb6
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3189 | 12804 | [NAME] | Fischer | RSA | 63 | 00:11:32 | 00:00:16 | 00:36:30 | 00:00:29 | 00:21:40 | 1 | 01:10:29
3189 | 16010 | Charlotte | [NAME] | ZIM | 62 | 00:11:59 | 00:00:21 | 00:40:49 | 00:00:21 | 00:27:29 | 2 | 01:21:01
Spreadsheet: 847020d1698135698-display-count-in-table-2-based-on-table-1-values-count-values-based-on-tabe-1
Sheet: Sheet1

 | Table 1
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 | a | 1 |  | 1 |  |  |  | 4
 | s | 2 | 2 | 3 |  | 3
 | d | 3 |  |  | 4 |  | 5 | 6
 | f | 4 | 4 |  | 5 | 5
 | g | 5 |  |  |  |  | 6 | 2
 | a | 6 |  | 5 |  |  | 7
 | s | 7 | 2 |  | 3 |  | 8
 | d | 8 |  |  | 9 | 4
 | g | 9 | 9 | 7
 | h | 1 |  |  | 1 | 3 | 4
 | j | 2 | 9 | 1
 | Table 2
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 | a | 2
 | s | 2 | 2
 | d | 2
 | f | 1
 | g | 2
 | h | 1
 | j | 1
Spreadsheet: 5bd37ac6-21bb-4e7d-b889-a83e9f5f3847
Sheet: Sheet1

Cash Flow Statement | 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
Name:
Principal:
Period: |  |  |  |  |  |  |  |  |  |  |  |  | please do not enter cents
REVENUES: | Start-up |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
CFDC Loan |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total Revenues | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EXPENSES:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
CFDC Loan (P&I) |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Monthly net cash flow |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Opening Cash Balance |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Add Total Revenues | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sub. Total Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Closing Cash Balance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 881567d1729676665-creation-of-duplicate-rules-in-conditional-formatting-wip-cf-help
Sheet: Bar Chart-Cap-2018 (trial)

Deep |  |  |  | Deep+Int:
Month | Capacity Lm | Forcast Deep Lm | Cast/day  Lm | Capacity deep+Int: | Forcast Deep+Int:
Jan |  |  | 250
Feb |  |  | 250
Mar |  |  | 250
Apr |  |  | 250
May |  |  | 250
Jun |  |  | 250
Jul |  |  | 250
Aug |  |  | 250
Sep |  |  | 250
Oct |  |  | 250
Nov |  |  | 250
Dec |  |  | 250
 |  |  | Total
INTERMEDIATE |  |  |  | Mould 11/12 transfer   from R to Deep
Month | Capacity Lm | Forcast  Int:  Lm | Cast/day  Lm | PAP | Add'l Deep
Jan |  |  | 90
Feb |  |  | 90
Mar |  |  | 90
Apr |  |  | 90
May |  |  | 90
Jun |  |  | 90
Jul |  |  | 90
Aug |  |  | 90
Sep |  |  | 90
Oct |  |  | 90
Nov |  |  | 90
Dec |  |  | 90
Month | [NAME] Deep+add'l
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Spreadsheet: 74581d1275063323-sumproduct-book1
Sheet: Data

 | Company | Number of units
Halifax | TCHC | 1 | #N/A
Halifax | TCHC | 2 | #N/A
Halifax | Contract managed | 3 | #N/A
Halifax | Contract managed | 4 | #N/A
Halifax | Contract managed | 5 | #N/A
Halifax | Contract managed | 6 | #N/A
Halifax | Other companies | 7 | #N/A
Halifax | Other companies | 8 | #N/A
Halifax | Other companies | 9 | #N/A
Halifax | Other companies | 10 | #N/A
Halifax | TCHC | 11
Halifax | Contract managed | 12
Kitchener | TCHC | 13
Kitchener | Contract managed | 14
Kitchener | TCHC | 15
Kitchener | TCHC | 16
Kitchener | TCHC | 17
Kitchener | Other companies | 18
Kitchener | Other companies | 19
Kitchener | Other companies | 20
Kitchener | Contract managed | 21
Kitchener | TCHC | 22
Kitchener | Contract managed | 23
London | Contract managed | 24
London | Contract managed | 25
London | TCHC | 26
London | TCHC | 27
London | TCHC | 28
London | TCHC | 29
London | TCHC | 30
London | TCHC | 31
Spreadsheet: andy_zipper__287__Mar Apr straddle spread
Sheet: Sheet1

March | April | Srike | Int | yield | vol | t | type | Ret | Value | [NAME] | Spread settle | P/L
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0 |  |  |  |  |  | Mar/Apr spread at settle: |  |  | 0.25
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 | 3 | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0
 |  | 3 | 0.035 | 0.035 | 0.5 | 30 | 0 | 0