tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 153538d1335957702-rolling-over-man-hours-into-next-month-page-tab-complete-ps-2012
Sheet: Oct 2012

2012-10-01 00:00:00
Date Submitted | Job No | Site | Customer | Project Engineer / Manager | Scope of work | Min People | Actual People | Budget Hours | Actual Hours | Field of work | Start Date | Finish Date | Comments / Additional Information | Special Tools |  |  | Match
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Man Hours | Available Hrs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrical
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mechanical
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site Electrical
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site Mechanical
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site Supervisor
Spreadsheet: 852650d1702607655-excel-formula-to-separate-name-in-two-columns-separating-names
Sheet: Employees 

STAFF MEMBERS
NAME | DATE OF BIRTH | DATE JOINED | ID NO. | JOB TITLE | Fiscal Year
[NAME] | [NAME] | 01/04/2021 | 08-965660 G73 | SUPERVISOR | 2023
[NAME] | 03/03/2003 | 08/02/2023 | 79-2013160 T79 | CASHIER /ACCOUNT ASS | 2023
Cain Johns | 10/06/2003 | 01/04/2021 | 08-2101012 E39 | ASSISTANT MANAGER | 2023
Spreadsheet: 40e157a2-3012-495b-aef1-b4cc261b68d6
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
RSER | Test | RSER | Rabbit Serum Proteins, IgE | Rabbit Serum Proteins, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
RSER | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
RSER | Result | RSER | Rabbit Serum Proteins, IgE | Rabbit Serum Proteins, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 10960-3 | Rabbit serum proteins [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 5ab0370e-adeb-4e1e-8e3c-52004f7598e5
Sheet: Audit Scoresheet

United States Department of Agriculture |  |  |  |  | Good Agricultural Practices & Good Handling Practices
Agricultural Marketing Services |  |  |  |  | Audit Verification Program Scoresheet                    www.ams.usda.gov/gapghp
Fresh Products Branch |  |  |  |  | for use only for SUBWAY SUPPLIERS
Facility Name (Print) as it should appear on Certificate:
Street Address (Print): |  |  |  |  |  |  | City (Print): |  |  |  |  |  |  |  |  | State (Print): |  |  | Zip (Print):
e-mail Address (Print): |  |  |  |  |  |  | fax number: |  |  |  |  |  |  |  |  | Date Audit Requested:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date of Previous Audit :
Date Audit Began: |  |  |  |  |  |  |  | Date Audit Completed: |  |  |  |  |  |  |  | USDA Commodity Procurement Audit?
Time Audit Began: |  |  |  |  |  |  |  | Time Audit Completed: |  |  |  |  |  |  |  | Check One |  | Yes |  | No
EVALUATION ELEMENTS
[NAME] | Element |  |  |  | Possible | Less N/A |  | Adjusted |  | Passing |  | Facility | Compliant |  | Date |  | General |  | Reviewing |  |  | Un-announced
Requested |  |  |  |  | Points | Points |  | Points |  | Score* |  | Score | Not Comp |  | Passed |  | Questions |  | Official
 | General Questions |  |  |  | 180
 | Part 6 – Wholesale Distribution |  |  |  | 410
 | Center/ Warehouses
 | Part 7 – Preventative Food |  |  |  | 180
 | Defense Procedures
**A Passing Score is 80% of the Possible Points or the Adjusted Points, if adjustment are necessary, with no "automatic unsatisfactory" conditions is required for certification.
Commodities |  | Commodity:
Reviewed (Print): |  | Acres:
Send completed GAP&GHP Certificate to: (choose one) |  |  |  |  |  | Inspection office: (list office) |  |  |  |  |  |  |  |  |  | Directly to auditee above:
Lead Auditor Name (Print): |  |  |  |  |  |  |  | Duty Station: |  |  |  |  |  |  | Signature & Date:
Facility Representative signature: |  |  |  |  |  |  |  |  |  |  |  | Date: |  |  |  |  | All Scopes Completed:
By signing this form, the facility representative agrees to have company information posted to the USDA website. A company will only be listed on the USDA website if all scopes audited receive a passing score.
For USDA HQ use:
Reviewing Official Name (Print) |  |  |  |  |  |  |  |  |  | Signature:
Date Received: |  |  | Date Certificate Mailed: |  |  |  |  |  | Date Posted to USDA Website: |  |  |  |  |  |  |  |  | Revised January  26, 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USDA, AMS, FVP, FPB
To verify a company's continued good standing in the USDA GAP&GHP Program please visit http://www.ams.usda.gov/gapghp |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | For Official Government Use Only
Spreadsheet: 852801d1702747868-data-relocation-from-worksheet-to-worksheet-example
Sheet: Revenue

 | Revenue
Date | Payee | Description | Amount
2023-01-10 00:00:00 | Jan's Car Ins. Addition | dates covering 12/12/22 - 1/10/23 | 150
2023-01-11 00:00:00 | Account 7504 | 2nd Progress Payment, Check 2856 | 812
2023-02-12 00:00:00 | Jan's Cell Addition | dates covering  1/11/23 - 2/12/23 | 80
2023-02-12 00:00:00 | Jan's Car Ins. Addition | dates covering  1/11/23 - 2/12/23 | 150
 |  | Total
Spreadsheet: 01d93c69-5e6c-4dbc-becd-f9d3219ac6f9
Sheet: Discount Factor

Discount Factor Table and Calculators:
Independent Variables:
Interest Rate (r): |  | 0.05
Investment Periods (n): |  | 10
Discount Factor ID | Fund Type | Value Conversion | Discount Factor Value (d) | Discount Factor [NAME] | Discount Factor [NAME] in Excel
1 | [NAME] | PV -> FV |  | (1+r)n | =FV(r,n,0,-1)
2 | [NAME] | FV -> PV |  | (1+r)-n | =PV(r,n,0,-1)
3 | Annuity | A -> FV |  | ((1+r)n-1)/r | =FV(r,n,-1)
4 | Annuity | A -> PV |  | ((1+r)n-1)/(r(1+r)n) | =PV(r,n,-1)
5 | Annuity | FV -> A |  | r/((1+r)n-1) | =PMT(r,n,0,-1)
6 | Annuity | PV -> A |  | r(1+r)n/((1+r)n-1) | =PMT(r,n,-1)
Note:
To take into the effect of interest compounding and discounting in investment analysis, we often need to convert the value of a fund or funds from one type to another, from present value to future value, for example. Using discount factors avoids the need for complicated fomulas. The table presents six common discount factors, along with their math formula and Excel formula.
Change the values of interest rate and the number of investment periods to get their corresponding discount factors.
To use the discount factor, follow this simple formula: Y=dX, where Y is value to be converted to, X is the value to be converted from, and d is one of the discount factor in the following table.
Spreadsheet: 24dd5be1-4cde-4b4e-9af3-b70f9917ca91
Sheet: Sheet1

Relationship of Victims to Offenders | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
by Offense Category, 2011
Offense Category | Total Victims1 | Relationship of Victims to Offenders
 |  | Family Member2 | Family Member and Other3 | Known to [NAME] and Other4 | Stranger5 | All Other6
Total | 1340077 | 287828 | 43429 | 708384 | 133387 | 167049
Crimes Against Persons | 1269145 | 287265 | 43263 | 695445 | 103611 | 139561
[NAME] | 1179231 | 265131 | 42436 | 646935 | 96503 | 128226
Homicide Offenses | 3328 | 549 | 51 | 1251 | 378 | 1099
Kidnapping/Abduction | 14654 | 3235 | 202 | 7435 | 1784 | 1998
Sex Offenses, Forcible | 65444 | 16776 | 511 | 35557 | 4863 | 7737
Sex Offenses, Nonforcible | 6488 | 1574 | 63 | 4267 | 83 | 501
Crimes Against Property | 70932 | 563 | 166 | 12939 | 29776 | 27488
Robbery | 70932 | 563 | 166 | 12939 | 29776 | 27488
1Since Data Element 35 (Relationship of Victim to Offender) is reported only for victims with [NAME] I = Individual or L = Law Enforcement Officer that are connected to Crimes Against Persons or Robbery and is not collected for victims in an incident with an Unknown Offender or victims of other Crimes Against Property or Crimes Against Society offenses, there are 4,606,913 victims that are not included in this table.
2Regardless of number, all offenders were related to the victims.
3At least one offender was related to the victims.
4At least one offender was known to the victims.  No offenders were related.
5Regardless of number, all offenders were strangers to the victims.
6Regardless of number, offenders were mutual combatants (victim was offender), had an unknown relationship, or the relationships were combinations of strangers, mutual combatants, and unknown relationships.
Spreadsheet: 28478d1222771086-counting-how-often-duplicate-items-have-occured-copy-of-messing-around-2
Sheet: Sheet3

 | 8
[NAME] | 1
[NAME] | 1
[NAME] | 3
[NAME] | 1
[NAME] | 3
[NAME] | #N/A | [NAME] | 4
fred | #N/A | fred | 1
[NAME] | #N/A | [NAME] | 3 | 2
Spreadsheet: 717523d1612711323-combine-table-with-dsum-function-and-data-table-tool-color
Sheet: Sheet1

Product | Color | Sell |  | Product | Color | Sell
A | Blue | 100 |  |  |  |  |  |  | Please, without VBA & helper colomns
B | Green | 200 |  |  |  |  |  |  | I mean you can use range(E2:G2)
A | Blue | 300 |  |  | A | B | C
A | Blue | 400 |  | Blue |  | 0 | 100
B | Green | 500 |  | Green | 1400 | 700 | 0
A | Green | 600
C | Blue | 100
A | Green | 800 |  | Colored rang(F5:H6) is My Result
 |  |  |  | Tbl | =Sheet1!$A$1:$C$9
Spreadsheet: 122160d1316634490-countifs-countifsproblem
Sheet: Sheet1

Fruit 1 | Fruit 2 | Fruit 3 | This space is defined as "FruitArray"
Apples | Bananas | Pears
Peaches | Apples | Mango |  | I want to count the number of ROWS where either the word Apples OR Bananas occurs without receiving duplicate counting.
Mango | Star Fruit | Nectarines |  | so my "countifs" statement would return 7
Apples
 | Bananas
Mango
 | Star Fruit
 |  | Apples
Apples |  | Bananas
 | Mango
Apples | Bananas
Spreadsheet: 9cdc9f69-a29c-4557-9568-f2eacbe1513a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FSHOX | Test | FSHOX | SHOX-DNA-DxTM | SHOXDNAdx | Mutation analysis by PCR, DHPLC and sequencing as needed | EDTA (lavender-top) tube: EDTA |  |  | 3 | mL | 3 mL whole blood in EDTA (lavender top tube). Yellow top (ACD) is acceptable. Ship ambient. | Adult 3 mL Peds 1 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided.  Test Performed by:	Esoterix Endocrinology 			4301 Lost Hills Road 			Calabasas Hills, CA 91301 | Varies, Monday through Friday | 14 - 21 days | 16 - 25 days | 1 | 81479 |  |  |  |  | Esoterix Endocrinology
FSHOX | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient | 7 days
FSHOX | Result | Z2269 | SHOXDNAdx | SHOXDNAdx | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34500-9 | SHOX gene mutation analysis:Prid:Pt:Bld/Tiss:Nar:Molgen
Spreadsheet: 821944d1679001885-auto-determine-percentage-of-increase-over-14-year-period-compounded-markup-calculator
Sheet: Sheet1

Year | Old Price | New Price |  | [NAME] need each year | Percent of Increase
 | 40.25 | 58 |  | 1.0285 | 0.000285 | 1.0285 = | 0.000285
Year 1 |  | 2010
Year 2 |  | 2011
Year 3 |  | 2012
Year 4 |  | 2013
Year 5 |  | 2014
Year 6 |  | 2015
Year 7 |  | 2016
Year 8 |  | 2017
Year 9 |  | 2018
Year 10 |  | 2019
Year 11 |  | 2020
Year 12 |  | 2021
Year 13 |  | 2022
Year 14 |  | 2023
Spreadsheet: 291835d1390417169-automatically-copy-a-row-of-data-from-one-sheet-to-another-routsheet
Sheet: 1207

RO# | OWNERS NAME | TAG | ADVISOR | [NAME] OF WORK | PROMISE TIME | 10 | 12 | 2 | 4 | DISPATCH TIME
74964 | UCD | 14623A | 1026 | COOLANT | ASAP
2692 | [NAME] | 157 | 129 | RECALL | 3
26926 | KAHL | 162 | 129 | [NAME] | EOD
26928 | BONILLA | 878 | 1207 | BONILLA | WAIT
Spreadsheet: 582915d1532100881-detect-if-there-is-a-public-holiday-an-closes-collectively-holiday-in-row-kalender
Sheet: Feestdagen Verlofcodes

2018
Datum | Naam | Dag naam | [NAME]
 | Nieuwjaar
 | Paaszondag
 | Paasmaandag
 | Dag v/d Arbeid
 | Hemelvaartsdag
 | Pinksterzondag
 | Pinkstermaandag
 | Nationale Feestdag
 | [NAME]
 | Allerheiligen
 | Wapenstilstand 1918
 | Kerstmis
 | 2de Kerstdag
tot aantal feestdagen in weekend
Codes | Naam | Aantal Dagen
KD | [NAME] | 12
[NAME] VM | [NAME] voormiddag
KD NM | [NAME] namiddag | 0.5
[NAME] | Collectief verlof | 12
[NAME] | Collectief [NAME]
[NAME] | Collectief [NAME]
V | Verlof | 26
V VM | Verlof voormiddag
V NM | Verlof namiddag
Z | Ziek
SP | Sociale promotie
GV | Gelegenheidsverlof
GV VM | Gelegenheidsverlof voormiddag
GV NM | Gelegenheidsverlof namiddag
VN | Dienstvrijstelling
VN VM | Dienstvrijstelling voormiddag
VN NM | Dienstvrijstelling namiddag
ZD | Zending
ZD VM | Zending voormiddag
ZD NM | Zending namiddag
WO | Werkongeval | 3
STAKING | Staking
Spreadsheet: 26996d1219761016-sumif-with-multiple-criteria-not-sure-what-functions-to-use-trend-graph1-rev2
Sheet: data input

 |  | branch |  |  | by order type
 | date | st albans | sunbury | peterborough | st albans w | st albans ertf | sunbury w | sunbury ertf | [NAME] | [NAME]
 | 2008-06-23 00:00:00 | 21 | 13 | 13
 | 2008-06-24 00:00:00 | 18 | 9 | 20
 | 2008-06-25 00:00:00 | 21 | 6 | 8
 | 2008-06-26 00:00:00 | 25 | 7 | 15
 | 2008-06-27 00:00:00 | 17 | 12 | 10
 | 2008-06-28 00:00:00 | 1 | 2 | 0
 | 2008-06-29 00:00:00 | 2 | 0 | 2
Spreadsheet: 8c1dc6d9-03a4-46c5-8864-be54052fd4db
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
259002 | 13383 | Gabriele | Pelz | GER |  | 00:41:01 | 00:01:35 | 00:52:17 | 00:01:18 | 00:23:08 | 1 | 01:59:17
Spreadsheet: 7e622e07-2d23-467d-b04f-65bbff66b51e
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
COS | Test | COS | Cobalt, Serum | Cobalt, S | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 1.6 | mL | Collection Container/Tube: Plain, royal blue-top [NAME] plastic trace element blood collection tube, catalog #368380 (Supply T184) Submission Container/Tube: 7-mL Mayo metal-free, screw-capped, polypropylene vial (Supply T173) [NAME]: 1.6 mL Collection Instructions:  1. Allow the specimen to clot for 30 minutes; then centrifuge the specimen to separate serum from the cellular fraction. 2. Remove the stopper. Carefully pour specimen into a 7-mL Mayo metal-free, screw-capped, polypropylene vial, avoiding transfer of the cellular components of blood. Do not insert a pipet into the serum to accomplish transfer, and do not ream the specimen with a wooden stick to assist with serum transfer. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.4 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	NA | 0.0-0.9 ng/mL <10 ng/mL (MoM implant) Reference values apply to all ages. | Tuesday through Thursday; 8 a.m.-11 a.m. | 1 day | 5 days | 1 | 83018 |  |  |  |  | Rochester
COS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
COS | Result | 80084 | Cobalt, S | Cobalt, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 5627-5 | Cobalt:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 7b0d69c5-51a5-497e-87c7-a17c1e5a8c56
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
6934 | 28252 | Natalia | Skuratovich | RUS | 0 | 00:13:26 | 00:00:00 | 00:36:01 | 00:01:12 | 00:24:22 | 1 | 01:15:02
Spreadsheet: 86510d1286470116-auto-delete-cell-value-after-selection-from-list-new-microsoft-office-excel-worksheet
Sheet: BOM

Sr. No | Item Discrption | Make | Part Number | Qty | Unit Rate | Amount
1
Spreadsheet: 1e7c1c84-5422-4f26-b4b0-9584bb5574b5
Sheet: Sheet1

Table 9--Wheat:  U.S. exports, [NAME] and export sales comparison (1,000 metric tons),5/13/13 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | 2010/11 |  | 2011/12 |  | 2012/13 (as of 5/2/13)
Importing |  |  |  |  |  | Out-
country |  |  |  |  | Shipments | standing | Total
Data |  | Export |  | Export | Export
source | Census 1/ | sales 2/ | Census 1/ | sales 2/ | sales 2/
Country:
Japan | 3318.4 | 3273 | 3513.4 | 3512.1 | 3209 | 479.7 | 3688.7
Mexico | 2749.7 | 2601 | 3794.3 | 3495.9 | 2574 | 228.9 | 2802.9
Nigeria | 3638.2 | 3645.3 | 3227.8 | 3248 | 2659.9 | 293.4 | 2953.3
Philippines | 1814.5 | 1806.3 | 2050 | 2038.6 | 1773.6 | 106 | 1879.6
Korean Rep. | 1660.2 | 1640.2 | 2132.9 | 1983 | 1310.2 | 90.2 | 1400.4
Egypt | 3804.6 | 4021.2 | 915.5 | 949.8 | 1615 | 0 | 1615
Taiwan | 916.1 | 912.9 | 893.2 | 887.9 | 978.2 | 57.8 | 189.4
Indonesia | 762.9 | 781.4 | 794 | 830 | 501.2 | 0 | 501.2
Venezuela | 655.4 | 615.7 | 642.2 | 593.5 | 536.3 | 96.5 | 632.8
Iraq | 1083.2 | 1078.4 | 571.8 | 571.8 | 208.9 | 0 | 208.9
EU-27 | 1244.2 | 1307.6 | 1185.9 | 1228.1 | 878.4 | 29 | 907.4
Total grain | 34516.2 | 33438.5 | 27955.4 | 26627.3 | 23839.9 | 2928 | 26767.9
Total (including
products) | 35076 | 33485.9 | 28563 | 26812.5 | 23897.4 | 2942.3 | 26839.7
USDA forecast
of Census |  |  |  |  |  |  | 25174
1/ Source:  U.S. Department of Commerce, U.S. Census Bureau
2/ Source:  USDA, Foreign Agricultural Service, U.S. Export Sales.
Source:  USDA, Foreign Agricultural Service, U.S. Export Sales.
Spreadsheet: 870068d1716569800-grabbing-data-from-a-data-table-between-2-dates-excel-2010-tornadoes-between-dates
Sheet: Sheet1

Data Table |  |  |  |  |  |  |  |  |  |  |  |  | Start Date | 2021-07-01 00:00:00 | End Date | 2021-08-31 00:00:00 | # of Occurrences
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Desired Results
 | Date | Start Time | End Time | # of Counties | Counties | Length | [NAME] | Deaths | Injuries | Rating |  | Occurrences | Date | Start Time | End Time | # of Counties | Counties | Length | [NAME] | Deaths | Injuries | Rating |  | Occurrences | Date | Start Time | End Time | # of Counties | Counties | Length | [NAME] | Deaths | Injuries | Rating
 | 2020-07-19 00:00:00 | 23:50:00 | 23:57:00 | 1 | [NAME] (WI) | 3.65 | 200 | 0 | 0 | EF1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-14 00:00:00 | 16:34:00 | 17:02:00 | 1 | [NAME] (IA) | 12.02 | 60 | 0 | 0 | EF1
 | 2020-08-10 00:00:00 | 11:32:00 | 11:34:00 | 1 | Grant (WI) | 0.55 | 50 | 0 | 0 | EF0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-14 00:00:00 | 17:43:00 | 17:53:00 | 2 | [NAME] (IA), [NAME] (IA) | 3.18 | 30 | 0 | 0 | EF0
 | 2021-05-15 00:00:00 | 16:49:00 | 16:51:00 | 1 | Howard (IA) | 0.3 | 15 | 0 | 0 | EF0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-07 00:00:00 | 15:29:00 | 15:56:00 | 1 | Grant (WI) | 9.38 | 1100 | 0 | 0 | EF3
 | 2021-07-14 00:00:00 | 16:34:00 | 17:02:00 | 1 | [NAME] (IA) | 12.02 | 60 | 0 | 0 | EF1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-11 00:00:00 | 12:45:00 | 12:59:00 | 1 | [NAME] (WI) | 5.91 | 80 | 0 | 0 | EF1
 | 2021-07-14 00:00:00 | 17:43:00 | 17:53:00 | 2 | [NAME] (IA), [NAME] (IA) | 3.18 | 30 | 0 | 0 | EF0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-11 00:00:00 | 12:55:00 | 13:02:00 | 1 | [NAME] (WI) | 2.77 | 75 | 0 | 0 | EF1
 | 2021-08-07 00:00:00 | 15:29:00 | 15:56:00 | 1 | Grant (WI) | 9.38 | 1100 | 0 | 0 | EF3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-27 00:00:00 | 16:50:00 | 16:51:00 | 1 | [NAME] (IA) | 1.29 | 140 | 0 | 0 | EF0
 | 2021-08-11 00:00:00 | 12:45:00 | 12:59:00 | 1 | [NAME] (WI) | 5.91 | 80 | 0 | 0 | EF1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-27 00:00:00 | 16:51:00 | 16:54:00 | 1 | [NAME] (IA) | 2.19 | 90 | 0 | 0 | EF0
 | 2021-08-11 00:00:00 | 12:55:00 | 13:02:00 | 1 | [NAME] (WI) | 2.77 | 75 | 0 | 0 | EF1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-27 00:00:00 | 16:57:00 | 17:11:00 | 1 | [NAME] (IA) | 6.38 | 300 | 0 | 0 | EF1
 | 2021-08-27 00:00:00 | 16:50:00 | 16:51:00 | 1 | [NAME] (IA) | 1.29 | 140 | 0 | 0 | EF0
 | 2021-08-27 00:00:00 | 16:51:00 | 16:54:00 | 1 | [NAME] (IA) | 2.19 | 90 | 0 | 0 | EF0
 | 2021-08-27 00:00:00 | 16:57:00 | 17:11:00 | 1 | [NAME] (IA) | 6.38 | 300 | 0 | 0 | EF1
 | 2021-09-20 00:00:00 | 15:47:00 | 15:56:00 | 1 | Olmsted (MN) | 5.66 | 100 | 0 | 0 | EF0
 | 2021-09-20 00:00:00 | 16:56:00 | 17:11:00 | 1 | [NAME] (WI) | 8.49 | 100 | 0 | 1 | EF1
 | 2021-12-15 00:00:00 | 18:53:00 | 18:57:00 | 2 | Butler(IA), [NAME] (IA) | 4.17 | 200 | 0 | 0 | EF1
Spreadsheet: 829090d1683903294-financial-modelling-staffing-inputs-how-to-toggle-both-starters-and-leavers-excel-staffing-workings-for-starters-and-leavers
Sheet: Sheet1

 | TEST |  |  |  |  |  |  |  |  |  |  |  | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-27 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00
 | STAFFING INPUT |  |  |  |  |  |  |  |  |  |  |  | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023
 |  |  |  |  |  |  |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | [NAME] | Start Date | Leave Date | Title | Status | Pay Type | [NAME] | Location | Salary | Medical |  |  | Headcount
1 | CFO | 2023-08-31 00:00:00 | 2023-10-31 00:00:00 |  | Permanent | Salary | Y |  | 100000