tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 871213d1717602038-splitting-columns-into-multiple-2098-cctest
Sheet: CCSpend

Index | Cost Centre | Spend |  | No of Columns  (3 - 5) | 5 |  | Index | Cost Centre | Spend |  | Index | Cost Centre | Spend |  | Index | Cost Centre | Spend
1 | CC00001 | 351.6331 |  | No of Data Rows |  |  | 1
2 | CC00002 | 338.824 |  | No of Rows per Table
3 | CC00003 | 511.5401
4 | CC00004 | 563.4368
5 | CC00005 | 875.4404
6 | CC00006 | 162.3569
7 | CC00007 | 473.6586
8 | CC00008 | 877.5081
9 | CC00009 | 248.2481
10 | [NAME] | 646.3584
11 | CC00011 | 38.8488
12 | CC00012 | 388.286
13 | CC00013 | 85.766
14 | CC00014 | 357.9898
15 | CC00015 | 217.0372
16 | CC00016 | 88.3918
17 | CC00017 | 318.1832
18 | CC00018 | 164.4154
19 | CC00019 | 593.4488
20 | CC00020 | 589.1383
21 | CC00021 | 46.8553
22 | CC00022 | 418.8681
23 | CC00023 | 239.1357
24 | CC00024 | 255.5476
25 | CC00025 | 258.0712
26 | CC00026 | 288.4695
27 | CC00027 | 827.1549
28 | CC00028 | 143.4624
29 | CC00029 | 115.257
30 | CC00030 | 684.3929
31 | CC00031 | 455.8555
32 | CC00032 | 410.2513
33 | CC00033 | 259.5526
34 | CC00034 | 461.2044
35 | CC00035 | 976.168
36 | CC00036 | 639.2695
37 | CC00037 | 291.7214
38 | CC00038 | 751.4144
39 | CC00039 | 565.5922
40 | CC00040 | 669.2514
41 | CC00041 | 46.2621 |  |  |  |  | NOTE:  All of the rows above this one contain formulas  -  the tables can extend downwards as far as this row
42 | CC00042 | 52.9365
43 | CC00043 | 554.2177 |  |  |  |  | Columns H, L, P, T and X can be hidden if required
44 | CC00044 | 644.4342
45 | CC00045 | 860.7579
46 | CC00046 | 432.9573
47 | CC00047 | 890.7977
48 | CC00048 | 251.0394
49 | CC00049 | 799.409
50 | CC00050 | 353.6073
51 | CC00051 | 632.2541
52 | CC00052 | 758.3226
53 | CC00053 | 3.3761
54 | CC00054 | 496.3789
55 | CC00055 | 916.4276
56 | CC00056 | 777.1802
57 | CC00057 | 109.0961
58 | CC00058 | 805.8108
59 | CC00059 | 618.7242
60 | CC00060 | 776.6509
61 | CC00061 | 692.7494
62 | CC00062 | 515.9762
63 | CC00063 | 332.5641
64 | CC00064 | 129.0512
65 | CC00065 | 737.5604
66 | CC00066 | 724.0837
67 | CC00067 | 343.7865
68 | CC00068 | 829.5265
69 | CC00069 | 670.6268
70 | CC00070 | 463.9958
71 | CC00071 | 212.0787
72 | CC00072 | 346.2946
73 | CC00073 | 850.4067
74 | CC00074 | 333.3756
75 | CC00075 | 848.5071
76 | CC00076 | 709.5304
77 | CC00077 | 861.0136
78 | CC00078 | 569.1975
79 | CC00079 | 317.9268
80 | CC00080 | 212.1019
Spreadsheet: 121040d1315797268-read-another-sheet-nfl-football-schedule-2011-2012
Sheet: Playoff Wildcard

 | Team | 1 | 2 | 3 | 4 | OT | Total | W/L
 | Team | 1 | 2 | 3 | 4 | OT | Total | W/L
 | Team | 1 | 2 | 3 | 4 | OT | Total | W/L
 | Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Spreadsheet: eric_saibi__9845__010801R
Sheet: Meramec 02

Owner Name |  | AmerenUE
Station Name |  | Meramec Power Station
Plant ID |  | 1013387
Unit Name |  | Meramec 02
Unit ID |  | 1006126
NERC Region |  | MAIN
State |  | MO
Fuel Type |  | coal
Capacity |  | 138 MW
Start Date |  | 2000-10-16 00:00:00
End Date |  | 2001-02-03 00:00:00
Prv. Start Date |  | 2000-10-16 00:00:00
Prv. End Date |  | 2001-01-14 00:00:00
Outage ID |  | 10257
Comments |  | Boiler/Turb/Precipitator
SIC |  | 4911
Spreadsheet: john_hodge__16252__MIDWAY SUMMARY
Sheet: MATL - Lateral

Midway - Take-off and Crosscountry Pipe install
[NAME] of Materials
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Total:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *Contractor Supplied |  |  | 0
Elbow |  |  |  | Size (O.D.) | qty | unit |  | Deg |  |  | Gr |  |  | Amount | Unit |  | Total | 1445
 |  | Elbow |  | 12 | 1 | ea. |  | 90 |  |  | 42 |  |  | 340 | ea. |  | 340
 |  | Elbow |  | 12 | 4 | ea. |  | 45 |  |  | 42 |  |  | 276.25 | ea. |  | 1105
Pipe |  |  |  | Size (O.D.) | qty | unit |  |  | wall |  | f p b | Gr |  | Amount | Unit |  | Total | 183337.9437241361
 |  | FBE  0.375 wall, X 42 |  | 12 | 8900 | ft |  |  | std |  | f | 42 |  | 19.25158160642783 | ft |  | 171339.0762972076
 |  | FBE  0.375 wall, X 42 |  | 12 | 400 | ft |  |  | std |  | fp | 42 |  | 28.48933662953819 | ft |  | 11395.73465181528
 |  | FBE  0.375 wall |  | 12 | 20 | ft |  |  | 0.375 |  | f | 42 |  | 30.15663875566054 | ft |  | 603.1327751132109
Tees (Reducing) |  |  |  | Run     x | qty | unit |  | Branch |  |  | Gr |  |  | Amount | Unit |  | Total | 0
 |  | tee reducing |  | 16 | 0 | ea. |  | 12 |  |  | 42 |  |  | 521.3333333333334 | ea.
Valves - Ball |  |  |  | Size (O.D.) | qty | unit |  | ANSI |  | W/F |  |  |  | Amount | Unit |  | Total | 20460
 |  | Valves - Ball |  | 12 | 2 | ea. |  | 600 |  | F |  |  |  | 10230 | ea. |  | 20460
Flanges |  |  |  | Size (O.D.) | qty | unit |  | ANSI | wall | W/F |  |  |  | Amount | Unit |  | Total | 700
 |  | Flange |  | 12 | 2 | ea. |  | 600 | std | W |  |  |  | 350 | ea. |  | 700
 |  | Flange |  | 8 | 0 | ea. |  | 600 | std | W |  |  |  | 150 | ea.
Bolt-up & Gaskets |  |  |  | Size (O.D.) | qty | unit |  | ANSI |  |  |  |  |  | Amount | Unit |  | Total | 448
 |  | Bolt-up & Gaskets |  | 12 | 4 | sets |  | 600 |  |  |  |  |  | 112 | ea. |  | 448
Valves - Check |  |  |  | Size (O.D.) | qty | unit |  | ANSI |  | End |  |  |  | Amount | Unit |  | Total | 1230
 |  | [NAME] |  | 12 | 1 | ea. |  | 600 |  | F |  |  |  | 1230 | ea. |  | 1230
TDW Items |  |  |  | Size (O.D.) | qty | unit |  |  |  |  |  |  |  | Amount | Unit |  | Total | 10200
 |  | [NAME] flange |  | 30 | 1 | ea. |  |  |  |  |  |  |  | 5600 | ea. |  | 5600
 |  | [NAME] flange |  | 24 | 1 | ea. |  |  |  |  |  |  |  | 4600 | ea. |  | 4600
Spreadsheet: 205297d1357776125-a-cell-reference-and-a-data-validation-list-in-same-cell-example-1-validate-reference
Sheet: Sheet2

standard | apple 1 | AID 1 | Banana 1 | BID 1 | pear 1 | PID 1
upgrade 1 | apple 2 | AID 2 | [NAME] | BID 2 | pear 2 | PID 2
upgrade 2 | apple 3 | AID 3 | [NAME] | BID 3 | pear 3 | PID 3
upgrade 3 | apple 4 | AID 4 | [NAME] | BID 4 | pear 4 | PID 4
upgrade 4 | apple 5 | AID 5 | Banana 5 | BID 5 | pear 5 | PID 5
Spreadsheet: 672238d1586801592-calculating-based-on-three-or-more-conditions-example1651
Sheet: Tables

Column1 | Column1 | Column1 |  | OMH115P |  |  |  |  |  |  |  |  |  |  |  |  | SKU | List
OMH115P | East | 5x |  | Region | QTY | Multiplier |  | Region | QTY | Multiplier |  | Region | QTY | Multiplier |  |  | OMH115P | 2.52
OMH120P | Central | 6 - 10x |  | East | 5x | 1.1 |  | Central | 5x | 1 |  | West | 5x | 1.1 |  |  | OMH120P | 3.86
OMH115PP | West | 11 - 25x |  |  | 6 - 10x | 1 |  |  | 6 - 10x | 0.91 |  |  | 6 - 10x | 0.95 |  |  | OMH115PP | 12.58
OMH220 |  | 26 - 50x |  |  | 11 - 25x | 0.9 |  |  | 11 - 25x | 0.8 |  |  | 11 - 25x | 0.9 |  |  | OMH220 | 4.21
OMH220P |  | 51 - 100x |  |  | 26 - 50x | 0.87 |  |  | 26 - 50x | 0.77 |  |  | 26 - 50x | 0.8 |  |  | OMH220P | 18.96
 |  | 101+ |  |  | 51 - 100x | 0.7 |  |  | 51 - 100x | 0.6 |  |  | 51 - 100x | 0.75
 |  |  |  |  | 101+ | 0.5 |  |  | 101+ | 0.48 |  |  | 101+ | 0.5
 |  |  |  | OMH120P
 |  |  |  | Region | QTY | Multiplier |  | Region | QTY | Multiplier |  | Region | QTY | Multiplier
 |  |  |  | East | 5x | 1.1 |  | Central | 5x | 1 |  | West | 5x | 1.1
 |  |  |  |  | 6 - 10x | 1 |  |  | 6 - 10x | 0.91 |  |  | 6 - 10x | 0.95
 |  |  |  |  | 11 - 25x | 0.9 |  |  | 11 - 25x | 0.8 |  |  | 11 - 25x | 0.9
 |  |  |  |  | 26 - 50x | 0.87 |  |  | 26 - 50x | 0.77 |  |  | 26 - 50x | 0.8
 |  |  |  |  | 51 - 100x | 0.7 |  |  | 51 - 100x | 0.6 |  |  | 51 - 100x | 0.75
 |  |  |  |  | 101+ | 0.5 |  |  | 101+ | 0.48 |  |  | 101+ | 0.5
 |  |  |  | OMH115PP
 |  |  |  | Region | QTY | Multiplier |  | Region | QTY | Multiplier |  | Region | QTY | Multiplier
 |  |  |  | East | 5x | 1.1 |  | Central | 5x | 1 |  | West | 5x | 1.1
 |  |  |  |  | 6 - 10x | 1 |  |  | 6 - 10x | 0.91 |  |  | 6 - 10x | 0.95
 |  |  |  |  | 11 - 25x | 0.9 |  |  | 11 - 25x | 0.8 |  |  | 11 - 25x | 0.9
 |  |  |  |  | 26 - 50x | 0.87 |  |  | 26 - 50x | 0.77 |  |  | 26 - 50x | 0.8
 |  |  |  |  | 51 - 100x | 0.7 |  |  | 51 - 100x | 0.6 |  |  | 51 - 100x | 0.75
 |  |  |  |  | 101+ | 0.5 |  |  | 101+ | 0.48 |  |  | 101+ | 0.5
 |  |  |  | OMH220
 |  |  |  | Region | QTY | Multiplier |  | Region | QTY | Multiplier |  | Region | QTY | Multiplier
 |  |  |  | East | 5x | 1.1 |  | Central | 5x | 1 |  | West | 5x | 1.1
 |  |  |  |  | 6 - 10x | 1 |  |  | 6 - 10x | 0.91 |  |  | 6 - 10x | 0.95
 |  |  |  |  | 11 - 25x | 0.9 |  |  | 11 - 25x | 0.8 |  |  | 11 - 25x | 0.9
 |  |  |  |  | 26 - 50x | 0.87 |  |  | 26 - 50x | 0.77 |  |  | 26 - 50x | 0.8
 |  |  |  |  | 51 - 100x | 0.7 |  |  | 51 - 100x | 0.6 |  |  | 51 - 100x | 0.75
 |  |  |  |  | 101+ | 0.5 |  |  | 101+ | 0.48 |  |  | 101+ | 0.5
 |  |  |  | OMH220P
 |  |  |  | Region | QTY | Multiplier |  | Region | QTY | Multiplier |  | Region | QTY | Multiplier
 |  |  |  | East | 5x | 1.1 |  | Central | 5x | 1 |  | West | 5x | 1.1
 |  |  |  |  | 6 - 10x | 1 |  |  | 6 - 10x | 0.91 |  |  | 6 - 10x | 0.95
 |  |  |  |  | 11 - 25x | 0.9 |  |  | 11 - 25x | 0.8 |  |  | 11 - 25x | 0.9
 |  |  |  |  | 26 - 50x | 0.87 |  |  | 26 - 50x | 0.77 |  |  | 26 - 50x | 0.8
 |  |  |  |  | 51 - 100x | 0.7 |  |  | 51 - 100x | 0.6 |  |  | 51 - 100x | 0.75
 |  |  |  |  | 101+ | 0.5 |  |  | 101+ | 0.48 |  |  | 101+ | 0.5
Spreadsheet: andy_zipper__290__AGA
Sheet: Total US

Month | Week | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003
Jan | 1
 | 2
 | 3
 | 4
 | 5
Feb | 6
 | 7
 | 8
 | 9
Mar | 10
 | 11
 | 12
 | 13
 | 14
Apr | 15
 | 16
 | 17
 | 18
May | 19
 | 20
 | 21
 | 22
Jun | 23
 | 24
 | 25
 | 26
Jul | 27
 | 28
 | 29
 | 30
Aug | 31
 | 32
 | 33
 | 34
 | 35
Sep | 36
 | 37
 | 38
 | 39
Oct | 40
 | 41
 | 42
 | 43
Nov | 44
 | 45
 | 46
 | 47
Dec | 48
 | 49
 | 50
 | 51
 | 52 |  |  |  |  |  |  |  |  |  |  |  | -195
Spreadsheet: 884029d1732911020-fetch-data-based-on-the-postive-balance-sample-accountant
Sheet: Sample Data

 | Prod Id | Date | Client Name | Invoice # | Billed Amount | Received | Balance
 | KHI 1 | 2024-11-27 00:00:00 | Mr. [NAME] | 50001 | 500000 | 500000
 | KHI 2 | 2024-11-28 00:00:00 | Mr. [NAME] | 50001 | 600000 | 450000
 | KHI 3 | 2024-11-28 00:00:00 | Mr. [NAME] | 50002 | 650000 | 680000
 | KHI 4 | 2024-11-29 00:00:00 | Mr.[NAME] | 50003 | 750000 | 750000
 | KHI 5 | 2024-11-29 00:00:00 | Mr.[NAME] | 50004 | 800000 | 780000
 | KHI 6 | 2024-11-29 00:00:00 | Mr.[NAME] | 50005 | 450000 | 450000
 | KHI 7 | 2024-11-29 00:00:00 | Mr.[NAME] | 50006 | 350000 | 350000
 | KHI 8 | 2024-11-29 00:00:00 | Mr.[NAME] | 50007 | 900000 | 900000
 | KHI 9 | 2024-11-29 00:00:00 | Mr.[NAME] | 50008 | 720000 | 615000
 | KHI 10 | 2024-11-29 00:00:00 | Mr.[NAME] | 50009 | 680000 | 680000
 | KHI 11 | 2024-11-29 00:00:00 | Mr.[NAME] | 50010 | 290000 | 280000
 | KHI 12 | 2024-11-29 00:00:00 | Mr.[NAME] | 50011 | 380000 | 380000
 |  | Date | Client Name | Invoice # | Billed Amount | Received | Balance
 | KHI 2 | 2024-11-28 00:00:00 | Mr. [NAME] | 50001 | 600000 | 450000 | 150000
 | KHI 5 | 2024-11-29 00:00:00 | Mr.[NAME] | 50004 | 800000 | 780000 | 20000
 | KHI 9 | 2024-11-29 00:00:00 | Mr.[NAME] | 50008 | 720000 | 615000 | 105000
 | KHI 11 | 2024-11-29 00:00:00 | Mr.[NAME] | 50010 | 290000 | 280000 | 10000
Spreadsheet: 537641d1505213620-day-issue-and-pivot-table-incorrect-week-numbers-timesystem1
Sheet: Pivot

 |  | Is 334 Contractor | TRUE
 |  | Time Sheet | Week Number
 |  | Name & Date | 2017.37 | 2017.38
 |  | [NAME] 334Cntr | 60 | 7
 |  | 2017-09-11 00:00:00 | 10
 |  | 2017-09-12 00:00:00 | 10
 |  | 2017-09-13 00:00:00 | 10
 |  | 2017-09-14 00:00:00 | 10
 |  | 2017-09-15 00:00:00 | 10
 |  | 2017-09-16 00:00:00 | 10
 |  | 2017-09-17 00:00:00 |  | 7
 |  | Grand Total | 60 | 7
Spreadsheet: 116898d1312279420-array-formula-or-possible-macro-to-match-and-calculate-between-multiple-sheets-testbook
Sheet: ProductRecipes

Ingredient | Amount | Unit | Falafel Wrap | [NAME] | Shrimp Wrap | Salmon Wrap
Falafel | 1 | OZ | 1 | 1 | 1 | 3
Marinated Chicken | 1 | OZ | 2 | 1 | 2 | 2
[NAME] Dough | 1 | OZ | 2 | 3
White Dough | 1 | OZ
[NAME] | 1 | OZ | 2 |  | 4
[NAME] | 1 | OZ | 1 |  |  | 1
Spreadsheet: 760069d1639971839-how-to-fill-series-or-formula-to-a-specific-row-without-dragging-in-excel-cash-flow-cash-flow-for-small-business
Sheet: Sheet1

PROJECT | TASK | START | END | FUNDING | PROJECT DURATION (MTHS) | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 |  |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
Project 1 | Buy consumables | 2022-01-10 00:00:00 |  | 1000
Project 1 | Hire staff |  |  | 18000
Project 1 | Contractor Fee | 2022-03-01 00:00:00 |  | 50000
Project 1 | Analysis Fee | 2022-10-01 00:00:00 |  | 10000
- 10% payment upfront and the remaining split across the duration
- remaining funds to be split equally across the entire duration of the task
Spreadsheet: 840336d1692660438-sumifs-while-cross-referencing-filtered-data-helper-or-no-helper-column
Sheet: EX 1 Imported Report

People | Places | Purpose | Days
[NAME] | Chicago | Business | 1
[NAME] | San Francisco | Tour | 2
Zach | New York | Work | 3
Gina | Lisbon | Work | 4
[NAME] the Eyebrow | Barcelona | Personal | 5
Gina | Madrid | Friends | 6
Zach | New York | Seminar | 7
[NAME] | Madrid | Tour | 8
[NAME] | Barcelona | Conference | 7
[NAME] the Eyebrow | San Francisco | Travel | 6
[NAME] | San Francisco | Tour | 5
Gina | Chicago | Work | 4
[NAME] the Eyebrow | Lisbon | Conference | 3
[NAME] | Chicago | Seminar | 2
Zach | Lisbon | Business | 1
[NAME] | Madrid | Family | 10
Spreadsheet: 822496d1679383929-empty-cell-counts-as-1-beyond-tat
Sheet: Sheet1

 | START DATE | END DATE | DIFFERENCE | BEYOND TAT
1 | 2023-01-01 00:00:00 | 2023-01-19 00:00:00
2 | 2023-01-03 00:00:00
3 | 2023-01-03 00:00:00 | 2023-01-03 00:00:00
4 | 2023-01-03 00:00:00 | 2023-01-31 00:00:00
5 | 2023-01-04 00:00:00 | 2023-01-06 00:00:00
 | HOLIDAYS
 | 2023-01-02 00:00:00
 | 2023-02-24 00:00:00
 | Question:
 | 1. In item number 2, why does Column E shows "1"?
 | 2. How can I make item number 2 into an empty cell just like the other items using another formula
Spreadsheet: 137959d1327444120-vlookup-match-array-formula-tigeravatar-example-for-skeller
Sheet: Sheet1

ID | Class | Teacher
1 | a | bob |  | Class: | a |  | Class: | b |  | Class: | c
1 | b | [NAME] |  | ID | Teacher |  | ID | Teacher |  | ID | Teacher
1 | c | [NAME] |  | 1 | bob |  | 1 | [NAME] |  | 1 | [NAME]
2 | c | [NAME] |  | 2 |  |  | 2 | ed |  | 2 | [NAME]
2 | b | ed |  | 3 | bob |  | 3 | ed |  | 3 | [NAME]
3 | a | bob |  | 4 |  |  | 4 |  |  | 4 | [NAME]
3 | b | ed
3 | c | [NAME]
4 | c | [NAME]
Spreadsheet: 016500a3-571b-496c-9667-11e7eed5886e
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (31 Entries):
 | 7 Biotechnology 7.17 Information and services
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Bayern International Bayer. Gesellschaft für Intern. Wirtschaftsbeziehungen mbH | Germany | München | 80687 | A3.251/350
2 | Berliner [NAME] [NAME] | Germany | Berlin | 12347 | A3.450
3 | BIOCOM AG | Germany | Berlin | 10785 | A3.112
4 | Biological Industries Ltd. | Israel | Beit Haemek | 25115 | A3.461
5 | BioM [NAME] | Germany | Martinsried | 82152 | A3.251/350
6 | BioPark Regensburg GmbH | Germany | [NAME] | 93053 | A3.251/350
7 | [NAME] | Germany | Dresden | 01307 | A3.341
8 | BMBF-Initiative 'BIOTechnikum. Leben erforschen - Zukunft gestalten' c/o FLAD & FLAD Communication GmbH | Germany | [NAME] | 90562 | EW.Atrium_1
9 | [NAME], Abt. [NAME] mbH | Germany | Luckenwalde | 14943 | A3.242
10 | [NAME] des [NAME] GmbH | Germany | München | 80336 | A3.251/350
11 | Charles River Laboratories | France | L&#39;Arbresle Cedex | 69592 | [NAME]
12 | [NAME] managed by: BioM [NAME] GmbH | Germany | Martinsried | 82152 | A3.251/350
13 | Eurofins Medigenomix GmbH | Germany | Ebersberg | 85560 | A3.144
14 | GoingPublic Media AG | Germany | München | 81379 | A3.DP3
15 | HP Medizintechnik GmbH | Germany | Oberschleißheim | 85764 | B2.307/412
16 | IMGM Laboratories GmbH - your outsourcing partner for genomic services | Germany | Martinsried / München | 82152 | A3.251/350
17 | Integra Biosciences GmbH | Germany | Fernwald | 35463 | B1.510
18 | Labexchange Service GmbH | Germany | Burladingen | 72393 | A2.313/412
19 | Labor Dr. Merk & Kollegen GmbH | Germany | Ochsenhausen | 88416 | A3.111
20 | Labor L+S AG | Germany | Bad Bocklet | 97708 | A1.136
21 | L.U.M. GmbH | Germany | Berlin | 12489 | A1.526
22 | metabion international AG metabion GmbH | Germany | [NAME] | 82152 | A3.400
23 | Microsynth AG | Switzerland | Balgach | 9436 | A3.310
24 | [NAME] m4 managed by: BioM [NAME] GmbH | Germany | Martinsried | 82152 | A3.251/350
25 | PSS Polymer Standards Service GmbH | Germany | [NAME] | 55120 | A1.223
26 | Rentschler Biotechnologie GmbH | Germany | Laupheim | 88471 | B2.440
27 | Science/AAAS | United Kingdom | Cambridge | CB2 1LQ | A3.512
28 | SEQLAB Sequence Laboratories Göttingen GmbH | Germany | Göttingen | 37085 | A3.166
29 | Thermo Scientific | Germany | Dreieich | 63303 | B1.101/202
30 | thinXXS Microtechnology AG | Germany | Zweibrücken | 66482 | A3.403
31 | YMC Europe GmbH | Germany | [NAME] | 46539 | A1.407
Spreadsheet: 159983d1338918723-vlookup-or-macro-book1
Sheet: Sheet1

Name | Category | Task |  |  |  | Name | Group
[NAME] | Service | 4 |  |  |  | 1 | Service |  |  | Project1
[NAME] | Project | 1 |  |  |  | 2 | Project |  |  | Project2
[NAME] | Project | 2 |  |  |  | 3 | Other
[NAME] | Project | 3 |  |  |  | 4 | Project
[NAME] | Service | 2
[NAME] | Service | 2
[NAME] | Service | 2
[NAME] | Service | 2
[NAME] | Service | 2
[NAME] | Service | 2
[NAME] | Service | 3
[NAME] | Service | 4
[NAME] | Service | 1
[NAME] | Project | 1
[NAME] | Project | 1
[NAME] | Project | 1
[NAME] | Project | 1
[NAME] | Project | 1
[NAME] | Project | 2
[NAME] | Project | 2
[NAME] | Service | 3
[NAME] | Service | 3
[NAME] | Service | 3
[NAME] | Service | 4
[NAME] | Service | 4
[NAME] | Service | 4
[NAME] | Project | 4
[NAME] | Project | 1
[NAME] | Project | 1
[NAME] | Project | 1
[NAME] | Project | 2
Spreadsheet: 846841d1697989537-convert-column-of-dates-to-day-number-of-year-etc-2024datesexample
Sheet: Birthdays-2024

Birthday | Age in 2024 | Day Number of 2024 | Day of Week in 2024
1968-04-10 00:00:00
2007-05-03 00:00:00
2011-04-16 00:00:00
2003-10-25 00:00:00
1984-08-30 00:00:00
2000-02-29 00:00:00
2004-11-11 00:00:00
1950-01-04 00:00:00
1938-01-17 00:00:00
2007-05-03 00:00:00
2011-04-16 00:00:00
1997-03-29 00:00:00
1941-03-04 00:00:00
2006-09-09 00:00:00
2005-09-13 00:00:00
2024-02-14 00:00:00
1971-07-23 00:00:00
1974-09-17 00:00:00
2005-09-13 00:00:00
1954-06-01 00:00:00
[NAME] for columns B, C & D to avoid tedious manual entry?
Spreadsheet: 52036d1251727896-link-sheets-based-on-grade-level-early-check-out-09-10-practice
Sheet: 1st Nine Weeks

1 | 2 |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56
 | Week of |  | 2009-08-24 00:00:00 |  | - | 2009-08-28 00:00:00 |  | Weekly Totals | 2009-08-31 00:00:00 |  | - | 2009-09-04 00:00:00 |  | Weekly Totals | 2009-09-07 00:00:00 |  | - | 2009-09-11 00:00:00 |  | Weekly Totals | 2009-09-14 00:00:00 |  | - | 2009-09-18 00:00:00 |  | Weekly Totals | 2009-09-21 00:00:00 |  | - | 2009-09-25 00:00:00 |  | Weekly Totals | 2009-09-28 00:00:00 |  | - | 2009-10-02 00:00:00 |  | Weekly Totals | 2009-10-05 00:00:00 |  | - | 2009-10-09 00:00:00 |  | Weekly Totals | 2009-10-12 00:00:00 |  | - | 2009-10-16 00:00:00 |  | Weekly Totals | 2009-10-19 00:00:00 |  | - | 2009-10-23 00:00:00 |  | Weekly Totals
 |  |  | Mon | Tue | Wed | Thu | Fri |  | Mon | Tue | Wed | Thu | Fri |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | Student Name | Gr. | 2009-08-24 00:00:00 | 2009-08-25 00:00:00 | 2009-08-26 00:00:00 | 2009-08-27 00:00:00 | 2009-08-28 00:00:00 |  | 2009-08-31 00:00:00 | 2009-09-01 00:00:00 | 2009-09-02 00:00:00 | 2009-09-03 00:00:00 | 2009-09-04 00:00:00 |  | 2009-09-07 00:00:00 | 2009-09-08 00:00:00 | 2009-09-09 00:00:00 | 2009-09-10 00:00:00 | 2009-09-11 00:00:00 |  | 2009-09-14 00:00:00 | 2009-09-15 00:00:00 | 2009-09-16 00:00:00 | 2009-09-17 00:00:00 | 2009-09-18 00:00:00 |  | 2009-09-21 00:00:00 | 2009-09-22 00:00:00 | 2009-09-23 00:00:00 | 2009-09-24 00:00:00 | 2009-09-25 00:00:00 |  | 2009-09-28 00:00:00 | 2009-09-29 00:00:00 | 2009-09-30 00:00:00 | 2009-10-01 00:00:00 | 2009-10-02 00:00:00 |  | 2009-10-05 00:00:00 | 2009-10-06 00:00:00 | 2009-10-07 00:00:00 | 2009-10-08 00:00:00 | 2009-10-09 00:00:00 |  | 2009-10-12 00:00:00 | 2009-10-13 00:00:00 | 2009-10-14 00:00:00 | 2009-10-15 00:00:00 | 2009-10-16 00:00:00 |  | 2009-10-19 00:00:00 | 2009-10-20 00:00:00 | 2009-10-21 00:00:00 | 2009-10-22 00:00:00 | 2009-10-23 00:00:00
12345678 | Student 1 Name | 1
12345679 | Student 2 Name | 1
12345680 | Student 3 Name | KG
12345681 | Student 4 Name | 3
12345682 | Student 5 Name | 5
12345683 | Student 6 Name | 1
12345684 | Student 7 Name | 2
12345685 | Student 8 Name | 2
12345686 | Student 9 Name | 5
12345687 | Student 10 Name | KG
Spreadsheet: 690182d1596916661-create-unique-list-of-orders-and-assign-items-orders-and-items
Sheet: Sheet1

 |  |  | Data |  |  | Result
 |  |  | Order # | Item |  | Order # | Item #1 | Item #2 | Item #3
 |  |  | 1045 | A |  | 1045 | A | B
 |  |  | 1045 | B |  | 1046 | C
 |  |  | 1046 | C |  | 1047 | D | E
 |  |  | 1047 | D |  | 1048 | F | G | B
 |  |  | 1047 | E |  | 1049 | A
 |  |  | 1048 | F
 |  |  | 1048 | G
 |  |  | 1048 | B
 |  |  | 1049 | A
Spreadsheet: 780290d1652373984-return-multiple-values-across-many-rows-and-columns-20210302-projects-1-
Sheet: Stg1 SIR Narrabundah

 |  | 2020-03-10 00:00:00
 | Task | Description | Contract Amount (ex GST) | Percent Complete | Billed To Date | Previously Billed | Current Billed
 | Stage 1 | Stage 1 SIR Narrabundah | 22700 |  |  | 0 | 22700
 |  | Project Total
 |  |  | Subtotal of This Invoice
 |  |  | GST
 |  |  | Invoice Total (Including GST)
Spreadsheet: kam_keiser__18046__Summary of Book Requests Update
Sheet: Financial

 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION
 |  |  | Type Of Transactions |  |  | Book Mapping
CP ID | Short Name | Long Name | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Y | Commodity/UOM/Curr | [NAME] | MTM or ACCRUAL | Reason For Book | Date Needed
166805 | FB-Financial1 | FB-Financial1 |  |  | X | MF | Financial1 | X | X | X | X |  | X | NG/MMBUT/USD |  | MTM | new company
166807 | FB-Financial2 | FB-Financial2 |  |  | X | MF | Financial2 | X | X | X | X |  | X | NG/MMBUT/USD | [NAME] | MTM | new company
166813 | FB-Financial3 | FB-Financial3 |  |  | X | MF | Financial3 | X | X | X | X |  | X | NG/MMBUT/USD | [NAME] May | MTM | new company
166815 | FB-Financial4 | FB-Financial4 |  |  | X | MF | Financial4 | X | X | X | X |  | X | NG/MMBUT/USD | [NAME] | MTM | new company
166818 | FB-Financial5 | FB-Financial5 |  |  | X | MF | Financial5 | X | X | X | X |  | X | NG/MMBUT/USD | [NAME] | MTM | new company
166823 | FB-Executive | FB-Executive |  |  | X | MF | Financial | X | X | X | X |  | X | NG/MMBUT/USD | [NAME] | MTM | new company
166828 | FB-Crude | FB-Crude |  |  | X | MF | FinancialC | X |  |  |  |  |  | WTI/BBL/USD |  | MTM | new company
166831 | FB-Unleaded | FB-Unleaded |  |  | X | MF | FinancialU | X |  |  |  |  |  | HU/BBL/USD |  | MTM | new company
166833 | FB-Heating Oil | FB-Heating Oil |  |  | X | MF | FinancialH | X |  |  |  |  |  | HO/BBL/USD |  | MTM | new company