tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 272566d1382433338-how-to-join-two-worksheets-into-one-based-on-the-data-they-contain-ef510_join_tables
Sheet: joined data

# defect | type of defect | # quality control | corrective action | responsible person | date of completion
23454 | z2 | 222
23455 | z1 | 231
23456 | z1 | 234 | aaa | A | 12.12.12
23456 | z1 | 234 | bbb | V | 13.1.11
23457 | z2 | 245 | [NAME] | W | 4.9.13
23458 | z1 | 267 | aac | A | 23.5.12
23459 | z3 | 277 | asdf | N | 5.7.12
23460 | z2 | 289 | asde | P | 6.1.12
23460 | z2 | 289 | jyjt | E | 3.6.13
23460 | z2 | 289 | asd | B | 23.9.11
23461 | z2 | 292 | nydz | N | 1.1.13
23462 | z3 | 301 | afeef | P | 9.9.12
23463 | z1 | 303 | kuud | A | 5.7.12
23464 | z3 | 333 | sgfsgr | W | 7.3.13
23465 | z1 | 343 | [NAME] | R | 13.1.11
23466 | z3 | 351 | xcvcx | Z | 6.3.12
23467 | z2 | 364 | ewgt | L | 25.2.12
23468 | z1 | 367 | kggjy | P | 3.6.13
Spreadsheet: 745939d1630387104-how-to-populate-a-range-from-a-range-with-a-specific-starting-point-how-to-populate-a-range-from-a-range-with-a-specific-starting-point
Sheet: Sheet1

Student1 | Student2 |  |  |  | List
word 1 | word 1 |  |  |  | eleven
word 2 | word 2 |  |  |  | twelve
word 3 | word 3 |  |  |  | thirteen
word 4 | word 4 |  |  |  | fourteen
word 5 | word 5 |  |  |  | fifteen
 | word 6 |  |  |  | sixteen
 | word 7 |  |  |  | seventeen
 |  |  |  |  | eighteen
 |  |  |  |  | ninteen
 |  |  |  |  | twenty
Spreadsheet: 01d93c69-5e6c-4dbc-becd-f9d3219ac6f9
Sheet: Simple Reg (2)

OBS | ACRES | AGE | EDUC | COUNTY |  | SUMMARY OUTPUT
1 | 190 | 50 | 14 | [NAME]
2 | 135 | 59 | 14 | Haynes |  | Regression Statistics
3 | 275 | 39 | 16 | Haynes |  | Multiple R | 0.8068802857956143
4 | 185 | 49 | 14 | Haynes |  | R Square | 0.6510557956056123
5 | 340 | 39 | 12 | [NAME] |  | Adjusted R Square | 0.6358843084580302
6 | 575 | 32 | 16 | Haynes |  | Standard Error | 103.0750337449459
7 | 210 | 51 | 14 | [NAME] |  | Observations | 25
8 | 95 | 55 | 8 | Haynes
9 | 55 | 67 | 8 | [NAME] |  | ANOVA
10 | 210 | 28 | 12 | Haynes |  |  | df | SS | MS | F | [NAME]
11 | 280 | 35 | 14 | Haynes |  | Regression | 1 | 455928.800625 | 455928.800625 | 42.91311651075506 | 1.102425751532937e-06
12 | 0 | 68 | 8 | [NAME] |  | Residual | 23 | 244362.6393750001 | 10624.46258152174
13 | 120 | 55 | 12 | Haynes |  | Total | 24 | 700291.4400000001
14 | 80 | 59 | 12 | [NAME]
15 | 600 | 30 | 18 | [NAME] |  |  | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0%
16 | 415 | 29 | 18 | Haynes |  | Intercept | -319.8599999999997 | 84.99785029890334 | -3.763153995956138 | 0.001011093839038652 | -495.6914488863872 | -144.0285511136123 | -495.6914488863872 | -144.0285511136123
17 | 0 | 62 | 8 | Haynes |  | EDUC | 42.20156249999997 | 6.44218960905912 | 6.55081037053852 | 1.102425751532944e-06 | 28.87487801352997 | 55.52824698646998 | 28.87487801352997 | 55.52824698646998
18 | 395 | 27 | 16 | Haynes
19 | 480 | 31 | 16 | [NAME]
20 | 180 | 52 | 12 | [NAME]
21 | 60 | 63 | 6 | Haynes
22 | 0 | 61 | 12 | Haynes
23 | 108 | 61 | 12 | Haynes
24 | 225 | 46 | 12 | [NAME]
25 | 295 | 37 | 16 | [NAME]
Spreadsheet: 438532d1452018248-team-list-copy-of-team-list
Sheet: Sheet2

Project | Count | Resource A | Resource B | Resource C | Resource D | Resource E | Resource F |  |  | Summary |  |  |  | formula for 'Named Range'
Project 1 |  | 4 | 5 | 3 |  |  |  |  |  | Select Project | Project 6
Project 2 |  |  |  |  | 12 | 6 | 3 |  |  |  |  |  | Resource A
Project 3 |  |  | 3 | 4 | 5 | 6 |  |  |  | Resources on Project |  |  | Resource B
Project 4 |  | 9 | 9 |  |  | 9 | 9 |  |  |  |  |  | Resource C
Project 5 |  | 3 | 2 | 1 | 2 | 3 |  |  |  |  |  |  | Resource D
Project 6 |  |  |  | 1 | 2 |  |  |  |  |  |  |  | Resource E
Project 7 |  | 4 |  |  | 5 |  | 3 |  |  |  |  |  | Resource F
Project 8 |  |  | 3 | 2 |  | 5 | 3
Spreadsheet: 9d2693cd-753a-4053-80bf-62f012074fae
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | Estimating and Appropriating to the 2006 GO Bond fund to continue construction on the Animal Shelter Interior
 | Renovation project; declaring that the Director of Public Works is hereby established as requisitioning authority
 | for the funds provided by this ordinance and declaring the intent of the City to reimburse itself from bond proceeds for certain expenditures
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | CIMO
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  |  |  | CIMO, NCS
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CIMO
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | NCS
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  |  |  | None Known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s) |  |  |  | 2006 GO BOND FUND
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
 |  |  |  |  |  |  | AL3392-898825-B-890000380
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
Fact Sheet Prepared by:
 | [NAME] | 2007-01-30 00:00:00 | Date
 | Contract Administrator |  | 2007-01-30 00:00:00
Reviewed by:
 | [NAME] |  | Date | 2007-01-30 00:00:00
 | Team Lead, Architectural Services
Reference Numbers
Spreadsheet: richard_sanders__31925__138 0616 ENBW jan2000  invc
Sheet: Invoice

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Power Settlements
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RECHNUNG |  |  |  |  |  |  |  |  |  | Enron House
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 Grosvenor Place
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | London SW1X 7EN
 |  | Enron Capital and Trade Resources Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tel: 0044 20 778 30000
 | Kunde |  |  |  |  |  |  |  | Zahlungsbedingungen |  |  |  |  |  |  |  |  |  |  |  | Einzelheiten der [NAME] |  |  |  |  |  |  | Fax: 0044 20 778 30001
 | RBB Abteilung |  |  |  |  |  |  |  | Zahlbar bis: |  |  |  |  |  |  |  |  |  |  |  | MWSt-Nr.: |  |  |  |  |  |  | DE 812633881
 | [NAME] für Stromhandel mbH |  |  |  |  |  |  |  | 2000-02-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Rechnungsdatum: |  |  |  |  |  |  | 2000-02-18 00:00:00
 | Durlacher [NAME] 93 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MWST-Datum |  |  |  |  |  |  | 2000-02-18 00:00:00
 | 76131 Karlsruhe |  |  |  |  |  |  |  | zu überweisen an: |  |  |  |  |  |  |  |  |  |  |  | [NAME]: |  |  |  |  |  |  | [NAME]
 | Germany |  |  |  |  |  |  |  | Citibank A.G., Frankfurt
 |  |  |  |  |  |  |  |  | [NAME]: |  | [PHONE]
 | MWSt-Nr.: | DE 190 565 239 |  |  |  |  |  |  | SWIFT Code: |  | CITIDEFF |  |  |  |  |  |  |  |  |  | [NAME]: |  |  |  |  |  |  | [NAME]
 | Telefon: | 0049 721 63 07 |  |  |  |  |  |  | BLZ:                     50210900 |  |  |  |  |  |  |  |  |  |  |  | Telefon: |  |  |  |  |  |  | +44 20 778 37430
 | Fax: | 0049 721 63 15477 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fax: |  |  |  |  |  |  | +44 20 778 38330
 | Beschreibung |  |  |  |  |  |  |  | Liefermenge |  |  |  |  |  | Preis |  |  |  |  |  | Netto-Beträge |  |  | MWSt |  |  | Brutto-Beträge
 | EnbW Energielieferung Vetrag 01/01/2000 - 04/02/2000 |  |  |  |  |  |  |  |  |  | -76800 | MWh |  |  | 18.75 |  |  |  | EUR/MWh |  | EUR |  |  | EUR |  |  | EUR
 | Ersatzkosten fur Energielieferung 01/01/2000 - 04/02/2000 |  |  |  |  |  |  |  |  |  | 76800 | MWh |  |  | ca. 27.01 |  |  |  | EUR/MWh |  | EUR | 2074490 |  | EUR |  |  | EUR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EUR
 | Die Details sind in [NAME] aufgelistet.
 | Art der Steuer: Standard Rate
 | Steuersatz: 7.5%
 | Gesamt-Summe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EUR |  |  | EUR |  |  | EUR
 | Registered in England No. 2415924, Registered Office Enron House, 40 [NAME], London, SW1X 7EN
Spreadsheet: 8153d795-7def-4e2f-b90f-e42009d743b2
Sheet: Accountability

 |  |  |  | Health-Related Institutions |  |  |  | Return to Index
 |  |  |  | FY 2012 Summary of Research Expenditures By Source to Accountability System
 |  |  |  | Dedember 13, 2012
Note:  [NAME] and past Columns D,E,F,&G values to S&U Accountability Tab.  Do not send separately.
FICE Code | Year | Institution | Total Research Expenditures | Federal | State | Private | Institutional | Check
000030 | FY 12 | UT Southwestern Med.
000040 |  | UT San Antonio HSC
000089 |  | Texas A&M HSC
000130 |  | U. North Texas HSC
000404 |  | UT Health Center Tyler
000412 |  | Texas Tech HSC
011618 |  | UT Houston Health Science Center
025554 |  | UT [NAME]
104952 |  | UT Galveston Medical Branch
 |  | Total
 |  | 9 Ok
 |  |  | 1776880251 | 843503441 | 410444996 | 379052785 | 143879029
000030 | FY 11 | UT Southwestern Med.
000040 |  | UT San Antonio HSC
000089 |  | Texas A&M HSC
000130 |  | U. North Texas HSC
000404 |  | UT Health Center Tyler
000412 |  | Texas Tech HSC
011618 |  | UT Houston Health Science Center
025554 |  | UT [NAME]
104952 |  | UT Galveston Medical Branch
 |  | Total
Spreadsheet: 540502d1506713190-formula-help-adjusting-decimal-point-display-based-upon-name-igt_formating-1-
Sheet: Specs3

 | Symbol | $ Point Value | $ Fees | Tic Value $
 | AD | 100000 | -5.5 | 10
 | BP | 62500 | -5.5 | 6.25
 | CD | 100000 | -5.5 | 10
 | EC | 125000 | -5.5 | 12.5
 | JY | 125000 | -5.5 | 12.5
 | SF | 125000 | -5.5 | 12.5
 | 6A | 100000 | -5.5 | 10
 | 6B | 62500 | -5.5 | 6.25
 | 6C | 100000 | -5.5 | 10
 | 6E | 125000 | -5.5 | 12.5
 | 6J | 125000 | -5.5 | 12.5
 | 6S | 125000 | -5.5 | 12.5
 | US | 3125 | -4.3 | 15.625
 | TY | 3125 | -4.3 | 15.625
 | CL | 1000 | -4.3 | 10
 | NG | 1000 | -4.3 | 10
 | GC | 100 | -8.94 | 10
 | YM | 5 | -4.32 | 5
 | NQ | 20 | -4.32 | 5
 | ES | 50 | -4.32 | 12.5
 | TF | 100 | -4.32 | 10
 | ZB | 3125 | -4.32 | 31.25
 | ZN | 3125 | -4.32 | 15.625
 | ZF | 3125 | -4.32 | 7.8125
 | ZT | 6250 | -4.32 | 15.625
 | CL3 | 1000 | -6.92 | 10
 | GC3 | 100 | -4.32 | 10
 | YM3 | 5 | -4.3 | 5
 | [NAME] | 50 | -4.32 | 50
 | ZB3 | 3125 | -4.38 | 31.25
 | ZN3 | 3125 | -4.38 | 15.625
 | 6E3 | 625000 | -5.5 | 62.5
Spreadsheet: 862274d1710018296-need-dynamic-calendar-that-starts-on-a-date-in-another-cell-and-shows-next-4-weeks-sample-file-for-calendar-example
Sheet: Sheet1

Date | 2024-03-11 00:00:00
 |  |  |  |  |  |  |  | I would like the calendar below to automatically populate based on the start date in $B$6, with that date automatically "landing" on the correct day of the week in the first week and then showing the date for each weekday moving forward for the following four weeks.
 |  |  |  |  |  |  |  | SOLVED
 |  |  |  |  |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday
 |  |  |  |  |  |  |  | Cells on the right are merged due to row restrictions in cells to the left that cannot be adjusted in height
Spreadsheet: 862076d1709851498-beginner-trouble-sorting-bilateral-trade-paper-2
Sheet: EC440 (3)

Herzog, Blake Richard
[EMAIL]
Country Name | Country Code | Home | Dist | U.S GDP Trillions | Foreign GDP | Foreign GDP (Trillions) | Exports(millions) | Exports(trillions) | Predicted Trade | Actual Trade | Gravity Term
Armenia | ARM | USA | 9088.867 | 21.38 | 13619290539 | 0.001361 | 52.9
Australia | AUS | USA | 16008.79 | 21.38 | 1394670000000 | 1.39467 | 25875.48 |  |  | 0.02587548
Bahrain | BHR | USA | 10643.58 | 21.38 | 38653318085 | 0.003865 | 1406.46 |  |  | 0.00140646
Belarus | BLR | USA | 7125.836 | 21.38 | 64410122847 | 0.00644101 | 125.11 |  |  | 0.00012511
Bolivia | BOL | USA | 6400.357 | 21.38 | 40895322851 | 0.0040895 | 552.27 |  |  | 0.00055227
Switzerland | CHE | USA | 6272.285 | 21.38 | 721369000000 | 0.721369 | 17987.25 |  |  | 0.01798725
Costa Rica | CRI | USA | 3564.9 | 21.38 | 64417670521 | 0.0064417 | 6219.63 |  |  | 0.006219629999999999
Denmark | DNK | USA | 6191.893 | 21.38 | 346499000000 | 0.346 | 3195.19 |  |  | 0.00319519
Dominican Republic | DOM | USA | 2508.955 | 21.38 | 88941372558 | 0.008894 | 9208 |  |  | 0.009208
Estonia | EST | USA | 6653.48 | 21.38 | 31081901909 | 0.0311 | 410.66 |  |  | 0.00041066
United Kingdom | GBR | USA | 5570.161 | 21.38 | 2851410000000 | 2.85 | 69079.94 |  |  | 0.06907993999999999
Georgia | GEO | USA | 8980.505 | 21.38 | 17470436259 | 0.0175 | 768.65 |  |  | 0.00076865
Ireland | IRL | USA | 5117.716 | 21.38 | 398933000000 | 0.399 | 9796.56 |  |  | 0.00979656
Iraq | IRQ | USA | 9651.111 | 21.38 | 233636000000 | 0.234 | 1189.17 |  |  | 0.00118917
Jamaica | JAM | USA | 2549.896 | 21.38 | 15830766571 | 0.0158 | 2480.26 |  |  | 0.00248026
Cambodia | KHM | USA | 14208.13 | 21.38 | 27089390033 | 0.0271 | 513.94 |  |  | 0.0005139400000000001
Kuwait | KWT | USA | 10209.52 | 21.38 | 136192000000 | 0.136 | 3170.73 |  |  | 0.00317073
Lithuania | LTU | USA | 6956.313 | 21.38 | 54808531641 | 0.0548 | 933.93 |  |  | 0.0009339299999999999
Malaysia | MYS | USA | 15130.12 | 21.38 | 365178000000 | 0.365 | 13193.72 |  |  | 0.01319372
Nigeria | NGA | USA | 8493.132 | 21.38 | 474517000000 | 0.475 | 3198.11 |  |  | 0.00319811
Norway | NOR | USA | 5916.703 | 21.38 | 408743000000 | 0.409 | 3897.34 |  |  | 0.00389734
Panama | PAN | USA | 3580.789 | 21.38 | 69721787500 | 0.0697 | 7537.82 |  |  | 0.00753782
Peru | PER | USA | 5890.553 | 21.38 | 228326000000 | 0.228 | 9658.28 |  |  | 0.00965828
Portugal | PRT | USA | 5425.189 | 21.38 | 239987000000 | 0.24 | 1715.6 |  |  | 0.0017156
Sudan | SDN | USA | 10225.49 | 21.38 | 32338079165 | 0.0323 | 74.09 |  |  | 7.409e-05
Senegal | SEN | USA | 6157.48 | 21.38 | 23403995992 | 0.0234 | 196.74 |  |  | 0.00019674
Serbia | SRB | USA | 8998 | 21.38 | 51514242939 | 0.0515 | 150.72 |  |  | 0.00015072
Tunisia | TUN | USA | 7023.72 | 21.38 | 419905540184 | 0.42 | 460.82 |  |  | 0.00046082
Uruguay | URY | USA | 8617.354 | 21.38 | 62048585619 | 0.062 | 1616.18 |  |  | 0.00161618
Zambia | ZMB | USA | 12156.13 | 21.38 | 23308667781 | 0.0233 | 99.46 |  |  | 9.945999999999999e-05
Spreadsheet: 34990d1232464462-step-value-step-value-question
Sheet: PERSONAL EXPENSES

Month | Income | Expenditure | Savings
January | 2120 | 1900
February | 2120 | 1905
March | 2120 | 1910
April | 2120 | 1915
May | 2120 | 1920
June | 2120 | 1925
Spreadsheet: 153234d1335814914-need-help-consolidating-data-across-multiple-sheets-warehouse-store-order-list-4-30-12
Sheet: Wing Sauce

Ordered | Item | Description | Retail | Heat Level | Category
 | P140 | Death By Wings, 13 oz. | 8.95 | 10+ | Wing Sauce
 | P185 | Wing Master - Hot, 13 oz. | 6.95 | 6 | Wing Sauce
 | R328 | Wing Master - Jolokia, 13 oz. | 8.95 | 10+ | Wing Sauce
 | P1160 | Wing Master - Med, 13 oz. | 6.95 | 4 | Wing Sauce
 | P1110 | Wing Master [NAME], 13 oz. | 6.95 | 8 | Wing Sauce
 | P1135 | Wing Master [NAME], 13 oz. | 6.95 | 5 | Wing Sauce
 | Q28 | Wing Master Special Edition [NAME], 13 oz. | 6.95 | 4 | Wing Sauce
Spreadsheet: 714811d1611383571-google-sheets-countifs-and-sumif-formulas-returning-0-copy-of-terrenos-familia-3-
Sheet: Alvaro

 | ALVARO |  |  | Renta
 |  |  |  | Meses rentados |  |  | Gastos
 |  |  |  | Ingresos |  |  | Ingresos
 |  |  |  |  |  |  | [NAME]
 | Fecha de pago | Propriedad | Persona | Descripcion | [NAME] | Monto | Recibo/Factura | Comentarios
Spreadsheet: 55182d1255353070-how-to-automatically-alter-formula-when-filters-are-applied-malchemist-2
Sheet: 31579

Date of Order | Date of Order | Year Of Order | Month Of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20090317 | 2009-03-17 | 2009 | 3 | 244283 | Cordl. ham. dr. driver SFH 144-A Li-Ion | 1 | 93.75 | 133858 | 31579
20090317 | 2009-03-17 | 2009 | 3 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 71.5199999999999 | 133858 | 31579
20090317 | 2009-03-17 | 2009 | 3 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133858 | 31579
20090317 | 2009-03-17 | 2009 | 3 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133858 | 31579
20090317 | 2009-03-17 | 2009 | 3 | 402704 | Rotary hammer TE 16-C 110V | 1 | 299 | 133858 | 31579
Spreadsheet: 272515d1382416962-excel-2010-copy-conditional-formating-from-a-row-with-4-columns-to-all-rows-task
Sheet: 1

 |  | Co.A | Co. B | Co. C | Co. D
 | Commodity 1 | 45 | 56 | 748 | 56
 | Commodity 2 | 98 | 65 | 312 | 45
 | Commodity 3 | 15 | 35 | 5 | 656
 | Commodity 4 | 45 | 565 | 565 | 5656
 | Commodity 5 | 656 | 87 | 565 | 213
 | Commodity 6 | 232 | 478 | 135 | 56
 | Commodity 7 | 456 | 45 | 48 | 485
Task | Need to copy conditional formatting from first row to all below it
 | Fill lowest value cell with background color.
Spreadsheet: 01af6e77-2c8d-4dba-b6db-8f3300c5d875
Sheet: Average Costs

Preschool
 | Number of students with disabilities enrolled (as of Dec 1)
 | Total salary and benefit costs of special education teachers providing service in preschool
 | Total salary and benefit costs of special education paraprofessionals providing service in preschool
 | Average Cost Per Preschool Student
General Education
 | Number of students with disabilities enrolled (as of Dec 1)
 | Total salary and benefit costs of special education teachers providing service in the general education classroom
 | Total salary and benefit costs of special education paraprofessionals providing service in the general education classroom
 | Average Cost Per General Education Student
Resource
 | Number of students with disabilities enrolled (as of Dec 1)
 | Total salary and benefit costs of special education teachers providing service using a pull-out (resource) model
 | Total salary and benefit costs of special education paraprofessionals providing service using a pull-out (resource) model
 | Average Cost Per Resource Student
Special Class
 | Number of students with disabilities enrolled (as of Dec 1)
 | Total salary and benefit costs of special education teachers providing service in a special class
 | Total salary and benefit costs of special education paraprofessionals providing service in a special class
 | Average Cost Per Special Class Student
Special School
 | Number of students with disabilities enrolled (as of Dec 1)
 | Total salary and benefit costs of special education teachers providing service in a special school
 | Total salary and benefit costs of special education paraprofessionals providing service in a special school
 | Average Cost Per Special School Student
Spreadsheet: 883491d1732111420-xlookup-xlookup-query
Sheet: Sheet1

Need to amend the formula to copy across the correct amounts
When entering date in F7 it populates G7 from D7
When entering date in F10 it should populate G10 from D11
 |  |  |  |  |  | Correct
 |  |  |  |  |  | Amounts
2023-12-29 00:00:00 | 19268.43 |  | 2023-12-29 00:00:00 | 19268.43 |  | 19268.43
2024-01-02 00:00:00 | 18934.11 |  | 2023-12-29 00:00:00 | 19268.43 |  | 19268.43
2024-01-03 00:00:00 | 18870.12 |  | 2024-04-02 00:00:00 | 19268.43 |  | 18813.99
2024-01-04 00:00:00 | 18886.82 |  | 2024-04-02 00:00:00 | 19268.43 |  | 18813.99
2024-04-02 00:00:00 | 18813.99 |  | 2024-10-01 00:00:00 | 19268.43 |  | 22546.87
2024-09-27 00:00:00 | 22945.13 |  | 2024-11-04 00:00:00 | 19268.43 |  | 22254.09
2024-09-30 00:00:00 | 22711.23
2024-10-01 00:00:00 | 22546.87
2024-10-02 00:00:00 | 22595.94
2024-11-04 00:00:00 | 22254.09
2024-11-05 00:00:00 | 22278.71
Spreadsheet: 456756d1461049645-to-get-desired-result-based-on-the-conditions-sample-file-1
Sheet: Sheet3

HOME_CNUM | ASSIGNMENT_STATUS | ASSIGNEE_LAST_NAME | ASSIGNEE_FIRST_NAME | HOST_CNUM | ACTUAL_START_DATE | ACTUAL_END_DATE | Home_Country | [NAME]
00013F744 | Completed | PODDAR | NITIN | 100603866 | 2013-12-06 00:00:00 | 2015-04-04 00:00:00 | India | United Kingdom
00013F744 | Completed | PODDAR | NITIN | 100603866 | 2013-03-21 00:00:00 | 2013-12-09 00:00:00 | India | United Kingdom
00013F744 | Completed | PODDAR | NITIN | 100603866 | 2012-12-15 00:00:00 | 2014-01-06 00:00:00 | India | United Kingdom
00013F744 | Completed | PODDAR | NITIN | 100603866 | 2012-11-03 00:00:00 | 2013-05-17 00:00:00 | India | United Kingdom
00013F744 | Completed | PODDAR | NITIN | 100603866 | 2012-08-06 00:00:00 | 2013-02-12 00:00:00 | India | United Kingdom
00013F744 | Completed | PODDAR | NITIN | 100603866 | 2011-08-01 00:00:00 | 2012-08-27 00:00:00 | India | United Kingdom
00013F744 | Completed | PODDAR | NITIN | 100603866 | 2010-12-03 00:00:00 | 2011-12-08 00:00:00 | India | United Kingdom
000251744 | Current | [NAME] | Swapna | 110053866 | 2013-12-01 00:00:00 | 2016-04-30 00:00:00 | United States | United Kingdom
000251744 | Completed | [NAME] | Swapna | 110053866 | 2013-06-01 00:00:00 | 2013-12-31 00:00:00 | United States | United Kingdom
000251744 | Completed | [NAME] | Swapna | 110053866 | 2010-02-01 00:00:00 | 2011-04-14 00:00:00 | United States | United Kingdom
000251744 | Completed | [NAME] | Swapna |  | 2009-11-25 00:00:00 | 2010-03-28 00:00:00 | United States | United Kingdom
000251744 | Completed | [NAME] | Swapna | 110053866 | 2008-12-30 00:00:00 | 2009-04-29 00:00:00 | United States | United Kingdom
000251744 | Completed | [NAME] | Swapna | 110053866 | 2008-01-15 00:00:00 | 2008-12-28 00:00:00 | United States | United Kingdom
000251744 | Completed | [NAME] | Swapna | 110053866 | 2000-01-01 00:00:00 | 2002-07-31 00:00:00 | United States | United Kingdom
000251744 | Completed | [NAME] | Swapna |  | 1998-05-31 00:00:00 | 1998-11-30 00:00:00 | United States | United Kingdom
00026J744 | Current | [NAME] | [NAME] | 115131866 | 2010-01-01 00:00:00 | 2010-07-14 00:00:00 | South Africa | United Kingdom
Results
Condition 1 for 3 different Assignees
00013F744 | Completed | PODDAR | NITIN | 100603866 | 2012-11-03 00:00:00 | 2013-05-17 00:00:00 | India | United Kingdom
000251744 | Completed | [NAME] | Swapna | 110053866 | 2010-02-01 00:00:00 | 2011-04-14 00:00:00 | United States | United Kingdom
00026J744 | Current | [NAME] | [NAME] | 115131866 | 2010-01-01 00:00:00 | 2010-07-14 00:00:00 | South Africa | United Kingdom
Condition 2 for 3 different Assignees
00013F744 | Completed | PODDAR | NITIN | 100603866 | 2013-12-06 00:00:00 | 2015-04-04 00:00:00 | India | United Kingdom
000251744 | Current | [NAME] | Swapna | 110053866 | 2013-12-01 00:00:00 | 2016-04-30 00:00:00 | United States | United Kingdom
00026J744 | Current | [NAME] | [NAME] | 115131866 | 2010-01-01 00:00:00 | 2010-07-14 00:00:00 | South Africa | United Kingdom