tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 679429d1590414947-substraction-based-on-multiple-conditions-hourly-time-cards
Sheet: Date

Profile date | Employee number | Name | Activites | Start time | End time | Hrs
2020-04-27 00:00:00 | 1702 | Sample | Clock-in | 06:34:44 | 06:34:44 | {SUMIFS({Table1[Start time]-Table1[End time]*24},Table1[Name],B3,Table1[Activites],"Clock-in",Table1[Activites],"Clock-out")}
2020-04-27 00:00:00 | 1702 | Sample | Indirect activity | 06:34:44 | 08:15:52
2020-04-27 00:00:00 | 1702 | Sample | Process | 08:15:52 | 10:45:48
2020-04-27 00:00:00 | 1702 | Sample | Indirect activity | 10:45:48 | 10:45:54
2020-04-27 00:00:00 | 1702 | Sample | Process | 10:45:54 | 14:22:48
2020-04-27 00:00:00 | 1702 | Sample | Indirect activity | 14:22:48 | 15:00:14
2020-04-27 00:00:00 | 1702 | Sample | Clock-out | 15:00:14 | 15:00:14
2020-04-27 00:00:00 | 1635 | Sample1 | Clock-in | 06:34:33 | 06:34:33
2020-04-27 00:00:00 | 1635 | Sample1 | Indirect activity | 06:34:33 | 07:34:05
2020-04-27 00:00:00 | 1635 | Sample1 | Process | 07:34:05 | 08:17:58
2020-04-27 00:00:00 | 1635 | Sample1 | Indirect activity | 08:17:58 | 08:29:38
2020-04-27 00:00:00 | 1635 | Sample1 | Process | 08:29:38 | 08:45:50
2020-04-27 00:00:00 | 1635 | Sample1 | Indirect activity | 08:45:50 | 09:21:56
2020-04-27 00:00:00 | 1635 | Sample1 | Process | 09:21:56 | 10:09:51
2020-04-27 00:00:00 | 1635 | Sample1 | Indirect activity | 10:09:51 | 10:10:11
2020-04-27 00:00:00 | 1635 | Sample1 | Indirect activity | 10:10:11 | 12:08:46
2020-04-27 00:00:00 | 1635 | Sample1 | Process | 12:08:46 | 14:44:44
2020-04-27 00:00:00 | 1635 | Sample1 | Indirect activity | 14:44:44 | 15:03:45
2020-04-27 00:00:00 | 1635 | Sample1 | Clock-out | 15:03:45 | 15:03:45
2020-04-27 00:00:00 | 1796 | Sample2 | Clock-in | 06:51:48 | 06:51:48
2020-04-27 00:00:00 | 1796 | Sample2 | Indirect activity | 06:51:48 | 15:03:08
2020-04-27 00:00:00 | 1796 | Sample2 | Clock-out | 15:03:08 | 15:03:08
2020-04-27 00:00:00 | 1686 | Sample3 | Clock-in | 06:58:34 | 06:58:34
2020-04-27 00:00:00 | 1686 | Sample3 | Indirect activity | 06:58:34 | 15:00:36
2020-04-27 00:00:00 | 1686 | Sample3 | Clock-out | 15:00:36 | 15:00:36
2020-04-27 00:00:00 | 1691 | Sample4 | Clock-in | 06:34:37 | 06:34:37
2020-04-27 00:00:00 | 1691 | Sample4 | Indirect activity | 06:34:37 | 07:23:39
2020-04-27 00:00:00 | 1691 | Sample4 | Process | 07:23:39 | 12:43:06
2020-04-27 00:00:00 | 1691 | Sample4 | Process | 12:43:06 | 14:58:17
2020-04-27 00:00:00 | 1691 | Sample4 | Indirect activity | 14:58:17 | 15:03:59
2020-04-27 00:00:00 | 1691 | Sample4 | Clock-out | 15:03:59 | 15:03:59
Spreadsheet: 854873d1704629967-creating-a-3rd-sheet-with-allowed-ids-and-associated-information-from-a-pivot-table-beispiel
Sheet: Final

Debitor | Buchungsdatum | Belegart | Belegnummer | Belegdatum | Fälligkeitsdatum | Beschreibung | Betrag
200001 | 2023-12-05 00:00:00 | Rechnung | 666666 | 2023-12-10 00:00:00 | 2024-01-09 00:00:00 | Rechnung | 253.53
200003 | 2023-03-31 00:00:00 | Rechnung | 123123 | 2023-12-06 00:00:00 | 2024-02-06 00:00:00 | Rechnung | 5000
200003 | 2022-08-12 00:00:00 | Rechnung | 421565 | 2023-08-12 00:00:00 | 2022-10-26 00:00:00 | Rechnung | -213
Spreadsheet: 854412d1704297080-checking-each-field-taking-data-from-latest-field-and-adding-to-one-specific-cell-dummy
Sheet: W8

IDs (Week 8 data (Week 13 since letter)) |  |  |  |  |  |  |  |  | IDs (Week 6 data (Week 15 since letter)) |  |  |  |  |  |  |  |  |  | IDs (Week 4 data (Week 17 since letter)) |  |  |  |  |  |  |  |  |  | IDs (Week 2 data (Week 19 since letter))
Group 1 | Group 2 |  |  |  | Group 3 |  |  |  | Group 1 | Group 2 |  |  |  | Group 3 |  |  |  |  | Group 1 | Group 2 |  |  |  | Group 3 |  |  |  |  | Group 1 | Group 2 |  |  |  | Group 3
No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date SMS Scheduled | SMS Status | Opted out? | No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date call made | Was Call Successful? | Was call rescheduled? | Opted out of receiving calls? | No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date call made | Was Call Successful? | Was call rescheduled? | Opted out of receiving calls? | No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date call made | Was Call Successful? | Was call rescheduled? | Opted out of receiving calls? | Total Scheduled | Total Delivered | TotaloOpted out | Total Clicks | Total calls made | Total Successful | Total Rescheduled | Total Opt out of calls
 |  |  |  |  | 5526540562 | 2024-09-13 00:00:00 |  |  |  |  |  |  |  | 9096115010 | 2024-09-15 00:00:00 |  |  |  |  |  |  |  |  | 1357548478 | 2024-09-17 00:00:00 |  |  |  |  |  |  |  |  | 5297206741 | 2024-09-19 00:00:00
Spreadsheet: 162784d1340060664-copy-of-managers-clients-info-from-master-list-database-example
Sheet: CM #

CAT | 1 | 2 | 3 | Total
Total
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 80

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
W80 | 2018-05-30 00:00:00 | 8.16 | 0.837 | 4.35 | 1.88 | 3.52 |  | 5.063544081208537 | 0 | 0.832 | 2.538 | 535 |  |  | 0.049 | 7.963 | 0 | 0 | 0 | 0
Spreadsheet: 38881d1237048022-update-an-excel-from-all-other-excel-files-job-tickets_2
Sheet: Sheet1

 |  | KAMAL CHEM
JOB CARD NO | 10 | DATE | 26/03/2009
CUSTOMER | home | Qty | 1
CODE NO | 312481K
[NAME] | lmnopq
BATCH NO | 2009-03-010 | LAST BATCH NO: | 2008-01-024
RELEASE | 1 big | SUBSTRATE | zzz
FORMULA
Sr.No | Code No. |  | Qty.
1 | 817315M |  | 0.1
2 | 897228 E |  | 0.1
3 | 847556 |  | 0.1
4 | 180455 |  | 0.1
5 | 321475 |  | 0.1
6 | 134875 |  | 0.1
7 | 247561 |  | 0.1
8 | 214893 |  | 0.1
9 | 126489 |  | 0.1
10 | 246216 |  | 0.1
 | TOTAL |  | 1
Spreadsheet: 869220d1715851204-find-value-from-table-using-iferror-aggregate-function-or-using-any-other-function-pressure-loss-table
Sheet: Sheet4

 |  |  |  |  |  |  |  |  |  |  | Looking for pressure loss value in cell N9 from pressure loss table
 | Pressure loss Table
 |  |  |  |  |  |  |  |  |  |  | my Input value  - pipe diameter in cell M9 and Flow M3/hr in cell M10
 | Flow m3/hr. | pipe diameter
 |  | 8 | 10 | 12 | 15 | 22 | 28 | 35
 | 0.26 | 0.2675 | 0.071 | 0.0255 | 0.0077 | 0.0014 | 0.0004 | 0.0001 |  |  | Scenario-1
 | 0.375 | 0.6 | 0.15 | 0.05 | 0.015 | 0.003 | 0.0008 | 0.0003 |  |  |  |  | Pressure loss
 | 0.52 | 0.8348 | 0.2188 | 0.0777 | 0.0231 | 0.004 | 0.0011 | 0.0004 |  |  | pipe diameter | 15 | 0.0337 | Output
 | 0.625 | 1.11845 | 0.31629375 | 0.114620644421875 | 0.033683586734375 | 0.005188681687499999 | 0.001475524484375 | 0.000470343125 |  |  | Flow m3/hr | 0.63
 | 0.75 |  | 0.4285 | 0.1514 | 0.0447 | 0.0077 | 0.0022 | 0.0007
 | 0.875 |  | 0.55358875 | 0.197727159546875 | 0.059816384609375 | 0.0100577491875 | 0.002830056859375 | 0.0009026186250000001
 | 1.02 |  | 0.694 | 0.2444 | 0.0719 | 0.0123 | 0.0035 | 0.0011
 | 1.125 |  | 0.84973375 | 0.298207917046875 | 0.090248034359375 | 0.0155660381875 | 0.004357525109375 | 0.001388157125 |  |  |  |  |  |  | Scenario-2                        Also I am looking for if input value M10 doesn’t match with column value in table cell B then it move to next higher value from cell B and  match value from  C7:I23.
 | 1.27 |  |  | 0.3553 | 0.1042 | 0.0178 | 0.005 | 0.0016 |  |  | Scenario-2
 | 1.375 |  |  | 0.416062916921875 | 0.124978535984375 | 0.0217135486875 | 0.006057929234375 | 0.001926958625 |  |  |  |  | Pressure loss
 | 1.5 |  |  | 0.4833 | 0.1414 | 0.024 | 0.0067 | 0.0021 |  |  | pipe diameter | 22 | 0.0123 | Output
 | 1.65 |  |  | 0.551292159171875 | 0.164007889484375 | 0.0285002806875 | 0.007931269234375 | 0.002519023125 |  |  | Flow m3/hr | 0.92
 | 1.75 |  |  | 0.6276 | 0.1832 | 0.0311 | 0.0086 | 0.0027
 | 1.87 |  |  | 0.7038956437968751 | 0.207336094859375 | 0.0359262341875 | 0.009977545109375001 | 0.003164350625
 | 2 |  |  | 0.7877 | 0.2296 | 0.0388 | 0.0108 | 0.0034
 | 1.14 |  |  | 0.873873370796875 | 0.254963152109375 | 0.0439914091875 | 0.012196756859375 | 0.003862941125
 | 2.26 |  |  | 0.963 | 0.2804 | 0.0473 | 0.0131 | 0.0042
 |  | Pressure loss
Spreadsheet: 857601d1706575342-display-icon-if-date-entered-and-a-different-icon-if-no-date-test-sheet_mrbean
Sheet: Sheet1

Completed | Date Created | Report Type | Issue raised | Location | Corrective Action | Person Responsible | Target Date | Completion Date
 | 2024-02-29 00:00:00 | Unsafe Act |  | Assemby | Order new screens. Speck to operator (complete) | [NAME] | 2024-03-29 00:00:00 | 2024-02-29 00:00:00
 | 2024-02-29 00:00:00 | Unsafe Condittion |  | Burn Shop |  | [NAME] | 2024-03-30 00:00:00
 | 2024-02-29 00:00:00 | Unsafe Act |  | Cyl. Assy |  | [NAME] | 2024-03-31 00:00:00 | 2024-02-29 00:00:00
 | 2024-02-29 00:00:00 | Unsafe Condittion |  | Locker room |  | [NAME] | 2024-03-04 00:00:00 | 2024-02-29 00:00:00
 | 2024-03-01 00:00:00 | Unsafe Condittion |  | Lunchroom |  | [NAME] | 2024-03-05 00:00:00
 | 2024-03-02 00:00:00 | Injury |  | Machining |  | [NAME] | 2024-03-06 00:00:00
 | 2024-03-03 00:00:00 | Damage |  | Maintenace |  | [NAME] | 2024-03-07 00:00:00
 | 2024-03-04 00:00:00 | Damage |  | Office |  | [NAME] | 2024-03-08 00:00:00
 | 2024-03-05 00:00:00 | Injury |  | Paint |  | [NAME] | 2024-03-09 00:00:00
 | 2024-03-06 00:00:00 | Unsafe Condittion |  | Saw Bay |  | [NAME] | 2024-03-10 00:00:00 | 2024-02-29 00:00:00
 | 2024-03-07 00:00:00 | Unsafe Act |  | Ship/Receive |  | [NAME] | 2024-03-11 00:00:00
 | 2024-03-08 00:00:00 | Minor Near Miss |  | Shop 2 Weld/Fab |  | [NAME] | 2024-03-12 00:00:00
Spreadsheet: 78946d1279207918-calculating-man-hours-and-days-worked-over-multiple-sheets-employee-hrs-response
Sheet: Employee Hours

 | Sun | Mon | Tue | Wed | Thu | Fri | Sat
Name | 2010-07-01 00:00:00 | 2010-07-02 00:00:00 | 2010-07-03 00:00:00 | 2010-07-04 00:00:00 | 2010-07-05 00:00:00 | 2010-07-06 00:00:00 | 2010-07-07 00:00:00 | Total Hours Worked | Total Days Worked
[NAME] | 0 | 9.5 | 0 | 0 | 0 | 0 | 0 | 9.5 | 1
[NAME] | 0 | 8 | 0 | 8 | 0 | 0 | 0 | 16 | 2
[NAME] | 10.5 | 0 | 8 | 8 | 8 | 8 | 8 | 50.5 | 6
[NAME] | 10.5 | 7 | 10.5 | 0 | 10.5 | 10.5 | 0 | 49 | 5
[NAME] | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 1
[NAME] | 0 | 10.5 | 10.5 | 10.5 | 10.5 | 0 | 10.5 | 52.5 | 5
Sherlock [NAME] | 0 | 0 | 0 | 0 | 9.5 | 9.5 | 9.5 | 28.5 | 3
[NAME] | 0 | 0 | 0 | 0 | 0 | 12 | 0 | 12 | 1
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
TOTAL |  |  |  |  |  |  |  | 226 | 24
This sheet needs to find the guys name and enter in their name, and hours. If possible also sort it by name.
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Natural Gas Admin

 | Natural Gas Admins
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense |  |  |  |  |  | 26409.6
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 16506 | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense |  |  |  |  |  | 22008
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  | 0 | [NAME] | 48400
ENARENT | Rent |  |  |  |  |  | 0 | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  | 11004 | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  | 0 | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | 5502 | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 0
 |  |  |  |  |  |  |  | Director | 143000 | 0
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 0
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 3151fac3-ad4c-4a16-9ed2-018f3245a8e7
Sheet: Sheet1

Start Date | End Date | Meeting Name | HQ Hotel | Venues | Attendees
2014-11-22 00:00:00 | 2014-11-22 00:00:00 | Milan Institute Graduation Ceremony | Cashman Center | Cashman Center | 1500
2014-12-13 00:00:00 | 2014-12-14 00:00:00 | CardAgain Magic: The Gathering Tournament | Downtown Grand Las Vegas | Cashman Center | 6000
2015-06-08 00:00:00 | 2015-06-08 00:00:00 | Clark County School District Veterans Tribute CTA Graduation | Cashman Center | Cashman Center | 2000
Spreadsheet: 127666d1320446430-please-help-need-sample-spreadsheets-cash-flow-model-rev01-01-07-1a
Sheet: Instructions

1 | This spreadsheet assumes a married couple.
2 | If you are not married, put age of spouse at zero
3 | Pension amount are company paid pensions.
4 | IRA amounts are current value
5 | SSN amounts are based upon recent notice you received from [NAME]
6 | Non-IRA investments are the amount you have invested outside an IRA
7 | Check box if you will take SSN benefits at age 62
8 | Model assumes you will not take any IRA/401k/403b payments before age 70.5
9 | Model assumes Non-IRA investment account is joint
10 | Tax rates, growth, and withdrawals should be entered as a decimal, ie 4% = .04
11 | Click on the Button Below to enter all data
Spreadsheet: 64106d1264976274-sorting-alphabetic-list-3-
Sheet: Data

List |  |  | sort this list |  | to get this
Adam | YES | [NAME] | <<<<<< |  | vvvvvv
Adam | YES | YES2 | Table |  |  |  |  | Table
[NAME] | NO | NO1 | Yes |  | <> | No |  | Yes |  | <> | No
[NAME] | YES | YES3 | YES | Adam |  | NO | [NAME] | YES | Adam |  | NO | [NAME]
Barack | YES | YES4 | YES | Adam |  | NO | Barack | YES | Adam |  | NO | Barack
Barack | NO | NO2 | YES | [NAME] |  | NO | Barack | YES | [NAME] |  | NO | Barack
Barack | NO | NO3 | YES | Barack |  | NO | [NAME] | YES | Barack |  | NO | [NAME]
[NAME] | YES | YES5 | YES | [NAME] |  | NO | [NAME] | YES | [NAME] |  | NO | [NAME]
[NAME] | YES | YES6 | YES | [NAME] |  | NO | [NAME] | YES | [NAME]
[NAME] | NO | NO4 | YES | [NAME]
[NAME] | NO | NO5
[NAME] | YES | YES7
[NAME] | NO | NO6
 |  |  |  |  |  |  |  |  | Sorting |  |  | Sorting
Spreadsheet: 1294e58b-6406-4317-94c4-66f50ca2b807
Sheet: Sheet1

Table 2--Feed and residual use of wheat and coarse grains, 9/14/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Market year and quarter 1/ |  | Corn  (million metric tons) | Sorghum  (million metric tons) | Barley  (million metric tons) | Oats  (million metric tons) | Feed grains  (million metric tons) | Wheat  (million metric tons) | Energy feeds  (million metric tons) | Grain consuming animal units  (millions) | Energy feeds per grain consuming animal unit  (tons)
2010/11 | Q1 Sep-Nov | 52.56517625243693 | 2.278308027407873 | 0.03339892280853589 | 0.3692424370254856 | 55.24612563967882 | -1.710578956392525 | 53.5355466832863
 | [NAME] | 39.62807592412668 | 0.4116515212131603 | 0.1556294004142207 | 0.2911846112394775 | 40.48654145699354 | -0.07359084686626552 | 40.41295061012727
 | [NAME] | 18.12008407790542 | 0.3276752205139929 | 0.1724812688977974 | 0.262850502262973 | 18.88309106958019 | -1.653072499503316 | 17.23001857007687
 | [NAME] | 11.43286785671194 | 0.1009442888622177 | 0.5687614475406668 | 0.6743722960217218 | 12.77694588913655 | 5.569308480093186 | 18.34625436922973
 | MY Sep-Aug | 121.746204111181 | 3.118579057997244 | 0.9302710396612208 | 1.597649846549658 | 127.3927040553891 | 2.13206617733108 | 129.5247702327202 | 92.94302041484113 | 1.393593296781193
2011/12 | Q1 Sep-Nov | 46.30731617483632 | 1.125526280695738 | -0.04624466235028046 | 0.33730317487533 | 47.72390096805711 | -0.4613035704079884 | 47.26259739764912
 | [NAME] | 39.22582283947089 | 0.144685120623853 | 0.2708709248116004 | 0.2283448137594565 | 39.86972369866581 | 1.196694943622988 | 41.0664186422888
 | [NAME] | 21.853143078496 | 0.3902383265702692 | 0.0227957445766213 | 0.2050882192049248 | 22.47126536884782 | -1.861870198156419 | 20.6093951706914
 | MY Sep-Aug | 111.7651914931449 | 1.651076692512367 | 1.862937047711581 | 1.429080359354121 | 116.7082855927229 | 7.231008308907377 | 123.9392939016303 | 93.42843945822707 | 1.326569239733957
2012/13 | MY Sep-Aug | 105.4148965219435 | 1.778082591936395 | 1.01669891709327 | 1.655258684036251 | 109.8649367150094 | 4.433821308142621 | 114.298758023152 | 91.9448943670058 | 1.243122402935381
1/ Corn and sorghum, September 1-August 31 marketing year; Barley and oats, June 1-May 31 marketing year. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Data run: 9/13/2012
Spreadsheet: 863773d1711150229-retun-a-value-based-on-the-values-dates-in-other-cells-if-values-test-01
Sheet: Sheet1

PATRON | # | SINCE | ACTIVE | LINE | STATUS | LAST APP | LAST RAT | X | X2 | X3 | REQUIRE 1 | REQUIRE 2 | REQUIRE 3
 |  | 2019-08-02 00:00:00 | 2020-01-04 00:00:00 |  | SUSP | 2019-07-29 00:00:00 | 2023-03-22 00:00:00 |  |  |  | NO | YES | YES |  | Expected results
 |  | 2021-03-23 00:00:00 | 2021-04-22 00:00:00 |  | SUSP | 2024-02-01 00:00:00 | 2021-03-17 00:00:00 |  |  |  | YES | NO | NO
 |  | 2021-05-15 00:00:00 | 2024-03-01 00:00:00 |  | CRDSUSP | 2021-05-15 00:00:00 | 2021-05-15 00:00:00 |  |  |  | SEE NOTES | SEE NOTES | SEE NOTES
 |  | 2023-03-18 00:00:00 | 2024-01-31 00:00:00 |  | APPROVED | 2023-05-18 00:00:00 | 2023-01-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  | REQUIRE 1 | REQUIRE 2 | REQUIRE 3
 |  |  |  |  |  |  |  |  |  |  | IF STATUS(F) = APPROVED, RETURN BLANK | IF STATUS(F) = APPROVED, RETURN BLANK | IF STATUS(F) = APPROVED, RETURN BLANK
 |  |  |  |  |  |  |  |  |  |  | IF STATUS(F) = ANYTHING OTHER THAN SUSP, RETURN "SEE NOTES" | IF STATUS(F) = ANYTHING OTHER THAN SUSP, SHOW "SEE NOTES" | IF STATUS(F) = ANYTHING OTHER THAN SUSP, SHOW "SEE NOTES"
 |  |  |  |  |  |  |  |  |  |  | IF STATUS(F) = SUSP, AND LAST RAT(H) IS OLDER THAN 18 MONTHS SHOW "YES", OTHERWISE SHOW "NO" | IF STATUS(F) = SUSP AND LAST APP(G) IS OLDER THAN 36 MONTHS SHOW "YES", OTHERWISE SHOW NO | IF STATUS(F) = SUSP AND ACTIVE(D) IS OLDER THAN 6 MONTHS SHOW "YES", OTHERWISE SHOW NO
Spreadsheet: 865237d1712297009-trying-to-tell-excell-to-do-one-thing-if-the-tick-box-is-ticked-and-another-if-the-tick-investment-property-spreadsheet-copy
Sheet: Proposed Analysis

POTENIAL PROPERTY ANALYSIS
 | MINIMUM INPUTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VIC
 |  | Proposed Property Address: |  |  |  |  |  | Enter the address |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QLD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NSW
 |  | Proposed Purchase Price: |  |  |  |  |  | 600000 |  |  |  |  |  | State: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WA
 |  | Proposed Loan Amount: |  |  |  |  |  | 540000 |  |  |  |  |  | Proposed LVR: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NT
 |  | Proposed Rental Amount: |  |  |  |  |  | 550 |  | Per Week
 | OPTIONIAL INPUTS
 |  | Capital Growth Rate: |  |  |  |  |  | 0.06 |  |  |  | Consumer Price Index: |  |  |  |  |  | 0.03
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Want interest only ticked to the following | Want PI repayments ticked the following
 |  |  |  | Property Expenses: |  |  |  |  |  |  |  |  |  | Loan Interest Rate: |  |  |  | 0.065
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Don't change the loan amount each year | Change loan amount and grab the corresponding loan balance after that year from Sheet 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Also just want interest payments to appear starting in cell E64 | Want interest in Cell E64 and principle amounts in cell E66
 | STATISTICS
 |  | Today |  | Year 1 |  | Year 2 |  | Year 3 |  | Year 4 |  | Year 5 |  | Year 6 |  | Year 7 |  | Year 8 |  | Year 9 |  | Year 10
 | Property Value:
 | Equity In Property:
 | Property Growth %: | 0
 | LVR:
 | Loan Balance:
 | Surplus to reinvest:
 | Purchase Power: | 0
 | Rental Income:
 | [NAME] Yield:
 | Net Rental Yield:
 | DEDUCTIONS
 | Property Expenses:
 | Loan Interest Payments:
 | Loan P & I Payments:
 | Pre-Tax Cashflow p/a:
 | Pre-Tax cashflow p/w:
 | NON - CASH DEDUCTIONS
 | Depreciation:
 | FINAL ANALYSIS
 | Total Deductions:
 | Net Profit or Loss:
 | Tax Refund:
 | Land Tax:
 | After-Tax Cashflow p/a:
 | After-Tax cashflow p/w:
Spreadsheet: 0338ba76-fb08-447f-af02-6f85e6fd3c50
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
 | 8731.0 Building Approvals, Australia
 | TABLE 82. Value of Building Approved, Chain Volume Measures, Original - Australian Capital Territory
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
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total houses ;  New ; |  |  | Original | A590547W | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total other residential building ;  New ; |  |  | Original | A590548X | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  New ; |  |  | Original | A590549A | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590550K | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590551L | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590552R | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590553T | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: 101935d1300000944-converting-two-columns-of-info-into-a-table-book2
Sheet: Sheet2

Game Week | Under 2.5 | Over2.5 | Under 2.5 | Over2.5 | Under 2.5 | Over 2.5 | Under 2.5 | Over2.5 | 1 | 2 | 3 | 4 | 5 | 6 | 7
Accrington
Aldershot
Arsenal
[NAME]
Barnet
Barnsley
Birmingham
[NAME]
Blackpool
[NAME]