tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 758345d1638828578-formula-to-add-closed-when-all-actions-are-competed-audit-tracker-2021
Sheet: Sheet1

Audit | Audit Number | Lead Auditor | Due | Auditee | Date Completed | NCR's raised | Department | Closed |  |  | Audit Number | NCR Ref | Action Owner | Department | Action target Date | Completed | Repeat NCR | Closed | On time
HR | SHA-MEG-1234 | [NAME] | 2022-01-01 00:00:00 | [NAME] |  |  |  |  |  |  | SHA-MEG-1237 | NCR-1 | [NAME] | Mod 1 | 2021-04-01 00:00:00 | 2021-04-01 00:00:00 | Yes
QUALITY | SHA-MEG-1235 | [NAME] | 2021-12-01 00:00:00 | [NAME] |  |  |  |  |  |  | SHA-MEG-1237 | NCR-2 | [NAME] | Mod 1 | 2021-04-01 00:00:00 | 2021-06-01 00:00:00 | No
ENGINEERING | SHA-MEG-1236 | [NAME] | 2021-12-01 00:00:00 | [NAME] |  |  |  |  |  |  | SHA-MEG-1237 | NCR-3 | [NAME] | [NAME] | 2021-04-01 00:00:00 | 2021-04-01 00:00:00 | Yes
MANUFACTURING | SHA-MEG-1237 | shrek | 2021-03-01 00:00:00 | [NAME] | 2021-03-01 00:00:00 | 3 | MANU |  |  |  | SHA-MEG-1239 | NCR-4 | [NAME] | [NAME] | 2021-09-01 00:00:00 | 2021-09-02 00:00:00 | No
MANAGEMENT | SHA-MEG-1238 | [NAME] | 2021-04-01 00:00:00 | [NAME] | 2021-05-01 00:00:00 | 0 | SLC |  |  |  | SHA-MEG-1239 | NCR-5 | [NAME] | Mod 1 | 2021-09-01 00:00:00 | 2021-09-01 00:00:00 | Yes
BUSSINESS REVIEW | SHA-MEG-1239 | [NAME] | 2021-08-01 00:00:00 | [NAME] | 2021-08-01 00:00:00 | 2 | SLC |  |  |  | SHA-MEG-1240 | NCR-6 | [NAME] | Mod 1 | 2022-01-01 00:00:00 |  | No
HS | SHA-MEG-1240 | [NAME] | 2021-11-01 00:00:00 | Doe | 2021-12-01 00:00:00 | 1 | HSE
INSPECTION | SHA-MEG-1241 | [NAME] | 2022-03-01 00:00:00 | Will
RELEASE | SHA-MEG-1242 | [NAME] | 2022-04-02 00:00:00 | Huge
RCCA | SHA-MEG-1243 | [NAME] | 2022-05-03 00:00:00 | [NAME]
Spreadsheet: 65950d1266576356-lookup-formula-demo-v2
Sheet: Pivot Table

Area | Name | Birthday |  |  | Address | Job | Phone | Cell | Start date | Quit Date
GH | MrA | 1976 | Jan | 12 | Don't know street | Secretary | 55223273 | 905555221 | 2007-03-02 00:00:00
GH | MrB | 1978 | Mar | 23 | Have not a clue Rd | Manager | 22555 | 552222552 | 2008-04-06 00:00:00
GH | MrC | 1979 | Jan | 24 | Wouldn't know how to to get there Street | sales clerk | 905555221 | 905555221 | 2010-01-02 00:00:00
NO2 | MrE | 1975 | Feb | 13 | Don't know street | Secretary | 55223222 | 905555221 | 2007-03-02 00:00:00
NO2 | MrD | 1978 | Mar | 30 | Have not a clue Rd | Manager | 22555 | 905555221 | 2008-04-06 00:00:00
NO2 | MrS | 1979 | Apr | 31 | Wouldn't know how to to get there Street | sales clerk | 552222552 | 905555221 | 2010-01-02 00:00:00
GHNO3 | MrZ | 1976 | Jan | 12 | Don't know street | Secretary | 55223222 | 905555221 | 2007-03-02 00:00:00
GHNO3 | MrX | 1978 | Mar | 23 | Have not a clue Rd | Manager | 22555 | 905555221 | 2008-04-06 00:00:00
GHNO3 | MrT | 1979 | Apr | 24 | Wouldn't know how to to get there Street | sales clerk | 552222552 | 905555221 | 2010-01-02 00:00:00
Kai | MrV | 1976 | Jan | 12 | Don't know street | Secretary | 55223222 | 905555221 | 2007-03-02 00:00:00
Kai | MrU | 1978 | Mar | 23 | Have not a clue Rd | Manager | 22555 | 905555221 | 2008-04-06 00:00:00
Kai | MrQ | 1979 | Apr | 24 | Wouldn't know how to to get there Street | sales clerk | 552222552 | 905555221 | 2010-01-02 00:00:00
[NAME] | MrR | 1976 | Jan | 12 | Don't know street | Secretary | 55223222 | 905555221 | 2007-03-02 00:00:00
[NAME] | MrF | 1978 | Mar | 23 | Have not a clue Rd | Manager | 22555 | 905555221 | 2008-04-06 00:00:00
[NAME] | MrG | 1979 | Apr | 24 | Wouldn't know how to to get there Street | sales clerk | 552222552 | 905555221 | 2010-01-02 00:00:00
Spreadsheet: 174568d1345116335-combining-2-workbooks-workbook-2
Sheet: name 6

name 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012/13
 | MINIMUM INFORMATION THAT HAS TO BE RECORDED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ADDITIONAL INFORMATION THAT MAY BE RECORDED
 | A | Annual Leave |  |  |  |  | T | Training |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Compassionate |  |  |  |  | S1 | Sickness Paid |  |  |  |  | M1 | Maternity Leave Paid
 | B | Bank Holiday |  |  |  |  | O | Other Authorised Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | [NAME]
 | S | Sickness |  |  |  |  | U | Unauthorised Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Jury Service |  |  |  |  | S2 | Sickness Half Pay
 | M | Maternity Leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Suspension |  |  |  |  |  |  |  |  |  |  | M2 | Maternity Leave Unpaid
Contracted Hours |  |  | 37.5 | A/L | 247.5 |  | B/H | 67.5 |  | Combined |  |  | 315
 |  | 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 | S | O | U | M | T | B | A | Annual Leave Outstanding
APRIL | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 315
MAY | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 315
[NAME] | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 315
JULY | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 315
AUG | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 315
SEPT | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 315
OCT | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 315
NOV | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 315
DEC | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 315
JAN | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 315
FEB | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 315
MAR | Code
 | Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 315
ANNUAL LEAVE ENTITLEMENT |  |  |  |  |  |  | 315 |  | hrs |  |  |  |  |  | CRB checked:    12/03/09             Renewal date:  12/03/12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 356284d1415045798-move-an-entire-row-to-a-new-sheet-based-on-the-value-of-a-cell-job-requisition-workbook
Sheet: EMBASSY

Embassy Healthcare Community |  |  |  | Administrator: [NAME] DON: |  | EEO: [EMAIL] Phone: [PHONE]
Requisition # | Job Title | Department | [NAME] | Position Open | Offer Accepted | Shift | Reason for Opening | Days Open | Satus
EMBSY14002 | ADON | Nursing | 40k-55k | 2014-10-30 00:00:00 |  | FT DAYS | [NAME].
EMBSY14001 | DON | Nursing | 60k-65k | 2014-10-30 00:00:00 |  | FT DAYS | [NAME].
Spreadsheet: 22706d1211852777-doubt-in-macro-try-to-group-rows-macro-error
Sheet: Sheet2

Songs\album | dilruba (1990) | Music | lyrics
song 1
song 2
song 3
song 4
song 5
song 6
song 7
song 8
song 9
song 10
song 11
song 12
song 13
song 14
song 15
song 16
song 17
song 18
song 19
song 20
song 21
song 22
song 23
song 24
Spreadsheet: 94936d1294686731-linking-checkboxes-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
Spreadsheet: 119987d1314903012-excel-2007-calculated-item-error-with-subtotals-and-grand-total-calculated-item-example
Sheet: Data

ServiceLine | Facility | Volume | Month
Service Line X | Facility1 | 219 | FY2011-01
Service Line X | Facility2 | 392 | FY2011-01
Service Line X | Facility3 | 1426 | FY2011-01
Service Line X | Facility4 | 1995 | FY2011-01
Service Line X | Facility5 | 30 | FY2011-01
Service Line X | Facility6 | 2555 | FY2011-01
Service Line X | Facility1 | 240 | FY2012-01
Service Line X | Facility2 | 304 | FY2012-01
Service Line X | Facility3 | 739 | FY2012-01
Service Line X | Facility4 | 1821 | FY2012-01
Service Line X | Facility5 | 19 | FY2012-01
Service Line X | Facility6 | 2339 | FY2012-01
Service Line Z | Facility1 | 277 | FY2011-01
Service Line Z | Facility2 | 554 | FY2011-01
Service Line Z | Facility3 | 1900 | FY2011-01
Service Line Z | Facility4 | 2600 | FY2011-01
Service Line Z | Facility5 | 33 | FY2011-01
Service Line Z | Facility6 | 3400 | FY2011-01
Service Line Z | Facility1 | 318 | FY2012-01
Service Line Z | Facility2 | 408 | FY2012-01
Service Line Z | Facility3 | 966 | FY2012-01
Service Line Z | Facility4 | 2300 | FY2012-01
Service Line Z | Facility5 | 24 | FY2012-01
Service Line Z | Facility6 | 3011 | FY2012-01
Spreadsheet: 268326d1380565573-sum-of-the-working-hours-for-a-person-total-working-hours
Sheet: Sheet1

User | Work Time | need the total output of [NAME]
[NAME] | 0.3 | 8.8
[NAME] | 0.5
[NAME] | 1
[NAME] | 1.5
[NAME] | 2.5
[NAME] | 3
[NAME] | 5 | 9.5
[NAME] | 4.5
[NAME] | 0.25 | 7.55
[NAME] | 0.25
[NAME] | 0.75
[NAME] | 0.3
[NAME] | 2.5
[NAME] | 3.5
Spreadsheet: 147138d1332534987-pasting-data-in-quarterly-format-from-data-in-monthly-format-us-unemployment-rate
Sheet: BLS Data Series

Labor Force Statistics from the Current Population Survey
Original Data Value
Series Id: | [NAME]
Seasonally Adjusted
Series title: | (Seas) Unemployment Rate
Labor force status: | Unemployment rate
Type of data: | Percent or rate
Age: | 16 years and over
Years: | 1948 to 2012
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Annual |  | uert | uertavg
1983 | 10.4 | 10.4 | 10.3 | 10.2 | 10.1 | 10.1 | 9.4 | 9.5 | 9.2 | 8.8 | 8.5 | 8.3 |  | 1983q3 | 9.2 | 9.366666666666665
1984 | 8 | 7.8 | 7.8 | 7.7 | 7.4 | 7.2 | 7.5 | 7.5 | 7.3 | 7.4 | 7.2 | 7.3 |  | 1983q4 | 8.3 | 8.533333333333333
1985 | 7.3 | 7.2 | 7.2 | 7.3 | 7.2 | 7.4 | 7.4 | 7.1 | 7.1 | 7.1 | 7 | 7 |  | 1984q1 | 7.8 | 7.866666666666667
1986 | 6.7 | 7.2 | 7.2 | 7.1 | 7.2 | 7.2 | 7 | 6.9 | 7 | 7 | 6.9 | 6.6 |  | 1984q2 | 7.2 | 7.433333333333334
1987 | 6.6 | 6.6 | 6.6 | 6.3 | 6.3 | 6.2 | 6.1 | 6 | 5.9 | 6 | 5.8 | 5.7 |  | 1984q3 | 7.3 | 7.433333333333334
1988 | 5.7 | 5.7 | 5.7 | 5.4 | 5.6 | 5.4 | 5.4 | 5.6 | 5.4 | 5.4 | 5.3 | 5.3 |  | 1984q4 | 7.3 | 7.300000000000001
1989 | 5.4 | 5.2 | 5 | 5.2 | 5.2 | 5.3 | 5.2 | 5.2 | 5.3 | 5.3 | 5.4 | 5.4 |  | 1985q1 | 7.2
1990 | 5.4 | 5.3 | 5.2 | 5.4 | 5.4 | 5.2 | 5.5 | 5.7 | 5.9 | 5.9 | 6.2 | 6.3 |  | 1985q2 | 7.4
1991 | 6.4 | 6.6 | 6.8 | 6.7 | 6.9 | 6.9 | 6.8 | 6.9 | 6.9 | 7 | 7 | 7.3 |  | 1985q3 | 7.1
1992 | 7.3 | 7.4 | 7.4 | 7.4 | 7.6 | 7.8 | 7.7 | 7.6 | 7.6 | 7.3 | 7.4 | 7.4 |  | 1985q4 | 7
1993 | 7.3 | 7.1 | 7 | 7.1 | 7.1 | 7 | 6.9 | 6.8 | 6.7 | 6.8 | 6.6 | 6.5
1994 | 6.6 | 6.6 | 6.5 | 6.4 | 6.1 | 6.1 | 6.1 | 6 | 5.9 | 5.8 | 5.6 | 5.5
1995 | 5.6 | 5.4 | 5.4 | 5.8 | 5.6 | 5.6 | 5.7 | 5.7 | 5.6 | 5.5 | 5.6 | 5.6
1996 | 5.6 | 5.5 | 5.5 | 5.6 | 5.6 | 5.3 | 5.5 | 5.1 | 5.2 | 5.2 | 5.4 | 5.4
1997 | 5.3 | 5.2 | 5.2 | 5.1 | 4.9 | 5 | 4.9 | 4.8 | 4.9 | 4.7 | 4.6 | 4.7
1998 | 4.6 | 4.6 | 4.7 | 4.3 | 4.4 | 4.5 | 4.5 | 4.5 | 4.6 | 4.5 | 4.4 | 4.4
1999 | 4.3 | 4.4 | 4.2 | 4.3 | 4.2 | 4.3 | 4.3 | 4.2 | 4.2 | 4.1 | 4.1 | 4
2000 | 4 | 4.1 | 4 | 3.8 | 4 | 4 | 4 | 4.1 | 3.9 | 3.9 | 3.9 | 3.9
2001 | 4.2 | 4.2 | 4.3 | 4.4 | 4.3 | 4.5 | 4.6 | 4.9 | 5 | 5.3 | 5.5 | 5.7
2002 | 5.7 | 5.7 | 5.7 | 5.9 | 5.8 | 5.8 | 5.8 | 5.7 | 5.7 | 5.7 | 5.9 | 6
2003 | 5.8 | 5.9 | 5.9 | 6 | 6.1 | 6.3 | 6.2 | 6.1 | 6.1 | 6 | 5.8 | 5.7
2004 | 5.7 | 5.6 | 5.8 | 5.6 | 5.6 | 5.6 | 5.5 | 5.4 | 5.4 | 5.5 | 5.4 | 5.4
2005 | 5.3 | 5.4 | 5.2 | 5.2 | 5.1 | 5 | 5 | 4.9 | 5 | 5 | 5 | 4.9
2006 | 4.7 | 4.8 | 4.7 | 4.7 | 4.6 | 4.6 | 4.7 | 4.7 | 4.5 | 4.4 | 4.5 | 4.4
2007 | 4.6 | 4.5 | 4.4 | 4.5 | 4.4 | 4.6 | 4.7 | 4.6 | 4.7 | 4.7 | 4.7 | 5
2008 | 5 | 4.9 | 5.1 | 5 | 5.4 | 5.6 | 5.8 | 6.1 | 6.1 | 6.5 | 6.8 | 7.3
2009 | 7.8 | 8.3 | 8.7 | 8.9 | 9.4 | 9.5 | 9.5 | 9.6 | 9.8 | 10 | 9.9 | 9.9
2010 | 9.7 | 9.8 | 9.8 | 9.9 | 9.6 | 9.4 | 9.5 | 9.6 | 9.5 | 9.5 | 9.8 | 9.4
2011 | 9.1 | 9 | 8.9 | 9 | 9 | 9.1 | 9.1 | 9.1 | 9 | 8.9 | 8.7 | 8.5
Spreadsheet: 881944d1730194339-full-workbook-lookup-form-test-wip
Sheet: Company 1

CATERGORY : INGREDIENTS
Item | Weight/ Quantity | RJL CODE | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00
Medium Grill Marked Panini  130g | BOX OF 30 (56 BOXES ON PALLET) | BRR12 | 5.72 | 5.72 | 5.72 | 5.72 | 5.72 | 6.68 | 6.68 | 6.68 | 6.68 | 6.68 |  | 6.68
PRODUCTS NOT PURCHASED RECENTLY
SUPER SUBMARINE ROLL | case (48 units/case) | BRL03
TOP CUT CIABATTA ROLL | (40 units/case) | BRL02
Spreadsheet: 799545d1665137955-countifs-with-multiple-criteria-using-cell-reference-test-25-
Sheet: Sheet1

id | unit 502
1 | Pass |  |  | Pass |  |  | Pass
2 | submitted |  |  |  | Submitted |  | Submitted
3 | pass |  |  |  | Refer |  | Re-Refer
4 | pass |  |  |  | Re-Refer |  | submitted
5 | resit pass |  |  |  | submitted |  | not submitted
6 | resit pass |  |  |  | not submitted |  | Resit Pass
7 | pass |  |  |  | Resit Pass |  | Refer
8 | pass
9 | pass
10 | not submitted
11 | not submitted
should return 7, cell reference are in a cont. [NAME] | =SUM(COUNTIFS(tbl_result[Unit 502],E2,f3:G8))
should return7, Cell references are scattered
I just want to know how to write a formula when criteria is cell referance.
Spreadsheet: ryan_slinger__33673__5_15act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 096009e1-354c-46ed-9d77-fb6a040ccef2
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44021166 | 2014-11-14 20:11:10 | ALLIES | 0 | 5 | 7 | 724044 | Spit1970 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
44021492 | 2014-11-14 20:38:06 | AXIS | 0 | 6 | 7 | 724044 | Spit1970 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
44067997 | 2014-11-17 20:35:08 | ALLIES | 0 | 7 | 10 | 181733 | deepnet | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44068401 | 2014-11-17 21:02:45 | AXIS | 0 | 6 | 10 | 181733 | deepnet | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44069710 | 2014-11-17 22:11:55 | ALLIES | 1 | 6 | 3 | 1422784 | flarchi | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
44136213 | 2014-11-22 20:10:03 | ALLIES | 0 | 6 | 10 | 563579 | Amombar | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44167559 | 2014-11-24 22:24:40 | AXIS | 0 | 7 | 10 | 688270 | Mouchotte72 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44193496 | 2014-11-26 20:07:28 | AXIS | 1 | 7 | 3 | 772737 | dwlandis | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44193663 | 2014-11-26 20:24:26 | ALLIES | 0 | 3 | 7 | 772737 | dwlandis | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44194685 | 2014-11-26 22:10:29 | AXIS | 0 | 8 | 10 | 1546936 | KATANA PAPA | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44195350 | 2014-11-26 22:43:29 | ALLIES | 0 | 9 | 10 | 1546936 | KATANA PAPA | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 66025d1266631862-arrange-the-part-codes-in-nearby-matching-order-book1-1-1
Sheet: Sheet1

Part Code | Group | SORT
111001989000 | SPTR
[PHONE] | SFGD
112001989100 | SPTR
[PHONE] | SFGD
[PHONE] | SFGD
[PHONE] | SFGD
171001589500 | SPTR
[PHONE] | SFGD
[PHONE] | SFGD
Expected Result
Part Code | Code
111001989000 | SPTR
[PHONE] | SFGD
112001989100 | SPTR
[PHONE] | SFGD
[PHONE] | SFGD
[PHONE] | SFGD
171001589500 | SPTR
[PHONE] | SFGD
[PHONE] | SFGD
Spreadsheet: 865256d1712306021-trying-to-tell-excell-to-do-one-thing-if-the-tick-box-is-ticked-and-another-if-the-tick-investment-property-spreadsheet-copy-1-aligw
Sheet: Sheet 1 - INVESTMENT PROPERTY I

INVESTMENT PROPERTY INCOME AND EXPENSES
 | Investment property address |  |  |  |  |  |  |  | Property 1 | Property 2 | SELL
Property information |  |  |  |  |  |  |  | Loan Amount | 580998 |  | Sale Price | 846000
Date of purchase | 2023-04-04 00:00:00 |  |  |  |  |  |  | Interest Rate | 0.06 |  | Selling Costs
Date of first rental income | 2023-04-20 00:00:00 |  |  |  |  |  |  | Initital Cost | 694746 |  | Conveyancer | 1300
Number of days rented | 365 |  |  |  |  |  |  | Current Value | 846000 |  | Pay Out existing loan
Number of days of personal use | 0 |  |  |  |  |  |  | Profit Made |  |  | Profit Before Tax
 |  |  |  |  |  |  |  | Usable Equity |  |  | Factor in orig costs
Purchase costs (only applicable if purchased this tax year) |  |  |  |  |  |  |  | Original Purchase Price | 650000 |  | [NAME] before discount
Stamp duty |  |  |  |  |  |  |  | % Growth |  |  | CGT 50% discount
Transfer fee |  |  |  |  |  |  |  |  |  |  | Your Tax Rate | 0.32
Mortgage registration fee |  |  |  |  |  |  |  | Use equity Next Purchase Price |  |  | [NAME]
Conveyancing |  |  |  |  |  |  |  |  |  |  | Overall Profit after tax to reinvest
Building and pest inspection
Strata inspection (if applicable) |  |  |  |  |  |  |  | Need to add persons income etc |  | Provide graphs with net profit and visualise expenses and income etc |  | Consumer Price index % affects the Gross & Net yield value
[NAME] purchase expenses |  |  |  |  |  |  |  | Cashflow forecast based on parameters set by user
TOTAL |  |  |  |  |  |  |  |  |  | Annual Growth Rate | 0.06
 |  |  |  |  |  |  |  | Automatically work out cashflow and benefit of sell and purchase new property based off provided purchase price |  | YR 1
Home loan costs |  |  |  |  |  |  |  |  |  | YR2
Home loan interest charges
Home loan fees | 500
Lenders mortgage insurance premium | 8896 |  |  |  |  |  |  | PI Repayment Formula | Loan Amount | 500000
TOTAL |  |  |  |  |  |  |  |  | IR | 0.07
 |  |  |  |  |  |  |  |  | Term | 30
Upkeep costs |  |  |  |  |  |  |  |  | Number of payments per year | 12
Repairs |  |  |  |  |  |  |  |  | Total number of repayments
Cleaning fees |  |  |  |  |  |  |  |  | Repayment
Renovation costs |  |  |  |  |  |  |  |  | Sum of payments
Pest control |  |  |  |  |  |  |  |  | Interest Cost
Gardening
TOTAL
Running costs
Council rates | 2000
Strata fees
Building insurance
Landlords insurance | 600
Property management fees
Land tax
Water rates
TOTAL
Investment property income
Rental income
Insurance claims
TOTAL
TOTAL EXPENSES
TOTAL INCOME
CASHFLOW POSITION
Spreadsheet: 1ed97094-91a1-4e58-94cc-0fd0d602ffbb
Sheet: Sheet1

Unnamed: 0 | Process Reviewed | Current State | AORN Recommended Procedure | GAP Exist?    (Y,N) | Action Steps to Close Process Gaps | Responsible Party | Due Date | Comments
1 | What are the ways you move patients in preadmission testing? |  |  |  | Link to tool
2 | What are the ways you move patients in your preoperative area? |  |  |  | Link to tool
3 | What are the ways you move patient intraoperatively? |  |  |  | Link to tool
4 | What are the ways you move patients in PACU? |  |  |  | Link to tool
5 | What are the ways you move patients in endoscopy? |  |  |  | Link to tool
6 | How are patients transported to the preoperative area? |  |  |  | Link to tool
7 | How are patients transported to the OR? |  |  |  | Link to tool
8 | How are patients transported to [NAME]? |  |  |  | Link to tool
9 | How are you transporting patients out of PACU? |  |  |  | Link to tool
10 | What are the ways you move equipment in the OR? |  |  |  | Link to tool
11 | What are the ways you move equipment in Endoscopy? |  |  |  | Link to tool
12 | What are the ways you are lifting and carrying supplies in the OR? |  |  |  | Link to tool
13 | What are the ways you are lifting and carrying supplies in Endoscopy? |  |  |  | Link to tool
14 | Do you have administrative support for the purchase of needed tranfer equipment? |  |  |  | Link to minutes from meeting with administration
15 | Do you have a multidisplinary team dedicated to supporting this change in practice? |  |  |  | Link to minutes from safe patient transfer committee meeting
16 | Have there been any patient or employee injuries related to patient transfer? |  |  |  | Hospital incident report log
17 | Inventory of all tranfer devices by location |  |  |  | Hospital-specific list
18 | Inspection of all transfer devices and maintance or replacement issues addressed |  |  |  | Hospital-specific list
19 | Have all staff members been educated on the proper patient transfer methods? |  |  |  | Hospital inservice records
20 | Do you have an audit tool in place to determine if safe transfers are taking place? |  |  |  | Hospital audit tool
Spreadsheet: eb1212fb-0c7f-4d58-bd68-6bebf9e4678f
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HSCRP | Test | HSCRP | C-Reactive Protein, High Sensitivity, Serum | C-Reactive Protein, High Sens, S | Immunoturbidimetry | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.5 | mL | Collection Container/Tube: Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 0.5 mL | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Low risk: <1.0 mg/L Average risk: 1.0-3.0 mg/L High risk: >3.0 mg/L Acute inflammation: >10.0 mg/L | Monday through Saturday; Continuously | Same day/1 day | 2 days | 1 | 86141 |  |  |  |  | Rochester
HSCRP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
HSCRP | Result | HSCRP | C-Reactive Protein, High Sens, S | C-Reactive Protein, High Sens, S | Numeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | 30522-7 | C reactive protein:MCnc:Pt:Ser/Plas:Qn:High sensitivity