tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 744848d1629481875-calculating-monthly-average-2011-2012
Sheet: 2011-2012

2011 |  |  |  | 2012
Shipping Date | Total QTY | Total Destinations |  | Shipping Date | Total QTY | Total Destinations
2011-04-29 00:00:00 | 4095 | 5 |  | 2012-01-06 00:00:00 | 1900 | 4 |  | =AVERAGEIFS($C$3:$C$12,$B$3:$B$12,”>=”&$E3,$B$3:$B$12,”<=”&EOMONTH($E3,0))
 | 3112 | 4 |  |  | 2183 | 5 |  | =AVERAGEIFS(values,dates,”>=”&A1,dates,”<=”&EOMONTH(A1))
 | 1452 | 5 |  |  | 441 | 5 |  | =IFERROR(AVERAGEIFS($C$39:$C$58,$B$39:$B$58,">="&$E39,$B$39:$B$58,"<="&EOMONTH($E39,0)),0)
 | 1851 | 4 |  |  | 846 | 6 |  | =IFERROR(SUMPRODUCT((MONTH($B$3:$B$38)=MONTH(H7)*(YEAR($B$3:$B$38)=YEAR(H7)))*($C$39:$C$58))/(SUMPRODUCT((MONTH($B$39:$B$58)=MONTH(E39)*(YEAR($B$39:$B$58)=YEAR(E39)))*1)),0)
 | 1131 | 3 |  |  | 848 | 4
 | 640 | 5 |  |  | 989 | 5
 | 1002 | 5 |  |  | 992 | 5
 | 1756 | 4 |  |  | 716 | 4
 | 779 | 5 |  |  | 588 | 4
2011-06-30 00:00:00 | 435 | 5 |  |  | 688 | 6 |  | Jan
2011-07-08 00:00:00 | 1147 | 3 |  |  | 772 | 7 |  | Feb
 | 981 | 5 |  |  | 418 | 3 |  | Mar
 | 761 | 4 |  |  | 568 | 5 |  | Apr
 | 786 | 5 |  |  | 437 | 5 |  | May
 | 194 | 4 |  |  | 825 | 6 |  | Jun
 | 694 | 5 |  |  | 707 | 3 |  | Jul
 | 1852 | 5 |  |  | 398 | 4 |  | Aug
 | 621 | 4 |  |  | 630 | 7
 | 636 | 4 |  |  | 1033 | 6
 | 324 | 3 |  |  | 865 | 7
 | 265 | 3 |  |  | 668 | 5
 | 386 | 4 |  |  | 1103 | 3
 | 1196 | 2 |  |  | 889 | 6
 | 952 | 5 |  |  | 461 | 4
 | 753 | 5 |  |  | 1059 | 5
 | 2025 | 4 |  |  | 786 | 5
 | 529 | 6 |  |  | 1645 | 5
 | 1411 | 3 |  |  | 740 | 5
 | 845 | 6 |  |  | 727 | 7
 | 719 | 5 |  |  | 841 | 7
 | 405 | 6 |  |  | 1276 | 4
 | 3779 | 4 |  |  | 889 | 4
 | 3943 | 6 |  |  | 532 | 4
 | 4466 | 6 |  |  | 725 | 7
 | 2384 | 5 |  |  | 1096 | 2
2011-12-28 00:00:00 | 397 | 5 |  |  | 409 | 3
 |  |  |  |  | 716 | 6
 |  |  |  |  | 761 | 5
 |  |  |  |  | 939 | 4
 |  |  |  |  | 1365 | 7
 |  |  |  |  | 761 | 5
 |  |  |  |  | 1671 | 6
 |  |  |  |  | 748 | 6
 |  |  |  |  | 168 | 3
 |  |  |  |  | 490 | 4
 |  |  |  |  | 460 | 4
 |  |  |  |  | 1864 | 6
 |  |  |  |  | 740 | 6
 |  |  |  |  | 490 | 6
 |  |  |  |  | 912 | 6
 |  |  |  |  | 2099 | 6
Spreadsheet: 44692d1243457364-listing-unique-values-and-summing-w-o-a-pivot-table-listing-unique-values-and-summing-wo-a-pivot-table
Sheet: Sheet1

22 | 10
23 | 20
22 | 10
24 | 20
22 | 10
 |  |  |  |  | UniqueValues | Total
 |  |  |  |  | 22 | 30
 |  |  |  |  | 23 | 20
 |  |  |  |  | 24 | 20
 |  |  |  |  | #N/A | 0
 |  |  |  |  | #N/A | 0
Spreadsheet: 865369d1712407076-countif-and-conditional-formatting-workdays-2
Sheet: Sheet1

 |  |  | ContainsLetters And =14
 |  |  | Greater than 14
MARCH/2024 |  | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | work days
Id Number | Name | 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
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | Y
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | X
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | Y
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Spreadsheet: 840755d1692965854-problem-with-using-and-manipulating-times-demo-time
Sheet: Worksheet

Drive | # of Plays | Time SOD | T EOD | Total time |  | # of Plays
1
Spreadsheet: 746536d1630825163-sum-data-from-different-columns-based-on-the-dates-selected-workfile
Sheet: Sheet1

Date From | 5 | May | 2021
Date To | 10 | May | 2021
Total
Cumulative
Year | 2021 |  |  |  |  |  |  |  |  | 2022
Date
 | 2021-04-01 00:00:00
Cumulative | 1302580 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb
1 | 8150 | 8890 | 9790 | 10270 | 10050 | 10540 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar
 | 3675 | 9000 | 9820 | 2800 | 10070 | 10510 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr
 | 8200 | 9040 | 9920 | 10310 | 10070 | 5020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 | 8200 | 8970 | 4665 | 10250 | 10020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun
 | 8210 | 9060 | 9960 | 10170 | 10050 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul
 | 8180 | 9030 | 10000 | 10160 | 4805 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug
 | 8320 | 4215 | 9950 | 9980 | 10080 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep
 | 8260 | 9140 | 10000 | 9980 | 10080 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct
 | 7820 | 9190 | 9980 | 4880 | 10120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov
 | 8380 | 9190 | 9980 | 10000 | 10180 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec
 | 8440 | 9250 | 4795 | 10000 | 10190
 | 8480 | 9250 | 9960 | 10100 | 5115
 | 8430 | 0 | 9960 | 10040 | 945
 | 8500 | 3100 | 9960 | 10040 | 10140
 | 8600 | 9300 | 9960 | 8760 | 10260
 | 4040 | 9280 | 9960 | 4435 | 10230
 | 8450 | 9170 | 9970 | 10090 | 10290
 | 8470 | 9040 | 4795 | 10070 | 10410
 | 8570 | 9170 | 9970 | 10070 | 10430
 | 8510 | 9170 | 9970 | 0 | 5070
 | 8530 | 4390 | 9970 | 9210 | 10490
 | 8540 | 9160 | 10150 | 10110 | 10490
 | 3925 | 9240 | 10080 | 4960 | 10390
 | 8530 | 9420 | 10250 | 10170 | 10390
 | 8550 | 9510 | 4865 | 10120 | 10350
 | 8640 | 9510 | 10270 | 10120 | 10370
 | 8670 | 9530 | 10300 | 10000 | 4990
 | 8690 | 4570 | 10300 | 10020 | 10520
 | 8830 | 9750 | 10290 | 10140 | 10560
 | 4155 | 9840 | 10290 | 4910 | 10560
 | 0 | 9840 | 0 | 10010 | 10560
Spreadsheet: 1a008053-8913-43a1-8534-eca32418996f
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 75. Value of Building Approved, Chain Volume Measures, Original - New South Wales
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 ;  New South Wales ;  Total houses ;  New ; |  |  | Original | A590477A | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total other residential building ;  New ; |  |  | Original | A590478C | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total residential building ;  New ; |  |  | Original | A590479F | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590480R | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590481T | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590482V | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  New South Wales ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590483W | 1985-09-01 00:00:00 | 2010-09-01 00:00:00 | 101 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: 875581d1722188877-how-to-make-index-work-after-drag-solved-test
Sheet: февруари

№ | Name | 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
 |  | LEMON
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LIME
Spreadsheet: 86577d1286525343-inventory-stock1
Sheet: DVD'S CD'S

S.No | [NAME] | MODEL NO | SERIAL NO | QTY | FINISH
1 | Pioneer DVD player | DV-220-KV-K
2 | LG LAM- N760 CAR DVD RECIVER |  |  | 1
3 | DENON IPOD DOCK  CONTROL | ASD 11R | 0 063319550 | 2
4 | B&W Zeppellin IPOD palyer |  | 57184 | 1 | BLACK
 | BACK
Spreadsheet: stacey_white__39232__spark_gap_requirements
Sheet: Sheet1

Business Owner | Business | Title | Description | Implementation | Status | Priority | Targeted Completion Date
[NAME] | Volume [NAME]. | ERCOT Automation | ERCOT solution for data collection, charge estimation, customer allocation and reconciliation (between ERCOT, Enron and customer) | ESCA Providing Solution.  Currently assessing [NAME] and VMS as possible long term solutions | Working Group developing requirements | 1
[NAME] | Volume [NAME]. | PJM Automation | Port Volume [NAME]. for PJM from Access/Excel based solutions to an automated system. | Currently assessing [NAME], ESCA and VMS as possible long term solutions | Working Group developing requirements | 1
[NAME] | Volume [NAME] | Daily Estimates | New interface to scrape meter websites for all counterparties and markets or receive meter files |  |  | 3
[NAME] | Volume [NAME]. | Dispute Activity | Automate current processes |  |  | 2
[NAME] | Volume [NAME]. | Market Charges Capture | Capture all charges within each market proactively and make available for new service transactions | Currently assessing using Accenture to assist in this area | Working Group developing requirements | 1
[NAME] | Settlements Reconcile | Flash Automation | Develop system solution to automate current [NAME] process. |  |  | 3
[NAME] | Settlements Reconcile | EnPower to Unify | Develop system solution to automate current EnPower to Unify reconciliation process. |  |  | 3
[NAME] | Settlements Reconcile | Checkout | Develop system solution to automate current spreadsheet based Checkout |  |  | 3
Bentley | PJM MOS | Automate Scheduling - PJM | Strategic solution required for PJM | Currently assessing FSP and ESCA as potential solutions | Working Group developing requirements | 1
Bentley | Trading Hourly | Hourly Traders Workbench | Automate manual/time intensive processes. |  |  | 2
Bentley | Trading General | Consolidated Position Manager Phase II | Combine Consolidated Position Manager and Curve Manager into one application |  | Requires Scoping | 2
White | Risk | [NAME]. Phase II | Provide curve shift for GAS and other commodities (gas, c. oil, heating oil, coal, and weather).  Currently, positions for other commodities are captured, not prices. Graphical and Tabular changes in curves over time. Swap model. |  | Requires Scoping | 2
White | Risk Deal Capture | Data entry for variable load deals | Currently performed by Risk Management and very time consuming.  Will not scale. | Will utilize new system developed by EES. |  | 3
White | Systems Architecture | Portcalc | Portcalc will not scale with increased volume (98) | Will utilize new system developed by EES. |  | 3
Spreadsheet: 268225d1380514979-sum-of-identical-values-text-in-different-tab-thinker8
Sheet: Sheet1

Resolved
Closed
Closed
Resolved
Closed
Open
Resolved
Resolved
Open
Closed
Resolved
Resolved
Closed
Resolved
Open
Open
Resolved
Open
Open
Open
Resolved
Resolved
Open
Closed
Open
Closed
Closed
Open
Resolved
Resolved
Open
Resolved
Resolved
Resolved
Spreadsheet: 838659d1691229348-splitting-days-across-a-range-allocating-nights-to-blocks-2-
Sheet: Sheet1

Guest Name | [NAME] date | checkout date | total nights stayed | night block 1 | night block 2 | night block 3 | night block 4 | night block 5 | block 24 | block 25 | Nights allocated Check
 |  |  | 2023 | 1 Jan to 15 Jan | 16 Jan to 31 Jan | 1 Feb to 15 Feb | 16 Feb to 28 Feb (or 29 Feb Leap yr) | 1 March to 15 March | 16 Dec to 31 Dec 2023 | 1 Jan to 15 Jan2024
J Bairstow | 2023-01-17 00:00:00 | 2023-01-18 00:00:00
S Smith | 2023-01-12 00:00:00 | 2023-01-19 00:00:00
[NAME] | 2023-01-10 00:00:00 | 2023-03-03 00:00:00
A Border | 2023-02-15 00:00:00 | 2023-02-16 00:00:00
A Test | 2023-12-28 00:00:00 | 2024-01-07 00:00:00
Spreadsheet: 719310d1613613068-possible-indirect-function-needed-or-any-feasible-method-indirect-function-help
Sheet: Template

Period | Invoice Period | Name | Invoice No | SK AK No | Account Name | EXP | USD | Billed Amount local CCY | Billed USD
January | 2021-01-01 00:00:00 | Example | 46547-[PHONE] | 666457 | Example | NA | AUD
January | 2021-01-01 00:00:00 | Example | 46547-[PHONE] | 666458 | Example | NA | AUD
January | 2021-01-01 00:00:00 | Example | 46547-[PHONE] | 666459 | Example | NA | AUD
January | 2021-01-01 00:00:00 | Example | 46547-[PHONE] | 666460 | Example | NA | USD
January | 2021-01-01 00:00:00 | Example | 46547-[PHONE] | 767987 | Example | BA | USD
January | 2021-01-01 00:00:00 | Example | 46547-[PHONE] | 767988 | Example | BA | EUR
January | 2021-01-01 00:00:00 | Example | 46547-[PHONE] | 767989 | Example | BA | EUR
January | 2021-01-01 00:00:00 | Example | 46547-[PHONE] | 767990 | Example | BA | USD
January | 2021-01-01 00:00:00 | Example | 166465789-[PHONE] | 9765464 | Example | BA | DKK
January | 2021-01-01 00:00:00 | Example | 166465789-[PHONE] | 9765465 | Example | BA | DKK
January | 2021-01-01 00:00:00 | Example | 166465789-[PHONE] | 9765466 | Example | BA | USD
January | 2021-01-01 00:00:00 | Example | 166465789-[PHONE] | 9765467 | Example | BA | NOK
January | 2021-01-01 00:00:00 | Example | 166465789-[PHONE] | 9765468 | Example | BA | NOK
January | 2021-01-01 00:00:00 | Example | 166465789-[PHONE] | 232134164 | Example | NA | NOK
January | 2021-01-01 00:00:00 | Example | 166465789-[PHONE] | 232134165 | Example | NA | NOK
January | 2021-01-01 00:00:00 | Example | 166465789-[PHONE] | 232134166 | Example | NA | NOK
January | 2021-01-01 00:00:00 | Example | 98787-299467989 | 0046-997897654 | Example | NA | NOK
January | 2021-01-01 00:00:00 | Example | 98787-299467989 | 0046-997897655 | Example | NA | USD
January | 2021-01-01 00:00:00 | Example | 98787-299467989 | 0046-997897656 | Example | NA | EUR
January | 2021-01-01 00:00:00 | Example | 98787-299467989 | 0046-997897657 | Example | NA | EUR
January | 2021-01-01 00:00:00 | Example | 98787-299467989 | 0046-997897658 | Example | NA | EUR
January | 2021-01-01 00:00:00 | Example | 98787-299467989 | 0046-997897659 | Example | NA | EUR
January | 2021-01-01 00:00:00 | Example | [PHONE]-[PHONE] | 588000000 | Example | NA | USD
January | 2021-01-01 00:00:00 | Example | [PHONE]-[PHONE] | 588000001 | Example | NA | USD
January | 2021-01-01 00:00:00 | Example | [PHONE]-[PHONE] | 588000002 | Example | NA | USD
January | 2021-01-01 00:00:00 | Example | [PHONE]-[PHONE] | 588000003 | Example | NA | USD
January | 2021-01-01 00:00:00 | Example | 48-000046549 |  | Example | NA | EUR
January | 2021-01-01 00:00:00 | Example | 48-000047967 |  | Example | NA | EUR
January | 2021-01-01 00:00:00 | Example | 48-000046679 |  | Example | NA | EUR
Spreadsheet: 59795d1260347225-league-spreadsheet-vs3_league_spreadsheet_test
Sheet: Documentation

How to use this [NAME]
 | Make a backup copy before you start playing around
Start here: | Save the current copy often.
 | Some sheets are protected to avoid accidental overwriting of formulas
 | unprotect sheets to make changes and remember to protect them again.
 | Tools - Protection - Protect/Unprotect Sheet - no password
Setup Sheet | Enter team names, team numbers, pairing and handicap ratio
Teams sheet | set up blocks for each team.
 | create range name for team
 | enter team members
 | come back later to see results and changes in pecking order week by week
 | Data entry only for player names. Don't touch the rest.
[NAME] | set up roster with pairings per week. read additional notes in Schedule
 | for convenience sake, enter team numbers instead of names, much quicker to set up the roster
Scores sheet | Enter teams and team players for week 1
 | when starting out, overwrite existing data rather than delete all rows, to preserve the data entry list structure and range names.
 | use the drop down boxes for teams and players, if you like
 | Enter scores for week 1
Results Sheet | Add more sections to cover all pairings. Number the sections
 | Select week 1 and find out who gets points
 | Enter points in Scores sheet
 | This sheet is info only. No scores or points are entered.
Preview sheet | Add more sections to cover all pairings. Number the sections
 | select week 2 and see what's up next week
 | Take note of handicaps
 | this sheet is info only
This [NAME] contains the following named [NAME]:
Blue
green
orange
pairings
purple
red
ScheduleTable
ScheduleWeek
ScoreMember
ScorePoints
ScoreScore
ScoreTable
ScoreTeam
[NAME]
ScoreXs
SpotRate
[NAME]
Teamlist
Teams
yellow
Spreadsheet: 719346d1613643005-gratuity-mot-calculating-correctly-gratuity-calculation
Sheet: Sheet1

Name | Smith Thompson
ID
Designation | Fleet Officer
Department | Logistics |  | Salary
Cadre | Manager |  | Basic | 249375
Date of employment | 2006-12-18 00:00:00 |  | Housing | 99750
Date of disengagement | 2021-03-10 00:00:00 |  | Transport | 30000
Length of service |  |  | Others | 69834
Confirmation Status | Confirmed |  | Gross
Mode of disengagement | Resignation
Notice period required
Notice  given? | Yes
Terminal month salary paid | No |  | 5 years |  | Correct
Last anniversary leave taken | 2020-12-18 00:00:00 |  | 6years
Leave entitlement from last anniversary leave (days) |  |  | 7years
Number of days taken |  |  | 8years
Leave balance for the previous year | 9 |  | 9years
Number of days outstanding |  |  | 10years |  | Incorrect
Leave allowance paid? | To be prorated up to date of disengagement |  | 11years
 |  |  | 12years
 |  |  | 13years
Entitlements |  |  | 14years
Gratuity
[NAME] up to date of disengagement
Leave earned but not taken
Leave allowance earned but not taken
[NAME] in lieu of notice
Overtime earned but not paid
Shift allowance earned but not paid
Other entitlements |  | Specify
Total entitlement
Less:
[NAME] paid but not earned
Leave taken but not earned
Leave allowance taken but not earned
[NAME] in lieu of notice
Car loan balance
Cooperative loan balance
Unretired float
Surcharges
Others
Total deductions
Net entitlement
Spreadsheet: 839191d1691745176-delete-or-empty-rows-based-on-specific-chain-of-values-org-chart-example
Sheet: Tabelle1

[NAME] | Reports to | Layer
0_Thomas |  | 1
1_Karl | 0_Thomas | 2
2_Vincent | 0_Thomas | 2
3_Mary | 0_Thomas | 2
4_Anna | 0_Thomas | 2
5_Simone | 0_Thomas | 2
6_Patricia | 1_Karl | 3
7_Jennifer | 1_Karl | 3
8_Linda | 1_Karl | 3
9_Elizabeth | 1_Karl | 3
10_Barbara | 1_Karl | 3
11_Susan | 2_Vincent | 3
12_Jessica | 2_Vincent | 3
13_Sarah | 2_Vincent | 3
14_Karen | 3_Mary | 3
15_Lisa | 3_Mary | 3
16_Nancy | 3_Mary | 3
17_Betty | 3_Mary | 3
18_Sandra | 3_Mary | 3
19_Margaret | 4_Anna | 3
20_Ashley | 4_Anna | 3
21_Kimberly | 4_Anna | 3
22_Emily | 4_Anna | 3
23_Donna | 4_Anna | 3
24_Michelle | 4_Anna | 3
25_Carol | 5_Simone | 3
26_Amanda | 5_Simone | 3
27_Melissa | 5_Simone | 3
28_Deborah | 5_Simone | 3
29_Stephanie | 6_Patricia | 4
30_Dorothy | 6_Patricia | 4
31_Rebecca | 6_Patricia | 4
32_Sharon | 6_Patricia | 4
33_Laura | 7_Jennifer | 4
34_Cynthia | 7_Jennifer | 4
35_Amy | 7_Jennifer | 4
36_Gary | 7_Jennifer | 4
37_Nicholas | 7_Jennifer | 4
38_Eric | 7_Jennifer | 4
39_Jonathan | 16_Nancy | 4
40_Stephen | 16_Nancy | 4
41_Larry | 16_Nancy | 4
42_Justin | 16_Nancy | 4
43_Scott | 16_Nancy | 4
44_Brandon | 22_Emily | 5
45_Benjamin | 22_Emily | 5
46_Samuel | 22_Emily | 5
47_Gregory | 41_Larry | 5
48_Alexander | 41_Larry | 5
49_Patrick | 41_Larry | 5
50_Frank | 41_Larry | 5
Spreadsheet: 106531d1303812195-excel-2007-how-to-calculate-an-annual-reduction-rate-from-a-monthly-variable-annualcalc
Sheet: Sheet1

Annual Rate calculations | External |  | Internal
Monthly rate from above |  | 1
month 1
month 2
month 3
month 4
month 5
month 6
month 7
month 8
month 9
month 10
month 11
month 12
Annual Rate
Spreadsheet: 872084d1718439602-unable-to-place-sum-at-the-end-of-dynamically-filtered-data-test-185-aligw
Sheet: Salary

Name | Amount |  |  |  |  |  | Name | Asid
Asid | 21437 |  |  |  |  |  |  |  | 21437
Pradeep | 10010 |  |  |  |  |  |  |  | 10076
[NAME] | 22589 |  |  |  |  |  |  |  | 21247
Ajay | 12437 |  |  |  |  |  |  |  | 17065
Ravi | 16626 |  |  |  |  |  |  |  | 23027
[NAME] | 14859 |  |  |  |  |  |  |  | 24094
Vayu | 18354 |  |  |  |  |  |  |  | 10272
Asid | 10076 |  |  |  |  |  |  |  | 21670
Asid | 21247 |  |  |  |  |  |  |  | 13338
Asid | 17065 |  |  |  |  |  |  |  | 15831
Asid | 23027 |  |  |  |  |  |  | Total | 178057
Asid | 24094
Asid | 10272
Asid | 21670
Asid | 13338
Vayu | 21313
Naveen | 16958
Kashi | 17607
[NAME] | 17907
Vayu | 14026
Naveen | 15526
Kashi | 23717
Asid | 15831
Pradeep | 12149
[NAME] | 23232
Ravi | 14018
[NAME] | 14558
Vayu | 14064
Naveen | 11145
Kashi | 22844
[NAME] | 10894
Vayu | 20262
Naveen | 20309
Spreadsheet: 78230107-0b25-4760-8d42-a01d64a656b9
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
SRSV | Test | SRSV | Respiratory Syncytial Virus (RSV) Antibodies, IgG and IgM (Separate Determinations), Serum | Respiratory Syncytial Virus, IgG/M | Immunofluorescence | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.15 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | IgG: <1:10 IgM: <1:10 | Tuesday, Friday; 9 a.m. | Same day/1 day | 3 days | 2 | 86756 |  |  |  |  | Rochester
SRSV | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SRSV | Result | 5737 | Respiratory Syncytial Virus, IgG | Respiratory Syncytial Virus, IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9573-7 | Respiratory syncytial virus [NAME].IgG:Titr:Pt:Ser:Qn:IF
SRSV | Result | 5738 | Respiratory Syncytial Virus, IgM | Respiratory Syncytial Virus, IgM | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9574-5 | Respiratory syncytial virus Ab.IgM:Titr:Pt:Ser:Qn:IF