tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 178650d1346861685-calculate-total-time-elapsed-inconsistency-between-2007-and-2010-dip11-error-test
Sheet: Sheet2

ID | Time1 | Time2 | Time3 | [NAME] | Time5 | Time6 |  |  | total error | TotalTime | TotalTime | Adjust | Time1 > ? | Time2 > ? | Time3 > ? | [NAME] ? | Time5 > ? |  | Total
13048 | 17:28:00 | 16:00:00 |  | 16:00:00 |  | 20:45:00 |  |  | 3077 |  | 1637
10440 | 17:25:00 | 23:00:00 | 15:15:00 | 15:15:00 | 20:30:00 | 20:35:00 |  |  | 3070 |  | 1630
8210 | 14:05:00 | 17:00:00 | 08:30:00 | 08:30:00 |  | 16:50:00 |  |  | 3045 |  | 1605
11377 | 17:55:00 | 18:40:00 | 16:00:00 | 16:00:00 |  | 18:45:00 |  |  | 2930 |  | 1490
7564 | 16:40:00 | 16:25:00 |  | 16:25:00 |  | 16:35:00 |  |  | 2875 |  | 1435
8416 | 13:45:00 | 13:25:00 |  | 13:25:00 |  | 13:40:00 |  |  | 2875 |  | 1435
13048 | 17:28:00 | 16:00:00 |  | 16:00:00 |  | 20:45:00 |  |  | 3077 | 1637 | 1637 |  | 1352 | 0 | 0 | 285 | 0 |  | 1637
10440 | 17:25:00 | 23:00:00 | 15:15:00 | 15:15:00 | 20:30:00 | 20:35:00 |  |  | 3070 | 1630 | 1630 |  | 335 | 975 | 0 | 315 | 5 |  | 1630
8210 | 14:05:00 | 17:00:00 | 08:30:00 | 08:30:00 |  | 16:50:00 |  |  | 3045 | 1605 | 1605 |  | 175 | 930 | 0 | 500 | 0 |  | 1605
11377 | 17:55:00 | 18:40:00 | 16:00:00 | 16:00:00 |  | 18:45:00 |  |  | 2930 | 1490 | 1490 |  | 45 | 1280 | 0 | 165 | 0 |  | 1490
7564 | 16:40:00 | 16:25:00 |  | 16:25:00 |  | 16:35:00 |  |  | 2875 | 1435 | 1435 |  | 1425 | 0 | 0 | 10 | 0 |  | 1435
8416 | 13:45:00 | 13:25:00 |  | 13:25:00 |  | 13:40:00 |  |  | 2875 | 1435 | 1435 |  | 1420 | 0 | 0 | 15 | 0 |  | 1435
Spreadsheet: 366180d1419151897-how-to-distribute-equally-among-individuals-allocate-ids-randomly-ish
Sheet: Sheet1

ID | Allocation |  |  | Unique list | Allocation
M7957002
M7723005 |  |  |  |  |  |  |  |  | Table-Employees
M1004004 |  |  |  |  |  |  |  |  | Sl No | Name | Count
M1004004 |  |  |  |  |  |  |  |  | 1 | [NAME]
E7957002 |  |  |  |  |  |  |  |  | 2 | Anna
M1004004 |  |  |  |  |  |  |  |  | 3 | Maria
[NAME] |  |  |  |  |  |  |  |  | 4 | Ria
M1004004
M7941001
[NAME]
M7941001
M7723005
M7941001
M7941001
M1004004
M7836004
M7836005
M2627002
M5723004
M5723004
Spreadsheet: 48405d1247623185-help-with-a-formula-mafia-wars-loot-list-001
Sheet: Weapons

 |  |  |  |  | Mafia Loot List
Weapons |  | Attack | [NAME] | Units | Power
Nambu Type 14 Pistol |  | 22 | 8 |  |  | The colum named POWER needs to auto sort the highest score row
Kunai |  | 18 | 12
Type 100 SMG |  | 30 | 10
[NAME] |  | 14 | 10
.50 Caliber Rifle |  | 16 | 11
Napalm |  | 25 | 9
[NAME] |  | 20 | 12 |  |  |  |  | `
Bookie's Holdout Pistol |  | 24 | 12
AR-15 Assault Rifle |  | 32 | 10
RA-92 |  | 29 | 11
Garza 9 |  | 25 | 10
[NAME] .50 Sniper Rifle |  | 40 | 16
M16A1 |  | 30 | 12
Cane Knife |  | 18 | 28
TNT |  | 42 | 20
Ru-38 Pistol |  | 20 | 24
ASC45 "Conquistador" |  | 36 | 18
Gaff hook |  | 20 | 30
Para 322 |  | 34 | 14
[NAME] |  | 14 | 6
Bayonet |  | 4 | 16
Saber |  | 17 | 13
Musket |  | 25 | 5
Spreadsheet: 848548d1699280823-split-range-sample
Sheet: Sheet1

Boxes | Range |  | Boxes | [NAME]
1 | 1-3 |  | 1 | 1
2 | 9-12 |  | 1 | 2
3 | 5-8 |  | 1 | 3
 |  |  | 2 | 9
 |  |  | 2 | 10
 |  |  | 2 | 11
 |  |  | 2 | 12
 |  |  | 3 | 5
 |  |  | 3 | 6
 |  |  | 3 | 7
 |  |  | 3 | 8
Spreadsheet: 831162d1685456131-indicate-overlapping-dates-against-ids-date-entries-ans2
Sheet: Sheet1

Name | Check In Time | Check Out Time | mama | FORMULA
[NAME] | 2013-01-03 08:45:00 | 2013-01-03 16:45:00
[NAME] | 2013-01-03 09:30:00 | 2013-01-03 18:10:00
[NAME] | 2013-01-03 17:30:00 | 2013-01-03 18:20:00
[NAME] | 2013-01-03 09:30:00 | 2013-01-03 18:10:00
[NAME] | 2013-01-03 10:30:00 | 2013-01-03 16:30:00
[NAME] | 2013-01-03 10:30:00 | 2013-01-03 16:30:00
[NAME] | 2013-01-03 18:11:00 | 2013-01-03 20:30:00
Spreadsheet: 482447d1475067631-copy-chart-from-one-area-to-another-without-fixed-cells-book29
Sheet: Sheet2

2016 - 2017
TARGET | Month
 | Period to Date
ACTUAL | Month
 | Period to Date
GAP | Month
 | Period to Date
[NAME] | Month
 | Period to Date
Spreadsheet: 2710d8c6-ef9b-4557-b60d-94506987a1cb
Sheet: Materials

Materials | [NAME] |  | * = Material processing footprint non-negligible and included (assuming conventional machining).
ABS* | 6.2
Aluminum* (ex. Aluminum foil, soda cans) | 16 |  | NOTE:
Brass* | 10
Brick | 0.215
Butyl Rubber* (ex. Inner tubes) | 5.2
Cast Iron* | 6
Cement | 1.125
Ceramic | 1.65
Concrete | 0.14
Copper* | 9.4
Cork | 0.2
Epoxies* | 6.3
Flexible Polymer [NAME]* (ex. Seat cushions, floatation devices, etc.) | 5.7
GFRP (Fiberglass) | 7.9
Processed GFRP* (Fiberglass) | 12.3
Leather | 4.295
Natural Rubber* (ex. Tires, tubing, etc.) | 2.9 |  | Source: CES Edu Pack 2010 Software
Neoprene* | 5.1
Oak | 0.465
Paper and Cardboard | 1.39
PET* (ex. Plastic bottles) | 4.9
PHA/PHB* (ex. Shampoo bottles, etc.) | 4.5
Pine | 0.43
Plaster of Paris | 0.205
Plywood | 0.75
Polyester* | 5
Polymethyl methacrylate* (ex. Acrylic, [NAME], etc.) | 6.3
Polystyrene* | 5.4
Polyurethane* | 6
PVC* | 4.9
Rigid Polymer [NAME]* (ex. Foam cups) | 5.1
Silicon | 3.985
Slate | 0.07
Soda-lime [NAME] | 1.5
Stainless Steel* | 12
Steel* (ex. Ranges from paperclips to high quality tools) | 8.2
[NAME] Copolymer Rubber (SBR)* (ex. Tires) | 7.5
Spreadsheet: 193696d1352917889-dates-formatted-as-text-excel-forum-problem
Sheet: Sheet1

2012-11-08 07:00:00 | satellite
2012-11-08 07:01:00 | satellite
2012-11-08 07:01:59.995000 | satellite
2012-11-08 07:02:59.995000 | satellite
2012-11-08 07:03:59.995000 | satellite
2012-11-08 07:04:59.995000 | satellite
2012-11-08 07:05:59.995000 | satellite
2012-11-08 07:06:59.995000 | satellite
2012-11-08 07:07:59.995000 | satellite
2012-11-08 07:08:59.995000 | satellite
2012-11-08 07:09:59.995000 | satellite
2012-11-08 07:10:59.995000 | satellite
2012-11-08 07:11:59.995000 | satellite
2012-11-08 07:12:59.995000 | satellite
2012-11-08 07:13:59.995000 | satellite
2012-11-08 07:14:59.995000 | satellite
2012-11-08 07:15:59.995000 | satellite
2012-11-08 07:16:59.995000 | satellite
2012-11-08 07:17:59.995000 | satellite
2012-11-08 07:18:59.995000 | satellite
2012-11-08 07:19:59.995000 | satellite
2012-11-08 07:20:59.995000 | satellite
2012-11-08 07:21:59.995000 | satellite
2012-11-08 07:22:59.995000 | satellite
2012-11-08 07:23:59.995000 | satellite
2012-11-08 07:24:59.995000 | satellite
2012-11-08 07:25:59.995000 | satellite
2012-11-08 07:26:59.995000 | satellite
2012-11-08 07:27:59.995000 | satellite
2012-11-08 07:28:59.995000 | satellite
2012-11-08 07:29:59.995000 | satellite
2012-11-08 07:30:59.995000 | satellite
2012-11-08 07:31:59.995000 | satellite
2012-11-08 07:32:59.995000 | satellite
2012-11-08 07:33:59.995000 | satellite
2012-11-08 07:34:59.995000 | satellite
2012-11-08 07:35:59.995000 | satellite
2012-11-08 07:36:59.995000 | satellite
2012-11-08 07:37:59.995000 | satellite
2012-11-08 07:38:59.995000 | satellite
2012-11-08 07:39:59.995000 | satellite
2012-11-08 07:40:59.995000 | satellite
2012-11-08 07:41:59.995000 | satellite
2012-11-08 07:42:59.995000 | satellite
2012-11-08 07:43:59.995000 | satellite
2012-11-08 07:44:59.995000 | satellite
2012-11-08 07:45:59.995000 | satellite
2012-11-08 07:46:59.995000 | satellite
2012-11-08 07:47:59.995000 | satellite
2012-11-08 07:48:59.995000 | satellite
2012-11-08 07:49:59.995000 | satellite
2012-11-08 07:50:59.995000 | satellite
2012-11-08 07:51:59.995000 | satellite
2012-11-08 07:52:59.995000 | satellite
2012-11-08 07:53:59.995000 | satellite
2012-11-08 07:54:59.995000 | satellite
2012-11-08 07:55:59.995000 | satellite
2012-11-08 07:56:59.995000 | satellite
2012-11-08 07:57:59.995000 | satellite
2012-11-08 07:58:59.995000 | satellite
2012-11-08 07:59:59.995000 | satellite
Spreadsheet: daren_farmer__5434__MinHPLN00
Sheet: Sheet1

MINHPLN00.xls |  | Via Fax:  (713) 646-3239
TO:   [NAME], [NAME], [NAME]/HPL
FROM:   [NAME] (Previously TUFCO)
SUBJECT:   Gas Sales and Purchase Contract #3949, as amended
Nomination of Estimated Monthly Quantity
 |  | Date |  | Estimated |  | Estimated
Nomination Month |  | Nominated |  | Daily Quantity |  | Monthly Quantity
 |  |  |  | MMBtu |  | MMBtu
2000
January |  | 1999-12-22 00:00:00 |  | 25000
February |  | 2000-01-26 00:00:00 |  | 25000
March |  | 2000-02-23 00:00:00 |  | 25000
April |  | 2000-03-27 00:00:00 |  | 20000
May |  | 2000-04-25 00:00:00 |  | 40000
June |  | 2000-05-23 00:00:00 |  | 65000
July |  | 2000-06-23 00:00:00 |  | 65000
August |  | 2000-07-24 00:00:00 |  | 65000
September |  | 2000-08-25 00:00:00 |  | 20000 |  | 600000
October
November
December
 |  |  |  |  | Total
Note:  Please advise immediately should you have any questions concerning the above.
C:      R. Skerik
[NAME]
G. Green
M. Jones
Spreadsheet: 22375d1211197649-excel-2007-multiple-pie-charts-example-pie-data
Sheet: Sheet1

Breed | F | Fn | M | Mn
Basset Hound (Case n=5) | 0.2 | 0.4 | 0.2 | 0.2
Basset Hound (Ctrl n=11) | 0.2727272727272727 | 0.09090909090909091 | 0.3636363636363636 | 0.2727272727272727
Beagle (Case n=5) | 0.2 | 0 | 0.6 | 0.2
Beagle (Ctrl n=11) | 0.6363636363636364 | 0 | 0.2727272727272727 | 0.09090909090909091
[NAME] (Case n=16) | 0.125 | 0.1875 | 0.3125 | 0.375
[NAME] (Ctrl n=27) | 0.2592592592592592 | 0.1111111111111111 | 0.5185185185185185 | 0.1111111111111111
Bulldog (Case n=6) | 0 | 0 | 0.8333333333333334 | 0.1666666666666667
Bulldog (Ctrl n=14) | 0.2142857142857143 | 0.07142857142857142 | 0.5714285714285714 | 0.1428571428571428
[NAME]) | 0.2 | 0.4 | 0 | 0.4
[NAME] (Ctrl n=23) | 0.4347826086956522 | 0 | 0.4347826086956522 | 0.1304347826086956
Spreadsheet: 542785d1508089670-drop-down-lists-drop-down-lists-book
Sheet: Sheet1

Agent Name |  | Agent | Tasks |  |  |  |  | Agent |  | Tasks
 |  | [NAME] | Audit |  |  |  |  | [NAME]
 |  | Kaira | Processes
 |  | Kai | Variations
 |  | [NAME] | over view
 |  | [NAME] | end of day
 |  | Kai | communications
 |  | [NAME] | Grouping
Spreadsheet: 167050d1341881618-fill-cell-value-based-on-value-from-another-sheet-in-dummy-terms-doc-2-those-who-did-not-open-emails
Sheet: Sheet1

Name | [NAME] | Total Opens | Total Clicks |  | [NAME] | [NAME]
304 on West | [EMAIL] | 1 | 1
34 Degrees South | [EMAIL] | 1 | 0
[NAME] | [EMAIL] | 1 | 0
Aperitivo | [EMAIL] | 1 | 0
Arvis Indian Restaurant and Bar | [NAME] | 2 | 0
Barbuto Restaurant | [EMAIL] | 1 | 0
Bartino | [EMAIL] | 2 | 1
[NAME]'s | [NAME] | 1 | 0
Big Stone | [NAME] | 1 | 0
Spreadsheet: 0da72f63-ce4e-47b2-b1c4-0e287e7d6f5c
Sheet: Sheet1

Table 7--Peanuts:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 | Area |  | Yield |  | Supply |  |  |  |  |  | Disappearance
Year begin. | Planted | Harvested |  | Beginning |  |  |  |  | Domestic |  | Seed & |  |  | Ending
Aug. 1 |  |  |  | stocks | Imports | Production | Total |  | food | Crush | residual | Exports | Total | stocks
 | ------1,000 acres-------- |  | Pounds/acre |  |  |  | Million pounds
2010/11 | 1288 | 1255 | 3312.223107569721 | 1828.748 | 64.5919124166918 | 4156.84 | 6050.179912416692 |  | 2839.7 | 586.553 | 502.4034567803826 | 605.5844556363093 | 4534.240912416692 | 1515.939
2011/121 | 1140.6 | 1097.6 | 3312.973760932945 | 1515.939 | 200 | 3636.32 | 5352.259 |  | 2970 | 575 | 377.259 | 525 | 4447.259 | 905
2012/132 | 1422 | 1394 | 3382.352941176471 | 905 | 100 | 4715 | 5720 |  | 3018 | 505 | 484 | 550 | 4557 | 1163
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Peanut Stocks and Processing,and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2012-05-14 15:00:41.420000
Spreadsheet: 111343d1307714370-index-indirect-match-problem-ddbrd-2-
Sheet: Sheet1

PTS
 | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
2011 | 7290 | 5722 | 6139 | 4774 | 2483 | 3673 | 9180 | 9001 | 9807 | 4423 | 2492 | 49
PTS
 | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
2011 | 7290 | 5722 | 6139 | 4774 | 2483 | 3673 | 9180 | 9001 | 9807 | 4423 | 2492 | 49
2010 | 6258 | 8203 | 5051 | 1764 | 8869 | 1501 | 2455 | 9377 | 6032 | 5855 | 9418 | 9418
2009 | 9522 | 9114 | 3287 | 5821 | 395 | 5175 | 4379 | 116 | 9160 | 9109 | 7889 | 160
2008 | 3894 | 138 | 8553 | 2908 | 870 | 3031 | 1828 | 6021 | 7909 | 1457 | 8385 | 8954
WOL
 | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
2011 | 2454 | 4483 | 581 | 633 | 6550 | 4431 | 7853 | 4036 | 3244 | 6875 | 7509 | 460
2010 | 4310 | 9549 | 4841 | 2517 | 7160 | 5464 | 7530 | 645 | 5482 | 4167 | 8614 | 1270
2009 | 7251 | 6799 | 3984 | 3712 | 570 | 2197 | 696 | 4944 | 9071 | 6521 | 669 | 7926
2008 | 7858 | 5801 | 9443 | 8180 | 2963 | 4966 | 1377 | 6501 | 2631 | 1292 | 7184 | 960
PTS
WOL
Spreadsheet: 834361d1687750442-filling-empty-cells-with-random-values-from-a-list-test-sheet
Sheet: Sheet1

Student Name | # OF CLASSES |  |  | TIME/TEACHER | [NAME] | [NAME] | CHRIS | JEWEL | CHLOE
Mark | 5 |  |  | 08:00 - 08:50
[NAME] | 5 |  |  | 09:00 - 09:50
[NAME] | 5 |  |  | 10:00 - 10:50
Hyacinth | 5 |  |  | 11:00 - 11:50
[NAME] | 5 |  |  | 11:50 - 13:00 | LUNCH | LUNCH | LUNCH | LUNCH | LUNCH
Gayle | 5 |  |  | 13:00 - 13:50
[NAME] | 5 |  |  | 14:00 - 14:50
Zack | 5 |  |  | 15:00 - 15:50
 |  |  |  | 16:00 - 16:50
Spreadsheet: 191901d1352241683-counting-unique-criteria-example-thetrirdman-oeldere-
Sheet: Data

Employee | Branch | Account Number | Checking | Saving | Credit Card | count | ch1 | sv1 | [NAME]
[NAME] | NYC | 1 | y
[NAME] | Philly | 2 | y
[NAME] | NYC | 3 | y
[NAME] | Dallas | 4 |  | y
[NAME] | Dallas | 5 |  |  | y
[NAME] | Dallas | 6 |  | y
[NAME] | HK | 7 | y
[NAME] | Dallas | 8 | y
[NAME] | NYC | 9 |  |  | y
[NAME] | NYC | 10 |  | y
[NAME] | Philly | 11 | y
Exie Desir | India | 12 |  |  | y
Spreadsheet: 2737c24e-743f-4cbc-ba73-7cc9efb65139
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43630376 | 2014-10-18 11:00:47 | AXIS | 1 | 5 | 3 | 1244505 | tshornhardt | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43638533 | 2014-10-18 23:19:01 | ALLIES | 0 | 4 | 6 | 867821 | b.kuntscher | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
43638840 | 2014-10-18 23:38:59 | AXIS | 0 | 5 | 6 | 867821 | b.kuntscher | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
43643857 | 2014-10-19 08:51:43 | ALLIES | 1 | 6 | 3 | 1657729 | DEJEAN [NAME] | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
43644070 | 2014-10-19 09:17:10 | AXIS | 1 | 6 | 5 | 1657729 | DEJEAN [NAME] | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
Spreadsheet: richard_sanders__31766__00-07-25-KW Bullet 2
Sheet: Sheet1

Data for Bullet points
Average 1999 Pool Price | 42.74 | [NAME]
Average Pool Price from 6/1 to 10/18 | 53.15 | [NAME]
Number of Hours from 6/1 to 10/18 | 3360 | Hours
Number of ENR/PWX transactions | 22 | Hours
Fraction of hours in period affected by ENR/PWX transactions
Total Pool volume from 6/1 to 10/18 | 19225140 | MWh
Total energy in ENR/PWX transactions | 1906 | MWh
ENR/PWX transactions as share of total traded volume in period
Number of hours Pool Price equalled of exceeded CAD100/MWh | 204 | Hours
Number of those hours involving ENR/PWX | 16 | Hours
Total value of Power Pool transactions from 6/1 to 10/18 | 1077 | Can$m
Total value of ENR/PWX transactions | 1.299 | Can$m
Average size of ENR/PWX transaction | 86.63636363636364 | MW
Average total Pool load during hours with ENR/PWX transactions | 6392.181818181818 | MW
Average ENR/PWX share of hourly volume when transactions occurred
Total Pool revenue on ENR/PWX transactions | 1299488 | Can$
Total Pool sales during hours with ENR/PWX transactions | 92582328.05000001 | Can$
Spreadsheet: 109584d1306406905-auto-generate-reports-from-another-worksheet-dans-sample
Sheet: Plantilla S.A. -DBM

Name of Incumbent | Item No./                        Unique Item No.                  FY-2011                     Personal Services Itemization and/or          Plantilla of Personnel          (1) | Position Title                                  (2) | Salary Grade      (3) | [NAME](4) | Actual            Monthly             Basic Salary           as of May 31,          2011                          (5) | Adjusted Monthly            Basic Salary Effective          June 1, 2011      (6) | Monthly    Salary Adjustment Effective      June 1, 2011; (6) - (5)               (7)
 | OFFICE OF THE DIRECTOR
JONES, [NAME] | SJUA- DIR4-1-1998 | DIRECTOR IV | 28 | 1
REAVIS, GREGORY KENT | SJUA-DIR-3-1-1998 | DIRECTOR III | 27 | 1
FORSTER, [NAME] | SJUA-SUPP-1-1998 | SUPERINTENDENT OF PRINTING | 26 | 1
VACANT | SJUA-ASPR-1-1998 | ASST. SUPERINTENDENT OF PRINTING | 25 | 1
VACANT | SJUA-LEGO4-1-1998 | LEGAL OFFICER IV | 23 | 1
CLINTON, SMITH BILLY | SJUA-ADAS3-1-2009 | ADMINISTRATIVE ASSISTANT III | 9 | 1
MURESAN, [NAME] | SJUA-ADAS3-6-2005 | ADMINISTRATIVE ASSISTANT III | 9 | 1
 | ADMINISTRATIVE DIVISION
JORDAN, [NAME] | SJUA-CADOF-6-2005 | CHIEF AMINISTRATIVE OFFICER | 24 | 3
STRAHOVSKI, [NAME] | SJUA-SADOF-8-2005 | SUPERVISING ADMINISTRATIVE OFFICER | 22 | 3
CARLMICHAEL, [NAME] | SJUA-ADOF5-9-2005 | ADMINISTRATIVE OFFICER V | 18 | 1
CASEY, [NAME] | SJUA-ADOF5-10-2005 | ADMINISTRATIVE OFFICER V | 18 | 2
AGRON, DIANNA MICHELLE | SJUA-ADOF5-11-2005 | ADMINISTRATIVE OFFICER V | 18 | 3
NGUYEN, [NAME] | SJUA-ADOF5-12-2005 | ADMINISTRATIVE OFFICER V | 18 | 1
Spreadsheet: 36873d1234847038-excel-2007-how-do-i-reference-a-min-value-in-another-spreadsheet-discrete-measures
Sheet: StaT

Level | 25PE | 25CS | 5PE | 5CS | 75PE | 75CS | 10PE | 10CS | 15PE | 15CS
Spreadsheet: 217835d1362216352-breaking-up-string-of-text-in-1-cell-into-multiple-cells-book1
Sheet: Sheet1

DATA | LAST | FIRST | MIDDLE | SOME #'s | PHONE | [NAME]
[NAME], [NAME] (2731715) [PHONE] [EMAIL] | [NAME] | [NAME] | Rios | 2731715 | [PHONE] | [EMAIL]
Berring, [NAME] (2718516) [PHONE] [EMAIL] | Berring | Virginia | Janice | 2718516 | [PHONE] | [EMAIL]
[NAME], [NAME] (3053815) [PHONE] [EMAIL] | [NAME] | [NAME] | - | 3053815 | [PHONE] | [EMAIL]
Jones, [NAME] (3062039) [PHONE] [EMAIL] | Jones | Willeta | - | 3062039 | [PHONE] | [EMAIL]
Spreadsheet: 762212d1641456366-count-not-counting-the-correct-number-count
Sheet: Surface   

Count |  |  | this is counting as 147, when it should count as 4, needs to count every one with S
 | 13
 | 19
 | 26
 | 35
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: 848072d1698868062-split-cell-values-in-to-multiple-cells-in-a-column-cell-to-table
Sheet: Sheet1

Table | Group | 31 Locations : D571 - 253, 1273,510, 512, 524, 547, 1591,1619, 530   D751 - 526, 159, 162, 252, 535,531, 1248, 533,1316, 1414, 534, 1105, 1169 D573 - 503, 505, 546, 551, 1324, 1263, 1362 CB - 656, 8496
 | D571 | I want above data from A2 cell with below criteria
 |  | Excluding  below words:
 |  | 31 Locations : | Means number of locations, it will change regularly
 |  | D571 -
 |  | D751 -
 |  | D573 -
 |  | CB -
Spreadsheet: 0d9b62ff-7ea7-4f8c-9fde-dbb76d86aca2
Sheet: PERSI-T1

Temporary Help PERSI Eligible Appointment -T1 Positions |  |  |  |  |  |  |  |  |  | Start Over
PCN# | PCN# | PCN# | PCN# | PCN# | Suffix | Employee Class | Title | Account Code
1st Job | 2nd Job | 3rd Job | 4th Job | 5th Job
**9900 | XX9600 | XX9800 | XX9840 | XX9860 | 05 | T1 | TH-Clerical/Tutors | E4110
**9901 | XX9601 | XX9801 | XX9841 | XX9861 | 05 | T1 | TH-Instructor/Coach | E4110
**9902 | XX9602 | XX9802 | XX9842 | XX9862 | 05 | T1 | TH-Laborer | E4110
**9903 | XX9603 | XX9803 | XX9843 | XX9863 | 05 | T1 | TH-Childcare Provider | E4110
**9904 | XX9604 | XX9804 | XX9844 | XX9864 | 05 | T1 | TH-Logging | E4110
**9905 | XX9605 | XX9805 | XX9845 | XX9865 | 05 | T1 | TH-Dairy | E4110
**9906 | XX9606 | XX9806 | XX9846 | XX9866 | 05 | T1 | TH-Farming | E4110
**9907 | XX9607 | XX9807 | XX9847 | XX9867 | 05 | T1 | TH-Cattle/Sheep | E4110
**9908 | XX9608 | XX9808 | XX9848 | XX9868 | 05 | T1 | TH-Drivers | E4110
**9909 | XX9609 | XX9809 | XX9849 | XX9869 | 05 | T1 | TH-Research-Lab | E4110
**9910 | XX9610 | XX9810 | XX9850 | XX9870 | 05 | T1 | TH-Research-Non-Lab | E4110
** Replace with the first 2 letters of department budget.
Each additional job within the same [NAME] should begin with the characters 'XX' not the first 2 letters of the budget.
Spreadsheet: 853538d1703397965-solver-lpx-solver_farming
Sheet: Possible Solver setup

 |  |  |  | farm A | Farm B | farm C
 |  | Farm production |  | 20000 | 34000 | 17000
 |  | 80% of farm poduction |  |  |  |  | These are  the highest through puts from one farm through one port
 |  | port capacity |  | Ex farm A | Ex farm B | Ex farm C | Sum cap | [NAME] cap
 |  |  | port 1 | 16000 | 8600 | 3400 |  | 28000
 |  |  | port 2 | 0 | 21000 | 0 |  | 21000
 |  |  | port 3 | 4000 | 4400 | 0 |  | 16000
 |  |  | port 4 | 0 | 0 | 13600 |  | 14000
 |  | Total from each farm
Spreadsheet: 3ebae4b1-fc0c-45cd-9020-019dd4c0f064
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  |  |  | AVERAGE |  |  |  |  |  | 2008-12-31 00:00:00 | 2008-11-30 00:00:00
INVESTMENT | INVESTMENT | ISSUER | MATURITY | PURCHASE | DAYS TO | CUSIP | RATE | YIELD | COST | PAR | MARKET | MARKET
NUMBER | TYPE |  | DATE | DATE | MATURITY |  |  |  |  |  | VALUE * | VALUE *
2007-01-11.1 | FHLB | U.S. GOVERNMENT AGENCY | 2008-12-12 00:00:00 | 2007-01-11 00:00:00 |  | 3133XHTU6 | 5 | - | Matured 12-12-08 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
1986-06-01 | ** FHLMC | U.S. GOVERNMENT AGENCY | 2016-06-01 00:00:00 | 1986-06-01 00:00:00 |  | 313400MC4 | 8.25 | 7.728337236533958 | 10199962.5 | 9555000 | 11567569.65 | 11967637.5
 |  |  |  |  | 2671 |  |  |  | 10199962.5 | 9555000 | 11567569.65 | 11967637.5
2007-01-11.6 | FNMA | U.S. GOVERNMENT AGENCY | 2009-03-16 00:00:00 | 2007-01-11 00:00:00 |  | 31359MUQ4 | 3.125 | 5 | 1923342 | 2000000 | 2010620 | 2011880
1985-12-10 | ** FNMA | U.S. GOVERNMENT AGENCY | 2015-12-10 00:00:00 | 1985-12-10 00:00:00 |  | 313586UB3 | 10.35 | 8.417842165459398 | 3688593.75 | 3000000 | 4422180 | 4219680
 |  |  |  |  | 1742.360577042656 |  |  |  | 5611935.75 | 5000000 | 6432800 | 6231560
1992-04-20 | LACIP | LOS ANGELES COUNTY TREASURER*** |  | 1992-04-20 00:00:00 | 522 |  | 3.26 | 3.26 | 3728328.24 | 3728328.24 | 3728328.24 | 3728328.24
1989-10-19 | LAIF | STATE OF CALIFORNIA |  | 1989-10-19 00:00:00 | 223 |  | 2.353 | 2.353000000000001 | 15864382.8 | 15864382.8 | 15864382.8 | 15864382.8
 |  |  |  |  | 1265.902647172224 |  | TOTALS: |  | 35404609.29000001 | 34147711.04000001 | 37593080.69 | 37791908.54000001
* MARKET VALUES HAVE BEEN PROVIDED BY UNION BANK.
** These two high interest long term investments were made before State Law limited investments to a maximum five-year term.
***  For this month's report, November 2008 LACIP Earnings Rate and November 2008 LACIP Weighted Average Days to Maturity were used due to the unavailability of December figures as of the writing of this report.
Note:  The Wells Fargo Sweep account was not included in the calculation of average maturity.