tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 162416d1339860988-export-adresses-in-excel-to-word-labels-wrap
Sheet: Sheet3

name 1 | address 1 | zip 1 | name 1 address 1 zip 1
name 2 | address 2 | zip 2 | name 2 address 2 zip 2
name 3 | address 3 | zip 3 | name 3 address 3 zip 3
name 4 | address 4 | [NAME] | name 4 address 4 zip 4
name 5 | address 5 | zip 5 | name 5 address 5 zip 5
name 6 | address 6 | zip 6 | name 6 address 6 zip 6
name 7 | address 7 | zip 7 | name 7 address 7 zip 7
name 8 | address 8 | zip 8 | name 8 address 8 zip 8
name 9 | address 9 | zip 9 | name 9 address 9 zip 9
name 10 | address 10 | zip 10 | name 10 address 10 zip 10
name 11 | address 11 | zip 11 | name 11 address 11 zip 11
name 12 | address 12 | zip 12 | name 12 address 12 zip 12
name 13 | address 13 | zip 13 | name 13 address 13 zip 13
Spreadsheet: 4ad1130a-cb66-4cae-bdcb-db4fd710f4fd
Sheet: Sheet1

City of Lansing Election Results:  General Election, November 7, 1989 | Unnamed: 1
Table of Contents
1……………………………………………………… | Important Notes
2……………………………………………………… | [NAME]
3…………………………………………..…………. | Lansing City Mayor
4…………………………………………..…………. | Lansing City Clerk
5…………………………………………...………… | Lansing City Coun. -- At Large
6…………………………………………...………… | Lansing City Coun. -- Ward 2
7…………………………………………..…………. | Lansing City Coun. -- Ward 4
8…………………………………………..…………. | Lansing Board of Ed.
9…………………………………………...………… | State Prop. A (Sales Tax 1)
10…………………………………………...………. | State Prop. B (Sales Tax 2)
Spreadsheet: 130566d1322463208-date-filtering-problem-troops-to-task-test
Sheet: Troop to Task

Troop to Task
RANK | NAME | MOS | STATUS | TASKING DATE | TASKING NUMBER | START DATE | END DATE | REMARKS |  | Updated By
HQ
 | [NAME] |  | Scheduled |  |  | 2011-12-06 00:00:00 | 2011-12-08 00:00:00 | leave
SUPPLY
 | [NAME] |  | Tenative |  |  | 2011-12-19 00:00:00 | 2011-12-28 00:00:00 | Storknesting
 | [NAME] |  | Scheduled |  |  | 2011-12-29 00:00:00 | 2012-01-10 00:00:00 | Paternity Leave
 | [NAME] |  | Tenative |  |  | 2011-11-01 00:00:00 | 2011-11-30 00:00:00
 |  |  | Tenative |  |  | 2011-12-06 00:00:00 | 2011-12-08 00:00:00
NST
 |  |  |  |  |  | 2011-11-29 00:00:00 | 2011-11-29 00:00:00
 |  |  |  |  |  | 2011-11-28 00:00:00 | 2011-11-29 00:00:00
 |  |  |  |  |  | 2011-11-01 00:00:00 | 2011-11-30 00:00:00
 |  |  |  |  |  | 2011-12-05 00:00:00 | 2011-12-05 00:00:00
 |  |  |  |  |  | 2011-11-29 00:00:00 | 2011-11-29 00:00:00
 |  |  |  |  |  | 2011-12-13 00:00:00 | 2012-01-10 00:00:00
 |  |  |  |  |  | 2011-12-08 00:00:00 | 2011-12-08 00:00:00
 |  |  |  |  |  | 2011-11-28 00:00:00 | 2011-12-02 00:00:00
 |  |  |  |  |  | 2011-11-01 00:00:00 | 2011-11-30 00:00:00
 |  |  |  |  |  | 2011-11-29 00:00:00 | 2011-11-29 00:00:00
 |  |  |  |  |  | 2011-12-22 00:00:00 | 2012-01-17 00:00:00
 |  |  |  |  |  | 2011-11-23 00:00:00 | 2011-12-16 00:00:00
 |  |  |  |  |  | 2011-11-30 00:00:00 | 2011-12-02 00:00:00
CSC
 |  |  |  |  |  | 2012-01-09 00:00:00 | 2012-01-13 00:00:00
 |  |  |  |  |  | 2011-12-09 00:00:00 | 2011-12-09 00:00:00
 |  |  |  |  |  | 2011-11-23 00:00:00 | 2011-12-16 00:00:00
 |  |  |  |  |  | 2012-02-01 00:00:00 | 2012-02-11 00:00:00
 |  |  |  |  |  | 2012-01-02 00:00:00 | 2012-04-02 00:00:00
 |  |  |  |  |  | 2011-11-23 00:00:00 | 2011-12-16 00:00:00
 |  |  |  |  |  | 2012-01-02 00:00:00 | 2012-01-28 00:00:00
 |  |  |  |  |  | 2011-11-23 00:00:00 | 2011-12-16 00:00:00
 |  |  |  |  |  | 2011-12-02 00:00:00 | 2011-12-02 00:00:00
 |  |  |  |  |  | 2011-12-15 00:00:00 | 2012-01-06 00:00:00
 |  |  |  |  |  | 2011-11-23 00:00:00 | 2011-12-16 00:00:00
HFRD
COMSEC
 |  |  |  |  |  | 2011-11-17 00:00:00 | 2011-11-30 00:00:00
TSSD
 |  |  |  |  |  | 2011-11-28 00:00:00 | 2011-12-02 00:00:00
 |  |  |  |  |  | 2011-11-30 00:00:00 | 2011-11-30 00:00:00
 |  |  |  |  |  | 2011-12-12 00:00:00 | 2012-01-03 00:00:00
 |  |  |  |  |  | 2011-11-30 00:00:00 | 2011-11-30 00:00:00
 |  |  |  |  |  | 2011-12-09 00:00:00 | 2012-01-03 00:00:00
 |  |  |  |  |  | 2011-12-07 00:00:00 | 2011-12-07 00:00:00
 |  |  |  |  |  | 2011-12-08 00:00:00 | 2011-12-09 00:00:00
 |  |  |  |  |  | 2011-11-30 00:00:00 | 2011-11-30 00:00:00
 |  |  |  |  |  | 2012-01-22 00:00:00 | 2012-02-20 00:00:00
 |  |  |  |  |  | 2011-11-28 00:00:00 | 2011-12-02 00:00:00
 |  |  |  |  |  | 2011-11-30 00:00:00 | 2011-11-30 00:00:00
 |  |  |  |  |  | 2011-12-05 00:00:00 | 2011-12-09 00:00:00
 |  |  |  |  |  | 2012-01-17 00:00:00 | 2012-02-08 00:00:00
 |  |  |  |  |  | 2011-12-01 00:00:00 | 2011-12-15 00:00:00
 |  |  |  | TOTAL SOLDIERS
Spreadsheet: b508100d-0623-43ec-be55-f73e2a61abef
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
260013 | 58157 | [NAME] | Molina | ESP | 10034 | 00:00:00 | 00:00:00 | 00:14:08 | 00:01:52 | 00:22:58 | 1 | 00:38:58
260013 | 72731 | Ricardo | Marin [NAME] | ESP | 10033 | 00:00:00 | 00:00:00 | 00:16:20 | 00:02:29 | 00:24:00 | 2 | 00:42:48
260013 | 55904 | Christian | Troger | AUT | 10139 | 00:00:00 | 00:00:00 | [NAME] | 00:02:30 | 00:25:27 | 3 | [NAME]
260013 | 7966 | [NAME] | Peiffer | FRA | 10035 | 00:00:00 | 00:00:00 | 00:17:28 | 00:01:45 | 00:26:16 | 4 | 00:45:28
260013 | 50818 | Francisco | [NAME] | BRA | 10036 | 00:00:00 | 00:00:00 | [NAME] | 00:02:05 | 00:35:23 | 5 | 00:54:34
Spreadsheet: 130993d1322680208-sum-two-sheets-with-vlookup-and-match-sample
Sheet: Sheet1

PART# | DESC | ORDER# | NOV | DEC | JAN | FEB | MAR | APR | MAY | [NAME] | JULY | AUG | SEPT | OCT
12345 | X | XX | 45 | 66 | 77 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 12
Spreadsheet: 141432d1329260068-creating-a-list-using-data-validation-can-i-create-a-subcategory-list-sonepar-technology-team-pos-and-invoices-2012
Sheet: PO & Invoice Details

SSIT Purchase Orders & Invoices
Managed by Technology Team - Hamilton, NJ
2012
IT ASSOCIATE TO FILL IN |  |  |  |  |  |  |  |  | AP ASSOCIATE TO FILL IN |  |  |  |  |  |  |  | OpCo | Cooper Electric | NorthEast Electric | Friedman Electric | World Electric | Capital Tristate | Crawford (CESCO) | [NAME]
Vendor | PO# | PO Total | Issued by | OpCo | Branch Location | Order Details | GL Acct | Pre-Paid Term | Invoice# | Inv Date | Payable # | Post Date |  |  |  |  | Brook | *NEW | *NEW | *NEW | *NEW | *NEW | *NEW | *NEW
 |  |  |  | Capital Tristate |  |  |  |  |  |  |  |  |  |  |  |  | Capital Tristate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cooper Electric
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawford (CESCO)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Essco
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friedman Electric
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hagemeyer USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Irby
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NorthEast Electric
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonepar USA (Corporate)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonepar USA ([NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonepar USA (Maitland)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Viking Electric
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | World Electric
Spreadsheet: 674731d1587998530-sum-data-based-on-a-gl-code-and-month-in-year-book1
Sheet: 2019

Code | Account | Group | Type | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | Total
200 | Sales 1 |  |  | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000
210 | Sales 2 |  |  | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000 | 40000
211 | Sales 3 |  |  | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000
212 | Sales 4 |  |  | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
213 | Sales 5 |  |  | 13000 | 13000 | 13000 | 13000 | 13000 | 13000 | 13000 | 13000 | 13000 | 13000 | 13000 | 13000
214 | Sales 6 |  |  | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
215 | Sales 7 |  |  | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
220 | Sales 8 |  |  | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000 | 14000
Spreadsheet: 471236d1468928961-show-text-instead-of-value-in-pivot-table-example
Sheet: Output Needed

User ID | Name of Department | Software | Version
AABHISH | ITM/SS | Corporate WMI Provider | 2.3.1.0
aadarsh | RD I/CEE | Corporate WMI Provider | 2.3.1.0
AADC_s_PID0BEB | 7 | 7 | 7
 | NULL | Corporate WMI Provider | 2.3.1.0
 | NULL | Corporate WMI Provider | 2.3.1.0
 | NULL | Corporate WMI Provider | 2.3.1.0
 | NULL | Corporate WMI Provider | 2.3.1.0
 | NULL | Corporate WMI Provider | 2.3.1.0
 | NULL | Corporate WMI Provider | 2.3.1.0
 | NULL | Corporate WMI Provider | 2.3.1.0
AANKSEN | NULL | Corporate WMI Provider | 2.3.1.0
Spreadsheet: 146117d1331905822-averaging-a-group-of-cell-with-special-conditions-treadmill_elliptical
Sheet: Treadmill_Equations

Date | Time | Speed | Distance | Time | Strides | Distance
2012-01-27 00:00:00 | 10 | 2.4 mph
2012-01-27 00:00:00 | 10 | 2.4 mph
2012-01-28 00:00:00 | 10 | 2.4 mph
2012-02-03 00:00:00 | 10 | 2.4 mph
2012-02-03 00:00:00 | 10 | 2.3 mph
2012-02-04 00:00:00 | 10 | 2.3 mph
2012-02-04 00:00:00 | 10 | 2.3 mph
2012-02-07 00:00:00 | 10 | 2.0 mph
2012-02-08 00:00:00 | 10 | 2.3 mph
2012-02-10 00:00:00 | 12 | 2.3 mph
2012-02-11 00:00:00 | 12 | 2.5 mph
2012-02-12 00:00:00 | 12 | 2.5 mph
2012-02-15 00:00:00 | 12 | 2.5 mph
2012-02-19 00:00:00 | 30 | 2.0 mph
2012-02-21 00:00:00 | 12 | 2.5 mph
2012-02-22 00:00:00 | 12 | 2.5 mph
2012-02-25 00:00:00 | 15 | 2.5 mph
2012-02-26 00:00:00 | 12 | 2.5 mph
2012-03-04 00:00:00 | 15 | 2.7 mph
2012-03-05 00:00:00 | 11.11 | 2.7 mph
2012-03-06 00:00:00 | 5 | 2.7 mph
2012-03-07 00:00:00 | 7 | 2.7 mph |  | 5 | 45
2012-03-07 00:00:00 | 3 | 3.0 mph |  | 5 | 45
2012-03-11 00:00:00 | 5 | 3.0 mph |  | 5 | 46
2012-03-16 00:00:00 |  |  |  | 5 | 45
Totals
 |  | Would like average of c1-c35 not counting empty cells in average count |  |  |  | Would like average of g1-g35 not counting empty cells in average count
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: daren_farmer__5354__CoastalAlbrecht
Sheet: Page 2 of 2

REQUESTOR: |  |  |  |  |  |  | CATS PROJECT:
DATE OF REQUEST: |  |  |  |  |  |  | COORDINATOR: | [NAME]
DUE DATE: |  |  |  |  |  |  | ASSIGNED TO:
METER/SYSTEM NO: |  |  |  |  |  |  | LATEST UPDATE:
 | PHYSICAL WELL CONNECT |  |  | Is this classified as a Project or Prospect? (CIRCLE ONE)
 | PROJECT |  | PROSPECT |  |  |  | ADDITIONAL REQUIREMENTS:
 | Operator Name: |  |  |  |  |  | [NAME]
 | Well Name: |  |  |  |  |  | Fac Agrmt Req'd
 | API #: |  |  |  |  |  | Purchase Cont Req'd
 |  |  |  |  |  |  | Transport Quote Req'd |  | 2000-06-29 16:48:44.410000
 | Work Order Title: |  |  |  |  |  | Transport Quote Rec'd
 | Field: |  |  |  |  |  | Facility Agreement Exec'd
 | County, State: |  |  |  |  |  | Economics Modelled
 | Abstract/Survey: |  |  |  |  |  | [NAME]:
 | MAP OR PLAT REQUEST (copy to trader, copy to [NAME]) |  |  |  |  | Req/Rec |  |  |  | SCALE:
 |  | WELL SPOT MAP |  |  |  |  |  |  |  | 1" = | 3000
 |  | PROPERTY PLAT/TOBIN (2) |  |  |  | 2000-06-20 16:52:49.410000 |  |  |  | 1" = | 3000
 |  | ALIGNMENT DRAWING (2) |  |  |  |  |  |  |  | 1" = | 3000
 |  | VALVE LOCATION MAP (2) |  |  |  |  |  |  |  | 1" = | 3000
 |  | USGS MAP (22x34) |  |  |  |  |  |  |  | 1" = | 3000
 | SHOW FACILITIES |  |  |  |  |  | SHOW CULTURE
 |  | HOUSTON PIPE LINE AND/OR LRC |  |  |  |  |  | ROADS
 |  | OTHER PIPELINES |  |  |  |  |  | WATER (RIVER & CREEKS)
 |  | TAPS & VALVES |  |  |  |  |  | ABSTRACTS
 |  |  |  |  |  |  |  | RAILROADS
 |  |  |  |  |  |  |  | CITIES
 | FACILITY PLANNING INFORMATION
 | ECONOMIC MODEL INFORMATION
 | GENERAL REQUEST AND OTHER SCOPING DATA
 | We request that a Field Meeting be arranged so that the location of the well, along with any potential topographic problems, can be confirmed; please note that
 | the wells appear to be situated near the terminus of a sales line.  If appropriate, we also request an estimate for the cost of a 6" tap, meter and riser on [NAME]'s
 | 10" Celanese Plant Line (4402) on the Blessing - Chocolate Bayou System 555.
 | 6/29/00 - Transport Rate Requested.
Spreadsheet: kay_mann__19215__bill of sale schedule 010301
Sheet: Sheet1

[NAME] of Sale - Schedule of Equipment
Draft as of 1/2/01
 |  |  | Guaranteed
Turbine (mfg/model) | Unit # | Serial # | Unit Delivery Date | Physical Location of Units (1/5/01) | Rights & Priveleges under contract dated | Contract Purchase Amount ($) | Contract terms (parties, date, rights)
GE LM6000 Enhanced SPRINT Dual-fuel Combustion Turbine Generator Set | 17 | 309604 | 2001-01-30 00:00:00 | GE Frabrication Yard (Houston. TX) | 2000-05-12 00:00:00 |  | See note 1 below
GE LM6000 Enhanced SPRINT Dual-fuel Combustion Turbine Generator Set | 18 | 309719 | 2001-01-30 00:00:00 | Turner Brother Storage Yard (Houston, TX) | 2000-05-12 00:00:00 |  | See note 2 below
ABB generator step-up transformer (13.8kV x 115kV/230kV) | LNL-9517-4 | N/A | 2000-12-01 00:00:00 | ABB Factory Storage Facility | 2000-07-14 00:00:00 |  | See note 3 below
 |  |  |  | 4350 [NAME].
 |  |  |  | St. Louis, Missouri 63120
 |  |  |  |  | Note 1 | Note 2 | Note 3
 |  |  |  |  | [insert contract terms below] | [insert contract terms below] | [insert contract terms below]
Spreadsheet: 869976d1716492324-solved-sumifs-formula-not-working-any-longer-excel-help
Sheet: Sheet1

 |  | EE Cost | ER Cost | Benefit
 |  | 50.18 | $- | Dental
 |  | 329.59 | 340 | Medical
 |  | 20.04 | $- | Vol Life
 |  | 50.18 | $- | Dental
 |  | 50.18 | $- | Dental
 |  | 329.59 | 340 | Medical
 |  | 25.05 | $- | Vol Life
 |  | 7.38 | $-
 |  | 2 | $-
 |  | 2 | $-
 |  | 2 | $-
 |  | 17.1 | $- | Vol Life
 |  | 3.42 | $-
 |  | 99.37 | $- | Dental
 |  | 81.36 | $- | Gap
 |  | 880.77 | 400 | Medical
 |  | 42.12 | $- | Aflac
 |  | 99.37 | $- | Dental
 |  | 81.36 | $- | Gap
 |  | 880.77 | 400 | Medical
 |  | 99.21 | $- | Aflac
 |  | 99.37 | $- | Dental
 |  | 37.86 | $- | Gap
 |  | 262.42 | 400 | Medical
 |  | 50.18 | $- | Dental
 |  | 264.59 | 340 | Medical
 |  | 50.18 | $- | Dental
 |  | 209.89 | 400 | Medical
 |  | 50.18 | $- | Dental
 |  | 209.89 | 400 | Medical
 |  | 37.86 | $- | Gap
 |  | 69.42 | $- | Aflac
 |  | 50.74 | $- | Aflac
 |  | 120.16
 |  | 30.29 | $- | Aflac
 |  | 99.37 | $- | Dental
 |  | 99.37 | $- | Dental
 |  | 37.86 | $- | Gap
 |  | 262.42 | 400 | Medical
 |  | 31.2 | $- | Aflac
 |  | 135.7 | $- | Vol Life
 |  | 25.05 | $- | Vol Life
 |  | 5.01 | $-
 |  | 59.8 | $- | Aflac
 |  | 50.18 | $- | Dental
 |  | 37.86 | $- | Gap
 |  | 209.89 | 400 | Medical
 |  | 120.9 | $- | Aflac
 |  | 50.4 | $- | Aflac
 |  | 18.45 | $- | Vol Life
 |  | 50.18 | $- | Dental
 |  | 27.17 |  | Aflac
 |  | 50.18 | $- | Dental
 |  | 50.18 | $- | Dental
 |  | 37.86 | $- | Gap
 |  | 209.89 | 400 | Medical
 |  | 56.4 | $- | Aflac
 |  | 44.07 | $- | Aflac
 |  | 100.47
 |  | 50.18 | $- | Dental
 |  | 103.38 | $- | Dental
 |  | 668.14 | 340 | Medical
 |  | 17.1 | $- | Vol Life
 |  | 50.18 | $- | Dental
 |  | 37.86 | $- | Gap
 |  | 262.42 | 400 | Medical
 |  | 40.71 | $- | Vol Life
 |  | 209.89 | 400 | Medical
 |  | 50.18 | $- | Dental
 |  | 220.08 | 340 | Medical
 |  | 50.18 | $- | Dental
 |  | 37.86 | $- | Gap
 |  | 264.59 | 340 | Medical
 |  | 11.4 | $- | Vol Life
 |  | 1.67 | $- | Vol Life
 |  | 2 | $- | Vol Life
 |  | 50.18 | $- | Dental
 |  | 37.57 | $- | Aflac
 |  | 50.18 | $- | Dental
 |  | 264.59 | 340 | Medical
 |  | 37.86 | $- | Gap
 |  | 262.42 | 400 | Medical
 |  | 50.18 | $- | Dental
 |  | 88.95 | $- | Vol Life
 |  | 17.79 | $- | Vol Life
 |  | 19.25 | $- | Vol Life
 |  | 7.38 | $- | Vol Life
 |  | 37.86 | $- | Gap
 |  | 836.16 | 340 | Medical
 |  | 99.37 | $- | Dental
 |  | 134.1 | $- | Vol Life
 |  | 26.82 | $- | Vol Life
 |  | 50.18 | $- | Dental
 |  | 220.08 | 340 | Medical
 |  | 37.86 | $- | Gap
 |  | 262.42 | 400 | Medical
 |  | 50.18 | $- | Dental
 |  | 88.95 | $- | Vol Life
 |  | 329.59 | 340 | Medical
 |  | 220.08 | 340 | Medical
 |  | 9.84 | $- | Vol Life
 |  | 31.46 | $- | Aflac
 |  | 668.14 | 340 | Medical
 |  | 50.18 | $- | Dental
 |  | 3.85 | $- | Vol Life
 |  | 50.18 | $- | Dental
 |  | 220.08 | 340 | Medical
 |  | 65.61 | $- | Vol Life
 |  | 65.61 | $- | Vol Life
 |  | 99.37 | $- | Dental
 |  | 50.18 | $- | Dental
 |  | 99.37 | $- | Dental
 |  | 1066.14 | 340 | Medical
 |  | 59.3 | $- | Vol Life
Spreadsheet: 96771d1296063180-count-base-on-the-day-of-the-week-copy-of-counting
Sheet: Sheet3

WEEK START | WEEK NUM | DAY | START | FINISH
2011-01-03 00:00:00 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
Spreadsheet: 763149d1642010083-xlookup-with-multiple-criteria-book1-2-
Sheet: Sheet1

 | Region Formula | Main WorkCtr |  |  |  | Return Array | [NAME]
 |  | C10332SK |  |  |  | CARLYLE | WN07AM02
 |  | C10332SK |  |  |  | NORTH BATTLEFORD | NB
 |  | C10332SK |  |  |  | [NAME] | PA
 |  | WN07AM02 |  |  |  | REGINA | RE
 |  | WN07AM02 |  |  |  | SASKATOON | SK
 |  | WN07AM02 |  |  |  | SWIFT CURRENT | SC
 |  | WN07AM02 |  |  |  | WEYBURN | WN
 |  | WN07AM02 |  |  |  | YORKTON | YN
 |  | WN07AM02
 |  | YN07AM01
 |  | YN07AM01
 |  | YN07AM01
 |  | YN07AM01
 |  | YN07AM01
 |  | YN07AM01
 |  | YN07AM01
 |  | YN07AM01
 |  | NB07AM01
 |  | NB07AM01
 |  | NB07AM01
 |  | NB07AM01
 |  | NB07AM01
 |  | NB07AM01
 |  | NB07AM01
 |  | NB07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | WN07AM01
 |  | [NAME]
 |  | 112233WN
 |  | WN07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
 |  | RE07AM01
Spreadsheet: 240752d1370420195-cell-format-is-not-changed-it-is-some-how-passive-sample-30-
Sheet: Sheet1

 |  | Paid Amt | [NAME] here
 |  | 2,000.00 |  | <------- these are numbers now ... you can then copy paste special values these values to any location you like.
 |  | 50,000.00
 |  | 275,650.00
 |  | 13,000.00
 |  | 55,000.00
 |  | 1,000.00
 |  | 59,875.00
 |  | 5,000.00
 |  | 35,000.00
 |  | 18,500.00
 |  | 20,000.00
 |  | 20,000.00
 |  | 23,550.00
 |  | 3,500.00
 |  | 6,000.00
 |  | 31,880.00
 |  | 15,900.00
 |  | 199,800.00
 |  | 50,000.00
 |  | 15,000.00
 |  | 95,000.00
 |  | 2,000.00
 |  | 56,470.00
 |  | 400,000.00
 |  | 43,200.00
 |  | 400,000.00
 |  | 35,880.00
 |  | 50,000.00
 |  | 162,900.00
 |  | 92,380.00
 |  | 150,300.00
 |  | 15,000.00
 |  | 2,000.00
 |  | 120,000.00
 |  | 11,960.00
 |  | 19,800.00
 |  | 102,900.00
 |  | 15,000.00
 |  | 74,000.00
 |  | 2,000.00
 |  | 50,000.00
 |  | 5,000.00
 |  | 5,200.00
 |  | 7,565.00
 |  | 115,500.00
 |  | 75,000.00
 |  | 365,800.00
 |  | 30,000.00
 |  | 4,500.00
 |  | 99,800.00
 |  | 26,550.00
 |  | 16,000.00
 |  | 50,000.00
 |  | 50,000.00
 |  | 50,000.00
 |  | 8,500.00
Spreadsheet: 373731d1422537413-working-out-when-amortisation-ends-amortisation
Sheet: Sheet1

Number of parts for Amortisation | Amortisation start month | April | May | June | July | August | September | October | November | December | January | February | March
58133 | May | 6982
Spreadsheet: 271984d1382123513-if-then-sales-specialist-weekly-tracking2
Sheet: KEY SHEET - DO NOT CHANGE

Associates | Stores | Location
[NAME] | Saks Fifth Avenue | Fifth Avenue
Associate #2 | Macy's | West Village
 | Other Store | Midtown
Store | (from list above)
Location | (from list above)
Week 1 | (if matches above store and location, then add all total hours from this week)
Week 2 | (if matches above store and location, then add all total hours from this week)
Week 3 | (if matches above store and location, then add all total hours from this week)
Week 4 | (if matches above store and location, then add all total hours from this week)
Total | Simple Total Hours
Next Store
Next Location
Week 1
Week 2
Week 3
Week 4
Total
Spreadsheet: 841309d1693496958-match-date-on-two-different-pages-and-paste-data-in-columns-copy-of-ef-file
Sheet: 12-9 Night

 | CR1 | Priority | Headcount | QI
1 | Alinity RV | 17 | 0.25 | Xavier
2 | Alinity RV | 16 | 0.25 | Dezree
3 | Alinity RV | 15 | 0.25 | Noemy
4 | Alinity RV | 14 | 0.25 | Dinah
5 | Alinity RV | 13 | 0.25
12 | [NAME] | 18 | 0.25
13 | [NAME] | 19 | 0.25
9 | Architect RV | 12 | 0.25
15 | [NAME] | 20 | 0.5
17 | Architect RV | 11 | 0.25
31 | Architect RV | 10 | 0.25
8 | Architect RV | 9 | 0.25
10 | Architect RV | 8 | 0.25
11 | [NAME] |  | 0.25
18 | Architect RV | 7 | 0.25
19 | Architect RV | 6 | 0.25
20 | [NAME] | 1 | 0.5
21 | Architect RV | 5 | 0.25
22 | Architect RV | 4 | 0.25
23 | Architect RV | 3 | 0.25
7 | Architect SC | 2 | 0.25
Total
 | CR2 | Priority
73 | 8ul | 4 | 0.25
74 | Side Cassette | 3 | 0.25
78 | PP1 | 2 | 0.25
79 | E/O Piston | 1
77 | PP4 | 6 | 0.25
87 | [NAME] | 5
53 | Architect RV | 7 | 0.2
61 | [NAME] | 11 | 0.5
66 | [NAME] | 10 | 0.5
83
84 | Ceph MB#1 | 8 | 0.25
86 | [NAME] | 9 | 0.25
62 | NP227 | 13 | 0.25
63 | NP104 | 14 | 0.25
67 | [NAME] | 15 | 0.25
88 | [NAME] | 12 | 0.25
106 |  |  | 0.25
107 |  |  | 0.25
108 |  |  | 0.25
109 |  |  | 0.25
Total
Grand Total
Spreadsheet: 479190d1473266309-count-number-of-cells-that-contain-numbers-based-on-another-column-example
Sheet: Sheet1

Company
 |  | € | €
 |  | 2015-11-01 00:00:00 | 2015-12-01 00:00:00
Staff A | WP
Staff A | WP
Staff A | IT
Staff A | WP
Staff A | DR
Staff A | WP
Staff A | WP
Staff A | WP
Staff A | WP
Staff A | D
Staff A | DR
Staff A | WP
Staff A | D
Staff A | WP
Staff A | WP
Staff A | WP
Staff A | WP
Staff A | DR
Staff A | D
Staff A | D
Staff A | WP
Staff A | D
Staff A | D
Staff A | D
Staff A | WP
Staff A | D
Staff A | WP
Staff A | WP
Staff A | D
Staff A | D
Staff A | S
Staff A | D
Staff A | MK
Staff A | WP
Staff A | D
Staff A | WP
Staff A | EC
Staff A | EC
Staff A | D
Staff A | D
Staff A | EC
Staff A | D
Staff A | D
Staff A | WP
Staff A | WP
Staff A | WP
Staff A | DR
Staff A | WP
Staff A | IT
Staff A | WP
Staff A | WP
Staff A | WP
Staff A | S
Staff A | D
Staff A | EC
Staff A | EC
Staff A | D
Staff A | WP
Staff A | S
Totals
Headcount | D
 | WP
 | EC
 | DR
 | S
 | F
 | IT
 | MK
 | A
Spreadsheet: 858208d1706950191-looking-for-formula-to-create-number-series-creating-number-series_sample
Sheet: Here

Numbering | 8 |  |  | Creating number series
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Spreadsheet: 37218d1235151244-combobox-based-on-date-vba-comboboxsos
Sheet: Sheet1

Month | Volume
2008-01-01 00:00:00 | 540.1348758569337
2008-02-01 00:00:00 | 710.613786041205
2008-03-01 00:00:00 | 877.063332589426
2008-04-01 00:00:00 | 157.8107217055866
2008-05-01 00:00:00 | 784.5906624354742
2008-06-01 00:00:00 | 709.8088487331573
2008-07-01 00:00:00 | 915.5628455432056
2008-08-01 00:00:00 | 226.0730744202331
2008-09-01 00:00:00 | 838.279091813761
2008-10-01 00:00:00 | 191.1931964449709
2008-11-01 00:00:00 | 300
2008-12-01 00:00:00 | 633.6937894319492
2009-01-01 00:00:00 | 19.84715006246418
2009-02-01 00:00:00 | 659.5108051326042
2009-03-01 00:00:00 | 632
Total | 7564.182180210971