tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 840551d1692809438-bom-creation-levels-parent-child-relationships-demonstration-of-transforming-parent-child-relationship-into-tree-structure-230502cx1
Sheet: Sheet1

 |  |  | Demonstration of transforming parent-child relationship into tree structure
CONTROL PANEL
Path level separator | > |  | ID | CODE | NAME | PID | AMOUNT | COST | PATH | LEVEL | HIERACHICAL CODE | IS LEAF | TOTAL AMOUNT | SINGLE LEVEL COST | ACCUMLATED LEVEL COST | TREE STRUCTURE
Show total amount in tree? | NO |  | 0 | 470-8691396_REV_R0 | 470-8691396_REV_R0
Calculate total cost? | NO |  | 1 | 8822339_REV_R1 | 8822339_REV_R1 | 0
HIERACHICAL CODE separator | - |  | 2 | 8822340_REV_R0 | 8822340_REV_R0 | 0
Format text for each level | 00 |  | 3 | 8822341_REV_R0 | 8822341_REV_R0 | 0
Counter 1(draw tree lines): | START |  | 44 | 8822342_REV_R0 | 8822342_REV_R0 | 3
 |  |  | 45 | 8822615_REV_R0 | 8822615_REV_R0 | 3
HOW TO USE |  |  | 5 | 8822343_REV_R1 | 8822343_REV_R1 | 0
1. Enable iterative calculation, set the number of iterations to 50 or more (theoretically, the maximum depth of the tree structure multiplied by the number of entries is sufficient, otherwise you need to press F9 a few more times), and set the workbook calculation method to "automatic". 2. Place the data in the 6 columns on the left. Alternatively, use the presentation data directly from the template. 3. Ensure that counter 1 has been changed to 'stop'. 4. Sort the "PATH BY ID" field in ascending order in the table. 5. Change counter 1 to 'start'. |  |  | 35 | 8822344_REV_R1 | 8822344_REV_R1 | 5
 |  |  | 36 | 8822345_REV_R0 | 8822345_REV_R0 | 5
 |  |  | 37 | 8822346_REV_R0 | 8822346_REV_R0 | 5
 |  |  | 38 | 8822347_REV_R0 | 8822347_REV_R0 | 5
 |  |  | 39 | 8822348_REV_R0 | 8822348_REV_R0 | 5
 |  |  | 40 | [NAME] | [NAME] | 5
 |  |  | 42 | 8822615_REV_R0 | 8822615_REV_R0 | 5
 |  |  | 4 | 8822613_REV_R0 | 8822613_REV_R0 | 0
 |  |  | 43 | 8822617_REV_R2 | 8822617_REV_R2 | 0
Spreadsheet: 727892d1618196794-updating-an-existing-formula-to-add-new-logic-samptt1
Sheet: Sheet2

Available | CA | COM | D | REV | FOR | IP | HOLD1 | HOLD2 | HOLD1A | HOLD1B | HOLD3 | HOLD4 | HOLD1C | PA | TERM | SET | TYP | OVER | EXEC | D2B | CURRENT CALCUAATION | Expected Calculation
0 |  |  |  | 1.208333333333333 |  | 55.45833333333334 |  |  |  |  |  |  |  | 0.25 |  | Modified | Normal | Override | 0.2 | 28 |  |  | IN THIS EXAMPLE, G2 GT U2
3 |  |  |  | 0 |  | 16.25 |  |  |  | 205.7916666666667 |  |  |  |  |  | Modified | Normal | Override | 0.2 | 8 |  |  | IN THIS EXAMPLE, G3 GT U3
0 |  |  |  | 2.916666666666667 |  | 0.08333333333333333 |  |  | 11.20833333333333 |  |  |  |  |  |  | Modified | Set Delivery Date | Override | 0.2 |  |  |  | EXEPCTED OUTCOME
0.7916666666666666 |  |  |  | 0.04166666666666666 |  | 11 |  |  | 33 |  |  |  |  | 3.458333333333333 |  | New | Normal | Override | 0.2 | 24 |  |  | IN THIS EXAMPLE, G5 [NAME]
0.08333333333333333 |  |  |  | 25 |  | 75.75 |  |  | 3 | 5.916666666666667 |  |  |  |  |  | Modified | Set Delivery Date | 0 | 68.75 |  |  |  | EXEPCTED OUTCOME
0.2083333333333333 |  |  |  | 1.708333333333333 |  | 8.875 |  |  |  |  |  |  |  |  |  | Modified | Normal | 0 | 8.9 |  |  |  | EXEPCTED OUTCOME
Spreadsheet: 049bdf74-5cf0-4fdd-8685-de03ab5696f7
Sheet: Sheet1

Student Name and Site: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
[NAME]
Community Counseling Log
 | Week 1 | Week 2 | Week 3 | Week 4
Activity | From: | From: | From: | From: | Totals
 | To: | To: | To: | To:
Individual Counseling (includes intake interviews) | 0 |  |  |  | 0
Group Counseling | 0 |  |  |  | 0
Family Counseling | 0 |  |  |  | 0
[NAME] | 0 |  |  |  | 0
Mental Status or Other Assessment/ Interpretation | 0 |  |  |  | 0
Other Direct | 0 |  |  |  | 0
Indirect Hours (e.g., case consultation, observation, paperwork, meetings, etc.) | 0 |  |  |  | 0
Individual/Triadic Supervision | 0 |  |  |  | 0
Group Supervision | 0 |  |  |  | 0
Total | 0 | 0 | 0 | 0 | 0
Monthly Totals | Direct |  | 0
 | Nondirect |  | 0
 | Supervision |  | 0
 | Direct Individual & Group |  | 0
Semester Totals To Date | Direct |  | 0
 | Nondirect |  | 0
 | Supervision |  | 0
 | Direct Individual & Group |  | 0
 | TOTAL HRS |  | 0
Intern's Signature: |  |  |  |  |  | Date:
Site [NAME]'s Signature: |  |  |  |  |  | Date:
Spreadsheet: daren_farmer__6608__TransportFlash
Sheet: 9910

September 1999 Transport Expense Flash
Company | Company Number |  | Commodity Expenses |  | Demand Charges |  | Payable To Pipeline | Contract Numbers
HPLC | 12 |  | 17845.65 |  |  |  | Black Marlin | 96022051
HPLC | 12 |  | 90.94 |  |  |  | Channel Industries Gas Co. | 96017259
HPLC | 12 |  | 6562.59 |  |  |  | East Texas Gas Systems | 96023455
HPLC | 12 |  | 500 |  |  |  | Tejas Gas Pipeline, LP | 96008135
HPLC | 12 |  | 639.53 |  |  |  | Dow Pipeline Co. | 96006998
HPLC | 12 |  |  |  |  |  | Houston Pipeline Company | 96021987/ 96021988
HPLC | 12 |  | 15364.62 |  |  |  | Southland Energy Corporation | 96008703
HPLC | 12 |  | 5210.52 |  |  |  | Unit Gas Transmission | 96008706
ECT/Texas | 16 |  | 490.94 |  |  |  | Northern Natural Gas/Black Marlin | 96020553
ECT/Texas | 16 |  | 61533.05 |  |  |  | Oasis Pipe Line Co. | 96015445/ 96016667/ 96019481/ 96019482
ECT/Texas | 16 |  | 1082.2 |  |  |  | Pan Grande Pipeline, LLC | 96019628
ECT/Texas | 16 |  | 142426.93 |  |  |  | PG&E Texas Pipeline, L.P. | 96006479/ 96006482/ 96009903/ 96011842
 |  |  |  |  |  |  |  | 96016601
ECT/Texas | 16 |  | 6052.34 |  |  |  | EastTrans Limited Partnership
ECT/Texas | 16 |  | 0 |  | 98300 |  | Centana Storage Demand Charge | 96019236
ECT/Texas | 16 |  |  |  |  |  | Houston Pipeline Company | 96007846/ 96007849
Totals
DEMAND CHARGE NOTES:
 |  |  |  | $93,300 demand charge is in line 36 of OA Flash Page
ISSUES: | CPR estimate does not tie with Unify actuals as of 8/2/99
NOTE: | Because Unify does not tie with CPR, and because Unify does not seem to have flashed all pipelines, we used CPR tickets to flash
 | Boxed items show total expense that should show up on HPLC Transport Revenue - HPLR/ECT line
Spreadsheet: 678498d1589917503-combine-multiple-columns-into-one-removing-blanks-delete-blanks
Sheet: Combine Lineups

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 |  | Helper Column | Result
Spreadsheet: 227715d1365792916-multi-column-indexing-solved-trackertest02
Sheet: Tracker

Store | Store1 | <------Once I change these
[NAME] | 2 | <------
Current Month Purchases | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan
This Year (TY)
Last Year (LY) |  |  |  |  |  |  |  |  |  |  |  |  | <-------I want these to auto populate
TY Sales Class Avg (SC)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is for my list selection in Cells B1,B2 pay this no mind.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Store1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Spreadsheet: 91179d1290922412-a-formula-to-multiple-search-the-value-and-total-up-weight4
Sheet: Block A

 |  |  |  |  |  |  | Date | Type no | SF
 |  | Block A |  |  |  |  | Block A
 |  |  |  |  |  |  | 27/11 | 30 | 1277
 |  |  |  |  |  |  | 27/11 | 35 | 1000
 |  |  |  |  |  |  | 27/11 | 30 | 5499
 |  |  |  |  |  |  | 27/11 | 32 | 10273
 |  |  |  |  |  |  | 27/11 | 32 | 1593
 |  |  |  |  |  |  | 27/11 | 35 | 1363
 |  |  |  |  |  |  | 27/11 | 32 | 690
 |  | Block B |  |  |  |  | Block B
 |  |  |  |  |  |  | 28/11 | 30 | 7078
 |  |  |  |  |  |  | 28/11 | 30 | 40
 |  | Block C |  |  |  |  | Block C
 |  |  |  |  |  |  | 28/11 | 30 | 442
 |  |  |  |  |  |  | 29/11 | 32 | 5454
 |  | weight= SF / profile
 |  |  | weight |  |  | type no | profile
 |  | Block A |  | 5.155858585858586 |  | 24 | 2200
 |  | Block A & C |  | 6.4941443001443 |  | 26 | 2500
 |  |  |  |  |  | 28 | 3000
 |  |  |  |  |  | 30 | 3500
 |  |  |  |  |  | 32 | 4500
 |  |  |  |  |  | 35 | 5500
Spreadsheet: 136393d1326602279-having-a-problem-with-the-if-male-female-formating-and-vlookup-sample
Sheet: Sheet1

 | Answer goes in G91 is on the assessment side of this page for post bpm |  |  |  |  |  |  | I2 is male or female |  | K2 is age
 | PostHB Test Result |  |  |  |  |  |  |  |  | PostHB Test Result |  | Rating
 | Male
 | Age |  |  |  |  |  |  |  |  | Points | Score
 |  | 18-25 | 26-35 | 36-45 | 46-55 | 56-65 | 65+ |  |  |  | 28 | Excellent
 | Excellent | 50-76 | 51-76 | 49-76 | 56-82 | 60-77 | 59-81 |  |  |  | 38 | Good
 | Good | 79-84 | 79-85 | 80-88 | 87-93 | 86-94 | 87-92 |  |  |  | 48 | Above Ave
 | Above Average | 88-93 | 88-94 | 92-88 | 95-101 | 97-100 | 94-102 |  |  |  | 59 | Average
 | Average | 95-100 | 96-102 | 100-105 | 103-111 | 103-109 | 104-110 |  |  |  | 70 | Below Ave
 | Below Average | 102-107 | 104-110 | 108-113 | 113-119 | 111-117 | 114-118 |  |  |  | 88 | Poor
 | Poor | 111-119 | 114-121 | 116-124 | 121-126 | 119-128 | 121-126 |  |  |  | 100 | Very Poor
 | Very Poor | 124-157 | 126-161 | 130-163 | 131-159 | 131-154 | 130-151
 | Female | AGE
 |  |  |  |  |  |  |  |  |  | PostHB Test Result | VO2 MAX | Rating
 |  |  | PostHB
 | 18-25 | 26-35 | 36-45 | 46-55 | 56-65 | 65+ |  |  |  | Points | Score
 | Excellent | 52-81 | 58-80 | 51-84 | 63-91 | 60-92 | 70-92 |  |  |  | 28 | Excellent
 | Good | 85-93 | 85-92 | 89-96 | 95-101 | 97-103 | 96-101 |  |  |  | 38 | Good
 | Above Average | 96-102 | 95-101 | 100-104 | 104-110 | 106-111 | 104-111 |  |  |  | 48 | Above Average
 | Average | 104-110 | 104-110 | 107-112 | 113-118 | 113-118 | 116-121 |  |  |  | 59 | Average
 | Below Average | 113-120 | 113-119 | 115-120 | 120-124 | 119-127 | 123-126 |  |  |  | 70 | Below Average
 | Poor | 122-131 | 122-129 | 124-132 | 126-132 | 129-135 | 128-133 |  |  |  | 80 | Poor
 | Very Poor | 135-169 | 134-171 | 137-169 | 137-171 | 141-174 | 135-155 |  |  |  | 100 | Very Poor
 |  |  |  |  | OTHER SIDE OF THIS PAGE
B | C | D | E | F |  | G |  |  |  | I
R 90 | Target Body Area |  | Test Abilities |  |  | TEST NAME |  | Test Results |  | RATING
R 91 | [NAME] |  | Aerobic Endurance |  |  | POST HEART BPM |  | 100 |  | ?
 |  |  | I WAS TRYING TO USE THIS FORMULA
 |  |  | IF(I2="","",(IF(I2="male",VLOOKUP …..
Spreadsheet: 850854d1701182357-unpivot-with-formulas-but-removing-blanks-and-ideally-duplicating-rows-book1
Sheet: Sheet1

 |  |  | Site Name | Block no | Size | Type | Column A | Column B | Column C | Column D | Column E
 |  |  | Site A | 1 | 576 | Type 1 | abc
 |  |  | Site A | 2 |  |  |  |  |  |  |  |  | Type 1 | Data Point 1
 |  |  | Site A | 3 |  |  |  |  |  |  |  |  |  | Data Point 2
 |  |  | Site A | 4 |  |  |  |  |  |  |  |  |  | Data Point 3
 |  |  | Site A | 5 |  |  |  |  |  |  |  |  |  | Data Point 4
 |  |  | Site B | 1 | 400 | Type 2 | abc | abc 2 |  |  |  |  |  | Data Point 5
 |  |  | Site B | 2 | 300 | Type 2 | abc 2
 |  |  | Site B | 3 | 200 | Type 2 | abc 3 | abc 4 | [NAME] | abc 6
 |  |  | Site B | 4 | 500 | Type 2 | abc 3 |  |  |  |  |  | Type 2 | Data Point 1
 |  |  | Site B | 5
 |  |  | Site C | 1 | 600 | Type 2 | abcc 1
 |  |  | Site C | 2 | 300 | Type 2 | abc 2 |  |  |  |  |  | Type 3 | Data Point 1
 |  |  | Site C | 3 | 200 | Type 2 | abc 3
 |  |  | Site C | 4
 |  |  | Site C | 5
 |  |  | Site D | 1 | 1000 | Type 3
 |  |  | Site D | 2
 |  |  | Site D | 3
 |  |  | Site D | 4
 |  |  | Site D | 5
 |  |  | Site E | 1
 |  |  | Site E | 2
 |  |  | Site E | 3
 |  |  | Site E | 4
 |  |  | Site E | 5
 |  |  | Site Name | Block | Size | Type | Column | Data
 | Desired Output |  | Site A | 1 | 576 | Type 1 | abc | Data Point 1
 |  |  | Site A | 1 | 576 | Type 2 | abc | Data Point 2
 |  |  | Site A | 1 | 576 | Type 3 | abc | Data Point 3
 |  |  | Site A | 1 | 576 | Type 4 | abc | Data Point 4
 |  |  | Site A | 1 | 576 | Type 5 | abc | Data Point 5
 |  |  | Site B | 1 | 400 | Type 1 | abc | Data Point 1
 |  |  | Site B | 1 | 400 | Type 2 | abc 2 | Data Point 1
 |  |  | Site B | 2 | 300 | Type 1 | abc 2 | Data Point 1
Spreadsheet: 300012d1393351746-count-unique-values-across-multiple-sheets-based-on-date-book1_sample
Sheet: B Codes

2014-02-02 00:00:00 | 15 | Day | Filipino | Booked | 02870216 | 023276 | Consultant
2014-02-02 00:00:00 | 15 | Day | Leban | Booked | 02411360 | 023276 | Consultant
2014-02-02 00:00:00 | 15 | Day | Syrian | Booked | 02084876 | 023276 | Consultant
2014-02-02 00:00:00 | 15 | Day | Romania | Booked | 02945555 | 023276 | Consultant
2014-02-02 00:00:00 | 15 | Day | Yemen | Booked | 01965933 | 023276 | Consultant
2014-02-02 00:00:00 | 15 | Day | Egyptian | Booked | 00812787 | 023276 | Consultant
2014-02-02 00:00:00 | 15 | Day | Egyptian | Booked | 00237805 | 023276 | Consultant
2014-02-02 00:00:00 | 15 | Day | Moroccan | Booked | 02735364 | 023276 | Consultant
2014-02-02 00:00:00 | 15 | Day | Egyptian | Booked | 02084876 | 023276 | Consultant
2014-02-03 00:00:00 | 14 | Day | Indian | Walk in | 02084876 | 007726 | Consultant
2014-02-03 00:00:00 | 14 | Day | Qatari | Walk in | 00037904 | 007726 | Consultant
2014-02-03 00:00:00 | 14 | Day | Indian | Walk in | 00237805 | 009745 | Consultant
2014-02-04 00:00:00 | 14 | Day | Qatari | Booked | 00055812 | 009745 | Consultant
2014-02-04 00:00:00 | 14 | Day | Qatari | Booked | 02084876 | 009745 | Consultant
2014-02-04 00:00:00 | 14 | Day | Indian | Walk in | 03055466 | 009745 | Consultant
2014-02-04 00:00:00 | 14 | Day | Qatari | Walk in | 02084876 | 007726 | Consultant
2014-02-05 00:00:00 | 14 | Day | Syrian | Booked | 01965933 | 009745 | Consultant
2014-02-05 00:00:00 | 14 | Day | Egyptian | Booked | 03100002 | 009745 | Consultant
2014-02-05 00:00:00 | 14 | Day | Saudi | Booked | 00893678 | 009745 | Consultant
2014-02-05 00:00:00 | 14 | Day | Pakistan | Booked | 02084876 | 009745 | Consultant
2014-02-05 00:00:00 | 14 | Day | Iraq | Booked | 02379331 | 009745 | Consultant
2014-02-05 00:00:00 | 14 | Day | Bangladesh | Booked | 02513158 | 009745 | Consultant
2014-02-05 00:00:00 | 14 | Day | Lebanese | Booked | 01817491 | 009745 | Consultant
2014-02-05 00:00:00 | 14 | Day | Qatari | Booked | 00084005 | 009745 | Consultant
2014-02-05 00:00:00 | 14 | Day | Filipino | Booked | 02084876 | 009745 | Consultant
2014-02-05 00:00:00 | 14 | Day | Indian | Walk in | 01965933 | 009745 | Consultant
2014-02-05 00:00:00 | 14 | Day | Indian | Walk in | 02017925 | 009745 | Consultant
2014-02-05 00:00:00 | 14 | Day | Filipino | Walk in | 02199554 | 009745 | Consultant
2014-02-05 00:00:00 | 14 | Day | Nigerian | Walk in | 02941138 | 009745 | Consultant
Spreadsheet: 525447d1498733390-please-advice-a-more-elegant-correct-approach-to-fill-the-column-with-values-excel_forum_questions
Sheet: DynamicChart

 | Present value
 | Capital value | 100000 |  | Management Summary
 | Periodic cash flow | 28000 |  | NPV
 | Minimum NPV | 7000
 | Start date
 | Select CF period:
 | Period:
 | Select Rate:
 | Discount rate
 | Years | 0 | 1 | 2 | 3 | 4 | 5
 | Periodic Dates
 | Capital value
 | Periodic Cash flows |  | 28000 | 28000 | 28000 | 28000 | 28000
 | Net cash flow
 | Cumulative total
 | Select entry: |  | 6 |  | << E22 uses OFFSET to change the name in the graph
 | Workings
 | Interval | 0.005 |  | Monthly | 1 | 4
 | 0.08 | 6 |  | Quarterly | 4
 |  |  |  | Bi-annual | 2
 |  |  |  | Annual | 12
Spreadsheet: 4f0e57d8-c8ce-4ed7-af8f-48709c6e39de
Sheet: CO GRAD PATHWAY

Grant: |  | Colorado Graduation Pathways
CFDA # |  | 84.36
GRANT NUMBER: |  | 5360
FISCAL YEAR: |  | FY2013-14
[NAME]: |  | Limited to 15%
Question regarding payments: |  | [NAME]-866-6724  or [EMAIL]
Questions regarding grant: |  | Marti Rodriguez [PHONE] or [EMAIL]
GBL/ORG: |  | 694C/7000
LAST DAY TO SUBMIT REQUEST FOR THIS GRANT  - October 15, 2014
Code | District/Agency Name | Allocation | Approved Carryover a/o 6/30/2013 | Total Amount Available | PAYMENTS TO DATE | BALANCE | JULY 2012 | AUGUST 2012 | SEPTEMBER 2012 | OCTOBER 2012 | OCTOBER  2013 | NOVEMBER  2013 | DECEMBER  2013 | JANUARY  2014 | FEBRUARY  2014 | [NAME] | APRIL  2014 | MAY  2014 | [NAME] | JULY  2014 | AUGUST  2014 | SEPTEMBER  2014
0010 | [NAME] | 125000 | 13500 |  |  |  |  |  |  |  |  |  |  | 11763 |  | 17455
0010-NAS | New America Schools
0020 | Adams 12 Five Star Schools | 285000 | 29184 |  |  |  |  |  |  |  |  | 68069 | 14494 | 21508 | 16833 | 24310
0030 | Adams 14 | 90000 | 2605 |  |  |  |  |  |  |  |  | 37646 | 877 |  | 5120 | 4513
0070 | Westminster 50 | 70000
0120 | Englewood 1 | 85500 | 324 |  |  |  |  |  |  |  |  | 17853 |  |  | 20944 | 5000
0130 | [NAME] | 35000 | 3500 |  |  |  |  |  |  |  |  |  |  |  |  | 17760
0180 | Adams-Arapahoe 28J | 324000 |  |  |  |  |  |  |  |  |  | 101014 | 5193 | 30397 | 26795 | 29115
0180-NAS | New America Schools | 47500 |  |  |  |  |  |  |  |  |  |  | 9035 | 452 |  | 13093
0880 | Denver Public Schools | 116000 |  |  |  |  |  |  |  |  |  |  | 4566
1010 | Colorado Springs 11 | 100000 | 2626 |  |  |  |  |  |  |  |  |  |  | 23733
1420 | [NAME] | 210500 | 23500 |  |  |  |  |  |  |  |  | 18917 | 17736 | 17676 | 12744 | 15721
1990 | Plateau 50 | 35000 |  |  |  |  |  |  |  |  |  | 6375 | 2832 | 2849 | 2849 | 2849
2000 | Mesa 51 | 35000 |  |  |  |  |  |  |  |  |  | 3549 |  |  | 8730 | 3229
2035 | [NAME] | 85500 | 23696 |  |  |  |  |  |  |  |  | 4993 | 5319 | 5326 | 5394 | 5631
2405 | [NAME] | 35000 | 7624 |  |  |  |  |  |  |  |  | 3943 | 2924 | 2923 | 2941 | 2941
2690 | Pueblo City 60 | 81000 |  |  |  |  |  |  |  |  |  | 13066 | 7432 | 6969 | 7057 | 7463
3120 | [NAME] 6 | 70000 |  |  |  |  |  |  |  |  |  | 19467 | 4310 | 3206 | 3228 | 3958
3140 | Weld RE-6 | 35000 |  |  |  |  |  |  |  |  |  |  | 6768
Spreadsheet: e5e4bf88-e7fd-46c5-86bf-bc0ae52e8827
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
BXMPL | Test | BXMPL | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. -8 p.m., Saturday; 8 a.m. -3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
BXMPL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BXMPL | Result | BXMPL | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7155-5
Spreadsheet: 96843d1296120473-vlookup-help-needed-order-book
Sheet: Shop Fit, Didsbury

PAYMENT BREAKDOWN |  |  |  | JOB DURATION
WEEK # | WEEK ENDING | AMOUNT |  | START | # OF WEEKS | END
 |  | 2000 |  | 2011-01-17 00:00:00 | 5
 |  | 1500
 |  | 1500
 |  | 1500 |  | TOTAL JOB VALUE
 |  | 2000
 |  |  |  | DATA INTEGRITY
 |  |  |  | Job End
 |  |  |  | Payments
Spreadsheet: 216927d1361921457-count-number-of-hours-someone-worked-between-two-times-test
Sheet: Sheet1

Day | Start Time | End Time | How Many Hours Did They Work From 7pm to Midnight? | How Many Hours Did They Work From Midnight to 7am? |  |  | End Time
Mon | 20 | 1
Tue | 16 | 6
Wed | 14 | 7
Thu | 13 | 23
Fri | 4 | 15
Sat | 5 | 13.5
Sun | 5 | 13.5
Spreadsheet: 709447d1608307277-do-i-use-index-and-match-to-count-products-on-different-sheets-stock-check-blanks-2
Sheet: D Aisle

 | Product code | Qty |  |  | Product code | Qty
D1A |  |  |  | D4A
D1B |  |  |  | D4B
D1C |  |  |  | D4C
D1D |  |  |  | D4D
D1E |  |  |  | D4E
[NAME] |  |  |  | D4F
D1G |  |  |  | D4G
D2A |  |  |  | D5A
D2B |  |  |  | D5B
D2C |  |  |  | D5C
D2D |  |  |  | D5D
D2E |  |  |  | D5E
D2F |  |  |  | D5F
D2G |  |  |  | D5G
D3A |  |  |  | D6A
D3B |  |  |  | D6B
D3C |  |  |  | D6C
D3D |  |  |  | D6D
D3E |  |  |  | D6E
D3F |  |  |  | D6F
[NAME] |  |  |  | D6G
 | Product code | Qty |  |  | Product code | Qty
D7A |  |  |  | [NAME]
D7B |  |  |  | D10B
D7C |  |  |  | [NAME]
D7D |  |  |  | D11D
D7E |  |  |  | D12E
D7F |  |  |  | D12F
[NAME] |  |  |  | D12G
D8A |  |  |  | D11A
D8B |  |  |  | D11B
D8C |  |  |  | D11C
[NAME] |  |  |  | D11D
[NAME] |  |  |  | D11E
[NAME] |  |  |  | D11F
D8G |  |  |  | D11G
D9A |  |  |  | D12A
D9B |  |  |  | [NAME]
D9C |  |  |  | D12C
D9D |  |  |  | D12D
D9E |  |  |  | D12E
D9F |  |  |  | D12F
[NAME] |  |  |  | D12G
D13A |  |  |  | D16A
D13B |  |  |  | D16B
D13C |  |  |  | [NAME]
D13D |  |  |  | D16D
[NAME] |  |  |  | D16E
[NAME] |  |  |  | D16F
[NAME] |  |  |  | [NAME]
D14A |  |  |  | D17A
D14B |  |  |  | D17B
D14C |  |  |  | D17C
D14D |  |  |  | D17D
D14E |  |  |  | D17E
D14F |  |  |  | [NAME]
D14G |  |  |  | [NAME]
D15A |  |  |  | D18A
D15B |  |  |  | D18B
D15C |  |  |  | D18C
D15D |  |  |  | D18D
D15E |  |  |  | D18E
D15F |  |  |  | D18F
D15G |  |  |  | [NAME]
Spreadsheet: 04d6dda1-0522-428b-9869-952349fea046
Sheet: Sheet1

CERTIFICATION OF EXPENSES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
FORT HAYS STATE UNIVERSITY
PR |  |  | PO |  |  | DO NOT USE THIS FORM FOR IMPREST
This signed form, along with itemized receipts, should be returned to Accounts Payable at the end of the trip.
Date(s) of Trip
Destination
Purpose
I certify that I personally paid for partial student expenses on this trip.
Print recipients Name: |  |  |  |  |  |  |  |  |  | (signature)
I certify that the amount below was paid for my expenses and I will not claim further reimbursement from the State of Kansas for this trip.
Name (printed) |  |  |  | Signature |  |  |  |  | Item |  |  |  |  |  | Amount
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 761935d1641307586-find-future-on-hand-quantity-for-duplicate-values-sample-excel-forum
Sheet: Data

Part | BalDue | Job # | Required Date | Total OH | Period Shortage | Short | DMR | RII | PO | Qty | PO Due | Shortage
101 | 4 | 301 | 2021-11-18 00:00:00 | 5 |  |  | 50 | 0 | 201 | 5 | 2022-01-25 00:00:00
102 | 5 | 301 | 2021-12-15 00:00:00 | 4 |  |  | 0 | 0 | 201 | 0 | 2022-01-25 00:00:00
103 | 10 | 302 | 2021-12-15 00:00:00 | 5 |  |  | 0 | 0 | 201 | 0 | 2022-01-25 00:00:00
104 | 12 | 302 | 2021-12-15 00:00:00 | 12 |  |  | 0 | 4 | 202 | 0 | 2022-06-07 00:00:00
105 | 20 | 303 | 2021-11-15 00:00:00 | 5 |  |  | 0 | 0 | 202 | 0 | 2022-01-14 00:00:00
106 | 3 | 303 | 2021-12-10 00:00:00 | 0 |  |  | 0 | 3 | 202 | 0 | 2022-01-14 00:00:00
107 | 5 | 304 | 2021-12-21 00:00:00 | 1 |  |  | 20 | 0 | 203 | 2 | 2022-01-21 00:00:00
108 | 6 | 304 | 2021-10-29 00:00:00 | 3 |  |  | 0 | 0 | 203 | 0 | 2022-01-21 00:00:00
109 | 4 | 305 | 2021-12-07 00:00:00 | 4 |  |  | 0 | 0 | 203 | 0 | 2022-01-11 00:00:00
110 | 21 | 305 | 2022-01-07 00:00:00 | 22 |  |  | 0 | 2 | 204 | 10 | 2022-01-06 00:00:00
111 | 8 | 306 | 2021-12-14 00:00:00 | 4 |  |  | 0 | 0 | 204 | 0 | 2022-03-22 00:00:00
112 | 14 | 306 | 2021-11-15 00:00:00 | 10 |  |  | 5 | 0 | 204 | 0 | 2022-01-05 00:00:00
113 | 25 | 307 | 2022-01-05 00:00:00 | 6 |  |  | 1 | 0 | 205 | 0 | 2022-01-06 00:00:00
114 | 7 | 307 | 2021-11-15 00:00:00 | 4 |  |  | 0 | 0 | 205 | 0 | 2022-01-06 00:00:00
115 | 9 | 308 | 2021-12-15 00:00:00 | 3 |  |  | 0 | 0 | 205 | 12 | 2022-01-06 00:00:00
116 | 14 | 308 | 2021-12-15 00:00:00 | 15 |  |  | 0 | 0 | 206 | 0 | 2022-02-01 00:00:00
117 | 16 | 309 | 2021-12-06 00:00:00 | 10 |  |  | 0 | 0 | 206 | 0 | 2022-02-01 00:00:00
118 | 8 | 309 | 2021-12-13 00:00:00 | 5 |  |  | 0 | 0 | 206 | 1 | 2022-02-08 00:00:00
119 | 30 | 310 | 2022-01-07 00:00:00 | 6 |  |  | 5 | 0 | 207 | 0 | 2022-01-06 00:00:00
120 | 2 | 310 | 2021-12-21 00:00:00 | 2 |  |  | 0 | 1 | 207 | 0 | 15/5/2022