tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 175918d1345668996-get-big-cells-to-show-in-filters-pctactionplan1
Sheet: PCT Action Plan DRAFT

 | Country | Person | City | Priority | Shop | BU | To Do | June | July | August | September
 | SWE | [NAME] | Stockholm | 1 | Elkjop | TV | Barkaby Shop display needs to be fixed
 |  |  |  | 1 | Expert | TV | [NAME]T procut training
 |  |  |  | 3 | Net On Net | TV | In Store Installation
 |  |  |  | 2 | Media Markt | Media | Campaign information HTS campaign
 |  |  | Malmö | 1 | Elkjop | TV | IN Store installation
 |  |  |  | 1 | Expert | Media | Media Product training
 |  |  |  | 2 | Media Markt
 |  |  |  | 2 | Net On Net
 |  | [NAME] | Stockholm | 1 | Elkjop | TV | LM760T product trainnig
 |  |  |  | 1 | Expert | Media | Media Product training
 |  |  |  | 1 | Media Markt | Media | In Store Installation
 |  |  |  | 2 | Net On Net | Media | Campaign information
 |  |  | Örebro | 1 | Elkjop
 |  |  |  | 1 | Expert
 |  |  |  | 1 | Media Markt
 |  |  |  | 2 | Siba
 | NOR | [NAME] | Oslo | 1 | Elkjop | TV | Barkaby Shop display needs to be fixed
 |  |  |  | 1 | Expert | TV | [NAME]T procut training
 |  |  |  | 3 | Net On Net | TV | In Store Installation
 |  |  |  | 2 | Media Markt | Media | Campaign information HTS campaign
 |  |  | Bergen | 1 | Elkjop | TV | IN Store installation
 |  |  |  | 1 | Expert | Media | Media Product training
 |  |  |  | 2 | Media Markt
 |  |  |  | 2 | Net On Net
 |  | [NAME] | Stavanger | 1 | Elkjop | TV | LM760T product trainnig
 |  |  |  | 1 | Expert | Media | Media Product training
 |  |  |  | 1 | Media Markt | Media | In Store Installation
 |  |  |  | 2 | Net On Net | Media | Campaign information
 |  |  | Haugesund | 1 | Elkjop
 |  |  |  | 1 | Expert
 |  |  |  | 1 | Media Markt
 |  |  |  | 2 | Siba
 | FIN | [NAME] | Helsingfors | 1 | Elkjop | TV | Barkaby Shop display needs to be fixed
 |  |  |  | 1 | Expert | TV | [NAME]T procut training
 |  |  |  | 3 | Net On Net | TV | In Store Installation
 |  |  |  | 2 | Media Markt | Media | Campaign information HTS campaign
 |  |  | Tampere | 1 | Elkjop | TV | IN Store installation
 |  |  |  | 1 | Expert | Media | Media Product training
 |  |  |  | 2 | Media Markt
 |  |  |  | 2 | Net On Net
 |  | [NAME] | [NAME] | 1 | Elkjop | TV | LM760T product trainnig
 |  |  |  | 1 | Expert | Media | Media Product training
 |  |  |  | 1 | Media Markt | Media | In Store Installation
 |  |  |  | 2 | Net On Net | Media | Campaign information
 |  |  | Vaasa | 1 | Elkjop
 |  |  |  | 1 | Expert
 |  |  |  | 1 | Media Markt
 |  |  |  | 2 | Siba
Spreadsheet: 795006d1662461716-right-forumla-in-vlookup-error-urmarire-porci-2022
Sheet: REZUMAT

 | Rezumat
 | Luna | [NAME] | [NAME] | Greutate [NAME] | Greutate Viu | Greutate Medie Viu | [NAME] | Carcasa CLF
 | Ianuarie
 | Februarie
 | [NAME]
 | [NAME]
 | Mai
 | Iunie
 | Iulie
 | August
 | Septembrie
 | [NAME]
 | Decembrie
Spreadsheet: 141940d1329521589-creating-a-conditional-list-with-multiple-factors-and-sources-amenity1
Sheet: Amenity Tracking (IRD only)

Internal Amenities
Order # | Room # | Blocked | Guest Name | Amenity | Notes | Delivery Time | Room Move | Delivered
FPC Amenities
Tier | Room # | Blocked | Guest Name | Amenity | Notes | Delivery Time | Room Move | Delivered
Spreadsheet: 844539d1696330106-hi-i-need-a-few-things-adding-or-changing-on-this-fishing-results-workbook-please-fishing-competition-results-1-
Sheet: 6

Name | lbs | oz | Oz (total) | Points
Spreadsheet: 600823d1543979341-cell-contains-one-of-many-things-nested-if
Sheet: Sheet1

 | Hrd |  | Race Type | Race Class
 | Chs |  | NHF | NHF
 | NHF |  | Stks NHF | NHF
 | Hcap Chs |  | [NAME] | NHF
 | Hcap Hrd |  | Listed NHF | NHF
 | [NAME] |  | Hcap Hrd | Hcap Hrd
 | [NAME] |  | Nov Hrd | Nov Hrd
 | Nov Hrd |  | [NAME] | [NAME]
 | Nov Stks |  | Nov Hcap Hrd | Hrd
 | Hcap |  | [NAME] | Hrd
 | Flat |  | Hrd | Hrd
 |  |  | [NAME] | Hrd
 |  |  | Listed Hrd | Hrd
 |  |  | Grd2 Hrd | Hrd
 |  |  | Selling Hrd | Hrd
 |  |  | Listed Hcap Hrd | Hrd
 |  |  | Grd3 [NAME] | Hrd
 |  |  | Grd2 Nov Hrd | Hrd
 |  |  | Nov Sell Hrd | Hrd
 |  |  | Listed Nov Hrd | Hrd
 |  |  | [NAME] | Hrd
 |  |  | [NAME] Listed | Hrd
 |  |  | [NAME] | Hrd
 |  |  | [NAME] | Hrd
 |  |  | [NAME] | Hrd
 |  |  | [NAME] | Hrd
 |  |  | Grd 2 Juv Hrd | Hrd
 |  |  | Hcap | Hcap
 |  |  | Nov Stks | Nov Stks
 |  |  | [NAME] | [NAME]
 |  |  | Nursery | Flat
 |  |  | Listed | Flat
 |  |  | Stks | Flat
 |  |  | Grp 3 | Flat
 |  |  | [NAME] | Flat
 |  |  | Cond Stks | Flat
 |  |  | Claim Stks | Flat
 |  |  | [NAME] | Flat
 |  |  | Grp1 | Flat
 |  |  | [NAME] | Flat
 |  |  | Grp3 | Flat
 |  |  | Grp 2 | Flat
 |  |  | PA | Flat
 |  |  | Hcap Stks | Flat
 |  |  | [NAME] | Flat
 |  |  | Grp 1 | Flat
 |  |  | Class Stks | Flat
 |  |  | Nov Hcap | Flat
 |  |  | Nursery Hcap | Flat
 |  |  | [NAME] | Flat
 |  |  | Mdn | Flat
 |  |  | Claim | Flat
 |  |  | PA Hcap | Flat
 |  |  | [NAME] | Flat
 |  |  | Selling Stks | Flat
 |  |  | Stakes | Flat
 |  |  | 1m [NAME] | Flat
 |  |  | 4f PA | Flat
 |  |  | Hcap Chs | Hcap Chs
 |  |  | Nov Hcap Chs | Chs
 |  |  | Nov Chs | Chs
 |  |  | [NAME] | Chs
 |  |  | Beg Chs | Chs
 |  |  | Chs | Chs
 |  |  | Nov Hunt Chs | Chs
 |  |  | Listed Chs | Chs
 |  |  | Grd3 Hcap Chs | Chs
 |  |  | Grd2 Chs | Chs
 |  |  | Listed Hcap Chs | Chs
 |  |  | Grd1 Chs | Chs
 |  |  | Nov Chs Listed | Chs
 |  |  | Grd 2 Nov Chs | Chs
 |  |  | [NAME] | Chs
 |  |  | Hcap Hunt Chs | Chs
 |  |  | Claim Chs | Chs
 |  |  | Grd2 Hcap Chs | Chs
 |  |  | [NAME] | Chs
 |  |  | XC Hcap Chs | Chs
 |  |  | [NAME] | Chs
 |  |  | Grd2 Nov Chs | Chs
 |  |  | Hcap Chs Listed | Chs
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Records Management

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Intake
Activity Name | Records Management
Activity Description / Purpose | Records management involves steps surrounding the creation and routing of physical case files.
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Create case file
Request old or history file
Log case
Assemble case folder
Route folder to appropriate department
Complete case transfer paperwork
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: drew_fossum__8870__Fixed2
Sheet: Sempra_2

[NAME]
FUEL HEDGING BOOK
Sempra_2
Prod. | Contract | Contract | Fixed |  | Fuel | Settled | Futures | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  | El Paso Prmn |  | (4) | (4) | (4)
1998-10-01 00:00:00 |  | Sempra
1998-11-01 00:00:00 |  | Sempra |  |  |  | 1.92
1998-12-01 00:00:00 |  | Sempra |  |  |  | 1.99
1999-01-01 00:00:00 |  | Sempra |  |  |  | 1.73
1999-02-01 00:00:00 |  | Sempra |  |  |  | 1.66
1999-03-01 00:00:00 |  | Sempra |  |  |  | 1.54
1999-04-01 00:00:00 |  | Sempra |  |  |  | 1.66
1999-05-01 00:00:00 |  | Sempra |  |  |  | 2.16
1999-06-01 00:00:00 |  | Sempra |  |  |  | 2.08
1999-07-01 00:00:00 |  | Sempra |  |  |  | 2.17
1999-08-01 00:00:00 |  | Sempra |  |  |  | 2.46
1999-09-01 00:00:00 |  | Sempra |  |  |  | 2.78
1999-10-01 00:00:00 |  | Sempra |  |  |  | 2.42
1999-11-01 00:00:00 |  | Sempra |  |  |  | 2.87
1999-12-01 00:00:00 |  | Sempra |  |  |  |  | 2.08
 |  |  |  |  |  | TW Index
1998-10-01 00:00:00 |  | Over-retention |  |  |  | 1.78
1998-11-01 00:00:00 |  | Over-retention |  |  |  | 1.99
1998-12-01 00:00:00 |  | Over-retention |  |  |  | 1.74
1999-01-01 00:00:00 |  | Over-retention |  |  |  | 1.73
1999-02-01 00:00:00 |  | Over-retention |  |  |  | 1.63
1999-03-01 00:00:00 |  | Over-retention |  |  |  | 1.59
1999-04-01 00:00:00 |  | Over-retention |  |  |  | 1.94
1999-05-01 00:00:00 |  | Over-retention |  |  |  | 2.06
1999-06-01 00:00:00 |  | Over-retention |  |  |  | 2.07
1999-07-01 00:00:00 |  | Over-retention |  |  |  | 2.11
1999-08-01 00:00:00 |  | Over-retention |  |  |  | 2.51
1999-09-01 00:00:00 |  | Over-retention |  |  |  | 2.36
1999-10-01 00:00:00 |  | Over-retention |  |  |  | 2.62
1999-11-01 00:00:00 |  | Over-retention |  |  |  | 2.17
1999-12-01 00:00:00 |  | Over-retention |  |  |  |  | 2.09
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.
Spreadsheet: 141308d1329213288-search-common-values-with-different-physical-locations-example2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Currently displaying |  |  | What I would like to display
 |  | PO No | Supplier | Description | Qty | Delivery Date | Value | Qty Received | Complete Ship | Location | Accept/Reject |  | Location
 |  | 114081 | [NAME] | picoview | 9 | 2012-02-08 00:00:00 | 100 | 9 |  | A1 |  |  | [NAME]
 |  | 120265 | Edmundson Electrical | enclosures | 10 | 2012-02-10 00:00:00 | 500 | 10 |  | C2 |  |  | C2,C4
Spreadsheet: 133091d1324163760-simplify-an-if-function-wo-test
Sheet: NOV11

 |  | 2011-11-01 00:00:00 | 2011-11-02 00:00:00 | 2011-11-03 00:00:00 | 2011-11-04 00:00:00 | 2011-11-05 00:00:00 | 2011-11-06 00:00:00 | 2011-11-07 00:00:00 | 2011-11-08 00:00:00 | 2011-11-09 00:00:00 | 2011-11-10 00:00:00 | 2011-11-11 00:00:00 | 2011-11-12 00:00:00 | 2011-11-13 00:00:00 | 2011-11-14 00:00:00 | 2011-11-15 00:00:00 | 2011-11-16 00:00:00 | 2011-11-17 00:00:00 | 2011-11-18 00:00:00 | 2011-11-19 00:00:00 | 2011-11-20 00:00:00 | 2011-11-21 00:00:00 | 2011-11-22 00:00:00 | 2011-11-23 00:00:00 | 2011-11-24 00:00:00 | 2011-11-25 00:00:00 | 2011-11-26 00:00:00 | 2011-11-27 00:00:00 | 2011-11-28 00:00:00 | 2011-11-29 00:00:00 | 2011-11-30 00:00:00
 |  | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F
 | EMP # | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
BILLY | 480 |  | D | D | D | D | D | D | D |  |  |  |  |  |  |  | V | V | V | D | D | D | D |  |  |  |  |  |  | WN | D
JACK | 485 |  | N | N | N | N | N | N | N |  |  |  |  |  |  |  | N | N | N | N | N | N | N |  |  |  |  |  |  |  | N
[NAME] | 500 | D |  |  |  |  |  |  |  | D | D | D | D | D | D | D |  |  |  |  |  | WD |  | V | V | V | V | N | N | N
FRED | 505 | N |  |  |  |  |  |  |  | N | N | N | N | N | N | N |  |  |  |  |  | WN |  | V | V | V | V | V | V | V
 |  | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
[NAME] | 510 |  | N | N | N | N | N | N | N |  |  |  |  |  | WD |  | D | D | D | D | D | D | D |  |  |  |  |  |  |  | N
CARL | 515 |  | D | D | D | D | D | D | D |  |  |  |  |  |  |  | N | N | N | N | N | N | N |  |  |  |  |  |  |  | D
DON | 520 | N |  |  |  |  |  |  |  | D | D | D | D | D | D | D | WD |  |  |  |  |  |  | N | N | N | N | N | N | N
FRANK | 525 | D |  |  |  |  |  |  |  | N | N | N | N | N | N | N |  |  |  |  |  |  |  | D | D | D | D | D | D | D
Spreadsheet: 855494d1705037816-look-up-and-return-not-a-normal-criterira-aqu-1-12-ans2
Sheet: PICK SHEET (2)

P/O | MFG Part | NICK NAME | Need | BOX 1 | BOX 2 | BOX 3 | BOX 4 | BOX 5 | BOX 6 | BOX 7 | BOX 8 | BOX 9 | BOX 10
7016100 | 72210519 | AQU032S
 | 74210171 | MC2057
 | 72210522 | AQU036S
 | 72210535 | AQU037S
 | 72210587 | AQU138
 | 74210123 | MC2107
 | 74210100 | AQU068
 | 74210110 | AQU069
 | 74210133 | AQU105PR
 | 74210143 | AQU112PR
7016047 | 72210519 | AQU032S
 | 74210125 | MC2108
7015887
7016005
Spreadsheet: 26597d1218788114-taking-values-from-another-sheet-forum
Sheet: Sheet2

 | enter product number and it will find the info for you |  |  |  |  |  |  | TABLE
 | No | Prod | Price |  |  |  | no | prod | price
 | 1 | ham | 10 |  |  |  | 1 | ham | 10
 | 3 | pie | 30 |  |  |  | 2 | cheese | 20
 | 5 | cake | 50 |  |  |  | 3 | pie | 30
 | 2 | cheese | 20 |  |  |  | 4 | fish | 40
 | 4 | fish | 40 |  |  |  | 5 | cake | 50
Spreadsheet: 863989d1711368708-work-out-time-duration-from-start-and-end-times-sim-outages-2-
Sheet: Careiums Sims

Careium | Signal Lost | Signal Restored | Total Outage Time
10000 | 00:13:00 | 10:29:00 | 10hrs 17 mins
10002 | 00:15:00 | 10:29:00 | 10hrs 14 mins
10004 | 00:12:00 | 10:41:00 | 10hrs 29 mins
10005 | 00:17:00 | 10:29:00 | 10hrs 12 mins
10007 | 04:28:00 | 10:34:00 | 6hrs 6 mins
10014 | 00:15:00 | 10:29:00 | 10hrs 14 mins
10016 | 00:15:00 | 10:31:00 | 10hrs 16 mins
10020 | 00:17:00 | 10:31:00 | 10hrs 14 mins
10024 | 08:11:00 | 10:29:00 | 2hrs 18 mins
10027 | 02:36:00 | 10:31:00 | 7 hrs 55 mins
10034 | 01:41:00 | 09:35:00 | 7hrs 54 mins
10036 | 00:46:00 | 10:31:00 | 9 hrs 45 mins
10037 | 00:25:00 | 10:29:00 | 9 hrs 45 mins
10042 | 01:15:00 | 10:29:00 | 9 hrs 14 mins
10043 | 02:37:00 | 10:29:00 | 7 hr 52 mins
10044 | 00:15:00 | 10:28:00 | 10 hrs 13 mins
10045 | 00:33:00 | 10:24:00 | 9 hrs 51 mins
10049 | 00:46:00 | 09:59:00 | 9 hrs 13 mins
10050 | 00:08:00 | 09:57:00 | 9 hrs 49 mins
10056 | 00:25:00 | 10:34:00 | 10 hrs 9 mins
10060 | 01:23:00 | 10:12:00 | 8 hrs 49 mins
10062 | 01:41:00 | 09:59:00 | 8 hrs 18 mins
10063 | 00:33:00 | 10:04:00 | 9 hrs 31 mins
10064 | 01:15:00 | 10:54:00 | 9 hrs 39 minutes
10065 | 00:46:00 | 10:41:00 | 9 hrs 55 mins
Spreadsheet: daacfe53-9ecc-4b98-8561-efd59e3355d3
Sheet: Sheet1

PRESIDENT OF THE UNITED STATES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Democratic Presidential Primary
1996-02-20 00:00:00
Sullivan County | Chimento, d | [NAME], d | Harder, d | Paulsen, d | [NAME], r | Buchanan, r
Acworth | 0 | 53 | 1 | 2 | 0 | 0
Charlestown | 5 | 332 | 2 | 1 | 10 | 20
Claremont Ward 1 | 1 | 339 | 1 | 1 | 2 | 23
Claremont Ward 2 | 1 | 373 | 1 | 1 | 5 | 17
Claremont Ward 3 | 3 | 371 | 3 | 0 | 4 | 35
Cornish | 0 | 98 | 2 | 4 | 1 | 7
Croydon | 0 | 34 | 1 | 0 | 3 | 1
Goshen | 0 | 58 | 0 | 3 | 1 | 2
Grantham | 0 | 111 | 0 | 1 | 2 | 0
Langdon | 0 | 39 | 0 | 0 | 0 | 1
Lempster | 1 | 36 | 0 | 0 | 2 | 0
Newport | 4 | 380 | 3 | 8 | 4 | 17
Plainfield | 1 | 173 | 2 | 3 | 0 | 3
Springfield | 0 | 60 | 0 | 3 | 1 | 0
Sunapee | 1 | 181 | 0 | 2 | 0 | 8
Unity | 3 | 58 | 0 | 3 | 2 | 2
Washington | 0 | 42 | 0 | 1 | 1 | 1
Totals | 20 | 2738 | 16 | 33 | 38 | 137
Sullivan County | [NAME], r | Forbes, r | Keyes, r | Lugar, r | [NAME], r | [NAME]*
Acworth | 0 | 1 | 0 | 0 | 0 | 0
Charlestown | 7 | 4 | 5 | 2 | 4 | 0
Claremont Ward 1 | 3 | 10 | 3 | 1 | 2 | 0
Claremont Ward 2 | 9 | 9 | 0 | 6 | 0 | 0
Claremont Ward 3 | 8 | 19 | 0 | 1 | 4 | 0
Cornish | 4 | 5 | 0 | 1 | 0 | 1
Croydon | 0 | 2 | 0 | 0 | 1 | 0
Goshen | 0 | 1 | 0 | 0 | 0 | 0
Grantham | 2 | 2 | 0 | 0 | 0 | 1
Langdon | 1 | 0 | 0 | 0 | 0 | 0
Lempster | 0 | 1 | 0 | 0 | 0 | 0
Newport | 3 | 6 | 0 | 4 | 2 | 0
Plainfield | 2 | 2 | 1 | 0 | 0 | 0
Springfield | 0 | 4 | 0 | 0 | 0 | 0
Sunapee | 3 | 6 | 2 | 0 | 0 | 86
Unity | 0 | 5 | 0 | 1 | 1 | 0
Washington | 1 | 0 | 1 | 1 | 0 | 0
Totals | 43 | 77 | 12 | 17 | 14 | 88
*write-ins
[NAME]: 1-Claremont Wd 3. [NAME]: 1-Claremont Wd 1; 2-Claremont Wd 3; 1-Lempster. [NAME]: 1-Claremont Wd 3; 1-Unity. Drucker: 1-Washington.
Griffin: 1-Charlestown; 1-Claremont Wd 2; 1-Cornish; 2-Newport; 1-Sunapee. Hamm: 1-Cornish; 1-Newport; 1-Sunapee. [NAME]: 1-Acworth;
1-Charlestown; 1-Croydon; 1-Lempster; 1-Newport; 1-Sunapee. LaRouche: 1-Acworth; 2-Claremont Wd 3; 1-Cornish; 1-Langdon; 1-Newport; 1-Sunapee.
[NAME]: 1-Charlestown; 1-Claremont Wd 3; 1-Sunapee. [NAME]: 1-Newport. [NAME]: 1-Grantham. Thorpe: 1-Charlestown; 1-Cornish. [NAME]: 1-Charlestown.
[NAME]: 2-Claremont Wd 1; 1-Newport. Skillen: 1-Charlestown; 1-Claremont Wd 2; 1-Claremont Wd 3; 1-Cornish; 1-Goshen. [NAME]: 1-Claremont Wd 2;
1-Claremont Wd 3; 1-Lempster; 1-Newport; 5-Sunapee. Perot: 1-Charlestown; 1-Grantham; 1-Langdon. [NAME]: 1-Sunapee.
Spreadsheet: 52511d1252310931-identify-new-text-in-a-list-in-one-workbook-and-return-it-to-another-workbook-example
Sheet: WORKBOOK1

Raw Data
Name | Admin Hours | Training hours | Call out hours
[NAME] | 2 | 2 | 5
[NAME] | 2 | 3 | 2
[NAME] | 2 | 4 | 1
[NAME] | 8.5 | 2.5 | 3
 | [NAME] is pasted in as a new addition to this list
Spreadsheet: 63447d1264374989-filter-info
Sheet: Sheet2 (2)

ADDRESS | DATE | WORKSHOP  WAREHOUSE AREA (SQM) | RATE  $psqm | OTHER BUILDING AREAS | AREA (SQM) | RATE $psqm | SITE WORKS | AREA (SQM) | RATE |  |  | COMMENTS
J Road | 2009-08-27 00:00:00 |  |  |  |  |  |  |  |  |  |  | J Road Building
 |  |  |  | Store | 745 | 23 | Yard | 453 | 23
 |  | 4895 | 63.08 | Office | 34 | 43 | Land | 23 | 23
 |  |  |  | Canopy | 423 | 23 | Carparks | 455 | 23
O Road | 2009-06-01 00:00:00 |  |  | Office | 23 | 43 | Yard | 24 | 345 | @ | 0.05 | O Road Building
 |  |  |  | Mezzanine Open | 124 | 43 | Conrete | 23 | 12 | @ | 0.03
 |  | 1231 | 75 | Mezzanine Office | 23 | 23 | Fences & Gate |  |  | @ | 0.05
 |  |  |  | Tool Room | 345 | 23 | Rear Yard | 234 | 12 | @ | 0.04
 |  |  |  |  |  |  | Drive Concrete |  |  | @ | 0.04
C Street | 2009-06-18 00:00:00 |  |  |  |  |  |  |  |  |  |  | C Street Building
 |  | 456 | 80 | Office | 56 | 23 | Carparks | 34 | 10
C Street | 2009-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | C Street Building
 |  | 867 | 65 | Office | 4312 | 43 | Sealed Yard | 543 | 5 | @ | 0.05
S Place | 2009-01-01 00:00:00 |  |  | Packhouse | 3412 | 2 | Deck | 34 | 4 |  |  | S Place Building
 |  |  |  | Office | 523 | 4 | Sealed Yard | 54 | 34
 |  |  |  | Staffroom | 4 | 5 | Metal Yard | 34 | 5
 |  |  |  | Office | 4535 | 6
 |  |  |  | Office | 7567 | 8
 |  |  |  | Office | 568 | 9
 |  |  |  | Lockers | 7 | 0
 |  | 738 | 27.01 | Store | 696 | 5
 |  |  |  | Store | 9 | 4
 |  |  |  | Canopy | 67 | 23
 |  |  |  | Plantroom | 4 | 45
 |  |  |  | Plantroom | 35 | 324
 |  |  |  | [NAME] | 35 | 23
 |  |  |  | Extension | 4234 | 23
O Road | 2009-01-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | O Road Building
 |  |  |  |  |  |  | Front Conrete |  | 23 | @ | 0.03
 |  | 23 | 23 | Mezzanine | 43 | 23 | Front Land |  | 45 | @ | 0.03
 |  |  |  |  |  |  | Fencing |  | 3 | @ | 0.03
Spreadsheet: 116336d1311766617-excel-2007-merging-data-from-three-reports-upload-1-rev-a
Sheet: Data

COMPILED REPORT RESULTS |  |  |  |  |  |  |  |  |  | SM based Utilization Data |  |  |  |  |  | Model Series Lookup
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAKE | EQUIP ID | CONTRACT | SERIAL #
TYPE | MAKE | SERIAL # | [NAME] | External | Total | Annual Util | $$/HR/12mth |  | Make | Model | Serial Nbr | Hrs per Day | Annualized |  | Make | Model | Series Code |  | THE REPORT RETURNS THESE AS BLANK |  |  |  | [NAME] | Misuse | Misuse  Wheels | Other  Service | Repair  Expenses | Scheduled  Maintenance | Shop  Repairs | Wheels/Tires /Casters | Total
 |  |  |  |  | ?? |  |  |  | RAYM | 114TM-TOW | 114-19223 | 10.665306122449 | 3892.83673469388 |  | RAYM | 114TM-TOW | TOW |  | RAYM |  | SM | 123-19255 | 0 | 0 | 0 | 0 | 0 | 305.1 | 0 | 0 | 305.1
 |  |  |  |  | ?? |  |  |  | RAYM | 840-FRE80L | 840-75069 | 7.50915750915751 | 2740.84249084249 |  | RAYM | 123-OPC-162 | OPC |  |  | 4 | [NAME] | 840-75069 | 657 | 2180.67 | 303.12 | -8.85 | 1508.705 | 195 | 0 | 283.58 | 5119.225
OPC | RAYM | 123-19255 |  |  | ?? |  |  |  | RAYM | 123-OPC-162 | 123-19255 | 6.4 | 2336 |  | RAYM | 840-FRE80L | RIDER_PT |  | RAYM |  | SM | 114-19223 | 0 | 0 | 0 | 0 | 0 | 305.1 | 0 | 0 | 305.1
Spreadsheet: 697387d1601329928-inventory-cost-calculation-fifo-easy-finaly-3-_error
Sheet: Fifo

Date | Item.Code | Type | Note | Purchase | Cost / Unit - Manual | Sale | Cumulative purchase Quantity  irrespective Of [NAME] code | Balance | Cucmulative sales quantity irrespective of item.code | TransactionType | Movement | Total Cost irrespective of item code (works) | Total Cost based on FIFO / item code (problem) | Cumulative purchase Cost irrespective of item.code | ESQty | ESCost | cpq.item | csq.item | excess | cpc.item
2013-01-01 00:00:00 | product1 | 1 |  | 1 | 1.5
2013-01-15 00:00:00 | product1 | 1 |  | 1 | 1.5
2013-01-31 00:00:00 | product1 | 1 |  | 4 | 2
2013-01-31 00:00:00 | product1 | 2 |  |  |  | 1
2013-01-31 00:00:00 | product1 | 2 |  |  |  | 1
2013-01-31 00:00:00 | product1 | 2 |  |  |  | 1
 |  |  |  | There is an error according to the first in first out method.  ( N Col)
 |  |  |  |  |  |  |  |  | three items cost | 5 | it must be
 |  |  |  |  |  |  |  |  | 4.5 wrong
 |  |  |  |  |  |  |  | Out
 |  |  |  |  |  |  |  | 1 * 1,5
 |  |  |  |  |  |  |  | 1 * 1,5
 |  |  |  |  |  |  |  | 1 * 2
 |  |  |  |  |  |  |  |  |  |  | Total | 5 | True
 |  |  |  |  |  |  |  | 4.5 | False
Spreadsheet: 692441d1598340683-excel-formula-to-calculate-employee-benefits-employee-benefits-3
Sheet: EMPLOYEE DATA

Employee data
Employee Code Number | Employee Name | Employee I.D Number | Date of Birth | Age | Disability | Motor Vehicle Benefit
CA1 | OLIVIA | 86000486 | 1974-05-30 00:00:00 |  | Yes | 1400cc
CA2 | BEAUTY | 12468300 | 1960-03-01 00:00:00 |  | No | [NAME]
CA3 | MARGARET | 220002002 | 1965-01-20 00:00:00 |  | Yes | 3001cc
CA4 | ENITA | 44804321 | 1976-04-03 00:00:00 |  | No
CA5 | EVERJOY | 44804333 | 1980-04-03 00:00:00 |  | No
CA6 | [NAME] | 44804333 | 1981-04-03 00:00:00 |  | No | 2500cc
Motor Vehicle benefit
Engine Capacity Value (Deemed Benefit per month)
1500cc or less | 1800
1501cc to 2000 | 2400
2001cc to 3000cc | 3600
Above 3000cc | 4800
Other benefits
Disability benefit | 720
Elderly person benefit | 720 | 55  Years and above
Note: Onlly persons with 55 years and above get the elderly benefit $720.  (Age Column E6:E12)
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-13-F-0001

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-13-F-0001 | 10182201 | 4NNA9 | 1P | 2 | 55 | 1428
W912LP-13-F-0001 |  |  |  | 3 | 110 |  |  |  |  | 1608.75
W912LP-13-F-0001 |  | 4NNA9 | 2P | 1 | 175 | 1429 |  |  |  | 1744.75
W912LP-13-F-0001 |  | 4NNA9 | 3P | 1 | 110 | 1430 |  |  |  | 1096.7
W912LP-13-F-0001 |  | 4NNA9 | 4P | 1 | 135 | 1431
W912LP-13-F-0001 |  |  |  | 3 | 166 |  |  |  |  | 2917.97
W912LP-13-F-0001 |  | 4NNA9 | 5P | 2 | 121 | 1432
W912LP-13-F-0001 |  |  |  | 4 | 55 |  |  |  |  | 1669.91
W912LP-13-F-0001 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 136822d1326834604-sort-column-data-while-locking-together-objects-in-different-rows-example
Sheet: Sheet1

 |  |  | Delivery Month | Color | Month 1 Sales | Month 2 Sales | Month 3 Sales | Total
 |  |  | 2011-01-01 00:00:00 | Red | 50 | 6 | 45
 |  |  | 2011-01-01 00:00:00 | Green | 432 | 234 | 3
 |  |  | 2011-01-01 00:00:00 | Blue | 2 | 4 | 5
 |  |  |  | Sum
 |  |  |  | High
 |  |  |  | Median
 |  |  |  | Launch
 |  |  | 2011-04-01 00:00:00 | Red | 50 | 6 | 45
 |  |  | 2011-04-01 00:00:00 | Green | 432 | 234 | 3
 |  |  | 2011-04-01 00:00:00 | Blue | 2 | 4 | 5
 |  |  |  | Sum
 |  |  |  | High
 |  |  |  | Median
 |  |  |  | Launch