tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 65856d1266502702-displaying-a-value-when-there-is-a-value-in-another-cell-vehicle-operations-time-management-tool
Sheet: Sheet1

Vehicle Operator Time Management Tool
 | w/e | Worked Hours | Hide Column |  | Total Banked Hours
 |  |  | 120
 | 2010-02-27 00:00:00 | 20 | 140
 | 2010-03-06 00:00:00 |  | 180
 | 2010-03-13 00:00:00 |  | 220
 | 2010-03-20 00:00:00 |  | 260
 | 2010-03-27 00:00:00 |  | 300
 | 2010-04-03 00:00:00 |  | 340
 | 2010-04-10 00:00:00 |  | 380
 | 2010-04-17 00:00:00 |  | 420
 | 2010-04-24 00:00:00 |  | 460
 | 2010-05-01 00:00:00 |  | 500
 | 2010-05-08 00:00:00 |  | 540
 | 2010-05-15 00:00:00 |  | 580
 | 2010-05-22 00:00:00 |  | 620
 | 2010-05-29 00:00:00 |  | 660
 | 2010-06-05 00:00:00 |  | 700
 | 2010-06-12 00:00:00 |  | 740
 | 2010-06-19 00:00:00 |  | 780
 | 2010-06-26 00:00:00 |  | 820
 | 2010-07-03 00:00:00 |  | 860
 | 2010-07-10 00:00:00 |  | 900
 | 2010-07-17 00:00:00 |  | 940
 | 2010-07-24 00:00:00 |  | 980
 | 2010-07-31 00:00:00 |  | 1020
 | 2010-08-07 00:00:00 |  | 1060
 | 2010-08-14 00:00:00 |  | 1100
 | 2010-08-21 00:00:00 |  | 1140
 | 2010-08-28 00:00:00 |  | 1180
 | 2010-09-04 00:00:00 |  | 1220
 | 2010-09-11 00:00:00 |  | 1260
 | 2010-09-18 00:00:00 |  | 1300
 | 2010-09-25 00:00:00 |  | 1340
 | 2010-10-02 00:00:00 |  | 1380
 | 2010-10-09 00:00:00 |  | 1420
 | 2010-10-16 00:00:00 |  | 1460
 | 2010-10-23 00:00:00 |  | 1500
 | 2010-10-30 00:00:00 |  | 1540
 | 2010-11-06 00:00:00 |  | 1580
 | 2010-11-13 00:00:00 |  | 1620
 | 2010-11-20 00:00:00 |  | 1660
 | 2010-11-27 00:00:00 |  | 1700
 | 2010-12-04 00:00:00 |  | 1740
 | 2010-12-11 00:00:00 |  | 1780
 | 2010-12-18 00:00:00 |  | 1820
 | 2010-12-25 00:00:00 |  | 1860
 | 2011-01-01 00:00:00 |  | 1900
Spreadsheet: 143527d1330450992-reverse-geocoding-excel-help-see-attachment-geocode
Sheet: Sheet1

lat | long | Geocode | Need column C to be
41.39247 | -105.79 | 82070, WY | 82070
41.38997 | -105.73888 | 82070, WY | 82070
41.33025 | -106.24807 | 82055, WY | 82055
41.37191 | -106.25001 | 82055, WY | 82055
41.15664 | -105.79083 | 82070, WY | 82070
41.18553 | -105.72416 | 82070, WY | 82070
41.23803 | -105.83833 | 82070, WY | 82070
41.39692 | -105.63777 | 82072, WY | 82072
41.17192 | -105.71444 | 82070, WY | 82070
41.36831 | -105.77166 | 82070, WY | 82070
41.2428411917262 | -105.91889342167 | 82070, WY | 82070
41.14886 | -106.10446 | 82070, WY | 82070
41.35941 | -106.29641 | NF-346, Centennial, WY 82055 | 82055
41.35525 | -106.29807 | 82055, WY | etc
41.34553 | -106.32168 | 82055, WY
41.37358 | -106.26946 | 82055, WY
41.21525 | -105.82194 | Meeboer Rd, Laramie, WY 82070
41.3383 | -106.32002 | street, Centennial, WY 82055
41.21136 | -105.84555 | 82070, WY
41.37664 | -106.29724 | 82055, WY
41.22636 | -105.84444 | 82070, WY
41.63191 | -105.93278 | 82083, WY
41.38691 | -106.30446 | 82055, WY
41.2057235077393 | -106.258056612452 | 82070, WY
41.17637 | -105.72333 | 82070, WY
41.25692 | -105.70694 | 79 Gearhart Rd, Laramie, WY 82070
41.21442 | -105.80222 | 41.21442,-105.80222
41.36941 | -106.29918 | 82055, WY
41.12276 | -105.6511 | 82070, WY
41.36664 | -106.2689 | 82055, WY
42.2120550577241 | -105.717041587344 | 82058, WY
41.23831 | -105.86361 | 82070, WY
41.8505534346003 | -105.612631696209 | 82051, WY
41.12804 | -105.58249 | 82070, WY
Spreadsheet: stacey_white__38793__TXU Energy Trading as of 12-18
Sheet: TXU Energy Trading as of 12-18

 |  |  | Physical/ | 2001-12-01 00:00:00 |  | 2002-01-01 00:00:00 |  | 2002-02-01 00:00:00 |  | 2002-03-01 00:00:00 |  | 2002-04-01 00:00:00 |  | 2002-05-01 00:00:00 |  | 2002-06-01 00:00:00 |  | 2002-07-01 00:00:00 |  | 2002-08-01 00:00:00 |  | 2002-09-01 00:00:00 |  | 2002-10-01 00:00:00 |  | 2002-11-01 00:00:00 |  | 2002-12-01 00:00:00 |  | 2003-01-01 00:00:00 |  | 2003-02-01 00:00:00 |  | 2003-03-01 00:00:00 |  | 2003-04-01 00:00:00 |  | 2003-05-01 00:00:00 |  | 2003-06-01 00:00:00 |  | 2003-07-01 00:00:00 |  | 2003-08-01 00:00:00 |  | 2003-09-01 00:00:00 |  | 2003-10-01 00:00:00 |  | 2003-11-01 00:00:00 |  | 2003-12-01 00:00:00
Portfolio | Counterparty | Region | Financial | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Pk Prc PL | OPk Prc PL | Total
EAST | TXUENETRA | CINERGY | Physical |  |  | 62960.94 |  | -26802.12 |  |  |  |  |  |  |  | -33632.23 |  | -561868.68 |  | -560637
EAST | TXUENETRA | Entergy | Physical | 9902.78 |  |  |  |  |  |  |  |  |  |  |  |  |  | -1027954.51 |  | -1025555.56
EAST | TXUENETRA | Ercot South | Physical | 14574.66 | 56801.24 | 1085894.95 |  | 867709.88 |  | 2029770.74 |  | 2185595.72 |  | 255040 |  | -1067101.75 |  | 97461.9 |  | 97234.46 |  | -603150.61 |  | 1943781.71 |  | 1673341.4 |  | 1741053 |  | -85462.36 |  | -112997.53 |  | -170402.57 |  | -151379.59 |  | -71392.93 |  | 42340 |  | 103317.74 |  | 79170.67 |  | -133195.18 |  | -152225.66 |  | -153405.8 |  | -147447.07
EAST | TXUENETRA | INTO TVA | Physical |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 405732.27 |  | 404683.36
EAST | TXUENETRA | NEPOOL | Financial | 35327.75
EAST | TXUENETRA | NEPOOL | Physical | -259721.27 |  | -451452.27 |  | -409838.08 |  | -305009.31 |  | -318978.86 |  | -309671.1 |  | -292818.85 |  | -78506.23 |  | -78323 |  | -294701.83 |  | -687175.07 |  | -595940.7 |  | -623750.28
EAST | TXUENETRA | SOCO | Physical | 45960.09
EAST | TXUENETRA | WESTERN HUB | Physical | 4152.78 |  | -795538 | -47516.84 | -734014.59 | -59070 | -17883 | -88694.28 | -14280.86 | -85209.12 | -19599.44 | -96967.72 | 110646.8 | -71130.08 | -161766 | -58672.66 | -179923.14 | -58535.74 | -35317.13 | -93001.77 | 45545.16 | -82301.06 | 37471.46 | -76094.88 | 41942.19 | -75368.3
Grand Total:
Spreadsheet: 678875d1590091954-how-to-check-if-a-cell-contains-specific-text-and-then-copy-relevant-data-2-lists
Sheet: Sheet1

List 1 |  |  |  | List 2
Name | Calls |  |  | Name | Days | Calls (pull from the first list)
[NAME], [NAME] | 38 |  |  | [NAME] | 2
Smith, Jessica | 50 |  |  | [NAME] | 3
Arika, [NAME] | 39 |  |  | [NAME] | 1
Atiyeth, Emily | 25 |  |  | Emily Atiyeth | 4
Spreadsheet: 44245d1242886301-advanced-filter-and-latest-date-solution-advanced-filter-and-latest-date-excelforum
Sheet: Sheet1 (3)

Table 1 |  |  |  |  |  |  | Table 2
Always Sort on Last Name <Ascending> then Date Droped on Descending |  |  |  |  |  |  | Just enter the name here after sorting Table 1 or just enter smith again on left side table and after sorting these details will be updated automatically
Subject | Course # | Section | College ID | Last Name | Date Dropped |  | Last Name | College ID | Section | Course # | Course Name | Date Droped
NUR | 5063 | 3 | S456789 | Doe | 2009-05-04 00:00:00 |  | [NAME]
BUS | 4089 | 7 | S456789 | Doe | 2009-02-12 00:00:00 |  | jones |  |  |  |  |  |  | What I am starting out with:
CRI | 5497 | 5 | S456789 | Doe | 2009-01-25 00:00:00 |  | doe
CHM | 3201 | 9 | S987654 | Jones | 2009-05-06 00:00:00 |  | [NAME]
BIO | 4000 | 6 | S987654 | Jones | 2009-03-01 00:00:00
ENC | 1000 | 2 | S987654 | Jones | 2009-02-14 00:00:00
MKT | 1005 | 5 | S123456 | Smith | 2009-04-10 00:00:00
MAC | 2003 | 4 | S123456 | Smith | 2009-03-15 00:00:00
ENC | 1001 | 3 | S123456 | Smith | 2009-01-23 00:00:00
ENC | 1001 | 3 | S123456 | Smith | 2009-04-15 00:00:00
MAC | 2003 | 4 | S123459 | [NAME] | 2009-05-21 00:00:00
 |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/684572-advanced-filter-and-latest-date.html
Spreadsheet: 16b4a616-1021-4c69-ae5c-e115faa07167
Sheet: 2012 reading grade 7

[NAME] |  | Total Number | [NAME]
Grade 7 |  |  | Inconclusive | Exploring | Emerging | Developing | Novice | No Score
2010 | All Students | 578 | 12 | 22 | 22 | 31 | 6 | 7
2011 |  | 598 | 8 | 24 | 24 | 33 | 6 | 6
2012 | All Students | 556 | 11 | 23 | 21 | 33 | 8 | 4
 | Black/African American | 42 | 7 | 26 | 17 | 38 | 12
 | Hispanic/Latino | 185 | 11 | 25 | 21 | 29 | 7 | 6
 | White | 299 | 11 | 21 | 22 | 34 | 8 | 4
 | Minority | 257 | 11 | 25 | 20 | 31 | 7 | 5
 | English Learners | 82 | 4 | 29 | 26 | 29 | 5 | 7
 | Free/Reduced Lunch | 296 | 7 | 24 | 21 | 35 | 8 | 3
 | Female | 205 | 12 | 20 | 19 | 34 | 10 | 4
 | Male | 351 | 10 | 25 | 23 | 32 | 6 | 5
Spreadsheet: 119166d1314233700-tipout-sheet-issues-banquet-tip-distribution
Sheet: Sheet1

Banquet |  |  | Employee | Job | Hours Worked | Tips |  | Employees | Jobs | Base Rate | Bonus | Adj Rates | Portion
Date |  |  | [NAME] | Director | 10 | 100 |  | [NAME] | Director | 0.25 | 0 | 1 | 100
Tips | 100 |  | Gabe | Server |  |  |  | Gabe | Server | 0.3 | 0.3 | 0 | 0
Allotted | 100 |  | Kimmy | Server |  |  |  | Kimmy | Busser | 0.15 | 0.15 | 0 | 0
 |  |  | Kelly | Server |  |  |  | Kelly | Bartender | 0.15 | 0.15 | 0 | 0
 |  |  | [NAME] | Server |  |  |  | [NAME] | [NAME] | 0.1 | 0.1 | 0 | 0
 |  |  | [NAME] | Busser |  |  |  | [NAME] | Host | 0.05 | 0.05 | 0 | 0
 |  |  | [NAME] | Busser |  |  |  | [NAME]
 |  |  | Ian | Bartender |  |  |  | Ian
 |  |  | [NAME] | Bartender |  |  |  | [NAME]
 |  |  | [NAME] | Bartender |  |  |  | [NAME]
 |  |  | Ileah | Bartender |  |  |  | Ileah
 |  |  | Agustus | [NAME] |  |  |  | Agustus
 |  |  | [NAME] | [NAME] |  |  |  | [NAME]
 |  |  | Emily | Host |  |  |  | Emily
 |  |  | [NAME] | Host |  |  |  | [NAME]
Spreadsheet: 872999d1719436475-highlight-column-in-red-based-on-a-saturday-date-in-a-row-sample
Sheet: Sheet1

 | Date Started:
 | 100
 | 95
 | 90
 | 85
 | 80
 | 75
 | 70
 | 65
 | 60
 | 55
 | 50
 | 45
 | 40
 | 35
 | 30
 | 25
 | 20
 | 15
 | 10
 | 5
 | # Obs Day |  | 1 | 2 |  | 3 | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13 | 14 |  | 15 | 16 | 17 | 18 | 19 | 20
 | Date:
Spreadsheet: kate_symes__18329__DJ Index 4-25
Sheet: Sheet1

Electricity Price Index Report
Rep. [NAME]: | 2001-04-25 00:00:00
Flow Date: | 2001-04-25 00:00:00
From: | Enron Power Marketing Inc. - Kate Symes
Phone: | (800) 464-7486
Fax: | (503) 464-3740
To: | [NAME] or [NAME]
Phone: | (609) 520-4683 ([NAME])
Phone: | (609) 520-4663 (Earnest Onukogu)
Fax: | (609) 452-3531
COB
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
MID COLUMBIA
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 314.2356687898089 | 5024
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | 195 | 600
 | Firm Trades Purchases | #[NAME]! | 0
PALO VERDE
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 293.0980392156862 | 4080
 | Firm Trades Purchases | 290.125 | 3200
[NAME] | Firm Trades Sales | 99.02843601895736 | 2376
 | Firm Trades Purchases | 98.75 | 400
MEAD
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 111.9148936170213 | 376
NP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 293.0113636363636 | 7040
 | Firm Trades Purchases | 294.8 | 2000
[NAME] | Firm Trades Sales | 183.6 | 2000
 | Firm Trades Purchases | 179 | 1200
SP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 281.7142857142857 | 2800
 | Firm Trades Purchases | 276.1016949152542 | 944
[NAME] | Firm Trades Sales | 120.578947368421 | 3800
 | Firm Trades Purchases | 118.8333333333333 | 240
Spreadsheet: 541819d1507564556-percentage-of-time-positive-dynamic-formula-help-percent-positive-help
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 year | 10 year
 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 |  | Average | Average | Average |  | % Positive | % Positive | % Positive
JAN | -0.01883827907075064 | -0.01020408806163819 | -0.04461937046702091 | -0.02608693138241658 | -0.0137931606384889 | -0.01873540247531824 | -0.02824856475453386 | 0.02710843373493965 | 0.01751713632901741 | 0.0913884007029877 | -0.04342273307790545 | -0.08174273858921155 | -0.06099314778783516 | 0.01013787510137876 | -0.0698576972833117 | 0.02790300962592918 | -0.06129032258064515 | -0.04658026433979223 | -0.05538425047438311 | -0.06517205422314909 | -0.02636990443933718 | 0.01877172653534198 | 0.06093233818671218 | 0.08292945611200864 | -0.08598930481283429 | -0.01229308666017515 | 0.00238980350504514
Spreadsheet: 840020d1692364267-sum-product-with-merged-cells-sumproduct-merged-cell-1-
Sheet: Employee Name

Name | Rate
[NAME] | 100
McDonaldtrut Ellie | 61
[NAME] | 54
[NAME] | 81
[NAME] | 30
[NAME] | 44
[NAME] | 96
[NAME] | 38
Myerstrut [NAME] | 38
[NAME] | 80
[NAME] | 23
[NAME] | 18
Okpevbatrut Victor | 66
[NAME] | 68
[NAME] | 95
[NAME] | 50
Norristrut Robert | 59
[NAME] | 76
Mairtrut Ruairidh | 32
[NAME] | 79
[NAME] | 30
Spreadsheet: 798683d1664640064-formula-to-calculate-how-many-people-attended-2-named-events-from-a-single-list-test-sheet
Sheet: Sheet1

My Data |  |  | What I want to show:
Name | Event |  |  | No of shared attendees
[NAME] | A |  | Event 1 | Event 2 | No of Attendees | notes:
[NAME] | B |  | A | B | 2 | [NAME] and [NAME]
[NAME] | C |  | A | C | 0
[NAME] | A |  | A | D | 1 | [NAME]
[NAME] | B |  | B | C | 0
[NAME] | D |  | B | D | 0
[NAME] | B |  | C | D | 0
Spreadsheet: 855616d1705134144-groupby-formula-but-sort-with-last-column-of-the-dataset-pivotby-aligw
Sheet: Formula

 |  |  | 1 | 3 | Total | <<<I need to sort this
 | 1620 | 3110 | 10292.19 |  | 10292.19
 | 1210 | 1410 | 10000 |  | 10000
 | 1110 | 3210 | 4494.5 |  | 4494.5
 | 3110 | 1210 | 2208.5 |  | 2208.5
 | 8210 | 1220 |  | 1879.74 | 1879.74
 | 3340 | 3390 | 1621.58 |  | 1621.58
 | 3110 | 1430 | 396.3 |  | 396.3
 | 1430 | 1210 | 380 |  | 380
 | 3340 | 3110 | 377.59 |  | 377.59
 | 7390 | 1620 | 247.03 |  | 247.03
 | 1430 | 1110 | 186 |  | 186
 | 7140 | 3110 | 13.81 |  | 13.81
 | 7380 | 1210 | 1 |  | 1
 | Total |  | 30218.5 | 1879.74 | 32098.23999999999
Spreadsheet: 76517d1277077386-count-sequential-zeros-in-a-column-example
Sheet: Sheet1

Day | What I need the column to show
0
0
0
0
0
0
0 | 7
2
3
6
5
2
0
0
0 | 3
2
6
6
4
0
0
0
0 | 4
Spreadsheet: 220d2fd6-c537-4492-9892-8fb0abaf389d
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
 | 8731.0 Building Approvals, Australia
 | TABLE 21. Value of Dwelling Units Approved in New Residential Buildings, Original, Australia
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
Value of Approval ;  New ;  Total houses ; |  |  | Original | A418405W | 1970-07-01 00:00:00 | 2011-04-01 00:00:00 | 490 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Semi-detached, row or terrace house, townhouse with one storey and similar ; |  |  | Original | A415787K | 1991-07-01 00:00:00 | 2011-04-01 00:00:00 | 238 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Semi-detached, row or terrace house, townhouse with two or more storeys ; |  |  | Original | A422928K | 1991-07-01 00:00:00 | 2011-04-01 00:00:00 | 238 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total semi-detached, row or terrace houses, townhouses and similar ; |  |  | Original | A416423R | 1991-07-01 00:00:00 | 2011-04-01 00:00:00 | 238 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Flat, unit or apartment in a building of one or two storeys ; |  |  | Original | A423531F | 1991-07-01 00:00:00 | 2011-04-01 00:00:00 | 238 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Flat, unit or apartment in a building of three storeys ; |  |  | Original | A424176T | 1991-07-01 00:00:00 | 2011-04-01 00:00:00 | 238 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Flat, unit or apartment in a building of four or more storeys ; |  |  | Original | A424728C | 1991-07-01 00:00:00 | 2011-04-01 00:00:00 | 238 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total flats, units or apartments, excl. [NAME] flats and other/unknown ; |  |  | Original | A417065V | 1991-07-01 00:00:00 | 2011-04-01 00:00:00 | 238 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total other residential building ; |  |  | Original | A419140V | 1970-07-01 00:00:00 | 2011-04-01 00:00:00 | 490 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total residential building ; |  |  | Original | A419826L | 1956-01-01 00:00:00 | 2011-04-01 00:00:00 | 664 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 4d1f27cc-c276-49d9-8f14-d699839c0589
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8655 | 41579 | Ece | [NAME] | TUR | 4 | [NAME] | 00:00:19 | 00:38:57 | 00:00:19 | 00:21:27 | 1 | 01:12:21
8655 | 53569 | Stefania | Ion | [NAME] | 3 | 00:10:50 | 00:00:20 | 00:39:30 | 00:00:20 | [NAME] | 2 | 01:12:39
8655 | 9838 | [NAME] | [NAME] | TUR | 2 | 00:11:26 | 00:00:20 | 00:38:56 | [NAME] | 00:22:40 | 3 | 01:13:50
8655 | 41778 | Rositsa | Petrova | BUL | 5 | [NAME] | 00:00:28 | 00:44:04 | 00:00:25 | 00:23:00 | 4 | 01:20:31
Spreadsheet: 0f4f8742-182a-48b3-8d67-a2e40d957c98
Sheet: Apple

Mt San Jacinto Community College
Fiscal Year 2013-2014
Tentative Fixed Costs & H&W Object Codes
Instructions:
1. Determine employee's object code.
2. Enter salary amount in box below "Salary".
3. [NAME] will calculate amount of fixed costs on that salary and will give you a total.
Non-Instructional Certificated |  |  |  | Instructional |  |  |  | Non-Instructional Classified
12XX APPLE |  |  |  | 11XX APPLE          22XX APPLE |  |  |  | 21XX APPLE
14XX APPLE |  |  |  | 13XX APPLE          24XX APPLE |  |  |  | 23XX APPLE
Description | Object Code | % of Wages |  | Description | Object Code | % of Wages |  | Description | Object Code | % of Wages
APPLE | 3362 | 0.0375 |  | APPLE | 3360 | 0.0375 |  | APPLE | 3361 | 0.0375
MEDICARE | 3335 | 0.0145 |  | MEDICARE | 3315 | 0.0145 |  | MEDICARE | 3325 | 0.0145
UNEMPLOYMENT | 3530 | 0.0005 |  | UNEMPLOYMENT | 3510 | 0.0005 |  | UNEMPLOYMENT | 3520 | 0.0005
WORKER'S COMP | 3630 | 0.02331 |  | WORKER'S COMP | 3610 | 0.02331 |  | WORKER'S COMP | 3620 | 0.02331
Salary: |  |  |  | Salary: |  |  |  | Salary:
16000 | 3362 |  |  |  | 3360 |  |  |  | 3361
 | 3335 |  |  |  | 3315 |  |  |  | 3325
 | 3530 |  |  |  | 3510 |  |  |  | 3520
 | 3630 |  |  |  | 3610 |  |  |  | 3620
 | Total |  |  |  | Total |  |  |  | Total
Spreadsheet: 868128d1714869911-power-query-nested-subgroups-index-on-3-sublevels-cost-centre-master-example-with-proper-data-set
Sheet: Buildsoft upload mapping

BuildSoft Upload - Note: Upload expects data to start on row 1 - therefore delete header rows before uploading.
Trade Code | Description | Item Code / Cost Code | Sub Item | Margin % | Resource | Quantity | UOM | Rate | Value | Item Overhead | Margin | Cost Code | Cost Type | Tender Estimate | Produce Code
19 A | 240 A | 08:00:00 | 05:00:00 | 05:00:00 | 10:00:00 | 15.4 N | 05:00:00 | 15.4 N | 15.4 N | 15.4 N | 15.4 N | 08:00:00 | 02:00:00 | 15.4 N | 16 A
Used for SOR Projects. Not used for Lump Sup Projects | HC Claim Item Description | HC Claim Item (Can be configured to equal Cost Code from Col M) | Used for SOR Projects. Not used for Lump Sup Projects | NotUsed | If cost code is blank  then this will be the cost code. Not used for SOR and earned budget job upload | HC Claim & CC Qty | HC Claim & CC UOM | HC Claim & CC Rate | HC Claim & CC Value Budget (Qty x Rate) | This column is added to Item Value tocaluclate HC Sell Price | This is used as check. It should equal to Item Value - Item Overhead - Total Budget. | Cost Code | Cost Type | Item Budget | PO Product code
Note: Trade Code, Item Code and Sub Item are used for SOR Jobs and earnedbudget job. Jobs that are not SOR and earned budget, trade code is not used and item code is set to cost code when position 11 of JBINTF parameter = Y.
Margin % - Not used in any of the buildsoft program
Claim structure will be updated
Full PMW Scope will be updated with scope of work if the Sub item is used with same CC. If Sub item is not used then Cost values will go directly into the Cost Code files.
Pending PO's will be created if the Product code is used.
Spreadsheet: 7ad3b77e-4d42-42a9-a2d9-95f09de702c1
Sheet: Sheet1

Release: Quarterly Retail E-Commerce Sales | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=179
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-04-19 10:58 PM CDT
 | Real-Time | Period
Name: | Start | End
Quarterly Retail E-Commerce Sales | 2009-02-17 00:00:00 | Current
Link:
http://www.census.gov/mrts/www/ecomm.html | 2009-02-17 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2009-02-17 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:
2009-02-17 00:00:00
2009-05-15 00:00:00
2009-08-17 00:00:00
2009-11-18 00:00:00
2010-02-16 00:00:00
2010-05-18 00:00:00
2010-08-17 00:00:00
2010-11-17 00:00:00
2011-02-17 00:00:00
2011-05-16 00:00:00
2011-08-16 00:00:00
2011-11-17 00:00:00
2012-02-16 00:00:00
2012-05-17 00:00:00
2012-08-16 00:00:00
2012-11-16 00:00:00
2013-02-15 00:00:00
2013-05-15 00:00:00
2013-08-15 00:00:00
2013-11-22 00:00:00
2014-02-18 00:00:00
Spreadsheet: gerald_nemec__11453__Project Cost and Projections thru September 14-2pm
Sheet: Sheet1

 |  |  | Approved | Work Orders | Work Orders | Work Orders | Work Orders | Work Orders |  | Work Orders
System Name | Account Number | System Number | Capital Cost | Capital Cost | Capital Cost | Capital Cost | Capital Cost | Accrual for Mat.&Labor |  | Estimate at
 |  |  | RAROC | Approved | Thru June 30th | 6-30 to 8-31 | 9-01 to 9-14 | 9-01Thru 9-22 |  | Completion
House Creek | 11025 | 100 | 11944234 | 5151501 | 2930353 | 2800.93 | 1000 | 4000 |  | 11944234
Caballo Lateral | 11026 | 200 | See Note 2 | 2511400 | 2703658 | 59226.71 | 0 | 10000 |  | 2800000
Caballo Compression | 11026 | 200 | 8062497 | 5740000 | 6498109 | 830965.79 | 29755.53 | 550000 |  | 8100000
Clydesdale | 11027 |  | 3254256 | 3370675 | 933169 | 908792.28 | 31608.66 | 720000 |  | 3254256
South Kitty | 11028 |  | 7462998 | 9413156 | 1500547 | 1633846.33 | 99427.73 | 1500000 |  | 7462998
Hoe Creek | 11029 |  | 6735882 | 4661220 | 654157 | 132485.16 | 1514.45 | 350000 |  | 6735882
[NAME] | 11030 | 400 | 6707026 | 7053775 | 7402549 | 207279.48 | 3403 | 90000 |  | 8000000
Maverick | 11030 | 300 | 1650000 | See Note 1 | See Note 1 | See Note 1 | See Note 1 | See Note 1 |  | See Note 1
Kudzu |  |  | 4729128 | 0 | 0 | 0 | 0 | 0 |  | 7153363
Fort Union Receipt Points |  |  | 676713 | 1194000 | 1104406 | 129320.45 | 1882.94 | 12000 |  | 1325000
 |  | Grand Total =
Note 1:  All of Maverick's Capital cost is included in the Box Draw work order.
Note 2:  This cost was included in the Caballo Compression RAROC number.