tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 274395d1383104697-move-cell-contents-over-two-columns-when-certain-text-in-another-column-book1
Sheet: Sheet1

before
a | a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | a | a | 1 | 1 | a
a | a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | a | a | 1 | 1 | a
a | a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | a | a | 1 | 1 | a
a | a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | a | a | 1 | 1 | a
a | a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | a | a | 1 | 1 | a
a | a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | a | a | 1 | 1 | a
a | a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | a | a | 1 | 1 | a
after
a | a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | a | a | 1 | 1 | a
a | a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | a | a | 1 | 1 | a
a | a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | a | a | 1 | 1 | a
a | a | X | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | a | a | 1 |  | a | 1
a | a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | a | a | 1 | 1 | a
a | a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | a | a | 1 | 1 | a
a | a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | a | a | 1 | 1 | a
Spreadsheet: 51946d1251551250-how-to-create-a-dropdown-list-that-returns-values-that-depends-on-another-cell-sample-invoice
Sheet: Price List

Product | Type | 1 Size | 100 | 120 | 160 | 180
ABC | Bed |  | 250 | 275
ABC | Box |  | 150 | 175
ABC | Set |  | 400 | 450
ABC 2 | Bed |  | 300 | 350 | 400 | 450
ABC 2 | Box |  | 200 | 250 | 300 | 350
ABC 2 | Set |  | 500 | 600 | 700 | 800
Accessories | Pillow | 30
Accessories | Memory Pillow | 65
Accessories | Matrres Pad |  | 75 | 85 | 95 | 105
XYZ | Bed |  |  | 850 | 950 | 1050
XYZ | Box |  |  | 400 | 450 | 500
XYZ | Set |  |  | 1250 | 1400 | 1550
*** As you can see, each product has its different types. And each product with a certain type also has different size
I would like the dropdown list in the 'Invoice' workbook' in the '[NAME]' column to show ONLY the size available for
that particular product and type.
Spreadsheet: 44783d1243534461-count-the-number-of-files-in-a-specified-folder-number-of-files
Sheet: Sheet1

 | No. Of files
Main folder
Subfolders:
Subfolder A:
100
99
98
97
96
Subfolder B:
100
99
98
97
96
Subfolder C:
100
99
98
97
96
Subfolder D:
100
99
98
97
96
Spreadsheet: 805935d1669023474-countifs-with-date-rules-listing
Sheet: IN-OUT

Total | X | Y | Z
IN
Exit
OUT in 1 year | ??? | ??? | ???
Category | Entry date | Exit date
X | 2021-04-21 00:00:00 | 2021-05-21 00:00:00
X | 2021-04-24 00:00:00 | 2021-04-25 00:00:00
Y | 2022-10-25 00:00:00
Y | 2022-11-21 00:00:00
Y | 2022-11-21 00:00:00
Z | 2022-11-21 00:00:00
Z | 2022-11-21 00:00:00
Z | 2022-11-21 00:00:00
Z
X
Z
Z
Y
X
Y
X
Y
Z
Y
Y
Z
Spreadsheet: 00b1ceb6-866d-43a5-9f36-4fbf8b127fe4
Sheet: 5

 | Nov 9 | Nov 16 | Nov 23 | Nov 30 | Dec 7
Total Interest Rates* | 84500 | 84500 | 84500 | 84500 | 84500
Cleared** | N/A*** | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 3500 | 3500 | 3500 | 3500 | 3500
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | 105000 | 105000 | 105000 | 105000 | 105000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equities | 25000 | 25000 | 25000 | 25000 | 25000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Commodities | 105000 | 105000 | 105000 | 105000 | 105000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 323000 | 323000 | 323000 | 323000 | 323000
Weekly total, estimated swap event volumes by asset class and cleared status (in number of events), all products, tenors, and participant types.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey, which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 3d19cd5f-3a1c-4d88-9737-0f319e41ff98
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 646657043023 | [NAME] | It'S All About You | 2006-02-07 | Compact Disc | Praise | 13.99 | Y | Available
Taseis | 646657043122 | [NAME] | Then & Now | 2008-01-29 | Compact Disc | Gospel | 13.99 | Y | Available
Spreadsheet: 769475d1645551129-searching-for-specific-text-and-using-index-and-match-beth-forum-2-
Sheet: Sheet1

MRN | LEAD, VENOUS | Prenatal Screen | HIV-1/2 AG/AB SCREEN *** (Basically  looking for HIV ) | HCG, QUANTITATIVE, PREGNANCY ***( Basically Looking for HCG) | POCT Urine Pregnancy or POCT URINALYSIS PRENATAL or Urine Culture And Sensitivity *** ( Basically looking for  URIN*) | TYPE & SCREEN, PRNATAL | Chlamydia And Neisseria By PCR |  | MRN | [NAME] | Status
418077 |  |  |  |  |  |  |  |  | 418077 | Chlamydia And Neisseria By PCR | Complete
845238 |  |  |  |  |  |  |  |  | 418077 | HIV-1/2 AG/AB SCREEN | Complete
1116441 |  |  |  |  |  |  |  |  | 418077 | LEAD, VENOUS | Complete
1489616 |  |  |  |  |  |  |  |  | 418077 | PRENATAL SCREEN | Complete
4038535 |  |  |  |  |  |  |  |  | 418077 | [NAME] | Complete
4236253 |  |  |  |  |  |  |  |  | 845238 | HCG, Quantitative | Complete
 |  |  |  |  |  |  |  |  | 845238 | HIV-1/2 Ag/Ab SCREEN | Complete
 |  |  |  |  |  |  |  |  | 845238 | Prenatal Screen | Complete
 |  |  |  |  |  |  |  |  | 845238 | TYPE & SCREEN, PRNATAL | Complete
 |  |  |  |  |  |  |  |  | 845238 | [NAME] | Complete
 |  |  |  |  |  |  |  |  | 1489616 | POCT URINALYSIS PRENATAL | Complete
 |  |  |  |  |  |  |  |  | 1489616 | POCT URINE PREGNANCY | Complete
 |  |  |  |  |  |  |  |  | 4038535 | HCG, QUANTITATIVE, PREGNANCY | Complete
 |  |  |  |  |  |  |  |  | 4038535 | HIV-1/2 AG/AB SCREEN | Complete
 |  |  |  |  |  |  |  |  | 4038535 | LEAD, VENOUS | Complete
 |  |  |  |  |  |  |  |  | 4038535 | POCT URINALYSIS PRENATAL | Complete
 |  |  |  |  |  |  |  |  | 4038535 | POCT URINE PREGNANCY | Complete
 |  |  |  |  |  |  |  |  | 4038535 | PRENATAL SCREEN | Complete
 |  |  |  |  |  |  |  |  | 4038535 | [NAME] | Complete
 |  |  |  |  |  |  |  |  | 4236253 | Chlamydia And Neisseria By PCR | Complete
 |  |  |  |  |  |  |  |  | 4236253 | HCG, QUANTITATIVE, PREGNANCY | Complete
 |  |  |  |  |  |  |  |  | 4236253 | HIV-1/2 Ag/Ab SCREEN | Complete
 |  |  |  |  |  |  |  |  | 4236253 | Lead, Venous | Complete
 |  |  |  |  |  |  |  |  | 4236253 | POCT URINALYSIS PRENATAL | Complete
 |  |  |  |  |  |  |  |  | 4236253 | Prenatal Screen | Complete
 |  |  |  |  |  |  |  |  | 4236253 | TYPE & SCREEN, PRNATAL | Complete
 |  |  |  |  |  |  |  |  | 4236253 | Urine culture | Complete
 |  |  |  |  |  |  |  |  | 4236253 | [NAME] | Complete
Spreadsheet: ae68a0e1-e450-441c-b9de-790a51ba0f36
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
FPARG | Test | FPARG | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain, red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr. 			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FPARG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FPARG | Result | FPARG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 166173d1341493757-problem-in-date-format-in-excel-sample-excel
Sheet: Sheet1

S no | Record Type | Status | Open Time
1 | REQUEST | Work in Progress | 26/01/12 17:43:28
2 | REQUEST | Work in Progress | 29/03/12 11:12:59
3 | REQUEST | Work in Progress | 28/05/12 14:33:18
4 | REQUEST | Work in Progress | 2012-07-06 15:03:06
5 | REQUEST | Work in Progress | 26/06/12 16:21:01
6 | REQUEST | Work in Progress | 26/06/12 16:29:00
7 | REQUEST | Work in Progress | 28/06/12 11:57:00
8 | REQUEST | Work in Progress | 28/06/12 [NAME]
9 | REQUEST | Work in Progress | 28/06/12 12:35:10
10 | REQUEST | Work in Progress | 29/06/12 18:52:48
11 | REQUEST | Work in Progress | 2012-04-07 12:09:16
12 | REQUEST | Work in Progress | 2012-05-07 12:26:48
13 | REQUEST | Work in Progress | 2012-05-07 14:36:57
14 | REQUEST | Work in Progress | 2012-05-07 14:47:55
Spreadsheet: 161371d1339510050-combining-multiple-rows-sample
Sheet: Sheet2

AccountID | IssuerAccountNumber | AccountOpenDate | ChargeOffDate | ChargeOffAmount | PrimaryDebtor | PrimarySSN_SIN | AcquiredFrom | RequestedDate | RequestedBy | OtherDescription
123456 | 1000000000000001 | 2001-01-01 00:00:00 | 2002-01-01 00:00:00 | 100.01 | Doe, [NAME] | 123-45-6789 | ABC Bank | 2012-06-12 00:00:00 | [NAME] | App; C/O; Repo Docs
654321 | 2000000000000002 | 2000-01-01 00:00:00 | 2002-02-02 00:00:00 | 150.15 | Doe, [NAME] | 987-65-4321 | ABC Bank | 2012-06-12 00:00:00 | [NAME] | App; C/O
Spreadsheet: 481343d1474405695-2-sum-ifs-for-a-and-text-problem-2
Sheet: Grocery Items

Grocery Items | Total $ | 2016 | # [NAME] | 2015 | # [NAME] | 2014 | # [NAME] | 2013 | # [NAME] | 2012 | # [NAME]
Almonds
Apple
Apple Juice
Applesauce
Bananas
Blueberries
[NAME]
Bread
Brocoli
Butter
Cereal
Cheese
Cheese Ravioli
[NAME]
Chocolates
Cinnamon
Eggs
Ham
Ham Slices
Hamburger Buns
Healthy Meal
Jelly
Mac N Cheese
Mayo
Milk
OJ
Peanuts
[NAME]
Ravioli
Salad
Salad Dressing
Salmon
Sausages
Snack
Sweet Potato
Syrup
Tea
Velveta
Waffles
Water
Spreadsheet: 844677d1696410782-need-to-extract-names-within-text-sample
Sheet: Sheet1

Data 1 | Data 2 | Data 3 | Data 4 |  | First Name | Last Name | First Name | Last Name
Ashkenazi Itzhak & [NAME] | Ashkenazi | Ashkenazi Itzhak & [NAME] | Ika Family Trust |  | Itzhak | Ashkenazi | Kochava | Ashkenazi
[NAME] | Maria | Maria Romano Trust | Romano [NAME] |  | Maria | Romano
[NAME] | Katharina | Katharina Schoentag Trust | Schoentag Katharina Tr
Chaim | Raskin | [NAME]
[NAME] And [NAME] | [NAME] | [NAME] E | [NAME]
[NAME] | [NAME] | [NAME]
Larisa And [NAME] | Fayman | [NAME] | [NAME]
Adam | Laniado | [NAME]
[NAME] | Dobbs | Dobbs [NAME] | [NAME]
[NAME] | Rozell | Rozell [NAME] D
Elaine | [NAME] | [NAME] | [NAME]
[NAME] And [NAME] | [NAME] | [NAME] | [NAME]
12512 [NAME] St Llc | 12512 [NAME] | 12512 [NAME] St Llc
[NAME] And [NAME] | Vicente | [NAME] | [NAME]
Amram | Ohnona | Ohnona Amram B
[NAME] | Khorani | [NAME]
[NAME] And [NAME] | Baghramyan | [NAME] | [NAME]
Ih5 Property West Lp | Ih | Ih5 Property West Lp
Armine | Asatryan | [NAME]
6425 Nagle Llc | 6425 Nagle | 6425 Nagle Llc
[NAME] | [NAME] | Nazarian Family Trust | Nazarian Simon & Roya Trs
[NAME] | Galajyan | Galajyan Family Trust
Vicbeck Llc | Vicbeck | Vicbeck Llc
[NAME] | [NAME] | Jacqueline Khchirian Trust | [NAME] Tr
[NAME] | Taguhi | [NAME] | [NAME] Revocable Living Trust
Altmann [NAME] | Altmann | Altmann [NAME] | [NAME]
Jan Shure Hurwitz Family | Jan | Jan Shure Hurwitz Trust | [NAME]
[NAME] And Shabnam | Younes | [NAME] A | Younes Shabnam S
Tatevik | Torosyan | [NAME]
Elmajian [NAME] | Elmajian | Elmajian [NAME] | [NAME]
[NAME] And [NAME] | Ladue | Ladue Milton J | Ladue Cheryl
[NAME] | [NAME] | Goldfarb Family Trust
[NAME] | [NAME] | [NAME]
Lampman [NAME] | Lampman | Lampman [NAME] | Rosanna Lampman Trust
Ilanit | [NAME] | [NAME]
Nazeli | Pzdikyan | Pzdikyan Nazeli
[NAME] | Ashvanyan | [NAME]
Behrokh And [NAME] | Tabibian | [NAME] | [NAME]
[NAME] And [NAME] | Hoogstraten | [NAME] | [NAME]
Azniv | Aslanyan | [NAME]
Vahe | Mkrtchian | Mkrtchian Vahe
[NAME] | Bayar | [NAME] | [NAME]
Vicbeck Llc | Vicbeck | Vicbeck Llc
Spreadsheet: 122626d1317033347-help-on-designing-a-workbook-wcb-sandbox2
Sheet: Prices

Description | Price
C | 7.65
L | 7.65
P | 11
Ref C | 3.825
Ref L | 3.825
D/C C | 15.3
D/C L | 15.3
D/C P | 22
None | 0
Spreadsheet: 864310d1711534795-producing-sales-history-on-point-of-sale-pos-trial
Sheet: Customers

I.D | Name | Address | Tin | VAT Number |  |  | [NAME]
1 | CHANNON | 10 Main Street, Workington | 100234234 | 200100300 |  |  | [NAME]
2 | [NAME] | 7 First Strret, Duck | 100478900 | 200389100 |  |  | Jain Russel
3 | MCLEISH | 20 Second Street, Downtown | 100532200 | 200987500 |  |  | [NAME]
4 | Cash Sale
Spreadsheet: 63231d1264156425-compare-and-copy-rows-memsample-2009_10
Sheet: Archive

First Name | Surname | Name | Paid To | [NAME] | EA Reg | Card | Amt. | Ca/ch | Date Paid | Address1 | Address2 | Address4 | Postcode | London | [NAME] | Home | Work | Mobile | Sex | DOB | Age | [NAME] | Claim | Competing | Uk TaxPayer | Born In | Nationality | Joined | 1st Claim2 | 2nd Claim | 2010-01-22 00:00:00
[NAME] | Doe | [NAME] | 2009 | 1153 | 2808075 |  | 20 | ch | 2009-01-07 00:00:00 | 46 long Parade | limehouse | London | ABC 123 |  | [EMAIL] | [PHONE] |  |  | m | 1957-01-17 00:00:00 | 53 | full | 2nd | n | y | [NAME] | irish | 2003 | hhh
[NAME] | [NAME] | [NAME]  smith | 2009 | 1154 |  | y | 20 | ch | 2008-12-03 00:00:00 | 5 Oak tree crescent | copse hill | hants | ABC 124 | 22 | [EMAIL] |  | [PHONE] | 8900 104143 | m | 1966-01-18 00:00:00 | 44 | full | 1st | y | y | York | British | 2006
[NAME] | [NAME] | [NAME][NAME] | 2010 | 1158 | 2808050 | done | 20 | ca | 0101/10 | 6 frodart close | henge | London | ABC 125 |  | [EMAIL] | [PHONE] | [PHONE] | 8901 104143 | m | 1956-02-18 00:00:00 | 53 | full | 1st | y | y | London | British | 2007
Ajay Kumar | [NAME] | Ajay Kumar  patel | 2010 | 1167 | 2808072 | done | 20 | ca | 2010-01-20 00:00:00 | 65 chestnut Vale | East brightwich | London | ABC 126 |  | [EMAIL] | [PHONE] |  | 8902 104143 | m | 1969-11-30 00:00:00 | 40 | full | 1st | y | y | London | British | 2007
Clare | ash | Clare  ash | 2009 | 1172 | 2716779 |  | 20 | ch | 2008-12-01 00:00:00 | 9 mousegrove Road | hamville | surrey | ABC 127 | 45 | [EMAIL] |  | [PHONE] | 8903 104143 | f | 1963-12-26 00:00:00 | 46 | full | 1st | y | n | Beckenham | British | 2007 |  | lockdale
Hugh | fourway | Hugh  fourway | 2010 | 1173 |  | done | 20 | ch | 2010-01-20 00:00:00 | 2 Asylum Road | pickam | London | ABC 128 |  | [EMAIL] | [PHONE] | [PHONE] |  | m | 1954-05-01 00:00:00 | 55 | full | 1st | y | y | London | British | 2007
Spreadsheet: phillip_m_love__30659__9909_OA
Sheet: TOTAL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - CONSOLIDATED VARIANCE
COMPANY:  ALL
REGION: ALL
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-Ontario
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 173442d1344550859-if-and-function-to-list-out-production-depending-on-which-month-the-business-starts-srilanka-dc-phase-1-3-model-draft-internet
Sheet: Scenarios

Pricing | Phase I |  |  |  |  |  |  | Service mix : Phase I
 |  | 30000 | Price | Cost | Margin | Margin % |  |  | Product Distribution
Pure co-location
 | Pure co-location charges incl 3 KVA power | Per Rack pa | 425000 |  |  |  |  |  | Colocation(%) - Racks | 0.8
Bandwidth
 | Bandwidth Price | 0 | 35000 | 25000 |  |  |  |  | Bandwidth - Racks | 0.5
Power
 | Power | 10 | 70000 |  |  |  |  |  | Additional Power
Managed Services
 | Managed Services - realization | Per Rack pa | 1200000 | 950000 |  |  |  |  | Managed Services (%) - Racks | 0.2
Pricing | Phase II |  |  |  |  |  |  | Service mix : Phase II
 |  | 30000 | Price | Cost | Margin | Margin % |  |  | Product Distribution
Pure co-location
 | Pure co-location charges incl 3 KVA power | Per Rack pa | 425000 |  |  |  |  |  | Colocation(%) - Racks | 0.8
Bandwidth
 | Bandwidth Price | 0 | 35000 | 25000 |  |  |  |  | Bandwidth - Racks | 0.5
Power
 | Power | 10 | 70000 |  |  |  |  |  | Additional Power
Managed Services
 | Managed Services - realization | Per Rack pa | 1200000 | 950000 |  |  |  |  | Managed Services (%) - Racks | 0.2
Pricing | Phase III |  |  |  |  |  |  | Service mix : Phase III
 |  | 30000 | Price | Cost | Margin | Margin % |  |  | Product Distribution
Pure co-location
 | Pure co-location charges incl 3 KVA power | Per Rack pa | 425000 |  |  |  |  |  | Colocation(%) - Racks | 0.8
Bandwidth
 | Bandwidth Price | 0 | 35000 | 25000 |  |  |  |  | Bandwidth - Racks | 0.5
Power
 | Power | 10 | 70000 |  |  |  |  |  | Additional Power
Managed Services
 | Managed Services - realization | Per Rack pa | 1200000 | 950000 |  |  |  |  | Managed Services (%) - Racks | 0.2
Spreadsheet: 0d86af7a-dee2-4ecc-8805-20dfa2e96f9e
Sheet: Sheet1

Supplementary Table 4.  The risk and protective alleles of rs2713604 and rs3803 do not occur on the same haplotype | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | GENECARD | GENECARD | CATHGEN | CATHGEN | CATHGEN | CATHGEN
RS2713604 | RS3803 | [NAME] | P value* | [NAME] | P value** | Controls | Cases
C | A | 0.199 | 0.03 | 0.199 | 0.017 | 0.224 | 0.185
C | G | 0.476 | 0.94 | 0.473 | 0.79 | 0.477 | 0.471
T | G | 0.324 | 0.044 | 0.328 | 0.024 | 0.3 | 0.344
T | A | 0.001 |  | 0
*, APL test; **, haplostats;  risk alleles are indicated in red and protective alleles are indicated in blue.  P values ≤0.05 are
highlighted in red.  N/A, not applicable
Spreadsheet: 889549d1740409066-changing-integer-creates-result-change-the-integer-without-pasting-values
Sheet: Sheet1

 | 2025 Budget | 2026 Plan | 2027 Plan | 2028 Plan | 2029 Plan | 2030 Plan
REVENUE
Revenue 1 | 0.5 | 1 | 2 | 3 | 4 | 5
Revenue 2 | 0 |  |  |  |  |  | 1
Total Revenue
CONTRIBUTION
Revenue Contribution
Revenue Contribution
Less Costs | -0.5 | -0.5 | -0.5 | -0.5 | -0.5 | -0.5
Total Contribution
 | 2025 Budget | 2026 Plan | 2027 Plan | 2028 Plan | 2029 Plan | 2030 Plan
0.5
0.6
0.7
0.8
0.9
1
1.1
1.2
1.3
1.4
1.5
Spreadsheet: mark_guzman__24559__Rogers_Calculator
Sheet: Calculator-Peak

 | ECONOMIC CALCULATOR FOR FIRM VERSUS NON-FIRM PURCHASE
 |  |  |  |  |  |  | HE | 19
 |  |  | Enter Local Generation Avail: |  |  |  | Projected Control Area Load: | 920 |  | [NAME].
 |  |  | Enter Remote Generation: |  |  |  | PNM Contingent: | 46 |  | Gen.
 |  |  | Firm Purchases into EPE: | 50 |  |  | TNP Firm: | 25 |  | UnLoaded
 |  |  | Non-Firm Purchases into EPE: | 0 |  |  | IID Firm + Contingent: | 150
 |  |  | SPS Firm: | 0 |  |  | Firm Sales: | 0 | Eddy | 118 | Local
 |  |  | Reserves: | 52 |  |  | Non-Firm Sales: | 0 | -load | 50 | Copper | 0
 |  |  | Total Generation for Load: |  |  |  | Total Load Next Hour:
 |  |  | Enter Total Spin Required: | 90 |  |  | PNM Contract: |  | (Contingent upon units 7 & 8 number automatically feeds from the calculation tab)
 |  |  | Spin Required: |  |  |  | IID Firm Contract: | 100 |  |  |  | Enter Blue Numbers
 |  |  | Non-Spin Required: |  |  |  | TNP Contract: | 25
 |  |  | Spin Required + Regulating Margin: |  |  |  | SPS Contract: | 100
 |  |  |  |  |  |  |  |  | [NAME] | 45.75
 |  |  | *Amount of Spin: |  |  | Weighted Avg. Purchase Power Calculator |  |  |  |  |  |  | * | Output | Highs' | Spin | RR
 |  |  | Amount of Non-Spin: |  |  |  |  | MWH | $/MWH |  |  |  | Unit  1 | 43 | 80 |  | 3
 |  |  | Total Spin: |  |  |  | Firm Block 1: | 0 | 0 |  |  |  | 2 | 48 | 82 |  | 4.5
 |  |  | Spin Available/(Deficient): |  |  |  | Firm Block 2: | 0 | 0 |  |  |  | 3 | 0 | 0 |  | 3.37
 |  |  | Enter Firm Price: | 0 |  |  | Firm Block 3: | 0 | 0 |  |  |  | GT1 | 0 | 0 |  | 10
 |  |  | Enter Non-Firm Price: | 0 |  |  | Firm Block 4: | 0 | 0 |  |  |  | GT2 | 0 | 0 |  | 10
 |  |  |  |  |  |  | Firm Block 5: | 0 | 0 |  |  |  | GT1S | 0 | 0 |  | 3.33
 |  |  | MWH of Firm Avail./(Deficient): |  |  |  | Total: |  |  |  |  |  | GT2S | 0 | 0 |  | 3.6
 |  |  | Total Cost of Firm: |  |  |  |  | MWH | $/MWH |  |  |  | NM4 | 214 | 214 |  | 3.6
 |  |  | MWH of Non-Firm Avail./(Deficient): |  |  |  | Non-Firm Block 1: | 0 | 0 |  |  |  | Copper | 0 | 0 |  | 10
 |  |  | Total Cost of Non-Firm: |  |  |  | Non-Firm Block 2: | 0 | 0 |  |  |  | 6 | 0 | 0 |  | 2
 |  |  |  |  |  |  | Non-Firm Block 3: | 0 | 0 |  |  |  | 7 | 33 | 33 |  | 2.1
 |  |  |  |  |  |  | Non-Firm Block 4: | 0 | 0 |  |  |  | 8 | 95 | 110 |  | 2.1
 |  |  |  |  |  |  | Non-Firm Block 5: | 0 | 0 |  |  |  | Total
 |  |  |  |  |  |  | Total: |  |  |  |  |  | FC | 52 | 108
 |  |  |  |  |  |  |  |  |  |  |  |  | PV | 530 | 600
 | NOTE: | * ACTUAL SPIN SHOW MAY BE LESS SINCE UNIT RAMP RATES ARE NOT CONSIDERED.
 |  |  |  |  |  |  |  |  |  |  |  |  | * If unit is off put zero's in both places