tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 192680d1352489833-duration-calculation-and-results-populated-on-another-sheet-gantt-example
Sheet: Gantt_Conditional Formatting

 |  |  |  | Internal Communication
 |  |  |  | 2012-11-05 00:00:00 | 2012-11-12 00:00:00 | 2012-11-19 00:00:00 | 2012-11-26 00:00:00 | 2012-12-03 00:00:00 | 2012-12-10 00:00:00 | 2012-12-17 00:00:00 | 2012-12-24 00:00:00 | 2012-12-31 00:00:00 | 2013-01-07 00:00:00 | 2013-01-14 00:00:00 | 2013-01-21 00:00:00 | 2013-01-28 00:00:00 | 2013-02-04 00:00:00 | 2013-02-11 00:00:00 | 2013-02-18 00:00:00 | 2013-02-25 00:00:00 | 2013-03-04 00:00:00 | 2013-03-11 00:00:00 | 2013-03-18 00:00:00 | 2013-03-25 00:00:00 | 2013-04-01 00:00:00 | 2013-04-08 00:00:00 | 2013-04-15 00:00:00 | 2013-04-22 00:00:00 | 2013-04-29 00:00:00
 | Task | Start | End
 | Task A
 | Task B
 | Task C
 | Task D
 | Task E
 | Task F
Spreadsheet: 716791d1612365867-gantt-chart-by-15-minutes-gantt-chart-by-15-mins-and-over-midnight-xing-duong-
Sheet: Sheet1

BASE DATA FOR FOMULAS SETUP (DON’T'TOUCH)
 |  |  |  | Working IN | Working OUT |  |  |  |  |  | No | ID No | Full Name |  |  |  |  |  |  |  | Time IN | Time OUT | [NAME] | [NAME]
 |  |  |  | 08:00:00 | 15:30:00 |  |  |  |  |  | 60 | 004237 | A
 |  |  |  | 08:30:00 | 15:00:00 |  |  |  |  |  | 30 | 003981 | B
 |  |  |  | 08:15:00 | 15:00:00 |  |  |  |  |  | 65 | 002122 | C
 |  |  |  | 08:45:00 | 15:00:00 |  |  |  |  |  | 27 | 002866 | D
 |  |  |  | 08:30:00 | 15:30:00 |  |  |  |  |  | 67 | 003376 | E
 |  |  |  | 08:30:00 | 15:45:00 |  |  |  |  |  | 64 | 004446 | F
 |  |  |  | 08:30:00 | 15:15:00 |  |  |  |  |  | 62 | 004233 | G
 |  |  |  | 08:15:00 | 15:30:00 |  |  |  |  |  | 28 | 003250 | H
 |  |  |  | 08:45:00 | 15:45:00 |  |  |  |  |  | 61 | 004503 | I
 |  |  |  | 22:30:00 | 06:30:00 |  |  |  |  |  | 28 | 003250 | J
 |  |  |  | 23:45:00 | 07:15:00 |  |  |  |  |  | 61 | 004503 | K
Spreadsheet: andy_zipper__345__NYMEX Straddles
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strke | Bid | Offer | Volatility | Net Change
 | G | 255 | 46 | 48 | 0.8247000000000083 | -0.02489999999999171
 | H | 255 | 60 | 62.5 | 0.7728000000000042 | 0.002700000000004144
 | J | 255 | 60 | 62 | 0.6335499999999892 | 0.005149999999989219
 | K | 265 | 65 | 66.5 | 0.5678999999999903 | -0.006000000000009664
 | M | 270 | 69 | 72 | 0.5274999999999926 | 0.002699999999992597
 | N | 275 | 77 | 80 | 0.5342999999999759 | 0.01469999999997595
 | Q | 280 | 84 | 88 | 0.5278999999999772 | 0.0008999999999771413
 | U | 280 | 90 | 94 | 0.5313499999999768 | 0.0006499999999768358
 | V | 285 | 96 | 101 | 0.5310499999999768 | -0.004050000000023202
 | X | 305 | 109 | 115 | 0.5395999999999759 | -0.007800000000024121
 | Z | 320 | 120 | 126 | 0.5377999999999761 | -0.0006000000000239147
 | F | 335 | 131 | 138 | 0.5438999999999996 | 0.008899999999999575
 | G | 325 |  |  | #[NAME]! | 0
 | H | 320
 |  |  | 2001-12-31 13:15:43.990000
 |  |  | Crude Oil Straddles
 | Month | Strke | Bid | Offer | Volatility | Net Change
 | G | 2000 | 180 | 190 | 0.5397999999999944
 | H | 2000 | 300 | 305 | 0.5357999999999927
 | J | 2050 | 390 | 395 | 0.5379999999999899
 | K | 2050 | 450 | 465 | 0.5245499999999899
 | M | 2050 | 480 | 495 | 0.4971999999999902
 | N | 2050 | 510 | 520 | #[NAME]!
 | Q | 2050 | 530 | 545 | 0.4585499999999912
 | U | 2050 | 540 | 560 | #[NAME]!
 | V | 2050 | 545 | 565 | #[NAME]!
 | X | 2100 | 550 | 570 | #[NAME]!
 | Z | 2100 | 550 | 570 | 0.2954999999999957
 | F03 |  |  |  | #[NAME]!
 | G |  |  |  | #[NAME]!
 |  |  | 2001-12-31 13:12:15.060000
Spreadsheet: 582870d1532090461-how-to-replicated-an-if-formulan-in-powerquery-accumulating
Sheet: Sheet2

Apply Date | Historical Date | Employee | Employee Name | Employee Logon | EE Type | Manager | Pay Rule | Location | Cost Center | [NAME] | CR CCSS [NAME] | CR CCSS Sick Leave Unpaid | CR Leave of Absence Unpaid | Consecutive_days
2018-05-29 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 5.37 |  |  | 1
2018-06-12 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 3.4 |  |  | 1
2018-06-13 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 2
2018-06-21 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 5.93 |  |  | 1
2018-06-22 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 2
2018-06-23 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 3
2018-06-28 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 1
2018-06-29 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 2
2018-06-30 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 3
2018-07-01 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 4
2018-07-02 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 5
2018-07-03 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 6
2018-07-04 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 7
2018-07-05 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 8
2018-07-06 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 9
2018-07-07 00:00:00 |  | x | x | aahrnan | x | x | x | x | x | x | 8 |  |  | 10
2018-01-16 00:00:00 | 43112 | x | x | aamendez | x | x | x | x | x | x | 8 |  |  | 1
2018-01-16 00:00:00 | 43111 | x | x | aamendez | x | x | x | x | x | x | 8 |  |  | 1
2018-06-11 00:00:00 |  | x | x | aamendez | x | x | x | x | x | x | 8 |  |  | 1
2018-06-12 00:00:00 |  | x | x | aamendez | x | x | x | x | x | x | 8 |  |  | 2
2018-06-13 00:00:00 |  | x | x | aamendez | x | x | x | x | x | x | 8 |  |  | 3
Spreadsheet: phillip_allen__28805__Rent_Roll
Sheet: Incentive Plan

 |  |  | Stage Coach Apartments
 |  |  | 2000 Incentive Plan
Cash bonuses in the year 2000 will be paid on a combination of owner's discretion and a percent of
rent collected.  The table below details the payout per employee.
 | Category |  | Rate |  | Cash Bonus
 | Discretionary |  | Owner Disc. |  | Up to $1,000/each
 | $210,000-$220,000 |  | 10% divided equally |  | Up to $500/each
 | $220,000-$230,000 |  | 20% divided equally |  | Up to $1,000/each
 |  |  | Total |  | Up to $2,500/each
Bonuses will be paid on 12/31/00.
Discretionary bonus based on productivity, expenses <$9,000/month, and appearance of property.
Rent assumptions:
 | Rent @ 100% occupancy |  |  | 233780
 | Average Vacancy 4 units
 | Expected Rents
 | Bonus based on rents collected not all cash.  Excludes deposits and
 | application fees, and utilities paid by tenant.
Spreadsheet: 605593d1547154731-applying-multiple-formulas-to-multiple-columns-ot-version-1
Sheet: Sheet2

Code: | Reason:
A | Shutdown
B | Start Up
C | Cores
D | Clean Broke
E | Replace Vacation
F | Two Hour Call
G | Four hour call
H | Foam Floors
I | Six hour call (Felt Change)
J | Seven hour call
K | Water Bottles
L | Felt Guiding
Spreadsheet: 789166d1658935872-dynamically-place-maximum-pay-range-in-last-row-column-b-starting-trend-test
Sheet: Sheet1

Pay Band Calculator - 10 Years
[NAME] |  |  |  |  | Pay Increase Jumps
Pay Band | Min | [NAME] |  |  | Semi-Annual Increase | Annual Increase
Rates | 35 | 45.5
Enter Years of Experience Here to get Rate
YOE | Calculated Rate |  |  |  | YOE Move | Market Move
8 |  |  |  |  | 0.02 | 0.02
YOE Salary | [NAME] band | [NAME] Years
 |  | 10
[NAME]: based off of the amount of years in c12.  I want the dollars to be automatically populated in column B18 down.  When [NAME] Years is entered…I want dynamically adjust the Dollars column.
Years of Experience | Dollars | Pay Increase
 |  | 0
0.5 | 35.525
1 | 36.05
1.5 | 36.575
2 | 37.1
2.5 | 37.625
3 | 38.15
3.5 | 38.675
4 | 39.2
4.5 | 39.725
5 | 40.25
5.5 | 40.775
6 | 41.3
6.5 | 41.825
7 | 42.35
7.5 | 42.875
8 | 43.4
8.5 | 43.925
9 | 44.45
9.5 | 44.975
10 | 45.5
Spreadsheet: 173598d1344612153-index-and-match-function-across-multiple-array-excel-ex-form
Sheet: Lookup Command

PARTS |  | Heats | Pieces | Heats | Pieces | Heats | Pieces | Heats | Pieces | Heats | Pieces | Heats | Pieces | Heats | Pieces | Heats | Pieces | Heats | Pieces | Heats | Pieces | Heats | Pieces | Heats | Pieces |  | PARTS |  | Heats | Pieces | Heats | Pieces | Heats | Pieces | Heats | Pieces | Heats | Pieces | Heats | Pieces | Heats | Pieces | Heats | Pieces | Heats | Pieces | Heats | Pieces
 | 33 |  |  |  | 11 |  |  |  | 12 |  |  |  | 13 |  |  |  | 14 |  |  |  | 15 |  |  |  | 16 |  |  | 40 |  |  |  | 17 |  |  |  | 18 |  |  |  | 19 |  |  |  | 20 |  |  |  | 21
8 | Cav |  |  | 66 |  |  |  | 48 |  |  |  | 68 |  |  |  | 18 |  |  |  | 23 |  |  |  | 56 |  |  | 33 | Cav |  |  | 77 |  |  |  | 42 |  |  |  | 64 |  |  |  | 85 |  |  |  | 44
1 | 80 | 14 |  | 14 |  | 14 |  | 10.9 |  | 12 |  | 13 |  | 14 |  | 14 |  | 16 |  | 16 |  | 14 |  | 7.2 |  |  | 11 | 66 | 14.7 |  | 15 |  | 14.7 |  | 15.5 |  | 12 |  | 12 |  | 12 |  | 12 |  | 14.7 |  | 14
2 | 15 | 13 |  | 13 |  | 13 |  | 10.9 |  | 13 |  | 14 |  | 13 |  | 13 |  | 13 |  | 19 |  | 13 |  | 7.2 |  |  | 12 | 48 | 10.9 |  | 15 |  | 10.9 |  | 15.5 |  | 12 |  | 12 |  | 12 |  | 12 |  | 10.9 |  | 14
3 | 36 | 12 |  | 12 |  | 12 |  | 12 |  | 7.3 |  | 13.7 |  | 12 |  | 12 |  | 7.3 |  | 17.7 |  | 12 |  | 12 |  |  | 13 | 68 | 14 |  | 15 |  | 14 |  | 14 |  | 14 |  | 14 |  | 14 |  | 13.7 |  | 14 |  | 14
4 | 17 | 15 |  | 14.7 |  | 15 |  | 10.9 |  | 13 |  | 14 |  | 15 |  | 15 |  | 17 |  | 18 |  | 15 |  | 7.2 |  |  | 14 | 18 | 15 |  | 15 |  | 15.5 |  | 15.5 |  | 12 |  | 12 |  | 12 |  | 12 |  | 15.3 |  | 14
5 | 29 | 12 |  | 12 |  | 12 |  | 12 |  | 9.3 |  | 13.7 |  | 12 |  | 12 |  | 9.3 |  | 17.7 |  | 12 |  | 12 |  |  | 15 | 23 | 20 |  | 15 |  | 19 |  | 17 |  | 19.7 |  | 16.3 |  | 19.7 |  | 13.7 |  | 20 |  | 14
6 | 67 | 12 |  | 12 |  | 12 |  | 12 |  | 10.6 |  | 13.7 |  | 12 |  | 12 |  | 10.6 |  | 17.7 |  | 12 |  | 12 |  |  | 16 | 56 | 7.2 |  | 15 |  | 7.2 |  | 15.5 |  | 12 |  | 12 |  | 12 |  | 12 |  | 7.2 |  | 14
7 | 98 | 12 |  | 12 |  | 12 |  | 12 |  | 13.7 |  | 13.7 |  | 12 |  | 12 |  | 14 |  | 17.7 |  | 12 |  | 12
8 | 31 | 12 |  | 12 |  | 12 |  | 12 |  | 8.1 |  | 13.7 |  | 12 |  | 12 |  | 8.1 |  | 17.7 |  | 12 |  | 12
9 | 15 | 12 |  | 12 |  | 12 |  | 12 |  | 13.7 |  | 13.7 |  | 12 |  | 12 |  | 14 |  | 17.7 |  | 12 |  | 12
10 | 74 | 12 |  | 12 |  | 12 |  | 12 |  |  |  | 13.7 |  | 12 |  | 12 |  |  |  | 17.7 |  | 12 |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pieces |  |  |  |  | Pieces
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Estimated Standard
Spreadsheet: 86da56fd-fac4-448b-9ae7-5fc5fcb49044
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly Report to the FHA Commissioner
 |  |  |  |  |  |  |  |  |  |  |  |  |  | on
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FHA Business Activity
 |  |  |  |  |  |  |  |  |  |  |  |  |  | October 2011
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Office of Risk Analysis and Regulatory Affairs
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Federal Housing Administration
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Department of Housing and Urban Development
Spreadsheet: 122014d1316551995-indirect-erep_1gb-tigrovi_bkp
Sheet: BeDva

Ambient on/off
eRepublik – Online Strategy Game
Sep20 Day 1,400 of the New World
Home
My Land
Wars
Market
Marketplace
Job market
Monetary market
Companies for sale
Community
World Map
News
My Party
Elections
Military Unit
Country administration
Invite friends
Badges
Get Gold & Extras
[NAME]
[NAME]
27
60
Eat food
Gold2.24 Gold
BAM411 BAM
HRK1625 HRK
Missions
X
You don't have enough Gold to complete the task Get Gold
Completed!
2011-10-03 00:00:00
2011-10-03 00:00:00
2011-10-03 00:00:00
Reward
Ok
Congratulations, your rank is now
Rank Bonus on attack +5%
Energy bar
Ok
Strength
Experience points
Health
Rank points
Gold
Energy bar
[NAME]
Free Lands
Scope
Bazooka
Weapons
Weapons
Weapons
Food units
Food units
Food units
Grain Farms
0 0
Logout
Experience level: 27
Experience points: 10027
Next level at: 15000
• Working, training and fighting decreases health
[NAME], health boxes, food, hospitals restore health.
This action restores as much health as possible by eating Food from your Storage.
You can recover up to: 450 / 450 Health
100 more recoverable Health in: 00:59:59
Food limit reached
You have reached your food consumption limit.
You can recover 100 health every hour.
100 more recoverable Health in: [NAME]
Buy health kit Close
BeDva
offlineBeDva
Add as a friend Send message Donate
Experience level 30
28,367 / 30,000
Location: CroatiaCroatia, Central Croatia Citizenship: CroatiaCroatia
eRepublik birthday
Feb 19, 2010
National rank: 192
Party Member
[NAME] eHrvatskeSavez Komunista eHrvatske Far-left Wing
Member
HV 1.GB Tigrovi HV 1.GB Tigrovi
Press director
Svijet [NAME]
Friends(1332)
[NAME]
Agrammon
[NAME]
[NAME]
[NAME] El Comandante
Fabius
boxer 64
gumby perec
[NAME] od Potoka
view all
Land of BeDva: 23 buildings
Visit
About me
Wiki page
eCroatian vMoFA --> you can find our team at #hr-mvp on rizon // or contact me or antjerci via IGM
http://plasmaoxyd.de/wp/wp-content/uploads/2006/04/reissack.jpg
Achievements
hard worker
16
Hard Worker
Worked 30 days in a row
congressman
5
Congress Member
Won the Congress elections
president
Country President
Win the Presidential elections
media mogul
Media Mogul
Reach 1000 subscribers to your newspaper
battle hero
7
Battle Hero
Reach the highest war influence in a battle
campaign hero
1
Campaign Hero
Reach the highest war influence in a campaign
resistance hero
1
Resistance Hero
Started a resistance war and liberated 1 regions.
super soldier
24
Super Soldier
Advance 250 strength points
society builder
Society Builder
Invite 10 people to eRepublik and help them reach level 10
mercenary
1
Mercenary
Defeat 25 enemies for 50 different countries
Coming soon
Coming soon
Military Skills
Strength
6,069.89
Super soldier:6,069 / 6,250
Rank
Supreme Marshal ***Supreme Marshal ***
Rank points:
4,744,091 / 4,900,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 133759d1324582349-vlookup-excel-test-data1
Sheet: Sheet1

Statement |  |  | Invoices cleared |  |  | Invoices registered |  |  | Invoices Paid |  |  | Invoices disputed
Invoice No. | Comment |  | Invoice No. | Comment |  | Invoice No. | Comment |  | Invoice No. |  |  | Invoice No.
123456 | Cleared |  | 123456 | Cleared |  | 124971 | Cleared |  | 124971 | Cleared |  | 131000 | Cleared
123457 | Cleared |  | 123457 | Cleared |  | 125862 | Cleared |  |  |  |  | 129444 | Cleared
124971 | Paid
125862 | Registered
129444 | Disputed
130000 | Not Found
 |  |  |  |  |  | It's not shown 124971 as a duplicate |  |  |  |  |  | It has 131000 as a cleared item
 |  |  |  |  |  |  |  |  |  |  |  | when it should be not found
Spreadsheet: 850929d1701238188-sort-data-conditional-upon-its-status-forum-help-sheet-for-sorting
Sheet: Sheet1

 |  |  |  |  |  |  |  | Debts Not Paid Off and Sorted by Interest Rate in Descending Order
 | Debt | Balance | Payment | Interest Rate | Pay Off?
 |  |  |  |  |  |  |  |  | Balance | Payment | Interest Rate
 | Debt 1 | 100000 | 600 | 0.05 | False |  |  | Remaining Debt 1
 | Debt 2 | 25000 | 350 | 0.075 | False |  |  | Remaining Debt 2
 | Debt 3 | 10000 | 225 | 0.08 | True |  |  | Remaining Debt 3
 | Debt 4 | 5000 | 150 | 0.19 | True |  |  | Remaining Debt 4
 | Debt 5 | 2000 | 50 | 0.26 | False |  |  | Remaining Debt 5
 | *Checked box = TRUE and means will be paid off
 |  | 2000 | 50 | 0.26
 | Debt 2 | 25000 | 350 | 0.075
 | Debt 1 | 100000 | 600 | 0.05
Spreadsheet: 35681d1233262395-accruals-formula-help-lucky-guess-for-once
Sheet: Sheet1

 |  | 2009-01-01 00:00:00 |  |  |  |  |  | 2009-02-01 00:00:00 |  |  |  | 2009-01-01 00:00:00
 |  | Bal. Forward | Accrued | Used | Remaining |  |  | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining
Employee | Hire Date
[NAME] | 2007-12-15 00:00:00 |  | 19.92 |  | 19.92 |  |  | 19.92 | 19.92 |  | 39.84 | 39.84 | 19.92 |  | 59.75999999999999
[NAME] | 2006-06-17 00:00:00 |  | 19.92 |  | 19.92 |  |  | 19.92 | 19.92 |  | 39.84 | 39.84 | 19.92 |  | 59.75999999999999
[NAME] | 2005-03-01 00:00:00 |  | 30 |  | 30 |  |  | 30 | 30 |  | 60 | 60 | 30 |  | 90
 |  |  |  |  | Manual Entry
 |  | cat!
 |  |  |  |  |  |  |  |  |  |  | Remaining Col.' should automate in 'Bal Forward Col.'
 |  |  |  |  |  |  |  |  |  |  | Remaining Col.' = sum [NAME]. Forward + Accrued - used
mew!----- |  |  |  |  | This table is used to reference the appropriate number by # of months
 |  |  |  | 0 | 0.83
 |  |  |  | 37 | 1.25
 |  |  |  | 61 | 1.67
Spreadsheet: 249909d1373655508-get-total-quantity-of-parts-that-match-list-example-multiple-lookup-criteria
Sheet: Desired BOM

Part No | Drawing No | Description |  | Qty
02P14008 | - | COMP 2DB3F25KL-TFD-C27 |  | 3
02P14023 | - | COMP 2DF4S11ML-TFD-C27 |  | 2
02P14099 | - | COMP 3DPHR12ML-TFD-C27 |  | 2
02P14085 | - | COMP 3DJHF33KL-TFD-C27 |  | 1
02P14237 | - | COMP 4DHDF63KL-TSK-C27 |  | 2
02P14195 | - | COMP 6DH3R35ML-TSK-C27 |  | 2
 | Compressor Accessories
32A18021 | 003-2154-00 | Muffler Plate (9R,2D) |  |  |  | 5
32A18022 | 003-0107-00 | Muffler Plate (9R,3D) |  |  |  | 3
32A18023 | 003-0382-00 | Muffler Plate (4R,4D) |  |  |  | 2
32A18024 | 003-0383-00 | Muffler Plate (6R,6D) |  |  |  | 2
Spreadsheet: 845460d1696965926-calculating-total-sum-of-item-within-a-date-range-gites
Sheet: Data

Direct |  | 1
Booking |  | 2 |  | BACS
 |  | 3 |  | Cheque
 |  | 4 |  | Cash
 |  | 5 |  | CB
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
1 | Cabernet | 60 | 3 | 2 | 6
2 | Grenache | 60 | 3 | 2 | 6
3 | Carignan | 60 | 3 | 2 | 6
4 | Cinsault | 60 | 3 | 2 | 6
5 | Sauvignon | 50 | 2 | 1 | 5
6 | Chardonnay | 60 | 3 | 2 | 6
7 | Merlot | 60 | 3 | 2 | 6
8 | [NAME] | 50 | 2 | 1 | 5
9 | Pinot | 60 | 3 | 2 | 6
10 | Picpoul | 70 | 3 | 2 | 6
11 | Muscat | 70 | 3 | 2 | 6
12 | Viognier | 75 | 3 | 2 | 6
Spreadsheet: c94412d9-dbb6-4f9d-bd4e-05164f0e748c
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
HP | Test | HP | [NAME], Mutation Screen | [NAME], Mutation Screen | Polymerase Chain Reaction (PCR)/DNA Sequencing Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA OR Yellow-Top (ACD) Tube: ACD OR |  |  | 3 | mL | [NAME] must arrive within 96 hours of draw.   Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms:	 1. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 3. If not ordering electronically, submit a Molecular Genetics Request Form (Supply T245) with the specimen. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Wednesday; 10 a.m. | 14 days | 20 days | 1 | 81401 |  |  |  |  | Rochester
HP | [NAME] | VARIES | Varies |  |  |  | Ambient
HP | Result | 17357 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
HP | Result | 17358 | [NAME] | [NAME] | Alphanumeric
HP | Result | 17359 | Source | Source | Alphanumeric
HP | Result | 17360 | Order Date | Order Date | Alphanumeric
HP | Result | 17361 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
HP | Result | 17362 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
HP | Result | 17363 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22070-7
HP | Result | 17364 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9
HP | Result | 17365 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
HP | Result | 17366 | Reviewed By: | Reviewed By: | Alphanumeric
HP | Result | 17367 | Release Date | Release Date | Alphanumeric
Spreadsheet: 202697d1356697009-formula-to-ship-product-when-cumulative-tonnage-reaches-a-certain-level-ghozi-28122012-product-shipment-example
Sheet: Sheet1

 | Manufacture
 |  | Week 1 | Week 2 | Week 3 |  | Week 4
 | Product A | 2000 | 3000 | 2000
 | Product B | 3000 | 2000 | 3000
 | Product C | 4000 | 5000 | 5000
 | Cumulative
 | Of which
 | Product A
 | Product B
 | Product C
 | Shipment | 0 | 0 | 25000
 | Of which
 | Product A | 0 | 0
 | Product B | 0 | 0
 | Product C | 0 | 0
Spreadsheet: 97062d1296249729-merge-and-update-data-from-tabs-conan
Sheet: AD Updated with SAP

GivenName | LastName | Initials | Office | [NAME] | WorkPhone | City | Title | Department | EmployeeNumber | DisplayName | Login | Pwdlastset | Lastlogon | Description
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [NAME]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]
 |  |  |  | [NAME]
 |  |  |  | [EMAIL]
 |  |  |  | [EMAIL]