tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 816638d1675759968-attendance-tracker-4-in-90-upload
Sheet: Roster

Unschedualed [NAME]
Shift | In 90 | Last report written | Rank | Staff Name | Day Off 1 | Day Off 2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  | 90
[NAME] |  |  | CO |  | SATURDAY | SUNDAY
[NAME] |  |  | CO |  | SATURDAY | SUNDAY
[NAME] |  |  | CO |  | SATURDAY | SUNDAY
[NAME] |  |  | CO |  | SATURDAY | SUNDAY
[NAME] |  |  | CO |  | SATURDAY | SUNDAY
[NAME] |  |  | CO |  | SATURDAY | SUNDAY
[NAME] |  |  | SGT |  | SATURDAY | SUNDAY
[NAME] |  |  | SGT |  | SATURDAY | SUNDAY
[NAME] |  |  | CO |  | SATURDAY | SUNDAY
[NAME] |  |  | CO |  | SATURDAY | SUNDAY
[NAME] |  |  | CO |  | SATURDAY | SUNDAY
[NAME] |  |  | CO |  | SATURDAY | SUNDAY
[NAME] |  |  | SGT |  | SATURDAY | SUNDAY
[NAME] |  |  | CO |  | SATURDAY | SUNDAY
[NAME] |  |  | CO |  | SATURDAY | SUNDAY
[NAME] |  |  | CO |  | SATURDAY | SUNDAY
1st |  |  | CO |  | THURSDAY | FRIDAY
1st |  |  | SGT |  | FRIDAY | SATURDAY
1st |  |  | CO |  | SUNDAY | MONDAY
1st |  |  | SGT |  | TUESDAY | WEDNESDAY
1st |  |  | SGT |  | FRIDAY | SATURDAY
1st |  |  | CO |  | SUNDAY | MONDAY
1st |  |  | CO |  | WEDNESDAY | THURSDAY
1st |  |  | CO |  | FRIDAY | SATURDAY
1st |  |  | CO |  | SUNDAY | MONDAY
1st |  |  | SGT |  | SUNDAY | MONDAY
2nd |  |  | SGT |  | THURSDAY | FRIDAY
2nd |  |  | SGT |  | TUESDAY | WEDNESDAY
2nd |  |  | SGT |  | SATURDAY | SUNDAY
2nd |  |  | CO |  | SUNDAY | MONDAY
2nd |  |  | CO |  | SATURDAY | SUNDAY
2nd |  |  | CO |  | MONDAY | TUESDAY
2nd |  |  | CO |  | FRIDAY | SATURDAY
2nd |  |  | CO |  | FRIDAY | SATURDAY
2nd |  |  | CO |  | WEDNESDAY | THURSDAY
2nd |  |  | SGT |  | SUNDAY | MONDAY
2nd |  |  | SGT |  | MONDAY | TUESDAY
2nd |  |  | CO |  | SATURDAY | SUNDAY
3rd |  |  | SGT |  | WEDNESDAY | THURSDAY
3rd |  |  | CO |  | MONDAY | TUESDAY
3rd |  |  | CO |  | TUESDAY | WEDNESDAY
3rd |  |  | CO |  | SUNDAY | MONDAY
3rd |  |  | CO |  | FRIDAY | SATURDAY
3rd |  |  | SGT |  | THURSDAY | FRIDAY
3rd |  |  | CO |  | FRIDAY | SATURDAY
3rd |  |  | SGT |  | SATURDAY | SUNDAY
3rd |  |  | CO |  | TUESDAY | WEDNESDAY
3rd |  |  | SGT |  | TUESDAY | WEDNESDAY
3rd |  |  | CO |  | THURSDAY | FRIDAY
3rd |  |  | CO |  | MONDAY | TUESDAY
2nd |  |  | SGT |  | FRIDAY | SATURDAY
Spreadsheet: 93780d1293556999-conditional-formatting-using-ifs-help-please-gwynemark_sample-4-
Sheet: Sheet1

Planned Closure Date | Status of Corrective Action |  |  |  |  |  |  |  | Planned Closure Date | Status of Corrective Action |  |  | Planned Closure Date | Status of Corrective Action
2010-11-15 00:00:00 | Open |  |  | 1) I would like column A to color code the cells in RED if the date is greater than 30 days from today and the Status (column B) is "open" |  |  |  |  | 2010-11-15 00:00:00 | Open |  |  | 2010-11-15 00:00:00 | Open
2010-12-01 00:00:00 | Open |  |  |  |  |  |  |  | 2010-12-01 00:00:00 | Open |  |  | 2010-12-01 00:00:00 | Open
2010-12-10 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-12-10 00:00:00 | Closed |  |  | 2010-12-10 00:00:00 | Closed
2010-08-11 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-08-11 00:00:00 | Closed |  |  | 2010-08-11 00:00:00 | Closed
2010-09-11 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-09-11 00:00:00 | Closed |  |  | 2010-09-11 00:00:00 | Closed
2010-10-04 00:00:00 | Open |  |  |  |  |  |  |  | 2011-01-15 00:00:00 | Open |  |  | 2010-10-04 00:00:00 | Open
2010-12-01 00:00:00 | Open |  |  | 2) If possible, I would also like to color code the cell YELLOW if the date is within 30 days of today and the status (column B) is "open" |  |  |  |  | 2010-12-01 00:00:00 | Open |  |  | 2010-12-01 00:00:00 | Open
2010-12-01 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-12-01 00:00:00 | Closed |  |  | 2010-12-01 00:00:00 | Closed
2010-06-15 00:00:00 | Open |  |  |  |  |  |  |  | 2010-06-15 00:00:00 | Open |  |  | 2010-06-15 00:00:00 | Open
2010-06-15 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-06-15 00:00:00 | Closed |  |  | 2010-06-15 00:00:00 | Closed
2010-08-17 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-08-17 00:00:00 | Closed |  |  | 2010-08-17 00:00:00 | Closed
2010-12-28 00:00:00 | Open |  |  |  |  |  |  |  | 2010-12-28 00:00:00 | Open |  |  | 2010-12-28 00:00:00 | Open
2010-12-01 00:00:00 | Closed |  |  | It should look like this to the right but done automatically. |  |  |  |  | 2010-12-01 00:00:00 | Closed |  |  | 2010-12-01 00:00:00 | Closed
2010-12-01 00:00:00 | Open |  |  |  |  |  |  |  | 2011-03-30 00:00:00 | Open |  |  | 2011-01-15 00:00:00 | Open
2010-12-01 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-12-01 00:00:00 | Closed |  |  | 2010-12-01 00:00:00 | Closed
2010-12-01 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-12-01 00:00:00 | Closed |  |  | 2010-12-01 00:00:00 | Closed
2010-12-01 00:00:00 | Open |  |  |  |  |  |  |  | 2010-12-01 00:00:00 | Open |  |  | 2010-12-01 00:00:00 | Open
2010-11-27 00:00:00 | Open |  |  |  |  |  |  |  | 2010-11-27 00:00:00 | Open |  |  | 2010-11-27 00:00:00 | Open
2010-11-26 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-11-26 00:00:00 | Closed |  |  | 2010-11-26 00:00:00 | Closed
Spreadsheet: john_griffith__15805__10_22_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 60 | 250 | 300 | 49.9 | 59.8 | 2.07 | 2001-10-22 14:23:00
 | [NAME] | 60 | 700 | 720 | 46.7 | 48.1 | 1.79 | 2001-10-22 14:23:00
 | HU F2 | 61 | 900 | 1000 | 44.2 | 49.1 | 1.79 | 2001-10-22 14:23:00
 | HU G2 | 62 | 1100 | 1160 | 43.4 | 45.8 | 1.74 | 2001-10-22 14:23:00
 | [NAME] | 62 | 1245 | 1280 | 43.5 | 44.8 | 1.72 | 2001-10-22 14:23:00
 | [NAME] | 69 | 1380 | 1480 | 39.3 | 42.2 | 1.77 | 2001-10-22 14:23:00
 | [NAME] | 69 | 1480 | 1580 | 38.7 | 41.3 | 1.74 | 2001-10-22 14:23:00
 | [NAME] | 69 | 1500 | 1625 | 36.3 | 39.3 | 1.64 | 2001-10-22 14:23:00
 | HU N2 | 68 | 1500 | 1700 | 34.7 | 39.4 | 1.58 | 2001-10-22 14:23:00
 | [NAME] | 67 | 1500 | 1700 | 33.4 | 37.9 | 1.5 | 2001-10-22 14:23:00
 | HU U2 | 66 | 1500 | 1700 | 32.2 | 36.6 | 1.43 | 2001-10-22 14:23:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | [NAME]
 | HU F3 |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 784509d1655793998-formula-based-computation-instead-of-using-table-formula-base-excelforum
Sheet: trans

 | Source |  | Distribution | FINAl Trans. | Remarks
 | 74 | 5 | 0.08 | 5 | FAILED
 | 75 | 3 | 0.08 | 3 | Passed |  | Needed is formula based so that there is no need for the table
 | 76 | 3 | 0.08 | 2.92 | Passed
 | 77 | 3 | 0.08 | 2.84 | Passed
 | 78 | 2.75 | 0.08 | 2.76 | Fairly Satisfactory
 | 79 | 2.75 | 0.08 | 2.68 | Fairly Satisfactory
 | 80 | 2.75 | 0.08 | 2.6 | Fairly Satisfactory |  | sample grades |  | [NAME]
 | 81 | 2.5 | 0.08 | 2.52 | Fairly Satisfactory |  | 92.99
 | 82 | 2.5 | 0.08 | 2.44 | Fairly Satisfactory |  | 93
 | 83 | 2.5 | 0.08 | 2.359999999999999 | Fairly Satisfactory |  | 93.99
 | 84 | 2.25 | 0.08 | 2.279999999999999 | Satisfactory |  | 94
 | 85 | 2.25 | 0.08 | 2.199999999999999 | Satisfactory |  | 75
 | 86 | 2.25 | 0.08 | 2.119999999999999 | Satisfactory |  | 74.99
 | 87 | 2 | 0.08 | 2.039999999999999 | Satisfactory
 | 88 | 2 | 0.08 | 1.959999999999999 | Satisfactory
 | 89 | 2 | 0.08 | 1.879999999999999 | Satisfactory
 | 90 | 1.75 | 0.08 | 1.799999999999999 | Very Satisfactory
 | 91 | 1.75 | 0.08 | 1.719999999999999 | Very Satisfactory
 | 92 | 1.75 | 0.08 | 1.639999999999999 | Very Satisfactory
 | 93 | 1.5 | 0.08 | 1.559999999999999 | Very Satisfactory
 | 94 | 1.5 | 0.08 | 1.479999999999999 | Very Satisfactory
 | 95 | 1.5 | 0.08 | 1.399999999999999 | Very Satisfactory
 | 96 | 1.25 | 0.08 | 1.319999999999999 | Superior
 | 97 | 1.25 | 0.08 | 1.239999999999998 | Superior
 | 98 | 1.25 | 0.08 | 1.159999999999998 | Superior
 | 99 | 1 | 0.08 | 1.079999999999998 | Excellent
 | 100 | 1 | 0.08 | 1 | Excellent
Spreadsheet: 68448d1268979748-inventory-running-count-testtracker
Sheet: Sheet2

Unit |  | System |  | OH | FMC | AOS / AOF | Left Limit | Right Limit | Remarks |  | HE | RAP | Illum | IR ILL | WP | Smoke | [NAME]
 |  | 155mm |  |  |  |  |  |  |  |  | 44
 |  | 105mm
 |  | 120mmA
 |  | 120mmB
 |  | 81mmA
 |  | 81mmB
 |  | 60mmA
 |  | 60mmB
 |  | 60mmC
 |  | 155mm
 |  | 105mm
 |  | 120mm
 |  | 120mm
 |  | 81mm
 |  | 81mm
 |  | 60mm | A
 |  |  | B
 |  |  | C
 |  | 155mm
 |  | 105mm
 |  | 120mm
 |  | 120mm
 |  | 81mm
 |  | 81mm
 |  | 60mm | A
 |  |  | B
 |  |  | C
 |  | 155mm
 |  | 105mm
 |  | 120mm
 |  | 120mm
 |  | 81mm
 |  | 81mm
 |  | 60mm | A
 |  |  | B
 |  |  | C
1 = | 1
2 = | 2
3 = | 3
4 = | 4
Spreadsheet: 711418d1609698031-extract-data-in-two-columns-into-one-column-with-formula-sample_twocolumns_to_onecolumn
Sheet: Master

Names_Master | Name | Name (Desired Output)
Spreadsheet: 742179d1627568637-pulling-specific-dates-from-one-sheet-into-another-using-data-validation-drop-down-testsheet2-ans
Sheet: Sheet1

 | June | July | August | Sept | Oct | Nov | Dec | Jan | Feb | Mar
A3 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00
A21 | 2021-06-02 00:00:00 | 2021-07-02 00:00:00
A39 | 2021-06-03 00:00:00 | 2021-07-05 00:00:00
A57 | 2021-06-04 00:00:00 | 2021-07-06 00:00:00
A75 | 2021-06-07 00:00:00 | 2021-07-07 00:00:00
A93 | 2021-06-08 00:00:00 | 2021-07-08 00:00:00
A111 | 2021-06-09 00:00:00 | 2021-07-09 00:00:00
A129 | 2021-06-10 00:00:00 | 2021-07-12 00:00:00
A147 | 2021-06-11 00:00:00 | 2021-07-13 00:00:00
A165 | 2021-06-14 00:00:00 | 2021-07-14 00:00:00
A183 | 2021-06-15 00:00:00 | 2021-07-15 00:00:00
A201 | 2021-06-16 00:00:00 | 2021-07-16 00:00:00
A219 | 2021-06-17 00:00:00 | 2021-07-19 00:00:00
A237 | 2021-06-18 00:00:00 | 2021-07-20 00:00:00
A255 | 2021-06-21 00:00:00 | 2021-07-21 00:00:00
A273 | 2021-06-22 00:00:00 | 2021-07-22 00:00:00
A291 | 2021-06-23 00:00:00 | 2021-07-23 00:00:00
A309 | 2021-06-24 00:00:00 | 2021-07-26 00:00:00
A327 | 2021-06-25 00:00:00 | 2021-07-28 00:00:00
A345 | 2021-06-29 00:00:00 | 2021-07-29 00:00:00
A363 | 2021-06-30 00:00:00 | 2021-07-30 00:00:00
A381
Spreadsheet: 4ec44d6a-6137-4345-9cf0-c90b58e65dc9
Sheet: 1

 | Sep 27 | Oct 4 | Oct 11 | Oct 18 | Oct 25
Total Interest Rate* | 415624591 | 419957125 | 418175079 | 423009082 | 426286753
Cleared** | 210869228 | 212856077 | 212263284 | 215452445 | 218425643
Uncleared | 204755363 | 207101047 | 205911795 | 207556637 | 207861109
Total Cross-Currency | 16678663 | 16854565 | 16835919 | 17008093 | 17157988
Cleared | N/A*** | N/A | N/A | N/A | N/A
Uncleared | 16678663 | 16854565 | 16835919 | 17008093 | 17157988
Total Credit | 19092493 | 19181631 | 19191667 | 19085959 | 19113583
Cleared | 3161527 | 3194237 | 3258614 | 3306022 | 3293875
Uncleared | 15930966 | 15987394 | 15933053 | 15779937 | 15819708
Total Equity | 5874865 | N/A | N/A | N/A | N/A
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 5874865 | N/A | N/A | N/A | N/A
Total Other Commodity | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 460361612 | 459084321 | 457293665 | 462194134 | 465649324
Weekly snapshot, estimated gross notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 746116d1630512020-formula-to-calculate-total-book1-5-
Sheet: Sheet1

Date | Invoice number | Description | price | tax | total
2021-08-12 00:00:00 | 145678 | Oil Can | 12
 |  | Onion 3kg | 4
 |  | Fish can | 19
 |  | Water 1.5l | 7
2021-08-13 00:00:00 | 147989 | apple | 4
 |  | orange | 5
 |  | Onion 3kg | 21
 |  | [NAME] | 40
2021-08-18 00:00:00 | 147999 | Oil Can | 12
 |  | Onion 3kg | 4
 |  | Fish can | 19
 |  | Water 1.5l | 7
Spreadsheet: 852519d1702524628-help-with-this-fifo-formula-fifo
Sheet: multiple products

 |  |  | INVENTORY MODEL. FIFO CALCULATION. MULTIPLE  SKUs!!!!!!!
 |  |  |  | Purchase |  |  | Usage |  |  |  | Closing balance
 |  |  | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | Quantity | Value | Unit price
 |  |  | 101001
 |  |  | 101008
 |  |  | 101009
 |  |  | 101020
 |  |  | 101027
 |  |  | 101022
 |  |  | 101023
 |  |  | 101024
 |  |  | 101033
 |  |  | 101034
 |  |  | 101044
 |  |  | 101037
 |  |  | 101039
 |  |  | 101038
 |  |  | 101036
 |  |  | 101040
 |  |  | 101070
 |  |  | 101045
 |  |  | 101057
 |  |  | 101046
 |  |  | 101048
 | INSERT ROWS
 |  |  | Total |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVENTORY SPLIT BY FIFO
 |  |  | Purchase |  |  |  | Usage |  |  |  |  |  |  |  | ONLY FOR EXCEL GEEKS & NERDS!!! |  |  |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
 | SKU/ID | ID | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price |  |  |  |  | Technical column 1 | Technical column 2 | Technical column 3 | Value | Value with validation |  | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price
 |  |  |  | 0 | 0 | 0 | do not amend this row, ANYWHERE!!! |  |  |  |  |  |  |  | do not amend this row, ANYWHERE!!!
 |  |  |  | 0 | 0 |  | do not amend this row, ANYWHERE!!! |  |  |  |  |  |  |  | do not amend this row, ANYWHERE!!!
 |  | 1 | 101001 | 6 | 210000 |  | 101001 | 6
 |  |  | 101008 | 100 | 650000 |  | 101008 | 100
 |  |  | 101009 | 100 | 125000 |  | 101009 | 100
 |  |  | 101020 | 3 | 645000 |  | 101044 | 2
 |  |  | 101027 | 5 | 310000 |  | 101070 | 100
 |  |  | 101022 | 10 | 95000
 |  |  | 101023 | 10 | 95000
 |  |  | 101024 | 10 | 95000
 |  |  | 101033 | 10 | 190000
 |  |  | 101034 | 10 | 170000
 |  |  | 101044 | 10 | 800000
 |  |  | 101037 | 3 | 6780000
 |  |  | 101039 | 3 | 4359000
 |  |  | 101038 | 3 | 5133000
 |  |  | 101036 | 3 | 9996000
 |  |  | 101040 | 3 | 2451000
 |  |  | 101070 | 100 | 175000
 |  |  | 101045 | 3 | 3315000
 |  |  | 101057 | 3 | 732000
 |  |  | 101046 | 3 | 1386000
 |  |  | 101048 | 3 | 10155000 |  |  |  |  |  |  | AND THEN COPY FORMULA
 |  |  |  |  |  |  |  |  |  |  |  | FROM ROW 34
Spreadsheet: 3d887e48-8c0d-4874-a5b1-925640dc0200
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
7996 | 55593 | Kelly | Haniver | GBR | 105 | 00:23:42 | 00:00:00 | [NAME] | 00:00:00 | 00:35:27 | 1 | 01:33:58
7996 | 55594 | [NAME] | [NAME] | GBR | 106 | 00:23:57 | 00:00:00 | 00:34:21 | 00:00:00 | 00:43:23 | 2 | 01:41:40
7996 | 10317 | Marta | Poretti | ITA | 104 | 00:26:33 | 00:00:00 | 00:39:09 | 00:00:00 | 00:47:17 | 3 | 01:53:00
Spreadsheet: 867041d1713950077-comparing-data-in-2-sheets-book1
Sheet: Sheet1

PRN
1234
4321
3456
7789
589962
288982
2878
38975
78273
337377
5663984
5532
225696
2559
22422
72787
89321
448899
145565
Spreadsheet: 758983d1639213711-excel-formula-flag-the-first-duplicate-samplefile
Sheet: Sheet1

Provider Code | [NAME] | [NAME] | Claim Code | Treatment Date | Treatment Month | Finance Paid Date | [NAME] | Calculated Approved Amount | Flag | Result
6212000003 | Al Azhar Hospital (Riyadh) | FINALIZED | 516222 | 44465 |  | 44487 | 132 | 87.24 |  | First Duplicate
6212000003 | Al Azhar Hospital (Riyadh) | FINALIZED | 540336 | 44406 |  | 44501 | 84.66 | 73.9 |  | First Duplicate
6212000003 | Al Azhar Hospital (Riyadh) | FINALIZED | 540339 | 44383 |  |  | 94.3 | 0 |  | First Duplicate
6212000003 | Al Azhar Hospital (Riyadh) | FINALIZED | 540338 | 44382 |  |  | 283.36 | 208.79 |  | Duplicate
6212000003 | Al Azhar Hospital (Riyadh) | FINALIZED | 540335 | 44387 |  |  | 309.02 | -12.98 |  | Duplicate
6212000003 | Al Azhar Hospital (Riyadh) | FINALIZED | 540337 | 44381 |  |  | 418.13 | 243.3 |  | Duplicate
6212000003 | Al Azhar Hospital (Riyadh) | FINALIZED | 540340 | 44385 |  |  | 8280 | 7040 |  | Duplicate
6212000003 | Al Azhar Hospital (Riyadh) | FINALIZED | 516223 | 44445 |  |  | 156.21 | 144.21 |  | Duplicate
6212000003 | Al Azhar Hospital (Riyadh) | FINALIZED | 516224 | 44464 |  |  | 264.45 | 264.45 |  | Duplicate
6212000004 | Al Bashawri Opticals - Riyadh | OS | 798324 | 44466 |  |  | 184.8 | 0 |  | First Duplicate
6212000004 | Al Bashawri Opticals - Riyadh | FINALIZED | 798323 | 44496 |  |  | 738.5 | 28 |  | First Duplicate
6212000008 | Al Belad Medical Center | FINALIZED | 391991 | 44378 |  |  | 210.04 | 0 |  | First Duplicate
6212000008 | Al Belad Medical Center | FINALIZED | 392332 | 44401 |  |  | 222.18 | 0 |  | Duplicate
6212000009 | Al Dosary Medical Polyclinic | OS | 837536 | 44434 |  |  | 162.35 | 117.55 |  | First Duplicate
6212000009 | Al Dosary Medical Polyclinic | FINALIZED | 720574 | 44434 |  |  | 205.36 | 192.04 |  | First Duplicate
6212000009 | Al Dosary Medical Polyclinic | FINALIZED | 720663 | 44434 |  |  | 205.36 | 0 |  | Duplicate
Spreadsheet: 55182d1255353070-how-to-automatically-alter-formula-when-filters-are-applied-malchemist-2
Sheet: 31950

Date of Order | Date of Order | Year Of Order | Month Of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20080603 | 2008-06-03 | 2008 | 6 | 370101 | Battery pack SFB 185 | 1 | 93.37 | 106298 | 31950
20081218 | 2008-12-18 | 2008 | 12 | 378426 | Battery pack B 24/3.0 NiMH | 1 | 112.37 | 131886 | 31950
Spreadsheet: 86182d1286210406-excel-2007-automatically-copy-data-from-master-sheet-new-microsoft-office-excel-worksheet
Sheet: Master

sr | Name | Address | Type of Product | Country
1 | [NAME] | Wall Streets | Shampoo | United States
2 | [NAME] | Midwell | Soap | UK
3 | Ishan | New Delhi | Hair Oil | India
4 | Rose | Lahore | [NAME] | India
 |  |  |  | India
 |  |  |  | UK
 |  |  |  | United States
Spreadsheet: 179529d1347290068-merging-data-so-if-columns-have-the-same-name-they-will-merge-data-from-the-rows-merging-solution
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3
 |  |  |  |  |  |  | 1 | 2 | 3 |  |  | [NAME] | [NAME] | Adams | 87 | 89 | 100
 | 1Joe Adams | [NAME] | [NAME] | Adams | 87 |  | 87 | 89 | 100 |  |  | [NAME] | [NAME] | White | 67 | 75
 | 2Joe Adams | [NAME] | [NAME] | Adams | 89 |  | 87 | 89 | 100 |  |  | [NAME] | [NAME] | Doe | 80 | 71
 | 1Paul White | [NAME] | [NAME] | White | 67 |  | 67 | 75
 | [NAME] | [NAME] | [NAME] | White | 75 |  | 67 | 75
 | 1Jane Doe | [NAME] | [NAME] | Doe | 80 |  | 80 | 71
 | 2Jane Doe | [NAME] | [NAME] | Doe | 71 |  | 80 | 71
 | 3Joe Adams | [NAME] | [NAME] | Adams | 100 |  | 87 | 89 | 100
Spreadsheet: 115964d1311422332-range-of-data-copied-to-cell-on-different-sheet-remove-duplicates-tech-form-sample
Sheet: Data

Gender | Workstation_ID | Procedure_Levels | Attending_Surgeon | Resident_Surgeon | Reading_Neurologist | Attending_Anesthesiologist | Tech_Name | Hospital | Muscles | Modalities
 | IOM-1 |  | Dr. [NAME], Oran | Dr. [NAME], [NAME] | Dr. [NAME], Nabil | Dr. [NAME], [NAME] | [NAME], [NAME] | University Medical Center |  | SSEPs (Median)
 |  |  |  |  |  |  |  |  |  | SSEPs (Ulnar)
 |  |  |  |  |  |  |  |  |  | SSEPs (Posterior Tibial)
 |  |  |  |  |  |  |  |  |  | SSEPs (Peroneal)
 |  |  |  |  |  |  |  |  |  | TceMEP (Upper)
 |  |  |  |  |  |  |  |  |  | TceMEP (Lower)
 |  |  |  |  |  |  |  |  |  | TOF
 |  |  |  |  |  |  |  |  |  | S-EMG (1 Extremity )
 |  |  |  |  |  |  |  |  |  | S-EMG (2 Extremity)
 |  |  |  |  |  |  |  |  |  | S-EMG (3 Extremity)
 |  |  |  |  |  |  |  |  |  | S-EMG (4 Extremity)
 |  |  |  |  |  |  |  |  |  | S-EMG (Anal Sphincter)
 |  |  |  |  |  |  |  |  |  | S-EMG (Cranial Nerve-Unilateral)
 |  |  |  |  |  |  |  |  |  | S-EMG (Cranial Nerve-Bilateral)
 |  |  |  |  |  |  |  |  |  | S-EMG (Laryngeal Nerve)
 |  |  |  |  |  |  |  |  |  | S-EMG (Paraspinal)
 |  |  |  |  |  |  |  |  |  | T-EMG (Direct Nerve)
 |  |  |  |  |  |  |  |  |  | T-EMG (Pedicle Screw)
 |  |  |  |  |  |  |  |  |  | T-EMG (Cranial Nerve)
 |  |  |  |  |  |  |  |  |  | TCD
 |  |  |  |  |  |  |  |  |  | BAEP
 |  |  |  |  |  |  |  |  |  | EEG
 |  |  |  |  |  |  |  |  |  | Cortical_Mapping
 |  |  |  |  |  |  |  |  |  | H-Reflex Gastrocnemius/Soleus
Spreadsheet: 749873d1633072406-highlight-cell-by-certain-colour-based-on-3-criteria-colour-coding
Sheet: Block 1x1

Pile Code | Block | Section | Row | Pile |  | Pile Type |  |  |  |  |  | Requirements
 | 1 | 3 | 1 | A | Int | Standard |  | w6*9 | 3.22 | No Colour | 1.37 Int | (A,B,C,D,E,F,H,I,J,K),(Int),(Standard)
 | 1 | 3 | 1 | B | Int | Standard |  | w6*9 | 2.4 | Red |  | (G),(Int),(Standard)
 | 1 | 3 | 1 | C | Int | Standard |  | w8*10 | 3.42 | Yellow | 1.37 Ext | (A,B,C,D,E,F,H,I,J,K),(Ext),(Standard)
 | 1 | 3 | 1 | D | Int | Tall |  | w8*10 | 2.6 | Orange |  | (G),(Ext,(Standard)
 | 1 | 3 | 1 | E | Int | Standard |  | w8*10 | 3.5 | Purple | 1.52 Int | (A,B,C,D,E,F,H,I,J,K),(Int),(Tall)
 | 1 | 3 | 1 | F | Int | Standard |  | w8*10 | 2.68 | Pink |  | (G),(Int),(Tall)
 | 1 | 3 | 1 | G | Int | Tall |  | w6*12 | 3.7 | Black | 1.52 Ext | (A,B,C,D,E,F,H,I,J,K),(Ext),(Tall)
 | 1 | 3 | 1 | H | Int | Standard |  | w6*12 | 2.88 | Green |  | (G),(Ext),(Tall)
 | 1 | 3 | 1 | I | Int | Standard
 | 1 | 3 | 1 | J | Int | Standard
 | 1 | 3 | 1 | K | Int | Standard
 | 1 | 3 | 1 | L | Int | Standard
 | 1 | 3 | 1 | M | Int | Standard
Spreadsheet: 777169d1650228036-need-help-creating-all-possible-orders-with-regard-to-the-conditions-test-6-1-
Sheet: Hárok1

 | Sequence/Order: | 1 | 12 | 25 | 38 | 51 | 64 | 79 | 85 | 61 | 76 | 91 |  | Conditions: | 1 | in order somewhere after | 64 |  | for example: | 64 | 25 | 38 | 51 | 79 | 85 | 61 | 1 | 12 | 76 | 91
 | [NAME]/order ↓: |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | in order somewhere after | 85 |  |  | 64 | 25 | 38 | 51 | 79 | 85 | 61 | 1 | 12 | 91 | 76
 | without repetition |  |  |  |  |  |  |  |  |  |  |  |  |  | 79 | in order somewhere after | 38 |  |  | 64 | 25 | 38 | 51 | 79 | 85 | 61 | 1 | 91 | 12 | 76
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 85 | in order somewhere after | 51 |  |  | 25 | 38 | 51 | 64 | 79 | 85 | 1 | 61 | 91 | 12 | 76
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 61 | in order somewhere after | 51 |  |  | .
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76 | in order somewhere after | 38 |  |  | ..
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 91 | in order somewhere after | 1 |  |  | ...
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | free position
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | free position
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51 | free position
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64 | free position
Spreadsheet: 78552d1278945086-latest-price-price_book
Sheet: Sample

 | DATE | ITEM | QTY. | PRICE
 | 2010-01-01 00:00:00 | F | 10 | 6
 | 2010-01-16 00:00:00 | A | 22 | 10
 | 2010-02-01 00:00:00 | B | 12 | 17
 | 2010-02-15 00:00:00 | D | 30 | 16
 | 2010-02-16 00:00:00 | C | 10 | 6
 | 2010-03-01 00:00:00 | A | 24 | 10.5
 | 2010-03-16 00:00:00 | F | 12 | 6.5
 | 2010-03-31 00:00:00 | A | 44 | 15
 | 2010-04-13 00:00:00 | B | 24 | 16
 | 2010-04-15 00:00:00 | D | 120 | 14
 | 2010-04-17 00:00:00 | F | 10 | 5
 | 2010-05-15 00:00:00 | C | 6 | 4.5
 | 2010-05-16 00:00:00 | D | 30 | 15
 | 2010-06-01 00:00:00 | B | 124 | 17.5
 | 2010-06-05 00:00:00 | D | 3 | 15.5
 | 2010-06-07 00:00:00 | C | 6 | 5
 | 2010-06-12 00:00:00 | B | 32 | 14
 | 2010-06-15 00:00:00 | F | 20 | 7
 | 2010-07-01 00:00:00 | C | 21 | 5.5
 | 2010-07-11 00:00:00 | A | 12 | 12.5