tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 772191d1647065006-how-to-generate-a-list-of-columns-f-and-g-based-on-columns-a-and-b-in-office365-3-12
Sheet: Sheet1

Q | 3 |  |  |  | Q | 1 |  |  | 1
D | 5 |  |  |  | Q | 2 |  | Q | 2
A | 2 |  |  |  | Q | 3 |  | Q | 3
 |  |  |  |  | D | 1 |  | D | 1
 |  |  |  |  | D | 2 |  | D | 2
 |  |  |  |  | D | 3 |  | D | 3
 |  |  |  |  | D | 4 |  | D | 4
 |  |  |  |  | D | 5 |  | D | 5
 |  |  |  |  | A | 1 |  | A | 1
 |  |  |  |  | A | 2 |  | A | 2
Spreadsheet: 143755d1330549258-filter-a-rollup-workbook-by-month-with-data-from-other-workbook-tu-tracking
Sheet: Store 1

Date [NAME] | Month | Week | Prospect # | First Name | Last Name | Lead Source | Appt Status | Appt Date | T/U Status |  |  | SSA paid
2012-01-31 00:00:00 |  |  |  | Hal | [NAME] | SSA | Booked | 2012-01-31 00:00:00 | Completed | 228 |  | x
2012-02-01 00:00:00 |  |  |  | [NAME] | [NAME] | SSA | Booked | 2012-02-01 00:00:00 | Completed | 39 |  | x
2012-02-02 00:00:00 |  |  |  | [NAME] | Okamoto | SSA | Booked | 2012-02-02 00:00:00 | Completed | 39
2012-02-02 00:00:00 |  |  |  | [NAME] | Tressel | SSA | Booked | 2012-02-02 00:00:00 | Completed | 273.24
2012-02-02 00:00:00 |  |  |  | [NAME] | Cooper | SSA | Booked | 2012-02-02 00:00:00 | Completed | 39
2012-02-02 00:00:00 |  |  |  | Maninda | [NAME] | SSA | Booked | 2012-02-02 00:00:00 | Completed | 39
2012-03-01 00:00:00 |  |  |  | [NAME] | Cox | SSA | Booked | 2012-03-01 00:00:00 | Completed | 174
2012-03-02 00:00:00 |  |  |  | [NAME] | Suffield | SSA | Not Interested | 2012-03-02 00:00:00 | Cust. Cancelled
2012-03-03 00:00:00 |  |  |  | [NAME] | Gladieux | SSA | Booked | 2012-03-03 00:00:00 | Cust. Cancelled
2012-03-04 00:00:00 |  |  |  | [NAME] | Bowe | SSA | Booked | 2012-03-04 00:00:00 | Completed | 39
2012-03-05 00:00:00 |  |  |  | [NAME] | Kelly | SSA | Booked | 2012-03-05 00:00:00 | Completed | 39
2012-03-06 00:00:00 |  |  |  | [NAME] | Pennie | SSA | Booked | 2012-03-06 00:00:00 | Completed | 39
Spreadsheet: 357246d1415350193-count-occurences-of-products-count-occurences-of-products-product-type_max-djw
Sheet: Blad2

[NAME] type | Q
Product 1 | 1
Product 2 | 0
Product 3 | 0
Product 4 | 0
 | 1
 | 0
 | 0
 | 0
 | 0
 | 1
 | 0
 | 0
 | 0
 | 1
 | 0
 | 0
 | 1
 | 0
 | 0
 | 0
 | 0
 | 1
 | 0
 | 0
 | 3
 | 0
 | 0
 | 0
 | 0
 | 1
 | 0
 | 0
 | 1
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 2
Spreadsheet: 740748d1626530989-correction-needed-for-calculating-running-quantity-example_running_quantity_v1-ans
Sheet: Bitcoin Cash

TOTALS
Purchase Quantity
Sale Quantity
Outstanding
 |  |  |  |  | TRANSACTION |  |  |  |  | OUTBOUND (Past) |  |  | OUTSTANDING (What's left to sell) |  |  | P/L
Trade Symbol | Transaction | Date | Sale Portion | [NAME] | Quantity Bought(+) / Sold(-) | Price | Fees | Amount | Running Quantity (Cumulative) | Quantity Sold | Price | Amount (Cost of Goods Sold) | Quantity Remaing | Price | Amount (Inventory Value) | Gain(+) / Loss(-) Running Balance | Gain(+) / Loss(-) per Sales Only
 | Purchase | 2021-02-22 00:00:00 |  |  | 0.16587323 | 602.87 | 0
 | Purchase | 2021-02-22 00:00:00 |  |  | 0.04451012 | 561.67 | 0
 | Purchase | 2021-02-23 00:00:00 |  |  | 0.15100926 | 496.58 | 0
 | Purchase | 2021-02-23 00:00:00 |  |  | 0.11111111 | 450 | 0
 | Purchase | 2021-02-28 00:00:00 |  |  | 0.10816891 | 462.42 | 0
 | Purchase | 2021-02-28 00:00:00 |  |  | 0.11270653 | 443.63 | 0
 | Sale | 2021-03-29 00:00:00 | All | Short | -0.69337916 | 519.36 | 0
 | Purchase | 2021-04-17 00:00:00 |  |  | 0.554502 | 902.36 | 0
 | Purchase | 2021-04-17 00:00:00 |  |  | 0.61494416 | 813.13 | 0
 | Purchase | 2021-04-27 00:00:00 |  |  | 1.17063065 | 854.23 | 0
 | Purchase | 2021-05-02 00:00:00 |  |  | 5.10172846 | 983.61 | 0
 | Sale | 2021-05-04 00:00:00 | All | Short | -7.44180527 | 1014.32 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 5.15060365 | 974.86 | 0
 | Sale | 2021-05-04 00:00:00 | All | Short | -5.15060365 | 1025.24 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 8.24243505 | 1219.08 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 7.65726099 | 1312.47 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 24.72614011 | 1536.47 | 0
 | Sale | 2021-05-06 00:00:00 | Partial | Short | -24.68352277 | 1328.21 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 24.74989886 | 1419.39 | 0
 | Sale | 2021-05-06 00:00:00 | Partial | Short | -24.54245845 | 1418.87 | 0
 | Sale | 2021-05-06 00:00:00 | All | Short | -16.14975379 | 1418.66 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 6.47642717 | 1550.14 | 0
 | Sale | 2021-05-06 00:00:00 | All | Short | -6.47642717 | 1430.38 | 0
 | Purchase | 2021-05-07 00:00:00 |  |  | 2.1405484 | 1407.57 | 0
 | Sale | 2021-05-07 00:00:00 | All | Short | -2.1405484 | 1313.06 | 0
 | Purchase | 2021-05-08 00:00:00 |  |  | 3.69139067 | 1359.35 | 0
 | Purchase | 2021-05-09 00:00:00 |  |  | 3.750786 | 1337.16 | 0
 | Purchase | 2021-05-09 00:00:00 |  |  | 0.07247375 | 1379.49 | 0
 | Purchase | 2021-05-12 00:00:00 |  |  | 3.38109696 | 1483.42 | 0
 | Purchase | 2021-05-12 00:00:00 |  |  | 2.27272727 | 1320 | 0
 | Purchase | 2021-05-12 00:00:00 |  |  | 0.77615318 | 1290.07 | 0
 | Purchase | 2021-05-12 00:00:00 |  |  | 1.55162649 | 1289.42 | 0
 | Purchase | 2021-05-12 00:00:00 |  |  | 0.83187062 | 1214.13 | 0
 | Purchase | 2021-05-12 00:00:00 |  |  | 2.53613156 | 1185.63 | 0
 | Purchase | 2021-05-13 00:00:00 |  |  | 1.70138918 | 1178.89 | 0
 | Purchase | 2021-05-13 00:00:00 |  |  | 12.43269681 | 1211.99 | 0
 | Purchase | 2021-05-15 00:00:00 |  |  | 2.54965863 | 1176.21 | 0
 | Purchase | 2021-05-18 00:00:00 |  |  | 1.74241591 | 1091.43 | 0
Spreadsheet: 793971d1661827628-removing-items-based-on-their-absence-in-subsequent-columns-sample-data
Sheet: Sheet5

 | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 |  | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21
 | 1523338 | 1523338 | 1523338 | 1523338 | 1523338
 | 11987616 | 11987616 | 11987616 | 11987616 | 11987616 |  | 11987616 | 11987616 | 11987616 | 11987616
 | 1502206 | 1502206 | 1502206 | 1575160 | 1502206 |  | 1502206 | 1502206 | 1575160 | 1575160
 | 1575160 | 1575160 | 1575160 | 53357781 | 1575160 |  | 1575160 | 1575160 | 53357781 | 53357781
 | 53357781 | 53357781 | 53357781 | 55853580 | 53357781 |  | 53357781 | 53357781 | 55853580 | 55853580
 | 55853580 | 55853580 | 55853580 | 64105489 | 55853580 |  | 55853580 | 55853580 | 64105489 | 64105489
 | 64105489 | 64105489 | 64105489 | 65301956 | 64105489 |  | 64105489 | 64105489 | 65301956 | 65301956
 | 65225542A | 65225542A | 65225542A | 69341720 | 65225542A |  | 65225542A | 65225542A | 69341720 | 69341720
 | 65301956 | 65301956 | 65301956 | 78470850 | 65301956 |  | 65301956 | 65301956 | 78470850 | 78470850
 | 69341720 | 69341720 | 69341720 | 80560243 | 69341720 |  | 69341720 | 69341720 | 80560243 | 80560243
 | 73247781 | 73247781 | 73247781 | 81811905 | 73247781 |  | 73247781 | 73247781 | 81811905 | 81811905
 | 78470850 | 78470850 | 78470850 | 82283178 | 78470850 |  | 78470850 | 78470850 | 82283178 | 82283178
 | 81811905 | 81811905 | 80560243 | 82306323 | 80560243 |  | 81811905 | 81811905 | 82306323 | 82306323
 | 82283178 | 82283178 | 81811905 | 82306359 | 81811905 |  | 82283178 | 82283178 | 82306359 | 82306359
 | 82306323 | 82306323 | 82283178 | 84017945 | 82283178 |  | 82306323 | 82306323 | 84017945 | 84017945
 | 82306359 | 82306359 | 82306323 | 86858938 | 82306323 |  | 82306359 | 82306359 | 86858938 | 86858938
 | 84017945 | 84017945 | 82306359 | 89643723 | 82306359 |  | 84017945 | 84017945 | 89643723 | 89643723
 | 89643723 | 86858938 | 84017945 | 90371073 | 84017945 |  | 89643723 | 86858938 | 90371073 | 90371073
 | 90371073 | 89643723 | 86858938 | 91198828 | 86858938 |  | 90371073 | 89643723 | 91198828 | 91198828
 | 65301937 | 90371073 | 89643723 | 91213766 | 89643723 |  | 65301937 | 90371073 | 91213766 | 91213766
 |  | 65301937 | 90371073 |  | 90371073
 |  |  | 91198828 |  | 91198828
 |  |  | 91213766 |  | 91213766
Spreadsheet: 209245d1359047592-check-if-the-values-of-a-list-are-in-progressive-order-checkifnumbersdescendlefttoright-excludezeros-
Sheet: Feuil1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Expected result
 | 0 | 0 | 0 | 16 | 12 | 10 | 1 | 0 | 0 | 0 | 0 | 0 | 1
 | 12 | 4 | 12 | 0 | 0 | 1 | 0 | 10 | 0 | 0 | 0 | 0 | 1
 | 19 | 0 | 2 | 1 | 0 | 2 | 10 | 5 | 0 | 0 | 0 | 0 | 1
 | 15 | 8 | 8 | 0 | 7 | 6 | 5 | 4 | 0 | 0 | 3 | 2 | 1
 | 15 | 8 | 8 | 0 | 7 | 5 | 6 | 4 | 0 | 0 | 3 | 2 | 1
Spreadsheet: 183175d1348733333-cannot-filter-by-value-0a1_fot_ftest-for-fotis
Sheet: Sheet1

Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Notes
 |  |  |  |  |  |  |  |  |  |  | I cannot filter the above column
 |  |  |  |  |  |  |  |  |  |  | kl
 |  | 22 | a | 15 |  |  |  | 10 |  |  | I cannot filter the above column
 |  |  | a |  |  |  |  |  |  |  | gghj
Spreadsheet: fa22363f-32a9-4e24-ac8a-5aa5fa4e9534
Sheet: Sheet1

Unnamed: 0 | STATE OF COLORADO | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | OFFICE OF THE STATE ARCHITECT
 | STATE BUILDINGS PROGRAMS |  |  |  |  | DATE:
 | CONTRACTOR'S APPLICATION FOR PAYMENT
[NAME] of Schedule of Values |  |  |  |  | Totals of Work Completed and Stored to Date
(A) | (B) | (C) | (D) | (E) | (F) | (G) | (H) | (I) | (J)
Item No. | Description of Work |  | Labor and | Totals | Materials | WORK IN PLACE |  | Total | % Complete
 |  | Material | Other | (C + D) | On-Site |  |  | Amount Due | and in Place
 |  |  |  |  | But Not | Material | Labor and | to Date | (I / E)
 |  |  |  |  | In Place |  | Other | (F+G+H)
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 0 |  |  |  | 0
(K) | ORIGINAL CONTRACT TOTALS (SUM) | 0 | 0 | 0 | 0 | 0 | 0 | 0
(L) | AMENDMENTS/CHANGE ORDER DEDUCTIONS |  |  | 0 |  |  |  | 0
(M) | AMENDMENTS/CHANGE ORDER ADDITIONS |  |  | 0 |  |  |  | 0
(N) | PRESENT CONTRACT TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 82274d1282260038-converting-multiple-columns-into-multiple-rows-temp2
Sheet: Needed Results

Line Name | Sub-Type Mod | Sub-Type Mod | Sub-Type Mod | Sub-Type Mod
9959 | Field Operators Reports | Miscellaneous | PLOTSEQ | Velocity Information (VPREP)
9956 | Field Operators Reports | Miscellaneous | PLOTSEQ | Velocity Information (VPREP)
9951A | Field Operators Reports | Miscellaneous | PLOTSEQ
332 | Miscellaneous | PLOTSEQ
Spreadsheet: 735167d1622731735-difficulty-exclusding-duplicates-when-using-sumproduct-or-sumifs-with-multiple-criteria-test-data
Sheet: Problem

 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | COST CENTRE | Name |  |  | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
 | H0F100 | Mrs A
 | H0F100 | Miss B
 | H0F100 | Mr J
 | H0F100 | Mr T
 | H0F120 | Miss H
 | H0F120 | Mr B
 | H0F130 | Mr G
 | H0F130 | Mr F
Spreadsheet: 687411d1595182840-help-with-formula-across-2-spreadsheets-quote-record-ex-rossc0-
Sheet: Quote No.

Quote No. | Client | Description | Date | Engineer | Value | Job no. if ordered
10236 |  |  | 2020-07-01 00:00:00 |  | 187000
10237 |  |  | 2020-07-02 00:00:00 |  | 644646
10238 |  |  | 2020-07-02 00:00:00 |  | 29200
10239 |  |  | 2020-07-02 00:00:00 |  | 2930 | 23343
10240 |  |  | 2020-07-06 00:00:00 |  | 485 | 23338
10241-1 |  |  | 2020-07-06 00:00:00 |  | 2045 | 23341
10242 |  |  | 2020-07-06 00:00:00 |  | 19660
10243 |  |  | 2020-07-07 00:00:00 |  | 600 | 23339
10244-2 |  |  | 2020-07-09 00:00:00 |  | 83700
10245 |  |  | 2020-07-10 00:00:00 |  | 78000
10246 |  |  | 2020-07-13 00:00:00 |  | 499800
10247 |  |  | 2020-07-10 00:00:00 |  | 960
10248 |  |  | 2020-07-13 00:00:00 |  | 189.12 | 23342
10249 |  |  | 2020-07-14 00:00:00 |  | 1524.24
10250 |  |  | 2020-07-14 00:00:00 |  | 4650
10251 |  |  | 2020-07-17 00:00:00 |  | 450000
10252 |  |  | 2020-07-14 00:00:00 |  | 8600
10253 |  |  | 2020-07-15 00:00:00 |  | 121000
10254 |  |  | 2020-07-15 00:00:00 |  | 20000
10255 |  |  | 2020-07-15 00:00:00 |  | 500
10256 |  |  | 2020-07-16 00:00:00 |  | 1500
10257 |  |  | 2020-07-16 00:00:00 |  | 450
Spreadsheet: 91032d1290706727-vlookup-with-multiple-values-tooling
Sheet: Tooling

 | Area | Machine | Description | Equipment | Location | Notes
AM054F | PATT SHOP | [NAME] | CORESETTER | AM054.02 | Z3
AM054F | PATT SHOP | [NAME] | RAM PLATE | AM054.02 | A3
AM054F | PATT SHOP | [NAME] | SWING PLATE | AM054.02 | A3
AM054F | CORE SHOP | HANSBERG | UCB VANE INSERT | AM054B
AM054F | CORE SHOP | HANSBERG | LCB VANE INSERT | AM054B
AM054F | CORE SHOP | HANSBERG | BLOW TUBE | 3GB1
AM054F | PATT SHOP | [NAME] | SWING PL. INSERT | AM054B |  | NO INSERTS FOUND
AM054F | PATT SHOP | [NAME] | ADAPTOR SET  R/S | T305
AM054F | PATT SHOP | [NAME] | ADAPTOR CSETTER | T295
AM054F | FETT SHOP | AUTO FETT | AUTOFETT JIG | JIG 1
AM054F | FETT SHOP | AUTO FETT | AUTOFETT CLAMP | CLAMP 4
AM054F | FETT SHOP | AUTO FETT | AUTOFETT LOADER | LOADER 150
AM054F | FETT SHOP | AUTO FETT | AUTOFETT GAUGE | GAUGE 4
AM054F | CORE SHOP | HANSBERG 7 | BLOW TUBE | BT03
AM054F | CORE SHOP | HANSBERG | LCB CENT. INSERT | AM054B
Spreadsheet: a7beaab0-9d2a-4e5f-9bdf-d977c312af93
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
GEN | Test | GEN | Bacterial Culture, Aerobic | Bacterial Culture, Aerobic | Conventional Culture Technique | Varies: Var |  |  |  |  | Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen.  [NAME] must be received in laboratory within 24 hours of collection.   [NAME] source is required; include the specific anatomic source. Indicate whether it is a "surface" or "deep/surgical" specimen. Do not label only as "wound."   Preferred: [NAME] abscess Container/Tube: Sterile container [NAME]: Entire collection Collection Instructions: Aspirate the abscess contents with a syringe. Specimen Stability Information: Ambient   Acceptable: [NAME] abscess, swab, tissue, or fluid Sources: Abscess, aspirate, lesion, or wound Container/Tube: Sterile container or culture transport swab Collection Instructions: For most open lesions and abscesses, remove superficial flora by decontaminating skin before collecting a specimen from advancing margin or base.  Additional Information: 1. If submitting a specimen from a source contaminated with usual flora, send at refrigerated temperature. 2. Refrigerated specimens are not suitable for isolation of Neisseria species. Specimen Stability Information: Ambient | 0.5 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | No growth or usual flora Identification of probable pathogens | Monday through Sunday; Continuously | 5 days | 14 days | 1 | 87070 |  |  |  |  | Rochester
GEN | [NAME] | VARIES | Varies |  |  |  | See instructions | 24 hours
GEN | Order Question | Q00M0027 | [NAME] |  | Plain Text
GEN | Result | GEN | Bacterial Culture, Aerobic | Bacterial Culture, Aerobic | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 295043d1391577881-combine-two-lists-while-matching-column-values-help-2sheets-
Sheet: List 1

2001 | 2002 | 2003 | 2004 | Description
1234 | 1234 |  | 1234 | Wagon
 | 1111 | 1111 | 1111 | Wheel
 |  |  | 2222 | Shovel
1221 | 1221 | 1221 | 1221 | Post
8888 |  |  | 8888 | Battery
Spreadsheet: 00c1599c-bcc6-4c25-82ea-61cd062a6024
Sheet: Sheet1

Table 5--Cottonseed meal:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 | 1,000 short tons
2010/11 | 54.233 | 1163 | 0 | 1217.233 |  | 1079.705 | 92.528 | 1172.233 | 45
2011/121 | 45 | 1090 | 0 | 1135 |  | 982.058 | 102.942 | 1085 | 50
2012/132 | 50 | 1125 | 0.2 | 1175.2 |  | 1040.2 | 85 | 1125.2 | 50
1 Estimated.  2 Forecast.
Source:  USDA, Foreign Agricultural Service, PS&D Online.
Last update: | 2013-01-15 11:17:37.200000
Spreadsheet: 107439d1304607327-using-vlookup-for-duplicated-numbers-sample-2
Sheet: Sheet1

Branch | [NAME] | Excel Result | Expected Result
300504 | 17022 | 17022 | 17022
300504 | 304932 | 17022 | 304932
300504 | 305552 | 17022 | 305552
300507 | 458150 | 458150 | 458150
300512 | 258621 | 258621 | 258621
300530 | 351642 | 351642 | 351642
300628 | 14576 | 14576 | 14576
300631 | 309302 | 309302 | 309302
300643 | 459824 | 459824 | 459824
Spreadsheet: louise_kitchen__22501__Turbine Position Report 072701
Sheet: Summary by Status

Turbine Position Report |  |  |  |  |  |  | CONFIDENTIAL
Summary by Status
($ MMs)
 |  |  |  |  |  | Financial Data as of
UNITS | MODEL | CONTROLLED BY | PROJECT(S) | DASH APPROVAL DATE / STATUS | CONTRACT COST | SCHEDULED CONTRACT PYMTS TO DATE | CANCELLATION COST TO DATE | STATUS
COMMITTED - turbines committed to deals which have been DASHed and financing is in process.
2 | 7EA |  |  |  |  |  |  | Committed
 |  |  | Total Committed
TENTATIVE - turbines tentatively committed to ONE deal which has not yet been DASHed, but is likely to be.
1 | MHI 501F simple cycle |  |  |  |  |  |  | Tentative
1 | 7FA |  |  |  |  |  |  | Tentative
2 | MHI 501F simple cycle |  |  |  |  |  |  | Tentative
 |  |  | Total Tentative
AVAILABLE - turbines which may be potential matches with SEVERAL deals, none of which have been approved to date.
1 | MHI 501F simple cycle |  |  |  |  |  |  | Available
1 | 501D5A simple cycle |  |  |  |  |  |  | Available
3 | 9FA STAG power islands |  |  |  |  |  |  | Available
2 | 11N1 |  |  |  |  |  |  | Available
2 | Fr 6B 60hz power barges (BV=0) |  |  |  |  |  |  | Available
1 | LM6000 |  |  |  |  |  |  | Available
 |  |  | Total Available
NEGOTIATING - turbines for which the purchase is currently being negotiated, but Enron does not yet have control of these turbines.
 |  |  | Total Negotiating
 | UNITS - TOTAL |  | GRAND TOTALS
SCHEDULED VS CANCELLATION PAYMENTS
($ MMs)
*  Total Cancellation Payments = Total Enron Exposure
Spreadsheet: 76972d1277413152-conditional-formatting-testing-two-cells-excel-cf-example
Sheet: Sheet1

Sales Budget Variance Example
Account # | Description | Actual | Budget | $ [NAME] | % Budget Variance |  | Actual | $ [NAME] from Actual | % Variance from Actual
 | OPERATING REVENUES
7440 | Account # 1 | 21838615.46 | 23634700 | -1796084.540000003 | -0.076 |  | 18675906.43 | 3162709.030000001 | 0.169
7441 | Account # 2 | 4050274.87 | 4126600 | -76325.12999999989 | -0.018 |  | 3304106.35 | 746168.52 | 0.226
7442 | Account # 3 | 14826436.89 | 15615800 | -789363.1099999994 | -0.051 |  | 13346213.92 | 1480222.969999999 | 0.111
7443 | Account # 4 | 20404595.25 | 21447200 | -1042604.75 | -0.049 |  | 18822492.41 | 1582102.840000004 | 0.084
7444 | Account # 5 | -202000 | 0 | -202000 | 0 |  | 365000 | -567000 | -1.553
7445 | Account # 6 | 2595556.42 | 1789200 | 806356.4199999999 | 0.451 |  | 2412816.25 | 182740.1699999999 | 0.076
7446 | Account # 7 | 622427.49 | 753900 | -131472.51 | -0.174 |  | 564061.92 | 58365.56999999995 | 0.103
7447 | Account # 8 | 1534129.26 | 1543100 | -8970.73999999999 | -0.006 |  | 1528903.92 | 5225.340000000084 | 0.003
7448 | Account # 9 | 348859.78 | 347200 | 1659.780000000028 | 0.005 |  | 347738.92 | 1120.860000000044 | 0.003
7449 | Account # 10 | 69289.53 | 65000 | 4289.529999999999 | 0.066 |  | 61329.31 | 7960.220000000001 | 0.13
7450 | Account # 11 | 195520.67 | 232300 | -36779.32999999999 | -0.158 |  | 193626 | 1894.670000000013 | 0.01
7451 | Account # 12 | 217581.24 | 223300 | -5718.760000000009 | -0.026 |  | 225678.45 | -8097.210000000021 | -0.036
7452 | Account # 13 | 84550.42 | 80000 | 4550.419999999998 | 0.057 |  | 84801.24 | -250.820000000007 | -0.003
7453 | Account # 14 | 91934.19 | 90000 | 1934.190000000002 | 0.021 |  | 89829.39 | 2104.800000000003 | 0.023
7454 | Account # 15 | 231728.35 | 230000 | 1728.350000000006 | 0.008 |  | 231045.4 | 682.9500000000116 | 0.003
7455 | Account # 16 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
7456 | Account # 17 | 5205 | 5300 | -95 | -0.018 |  | 5280 | -75 | -0.014
7457 | Account # 18 | 20118.73 | 20000 | 118.7299999999996 | 0.006 |  | 20691.17 | -572.4399999999987 | -0.028
7458 | Account # 19 | 44240.7 | 0 | 44240.7 | 0 |  | 211.76 | 44028.94 | 207.919
7459 | Account # 20 | 29892.98 | 0 | 29892.98 | 0 |  | 0 | 29892.98 | 0
7460 | Account # 21 | 14034.62 | 12700 | 1334.620000000001 | 0.105 |  | 37877.42 | -23842.8 | -0.629
 | $ budget variances that are GT or LT $5,000 and % variances that are GT or LT 5%
Spreadsheet: 217960d1362268388-how-to-fill-row-based-on-multiple-criteria-with-the-most-recent-of-multiple-matches-dummysample-1
Sheet: Sample Use Log

Box | Position | Sample Name | Concentration | LOT # | Original Amount (ug) | Deducted (ug) | Amount Remaining | [NAME] (ul) | Requestor | Aliquot # | Date Aliquotted | Aliquotter
1 | 1 | Sample 1 | 500 | 123456 | 250 | 50 | 200 | 100 | AB | A1 | 2013-01-01 00:00:00 | ME
D2 | 2 | Sample 2 | 1000 | 543253 | 250 | 50 | 200 | 50 | BC | A1 | 2013-01-02 00:00:00 | ME
1 | 2 | Sample 3 | 2000 | 734902 | 250 | 50 | 200 | 25 | CD | A1 | 2013-01-03 00:00:00 | ME
2 | 3 | Sample 4 | 700 | 183087 | 250 | 50 | 200 | 71.42857142857143 | EF | A1 | 2013-02-05 00:00:00 | ME
1 | 1 | Sample 1 | 500 | 123456 | 200 | 50 | 150 | 100 | GH | A2 | 2013-02-06 00:00:00 | ME
1 | 3 | Sample 6 | 50 | 749584 | 250 | 50 | 200 | 1000 | IJ | A1 | 2013-02-07 00:00:00 | ME
2 | 5 | Sample 7 | 900 | 647597 | 250 | 50 | 200 | 55.55555555555555 | KL | A1 | 2013-02-08 00:00:00 | ME
1 | 5 | Sample 8 | 2300 | 876509 | 250 | 50 | 200 | 21.73913043478261 | MN | A1 | 2013-01-08 00:00:00 | ME
1 | 1 | Sample 1 | 500 | 123456 | 150 | 50 | 100 | 100 | OP | A3 | 2013-03-01 00:00:00 | ME
D2 | 2 | Sample 2 | 1000 | 543253 | 200 | 50 | 150 | 50 | QR | A2 | 2013-03-01 00:00:00 | ME
Input | Input | OUTPUT (Based on Values input into A13 & B13)* | OUTPUT | OUTPUT | OUTPUT** | [NAME] | =F13-G13 | =G13/D13*1000 | [NAME] | OUTPUT | [NAME] | [NAME]
1 | 1 | Sample 1 | 500 | 123456 | 100 |  |  |  |  | A4 |  |  | Example of Desired Output
D2 | 3 | Sample 10 | 3000 | 654321 | 500 |  |  |  |  | A1 |  |  | Or this from 'Sample Duplicate List'
 |  | * I sucessfully generated a MATCH INDEX equation (can't access it now because it is on my work computer) that works for this sheet only (i.e. only works if the sample has been previously aliquotted and added to this sheet), but I have not attempted extending the array to the sample inventory & Sample Duplicate Sheets (there are even more sheets, but it's too much work to re-create them all in this dummy workbook).     My goal here is to fill-in the name corresponding to the box & position regardless of whether it was previously entered into this sheeet of the workbook or it is in another sheet of this workbook if that is even possible. | (See C15) | (See C15) | ** The main issue with the Index Match combo I created (again, sorry I do not have it on hand) is that when I adapt it so that it will return the last known amount (which should be in column H after the last aliquot), I can only get it to return the remaining amount following the first aliquot, which provides incorrect data when a sample has been aliquotted multiple times.  I do not know how to
 |  | (Note: The best outcome would be if the formula could search the 'Sample Use Log' first, then 'Sample Duplicate List', then finally the 'Sample Inventory' sheet of this workbook, again only if this is possible)