tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 853400d1703260728-formula-for-pro-rating-given-values-pto-calculator
Sheet: Employee PTO Load

Name | Anniversary Date | 2024 PTO
[NAME] | 2014-04-20 00:00:00
[NAME] | 2014-10-31 00:00:00
Name | Anniversary Date | Old Entitlement | New Entitlement | 2024 Calculation | EXPECTED  Calculation
[NAME] | 2014-04-20 00:00:00 | 26 | 31
[NAME] | 2014-10-31 00:00:00 | 26 | 31
MANUAL CALCULATION
PARAMETERS
<3 years | 16 Days
3-5 years | 21 Days
5-10 years | 26 Days
10+ years | 31 Days
1. Time must be used in 0.5 increments, and is always rounded DOWN
2. An employee accrues time MONTHLY
For example, if an employee has a start date of April 14th, 2014 - he will not have any accrual for April.
For employees who are terminated, if they leave mid-month, they do not accrue time for the current month.
Spreadsheet: 733699d1621738167-auto-date-and-value-rotation-demo
Sheet: Sheet1

CHAPTER ALLOCATION LIST |  |  | CHAPTER ALLOCATION LIST
Date: | 2021-05-23 00:00:00 |  | Date:
ROLL NO | CHAPTER NO |  | ROLL NO | CHAPTER NO
1 | 1 , 2_x000D_ |  | 1
2 | 3, 4_x000D_ |  | 2
3 | 5, 6 |  | 3
4 | 7, 8 |  | 4
5 | 9, 10 |  | 5
6 | 11, 12 |  | 6
7 | 13, 14 |  | 7
8 | 15, 16-17 |  | 8
9 | 18-19, 20 |  | 9
10 | 21, 22 |  | 10
11 | 23, 24 |  | 11
12 | 25, 26 |  | 12
13 | 27, 28 |  | 13
14 | 29, 30 |  | 14
15 | 31, 32 |  | 15
16 | 33, 34 |  | 16
17 | 35, 36 |  | 17
18 | 37, 38 |  | 18
19 | 39, 40 |  | 19
20 | 41, 42 |  | 20
21 | 43- 44, 45_x000D_ |  | 21
22 | 46, 47_x000D_ |  | 22
23 | 48, 49_x000D_ |  | 23
24 | 50, 51(Epilogue) |  | 24
Spreadsheet: 142920d1330091116-excel-2010-if-statement-to-pull-through-start-and-end-dates-of-a-project-copy-of-test
Sheet: Project Scheduling

 |  |  |  | 2012
BUILDING NO | BUILDING | PROJECT | Type | 2012-01-31 00:00:00 | 2012-02-29 00:00:00 | 2012-03-31 00:00:00 | 2012-04-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-30 00:00:00 | 2012-07-31 00:00:00 | 2012-08-31 00:00:00 | 2012-09-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-30 00:00:00 | 2012-12-31 00:00:00
1 | House
 |  | Project 1 | Electrical
 |  | Project 2
 |  | Project 3
 |  | Project 4
 |  | Project 5
 |  | Project 6
 |  | Project 7
Spreadsheet: 00a2d861-ec16-49fd-8f94-f639d2e6fe06
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
 | 8501.0 Retail Trade, Australia
 | TABLE 16. Retail Turnover, Completely Enumerated sector: Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Turnover ;  Total CE and [NAME] ; |  |  | Original | [NAME] | 1994-04-01 00:00:00 | 2011-06-01 00:00:00 | 207 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ; |  |  | Seasonally Adjusted | A3350334L | 1994-04-01 00:00:00 | 2011-06-01 00:00:00 | 207 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ; |  |  | Trend | A3350340J | 1994-04-01 00:00:00 | 2011-06-01 00:00:00 | 207 | $ Millions | FLOW | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Original | A3350329V | 1994-04-01 00:00:00 | 2011-06-01 00:00:00 | 207 | Percent | PERCENT | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Seasonally Adjusted | A3350335R | 1994-04-01 00:00:00 | 2011-06-01 00:00:00 | 207 | Percent | PERCENT | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Trend | A3350341K | 1994-04-01 00:00:00 | 2011-06-01 00:00:00 | 207 | Percent | PERCENT | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: darrell_schoolcraft__7608__imball0201
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 159260 | 160824
78311 | 48180 | 34200 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 148198 | 173332 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 191824 | 143548
500293 | 95279 | 94670
500302 |  | 1380
500303 |  | 40807
500305 | 253754 | 244698
500307 | 18290 | 10640
500313 |  | 505
500314
500655 | 36126
500657 | 28965 | 34988
INDEX
2001-12-31 00:00:00 |  |  | 68958.7
2002-01-05 00:00:00
CBS Volume
 |  |  | 44250
Spreadsheet: 695725d1600363693-sum-function-based-on-2-criteria-sample-file
Sheet: Sheet1

 | Fruits name | Category | Price R1 | Price R2 | Price R3 | Price R4 | Price R5
 | Orange | R1 | 45 | 34 | 34 | 57 | 56
 | Orange | R2 | 6 | 55 | 66 | 89 | 34
 | Orange | R3 | 44 | 66 | 77 | 87 | 34
 | Orange | R4 | 23 | 23 | 45 | 34 | 35
 | Orange | R5 | 45 | 33 | 35 | 33 | 45
 | Apple | R3 | 4 | 5 | 6 | 6 | 55
 | Apple | R5 | 23 | 33 | 44 | 55 | 5 |  |  |  |  | Price
 |  |  |  |  |  |  |  |  |  | My Result should be | Orange
 |  |  |  |  |  |  |  |  |  |  | Apple
Spreadsheet: 466106d1466008079-how-to-filter-and-average-data-by-classes-food-example
Sheet: Sheet1

 | Category | Item | Level_Sun01 | Level_sun02 | Level_moon01 | Level_Moon02 | LevelMoon2 | [NAME] | Levels_Mars02
 | Food | Breads | 90 | 31 | 34 | 74 | 38 | 31 | 53 |  |  | [NAME] | Level Moon | Level Mars
 | Food | Meat | 89 | 82 | 93 | 14 | 67 | 97 | 14 |  | Average % Food
 | Food | Dumplings | 65 | 89 | 34 | 33 | 81 | 43 | 14 |  | Average % Drink
 | Food | Pizza | 31 | 86 | 59 | 49 | 93 | 89 | 28 |  | Average % Snack
 | Food | Burger | 20 | 40 | 61 | 21 | 44 | 48 | 68
 | Drink | Coke | 46 | 15 | 24 | 19 | 35 | 97 | 7
 | Drink | Milk | 40 | 43 | 72 | 61 | 3 | 70 | 80
 | Drink | Water | 74 | 55 | 68 | 27 | 31 | 78 | 29
 | Drink | Beer | 77 | 50 | 49 | 97 | 78 | 34 | 53
 | Drink | Soda | 53 | 48 | 88 | 60 | 55 | 65 | 5
 | Snack | Candy | 33 | 86 | 38 | 46 | 100 | 44 | 90
 | Snack | Fruit | 70 | 77 | 26 | 81 | 3 | 43 | 78
 | Snack | Gum | 5 | 36 | 66 | 70 | 55 | 26 | 41
Spreadsheet: 810971d1672213631-sorting-data-at-the-bottom-sorting2
Sheet: Sheet2

Custodian | ISIN | Rating |  |  | Custodian | ISIN | Rating |  |  | Custodian | ISIN | Rating
BOV | [NAME] | A |  |  | BOV | [NAME] | A |  |  | BOV | [NAME] | A
BOV | Cash | A+ |  |  | APS | FA123 | A |  |  | APS | FA123 | A
BOV | Cash | B- |  |  | APS | [NAME] | A |  |  | APS | [NAME] | A
APS | FA123 | A |  |  | APS | QA888 | AA+ |  |  | APS | QA888 | AA+
APS | [NAME] | A |  |  | APS | [NAME] | BB+ |  |  | APS | [NAME] | BB+
APS | QA888 | AA+ |  |  | Lombard | PA123 | A+ |  |  | Lombard | PA123 | A+
APS | [NAME] | BB+ |  |  | Lombard | QW741 | BB |  |  | Lombard | QW741 | BB
Lombard | PA123 | A+ |  |  | BOV | Cash | A+
Lombard | QW741 | BB |  |  | BOV | Cash | B-
 |  |  |  |  |  |  |  |  |  | BOV | Cash | A+
 |  |  |  |  |  |  |  |  |  | BOV | Cash | B-
Spreadsheet: 91191d1290950511-finalize-to-my-stock-report-stock-balance-record
Sheet: 01

 | Stock Balance Record
 |  |  |  | ITEM | Table lamp
 |  |  |  | ITEM # | 01
 |  |  |  | UNITS
 |  |  |  | [NAME] |  | SECTION
 |  |  |  | EXPEDITE |  | REORDER
 |  |  |  |  |  | CURRENT BALANCE | 425
 |  |  |  |  |  | USED
 | DATE | REFERENCE | ISSUED | REC'D | ON ORDER | TO DATE | BALANCE
 |  |  |  |  |  | OPENING BALANCE | 400
 | 25.11.10 | Table lamp | 50 | 75 |  | 425 | 425
Spreadsheet: 88314d1288179747-multi-lookup-multi-lookup
Sheet: Summary

CURRENTLY: |  |  |  |  |  |  |  |  | WANT:
Date | 3 |  |  |  |  |  |  |  | Date From: | 2 |  | Date To: | 5
Total run time |  |  |  |  |  |  |  |  | Total run time
Break downs |  |  |  |  |  |  |  |  | Break downs
Actual run time |  |  |  |  |  |  |  |  | Actual run time
Output |  |  |  |  |  |  |  |  | Output
Spreadsheet: 76708d1277220996-if-then-formula-date_45
Sheet: MINE

All Accounts
BR | Customer Name | Starting Balance | File Date | Surety Co. | Total Paid | Actual Pmt Current Month | Projected Pmt Current Month | Promise to Pay | Remaining Balance | Savings | Potential Savings | Action
302 | Customer 1 | 16846.27 | 2010-02-21 00:00:00 | Surety 1 | 4000 | 0 | 8000 | 16846.27 | 12846.27 | 720 | 3032.3286 | no
302 | Customer 2 | 10084.81 | 2010-03-01 00:00:00 | Surety 2 | 10084.81 | 0 | 0 | 10084.81 | 0 | 1815.2658 | 1815.2658 | no
53 | Customer 3 | 7825.69 | 2010-03-21 00:00:00 | Surety 3 | 0 | 0 | 0 |  | 7825.69 | 0 | 0 | no
229 | Customer 4 | 6477.55 | 2010-04-01 00:00:00 | Surety 4 | 2500 | 0 | 0 | 6477.55 | 3977.55 | 450 | 1165.959 | no
188 | Customer 5 | 9608 | 2010-04-21 00:00:00 | Surety 5 | 0 | 0 | 1500 | 9608 | 9608 | 0 | 1729.44 | no
236 | Customer 6 | 11321.87 | 2010-05-01 00:00:00 | Surety 6 | 0 | 0 | 0 |  | 11321.87 | 0 | 0 | no
161 | Customer 7 | 13376.37 | 2010-05-21 00:00:00 | Surety 7 | 1210 | 0 | 2421.39 | 13376.37 | 12166.37 | 217.8 | 2407.7466 | no
75 | Customer 8 | 5653.62 | 2010-06-01 00:00:00 | Surety 8 | 2500 | 2500 | 5653.62 | 5653.62 | 3153.62 | 450 | 1017.6516 | no
62 | Customer 9 | 6969.87 | 2010-06-21 00:00:00 | Surety 9 | 0 | 0 | 0 |  | 6969.87 | 0 | 0 | no
Spreadsheet: 154153d1336247460-isnumber-and-isblank-book1
Sheet: Sheet1

 | list |  |  |  | list
 | 1 |  |  |  | a1
 | 2 |  |  |  | a2
 | 3 |  |  |  | a3
 | 4 |  |  |  | a4
 | 5 |  |  |  | a5
 | 6 |  |  |  | a6
 | list |  |  |  |  |  | answer
 | a
 | b
 | c
 | d
 | e
 | f
Spreadsheet: 757680d1638393976-conditional-formatting-rules-manager-locking-workbook-cf-error-example
Sheet: Options

Client
4th Utility
Aberdeen PM
AllCall
Amana Lettings
Bailey and Staples
[NAME]
Cavendish Peaks
Clixels
[NAME]
[NAME]
Fortis Group
[NAME]
[NAME]
[NAME]
HMG
[NAME]
Knoll Court
Kove Estates
Lennon Properties
[NAME]
[NAME]
My Property Club
Park PM
[NAME]
PropCall Limited
SnugPads
[NAME]
Student Cribs
[NAME]
Viva Training
[NAME]
Whites Northampton
Xenia Estates
Xenia Lettings
Your Home Managed
Spreadsheet: 69671d1270225831-counting-numbers-if-certains-cells-have-txt-counting-numbers
Sheet: Sheet1

6 | V
1 | P
1
1 | S
1
1
1
1
1
1
1
1
Regular | Vacation | Sick | Personal | etc…..
9 | 6 | 1 | 1
Spreadsheet: 268660d1380727017-sum-last-years-year-to-date-performance-as-we-enter-this-years-performance-tracker-example
Sheet: Sheet1

Week | 2013 | 2014
Wk1 | 139 | 155
Wk2 | 168 | 202
Wk3 | 95 | 101
Wk4 | 127 | 121
Wk5 | 136 | 0
Wk6 | 128 | 0
Wk7 | 127 | 0
Wk8 | 137 | 0
Wk9 | 373 | 0
Wk10 | 1393 | 0
Wk11 | 4152 | 0
Wk12 | 658 | 0
Wk13 | 895 | 0
FULL YEAR
YTD
Spreadsheet: 885760d1735595632-listing-top-3-clients-basis-the-revenue-sample
Sheet: Sheet1

Client Name | Revenue | Year | Category
A | 2 | FY2023 | Smooth
A | 3 | FY2023 | Smooth
A | 4 | FY2023 | Far
B | 5 | FY2023 | Smooth
B | 6 | FY2024 | Smooth
B | 10 | FY2024 | Smooth
A | 13 | FY2024 | Smooth
A | 13 | FY2024 | Far
A | 12 | FY2023 | Smooth
B | 15 | FY2023 | Smooth
B | 3 | FY2023 | Smooth
B | 9 | FY2024 | Far
C | 7 | FY2024 | Smooth
D | 3 | FY2025 | Smooth
E | 8 | FY2025 | Far
F | 9 | FY2023 | Smooth
D | 11 | FY2023 | Smooth
D | 2 | FY2025 | Far
C | 6 | FY2023 | Far
C | 5 | FY2025 | Far
C | 7 | FY2025 | Far
F | 4 | FY2024 | Smooth
F | 7 | FY2024 | Smooth
A | 4 | FY2023 | Smooth
B | 5 | FY2024 | Far
C | 6 | FY2023 | Smooth
D | 3 | FY2023 | Smooth
E | 2 | FY2023 | Far
F | 4 | FY2024 | Far
F | 6 | FY2023 | Smooth
E | 7 | FY2025 | Far
A | 9 | FY2025 | Smooth
B | 7 | FY2024 | Smooth
C | 3 | FY2025 | Far
D | 1 | FY2025 | Far
Spreadsheet: 134799d1325633559-lookup-on-first-five-char-lookup-on-value
Sheet: Shindel

Dr Shindel
CPT | Count | wRVU |  |  |  |  | Modifiers
43235 | 41 |  |  |  |  |  | 25 | No Effect
43236 | 1 |  |  |  |  |  | 33 | No Effect
43239 | 304 |  |  |  |  |  | 51 | 0.5
43244 | 11 |  |  |  |  |  | 53 | Discontinued
43245 | 0 |  |  |  |  |  | 59 | No Effect
43246 | 15 |  |  |  |  |  | AG | No Effect
43247 | 6 |  |  |  |  |  | GW | No Effect
43248 | 126 |  |  |  |  |  | PT | No Effect
43249 | 15
43251 | 9
43255 | 11
43256 | 0
43260 | 3
43261 | 2
43262 | 25
43264 | 21
43268 | 24
43269 | 17
43271 | 7
43760 | 3
45330 | 1
45331 | 4
45338 | 1
45345 | 0
45378 | 582
45380 | 65
45381 | 60
45382 | 3
45384 | 1006
45385 | 213
45386 | 1
46221 | 6
46606 | 1
46611 | 1
49440 | 0
91110 | 8
99070 | 1
99201 | 1
99202 | 2
99203 | 51
99204 | 230
99205 | 2
99212 | 12
99213 | 281
99214 | 1871
99215 | 37
99219 | 0
99221 | 0
99222 | 37
99231 | 121
99232 | 502
99233 | 26
99234 | 0
99242 | 1
99243 | 12
99244 | 40
99245 | 3
99253 | 1
99254 | 0
99255 | 0
99282 | 0
99283 | 2
99284 | 1
99285 | 1
99304 | 1
99304 | 1
99305 | 1
99306 | 1
99307 | 27
99308 | 5
99309 | 0
43235-53 | 0
43235-gw | 0
43236-59 | 1
43239-51 | 0
43239-59 | 0
43239-ag | 2
43246-53 | 0
43249-59 | 0
43255-59 | 2
43260-53 | 2
43262-53 | 0
43262-ag | 1
43264-51 | 1
43268-51 | 1
43268-59 | 0
43269-53 | 0
43760-59 | 0
45330-53 | 0
45330-59 | 0
45332-53 | 0
45378-33 | 0
45378-51 | 1
45378-53 | 9
45378-59 | 1
45378-ag | 1
45380-33 | 2
45380-53 | 3
45380-59 | 0
45380-ag | 0
45380-gw | 0
45380-pt | 4
45381-59 | 1
45382-59 | 4
45382-gw | 0
45384-33 | 93
45384-53 | 1
45384-ag | 2
45384-pt | 67
45385-33 | 17
45385-53 | 1
45385-ag | 1
45385-pt | 22
99212-25 | 0
99213-25 | 0
99214-25 | 0
99214-gw | 1
99215-25 | 5
99219-25 | 2
99221-25 | 1
99221-gw | 1
99222-25 | 11
99223-25 | 17
99231-25 | 1
99232-25 | 3
99232-gw | 2
99233-25 | 1
99253-25 | 0
99254-25 | 0
99255-25 | 0
99284-25 | 0
99304-25 | 0
G0105 | 3
G0121 | 32
G0121-53 | 2
G8553 | 9
Totals
Spreadsheet: 648791d1573206786-lookup-or-match-over-several-columns-lookup-demo
Sheet: Headcount

Staff ID | Name | DOB | NI | Unq ID
1234 | [NAME] | 2010-10-01 00:00:00 | AB123456 | 1
7777 | Homer | 2011-11-02 00:00:00 |  |  | *so this id has changed but we have the name and dob already so I want to be able to identify to check the master list, then I would add the details to the masterlist with the new staff id but same unq id
8888 | [NAME] | 2012-12-03 00:00:00 | AD123456
9999 | [NAME] | 2008-12-01 00:00:00 | AF123456 |  | * this would be a new start so would be added to master list manually
Spreadsheet: 40881410-d57d-469b-9a6e-45bdf39a04ac
Sheet: Sheet1

Thanks for volunteering to work with the Audio Ministry at the 8:30 Service. Below is a schedule through July 2013. If you have any conflicts, either call me or just swap with someone else on the list. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | Thanks,
 |  | [NAME] (215) 822-6762
 |  | CUMC Sound System |  |  | 2013-01-05 12:18:26.700000
 |  | 8:30 Service Audio Tech Schedule
2013-01-06 00:00:00 |  | [NAME]
2013-01-13 00:00:00 |  | [NAME]
2013-01-20 00:00:00 |  | [NAME]
2013-01-27 00:00:00 |  | [NAME]
2013-02-03 00:00:00 |  | [NAME]
2013-02-10 00:00:00 |  | [NAME]
2013-02-17 00:00:00 |  | [NAME]
2013-02-24 00:00:00 |  | [NAME]
2013-03-03 00:00:00 |  | [NAME]
2013-03-10 00:00:00 |  | [NAME]
2013-03-17 00:00:00 |  | [NAME]
2013-03-24 00:00:00 |  | [NAME]
2013-03-31 00:00:00 |  | [NAME]
2013-04-07 00:00:00 |  | [NAME]
2013-04-14 00:00:00 |  | [NAME]
2013-04-21 00:00:00 |  | [NAME]
2013-04-28 00:00:00 |  | [NAME]
2013-05-05 00:00:00 |  | [NAME]
2013-05-12 00:00:00 |  | [NAME]
2013-05-19 00:00:00 |  | [NAME]
2013-05-26 00:00:00 |  | [NAME]
2013-06-02 00:00:00 |  | [NAME]
2013-06-09 00:00:00 |  | [NAME]
2013-06-16 00:00:00 |  | [NAME]
2013-06-23 00:00:00 |  | [NAME]
2013-06-30 00:00:00 |  | [NAME]
2013-07-07 00:00:00 |  | [NAME]
2013-07-14 00:00:00 |  | [NAME]
2013-07-21 00:00:00 |  | [NAME]
2013-07-28 00:00:00 |  | [NAME]
Spreadsheet: 749ac945-b67c-4be7-94e7-e6e5610ecae5
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
SAL | Test | SAL | Hypersensitivity Pneumonitis IgG Antibodies, Serum | Hypersensitivity Pneum IgG Ab, S | Fluorescence Enzyme Immunoassay (FEIA) Includes IgG antibodies to [NAME], Thermoactinomyces vulgaris, and Aspergillus fumigatus. | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Aspergillus fumigatus, IgG ANTIBODIES <4 years: not established > or =4 years: < or =102 mg/L   Micropolyspora faeni, IgG ANTIBODIES 0-12 years: < or =4.9 mg/L 13-18 years: < or =9.1 mg/L >18 years: < or =13.2 mg/L   Thermoactinomyces vulgaris, IgG ANTIBODIES 0-12 years: < or =6.6 mg/L 13-18 years: < or =11.0 mg/L >18 years: < or =23.9 mg/L | Monday through Friday; 9 a.m.-8 p.m. | Same day/1 day | 3 days |  | Profile |  |  |  |  | Rochester
SAL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SAL | Result | SASP | Aspergillus fumigatus, [NAME], S | Aspergillus fumigatus, [NAME], S | Numeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | 26954-8 | Aspergillus fumigatus Ab.IgG:MCnc:Pt:Ser:Qn:
SAL | Result | [NAME] | [NAME], [NAME], S | [NAME], [NAME], S | Numeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | 26948-0 | Saccharopolyspora [NAME].IgG:MCnc:Pt:Ser:Qn:
SAL | Result | TAMV | Thermoactinomyces vulgaris, [NAME] | Thermoactinomyces vulgaris, [NAME] | Numeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | 34190-9 | Thermoactinomyces vulgaris Ab.[NAME]:MCnc:Pt:Ser:Qn:
SAL | Billing Component | SAL |  | Aspergillus |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86606
SAL | Billing Component | SAL |  | Fungus-not elsewhere spec |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 86671
Spreadsheet: 168067d1342204766-how-to-create-a-collapsable-tree-in-excel-to-view-more-less-information-book1
Sheet: Sheet1

Account | Business Model | Account Manager | SAP Number | Country | Stages
24/7 Distribution Pty Ltd / Ethan Group | Service Provider |  |  |  |  | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues | Net Revenues
 |  |  |  |  |  | Z1/001.2010 | Z1/002.2010 | [NAME] | Z1/004.2010 | Z1/005.2010 | Z1/006.2010 | [NAME] | Z1/008.2010 | Z1/009.2010 | Z1/010.2010 | [NAME] | Z1/012.2010 | Z1/001.2011 | Z1/002.2011 | Z1/003.2011 | Z1/004.2011 | Z1/005.2011 | Z1/006.2011 | Z1/007.2011 | Z1/008.2011 | Z1/009.2011 | Z1/010.2011 | Z1/011.2011 | Z1/012.2011 | Z1/001.2012 | Z1/002.2012 | [NAME] | Overall Result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 226.01 |  | 226.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 979.72 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 979.72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1806.44 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2210.47
Acropolis | Service Provider
Spreadsheet: 89133d1288888392-lookup-values-based-on-2-columns-book1
Sheet: Sheet1

City | State | County | ID
ORIENT | IA | ADAIR
STANZEL | IA | ADAIR
ZION | IA | ADAIR
BREEDING | KY | ADAIR
CANE VALLEY | KY | ADAIR
CASEY CREEK | KY | ADAIR
COLUMBIA | KY | ADAIR
CUNDIFF | KY | ADAIR
FAIRPLAY | KY | ADAIR
GLENS FORK | KY | ADAIR
GRADYVILLE | KY | ADAIR
KNIFLEY | KY | ADAIR
MILLTOWN | KY | ADAIR
MONTPELIER | KY | ADAIR
ADAIR | MO | ADAIR
BRASHEAR | MO | ADAIR
CONNELSVILLE | MO | ADAIR
GIBBS | MO | ADAIR
GREENTOP | MO | ADAIR
KIRKSVILLE | MO | ADAIR
Spreadsheet: 750281d1633367446-index-and-match-maybe-old-job-report
Sheet: Sheet1

Tray# | Account | Invoice | Patient | Station | Lab Date | Stn Date | In Lab | In Stn |  | Tray# | Account | Invoice | Patient | Station | Lab Date | Stn Date | In Lab | In Stn |  | Did Tray Move? | this column will be removed -  this is what the formula should return
1 |  |  |  | A |  |  |  |  |  | 456789 |  |  |  | A |  |  |  |  |  |  | Did not move
2 |  |  |  | A |  |  |  |  |  | 123456 |  |  |  | A |  |  |  |  |  |  | Did not move
3 |  |  |  | A |  |  |  |  |  | 1 |  |  |  | A |  |  |  |  |  |  | Did not move
4 |  |  |  | A |  |  |  |  |  | 2 |  |  |  | B |  |  |  |  |  |  | Did Move
5 |  |  |  | A |  |  |  |  |  | 3 |  |  |  | B |  |  |  |  |  |  | Did Move
6 |  |  |  | A |  |  |  |  |  | 4 |  |  |  | B |  |  |  |  |  |  | Did Move
456789 |  |  |  | A |  |  |  |  |  | 5 |  |  |  | B |  |  |  |  |  |  | Did Move
123456 |  |  |  | A |  |  |  |  |  | 6 |  |  |  | B |  |  |  |  |  |  | Did Move
Spreadsheet: 70215d1270959865-sorting-sort-odd-even-into-groups-slovenc0417-sdg11
Sheet: Sheet1

SAMPLE NUMBERS - BEFORE |  |  |  |  | SAMPLE NUMBERS - BEFORE | SAMPLE NUMBERS - AFTER
P114311 |  |  |  |  | P114311 | P114311 | ODD
P215222 |  |  |  |  | P215222 | P184571
P184571 |  |  |  |  | P184571 | P144051
P372121 |  |  |  |  | P372121 | P114331
P144051 |  |  |  |  | P144051 | P092712
P114331 |  |  |  |  | P114331 | P273573
P123661 |  |  |  |  | P123661 | P215222 | EVEN
P092712 |  |  |  |  | P092712 | P372121
P312081 |  |  |  |  | P312081 | P123661
P273573 |  |  |  |  | P273573 | P312081
 |  |  |  |  | Today, 10:18 PM
 |  |  |  |  | [NAME] Even into groups - slovenc0417 - SDG11.xls
 |  |  |  |  | Registered User   Join Date: 03 May 2007
 |  |  |  |  | Posts: 42
 |  |  |  |  | Sorting
 |  |  |  |  | http://www.excelforum.com/excel-general/724923-sorting.html
 |  |  |  |  | I would like to sort a column of data, but not in an ordinary way. I have a seven digit number (always starting with the letter "P", followed by 6 digits). An example would be, P114311.
 |  |  |  |  | You will notice that the digits "433" are in red. I did this only for emphasis. I will have a long list of numbers that will follow this 7 digit format.
 |  |  |  |  | I would like to sort the list by the digits in "placeholders" 4, 5 and 6 (theoretically covering a range 000 to 999) AND splitting them into two groups, odd and even.
 |  |  |  |  | Can this be done? I have attached a sample xcel that shows an initial list and how i would like it to look after it is sorted.
 |  |  |  |  | Any help would be greatly appreciated!!!
 |  |  |  |  | Thanks,
 |  |  |  |  | [NAME]
Spreadsheet: 105413d1302776424-how-to-combine-vlookup-and-search-text-within-cell-book1_garriebartolome
Sheet: Sheet1

String Contains > | ID001 |  | Validation List
ID001,ID002,ID003 | Yes |  | ID001
ID004,ID005,ID006 | No |  | ID002
ID001,ID005,ID007 | Yes |  | ID003
ID004,ID009,ID010 | No |  | ID004
ID004,ID005,ID009 | No |  | ID005
ID003,ID005,ID010 | No |  | ID006
ID004,ID005,ID011 | No |  | ID007
[NAME] | No |  | ID008
ID001,ID005,ID013 | Yes |  | ID009
ID004,ID005,ID014 | No |  | ID010
ID002,ID005,ID015 | No |  | ID011
ID004,ID005,ID016 | No |  | ID012
 |  |  | ID013
 |  |  | ID014
 |  |  | ID015
 |  |  | ID016
Spreadsheet: 681581d1591645635-search-another-sheet-row-for-text-extract-data-in-that-column-protected-example-master
Sheet: Employee Job Aid

Next Invoice Scheduled Date = |  |  |  | 2020-07-01 00:00:00
***NOTE: If the agreement has ended, enter the next day from expiration. Ex: Expired 3/31/20, Enter 4/1/2020.
Invoice Total
SN being Removed | Remove/Add | Annual Value | Effective Date | Credit/Invoice Amount
 | Remove
Future Invoices
Monthly
Quarterly
Annually
Sequence | Status | Equip Type | Serial # | Annual Value | Monthly | Quarterly | Line Price/Inv Amount | Prorated Value | Start | End | TOTAL MONTHS ON AGREEMENT | Prorated to Date | MONTHS BILLED TO DATE | Actual to Date: | Correct Invoice to Date: |  | OUTCOME | DIFFERENCE | MONTHS LOV
1
Spreadsheet: 100384d1298762142-conditional-formating-on-cells-based-on-another-cell-colour-teampicks
Sheet: Sheet1

Name | Team to Win | Game# |  |  |  | Games
[NAME] | TeamA | 1 |  |  |  | TeamA | TeamB
Fred | TeamB | 1 |  |  |  | TeamC | TeamD
[NAME] | TeamA | 1 |  |  |  | TeamE | TeamF
[NAME] | TeamA | 1
[NAME] | TeamC | 2
Fred | TeamC | 2
[NAME] | TeamD | 2
[NAME] | TeamD | 2 |  |  | Sum of Game# | Column Labels
[NAME] | TeamE | 3 |  |  | Row Labels | TeamA | TeamB | TeamC | TeamD | TeamE | TeamF | Grand Total
Fred | TeamE | 3 |  |  | [NAME] | 1 |  | 2 |  | 3 |  | 6
[NAME] | TeamE | 3 |  |  | Fred |  | 1 | 2 |  | 3 |  | 6
[NAME] | TeamF | 3 |  |  | [NAME] | 1 |  |  | 2 |  | 3 | 6
 |  |  |  |  | [NAME] | 1 |  |  | 2 | 3 |  | 6
 |  |  |  |  | Grand Total | 3 | 1 | 4 | 4 | 9 | 3 | 24