tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18250__DJ Index 3-31
Sheet: Sheet1

Electricity Price Index Report
Rep. [NAME]: | 2001-03-30 00:00:00
Flow Date: | 2001-03-31 00:00:00
From: | Enron Power Marketing Inc. - Kate Symes
Phone: | (800) 464-7486
Fax: | (503) 464-3740
To: | [NAME] or [NAME]
Phone: | (609) 520-4452 ([NAME])
Phone: | (609) 520-4663 (Earnest Onukogu)
Fax: | (609) 452-3531
COB
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 186.25 | 1600
 | Firm Trades Purchases | 178.3333333333333 | 1200
[NAME] | Firm Trades Sales | 119.2897727272727 | 1408
 | Firm Trades Purchases | #[NAME]! | 0
MID COLUMBIA
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 178 | 2000
 | Firm Trades Purchases | 178 | 400
[NAME] | Firm Trades Sales | 125.8333333333333 | 1200
 | Firm Trades Purchases | 125 | 200
PALO VERDE
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 155.7826086956522 | 9200
 | Firm Trades Purchases | 155 | 2400
[NAME] | Firm Trades Sales | 79.66666666666666 | 1200
 | Firm Trades Purchases | #[NAME]! | 0
MEAD
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 160 | 400
 | Firm Trades Purchases | 145 | 160
[NAME] | Firm Trades Sales | 90 | 400
 | Firm Trades Purchases | #[NAME]! | 0
NP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 149.3 | 4000
 | Firm Trades Purchases | 163.5 | 800
[NAME] | Firm Trades Sales | 93.4 | 1000
 | Firm Trades Purchases | 92.11538461538461 | 1040
SP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 164.375 | 3200
 | Firm Trades Purchases | 162.764705882353 | 1360
[NAME] | Firm Trades Sales | 93.88524590163932 | 2440
 | Firm Trades Purchases | 91.13333333333333 | 600
Spreadsheet: 73584d1274219095-return-data-from-table-example-table
Sheet: Sheet1

[NAME] | Insulation | quantity |  |  |  | Insulation | [NAME]
 |  |  |  |  |  |  | 3/8" | 0.5 | 0.625 | 0.875 | 1.125 | 1.375 | 1.625 | 2.125 | 2.625 | 3.125 | 4.125
0.375 | 0.375 | ? |  |  |  | 0.375 | 100 | 80 | 65 | 50 | 35 | 30 | 20 | 16 | 12 | 9
0.5 | 0.75 | ? |  |  |  | 0.5 | 75 | 66 | 54 | 35 | 28 | 20 | 15 | 10 | 10 | 7 | 4
0.625 | 0.75 | ? |  |  |  | 0.75 | 40 | 38 | 28 | 22 | 16 | 12 | 10 | 9 | 8 | 7 | 4
etc |  |  |  |  |  | 1 |  |  | 20 | 15 | 13 | 10 | 8 | 6 | 6 | 5 | 3
etc
etc
Spreadsheet: 801087d1666079410-formula-to-get-value-according-date-hassanbook1
Sheet: Sheet1 (2)

 |  |  |  |  |  |  | Date | 2022-10-13 00:00:00 | 2022-10-13 00:00:00 | 2022-10-13 00:00:00 | 2022-10-13 00:00:00 | 2022-10-13 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-15 00:00:00 | 2022-10-15 00:00:00 | 2022-10-15 00:00:00 | 2022-10-15 00:00:00 | 2022-10-15 00:00:00
 |  |  |  |  |  |  |  | Math | Science | Geo | History | English | Math | Science | Geo | History | English | Math | Science | Geo | History | English
 |  |  |  |  |  |  | George | A | A | A | P | P | A | A | A | A | A | A | A | P | A | A
 |  |  |  |  |  |  | [NAME] | P | P | P | P | P | A | A | A | A | A | P | P | P | P | A
 |  |  |  |  |  |  | Leen | A | A | A | A | P | P | P | P | P | P | P | P | P | P | A
 |  |  |  |  |  |  | [NAME] | A | P | P | A | A | P | A | A | A | A | A | A | A | A | A
 |  |  |  |  |  |  | [NAME] | A | A | A | A
 |  |  |  |  |  |  | Sara | A | A | A |  |  | A | A | A | A | A | P | P | P | P | P
 |  |  |  |  |  |  | Toni | A | A | A | P | P |  | A | A | A | A
 |  |  |  |  |  |  | [NAME] | A | A | A | A | A | P | P | P | P | P
 |  |  |  |  |  |  | Rachel | A | A | A | A | P | A | A | A | A | A | A | A | A | A | P
 |  |  |  |  |  |  | Dima | A | A | A | A | A | P | A | A | A | A | P | A | A | A | A
 |  |  |  |  |  |  | each date has five hours for five subject along the year
 |  |  |  |  |  |  | I need formula to search for the name that has at least one letter A as ( Absent ) and get the five letter (A and P)  according the date I entered below
 |  |  |  |  |  |  | and ignore the name that has letter P as (Present) in the five hours in that date
 |  |  |  |  |  |  | Example
 |  |  |  |  |  |  | Date | 2022-10-15 00:00:00
 |  |  |  |  |  |  |  | Math | Science | Geo | History | English
 |  |  |  |  | 1
Spreadsheet: kate_symes__18504__New Notification Report 0101
Sheet: Feb 01 Changes

ALL PROPOSED CHANGES SINCE: |  | 2001-01-24 00:00:00
Old Record Information |  |  | New Record Information
Change Type | Old Name | CP ID | New Name
Spreadsheet: 799660d1665183660-if-function-to-find-out-original-order-and-than-number-the-duplicates-per-repeat-sample
Sheet: Sheet1

Case | Name | Last Name | Received Date | Closed date | Output
224186782 | PAUL | PAUL | 2022-05-03 13:01:52 | 2022-05-06 12:57:28 | Unique | Oldest order
224186858 | PAUL | PAUL | 2022-05-03 13:02:25 | 2022-05-06 13:12:22 | Duplicate 1 | Second Oldest
224186978 | PAUL | PAUL | 2022-05-03 13:03:10 | 2022-05-17 17:20:27 | Duplicate 2 | Newest
224429548 | LEAH | LEAH | 2022-05-05 17:17:08 | 2022-05-12 16:20:38 | Unique | Oldest order
226153916 | LEAH | LEAH | 2022-05-26 08:51:10 | 2022-06-16 07:20:50 | Duplicate 1 | Second Oldest
226161644 | LEAH | LEAH | 2022-05-26 10:19:53 | 2022-06-13 17:20:31 | Duplicate 2 | Newest
Spreadsheet: 850853d1701182150-shading-weekend-cloumns-meeting-rooms
Sheet: June 2024

 | 2024-06-01 00:00:00 | 2024-06-02 00:00:00 | 2024-06-03 00:00:00 | 2024-06-04 00:00:00 | 2024-06-05 00:00:00 | 2024-06-06 00:00:00 | 2024-06-07 00:00:00 | 2024-06-08 00:00:00 | 2024-06-09 00:00:00 | 2024-06-10 00:00:00 | 2024-06-11 00:00:00 | 2024-06-12 00:00:00 | 2024-06-13 00:00:00 | 2024-06-14 00:00:00 | 2024-06-15 00:00:00 | 2024-06-16 00:00:00 | 2024-06-17 00:00:00 | 2024-06-18 00:00:00 | 2024-06-19 00:00:00 | 2024-06-20 00:00:00 | 2024-06-21 00:00:00 | 2024-06-22 00:00:00 | 2024-06-23 00:00:00 | 2024-06-24 00:00:00 | 2024-06-25 00:00:00 | 2024-06-26 00:00:00 | 2024-06-27 00:00:00 | 2024-06-28 00:00:00 | 2024-06-29 00:00:00 | 2024-06-30 00:00:00
 | 2024-06-01 00:00:00 | 2024-06-02 00:00:00 | 2024-06-03 00:00:00 | 2024-06-04 00:00:00 | 2024-06-05 00:00:00 | 2024-06-06 00:00:00 | 2024-06-07 00:00:00 | 2024-06-08 00:00:00 | 2024-06-09 00:00:00 | 2024-06-10 00:00:00 | 2024-06-11 00:00:00 | 2024-06-12 00:00:00 | 2024-06-13 00:00:00 | 2024-06-14 00:00:00 | 2024-06-15 00:00:00 | 2024-06-16 00:00:00 | 2024-06-17 00:00:00 | 2024-06-18 00:00:00 | 2024-06-19 00:00:00 | 2024-06-20 00:00:00 | 2024-06-21 00:00:00 | 2024-06-22 00:00:00 | 2024-06-23 00:00:00 | 2024-06-24 00:00:00 | 2024-06-25 00:00:00 | 2024-06-26 00:00:00 | 2024-06-27 00:00:00 | 2024-06-28 00:00:00 | 2024-06-29 00:00:00 | 2024-06-30 00:00:00
BIG BOARDROOM: 0800-0900
BIG BOARDROOM: 0900-1000
BIG BOARDROOM: 1000-1100
BIG BOARDROOM: 1100-1200
BIG BOARDROOM: 1200-1300
BIG BOARDROOM: 1300-1400
BIG BOARDROOM: 1400-1500
BIG BOARDROOM: 1500-1600
BIG BOARDROOM: 1600-1700
SMALL BOARDROOM: 0800-0900
SMALL BOARDROOM: 0900-1000
SMALL BOARDROOM: 1000-1100
SMALL BOARDROOM: 1100-1200
SMALL BOARDROOM: 1200-1300
SMALL BOARDROOM: 1300-1400
SMALL BOARDROOM: 1400-1500
SMALL BOARDROOM: 1500-1600
SMALL BOARDROOM: 1600-1700
Spreadsheet: 782785d1654268994-goal-seek-conditional-sum-product-is-this-possible-sump_mod4
Sheet: OP_file

 |  |  | Target | Achieved | round
 |  |  | 140
 |  | Fixed ratio | Can be integer only
 | 4 | 0.032 | 1
 | 8 | 0.064 | 2
 | 12 | 0.096 | 1
 | 24 | 0.096 | 1 |  |  |  | Your last upload file. Not possible to meet demand 140 unless value 108 is not included.
 | 36 | 0 | 1
 | 48 | 0.288 | 1 |  |  |  | [NAME] will not work as setup is not deemed linear
 | 108 | 0.432 | 0
 |  |  |  |  |  |  | GRG Nonlinear says no solution found
 |  |  |  |  |  |  | But Evolutionary engine finds a solution by excluding value 108
Spreadsheet: 470066d1468327973-need-formula-for-calculating-expiry-date-of-items-stores-expiry-register
Sheet: Price List

S.No. | Name of Item | Purchase Date/ Mfg Date | Best Before | [NAME]
1 | ABC | 2016-07-12 00:00:00 | 2016-09-15 00:00:00
2 | BCD | 2016-07-12 00:00:00 | 6 Months
3 | EFG | 2016-07-12 00:00:00 | 1.5 Years
4
5
6
7
8
9
Spreadsheet: 124949d1318763618-extract-data-to-tab-based-on-value-advanced-filter-example
Sheet: Countsheet

Name | Size | Type | Supplier | Cases |  | Name | Size | Type | Supplier | Cases | << [NAME]
Boylan Root Beer | 355ml | [NAME] | American Soda Company | 1 |  |  |  |  | American Soda Company
Boylan Creme | 355ml | [NAME] | JMJ | 2
Boylan Orange Creme | 355ml | [NAME] | Fucor | 12 |  | Name | Size | Type | Supplier | Cases | <<Result
[NAME] | 355ml | [NAME] | AJMD | 3 |  | Boylan Root Beer | 355ml | [NAME] | American Soda Company | 1
Boylan Cane Cola | 355ml | [NAME] | AJMD | 4 |  | Boylan Grape | 355ml | [NAME] | American Soda Company | 5
Boylan Grape | 355ml | [NAME] | American Soda Company | 5 |  | Tizer | 330ml | Can | American Soda Company | 5
Boylan Ginger Ale | 355ml | [NAME] | Fucor | 4 |  | Fresh-up Crisp Apple | 355ml | Can | American Soda Company | 1
Boylan Black Cherry | 355ml | [NAME] | JMJ | 5 |  | L&P | 1.5L | Bottle | American Soda Company | 15
Boylan Diet Creme | 355ml | [NAME] | AJMD | 6 |  | Hanks Vanilla Cream | 355ml | Bottle | American Soda Company | 11.6
Boylan Diet Cane Cola | 355ml | [NAME] | JMJ | 7 |  | Cafe Earth Blood Orange | 330ml | Bottle | American Soda Company | 21
[NAME] | 330ml | Can | Fucor | 8 |  | Appletiser | 750ml | Bottle | American Soda Company | 3.4
Orangina | 330ml | Can | Fucor | 3
Tizer | 330ml | Can | American Soda Company | 5
Fresh-up Apple Mango | 355ml | Can | AJMD | 43
Fresh-up Apple Orange | 355ml | Can | JMJ | 5
Fresh-up Original Apple | 355ml | Can | JMJ | 54
Fresh-up Crisp Apple | 355ml | Can | American Soda Company | 1
Fresh-up [NAME] | 355ml | Can | Fucor | 12
L&P | 1.5L | Bottle | American Soda Company | 15
Hanks Root Beer | 355ml | Bottle | JMJ | 32
Hanks Diet Root Beer | 355ml | Bottle | AJMD | 21
Hanks Orange Cream | 355ml | Bottle | Fucor | 32
Hanks Vanilla Cream | 355ml | Bottle | American Soda Company | 11.6
Hanks Birch Beer | 355ml | Bottle | JMJ | 3.4
Hanks [NAME] Cherry | 355ml | Bottle | JMJ | 2
Cafe Earth Pink Grapefruit | 330ml | Bottle | JMJ | 1
Cafe Earth Cranberry | 330ml | Bottle | Fucor | 2.4
Cafe Earth Natural Mineral Water | 330ml | Bottle | Fucor | 4.5
Cafe Earth Blood Orange | 330ml | Bottle | American Soda Company | 21
Cafe Earth Jamaican Lime | 330ml | Bottle | JMJ | 32
Cafe Earth Wild Lemon | 330ml | Bottle | Fucor | 11.6
Appletiser | 750ml | Bottle | American Soda Company | 3.4
Grapetiser | 750ml | Bottle | Fucor | 2
White Grapetiser | 750ml | Bottle | AJMD | 1
[NAME] | 330ml | [NAME] | Fucor | 2.4
[NAME] | 330ml | [NAME] | AJMD | 4.5
Spreadsheet: 768376d1644939938-vacation-calendar-salary-vacation-example
Sheet: Calendar

Name | Employee 10 |  |  |  | Payroll ID No. |  |  |  | Earned Hours |  |  | Total Used |  |  |  |  | Total Available
January |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  | March |  |  |  |  |  |  |  | April
Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat
 |  |  |  |  |  | 2022-01-01 00:00:00 |  |  |  | 2022-02-01 00:00:00 |  |  |  |  |  |  |  | 2022-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2022-04-01 00:00:00
May |  |  |  |  |  |  |  | June |  |  |  |  |  |  |  | July |  |  |  |  |  |  |  | August
Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat
2022-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2022-06-01 00:00:00 |  |  |  |  |  |  |  |  |  | 2022-07-01 00:00:00 |  |  |  | 2022-08-01 00:00:00
September |  |  |  |  |  |  |  | October |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  | December
Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat
 |  |  |  | 2022-09-01 00:00:00 |  |  |  |  |  |  |  |  |  | 2022-10-01 00:00:00 |  |  |  | 2022-11-01 00:00:00 |  |  |  |  |  |  |  |  |  | 2022-12-01 00:00:00
Spreadsheet: 77412d1277899050-count-and-sum-calculations-excel-query1
Sheet: Sheet1

 | Raw Data
 | Name | Rupees
 | Amit | 1000
 | Raju | 1000
 | [NAME] | 1000
 | Amit | 1000
 | Raju | 1000
 | [NAME] | 1000
 | Kapil | 1000
 | Amit | 1000
 | Amit | 1000
 | Amit | 1000
 | Amit | 1000
 | Total | 11000
 | Result of Count |  |  | Result of Sum
Done Manually | Amit Count | 6 |  | Amit Sum | 6000
 | [NAME] | 2 |  | [NAME] | 2000
 | Kapil | 1 |  | [NAME] | 1000
 | Raju | 2 |  | Raju Sum | 2000
 | Total | 12 |  | Total | 11000
 |  | Data
 | Name | Count of Rupees | Sum of Rupees2
 | Amit | 6 | 6000
 | Kapil | 1 | 1000
 | [NAME] | 2 | 2000
 | Raju | 2 | 2000
 | Total | 1 | 11000
 | Grand Total | 12 | 22000
Spreadsheet: 09091a80-57d6-48b0-be6a-2b5a4645c645
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Central | IBC | NEPA | Highmark | Totals
 | ADAMS | 67 |  |  |  | 67
 | ALLEGHENY |  |  |  | 4465 | 4465
 | ARMSTRONG |  |  |  | 417 | 417
 | BEAVER |  |  |  | 778 | 778
 | BEDFORD |  |  |  | 291 | 291
 | BERKS | 481 |  |  |  | 481
 | BLAIR |  |  |  | 604 | 604
 | BRADFORD |  |  | 135 |  | 135
 | BUCKS |  | 1308 |  |  | 1308
 | BUTLER |  |  |  | 734 | 734
 | CAMBRIA |  |  |  | 1151 | 1151
 | CAMERON |  |  |  | 36 | 36
 | CARBON |  |  | 201 |  | 201
 | CENTRE | 166 |  |  | 121 | 287
 | CHESTER |  | 647 |  |  | 647
 | CLARION |  |  |  | 198 | 198
 | CLEARFIELD |  |  |  | 722 | 722
 | CLINTON |  |  | 117 |  | 117
 | COLUMBIA | 106 |  |  |  | 106
 | CRAWFORD |  |  |  | 479 | 479
 | CUMBERLAND | 188 |  |  |  | 188
 | DAUPHIN | 268 |  |  |  | 268
 | DELAWARE |  | 1488 |  |  | 1488
 | ELK |  |  |  | 281 | 281
 | ERIE |  |  |  | 1901 | 1901
 | FAYETTE |  |  |  | 878 | 878
 | FOREST |  |  |  | 19 | 19
 | FRANKLIN | 121 |  |  |  | 121
 | FULTON | 16 |  |  |  | 16
 | GREENE |  |  |  | 268 | 268
 | HUNTINGDON |  |  |  | 233 | 233
 | INDIANA |  |  |  | 510 | 510
 | JEFFERSON |  |  |  | 292 | 292
 | JUNIATA | 44 |  |  |  | 44
 | [NAME] |  |  | 488 |  | 488
 | LANCASTER | 307 |  |  |  | 307
 | [NAME] |  |  |  | 504 | 504
 | LEBANON | 99 |  |  |  | 99
 | LEHIGH | 309 |  |  |  | 309
 | LUZERNE |  |  | 781 |  | 781
 | LYCOMING |  |  | 172 |  | 172
 | MCKEAN |  |  |  | 205 | 205
 | MERCER |  |  |  | 551 | 551
 | MIFFLIN | 119 |  |  |  | 119
 | MONROE |  |  | 354 |  | 354
 | MONTGOMERY |  | 1593 |  |  | 1593
 | MONTOUR | 8 |  |  |  | 8
 | NORTHAMPTON | 223 |  |  |  | 223
 | NORTHUMBERLAND | 110 |  |  |  | 110
 | PERRY | 56 |  |  |  | 56
 | PHILADELPHIA |  | 6726 |  |  | 6726
 | PIKE |  |  | 121 |  | 121
 | POTTER |  |  |  | 149 | 149
 | SCHUYLKILL | 154 |  |  |  | 154
 | SNYDER | 36 |  |  |  | 36
 | [NAME] |  |  |  | 586 | 586
 | SULLIVAN |  |  | 19 |  | 19
 | SUSQUEHANNA |  |  | 160 |  | 160
 | TIOGA |  |  | 123 |  | 123
 | UNION | 28 |  |  |  | 28
 | VENANGO |  |  |  | 312 | 312
 | WARREN |  |  |  | 225 | 225
 | WASHINGTON |  |  |  | 913 | 913
 | WAYNE |  |  | 116 |  | 116
 | WESTMORELAND |  |  |  | 1973 | 1973
 | WYOMING |  |  | 79 |  | 79
 | YORK | 301 |  |  |  | 301
 | Totals | 3207 | 11762 | 2866 | 19796 | 37631
Spreadsheet: phillip_allen__28916__version 3_05
Sheet: Proforma

 | Internet | 0
 | Two Bedroom Rate | 575
 | Three Bedroom Rate
 | Garage Rate | 75
 | CATEGORIES |  |  |  |  | PLAN 1016 |  |  |  |  | PLAN 1213 |  |  |  |  | PROJECT TOTAL |  |  |  |  | PROJECT TOTAL
 |  |  |  |  | Annual | Monthly | Per Unit | Per SF |  | Annual | Monthly | Per Unit | Per SF |  | Annual | Monthly | [NAME] | [NAME] | % Dist |  | TOTAL | PER UNIT | % INCOME
 |  |  |  |  | Total | Total | Per Month | Per Month |  | Total | Total | Per Month | Per Month |  | Total | Total
 | [NAME]. Ft
 | Stories/Garages |  |  |  |  |  | 2 / 0 |  |  |  |  | 2 / 1.5
 | Unit [NAME] |  |  |  |  | 15.83 | LF |  |  |  | 26 | LF
 | Mix - Units
 | Mix - %
 |  |  |  |  |  |  | Including Manager's Unit
 | INCOME:
 | Rental Income
 | Vacancy Allowance-5% | 0.05
 | Security Deposit Forfeit
 | Misc. Income:  Vending Machines | 300
 | TOTAL INCOME:
 | EXPENSES:
 | Management Fee - 5% Total Income | 0.05
 | Unit Maintenance | 250/YR/Unit
 | Grounds Maintenance
 | Cable TV & T-1 | CATV $13+$10 T-1
 | Utilities
 | Advertising/Promotion | 300/YR
 | Property Taxes
 | Property Insurance
 | Liability Insurance
 | Legal
 | Rental Commissions
 | TOTAL OPERATING EXPENSES:
 | MONTHLY NOI:
 | Replacement Reserve $350/u/y | Term | 360
 | Mortgage: 30Y, 7.5%, 80% Value | MortRate
 | MONTHLY NET CASH INCOME:
 | COVERAGE RATIO: NOI/MORTGAGE
 | VALUE @ 10% CAP RATE | 0.1
 | MORTGAGE LOAN @ 80%LTV | LTV | 0.8
 | VALUE @ 9.5% CAP RATE
 | MAI Appraisal- 134 Units
 | VALUE @ 10.5% CAP RATE
 | Cash Flow Analysis
 | Total Cost in Loan Pkg
 | [NAME] 80% LTC
 | Min. Loan 75% LTC
 | Equity
 | Total at 80% LTC
 | Less EST Const Profit Allowance 10% Cost
 | Net Cash Equity
 | Less Land
 | Net Additional Cash
 | True Cost
 | less Cash equity
 | Cash over Cost in Base Loan
 | Total at 75% LTC
 | Less EST Const Profit Allowed
 | Net Cash Equity
 | Less Land
 | Net Additional Cash
 | Mortage
 | Less 2% Cost of Loan
 | Limit-90% LTC
 | Less Construction Loan-80% LTC
 | Net Cash at Permanent
 | Less ROE
 | [NAME] CSB |  |  |  | 1000000
 | Years to Pay Off
 | Alternate CSB
 | CMF 8%
Spreadsheet: 874016d1720589063-how-to-drag-down-the-date-in-dd-mm-yy-format-how-to-drag-the-date-down_100724
Sheet: loan 130821-1L

loan amount & date | pay date | amt to sala | amt to interest | balance | Merged | date in date format dd-mm-yyyy
100000 | 110921 | 3000 | 1000 |  | 2021-09-11 00:00:00
2021-08-13 00:00:00 | 91021 | 3000 | 970 |  | 2021-10-09 00:00:00
 | 131121 | 3000 | 940 |  | 2021-11-13 00:00:00
 | 111221 | 3000 | 910 |  | 2021-12-11 00:00:00
 | 150122 | 3000 | 880 |  | 2022-01-15 00:00:00
 | 120222 | 3000 | 850 |  | 2022-02-12 00:00:00
 | 120322 | 3000 | 820 |  | 2022-03-12 00:00:00 |  |  |  |  | fomula | result
 | 160422 | 3000 | 190 |  | 2022-04-16 00:00:00
 | 210522 | 3000 | 760 |  | 2022-05-21 00:00:00 |  |  |  |  | '=LEFT(B4,2)&"-"&RIGHT(B4,2) | 13-21
 | 130622 | 3000 | 730 |  | 2022-06-13 00:00:00
 | 160722 | 3000 | 700 |  | 2022-07-16 00:00:00 |  |  |  |  | =LEFT(B4,2)&"-"&RIGHT(B4,2)&"-"
 | 200822 | 3000 | 670 |  | 2022-08-20 00:00:00
 | 170922 | 3000 | 640 |  | 2022-09-17 00:00:00 |  |  |  |  | '=[NAME])
 | 221022 | 3000 | 610 |  | 2022-10-22 00:00:00
 | 191122 | 3000 | 580 |  | 2022-11-19 00:00:00
 | 171222 | 3000 | 550 |  | 2022-12-17 00:00:00 |  |  |  |  |  | if I drag down
 | 210123 | 3000 | 520 |  | 2023-01-21 00:00:00 |  |  |  |  |  | if I drag down
 | 180223 | 3000 | 490 |  | 2023-02-18 00:00:00 |  |  |  |  |  | if I drag down
 | 180323 | 3000 | 460 |  | 2023-03-18 00:00:00 |  |  |  |  |  | if I drag down
 | 180423 | 3000 | 430 |  | 2023-04-18 00:00:00 |  |  |  |  |  | if I drag down
 | 200523 | 3000 | 400 |  | 2023-05-20 00:00:00
 | 170623 | 3000 | 370 |  | 2023-06-17 00:00:00
 | 150723 | 3000 | 340 |  | 2023-07-15 00:00:00
 | 180823 | 3000 | 310 |  | 2023-08-18 00:00:00
 | 160923 | 3000 | 280 |  | 2023-09-16 00:00:00
 | 211023 | 3000 | 250 |  | 2023-10-21 00:00:00
 | 181123 | 3000 | 220 |  | 2023-11-18 00:00:00
 | 161223 | 3000 | 190 |  | 2023-12-16 00:00:00
 | 200124 | 3000 | 160 |  | 2024-01-20 00:00:00
 | 180224 | 3000 | 130 |  | 2024-02-18 00:00:00
 | 160324 | 3000 | 100 |  | 2024-03-16 00:00:00
 | 200424 | 3000 | 70 |  | 2024-04-20 00:00:00 |  |  |  |  |  |  |  |  | l
 | 250524 | 4000 | 40 |  | 2024-05-25 00:00:00
 | to get row 1 as freezed click on row 2 cell a2 and go to tools view freeze panes. Done.   100724
Spreadsheet: darrell_schoolcraft__7622__imball0201
Sheet: MiVida_Rich

 | Mi Vida/Richardson Gas Treating
 | POI 500607 - Delhi/No Pyote
Day | Measured | Scheduled
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
2001-12-31 00:00:00
2001-12-31 00:00:00
CBS Volume
Spreadsheet: 139025d1328039182-i-need-help-with-array-formula-sample
Sheet: Sheet1

HEIGHT | WIDTH |  |  |  |  |  | HEIGHT | WIDTH
 | 10" - 14" | 14" - 18" | 18" - 22" | 22" - 26" | 26" - 30" |  |  | 10" - 14" | 14" - 18" | 18" - 22" | 22" - 26" | 26" - 30"
20" - 36" | 130 | 160 | 200 | 240 | 280 |  | 20" - 36" | 138 | 173 | 215 | 259 | 301
36" - 42" | 140 | 180 | 220 | 265 | 310 |  | 36" - 42" | 153 | 191 | 237 | 284 | 329
42" - 48" | 160 | 195 | 240 | 290 | 335 |  | 42" - 48" | 168 | 209 | 259 | 309 | 358
48" - 54" | 170 | 215 | 260 | 310 | 360 |  | 48" - 54" | 180 | 227 | 280 | 334 | 386
54" - 60" | 180 | 230 | 280 | 335 | 385 |  | 54" - 60" | 195 | 245 | 302 | 359 | 414
60" - 66" | 195 | 245 | 300 | 360 | 415 |  | 60" - 66" | 210 | 263 | 323 | 384 | 442
66" - 72" | 210 | 260 | 320 | 380 | 440 |  | 66" - 72" | 225 | 281 | 345 | 409 | 471
72" - 78" | 225 | 280 | 340 | 405 | 465 |  | 72" - 78" | 240 | 299 | 367 | 434 | 499
78" - 84" | 240 | 295 | 360 | 430 | 490 |  | 78" - 84" | 255 | 317 | 388 | 459 | 527
84" - 90" | 245 | 315 | 380 | 450 | 520 |  | 84" - 90" | 262 | 335 | 410 | 484 | 555
90" - 96" | 265 | 330 | 400 | 475 | 545 |  | 90" - 96" | 270 | 353 | 431 | 509 | 584
96" - 102" | 280 | 345 | 420 | 495 | 570 |  | 96" - 102" | 285 | 371 | 453 | 534 | 612
HEIGHT | WIDTH |  |  |  |  |  | HEIGHT | WIDTH
 | 10" - 14" | 14" - 18" | 18" - 22" | 22" - 26" | 26" - 30" |  |  | 10" - 14" | 14" - 18" | 18" - 22" | 22" - 26" | 26" - 30"
20" - 36" | 178.69 | 224.08 | 279.93 | 336.24 | 391.2 |  | 20" - 36" | 142.952 | 179.264 | 223.944 | 268.992 | 312.96
36" - 42" | 198.48 | 247.55 | 307.97 | 368.72 | 427.87 |  | 36" - 42" | 158.784 | 198.04 | 246.376 | 294.9760000000001 | 342.296
42" - 48" | 218.27 | 271.02 | 336.01 | 401.2 | 464.53 |  | 42" - 48" | 174.616 | 216.816 | 268.808 | 320.96 | 371.624
48" - 54" | 233.86 | 294.49 | 364.05 | 433.68 | 501.19 |  | 48" - 54" | 187.088 | 235.592 | 291.24 | 346.944 | 400.952
54" - 60" | 253.3 | 317.96 | 392.09 | 466.16 | 537.86 |  | 54" - 60" | 202.64 | 254.368 | 313.672 | 372.9280000000001 | 430.288
60" - 66" | 272.74 | 341.43 | 420.13 | 498.64 | 574.52 |  | 60" - 66" | 218.192 | 273.144 | 336.104 | 398.912 | 459.616
66" - 72" | 292.19 | 364.9 | 448.17 | 531.12 | 611.19 |  | 66" - 72" | 233.752 | 291.92 | 358.5360000000001 | 424.896 | 488.9520000000001
72" - 78" | 311.63 | 388.37 | 476.21 | 563.59 | 647.85 |  | 72" - 78" | 249.304 | 310.696 | 380.968 | 450.8720000000001 | 518.28
78" - 84" | 331.07 | 411.84 | 504.25 | 596.07 | 684.52 |  | 78" - 84" | 264.856 | 329.472 | 403.4 | 476.8560000000001 | 547.616
84" - 90" | 340.14 | 435.31 | 532.29 | 628.55 | 721.18 |  | 84" - 90" | 272.112 | 348.248 | 425.832 | 502.84 | 576.944
90" - 96" | 350.59 | 458.78 | 560.34 | 661.03 | 757.84 |  | 90" - 96" | 280.472 | 367.024 | 448.272 | 528.824 | 606.272
96" - 102" | 370.03 | 482.25 | 588.38 | 693.51 | 794.51 |  | 96" - 102" | 296.024 | 385.8 | 470.704 | 554.808 | 635.6080000000001
Spreadsheet: 742863d1628083256-input-date-calculate-in-condition-format-date-josephteh
Sheet: Sheet3

Count of DATE
NAME | DATE | Total
AAA | 01/02/2021 | 1
 | 01/03/2021 | 1
 | 02/02/2021 | 1
 | 03/02/2021 | 1
 | 05/04/2021 | 1
 | 06/05/2021 | 1
 | 08/02/2021 | 1
 | 08/03/2021 | 1
 | 12/04/2021 | 1
 | 15/03/2021 | 1
 | 22/02/2021 | 1
 | 22/03/2021 | 1
 | 29/03/2021 | 1
 | 30/07/2021 | 1
BBB | 04/05/2021 | 1
 | 09/07/2021 | 1
 | 16/04/2021 | 1
CCC | 07/07/2021 | 1
DDD | 01/02/2021 | 1
Grand Total |  | 19
Spreadsheet: 10af2bae-ea77-4c43-ace1-4dc088b785ad
Sheet: River Analysis

 |  |  |  |  |  |  |  |  |  |  |  |  | Weekly Grain Barges Unloaded
 |  |  |  |  |  |  |  |  |  |  |  |  | Sum of 7 weeks ending: | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 2013-01-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Difference in barges
 |  |  |  |  |  |  |  |  |  |  |  |  | 3-year average for the 7- week period
 |  |  |  |  |  |  |  |  |  |  |  |  | Difference in barges
 |  |  |  |  |  |  |  |  |  |  |  |  | Recent Weeks:
 |  |  |  |  |  |  |  |  |  |  |  |  | Week ending 1/19/13
 |  |  |  |  |  |  |  |  |  |  |  |  | Week ending 1/12/13
 |  |  |  |  |  |  |  |  |  |  |  |  | Difference in barges
 |  |  |  |  |  |  |  |  |  |  |  |  | Source:  GIPSA, New Orleans Field Office