tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 783082d1654566922-need-adjacent-cell-data-from-max-value-cell-address-adjacent-cell-data
Sheet: Sheet1

Project Name | Test A1 Date | Test A1 Outcome | Test A2 Date | Test A2 Outcome | Test B1 Date | Test B1 Outcome | Test B2 Focus Group Date | Test B2 Trial Date | Test B2 Date | Test B2 Outcome | Max Test Date | [NAME]
A | 2022-01-01 00:00:00 | Success |  |  | 2022-01-15 00:00:00 | Success
B | 2022-01-02 00:00:00 | Failure | 2022-02-02 00:00:00 | Failure
C | 2022-01-01 00:00:00 | Failure | 2022-02-01 00:00:00 | Success | 2022-02-15 00:00:00 | Failure | 2022-02-18 00:00:00 | 2022-03-01 00:00:00 | 2022-03-15 00:00:00 | Success
D | 2022-01-01 00:00:00 | Success |  |  | 2022-01-15 00:00:00 | Failure | 2022-01-18 00:00:00 | 2022-02-01 00:00:00 | 2022-02-15 00:00:00
Spreadsheet: 769467d1645548995-populate-an-excel-calendar-with-information-from-sheet-in-same-workbook-opi-job-track-worksheet
Sheet: Job Track

Job Track
 |  |  |  |  |  |  | Belle |  |  |  |  | Refurb |  |  |  |  |  |  |  | Main Warehouse
 | Job # | Job Name | SP | Due Date |  |  | Pulled | Staged | Transferred | [NAME] |  | Fabric Received | Worksurface Received | Pedestals Received | Top Caps Received | Painted | Assembled | [NAME] |  | Pulled | Staged | Transferred | [NAME] |  | Invoice #
 |  |  |  |  |  |  | Yes | N/A | Yes |  |  | Yes | Yes | No | No
 |  |  |  |  |  |  | Yes | Yes | N/A | No
Spreadsheet: 268810d1380832724-sumproduct-formula-working-on-all-but-one-worksheet-2012-inpt-mb
Sheet: Mar

March |  |  |  |  |  |  | 3
Expenses | Total Expenses HTG | Total Expenses USD | Inpatient Total HTG | Inpatient Total USD | Outpatient Total HTG | Outpatient Total USD
bongu/juice
formula
patient food
medical supplies
medical services
medication
x-ray
office supplies
photocopy
other transportation
outpatient nurse for injections
employee compensation
school
other expenses
phone list
physical phone
telephone minutes
oxygen
volunteer expenses
patient transportation
Spreadsheet: 6386dd9b-5ab0-40e1-9fee-556cd0d64b52
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2012
 |  | Data Extracted on: May 22, 2013 (5:59 am)
Period | Value
Q1-2003 | X
Q2-2003 | X
Q3-2003 | X
Q4-2003 | 229371
Q1-2004 | 229175
Q2-2004 | 233474
Q3-2004 | 235336
Q4-2004 | 238105
Q1-2005 | 241837
Q2-2005 | 244380
Q3-2005 | 247183
Q4-2005 | 247443
Q1-2006 | 250954
Q2-2006 | 254990
Q3-2006 | 258328
Q4-2006 | 262731
Q1-2007 | 263776
Q2-2007 | 266272
Q3-2007 | 270025
Q4-2007 | 272054
Q1-2008 | 276013
Q2-2008 | 278199
Q3-2008 | 280692
Q4-2008 | 273583
Q1-2009 | 267567
Q2-2009 | 267416
Q3-2009 | 268461
Q4-2009 | 271132
Q1-2010 | 273221
Q2-2010 | 275247
Q3-2010 | 279408
Q4-2010 | 281844
Q1-2011 | 284136
Q2-2011 | 290132
Q3-2011 | 292370
Q4-2011 | 293684
Q1-2012 | 296657
Q2-2012 | 298058
Q3-2012 | 300019
Q4-2012 | 309655
Spreadsheet: kay_mann__19201__ABB - New Option Allocation
Sheet: Summary By Unit

ABB Transformers
 |  | Guaranteed Unit | Contract | Option | Progress |  | Progress | Total
Unit/ABB Item # | Project Designation | Delivery Date | Purchase Price | Premium Paid | Pymts. Made | Retainage | Pymts. Due | Purchase Price
lNL 9521-1 | [NAME] | 2000-10-20 00:00:00 | 562300 | 440000 |  |  | SOLD
LNL 9521-2 | [NAME] | 2000-10-20 00:00:00 | 562300 |  |  |  | SOLD
LNL 9517-1 | PSCO | 2000-12-01 00:00:00 | 786000
LNL 9517-2 | PSCO | 2000-11-17 00:00:00 | 786000
LNL 9517-3 | PSCO | 2000-12-01 00:00:00 | 786000
LNL 9517-4 | Coral | 2000-11-17 00:00:00 | 786000
LNL 9517-5 | ESA | 2000-12-15 00:00:00 | 786000 |  |  | N/A
LNL 9517-6 | ESA | 2000-12-15 00:00:00 | 786000 |  |  | N/A
LNL 9518-1 | [NAME] | 2001-08-01 00:00:00 | 782000
LNL 9518-2 | [NAME] | 2001-08-01 00:00:00 | 782000
Total
Progress Payments Due
Less Discount |  | -30000
Progress Payments Due
Less Retainage |  |  | Excludes ESA transformers
Total Amount Due
1 The two units designated for ESA have been cancelled -- the progress payments due for these units are cancellation charges.
2 Retainage amount per section 6.1.3 of the Agreement.
Spreadsheet: 784451d1655738730-dynamic-array-formula-to-count-same-date-customer-for-specific-part-numbers-arrayformulamultiplepartnosamedaycustomer
Sheet: Data

Date | Customer Number | Customer Name | Order Number | Part Number | CLF-Amt Paid To Prov | [NAME] | Codes
2021-01-01 00:00:00 | 1111111A | Smith, [NAME] | 987635672 | G2023 | 99
2021-01-01 00:00:00 | 1111111A | Smith, [NAME] | 987635672 | 99213 | 88
2021-01-01 00:00:00 | 1111111A | Smith, [NAME] | 987635672 | 99203 | 67
2021-02-01 00:00:00 | 2222222A | Doe, [NAME] | 344545665 | 99213 | 88
2021-02-01 00:00:00 | 2222222A | Doe, [NAME] | 344545665 | 98745 | 88
2021-03-01 00:00:00 | 3333333A | Jones, [NAME] | 124907567 | G2023 | 98
2021-03-01 00:00:00 | 3333333A | Jones, [NAME] | 124907567 | 99213 | 88
2021-03-01 00:00:00 | 3333333A | Jones, [NAME] | 124907567 | 99203 | 0
2021-04-01 00:00:00 | 1111111A | Smith, [NAME] | 567894346 | 99213 | 78
2021-05-01 00:00:00 | 3333333A | Jones, [NAME] | 124907567 | 99214 | 110
 |  |  |  |  |  | *Cell [NAME] should be 0, not 1, since it does not contain any of the three part numbers
Spreadsheet: 171729d1343837117-totals-in-pivot-table-ot-example-aug-1
Sheet: Sheet1

 |  | PP1 | PP2 | PP3 | Total
[NAME] | OT | 1 |  | 3
 | REG | 8 | 8 | 8
[NAME] | OT |  | 5 | 8
 | REG | 8 | 8 | 8
Spreadsheet: 8a0da054-007b-4706-9dac-f9fc437003ee
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
 | Parecer da Associação/Agência
 | Processo nº |  |  |  |  | Área Geogràfica do Concelho de :
 | Data de entrada : |  |  |  |  |  |  | Data de recepção últimos doc.:
 | Entidade receptora : |  |  |  |  |  |  | Financiamento:
 | Promotor : |  |  |  |  |  |  |  |  |  | NIPC:
 | Actividade : |  |  |  |  |  |  |  |  | CAE:
 | Investimento total previsto : |  |  |  |  |  |  |  |  |  |  |  |  | Emprego total antes e depois do projecto : | 0 | >
 | Comentários
 | Síntese do parecer |  |  |  |  |  |  |  |  |  |  | <<< Indicar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Não
 | Enquadramento do pedido nos objectivos, âmbito e actividades abrangidas
 | [NAME] a sua situação económico-financeira equilibrada e/ou financiarem o projecto adequadamente
 | com capitais próprios.
 | [NAME] constituídas e registadas [NAME] legislação em vigor ou comprometerem-se a cumprir este requisito até à data de assinatura do contrato de financiamento
 | Disporem ou passarem a dispor de contabilidade [NAME] com o POC
 | Comprometerem-se a manter afecto à respectiva actividade o investimento a realizar, bem como a manter a localização geográfica no concelho, [NAME] período do contrato de financiamento
 | [NAME] o investimento objecto de financiamento [NAME] no concelho de
 | Não [NAME] o investimento [NAME] dias antes de apresentação do pedido de financiamento [NAME]
 | [NAME] características inovadoras ou de certa forma diferenciadoras face às empresas intaladas no concelho ou na região.
 | Data do parecer
 | O Técnico
Spreadsheet: 754800d1636506930-searching-a-value-different-tabs-using-some-conditionals-planilha-de-transporte-2022-1-
Sheet: CALCULO GERAL

 |  | VALOR PROCURADO | SEARCHED VALUE
 |  | CONDICIONAIS | CONDITIONALS
 |  | LOCAL | VEÍCULO
ORIGIN | SAÍDA | SP | VUK (4,8m)
ARRIVE | CHEGADA | SOROCABA - SP
 |  | DATA |  | O USUÁRIO VAI SELECIONAR 03 OPÇÕES (TIPO DE VEÍCULO / FILIAL DE ORIGEM / DESTINO) E INFORMAR AS DATAS
CHARGE | CARGA | 2021-12-05 00:00:00 |  | THE USER WILL SELECT 03 OPTIONS (TYPE OF VEHICLE - TRUCK / BRANCH ORIGIN / DESTINY ) AND INFORM DATES
DISCHARGE | DESCARGA | 2021-12-05 00:00:00 |  | A CONDICIONAL DA DATA SÓ VAI DEFINIR A QUANTIDADE DE VIAGENS QUE SERÃO REALIZADAS
 |  |  |  | SE FOR NO MESMO DIA VAI CONSIDERAR 2 PERNAS E SE NÃO FOR VAI CONSIDERAR 4 PERNAS (NOMENCLATURA PARA CADA VIAGEM DO CAMINHÃO)
 |  |  |  | THE CONDITIONAL DATE WILL DEFINY ONLY THE QUANTITY OF TRAVELS THAT WILL BE MAKED
 |  |  |  | IF IT'S ON THE SAME DAY, WILL CONSIDER 2 LEGS AND IF DON'T, IT WILL CONSIDER 4 LEGS (LEGS IS THE NOMENCLATURE TO EACH TRAVEL OF THE TRUCK)
COST | CUSTO |  | O VALOR SERÁ BUSCADO [NAME] O LOCAL DE SAÍDA FOR SP, O VALOR SERÁ PUXADO DA ABA SP LEVANDO EM CONTA A INFORMAÇÃO DE DATA, SE FOREM DIFERENTES PUXA UM VALOR, SE IGUAIS PUXAM OUTRO
SELL | VENDA |  | [NAME] O VALOR COM A MARGEM DE LUCRO JÁ EMBUTIDA
 |  |  | THE VALUE WILL BE SEARCHED IN THE CORRESPONDENT TABS - IF THE LOCAL OF ORIGIN IS SP, THE VALUE WILL BE PULLED OUT FROM THE TAB SP, CONSIDERING THE INFORMATION OF DATE, IF THEY ARE DIFFERENT, PULLS A VALUE, IF EQUAL, PULLS ANOTHER
 |  |  | HERE WE'LL PRESENT THE VALUE WITH THE PROFIT MARGE ALREADY INSERT
 |  |  | <-- | Teste a nova fórmula
Spreadsheet: 882926d1731403904-adjust-requirement-so-that-total-order-volume-isnt-exceeded-fruit2
Sheet: Original

 | Split | Order Quantity | Sent | Stock incoming | Oustanding | Diff. calc. | Outstanding new
Fruit |  | 482
Apple | 0.21 | 99 | 99 | 1
Pear | 0.26 | 131 | 151 | 1
Orange | 0.18 | 85 | 30 | 8
[NAME] | 0.1 | 46 | 21 | 2
Grapefruit | 0.16 | 78 | 64 | 14
[NAME] | 0.09 | 43 | 6 | 5
Spreadsheet: 68017d1268554595-excel-2007-different-calculation-depending-on-cell-entry-testantonia
Sheet: Sheet1

Here's what I would like to happen, but all in two cells--                                                                   1 cell to enter the number, the other cell that shows the results
Changing Cell | Results Cell
If the Cell that changes (above for example) has the number… | The Cell that calculates and displays the result (above for example) should have...
1
2
3
4
5
6
7
8 |  | To expand the formula, just copy from cell B12 to all other cells ...
9
10
11
12
Spreadsheet: 93321d1292919942-excel-formulas-arent-calculating-correctly-balance
Sheet: Sheet1

Debit Date | Nippu | Description | Amount | Account Transfer | ATM | Interest | Misc. 1 | Misc. 2 | Balance
2010-05-05 00:00:00 | 1 | BALANCE |  |  |  |  |  |  | 500
2010-05-05 00:00:00 | 1 | Bus to city centre | 9.1 |  |  |  |  |  | #N/A
2010-05-05 00:00:00 | 1 | Dinner | 9.1 |  |  |  |  |  | #N/A
2010-05-06 00:00:00 | 1 | new tie | 0.8 |  |  |  |  |  | #N/A
2010-05-06 00:00:00 | 999 | GSM | 5 |  |  |  |  |  | #N/A
2010-05-06 00:00:00 |  | Coffee | 20 |  |  |  |  |  | #N/A
2010-05-08 00:00:00 |  | Flowers for Mom | 5 |  |  |  |  |  | #N/A
2010-05-08 00:00:00 |  | [NAME] | 0.8 |  |  |  |  |  | #N/A
2010-05-08 00:00:00 |  | Candy | 2.5 |  |  |  |  |  | #N/A
2010-12-17 00:00:00 | 25 | [NAME] | 10 |  |  |  |  |  | #N/A
2010-12-17 00:00:00 | 25 | [NAME] | 2 |  |  |  |  |  | #N/A
2010-12-18 00:00:00 | 25 | Bus to city centre | 2.9 |  |  |  |  |  | #N/A
Spreadsheet: 786813d1657464282-sum-values-with-multiple-columns-book1_pivot
Sheet: Sheet2

Column1 | PO1 | PO2 | PO3 | PO4 | PO5 | PO6 | PO7 | PO8
Name A | 19 | 2 | 0 | 3 | 0 | 5 | 3 | 0
Name B | 31 | 4 | 4 | 6 | 1 | 4 | 3 | 7
Name C | 33 | 4 | 3 | 7 | 0 | 3 | 0 | 2
Name D | 28 | 0 | 5 | 4 | 1 | 4 | 1 | 6
Name E | 3 | 6 | 7 | 4 | 2 | 1 | 4 | 5
Name F | 17 | 0 | 7 | 3 | 3 | 1 | 2 | 7
Name G | 6 | 2 | 0 | 6 | 1 | 1 | 2 | 1
Name H | 37 | 6 | 2 | 2 | 2 | 3 | 2 | 3
Name I | 41 | 9 | 5 | 7 | 3 | 5 | 3 | 6
Name J | 23 | 10 | 4 | 3 | 1 | 1 | 2 | 10
Name K | 14 | 0 | 3 | 4 | 3 | 2 | 5 | 9
Name L | 7 | 9 | 0 | 4 | 1 | 1 | 4 | 6
Name M | 3 | 2 | 0 | 7 | 0 | 5 | 3 | 8
Name N | 5 | 6 | 3 | 8 | 0 | 5 | 0 | 2
Spreadsheet: phillip_m_love__30140__200005_OA
Sheet: BGC-EGM-VAR

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - VARIANCE
COMPANY:  ECTR (EGM)
REGION: BOSTON GAS
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 99100d1297859118-linking-or-grabbing-data-from-400-workbooks-final
Sheet: Sheet1

Office | TO / FROM | P01 | P02 |  | << please note that column A will have around 400 branches therefore totalling 8000 rows (I have shortened it for this example)
Branch1
Branch1
Branch1
Branch1
Branch1
Branch1
Branch1
Branch1
Branch1
Branch1
Branch1
Branch1
Branch1
Branch1
Branch1
Branch1
Branch1
Branch1
Branch1
Branch1
Branch2
Branch2
Branch2
Branch2
Branch2
Branch2
Branch2
Branch2
Branch2
Branch2
Branch2
Branch2
Branch2
Branch2
Branch2
Branch2
Branch2
Branch2
Branch2
Branch2
Branch3
Branch3
Branch3
Branch3
Branch3
Branch3
Branch3
Branch3
Branch3
Branch3
Branch3
Branch3
Branch3
Branch3
Branch3
Branch3
Branch3
Branch3
Branch3
Branch3
Branch4
Branch4
Branch4
Branch4
Branch4
Branch4
Branch4
Branch4
Branch4
Branch4
Branch4
Branch4
Branch4
Branch4
Branch4
Branch4
Branch4
Branch4
Branch4
Branch4
Branch5
Branch5
Branch5
Branch5
Branch5
Branch5
Branch5
Branch5
Branch5
Branch5
Branch5
Branch5
Branch5
Branch5
Branch5
Branch5
Branch5
Branch5
Branch5
Branch5
Spreadsheet: 0204c9e8-701a-4c48-9076-1f13934e4c88
Sheet: Sheet1

Job by tiers | 2006 | 2005 | 2004 | 2003 | 2002
Editor | 129919 | 123196 | 125343 | 124484 | 105485
Copy Editor I | 31464 | 30923 | 30760 | 30615 | 29490
Copy Editor II | 38480 | 37737 | 36935 | 38821 | 37983
Copy Editor III | 45947 | 45256 | 44564
Reporter I | 29262 | 28366 | 28162 | 27106 | 25723
Reporter II | 34669 | 34069 | 33728 | 32645 | 31555
Reporter III | 44083 | 43477 | 43292 | 42881 | 41996
[NAME] I | 27460 | 26060 | 26798
Graphic Artist II | 31802 | 30802 | 30980 | 29264 | 29988
Graphic Artist III | 37425 | 37371 | 36732
Photographer I | 30543 | 29230 | 29170
Photographer II | 36184 | 36192 | 35839 | 33700 | 32203
Photographer III | 45201 | 44151 | 43418
** Total Direct Averages Given (includes base pay plus incentives)
*** For 2003 and 2002 the Photographer and Graphic Artist positions did not have tiers.
**** For 2003 and 2002 the Copy Editor position only had 2 tiers.
Spreadsheet: 38531d1236693696-summarizing-data-over-several-sheets-bolts-list
Sheet: BoltsP2

 | BOLTS LIST | BOLTS LIST
CLIENT |  | 0 |  |  |  | JOB No. |  | A
PLANT |  | 0 |  |  |  |  | LIST No.  2   of  3
 |  | ALL BOLTS GRADE 8.8 ZINC PLATED |  | BOLTS |  | NUTS |  | WASHERS
ITEM | GRIP | [NAME] OF JOINT | QTY | DIA | LGTH | NYLCK | HEX | FORM C | SPRING
20 | 6 |  | 10 | M12 | 25
21 | 14 |  | 12 | M12 | 35
22 | 18 |  | 14 | M12 | 40
23 | 18 |  | 16 | M12 | 40
24 | 24 |  | 18 | M12 | 45
25 | 36 |  | 20 | M12 | 55
26 | 12 |  | 2 | M12 | 35
27 | 8 |  | 4 | M12 | 30
28 | 16 |  | 6 | M12 | 35
29 | 10 |  | 8 | M12 | 30
30 | 8 |  | 10 | M12 | 30
31 | 16 |  | 8 | M12 | 35
32 |  |  |  |  | #N/A
33 |  |  |  |  | #N/A
34 |  |  |  |  | #N/A
35 |  |  |  |  | #N/A
36 |  |  |  |  | #N/A
37 |  |  |  |  | #N/A
38 |  |  |  |  | #N/A
Spreadsheet: 826536d1682072623-if-function-not-working-if_function-aligw
Sheet: Sheet1

A | Complete | Admitted | Admitted | Yes | Yes
B | Complete | Denied | Applied | Yes | No |  |  |  | Conditions is : if B1=Complete, C1 OR D1=Admitted, E1=Yes OR F1=Yes then [NAME] should equal to ACCEPT If any of them are not true, it should say NOT ACCEPTED.
C | Complete | Applied | Admitted | No | Yes
D | Complete | Admitted | Admitted | Yes | No
E | Complete | Admiited | Admitted | Yes | Yes
Spreadsheet: gerald_nemec__11456__P&SAug3PPANB
Sheet: Sheet1

Estimated Purchase Price Adjustment (1)
Income
Operating Revenues (July & August) | -1147268.93
Operating Costs (July & August) | 1025804.72
Estimated September margin | -100000
 |  | -221464.21
Investments
Cash of Advanced to Bighorn | 150000
Received Cash from Fort Union | -850582
Lost Creek Gathering Funding | 17500
 |  | -683082
Capital Expenditures
July & August | 3768345.93
Estimated September | 900000
 |  | 4668345.93
Advances Quantam & Shapphire |  | 102819.24
Gathering Fee due Enron (Excess only, per S. Sitter)
July & August |  | 868000
Denver office costs due Enron
July & August | 235924.56
Estimated September | 120000
 |  | 355924.56
 |  | 5090543.52
Total Estimate |  | 5090000
(1)  All amounts shown are subject to true-up.
Spreadsheet: 859334d1707750732-move-data-on-a-specific-date-example-sheet
Sheet: work out

 |  | GROSS | GROSS | [NAME] | ***Last Week's GROSS*** | **Last Week's Movement** |  | This week's movement |  | No of |  | Reserved amount |  | ***Last Week's Seats*** |  | Seat Movement
 |  |  | TO COPY |  | Remember to change |  |  |  |  | [NAME]
 |  |  |  |  | this every week!!! |  |  |  |  |  |  |  |  | Remember to change
 |  |  |  |  |  |  |  |  |  |  |  |  |  | this every week!!!
venue
 |  | 130 |  | 75 | 14 | 15 |  |  |  | 0 |  | 0 | Gross | 29404
 |  |  |  |  |  |  |  |  |  |  |  |  | Net
 |  | 0 |  | 0 | 0 |  |  |  |  | 0 |  | 0 | Gross | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Net
 |  | 0 |  | 0 | 0 |  |  |  |  | 0 |  | 0 | Gross | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Net
venue
 |  | 450 |  | 65 | 325 | 75 |  |  |  | 0 |  | 0 | Gross | 24679
 |  |  |  |  |  |  |  |  |  |  |  |  | Net
venue
 |  | 56 |  | 100 | 48 | 2 |  |  |  | 0 |  | 0 | Gross | 22916
 |  |  |  |  |  |  |  |  |  |  |  |  | Net
venue
 |  | 4509 |  | 35 | 4123 | 256 |  |  |  | 0 |  | 0 | Gross | 13640
 |  |  |  |  |  |  |  |  |  |  |  |  | Net
venue
 |  | 6475 |  | 141 | 5891 | 456 |  |  |  | 0 |  | 0 | Gross | 14151
 |  |  |  |  |  |  |  |  |  |  |  |  | Net
Spreadsheet: 877561d1724355974-make-a-top-list-from-four-different-groups-toplist-from-four-table-into-one
Sheet: Blad1

Tool | 2024 | 2023 | 2022 | 2021 |  |  | Tool | 2024 | 2023 | 2022 | 2021 |  |  | Tool | 2024 | 2023 | 2022 | 2021
A1 | 200 | 130 | 80 | 70 |  |  | C1 | 1000 | 1500 | 390 | 2000 |  |  | D2 | 400 | 350 | 300 | 250
A2 | 145 | 129 | 320 | 46 |  |  | C2 | 450 | 400 | 560 | 2300 |  |  | C4 | 350 | 300 | 250 | 200
A3 | 151 | 87 | 68 | 56 |  |  | [NAME] | 400 | 567 | 2345 | 567 |  |  | A3 | 151 | 87 | 68 | 56
A4 | 70 | 789 | 234 | 56 |  |  | C4 | 350 | 300 | 250 | 200 |  |  | B3 | 150 | 134 | 78 | 45
A5 | 60 | 90 | 456 | 123 |  |  | C5 | 300 | 301 | 453 | 27 |  |  | D7 | 125 | 40 | 30 | 29
A6 | 50 | 23 | 12 | 9 |  |  | C6 | 250 | 251 | 245 | 23 |  |  | B7 | 100 | 89 | 39 | 29
A7 | 40 | 38 | 36 | 6 |  |  | C7 | 239 | 245 | 128 | 231 |  |  | A6 | 50 | 23 | 12 | 9
.. |  |  |  |  |  |  | .. |  |  |  |  |  |  | D25 | 49 | 48 | 26 | 6
A25 | 10 | 8 | 6 | 4 |  |  | C25 | 46 | 245 | 128 | 345 |  |  | A7 | 40 | 38 | 36 | 6
Tool | 2024 | 2023 | 2022 | 2021 |  |  | Tool | 2024 | 2023 | 2022 | 2021
B1 | 345 | 200 | 560 | 46 |  |  | D1 | 2300 | 3000 | 1200 | 234 |  |  | The result that I wish to present up to 10 tools if so many
B2 | 200 | 234 | 23 | 69 |  |  | D2 | 400 | 350 | 300 | 250
B3 | 150 | 134 | 78 | 45 |  |  | D3 | 345 | 234 | 389 | 23 |  |  | The highest sold tool in this year in total of all all group
B4 | 145 | 345 | 34 | 234 |  |  | D4 | 300 |  |  |  |  |  | with an increase every year since last four years
B5 | 140 | 234 | 567 | 765 |  |  | D5 | 200 |  |  |  |  |  | List highest number and then in decreasing numbers
B6 | 110 | 435 | 784 | 34 |  |  | D6 | 150 |  |  |  |  |  | that are in present year
B7 | 100 | 89 | 39 | 29 |  |  | D7 | 125 | 40 | 30 | 29 |  |  | I want it to be easy that it follow for years to come without a need of giving
.. |  |  |  |  |  |  | .. |  |  |  |  |  |  | which years it is now like (YEAR TODAY)
B25 |  |  |  |  |  |  | D25 | 49 | 48 | 26 | 6
Spreadsheet: 348870d1412127034-conditional-formatting-for-renewing-customers-example
Sheet: Sheet1

 | Customer | Year | Claim
 | A | 1 | 1
 | A | 2 | 1
 | B | 1 | 2
 | B | 2 | 0
 | B | 3 | 1
Spreadsheet: 792587d1660992408-retrieving-data-from-a-table-based-on-two-drop-down-box-values-sample1-1
Sheet: Department Report

1969
 |  |  | Department Costing Report
 |  | Supplier | Marketing |  | Month 1 | June
 |  |  |  |  | Month 2 | July
 |  | Total Spent inc. VAT
 |  | Total Spent ex. VAT
 |  | Total VAT
 |  |  |  |  | Difference +/-
 |  | Supplier Expenditure With Chosen Department
 |  |  | Total Inc. VAT |  |  | Difference +/-
 |  | All Suppliers
 |  | [NAME]
 |  | AJet
 |  | Amazon
 |  | Arboritom
 |  | Arleigh
 |  | Asgard
 |  | AvantiGas
 |  | Buildbase
 |  | Calor
 |  | [NAME]
 |  | Coast & County Ltd
 |  | Creative Play
 |  | DeeBee
 |  | Eden Farm Hulleys
 |  | EuroCell
 |  | Firestop Services
 |  | Foundations and Buildings
 |  | [NAME]
 |  | [NAME]'s Homeware
 |  | Keycraft
 |  | [NAME]
 |  | [NAME]
 |  | LincsPest Ltd
 |  | Miscellaneous Vendor
 |  | Office Stationary
 |  | S and A Colclough
 |  | Screwfix
 |  | SGS
 |  | Smart Spanner
 |  | SSE
 |  | Tesco
 |  | Veolia
 |  | Victorian Plumbing
 |  | Weldricks Pharmacy
 |  | Welton Aggregate
 |  | Windhager
 |  | Y Pellets
 | ------------------------------------------------------------------------------------------------------------------------------------------------------------
 |  | All Purchase Orders for selected "Month 1"
 |  | PO Number | Date of Purchase | Costing Code | Cost inc. VAT | Total VAT
 |  | All of the above figures are correct as of todays date, providing all Purchase Orders have been input into the [NAME] form.
Spreadsheet: 3e7d8c7d-0de7-4135-a2a7-50173407a2fc
Sheet: Alum Rock

REGIONAL DIRECTORY 2014/2015
[NAME] DISTRICT
Dr. [NAME], [NAME] | [NAME], Director [NAME] and Federal Programs | [NAME], Coordinator State and Federal Programs
2930 Gay Avenue | 2930 Gay Avenue | 2930 Gay Avenue
San Jose,  CA  95127 | San Jose, CA, 95127 | San Jose, CA, 95127
O: [PHONE] | O: [PHONE] | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL] | [EMAIL]
[NAME], Administrative Assistant Supplementary Programs Division of Instructional Services | Efrain Robles, Fiscal Officer | [NAME], Student Information Systems
2930 Gay Avenue | 2930 Gay Avenue | 2930 Gay Avenue
San Jose, CA  95127 | San Jose, CA, 95127 | San Jose, CA 95127
[PHONE] | O: [PHONE] | O: (408) 928-6579
[PHONE] | F: [PHONE] | F: (408) 928-6415
[EMAIL] | [EMAIL] | [EMAIL]
Adriana Magallon, Program Advocate | [NAME], [NAME]
O: [PHONE] | O: [PHONE]/ [PHONE]
C: [PHONE] | C: [PHONE]
[EMAIL] | [EMAIL]
Spreadsheet: d423695f-f78f-4cc9-bc39-9a8092ba1572
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3034 | 16344 | Françoise | Théate | BEL | 119 | 00:45:25 | 00:01:49 | 2:34:55 | 00:01:11 | 1:29:32 | 1 | 4:52:54
3034 | 17436 | [NAME] | Coto | ESP | 120 | 00:52:47 | 00:02:36 | 2:35:52 | 00:00:56 | 1:41:07 | 2 | 5:13:24
3034 | 17869 | [NAME] | Stagg | GBR | 118 | 00:56:59 | [NAME] | 2:25:45 | 00:01:18 | 1:53:39 | 3 | 5:20:28