tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 462813d1464197088-autofill-several-cells-based-on-single-unique-cell-master-register
Sheet: Sheet1

unique id | NAME | COMPANY | SITE INDUCTION Y/N | WORKED WITHIN LAST 12 HOURS | TIME YOU LEFT PLACE OF REST | TRAVEL TIME TO SITE | SIGNED IN Y/N | DATE | TIME ON   SITE | SIGNED      OUT    Y/N | TIME OFF  SITE | FIRST AIDER  Y N | COSS | RADIO LOG | MEDS TAKEN | ALL PPE OK | SPONSOR LOGO CORRECT | JOB ACTIVITY | MOBILE NO.
123456 | [NAME] | KELTBRAY | Y | N |  |  |  |  |  |  |  | N | Y |  |  |  |  | SM | 00123 456789
1234567 | [NAME] | COSTAIN | Y | Y |  |  |  |  |  |  |  | Y | N |  |  |  |  | TECH | 00234 564123
1011025 | [NAME] | TES | Y | Y |  |  |  |  |  |  |  | Y | Y |  |  |  |  | TM | 15423 124705
Spreadsheet: darrell_schoolcraft__7818__imbalsumm0109
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -89270 | -72220 | 0 | -16950
2 | -96891 | -72220 | 0 | -24950 |  |  |  |  |  |  |  |  |  | Avg
3 | -97824 | -72220 |  | -24950 |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
4 | -102043 | -77338 |  | -24624
5 | -85354 | -69960 |  | -14933
6 | -48847 | -43328 |  | -4968 |  |  |  |  |  | 2001-01-01 00:00:00 | -715680 | -705664 |  | 8.21
7 | -92703 | -80852 |  | -11848 |  |  |  |  |  | 2001-02-01 00:00:00 | -661568 | -648307 |  | 5.62
8 | -118238 | -73499 |  | -44100 |  |  |  |  |  | 2001-03-01 00:00:00 | -1831536 | -1828209 |  | 4.98
9 | -108131 | -67831 |  | -44100 |  |  |  |  |  | 2001-04-01 00:00:00 |  | -3486797 |  | 4.87
10 | -117446 | -72624 |  | -44100 |  |  |  |  |  | 2001-05-01 00:00:00 | -3735499 | -3753054 |  | 3.82
11 | -71297 | -71801 |  |  |  |  |  |  |  | 2001-06-01 00:00:00 |  | -5025875 |  | 3.2
12 |  |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00 | -4565965 | -4525416 |  | 2.77
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2001-08-31 00:00:00 |  |  | 457935.18
 |  |  |  | 2001-09-11 00:00:00
 | CBS Volume
 |  |  |  | 110189
Spreadsheet: 841309d1693496958-match-date-on-two-different-pages-and-paste-data-in-columns-copy-of-ef-file
Sheet: 1-28 night

 | CR1 | Priority | Headcount
1 | Alinity RV | 19 | 0.25
2 | Alinity RV | 18 | 0.25
3 | Alinity RV | 17 | 0.25
4 | Alinity RV | 16 | 0.25
5 | Alinity RV | 15 | 0.25
12 | [NAME] | 20 | 0.25
13 | [NAME] | 21 | 0.25
9 | Architect RV | 14 | 0.25
15 | Alinity SC | 13 | 0.25
16 | Architect RV | 12 | 0.25
17 | Alinity RV | 11 | 0.25
50 | Baxter SIV Assy | 22 | 3
31 | Architect RV | 10 | 0.25
8 | Alinity RV | 9 | 0.25
10 | Architect RV | 8 | 0.25
11 | [NAME] | 24 | 0.25
18 | Architect RV | 7 | 0.25
19 | Architect RV | 6 | 0.25
20 | Siemens Bases tray | 23 | 0.5
21 | Architect RV | 5 | 0.25
22 | Architect RV | 4 | 0.25
23 | Architect RV | 3 | 0.25
30 | Architect RV | 2 | 0.25
7 | Architect SC | 1 | 0.25
Total
 | CR2 | Priority
72 | 8ul OQ Low
73 | PP4 | 4 | 0.25
74 | PP3 | 5 | 0.25
77 | Base Cassette B PQ | 2 | 1
78 | Side Cassette A mold | 1 | 0.25
79 | [NAME] | 6 | 0.25
87 | [NAME] | 8 | 0.25
52 | Architect RV | 10 | 0.25
53 | Architect RV | 9 | 0.25
61 | [NAME] | 13 | 0.5
66 | [NAME] | 12 | 0.5
83 | Ceph OM#1
84 | Ceph MB#1
86 | [NAME] | 11 | 0.25
62 | NP227 | 14 | 0.25
63 | NP Birdcage
64 | Siemens 1ML |  |  | mpb
67 | [NAME]
69
88 | [NAME] | 7 | 0.25
89 | Top Frame B PQ | 3 | 1
106
107
108
109
Total
Spreadsheet: 241892d1370839836-hotel-reservation-spreadsheet-check-in-and-out-dates-listed-need-total-in-house-and-occ-sample-book
Sheet: Sheet1

Property # | Resv # | [NAME] | Checkout Date | # of nights
#181 | #4175 | 2013-06-06 00:00:00 | 2013-06-09 00:00:00 | 3
#196 | #4549 | 2013-06-06 00:00:00 | 2013-06-09 00:00:00 | 3
#279 | #3846 | 2013-06-06 00:00:00 | 2013-06-09 00:00:00 | 3
#66 | #4219 | 2013-06-07 00:00:00 | 2013-06-09 00:00:00 | 2
#67 | #4708 | 2013-06-07 00:00:00 | 2013-06-09 00:00:00 | 2
#68 | #4579 | 2013-06-07 00:00:00 | 2013-06-10 00:00:00 | 3
#70 | #3540 | 2013-06-07 00:00:00 | 2013-06-11 00:00:00 | 4
#71 | #4092 | 2013-06-07 00:00:00 | 2013-06-09 00:00:00 | 2
#72 | #3782 | 2013-06-07 00:00:00 | 2013-06-09 00:00:00 | 0
#74 | #4071 | 2013-06-07 00:00:00 | 2013-06-09 00:00:00 | 0
#74 | #4105 | 2013-06-07 00:00:00 | 2013-06-09 00:00:00 | 2
#192 | #3740 | 2013-06-07 00:00:00 | 2013-06-09 00:00:00 | 0
#261 | #4130 | 2013-06-07 00:00:00 | 2013-06-09 00:00:00 | 2
 | Total In House | Occupancy %
2013-06-06 00:00:00 | ? | ?
2013-06-07 00:00:00 | ? | ?
2013-06-08 00:00:00 | ? | ?
2013-06-09 00:00:00 | ? | ?
2013-06-10 00:00:00 | ? | ?
2013-06-11 00:00:00 | ? | ?
2013-06-12 00:00:00 | ? | ?
2013-06-13 00:00:00 | ? | ?
2013-06-14 00:00:00 | ? | ?
2013-06-15 00:00:00 | ? | ?
2013-06-16 00:00:00 | ? | ?
2013-06-17 00:00:00 | ? | ?
2013-06-18 00:00:00 | ? | ?
Spreadsheet: 74052d1274679306-can-i-make-tables-appear-as-i-enter-a-value-in-the-cell-how_to_mod
Sheet: Main

 | Day 1
 |  |  |  | MAIN |  |  |  |  |  |  |  |  |  |  |  | Step 1
 |  |  | Making Date |  |  | 2010-05-06 00:00:00 |  |  |  |  |  |  | If this table is empty, I don`t want any cards below. They should appear when number of batches entered
 |  |  | Use By |  |  | 2010-05-11 00:00:00
 |  |  | Batches Made |  |  | 8
1 |  |  | Traceability No. |  |  | 2 | 56456 | A |  |  |  |  |  |  |  | Step 2
 |  |  |  |  |  |  |  |  |  |  |  |  | I want the number of cards below the MAIN table depending how many batches have been made devided by 2. Example: if G6=36 then I want 36/2=18 Batch Cards below.
 |  | [NAME] | Batches |  |  | 2 | of | 8
 |  |  | Date baked
 |  |  | Time baked
 |  |  | Traceability No. |  |  | 2 | 56456 | A
1 |  |  | Product used in |  |  |  |  |  |  |  |  |  |  |  |  | Step 3
 |  |  |  |  |  |  |  |  |  |  |  |  | When [NAME] appear, I want Traceability No. letter to change on every [NAME] ascendingly. Example: [NAME] letter A, [NAME] letter B, and so on. Numbers on [NAME] remain the same as entered in MAIN.
 |  | [NAME] | Batches |  |  | 2 | of | 8
 |  |  | Date baked
 |  |  | Time baked
 |  |  | Traceability No. |  |  | 2 | 56456 | B
2 |  |  | Product used in
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Please note, that there are going to be 30 days.
 |  | [NAME] | Batches |  |  | 3 | of | 8
 |  |  | Date baked
 |  |  | Time baked
 |  |  | Traceability No. |  |  | 2 | 56456 | C
3 |  |  | Product used in
 |  |  |  |  |  |  |  |  |  |  |  |  | Hi, I have used Conditional Formatting to achieve the disappearance of [NAME]. Column A provides the Key, based on the number of [NAME] shown at G6. I have only gone down a limited way, I am hoping you can add more as required. I was a little unsure where you wish to Start Your First Batch????? Anyway, this is a start get back if you need more help. TonyB
 |  | [NAME] | Batches |  |  | 4 | of | 8
 |  |  | Date baked
 |  |  | Time baked
 |  |  | Traceability No. |  |  | 2 | 56456 | D
4 |  |  | Product used in
 |  | [NAME] | Batches |  |  | 5 | of | 8
 |  |  | Date baked
 |  |  | Time baked
 |  |  | Traceability No. |  |  | 2 | 56456 | "?"
0 |  |  | Product used in
 |  | [NAME] | Batches |  |  | 1 | of | 8
 |  |  | Date baked
 |  |  | Time baked
 |  |  | Traceability No. |  |  | 2 | 56456 | "?"
0 |  |  | Product used in
 |  | [NAME] | Batches |  |  | 1 | of | 8
 |  |  | Date baked
 |  |  | Time baked
 |  |  | Traceability No. |  |  | 2 | 56456 | "?"
0 |  |  | Product used in
 |  | [NAME] | Batches |  |  | 1 | of | 8
 |  |  | Date baked
 |  |  | Time baked
 |  |  | Traceability No. |  |  | 2 | 56456 | "?"
0 |  |  | Product used in
 |  | [NAME] | Batches |  |  | 1 | of | 8
 |  |  | Date baked
 |  |  | Time baked
 |  |  | Traceability No. |  |  | 2 | 56456 | "?"
0 |  |  | Product used in
Spreadsheet: 765183d1643205833-requesting-formula-for-conditional-formatting-sample-form-thanks
Sheet: Sheet1

Name | RID | PO | Date Referred | Next Report Day
[NAME] | 101 | GC | 2020-06-12 00:00:00 | 2022-01-18 00:00:00
[NAME] | 2980 | KA | 2020-06-15 00:00:00 | 2022-01-28 00:00:00
[NAME] | 460 | MK | 2020-06-23 00:00:00 | 2022-01-26 00:00:00
[NAME] | 582 | LB | 2020-06-26 00:00:00 | 2022-01-11 00:00:00
[NAME] | 297 | SR | 2020-07-01 00:00:00 | 2022-02-07 00:00:00
Mark | 342 | MW | 2020-07-08 00:00:00 | 2022-01-24 00:00:00
[NAME] | 811 | [NAME] | 2020-07-09 00:00:00 | 2022-01-25 00:00:00
[NAME] | 957 | RM | 2020-07-09 00:00:00 | 2022-01-27 00:00:00
[NAME] | 222 | MB | 2020-07-09 00:00:00 | 2022-01-26 00:00:00
Spreadsheet: 33589d1230045246-importing-data-from-a-print-file-m32example
Sheet: Sheet1

P U R C H A S E   H I S T O R Y
VEND | MODEL # |  |  |  | SALESMAN |  |  |  |  | TERMS DAYS TERMS % |  |  | FRGHT | PREPAID | ON | FRGHT
4634-88036BERXXL |  | [NAME] |  |  |  |  |  |  |  |  | SEE GI |  |  | FOB FACTORY
AA** | ATT: JOHN SMITH EXT 8337
GI** | CUSTOMER SERVICE FAX [PHONE]
DUE DATE | PO NUM | BAL DUE | VENDOR NAME |  |  |  | QTY ORD | QTY REC | FIRST DAY | DEL | VENDOR COST |  | LAND COST |  | STAT
2008-12-23 00:00:00 | 670125 | 36 | JOHNS CLOTHING COMPANY |  |  |  | 36 | 0 |  | 0 | 74.25 |  | 74.25 |  | OPEN
2008-12-15 00:00:00 | 670124 | 54 | JOHNS CLOTHING COMPANY |  |  |  | 54 | 50 | 2008-12-16 00:00:00 | -4 | 74.25 |  | 74.25 |  | COMP
ITEM NUMBER: | 97896BLKL | 11018975 |  |  |  |  |  |  |  |  | AS OF FRI, DEC 19, 2008 |  |  | 08:25:00
WAREHOUSE | LOCAL
STATUS: | ACTIVE |  | DESC: | XXXXXX JACKET MNS |  |  |  |  |  |  | PRODUCT CLASS: |  |  | CATEGORY: |  | 0L00
ALT #: |  | VEND MODEL #: |  |  |  |  | PURCH PACK SIZE: |  | 0 |  |  | PACK: | 0 | WEIGHT: |  | 1.74
 | NOMINAL LT: |  | 3 | NOMINAL RP: |  | 0 | CALC RP: | 0 | TOTAL HAND: | 35 | FUTURE ORDERS: |  | 36
 |  |  |  |  |  |  |  |  |  | TOTAL | 1 WK | 2 WKS | 3 WKS | Over 3 WKS
 |  | LOC CAP: | 12 |  | LOC RESTOCK: |  | 3
TRUE BO: | 0 | [NAME]: | 5 |  |  |  |  |  | BACK ORDERS: | 0
INDIRECT BO: | 0 | BULK: | 30 |  |  |  |  |  | RECENT SALE: | 270 | 36 | 59 | 51 | 16
S A L E S    H I S T O R Y
 | ****************** 08 ***************** |  |  |  |  | ******************** 07 *************** |  |  |  |  | ******************* 06 ****************
 | ST #1 | ST #2 | ST#3 | ST#4, 5 | TOTAL | ST #1 | ST #2 | ST#3 | ST#4, 5 | TOTAL | ST #1 | ST #2 | ST#3 | ST#4, 5 | TOTAL
1 | 3 | 0 | 5 | 19 | 27 | 0 | 0 | 3 | 4 | 7 | 1 | 0 | 3 | 6 | 10
2 | 1 | 0 | 3 | 10 | 14 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
3 | 0 | 0 | 1 | 7 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
4 | 0 | 0 | 2 | 2 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 0 | 0 | 7 | 1 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4
6 | 0 | 0 | 1 | 1 | 2 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 3 | 3 | 6
7 | 0 | 0 | 5 | 2 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | 3 | 26
8 | 0 | 0 | 5 | 4 | 9 | 2 | 0 | 0 | 3 | 5 | 0 | 0 | 12 | 4 | 16
9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 7 | 8 | 0 | 0 | 3 | 5 | 8
10 | 1 | 0 | 1 | 14 | 16 | 0 | 0 | 0 | 12 | 12 | 0 | 0 | 7 | 22 | 29
11 | 0 | 0 | 14 | 18 | 32 | 0 | 0 | 13 | 35 | 48 | 2 | 0 | 13 | 9 | 24
12 | 2 | 0 | 103 | 36 | 141 | 3 | 0 | 21 | 60 | 84 | 2 | 0 | 24 | 30 | 56
** | 7 | 0 | 147 | 114 | 268 | 5 | 0 | 39 | 122 | 166 | 5 | 0 | 89 | 86 | 180
Spreadsheet: 882079d1730356549-sports-carnival-help-millie0802-swimming-results-v2-spill-2021-aligw
Sheet: Age Champion

Name | HOUSE | BUTTERFLY |  | FREESTYLE |  | BREASTSTROKE |  | BACKSTROKE |  | Total | Place
 |  | Place | Points | Place | Points | Place | Points | Place | Points
Dayton | [NAME] | 1 |  | 2 |  | 3 |  | 5 |  |  |  |  | 1st: | 10
[NAME] | Bribie | 5 |  | 1 |  | 2 |  | 3 |  |  |  |  | 2nd | 6
[NAME] | Strady | 3 |  | 4 |  | 5 |  | 1 |  |  |  |  | 3rd | 3
Greg | [NAME] | 4 |  | 3 |  | 6 |  | 2 |  |  |  |  |  |  |  |  |  | Total
Norm | [NAME] | 2 |  | 5 |  | 1 |  | 6 |  |  |  |  | Age Champion | Points | House |  | [NAME]
[NAME] | Bribie | 6 |  | 6 |  | 4 |  | 4 |  |  |  |  |  | 19 | [NAME] |  | Bribie
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 19 | Bribie |  | Strady
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Up | Points | House
Want to assign points for each event automatically so that if the athlete places first it automatically assigns them 10 points etc |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | [NAME]
Want to tally house points so that all the [NAME] points are tallied [NAME] and all the [NAME] points are tallied S8 etc
Want the 'Age Champion' to populate N8 with the athlete name with the highest total point tally and for Points O8 and House P8 to populate as well
Want the ability, in case there is a tie for age champion or runner up for there to be two athletes named
Want Column L to populate with the placings from 1st to last (however many that may be)
Spreadsheet: 727235d1617794814-auto-fill-today-date-using-vlookup-function-auto-fill
Sheet: APR

 |  | 1005
 |  | 1010
 |  | 1015
Spreadsheet: 686578d1594692853-index-indirect-function-need-help-inventory-searchmaster2010-
Sheet: InventoryAudit 

Category | Massage
Category | Item | Projection | Actual
1 |  |  |  |  |  |  |  |  |  | =[NAME]))
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 | Categories | Mon | [NAME] | Wed | Thur | Fri | Sat | Sun
 | Massage
 | Golf
 | Food
 | Novelty
 | Reading
 | Clothing
 | Item | Beginning inventory | Total out | Total in | Ending | Actual | [NAME] | [NAME] | Turnover | Description
 | A1 | 35 |  |  |  |  | 25
 | A2 | 33 |  |  |  |  | 20
 | A3 | 48 |  |  |  |  | 15
 | A4 | 10 |  |  |  |  | 10
 | A5 | 52 |  |  |  |  | 30
 | A6 | 10 |  |  |  |  | 30
 | A7 | 22 |  |  |  |  | 30
 | A8 | 15 |  |  |  |  | 30
 | A9 | 20 |  |  |  |  | 30
 | A10 | 30 |  |  |  |  | 30
 | A11 | 22 |  |  |  |  | 30
 | A12 | 10 |  |  |  |  | 30
 | A13 | 23 |  |  |  |  | 30
 | A14 | 25 |  |  |  |  | 30
 | A15 | 12 |  |  |  |  | 30
 | A16 | 14 |  |  |  |  | 30
 | A17 | 16 |  |  |  |  | 30
 | A18 | 33 |  |  |  |  | 30
 | A19 | 27 |  |  |  |  | 30
 | A20 | 15 |  |  |  |  | 30
Spreadsheet: 776768d1649907707-transpose-data-into-the-adjoining-cells-test_transpose-single-cell-to-double_140422
Sheet: Sheet1

Symbol | [NAME] | Last Price | Chg | Chg | High |  |  | Average | Open | Increase in OI | Increase | Vol. Shares |  |  | % Change
 |  |  | (Rs) | (%) | Low |  |  | Price | Interest |  | (%) | Prev. Volume
NTPC | 2022-04-28 00:00:00 | 154.45 | 1.7 | 0.0111 | 156.65 |  |  | 154.84 | 67356900 | 3254700 | 0.0508 | 21870900 |  |  | 0.4855
 |  |  |  |  | 153.3 |  |  |  |  |  |  | 14723100
AMBUJACEM | 2022-04-28 00:00:00 | 370.2 | 10.25 | 0.0285 | 375.65 |  |  | 368.35 | 29545500 | 2877000 | 0.1079 | 28225500 |  |  | 0.086
 |  |  |  |  | 359.55 |  |  |  |  |  |  | 25990500
ONGC | 2022-04-28 00:00:00 | 174.25 | 4.85 | 0.0286 | 174.9
 |  |  |  |  | 171.2 |  |  | 73.86 | 56433300 | 2233000 | 0.0412 | 21013300 |  |  | 33.32
 |  |  |  |  |  |  |  |  |  |  |  | 15761900
1 | i want to get the data in cell |  |  | f3 and F4 to be transposed pasted in cells  G3 AND H3..
2 | i want to get the data in cell |  |  | M3 AND M4 To be pasted in  N3 AND O3
3 | for a single row it is easy |  |  |  | 156.65 | 156.65 | 153.3
 |  |  |  |  | 153.3
4 | I want to do it for a great many rows
Spreadsheet: 150244d1334346187-excel-logic-inc
Sheet: Sheet1

Starting Number | 0
Spreadsheet: 45353d1244104637-totalling-up-values-that-meet-two-criteria-muni-masters
Sheet: Municipal Collections Summary

Municipal Cages Collections Weekly Summary
Week commencing
Site | District | [NAME] | [NAME] CRTs | Fridges | Total all collections
[NAME] | Calderdale
Elland | Calderdale
[NAME] | Calderdale
Milner Royd | Calderdale
Todmorden | Calderdale
Calverley Bridge | Leeds
East Leeds | Leeds
[NAME] | Leeds
Holmewell Road | Leeds
[NAME] | Leeds
[NAME] | Leeds
Meanwood Road | Leeds
Milners Road | Leeds
[NAME] | Leeds
St Judes | Leeds
Stanley Road | Leeds
[NAME] | Leeds
 | Total
Spreadsheet: 837795d1690443562-highest-most-frequent-value-in-a-column-example
Sheet: Sheet1

 |  |  | Low/ Medium/ High | Low/ Medium/ High | Low/ Medium/ High | Low/ Medium/ High
 |  |  | 4 | 7 | 0 | 1
 |  |  | 4 | 8 | 6 | 2
 |  |  | 0 | 0 | 0 | 3
 |  |  | 0 | 0 | 0 | 4
 |  |  | 4 | 2 | 0 | 5
 |  |  | 4 | 4 | 0 | 6
 |  |  | 4 | 7 | 2 | 7
 |  |  | 4 | 8 | 0 | 8
 |  | Answer to be | 4 | 8 | 0 | 8
 |  | Doesn't Work
 |  |  |  | 8
 |  |  |  | 0
Spreadsheet: 879124d1726577473-conditional-formatting-based-on-days-remaining-procurement-schedule
Sheet: Sheet1

 |  |  |  |  |  | Todays Date:
 | Procurement Schedule
Item | Description | Supplier / Subcontractor | Total Cost | Lead Time (wks) | Date Order Required | Actual Start Date
 |  |  |  | 1 |  | 2024-09-30 00:00:00
 |  |  |  | 5 |  | 2024-10-30 00:00:00
 |  |  |  | 4 |  | 2024-10-31 00:00:00
 |  |  |  | 5 |  | 2024-11-01 00:00:00
 |  |  |  | 6 |  | 2024-11-02 00:00:00
 |  |  |  | 7 |  | 2024-11-03 00:00:00
 |  |  |  |  |  | 2024-11-04 00:00:00
 |  |  |  | 1
 |  |  |  | 1 |  | 2024-11-06 00:00:00
Spreadsheet: 833639d1687165750-using-mod-and-if-to-find-cell-value-vs-reference-and-show-if-divisible-but-i-have-an-issue-copy-of-fvf_sample
Sheet: Data Sheet

Week Date | 2023-06-18 00:00:00
 |  |  |  |  | Current |  |  |  | Peak | Additional Goals Entry
Name | Team | Starting Weight | Starting Height | Starting BMI | Weekly Result (+/-) | Weekly BMI | Overall (+/-) | Overall %age Lost | Peak %age Lost | Hat-Trick | Tracked Food? | POTW | Milestone Hit? | [NAME] (1st week)? | [NAME]? | Lost Weight? | Individual Goals For/Against | 2023-05-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | POTW awarded | (enter Y if Peak passes 5/10/15% on weigh in) | Between 18.5 and 24.9 |  |  |  | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg)
[NAME] | Black | 96.9 | 180 |  |  |  |  |  |  |  | Y |  |  |  |  |  |  | 96.1 | 98 | 98.5 | 97.9 | 97.5 | 96.8
Spreadsheet: d233960d-8d81-4df9-91ec-88fbc2efec6d
Sheet: Income Statement

The NASDAQ OMX Group, Inc.
Consolidated Statements of Income
(in millions, except per share amounts)
(unaudited)
 |  | Three Months Ended
 |  | March 31, |  | December 31, |  | March 31,
 |  | 2012 |  | 2011 |  | 2011
Revenues:
Market Services |  | 666 |  | 698 |  | 683
Cost of revenues:
Transaction rebates |  | -306 |  | -324 |  | -309
Brokerage, clearance and exchange fees |  | -84 |  | -93 |  | -93
Total cost of revenues
Total Market Services revenues less transaction rebates,
brokerage, clearance and exchange fees |  |  |  |  |  | 281
Issuer Services |  | 90 |  | 91 |  | 89
Market Technology |  | 45 |  | 48 |  | 43
Revenues less transaction rebates, brokerage,
clearance and exchange fees
Operating Expenses:
Compensation and benefits |  | 112 |  | 113 |  | 112
Marketing and advertising |  | 6 |  | 9 |  | 5
Depreciation and amortization |  | 26 |  | 28 |  | 27
Professional and contract services |  | 22 |  | 23 |  | 19
Computer operations and data communications |  | 17 |  | 15 |  | 17
Occupancy |  | 23 |  | 22 |  | 23
Regulatory |  | 9 |  | 9 |  | 9
Merger and strategic initiatives |  | 2 |  | 1 |  | 5
Restructuring and other charges |  | 9 |  | 0 |  | 0
General, administrative and other |  | 14 |  | 39 |  | 13
Total operating expenses
Operating income
Interest income |  | 2 |  | 3 |  | 2
Interest expense |  | -24 |  | -26 |  | -32
Asset impairment charges |  | -12 |  | -18 |  | 0
Dividend and investment income |  | 0 |  | 0 |  | -1
Income from unconsolidated investees, net |  | 0 |  | 1 |  | 0
Income before income taxes
Income tax provision |  | 53 |  | 40 |  | 49
Net income
Net loss attributable to noncontrolling interests |  | 1 |  | 1 |  | 1
Net income attributable to NASDAQ OMX
Basic and diluted earnings per share:
Basic earnings per share |  | 0.49 |  | 0.46 |  | 0.59
Diluted earnings per share |  | 0.48 |  | 0.45 |  | 0.57
Weighted-average common shares outstanding
for earnings per share:
Basic |  | 173 |  | 175 |  | 176
Diluted |  | 178 |  | 180 |  | 181
Spreadsheet: 775821d1649336948-converting-time-duration-format-2-3
Sheet:  #2 #3

 |  | #2 | #3
03
17 | I wanna convert column A
07:03 | into Column C
09:48
10:03
52:42
02:58:05
11:45:36
Spreadsheet: 739434d1625693266-nested-if-function-to-pull-info-from-multiple-cells-sample-2
Sheet: Manning Table W1 & W2

ASSIGNMENT MANNING TABLE
DIETARY AIDES FT
WEEK 1 | WED | THU | FRI | SAT | SUN | MON | TUE
 | 2021-07-21 00:00:00
FGN ER
KJN G9
FGN F4
Clean
FAN NS
FGN G7
FAN P
FGN G6
FGN F5
FGN C6
FGN MH
[NAME]
FGN C7
JGN DR
FGN G5
FGN F3
FGN F6
FGN C5
FLOAT
GAD G9
SKH
Clean
ASSIGNMENT MANNING TABLE
DIETARY AIDES PT
WEEK 1 | WED | THU | FRI | SAT | SUN | MON | TUE
 | 2021-07-21 00:00:00
FGN ER
KJN G9
FGN F4
Clean
FAN NS
FGN G7
FAN P
FGN G6
FGN F5
FGN C6
FGN MH
[NAME]
FGN C7
JGN DR
FGN G5
FGN F3
FGN F6
FGN C5
FLOAT
GAD G9
SKH
Clean
Spreadsheet: 49963d1249388660-linking-if-function-to-other-worksheets-figs-test
Sheet: CEImporter

 | 2009
 | Market | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 |  | TOTAL
 | CE / Importer | 8974 | 11948 | 9286 | 13411 | 8085 | 6082 | 9083 | 9831 | 15267 | 0 | 0 | 0 |  | 91967
Customer | Market | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 |  | Total
CUST 7 | CE / Importer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 43 | 0 | 0 | 0 | 0 | 43
CUST 8 | CE / Importer | 1736 | 1423 | 975 | 2069 | 1568 | 1153 | 969 | 1062 | 1401 | 0 | 0 | 0 | 0 | 12356
CUST 9 | CE / Importer | 821 | 1618 | 836 | 523 | 208 | 0 | 0 | 0 | -48 | 0 | 0 | 0 | 0 | 3958
CUST 10 | CE / Importer | 47 | 47 | 48 | 22 | 44 | 15 | 5 | 9 | 0 | 0 | 0 | 0 | 0 | 237
CUST 11 | CE / Importer | 5936 | 5970 | 5157 | 3186 | 3297 | 3621 | 3123 | 2755 | 2731 | 0 | 0 | 0 | 0 | 35776
CUST 12 | CE / Importer | -1002 | 2890 | 849 | 7442 | 906 | 786 | 941 | 4502 | 11140 | 0 | 0 | 0 | 0 | 28454
CUST 13 | CE / Importer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CUST 14 | CE / Importer | 0 | 0 | 0 | 0 | 0 | 0 | 3453 | 0 | 0 | 0 | 0 | 0 | 0 | 3453
CUST 15 | CE / Importer | 1436 | 0 | 1421 | 169 | 2062 | 507 | 592 | 1503 | 0 | 0 | 0 | 0 | 0 | 7690
Spreadsheet: 838446d1691011421-help-with-formula-maybe-sumifs-ret_eng
Sheet: April Orders

Order ID | SKU | Quantity
101 | ABC1 | 1
102 | ABC1 | 1
103 | ABC1 | 1
104 | ABC5 | 1
105 | ABC5 | 1
106 | [NAME] | 2
107 | ABC3 | 3
108 | ABC1 | 1
109 | [NAME] | 1
110 | [NAME] | 1
111 | [NAME] | 1
112 | [NAME] | 1
113 | [NAME] | 2
114 | [NAME] | 4
115 | [NAME] | 1
116 | [NAME] | 1
117 | [NAME] | 1
118 | [NAME] | 1
119 | [NAME] | 1
120 | [NAME] | 1
121 | [NAME] | 1
122 | [NAME] | 1
123 | ABC5 | 2
124 | ABC5 | 2
125 | ABC3 | 2
126 | ABC3 | 2
127 | ABC3 | 3
128 | ABC1 | 1
129 | ABC1 | 1
Spreadsheet: 300799d1393571648-copying-last-6-columns-of-152-excel-sheets-tabs-into-1-sheet-micro_2004-4-
Sheet: Page 85

HINO | DUTRO | 3700 | (D) |  | KK-BU301M | 4B | 99/06～ | 90915-30002 | T1640 | 17801-78010 | A1396 | 23390-64480 | FT1910
HINO | DUTRO | 3700 | (D) |  | KK-BU301X | 4B | 99/05～ | 90915-30002 | T1640 | 17801-78010 | A1396 | 23390-64480 | FT1910
HINO | DUTRO | 3700 | (D) |  | KK-BU306M | 4B | 99/05～ | 90915-30002 | T1640 | 17801-78010 | A1396 | 23390-64480 | FT1910
HINO | DUTRO | 3700 | (D) |  | KK-BU306Y | 4B | 99/05～ | 90915-30002 | T1640 | 17801-78010 | A1396 | 23390-64480 | FT1910
HINO | DUTRO | 3700 | (D) |  | KK-BU346M | 4B | 99/05～ | 90915-30002 | T1640 | 17801-78010 | A1396 | 23390-64480 | FT1910
HINO | DUTRO | 4100 | (D) | TURBO | KK-BU400M | 15B-FTE | 99/07～ | 90915-30002 | T1640 | 17801-78020 | A1410 | 23390-64480 | FT1910
HINO | DUTRO | 4100 | (D) | TURBO | KK-BU410M | 15B-FTE | 99/07～ | 90915-30002 | T1640 | 17801-78020 | A1410 | 23390-64480 | FT1910
HINO | DUTRO | 4100 | (D) | TURBO | KK-BU420M | 15B-FTE | 99/07～ | 90915-30002 | T1640 | 17801-78020 | A1410 | 23390-64480 | FT1910
HINO | DUTRO | 4100 | (D) | TURBO | KK-BU430M | 15B-FTE | 99/07～ | 90915-30002 | T1640 | 17801-78020 | A1410 | 23390-64480 | FT1910
Spreadsheet: 714811d1611383571-google-sheets-countifs-and-sumif-formulas-returning-0-copy-of-terrenos-familia-3-
Sheet: Vista Cibeles #99

 | VISTA CIBELES #99 |  |  | Renta
 |  |  |  | Meses rentados |  |  | Gastos
 |  |  |  | Ingresos |  |  | Ingresos
 |  |  |  |  |  |  | [NAME]
 | Fecha de pago | Propriedad | Persona | Descripcion | [NAME] | Monto | Recibo/Factura | Comentarios