tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 126358d1319650761-calendar-and-buttons-travel-calendar-example
Sheet: Oct

October 2011 Travel Calendar
Purpose | 2011-10-01 00:00:00 | 2011-10-02 00:00:00 | 2011-10-03 00:00:00 | 2011-10-04 00:00:00 | 2011-10-05 00:00:00 | 2011-10-06 00:00:00 | 2011-10-07 00:00:00 | 2011-10-08 00:00:00 | 2011-10-09 00:00:00 | 2011-10-10 00:00:00 | 2011-10-11 00:00:00 | 2011-10-12 00:00:00 | 2011-10-13 00:00:00 | 2011-10-14 00:00:00 | 2011-10-15 00:00:00 | 2011-10-16 00:00:00 | 2011-10-17 00:00:00 | 2011-10-18 00:00:00 | 2011-10-19 00:00:00 | 2011-10-20 00:00:00 | 2011-10-21 00:00:00 | 2011-10-22 00:00:00 | 2011-10-23 00:00:00 | 2011-10-24 00:00:00 | 2011-10-25 00:00:00 | 2011-10-26 00:00:00 | 2011-10-27 00:00:00 | 2011-10-28 00:00:00 | 2011-10-29 00:00:00 | 2011-10-30 00:00:00 | 2011-10-31 00:00:00 |  | #
Conference
Interview
Material pick-up
Presentation 1
Presentation 2
Project 1
[NAME]
Set-Up
Set-Up Presentation 2
Training
# Employees Out of Office
Date | 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 | 31 |  | #
Spreadsheet: 874449d1721047058-return-value-from-a-cell-in-a-range-based-on-data-validation-book1
Sheet: Sheet1

[NAME] | Currency | Site Survey Costs | On-Site Manager Local Costs | On-Site Manager All Inclusive Costs | On-Site Rate | Site Survey | City Location | 1 Camera | 2 Cameras | 3 Cameras | Cameras
 |  |  |  |  |  |  | Choose your City |  |  |  | 0
Same Day Rig | CHF | 2115 | 3075 | 5000 | Local | Yes | London | 2279.1 | 2932.3 | 3826.9 | 1
Previous Day Rig | DKK |  |  |  | All Inclusive | No | Paris | 1593.24 | 3669.28 | 4691.679999999999 | 2
 | EUR | 1715 | 2710 | 4405 | No Onsite Required |  | Barcelona | 681.5999999999999 | 1448.4 | 1661.4 | 3
 | GBP | 1455 | 2430 | 3950 |  |  | Madrid | 681.5999999999999 | 1448.4 | 1661.4
 | SEK | 22100 | 29410 | 47760 |  |  | Milan | 1008.2 | 2840 | 4402
 | USD | 2310 | 3075 | 5000 |  |  | Munich | 4068.3 | 6091.799999999999 | 8008.799999999999
 |  |  |  |  |  |  | Frankfurt | 5566.4 | 7810 | 9947.1
 |  |  |  |  |  |  | Stockholm | 9088 | 0 | 0
 |  |  |  |  |  |  | Copenhagen | 9230 | 0 | 0
Spreadsheet: 555132d1515447516-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018
Sheet: Tournament 1

 |  |  | Tournament 1
 |  |  |  |  |  |  | Player
 |  |  |  |  |  |  | Low Score
 |  |  | Player | Score
 |  |  |  | 27
 |  |  |  | 66
 |  |  |  | 56
 |  |  |  | 50
 |  |  |  | 67
 |  |  |  | 63
 |  |  |  | 34
 |  |  |  | 38
 |  |  |  | 70
 |  |  |  | 71
 |  |  |  | 44
 |  |  |  | 75
 |  |  |  | 50
 |  |  |  | 40
 |  |  |  | 54
 |  |  |  | 66
 |  |  |  | 58
 |  |  |  | 26
 |  |  |  | 54
 |  |  |  | 66
 |  |  |  | 57
 |  |  |  | 35
 |  |  |  | 39
 |  |  |  | 38
 |  |  |  | 57
 |  |  |  | 27
 |  |  |  | 30
 |  |  |  | 51
 |  |  |  | 29
 |  |  |  | 61
 |  |  |  | 68
 |  |  |  | 33
 |  |  |  | 43
 |  |  |  | 61
 |  |  |  | 51
 |  |  |  | 51
 |  |  |  | 64
 |  |  |  | 70
 |  |  |  | 75
 |  |  |  | 55
 |  |  |  | 32
 |  |  |  | 70
 |  |  |  | 30
 |  |  |  | 47
 |  |  |  | 28
 |  |  |  | 28
 |  |  |  | 57
 |  |  |  | 32
 |  |  |  | 57
 |  |  |  | 27
 |  | x | x | x
Spreadsheet: darrell_schoolcraft__7335__imball0203
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -84738 | -85300 |  |  |  |  |  |  |  | San Juan
2 | -84260 | -85300 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
3 | -85534 | -85300 |  |  |  | 2001-02-01 00:00:00 | -537 | -5933 |  | 5.62
4 | -77757 | -85300 |  |  |  | 2001-03-01 00:00:00 | -80533 | -96000 |  | 4.98
5 | -56602 | -49977 |  |  |  | 2001-04-01 00:00:00 | -819833 | -1020974 |  | 4.87
6 |  |  |  |  |  | 2001-05-01 00:00:00 |  | -1252019 |  | 3.82
7 |  |  |  |  |  | 2001-06-01 00:00:00 |  | -1589467 |  | 3.2
8 |  |  |  |  |  | 2001-07-01 00:00:00 | -2051914 | -1898771 |  | 2.77
9 |  |  |  |  |  | 2001-08-01 00:00:00 | -2021619 | -1999977 |  | 2.77
10
11
12
13
14 |  |  |  |  |  | 9/1 - 9/25
15
16
17
18
19 |  |  |  |  |  | Accumulated @ 9/25/01
20
21 |  |  |  |  |  | Equilalent volumes at 9/25/01
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | 15394.13
2002-03-12 00:00:00
CBS Volume
 |  |  | 94380
Spreadsheet: 790241d1659609752-the-2nd-lowest-positive-value-book2-hd
Sheet: Sheet1

 |  |  |  |  | P59001
-30 | P59001 | 1
-25 | P59001 | 51 |  |  |  | <-----
-3 | P59001 | 110
0 | P59001 | 30 |  |  |  | <----
15 | P59001 | 2880
91 | P59001 | 33
150 | P59001 | 20
45 | P59002 | 30
75 | P59003 | 1680
Spreadsheet: 731391d1620319770-formatting-large-numbers-to-3-figures-sample-formula
Sheet: Sheet1

 |  |  | £1,234
 |  |  | £12,345
 |  |  | £123,456
 |  |  | £1,234,567
 |  |  | £12,345,678
 |  |  | £1,456
 |  |  | £1,234,567,890
 |  |  | £12,345,678,901
 |  |  | £123,456,789,012
 |  |  | £1,234,567,890,123
 |  |  | £12,345,678,901,234
 |  |  | £123,456,789,012,345
 |  |  | £12,345,678,901,234
 |  |  | £123,456,789,012,345
Spreadsheet: 730061d1619530660-function-to-coverts-all-specific-numbers-in-a-cell-to-1-and-2-numeric-values-substitute-3-numbers
Sheet: Sheet1

 | Raw Data | Result |  | Function to convert column B data to results in column C
 | 1241335 | 1221111
 | 3344445 | 1122221
 | 1234555 | 1212111
 | 4443555 | 2221111
 | 3513245 | 1111221
 | Total 7 digits in a cell
 | in given cell function to convert:
 | 1 | remains as 1
 | 2 | remain as 2
 | 3 | converts to1
 | 4 | converts to2
 | 5 | converts to1
 | currently I use Control +  F; replace 3 to replace with  1
 | currently I use Control + F ;replace 4 to replace with 2
 | currently I use Control + F;replace 5 to replace with  1
Spreadsheet: 197671d1354522531-array-problem-non-array-version-with-index-not-offset
Sheet: TablePlan

 | Table | Seat | Guest
 | 1 | 1 | martin
 | 1 | 2
 | 1 | 3
 | 1 | 4
 | 1 | 5
 | 1 | 6
 | 1 | 7
 | 1 | 8
 | 2 | 1
 | 2 | 2
 | 2 | 3
 | 2 | 4
 | 2 | 5
 | 2 | 6
 | 2 | 7
 | 2 | 8
 | 3 | 1
 | 3 | 2
 | 3 | 3
 | 3 | 4
 | 3 | 5
 | 3 | 6
 | 3 | 7
 | 3 | 8
 | 4 | 1 | [NAME]
 | 4 | 2
 | 4 | 3
 | 4 | 4
 | 4 | 5
 | 4 | 6
 | 4 | 7
 | 4 | 8
Spreadsheet: 268996d1380910052-is-there-any-way-to-autofill-hyperlinks-puppies_help
Sheet: Pivot Table

Count of Color
Breed | Color | Gender | Total
Corgi | White | F | 1
Corgi Total |  |  | 1
German Shepard | Black | F | 1
 | [NAME] | M | 1
German Shepard Total |  |  | 2
Lab | Blonde | M | 1
Lab Total |  |  | 1
Mastif | Black | M | 1
 | [NAME] | M | 1
Mastif Total |  |  | 2
[NAME] | Grey | F | 1
Pug Total |  |  | 1
Grand Total |  |  | 7
Spreadsheet: 438148d1451788871-trouble-deleting-duplicates-shipment-calculation
Sheet: Shipment Calculations

Shipment Calculations
Units Shipment | Shipment Staff | Backstock Staff
1000
1100
1200
1300
1400
1500
1600
1700
1800
1900
2000
2100
2200
2300
2400
2500
2600
2700
2800
2900
3000
3100
3200
3300
3400
3500
3600
3700
3800
3900
4000
4100
4200
4300
4400
4500
4600
4700
4800
4900
5000
5100
5200
5300
5400
5500
5600
5700
5800
5900
6000
Spreadsheet: 0ef4e4f2-f093-4f3d-a46d-8aa3b02c29d0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-04-22 09:25:08.900000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.765 | 102.64 | 102.515 | 102.14 |  | and are added to price quote
4.625 | 101.979 | 101.854 | 101.729 | 101.354
4.5 | 101.046 | 100.921 | 100.796 | 100.421 |  | Note: | Refer To Price [NAME]
4.375 | 100.233 | 100.108 | 99.983 | 99.608 |  |  | For all Price Adjs
4.25 | 99.637 | 99.512 | 99.387 | 98.762
4.125 | 98.769 | 98.644 | 98.519 | 97.894
4 | 97.73 | 97.605 | 97.48 | 96.855
3.875 | 96.665 | 96.54 | 96.415 | 95.79
3.75 | 95.79 | 95.665 | 95.54 | 94.915
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.274 | 102.149 | 102.024 | 101.649
3.75 | 101.785 | 101.66 | 101.535 | 101.16
3.625 | 101.381 | 101.256 | 101.131 | 100.756
3.5 | 100.826 | 100.701 | 100.576 | 100.201
3.375 | 100.096 | 99.971 | 99.846 | 99.221
3.25 | 99.345 | 99.22 | 99.095 | 98.47
3.125 | 98.703 | 98.578 | 98.453 | 97.828 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-05-06 09:25:08.900000
30 DAY | 2014-05-21 09:25:08.900000
45 DAY | 2014-06-05 09:25:08.900000
60 DAY | 2014-06-20 09:25:08.900000
90 DAY | 2014-07-20 09:25:08.900000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 1cad9d96-712a-4350-ab6b-a8ad67cc762b
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
AMPCS | Test | AMPCS | AMPA-Receptor Antibody by CBA, Serum | AMPA-R Ab CBA, Serum | Cell-binding assay (CBA) detects IgG specific for 2 amino-3 (5-methyl 3 oxo-1,2 oxazole 4 yl) propanoic acid receptor (AMPA-R) by indirect immunofluorescence (IFA) |  |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL Additional Information: Include relevant clinical information, name, phone number, mailing address, and E-mail address (if applicable) of ordering physician. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK  Lipemia	Mild OK; Gross reject Icterus	Mild reject; Gross reject Other	NA | Negative | Wednesday, Friday; 8 a.m. | Negative: 2-4 days; Positive: 5-7 days | 6 days | 1 | 86255 |  |  |  |  | Rochester
AMPCS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
AMPCS | Result | 61518 | AMPA-R Ab CBA, Serum | AMPA-R Ab CBA, Serum | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 111328d1307710584-summarising-data-from-multiple-worksheets-cashbook-sample
Sheet: Pivot Table Reports

EXPENDITURE
Cost Centre | _SE2011
Sum of Total invoice amount
Row Labels | Total
Accommodation | 835.9200000000001
Guest accommodation | 835.9200000000001
Travelodge | 835.9200000000001
Photography | 300
Story Engine | 300
[NAME] | 300
Grand Total | 1135.92
Spreadsheet: 330283d1404681117-formula-if-help-for-a-schedule-schedule-template-wip
Sheet: Personal Time Sheet

 | Weekly Schedule |  |  |  |  |  |  | #
 | Day of The Week | Thursday | Friday | Saturday | Monday | Tuesday | Wednesday | Weekly Totals
 | In
 | Out
 | Lunch |  |  | -
 | Coverage |  |  |  |  |  |  | Total Hours
 | Coverage
 | General [NAME]
 | Total Hours
 | Weekly Schedule |  |  |  |  |  |  | Weekly Totals
 | Day of The Week | Thursday | Friday | Saturday | Monday | Tuesday | Wednesday
 | In
 | Out
 | Lunch |  |  | -
 | Coverage |  |  |  |  |  |  | Total Hours
 | Coverage
 | General [NAME]
 | Total Hours
 | Enter the # beside your name from the timesheet into cell I2; this sheet will automatically enter your info.
 | You can print this whole page in landscape view.
Spreadsheet: 93431d1293013201-dependent-drop-down-list-book123
Sheet: Sheet1

[NAME] | REGION | PROVINCE
PNH1 | C1 | PNH
PNH2 | C1 | PNH
PNH3 | C1 | PNH
PNH4 | C1 | PNH
KDL1 | C2 | KDL
KDL2 | C2 | KDL
KDL3 | C2 | KDL
[NAME] | NE | KCM
KCM2 | NE | KCM
KCM3 | NE | KCM
KCM4 | NE | KCM
KCM5 | NE | KCM
KCM6 | NE | KCM
KRT1 | NE | KRT
KRT2 | NE | KRT
KRT3 | NE | KRT
[NAME] | NE | KRT
KRT5 | NE | KRT
KRT6 | NE | KRT
KRT7 | NE | KRT
[NAME] | NE | KRT
Spreadsheet: phillip_m_love__30153__9904_OA
Sheet: TX-CON-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM) / HPL
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  |  |  |  |  | June |  |  |  |  |  | September |  |  |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | June |  | August |  |  |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-South Texas
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 177453d1346317109-drop-down-list-hyperlink-to-sheets-in-another-workbook-master-plan
Sheet: Cabinet

 | No. | Code | Supplier | Brand | Description |  | This Master Plan workbook contains 3 sheets and each sheets link to its own workbook. Whenever I want to edit the Master Plan, I just click the drop down menu and it will hyperlink to the exact sheet in the exact workbook
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | until 500
Spreadsheet: 175664d1345602797-ignore-blank-cells-ignore-blank-cells
Sheet: Data Sheet

Cost of Sale | Hours | Amount | FICA | Medicare | FUTA | SUTA - 3.2% plus Interest  @ $12.12 Each Employee over $13,000 | Group Ins @  % of Cost | W/C | Total
Cost of Sale | 45 |  |  |  |  |  | 75
Marketing
Repair | 45 |  |  |  |  |  | 75
Utility
Total
Spreadsheet: 110199d1306936713-summing-and-counting-data-book2
Sheet: Sheet1

account | product | $ |  |  |  |  | Data
1 | a | 5 |  |  |  | product | Count of account | Sum of $
2 | a | 10 |  |  |  | a | 3 | 30
3 | a | 15 |  |  |  | b | 2 | 50
1 | b | 20 |  |  |  | Grand Total | 5 | 80
3 | b | 30
Spreadsheet: sara_shackleton__36364__PHONE_LIST
Sheet: ext. Rio office

[NAME] do [NAME]. |  |  |  |  | [NAME] do [NAME].
RIO DE JANEIRO OFFICE |  |  |  |  | RIO DE JANEIRO OFFICE
Av. [NAME], 01 - 9º andar/setor A - 20090-003 - Rio de Janeiro - Brasil                                          Tel. 55 21 550 -8870    Fax. 55 21 550-8888 |  |  |  |  | Av. [NAME], 01 - 9º andar/setor A - 20090-003                                                                                  Rio de Janeiro - Brasil      Tel. 55 21 550 -8870    Fax. 55 21 550-8888
 | STAFF & SUPPORT TELEPHONE |  |  |  | STAFF & SUPPORT TELEPHONE
NAME | DEPARTMENT | EXTENSION | FLOOR |  | CONFERENCE ROOM
[NAME] | Administrative | 3036 | 9th |  |  | Conference Room 9C1 | 3032
Andréa Gavino | Administrative | 3029 | 9th |  |  | Conference Room 9C2 | 3033
[NAME] | Administrative | 3011 | 9th |  |  | Conference Room 9C3 | 3017
[NAME] | Associate | 3012 | 9th
Fernanda Figueiredo | Administrative | 3020 | 9th |  | RECEPTION
[NAME] | Operations | 3021 | 9th |  |  | [NAME] | 3026
[NAME] | Administrative | 3026 | 9th |  |  | Visitors | 3022
[NAME] | Origination | 3045 | 9th
[NAME] | Origination | 3015 | 9th |  | FAXES
[NAME] | Legal | 3027 | 9th |  |  | Office | 550-8888
[NAME] | Regional Director | 3013 | 9th |  |  | [NAME] | 550-8887
[NAME] | Administrative | 3041 | 9th |  |  | Legal | 550-8886
Nanci Sampaio | Administrative | 3016 | 9th
[NAME] | Finance | 3019 | 9th |  | CELL PHONES
Orlando Puppin | Executive Staff | 3014 | 9th |  |  | [NAME] | 021 9967-9688
[NAME] | Legal | 3034 | 9th |  |  | [NAME] | 021 9648-6308
[NAME] | Executive Staff | 3010 | 9th |  |  | [NAME] | 021 9648-6311
[NAME] | Operations | 3028 | 9th |  |  | Nanci Sampaio | 021 9948-3911
Rodrigo Benevides | Systems | 3044 | 9th |  |  | Valéria Amoroso Lima | 021 9649-5649
[NAME] | Administrative | 3041 | 9th |  |  | [NAME] | 021 9648-6303
Valéria Amoroso Lima | Finance | 3040 | 9th
[NAME] | Legal | 3025 | 9th
Spreadsheet: 153584d1335967696-generate-data-from-another-sheet-john-book1
Sheet: Customers Sheet

Part | Qty | Price | Total
A001 | 46
A002 | 25
A010 | 44
A011 | 51
A012 | 8
A017 | 22
A018 | 10
A019 | 8
A020 | 49
A021 | 42
A022 | 22
Spreadsheet: 454671d1459939543-subtract-from-a-fixed-value-cycle-rower
Sheet: Sheet1

DATE | ROWING | CYCLING
 | MINUTES | MINUTES | [NAME] | [NAME] | 500
2016-04-02 00:00:00 |  | 53.13 | 6.3 | 500 | 493.7
2016-04-03 00:00:00 |  | 54.19 | 6.5 | 493.7 | 487.2
2016-04-04 00:00:00 | 30 |  |  | 487.2 | 487.2
2016-04-05 00:00:00 |  | 1.22 | 11.2 | 487.2 | 476
2016-04-06 00:00:00 |  |  |  | 476 | 476
2016-04-07 00:00:00 |  |  |  | 476 | 476
2016-04-08 00:00:00 |  |  |  | 476 | 476
2016-04-09 00:00:00 |  |  |  | 476 | 476
2016-04-10 00:00:00 |  |  |  | 476 | 476
2016-04-11 00:00:00 |  |  |  | 476 | 476
2016-04-12 00:00:00 |  |  |  | 476 | 476
2016-04-13 00:00:00 |  |  |  | 476 | 476
2016-04-14 00:00:00 |  |  |  | 476 | 476
2016-04-15 00:00:00 |  |  |  | 476 | 476
2016-04-16 00:00:00 |  |  |  | 476 | 476
2016-04-17 00:00:00 |  |  |  | 476 | 476
2016-04-18 00:00:00 |  |  |  | 476 | 476
2016-04-19 00:00:00 |  |  |  | 476 | 476
2016-04-20 00:00:00 |  |  |  | 476 | 476
2016-04-21 00:00:00 |  |  |  | 476 | 476
2016-04-22 00:00:00 |  |  |  | 476 | 476
2016-04-23 00:00:00 |  |  |  | 476 | 476
2016-04-24 00:00:00 |  |  |  | 476 | 476
2016-04-25 00:00:00 |  |  |  | 476 | 476
2016-04-26 00:00:00 |  |  |  | 476 | 476
2016-04-27 00:00:00 |  |  |  | 476 | 476
2016-04-28 00:00:00 |  |  |  | 476 | 476
2016-04-29 00:00:00 |  |  |  | 476 | 476
2016-04-30 00:00:00 |  |  |  | 476 | 476
2016-05-01 00:00:00 |  |  |  | 476 | 476
2016-05-02 00:00:00 |  |  |  | 476 | 476
2016-05-03 00:00:00 |  |  |  | 476 | 476
2016-05-04 00:00:00 |  |  |  | 476 | 476
2016-05-05 00:00:00 |  |  |  | 476 | 476
2016-05-06 00:00:00 |  |  |  | 476 | 476
2016-05-07 00:00:00 |  |  |  | 476 | 476
2016-05-08 00:00:00 |  |  |  | 476 | 476
2016-05-09 00:00:00 |  |  |  | 476 | 476
2016-05-10 00:00:00 |  |  |  | 476 | 476
2016-05-11 00:00:00 |  |  |  | 476 | 476
2016-05-12 00:00:00 |  |  |  | 476 | 476
2016-05-13 00:00:00 |  |  |  | 476 | 476
2016-05-14 00:00:00 |  |  |  | 476 | 476
2016-05-15 00:00:00 |  |  |  | 476 | 476
2016-05-16 00:00:00 |  |  |  | 476 | 476
2016-05-17 00:00:00 |  |  |  | 476 | 476
2016-05-18 00:00:00 |  |  |  | 476 | 476
2016-05-19 00:00:00 |  |  |  | 476 | 476
2016-05-20 00:00:00 |  |  |  | 476 | 476
2016-05-21 00:00:00 |  |  |  | 476 | 476
2016-05-22 00:00:00 |  |  |  | 476 | 476
2016-05-23 00:00:00 |  |  |  | 476 | 476
2016-05-24 00:00:00 |  |  |  | 476 | 476
2016-05-25 00:00:00 |  |  |  | 476 | 476
2016-05-26 00:00:00 |  |  |  | 476 | 476
2016-05-27 00:00:00 |  |  |  | 476 | 476
2016-05-28 00:00:00 |  |  |  | 476 | 476
2016-05-29 00:00:00 |  |  |  | 476 | 476
Spreadsheet: 853974d1703933469-calculating-annual-totals-of-various-cells-columns-annualtotals-aligw
Sheet: Annual Summary

 | YEAR | 2023 |  | Manually Calculated Results for 2023
 | [NAME] |  |  | 12405.48
 | Delays |  |  | 644
 | Moves | Which column are moves? |  | 512
 |  | Number of instances by year | [NAME]
 | EMU
 | DL
 | DLR
 | DMU
 | EL
 | EDL
 | MON
 | Misc
 | SL
 | Tram
 | Tube
 | TOC | Number of Instances by year | [NAME] | Delays
 | CS
 | DSR
 | EL
 | EM
 | EMR
 | GA
 | GC
 | GN
 | GR
 | GW
 | GX
 | LE
 | LO2
 | LUL
 | ME
 | Misc
 | NT
 | NVR
 | RHD
 | SBN
 | SE
 | SN
 | SR
 | SW
 | TfW
 | TL
 | TML
 | TP
 | Tube
 | VT
 | VT3
 | WM
 | XC
Spreadsheet: 777694d1650554425-count-blank-cells-in-binary-data-s-table-blank-cells
Sheet: Feuil1

datas
 |  | Numbers of consecutives blanks cells | frequency
 |  |  | 1 | -1
-1 |  | 0
 |  | 1
1 |  | 2
 |  | 3
 |  | 4
 |  | 5
-1 |  | 6
1 |  | 7
-1 |  | 8
 |  | 9
 |  | 10
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
Spreadsheet: 35612d1233190606-using-vlookup-to-reference-columna-and-b-to-report-an-amount-in-columnc-excelforum
Sheet: Sheet1

from | to | miles | date | reason
location1 | location2 |  | 2009-01-28 00:00:00 | store visit
location1 | location3 |  | 2009-01-28 00:00:00 | manager review
location2 | location3 |  | 2009-01-28 00:00:00 | meeting with client
from | to | miles
location1 | location2 | 6.8
location1 | location3 | 73.5
location1 | location4 | 3.7
location1 | location5 | 23.4
location1 | location6 | 15
location1 | [NAME] | 52
location1 | location8 | 37
location1 | location9 | 50.4
location1 | location10 | 55.6
location2 | location1 | 6.8
location2 | location3 | 17
location2 | location4 | 33
location2 | location5 | 24.1
location2 | location6 | 42.5
location2 | [NAME] | 9.1
location2 | location8 | 18.5
location2 | location9 | 29.2
location2 | location10 | 33.5
Spreadsheet: 796415d1663256647-if-and-statement-not-working-book5
Sheet: Sheet1

Visit Due Date | Has Been Visited? | Actual Visit Date | Was the actual visit within SLA
Visit Due Date | Has Been Visited? | Actual Visit Date | Visit on time |  |  |  | If visit date is not due - n/a
2022-05-31 00:00:00 |  | 2022-07-25 00:00:00 |  |  |  |  | If visited and on time - Yes
2023-04-30 00:00:00 |  |  |  |  |  |  | If visit and late - No
2023-04-30 00:00:00 |  |  |  |  |  |  | Not visited - No
2023-04-30 00:00:00 |  | 2022-04-10 00:00:00