tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0861efc5-0b91-4eb5-99e5-06a9aa0f9ea9
Sheet: Example Budget Spreadsheet

Discover Poland; Summer 2012: [NAME]
Program Dates: May 14, 2012 to May 27, 2012
ORG: 101555
 |  |  | Number of faculty supported by participants |  |  | USD to 1 Foreign Currency
Classes: HUM 205 |  |  | 1 |  |  | 0.29
 |  |  | Per Participant based on full fee |  |  | Activities & Excursions | Foreign Currency per room | Cost Per Person |  | Accommodations | Dates | Foreign Currency per room | Cost Per Person
 |  |  | 9 |  |  | Krakow Jewish Quarter | 0 |  |  | Hotel Krakow | 05/14/12 to 05/20/12 | 1452
 |  |  |  |  |  | Auschwitz | 150 |  |  | Hotel Warsaw | 5/21/2012 to 05/27/12 | 1511
Budget Item | Foreign Currency | USD |  |  |  | Castle in Krakow | 100
[NAME] |  |  |  | The [NAME]. stipend amount is $2000.00 |  | Museum | 30
Faculty Benefits |  | 0
[NAME] |  | 540 |  | (Depart $270)  (Arrival $270)
Airfare (per person) |  | 1100
Airport Transfers | 0 | 80
Housing (per person) |  |  |  |  |  |  |  |  |  | People per room | 2 | Total
Meals (per person)
Activities & Excursions (per person) |  |  |  |  |  |  |  |  |  | Participant Meals | # of meals included in program | Amount permited per meal | Cost Per Person
On-site transportation | 182 |  |  |  |  |  |  |  |  | Breakfast | 10 | 8
Tips |  | 50 |  |  |  |  |  |  |  | Lunch | 10 | 9
Phone Charges |  |  |  |  |  |  |  |  |  | Dinner | 10 | 19
Contingencies |  | 25 |  |  |  |  |  |  |  | Total
Director Airfare
Director Insurance |  | 36.5 |  |  |  |  |  |  |  | [NAME] | # of students | Amount alloted per student | Stipend
Director Housing |  |  |  |  |  |  |  |  |  | [NAME] |  | 10
Director Daily Meals
Director Activities |  |  |  |  |  | Total |  |  |  | Faculty Meals | # of meals included in program | Amount permited per meal | Cost Per Person
Director [NAME] |  | 52.78 |  |  |  | Phone Usage Charges |  |  |  | Breakfast | 10 | 8
Director to/from US Airport |  | 150 |  |  |  | Phone ($35 If phone is not returned) |  |  |  | Lunch | 10 | 9
Director's total cost |  |  |  |  |  | SimCard ($25 If SimCard is not returned) |  |  |  | Dinner | 10 | 19
 |  |  |  |  |  | Minutes ([NAME]) |  | 40 |  | Total
Total Individual Expenses |  |  |  |  |  | Additional Credit (when account drps below $20, $30 credit will automatically be credited and be billed to the assigned individual's account.
 |  |  |  |  |  | Total
 |  |  |  |  |  | Note:  Students are required to buy insurance for themselves as part of their applications on Horizon's through CISI.  The insurance is $36.50 per person.  There is a link in the Horizon's post acceptance application that explains to students how to complete this portion of the application.
Advertised Program Price |  | $?????
Spreadsheet: 81884d1282020211-matching-rows-in-excel-and-finding-out-duplicate-rows-contacts_records
Sheet: Company_Records

Company Name | First Name | Last Name | Job Title | Address 1 | Phone | Website
Big Design | [NAME] | Love | Sales Manager | 11 NY, USA | 123-456-567 | www.bigdesign.com
Big Design | Stephen | Gills | Director | 12 NY, USA | 123-456-568 | www.bigdesign.com
Big Design | [NAME] | McKay | CEO | 13 NY, USA | 432-455-354 | www.bigdesign.com
ABC LLC | [NAME] | Soll | President | Garden Town, LA, USA | 542-123-123 | www.abc.com
ABC LLC | [NAME] | Fard | Technician | 415 M Town, UK | 453-989-876 | www.abc.com
ABC LLC | [NAME] | Higg | Director | 818 Melbourne, Australia | 453-989-877 | www.abc.com
Future Ltd | [NAME] | Tilds | Assistant | 12, NY, USA | 233-111-111 | www.futureltd.com
Future Ltd | Beny | Hard | Vice Executive | 33, UK | 101-000-000 | www.futureltd.com
Future Ltd | [NAME] | Farris | CFO | 34, New Zeland | 103-340-009 | www.futureltd.com
Digital Torch | Jet | [NAME] | Technician | 12, Australia | 124-009-007 | www.digital.com
Digital Torch | Johny | Mac | Designer | 12, Australia | 124-009-008 | www.digital.com
Digital Torch | [NAME] | Rid | [NAME] | 12, Australia | 124-009-009 | www.digital.com
In sheet1: I have these records: (Company Records)
In sheet 2: I have these records: (All Records)
In sheet 2 i have all the contacts that includes personal contacts, company contacts etc plus in few records there is no company name, address etc
(a)Now in sheet 3 i want those records (with complete row i.e. all fields) from sheet 2 that matches with records in sheet 1 (matching will be based on First Name, Last Name & CompanyName)
(b) In addition to that the records which are in sheet 2, i am not sure if they are correct or not,
so if any row (from sheet 2) matches with row(in sheet 1)[on bases of 3 fields that i mentioned above] i want Address, website and JobTitle (in resultant sheet 3) to be updated according to sheet 1
How to do that ? please guide me....as i have 10,000 records and manually doing each one is not possible....
Spreadsheet: 32537d1228749171-if-statements-and-date-logic-sample-resource-model_hourly_view
Sheet: Sheet1

Name | Allocation | Start Date | End Date | 2008-12-01 00:00:00 | 2008-12-08 00:00:00 | 2008-12-15 00:00:00 | 2008-12-22 00:00:00 | 2008-12-29 00:00:00 | 2009-01-05 00:00:00 | 2009-01-12 00:00:00 | 2009-01-19 00:00:00 | 2009-01-26 00:00:00 | 2009-02-02 00:00:00 | 2009-02-09 00:00:00 | 2009-02-16 00:00:00 | 2009-02-23 00:00:00 | 2009-03-02 00:00:00 | 2009-03-09 00:00:00 | 2009-03-16 00:00:00 | 2009-03-23 00:00:00 | 2009-03-30 00:00:00 | 2009-04-06 00:00:00 | 2009-04-13 00:00:00 | 2009-04-20 00:00:00 | 2009-04-27 00:00:00 | 2009-05-04 00:00:00 | 2009-05-11 00:00:00 | 2009-05-18 00:00:00 | 2009-05-25 00:00:00 | 2009-06-01 00:00:00 | 2009-06-08 00:00:00 | 2009-06-15 00:00:00 | 2009-06-22 00:00:00 | 2009-06-29 00:00:00
AA | 0.8 | 2008-12-01 00:00:00 | 2009-02-25 00:00:00 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 26.66666666666666 | 25.5 | 23.07692307692308 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AA | 1 | 2008-12-01 00:00:00 | 2009-03-17 00:00:00 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 20 | 14.67391304347826 | 4.6875 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AA | 0.5 | 2008-02-04 00:00:00 | 2009-04-15 00:00:00 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 7.5 | 3.125 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AA | 1 | 2008-12-01 00:00:00 | 2009-06-30 00:00:00 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5
AA | 0.75 | 2008-12-01 00:00:00 | 2009-06-18 00:00:00 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 28.125 | 16.875 | 13.45108695652174 | 7.03125 | 0 | 0
AA | 1 | 2008-12-01 00:00:00 | 2008-12-31 00:00:00 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AA | 0.9 | 2009-01-12 00:00:00 | 2009-06-09 00:00:00 | 0 | 0 | 0 | 0 | 0 | 25 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 33.75 | 10.125 | 2.934782608695652 | 0 | 0 | 0
AA | 1 | 2009-01-12 00:00:00 | 2009-06-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 27.77777777777778 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5
Spreadsheet: 153663d1335993967-somewhat-complex-document-problems-extracting-and-organizing-data-from-cells-6maxhyper
Sheet: Sheet1

 | Players | UTG | MP | CO | BU | SB | BB
Spreadsheet: 166489d1341600190-formula-problem-vlookup-combined-with-if-statement-excel-spreadheet-if-statement-with-vloolup
Sheet: Kim Count

Invoice Creation Date | Billing Specialist | Comments | Invoice Number | Sold To Customer | Contract Type
2012-07-05 00:00:00 | [NAME] |  | 1154321 | 1ST ID 75TH FIRES BDE 3RD BN 13TH FAR | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | [NAME] |  | 1154317 | 1ST SWTG 2ND BN B CO | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | [NAME] |  | 1153089 | 200TH MP CMD | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | [NAME] |  | 1154322 | AR NG PA | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | [NAME] |  | 1154324 | ARMY SF 1ST SFG | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | [NAME] |  | 1154316 | DE AIR NG 166TH AW 166TH MSG 166TH CES | FESNE #SPM8EG08D0005
2012-07-05 00:00:00 | [NAME] |  | 1154316 | DE AIR NG 166TH AW 166TH MSG 166TH CES | FESNE #SPM8EG08D0005
2012-07-05 00:00:00 | [NAME] |  | 1154510 | DEFENSE SUPPLY CTR PHILADELPHIA | TLSNFPOA #SPM8EJ09D0020
2012-07-05 00:00:00 | [NAME] |  | 1154509 | DEFENSE SUPPLY CTR PHILADELPHIA | TLSNFPOA #SPM8EJ09D0020
2012-07-05 00:00:00 | [NAME] |  | 1154314 | HS 10 | FESWT #SPM8EG08D0016
2012-07-05 00:00:00 | [NAME] |  | 1154315 | HSC 84 | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | [NAME] |  | 1154323 | III CORPS ARTY 214TH FIRES BDE 2ND BN 5TH FAR | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | [NAME] |  | 1154320 | SAO-A | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | [NAME] |  | 1154318 | SPAWAR SD | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | [NAME] |  | 1154319 | USARPAC 9TH MSC | TLSNFPBID #SPM8EJ09D0017
Spreadsheet: 111258d1307662846-how-to-use-lookup-command-form14excel
Sheet: JPR COVERAGE

January | February | March | April | May | June | July | August | September
A01A | B01A
A01B | B02B
A01C | B02C
A01D | B02D
A01E | B02E
A01F | B02F
A01G | B02G
A01H | B02H
A01I | [NAME]
A01J | B02J
[NAME] | B02K
A01L | B02L
A01M | B02M
A01N | B02N
A01O | B02O
A01P | B02P
A01Q | B02Q
A01R | B02R
A01S | B02S
A01T | B02T
Spreadsheet: 833393d1686933081-sum-values-each-row-dynamic-arrays-return-spilling-column-sumrow
Sheet: Feuil1

IGNORE
A | B | C |  | A | B | C |  | total of row, spilling, expected result
0 | 1 | 0 |  |  | 1 | 0 |  | 1
0 | 1 | 0 |  | 0 | 1 | 0 |  | 1
0 | 1 | 1 |  | 0 | 1 | 1 |  | 2
1 | 0 | 0 |  | 1 | 0 | 0 |  | 1
0 | 1 | 0 |  | 0 | 1 | 0 |  | 1
0 | 0 | 0 |  | 0 | 0 | 0 |  | 0
1 | 0 | 0 |  | 1 | 0 | 0 |  | 1
1 | 0 | 0 |  | 1 | 0 | 0 |  | 1
0 | 0 | 1 |  | 0 | 0 | 1 |  | 1
1 | 0 | 1 |  | 1 | 0 | 1 |  | 2
Spreadsheet: 06ce6aa0-2756-4a81-a639-dcccc2aeaf35
Sheet: HS

High School Division
TEAM | Championships | Tourny's | Overall | Overall | Overall |  | Bracket | Bracket
2012-06-25 00:00:00 | Won | played | Win | Loss | Ties |  | Won | Lost
Bartow Outlaws |  | 1 | 3 | 2 |  |  | 1 | 1
[NAME] |  | 1 | 2 | 2 |  |  | 0 | 1
Chobee Lady Bulls |  | 1 | 0 | 3 | 2
Cooper City Cobras 18U |  | 1 | 3 | 3 |  |  | 2 | 2
Coral Springs Panthers |  | 1 | 1 | 4 |  |  | 1 | 2
FL Misfits HS |  | 1 | 3 | 1 |  |  | 0 | 1
[NAME] |  | 1 | 3 | 2
Nitroz | 1 | 1 | 4 | 1 |  |  | 3 | 1
Polk County Crush 97 |  | 1 | 2 | 3
[NAME] |  | 1 | 1 | 4 |  |  | 1 | 1
[NAME] | 1 | 1 | 3 | 1 |  |  | 2 | 0
[NAME] 18U |  | 1 | 2 | 2 |  |  | 0 | 2
Tampa Blaze |  | 1 | 3 | 1 | 1
Tampa Panthers |  | 1 | 2 | 2
Team FLA 16U |  | 1 | 2 | 3
Team Xstatic |  | 2 | 4 | 4
Twilight Twisters Pink |  | 1 | 2 | 3
Venice Venom | 1 | 1 | 5 | 0
Spreadsheet: 84945d6b-bd9f-4c43-b3bc-eecafa68fbe2
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 14998418693 | [NAME] | Blessed & Cursed | 2010-07-27 | DVD | Insp | 15.95 | Y | Available
Taseis | 859219001595 | My Destiny Place | Imagine This / Believe In You | 2011-04-19 | DVD | Children | 5.95 | Y | Available
Taseis | 859219001694 | My Destiny Place | Let Us Entertain You / Never Give Up | 2011-04-19 | DVD | Children | 5.95 | Y | Available
Taseis | 859219001397 | [NAME] | Live In Chicago | 2010-10-26 | DVD | Comedy | 11.99 | Y | Available
Taseis | 14998419492 | [NAME] | [NAME], A | 2012-08-21 | DVD | Insp | 15.95 | Y | Available
Taseis | 14998419393 | [NAME] | Live: The Journey | 2011-10-18 | DVD | Gospel | 10.99 | Y | Available
Taseis | 859219001793 | My Destiny Place | Practice, Practice, Practice! [NAME] | 2011-06-21 | DVD | Children | 5.95 | Y | Available
Spreadsheet: rick_buy__32796__NP Daily Marks
Sheet: Breakdown

The New Power Company
Breakdown by Product
 |  |  |  | Per CAS | Capacity Corr. |  |  | Per CAS | Capacity Corr. |  |  | Per CAS | Capacity Corr. |  |  | Per CAS | Capacity Corr. |  |  | Per CAS | Capacity Corr. |  |  | Per CAS |  |  |  | Per CAS
 | COB 8/27/01 | COB 8/28/01 |  | COB 8/29/01 | COB 8/29/01 | Difference |  | COB 9/4/01 | COB 9/4/01 | Difference |  | COB 9/6/01 | COB 9/6/01 | Difference |  | COB 9/10/01 | COB 9/10/01 | Difference |  | COB 9/12/01 | COB 9/12/01 | Difference |  | COB 9/17/01 | COB 9/17/01 | Difference |  | COB 9/18/01 | COB 9/18/01 | Difference | COB 9/19/01 |  | Daily Change
Financial MTM | 49947286 | 55858213 |  | 57692146 | 57692146 |  |  | 46484930 | 46484930 |  |  | 46043210 | 46043210 |  |  | 44910437 | 44910437 |  |  | 42269727 | 42269727 |  |  | 41763715 |  |  |  | 48406572
Gas MTM | 4691838 | 4946778 |  | 5061950 | 5061950 |  |  | 4923532 | 4923532 |  |  | 4872850 | 4872850 |  |  | 10151598 | 10151598 |  |  | 4747637 | 4747637 |  |  | 5004111 |  |  |  | 5458453 |  |  | 5910950
Gas Purchases |  | -596668 |  | -601718 | -601718 |  |  | -1209051 | -1209051 |  |  | -1333842 | -1333842 |  |  | -1333845 | -1333845 |  |  | -1333852 | -1333852 |  |  | -1333861 |  |  |  | -1408374 |  |  | -804194
Gas Sales |  | 7435080 |  | 7435080 | 7435080 |  |  | 15290816 | 15290816 |  |  | 15053482 | 15053482 |  |  | 15054186 | 15054186 |  |  | 15054427 | 15054427 |  |  | 15060666 |  |  |  | 15066560 |  |  | 8027587
Total Gas
Power MTM | 52787394 | 54029592 |  | 54402992 | 54402992 |  |  | 53378304 | 53378304 |  |  | 7690871 | 7690871 |  |  | 48353305 | 48353305 |  |  | 46016089 | 46016089 |  |  | 37433537 |  |  |  | 45334327 |  |  | 49514316
Power Purchases | -82546945 | -85660468 |  | -88773990 | -18720422 |  |  | -102241362 | -19885207.79999999 |  |  | -37773032 | -19885207.79999999 |  |  | -45558719 | -19885207.79999999 |  |  | -53584206 | -19885207.79999999 |  |  | -66720218 | -19885207.79999999 |  |  | -50001684 | -19885207.79999999 |  | -6923427.8
Power Sales | 108806923 | 112835527 |  | 116864132 | 16183721 |  |  | 135064396 | 16702984 |  |  | 41539165 | 16702984 |  |  | 52171599 | 16702984 |  |  | 62833553 | 16702984 |  |  | 80573957 | 16702984 |  |  | 67422539 | 16702984 |  | 5220184
Total Power
Total Exposure
Treashold Amt. | -15000000 | -15000000 |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | 0 | 0 |  | 0
Collateral Posted | -87300000
Margin due to ENE
Spreadsheet: louise_kitchen__22533__3base329c
Sheet: 50 NR

Note Receivable |  |  |  | Today |  |  |  |  | Principle
Face | 50000000 |  |  | Last Pymt Date |  |  |  |  | Accrued Interest
Interest |  |  |  | Interest Days
Tenor |  |  |  | Next Interest |  |  |  |  | Cum. Interest Inc.
Payment
Date | Beg. Bal | Payment | Interest | Principle | End Bal |  | Cum Payments | Cum Int Inc
2000-09-27 00:00:00 |  |  |  |  |  | 60
2001-03-27 00:00:00 |  |  |  |  |  | 59
2001-09-27 00:00:00 |  |  |  |  |  | 58
2002-03-27 00:00:00 |  |  |  |  |  | 57
2002-09-27 00:00:00 |  |  |  |  |  | 56
2003-03-27 00:00:00 |  |  |  |  |  | 55
2003-09-27 00:00:00 |  |  |  |  |  | 54
2004-03-27 00:00:00 |  |  |  |  |  | 53
2004-09-27 00:00:00 |  |  |  |  |  | 52
2005-03-27 00:00:00 |  |  |  |  |  | 51
2005-09-27 00:00:00 |  |  |  |  |  | 50
Spreadsheet: 126161d1319552043-formula-to-ignore-data-entered-after-the-current-projected-qualifying-date-cal_daddy
Sheet: BLOGGS

EXAMPLE 1
BLOGGS
 | 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 |  |  | MY FORMULA
2011-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absent days | Qual date
2011-11-01 00:00:00 |  |  |  |  |  |  |  |  |  | s |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | 4 | 2011-12-30 00:00:00
2011-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | h | h | h
2012-01-01 00:00:00
2012-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x
EXAMPLE 2
PERRY
 | 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 |  |  | MY FORMULA
2011-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absent days | Qual date
2011-11-01 00:00:00 |  |  |  |  |  |  |  |  |  | s | s |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | 8 | 2011-12-28 00:00:00
2011-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | h
2012-01-01 00:00:00 |  | h | h | h | h | h
2012-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x
Spreadsheet: 133179d1324246571-excel-2007-tick-off-a-box-after-user-ticks-off-tasks-dummywb
Sheet: Sheet1

 | Day 1 Part A | Day 1 Part B | Days 2-4 |  |  | Day 1 Part A | Day 1 Part B | Days 2-4 |  | Day 1 Part A | Day 1 Part B | Days 2-4
Task 1 |  |  |  |  |  | True | True | True
Task 2 |  |  |  |  |  | True | True | True
Task 3 |  |  |  |  |  | True | True | True
Task 4 |  |  |  |  |  | True | True | True
Task 5 |  |  |  |  |  | True | True | True
Task 6 |  |  |  |  |  | True | True | True
Task 7 |  |  |  |  |  | True | True | True
Task 8 |  |  |  |  |  | True | True
Task 9 |  |  |  |  |  | True | True
Task 10 |  |  |  |  |  |  | True
Task 11
Task 12
Task 13
Task 14
Completed?
Spreadsheet: 759605d1639610203-query-to-find-the-highest-overal-percentage-from-different-data-types-subs-generals-hydr-
Sheet: Sheet1

 | [NAME]
General | Total Attack | Total Def | Total HP | GR Atk | Gr Def | GR HP | Mount Atk | Mount Def | Mount HP | [NAME] | [NAME] | Range HP | [NAME] | Seige Def | Seige HP
Baldwin IV |  |  |  |  |  |  |  |  |  | -0.3 |  |  | -0.2
[NAME] | -0.1 |  | -0.1
[NAME] |  | -0.1 |  |  |  |  |  |  |  | -0.3
Cnut the Great |  |  |  |  |  | -0.15 |  |  | -0.15 | -0.25
Arminius |  |  |  |  |  | -0.1 |  |  | -0.1 | -0.15 |  |  | -0.15
Jester | -0.15
Flavius Aetius |  |  |  |  |  | -0.2 |  |  |  |  |  |  | -0.2
[NAME] I | -0.1 |  |  |  |  |  | -0.2
[NAME] |  |  |  | -0.25 |  |  |  |  |  | -0.15 |  |  | -0.15
[NAME] I |  |  |  | -0.35 |  | -0.2 |  |  | -0.2
Empress Dowager Cixi |  | -0.15 |  |  | -0.15
Nero |  |  | -0.15
[NAME] | -0.1
[NAME] |  |  |  |  |  |  |  |  | -0.2 | -0.2
[NAME] |  |  |  |  |  |  |  |  |  | -0.1 |  |  | -0.1
Honda Tadakatsu |  |  |  |  |  | -0.15 |  |  | -0.15
Constantine the Great |  |  |  | -0.2 |  |  | -0.2
Himiko |  |  |  |  |  |  | -0.25
[NAME] |  |  |  | -0.15 |  |  | -0.15
General Selection | Total Attack | Total Def | Total HP | GR Atk | Gr Def | GR HP | Mount Atk | Mount Def | Mount HP | [NAME] | [NAME] | Range HP | [NAME] | Seige Def | Seige HP
1,2,3,4,5,6,7,8,9
 | the needed calculator sample it’s static as of now but I really want to find a way to select and choose form the above list 9 Generals and Excel sheet at the end calculate and show results automatically as shown below
 | Select Generals
 |  | Baldwin IV | [NAME] | [NAME] | Cnut the Great | Arminius | Jester | Flavius Aetius | [NAME] I | [NAME]
 | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
 | Ground | Mounted | Ranged | Seige | Ground | Mounted | Ranged | Seige | Ground | Mounted | Ranged | Seige
 | in which here the values will calculate all the debuffs in each field of the above table and put it here, the total is added to all troop types, as example:  [NAME], has -10% atk and HP for all troops, means this will give a -10% in attack in all the values calculated in cells B35,C35,D35,E35 and same goes in J35,K35,L35,M35
Spreadsheet: 268509d1380659399-index-and-match-formula-test
Sheet: Sheet2

 |  | 0.004482728251959564 | 41317.40000000004 | 0
 |  |  |  | Band 2
Exec | List Price Inc Options (inc Customer Saving) | Margin % | Total Profit | Lookup
Mark | 14666 | -0.08170367968876648 | -1008.060000000001
[NAME] | 14666 | -0.08170367968876648 | -1008.060000000001
Fred | 14666 | -0.08170367968876648 | -1008.060000000001
[NAME] | 14666 | -0.08170367968876648 | -1008.060000000001
Mark | 14666 | -0.08170367968876648 | -1008.060000000001
Spreadsheet: 817677d1676387601-horse-betting-odds-and-returns-calculator-horse-racing-profit-and-loss-
Sheet: Sheet1

Stake | Odds | Win / Each Way | Payout | Profit
10 | 10 | Win
Amount bet | Odds offered by betting firm (I have hard coded using a ' but I want this displayed as a fraction | Was the bet for a win or place | If WIN, then multiply stake with odds (£10 x 10) PLUS stake = £110 | Profit is payout minus stake
10 | 10 | Each Way
Amount bet | Odds offered by betting firm (I have hard coded using a ' but I want this displayed as a fraction | This time it's each way | If WIN, then multiply stake with odds (£10 x 10) PLUS stake = £110  If Each Way, then half the stake, multiplied by 1/5 of the odds e.g.  £10 bet - £5 on win and £5 on place so £5 is lost on the win part of the bet and the remaining £5 is returned plus 1/5 odds of 10/1 (so 2/1) = £5 + 2x£5 = £15 | Profit is payout minus stake
Spreadsheet: 118303d1313593745-last-used-range-vba-code-new-microsoft-office-excel-worksheet-5-
Sheet: Sheet2

Consolidated Statement of Income (Unaudited)—Three and Nine Months Ended September 30, 2006 and 2005 |  | 86
Consolidated Balance Sheet—September 30, 2006 (Unaudited) and December 31, 2005 |  | 87
Consolidated Statement of Changes in Stockholders' Equity (Unaudited)—Nine Months Ended September 30, 2006 and 2005 |  | 88
Consolidated Statement of Cash Flows (Unaudited)—Nine Months Ended September 30, 2006 and 2005 |  | 89
Consolidated Balance Sheet—Citibank, N.A. and Subsidiaries September 30, 2006 (Unaudited) |  | 90
and December 31, 2005
Notes to Consolidated Financial Statements ([NAME]):
In millions of dollars |  | Citigroup |  |  | CGMHI |  |  | CFI |  |  | CCC |  |  | Associates |  |  | Other Citigroup |  |  | Consolidating |  |  | Citigroup
 |  | parent |  |  |  |  |  |  |  |  |  |  |  |  |  |  | subsidiaries, |  |  | adjustments |  |  | Consolidated
 |  | company |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eliminations and
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | income from
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | discontinued
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | operations
Revenues
Spreadsheet: 684761d1593526763-remove-blanks-from-data-vaildation-lists-test-enviro-eie
Sheet: Accounts

Owner | Type | Name | Amount | Growth Rate
[NAME] | Checking | My Checking | 10000
Joint | Checking | [NAME] | 1400
[NAME] | Savings | John's Savings | 25000
Suzie | Money Market | Suzie's Car Account | 3000
Lewis | Savings | Lewis's Guitar Account | 300
Spreadsheet: 01ed928d-5fe4-486b-ad2f-e95a46266d9b
Sheet: vols added monographs

Monograph Volumes Added FY10 and FY11
Monograph Volumes Added by Acquisition Type FY10 and FY11 (Kingston only)
Acquisition Type | FY10 | FY11 | % change | % of total FY11 vols.
Approval Plan (Strand) | 3908 | 3715
Firm orders | 3507 | 3901
Standing orders | 218 | 151
Gifts | 3899 | 2903
TOTALS
Average Price of Monograph FY10 and FY11 (Kingston only)
 | FY10 | FY11 | % change
Amount spent | 347375.7 | 337819.13
[NAME] purchased |  | 7767
Average price paid per volume