tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sara_shackleton__36501__ENE MTM 0630 revised 2
Sheet: Credit Suisse 4-5

Current Date
Termination Date
Interest Payment Date
Quarter End Date
Lowest Date
Phantom Stock Hedge |  | Effective Date | 2000-04-05 00:00:00 | <<<--- (trade ticket says 4/10/00)
Credit Suisse |  | Termination Date | 2000-05-08 00:00:00
 |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  |  |  | Total |  |  |  | Total
 |  |  | Quarter End | Quarter End |  | Quarter End | Quarter End | Quarter End |  | Quarter End | Quarter End | Quarter End |  |  |  | Quarter End | Quarter End | Quarter End |  | Quarter End | Quarter End | Quarter End
ENE |  |  | 2000-06-30 00:00:00 | 2000-06-30 00:00:00 |  | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 |  | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 |  | Year 2000 |  | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 |  | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 |  | Year 2001 |  | LTD
 | Market Price |  | 76.125
Shares: | 790000
Opening price
Interest Payment Dates |  |  | 2000-07-05 00:00:00 |  |  | 2000-07-05 00:00:00 | 2000-10-05 00:00:00 |  |  | 2000-10-05 00:00:00 | 2001-01-05 00:00:00 |  |  |  |  | 2001-01-05 00:00:00 | 2001-04-04 00:00:00 |  |  | 2001-04-04 00:00:00 | 2001-04-04 00:00:00
Equity Payment (CSFB pays if price goes up/Enron pays if price goes down)
 | Opening value
 | Closing Value
 | MTM
Dividend Payment (CSBI pays)
Expected quarterly dividend |  |  | 0 |  |  | 0.125 |  |  |  | 0.125 |  |  |  |  |  | 0.125 |  |  |  | 0.125
Payment
Interest Payment (Enron pays)
Interest Rate |  |  | 0.0627125 |  |  |  | 0.0609 |  |  |  | 0.0609 |  |  |  |  |  | 0.0609 |  |  |  | 0.0609
Spread |  |  | 0.0105 |  |  | 0.0105 | 0.0105 |  |  | 0.0105 | 0.0105 |  |  |  |  | 0.0105 | 0.0105 |  |  | 0.0105 | 0.0105
All in Rate
Annual Day Count |  |  | 365 |  |  | 365 | 365 |  |  | 365 | 365 |  |  |  |  | 365 | 365 |  |  | 365 | 365
Beginning of period
End of period
Day Count
Payment
Net receipt/(payment)
 | 790000
 | 460000
 | 511200
 | 0.03
Spreadsheet: 818252d1676668989-conditional-formatting-using-ranges-from-different-sheets-conditional-sample
Sheet: Sheet2

Golfers | [NAME] | [NAME] | [NAME]
[NAME] | 2 | 0 | 0
[NAME] | 0 | 3 | 0
[NAME] | 0 | 0 | 3
[NAME] | 2 | 0 | 0
[NAME] | 0 | 1 | 0
[NAME] | 0 | 0 | 2
[NAME] | 1 | 0 | 0
Harris English | 0 | 1 | 0
[NAME] | 0 | 0 | 1
Spreadsheet: 125016d1318814420-excel-2007-multiply-if-statements-and-sumifs-volume-sells
Sheet: Cost

Type | Error | Supply | Inventory | Expected Sell | Over [NAME] |  | Expected for Supply | Expected for Inventory
PC | Harddrive | 30 | 50 | 35 | 50
MAC | Harddrive | 65 | 60 | 35 | 50
PC | Monitor | 30 | 44 | 33 | 45
MAC | Monitor | 25 | 20 | 24 | 20
PC | Keyboard | 15 | 30 | 14 | 25
PC | Touchpad | 2 | 4 | 6 | 7
PC | Sound | 1 | NA | NA | NA |  | NA
Spreadsheet: 807863d1670115851-ageing-formula-help-wip-ageing-matt2702-
Sheet: Aged as at June

WIP Closing Balance |  |  |  | Invoiced in mth |  |  |  | Calculated Revenue |  |  |  | Aged WIP at July
Apr | May | June |  | Apr | May | June |  | Apr | May | June |  | Current | 1mth | 2mth | 3mth
500 | 650 | 1350 |  | 0 | 100 | 50 |  |  |  |  |  | 750 | 150
 |  |  |  |  |  |  |  |  | 2022-04-01 00:00:00 |  |  |  |  | 2022-04-01 00:00:00
 |  |  | WIP |  |  |  |  | Inv | 0 | 100 | 50
Month | Rev | Inv | Closing | current | 1mth | 2mth | 3mth
2022-04-01 00:00:00 | 500 | 0
 | 250 | 100
 | 750 | 50
Spreadsheet: 35806d1233506295-summing-values-using-specific-conditions-book12
Sheet: Sheet1

Node | Fed From Node | Amps | Total |  | Nodes Supplied | Total Should Equal
1 |  |  | 2108 |  | 2 thru 20 | 2108
2 | 1 | 1000 | 1750 |  | 3,4,5,6,7,8,9,12 | 2108
3 | 2 | 50 | 750 |  | 5 | 750
4 | 2 | 50 | 80 |  | 6 | 80
5 | 3 | 75 | 700 |  | 7 | 700
6 | 4 | 30 | 30 |  | None | 30
7 | 5 | 25 | 625 |  | 12 | 625
8 | 2 | 25 | 25 |  | None | 25
9 | 2 | 250 | 253 |  | 10 | 253
10 | 9 | 3 | 3 |  | None | 3
11 | 0 | 0 | 0
12 | 7 | 600 | 600 |  | None | 600
13 | 0 | 0 | 0
14 | 0 | 0 | 0
15 | 0 | 0 | 0
16 | 0 | 0 | 0
17 | 0 | 0 | 0
18 | 0 | 0 | 0
19 | 0 | 0 | 0
20 | 0 | 0 | 0
Spreadsheet: 104316d1301947273-excel-2007-dates-and-conditional-formatting-example-book
Sheet: Sheet1

Ratee |  |  | Rater |  |  | Front | Chair | C/O | Comments
Smith | [NAME] | K | Doe | [NAME] | B | 2011-11-22 00:00:00 | 2011-12-06 00:00:00 | 2012-01-10 00:00:00
Doe | [NAME] | B | Smith | [NAME] | K | 2011-12-11 00:00:00 | 2011-12-25 00:00:00 | 2012-01-29 00:00:00
Spreadsheet: 763417d1642165202-what-formula-to-find-a-date-between-date-range-data
Sheet: Lookup

 | Period |  |  | Period | Period Start | Period End | Column1 | Column2
2020-11-20 00:00:00 |  |  |  | P01/2021 | 2020-09-24 00:00:00 | 2020-10-28 00:00:00
2020-11-26 00:00:00 |  |  |  |  |  | 2020-11-25 00:00:00 | 02 | 2021
 |  |  |  |  |  | 2020-12-23 00:00:00 | 03 | 2021
 |  |  |  |  |  | 2021-01-27 00:00:00 | 04 | 2021
 |  |  |  |  |  | 2021-02-24 00:00:00 | 05 | 2021
 |  |  |  |  |  | 2021-03-24 00:00:00 | 06 | 2021
 |  |  |  |  |  | 2021-04-28 00:00:00 | 07 | 2021
 |  |  |  |  |  | 2021-05-26 00:00:00 | 08 | 2021
 |  |  |  |  |  | 2020-06-23 00:00:00 | 09 | 2021
 |  |  |  |  |  | 2021-07-28 00:00:00 | 10 | 2021
 |  |  |  |  |  | 2021-08-25 00:00:00 | 11 | 2021
 |  |  |  |  |  | 2021-09-22 00:00:00 | 12 | 2021
 |  |  |  |  |  | 2021-10-27 00:00:00 | 01 | 2022
 |  |  |  |  |  | 2021-11-24 00:00:00 | 02 | 2022
 |  |  |  |  |  | 2021-12-22 00:00:00 | 03 | 2022
 |  |  |  |  |  | 2022-01-26 00:00:00 | 04 | 2022
 |  |  |  |  |  | 2022-02-23 00:00:00 | 05 | 2022
 |  |  |  |  |  | 2022-03-23 00:00:00 | 06 | 2022
 |  |  |  |  |  | 2022-04-27 00:00:00 | 07 | 2022
 |  |  |  | The Formula IF(AND(E66732>=Sheet1!$N$2,E66732<=Sheet1!$O$2),Sheet1!$M$2,IF(AND(E66732>=Sheet1!$N$3,E66732<=Sheet1!$O$3),Sheet1!$M$3,IF(AND(E66732>=Sheet1!$N$4,E66732<=Sheet1!$O$4),Sheet1!$M$4,IF(AND(E66732>=Sheet1!$N$5,E66732<=Sheet1!$O$5),Sheet1!$M$5,IF(AND(E66732>=Sheet1!$N$6,E66732<=Sheet1!$O$6),Sheet1!$M$6,IF(AND(E66732>=Sheet1!$N$7,E66732<=Sheet1!$O$7),Sheet1!$M$8,IF(AND(E66732>=Sheet1!$N$9,E66732<=Sheet1!$O$9),Sheet1!$M$9,IF(AND(E66732>=Sheet1!$N$10,E66732<=Sheet1!$O$10),Sheet1!$M$10,IF(AND(E66732>=Sheet1!$N$11,E66732<=Sheet1!$O$11),Sheet1!$M$11,IF(AND(E66732>=Sheet1!$N$12,E66732<=Sheet1!$O$12),Sheet1!$M$12,IF(AND(E66732>=Sheet1!$N$13,E66732<=Sheet1!$O$13),Sheet1!$M$13,IF(AND(E66732>=Sheet1!$N$14,E66732<=Sheet1!$O$14),Sheet1!$M$14,IF(AND(E66732>=Sheet1!$N$15,E66732<=Sheet1!$O$15),Sheet1!$M$15)))))))))))))
Spreadsheet: 684464d1593377893-how-to-randomly-return-a-cell-value-based-on-a-criteria-sample-suji01-
Sheet: One

Code | ID
[NAME] | 1
G2 | 1
G3 | 1
G4 | 1
F1 | 3
F2 | 3
F3 | 3
F4 | 3
Spreadsheet: 867434d1714290805-combine-two-filter-formulas-help
Sheet: DeadSummary

 | title | title | title | title
title | title | title | title | title
 | GTGTG243126100242 | B0 | 0 | 0
 | GTGTG283679400151 | B2 | 1 | 2
 | GTGTG320509101638 | B0 | 0 | 0
 | GTGTG320509300492 | B0 | 0 | 0
 | GTGTG320509401648 | B4 | 4 | 11
 | GTGTG320509601671 | B2 | 1 | 2
 | GTGTG742183500713 | B0 | 0 | 0
 | GTGTG745205100320 | B0 | 0 | 0
 | GTGTG745205200426 | B0 | 0 | 0
 | GTGTG745205400785 | B2 | 1 | 2
 | GTGTG745205600437 | B2 | 1 | 2
 | GTGTG745205700431 | B0 | 0 | 0
 | GTGTG745205700585 | B4 | 3 | 8
 | GTGTG745656100326 | B0 | 0 | 0
 | GTGTG745656100515 | B0 | 0 | 0
 | GTGTG745656100536 | B0 | 0 | 0
 | GTGTG745656100550 | B0 | 0 | 0
 | GTGTG745656100592 | B0 | 0 | 0
 | GTGTG745656100641 | B2 | 1 | 2
 | GTGTG745656100690 | B2 | 1 | 2
 | GTGTG745656100732 | B0 | 0 | 0
 | GTGTG745656100767 | B0 | 0 | 0
 | GTGTG745656100774 | B0 | 0 | 0
 | GTGTG745656100795 | B0 | 0 | 0
 | GTGTG745656100823 | B0 | 0 | 0
 | GTGTG745656100872 | B0 | 0 | 0
 | GTGTG745656100921 | B3 | 2 | 3
 | GTGTG745656100935 | B5 | 3 | 15
Spreadsheet: 367836d1420133623-solved-help-want-to-subtract-values-based-on-if-check-box-is-checked-test
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
[NAME] | 135
bill 2 | 220
bill 3 | 800
[NAME] | 50
Spreadsheet: darrell_schoolcraft__7799__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | Gas Nomination for 6th = 50,000
 |  |  | SoCal Gas Price |  | 3.56
 |  |  | San Juan Gas Price |  | 2.49
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
he 6 | 07:00:00 |  | 0 | 0 | 0 | 234 | 7
he 7 | 08:00:00 |  | 0 | 0 | 0 | 241 | 7
he8 | 09:00:00 |  | 0 | 0 | 0 | 241 | 7
he9 | 10:00:00 |  | 0 | 0 | 0 | 241 | 7
he10 | 11:00:00 |  | 0 | 0 | 0 | 241 | 7
he11 | 12:00:00 |  | 0 | 0 | 0 | 241 | 7
he12 | 13:00:00 |  | 0 | 0 | 0 | 241 | 7
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 241 | 7
he14 | 15:00:00 |  | 0 | 0 | 0 | 241 | 7
he15 | 16:00:00 |  | 0 | 0 | 0 | 241 | 7
he16 | 17:00:00 |  | 0 | 0 | 0 | 380 | 7
he17 | 18:00:00 |  | 0 | 0 | 0 | 380 | 7
he18 | 19:00:00 |  | 0 | 0 | 0 | 380 | 7
he19 | 20:00:00 |  | 0 | 0 | 0 | 380 | 7
he20 | 21:00:00 |  | 0 | 0 | 0 | 380 | 7
he21 | 22:00:00 |  | 0 | 0 | 0 | 380 | 7
he22 | 00:00:00 |  | 0 | 0 | 0 | 380 | 7
he23 | 01:00:00 |  | 0 | 0 | 0 | 380 | 7
he24 | 02:00:00 |  | 0 | 0 | 0 | 380 | 7
he1 | 03:00:00 |  | 0 | 0 | 0 | 380 | 7
he2 | 04:00:00 |  | 0 | 0 | 0 | 380 | 7
he3 | 05:00:00 |  | 0 | 0 | 0 | 380 | 7
he4 | 06:00:00 |  | 0 | 0 | 0 | 380 | 7
[NAME] | 07:00:00 |  | 0 | 0 | 0 | 380 | 7
Spreadsheet: 92020d1291694479-data-layout-between-row-and-column-test
Sheet: Steps taken

Steps
1 | Highlighted A1:C16 on the How it looks tab.
2 | Hit Ctrl+C (Copy).  [Alternatively, right click, choose Copy]
3 | Selecting cell A11 below.
4 | Right click, [NAME].
5 | Check off Values.
6 | Check off Transpose.  (as in the sample below)
7 | Hit OK.
8 | The results are as you see below.
Applicant |  | Application ID | Contact |  |  | Project title | Program | Proposed Project Area | Project type | Funding Round | Grant request* | Loan request | Status | Description | Public Notice Response
This |  | is | Testing |  |  | using | another | column | with | some | extra | data.
Spreadsheet: 275065d1383321404-need-to-merege-duplicate-row-values-with-varying-column-values-into-one-row-book2-solution-fixed
Sheet: Sheet1

Inspection Report
Unit Number | Description | Annual Lift | DOT Inspection | Crane Inspection | Dielectric Test | Manufacture Major Inspection | Location | Service Days | Equipment Status
2510087 | 67 Pole Trailer |  | 2/18/2012 |  |  |  | 25170710 | 365 | AV - Available
2510133 | 68 Assmbl Dualtand Pl Trl |  | 9/20/2012 |  |  |  | [PHONE] | 365 | AV - Available
2510448 | 77 Truco Reel Trailr |  | 7/11/2013 |  |  |  | 25180710 | 365 | DN - Down
2510565 | [NAME] |  | 11/27/2006 |  |  |  | 25180710 | 365 | AV - Available
2510579 | 74 Bomb. W/Crane |  |  | 2/15/2012 |  |  | 25190710 | 365 | DN - Down
2510579 | 74 Bomb. W/Crane |  |  |  | 9/1/2012 |  | 25190710 | 365 | DN - Down
2510581 | 2 Reel Wire Trlr |  | 5/17/2013 |  |  |  | [PHONE] | 365 | AV - Available
2510582 | Tand 5Th Wheel Dolly |  | 9/1/2012 |  |  |  | 25170710 | 365 | AV - Available
2510598 | Tandem 5th Wheel Dolly |  | 9/1/2012 |  |  |  | 25190710 | 365 | AV - Available
2510605 | 81 Grove Rt518 Crane |  |  | 11/14/2004 |  |  | 25190710 | 365 | DS - Down - In Shop
2510605 | 81 Grove Rt518 Crane |  |  |  | 9/1/2012 |  | 25190710 | 365 | DS - Down - In Shop
2510634 | 2 Reel Wire Trlr |  | 6/28/2012 |  |  |  | 25170710 | 365 | AV - Available
2510736 | S/A Reel Trlr    Dist |  | 11/16/2005 |  |  |  | 25170710 | 365 | AV - Available
2510839 | 88 S/A Butler Reel Trlr |  | 5/10/2013 |  |  |  | 25190710 | 365 | DN - Down
2510850 | 76 Bomb W/Digger |  |  | 9/1/2011 |  |  | 25190710 | 365 | DN - Down
2510850 | 76 Bomb W/Digger |  |  |  | 9/1/2012 |  | 25190710 | 365 | DN - Down
2510854 | 89 Sm. Pole Trailer |  | 9/27/2005 |  |  |  | 25170710 | 365 | AV - Available
2510884 | Platform 24' One-Man |  |  | 9/1/2012 |  |  | 25180770 | 365 | AV - Available
2510911 | 88 Butler 10T Eq Trailer |  | 1/11/2013 |  |  |  | [PHONE] | 365 | WK - Working
2510913 | 89 Pole/Material Trl |  | 11/27/2012 |  |  |  | [PHONE] | 365 | WK - Working
2510914 | 89 Pole/Material Trl |  | 10/3/2012 |  |  |  | 25180710 | 365 | AV - Available
2510915 | 89 Pole/Material Trl |  | 6/27/2012 |  |  |  | 25170710 | 365 | AV - Available
2510916 | 89 Pole/Material Trl |  | 7/17/2007 |  |  |  | 25170710 | 365 | DN - Down
2510917 | 89 Pole/Material Trl |  | 8/30/2013 |  |  |  | [PHONE] | 365 | WK - Working
2510918 | 89 Pole/Material Trl |  | 6/12/2013 |  |  |  | [PHONE] | 365 | WK - Working
2510919 | 89 Pole/Material Trl |  | 6/5/2012 |  |  |  | [PHONE] | 365 | AV - Available
2510920 | 89 Pole/Material Trl |  | 6/7/2013 |  |  |  | [PHONE] | 365 | WK - Working
2510965 | 89 Sm. Pole Trailer |  | 1/10/2013 |  |  |  | [PHONE] | 365 | WK - Working
2510971 | 79 Dorsy Van Trlr |  | 6/19/2013 |  |  |  | [PHONE] | 365 | WK - Working
2510972 | [NAME] W/48 Bull" |  | 2/18/2013 |  |  |  | [PHONE] | 365 | DN - Down
2510976 | 91 IHC Tractor 6X4 |  |  | 9/1/2012 |  |  | [PHONE] | 365 | WK - Working
2510976 | 91 IHC Tractor 6X4 |  | 8/22/2013 |  |  |  | [PHONE] | 365 | WK - Working
Spreadsheet: 540366d1506659587-please-critique-my-spreadsheet-payroll-worksheets-year-2017
Sheet: May 2017 Summary

May 2017 Summary |  | Total Job Hours
# |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
Job
1 |  |  | x
2 |  |  |  | x
3 |  |  |  |  | x
4 |  |  |  |  |  | x
5 |  |  |  |  |  |  | x
6 |  |  |  |  |  |  |  | x
7 |  |  |  |  |  |  |  |  | x
8 |  |  |  |  |  |  |  |  |  | x
9 |  |  |  |  |  |  |  |  |  |  | x
 | less shop hours
 | Hours less Shop
7 |  |  |  |  |  |  |  |  | x
9 |  |  |  |  |  |  |  |  |  |  | x
10 |  |  |  |  |  |  |  |  |  |  |  | x
11 |  |  |  |  |  |  |  |  |  |  |  |  | x
12 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  | 0 | 0
 | less shop hours
 | Hours less Shop
Hours without Shop
Shop Hours
Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
%
Vehicles
 | Fuel | 1104.16
 | Repairs & Maintenance | 3372.85
 | Overhead | 14105.03
 |  | 0.75
Spreadsheet: 877491d1724318330-redundancy-calc-with-a-difference-a-formula-question-thenewunion-redundancy-calc-with-a-difference-v3-spill-365-aligw
Sheet: Sheet1

 | Redundancy Calc with a difference
 |  |  |  |  | Age @ | Years | Age @ | Completed | Total
 | Employee Name | DOB | Hire Date | Exit Date | Hire | Worked | Exit | Years | Weeks | Status | Expected Output
 | Empl 001 | 1990-09-30 00:00:00 | 2009-03-09 00:00:00 | 2024-08-13 00:00:00 |  |  |  |  | 13 | Correct | 13 |  | Perfect!
 | Empl 002 | 1974-03-22 00:00:00 | 2008-01-04 00:00:00 | 2024-10-31 00:00:00 |  |  |  | 16 | 20.5 | Correct | 20.5 |  | Perfect!
 | Empl 003 | 1980-04-18 00:00:00 | 2020-07-27 00:00:00 | 2024-12-31 00:00:00 |  |  |  | 4 | 5.5 | Correct | 5.5 |  | Perfect!
 | Empl 004 | 1969-04-03 00:00:00 | 2008-06-25 00:00:00 | 2025-03-06 00:00:00 |  |  |  | 16 | 23 | Correct | 23 |  | Perfect!
 | Empl 008 | 1990-07-21 00:00:00 | 2012-12-03 00:00:00 | 2024-11-30 00:00:00 |  |  |  | 11 | 11 | Correct | 11 |  | Perfect!
 |  | 0.5 week’s pay for each full year worked when you’re under 22
 |  | 1 week’s pay for each full year worked when you’re between 22 and 41
 |  | 1.5 week’s pay for each full year worked when you’re 41 or older
Spreadsheet: 67409d1268056852-excel-2007-adjusting-stock-level-formula-testinventory
Sheet: Stock Database

PRODUCT CODE | PRODUCT DESCRIPTION | QTY PER PACK/BOX | CURRENT STOCK LEVEL | COST PRICE (£) | RETAIL PRICE (£) | QUANTITY SOLD | TOTAL PROFIT (£)
40001 | Rotadex Steel Bookends | 2 | 491 | 4.194 | 6.99 | 12 | 33.55200000000001
40002 | Strong Metal Bookends | 2 | 478 | 4.794 | 7.99 | 23 | 73.508
40003 | Stackable Letter Trays | 1 | 478 | 0.954 | 1.59 | 24 | 15.264
40003A | Stackable Letter Trays | 6 | 478 | 4.644 | 7.74 | 25 | 77.4
40004 | Avery Standard Letter Trays | 1 | 472 | 0.954 | 1.59 | 32 | 20.352
40005 | Extendable Letter Trays | 1 | 457 | 11.994 | 19.99 | 45 | 359.8199999999999
40006 | Universal Letter Tray Risers | 4 | 467 | 0.624 | 1.04 | 34 | 14.144
Spreadsheet: 707136d1607052987-how-to-programmatically-select-a-range-programmatically-select-a-range
Sheet: シート1

 |  | ⁕ | † | ⁑ | ‡
2020-11-29 23:59:00 |  | 70 | -10.79 | 10 | 10
2020-11-30 23:59:59
2020-12-01 23:59:59 |  | 50
 |  |  |  | 4
2020-12-02 23:59:59
 |  | 45
2020-12-03 00:00:00 |  |  |  |  | 10
 |  | 70
2020-12-04 00:00:00
 |  |  |  |  | 15
2020-12-05 23:59:59 |  | 75
2020-12-06 23:59:59 |  |  |  | 10
2020-12-07 23:59:59 |  | 90
Spreadsheet: 37687d1235721574-to-find-more-than-1-matches-in-a-list-to-find-more-than-1-matches-in-a-list
Sheet: Sheet1

A1 | A1 | 1 | 7
A2 | B1 | 4 | 10
A3 | C1 | 9
A4 | A2
A5 | D1 | 11
A6 | D3 | 12
A7 | A1
 | B1
 | A3
 | A2
 | A5
 | A6
Spreadsheet: 186753d1350195876-get-the-data-from-two-different-sheets-shiftsab-indirect
Sheet: DayNight

 |  | Emp No | Emp Name | 8-9 AM | 10-11 AM | 12-2 PM | 4-5 PM | 8-9 PM | 12-1 AM | 4-5 AM
 |  |  |  | Break Fast | Brunch | Lunch | [NAME] | Dinner | Snacks | Morning Tea
Shift A | Day | 2012002 | Name1
Shift A | Day | 2012005 | [NAME]
Shift A | Day | 2012020 | Name3
Shift A | Day | 2012119 | Name4
Shift A | Day | 2013038 | Name5
Shift A | Day | 2013037 | Name6
Shift A | Day | 2012055 | Name7
Shift A | Day | 2012009 | Name8
Shift A | Day | 2013041 | Name9
Shift B | Night | 2012003 | Name10
Shift B | Night | 2012038 | Name11
Shift B | Night | 2012035 | Name12
Shift B | Night | 2012071 | Name13
Shift B | Night | 2012075 | Name14
Shift B | Night | 2012143 | Name15
Shift B | Night | 2012022 | [NAME]
Spreadsheet: 787307d1657722171-find-cell-based-on-date-index-and-matching-excelfiles1
Sheet: Blad2

What it should look like:
Transport | Last checkup | Next checkup week | Type of checkup
#1
#2
#3
#4
#5
#6
Spreadsheet: 858d94c6-5de4-4aa8-b1b2-3db240a8f365
Sheet: PAG 1

Financial highlights - Ambev consolidated |  |  | % As | %
R$ million | 1Q10 | 1Q11 | Reported | Organic
Total volumes | 40926.55474770147 | 40796.58271634969 | -0.003175738396574479 | 0.001591002983578252
Beer | 29399.28819813865 | 29476.01799018704 | 0.002609920061032112 | 0.008254271480754765
CSD and NANC | 11527.26654956282 | 11320.56472616265 | -0.01793155580392236 | -0.0154299655087717
Net sales | 6121.422 | 6562.098 | 0.0719891554609371 | 0.1054048686673996
Gross profit | 4122.396999999999 | 4455.01 | 0.08068436882716568 | 0.1130049561937958
Gross margin | 0.6734378057908765 | 0.6789002541565213 | 50 | 50
EBITDA | 2773.95 | 3097.969 | 0.1168078011499847 | 0.1374124756654107
EBITDA margin | 0.453154512137866 | 0.4721003861874663 | 190 | 130
Normalized EBITDA | 2806.538 | 3098.507 | 0.1040317287704637 | 0.1244372619748208
Normalized EBITDA margin | 0.4584781117851375 | 0.4721823721620737 | 140 | 80
Profit - Ambev holders | 1650.195999999999 | 2088.674 | 0.2657126789787407
Normalized profit - Ambev holders | 1716.614999999999 | 2089.212 | 0.2170533287895082
No. of share outstanding (millions) | 3082.1711831 | 3103.536488
EPS (R$/shares) | 0.5354005024277261 | 0.6729980485410682 | 0.2569992846278968
Normalized EPS | 0.5569499219940971 | 0.6731713991693209 | 0.2086749141809838
Spreadsheet: 228453d1366120535-compare-data-in-two-sheets-and-write-it-in-another-sheet-in-same-workbook-excel_help
Sheet: departures

Serial Number | Date | Model | Barcode | User
CNU80111SQ | 2013-04-09 00:00:00 | HP6720S | TRAVI002979 | ALEX
CNU80115DV | 2013-04-09 00:00:00 | HP6720S | TRAVI000131 | [NAME]
CNU80111SQ | 2013-04-17 00:00:00 | HP6720S | TRAVI002979 | HENRY
Spreadsheet: b3ffb97e-c1ca-4d5d-9cab-c89051933257
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6950 | 32167 | [NAME] | Ranford | NZL | 31 | [NAME] | 00:00:00 | 00:33:09 | 00:00:00 | 00:10:18 | 1 | 01:00:22
6950 | 32169 | Leighton | [NAME] | NZL | 32 | 00:19:23 | 00:00:00 | [NAME] | 00:00:00 | 00:11:18 | 2 | 01:08:16
Spreadsheet: 138619d1327768574-excel-2007-performing-calculations-in-cells-2012-income
Sheet: sept visa

0
 |  | yes | Amount | Amount Deposited | Fee Deducted | Taxable Merch | Shipping Taxable | Sales Tax Payable | Non- taxable Merch | Shipping Non-Taxable | Income Tax Income | Misc NonTaxable | Owner Loan
Bank Posting Date | Received From | Invoices Paid | 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
 |  |  |  |  | 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
 |  |  |  |  | 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
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: 294839ad-c7ff-466c-87d7-a3e8ddd4f1ba
Sheet: Sheet1

Table S8. Intersection between IRF8 target lists from Ref. [31] and those from the present study. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
N/A = Not Assessed (Not included in expression arrays or ChIP arrays)
[NAME] | Regulated by IFNγ/CpG | Affected by Tuberculosis infection | IRF8 target site | Comments
ACTG1
BCL11A
C7orf55 ([NAME])
CAPZA1 |  | yes | IRF8_174
CBX6 (NPTXR) |  | yes
CCRK
CD244 |  | yes
CD36 |  | yes |  | contain many alternative promoters, but only 1 is represented on the array
CD38 | yes | yes
CD53 |  | yes | IRF8_176
CD74 | yes | yes | IRF8_128
CD82 | yes | yes
COQ10B
CTSS |  | yes | IRF8_171
CUGBP2 (CELF2) |  | yes |  | contain many alternative promoters, but only 1 is represented on the array
DARS2
DDX58 |  | yes
DHRS9
DHX58 | yes | yes
DPH3 (ZCS12) |  | yes
EDG3 (S1PR3)
FLJ20035 (DDX60) |  | yes
GPNMB |  | yes
GPR18 | yes | yes | IRF8_86
IFI35 |  | yes | IRF8_44
IFIT1 |  | yes | IRF8_137
IRF9 |  | yes | low (1.74 p=2e-2)
ISG20 |  | yes | IRF8_257
ITPR3 | yes |  | low (1.85 p=7.2e-4)
KCNMB1
[NAME]
KIAA0152 (MLEC) | yes | yes
KIAA0494 (4732418C07Rik)
LY86 | yes | yes | IRF8_62
LYN |  | yes
MAD1L1
MARCH3 |  | yes
MEF2D
METTL7B
MICAL1 |  | yes
MOBKL2A |  | yes
MOV10 |  |  | IRF8_174
MS4A7 | yes | yes
MT2A (MT2) |  |  | low (2.12 p=3.17e-2)
MX1 |  | yes |  | This human Mx1 site is outside the coverage of our array
NCF4 |  | yes
NCOA7 |  | yes | low (1.82 p=2.54e-2)
NLRP3 (CIAS1) |  | yes | IRF8_28
NUDCD2 |  | yes
OAS1 |  | yes
OAS2 |  | yes | low
OAS3 |  | yes | low
PARP9 |  | yes | IRF8_100
PDE7A |  | yes
PGM3 |  | yes
PIPOX
PKIB |  | yes | low (12.82 p=6.33e-2)
PLD1
PLDN |  | yes
PPM1M |  |  | low (1.87 p=1.82e-2)
PTGER4 |  | yes
RECK |  | yes
RTP4 |  | yes | IRF8_96
RUNX2 |  | yes | low (2.02 p=1.04e-1)
S100A10 | yes
SASH1 |  | yes
SDC2 |  | yes
SLC15A3 | yes | yes | IRF8_130
SLC2A6 | yes | yes | low (1.82 p=3.11e-4)
SP110 |  | yes
SPAST |  | yes
STAT1 |  | yes
STAT2 |  | yes
TFAM
TLR4 |  | yes | IRF8_194
TMEM116 |  |  | IRF8_220
TMEM123 |  | yes
TNFSF13B |  | yes | IRF8_271
USP18 | yes | yes | IRF8_239
VPS25
XAF1 | yes | yes | low (2.29 p=8.61e-3)
ZFP36 | yes | yes
ZNF342 (ZNF296) |  |  | IRF8_249
[NAME] (ZNF385A) | yes
Genes available for comparison | 78 | 83 | 70
Total | 16 | 58 | 30
Percent overlap | 0.2051282051282051 | 0.6987951807228916 | 0.4285714285714285