tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 783109d1654595171-tidying-up-array-formula-to-be-less-cumbersome-spotracers-base-stats-list
Sheet: Dashboard

 | Best SpotRacer |  |  |  | Brand Search |  |  |  |  |  |  |  |  | Top 5 Brands |  |  | Top 5 Quickest SpotRacers by Acceleration |  |  |  |  | Bottom 5 Slowest Accelerating SpotRacers
 | SpotRacer | Brand | Model |  | Matches | Kia | (Select or enter search term in grey box)
 | Acorna
 | Aldo |  |  |  | Search Results
 | Attarani |  |  |  | SpotRacer | Brand | Model | Acceleration | Speed (MPH) | Speed (KPH) | Handling (%) | Star Rating
 | Ballingu
 | Basetti
 | Bertone
 | Bjorn |  |  |  |  |  |  |  |  |  |  |  |  | Top 5 SpotRacer Counts |  |  | Top 5 Fastest SpotRacers by Top Speed |  |  |  |  | Top 5 Slowest Top Speed SpotRacers
 | Boaster
 | [NAME]
 | [NAME]
 | Bug
 | Buster
 | Butzi
 | Buzz
 | Cabrio |  |  |  |  |  |  |  |  |  |  |  |  | Total Number |  |  | Top 10 Contriubtors |  |  |  |  | Speed Conversion Calculator
 | Campon |  |  |  |  |  |  |  |  |  |  |  |  | Unique Spots |  |  |  |  |  |  |  | Enter Speed in [NAME]
 | Caprize |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MPH | KMH
 | Caravelle |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101
 | Cargean |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MPH | KMH
 | Cargon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 171
 | Carrier
 | Cashaan
 | Charm
 | Citano
 | Compace
 | Comvan
 | Conqueror
 | Constance
 | Cossack
 | Cubana
 | [NAME]
 | Darkstar
 | [NAME]
 | Diablo
 | [NAME]
 | Electrify
 | Ercole
 | Falcon
 | Famcan
 | Famtain
 | [NAME]
 | Fintail
 | Five00
 | Four Four
 | [NAME]
 | Garland
 | Gaston
 | [NAME]
 | Goddess
 | Griswold
 | [NAME]
 | Hatcher
 | Imperator
 | Jamba
 | Julietta
 | Kei
 | Kong
 | Le Car
 | Legal
 | Lodger
 | Lord
 | Louis
 | Magnetic
 | Manowar
 | Masaka
 | Michelle
 | Miludan
 | Mosquit
 | Muscal
 | Neale
 | Norma
 | Octane
 | Osawa
 | Over Land
 | Phantom
 | Phenix
 | Ponta
 | Pontoon
 | Powers
 | [NAME]
 | Prince
 | Princess
 | Promenade
 | Proton
 | Purpose
 | Quatrelle
 | Quebec
 | Queen
 | Rallye
 | [NAME]
 | Sailor
 | [NAME]
 | [NAME]
 | Sensei
 | Serpent
 | Shogun
 | Silver
 | Spider
 | Steed
 | Sterling
 | Stingar
 | Super Eight
 | Supreme
 | Swifty
 | Teddy
 | Terrain
 | Tomahawk
 | Trabbi
 | Trendier
 | Trino
 | Truckan
 | Venom
 | Voltage
 | Wagance
 | Walter
 | Wantace
 | Westy
 | [NAME]
Spreadsheet: 585a9116-95b7-4df5-84dd-4d35ebba82ff
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40867996 | 2014-04-06 13:23:12 | ALLIES | 1 | 7 | 6 | 580159 | Devious | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40868265 | 2014-04-06 13:44:20 | AXIS | 1 | 7 | 3 | 580159 | Devious | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40918576 | 2014-04-09 21:15:46 | AXIS | 0 | 3 | 6 | 243582 | Vercingetorix1302 | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
40918808 | 2014-04-09 21:37:23 | ALLIES | 1 | 6 | 4 | 243582 | Vercingetorix1302 | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
Spreadsheet: 95b49dee-0fd3-4b01-beb1-2699b4a1c69d
Sheet: Sheet1

Unnamed: 0 | GOVERNOR - REPUBLICAN | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
2002-09-10 00:00:00
Belknap County | Benson, r | Haas, r | Humphrey, r | Keough, r | Kingsbury, r | Kroepel, r | [NAME], d | Hollingworth, d | [NAME]
Alton | 412 | 3 | 280 | 269 | 1 | 2 | 0 | 1 | 1
Barnstead | 220 | 4 | 188 | 187 | 3 | 5 | 0 | 0 | 0
Belmont | 362 | 3 | 202 | 230 | 5 | 4 | 3 | 2 | 2
Center Harbor | 99 | 0 | 69 | 104 | 0 | 0 | 0 | 0 | 1
Gilford | 718 | 3 | 240 | 433 | 7 | 3 | 0 | 0 | 0
Gilmanton | 215 | 4 | 149 | 176 | 4 | 0 | 1 | 0 | 0
[NAME] | 290 | 3 | 100 | 197 | 4 | 3 | 2 | 1 | 2
[NAME] | 155 | 2 | 96 | 96 | 3 | 2 | 0 | 0 | 0
[NAME] 3 | 162 | 1 | 82 | 118 | 2 | 2 | 1 | 1 | 1
[NAME] | 151 | 1 | 90 | 79 | 1 | 1 | 0 | 0 | 0
[NAME] | 92 | 2 | 75 | 53 | 2 | 1 | 0 | 0 | 2
[NAME] 6 | 181 | 0 | 96 | 93 | 1 | 0 | 1 | 0 | 0
Meredith | 467 | 5 | 227 | 473 | 5 | 3 | 1 | 1 | 1
New Hampton | 126 | 3 | 106 | 96 | 0 | 4 | 1 | 0 | 0
Sanbornton | 178 | 1 | 131 | 145 | 2 | 2 | 0 | 0 | 1
[NAME] | 161 | 2 | 110 | 122 | 4 | 1 | 0 | 0 | 0
TOTALS | 3989 | 37 | 2241 | 2871 | 44 | 33 | 10 | 6 | 11
 | GOVERNOR - REPUBLICAN
2002-09-10 00:00:00
Carroll County | Benson, r | Haas, r | Humphrey, r | Keough, r | Kingsbury, r | Kroepel, r | [NAME], d | Hollingworth, d | [NAME]
Albany | 40 | 0 | 12 | 40 | 1 | 0 | 0 | 0 | 0
[NAME] | 211 | 3 | 39 | 313 | 0 | 1 | 0 | 1 | 2
[NAME] | 74 | 0 | 49 | 42 | 4 | 0 | 0 | 0 | 0
Chatham | 25 | 0 | 11 | 10 | 0 | 1 | 0 | 0 | 0
Conway | 467 | 3 | 154 | 586 | 5 | 3 | 0 | 0 | 1
Eaton | 23 | 0 | 18 | 29 | 0 | 0 | 1 | 0 | 0
[NAME] | 94 | 1 | 43 | 57 | 3 | 1 | 0 | 0 | 0
Freedom | 150 | 1 | 48 | 146 | 3 | 2 | 0 | 0 | 0
Hale's Location | 45 | 0 | 5 | 18 | 0 | 0 | 0 | 0 | 0
Hart's Location | 3 | 0 | 3 | 6 | 0 | 0 | 0 | 0 | 0
[NAME] | 118 | 0 | 32 | 130 | 1 | 1 | 0 | 0 | 1
[NAME] | 143 | 2 | 74 | 168 | 1 | 1 | 1 | 1 | 0
Moultonborough | 402 | 3 | 214 | 635 | 3 | 3 | 2 | 0 | 0
Ossipee | 346 | 2 | 127 | 236 | 3 | 6 | 0 | 0 | 0
Sandwich | 78 | 7 | 114 | 95 | 0 | 0 | 0 | 0 | 0
Tamworth | 199 | 5 | 81 | 181 | 4 | 0 | 0 | 0 | 0
Tuftonboro | 248 | 6 | 120 | 309 | 0 | 1 | 0 | 0 | 1
Wakefield | 341 | 3 | 167 | 219 | 4 | 2 | 1 | 0 | 0
Wolfeboro | 708 | 10 | 312 | 619 | 6 | 6 | 0 | 0 | 0
TOTALS | 3715 | 46 | 1623 | 3839 | 38 | 28 | 5 | 2 | 5
Spreadsheet: 116124d1311613624-find-a-number-in-column-a-matching-column-b-and-move-in-c-matching-column-b-tigeravatar-example-for-judeh
Sheet: Sheet1

HeaderA | HeaderB | HeaderC |  | [NAME]
11 | 99 | 864 |  | 212
14 | 96 | 294 |  | 758
15 | 95 | 567 |  | 160
21 | 94 | 365 |  | 385
24 | 90 | 878 |  | 178
25 | 87 | 945 |  | 771
27 | 86 | 177 |  | 138
30 | 84 | 788 |  | 731
33 | 83 | 332 |  | 390
35 | 77 | 676 |  | 583
37 | 75 | 889 |  | 749
42 | 73 | 370 |  | 544
43 | 72 | 842 |  | 248
48 | 61 | 988 |  | 360
56 | 57 | 865 |  | 928
57 | 56 | 928 |  | 865
61 | 48 | 360 |  | 988
72 | 43 | 248 |  | 842
73 | 42 | 544 |  | 370
75 | 37 | 749 |  | 889
77 | 35 | 583 |  | 676
83 | 33 | 390 |  | 332
84 | 30 | 731 |  | 788
86 | 27 | 138 |  | 177
87 | 25 | 771 |  | 945
90 | 24 | 178 |  | 878
94 | 21 | 385 |  | 365
95 | 15 | 160 |  | 567
96 | 14 | 758 |  | 294
99 | 11 | 212 |  | 864
Spreadsheet: 59618d1260212052-grand-totals-in-pivot-chart-2007-grand-totals-in-pivot-chart
Sheet: Sheet1

owner | status | closed
tom | cancelled | 2009
bill | cancelled | 2009
tom | cancelled | 2009
tom | cancelled | 2008
tom | cancelled | 2008
bill | cancelled | 2008
bill | cancelled | 2008
tom | cancelled | 2009
Count of status | Column Labels
Row Labels | 2008 | 2009 | Grand Total
bill | 2 | 1 | 3
tom | 2 | 3 | 5
Grand Total | 4 | 4 | 8
Spreadsheet: cc776697-f7a1-4634-8b44-3080dd8cb799
Sheet: Table 8.3

8.3 Unemployment rates
 |  |  |  |  |  | Months (a)
 | Annual average (a) (b) |  |  |  |  | 2013
Country | 2010 | 2011 | 2012 | 2013 |  | Sep | Oct | Nov | Dec
Australia | 5.23 | 5.09 | 5.23 | 5.65 |  | 5.68 | 5.76 | 5.77 | 5.850000000000001
Canada | 8 | 7.45 | 7.24 | 7.05 |  | 6.9 | 6.9 | 6.9 | 7.2
France | 9.72 | 9.61 | 10.24 | 10.81 |  | 10.9 | 10.8 | 10.8 | 10.8
Germany | 7.08 | 5.95 | 5.48 | 5.32 |  | 5.2 | 5.2 | 5.100000000000001 | 5.100000000000001
Italy | 8.43 | 8.38 | 10.7 | 12.24 |  | 12.5 | 12.5 | 12.8 | 12.7
Japan | 5.05 | 4.58 | 4.350000000000001 |  |  | 4 | 4 | 4
New Zealand (c) | 6.53 | 6.53 | 6.9
United Kingdom | 7.78 | 8.03 | 7.890000000000001 |  |  | 7.3 | 7.2
United States | 9.620000000000001 | 8.950000000000001 | 8.07 | 7.38 |  | 7.2 | 7.2 | 7 | 6.7
OECD average | 8.32 | 7.95 | 7.96 |  |  | 7.850000000000001 | 7.83 | 7.74
G7 average | 8.19 | 7.68 | 7.41 |  |  | 7.06 | 7.05 | 6.96
Euro-zone average | 10.15 | 10.13 | 11.35 | 12.06 |  | 12.1 | 12 | 12 | 12
(a) Unemployment as a percentage of labour force.
(b) Years shown are calendar years.
(c) Data only available quarterly. Relevant data not yet available.
(d) Monthly data seasonally adjusted
Note: Unemployment rates shown above have been adjusted as necessary by the OECD
to conform to international definitions and to ensure consistency over time. |  |  |  |  |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  |  |  |  |  | Early March 2014
Source: Datastream
Spreadsheet: 600313d1543597989-sum-columns-until-target-value-met-and-report-header-date-sum-and-report_date
Sheet: Sheet1

 | 2018-11-30 00:00:00 | 2018-12-07 00:00:00 | 2018-12-14 00:00:00 | 2018-12-21 00:00:00 | 2018-12-28 00:00:00 | 2019-01-04 00:00:00 | 2019-01-11 00:00:00 | 2019-01-18 00:00:00 | 2019-01-25 00:00:00 | 2019-02-01 00:00:00 | 2019-02-08 00:00:00 | 2019-02-15 00:00:00 | 2019-02-22 00:00:00 | 2019-03-01 00:00:00
[NAME] | 1 | 1 | 7 | 2 | 1 | 1 | 7 | 1 | 7 | 2 | 1 | 1 | 2 | 1
[NAME] | 5 | 5 | 3 | 5 | 5 | 5 | 3 | 5 | 3 | 5 | 5 | 5 | 5 | 5
[NAME] | 4 | 5 | 1 | 2 | 4 | 5 | 1 | 5 | 1 | 2 | 4 | 5 | 2 | 4
[NAME] | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
[NAME] | 9 | 4 | 2 | 9 | 9 | 4 | 2 | 4 | 2 | 9 | 9 | 4 | 9 | 9
[NAME] | 8 | 9 | 8 | 8 | 8 | 9 | 8 | 9 | 8 | 8 | 8 | 9 | 8 | 8
[NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 5 | 5 | 2 | 5 | 5 | 5 | 2 | 5 | 2 | 5 | 5 | 5 | 5 | 5
[NAME] | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
 |  |  |  | target value for [NAME]: | 40 |  | return value should be 28-Dec-18
Spreadsheet: 122410d1316787243-rounding-hst-calculation
Sheet: Sheet1

115 |  |  |  |  |  |  | Cedar Springs | Professional Fees
Gross Amount | Taxable Amount | QB Expense | FED Amount | NS Amount | Check Value | Difference | Vendor | QuickBooks Expense Account
100.05
100.06
100.07
100.08
100.09
100.1
100.11
100.12
100.13
100.14
100.15
100.16
100.17
100.18
100.19
100.2
Alternate
 | Taxable Amount | QB Expense | FED Amount | NS Amount | Gross Amount
 | 87
Spreadsheet: 829758d1684425122-need-to-add-cells-j9-j16-for-all-icoy-working-capital-inside-ifna-formula-feb23-trial-balances-lse-test
Sheet: 211 N Harbor Bank Rec

 | Bank Name
 | Account Number
 | Month Ending
 | Company Name
 | Account Name
 | Trial Balance Account
 | Opening Balance Per Trial Balance - February 2023
 | Tribune Publishing Company LLC aka Chicago Tribune Company LLC | 2023-02-17 00:00:00 | 1613534 | -35000
 | [NAME] | 2023-02-16 00:00:00 | 1613536 | -6047.5
 | Near North National Title LLC | 2023-02-16 00:00:00 | 1613537 | -241
 | Tribune Publishing Company LLC aka Chicago Tribune Company LLC | 2023-02-23 00:00:00 | 1616283 | -35000
 | Community Management Systems LLC | 2023-02-28 00:00:00 | 1617282 | -846.01
 | Corporate Concepts Inc | 2023-02-28 00:00:00 | 1617283 | -139297.58
 | Evolution Ventures LLC | 2023-02-28 00:00:00 | 1617284 | -250
 | City of Chicago, Dept of Revenue | 2023-02-28 00:00:00 | 1617395 | -135560.22
 | Interior Architects Inc dba IA Interior Architects | 2023-02-28 00:00:00 | 1617396 | -3142.5
 | Near North National Title LLC | 2023-02-28 00:00:00 | 1617397 | -289
 | Draw # 27 |  |  | 164559.05
 | [NAME] Publishing |  |  | 35000
 | ComEd |  |  | 18644.65
 | Closing Trial Balance - February 2023 |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 | Known Reconciling Items - GL
 | Total
 | Balance Per Bank: |  |  | 1041774.49
 | Difference
 | Known Reconciling Items - Bank (Unpresented Checks)
 | Near North National Title LLC | 2023-02-16 00:00:00 | 1613537 | 241
 | Tribune Publishing Company LLC aka Chicago Tribune Company LLC | 2023-02-23 00:00:00 | 1616283 | 35000
 | City of Chicago, Dept of Revenue | 2023-02-28 00:00:00 | 1617395 | 135560.22
 | Interior Architects Inc dba IA Interior Architects | 2023-02-28 00:00:00 | 1617396 | 3142.5
 | Near North National Title LLC | 2023-02-28 00:00:00 | 1617397 | 289
 | Total
 | Unknown Reconciling Difference
Spreadsheet: 725294d1616606071-else-function-on-each-scenario-sample-2
Sheet: Source

Section | Name | Group | Physics | Chem | Bio | Maths
A | [NAME] | 33225 | 53 | 49 | 35 | 29
A | [NAME] | Group 1 | 44 | 55 | 32 | 45
A | [NAME] | Group 2 | 34 | 55 | 33 | 45
B | Maria | 5567 | 33 | 45 | 66 | 23
B | Maria | 3455 | 34 | 55 | 33 | 45
C | [NAME] | Group 1 | 33 | 45 | 66 | 23
C | [NAME] | Group 2 | 100 | 77 | 88 | 99
Spreadsheet: 797583d1663960738-ifs-to-return-dynamic-spill-range-ifs-to-return-dynamic-array
Sheet: Sheet1

Fiscal year/period | Cost Element | Cost Category | Cost Category of Interest |  | Desired Result (in a dynamic spill range)
JAN 2022 | 608500 | Material |  |  | Exclude
JAN 2022 | 608500 | Material | Material |  | Exclude
JAN 2022 | 608500 | Material | Material |  | Exclude
JAN 2022 | 610000 | Contractor | Contractor |  | Contractor
JAN 2022 | 630100 | Personnel Costs | Personnel Costs |  | Personnel Costs
MAR 2022 | 91002 | Personnel Costs | Personnel Costs |  | Exclude - Cost Category of Interest
MAR 2022 | 93000 | Contractor | Contractor |  | Exclude - Cost Category of Interest
MAR 2022 | 94000 | Personnel Costs | Personnel Costs |  | Exclude - Cost Category of Interest
MAR 2022 | 94000 | Personnel Costs | Personnel Costs |  | Exclude - Cost Category of Interest
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Lady J

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2016-04-01 00:00:00 | Sorry Im a bit confused with this one!
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2018-05-02 00:00:00 |  |  |  | DATE PAID | Reminder letter sent | NEXT FEE DUE | DATE PAID | NEXT FEE DUE | DATE PAID | NEXT FEE DUE | DATE PAID | NEXT FEE DUE | DATE PAID | NEXT FEE DUE
 |  |  |  | 10 MAY 14 £200 - 6 MTHS |  | 2014-11-24 00:00:00 | 1 may 15 £100 | £100 paid 21/8/15 | 26/10 £100 paid - until 24 Aug 15 | 25 January 16 - due | paid 24/1/16 £100 | due April end 16 | £100 rec 30 July 16 | £100 rec 26/1/17
Spreadsheet: 870265d1716809419-project-resource-planner-lookup-and-count-sum-formulas-project-resource-plan
Sheet: Summary

 |  | ALLOCATIONS
 |  |  | 2024-01-23 00:00:00 | 2024-02-23 00:00:00 | 2024-03-23 00:00:00 | 2024-04-23 00:00:00 | 2024-05-23 00:00:00 | 2024-06-23 00:00:00 | 2024-07-23 00:00:00 | 2024-08-23 00:00:00 | 2024-09-23 00:00:00 | 2024-10-23 00:00:00 | 2024-11-23 00:00:00 | 2024-12-23 00:00:00
 |  | Project A
 |  | Project B
 |  | Project C
 |  | Project D
 |  | Project E
 |  | Project F
 |  | Project G
 |  | Project H
 |  | NUMBER OF PEOPLE
 |  |  | 2024-01-23 00:00:00 | 2024-02-23 00:00:00 | 2024-03-23 00:00:00 | 2024-04-23 00:00:00 | 2024-05-23 00:00:00 | 2024-06-23 00:00:00 | 2024-07-23 00:00:00 | 2024-08-23 00:00:00 | 2024-09-23 00:00:00 | 2024-10-23 00:00:00 | 2024-11-23 00:00:00 | 2024-12-23 00:00:00
 |  | Project A | EQUALS THE NUMBER OF PEOPLE WHO ARE ALLOCATED TO PROJECT A e.g. TOTAL 5 people | etc.
 |  | Project B | EQUALS THE NUMBER OF PEOPLE WHO ARE ALLOCATED TO PROJECT B
 |  | Project C | etc.
 |  | Project D
 |  | Project E
 |  | Project F
 |  | Project G
 |  | Project H
Spreadsheet: michelle_lokay__26569__imbalsumm0012
Sheet: summary

Index is high - payback should be done on Dollar Valued payables
- payback should be done on Volumetric receivable
- payback should not be done on Dollar valued receivables
- payback should not be done on Volumetric payables
Positive = due [NAME]
Negative = due operator
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments |  |  |  |  |  |  |  | index
El Paso |  |  |  | Volumetric | [NAME] |  |  |  |  |  |  |  |  | SJ
PG&E |  |  |  | Volumetric | [NAME] |  |  |  |  |  |  |  |  | AVG
NGPL |  |  |  | Volumetric | [NAME]
PNM |  |  |  | Dollar Valued | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | This balance is cashed out every month.
Duke |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
NNG |  |  |  | Dollar Valued | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
SoCal |  |  |  | Volumetric | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
PG&E TX |  |  |  | Dollar Valued | [NAME] | This balance is cashed out every month
Lonestar |  |  |  | Volumetric | [NAME]
Receivable imbalances
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments
Northwest |  |  |  | Volumetric | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
Pan-Alberta-shipper |  |  | 2000-12-14 00:00:00 | Dollar Valued | [NAME]
[NAME] |  |  |  | Volumetric | Hernandez
Continental |  |  |  | Dollar Valued | [NAME]
CIG |  |  |  | Dollar Valued | [NAME]
Red Cedar |  |  |  | Dollar Valued | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 615aa2a2-4692-47aa-923c-fe2e48a014c1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Not Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2014
 |  | Data Extracted on: October 25, 2014 (4:09 pm)
Period | Value
Q1-2003 | X
Q2-2003 | X
Q3-2003 | X
Q4-2003 | 237399
Q1-2004 | 223675
Q2-2004 | 233241
Q3-2004 | 232983
Q4-2004 | 246201
Q1-2005 | 236033
Q2-2005 | 244136
Q3-2005 | 244711
Q4-2005 | 255856
Q1-2006 | 245182
Q2-2006 | 254735
Q3-2006 | 255745
Q4-2006 | 271401
Q1-2007 | 257973
Q2-2007 | 265739
Q3-2007 | 267325
Q4-2007 | 281304
Q1-2008 | 270223
Q2-2008 | 277650
Q3-2008 | 277603
Q4-2008 | 282873
Q1-2009 | 261921
Q2-2009 | 266862
Q3-2009 | 265511
Q4-2009 | 280665
Q1-2010 | 267597
Q2-2010 | 274785
Q3-2010 | 276049
Q4-2010 | 291794
Q1-2011 | 277416
Q2-2011 | 289110
Q3-2011 | 288779
Q4-2011 | 305253
Q1-2012 | 291952
Q2-2012 | 300081
Q3-2012 | 298950
Q4-2012 | 322308
Q1-2013 | 306040
Q2-2013 | 313234
Q3-2013 | 314646
Q4-2013 | 340055
Q1-2014 | 324502
Q2-2014 | 330908
Q3-2014 | X
Q4-2014 | X
Spreadsheet: 92370d1291933622-minimum-based-upon-level-twc-tax-rate-calculator-for-chargebacks-2010
Sheet: Sheet1

 | Houston | Texas | Dallas
Chargebacks |  | 12489.27 | 58964.24
Taxes Wages | 557612.46 | 452722.54 | 3316889.68
[NAME] |  |  | 0.0178
Replenishment Ratio | 1.28 | 1.28 | 1.28
General Tax Rate
Unemployment Rate | 0.0146 | 0.0072 | 0.0063
E, T & I Assessment | 0.001 | 0.001 | 0.001
Replenishment Rate | 0.0056 | 0.0056 | 0.0056
Effective Tax Rate
Paydown in $ | 398 | 111 | 1956 | **payment modifier
New General Tax Rate
New Effective Rate
Taxes @ Effective Rate
Taxes @ Pay down%
 |  |  |  | Total
Savings in $
Spreadsheet: 669991d1585693107-count-specific-words-in-a-range-and-return-total-count-from-another-column-count-question-sum-of-search-word-then-value-col
Sheet: Sheet1

Subject | # of calls |  |  | Word | Total # of calls
Additional driver | 10 |  |  | Additional |  | should bring back - 15
Additional vehicle | 5 |  |  | Billing |  | should bring back - 120
Billing - payments | 30
Billing - address | 40
Billing - questions | 50
Spreadsheet: 34540d1231850267-formula-that-counts-formula-that-counts
Sheet: Sheet1

BET NO. | BANK | STAKE % | STAKE £ | ODDS | TOTAL AFTER BET | WIN? YES NO | IF BET WON | NEW TOTAL |  | ROI | DATE OF BET |  | days since started
1 |  | 0.2 |  | 1.5 |  | y |  |  |  |  | 2008-12-28 00:00:00 | horse racing
2 |  | 0.1 |  | 1.67 |  | N |  |  |  |  | 2009-01-02 00:00:00 | darts
3 |  | 0.2 |  | 1.9584 |  | Y |  |  |  |  | 2009-01-03 00:00:00 | football
4 |  | 0.12 |  | 1.9375 |  | y |  |  |  |  | 2009-01-04 00:00:00 | horse racing
5 |  | 0.08 |  | 1.56 |  | y |  |  |  |  | 2009-01-05 00:00:00 | darts
6 |  | 0.03 |  | 1.69 |  | y |  |  |  |  | 2009-01-06 00:00:00 | football
7 |  | 0.11 |  | 1.61 |  | y |  |  |  |  | 2009-01-07 00:00:00 | horse racing
8 |  | 0.06 |  | 2.2 |  | n |  |  |  |  | 2009-01-08 00:00:00 | darts
9 |  | 0.14 |  | 1.7 |  | y |  |  |  |  | 2009-01-09 00:00:00 | football
10 |  | 0.11 |  | 1.62 |  | y |  |  |  |  | 2009-01-10 00:00:00 | horse racing
11 |  | 0.12 |  | 1.88 |  | y |  |  |  |  | 2009-01-11 00:00:00 | darts
12
13
14
15
16
17
18
19
20
21
22
23
24
Spreadsheet: 820863d1678312100-replace-maiden-name-with-married-name-aka
Sheet: Sheet1

Name |  | Sales |  |  |  | Reference List: |  | Maiden Name | Married Name
[NAME] |  | 2000 |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  | 1500 |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  | 900
[NAME] |  | 1200
[NAME] |  | 3500
[NAME] |  | 1400
[NAME] |  | 1000
I would like excel to use reference list to either replace maiden names with married name outright:
Name |  | Sales
[NAME] |  | 2000
[NAME] |  | 1500
[NAME] |  | 900
[NAME] |  | 1200
[NAME] |  | 3500
[NAME] |  | 1400
[NAME] |  | 1000
or I could add a column for married name which excel would automatically fill:
Name | Married Name | Sales
[NAME] | [NAME] | 2000
[NAME] |  | 1500
[NAME] |  | 900
[NAME] |  | 1200
[NAME] |  | 3500
[NAME] | [NAME] | 1400
[NAME] |  | 1000
Spreadsheet: 771697d1646799657-help-with-vlookup-function-grid-setup
Sheet: Sheet1

Item # | Item # | √ | Item Name | Item Price |  | Item # | Item Name | Item Price | Packaging
[NAME] |  |  |  |  |  |  |  |  | 24/40 Ct. Box
153275 |  |  |  |  |  |  |  |  | 24/20 Ct. Box
201145 |  |  |  |  |  |  |  |  | 32/6 Ct. Display
201234 |  |  |  |  |  |  |  |  | Small Pack
251141 |  |  |  |  |  |  |  |  | 10 Pack
251180 |  |  |  |  |  |  |  |  | 32/3 Ct. Display
251184 |  |  |  |  |  |  |  |  | 24/40 Ct. Box
251187 |  |  |  |  |  |  |  |  | 24/20 Ct. Box
251270 |  |  |  |  |  |  |  |  | 24/50 Ct. Box
271147 |  |  |  |  |  |  |  |  | 24/50 Ct. Box
271159 |  |  |  |  |  |  |  |  | 3 Box Display
271182 |  |  |  |  |  |  |  |  | 24/32 Ct. Box
271184 |  |  |  |  |  |  |  |  | 24/32 Ct. Box
271208 |  |  |  |  |  |  |  |  | 24/50 Ct. Box
301460 |  |  |  |  |  |  |  |  | 24/32 Ct. Box
301461 |  |  |  |  |  |  |  |  | 24/50 Ct. Box
301490 |  |  |  |  |  |  |  |  | 24/24 Ct. Box
301491 |  |  |  |  |  |  |  |  | 24/50 Ct. Box
301500 |  |  |  |  |  |  |  |  | 25/50 Ct. Box
301502 |  |  |  |  |  |  |  |  | 24/32 Ct. Box
301503 |  |  |  |  |  |  |  |  | 24/32 Ct. Box
301504 |  |  |  |  |  |  |  |  | 24/32 Ct. Box
301505 |  |  |  |  |  |  |  |  | 24/50 Ct. Box
301506 |  |  |  |  |  |  |  |  | 20 Ct. Box
351136 |  |  |  |  |  |  |  |  | 24 Ct. Box
351138 |  |  |  |  |  |  |  |  | 24/32 Ct. Box
351163 |  |  |  |  |  |  |  |  | 24/50 Ct. Box
PET3PPLUG |  |  |  |  |  |  |  |  | 20 Ct. Box
PETBALKDELT |  |  |  |  |  |  |  |  | 24 Ct. Box
PETCCHO |  |  |  |  |  |  |  |  | 32/6 Ct. Display
[NAME] |  |  |  |  |  |  |  |  | 25/50 Ct. Box
PETHYDEPARK |  |  |  |  |  |  |  |  | 32/3 Ct. Display
PETIRCASK
PETIRFLAKE
PETIRWHISK
PETKILLARNEY
PETOLDPUB
PETSHERHOLM
PETSUNSETBREEZE
PETUNIVFLAKE
STNMEL
STNVAN
T243001
Spreadsheet: 812351d1673088025-help-with-formulas-for-entilement-days-and-service-holiday-tracker-example
Sheet: info

 | Years |  | Departments
 | 2022
 | 2023 |  | Directors
 | 2024 |  | Sales
 | 2025 |  | Development
 | 2026 |  | Projects
 | 2027 |  | Production
 | 2028 |  | Operations
 | 2029 |  | Finance
 | 2030 |  | Design
 | 2031
 | 2032
 | 2033
Spreadsheet: 762260d1641476204-modify-existing-if-and-iferror-formula-permit-register-example-6-1-22
Sheet: BP

ABC Job Number | Address | Description | Client | Date of Confirmation  to Proceed | Permit  Number | BP Type | Job Notes
 | Address 23 | Description 23 | Client 23 | 2021-04-27 00:00:00 | 00:00:00 | BP | 00:00:00
ABC-21024 | Address 24 | Description 24 | Client 24 | 2021-04-28 00:00:00 | 00:00:00 | BP | 00:00:00
ABC-21025 | Address 25 | Description 25 | Client 25 | 2021-04-29 00:00:00 | 00:00:00 | BP | 00:00:00
Spreadsheet: 539580d1506259973-conditional-format-can-not-work-with-copy-paste-values-formula_b2500
Sheet: Sheet1

37943.99946499999 | 25102
131044.99571 | 37944
210834.995663 | 270665
25101.99976 | 131045
270665.03688 | 210835
246573 | 246573
316610.99008 | 108609
108609 | 316611
281985.994092 | 222028
290965.992504 | 281986
91663.99825399999 | 91664
222027.999344 | 286320
343584.989309 | 343585
286319.997692 | 618.56
595568
798364.9849009999
102607.998457
618
 | 618
 | 618.56
618.34