tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: theresa_staab__39598__Producer Pricing Detail Nov01
Sheet: Kennedy Gas Daily Pricing

Kennedy Oil
Gas Daily Pricing for October 2001
 |  |  | Medicine Bow fuel = | 0.0068
 |  |  | Medicine Bow expansion volumes @ GD + $0.10
 | Gas Daily Discount on Swing Volumes |  | @ Glenrock (MMBtu) | @ Dull Knife ([NAME])
2001-10-01 00:00:00 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
 | -0.05 |  |  | 2190
Spreadsheet: 64052d1264909056-employees-project-report-summary-explain-new
Sheet: Summary Total

IN THE PROJECT COLUMN WILL BE ALL THE POSSIBLE VALUES THAT COULD BE FOUND ON ALL WORKBOOKS AND SPREADSHEETS BETWEEN A13:A18 | IN THE TOTAL COLUMN WILL CALCULATE THE AMOUNT OF HOURS THAT EVERY EMPLOYEE HAS SPENT THROUGHOUT THE YEAR |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
PROJECTS | ALL EMPLOYEES TOTAL | IMPORTANT
CR001 | 42.5 | In Cell B9 is where we want the hours to be displayed. So for example we need to look in the john worksheet,tony worksheet,[NAME],[NAME] and susan worksheet [NAME] cells A13:A18 and find the project CR001 and add the total amount of the hours(which could be between G13:G18) and display it to me.
CR002 | 28.5
CR003 | 18
CR004 | 30
CR005 | 30 | IF THE FORMULA IS CORRECT THE WE WILL SEE IN CELL B9  42.5. AND HERE HOW THIS AMOUNT CAME FROM ( In [NAME]'s worksheet found out than CR001 total is 5hours, in tony's worsheet found out that CR001 totals to 6.5hours, in Dany's worksheet found out that CR001 totals to  14hours, in [NAME]'s worksheet found out that CR001 totals to 8hours and in [NAME]'s worksheet found out CR001 totals 9hours. Now we add the hours= 5+6.5+14+8+9 which gives us 42.5 .
CR006 | 6 | IN CELL B10 WILL SEE THE AMOUNT OF 28.5
CR007 | 9 | IN CELL B11 WILL SEE THE AMOUNT OF 18
CR008 | 8
CR009 | 0 | IF WE MANAGE TO GET THIS FORMULAS TO WORK WILL WE BE ABLE TO CONNECT 400 DIFFERENT WORKSHEETS TOGETHER AS THEY WILL BE IN DIFFENERNT PLACE AND IF YES HOW?
CR010 | 14
CR011 | 0
CR012 | 0
[NAME] | 0
CR014 | 0
CR015 | 0
CR016 | 0
CR017 | 0
CR018 | 0
CR019 | 0
CR020 | 0
CR021 | 0
[NAME] | 0
CR023 | 0
CR024 | 0
CR025 | 0
CR026 | 0
CR027 | 0
CR028 | 0
CR029 | 0
[NAME] | 0
Spreadsheet: 266526d1379646111-index-match-issue-notconcatenate
Sheet: Before

 | Month | Paid Absence | Paid Holidays | Department Usage | 13B/C | Total Hours | [NAME] | Project EWW hrs
[NAME] | January
[NAME] | February
[NAME] | March
[NAME] | April
[NAME] | May
[NAME] | June
[NAME] | July
[NAME] | August
[NAME] | September
[NAME] | October
[NAME] | November
[NAME] | December
 | Total Hours
 |  |  |  | Total Lbr worked - 13B/C
Spreadsheet: 47624d1246713939-auto-copy-from-1-sheet-to-other-if-condition-met-invoicecreator
Sheet: Invoice

 | Customer Name: | [NAME] | INV # | GG1000-090001
 | Customer Address: | 1234 Main St | Phone: | (999) 123-4567
 |  | Anywhere, NY 10001 |  |  | Items | 5
 | Invoice
 | Product Code | Item Description | QTY | Price | Total | Dept
1 | 230001 | Product #1 | 14 | 1.25 | 17.5 | HR
2 | 230006 | Product #6 | 7 | 1.4 | 9.799999999999999 | HR
3 | 230011 | Product #11 | 12 | 1.8 | 21.6 | Appl
4 | 230016 | Product #16 | 3 | 2.25 | 6.75 | Appl
5 | 230028 | Product #28 | 16 | 3 | 48 | Int
6
7
8
9
10
11
12
13
14
15
 |  |  |  | SUBTOTAL | 103.65
 |  |  |  | TAX | 8.810250000000002
 |  |  |  | SHIPPING | 25
 |  |  |  | GRAND TOTAL | 137.46025
Spreadsheet: 802561d1666912829-filter-rows-for-a-value-in-one-column-that-appears-with-multiple-values-in-another-column-s666-pq-comparativepottery
Sheet: Sheet2

Field | Site
A.044.600 | As,[NAME]
A.655.520a | As,[NAME]
B.001.200a | As,[NAME]
B.032.200a | As,[NAME]
B.174.220c | As,[NAME]
B.535.220 | As,[NAME]
B.545.220b | As,[NAME]
B.575.224 | As,[NAME]
B.576.220 | As,[NAME]
B.645.224 | As,[NAME]
B.664.540a | As,[NAME]
C.142.310 | As,[NAME]
C.365.810b | As,[NAME]
C.365.810d | As,[NAME]
C.556.322 | As,[NAME]
C.596.440b | As,[NAME]
C.654.520 | As,[NAME]
C.656.540 | As,[NAME]
D.465.360 | As,[NAME]
D.546.540b | As,[NAME]
Spreadsheet: 4ec44d6a-6137-4345-9cf0-c90b58e65dc9
Sheet: 9d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis* | 896790 | 817111 | 697454 | 2015142 | 1653273 | 806092 | 347356 | 7233218
FRA | 18734271 | 10883212 | 6483051 | 5975642 | 150531 |  |  | 42226707
IRS- [NAME] | 5553519 | 5829423 | 5341409 | 26519010 | 46816008 | 36756696 | 16585206 | 143401271
OIS | 8802372 | 5824541 | 2986348 | 6578513 | 746247 | 110645 | 32474 | 25081140
VNS | <100 | 776 | 201 | 1250 | 9559 | 9016 | 12470 | 33272
Zero Coupon | 54779 | 65659 | 31816 | 139083 | 82248 | 20224 | 56212 | 450021
TOTAL | 34041732 | 23420721 | 15540279 | 41228639 | 49457867 | 37702672 | 17033718 | 218425628
Estimated gross notional amount outstanding, October 25 weekly snapshot, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 9efa270a-9b1b-476f-a899-de1a957ff0ea
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
[NAME] | Test | [NAME] | Protein, Total, Body Fluid | Protein, Total, BF | Photometric, [NAME] | Plastic vial: PlV |  |  | 1 | mL | Container/Tube: Sterile container [NAME]: 1 mL Collection Instructions: 1. Centrifuge to remove any cellular material. 2. Indicate specimen source. Additional Information: For spinal fluid, see test TPSF / Protein, Total, Spinal Fluid. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	Spinal fluid | Not applicable | Monday through Sunday; Continuously | Same day/1day | 2 days | 1 | 84157 |  |  |  |  | Rochester
[NAME] | [NAME] | BODYFL | Body Fluid |  |  |  | Refrigerated | 7 days
[NAME] | Order Question | [NAME] | [NAME] |  | Plain Text
[NAME] | Result | TPBF1 | Protein, Total, BF | Protein, Total, BF | Numeric |  |  |  |  | g/dL |  |  |  |  |  |  |  |  |  | 2881-1 | Protein:MCnc:Pt:Body fld:Qn:
[NAME] | Result | [NAME] | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14725-6 | Fluid:Type:Pt:Body fld:Nom:
Spreadsheet: 02ab4e35-02bf-4b44-a061-6eff286f5b62
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
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 2. GOODS AND SERVICES, Summary: Original, Current prices
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
Balance on goods and services ; |  |  | Original | A2717903C | 1971-07-01 00:00:00 | 2010-08-01 00:00:00 | 470 | $ Millions | FLOW | Month | 1
Credits, Total goods and services ; |  |  | Original | A2717883F | 1971-07-01 00:00:00 | 2010-08-01 00:00:00 | 470 | $ Millions | FLOW | Month | 1
Credits, Total goods ; |  |  | Original | A2717881A | 1971-07-01 00:00:00 | 2010-08-01 00:00:00 | 470 | $ Millions | FLOW | Month | 1
Credits, Rural goods ; |  |  | Original | A2717884J | 1971-07-01 00:00:00 | 2010-08-01 00:00:00 | 470 | $ Millions | FLOW | Month | 1
Credits, Non-rural goods ; |  |  | Original | A2717931L | 1971-07-01 00:00:00 | 2010-08-01 00:00:00 | 470 | $ Millions | FLOW | Month | 1
Credits, Net exports of goods under merchanting ; |  |  | Original | A2718034F | 1971-07-01 00:00:00 | 2010-08-01 00:00:00 | 470 | $ Millions | FLOW | Month | 1
Credits, Non-monetary gold ; |  |  | Original | A2718037L | 1971-07-01 00:00:00 | 2010-08-01 00:00:00 | 470 | $ Millions | FLOW | Month | 1
Credits, Total services ; |  |  | Original | A2718332C | 1971-07-01 00:00:00 | 2010-08-01 00:00:00 | 470 | $ Millions | FLOW | Month | 1
Debits, Total goods and services ; |  |  | Original | A2717891F | 1971-07-01 00:00:00 | 2010-08-01 00:00:00 | 470 | $ Millions | FLOW | Month | 1
Debits, Total goods ; |  |  | Original | A2718054R | 1971-07-01 00:00:00 | 2010-08-01 00:00:00 | 470 | $ Millions | FLOW | Month | 1
Debits, Consumption goods ; |  |  | Original | A2718056V | 1971-07-01 00:00:00 | 2010-08-01 00:00:00 | 470 | $ Millions | FLOW | Month | 1
Debits, Capital goods ; |  |  | Original | A2718126R | 1971-07-01 00:00:00 | 2010-08-01 00:00:00 | 470 | $ Millions | FLOW | Month | 1
Debits, Intermediate and other merchandise goods ; |  |  | Original | A2718182J | 1971-07-01 00:00:00 | 2010-08-01 00:00:00 | 470 | $ Millions | FLOW | Month | 1
Debits, Non-monetary gold ; |  |  | Original | A2718320V | 1971-07-01 00:00:00 | 2010-08-01 00:00:00 | 470 | $ Millions | FLOW | Month | 1
Debits, Total services ; |  |  | Original | A2718454A | 1971-07-01 00:00:00 | 2010-08-01 00:00:00 | 470 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 471361d1468969718-excel-calculation-problem-of-the-pi-value-nnsw-roadbase-blends-2014-15-16-1-
Sheet: Ballina 1141

Ballina SC Auspec
 | % Passing Sieve |  |  |  |  |  |  | % Passing | Passing Specification |  | Deviation | % Retained | [NAME] |  | Deviation
Sieve mm | Straight Blue 20mm Roadbase Through Plant (T1) | Champions Fatty | Champions Sandy | Crusher Dust | Straight Blue 20mm Roadbase Through Plant (T2) | 7mm | ROSA | Blend Result | Lower | Upper | Passing | Blend Result | Lower | Upper | Retained
26.5 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0
19 | 98 | 98 | 92 | 100 | 98 | 100 | 100 | 97.88 | 95 | 100 | 0 | 2.120000000000005
13.2 | 87 | 93 | 87 | 100 | 85 | 100 | 100 | 87.78 | 78 | 92 | 0 | 10.09999999999999 | 6 | 18 | 0
9.5 | 74 | 88 | 84 | 100 | 70 | 100 | 100 | 75.96 | 63 | 83 | 0 | 11.82000000000001 | 7 | 17 | 0
6.7 | 64 | 84 | 80 | 100 | 59 | 100 | 100 | 66.8 | 50 | 70 |  |  | 10 | 21
4.75 | 55 | 81 | 76 | 99 | 50 | 52 | 100 | 58.48 | 44 | 64 | 0 | 17.48 | 13 | 25 | 0 |  |  | ABC Ratios
2.36 | 39 | 78 | 74 | 73 | 34 | 9 | 100 | 42.44 | 35 | 55 | 0 | 16.04 | 7 | 19 | 0
0.425 | 13 | 68 | 65 | 25 | 9 | 0 | 100 | 15.8 | 14 | 23 | 0 | 26.64 | 14 | 30 | 0 |  | 37.22902921771913 | 0.3722902921771913 | 35/55
0.075 | 5 | 63 | 59 | 10 | 4 | 0 | 100 | 7.46 | 7 | 14 | 0 | 8.34 | 6 | 13 | 0 |  | 47.21518987341772 | 0.4721518987341772 | 35/55
0.0135 | 2 | 6 | 17 | 8 | 2.7 | 0 | 40 | 2.96 | 3 | 7 | -0.04000000000000004 | 4.5 | 3 | 8 | 0 |  | 39.67828418230563 | 0.3967828418230563 | 35/60
PI | 0 | 15 | 19 | 0 | 0 | 0 |  | 3.126582278481012
Ratio | 90 | 0 | 4 | 6 | 0 | 0 | 0 | 100
Spreadsheet: 709732d1608531946-how-to-find-the-maximum-value-of-the-last-6-consecutive-days-without-spaces-example2014
Sheet: Sheet1

[NAME] | 2020-12-01 00:00:00 | 2020-12-02 00:00:00 | 2020-12-03 00:00:00 | 2020-12-04 00:00:00 | 2020-12-05 00:00:00 | 2020-12-06 00:00:00 | 2020-12-07 00:00:00 | 2020-12-08 00:00:00 | 2020-12-09 00:00:00 | 2020-12-10 00:00:00 | 2020-12-11 00:00:00 | 2020-12-12 00:00:00 | 2020-12-13 00:00:00 | 2020-12-14 00:00:00 | 2020-12-15 00:00:00 | 2020-12-16 00:00:00 | 2020-12-17 00:00:00 | 2020-12-18 00:00:00 | 2020-12-19 00:00:00 | 2020-12-20 00:00:00 | 2020-12-21 00:00:00 | 2020-12-22 00:00:00 | 2020-12-23 00:00:00 | 2020-12-24 00:00:00 | 2020-12-25 00:00:00 | 2020-12-26 00:00:00 | 2020-12-27 00:00:00 | 2020-12-28 00:00:00 | 2020-12-29 00:00:00 | 2020-12-30 00:00:00 | 2020-12-31 00:00:00
 |  | 26275.43 | 100000 | 21553.257 |  | 25152.349 | 27083.554 | 25429.122 | 18790.425 | 19480.144 | 17561.242 | 22241.642 | 21808.236 | 22056.135
 | 49427.071 | 45857.486 | 41551.494 | 39839.34 |  |  | 46029.191 | 48668.461 | 36961.393 | 34507.729 | 31460.845 | 30667.831 | 31876.037 | 34445.296 | 34690.466
 | 345 | 12 | 4 |  | 19 | 3 | 5 | 15 | 12 | 18 |  | 2 | 4 | 9
Spreadsheet: 473881d1470469852-text-format-trial
Sheet: Trial

1 | CAPITAL AND RESERVES
1100 | ISSUESUBSCRIBED AND PAID UP CAP.
Ac Code | Ac Descp |  |  | Opening debit | Opening Credit | During Debit | During Credit | Closing Debit | Closing Credit
11000001 | SHARE CAPITAL NIAN IQBAL SB |  |  | 0 | 28393010 | 0 | 0 | 0 | 28393010
11000002 | SHARE CAP. MIAN HABIB IQBAL |  |  | 0 | 40942010 | 0 | 0 | 0 | 40942010
11000003 | SHARE CAP. MRS KAUSAR JABEEN |  |  | 0 | 11868010 | 0 | 0 | 0 | 11868010
11000004 | SHARE CAP. [NAME] |  |  | 0 | 19999000 | 0 | 0 | 0 | 19999000
11000005 | SHARE CAP. MRS NOUSHEEN YASEEN |  |  | 0 | 23797970 | 0 | 0 | 0 | 23797970
11000006 | SHARE CAP. AMIR RIAZ |  |  | 0 | 210000000 | 0 | 0 | 0 | 210000000
11000007 | SHARE CAP. RAMEEZ IQBAL |  |  | 0 | 15000000 | 0 | 0 | 0 | 15000000
 |  | Total : |  | 0 | 350000000 | 0 | 0 | 0 | 350000000
1320 | RESERVES
Ac Code | Ac Descp |  |  | Opening debit | Opening Credit | During Debit | During Credit | Closing Debit | Closing Credit
13200001 | UNAPPROPRIATED PROFIT/(LOSS)(2005-6) |  |  | 14235341 | 0 | 0 | 0 | 14235341 | 0
13200002 | UNAPPROPRIATED PROFIT/(LOSS)(2006-7) |  |  | 29274234 | 0 | 0 | 0 | 29274234 | 0
13200003 | UNAPPROPRIATED PROFIT/(LOSS)(2007-8) |  |  | 14031440 | 0 | 0 | 0 | 14031440 | 0
13200004 | UNAPPROPRIATED PROFIT/(LOSS)(2008-9) |  |  | 43044126 | 0 | 0 | 0 | 43044126 | 0
13200005 | UNAPPROPRIATED PROFIT/(LOSS)(2009-10) |  |  | 0 | 5356386.94 | 0 | 0 | 0 | 5356386.94
13200007 | UNAPPROPRIATED PROFIT/(LOSS)(2011-12) |  |  | 0 | 8551939.86 | 0 | 0 | 0 | 8551939.86
13200010 | UNAPPROPRIATED PROFIT/(LOSS)(2010-11) |  |  | 3075918 | 0 | 0 | 0 | 3075918 | 0
13200011 | UNAPPRPRATED PROFIT /(LOSS)(2012-2013) |  |  | 67524 | 0 | 0 | 0 | 67524 | 0
13200012 | UNAPROPRIATED PROFIT/(LOSS) (2013-14) |  |  | 66973312.77 | 0 | 0 | 0 | 66973312.77 | 0
13200013 | UNAPPROPRIATED PROFIT/(LOSS) 2014-2015 |  |  | 14357901 | 0 | 0 | 0 | 14357901 | 0
 |  | Total : |  | 185059796.77 | 13908326.8 | 0 | 0 | 185059796.77 | 13908326.8
 |  |  |  | 185059796.77 | 363908326.8 | 0 | 0 | 185059796.77 | 363908326.8
 |  | Total :
Spreadsheet: 106938d1304086865-combining-search-and-conditional-color-formatting-for-a-small-database-darkspore-squad-overview
Sheet: Squad Info

Squad 1 |  |  |  |  |  |  |  | Bio | Cyber | Necro | Plasma | Quantum |  | Sentinel
Zrin |  | Sage |  | Titan |  |  | Squad 1 |  |  |  |  |  |  | Ravager
 |  |  |  |  |  |  | Squad 2 |  |  |  |  |  |  | Tempest
Squad 2 |  |  |  |  |  |  | Squad 3
Krel |  | Maldri |  | Arakna
Squad 3
Blitz |  | Savage |  | SRS-42
Spreadsheet: 189975d1351485018-merging-averaging-a-list-of-rankings-roark-combined-rankings-moo
Sheet: Sheet1

List 1 | List 2 | Combined List | Unique List | Sorted List | Cleaned Up List | Average Ranking
google.com | google.com
facebook.com | youtube.com
youtube.com | facebook.com
yahoo.com | msn.com
amazon.com | twitter.com
wikipedia.org | yahoo.com
ebay.com | amazon.com
twitter.com | wikipedia.org
craigslist.org | microsoft.com
live.com | bing.com
linkedin.com | huffingtonpost.com
go.com | answers.com
blogspot.com | pinterest.com
bing.com | ask.com
pinterest.com | ehow.com
espn.go.com | wordpress.com
msn.com | blogger.com
aol.com | blogspot.com
tumblr.com | ebay.com
huffingtonpost.com | live.com
netflix.com | tumblr.com
cnn.com | aol.com
paypal.com | linkedin.com
ask.com | craigslist.org
apple.com | Hidden profile
bankofamerica.com | about.com
wordpress.com | weather.com
chase.com | adobe.com
weather.com | paypal.com
Spreadsheet: 104784d1302240025-pmt-formula-help-segagirl
Sheet: Goal

Opal Industries Inventory Purchase |  |  |  | So this problem looks like [NAME] bought a lot of inventory = 1.74 million bucks
Cost of Inventory | 1740220.45 |  |  | They want to pay it off in 3 years or 36 equal payments.
Period (years) | 3 |  |  | It's stupid but everybody gives percent rates in ANNUAL Percent and that is 5.5 percent annually
Interest rate (per year) | 0.055 |  |  | You have to know this is then 5.5 percent divided by 12 to get the monthly interest rate |  |  |  |  |  |  |  |  | <<See formula here
Payment (per month)
 |  |  |  | Here is the best way to do these problems.  GUESS an Answer. The answer is Payment Per Month.
Option #1 - Reduce the Loan
Amount of Loan |  |  |  | I guess ??  How about $25,000 payment per month?  So 36 payments of 25 k = |  |  |  |  |  |  |  |  | <<see formula
Period (years) |  |  |  | Guess 2 as 900k was a little short of 1.7 mil … so try 35k monthly payment === |  |  |  |  |  |  |  |  | << see formula
Interest rate (per year) |  |  |  | Closer but still short so now is the time for a formula or method.
Payment (per month) |  |  | Month | Balance | Payment | Interest | Pmt-Int
 |  |  | 1 | 1740220 | 40000 |  |  | << This first line is most important to get.  Borrowed 1.7 mil for 1 month costs 7976 (ouch) bucks.  So the 40000 payment only reduced the balance by 32023.
 |  | In Cell [NAME] is an important idea.  Balance minus Pmt - Int>> | 2 |  |  |  |  | <<Fill these next rows in by puttling down the above rows but ot E13
 |  |  | 3 |  |  |  |  | << Now grab all 4 columns and drag down to bottom of 36 months to see if our guess of 40000 per month was correct.
 |  |  | 4
 |  |  | 5 |  |  |  |  | When you get to the bottom see if it is paid off.  You will see a zero on month 37.
 |  |  | 6
 |  |  | 7 |  |  |  |  | 40000 wasn't enough so bump it to 50000 per month to see what happens.
 |  |  | 8
 |  |  | 9 |  |  |  |  | From here you need to either learn the [NAME] or learn how to use the solver.
 |  |  | 10
 |  |  | 11
 |  |  | 12
 |  |  | 13
 |  |  | 14
 |  |  | 15
 |  |  | 16
 |  |  | 17
 |  |  | 18
 |  |  | 19
 |  |  | 20
 |  |  | 21
 |  |  | 22
 |  |  | 23
 |  |  | 24
 |  |  | 25
 |  |  | 26
 |  |  | 27
 |  |  | 28
 |  |  | 29
 |  |  | 30
 |  |  | 31
 |  |  | 32
 |  |  | 33
 |  |  | 34
 |  |  | 35
 |  |  | 36
Spreadsheet: b1de2727-9f1a-406d-bc73-600055e44ece
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
CMAC | Test | CMAC | [NAME], Congenital, Blood | [NAME], Blood | [NAME] (CMA) | EDTA (lavender-top) tube: EDTA Green-Top Tube (Sodium Heparin): GrnNaHp |  |  |  |  | Specimens must arrive within 96 hours of draw.   A whole blood EDTA and a whole blood sodium heparin specimen, as well as the reason for referral, are required.   Specimen Type: Whole blood Container/Tube: Green top (sodium heparin) and lavender top (EDTA) [NAME]: 3 mL for each tube Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tubes. Forms:  1. 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. 2. [NAME] Information Sheet (Supply T665) in Special Instructions | 2 mL | Note: No specimen should be rejected. If specimen not received at appropriate temperature or in wrong anticoagulant, include note to laboratory. If questions, contact laboratory. | An interpretive report will be provided. | Samples processed Monday through Sunday. Results reported Monday through Friday, 8 a.m.-5 p.m. CST. | 8 days | 21 days | 1 | 81229 |  |  |  |  | Rochester
CMAC | [NAME] | VARIES | Varies |  |  |  | Ambient
CMAC | Order Question | CG632 | Source |  | Answer List
CMAC | Option | CG632-1 | Whole blood EDTA, Whole blood [NAME], Whole blood EDTA and [NAME] NaHep
CMAC | Order Question | CG633 | Reason For Referral |  | Plain Text
CMAC | Result | 51476 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
CMAC | Result | 51477 | [NAME] | [NAME] | Alphanumeric
CMAC | Result | CG632 | Source | Source | Alphanumeric
CMAC | Result | 51479 | Order Date | Order Date | Alphanumeric
CMAC | Result | CG633 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
CMAC | Result | 51481 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
CMAC | Result | 51482 | Results | Results | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
CMAC | Result | 51483 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
CMAC | Result | 51484 | Amendment | Amendment | Alphanumeric
CMAC | Result | 51485 | Consultant | Consultant | Alphanumeric
CMAC | Result | 51486 | Released Date | Released Date | Alphanumeric