tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: e08402db-6ea4-49ba-a535-2f5c5822b074
Sheet: Report

Unit | Unit Priority | [NAME] | Objective Id | Objective Name | Objective Priority | Strategic Direction | Impact Type
Administrative Applications | 1 | Self Sufficient User Community | 1.1 | Provide user training | 1 | None | -- Pick One --
Administrative Applications | 1 | Self Sufficient User Community | 1.2 | Provide current documentation | 3 | None | -- Pick One --
Administrative Applications | 1 | Self Sufficient User Community | 1.3 | Publicize provided opportunities | 2 | None | -- Pick One --
Administrative Applications | 1 | Self Sufficient User Community | 1.4 | Permissions maintenance | 4 | None | -- Pick One --
Administrative Applications | 2 | Quality, timely and accurate project implementation | 2.1 | Implement structured project management | 2 | None | -- Pick One --
Administrative Applications | 2 | Quality, timely and accurate project implementation | 2.2 | Staff development | 1 | None | -- Pick One --
Administrative Applications | 1 | Employee Maintenance | 3.1 | Reclass UL Position | 1 | None | -- Pick One --
Administrative Applications | 1 | HR & Finance Systems Consolidation | 4.1 | Consolidate HR | 1 | None | -- Pick One --
Administrative Applications | 1 | HR & Finance Systems Consolidation | 4.2 | Consolidate Finance | 1 | None | -- Pick One --
Spreadsheet: 745161d1629789909-combine-columns-and-remove-zeros-errors-example-datasheet
Sheet: Look_up sheet

 | Searching panel
 | Name | Colour | Number | Animal | Insect |  | This is where the the match occurs and the index comes from here
 | [NAME] | red
 | Results
 | Name | Colour | Number | Animal | Insect |  | Name | Colour | Number | Animal | Insect |  | Master column
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I want to Index from this master column but the #N/A errors get in the way
 | Switch counter
Spreadsheet: eric_saibi__9899__102501
Sheet: Martins Creek 04

Owner Name |  | PPL Martins Creek LLC
Station Name |  | Martins Creek Power Station
Unit Name |  | Martins Creek 04
NERC Region |  | MAAC
State |  | PA
Fuel Type |  | Nat. gas/Fuel Oil
Capacity |  | 851 MW
Start Date |  | 2001-10-23 00:00:00
End Date |  | 2001-10-26 00:00:00
Comments |  | Tube leak
SIC |  | 4911
Plant ID |  | 1503204
Unit ID |  | 1005499
Outage ID |  | 18726
Spreadsheet: e06f7a58-63c3-4b38-af45-62564d88e1a2
Sheet: Table 3.5

Monthly Statistical Bulletin
3.5 Labour productivity
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012-13 | 2013-14
Labour productivity index (a) (b)
September | 96.4 | 96.6 | 99.1 | 102.2 | 104
December | 96.2 | 96.7 | 98.8 | 103 | 104.9
March | 96.9 | 95.6 | 101.1 | 103.4 | 106.2
June | 96.3 | 97.8 | 100.9 | 103.6 | 106.9
Annual | 96.6 | 96.6 | 100 | 103.7 | 105.8
Quarterly change (a) – per cent
September | 1.366982124079925 | 96.6 | 1.329243353783241 | 1.288404360753219 | 0.3861003861003809
December | -0.2074688796680562 | 96.7 | -0.3027245206861693 | 0.782778864970652 | 0.8653846153846132
March | 0.727650727650726 | 95.6 | 2.327935222672068 | 0.3883495145631031 | 1.239275500476651
June | -0.6191950464396427 | 97.8 | -0.1978239366963237 | 0.1934235976789154 | 0.6591337099811625
Annual change (a) – per cent
\
September | 3.322615219721342 | 0.2074688796680562 | 2.587991718426494 | 3.128153380423825 | 1.761252446183946
December | 3.21888412017168 | 0.5197505197505308 | 2.171664943123062 | 4.251012145748987 | 1.84466019417475
March | 3.969957081545061 | -1.341589267285869 | 5.753138075313814 | 2.274975272007936 | 2.707930367504829
June | 1.261829652996838 | 1.557632398753881 | 3.169734151329266 | 2.675916749256672 | 3.185328185328189
Annual | 2.985074626865654 | 0 | 3.519668737060044 | 3.699999999999989 | 2.025072324011575
(a) Quarterly figures are seasonally adjusted.
(b) Reference year for index is 2011-12 = 100.0.
Source: ABS, Australian national accounts: national income, expenditure and product, | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007
Cat. no. 5206.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-12-03 00:00:00
Spreadsheet: 6c571e87-9eae-46ab-b567-ecfdb702078d
Sheet: Sheet1

LAM RESEARCH CORPORATION | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
CONDENSED CONSOLIDATED STATEMENTS OF CASH FLOWS
(in thousands)
(unaudited)
 |  | Three Months Ended |  |  |  |  |  | Nine Months Ended
 |  | March 26, |  | December 25, |  | March 27, |  | March 26, |  | March 27,
 |  | 2006 |  | 2005 |  | 2005 |  | 2006 |  | 2005
CASH FLOWS FROM OPERATING ACTIVITIES:
Net income |  | 86337 |  | 77778 |  | 59451 |  | 213606 |  | 232815
Adjustments to reconcile net income to net cash provided
by operating activities:
Depreciation and amortization |  | 5208 |  | 4995 |  | 6324 |  | 16235 |  | 19212
Deferred income taxes |  | 17935 |  | -647 |  | -13413 |  | 32662 |  | 38165
Restructuring charges, net |  | 0 |  | 0 |  | 14201 |  | 0 |  | 14201
Stock-based compensation |  | 6029 |  | 6044 |  | 74 |  | 17319 |  | 367
Income tax benefit from stock option exercises |  | 0 |  | 0 |  | 30353 |  | 0 |  | 30353
Other, net |  | -864 |  | 109 |  | 1308 |  | 1087 |  | 2631
Change in working capital accounts |  | -5010 |  | 23126 |  | 3001 |  | -12488 |  | -45698
Net cash provided by operating activities |  | 109635 |  | 111405 |  | 101299 |  | 268421 |  | 292046
CASH FLOWS FROM INVESTING ACTIVITIES:
Capital expenditures |  | -6447 |  | -5036 |  | -4640 |  | -16141 |  | -18623
Net sales (purchases) of available-for-sale securities |  | 26703 |  | 14191 |  | 30976 |  | 92492 |  | -27744
Net cash provided by/(used for) investing activities |  | 20256 |  | 9155 |  | 26336 |  | 76351 |  | -46367
CASH FLOWS FROM FINANCING ACTIVITIES:
Payments on capital lease |  | -67 |  | 0 |  | 0 |  | -67 |  | 0
Treasury stock purchases |  | -73602 |  | -61917 |  | -67793 |  | -214209 |  | -67793
Reissuances of treasury stock |  | 4515 |  | 0 |  | 0 |  | 9652 |  | 0
Proceeds from issuance of common stock |  | 61602 |  | 61926 |  | 48923 |  | 135702 |  | 90848
Net cash provided by/(used for) financing activities |  | -7552 |  | 9 |  | -18870 |  | -68922 |  | 23055
Effect of exchange rate changes on cash |  | 1724 |  | -1605 |  | 1524 |  | -255 |  | 4325
Net increase in cash and cash equivalents |  | 124063 |  | 118964 |  | 110289 |  | 275595 |  | 273059
Cash and cash equivalents at beginning of period |  | 633782 |  | 514818 |  | 326173 |  | 482250 |  | 163403
Cash and cash equivalents at end of period |  | 757845 |  | 633782 |  | 436462 |  | 757845 |  | 436462
Spreadsheet: 285952d1387958397-how-to-properly-setup-the-page-to-get-an-accurate-cashflow-forum-attribution
Sheet: Sheet1

 | Employee 1 | Employee 2 | Employee 3 | Employee 4 |  | weekly invoices |  | Actual Payout | Employee 1 | Employee 2 | Employee 3 | Employee 4
2014-01-20 00:00:00 | 2500 |  |  |  |  |  |  | 2014-01-20 00:00:00
2014-01-27 00:00:00 | 2500 |  |  |  |  |  |  | 2014-01-27 00:00:00
2014-02-03 00:00:00 | 2500 |  |  |  |  |  |  | 2014-02-03 00:00:00
2014-02-10 00:00:00 | 2500 |  |  |  |  |  |  | 2014-02-10 00:00:00
2014-02-17 00:00:00 | 2500 | 2500 |  |  |  |  |  | 2014-02-17 00:00:00
2014-02-24 00:00:00 | 2500 | 2500 |  |  |  |  |  | 2014-02-24 00:00:00
2014-03-03 00:00:00 | 2000 | 2000 |  |  |  |  |  | 2014-03-03 00:00:00
2014-03-10 00:00:00 | 2500 | 2500 |  |  |  |  |  | 2014-03-10 00:00:00
2014-03-17 00:00:00 | 2500 | 2500 | 2500 |  |  |  |  | 2014-03-17 00:00:00
2014-03-24 00:00:00 | 2500 | 2500 | 2500 |  |  |  |  | 2014-03-24 00:00:00
2014-03-31 00:00:00 | 2500 | 2500 | 2500 |  |  |  |  | 2014-03-31 00:00:00
2014-04-07 00:00:00 | 2500 | 2500 | 2500 |  |  |  |  | 2014-04-07 00:00:00
2014-04-14 00:00:00 | 2500 | 2500 | 2500 | 2500 |  |  |  | 2014-04-14 00:00:00
2014-04-21 00:00:00 | 2500 | 2500 | 2500 | 2500 |  |  |  | 2014-04-21 00:00:00
2014-04-28 00:00:00 | 2500 | 2500 | 2500 | 2500 |  |  |  | 2014-04-28 00:00:00
2014-05-05 00:00:00 | 2500 | 2500 | 2500 | 2500 |  |  |  | 2014-05-05 00:00:00
2014-05-12 00:00:00 | 2500 |  |  |  |  |  |  | 2014-05-12 00:00:00
2014-05-19 00:00:00 | 2500 |  |  |  |  |  |  | 2014-05-19 00:00:00
Spreadsheet: 03d854bd-fa38-41ae-8018-473efb645b75
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
FNLV | Test | FNLV | Norovirus, EIA (Stool) | Norovirus Antigen | Enzyme Immunoassay (EIA) | Stool Container: Stool |  |  | 2 | g | Collect 2 grams of stool, unpreserved, in sterile container. Send specimen frozen. | 1 gram | Specimens other than	Feces Anticoagulants other than	NA Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icteric	NA | Norovirus Antigen: Negative   A Positive result indicates the presence of                                Norovirus antigen, but does not differentiate                              genotype 1 and 2. Other potential gastrointestinal                         pathogens may still be present. A Negative result                          does not fully exclude the presence of Norovirus                           or infection. Results should always be interpreted                         in combination with the full clinical picture.     Test Performed By:  Focus Diagnostics, Inc.                                         5785 Corporate Ave.                                         Cypress, CA  90630-4750 | Monday, Wednesday, Friday | 1-4 days | 3 - 9 days | 1 | 87449 |  |  |  |  | Focus Diagnositics, Inc.
FNLV | [NAME] | FECAL | Fecal |  |  |  | Frozen
FNLV | Result | Z0526 | Norovirus Antigen | Norovirus Antigen | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 95341d1294939249-inerting-rows-in-formatted-table-in-excel-2007-sample-problem
Sheet: Sheet1

date | time | location | rating
a | 1 | g | 7
b | 2 | h | 8
c | 3 | i | 9
d | 4 | j | 10
e | 5 | k | 11
f | 6 | l | 12
Spreadsheet: cb502046-c3d7-40e1-8fa6-a91f904cc752
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42852653 | 2014-08-24 00:02:36 | ALLIES | 0 | 1 | 6 | 1422784 | flarchi | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
42852840 | 2014-08-24 00:14:45 | AXIS | 1 | 6 | 1 | 1422784 | flarchi | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
Spreadsheet: 2fa50e78-324d-4e47-990a-aa14a9267c45
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
12/08/2013 | Gymnastics | Gold-Blue Intrasquad | 3 p.m.
01/10/2014 | Gymnastics | at Kentucky with Penn State and Ball State | 7 p.m.
01/17/2014 | Gymnastics | at Maryland | 7 p.m.
01/26/2014 | Gymnastics | NC State | 3 p.m.
02/02/2014 | Gymnastics | [NAME] and Towson | 3 p.m.
02/07/2014 | Gymnastics | at Iowa State* | 7:30 p.m.
02/14/2014 | Gymnastics | Pitt (Beauty and the Beast) | 6 p.m.
02/21/2014 | Gymnastics | vs. Oklahoma*, Alabama, Michigan (Oklahoma City, Okla.) | 8 p.m.
03/02/2014 | Gymnastics | Ohio State | 3 p.m.
03/07/2014 | Gymnastics | at Florida | 7 p.m.
03/16/2014 | Gymnastics | at Maryland | 2 p.m.
[NAME] | Gymnastics | Big 12 Championship (Morgantown, W.Va.) | 4 p.m.
04/05/2014 | Gymnastics | NCAA Regional Championships | TBA
04/18/2014 | Gymnastics | NCAA National Championships (Birmingham, Ala.) | TBA
Spreadsheet: 715848d1611881589-sum-multiple-categories-in-the-same-formula-for-each-month-forum-excel-28-jan-2021
Sheet: Épargnes Inv.

 |  |  | Compte |  | Profit /perte | Solde fermeture
 | Solde des comptes (relevé le + récent, solde de fermeture): |  |  | Chèque
 |  |  |  | FTQ (REER)
 |  | + |  | Placement québec (CÉLI)
Profit/perte sur période de 12 mois (selon l'année financière): |  |  |  | Argent métal
 |  |  |  | Urgence
Date | Description | Compte | Solde relevé
2020-01-31 00:00:00 | Solde de fermeture
2020-02-29 00:00:00 | Solde de fermeture
2020-03-31 00:00:00 | Solde de fermeture
2020-04-30 00:00:00 | Solde de fermeture
2020-05-31 00:00:00 | Solde de fermeture
2020-06-30 00:00:00 | Solde de fermeture
2020-07-31 00:00:00 | Solde de fermeture
2020-08-31 00:00:00 | Solde de fermeture
2020-09-30 00:00:00 | Solde de fermeture
2020-10-31 00:00:00 | Solde de fermeture
2020-11-30 00:00:00 | Solde de fermeture
2020-12-31 00:00:00 | Solde de fermeture
Date | Description | Compte | Solde relevé | Montant | Profit /perte | Solde fermeture
2020-01-10 00:00:00 | Deposit | AR |  | 200
2020-01-21 00:00:00 | Deposit | AR |  | 200
2020-01-30 00:00:00 | Deposit | AR |  | 200
2020-03-01 00:00:00 | Deposit | FT |  | 300
2020-03-01 00:00:00 | Deposit | AR |  | 25
2020-03-05 00:00:00 | Withdrawal | AR |  | -30
2020-03-11 00:00:00 | Withdrawal | FT |  | -45
2020-03-13 00:00:00 | Withdrawal | AR |  | 20
2020-03-01 00:00:00 | Deposit | PL |  | 60
2020-03-01 00:00:00 | Deposit | UR |  | 80
2020-05-01 00:00:00 | Annual report (balance now at 230$) | AR | 230
2020-05-01 00:00:00 | Annual report (balance now at 280$) | PL | 320
2020-05-01 00:00:00 | Annual report (balance now at 55$) | PL | 55
2020-05-01 00:00:00 | Annual report (balance now at 77$) | UR | 77
Spreadsheet: 765601d1643402211-double-lookup-lookup-example
Sheet: Sheet1

Worksheet 1:  Daily Stock Values in a Given Month |  |  |  |  |  | Worksheet 2:  What is the Current Value of Each Stock
 |  |  |  |  |  |  | 2022-01-15 00:00:00
Ticker | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 |  |  | CURRENT
AES | 24.38 | 24.45 | 23.33 | 23.24 |  | AES
BAGIX | 11.28 | 11.27 | 11.24 | 11.23 |  | BAGIX
DODIX | 14 | 14 | 13.96 | 13.94 |  | DODIX
EIX | 67.51 | 66.67 | 65.2 | 64.62 |  | EIX
Spreadsheet: 877128d1723800991-spill-formula-for-doing-sum-at-sheet-1-from-sheet2-only-the-unique-values-rajsoft-second-test-365-aligw
Sheet: Sheet1

 |  |  | Result required : [NAME] unique Values of Col.C at D based on Sheet2
 |  | Match | Sum
 | Cat | 56346
 | Rabbit | 6364 | 41
 | Owl | 4263 | 75
duplicate> | Parrot | 56346
 | Nightangle | 45267 | 12.5
duplicate> | D Rabit | 6364
Spreadsheet: 182114d1348275019-how-to-manage-inventory-for-large-quantities-of-items-with-several-customers-suppliers-new-inventory-template
Sheet: Purchases

 |  |  |  |  | PD
 |  |  |  |  | 2.66/2M
 |  |  |  |  | 2.8/2M
 |  |  |  |  | 3.0/2M
 |  |  |  |  | 3.2/2M
 |  |  |  |  | 2.8/4M
 |  |  |  |  | 3.0/4M
 |  |  |  |  | 3.2/4M
 |  |  |  |  | 3.4/4M
Purchased From: | Pentium 4  1M | Quantity: | Pentium 4  2M |  | 3.6/4M
Manoj | 2.66/1M
 |  |  |  |  | P4
 |  |  |  |  | 2.66/1M
 |  |  |  |  | 2.8/1M
 |  |  |  |  | 2.93/1M
 |  |  |  |  | 3.0/1M
 |  |  |  |  | 3.06/1M
 |  |  |  |  | 3.2/1M
 |  |  |  |  | 3.4/1M
 |  |  |  |  | 3.6/1M
 |  |  |  |  | 3.8/1M
 |  |  |  |  | 2.66/2M
 |  |  |  |  | 2.8/2M
 |  |  |  |  | 2.93/2M
 |  |  |  |  | 3.0/2M
 |  |  |  |  | 3.06/2M
 |  |  |  |  | 3.2/2M
 |  |  |  |  | 3.4/2M
 |  |  |  |  | 3.6/2M
 |  |  |  |  | 3.8/2M
 |  |  |  |  | DC
 |  |  |  |  | E2140 1.6
 |  |  |  |  | E2160 1.8
 |  |  |  |  | E2180 2.0
 |  |  |  |  | E2200 2.2
 |  |  |  |  | E2210 2.2
 |  |  |  |  | E2220 2.4
 |  |  |  |  | E5200 2.5
 |  |  |  |  | [NAME]
 |  |  |  |  | E5400 2.7
 |  |  |  |  | E5500 2.8
 |  |  |  |  | E5700 3.0
 |  |  |  |  | E5800 3.2
 |  |  |  |  | C2D
 |  |  |  |  | E4300 1.8
 |  |  |  |  | E4400 2.0
 |  |  |  |  | E4500 2.2
 |  |  |  |  | E4600 2.4
 |  |  |  |  | E4700 2.6
 |  |  |  |  | E6300 1.87
 |  |  |  |  | E6320 1.87
 |  |  |  |  | E6400 2.13
 |  |  |  |  | E6420 2.13
 |  |  |  |  | E6540 2.33
 |  |  |  |  | E6550 2.33
 |  |  |  |  | E6600 2.4
 |  |  |  |  | E6700 2.67
 |  |  |  |  | E6750 2.67
 |  |  |  |  | E6850 3.0
 |  |  |  |  | E7200 2.53
 |  |  |  |  | E7300 2.67
 |  |  |  |  | E7400 2.8
 |  |  |  |  | E7500 2.93
 |  |  |  |  | E7600 3.07
 |  |  |  |  | E8190 2.67
 |  |  |  |  | E8200 2.67
 |  |  |  |  | E8300 2.83
 |  |  |  |  | E8400 3.0
 |  |  |  |  | E8500 3.17
 |  |  |  |  | [NAME] 3.33
 |  |  |  |  | E8700 3.5
Spreadsheet: 841364d1693552207-match-date-on-two-different-pages-and-paste-data-in-columns-copy-of-copy-of-ef-file-
Sheet: 2-9 Day

 | CR1 | Priority | Headcount
1 | Alinity RV | 17 | 0.25
2 | Alinity RV | 16 | 0.25
3 | Alinity RV | 15 | 0.25
4 | Alinity RV | 14 | 0.25
5 | Alinity RV | 3 | 0.25
12 | [NAME] | 21 | 0.25
13 | [NAME] | 20 | 0.25
9 | Architect RV | 13 | 0.25
15 | Lid tray | 18 | 0.5
16 | Architect RV | 12 | 0.25
17 | Alinity RV | 11 | 0.25
50 | Baxter SIV Assy | 22 | 3
31 | Architect RV | 10 | 0.25
8 | Alinity RV | 9 | 0.25
10 | Architect RV | 8 | 0.25
11 | [NAME]
18 | Architect RV | 7 | 0.25
19 | Architect RV | 6 | 0.25
20 | Base Trays | 19 | 0.5 |  |  |  |  |  | day | night
21 | Architect RV | 5 | 0.25 |  |  |  |  |  |  | 17
22 | Architect RV | 4 | 0.25 |  |  |  |  | Tuesday | 22 | 18
23 | Architect RV | 23 | 0.25 | DOWN |  |  |  | Wend | 19 | 12
30 | Architect RV | 2 | 0.25 |  |  |  |  | thu | 18
7 | Architect SC | 1 | 0.25 |  |  |  |  | FRI
Total
 | CR2 | Priority
71 | PP4 ES |  |  | PQR
72 | 8ul ES |  |  | PQR
73 | PP1 | 4 | 0.25
74 | Side Cassette A | 3 | 0.25
77 | Luminex 6 UL | 2 | 0.25
78 | Side Cassette B PQ | 1 | 1 | ES
79 | Roche Plunger ES
87 | [NAME] | 5 | 0.25
52 | Architect RV | 8 | 0.25 | DOWN
53 | Architect RV | 7 | 0.25
54 | Siemens KS860
59 | Architect RV | 9 | 0.25
61 | [NAME] | 13 | 0.5
66 | [NAME] | 12 | 0.5
83 | Ceph OM#1
84 | Ceph MB#1
86 | [NAME] | 11 | 0.25
62 | NP227 | 14 | 0.25
63 | NP Birdcage
64 | Siemens 1ML
67 | [NAME]
69
88 | [NAME] | 6 | 0.25
89 | Top Frame B ES
106 | [NAME]
107
108 | [NAME]
109 | Baxter 4 Cavity Neck Spares ES
Total
Spreadsheet: 793966d1661821979-nested-if-and-and-or-functions-help
Sheet: Sheet1

The operator must count two slides four times. The operator will document the number of red things and the number of blue things in each quadrant per slide. The assessment needs to be as follows: the minimum count is 20 and the maximum count is 125 for each quadrant of the sum of red and blue. For the assessment to pass, the sum of red and blue in each quadrant must be between 20 and 125. If it is, the result will state "Proceed to next assessment." If the counts are too low of the sum of red and blue for any one quadrant, the result will state "Reduce the quantity and resuspend." If the counts are too high for any one quadrant of the sum of red and blue, the result will state "Dilute the sample."
 | Slide 1 |  | Slide 2
 | Red | Blue | Red Blue
[NAME] | 19 | 1 | 19 | 1
[NAME] | 19 | 1 | 19 | 1
[NAME] | 19 | 1 | 19 | 1
[NAME] | 19 | 1 | 19 | 1
Assessment
Spreadsheet: 68677d1269270942-comparing-languages-compare-languages
Sheet: Countries

iso2 | country | langoff_1 | langoff_2 | langoff_3
AL | Albania | Albanian
AD | Andorra | Catalan | Spanish
AT | Austria | German
BE | Belgium | Dutch | French | German
BG | Bulgaria | Bulgarian
BA | Bosnia and Herzegovina | Serbo-Croatian
BY | Belarus | Belarussian
CH | Switzerland | German | French | Italian
CY | Cyprus | Greek | Turkish
CZ | Czech Republic | Czech
DE | Germany | German
DK | Denmark | Danish
ES | Spain | Spanish
EE | Estonia | Estonian
FI | Finland | Swedish
FR | France | French
GB | United Kingdom | English
GR | Greece | Greek
HR | Croatia | Serbo-Croatian
[NAME] | Hungary | Hungarian
IE | Ireland | English
IS | Iceland | Icelandic
IT | Italy | Italian
LT | Lithuania | Lithuanian
LU | Luxembourg | French | German | Luxembourgish
LV | Latvia | Latvian
MD | Moldova, Rep.of | Romanian
MK | Macedonia (the former Yugoslav Rep. of) | Macedonian
MT | Malta | English
NL | Netherlands | Dutch
NO | Norway | Norwegian
PL | Poland | Polish
PT | Portugal | Portuguese
RO | Romania | Romanian
SM | [NAME] | Italian
SK | Slovakia | Slovak
SI | Slovenia | Slovenian
SE | Sweden | Swedish
TR | Turkey | Turkish
UA | Ukraine | Ukrainian
YU | Serbia and Montenegro | Serbo-Croatian
Spreadsheet: 794422d1662041620-how-to-update-a-list-tab-based-on-an-evolving-data-tab-test-v4
Sheet: Data

Centre | Area | Team | PARENT2 | CRS_CODE | TOTAL_PLACES | ActiveEnrol | CRS_TITLE | STATUS | MAIN_COURSE2 | MOA | UnitCategory | awarding_body | LearningAim | NVQLevel | FL2 | FL3 | FL3_Adult | OccurrenceCode | S_DATE | E_DATE | QualStart | QualEnd | SITE | NoOfGroups | HoursPerWeek | WeeksPerYear | GLH | FE_Fees | HE_Fees | Appr_Fees | Adv_Fees1 | Textbox26 | FC_Fees | FC2_Fees | EXAMS_FEES | MATERIAL_FEES | OS_FE_Fees | OS_HE_Fees | OS_Appr_Fees | OS_FC_Fees | OS_FC2_Fees | OS_Exams_Fees | OS_Material_Fees
Centre 01 | Area 01 | Team 01 | 001 | 001 |  |  | Title 01 | ACTIVE | Q1 |  | F1 | AO1 | X1 | 1
Centre 01 | Area 01 | Team 01 | 001 | 002 |  |  | Title 02 | ACTIVE | Q1 |  | F1 | AO2 | X2
Centre 01 | Area 01 | Team 01 | 001 | 003 |  |  | Title 03 | ACTIVE | Q1 |  | F1 | AO3 | X3 | X
Centre 01 | Area 01 | Team 01 | 001 | 004 |  |  | Title 04 | ACTIVE | Q1 |  | F1 | AO4 | X4 | E
Centre 01 | Area 01 | Team 01 | 001 | 005 |  |  | Title 05 | ACTIVE | Q1 |  | F1 | AO5 | X5 | E
Centre 01 | Area 01 | Team 01 | 001 | 006 |  |  | Title 06 | ACTIVE | Q1 |  | F1 | AO6 | X6 | E
Centre 01 | Area 01 | Team 01 | 001 | 007 |  |  | Title 07 | ACTIVE | Q1 |  | F1 | AO7 | X7 | 1
Centre 01 | Area 01 | Team 01 | 001 | 008 |  |  | Title 08 | ACTIVE | Q1 |  | F1 | AO8 | X8 | 2
Centre 01 | Area 01 | Team 01 | 001 | 009 |  |  | Title 09 | ACTIVE | Q1 |  | F1 | AO9 | X9 | E
Spreadsheet: 101608d1299697876-excel-2007-formula-to-organize-data-example2
Sheet: DEF

DEF Co.
sequence | item | cost | profit
1 | pear | 2 | 2
2 | orange | 3 | 3
3 | apple | 0 | 0
4 | banana | 0 | 0
5 | blueberry | 0 | 0
6 | [NAME] | 5 | 3
Spreadsheet: 91575d1291282795-calculating-the-exact-value-pb-test
Sheet: PB

 | PAY BACK PERIOD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US$ in Millions
 | Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | Profit After Tax | -30.89 | 4.315387465038719 | 5.242105463852408 | 6.231463724096855 | 7.339424683545127 | 8.203502420928043 | 8.378537282572541 | 8.553572144217041 | 8.72860700586154 | 8.903641867506042 | 9.07867672915054 | 9.209952875383918 | 9.209952875383918 | 9.209952875383918 | 9.209952875383918 | 9.209952875383918
 | Depreciation | 0 | 1.505066666666667 | 1.505066666666667 | 1.505066666666667 | 1.505066666666667 | 1.505066666666667 | 1.505066666666667 | 1.505066666666667 | 1.505066666666667 | 1.505066666666667 | 1.505066666666667 | 1.505066666666667 | 1.505066666666667 | 1.505066666666667 | 1.505066666666667 | 1.505066666666667
 | Total | -30.89 | 5.820454131705386 | 6.747172130519075 | 7.736530390763522 | 8.844491350211793 | 9.708569087594709 | 9.883603949239207 | 10.05863881088371 | 10.23367367252821 | 10.40870853417271 | 10.58374339581721 | 10.71501954205058 | 10.71501954205058 | 10.71501954205058 | 10.71501954205058 | 10.71501954205058
 | Cummulated Total | -30.89 | 5.820454131705386 | 12.56762626222446 | 20.30415665298798 | 29.14864800319978 | 38.85721709079449 | 48.74082104003369 | 58.7994598509174 | 69.03313352344561 | 79.44184205761832 | 90.02558545343553 | 100.7406049954861 | 111.4556245375367 | 122.1706440795873 | 132.8856636216379 | 143.6006831636884
 | Regular Payback Period | N/A | N/A | N/A | N/A | N/A | 4.179362373701935
 | Capital Investment | 30.89
 | Payback Period | 4.179362373701935 | Years
 | Notes
 | Values in Rows C6:R6 are linked from other book and change with any Change in C11 (Capital Investment)
 | The [NAME] in C10:H10 calculates the desired result by calculating the payback period in the above table in 5th Year i.e. 4.18
 | Requirement
 | However if the formulae in C10:H10 is extended to C10:R10 it altogether gives misleading results.
 | I need a modification in this formula C10:R10 in a way that it only shows the the value of the corrected year