tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 858714d1707298481-creating-a-button-to-flick-between-forecast-and-actuals-new-forecasting-template-draft-to-share-v2
Sheet: Capital

 | PROJECT
 |  |  | Baseline | Held by GMA |  | Change to dropdowns |  |  |  |  |  | Staff cost calculator
 |  |  | Budget | Original total spend estimate?
 |  |  | Forecast | Completed by the PMs |  |  |  |  |  |  |  | How do we deal with baseline vs the latest approved
 |  |  | Actual | Held by finance
 |  |  |  |  |  |  |  |  |  |  | 23/24
 |  | Actuals to Date | AFC | 23/24 Forecast | 24/25 Forecast | 25/26 Forecast | 26/27 Forecast | 27/28 Forecast | 28/29 Forecast |  | March | April | May | June | July | August | September | October | November | December | January | February
 | Consultancy Costs |  |  |  |  |  |  |  |  |  | 1 | 23 | 3 | 3 | 3
 | ICT (Hardware/Software) |  |  |  |  |  |  |  |  |  | 1 | 23 | 3 | 3 | 3
 | Legal Fees |  |  |  |  |  |  |  |  |  | 1 | 23 | 3 | 3 | 3
 | Payment to contractors |  |  |  |  |  |  |  |  |  | 1 | 23 | 3 | 3 | 3
 | Payments to LA's / Other Public Bodies |  |  |  |  |  |  |  |  |  | 1 | 23 | 3 | 3 | 3
 | Payments to Others
 | Staff Costs
 | Agency
 | Secondments
 | Departmental recharges
Revenue only | Direct Transport Costs
Revenue only | [NAME]
Revenue only | [NAME], Lease & Rental
Revenue only | Equipment, Furniture & Materials
Revenue only | Events & Catering
Revenue only | Printing, Stationery & Office Supplies
Revenue only | Advertising
Revenue only | Digital
Revenue only | Publicity & Events
Revenue only | Expenses - Conferences
Revenue only | Subscriptions
Revenue only | Insurance
Revenue only | External and Company Training
CHECK | Public Transport - Staff & Members
CHECK | Public Transport - Service Travel Costs
CHECK | Communications & Marketing
 |  | Stage |  |  |  |  |  |  |  |  | OBC | OBC | OBC | FBC | FBC | Delivery
 | Grant information
 | Project X
 |  |  | Baseline |  |  |  |  |  |  |  |  |  | Forecast
 | 22/23 | TCF | 5
 |  | IF | 1 |  |  |  |  |  |  |  |  |  | 10
 |  | TOTAL
 | 23/24 | CRSTS | 6
 | PROGRAMME
 | SOFT Summary
 | Budget (Total grant award) | Approved | Actuals to  Date | Forecast | AFC |  | AFC Movement
CRSTS | 540 | 5 | 0 | 650 |  |  | 6
Spreadsheet: 738187d1624889826-formula-for-total-and-entries-excel-question-2806
Sheet: Sheet1 (2)

A |  |  | B
Name | Amount |  | Name | Total | Entries
[NAME] | 10 |  | [NAME] |  | 5
Mark | 20 |  | Mark |  | 5
[NAME] | 30 |  | [NAME] |  | 5
[NAME] | 10 |  | [NAME] |  | 5
[NAME] | 20
Mark | 30
[NAME] | 40
[NAME] | 50
[NAME] | 60
Mark | 70
[NAME] | 80
[NAME] | 90
[NAME] | 100
Mark | 110
[NAME] | 120
[NAME] | 130
[NAME] | 140
Mark | 150
[NAME] | 160
[NAME] | 170
Spreadsheet: fb895447-9a9e-40a1-a4b1-7cc63307a83f
Sheet: Sheet1

Individual | Stage | Tissues
638 | d25 RPY | YSM, Head
788 | d23 RPY | YSM, Tail
863 | d25 RPY | YSM, Head
2359 | D5 pp | Body
2386 | D8 pp | Body
112 | d23 RPY | BYS, TYS, Head
3001 | d22 | Head, YSM
3294 | d22 | Head, YSM
3297 | d24 | Head, YSM
3640 | d22 | Head, YSM
3770 | d25 | Head, YSM
3795 | d25 | Head, YSM
3444 | d25 | TYS Cell line
Spreadsheet: sally_beck__33995__Log as of 4_20_01
Sheet: Sum Feb 7 to 13

 | Week summary (Feb 7 to 13)
Category | Description | Total |  | Breakdown of Cat 1
1 | Human Errors |  |  | Process in place but not followed
2 | IT Hardware problems |  |  | Officialized on time but needed recalc
3 | IT Software Problems |  |  | Book not officialized
4 | Miscellaneous |  |  | No process in place
5 | Uncontrollable | 0 |  | Other
 | Total |  |  | Total
 |  |  |  | Breakdown of Cat 2
 |  |  |  | Computer breakdown | 0
 |  |  |  | Other
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 3
 |  |  |  | Correct inputs, incorrect outputs
 |  |  |  | Slow feeds
 |  |  |  | Feed problem
 |  |  |  | Books shown as officialized, but not RiskTrac
 |  |  |  | Application down alternate system used
 |  |  |  | Other
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 4
 |  |  |  | Credit interface | 0
 |  |  |  | Other | 0
 |  |  |  | Total
Spreadsheet: 19fec273-c675-49d9-82a4-bb71e2707ade
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 17. COMMERCIAL FINANCE COMMITMENTS, Fixed Loans By Industry: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Agriculture, forestry and fishing ; |  |  | Original | A2414226J | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2414227K | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2414228L | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2414229R | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2414230X | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | A2414231A | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2414232C | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | A2414233F | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2414234J | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2414235K | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Public administration ; |  |  | Original | A2414236L | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2414237R | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2414238T | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
TOTAL FIXED LOANS ; |  |  | Original | A2414239V | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 769999d1645777306-pull-balance-consonants-wild-card-pull
Sheet: Sheet1

DLN
TENDRIL |  | s | 569 | DEILNRT | RT
TRINDLE |  | ds | 570 | DEILNRT | RT
ENTROLD |  |  | 683 | DELNORT | RT
DARNELS |  |  | 1492 | ADELNRS | RS
ENLARDS |  |  | 1493 | ADELNRS | RS
LANDERS |  |  | 1494 | ADELNRS | RS
RELANDS |  |  | 1495 | ADELNRS | RS
SLANDER |  | s | 1496 | ADELNRS | RS
SNARLED |  |  | 1497 | ADELNRS | RS
DENTALS |  |  | 1501 | ADELNST | ST
SLANTED |  |  | 1502 | ADELNST | ST
Spreadsheet: 91492d1291219341-excel-2007-find-and-copy-rows-and-stop-when-data-changes-sample-data
Sheet: Paste #1 Rpt

N DC Team | Page -1 of 1
NDC1A | N DC Team
External | 1
Externally Billed | Total Invoice Days:
0 - Travel | 47 | 50 | 40.3 | 0 | 40.3 | 3.668973051711581 | 4077.75 | 101.1848635235732 | 26.04 | 0 | 0 | 0 | 4103.79
10090173 | 109 | 1 | 2 | 0 | 2 | 0.1820830298616169 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10126600 | 94 | 1 | 1 | 0 | 1 | 0.09104151493080845 | 110 | 110 | 1.24 | 0 | 0 | 0 | 111.24
1 - Breakdown | 39 | 47 | 184.7 | -0.15 | 184.7 | 16.81536780772032 | 16424.6385 | 88.92603410936654 | 0 | 11770.5019 | 71.66368927998019 | 63.72767677314564 | 28195.1404
10126600 | 94 | 1 | 7.5 | 0 | 7.5 | 0.6828113619810634 | 705 | 94 | 0 | 521.71 | 74.00141843971633 | 69.56133333333334 | 1226.71
26837800 | 94 | 8 | 25 | 0 | 25 | 2.276037873270211 | 2350 | 94 | 0 | 1107.48 | 47.12680851063829 | 44.2992 | 3457.48
2872501 | 98.1 | 1 | 0.2 | 0.1 | 0.2 | 0.01820830298616169 | 29.43 | 147.15 | 0 | 6.9 | 23.44546381243629 | 34.5 | 36.33
28772466 | 98.1 | 1 | 5.5 | 0 | 5.5 | 0.5007283321194465 | 539.5499000000001 | 98.09998181818185 | 0 | 24.6599 | 4.570457709286943 | 4.483618181818182 | 564.2098000000001
28772602 | 98.1 | 1 | 3.8 | 0 | 3.8 | 0.3459577567370722 | 372.78 | 98.1 | 0 | 0 | 0 | 0 | 372.78
2 - Scheduled Maintenance | 55 | 55 | 59 | 16.4 | 42.6 | 3.87836853605244 | 5085 | 119.3661971830986 | 27.5 | 0 | 0 | 0 | 5112.5
11589000 | 94 | 2 | 5 | 2 | 3 | 0.2731245447924254 | 330 | 110 | 13.75 | 0 | 0 | 0 | 343.75
2872501 | 98.1 | 1 | 1.5 | 0.7 | 0.8 | 0.07283321194464676 | 95 | 118.75 | 0 | 0 | 0 | 0 | 95
3 - Repair  Field | 72 | 79 | 174.6 | 0.05 | 179.2 | 16.31463947560087 | 16195.9549 | 90.37921261160714 | 0 | 38041.41 | 234.8821680159161 | 212.2846540178572 | 54237.3649
10090173 | 109 | 1 | 11 | 0 | 11 | 1.001456664238893 | 1034 | 94 | 0 | 0 | 0 | 0 | 1034
11589000 | 94 | 2 | 5.5 | 0 | 5.5 | 0.5007283321194465 | 517 | 94 | 0 | 347.15 | 67.14700193423597 | 63.11818181818182 | 864.15
125 | 94 | 3 | 16.5 | 0 | 16.5 | 1.50218499635834 | 1551 | 94 | 0 | 538.05 | 34.69052224371373 | 32.60909090909091 | 2089.05
26837800 | 94 | 5 | 25.5 | 0 | 21.5 | 1.957392571012381 | 2397 | 111.4883720930233 | 0 | 2139.7 | 89.26574885273257 | 99.52093023255814 | 4536.7
2872501 | 98.1 | 1 | -0.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Internal | 2 | #WOs | #Seg | Inv Hours | Dock/Gain | Actual Hours | % Total | Labor $$ | $$ Per Hour | Misc $$ | Parts $$ | P to Lbr % | PP/Lbr Hr
[NAME] | Total Invoice Days: | 18 | Avg Labor $ P/Day: | 1066.261111111111 | [NAME] $ P/Day: | 258.4183166666667 | Avg Labor Hours P/Day: | 18.07222222222222 | #WOs | #Seg | Inv Hours | Dock/Gain | Actual Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19192.7 | 59 | 0 | 4651.5297 | 24.23593189077097 | 14.29919981555487 | 23844.2297
0 - Travel | 27 | 28 | 59.9 | 0 | 59.9 | 5.453386744355426 | 3534.1 | 59 | 0 | 0 | 0 | 0 | 3534.1
125 | 94 | 4 | 12.6 | 0 | 12.6 | 1.147123088128186 | 743.4 | 59 | 0 | 0 | 0 | 0 | 743.4
Spreadsheet: 176188d1345751110-adding-values-based-upon-name-in-column-a-banking-hours
Sheet: Sheet1

EMPLOYEE | DATE OF O.T | DATE USED | AMOUNT BANKED | AMOUNT USED
[NAME] |  |  | 1 | 3 |  | MIKE PURDY
[NAME] |  |  | 2 | 3 |  | [NAME]
[NAME] |  |  | 10 |  |  | RYAN HILL
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | PATTI LINDSTROM
 |  |  |  |  |  | CHRIS TONE
Spreadsheet: 706393d1606674812-generating-incremental-order-number-based-on-date-and-condition-sample
Sheet: Sample

Date (YYMMDD) | Name | Order Number
2020-11-25 00:00:00 | Abrar | 20112501-01
2020-11-25 00:00:00 | Abrar | 20112501-02
2020-11-25 00:00:00 | Dev | 20112502-01
2020-11-25 00:00:00 | Dev | 20112502-02
2020-11-26 00:00:00 | [NAME] | 20112601-01
2020-11-26 00:00:00 | [NAME] | 20112601-02
2020-11-26 00:00:00 | [NAME] | 20112601-03
2020-11-26 00:00:00 | [NAME] | 20112601-04
2020-11-26 00:00:00 | Partha | 20112602-01
Spreadsheet: 04de7c86-1f43-402e-970f-3b08b18ab5b0
Sheet: Consolidate 2887

Consolidation: Districts Affected by McLeod West 2887
 |  | A | B | C | D | E
 |  | 2887 | 2159 | 2365 | 2859
 |  | 1 | 1 | 1 | 1
 |  | MCLEOD WEST | BUFFALO LAKE | G.F.W. | GLENCOE-S LAKE
1 | Portions for distributing Mcleod West values
 | based on FY 2009 AMCPU: | 0 | 0.15 | 0.29 | 0.56
 | [NAME] totals before adjusting for consolidation:
 | TRA basic + coordinated salaries, FY 1997 | 1487616.72 | 1499008.01 | 2637938.48 | 4201427.59
 | TRA basic + coordinated salaries, FY 2004 | 1553595.1 | 2265962.58 | 3188988.91 | 5881443.27
 | TRA basic + coordinated salaries, FY 2005 | 1607578.73 | 2216552.64 | 3193583.58 | 6095824.87
 | TRA basic + coordinated salaries, FY 2006 | 1637985.05 | 2250864.08 | 3010779.06 | 5741888.82
 | TRA basic + coordinated salaries, FY 2007 | 1568852.79 | 2213944.46 | 3072818.16 | 5387615.3
 | TRA basic + coordinated salaries, FY 2008 | 1436341.44 | 2364341.6 | 3133690.35 | 5421286.48
 | TRA basic + coordinated salaries, FY 2009 | 1082620.04 | 2528502.75 | 3087237.08 | 5841122.22
 | TRA basic + coordinated salaries, FY 2010 | 0 | 2655495.72 | 3277582.59 | 6501234.79
 | FY 1997 salary totals adjusted for consolidation:
 |  |  | n/a | n/a | n/a
 |  | 0
 |  | n/a
 |  | n/a
 | Share of #2887's FY 2007 salaries | n/a
 |  | n/a
 | PERA:
 | Not adjusted for consolidation:
 | PERA salaries, FY 1997 | 377150 | 356207 | 905939 | 1619524
 | PERA adjustment, old law | -2307.75 | -2908.54 | -2900 | -6870.24
 | Distributing the McLeod West values:
 | PERA salaries, FY 1997 | n/a
 | PERA adjustment, old law | n/a
 | Adjusted for consolidation:
 |  | n/a
 |  | n/a
Spreadsheet: 0e85f869-3956-4a95-8af2-99ff929e9a3f
Sheet: Sheet1

name | Spo11 [NAME] (sae2D)  (Borde et al) | Spo11 [NAME] (rad50S)  (this study ) | name  (Agilent )
YDR187C* | 15.665425 | 32.4539 | iYDR186C
YGR176W | 14.59809 | 20.0979 | iYGR175C
YBR209W | 13.432655 | 23.1086 | [NAME]
YJR078W | 13.18867 | 10.0172 | iYJR077C
YDR296W* | 11.88925 | 15.458 | YDR296W_MHR1
YCR047C* | 11.014585 | 27.7305 | iYCR047C
YJR072C | 10.38599 | 17.2667 | YJR072C_YJR072C
YGL149W | 10.21456 | 18.0179 | iYGL150C
YDR188W* | 9.59109 | 32.4539 | iYDR186C
YPR064W | 9.28136 | 14.5025 | iYPR063C
YMR122C | 9.24514 | 6.2037 | iYMR121C
YCR049C* | 9.126524999999999 | 27.7305 | iYCR047C
YCR074C | 8.944565 | 8.4807 | [NAME]
YKR049C | 8.78883 | 10.2286 | [NAME]
YHR041C | 8.546935 | 31.2095 | YHR042W_NCP1
YOR226C | 8.302829999999998 | 6.8521 | iYOR226C
YJL055W | 8.26873 | 10.6816 | iYJL056C
YOL073C | 8.248335 | 11.6145 | YOL073C_YOL073C
YMR057C* | 8.13568 | 28.6115 | iYMR056C
YJR073C* | 8.046315 | 21.7053 | iYJR074W
YCR048W* | 8.02461 | 27.7305 | iYCR047C
YJL063C | 8.004055 | 11.7307 | iYJL063C
YMR265C | 7.934445 | 28.8629 | YMR265C
YPR082C | 7.556635 | 4.5593 | YPR082C_DIB1
YOR268C | 7.53935 | 8.094 | YOR268C_YOR268C
YPR062W | 7.487855 | 9.0232 | [NAME]
YOL058W | 7.3544 | 10.9232 | iYOL059W
YJR074W | 6.919675 | 21.7053 | iYJR074W
YJR038C | 6.853209999999999 | 4.6188 | iYJR036C
YDR123C | 6.74059 | 19.4122 | iYDR123C
YOL059W | 6.70905 | 10.9232 | iYOL059W
YDR246W | 6.58423 | 15.7324 | YDR246W-A
[NAME] | 6.554174999999999 | 5.7272 | itL(CAA)C
YMR056C* | 6.505195 | 27.6115 | iYMR056C
YOL071W | 6.459454999999999 | 6.8122 | YOL072W_THP1
YPL025C | 6.41522 | 4.7861 | iYPL026C
YLR350W | 6.30057 | 13.9097 | iYLR348C
YJR058C | 6.185155 | 9.8812 | iYJR058C
YBR032W | 6.14118 | 20.3535 | YBR033W_EDS1
YCR046C* | 6.133389999999999 | 27.7305 | iYCR047C
YFR020W | 6.092835 | 10.5063 | iYFRCdelta9
YBR219C | 6.05132 | 14.6001 | YBR219C_YBR219C
[NAME] | 5.846635 | 11.9058 | iYBR230C
YFR025C | 5.84559 | 8.9378 | YFR025C_HIS2
YOR091W | 5.826555 | 16.0173 | iYOR091W
YBR134W | 5.794734999999999 | 7.4962 | iYBR133C
YJL064W | 5.76588 | 9.9358 | YJL063C_MRPL8
[NAME] | 5.642515 | 12.3175 | iYJL027C
YGR078C | 5.527865 | 12.2448 | iYGR078C
YAL020C | 6.090025000000001 | 5.7636 | YAL020C
Spreadsheet: 839154d1691697901-dynamic-drop-down-list-in-excel-sample1
Sheet: Sheet1

 | Account | FN
 | 502 | FN1
 | 601
 | 101
 | 501
 | 601
 | 501
 | 602
 | 603
 | 604
 | 502
 | 503
 | 504
 | 505
Spreadsheet: bf34bbf1-f529-4328-a261-2290c32b1433
Sheet: Sheet1

Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2011-04-13 | 1 | Peoria | 1 | Houston | 4 | Final | Toyota [NAME], TX
2011-04-15 | 2 | Peoria | 2 | Houston | 3 | Final OT | Toyota [NAME], TX
2011-04-18 | 3 | Houston | 5 | Peoria | 3 | Final | Carver [NAME], IL
2011-04-19 | 4 | Houston | 2 | Peoria | 1 | Final | Carver [NAME], IL
2011-04-29 | 1 | Houston | 1 | Milwaukee | 3 | Final | Bradley Center Milwaukee, WI
2011-05-01 | 2 | Houston | 2 | Milwaukee | 0 | Final | Bradley Center Milwaukee, WI
2011-05-03 | 3 | Milwaukee | 5 | Houston | 3 | Final | Toyota [NAME], TX
2011-05-05 | 4 | Milwaukee | 2 | Houston | 3 | Final OT | Toyota [NAME], TX
2011-05-06 | 5 | Milwaukee | 2 | Houston | 3 | Final OT | Toyota [NAME], TX
2011-05-08 | 6 | Houston | 4 | Milwaukee | 5 | Final OT | Bradley Center Milwaukee, WI
2011-05-10 | 7 | Houston | 4 | Milwaukee | 2 | Final | Bradley Center Milwaukee, WI
2011-05-13 | 1 | [NAME] | 1 | Houston | 2 | Final | Toyota [NAME], TX
2011-05-15 | 2 | [NAME] | 2 | Houston | 3 | Final | Toyota [NAME], TX
2011-05-17 | 3 | Houston | 3 | [NAME] | 2 | Final | [NAME], ON
2011-05-18 | 4 | Houston | 1 | [NAME] | 8 | Final | [NAME], ON
2011-05-20 | 5 | Houston | 2 | [NAME] | 4 | Final | [NAME], ON
2011-05-22 | 6 | [NAME] | 5 | Houston | 4 | Final OT | Toyota [NAME], TX
2011-05-24 | 7 | [NAME] | 3 | Houston | 4 | Final | Toyota [NAME], TX
2011-05-27 | 1 | [NAME] | 1 | Houston | 3 | Final | Toyota [NAME], TX
2011-05-28 | 2 | [NAME] | 2 | Houston | 1 | Final OT | Toyota [NAME], TX
2011-06-01 | 3 | Houston | 2 | [NAME] | 1 | Final | Broome County Veterans Memorial Arena Binghamton, NY
2011-06-03 | 4 | Houston | 0 | [NAME] | 3 | Final | Broome County Veterans Memorial Arena Binghamton, NY
2011-06-04 | 5 | Houston | 2 | [NAME] | 4 | Final | Broome County Veterans Memorial Arena Binghamton, NY
2011-06-07 | 6 | [NAME] | 3 | Houston | 2 | Final | Toyota [NAME], TX
Spreadsheet: 833d4ce1-cf31-4ac1-8176-e06025ef938d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | "RIDE 'N' TIE" TIMING SHEET | Unnamed: 4 | Unnamed: 5 | PAGE No. | Unnamed: 7
DATE:
START TIME | A- |  |  |  | B | (B-A)
TEAM | RIDER | FIRST VET CHECK | SECOND VET CHECK | THIRD VET CHECK | FINISHING | RUNNING | FINISHING
RIDERS | # | IN AND OUT | IN AND OUT | IN AND OUT | TIME | TIME | ORDER
Spreadsheet: 0c79b9a8-fb2f-4909-9abd-067130a9002f
Sheet: 2009

2009 Rank | NAME OF EMPLOYER | EMPLOYEES(1) | BUSINESS | 2008 Rank
1 | HARVARD UNIVERSITY | 11382 | HIGHER EDUCATION | 1
2 | MASSACHUSETTS INSTITUTE OF TECHNOLOGY | 8167 | HIGHER EDUCATION | 2
3 | CITY OF CAMBRIDGE(2) | 2657 | GOVERNMENT | 3
4 | MT. AUBURN HOSPITAL | 2056 | MEDICAL | 4
5 | NOVARTIS INSTITUTE FOR BIOMEDICAL RESEARCH | 1946 | BIOTECHNOLOGY | 5
6 | BIOGEN IDEC | 1654 | BIOTECHNOLOGY | 6
7 | GENZYME CORPORATION | 1386 | BIOTECHNOLOGY | 8
8 | FEDERAL GOVERNMENT | 1292 | GOVERNMENT | 9
9 | DRAPER LABORATORY | 1199 | RESEARCH & DEVELOPMENT | 10
10 | CAMBRIDGE HEALTH ALLIANCE | 1154 | MEDICAL | 7
11 | VERTEX PHARMACEUTICALS | 1098 | BIOTECHNOLOGY | 11
12 | MILLENIUM PHARMACEUTICALS | 1003 | BIOTECHNOLOGY | 14
13 | [NAME] CAMBRIDGE | 810 | BIOTECHNOLOGY | 18
14 | CAMP, DRESSER & MCKEE | 668 | ENGINEERING CONSULTANTS | 15
15 | EF INTERNATIONAL | 650 | TRAVEL & EXCHANGE PROGRAMS | 16
16 | QUEST DIAGNOSTICS | 640 | CLINICAL TESTING SERVICES | 13
17 | WHOLE FOODS | 622 | SUPERMARKET | 17
18 | AKAMAI | 618 | INTERNET NETWORK SERVICES | 19
19 | LESLEY UNIVERSITY | 531 | HIGHER EDUCATION | 21
20 | COMMONWEALTH OF MASSACHUSETTS | 526 | GOVERNMENT | 12
21 | FORRESTER RESEARCH | 519 | BUSINESS SERVICES | 20
22 | SHIRE HGT(3) | 491 | BIOTECHNOLOGY | --
23 | BBN TECHNOLOGIES | 478 | RESEARCH & DEVELOPMENT | 23
24 | ITA SOFTWARE | 443 | SOFTWARE | 22
25 | YOUVILLE HOSPITAL & REHABILITATION CENTER | 418 | MEDICAL | 24
Spreadsheet: 206399d1358178406-tracking-construction-employee-hours-across-sheets-tracker
Sheet: Sheet3

 | Name | Part | Sept | Oct | Nov | Dec | Joined
 | Fred | a | 1 | 1 | 1 | 1
 | Fred | a | 1 | 1 | 1 | 1 |  |  | [NAME]
 | Barney | a | 1 | 1 | 1 | 1 |  |  | Part | a
 | Barney | a | 1 | 1 | 1 | 1 |  |  | Month
 | Wilma | a | 1 | 1 | 1 | 1
 | Wilma | b | 1 | 1 | 1 | 1 |  |  | Total Sales
 | [NAME] | a | 1 | 1 | 1 | 100
 | [NAME] | b | 1 | 1 | 1 | 1
 | [NAME] | a | 1 | 1 | 1 | 1
 | Heather | b | 1 | 1 | 1 | 1
 | [NAME] | a | 1 | 1 | 1 | 1
 |  |  |  | sumif | sumproduct
 | Name | Product | Month | Total | Total
 | [NAME] |  | Dec
SUMIF({"Freda";"Freda";"Barneya";"Barney a";"Wilmaa";"Wilmab";"Toma";"Joeb";" Chrisa";"Heatherb";"Chrisa"},"Toma",INDEX({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,100;1,1,1,1;1,1,1,1;1,1,1,1;1,1,1,1},,MATCH("Dec",{"Sept","Oct","Nov","Dec"},0)))
SUMPRODUCT(--({"Fred";"Fred";"Barney";"Barney ";"Wilma";"Wilma";"Tom";"Joe";" Chris";"Heather";"Chris"}&{"a";"a";"a";"a";"a";"b";"a";"b";"a";"b";"a"}="Tom"&"a"),INDEX({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,100;1,1,1,1;1,1,1,1;1,1,1,1;1,1,1,1},,MATCH("Dec",{"Sept","Oct","Nov","Dec"},0)))
Spreadsheet: 605494d1547116880-abbreviating-names-sample
Sheet: Sheet1

[NAME] | Aint
Ascot | Ascot | Ascot |  | column A would be the data received
Ayr | Ayr |  |  | column B is how I wish it to be shown
Bangor | Bang
Bath | Bath |  |  | Col C are the exceptions to the formula I thought I was going to be able to be used Left etc
Beverley | Bev | Bev
Brighton | Brig |  |  | some days there will be 6 -8 entires from the list other days there might be 2-3 or 10-12  it does vary quite a bit
Carlisle | [NAME]
[NAME] | Cart
[NAME] | [NAME]
Cheltenham | Chelt | Chelt
Chelmsford City | ChelmC | Chelmc
Chepstow | [NAME]
Chester | Chest | Chest
Doncaster | [NAME]
[NAME] | Epsm | Epsm
Exeter | [NAME] | [NAME]
Fakenham | Fake
Ffos Las | [NAME] | [NAME]
Folkstone | Folk
Fontwell | Font
Goodwood | Good
[NAME] | Ham
Haydock | Hayd
[NAME] | Here
Hexham | Hex | Hex
Huntingdon | [NAME]
Kelso | Kelso | Kelso
[NAME] | [NAME]
Leicester | Leic
Lingfield | Ling
Ludlow | [NAME]
Market Rasen | MrktR | Mrktr
Musselburgh | Muss
Newbury | Newb
Newcastle | Newc
Newmarket | Newm
[NAME] | [NAME]
[NAME] | Nott
Perth | Perth | Perth
Plumpton | Plump | Plump
Pontefract | Ponte | Ponte
Redcar | Redc
Ripon | Ripon | Ripon
Salisbury | Salis
Sandown | Sand
Sedgefield | Sedge | Sedge
Southwell | [NAME] | [NAME]
[NAME] | Strat
Taunton | Taun
Thirsk | Thirsk | Thirsk
Towcester | Towc
[NAME] | Uttox
Warwick | Warw
Wetherby | Weth
Wincanton | Winc
Windsor | Wind
Wolverhampton | Wolv
Worcester | Worc
Yarmouth | Yarm
York | York
Ballinrobe | Ballin | Ballin
Bellewstown | Belle | Belle
Clonmel | Clon
Cork | Cork
[NAME] | DownR | Downr
Downpatrick | DownP | Downp
Dundalk | Dund
Fairyhouse | Fairy | Fairy
Galway | Gal | Gal
Gowran Park | GowP
Killarney | Killar | Killar
Kilbeggan | [NAME]
Laytown | [NAME]
Leopardstown | Leop
Limerick | Lim | Lim
Listowel | List
Naas | Naas
Navan | Navan | Navan
Punchestown | Punch | Punch
Roscommon | Rosc
Shelbourne | Shelb | Shelb
Sligo | Sligo
The Curragh | Curr | Curr
Thurles | Thurl
Tipperary | Tipp
Tralee | Tral
Tramore | Tram
Wexford | Wex | Wex
Spreadsheet: 113192d1309176407-an-easier-way-to-use-subtotals-subtotals-after
Sheet: After

Vehicle Reg | Driver | Garagae | Cost
A123ABC | [NAME] | London | 150
A123ABC | [NAME] | London | 100
A123ABC | [NAME] | London | 50
A123ABC | [NAME] | London | 100
A123ABC | [NAME] | London | 100
A123ABC | [NAME] | London | 50
A123ABC | [NAME] | London | 150
A123ABC | [NAME] | London | 100
A123ABC | [NAME] | London | 50
A123ABC | [NAME] | London | 100
A123ABC | [NAME] | London | 100
A123ABC | [NAME] | London | 50
A123ABC | [NAME] | London | 150
A123ABC | [NAME] | London | 100
A123ABC | [NAME] | London | 50
A123ABC Total |  |  | 1400
B234BCD | [NAME] | Liverpool | 100
B234BCD | [NAME] | Liverpool | 100
B234BCD | [NAME] | Liverpool | 50
B234BCD | [NAME] | Liverpool | 150
B234BCD | [NAME] | Liverpool | 100
B234BCD | [NAME] | Liverpool | 50
B234BCD | [NAME] | Liverpool | 100
B234BCD | [NAME] | Liverpool | 100
B234BCD | [NAME] | Liverpool | 50
B234BCD | [NAME] | Liverpool | 150
B234BCD | [NAME] | Liverpool | 100
B234BCD Total |  |  | 1050
C345CDE | [NAME] | [NAME] | 50
C345CDE | [NAME] | [NAME] | 100
C345CDE | [NAME] | [NAME] | 100
C345CDE | [NAME] | [NAME] | 50
C345CDE | [NAME] | [NAME] | 150
C345CDE | [NAME] | [NAME] | 100
C345CDE | [NAME] | [NAME] | 50
C345CDE | [NAME] | [NAME] | 100
C345CDE | [NAME] | [NAME] | 100
C345CDE | [NAME] | [NAME] | 50
C345CDE | [NAME] | [NAME] | 75
C345CDE | [NAME] | [NAME] | 100
C345CDE | [NAME] | [NAME] | 150
C345CDE Total |  |  | 1175
Grand Total |  |  | 3625
Spreadsheet: 147118d1332530845-average-of-last-3-cells-in-a-range-dynamic-rollingaverage
Sheet: Sheet1

 |  |  |  | 12
 |  |  |  | 3MR |  | Jan | Feb | Mrt | Apr | [NAME] | Jun | Jul | Aug | Sep | Okt | Nov | Dec | Jan | Feb | Mrt | Apr | [NAME] | Jun | Jul | Aug | Sep | Okt | Nov | Dec
 |  |  |  |  |  | 10 | 20 | 30 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0