tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 855589d1705104645-creating-custom-charts-my-file-contains-chart-solution-need-to-recreate-it-in-excel-graph-trend-4-
Sheet: graph trend

 |  | 2022
Visit Type 3 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
IP | [NAME] | 116350 | 77230 | 110125 | 100045 | 99370 | 84095 | 72175 | 132170 | 111940 | 111150 | 110535 | 82485
 | Patient Number | 158 | 132 | 174 | 158 | 175 | 164 | 127 | 180 | 185 | 182 | 152 | 140
 | Visits/Encounters | 191 | 119 | 171 | 152 | 141 | 128 | 109 | 193 | 181 | 183 | 169 | 132
OP | [NAME] | 341827.5 | 337865 | 490112.5 | 425575 | 440310 | 474970 | 407585 | 506585 | 412890 | 462112.5 | 486700 | 499850
 | Patient Number | 1116 | 1060 | 1255 | 1299 | 1302 | 1330 | 1229 | 1387 | 1248 | 1350 | 1303 | 1376
 | Visits/Encounters | 564 | 561 | 838 | 706 | 749 | 786 | 665 | 812 | 649 | 734 | 785 | 778
 |  | Green color represents IP Gross Billing
 |  | Grey Color represents [NAME]
Spreadsheet: 0668fe1b-4d7f-4440-afdd-6471689308c5
Sheet: Sheet1

Table 2--World cotton supply and use estimates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  |  | 2013/14
Item | 2012/13 |  | July |  | Aug. |  | Sep.
 | Million 480-lb. [NAME]
Supply:
Beginning stocks--
World | 71.77 |  | 85.58 |  | 86.35 |  | 86.04
Foreign | 68.42 |  | 81.68 |  | 82.55 |  | 82.14
Production--
World | 121.04 |  | 118.02 |  | 116.38 |  | 117.42
Foreign | 103.72 |  | 104.52 |  | 103.33 |  | 104.53
Imports--
World | 46.43 |  | 38.26 |  | 38.37 |  | 38.93
Foreign | 46.42 |  | 38.25 |  | 38.37 |  | 38.92
Use:
[NAME] use--
World | 107.27 |  | 109.79 |  | 109.85 |  | 109.53
Foreign | 103.77 |  | 106.29 |  | 106.35 |  | 106.03
Exports--
World | 46.74 |  | 38.3 |  | 38.36 |  | 38.96
Foreign | 33.72 |  | 27.3 |  | 27.76 |  | 28.56
Ending stocks--
World | 86.04 |  | 94.34 |  | 93.77 |  | 94.73
Foreign | 82.14 |  | 91.44 | 71.22 | 90.97 |  | 91.83
 | Percent
Stocks-to-use ratio:
World | 80.2 |  | 85.9 |  | 85.4 |  | 86.5
Foreign | 79.2 |  | 86 |  | 85.5 |  | 86.6
 | 3
Source: USDA, World Agricultural Outlook Board.
Last update: 09/16/13.
Spreadsheet: 709976d1608647455-specific-time-how-many-times-numbers-coming-in-column-in-excel-example
Sheet: Sheet1

Date | Numbers
2020-12-06 00:00:00 | 17 28 39 37 38 |  |  |  | How many time each number coming from 1995 to 2020
2020-12-05 00:00:00 | 16 21 22 23 38 |  |  | 1995-01-01 00:00:00 | for example 17 is coming 2 time in date range 1995 to 2020
2020-12-04 00:00:00 | 38 23 37 17 20 |  |  | 2020-12-31 00:00:00
1999-08-03 00:00:00 | 02 14 35 38 29 |  |  | 17
1996-08-03 00:00:00 | 07 23 25 34 36
1995-08-03 00:00:00 | 09 31 27 32 23
1990-08-03 00:00:00 | 14 20 24 19 24
2001-07-08 00:00:00 | 07 08 11 12 14
2005-09-04 00:00:00 | 01 17 18 12 19
Spreadsheet: 50363d1249754069-exchange-a-number-for-a-letter-forumla-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | H | HOLIDAY
Week 1
Week Ending:
 |  |  |  |  |  |  | OFFICE USE ONLY
No. | Name | Mon | [NAME] | Wed | Thurs | Fri | Total Hours | Rate (£) | Week 1 (£) | Notes/Comments
 |  |  |  |  |  |  | 0 | 6.15 | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0
 | Totals: | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Week 2
Week Ending:
 |  |  |  |  |  |  | OFFICE USE ONLY
No. | Name | Mon | [NAME] | Wed | Thurs | Fri | Total Hours | Rate (£) | Week 1 (£) | Week 2 (£) | Grand Total
 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
 | Totals: | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
Spreadsheet: b1b210b4-636a-487e-8d36-4eff79507d5a
Sheet: POD Friday

 | Regatta 2013
 | Plan of the Day
 | Friday, April 26,2013
Time: | Event: | Place:
1500 - 2300 | Registration
2000 - 2300 | [NAME]
1900 - 2100 | Set up outside events
2000 | Area Staff Meeting
 | Central Accounting Staff
 | Commodores
 | Area Elected Staff
2100 | Officer and Bos'n Meeting
2100 - 2300 | [NAME] | [NAME]
2300 | Lights out in Berthing
 | Quiet in berthing areas
2400 | All Hands Turn In (Bed Time)
Spreadsheet: 819907d1677761387-count-range-with-dates-not-working-copy
Sheet: DROP DOWN

 |  |  |  | "" ""
 |  |  |  | 2023-02-28 00:00:00
 |  |  |  |  |  | Overrides
 |  |  |  |  |  | Suspended /RRT
 |  |  |  |  |  | Claim closed
Spreadsheet: 851750d1701888203-batching-totalling-based-on-dates-calculating-transactions-test-
Sheet: Reserve Pay Out Schedule

Registrant Name | Date Paid | ref Code | Closing Date | Total Amount | Reserve Percentage | Paid out immediately | Reserve | Date Reserve is Released |  | Remittance Date | Amount Expected
[NAME] |  | 25N4GZ67STQ |  | 939.75 | 20 |  |  |  |  | 2023-06-29 00:00:00
[NAME] |  | 25N4GZ67STQ |  | 939.75 | 20
Roma |  | RQNXYS6N27C |  | 939.75 | 20
Nat |  | 9RNPDQBXNFV |  | 519.75 | 20
[NAME] |  | W9NCR5HM2Q7 |  | 519.75 | 20
Collet |  | [NAME] |  | 467.25 | 20
[NAME] |  | 3RNWDZ929KD |  | 1044.75 | 20
[NAME] |  | 3RNWDZ929KD |  | 1044.75 | 20
[NAME] |  | [NAME] |  | 519.75 | 20
Yuna |  | R8NQDGD3WC2 |  | 1044.75 | 20
[NAME] |  | 3RNWDZ929KD |  | 1044.75 | 20
[NAME] |  | 3RNWDZ929KD |  | 1044.75 | 20
[NAME] |  | 3RNWDZ929KD |  | 1044.75 | 20
[NAME] |  | 3RNWDZ929KD |  | 1044.75 | 20
Tyler |  | 3RNWDZ929KD |  | 1044.75 | 20
[NAME] |  | 6GNJJPKXXF8 |  | 1884.75 | 20
[NAME] |  | R8NQDGD3WC2 |  | 1044.75 | 20
Rajesh |  | 3RNWDZ929KD |  | 1044.75 | 20
[NAME] |  | WSND67JG6B9 |  | 1989.75 | 20
Scott |  | 6FNRGQFD24N |  | -1779.75 | 20
[NAME] |  | W9NCR5HM2Q7 |  | 519.75 | 20
Jon |  | W9NCR5HM2Q7 |  | 519.75 | 20
[NAME] |  | W9NCR5HM2Q7 |  | 519.75 | 20
[NAME] |  | W9NCR5HM2Q7 |  | 519.75 | 20
[NAME] |  | [NAME] |  | 519.75 | 20
[NAME] |  | 25N4GZ67STQ |  | 1044.75 | 20
Brett |  | F2NBJ6NQQJZ |  | 1884.75 | 20
[NAME] |  | WSND67JG6B9 |  | 1884.75 | 20
[NAME] |  | WSND67JG6B9 |  | 1989.75 | 20
Wei |  | BBNBJ2TM9JV |  | 519.75 | 20
Troy |  | VXNWTYCYLXD |  | 1989.75 | 20
[NAME] |  | BBNBJ2TM9JV |  | 519.75 | 20
Justin |  | Q4N7BH78NXQ |  | 1044.75 | 20
Mira |  | VXNWTYCYLXD |  | -1989.75 | 20
[NAME] |  | 6FNRGQFD24N |  | 1989.75 | 20
Carm |  | Q4N7BH78NXQ |  | 1044.75 | 20
[NAME] |  | 59NP48373JG |  | -1779.75 | 20
Brenn |  | 59NP48373JG |  | -1779.75 | 20
Spreadsheet: lisa_gang__22290__ENA_PGE_MAY 7_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 2002-05-07 00:00:00
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  |  |  | Total In To PGE Trans
0100 |  |  |  |  | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0 | 0
0700 | 25 | 25 | 25 | 25 | 25 | 25
0800 | 25 | 25 | 25 | 25 | 25 | 25
0900 | 25 | 25 | 25 | 25 | 25 | 25
1000 | 25 | 25 | 25 | 25 | 25 | 25
1100 | 25 | 25 | 25 | 25 | 25 | 25
1200 | 25 | 25 | 25 | 25 | 25 | 25
1300 | 25 | 25 | 25 | 25 | 25 | 25
1400 | 25 | 25 | 25 | 25 | 25 | 25
1500 | 25 | 25 | 25 | 25 | 25 | 25
1600 | 25 | 25 | 25 | 25 | 25 | 25
1700 | 25 | 25 | 25 | 25 | 25 | 25
1800 | 25 | 25 | 25 | 25 | 25 | 25
1900 | 25 | 25 | 25 | 25 | 25 | 25
2000 | 25 | 25 | 25 | 25 | 25 | 25
2100 | 25 | 25 | 25 | 25 | 25 | 25
2200 | 25 | 25 | 25 | 25 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24711 | BPA(G)24718 | BPA(G)24727 | BPA(G)24771 | BPA(G)24547 | BPA(G)24547
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AEP | AEP | AEP | AEP | AEP | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AEP | AEP | AEP | AEP | AEP | AEP
 | CDWR | CDWR | TID | AVISTA | SNCL | MORGAN
 | ISO(T)MALIN/NP15 | ISO(T)MALIN/NP15 | TID(T)CPJK/TRACEY/WESLEY | MID | ISO(T)CPJK/NP15 | APX
 | CDWR(L,FS)NP15 (CA) | CDWR(L,FS)NP15 (CA) | TID | MID9T)CPJK/TRACEY/WESLEY | SNCL(L)NP15 | ISO(T)MALIN/NP15
 |  |  | TID(L)WESLEY | MID(L)TRACEY |  | APX(L,FS)SYS
Spreadsheet: 118389d1313652510-data-validation-auto-complete-combo-box-example
Sheet: Sheet1

Tennant
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Brett
Calvin
Calvin
Caroline
Christina
[NAME]
Crystal
Curtis
[NAME]
[NAME]
[NAME]
Dolores
[NAME]
[NAME]
[NAME]
Dwight
Elsie
Elsie
[NAME]
[NAME]
Ethel
[NAME]
[NAME]
Faye
[NAME]
Franklin
[NAME]
[NAME]
Gladys
Glenda
Gretchen
Gretchen
Gretchen
Harvey
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Jessica
[NAME]
[NAME]
Julia
[NAME]
[NAME]
[NAME]
Kelly
Kristina
Kristine
[NAME]
[NAME]
[NAME]
Louis
[NAME]
[NAME]
[NAME]
[NAME]
Marian
Marianne
Marion
[NAME]
Melinda
Michelle
[NAME]
[NAME]
[NAME]
[NAME]
Paige
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Priscilla
Samantha
Sandy
Sara
Scott
Shelley
[NAME]
[NAME]
[NAME]
Stacy
Stacy
[NAME]
[NAME]
[NAME]
[NAME]
Wayne
[NAME]
[NAME]
Spreadsheet: 026c518c-b948-4e99-9323-ac56ee92b377
Sheet: Sheet1

ECOLAB INC. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
CONSOLIDATED STATEMENT OF CASH FLOWS
NINE MONTHS ENDED SEPTEMBER 30, 2011
(unaudited)
 |  |  | Sept 30 |  | Sept 30
(millions) |  |  | 2011 |  | 2010
Operating Activities
Net income including noncontrolling interest |  |  | 374.5 |  | 399.5
Adjustments to reconcile net income including noncontrolling
interest to cash provided by operating activities:
 | Depreciation and amortization |  | 285 |  | 259.5
 | Deferred income taxes |  | 3.3 |  | 2.9
 | Share-based compensation expense |  | 28 |  | 21
 | Excess tax benefits from share-based payment arrangements |  | -8.9 |  | -13.3
 | Pension and postretirement plan contributions |  | -132 |  | -19.4
 | Pension and postretirement plan expense |  | 60.6 |  | 67.5
 | Restructuring, net of cash paid |  | 44.7 |  | 0
 | Other, net |  | 5.6 |  | 3.1
 | Changes in operating assets and liabilities:
 | Accounts receivable |  | -74.1 |  | -74.5
 | Inventories |  | -28 |  | 1.7
 | Other assets |  | -40.7 |  | 2.4
 | Accounts payable |  | 47.1 |  | 9
 | Other liabilities |  | -24.4 |  | -21.2
 | Cash provided by operating activities |  | 540.7 |  | 638.2
Investing Activities
Capital expenditures |  |  | -228.3 |  | -188.2
Capitalized software expenditures |  |  | -16.5 |  | -28.3
Property and other assets sold |  |  | 3.1 |  | 1.5
Businesses acquired and investments in affiliates, net of cash acquired |  |  | -281.9 |  | -39.6
Sale of businesses |  |  | 0 |  | 16
Deposit into indemnification escrow |  |  | -28.1 |  | -2.1
Receipt from indemnification escrow |  |  | 0 |  | 0.9
 | Cash used for investing activities |  | -551.7 |  | -239.8
Financing Activities
Net issuances (repayments) of commercial paper and notes payable |  |  | 297 |  | 89.9
Long-term debt borrowings |  |  | 0 |  | 0
Long-term debt repayments |  |  | -155.7 |  | -5.9
Reacquired shares |  |  | -122.5 |  | -345.1
Cash dividends paid on common stock |  |  | -122.3 |  | -109.6
Exercise of employee stock options |  |  | 60.2 |  | 71.9
Excess tax benefits from share-based payment arrangements |  |  | 8.9 |  | 13.3
Other, net |  |  | -8.3 |  | 0
 | Cash provided by (used for) financing activities |  | -42.69999999999999 |  | -285.5000000000001
Effect of exchange rate changes on cash |  |  | 18.7 |  | -18.1
Increase (decrease) in cash and cash equivalents |  |  | -34.99999999999999 |  | 94.80000000000004
Cash and cash equivalents, beginning of period |  |  | 242.3 |  | 73.6
Cash and cash equivalents, end of period |  |  | 207.3 |  | 168.4
Spreadsheet: 864800d1711949502-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record-aligw
Sheet: Formaldehyde

Raw Material |  | Formaldehyde
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 25
2023-10-02 00:00:00 |  |  |  |  | 7.7
2023-10-03 00:00:00 |  |  |  |  | 7.7
2023-10-04 00:00:00 |  |  |  |  | 7.7
Total
Spreadsheet: 94145d1294026600-formula-when-result-falls-within-a-dollar-range-book2
Sheet: New Hire 1

CONTRACT COMMISSIONS
New Hire 1 |  | NH1
2011
Class | Month |  | Client Billed | Invoice Date |  | Invoice # | [NAME] |  | Total GP / Hour | [NAME] % | # [NAME] | GP Earned
af | jan |  |  |  |  |  |  |  | 45 | 0.2 | 40
it | feb |  |  |  |  |  |  |  | 80 | 0.5 | 80
fs | [NAME] |  |  |  |  |  |  |  | 62 | 0.5 | 40
af | apr |  |  |  |  |  |  |  | 45 | 0.75 | 40
it | apr |  |  |  |  |  |  |  | 45 | 0.75 | 40
 |  |  | GP | Commission |  | GP | Commission |  | GP | Commission | YTD GP Earned By Class |  |  | YTD Commission Earned By Class
Month | Monthly Commission Rate |  | IT |  |  | AF |  |  | FS |  | IT | AF | FS | IT | AF | FS | YTD GP | YTD Commission
Dec | 0.35
Nov | 0.35
Oct | 0.35
Sep | 0.35
Aug | 0.35
Jul | 0.35
Jun | 0.35
May | 0.35
Apr | 0.35
Mar | 0.35
Feb | 0.35
Jan | 0.35
Total
 |  |  |  |  |  |  | Total GP - Check #
 |  |  |  |  |  |  | Tot YTD Comm - Check #
 | Threshold Range |  | Rate |  | [NAME]
 | 0 | 200000 | 0.3
 | 200001 | 300000 | 0.35
 | 300001 | 400000 | 0.4 | Here are the rates for the corresponding ranges
 | 400001 | 500000 | 0.45
 | 500001 | 600000 | 0.5
 | 600001 |  | 0.55
 |  |  |  | These are the ranges that the gross profit will fall between.
 |  |  |  | Here is the data section for the gross profit that will be earned throughout the year.
Spreadsheet: 819111d1677220600-formula-to-separate-multicurrency-file-to-its-respective-currencies-multicurrency
Sheet: Sheet1

Kindly asking for excel formula to separate a purchase ledger with multicurrency into three respective currencies as shown on the desired solution.
 |  |  |  |  |  |  |  |  | DESIRED SOLUTION
 | Multicurrency |  |  |  |  |  |  |  |  | ZWL |  |  |  |  |  |  |  | USD |  |  |  |  |  |  |  | ZAR
 | Supplier | [NAME] | Date | Order | Exclusive | Tax | Inclusive |  |  | Supplier | [NAME] | Date | Order | Exclusive | Tax | Inclusive |  | Supplier | [NAME] | Date | Order | Exclusive | Tax | Inclusive |  | Supplier | [NAME] | Date | Order | Exclusive | Tax | Inclusive
 | PU001 | GRN | 2022-09-16 00:00:00 | P001 | 93266 | 13523 | 106789 |  |  | PU001 | GRN | 2022-09-16 00:00:00 | P001 | 93266 | 13523 | 106789 |  | DUB002 | GRN | 2022-09-19 00:00:00 | P12 | 25 |  | 25 |  | DUB002 | GRN | 2022-09-19 00:00:00 | P11 | 234 | 4 | 230
 | DUB002 | GRN | 2022-09-19 00:00:00 | P12 | 25 |  | 25 |  |  | COM23 | GRN | 2022-09-20 00:00:00 | P34 | 100 | 3 | 97 |  | DUB002 | GRN | 2022-09-19 00:00:00 | P12 | 234 | 4 | 230 |  | DUB002 | GRN | 2022-09-19 00:00:00 | P13 | 250 | 50 | 200
 | COM23 | GRN | 2022-09-20 00:00:00 | P34 | 100 | 3 | 97 |  |  | [NAME] | GRN | 20/19/2022 | P34 | 120 | 3 | 117 |  | DUB002 | GRN | 2022-09-19 00:00:00 | P12 | 250 | 50 | 200
 | DUB002 | GRN | 2022-09-19 00:00:00 | P12 | 234 | 4 | 230 |  |  |  |  |  |  |  |  |  |  | DUB002 | GRN | 19/19/2022 | P12 | 25 |  | 25
 | DUB002 | GRN | 2022-09-19 00:00:00 | P12 | 250 | 50 | 200
 | DUB002 | GRN | 19/19/2022 | P12 | 25 |  | 25
 | [NAME] | GRN | 20/19/2022 | P34 | 120 | 3 | 117
 | DUB002 | GRN | 2022-09-19 00:00:00 | P11 | 234 | 4 | 230
 | DUB002 | GRN | 2022-09-19 00:00:00 | P13 | 250 | 50 | 200
Spreadsheet: 881757d1729911723-power-query-internal-lookup-date2
Sheet: Sheet1

 |  |  | Starting Point |  | Trans Date | Trans Type | Ref |  |  | Trans Date | Trans Type | Ref | Trans Date 2
 |  |  |  |  | 2023-01-01 00:00:00 | Invoice | 123 |  |  | 2023-01-01 00:00:00 | Invoice | 123 | 2023-01-01 00:00:00
 |  |  |  |  | 2023-01-02 00:00:00 | Invoice | 456 |  |  | 2023-01-02 00:00:00 | Invoice | 456 | 2023-01-02 00:00:00
 |  |  |  |  | 2023-01-03 00:00:00 | Credit Note | 456 |  |  | 2023-01-03 00:00:00 | Credit Note | 456 | 2023-01-02 00:00:00
 |  |  |  |  | 2023-01-04 00:00:00 | Invoice | 234 |  |  | 2023-01-04 00:00:00 | Invoice | 234 | 2023-01-04 00:00:00
 |  |  |  |  | 2023-01-05 00:00:00 | Invoice | 432 |  |  | 2023-01-05 00:00:00 | Invoice | 432 | 2023-01-05 00:00:00
 |  |  |  |  | 2023-01-06 00:00:00 | Credit Note | 123 |  |  | 2023-01-06 00:00:00 | Credit Note | 123 | 2023-01-01 00:00:00
 |  |  |  |  | let
 |  |  |  |  | Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
 |  |  |  |  | #"Changed Type" = Table.TransformColumnTypes(Source,{{"Trans Date", type date}, {"Trans Type", type text}}),
 |  |  |  |  | #"Merged Queries" = Table.NestedJoin(#"Changed Type", {"Ref"}, StartData, {"Ref"}, "StartData", JoinKind.LeftOuter),
 |  |  |  |  | #"Expanded StartData" = Table.ExpandTableColumn(#"Merged Queries", "StartData", {"Trans Date"}, {"Trans Date.1"}),
 |  |  |  |  | #"Sorted Rows" = Table.Sort(#"Expanded StartData",{{"Trans Date", [NAME].Ascending}}),
 |  |  |  |  | #"Removed Duplicates" = Table.Distinct(#"Sorted Rows", {"Trans Date", "Trans Type", "Ref"}),
 |  |  |  |  | #"Renamed Columns" = Table.RenameColumns(#"Removed Duplicates",{{"Trans Date.1", "Trans Date 2"}})
 |  |  |  |  | in
 |  |  |  |  | #"Renamed Columns"
Spreadsheet: 854215d1704176724-a-networkday-formula-that-excludes-holidays-and-multiple-leave-date-entries-by-employee-formula-play_with-expected-results-highlighted-in-yellow_v4-hd-1-
Sheet: Project

employee | Start | end | actual end |  | Networkdays | Example of actual end date | result wanted for example of actual end date |  | number of sick leave days for end date | number of sick days for actual end date
AS123 | 2024-01-15 00:00:00 | 2024-02-16 00:00:00 | 2024-02-14 00:00:00 |  |  |  | 16
AP345 | 2024-03-10 00:00:00 | 2024-03-14 00:00:00 | 2024-03-13 00:00:00 |  |  |  | 1
AP346 | 2023-12-29 00:00:00 | 2024-03-29 00:00:00 | 2024-02-19 00:00:00 |  |  |  | 28
[NAME] | 2023-12-05 00:00:00 | 2024-02-02 00:00:00 | 2024-02-20 00:00:00 | 2024-02-03 00:00:00 |  |  | -6
Spreadsheet: 735275d1622807595-select-column-header-based-on-condition-last_month
Sheet: Sheet3

 | June | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 5
4 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0
5 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 01ebf95f-b221-4f6d-b58f-c62b40bf3c8a
Sheet: Sheet1

RFP 29-11 ORJ Warehouse A/C                                                                                                                                                                                                                                                                                                                                 OPENED:     December 2, 2011                                           AWARDED:   January 3, 2012                                            (Project-No Renewals) |  | Kenyon & Partners         3203 Queen Palm Dr.    Tampa, FL 33619                Ph [PHONE]                   Fx [PHONE]             Wayne Evans, ProjMgr wayne.evans@kenyonand partners.com | Air Mechanical & Svc Corp        4311 [NAME], Fl 33614                   Ph [PHONE]                   Fx [PHONE]              [NAME]                    [EMAIL] | [NAME] Maislin Dr.                Tampa Fl 33637                     Ph [PHONE]                     Fx [PHONE]                         Keith Hartsfield, ProjMgr [EMAIL] | [NAME]1501 Hobbs St.                  Tampa Florida 33619                Ph [PHONE]                   Fx [PHONE]                          [NAME], ProjMgr [EMAIL] | Unnamed: 6 | Unnamed: 7
SHADED AREA INDICATES AWARD
Description |  | 1 | 2 | 3 | 4
TOTAL PRICE OF EQUIPMENT, INSTALLATION, LABOR & MATERIALS |  | 62500 | 45500 | 52060 | 46900
CALENDAR DAYS TO COMPLETE |  | 45 | 30 | 60 | 30
EXCEPTIONS |  |  |  | None | None
Spreadsheet: 723644d1615818263-if-isnumber-formula-update-cells-with-character-depending-on-dates-holiday-forms-2021
Sheet: Colleague 18

HOLIDAY FORM 2021
NAME: |  |  |  | 2020 BANK HOLIDAY DATES | TAKEN Y/N (IF NO ADD LIEU DAY TO TABLE)
2021 HOLIDAY ENTITLEMENT |  |  |  | 01/01/2021 (New Years Day) | Y
To be completed - |  |  |  | 02/04/2021 (Good Friday)
2021 ENTITLEMENT |  | 25 |  | 05/04/2021 (Easter Monday)
CARRIED OVER FROM 2020 |  | 0 |  | 03/05/2021 (May Bank Hol)
LIEU DAYS |  | 0 |  | 31/05/2021 (May Bank Hol)
BOUGHT HOLIDAYS FOR 2021 |  | 0 |  | 30/08/2021 (Aug Bank Hol)
OTHER ENTITLEMENT (PLEASE ADD DETAILS) |  | 0 |  | 27/12/2020 (Xmas Day)
Reason: |  |  |  | 28/12/2020 (Xmas BH Day)
TOTAL FOR 2021:
HOLIDAY BOOKING PROCESS
1) | Send a request for holiday dates to your line manager
2) | Once approval is gained, issue a meeting invite to your line manager and direct team so they are aware of holiday dates
2) | Update this holiday form yourself and re-save on the network once approved
FROM | TO | DAYS | DAYS | AUTHORISED | DATE OF APPROVAL
 | (INCLUSIVE) | TAKEN | LEFT | BY
Date (dd/mm/yyyy) | Date (dd/mm/yyyy) | 0 |  | Add line manager name | Add date (dd/mm/yyyy)
2021-09-08 00:00:00 | 13/08/2021 | 5
Spreadsheet: 679638d1590552558-lookup-based-on-2-criteria-lookup-example
Sheet: data

ID | Name | Project | Hours
12345 | [NAME], [NAME] | 85000.AZ.3000 | 2500
98765 | Doe, [NAME] | 90000.AB.3000 | 4500
24680 | [NAME], [NAME] | 85000.AZ.3000 | 1000
13579 | [NAME], [NAME] | 85000.AZ.3000 | 700
13579 | [NAME], [NAME] | 90000.AB.3000 | 2500
12390 | Nicole, Amber | 85000.AB.3000 | 25
24680 | [NAME], [NAME] | 90000.AB.3000 | 55
12345 | [NAME],[NAME] | 85000.AB.3000 | 300
98765 | Doe, [NAME] | 90000.AZ.3000 | 5000
Spreadsheet: 1c306f2e-31f7-4b8a-a8a7-dd8f5904dda9
Sheet: Sheet1

Organization Name: |  | Nurse Leader Eligibility Table
Note:  Before beginning to enter data, create one line for each unit to be entered.  If additional lines are needed for a Unit Type, right click on a row number within that unit type and select "Insert".  Enter one unit per line.
Dept./Service/Unit | Units | Name (Last, First) | Highest Nursing Degree | Job Title
Medical
Surgical
Med-Surg
Oncology
Step Down
Critical Care
Labor & Delivery
Ante/Post Partum
NICU
Pediatrics
PICU
Operating Room(s)
PACU
Amb. Procedure
Psych.
Rehab.
Ambulatory
Emergency Department
Specialty Practice
Acuity Adaptable
Pre-Operative
LDRP
Home Care
Hospice
Long Term Care
Centralized Function
All Others
© 2013 American Nurses Credentialing Center.