tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 821641d1678824115-multiple-changing-variables-that-require-a-sum-dummy-ulcer-data
Sheet: helper

 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Ward 1 | 1 | 1 | 2 | 2 | 4 | 4 | 5 | 6 | 6 | 7 | 7 | 7
Ward 2 | 2 | 2 | 5 | 5 | 5 | 6 | 7 | 1 | 1 | 1 | 1 | 3
Ward 3 | 3 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 1 | 1 | 1 | 1
Ward 4 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
Ward 5 | 5 | 1 | 1 | 1 | 4 | 4 | 4 | 4 | 7 | 7 | 5 | 4
Ward 6 | 5 | 1 | 1 | 1 | 4 | 4 | 4 | 4 | 7 | 7 | 5 | 4
Ward 7 | 5 | 1 | 1 | 1 | 4 | 4 | 4 | 4 | 7 | 7 | 5 | 4
Ward 8 | 5 | 1 | 1 | 1 | 4 | 4 | 4 | 4 | 7 | 7 | 5 | 4
Ward 9 | 5 | 1 | 1 | 1 | 4 | 4 | 4 | 4 | 7 | 7 | 5 | 4
Spreadsheet: 810484d1671802950-row-distribution-testing-hd
Sheet: Data

 | Roberts D | 1
 | [NAME] O | 5
 | [NAME] | 126
 |  | 138
 | Atikinson N | 198
 |  | 209
 | Sheldon A | 348
 | Shaw C | 378
 |  | 422
 | Blogs F | 497
 | Smith A | 504
 |  | 858
 |  | 1084
 |  | 1101
 | Bradley K | 1188
 |  | 1211
 | Farden U | 1279
 |  | 1359
 | [NAME] | 1360
 |  | 1461
 | Sunny J | 1936
 |  | 1947
 | Adams H | 2070
 | [NAME] | 2071
 |  | 2195
 |  | 2229
 | O'Hart | 2248
 |  | 2418
 | [NAME] T | 2425
 | [NAME] | 2502
Spreadsheet: 173709d1344686469-cross-referencing-people-to-skills-please-read-below-excel-help
Sheet: NIGEL

 | MOTOR SPORT SUPPORT: PERSONAL RECORD
 | NAME: | [NAME]
 | ADDRESS:
 | TEL: |  |  | MOBILE:
 | EMAIL:
 | D.O.B: |  |  | AGE:
 | NOK: |  |  | TEL:
 | BLOOD GRP:
 | ALERGIES:
 | INDUCTION |  |  | STATUS
 | TASTER DAY |  |  | COMPLETED
 | CIRCUIT SKILLS | CURRENT LEVEL | TRNG PROVIDED BY |  |  | TRNG COMPLETED
 | [NAME] | T
 | LIGHTS | I
 | COMMS | A
 | MEDIC SUPPORT | A | ST JOHNS AMBULANCE |  |  | T - 1/1/10 | I - 1/1/11 | A - 1/1/12
 | TOW
 | LIFT
 | DISBURSEMENTS
 | FIRE - BOTTLE - WATER | A | FIRE SERVICE |  |  | T - 1/1/10 | I - 1/1/11 | A - 1/1/12
 | FIRE - BOTTLE - PWDR
 | FIRE - TRUCK - WATER
 | FIRE - TRUCK - PWDR
Spreadsheet: 872277d1718657303-copy-rows-from-1-excel-sheet-to-another-if-cells-in-column-a-match-movie-and-tv-lists_sample
Sheet: VUDU

Title | Studio | [NAME] | Year | Cast
(500) Days of Summer (2009) | 20th Century Fox | [NAME] | 2009 | [NAME], [NAME], [NAME], Chloë [NAME], [NAME]
...And Justice for All (1979) | Sony Pictures | Legal | 1979 | [NAME], [NAME], [NAME], [NAME], [NAME], [NAME]
10 [NAME] (2016) | Paramount Pictures | Horror | 2016 | [NAME], [NAME], [NAME], [NAME], [NAME], Bradley Cooper
10 Rillington Place (1971) | Sony Pictures | Non-Fiction Crime | 1971 | [NAME], [NAME], [NAME], [NAME], [NAME]
10 Things I Hate About You (1999) | Disney / Buena Vista | Teen Romance | 1999 | [NAME], Julia Stiles, [NAME], [NAME], [NAME], [NAME]
10 Years (2011) | Starz / Anchor Bay | [NAME] | 2011 | [NAME], [NAME], [NAME], [NAME], [NAME], [NAME]
10 (1979) | Warner Bros. | [NAME] | 1979 | [NAME], [NAME], [NAME], [NAME], [NAME], [NAME]
10,000 B.C. (2008) - Hunter sets out on a bold trek through uncharted realms to rescue his kidnapped beloved | Warner Bros. | Fantasy | 2008 | [NAME], [NAME], Cliff Curtis, [NAME], [NAME], Mo Zinal
100 Girls (2000) | Lionsgate Films | Teen | 2000 | [NAME], Emmanuelle Chriqui, [NAME], [NAME], [NAME], Jaime Pressly
100 Rifles (1969) | 20th Century Fox | Western | 1969 | [NAME], [NAME], [NAME], [NAME], [NAME], [NAME]
101 Dalmatians (Signature Collection) (1961) | Disney / Buena Vista | Animation (Disney) | 1961 | [NAME], [NAME], [NAME], [NAME], [NAME], Cate Bauer
101 Dalmatians II: Patch's London Adventure (2003) | Disney / Buena Vista | Animation (Disney) | 2003 | [NAME], [NAME], [NAME], [NAME], [NAME], [NAME]
101 Dalmatians (1996)  (Live Action) | Disney / Buena Vista | Family Adventure | 1996 | [NAME], [NAME], [NAME], [NAME], [NAME], [NAME]
102 Dalmatians (2000)  (Live Action) | Disney / Buena Vista | Family Adventure | 2000 | [NAME], [NAME], [NAME], [NAME], [NAME], [NAME]
11 Harrowhouse (1974) - Diamond merchant is blackmailed into robbing the vault at a precious gem exchange | 20th Century Fox | Heist | 1974 | [NAME], [NAME], [NAME], [NAME], [NAME], [NAME]
11.22.63: Season 1 (TV) (2016) | Warner Bros. | Time Travel | 2016 | [NAME], [NAME], [NAME], [NAME], [NAME], [NAME]
12 Angry Men (1957) | Metro-Goldwyn-Mayer | Legal | 1957 | [NAME], [NAME], [NAME], [NAME], [NAME], [NAME]
12 Men of Christmas (2009) | 20th Century Fox | Christmas | 2009 | [NAME], [NAME], [NAME], [NAME]
12 Monkeys (1995) | Universal Studios | Sci-Fi Mystery | 1995 | [NAME], [NAME], [NAME], [NAME], [NAME], [NAME]
Spreadsheet: 15fae81b-2d15-4dd7-9fec-e63922bebc4e
Sheet: Sheet1

[NAME] zur Radbundesliga 2008 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Straße Frauen 2008
 |  | Landesverbands-Mannschaft |  |  | Vereinsmannschaft
 |  | Continental Teams Frauen (Pkt. 2.4 GA) |  |  | Renngemeinschaft
!Namentliche Nennung der [NAME] lt. Generalausschreibung bis spätestens [NAME]. Februar 2008
Offizieller Mannschaftsname:
 | Nr. | Zu- und [NAME] | [NAME] | Kader | UCI-Code* | Lizenz-Nr.
 | 1.
Min. | 2.
 | 3.
 | 4.
 | 5.
 | 6.
[NAME]. | 7.
 | 8.
 | 9.
 | 10.
 | 11.
 | 12.
Sportliche/r Leiter/in und [NAME]/in:
Nr. | Vor- und Nachname: |  | Adresse/E-mails: |  |  | Lizenz-Nr.:
1.
2.
Anschrift des verantwortlichen Ansprechpartners (bezügl. Schriftverkehr: Name, [NAME], Telefon, Fax, E-mail)
Name/Vorname:
Straße/Ort:
Telefon/Fax:
Handynummer:
E-mail:
Bankverbindung:
BLZ:
Konto-Nr.:
Nenngelder in Höhe von |  |  | Überweisung ([NAME] beifügen)
€ 510,- bezahlt durch:
[NAME]: Es wird ausdrücklich bestätigt, dass alle [NAME], [NAME] bzw. Sportgruppen ihr Einverständnis zur  Meldung gegeben haben, im Besitz einer gültigen Lizenz sind und die Generalausschreibung und das Reglement der  Radbundesliga anerkennen.
Ort/Datum: |  |  | Unterschrift/Stempel:
 |  | BDR-Bankverbindungen: | Dresdner Bank AG Frankfurt/Main, Kto.-Nr. 5 100 677 00 (BLZ 500 800 00)
 |  |  | Postgirokonto Frankfurt/Main, Nr. 61 685-602 (BLZ 500 100 60)
 | * UCI-Code setzt sich wie folgt zusammen: GER für Deutschland + Geburtsjahr + Monat + Tag (Bsp.: GER 19660508)
Spreadsheet: 78828d1279128796-insert-picture-into-a-single-cell-mobileflags
Sheet: Sheet2

 | Algeria | ALG |  |  | HOME |  | AWAY
 | Argentina | ARG
 | Australia | AUS |  |  | Australia | v | Germany
 | Brazil | BRA
 | Cameroon | CAM
 | Chile | CHI |  |  | Denmark | v | Brazil
 | Côte d'Ivoire | CIV
 | Denmark | DEN |  |  | Argentina | v | Algeria
 | England | ENG
 | France | FRA
 | Germany | GER
 | Ghana | GHA
 | Greece | GRE
 | Honduras | HON
 | Italy | ITA
 | Japan | JAP
 | Korea DPR | KDP
 | Korea Republic | KOR
 | Mexico | MEX
 | Netherlands | NED
 | New Zealand | NZL
 | Nigeria | NIG
 | Paraguay | PAR
 | Portugal | POR
 | Serbia | SRB
 | Slovakia | SVK
 | Slovenia | SVN
 | South Africa | RSA
 | Spain | ESP
 | Switzerland | SUI
 | Uruguay | URU
 | USA | USA
Spreadsheet: kevin_ruscitti__20263__PLRates 05-01
Sheet: ANRMeter

ANR
[NAME] | Name | [NAME] (RC/DV) | Location | Throughput
Reliant | Perryville |  | ML2
Columbia Gas | Lebanon | 38843 | ML3 | 400000
Columbia Gas | Paulding | 16118 | ML3 | 75000
CNG | Lebanon | 21906 | ML3
MGT | Chrisney |  | ML3
TGT | Slaughters |  | ML3
Columbia Gas | Monclova | 110850 | ML7 | 127000
Columbia Gas | Maumee N | 108641 | ML7 | 200000
GRLK | Farwell | 11616/48644 | ML7 | 1000000
GRLK | [NAME] | 11611/40844 | ML7 | 700000
NGPL | Joliet | 2610 | ML7 | 310000
NGPL | Woodstock |  | ML7
TX Eastern | French [NAME] |  | ML7
Viking | Marshfield |  | ML7 | 330000
Consumers | Stag Lake | 22992 | ML7
Michcon | Willow | 42078 | ML7 | 1000000
Michcon | Colombus | 28672 | ML7 | 300000
Michcon | Kaulkaska |  | ML7
NICOR | Shorewood | 138675 | ML7 | 300000
Peoples | E. Joliet | 4196 | ML7
Acadian | Franklin | 10399 | SE | 140000
Bridgeline | Riverway | 42593 | SE | 1500000
HIOS |  | Various | SE | 1200000
Florida | [NAME] | 10100 | SE | 160000
[NAME] | Centerville | 10410 | SE | 450000
LIG | [NAME] | 142179 | SE | 100000
NGPL | Lake Arthur | 74629/7694 | SE | 500000
Sonat | Shady Side | 10369/33400 | SE | 300000
Stingray | [NAME] | 135819 | SE | 100000
TX Gas | Eunice | 6655 | SE
TX Eastern | St. Laundry |  | SE
Trunkline | [NAME] | 48640/40317 | SE | 150000
UTOS |  | Various | SE | 800000
CIG/NGPL | Beaver | 16453/16435(4) | SW | 186000
MDMC |  |  | SW
NNG | Janesville | 28808 | SW | 120000
NNG | Greensburg | 34887/90017 | SW | 250000
PEPL | Defiance | 15672 | SW | 467000
Spreadsheet: 840086d1692392855-formula-for-a-sumif-or-sumifs-with-summary-and-value-in-different-worksheets-example-to-post
Sheet: LAB

WWS | Employee Name | LAB COST
93167 | [NAME] | 42.73
93167 | [NAME] | 42.73
2606.1 | [NAME] | 85.45
24628 | [NAME] | 514.64
24628 | [NAME] | 643.3
2606.1 | [NAME] | 697.62
2606.1 | [NAME] | 465.08
24628 | [NAME] | 232.54
24628 | [NAME] | 385.98
24628 | [NAME] | 192.06
11246 | [NAME] | 101.23
78002 | [NAME] | 683.6
2606.1 | [NAME] | 1324.48
78002 | [NAME] | 1324.48
78002 | [NAME] | 151.85
24628 | [NAME] | 288.09
24628 | [NAME] | 643.3
89314 | Amelia [NAME] | 64.33
2606.1 | Karmen [NAME] | 520.74
2606.1 | [NAME] | 116.27
89314 | [NAME] | 694.32
2606.1 | [NAME] | 694.32
89314 | [NAME] | 260.37
89314 | [NAME] | 465.08
2606.1 | [NAME] | 96.44
89314 | [NAME] | 86.79
89314 | [NAME] | 86.79
2606.1 | [NAME] | 86.79
89314 | [NAME] | 116.27
89314 | [NAME] | 241.1
89314 | [NAME] | 21.7
Spreadsheet: 28055d81-c81f-492f-a381-3587ceaeb4be
Sheet: Sheet1

New York State Energy Research and Development Authority | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Solicitation/Contract No. | Unnamed: 6 | Page
Contract Pricing Proposal Form |  |  |  |  | PON 2618
Contractor: |  |  |  |  | Name of Proposed Project:
Address:
Location (where work is to be performed): |  |  |  |  | NYSERDA funding:
 |  |  |  |  | Total Project Cost:
 |  |  |  |  | Total | Funding & | Cost-sharing
 |  |  |  |  | Project | Co-funding | & Other
Cost Element |  |  |  |  | Cost | via NYSERDA | Co-funding
1.   Direct Materials
a. Purchased Parts
b. Other
Total Direct Materials
2.   Materials Overhead |  |  | Rate:
3.   Direct Labor (specify names/titles) |  |  | Hours | Rate/hr
Total Direct Labor
4.   Labor Overhead |  |  | Rate % | $ [NAME]
Total Labor Overhead
5.   Outside Special Testing
6.   Equipment
7.   Travel
8.   Other Direct Costs
9.   Subcontractors/Consultants
Total Subcontractors/Consultants
10. General & Administrative Expense |  |  | Rate % | Element(s)
11. Fee or Profit  (if allowable)      Rate: |  |  |  |  |  | Not Allowed
12. Total Estimated Project Cost
This proposal reflects our best estimates as of this date, in accordance with the instructions to proposers.
Typed Name and Title: |  |  |  | Signature: |  |  | Date:
Has any executive agency of the U.S. government performed any review of your records in connection with any prime
contract or subcontract within the past twelve months? |  |  |  | ____ Yes | ____ No
If yes, identify:
Supporting Schedule - Contract Pricing Proposal Form
Element No. | Item Description |  |  |  |  |  | Amount
Spreadsheet: 59980d1260497926-how-can-i-fix-value-dreamz
Sheet: Products

Products
21 | Summer Beach Scene | 25
27 | Seascape Watch | 36
31 | Victorian Walking Stick | 28
47 | Spanish Ducat Key Chain | 12
63 | Rainesdrop Crew Neck T-shirt | 14
67 | Stonewashd Twill Jacket | 54
68 | Island Can Coolers | 6
Spreadsheet: 57417d1257532615-date-formula-torque_nut
Sheet: Sheet1

Process | # of days to complete |  |  | Select process from the drop down menus
Process 1 | 1 |  |  | Select up to three
Process 2 | 2
Process 3 | 3 |  | 1.) | Process 3 |  |  | 3.) | Process 3
Process 4 | 4 |  |  |  |  |  |  |  |  |  |  | These are drop down lists
 |  |  | 2.) | Process 2 |  |  | 4.) | Process 4
Process: |  | Daily Customers |  | Monday & Wednesday Only Customers |  |  |  | Tuesday & Thursday Only Customers |  |  |  | Friday Only Customers
Process 3 |  | 2009-11-11 00:00:00 |  | 2009-11-16 00:00:00 |  |  |  | 2009-11-17 00:00:00 |  |  |  | 2009-11-27 00:00:00
Process 2 |  | 2009-11-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | These are the delivery Dates
Process 3 |  | 2009-11-11 00:00:00
Process 4 |  | 2009-11-12 00:00:00
 |  |  |  |  |  |  | Can't figure these out. I figured out the daily customer ones, but not the rest of them
Spreadsheet: 871147d1717572214-percent-rank-of-an-array-percentrank-aligw
Sheet: Sheet1

 |  | Style Pnts | Surface | Distance | Class |  | PercentRank
 | 1 | 3 | 0.47 | 0 | 0.56
 | 2 | 7 | 0.4 | 0 | 0 |  | 2
 | 3 | 0 | 0.44 | 0.56 | 0.5 |  | 6
 | 4
 | 5 | 3 | 0.5 | 0 | 0.83 |  | 3
 | 6 | 0 | 0.72 | 0.67 | 0.72 |  | 5
 | 7 | 7 | 0.45 | 0.6 | 0.5 |  | 1
Spreadsheet: 63097d1264059968-mail-merge-help-required-mailme
Sheet: Sheet1

[NAME] | Schedule | Received | Pending
s&[EMAIL] | 1000 | 800 | 200
s&[EMAIL] | 500 | 250 | 250
[EMAIL] | 300 | 200 | 100
[EMAIL] | 2000 | 1900 | 100
[EMAIL] | 500 | 300 | 200
[EMAIL] | 100 | 50 | 50
Spreadsheet: 306f9f05-1efb-41d4-9c15-e0281c69651d
Sheet: Total Request

Calculator Instructions:                                                                                                FOOD GROUP - EGG | Click on a processor name to access its calculator.  While calculator formats are different, each will help you estimate the number of pounds you will need by asking for your estimated number of servings, ect.   Note, each excel spreadsheet is restricted by food group.  While some processors offer multiple items on one calculator, your request will only populate on the Total Request tab if it is within the food group listed on that spreadsheet.  You will need to pull up the beef spreadsheet to allocate beef pounds, the chicken calculator to allocate chicken pounds, ect.
 | The calculator will automatically calculate the number of pounds you will need for a specific item, and will input that number on the Total Request tab.  Once finished, take the numbers in yellow and transfer them to your NOI Request Form.  Be sure you are inputting the correct number of pounds for each processor.  The processor number on this form should match the processor number on the NOI Request Form.
Processor | Broker | Contact | Material | [NAME] | USDA Value | Total Value
20. [NAME] Favorites | [NAME] | [NAME] | 10047 |  | 0.696
21. Cargill Kitchen Solutions | Hockenberg Newburgh | [NAME] | 10047 |  | 0.696
22. [NAME] | Advantage Waypoint | [NAME] | 10047 |  | 0.696
 |  | Total lbs Requested: |  |  | Total Value:
Spreadsheet: geir_solberg__11278__10_19act
Sheet: EPEData

 | 37276.03819444445
 | NEWMAN 1 ,MANL, 34  , 75  , 35  , 83  ,  0  ,1
 | NEWMAN 2 ,MANL, 31  , 77  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,ECON, 38  ,100  , 35  ,103  , 40  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,ECON,136  ,215  , 86  ,214  , 78  ,1
 | NEWMAN   ,, 238 ,  467,  190, 483 , 118 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,UNAV,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,MANL, 30  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,100  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,  30 ,   38,   32,  49 ,   0 ,
 | PALOVERDE,MANL,193  ,193  ,193  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 98  , 98  , 98  ,104  ,  0  ,1
 | LAMBDA, 27.90,  680,  678,  210,    0,    0,12191,0
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 681723d1591713177-sumproduct-must-ignore-negative-values-lq
Sheet: Initial forecast

 |  | 0.8 | July | July |  |  | estimate
 |  | of Wine | Wine | Natural | average
116x137 | Black/Gold |  | 15.5 | 9.216666666666669 |  |  | 12
116x182 | Black/Gold |  | 10 | 10.55 |  |  | 9
116x228 | Black/Gold |  | 17.25 | 9.391666666666667 |  |  | 13.32083333333333
168x137 | Black/Gold |  | 9.5 | 7.7 |  |  | 8
168x182 | Black/Gold |  | 17.75 | 13.55833333333333 |  |  | 15
168x228 | Black/Gold |  | 30.5 | 27 |  |  | 28
228x137 | Black/Gold |  | 7.75 | 4.358333333333334 |  |  | 6.054166666666667
228x182 | Black/Gold |  | 23.25 | 10 |  |  | 18
228x228 | Black/Gold |  | 39.5 | 23 |  |  | 31.25
076cm Oblong Tieback | Black/Gold |  | 50.25 | 29.50833333333333 |  |  | 39.87916666666666
18" Cushion | Black/Gold |  | 127.75 | 53.73333333333333 |  |  | 90
24" Cushion | Black/Gold |  | 124.25 | 58.2 |  |  | 90
Spreadsheet: 798354d1664441570-possible-to-make-tedious-formula-more-efficient-and-scalable-sample
Sheet: Sheet1

Employee | Wages | Taxes | Benefits | Hours |  | Hrs/Proj 1 | Hrs/Proj 2 | Hrs/Proj 3
Employee 1 | 3000 |  |  | 120 |  | 80 | 40 | 0
Employee 2 | 1000 |  |  | 40 |  | 40 | 0 | 0
Employee 3 | 5000 |  |  | 200 |  | 100 | 50 | 50
Employee 4 | 500 |  |  | 20 |  | 10 | 0 | 10
Employee 5 | 750 |  |  | 30 |  | 10 | 10 | 10
Employee 6 | 4000 |  |  | 160 |  | 80 | 80 | 0
 |  |  |  | Wages
 |  |  |  | Taxes
 |  |  |  | Benefits
Spreadsheet: 733297d1621498723-help-with-formula-based-on-number-of-occurences-of-values-in-another-column-sample
Sheet: Sheet1

 | 1
 | 0.5
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1000
 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
 | 0
 | 2000
Time | S | N | Result | T | T+L | S2 | W/L | P | CP | SP | Reset
04/05/2019 11:25:00 | A | 5.6 | Won
04/05/2019 11:50:00 | B | 3.56 | Won
04/05/2019 11:53:00 | C | 3.8 | Lost
04/05/2019 12:18:00 | D | 3.45 | Lost
04/05/2019 12:41:00 | E | 4.93 | Lost
04/05/2019 12:50:00 | C | 4.1 | Won
04/05/2019 13:00:00 | F | 4.2 | Lost
04/05/2019 13:06:00 | S | 3.45 | Lost
04/05/2019 [NAME] | T | 3.45 | Lost
04/05/2019 13:16:00 | A | 2.66 | Lost
04/05/2019 13:50:00 | U | 3.1 | Lost
04/05/2019 14:01:00 | Y | 4.6 | Lost
04/05/2019 14:05:00 | Z | 5.32 | Lost
04/05/2019 14:10:00 | X | 3.6 | Lost |  |  |  |  |  |  |  | <--- after 7 consecutive losses, this number is 0 as per the formula in Col G
04/05/2019 14:12:00 | C | 3 | Won
04/05/2019 14:18:00 | B | 4.59 | Won
04/05/2019 14:25:00 | A | 4.2 | Lost |  |  |  |  |  |  |  | <--- after the zeros in col G above, there have been two occurances of the value "Won" in Col D, so the value in Col E should now be one more than the previous (in this case it was 7 so add one equals 8)
04/05/2019 14:30:00 | R | 3.05 | Lost
04/05/2019 14:36:00 | K | 3.85 | Lost
04/05/2019 14:38:00 | O | 3.55 | Lost
04/05/2019 14:45:00 | P | 4.58 | Lost
04/05/2019 17:15:00 | C | 3.86 | Lost
04/05/2019 17:30:00 | F | 3.5 | Lost
04/05/2019 18:15:00 | S | 5.59 | Lost |  |  |  |  |  |  |  | <--- after 7 consecutive losses, this number is 0 as per the formula in Col G
04/05/2019 19:15:00 | T | 3.7 | Lost
04/05/2019 20:15:00 | A | 5.3 | Lost
11/05/2019 11:50:00 | U | 4.2 | Won
11/05/2019 12:18:00 | Y | 3.15 | Lost
11/05/2019 12:30:00 | Z | 5.16 | Lost
11/05/2019 13:16:00 | X | 4 | Won
11/05/2019 13:40:00 | C | 5.5 | Lost |  |  |  |  |  |  |  | <--- after the zeros in col G above, there have been two occurances of the value "Won" in Col D, so the value in Col E should now be one more than the previous (in this case it was 15 so add one equals 16)
11/05/2019 13:53:00 | B | 3.06 | Won
11/05/2019 14:12:00 | A | 3.08 | Lost
18/05/2019 12:05:00 | A | 5.2 | Lost
18/05/2019 12:15:00 | U | 5.59 | Lost
18/05/2019 12:25:00 | Y | 5.08 | Lost
[NAME] 12:40:00 | Z | 4.06 | Lost
18/05/2019 12:47:00 | X | 3.56 | Lost
[NAME] 12:50:00 | C | 4.1 | Lost
18/05/2019 13:06:00 | A | 4.5 | Won |  |  |  |  |  |  |  | <--- after 7 consecutive losses, this number is 0 as per the formula in Col G
18/05/2019 13:10:00 | U | 4.6 | Lost
[NAME] 13:15:00 | Y | 3.85 | Won
18/05/2019 13:18:00 | Z | 3.6 | Lost |  |  |  |  |  |  |  | <--- after the zeros in col G above, there have been two occurances of the value "Won" in Col D, so the value in Col E should now be one more than the previous (in this case it was 24 so add one equals 25)
18/05/2019 13:40:00 | X | 5.1 | Lost
[NAME] 13:46:00 | C | 3.05 | Lost
Spreadsheet: 870040d1716548916-sumifs-criteria-not-working-v3-aligw
Sheet: WEEK3

 | DROP DOWN MENU ----> |  |  | 2024-05-01 00:00:00
 | 2024-05-20 00:00:00
 | SITE | Vacancies (P) | Interview Slots | Interviews Attended (s) | Attended  vs  Slots | Job Offers (z) | Offers  vs  Vacancies
 | [NAME]
 | Ealing
 | Fulham
 | Harlesden
 | [NAME]
 | [NAME]
 | Hounslow
 | Kingston
 | Queens Park
 | [NAME]
 | [NAME]
 | Uxbridge
 | Wandsworth
 | Wembley
 | District Office
 | [NAME]
 | Grand Total
Spreadsheet: 827659d1682941462-how-to-update-to-reflect-the-new-extra-added-columns-updateheader-2nd-5throws
Sheet: Sheet1

1st
 | This is the main table that contains my data, so I've gave it a name "MainTable", but this name of course does not includes the header row.
 | And also set a defined name "EntireMainTable" to include the header row as well.
 | No. | Item | 2016 | 2017 | 2018 | 2019
 | 1 | Cash | 586659031 | 480343056 | 20473172 | 605840237
 | 2 | Sales | 759051269 | 498365688 | 395887621 | 554353871
 | 3 | Receivables | 554603731 | 413440842 | 653946455 | 484659284
 | 4 | payables | 102298199 | 858026168 | 111387132 | 410342401
 | 5 | Loans | 826522204 | 873292758 | 320363304 | 389108069
 | 6 | Expenses | 722623185 | 34417935 | 579008782 | 333651085
2nd
 | Now if I want to copy the entire table and let the copy got updated automatically, I use the formula =EntireMainTable
 |  | Item | 2016 | 2017 | 2018 | 2019
 | 1 | Cash | 586659031 | 480343056 | 20473172 | 605840237
 | 2 | Sales | 759051269 | 498365688 | 395887621 | 554353871
 | 3 | Receivables | 554603731 | 413440842 | 653946455 | 484659284
 | 4 | payables | 102298199 | 858026168 | 111387132 | 410342401
 | 5 | Loans | 826522204 | 873292758 | 320363304 | 389108069
 | 6 | Expenses | 722623185 | 34417935 | 579008782 | 333651085
3rd - When the table got updated
 | Now I want to copy only the header and the 2nd and 5th rows of that table, but also want if the table got updated by adding new columns for new years like 2020 …etc. I want the new added data to be copied automatically.
 | No. | Item | 2016 | 2017 | 2018 | 2019 | 2020
 | 1 | Cash | 586659031 | 480343056 | 20473172 | 605840237 | 322747307.5
 | 2 | Sales | 759051269 | 498365688 | 395887621 | 554353871 | 372772047
 | 3 | Receivables | 554603731 | 413440842 | 653946455 | 484659284 | 534330646
 | 4 | payables | 102298199 | 858026168 | 111387132 | 410342401 | 414886867.5
 | 5 | Loans | 826522204 | 873292758 | 320363304 | 389108069 | 136028619
 | 6 | Expenses | 722623185 | 34417935 | 579008782 | 333651085 | 261843883.5
4th - I want the copy to be updated automatically, copy only the header and the 2nd and 5th rows of that table
 | How to only copy the header, 2nd, and 5th rows, and include column 2020, and if more columns added later on to be included
 | I've tried to add a defined names for header, 2nd row, and 5th row, but it did not got updated except for header
 | No. | Item | 2016 | 2017 | 2018 | 2019 | 2020
 | 1 | Cash | 586659031 | 480343056 | 20473172 | 605840237 | 322747307.5
 | 2 | Sales | 759051269 | 498365688 | 395887621 | 554353871 | 372772047
 | 3 | Receivables | 554603731 | 413440842 | 653946455 | 484659284 | 534330646
 | 4 | payables | 102298199 | 858026168 | 111387132 | 410342401 | 414886867.5
 | 5 | Loans | 826522204 | 873292758 | 320363304 | 389108069 | 136028619
 | 6 | Expenses | 722623185 | 34417935 | 579008782 | 333651085 | 261843883.5
5th - Only the header worked! | I was not able to make a dynamic updated range for 2nd, and 5th rows
 |  | Item | 2016 | 2017 | 2018 | 2019 | 2020