tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 838703d1691264103-the-return-value-past-a-specific-should-be-zero-example-55-
Sheet: Projected Depreciation

 | Description | ID | Type | Entity | Useful Life (Months) | Useful Life (Years) | Monthly Depre. | Acquisition Date | Asset Value | 2011-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2013-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2014-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014 | 2015-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2015 | 2016-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2016 | 2017-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Book Salvage Value
 | Equipment 1 | 123456789 | Bread Machine | Unit A | 120 | 10 | 114.1666666666667 | 2011-07-01 00:00:00 | 13700
 | Equipt 2 | 123456788 | Bread Machine 2 | Unit B | 84 | 7 | 229.0952380952381 | 2017-11-14 00:00:00 | 19244
Spreadsheet: 753847d1635785724-help-concatenate-skip-blanks-add-line-break-mail-merge-test
Sheet: Sheet1

Preferred [NAME] | Sun, Nov 1 | Mon, Nov 22 | [NAME], Nov 23 | Concatenate Result
[EMAIL] | Meeting 1 |  | Meeting 3
[EMAIL] |  | Meeting 2
[EMAIL] |  |  | Meeting 3
[EMAIL] | Meeting 1 | Meeting 2
[EMAIL] | Meeting 1 |  | Meeting 3
[EMAIL] | Meeting 1 | Meeting 2 | Meeting 3
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Mike McCarthy

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
It is unfair for employees who benefit from a collective bargaining unit to shirk the responsibility of contributing to the activities done
on their behalf. We must work together to define how the fair share should be assessed so that we give employees who do not wish
to participate in overtly political acvtivity the opportunity to opt out.
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
Disagree
Explain your health care reform position, if you choose
The main goal of health care reform is to provide affordable access to health care for everyone. If Vermont gets the policy right, the
new health care system should not diminish coverage or cost more for the vast majority of unionized workers. I fully support the
health care reform effort and will not advocate for plans that cost more to our teachers and other unionized workers. In our current
heallth care payment structure, insured workers have had costs shifted on to them that they should not have had to bear. I will not
advocate for a  reformed system that increases this problem, but I am reluctant to promise that I will support special compensation for
a specific group of organized labor without knowing what the benefits and payment structure will look like for everyone in our state.
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 321 Lake St. | State Represenate (Franklin 3-1) | No
Spreadsheet: 57596d1257802080-using-a-calculation-to-show-which-column-a-figure-falls-under-book2
Sheet: Sheet1

Project | January | February | March | April | May | June | July | August | September | October | November | December
Birmingham |  |  | 5000 |  |  |  |  |  |  |  |  |  | MONTH TO GO HERE e.g. March
London |  |  |  |  |  | 2500 |  |  |  |  |  |  | "JUNE" TO DISPLAY HERE
[NAME] |  |  |  | 500 |  |  |  |  | 1000 |  |  |  | "APRIL/SEPTEMBER" TO DISPLAY HERE
Spreadsheet: 122643d1317043544-duplicating-drop-downs-for-separate-sheets-in-1-workbook-book2
Sheet: Names

Last | First | MI | [NAME] | Team | Role | Grade | Sort by grade | sort by team | sort by role
Adams | [NAME] | V | asfsd | Leadership | SSSW | [NAME]
[NAME] | Kayla | P | dfgf | SIT | Instructional Staff | Grade 5
Dominguez | [NAME] | W | asdffds | Catch Up | Mental Health Partner Staff | Pre K
Griffin | [NAME] | C | ghfhgf | TSI | Principal | Grade 11
Henri | [NAME] | M | hkhj | TSI | Principal | Grade 11
Hilton | [NAME] | C | [NAME] | SIT | Instructional Staff | Grade 6
Jacobs | Kylie | E | hjkkj | IST | Teacher | Grade 9
[NAME] | Stacy | A | ert | IST | Teacher | Grade 11
Phillips | [NAME] | S | q324 | TSI | Principal | [NAME]
Simpleton | [NAME] | J | wert364 | SIT | Instructional Staff | [NAME]
[NAME] | [NAME] | B | bvnyh | Leadership | Teacher | Grade 7
[NAME] | Stanley | L | 890lg | Leadership | SSSW | Grade 11
White | [NAME] | N | 12qwa | Leadership | Teacher | Grade 10
Wilshere | [NAME] | P | 342sdgf | Leadership | SSSW | Grade 11
Spreadsheet: 42976d1241598377-how-to-check-whether-a-text-exists-in-a-group-of-cells-example61
Sheet: Sheet1

WITH FORMULA:
ALL | People | Names |  | Names | People
[NAME] | NO | YES |  | [NAME] | [NAME]
[NAME] | YES | YES |  | Spongebob | George
George | YES | YES |  | [NAME]
Spongebob | NO | YES |  | George
SHOULD BE:
ALL | People | Names |  | Names | People
[NAME] | NO | YES |  | [NAME] | [NAME]
[NAME] | YES | YES |  | Spongebob | George
George | YES | YES |  | [NAME]
Spongebob | NO | YES |  | George
ALL | People | Names |  | Names | People
[NAME] | no | yes |  | [NAME] | [NAME]
[NAME] | yes | yes |  | Spongebob | George
George | yes | yes |  | [NAME]
Spongebob | no | yes |  | George
Spreadsheet: phillip_m_love__30638__texasfred plove
Sheet: AVar

Financial Liquidation Variances
GL Perspective: Economics to Review
TAGG | GL Amount | [NAME] | [NAME] |  | Desk Adjustment | GL Adjustment/Reclass | Comments
NA7778.2 | 125611.94 | -125599.9379999998
N38487.2 | 65906 | -65900
N38490.2 | 65906 | -65900
N38492.2 | 65906 | -65900
NA7778.4 | 62805.97 | -62799.96899999989
NB3069.3 | 54740 | -54749.99999999993
NB2779.1 | 23268 | -23250.00000000009
NB1797.2 | 23190 | -23200
NB1817.1 | 23190 | -23200
NA9999.1 | 18197 | -18200
NB2880.1 | 15512 | -15500.00000000006
NB8356.1 | 15246 | -15250
NB4322.1 | 13104 | -13100
NB4324.4 | 12124 | -12125
NB4324.3 | 11774 | -11775
NB4324.2 | 10374 | -10375
NB1002.2 | 8580 | -8575.000000000025
NB4324.1 | 8274 | -8274.999999999995
NB1969.2 | 8190 | -8200.00000000005
NB2790.1 | 7756 | -7750.000000000042
NB3276.1 | 6874 | -6875.000000000021
NB3278.1 | 6874 | -6875.000000000021
NC6107.2 | 5401 | -5400
NB5701.1 | 5052 | -5050.000000000015
NB9444.8 | 3978 | -3975.000000000007
NB1002.3 | 3330 | -3325.000000000007
NC7728.1 | 2974.5 | -2975.000000000005
NB9444.4 | 2740.5 | -2737.499999999989
NB4820.2 | 2652 | -2650.000000000012
NC7728.3 | 2324 | -2325
NB9444.7 | 1953 | -1950.000000000012
NC0073.1 | 72 | -74.9999999999853
[NAME] | 43.5 | -49.99999999998252
E06912.S | -18443.39 | 0
N69426.1 | -14880 | 0
E33520.9 | -14755.99 | 0
E43532.4 | -14419.59 | 0
EO3094.1 | -13957 | 0
E99035.3 | -980.75 | 0
E05136.7 | -50.4 | 0
E24155.4 | 18.96 | 0
E24346.3 | 21.75 | 0
E24344.3 | 38.29 | 0
E50361.3 | 61.38 | 0
E24161.4 | 254.06 | 0
E05136.5 | 516.51 | 0
E26418.4 | 620 | 0
E26357.4 | 641.6 | 0
EY2670.1 | 852.5 | 0
E25904.5 | 960.05 | 0
E05228.4 | 2635 | 0
E33520.B | 6145.35 | 0
N82893.1 | 8990 | 0
EO3094.2 | 13957 | 0
EN0116.1 | 16000 | 0
E07001.7 | 16246.21 | 0
EK1331.3 | 18443.39 | 0
E07001.A | 20946.22 | 0
ES5823.Y | 25187.5 | 0
[NAME] | 44570 | 0
NA7655.1 | 368125 | 0
NA7651.1 | 395250 | 0
E90253.G | 1875810 | 0
NB9444.6 | -1647 | 1649.999999999992
NB9444.3 | -1953 | 1950
NB9444.2 | -2478 | 2474.999999999994
NC7728.2 | -2524.5 | 2525
NB9444.1 | -3003 | 3000.000000000029
NB9444.5 | -3003 | 3000.000000000029
NC7728.4 | -3324 | 3325
NC6107.1 | -4576 | 4574.999999999994
NB3252.1 | -5756.5 | 5749.999999999994
NB3895.1 | -7574 | 7575.000000000013
[NAME] | -7574 | 7575.000000000013
NB1002.1 | -9330 | 9325.000000000013
NC2776.1 | -10956.8 | 10960
NB0983.1 | -11580 | 11575
[NAME] | -14696 | 14700
NB3254.1 | -17313 | 17300
NA8979.2 | -21297 | 21300
NB3069.4 | -24780 | 24749.99999999991
NA8979.1 | -32922 | 32925
NA8486.1 | -32953 | 32950
NB3949.2 | -33096 | 33100
NB3622.1 | -40068 | 40049.99999999979
NA5479.1 | -43028 | 43025
NA5493.1 | -43028 | 43025
NA4151.2 | -63581 | 63575
NA4157.2 | -63581 | 63575
NA4180.2 | -63581 | 63575
NA7778.3 | -67456 | 67450
NA4198.2 | -127162 | 127150
NA7778.1 | -131812 | 131800
NA5455.2 | -188417.91 | 188399.9069999997
NA0929.2 | -321780 | 321750
Spreadsheet: 188230d1350754514-automatic-calculations-making-excel-count-and-display-progressively-satvleli
Sheet: Sheet3

5 | 4
5 | 6
5 | 3
5
5
5
5
5
5
5
5
5
5
5
5
5
10
10
10
10
10
10
10
10
10
10
10
15
15
15
15
15
15
15
15
15
20
20
20
20
20
20
20
25
25
25
25
25
25
30
Spreadsheet: 703071d1604734279-calculate-running-time-based-on-date-and-time-between-previous-entry-test-book-1
Sheet: Sheet1

Date | Time | completed hours
2020-10-07 00:00:00 | 09:00:00 | 0
2020-10-08 00:00:00 | 09:00:00 | 24
2020-10-09 00:00:00 | 09:00:00 | 48
2020-10-12 00:00:00 | 11:00:00 | 122
2020-10-13 00:00:00 | 10:30:00 | 145.5
2020-10-14 00:00:00 |  |  |  |  | I need a formula in this column to start at [NAME] and calculate the hours between the previuous date & time and the new date and time but it also must include the previous completed hours figure from the day before. So in C3 it would be ZERO but in C4 It would be the amount of completed hours in C3 which is 24 in this case plus the amount of running hours between the date and time entries in columns A & B.
Spreadsheet: 99854d1298401073-changing-10k-part-numbers-xlf-fulford
Sheet: Sheet1

C90S-12 | 16C90S |  |  |  | Old | New |  | Old | New
B90-12 | 16B90 |  |  |  | 06 | 10 |  | C | C
C45-15 | 24C45 |  |  |  | 10 | 12 |  | B | B
CP-15C | 24CPC |  |  |  | 12 | 16 |  | S | PCE
C90S-12 | 16C90S |  |  |  | 14 | 20 |  | VX | PC
B90-12 | 16B90 |  |  |  | 15 | 24
C45-15VX | 24C45PC |  |  |  | 20 | 32
CP-15C | 24CPC |  |  |  | 25 | 36
 |  |  |  |  | 30 | 48
 |  |  |  |  | 35 | 56
 |  |  |  |  | 40 | 64
 |  |  |  |  | 45 | 72
 |  |  |  |  | 50 | 80
 |  |  |  |  | 55 | 88
 |  |  |  |  | 60 | 96
Spreadsheet: 163a8fe1-1ecf-4791-9f53-dcfeaf33fe48
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (41 Entries):
 | 2 Analysis 2.7 Detectors
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Agilent Technologies Sales & Services GmbH & Co. [NAME] | Germany | Waldbronn | 76337 | A2.105/206
2 | Alliance Instruments - AMS France Unity Scientific | France | Frepillon | 95740 | A1.406
3 | Andor Technology plc. | United Kingdom | Belfast | BT12 7AL | A2.144
4 | BERTHOLD TECHNOLOGIES GmbH & Co. [NAME] | Germany | Bad Wildbad | 75323 | [NAME]
5 | Brookhaven Instruments Corp. | USA | Holtsville | NY 11742 | A1.429
6 | Büchi Labortechnik GmbH | Germany | Essen | 45127 | A2.405
7 | CeramOptec GmbH | Germany | Bonn | 53121 | A2.445
8 | CHROMSYSTEMS Instruments & Chemicals GmbH | Germany | Gräfelfing / München | 82166 | B1.211
9 | DURATEC Analysentechnik GmbH | Germany | [NAME] | 68766 | A1.111
10 | ECOM spol. s.r.o. | Czech Republic | Prag | 120 35 | A2.427
11 | Ellutia | United Kingdom | Witchford | CB6 2HY | A1.133
12 | [NAME] | Germany | Riemerling | 85521 | A2.305
13 | fischer analytics OHG | Germany | Bingen | 55411 | A1.236
14 | FOSS GmbH | Germany | [NAME] | 25462 | A1.505
15 | GERSTEL GmbH & Co. [NAME] | Germany | Mülheim an der Ruhr | 45473 | A1.323/424
16 | [NAME] GmbH | Germany | [NAME] Hallertau | 84072 | A1.119/216
17 | Hamamatsu Photonics Deutschland GmbH | Germany | Herrsching | 82211 | A2.415/514
18 | ITS Europe Ltd. | United Kingdom | Salisbury | SP3 5DU | A1.139
19 | Jasco Europe s.r.l. | Italy | Cremella | 23894 | A2.121/220
20 | J&M Analytik AG | Germany | [NAME] | 73457 | A2.550
21 | [NAME] systems GmbH | Germany | Moers | 47445 | A2.221/322
22 | JSB BV | Netherlands | Eindhoven | 5653 [NAME] | A2.130
23 | KNAUER [NAME] Dr. [NAME]. [NAME] | Germany | Berlin | 14163 | A2.307
24 | Laser 2000 GmbH | Germany | Weßling | 82234 | A2.303
25 | Laser Components GmbH | Germany | Olching | 82140 | A2.400A
26 | LECO Instrumente GmbH | Germany | Mönchengladbach | 41199 | A1.324
27 | LEONI Fiber Optics GmbH | Germany | Neuhaus-Schierschnitz | 96524 | A2.234
28 | LLA Instruments GmbH | Germany | Berlin | 12489 | A2.435
29 | Malvern Instruments GmbH | Germany | [NAME] | 71083 | A1.320
30 | PAS-Analytik GmbH | Germany | Hamburg | 22419 | B2.430/6
31 | PicoQuant GmbH | Germany | Berlin | 12489 | A2.510
32 | Postnova Analytics GmbH | Germany | [NAME] | 86899 | A2.323
33 | PSS Polymer Standards Service GmbH | Germany | [NAME] | 55120 | A1.223
34 | raytest Isotopenmessgeräte GmbH | Germany | Straubenhardt | 75334 | A3.220
35 | Schambeck SFD GmbH | Germany | Bad Honnef | 53604 | A1.404
36 | Sedere sas | France | Alfortville Cedex | 94141 | A2.231
37 | [NAME] Europe GmbH | Germany | München | 81829 | A1.326
38 | Thermo Scientific | Germany | Dreieich | 63303 | B1.101/202
39 | Unity Scientific GmbH | Germany | [NAME] | 40549 | A1.406
40 | Waters GmbH | Germany | Eschborn | 65760 | A1.243/336
41 | Wyatt Technology Europe GmbH | Germany | Dernbach | 56307 | A1.439
Spreadsheet: 743193d1628280473-a-few-if-formulas-to-excel-forum
Sheet: Sheet1 (2)

 |  | I want:
 |  | F16 to say "flat" IF E16 says "flat"
 |  | If E16 has 18.00 (or any numerical value), then F16 should = E16 x C16
 |  | If F16:F21 has all "flat", then F24 should = 120.00
 |  | If F16:F21 has all numerical values, then F24 should = SUM
 |  | If F16:F21 has a both numerical values and "flat", then SUM 120.00+numerical values
INVOICE
[NAME] To: |  | Invoice ID
 |  | Issue Date
 |  | Due Date
 |  | Week Ending
Balance Due
Service | Description | Hours | hh:[NAME] | Rate | Total
Client Projects | PROJECT NAME | 2.09 | 02:00:00 | flat
 | July 26, 2021 9:28 pm - 11:33 pm
 | task name
 | task name
 |  |  |  | Subtotal | 120
 |  |  |  | Paid to Date | 0
 |  |  |  | Balance Due
Spreadsheet: 88059d1287975202-excel-2010-conditional-formatting-across-mulitpe-colums-patch
Sheet: Sheet1

DEVICE | PORT | DEVICE | PORT | DEVICE | PORT | DEVICE | PORT
EDGE1 | 2/01 | R2C2-PPB | 1
EDGE1 | 2/02 | R2C2-PPA | 19
EDGE1 | 2/03 | R2C2-PPA | 20
EDGE1 | 2/04 | R2C2-PPA | 22
EDGE1 | 2/05 | R2C2-PPA | 08
EDGE1 | 2/06 | R2C2-PPC | 10
EDGE1 | 2/07 | R2C2-PPA | 7
EDGE1 | 2/09 | R2C2-PPA | 21
EDGE1 | 2/10 | R2C2-PPA | 11
EDGE1 | 2/12 | R2C2-PPC | 23
EDGE1 | 2/20 | R2C2-PPB | 3
EDGE1 | 2/21 | R2C2-PPC | 9
EDGE1 | 2/22 | R2C2-PPC | 8
EDGE1 | 2/25 | R2C2-PPA | 8
EDGE1 | 2/30 | R2C2-PPA | 13
EDGE1 | 2/37 | R2C2-PPC | 5
EDGE1 | 2/38 | R2C2-PPC | 6
EDGE1 | 2/43 | R2C2-PPC | 13
EDGE1 | 2/44 | R2C2-PPC | 3
EDGE1 | 2/45 | R2C2-PPB | 10
EDGE1 | 2/47 | R2C2-PPA | 23
EDGE1 | 2/48 | BCC-RR1
EDGE1 | 3/01
EDGE1 | 3/03
EDGE1 | 3/07
EDGE1 | 3/08
EDGE1 | 3/10
EDGE1 | 3/11
EDGE1 | 3/13
EDGE1 | 3/14
EDGE1 | 3/17
EDGE1 | 3/20
EDGE1 | 3/22
EDGE1 | 3/23
EDGE1 | 3/24
EDGE1 | 3/26
EDGE1 | 3/28
EDGE1 | 3/31
EDGE1 | 3/32
EDGE1 | 3/34
EDGE1 | 3/35
EDGE1 | 3/36
EDGE1 | 3/37
EDGE1 | 3/38
EDGE1 | 3/39
EDGE1 | 3/41
EDGE1 | 3/42
EDGE1 | 3/43
EDGE1 | 3/44
EDGE1 | 3/45
EDGE1 | 3/47
EDGE1 | 3/48
EDGE1 | 6/1
EDGE1 | 6/2
Spreadsheet: 65655d1266347931-selective-data-to-get-a-printed-report-budget-to-actual-expenditure-2010-slots
Sheet: 9

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Estimated Duty / Tax / Transport = |  | 0.45
 | Details |  |  |  |  | Quotation |  |  |  |  |  | Invoice |  |  |  |  |  |  |  | Local Duty, TAX & Local Transport
I / Q | # | Sequence # | Company | Discription |  | Quotation # | Quotation (Euro) | X rate | RSD | Date (processed) |  | Invoice # | Act invoice (Euro) | X rate | RSD | SHIP invoice | Difference % | Process (date) |  | Duty & Transport | Act invoice | Difference % | Paid (date) |  | Total cost (actual) | Special NOTES
 | 1 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 2 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 3 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 4 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 5 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 6 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 7 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 8 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 9 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 10 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 11 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 12 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 13 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 14 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 15 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 16 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 17 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 18 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 19 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 20 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 |  |  |  | Total = |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | Total spent = |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Budget total = |  | 518940
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remaining = |  | 518940
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % = |  | 1
Spreadsheet: 275495d1383550330-how-to-vlookup-with-multiple-criteria-mambaout626
Sheet: Sheet1

Order ID #(DUPLICATE) | Order Amount | Unique | Less than 50K | B/W 10K & 50K
235611 | 1625
240425 | 11572.72
242686 | 4290
242686 | 12285
242686 | 14742
242686 | 5733
242686 | 257.4
242686 | 384.8
242686 | 6054.75
242686 | 6054.75
242686 | 8073
242686 | 11466
242709 | 35400
242709 | 5400
242894 | 228
244543 | 6531.47
244543 | 6116.86
244563 | 13062.94
Spreadsheet: 30766d1226439946-formula-to-reference-previous-cell-in-row-ud-2
Sheet: NARRATIVE

 |  |  |  | FIELD SERVICES BUREAU DAILY REPORT
MICHIGAN STATE POLICE
OFFICER(S) |  | MO/DA/YR |  | RADAR VERIFICATION |  | CAR NUMBER |  | PATROL AREA
 |  | #N/A |  | ER or NR NO.
 |  |  |  | Speedometer Calibration Date |  | MILEAGE
 |  |  |  |  | OUT         IN | IN
 |  |  |  | TIME | 7:00a | OUT |  | GUN NUMBER
 |  |  |  | Display Segment Check |  | TOTAL
 |  |  |  | Internal Verification |  | [NAME]
OTHER EQUIPMENT |  |  |  | Range Test |  |  |  | CAMERA NUMBER
 |  |  |  | Audio Test |  | GAS | OIL
 |  |  |  | Patrol Speed Test |  | ______ | ______
TIME | ACTIVITY | CODE | [NAME] |  | [NAME] OF ACTIVITY
7:00a | I/S |  |  |  | On Duty
 | VW
 | CA
 | PI
3:00p | O/S
 | O/S |  |  |  | Off Duty
Spreadsheet: 599229d1542913492-inventory-aging-fifo-inventory-age-updated-v2_gw
Sheet: Sheet2

 |  |  |  |  |  |  |  |  | [NAME]
 |  | Buffer In | Buffer Out | Daily Buffer Amount | Cum in | Cum out | Take inv from |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1-3 Days | 4 - 11 Days | 12 - 17 Days | 18+ Days
 | 2017-10-15 00:00:00 | 0 | 0 |  | 0 | 0
 | 2018-01-02 00:00:00
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Canada A&A

 | Canada Analyst & Associate
 | 2002 Plan
 |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2002 |  | 2002 |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  | 0 | Compensation | 0
 | Special Pays |  |  |  |  | 0
 | Analysts & Associates | 0 |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | Analyst | 66000
ENATAXES | Taxes Other than Income |  |  |  |  |  | Associate | 97200 | 2
ENATOTDR | Total Direct Expenses |  |  |  |  |  | Manager | 120000 | 0
 |  |  |  |  |  |  | Director | 156000 | 0
 | Headcount |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  | VP | 216000 | 0
 | Analyst & Associate Headcount |  |  |  |  |  | CEO | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | *  Analysts and Associates are billed through normal payroll for Canada. |  |  |  |  | Other Expense Calculation
ENAOUTTX
ENAINSUR |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
ENASYSDV
ENACORIT
ENACORRN
ENAOTHAL
ENADEPR
Spreadsheet: 836594d1689514283-vba-auto-update-a-weekly-schedule-weeksched-2-
Sheet: Sheet1

 |  | Weely schedule
2023-07-17 14:00:00 | Client 1
2023-07-13 08:00:00 | Client 2
2023-07-20 11:30:00 | Client 3
2023-07-14 15:00:00 | Client 4
This should auto update to 07/20 08:00am when the current date (in A2) passes the date in cell A5
This should auto update to 07/21 3pm when the current date (in A2) passes the date in cell A7
Once the date in Column A passes the date in cell A2, I'm having to manually change the dates to 7 days later. For instance, the date in cell A5 needs to change to 07/20/2023 8:00am automatically.
Same for cell A7, this needs to update automatically to 07/21/2023 3pm instead having to manually change it.
Spreadsheet: 779280d1651678266-formula-conditional-formatting-to-highlight-upcoming-oil-change-week-sample-zahid0111-
Sheet: MP10

Oil Change Plan
 | Week # |  |  | Oil change due reading |  | 91190
Last Replacment Date: |  | 2021-06-27 00:00:00 |  | Reading date |  | 2022-04-27 00:00:00 |  | Doc 1
M/ Unit | Point No | Description | Quantity (L) | Code | Date Oil Change | Status | Oil Change Meter Reading | RunningHours | Remaining Hours | Total run Hours | Running days | Per day Run
M1 | 1 | Agitator [NAME] | 0.5 | Shell Omla EP150 | 2018-09-17 00:00:00 |  | 85047 | 6000
 | 2 | Hopper pusher unit | 8 | Shell Omla EP150 | 2018-01-04 00:00:00 |  | 85047 | 6000
 | 3 | Cig. Pocket pusher unit | 6 | Shell Omla EP150 | 2018-01-04 00:00:00 |  | 85047 | 6000
Spreadsheet: 107424d1304599166-need-formula-for-a-macro-function-example
Sheet: 13

826
Name | Amount
Name 3 | 127
Name 2 | 179
Name 2 | 127
Name 3 | 193
Name 2 | 110
Name 3 | 171
Name 3 | 103
Name 2 | 199
Name 3 | 118
Name 3 | 126
Name 2 | 163
Name 3 | 125
Name 1 | 137
Name 1 | 111
Name 2 | 118
Name 1 | 119
Name 1 | 113
Name 3 | 130
Name 2 | 194
Name 3 | 113
Name 2 | 107
Name 3 | 184
Name 3 | 122
Name 1 | 166
Name 1 | 180
Spreadsheet: 679356d1590347142-same-cust-number-within-2-or-more-groups-unique-group
Sheet: Sheet1

GROUP NUM | CUST NUM | ACC NO | Flag I want
8 | NSRN67L100800X | 13400310 | 1
8 | NSRN67L100800X | 13491858
8 | NSRN67L100800X | 13487635
10 | NSRN67L100800X | 13008840 | 1
10 | NSRN67L100800X | 13393888
27 | NSRN67L100800X | 14693886 | 1
27 | NSRN67L100800X | 13293807
Spreadsheet: 766941d1644181826-help-with-index-array-formula-sample
Sheet: Sheet1

Employee | Shift
Abbey | 1
[NAME] | 3
[NAME] | 4
[NAME] | 2
[NAME] | 8
[NAME] | 3
George | 5
[NAME] | 1
Iliana | 7
Jessica | 6
[NAME] | 2
Leonard | 6