tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 35359d1232976760-copying-hyperlinks-december-2008-excel-forum-daily-accts
Sheet: 2

 |  |  |  |  |  | 2
Total Money in the accounts
at the beginning of  23 Jan.  2009
Name of Company | Money X | Money Y | Total
Вагриус | 985.4199999999983 | 0 | 985.4199999999983 |  |  | B17 | B134 | B16 |  | C17 | C134 | C16
Вагриус книги | 1238.7 | 0 | 1238.7 |  |  | B18 | B150 | B32 |  | C18 | C150 | C32
Вагриус правда | 67683.88 | 0 | 67683.88 |  |  | B19 | B166 | B48 |  | C19 | C166 | C48
Вагриус минус | 628.08 | 0 | 628.08 |  |  | [NAME] | B182 | B64 |  | C20 | C182 | C64
Плюс-минус | 2982.36 | 0 | 2982.36 |  |  | B21 | B198 | B80 |  | C21 | C198 | C80
Издательство Вагриус | 444.69 | 0 | 444.69 |  |  | B22 | B114 | [NAME] |  | C22 | C114 | C96
Вагриус плюс-минус | 0 | 0 | 0 |  |  | B23 | B230 | B112 |  | C23 | C230 | C112
Grand Total | 73963.13 | 0 | 73963.13
Spreadsheet: 42033d1240568505-making-cell-transfers-capitals-po
Sheet: PURCHASE ORDER

PURCHASE ORDER
 |  |  |  | Purchase Order Number: |  |  |  |  |  | 66
 | TO: |  |  |  |  | Contact Name: |  |  |  | REQUIRED BY
 |  |  |  |  |  | Branch Name:
 | DATE |  | REQUISITIONER |  |  | JOB NUMBER |  | CUSTOMER NAME |  |  | TERMS
 |  |  |  |  |  |  |  |  |  |  | A/C
 | QUANTITY | UNITS | [NAME] |  |  |  |  |  |  | PRICE | TOTAL
 | N.B |  |  |  |  |  |  |  |  | Sub Total | 0
 | Please notify us immediately if you are unable to supply as specified |  |  |  |  |  |  |  |  | Delivery
 |  |  |  |  |  |  |  |  |  | VAT | 0
 |  |  |  |  |  |  |  |  |  | TOTAL | 0
 | AUTHORISED BY
 | 1900-01-01 00:00:00
Spreadsheet: 104235d1301899133-rank-function-problem-rank-problem
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Top 5 |  |  | %
Investment Name |  |  |  |  |  |  |  |  |  |  | Market Value GBP |  |  |  | Rank
xxxxx1 |  |  |  |  |  |  |  |  |  |  | 42634.4375
xxxxx2 |  |  |  |  |  |  |  |  |  |  | 50249.31506849315
total
xxxxx3 |  |  |  |  |  |  |  |  |  |  | 7440.826999999999
xxxxxx4 |  |  |  |  |  |  |  |  |  |  | 3168.6525
xxxxxx5 |  |  |  |  |  |  |  |  |  |  | 4588.35
xxxxxx6 |  |  |  |  |  |  |  |  |  |  | 2574.9712
total
Spreadsheet: 24181d1214320462-creating-a-spreadsheet-with-drop-down-menus-example-spreadsheet-1
Sheet: Sheet1

 |  | 8 Hr Day Delegate Package (Cost per delegate) |  | 24hr Residential Delegate Package (Cost per delegate) |  |  | Room Hire
 |  | Revenue Monday-Thursday | Revenue Saturday-Friday | Revenue Monday-Thursday | Revenue Friday-Sunday |  | Room 1 | Room 2 | Room 3
No. of delegates |  | 35 | 25 | 145 | 120 |  | 500 | 600 | 300
EXAMPLES BELOW |  |  |  |  |  |  |  |  |  |  | N/A
 |  |  |  |  |  |  |  |  |  |  | 8Hr Day Monday-Thursday
23 |  | 805 |  |  |  |  |  |  |  |  | 8 Hr Day Friday-Sunday
 |  |  |  |  |  |  |  |  |  |  | 24Hr Residential Monday-Thursday
23 |  |  | 575 |  |  |  |  |  |  |  | 24Hr Residential Friday-Sunday
23 |  |  |  | 3335 |  |  |  |  |  |  | N/A
 |  |  |  |  |  |  |  |  |  |  | Room1
23 |  |  |  |  | 2760 |  |  |  |  |  | Room2
 |  |  |  |  |  |  |  |  |  |  | Room3
23 |  |  |  |  |  |  | 500
23 |  |  |  |  |  |  |  | 600
23 |  |  |  |  |  |  |  |  | 300
 |  | Selected  Package: | 2 | 1
 | No. of Delegates | Package | Cost of Package | Cost of Room | Total Revenue
 | 23 |  | 0 | 0 | 0
 | 24 | 8Hr Day Monday-Thursday | 840 | 0 | 840
 |  | N/A
 | 25 |  | 0 | 0 | 0
 | 26 |  | 0 | 0 | 0
 | 27 |  | 0 | 0 | 0
 | 28 |  | 0 | 0 | 0
 | 29 |  | 0 | 0 | 0
 | 30 |  | 0 | 0 | 0
 | 31 |  | 0 | 0 | 0
 | 32 |  | 0 | 0 | 0
 | 33 |  | 0 | 0 | 0
 | 34 |  | 0 | 0 | 0
 | 35 |  | 0 | 0 | 0
Spreadsheet: 119956d1314886742-help-matching-specific-cells-with-a-hierarchy-find-macro-excel-help
Sheet: Original

Part | Part Description
EP# | 0002
107283 | BOX, ELECTRICAL, 3/4 IN, FS-FD, APPLETON ELECTRIC CO P/N FDC-1-75-A
106625 | BUMPER, FOR DOCK, P/N RH412-14 12X14X4 PROJECTION
108014 | CLAMP, BEAM, STRUT TO BEAM, ZINC PLATED, 13/16 - 1-5/8 IN STRUT, B-LINE SYSTEMS INC P/N B441-22
106613 | CONTROLLER, RAMP, ASSEMBLY, WITH BAR, FOR RITE-HITE DOCK LOK, RITE-HITE CORP P/N 503
107206 | COVER, BOX, ALUMINUM, FOR FS-FD BOX, APPLETON ELECTRIC CO P/N FSK-1B-CA
108126 | GRIP, CORD, 3/4 IN, [NAME], 0.450 - 0.500 DIAMETER, STRAIGHT, WATER/OIL TIGHT, APPLETON ELECTRIC CO P/N CG-3775
108005 | KIT, HEAT TRACE, SPLICE AND TEE, SR TRACE P/N SRST
111027 | SPRING, DOCKPLATE, FOR RITE-HITE DOCK HANDLE RETURN, P/N 52111
EP# | 0004
112090 | BODY, COUPLER, BRASS, 1/2" FPT, FOR COATER AIR PUMPS, DIXON P/N STFC4
102859 | CONNECTOR, QUICK CONNECT, 2 IN, 316 STAINLESS STEEL, FNPT, P/N 733A
102867 | CONNECTOR, QUICK CONNECT, 2 IN, FEMALE, 316 STAINLESS STEEL, OPW, HOSE SHANK
102928 | GASKET, 2 IN, 200G NEOPRENE GSKT., FOR QUICK CONNECT COUPLER P/N H1893M
102929 | HANDLE, REPAIR, FOR COUPLER, DIXON P/N 200-HRR-SP
109748 | KIT, REPAIR, FOR ARO AIR MOTOR, ARO P/N 637302
109749 | KIT, REPAIR, FOR ARO PUMP, ARO P/N 637309-AA
112089 | PLUG, COUPLER, BRASS, 1/2" MPT, FOR COATER AIR PUMPS, DIXON P/N STMP4B
111224 | SEAT, ITEM 21, FOR ARO PUMP, P/N 94328-A
102332 | VALVE, BALL, 1/2 IN, BRASS, NELES-JAMESBURY P/N 1/2 451T
EP# | 0006
107183 | CONNECTOR, CONDUIT, SEALTITE, 1/2 IN, 45 DEGREE, APPLETON ELECTRIC CO P/N ST-4550
108417 | CONNECTOR, CONDUIT, SEALTITE, 3/8 IN, STRAIGHT, APPLETON ELECTRIC CO P/N ST-38
109757 | PUMP, VACUUM, WITH MOTOR, FOR LAB BUILDING
EP# | 0007
106290 | GUN, SPRAY, SPRAYING SYSTEMS CO P/N 36533-60
Spreadsheet: 887353d1737580762-due-dates-formula-for-month-end-close-calendar-month-end-close-due-dates
Sheet: Copy

Revenue Month End Closing Schedule
 | Day - Quarter | Day | Due Date | Frequency
 | 15th | -15 |  | Monthly
 | 15th | -15 |  | Monthly
 | 20th | -20 |  | Monthly
 | D -10 to -5 | -10 |  | Monthly
 | D -10 to -5 | -5 |  | Monthly
 | D -10 to -5 | -10 |  | Quarterly
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Quarterly
 | D1 | -1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | 1 |  | Quarterly
 | D1 | 1 |  | Quarterly
 | D1 | 1 |  | Quarterly
 | D1 | 1 |  | Quarterly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | 1 |  | Quarterly
 | D 1 | 1 |  | Quarterly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D2 | 2 |  | Monthly
 | D2 | 2 |  | Monthly
 | D2 | 2 |  | Quarterly
 | D2 | 2 |  | Monthly
 | D 2 | 2 |  | Monthly
 | D 2 | 2 |  | Monthly
 | D 2 | 2 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 2 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 3 |  | Quarterly
 | D3/D4 | 4 |  | Quarterly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Quarterly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Quarterly
 | D6 | 6 |  | Monthly
 | D6 - D9 | 6 |  | Quarterly
 | D6 - D9 | 6 |  | Quarterly
 | D 6 | 6 |  | Monthly
 | D6 - D9 | 9 |  | Monthly
 | D 6 | 6 |  | Monthly
 | D6 - D9 | 8 |  | Monthly
 | D 6 | 6 |  | Monthly
 | D6 - D9 | 8 |  | Monthly
 | D 6 | 6 |  | Quarterly
 | D6 - D9 | 8 |  | Quarterly
 | D 6 | 6 |  | Quarterly
 | D 6 | 6 |  | Quarterly
 | D 8 | 8 |  | Quarterly
 | D10 | 10 |  | Quarterly
 | D10 | 10 |  | Quarterly
 | D11 | 11 |  | Monthly
 | D20+ | 20 |  | Quarterly
 | D20+ | 20 |  | Quarterly
 | D20+ | 20 |  | Quarterly
Spreadsheet: 272050d1382169650-if-cell-has-data-the-look-up-value-example-list-rovert7-191013
Sheet: Price list

Item | Price |  | Sub Total
Charm | 0.5 |  |  |  | You can make array for price list
Letter | 0.5 |  |  |  | Formulas - Define Name…
Box | 0.65 |  |  |  |  | Name | -> name for the array
Pillow | 0.85 |  |  |  |  | Scoop | -> when this array you want to use, default workbook
 |  |  |  |  |  | Refers to | -> range of array
 |  |  |  |  | For how you use it, check price on sheet Order List
Spreadsheet: 60676d1261169249-group-rows-together-during_2
Sheet: Sheet1

 |  |  | Order | Type
-------------------------- | ----------------------------------------- | ------------------- | 2 | STRUCTURAL
30578R       4/18/2003 | 1485  QUAIL RUN DR W | [NAME] | 3 | STRUCTURAL
STRUCTURAL | 54-286674-00.000 | 5501 FRANTZ RD | 4 | STRUCTURAL
ELECTRICAL | 12898 |  | 5 | STRUCTURAL
HVAC | 1 FAMILY DWELLING | DUBLIN, OH 43017- | 6 | STRUCTURAL
 | POTTERS GROVE | 0/ 2.00/ | 7 | STRUCTURAL
 | CITY OF NEWARK | 5B | 8 | STRUCTURAL
-------------------------- | ----------------------------------------- | ------------------- | 9 | ZONING
30577Z       4/3/2003 | 1485  QUAIL RUN DR W | [NAME] | 10 | ZONING
ZONING | 54-286674-00.000 | 5501 FRANTZ RD | 11 | ZONING
 | 12898 |  | 12 | ZONING
 | 1 FAMILY DWELLING | DUBLIN, OH 43017- | 13 | ZONING
 | POTTERS GROVE | 0/ 0.00/ | 14 | ZONING
 | CITY OF NEWARK |  | 15 | ZONING
-------------------------- | ----------------------------------------- | ------------------- | 16 | Z-NEW CONSTR.
10401C       7/5/2001 | 109 1 FAIRWAY DR BLDG #2 | ROCKFORD HOMES INC | 17 | Z-NEW CONSTR.
Z-NEW CONSTR. | N/A | 999 POLARIS PKWY | 18 | Z-NEW CONSTR.
 | N/A | SUITE 200 | 19 | Z-NEW CONSTR.
 | NEW 4 UNIT CONDO BLD | COLUMBUS, OH 43240 | 20 | Z-NEW CONSTR.
 | LICKING COUNTY | 4/ 1.00/ | 21 | Z-NEW CONSTR.
 | ETNA TOWNSHIP | 5B | 22 | Z-NEW CONSTR.
-------------------------- | ----------------------------------------- | ------------------- | 23 | Z-NEW CONSTR.
10403C       7/5/2001 | 109 1 NICKLAUS LN BLDG #7 | ROCKFORD HOMES INC | 24 | Z-NEW CONSTR.
Z-NEW CONSTR. | N/A | 999 POLARIS PKWY | 25 | Z-NEW CONSTR.
 | N/A | SUITE 200 | 26 | Z-NEW CONSTR.
 | NEW 4 UNIT CONDO | COLUMBUS, OH 43240 | 27 | Z-NEW CONSTR.
 | LICKING COUNTY | 4/ 1.00/ | 28 | Z-NEW CONSTR.
 | ETNA TOWNSHIP | 5B | 29 | Z-NEW CONSTR.
-------------------------- | ----------------------------------------- | ------------------- | 30 | Z-NEW CONSTR.
10407C       8/14/2001 | 109 1 PLAYER WAY BLDG #16 | ROCKFORD HOMES INC | 31 | Z-NEW CONSTR.
Z-NEW CONSTR. | N/A | 999 POLARIS PKWY | 32 | Z-NEW CONSTR.
 | N/A | SUITE 200 | 33 | Z-NEW CONSTR.
 | NEW 4 UNIT CONDO BLD | COLUMBUS, OH 43240 | 34 | Z-NEW CONSTR.
 | LICKING COUNTY | 4/ 1.00/ | 35 | Z-NEW CONSTR.
 | ETNA TOWNSHIP | 5B | 36 | Z-NEW CONSTR.
-------------------------- | ----------------------------------------- | ------------------- | 37 | Z-NEW CONSTR.
10409C       8/14/2001 | 109 1 SNEAD RD BLDG #22 | ROCKFORD HOMES INC | 38 | Z-NEW CONSTR.
Z-NEW CONSTR. | N/A | 999 POLARIS PKWY | 39 | Z-NEW CONSTR.
 | N/A | SUITE 200 | 40 | Z-NEW CONSTR.
 | NEW 4 UNIT CONDO BLD | COLUMBUS, OH 43240 | 41 | Z-NEW CONSTR.
 | LICKING COUNTY | 4/ 1.00/ | 42 | Z-NEW CONSTR.
 | ETNA TOWNSHIP | 5B | 43 | Z-NEW CONSTR.
Spreadsheet: 322268d1401691484-same-name-in-cells-is-formatted-differently-how-can-i-replace-with-a-consistent-format-6-2-14-deep-testing
Sheet: Dorks

Trade Rejected
Shine On You Crazy Diamond offers Year 2014 Draft Pick 1.14;Year 2014 Draft Pick 2.01;Year 2014 Draft Pick 2.06;Year 2014 Draft Pick 4.01
New York Dorks for Year 2014 Draft Pick 1.09;Year 2014 Draft Pick 1.10
Expires: Thu Mar 20 10:00:00 a.m. ET 2014
[NAME] 13 5:17:52 p.m. ET 2014
Trade Rejected
New York Dorks offers Year 2014 Draft Pick 1.04;Year 2014 Draft Pick 3.04;Year 2014 Draft Pick 4.04
Shine On You Crazy Diamond for Year 2014 Draft Pick 1.14;Year 2014 Draft Pick 2.01; Year 2015 Round 1 Draft Pick from Shine On You Crazy Diamond
Expires: Wed Mar 19 7:00:00 p.m. ET 2014
[NAME] ET 2014
Trade Rejected
Shine On You Crazy Diamond offers Year 2014 Draft Pick 2.01;Year 2014 Draft Pick 3.01
New York Dorks for Year 2014 Draft Pick 1.04
Expires: Wed Mar 19 4:00:00 a.m. ET 2014
Wed Mar 12 7:58:05 p.m. ET 2014
Trade Rejected
Shine On You Crazy Diamond offers Year 2014 Draft Pick 2.01;Year 2014 Draft Pick 3.01
New York Dorks for Year 2014 Draft Pick 1.04
Expires: Wed Mar 19 4:00:00 a.m. ET 2014
Wed Mar 12 6:50:00 a.m. ET 2014
Trade Rejected
New York Dorks offers Year 2014 Draft Pick 3.10;Year 2014 Draft Pick 4.10
Shine On You Crazy Diamond for Year 2014 Draft Pick 3.01
Expires: Tue Mar 18 4:00:00 p.m. ET 2014
Wed Mar 12 4:09:41 a.m. ET 2014
3-20-14, [NAME] likes up to 14, Chad likes up to 16, maybe even 18
2.03 (15) might be Moncrief or [NAME]!
3/27: [NAME], I'm not sure I'd do it, but would you consider a 2 for 1?  1.01 for 1.04 and 1.09?
#/27:  [NAME] says - I would definitely be interested in the 1.1 pick, even though I consider this a very deep draft and would reluctantly
part with two first rounders.
Spreadsheet: phillip_platter__31378__RT-STCA August
Sheet: Aug04

DATE | FERC FILE | SERVICE CUST | HR BEG | HR END | TOTAL HRS | DEL PT | SUPPLY | MW PER HR | TOTAL MW | SCHEDULE ID | PRICE | MARKET | PRICE | FEES | CONG | A_S CHARGE | BASIS | FERC ADJ | ENPOWER DEALS | TMM | LINE LOSSES | P_L | FILE SOURCE | TAG NO
2001-08-04 00:00:00 |  | Y | 7 | 7 |  | SP15 | EES | 25 |  |  | 29 | STCA | 46 |  |  |  |  |  |  | 718125,718126 | 1
2001-08-04 00:00:00 |  | Y | 8 | 8 |  | SP15 | EES | 25 |  |  | 29 | STCA | 46 |  |  |  |  |  |  | 718125,718126 | 1
2001-08-04 00:00:00 |  | Y | 9 | 9 |  | SP15 | EES | 25 |  |  | 29 | STCA | 46 |  |  |  |  |  |  | 718125,718126 | 1
2001-08-04 00:00:00 |  | Y | 10 | 10 |  | SP15 | EES | 25 |  |  | 29 | STCA | 46 |  |  |  |  |  |  | 718125,718126 | 1
2001-08-04 00:00:00 |  | Y | 11 | 11 |  | SP15 | WESCO | 10 |  |  | 48 | STCA | 46 |  |  |  |  |  |  | 718165,718126 | 1
2001-08-04 00:00:00 |  | Y | 11 | 11 |  | SP15 | CORAL | 15 |  |  | 47 | STCA | 46 |  |  |  |  |  |  | 718166,718126 | 1
2001-08-04 00:00:00 |  | Y | 12 | 12 |  | SP15 | CORAL | 25 |  |  | 47 | STCA | 46 |  |  |  |  |  |  | 718166,718126 | 1
2001-08-04 00:00:00 |  | Y | 13 | 13 |  | SP15 | WESCO | 25 |  |  | 48 | STCA | 46 |  |  |  |  |  |  | 718165,718126 | 1
2001-08-04 00:00:00 |  | Y | 14 | 14 |  | SP15 | WESCO | 25 |  |  | 48 | STCA | 46 |  |  |  |  |  |  | 718165,718126 | 1
2001-08-04 00:00:00 |  | Y | 15 | 15 |  | SP15 | WESCO | 24 |  |  | 48 | STCA | 46 |  |  |  |  |  |  | 718165,718126 | 1
2001-08-04 00:00:00 |  | Y | 15 | 15 |  | SP15 | CORAL | 1 |  |  | 47 | STCA | 46 |  |  |  |  |  |  | 718166,718126 | 1
2001-08-04 00:00:00 |  | Y | 16 | 16 |  | SP15 | WESCO | 25 |  |  | 48 | STCA | 46 |  |  |  |  |  |  | 718165,718126 | 1
2001-08-04 00:00:00 |  | Y | 17 | 17 |  | SP15 | EPME | 25 |  |  | 52 | STCA | 46 |  |  |  |  |  |  | 718190,718126 | 1
2001-08-04 00:00:00 |  | Y | 18 | 18 |  | SP15 | EPME | 25 |  |  | 52 | STCA | 46 |  |  |  |  |  |  | 718190,718126 | 1
2001-08-04 00:00:00 |  | Y | 19 | 19 |  | SP15 | EES | 25 |  |  | 43 | STCA | 46 |  |  |  |  |  |  | 718191,718126 | 1
2001-08-04 00:00:00 |  | Y | 20 | 20 |  | SP15 | EES | 25 |  |  | 43 | STCA | 46 |  |  |  |  |  |  | 718191,718126 | 1
2001-08-04 00:00:00 |  | Y | 21 | 21 |  | SP15 | CALPINE | 25 |  |  | 42 | STCA | 46 |  |  |  |  |  |  | 718192,718126 | 1
2001-08-04 00:00:00 |  | Y | 22 | 22 |  | SP15 | CALPINE | 25 |  |  | 42 | STCA | 46 |  |  |  |  |  |  | 718192,718126 | 1
Spreadsheet: 132260d1323651841-excel-2007-eliminating-weekend-in-bar-chart-plan_schedule_jpr73
Sheet: Gantt Chart

# | Task Name | Resource | Status | Start Date | Duration (days) | End Date2 | Duration (chart)
1 | Task 1 |  |  | 2011-12-12 00:00:00 | 5
2 | Task 2 |  |  | 2011-12-19 00:00:00 | 5
3 | Task 3 |  |  | 2011-12-26 00:00:00 | 15
4 | Test Task 4 |  |  | 2012-01-02 00:00:00 | 12
5 | Testing Task 5 |  |  |  | 10
Total
 |  | 40889
 |  | 41255
 |  | 40896
Spreadsheet: 35411d1233006414-birthday-calculator-birthdays
Sheet: Table of birthdays

 | Person | D.O.B | Current Age | Days until next birthday
 | Gran | 1922-08-26 00:00:00 | 1986-06-03 00:00:00 | 211
 | [NAME] | 1948-02-19 00:00:00 | 1960-12-08 00:00:00 | 23
 | Dad | 1951-10-27 00:00:00 | 1957-04-02 00:00:00 | 273
 | [NAME] | 1968-10-27 00:00:00 | 1940-04-01 00:00:00 | 273
 | Leah | 1978-01-18 00:00:00 | 1931-01-09 00:00:00 | #N/A
 | Liping | 1977-09-08 00:00:00 | 1931-05-21 00:00:00 | 224
 | [NAME] | 1978-12-28 00:00:00 | 1930-01-30 00:00:00 | 335
 | [NAME] | 1980-11-28 00:00:00 | 1928-02-29 00:00:00 | 305
 | Marni | 1981-10-25 00:00:00 | 1927-04-04 00:00:00 | 271
 | Blake | 2004-03-03 00:00:00 | 1904-11-25 00:00:00 | 35
 | Logan | 2005-07-30 00:00:00 | 1903-06-30 00:00:00 | 184
 | Jasmine | 2007-08-22 00:00:00 | 1901-06-07 00:00:00 | 207
 | [NAME] | 2008-10-16 00:00:00 | 1900-04-12 00:00:00 | 262
Spreadsheet: 8de62b41-1293-4e78-aba7-11762dd494d8
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6859 | 8065 | [NAME] | Brockenbrough | USA | 665 | 00:00:00 | 00:00:00 | 05:23:02 | 00:07:41 | 03:31:08 | 1 | 09:01:52
6859 | 8079 | Dieter | [NAME] | USA | 664 | 00:00:00 | 00:00:00 | 06:05:30 | 00:17:33 | 00:00:00 | DNS | 00:00:00
6859 | 54023 | [NAME] | Temple | USA | 666 | 00:00:00 | 00:00:00 | 05:34:20 | 00:05:43 | 00:00:00 | DNS | 00:00:00
Spreadsheet: 269478d1381171585-formatting-a-table-to-pull-data-array-formula-sampletable_student1990
Sheet: StdDev

 |  |  | Fundamental |  |  |  |  | Quantitative
Size Group | Style Group |  | 3-Year | 5-Year | 7-Year | 10-Year |  | 3-Year | 5-Year | 7-Year | 10-Year
A | 1 |  | 21.6792 | 27.41025 | 23.7802 | 21.8979 |  | 21.1741 | 28.70245 | 25.3919 | 22.491
A | 2 |  | 20.9917 | 25.97115 | 22.9961 | 20.41875 |  | 20.38605 | 25.8365 | 23.103 | 20.6264
A | 3 |  | 21.2077 | 26.2614 | 23.0701 | 20.8024 |  | 20.9599 | 27.2932 | 23.94245 | 21.8869
A | 4 |  | 22.31805 | 26.1391 | 23.8544 | 21.51135 |  | 23.2218 | 27.5121 | 24.3167 | 22.4947
A | 5 |  | 21.1101 | 25.5895 | 22.5842 | 20.4854 |  | 22.13225 | 26.696 | 23.6501 | 20.9523
B | 1 |  | 20.4094 | 25.7541 | 23.3766 | 21.49235 |  | 21.64085 | 27.8267 | 24.7484 | 21.8639
B | 2 |  | 21.46855 | 25.9913 | 22.7574 | 20.8926 |  | 19.4184 | 23.5037 | 21.0775 | 18.9932
B | 3 |  | 20.9183 | 25.92355 | 22.9604 | 21.0843 |  | 21.47 | 27.5887 | 24.28 | 20.42855
B | 4 |  | 21.04805 | 25.8812 | 23.57615 | 20.62985 |  | 21.6662 | 28.3651 | 25.3298 | 22.5106
B | 5 |  | 20.0782 | 24.6071 | 21.61265 | 19.485 |  | 21.4191 | 26.30015 | 23.3964 | 20.525
C | 1 |  | 20.72 | 26.35 | 23.08 | 20.51 |  | 19.45 | 26.26 | 23.06 | 20.2
C | 2 |  | 19.46 | 24.56 | 21.76 | 19.11 |  | 19.67 | 25.55 | 22.36 | 19.26
C | 3 |  | 19.61 | 24.75 | 21.95 | 19.2 |  | 19.56 | 25.68 | 22.36 | 19.43
C | 4 |  | 20.37 | 25.55 | 22.63 | 20.24 |  | 20.63 | 24.91 | 22.05 | 19.66
C | 5 |  | 20.01 | 24.59 | 21.4 | 18.75 |  | 20.33 | 26.02 | 22.75 | 19.68
D | 1 |  | 18.08 | 23.81 | 20.89 | 18.45 |  | 17.4 | 22.87 | 20.36 | 17.71
D | 2 |  | 16.44 | 21.83 | 19.36 | 17.11 |  | 16.79 | 22.6 | 20.03 | 17.4
D | 3 |  | 16.65 | 22.18 | 19.57 | 17.2 |  | 17.08 | 22.85 | 20.19 | 17.52
D | 4 |  | 17.68 | 22.57 | 19.85 | 17.34 |  | 16.72 | 22.15 | 19.51 | 17.21
D | 5 |  | 16.54 | 21.5 | 18.99 | 16.55 |  | 16.27 | 21.45 | 19.05 | 16.45
Spreadsheet: kim_ward__20827__Prepay Quantity Summary
Sheet: Quantity & Delivery Pt Summary

12 Year Prepay with APEA
4 Year Transactions to Support Term Prepay
Entity | Primary | Start | [NAME] | Delivery | Quantity MMBtu/d
 | Term | Date | End Date | Point | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Pasadena | 4 Years | 1999-05-01 00:00:00 | 2003-04-30 00:00:00 | Topock | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000
Glendale | 4 Years | 1999-07-01 00:00:00 | 1999-12-31 00:00:00 | Topock |  |  |  |  |  |  | 3990 | 3990 | 3990 | 3990 | 4178 | 4178
Glendale |  | 2000-01-01 00:00:00 | 2000-10-31 00:00:00 | Topock | 4178 | 4178 | 4178 | 4178 | 4178 | 4178 | 4178 | 4178 | 4178 | 4178
Glendale |  | 2000-11-01 00:00:00 | 2002-06-30 00:00:00 | NIT ("AECO C") | 4178 | 4178 | 4178 | 4178 | 4178 | 4178 | 4178 | 4178 | 4178 | 4178 | 4178 | 4178
SMUD | 4 Years | 1999-05-01 00:00:00 | 2003-04-30 00:00:00 | 2/3 Malin, 1/3 Permian | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000
Clark County PUD | 3 Years | 1999-07-01 00:00:00 | 2002-06-30 00:00:00 | NWPL, Sumas | 10000 | 10000 | 10000 |  |  |  | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
APEA | 2 Years | 1999-11-01 00:00:00 | 2001-10-31 00:00:00 | NNG Demarcation | 4000 | 4000 | 4000 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 4000 | 4000
APEA | 3 Years | 2001-11-01 00:00:00 | 2004-10-31 00:00:00 | NNG Demarcation | 7000 | 7000 | 7000 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 7000 | 7000
APEA | 3 Years | 2004-11-01 00:00:00 | 2007-10-31 00:00:00 | NNG Demarcation | 9000 | 9000 | 9000 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 9000 | 9000
APEA | 4 Years | 2007-11-01 00:00:00 | 2011-04-30 00:00:00 | NNG Demarcation | 15000 | 15000 | 15000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 15000 | 15000
Spreadsheet: 220728d1363250722-combine-if-and-vlookup-and-sum-it-sample
Sheet: INVOICE

NO CUST | NO | NO INV | COMPANY NAME | CP | INVOICE | PAYMENT | BALANCE
A11 | 1 |  |  |  | 1000
A12 | 1 |  |  |  | 1000
A13 | 1 |  |  |  | 2500
A13 | 2 |  |  |  | 2000
Spreadsheet: 112953d1308918920-league-table-spreadsheet-help-football-stats-current-
Sheet: Sheet1

 | [NAME] | [NAME] | Adam | [NAME] | Olly | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Tariq | [NAME] | [NAME] | Nich | [NAME] | Mark | Martin | [NAME] | [NAME] | [NAME] | Shaun
[NAME]
[NAME]
Adam
[NAME]
Olly
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Tariq
[NAME]
[NAME]
Nich
[NAME]
Mark
Martin
[NAME]
[NAME]
[NAME]
Shaun
Spreadsheet: 07e8ab7d-c398-4d62-91b2-a154190d042f
Sheet: AP5-Non Construction L2

NCC | Non Construction Costs Profile |  |  |  | Years | 60
REF | BCIS | Description | Qty | Unit | Rate | Cost
6.0 | Non Construction Costs
6.1 | Land and enabling works
6.1 |  | State client requirements, standards required, working restrictions and procurement context
6.2 | Finance costs
6.2 |  | State client requirements, standards required, working restrictions and procurement context
6.3 | Rent costs
6.3 |  | State client requirements, standards required, working restrictions and procurement context
6.4 | Strategic estate management
6.4 |  | State client requirements, standards required, working restrictions and procurement context
6.5 | Space charges
6.5 |  | State client requirements, standards required, working restrictions and procurement context
6.6 | Taxes on costs
6.6 |  | State client requirements, standards required, working restrictions and procurement context
6.7 | Client definable costs
 |  | Total Non Construction Costs
Spreadsheet: 106033d1303258227-formula-not-showing-correct-format-2011_
Sheet: KPI Checklist

 |  |  |  |  | 0.0005555555555555556 | 0.005 | 0.045
 | Job Title: | tess |  |  |  |  |  |  | 0.005
 |  | 152 |  |  |  |  |  |  | 0.01
 |  | 1A007 |  |  |  |  |  |  | 0.005 | 0.0005555555555555556
 | Description | Start Date | Baseline Excellent Due Date | Baseline Expected Due Date | Baseline  Poor Date | Current Excellent Due Date | Current Expected Due Date | Current  Poor Date | Date Met | Score | Criteria |  |  |  | Qual. Weight
 |  |  |  |  |  |  |  |  |  |  | EXCELLENT | EXPECTED | POOR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Workdays between |  |  |  | 1 | 0.9 | 0.8 | 0.7 | 0.6 | 0.5 | 0.4 | 0.3 | 0.2 | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.025 | 0.0225 | 0.02 | 0.0175 | 0.015 | 0.0125 | 0.01 | 0.0075 | 0.005000000000000001 | 0.0025
5.2 | EI's completed by Agreed schedule (within 5 working days) | 2011-03-07 00:00:00 | 2011-02-28 00:00:00 | 2011-03-07 00:00:00 | 2011-03-14 00:00:00 | 2011-02-28 00:00:00 | 2011-03-07 00:00:00 | 2011-03-14 00:00:00 | 2011-02-28 00:00:00 | Excellent | ≤5 Days of Agreed Schedule | Agreed Scheduled Date | ≥5 Days of Agreed Schedule | 0.025 | 0.025 |  |  | 0 | 5 | 10
5.3 | Response to corrective/integrity CTR request (+15%) | 2011-03-07 00:00:00 | 2011-02-28 00:00:00 | 2011-03-07 00:00:00 | 2011-03-14 00:00:00 | 2011-02-28 00:00:00 | 2011-03-07 00:00:00 | 2011-03-14 00:00:00 | 2011-02-28 00:00:00 | Excellent | ≤5 Days of CTR Request | Agreed Scheduled Date | ≥5 Days of CTR Request | 0.025 | 0.025 |  |  | 0 | 5 | 10 |  | 1 | 0.9 | 0.8 | 0.7 | 0.6 | 0.5 | 0.4 | 0.3 | 0.2 | 0.1