tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2a7c8b2a-d55e-4b63-aec1-2dce68776de4
Sheet: Variant Impacts Table

The Variant_impacts table
Documentation also available at: http://gemini.readthedocs.org/en/latest/content/database_schema.html#the-variant-impacts-table
COLUMN NAME | COLUMN TYPE | [NAME]
variant_id | INTEGER | PRIMARY_KEY (Foreign key to variants table)
anno_id | INTEGER | PRIMARY_KEY (Based on variant transcripts)
gene | STRING | The gene affected by the variant.
transcript | STRING | The transcript affected by the variant.
is_exonic | BOOL | Does the variant affect an exon for this transcript?
is_coding | BOOL | Does the variant fall in a coding region (excludes 3’ & 5’ UTR’s of exons)?
is_lof | BOOL | Based on the value of the impact col, is the variant [NAME]?
exon | STRING | Exon information for the variants that are exonic
codon_change | STRING | What is the codon change?
aa_change | STRING | What is the amino acid change?
aa_length | STRING | The length of CDS in terms of number of amino acids (only snpEff)
biotype | STRING | The type of transcript (e.g.protein-coding, pseudogene, rRNA etc.) (only snpEff)
impact | STRING | Impacts due to variation (ref.impact category)
impact_severity | STRING | Severity of the impact based on the impact column value (ref.impact category)
polyphen_pred | STRING | Impact of the SNP as given by [NAME] (only VEP)
 |  | (benign, possibly_damaging, probably_damaging, unknown)
polyphen_scores | FLOAT | Polyphen score reflecting severity (higher the impact, higher the score)  (only VEP)
sift_pred | STRING | Impact of the SNP as given by SIFT (only VEP)
 |  | (neutral, deleterious)
sift_scores | FLOAT | SIFT prob. scores reflecting severity (Higher the impact, lower the score) (only VEP)
Spreadsheet: dutch_quigley__9232__AIGCanada
Sheet: Options

 |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | Phy/ | [NAME] | Opt |  | Option | Monthly | Option | Stike | Mid | Mid | Mid | Premium
Counterparty | Deal Num | Pub Code | Fin | Put | Type | Period | [NAME] | Option Qty | Delta | Price | Price | Vol | Value | Value
AIGENETRA | V90941.1 | NXB2 | F | C | EUR | 2001-11-01 00:00:00 | 2001-10-26 00:00:00 | 0 | 0 | 4.75 | 3.041 | 0.5 | 0 | 0
AIGENETRA | V90941.1 | NXB2 | F | C | EUR | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | -500000 | -36.485 | 4.75 | 2.551 | 0.883955 | -3.2805 | 0
AIGENETRA | V90941.1 | NXB2 | F | C | EUR | 2002-01-01 00:00:00 | 2001-12-26 00:00:00 | -500000 | -21240.728 | 4.75 | 2.767 | 0.864235 | -6246.1079 | 0
AIGENETRA | V90941.1 | NXB2 | F | C | EUR | 2002-02-01 00:00:00 | 2002-01-28 00:00:00 | -500000 | -53074.846 | 4.75 | 2.825 | 0.809125 | -22672.6017 | 0
AIGENETRA | V90941.1 | NXB2 | F | C | EUR | 2002-03-01 00:00:00 | 2002-02-25 00:00:00 | -500000 | -61298.4635 | 4.75 | 2.822 | 0.72926 | -28236.2556 | 0
AIGENETRA | V90941.2 | NXB2 | F | P | EUR | 2001-11-01 00:00:00 | 2001-10-26 00:00:00 | 0 | 0 | 4.75 | 3.041 | 0.5 | -854500 | 0
AIGENETRA | V90941.2 | NXB2 | F | P | EUR | 2001-12-01 00:00:00 | 2001-11-27 00:00:00 | -500000 | 499611.7714 | 4.75 | 2.551 | 0.883955 | -1098729.7963 | 0
AIGENETRA | V90941.2 | NXB2 | F | P | EUR | 2002-01-01 00:00:00 | 2001-12-26 00:00:00 | -500000 | 477559.2682 | 4.75 | 2.767 | 0.864235 | -995366.5004 | 0
AIGENETRA | V90941.2 | NXB2 | F | P | EUR | 2002-02-01 00:00:00 | 2002-01-28 00:00:00 | -500000 | 444763.8164 | 4.75 | 2.825 | 0.809125 | -981012.0268 | 0
AIGENETRA | V90941.2 | NXB2 | F | P | EUR | 2002-03-01 00:00:00 | 2002-02-25 00:00:00 | -500000 | 435726.5009 | 4.75 | 2.822 | 0.72926 | -986500.3869 | 0
Spreadsheet: 037ba6c6-f1e2-43c3-8dc1-2c0206f8207a
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 45. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (SA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413770V | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413771W | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413772X | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413773A | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413774C | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413775F | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413776J | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413778L | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413779R | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413780X | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 840594d1692846839-detect-and-remove-outliers-from-dataset-exposure
Sheet: Sheet1

ps_n
0.7 | std
1 | mean |  |  | 0.8457709306622481
0.8 | Min |  |  | 0.2416488373320711
1 | [NAME] |  |  | 0.8457709306622481
0.1 |  |  |  | -1.872778489323549
 | [NAME] | 2.58
Spreadsheet: 04638ce8-6237-4dd5-8332-034122c86e05
Sheet: Sheet1

Unnamed: 0 | GUEST EXPENSE VOUCHER | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  | Date: |  |  | Page: | ______  of | _______
 |  |  |  |  |  |  |  |  |  | [NAME]7/28/05
 | YOU MUST ATTACH THE BA2 FORM TO THIS VOUCHER.
NAME OF EMPLOYEE HOST |  |  |  |  |  |  | EMPLOYEE HOST TITLE
OPERATING UNIT TITLE (COLLEGE OR CENTRAL OFFICE TITLE) |  |  |  |  |  |  | WORK LOCATION
ATTACH AN ITEMIZED RECEIPT FOR EACH ITEM
 | PART 1
 | DATE | TYPE OF EXPENSE |  |  | EXPLANATION |  |  |  |  | AMOUNT
 |  |  |  |  |  |  | TOTAL FOR PART 1
 | PART 2
 | ENTERTAINMENT OF OFFICIAL GUESTS (ATTACH ALL RECEIPTS)
 | DATE AND PURPOSE OF GUEST ENTERTAINMENT
 | NAMES OF [NAME] AND CO-HOSTS |  |  |  |  | NAMES OF OFFICIAL GUESTS
 |  |  |  |  |  |  |  | GRAND TOTAL
EMPLOYEE SIGNATURE |  |  |  |  | DATE
APPROVAL SIGNATURE |  |  |  |  | DATE |  | AUDITOR SIGNATURE AND DATE
Spreadsheet: 274957d1383284440-copy-row-from-one-worksheet-to-another-based-on-cell-value-copy-of-test-data
Sheet: Sheet1

Please Select… | Price | Chassis | Price | [NAME]
> Narrow < |  | > Narrow <
OL10N | 41500 | 4x2_N | 70795 | BetaLip
OL14N | 42000 | 6x2ML_N (22t) | 79095 | BetaPal
OL16N | 42500 | 6x2ML_N | 81695 | Terberg
OL19N | 43500 | 6x2MS_N | 84380 | Zoeller
 |  | 6x2RS_N | 85115 | Otto
OL11N_2.0mPod | 41500 |  |  | Openback
OL11N_3.5mPod | 41500 | > Wide < |  | Pipe Up & Frame Only
OL11N_4.2mPod | 41500 | 4x2_W | 70250
OL14N_2.0mPod | 42000 | 6x2ML_W (23.5t) | 79060
 |  | 6x2ML_W | 80660
> Wide < |  | 6x2MS_W | 84295
OL13W | 40500 | 6x2RS_W | 84295
OL16W | 40500 | 6x4_W | 84025
OL20W | 41750 | 8x4_W | 90000
OL21W | 42000
OL23W | 42500 | >Non-Dennis<
OL27W | 44500 | Mercedes
 |  | Volvo
OL13W+2.5m Pod | 40500 | DAF
OL13W+4.0m Pod | 40500 | Scania
OL13W+5.0m Pod | 40500
OL16W+2.5m Pod | 40500
OL16W+4.0m Pod | 40500
OLTP16 | 67000
OLTP19 | 67000
OLTP22 | 67000
OLTP27 | 70000
One Pass | 67000
None | 0
Spreadsheet: 877432d1724262680-weighted-average-with-two-conditions-weighted-average-with-two-conditions
Sheet: Data

Date | Lot | Weight | %
2024-07-22 00:00:00 | LOT 001 | 150 | 0.653
2024-07-22 00:00:00 | LOT 001 | 167 | 0.655
2024-07-28 00:00:00 | LOT 001 | 189 | 0.634
2024-07-28 00:00:00 | LOT 002 | 290 | 0.582
2024-07-28 00:00:00 | LOT 002 | 500 | 0.573
2024-07-30 00:00:00 | LOT 002 | 766 | 0.612
2024-07-30 00:00:00 | LOT 002 | 467 | 0.664
2024-08-21 00:00:00 | LOT 003 | 536 | 0.623
2024-08-21 00:00:00 | LOT 003 | 288 | 0.62
Spreadsheet: 849204d1699725320-repeat-a-formula-x-times-dynamic-and-automatic-formula-x-times
Sheet: Sheet1

At present the formula in column D needs copying down to each row which isn't helpful because list of 'Names' in column B and C are changing daily.
Is there any way to have a dynamically updating array formula in column D (that doesn't slow down Excel when there are 60k rows)
In my head I feel like I would love a formula to find the last row in column B and then have excel effectively drag down the formula that many times from D6 onwards. (I would want this to be automatic though)
 | Names | Positions | Team Leader - What I Would Like Without Copying Down | [NAME] I Tried but it Doesn't Fill The All Cells Correctly | Helper For Column G | Works but Unefficent When Run Across 60K Rows
 | [NAME] | Leader
 | [NAME] | Member 1 |  | [NAME]
 | [NAME] | Member 2 |  | [NAME]
 | Sandy | Leader |  | Sandy
 | Troy | Leader |  | Troy
 | [NAME] | Member 1 |  | Troy
 | Dwane | Member 2 |  | Troy
 | Shona | Member 3 |  | Troy
 | Toni | Member 4 |  | Troy
 | [NAME] | Leader |  | [NAME]
 | Marvin | Member 1 |  | [NAME]
 | Mark | Leader |  | Mark
 | Joy | Member 1 |  | Mark
 | Winston | Member 2 |  | Mark
 | Bella-Anne | Leader |  | Bella-Anne
Spreadsheet: 781376d1653291376-change-in-lookup-to-different-sheet-not-working-northfields-review-test-etaf
Sheet: Cost Calculation

Job Data |  |  |  |  |  |  |  |  | main rate | Main rate variable | Main rate variable | Main rate variable | Main rate variable | TMA extra cost | Wash out hydrant | fire hydrant | sluice valves | air valves | non return valve | Pressure reducing valve (install only) | mains branch | Add metres of main/service/comm pipe
 |  |  |  |  |  |  |  |  | rate | rate | rate | rate | rate | Lookup | rate | rate | rate | rate | rate | rate | rate | m
Unique Id | SAP order no. | Service Product | Job as promoted | Job as delivered | Description | Final Entry | Error | Audit | A1 | A2 | A3 | A4 | A5 | TM | V1 (a-d) | V2 (a-d) | V3 (a-d) | V4 (a-d) | V5 (a-d) | V6 (a-d) | V7 (a-d) | X1 (a-d)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TM
25770880-6 | 25770880 | 3SL6 | Yes | 3SL6 | Manifold Installation No Exc |  | 0
25770832-7 | 25770832 | 3SL6 | Yes | 3SL6 | Manifold Installation No Exc |  | 0
25942414-8 | 25942414 | 3ML1 | Yes | 3ML1 | Excavate and [NAME] |  | 0
25904092-9 | 25904092 | 3HW2 | Yes | 3HW2 | [NAME] |  | 0
25762507-10 | 25762507 | 3SM2 | Yes | 3SM2 | Inst LrgeDiaMtrd ComPipe Shrt |  | 0
25770831-11 | 25770831 | 3SM4 | Yes | 3SM4 | Inst MSMChmMtrFerLaidSer [NAME] |  | 0
25904092-12 | 25904092 | 3HW2 | Yes | 3HW2 | [NAME] |  | 0
26123859-13 | 26123859 | 3ML1 | Yes | 3ML1 | Excavate and [NAME] |  | 0
26123859-14 | 26123859 | 3ML1 | No | 3TH1 | [NAME] (Permit) |  | 0
23494103-15 | 23494103 | 3ML1 | Yes | 3ML1 | Excavate and [NAME] |  | 0
25981916-16 | 25981916 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  | 0
25981916-17 | 25981916 | 3SM1 | No | 3SM4 | Inst MSMChmMtrFerLaidSer [NAME] |  | 0
26164701-18 | 26164701 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  | 0
25880278-19 | 25880278 | 3LD0 | Yes | 3LD0 | Lead Renewal (Short Side) |  | 0
26100240-20 | 26100240 | 3DC1 | Yes | 3DC1 | Disconnect Cust Supply Rech |  | 0
26161186-21 | 26161186 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  | 0
26161188-22 | 26161188 | 3SFA | Yes | 3SFA | New Supplies Disconnection |  | 0
26078818-23 | 26078818 | 3DC1 | Yes | 3DC1 | Disconnect Cust Supply Rech |  | 0
26137612-24 | 26137612 | 3SM0 | Yes | 3SM0 | Inst Mtrd MSM Com Pipe ShortS |  | 0
26137809-25 | 26137809 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  | 0
26166744-26 | 26166744 | 3SM0 | Yes | 3SM0 | Inst Mtrd MSM Com Pipe ShortS |  | 0
26094786-27 | 26094786 | 3ML2 | Yes | 3ML2 | Lay Main Only |  | 0
26094786-28 | 26094786 | 3ML2 | Yes | 3ML2 | Lay Main Only |  | 0
26054664-29 | 26054664 | 3ML1 | Yes | 3ML1 | Excavate and [NAME] |  | 0
26164333-30 | 26164333 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  | 0
26185749-31 | 26185749 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  | 0
26146302-32 | 26146302 | 3SM0 | Yes | 3SM0 | Inst Mtrd MSM Com Pipe ShortS |  | 0
26146302-33 | 26146302 | 3SM4 | Yes | 3SM4 | Inst MSMChmMtrFerLaidSer [NAME] |  | 0
26146303-34 | 26146303 | 3SM0 | Yes | 3SM0 | Inst Mtrd MSM Com Pipe ShortS |  | 0
25981539-35 | 25981539 | 3ME1 | Yes | 3ME1 | 15mm [NAME] (NoExc) |  | 0
Spreadsheet: 669263d1585274813-conditional-format-with-multiple-conditions-rota-conditional-format-multiples
Sheet: WEEK 15

 | W/C | 2020-04-06 00:00:00 |  | MON | TUE | WED | THU | FRI | SAT | SUN
 |  | WEEK | 15
EARLY SHIFT | 1 | Vacant |  | WORKING | WORKING | WORKING | WORKING | OD | WORKING | WORKING
 | 2 | Vacant |  | OD | WORKING | WORKING | WORKING | WORKING | OD | OD
 | 3 | Vacant |  | WORKING | WORKING | WORKING | WORKING | WORKING | OD | OD
 | 4 | Person 1 |  | WORKING | WORKING | WORKING | OD | WORKING | WORKING | WORKING
 | 5 | Person 2 |  | OD | A/L | A/L | A/L | A/L | OD | OD
 | 6 | Person 3 |  | WORKING | WORKING | WORKING | WORKING | WORKING | OD | OD
 | 7 | Person 4 |  | WORKING | WORKING | OD | WORKING | WORKING | WORKING | WORKING
 | 8 | Person 5 |  | OD | WORKING | WORKING | WORKING | WORKING | OD | OD
 | 9 | Vacant |  | WORKING | WORKING | WORKING | WORKING | WORKING | OD | OD
 | 10 | Person 6 |  | WORKING | WORKING | WORKING | WORKING | OD | A/L | A/L
 | 11 | Person 7 |  | OD | WORKING | WORKING | WORKING | WORKING | OD | OD
 | 12 | Person 8 |  | A/L | A/L | A/L | A/L | A/L | OD | OD
 | 13 | Person 9 |  | WORKING | WORKING | WORKING | OD | WORKING | WORKING | WORKING
 | 14 | Person 10 |  | OD | WORKING | WORKING | WORKING | WORKING | OD | OD
 | 15 | Person 11 |  | WORKING | WORKING | WORKING | WORKING | WORKING | OD | OD
 | 16 | Person 12 |  | WORKING | WORKING | OD | WORKING | WORKING | WORKING | WORKING
 | 17 | Person 13 |  | OD | WORKING | WORKING | WORKING | WORKING | OD | OD
 | 18 | Person 14 |  | WORKING | WORKING | WORKING | WORKING | WORKING | OD | OD
Spreadsheet: 752638d1634869892-index-match-between-two-dates-template-123
Sheet: Sheet1

First Name | Last Name | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 |  | Index Match between two dates
[NAME] | Bloggs |  |  |  |  | I'm working with a large data set which is an extraction from a current system. Unfortunately, the structure isn't great and I'm trying to re-organise the data.
[NAME] | Citizen
 |  |  |  |  |  | I'm trying to 'extract' through index match a reference that is between two dates.
First Name | Last Name | Compensation Change Date | Compensation Amount |  |  | I've attached a template of what I'm trying to accomplish. The shaded area is where I've hardcoded numbers but would ideally have a formula do this.
[NAME] | Bloggs | 2019-02-15 00:00:00 | 50000
[NAME] | Bloggs | 2019-12-31 00:00:00 | 65000
[NAME] | Bloggs | 2020-07-01 00:00:00 | 70000
[NAME] | Citizen | 2018-08-01 00:00:00 | 110000
[NAME] | Citizen | 2019-07-01 00:00:00 | 115000
[NAME] | Citizen | 2020-07-01 00:00:00 | 120000
[NAME] | Smith | 2019-06-18 00:00:00 | 85000
[NAME] | Smith | 2020-07-01 00:00:00 | 95000
Robyn | Banks | 2019-08-08 00:00:00 | 125000
Robyn | Banks | 2020-07-01 00:00:00 | 135000
Geoff | [NAME] | 2019-11-19 00:00:00 | 75000
Geoff | [NAME] | 2020-07-01 00:00:00 | 80000
Spreadsheet: 85922d1285917252-text-into-a-cell-2010-09-28-vendas-de-animais-janeiro-2010
Sheet: F13

CLIENTE |  | IANAKI DIMOV |  |  |  | Nº CONTRIBUINTE |  |  |  |  | DATA |  | 2010-01-18 00:00:00
MORADA |  |  |  |  |  |  |  |  |  |  | PRAZO PAGAMENTO |  | 0 | DIAS
CIDADE |  |  |  |  |  | TIPO PAGAMENTO |  |  |  |  | VENCIMENTO
 |  |  |  |  | DATA RECEPÇÃO |  |  |  |  | Nº FACTURA |  | 178
REF. | DESCRIÇÃO |  |  |  | QUANTIDADE |  | PREÇO TON. |  |  |  | VALORES SEM IVA
 |  |  |  |  | Unidade | Kgs. | BGL |  | EUROS |  | BGL |  | EUROS
pabt |  |  |  |  | 150 | 26589 | 25
rabt |  |  |  |  | 10 | 12345 | 2.6
 |  |  |  | TOTAIS
 |  |  |  |  |  |  |  |  | IVA |  | 0.2
 |  |  |  |  |  |  |  |  | VALOR IVA
 |  |  |  |  |  |  |  |  | VALOR COM IVA
Spreadsheet: 153479d1335933113-index-match-help-example-2
Sheet: Network

[NAME] Event Detail
 |  |  |  |  | NETWORK (1605001)
Reported Date | Claim ID | Division (FLEET DATA LEVEL_06_NODE_DS) | Name | Location | Event Description | Accident Date
IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'NETWORK (1605001)' THEN PULL INFOMRATION FROM COLUMN X ON 'FLEET DATA ACC DETAIL' | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'NETWORK (1605001)' THEN PULL INFOMRATION FROM COLUMN Q ON 'FLEET DATA ACC DETAIL' | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'NETWORK (1605001)' THEN PULL INFOMRATION FROM COLUMN J ON 'FLEET DATA ACC DETAIL' |  | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'NETWORK (1605001)' THEN PULL INFOMRATION FROM COLUMN AB ON 'FLEET DATA ACC DETAIL' | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'NETWORK (1605001)' THEN PULL INFOMRATION FROM COLUMN V ON 'FLEET DATA ACC DETAIL' | IN THIS CELL IF COLUMN H ON 'FLEET DATA ACC DETAIL' READS 'NETWORK (1605001)' THEN PULL INFOMRATION FROM COLUMN W ON 'FLEET DATA ACC DETAIL'
DRAG DOWN | DRAG DOWN | DRAG DOWN | DRAG DOWN | DRAG DOWN | DRAG DOWN | DRAG DOWN
Spreadsheet: 711641d1609829203-add-values-each-month-based-on-a-ramp-up-model-example-1-
Sheet: Sheet1

MODEL - STANDARD SALESMAN PERFORMANCE
"Standard" months | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Sales | 0 | 10 | 15 | 30 | 35 | 40 | 50 | 60 | 80 | 120 | 150 | 200
Variable Costs
Fixed Costs | -5 | -5 | -5 | -5 | -5 | -10 | -10 | -10 | -10 | -10 | -10 | -10
 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
Hires of month (input) | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 0
Total Number of Salesmen
OUTPUT (n. of salsmen * standard salesman performance) | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
Sales
Variable Costs
Fixed Costs
 | Desired results
 | 0 | 0 | 0 | 10 | 25 | 45 | 65 | 85 | 115 | 165 | 220 | 315
 | 0 | 0 | 0 | -3.5 | -8.75 | -15.75 | -22.75 | -29.75 | -40.25 | -57.75 | -77 | -110.25
 | 0 | 0 | -5 | -10 | -10 | -10 | -15 | -25 | -35 | -35 | -40 | -45
Spreadsheet: 782770d1654263874-sumifs-change-sequentially-excel-sample
Sheet: Sheet1

Row | Post | Pressure
1201 | 1 | 1 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
1201 | 1 | 1 |  | 1201
1201 | 1 | 1 |  | 1202
1201 | 1 | 1 |  | 1203
1201 | 2 | 1
1201 | 2 | 1
1201 | 2 | 1
1202 | 1 | 1
1202 | 1 | 1
1202 | 2 | 1
1202 | 2 | 1
1202 | 3 | 1
1202 | 3 | 1
1202 | 4 | 1
1202 | 4 | 1
1202 | 5 | 1
1202 | 5 | 1
1202 | 6 | 1
1202 | 6 | 1
1202 | 7 | 1
1202 | 7 | 1
1202 | 8 | 1
1203 | 1 | 1
1203 | 1 | 1
1203 | 1 | 3
1203 | 1 | 3
1203 | 2 | 1
1203 | 2 | 1
1203 | 2 | 3
1203 | 2 | 4
1203 | 3 | 1
1203 | 3 | 1
1203 | 3 | 4
1203 | 3 | 4
1203 | 4 | 1
Spreadsheet: 81f7fa73-66e1-4ba3-a288-cd3f6d837f4a
Sheet: SFR STARTS ONLY

 |  |  |  | Single Family Residential Starts
YEAR | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL
2014 | 40 | 59 | 45 | 49 | 60 | 38 | 32 | 34 | 59 | 16 | 24
2013 | 50 | 31 | 53 | 67 | 45 | 47 | 31 | 24 | 31 | 36 | 35 | 29
2012 | 19 | 19 | 44 | 46 | 38 | 46 | 46 | 48 | 26 | 37 | 22 | 26
2011 | 5 | 20 | 32 | 44 | 26 | 51 | 9 | 10 | 36 | 19 | 12 | 37
2010 | 19 | 47 | 60 | 44 | 33 | 83 | 36 | 37 | 25 | 27 | 25 | 19
2009 | 57 | 93 | 68 | 85 | 89 | 61 | 44 | 67 | 19 | 31 | 35 | 39
2008 | 50 | 105 | 87 | 82 | 106 | 76 | 45 | 35 | 28 | 53 | 23 | 25
2007 | 112 | 91 | 124 | 90 | 111 | 107 | 85 | 59 | 63 | 101 | 49 | 54
2006 | 322 | 178 | 337 | 242 | 170 | 191 | 126 | 113 | 81 | 55 | 90 | 144
2005 | 193 | 347 | 195 | 335 | 288 | 315 | 254 | 317 | 236 | 218 | 146 | 240
2004 | 94 | 85 | 201 | 176 | 142 | 185 | 166 | 135 | 113 | 181 | 121 | 121 | 1720
2003 | 60 | 79 | 110 | 114 | 111 | 135 | 141 | 105 | 93 | 103 | 71 | 102 | 1224
2002 | 71 | 66 | 83 | 75 | 68 | 77 | 70 | 83 | 66 | 90 | 75 | 77 | 901
2001 | 62 | 67 | 102 | 78 | 114 | 83 | 64 | 92 | 68 | 72 | 58 | 56 | 916
2000 | 44 | 28 | 47 | 64 | 57 | 57 | 69 | 43 | 70 | 51 | 44 | 54 | 628
1999 | 20 | 53 | 26 | 61 | 47 | 23 | 55 | 48 | 48 | 30 | 37 | 58 | 506
1998 | 35 | 33 | 85 | 85 | 63 | 75 | 57 | 38 | 66 | 60 | 16 | 51 | 664
1997 | 48 | 70 | 69 | 35 | 87 | 79 | 18 | 63 | 23 | 43 | 49 | 91 | 675
1996 | 34 | 81 | 58 | 48 | 65 | 64 | 91 | 110 | 40 | 91 | 38 | 58 | 778
1995 | 56 | 60 | 105 | 77 | 117 | 63 | 56 | 67 | 55 | 64 | 50 | 89 | 859
1994 | 63 | 72 | 69 | 64 | 41 | 52 | 41 | 65 | 67 | 91 | 56 | 91 | 772
1993 | 29 | 73 | 105 | 91 | 90 | 115 | 80 | 100 | 48 | 111 | 70 | 91 | 1003
1992 | 22 | 43 | 59 | 54 | 48 | 55 | 69 | 81 | 72 | 24 | 52 | 41 | 620
1991 | 35 | 31 | 39 | 39 | 31 | 44 | 45 | 43 | 48 | 49 | 95 | 75 | 574
1990 | 29 | 20 | 14 | 25 | 53 | 39 | 30 | 76 | 29 | 35 | 38 | 28 | 416
1989 | 58 | 65 | 105 | 64 | 61 | 59 | 51 | 53 | 37 | 49 | 8 | 46 | 656
1988 | 38 | 75 | 100 | 70 | 99 | 127 | 54 | 58 | 103 | 55 | 45 | 39 | 863
1987 | 102 | 106 | 95 | 78 | 36 | 48 | 43 | 39 | 84 | 81 | 43 | 45 | 800
1986 | 73 | 85 | 89 | 118 | 74 | 129 | 76 | 95 | 109 | 74 | 72 | 32 | 1026
1985 | 91 | 108 | 67 | 73 | 182 | 105 | 93 | 103 | 81 | 128 | 37 | 59 | 1127
TOTAL
**Totals include [NAME] as well as stick-built homes.**
***BUILDING INSPECTION BECAME A DIVISION OF C.D.D. IN MAY, 1987.
(Prior to that date, permits were obtained through C.I.D.-State)