tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 825417d1681309523-count-based-on-cell-value-count2-sample-ans
Sheet: Sheet1

STUFF | NAME A | [NAME] | NAME B | CRAP | NAME C | TRASH | PT
FFF | BILL | HH |  | GGG |  | WWW | X
GGG | HARRY | HH | [NAME] |  |  | WWW
 | JOE | HH | JILL | GGG |  | WWW | X
YY | GOLDIE | HH |  |  | KURT | WWW
 | [NAME] | HH | YOKO | GGG |  | WWW
VVV | HUMPHREY | HH |  |  | LAUREN | WWW | X
 | COUNT = 5
Spreadsheet: darrell_schoolcraft__7585__imball0112
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 101751 | 98243
2 | 102927 | 104706
3 | 117477 | 116286
4 | 119833 | 117531
5 | 123072 | 121673
6 | 115143 | 114331
7 | 104853 | 105766
8 | 104302 | 102762
9 | 103913 | 102521
10 | 101722 | 101279
11 | 108378 | 104512
12 | 83509 | 109973
13 | 77877 | 101045
14 | 131278 | 141469
15 | 97603 | 96224
16 | 91854 | 96224
17 | 106236 | 103991
18 | 100249 | 98417
19 | 98119 | 96237
20 | 126430 | 125497
21 | 98320 | 96237
22 | 128666 | 127851
23 | 129018 | 126608
24 | 141956 | 135259
25 | 136288 | 133973
26 | 134730 | 132198
27 | 102542 | 100321
28 | 131265 | 130675
29 | 121742 | 119182
30
31
2001-11-30 00:00:00 |  |  | -47216
2001-12-29 00:00:00
CBS Dollars
 |  |  | 234488.68 |  |  |  | 12
 |  |  |  |  |  |  | 500
 |  |  |  |  |  |  | 5895
Spreadsheet: 0b0381e5-5f11-4cfe-8169-2f980fdf02c7
Sheet: Sheet1

Jurisdiction/Grantee Name:  City of Lansing | Unnamed: 1 | CDBG-R Fomula Grant Amount: $587,391 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Date: | Unnamed: 7
Activity Name | Activity Description | Eligibility (Regulatory or HCDA Citation) | National Objective Citation | CDBG-R Project Budget ($) | Additional Recovery Funds ($) | Other Leveraged Funding ($) | Total Activity Budget
Administration | CDBG-R allowance for planning and administrative costs | 24 CFR 570.205 24CFR  570.206 | NA (IDIS Activities 20,21A, 21B, 21C,21D, 21E, 21H) | 58739 |  |  | 58739
Public Services | Housing counseling, youth and senior programs, neighborhood clean-ups, community policing, tool lending programs, neighborhood counseling | 24 CFR 570.201(e) | LMA 05 Public Service | 88109 |  |  | 88109
Boys and Girls Club site work | Install new driveway | 24 CFR 570.201(c) | LMA 03 Public Facilities Improvement | 30000 |  |  | 30000
Code Enforcement | Code enforcement on commercial and vacant buildings in CDBG eligibile areas | 24 CFR 570.202(c) | LMA 15 Code Enforcement | 90000 |  |  | 90000
LED Traffic Lighting | Install LED lights at intersections | 24 CFR 570.201(c) | LMA 03K Street Improvements | 200000 |  |  | 200000
BCFI Energy Retrofit | Weatherization and component replacement to reduce energy consumption | 24 CFR 570.201(c) | LMA 03 Public Facilities Improvement | 120543 |  |  | 120543
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
Spreadsheet: 727833d1618141890-import-data-in-a-cell-to-another-workbook-automatic-update-by-date-asq-meal-plan-daily-revenue-042021
Sheet: SBS

Date |  | Room  Available for ASQ |  | Breakfast | Lunch | Dinner | Cost
 |  |  | RM Occupied | Actual Guest (Pax) | Actual Guest (Pax) | Actual Guest (Pax) | Food Cost 450 Breakfast (150) [NAME] (150) Dinner (150) | Estimate Breakfast Cost | Estimate  Lunch  Cost | Estimate Dinner  Cost | REMARK
Total
Spreadsheet: 165445d1341235839-conditional-formattings-on-a-lot-of-spreadsheets-0acftest-4-
Sheet: Sheet2

1 |  |  | When I press say one the color must be red, if 2 color must be blue eg.
1
2
1
2
1
 |  |  | When Value in column A is 1>>red, if=2>>blue…
Spreadsheet: 106112d1303326949-counting-months-in-range-function-months-calculation-example
Sheet: Sheet1

 |  | Months in Year Ending…
Period Start | Period End | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00
2010-01-01 00:00:00 | 2011-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 3
2010-03-31 00:00:00 | 2010-06-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0
2010-03-30 00:00:00 | 2010-05-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 1.033333 | 0
Spreadsheet: 839743d1692192651-automate-spreadsheet-to-work-out-who-owes-who-or-a-macro-that-can-do-it-splitting-bills-
Sheet: Per App

 |  | COST | 1.16 |  | All £ sterling
Paid by |  | € actual | £ equiv |  | R | SI | D | B | ST | C | N | P | M
ST |  | 525
R |  | 104.8
C |  | 435
P |  | 600
D |  | 139
M |  | 220
P |  | 711
P |  | 22.74
SI |  | 624
C |  | 49.71
ST |  | 43
B |  | 99
P |  | 31.5
D |  | 46.3
N |  | 640
D |  | 57.8
ST |  | 43
ST |  | 76.3
ST |  | 58.8
D |  | 633.5
SI |  | 70.8
ST |  | 70.2
ST |  | 22.5
C |  | 51.08
Total Cost
Total paid
Surplus/Deficit
Cost |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 252
Winnings (credit back) |  |  |  |  | -49 | -52.5 | -28 | -31.5 | -59.5 | -10.5 | -3.5 | -17.5
Total (Due) / Owed
Spreadsheet: 893b1f0c-1137-4f1d-a986-3c3f4f591706
Sheet: Sheet1

Table S1. Primers used for real time RT-PCR analysis. | Unnamed: 1 | Unnamed: 2
Transcript | Primer Name | Sequence
16S | 16S-1088-Fw | 5′- TGAGATGTTGGGTTAAGTCCCGCA-3′
 | 16S-1275-Rv | 5′-CGGTTTCGCTGCCCTTTGTATTGT-3′
ssl7 | ssl7-12-Fw | 5′-AACGTTAGCTAAAGCAACATTGGC-3′
 | ssl7-91-Rv | 5′-TTGCTTGAACTGCTTGGCCTTCTG-3′
ssl1 | ssl1-500-Fw | 5′-GAACGTGCGATTAAACAACACGGC-3′
 | ssl1-643-Rv | 5′-CGTCGATTGACTCACCCATACGTT-3′
[NAME] | ssl2-385-Fw | 5′-GCTGTCGACCTAATAGCAGAAGCA-3′
 | ssl2-560-Rv | 5′-CCTGTACTCATTTCACCGTAAAGACC-3′
lukS | lukS-851-Fw | 5′-TTCCCAATATCATCCGGTGCTG-3′
 | [NAME] | 5′-GTTATCAGCAGCAACGACTCAAGC-3′
hlgA | [NAME] | 5′-AATCGGAGGCAGTGGCTCATTCAA-3′
 | [NAME] | 5′-GGACCAGTTGGGTCTTGTGCAAAT-3′
hlgC | [NAME] | 5′-TCGGTGGTAATTTCCAATCAGCCC-3′
 | hlgC-583-Rev | 5′-CGAATGAATTCGCTTTGACGCCC-3′
Spreadsheet: 166263d1341510780-getting-a-cell-to-populate-when-it-sees-a-name-airframe-engine-log-sample-modified-by-tigeravatar-v2
Sheet: Graham

Today is:
 | Date | Hourly | Cost Calculator
 |  |  |  |  | RUNNING TOTAL |  | (- expenses)
 |  |  |  |  |  | Expenses
 |  |  |  |  |  | Date | Cost | Description
 |  |  |  |  |  | 2012-07-04 00:00:00 | 3.75 | Tootbrush
 |  |  |  |  |  | Total
 |  |  | Total
Spreadsheet: 793265d1661369419-value-error-financial-report-2
Sheet: Financial Report

FY23 CWSP Formula Grant Report |  |  |  |  |  |  |  | AWARD INFO |  | STATE REMAINING GRANT $ |  | EXPEDITURES
Quarter ending: [date] |  |  |  |  |  |  |  | Total Award Amount: | 1000000 | Amount Available at Grant Start |  | Total Disbursed
[CWSP Name] |  |  |  |  |  |  |  | Administrative Costs (AC): 15% | 150000 | Total Requested |  | Total Spent
[Grant ID] |  |  |  |  |  |  |  | Project Completion Costs (PCC): 85% | 850000 | Total Remaining |  | Remaining Cash on Hand
 | .
 |  | Ex: Draw only | Ex: Draw+ Adv | Ex: Draw+ Reimb
 |  | Quarter 1 | Quarter2 | Quarter 3 | Quarter 4 | Quarter 5 | Quarter 6 | Quarter 7 | Quarter 8 | Cumulative Totals | % Remaining
Administrative Costs (AC) | Total Expenditures this Quarter- AC | 20000 | 30000 | 37500 | 37500 | 0 | 0 | 0 | 0 |  |  | admin pacing
 | Quarter to Date Cash Reimbursements- AC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | New Advance Request | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Cash Balance at Quarter Start- AC |  |  |  |  |  |  |  |  |  |  | HIDE | 0
 | Quarter End Remaining Cash Balance- AC |  |  |  |  |  |  |  |  |  |  | HIDE
 | Cumulative expenses |  |  |  |  |  |  |  |  |  |  | HIDE
 | Available State AC |  |  |  |  |  |  |  |  |  |  | HIDE
 | Quarter End Draw Request
 | Total Amount AC Currently Requested
Project Completion Costs (PCC) | Total Expenditures this Quarter- PCC | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | pcc pacing
 | Quarter to Date Cash Reimbursements- PCC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | New Advance Request | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Cash Balance at Quarter Start- PCC |  |  |  |  |  |  |  |  |  |  | HIDE
 | Quarter End Remaining Cash Balance- PCC |  |  |  |  |  |  |  |  |  |  | HIDE
 | Quarter End Draw Request
 | Total PCC Currently Requested
 | Total Draw Requested
 | Total Advance Requested
 | Quarter Total Requested |  |  |  |  |  |  |  |  |  |  | remaining state funds
 | PCC Non- Match Eligible | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PCC- Match Eligible
 | Interest Earned | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | goes the other way- talks to TPM tab
Spreadsheet: 880127d1727754164-iterate-through-a-column-recursively-olva-wraparound-list
Sheet: Wraparound

All Names |  |  |  |  | Selected Names
Paulo |  | Number of names | 5 |  |  | Extend formula down for as many rows as the [NAME] number of names you could need
[NAME] |  | Starting row | 8
[NAME] |  |  |  |  |  | V
Celine
Julia
[NAME]
[NAME]
[NAME]
Merly
Spreadsheet: 59989d1260516987-excel-2007-finding-and-copying-cells-findingcopying
Sheet: Sheet1

A6 | A1 | A2 | A3 | A4 | A5
 | 1 | 10 | 20 | 30 | 40
 | 2 | 10 | 20 | 30 | 40
 | 3 | 10 | 20 | 30 | 40
 | 1 | 11 | 19 | 30 | 40
 |  | A1 | A2 | A3 | A4 | A5
 | 102
Spreadsheet: 77320d1277818489-excel-2007-lookup-data-using-drop-down-menus-lookups-using-drop-downs
Sheet: Forecast

 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00
Income | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000
Exp | 16000 | 16000 | 16000 | 16000 | 16000 | 16000 | 16000 | 16000 | 16000 | 16000 | 16000 | 16000
Profit
Spreadsheet: 2a7c8b2a-d55e-4b63-aec1-2dce68776de4
Sheet: Samples Table

The Samples table
Documentation also available at: http://gemini.readthedocs.org/en/latest/content/database_schema.html#the-samples-table
COLUMN NAME | COLUMN TYPE | [NAME]
sample_id | INTEGER | PRIMARY_KEY
name | STRING | Sample names
family_id | INTEGER | Family ids for the samples [User defined, default: NULL]
[NAME] | INTEGER | Paternal id for the samples [User defined, default: NULL]
maternal_id | INTEGER | Maternal id for the samples [User defined, default: NULL]
sex | STRING | Sex of the sample [User defined, default: NULL]
phenotype | STRING | The associated sample phenotype [User defined, default: NULL]
ethnicity | STRING | The ethnic group to which the sample belongs [User defined, default: NULL]
Spreadsheet: 07296c68-386c-439e-ae6d-c17a93d8cce3
Sheet: 40

THE ALLSTATE CORPORATION
CHANGE IN CONTRACTHOLDER FUNDS
($ in millions)
 |  |  | Three months ended |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Twelve months ended
 |  |  |  | Dec. 31, |  |  | Sept. 30, |  |  | June 30, |  |  | March 31, |  |  | Dec. 31, |  |  | Sept. 30, |  |  | June 30, |  |  | March 31, |  |  | Dec. 31, |  |  | Dec. 31,
 |  |  |  | 2012 |  |  | 2012 |  |  | 2012 |  |  | 2012 |  |  | 2011 |  |  | 2011 |  |  | 2011 |  |  | 2011 |  |  | 2012 |  |  | 2011
Beginning balance |  |  | $ | 40110 |  | $ | 40832 |  | $ | 41603 |  | $ | 42332 |  | $ | 43776 |  | $ | 45078 |  | $ | 46834 |  | $ | 48195 |  | $ | 42332 |  | $ | 48195
 | Deposits
 | Fixed annuities |  |  | 318 |  |  | 272 |  |  | 185 |  |  | 153 |  |  | 228 |  |  | 133 |  |  | 142 |  |  | 164 |  |  | 928 |  |  | 667
 | Interest-sensitive life insurance |  |  | 357 |  |  | 323 |  |  | 335 |  |  | 332 |  |  | 325 |  |  | 320 |  |  | 316 |  |  | 330 |  |  | 1347 |  |  | 1291
 | Bank deposits |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 18 |  |  | 33 |  |  | 97 |  |  | 212 |  |  | 0 |  |  | 360
 |  | Total deposits |  | 675 |  |  | 595 |  |  | 520 |  |  | 485 |  |  | 571 |  |  | 486 |  |  | 555 |  |  | 706 |  |  | 2275 |  |  | 2318
 | Interest credited |  |  | 362 |  |  | 213 |  |  | 369 |  |  | 379 |  |  | 406 |  |  | 400 |  |  | 413 |  |  | 410 |  |  | 1323 |  |  | 1629
 | Maturities, benefits, withdrawals
 |  | and other adjustments
 | Benefits |  |  | -434 |  |  | -341 |  |  | -331 |  |  | -357 |  |  | -326 |  |  | -396 |  |  | -367 |  |  | -372 |  |  | -1463 |  |  | -1461
 | Surrenders and partial withdrawals |  |  | -1157 |  |  | -941 |  |  | -949 |  |  | -943 |  |  | -1052 |  |  | -1351 |  |  | -1513 |  |  | -1019 |  |  | -3990 |  |  | -4935
 | Bank withdrawals |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | -817 |  |  | -162 |  |  | -210 |  |  | -274 |  |  | 0 |  |  | -1463
 | Maturities of and interest payments on institutional
 | products |  |  | -48 |  |  | -1 |  |  | -88 |  |  | -1 |  |  | -48 |  |  | -26 |  |  | -306 |  |  | -487 |  |  | -138 |  |  | -867
 | Contract charges |  |  | -272 |  |  | -264 |  |  | -266 |  |  | -264 |  |  | -265 |  |  | -257 |  |  | -255 |  |  | -251 |  |  | -1066 |  |  | -1028
 | Net transfers from separate accounts |  |  | 4 |  |  | 3 |  |  | 2 |  |  | 2 |  |  | 3 |  |  | 3 |  |  | 3 |  |  | 3 |  |  | 11 |  |  | 12
 | Fair value hedge adjustments for institutional products |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | -34 |  |  | 0 |  |  | -34
 | Other adjustments |  |  | 79 |  |  | 14 |  |  | -28 |  |  | -30 |  |  | 84 |  |  | 1 |  |  | -76 |  |  | -43 |  |  | 35 |  |  | -34
 |  | Total maturities, benefits, withdrawals
 |  | and other adjustments |  | -1828 |  |  | -1530 |  |  | -1660 |  |  | -1593 |  |  | -2421 |  |  | -2188 |  |  | -2724 |  |  | -2477 |  |  | -6611 |  |  | -9810
Ending balance |  |  | $ | 39319 |  | $ | 40110 |  | $ | 40832 |  | $ | 41603 |  | $ | 42332 |  | $ | 43776 |  | $ | 45078 |  | $ | 46834 |  | $ | 39319 |  | $ | 42332
Spreadsheet: 811494d1672584430-find-a-particular-text-within-a-cell-book1-hd
Sheet: Sheet1

Description | Tag | HD |  | Key | If the word/string below exists, tag it against  the key
[NAME] cat idshofsih | Animal |  |  | Animal | cat, snake, dog, parrot
dog - @hgios | Animal | Animal | Animal | Building | burj, burj khalifa, Khalifa, Opera, House, Opera House
hsodfhs -snake 1231 | Animal | Animal | Animal | Human | [NAME], Rory
oihdsd Burj Khalifa 556 | Building | Building | Building
Opera House 889 | Building | Building | Building
[NAME] | Human | Human | Human
9302 @- ADAM 0jdj | Human | Human | Human
Parrot 9393 | Animal | Animal | Animal
Spreadsheet: 01171ccc-6b9f-472a-9db0-423c0a255c6d
Sheet: Sheet1

Insitution / Organisation | Zielland | [NAME]
 | CHILE | 3
Universidad de Chile |  | 3
 | CHINA | 2
Tongji University Shanghai |  | 2
 | DÄNEMARK | 2
Aarhus Universitet |  | 2
 | [NAME] | 5
Universität Oulu |  | 3
University of Eastern Finland |  | 2
 | FRANKREICH | 14
Ecole de Commerce, Toulouse |  | 2
ENSAM Paris |  | 2
ENSIETA Brest |  | 2
Université Paris-Sud |  | 2
Institut supérieure d'electronique de Paris/ Institut Catholique |  | 2
Ecole des Mines de Paris |  | 2
Université [NAME] |  | 2
 | HOLLAND | 2
Technische Universiteit Delft |  | 2
 | INDONESIEN | 2
Universitas Jenderal [NAME] |  | 2
 | ITALIEN | 2
Università di Camerino |  | 2
 | JAPAN | 2
Osaka Institute of Technology |  | 2
 | KANADA | 2
Institut Supérieur d'Electronique, Québec |  | 2
 | LITAUEN | 8
Klaipeda University |  | 2
Technische Universität Vilnius |  | 2
Technische Universität Kaunas |  | 2
Vytautas Magnus Universität Kaunas |  | 2
 | ÖSTERREICH | 4
[NAME] |  | 2
FH Wels |  | 2
 | POLEN | 2
Politechnika Wroclaw |  | 2
 | RUMÄNIEN | 8
Politehnika Bukarest |  | 2
University of Craiova |  | 2
Universitatea "[NAME]" Resita |  | 2
Universitatea tehnica de constructii Bucuresti |  | 2
 | RUSSLAND | 3
Technische Universität St. Petersburg |  | 3
Herzen Universität, St.Petersburg
 | SCHOTTLAND | [NAME]
Napier University, Edinburgh
 | SCHWEIZ | 2
Universität Luzern |  | 2
 | SPANIEN | 14
[NAME] |  | 2
Universidad de Cádiz |  | 2
[NAME] |  | 2
[NAME] |  | 2
Universidad Nacional de Educacion a Distancia |  | 2
Universitat Pompeu Fabra |  | 2
Universidad Autonoma de Madrid |  | 2
 | TSCHECH. REPUBLIK | 2
Univerzita obrany |  | 2
 | TÜRKEI | 4
Koc University |  | 2
Middle East Technical University |  | 2
 | UNGARN | 2
Central European University |  | 2
 | USA | 15
University of Arizona, Tucson |  | 2
Naval Postgraduate School |  | 5
Norwich University, Vermont |  | 6
University of Texas at El Paso |  | 2
Spreadsheet: 861021d1709034680-return-true-if-months-match-date-q-aligw
Sheet: Sheet1

Amt | [NAME] | Mth | Status |  |  |  |  | Reference Data
-37.92 | sdg | 2024-01-01 00:00:00
-50 | zfsfj | 2024-02-20 00:00:00
-46 | yuk | 2024-02-20 00:00:00
-285.36 | fhd | 2024-03-01 00:00:00
-377.38 | f,fi | 2024-05-01 00:00:00 |  |  |  |  |  | 2024-02-20 00:00:00
-59.99 | iukj | 2024-06-01 00:00:00
-80 | [NAME] | 2024-08-01 00:00:00
-200 | wer | 2024-09-01 00:00:00
-160.68 | ytr | 2024-09-01 00:00:00
-40 | zxcv | 2024-09-01 00:00:00
Spreadsheet: 541720d1507525292-conditional-formatting-test-sample
Sheet: Sheet1

 |  | A | B | C | D | Answer
 | Q1 | 5 | 6 | 7 | 8 | C
 | Q2 | 4 | 5 | 6 | 6 | B
 | Q3 | 6 | 3 | 4 | 1 | D
 | Q4 | abc | def | pqr | xyz | A
Spreadsheet: 878516d1725622586-formula-to-compute-net-effective-gains-samplecalculation
Sheet: Sheet1

Assumptions
Win / Loss Ratio | 50:50
Average Gain per Trade | 0.125
Average Loss per Trade | 0.0625
Position Size per Trade | 0.25
No.Of Trades | 124
Exposure per Trade | 0.25
Calculation
Effecive Gain per Trade
Compounded Growth
Spreadsheet: 586404d1534355978-multiple-lookups-matching-norms
Sheet: SUM-PURPLE

LOC.OC.StdScoreSum | LOC.OC.StdScoreSumPercentile | LOC.OC.StdScoreSumQuotient
2 | <1 | 46
3 | <1 | 49
4 | <1 | 52
5 | <1 | 55
6 | <1 | 58
7 | <1 | 61
8 | <1 | 64
9 | 1 | 67
10 | 2 | 70
11 | 3 | 73
12 | 5 | 76
13 | 8 | 79
14 | 12 | 82
15 | 16 | 85
16 | 21 | 88
17 | 27 | 91
18 | 35 | 94
19 | 42 | 97
20 | 50 | 100
21 | 58 | 103
22 | 65 | 106
23 | 73 | 109
24 | 79 | 112
25 | 84 | 115
26 | 89 | 181
27 | 92 | 121
28 | 95 | 124
29 | 97 | 127
30 | 98 | 130
31 | 99 | 133
32 | >99 | 136
33 | >99 | 139
34 | >99 | 142
35 | >99 | 145
36 | >99 | 148
37 | >99 | 151
38 | >99 | 154
39 | >99 | 157
40 | >99 | 160
Spreadsheet: 079453ec-976f-4b5a-8f24-ce3198fa57b6
Sheet: Nursing Calculator

 |  | CollCourse | CollCourse | CollCourse | CollCourse | CollCourse | CollCourse | CollCourse | CollCourse | CollCourse | Regents | Regents
 | Class
 | Credit Hours
 | Grade
 | [NAME]
 | Quality Points
 | Weighted Points
 | Total # of Classes
 | GPA
 | Total Weighted Points
 |  |  |  | College Course Grade |  |  | Credit Hours = 3 |  |  | Credit Hours = 4
 | Course | Credit Hrs |  | Grade | Numeric Points |  | Grade | Weighted Points |  | Grade | Weighted Points
 | CHE 100 | 3 |  | A | 4 |  | A | 10 |  | A | 20
 | BIO 104 | 3 |  | B | 3 |  | B | 8 |  | B | 15
 | ENG 101 | 3 |  | C | 2 |  | C | 5 |  | C | 10
 | ENG 102 | 3 |  | D | 1 |  | D | 2 |  | D | 5
 | BIO105/152 | 4 |  | F | 0 |  | F | 0 |  | F | 0
 | BIO 106/153 | 4
 | BIO 201 | 4
 | SOC 101 | 3
 | PSY 101 | 3
 |  |  |  |  |  |  | Regents Grades
 | *Please make sure you enter both Class and [NAME], or else the GPA will NOT calculate accurately. |  |  |  |  |  | Score | Weighted Points
 |  |  |  |  |  |  | 95 - 100 | 10
 |  |  |  |  |  |  | 90 - 94 | 9
 |  |  |  |  |  |  | 85 - 89 | 7
 |  |  |  |  |  |  | 80 - 84 | 5
 |  |  |  |  |  |  | 75 - 79 | 3
 |  |  |  |  |  |  | 0 -74 | 0
Spreadsheet: 697650d1601466192-filtering-formula-values-in-a-table-samplea-ans
Sheet: Sheet1

Account Type | Premium
 | Total Accounts | Active Accounts | Deferred Accounts | Contract Value | Account Type
Sector1 | 10 | 5 | 5 | 10M | Regular
Sector2 | 32 | 20 | 12 | 25M | Premium
Sector3 | 25 | 18 | 7 | 14M | Premium
Spreadsheet: 791193d1660208508-consolidate-duplicate-rows-into-unique-rows-to-provide-to-excel-forum
Sheet: first formual

Color | Lead name
White | [NAME]
Red | [NAME]
Purple | [NAME]
Pink | [NAME]
Black | Nathan
Yellow | Nathan
 |  |  |  |  |  |  |  |  |  |  |  |  | Drag my formula all across green region
Spreadsheet: mary_fischer__25625__1290
Sheet: E-6.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 1290
ANALYSIS OF PROPERTY, PLANT AND EQUIPMENT
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
 |  | 12-31-2000 Balance |  |  |  |  |  | CHARGED TO I/S
 |  | DR/(CR.) |  |  |  | SALES AND OTHER |  |  |  |  |  |  |  | DETAIL OF |  | ENDING
[NAME] |  | BEGINNING |  | ADDITIONS |  | RETIREMENTS |  | DEPR |  | DEPL |  | OTHER |  | OTHER CHANGES |  | BALANCE
 |  | BALANCE |  | DR/(CR) |  | DR/(CR) |  | 1415 |  | 1416 |  | (List Below-A) |  | (List Below-B) |  | DR/(CR)
Natural Gas Transmission
Electric Generation & Distribution
Construction In Process
O & G Properties
Other |  | 0 |  |  |  |  |  |  |  |  |  | 0
Gross PP & E
Accumulated DD & A |  | -235857 |  |  |  |  |  |  |  |  |  |  |  | 235857
Net PP & E |  |  | * |  | ** |  | ** |  |  |  |  |  |  |  |  |  | *
 |  |  |  |  | ** Pertains to amounts related to normal |  |  |  |  |  |  | (A) |  | (B) | * | [NAME] TO
 |  |  |  |  | operations.  Unusual amounts should be shown |  |  |  |  |  |  |  |  |  |  | HYPERION LINE
 |  |  |  |  | under "Other Changes" with appropriate explanations. |  |  |  |  |  |  |  |  |  |  | NET_TOT_PPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asset/Exp  DR/(CR)
 |  |  |  |  |  |  | DETAIL OF OTHER CHANGES     (B)
 |  |  |  |  |  |  |  |  |  |  |  | PP & E |  | ACCUM |  | NET
CHARGED TO OTHER I/S ACCTS     (A) |  |  |  |  |  |  | KEY: |  |  |  |  | DR/(CR) |  | DR/(CR) |  | DR/(CR)
[NAME] |  | HYP ACCT CHGD |  | DR/(CR) |  |  | (PROVIDE DETAIL OF INDIVIDUAL ITEMS
 |  |  |  |  |  |  | IN EXCESS OF $200,000.)
 |  |  |  |  |  |  | (1) Reclassification between property
 |  |  |  |  |  |  | accounts (should net to -0-)
 |  |  |  |  |  |  | (2) Intercompany transfer
 |  |  |  |  |  |  | (list companies):
 |  | TOTAL
 |  |  |  |  |  |  | (3) Acquisition (disposition)
 |  |  |  |  |  |  | of business
 |  |  |  |  |  |  | (4) Foreign currency
 |  |  |  |  |  |  | translation adjustment
 |  |  |  |  |  |  | (5) Lease impairments -
 |  |  |  |  |  |  | Oil & Gas
 |  |  |  |  |  |  | (6) Other (detail):
 |  |  |  |  |  |  |  | Reclass to Deferred Charge Hyp acct 344 |  |  |  |  |  | 235857
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
Spreadsheet: 105998d1303237137-using-vlookup-and-data-filter-together-copy-of-outstandingbills
Sheet: Bills

Party Name | Party Code | [NAME] | [NAME]
ABC Developers | 1 | 2011-12-31 00:00:00 | 500000
Apex Computers | 2 | 2011-02-01 00:00:00 | 800000
Sky Computers | 3 | 2011-02-15 00:00:00 | 655000
Spreadsheet: 888039d1738349719-excel-formula-help-ef1668_attendance-tracker
Sheet: Attendance

Atendance for the Month of |  |  |  |  |  |  |  |  |  |  |  | January
 |  | Start Date |  |  |  |  | End Date
Holiday
Name of Employee |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Excused EX | Unexcused UnEx | No Call No Show NCNS
Spreadsheet: 127379d1320328507-help-using-match-and-index-i-think-copy-of-sample-worksheets-1
Sheet:  Exp Breakdown

2100 | % | Salary | Wages | Medical | Security | Total
 |  |  |  | 9508
 |  |  |  | 9508
 |  |  |  | 9508
6500
 |  |  |  | 9508
 |  |  |  | 9508
5100
 |  |  |  | 9508
 |  |  |  | 9508
 |  |  |  | 9508
Enter a formula in this
column to auto populate
a name
based on the
table in
[NAME]
that cross references | the account code