tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 550417d1512315453-compare-items-in-1-table-under-multiple-criteria-and-match-totals-from-income-and-expense
Sheet: Sheet1

Month | Account | Expense | Income | Description | No of Matches | Total |  |  | I need to match items in a table.
Apr | 1111 | 500 |  | Invoice | 1 |  |  |  | They need to match on Month, Account, Description and Expense / Income.
Apr | 1111 |  | 500 | Invoice | 1 |  |  |  | So if Income = 500, it needs to be matched against  Expense = 500.
Apr | 2222 | 800 |  | Other | 0
May | 1111 | 500 |  | Invoice | 0 |  |  |  | Where the match is not a 1 to 1 match but rather a >1 to 1 Match, I need to identify these separately.
May | 2222 |  | 800 | Other | 0 |  |  |  | This happens in June to the Left
May | 2222 |  | 500 | Invoice | 0
Jun | 3333 | 200 |  | Invoice | 2 |  |  |  | I ntried to do this using count ifs with conditional formatting but as soon as I had 2 or more to 1 matches, it no longer worked.
Jun | 3333 |  | 200 | Invoice | 1 |  |  |  | I need 1 to 1 Matches identified separately from 2 to 1 Matches.
Jun | 3333 |  | 200 | Invoice | 1 |  |  |  | In June to the left, I would need all 3 items to be identified separately so that I can filter.
 |  |  |  |  |  |  |  |  | Because Lines 9 & 10 say 1 as opposed to 2, I cannot filter for these items.
 |  |  |  |  |  |  |  |  | Can anyone help please?
 | Row Labels | Sum of Total |  | << Is this what you want??
 | 1111 | -500
 | 2222 | 500
 | 3333 | 200
 | Grand Total | 200
My failed attempt is below.
It requries splitting the table into  2, I would prefer not if possible.
Month | Account | Expense | Income | Description | [NAME] |  |  |  | Month | Account | Expense | Income | Description | [NAME] |  | Step 1
Apr | 1111 | 500 |  | Invoice |  |  |  |  | Apr | 1111 |  | 500 | Invoice
Apr | 2222 | 800 |  | Other |  |  |  |  | May | 2222 |  | 800 | Other
May | 1111 | 500 |  | Invoice |  |  |  |  | May | 2222 |  | 500 | Invoice
Jun | 3333 | 200 |  | Invoice |  |  |  |  | Jun | 3333 |  | 200 | Invoice
 |  |  |  |  |  |  |  |  | Jun | 3333 |  | 200 | Invoice
Month | Account | Expense | Income | Description | [NAME] |  |  |  |  |  |  |  |  |  |  | Step 2
Apr | 1111 | 500 |  | Invoice | 1
Apr | 1111 |  | 500 | Invoice | 1
Apr | 2222 | 800 |  | Other | 0
May | 1111 | 500 |  | Invoice | 0
May | 2222 |  | 500 | Invoice | 0
May | 2222 |  | 800 | Other | 0
Jun | 3333 | 200 |  | Invoice | 2
Jun | 3333 |  | 200 | Invoice | 1
Jun | 3333 |  | 200 | Invoice | 1
Spreadsheet: 156131d1337185612-creating-a-staff-rota-new-rota
Sheet: Sheet1

Week Commencing: |  | 3/0612 |  |  |  |  |  |  |  |  |  |  |  |  | Wage Cost:
Week No: | 40 | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9
Name | Contract | Sun | Hours | Mon | Hours | [NAME] | Hours | Wed | Hours | Thurs | Hours | Fri | Hours | Sat | Hours | Total | Extra
DAVE H | 39 |  |  | 8-4 |  |  |  |  |  |  |  |  |  |  |  | 0 | -39
MICHELLE | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -29
CRAIG | 39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -39
DANNY | 39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -39
GEORGE | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -24
SUSAN | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -30
VICKI | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -16
ROZ | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -16
HAYLEY | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -16
WENDY | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -16
DANNI | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -20
TASH | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -12
TERRI | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -16
LESLEY | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -16
MARIE | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -20
REBECCA | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 364 |  |  |  |  |  |  |  |  |  |  |  |  | Totals |  | 0 | -364
Spreadsheet: 201882d1356185246-is-there-a-way-to-invert-a-column-invertunsortedlist
Sheet: Sheet1

Places |  | [NAME] |  |  | Places |  | Non-continuous Inverted
Auchterderran |  | [NAME] |  |  | Auchterderran |  | [NAME]
[NAME] |  | Carnbee |  |  |  |  | Carnbee
[NAME] |  | Anstruther |  |  | [NAME] |  | Anstruther
Balfarg Henge |  | Auchtermuchty |  |  | Balfarg Henge |  | Auchtermuchty
[NAME] Circle |  | Ceres |  |  | [NAME] Circle |  | Ceres
Buckhaven |  | Cellardyke |  |  | Buckhaven |  | Cellardyke
[NAME] |  | [NAME] |  |  | [NAME] |  | [NAME]
[NAME] |  | Arncroach |  |  | [NAME] |  | Arncroach
Auchmuirbridge |  | Balgeddie House |  |  | Auchmuirbridge |  | Balgeddie House
Auchtertool |  | Burntisland |  |  | Auchtertool |  | Burntisland
Dogton Stone |  | Donibristle |  |  |  |  | Donibristle
Dalgety Bay |  | Carnock |  |  | Dalgety Bay |  | Carnock
[NAME] |  | Dunfermline |  |  | [NAME] |  | Dunfermline
[NAME] |  | [NAME] |  |  | [NAME] |  | [NAME]
Dunfermline |  | [NAME] |  |  | Dunfermline |  | [NAME]
Carnock |  | Dalgety Bay |  |  | Carnock |  | Dalgety Bay
Donibristle |  | Dogton Stone |  |  | Donibristle
Burntisland |  | Auchtertool |  |  | Burntisland |  | Auchtertool
Balgeddie House |  | Auchmuirbridge |  |  | Balgeddie House |  | Auchmuirbridge
Arncroach |  | [NAME] |  |  | Arncroach |  | [NAME]
[NAME] |  | [NAME] |  |  | [NAME] |  | [NAME]
Cellardyke |  | Buckhaven |  |  | Cellardyke |  | Buckhaven
Ceres |  | [NAME] Circle |  |  | Ceres |  | [NAME] Circle
Auchtermuchty |  | Balfarg Henge |  |  | Auchtermuchty |  | Balfarg Henge
Anstruther |  | [NAME] |  |  | Anstruther |  | [NAME]
Carnbee |  | [NAME] |  |  | Carnbee
[NAME] |  | Auchterderran |  |  | [NAME] |  | Auchterderran
Spreadsheet: 09ae7a7e-fc8e-4eba-b5c4-1e2036a9c697
Sheet: 3 - Truck Traffic

ATTACHMENT 3:  Truck Traffic
Existing Truck Traffic
Source: Truck Traffic Turning Movement Counts,
Contra Costa County Public Works Department, May 12-15, 2008
Vasco Road North of Camino Diablo (5:00-18:00)
 | Number of Vehicles
Truck Count | 467
Bus Count | 10
Traffic Count | 13291
Percentage of Truck Traffic
Vasco Road South of Camino Diablo (5:00-18:00)
 | Number of Vehicles
Truck Count | 642
Bus Count | 7
Traffic Count | 15618
Percentage of Truck Traffic
Spreadsheet: 177922d1346521532-how-to-add-multiple-axis-in-the-chart-c-vs-p
Sheet: Sheet1

 | Year Vs Avg Paid
 | Year | Capital |  | Chemical |  | Project |  | Service |  | Spares & Consumables |  | Welfare & Safety |  | Total
 |  | Paid | [NAME]. | Paid | [NAME]. | Paid | [NAME]. | Paid | [NAME]. | Paid | [NAME]. | Paid | [NAME]. | Paid | [NAME].
 | 2009 | 1.51416701008018 | 0.2163095728685971 | 0.706943376 | 0.1009919108571429 | 2.41260505 | 0.3446578642857143 | 0.381588006965636 | 0.05451257242366229 | 14.2717723783826 | 2.038824625483229 | 0.473799897563001 | 0.06768569965185729 | 19.76087571899142 | 2.822982245570202
 | 2010 | 2.95847281855556 | 0.2465394015462966 | 0 | 0 | 4.417454596611109 | 0.3681212163842591 | 1.84582919902222 | 0.1538190999185183 | 16.90306961825 | 1.408589134854167 | 0.9167277014444449 | 0.07639397512037041 | 27.04155393388334 | 2.253462827823611
 | 2011 | 5.18706724511111 | 0.4322556037592591 | 0.23882665 | 0.01990222083333333 | 2.33583847138889 | 0.1946532059490742 | 2.90319622978889 | 0.2419330191490742 | 18.1561552169483 | 1.513012934745692 | 0.7940700980222221 | 0.06617250816851851 | 29.61515391125941 | 2.467929492604951
 | 2012 | 3.23756011345833 | 0.4046950141822912 | 0.244358961111111 | 0.03054487013888888 | 0.20881862 | 0.0261023275 | 1.32683107076778 | 0.1658538838459725 | 8.871180126993892 | 1.108897515874236 | 0.511045799255556 | 0.0638807249069445 | 14.39979469158667 | 1.799974336448333
 | Total | 12.89726718720518 | 1.299799592356444 | 1.190128987111111 | 0.1514390018293651 | 9.374716738 | 0.9335346141190476 | 6.457444506544527 | 0.6161185753372274 | 58.20217734057479 | 6.069324210957324 | 2.695643496285224 | 0.2741329078476907 | 90.81737825572084 | 9.344348902447098
 | Year Vs Production
 | Year | Production | A Avg. Production |  | Year | Production | B Avg. Production
 | 2008 | 552000 | 1514 |  | 2008 |  | 0
 | 2009 | 903000 | 2472 |  | 2009 | 282716 | 775
 | 2010 | 1055000 | 2890 |  | 2010 | 314088 | 861
 | 2011 | 1411000 | 3866 |  | 2011 | 391017 | 1071
 | 2012 | 963000 | 3931 |  | 2012 | 239619 | 978
Spreadsheet: 8713e446-6f5b-48fb-b5f4-6070766823fb
Sheet: Sheet1

Table 2a: 2010-based Subnational Population Projections by sex and quinary age
Long-term subnational population projections are an indication of the future trends in population by age and sex over the next 25 years.
They are trend-based projections, which means assumptions for future levels of births, deaths and migration are based on observed levels
mainly over the previous five years. They show what the population will be if recent trends continue.
The projected resident population of an area includes all people who usually live there, whatever their nationality.  People moving into or
out of the country are only included in the resident population if their total stay in that area is for 12 months or more, thus visitors and
short-term migrants are not included. Armed forces stationed abroad are not included, but armed forces stationed within an area are included.
Students are taken to be resident at their term-time address.
The projections do not take into account any policy changes that have not yet occurred, nor those that have not yet had an impact on observed
trends. They are constrained at the national level to the national projections published on 26 October 2011.
These projections published on 21 March 2012 are based on the indicative 2010 mid-year population estimates published on 17 November 2011.
Further tables and information about this release are available from the ONS website at:
http://www.ons.gov.uk/ons/rel/snpp/sub-national-population-projections/2010-based-projections/index.html
Breakdown figures may be available on request. For further information please email [EMAIL] or telephone 01329 444652.
These data are on administrative geographic boundaries in place from 1 April 2009.
Information on 2009 geographic boundary changes:
Cheshire East UA comprises the former districts of Congleton, Crewe and [NAME] and [NAME].
Cheshire West and Chester UA comprises the former districts of Chester, Ellesmere Port & Neston and Vale Royal.
County Durham UA comprises the former districts of Chester-le-Street, Derwentside, Durham, Easington, Sedgefield, Teesdale and Wear Valley.
Northumberland UA comprises the former districts of Alnwick, Berwick-upon-Tweed, Blyth Valley, [NAME], Tynedale and Wansbeck.
Under the terms of the Open Government Licence (OGL) and UK Government Licensing Framework, anyone wishing to use or re-use
ONS material, whether commercially or privately, may do so freely without a specific application for a licence, subject to the conditions
of the OGL and the Framework. To view this licence, go to: http://www.nationalarchives.gov.uk/doc/open-government-licence/
or write to The Information Policy Team, The National Archives, [NAME], London TW9 4DU, or email [EMAIL]
Users should include a source accreditation to ONS as "Source: Office for National Statistics".
Figures may not add exactly due to rounding.
Source: Population Projections Unit, ONS. Crown copyright 2012.
Spreadsheet: 707234d1607108717-consoldate-mulitple-rows-into-a-single-row-sample-bene-data-v2
Sheet: Sheet1

Oringinal Data
A/N | Type | Name | [NAME] | Relationship | [NAME] | %
123 | IRA | Smith | [NAME] | Spouse | Primary | 100
123 | IRA | Smith | [NAME] | Child | Contingent | 50
123 | IRA | Smith | Sue | Child | Contingent | 50
124 | AAA | asa | sss | dddd | [NAME] | 44
124 | AAA | asa | rrr | eee | wqw | 1000
Preferred Data Format
A/N | Type | Name | [NAME] | Relationship | [NAME] | % | [NAME] | Relationship | [NAME] | % | [NAME] | Relationship | [NAME] | %
123 | IRA | Smith | [NAME] | Spouse | Primary | 100 | [NAME] | Child | Contingent | 50 | Sue | Child | Contingent | 50
New Data Set
A/N | Type | Name | [NAME] | Relationship | [NAME] | % | [NAME] | Relationship | [NAME] | % | [NAME] | Relationship | [NAME] | %
123 | IRA | Smith | [NAME] | Spouse | Primary | 100
123 | IRA | Smith | [NAME] | Child | Contingent | 50
123 | IRA | Smith | Sue | Child | Contingent | 50
124 | AAA | asa | sss | dddd | [NAME] | 44
124 | AAA | asa | rrr | eee | wqw | 1000
125 | BBB | BTB | GRG | Spouse | Primary | 100
125 | BBB | BTB | FEF | Child | Contingent | 100
Attempt #1
A/N | Type | Name | [NAME] | Relationship | [NAME] | % | [NAME] | Relationship | [NAME] | % | [NAME] | Relationship | [NAME] | %
Spreadsheet: 873120d1719545541-move-certain-values-from-sheet-1-to-specific-cells-on-sheet-2-for-a-selected-row-jim94015-jim-test-aligw
Sheet: Sheet2

Breed | Persian | Pounds/Ounces |  | ID:
Birthdate |  | Room
Name | Fluffy | Owner | Parker
Species | Feline | Food | Can
Color | White | Sex | F
# of Days | 22 | [NAME] date | 2024-03-25 00:00:00
 |  | Arrival age | 1900-01-07 00:00:00
 |  | Toy | [NAME]
Spreadsheet: f0c92528-aec7-4ffa-9e26-50b62c5da9a4
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
5435 | 21904 | Rebecca | [NAME] | USA | 0 | 00:20:25 | 00:00:00 | 00:31:04 | 00:00:00 | 00:25:26 | 1 | 01:16:55
5435 | 28249 | Emma | Garrard | USA | 0 | 00:20:42 | 00:00:00 | [NAME] | 00:00:00 | 00:28:33 | 2 | 01:23:47
5435 | 15572 | Heather | Best | USA | 0 | 00:22:00 | 00:00:00 | 00:33:36 | 00:00:00 | 00:33:37 | 3 | 01:29:14
Spreadsheet: e2f8044f-601c-448d-aa4b-66870b59add5
Sheet: Sheet1

Table S1. Sequence characteristics of L1s across a 6-Mb genomic region of the 10q25 neocentromere | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Sequence characteristics | 330-Kb CENP-A-binding domain | Non-binding region | CENP-A-binding domain / non-binding region | P-value
Percentage of nucleotide corresponding to L1 | 45.3 ± 13.3 | 11.8 ± 9.6 | 3.85181577654429 | <0.001
Average number of L1 (per 100 kb) | 55.7 ± 22.3 | 26.0 ± 15.0 | 2.142857142857143 | <0.001
Average L1 length (bp) | 865.1 ± 201.8 | 440.0 ± 205.9 | 1.965589838358792 | <0.001
Divergence rate (nucleotide in parts per thousand) | 202.5 ± 25.3 | 210.8 ± 32.3 | 0.9606677741139631 | 0.507
Deletion rate (nucleotide in parts per thousand) | 52.4 ± 15.9 | 56.2 ± 18.7 | 0.9324866620686411 | 0.6
Insertion rate (nucleotide in parts per thousand) | 25.9 ± 7.4 | 33.1 ± 13.6 | 0.7826095060947301 | 0.168
Proportion of L1P (%) | 22.7 | 16.3 | 1.392638036809816
Proportion of L1M (%) | 70.8 | 78 | 0.9076923076923077
L1P/L1M ratio | 0.3 | 0.209 | 1.535885167464115
* L1P, primate-specific subfamily of L1; L1M, mammalian-wide subfamily of L1
The 6-Mb genomic region was divided into equal segments of 50 Kb and independently analyzed. Segments were grouped into CENP-A-binding domain and non-CENP-A-binding region based on the previous CENP-A mapping data (18). The average rates of divergence, deletion and insertion for all the L1 DNA elements within CENP-A binding domain and non-binding region are also shown.
Spreadsheet: c50f24c5-458f-4bc9-8f5b-38df33ef2af6
Sheet: District Marketing Chairs

 |  | Council/District Marketing and Communications Leadership (as of 5 Feb 2012)
District | Position | Last Name | First Name | [NAME] | Remarks | Attend KSW
Council | VP, MarComm | Wilson | J.S. ([NAME]) | [EMAIL] |  | Yes
Council | Dir, Strategic Initatives | Bisceglie | [NAME] | [EMAIL] |  | Yes
Council | [NAME] | Chusid | [NAME] | [EMAIL] |  | Yes
Council | Marketing Director | Pruett | Curtis | [EMAIL]
Council | Webmaster Committee | Groover | [NAME] | [EMAIL] |  | Yes
Council | PR/Mktg Consultant | [NAME] | [NAME] | [EMAIL]
[NAME] | Marketing Chair
[NAME] | [NAME] | Binzer | Margie | [EMAIL] |  | Yes
Aquia | [NAME] | Bell | [NAME] | [EMAIL] |  | Yes
Aquia | Training | Ellis | Mark | [EMAIL]
Aquia | Marketing Chair
[NAME] | Newsletter Editor | Smith | [NAME] | [EMAIL]
[NAME] | [NAME] | Thornburg | [NAME] | [EMAIL] |  | Yes
[NAME] | Marketing Chair
Catoctin Mountain | [NAME] | Groover | [NAME] | [EMAIL] |  | Yes
Catoctin Mountain | Marketing Chair
Catoctin Mountain | Advancedment Chair | Speace | [NAME] | [EMAIL] |  | Yea
Chain Bridge | Communications | [NAME] | [NAME] | [EMAIL]
Chain Bridge | [NAME]
Colonial | Marketing Chair | Morgan | [NAME] | [EMAIL]
Colonial | Marketing Team | Marston | [NAME] | [EMAIL] |  | Yes
Colonial | [NAME]
[NAME] | [NAME] | Valley | [NAME] | [EMAIL] |  | Yes
[NAME] | [NAME] | Valley | [NAME] | [EMAIL]
[NAME] | Marketing Chair | Sierra | [NAME] | [EMAIL]
[NAME] | [NAME]
[NAME] | [NAME] | Peck | [NAME] | [EMAIL]
[NAME] | Marketing Chair
[NAME] | Marketing Chair | Drake | [NAME] | [EMAIL] |  | Yes
Potomac | [NAME] | Hildebrand | Val | [EMAIL] |  | Yes
[NAME] | Marketing Chair | Harman | [NAME] | [EMAIL] |  | Yes
[NAME] | [NAME]
Montgomery South | Marketing Chair
Montgomery South | [NAME]
Occoquan | [NAME] | Eggers | [NAME] | [EMAIL]
Occoquan | Marketing Chair
Occoquan | Marketing Team | Sackett | [NAME] | [EMAIL] |  | Yes
Old Dominion | Marketing Chair | Chi | Nam | [EMAIL]
Old Dominion | Communications | Wokeck | Dennis
Old Dominion | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [EMAIL]
[NAME] | Communications | [NAME] | Doug | [EMAIL] |  | Yes
Piedmont | [NAME] | [NAME] | Troy | [EMAIL]
Piedmont | Communications | King | [NAME] | [NAME]
Powhatan | [NAME] | Sheflett | George | [EMAIL] |  | Yes
Powhatan | Marketing Chair | Walter | [NAME] | [EMAIL]
[NAME] | [NAME] | Moore | Kittie | [EMAIL]
[NAME] | Marketing Chair | [NAME] | [NAME] | [EMAIL] |  | Yes
Sully | Marketing Chair
Sully | [NAME]
Washington | Marketing Chair | Matthews | [NAME] | [EMAIL] |  | Yes
Washington | [NAME] | Matthews | [NAME] | [EMAIL] |  | Yes
Western Shore | Marketing Chair | [NAME] | [NAME] | [EMAIL]
Western Shore | [NAME] | [NAME] | [NAME] | [EMAIL] |  | Yes
Zekiah | Marketing Chair
Zekiah | [NAME] | [NAME] | [NAME] | [EMAIL] |  | Yes
Venturing | Marketing/Webmaster | [NAME] | Carol | [EMAIL] |  | Yes
Spreadsheet: 606161d1547508811-flag-earliest-date-in-array-dummy-data-bvj-
Sheet: Sheet1

Desired Outcome |  |  |  |  | My solution
Account ID | ACCT_Opn_dt | AS_OF_DT | Month# |  | ACCT_ID | ACCT_OPN_DT | ACCT OPN DATE2 | AS_OF_DT | Month#
1 | 2018-06-29 00:00:00 | 2018-12-01 00:00:00 |  |  | 1 | 2018-06-29 00:00:00 |  | 2018-12-01 00:00:00
1 | 2018-06-29 00:00:00 | 2018-11-01 00:00:00 |  |  | 1 | 2018-06-29 00:00:00 |  | 2018-11-01 00:00:00
1 | 2018-06-29 00:00:00 | 2018-10-01 00:00:00 |  |  | 1 | 2018-06-29 00:00:00 |  | 2018-10-01 00:00:00
1 | 2018-06-29 00:00:00 | 2018-09-01 00:00:00 |  |  | 1 | 2018-06-29 00:00:00 |  | 2018-09-01 00:00:00
1 | 2018-06-29 00:00:00 | 2018-08-01 00:00:00 |  |  | 1 | 2018-06-29 00:00:00 |  | 2018-08-01 00:00:00
1 | 2018-06-29 00:00:00 | 2018-07-01 00:00:00 |  |  | 1 | 2018-06-29 00:00:00 |  | 2018-07-01 00:00:00
2 | 2018-03-28 00:00:00 | 2018-08-01 00:00:00 |  |  | 2 | 2018-03-28 00:00:00 |  | 2018-08-01 00:00:00
2 | 2018-03-28 00:00:00 | 2018-07-01 00:00:00 |  |  | 2 | 2018-03-28 00:00:00 |  | 2018-07-01 00:00:00
2 | 2018-03-28 00:00:00 | 2018-06-01 00:00:00 |  |  | 2 | 2018-03-28 00:00:00 |  | 2018-06-01 00:00:00
2 | 2018-03-28 00:00:00 | 2018-05-01 00:00:00 |  |  | 2 | 2018-03-28 00:00:00 |  | 2018-05-01 00:00:00
2 | 2018-03-28 00:00:00 | 2018-04-01 00:00:00 |  |  | 2 | 2018-03-28 00:00:00 |  | 2018-04-01 00:00:00
2 | 2018-03-28 00:00:00 | 2018-03-01 00:00:00 |  |  | 2 | 2018-03-28 00:00:00 |  | 2018-03-01 00:00:00
Spreadsheet: 199356d1355191577-help-a-teacher-day-how-to-pull-data-from-a-sheet-to-enter-in-a-calendar-template-grading-attendance-behavior-chart
Sheet: Friday

Date: Friday |  | 2012-12-15 00:00:00 |  | Daily Student Tracking Report
Student | On Time |  | On Task |  | Response |  | Talking |  | Disruption |  | Gum/food |  | Homework |  | Classwork |  | Absent |  | Tardy |  | Total (day)
Student1
Student2
Student3
Student4
Student5
Student6
Student7
Student8
Student9
Student10
Student11
Student12
Student13
Student14
Student15
Student16
Student17
Student18
Notes for Principal / Parent   |        Nòt pou Direktè / Paran              |        Notas para el Director / Padres  √
Name | Time | Reason      |      Rezon ki fè      |      Razón
Spreadsheet: 776935d1650006929-conditional-formatting-based-on-two-cells-example-projectmanagement
Sheet: Sheet1

 | Planning
 | Nr | Topic | Action | Description | Date | Status | Preparer | Reviewer | Involved (client, specialist, other)
 | 1 | Teamplanning | Team opbouw | Meeting within the team | 2022-04-15 00:00:00 | Completed | JO | N/a | N/A
 |  |  | Hours per period | Contact with planning | 2022-04-15 00:00:00 | Completed | JO / DS | N/a | Planning department
 | 2 | Fee schedule | Review internally | Plan time for review |  |  |  |  | Joost
 |  |  | Review externally | Plan time for review |  |  |  |  | Jan
 |  |  | Due date | Date of SB meeting | 2022-03-27 00:00:00
Spreadsheet: 32076d1228206581-one-cell-reading-from-different-locations-plus-minus-variables-2-0212
Sheet: Sheet1

 |  |  | gradiant | 25
 |  |  |  |  |  |  |  |  | drop of blind |  |  |  | 1855
 |  |  | gradiant x 2 | 50 |  |  |  |  | minus headrail |  | 25
 |  |  |  |  |  |  |  |  | minus allowance for gear |  | 90 |  |  |  | 9.090909090909092
 |  |  |  |  |  |  |  |  | bottom bar |  | 40
 |  |  |  |  |  |  |  |  | take off |  | 155 |  | 1700 |  | 5.5
 |  | 2116 track | 25mm | Gradiant folds with Flaps |  |  |  |  |  |  |  | 3 | 309.0909090909091
 |  | gear drive | 90mm | i | ii | iii |  |  |  |  | 1 | 309.0909090909091 | 209.0909090909091 | 200
 |  | workable fabric 1500 mm | 1 | (272) -100 = | 172 - 9 = | 163 |  |  |  | minus above | 2 | 309.0909090909091 | 259.0909090909091 | 250
 |  |  | 2 | (272) - 50  = | 222 - 9 = | 213 |  |  |  | centre fold of blind | 3 | 309.0909090909091 | 309.0909090909091 | 300
 |  | take middle fold as datum | 3 | (272) ± 0 = | 272 - 9 = | 263 |  |  |  | plus below | 4 | 309.0909090909091 | 359.0909090909091 | 350
 |  |  | 4 | (272) + 50  = | 322 - 9 = | 313 |  |  |  |  | 5 | 309.0909090909091 | 409.0909090909091 | 400
finished drop of blind |  |  | 5 | (272) + 100 = | 372 - 9 = | 363
1655 mm |  |  | 1/2 flap | (136). | 186 | 182
 |  | 2004 bottom weight bar | 40mm
 |  |  |  | 1500 | 1546 | 1497
 | For example:- 1655[NAME] drop |  |  |  |  |  |  |  |  | 1/2 flaps |  | 154.5454545454545 | 204.5454545454545 | 200
i | 1655mm - 155mm = 1500[NAME] workable fabric
 | 25mm gradiant, 5 folds |  |  |  |  |  |  |  |  |  |  | 1700 | 1750 | 1700
 | 1500
 | 5.5  = | 272 mm rounded down to the nearest mm
ii | Adjust to form gradiant by adding or subtracting 2 x gradiant (50 mm)
 | the new total is now 1546 mm but there is omly 1500 mm of workable fabric so there is a deficit of 46mm.
 | 46
 | 5.5 | spaces = 8.36 mm
 | Therefor adjust each space down by 9mm as in step iii.
 | The new Total will be 1497 mm and if you plan form the bottom it only increases the final top space by 3mm.
Spreadsheet: 175135d1345417197-referencing-a-different-workbook-updated-w-workbooks-dummy-book-1
Sheet: PWO Tee Example

COLOR: |  | Red | Green | Yellow |  | ITEM #: | Red | Green | Yellow
SUM: |  |  |  |  |  | XS | 7802 | 8163 | 8169
 |  | C2 SHOULD EQUAL 4600 UNITS | [NAME] EQUAL 5731 UNITS | [NAME] EQUAL 6349 UNITS |  | S | 7803 | 8164 | 8170
 |  |  |  |  |  | M | 7804 | 8165 | 8171
 |  |  |  |  |  | L | 7805 | 8166 | 8172
 |  |  |  |  |  | XL | 7806 | 8167 | 8173
 |  |  |  |  |  | XXL | 7807 | 8168 | 8174
Spreadsheet: 162676d1340030839-complex-if-and-logic-help-needed-commscalc-example-test
Sheet: CommsCalc

 |  | Target | 1800 |  | TOTAL
 |  | 100 |  |  | Tax Rate | 0.4
 |  |  |  |  | Net Income
 |  |  |  | 1-100 | 100-150 | 150+ | Comms | Base | Bonus | TOTAL
 | Quota Achievement | Running Total | % Achieved | 1 | 2.4 | 2.7 |  | 10
Q1 | 1000 |  |  |  |  |  |  |  | 0
Q2 | 1000 |  |  |  |  |  |  |  | 10
Q3 | 1000 |  |  |  |  |  |  |  | 0
Q4 | 1000 |  |  |  |  |  |  |  | 20
Total | 4000
Only adjust the Yellow cells