tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 269499d1381174421-formatting-a-table-to-pull-data-array-formula-sampletable_student1990-2-pt-oeldere-
Sheet: Pivot table

Som van 3-Year | Kolomlabels
 | 1 |  | Totaal 1 | 2 |  | Totaal 2 | 3 |  | Totaal 3 | 4 |  | Totaal 4 | 5 |  | Totaal 5 | Eindtotaal
Rijlabels | Fundamental | Quantitative |  | Fundamental | Quantitative |  | Fundamental | Quantitative |  | Fundamental | Quantitative |  | Fundamental | Quantitative
A | 41.47355 | 42.5673 | 84.04085 | 40.3968 | 41.3365 | 81.73330000000001 | 40.7115 | 42.1756 | 82.8871 | 44.50315000000001 | 45.9926 | 90.49575 | 41.18515 | 44.11645 | 85.30160000000001 | 424.4586
Returns | 18.90175 | 20.4263 | 39.32805 | 18.5154 | 19.97285 | 38.48825 | 18.6113 | 20.2478 | 38.8591 | 21.25335 | 21.8099 | 43.06325 | 19.1644 | 21.0211 | 40.1855 | 199.92415
Shape | 0.8926 | 0.9669 | 1.8595 | 0.8897 | 0.9776 | 1.8673 | 0.8925 | 0.9679 | 1.8604 | 0.93175 | 0.9609 | 1.89265 | 0.91065 | 0.9631 | 1.87375 | 9.3536
StdDev | 21.6792 | 21.1741 | 42.8533 | 20.9917 | 20.38605 | 41.37775000000001 | 21.2077 | 20.9599 | 42.1676 | 22.31805 | 23.2218 | 45.53985 | 21.1101 | 22.13225 | 43.24235 | 215.18085
B | 39.1967 | 41.5307 | 80.7274 | 41.35355 | 42.4752 | 83.82874999999999 | 40.74930000000001 | 43.5907 | 84.34 | 42.31945 | 40.5774 | 82.89685 | 39.40434999999999 | 43.8403 | 83.24465000000001 | 415.03765
Returns | 17.9256 | 18.99385 | 36.91945 | 18.96405 | 21.9318 | 40.89585 | 18.92075 | 21.1401 | 40.06085 | 20.3333 | 18.1143 | 38.4476 | 18.41695 | 21.3699 | 39.78685 | 196.1106
Shape | 0.8617 | 0.896 | 1.7577 | 0.92095 | 1.125 | 2.04595 | 0.91025 | 0.9806 | 1.89085 | 0.9381 | 0.7969 | 1.735 | 0.9092 | 1.0513 | 1.9605 | 9.39
StdDev | 20.4094 | 21.64085 | 42.05025000000001 | 21.46855 | 19.4184 | 40.88695 | 20.9183 | 21.47 | 42.3883 | 21.04805 | 21.6662 | 42.71425 | 20.0782 | 21.4191 | 41.4973 | 209.53705
C | 40.46 | 42.23999999999999 | 82.69999999999999 | 39.8 | 40.33 | 80.13 | 39.87 | 40.41 | 80.28 | 39.72 | 39.57 | 79.28999999999999 | 38.91 | 42.34 | 81.25 | 403.65
Returns | 18.8 | 21.72 | 40.52 | 19.33 | 19.67 | 39 | 19.28 | 19.81 | 39.09 | 18.44 | 18.05 | 36.49 | 18 | 20.98 | 38.98 | 194.08
Shape | 0.94 | 1.07 | 2.01 | 1.01 | 0.99 | 2 | 0.98 | 1.04 | 2.02 | 0.91 | 0.89 | 1.8 | 0.9 | 1.03 | 1.93 | 9.76
StdDev | 20.72 | 19.45 | 40.17 | 19.46 | 19.67 | 39.13 | 19.61 | 19.56 | 39.17 | 20.37 | 20.63 | 41 | 20.01 | 20.33 | 40.34 | 199.81
D | 37.08 | 38.61 | 75.69 | 35.39 | 36.98 | 72.37 | 35.59999999999999 | 37.76 | 73.36 | 36.08 | 36.89 | 72.97 | 34.83 | 36.8 | 71.63 | 366.02
Returns | 17.98 | 20.05 | 38.03 | 17.87 | 19.02 | 36.89 | 17.89 | 19.51 | 37.40000000000001 | 17.42 | 19.07 | 36.49 | 17.24 | 19.33 | 36.56999999999999 | 185.38
Shape | 1.02 | 1.16 | 2.18 | 1.08 | 1.17 | 2.25 | 1.06 | 1.17 | 2.23 | 0.98 | 1.1 | 2.08 | 1.05 | 1.2 | 2.25 | 10.99
StdDev | 18.08 | 17.4 | 35.48 | 16.44 | 16.79 | 33.23 | 16.65 | 17.08 | 33.73 | 17.68 | 16.72 | 34.4 | 16.54 | 16.27 | 32.81 | 169.65
Eindtotaal | 158.21025 | 164.948 | 323.15825 | 156.94035 | 161.1217 | 318.06205 | 156.9308 | 163.9363 | 320.8671000000001 | 162.6226 | 163.03 | 325.6526 | 154.3295 | 167.09675 | 321.42625 | 1609.16625
Spreadsheet: 01413bfc-5de4-4861-a419-a643886dfc73
Sheet: Sheet1

2013 Troop 34 Flower Sale Order Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
[NAME] | Orders Due: 4/5/2013
Customer | Phone
Address | [NAME]
 | 16 | 8.5
Annuals | Full Flat $16.00 | Half Flat $8.50 | Total
[NAME] |  |  | 0
[NAME] |  |  | 0
Marigolds Mixed |  |  | 0
Petunias Pink |  |  | 0
Petunias Mixed |  |  | 0
Ageratum |  |  | 0
Dianthus |  |  | 0
[NAME] |  |  | 0
Salvia Red |  |  | 0
[NAME] |  |  | 0
[NAME] |  |  | 0
[NAME] |  |  | 0
Coleus |  |  | 0
[NAME] |  |  | 0
[NAME] |  |  | 0
[NAME] |  |  | 0
Miscellaneous | Price | Quantity | Total
Geraniums | 3.75 |  | 0
[NAME] | 15.75 |  | 0
Hanging Baskets | Price | Quantity | Total
10" Fuchsia | 17 |  | 0
10" Geranium Ivy | 17 |  | 0
10" Double Impatiens | 17 |  | 0
10" Supertinia | 17 |  | 0
10" Torenia | 17 |  | 0
10" Calibroca | 17 |  | 0
12" Combo | 24 |  | 0
14" Coconest Combo | 34 |  | 0
14" Cone Basket | 34 |  | 0
Tubs & Urns | Price | Quantity | Total
16" Combo (Grey, Red Bronze, [NAME]) | 35 |  | 0
10" Terra Combo | 20 |  | 0
6.5" Annual Combo (Terra Pot) | 7 |  | 0
4.5" Hens & Chicks | 5 |  | 0
Veggies & Herbs | Price | Quantity | Total
Bell Pepper | 3 |  | 0
[NAME] | 3 |  | 0
[NAME] | 3 |  | 0
Big Boy Tomato | 3 |  | 0
[NAME] | 3 |  | 0
Dill | 2.75 |  | 0
Cilantro | 2.75 |  | 0
Lavender | 2.75 |  | 0
Thyme | 2.75 |  | 0
Sage | 2.75 |  | 0
[NAME] | 2.75 |  | 0
Total Amount Due | 0
Amount Paid | 0
Balance Due | 0
Delivery Date: May 4-6, 2013
Special Delivery Instructions
Spreadsheet: 57282d1257392953-help-on-formula-multiple-worksheets-excel-ks
Sheet: 0410 Conc Supply

Project: |  |  |  |  |  |  |  |  |  | Claim No.: | 1
Building: |  |  |  |  |  |  |  |  |  | Proj No.:
Trade No / Trade Name | TP 0410 | Concrete Supply |  |  |  |  |  |  |  | Date Issued: | 2009-10-30 00:00:00
[NAME]
TP No:- | Subcontract / Supply No | Description |  | Subcontractor / Supplier | Original Contract Sum | Adjustment | Adjusted Contract Sum | Approved Commitment | Completed to date | Previous Approved Value | Value this Claim
 |  |  |  |  | 4000 | 0 | 4000 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  | Contract Works Sub-Total | 4000 | 0 | 4000 | 0 | 0 | 0 | 0
Variation / Claims
SCVO | Status | Description | Notification / Instruction # | Subcontractor / Supplier | Budget | Adjustment | Adjusted Budget | Approved Commitment | Completed to date | Previous Approved Value | Value this Claim
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | Contract Works Sub-Total | 0 | 0 | 0 | 0 | 0 | 0 | 0
TP 0410 | Concrete Supply |  |  | NET TOTAL | 4000 | 0 | 4000 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Status
 |  |  |  |  |  |  | A | Approved
 |  |  |  |  |  |  | P | Submitted / Pending Approval
 |  |  |  |  |  |  | D | Disputed
 |  |  |  |  |  |  | R | Rejected
Spreadsheet: 751551d1634166732-please-help-beginner-with-a-formula-please-need-help-etaf-1-
Sheet: Sheet1

 |  |  | A | B
 | 1st | example | 1 | 3 |  | 1 |  | 1 | 1
 | 2nd | example | 0 | 7 |  | 0
 | 3rd | example | 0 | -5 |  | 0
 | 4th | example | 1 | 12 |  | 1
 | 5th | example | 1 | -3 |  | 0
 |  |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  | 1st | result | 1
 |  |  |  |  |  |  |  | 2nd | result | 0
 |  | I need a formula in the C column , that will give me back a ''1'' only when there is both a 1 in the A column and a positive number in the B column. If any of these conditions are not met , I should get back a ''0'' in the C column. |  |  |  |  |  | 3rd | result | 0
 |  |  |  |  |  |  |  | 4th | result | 1
 |  |  |  |  |  |  |  | 5th | result | 0
Spreadsheet: 816868d1675869431-matching-two-separate-columns-and-return-a-value-from-a-different-column-junction-look-up
Sheet: Gully

FROM M/H Ref | Depth | TO  M/H Ref | Depth2 |  |  |  |  |  |  |  |  |  | Junction Size
6 | 2.274999999999977 | 7 | 2.098000000000013 |  |  |  |  |  |  |  |  |  | This need to look up the first manhole in column A and then the Manhole in Column C. It then needs to match column A here with Column D on the sewers tab and Column C here with column E on the sewers tab. It then need to return the pipe diamter from Column G on the sewers tab
6 | 2.274999999999977 | 7 | 2.098000000000013 |  |  |  |  |  |  |  |  |  | so in cell M8 the result would be 225
6 | 2.274999999999977 | 7 | 2.098000000000013 |  |  |  |  |  |  |  |  |  | M12 would be 450
6 | 2.274999999999977 | 7 | 2.098000000000013
7 | 2.098000000000013 | 8 | 1.813000000000017
15 | 1.655000000000001 | 15 | 1.655000000000001
15 | 1.655000000000001 | 15 | 1.655000000000001
15 | 1.655000000000001 | 15 | 1.655000000000001
15 | 1.655000000000001 | 16 | 1.757000000000005
16 | 1.757000000000005 | 17 | 1.687000000000012
Spreadsheet: 696106d1600630172-section-wise-summarize-the-data-into-one-sheet-from-other-work-sheets-summarize-the-data-into-one-sheet-from-multiple-work-sheets-mohammad-munawar-
Sheet: Summary

 |  |  | Section-A |  |  | Section-B |  |  | Section-C
Ref | Description | Total | Total Consumed Hrs |  | Total | Total Consumed Hrs |  | Total | Total Consumed Hrs
Number | Workdone | Qty | Man Power | Machinery | Qty | Man Power | Machinery | Qty | Man Power | Machinery
Spreadsheet: 857741d1706671275-solve-for-multiple-objective-cells-in-solver-sff-2024-solver-copy
Sheet: Real Adj Returns

 |  |  | Macquarie Term Deposit - Returns adjusted for taxation and inflation
Year | Amount invested in real dollars | Interest rate | Earnings | Tax | After Tax Earnings | Inflation % | Real value of closing balance |  | Annual closing balance | Inflation Factor
1 | 100000 | 0.0465 |  | 0.3 |  | 4.3
2 |  | 0.0465 |  | 0.3 |  | 4.3
3 |  | 0.0465 |  | 0.3 |  | 4.3
4 |  | 0.0465 |  | 0.3 |  | 4.3
5 |  | 0.0465 |  | 0.3 |  | 4.3
6 |  | 0.0465 |  | 0.3 |  | 4.3
7 |  | 0.0465 |  | 0.3 |  | 4.3
8 |  | 0.0465 |  | 0.3 |  | 4.3
9 |  | 0.0465 |  | 0.3 |  | 4.3
10 |  | 0.0465 |  | 0.3 |  | 4.3
11 |  | 0.0465 |  | 0.3 |  | 4.3
12 |  | 0.0465 |  | 0.3 |  | 4.3
13 |  | 0.0465 |  | 0.3 |  | 4.3
14 |  | 0.0465 |  | 0.3 |  | 4.3
15 |  | 0.0465 |  | 0.3 |  | 4.3
 |  |  | Remara Investment - Returns adjusted for taxation and inflation
1 | 100000 | 0.133 |  | 0.3 |  | 4.3
2 |  | 0.133 |  | 0.3 |  | 4.3 |  |  |  | 0.9570000000000001
3 |  | 0.133 |  | 0.3 |  | 4.3 |  |  |  | 0.9570000000000001
4 |  | 0.133 |  | 0.3 |  | 4.3 |  |  |  | 0.9570000000000001
5 |  | 0.133 |  | 0.3 |  | 4.3 |  |  |  | 0.9570000000000001
6 |  | 0.133 |  | 0.3 |  | 4.3 |  |  |  | 0.9570000000000001
7 |  | 0.133 |  | 0.3 |  | 4.3 |  |  |  | 0.9570000000000001
8 |  | 0.133 |  | 0.3 |  | 4.3 |  |  |  | 0.9570000000000001
9 |  | 0.133 |  | 0.3 |  | 4.3 |  |  |  | 0.9570000000000001
10 |  | 0.133 |  | 0.3 |  | 4.3 |  |  |  | 0.9570000000000001
11 |  | 0.133 |  | 0.3 |  | 4.3 |  |  |  | 0.9570000000000001
12 |  | 0.133 |  | 0.3 |  | 4.3 |  |  |  | 0.9570000000000001
13 |  | 0.133 |  | 0.3 |  | 4.3 |  |  |  | 0.9570000000000001
14 |  | 0.133 |  | 0.3 |  | 4.3 |  |  |  | 0.9570000000000001
15 |  | 0.133 |  | 0.3 |  | 4.3 |  |  |  | 0.9570000000000001
Spreadsheet: 884011d1732885079-working-with-representations-of-time-durations-2024-25-track-timing-cut-down-
Sheet: Output

DATE | Prog
2024-11-22 00:00:00
 |  |  | DATA IN THESE COLUMNS ISPROBLEMATIC |  |  |  |  |  |  |  |  |  |  | The desired results are as follows:
EVENT |  |  | (Wrong)
200m
Race # | # Aths | RaceTime | Quickest | Slowest | Span | Intervals | Age Groups |  |  |  |  |  |  | Quickest | Slowest | Span
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 51.76 | 00:01:25.900000 | 34.14 |  |  |  | 18.9
Race-038 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50.1 | 00:01:18.900000 | 28.8 |  |  |  | 9.9
Spreadsheet: 75618d1276166542-left-lookup-sample
Sheet: Sheet1

Type | Value1 | Value2 |  | Find Type given Value |  |  | occurance
aa | 149 |  |  | Value | 150 |  | 1 | bb
bb | 145 | 150 |  |  |  |  | 2 | ee
cc | 148 | 146 |  |  |  |  | 3 | ee
dd |  | 146 |  |  |  |  | 4 | gg
ee | 150 | 150 |  |  |  |  | 5 | hh
ff | 147 | 140 |  |  |  |  | 6
gg | 150 |  |  |  |  |  | 7
hh |  | 150 |  |  |  |  | 8
ii | 142 | 145 |  |  |  |  | 9
jj | 147 |  |  |  |  |  | 10
 |  |  |  |  |  |  | 11
 |  |  |  |  |  |  | 12
 |  |  |  |  |  |  | 13
 |  |  |  |  |  |  | 14
 |  |  |  |  |  |  | 15
 |  |  |  |  |  |  | 16
 |  |  |  |  |  |  | 17
 |  |  |  |  |  |  | 18
 |  |  |  |  |  |  | 19
Spreadsheet: 676659d1588919632-if-or-and-and-nested-function-forum-q1
Sheet: Sheet1

 |  | City | Country | Month | Count | New Count
 |  | Melbourne | Australia | January | 100
 |  | Sydney | Australia | January | 101
 |  | Melbourne | Australia | January | 102
 |  | Sydney | Australia | March | 103
 |  | Melbourne | Australia | April | 104
 |  | Sydney | Australia | May | 105
 |  | Melbourne | Australia | September | 106
 |  | [NAME] | Australia | September | 107
 |  | [NAME] | Australia | September | 108
 |  | Auckland | New Zealand | January | 109
 |  | Auckland | New Zealand | September | 110
 |  | Auckland | New Zealand | December | 111
Spreadsheet: 881056d1728982088-combine-arrays-into-1-array-to-make-to-1-array
Sheet: Sheet1

Department | Name | Sales | Budget N | Actual N | Budget N+1 | Actual N
Finance | A | 4000 | 5000
Sales | B | 2000 | 3500
Finance | C | 3000
Marketing | D | 3400
Spreadsheet: 268537d1380672630-using-if-then-and-using-sorting-to-parse-data-and-create-list-without-spaces-sample-list
Sheet: Sheet1

 |  |  |  |  |  |  | widgets
 |  |  |  | invoice y/n | customer | date | a | b | c | d | e | f | g | h | i | j | k | l | m | n
 |  |  |  |  | [NAME] | 2013-10-01 00:00:00 | 2 |  | 4 |  |  | 1 |  |  | 3
 |  |  |  |  | [NAME] | 2013-01-02 00:00:00 |  | 1 | 1 |  |  | 1 |  | 2 |  | 4
 |  |  |  |  | bill doe | 2012-04-05 00:00:00 | 1 |  |  | 2 |  |  |  | 2 |  |  |  | 2
 |  |  |  |  | [NAME] doe | 2011-07-08 00:00:00 |  |  |  |  |  |  |  |  | 2 |  | 2
 |  |  |  |  | carol doe | 2010-10-09 00:00:00 | 1 | 1 |  |  |  |  |  |  | 1 |  |  | 1
 |  |  |  | y | [NAME] doe | 2010-01-10 00:00:00 | 3 |  | 2 |  | 1 |  |  | 1 |  |  | 1 |  | 1 | 1
 |  |  |  |  | sue doe | 2009-04-13 00:00:00 | 3 |  | 5 |  | 5 | 6 |  | 7 |  |  | 6
 |  |  |  |  | [NAME] doe | 2008-07-15 00:00:00 | 1 |  |  | 1 |  |  | 1 |  |  |  | 2 |  | 4 | 5
Spreadsheet: sally_beck__33749__Moratorium
Sheet: Work on Hold

Work on HOLD
New Product Type |  | US Nat Gas Financial Options
 | 2000-08-10 00:00:00 | On hold until post-Phase II
New Product Type |  | AUS and JPN Weather Options
 | 2000-08-10 00:00:00 | On hold until post-Phase II
New Product Type |  | Physical Steel
 | 2000-08-03 00:00:00 | Spoke with [NAME]. Enron owns a surplus of steel and would like to transact Online.
 |  | They have never done this OTC, have no Confirmations, no legal description, no GTC.
 |  | Jayshree was directed to the Legal area to start the legal review and processes.
New Product Type |  | Advertising Market (Bandwidth)
 | 2000-08-09 00:00:00 | Work commenced earlier in the month with discussions with trading. When we followed
 |  | up with [NAME] (EBS Legal), [NAME] explained that they had not done this
 |  | product OTC, that they had no GTC, [NAME], or Confirmation in place - and
 |  | that she was putting this on hold for EOL purposes until they could get the documentation
 |  | in order.
Spreadsheet: 818408d1676815595-or-function-in-table-format-doesnt-work-example
Sheet: Sheet1

 | (Worked) Scenario1: Indicator =1
 |  |  |  |  |  | Expected: |  |  |  | [NAME]:
 |  | Transit | GL | Indicator |  | Transit | GL | Indicator |  | Transit | GL | Indicator
 |  | 11111 | 123456
 |  | 22222 | 2222214
 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1
 | (Doesn't Worked) Scenario2: Indicator =1 or Indicator [NAME]
 |  |  |  |  |  | Expected: |  |  |  | [NAME]:
 |  | Transit | GL | Indicator |  | Transit | GL | Indicator |  | Transit | GL | Indicator
 |  | 11111 | 123456 | -1 |  | 11111 | 123456 | -1 |  |  | 123456 | -1
 |  | 22222 | 2222214 |  |  |  |  |  |  | 22222 | 2222214 | 0
 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1
Spreadsheet: 880420d1728089023-adding-another-equation-into-the-the-mix-test-file-4-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02 | / Month
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TERM |  |  |  |  | Original | Without SUM | TMS 1 | TMS 2 | [NAME] | Without SUM | TMS 3 | Without SUM | TMS 4
 |  |  |  | 15013 |  | 2023-05-01 00:00:00 | 2024-09-03 00:00:00 | True | False | 61570 | 58010 | 1000 |  |  | 34300 | HARD FIGURE
 |  |  |  | 14858 |  | 2023-06-30 00:00:00 | 2024-08-29 00:00:00 | True | False | 59950 | 56545 | 1000 |  |  | 35100 | HARD FIGURE
 |  |  |  | 16029 |  | 2024-01-31 00:00:00 | 2024-08-31 00:00:00 | True | False | 62910 | 59245 | 1000 |  |  | 42500 | HARD FIGURE
 |  |  |  | 8E18669 |  | 2024-01-31 00:00:00 |  | False | False | 45065 | 42655 | 500 |  |  |  | False
 |  |  |  | 7N62794 |  | 2024-01-31 00:00:00 |  | False | False | 42895 | 40640 | 500 |  |  |  | False
 |  |  |  | 7N71090 |  | 2024-01-31 00:00:00 |  | False | False | 44195 | 41850 | 500 |  |  |  | False
 |  |  |  | FS28362 |  | 2024-01-31 00:00:00 |  | False | False | 54115 | 51070 | 500 |  |  |  | False
 |  |  |  | 9V40554 |  | 2024-02-29 00:00:00 | 2024-08-31 00:00:00 | True | False | 51330 | 48470 | 500 |  |  | 38800 | HARD FIGURE
 |  |  |  | 15849 |  | 2024-02-29 00:00:00 |  | False | False | 63395 | 59705 | 1000 |  |  |  | False
 |  |  |  | 15851 |  | 2024-02-29 00:00:00 |  | False | False | 61945 | 58355 | 1000 |  |  |  | False
Spreadsheet: 770264d1645965518-calculate-time-applicant-tracker-aligw
Sheet: Sheet1

Name | Received  (Date & Time) | Assigned to | Contacted  (Date & Time) | Time to Contact | Interview Scheduled? | Confirmation Made? | Show for Internview? | Job offered? | Job accepted? | Show for Work? | 2nd Reach-Out (Date) | 3rd Reach-Out (Date)
Batman | 2022-02-22 11:00:00 |  | 2022-02-24 17:00:00
Superman | 2022-02-23 11:00:00 |  | 2022-02-24 12:00:00
Spreadsheet: 683368d1592668372-searching-between-two-excel-sheets-vlookup
Sheet: Sheet1

Number | Products | Price
1 | A | 100
2 | B | 200
3 | C | 300
4 | D | 400
5 | E | 500
6 | F | 600
7 | G | 700
Spreadsheet: 713484d1610732596-formula-to-return-multiple-matches-from-a-reference-list-excel_help-1-
Sheet: Sheet2

group_names | assigned_categories
Group A | Red
Group B | TURQUOISE
Group C | Red
Group D | Red
Group E | Red
Group F | Red
Group G | Red
Group H | Red
Group I | Red
Group J | YELLOW
Group K | Blue
Group L | Blue
Group M | Blue
Group N | Blue
Group O | Blue
Group P | Blue
Group Q | Blue
Group R | Blue
Group S | Red
Group T | GREEN
Group U | Red
Group V | Red
Group W | Red
Group X | Red
Group Y | Red
Group Z | Red
Spreadsheet: 49280d1248571737-looking-up-the-column-header-for-a-given-value-in-a-column-example-ranj
Sheet: Sheet2

Header 1 | [NAME] | [NAME] | [NAME] | ABS High 1 | Header | ABS High 2 | Header
0 | -5 | 4 | 0 | -5 | [NAME] | 4 | [NAME]
0 | 0 | 2.5 | -2 | 2.5 | [NAME] | -2 | [NAME]
-3.3 | -2 | 1 | 3 | -3.3 | Header 1 | 3 | [NAME]
-2.32 | -1 | 7 | 4 | 7 | [NAME] | 4 | [NAME]
Spreadsheet: aad84ff7-a8d2-4236-ad29-97f608248590
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HHV8 | Test | HHV8 | Human [NAME], IgG, Serum | Human Herpesvirus-8, [NAME], IgG, S | Immunofluorescence Assay (IFA) | Serum Gel Tube: SGT |  |  | 0.25 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.25 mL | 0.15 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Negative (reported as positive or negative) | Wednesday; 9 a.m. | 1 day | 7 days | 1 | 86790 |  |  |  |  | Rochester
HHV8 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
HHV8 | Result | 81971 | Human Herpesvirus-8, [NAME], IgG, S | Human Herpesvirus-8, [NAME], IgG, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40834-4 | Herpes virus 8 Ab.IgG:ACnc:Pt:Ser:[NAME]:IF
Spreadsheet: 454140d1459679839-if-inside-if-replacement-if-inside-if
Sheet: Sheet2

 | ORDER | PIZZAS SERVED |  |  |  |  |  |  |  |  |  | PIZZAS SERVED
1 | NAME6 |  |  |  |  |  |  |  |  |  |  | name1 | 1
2 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 3
3 |  |  |  |  |  |  |  |  |  |  |  | name3 | 0
4 |  |  |  |  |  |  |  |  |  |  |  | name4 | 0
5 |  |  |  |  |  |  |  |  |  |  |  | name5 | 2
6 |  |  |  |  |  |  |  |  |  |  |  | name6 | 1
7 |  |  |  |  |  |  |  |  |  |  |  | name7 | 1
Spreadsheet: 79565d1279804311-sorting-one-dataset-with-another-data_sorting
Sheet: TIDES

DATE | HW TIME
2010-03-22 00:00:00 | 08:52:00
 | 21:10:00
2010-03-23 00:00:00 | 09:50:00
 | 22:18:00
2010-03-24 00:00:00 | 11:08:00
 | 23:44:00
2010-03-25 00:00:00 | 12:45:00
2010-03-26 00:00:00 | 01:19:00
 | 14:15:00
2010-03-27 00:00:00 | 02:35:00
 | 15:16:00
2010-03-28 00:00:00 | 03:32:00
 | 16:06:00
2010-03-29 00:00:00 | 04:42:00
 | 16:52:00
2010-03-30 00:00:00 | 05:08:00
 | 17:35:00
2010-03-31 00:00:00 | 05:53:00
 | 18:18:00
2010-04-01 00:00:00 | 06:36:00
 | 18:55:00
2010-04-02 00:00:00 | 07:14:00
 | 19:27:00
2010-04-03 00:00:00 | 07:47:00
 | 19:54:00
2010-04-04 00:00:00 | 08:15:00
 | 20:21:00
2010-04-05 00:00:00 | 08:44:00
 | 20:56:00
2010-04-06 00:00:00 | 09:27:00
 | 21:46:00
2010-04-07 00:00:00 | 10:36:00
 | 23:08:00
2010-04-08 00:00:00 | 12:52:00
2010-04-09 00:00:00 | 01:17:00
 | 13:58:00
2010-04-10 00:00:00 | 02:16:00
 | 14:46:00
2010-04-11 00:00:00 | 03:03:00
 | 15:28:00
2010-04-12 00:00:00 | 03:45:00
 | 16:07:00
2010-04-13 00:00:00 | 04:24:00
 | 16:45:00
2010-04-14 00:00:00 | 05:02:00
 | 17:21:00
2010-04-15 00:00:00 | 05:38:00
 | 17:56:00
2010-04-16 00:00:00 | 06:16:00
 | 18:30:00
2010-04-17 00:00:00 | 06:49:00
 | 19:02:00
2010-04-18 00:00:00 | 07:24:00
 | 19:34:00
2010-04-19 00:00:00 | 08:02:00
 | 20:15:00
2010-04-20 00:00:00 | 08:48:00
 | 21:04:00
2010-04-21 00:00:00 | 09:46:00
 | 22:09:00
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R50

Ime artikla
Spreadsheet: 599541d1543172888-conditional-formatting-not-matching-third-criteria-not-conditionally-formatting-third-criteria
Sheet: Sheet1

Equipment | From | To | Days |  |  |  |  | 2018-01-05 00:00:00 | 2018-01-06 00:00:00 | 2018-01-07 00:00:00 | 2018-01-08 00:00:00 | 2018-01-09 00:00:00 | 2018-01-10 00:00:00 | 2018-01-11 00:00:00 | 2018-01-12 00:00:00 | 2018-01-13 00:00:00 | 2018-01-14 00:00:00 | 2018-01-15 00:00:00
Equipment 4 | 2018-01-07 00:00:00 | 2018-01-09 00:00:00 |  |  |  |  | Equipment 1
Equipment 1 | 2018-01-05 00:00:00 | 2018-01-07 00:00:00
Equipment 2 | 2018-01-09 00:00:00 | 2018-01-12 00:00:00 |  |  |  |  | Equipment 2
Equipment 3 | 2018-01-06 00:00:00 | 2018-01-08 00:00:00
Equipment 1 | 2018-01-11 00:00:00 | 2018-01-11 00:00:00 |  |  |  |  | Equipment 3
Equipment 2 | 2016-01-14 00:00:00 | 2016-01-15 00:00:00
Equipment 5 | 2016-01-08 00:00:00 | 2016-01-08 00:00:00 |  |  |  |  | Equipment 4
Test by adding From and To dates for 2 and 5 in rows 5 and 6 |  |  |  |  |  |  | Equipment 5