tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0094e62b-83ad-41dc-a935-a99c47b6f019
Sheet: Example 1

DEPARTMENT NUMBER: |  |  |  | PERIOD ENDING |  | 2013-06-14 00:00:00 |  |  | V - VACATION |  |  |  | VF - VACATION FMLA
 |  |  |  |  |  |  |  |  | S - ILLNESS WITH PAY |  |  |  | SF - SICK FMLA
DEPARTMENT NAME: |  |  |  |  |  |  |  |  | P - PERSONAL LEAVE |  |  |  | PF - PERSONAL FMLA
 |  |  |  |  |  |  |  |  | H - HOLIDAY |  |  |  | [NAME] DUTY
APPROVED BY: |  |  |  |  |  |  |  |  | LT - LOST TIME |  |  |  | LF - FMLA
eSIGNATURE: |  |  |  |  |  |  |  |  | UC - UNSCHEDULED CLOSING |  |  |  | FL -FUNERAL LEAVE
 |  |  |  |  |  |  |  |  |  | ** FOR PAYROLL USE ONLY **
EMPLOYEE NAME
EMPLOYEE NUMBER |  |  | SAT | SUN | MON | TUES | WED | THUR | FRI |  | REG.HRS. | VAC. | SICK |  | OT.
Last, First | WK. 1 | Start Time |  |  | 08:30:00 | 08:30:00 |  | 08:30:00
 |  | End Time |  |  | 5:00PM | 5:00PM |  | 5:00PM
 |  | Lunch Period |  |  | 1 hour | 1 hour |  | 1 hour
 |  | Worked Hrs |  |  | 7.5 | 7.5 |  | 7.5
 |  | Non-Worked Hrs |  |  |  |  | 3.75 S, 3.75 V |  | 7.5 V
123456
 |  |  | SAT | SUN | MON | TUES | WED | THUR | FRI |  | REG.HRS. | VAC. | SICK |  | OT.
 | WK. 2 | Start Time |  |  | 08:30:00 | 08:30:00 | 08:30:00 | 08:30:00 | 08:30:00
 |  | End Time |  |  | 12:00PM | 5:00PM | 5:00PM | 7:00PM | 3:00PM
 |  | Lunch Period |  |  | 1 hour | 1 hour | 1 hour | 1 hour | 1 hour
 |  | Worked Hrs |  |  | 3.5 | 7.5 | 7.5 | 9.5 | 5.5
 |  | Non-Worked Hrs |  |  | 4.0 S
Spreadsheet: 705522d1606164055-reformatting-data-table-to-be-more-export-friendly-datacleanexample
Sheet: Sheet1

 | ORIGINAL
 | First Name | Last Name | Location | Fav Color | Food1 | Food2 | Food3 | Food4 | Food5
 | [NAME] | Smith | US | Black | Oranges | Bananas | Eggplant | Pumpkin
 | April | Jones | China | [NAME] | Lettuce | Eggs | Milk | Bread | Onions
 | [NAME] | Little | Belgium | Blue | Bagels | Bread | Tomatoes
 | DESIRED
 | First Name | Last Name | Food
 | [NAME] | Smith | Oranges
 | [NAME] | Smith | Bananas
 | [NAME] | Smith | Eggplant
 | [NAME] | Smith | Pumpkin
 | [NAME] | Smith | -
 | April | Jones | Lettuce
 | April | Jones | Eggs
 | April | Jones | Milk
 | April | Jones | Bread
 | April | Jones | Onions
 | [NAME] | Little | Bagels
 | [NAME] | Little | Bread
 | [NAME] | Little | Tomatoes
 | [NAME] | Little | -
 | [NAME] | Little | -
Spreadsheet: vkaminski__40853__ModelingProject
Sheet: Schwartz

 | Input Parameters |  |  | Computation |  |  |  |  | Mean Reversion Rate
 | F | 100 |  | P(t,T) |  |  |  |  | 0.01 | 0.1 | 1
 | K | 95 |  | w |  |  | Futures Prices | 20 |  | 0.04961610049983981 | 8.589497666021132e-05
 | r | 0.05 |  | h1 |  |  |  | 25 | 0.2243206027724423 | 0.1600668741740539 | 0.001122014762402865
 | t | 0 |  | h2 |  |  |  | 30 | 0.507779498078941 | 0.385032821677468 | 0.007302097324493525
 | s | 1.5 |  | N(h1) |  |  |  | 35 | 0.9653134813568948 | 0.7661828063023419 | 0.03045727105746342
 | T | 0.75 |  | N(h2) |  |  |  | 40 | 1.626445227968833 | 1.337550946608914 | 0.09379123343618155
 | σ | 0.5 |  | Call |  |  |  | 45 | 2.510603963844408 | 2.123762393548695 | 0.2324781025367195
 | α | 0.01 |  | Put |  |  |  | 50 | 3.628257720905385 | 3.140237840412092 | 0.4905892874657891
 |  |  |  |  |  |  |  | 55 | 4.982584948860019 | 4.394381337503985 | 0.9157104214340646
 |  |  |  |  |  |  |  | 60 | 6.571187443558656 | 5.887115132001039 | 1.553182397554303
 |  |  |  |  |  |  |  | 65 | 8.38761984919232 | 7.614412440379216 | 2.441437424735057
 |  |  |  |  |  |  |  | 70 | 10.42265959538541 | 9.568663803545327 | 3.609107443711081
 |  |  |  |  |  |  |  | 75 | 12.66531422596883 | 11.73981857079325 | 5.073925199612086
 |  |  |  |  |  |  |  | 80 | 15.10357491220513 | 14.11629261640181 | 6.843065515348032
 |  |  |  |  |  |  |  | 85 | 17.72494831809307 | 16.68560694726881 | 8.914449179222377
 |  |  |  |  |  |  |  | 90 | 20.51693902597025 | 19.43498272166677 | 11.27854711201047
 |  |  |  |  |  |  |  | 95 | 23.4672897225071 | 22.35168657771072 | 13.92016956971738
 |  |  |  |  |  |  |  | 100 | 26.56417820495932 | 25.4232866211014 | 16.82037431187652
 |  |  |  |  |  |  |  | 105 | 29.79634490140018 | 28.63783632109107 | 19.9579559382129
 |  |  |  |  |  |  |  | 110 | 33.15316671413706 | 31.98398995885657 | 23.3108038494081
 |  |  |  |  |  |  |  | 115 | 36.62469255459367 | 35.45106817570591 | 26.85676653831826
 |  |  |  |  |  |  |  | 120 | 40.2016568149974 | 39.02911080861744 | 30.57444838789673
 |  |  |  |  |  |  |  | 125 | 43.87549414864694 | 42.70886904657386 | 34.4436773493863
 |  |  |  |  |  |  |  | 130 | 47.63826886153468 | 46.48176765440981 | 38.44578863100903
 |  |  |  |  |  |  |  | 135 | 51.48266812342553 | 50.33990661075622 | 42.56377311012658
 |  |  |  |  |  |  |  | 140 | 55.40197096431877 | 54.27602599102425 | 46.78232242420722
Spreadsheet: 287058d1388606866-generating-custom-timeline-on-separate-tab-help_example
Sheet: Daily Log

Date | State | Org | Truck Type | ID | F/ID | Null
2013-09-18 00:00:00 | IL | AWS | Mack | 119
2013-09-18 00:00:00 | IL | AWS | Ford | 104
2013-09-18 00:00:00 | WI | CLE | Peterbuilt | 66
2013-09-18 00:00:00 | WI | CLE | [NAME] | 69
2013-09-18 00:00:00 | MD | WM | Freightliner | 556
2013-09-18 00:00:00 | VA | WM | Freightliner | 1573
2013-09-18 00:00:00 | VA | KWS | Chevy | 2146
 |  |  |  |  |  | x
2013-09-19 00:00:00 | IL | AWS | Ford | 104
2013-09-19 00:00:00 | WI | CLE | Peterbuilt | 2166 | 66
2013-09-19 00:00:00 | WI | CLE | [NAME] | 69
2013-09-19 00:00:00 | MD | WM | Freightliner | 556
2013-09-19 00:00:00 | VA | WM | Freightliner | 1573
2013-09-19 00:00:00 | VA | KWS | Chevy | 2146
 |  |  |  |  |  | x
2013-09-20 00:00:00 | IL | AWS | Ford | 104
2013-09-20 00:00:00 | WI | CLE | Peterbuilt | 2166 | 66
2013-09-20 00:00:00 | MD | WM | Freightliner | 590
2013-09-20 00:00:00 | VA | KWS | Chevy | 2366
 |  |  |  |  |  | x
Spreadsheet: 03f050e0-3a09-4380-9615-4dd4fed953c9
Sheet: Sheet1

Arrest Table | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Arrests for Drug Abuse Violations
Percent Distribution by Region, 2011
Drug abuse violations |  | United States total | Northeast | Midwest | South | West
Total1 |  | 100 | 100 | 100 | 100 | 100
Sale/Manufacturing: | Total | 18.2 | 21.8 | 19.4 | 17.3 | 16.6
 | [NAME] or cocaine and their derivatives | 6.3 | 11.5 | 4.3 | 5.8 | 4.8
 | [NAME] | 6.2 | 6.5 | 9.2 | 5 | 5.7
 | Synthetic or manufactured drugs | 1.8 | 1.6 | 1.4 | 3 | 0.6
 | Other dangerous nonnarcotic drugs | 4 | 2.2 | 4.4 | 3.4 | 5.6
Possession: | Total | 81.8 | 78.2 | 80.6 | 82.7 | 83.4
 | [NAME] or cocaine and their derivatives | 16.7 | 16.6 | 10.4 | 14.4 | 23.9
 | [NAME] | 43.3 | 48.5 | 52.1 | 51.3 | 23.5
 | Synthetic or manufactured drugs | 4.6 | 3.2 | 4.8 | 6 | 3.4
 | Other dangerous nonnarcotic drugs | 17.2 | 9.9 | 13.3 | 11.1 | 32.6
1 Because of rounding, the percentages may not add to 100.0.
Spreadsheet: 157651d1337817732-cumulative-probability-question-which-is-correct-excel-forum-cummulative-probability-question
Sheet: Sheet1

 |  | A | B
1 | 0.01 | 0.01 | 0.01
2 |  |  |  |  | 0.03 | Growth-rate
3
4
5
6
7
8
9
10
Spreadsheet: 1340fa74-5cec-4d8c-ad8b-184f08d25242
Sheet: Sheet1

CAPITAL PROJECT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Ordinance Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
Is this ordinance for the following: |  |  |  | x | New Construction
 |  |  |  |  | Replacement
 |  |  |  |  | Repair
Was this project programmed in the Five-Year Capital Improvement Plan? |  |  |  |  |  |  |  | No |  | x | Yes
 | If yes, please identify year in which this project was funded. |  |  |  |  |  | FY | 2012
 | If no, please detail the reasons why this project was not included and need for present funding request.
Does this project leverage non-city funds for design/construction? |  |  |  |  |  |  | x | No |  |  | Yes
 | If yes, please identify source and amount.
 | Source of Funds:
 | Year Funded:
 | Amount of Non-City Funds: |  |  | $
 | If no, please identify source and amount of city funds.
 | Acct #: |  |  |  | 12-3398 & 12-3090
 | Name of Fund: |  |  |  | Bond and [NAME]
 | Year Funded: |  |  |  | 2012
 | Amount of City Funds: |  |  |  | $1,681,102 & $13,749,437.05
If ordinance is for new construction or replacement of asset please provide the following information:
 | Total estimated costs (design through construction): |  |  | $ | 33000000
 | Estimated lifespan of project in years |  |  |  | 25
 | Estimated annual operating and maintenance costs |  |  | $ | 20000
 | (Please detail type of maintenance or operating costs needed, additional staffing, capital maintenance costs, utilities, etc.)
 | Street maintenance
Are these O&M costs reflected in the current budget? |  |  |  |  |  |  |  | No |  | x | Yes
 | If yes, please please provide source of funds. |  |  |  | Street maintenance
 | If no, please identify year in which additional operating and maintenance costs will be needed. |  |  |  |  |  |  |  |  |  | FY
Reference Numbers: (Previously approved legislation):
Reviewed by:
 |  |  |  |  |  | OMB Approval Date
Spreadsheet: 808483d1670492340-combine-2-sheets-grade-6
Sheet: WAVULANA 5 BORA NA 5 DUNI

HALMASHAURI YA WILAYA [NAME]
MATOKEO YA MTIHANI WA KUMALIZA  MUHULA WA PILI DARASA LA V NOVEMBA,2022
[NAME] BORA
NA | JINA | JINSI 1=MV 2= MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
H.WAVULANA 5 DUNI
NA | JINA | JINSI 1=MV 2= MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
Spreadsheet: 770129d1645818210-replacing-offset-to-sum-up-to-max-value-from-specific-cell-tracking-eba
Sheet: Sheet1

Steps | Time | [NAME] (INPUT) | Sume of Steps (RESULT) | Count (RESULT)
2800N1 | 5 | 2800N1 | 14 | 2
2800N2 | 8 | [NAME] (INPUT)
2800N3 | 4 | 40
2800N4 | 10
2800N5 | 10
2800N6 | 10
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: 5HR

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty
5HR ENRGY BERY 12/16Z CN | 10074
5HR ENRGY GRPE 12/16Z CN | 10073
5HR ENRGY WTRM 12/16Z CN | 10072
5HR ENRGY PNAP 12/16Z CN | 10951
5HR ENRGY TROP 12/16Z CN | 10952
5HR ENRGY ORNG 12/16Z CN | 10950
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
5HR ENRGY BERY 12/16Z CN | 10074
5HR ENRGY GRPE 12/16Z CN | 10073
5HR ENRGY WTRM 12/16Z CN | 10072
5HR ENRGY PNAP 12/16Z CN | 10951
5HR ENRGY TROP 12/16Z CN | 10952
5HR ENRGY ORNG 12/16Z CN | 10950
Spreadsheet: dcbab330-5c3a-4c90-a179-7ee5060f70bc
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
MELAI | Test | MELAI | Melaleuca leucadendron, IgE | Melaleuca Leucadendron, 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
MELAI | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
MELAI | Result | MELAI | Melaleuca Leucadendron, IgE | Melaleuca Leucadendron, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6171-3 | Melaleuca [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: stacey_white__39152__UBS Book List
Sheet: original as of 1.28

Netco East Power
Book Organization
[NAME] |  | Netco Power Book Name |  | Old EPMI Power Book Name |  | Netco Gas Book Name |  | Old EPMI Gas Book Name |  | Region
[NAME] |  | NETCO-LT-MGMT |  | EPMI-LT-MGMT |  | PWR-GAS-MGMT |  | PWR-GAS-LT-MGMT |  | All
[NAME] |  | NETCO-LT-OPTION |  | EPMI-LT-OPTION |  | PWR-GAS-OPTION |  | PWR-GAS-LT-OPTION |  | Option
[NAME] |  | NETCO-LT-OPTIONA |  | EPMI-LT-OPTIONA |  |  |  |  |  | Option
[NAME] |  | NETCO-LT-OPTIONB |  | EPMI-LT-OPTIONB |  |  |  |  |  | Option
[NAME] |  | NETCO-LT-OPTIONC |  | EPMI-LT-OPTIONZ |  |  |  |  |  | Option
[NAME] |  | NETCO-LT-NEMGMT |  | EPMI-LT-NEMGMT |  | PWR-GAS-NE |  | PWR-NE-GAS-MTM |  | Northeast
[NAME] |  | NETCO-LT-PJM |  | EPMI-LT-PJM |  |  |  |  |  | Northeast
[NAME] |  | NETCO-ST-NENG |  | EPMI-ST-NENG |  |  |  |  |  | Northeast
[NAME] |  | NETCO-ST-PJM |  | EPMI-ST-PJM |  |  |  |  |  | Northeast
[NAME] |  | NETCO-HRLY-NY |  | EPMI-ST-NY |  |  |  |  |  | Northeast
[NAME] |  | NETCO-OFF-NE |  | EPMI-NE-PHYS |  |  |  |  |  | Northeast
Narsimha Misra |  | NETCO-ST-NY |  | none |  |  |  |  |  | Northeast
[NAME] |  | NETCO-HRLY-PJM |  | EPMI-HRLY-PJM |  |  |  |  |  | Northeast
[NAME] |  | NETCO-HRLY-NENG |  | EPMI-HRLY-NENG |  |  |  |  |  | Northeast
[NAME] |  | NETCO-HRLY-NY |  | EPMI-HRLY-NY |  |  |  |  |  | Northeast
[NAME] |  | NETCO-MIDWEST |  | EPMI-MIDWEST |  | PWR-GAS-MW |  | PWR-MW-GAS-MTM |  | Midwest
[NAME] |  | NETCO-ST-CIN |  | EPMI-ST-ECAR |  |  |  |  |  | Midwest
[NAME] |  | NETCO-ST-COMED |  | EPMI-ST-COMED |  |  |  |  |  | Midwest
[NAME] |  | NETCO-HRLY-MW |  | EPMI-HRLY-MW |  |  |  |  |  | Midwest
[NAME] |  | NETCO-SOUTHEAST |  | EPMI-SOUTHEAST |  | PWR-GAS-SE |  |  |  | Southeast
[NAME] |  | NETCO-LT-SOCO |  | EPMI-LT-SERC |  |  |  |  |  | Southeast
[NAME] |  | NETCO-LT-SPP |  | EPMI-LT-SPP |  |  |  |  |  | Southeast
[NAME] |  | NETCO-HRLY-SE |  | EPMI-HRLY-SE |  |  |  |  |  | Southeast
[NAME] |  | NETCO-ERCT-MGMT |  | EPMI-ERCT-MGMT |  | PWR-GAS-ERCOT |  | PWR-NG-TEXAS |  | [NAME]
[NAME] |  | NETCO-LT-ERCOT |  | EPMI-LT-ERCOT |  |  |  |  |  | [NAME]
[NAME] |  | NETCO-ST-ERCOT |  | EPMI-ST-ERCOT |  |  |  |  |  | [NAME]
[NAME] |  | NETCO-OFF-ERCOT |  | EPMI-ERCOT-OFF |  |  |  |  |  | [NAME]
[NAME] |  | NETCO-HRLY-ERCOT |  | EPMI-ERCOT-ASST |  |  |  |  |  | [NAME]
Spreadsheet: 34a028ab-f027-49d6-acaa-9fbf28b45cf1
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43209645 | 2014-09-18 13:15:39 | AXIS | 1 | 7 | 6 | 464498 | gizzzmo | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43209797 | 2014-09-18 13:38:23 | ALLIES | 0 | 3 | 7 | 464498 | gizzzmo | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43210383 | 2014-09-18 14:43:50 | ALLIES | 0 | 5 | 6 | 1362585 | NEMAUS | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
43210493 | 2014-09-18 15:05:43 | AXIS | 0 | 3 | 6 | 1362585 | NEMAUS | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
43210661 | 2014-09-18 15:23:16 | ALLIES | 0 | 5 | 6 | 1362585 | NEMAUS | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
43210810 | 2014-09-18 15:36:20 | AXIS | 1 | 6 | 3 | 1362585 | NEMAUS | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
Spreadsheet: 807873d1670122090-i-need-to-combine-two-different-sheets-analysis-6
Sheet: SHEET2

B. MPANGILIO WA UFAULU WA WANAFUNZI KIMASOMO
SHULE |  |  | KALOLENI |  |  |  |  |  | DARASA |  |  |  |  | VI
NA | SOMO | USAJILI |  |  |  | IDADI [NAME] KWA MADARAJA YA UFAULU |  |  |  |  |  |  | WASIOFAULU |  |  |  | % WASIOFAULU
 |  | WALIOFANYA |  | WALIOFAULU |  | A |  | B |  | C |  | %[NAME] | D |  | E
 |  | WV | WS | WV | WS | WV | WS | WV | WS | WV | WS |  | WV | WS | WV | WS
1 | HISABATI
2 | KISWAHILI
3 | KIINGEREZA
4 | SAYANSI & TEKNOLOJIA
5 | [NAME]
8 | URAIA NA MAADILI
7 | S/KAZI
Spreadsheet: 81287d1281529721-link-cells-from-table-in-list-form-timetable-model
Sheet: Class 1d

2010-08-23 00:00:00
Spreadsheet: 167983d1342178848-sumproduct-with-date-restrictions-book1_jayres14
Sheet: Trips Totals

 | 2009 |  |  |  | 2010
Region | 1st QTR | 2nd QTR | 3rd QTR | 4th QTR | 1st QTR | 2nd QTR | 3rd QTR | 4th QTR
West | 1 | 0 | 1 | 1 | 1 | 1 | 0 | 1
Midwest | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 0
South | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Northeast | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pacific | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2011 |  |  |  | 2012
Region | 1st QTR | 2nd QTR | 3rd QTR | 4th QTR | 1st QTR | 2nd QTR | 3rd QTR | 4th QTR
West | 0 | 0 | 2 | 1 | 1 | 1 | 0 | 1
Midwest | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0
South | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0
Northeast | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pacific | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 2009 | < Select Year from Dropdown
 |  | State 1 | State 2 |  | 1st QTR | 2nd QTR | 3rd QTR | 4th QTR
 |  | CA | OR |  | 1 | 0 | 0 | 0
 |  | NV | NV |  | 0 | 0 | 0 | 0
 |  | OK, TX | TX, OK |  | 0 | 0 | 0 | 0
 |  | KS, NE | NE, KS |  | 0 | 0 | 1 | 1
 | CA & OR Total
 | 4 |  | but I want to be able to find it based on year and quarter as well. [NAME] I used is below
 | *(=SUMPRODUCT(--(ISNUMBER(SEARCH("CA",Trips!A:A))+ISNUMBER(SEARCH("OR",Trips!A:A))>0))
Spreadsheet: 07d77b8d-de94-4f2d-b1b3-8b0a1bac37f5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Utah Menu Production Work Sheet | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21
Date: |  |  |  |  |  |  |  |  |  | NEW Food Based Menu Planning--Lunch |  |  |  |  |  |  |  | Reimbursable Meal Counts
 |  |  |  |  | Meat svgs |  |  |  |  |  |  | Grain svgs |  |  |  |  |  | Grade Group | Planned | Actual
School: |  |  |  |  |  | Weekly |  | Veg svgs |  | Fruit svgs |  |  | Weekly |  | Milk |  |  | PreK
 |  |  |  | Grade | Daily | Min | [NAME] | Daily | Weekly | Daily | Weekly | Daily | Min | [NAME] | Daily | Weekly |  | K-5
Offer [NAME]?    Yes____ No____ |  |  |  | PreK | 1/2 (oz eq) |  |  | 1/2 C |  | 1/2 C |  | 1/2 serv |  |  | 6 oz |  |  | 6-8
Grades: |  |  |  | K-5 | 1 (oz eq) | 8 (oz eq) | 10(oz eq) | 3/4 C | 3 3/4 C | 1/2 C | 2 1/2 | 1 (oz eq) | 8 (oz eq) | 9 (oz eq) | 1 C | 5 C |  | 9-12
Seconds/A la Carte?  Yes____ No_____ |  |  |  | 6-8 | 1 (oz eq) | 9 (oz eq) | 10(oz eq) | 3/4 C | 3 3/4 C | 1/2 C | 2 1/2 | 1 (oz eq) | 8 (oz eq) | 10(oz eq) | 1 C | 5 C |  | Adults
 |  |  |  | 9-12 | 2 (oz eq) | 10 (oz eq) | 12(oz eq) | 1 C | 5 C | 1 C | 5 C | 2 (oz eq) | 10 (oz eq) | 12(oz eq) | 1 C | 5 C |  | Total
Menu                                                (include within the description Recipe No. or Brand and product name) |  |  | Quantity Prep (# of servings, pounds, cans) | Serving Temperature | PreK |  |  | Grades: |  |  | Grades: |  |  | Grades: |  |  | Adults/ a la carte: |  | Total
 |  |  |  |  | Serving Size | Planned Servings | Meal Pattern Contribution | Serving Size | Planned Servings | Meal Pattern Contribution | Serving Size | Planned Servings | Meal Pattern Contribution | Serving Size | Planned Servings | Meal Pattern Contribution | Serving Size | Planned Servings | Reimbursable Served | Seconds/ a la Carte Sold | Leftover/ Comments
Meat/Meat Alternate
Vegetables: DG, RO, BP (legumes), S, O -- Identify in Component Column
Fruits
Grain/Bread: þ  if [NAME] rich in Component Column
Other Foods (Condiments, etc.)
Milk 1%  or Fat Free (2 varieties per day)
Subgroup Legend: DG (dark green), RO (red, orange), BP (Beans/Peas), S (Starchy), O (Other)
*** Reminder: Make sure to document Special Diet Meals and Substitutions.
***For substitutions use nutritionally equivalent food and date when the substitutions was know.
Spreadsheet: 269145d1380983298-conditional-formulas-in-excel-calculating-with-dates-age-and-affiliation-date-calculus-age-and-subscription-date-calculator
Sheet: Sheet1

Last Name
First Name
Employee ID
Cost Center
Enter Date of Birth | 1970-06-21 00:00:00
Enter Date in Service | 2013-10-01 00:00:00
Today
Current age
Age at the day of entry in service
Time in Service till Today
EE is 6 months in service as of
Date of 25th Birthday
Date of 65th Birthday
EE is younger than 25 today
EE is younger than 25 on date of entry in service
EE is older than 25 today
EE is older than 25 at day of entry in service
EE is younger than 25 at day of entry in service
EE reaches 25th Birthday before 6 months of service |  |  | 1. This formula is wrong
Choose: | X Affiliation as of
EE is older than 25 at day of entry in service - Yes
EE is younger than 25 at day of entry in service - Yes
But use this one IF EE reaches 25th birthday before being in 6 months of service - TRUE |  |  | This formula could use a tweak to only take in account Employees as of the age of 18
Choose: | Y Affiliation as of
EE is older than 25 at day of entry in service - Yes |  |  | 2. Add condition if date of entry in service is the first of the month then Y affiliation as of the first of that month
EE is younger than 25 at day of entry in service - Yes
But use this one IF EE reaches 25th birthday before being in 6 months of service - TRUE
Spreadsheet: 153895d1336089460-excel-formula-to-adjust-to-data-entered-hb062609
Sheet: Spotted Cars (Test)

Date | Spotted Car # at Facility | PO or Rail BOL | Quantity [NAME] (tn) | Quantity [NAME] (lb) | Material | Net Unloaded | Shrinkage
2012-03-27 00:00:00 | DSIX 1234 |  |  |  | XYZ123
2012-03-27 00:00:00 | DSIX 5678 |  |  |  | XYZ123
2012-03-27 00:00:00 | DSIX 9000 |  |  |  | XYZ123
2012-03-27 00:00:00 | DSIX 1000 |  |  |  | XYZ123
2012-03-28 00:00:00 | DSIX 1234 |  |  |  | XYZ123
2012-03-28 00:00:00 | DSIX 5678 |  |  |  | XYZ123
2012-03-28 00:00:00 | DSIX 9000 |  |  |  | XYZ123
2012-03-28 00:00:00 | DSIX 1000 |  |  |  | XYZ123
2012-03-29 00:00:00 | DSIX 1234 |  |  |  | XYZ123
2012-03-29 00:00:00 | DSIX 5678 |  |  |  | XYZ123
2012-03-29 00:00:00 | DSIX 9000 |  |  |  | XYZ123
2012-03-29 00:00:00 | DSIX 1000 |  |  |  | XYZ123
2012-03-30 00:00:00 | DSIX 1234 |  |  |  | XYZ123
2012-03-30 00:00:00 | DSIX 5678 |  |  |  | XYZ123
2012-03-30 00:00:00 | DSIX 9000 |  |  |  | XYZ123
2012-03-30 00:00:00 | DSIX 1000 |  |  |  | XYZ123
2012-03-31 00:00:00 | DSIX 1234 |  |  |  | XYZ123
2012-03-31 00:00:00 | DSIX 5678 |  |  |  | XYZ123
2012-03-31 00:00:00 | DSIX 9000 |  |  |  | XYZ123
2012-03-31 00:00:00 | DSIX 1000 |  |  |  | XYZ123
2012-04-01 00:00:00 | DSIX 1234 |  |  |  | XYZ123
2012-04-01 00:00:00 | DSIX 5678 |  |  |  | XYZ123
2012-04-01 00:00:00 | DSIX 9000 |  |  |  | XYZ123
2012-04-01 00:00:00 | DSIX 1000 |  |  |  | XYZ123