tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 741056d1626789877-help-with-brushing-up-formula-that-copies-row-data-automatically-from-another-sheet-gk-20-07-15-00
Sheet: Purchase Order

ORDER - PO | ORDER - STATUS: | STAFF - ORDER TAKEN BY: | DATE - INPUTTED DATA: | DATE - CUSTOMER INSTALLATION DATE: | CUSTOMER -  FULL NAME: | CUSTOMER - EMAIL: | CUSTOMER - PHONE: | CUSTOMER - ADDRESS (1ST LINE): | CUSTOMER - ADDRESS (CITY): | CUSTOMER - ADDRESS  (POST CODE): | CUSTOMER - DELIVERY ADDRESS (IF [NAME]): | PRODUCT CODE | PRODUCT SIZE (SQM) | PRODUCT COST PER UNIT (SQM) | PRODUCT QTY | PRODUCT - TOTAL COST | PAYMENT - TOTAL ORDER COST | PAYMENT - CUSTOMER PAID: | PAYMENT -OUTSTANDING | NOTES:
Spreadsheet: jonathan_mckay__16902__EnronDirect Deal Sheet-Area Managers
Sheet: Family

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | Family Leisure Centre Association of South East Calgary |  |  |  | Deal Date: | 2001-05-30 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: | Buy |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 0 | 2905
 | February | 0 | 2664
 | March | 0 | 2334
 | April | 0 | 1617
 | May | 0 | 1327
 | June | 0 | 1197
 | July | 0 | 894
 | August | 0 | 864
 | September | 0 | 1288
 | October | 0 | 1582
 | November | 0 | 2074
 | December | 0 | 2491
 | TOTAL:
Spreadsheet: eric_saibi__9831__100101R
Sheet: Zimmer 01B

Owner Name |  | Cinergy Corp.
Station Name |  | [NAME] Power Station
Unit Name |  | [NAME] 01B
NERC Region |  | ECAR
State |  | OH
Fuel Type |  | Coal
Capacity |  | 494 MW
Start Date |  | 2001-09-28 00:00:00
End Date |  | 2001-10-08 00:00:00
Prv. Start Date |  | 2001-10-12 00:00:00
Prv. End Date |  | 2001-10-16 00:00:00
Comments |  | Inspection/Tune Up
SIC |  | 4911
Plant ID |  | 1009921
Unit ID |  | 1003897
Outage ID |  | 17363
Spreadsheet: 850399d1700745309-using-conditional-formatting-to-highlight-like-numbers-or-opposite-numbers-stock-short-term-comparison-23-1-
Sheet: Sheet1

 |  |  |  |  | 1234X2cl..12..34t |  |  |  |  |  |  |  | a t6=4,t8=5,..b t4=5,t6=7,t9=3,
 | 1/2e | 0/1e | 3e | -2e |  | -4/-3e |  | -3/0a
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 0 | 0 | 1 | 0 | 1 | 0 | 2 | 0 | 3 | 1 | 2 | 0 | 1 | 2 | 4
 | 0 | 0 | 1 | 0 | 1 | 0 | 3 | 1 | 4 | 1 | 3 | 1 | 2 | 4 | 6
 | 0 | 0 | 1 | 0 | 2 | 0 | 4 | 2 | 4 | 1 | 4 | 2 | 3 | 7 | 10
 | 0 | 0 | 1 | 0 | 3 | 0 | 5 | 2 | 5 | 4 | 6 | 6 | 6 | 11 | 15
 | 0 | 0 | 1 | 0 | 3 | 0 | 6 | 2 | 5 | 6 | 10 | 10 | 11 | 16 | 20
 | 0 | 0 | 1 | 0 | 3 | 0 | 6 | 2 | 5 | 6 | 10 | 11 | 11 | 17 | 21
 | 0 | 0 | 1 | 0 | 4 | 0 | 7 | 2 | 6 | 7 | 11 | 12 | 12 | 18 | 22
Spreadsheet: 148115d1333139753-lotto-calculator-lottowinner
Sheet: Lotto

 |  | Winner 1 | Winner 2 | Winner 3 | Winner 4 | Winner 5 | Winner MB
 |  | 46 | 19 | 80 | 61 | 24 | 68
Ticket | Game | Digit 1 | Digit 2 | Digit 3 | Digit 4 | Digit 5 | [NAME] | Match 1 | Match 2 | Match 3 | Match 4 | Match 5 | Match MB | Winner?
1 | A | 46 | 19 | 80 | 61 | 24 | 68
1 | B | 65 | 17 | 74 | 56 | 47 | 24
1 | C | 66 | 92 | 85 | 88 | 57 | 1
1 | D | 1 | 16 | 69 | 3 | 42 | 1
1 | E | 86 | 89 | 6 | 54 | 21 | 29
1 | F | 49 | 98 | 90 | 61 | 8 | 75
1 | G | 95 | 79 | 47 | 67 | 47 | 73
1 | H | 16 | 47 | 25 | 84 | 87 | 60
1 | I | 73 | 50 | 89 | 26 | 70 | 54
1 | J | 14 | 67 | 20 | 12 | 82 | 21
2 | A | 15 | 54 | 83 | 63 | 21 | 41
2 | B | 48 | 39 | 3 | 56 | 27 | 26
2 | C | 44 | 56 | 73 | 11 | 46 | 83
2 | D | 37 | 26 | 9 | 80 | 76 | 79
2 | E | 38 | 45 | 3 | 96 | 50 | 92
2 | F | 71 | 82 | 11 | 83 | 72 | 76
2 | G | 51 | 89 | 3 | 80 | 39 | 76
2 | H | 19 | 10 | 10 | 46 | 57 | 14
2 | I | 12 | 70 | 7 | 68 | 59 | 38
2 | J | 4 | 32 | 81 | 67 | 34 | 10
3 | A | 35 | 67 | 28 | 27 | 56 | 87
3 | B | 13 | 44 | 28 | 37 | 39 | 84
3 | C | 0 | 89 | 96 | 40 | 31 | 72
3 | D | 30 | 88 | 78 | 9 | 46 | 55
3 | E | 15 | 56 | 33 | 13 | 33 | 66
3 | F | 9 | 28 | 58 | 1 | 18 | 28
3 | G | 42 | 42 | 95 | 63 | 30 | 51
3 | H | 80 | 77 | 47 | 45 | 99 | 41
3 | I | 66 | 3 | 7 | 80 | 67 | 95
3 | J | 36 | 20 | 56 | 90 | 35 | 23
4 | A | 94 | 23 | 5 | 45 | 2 | 9
4 | B | 37 | 86 | 29 | 0 | 80 | 87
4 | C | 15 | 67 | 30 | 37 | 10 | 22
4 | D | 89 | 32 | 24 | 86 | 33 | 19
4 | E | 37 | 61 | 85 | 67 | 3 | 0
4 | F | 27 | 4 | 83 | 39 | 38 | 0
4 | G | 2 | 53 | 61 | 37 | 91 | 63
4 | H | 34 | 84 | 32 | 60 | 40 | 47
4 | I | 91 | 53 | 30 | 57 | 73 | 52
4 | J | 88 | 61 | 84 | 32 | 16 | 15
5 | A | 58 | 66 | 92 | 98 | 49 | 1
5 | B | 49 | 51 | 5 | 4 | 37 | 64
5 | C | 89 | 6 | 64 | 18 | 6 | 92
5 | D | 23 | 89 | 14 | 37 | 63 | 51
5 | E | 79 | 80 | 29 | 83 | 63 | 0
5 | F | 53 | 39 | 63 | 63 | 19 | 31
5 | G | 88 | 61 | 14 | 96 | 47 | 12
5 | H | 75 | 90 | 2 | 28 | 91 | 48
5 | I | 66 | 26 | 91 | 95 | 29 | 86
5 | J | 83 | 48 | 97 | 9 | 7 | 50
6 | A | 75 | 44 | 71 | 62 | 3 | 28
6 | B | 43 | 95 | 55 | 44 | 56 | 26
6 | C | 24 | 64 | 14 | 13 | 84 | 78
6 | D | 95 | 53 | 75 | 33 | 56 | 41
6 | E | 86 | 53 | 84 | 33 | 12 | 42
6 | F | 51 | 65 | 37 | 80 | 65 | 63
6 | G | 9 | 85 | 45 | 53 | 49 | 92
6 | H | 6 | 14 | 8 | 30 | 15 | 35
6 | I | 47 | 89 | 2 | 32 | 67 | 74
6 | J | 89 | 86 | 82 | 40 | 76 | 38
7 | A | 2 | 10 | 39 | 79 | 11 | 63
7 | B | 50 | 7 | 14 | 39 | 10 | 53
7 | C | 6 | 19 | 3 | 51 | 12 | 59
7 | D | 97 | 28 | 97 | 85 | 49 | 66
7 | E | 3 | 85 | 54 | 17 | 12 | 37
7 | F | 26 | 68 | 44 | 14 | 51 | 28
7 | G | 19 | 76 | 15 | 16 | 40 | 4
7 | H | 4 | 67 | 38 | 50 | 19 | 23
7 | I | 5 | 79 | 91 | 29 | 55 | 47
7 | J | 11 | 32 | 58 | 93 | 19 | 97
8 | A | 1 | 0 | 74 | 55 | 27 | 49
8 | B | 14 | 98 | 81 | 52 | 24 | 1
8 | C | 71 | 76 | 73 | 38 | 92 | 70
8 | D | 41 | 75 | 40 | 89 | 44 | 64
8 | E | 90 | 53 | 7 | 99 | 95 | 54
8 | F | 48 | 0 | 91 | 80 | 28 | 65
8 | G | 89 | 24 | 22 | 68 | 83 | 22
8 | H | 21 | 37 | 91 | 56 | 30 | 2
8 | I | 49 | 95 | 51 | 79 | 22 | 53
8 | J | 57 | 92 | 15 | 76 | 95 | 57
Spreadsheet: 98948d1297765272-filter-where-certain-line-is-missing-book1
Sheet: Sheet1

Cell nr | Service | Amount | Kb
1234567 | Service 1 | 31
1234567 | Service 2 | 765 | 35189 |  |  |  | After [NAME] should look like this:
1234567 | Service 3 |  |  |  |  |  | 4567890
 |  |  |  |  |  |  | 6789101
2345678 | Service 1 | 31
2345678 | Service 2 | 654 | 11315
2345678 | Service 4 | 105 | 1950
2345678 | Service 5 | 1
2345678 | Service 6 | 1
2345678 | Service 3
3456789 | Service 1 | 31
3456789 | Service 2 | 762 | 34243
3456789 | Service 3
4567890 | Service 1 | 31
4567890 | Service 3
5678910 | Service 1 | 31
5678910 | Service 2 | 766 | 7719
5678910 | Service 3
6789101 | Service 1 | 31
6789101 | Service 4 | 105 | 1950
6789101 | Service 5 | 1
6789101 | Service 6 | 1
6789101 | Service 3
Spreadsheet: 102300d1300255623-formula-to-select-the-first-name-and-second-name-actores-20name-1-
Sheet: Sheet1

 | Actors Name |  | First Name | Second Name | hc
 | [NAME] |  | [NAME] | Hanks | 1
 | [NAME] |  | [NAME] | Depp | 1
 | [NAME] |  | [NAME] | Cruise | 1
 | [NAME] |  | [NAME] | [NAME] | 1
 | [NAME] |  | Sylvester | Stallone | 1
 | [NAME] |  | [NAME] | Di Caprio | 1
 | [NAME] |  | [NAME] | [NAME] | 1
 | [NAME] |  | [NAME] | Schwarzenegger | 1
 | [NAME] |  | [NAME] | Parker | 2
Spreadsheet: 163767d1340449056-help-matching-data-in-sheet1-based-on-data-on-sheet2-percentage
Sheet: Sheet2

MEMBERSHIP_CARD_NO | MEMBERSHIP_LEVEL | RESORT | COUNTRY | DEPARTURE_DATE | NUMBER_NIGHTS | MONTH | YEAR
9815879221 | PLATINUM | PPBKK | MY | 2010-08-08 00:00:00 | 14
9005707061 | GOLD | PPBKK | JP | 2010-02-01 00:00:00 | 4
9910102045 | BRONZE | PPBKK | MY | 2010-09-01 00:00:00 | 4
9567232761 | GOLD | PPBKK | JP | 2010-08-02 00:00:00 | 4
9448577501 | PLATINUM | [NAME] | US | 2012-03-29 00:00:00 | 2
9503518596 | GOLD | [NAME] | US | 2012-05-29 00:00:00 | 2
9796533379 | GOLD | [NAME] | US | 2012-04-28 00:00:00 | 1
9710789392 | SILVER | [NAME] | US | 2012-11-29 00:00:00 | 1
9043833763 | GOLD | [NAME] | US | 2012-04-29 00:00:00 | 1
9000415133 | GOLD | PPXMN | CN | 2011-06-02 00:00:00 | 1
9082602617 | GOLD | PPXMN | NL | 2011-04-03 00:00:00 | 1
9811307853 | SILVER | PPXMN | DE | 2011-01-05 00:00:00 | 3
9219114250 | GOLD | PPXMN | AU | 2011-12-04 00:00:00 | 2
9182449820 | GOLD | PPXMN | TW | 2011-04-07 00:00:00 | 3
9206496735 | PLATINUM | PPXMN | CN | 2011-09-05 00:00:00 | 1
Spreadsheet: 04d714de-b491-44e7-8405-7959d1ba7627
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: |  |  | 2011-01-14 14:51:57.970000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.25 | 101.5 | 101.5 | 101.375 | 100.875 |  | and are added to price quote
5.125 | 101.239 | 101.239 | 101.114 | 100.614
5 | 100.888 | 100.888 | 100.763 | 100.263 |  | Note: | Refer To Price [NAME]
4.875 | 100.051 | 100.051 | 99.92599999999999 | 99.42599999999999 |  |  | For all Price Adjs
4.75 | 99.5 | 99.5 | 99.375
4.625 | 98.541 | 98.541 | 98.416
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.625 | 101.2 | 101.2 | 101.075 | 100.575
4.5 | 101.025 | 101.025 | 100.9 | 100.4
4.375 | 100.784 | 100.784 | 100.659 | 100.159
4.25 | 100.276 | 100.276 | 100.151 | 99.651
4.125 | 99.04199999999999 | 99.04199999999999 | 98.91699999999999
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-01-14 14:51:57.970000
 |  |  |  |  |  | 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 | 2011-01-28 14:51:57.970000
30 DAY | 2011-02-12 14:51:57.970000
45 DAY | 2011-02-27 14:51:57.970000
60 DAY | 2011-03-14 14:51:57.970000
90 DAY | 2011-04-13 14:51:57.970000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 684888d1593600929-counting-the-number-of-employees-in-each-project-emp-counts-aligw
Sheet: Sheet1

Project Name | Emp Names
Project A | Emp 1
Project A | Emp 2
Project C | Emp 3
Project A | Emp 4 |  | my sheet has more than 3000+ rows.i need to know the no of employees tagged to each project in the sheet
Project A | Emp 5
Project E | Emp 6 |  | manually putting the results here for you to understand the desired results for me
Project B | Emp 7
Project B | Emp 8
Project B | Emp 9 |  |  |  |  |  | Project Name | count of employees
Project B | Emp 10 |  |  |  |  |  | Project A
Project E | Emp 11 |  |  |  |  |  | Project B
Project C | Emp 12 |  |  |  |  |  | Project C
Project B | Emp 13
Project B | Emp 14
Spreadsheet: 181363d1348003086-complex-search-based-on-multiple-data-reloading-database
Sheet: Reloading Log

Date | Caliber | Bullet Weight (gr) | Bullet Brand | Bullet Type | Powder | Charge (gr.) | Disk | Primer | Quantity | Purpose | Cost
2012-05-12 00:00:00 | .357 Sig | 100 | Remington | CTF Frangible | Accur #9 | 10 |  | Fed Small Pistol | 100 | Target
Spreadsheet: 839136d1691685940-calendar-with-recurring-weekly-events-demand-gen-enterprise-campaign-calendar_test-1-
Sheet: Calendar Items

Date | Name | Location | Recurring |  | 2023-01-01 00:00:00 |  |  | Location |  |  |  | No | 0
2023-03-15 00:00:00 | Healthcare Short Nurture | SS | Weekly |  | 2023-02-01 00:00:00 |  |  | SS | Shelley Street |  |  | Daily | 1
2023-02-15 00:00:00 | [NAME] | 1MP | Monthly |  | 2023-03-01 00:00:00 |  |  | 1MP | 1 [NAME] |  |  | Weekly | 7
2023-01-15 00:00:00 | Retail Short Nurture | 50MP | Daily |  | 2023-04-01 00:00:00 |  |  | 50MP | 50 [NAME] |  |  | Fortnightly | 14
2023-03-20 00:00:00 | Sample Event | ALL | Annual |  | 2023-05-01 00:00:00 |  |  | ALL | All sites |  |  | Monthly | 30
2014-09-01 00:00:00 | Cleaning Audit | 1MP | Weekly |  | 2023-06-01 00:00:00 |  |  |  |  |  |  | Quarterly | 90
 |  |  |  |  | 2023-07-01 00:00:00 |  |  |  |  |  |  | 6 monthly | 182
 |  |  |  |  | 2023-08-01 00:00:00 |  |  |  |  |  |  | Annual | 365
 |  |  |  |  | 2023-09-01 00:00:00
 |  |  |  |  | 2023-10-01 00:00:00
 |  |  |  |  | 2023-11-01 00:00:00
 |  |  |  |  | 2023-12-01 00:00:00
 |  |  |  |  | 2024-01-01 00:00:00
 |  |  |  |  | 2024-02-01 00:00:00
 |  |  |  |  | 2024-03-01 00:00:00
Spreadsheet: 04b372d7-ee7d-42ce-b22c-fe993f21e8ba
Sheet: Danville

 |  |  |  |  | ROOM ASSIGNMENTS |  | Room Detail | Room Type
Building | Room # | Capacity |  |  | Division
DAN | 104 | 24 |  |  | Humanities |  | computer/projector | [NAME]
DAN | 110 | 32 |  |  | MS / Humanities | 1/2 & 1/2 | computer/projector | [NAME]
DAN | 112 | 30 |  |  | MS |  | computer/projector | [NAME]
DAN | 113 | 32 |  |  | CHLSS |  | computer/projector | [NAME]
DAN | 114 | 24 |  |  | Business |  | computer/projector/smartboard | Computer Lab
DAN | 115 | 24 |  |  | CSIS |  | computer/projector/smartboard | Computer Lab
DAN | 116 | 40 |  |  | Nursing |  | computer/projector | [NAME]
DAN | 118 | 50 |  |  | Nursing / NS | 1/2 & 1/2 | computer/projector | [NAME]
DAN | 120 | 40 |  |  | Nursing / CHLSS | 1/2 & 1/2 | computer/projector | [NAME]
DAN | 122 | 15 |  |  | Nursing |  | computer/projector | [NAME]
DAN | 124 | 12 |  |  | NS |  | computer/projector | [NAME]
DAN | 129 | 12 |  |  | Trades & Technologies |  | computer/projector | Computer Lab
DAN | 130 | 18 |  |  | Manufacturing Industrial Technology |  | computer/projector | Lab
DAN | 131 | 12 |  |  | Trades & Technologies |  | computer/projector | Lab
DAN | 133 | 15 |  |  | Trades & Technologies |  | computer/projector | Lab
DAN | 134 | 14 |  |  | Manufacturing Industrial Technology |  | computer/projector | Lab
DAN | 136 | 12 |  |  | Manufacturing Industrial Technology |  | computer/projector | Lab
 |  |  |  |  |  | Room Allocation
 |  |  |  |  |  | BUS | 1
 |  |  |  |  |  | CHLSS | 1,  1/2
 |  |  |  |  |  | CSIS | 1
 |  |  |  |  |  | HUM | 1 , 1/2
 |  |  |  |  |  | MIT | 3
 |  |  |  |  |  | MS | 1,  1/2
 |  |  |  |  |  | Nursing | 2,  1/2,  1/2
 |  |  |  |  |  | NS | 1 , 1/2
 |  |  |  |  |  | TT | 3
 |  |  |  |  |  |  | 17 rooms total
Spreadsheet: 881286d1729313426-autocomplete-drop-down-list-not-working-product
Sheet: Category

Categories
Alcohol
Baby Food
[NAME]
Baking Supplies
Beer
Bread
Butter
Cakes
Candy
Canned Goods
Cheese
Chips
Cleaning Supplies
Cookies
Crackers
Deodorant
Diapers
First Aid Supplies
[NAME]
Fruits
Ice Cream
Juices
Laundry Detergent
Medicine
Milk
Nuts
Paper Products
Pasta
Pastries
Pet Food
Poultry
[NAME]
Seafood
Shampoo
Soap
[NAME]
Toothpaste
[NAME]
Vegetables
Vitamins
Water
Wine
Spreadsheet: phillip_allen__29604__SM134 Proforma
Sheet: Proforma

 |  |  | Plan 1198 ADA |  |  | Plan 1107 |  |  | Plan 1287 |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL | Per Unit | Per SF
Bedrooms/Baths |  |  | 2 | 2 |  | 2 | 2.5 |  | 3 | 3.5
Square Feet |  |  | 1198 |  |  | 1107 |  |  | 1287
Stories |  |  | Single |  |  | Two Story |  |  | Two Story
Unit [NAME] |  |  | 28 | LF |  | 15.83 | LF |  | 26 | LF
Mix
Rental Income |  |  | 1250 |  |  | 1200
Vacancy Allowance | 0.05
Management Fee | 0.05
Net Revenue
Expenses
Property Tax |  | Per SF
Insurance |  | Per SF
Maintenance |  |  | -50 |  |  | -50 |  |  | -50
Replacement Reserve | 350 | /unit/year
Utilities | 200 | Per Mo
Sub Total Expenses
Net Operating Income
Value @ 10% Capitalization Rate
Mortgage | 0.8 | LTV
Principal & Interest | 0.072 | Per Yr/30Yr
Monthly Net Income
Annual Net Income
Land
Improvements
Amenities
Unit Cost
Construction Profit
Fianance Cost
TOTAL COST
Spreadsheet: 73680d1274291658-excel-2007-automated-copying-from-worksheet-to-worksheet-based-off-text-example-for-macro-help2
Sheet: Greg

City | Travel date | Person going | Cost | Paid/Not Paid
Grand Island | 2009-04-05 00:00:00 | Greg | 180.65 | PAID
Grand Island | 2009-04-20 00:00:00 | Greg | 120 | PAID
Grand Island | 2009-06-08 00:00:00 | Greg | 180.36 | PAID
Grand Island | 2009-07-08 00:00:00 | Greg | 168.36 | PAID
Grand Island | 2009-09-09 00:00:00 | Greg | 145.9 | PAID
Kearney | 2009-02-06 00:00:00 | Greg | 210.3 | PAID
Kearney | 2009-05-18 00:00:00 | Greg | 220.36 | PAID
Omaha | 2009-01-01 00:00:00 | Greg | 111.22 | PAID
Omaha | 2009-03-01 00:00:00 | Greg | 125 | PAID
Omaha | 2009-06-01 00:00:00 | Greg | 132.15 | PAID
Spreadsheet: 233688d1367897501-extract-rows-to-another-sheet-based-on-specific-words-auto-updates-extracting-data-to-another-worksheet
Sheet: Data as downloaded

Fiction data as downloaded from the bank
Date | Payee | Memo | Amount
2013-04-01 00:00:00 | ASB BANK Insurance |  | 3000
2013-04-02 00:00:00 | AMI INSURANCE     DL |  | -56.71
2013-04-02 00:00:00 | TELECOM |  | -173.95
2013-04-08 00:00:00 | RETAIL FINANCIAL SER |  | -389.59
2013-04-11 00:00:00 | GENESIS ENERGY |  | -61.86
2013-04-21 00:00:00 | TELECOM |  | -101.47
2013-04-21 00:00:00 | LOAN - INTEREST | Loan 1 | -715.07
2013-04-21 00:00:00 | LOAN - PRINCIPAL | Loan 1 | -102.74
2013-04-21 00:00:00 | LOAN - INTEREST | Loan 2 | -35.01
2013-04-21 00:00:00 | LOAN - INTEREST | Loan 2 | -15
2013-04-21 00:00:00 | LOAN - PRINCIPAL | Loan 2 | -50.39
2013-04-21 00:00:00 | LOAN - INTEREST | Loan 1 | -77.28
2013-04-22 00:00:00 | LOAN - INTEREST | Loan 2 | -129.79
2013-04-22 00:00:00 | LOAN - PRINCIPAL | Loan 1 | -191.59
2013-04-22 00:00:00 | LOAN - INTEREST | Loan 2 | -203.74
2013-04-22 00:00:00 | WHANGAREI DC |  | -323.74
2013-04-22 00:00:00 | ASB BANK Insurance |  | -166.42
2013-04-22 00:00:00 | TOWER HEALTH & LIFE |  | -163.16
2013-04-22 00:00:00 | PAYMENT |  | -47.19
2013-04-22 00:00:00 | TOWER MEDICAL INSURA |  | -60
2013-04-24 00:00:00 | TOWER HEALTH & LIFE |  | -21.64
2013-04-26 00:00:00 | TELECOM |  | -30
2013-04-29 00:00:00 | PAYMENT |  | -2
2013-05-01 00:00:00 | RETAIL FINANCIAL SER |  | -18.84
Spreadsheet: 757936d1638543684-calculating-4-threads-issue-with-tracker-pla-learning-journey-example-
Sheet: Stage 2 & QAF (John)

[NAME] |  |  |  |  |  |  |  |  |  |  | Openings Learning | Openings Learning | Openings Learning | Openings Learning | Openings Learning | Openings Sign Off | Openings Sign Off | Middles Learning | Middles Learning | Middles Learning | Middles Learning | Middles Learning | Middles Learning | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Closures Sign Off | Closures Sign Off |  | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF
[NAME] | [NAME] | Front-Line Manager Name | Grade | Location | Tax Regime | Project | Date TPP Commenced | TUD Date | Cohort | Expected TPP Week | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19 | Week 20 | Week 21 | Week 22 | Week 23 | Week 24 | Week 25 | Week 26 | Week 27 | Week 28 | Week 29 | Week 30 | Week 31 | Week 32 | Week 33 | [NAME] | Expected QAF Milestone 1 (Week 10) | Actual Milestone 1 Completion | Formula 2 | Expected QAF Milestone 2 (Week 22) | Actual [NAME] | Formula 5 | Expected QAF Milestone 3 (Week 38) | Actual [NAME] | [NAME] | Expected QAF Milestone 4 (Week 52) | Actual [NAME] | Forumula 9 | Expected QAF Milestone 5 (Week 69) | Actual [NAME] | [NAME] 10 | Expected QAF Milestone 6 (Week 78) | Actual [NAME] | [NAME] | Expected QAF Completion (18 months) | Actual QAF Completion | [NAME] 12 | Exceptions
 | 123 | Manager A | 5 | Wales | #N/A | A1 | 44424 | 44424 | A1.1 | #N/A | x | x | x | x | x | 0 | 0 | x | 0 | x | 0 | 0 | x | 0 | 0 | x | 0 | 0 | x | #N/A
Learner 2 | 234 | Manager A | 5 | Wales | #N/A | A1 | 44421 | 44417 | A1.1 | #N/A | x | X | X | x | x | 0 | 0 | x | 0 | x | 0 | 0 | x | 0 | 0 | 0 | 0 | 0 | x | #N/A
Learner 5 | 567 | Manager C | 5 | England | #N/A | A3 | 44466 | 44452 | A3.3 | #N/A | x | x | x | x | x | x | x | x | x | x | 0 | x | x | x | x | x | x | x | x | #N/A
Spreadsheet: 4928958d-9bdb-4f2e-b4c7-421ab03ed6f4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 31. LEASE FINANCE COMMITMENTS, By Purpose: State (NSW), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413975X | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413976A | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413977C | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413978F | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413979J | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413980T | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413981V | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413982W | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413983X | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413984A | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413985C | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413986F | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413987J | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413988K | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413989L | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413990W | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011