tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 889644d1740537870-retrieve-info-from-a-specific-column-not-working-correctly-in-a-specific-set-of-columns-sample
Sheet: Pin Money

First Name | Last Name | My Total Pins | Pin Money |  |  |  | 50 | 20 | 10 | 5 | 1 | 0.25 | 0.1 | 0.05 | 0.01 |  | Check
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Beginning Balance |  |  |  | 193.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expenses
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reissued Check |  |  | 17.44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non-Payment |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bowling Fees
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secretary  Fee
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Awards
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High Scratch Game | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High Scratch Series | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hgh Handicap Game | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High Handicap Game | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High Average | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Most Improved | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | First Place | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Second Place | 66
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Third Place | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last Place | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sweeps
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2nd | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3rd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4th
Fees/Awards/Pin Money
 |  |  |  |  |  |  | 50 | 20 | 10 | 5 | 1 | 0.25 | 0.1 | 0.05 | 0.01 |  | Check |  | Total Expenses
Secretary
Treasurer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sub Total
High Scratch Game
High Scratch Series |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pin Money
Hgh Handicap Game
High Handicap Game |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ending Balance
High Average
Most Improved |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min Carryover- $5.00
Awards, Etc. Denominations
Costs
Pin Money Denominations
Costs
Total Denominations
Total Costs
 |  |  |  |  |  |  |  |  |  |  |  | +
Spreadsheet: 149031d1333654513-excel-2007-help-with-an-expenses-tracker-pullman-audit-trail3
Sheet: Overview

Audit Trail
Department | Number of Payments | P01 | P02 | P03 | P04 | P05 | P06 | P07 | P08 | P09 | P10 | P11 | P12 | Total for Year
Totals
Spreadsheet: 116674d1311975639-selective-columns-priors-hall
Sheet: An

Ankers. N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hole | par | stroke index | strokes | points | penalty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 881125d1729059429-distribution-of-items-based-on-actual-value-should-be-exact-excel-forum-actual-total-number-remains-
Sheet: Sheet1

 |  |  |  |  |  | Time (Hours) | Total Number of Items
 |  |  |  |  |  |  | Actual | Adjusted
 |  |  |  |  |  | 8 |  |  | <---- | we can retain the numbers here
 |  |  |  |  |  | 7 |  |  |  | or round down or round up..
 |  |  |  |  |  | 7 |  |  |  | so that the total in green is always equal to user entry value
 |  |  |  |  |  |  |  |  |  | in this example is user entry is 20
 |  |  |  |  |  |  | 20 |  |  | <--- this should also be 20
 |  |  |  |  |  |  | this will change based on user entry value | should be always equal to the total ACTUAL
 |  |  |  |  |  |  |  | meaning this should also be 20 based on the ACTUAL
Spreadsheet: kate_symes__18762__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-01 00:00:00 |  | 298.9 | 27200 | 269.54 | 7872
 | 2001-02-28 00:00:00 |  | 200.96 | 25024 | 183.83 | 13864 | 316.43 | 2298 | 258.89 | 1480
 | 2001-02-27 00:00:00 |  | 201.92 | 15424 | 178.85 | 6464 | 244.23 | 455 | 204.11 | 1255
 | 2001-02-26 00:00:00 |  | 245.45 | 11424 | 227.06 | 6928 | 198.18 | 550 | 160 | 50
 | 2001-02-25 00:00:00 |  | 240 | 800 | 210 | 0 | 173.83 | 962 | 159.04 | 584 |  | 227.06 | 20784
 | 2001-02-24 00:00:00 |  | 194.5 | 20624 | 152.04 | 7328 | 186.82 | 2727 | 184.22 | 870
 | 2001-02-23 00:00:00 |  | 194.65 | 20624 | 152.04 | 7328 | 278.92 | 300 | 186.49 | 208
 | 2001-02-22 00:00:00 |  | 253.75 | 17824 | 217.96 | 5880 | 190.34 | 576 | 143.24 | 795
 | 2001-02-21 00:00:00 |  | 291.88 | 11824 | 261.34 | 6928 | 295 | 50 | 220.57 | 485
 | 2001-02-20 00:00:00 |  | 326.7 | 22224 | 310.97 | 5328 | 275 | 78 | 222.94 | 375
 | 2001-02-19 00:00:00 |  | 326.67 | 22624 | 310.97 | 5328 | 335.35 | 174 | 259.78 | 115
 | 2001-02-18 00:00:00 |  | 325 | 800 | 310 | 0 | 275.26 | 476 | 266.22 | 555 |  | 336.69 | 11784
 | 2001-02-17 00:00:00 |  | 349.98 | 15824 | 336.58 | 3800 | 347.69 | 281 | 332.5 | 0
 | 2001-02-16 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 397.28 | 230 | 350 | 40
 | 2001-02-15 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 348.8 | 1693 | 398.23 | 784
 | 2001-02-14 00:00:00 |  | 327.05 | 15664 | 314.82 | 3928 | 479.05 | 452 | 472.12 | 165
 | 2001-02-13 00:00:00 |  | 335.68 | 13424 | 322.6 | 4728 | 386.38 | 1053 | 330 | 0
 | 2001-02-12 00:00:00 |  | 302.64 | 12624 | 279.2 | 4528 | 271.84 | 1346 | 324.32 | 544
 | 2001-02-11 00:00:00 |  | 285 | 0 | 270 | 0 | 312.37 | 316 | 326.04 | 96 |  | 278.81 | 12600
 | 2001-02-10 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 322.06 | 790 | 309.3 | 328
 | 2001-02-09 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 341.87 | 3340 | 307.19 | 1050
 | 2001-02-08 00:00:00 |  | 381.43 | 15120 | 316.79 | 3376 | 341.12 | 2521 | 320.97 | 373
 | 2001-02-07 00:00:00 |  | 274.49 | 8688 | 253.14 | 4024 | 294.97 | 2143 | 251.02 | 216
 | 2001-02-06 00:00:00 |  | 213.71 | 10784 | 195.79 | 4096 | 259.92 | 63 | 196.16 | 307
 | 2001-02-05 00:00:00 |  | 200.43 | 11824 | 196.63 | 3968 | 204.52 | 1904 | 179.61 | 727
 | 2001-02-04 00:00:00 |  | 200 | 0 | 185 | 0 | 181.95 | 1513 | 175.11 | 1100 |  | 196.25 | 10704
 | 2001-02-03 00:00:00 |  | 222.8 | 15824 | 195.9 | 7648 | 185 | 35 | 199.94 | 233
 | 2001-02-02 00:00:00 |  | 222.8 | 15824 | 195.9 | 7648 | 203.95 | 380 | 200 | 48
 | 2001-02-01 00:00:00 |  | 355.71 | 7984 | 306.05 | 3728 | 255.73 | 1202 | 198.09 | 315
 | 2001-01-31 00:00:00 |  | 409.15 | 12656 | 342.56 | 3280 | 313.68 | 3766 | 275 | 70
 | 2001-01-30 00:00:00 |  | 468.99 | 11456 | 403.48 | 2872 | 383.47 | 304 | 351 | 25
 |  |  |  |  |  | ..
Spreadsheet: 799518d1665131159-generate-list-of-names-based-on-criteria-sample
Sheet: FOLDER 2.1

FOLDER 2.1 - MASTERLIST OF PRE-SCHOOL CHILDREN
HH NO. | ADDRESS | NAME OF MOTHER | NAME OF CHILD | BELONG TO IP GROUP | GENDER | DATE OF BIRTH | DATE OF MEASUREMENT | AGE IN MONTHS | WEIGHT | HEIGHT | [NAME] | L/HFA STATUS | WFL/H STATUS
 |  |  |  |  |  |  |  |  | (KG) | (CM)
Spreadsheet: 169118d1342707100-joining-two-lists-tonyjc_846443-joining-two-lists_19jul12_01
Sheet: Sheet1

What I have
Full Part Number and Description | Used last Year |  | Part Number | Stores Number available |  | Full Part Number and Description | Used last Year
1003 trib fan card belt | 16 |  | 1000 | 3
1000 trib | 11 |  | 1001 | 2
1006 can | 60 |  | 1002 | 3
1005 trib holder | 30 |  | 1003 | 2
1001 holder | 12 |  | 1004 | 3
1002 belt | 15 |  | 1005 | 2
1004 | 18
What I'd like
Full Part Number and Description | Used last Year |  | Part Number | Stores Number available
1000 trib | 11 |  | 1000 | 3
1001 holder | 12 |  | 1001 | 2
1002 belt | 15 |  | 1002 | 3
1003 trib fan card belt | 16 |  | 1003 | 2
1004 | 18 |  | 1004 | 3
1005 trib holder | 30 |  | 1005 | 2
1006 can | 60
Spreadsheet: michelle_lokay__26556__imbalsumm0012
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 105467 |  |  | 77908 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 131083 |  |  | 45263 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 134074 | 161714 |  | 31644 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2000-11-30 00:00:00 |  |  |  | -76471
 | 2000-12-03 00:00:00
Spreadsheet: 861243d1709166428-add-up-specific-numbers-from-a-cell-sample-freight-data-with-function
Sheet: Sales Proposal Master

ID | Cargo Description | Weight (KG) | Volume (m3) | Chargeable Weight (KG CW)
1898382 | 1 PKG |  234 Kg | 0.811 m3 | 234 [NAME]252 Kg | 0.883 m3 | 252 Kg CW  | 1 PKG |  44 Kg | 0.164 m3 | 44 Kg CW
1898120 | 1 PKG |  297 Kg | 0.975 m3 | 297 Kg CW
1897910 | 1 PKG |  247 Kg | 0.6 m3 | 247 Kg CW
1895872 | 1 PKG |  238 Kg | 0.69 m3 | 238 [NAME] |  384 Kg | 1.123 m3 | 384 Kg CW
1891128 | 2 PLT |  400 Kg | 4.8 m3 | 0 Kg CW
1891528 | 1 PKG |  418 Kg | 0.509 m3 | 418 Kg CW  | 1 PKG |  799 Kg | 0.691 m3 | 799 Kg CW
1889744 | 2 PLT |  300 Kg | 3.84 m3 | 640 Kg CW
1889991 | 2 PLT |  1,300 Kg | 3.84 m3 | 0 Kg CW
1887574 | 1 PKG |  352 Kg | 1.123 m3 | 352 Kg CW  | 1 PKG |  [NAME] | 0.975 m3
1887624 | 1 PLT |  280 Kg | 2.4 m3 | 0 Kg CW
Spreadsheet: 148632d1333487232-excel-not-sorting-numbers-correctly-example
Sheet: Sheet1

Store # | Street | City | State | Zip
7 | 1 abc road | generic town | ny | 55555
9 | 2 abc road | generic town | ny | 55555
11 | 3 abc road | generic town | ny | 55555
14 | 4 abc road | generic town | ny | 55555
23 | 5 abc road | generic town | ny | 55555
24 | 6 abc road | generic town | ny | 55555
25 | 7 abc road | generic town | ny | 55555
26 | 8 abc road | generic town | ny | 55555
32 | 9 abc road | generic town | ny | 55555
34 | 10 abc road | generic town | ny | 55555
35 | 11 abc road | generic town | ny | 55555
36 | 12 abc road | generic town | ny | 55555
38 | 13 abc road | generic town | ny | 55555
41 | 14 abc road | generic town | ny | 55555
44 | 15 abc road | generic town | ny | 55555
45 | 16 abc road | generic town | ny | 55555
47 | 17 abc road | generic town | ny | 55555
48 | 18 abc road | generic town | ny | 55555
49 | 19 abc road | generic town | ny | 55555
51 | 20 abc road | generic town | ny | 55555
55 | 21 abc road | generic town | ny | 55555
59 | 22 abc road | generic town | ny | 55555
60 | 23 abc road | generic town | ny | 55555
62 | 24 abc road | generic town | ny | 55555
63 | 25 abc road | generic town | ny | 55555
64 | 26 abc road | generic town | ny | 55555
65 | 27 abc road | generic town | ny | 55555
66 | 28 abc road | generic town | ny | 55555
67 | 29 abc road | generic town | ny | 55555
68 | 30 abc road | generic town | ny | 55555
71 | 31 abc road | generic town | ny | 55555
72 | 32 abc road | generic town | ny | 55555
75 | 33 abc road | generic town | ny | 55555
76 | 34 abc road | generic town | ny | 55555
80 | 35 abc road | generic town | ny | 55555
83 | 36 abc road | generic town | ny | 55555
84 | 37 abc road | generic town | ny | 55555
85 | 38 abc road | generic town | ny | 55555
86 | 39 abc road | generic town | ny | 55555
87 | 40 abc road | generic town | ny | 55555
88 | 41 abc road | generic town | ny | 55555
91 | 42 abc road | generic town | ny | 55555
101 | 43 abc road | generic town | ny | 55555
102 | 44 abc road | generic town | ny | 55555
103 | 45 abc road | generic town | ny | 55555
106 | 46 abc road | generic town | ny | 55555
107 | 47 abc road | generic town | ny | 55555
108 | 48 abc road | generic town | ny | 55555
111 | 49 abc road | generic town | ny | 55555
113 | 50 abc road | generic town | ny | 55555
117 | 51 abc road | generic town | ny | 55555
120 | 52 abc road | generic town | ny | 55555
Spreadsheet: 718140d1613006264-if-formula-with-highlight-cell-excel-help
Sheet: Sheet1

 |  | Qty | Price 1 | Price 2 | Price 3 | Manual | Prefer formula
A | Set | 10 | 850 | 925 | 770
B | Set | 51 | 705 | 735 | 700
C | Set | 4 | 555 | 535 | 490
D | Set | 110 | 600 | 570 | 590
 | I want to have authomatic calculation from highligh color x Qty
Spreadsheet: 136938d1326894438-auto-populate-on-different-sheet-from-lowest-total-bidder-dollars-and-name-fee-tabulation-example
Sheet: Cont. #

Discipline | Company | Phase I                                        Survey     Design Development |  | Phase II                                         CD's | Phase III                                         CA | Reimbursables | TOTAL
Architectural
 | Architect | 1200 | 4000 | 14700 | 9800 | 1800 | 29700
 | Estimated Reimbursables | 100 | 200 | 750 | 750
Engineering
 | Engineer D | 0 | 0 | 0 | 0 | 0 | 0
 | Estimated Reimbursables | 0 |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Structural
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Fire Protection / Fire Alarm
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Functional Commissioning
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Civil Engineering
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Bldg. Dept. Plan Review Fees
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
GeoTech
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Skylight Energy Modeling
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Expediter & Third Party Reviewer
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Landscaping
 |  |  |  | 800 |  | 0 | 800
 | Estimated Reimbursables
 | Reimbursable Sub-total Per Phase | 100 | 200 | 750 | 750
 | SUB-TOTALS PER PHASE | 1200 | 4000 | 15500 | 9800 | 1800 | 30500
 |  |  | Additional Services NOT INCLUDED in Base Contract
SUB TOTAL | 30500
REIMBURSABLS | 1800
GRAND TOTAL | 32300
Spreadsheet: 600688d1543912771-monster-conditional-formatting-dummy-data
Sheet: All Variations

 | Sun | [NAME] | Earth | Mars | Delivered To | From
 |  |  |  |  | Custom | Sun
 |  |  |  |  | [NAME] | Sun
 |  |  |  |  | Earth | Sun
 |  |  |  |  | Mars | Sun
 |  |  |  |  | Sun | Custom
 |  |  |  |  | Sun | [NAME]
 |  |  |  |  | Sun | Earth
 |  |  |  |  | Sun | Mars
 |  |  |  |  | Custom | [NAME]
 |  |  |  |  | Sun | [NAME]
 |  |  |  |  | Earth | [NAME]
 |  |  |  |  | Mars | [NAME]
 |  |  |  |  | [NAME] | Custom
 |  |  |  |  | [NAME] | Sun
 |  |  |  |  | [NAME] | Earth
 |  |  |  |  | [NAME] | Mars
 |  |  |  |  | Custom | Earth
 |  |  |  |  | Sun | Earth
 |  |  |  |  | [NAME] | Earth
 |  |  |  |  | Mars | Earth
 |  |  |  |  | Earth | Custom
 |  |  |  |  | Earth | Sun
 |  |  |  |  | Earth | [NAME]
 |  |  |  |  | Earth | Mars
 |  |  |  |  | Custom | Mars
 |  |  |  |  | Sun | Mars
 |  |  |  |  | [NAME] | Mars
 |  |  |  |  | Earth | Mars
 |  |  |  |  | Mars | Custom
 |  |  |  |  | Mars | Sun
 |  |  |  |  | Mars | [NAME]
 |  |  |  |  | Mars | Earth
Spreadsheet: 074e8607-08ee-49ac-903c-4ab611da6ad3
Sheet: Sheet4

Andrew_id | Total Late Days Used | Cookies
agrahame | 7
ajbritto | 0
amallick | 9
areyes | 6
aycho | 0
bcforres | 1
[NAME] | 2
changshl | 2
dcampbel | 2
[NAME] | 4
dmou | 10
elliotr | 8
eob | 5
epintar | 4
fsadi | 2
jabinder | 2
jangarit | 4
jchowdha | 6
[NAME] | 6
jeremiek | 6
jgreth | 4
jkleung1 | 6
joonhyu1 | 4
[NAME] | 6
markwill | 0
mgregan | 7
[NAME] | 7
msotolon | 7
mzli | 6
[NAME] | 0
njeffrie | 5
nmellis | 11
poungpas | 6
rbenua | 14
shivaprk | 0
shreyaj | 2
[NAME] | 8
[NAME] | 8
tliao | 1
tmullins | 2
xianglin | 3
Spreadsheet: 126592d1319761143-tricky-for-me-if-statement-answer
Sheet: Sheet1

Item # | Sales Units
00-01 Cat | 50
00-02 Dog | 100
00-04 Mouse | 155
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
etc. | 0
Spreadsheet: 753025d1635187248-move-start-of-week-to-new-tab-week-example-pr1
Sheet: February

 | Week
 | 1
 |  | day | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
 | Week
 | 2 | commencing date:
 |  | day | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
 | Week
 | 3 | commencing date:
 |  | day | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
 | Week
 | 4 | commencing date:
 |  | day | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
 | Week
 | 5 | commencing date:
 |  | day | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
Spreadsheet: 01ea4593-c624-4565-b42a-4eef1febf30a
Sheet: Sheet1

 | Run in speed (m/s) | Altitude (m) | Group 1 TV (m/s) | Group 2 TV (m/s) | Group 1 pull (m) | Group 2 pull (m) |  | g | k1 | [NAME]
 | 35 | 4000 | 53 | 53 | 1067 | 1067 |  | 9.81
 | Exit seperation (s) | 5 |  | [NAME] to standard units
 | [NAME]. Sep at pull (m) |  |  | MPH | 120
 | Time between pulls (s) |  |  | [NAME] per second (m/s)
 | Vert. Sep at pull (m)
 |  |  |  | Feet | 13000
 |  |  |  | [NAME]
 | GROUP 1 |  |  | Group 2
 | Freefall time (s) |  |  | Freefall time (s)
 | Total throw(m) |  |  | Total throw(m)
 | Horizontal V (m/s) at pull height |  |  | Horizontal V (m/s) at pull height
 | Vertical V (m/s) at pull height |  |  | Vertical V (m/s) at pull height
Spreadsheet: 558230d1516978822-using-if-function-across-multiple-sheets-and-cell-sample-data
Sheet: Inventory

Computer Name | Business Unit
MICKEY5-LAP
FREDWALLS-LAP
AABLUE1
MIHILL-mac
CALLSYS-mac1
FORESTGUMP-LAP
CIAALPHA
[NAME]
WADISNEY-LAP
TBRADY-LAP
DWROCK-LAP
APBIO
Spreadsheet: 65575d1266309924-excel-2008-filtering-rows-tabela-a
Sheet: MasterList

REFERENCIA
1001
1002
1003
1004
1041
1042
1058
1102
1117
1122
1125
1177
1182
1183
1184
1203
1204
1205
1206
1208
1254
1256
1257
1258
1355
1356
1357
1358
1366
1368
60100
6028
6046
60700
61540
6262
62620
6270
6272
6280
6284
6292
62920
64710
6632
6852
68520
6853
6854
68540
6864
6878
72710
7283
73030
73330
73751
73760
73770
Spreadsheet: 760258d1640103322-average-formula-using-unconventional-format-test
Sheet: Sheet1

Year | Reading Age Difference
2016 | 1/1
2017 | 6/8 |  | 80
2018 | 1/6 |  | 18
2019 | -0/4 |  | -4
2020 | 2/8 |  | 32
2021 | 4/10 |  | 58
Average
Spreadsheet: a33799e5-df20-45a0-91de-88d676cb6ef5
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43286358 | 2014-09-23 23:27:43 | ALLIES | 0 | 1 | 6 | 580456 | JP [NAME] | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
Spreadsheet: 90708d1290473218-lookup-or-matching-test
Sheet: Sheet1

Manually input # | Name ([NAME]) | ID List | Employee Name
3935 |  | 8911 | [NAME]
8911 |  | 3943 | [NAME]
3943 |  | 2778 | [NAME]
2778 |  | 3074 | [NAME]
3943 |  | 2938 | [NAME]
3943 |  | 9999 | [NAME]
3074
So it should look like this
3935 | [NAME]
2778 | [NAME]
3935 | [NAME]
Spreadsheet: 676878d1589036134-sumif-formula-help-required-sample-1
Sheet: Sheet1

DATE WORKED | AMOUNT | MONTH NUM | MONTHLY TOTAL
2020-01-01 00:00:00 | 100 | =[@[DATED WORKED]]
2020-01-18 00:00:00 | 300 | 1
2020-01-27 00:00:00 | 50 | 1 | 450
2020-02-14 00:00:00 | 200 | 2
2020-02-14 00:00:00 | 150 | 2
2020-02-19 00:00:00 | 100 | 2
2020-02-25 00:00:00 | 50 | 2 | 500
2020-03-03 00:00:00 | 100 | 3
2020-03-06 00:00:00 | 50 | 3 | 150