tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 698666d1602110317-number-incrementor-formula-help-needed-book1
Sheet: Sheet1

 | Current Data |  |  |  |  |  |  |  |  | Result needed
 | Product | SHOP |  |  |  |  |  |  |  | Product | Identification because of the Shops
 | Apple | NY |  |  |  |  |  |  |  | Apple-01 | First Entry
 | Apple | NC |  |  |  |  |  |  |  | Apple-01 | 1
 | Apple | WC |  |  |  |  |  |  |  | Apple-02 | First Entry
 | Pear | PA |  |  |  |  |  |  |  | Apple-02 | 1
 | Pear | PA |  |  |  |  |  |  |  | Apple-03 | First Entry
 | Pear | PA |  |  |  |  |  |  |  | Apple-03 | 1
 | Pear | PA |  |  |  |  |  |  |  | Pear-01 | First Entry
 | Pear | PA |  |  |  |  |  |  |  | Pear-01 | 1
 | Pear | PA |  |  |  |  |  |  |  | Pear-01 | 2
 | Pear | PA |  |  |  |  |  |  |  | Pear-01 | 3
 | Pear | PA |  |  |  |  |  |  |  | Pear-01 | 4
 | Pear | PA |  |  |  |  |  |  |  | Pear-01 | 5
 | Pear | PA |  |  |  |  |  |  |  | Pear-01 | 6
 | Mango | CA |  |  |  |  |  |  |  | Pear-01 | 7
 | Mango | LA |  |  |  |  |  |  |  | Pear-01 | 8
 | Mango | LA |  |  |  |  |  |  |  | Pear-01 | 9
 |  |  |  |  |  |  |  |  |  | Mango-01 | First Entry
 |  |  |  |  |  |  |  |  |  | Mango-01 | 1
 |  |  |  |  |  |  |  |  |  | Mango-02 | First Entry
 |  |  |  |  |  |  |  |  |  | Mango-02 | 1
 |  |  |  |  |  |  |  |  |  | Mango-02 | 2
Spreadsheet: 89269d1289021956-how-to-make-a-function-every-8-cells-and-drag-it-down-over-2000-cells-help
Sheet: Sheet1

 | [NAME]? | [NAME]? | FPS Sent? | FPS Received?
Row Labels
[NAME]
ALMO Manifold & TOOL CO. INC. | 2007
[NAME] 472
[EMAIL] | +[PHONE]
No
No
Yes
No
ANCHOR FLUID POWER | 2010
[NAME]
[EMAIL] | 1+[PHONE]
No
No
Yes
No
APPLIED INDUSTRIAL TECHNOLOGIES | 1484
[NAME] 457
[EMAIL] [NAME]
No
No
Yes
No
APSCO, INC. | 1442
[NAME] Williams| 454
[EMAIL] [NAME]
No
No
Yes
No
ATLAS SYSTEMS GROUP, HYDROTECH LLC | 2000
[NAME] Ferguson| 466
[EMAIL] | [PHONE]
Yes
Yes
Yes
Yes
Rex Wetherill| 464
[NAME] Shock| 465
[NAME] (P) Ltd. | 1884
R. Kulkarni| 341
[EMAIL] | (0831)4202743/2441014
Yes
Yes
Yes
Yes
Yaswand Mohta| 342
[EMAIL] | +41-831-4202-743
Yes
Yes
Yes
Yes
Brennan Industries | 8004
[NAME] 445
[EMAIL] | [PHONE] ext. 2014
Yes
Yes
Yes
Yes
BUCHER HYDRAULI | 1418
[NAME] Vaughan| 403
[EMAIL] | [PHONE]
No
Yes
Yes
Yes
[NAME]
[EMAIL] | [PHONE]
No
Yes
Yes
Yes
Yan Charlie| 404
[EMAIL] | +886-3-3287728
No
Yes
Yes
Yes
CONTECH MFG, INC. | 1444
[NAME] Compton| 461
[EMAIL] [NAME]
No
No
Yes
No
CROSS FLUID POWER | 1445
[NAME] 426
[EMAIL] | (205) 413-3875
Yes
Yes
Yes
Yes
[NAME] 425
[EMAIL] | [PHONE]
Yes
Yes
Yes
Yes
CROSS MANUFACTURING | 1482
[NAME] Worley| 454
[EMAIL] | +[PHONE]
No
No
Yes
No
Dakota Tube | 2026
Jon Fischbach| 474
[EMAIL] | (605)882-2156
Yes
Yes
Yes
Yes
[NAME] Highman| 478
[EMAIL] | [PHONE]
Yes
Yes
Yes
Yes
DELTA SALES CORPORATION - India ( Rakesh Mehta ) | 1410
Rakesh Mehta| 400
[EMAIL] | +41-20-2712 6650
No
Yes
Yes
Yes
[NAME] power | 2027
[NAME] 480
[EMAIL] | [PHONE]
Yes
Yes
Yes
Yes
[NAME] Guidish| 481
[EMAIL] | [PHONE]
Yes
Yes
Yes
Yes
Spreadsheet: 849195d1699714005-conditional-formatting-with-percentages-inventory-test-shawnni-
Sheet: Sheet1

INVENTORY  LIST
Supplier | Item Number | Item Name | Description | Units Ordered | Items per Unit | Number Units on B/O | Items/ Unit/Meters Quantity In Stock | Unit Price | Per | Date Last  Ordered | N(Itmes per Unit)
DJO Global | CCE3830 | CCE RSTape | 3.8cm x 13.7m (30box) | 1 | 30 rolls |  | 30 | 204 | EACH | 08.09.2023
 | CCE5010UF | CCE Underfix Stretch | 5cm x 10m | 5 | 10m |  | 5 | 6.9 | EACH | 08.09.2023
 | CCETPBL-BLK | CCE [NAME] | Black | 1 | 1 |  | 1 | 4.9 | EACH | 08.09.2023
[NAME] | 64002202 | P P STRENGTH GRIP | (SG1) | 1 | 1 grip | 1 | 1 | 15.38 | EACH | 23.08.2023
 | 976040-8MML | VASYLI HEEL LIFTS / RAISES | SOLD IN PAIRS - 8MM LARGE | 4 | 1 pairs | 4 | 0 | 5.95 | EACH | 23.08.2023
 | 8205 | SORBOLENE LOTION | 1 LITRE PUMP | 6 | 1 liter |  | 6 | 6.8 | EACH | 23.08.2023
 | 8146 | [NAME] | Long Round - Blue - 15cm x 92cm | 2 | 1 roller | 1 | 0 | 15.38 | EACH | 23.08.2023
 | 976040-6MMS | VASYLI HEELLIFTS/RAISES | SOLD IN PAIRS - 6MM SMALL. | 4 | 1 pair |  | 2 | 5.95 | EACH | 23.08.2023
 | 976040-8MMS | VASYLI HEELLIFTS/RAISES | SOLD IN PAIRS - 8MM SMALL | 4 | 1 pair |  | 0 | 5.95 | EACH | 23.08.2023
 | 976040-8MMM | VASYLI HEELLIFTS/RAISES | SOLD IN PAIRS - 8MM MEDIUM | 4 | 1 pair |  | 1 | 5.95 | EACH | 23.08.2023
 | 976040-8MML | VASYLI HEELLIFTS/RAISES | SOLD IN PAIRS- 8MM LARGE | 4 | 1 pair | 4 | 0 | 5.95 | EACH | 23.08.2023
 | [NAME] | OS1ST AF7 ANKLE SLEEVE | Black/Right Medium | 2 | 1 sleeve |  | 2 | 23.1 | EACH | 23.08.2023
 | AF7BRXL | OS1ST AF7 ANKLE SLEEVE BLACK | Black/Right Xlarge | 2 | 1 sleeve |  | 0 | 23.1 | EACH | 23.08.2023
 | 4234 | Clini-clean head pads with X-Cut | Carton of 1000 | 1 | 1000 |  | 250 | 85 | EACH | 23.08.2023
 | 9219 | DEEP HEAT BACK PATCHES | 2 x 9.5cm x 26.5cm | 6 | 2 patches |  | 6 | 14.25 | EACH | 23.08.2023
 | 50084 | CLINELL UNIVERSAL WIPES | (225) REFILL - MULTI PURPOSE WIPES | 3 | 3 |  | 3 | 29.32 | EACH | 17.10.2023
 | 8430 | [NAME] KLEENEX Compact Towel) | Carton of 24 19CM x 29.5CM (4440-01) | 1 | 225 |  | 10 | 92.85 | EACH | 17.10.2023
 | [NAME] | POW.R E C OFRIENDLY FOAM ROLLER | SHORTROUND 15cm x 30cm **DWO** | 1 | 1 roller |  | 1 | 15 | EACH | 17.10.2023
 | PW084 | POW.R ECO FRIENDLY FOAM EACH ROLLER - | MEDIUM ROUND 15cm × 45cm **DWO** | 3 | 1 roller |  | 3 | 19 | EACH | 17.10.2023
 | 8146 | ALPHASPORT FOAM ROLLER | Long Round - Blue - 15cm x 92cm | 4 | 1 roller |  | 4 | 30 | EACH | 17.10.2023
 | SM200 | Tubular Form Tan - latex free | [NAME]	10m	4cm *unstretched width
 | SM201 | Tubular Form Tan - latex free | [NAME]	10m	6.5cm *unstretched width
 | SM202 | Tubular Form Tan - latex free | [NAME]	10m	7cm *unstretched width
 | SM203 | Tubular Form Tan - latex free | [NAME]	10m	7.5cm *unstretched width
 | SM204 | Tubular Form Tan - latex free | [NAME] 10mm (adult legs) | 1 |  |  | 1 | 28.35 | EACH | 17.10.2023
 | SM205 | Tubular Form Tan - latex free | [NAME]	10m	10cm *unstretched width
 | SM206 | Tubular Form Tan - latex free | [NAME]	10m	12.5cm *unstretched width
Spreadsheet: 28328ab4-0433-4e98-9e9d-9744797c37bb
Sheet: Sheet1

Instructions for Completing the LEA Jobs and Spending Form as required by ARRA:
HEADING:  Read and fill in all information requested.
1.  Save the form and add your LEA name to the end of the filename.
2.  [NAME] the following information:  District, Consultant, and Quarter-Ending date.
3.  After the form is complete, type the Director of [NAME]  name in the box. should read the assurance statement and certify report on E-reporting.
4. Before certifying the report, the Director of Schools should read the assurance statement
CERTIFICATION:
1.  Director of Schools will locate the NCLB ARRA Q1 1512 Report on E-reporting.
2.  Director of Schools will certify that the information presented is correct and that an the electronic copy has been sent to the consultant.
JOB REPORTING:  It is mandated in Section 1512 of the American Recovery and Reinvestment Act that each Title / Program
receiving ARRA funds report both jobs and numbers and vendors receiving ARRA funds.
1.  Enter the Full-Time Equivalent (FTE) positions created and/or retained for each ARRA project.  These positions need to be placed
in the appropriate job category.
2.  The spreadsheet total column will auto-calculate the total for each project.
3.  In the box beneath the Job Verification line, a narrative description must be added for each project (see Narrative Example
at bottom of form).
VENDOR INFORMATION:  The purpose of this report is to identify vendors receiving ARRA funds for  the entire grant period.
1.  Enter the cumulative amount paid (funds spent, not purchase orders) to vendors from ARRA funds ONLY in the box provided.
2.  Enter the amount paid  during the current quarter to all vendors from ARRA funds.
3.  On the lines provided, identify vendors receiving in excess of $25,000 either by the Name of Entity AND the Vendor's D-U-N-S number OR
the Zip Code + 4 of the Company Headquarters.
4.  List all single payments to vendors for prior quarters AND current quarter.  All in excess of 25,000 or greater will be listed each quarter.
5.  Once a vendor has a single payment greater than 25,000 in a quarter, this vendor payment - plus any additional payments to the vendor-
will be listed on this report and any successive reports.
6.  The remaining information will auto-calculate.
This completed form should be electronically sent to your NCLB Consultant by  March 19,2010 for the quarter ending March 31, 2010 (Q1).  For
the quarter ending June 30, 2010 (Q2), the forms are due to your NCLB Consultant by June 18, 2010.
REMEMBER:  What constitues a full-time schedule may differ from district to district.
Spreadsheet: 705673d1606248631-data-comparison-and-aggregation-looking-for-help-copy-template-1-
Sheet: analysis

 |  |  |  |  |  |  |  |  |  |  |  | post Code
ID | Acc Num |  |  | Value | totalValue | otherPercentage | otherCharge | My%Charged | MyCharge | MybrandCheaper? |  |  | Total value (agg and non agg) | family pricing % | family pricing charge
111 | 1111 |  |  | 1133059.89 | 1133059.89 |  |  |  |  |  |  |  |  |  |  | I will use the same formula as in column H3 for the total value in N3
111 | 1112 |  |  | 3984.4 | 3984.4
222 | 1113 |  |  | 199959.2 | 199959.2
222 | 1114 |  |  | 716513.7 | 716513.7
222 | 1115 |  |  | 55676.77 | 55676.77
333 | 1116 |  |  | 38657.34 | 38657.34
333 | 1117 |  |  | 445112.3 | 445112.3
444 | 1118 |  |  | 121 | 121
444 | 1119 |  |  | 157763.62 | 157763.62
555 | 1120 |  |  | 612748.12 | 612748.12
555 | 1121 |  |  | 906128.44 | 906128.44
666 | 1122 |  |  | 5678224.49 | 5678224.49
777 | 1123 |  |  | 456034.94 | 456034.94
777 | 1124 |  |  | 123456.29 | 123456.29
888 | 1125 |  |  | 2509.43 | 2509.43
888 | 1126 |  |  | 75748.43 | 75748.43
888 | 1127 |  |  | 12745.31 | 12745.31
999 | 1128 |  |  | 123461.02 | 123461.02
999 | 1129 |  |  | 509000.2 | 509000.2
1000 | 1130 |  |  | 131575.33 | 131575.33
1000 | 1131 |  |  | 31040.95 | 31040.95
Spreadsheet: 104572d1302121337-if-and-function-or-other-copy-of-sample-20worksheet-202-1-
Sheet: Sheet1

Prediction | Actual | Points
[NAME] | [NAME] | 16 | 16
G2 | [NAME] | 5 | 5
G3 | [NAME] | 4 | 4
G4 | [NAME] | 3 | 3
G5 | [NAME] | 4 | 4
G6 | [NAME] | 3 | 3
G7 | [NAME] | 0 | 0
G8 | [NAME] | 0 | 0
[NAME] | G2 | 5 | 5
G2 | G2 | 25 | 25
G3 | G2 | 2 | 2
G4 | G2 | 2 | 2 |  |  | [NAME] | G2 | G3 | G4
G5 | G2 | 2 | 2 |  | [NAME] | 16 | 5 | 2 | 4
G6 | G2 | 2 | 2 |  | G2 | 5 | 25 | 2 | 2
G7 | G2 | 0 | 0 |  | G3 | 4 | 2 | 13 | 4
G8 | G2 | 0 | 0 |  | G4 | 3 | 2 | 3 | 10
[NAME] | G3 | 2 | 2 |  | G5 | 4 | 2 | 2 | 2
G2 | G3 | 2 | 2 |  | G6 | 3 | 2 | 2 | 3
G3 | G3 | 13 | 13
G4 | G3 | 3 | 3
G5 | G3 | 2 | 2
G6 | G3 | 2 | 2
G7 | G3 | 0 | 0
G8 | G3 | 0 | 0
[NAME] | G4 | 4 | 4
G2 | G4 | 2 | 2
G3 | G4 | 4 | 4
G4 | G4 | 10 | 10
G5 | G4 | 2 | 2
G6 | G4 | 3 | 3
G7 | G4 | 0 | 0
G8 | G4 | 0 | 0
Spreadsheet: 0a1476f1-9c5b-4d8f-a8e0-15665507a9e7
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
[NAME] | Gymnastics | at Pitt | 12:00 AM | W, 194.675-193.55
01/19/2013 | Gymnastics | at Utah | 12:00 AM | L, 196.95-192.125
01/19/2013 | Gymnastics | vs. Oregon State (at Utah) | 12:00 AM | L, 195.95-192.125
01/19/2013 | Gymnastics | vs. Southern Utah | 12:00 AM | W, 192.125-191.05
01/25/2013 | Gymnastics | at NC State | 12:00 AM | L, 195.2-195.15
02/01/2013 | Gymnastics | Oklahoma* | 12:00 AM | L, 197.375-196.05
02/01/2013 | Gymnastics | Western Michigan | 12:00 AM | W, 196.05-192.475
02/01/2013 | Gymnastics | William & Mary | 12:00 AM | W, 196.05-192.225
02/10/2013 | Gymnastics | Iowa State* | 12:00 AM | W, 196.15-194.825
[NAME] | Gymnastics | at Maryland | 12:00 AM | L, 196.175-195.775
[NAME] | Gymnastics | vs. Rutgers (College Park, Md.) | 12:00 AM | W, 195.775-195.05
[NAME] | Gymnastics | Michigan | 12:00 AM | L, 196.925-196.55
[NAME] | Gymnastics | Towson | 12:00 AM | W, 196.55-193.15
[NAME] | Gymnastics | New Hampshire | 12:00 AM | W, 196.55-194.875
03/03/2013 | Gymnastics | Denver | 12:00 AM | L, 196.8-196.375
03/03/2013 | Gymnastics | Temple | 12:00 AM | W, 196.375-191.625
03/03/2013 | Gymnastics | [NAME] | 12:00 AM | W, 196.375-195.3
03/10/2013 | Gymnastics | at [NAME] | 12:00 AM | W, 195.45-194.5
03/15/2013 | Gymnastics | Maryland | 12:00 AM | W, 196.05-194.8
03/15/2013 | Gymnastics | Rutgers | 12:00 AM | W, 196.05-194.175
03/23/2013 | Gymnastics | Big 12 Championships (Ames, Iowa) | 12:00 AM | Third Place, 194.675
[NAME] | Gymnastics | NCAA Morgantown Regional | 12:00 AM | Fifth Place, 194.475
Spreadsheet: 3ae85187-ab35-4b1c-8054-1662d89580da
Sheet: Sheet1

Name | Address | City | State | ZIP | Phone | County
Sutherlands | 1801 South Zero St. | Fort Smith | AR | 72901 | [PHONE] | [NAME]
SEARS Corporate | 1901 S Caraway Rd Ste 1 | Jonesboro | AR |  | [PHONE] | Craighead
[NAME] | 201 N. Arkansas Ave. | Russellville | AR | 72801 | [PHONE] | Pope
[NAME]'s Best Brands Plus (Freemyers) | [NAME] | Stuttgart | AR | 72160 | [PHONE] | Arkansas
Sears Dealer Store | 201 Skyline Dr., Ste. 35 | Conway | AR | 72032 | [PHONE] | Faulkner
TUCKERS FUNITURE AND APPLIANCE | 2013 N. 13TH STREET | ROGERS | AR | 72756 | [PHONE]
[NAME]'s Appliance Center (Tuckers) | 2013 N. 13th | Rogers | AR | 72756 | [PHONE] | [NAME]
[NAME] | 2020 NW Ave | El Dorado | AR | 71730 | [PHONE]
Best Buy Co., Inc. | 20815 I-30 | BENTON | AR | 72022 | [PHONE] | Saline
[NAME] | 209 Shoppingway | West Memphis | AR | 72301 | [PHONE]
S & K Quality Plumbing | [NAME]. | [NAME] | AR | 72002 | [PHONE]
Lowe's Home Centers, Inc. (Lowes) | 2111 FAIR PARK BLVD. | JONESBORO | AR | 72401 | (870)930-9000 | CRAIGHEAD
Lowe's Home Centers, Inc. (Lowes) | 212 NORTH 23RD STREET | PARAGOULD | AR | 72450 | (870)586-2000 | GREENE
Lowe's Home Centers, Inc. (Lowes) | 2120 FAYETTEVILLE ROAD | [NAME] | AR | 72956 | (479)494-4470 | CRAWFORD
Zellner Appliance & TV | 2130 Harkrider Street | Conway | AR | 72032 | [PHONE] | Faulkner
Southern Pipe & Supply Co. | 2135 Harkrider | Conway | AR | 72032 | [PHONE] | Faulkner
Quality Furniture & Appliance | 215 [NAME] | [NAME] | AR | 72110 | [PHONE] | Conway
Bud's Home Appliance Center, Inc. | 218 [NAME], Suite B | [NAME] | AR | 72031 | [PHONE]
Dependable Maytag | 2202 N. College Ave | Fayetteville | AR | 72703 | [PHONE] | Washington
[NAME] Home Furnishings | 2210 Towson Ave. | Fort Smith | AR | 72901 | [PHONE] | [NAME]
Best Buy Co., Inc. | 2220 PROMENADE BLVD | ROGERS | AR | 72758 | [PHONE] | [NAME]
Bever's Ace Hardware | 229 E Main St | Gentry | AR | 72734 | [PHONE] | [NAME]
[NAME] | 23 Southpark | Nashville | AR | 71852 | [PHONE] | [NAME]
Lowe's Home Centers, Inc. (Lowes) | 2301 T.P. WHITE DRIVE | JACKSONVILLE | AR | 72076 | (501)241-1500 | PULASKI
SEARS | 2310 E RACE AVE | SEARCY | AR | 72143 | [PHONE]
Spreadsheet: 136257d1326493003-how-to-merge-multiple-lines-on-a-time-sheet-sched-time-sheet-integration2
Sheet: Site 1

Employee Number | Name |  |  |  |  |  |  |  | Reg Hours | OT Hours | Unworked Stat Hours | Total Weekly Hours | Su | Mo | [NAME] | We | Th | Fr | Sa | Reg Hours | OT Hours | Unworked Stat Hours | Total Weekly Hours | Total Bi-Weekly Hours
Spreadsheet: 730188d1619599830-how-to-get-records-based-on-a-condition-using-index-match-example
Sheet: Sheet1

Area | Item | Frequency |  |  | Show: | Monthly
[NAME] | Item1 | Monthly
[NAME] | Item2 | Monthly
[NAME] | Item3 | Weekly
[NAME] | Item4 | Monthly
[NAME] | Item5 | Monthly
Area2 | Item2 | Weekly
Area2 | Item1 | Weekly
Area2 | Item3 | Weekly
Area3 | Item5 | Weekly
Area3 | Item7 | Weekly
Area3 | Item2 | Monthly
Area3 | Item1 | Weekly
Area3 | Item3 | Monthly
Area3 | Item4 | Weekly
Area3 | Item6 | Weekly
Spreadsheet: 04cf6079-2572-440f-8027-56a1ae1977db
Sheet: T10

الجدول 10: السكان في الكويت بحسب [NAME] تعداد 2005
Table 10: Population of Kuwait by age groups, 2005 census
 | Nationals | المواطنون | Non-nationals | [NAME] | Urban | حضر | Rural | ريف | Total | المجموع | المجموع
[NAME] | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | [NAME]
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | 59349 | 55874 | 40116 | 36836 | … | … | … | … | 99465 | 92710 | 192175
5-9 | 60713 | 56447 | 36483 | 34362 | … | … | … | … | 97196 | 90809 | 188005
10-14 | 56307 | 52961 | 30358 | 27262 | … | … | … | … | 86665 | 80223 | 166888
15-19 | 49908 | 48294 | 30820 | 27027 | … | … | … | … | 80728 | 75321 | 156049
20-24 | 40363 | 39596 | 73278 | 46927 | … | … | … | … | 113641 | 86523 | 200164
25-29 | 31071 | 33425 | 144668 | 71197 | … | … | … | … | 175739 | 104622 | 280361
30-34 | 27294 | 30291 | 145039 | 66849 | … | … | … | … | 172333 | 97140 | 269473
35-39 | 24481 | 27565 | 130143 | 55678 | … | … | … | … | 154624 | 83243 | 237867
40-44 | 20827 | 23616 | 94116 | 39253 | … | … | … | … | 114943 | 62869 | 177812
45-49 | 15727 | 19912 | 68968 | 24309 | … | … | … | … | 84695 | 44221 | 128916
50-54 | 11827 | 15144 | 42088 | 13175 | … | … | … | … | 53915 | 28319 | 82234
55-59 | 8120 | 11328 | 22165 | 6941 | … | … | … | … | 30285 | 18269 | 48554
60-64 | 6834 | 8134 | 9652 | 3714 | … | … | … | … | 16486 | 11848 | 28334
65+ | 12458 | 12458 | 7174 | 4729 | … | … | … | … | 19632 | 17187 | 36819
غير محدد    Not stated | … | … | … | … | … | … | … | … | … | … | …
المجموع    Total | 425279 | 435045 | 875068 | 458259 | … | … | … | … | 1300347 | 893304 | 2193651
Spreadsheet: kate_symes__18478__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-19 00:00:00 |  | 559.4 | 25088 | 411.6 | 8344
 | 2001-01-18 00:00:00 |  | 481.44 | 21424 | 392.14 | 5112 | 454.07 | 393 | 294.21 | 380
 | 2001-01-17 00:00:00 |  | 272.66 | 29824 | 248.16 | 6312 | 428.17 | 196 | 285.3 | 495
 | 2001-01-16 00:00:00 |  | 179.29 | 23760 | 158.21 | 3800 | 422.32 | 6337 | 190 | 50
 | 2001-01-15 00:00:00 |  | 179.29 | 23760 | 158.21 | 3800 | 205.96 | 83 | 210 | 22
 | 2001-01-14 00:00:00 |  | 158.5 | 0 | 152.5 | 0 | 175.38 | 920 | 157.2 | 820 |  | 152.44 | 15000
 | 2001-01-13 00:00:00 |  | 158.65 | 17648 | 151.85 | 6600 | 180.04 | 1330 | 158.51 | 865
 | 2001-01-12 00:00:00 |  | 171.71 | 16368 | 147.69 | 5432 | 181.08 | 185 | 149.35 | 575
 | 2001-01-11 00:00:00 |  | 171.43 | 15360 | 147.59 | 5936 | 157.64 | 254 | 119.48 | 1146
 | 2001-01-10 00:00:00 |  | 157.57 | 15328 | 144.37 | 5680 | 149.25 | 499 | 120.6 | 712
 | 2001-01-09 00:00:00 |  | 152.13 | 22160 | 145.73 | 6400 | 148.76 | 1729 | 123.36 | 640
 | 2001-01-08 00:00:00 |  | 147.54 | 22800 | 130.49 | 6480 | 115.32 | 470 | 102.22 | 1125
 | 2001-01-07 00:00:00 |  | 140 | 0 | 130 | 0 | 119.61 | 888 | 82.66 | 800 |  | 130.49 | 19440
 | 2001-01-06 00:00:00 |  | 146.05 | 22800 | 135.85 | 3616 | 103.18 | 1305 | 98.34 | 1325
 | 2001-01-05 00:00:00 |  | 146.05 | 22800 | 135.85 | 3616 | 134.44 | 1345 | 120.8 | 1155
 | 2001-01-04 00:00:00 |  | 152.95 | 20280 | 139.1 | 5544 | 143.03 | 190 | 127.53 | 415
 | 2001-01-03 00:00:00 |  | 175.7 | 14400 | 163.68 | 3800 | 156.14 | 485 | 127.71 | 648
 | 2001-01-02 00:00:00 |  | 185.67 | 14400 | 176.33 | 3000 | 142.46 | 2097 | 126.6 | 1453
 | 2001-01-01 00:00:00 |  | 187.5 | 0 | 175 | 0 | 111.05 | 95 | 110 | 300 |  | 176.33 | 9000
 | 2000-12-31 00:00:00 |  | 167.5 | 0 | 157.5 | 0 | 150.12 | 2630 | 110 | 450 |  | 164.5 | 19440
 | 2000-12-30 00:00:00 |  | 171.7 | 19408 | 160.7 | 5608 | 146.38 | 705 | 145.32 | 1175
 | 2000-12-29 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 214.02 | 1107 | 166.68 | 674
 | 2000-12-28 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 190.98 | 1381 | 158.36 | 802
 | 2000-12-27 00:00:00 |  | 394.68 | 12400 | 267.17 | 3320 | 165.54 | 2855 | 159.35 | 1123
 | 2000-12-26 00:00:00 |  | 451.15 | 10624 | 428.32 | 2712 | 182.26 | 2772 | 177.14 | 934
 | 2000-12-25 00:00:00 |  | 410 | 32 | 315 | 200 | 201.38 | 12441 | 207.74 | 775 |  | 377.09 | 5160
 | 2000-12-24 00:00:00 |  |  |  | 315 | 200 | 225.8 | 1588 | 225.35 | 855 |  | 377.09 | 5160
 | 2000-12-23 00:00:00 |  | 462.41 | 8224 | 382.64 | 1912 | 325.41 | 4915 | 244.19 | 2400
 | 2000-12-22 00:00:00 |  | 463 | 8624 | 382.94 | 1712 | 349.16 | 4653 | 309.33 | 2630
 | 2000-12-21 00:00:00 |  | 463 | 8624 | 384.75 | 2112 | 425 | 150 | 350 | 50
 | 2000-12-20 00:00:00 |  | 463.54 | 9424 | 386.4 | 1912 | 411.71 | 1117 | 365.63 | 240
 |  |  |  |  |  | ..
Spreadsheet: 541120d1507127716-simplex-lp-solver-problem-jp-morgan-chase-atm-problem
Sheet: Sheet1

Location | A | B | C | D | E | F | G | H
Invest? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Used | Available
Amount | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 28000
ROI | 0.07 | 0.09 | 0.04 | 0.25 | 0.21 | 0.14 | 0.08 | 0.16
Total ROI
Constraints
Total Amount invested <= 28,000
If a location is chosen, at least 700 and no more than 7000 must be invested
Location B cannot be pursued unless Location A is
Location C cannot be pursued unless Location A is
Location D cannot be pursued unless Location B is
Location D cannot be pursued unless Location C is
If [NAME] is chosen, so must Location G (and vice versa)
Locations E and F cannot be pursued at the same time
Spreadsheet: 805011d1668475759-solver-for-resource-allocation-sample
Sheet: Sheet1

 |  |  | SAMPLE DATA
 |  |  | EmpID | Grade | Type | Name | Join Date | Duration
 |  |  | 19467 | [NAME] | T1 | A | 2015-12-12 00:00:00
 |  |  | 19468 | [NAME] | T1 | B | 2016-01-06 00:00:00
 |  |  | 19469 | [NAME] | T2 | C | 2016-03-04 00:00:00
 |  |  | 19470 | [NAME] | T3 | D | 2017-03-25 00:00:00
 |  |  | 19471 | G2 | T1 | E | 2017-04-05 00:00:00
 |  |  | 19472 | G2 | T2 | F | 2017-12-19 00:00:00
 |  |  | 19473 | G2 | T3 | G | 2018-05-08 00:00:00
 |  |  | 19474 | G3 | T1 | H | 2019-01-21 00:00:00
 |  |  | 19475 | G3 | T2 | I | 2020-02-18 00:00:00
 |  |  | 19476 | G3 | T4 | J | 2021-03-31 00:00:00
 |  |  | DESIRED RESULT
 |  |  | SET 1 | SET 2 | SET 3 | SET 4
 |  |  | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  | G2-T1 | G2-T2 | G2-T3 | G3-T1
 |  |  | G3-T2 | G3-T4
 |  |  | Note:  Criteria 1  is to distribute the 'Grades' equally amongst the sets [NAME]  is to distribute the 'Trades' equally amongst the sets Criteria 3  is to distribute the 'Duration' equally amongst the sets
Spreadsheet: 247f7d11-93c3-4ac1-b101-7c7048b41b20
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Housing Opportunity Index: 1st Quarter 2014
 |  | Areas with Population of 500,000 or more in 2012
 |  | 10 Most Affordable Metro Areas |  |  |  | 10 Least Affordable Metro Areas
 | 1 | Syracuse, NY |  |  | 1 | San Francisco-San Mateo-Redwood City, CA ^^^
 | 2 | Buffalo-Niagara Falls, NY |  |  | 2 | Santa Ana-Anaheim-Irvine, CA ^^^
 | 2 | Youngstown-Warren-Boardman, OH-PA |  |  | 3 | Los Angeles-Long Beach-Glendale, CA ^^^
 | 4 | Harrisburg-Carlisle, PA |  |  | 4 | New York-White Plains-Wayne, NY-NJ ^^^
 | 5 | Dayton, OH |  |  | 5 | San Jose-Sunnyvale-Santa Clara, CA
 | 6 | Scranton--Wilkes-Barre, PA |  |  | 6 | San Diego-Carlsbad-San Marcos, CA
 | 6 | Toledo, OH |  |  | 7 | Oakland-Fremont-Hayward, CA ^^^
 | 8 | Wichita, KS |  |  | 8 | Honolulu, HI
 | 9 | Grand Rapids-Wyoming, MI |  |  | 9 | Oxnard-Thousand Oaks-Ventura, CA
 | 10 | Lakeland-Winter Haven, FL |  |  | 10 | Riverside-San Bernardino-Ontario, CA
 |  | Areas with Population under 500,000 in 2012
 |  | 10 Most Affordable Metro Areas |  |  |  | 10 Least Affordable Metro Areas
 | 1 | Cumberland, MD-WV |  |  | 1 | Santa Cruz-Watsonville, CA
 | 2 | Springfield, OH |  |  | 2 | Napa, CA
 | 3 | Kokomo, IN |  |  | 3 | Salinas, CA
 | 4 | Mansfield, OH |  |  | 4 | [NAME], CA
 | 5 | Lima, OH |  |  | 5 | [NAME], CA
 | 6 | Davenport-Moline-Rock Island, IA-IL |  |  | 6 | Santa Barbara-Santa Maria-Goleta, CA
 | 7 | Saginaw-Saginaw Township North, MI |  |  | 7 | Ocean City, NJ
 | 8 | Elizabethtown, KY |  |  | 8 | Laredo, TX
 | 9 | [NAME], MI |  |  | 9 | Barnstable Town, MA
 | 10 | Sandusky, OH |  |  | 10 | Flagstaff, AZ
 |  | Sales Transaction Data:  Core Logic
 |  | Interest Rates: Federal Housing Finance Agency
 |  | Median Household Income: Housing & Urban Development Department (HUD)
 |  | Property Taxes & Insurance:  Bureau of the Census
 |  | Population:  Bureau of the Census
 |  | ^^^  Indicate Metropolitan Divisions.  All others are Metropolitan Statistical Areas.