tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 270289d1381430210-need-help-with-formula-deleting-rows-main
Sheet: Main

Col A | Department | Col C | Col D | Col E | Col F | Col G | Date Received
1 | Finance | a | 100 | blue | open | Resolved | 2010-09-23 00:00:00
2 | Accounting | b | 101 | red | closed | Resolved
3 | HR | c | 102 | orange | closed | Resolved | 2012-01-17 00:00:00
4 | HR | d | 103 | green | closed | Resolved | 2012-09-07 00:00:00
5 | HR | e | 104 | yellow green | closed | Resolved | 2012-09-25 00:00:00
6 | HR | f | 105 | dark blue | closed | Resolved | 2012-11-30 00:00:00
7 | Finance | g | 106 | yellow | closed | Resolved | 2011-04-05 00:00:00
8 | Accounting | h | 107 | orange | closed | Resolved | 2011-07-29 00:00:00
9 | HR | I | 108 | green | closed | Resolved | 2011-02-09 00:00:00
10 | HR | j | 109 | yellow green | closed | Resolved | 2012-08-20 00:00:00
11 | HR | k | 110 | dark blue | closed | Resolved | 2012-08-29 00:00:00
12 | HR | l | 111 | yellow | closed | Resolved | 2011-06-09 00:00:00
13 | HR | m | 112 | green | closed | Resolved | 2013-04-25 00:00:00
14 | Finance | n | 113 | green | closed | Resolved | 2011-03-04 00:00:00
15 | Accounting | o | 114 | purple | closed | Resolved | 2013-07-31 00:00:00
16 | HR | p | 115 | purple | closed | Resolved
17 | HR | q | 116 | pink | closed | Resolved | 2010-09-15 00:00:00
18 | HR | r | 117 | pink | closed | Resolved | 2012-08-27 00:00:00
19 | HR | s | 118 | green | closed | Resolved | 2011-11-22 00:00:00
Spreadsheet: tori_kuykendall__39962__pasadena sept
Sheet: Sheet 1

City of Pasadena
Sept 2000 Invoice
 |  |  |  |  |  |  |  |  |  |  |  | Gas Daily | Gas Daily | Gas Daily | Gas Daily
 |  |  |  |  |  |  | Gas Daily | SoCal | Pasadena |  | Pasadena | Purchases | Purchases | Sales | Sales
[NAME] | 6.31 |  |  |  |  | Date | Mid | Usage | Net Nom | APEA | Imbalance | from EPMI | from EPMI | to EPMI | to EPMI
IFGMR EP San Juan | 3.45 |  |  |  |  |  | $/MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | $ | MMBtu | $
 |  |  |  |  |  | 2000-09-01 00:00:00 | 6.18 | 6659 |  | 3000
 |  |  |  | Amount |  | 2000-09-02 00:00:00 | 5.875 | 5485 |  | 3000
 | Border | Basin |  | Due |  | 2000-09-03 00:00:00 | 5.875 | 6844 |  | 3000
Pasadena | MMBtu | MMBtu | $/MMBtu | $ |  | 2000-09-04 00:00:00 | 5.875 | 9755 |  | 3000
Nomination |  |  |  |  |  | 2000-09-05 00:00:00 | 5.875 | 12445 |  | 3000
APEA Nomination |  |  |  |  |  | 2000-09-06 00:00:00 | 6.205 | 8421 |  | 3000
Net Nomination |  |  |  |  |  | 2000-09-07 00:00:00 | 6.34 | 11010 |  | 3000
 |  |  |  |  |  | 2000-09-08 00:00:00 | 6.225 | 7768 |  | 3000
Usage |  |  |  |  |  | 2000-09-09 00:00:00 | 6.15 | 6088 |  | 3000
Less APEA Usage |  |  |  |  |  | 2000-09-10 00:00:00 | 6.15 | 7658 |  | 3000
Net Usage |  |  |  |  |  | 2000-09-11 00:00:00 | 6.15 | 11416 |  | 3000
 |  |  |  |  |  | 2000-09-12 00:00:00 | 6.325 | 12411 |  | 3000
Gas Supply |  |  |  |  |  | 2000-09-13 00:00:00 | 6.36 | 21200 |  | 3000
NGI Purchases |  |  |  |  |  | 2000-09-14 00:00:00 | 6.39 | 17583 |  | 3000
Fixed Price Purchases | 30000 |  | 3.015 |  |  | 2000-09-15 00:00:00 | 6.37 | 12862 |  | 3000
Gas Daily Purchases from Enron |  |  |  |  |  | 2000-09-16 00:00:00 | 6.395 | 13631 |  | 3000
Gas Daily Sales to Enron |  |  |  |  |  | 2000-09-17 00:00:00 | 6.395 | 9974 |  | 3000
 |  |  |  |  |  | 2000-09-18 00:00:00 | 6.395 | 17722 |  | 3000
Kern River Station Purchases |  |  |  |  |  | 2000-09-19 00:00:00 | 6.31 | 15421 |  | 3000
Indexed Price Purchases | 118510 |  |  |  |  | 2000-09-20 00:00:00 | 6.25 | 18696 |  | 3000
Total Purchases |  |  |  |  |  | 2000-09-21 00:00:00 | 6.075 | 7620 |  | 3000
El Paso Capacity Reimbursement |  |  |  |  |  | 2000-09-22 00:00:00 | 5.7 | 6432 |  | 3000
Fixed | 105145 |  |  |  |  | 2000-09-23 00:00:00 | 5.34 | 6679 |  | 3000
Variable |  |  |  |  |  | 2000-09-24 00:00:00 | 5.34 | 8185 |  | 3000
 |  |  |  |  |  | 2000-09-25 00:00:00 | 5.34 | 8473 |  | 3000
Net Due |  |  |  |  |  | 2000-09-26 00:00:00 | 5.415 | 7526 |  | 3000
 |  |  |  |  |  | 2000-09-27 00:00:00 | 5.64 | 5867 |  | 3000
El Paso Capacity Reimbursement | $/MMBtu |  |  |  |  | 2000-09-28 00:00:00 | 5.75 | 8431 |  | 3000
 |  |  |  |  |  | 2000-09-29 00:00:00 | 5.845 | 9446 |  | 3000
[NAME] |  |  |  |  |  | 2000-09-30 00:00:00 | 5.695 | 5213 |  | 3000
IFGMR San Juan
Spread |  |  |  |  |  | Totals
 | -0.015
Less Fuel
Less Variable | -0.026
Net Reservation Value
Spreadsheet: richard_shapiro__32381__Stranded Cost Analysis Structuring Confidential3
Sheet: Overmarket Chart

 | Mark-to-Market of
 | DWR Contracts By Counter Party
 | ($s, negative number means contract is above market)
 | Calpine
 | Sempra
 | Coral
 | Dynegy
 | [NAME]
 | High Desert
 | GWF
 | Mirant
 | Constellation
 | El Paso
 | Morgan Stanley
 | Alliant
 | PG&E Gen
 | Clearwood
 | Allegheny
 | IID
 | Total Overmarket PV
Spreadsheet: ef0f8432-86dd-4d14-95e3-099d7d59ef42
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
43045678 | 2014-09-06 17:51:38 | ALLIES | 0 | 1 | 6 | 552083 | player552083 | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
43052457 | 2014-09-07 03:15:27 | ALLIES | 1 | 5 | 1 | 1631362 | [NAME] | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
43061691 | 2014-09-07 19:00:44 | AXIS | 0 | 5 | 7 | 706396 | Intello | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
43062015 | 2014-09-07 19:27:30 | ALLIES | 0 | 5 | 7 | 706396 | Intello | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
43132873 | 2014-09-12 23:56:41 | AXIS | 0 | 8 | 10 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43133306 | 2014-09-13 00:27:20 | ALLIES | 1 | 10 | 6 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43135234 | 2014-09-13 03:39:01 | AXIS | 1 | 4 | 0 | 1631362 | [NAME] | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
43135401 | 2014-09-13 04:03:59 | AXIS | 1 | 4 | 2 | 1631362 | [NAME] | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
43142605 | 2014-09-13 17:46:47 | AXIS | 1 | 6 | 2 | 1529880 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43157753 | 2014-09-14 17:59:50 | ALLIES | 1 | 6 | 5 | 21590 | Greenheart22 | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
Spreadsheet: 118672d1313869789-finding-next-nonblank-cell-and-copying-examplecomparison
Sheet: Comparison Sheet

1 | 1
2 | 22
3 | 3
4 | 4
5 | 42
6 | 6
7 | 7
8 | 8
9 | 32
10 | 10
Spreadsheet: 815879d1675248634-partial-matche-example-booklet
Sheet: Sheet1

Table Array | Lookup Value | Multiple Returns |  | Final Result Required:
123-123-789 | 123-123 | 123-123-123, 123-123-456, 123-123-789 |  | 123-123 | 123-123-123 |  |  | 123-123-789
123-123-456 | 123-456 | 123-456-123 |  | 123-123 | 123-123-456 |  | 123-123 | 123-123-456
123-456-123 | 123-789 | 123-789-123, 123-789-456 |  | 123-123 | 123-123-789 |  | 123-123 | 123-123-123
000-123-123 | 000-123 | 000-123-123, 000-123-456, 000-123-789, 000-123-000 |  | 123-456 | 123-456-123 |  | 123-456 | 123-456-123
123-789-123 |  |  |  | 123-789 | 123-789-123 |  | 123-789 | 123-789-123
123-789-456 |  |  |  | 123-789 | 123-789-456 |  | 123-789 | 123-789-456
000-123-456 |  |  |  | 000-123 | 000-123-123 |  | 000-123 | 000-123-123
123-123-123 |  |  |  | 000-123 | 000-123-456 |  | 000-123 | 000-123-456
000-123-789 |  |  |  | 000-123 | 000-123-789 |  | 000-123 | 000-123-789
000-123-000 |  |  |  | 000-123 | 000-123-000 |  | 000-123 | 000-123-000
Spreadsheet: 38113d1236238531-vlookup-function-not-working-properly-ejemplo-excel-tip
Sheet: Hoja1

 | id number |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
29 | 21421833 | CESPEDES | CANCINO | MARIA ROSARIO |  | CONJ. HABITACIONAL AGRUPAMIENTO LA ANGOSTURA | B | 8 | SUBTANJALLA | [NAME] | 6 | CSP | EFECT. |  | 2650 | 16750 | 19400 | CAL-01-05-430 | #N/A
30 | 21515932 | PEÑA | HERNANDEZ | MANUELA TERESA |  | CP SUBTANJALLA CERCADO I ETAPA | p | 30 | SUBTANJALLA | [NAME] |  | CSP | CD | 6000 |  | 13400 | 19400 | OI-CAL-01-05-138 | #N/A
Spreadsheet: 217207d1362001473-change-the-data-set-your-vlookups-pull-from-via-a-drop-box-bid-example
Sheet: Eastimate sheet

 | Select Historical Type | Building 1 | Building 2 | Building 3 | Building 4 | Building 5 | Building 6 | Building 7 | Building 8
 |  | 12500 | 3500 | 94000 | 2365 | 10000 | 12541 | 128410 | 1247
Electrical
plumbing
HVAC
Welding
Floor repair
Carpeting
Cleaning
Spreadsheet: 1e406405-8c69-4fcc-b47c-0b7d24422b70
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-09-09 09:29:58.150000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.742 | 101.617 | 101.492 | 101.117
4.25 | 101.154 | 101.029 | 100.904 | 100.529 |  | Note: | Refer To Price [NAME]
4.125 | 100.559 | 100.434 | 100.309 | 99.934 |  |  | For all Price Adjs
4 | 100.057 | 99.932 | 99.807
3.875 | 99.433 | 99.308 | 99.183
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 101.875 | 101.75 | 101.625 | 101.25
3.625 | 101.494 | 101.369 | 101.244 | 100.869
3.5 | 101.158 | 101.033 | 100.908 | 100.533
3.375 | 100.778 | 100.653 | 100.528 | 100.153
3.25 | 100.22 | 100.095 | 99.97
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-09-23 09:29:58.150000
30 DAY | 2011-10-08 09:29:58.150000
45 DAY | 2011-10-23 09:29:58.150000
60 DAY | 2011-11-07 09:29:58.150000
90 DAY | 2011-12-07 09:29:58.150000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 00c4140f-1490-48f9-82a6-1c7482baa56f
Sheet: Sheet1

San Diego Miramar College | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Grant Funding Implementation Form - Budget Template
Summary Page
 | Object of Expenditure |  | Classification/Description |  | Line |  |  |  | Requested Budget
 | 1000 |  | Instructional Salaries |  | 1 |  |  |  | 0
 | 2000 |  | Noninstructional Salaries |  | 2 |  |  |  | 0
 | 3000 |  | Employee Benefits |  | 3
 |  |  | Instructional Benefits |  | 3a |  |  |  | 0
 |  |  | Noninstructional Benefits |  | 3b |  |  |  | 0
 | 4000 |  | Supplies and Materials |  | 4 |  |  |  | 0
 | 5000 |  | Other Operating Expenses and Services |  | 5 |  |  |  | 0
 | 6000 |  | Capital Outlay |  | 6 |  |  |  | 0
 | 7000 |  | Other Outgo |  | 7 |  |  |  | 0
 |  |  | Total Direct Costs |  | 8 |  |  |  | 0
 |  |  | Total Indirect Costs (% of line 8) |  | 9 |  | 0.04 |  | 0
 |  |  | Total Budget Request |  | 10 |  |  |  | 0
 | This worksheet is a summary of the subsequent 6 tabs
 | The only entry on this worksheet is the variable % Indirect Rate highlighed in yellow above
Spreadsheet: 182673d1348576435-multi-dependant-data-validation-multipale-data-validation
Sheet: Sheet1

Main Group |  | Main Group | SUBGROUP |  | SUBGROUP | TASK
CASUAL LABOUR |  | CASUAL LABOUR | CASUAL LABOUR |  | CASUAL LABOUR | CASUAL LABOUR
CONSULTANCY FEES |  | CONSULTANCY FEES | PROJECT CONSULTANCY FEES |  | CASUAL LABOUR | LABOUR CHARGES
CONTRACTORS PAYMENTS |  | CONTRACTORS PAYMENTS | CONTRACTORS PAYMENTS |  | PROJECT CONSULTANCY FEES | PROJECT CONSULTANCY FEES
DEBRIS |  | DEBRIS | DEBRIS |  | CONTRACTORS PAYMENTS | ACTUAL PAYMENT OF LABOUR CONTRACTOR
GLASS PARTITION |  | GLASS PARTITION | GLASS PARTITIONS |  | CONTRACTORS PAYMENTS | CASH ADVANCE
PROJECT SALARIES LABOUR |  | PROJECT SALARIES LABOUR | ACCOMMODATION FOR LABOUR |  | CONTRACTORS PAYMENTS | CONTRACT LABOUR - INTERIORS
DOORS |  | PROJECT SALARIES LABOUR | ACCOMODATION DEPOSITE LABOUR |  | CONTRACTORS PAYMENTS | CONTRACT PAYMENT
 |  | PROJECT SALARIES LABOUR | FOOD MONEY FOR LABOUR |  | CONTRACTORS PAYMENTS | LIFTTING CHARGES
 |  | PROJECT SALARIES LABOUR | PROJECT SALARY LABOUR |  | CONTRACTORS PAYMENTS | OUT STATION CHARGES
 |  | PROJECT SALARIES LABOUR | TRAVELING LABOUR |  | DEBRIS | DEBRIS
 |  | DOORS | AUTOMATED SLIDING GLASS DOOR |  | GLASS PARTITIONS | [NAME]
 |  |  |  |  | GLASS PARTITIONS | LOADING & PACKING CHARGES
 |  |  |  |  | GLASS PARTITIONS | POLISH CHARGES FOR GLASS
 |  |  |  |  | ACCOMMODATION FOR LABOUR | ELECTRICITY BILL OF RENT ROOM
 |  |  |  |  | ACCOMMODATION FOR LABOUR | PROJECT SALARIES - ACCOMMODATION FOR LABOUR AT SITE
 |  |  |  |  | ACCOMODATION DEPOSITE LABOUR | ACCOMODATION DEPOSITE FOR LABOUR AT SITE
 |  |  |  |  | FOOD MONEY FOR LABOUR | FOOD FOR CARPANTARY
 |  |  |  |  | FOOD MONEY FOR LABOUR | PROJECT SALARIES - FOOD MONEY FOR LABOUR AT SITE
 |  |  |  |  | PROJECT SALARY LABOUR | APR. PROJECT LABOUR SALARY
 |  |  |  |  | PROJECT SALARY LABOUR | AUG. PROJECT LABOUR SALARY
 |  |  |  |  | PROJECT SALARY LABOUR | DEC. PROJECT LABOUR SALARY
 |  |  |  |  | PROJECT SALARY LABOUR | FEB. PROJECT LABOUR SALARY
 |  |  |  |  | PROJECT SALARY LABOUR | FOOD FOR STORE KEEPER
 |  |  |  |  | PROJECT SALARY LABOUR | JAN. [NAME] SALARY
 |  |  |  |  | PROJECT SALARY LABOUR | JULY PROJECT LABOUR SALARY
 |  |  |  |  | PROJECT SALARY LABOUR | JUNE PROJECT LABOUR SALARY
 |  |  |  |  | PROJECT SALARY LABOUR | MAR. [NAME] SALARY
 |  |  |  |  | PROJECT SALARY LABOUR | MAY PROJECT LABOUR SALARY
 |  |  |  |  | PROJECT SALARY LABOUR | NOV. PROJECT LABOUR SALARY
 |  |  |  |  | PROJECT SALARY LABOUR | OCT. [NAME] SALARY
 |  |  |  |  | PROJECT SALARY LABOUR | PROJECT SALARIES - PROJECT LABOUR SALARY
 |  |  |  |  | PROJECT SALARY LABOUR | SEP. PROJECT LABOUR SALARY
 |  |  |  |  | TRAVELING LABOUR | PROJECT SALARIES - LABOUR TRAVALING
 |  |  |  |  | AUTOMATED SLIDING GLASS DOOR | HOLE CHARGES
Spreadsheet: 3dc79cd0-fb6c-49d3-80c2-7f07c2e5e106
Sheet: Sheet1

Selected financial ratios - OTPF13VI | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Ratios are based on data submitted by the company
 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
Equity ratio | 8.52 | 8 | 8.44 | 7.930393690578672 | 7.18 | 6.47 | 6.19
Return on assets (ROA) | 0.28 | 0.23 | 0.23 | 0.22 | 0.12 | 0.09024630060148411 | 0.05
Return on equity (ROE) | 0.03034451184090499 | 0.02 | 0.02 | 0.02 | 0.01 | 0.01 | 0
The information provided herein is for information purposes only and contains data submitted or uploaded by issuers. Data presented herein may be modified based on base period data in subsequent financial reports. The Budapest Stock Exchange Ltd. makes no representation or warranty as to the accuracy, completeness or authenticity of the data. For detailed terms of use, principles of data protection and liability provisions please refer to the relevant legal disclaimer. For further information please consult the relevant financial statements disclosed by the issuer.
Spreadsheet: 86420d1286396204-vlookup-not-working-sample_currency
Sheet: Sheet2

Year | Month | Currency | Value | Rate
2008 | Jan | GBP | Jan 2008 GBP | 1
2008 | Feb | GBP | Feb 2008 GBP | 2
2008 | Mar | GBP | Mar 2008 GBP | 1
2008 | Apr | GBP | Apr 2008 GBP | 2
2008 | May | GBP | May 2008 GBP | 2
2008 | Jun | GBP | Jun 2008 GBP | 1
2008 | Jul | GBP | Jul 2008 GBP | 2
2008 | Aug | GBP | Aug 2008 GBP | 1
2008 | Sep | GBP | Sep 2008 GBP | 1
2008 | Oct | GBP | Oct 2008 GBP | 2
2008 | Nov | GBP | Nov 2008 GBP | 2
2008 | Dec | GBP | Dec 2008 GBP | 1
2008 | Jan | GBP | Jan 2008 GBP | 1
2008 | Feb | GBP | Feb 2008 GBP | 1
2008 | Mar | GBP | Mar 2008 GBP | 2
2008 | Apr | GBP | Apr 2008 GBP | 2
2008 | May | GBP | May 2008 GBP | 1
2008 | Jun | GBP | Jun 2008 GBP | 2
2008 | Jul | GBP | Jul 2008 GBP | 2
2008 | Aug | GBP | Aug 2008 GBP | 3
2008 | Sep | GBP | Sep 2008 GBP | 1
2008 | Oct | GBP | Oct 2008 GBP | 3
2008 | Nov | GBP | Nov 2008 GBP | 32
2008 | Dec | GBP | Dec 2008 GBP | 4
2008 | Jan | GBP | Jan 2008 GBP | 2
2008 | Feb | GBP | Feb 2008 GBP | 1
Spreadsheet: 159788d1338843035-excel-2007-i-need-a-formula-to-calculate-six-months-at-a-time-from-separate-sheet-tabs-hr-calendar-with-formulas
Sheet: Aug

 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY |  | 1. Absent - EX  2. Absent - UN  3. Bereavement  4. Discipline  5. FMLA  6. Tardy
 |  |  | NOTES:
 |  |  | Type in Employee's Last Name and the Corresponding Number
Spreadsheet: 60014d1260534941-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-new-budget-planner1
Sheet: Data Input

 | Home Accounting |  |  |  |  |  |  |  | January | 2008 |  |  | 4
 | Monthly Data Input Sheet |  |  |  |  |  |  |  | February | 2009
 |  |  |  |  |  |  |  |  | March | 2010
 |  |  |  |  |  |  |  |  | April | 2011
 | Month |  | December |  |  | Month and year selected from list |  |  | May | 2012
 |  |  |  |  |  |  |  |  | June | 2013
 | Year |  | 2008 |  |  |  |  |  | July | 2014 |  |  | 8
 |  |  |  |  |  |  |  |  | August | 2015
 |  |  |  |  |  |  |  |  | September
 |  |  | Month Amount |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  | November
 | Mortgage | 3 | 1 | 10 |  | I would like to be able to input my data here for the relevent month and year selected then send it to the relevent sheet |  |  | December
 |  | 4 |  | 10
 | [NAME] | 5 | 2 | 10 |  | putting the data into the corresponding cell for the month and year.
 |  | 6 |  | 10
 | Home Ins | 7 | 3 | 10
 |  | 8 |  | 10
 | Council Tax | 9 | 4 | 10
 |  | 10 |  | 10
 | United Utilities (Water) | 11 | 5 | 10
 |  | 12 |  | 10
 | EDF Energy | 13 | 6 | 10
 |  | 14 |  | 10
 | TV Licence | 15 | 7 | 10
 |  | 16 |  | 10
 | Virgin | 17 | 8 | 10
 |  | 18 |  | 10
 | O2 Simons Mobile | 19 | 9 | 10
 |  | 20 |  | 10
 | Orange [NAME] | 21 | 10 | 10
 |  | 22 |  | 10
 | Unemployment Ins | 23 | 11 | 10
 |  | 24 |  | 10
 | Wedding Ring Si | 25 | 12 | 10
 |  |  |  | 10
 | Marmy Ins |  | 13 | 10
 |  |  |  | 10
 | Next Catalogue |  | 14
 | Next Funature |  | 15
 | Si Car Ins |  | 16
 | [NAME] |  | 17
 | Credit Card |  | 18
 | [NAME] |  | 20
 |  |  | 20
 | [NAME] |  | 21
 | Wages Lisa |  | 22
 | Other Income |  | 23
Spreadsheet: 108641d1305663518-finding-a-match-in-a-list-sample
Sheet: Sheet2

Numbers | details (not important)
33
81
95
116
332
379
449
472
489
494
742
808
848
914
1015
1043
1062
1067
1068
1083
1114
1135
1267
1281
1284
1302
1325
1341
1346
1360
1376
1493
1495
1784
2128
3073
3440
3910
4026
4929
5165
5466
5518
5980
6297
6734
6784
6794
7108
7215
7454
7505
7519
7719
7723
7781
8820
8865
8906
9501
9574
9628
9710
11914
12027
12045
12380
12551
13017
13066
13089
13219
13300
13347
13412
13806
13836
13975
13977
14129
16128
16418
16691
16940
17132
17366
17671
18570
18571
18869
19192
19220
19386
19460
19688
19831
19950
20339
20715
20763
20855
20856
21152
21186
21197
21312
21421
21541
21616
21617
21622
21623
21907
22006
22215
22218
22219
22554
22690
22803
23137
23138
23384
23495
23507
23513
23517
23546
23597
23598
23630
23688
23706
23707
23741
23828
23859
23890
23904
23956
23962
23969
24024
24049
24148
24184
24230
24262
24270
24296
24388
24398
24449
24464
24476
24538
24547
24567
24593
24601
24652
24712
24761
24792
24867
24929
24937
25007
25020
25027
25064
25070
25085
25164
25186
25213
25312
25346
25395
25398
25407
25421
25426
25440
25460
25502
25529
25598
25607
25641
25656
25667
25796
25811
25834
25840
25849
25912
25937
25953
25984
25991
26078
26115
26130
26152
26173
26205
26291
26341
26342
26401
26449
26451
26452
26457
26463
26500
26526
26530
26571
26575
26648
26669
26716
27053
28272
28603
28727
29367
29385
29710
29715
29716
30169
30468
30619
31417
32589
33720
34759
35197
35428
35652
35921
36043
37004
37087
37579
37938
37967
38023
38249
39022
40060
40470
41877
42680
43089
43640
43690
43729
43880
45059
45259
45561
45681
45702
45851
46211
46301
Spreadsheet: 833635d1687160668-using-mod-and-if-to-find-cell-value-vs-reference-and-show-if-divisible-but-i-have-an-issue-copy-of-fvf-weight-tracker-2023-1-test
Sheet: Data Sheet

Week Date | 2023-06-18 00:00:00
 |  |  |  |  | Current |  |  |  | Peak | Additional Goals Entry
Name | Team | Starting Weight | Starting Height | Starting BMI | Weekly Result (+/-) | Weekly BMI | Overall (+/-) | Overall %age Lost | Peak %age Lost | Hat-Trick | Tracked Food? | POTW | Milestone Hit? | [NAME] (1st week)? | [NAME]? | Lost Weight? | Individual Goals For/Against | 2023-05-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | POTW awarded | (enter Y if Peak passes 5/10/15% on weigh in) | Between 18.5 and 24.9 |  |  |  | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg)
[NAME] | White | 129 | 180 |  |  |  |  |  |  |  | Y |  |  |  |  |  |  | 130 | 130 | 130 | 129.2 | 127.9 | 127.2
Spreadsheet: 78189d1278592522-lookup-function-help
Sheet: Sheet1

Basis | Cost | Year | Price |  |  |  | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
Right | 50 | 2000 | 50 |  |  | Percent% | 0.6 | 0.23 | 0.5 | 0.65 | 0.26 | 0.4 | 0.5 | 0.32 | 0.67 | 0.9 | 0.82
Left | 50.92 | 2008 | 76
Right |  | 2003 | 203
Right |  | 2002 | 69
Left |  | 2001 | 24
Right |  | 2010 | 108
Left |  | 2009 | 43
Left |  | 2007 | 76
Right |  | 2006 | 83
 |  | If Basis is 'Right' Display Price. If Basis is 'Left'  Look up the year and calc 'Price' x 'Percent%'
 |  | First two answers should be: