tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 002ff8f7-34f1-4f75-ab90-dc7586af3484
Sheet: PI-Other

Policyholder Impact Exhibit |  |  |  |  |  |  |  | PI-Other
Insurance Company: |  | Insert Company Name
Program: |  | Insert Program Type
Effective Date: |  | MM/DD/YYYY
Rate Change Interval |  | # Policies Affected | % Policies Affected |  | Rate Change Interval |  | # Policies Affected | % Policies Affected
0.251 | XX.X% |  |  |  | 400.01 | $   XXX.XX
0.201 | 0.25 |  |  |  | 300.01 | 400
0.151 | 0.2 |  |  |  | 200.01 | 300
0.101 | 0.15 |  |  |  | 100.01 | 200
0.051 | 0.1 |  |  |  | 50.01 | 100
0.001 | 0.05 |  |  |  | 0.01 | 50
No Change |  |  |  |  | No Change
-0.001 | -0.05 |  |  |  | -0.01 | -50
-0.051 | -0.1 |  |  |  | -50.01 | -100
-0.101 | -0.15 |  |  |  | -100.01 | -200
-0.151 | -0.2 |  |  |  | -200.01 | -300
-0.201 | -0.25 |  |  |  | -300.01 | -400
-0.251 | -XX.X% |  |  |  | -400.01 | $   (XXX.XX)
 | Total |  |  |  |  | Total
Insurer Notes:
Notes:
1.  Enter the maximum proposed increase and maximum proposed decrease percentages in cells B9 and B21
2.  Enter the maximum proposed increase and maximum proposed decrease dollars in cells G9 and G21
3.  If policies will receive a rate change > +25.0% or < -25.0%, then list the actual percentage change, the actual dollar change, and the rating variable changes that are driving the rate change for the 5 policies receiving the largest percentage increases and the 5 policies receiving the largest percentage decreases
4.  If policies will receive a dollar change > +$400 or < -$400, then list the actual dollar change, the actual percentage change, and the rating variable changes that are driving the rate change for the 5 policies receiving the largest dollar increases and the 5 policies receiving the largest dollar decreases
5.  If proposing a cap, then complete exhibit with and without the use of capping
6.  [NAME] exhibit for each Program type being filed (i.e. Auto, Motorcycle, etc)
Spreadsheet: 24869d1215748266-totals-from-two-criteria-sales-amount-and-sales-agent-name-stores-stats-sample-build
Sheet: Performance Sheet

 | Success Line |  |  | Original Calls |  |  | First Follow-Ups |  |  | Second Follow-Ups |  |  | Pipeline |  |  |  | Upsells |  | [NAME] |  |  |  | Basals
ProStores Consultant | Sold | Unsold | Rejected | Sold | Unsold | Rejected | Sold | Unsold | Rejected | Sold | Unsold | Rejected | Newsletters | Follow-Ups | Overdue | Over 10 | PayPal | DesignServices | Express | Business | Advanced | Enterprise | 90 Day Attendance | New QC | New QC Avg. | [NAME]
Sales1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 12 | 1 | 0
Sales2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 4 | 0 | 0
Sales3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 0
Spreadsheet: 705203d1605925338-convert-time-series-ohlc-data-frequency-from-daily-to-weekly-ohlc-data
Sheet: Daily

Date | Open | High | Low | Close | Volume | OI | Weekday | Week | Year
2014-11-30 00:00:00 | 376.57 | 381.99 | 373.32 | 373.34 | 1145566.61 | 0
2014-12-01 00:00:00 | 376.4 | 382.31 | 373.03 | 378.39 | 2520662.37 | 0
2014-12-02 00:00:00 | 378.39 | 382.86 | 375.23 | 379.25 | 2593576.46 | 0
2014-12-03 00:00:00 | 379.25 | 383 | 374.23 | 376.67 | 2998357.92 | 0
2014-12-04 00:00:00 | 376.67 | 378.99 | 360.01 | 365.2 | 3297896.46 | 0
2014-12-05 00:00:00 | 365.2 | 377.89 | 363.99 | 374.95 | 3331762.49 | 0
2014-12-06 00:00:00 | 374.95 | 376.99 | 371.31 | 375.07 | 861748.71 | 0
2015-11-29 00:00:00 | 356.78 | 373.15 | 354.45 | 371.04 | 2798580.83 | 0
2015-11-30 00:00:00 | 371.48 | 383 | 367.11 | 377.98 | 6688039.27 | 0
2015-12-01 00:00:00 | 376.7 | 379 | 354.56 | 362.95 | 5610058.11 | 0
2015-12-02 00:00:00 | 363.06 | 363.06 | 348.64 | 359.97 | 4282488.25 | 0
2015-12-03 00:00:00 | 359.11 | 370.53 | 356.21 | 361.32 | 4394915.48 | 0
2015-12-04 00:00:00 | 361.48 | 364.3 | 355.92 | 362.3 | 3573289.38 | 0
2015-12-05 00:00:00 | 363.62 | 389.89 | 363 | 384.67 | 6173704.59 | 0
[NAME] OHLC Data Frequency (from Daily to Weekly)
Hello, looking for some help to convert daily Open, High, Low, Close (OHLC) data to weekly format
Open = Open value on the 1st day of the 7 day range
High = [NAME] value for the 7 day range
Low = Min Low value for the 7 day range
Close = Close value on the 7th day of the 7 day range
Volume = Sum of volume added each day for the 7 day range.
OI = Sum of open interest added each day for the 7 day range
- the "Date" column on the weekly table should represent day 1 of each 7 day range.
- my data spans multiple years and I only want to aggregate daily data from the same week of the same year (i.e. week number 49 from 2014 should not be added to week number 49 from 2015).
Spreadsheet: 67828d1268334901-indexing-larger-value-copy-of-book3
Sheet: Customers

Account | Customer | Quantity | UM | Price | Document # | Rep | Date | Type | Discount | Cost | Tax Code | Revenue Account | Expense Account | Location/Sub-Location | Net Price | Week Created | Month Created | Net Charge Amount
396611 | [NAME] | 1 | EA | 339 | SO-5169750 | NLE | 2009-01-02 00:00:00 | [NAME] | 0 | 220 | EXEMPT |  |  | MAIN | 339 | WEEK 1,2009 | 2009, 1
403590 | [NAME] | 1 | EA | 339 | SO-5175793 | NLE | 2009-01-29 00:00:00 | [NAME] | 0 | 220 | EXEMPT |  |  | MAIN | 339 | WEEK 5,2009 | 2009, 1
421516 | [NAME] | 1 | EA | 319 | SO-5191623 | NLE | 2009-05-21 00:00:00 | [NAME] | 0 | 202.4 | EXEMPT |  |  | MAIN | 319 | WEEK 21,2009 | 2009, 5
420290 | [NAME] yates | 1 | EA | 319 | SO-5190527 | NLE | 2009-05-16 00:00:00 | [NAME] | 0 | 202.4 | EXEMPT |  |  | MAIN | 319 | WEEK 20,2009 | 2009, 5
Ok I have revised it for you…i..you will see that [NAME], [NAME], [NAME] yate have 2 shipments but
the net charge on one is higher than the other…is there a way to skip the lower charge and have the higher charge
put into S3
the higher charges are highlighted in green on Ground3 sheet
but as you can see [NAME] coleman only has 1 shipment and I still need to get the charge imported into the S colum also
Spreadsheet: 757376d1638219107-cell-value-from-multiple-sheets-to-be-presented-in-master-sheet-pt2-new-microsoft-excel-worksheet-2-
Sheet: M01122021

Country | A | B
Poland | Mark | Mark
U.K. | [NAME] | [NAME]
Italy | Francesco | Francesco
France | [NAME] | [NAME]
Germany | [NAME] | [NAME]
Greece | [NAME] | [NAME]
Spain | [NAME] | [NAME]
Russia | [NAME] | Guy
Malta | [NAME] | [NAME]
Austria | [NAME] | [NAME]
Spreadsheet: joe_parks__14911__ENA-Reliant Prepay
Sheet: Summary

ENA Prepays to Reliant
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
 |  | Date | Volume | Prepayments
 | Wed | 2002-02-06 00:00:00 |  | 22500
 | Fri | 2002-02-08 00:00:00 |  | 20000
 | Thu | 2002-02-14 00:00:00 |  | 26000
 | Thu | 2002-02-21 00:00:00 |  | 10000
 | Thu | 2002-02-28 00:00:00 |  | 19000
 |  | Total Prepays Feb 2002
 |  | Feb 2002 Purchases | 26000 | 62100
 |  | Cash Balance on 2/28/02
 | Wed | 2002-03-06 00:00:00 |  | 42000
 | Thu | 2002-03-14 00:00:00 |  | 25000
 | Thu |  |  | 30000 | 3/22/02 9:00AM  verfied payment with [NAME]
 | Thu |  |  | 0
 |  | Total Prepays Mar 2002
 |  | Mar 2002 Purchases | 26000
 |  | Cash Balance
Spreadsheet: 772089d1647002967-need-calculated-results-to-automatically-sort-when-input-data-changed-k-example
Sheet: Sheet1

Fragment of large spreadsheet, where user enters % Composition, and the k' values are calculated, based on Solute Data (which user also enters, and is different depending on the particular solutes being studied).
User entered data cells are in green.
 |  |  |  |  | Enter Mobile Phase % Composition: | 30 |  | User interactively enters the solvent composition here
 |  |  |  |  |  |  |  | Entering 10%, the k' happen to be ascending
 |  |  |  |  |  |  |  | However, enter 30% and they are not.  The k' and Peak ID have to automatically sort into ascending order
 |  |  |  |  |  |  |  | without user [NAME] when the user enters new data.
 |  |  | Enter Solute Data to Model Retention:
 |  |  | Solute: | Slope: | k'0 |  |  |  | Peak ID: | k' | α (k'2/k'1)
Constants for 5 solutes |  |  | Ura | 0.09354337706141921 | 0.868028284335231 |  |  |  |  |  | NA
are entered here |  |  | Theoph | 0.1334800381842085 | 11.71441374910261 |  |  |  |  |  |  |  |  | The calculated k' values are subsequently
 |  |  | Caff | 0.1465644272899692 | 27.92598620753177 |  |  |  |  |  |  |  |  | used by a  large, complex spreadsheet
 |  |  | 8-Cl-Theoph | 0.1447029923299291 | 38.03750054938092 |  |  |  |  |  |  |  |  | and charts, but it is necessary for the calculated k'
 |  |  | Impurity | 0.2723686837195675 | 264.9584621184976 |  |  |  |  |  |  |  |  | values to be in ascending order
 |  |  |  |  |  |  |  |  | The resulting k' values
 |  |  |  |  |  |  |  |  | are calculated here
 |  |  |  |  |  |  |  |  | for a given % mobile phase
 |  |  |  |  |  |  |  |  | composition.  Peak ID must move as well and stay with its k'
 |  |  |  |  |  |  |  |  | These have to be in ascending order
 |  |  |  |  |  |  |  |  | If entering 10% e.g., they are ok
 |  |  |  |  |  |  |  |  | but for 30%, they are not ascending
 |  |  |  |  |  |  |  |  | Need to automatically have k' values
 |  |  |  |  |  |  |  |  | and ID in ascending order, so that other
 |  |  |  |  |  |  |  |  | calculations and graphs can be performed.
Spreadsheet: 183867d1349080912-how-to-connect-the-data-in-two-sheets-in-one-book-show-2-
Sheet: Sheet2

Name | CSN | Country | Partner Name | Job
[NAME] | 1 | X | A | Sales | [NAME]
Betty | 1 | X | A | Marketing | [NAME]
[NAME] | 2 | Y | B | Sales | Silver
Zee | 3 | Y | C | IT | Silver
 |  | X count | 2
 |  | Y count | 0
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 8a

Product1 | Cleared2 | Uncleared | TOTAL
Basis | 59 | 202 | 261
Cap/Floor | 0 | 295 | 295
Debt Option | 0 | 0 | 0
Exotic | 0 | 0 | 0
Fixed-Fixed | 0 | 32 | 32
Fixed-Float | 20598 | 3655 | 24253
FRA | 1225 | 136 | 1361
Inflation | 0 | 165 | 165
OIS | 94 | 151 | 245
Swaption | 0 | 1600 | 1600
TOTAL | 21976 | 6236 | 28212
Spreadsheet: 694393d1599583218-trend-data-display-symbol-trend-arrow-shane1966-
Sheet: Sheet1

 |  |  | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00
 |  | On Time Delivery - "Promise" | 0.91 | 0.85 | 0.9 | 0.81 | 0.8 | 0.87 | 0.92 | 0.91 | 0.83 | 0.85 | 0.87 | 0.86 | 0.83 | 0.93 | 0.84 | 0.77 | 1.5
 |  |  |  |  |  | Trend
 |  |  |  |  |  |  | What formula goes in this cell to show if the trend is going UP, [NAME], Or Staying same
 |  |  |  |  |  |  | And shows a symbol similar to above
Spreadsheet: juan_hernandez__17707__SCHED2001
Sheet: AUGUST

 |  |  |  |  |  |  |  |  |  |  | 24 HOUR SCHEDULE
 |  |  |  |  |  |  |  |  |  |  |  |  | AUGUST
NAME | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI
ERCOT | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
[NAME] |  |  |  |  |  | N | N | N |  |  | D | D |  |  |  | N | N | N | N |  |  |  |  |  |  |  | N | N | N | N
 |  | N | N | N | N |  |  |  |  |  |  |  | N | N | N |  |  | D | D |  |  |  | N | N | N | N
[NAME] | N |  |  | D | D |  |  |  | N | N | N | N |  |  |  |  |  |  |  | N | N | N |  |  | D | D |  |  |  |  | N
SOUTHEAST
[NAME] | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
RUDY ACEVEDO | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
MIGUEL GARCIA | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
Vacant
ANDREW GREER | N |  |  |  |  | N | N | N |  |  | D | D |  |  |  | N | N | N | N |  |  |  |  |  |  |  | N | N | N | N
MAURICIO TREJO |  |  |  | D | D |  |  |  | N | N | N | N |  |  |  |  |  |  |  | N | N | N |  |  | D | D |  |  |  |  | N
MIDWEST
[NAME] | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
J.D.KINSER | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
DEAN LAURENT | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
 |  |  |  |  |  | N | N | N |  |  | D | D |  |  |  | N | N | N | N |  |  |  |  |  |  |  | N | N | N | N
 | N |  |  | D | D |  |  |  | N | N | N | N |  |  |  |  |  |  |  | N | N | N |  |  | D | D |  |  |  |  | N
DUSTIN COLLINS |  | N | N | N | N |  |  |  |  |  |  |  | N | N | N |  |  | D | D |  |  |  | N | N | N | N
NIGHTS
DAYS
Spreadsheet: 236324d1368750779-how-do-i-create-a-calendar-drop-down-in-excel-benefit-tracker-fy14-v2
Sheet: Tracker

 |  |  |  | CAPEX | OPEX | CAPEX | OPEX | CAPEX | OPEX | CAPEX | OPEX | CAPEX | OPEX
 |  |  |  | Full | Full | Light | Light | Superstore | Superstore | Light | Light | Basic | Basic
Updated: 21-Feb-13 |  |  |  | Greenacres | Greenacres | [NAME] | [NAME] | Gungahlin | Gungahlin | [NAME] | [NAME] | Yeppoon | Yeppoon
 |  |  |  | 2012-07-18 00:00:00 | 2012-07-18 00:00:00 | 2012-07-18 00:00:00 | 2012-07-18 00:00:00 | 2012-07-25 00:00:00 | 2012-07-25 00:00:00 | 2012-08-08 00:00:00 | 2012-08-08 00:00:00 | 2012-08-08 00:00:00 | 2012-08-08 00:00:00
Sub Activity | Capex Total | Opex Total | Total | 7 | 7 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8
Spreadsheet: ddcecd8c-bb06-4b3e-b251-d6f4bc64b334
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
FORNG | Test | FORNG | Orange IgG | Orange IgG | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain, red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.    Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr.                              Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FORNG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FORNG | Result | FORNG | Orange IgG | Orange IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 271001d1381780174-collecting-a-total-value-of-a-specific-from-specific-hours-and-number-of-days-jexzard
Sheet: Sheet1

Start |  | End |  | Duration |  |  | 08:00:00 | Start day
Date | Time | Date | Time | Days | Hrs | Hrs : min | 18:00:00 | End Day
2013-10-01 00:00:00 | 16:00:00 | 2013-10-01 00:00:00 | 16:30:00
2013-10-02 00:00:00 | 14:00:00 | 2013-10-04 00:00:00 | 14:00:00
Spreadsheet: 739339d1625653367-index-and-match-3-criteria-for-result-sample-data
Sheet: sUMMARY

 | P3
 | APAC | Data2 formula |  |  |  |  |  |  |  |  |  | P1 | US
Sunday |  |  |  |  |  |  |  |  |  |  |  |  | APAC
Monday |  |  |  |  |  |  |  |  |  |  |  |  | EMEAR
Tuesday |  |  |  |  |  |  |  |  |  |  |  | P2 | US
Wednesday |  |  |  |  |  |  |  |  |  |  |  |  | APAC
Thursday |  |  |  |  |  |  |  |  |  |  |  |  | EMEAR
Friday |  |  |  |  |  |  |  |  |  |  |  | P3 | US
Saturday |  |  |  |  |  |  |  |  |  |  |  |  | APAC
 |  |  |  |  |  |  |  |  |  |  |  |  | EMEAR
 |  |  |  |  |  |  |  |  |  |  |  | P4 | US
 |  |  |  |  |  |  |  |  |  |  |  |  | APAC
 |  |  |  |  |  |  |  |  |  |  |  |  | EMEAR
 |  |  |  |  |  |  |  |  |  |  |  | P5 | US
 |  |  |  |  |  |  |  |  |  |  |  |  | APAC
 |  |  |  |  |  |  |  |  |  |  |  |  | EMEAR
Spreadsheet: john_arnold__15179__SSDSTF Datatables 97 June 00
Sheet: Table 20

TABLE 20
USE A SEPARATE SHEET FOR METRO & COUNTY
INTERNATIONAL RESOURCES
Country | Sampling of Companies |  | No. of Companies |  | Total Employment
Associations | Business Associations Geared to Specific Countries |  | Fraternal Associations Geared to Specific Countries
Name
Country Orientation
No. of Members
Contact
Name
Title
Address
Foreign Institutions | Number
Foreign Banks w/Branches or Offices in the Area
US Banks in the Area w/International Departments
Foreign Consulates by Country
Full Service
Honorary
No. of Import/Export Brokers
No. of International Courier Services in the Area
No. of Language Translation Firms in the Area
Languages | Spanish | French | German | Chinese | Japanese | Korean | Vietnamese | Portuguese
No. of People Fluent in a Second Language
No. of Elementary & Secondary Schools w/Instruction Solely in another Language
No. of Special Schools Geared to Families of Foreign Nationalities
Service to Specific Countries/Regions | International Air Transportation to: |  | Name of Airport |  | City Distance to Airport |  | No. of Weekly                Non-Stop Flights
Canada
Mexico
South America
Europe
Asia
Australia/New Zealand
Educational International Focus
Dedicated Programs by Country or Region for Each College/University
University (Name) | Program Name
Spreadsheet: 220294d1363113811-populating-data-into-a-summary-tab-using-multiple-data-tabs-formulahelp1
Sheet: GHI

 |  |  |  | 202 | 204 | 52 | 20 | Total
 |  |  | AFH | 1 | 77 | 66 | 43
 |  |  | UNA | 2 | 0 | 34 | 0
 |  |  | AIS | 2 | 5 | 4456 | 0
 |  |  | MMM | 5 | 23 | 0 | 34
 |  |  | OFN | 1 | 3 | 445 | 0
 |  |  | SSB | 3 | 2 | 1 | 0
 |  |  | SPB | 11 | 1 | 0 | 34
 |  |  | MHMO | 2 | 0 | 0 | 44
 |  |  | MPPO | 1 | 1 | 2 | 0
 |  |  | HUI | 3334 | 3333 | 667 | 2367
 |  |  | NCI | 32 | 4 | 3 | 2222
 |  |  | HIP | 1 | 45 | 7 | 777
 |  |  | VIS | 1 | 0 | 777 | 434
 |  |  | AMI | 7675 | 67 | 1 | 1
 |  |  | JHP | 757 | 0 | 44 | 0
 |  |  | PIC | 1 | 76 | 4 | 56
 |  |  | HNI | 57 | 564 | 56 | 656
Spreadsheet: 12668ee9-7ae7-4ce5-ac06-606e6751515d
Sheet: Sheet1

# | Category | Project Arr. | Student Name | Project Title | Teacher Name | School
Senior
1 | EN | TN | [NAME], [NAME] | Electromechanically Detected Resonance Activated Damping | Mr. [NAME] | Rutherford High School
2 | EV | TN | Dudinsky, [NAME] | Gone With the Current | Mrs. [NAME] | Bay Haven Charter Academy
3 | EV | TN | Blankenship, [NAME] | TEAM: Ocean Acidification: Harmful Effects and Helpful Solutions | Mrs. [NAME] | [NAME]
4 | ME | TN | Wood, [NAME] | Red Bull's Effect on Heart Rate | Ms. [NAME] | Wewahitchka High School
5 | ME | TN | Akram, [NAME] | Organic Vs. Non Organic Fruit's Effect Upon Drosophila melanogaster Reproduction,  With Implications on Human Health | Mr. [NAME] | Rutherford High School
Junior
1 | BE | TN | Campbell, [NAME] | Shall We Stand: The Effects of Standing on Short-Term Memory | Mrs. [NAME] | Bay Haven Charter Academy
2 | BI | TN | Talkington, [NAME] | How Genetic Modification Changes Corn | Ms. [NAME] | Renascence School International Panama City
3 | BO | TN | [NAME], Vicky | The Effect of Different Colored Light on Plants | Ms. [NAME] | Renascence School International Panama City
4 | CH | TN | Matson, [NAME] | Juicy Batteries | Mrs. [NAME] | Bay Haven Charter Academy
5 | CO | TN | Freeman, [NAME] | First Compressions | Mrs. [NAME] | Surfside Middle School
6 | EA | TN | Folsom, [NAME], III | Fresh Water from the Sea | Mrs. [NAME] | Merritt Brown Middle School
7 | EN | TN | Fonzi, [NAME] | Optimizing Airplanes | Mr. [NAME] | Surfside Middle School
8 | EV | TN | Ashley, [NAME] | Trepidation of the Ocean's Acidification | Mr. [NAME] | Surfside Middle School
9 | MA | TN | Langford, [NAME] | Approximating Area Using Rectangles | Mr. [NAME] | Surfside Middle School
10 | ME | TN | [NAME], [NAME] | No Mo Squitoes: Repellent Formulation Development with Natural Ingredients Using  Design of Experiments on A. aegypti Via the K&D in Vitro Bioassay Method | Mrs. [NAME] | Bay Haven Charter Academy
11 | PH | TN | Curnin, [NAME] | Smokin' | Mrs. [NAME] | Everitt Middle School
12 | ZO | TN | Fish, [NAME] | The Affect of Humidity on the Volume of Viscid Glue | Mrs. [NAME] | Everitt Middle School
Spreadsheet: 778297d1650982037-pull-three-columns-from-one-sheet-to-another-and-have-them-aplhabetically-sorted-for-excel-help-forum
Sheet: Things I have tried

 |  |  |  |  |  |  |  |  |  |  |  |  | Correct but in text format |  |  |  | hvordan fjerne nuller
 | Correct but gives zero in cells that were blank |  |  |  |  |  | Wrong
 |  |  |  |  |  |  |  |  |  |  | Wrong
 |  | 100 | 10000 |  |  | 100 |  |  |  | 100 |  |  |  | 100 | 10000 |  |  | 100 | 10000 |  |  | 100 | 10000
 | A | 50 | 5000 |  | A | 50 |  |  | A | 50 |  |  | A | 50 | 5000 |  | A | 50 | 5000 |  | A | 50 | 5000
 | B | 0 | 6000 |  | B |  |  |  | B |  |  |  | B |  | 6000 |  | B | 0 | 6000 |  | B | 0 | 6000
 | B | 1 | 2000 |  | B | 1 |  |  | B | 1 |  |  | B | 1 | 2000 |  | B | 1 | 2000 |  | B | 1 | 2000
 | B | 0 | 1000 |  | B |  |  |  | B |  |  |  | B |  | 1000 |  | B | 0 | 1000 |  | B | 0 | 1000
 | B | 0 | 4000 |  | B |  |  |  | B |  |  |  | B |  | 4000 |  | B | 0 | 4000 |  | B | 0 | 4000
 | D | 800 | 500 |  | D | 800 |  |  | D | 800 |  |  | D | 800 | 500 |  | D | 800 | 500 |  | D | 800 | 500
 | W | 0 | 50 |  | W |  |  |  | W |  |  |  | W |  | 50 |  | W | 0 | 50 |  | F | 0 | 2000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W | 3 | 99
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W | 0 | 50
Spreadsheet: 162552d1339962837-display-value-different-from-entered-value-validationlistexample
Sheet: Sheet1

Name |  |  |  | Name List
Grant |  |  |  | Adam
 |  |  |  | Betty
 |  |  |  | [NAME]
 |  |  |  | Doug
 |  |  |  | [NAME]
 |  |  |  | Fran
 |  |  |  | Grant
 |  |  |  | Huey
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Lacy
 |  |  |  | Marvin
 |  |  |  | [NAME]
 |  |  |  | Oren
 |  |  |  | [NAME]
 |  |  |  | Quinn
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Ulan
 |  |  |  | Victor
 |  |  |  | [NAME]
 |  |  |  | Xavier
 |  |  |  | Yevette
 |  |  |  | Zorn
Spreadsheet: 849208d1699731792-formulas-are-turning-to-text-if-i-try-to-edit-them-in-any-way-ch-calc_v3
Sheet: Converter

 |  | Metric to Imperial |  |  |  |  |  |  | Imperial to Metric
 |  | Length / Distance
 |  | 0 | m | → |  | ft |  |  | 27.84 | ft | → |  | m
 |  | 73 | [NAME] | → |  | in |  |  | 2.441 | in | → |  | [NAME]
 |  | Weight
 |  | 445 | [NAME] | → |  | lb |  |  | 235 | lb | → |  | [NAME]
 |  | 13.84 | kg/m | → |  | lb/ft |  |  | 0 | lb/ft | → |  | kg/m
 |  | Volume
 |  | 0 | litres | → |  | bbl |  |  | 0 | bbl | → |  | litres
 |  |  |  | → |  | gal |  |  | 0 | gal | → |  | litres
 |  | Pressure
 |  | 15000 | kPa | → |  | [NAME] |  |  | 0 | [NAME] | → |  | kPa
 |  | Density
 |  | 0 | Kg/m³ | → |  | lb/gal |  |  | 0 | lb/gal | → |  | Kg/m³