tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 58967d1259267109-vlookup-with-multiple-values-vlookupproblem
Sheet: Sheet1

Sorted by category |  |  |  |  | Sorted by price
Category | NPV | Quantity |  |  | Category | NPV | Quantity
1 | 0 | 0 |  |  |  | -80
2 | 5.51 | 3.725 |  |  |  | -80
3 | 14.52 | 0 |  |  |  | -78
4 | 18.66 | 6.205 |  |  |  | -76
5 | 29.33 | 0 |  |  |  | -65
6 | 40.36 | 12.3948 |  |  |  | -61
7 | 55.99 | 6.1974 |  |  |  | -51
8 | 30 | 1.183599791469665 |  |  |  | -51
9 | 70 | 7.156826531529433 |  |  |  | -45
10 | -65 | 0 |  |  |  | -43
11 | 24 | 0 |  |  |  | -38
12 | 25 | 1.399106921944035 |  |  |  | -34
13 | 21 | 0.2040364261168385 |  |  |  | -20
14 | 83.31687034552657 | 0.8452937653411879 |  |  |  | -13
15 | -10 | 1.748883652430044 |  |  |  | -11
16 | 50 | 0 |  |  |  | -10
17 | 42 | 0.2914806087383408 |  |  |  | -8
18 | -76 | 0.05829612174766814 |  |  |  | -6
19 | -38 | 1.107626313205694 |  |  |  | -3
20 | 30 | 0.106575 |  |  |  | -2
21 | 70.35646829177794 | 0.248675 |  |  |  | etc…
22 | -11 | 0.1953875
23 | -13 | 0
24 | 1 | 0.3111195652173913
25 | -80 | 0.3733434782608696
26 | -80 | 0.7466869565217392
27 | -78 | 0.1866717391304348
28 | -1 | 0.5042637681159421
29 | -43 | 0.8194286231884057
30 | 8 | 0.3151648550724638
31 | 83.31687034552657 | 1.260659420289855
32 | -34 | 1.38672536231884
33 | -20 | 0
34 | -8 | 0.9277505084745764
35 | -3 | 1.208233220338983
36 | -2 | 1.308919322033899
37 | 2 | 1.388029830508475
38 | 85.16835635320489 | 0.08630237288135595
39 | 107.3861884453453 | 0.5897328813559323
40 | -61 | 0
41 | -51 | 0
42 | -51 | 3.980907
43 | -45 | 1.3417131
44 | -6 | 0.294882
45 | -2 | 0.4128348
46 | 0 | 2.0346858
47 | 0 | 0.884646
48 | 0 | 0.9878547
49 | 0 | 0.6045081
50 | 2 | 1.032087
51 | 2 | 0.589764
52 | 5 | 0.3980907
53 | 10 | 0.1769292
54 | 16 | 0.8551578
55 | 18 | 0.8109255
56 | 16.41245216855349 | 2.2411032
57 | 16.41245216855349 | 0.7224609000000001
58 | 16.41245216855349 | 0.3980907
59 | 16.41245216855349 | 0.3833466
60 | 25 | 0.8404137
61 | 25 | 0.9141342
62 | 66.65349627642115 | 0.6782286000000001
63 | 32.82490433710697 | 0.3391143
64 | 32.82490433710697 | 0
65 | 32.82490433710697 | 0.3243702
66 | 32.82490433710697 | 0.3096261
67 | 41 | 0.7666932
68 | 79.61389833016993 | 0.8404137
69 | 88.87132836856152 | 0
Spreadsheet: 789141d1658928247-lookup-sum-between-two-dates-test-3-
Sheet: Sheet9

 |  |  |  | 2021-10-01 00:00:00 | 100 |  |  | 2021-10-01 00:00:00 | 2021-10-31 00:00:00
 |  |  |  | 2021-10-02 00:00:00 | 100 |  |  | 2021-10-10 00:00:00 | 2021-10-10 00:00:00
 |  |  |  | 2021-10-03 00:00:00 | 100
 |  |  |  | 2021-10-04 00:00:00 | 100
 |  |  |  | 2021-10-05 00:00:00 | 100
 |  |  |  | 2021-10-06 00:00:00 | 100
 |  |  |  | 2021-10-07 00:00:00 | 100
 |  |  |  | 2021-10-08 00:00:00 | 100
 |  |  |  | 2021-10-09 00:00:00 | 100
 |  |  |  | 2021-10-10 00:00:00 | 200
 |  |  |  | 2021-10-11 00:00:00 | 100
 |  |  |  | 2021-10-12 00:00:00 | 100
 |  |  |  | 2021-10-13 00:00:00 | 100
 |  |  |  | 2021-10-14 00:00:00 | 100
 |  |  |  | 2021-10-15 00:00:00 | 100
 |  |  |  | 2021-10-16 00:00:00 | 100
 |  |  |  | 2021-10-17 00:00:00 | 100
 |  |  |  | 2021-10-18 00:00:00 | 100
 |  |  |  | 2021-10-19 00:00:00 | 100
 |  |  |  | 2021-10-20 00:00:00 | 100
 |  |  |  | 2021-10-21 00:00:00 | 100
 |  |  |  | 2021-10-22 00:00:00 | 100
 |  |  |  | 2021-10-23 00:00:00 | 100
 |  |  |  | 2021-10-24 00:00:00 | 100
 |  |  |  | 2021-10-25 00:00:00 | 100
 |  |  |  | 2021-10-26 00:00:00 | 100
 |  |  |  | 2021-10-27 00:00:00 | 100
 |  |  |  | 2021-10-28 00:00:00 | 100
 |  |  |  | 2021-10-29 00:00:00 | 100
 |  |  |  | 2021-10-30 00:00:00 | 100
 |  |  |  | 2021-10-31 00:00:00 | 100
Spreadsheet: 59048d1259410430-counting-and-averaging-information-708920_sam_d
Sheet: Sheet1

 | Company | Raised | Closed | Days | Less 14
Query 1 | A | 2009-11-02 00:00:00 | 2009-11-18 00:00:00 | 16 | 0
Query 2 | B | 2009-11-09 00:00:00 | 2009-11-19 00:00:00 | 10 | 1
Query 3 | C | 2009-11-09 00:00:00 | 2009-11-18 00:00:00 | 9 | 1
Query 4 | A | 2009-11-10 00:00:00 | 2009-11-23 00:00:00 | 13 | 1
Query 5 | B | 2009-11-11 00:00:00 | 2009-11-24 00:00:00 | 13 | 1
Query 6 | C | 2009-11-16 00:00:00
Query 7 | A | 2009-11-13 00:00:00
Query 8 | B | 2009-11-14 00:00:00 | 2009-11-23 00:00:00 | 9 | 1
Query 9 | C | 2009-11-19 00:00:00
Query 10 | A | 2009-11-14 00:00:00
Query 11 | B | 2009-11-17 00:00:00
Query 12 | C | 2009-11-18 00:00:00
Spreadsheet: 135691d1326188585-how-to-automatically-refresh-filter-by-data-shange-workbook-of-grades
Sheet: 5

LENTELĖS PAGAL KLASES [5]
Nr. | Pavardė, [NAME] | Klasė | Dorinis ugdymas (Etika) | [NAME] kalba | Rusų kalba | Lenkų kalba | [NAME] (valstybinė) | Rusų kalba | Anglų kalba | Vokiečių kalba | Prancūzų kalba | Rusų kalba | Anglų kalba | Vokiečių kalba | Prancūzų kalba | Matematika | Informacinės technoligijos | Istorija | Ekonomika | Pilietiškumo pagrindai | Geografija | Biologija | [NAME] | Chemija | [NAME] | Dailė | Technologijos | [NAME] kultūra
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
32
33
34
35
29
30
31
32
33
34
35
Spreadsheet: 740942d1626713764-auto-calculate-end-date-auto-calculate-end-date
Sheet: josephteh

 |  |  |  |  |  |  |  |  |  | Workings
Job | Allocated Hours | Start Date | End Date |  | Working Hours |  |  | Holidays |  | Allocated Hours |  |  | 40
Job A | 40 | 2021-07-19 10:35:00 |  |  | Start Hour | 08:00:00 |  | 2021-07-20 00:00:00 |  | Start Date |  |  | 2021-07-19 10:35:00
Job B | 40 | 2021-07-19 12:00:00 |  |  | End Hour | 15:00:00 |  | 2021-07-24 00:00:00 |  | End Date
Job C | 50 | 2021-07-19 09:00:00 |  |  | Working Hours |  |  | 2021-07-27 00:00:00 |  | First Day Hours
 |  |  |  |  |  |  |  |  |  | Last Day Hours
 |  |  |  |  |  |  |  |  |  | End Date (combined formulas)
 |  |  |  |  |  |  |  |  |  |  |  |  | Cumulative | Start/End | Start/End
 |  |  |  |  |  |  |  |  |  | Date | Day | Working hours | Working hours | Date | Time
https://www.excelforum.com/excel-formulas-and-functions/1354786-auto-calculate-end-date.html |  |  |  |  |  |  |  |  |  | 2021-07-19 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-07-20 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-07-21 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-07-22 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-07-23 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-07-24 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-07-25 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-07-26 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-07-27 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-07-28 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-07-29 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-07-30 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-07-31 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-08-02 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-08-03 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-08-04 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-08-05 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-08-06 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-08-07 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-08-08 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-08-09 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-08-10 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-08-11 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-08-12 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-08-13 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-08-14 00:00:00
 |  |  |  |  |  |  |  |  |  | 2021-08-15 00:00:00
Spreadsheet: 133311d1324328762-creating-a-table-with-if-statements-for-a-chart-dummytable
Sheet: Table

Date | End of 2010 | 2011-01-07 00:00:00 | 2011-01-17 00:00:00 | 2011-01-24 00:00:00 | 2011-01-31 00:00:00 | 2011-02-07 00:00:00 | 2011-02-14 00:00:00 | 2011-02-21 00:00:00 | 2011-02-28 00:00:00 | 2011-03-04 00:00:00 | 3/14/2011* | 2011-03-21 00:00:00 | 2011-03-29 00:00:00 | 2011-04-04 00:00:00 | 2011-04-11 00:00:00 | 2011-04-19 00:00:00 | 2011-04-26 00:00:00 | 2011-05-02 00:00:00 | 2011-05-09 00:00:00 | 5/16/2011* | 2011-05-24 00:00:00 | 2011-05-31 00:00:00 | 2011-06-06 00:00:00 | 2011-06-20 00:00:00 | 2011-06-27 00:00:00 | 2011-07-05 00:00:00 | 2011-07-11 00:00:00 | 7/18/2011* | 2011-07-31 00:00:00 | 8/8/2011* | 2011-08-15 00:00:00 | 2011-08-22 00:00:00 | 2011-08-29 00:00:00 | 9/12/2011* | 2011-09-26 00:00:00 | 2011-10-03 00:00:00 | 10/10/2011* | 2011-10-17 00:00:00 | 2011-10-24 00:00:00 | 2011-10-31 00:00:00 | 11/7/2011* | 2011-11-14 00:00:00 | 2011-11-21 00:00:00 | 2011-11-29 00:00:00 | 2011-12-05 00:00:00 | 2011-12-12 00:00:00 | 2011-12-19 00:00:00
1 | 3229 | 3318 | 3290 | 3421 | 3564 | 3624 | 3702 | 3885 | 4030 | 4187 | 4341 | 4482 | 4733 | 4838 | 5019 | 5189 | 5355 | 5452 | 5418 | 5157 | 5292 | 5475 | 5583 | 5640 | 5784 | 5874 | 5919 | 5880 | 6154 | 6064 | 6156 | 6291 | 0 | 6261 | 6459 | 6601 | 6453 | 6564 | 6686 | 6805 | 6570 | 6672 | 6807 | 6849 | 6834 | 6709 | 6803
2 | 0 | -28 | 131 | 143 | 60 | 78 | 183 | 145 | 157 | 154 | 141 | 251 | 105 | 181 | 170 | 166 | 97 | -34 | -261 | 135 | 183 | 108 | 57 | 144 | 90 | 45 | -39 | 274 | -90 | 92 | 135 | -30 | 0 | 198 | 142 | -148 | -6453 | 111 | 119 | -235 | 102 | 135 | 42 | -15 | -125 | 94
3 | 4366 | 4786 | 4759 | 4968 | 5193 | 5325 | 5467 | 5755 | 5995 | 6281 | 6538 | 6733 | 7144 | 7320 | 7588 | 7871 | 8124 | 8278 | 8300 | 7943 | 8150 | 8461 | 8645 | 8733 | 8933 | 9121 | 9211 | 9153 | 9604 | 9489 | 9636 | 9840 | 0 | 9825 | 10143 | 10382 | 10191 | 10373 | 10578 | 10766 | 10371 | 10522 | 10749 | 10832 | 10846 | 10663 | 10819
4 | 0 | -27 | 209 | 225 | 132 | 142 | 288 | 240 | 286 | 257 | 195 | 411 | 176 | 268 | 283 | 253 | 154 | 22 | -357 | 207 | 311 | 184 | 88 | 200 | 188 | 90 | -58 | 451 | -115 | 147 | 204 | -15 | 0 | 318 | 239 | -191 | -10191 | 182 | 188 | -395 | 151 | 227 | 83 | 14 | -183 | 156
Spreadsheet: 794087d1661871606-find-and-list-all-entries-not-equal-to-example-workbook
Sheet: Tabelle1

support | text1 |  |  | output wanted (yellow background): |  |  | support | text1
support |  |  |  |  |  |  | support
- | - |  |  |  |  |  | test
- | - |  |  |  |  |  | test2 | text2
#[NAME] | #[NAME] |  |  |  |  |  | test3 | text1
test
test2 | text2
test3 | text1
Spreadsheet: 691856d1597921741-concatenate-data-in-different-cells-and-add-a-comma-book6
Sheet: Sheet1

Column1
689
805
806
807
808
809
1281
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
Spreadsheet: 455936d1460567474-scheduling-independent-variables-160405_schedule_r2
Sheet: MINE SCHEDULE

 | KRAKATOA : LONG-TERM MINE SCHEDULE
 | STAGE |  | LENSE | ID | TOTAL TIME (d) | CHECK (d) | YEAR 0 |  |  |  |  |  |  |  |  |  |  |  | YEAR 1 |  |  |  |  |  |  |  |  |  |  |  | YEAR 2 |  |  |  |  |  |  |  |  |  |  |  | YEAR 3
 |  |  |  |  |  |  | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
 | PRIMARY - ACCESS |  | MAIN & HW | PORTAL RAMP
 |  |  |  | CROSS-CUT
 |  |  |  | MAIN RAMP
 |  |  | MAIN | 1230 ACCESS
 |  |  |  | 1200 ACCESS
 |  |  |  | 1170 ACCESS
 |  |  |  | 1150 ACCESS
 | SECONDARY - DRIFT & STOPE & RETREAT |  | MAIN | 1230 LEVEL
 |  |  |  | 1200 LEVEL
 |  |  |  | 1170 LEVEL
 |  |  |  | 1150 LEVEL
 |  |  |  |  |  | TOTAL
Spreadsheet: eric_saibi__9870__101901R
Sheet: El Segundo 03

Owner Name | El Segundo Power LLC
Station Name | El Segundo Power Station
Unit Name | Unit 03
NERC Region | WSCC
State | CA
Fuel Type | Natural Gas
Capacity | 342 MW
Start Date | 2001-10-08 00:00:00
End Date | 2001-10-21 00:00:00
Prv. Start Date | 2001-10-08 00:00:00
Prv. End Date | 2001-10-18 00:00:00
Comments | Having Problems with boiler; they hope to be up by this weekend
SIC | 4931
Plant ID | 1013744
Unit ID | 1006016
Outage ID | 18613
Spreadsheet: mary_fischer__25615__32L
Sheet: E15.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032L
COMPANY NAME   Jovinole Associates
ANALYSIS OF MINORITY INTERESTS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  | E-15
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  | AMOUNT |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | ENRON'S |  | BALANCE |  | PER INCOME |  | OTHER |  |  |  | BALANCE
 |  | OWNERSHIP % |  | DR. (CR.) |  | STATEMENT |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Minority Interest | * |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0855  DR/(CR)
Spreadsheet: 721032d1614437042-excel-formula-that-excludes-columns-with-specific-words-in-the-header-exitcomparisons-sample
Sheet: Totals_1mTrend

Worksheet | Total Trades | Total Pips | Best Setup | Num of Wins | Num of Loses | WinRate | Win/Loss Ratio | [NAME] | [NAME] | [NAME] | Best Trade | Worst Trade
10
Spreadsheet: 65214d1265914340-tie-breaker-copy-of-rank-tiebreaking_test
Sheet: PreferredMethod

Name | Score | [NAME] | [NAME] | TieBreak3 | TieBreak4 | TieBreak5 | [NAME] | KEY | Simple Rank | Rank w/ordinal
Name1 | 146 | 67 | 4 | 0 | 67 | 0 | 0 | 146.67040067 | 4 | 4th | 4th
[NAME] | 136 | 85 | 5 | 0 | 85 | 0 | 0 | 136.85050085 | 5 | 5th | 5th
Name3 | 106 | 38 | 2 | 0 | 38 | 0 | 0 | 106.38020038 | 6 | 6th | 6th
Name4 | 158 | 87 | 4 | 0 | 87 | 0 | 0 | 158.87040087 | 3 | 3rd | 3rd
Name5 | 205 | 85 | 5 | 4 | 85 | 0 | 0 | 205.85050485 | 1 | 1st | 1st
Name6 | 205 | 153 | 5 | 5 | 153 | 0 | 0 | 205.1530505153 | 2 | 2nd | 2nd
Name7 | 50 | 66 | 3 | 0 | 66 | 0 | 0 | 50.66030066 | 9 | 9th | 9th
Name8 | 37 | 35 | 2 | 0 | 35 | 0 | 0 | 37.35020035 | 10 | 10th | 10th
Name9 | 69 | 100 | 5 | 0 | 100 | 0 | 0 | 69.10005001 | 8 | 8th | 8th
Name10 | 86 | 117 | 1 | 0 | 117 | 0 | 0 | 86.1170100117 | 7 | 7th | 7th
 |  |  | The KEY column makes a very accurate decimal value from all of the
 |  |  | tiebreaker values allowing the simplest ranking. Hide this column if desired.
 |  |  | As you adapt this technique, apply the TEXT() function to each column correctly in the KEY column formula.
 |  |  | For the various possible values:
 |  |  | TEXT(A1,"00") |  | syntax to format those values to 2 digits.
 |  |  | TEXT(A1,"000") |  | syntax to format those values to 3 digits.
 |  |  | A1 |  | syntax for 1 digit, just take the cell value with no additional formatting
 |  |  | String those functions together as you see demonstrated in I2:I11
 |  |  | The rank formula in column K has an ordinal addition automatically added, thanks to [NAME] for that.
 |  |  | http://www.officekb.com/Uwe/Forum.aspx/ms-excel/125992/1st-and-2nd-positions
 |  |  | The rank formula in column L has a different ordinal addition technique, thanks to [NAME] for that.
 |  |  | http://forums.techonthenet.com/showthread.php?p=4555&posted=1#post4555
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 8a

Product1 | Cleared2 | Uncleared | TOTAL
Basis | 2 | 9 | 11
Cap/Floor | - | 70 | 70
Debt Option | - | - | -
Exotic | - | - | -
Fixed-Fixed | - | 4 | 4
Fixed-Float | 10298 | 998 | 11296
FRA | 20 | 62 | 82
Inflation | - | 35 | 35
OIS | 7 | 51 | 58
Swaption | - | 304 | 304
TOTAL | 10327 | 1533 | 11860
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 15a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | 210 | 19063 | 19273
Index | 222865 | 129012 | 351877
Asia | - | 965 | 965
Europe | 99700 | 35835 | 135535
North America | 122514 | 91789 | 214303
Other | 651 | 423 | 1074
OTHER* | 10619 | 64750 | 75369
Exotic | - | - | -
Swaptions | 10619 | 64750 | 75369
Total Return Swap | - | - | -
TOTAL | 233694 | 212825 | 446519
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 29190d1224034577-automatic-data-selection-orders-sglife
Sheet: Order Sheet

Date | Name | Pen Colour | Description | Part Number | Quantity
 |  | Red | Fine nib | rd123
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Spreadsheet: b101fe39-e6eb-4037-813e-5230b81f110f
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
FFURO | Test | FFURO | Furosemide (Lasix) | Furosemide (Lasix) | High Performance Liquid Chromatography with Fluorescence Detection (HPLC-FL) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 1 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s).   ([NAME] is not acceptable.)  Spin down and send 1 mL sodium heparin plasma refrigerated. Note:		1. Indicate plasma on request form. 	2.  [NAME] specimen appropriately (plasma).                 	3. Trough levels are most reproducible.   Serum Draw blood in a plain, red-top tube(s).  (Serum gel tube is not acceptable.)  Spin down and send 1 mL of serum refrigerated. Note:		1. Indicate serum on request form. 	2. Label specimen appropriately (serum).                 	3. Trough levels are most reproducible. | 0.1	Ml Note: Submission of the m | Specimens other than	Plasma, serum Anticoagulants other than	Sodium heparin, EDTA, plain red-top Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Reporting Limit: 0.10 ug/mL Critical Value: 50.00 ug/mL   Expected serum Furosemide concentration in patients on usual daily dosages: 	Up to 5.0  ug/mL   Toxic:	>50.0  ug/mL   TEST PERFORMED BY  MEDTOX LABORATORIES, INC. [NAME] ROAD D ST. PAUL, MN 55112 | Monday through Sunday | 7 days | 9 - 11 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc
FFURO | [NAME] | VARIES | Varies |  |  |  | Refrigerated
FFURO | Result | Z1189 | Furosemide | Furosemide | Alphanumeric |  |  |  |  | ug/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 679733d1590601510-count-if-with-an-index-match-example
Sheet: Sheet1

Item | Data point 1 | Data point 2 | Data point 3 | Data point 4
Product 1 | 1 |  |  |  | Data entered correctly |  | Row Labels | Expected count
Product 1 |  | 1 |  |  | Data entered correctly |  | Product 1 | 2
Product 2 | 1 |  |  |  | Data entered correctly |  | Product 2 | 3
Product 2 |  | 1 |  |  | Data entered correctly |  | Product 3 | 4
Product 2 |  |  | 1 |  | Data entered correctly |  | Product 4 | 2
Product 3 | 1 |  |  |  | Data entered correctly |  | Product 5 | 1
Product 3 |  | 1 |  |  | Data entered correctly |  | Product 6 | 3
Product 3 |  |  | 1 |  | Data entered correctly |  | Product 7 | 4
Product 3 |  |  |  | 1 | Data entered correctly |  | Product 8 | 2
Product 4 | 1 |  |  |  | Data entered correctly |  | Grand Total
Product 4 |  | 1 |  |  | Data entered correctly
Product 5 | 1 |  |  |  | Data entered correctly
Product 6 | 1 | 1 | 1 |  | Data incorrectly entered
Product 7 | 1 | 1 | 1 | 1 | Data incorrectly entered
Product 8 | 1 | 1 |  |  | Data incorrectly entered
Spreadsheet: 278ca921-2cd7-4bb9-8e47-12bf553bad0f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Michigan Industrial Ventilation Conference – Design Class Self-Placement Questionnaire
 | If you wish to attend one of the three design classes  (i.e., Phase I, Phase II, or Nonstandard Air) offered at the conference, you should pick the session that best fits your ability, past experience, and goals in ventilation design. To make a selection, please fill out this Self-Placement Questionnaire.  If you have not attended an industrial ventilation conference previously and do not have significant ventilation system design experience, it is highly recommended that you attend a PHASE I Introductory Ventilation System Design class (i.e., the introductory-level course) OR the Operations and Maintenance class.  Note that you need not complete the questionnaire if you wish to attend the Operations and Maintenance class.
 | Please compare your total score with the following table. We strongly recommend that you attend the type of course identified by the table.  Phase I - Ventilation System Design - 0 to 9 points PHASE II - Advanced Ventilation System Design - 10 to 12 points Nonstandard Air Design - 13 to 15 points
 |  | Question | Response |  | Selection
 | 1 | Regarding contaminant control hoods, ductwork, fan, and/or collector systems,I have actually designed (as distinguished from drafted): | 1 | No such systems.
 |  |  | 2 | One or two systems
 |  |  | 3 | Several systems.
 | 2 | When it comes to psychrometric charts, I: | 1 | Do not know what they are.
 |  |  | 2 | Know what they are, but do not know how to use them for designing industrial ventilation systems.
 |  |  | 3 | Know what they are and how to use them well.
 | 3 | Concerning the relationship between VP, SP, and TP, I: | 1 | Do not know what the abbreviations stand for or what they mean.
 |  |  | 2 | Know what the abbreviations stand for and think I know their relationship.
 |  |  | 3 | Know what the abbreviations stand for, what they mean, and how to use them well.
 | 4 | Regarding formal courses in fluid dynamics, fluid flow, and/or hydraulics, I have had: | 1 | No such courses.
 |  |  | 2 | Have had one course.
 |  |  | 3 | Have had two or more courses.
 | 5 | Regarding make-up air or air conditioning, I have designed the following types of systems (if you have designed more than one type, select the one with the highest value): | 1 | None - I have designed no such systems.
 |  |  | 2 | Commercial and/or light industry systems.
 |  |  | 3 | Heavy industry systems.
 | Total Score |  |  |  | 0
 | Please compare your total score with the following table.  We strongly recommend that you attend the
 | type of course identified by the table.
 | PHASE I Introductory - Ventilation System Design |  |  | 0 to 9 points
 | PHASE II Advanced - Ventilation System Design |  |  | 10 to 12 points
 | NONSTANDARD AIR DESIGN |  |  | 13 to 15 points
Spreadsheet: 859840d1708080338-calculating-lag-period-of-2-months-book2
Sheet: Opertional Projections_MGTxP

 |  | Fiscal Year |  |  | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2
 |  | Date
 |  | Year
 |  | Month
 |  | Days in Period
 |  |  |  |  | 0
x | x | Key Assumptions
 |  | Revenue Assumptions
 |  | No. of Beds |  |  | 3 | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27 | 31 | 35 | 39 | 43 | 47 | 51 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57
 |  | Incremental
 |  | No of Beds Available |  |  |  | 3 | 3 | 5 | 5 | 7 | 7
 |  | Essentially Row 11 comes from a Rental calculation sheet and it shows the accummulated no. of rooms we are renting in a particular month
 |  | In Month 0 the 3 is rooms is owned by us to its always there and can be rented out immediately
 |  | But for the rooms we are renting if we want to sub lease these rooms, we think it will take at least 2 months to sublease
 |  | So Row 13 is the Row I want to see the number as in the example--- hardcoded
 |  | With Row 13 I can calculate my revenue and expenses