tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 70799d1271482144-names-to-numbers-new-new-mileage
Sheet: Mileage Log and Reimbursement

Mileage Log and Reimbursement Form |  |  |  |  |  |  |  | http://www.hypermiler.co.uk/mpg-calculator.html
 |  |  |  |  |  |  |  | http://www.hmrc.gov.uk/cars/advisory_fuel_current.htm
Employee Name | [NAME] |  |  |  |  | Rate Per Mile |  |  | 0.12 |  | per lit | 1.09
Employee ID |  |  |  |  |  | For Period |  |  | From 25/10/09 to 27/10/09 |  | per gal | 4.9595
Vehicle Description | fiat 500 |  |  |  |  | Total Mileage |  |  | 710 |  | per mile | 12p
Authorized By |  |  |  |  |  | Total Reimbursement |  |  | 85.2
Date |  | [NAME] 1 | [NAME] 2 | [NAME] 3 | [NAME] 4 | [NAME] 5 | [NAME] 6 | Hours | [NAME] | Odometer End | Mileage | Reimbursement
2009-10-25 00:00:00 |  | [NAME] | Mario | Rachelle | Chenga | Shahima | keivn |  |  |  | 250 | 30
2009-10-27 00:00:00 |  | Chenga | Chenga |  |  | Marcol |  |  |  |  | 170 | 20.4
 |  | Rachelle | Rachelle | keivn | mario |  |  |  |  |  | 175 | 21
 |  | Chenga | Rachelle | mario |  |  |  |  |  |  | 115 | 13.8
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 |  | Totals | 710 | 85.2
 | LIST
 | mario | 45 |  | I have made another sheet (tab) for names this can be as long as it wants :)
 | Rachelle | 35 |  | But can I link the cells on this page from that other one?
 | Shahima | 35
 | [NAME] | 40
 | Chenga | 35
 | keivn | 60
 | Marcol | 100
Spreadsheet: michelle_lokay__26576__Dec00pnr
Sheet: EES 500616

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Inventory Calculation
DAY | NAME | CONTRACT NUMBER | MONTH | POI # | type_poi | SCHEDULED INJECTION | SCHEDULED WITHDRAWAL | NET SCHEDULED QTY | Carryover GIP | NET GIP | DAILY INJECTION   PRICE                (Inj + MIC) | DAILY WITHDRAWAL  PRICE               (Wd + MIC) | INJECTION AMOUNT       (Inj + MIC) | WITHDRAWAL  AMOUNT          (Wd + MIC) | Positive Inventory | Negative Inventory | Positive Inventory Components | Negative Inventory Components
 | Enron Energy Services | 27431 | 00/12 | 500616 | PnR
1 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
2 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
3 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
4 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
5 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
6 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
7 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
8 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
9 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
10 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
11 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
12 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
13 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
14 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
15 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
16 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
17 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
18 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
19 |  |  |  |  |  | 4645 |  |  |  |  | 0.3883 | 0.3883
20 |  |  |  |  |  |  | -4645 |  |  |  | 0.3883 | 0.3883
21 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
22 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
23 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
24 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
25 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
26 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
27 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
28 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
29 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
30 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
31 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absolute [NAME]
 |  |  |  | Total Injection |  |  |  |  |  |  |  | Total Invoice Amount
 |  |  |  | Total W/D
Spreadsheet: 731489d1620367522-bulk-hyperlink-permit-register-adjusted
Sheet: ABC Job Register

E:\Temp\* | C:\Users\Admin\OneDrive - AB Consulting\Desktop\Test - Permit Registers\2021\*
ABC Job Number | Address | Job Description | Client | Job Received | Quote Sent | Date of Confirmation  to Proceed | Permit Number | BP | OP | Job Notes | Oustanding Documents | Invoice Date
 | Address 1 | Description 1 | Client 1 | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | 2021-02-05 00:00:00 | 123/123/123 | 2021-03-01 00:00:00 | 2021-03-01 00:00:00
 | Address 2 | Description 2 | Client 2 | 2021-02-05 00:00:00 | 2021-02-06 00:00:00
 | Address 3 | Description 3 | Client 3 | 2021-02-10 00:00:00 | 2021-02-11 00:00:00 | 2021-02-15 00:00:00 | 456/456/456 | 2021-03-01 00:00:00 | 2021-03-01 00:00:00
 | Address 4 | Description 4 | Client 4 | 2021-02-15 00:00:00 | 2021-02-16 00:00:00 | 2021-02-20 00:00:00 | 789/789/789 | 2021-03-01 00:00:00 | OP |  | Waiting on Plumbing cert
 | Address 5 | Description 5 | Client 5 | 2021-02-20 00:00:00 | 2021-02-21 00:00:00 | 2021-02-25 00:00:00 | 001/123/001 | 2021-03-05 00:00:00 | AMDT OP
 | Address 6 | Description 6 | Client 6 | 2021-02-25 00:00:00 | 2021-02-26 00:00:00 | 2021-02-28 00:00:00 | 002/456/002 | 2021-03-05 00:00:00 | READY
 | Address 7 | Description 7 | Client 7 | 2021-03-01 00:00:00 | 2021-03-02 00:00:00 | 2021-03-05 00:00:00 | 003/789/003 | 2021-04-01 00:00:00 | READY
 | Address 8 | Description 8 | Client 8 | 2021-03-05 00:00:00 | 2021-03-06 00:00:00 | 2021-03-10 00:00:00 | 004/999/456 | READY
 | Address 9 | Description 9 | Client 9 | 2021-03-10 00:00:00 | 2021-03-11 00:00:00 | 2021-03-15 00:00:00 | 789/000/001 | READY
 | Address 10 | Description 10 | Client 10 | 2021-03-15 00:00:00 | 2021-03-16 00:00:00
 | Address 11 | Description 11 | Client 11 | 2021-03-20 00:00:00 | 2021-03-21 00:00:00 | 2021-03-25 00:00:00 |  | BP |  | Waiting on $ value from client 30/3
 | Address 12 | Description 12 | Client 12 | 2021-03-25 00:00:00 | 2021-03-26 00:00:00 | 2021-03-30 00:00:00 | 654/654/654 | BP Stage 2
 | Address 13 | Description 13 | Client 13 | 2021-03-30 00:00:00 | 2021-03-31 00:00:00 | 2021-04-01 00:00:00 | 987/987/987 | BP
 | Address 14 | Description 14 | Client 14 | 2021-04-01 00:00:00 | 2021-04-02 00:00:00
 | Address 15 | Description 15 | Client 15 | 2021-04-05 00:00:00 | 2021-04-06 00:00:00 | 2021-04-05 00:00:00 | 321/321/321 | BP
 | Address 16 | Description 16 | Client 16 | 2021-04-10 00:00:00 | 2021-04-11 00:00:00 | 2021-04-15 00:00:00 |  | Out of Area BP
ABC-21017 | Address 17 | Description 17 | Client 17 | 2021-04-15 00:00:00 | 2021-04-16 00:00:00
ABC-21018 | Address 18 | Description 18 | Client 18 | 2021-04-20 00:00:00 | 2021-04-21 00:00:00 | 2021-04-22 00:00:00 |  | BP
ABC-21019
ABC-21020
ABC-21021
ABC-21022
ABC-21023
ABC-21024
ABC-21025
ABC-21026
ABC-21027
ABC-21028
ABC-21029
ABC-21030
ABC-21031
ABC-21032
ABC-21033
ABC-21034
ABC-21035
ABC-21036
ABC-21037
ABC-21038
ABC-21039
ABC-21040
Spreadsheet: 154609d1336494921-subtracting-values-in-cells-from-a-total-and-counting-the-number-of-cells-to-reach-0-strawberry-temp-forecast
Sheet: Constants_Ratios

 |  | Required Sum of Average 24Hr Temps from Flower to Ripe Fruit | Flowers bearing fruit (%) | Class I fruit (%) | Class II fruit (%) | Waste fruit (%)
[NAME] | Group 01 | 750 | 0.8 | 0.9 | 0.07 | 0.03
[NAME] | Group 02 | 750 | 0.8 | 0.9 | 0.07 | 0.03
[NAME] | Group 03 | 750 | 0.8 | 0.9 | 0.07 | 0.03
[NAME] | Group 04 | 750 | 0.8 | 0.9 | 0.07 | 0.03
[NAME] | Group 05 | 750 | 0.8 | 0.9 | 0.07 | 0.03
[NAME] | Group 06 | 750 | 0.8 | 0.9 | 0.07 | 0.03
[NAME] | Group 07 | 750 | 0.8 | 0.9 | 0.07 | 0.03
Elsanta | Group 08 | 750 | 0.65 | 0.8 | 0.15 | 0.05
Elsanta | Group 09 | 750 | 0.65 | 0.8 | 0.15 | 0.05
Elsanta | Group 10 | 750 | 0.65 | 0.8 | 0.15 | 0.05
Elsanta | Group 11 | 750 | 0.65 | 0.8 | 0.15 | 0.05
Elsanta | Group 12 | 750 | 0.65 | 0.8 | 0.15 | 0.05
Elsanta | Group 13 | 750 | 0.65 | 0.8 | 0.15 | 0.05
Spreadsheet: 759480d1639570490-need-multiple-values-from-lookup-value-book2
Sheet: Main Data

Emp Number | Emp Name | Cost center | STAFFING PERCENTAGE
128745 | [NAME] | T85755 | 100
128756 | [NAME] bhailalbhai Kothiya | T85755 | 100
128759 | [NAME] | T85755 | 100
128799 | [NAME] | T85755 | 100
128754 | VENU GOPAL MANGENA | T85755 | 100
128750 | [NAME] | T85755 | 100
128751 | [NAME] | T85755 | 100
128752 | [NAME] | T85755 | 100
128753 | [NAME] | T85755 | 100
128778 | [NAME] | T85755 | 100
128755 | MUKESH KUMAR | T85755 | 100
128791 | [NAME] | T82301 | 50
128791 | [NAME] | T82302 | 50
128792 | Deepak Dalal | T82289 | 99
128792 | Deepak Dalal | T82290 | 1
128793 | [NAME] | T82289 | 50
128793 | [NAME] | T82290 | 50
128794 | [NAME] | T82295 | 50
128794 | [NAME] | T82296 | 50
128795 | ASHISH BHARTI | T27666 | 50
128795 | ASHISH BHARTI | T27667 | 50
128796 | BVBR RAJESH | T89765 | 15
128796 | BVBR RAJESH | T89766 | 35
128796 | BVBR RAJESH | T89767 | 30
128797 | [NAME] | T14567 | 80
128797 | [NAME] | T14568 | 15
128797 | [NAME] | T14569 | 5
Spreadsheet: 851186d1701404365-formula-issues-match-index-book1-3-1-
Sheet: Sheet1

 | Scenario 1
 | Paid |  |  |  |  |  |  | Payment Terms (Days)
 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 |  |  | 60
 | 100000 | 50000
 | Received
 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00
 |  |  | 99999.99999999999 | 49999.99999999999 |  |  |  |  |  | 99999.99999999999 | 49999.99999999999
 | Hardcoded Example of Goal Result: (60 days)
 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00
 |  |  | 100000 | 50000
Spreadsheet: 142038d1329594641-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fantasy-golf
Sheet: British

 |  | WEEK 16 The British
 |  | Total Earnings |  |  |  | Rankings Through Week 16 | Total
 | [NAME] | 0 |  | 2 |  | [NAME] | 5000
 | [NAME] | 5000 |  | 1 |  | [NAME] | 0
 | [NAME] | 0 |  | 3 |  | [NAME] | 0
 |  | 0 |  | 4 |  | 0 | 0
 |  | 0 |  | 5 |  | 0 | 0
 |  | 0 |  | 6 |  | 0 | 0
 |  | 0 |  | 7 |  | 0 | 0
 |  | 0 |  | 8 |  | 0 | 0
 |  | 0 |  | 9 |  | 0 | 0
 |  | 0 |  | 10 |  | 0 | 0
 |  | 0 |  | 11 |  | 0 | 0
 |  | 0 |  | 12 |  | 0 | 0
 |  | 0 |  | 13 |  | 0 | 0
 |  | The British |  | YTD
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 5000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 5000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
Spreadsheet: 266149d1379512785-i-need-to-bump-data-from-two-different-spreadsheets-2012
Sheet: sheet1

PO_DANIELLE_OM_MFG_PURCHASES | 2359
Unit | PO | PO Date | Vndr SetID | Vendor | Line | Mfg ID | Mfg Itm ID | Item | Description | PO Qty | Price
A | 1579300 | 2012-09-21 00:00:00 | AHS | 92369 | 1 | 2299 | TRC1 | 949328 | ITEM 12 | 2 | 1069.64
A | 1579300 | 2012-09-21 00:00:00 | AHS | 92369 | 2 | 2299 | LLB22 | 930734 | ITEM 14 | 1 | 281.2
C | 1952496 | 2012-09-04 00:00:00 | AHS | 92369 | 8 | 2299 | PDS15 | 25553 | ITEM 17 | 3 | 120
Spreadsheet: 8cad5f43-197c-4512-b23c-7f1a0d3af9ae
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FHSSE | Test | FHSSE | Helminthosporium sativum/[NAME] | Helminthosporium sativum IgE | Radioimmunoassay (RIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | <[NAME]/L  Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr.                              Lee's Summit, MO 64086 | Monday through Friday | 2 - 3 days | 4 - 7 days | 1 | 86003 |  |  |  |  | Viracor-IBT Laboratories
FHSSE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FHSSE | Result | Z3092 | Helminthosporium sativum IgE | Helminthosporium sativum IgE | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHSSE | Result | Z3093 | Class | Class | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 265877d1379432259-formulae-for-golf-syndicate-problems-x3-below-can-anyone-help-copy-of-summary-sheets
Sheet: Top ten weekly scores

Member | Top 10 scores for the year |  |  |  |  |  |  |  |  |  | Average
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 272606d1382444369-rearranging-datewise-horizontally-in-a-specified-format-from-raw-data-vat1_sr_rev
Sheet: Result(Revised)

Date | Name of Party | Particulars | Reference No. | Taxable Purchase | Taxable Import | [NAME] | [NAME] in Custom | Excise Duty | Total
 |  |  | [NAME]. 610
 |  |  | [NAME]. 504
 |  |  | [NAME]. 4409
 |  |  | PP NO.55408
 |  |  | PP NO. 55253
 |  |  | RECEPT NO. 93198
Spreadsheet: 222331d1363816132-rearranging-data-sample-data
Sheet: Sheet1

Cardholders - Simple Report |  |  | First | * | Last | * | Card Type (A=All, R=Regular, V=Visitor) | All | Partition | *
Company | XYZ
Department | *
Partition | Super User
First | [NAME] | Middle | 123 | Last | Smith | Company | XYZ | Department |  | Card Type (A=All, R=Regular, V=Visitor) | Regular | E-Mail
Access Badge
Badge Number | 123
Badge Status | Active
Access Groups | Timezones
Group 1 | 24/7 All Door All Lifts | Time Zone 1 | 24/7
Total Number of Badges | 1
Cardholders - Simple Report |  |  | First | * | Last | * | Card Type (A=All, R=Regular, V=Visitor) | All | Partition | *
Company | ABC
Department | *
Partition | Super User
First | [NAME] | Middle | 456 | Last | Doe | Company | ABC | Department |  | Card Type (A=All, R=Regular, V=Visitor) | Regular | E-Mail
Access Badge
Badge Number | 456
Badge Status | Disabled
Access Groups | Timezones
Group 1 | Carpark | Time Zone 1 | 24/7
Group 2 | Level 7 Only | Time Zone 1 | 7am - 6pm Mon - Fri
Total Number of Badges | 1
Spreadsheet: 203911d1357296956-prorating-monthly-into-weekly-excel-help-upload-jan-4-2013
Sheet: Monitoring

 | 2012-12-31 00:00:00 | 2013-01-07 00:00:00 | 2013-01-14 00:00:00 | 2013-01-21 00:00:00 | 2013-01-28 00:00:00 | 2013-02-04 00:00:00 | 2013-02-11 00:00:00 | 2013-02-18 00:00:00 | 2013-02-25 00:00:00 | 2013-03-04 00:00:00 | 2013-03-11 00:00:00 | 2013-03-18 00:00:00 | 2013-03-25 00:00:00 | 2013-04-01 00:00:00 | 2013-04-08 00:00:00 | 2013-04-15 00:00:00 | 2013-04-22 00:00:00 | 2013-04-29 00:00:00 | 2013-05-06 00:00:00 | 2013-05-13 00:00:00 | 2013-05-20 00:00:00 | 2013-05-27 00:00:00 | 2013-06-03 00:00:00 | 2013-06-10 00:00:00 | 2013-06-17 00:00:00 | 2013-06-24 00:00:00 | 2013-07-01 00:00:00 | 2013-07-08 00:00:00 | 2013-07-15 00:00:00 | 2013-07-22 00:00:00 | 2013-07-29 00:00:00 | 2013-08-05 00:00:00 | 2013-08-12 00:00:00 | 2013-08-19 00:00:00 | 2013-08-26 00:00:00 | 2013-09-02 00:00:00 | 2013-09-09 00:00:00 | 2013-09-16 00:00:00 | 2013-09-23 00:00:00 | 2013-09-30 00:00:00 | 2013-10-07 00:00:00 | 2013-10-14 00:00:00 | 2013-10-21 00:00:00 | 2013-10-28 00:00:00 | 2013-11-04 00:00:00 | 2013-11-11 00:00:00 | 2013-11-18 00:00:00 | 2013-11-25 00:00:00 | 2013-12-02 00:00:00 | 2013-12-09 00:00:00 | 2013-12-16 00:00:00 | 2013-12-23 00:00:00 | 2013-12-30 00:00:00
Prorate Target Direct
Prorate Target Deals
Spreadsheet: 60350d1260906320-auto-copy-part-of-row-in-a-worksheet-to-another-worksheet-based-on-criteria-case-assignments2010-temp
Sheet: Jan2010

 | Week 1 |  |  |  | Week 2 |  |  |  | Week 3 |  |  |  | Week 4 |  |  |  | Week 5
 | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code
 | Monday |  |  |  | 2010-01-04 00:00:00 |  |  |  | 2010-01-11 00:00:00 |  |  |  | 2010-01-18 00:00:00 |  |  |  | 2010-01-25 00:00:00
1 |  |  |  |  | AB | [NAME], [NAME] | 14-CC |  |  |  |  |  |  | Holiday
2
3
4
5
6
7
8
9
 | Tuesday |  |  |  | 2010-01-05 00:00:00 |  |  |  | 2010-01-12 00:00:00 |  |  |  | 2010-01-19 00:00:00 |  |  |  | 2010-01-26 00:00:00
1 |  |  |  |  | KD | [NAME], [NAME] | 90-CC
2
3
4
5
6
7
8
9
 | Wednesay |  |  |  | 2010-01-06 00:00:00 |  |  |  | 2010-01-13 00:00:00 |  |  |  | 2010-01-20 00:00:00 |  |  |  | 2010-01-27 00:00:00
1
2
3
4
5
6
7
8
9
 | Thursday |  |  |  | 2010-01-07 00:00:00 |  |  |  | 2010-01-14 00:00:00 |  |  |  | 2010-01-21 00:00:00 |  |  |  | 2010-01-28 00:00:00
1
2
3
4
5
6
7
8
9
 | 2010-01-01 00:00:00 |  |  |  | 2010-01-08 00:00:00 |  |  |  | 2010-01-15 00:00:00 |  |  |  | 2010-01-22 00:00:00 |  |  |  | 2010-01-29 00:00:00
1 |  | Holiday
2
3
4
5
6
7
8
9
Spreadsheet: 701859d1603972191-link-cell-data-to-venn-diagram-venn_diagram-2-
Sheet: Sheet1

Brand | Respondents | Relative Share | Chart Value | X Value | Y Value | Circle Size | Label
Coca-Cola | 912 | 1 |  | 38 | 35
Pepsi | 839 | 0.92 |  | 50 | 65
Dr Pepper | 730 | 0.8 |  | 62 | 35
Coca-Cola & Pepsi | 476
Coca-Cola & Dr Pepper | 235
Pepsi & Dr Pepper | 302
Coca-Cola & Pepsi & Dr Pepper | 156 |  | 156
Total:
Spreadsheet: 882855d1731338540-split-value-across-years-test1
Sheet: Sheet1

start date | end date | amount | 2017 | 2018
2017-04-10 00:00:00 | 2018-04-09 00:00:00 | 6000
 |  |  | number of days | total days
Start date 2017/2018 | 2017-04-10 00:00:00 | 2017-07-31 00:00:00
End date 2018/2019 | 2017-08-01 00:00:00 | 2018-04-09 00:00:00 |  | 263
Spreadsheet: 8f74780f-50cf-4ba0-98de-2147e93fb540
Sheet: Sheet1

Name | Add1 | CSZ | phone | fax | e-mail | [NAME]
EJ Prescott Inc | 162 North Main Street | [NAME], MA 01949 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
EJ Prescott Inc | 162 North Main Street | [NAME], MA 01949 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Ferguson Enterprises | 400 Lynnway | [NAME], MA 01905 | [PHONE] |  | [EMAIL] | [NAME]
[NAME] | 2 Whitman Road | Canton, MA 02021 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Metalloy Industries, Inc. | 13101 [NAME] | Alachua, FL 32615 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Stiles Co., Inc. | 922 Pleasant St | Norwood, MA 02062 | [PHONE] | [PHONE] | [EMAIL] | Sandy
TI Sales Inc. | 36 Hudson Rd | Sudbury, MA 01776 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Vellano Bros. Inc | 3 [NAME] | [NAME], MA 02379 | [PHONE] | [PHONE] | [EMAIL] | C T Eidam
[NAME] | 98 Lindberg Avenue | Methuen, MA 01844-2427 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Spreadsheet: 71029d1271778567-quotation-populate-date-from-price-list-sample-quote
Sheet: QUOTE

Quotation | Total Quote: | 2200
QTY | PART NO | [NAME] | PRICE | EXTENDED PRICE
1 | 125459 | Application Software  F/2 | 800 | 800
1 | 125461 | Server Core2Due | 1200 | 1200
1 | 125463 | Raid controller | 200 | 200
Spreadsheet: 271865d1382089747-how-to-collect-data-text-from-multiple-cell-to-one-cell-when-answer-of-a-cell-is-yes-ef506_multi_concat
Sheet: Sheet1

Name | Fees Paid |  |  | Fees Paid: | Yes
Ram | Yes
Sham | No
Geeta | Yes
Seeta | No
name_1 | No
name_2 | No
[NAME] | Yes
name_4 | Yes
name_5 | No
name_6 | Yes
name_7 | Yes
name_8 | Yes
name_9 | No
name_10 | No
name_11 | Yes
Spreadsheet: craig_dean__4380__PowervsHeatRate
Sheet: data

 |  | unit - new & clean data |  |  |  |  |  | special adjustments |  | plant data new & clean
 |  | kW | Btu/kWhr LHV |  | delta kW% | delta HR% |  | kW | Btu/kWhr | kW | Btu/kWhr LHV
E Sprint with chilling |  | 48000 | 8570 |  |  |  |  | 0 |  | 177540 | 10492
E Sprint without chilling |  | 40500 | 8957 |  |  |  |  | 0 |  |  |  | ignore this line just to calc the next line!!!!
 |  |  |  |  |  |  |  | 6000 |  |  |  | this is the CTG adjusted with the chilling kW added back in.
Sprint without chilling | HP Sprint only | 34500 | 9189 |  |  |  |  | 0
no Sprint no chilling |  | 28500 | 9400 |  |  |  |  | 0
 | Altitude | CIT | Wet Bulb | RH | output | heat rate
 | [NAME] | F | F | % | kW | Btu/kWhr LHV
S&S Guar | - | 50 |  | 0.95 | 48580 | 8570
ElectriCities | 150 | 50 |  | 0.95 | 48316 | 8570
 | 40 | 96 |  | 0.48 | 40559 | 8957
 | - | 50 |  | 0.95 | 48580 | 8570
 | - | 50 |  | 0.95 | 48580 | 8570
 | - | 50 |  | 0.95 | 48580 | 8570
 | - | 50 |  | 0.95 | 48580 | 8570
 | - | 50 |  | 0.95 | 48580 | 8570