tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 747845d1631726236-counting-text-across-multiple-rows-and-columns-sample3-1-ans2
Sheet: Location C

 | Go to Summary
Floor | Room | DEPARTMENT | MONDAY AM | MONDAY PM | TUESDAY AM | TUESDAY PM | WEDNESDAY AM | WEDNESDAY PM | THURSDAY AM | THURSDAY PM | FRIDAY AM | FRIDAY PM
1 | 1 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 2 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 3 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 4 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 5 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 6 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 7 | INTERNAL MEDICINE | Test | Test |  |  | Test | Test | Test | Test | Test | Test
1 | 8 | INTERNAL MEDICINE | Test | Test |  |  | Test | Test | Test | Test | Test | Test
2 | 1 | PEDIATRICS |  |  | Test | Test | Test | Test | Test |  | Test | Test
2 | 2 | PEDIATRICS | Test | Test | Test | Test | Test |  | Test | Test | Test | Test
2 | 3 | PEDIATRICS | Test | Test |  |  |  |  |  | Test | Test | Test
2 | 4 | PEDIATRICS | Test | Test | Test |  | Test | Test | Test | Test | Test | Test
2 | 5 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 6 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 7 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 8 | PEDIATRICS | Test | Test | Test | Test | Test |  | Test | Test | Test | Test
2 | 9 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test |  | Test | Test
2 | 10 | PEDIATRICS | Test | Test | Test |  | Test | Test | Test | Test | Test | Test
2 | 11 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 12 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 13 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 14 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
Spreadsheet: 191213d1351971094-pivot-table-assistance-rag-pivot-1
Sheet: Pivot

 |  |  |  | Country | UK
 |  |  |  | Business Unit | TSA
 |  |  |  | Blue | Red | Amber | Green
 |  | c | Colour 1 | 3 | 1 | 2 | 3
 |  | d | [NAME] | 1 | 4 | 3 | 1
 |  | e | Colour 3 | 4 | 1 | 3 | 1
 |  | f | [NAME] | 1 | 5 | 3 | 0
 |  |  |  |  | Bue | Red | Amber | Green
 |  |  |  | Colour 1 | 3 | 1 | 2 | 3
 |  |  |  | [NAME] | 1 | 4 | 3 | 1
 |  |  |  | Colour 3 | 4 | 1 | 3 | 1
 |  |  |  | [NAME] | 1 | 5 | 3 | 0
Spreadsheet: 216217d1361643755-automatic-update-date-and-colum-c-test
Sheet: ADDDECREASE

DATE | SKU | PRIE CODE
 | T5G971 | 8
 | T5G971 | 8
 | GA100A-7A | 8
 | DW6900FS-8 | 8
 | DW6900CS-1 | 8
 | GA110HC-1ACR | 8
 | RLX1182 | 8
 | 1780947 | 8
 | 1790713 | 8
 | ADH2084 | 8
 | ADH4048 | 8
 | [NAME] | 8
 | ADH2779 | 8
 | ADH2737 | 8
 | T5G971 | 10
 | T5G971 | 10
 | GA100A-7A | 10
 | DW6900FS-8 | 10
 | DW6900CS-1 | 10
 | GA110HC-1ACR | 10
 | RLX1182 | 10
 | 1780947 | 10
 | 1790713 | 10
 | ADH2084 | 10
 | ADH4048 | 10
 | [NAME] | 10
 | ADH2779 | 10
 | ADH2737 | 10
Spreadsheet: 702208d1604164804-extract-specific-column-information-from-json-column-json-data-conversion
Sheet: Output

timestamp | source | level | message | source | event | claimId | BillId | chintextId | RuleId | RuleId
2012-10-28T09:35 | 8990 | [NAME] | eventrequest | [NAME] | HOLD | 2022 | 9872 | 55555 | 9999
2020-10-28T09:30:18.000Z | 34221 | info | eventrequest | ENET | CREATE-HOLD | 510892 | 19911 | 19005 | 78826 | 18395
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: Research1

 | Research
 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  |  |  | Per HC | New HC | Adj Comp |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  | Compensation | 0
 | Analysts & Associates | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services |  |  |  |  |  |  | Total |  |  |  |  | 1699109
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME]
ENARENT | Rent |  |  |  |  |  |  | Admins | 48000 | 0
ENATECH | Technology |  |  |  |  |  |  | Staff | 49200 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Analysts | 57600 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Associate | 72000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Specialist | 62400 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialst | 74400 | 1
 |  |  |  |  |  |  |  | Managers | 90000 | 1
 | Headcount |  |  | 44 |  |  |  | Directors | 120000 | 1
 |  |  |  |  |  |  |  | Sr Director | 178800 | 0
 | Analysts & Associate Headcount |  |  | 5 | 0 |  |  | Vice President | 216000 | 0
 |  |  |  |  |  |  |  | [NAME] | 312000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  | Total Misc Exp |  | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 102596d1300544256-vlookup-problem-for-employees-with-same-shift-example-of-pull-from-schedule
Sheet: goal sheet

2011-01-02 00:00:00 | <-enter date
[NAME] | 10-5
angie | 10-3
mark | 12-8
[NAME] | 12-8
robby | 3-8
 | [NAME] | filtered | sort order | Rank | no blanks |  | sorted times
[NAME]
[NAME]
[NAME]
Mark
[NAME]
robby
angie
becky
micky
[NAME]
 |  | shift | sort order |  |  |  |  | 1 | 10-7 |  | =VLOOKUP(ROW()-ROW($E$5),$B$6:$C$15,2,FALSE)
 |  | 9-11 | 1 |  |  |  |  | 2 | 10-4 |  | 10-6
 |  | 9-6 | 2 |  |  |  |  | 3 | 10-3
 |  | 9-5 | 3 |  |  |  |  | 4 | 11-7
 |  | 9-4 | 4 |  |  |  |  | 5 | Paris Hilton |  | 1030-630
 |  | 9-11/2-8 | 5 |  |  |  |  | 6 | Ratan Tata |  | 1030-330
 |  | 9-11/3-8 | 6 |  |  |  |  | 7 | [NAME]
 |  | 10-7 | 7 |  |  |  |  | 8 | [NAME]
 |  | 10-6 | 8 |  |  |  |  | 9 | [NAME]
 |  | 10-5 | 9 |  |  |  |  | 10 | [NAME]
 |  | 10-4 | 10
 |  | 10-3 | 11
 |  | 1030-630 | 12
 |  | 1030-530 | 13
 |  | 1030-430 | 14
 |  | 1030-330 | 15
 |  | 11-7 | 16
 |  | 11-6 | 17
 |  | 11-5 | 18
 |  | 11-4 | 19
 |  | 11-3 | 20
 |  | 12-8 | 21
 |  | 12-7 | 22
 |  | 12-6 | 23
 |  | 12-5 | 24
 |  | 12-4 | 25
 |  | 1-8 | 26
 |  | 1-7 | 27
 |  | 1-6 | 28
 |  | 1-5 | 29
 |  | 1-10 | 30
 |  | 2-8 | 31
 |  | 2-7 | 32
 |  | 2-6 | 33
 |  | 2-11 | 34
 |  | 3-8 | 35
 |  | 3-9 | 36
 |  | 3-10 | 37
 |  | 3-11 | 38
 |  | 3-12 | 39
Spreadsheet: 166570d1341644401-formula-needed-part-2-part-2
Sheet: Sheet2

Month | Cases - Name | Projected visits | Frequency | Results | Last Name | Actual visits
2012-04-01 00:00:00 | Adams | 2012-03-06 00:00:00 | Monthly |  | Agard | 2012-03-06 00:00:00
2012-04-01 00:00:00 | Agard | 2012-03-06 00:00:00 | Quarterly | Met as Projected | [NAME] | 2012-11-01 00:00:00
2012-04-01 00:00:00 | [NAME] | 2012-04-04 00:00:00 | PRN | Met as Projected | [NAME] | 2012-03-06 00:00:00
2012-04-01 00:00:00 | [NAME] | 2012-03-06 00:00:00 | Monthly |  | [NAME] | 2012-04-24 00:00:00
2012-04-01 00:00:00 | Canty | 2012-04-25 00:00:00 | Monthly | Met as Projected | Ayers | 2011-12-12 00:00:00
2012-04-01 00:00:00 | [NAME] | 2012-03-14 00:00:00 | Quarterly |  | Byron | 2012-03-12 00:00:00
 |  |  |  |  | Canty | 2012-03-15 00:00:00
 |  |  |  |  | Canty | 2012-04-25 00:00:00
 |  |  |  |  | Canty | 2012-04-26 00:00:00
 |  |  |  |  | Casteel | 2012-04-01 00:00:00
 |  |  |  |  | [NAME] | 2012-03-12 00:00:00
 |  |  |  |  | Garrett | 2012-03-12 00:00:00
 |  |  |  |  | Jones | 2012-04-02 00:00:00
 |  |  |  |  | Renolds | 2012-03-29 00:00:00
Spreadsheet: 757426d1638260897-formula-required-to-calculate-monthly-totals-from-a-list-estimated-v-actual-2022
Sheet: Sheet1

COMPANY ID | COMPANY | LOANS | DATE |  |  | COMPANY ID | COMPANY | TURNOVER | ESTIMATED | 2022-01-01 00:00:00 | ESTIMATED | 2022-02-01 00:00:00 | ESTIMATED | 2022-03-01 00:00:00
123 | ABC WINDOWS | 1000 | 2022-01-01 00:00:00 |  |  | 123 | ABC WINDOWS | 20000 | 3000 |  | 3000 |  | 3000
456 | DEF WINDOWS | 2000 | 2022-01-01 00:00:00 |  |  | 456 | DEF WINDOWS | 30000 | 2000 |  | 2000 |  | 2000
789 | GHI WINDOWS | 3000 | 2022-01-01 00:00:00 |  |  | 789 | GHI WINDOWS | 40000 | 1000 |  | 1000 |  | 1000
123 | ABC WINDOWS | 4000 | 2022-02-01 00:00:00
456 | DEF WINDOWS | 5000 | 2022-02-01 00:00:00
789 | GHI WINDOWS | 6000 | 2022-02-01 00:00:00
123 | ABC WINDOWS | 7000 | 2022-03-01 00:00:00
456 | DEF WINDOWS | 8000 | 2022-03-01 00:00:00
789 | GHI WINDOWS | 9000 | 2022-03-01 00:00:00
Spreadsheet: 762134d1641404746-help-with-formula-power-query-to-get-the-number-of-matching-row-counts-of-codes-sample-excel-3
Sheet: Input

ctextid | vbillid | agentcode | predictcode
4512 | 231 | A202,A203 | A314,A202
7678 | 235 | A415,A203 | A415,A203
7781 | 213 | D123,E124,F341 | D123,E124
8123 | 214 | D123, F341,A203 | F341
Spreadsheet: 884611d1733840749-need-help-comparing-data-from-inpatient-and-outpatient-pharmacy-excel-files-discharge-list
Sheet: Sheet1

MR# | DATE | COMMENT
10209260 | 02/11/2024
20067955 | 02/11/2024
50082193 | 02/11/2024
10272113 | 02/11/2024
40022139 | 02/11/2024
20298508 | 02/11/2024
60172018 | 03/11/2024
50168369 | 03/11/2024
10282592 | 03/11/2024
50007311 | 04/11/2024
10294108 | 05/11/2024
30054719 | 05/11/2024
40001402 | 06/11/2024
10293525 | 06/11/2024
10286622 | 06/11/2024
50254659 | 07/11/2024
10296645 | 07/11/2024
10295312 | 07/11/2024
20094742 | 07/11/2024
20002201 | 09/11/2024
40017067 | 09/11/2024
50023243 | 09/11/2024
10023862 | 09/11/2024
10150789 | 09/11/2024
20361876 | 10/11/2024
50168369 | 10/11/2024
60182723 | 10/11/2024
30054719 | 11/11/2024
10209260 | 11/11/2024
80033236 | 11/11/2024
10245853 | 11/11/2024
20210786 | 12/11/2024
10252042 | 12/11/2024
20063760 | 13/11/2024
10241897 | 13/11/2024
20308857 | 13/11/2024
20094742 | 13/11/2024
20051091 | 14/11/2024
40053559 | 14/11/2024
10300481 | 14/11/2024
10191046 | 14/11/2024
10095564 | 14/11/2024
10294705 | 14/11/2024
40022139 | 16/11/2024
20299570 | 16/11/2024
10286109 | 16/11/2024
10117553 | 16/11/2024
20008943 | 16/11/2024
10241897 | 16/11/2024
20063760 | 17/11/2024
10291233 | 17/11/2024
50007311 | 17/11/2024
10301198 | 17/11/2024
20317741 | 17/11/2024
60185105 | 17/11/2024
10268216 | 19/11/2024
20056192 | 19/11/2024
10005926 | 20/11/2024
10076085 | 21/11/2024
20035496 | 21/11/2024
10300319 | 21/11/2024
10016733 | 21/11/2024
40022139 | 23/11/2024
50082193 | 23/11/2024
20067955 | 23/11/2024
10241897 | 23/11/2024
20298508 | 23/11/2024
10282592 | 24/11/2024
50168369 | 24/11/2024
10301198 | 24/11/2024
10234736 | 25/11/2024
20051091 | 27/11/2024
10293525 | 27/11/2024
50039606 | 27/11/2024
10064982 | 28/11/2024
20051091 | 28/11/2024
10300481 | 28/11/2024
40009388 | 28/11/2024
10295312 | 28/11/2024
10296645 | 28/11/2024
10191046 | 28/11/2024
10016733 | 28/11/2024
10286622 | 30/11/2024
10272113 | 30/11/2024
Spreadsheet: darrell_schoolcraft__7776__imbalsumm0106
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 372408 | 395000 | 54996 | 51737 | 77854 | 40670 | 76796 | 95022
2 | 371402 | 400000 | 51789 | 50166 | 82226 | 75758 | 63005 | 67484
3 | 374673 | 377553 | 45902 | 49510 | 79928 | 75857 | 63323 | 63651
4 | 391192 | 400000 | 74587 | 76673 | 73280 | 73080 | 120589 | 107762
5 | 383957 | 398502 | 56653 | 51016 | 75484 | 70290 | 93011 | 84699
6 | 359161 | 377237 | 37186 | 32959 | 76331 | 75340 | 67920 | 61227
7 | 356082 | 400000 | 72481 | 70868 | 80602 | 85687 | 73891 | 74915
8 | 347490 | 341205 | 80045 | 69316 | 80506 | 77451 | 95309 | 96346
9 | 227021 | 218582 | 41724 | 47018 | 69337 | 58706 | 55471 | 57915
10 | 206977 | 218582 | 57075 | 47018 | 62471 | 58706 | 60760 | 57915
11 | 247615 | 260374 | 44330 | 39034 | 72487 | 79683 | 53273 | 47378
12 | 314990 | 315860 | 55833 | 54940 | 75985 | 74409 | 97302 | 96007
13 | 324658 | 318495 | 39927 | 48780 | 69879 | 66897 | 82453 | 76080
14 | 297028 | 295559 | 46805 | 52236 | 74314 | 65706 | 82731 | 82045
15 | 314898 | 332451 | 54801 | 46979 | 66415 | 62129 | 97837 | 88364
16 | 304910 | 333503 | 64885 | 47967 | 63434 | 60662 | 79061 | 68700
17 | 302926 | 334832 | 69533 | 44264 | 66099 | 61813 | 77275 | 66857
18 | 317994 | 331948 | 54897 | 54895 | 63349 | 62127 | 77264 | 66556
19 | 332220 | 323242 | 55852 | 51857 | 59277 | 62085 | 71415 | 75600
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  |  |  |  |  |  |  | 278779
2001-06-19 00:00:00
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
Spreadsheet: 672153d1586773247-extract-parentheses-or-extract-word-without-parentheses-and-check-two-ip-subnet-ranges-sample
Sheet: Sheet1

Attacker Description | Attacker info- | Host name
10.169.21.37
Multiple (82)
10.179.14.60
::1 (EXECUTIONSCHEDU)
10.179.5.171 (Teslaable-dms-ns)
10.179.6.152 (DMX-D42WDS.org.gov.local)
10.161.0.13
10.179.6.152 (DMX-D42WDS.org.gov.local)
10.169.3.122 (RPG-DC3-A1P-E5W32)
10.179.26.103
10.179.26.103
10.179.26.250
10.179.27.33
10.179.14.60
10.169.2.166 (RPG-ADC-AP-NJ211)
10.161.3.225 (10.161.3.225)
::1 (EXECUTIONSCHEDU1)
10.179.6.152 (DMX-D42WDS.moj.gov.local)
10.179.26.164
10.179.14.60
10.179.27.7
10.169.21.37
10.179.26.111
10.179.26.164
10.179.26.211
10.179.26.120
10.179.26.69 (Fortinet VPN)
10.179.26.43
10.179.26.189
Multiple (2)
10.179.26.31
Spreadsheet: 600697d1543916857-auto-populate-35-wbs-cost-reports-test-formula
Sheet: Sheet1

 | Period end |  | Test Report
 |  |  | [NAME] TEXT
 |  |  | Budget |  |  |  |  | Month & Cumulative Cost
 |  |  | Original Budget | Variations |  | Current Approved Budget |  | Expended |  | Contract Expended |  | Commitments |  |  | Accruals | VOWD |  |  |  |  |  |  |  |  |  | Budget vs actual variance |  | Budgeted Cost |  | Current Cost |  | Invoiced to date re Orig Plan
 | Cost Description |  |  | Pending | Approved |  |  | Period | Cumulative | Period | Cumulative | Committed | Remaining | Total |  | Period | Cumulative |  | Remaining | Final Forecast | [NAME] |  | %age | CPI
 | SCOPE TEXT A
 | Figures
 | Main
 | Test
 | Queries
 | SCOPE TEXT A Total
 | SCOPE TEXT B
 | Test 1
 | Test 2
 | Test 3
 | Test 4
 | Test 5
 | Test 6
 | Rail
 | Overrail
 | Underrail
 | Systems
 | Support
 | Transfer
 | Unit
 | SCOPE TEXT B Total
 | SCOPE TEXT C
 | Test 1
 | Test 2
 | Test 3
 | Test 4
 | Test 5
 | Test 6
 | Rail
 | Overrail
 | Underrail
 | Systems
 | Support
 | Transfer
 | Unit
 | SCOPE TEXT C Total
 | SCOPE TEXT D
 | Test 1
 | Test 2
 | Test 3
 | Test 4
 | Test 5
 | Test 6
 | Rail
 | Overrail
 | Underrail
 | Systems
 | Support
 | Transfer
 | Unit
 | SCOPE TEXT D TotAL
 | OVERALL WBS  TOTAL
Spreadsheet: 624744d1558048733-help-calendar-correction-employee-absence-schedule-current
Sheet: Employee Names

 | Employee Names
 | Employee Names |  |  | I need all of these names to show up on the names list Jan-December
 | [NAME] |  |  | Based on what you've shared, you need to insert the names on others sheets.
 | Lynda |  |  | Do you believe that will address your problem?
 | [NAME] |  |  | I'm going to do this. This should take me 20 minutes.
 | Heather |  |  | I already have done it for January. I will do it for others months.
 | [NAME] |  |  | I have already finished.
 | Emili |  |  | Does this solution solve your problem?
 | Amber |  |  | Do you have any other questions about this problem and the solution?
 | Meredith |  |  | Thanks for coming to Excelchat. Feel free to leave any comments or feedback. Have a nice day.
 | Julie |  |  | You have been a game changer!!  Thank you immensely for your help and have a wonderful evening!
Spreadsheet: 715725d1611844098-replace-a-formula-to-find-multiple-partial-text-string-and-list-all-book1
Sheet: Sheet1

 |  |  |  |  |  | =IFERROR(LOOKUP(2,1/SEARCH(SUBSTITUTE(I5,"""",""),D$5:D$87),B$5:B$87),"")
 |  |  | Data comes in like this-: |  |  |  | [NAME] I have works fine for single instances
 | 2020-12-02 00:00:00 | D/D | 'NPOWER | -5 |  |  |  | HALFORDS
 | 2020-12-02 00:00:00 | D/D | BA GROUP LTD | -52.93 |  |  |  | 'NPOWER
 | 2020-12-02 00:00:00 | POS | 573 01DEC20 C , HALFORDS 079 , SH GB | -11.9 |  |  |  | ANIMAL HEALTHCARE
 | 2020-12-02 00:00:00 | POS | 573 01DEC20 C , STARBUCKS , SH GB | -6.12
 | 2020-12-03 00:00:00 | POS | 573 02DEC20 C , NEW GREAT WALL , SH GB | -32.6
 | 2020-12-04 00:00:00 | POS | 573 02DEC20 , AMZN DIGITA , L*MY6Y4 , 35661 LU | -3.29 |  |  | Final result would look like this
 | 2020-12-05 00:00:00 | D/D | 573 04DEC20 , ANIMAL HEALTHCARE | -13 |  |  |  | ANIMAL HEALTHCARE
 | 2020-12-17 00:00:00 | D/D | 573 16DEC20 , ANIMAL HEALTHCARE | -17
 | 2020-12-21 00:00:00 | POS | 573 06DEC20 , SAINSBURY S , SH GB | -48
 |  |  |  |  |  |  | fprmula puuled down over 3 rows
Spreadsheet: 881773d1729942065-dates-to-be-worked-by-an-employee-per-month-dates-listing02
Sheet: Sheet1

[NAME] for the Period:  October 2024
Pay Date | 2024-10-31 00:00:00
Date | employee name
 | Time In | Time Out | Hours | Holidays
2024-10-01 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-02 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-03 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-04 00:00:00
2024-10-05 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-06 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-07 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-08 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-09 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-10 00:00:00
2024-10-11 00:00:00
2024-10-12 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-13 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-14 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-15 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-16 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-17 00:00:00
2024-10-18 00:00:00
2024-10-19 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-20 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-21 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-22 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-23 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-24 00:00:00
2024-10-25 00:00:00
2024-10-26 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-27 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-28 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-29 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-30 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-31 00:00:00 | 07:00:00 | 17:00:00 | 9.99999999999998
Spreadsheet: 759162d1639386191-try-create-price-offer-table-ceny
Sheet: Hárok1

Cenová ponuka
Dodávateľ: |  |  |  | [NAME]:
RVMBAU s.r.o. |  |  |  | INGSOL s.r.o.
[NAME], 913 11
IČO: 53 303 163
DIČ: [PHONE]
Projekt: RD15 - Kompletáž
Č.P. | [NAME] | M.j. | Počet | Price | Cena M.j.2 | Cena | Cena3 | Cena4
 |  |  |  |  | Montáž | [NAME] | Montáž | Spolu
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
32
33
Spreadsheet: 4a271d34-3c36-44ea-8036-f2bd492245b3
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
SPN | Test | SPN | Pneumocystis Smear | Pneumocystis smear | Calcofluor White Fluorochrome Stain | [NAME], sterile centrifuge tubes: ScwStlTb |  |  |  | Varies | Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen.  [NAME] source is required.   Submit only 1 of the following specimens:   Preferred: [NAME]: Bronchoalveolar lavage Container/Tube: Sterile container [NAME] Minimum of 2 mL   Specimen Type: Lung or open lung tissue Container/Tube: Sterile container [NAME] Minimum of a rice size piece Collection Instructions: Tissue should be placed in small amount of sterile saline or sterile water.   Alternate: [NAME]: Bronchial washing, sputum, or tracheal secretion Container/Tube: Sterile container	 [NAME] Minimum of 1 mL | Varies*  Brochoalveolar lavage: | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Fixed tissue; viral transport media (including but not limited to M4, M5, BD viral transport media, thioglycolate broth); wood shaft or charcoal swab | Negative | Monday through Sunday; Continuously | 1 day | 1 day | 1 | 87206 |  |  |  |  | Rochester
SPN | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
SPN | Order Question | Q00M0054 | [NAME] |  | Plain Text
SPN | Result | SPN | Pneumocystis smear | Pneumocystis smear | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48055-8 | Pneumocystis jiroveci:ACnc:Pt:[NAME]:[NAME]:Calcoflour white preparation
Spreadsheet: 121555d1316148426-alternative-to-if-and-concencate-to-return-a-date-as-month-and-year-book1
Sheet: DATA

Date | Source | Type | Unit | Subject | DP | AB | Report | Month
2010-12-02 00:00:00 | Other | Phone | Unit1 | Information | N/A | CSE | N/A | DEC 2010
2010-12-09 00:00:00 | Other | [NAME] | Unit1 | Other | N/A | N/A | N/A | 12 2010 |  | Source | Type | Unit | Subject | DP | AB | Report
2010-12-18 00:00:00 | Command | Phone | Unit3 | Other | Pre | CSE | CPS | 2010-12-18 00:00:00 |  | Command | [NAME] | Unit1 | Information | N/A | N/A | N/A
2011-05-15 00:00:00 | Subordinate | Phone | Unit2 | New | N/A | CSE | CPS | 5-2011 |  | Person | Phone | Unit2 | Finance | Late | CSE | CPS
2011-05-26 00:00:00 | Subordinate | Phone | Unit4 | Finance | Post | N/A | LTG | 2011-05-26 00:00:00 |  | Subordinate | Letter | Unit3 | Unknown | Mid | EX | CPD
2011-05-31 00:00:00 | Command | Letter | Unit7 | Finance | Mid | EX | N/A |  |  | Other |  | Unit4 | Other | Post | MW | LTG
2012-03-03 00:00:00 | Person | Phone | Unit8 | Unknown | N/A | Other | Other |  |  |  |  | Unit5 | New | Pre | Other | Other
2012-07-06 00:00:00 | Person | [NAME] | Unit8 | Other | Late | N/A | N/A |  |  |  |  | Unit6
2012-07-14 00:00:00 | Other | [NAME] | Unit5 | New | Late | MW | LTG |  |  |  |  | Unit7
2012-07-17 00:00:00 | Other | [NAME] | Unit5 | New | N/A | N/A | N/A |  |  |  |  | Unit8
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Unit10
Spreadsheet: 96565d1295952991-dependent-list-from-one-column-sample
Sheet: Qs

 | CURRENT LIST |  |  |  |  |  | NEW LIST
 | MAIN QUEUE | Queue A | [NAME] | [NAME] |  |  | MAIN QUEUE | Queue
 | Queue | A1 | B1 | C1 |  |  | Queue A | A1
 |  | A2 | B2 | C2 |  |  | Queue A | A2
 |  | A3 | B3 | [NAME] |  |  | Queue A | A3
 |  | A4 | B4 | C4 |  |  | Queue A | A4
 |  | A5 | B5 | C5 |  |  | Queue A | A5
 |  |  |  |  |  |  | [NAME] | B1
 |  |  |  |  |  |  | [NAME] | B2
 |  |  |  |  |  |  | [NAME] | B3
 |  |  |  |  |  |  | [NAME] | B4
 |  |  |  |  |  |  | [NAME] | B5
 |  |  |  |  |  |  | [NAME] | C1
 |  |  |  |  |  |  | [NAME] | C2
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | [NAME] | C4
 |  |  |  |  |  |  | [NAME] | C5