tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 739644d1625841498-how-to-auto-populate-information-from-one-tab-to-the-other-moveuniquevalues
Sheet: Sheet5

[NAME]
Amber Riley
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Amber Riley
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Amber Riley
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Amber Riley
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Amber Riley
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 78382d1278712880-spreadsheet-layout-from-data-dump-problem-example
Sheet: Desired Format

 |  | SITE 0 |  | SITE 1 |  | SITE 2 |  | SITE 3
 |  | Start | Finish | Start | Finish | Start | Finish | Start | Finish
GEN
 | Activity 1
SOU
 | Activity 2
GOV
 | Activity 3
APP
 | Activity 4
 | Activity 5
 | Activity 6
 | Activity 7
OUT
 | Activity 8
 | Activity 9
 | Activity 10
ACQ
 | Activity 11
 | Activity 12
 | Activity 13
 | Activity 14
 | Activity 15
 | Activity 16
EAS
 | Activity 17
 | Activity 18
 | Activity 19
CON
 | Activity 20
 | Activity 21
 | Activity 22
 | Activity 23
Spreadsheet: 810569d1671855781-need-a-formula-to-lookup-balance-of-certain-account-for-1st-day-of-every-month-book5-bvj-
Sheet: Sheet1

Date | Account # | Institution | Balance | Balance2
2022-11-28 22:43:51 | xxxx0570 | Chase | 2231.55 | CREDIT
2022-11-30 07:24:10 | xxxx0570 | Chase | 2231.55 | CREDIT
2022-12-01 10:48:06 | xxxx0570 | Chase | 2231.55 | CREDIT
2022-12-03 03:48:24 | xxxx0570 | Chase | 2118.55 | CREDIT |  |  | 2022-12-01 00:00:00 | END OF DAY | START OF DAY
2022-12-04 00:00:27 | xxxx0570 | Chase | 2118.55 | CREDIT |  |  | xxxx0570
2022-11-29 07:17:07 | xxxx3838 | Capital One | 1338.72 | CREDIT |  |  | xxxx3838
2022-11-30 00:04:18 | xxxx3838 | Capital One | 1338.72 | CREDIT |  |  | xxxx4887
2022-12-01 02:15:13 | xxxx3838 | Capital One | 1338.72 | CREDIT |  |  | xxxx9243
2022-12-02 18:14:39 | xxxx3838 | Capital One | 1338.72 | CREDIT |  |  | xxxx6977
2022-12-03 18:23:14 | xxxx3838 | Capital One | 1338.72 | CREDIT
2022-12-04 18:35:31 | xxxx3838 | Capital One | 1297.72 | CREDIT
2022-11-29 07:17:07 | xxxx4887 | Capital One | 1257.87 | CREDIT
2022-11-30 00:04:18 | xxxx4887 | Capital One | 1257.87 | CREDIT
2022-12-01 02:15:13 | xxxx4887 | Capital One | 1257.87 | CREDIT
2022-12-02 18:14:39 | xxxx4887 | Capital One | 1257.87 | CREDIT
2022-12-03 18:23:14 | xxxx4887 | Capital One | 1257.87 | CREDIT
2022-12-04 18:35:31 | xxxx4887 | Capital One | 1218.87 | CREDIT
2022-11-30 02:50:44 | xxxx5009 | American Express Cards | 1018.59 | CREDIT
2022-12-01 02:17:33 | xxxx5009 | American Express Cards | 1018.59 | CREDIT
2022-12-02 06:59:24 | xxxx5009 | American Express Cards | 1018.59 | CREDIT
2022-12-02 22:09:56 | xxxx5009 | American Express Cards | 1048.25 | CREDIT
2022-12-03 22:28:28 | xxxx5009 | American Express Cards | 1048.25 | CREDIT
2022-12-04 23:09:02 | xxxx5009 | American Express Cards | 1048.25 | CREDIT
2022-11-29 04:57:44 | xxxx6977 | Citibank | 2154.08 | CREDIT
2022-11-30 09:45:37 | xxxx6977 | Citibank | 2154.08 | CREDIT
2022-12-01 12:09:15 | xxxx6977 | Citibank | 2113.08 | CREDIT
2022-12-02 09:27:18 | xxxx6977 | Citibank | 2113.08 | CREDIT
2022-12-03 23:11:33 | xxxx6977 | Citibank | 2113.08 | CREDIT
2022-12-05 03:16:35 | xxxx6977 | Citibank | 2113.08 | CREDIT
2022-11-29 06:35:01 | xxxx8214 | Discover Card | 3850.9 | CREDIT
2022-11-30 03:32:15 | xxxx8214 | Discover Card | 3850.9 | CREDIT
2022-12-01 09:44:43 | xxxx8214 | Discover Card | 3850.9 | CREDIT
2022-12-02 05:40:37 | xxxx8214 | Discover Card | 3850.9 | CREDIT
2022-12-03 00:32:55 | xxxx8214 | Discover Card | 3850.9 | CREDIT
2022-12-04 04:13:33 | xxxx8214 | Discover Card | 3850.9 | CREDIT
2022-12-05 07:09:22 | xxxx8214 | Discover Card | 3924.28 | CREDIT
2022-11-30 02:36:20 | xxxx9243 | Wells Fargo | 1540.54 | CREDIT
2022-12-01 04:39:48 | xxxx9243 | Wells Fargo | 1540.54 | CREDIT
2022-12-02 05:06:50 | xxxx9243 | Wells Fargo | 1540.54 | CREDIT
2022-12-03 04:30:03 | xxxx9243 | Wells Fargo | 1540.54 | CREDIT
2022-12-04 18:14:37 | xxxx9243 | Wells Fargo | 1540.54 | CREDIT
2022-12-05 20:05:43 | xxxx9243 | Wells Fargo | 1540.54 | CREDIT
Spreadsheet: 525929d1499025296-sum-statement-excel-forum-version
Sheet: Huntage

Date | Horse | Time | Meeting | Advised/BOG | Stake | Result | R4 | Advised P&L | BFSP | BFSP P&L |  |  | Advised PL |  | BFSP PL
2017-07-02 00:00:00 | Red Riverman | 15:55:00 | [NAME] | 6 | 1 | 0 | 0 |  | 10.58
2017-07-02 00:00:00 | Notarfbad | 16:35:00 | [NAME] | 12 | 1 | 2 | 0 |  | 0
2017-07-02 00:00:00 | Omid | 17:00:00 | [NAME] | 5.5 | 1 | 0 | 0 |  | 10.72
2017-06-30 00:00:00 | Tontos Spirit | 1904-01-01 16:50:00 | [NAME] | 12 | 1 | 0 | 0 |  | 8.6
2017-06-22 00:00:00 | King Massini | 1904-01-01 20:10:00 | Ffos Las | 14 | 1 | 0 | 0 |  | 55
2017-06-22 00:00:00 | Catcher On The Go | 1904-01-01 20:40:00 | Ffos Las | 16 | 1 | 1 | 0 |  | 34.86
2017-06-21 00:00:00 | [NAME] Tongues | 17:20:00 | [NAME] | 8 | 1 | 2 | 0 |  | 0
2017-06-17 00:00:00 | Master Of Irony | 15:55:00 | Hexham | 4 | 1 | 0 | 0 |  | 7.5
2017-06-15 00:00:00 | [NAME] | 15:30:00 | Fontwell | 3.5 | 1 | 0 | 0 |  | 4.5
2017-06-15 00:00:00 | Lovely Job | 18:25:00 | [NAME] | 3.333333333333333 | 1 | 1 | 0.25 |  | 3.71
2017-06-15 00:00:00 | The Groove | 20:00:00 | [NAME] | 14 | 1 | 0 | 0 |  | 65
2017-06-14 00:00:00 | [NAME] | 14:50:00 | Worcester | 11 | 1 | 0 | 0 |  | 12.82
2017-06-13 00:00:00 | Little Pop | 18:00:00 | Southwell | 7.5 | 1 | 1 | 0 |  | 6.66
2017-06-13 00:00:00 | Barkis | 20:00:00 | Southwell | 12 | 1 | 0 | 0 |  | 20.91
2017-06-10 00:00:00 | Barman | 1904-01-01 19:00:00 | [NAME] | 5.5 | 1 | 0 | 0 |  | 4.4
2017-06-06 00:00:00 | [NAME] | 1904-01-01 19:05:00 | Southwell | 1.5 | 1 | 1 | 0 |  | 2.67
2017-06-05 00:00:00 | [NAME] | 1904-01-01 15:40:00 | [NAME] | 10 | 1 | 2 | 0 |  | 0
2017-06-05 00:00:00 | [NAME] | 1904-01-01 14:10:00 | [NAME] | 9 | 1 | 0 | 0 |  | 8.72
2017-06-05 00:00:00 | Tea In Transvaal | 1904-01-01 15:10:00 | [NAME] | 8 | 1 | 0 | 0 |  | 8.19
2017-06-05 00:00:00 | Milan Hart | 1904-01-01 16:10:00 | [NAME] | 33 | 1 | 0 | 0 |  | 17.17
2017-06-04 00:00:00 | Ballykan | 1904-01-01 16:15:00 | Perth | 12 | 1 | 0 | 0 |  | 6.8
2017-06-04 00:00:00 | [NAME] | 1904-01-01 16:50:00 | Kilbeggan | 16 | 1 | 0 | 0 |  | 18.5
2017-06-02 00:00:00 | Tangolan | 1904-01-01 16:00:00 | Market Rasen | 10 | 1 | 0 | 0 |  | 50.31
2017-06-02 00:00:00 | Blue Comet | 1904-01-01 16:45:00 | Market Rasen | 7 | 1 | 0 | 0 |  | 3.39
2017-06-01 00:00:00 | Skewiff | 1904-01-01 20:00:00 | Ffos Las | 4 | 1 | 1 | 0 |  | 2.96
Spreadsheet: 708936d1608102304-combine-data-feom-2-rows-in-2-comlumns-into-one-row-and-column-d-and-p-ans2
Sheet: Feb

name | bol date | am/pm | d/p |  |  | total |  |  |  | Sheets
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 |  |  |  | Feb
Bum | 2020-01-10 00:00:00 | am | d |  |  |  |  |  |  | Mar
[NAME] | 2020-01-14 00:00:00 | pm | d |  |  |  |  |  |  | Apr
[NAME] | 2020-02-13 00:00:00 | am | d |  |  |  |  |  |  | May
mary | 2020-02-15 00:00:00 | am | d |  |  |  |  |  |  | Jun
bum | 2020-02-09 00:00:00 | pm | p |  |  |  |  |  |  | Jul
herold | 2020-02-10 00:00:00 | am | d |  |  |  |  |  |  | Aug
becky | 2020-02-15 00:00:00 | pm | d |  |  |  |  |  |  | Sep
[NAME] | 2020-02-18 00:00:00 | pm | p |  |  |  |  |  |  | Oct
becky | 2020-02-19 00:00:00 | pm | p |  |  |  |  |  |  | Nov
[NAME] | 2020-02-20 00:00:00 | am | d |  |  |  |  |  |  | Dec
Spreadsheet: 838964d1691566947-copying-a-number-to-a-different-column-and-specific-number-of-rows-copynumber
Sheet: data

 | 7330
 | 7330
 | 24558
 | 470812
 | 653373
 | 82640
 | 7330
 | 7330
 | 7330
 | 25226
 | 25226
 | 581500
 | 25226
 | 25226
 | 25226
 | 82664
 | 82664
 | 82480
 | 82664
 | 82664
 | 82664
 | 6060
 | 6060
 | 1921
 | 19462
 | 481899
 | 57601
 | 653442
 | 82495
 | 82593
! | 494147
 | 668527
 | 6060
 | 6060
 | 6060
Spreadsheet: 672402d1586863251-autofil-pairs-of-rows-example-abcpairs
Sheet: Biex try to help

 | Datset I have :
 | A |  | B |  | C |  |  | Matrix of pairs of 1 (green)
 | a | b | a | b | a | b |  |  | A | B | C
1 |  |  | 3 |  | 1 |  |  | A | 8 |  |  | I already have this matrix
2 |  |  | 3 |  |  | 1 |  | B | 6 | 11
3 |  |  | 3 |  | 1 |  |  | C | 3 | 3 | 11
4 | 1 |  | 3 |  |  | 1
5 | 1 |  | 1 |  |  |  |  | Matrix of neither has a 3 (non reds) |  |  |  | number of lines where there is no 3 either in A or B, A or C, B or C
6 | 1 |  | 1 |  |  |  |  |  | A | B | C
7 |  | 1 |  | 1 |  |  |  | A |  |  |  | I'm looking for a way to create this one
8 |  |  |  |  |  |  |  | B |  |  |  | Ex: for AB I count entries 5 to 12 then 19 and 20, total = 10
9 | 1 |  | 1 |  | 3 |  |  | C
10 |  |  |  | 1 | 3 |  |  | so I count the number of line that has no 3 in either Aa or Ba, Aa or Ca, Ba or Ca etc… over the entire row (here from line 4 to line 23).
11 | 1 |  | 1 |  | 3 |  |  | Everytime there is a 3, do not count. I'm thinking playing with COUNTIF and a step dataset but I don't know how to autofil all the pairs
12 |  |  |  | 1 | 3 |  |  | we would need to autofil with pairs like this : (row)B and (row)D, then B and F, then D and F. 3s are always in the "a" rows.
13 | 3 |  | 1 |  | 3 |  |  | for this simple dataset it's easy, for for 31 entries that leave me with a lot of pairs so I really need to automate this.
14 | 3 |  | 1 |  | 1 |  |  | Even if I could simply create a step dataset with the sum of each pair for each line then I can COUNTIF(row;<3) over the entire rows and have my answers.
15 | 3 |  |  |  | 1 |  |  | that would leave me with my answers in a line instead of a matrix but I can manually refill if no better options.
16 | 3 |  |  |  | 1
17 | 3 |  |  |  |  | 1 |  | Comments :
18 | 3 |  | 1 |  | 1 |  |  | - "3" can be changed to anything preferable with a simple "replace" over the dataset.
19 |  | 1 |  | 1 |  | 1 |  | - there are 31 (a+b) so 62 rows
20 | 1 |  |  |  | 1 |  |  | - there is over 650 lines and growing potentially
 |  |  |  |  |  |  |  | - we can delete all the "b" row if important for autofilling
Seen total (1s) | 6 | 2 | 7 | 4 | 7 | 4
Over x potential (non-red) | 14 |  | 16 |  | 15
Spreadsheet: 547386d1510530002-employee-daily-schedule-gantt-chart-copy-of-excel-gnatt-schedule-ryesner-
Sheet: Tues

INTERNATIONAL | Name |  | In | Out | Duration |  | 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00
Sr. International Relationship | Lauren |  | 09:00:00 | 17:00:00
 | [NAME] |  | 14:00:00 | 22:00:00
 | Tiffany |  |  |  | 8
 | Son |  |  |  | 8
Manager of Int'l   Relationship | Phuong |  |  |  | 8
 | [NAME] |  |  |  | 8
 | [NAME] |  |  |  | 8
 | [NAME] |  |  |  | 8
 | Stephen |  |  |  | 8
DOMESTIC | Name
Sr. Relationship | [NAME] |  |  |  | 8
 | [NAME] |  |  |  | 8
 | Yuliana |  |  |  | 8
 | [NAME] |  |  |  | 8
 | [NAME] |  |  |  | 8
Relationship | Keila |  |  |  | 8
 | Nairobi |  |  |  | 8
 | [NAME] |  |  |  | 8
 | [NAME] |  |  |  | 8
Host | [NAME] |  |  |  | 8
 | Joy |  |  |  | 8
VIP Services & Admin | Name
VIP Services Coordinator | [NAME] |  |  |  | 8
 | [NAME] |  |  |  | 8
VIP Concierge | Brittany |  |  |  | 8
 | Delena |  |  |  | 8
 | Sheena |  |  |  | 8
Spreadsheet: 851257d1701466945-a-way-formula-to-have-sheet-2-build-itself-into-a-list-from-sheet-1-off-of-a-date-trigger-problem1-rev1
Sheet: Sheet2

Sheet 2
Order ID | [NAME] | Ship Date | Express | Due Date | Days Over Due | Ship ID
22 | Air | 2023-10-25 00:00:00 | Yes | 2024-04-02 00:00:00 |  | 543
25 | Air | 2023-07-08 00:00:00 | No | 2023-12-15 00:00:00 |  | 722
26 | Land | 2023-01-20 00:00:00 | Yes | 2023-06-29 00:00:00 |  | 643
68 | Air | 2023-11-15 00:00:00 | Yes | 2024-04-23 00:00:00 |  | 986
72 | Land | 2023-08-19 00:00:00 | Yes | 2024-01-26 00:00:00 |  | 223
98 | Land | 2023-08-31 00:00:00 | Yes | 2024-02-07 00:00:00 |  | 510
47 | Land | 2023-06-13 00:00:00 | No | 2023-11-20 00:00:00 |  | 473
35 | Land | 2023-04-01 00:00:00 | No | 2023-09-08 00:00:00 |  | 435
19 | Air | 2023-02-05 00:00:00 | No | 2023-07-15 00:00:00 |  | 397
66 | Air | 2023-05-23 00:00:00 | No | 2023-10-30 00:00:00 |  | 600
74 | Land | 2023-12-28 00:00:00 | No | 2024-06-05 00:00:00 |  | 322
11 | Land | 2023-09-10 00:00:00 | Yes | 2024-02-17 00:00:00 |  | 285
17 | Air | 2023-10-20 00:00:00 | No | 2024-03-28 00:00:00 |  | 247
Spreadsheet: 90544d1290275724-fill-a-field-with-a-colour-after-entering-data-in-field-for-web-question
Sheet: Sheet1

A = Complete UIF Form |  | D = Cheque paid in at SARS (date) |  |  |  |  |  |  | I1 = Informed Client per phone (date) |  |  |  |  |  | L = Paid SARS on date
B1 = Informed Client per phone (date) |  | E = Paid SARS on date |  |  |  |  |  |  | I2 = Informed Client per SMS (date) |  |  |  |  |  | M = Payment checked by OZ
B2 =  Informed Client per SMS (date) |  | F = Payment checked by OZ |  |  |  |  |  |  | I3 = Informed Client per E-mail (date) |  |  |  |  |  | N = Proof of Payment received from SARS
B3 =  Informed Client per E-mail (date) |  | G = Proof of Payment received from SARS |  |  |  |  |  |  | J = Received cheque from client |  |  |  |  |  | O = Month complete and finalized
C = Received cheque from client |  | H = Received notice of penalty + Interest |  |  |  |  |  |  | K = Cheque paid in at SARS
Name client | A | B1 | B2 | B3 | C | D | E | F | G | H | I1 | I2 | I3 | J | K | L | M | N | O
A
before
completing data |  | 2010-09-01 00:00:00 | 2010-09-02 00:00:00 | 2010-09-02 00:00:00
stil completing till work done |  | 2010-09-01 00:00:00 | 2010-09-01 00:00:00 | NA |  |  |  |  |  |  | 2010-09-07 00:00:00 | 2010-09-07 00:00:00 | NA
stil completing till work done |  | 2010-09-01 00:00:00 | 2010-09-01 00:00:00 | NA | Y | Y | Y | Y | Y | Y | 2010-09-07 00:00:00 | 2010-09-07 00:00:00 | NA
All work done |  | 2010-09-01 00:00:00 | 2010-09-02 00:00:00 | 2010-09-02 00:00:00 | Y | Y | Y | Y | Y | Y | 2010-09-07 00:00:00 | 2010-09-07 00:00:00 | 2010-09-07 00:00:00 | Y | Y | Y | Y | Y
automatically everything green |  | 2010-09-01 00:00:00 | 2010-09-02 00:00:00 | 2010-09-02 00:00:00 | ATM |  |  |  |  |  | 2010-09-07 00:00:00 | 2010-09-07 00:00:00 | 2010-09-07 00:00:00 |  |  |  |  |  | Y
As you can see are there about 20 fields - steps - before completing the full line in green. When all work is done it is in one sight possible to see
Second question if I add a date after the 8th of the month  at field I1,I2  could it be possible that it will show pink or orange  automitically?
Thank you for your assistance and support
Spreadsheet: 9e3169d7-3d8f-41c2-acd2-89220c4e2f1f
Sheet: Sheet1

 | Carnotaurus sastrei
 | Natural History Museum of Los Angeles County
 | LACM 127704 (cast of MACN-CH 894)
 | [NAME] | 1 | 2 | 3 | 4 | 5 | 6
 | Spinous Process
 | [NAME] (from neural arch) | 110 | 109 | 104 | 112 | 113 | 105
 | [NAME] (from neural arch) | 142 | 135 | 125 | 135 | 138 | 123
 | Basal Length | 74 | 73 | 77 | 81 | 75 | 70
 | Basal Width | 21 | 21 | 15 | 12 | 19 | 10
 | Middle Length | 61 | 60 | 47 | 48 | 43 | 43
 | Tip Length | 51 | 45 | 43 | 48 | 38 | 33
 | Tip [NAME] | 26 | 23 | 29 | 24 | 28 | 14
 | [NAME]
 | [NAME] | 215 | 180 | 210 | 230 | 205 | 200
 | Maximum Lateral [NAME] (from Neural Arch) | 129 | 136 | 90 | 111 | 127 | 118
 | Lateral Run (from centrum to tip) | 225 | 215 | 240 | 245 | 220 | 215
 | Basal Length | 59 | 83 | 75 | 82 | 74 | 80
 | Basal Thickness | 46 | 40 | 24 | 23 | 38 | 28
 | Middle Length | 56 | 54 | 51 | 54 | 34 | 32
 | Tip Thickness | 10 | 12 | 12 | 10 | 10 | 15
 | Tip Length | 101 | 106 | 112 | 120 | 118 | 112
 | [NAME]
 | Maximum Length | 127 | 114 | 116 | ??? | 92 | 96
 | Maximum Length (Bonaparte et al., 1990) | 128 | 122 | 120 | 136 | ??? | ???
 | Width Anterior | 140 | 143 | 121 | ??? | 91 | 98
 | Width Anterior ([NAME], 1990) | 140 | 144 | ??? | 104 | ??? | ???
 | Height Anterior | 120 | 115 | 118 | ??? | 103 | 100
 | Height Anterior (Bonaparte et al., 1990) | 126 | 118 | 120 | 117 | ??? | ???
 | Width Posterior | 127 | 134 | 87 | 82 | 93.2 | 104
 | Height Posterior | 110 | 105 | 116 | 100 | 79 | 103
 | Height Middle | 67 | 68 | 72 | 79 | 63 | 69
 | [NAME] | 88 | 78 | 65 | 53 | 64 | 69
 | Post Zygapophyses
 | Articulation Surface Width | 10.4 | 16.9 | ??? | 16.8 | 12.7 | 14
 | Articulation Surface Length | 17.4 | ??? | ??? | 22.2 | 26.5 | 29.4
 | Pre Zygapophyses
 | Articulation Surface Width | 19.2 | 10.9 | ??? | ??? | 19.1 | 14.1
 | Articulation Surface Length | 29.8 | 29.2 | 42.2 | ??? | 36.4 | 40.9
 | Ilium | Left Side
 | Greatest Length | 950
 | Greatest Length (Bonaparte et al., 1990) | 970
 | [NAME] | 230
 | [NAME] | 350
 | [NAME] | 77
 | [NAME] | 103
Spreadsheet: 849938d1700299562-change-empty-values-in-whole-workbook-in-specific-columns-book1
Sheet: Sheet1

Raw | Raw | Raw | Raw
Raw | Raw | Raw | Raw
Raw | ee | Raw | Raw
aa | Raw | Raw | Raw
Raw | Raw | vvv | Raw
Raw | Raw | Raw | Raw
Raw | Raw | Raw | Raw
Raw | Raw | Raw | Raw
Raw | Raw | Raw | Raw
Raw | Raw | Raw | Raw
Raw | Raw | Raw | Raw
Raw | Raw | Raw | Raw
Spreadsheet: 848600d1699297875-need-help-writing-formula-that-combines-data-excel-question-11-6-23
Sheet: Sheet1

Name | Sales Targets Hit | All Sales Targets Hits
[NAME] | Target A
Emma | Target A
[NAME] | Target A
Olivia | Target A
[NAME] | Target A
Ava | Target A
[NAME] | Target A
[NAME]
Emma | Target B
[NAME] | Target B
Olivia | Target B
[NAME] | Target B
Ava
[NAME] | Target B
[NAME] | Target C
Emma | Target C
[NAME]
Olivia | Target C
[NAME] | Target C
Ava | Target C
[NAME] | Target C
Spreadsheet: 466146d1466021333-using-drop-down-list-in-excel-2010-recipes-1-
Sheet: Recipes

Meal | Recipe Name | Ingredient | Brand | Amount | Calories | Fat | Sat. Fat | Cholesterol | Sodium | Carbs | Fiber | Sugar | Protein
Snack | [NAME] | [NAME]
Snack | [NAME] | Sugar Free Instant Vanilla Pudding
Snack | [NAME] | Cinnamon
Snack | [NAME] | Vanilla Extract
Snack | [NAME] | Butter Flavor Extract
Snack | [NAME] | Water
Snack | [NAME] | Ice
Snack | [NAME] | Total
Spreadsheet: 216009d1361557075-lookup-unique-id-then-count-values-in-different-column-pt-chore-list
Sheet: Sheet1

UID | Job Title | Job Description | Total Number of Times | Total Amount of Minutes
1 | Bathroom | Cleaning Bathroom
2 | Kitchen | Cleaning Kitchen
3 | Living Room | Cleaning Living Room
4 | Bedroom | Cleaning Bedroom
 |  |  |  |  |  | UID | (All)
 |  |  |  |  |  | Row Labels | Count of Time Spent | Sum of Time Spent2
 |  |  |  |  |  | Bathroom | 5 | 80
 |  |  |  |  |  | Bedroom | 2 | 30
 |  |  |  |  |  | Kitchen | 2 | 65
 |  |  |  |  |  | Living Room | 2 | 40
 |  |  |  |  |  | Grand Total | 11 | 215
Spreadsheet: sally_beck__33948__GlobalMgmtSum-Q101-0208
Sheet: GM-WeeklyChnge

ENRON GLOBAL MARKETS
1st QUARTER 2001 DETAIL OF GROSS MARGIN - WEEKLY CHANGE
 |  |  |  |  |  |  | Actual | Deals | Forecast | Total
Business Team |  | DPR(1) | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin
Crude & Products
Coal
Emissions
Weather
Global Risk Markets
Equity Trading
Convertible Trading
FX / Int Rate Trading
Soft Commodities Trading
Grain Trading
Meat Trading
Financial Trading
Freight
LNG
Middle East
Puerto Rico
Finance and Structuring
Office of the Chairman
Total Gross Margin Change
Other Interest Related Charges
Change in EGM Pre-tax Income
(1) Excludes Cap. Charge & Operating Costs
Spreadsheet: 836485d1689403387-iferror-vlookup-with-an-if-isna-condition-multiple-vlookup-test
Sheet: Review

VPC ID | Phase 2 Lookup | Phase 3 Lookup | Combined Phase Lookup | TMS | TMS v2 | Hans | Phuocam | Phuocam 2
vpc-123456
vpc-123457
vpc-123458
vpc-123459
vpc-123460
vpc-123461
vpc-123462
vpc-123463
vpc-123464
vpc-123465
vpc-123466
vpc-123467
vpc-123468
vpc-123469
vpc-123470
vpc-123471
vpc-123472
vpc-123473
vpc-123474
Spreadsheet: 38149a33-d4ea-4d46-9725-867e230caefa
Sheet: Sheet1

Table 1.1:  Regulation Status of Provinces and Territories | Unnamed: 1
Regulated Provinces | First Year of Regulation
N.S. | 2004
N.B. | 1992
Que. | 1973
[NAME]. | 1994
Man. | 2007
Sask. | 1996
Alta. | 2002
Unregulated Provinces and Territories
N.L.
P.E.I.
B.C.
Y.T.
N.W.T.
Nun.
Spreadsheet: dana_davis__4508__1 Central Records Form
Sheet: ZOO69692V

ENA |  |  |  |  |  |  |  | Page | of
 |  |  | RECORDS TRANSFER LIST |  |  |  |  | 1 | 1
[NAME] Number |  |  | R.C. Number |  | Company Number | Destination Date |  | Transfer Number
 | 404 |  | 0771 |  | 413
Company |  |  |  |  | Department |  |  | Section
ENRON CORP |  |  |  |  | Merchant Finance
Retention |  | [NAME] by Filing Arrangement and |  |  |  | [NAME] |  |  | Record
Schedule |  | Record Series Range, eg. 1-5, A-H, etc. |  |  |  |  |  | Container | Center Only
Item Number |  | (Title Same as Used in [NAME]) |  |  |  | From | To | Number | Location #
20272 |  | Journal Vouchers |  |  |  |  |  | Z0069692
 |  | Co. # 002
 |  | 002-025-13 |  |  |  | 1997-01-01 00:00:00 | 1997-12-01 00:00:00
 |  | 002-025-11 |  |  |  | 1997-01-01 00:00:00 | 1997-03-01 00:00:00
 |  | 002-025-11 |  |  |  | 1997-06-01 00:00:00 | 1997-07-01 00:00:00
 |  | 002-025-11 |  |  |  | 1997-09-01 00:00:00 | 1997-12-01 00:00:00
 |  | 002-025-03 |  |  |  | 1997-09-01 00:00:00
 |  | Co. # 003
 |  | 003-013-21 |  |  |  | 1997-01-01 00:00:00 | 1997-12-01 00:00:00
 |  | 003-014-22 |  |  |  | 1997-01-01 00:00:00 | 1997-12-01 00:00:00
 |  | 003-025-11 |  |  |  | 1997-05-01 00:00:00 | 1997-06-01 00:00:00
 |  | 003-025-11 |  |  |  | 1997-08-01 00:00:00
 |  | 003-025-13 |  |  |  | 1997-01-01 00:00:00 | 1997-12-01 00:00:00
 |  | 003-025-03 |  |  |  | 1997-09-01 00:00:00
Prepared By |  |  |  | Date | Building/Room/City
[NAME] |  |  |  |  | ENRON CORP./EB 2448a/HOUSTON
Department Head |  |  |  | Date | Computer Input By |  |  |  | Date
Hope Vargas
Checked and Received by |  |  |  | Date | Verified by |  |  |  | Date
Spreadsheet: joe_parks__14601__POSTIONTRAX_OCT
Sheet: hsc_aug

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  | 3 DAY ROLL
 |  |  |  |  |  |  |  |  |  |  | 15.5 | 3.445
 |  |  |  |  |  |  |  |  |  |  | 22.5 | 3.385
 |  |  |  |  |  |  |  |  |  |  | 46.5 | 3.35
 |  |  | ROLL VALUE
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 0106eeea-0b67-4a72-84ac-22520e8fd084
Sheet: Master mix data

Master mix
 | # of samples
 | N + 1ul
 | 1 | 10 |  |  | [DNA] = VDNA/Vcuvette x 50 x A260
Polymerase | 25 | 250
Primer F | 1 | 25 |  | Example: | [DNA] = 20/2000 x 50 x 0.1
Primer R | 1 | 25 |  |  | =1/100 x 50 x 0.1
Water | 22 | 220 |  |  | =0.5 x 0.1
Template | 1 |  |  |  | =0.05 ug/ul |  |  |  | CONVERSION WEBSITE
TOTAL |  |  |  |  | =50 ng/ul |  |  |  | http://www.endmemo.com/sconvert/ug_ulng_ul.php
*Vortex master mix
Spreadsheet: 854022d1703978733-calculating-annual-days-of-business-wrkday-
Sheet: Sheet1

 |  | 2024
 | HOLIDAY | DAY |  | Reflected |  | 2024-04-01 00:00:00 | 2024-06-22 00:00:00 |  |  | 2024-06-23 00:00:00 | 2024-08-31 00:00:00 |  |  | 2024-09-01 00:00:00 | 2025-01-25 00:00:00 |  |  | 2025-01-26 00:00:00 | 2025-03-31 00:00:00
 | Memorial Day |  |  | SUN |  | SUN | WEEK | SAT |  | SUN | WEEK | SAT |  | SUN | WEEK | SAT |  | SUN | WEEK | SAT
 | Juneteenth |  |  | WEEK
 | Fourth of July |  |  | SUN |  | 12 | 59 | 12 |  | 11 | 49 | 10 |  | 26 | 98 | 23 |  | 10 | 45 | 10
 | Labor Day |  |  | SUN
 | Columbus Day |  |  | SAT
 | Election Day |  |  | WEEK
 | Veteran's Day |  |  | SAT
 | Thanksgiving |  |  | SUN
 | Christmas |  |  | SUN
 | New Year's Day |  |  | SUN
 | MLK Day |  |  | SUN
 | Presidents Day |  |  | SAT
 | Christmas Eve
 | New Year's Eve
Spreadsheet: 100632d1298938288-counta-workshop-participants
Sheet: Sheet1

Country | Name | Position
Australia | Dr. [NAME] | Asia Pacific Civil Military Center of Excellence
Bangladesh
Brunei
Cambodia
Canada
Chile
China
France
India
Indonesia
Japan
Korea
Malaysia
Mexico
Brunei
New Zealand | Capt [NAME]
 | Cdr Shane Arndell
[NAME] | [NAME]
 | [NAME]
Peru
Philippines
Russia
Singapore
Tonga
Thailand
Vietnam
USA | Mr. [NAME]
 | Mr. [NAME]
 | [NAME]
 | LCDR Tommy Price
 | [NAME]
 | LT [NAME]
 | [NAME]
 | Mr. [NAME]
 | [NAME] | [NAME]
 | Major [NAME] | PACOM
 | CAPT Philip Gwaltney | Chaplain