tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 859334d1707750732-move-data-on-a-specific-date-example-sheet
Sheet: EXAMPLE sheet

 | EXAMPLE SHEET
 | Week | No of | Total | GROSS | GROSS | Carried | Tickets | Seat | Average | % of | Reserved | Sales and | % of | Venue | Target | % of | Movement | Previous | Number | Sales required
 | Commencing | Perfs | Seat | Capacity | Movement | Forward | sold | Movement | price per | capacity | Tickets | Reserved | capacity | Target | Cash | Target | on | Figures | of weeks | per week
 |  |  | Capacity |  |  |  |  |  | seat | (sales) |  | Combined | (tx sold) |  |  | Cash | [NAME] |  | left | for target
1a | Mon 27 Jun | 16 | 31040 | 1255568 |  |  |  |  |  |  |  |  |  | n/a | 1100000 |  |  | 474098.75
 | to
 | 2022-07-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1  week 29 Aug Return: £432925.78 x 1 week 31 Jul
1b | 2022-07-19 00:00:00 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0
 | to
 | 2022-08-28 00:00:00
2a | 2022-09-06 00:00:00 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0
 | to
 | 2022-09-17 00:00:00
2b | 2022-09-20 00:00:00 | 16 | 30495 | 1348744.34 |  |  |  |  |  |  |  |  |  | n/a | 1100000 |  |  | 637720
 | to
 | 2022-10-02 00:00:00 |  |  | Converted into sterling 26 Sep |  |  |  |  |  |  |  |  |  |  |  |  |  | x 1 week 15 Nov Return: £171,222.50 x 1 week 29 Aug
3a | 2022-10-04 00:00:00 | 15 | 27615 | 1109187.88 |  |  |  |  |  |  |  |  |  | n/a | 1000000 |  |  | 330758.25
 | to
 | 2022-10-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]. x 1 week 12 Sep
3b | 2022-10-17 00:00:00 | 16 | 14592 | 524808 |  |  |  |  |  |  |  |  |  | n/a | 420000 |  |  | 416618
 | to
 | 2022-10-29 00:00:00 |  |  |  | net | net |  |  |  |  |  |  |  |  |  |  |  | x 2 weeks 1 Aug
4a | 2022-10-31 00:00:00 | 8 | 14153 | 508999 |  |  |  |  |  |  |  |  |  | n/a | 450000 |  |  | 923832
 | to
 | 2022-11-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x 2 weeks 17 Apr
Spreadsheet: andy_zipper__180__DYNEGY-ICE VOL Apr30
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  | ENRON PERCENTAGE: |  |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
ICE CRUDE PRODUCTS VOLUME: |  | ENRON PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Transactions | Volume |  | Trader | Product | Qty Units | Transactions | Volume
Mckay, B | NG Fin BS, LD1 for IF | MMBtus | 1 | 1510000 |  | Carson , M | Firm-LD Peak | MWhs | 7 | 12000
Pimenov, V | NG [NAME], ID, GDD | MMBtus | 3 | 20000 |  | Dorland , C | Firm-LD Peak | MWhs | 7 | 39200
White , B | Crude | bbl | 1 | 120000 |  | [NAME], R | Firm-LD Peak | MWhs | 6 | 168800
Grand Total |  |  | 5 | 1650000 |  | Grand Total |  |  | 20 | 220000
Spreadsheet: 160977d1339349455-vlookup-search-mm-yy-excl-day-return-value-example
Sheet: Xrates

Average monthly BID rates @ +/- 0%
www.oanda.com/currency/historical-rates/
End Date | USD/EUR | EUR / USD
2010-01-31 00:00:00 | 0.7002
2010-02-28 00:00:00 | 0.7308
2010-03-31 00:00:00 | 0.7363
2010-04-30 00:00:00 | 0.7438
2010-05-31 00:00:00 | 0.7926
2010-06-30 00:00:00 | 0.8186
2010-07-31 00:00:00 | 0.7839
2010-08-31 00:00:00 | 0.7744
2010-09-30 00:00:00 | 0.7676
2010-10-31 00:00:00 | 0.7196
2010-11-30 00:00:00 | 0.7303
2010-12-31 00:00:00 | 0.7566
2011-01-31 00:00:00 | 0.7489
2011-02-28 00:00:00 | 0.7327
2011-03-31 00:00:00 | 0.7141
2011-04-30 00:00:00 | 0.6926
2011-05-31 00:00:00 | 0.6973
2011-06-30 00:00:00 | 0.6952
2011-07-31 00:00:00 | 0.6989
2011-08-31 00:00:00 | 0.697
2011-09-30 00:00:00 | 0.7245
2011-10-31 00:00:00 | 0.73
2011-11-30 00:00:00 | 0.736
2011-12-31 00:00:00 | 0.7584
2012-01-31 00:00:00 | 0.7755
2012-02-29 00:00:00 | 0.7563
2012-03-31 00:00:00 | 0.7567
2012-04-30 00:00:00 | 0.7592
2012-05-31 00:00:00 | 0.7789
Period Average | 0.7219
Period Low | 0.6336
Period High | 0.8186
Spreadsheet: 64125d1264993093-excel-2007-how-do-i-round-to-a-specific-fraction-specs
Sheet: SPECS

 | METRIC (SIZES 0 - 6 AND 20-24 ASSUMED BASED ON DIFFERENCE CALCULATION) |  |  |  |  |  |  |  |  |  |  |  |  |  | IMPERIAL (SIZES 0 - 6 ASSUMED BASED ON DIFFERENCE CALCULATION) |  |  |  |  |  |  |  |  |  |  |  |  |  | CONVERSION TO X/32
REF | 0 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | X01 | 0 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | X01 | 0 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24
H01 |  |  |  |  | 80
H02 |  |  |  |  | 60
H03 |  |  |  |  | 86
H04 |  |  |  |  | 80
H05 |  |  |  |  | 34
H06 |  |  |  |  | 31.5
H07 |  |  |  |  | 12.4
H08 |  |  |  |  | 16.8
H09 |  |  |  |  | 35.5
H10 |  |  |  |  | 74
H11 |  |  |  |  | 67
H12 |  |  |  |  | 26
[NAME] |  |  |  |  | 22.2
H14 |  |  |  |  | 15
H15 |  |  |  |  | 48
H16 |  |  |  |  | 32.2
H17 |  |  |  |  | 21.8
Spreadsheet: 002ff8f7-34f1-4f75-ab90-dc7586af3484
Sheet: UW-Other

[NAME] |  |  |  |  |  | UW-Other
Insurance Company: | Insert Company Name
Effective Date: | MM/DD/YYYY
Actual SC Direct | Year | % of Premium | Year | % of Premium | Year | % of Premium
Earned Premium
Incurred Losses
Incurred LAE
Incurred U/W Expenses
U/W Results
Actual SC Net of Reinsurance | Year | % of Premium | Year | % of Premium | Year | % of Premium
Earned Premium
Incurred Losses
Incurred LAE
Incurred U/W Expenses
U/W Results
Insurer Notes:
Notes:
1.  Use South Carolina calendar year data
2.  Provide latest three years of data
Spreadsheet: 97043d1296243588-conditional-formatting-example
Sheet: Sheet1

Animal | Live | Compare |  | Compare
Cow | Farm | Horse | Farm | Chicken | Farm | *cells D4 and D5, and cells F3 and F5 should be left blank
Chicken | Farm | Cow | Farm | Goldfish |  | *I'm not sure if I need a macro, vlook up or conditional formatting.
Dolphin | Ocean | Dog |  | Dolphin | Ocean
Monkey | Jungle | Cat |  | Hamster
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 13d

 | Swap Dealers/MSPs5 |  |  | Others
Product1 | HY6 | IG | Other | HY | IG | Other
Index Tranche | 70136 | 749139 | 705834 | 17024 | 76270 | 108516
Index | 878147 | 4058375 | 5973213 | 366336 | 1329350 | 1723861
Asia | 0 | 0 | 183807 | 0 | 0 | 49567
Europe | 0 | 0 | 5215208 | 0 | 0 | 1563912
North America | 878147 | 4058375 | 156876 | 366336 | 1329350 | 45246
Other | 0 | 0 | 417322 | 0 | 0 | 65136
OTHER* | 0 | 0 | 522748 | 0 | 0 | 281437
TOTAL | 948283 | 4807514 | 7201795 | 383360 | 1405620 | 2113814
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 145327ea-844d-4bbb-a30f-6a3aaac82676
Sheet: Sheet1

[NAME] (5-) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  | 42
Spreadsheet: 195118d1353425417-text-help-maintenance-report-x4l
Sheet: X4L - Doncaster

[NAME]
Product | Issue | Part Req | Part Price | Status | Del Date | Fitting Date
Matrix U1x | Resistance too high | Generator | 93.17 | On Order | Uk [NAME]
 |  | Lower Control Board | 144.46 | On Order | Uk [NAME]
 |  | Total
Spreadsheet: 237511d1369235182-when-i-filter-a-column-my-hyperlinks-go-to-the-wrong-location-sample_hyperlinked_spreadsheet_5_22_2013
Sheet: Monopoly

Customer Number | Customer Name | Year Purchased | Version | Number of Times Played
AA1003 | Christian Bale | 2000 | 3 | 8
AA1004 | [NAME] | 2005 | 4 | 1006
AB1065 | Sandra Bullock | 1999 | 2 | 29
AB1089 | [NAME] | 2012 | 6 | 15
Spreadsheet: 730040d1619516930-excel-keeps-calculating-no-idea-why-production-planning-excel-issue
Sheet: OVERVIEW

Loads per week
% Load |  | wk01 | wk02 | wk03 | wk04 | wk05 | wk06 | wk07 | wk08 | wk09 | wk10 | wk11 | wk12 | wk13 | wk14 | [NAME] | wk16 | wk17 | wk18 | wk19 | wk20 | wk21 | wk22 | wk23 | wk24 | wk25 | wk26
 | S2
 | S3
% Load |  | wk27 | wk28 | wk29 | wk30 | wk31 | wk32 | wk33 | wk34 | [NAME] | wk36 | wk37 | wk38 | wk39 | wk40 | wk41 | wk42 | wk43 | [NAME] | wk45 | wk46 | wk47 | wk48 | wk49 | wk50 | wk51 | wk52
 | S2
 | S3
Productivity per week
% Productivity |  | wk01 | wk02 | wk03 | wk04 | wk05 | wk06 | wk07 | wk08 | wk09 | wk10 | wk11 | wk12 | wk13 | wk14 | [NAME] | wk16 | wk17 | wk18 | wk19 | wk20 | wk21 | wk22 | wk23 | wk24 | wk25 | wk26
 | S2
 | S3
% Productivity |  | wk27 | wk28 | wk29 | wk30 | wk31 | wk32 | wk33 | wk34 | [NAME] | wk36 | wk37 | wk38 | wk39 | wk40 | wk41 | wk42 | wk43 | [NAME] | wk45 | wk46 | wk47 | wk48 | wk49 | wk50 | wk51 | wk52
 | S2
 | S3
Spreadsheet: 192973d1352666086-how-to-do-two-variable-data-tables-exploring_e06_grader_eoc
Sheet: Budget

[NAME]'s [NAME] |  |  |  | One-Variable Data Table: Attendees
 |  |  |  | # Attend
Input Section |  |  |  | 300 |  | 40797.5 | -5605
No. of Attendees | 400 |  |  |  | 36972 | 41456 | -4484
% Attendees Using Valet | 0.5 |  |  |  | 38751.5 | 42114.5 | -3363
Cost per Chair Setup | 2 |  |  |  | 40531 | 42773 | -2242
[NAME] per Car | 19.95 |  |  |  | 42310.5 | 43431.5 | -1121
Caterer's Meal Cost per Person | 20.95 |  |  |  | 44090 | 44090 | 0
Ticket Price per Person | 88.975 |  |  |  | 45869.5 | 44748.5 | 1121
 |  |  |  |  | 47649 | 45407 | 2242
Limitations |  |  |  |  | 49428.5 | 46065.5 | 3363
[NAME] | 500 |  |  |  | 51208 | 46724 | 4484
Maximum Parking Stalls | 240 |  |  |  | 52987.5 | 47382.5 | 5605
Minimum Ticket Price | 50
Maximum Ticket Price | 100
 |  |  |  | Two-Variable Data Table: Attendees and Price Per Ticket
Income |  |  |  |  | 70 | 80 | 90 | 100
Student Club Contributions | 8500 |  |  | 300 |  | -8297.5 | -5297.5 | -2297.5
Ticket Revenue |  |  |  | 320 | -10556 | -7356 | -4156 | -956
Total Income |  |  |  | 340 | -9814.5 | -6414.5 | -3014.5 | 385.5
 |  |  |  | 360 | -9073 | -5473 | -1873 | 1727
Expenses |  |  |  | 380 | -8331.5 | -4531.5 | -731.5 | 3068.5
Advertising | 3345 |  |  | 400 | -7590 | -3590 | 410 | 4410
[NAME] | 12500 |  |  | 420 | -6848.5 | -2648.5 | 1551.5 | 5751.5
Chairs/Table Setup |  |  |  | 440 | -6107 | -1707 | 2693 | 7093
Valet Parking |  |  |  | 460 | -5365.5 | -765.5 | 3834.5 | 8434.5
Decorations | 4575 |  |  | 480 | -4624 | 176 | 4976 | 9776
DJ Cost | 3000 |  |  | 500 | -3882.5 | 1117.5 | 6117.5 | 11117.5
Cleanup Costs | 2500
Meal Cost
Contingency | 5000
Total Expenses
Balance
Spreadsheet: john_griffith__15895__11_13_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 21.5 | 70 | 85 | 77.9 | 94.6 | 1.17 | 2001-11-13 10:17:00
 | CL F2 | 22 | 267 | 277 | 52.4 | 54.3 | 0.74 | 2001-11-13 10:17:00
 | CL G2 | 22 | 365 | 385 | 50.1 | 52.8 | 0.71 | 2001-11-13 10:17:00
 | CL H2 | 22 | 435 | 445 | 49.7 | 50.9 | 0.7 | 2001-11-13 10:17:00
 | CL J2 | 22 | 475 | 490 | 47.6 | 49.1 | 0.67 | 2001-11-13 10:17:00
 | CL K2 | 22 | 505 | 525 | 45.1 | 46.9 | 0.64 | 2001-11-13 10:17:00
 | CL M2 | 22 | 535 | 550 | 44 | 45.3 | 0.62 | 2001-11-13 10:17:00
 | CL N2 | 21.5 | 550 | 575 | 42.9 | 44.9 | 0.59 | 2001-11-13 10:17:00
 | CL Q2 | 21.5 | 552 | 578 | 40.5 | 42.4 | 0.56 | 2001-11-13 10:17:00
 | CL U2 | 21.5 | 555 | 580 | 38.7 | 40.5 | 0.54 | 2001-11-13 10:17:00
 | [NAME] | 21.5 | 558 | 580 | 36.9 | 38.4 | 0.51 | 2001-11-13 10:17:00
 | CL X2 | 21.5 | 560 | 580 | 35.5 | 36.8 | 0.49 | 2001-11-13 10:17:00
 | [NAME] | 21.5 | 565 | 590 | 34.6 | 36.1 | 0.48 | 2001-11-13 10:17:00
 | CL M3 | 21.5 | 560 | 580 | 28.8 | 29.8 | 0.4 | 2001-11-13 10:17:00
 | CL Z3 | 21.5 | 560 | 580 | 25.5 | 26.5 | 0.35 | 2001-11-13 10:17:00
Spreadsheet: 724636d1616266195-randbetween-without-repeat-in-column-randbetween-2-
Sheet: Sheet1

betweeb 1,6 | between 7,17 | between 18,27 | 1,27 not repeated ?? | ROW |  | Exclusions |  | Numbers | Row 1 | Row 2 | Row 3 | Row 4 | Row 5 | Row 6 | Row 7 | Row 8 | Row 9 | Row 10 | Row 11 | Row 12 | Row 13 | Row 14 | Row 15 | Row 16 | Row 17 | Row 18 | Row 19 | Row 20
 |  |  |  | Row 1 |  | 10 |  | 1
 |  |  |  | Row 2 |  |  |  | 2
 |  |  |  | Row 3 |  |  |  | 3
 |  |  |  | Row 4 |  |  |  | 4
 |  |  |  | Row 5 |  |  |  | 5
 |  |  |  | Row 6 |  |  |  | 6
 |  |  |  | Row 7 |  |  |  | 7
 |  |  |  | Row 8 |  |  |  | 8
 |  |  |  | Row 9 |  |  |  | 9
 |  |  |  | Row 10 |  |  |  | 10
 |  |  |  | Row 11 |  |  |  | 11
 |  |  |  | Row 12 |  |  |  | 12
 |  |  |  | Row 13 |  |  |  | 13
 |  |  |  | Row 14 |  |  |  | 14
 |  |  |  | Row 15 |  |  |  | 15
 |  |  |  | Row 16 |  |  |  | 16
 |  |  |  | Row 17 |  |  |  | 17
 |  |  |  | Row 18 |  |  |  | 18
 |  |  |  | Row 19 |  |  |  | 19
 |  |  |  | Row 20 |  |  |  | 20
 |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  | 27
Spreadsheet: 273351d1382688208-dynamic-matching-cell-in-table-and-returning-column-example
Sheet: 20131021

 | BIG | LARGE | TINY | CLOTHES | FROGS | BEAR | ICE | CREAM | TIE | ST | LT | HH | OP
 | 12486107251.5 | 6154300536.5 | 6331806715 | 1281837318 | 2016178719.5 | 668323984 | 154100257 | 2468979081 | 68624584 | 136464038 | 11784193 | 5663482731 | 16332346
A | 2259057820 | 567394862 | 1691662958 | 91168844 | 95233506 | 0 | 0 | 374619329 | 2967057 | 3318285 | 87841 | 1691662958 | 0
B | 2086135632 | 262345984 | 1823789648 | 0 | 163570515 | 168877098 | 25180870 | 61048868 | 2126031 | 9679842 | 739858 | 1654912550 | 0
C | 1803764811 | 945049293 | 858715518 | 112672265 | 269216440 | 25433520 | 14917958 | 533924673 | 7633517 | 6279448 | 404992 | 833281998 | 0
E | 1118508294.5 | 881482879.5 | 237025415 | 345952976 | 461775582.5 | 95622346 | 15536935 | 37016745 | 3087231 | 1295955 | 491834 | 141403069 | 16325621
D | 1094397545 | 469331407 | 625066138 | 247658310 | 98365518 | 15999331 | 3612600 | 117472209 | 1594285 | 327893 | 300592 | 609066807 | 0
F | 909242134 | 486705227 | 422536907 | 61526362 | 271479245 | 320494718 | 20008157 | 109295964 | 21524426 | 2160287 | 710786 | 102042189 | 0
H | 801163788 | 198982357 | 602181431 | 10628473 | 117313096 | 0 | 8740419 | 51202779 | 6808318 | 2401378 | 1887894 | 602181431 | 0
G | 719266722 | 701005825 | 18260897 | 228136681 | 164112921 | 0 | 24283443 | 273232362 | 3898163 | 6596635 | 738895 | 18260897 | 6725
Spreadsheet: jonathan_mckay__16902__EnronDirect Deal Sheet-Area Managers
Sheet: West Hillhurst

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | West Hillhurst Community Association |  |  |  | Deal Date: | 2001-05-30 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: | Buy |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 1102 | 0
 | February | 1030 | 0
 | March | 894 | 0
 | April | 770 | 0
 | May | 306 | 0
 | June | 209 | 0
 | July | 105 | 0
 | August | 74 | 0
 | September | 337 | 0
 | October | 473 | 0
 | November | 862 | 0
 | December | 1040 | 0
 | TOTAL:
Spreadsheet: 843646d1695423817-issues-with-combined-line-stacked-area-charts-mrshorty-linescatterareacombochart
Sheet: original

1
310
 | line chart data |  |  | stacked area data
 | normal | new |  | normal2 | above | below
16 | 165.57 | 222.5
17 | 163.71 | 226.1
18 | 165.86 | 225.4
19 | 166.07 | 130.4
20 | 165.1 | 134.4
21 | 163.41 | 140.8
Spreadsheet: 41971d1240504243-pulling-non-zero-data-from-a-large-table-array-sample
Sheet: Sheet1

 |  |  | Total Resources | Complexity | Solid Petrochem Fuel | Ferrous Metal | Smelted Non-Ferrous Metal | Smelted Copper | Mythra Copper | Beyrllius Copper | Smelted Aluminum | Agrinium Aluminum | Smelted Ferrous Metal | Smelted Steel | Quadranium Steel | Unknown Inert Gas | Unknown Reactive Gas | Low Quality Gemstone | Bospridium Amorphous Gemstone | Chemical Compound | Lubricating Oil |  | Corellia Fiberplast | Igneous Ore
1 | Small Structure Storage Module | 1 | 170 | 5 |  | 80 |  |  |  |  |  | 20 |  | 50 |  | 20
2 | Structural Module | 2 | 280 | 8 |  | 50 |  |  |  |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  | 200
3 | Structure Storage Module | 3 | 280 | 5 |  | 200 |  |  |  | 20 |  |  |  | 50 |  |  |  |  |  |  |  | 10
4 | Turbo Fluidic Drilling Pump | 4 | 350 | 5 |  |  |  |  |  |  |  | 100 |  |  |  | 50 |  |  |  | 200
5 | Wall Module | 5 | 500 | 15 |  | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200
6 | Adv Turbo Fluidic Pump | 6 | 2170 | 17 |  | 630 |  |  | 50 |  |  |  |  | 360 |  |  |  | 20 |  | 1080 |  | 30
7 | Adv Ore Mining Unit | 7 | 1785 | 12 |  | 450 |  |  |  |  |  |  |  | 1110 |  | 225
8 | Adv Heavy Harvesting Mechanism | 8 | 2025 | 16 |  | 150 |  |  |  |  | 15 |  |  | 750 |  |  |  |  |  | 1110
 | Choose "Wall Module"
 | 5
 |  |  | Result should be a list starting below… |  |  |  |  |  |  |  |  |  |  | … and should look like this…
 |  |  | Wall Module |  |  |  |  |  |  |  |  |  |  | Wall Module
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Resource |  |  |  |  | 500
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Ferrous Metal |  |  |  |  | 300
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Igneous Ore |  |  |  |  | 200
 |  |  | What formula would I use? Keep in mind that the top data part and the bottom part here are on different pages.
Spreadsheet: 0f4a4562-b5cb-4a99-8ca6-a2e914027d26
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Not Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2014
 |  | Data Extracted on: March 11, 2014 (10:26 am)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 237399
2004 | 223675 | 233241 | 232983 | 246201
2005 | 236033 | 244136 | 244711 | 255856
2006 | 245182 | 254735 | 255745 | 271401
2007 | 257973 | 265739 | 267325 | 281304
2008 | 270217 | 277643 | 277604 | 282885
2009 | 261948 | 266881 | 265508 | 280622
2010 | 267483 | 274697 | 276055 | 291990
2011 | 277885 | 289552 | 288862 | 304550
2012 | 290131 | 297462 | 296119 | 320584
2013 | 302663 | 309834 | 310513 | X
2014 | X | X | X | X
Spreadsheet: 867407d1714235362-weekend-rota-planning-generate-values-based-on-criteria-date-shift-pattern-weekend-rota-planing-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apple | [NAME] | Pear | Grape | Plum
 |  |  |  | 2023-04-26 00:00:00 |  |  |  |  |  |  |  |  |  | 2024-04-26 00:00:00 | 1 | 0 | 0 | 1 | 1
 |  |  | Name | FRIDAY |  | SATURDAY |  | SUNDAY |  | MONDAY |  |  |  | 2024-04-27 00:00:00 | 1 | 1 | 1 | 0 | 1
 |  |  | Apple |  | 18:00 | 06:00 | 18:00 | 06:00 | 18:00 |  |  |  |  | 2024-04-28 00:00:00 | 1 | 0 | 1 | 0 | 1
 |  |  | [NAME] |  |  | 06:00 | 18:00 |  |  | 06:00 | 18:00 |  |  | 2024-04-29 00:00:00 | 0 | 1 | 0 | 0 | 1
 |  |  | Pear |  |  | 06:00 | 18:00 | 06:00 | 18:00
 |  |  | Grape | 06:00 | 18:00
 |  |  | Plum | 06:00 | 18:00 | 06:00 | 18:00 | 06:00 | 18:00 | 06:00 | 18:00
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: New 400D

New 400D |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 47667d1246835378-allocate-days-into-periods-in-which-they-fall-sample-2
Sheet: Sheet1

 |  | Courses start and finish at random times. How can the days be allocated into the periods in which they fall?
 |  |  | Start | Finish | 2009-07-31 00:00:00 | 2009-08-31 00:00:00 | 2009-09-30 00:00:00 | 2009-10-31 00:00:00 | 2009-11-30 00:00:00 | 2009-12-31 00:00:00
 |  | Course 1 | 2009-07-03 00:00:00 | 2009-07-15 00:00:00 | 12
 |  | Course 2 | 2009-07-15 00:00:00 | 2009-08-14 00:00:00 | 15 | 15
 |  | Course 3 | 2009-07-03 00:00:00 | 2009-10-21 00:00:00
 |  | Course 4 | 2009-07-21 00:00:00 | 2009-10-18 00:00:00
 |  | Course 5 | 2009-07-31 00:00:00 | 2009-11-15 00:00:00
 |  | Course 6 | 2009-08-30 00:00:00 | 2009-12-24 00:00:00
Spreadsheet: 749458d1632817661-help-with-index-and-match-that-returns-value-based-on-multiple-criteria-test_xcel_sheet2
Sheet: TASK_COMPLETION_LIST

ID | TASK1 | TASK2 | TASK3 | TASK4 | TASK5 | TASK6 | TASK7 | TASK8 | TASK9 | TASK10 | TASK11 | TASK12 | TASK13 | TASK14
1841135
1573323
1829256
112524
810973
1383693
1191651
388937
1892153
1043714
1234070
1424764
898757
Spreadsheet: 794614d1662140127-how-to-use-vloop-up-formula-to-retrieve-the-values-from-different-work-sheet-test
Sheet: Attendance

Sr. # | NAME | 2022-09-01 00:00:00 | 2022-09-02 00:00:00 | 2022-09-03 00:00:00 | 2022-09-04 00:00:00 | 2022-09-05 00:00:00 | 2022-09-06 00:00:00 | 2022-09-07 00:00:00 | 2022-09-08 00:00:00 | 2022-09-09 00:00:00 | 2022-09-10 00:00:00 | 2022-09-11 00:00:00 | ABSENT | PRESENT | HALF DAY | WEEK OFF | TOTAL DAYS | [NAME] | PER DAY | SALARY - FINAL
1 | [NAME] | P | P | W/O | W/O | P | P | P | P | P | W/O | W/O | 0 |  |  |  |  | 25000
 | [NAME] | P | P | W/O | W/O | P | P | P | P | P | W/O | W/O | 0 |  |  |  |  | 25000
 | Michelle | P | P | W/O | W/O | P | P | P | P | P | W/O | W/O | 0 |  |  |  |  | 25000
 | [NAME] | P | P | W/O | W/O | P | P | P | P | P | W/O | W/O | 0 |  |  |  |  | 25000
 | [NAME] | P | P | W/O | W/O | P | P | P | P | P | W/O | W/O | 0 |  |  |  |  | 25000
 | Asmos | P | P | W/O | W/O | P | P | P | P | P | W/O | W/O | 0 |  |  |  |  | 25000
 | Senti | HD | P | W/O | W/O | AB | HD | P | P | P | W/O | W/O | 0 |  |  |  |  | 25000
 | [NAME] | P | P | W/O | W/O | HD | P | P | P | P | W/O | W/O | 0 |  |  |  |  | 25000
 | [NAME] | HD | P | W/O | W/O | AB | HD | P | P | P | W/O | W/O | 0 |  |  |  |  | 25000
Spreadsheet: 114149d1309975524-sum-and-count-formula-request
Sheet: Sheet1

Subtotal Thru Day: |  | 6
Day: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | SUBTOTAL
Volume: | 1 | 2 | 5 | 6 | 8 | 9 | 1 | 2 | 5 | 9 | 8 | 3 | [NAME] needed
Spreadsheet: 714125d1611102573-iferror-formula-results-in-spill-sample
Sheet: Sheet2

Empl ID | Name | SSN | [NAME] | Dept
108658062 | [NAME],[NAME] | 111223333 | [EMAIL] | 29219
100769236 | Gutierrez,[NAME] | 222334444 | [EMAIL] | 22143
200007453 | Smith, [NAME] | 333445555 | [EMAIL] | 22156