tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: jeff_dasovich__14023__E220 Case 5-1 Northrop
Sheet: Sheet1

NORTHROP CASE 5-1
 | 1991
Net Income | 200.8 | 210.4 | -80.5 | 104.2 | 94.2
Net Cash Flow from Ops
COF
from customers |  |  |  |  |  | Uses of cash
progress payment | 2646.7 | 2618.1 | 2324 | 2099.2 | 1794.4 | Paid to suppliers | 4986.5 | 5220.6 | 4967 | 5302.7 | 5635.2
other collection | 3050.5 | 2976.8 | 2829.7 | 3459.6 | 3847.3 | Interest paid | 85 | 97.1 | 122.1 | 150.2 | 40.7
Interest Received | 11.5 | 2.4 | 2.8 | 2.4 | 1.7 | Fines from litigation | 10.2 | 17
Income Tax Refund | 3.1 | 1.1 | 0.2 | 2.2 | 0.2 | Settlement of accrued product support |  |  |  |  | 27.7
Settlement | 9 |  |  |  |  | Income Txes paid | 31.8 | 13.6 | 8 | 13.1 | 9.7
Other | 3.7 | 17.1 | 19.3 | 2.3 | 3.5 | Other | 1.6 | 1.1 | 0.3 | 2.7 | 0.9
Cash provided by ops |  |  |  |  |  | Cash Used | 5115.1 | 5349.4 | 5097.4 | 5468.7 | 5714.2
COF
from customers
progress payment |  |  |  |  |  | Paid to suppliers | 0.9748587515395593 | 0.975922533368228 | 0.974418330913799 | 0.969645436758279 | 0.9861747926218895
other collection |  |  |  |  |  | Interest paid | 0.01661746593419483 | 0.01815156840019441 | 0.02395338800172637 | 0.02746539396931629 | 0.007122606839102589
Interest Received |  |  |  |  |  | Fines from litigation | 0.00199409591210338 | 0.003177926496429505 | 0 | 0 | 0
Income Tax Refund |  |  |  |  |  | Settlement of accrued product support | 0 | 0 | 0 | 0 | 0.004847572713590704
Settlement |  |  |  |  |  | Income Txes paid | 0.006216887255381126 | 0.002542341197143604 | 0.001569427551300663 | 0.002395450472690036 | 0.001697525462881943
Other |  |  |  |  |  | Other | 0.0003127993587613145 | 0.0002056305380042621 | 5.885353317377486e-05 | 0.0004937187997147403 | 0.0001575023625354381
Cash provided by ops |  |  |  |  |  | Cash Used | 1 | 1 | 1 | 1 | 1
Uses of cash
Paid to suppliers | 4986.5 | 5220.6 | 4967 | 5302.7 | 5635.2
Interest paid | 85 | 97.1 | 122.1 | 150.2 | 40.7
Fines from litigation | 10.2 | 17
Settlement of accrued product support |  |  |  |  | 27.7
Income Txes paid | 31.8 | 13.6 | 8 | 13.1 | 9.7
Other | 1.6 | 1.1 | 0.3 | 2.7 | 0.9
Cash Used
Paid to suppliers
Interest paid
Fines from litigation
Settlement of accrued product support
Income Txes paid
Other
Cash Used
Spreadsheet: 154903d1336594402-creating-a-complex-program-forum-post
Sheet: Sheet1

(NAME) |  |  |  |  |  |  |  | Burn Permit: ####
(ADDRESS) |  |  |  |  |  |  |  | Issue Date: 1/1/2012
(PHONE NUMBER
BIRTH INFORMATION |  |  |  |  | Projected Outcome Without Sale
Date: | TOC | PM10 | CO |  | Date: | TOC | PM10 | CO
2008-04-21 00:00:00 | 6.09 | 0 | 0
CERTIFICATE ####
TOC |  |  |  |  | TOC Outcome with Sale
 | AMOUNT | DOLLAR | POLLUTANT | COMMENTS | Date: | TOC
DATE | SOLD | /PER TON | BALANCE
2009-04-21 00:00:00 | -1 | 500
2010-04-21 00:00:00 | 0 | 0
2011-04-20 00:00:00 | -1 | 600
2011-04-21 00:00:00 | 0 | 0
2012-04-20 00:00:00 | -1 | 70
2012-04-21 00:00:00 | 0 | 0
2013-04-20 00:00:00 | -0.05 | 100
2013-04-21 00:00:00 | 0 | 0
Spreadsheet: 102884d1300799350-rename-product-number-and-adding-a-path-urllist
Sheet: Sheet1

AA07006 | mydomain.com/images/productimage/A/A07006.jpg |  | 1 |  | A | <<<< UNIQUE LIST
ZU07045 | mydomain.com/images/productimage/Z/Z07045.jpg |  | 2 |  | Z
BK09858 | mydomain.com/images/productimage/B/B09858.jpg |  | 3 |  | B
AA07019 | mydomain.com/images/productimage/A/A07019.jpg |  |  |  | X
ZU07046 | mydomain.com/images/productimage/Z/Z07046.jpg
BK09832 | [NAME]
AA08006 | mydomain.com/images/productimage/A/A08006.jpg
ZU07845 | mydomain.com/images/productimage/Z/Z07845.jpg
BK08858 | mydomain.com/images/productimage/B/B08858.jpg
XY23456 | mydomain.com/images/productimage/X/X23456.jpg |  | 10
 | mydomain.com/images/productimage//.jpg
 | mydomain.com/images/productimage//.jpg
 | mydomain.com/images/productimage//.jpg
 | mydomain.com/images/productimage//.jpg
 | mydomain.com/images/productimage//.jpg
 | mydomain.com/images/productimage//.jpg
Spreadsheet: 848030d1698840777-comparing-number-and-text-irregardless-of-arrangement-book1
Sheet: Sheet1

 | Number | Criteria | to show
 | 12345 | 21463 | 0.8 | 4/5 correct
 | 12345 | 21543 | 1 | 5/5 correct
 | 12345 | 88543 | 0.6 | 3/5 correct
 | 11122 | 18881 | 0.4 | 2/5 correct
 | 12121 | 11221 | 1 | 5/5 correct
 | 22221 | 2222111 | 1 | 5/5 correct
 | qwerty | wert |  | 4/6 correct
 | qwerty | qxxx |  | 1/6 correct
 | [NAME] | abxxx | 0 | 0/5 correct
 | [NAME] | qtqtq | 1 | 5/5 correct
 | what | hatwww | 1 | 4/4 correct
 | what | whhae | 0.75 | 3/4 correct
Spreadsheet: 221d9f72-b924-4b22-82cd-c381e9f24395
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
FLACO | Test | FLACO | Lacosamide (Vimpat) | Lacosamide (Vimpat) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) |  |  |  | 1 | mL | Submit only 1 of the following specimens:  Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not acceptable.) Spin down and send 1 mL of serum refrigerated. Note: 1. Indicate serum on request form.               2. Label specimen appropriately (serum).  [NAME] blood in a green-top (sodium heparin) tube(s). ([NAME] is not acceptable.) Spin down and send 1 mL of sodium heparin plasma refrigerated. Note: 1. Indicate plasma on request form.               2. Label specimen appropriately (plasma). | 0.6 mL Note: Submission of the m | Specimens other than	Serum, plasma Anticoagulants other than	Plain red-top, sodium heparin Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | <=15.0 ug/mL  Expected concentrations of lacosamide in patients receiving recommended daily dosages: up to 15.0 ug/mL. Toxic range not established.   Test Performed by: Medtox Laboratories, Inc                              402 W. County Road D                              St. Paul, MN 55112 | Monday through Sunday | 2 days | 4 - 6 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc
FLACO | [NAME] | VARIES | Varies |  |  |  | Refrigerated
FLACO | Result | Z2237 | Lacosamide | Lacosamide | Numeric |  |  |  |  | ug/mL |  |  |  |  |  |  |  |  |  | 59296-4
FLACO | Result | Z2238 | Desmethyllacosamide | Desmethyllacosamide | Alphanumeric |  |  |  |  | ug/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 218836d1362591690-excel-magic-regression-with-intercept-specified-excel-regression-non-zero-intercept-data-shifted
Sheet: Sheet4

T[0].Width[0] | 0.120756994844572 | T[1].Width[0] | 0.139748090045038 | T[2].Width[0] | 0.0937445249398801
T[0].Width[1] | 0.120874909199294 | T[1].Width[1] | 0.148725949052447 | T[2].Width[1] | 0.0938001571124134
T[0].Width[2] | 0.120215165991515 | T[1].Width[2] | 0.156678136891863 | T[2].Width[2] | 0.0933800836342886
T[0].Width[3] | 0.118813349144732 | T[1].Width[3] | 0.163549087522462 | T[2].Width[3] | 0.0924764334308931
T[0].Width[4] | 0.116735284231954 | T[1].Width[4] | 0.169347664534417 | T[2].Width[4] | 0.0911001457165032
T[0].Width[5] | 0.114084601449006 | T[1].Width[5] | 0.174130642825806 | T[2].Width[5] | 0.0892862379327381
T[0].Width[6] | 0.111000899991738 | T[1].Width[6] | 0.177985390127234 | T[2].Width[6] | 0.0870958588080538
T[0].Width[7] | 0.107648230085797 | T[1].Width[7] | 0.181014628064666 | T[2].Width[7] | 0.0846137704017512
T[0].Width[8] | 0.104196537593782 | T[1].Width[8] | 0.183324904441286 | T[2].Width[8] | 0.081940955620403
T[0].Width[9] | 0.100801454177867 | T[1].Width[9] | 0.185018788705729 | T[2].Width[9] | 0.0791836944882274
T[0].Z[0] | 0.34743353915041 | T[1].Z[0] | 0.755805269557642 | T[2].Z[0] | 0.290393028438294
T[0].Z[1] | 0.346461140176722 | T[1].Z[1] | 0.569784738803342 | T[2].Z[1] | 0.289860489033774
T[0].Z[2] | 0.351998138649085 | T[1].Z[2] | 0.477027875585802 | T[2].Z[2] | 0.293946740673926
T[0].Z[3] | 0.364593663223785 | T[1].Z[3] | 0.422930845531596 | T[2].Z[3] | 0.303275435906379
T[0].Z[4] | 0.385660842357548 | [NAME]] | 0.388528625103357 | T[2].Z[4] | 0.319084341951097
T[0].Z[5] | 0.417725380711254 | T[1].Z[5] | 0.365495690393839 | T[2].Z[5] | 0.343528790349564
T[0].Z[6] | 0.465028433296011 | T[1].Z[6] | 0.349603127998188 | T[2].Z[6] | 0.380329895955335
T[0].Z[7] | 0.534809207934273 | T[1].Z[7] | 0.338477104645754 | T[2].Z[7] | 0.436206689806659
T[0].Z[8] | 0.640166249231423 | T[1].Z[8] | 0.330684687727344 | T[2].Z[8] | 0.524386855584516
T[0].Z[9] | 0.807200027887563 | T[1].Z[9] | 0.325312377222964 | T[2].Z[9] | 0.674747507242082
Spreadsheet: 708c06d8-ec1a-4e6d-a1f6-883f868c8dd3
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Das AHV-Rentenalter wird erhöht.
 | Stadt/Land
Antwort | Land | Stadt
[NAME] | 0.31 | 0.32
Neutral/Weiss nicht | 0.11 | 0.13
[NAME] | 0.57 | 0.55
Angaben zu den [NAME]
Erhebungsjahr | 2010
Stichprobengrösse | 29292
Erhebungszeitraum | 02.10.2010 bis: 06.12.2010
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: POLS

Old course number | New course number
POLS-301 | POLS-2101
POLS-302 | POLS-2100
[NAME] | POLS-3600
POLS-311 | POLS-3110
POLS-320 | POLS-2200
POLS-440 | POLS-4400
POLS-460 | POLS-4600
POLS-470 | POLS-4700
POLS-480 | POLS-4800
POLS-489 | POLS-4890
POLS-505 | POLS-5150
POLS-510 | POLS-5000
POLS-520 | POLS-4200
POLS-520 | POLS-6200
POLS-530 | POLS-4300
POLS-530 | POLS-6300
POLS-531 | POLS-5310
POLS-536 | POLS-5360
POLS-538 | POLS-5380
POLS-540 | POLS-5400
POLS-548 | POLS-5480
POLS-563 | POLS-5630
POLS-737 | POLS-7370
POLS-845 | POLS-8450
POLS-863 | PADM-8200
Spreadsheet: 104851d1302285453-capturing-daily-values-from-one-sheet-to-another-example
Sheet: WORKSHEET 1

HOURLY PRODUCTION SHEET
 |  | DATE: | 2011-04-11 00:00:00 | 2011-04-11 00:00:00 | 2011-04-11 00:00:00 | 2011-04-11 00:00:00 | 2011-04-11 00:00:00 | 2011-04-11 00:00:00 | 2011-04-11 00:00:00
 |  | SIZE | NUMBER PRODUCED | NUMBER REJECTED | # OF MEN IN CELL | DOWNTIME HOURS | DOWNTIME CODE | Pieces Per 1 Labor Hour | Goal Pieces Per Labor Hour
HOUR 1 |  | 200 | 2000 | 5 | 8 | 1 | Setup | 92 | 736
HOUR 2 |  | 200 | 4000 | 8 | 8 | 2 | [NAME] | 92 | 736
HOUR 3 |  | 200 | 3000 | 12 | 8 | 3 | Scheduled Maintenance | 92 | 736
HOUR 4 |  | 45 | 1400 | 8 | 8 | 4 | Not Scheduled | 179 | 1432
HOUR 5 |  | 90 | 1000 | 6 | 8 | 5 | Other | 137 | 1096
HOUR 6 |  | 90 | 1000 | 6 | 8 | 6 | Setup | 137 | 1096
HOUR 7 |  | 90 | 900 | 9 | 8 | 7 | [NAME] | 137 | 1096
HOUR 8 |  | 250 | 500 | 20 | 8 | 8 | Scheduled Maintenance | 76 | 608
2ND SHIFT |  | 500 | 240 | 100 | 4 | 9 | Not Scheduled | 62 | 248
 |  |  | 14040 | 174 | 68 |  |  |  | 7784
 |  |  |  |  | 206.4705882352941 |  |  |  | 114.4705882352941
15 | 222 | Setup |  | 7
25 | 242 | [NAME] |  | 9
32 | 287 | Scheduled Maintenance |  | 11
45 | 179 | Not Scheduled |  | 13
65 | 172 | Other |  | 5
90 | 137
115 | 113
150 | 101
200 | 92
250 | 76
500 | 62
Spreadsheet: 86037d1286005804-using-a-date-format-in-a-cell-instead-of-a-text-format-to-support-a-formula-cash-deposits-and-orders-sample-3-
Sheet: 09-09-10

CASH ORDER
Denomination |  | 2010-09-09 00:00:00 | Area #1 | Area #2 | Area #3 | Area #4 | Area #5 | Area #6 | Total
100 |  | 424100 |  | 2084600
20 |  | 1273580 |  | 1147000
10 |  | 31980 | 14550 | 0
5 |  | 311610 |  | 286100
1 |  | 102391 |  | 52000
0.25 |  | 12463.25 | 13055 | 0 |  | 5000 | 5000
0.05 |  | 6223.6 | 1746 | 0 |  | 2000 | 2000
0.01 |  | 1372.53 | 447 | 0
Total
Spreadsheet: 845785d1697129605-dependent-drop-down-name-issue-buildingroom-tora-v1-
Sheet: BaseData

Biggest Building | Medium Building | [NAME] | Bigger Building
Room 1 | Room a | Room I | Room 01
Room 2 | Room b | Room II | Room 02
Room 3 | Room c | Room III | Room 03
Room 4 | Room d | Room IV | Room 04
Room 5 |  | Room V | Room 05
Spreadsheet: 733796d1621830510-index-formula-search-in-different-sheet-testalles-ans
Sheet: Hours

Project | Datum | Firma | Nummer | Vertrek | Tijd | Aankomst | Naam | Telefoon | Tropco's | Aantal | [NAME] | Wie D | Inkoop NL | Inkoop D | [NAME] | Verkoop D
5235 |  |  |  |  |  |  |  |  | 2 | 1 |  | nl |  |  |  |  |  | Uren inkoop |  |  | Km inkoop
5258 |  |  |  |  |  |  |  |  | 1 | 2 | [NAME] | nl |  |  |  |  |  | Uren verkoop |  |  | Km verkoop
5259 |  |  |  |  |  |  |  |  | 2 | 2 | [NAME] | nl |  |  |  |  |  | Verschil uren |  |  | [NAME] km
5259 |  |  |  |  |  |  |  |  | 2 | 2 |  | nl |  |  |  |  |  | Inkoop NL | 42.5 |  | Inkoop D | 1.15
5259 |  |  |  |  |  |  |  |  | 2 | 2 |  | nl |  |  |  |  |  | Inkoop NL |  |  | Inkoop D
5259 |  |  |  |  |  |  |  |  | 1 | 2 |  | nl |  |  |  |  |  | [NAME] |  |  | Verkoop D
5260 |  |  |  |  |  |  |  |  | 2 | 2 | [NAME] | nl |  |  |  |  |  | [NAME] |  |  | Verschil D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 45 |  | Verkoop D | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj NL ink |  |  | Totaal inkoop
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ver |  |  | Totaal verkoop
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj KM ink |  |  | Totaal verschil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ver
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project verschil NL |  |  |  | Project verschil D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal uren NL |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal Verkoop NL |  |  | Totaal verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per begeleider
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zoek project | Aantal beg | Inkoop NL | Inkoop D | [NAME] | Verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Klant | aantal beg
Spreadsheet: aee207e8-ccd3-494b-aa41-2b8986fcda7d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: Lower Eastern Shore (Tangier) for all available years | 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 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
Indicator | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
Chlorophyll a | 60.42 | 30.7 | 23.06 | 33.76 | 20.73 | 30.48 | 75.88 | 33.75 | 20.92 | 45.7 | 12.08 | 6.01 | 22.26 | 44.51 | 17.74 | 16.12 | 63.4 | 12.37 | 15.88 | 7.92 | 40.93 | 33.45 | 38 | 44.658 | 15.838
Aquatic Grasses | 29.3 | 27.19 | ND | 34.87 | 36.49 | 40.14 | 42.51 | 42.04 | 31.31 | 27.67 | 25 | 23.34 | 15.26 | 24.95 | 30.61 | 36.29 | 42.97 | 25.35 | 24.27 | 31.44 | 23.96 | 23.48 | 30 | 36.6 | 34.35
[NAME] | 92.47 | 92.32 | 92.38 | 82.35 | 81.82 | 81.36 | 95.74 | 85.1 | 86.19 | 93.78 | 86.81 | 84.64 | 80.63 | 90.46 | 87.1 | 83.06 | 93.07 | 81.82 | 86.89 | 57.34 | 87.72 | 91.59 | 77 | 85.553 | 81.677
[NAME] | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | 68.46 | 73.57 | 53.57 | 50 | 45.28 | 75.13 | 42.88 | 69.67 | 69.98 | 65.71 | 66.31 | 28.87 | 44 | 51.37717564 | 56.79599
Water Clarity | 28.4 | 11.41 | 15.37 | 18.17 | 12.23 | 13.23 | 14.11 | 0 | 4.68 | 7.52 | 3.03 | 2.73 | 0 | 9.36 | 5.46 | 7.39 | 6.55 | 5.46 | 0 | 1 | 5.17 | 0 | 19 | 25.951 | 12.211
Phytoplankton Index | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | nd |  | Insufficient data
Water Quality Index | 62.5 | 44.82 | 43.73 | 44.85 | 38.22 | 41.75 | 62.22 | 39.55 | 37.1 | 49.19 | 33.83 | 30.98 | 34.21 | 48.28 | 36.69 | 35.38 | 54.64 | 33.02 | 33.95 | 21.79 | 44.44 | 41.68 | 45 | 52.054 | 36.57533333
Biotic Index | Insufficient Data | Insufficient Data | Insufficient Data | Insufficient Data | Insufficient Data | Insufficient Data | Insufficient Data | Insufficient Data | Insufficient Data | Insufficient Data | 46.73 | 48.46 | 34.41 | 37.47 | 37.95 | 55.71 | 42.93 | 47.51 | 47.13 | 48.58 | 45.14 | 26.17 | 37 | 43.98858782 | 45.572995
Bay Health Index | Insufficient Data | Insufficient Data | Insufficient Data | Insufficient Data | Insufficient Data | Insufficient Data | Insufficient Data | Insufficient Data | Insufficient Data | Insufficient Data | 40.28 | 39.72 | 34.31 | 42.88 | 37.32 | 45.55 | 48.79 | 40.27 | 40.54 | 35.18 | 44.79 | 33.93 | 40.85 | 48.02129391 | 41.07416417
Spreadsheet: 177695d1346403430-auto-fill-with-conditions-using-if-vlookup-excel_forum
Sheet: Sheet3

 |  |  |  | (Given info)
 | (outcome) |  |  | PO# | Ctns |  |  |  |  | Expected Result
Ctn. 1 | IV661445 |  |  | IV661445 | 1 | - | 1 |  |  | Ctn. 1 | IV661445
Ctn. 2 | IV661446 |  |  | IV661446 | 2 | - | 2 |  |  | Ctn. 2 | IV661446
Ctn. 3 | IV661448 |  |  | IV661448 | 3 | - | 3 |  |  | Ctn. 3 | IV661448
Ctn. 4 | IV661447 |  |  | IV661447 | 4 | - | 8 |  |  | Ctn. 4 | IV661447
Ctn. 5 | IV661447 |  |  | IV661449 | 9 | - | 9 |  |  | Ctn. 5 | IV661447
Ctn. 6 | IV661447 |  |  |  |  |  |  |  |  | Ctn. 6 | IV661447
Ctn. 7 | IV661447 |  |  |  |  |  |  |  |  | Ctn. 7 | IV661447
Ctn. 8 | IV661447 |  |  |  |  |  |  |  |  | Ctn. 8 | IV661447
Ctn. 9 | IV661449 |  |  |  |  |  |  |  |  | Ctn. 9 | IV661449
Spreadsheet: 796043d1663078913-countif-cells-within-a-range-and-are-filtered-afl-data-help
Sheet: Analysis

[NAME]
Parameters of Expected Score | Lower than expected range |  | Expected range |  | Higher than expected range
 | 0 | 5 | 6 | 14 | 15 | 100
 | Reading |  |  | Spelling |  |  | Mental Maths
 | Aut 1 | Spr 1 | Sum 1 | Aut 1 | Spr 1 | Sum 1 | Aut 1 | Spr 1 | Sum 1
Percentage of pupils below expected
Percentage of pupils at expected
Percentage of pupils above expected
 | Reading |  |  | Spelling |  |  | Mental Maths
 | Aut 1 | Spr 1 | Sum 1 | Aut 1 | Spr 1 | Sum 1 | Aut 1 | Spr 1 | Sum 1
Percentage of pupils who have made below  expected progress
Percentage of pupils who have made expected progress
Percentage of pupils who have made above expected progress
Selected Class/Year
Parameters of Expected Score | Lower than expected range |  | Expected range |  | Higher than expected range
 | 0 | 5 | 6 | 14 | 15 | 100
 | Reading |  |  | Spelling |  |  | Mental Maths
 | Aut 1 | Spr 1 | Sum 1 | Aut 1 | Spr 1 | Sum 1 | Aut 1 | Spr 1 | Sum 1
Percentage of pupils below expected
Percentage of pupils at expected
Percentage of pupils above expected
 | Reading |  |  | Spelling |  |  | Mental Maths
 | Aut 1 | Spr 1 | Sum 1 | Aut 1 | Spr 1 | Sum 1 | Aut 1 | Spr 1 | Sum 1
Percentage of pupils who have made below  expected progress
Percentage of pupils who have made expected progress
Percentage of pupils who have made above expected progress
Spreadsheet: 861672d1709555710-max-row-table-does-not-work-help-please-table-aligw
Sheet: Sheet1

 |  | Food Table |  |  |  |  |  |  |  |  | Food Table
 |  | Pizza |  |  |  |  |  |  |  |  | Pizza
 |  | Burger |  |  |  |  |  |  |  |  | Burger
 |  | Fries |  |  |  |  |  |  |  |  | Fries
 |  | Soda |  |  |  |  |  |  |  |  | Soda
 |  | Ice Cream |  |  |  |  |  |  |  |  | Ice Cream
 |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Fruit
 |  |  |  |  |  |  |  |  |  |  | More fruit
 |  | [NAME]
 |  | Min Row
 |  | [NAME]
Spreadsheet: 87741d1287598200-create-new-rows-based-on-multiple-cells-on-single-row-errors
Sheet: Action List

Project ID | TCS  QC Reviewer | TCS Processor | RDS  QC Reviewer | Review Needed | Error Count | Rows | Need Row? | QC Category | QC Question
[PHONE] | Mr. [NAME] | Miss. A | Mrs. A | Yes | 4 |  |  | Type B | Q1
[PHONE] | Mr. [NAME] | Miss. A | Mrs. A | Yes | 4 |  |  | Type B | Q2
[PHONE] | Mr. [NAME] | Miss. A | Mrs. A | Yes | 4 |  |  | Type B | Q3
[PHONE] | Mr. [NAME] | Miss. A | Mrs. A | Yes | 4 |  |  | Type D | Q3
[PHONE] | Mr. [NAME] | Miss. B | Mrs. B | Yes | 3
[PHONE] | Mr. [NAME] | Miss. B | Mrs. B | Yes | 3
[PHONE] | Mr. [NAME] | Miss. B | Mrs. B | Yes | 3
Spreadsheet: 103286d1301047189-if-formula-for-corresponding-tables-copy-of-copy-of-auto-adjust
Sheet: Sheet1

TABLE ONE |  |  |  |  | TABLE TWO
Distance | Lengths | Before | 100% Adjusted |  | distance | barrier | % before barrier | 100% adj number | formula in m3:m11
1000 m | 9.65 | 0.89 |  |  | 1000 m | 1 | 0.5 |  | 0.034
1200 m | 11.57 | 0.96 |  |  | 1200 m | 1 | 0.5 |  | 0.042
1400 m | 12.91 | 1 |  |  | 1400 m | 1 | 0.5 |  | 0.044
1600 m | 8.96 | 0.57 |  |  | 1600 m | 1 | 0.5 |  | 0.044
 |  |  |  |  | 1800 m | 1 | 0.5 |  | 0.046
 |  |  |  |  | 2200 m | 1 | 0.5 |  | 0.048
 |  |  |  |  | 2400 m | 1 | 0.5 |  | 0.052
 |  |  |  |  | 2850 m | 1 | 0.5 |  | 0.054
 |  |  |  |  | 3200 m | 1 | 0.5 |  | 0.054
I have manually entered the formula want in cells d3:d6. Ideally though I would like a formula to automatically change the formula in cells d3:d6 depending on the distance in cells b3:b6.
I have pasted the formulas fromI3:I11 in cells J3:J11 without the = sign to show the formulas.
So if I changed cell A3 to 200m I would like cell D3 's formula to change from (((100-(c3*100))*0.034)+b3) to (((100-(c3*100))*0.042)+b3)
Spreadsheet: 166213d1341500470-some-sort-of-lookup-and-return-value-test-
Sheet: Sport

Sport | Completed
Hockey | June 27/2013
Other
Hockey
Walking
Walking
Soccer | June 27/2015
Soccer | June 1,2012
Soccer
Softball
Soccer
Walking
Soccer | Complete
Softball
Soccer | June 27/2012
Soccer
Softball
Walking
Skiing
Other
Skiing | June 27/2016
Skiing | 2012-05-17 00:00:00
Skiing | june 30/2012
Other
Hockey
Softball
Walking | Complete
other
Walking
Skiing
Walking
Soccer
Walking | June 27/2014
Soccer
Softball
Skiing
Softball | Complete
Softball | Complete
Spreadsheet: 824010d1680247644-get-data-from-other-files-2023002
Sheet: Invoice

 | INVOICE
 | Factuurnummer: | 2023002
 | Factuurdatum: | 2023-03-12 00:00:00
 | Vervaldatum:
 | OMSCHRIJVING |  |  |  |  |  | SUBTOTAAL
 | description
 |  |  |  |  |  | Subtotaal excl. BTW
 |  |  |  |  | BTW | over
 |  |  |  |  | 0.21
 |  |  |  |  |  | Totaal te betalen
Spreadsheet: 806084d1669100131-copy-from-sheet-to-sheet-based-on-rows-and-columns-excel-help-example-ans-2
Sheet: October 2020

 | Location 1 | Location 2 | Location 3 | Location 4 | Location 5 | Location 6 | Location 7 | Location 8 | Location 9 | Location 10
October 2020 Sales | 1111 | 2222 | 3333 | 4444 | 5555 | 6666 | 7777 | 8888 | 9999 | 11110
October 2019 Sales | 111 | 222 | 333 | 444 | 555 | 666 | 777 | 888 | 999 | 1110
% Change | % | % | % | % | % | % | % | % | % | %
October 2018 Sales | 11 | 22 | 33 | 44 | 55 | 66 | 77 | 88 | 99 | 110
% Change from 2020 | % | % | % | % | % | % | % | % | % | %
Spreadsheet: kevin_hyatt__19595__Feb01pnr
Sheet: Summary

Transwestern Pipeline Company
Park n Ride Service
Actual Billing Summary
Billing Month | Buyer | Purchase Order # | Contract | POI | Dekatherm | Rate/Dth | Imputed Rate | Rate_Type Daily/Total | Invoice Amount | Remaining Balance
2001-02-01 00:00:00 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 | TOTALS