tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 110141d1306905281-running-calculations-by-date-example-1
Sheet: Sheet1

2011-05-01 00:00:00
 | collected | Number of items |  | outstanding | Number of Items |  | losses | Number of Items
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Spreadsheet: daren_farmer__6580__egmnom-Feb
Sheet: RHODIA

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-27106-02-011
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 2000-02-01 00:00:00
Fax: | (713)207-0054 | Stop:
 |  | 2000-02-29 00:00:00
RECEIPTS |  |  | FEB | FEB | FEB | FEB | FEB
METER # | [NAME] | SUPPLIER | 1
4132 | EXXON KATY | [NAME] (MIDCON 92155) | 500 | 500 | 500 | 500 | 500
ZZZZ | IMBALANCE |  | 0 | 0 | 0 | 0 | 0
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
8078 | RHODIA-FREEPORT | RHODIA-FREEPORT | 500 | 500 | 500 | 500 | 500
ZZZZ | IMBALANCE |  | 0 | 0 | 0 | 0 | 0
 |  | DELIVERY TOTAL
 |  | BALANCE
Spreadsheet: 741557d1627134234-how-to-count-cells-only-when-they-have-content-aligw
Sheet: Calculations

 | P | W | D | L | F | A | Pts | [NAME] | [NAME] | Goals Scored | Name | Rank | New Total
Birmingham City
Wycombe Wanderers
Barnsley
Bournemouth
Bristol City
Cardiff City
Derby County
Huddersfield Town
Millwall
[NAME]
Queens Park Rangers
Coventry City
[NAME]
[NAME]
Brentford
[NAME]
Middlesbrough
Norwich City
Reading
[NAME]
Sheffield Wednesday |  |  |  |  |  |  |  |  |  |  |  |  |  | -6
Swansea City
Stoke City
Spreadsheet: 805907d1669002175-how-to-create-a-formula-to-recognise-cells-with-coloured-fill-and-multipy-it-by-say-6-sample-for-excel-forum-v2
Sheet: Sheet1

No | 1 to 6 | 7 to 12 | 13 to18 | 19 to 24 | 25 to 30 | 31 to36 |  | O/L | RET | PROF | BAL
 |  |  |  |  |  |  |  |  | (Color x 6) |  | 0
26 |  |  |  |  | 1
19 |  |  |  | 2
12 |  | 3
7 |  | 4
31 |  | 5
19 |  | 6 |  |  |  | 6
29 |  |  |  | 7
17 |  |  | 8
5 | 9
11 |  |  |  | 10
15
4
5
24
17
5
11
35
Spreadsheet: 883434d1732057371-if-and-and-in-the-same-function-lookup-formula-eba
Sheet: Invoices (Sales)

Area | [NAME] | Sales Group
 | [NAME] | C34
 | Brent K | U67 |  |  |  |  |  |  |  |  |  |  |  |  | C34 | Mexico
 | Brent K | U67 |  |  |  |  |  |  |  |  |  |  |  |  | U67 | West 1
 | [NAME] Q | U67 |  |  |  |  |  |  |  |  |  |  |  |  | U00 | Foreign Country
 | [NAME] Q | U67 |  |  |  |  |  |  |  |  |  |  |  |  | Naveen WU00 | Naveen W - Foreign Country
 | Naveen W | U00 | I have this IF formula in Column A
 | [NAME] | U00 | IF(@C:C="U67","West 1",IF(@C:C="C34","Mexico",IF(@C:C="U00","Foreign Country","")))
 | Brent K | U00
 |  |  | and I would like the formula to show
 |  |  | IF it is U00 in Column C AND Naveen W in B - I would like column A to show Foreign Country - Naveen W
 |  |  | and all the other U00 in column C to show just Foreign Country
Spreadsheet: 850135d1700515137-wrong-sum-up-values-from-a-range-with-xlookup-and-index-match-formula-overtime-blank-format-2017-2-
Sheet: AUTHORIZATION (5)

King Fahd Armed Forces Hospital, Jeddah
مستشفى الملك فهد لللقوات المسلحة بجدة
FINANCE DEPARTMENT
[NAME]
OVERTIME AUTHORIZATION & CONTROL FORM
نموذج تصريح و مراقبة التكليف بالعمل الاضافي
 | Department Name / اسم القسم |  |  |  | Human Resource |  |  |  |  |  |  |  |  | 4701 |  |  |  |  |  |  |  |  |  | Dept. No. / رقم القسم |  |  |  |  |  |  |  | 4701
 | Pay Period Ending / الدفع نهاية الفترة |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
# | Emp. # | Employee Name |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total | Employee Signature
 | [NAME] | اسم الموظف |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | الإجمالى | توقيع الموظف
1 | 4192 | MARIA SOCORRO REYES |  |  | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 | 6 |  | 3 | 3 | 3 | 3 | 3
2 | 8363 | JAYMAR BARDON |  |  | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 | 6 |  | 3 | 3 | 3 | 3 | 3
3 | 13846 | JEFFERSON DALUSON |  |  | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 | 6 |  | 3 | 3 | 3 | 3 | 3
4 | 14118 | JADE BIDAN |  |  | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 | 6 |  | 3 | 3 | 3 | 3 | 3
5 | 14714 | SIGRID AMABEL FRANCISCO |  |  | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 | 6 |  | 3 | 3 | 3 | 3 | 3
6 | 14994 | RINA [NAME] |  |  | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 | 6 |  | 3 | 3 | 3 | 3 | 3
7 | 16537 | NESVAN JOY SARMIENTO |  |  | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 | 6 |  | 3 | 3 | 3 | 3 | 3
8
9
10
11
12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Overtime Hour
 |  |  | Signature / توقيع |  |  |  |  |  |  |  |  |  |  | Approved by  /  الموافقة من |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Certified by / مصدقة من
 |  |  | Department Head |  |  |  |  |  |  |  |  |  | Finance Director |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hospital Director
 |  |  | رئيس القسم |  |  |  |  |  |  |  |  |  | مدير [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | مدير المستشفى
Spreadsheet: 853011d1702979946-correct-let-formula-to-remove-certain-filters-daily-market-reportcopy
Sheet: Sheet2

VESSEL |  | VESSEL + PLN |  | VESSEL TYPE |  | BOX TYPE |  | TRIP DATES |  | FISHING AREA |  | FSIHING TIME |  | HAULS TO ADD
[NAME] |  | [NAME] | BPS | TRAWL |  | BPS |  |  |  | FAO27-Sub / Area: IV |  | 1 day |  | 0
KEILA |  | [NAME] | BPS | SEINE |  | GKN |  |  |  | FAO27-Sub / Area: VI |  | 2 days |  | 1
CEOL NA MARA |  | [NAME] | BPS |  |  | LHD |  |  |  | FAO27-Sub / Area: IV  + VI |  | 3 days |  | 2
GENESIS |  | Genesis BF505 | BPS |  |  |  |  |  |  | FAO27-Sub / Area: IV + VI |  | 4 days |  | 3
CALEDONIA |  | [NAME] | BPS |  |  |  |  |  |  | FAO27-Sub / Area: Vb |  | 5 days |  | 4
CARINA |  | [NAME] | BPS |  |  |  |  |  |  | FAO27-Sub / Area: VIb |  | 6 days |  | 5
[NAME] |  | Radiance INS240 | BPS |  |  |  |  |  |  | FAO27-Sub / Area: VIa + VIb |  | 7 days |  | STILL FISHING
LOCH INCHARD |  | Loch Inchard III UL44 | BPS |  |  |  |  |  |  | FAO27-Sub / Area: VIa + VIb + IVa |  | 8 days
RELIANCE |  | Reliance III BF800 | BPS |  |  |  |  |  |  | FAO27-Sub / Area: IV + VI + Vb |  | 9 days
[NAME] |  | Transcend BF61 | BPS |  |  |  |  |  |  | FAO27-Sub / Area: IV + Vb |  | 1.5 days
AQUARIUS |  | Aquarius BF89 | BPS
SP/ STAR |  | Sparkling Star UL290 | BPS
ADVENTURER |  | Adventurer INS8 | GKN
DEESIDE |  | Deeside BCK595 | BPS
FLADDA MAID |  | [NAME] | GKN
VISION |  | Vision BF191 | BPS
SHEKINAH |  | [NAME] | BPS
LOLA V |  | Lola V BF100 | BPS
JOLANNA M |  | [NAME] | BPS
GRIANAN OIR |  | [NAME] | GKN
OCEAN ROSE |  | Ocean Rose INS115 | BPS
CONSORTIUM |  | Consortium [NAME] | GKN
CONQUEST |  | Conquest BCK364 | BPS
OCEAN BOUNTY |  | Ocean Bounty PD182 | BPS
AVRELLA |  | [NAME] | LHD
SERENITY |  | Serenity BF24 | BPS
WESTRA FJORD |  | [NAME] K193 | BPS
LIBERTY |  | Liberty BF120 | BPS
APOLLO |  | Apollo INS179 | BPS
NORLAN |  | [NAME] | BPS
OPPORTUNE |  | Opportune LK209 | LHD
OSPREY |  | [NAME] | GKN
NJORD VENTURE |  | Njord Venture INS291 | GKN
LEAH FAYE |  | Leah Faye WK290 | BPS
FISHER BOYS |  | Fisher Boys FR54 | GKN
VENTURE |  | Venture BF326 | BPS
ENDEAVOUR |  | Endeavour V BF515 | BPS
ACCORD |  | Accord BCK262 | BPS
FAITHLIE |  | [NAME] | BPS
ELLORAH |  | [NAME] BF12 | BPS
MORAY END |  | Moray Endeavour BCK17 | GKN
COURAGE |  | Courage SH170 | GKN
OCEAN VISION |  | Ocean Vision BF190 | BPS
Spreadsheet: 51fa725f-4b67-4866-a6ba-ae4383389f3b
Sheet: Sheet1

Unnamed: 0 | HEOA - Title II 2011 - 2012 Academic Year | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Institution Name | ST MARY-OF-THE-WOODS COLLEGE
Institution Code | 1704
State | Indiana
 |  |  |  |  | 2013-03-30 00:00:00
 |  |  |  | Statewide
Group | Number  Taking  Assessment1 | Number Passing Assessment2 | Institutional Pass Rate | Number  Taking  Assessment1 | Number Passing Assessment2 | Statewide  Pass Rate
All program completers, 2011-12 | 40 | 40 | 1 | 3322 | 3240 | 0.98
All program completers, 2010-11 | 41 | 41 | 1 | 3281 | 3245 | 0.99
All program completers, 2009-10 | 45 | 44 | 0.98 | 3316 | 3277 | 0.99
1 Number of completers taking one or more assessments within their area of specialization.
2 Number who passed all assessments taken within their area of specialization.
Spreadsheet: 272649d1382453312-formula-to-calculate-change-of-a-value-across-two-tables-tracker1
Sheet: Week2

Programs | Subject1 | Subject2 | Subject3 | Subject4 | Subject5 | Totals
101 | 1 | 2 | 1 | 3 | 1
102 | 2 | 2 | 1 | 2 | 1
103 | 3 | 2 | 1 | 2 | 1
104 | 1 | 1 | 1 | 2 | 1
105 | 1 | 2 | 2 | 1 | 1
106 | 4 | 1 | 1 | 3 | 1
107 | 1 | 4 | 2 | 3 | 1
107B | 2 | 3 | 2 | 1 | 2
108 | 1 | 4 | 1 | 2 | 2
109 | 4 | 1 | 1 | 3 | 2
110 | 2 | 1 | 3 | 1 | 1
111 | 1 | 2 | 2 | 1 | 1
Total
Spreadsheet: 4baef63d-5642-4223-b5d9-eacc836f06fa
Sheet: Page 5

Permit No.: |  |  | WQ0013398 |  |  | Facility Name: |  | Sandpiper Bay WWTF |  |  |  |  |  | County: | Brunswick |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | S-2 |  | Field Name: |  | S-3 |  | Field Name: |  | S-4 |  | Field Name: |  | S-5
 |  |  |  |  |  | Area (acres): |  | 1.82 |  | Area (acres): |  | 4.1 |  | Area (acres): |  | 4.16 |  | Area (acres): |  | 6.6
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 1 |  | [NAME] (in): |  | 1 |  | [NAME] (in): |  | 1 |  | [NAME] (in): |  | 1
 |  |  |  |  |  | Annual Rate (in): |  | 51 |  | Annual Rate (in): |  | 51 |  | Annual Rate (in): |  | 51 |  | Annual Rate (in): |  | 51
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 747496d1631541107-if-statment-for-more-than-2-arguments-fourm
Sheet: Sheet1

Final results |  | Value Output | Value Output Units | Parameter Limit (Output) | Column20 | Column2012 | Column2011 | Column2010 | Column209 | Column208 | Column207 | Column206 | Column205 | Column204 | Column203 | Column202 | Column21 | Result Parameter | LORR Value |  | UORR Value
 |  | 0 |  | LOR |  |  |  |  |  |  |  |  |  |  |  |  |  | Pass | 1.5 |  | 6.2
 |  | 1510 | nmol/l |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pass | 244 |  | 1767
 |  | 0 |  | LOR |  |  |  |  |  |  |  |  |  |  |  |  |  | Pass | 152 |  | 417
 |  | 41573 | nmol/l |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pass | 637 |  | 52385
 |  | 30536 | nmol/l |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pass | 2780 |  | 14168
 |  | 26.5 | nm |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pass | 25 |  | 100
 |  | 21.5 | nm |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pass | 18 |  | 25
 |  | 11.4 | nm |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pass | 8 |  | 12
 |  | 272 | mg/dl |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pass | 11 |  | 305
 |  | 167 | mg/dl |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pass | 6 |  | 173
 |  | 87 | mg/dl |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pass | 17 |  | 95
 |  | 60 | mg/dl |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pass | 44 |  | 179
Spreadsheet: f9e09cc3-3e3f-4857-b664-ddb868520a51
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
DAGL | Test | DAGL | Gliadin (Deamidated) Antibody, IgA, Serum | Gliadin(Deamidated) Ab, IgA, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | Negative: <20.0 U  Weak positive: 20.0-30.0 U Positive: >30.0 U Reference values apply to all ages. | Monday through Saturday; 4 p.m. | 1 day | 3 days | 1 | 83516 |  |  |  |  | Rochester
DAGL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
DAGL | Result | DAGL | Gliadin(Deamidated) Ab, IgA, S | Gliadin(Deamidated) Ab, IgA, S | Numeric |  |  |  |  | U |  |  |  |  |  |  |  |  |  | 20495-8
Spreadsheet: 843804d1695652164-creating-calendar-from-data-within-summary-page-of-workbook-rb-example
Sheet: 3

 |  |  |  |  |  | LODESTONE
 | [NAME]
 | PROJECT: |  |  |  | PROJECT NO:
 | DATE to CLAIM RETENTION:
 |  |  |  |  |  |  | Agreed Final Account | 0
 |  |  |  |  |  |  | Amount paid to date | 0
 |  |  |  |  |  |  | Retention held on LPLL
 | [NAME]
 | Agreed Final Account |  | Sub Contractor | Paid to Date | Retention owed to SC | %
 | 0 | 1 |  | 0
 | 0 | 2 |  | 0
 |  | 3 |  | 0
 |  | 4 |  | 0
 |  | 5 |  | 0
 |  | 6 |  | 0
 |  | 7 |  | 0
 |  | 8 |  | 0
 |  | 9 |  | 0
 |  | 10 |  | 0
 |  | 11 |  | 0
 |  | 12 |  | 0
 |  | 13 |  | 0
 |  | 14 |  | 0
 |  |  | Totals
 |  |  |  |  |  |  | Sub Total
 | Less Provisions etc. |  |  |  |  |  |  | 0
 | [NAME] to LPLL
Spreadsheet: 9ea774f0-2c18-4a20-8412-a77c19bb9cb1
Sheet: ELD

 | Statistics
 | FCLG_GROWTH_PERCENTILE
 | N | Valid | 75820
 |  | Missing | 0
 | Median |  | 51
 | Statistics
 | FCLG_GROWTH_PERCENTILE
 | 1 | N | Valid | 20880
 |  |  | Missing | 0
 |  | Median |  | 50
 | 2 | N | Valid | 54940
 |  |  | Missing | 0
 |  | Median |  | 52
 | MetAGP
 |  |  | Frequency | Percent | [NAME] | [NAME]
 | Valid | 0 | 34428 | 45.40754418359272 | 46.38329403839677 | 46.38329403839677
 |  | 1 | 39797 | 52.48878923766816 | 53.61670596160323 | 100
 |  | Total | 74225 | 97.89633342126088 | 100
 | Missing | System | 1595 | 2.103666578739119
 | Total |  | 75820 | 100
 | FCLG_DLPF_CODE * MetAGP Crosstabulation
 | Count
 |  |  | MetAGP |  | Total
 |  |  | 0 | 1
 | FCLG_DLPF_CODE | 1 | 6893 | 13943 | 20836
 |  | 2 | 27535 | 25854 | 53389
 | Total |  | 34428 | 39797 | 74225
Spreadsheet: 9bc37b32-d51e-4530-88b5-1a3607de46ce
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
MPLVA | Test | MPLVA | MPL Exon 10 Mutation Detection, Varies | MPL Exon 10 Mutation Detection, V | Mutation Detection in DNA Using Sanger Sequencing (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Varies: Var |  |  |  |  | [NAME]: Extracted DNA from blood or bone marrow Container/Tube: 1.5- to 2- mL tube with indication of volume and concentration of DNA [NAME] Volume: Entire specimen Collection Instructions: Label specimen as extracted DNA from blood or bone marrow Specimen Stability Information: Refrigerated/Ambient |  | No specimen should be rejected. If specimen not received at appropriate temperature or in wrong anticoagulant, include note to laboratory. If questions, contact laboratory. | An interpretive report will be provided. | Monday through Friday | 5 days | 8 days | 1 | 81403 |  |  |  |  | Rochester
MPLVA | [NAME] | VARIES | Varies |  |  |  | See instructions
MPLVA | Order Question | 34937 | Specimen: |  | Plain Text
MPLVA | Result | 34850 | Final Diagnosis: | Final Diagnosis: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34574-4 | Path report.final diagnosis:Imp:Pt:[NAME]:Nom:
MPLVA | Result | 34937 | Specimen: | Specimen: | Alphanumeric
Spreadsheet: 78651d1279014203-if-and-or-pricebreaks
Sheet: Sheet1

Qty | Total |  |  |  |  | Qty |  | Price
50 | 25 |  |  |  |  | 1 | 99 | 25
100 | 20 |  |  |  |  | 100 | 501 | 20
201 | 20 |  |  |  |  | 502 | + | 15
501 | 20
502 | 15
1000 | 15
99 | 25
0
Spreadsheet: 541234d1507190637-simplex-lp-solver-problem-jp-morgan-chase-atm-problem
Sheet: Sheet1

Location | A | B | C | D | E | F | G | H
Invest? | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | Used | Available
Amount | 712.0604268399381 | 5586.191090387366 | 706.0450240632285 | 7000 | 6999.999706635255 | 3811.594926888562 | 3136.74572763677 | 6994.956295526442 |  | 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 |  |  |  |  |  |  |  | J4
If a location is chosen, at least 700 and no more than 7000 must be invested |  |  |  |  |  |  |  | B4:H4
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 |  |  |  |  | both
If [NAME] is chosen, so must Location G (and vice versa)
Locations E and F cannot be pursued at the same time
 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1
4921 | 700 | 5600 | 700 | 7000 | 7000 | 700 | 700 | 7000
Spreadsheet: 273099d1382613096-count-number-of-cells-since-value-exceeded-some-number-query-cell-value-greater-than-x-since
Sheet: Sheet1

 |  |  | SL NO. | DATE | NIFTY | LN RETURNS
 |  |  | 1 | 2013-09-25 00:00:00 | 5873.8501
 |  |  | 2 | 2013-09-26 00:00:00 | 5882.25 | 0.001429028565258452
 |  |  | 3 | 2013-09-27 00:00:00 | 5833.2002 | -0.008373572634977962
 |  |  | 4 | 2013-09-30 00:00:00 | 5735.2998 | -0.01692574442744512
 |  |  | 5 | 2013-10-01 00:00:00 | 5780.0498 | 0.007772273847799043
 |  |  | 6 | 2013-10-03 00:00:00 | 5909.7002 | 0.02218280398682313
 |  |  | 7 | 2013-10-04 00:00:00 | 5907.2998 | -0.0004062621702658722
 |  |  | 8 | 2013-10-07 00:00:00 | 5906.1499 | -0.0001946764125353194
 |  |  | 9 | 2013-10-08 00:00:00 | 5928.3999 | 0.003760181264518869
 |  |  | 10 | 2013-10-09 00:00:00 | 6007.35 | 0.01322937429508272
 |  |  | 11 | 2013-10-10 00:00:00 | 6029 | 0.003597439979520719
 |  |  | 12 | 2013-10-11 00:00:00 | 6096 | 0.01105165887707665
 |  |  | 13 | 2013-10-14 00:00:00 | 6113.4 | 0.002850264841812283
 |  |  | 14 | 2013-10-15 00:00:00 | 6089 | -0.003999218599720465
 |  |  | 15 | 2013-10-17 00:00:00 | 6045 | -0.007252380559680976
 |  |  | 16 | 2013-10-18 00:00:00 | 6189 | 0.02354203869046843 | > THAN 1 %
 |  |  | 17 | 2013-10-21 00:00:00 | 6204 | 0.002420722557068023 | < THAN 1%
 |  |  | 18 | 2013-10-22 00:00:00 | 6202 | -0.0003224246360352142 | < THAN 1%
 |  |  | 19 | 2013-10-23 00:00:00 | 6178 | -0.003877226181867227 | < THAN 1%
 |  |  | 20 | 2013-10-24 00:00:00 | 6164 | -0.002268677038520663 | < THAN 1%
DAYS SINCE NIFTY MOVED MORE THAN 1%
MANUALLY IT WOULD BE |  |  | 2013-10-18 00:00:00 | TO | 2013-10-24 00:00:00 |  | 5 TRADING DAYS
HOW TO AUTOMATE THE SAME?
Spreadsheet: 6efcee13-b44c-4a93-bd15-a0719e8dcbf8
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
GALK | Test | GALK | Galactokinase, Blood | Galactokinase, B | Radioisotopic | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  |  | Varies | [NAME] must arrive within 48 hours of draw.   Container/Tube: Green top (sodium heparin) [NAME]: 5 mL Additional Information: Date of draw is required. Forms: 1.   1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2.   2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | <2 years: 20.1-79.8 mU/g of hemoglobin > or =2 years: 12.1-39.7 mU/g of hemoglobin | Wednesday; 9 a.m. | 9 days | 16 days | 1 | 82759 |  |  |  |  | Rochester
GALK | [NAME] | WBNAH | WB Sodium Heparin |  |  |  | Refrigerated | 48 hours
GALK | Result | 8628 | Galactokinase, B | Galactokinase, B | Numeric |  |  |  |  | mU/g Hb |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 840480d1692771474-sum-by-matching-in-sheet2-from-sheet1-sum-multiple-columns
Sheet: Sheet2

 |  |  |  |  |  | Single Column |  |  |  | Multiple Column(Specific columns only i.e E+G)
 |  |  |  |  |  | Office 2021 | Office 365 | Office 2021
 |  |  |  | [NAME]
 |  |  |  | Ma-84/97/140
 |  |  |  | Ash-71/142
 |  |  |  | [NAME] |  |  |  |  | 97
 |  |  |  | M-8/9/44
Spreadsheet: benjamin_rogers__1185__United American Energy 02-09-00
Sheet: Returns

RETURNS
 | 0
('000 $) | Close
ENRON'S EQUITY CASHFLOW
Pre Tax Cash Flow | 0
Enron's State Taxes Benefit (Expense) | 0
Enron's Federal Taxes Benefit (Expense) | 0
After Tax Cash Flow | 0
Equity Contributions from Enron |  | 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
Enron's Cashflow with No Residual
Equity CF
Other CF | 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
Total CF
IRR
Enron's Cashflow with Residual Value
Equity CF
Residual Value | 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
Other Cashflow | 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
Total CF
IRR
Spreadsheet: 5019af0f-9aa5-4443-83df-66b748f49a10
Sheet: Inter-District Goal 3

 |  |  | Integration Revenue Budget Worksheet
 |  |  |  |  | FY14
 |  |  |  | Inter-District Budget: Goal 3
District Number: |  |  |  | District Name:
Please insert Inter-District integration goal #3 from your district's desegregation plan:
Line Item Description |  | UFARS | Code | (Required) |  | Budgeted Amount |  | Actual Expenditures
 |  |  |  |  |  |  |  | Resubmit this form with
Provide a short description |  |  |  |  |  | Provide the total amount |  | the actual FY14
of the expenditure. |  | ORG | PROG | FIN | OBJ | budgeted for this line item |  | expenditures by 12/1/14.
TOTAL
PARTICIPATION INFORMATION |  |  |  |  |  | Projected (7/1/13) |  | Actual
 |  |  |  |  |  | Students | Staff | Students | Staff
Participation from Racially Isolated District (RI):
Participation from Your District (if not the RI):
Participation from Other Member Districts:
Total Program Participation:
Notes or Comments:
Spreadsheet: 705510d1606160194-need-help-please-in-distributing-a-number-across-a-date-in-multiple-cells-distribute-number
Sheet: Sheet1

DATE
2020-09-01 |  |  |  |  | Qty
2020-09-01 |  |  |  | 2020-09-01 | 587
2020-09-01 |  |  |  | 2020-09-02 | 869
2020-09-01 |  |  |  | 2020-09-03 | 741
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01