tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 687181d1595009142-nested-if-then-statement-help-new-microsoft-excel-worksheet
Sheet: Sheet1

 |  |  |  |  |  | 2020 |  |  | 2021
 |  | Site | Capacity | Load |  | FCST | [NAME] | PROJECTED | FCST | [NAME] | PROJECTED | TOTAL PROJECTED |  | [NAME] | Positions Available
 |  | A | 1000 | 500 |  | 1 |  |  | 1
 |  | B | 2000 | 1200
 |  | C | 5000 | 2500 |  | 1 |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | I want this Column O to check
 |  |  |  |  |  |  |  |  |  |  |  |  |  | If TOTAL PROJECTED is 0, then give me CAPCITY - LOAD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | but if TOTAL PROJECTED is not 0, then give me CAPACITY - TOTAL PROJECTED
Spreadsheet: 828521d1683564223-sum-fte-counts-by-month-between-two-dates-test
Sheet: EV

Earned Value Worksheet
This worksheet is used to help calculate the Earned Value (EV) or Budgeted Cost of Work Performed (BCWP).
Make sure that the WBS, Task Name, and TBC are identical to the table in the Report worksheet.
Enter the % Complete for each task to calculate the cumulative earned value.
Cumulative Earned Value (EV)
WBS | Task Name | TBC
 |  |  | 0.15 | 0.5 | 1 | 1 | 1 | 1 | 1
 |  |  |  | 0.25 | 0.3 | 0.6 | 0.75 | 0.9 | 1
 |  |  |  |  | 0.25 | 0.4 | 0.5 | 1 | 1
 |  |  |  |  |  |  | 0.25 | 0.8 | 0.9
 |  |  |  |  |  |  |  | 0.25 | 0.75
 |  |  |  |  |  |  |  |  | 0.5
[NAME] new rows above this one
 |  | Cumulative EV
Spreadsheet: 537169d1504854972-divide-plan-table-data-in-actual-table-using-excel-formula-or-vba-task1
Sheet: Planned

 | Plan |  |  |  |  |  |  |  |  | Actual
Project | [NAME] | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 |  | Project | [NAME] | Start Date | End Date | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00
P001 | Engineer | 160 | 160 | 160 | 160 | 160 | 160 |  | P001 | Engineer | 2017-04-01 00:00:00 | 2017-06-30 00:00:00 | 160 | 160 | 160
P001 | Coordinator | 160 | 160 | 160 | 160 | 160 | 160 |  | P001 | Engineer | 2017-07-01 00:00:00 | 2017-09-30 00:00:00 |  |  |  | 160 | 160 | 160
P001 | Manager | 160 | 160 | 160 | 160 | 160 | 160 |  | P001 | Coordinator | 2017-04-01 00:00:00 | 2017-06-15 00:00:00 | 160 | 160 | 80
P001 | Support | 160 | 160 | 160 | 160 | 160 | 160 |  | P001 | Coordinator | 2017-06-16 00:00:00 | 2017-09-30 00:00:00 |  |  | 80 | 160 | 160 | 160
P002 | Engineer | 160 | 160 | 160 | 160 | 160 | 160 |  | P001 | Manager | 2017-04-01 00:00:00 | 2017-09-30 00:00:00 | 160 | 160 | 160 | 160 | 160 | 160
P002 | Coordinator | 160 | 160 | 160 | 160 | 160 | 160 |  | P001 | Support | 2017-05-01 00:00:00 | 2017-09-30 00:00:00 |  | 160 | 160 | 160 | 160 | 160
P002 | Manager | 160 | 160 | 160 | 160 | 160 | 160 |  | P002 | Engineer | 2017-04-01 00:00:00 | 2017-05-30 00:00:00 | 160 | 160
P002 | Support | 160 | 160 | 160 | 160 | 160 | 160 |  | P002 | Engineer | 2017-06-01 00:00:00 | 2017-09-30 00:00:00 |  |  | 160 | 160 | 160 | 160
 |  |  |  |  |  |  |  |  | P002 | Coordinator | 2017-04-01 00:00:00 | 2017-06-15 00:00:00 | 160 | 160 | 80
 |  |  |  |  |  |  |  |  | P002 | Coordinator | 2017-06-16 00:00:00 | 2017-09-30 00:00:00 |  |  | 80 | 160 | 160 | 160
 |  |  |  |  |  |  |  |  | P002 | Manager | 2017-04-01 00:00:00 | 2017-09-30 00:00:00 | 160 | 160 | 160 | 160 | 160 | 160
 |  |  |  |  |  |  |  |  | P002 | Support | 2017-04-01 00:00:00 | 2017-06-07 00:00:00 | 160 | 160 | 40
 |  |  |  |  |  |  |  |  | P002 | Support | 2017-06-08 00:00:00 | 2017-09-30 00:00:00 |  |  | 120 | 160 | 160 | 160
Spreadsheet: 85836d1285864994-a-complicated-sort-sotest
Sheet: RawData

This is the horrible way that the program exports data
Sale Number: 9977 |  |  | Recorded Sale Date: 01/20/2010 12:00:00 AM
Customer: Special, Nobody |  |  |  | Processed Date: 01/20/2010 3:23:28 PM
Interment: Cremation (1 @ 110)
 |  |  | Debit | Credit
1451-20 | Grave Digging |  |  | 110
4251-10 | GST Collected |  |  | 5.5
 | Account Allocations Total: |  |  | 115.5
Rights Transfer: Cremation - Non-resident (1 @ 322)
 |  |  | Debit | Credit
1451-50 | Care Fund |  |  | 80
4251-10 | GST Collected |  |  | 16.1
1451-10 | Plot Sales |  |  | 242
 | Account Allocations Total: |  |  | 338.1
Memorials: Installation - First Time (1 @ 145)
 |  |  | Debit | Credit
1451-50 | Care Fund |  |  | 37
1451-30 | Grave Marker Maintenance |  |  | 108
4251-10 | GST Collected |  |  | 7.25
 | Account Allocations Total: |  |  | 152.25
Sale Number: 9978 |  |  | Recorded Sale Date: 01/20/2010 12:00:00 AM
Customer: Doe, [NAME] |  |  |  | Processed Date: 01/20/2010 3:56:15 PM
Memorials: Installation - Reset (1 @ 108)
 |  |  | Debit | Credit
1451-30 | Grave Marker Maintenance |  |  | 108
4251-10 | GST Collected |  |  | 5.4
 | Account Allocations Total: |  |  | 113.4
Sale Number: 9979 |  |  | Recorded Sale Date: 01/22/2010 12:00:00 AM
Customer: [NAME], [NAME] |  |  |  | Processed Date: 01/22/2010 2:51:18 PM
Miscellaneous: Reclassify Deferred for Interment (1 @ -200)
 |  |  | Debit | Credit
4290-11 | Unearned Revenue - Reclassify | 200
 | Account Allocations Total: | 200
Interment: Columbarium Niche - From Deferred (1 @ 200)
 |  |  | Debit | Credit
1451-20 | Grave Digging |  |  | 200
 | Account Allocations Total: |  |  | 200
Sale Number: 9980 |  |  | Recorded Sale Date: 01/22/2010 12:00:00 AM
Customer: [NAME], [NAME] |  |  |  | Processed Date: 01/22/2010 3:04:24 PM
Miscellaneous: Reclassify Deferred for Interment (1 @ -200)
 |  |  | Debit | Credit
4290-11 | Unearned Revenue - Reclassify | 200
 | Account Allocations Total: | 200
Interment: Columbarium Niche - From Deferred (1 @ 200)
 |  |  | Debit | Credit
1451-20 | Grave Digging |  |  | 200
 | Account Allocations Total: |  |  | 200
Spreadsheet: 843982d1695797360-find-the-estimated-time-required-to-manufacture-a-product-based-on-non-linear-min-max-data-linearregressionmanufacturingscatter
Sheet: Sheet1

n | t | Linear | Exp | [NAME]) | Exp(S)
1 | 6
10000 | 2700
5000
 | 5.730573057305719
 | 5.996335204541927
Spreadsheet: 811135d1672302522-combining-vlookup-and-match-journals
Sheet: Sheet1

BR1 | November
2370324 |  |  | 8240.68
2570324 |  |  | 2000
2670324 |  |  | 1999.97
2770324 |  |  | 2939.39
2973266 |  |  | 2256.35
3224020 |  |  |  | 8240.68
3224020 |  |  |  | 2000
3224020 |  |  |  | 1999.97
3224020 |  |  |  | 2939.39
3224020 |  |  |  | 2256.35
 | Journal Balance
BR2
3370324 |  |  | 3333.32
2570324 |  |  | 999.98
2670324 |  |  | 1000.02
2770324 |  |  | 1789.68
2770324 |  |  | 441.68
2973223 |  |  | 465.78
2973223 |  |  | 2485.08
2973223 |  |  | 325.49
3228003 |  |  | 154.05
3228003 |  |  | 100.65
3228003 |  |  | 48.27
3228003 |  |  | 154.24
3228003
3228003
3228003
3228003
3227008
3227008
3228003 |  |  | 67.54
32280322 |  |  | 653.78
3224020 |  |  |  | 2044.54
3224020 |  |  |  | 4200.02
3224020 |  |  |  | 3333.32
3224020 |  |  |  | 999.98
3224020 |  |  |  | 1000.02
3228003 |  |  |  | 441.68
 | Journal Balance
Spreadsheet: 746136d1630520613-transformirng-a-from-time-to-time-list-into-a-date-by-date-list-summing-hours-on-a-daily-basis-schmidmb-
Sheet: sheet1

comes | goes | time here |  | Start Date | End Date | Comes | Goes | Here | Away
2020-12-01 17:30:00 | 2020-12-03 18:00:00
2020-12-10 14:00:00 | 2020-12-10 18:00:00
2020-12-21 09:00:00 | 2020-12-22 19:00:00
2020-12-24 15:00:00 | 2020-12-24 17:02:00
2020-12-29 17:20:00 | 2021-01-08 16:05:00
Spreadsheet: 5610f7b8-4c78-4f0a-abf0-aa4af8674665
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
 | 6202.0 Labour Force, Australia
 | Table 20. Aggregate monthly hours worked by State - Trend and Seasonally adjusted
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Aggregate Monthly Hours Worked ;  NEW SOUTH WALES ; |  |  | Trend | A3591553W | 1978-07-01 00:00:00 | 2014-01-01 00:00:00 | 427 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  VICTORIA ; |  |  | Trend | A3591554X | 1978-07-01 00:00:00 | 2014-01-01 00:00:00 | 427 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  [NAME] ; |  |  | Trend | A3591555A | 1978-07-01 00:00:00 | 2014-01-01 00:00:00 | 427 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  SOUTH AUSTRALIA ; |  |  | Trend | A3591556C | 1978-07-01 00:00:00 | 2014-01-01 00:00:00 | 427 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  WESTERN AUSTRALIA ; |  |  | Trend | A3591557F | 1978-07-01 00:00:00 | 2014-01-01 00:00:00 | 427 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  TASMANIA ; |  |  | Trend | A3591558J | 1978-07-01 00:00:00 | 2014-01-01 00:00:00 | 427 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  NORTHERN TERRITORY ; |  |  | Trend | A3591559K | 1978-07-01 00:00:00 | 2014-01-01 00:00:00 | 427 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  AUSTRALIAN CAPITAL TERRITORY ; |  |  | Trend | A3591560V | 1978-07-01 00:00:00 | 2014-01-01 00:00:00 | 427 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  NEW SOUTH WALES ; |  |  | Seasonally Adjusted | A3591544V | 1978-07-01 00:00:00 | 2014-01-01 00:00:00 | 427 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  VICTORIA ; |  |  | Seasonally Adjusted | A3591545W | 1978-07-01 00:00:00 | 2014-01-01 00:00:00 | 427 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  [NAME] ; |  |  | Seasonally Adjusted | A3591546X | 1978-07-01 00:00:00 | 2014-01-01 00:00:00 | 427 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  SOUTH AUSTRALIA ; |  |  | Seasonally Adjusted | A3591547A | 1978-07-01 00:00:00 | 2014-01-01 00:00:00 | 427 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  WESTERN AUSTRALIA ; |  |  | Seasonally Adjusted | A3591548C | 1978-07-01 00:00:00 | 2014-01-01 00:00:00 | 427 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  TASMANIA ; |  |  | Seasonally Adjusted | A3591549F | 1978-07-01 00:00:00 | 2014-01-01 00:00:00 | 427 | 000 Hours | FLOW | Month | 1
© Commonwealth of Australia  2014
Spreadsheet: 64039d1264901218-dependent-data-validation-lists-dependentlists
Sheet: Choices

On this page we use Validation List of |  |  |  |  |  | Sample Lists
Allow: =Animals
for both H5 and H19 versions. |  |  |  |  |  | Problematic
 |  |  |  |  |  |  | Classes | Types | Animals
Then, the validation list for I5 uses an INDIRECT formula |  |  |  |  |  |  | Avian | Tigers | [NAME]
Allow:  =INDIRECT(H5)
so the word chosen becomes the active "list" and the animal
names are brought over. The same thing is used in the |  |  |  |  |  |  | NOTE: Problem if you make selections in the boxes above, and then go back and change an earlier box
validation list for J5: |  |  |  |  |  |  | it does not change the others, so you could end up with Canine - Tiger - Bald Eagle.
Allow:  =INDIRECT(I5)
This technique could go on indefinitely. |  |  |  |  |  |  | SOLUTION: A WorkSheet_change macro can be used to watch for changes in the earliest boxes and then
 |  |  |  |  |  |  | clear the previous made in later boxes that are now no longer valid.
The "LISTS" are on the next sheet.
 |  |  |  |  |  |  | Right-click on the sheetname tab and VIEW CODE to see the macro.
 |  |  |  |  |  | Better
 |  |  |  |  |  |  | Classes | Types | Animals
 |  |  |  |  |  |  | Canine
Spreadsheet: andy_zipper__187__DYNEGY-ICE VOL May18
Sheet: DD-ENA

Dynegy Direct
Enron North America
UOM | Deals | Volume
Coal |  |  | Note: COAL PRB8800 VOL is 1 Train (12,500 ST/Train/Mo)
US Natural Gas
Power
Enron Trader | Period | Total Volume | Activity Type | Customer | Major Commodity | User Name | Dynegy User Name | Minor Commodity | Priority Of Service | Deal Type | Location | Pricing Mechanism | Settlement Type | Term | Term Start Date | Term End Date | Delivery Time | Transportation Description | Transaction Date | Transaction Time | Buy/Sell | Volume | Price | Deal Number
 |  |  | Transaction | ENRON NORTH AMERICA CORP. | US Natural Gas | ENECGERMANY | DYNCMCG | ng.US Natural Gas | ng-pwr.Firm | Physical | ng.TETCO ELA | ng-pwr.Fixed Price |  | ng.Next Day | 2001-05-19 00:00:00 | 2001-05-21 00:00:00 |  |  | 2001-05-18 00:00:00 | 09:17 A.M. | BUY | 5000 | 4.09 | 31491
 |  |  | Transaction | ENRON NORTH AMERICA CORP. | US Natural Gas | ENECGERMANY | DYNCMCG | ng.US Natural Gas | ng-pwr.Firm | Physical | ng.TETCO ELA | ng-pwr.Fixed Price |  | ng.Next Day | 2001-05-19 00:00:00 | 2001-05-21 00:00:00 |  |  | 2001-05-18 00:00:00 | 09:36 A.M. | BUY | 5000 | 4.09 | 31522
 |  |  | Transaction | ENRON NORTH AMERICA CORP. | US Natural Gas | ENECGERMANY | DYNTTU | ng.US Natural Gas | ng-pwr.Firm | Physical | ng.TGT Zone SL | ng-pwr.Fixed Price |  | ng.Next Day | 2001-05-19 00:00:00 | 2001-05-21 00:00:00 |  |  | 2001-05-18 00:00:00 | [NAME] | SELL | 10000 | 4.13 | 31344
 |  |  | Transaction | ENRON NORTH AMERICA CORP. | US Natural Gas | ENEPEREI | [NAME] | ng.US Natural Gas | ng-pwr.Firm | Physical | ng.[NAME] 3, Station 65 | ng-pwr.Fixed Price |  | ng.Next Day | 2001-05-19 00:00:00 | 2001-05-21 00:00:00 |  |  | 2001-05-18 00:00:00 | 10:08 A.M. | BUY | 10000 | 4.165 | 31546
Spreadsheet: 843616d1695394903-name-row-based-on-column-value-camp-w-largest-1-
Sheet: Sheet1

Name | Assiniboia | Koinonia | Moose Lake
 | 3 | 1 | 4
Assiniboia | 4 | 0 | 2
Koinonia | 1 | 5 | 4
Assiniboia | 5 | 3 | 3
tie Assiniboia and Moose Lake | 3 | 1 | 3
Moose Lake | 1 | 0 | 3
tie Assiniboia and Moose Lake | 3 | 0 | 3
Moose Lake | 1 | 0 | 3
Spreadsheet: vkaminski__40933__raptor4b
Sheet: Shares

 |  |  | $ Equivalents | Share Equivalents
ENE Stock Price
ENE Shares held by WW | 50000000
Osprey 144A Debt outstanding
Subtotal:  Remaining value
Less:
Raptor I commitment | 3876755 |  |  | 3876755
Raptor II commitment | 7809790 |  |  | 7809790
Raptor IV commitment | 6326045 |  |  | 6326045
Ending Balance
Reduction in Share Price available
Raptor IV Shares
Origanal Shares
Origanal Discount
Amortization
Balance
Shares Available
Origanal Discount
Amortization
Balance Sheet
Check
Reserve for Shares
Spreadsheet: 165317d1341161457-average-of-range-based-on-lookup-average-yearly-wages
Sheet: Sheet1

Year | Wage |  | Start Year | End Year | Average
2012 | 10 |  | 2012 | 2013 |  | <<Look at this formula for the answer.
2013 | 11.5 |  | 2012 | 2012
2014 | 12.25 |  | 2014 | 2015
2015 | 13
Spreadsheet: 04b372d7-ee7d-42ce-b22c-fe993f21e8ba
Sheet: Regency

 |  |  | ROOM ASSIGNMENTS |  | Room Detail | Room Type
Building | Room # | Capacity | Division
Regency | 100 | 20 | BUS |  | computer lab
Regency | 102 | 16 | HUM |  | computer lab
Regency | 104 | 16 | CSIS/BUS(secondary) | 1/2 & 1/2 | computer lab
Regency | 108 | 20 | BUS/NS | 1/2 & 1/2 | [NAME]
Regency | 120 | 24 | BUS |  | [NAME]
Regency | 201 | 28 | BUS |  | smart
Regency | 203 | 28 | BUS |  | smart
Regency | 204 | 28 | MS
Regency | 205 | 20 | HUM
Regency | 206 |  | HUM (film)
Regency | 207/209 | 24 | Registrar Room
Regency | 208 | 28 | CHLSS |  | [NAME]
Regency | 211 | 28 | CHLSS
Regency | 213 | 20 | CHLSS
 |  |  |  | Room Allocation
 |  |  |  | BUS | 4, 1/2, 1/2
 |  |  |  | CHLSS | 3
 |  |  |  | CSIS | 1/2
 |  |  |  | HUM | 3
 |  |  |  | MS | 1
 |  |  |  | NS | 0.5
 |  |  |  | Registrar | 2
 |  |  |  |  | 15 rooms total
Spreadsheet: 109724d1306501121-excel-2007-specific-date-compared-to-date-range-fed-calc-v3
Sheet: Year 20

 | Case Number |  |  |  |  | Date Prepared
 | Non Custodial Parent |  |  |  |  |  | Reconciliation Date
 | CP/Caretaker
 | YEAR 20:
 |  | Amount Due |  |  |  |  |  | Charging
 |  |  |  |  |  |  |  | Order
Month |  | ORDER 1 | ORDER 2 | ORDER 3 | ORDER 4 | ORDER 5 |  | Amount
229 | January
230 | February
231 | March
232 | April
233 | May
234 | June
235 | July
236 | August
237 | September
238 | October
239 | November
240 | December
 | Support Due
 | Support Paid
 | [NAME]
 | Accrued Arrearage
 | Last Year Carryover
 | Lump/TANF
 | This Year
 | Total
 | Interest Rate
 | Arrears Interest
 | Fees Due
 | Fees Paid
 | Fees Owed
Spreadsheet: 729399d1619073485-data-validation-list-with-conditions-and-vlookup-test_validation-1-
Sheet: Sheet1

Value A | Value B |  |  |  |  |  |  |  |  |  |  |  |  | Unique Value A
1.1.1.1 | 1.3
1.3.5.4 | 2.1 |  |  |  | Value A | Value B
3.2.2 | 1.3
4.1.3 | 3.6 |  |  |  | 1.1.1.1 | 1.3
1.2.1.1 | 1.4
1.2.1.1 | 2.1
3.1.1 | 1.3 |  |  |  | 3.1.1 | 1.3
3.1.1 | 3.6
Spreadsheet: 864800d1711949502-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record-aligw
Sheet: Pigment Red Oxide

Raw Material |  | Pigment Red Oxide
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 44.709
2023-10-28 00:00:00 |  |  |  |  | 17.5
Total
Spreadsheet: 863503d1710955821-finding-matching-numbers-in-3-different-cells-find-numbers_2
Sheet: Sheet1

Lookup this: | 12 | 7 | 61
Identify  Row | HERE | if found.
In these columns: | A | B | C
 | 1 | 2 | 3
 | 2 | 3 | 4
 | 3 | 4 | 5
 | 4 | 5 | 6
 | 5 | 6 | 7
 | 6 | 7 | 8
 | 7 | 8 | 9
>>> | 61 | 12 | 7
 | 9 | 10 | 11
 | 10 | 11 | 12
 | 11 | 12 | 13
 | 12 | 13 | 14
 | 13 | 14 | 15
 | 14 | 15 | 16
 | 15 | 16 | 17
 | 16 | 17 | 18
 | 17 | 18 | 19
 | 18 | 19 | 20
Spreadsheet: 759547d1639589649-calculate-fte-per-running-month-counting-full-ftes-late-hires-and-early-terminations-hd1080-
Sheet: Sheet1

Employee | Start Date | End Date | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
E1 | 2020-01-04 00:00:00
E2 | 2021-04-08 00:00:00
E3 | 2021-07-15 00:00:00
E4 | 2021-01-08 00:00:00 | 2021-04-23 00:00:00
E5 | 2021-09-25 00:00:00
E6 | 2021-03-27 00:00:00 | 2021-05-02 00:00:00
E7 | 2021-07-05 00:00:00
E8 | 2021-09-19 00:00:00
E9 | 2021-05-08 00:00:00
E10 | 2020-12-01 00:00:00
E11 | 2020-12-04 00:00:00
 |  | Total FTE's
Spreadsheet: 881837d1730055520-worksheet-with-month-drop-down-sheet-changes-based-on-month-help-bills-jot
Sheet: February

Monthly Bills Jot
From [NAME] | mortgage | 397.5
 | bills | 182.41
 | pot | 500
 | receipts | 107.07
 | owed | 0
Back to jack | credit | 0 | pay off credit card
 |  |  |  |  |  |  |  | lunch | 10
Mine | To Bills | 759.4 |  |  |  |  |  | water/misc | 10
 | Credit Card ex |  |  |  |  |  |  | sun lounger | 10
 | Receipts | 107.07 |  |  |  |  |  | evening meal | 75
 | To Pot | 0 |  |  |  |  |  |  |  | 500
 | Pay credits
 | Santander
 |  |  |  |  |  |  |  | total
- | + | 0
minus |  | 50
 |  | 150
£100 leave in bills pot this month only. £150 leave for virgin. £50 off other card
Spreadsheet: 456247d1460715984-how-to-add-a-character-to-a-cell-if-a-certain-number-is-in-another-x-marks-the-spot
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
Spreadsheet: 240d15ab-bb27-4abb-8d46-424af2f4e6fc
Sheet: Sheet1

CDBG Missing Data | 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 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
CORVALLIS OR
Data as of 06/01/2009
Act ID | Status | [NAME] | Matrix CD | Prop Accomp MA04 | Actual [NAME] | Total [NAME] CDBG08 | Create FT Jobs CDBG11 | Create FT Jobs LM CDBG11 | Create PT Hours CDBG11 | Create PT Hours LM CDBG11 | Retain FT Jobs CDBG11 | Retain FT Jobs LM CDBG11 | Retain PT Hours CDBG11 | Retain PT Hours LM CDBG11 | Assist Type CDBG11 | [NAME] CDBG13 | [NAME] CDBG13 | Num Very Low Incm CDBG13 | Units Start CDBG14 | Units [NAME] CDBG14 | Units Occ LM Start CDBG14 | Units Exp CDBG14 | Units [NAME] CDBG14 | Units Occ LM Exp CDBG14 | LMA % CDBG07
354 | 4 | LMH | 14B | 82 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 148477d1333441833-rent-calculation-with-days-wise-escalation-rent-master
Sheet: Sheet1

 |  |  |  |  |  |  |  | Quarter 1 |  |  |  | Quarter 2 |  |  |  | Quarter 3 |  |  |  | Quarter 4
S.No. | Agreement Commencement Date | Agreement Valid Upto  (Year) | Base Rent (Yearly) | Hike on Rent  (Tenure yearly) | Hike on Rent  (%) | Financial year | Agreement [NAME] | APRIL (30 Days) | MAY (31 Days) | JUNE (30 Days) | Quarter 1 Amount | JULY (31 Days) | AUGUST (31 Days) | SEPTEMBER (30 Days) | Quarter 2 Amount | OCTOBER (31 Days) | NOVEMBER (30 Days) | DECEMBER (31 Days) | Quarter 2 Amount | [NAME] (30 Days) | FEBRUARY (Days as per leap year) | [NAME] (31 Days) | Quarter 4 Amount
1 | 2004-03-10 00:00:00 | 8 | 200000 | 2 | 0.15 | 2011-2012 | 2012-03-08 00:00:00 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 | Total Yearly Rent + escalations divided by 12 = monthly rent and in this condition agreement is expired on 8th March 12 so rent to be paid upto 8 th March only  and For March (31 days) month rent would be calculate as total monthly rent/31*8 days of march month.
2 | 2003-01-12 00:00:00 | 6 | 500000 | 3 | 0.1 | 2008-2009 | 2009-01-10 00:00:00 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 | In this condition rent financial year is different and agreement is expired on 10 jan 2009. So rent to be paid upto 10 jan 2009 only and  in jan month rent to be paid as monthly rent/31*10 days
3 | 2007-11-15 00:00:00 | 5 | 1500000 | 1 | 0.15 | 2011-2012 | 2012-11-13 00:00:00 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 | Here as per financial year rent required agreement is expired on 13 nov 2012 so rent for Nov would be calculate as total monthly rent/30 days*13 days of Nov.
4 | 2011-10-15 00:00:00 | 3 | 450000 | 1 | 0.09 | 2011-2012 | 2014-10-14 00:00:00 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 | In this condition as per financial year required rent would be calculated from 15 Oct 2011 so no such amount to be paid from april 11 to Sep 11 and For Nov month rent would be paid for 15 days only as agreement commence date and Month is 0f 30 days
5 | 2002-04-28 00:00:00 | 8 | 320000 | 3 | 0.05 | 2011-2012 | 2010-04-26 00:00:00 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 | In this condition agreement is already expired as per required year rent so no rent to be paid all fiels would be blank.
6 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
7 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
8 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
9 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
10 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0