tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 765855d1643642090-compare-2-columns-on-multiple-values-kopie-van-exdata2
Sheet: Last Month

Product | Subscription key | Company | Usage | Total seats
Product1 | abc123 | Comp1 | 10 | 20
Product2 | def456 | Comp1 | 4 | 5
Product1 | ghi789 | Comp1 | 4 | 4
Product3 | jkl123 | Comp1 | 1 | 1
Product2 | mno456 | Comp1 | 19 | 19
Product1 | pqr789 | Comp1 | 1 | 1
Product2 | stu123 | Comp1 | 5 | 5
Product1 | vwx456 | comp2 | 25 | 25
Product3 | yza789 | comp3 | 4 | 4
Product2 | bcd123 | comp2 | 18 | 20
Product1 | efg456 | comp2 | 42 | 46
Product2 | hij789 | comp3 | 9 | 9
Product1 | klm123 | comp2 | 31 | 36
Product3 | nop456 | comp3 | 19 | 19
Product2 | qrs789 | comp2 | 2 | 2
Product1 | tuv123 | comp2 | 4 | 4
Product2 | wxy456 | comp3 | 2 | 2
Spreadsheet: fletcher_sturm__10990__1019 Cash Sheet
Sheet: Sheet1

2001-10-19 00:00:00
Cinergy |  |  |  | Entergy
 | bid | offer |  |  | bid | offer
 |  |  |  | 2001-10-22 00:00:00 | 19.5 | 21.5
2001-10-22 00:00:00 | 19 | 21 |  | Oct 23-Oct 26, 2001 | 20.5 | 21.55
Oct 23-Oct 26, 2001 | 21.2 | 22 |  | Oct 29-Oct 31, 2001 | 20.75 | 21.55
Oct 29-Oct 31, 2001 | 22.7 | 23.5 |  | November, 2001 | 21.6 | 22.25
November, 2001 | 22.8 | 23.5 |  | December, 2001 | 23 | 23.65
December, 2001 | 26 | 26.8 |  | Jan/Feb 2002 | 24.7 | 25.5
Jan/Feb 2002 | 28.15 | 28.9 |  | March/April , 2002 | 23.6 | 24.4
Cal 2001 | 32 | 33 |  | May, 2002 | 25.7 | 26.5
March/April , 2002 | 26.2 | 26.9 |  | June, 2002 | 34.7 | 35.65
May, 2002 | 28.5 | 29.5 |  | July/August, 2002 | 44.4 | 45.3
June, 2002 | 38.5 | 39.5 |  | Sept, 2002 | 23.5 | 24.3
July/August, 2002 | 50 | 51 |  | Q4, 2002 | 24.4 | 25.3
Sept, 2002 | 26.4 | 27 |  | Jan/Feb, 2003 | 26.4 | 27.4
Q4, 2002 | 27.15 | 27.8 |  | March/April, 2003 | 26 | 26.9
Cal 2003 | 32.25 | 33.5 |  | July/August, 2003 | 41.5 | 42.7
Cal 2004 | 33.5 | 34.75 |  | Q4, 2003 | 26.7 | 28.15
Cal 2005 | 33.25 | 35.25 |  | Cal, 2004 | 30.75 | 32.5
Comed |  |  |  | TVA
 | bid | offer |  |  | bid | offer
 |  |  |  | 2001-10-22 00:00:00 | 21 | 21.8
 |  |  |  | Oct 23-Oct 26, 2001 | 21 | 22
 |  |  |  | Oct 29-Oct 31, 2001 | 22.5 | 23.5
2001-10-22 00:00:00 | 19 | 20
Oct 22-Oct 26, 2001 | 20.3 | 21.3 |  | November, 2001 | 22.4 | 23.2
Oct 29-Oct 31, 2001 | 21.5 | 22.4 |  | December, 2001 | 25 | 26
November, 2001 | 21.75 | 22.6 |  | Jan/Feb 2002 | 27.2 | 28
December, 2001 | 24.15 | 25.15 |  | Cal 2002 | 30.75 | 32
Jan/Feb 2002 | 26.5 | 27.4 |  | March/April , 2002 | 25.25 | 26.2
Jul/Aug 2002 | 48 | 49 |  | May, 2002 | 27.25 | 28.75
 |  |  |  | June, 2002 | 36.25 | 37.5
 |  |  |  | July/August, 2002 | 47.75 | 49
 |  |  | 26.5 | Sept, 2002 | 24.7 | 25.5
 |  |  |  | Q4, 2002 | 25.2 | 26.5
 |  |  |  | Cal 2003
PJM |  |  |  | SOCO
 | bid | offer |  |  | bid | offer
 |  |  |  | 2001-10-22 00:00:00 | 27.5 | 28.5
 |  |  | 52.75 | Oct 23-Oct 26, 2001 | 27 | 28
2001-11-01 00:00:00 | 27 | 27.9 |  | Oct 29-Oct 31, 2001 | 27 | 28
December, 2001 | 29.4 | 30.45 |  | November, 2001 | 27.25 | 28
 |  |  |  | December, 2001 | 28.5 | 29.25
Jan/Feb 2002 | 34 | 34.95 |  | Jan/Feb 2002 | 31.8 | 32.5
Cal 2002 |  |  |  | Cal 2002
March/April , 2002 | 31.4 | 32.3 |  | March/April , 2002 | 29.1 | 29.85
May, 2002 | 34.6 | 35.3 |  | May, 2002 | 31.7 | 32.5
June, 2002 | 44.75 | 45.6 | 91 | June, 2002 | 41.8 | 42.55
July/August, 2002 | 57 | 57.75 |  | July/August, 2002 | 52.6 | 53.5
Sept, 2002 | 30.75 | 31.4 |  | Sept, 2002 | 27.75 | 28.55
Q4, 2002 | 31.1 | 31.6 |  | Q4, 2002 | 27.8 | 28.5
Cal 2003 | 38.1 | 39 |  | Jan/Feb 2003 | 32.15 | 33
Cal 2004 | 38 | 39 |  | March/April, 2003 | 30 | 30.8
 |  |  |  | May, 2003 | 31.9 | 32.8
 |  |  |  | June, 2003 | 41.2 | 42
Spreadsheet: e456dc50-7063-4aa3-ab85-4cc8789fcd75
Sheet: Sheet1

Table 5--Corn: Food, seed, and industrial use (million bushels), 4/11/2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Mkt year and qtr 1/ |  | High-fructose corn syrup (HFCS) | Glucose and dextrose | Starch | Alcohol for fuel | Alcohol for beverages and manufacturing | Cereals and other products | Seed | Total food, seed, and industrial use
2011/12 | Q1 Sep-Nov | 119.625 | 77.996 | 64.647 | 1265.728 | 33.302 | 50.732 | 0 | 1612.03
 | [NAME] | 114.982 | 73.408 | 62.037 | 1303.844 | 34.93 | 50.732 | 0 | 1639.933
 | [NAME] | 136.825 | 72.97 | 62.152 | 1243.296 | 36.586 | 50.531 | 23.565 | 1625.925
 | [NAME] | 141.939 | 72.374 | 65.177 | 1187.164 | 31.682 | 51.234 | 0.963 | 1550.533
 | MY Sep-Aug | 513.371 | 296.748 | 254.013 | 5000.032 | 136.5 | 203.229 | 24.528 | 6428.421
2012/13 | Q1 Sep-Nov | 123.067 | 70.385 | 63.98 | 1124.38 | 34.156 | 52.401 | 0 | 1468.369
 | [NAME] | 113.437 | 67.359 | 59.151 | 1109.854 | 35.826 | 52.286 | 0 | 1437.913
 | [NAME] | 126.318 | 72.48 | 62.195 | 1193.06 | 37.524 | 52.836 | 22.366 | 1566.779
 | [NAME] | 128.199 | 73.914 | 62.359 | 1221.159 | 32.494 | 52.896 | 2.215 | 1573.236
 | MY Sep-Aug | 491.021 | 284.138 | 247.685 | 4648.453 | 140 | 210.419 | 24.581 | 6046.297
2013/14 | Q1 Sep-Nov | 113.429 | 71.108 | 60.806 | 1224.188 | 34.208 | 51.155 | 0 | 1554.894
 | [NAME] | 110.117 | 73.265 | 60.471 | 1270.336 | 35.852 | 51.02 | 0 | 1601.061
 | MY Sep-Aug | 500 | 280 | 250 | 5000 | 140 | 205.35 | 24.65 | 6400
1/ September-August.  Latest data may be preliminary or projected. Source: Calculated by USDA, Economic Research Service.
Date run: 4/10/2014
Spreadsheet: 823525d1680000622-conditional-format-date-date-deadline-red-or-green-deadlines-etaf
Sheet: Sheet1

Pre-Permit Walk Round |  |  |  |  |  | Permit Approval |  |  |  |  | Permit Closed Perameters
ID | Name | Date | Name | Date | Comments | Permit Number | Date | Permit Issuer | Date | Comments | Permit Number | Date | Permit Issuer | Date | Comments
Pre-walk ID | Issuer | Raised | PTWO | Completed |  | Permit | Raised | Raised by | Approved |  | Permit | Closed | Closed by | Approver Sign
 |  | 2023-03-01 00:00:00 |  |  |  |  | 2023-03-01 00:00:00
 |  | 2023-03-01 00:00:00
 |  | 2023-03-01 00:00:00
Spreadsheet: 126847d1320004482-transpose-help-please-transpose-102
Sheet: Sheet1

Hardware EDC | Service Plan |  | Hardware EDC | Service Plan | Service Plan | Service Plan
1320161 | 2068256 |  | 1320161 | 2068256 | 2078621 | 2078630
1320161 | 2078621 |  | 2497201 | 1 | 2 | 3
1320161 | 2078630 |  | 2233635 | 2068256 | 2078621 | 2078630
2497201 | 1 |  | GGG | VVVV | WWW | XXXX
2497201 | 2
2497201 | 3
2233635 | 2068256
2233635 | 2078621
2233635 | 2078630
GGG | VVVV
GGG | WWW
GGG | XXXX
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
Spreadsheet: cf4345e0-0333-4a81-bdde-671f5e86f5df
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | FT 7
Appendix 1
Ebert Ave & Robinson St Watermain Replacements
Contract 89012A
SCHEDULE OF QUANTITIES AND PRICES
(see paragraph 5.3.1 of the Instruction to Tenderers - Part II)
(All Tender and Contract Prices shall NOT include taxes.  HST will apply upon invoice and payment)
Should there be any discrepancy in the information provided, the City's original file copy shall prevail.
Master Municipal Specifications           Division 1 - GENERAL REQUIREMENTS
 | 1535 | Temporary Facilities | Incidental to Contract
 | 1561 | Environmental Protection | Incidental to Contract
 | 1570 | Traffic Control | Incidental to Contract
Master Municipal Specifications           Division 2 - SITE WORKS
ITEM No. | MMCD/   [NAME]. Spec. | [NAME] | UNIT | QTY | UNIT   PRICE | EXTENDED AMOUNT
1 | 2221 | ROCK REMOVAL
1.01 | 1.6 | Rock removal c/w offsite disposal & backfilling (Provisional) | cu.m. | 4
2 | 2223 | EXCAVATING, TRENCHING, & BACKFILLING
2.01 | 1.10.3 | Overexcavation  (Provisional) | cu.m. | 10
2.02 | 1.10.9 | Add Import Trench Backfill (Provisional) | tonne | 100
3 | 2512 | ASPHALT CONCRETE PAVING
3.01 | 1.5.1 | Permanent Trench Patch  - Robinson St. (35mm key & overlay) | tonne | 25
4.01 | 2666 | WATERWORKS
4.01 | 1.8.2 | 150mm CL 50 DI Pipe | [NAME]. m. | 15
4.02 | 1.8.2 | 300mm CL 50 DI Pipe | [NAME]. m. | 265
4.03 | 1.8.3 | 150mm DI Gate Valves | each | 1
4.04 | 1.8.3 | 300mm DI Gate Valves | each | 3
4.05 | 1.8.3 | 300 x 300 x 300 DI Tee | each | 1
4.06 | 1.8.3 | 300 x 300 x 150 DI Tee | each | 2
4.07 | 1.8.3 | 150mm 45° DI Bend | each | 2
4.08 | 1.8.3 | 300mm 45° DI Bend | each | 2
4.09 | 1.8.3 | 300mm X 150mm Reducer | each | 1
4.1 | 1.8.4.2 | New Hydrant Assembly c/w Storz Nozzle | each | 2
4.11 | 1.8.4.1 | Remove Existing Hydrant Assembly | each | 2
4.12 | 1.8.5.1 | Replace Service Connection (19mm) | l.m. | 164
4.13 | 1.8.5.1 | Extend Ex. Service Connection c/w fiitings (19mm) | l.m. | 12
4.14 | 1.8.5.1 | [NAME] with Nelson Box & Riser Pipe -supply & install | each | 17
4.15 | 1.8.5.2 | Transfer Ex. Service Connection c/w fittings (19mm) | each | 1
4.16 | 1.8.14 | Tie-in & Cap Existing 300mm W/M on Robinson St. (North) | l.s. | 1
4.17 | 1.8.14 | Tie-in & Cap Existing 150mm W/M on Robinson St. (South) | l.s. | 1
4.18 | 1.8.14 | Tie-in & Cap Existing 300mm W/M on Ebert Ave (East) | l.s. | 1
4.19 | 1.8.14 | Tie-in & Cap Existing 300mm W/M on Ebert Ave (536 Ebert) | l.s. | 1
4.2 | 1.8.14 | Tie-in Existing 300mm & Cap 150mm W/M on Ebert Ave (West) | l.s. | 1
4.21 | 1.8.15 | Valve Box Removal & Restoration | each | 4
Transfer TOTAL amount to Page FT.1 - Summary (exclude HST) |  |  |  |  | TOTAL
Spreadsheet: 85e4d824-b997-4a48-880f-5bad8d800c14
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
08/23/2014 | Volleyball | Gold-Blue Scrimmage | 04:00 PM
08/29/2014 | Volleyball | BYU (Gold & Blue Player's Challenge) | 07:00 PM | L, 0-3
08/30/2014 | Volleyball | Toledo (Gold & Blue Player's Challenge) | 02:00 PM | W, 3-0
08/30/2014 | Volleyball | IUPUI (Gold & Blue Player's Challenge) | 07:00 PM | W, 3-0
09/01/2014 | Volleyball | at [NAME] | 06:00 PM | W, 3-0
09/05/2014 | Volleyball | vs. Gardner-Webb ([NAME]) | 01:00 PM | W, 3-0
09/05/2014 | Volleyball | at [NAME] (Niagara Invitational) | 06:00 PM | W, 3-0
09/06/2014 | Volleyball | vs. Providence ([NAME]) | 11:00 AM | W, 3-0
09/12/2014 | Volleyball | [NAME] (Mountaineer Invitational) | 12:00 PM | W, 3-1
09/12/2014 | Volleyball | [NAME] (Mountaineer Invitational) | 07:00 PM | W, 3-0
09/13/2014 | Volleyball | St. Francis (Mountaineer Invitational) | 12:00 PM | W, 3-1
09/13/2014 | Volleyball | Montana (Mountaineer Invitational) | 07:00 PM | W, 3-0
09/19/2014 | Volleyball | at Duke (ACC-Big 12 Challenge) | 06:30 PM | L, 1-3
09/20/2014 | Volleyball | at UNC (ACC-Big 12 Challenge) | 06:00 PM
09/24/2014 | Volleyball | Texas* | 07:00 PM
09/27/2014 | Volleyball | at Texas Tech* | 02:00 PM
10/01/2014 | Volleyball | at [NAME] | 06:30 PM
10/04/2014 | Volleyball | at Iowa State* | 02:00 PM
10/08/2014 | Volleyball | Oklahoma* | 06:30 PM
10/11/2014 | Volleyball | TCU* | 02:00 PM
10/15/2014 | Volleyball | Kansas* | 06:30 PM
10/22/2014 | Volleyball | at Baylor* | 07:00 PM
10/25/2014 | Volleyball | Kansas State* | 05:00 PM
10/29/2014 | Volleyball | at TCU* | 07:30 PM
11/01/2014 | Volleyball | at Oklahoma* | 08:00 PM
11/08/2014 | Volleyball | Iowa State* | 04:00 PM
11/12/2014 | Volleyball | at Texas* | 08:00 PM
11/15/2014 | Volleyball | Texas Tech* | 03:30 PM
11/22/2014 | Volleyball | Baylor* | 06:30 PM
11/26/2014 | Volleyball | at Kansas* | 07:00 PM
11/29/2014 | Volleyball | at Kansas State*
12/05/2014 | Volleyball | NCAA First and Second Rounds
12/12/2014 | Volleyball | NCAA Regional Semifinals
12/18/2014 | Volleyball | [NAME]
Spreadsheet: 216315d1361715387-help-with-vlookup-formula-bikes
Sheet: Sheet1

ram | pulsar
vivek | pulsar
vikas | pulsar
suraj | Passion
vikas | Passion
prashant | Passion
vivek | Karizma
ram | Karizma
sunil | Karizma
suhas | Unicorn
mayur | Unicorn
ram | Unicorn
vikas | Splender
prashant | Splender
suhas | Splender
Spreadsheet: 143138d1330222811-how-to-calculate-difference-of-time-from-simple-text-and-add-multiply-time-time-1-
Sheet: Sheet1

shift time |  | # of shifts per pay period | hours per shift | hours per pay period
 |  |  |  | = shifts  x  hours
Start Time | End Time
14:00:00 | 22:00:00 | 8
17:30:00 | 1900-01-01 06:20:00 | 8
11:30:00 | 18:12:00 | 7
11:00:00 | 18:12:00 | 9
Spreadsheet: 692140d1598112212-creating-student-ids-from-student-information-excel-josiah670-
Sheet: Sheet1

Date requested | ID | First name | Last Name | Date of Birth |  |  |  |  | Place of Birth | Agent | School | Program | Visa | Notes
2020-03-16 00:00:00 |  | [NAME] | Smith | 05-07-1990
2020-03-16 00:00:00 |  | [NAME] | Smith | 26-05-2001
2020-03-17 00:00:00 |  | [NAME] | [NAME] | 03-02-1997
2020-03-17 00:00:00 |  | [NAME] | [NAME] | 01-02-1994
2020-03-17 00:00:00 |  | [NAME] | Scott | 21-09-2000
2020-03-17 00:00:00 |  | Sasha | Scott | 19-01-2001
2020-03-17 00:00:00 |  | [NAME] | Atwood | 25-12-2000
2020-03-17 00:00:00 |  | Sara | Atwood | 17-04-2002
2020-03-18 00:00:00 |  | [NAME] | Jones | 23-03-1994
2020-03-18 00:00:00 |  | Sara | Jones | 23-06-2001
2020-03-19 00:00:00 |  | Bethany | Swim | 23-09-1996
2020-03-20 00:00:00 |  | Jake | Swim | 02-02-1996
2020-03-20 00:00:00 |  | [NAME] | Swim | 24-08-2001
2020-03-23 00:00:00 |  | Maria | Pirell | 26-04-2001
Spreadsheet: 05a736a3-7b5a-4238-a833-54cfdb7dca6c
Sheet: Exhibit XVII, Sheet 6, pg 1

Owners Forms
USAA
Pennsylvania
Claims, Losses, & Expense Summary
 |  | Incurred Loss & LAE (excl IBNR)
 |  | (incl [NAME])
Accident Year | as of | 15 Months | 27 Months | 39 Months | 51 Months
2001-06-30 00:00:00 |  | 10940100 | 11160638 | 11168421 | 11300133
2002-06-30 00:00:00 |  | 7973667 | 8269921 | 8368627 | 8102234
2003-06-30 00:00:00 |  | 9341307 | 9452364 | 9502201 | 9486909
2004-06-30 00:00:00 |  | 9758762 | 9690183 | 10452984 | 10481479
2005-06-30 00:00:00 |  | 11399057 | 11312748 | 11214332 | 11208149
2006-06-30 00:00:00 |  | 9971076 | 10690091 | 11017157 | 10890787
2007-06-30 00:00:00 |  | 14921437 | 15643482 | 15673584 | 15882395
2008-06-30 00:00:00 |  | 14029833 | 14591034 | 14954310 | 14872241
2009-06-30 00:00:00 |  | 17309237 | 17665924 | 18413252 | 18680511
2010-06-30 00:00:00 |  | 28019831 | 31176155 | 32140626
2011-06-30 00:00:00 |  | 22732336 | 25602201
2012-06-30 00:00:00 |  | 28447109
 |  | Incurred Loss & LAE (excl IBNR)
 |  | (excl [NAME])
Accident Year | as of | 15 Months | 27 Months | 39 Months | 51 Months
2001-06-30 00:00:00 |  | 10462168 | 10657055 | 10664839 | 10796550
2002-06-30 00:00:00 |  | 7803633 | 8095110 | 8193817 | 7927423
2003-06-30 00:00:00 |  | 8170713 | 8208417 | 8270503 | 8255211
2004-06-30 00:00:00 |  | 7973527 | 7909922 | 8670994 | 8721946
2005-06-30 00:00:00 |  | 9887088 | 9792519 | 9693921 | 9682771
2006-06-30 00:00:00 |  | 9061650 | 9817686 | 10136306 | 10007168
2007-06-30 00:00:00 |  | 13607062 | 14301862 | 14331964 | 14540775
2008-06-30 00:00:00 |  | 13530070 | 14047345 | 14409996 | 14327926
2009-06-30 00:00:00 |  | 16340801 | 16579906 | 17323262 | 17590521
2010-06-30 00:00:00 |  | 13663556 | 14462831 | 15344085
2011-06-30 00:00:00 |  | 18358367 | 19814345
2012-06-30 00:00:00 |  | 21313759
Spreadsheet: 832442d1686325957-a-column-that-repeats-a-plate-5-times-and-adds-a-different-letter-after-each-plate-example-file-4-1-
Sheet: Desired Output

ACCT Number | ST | PLATE | EQUIP | VIN | MAKE | YEAR
ABC123 | MN | V123456A | 11111 | alsk;fjdal;kjdfl;adjsf | Bear | 2011
ABC123 | MN | V123456E | 11111 | alsk;fjdal;kjdfl;adjsf | Bear | 2011
ABC123 | MN | V123456H | 11111 | alsk;fjdal;kjdfl;adjsf | Bear | 2011
ABC123 | MN | V123456O | 11111 | alsk;fjdal;kjdfl;adjsf | Bear | 2011
ABC123 | MN | V123456T | 11111 | alsk;fjdal;kjdfl;adjsf | Bear | 2011
ABC567 | MN | O123456A | 33333 | alsdfjsldfjk | Horse | 2013
ABC567 | MN | O123456E | 33333 | alsdfjsldfjk | Horse | 2013
ABC567 | MN | O123456H | 33333 | alsdfjsldfjk | Horse | 2013
ABC567 | MN | O123456O | 33333 | alsdfjsldfjk | Horse | 2013
ABC567 | MN | O123456T | 33333 | alsdfjsldfjk | Horse | 2013
ABC655 | MN | B123456A | 44444 |  | Dog | 2015
ABC655 | MN | B123456E | 44444 |  | Dog | 2015
ABC655 | MN | B123456H | 44444 |  | Dog | 2015
ABC655 | MN | B123456O | 44444 |  | Dog | 2015
ABC655 | MN | B123456T | 44444 |  | Dog | 2015
 | MN | V123456A | 11111 | alsk;fjdal;kjdfl;adjsf | Bear | 2011
ABC123 | MN | V123456E | 11111 | alsk;fjdal;kjdfl;adjsf | Bear | 2011
ABC123 | MN | V123456H | 11111 | alsk;fjdal;kjdfl;adjsf | Bear | 2011
ABC123 | MN | V123456O | 11111 | alsk;fjdal;kjdfl;adjsf | Bear | 2011
ABC123 | MN | V123456T | 11111 | alsk;fjdal;kjdfl;adjsf | Bear | 2011
ABC234 | MN | N123456A | 55555 | alsdfjsldfjk | Duck | 2013
ABC234 | MN | N123456E | 55555 | alsdfjsldfjk | Duck | 2013
ABC234 | MN | N123456H | 55555 | alsdfjsldfjk | Duck | 2013
ABC234 | MN | N123456O | 55555 | alsdfjsldfjk | Duck | 2013
ABC234 | MN | N123456T | 55555 | alsdfjsldfjk | Duck | 2013
ABC567 | MN | O123456A | 33333 | [NAME] | Horse | 2015
ABC567 | MN | O123456E | 33333 | [NAME] | Horse | 2015
ABC567 | MN | O123456H | 33333 | [NAME] | Horse | 2015
ABC567 | MN | O123456O | 33333 | [NAME] | Horse | 2015
ABC567 | MN | O123456T | 33333 | [NAME] | Horse | 2015
ABC725 | MN | A123456A | 222222 | alksdfjasl;dkfjasldf | Cat | 2010
ABC725 | MN | A123456E | 222222 | alksdfjasl;dkfjasldf | Cat | 2010
ABC725 | MN | A123456H | 222222 | alksdfjasl;dkfjasldf | Cat | 2010
ABC725 | MN | A123456O | 222222 | alksdfjasl;dkfjasldf | Cat | 2010
ABC725 | MN | A123456T | 222222 | alksdfjasl;dkfjasldf | Cat | 2010
ABC655 | MN | B123456A | 44444 | lasj;df;lsdkjfl;sdjf | Dog | 2012
ABC655 | MN | B123456E | 44444 | lasj;df;lsdkjfl;sdjf | Dog | 2012
ABC655 | MN | B123456H | 44444 | lasj;df;lsdkjfl;sdjf | Dog | 2012
ABC655 | MN | B123456O | 44444 | lasj;df;lsdkjfl;sdjf | Dog | 2012
ABC655 | MN | B123456T | 44444 | lasj;df;lsdkjfl;sdjf | Dog | 2012
Spreadsheet: 950bf15e-61c8-40bf-92e8-040ffb5f8c34
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Finance: Business Financial Management
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Business Financial Management Pathway of the Finance [NAME]) can serve as a guide, along with other career planning materials, as learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study, used for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for        Business Financial Management Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | ►Accountant ►Auditor ►Bookkeeper ►Capital Budgeting Specialist ►Capital Expenditure Manager ►Cash Manager ►Chief Revenue Agent ►Collector ►Controller ►Cost Analyst ►Credit Analyst ►Economist ►Financial Analyst ►Financial Planner ►Foreign Exchange Manager ►Management Accountant ►Project Analyst ►Revenue Agent ►Tax Accountant ►Tax Examiner ►Tax Preparer ►Treasurer
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 137531d1327193152-need-to-find-the-week-number-of-the-month-first-of-the-month-not-always-the-1st-week-weekofmonth
Sheet: Sheet1

Date | Day | 1st Day of Month | Week | Manual Answer
2011-10-16 00:00:00 | 16 | 7 | 4 | 4 |  | Look in Col D for the formula.
2011-10-20 00:00:00 | 20 | 7 | 4 | 4
2011-10-21 00:00:00 | 21 | 7 | 4 | 4
2011-10-23 00:00:00 | 23 | 7 | 5 | 5
2011-10-25 00:00:00 | 25 | 7 | 5 | 5
2011-10-31 00:00:00 | 31 | 7 | 6 | 6
2011-11-01 00:00:00 | 1 | 3 | 1 | 1
2011-11-10 00:00:00 | 10 | 3 | 2 | 2
2011-11-11 00:00:00 | 11 | 3 | 2 | 2
2011-11-16 00:00:00 | 16 | 3 | 3 | 3
2011-11-17 00:00:00 | 17 | 3 | 3 | 3
2011-11-20 00:00:00 | 20 | 3 | 4 | 4
2011-11-21 00:00:00 | 21 | 3 | 4 | 4
2011-11-23 00:00:00 | 23 | 3 | 4 | 4
2011-11-23 00:00:00 | 23 | 3 | 4 | 4
2011-11-23 00:00:00 | 23 | 3 | 4 | 4
2011-11-24 00:00:00 | 24 | 3 | 4 | 4
2011-11-25 00:00:00 | 25 | 3 | 4 | 4
2011-11-26 00:00:00 | 26 | 3 | 4 | 4
2011-11-28 00:00:00 | 28 | 3 | 5 | 5
2011-12-03 00:00:00 | 3 | 5 | 1 | 1
2011-12-04 00:00:00 | 4 | 5 | 2 | 2
2011-12-04 00:00:00 | 4 | 5 | 2
2011-12-04 00:00:00 | 4 | 5 | 2
2011-12-09 00:00:00 | 9 | 5 | 2
2011-12-11 00:00:00 | 11 | 5 | 3
2011-12-13 00:00:00 | 13 | 5 | 3
2011-12-14 00:00:00 | 14 | 5 | 3
2011-12-17 00:00:00 | 17 | 5 | 3
2011-12-19 00:00:00 | 19 | 5 | 4
2011-12-21 00:00:00 | 21 | 5 | 4
2011-12-23 00:00:00 | 23 | 5 | 4
2011-12-24 00:00:00 | 24 | 5 | 4
2011-12-28 00:00:00 | 28 | 5 | 5
2011-12-30 00:00:00 | 30 | 5 | 5
2011-12-30 00:00:00 | 30 | 5 | 5
2012-01-02 00:00:00 | 2 | 1 | 1
2012-01-05 00:00:00 | 5 | 1 | 1
2012-01-05 00:00:00 | 5 | 1 | 1
2012-01-10 00:00:00 | 10 | 1 | 2
Spreadsheet: 390635d1429712474-segregate-and-sum-amounts-in-various-rows-formula-question
Sheet: Sheet1

 |  |  |  |  | Desired
Position # |  | Amount |  |  | Results
 |  |  |  |  | Position | Amount
20 |  | 100 |  |  | 20 | 400
19 |  | 200 |  |  | 19 | 500
18 |  | 200 |  |  | 18 | 500
17 |  | 400 |  |  | 17 | 1100
18 |  | 300 |  |  | 16 | 900
20 |  | 300 |  |  | 15 | 2500
19 |  | 300 |  |  | 14 | 1000
17 |  | 200 |  |  | 13 | 1700
16 |  | 400 |  |  | 12 | 1100
15 |  | 400 |  |  | 11 | 600
15 |  | 400 |  |  | 10 | 2600
13 |  | 600 |  |  | 9 | 2100
16 |  | 500 |  |  | 8 | 1400
15 |  | 500 |  |  | 7 | 2500
14 |  | 500 |  |  | 6 | 1700
14 |  | 500 |  |  | 5 | 1100
15 |  | 500 |  |  | 4 | 2500
17 |  | 500 |  |  | 3 | 2300
12 |  | 500 |  |  | 2 | 3400
12 |  | 600 |  |  | 1 | 2500
13 |  | 600
13 |  | 500
11 |  | 600
10 |  | 600
10 |  | 600
9 |  | 600
8 |  | 600
7 |  | 700
6 |  | 700
10 |  | 700
9 |  | 700
8 |  | 800
10 |  | 700
7 |  | 700
9 |  | 800
15 |  | 700
4 |  | 800
4 |  | 800
3 |  | 900
2 |  | 1000
4 |  | 900
6 |  | 1000
2 |  | 900
7 |  | 1100
5 |  | 1100
1 |  | 1200
1 |  | 1300
3 |  | 1400
2 |  | 1500
 |  | -
Spreadsheet: 266253d1379549739-excel-align-data-from-many-rows-into-a-single-row-alignment-using-supplied-formulas
Sheet: Sheet1

Current Situation
 |  |  | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5
Name | RT | [NAME] | Area | Area | Area | Area | Area
Chemical A | 21.201 | 43 | 176962
Chemical A | 21.202 | 43 |  | 2162037
Chemical A | 21.2 | 43 |  |  | 1593040
Chemical A | 21.203 | 43 |  |  |  | 1595420
Chemical A | 21.203 | 43 |  |  |  |  | 15612
Chemical B | 21.311 | 81 | 156752
Chemical B | 21.311 | 81 |  | 54952
Chemical B | 21.311 | 81 |  |  | 248956
Chemical B | 21.311 | 81 |  |  |  | 152566
Chemical B | 21.311 | 81 |  |  |  |  | 45555
Chemical C | 21.415 | 77 | 9548
Chemical C | 21.415 | 77 |  | 533666
Chemical C | 21.415 | 77 |  |  | 15578
Chemical C | 21.415 | 77 |  |  |  | 1512889
Chemical D | 22.255 | 89 | 1565
Chemical D | 22.255 | 89 |  | 156
Chemical D | 22.255 | 89 |  |  | 55566
Chemical D | 22.255 | 89 |  |  |  | 54987
Chemical D | 22.255 | 89 |  |  |  |  | 4564889
What I get
 |  |  | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5
Name | RT | [NAME] | Area | Area | Area | Area | Area
Spreadsheet: 138493d1327683130-performance-report-report1_pt_jpr73-1-
Sheet: Data

Box  No | Binders  name | Operator  Name | NO OF  PGS | Start Time  (24 hr Format) | Finish Time  (24 hr Format) | Total  Time | Time in  Minutes | Average | QC'ER | NO OF  PGS2 | COMMENTS | A4  Colour | A3  B&W | A3  Colour | A2  B&W | A2  Colour | A1  B&W | A1  Colour | A0  B&W | A0  Colour | Rebind | OCR | OCR QC | DATE EXPORTED
1 | 001 | MUHAMMAD | 5 | 23:00:00 | 00:20:00