tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 806826d1669623840-extracting-and-reformating-data-from-pivot-table-efpivottimefullset
Sheet: Sheet2

Count of time | Column Labels
Row Labels | To A | To B
<1/0/1900
4 AM
:00 |  | 1
:30 |  | 1
:45 | 1
5 AM
:00 |  | 1
:15 | 1
:30 |  | 1
:45 | 1
6 AM
:00 |  | 1
:14 | 1
:20 |  | 1
:34 | 1
:40 |  | 1
:54 | 1
7 AM
:00 |  | 1
:14 | 1
:20 |  | 1
:34 | 1
:40 |  | 1
:54 | 1
8 AM
:00 |  | 1
:14 | 1
:20 |  | 1
:34 | 1
:40 |  | 1
:54 | 1
9 AM
:00 |  | 1
:16 | 1
:24 |  | 1
:40 | 1
:48 |  | 1
10 AM
:04 | 1
:12 |  | 1
:30 | 1
:36 |  | 1
:53 |  | 1
:54 | 1
11 AM
:13 |  | 1
:14 | 1
:33 |  | 1
:34 | 1
:53 |  | 1
:54 | 1
12 PM
:13 |  | 1
:14 | 1
:33 |  | 1
:34 | 1
:53 |  | 1
:54 | 1
1 PM
:13 |  | 1
:14 | 1
:33 |  | 1
:34 | 1
:53 |  | 1
:54 | 1
2 PM
:11 |  | 1
:12 | 1
:31 |  | 1
:32 | 1
:51 |  | 1
:52 | 1
3 PM
:11 |  | 1
:12 | 1
:31 |  | 1
:32 | 1
:51 |  | 1
:52 | 1
4 PM
:11 |  | 1
:12 | 1
:31 |  | 1
:32 | 1
:51 |  | 1
:52 | 1
5 PM
:11 |  | 1
:12 | 1
:31 |  | 1
:32 | 1
:51 |  | 1
:52 | 1
6 PM
:15 |  | 1
:18 | 1
:39 |  | 1
:44 | 1
7 PM
:04 |  | 1
:10 | 1
:28 |  | 1
:34 | 1
:52 |  | 1
:58 | 1
8 PM
:16 |  | 1
:28 | 1
:58 | 1
9 PM
:01 |  | 1
:28 | 1
:33 |  | 1
:58 | 1
10 PM
:03 |  | 1
:28 | 1
:33 |  | 1
:58 | 1
11 PM
:04 |  | 1
:29 | 1
:34 |  | 1
1-Jan
12 AM
:09 | 1 | 1
:49 | 1 | 1
1 AM
:29 | 1
:33 |  | 1
Spreadsheet: 1160b714-2cae-4a30-83cf-e6aa682598c6
Sheet: Satpol

RENCANA UMUM PENGADAAN BARANG/JASA PEMERINTAH
PA/KPA |  | : [NAME], S.Pd
K/L/D/I |  | : [NAME]. [NAME]
SATKER/SKPD |  | : Satuan Polisi Pamong Praja
PPK |  | :
[NAME] |  | : 2012
NO | KEGIATAN |  | SUB KEGIATAN/ PEKERJAAN | NAMA PAKET PEKERJAAN | VOLUME | LOKASI PEKERJAAN (PROVINSI/KAB/KOTA) | RENCANA PENGANGGARAN |  |  | CARA PENGADAAN | PERKIRAAN WAKTU MULAI PELAKSANAAN PENGADAAN ￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼ | WAKTU PELAKSANAAN (BULAN) | [NAME]
 |  |  |  |  |  |  | PERKIRAAN BIAYA (RP,-) | [NAME] (APBN/APBD) | RENCANA PEMBIAYAAN
(1) | (2) |  | (3) | (4) | (5) | (6) | (7) | (8) | (9) | (10) | (11) | (12) | (13)
1 | [NAME] disiplin aparatur |  | Pengadaan pakaian dinas beserta kelengkapannya | Belanja pakaian dinas harian (PDH) | 30 org/stel |  | 8400000 | APBD |  | Penunjukkan langsung | Mei 2012 | 1
 |  |  |  | Belanja pakaian [NAME] (PDL) | 139 org/stel |  | 45870000 | APBD |  | Penunjukkan langsung | Mei 2012 | 1
 |  |  | Belanja atribut [NAME] | [NAME] satpol PP | 139 buah |  | 10425000 | APBD |  | Penunjukkan langsung | [NAME] 2012 | 1
 |  |  |  | [NAME] | 139 buah |  | 5560000 | APBD |  | Penunjukkan langsung | [NAME] 2012 | 1
 |  |  |  | Dahrem | 139 buah |  | 4865000 | APBD |  | Penunjukkan langsung | [NAME] 2012 | 1
 |  |  |  | Pluit + Talikur | 139 buah |  | 4170000 | APBD |  | Penunjukkan langsung | [NAME] 2012 | 1
 |  |  |  | Sepatu PDL | 139 buah |  | 34750000 | APBD |  | Penunjukkan langsung | [NAME] 2012 | 1
 |  |  |  | [NAME] pet PDH | 30 buah |  | 1200000 | APBD |  | Penunjukkan langsung | [NAME] 2012 | 1
 |  |  |  | Sabuk | 30 buah |  | 600000 | APBD |  | Penunjukkan langsung | [NAME] 2012 | 1
 |  |  |  | Sepatu PDH | 30 buah |  | 6000000 | APBD |  | Penunjukkan langsung | [NAME] 2012 | 1
 |  |  |  | [NAME] | 169 buah |  | 2535000 | APBD |  | Penunjukkan langsung | [NAME] 2012 | 1
 |  |  |  | [NAME] PDL logo | 139 buah |  | 6950000 | APBD |  | Penunjukkan langsung | [NAME] 2012 | 1
Spreadsheet: michelle_cash__26538__Annual Payroll
Sheet: Sheet1

Annual Payroll Amounts
 |  |  | YTD | YTD | YTD | YTD | YTD | Projected December | Projected YTD | YTD
 | Tax Company |  | Bonus | Stock Options | Deferral Payments | Other Salaries & Wages | Total Compensation | Other Salaries & Wages | Total Compensation | Employer Taxes
Enron Corp | 0011 |  | 120789855.58 | 367399351.47 | 62929166.23 | 246735510.69
ENA | 0364 |  | 68031738.49 | 79117755.34 | 2212926.75 | 116850948.53
EPM | 0600 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
Subtotal
Total All Companies |  |  | 324753392.59 | 654170697.4 | 66228448.47 | 1192404758.36
Spreadsheet: 05154d41-2ea5-458b-9f66-3198aa2ff80d
Sheet: Sheet1

School/Dept. | Contact | [NAME] | [NAME] | Design | Quantity | PO No | Del address | First line | Second line | Third line
University Communications | [NAME] | [PHONE] | [EMAIL] | Flare | 50 | 9002125 | SW217 | with best wishes from | [NAME] | Director of Marketing
Spreadsheet: 121083d1315839084-count-cf-colors-example
Sheet: Week 1

 | Thurs | Sun | Sun | Sun | Sun | Sun | Sun | Sun | Sun | Sun | Sun | Sun | Sun | Sun | Mon | Mon
 | 8:30pm | 1:00pm | 1:00pm | 1:00pm | 1:00pm | 1:00pm | 1:00pm | 1:00pm | 1:00pm | 4:15pm | 4:15pm | 4:15pm | 4:15pm | 8:20pm | 7:00pm | 10:15pm
Away | NO | ATL | CIN | BUF | PHI | DET | TEN | PIT | IND | NYG | SEA | MIN | CAR | DAL | NE | OAK
Home | GB | CHI | CLE | KC | STL | TB | JAC | BAL | HOU | WAS | SF | SD | ARI | NYJ | MIA | DEN
WINNER | GB | CHI | CIN | BUF | PHI | DET | JAC | BAL | HOU | WAS | SF | SD | ARI | NYJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Pts
Person1 | NO | ATL | CLE | KC | PHI | TB | TEN | BAL | HOU | NYG | SF | SD | ARI | NYJ | NE | DEN
Person2 | GB | ATL | CLE | KC | PHI | DET | JAC | BAL | HOU | NYG | SF | MIN | ARI | NYJ | NE | DEN
Person3 | NO | CHI | CLE | KC | PHI | DET | TEN | BAL | HOU | NYG | SF | SD | CAR | NYJ | MIA | DEN
Person4 | GB | CHI | CLE | KC | PHI | DET | JAC | BAL | IND | WAS | SF | MIN | ARI | NYJ | NE | OAK
Person5 | GB | ATL | CLE | KC | PHI | TB | JAC | BAL | HOU | NYG | SF | SD | ARI | NYJ | NE | DEN
Person6 | GB | ATL | CLE | KC | PHI | TB | JAC | BAL | HOU | NYG | SF | SD | ARI | NYJ | NE | DEN
Person7 | GB | ATL | CIN | KC | PHI | DET | JAC | BAL | HOU | NYG | SF | SD | ARI | NYJ | NE | DEN
Person8 | GB | ATL | CLE | KC | PHI | TB | TEN | PIT | HOU | NYG | SF | SD | ARI | NYJ | NE | DEN
Person9 | NO | ATL | CLE | KC | PHI | DET | TEN | PIT | HOU | NYG | SF | SD | ARI | NYJ | NE | OAK
Person10 | GB | ATL | CLE | KC | PHI | DET | TEN | PIT | HOU | NYG | SF | SD | ARI | NYJ | NE | DEN
Person11 | GB | CHI | CLE | KC | STL | DET | TEN | PIT | HOU | NYG | SEA | SD | ARI | DAL | NE | DEN
Person12 | GB | ATL | CLE | KC | PHI | DET | JAC | PIT | HOU | NYG | SF | SD | ARI | NYJ | NE | OAK
[NAME] | GB | ATL | CLE | KC | PHI | DET | JAC | BAL | HOU | NYG | SF | SD | ARI | NYJ | NE | DEN
Person14 | GB | ATL | CLE | KC | PHI | DET | TEN | PIT | HOU | WAS | SF | MIN | CAR | DAL | NE | OAK
Spreadsheet: 28849d1223395601-pivot-table-question-example
Sheet: Sheet1

Car Make | Value |  |  |  |  |  | Bmw
Bmw | 2000 |  |  |  |  |  | Ford
Ford | 25000 |  |  |  |  |  | VW
VW | 6500
Ford | 9500
Ford | 2000
Bmw | 6500
Ford | 4800
Bmw | 3000
Spreadsheet: 151389d1334881268-help-with-getting-rid-of-0s-in-spreadsheet-dota-2-log
Sheet: Sheet2

 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
Spreadsheet: ryan_slinger__33685__8_8act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 567822d1522242891-lookup-multiple-occurrences-of-the-same-value-in-two-different-columns-example-workbook-2
Sheet: ELO

Name | ELO 1 | ELO 2 | ELO 3 | ELO 4 | ELO 5 | ELO 6 | ELO 7 | ELO 8 | ELO 9 | ELO 10
Adam | 1000
Alicia | 1000
[NAME] | 1000
Braxton | 1000
Ellie | 1000
[NAME] | 1000
Erin | 1000
Grace | 1000
Jessica | 1000
Olivia | 1000
[NAME] | 1000
[NAME] | 1000
[NAME] | 1000
Tyron | 1000
Spreadsheet: 674105d1587662338-count-specific-values-in-column-g-sorted-by-values-in-column-a-invoice-example-sheet
Sheet: Sheet1

# | Name | Date Estimate Submitted | Vendor | Quoted Amount | Date Estimate Approved | Payment Type | Scope of Work |  |  |  | Invoices | Card
734 | Springfield |  |  |  |  | Invoice |  |  |  | 531
734 | Springfield |  |  |  |  | Card |  |  |  | 622
622 | East Springfield |  |  |  |  | Card |  |  |  | 734
531 | Washington |  |  |  |  | Invoice
622 | East Springfield |  |  |  |  | Invoice
531 | Washington |  |  |  |  | Invoice
734 | Springfield |  |  |  |  | Card
Spreadsheet: 03ab6e42-14e8-4478-b042-976fd770e755
Sheet: Sheet1

Line | Calculator for Shared-Placement Cases | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
1 | ENTER the number of children in this case | 0
2 | Percentage Standard for this number of children | 0
 |  | Parent A | Parent B
3 | ENTER each parent's monthly income available for child support | 0 | 0
4 | Estimated share for each parent based on percent of their income | 0 | 0
5 | Multiplier of 150% | 0 | 0
6 | ENTER number of overnights the child/children spend with each parent ("TRUE" when days add up correctly to 365 days/year) | 0 | 0 | 1
7 | Percent of time spent with each parent | 0 | 0
8 | Estimated share for each parent based on time spent with child | 0 | 0
9 | Estimated monthly support amount to be paid by each parent | $0 | $0
 | Disclaimer:  * This calculator estimates support based on the Shared-Placement formula found in DCF 150. The use of this formula is at the court's discretion
 | * The estimates for Shared-Placement do not include variable costs.
 | Areas shaded in yellow are locked to protect formulas
Spreadsheet: andy_zipper__221__Global_Prod 5-30-01 EM
Sheet: Taken Down Prior to Exp

Global Products that were not made available on
and have not yet expired
Global Product Short Desc.
Credit Dflt Swap AT & T                  5 Years         bpa/USDm
Credit Dflt Swap BMW AG                  5 Years         bpa/USDm
Credit Dflt Swap DaimlerChrysler         5 Years         bpa/USDm
Credit Dflt Swap Fiat SpA                5 Years         bpa/USDm
Credit Dflt Swap Ford Credit             3 Years         bpa/USDm
Credit Dflt Swap Ford Credit             5 Years         bpa/USDm
Credit Dflt Swap GM Acceptance           3 Years         bpa/USDm
Credit Dflt Swap GM Acceptance           5 Years         bpa/USDm
Credit Dflt Swap Volkswagen              3 Years         bpa/USDm
Credit Dflt Swap Volkswagen              5 Years         bpa/USDm
Credit Dflt Swap Volvo                   5 Years         bpa/USDm
Credit Dflt Swap Worldcom                5 Years         bpa/USDm
For Curr Exch    Forward                 31May01         JPY/USD
For Curr Exch    Forward                 31May01         USD/EUR
For Curr Exch    Forward                 31May01         USD/GBP
For Curr LME     LME (Spot)              31May01         JPY/USD
For Curr LME     LME (Spot)              31May01         USD/EUR
For Curr LME     LME (Spot)              31May01         USD/GBP
Gasoil CIF Med   Platts Hi               Jun01           USD/mt
SG Dubai Swap    Platts                  Q4 2001         USD/bl/m
SG Gasoil Swap   Platts AP               Jun01           USD/bbl
[NAME]           WS/mt
US Crude Fin Opt NYMEX WTI    EC32.5     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC33.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP26.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP30.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP30.5     Jul01           USD/bl/m
US HeatOil2 Swap NYMEX HO CrkSpd         Q1 2002         USD/bl/m
US HeatOil2 Swap NYMEX HO CrkSpd         Q2 2002         USD/bl/m
US HeatOil2 Swap NYMEX HO CrkSpd         Q3 2002         USD/bl/m
US HeatOil2 Swap NYMEX HO CrkSpd         Q4 2002         USD/bl/m
US PL CapNNG [NAME] R+C      Jun01           USD/MM
US Wthr CDD Swap SAC 100/20K             May01           USD/CDD
US WTI Swap      Nymex                   Jan-Dec02       USD/bl/m
Spreadsheet: 770272d1645973847-excel-formula-to-produce-balance-sheet-balannce-sheet-2021
Sheet: Financial Statement

I am kindly asking for a excel formula that can produce a Balance Sheet using data in Trial Balance worksheet  as shown in the desired outcome:
 | Desired outcome
 | ASSETS
 | Non-current Assets
 | Buildings |  | 331833
 | Furniture - Net Value |  | 605421.6226666667
 | Motor Vehicles - Net Value |  | 5101.970661039522
 | Equipment - Net Value |  | 149508.2933333333
 | Current Assets
 | Debtors and other receivables |  | 2868092.2
 | Cash and equivalents |  | 223983.38
 | Total Assets
 | FINANCED BY:
 | EQUITY AND LIABILITIES
 | Accumulated funds |  | 491809.59
 | Net Surplus for the year |  | 2536617.16
 | School development funds |  | 846341.62
 | Total
 | Current Liabilities
 | Sundry Suppliers |  | 309000
 | Other obligations |  | 172.1
 | Total Equity and Liabilities
Spreadsheet: 221651d1363631938-time-adherence-sheet-for-excel-work-times
Sheet: Sheet1

02:00:00 | Start | End | Minute Usage | Total Minutes Used | Minutes Available for ACW
ACW | 08:30:00 | 08:40:00 |  |  |  |  | In cell E3 You had    =IF(C2>0,D2+D3,"")   I have    =IF(C3>0,E2+D3,"")
ACW | 08:45:00 | 08:50:00
ACW | 08:55:00 | 09:00:00 |  |  |  |  | Now In cell F 2 I have   =IF(C2>0,A1-E2,"")
ACW | 09:05:00 | 09:10:00 |  |  |  |  | In cell [NAME] is the 2 hours you are allowed.
ACW |  |  |  |  |  |  | In cell F3 and down I have =IF(C3>0,F2-E3,"")
ACW |  |  |  |  |  |  | The If statement part hides 0 and error values if there is nothing in C column
ACW |  |  |  |  |  |  | You could hide 0 values in column D by using  =IF(C2>0,MOD(C2-B2,0.5),"")   in cell [NAME]  and fill down.
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
ACW
Spreadsheet: 140875d1328916764-using-multiple-names-and-referring-to-names-via-cells-when-tranferring-btw-2-sheets-book1
Sheet: Sheet1

text |  |  |  | text
juicy |  |  |  | floury
fleshy |  |  |  | waxy
sour |  |  |  | mashing |  |  |  |  |  | Animals
sweet |  |  |  | boiling |  |  |  |  |  | dog
dry |  |  |  | salad |  |  |  |  |  | cat
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | fish
 |  |  |  |  |  | People |  |  |  | horse
 |  |  |  |  |  | [NAME] |  |  |  | cow
 |  |  |  |  |  | [NAME] |  |  |  | pig
 |  |  |  |  |  | [NAME] |  |  |  | chicken
 |  |  |  |  |  | [NAME]
Spreadsheet: 778265d1650964851-get-number-of-seconds-between-two-dates-in-excel-excluding-part-of-weekend-and-holidays-time-between-hours-1-1-
Sheet: Full Day Holidays

[NAME] | End Holidays | Weekday
2022-04-08 05:00:00 | 2022-04-09 05:00:00 |  |  | The pupose of this list is strictly for whole-day Holidays, not for part days or days that are not from midnight to midnight.
2022-04-14 21:00:00 | 2022-04-16 05:00:00 |  |  | Examples: Chrismas Day is all of the 25/12
2022-04-20 05:00:00 | 2022-04-22 21:00:00 |  |  | It is not from 5am one day to 5am the next day
2022-04-29 04:30:00 | 2022-04-30 05:00:00 |  |  | and it is not just from 8 am to 8 pm.
Spreadsheet: 88466d1288275385-lookup-column-header-column-heading
Sheet: Sheet1

New York | New Jersey | Connecticut |  |  | Header
55 | 125 | 78 | [NAME] |  | New Jersey
76 | 11 | 43 | Min |  | New York
1 | 63 | 2
21 | 24 | 96
46 | 7 | 2
Spreadsheet: 839154d1691697901-dynamic-drop-down-list-in-excel-sample1
Sheet: FN

 | FN |  | Bal | PL
 | FN1 |  | FN11 | FN21 |  | FN22
 | FN2 |  | FN12 | FN22 |  | FN23
 | FN3 |  | FN13 | FN23 |  | FN24
 | FN4 |  | FN14 | FN24
 | FN5
 | FN11
 | FN12
 | FN13
 | FN14
 | FN21
 | FN22
 | FN23
 | FN24
Spreadsheet: 95298d1294920393-modify-sumproduct-and-sumif-formulas-testing
Sheet: Savings

Category | Location | Family Part Number | [NAME] | Savings
Fitting | Alabama | Code1 | Supplier 1 |  | This should be:
Fitting | Alabama | Code2 | Supplier 2 |  | This should be:
Spreadsheet: 541458d1507298159-match-column-error-dashboard_1
Sheet: Dashboard

 |  |  |  |  | DASHBOARD
 | Month: | 2017-09-01 00:00:00
Categories in Area 2
A
Desired Answers for A |  |  | 78 | 89.33333333333333 | 92
B
Desired Answers for B |  |  | 61.4 | 77.5 | 50.25
Spreadsheet: 97997d1297100791-lock-cells-together-fruit-sorting
Sheet: Raw Data

apples | 18
#1567 | 30
pears | 72
#6645 | 100 |  |  |  | Paste raw data here in columns A & B(I have enough formula copied on Sheet2 to handle 2000 rows of data on Sheet1
lemons | 33 |  |  |  | See Sheet 2 for sorted data(I only copied the forumlas down 1000 rows)
#5546 | 300
oranges | 18
#2345 | 30
grapes | 72
#5589 | 100
Spreadsheet: 1923b6c3-1ffb-4339-a029-7a5d3d88629f
Sheet: Sheet1

Human GeneID | Human Symbol | [NAME] | [NAME] | HG_U133A | HG_U133+ | MG_U74A | MG_430A | MG_430 | Description
1595 | CYP51A1 | 13121 | Cyp51 | 216607_s_at | 216607_s_at | 94916_at | 1422533_at | 1422533_at | cytochrome P450, family 51, subfamily A, polypeptide 1
1717 | DHCR7 | 13360 | Dhcr7 | 201790_s_at | 201790_s_at | 98989_at | 1448619_at | 1448619_at | 7-dehydrocholesterol reductase
10682 | EBP | 13595 | Ebp | 202735_at | 202735_at | 96627_at | 1416667_at | 1416667_at | emopamil binding protein (sterol isomerase)
2222 | [NAME] | 14137 | Fdft1 | 208647_at | 208647_at | 97518_at | 1438322_x_at | 1438322_x_at | farnesyl-diphosphate farnesyltransferase 1
3156 | HMGCR | 15357 | Hmgcr | 202539_s_at | 202539_s_at | 99425_at | 1427229_at | 1427229_at | 3-hydroxy-3-methylglutaryl-Coenzyme A reductase
51478 | HSD17B7 | 15490 | Hsd17b7 | 220081_x_at | 220081_x_at | 94177_at | 1417871_at | 1417871_at | hydroxysteroid (17-beta) dehydrogenase 7
4047 | LSS | 16987 | Lss | 211018_at | 211018_at | 160737_at | 1420013_s_at | 1420013_s_at | lanosterol synthase (2,3-oxidosqualene-lanosterol cyclase)
4598 | MVK | 17855 | [NAME] | 36907_at | 36907_at | 95632_f_at | 1418052_at | 1418052_at | mevalonate kinase
50814 | NSDHL | 18194 | Nsdhl | 209279_s_at | 209279_s_at | 93868_at | 1416222_at | 1416222_at | NAD(P) dependent steroid dehydrogenase-like
6713 | SQLE | 20775 | Sqle | 209218_at | 209218_at | 94322_at | 1415993_at | 1415993_at | squalene epoxidase
6307 | SC4MOL | 66234 | Sc4mol | 209146_at | 209146_at | 160388_at | 1423078_a_at | 1423078_a_at | sterol-C4-methyl oxidase-like
10654 | PMVK | 68603 | Pmvk | 203515_s_at | 203515_s_at |  | 1427893_a_at | 1427893_a_at | phosphomevalonate kinase
7108 | TM7SF2 | 73166 | Tm7sf2 | 210130_s_at | 210130_s_at | 92437_at | 1460684_at | 1460684_at | transmembrane 7 superfamily member 2
1718 | DHCR24 | 74754 | Dhcr24 | 200862_at | 200862_at |  | 1418129_at | 1418129_at | 24-dehydrocholesterol reductase
2224 | FDPS | 110196 | Fdps | 201275_at | 201275_at | 99098_at | 1423418_at | 1423418_at | farnesyl diphosphate synthase (farnesyl pyrophosphate synthetase, dimethylallyltranstransferase, geranyltranstransferase)
4597 | MVD | 192156 | Mvd | 203027_s_at | 203027_s_at | 160770_at | 1417303_at | 1417303_at | mevalonate (diphospho) decarboxylase
3157 | [NAME] | 208715 | Hmgcs1 | 221750_at | 221750_at | 94325_at | 1433443_a_at | 1433443_a_at | 3-hydroxy-3-methylglutaryl-Coenzyme A synthase 1 (soluble)
6309 | SC5DL | 235293 | Sc5d | 211423_s_at | 211423_s_at | 102768_i_at | 1424709_at | 1424709_at | sterol-C5-desaturase (ERG3 delta-5-desaturase homolog, S. cerevisiae)-like
3422 | IDI1 | 319554 | Idi1 | 204615_x_at | 204615_x_at | 96269_at | 1423804_a_at | 1423804_a_at | isopentenyl-diphosphate delta isomerase 1
Spreadsheet: 862239d1709984980-need-help-totaling-based-on-selections-mix-id-calculator
Sheet: Sheet1

This section is where the results are displayed. |  |  |  |  |  |  | This section is where I manipulate the lists and price.  Can be done on another tab.
Base Price | Mix ID | Add On | Distance | Total |  |  | Mix ID | Price |  | Add On | Price |  | Distance | Price
121 | dropdown | check box | dropdown | total |  |  | COM301510 | base |  | Air | 3 |  | 1-10 | 0
 |  |  |  |  |  |  | COM351510 | 5 |  | HRWR | 5 |  | 11-20 | 5
 |  |  |  |  |  |  | COM401510 | 10 |  | 3/8 Agg | 7 |  | 21-30 | 10
 |  |  |  |  |  |  | COM451510 | 15 |  | [NAME] | 13
 |  |  |  |  |  |  | COM501510 | 20
Spreadsheet: phillip_m_love__30112__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 4/20/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
ATP Oil & Gas Corporation | V48412.1 | P | NG | [NAME]
Amerada Hess Trading Company | V47920.1 | P | WTI | [NAME]
Callon Petroleum Company | V48139.1/2/3/4/5/6/7/8/9/A | F | NG | [NAME]
Cilcorp Inc. | V47526.1 | F | NG | [NAME]
Iris Energy LLC | V47997.1 | P | COAL | [NAME]
NGL Supply Inc. dba Premier Energy | V47688.1 | F | C3GC | Credit Previously Provided
New Counterparty | V48336.1 | P | MEOH | [NAME]
Pepco Energy Services, Inc. | V47151.1 | P | NG | [NAME]
Texican Natural Gas Inc. | V48568.1 | P | NG | [NAME]
Tropicana Products Inc. | V47584.1/2/3 | P | NG | [NAME]
U.S. Brick Company | V48090.1 V48242.1 | F | NG | Brant Reves
Waste Management Holdings, Inc. | V47184.1 V47231.1 V47245.1 V47253.1 v47259.1 V47265.1 V47416.1 V47421.1 | F | OCC | [NAME]
[NAME], LLC | V48496.1 V48512.1/2 | P | NG | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
Dynegy Canada Inc. | V47643.1 | F | NG | Dynegy Canada Inc. (w/ECC)
Elf Trading, Inc. | V47005.1 | F | 61NY | Elf Trading SA
Louis Dreyfus Natural Gas Holdings | V47644.1 V47645.1 | F | NG | Louis Dreyfus Natural Gas Corp.
Public Service Resources Corp. | V47841.1 | F | NG | Public Service Company of Colorado
TransCanada Energy Financial Products | V47146.1 | F | NG | TransCanada Energy Financial Products (w/ECC)
Virginia Electric and Power Company | [NAME] | F | NG | Virginia Power Energy Marketing