tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: vkaminski__40901__CASH_EPE_0400MyCopy
Sheet: Trapped

TRAPPED CASH, PARTNER LOANS, RESERVES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Offset For
Current Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "Trapped_Table"
Calendar Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals |  | 1
Months Of Operation
[NAME]
Beginning Balance |  |  |  |  | 0
Plus: Current Year Earnings
Subtotal Available For Dividends
Less: Current Year Dividends
Ending Balance
Cash (Excluding Working Capital)
Beginning Balance |  |  |  |  | 0
Plus: Prior Year Partner Loans Repayment
Plus: Current Year Cashflow
Subtotal Cashflow Available For Distribution
Less: Current Year Dividends
Less: Current Year Capital Reductions
Less: Current Year Partner Loans
Ending Balance
Beginning Trapped Cash |  |  |  |  | 0
Current Year Trapped Cash
Relief Of Prior Years Trapped Cash
Ending Trapped Cash
PARTNER LOANS
Beginning Balance |  |  |  |  | 0
Plus: Prior Year Trapped Cash
Less: Loan Repayment
Ending Balance
Interest Income - Project Company
Interest Expense - Partners
SUDAM TAX CREDIT RESERVE
Beginning Reserve Balance |  |  |  |  | 0
Plus: Current Year Sudam Credits
Less: Distribution Of Reserve (See Below)
Ending Reserve Balance
Current Year Earnings Before Sudam Credit
Cumulative Earnings Before Sudam Credit
Cumulative Sudam Credits Available
Sudam Credits Distributed
MAINTENANCE RESERVE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
Base Year For Escalation |  |  | 1997
Unescalated Maintenance Expense |  |  |  |  | 0 | 0 | 126 | 10862 | 6972 | 6784 | 869 | 6733 | 7921 | 239 | 239 | 8961 | 8773 | 239 | 239 | 14299 | 239 | 239 | 6465 | 12264 | 239 | 239
Savings Factor |  | 0
Unescalated Maintenance Expense
R$ Percentage |  |  |  |  | 0 | 0 | 0.2565 | 0.0059 | 0.0671 | 0.0584 | 0.0742 | 0.0827 | 0.0271 | 0.2697 | 0.2697 | 0.0522 | 0.0452 | 0.2697 | 0.2697 | 0.0494 | 0.2697 | 0.2697 | 0.0724 | 0.0323 | 0.2697 | 0.2697
R$ Portion (In US$)
US$ Portion
US$ Portion
Times: Inflation Factor (CPI-May)
Escalated Maintenance Expense (Before Duties)
Customs & Duties Tax
Escalated Maintenance Expense (After Duties)
Maintenance Reserve Accrual
[NAME] To Cash Adjustment
Maintenance Reserve Account (US$ Portion)
Beginning Balance |  |  |  |  | 0
Plus: Maintenance Reserve Accrual
Less: Maintenance Reserve Expense
Ending Balance
R$ Portion (In US$)
[NAME]
Times: Inflation Factor (IGP)
Escalated Maintenance Expense (R$)
Current Exchange Rate
Escalated Maintenance Expense (US$)
Maintenance Reserve Accrual
[NAME] To Cash Adjustment
Maintenance Reserve Account (R$ Portion)
Beginning Balance |  |  |  |  | 0
Plus: Maintenance Reserve Accrual
Less: Maintenance Reserve Expense
Ending Balance
Interest Income On Maintenance Reserve & WCAP
Average Annual Maintenance Reserve Balance
WCAP Balance
Total
Interest Expense On MR & WCAP
Spreadsheet: 190174d1351546096-top-3-based-on-3-categories-fruit-example
Sheet: Pivot

Count of Container | Column Labels |  |  |  |  | 1 | I want to find of the fruit, what the top three fruit are (count) | 1 | Of the top fruit, what are the top three containers
Row Labels | Apple | [NAME] | Orange | Grand Total |  |  |  | 2
Basket | 4 | 4 |  | 8 |  |  |  | 3
Bowl | 3 | 3 | 1 | 7
Cup | 3 | 3 | 2 | 8
Tub |  | 2 |  | 2 |  | 2
Grand Total | 10 | 12 | 3 | 25 |  | 3
Spreadsheet: 688154d1595592623-how-to-compare-two-columns-data-sample
Sheet: Sheet1

1 | 1
01A | 01A
02A | 02A
391 | 391
03A | 03A
53D | 53D
D77 | D77
D78 | D78
A01
A02
Spreadsheet: 198748d1354887419-match-and-vlookup-matchlookup-problem
Sheet: t_Personnel_data

employee_id | badge | first_name | middle_name | last_name | paylink | ni_code | [NAME] | badge_expiry | Sex | passport_number | visa_number | known_as | union_name | union_details | union_number | address | postcode | home_tel | mobile_tel | pager_number | e_mail | nok_name | nok_tel | bank_name | bank_address | bank_tel | account_name | account_number | account_sort_code | pension_name | pension_number | pension_details | pension_date_of_entry | pension_voluntary_contribution | vehicle_registration_number | vehicle_make_and_model | driving_licence_number | driving_endorsements_last_checked | driving_endorsements_review | driving_endorsements_review_rfa | date_started_with_company | appraisal_next | appraisal_next_rfa | doctor_name | doctor_address | doctor_tel | blood_group | disability_rating | vts_user_name | [NAME] | vts_administrator | wti_status | wti_opted_out_date | wti_opted_out_review_date | wti_opted_out_review_date_rfa | wti_night_shift_worker | employee_grouping_id | employee_status | employee_title | employee_religion | employee_nationality | employee_ethnic_origin | employee_marital_status | employee_vehicle_ownership | Department | Sub Dept | Location | Catagory | Grouping 05 | Grouping 06 | Grouping 07 | Grouping 08 | Grouping 09 | Grouping 10 | period_schedule_allocation_week | absence_entitlement | period_schedule | selected | secondary_employment | secondary_employment_identifier | flexitime_balance_date | flexitime_balance | personal_information_portal | enrolment_state | retirement_age_rfa | years_service_rfa | email_policy | terminal_policy | badge_activation | remuneration
8 |  | Loraine | [NAME] | LEUTY |  |  |  |  |  |  |  | LEUTY, Loraine |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee
Spreadsheet: 88954d1288758334-payment-calculator-example
Sheet: Sheet1

Car Loan Payment Calculator
Car Type: Honda Civic
Price | 6000 |  | Interest Rate | 0.075 | Annual Rate
Down Payment % | 0.3 |  | Monthly Interest |  | per month
Down Payment |  |  | Loan Period | 5 | years
Loan Amount |  |  | Loan Period |  | months
 |  |  | Payment |  | Monthly
Payment Period | Principal | Interest | Add'l Principal | Balance
1
Spreadsheet: 55427d1255541765-triple-vlookup-select-from-menu
Sheet: Sheet1

Color | Year | Type | January | February | March | Apr | May
Red | 2006 | KG | 5 | 6 | 6 | 6 | 6
Red | 2006 | Value | 5 | 6 | 6 | 6 | 7
Red | 2007 | KG | 5 | 6 | 7 | 9 | 9
Red | 2007 | Value | 5 | 4 | 8 | 9 | 9
Blue | 2006 | KG | 4 | 4 | 4 | 4 | 5
Blue | 2006 | Value | 4 | 3 | 2 | 3 | 4
Blue | 2007 | KG | 5 | 1 | 1 | 51 | 5
Blue | 2007 | Value | 5 | 5 | 5 | 4 | 4
Red | 2007 | Value | 5 | 4 | 8 | 9 | 9
Spreadsheet: 92745d1292307101-iteration-continuously-increases-after
Sheet: Week5

Week | Day | Date | Winner/tie | PtsW |  | [NAME]/tie | PtsL
5 | Sun | 2010-10-10 00:00:00 | Tennessee Titans | 34 | @ | Dallas Cowboys | 27
5 | Sun | 2010-10-10 00:00:00 | Detroit Lions | 44 |  | St. Louis Rams | 6
5 | Sun | 2010-10-10 00:00:00 | Washington Redskins | 16 |  | Green Bay Packers | 13
5 | Sun | 2010-10-10 00:00:00 | Baltimore Ravens | 31 |  | Denver Broncos | 17
5 | Sun | 2010-10-10 00:00:00 | [NAME] | 36 | @ | Buffalo Bills | 26
5 | Sun | 2010-10-10 00:00:00 | Atlanta Falcons | 20 | @ | [NAME] | 10
5 | Sun | 2010-10-10 00:00:00 | New York Giants | 34 | @ | Houston Texans | 10
5 | Sun | 2010-10-10 00:00:00 | Oakland Raiders | 35 |  | San Diego Chargers | 27
5 | Sun | 2010-10-10 00:00:00 | Indianapolis Colts | 19 |  | Kansas City Chiefs | 9
5 | Sun | 2010-10-10 00:00:00 | Tampa Bay Buccaneers | 24 | @ | Cincinnati Bengals | 21
5 | Sun | 2010-10-10 00:00:00 | Arizona Cardinals | 30 |  | New Orleans Saints | 20
5 | Sun | 2010-10-10 00:00:00 | Chicago Bears | 23 | @ | Carolina Panthers | 6
5 | Sun | 2010-10-10 00:00:00 | Philadelphia Eagles | 27 | @ | San Francisco 49ers | 24
5 | Mon | 2010-10-11 00:00:00 | New York Jets | 29 |  | Minnesota Vikings | 20
Spreadsheet: 467838d1466978003-sum-up-length-if-id-is-the-same-test
Sheet: Sheet1

HoleID | Length | Angle | Total Length
2868 | 1.8774 | 171 | 1.8774
2869 | 1.4893 | 172 | 1.4893
2870 | 1.4276 | 169 | 1.4276
2870 | 1.9894 | 171
2870 | 2.0111 | 171
2870 | 2.0308 | 169
2874 | 0.8121 | 168
2874 | 1.8874 | 169
2874 | 1.9679 | 172
2874 | 2.0767 | 169
2878 | 1.7669 | 179 | and so on…
2878 | 2.0241 | 179
2880 | 1.8632 | 180
2880 | 1.9919 | 179
2880 | 1.4318 | 177
2880 | 1.9596 | 180
2880 | 2.0318 | 180
2880 | 1.9602 | 181
2886 | 1.7669 | 179
2886 | 1.9114 | 180
2888 | 1.7186 | 180
2888 | 1.9918 | 180
2888 | 2.1844 | 180
2888 | 1.9668 | 180
2888 | 2.0399 | 180
2888 | 1.9653 | 180
2894 | 2.0083 | 179
2894 | 1.4617 | 181
2894 | 2.0323 | 180
2894 | 1.9762 | 179
2894 | 1.8953 | 180
2894 | 2.065 | 180
2894 | 2.0248 | 182
2901 | 2.0478 | 180
2901 | 1.5099 | 179
2901 | 1.9114 | 180
2901 | 1.9596 | 180
2901 | 1.9918 | 180
2901 | 2.0341 | 180
2901 | 2.0238 | 180
2901 | 1.9919 | 181
2909 | 2.056 | 180
2909 | 2.0399 | 180
2909 | 1.9438 | 179
2909 | 1.9683 | 180
2909 | 1.8472 | 180
2909 | 2.0299 | 180
2909 | 1.6063 | 181
2909 | 1.9836 | 181
2917 | 1.9756 | 180
2917 | 1.9435 | 180
2917 | 1.8964 | 182
2920 | 1.5901 | 180
Spreadsheet: michelle_lokay__26569__imbalsumm0012
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -47774 | -77022
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -1900764 | -1967904
58710 | -258435 | -128302
60921 | -491935 | -480892
78026 | 42844
500084 | -41233 | -57000
500085 | -136148 | -94069
500097 | -12277
INDEX
2000-11-30 00:00:00 |  |  | 370218.8
2000-12-19 00:00:00
 |  | 300 | 7.75
 |  | 300 | 6.375
 |  | 400 | 5
 |  | 1000
Spreadsheet: 739134d1625549545-if-function-stacked-up-to-be-simplified-if-function-stacked-up-to-be-simplified
Sheet: Sheet1

Date | Reading | Usage | Days
2020-01-19 00:00:00 | 27611
2020-01-20 00:00:00 | 27907
2020-01-21 00:00:00 | 28203
2020-01-22 00:00:00
2020-01-23 00:00:00 | 28800
2020-01-24 00:00:00
2020-01-25 00:00:00
2020-01-26 00:00:00 | 29693
2020-01-27 00:00:00
2020-01-28 00:00:00 | 30268
2020-01-29 00:00:00
2020-01-30 00:00:00
2020-01-31 00:00:00
2020-02-01 00:00:00
2020-02-02 00:00:00
2020-02-03 00:00:00 | 32104
2020-02-04 00:00:00
2020-02-05 00:00:00
2020-02-06 00:00:00
Spreadsheet: 47183d1246084392-bar-charts-689366_topazo
Sheet: Sheet3

 | A | B | C | D
1 | 5 | 7 | 6 | 11
2 | 5 | 7 | 5 | 8
3 | 5.4 | 9 | 6.1 | 7.5
AVERAGE | 5.13 | 7.67 | 5.7 | 8.83
STDEV | 0.23 | 1.15 | 0.61 | 1.89
Spreadsheet: 803871d1667756396-how-to-determine-intervals-when-values-are-below-a-threshold-example-interval-cal
Sheet: Sheet1

Hour | Value
01:00:00 | 1 |  | 'identify all intervals where consecutive values fall below 5 for at least 4 hours
02:00:00 | 3
03:00:00 | 1
04:00:00 | 2
05:00:00 | 3
06:00:00 | 5
07:00:00 | 7
08:00:00 | 4
09:00:00 | 3
10:00:00 | 9
11:00:00 | 7
12:00:00 | 4
13:00:00 | 3
14:00:00 | 2
15:00:00 | 4
16:00:00 | 6
17:00:00 | 8
18:00:00 | 10
19:00:00 | 7
20:00:00 | 2
21:00:00 | 3
22:00:00 | 6
Spreadsheet: 101612d1299699699-can-you-sort-a-pivot-field-two-ways-xlforumtest
Sheet: Sheet1

Count of AHT +/- | Date
Member | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | Grand Total
Zaza, test | 1 | 1 | 2
Aloha, Tuyu | 1 | 1 | 2
World, Itsagreat | 1 | 1 | 2
War, TooMany | 1 | 1 | 2
Angola, Whereis | 1 | 1 | 2
Africa, Thatis | 1 |  | 1
Australia, Ilove | 1 |  | 1
Williamsburg, Va | 1 |  | 1
Andorra, IsFar |  | 1 | 1
Arrivals, AndDept |  | 1 | 1
Spreadsheet: 846215d1697491154-convert-formula-to-power-query-example
Sheet: Table1

XX DI | Type | [NAME]
104716 | 00014857 | No
104716 | 00016502 | No
104716 | 00011880 | No
104723 |  | Yes
104723 | 00011905 | Yes
104729 | 00004088 | No
104745 | 00011889 | No
104802 | 00015879 | No
104804 | 00011909 | No
104804 | 00008210 | No
105370 | 00013536 | Yes
105370 |  | Yes
106534 | 00012356 | Yes
106534 |  | Yes
111338 | 00015861 | Yes
111338 |  | Yes
137132 |  | No
Spreadsheet: 234808d1368194189-using-a-drop-down-to-pull-data-from-another-sheet-283-drop-down-for-sheet-name-v2
Sheet: Summary

[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hawthorn
 | Month | RepairCenterRollUpName | Cookies sent to store | Cookies not sold | percent of cookies not sold
 | Month 1
 | Month 2
 | Month 3
 | Month 4
 | Month 5
 | Month 6
Spreadsheet: kimberly_watson__20555__imbalsumm0108
Sheet: Conoco

 | Maljamar |  | Zia |  |  |  |  |  |  |  |  | Avg
Day | Measured | Scheduled | Measured | Scheduled |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
1 | 36395 | 35310 | 30665 | 30355
2 | 36109 | 35970 | 30760 | 30926 |  |  | 2001-03-01 00:00:00 |  |  |  | 4.98
3 | 34935 | 35968 | 31613 | 30922 |  |  | 2001-04-01 00:00:00 |  |  |  | 4.87
4 | 35129 | 38500 | 32705 | 33450 |  |  | 2001-05-01 00:00:00 |  |  |  | 3.82
5 | 36992 | 38491 | 29785 | 33441 |  |  | 2001-06-01 00:00:00 |  |  |  | 3.2
6 | 37536 | 31999 | 30106 | 29000 |  |  | 2001-07-01 00:00:00 |  |  |  | 2.77
7 | 30804 | 36000 | 34261 | 30950
8 | 28957 | 36000 | 32502 | 30950
9 | 33886 | 35956 | 29962 | 30912
10 | 33528 | 32935 | 31738 | 33878
11 | 33647 | 35767 | 29418 | 30749
12 | 33412 | 30764 | 30321 | 30269
13 | 33711 | 30302 | 29868 | 30731
14 | 34265 | 30374 | 30207 | 30804
15 | 34973 | 30417 | 27096 | 30847
16 | 33442 | 30517 | 31103 | 30950
17 | 33295 | 30517 | 28744 | 30950
18 | 37922 | 30402 | 29031 | 30834
19 | 37429 | 30402 | 29422 | 30834
20 | 35688 | 30402 | 28474 | 30834
21 | 36035 | 30517 | 27197 | 30950
22 | 35506 | 30517 | 28224 | 30949
23 | 36635 | 30517 | 27453 | 30950
24 | 36673 | 30517 | 30643 | 30950
25 | 33829 | 30517 | 27379 | 30950
26 | 35973 | 30517 | 29256 | 30950
27 | 30842 | 27017 | 31434 | 34450
28
29
30
31
2001-07-31 00:00:00 |  | 612678.27 |  | 0
2001-08-27 00:00:00
CBS Volume
 |  |  | 95131
Spreadsheet: 160365d1339067114-excel-2007-text-boxes-and-pictures-will-not-print-tried-lots-of-things-to-no-avail-copy-of-recipe-sheet-v5
Sheet: Agg QA

 | A G G R E G A T E    Q U A N T I T Y    Q A
 | Job No |  |  |  |  |  |  | Customer
 | Area |  |  |  |  |  |  | Site Details
 | Coverage/m²
 | Depth
 | Mix Code
 | AGGREGATE PER BATCH
 | Size | Type |  | Supplier | Kg in mix | [NAME] | No of Bags per mix | Total Tonnage | Total No. of [NAME] | [NAME] (Please tick) | No of Bags Counted | Signed
 | ANY OTHER COMMENTS
 | Completed by |  |  |  |  |  | Signed |  |  |  | Date
Spreadsheet: 878620d1725793150-help-to-make-inventory-list-it_electronics2000-inventory-sample-2016-aligw
Sheet: Master Inventory

Date |  | Inventory List
2024-08-01 00:00:00
 |  |  | Shop |  |  |  |  |  | Warehouse |  |  |  |  |  | TOTAL
Category | Barcode | Item Name | SH Opening Stock | SH Stock In | SH Stock Out | SH Transfer In | SH Transfer Out | SH Closing Stock | WH Opening Stock | WH Stock In | WH Stock Out | [NAME] In | [NAME] | WH Closing Stock | Opening Stock | Stock In | Stock Out | Transfer In | Transfer Out | Closing Stock | Re-Order | Cost | R% | [NAME] | R Sell | DH Sell | Closed Item | Notes
Hotelware | 1000 | Bamboo Fruit Plate 4 step |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Hotelware | 1001 | Bamboo Tray 14" |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Hotelware | 1002 | Bamboo Tray 16" |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Hotelware | 1003 | Basket Fancy Design 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Hotelware | 1004 | Basket Fancy Design 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Hotelware | 1005 | Basket Fancy Design 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Spreadsheet: louise_kitchen__22861__Wes
Sheet: Accounting

Accounting
Hernandez, Anamaria | Analyst
Schultz, Amanda | Analyst
Ellis, [NAME] | [NAME]
[NAME], [NAME] | Director
Shepperd, [NAME] | Director
Vargas, [NAME] (Hope) | Director
Whiting, Gregory | Director
Tijerina, [NAME] | Executive Secretary
[NAME], [NAME] | Manager
[NAME], [NAME] | Manager
Harris, Kimberly | Manager
[NAME], [NAME] | Manager
[NAME], [NAME] | Manager
Leschber, [NAME] | Manager
Warwick, Todd | Manager
[NAME], Angeles | Manager
Greusen, [NAME] | Manager
Colwell, [NAME] | Managing Director
Day, Misti | Spec.
Guerra, Ricardo | Spec.
Guilliams, [NAME] | Spec.
Kacal, [NAME] | Spec.
[NAME], [NAME] | Spec.
Mayeux, [NAME] | Spec.
Moore, [NAME] | Spec.
Ingram, [NAME] | Sr. [NAME].
[NAME], [NAME] | Sr. [NAME]
[NAME], [NAME] | Sr. Director
Hardy, Stacy | Sr. Spec.
[NAME], [NAME] | Sr. Spec.
Eastwood, Anne | Sr. Spec.
Fellers, [NAME] | Sr. Spec.
Green, [NAME] | Sr. Spec.
Hardy, [NAME] | Sr. Spec.
[NAME], Shannon | Sr. Spec.
Simper, [NAME] | Sr. Spec.
Smith, [NAME] | Sr. Spec.
[NAME], [NAME] | Sr. Spec.
Wolfe, Stephen | Sr. Spec.
[NAME], [NAME] | Staff
Price, [NAME] ([NAME]) | Staff
Hodges, [NAME] | VP
[NAME], [NAME] | VP
[NAME], [NAME] | VP
Total | 44
Spreadsheet: rick_buy__32955__Raptor 3b
Sheet: 50 NR

Note Receivable |  |  |  | Today |  |  |  |  | Principle
Face | 50000000 |  |  | Last Pymt Date |  |  |  |  | Accrued Interest
Interest |  |  |  | Interest Days
Tenor |  |  |  | Next Interest |  |  |  |  | Cum. Interest Inc.
Payment
Date | Beg. Bal | Payment | Interest | Principle | End Bal |  | Cum Payments | Cum Int Inc
2000-09-22 00:00:00 |  |  |  |  |  | 60
2001-03-22 00:00:00 |  |  |  |  |  | 59
2001-09-22 00:00:00 |  |  |  |  |  | 58
2002-03-22 00:00:00 |  |  |  |  |  | 57
2002-09-22 00:00:00 |  |  |  |  |  | 56
2003-03-22 00:00:00 |  |  |  |  |  | 55
2003-09-22 00:00:00 |  |  |  |  |  | 54
2004-03-22 00:00:00 |  |  |  |  |  | 53
2004-09-22 00:00:00 |  |  |  |  |  | 52
2005-03-22 00:00:00 |  |  |  |  |  | 51
2005-09-22 00:00:00 |  |  |  |  |  | 50
Spreadsheet: 06fc3873-0d52-407b-8252-09dd4e52d683
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
 | 5609.0 Housing Finance, Australia
 | TABLE 9a. HOUSING FINANCE COMMITMENTS (Owner Occupation), By Type of Buyer and Loan: Australia, Original
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
First home buyers - Dwellings financed (no.) ; |  |  | Original | A2412824W | 1975-10-01 00:00:00 | 2010-05-01 00:00:00 | 416 | Number | FLOW | Month | 1
First home buyers - % of all dwellings financed ; |  |  | Original | A2412836F | 1975-10-01 00:00:00 | 2010-05-01 00:00:00 | 416 | Percent | DERIVED | Month | 1
First home buyers - Average loan size ($000) ; |  |  | Original | A2412825X | 1975-10-01 00:00:00 | 2010-05-01 00:00:00 | 416 | $'000 | DERIVED | Month | 1
Non-first home buyers - Dwellings financed (no.) ; |  |  | Original | A2412827C | 1975-10-01 00:00:00 | 2010-05-01 00:00:00 | 416 | Number | FLOW | Month | 1
Non-first home buyers - % of all dwellings financed ; |  |  | Original | A2416246C | 1975-10-01 00:00:00 | 2010-05-01 00:00:00 | 416 | Percent | DERIVED | Month | 1
Non-first home buyers - Average loan size ($000) ; |  |  | Original | A2412826A | 1975-10-01 00:00:00 | 2010-05-01 00:00:00 | 416 | $'000 | DERIVED | Month | 1
Fixed rate - Dwellings financed (no.) ; |  |  | Original | A2412828F | 1975-10-01 00:00:00 | 2010-05-01 00:00:00 | 416 | Number | FLOW | Month | 1
Fixed loans - % of all dwellings financed ; |  |  | Original | A2412837J | 1975-10-01 00:00:00 | 2010-05-01 00:00:00 | 416 | Percent | DERIVED | Month | 1
Fixed rate - Average loan size ($000) ; |  |  | Original | A2412829J | 1975-10-01 00:00:00 | 2010-05-01 00:00:00 | 416 | $'000 | DERIVED | Month | 1
Secured revolving loans - Dwellings financed (no.) ; |  |  | Original | A2412830T | 1975-10-01 00:00:00 | 2010-05-01 00:00:00 | 416 | Number | FLOW | Month | 1
Secured revolving loans - % of all dwellings financed ; |  |  | Original | A2412838K | 1975-10-01 00:00:00 | 2010-05-01 00:00:00 | 416 | Percent | DERIVED | Month | 1
Secured revolving loans - Average loan size ($000) ; |  |  | Original | A2412831V | 1975-10-01 00:00:00 | 2010-05-01 00:00:00 | 416 | $'000 | DERIVED | Month | 1
Other loans -  Dwellings financed (no.) ; |  |  | Original | A2412832W | 1975-10-01 00:00:00 | 2010-05-01 00:00:00 | 416 | Number | FLOW | Month | 1
Other loans - % of all dwellings financed ; |  |  | Original | A2412839L | 1975-10-01 00:00:00 | 2010-05-01 00:00:00 | 416 | Percent | DERIVED | Month | 1
Other loans - Average loan size ($000) ; |  |  | Original | A2412833X | 1975-10-01 00:00:00 | 2010-05-01 00:00:00 | 416 | $'000 | DERIVED | Month | 1
ALL FINANCE - Average loan size ($000) ; |  |  | Original | A2412834A | 1975-10-01 00:00:00 | 2010-05-01 00:00:00 | 416 | $'000 | DERIVED | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 772588d1647377579-assign-points-in-a-calendar-2022-hourly-calendars-test
Sheet: Data

Employee Name | FILE# | Occur Date | Occur Type | Abr | Points | CODE | Adj Points | Adj Date | Comments
Employee 1 | 2423 | 2021-12-14 00:00:00 | Absent |  | 1
Employee 1 | 2423 | 2021-12-31 00:00:00 | Absent |  | 1
Employee 1 | 2423 | 2022-01-01 00:00:00 | Insuff Notice (PT)
Employee 1 | 2423 | 2022-01-02 00:00:00 | Insuff Notice (PT)
Employee 1 | 2423 | 2022-01-15 00:00:00 | Absent
Employee 2 | 2787 | 2022-01-29 00:00:00 | Absent
Employee 2 | 2787 | 2022-01-30 00:00:00 | Absent
Employee 2 | 2787 | 2022-01-31 00:00:00 | Absent
Spreadsheet: 803702d1667627148-formula-help-for-countif-for-data-on-paricular-date-excel-doubt
Sheet: Sheet1

 | Inputs |  |  | Required Result using [NAME]
 | INVOICE DATE | STATUS |  | STATUS : NO. OF INVOICES | ON 03-Nov-22
 | 2022-11-01 00:00:00 | On Time Completed |  | On Time Completed | 1
 | 2022-11-02 00:00:00 | Delay more than one day |  | Delay more than one day | 1
 | 2022-11-03 00:00:00 | Not Outward |  | Not Outward | 1
 | 2022-11-01 00:00:00 | On Time Completed |  | Grand Total
 | 2022-11-02 00:00:00 | Delay more than one day
 | 2022-11-03 00:00:00 | Not Outward
 | 2022-11-01 00:00:00 | On Time Completed
 | 2022-11-02 00:00:00 | Delay more than one day
 | 2022-11-03 00:00:00 | Not Outward
Spreadsheet: 706060d1606439834-powerquery-data-extraction-from-website-question-finvizpquery-problema2
Sheet: Sheet1

Path |  |  | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12
sim |  |  | Index | - | P/E | - | EPS (ttm) | -0.27 | Insider Own | 0.841 | Shs Outstand | 165.90M | Perf Week | 3.67%
 |  |  | Market [NAME] | 1.55B | Forward P/E | - | EPS next Y | - | Insider Trans | 0 | [NAME] | 165.90M | Perf Month | 12.82%
 |  |  | Income | 11.60M | PEG | - | EPS next Q | - | Inst Own | 0.002 | Short Float | 0.00% | Perf Quarter | 46.54%
 |  |  | Sales | 1.64B | P/S | 0.94 | EPS this Y | -147.10% | Inst Trans | 0.003 | Short Ratio | 0.58 | Perf Half Y | 31.45%
 |  |  | Book/sh | 10.33 | P/B | 0.90 | EPS next Y | - | ROA | 0.005 | Target Price | - | Perf Year | -4.21%
 |  |  | Cash/sh | - | P/C | - | EPS next 5Y | - | ROE | 0.007 | 52W Range | 5.20 - 11.14 | Perf YTD | -8.27%
 |  |  | Dividend | 0.59 | P/FCF | - | EPS past 5Y | -28.00% | ROI | -0.029 | 52W High | -16.34% | Beta | 0.41
 |  |  | Dividend % | 6.33% | [NAME] | 2.00 | Sales past 5Y | 5.00% | Gross Margin | 0.162 | 52W Low | 79.23% | ATR | 0.60
 |  |  | Employees | 4244 | Current Ratio | 3.10 | Sales Q/Q | 15.80% | Oper. Margin | 0.104 | RSI (14) | 56.95 | Volatility | 4.72% 6.40%
 |  |  | Optionable | No | Debt/Eq | 0.00 | EPS Q/Q | 22.70% | Profit Margin | 0.007 | Rel Volume | 0.04 | Prev Close | 9.36
 |  |  | Shortable | Yes | LT Debt/Eq | 0.00 | Earnings | - | Payout |  | [NAME] | 1.83K | Price | 9.32
 |  |  | Recom | - | SMA20 | 3.31% | SMA50 | 19.74% | SMA200 | 0.1765 | Volume | 69 | Change | -0.45%
Spreadsheet: 557122d1516442331-how-to-move-data-in-columns-below-another-set-of-columns-book1-5-
Sheet: Correct answer

Col 1 | Col 2 | Col 3 | Col 4 | Col 5 | Col 6 | Col 7 | Col 8 | Col 9 |  |  |  |  | Col 1 | Col 2 | Col 3
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9