tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 183360d1348796655-excel-bar-chart-book2
Sheet: Sheet2

 |  |  |  |  | PROCESS |  |  |  |  |  |  |  | BASIC PROCESS TIME |  |  |  |  |  |  |  |  |  | OVER TIME
 |  |  |  |  | ESTIMATED TIME
NO | RECEIVED DATE | [NAME] | QTY | PROCESSES / ACTIVITIES | START TIME | PROCESS 1 | PROCESS 2 | PROCESS 3 | PROCESS 4 | PROCESS 5 | TOTAL TIME | END TIME | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | STATUS
 |  |  |  |  | 08:30:00 | 0.5 | 0.5 | 0.5 | 2 | 3 |  |  |  |  |  |  |  | LUNCH BREAK |  |  | HIGH TEA
 |  |  |  |  | 17:00:00 | 0.5 | 1 | 0.5
 |  |  |  |  | 10:00:00 | 1 | 2 | 1 | 1
 |  |  |  |  | 11:00:00 | 5 | 2 | 0.5 | 0.3
 |  |  |  |  | 17:45:00 | 0.5 | 0.4 | 0.9 | 1 | 2
 |  |  |  |  | You can see that each process I have to change the number to become minutes and its not user friendly.
 |  |  |  |  | The formulated columns is at column L (total time)  and column M (End time).
Spreadsheet: eric_saibi__9701__010302
Sheet: Pittsburg 07

Owner Name |  | Mirant California LLC
Station Name |  | Pittsburg Power Station
Unit Name |  | Pittsburg 07
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Natural Gas
Capacity |  | 751 MW
Start Date |  | 2002-01-03 00:00:00
End Date |  | 2002-01-10 00:00:00
Comments |  | Unit is down with boiler leak
SIC |  | 4931
Plant ID |  | 1507901
Unit ID |  | 1004745
Outage ID |  | 19355
Spreadsheet: 08d84c5b-853e-47f0-9861-53302465f1a8
Sheet: April

FEDERAL COLLEGE WORK-STUDY PROGRAM
 | MASTER SHEET FOR STUDENT WORK HOURS
NAME |  |  |  |  |  |  |  | ASU ID #
PAY PERIOD BEGINNING |  |  | 2013-04-01 00:00:00 |  |  |  |  | PAY PERIOD ENDING |  |  | 2013-04-30 00:00:00
HOURLY RATE |  |  | 7.25 |  | TOTAL Hours |  |  |  |  | DEPARTMENT
TIME
WORKED | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
IN
OUT
IN
OUT
IN
OUT
TOTAL
TIME
WORKED | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
IN
OUT
IN
OUT
IN
OUT
TOTAL
Student's Signature
Supervisor's Name (Print) |  |  |  |  |  |  |  |  | [NAME]'s Signature
Department Head's  Name (Print) |  |  |  |  |  |  |  |  | Department Head's Signature
Note:  This Master [NAME] should reflect the time and hours the student actually worked.  The total hours per day should reflect in the total column.
Students are not authorized to work no more than 20 hours per week.  No EXCEPTIONS!!!
Spreadsheet: ef3ebf13-0c35-4372-b5cf-4cafd49bbd1d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Residential Construction
 |  | Housing Units Completed: United States
 |  | Seasonally Adjusted Total Units [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: September 1, 2014 (5:35 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008
2009
2010
2011
2012
Spreadsheet: 685269d1593867925-profit-and-revenue-sharing-revenue
Sheet: Sheet1

 |  |  | NetIncome | 100000
Emp | Points | Percentage of Sharing | Distribution |  |  | [NAME] | Percentage of Sharing
Emp1 | 4 |  |  |  |  | 1 | 0.05
Emp2 | 4 |  |  |  |  | 2 | 0.07
Emp3 | 3 |  |  |  |  | 3 | 0.09
Emp4 | 4 |  |  |  |  | 4 | 0.1
Emp5 | 2 |  |  |  |  | 5 | 0.12
Emp6 | 3
Emp7 | 2
[NAME] | 1
Emp9 | 2
Emp10 | 3
Emp11 | 2
Emp12 | 2
Emp13 | 1
Emp14 | 1
 | Total
Spreadsheet: 300502d1393495306-search-and-match-between-2-sheets-new-microsoft-excel-worksheet
Sheet: Sheet2

AUToGLYM
AUTOSHEEN | 21SH005D
QUICK DETAILER | 21QD0250
FABRIC PROTECTOR | xca2510w
ODOUR REMOVER | XBF1524W
BEADING RESTORER | XEG646Q
LEATHER TREATMENT | 21LC1000
BASF
DARK GLAZE | DD5948P
LIGHT GLAZE | DD22041
[NAME] REMOVER | DD56225
G3 POLISH | DD66556
WAX TOP
WHITE MOP
BLACK MOP
P2000 SANDING PAPER
REDUCER
CLEARCOAT
HARDENER
RACING ADDITIVE
[NAME]
TAR REMOVER
Spreadsheet: 71168d1271872476-vlookup-solution2
Sheet: Sheet1

Title-1 | Title-1 | x | a
Title-1 | Title-2 | y | b
Title-1 | Title3 | z | c
Title-2
Title-2
Title3
Title3
Title3
Title-1
Title-1
Title-1
Title-2
Title-2
Title3
Title3
Title3
Spreadsheet: 136392d1326602135-excel-2008-how-to-count-and-or-sum-consecutive-values-on-a-range-with-blank-data-in-the-middle-consecutive-values
Sheet: Consecutive

 | 2007-01-01 00:00:00 | 100 | W
 | 2007-01-02 00:00:00 | 100 | W
 | 2007-01-03 00:00:00 | 100 | W
 | 2007-01-04 00:00:00 |  | 0
 | 2007-01-05 00:00:00 |  | 0
 | 2007-01-06 00:00:00 |  | 0
 | 2007-01-07 00:00:00 |  | 0
 | 2007-01-08 00:00:00 |  | 0
 | 2007-01-09 00:00:00 |  | 0
 | 2007-01-10 00:00:00 | 100 | W
 | 2007-01-11 00:00:00 | 100 | W
 | 2007-01-12 00:00:00 | 100 | W | 6 | 600
 | 2007-01-13 00:00:00 | -50 | L
 | 2007-01-14 00:00:00 | -50 | L
 | 2007-01-15 00:00:00 | -50 | L
 | 2007-01-16 00:00:00 | -50 | L
 | 2007-01-17 00:00:00 | -50 | L
 | 2007-01-18 00:00:00 |  | 0
 | 2007-01-19 00:00:00 |  | 0
 | 2007-01-20 00:00:00 |  | 0
 | 2007-01-21 00:00:00 | -50 | L | 6 | -300
 | 2007-01-22 00:00:00 | 200 | W
 | 2007-01-23 00:00:00 | 200 | W
 | 2007-01-24 00:00:00 | 200 | W | 3 | 600
 | 2007-01-25 00:00:00 | -100 | L
 | 2007-01-26 00:00:00 | -100 | L
 | 2007-01-27 00:00:00 | -100 | L | 3 | -300
Spreadsheet: 478236d1472690911-attendance-sheet-how-to-best-summarise-data-timeclock-2
Sheet: Sheet4

Row Labels | Max of Time
[NAME]
2016-08-29 00:00:00
In | 08:00:00
Out | 09:00:00
29/08/2016 Total | 09:00:00
2016-08-30 00:00:00
In | 08:00:00
Out | 09:00:00
30/08/2016 Total | 09:00:00
2016-08-31 00:00:00
In | 12:00:00
Out | 14:00:00
31/08/2016 Total | 14:00:00
2016-09-01 00:00:00
In | 06:30:00
Out | 15:30:00
1/09/2016 Total | 15:30:00
Clinton Total | 15:30:00
[NAME] | 14:00:00
[NAME] | 21:00:00
Spreadsheet: 152357d1335362552-countif-based-on-three-criteria-fy12-po-metrics
Sheet: Comparison

 | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Overall Total | FY11 | FY12 | FY11 vs. FY12 | FY11 Ave. | FY12 Ave. | Overall Ave. | YTD %
Closed PO | 0 | 8 | 8 | 2 | 1 | 6 | 6 | 9 | 17 | 3 | 2 |  | 5 | 3 | 5 | 7 | 5 | 3 | 4 | 10 | 8
Changes To PO | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 2 | 1 | 1 | 1 | 0
Decrease PO | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 0 | 5 |  | 5 | 0 | 2 | 5 | 0 | 0 | 0 | 0 | 0
Denied Rqst | 2 | 7 | 4 | 7 | 5 | 14 | 16 | 12 | 6 | 3 | 7 | 4 | 5 | 8 | 21 | 28 | 33 | 19 | 31 | 16 | 11
Extend PO Date | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 |  | 1 | 3 | 3 | 2 | 1 | 5 | 2 | 0 | 2
Issued PO | 15 | 24 | 12 | 22 | 16 | 15 | 21 | 16 | 21 | 12 | 12 |  | 11 | 20 | 19 | 14 | 16 | 21 | 33 | 17 | 7
Increase PO | 6 | 12 | 6 | 5 | 7 | 3 | 7 | 8 | 12 | 10 | 11 |  | 9 | 6 | 9 | 9 | 6 | 9 | 7 | 5 | 4
Invoice Issues | 8 | 17 | 12 | 29 | 14 | 11 | 12 | 13 | 10 | 15 | 3 |  | 9 | 16 | 13 | 32 | 21 | 18 | 41 | 15 | 11
Total:
Spreadsheet: c87fd8ee-b6ab-4679-89de-f107a74ae36a
Sheet: Sheet1

Release: Annual Estimates of the Population for the U.S. and States, and for Puerto Rico | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=118
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-03-10 3:23 PM CDT
 | Real-Time | Period
Name: | Start | End
Annual Estimates of the Population for the U.S. and States, and for | 2004-12-22 00:00:00 | Current
Puerto Rico
Link:
http://www.census.gov/popest/ | 2004-12-22 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2004-12-22 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2004-12-22 00:00:00
2005-12-22 00:00:00
2006-12-22 00:00:00
2007-12-27 00:00:00
2008-12-19 00:00:00
2009-12-22 00:00:00
2011-02-02 00:00:00
2011-12-21 00:00:00
2012-12-20 00:00:00
2014-02-26 00:00:00
Spreadsheet: 804423d1668075051-password-generator-excel-password-genertor
Sheet: Index

Dictionary of words to collect data from | Numbers | Symbols
Red | 1 | !
House | 2 | "
 | 3 | £
 | 4 | $
 | 5 | %
List of dictionary words | 6 | &
 | 7 | *
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | to 99
Spreadsheet: 134610d1325514231-trying-to-track-names-with-days-months-and-year-s-aging-with-datedif
Sheet: Sheet1

Name | [NAME] | Client Names | Date of Entry | Days in program | Months in program | Years in program
a | 2011-01-01 00:00:00 | [NAME] | 2009-06-15 00:00:00 | 367 | 12 | 1.002739726027397 |  | 2 years 6 months 18 days
b | 2009-01-02 00:00:00 | [NAME] | 2010-12-10 00:00:00 | 1096 | 37 | 3 |  | 1 years 23 days
c | 2011-11-15 00:00:00 | [NAME] | 2011-12-29 00:00:00 | 49 | 2 | 0.1315068493150685 |  | 4 days
d | 2010-01-19 00:00:00 | [NAME] | 2010-12-29 00:00:00 | 714 | 24 | 1.953424657534247 |  | 1 years 4 days
 |  | I am specifically looking for a calculation, whereas I sumit a 'Date of Entry' it can then update each date, month, and year a client has been in the program automatically.
 |  | However, thank you for this sample and starting point Sir / Ma'am.
 |  |  |  |  | - Two calculations for calculating Months and year have been provided above, choose whichever suits you.
Spreadsheet: 752494d1634805421-combining-data-based-on-common-value-power-pivot-prices
Sheet: Sheet1

PO No | Region | Price |  | PO No | Price | Regions
12143500 | 1 | 3.66 |  | 12143500 | 3.66 | 1, 2, 4
12143500 | 2 | 3.66 |  |  | 4 | 8
12143500 | 8 | 4 |  |  | 4.2 | 24
12143500 | 4 | 3.66 |  | 58267237 | 3 | 35, 10, 23
12143500 | 24 | 4.2 |  | 84348504 | 3.66 | 99, 22, 34, 43
99897678 | 1 | 4 |  |  | 4.03 | 40
99897678 | 2 | 4 |  | 99897678 | 4 | 1, 2, 99, 88, 35
99897678 | 99 | 4
99897678 | 88 | 4
99897678 | 35 | 4
84348504 | 22 | 3.66
84348504 | 34 | 3.66
84348504 | 40 | 4.03
84348504 | 43 | 3.66
84348504 | 99 | 3.66
58267237 | 10 | 3
58267237 | 23 | 3
58267237 | 35 | 3
Spreadsheet: f08bb4c5-be70-4a3a-a677-081016c52b8d
Sheet: Sheet1

IGSSA Football Weekly Return Sheet 2012
Venue: |  |  |  | Week
PLEASE EMAIL OR FAX  AND THEN POST ORIGINAL ON SATURDAY WITH RESULT SHEETS.
[NAME] | [NAME]
Phone: | 9888 9477 |  | Mail to: LG 1  56 Delhi Road
Fax: | 9888 9277 |  | North Ryde NSW 2113
Time | Grade | Winner | [NAME] | Score
FIELD 1
8.00am
9.00am
10.00am
11.00am
FIELD 2
8.00am
9.00am
10.00am
11.00am
FIELD 3
8.00am
9.00am
10.00am
11.00am
FIELD 4
8.00am
9.00am
10.00am
11.00am
Comments:
Spreadsheet: 0d2625ef-8b4e-4785-9333-4fae8d678b80
Sheet: Sheet1

[NAME] courses in order of their importance to you. Waitlists are computer generated from primary requests only. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Sample | (LAW) | 619 | 002 | NO | 3 | Ignore
Request Number | Subject Code | Course # | Section # | Any Section? | Credits (semester hrs) | [NAME]
1st Primary
1st Alternate
2nd Primary
2nd Alternate
3rd Primary
3rd Alternate
4th Primary
4th Alternate
5th Primary
5th Alternate
6th Primary
6th Alternate
7th Primary
7th Alternate
8th Primary
8th Alternate
Spreadsheet: john_griffith__16117__1_23_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 19.5 | 203 | 218 | 53.3 | 57.2 | 0.68 | 2002-01-23 10:06:00
 | CL J2 | 19.5 | 300 | 312 | 51.9 | 54 | 0.65 | 2002-01-23 10:06:00
 | CL K2 | 19.5 | 370 | 385 | 50.1 | 52.2 | 0.63 | 2002-01-23 10:06:00
 | CL M2 | 20 | 415 | 430 | 47.4 | 49.2 | 0.61 | 2002-01-23 10:06:00
 | CL N2 | 20 | 455 | 475 | 46.1 | 48.2 | 0.59 | 2002-01-23 10:06:00
 | CL Q2 | 20 | 480 | 495 | 44.5 | 45.9 | 0.57 | 2002-01-23 10:06:00
 | CL U2 | 20 | 485 | 505 | 41.8 | 43.5 | 0.54 | 2002-01-23 10:06:00
 | [NAME] | 20 | 490 | 510 | 39.3 | 40.9 | 0.5 | 2002-01-23 10:06:00
 | CL X2 | 20 | 495 | 515 | 37.5 | 39.1 | 0.48 | 2002-01-23 10:06:00
 | [NAME] | 20.5 | 500 | 520 | 35.3 | 36.7 | 0.46 | 2002-01-23 10:06:00
 | CL F3 | 20.5 | 505 | 525 | 34.1 | 35.4 | 0.45 | 2002-01-23 10:06:00
 | CL G3 | 20.5 | 505 | 530 | 32.7 | 34.4 | 0.43 | 2002-01-23 10:06:00
 | CL M3 | 20.5 | 520 | 550 | 29.7 | 31.4 | 0.39 | 2002-01-23 10:06:00
 | CL Z3 | 20.5 | 530 | 555 | 26.4 | 27.7 | 0.35 | 2002-01-23 10:06:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 822022d1679058564-array-like-formula-to-create-combinations-book1
Sheet: Sheet1

Dep. Codes |  | Program Codes |  |  | Account Codes
2022 |  | 2022 |  |  | 2022
121 |  | 1206 |  |  | 5065
121 | 123 | 1206
121 |  | 1206 |  |  | 5000
121 |  | 1206 |  |  | 5010
121 |  | 1206 |  |  | 5020
121 |  | 1206
121 |  | 1206
121 |  | 1210 |  |  | 5070
121 | 150 | 1206 |  |  | 5180
121 |  | 1206 |  |  | 5030
121 |  | 1206
121 |  | 1206
121 | 175 | 1206 |  |  | 5090
121 |  | 1206 |  |  | 5110 | 5111
121 |  | 1206 |  |  | 5165
121 |  | 1206
121 |  | 1206 |  |  | 5130 | 5120
121 |  | 1206
Spreadsheet: 288948d1389357571-sorting-question-trying-to-force-a-row-of-data-to-apper-in-the-wrong-sort-location-excelforumsupersort-2014-01-10-07-34
Sheet: Similar Start Values

 |  |  | Production ID | ProjectID | Start | Super Sort
 |  |  |  | 4 | 12 | 12
 |  |  |  | 2 | 14 | 14
 |  |  |  | 7 | 16 | 16
 |  |  |  | 15 | 23 | 23
 |  |  | 5 | 1 | 88 | 88
 |  |  |  | 8 | 88 | 88
 |  |  |  | 12 | 88 | 88
 |  |  |  | 5 | 88 | 88.1
 |  |  | 14 | 9 | 91 | 91
 |  |  |  | 14 | 1 | 91.1
 |  |  |  | 10 | 115 | 115
 |  |  |  | 11 | 123 | 123
 |  |  |  | 13 | 236 | 236
 |  |  |  | 6 | 458 | 458
 |  |  |  | 3 | 498 | 498
 |  |  | But when there are other projects with non unique start times (column F) it does not put them in the right spot.  And it won't because 88.1 will never be smaller than  88.  So is there another way I can use a formula to trick sort to get the row of data in column E that is represented by ID 5 to appear emmediatly under ID 1?
Spreadsheet: 773611d1647955948-function-for-count-out-of-spec-test-demo
Sheet: Sheet1

 |  |  |  |  | OUT OF SPEC POINT COUNTER:
 | POINT | SPEC |  |  | SPEC MIN | SPEC MAX | RESULT1 | RESULT2 | RESULT3...
 | 1 |  | A |  | 0.5 | 1.5 | 1.1 | 1.6
 | 2 |  | A |  | 0.5 | 2.2 | 1.5 | 1.4
 | 3 |  | A |  | 1.2 | 1.5 | 2.5 | 1.3
 | 4 |  | A |  | 0.8 | 1.5 | 2.1 | 2.2
 | 5 |  | A |  | 0.5 | 2.5 | 1.5
 | 6 |  | A |  | 0.2 | 1.5 | 1.2 | 1.6
 | 7 |  | A |  | 1.2 | 1.5 | 2.5 | 1.3
 | 1~7 TTL |  |  |  | 0.8 | 1.5 | 1.4 | 2.1
 | 8 |  | B |  | 0.5 | 2.5 | 1.1 | 1.6
 | 9 |  | B |  | 0.2 | 1.5 | 1.4 | 1.4
 | 10 |  | B |  | 1.2 | 1.5 |  | 1.3
 | 11 |  | B |  | 1.2 | 1.5 | 2.1 | 2.2
 | 12 |  | B |  | 0.8 | 1.5 | 1.2 | 2.1
 | 13 |  | B |  | 1.2 | 1.5 | 1.2 | 1.6
 | 14 |  | B |  | 0.8 | 1.5 | 2.5 | 1.3
 | 8~14 TTL |  |  |  | 0.5 | 2.5 | 2.8 | 1.5
Spreadsheet: joe_parks__14535__margas1
Sheet: Sheet1

 |  | Purchased | Sold | price | Total | paid
2002-03-01 00:00:00 | x | 25000 |  | 2.55 |  | 111600
2002-03-02 00:00:00 | x | 15000 |  | 2.48 |  | x
2002-03-03 00:00:00 | x | 15000 |  | 2.48 |  | x
2002-03-04 00:00:00 | x | 15000 |  | 2.48 |  | x
2002-03-05 00:00:00 | x | 15000 |  | 2.56 |  | 187500
2002-03-06 00:00:00
2002-03-07 00:00:00 |  |  | -20000 | 2.31
2002-03-08 00:00:00 |  | 20000 |  | 2.6
2002-03-09 00:00:00 |  | 20000 |  | 2.715
2002-03-10 00:00:00 |  | 20000 |  | 2.715
2002-03-11 00:00:00 |  | 20000 |  | 2.715 |  | 128450
2002-03-12 00:00:00 |  | 20000 |  | 2.82
2002-03-13 00:00:00
2002-03-14 00:00:00
2002-03-15 00:00:00
2002-03-16 00:00:00
2002-03-17 00:00:00
2002-03-18 00:00:00
2002-03-19 00:00:00
2002-03-20 00:00:00
2002-03-21 00:00:00
2002-03-22 00:00:00
2002-03-23 00:00:00
2002-03-24 00:00:00
2002-03-25 00:00:00
2002-03-26 00:00:00
2002-03-27 00:00:00
2002-03-28 00:00:00
2002-03-29 00:00:00
2002-03-30 00:00:00
2002-03-31 00:00:00
Spreadsheet: 151015d1334759920-dynamic-named-range-question-offset-forum-version
Sheet: AMPh

[Links]
Link Data
RECORDNAME | INTID | NB | SB | EB | WB
Up ID | 30 | 4 | 851 | 1 | 2
Lanes | 30 | 4 | 4 | 2 | 2
Name | 30
Distance | 30 | 2276 | 1546 | 502 | 634
Speed | 30 | 55 | 45 | 40 | 40
Time | 30 | 28.2 | 23.4 | 8.6 | 10.8
Grade | 30 | 0 | 0 | 0 | 0
Median | 30 | *37 | *37 | 12 | 12
Offset | 30 | 0 | 0 | 0 | 0
TWLTL | 30 | 0 | 0 | 0 | 0
Crosswalk Width | 30 | 30 | 30 | 30 | 30
Mandatory Distance | 30 | 541 | 541 | 541 | 541
Mandatory Distance2 | 30 | 2421 | 1980 | 1761 | 1761
Positioning Distance | 30 | 1614 | 1320 | 1174 | 1174
Positioning Distance2 | 30 | 3228 | 2640 | 2348 | 2348
[NAME] | 30 |  | 1894868
Curve Pt Y | 30 |  | 1107715
Curve Pt Z | 30 |  | 0
[Timeplans]
Timing Plan Settings
RECORDNAME | INTID | DATA
Control Type | 30 | 3
Cycle Length | 30 | 130
Lock Timings | 30 | 0
Referenced To | 30 | 1
Reference Phase | 30 | 206
Offset | 30 | 34
Master | 30 | 0
Yield | 30 | 0
[NAME] 0 | 30 | 30
[NAME] 1 | 30 | 0
Spreadsheet: 123701d1317814495-excel-2007-conditioned-vlookup-look-to-1-sheet-if-not-a-certain-value-look-to-sheet-2-sample-tcn-sheet
Sheet: GroupExtract

 |  |  |  |  |  |  |  |  |  |  |  | Users
5 | PS CU | 44 | 2011-08-31 00:00:00 | 23 | Advanced Charting | 2011-04-29 14:14:06 | 2045-01-01 00:00:00 |  | 40545 | 70697 | 1918984 | 7 | 1
6 | CU LLC | 44 | 2011-08-31 00:00:00 | 18 | Enhanced Reporting - Lite | 2009-03-19 00:00:00 | 2045-12-31 00:00:00 |  | 93640 | 245385 | 3140499 | 1 | 15
Spreadsheet: 100535d1298899662-add-letters-to-numbers-in-column-b-book3_sem
Sheet: Sheet2

01 02 38
01 03 10
01 04 17
01 05 24
01 06 16
01 07 36
01 08 15
01 09 14
01 11 26
01 12 30
01 13 25
01 18 37
01 19 21
01 20 29
01 22 31
01 23 28
01 27 39
01 32 35
01 33 34
02 03 34
02 04 25
02 05 06
02 07 15
02 08 23
02 09 12
02 10 37
02 11 39
02 13 35
02 14 18
02 16 27
02 17 33
02 19 24
02 20 36
02 21 28
02 22 29
02 26 30
02 31 32
03 04 35
03 05 32
03 06 08
03 07 12
03 09 24
03 11 14
03 13 16
03 15 33
03 17 18
03 19 27
03 20 30
03 21 38
03 22 36
03 23 29
03 25 31
03 26 37
03 28 39
04 05 27
04 06 29
04 07 39
04 08 14
04 09 36
04 10 18
04 11 22
04 12 34
04 13 30
04 15 28
04 16 19
04 20 32
04 21 33
04 23 37
04 24 38
04 26 31
05 07 30
05 08 10
05 09 38
05 11 23
05 12 35
05 13 28
05 14 33
05 15 18
05 16 31
05 17 26
05 19 39
05 20 22
05 21 36
05 25 37
05 29 34
06 07 32
06 09 33
06 10 27
06 11 34
06 12 28
06 13 37
06 14 39
06 15 17
06 18 30
06 19 36
06 20 26
06 21 25
06 22 38
06 23 31
06 24 35
07 08 35
07 09 20
07 10 11
07 13 17
07 14 24
07 16 18
07 19 22
07 21 23
07 25 28
07 26 34
07 27 33
07 29 31
07 37 38
08 09 29
08 11 31
08 12 22
08 13 33
08 16 20
08 17 30
08 18 36
08 19 26
08 21 27
08 24 25
08 28 32
08 34 38
08 37 39
09 10 19
09 11 37
09 13 15
09 16 26
09 17 21
09 18 39
09 22 32
09 23 35
09 25 27
09 28 34
09 30 31
10 12 24
10 13 32
10 14 16
10 15 25
10 17 28
10 20 21
10 22 33
10 23 30
10 26 36
10 29 35
10 31 34
10 38 39
11 12 33
11 13 19
11 15 38
11 16 36
11 17 32
11 18 20
11 21 29
11 24 28
11 25 35
11 27 30
12 13 36
12 14 17
12 15 32
12 16 38
12 18 26
12 19 23
12 20 31
12 21 37
12 25 39
12 27 29
13 14 27
13 18 38
13 20 34
13 21 26
13 22 23
13 24 29
13 31 39
14 15 26
14 19 32
14 20 23
14 21 31
14 22 35
14 25 38
14 28 29
14 30 36
14 34 37
15 16 23
15 19 29
15 20 39
15 21 30
15 22 27
15 24 34
15 31 36
15 35 37
16 17 29
16 21 35
16 22 25
16 24 33
16 28 37
16 30 34
16 32 39
17 19 31
17 20 24
17 22 37
17 23 39
17 25 34
17 27 38
17 35 36
18 19 28
18 21 22
18 23 34
18 24 31
18 25 32
18 27 35
18 29 33
19 20 25
19 30 37
19 33 38
19 34 35
20 27 37
20 28 38
20 33 35
21 24 39
21 32 34
22 24 26
22 28 30
22 34 39
23 24 27
23 25 36
23 26 38
23 32 33
24 30 32
24 36 37
25 26 29
25 30 33
26 27 32
26 28 35
26 33 39
27 28 31
27 34 36
28 33 36
29 30 38
29 32 37
29 36 39
30 35 39
31 33 37
31 35 38
32 36 38
Spreadsheet: 35507d1233112865-if-function-formula-needed
Sheet: Sheet1

 |  | alevgoksu | 645.31 |  | AnjamKhan
 |  | AnjamKhan | 143 |  | davideastwood
 |  | davideastwood | 445.48 |  | DharamPatel
 |  | DharamPatel | 147 |  | geshanbandaranaike
 |  | gabiecr | 156.36 |  | jaynehough
 |  | geshanbandaranaike | 457 |  | alevgoksu
 |  | [NAME] | 138.5 |  | gabiecr
 |  | [NAME] | 881.85 |  | [NAME]
 |  | BarrySimmons | 225.32
 |  | [NAME] | 341.91
 |  | jasoneurope | 278.1
 |  | jitmandalia | 944.96
 |  | joannechandler | 543.86
 |  | JulieCollier | 871
 |  | JustianMerritt | 525.6
 |  | MarkCourtney | 509.64
 |  | MatthewSmith | 296.12
 |  | [NAME] | 435.81
 |  | [NAME] | 506.4
 |  | ParryThakrar | 194.46
 |  | SandraFernandes | 410.9
 |  | SanjuSmith | 343.39
 |  | sarahharding | 457.69
 |  | SevWright | 246.6
 |  | SimonBridgers | 433
 |  | sydusa | 302
Spreadsheet: 273118d1382618324-hiding-columns-with-formulas-from-clients-invoice-spreadsheet
Sheet: ROOM ONLY

Room Only
Name | Dates | Number of Nights | Required Single Rooms |  | Single cost | Required Twin Rooms |  | Twin Cost | Required Double Rooms |  | Double Cost | Required Triple Rooms |  | Triple Cost | Required Family Rooms |  | Family Cost | Totals
joel | 8/11 - 11/11 | 3 |  | 315.6 | 0 |  | 315.6 | 0 | 1 | 315.6 | 315.6 |  | 350.67 | 0 |  | 350.67 | 0 | 315.6 | 5926.289999999999
jonatan | 7/11 - 10/11 | 2 |  | 210.4 | 0 |  | 210.4 | 0 |  | 210.4 | 0 | 1 | 233.78 | 233.78 |  | 233.78 | 0 | 233.78
magnas | 7/11 - 10/11 | 3 |  | 315.6 | 0 | 1 | 315.6 | 315.6 |  | 315.6 | 0 |  | 350.67 | 0 |  | 350.67 | 0 | 315.6
[NAME] | 8/11 - 11/11 | 3 |  | 315.6 | 0 |  | 315.6 | 0 |  | 315.6 | 0 | 1 | 350.67 | 350.67 |  | 350.67 | 0 | 350.67
torbjorn | 8/11 - 11/11 | 3 |  | 315.6 | 0 |  | 315.6 | 0 |  | 315.6 | 0 | 3 | 350.67 | 1052.01 |  | 350.67 | 0 | 1052.01
torbjorn | 8/11 - 11/11 | 3 |  | 315.6 | 0 |  | 315.6 | 0 |  | 315.6 | 0 |  | 350.67 | 0 | 1 | 350.67 | 350.67 | 350.67
[NAME] | 8/11 - 11/11 | 3 |  | 315.6 | 0 | 3 | 315.6 | 946.8000000000001 |  | 315.6 | 0 |  | 350.67 | 0 |  | 350.67 | 0 | 946.8000000000001
bjorn | 8/11 - 10/11 | 2 |  | 210.4 | 0 |  | 210.4 | 0 |  | 210.4 | 0 | 1 | 233.78 | 233.78 |  | 233.78 | 0 | 233.78
[NAME] | 8/11 - 10/11 | 2 |  | 210.4 | 0 | 1 | 210.4 | 210.4 |  | 210.4 | 0 |  | 233.78 | 0 |  | 233.78 | 0 | 210.4
[NAME] | 8/11 - 10/11 | 2 |  | 210.4 | 0 | 1 | 210.4 | 210.4 |  | 210.4 | 0 |  | 233.78 | 0 |  | 233.78 | 0 | 210.4
anders | 8/11 - 10/11 | 2 |  | 210.4 | 0 | 3 | 210.4 | 631.2 |  | 210.4 | 0 |  | 233.78 | 0 |  | 233.78 | 0 | 631.2
anders | 8/11 - 10/11 | 2 |  | 210.4 | 0 |  | 210.4 | 0 |  | 210.4 | 0 | 1 | 233.78 | 233.78 |  | 233.78 | 0 | 233.78
[NAME] | 8/11 - 10/11 | 2 |  | 210.4 | 0 | 1 | 210.4 | 210.4 |  | 210.4 | 0 |  | 233.78 | 0 |  | 233.78 | 0 | 210.4
yngve | 8/11 - 11/11 | 3 |  | 315.6 | 0 | 2 | 315.6 | 631.2 |  | 315.6 | 0 |  | 350.67 | 0 |  | 350.67 | 0 | 631.2
 |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0