tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: rick_buy__32812__NP Daily Marks
Sheet: Breakdown

The New Power Company
Breakdown by Product
 |  |  |  | Per CAS | Capacity Corr. |  |  | Per CAS | Capacity Corr. |  |  | Per CAS | Capacity Corr. |  |  | Per CAS | Capacity Corr. |  |  | Per CAS | Capacity Corr. |  |  | Per CAS |  |  |  | Per CAS
 | COB 8/27/01 | COB 8/28/01 |  | COB 8/29/01 | COB 8/29/01 | Difference |  | COB 9/4/01 | COB 9/4/01 | Difference |  | COB 9/6/01 | COB 9/6/01 | Difference |  | COB 9/10/01 | COB 9/10/01 | Difference |  | COB 9/12/01 | COB 9/12/01 | Difference |  | COB 9/17/01 | COB 9/17/01 | Difference |  | COB 9/18/01 | COB 9/18/01 | Difference | COB 9/19/01 | COB 9/20/01 | COB 9/21/01 |  | COB 9/24/01 | COB 9/25/01 | COB 9/26/01 |  | Daily Change
Financial MTM | 49947286 | 55858213 |  | 57692146 | 57692146 |  |  | 46484930 | 46484930 |  |  | 46043210 | 46043210 |  |  | 44910437 | 44910437 |  |  | 42269727 | 42269727 |  |  | 41763715 |  |  |  | 48406572 |  |  |  | 54912946 |  |  | 61351647 | 58563560 | 61524394
Gas MTM | 4691838 | 4946778 |  | 5061950 | 5061950 |  |  | 4923532 | 4923532 |  |  | 4872850 | 4872850 |  |  | 10151598 | 10151598 |  |  | 4747637 | 4747637 |  |  | 5004111 |  |  |  | 5458453 |  |  | 5910950 | 5809999 | 5739531 |  | 6028749 | 5827560 | 5911700
Gas Purchases |  | -596668 |  | -601718 | -601718 |  |  | -1209051 | -1209051 |  |  | -1333842 | -1333842 |  |  | -1333845 | -1333845 |  |  | -1333852 | -1333852 |  |  | -1333861 |  |  |  | -1408374 |  |  | -804194 | -804194 | -804191 |  | -804191 | -804191 | -804200
Gas Sales |  | 7435080 |  | 7435080 | 7435080 |  |  | 15290816 | 15290816 |  |  | 15053482 | 15053482 |  |  | 15054186 | 15054186 |  |  | 15054427 | 15054427 |  |  | 15060666 |  |  |  | 15066560 |  |  | 8027587 | 8033044 | 8056777 |  | 8059302 | 8072455 | 8088001
Total Gas
Power MTM | 52787394 | 54029592 |  | 54402992 | 54402992 |  |  | 53378304 | 53378304 |  |  | 7690871 | 7690871 |  |  | 48353305 | 48353305 |  |  | 46016089 | 46016089 |  |  | 37433537 |  |  |  | 45334327 |  |  | 49514316 | 51629206 | 51512135 |  | 54909855 | 55022682 | 54802409
Power Purchases | -82546945 | -85660468 |  | -88773990 | -18720422 |  |  | -102241362 | -19885207.79999999 |  |  | -37773032 | -19885207.79999999 |  |  | -45558719 | -19885207.79999999 |  |  | -53584206 | -19885207.79999999 |  |  | -66720218 | -19885207.79999999 |  |  | -50001684 | -19885207.79999999 |  | -6923427.8 | -7158407.8 | -7623547.8 |  | -7858527.8 | -8093507.8 | -8328487.799999992
Power Sales | 108806923 | 112835527 |  | 116864132 | 16183721 |  |  | 135064396 | 16702984 |  |  | 41539165 | 16702984 |  |  | 52171599 | 16702984 |  |  | 62833553 | 16702984 |  |  | 80573957 | 16702984 |  |  | 67422539 | 16702984 |  | 5220184 | 5267164 | 5378584 |  | 5425564 | 5472544 | 5519524
Total Power
Total Exposure
Treashold Amt. | -15000000 | -15000000 |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
Collateral Posted | -87300000
Margin due to ENE
Spreadsheet: 214107d1360799488-auto-fill-in-book1
Sheet: Sheet1

Product | Commercial name | Client | Broker | Country | Dosage | Box
Paracetamol | Clotilde | [NAME] | Sonae | Tunisia | 50 | 21 AM
Paracetamol | Clotilde | [NAME] | Sonae | Tunisia | 50 | 21
Paracetamol | Clotilde | [NAME] | Sonae | Tunisia | 50 | 105
Paracetamol | Clotilde | [NAME] | Sonae | Tunisia | 100 | 21 AM
Spreadsheet: 91678d1291334659-solution-to-if-statement-when-no-match-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | INPUT |  |  | RESULT
 |  |  |  |  |  |  |  |  |  |  |  |  | 105 |  |  | 5.75
 |  |  |  |  | 1min | 60 |  |  |  |  |  | Input
 |  |  |  |  | Diff in Min | Diff in Sec |  | Diff in MM | MM/Sec |  |  | Diff in MM
 | 5 | 300 | 111
 |  |  |  |  | 1 | 60 |  | 8 | 7.5 |  |  | 6 | 45 | 345 |  | 5.75
 | 6 | 360 | 103
 |  |  |  |  | 4 | 240 |  | 18.40000000000001 | 13.04347826086956 |  |  | -2 | -26.08695652173912 | 333.9130434782609 |  | 5.565217391304348
 | 10 | 600 | 84.6
 |  |  |  |  | 10 | 600 |  | 21.89999999999999 | 27.39726027397261 |  |  | -20.40000000000001 | -558.9041095890415 | 41.09589041095853 |  | 0.6849315068493088
 | 20 | 1200 | 62.7
 |  | NEED TO FINISH OFF FORMULA FOR CEL "Q2", IF INPUT CELL "N2" DATA IS GREAT THAN "D9" THAN = 5
 |  | Solution to if statement when no match
Spreadsheet: 43924d1242585197-variable-cell-reference-10day
Sheet: Sheet1

date | S&p | 10day
1928-11-21 00:00:00 | 280.53 | 0
1928-11-22 00:00:00 | 290.34 | 0
1928-11-23 00:00:00 | 288.22 | 0
1928-11-26 00:00:00 | 291.16 | 0
1928-11-27 00:00:00 | 292.39 | 0
1928-11-28 00:00:00 | 295.62 | 0
1928-11-30 00:00:00 | 293.38 | 0
1928-12-03 00:00:00 | 289.23 | 0
1928-12-04 00:00:00 | 291.3 | 0
1928-12-05 00:00:00 | 290.68 | (a11-10) |  | date in a11 minus 10 days
1928-12-06 00:00:00 | 279.79 |  |  | then average columb be from current row to what cell was returned in previous date funcion
1928-12-07 00:00:00 | 271.05
1928-12-10 00:00:00 | 263.95
1928-12-11 00:00:00 | 269.34
1928-12-12 00:00:00 | 266.82
1928-12-13 00:00:00 | 266.88
1928-12-14 00:00:00 | 272.26
1928-12-17 00:00:00 | 270.23
1928-12-18 00:00:00 | 275.41
1928-12-19 00:00:00 | 280.5
1928-12-20 00:00:00 | 282.01
1928-12-21 00:00:00 | 286.53
1928-12-24 00:00:00 | 287.89
1928-12-26 00:00:00 | 286.13
1928-12-27 00:00:00 | 290.95
1928-12-28 00:00:00 | 296.52
1928-12-31 00:00:00 | 300
Spreadsheet: 277955d1384489238-need-help-sorting-data-sample
Sheet: Sheet1

PhoneNumber | FirstName | LastName | Address | City | State | [NAME] | [NAME] | Gender | Group | Date | TextMsg
12407987034 |  |  |  | District Heights | MD
12404987136 | [NAME] | Smith |  |  |  |  | [EMAIL]
12404987136 | [NAME] | Smith |  |  |  |  | [EMAIL]
12404987136 |  |  |  | Gaithersburg | MD | 20885
12404987136 | [NAME] | Smith | 19307 Any Drive Pl. | Montgomery Village | MD | 20886
12404987136 | [NAME] | Smith |  | Montgomery Village | MD | 20886 | [EMAIL] |  |  | 2012-11-18T16:48:55 | No Text
12405063883 | [NAME] | Jones |  | Churchton | MD |  | [EMAIL]
12405063883 | [NAME] | Jones |  |  |  |  | [EMAIL] |  | Waitlist
12405063883 | [NAME] | Jones | 123 Adams Dr | College Park | MD | 20740
12405652588
12405652588 |  |  |  | District Heights | MD | 20747
12405652588 | [NAME] | Adams | 4567 Main Circle Court Apt 101 | Forestville | MD | 20747
12405652911 |  |  |  |  | NULL
12405652911 |  |  |  | Upper Marlboro | MD | 20772
12405938400 | Kelly | [NAME] |  |  |  |  | [EMAIL]
12405938400 | Kelly | [NAME] |  |  |  |  | [EMAIL] |  | Premium Seating
12405938400 | Kelly | [NAME] | 7891 Moontown Dr Apt B | Laurel | MD | 20723
12405953189 | [NAME] | [NAME] | False | False |  |  | [EMAIL]
12405953189 | [NAME] | [NAME] |  | Lanham | MD | 20706 | [EMAIL] |  |  | 2012-11-02T14:14:31 | No Text
12406015800
12406015800 | [NAME] | South | 1805 Castle Way | Potomac | MD | 20854
12406015800 | [NAME] | South | 29 Rolling High Way | Olney | MD | 20832 | [EMAIL] |  |  | 2013-08-19T19:21:44 | No Text
12406016800 |  |  |  |  |  |  |  |  | Premium Seating
12406016800 | [NAME] | Jones |  | Potomac | MD | 20854
12406016800 | [NAME] | Jones | 34 [NAME] | Potomac | VA | 20832 | [EMAIL] |  | Special Offers | 2013-08-19T19:21:44 | No Text
Spreadsheet: 685978d1594302307-automatic-change-billing-format-in-excel-bill-format
Sheet: STST003

SUN JEWELLERY
#20/1 NEW STREET, NAGA
TEL: [PHONE]
CUSTOMER DETAILS: |  |  |  |  |  |  |  | Date : |  | ESTIMATE BILL FORMATE WITH OLD PURCHASE
Mr/Mrs. Iqbal M |  |  |  |  |  |  |  | Est No: | STST003
Contact : [PHONE] |  |  |  |  |  |  |  | Gold Per Grm : | 4680
India |  |  |  |  |  |  |  | Silver Per Grm : | 54
ESTIMATE
S.No. | [NAME] | PCS | PURITY | RATE | GRS.WT | NET.WT | WASTAGE | HALL MARK | AMOUNT
1 | Chain | 1 | 916 | 4610 | 8 |  | 0.1 | 250
 |  |  |  |  |  |  |  | Total
OLD PURCHASE
S.No. | [NAME] | PCS | PURITY | RATE | GRS.WT | NET.WT |  | AMOUNT
1 | Earing | 1 | 916 | 4600 | 8 | 4
 |  |  |  |  |  |  |  | Less Purchase
 |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  | Less Discount | 418
 |  |  |  |  |  |  |  | Net Amount
 |  |  |  |  |  |  |  | Cash Received | 24000
 |  |  |  |  |  |  |  | [NAME] | 2000
 |  |  |  |  |  |  |  | Net Amount
Spreadsheet: 827359d1682627396-baseball-league-spreadsheet-test-run
Sheet: Schedule

 |  |  |  | STANDINGS
Team # | Team Name |  |  | Place | Team Name |  | W | L | T | FW | FL | Pts | RF | RA | +/- |  |  |  |  | Team Name |  | W | L | T | FW | FL | Pts | RF | RA | +/- | Rank
1 | Freeguy |  |  | 1st
2 | Assassins |  |  | 2nd
3 | Gurus |  |  | 3rd
4 | Tigers |  |  | 4th
5 | Cardinals |  |  | 5th
6 | Tetras |  |  | 6th
7 | Ramrod |  |  | 7th
8 | Mismatched |  |  | 8th
9 | Outliers |  |  | 9th
SCHEDULE
2022-02-05 00:00:00 | Diamond | Home |  | Score | Visitor |  | Score
18:00:00 | 1
18:00:00 | 2
19:00:00 | 1
19:00:00 | 2
20:00:00 | 1
20:00:00 | 2
21:00:00 | 1
21:00:00 | 2
Spreadsheet: 473998d1470568419-formula-for-top-5-values-with-countif-sample-gk
Sheet: Calc

Calculations |  |  |  |  |  |  |  | Charts | List of ways to Compare
 |  |  |  |  |  |  |  | Total Volume
 |  |  |  |  |  |  |  | Problem Area
Compare by |  | Option 1 |  | Option 2 |  |  |  | Problem Type
 | 1 | 0 |  |  |  |  |  | Week
 |  |  |  |  |  |  |  | Avg Daily Open Escaltions
Date
 | Total Vol |  |  | Weekday |  |  | Problem Type
Date | Vol | Midwest | Midwest | Probem Area |  |  | Problem Type
2016-04-01 00:00:00
Spreadsheet: 842773d1694766576-stacking-dynamic-data-from-multiple-columns-to-one-sf501
Sheet: Sheet1

 | Assignment No. | AE1 | AE2 | AE3
 | Total Point | 40 | 50 | 10
1 | S001 | 20 | 35 | 10
2 | S002 | 22 | 32 | 10
3 | S003 | 33 | 33 | 10
4 | S004 | 34 | 34 | 9
5
6
7
8
9
10
11
Spreadsheet: 104177d1301831953-keep-raw-of-maximum-value-keep-maximum-value
Sheet: Sheet1

shipper | Responsible | Value
4 YOU CLOTHING LTD | Hossain, [NAME] | 1
786 GARMENTS & TEXTILES | [NAME], [NAME] | 1
A & A TROUSERS LTD | [NAME], [NAME] | 1
A G DRESSES LTD | Zahir, [NAME] | 1
A J SUPER GARMENTS LTD | [NAME], Binoy Krishna | 2
A K M KNITWEAR LTD | Hossain, [NAME] | 1
A K M KNITWEAR LTD | [NAME], [NAME] | 3
A M DESIGN LTD | Barman, Nilmani | 1
A M DESIGN LTD | [NAME], [NAME] | 2
A PLUS INDUSTRIES LTD | Barman, Nilmani | 1
A T S APPARELS LTD | Awal, [NAME] | 1
A T S APPARELS LTD | [NAME], [NAME] | 2
A T S APPARELS LTD | Zahir, [NAME] | 1
Spreadsheet: 734309d1622103347-help-with-formula-to-flag-differences-in-time-sample-1-
Sheet: Sheet1

Date/Time | Diff | Flag
07/09/2019 16:24:00 |  | 1
07/09/2019 16:26:00 |  |  |  |  |  |  |  | 0
07/09/2019 16:30:00 |  |  |  |  |  |  |  | 1
07/09/2019 16:33:00 |  |  |  |  |  |  |  | 0
07/09/2019 16:42:00 |  |  |  |  |  |  |  | 1
07/09/2019 16:50:00 |  |  |  |  |  |  |  | 1
07/09/2019 17:30:00 |  |  |  |  |  |  |  | 1
07/09/2019 18:10:00 |  |  |  |  |  |  |  | 1
07/09/2019 18:15:00 |  |  |  |  |  |  |  | 1
07/09/2019 18:30:00 |  |  |  |  |  |  |  | 1
07/09/2019 20:00:00 |  |  |  |  |  |  |  | 1
14/09/2019 12:22:00 |  |  |  |  |  |  |  | 1
14/09/2019 12:53:00 |  |  |  |  |  |  |  | 1
14/09/2019 12:58:00 |  |  |  |  |  |  |  | 1
14/09/2019 13:09:00 |  |  |  |  |  |  |  | 1
14/09/2019 13:16:00 |  |  |  |  |  |  |  | 1
14/09/2019 13:25:00 |  |  |  |  |  |  |  | 1
14/09/2019 13:37:00 |  |  |  |  |  |  |  | 1
14/09/2019 14:03:00 |  |  |  |  |  |  |  | 1
14/09/2019 14:12:00 |  |  |  |  |  |  |  | 1
14/09/2019 14:15:00 |  |  |  |  |  |  |  | 0
14/09/2019 14:19:00 |  |  |  |  |  |  |  | 1
14/09/2019 14:26:00 |  |  |  |  |  |  |  | 1
14/09/2019 14:35:00 |  |  |  |  |  |  |  | 1
14/09/2019 14:47:00 |  |  |  |  |  |  |  | 1
14/09/2019 14:50:00 |  |  |  |  |  |  |  | 0
14/09/2019 14:58:00 |  |  |  |  |  |  |  | 1
14/09/2019 15:01:00 |  |  |  |  |  |  |  | 0
14/09/2019 15:10:00 |  |  |  |  |  |  |  | 1
14/09/2019 15:22:00 |  |  |  |  |  |  |  | 1
14/09/2019 15:30:00 |  |  |  |  |  |  |  | 1
14/09/2019 15:32:00 |  |  |  |  |  |  |  | 0
14/09/2019 15:34:00 |  |  |  |  |  |  |  | 1
14/09/2019 15:38:00 |  |  |  |  |  |  |  | 0
14/09/2019 15:44:00 |  |  |  |  |  |  |  | 1
Spreadsheet: 122014d1316551995-indirect-erep_1gb-tigrovi_bkp
Sheet: sas2208

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
sas2208
offlinesas2208
Add as a friend Send message Donate
Experience level 26
9,109 / 10,000
Location: CroatiaCroatia, [NAME]: CroatiaCroatia
eRepublik birthday
Jun 24, 2009
National rank: 1572
No political activity
HV 1.GB Tigrovi HV 1.GB Tigrovi
No media activity
Friends(59)
[NAME]
delboy1512
dilbert
Marius Black
big_konj
[NAME]
cloudVII
mlatonja
bhmax
view all
Land of sas2208: 13 buildings
Visit
Achievements
hard worker
14
Hard Worker
Worked 30 days in a row
congressman
Congress Member
Win the Congress elections
president
Country President
Win the Presidential elections
media mogul
Media Mogul
Reach 1000 subscribers to your newspaper
battle hero
Battle Hero
Reach the highest war influence in a battle
campaign hero
Campaign hero
Reach the highest war influence in a campaign
resistance hero
Resistance Hero
Start a resistance war and liberate that region
super soldier
10
Super Soldier
Advance 250 strength points
society builder
Society Builder
Invite 10 people to eRepublik and help them reach level 10
mercenary
Mercenary
Defeat 25 enemies for 50 different countries
Coming soon
Coming soon
Military Skills
Strength
2,570.65
Super soldier:2,570 / 2,750
Rank
Colonel *Colonel *
Rank points:
401,360 / 435,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 688684d1595906506-using-data-validation-to-link-data-to-different-locations-excel-help-2-1-
Sheet: Financing Structure & Fees Ass.

Financing Structure
 | Structure
Sources of Funds | Structure 1 | Structure 2 | Structure 3 | Structure 4 | Status Quo
Revolving Credit Facility Size | 250 | 250 | 250 | 250
Revolving Credit Facility Draw
Term Loan A |  | 500
Term Loan B | 2150 | 1650 | 2100 | 1750
Term Loan C
2nd [NAME]
Senior Notes | 1500 | 1500 | 700 | 1000
Senior Suboridinate Notes |  |  | 700 | 1000
Senior Bridge Facility
Senior Subordinate Bridge Facility
Equity Contribution | 2100 | 2100 | 2250 | 2250
Rollover Equity
Cash and Cash Equivalents | 250 | 250 | 250
Total Sources of Funds
Uses of Funds
Equity Purchase Price | 4350 | 4350 | 4350 | 4350 | 4350
Existing Bank Debt | 1000 | 1000 | 1000 | 1000 | 1000
Existing Bond Debt | 500 | 500 | 500 | 500 | 500
Existing Mezzanine Debt | 0 | 0 | 0 | 0 | 0
Tender / Call Premiums | 20 | 20 | 20 | 20 | 20
Deferred Financing Fees | 90 | 90 | 90 | 90 | 90
Other Fees and Expenses | 40 | 40 | 40 | 40 | 40
Total Use of Funds
Financing Fees
 |  | Fees
 | Structure 1 | Size | (%) | ($)
Revolving Credit Facility Size |  |  | 0.015
Term Loan A |  |  | 0.015
Term Loan B |  |  | 0.015
Term Loan C |  |  | 0.015
2nd [NAME] |  |  | 0.0225
Senior Notes |  |  | 0.0225
Senior Suboridinate Notes |  |  | 0.0225
Senior Bridge Facility |  | 1500 | 0.01
Senior Subordinate Bridge Facility |  | 0 | 0.01
Other Financing Fees & Expense |  |  |  | 5.3
Total Financing Fees
Amortization of Financing Fees
 | Term | Year 1 2013 | Year 2 2014 | Year 3 2015 | Year 4  2016 | Year 5 2017 | Year 6  2018 | Year 7  2019 | Year 8 2020 | Year 9  2021 | Year 10 2022
Revolving Credit Facility Size | 6
Term Loan A
Term Loan B | 7
Term Loan C
2nd [NAME]
Senior Notes | 8
Senior Suboridinate Notes
Senior Bridge Facility | 8
Senior Subordinate Bridge Facility
Other Financing Fees & Expense | 8
Annual Amortization
Spreadsheet: 109113d1306037633-excel-2007-couting-incidents-based-on-age-bennyharassi2
Sheet: Summary

 | All Tickets
Technicians | High | Medium | Low | Total |  |  |  |  |  |  | Sensitive | Pending | In Progress | Assigned | Resolved |  | New Hires | Exiting Employees
test 1
test 2
test 3
test 4
test 5
test 6
test 7
test 8
test 9
test 10
test 11
test 12
 | [NAME] |  |  | % |  |  | Ticket Age
 | In Process |  |  |  |  |  | 2
 | Missed Goal |  |  |  |  |  | 5
 | Pending |  |  |  |  |  | 10
 | Warning |  |  |  |  |  | 15
 | Attached |  |  |  |  |  | 20
 | Detached |  |  |  |  |  | 30
 |  |  |  |  |  |  | over 30
Spreadsheet: 453989d1459556797-create-custom-auto-fill-formulas-in-excel-2010-options-trading
Sheet: Sheet1

date | description |  | stock price | option price | strike price | break even | stock contract price | option premium | commis- sion | closing price adjust- ments | cash balance | account balance
2016-03-17 00:00:00 | open account |  |  |  |  |  |  |  |  |  | 50000 | 50000
 | buy 100 shares RPM @ 44.69 |  | 44.69 |  | 45 |  | -4469 |  | -4.95
 | sell 4/15 $45 strike price call @ .75
 |  |  |  | 0.75 |  |  |  | 75 | -0.5
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Warren

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 194322d1353102452-aline-data-across-a-sheet-book2
Sheet: Sheet1

 |  |  |  | This is basically what I have
DIS Report |  |  | ELS |  |  | Fastline |  |  | CRM
Stock Number | Model | List Price | Stock Number | Model | List Price | Stock Number | Model | List Price | Stock Number | Model | List Price
14641 | DC75LT | 65000 | 14470 | 36" | 4200 | 6651 | PRIME | 1000 | 17557 | 8585 | 34500
14645 | DC95XLT | 70000 | 14499 | DC95 | 65000 | 10616 | 350 | 200 | 17571 | 7510 | 7900
14653 | B-6T | 6845 | 14545 | MWL31-1A | 4750 | 10666 | 9000 | 69900 | 17573 | 4-16 | 1000
14722 | 445CT | 39500 | 14618 | DC75LT | 65000 | 11134 | SM2000HD | 4420 | 17592 | GR484 | 6495
14828 | SK50SR-3 | 39950 | 14633 | E68 | 39500 | 11829 | 9000 | 39500 | 17618 | PH14FT | 2505
14892 | C150HX4 | 19900 | 14641 | DC75LT | 65000 | 12284 | 9000 | 39500 | 17622 | 2388
14895 | H90XM | 11500 | 14645 | DC95XLT | 70000 | 12357 | CH150x4 | 17000 | 17625 | TRX175 | 6895
 | Below is what I need (CRM dosen't have data that would line up with the others so that would remain blank in this little sample)
DIS Report |  |  | ELS |  |  | Fastline |  |  | CRM
Stock Number | Model | List Price | Stock Number | Model | List Price | Stock Number | Model | List Price | Stock Number | Model | List Price
14641 | DC75LT | 65000 | 14641 | DC75LT | 65000 | 14641 | DC75LT | 65000
14645 | DC95XLT | 70000 | 14645 | DC95XLT | 70000 | 14645 | DC95XLT | 70000
14653 | B-6T | 6845 |  |  |  | 14653 | B-6T | 6845
14722 | 445CT | 39500 | 14722 | 445CT | 39500 | 14722 | 445CT | 39500
14828 | SK50SR-3 | 39950 | 14828 | SK50SR-3 | 39950
14892 | C150HX4 | 19900 | 14892 | C150HX4 | 19900 | 14892 | C150HX4 | 19900
14895 | H90XM | 11500 | 14895 | H90XM | 11500 | 14895 | H90XM | 11500
Spreadsheet: bea6de7d-f70e-499a-8047-c534e14cabe4
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
P53KM | Test | P53KM | TP53 Gene, Known Mutation | TP53 Gene, Known Mutation | Polymerase Chain Reaction (PCR) Amplification Followed by DNA (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA Yellow-Top (ACD) Tube: ACD |  |  | 3 | mL | This test can only be performed if a mutation has previously been identified in a family member of this individual.  [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-Colon Cancer 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. | 1 mL | Note: No specimen should be rejected. If specimen is received in wrong anticoagulant or at an inappropriate temperature, include note to laboratory. If questions, contact laboratory. | An interpretive report will be provided. | Wednesday; 10 a.m. | 10 days | 16 days | 1 | 81403 |  |  |  |  | Rochester
P53KM | [NAME] | VARIES | Varies |  |  |  | Ambient
P53KM | Result | 34197 | Reason for Referral | Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
P53KM | Result | 34198 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
P53KM | Result | 34199 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
P53KM | Result | 34200 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
P53KM | Result | 34201 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
P53KM | Result | 34202 | [NAME] | [NAME] | Alphanumeric
P53KM | Result | 34203 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
P53KM | Result | 34204 | Reviewed By | Reviewed By | Alphanumeric
P53KM | Result | 34205 | Release Date | Release Date | Alphanumeric
Spreadsheet: 832868d1686649340-is-it-possible-to-make-the-reference-element-of-an-offset-formula-dynamic-offset-issue
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | start ref | end ref
 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  |  |  | 5
 |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | sum
 |  |  |  |  |  | 351.36978 | 398.26435 | 446.7180699999999 | 391.61136 | 361.29847 | 398.94532 | 390.0334300000001 | 388.10408 | 397.2278599999999 | 370.51434 | 397.9263799999999 | 342.2486699999999 |  |  | formula
Spreadsheet: 174119d1344937511-need-help-with-some-conditional-formatting-client-tracker-2012
Sheet: Sheet2

 | Clients Name | Offered  Hep B test? | [NAME] count | Date of vaccination
 | [NAME] | Yes | Two Vaccination
 | xxxx | Refused
 | yyyyy | Immunised already | Course completed
 | cccccccc | Acquired immunity | Course completed
 | wwwwww | Yes
 | bbbbbbb | Yes
 | kkkk | Yes | Three Vaccination
 | llll | Yes | One Vaccination
 | [NAME] | Refused