tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: tracy_geaccone__40528__sharris1001wk4
Sheet: Current Est Vs. Forecast 

Transwestern Pipeline Company
($[NAME])
October:  10/01/01 thru 10/23/01 |  |  |  |  |  | 2001-10-25 08:09:28.530000
Current Estimate vs. Forecast |  | October, 2001
 |  | 3rd Current | Weekly
 |  | Estimate | Forecast | [NAME] |  | Comments
West Demand Revenues |  | 10.42 | 10.539 | 0.1189999999999998 |  | USGT $11K,  Astra $3K Negotiated Rate
 |  |  |  |  |  | New Contracts:  PPL EnergyPlus, [NAME]
West Commodity Revenues |  | 0.822063 | 0.9111659999999997 | 0.08910299999999971 |  | West IT deals $107K
East Demand Revenues |  | 1.111 | 1.228 | 0.117 |  | Assumed [NAME] turn back in October
East Commodity Revenues |  | 0.143 | 0.1679999999999999 | 0.02499999999999991 |  | Higher IT Rates
[NAME] |  | 0.672 | 0.703 | 0.03099999999999992 |  | New Contract: Burlington; Reliant $13K
[NAME] Revenues |  | 0.08399999999999996 | 0.06800000000000006 | -0.0159999999999999 |  | Lower IT Volumes
PNR Revenues |  | 0 | 0.005047899999999999 | 0.005047899999999999
Revenue Variance |  | 13.252063 | 13.6222139 | 0.3701508999999952
Fuel Price [NAME] |  | 0.612 | 0.523 | -0.08899999999999997 |  | MTD index price of $1.95 vs. 3nd CE index price of $2.28
Fuel Volume Variance-Unhedged |  | 0 | -0.131 | -0.131 |  | Lower retained volumes
Sales Margin Variance on Unhedged |  | 0 | 0.067 | 0.067 |  | Over-retained fuel sales
Hedging Adjustment |  | 2.206 | 2.206 | 0
Other Adjustment |  | 0 | 0 | 0
Fuel Variance (Excludes UAF) |  | 2.818 | 2.666 | -0.153
Current Month Margin Variance |  | 16.070063 | 16.2882139 | 0.2171508999999952
Expenses |  | -0.944 | -0.944 | 0
Non-Recurring |  | 0 | 0 | 0
Other |  | -0.004 | -0.004 | 0
Total Current Month Variance |  | 15.122063 | 15.3402139 | 0.2171508999999952
[NAME] |  | 48.063 | 47.153 | -0.9100000000000037
2nd Qtr |  | 52.278 | 52.278 | 0
1st Qtr |  | 47.784 | 47.784 | 0
October 31, 2001 YTD |  | 163.247063 | 162.5552139 | -0.6928491000000085 |  | Includes September Actuals
 |  |  |  |  |  | YTD variance decreased due to OBA re-evaluations for August & September
Spreadsheet: 709450d1608308630-function-to-calculate-if-device-is-under-warranty-warranty-checks
Sheet: main

Serial Number | Receival Date | Manufactured | Warranty date | Warranty Check
N018316013 |  | 2018-11-12 00:00:00 | 2020-11-12 00:00:00 | Out of Warranty
N120119247 |  | 2020-04-28 00:00:00 | 2022-04-28 00:00:00 | Under Warranty
N119178385 |  | 2019-06-27 00:00:00 | 2021-06-27 00:00:00 | Under Warranty
N119178382 |  | 2018-06-27 00:00:00 | 2021-06-27 00:00:00 | Out of Warranty
[NAME] |  | 2019-09-06 00:00:00 | 2021-09-06 00:00:00 | Under Warranty
Spreadsheet: 978ec7d4-51d9-4f38-a34b-468ba38837fa
Sheet: Sheet1

Modem Adapter | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Cod. Interno | Cod. Produttore | Produttore | Descrizione
BB.256.04 | ACCY-BATAA36V | B&B Electronics | 3.6V 2400MAH LITHIUM AA BATTERY
BB.256.05 | DRAD35 | B&B Electronics | DIN RAIL ADAPTER CLIPS FOR DE-311
BB.256.06 | EK-CLIP-MPC | B&B Electronics | DIN CLIP FOR BLACK POLYCASE ENCLOSURE
BB.256.08 | MFDTE25 | B&B Electronics | DCE TO DTE PORT REVERSER, DB25 [NAME]
BB.256.09 | MFNM25 | B&B Electronics | NULL MODEM ADAPTER DB25 [NAME]
BB.256.07 | MF23R25 | B&B Electronics | NULL MODEM ADAPTER PIN 2-3 RVSR DB25 [NAME]
BB.256.10 | MMNM25 | B&B Electronics | NULL MODEM ADAPTER DB25 [NAME]
BB.256.11 | MMNM9 | B&B Electronics | NULL MODEM ADAPTER, [NAME]
BB.255.98 | 232MH | B&B Electronics | SET OF MALE HOLDING HARDWARE
BB.256.00 | 232SGM | B&B Electronics | 25 PIN GENDER REV LOWPRO M/M
BB.256.01 | 9PMFJB | B&B Electronics | 9-PIN M/F JUMBER BOX
BB.256.02 | 9PMMNM | B&B Electronics | 9 PIN MALE TO MALE NULL MODE
BB.256.03 | 9SGM | B&B Electronics | 9P GEN REV LOW PRO MM
Spreadsheet: 766871d1644131087-drag-a-formula-across-365-columns-skipping-1-row-every-3-columns-dragged-test10-ans-2-
Sheet: TAB3

I need the red fixed
Spreadsheet: 179634d1347329209-match-names-and-sum-the-2-values-from-matched-names-summatch
Sheet: Sheet1

Names
A | 23
B | 14
C | 56
D | 78
Names | Value |  | Value P
F | 10
D | 12
R | 23
A | 45
B | 14
Spreadsheet: 843159d1695105586-calculating-prices-for-duplicate-products-based-on-smallest-quantity-excel-forum-19-september
Sheet: Sheet2

Product Name | Quantity | Price (Formula Downwards) | Total
A | 5 |  | 30
A | 5 |  | 30
A | 5 |  | 30
B | 5 |  | 56.1
B | 4 |  | 56.1
B | 4 |  | 56.1
B | 4 |  | 56.1
B | 4 |  | 56.1
C | 5 |  | 34
C | 5 |  | 34
C | 5 |  | 34
F | 5 |  | 68.85
F | 5 |  | 68.85
F | 5 |  | 68.85
F | 5 |  | 68.85
F | 6 |  | 70
H | 4 | D18/B18 shall be 28.05 | 56.1
H | 2 |  | 56.1
H | 2 |  | 56.1
H | 2 |  | 56.1
H | 2 |  | 56.1
K | 4 | D23/B23   shall be 17 | 51
K | 3 |  | 51
K | 3 |  | 51
K | 3 |  | 51
K | 3 |  | 51
Spreadsheet: 63037d1264004263-duplicate-rows-combining-and-flipping-class_pivot
Sheet: Sheet2

Sum of Grade | Quarter | Class
 | 1 |  |  |  | 2 |  |  |  | Grand Total
Student | Chemistry | Math | English | Geography | Chemistry | Math | English | Geography
[NAME] | 70 | 60 | 85 | 60 | 64 | 52 | 88 | 58 | 537
Millie | 75 | 72 | 64 | 89 | 64 | 75 | 90 | 55 | 584
[NAME] | 88 | 79 | 87 | 85 | 94 | 73 | 60 | 71 | 637
[NAME] | 70 | 95 | 91 | 81 | 80 | 100 | 56 | 59 | 632
[NAME] | 93 | 94 | 86 | 65 | 68 | 77 | 93 | 75 | 651
[NAME] | 67 | 88 | 71 | 79 | 47 | 85 | 75 | 72 | 584
Grand Total | 463 | 488 | 484 | 459 | 417 | 462 | 462 | 390 | 3625
Spreadsheet: 696408d1600796295-count-if-a-win-and-on-a-saturday-soccer-stats
Sheet: 2020 Season Avgs.

 | W | L | D | Pts | [NAME].
Player 1
Player 2
Player 3
Player 4
Player 5
Player 6
Player 7
Player 8
Player 9
Player 10
Player 11
Player 12
Player 13
Player 14
Player 15
Player 16
Player 17
Player 18
Player 19
Player 20
Player 21
Player 22
Player 23
Player 24
Player 25
Player 26
Player 27
Player 28
Player 29
Player 30
Player 31
Player 32
Player 33
Player 34
Player 35
Player 36
Player 37
Player 38
Player 39
Player 40
Player 41
Player 42
Player 43
Player 44
Player 45
Spreadsheet: 811827d1672823868-index-match-approximate-with-two-criteria-between-two-worksheets-matching-with-2-criteria
Sheet: Love

 | S/No | Name | Company | Name on "Hello"
 | 1 | [NAME] | ABC
 | 2 | [NAME] | ABC
 | 3 | [NAME] | XYZ
 | 4 | [NAME] | XYZ
 | 5 | [NAME] | XYZ
 | 6 | [NAME] | 123
 | 7 | [NAME] [NAME] | 123
 | 8
 | Need a formula to do the matching from this two worksheet with the outcome on this worksheet column E.  If the matching fits the two criteria (name & company), then the name on "Hello" sheet will be on column E.
Spreadsheet: danny_mccarty__4657__NNG_Wkly1228
Sheet: MarginVarianceReport

NORTHERN NATURAL GAS COMPANY
Current Month Variance to 3rd Current Estimate Report
($ Thousands)
MIDWEST
 |  |  |  |  |  |  | Var. To CE
Demand | Risk Assessed-North |  |  |  | 15
 | -Central |  |  |  | 0
 | SLA Rate Filing - Subject to Refund
 | Taconites |  |  |  | 55
 | Reliant MGO |  |  |  | 0
 | Margin Stretch |  |  |  | 0
 | East Leg |  |  |  | 0
 | Winter TFX Deals
 | MDQ variances |  |  |  | 0
 | Rate Variances
 | Other
Commodity | [NAME]
 | Rates
 | TOTAL MIDWEST [NAME]
PRICING & STRUCTURING
Demand | California markets |  |  |  | 108.08
 | Plants |  |  |  | 21.18
 | [NAME] |  |  |  | 79.38
 | Unattached (plan included tranche 3 & S.P. items) |  |  |  | -227.33
 | Other |  |  |  | -16.096
Commodity | TI volume |  |  |  | -27.97
 | TI rate |  |  |  | 107.938
 | TF/TFX rate |  |  |  | -20.445
 | TF/TFX volume |  |  |  | 45.355
 | TF/TFX overrun |  |  |  | 27.567
 | Other |  |  |  | -22.995
 | TOTAL VARIANCE PRICING & STRUCTURING
OFFSHORE
 | MOPS |  |  |  | 78
 | Other- TI |  |  |  | 91
STORAGE
Demand
Commodity | Month to Month, and Park & Ride
 | TOTAL VARIANCE STORAGE
OTHER REVENUES
Demand | Reserves - ($100) UCU, ($300) A/R
 | Margin Stretch |  |  |  | 0
 | SLA Rate Filing
Commodity | DDVC
 | Reserves |  |  |  | 0
 | SLA Rate Filing |  |  |  | -8
 |  |  |  |  | 0
 | TOTAL [NAME]
TOTAL CURRENT MONTH REVENUE VARIANCE TO CURRENT ESTIMATE
 | Recurring IBIT Stretch
 | Structured Products - Non Recurring
 | [NAME]
TOTAL CURRENT MONTH MARGIN VARIANCE TO CURRENT ESTIMATE
Spreadsheet: 89377d1289184412-extract-data-from-different-sheet-test-1
Sheet: Sheet2

Content | Application Name | Severity | Update | Date Of | Today | Number | Status
Infrastructure System | Active Directory Services (Global) | Low | 2006-04-18 00:00:00 | 2011-04-19 00:00:00 | 2010-11-07 18:46:27 | 5 | X
Application | ARBBL/MOC | Low | 2006-07-06 00:00:00 | 2011-07-07 00:00:00 | 2010-11-07 18:46:27 | 8 | X
Application | AUDIT | Low | 2004-05-04 00:00:00 | 2009-05-05 00:00:00 | 2010-11-07 18:46:27 | 7 | X
Application | AUDIT | Low | 2004-05-04 00:00:00 | 2009-05-05 00:00:00 | 2010-11-07 18:46:27 | 7 | X
Application | ARBBL/MOC | Low | 2006-07-06 00:00:00 | 2011-07-07 00:00:00 | 2010-11-07 18:46:27 | 8 | X
Spreadsheet: 838698d1691261754-weighted-marks-for-school-each-mark-its-own-weighting-sandrotrunz-weighted-grades
Sheet: data

Vorname | class | D | F | M | E Niveau
Alpha | 8B | S | S | S | S
Bravo | 8B | S | S | S | S
Charly | 8B | S | R | R | S
Delta | 8B | R | R | S | S
Echo | 8B | S | S | S | S
Foxtrot | 8B | S | S | S | S
Golf | 8B | S | S | S | S
Hotel | 8B | S | S | S | S
India | 8B
[NAME] | 8B | S | S | S | S
Kilo | 8D |  |  |  | ?
Lima | 8D | R | R | R | S
[NAME] | 8D | S | S | S | S
November | 8D | S | S | S | S
[NAME] | 8D | R | S | S | S
Papa | 8D | S | S | R | S
Quebec | 8D | S | S | S | S
Romeo | 8D | S | S | R | S
Sierra | 8D | S | S | S | S
Tango | 8D | S | S | S | S
Uniform | 8D | S | S | S | S
Victor | 8D | S | R | R | S
Spreadsheet: 121259d1315949941-automatically-fill-data-depending-on-choice-from-drop-down-menu-excel-help-1
Sheet: CL. Au Bos Ser Cro Slo CR Slova

Reporting Period: |  | P08 |  |  | HR Scorecard
 |  |  |  |  | Key Performance Indicator
 | Result Level: |  | Please Select Required Level | KPI Definition
 |  |  | KPIs | Unit | P 08/11 | P 09/11 | P 10/11 | P 11/11 | P 12/12 | Target | Comment
 |  |  |  | % | 7 | 6 | 5 | 4 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Please Select Required Level
 |  |  |  | % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SE Region
 |  |  |  | % | 7 | 6 | 5 | 4 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster Italy/Spain
 |  |  |  | % | 7 | 6 | 5 | 4 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster Portugal
 |  |  |  | % | 7 | 6 | 5 | 4 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster Hungary/Bulgaria/Romania
 |  |  |  | % | 7 | 6 | 5 | 4 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster Israel/Greece/Cyprus/Malta/Albania
 |  |  |  | € | 7 | 6 | 5 | 4 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster Hungary/Bulgaria/Romania
 |  |  |  | Avearge number | 7 | 6 | 5 | 4 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | % | 7 | 6 | 5 | 4 | 3
 |  |  |  | Avearge number | 7 | 6 | 5 | 4 | 3
 |  |  |  | % | 7 | 6 | 5 | 4 | 3
 |  |  |  | % | 7 | 6 | 5 | 4 | 3
 |  |  |  | % | 7 | 6 | 5 | 4 | 3
 |  |  |  | % | 7 | 6 | 5 | 4 | 3
 |  |  |  | % | 7 | 6 | 5 | 4 | 3
 |  |  |  | % | 7 | 6 | 5 | 4 | 3
 |  |  |  |  | 7 | 6 | 5 | 4 | 3
 |  |  |  | % | 7 | 6 | 5 | 4 | 3
Spreadsheet: 743401d1628479444-adjustment-of-if-formula-for-depreciation-to-accomodate-disposal-and-nondepreciating-asset-if-formula-depn
Sheet: Sheet1

Kindly asking for help with if formula. I want if Life column is less than the period column, column  (I) do not culculate depreciation.
If column H is blank, no depreciation is calculated. Lastly if disposal occur in column L, no depreciation is calculated.
 |  |  |  |  |  |  |  | depreciation
 | Asset | Price | Year | Salvage | Life | Period | Method | 2021 | B/F Depreciation | Acc Depreciation | Disposal
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | VDB |  |  |  | 0
 | Land | 10000 | 2014 | 1000 | 10 |  |  |  |  |  | 0
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | DB |  |  |  | 0
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | DDB |  |  |  | 30000
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | VDB |  |  |  | 0
 | Desired solution
 | Asset | Price | Year | Salvage | Life | Period | Method | 2021 | B/F Depreciation | Acc Depreciation | Disposal
 | Vehicles | 10000 | 2014 | 1000 | 5 |  | VDB | 0 | 7902.848 | 8322.2784 | 0
 | Land | 10000 | 2014 | 1000 | 10 |  |  | 0 | 0 |  | 0
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | DB |  |  |  | 0
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | DDB | 0 |  | 0 | 30000
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | VDB |  |  |  | 0
Spreadsheet: 219948d1363019467-conditional-formatting-if-d7-is-to-or-b7-color-it-green-if-d7-is-b7-color-it-red-polar-add-on-survival-kit-list
Sheet: Contents List

POLAR ADD-ON KIT
 |  | COST PER UNIT | TOTAL COST | BRAND | SOURCE | SHELF LIFE | ALTERNATIVE BRAND | ALTERNATIVE COST | ALTERNATIVE SOURCE
1 | [NAME] | 135 |  | Northface | http://www.thenorthface.com/
Shelter:
1 | Tent, 4 season expedition, 2 person | 44.05 |  | [NAME] | http://www.amazon.com/ |  | Cabela's | 319.99 | http://www.cabelas.com/
2 | [NAME] (0°) | 40.42 |  | [NAME] | http://www.amazon.com/
2 | Sleeping Pads (Thermarest Inflatable) | 12
2 | Winter Hats | 5.99 |  | Dickies | http://www.amazon.com/
2 | Pair Winter Mitts | 35.99 |  | Dakine | http://www.zappos.com/
Fire, Heat, & Light:
1 | Stove, [NAME] | 13
2 | Fuel Bottles, 100g | 5
20 | Chemical Hand Warmers | 0.6 |  | Hothands | http://www.amazon.com/
Food & Water:
6 | Food Rations | 8.49 |  | Mainstay | http://www.amazon.com/ | 5 years
16 | Water Rations 4oz | 2.41 |  | Mainstay | http://www.amazon.com/ | 5 years | Datrex | 0.39 | http://www.amazon.com/
Tool & Utility
1 | Gerber Folding Shovel with [NAME] | 40.44 |  | Gerber 30-000075 E-Tool | http://www.amazon.com/
1 | Snow Saw | 12
 |  | Total Cost of the kit
Spreadsheet: 44416d1243013985-excel-2007-want-to-make-a-order-list-list
Sheet: order

Product | Weight | Price | Quantity
a | 1 | 12 | 1
b | 2 | 1 | 2
c | 3 | 1 | 13
d | 4 | 1 | 0
e | 1 | 1 | 3
f | 2 | 131 | 0
Order |  |  |  | Price | Weight
a | 1 | 12 | 1 | 12 | 1
b | 2 | 1 | 2 | 2 | 4
c | 3 | 1 | 13 | 13 | 39
e | 1 | 1 | 3 | 3 | 3
 |  |  |  | Total Weight: | 47
 |  |  | Total: | 43
Spreadsheet: 799006d1664874644-countifs-with-many-criteria-excel-issue-2
Sheet: Sheet1

Type | Number | Date and time
1K2322 | 0 | 2022-07-28 20:55:25
1L2323 | 3 | 2022-07-28 17:47:00
1K2323 | 4 | 2022-07-28 16:30:45
1K232 | 200 | 2022-07-28 14:26:06
1L4444 | 0 | 2022-07-28 12:21:44
Spreadsheet: 839290d1691790896-xlookup-not-showing-result-sample1
Sheet: Detail

Empl ID | Rcd# | Leave Type | Name | Position | [NAME] | Department | Job Code | Job Title | Payroll Status | Term Date
101268241 | 0 | Excess +/- | Abbott,L | 00001904 | 43425 | Police | 8350 | Police Off | Terminated
200021319 | 0 | Comptime | [NAME],J | 00001985 | 42419 | Custodial Services | 2010 | Custodian | Terminated
200021319 | 0 | Vacation | [NAME],J | 00001985 | 42419 | Custodial Services | 2010 | Custodian | Terminated
109974923 | 1 | Vacation | Adams,A | 00004784 | 81152 | Acad Tech & Dig Access | 0400 | Analyst/Pr | Terminated
106008571 | 0 | Vacation | Bailey,Helen I | 00002526 | 50450 | VP For University Advancement | 1038 | [NAME] | Retired
Spreadsheet: 99838d1298394409-vlookup-and-sumif-price-list-for-job
Sheet: Sheet1

[NAME] for job XXX
Part | Price
555-123
90-555
555-450
Total
Spreadsheet: 772475d1647293864-number-of-hours-between-two-time-frames-book-3-1-
Sheet: Sheet1

 |  |  |  |  |  |  | Late Premium | Night Premium
Name | Payroll Number | Start Time | End Time | Total Hours |  |  | 17:00 - 19:59 | 20:00 - 05:59
[NAME] | 90100 | 12:00:00 | 21:00:00 | 09:00:00
[NAME] | 90101 | 13:00:00 | 04:00:00 | 15:00:00
[NAME] | 90102 | 14:00:00 | 08:00:00 | 18:00:00
[NAME] | 90103 | 03:00:00 | 12:00:00 | 09:00:00
[NAME] | 90104 | 22:00:00 | 09:00:00 | 11:00:00
[NAME] | 90105 | 18:00:00 | 06:00:00 | 12:00:00
[NAME] | 90106 | 05:00:00 | 14:00:00 | 09:00:00
[NAME] | 90107 | 12:00:00 | 02:15:00 | 14:15:00
[NAME] | 90108 | 03:00:00 | 14:00:00 | 11:00:00
[NAME] | 90109 | 09:00:00 | 22:00:00 | 13:00:00
[NAME] | 90110 | 16:00:00 | 02:00:00 | 10:00:00
Spreadsheet: 89195d1288944980-conditional-formatting-with-indirect-address-referance-indirect-address-condfmt
Sheet: Sheet1

 |  |  | Conditional [NAME] |  |  |  |  |  |  | Conditional [NAME]
with Indirect reference |  |  | with Indirect reference |  |  |  | with direct reference |  |  | with direct reference
Name | Number |  | New w/hilite | New w/o hilite | hilight |  | Name | Number |  | New w/hilite | New w/o hilite | hilight
Name 1 | 172 |  | 1 | 0 | 1 |  | Name 1 | 172 |  | 1 | 0 | 1
Name 1 | 300 |  | 0 | 0 | 0 |  | Name 1 | 300 |  | 0 | 0 | 0
Name 1 | 485 |  | 0 | 0 | 1 |  | Name 1 | 485 |  | 0 | 0 | 1
Name 1 | 486 |  | 0 | 0 | 0 |  | Name 1 | 486 |  | 0 | 0 | 0
Name 2 | 100 |  | 1 | 0 | 1 |  | Name 2 | 100 |  | 1 | 0 | 1
Name 2 | 101 |  | 0 | 0 | 0 |  | Name 2 | 101 |  | 0 | 0 | 0
 |  |  |  |  |  |  | name 5
Name 2 | 102 |  | 0 | 1 | 0 |  | Name 2 | 102 |  | 0 | 0 | 0
Name 3 | 1010 |  | 1 | 0 | 1 |  | Name 3 | 1010 |  | 1 | 0 | 1
Name 3 | 1011 |  | 0 | 0 | 0 |  | Name 3 | 1011 |  | 0 | 0 | 0
Name 3 | 1012 |  | 0 | 0 | 1 |  | Name 3 | 1012 |  | 0 | 0 | 1
Name 3 | 1013 |  | 0 | 0 | 0 |  | Name 3 | 1013 |  | 0 | 0 | 0
Name 3 | 1234 |  | 0 | 0 | 1 |  | Name 3 | 1234 |  | 0 | 0 | 1
Name 4 | 5 |  | 0 | 1 | 0 |  | Name 4 | 5 |  | 0 | 1 | 0
Name 5 | 1 |  | 1 | 0 | 1 |  | Name 5 | 1 |  | 1 | 0 | 1
Name 5 | 2 |  | 0 | 0 | 0 |  | Name 5 | 2 |  | 0 | 0 | 0
Name 5 | 3 |  | 0 | 0 | 1 |  | Name 5 | 3 |  | 0 | 0 | 1
Name 5 | 4 |  | 0 | 0 | 0 |  | Name 5 | 4 |  | 0 | 0 | 0
 | New Name - w/Highlight:
 | New Name - w/o Highlight:
 | Highlight:
Spreadsheet: 726074d1617033080-select-a-cell-from-a-list-of-100-cells-example-2
Sheet: INPUT

 | x
 | x
 | x
Spreadsheet: kate_symes__18290__Deal Correction 4-11
Sheet: 4-9

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2001-04-09 00:00:00 | 2001-04-09 00:00:00 | 2001-04-06 00:00:00 | STCA | KS | KS | N/A | Price: from 109.76 to 119.76 |  | 573612 | SP-15 | 2001-04-08 00:00:00 | On [NAME] | Shaped | 119.76 | EES
 | 2001-04-09 00:00:00 | 2001-04-09 00:00:00 | 2001-04-06 00:00:00 | STSW | MF | Houston | N/A | Broker: from Bloomberg to No Broker |  | 573083 | Palo Verde | 4/8/01-4/9/01 | [NAME] | 25 | 100 | Pacificorp
 | 2001-04-09 00:00:00 | 2001-04-09 00:00:00 | 2001-04-04 00:00:00 | STSW | TA | Houston | N/A | Price: from 85 to 80 |  | 570450 | Palo Verde | 2001-04-05 00:00:00 | [NAME] | 10 | 80 | FPL Energy
 | 2001-04-09 00:00:00 | 2001-04-09 00:00:00 | 2001-04-06 00:00:00 | STWS | CF | Houston | N/A | Price: took out basis price |  | 573625 | SP-15 | 2001-04-08 00:00:00 | RTC | 8 | 90 | APX
 | 2001-04-09 00:00:00 | 2001-04-10 00:00:00 | 2001-04-09 00:00:00 | LTCA | PC | Houston | N/A | CTPY: from Port of Oakland to The City of Oakland |  | 576228 | NP-15 | Q3-01 | RTC | 4 | 331 | City of Oakland
 |  |  |  | Grand Count
Spreadsheet: 97821d1296909645-removal-of-a-value-remove-a-char
Sheet: Sheet1

Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Â£1.5m
Spreadsheet: 100ac1f7-e07a-47a8-8505-a0d40fa4f174
Sheet: Sheet1

State Representative - DEM (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 6/19/2013 2:09:27 AM
Precincts Reporting: 693/693 - Total Ballots Cast: 94306
2000 Primary Election - OFFICIAL RESULTS
Precinct | Carol A Niemeier | [NAME] | TOTALS
Combined Precinct | 54 | 58 | 112
TOTAL | 54 | 58 | 112
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 165303d1341152353-copy-data-from-multiple-worksheet-to-master-worksheet-equipment-maintenance
Sheet: Master

Equipment / Asset Code | Description | Category | Make | Model | Serial No. | Range / Capacity | Present Location | Present Status | Owned / Hired | Source details (if hired) | Purchased date (dd/mm/yyyy) | Purchase value (AED) | Annual Maint. Cost | Expenses Till date 2012 | Worked Days | Worked hours /kms | Idle hours | [NAME] hours | Fuel Type | Fuel tank capacity | Fuel consumption / litre | User Manual | TPI last done | TPI next due
AACMP015!A1
AACMP016
AFT-13
 | Here I want to copy fields which I entered manualy in row 2 by formula to be display for all the worksheet in this Master file
Spreadsheet: 142576d1329918446-linking-filters-from-pivot-table-build-plan-copy
Sheet: Build Plan

 | Year | 2012 |  |  |  |  |  | Year | 2012
 | Month | February |  |  |  |  |  | Month | March
 | Product | UH |  |  |  |  |  | Product | UH
 |  |  | Values |  |  |  |  |  |  | Values
 | Week Number | Date | Capacity | Demand | Total Condor Demand | +/- |  | Week Number | Date | Capacity | Demand | Total Condor Demand | +/-
 | 5 | 2012-02-01 00:00:00 | 169 | 169 |  | 0 |  | 9 | 2012-03-01 00:00:00 | 400 | 67 |  | 1464
 |  | 2012-02-02 00:00:00 | 224 | 224 |  | 0 |  | 9 Total |  | 400 | 67 |  | 1464
 | 5 Total |  | 393 | 393 |  | 0 |  | 10 | 2012-03-05 00:00:00 | 400 | 50 |  | 1814
 | 6 | 2012-02-06 00:00:00 | 266 | 266 |  | 0 |  |  | 2012-03-06 00:00:00 | 400 | 20 |  | 2194
 |  | 2012-02-07 00:00:00 | 230 | 230 |  | 0 |  |  | 2012-03-07 00:00:00 | 400 | 5 |  | 2589
 |  | 2012-02-08 00:00:00 | 122 | 122 |  | 0 |  |  | 2012-03-08 00:00:00 | 400 |  |  | 2989
 |  | 2012-02-09 00:00:00 | 80 | 80 |  | 0 |  | 10 Total |  | 1600 | 75 |  | 9586
 | 6 Total |  | 698 | 698 |  | 0 |  | 11 | 2012-03-12 00:00:00 | 400 |  |  | 3389
 | 7 | 2012-02-13 00:00:00 | 163 | 163 |  | 0 |  |  | 2012-03-13 00:00:00 | 400 | 203 |  | 3586
 |  | 2012-02-14 00:00:00 | 138 | 138 |  | 0 |  |  | 2012-03-14 00:00:00 | 400 |  |  | 3986
 |  | 2012-02-15 00:00:00 | 84 | 84 |  | 0 |  |  | 2012-03-15 00:00:00 | 400 |  |  | 4386
 |  | 2012-02-16 00:00:00 | 111 | 111 |  | 0 |  | 11 Total |  | 1600 | 203 |  | 15347
 | 7 Total |  | 496 | 496 |  | 0 |  | 12 | 2012-03-19 00:00:00 | 400 |  |  | 4786
 | 8 | 2012-02-20 00:00:00 | 171 | 171 |  | 0 |  |  | 2012-03-20 00:00:00 | 400 |  |  | 5186
 |  | 2012-02-21 00:00:00 | 176 | 176 |  | 0 |  |  | 2012-03-21 00:00:00 | 400 |  |  | 5586
 |  | 2012-02-22 00:00:00 | 400 | 40 |  | 360 |  |  | 2012-03-22 00:00:00 | 400 | 50 |  | 5936
 |  | 2012-02-23 00:00:00 | 400 | 418 |  | 342 |  | 12 Total |  | 1600 | 50 |  | 21494
 | 8 Total |  | 1147 | 805 |  | 702 |  | 13 | 2012-03-26 00:00:00 | 400 | 60 |  | 6276
 | 9 | 2012-02-27 00:00:00 | 400 | 210 |  | 532 |  |  | 2012-03-27 00:00:00 | 400 |  |  | 6676
 |  | 2012-02-28 00:00:00 | 400 | 111 |  | 821 |  |  | 2012-03-28 00:00:00 | 400 |  |  | 7076
 |  | 2012-02-29 00:00:00 | 400 | 90 |  | 1131 |  |  | 2012-03-29 00:00:00 | 400 |  |  | 7476
 | 9 Total |  | 1200 | 411 |  | 2484 |  | 13 Total |  | 1600 | 60 |  | 27504
 | Grand Total |  | 3934 | 2803 |  | 3186 |  | Grand Total |  | 6800 | 455 |  | 75395
Spreadsheet: 845975d1697270345-index-of-non-empty-cells-match-input-with-pool-of-texts-or-word-bank-excelforum3-updated
Sheet: CompaniesList

Company List | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
ALYUSR INDUSTRIAL CONTRACTING CO. | AYTB | AYTB | AYTB
Binzagr (BFIM) | BINZAGR | BFIM | BINZAGR | Binzagr (BFIM)
Eram Contracting Est. | ERAM | ERAM | Eram Engineering | ERAM Engr.
JADARRAH | JADARAH | [NAME] | JADDARAH | [NAME]
JAL Human Resources Company (JHR) | JAL | JAL | JAL - TA | JAL HR | JAL
Massadr Human Resource Services Company | MASSADR | MASSDR HR | MASSADR
Plantech | Plant  tech | Plant tech | PLANTECH | Planttech | PLANT-TECH | Planttech | Planttech (Hydrojetting) | PLANT-TECH (Cleaning) | PLANT-TECH (IP-X093)
SGS Inspection Services Saudi Arabia Ltd. | SGS | SGS Inspection Services Saudi Arabia Ltd. | SGS Services
ARABIAN CONSOLIDATED INDUSTRIAL CLEANING CO. (TANDHEEF) | ACIC | ACIC
Arabian Pipeline & Services Co. Ltd (ANABEEB) | ANABEEB | Anabeeb | Anabeeb (V-7645 Chemical Cleaning)
HI TECH | (HITEC) | HITECH
Arabian Consolidated Trading Est. | ACT | ACT
LIMOSINA | LIMOSINA - (Contractors) | Limosena | Limousina