tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: a26c170e-925e-49b8-889e-2d2171220904
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | On line sales of digital GIS data |  |  |  | Allow for e-commerce sales of digital GIS data
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor | Information Technology Department
 |  |  |  |  | Programs, | Information Technology Department, City Planning and Development, Water Services, Public Works, and other City departments who use or create digital GIS data.
 |  |  |  |  | Departments,
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  |  |  | None Known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  |  |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact |  |  | No direct increase or decrease
 |  |  |  |  |  |  |  | of current revenues is expected
 |  |  |  |  |  |  |  | due to electronic sales. Current
 |  |  |  |  |  |  |  | revenue account listed
 |  |  |  |  |  |  |  | below.
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes |  |  | 3230-187010
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
Fact Sheet Prepared by:
 | Name [NAME] |  | Date
 | Title CIO
Reviewed by:
 | Name [NAME] |  | Date
 | Title CIO
Reference Numbers
Spreadsheet: 789467d1659106125-hlook-up-not-working-last-man-standing
Sheet: week 1

 | Week 1
 | NAME | TEAM
Spreadsheet: 474886d1470945439-how-to-create-mutiple-hyperlinks-at-once-before
Sheet: Sheet1

CORNER ID | Index_WI_ID | CORNER TYPE | Type Found | Type Set | Date | Mer | Town | Range | Sect | NORTHING | EASTING | SPACIAL REF SYSTEM | COORDINATE DATE | COORDINATE METHOD | horizontal accuracy | Vertical Accuracy | Comments | tie sheets | Volume | Page start | Page end
44205310020 | 44205310020 |  | None | BC | 1973-05-17 00:00:00 | 4 | 42 | 5 | 31 |  |  |  |  |  |  |  |  |  | 1 | 1 | 1
44205310020 | 44205310020 |  | None | ? | 2000-06-01 00:00:00 | 4 | 42 | 5 | 31 |  |  |  |  |  |  |  |  |  | 1 | 2 | 2
44105060020 | 44105060020 |  | ? | ? | 1973-05-17 00:00:00 | 4 | 41 | 5 | 6 |  |  |  |  |  |  |  |  |  | 1 | 3 | 3
44105060020 | 44105060020 |  | None | IP | 1973-05-17 00:00:00 | 4 | 41 | 5 | 6 |  |  |  |  |  |  |  |  |  | 1 | 3 | 3
44105060000 | 44105060000 |  | ? | IP | 1973-05-17 00:00:00 | 4 | 41 | 5 | 6 |  |  |  |  |  |  |  |  |  | 1 | 4 | 4
44105060000 | 44105060000 |  | ? | ? | 1973-05-17 00:00:00 | 4 | 41 | 5 | 6 |  |  |  |  |  |  |  |  |  | 1 | 4 | 4
44105062000 | 44105062000 |  | IP | None | 1973-05-17 00:00:00 | 4 | 41 | 5 | 6 |  |  |  |  |  |  |  |  |  | 1 | 5 | 5
44105062000 | 44105062000 |  | ? | ? | 1973-05-17 00:00:00 | 4 | 41 | 5 | 6 |  |  |  |  |  |  |  |  |  | 1 | 5 | 5
44205100000 | 44205100000 |  | None | IP | 1994-01-06 00:00:00 | 4 | 42 | 5 | 10 |  |  |  |  |  |  |  |  |  | 1 | 6 | 6
44109210000 | 44109210000 |  | ? | ? | 1979-09-30 00:00:00 | 4 | 41 | 9 | 21 |  |  |  |  |  |  |  |  |  | 1 | 7 | 8
44109220000 | 44109220000 |  | ? | ? | 1979-09-30 00:00:00 | 4 | 41 | 9 | 22 |  |  |  |  |  |  |  |  |  | 1 | 7 | 8
44109220020 | 44109220020 |  | ? | ? | 1974-04-08 00:00:00 | 4 | 41 | 9 | 22 |  |  |  |  |  |  |  |  |  | 1 | 7 | 8
44109270000 | 44109270000 |  | ? | ? | 1997-07-08 00:00:00 | 4 | 41 | 9 | 27 |  |  |  |  |  |  |  |  |  | 1 | 7 | 8
44109270020 | 44109270020 |  | ? | ? | 1979-10-01 00:00:00 | 4 | 41 | 9 | 27 |  |  |  |  |  |  |  |  |  | 1 | 7 | 8
44109272000 | 44109272000 |  | ? | ? | 1974-04-08 00:00:00 | 4 | 41 | 9 | 27 |  |  |  |  |  |  |  |  |  | 1 | 7 | 8
44109280000 | 44109280000 |  | ? | ? | 1979-10-01 00:00:00 | 4 | 41 | 9 | 28 |  |  |  |  |  |  |  |  |  | 1 | 7 | 8
44109281000 | 44109281000 |  | ? | ? | 1974-04-08 00:00:00 | 4 | 41 | 9 | 28 |  |  |  |  |  |  |  |  |  | 1 | 7 | 8
Spreadsheet: 155129d1336676732-how-to-consolidate-different-excel-sheets-opportunity-list-sample
Sheet: Topsy's Opportunity List

 |  |  |  |  |  |  |  |  |  |  |  | FY 2012
Region / BU | Industry | # | Customer | Description (new products, new segments; prod. spec. process/codes not yet completed/available) | Annual Volume Potential (tons) | Annual Revenue Potential (k€) | First Detected | Start of Business | Key Competitor | Prob. (%) | Fcsted? (Y/N) | Volume (tons) | Revenue (k€) | Prob. (%) | [NAME]k€) | Fcsted? (Y/N) | Bdgted? (Y/N) | Opps / Risks (k€)
KAM | Baking | 1 | Coca Cola | Vanish MAC | 20-30 | 2000-3000 | 2009-06-01 00:00:00 | 2010-06-01 00:00:00 | Animal | 0.9 | Y, partly | 12 | 1194 | 0.95 |  | Y, partly | Y | -340
EMEA | Baking | 2 | Pepsi | Vanish XL | 200 | 2000 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | Unknown | 0.7 | N | 150 | 1500 | 0.7 |  | N | Y | 1050
EMEA | Baking | 3 | Stella Artois | Vanish [NAME], [NAME], [NAME] |  | 1000 | 2010-11-01 00:00:00 |  | Unknown |  | N |  |  |  | 500 | N | Y
NAM | P&P | 4 | Pils | Feather R | 84 | 500 | 2010-09-01 00:00:00 | TBC | Unknown | 0.99 | Y | 72 | 500 | 0.99 |  | Y | Y | 200
F&S | Specialities | 5 | Budweiser | [NAME] (Oils&Fats) | 100 | 3000 | 2009 | May 11 | Animal | 0.3 | N | 30 | 1000 | 0.3 |  | N | N | 300
Spreadsheet: 11ee1ec0-e3e8-4e72-8360-e3dd6f3ce36d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | n=14 | n=14.1 | n=6 | n=13
 |  | Fall 2012 | Sp 2013 | Fall 2013 | Sp 2014
 | Content
1 | Candidates use their understanding of young children’s characteristics and needs, and of multiple interacting influences on children’s development | 3.5 | 3.6 | 3.5 | 3.4
 | and learning, to create environments that are healthy, respectful, supportive, and challenging for all children
2 | Candidates know about, understand, and value the importance and complex characteristics of children’s families and communities. They use | 3.6 | 3.7 | 3.6 | 3.5
 | this understanding to create respectful, reciprocal relationships that support and empower families, and to involve all families in their children’s
 | development and learning
3 | Candidates know about and understand the goals, benefits, and uses of assessment. They know about and use systematic observations, | 3.4 | 3.5 | 3.6 | 3.4
 | influence children’s development and learning
4 | Candidates integrate their understanding of and relationships with children and families; their understanding of developmentally effective | 3.5 | 3.6 | 3.3 | 3.2
 | approaches to teaching and learning; and their knowledge of academic disciplines to design, implement, and evaluate experiences that promote
 | positive development and learning for all children.
5 | Candidates identify and conduct themselves as members of the early childhood profession. They know and use ethical guidelines and other | 3.5 | 3.6 | 3.5 | 3.4
 | professional standards related to early childhood practice. They are continuous, collaborative learners who demonstrate knowledgeable,
 | reflective, and critical perspectives on their work, making informed decisions that integrate knowledge from a variety of sources.
 | They are informed advocates for sound educational practices and policies.
 | Mean | 3.5 | 3.6 | 3.5 | 3.4
Spreadsheet: 854198d1704168390-closest-date-with-criteria-with-maxifs-formula-closestdate
Sheet: Sheet1

Date | Symbol | Closest RS Date |  |  |  | Date | Symbol | [NAME]
2023-12-04 00:00:00 | MULN |  |  |  |  | 2023-05-04 00:00:00 | MULN | 1 for 10
2023-12-05 00:00:00 | ABC |  |  |  |  | 2023-08-11 00:00:00 | MULN | 1 for 20
2023-12-06 00:00:00 | ABC |  |  |  |  | 2023-12-04 00:00:00 | SYTA | 1 for 10
2023-12-07 00:00:00 | ABC |  |  |  | Desired date in cell C2-> | 2023-12-21 00:00:00 | MULN | 1 for 50
2023-12-31 00:00:00 | MULN |  |  |  | Desired date in cell C6 -> | 2023-12-30 00:00:00 | MULN | 1 for 10
Spreadsheet: 695976d1600512772-calculating-and-reporting-over-separate-months-example-forecasting
Sheet: Sheet1

 | Product no. | Cost | Margin | Duration (months) | Qty for sale
 | 1 | 100 | 20 | 5 | 20
 | 2 | 200 | 50 | 4 | 30
 | 3 | 50 | 10 | 12 | 100
 | 4 | 200 | 60 | 3 | 30
 | Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Profit/loss | -100 | -50 | 50 | 100 | 25 | 160 | 180 | 300 | 400 | 450 | 400 | 360
Spreadsheet: 286220d1388134212-conditions-in-list-box-car-pool
Sheet: Sheet1

 |  | Days | km/day | petrol cost | mileage | total cost | No of ppl | cost per person | Cost for 4 ppl per day
 |  | 21 | 50 | 78 | 12 | 6825 | 4 | 1706.25
 |  | 1 | 50 | 78 | 12 | 325 | 4 | 81.25 | 325
 |  |  | Name | Days car brought | Money spent | To be given |  | Month | 2013-12-01 00:00:00
 |  |  | Sundar | 8 | 2600 | 893.75
 |  |  | [NAME] | 7 | 2275 | 568.75
 |  |  | Jai | 4 | 1300 | -406.25
 |  |  | [NAME] | 2 | 650 | -1056.25
 |  |  |  | Total Money Spent | 6825 | 0
 |  |  | Sundar | receive from
 |  |  | [NAME] | receive from
 |  |  | Jai | transfer to
 |  |  | [NAME] | transfer to
Spreadsheet: 27541d1220879340-excel-football-game-excelfootball-mdbct-edit
Sheet: Sheet1

 |  |  | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 55 | 60 | 65 | 70 | 75 | 80 | 85 | 90 | 95 | 100
 |  | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque
 |  | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage
 |  | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise
 |  |  |  |  |  |  |  | SCOREBOARD
 |  |  |  |  |  | Total yards | Albuquerque | Anchorage | Boise
 |  |  |  |  |  | 525 | 35
 |  | Albuquerque | Anchorage | Boise
 |  | 75 | 5 | 0
 |  | 75 | 5 | 0
 |  | 75 | 5 | 0
 |  | 75 | 5 | 0
 |  | 75 | 5 | 0
 |  | 75 | 5 | 0
 |  | 75 | 5 | 0
Spreadsheet: 744197d1629058990-need-to-find-corresponding-ids-but-vlookup-doesnt-work-what-formula-do-i-use-new-example-file-0815
Sheet: Sheet1

ID | NAME | EXTENSION |  | BID | ID | Name
1234567 | Apples | (45986712B or 452837456B or 12345679B or 23659480) |  | 5648493048B
2456778 | Oranges | (45872312B and 21435465B) |  | 985746324B
4567890 | Bananas | (87432317B and 42873452B) |  | 452837456B
345321 | Pears | random words (34512985B) and random (25467832B) |  | 43564898B
9876543 | Nectarines | random words <=30 (43564898B) |  | 87432317B
9873456 | Plums | 5648493048B |  | 34512985B
2345678 | Cherries | 985746324B |  | 21435465B |  |  | Also need to get avocados for this BID
4567934 | Pineapples | 87432317B |  | 87432317B
43219056 | Avocados | (21435465B or 12345679B or 43564898B) |  | 12345679B
 |  |  |  | 45986712B
 |  |  |  | 12345679B |  |  | I also need to get avocados for this BID but I don't
 |  |  |  | 23659480
Spreadsheet: 483251d1475579003-x-y-scatter-plot-challenge-test-calculations
Sheet: Sheet1

Point "B" is        (15) | X2 | Y2 | -20 | 21
Point "A" is     (any #) | X1 | Y1
17 | -20 | 17 | Diff in ft. |  | [NAME] | NOT RIGHT,Distance is greater than 4 feet
16 | -20 | 15 | Diff in ft. |  | [NAME] | NOT RIGHT,Distance is greater than 6 feet
5 | -6 | 7 | Diff in ft. |  | [NAME] | NOT RIGHT,Distance is greater than 19 feet
4 | -11 | -20 | Diff in ft. |  | [NAME] | NOT RIGHT,Distance is greater than 41 feet
3 | 6 | 24 | Diff in ft. |  | [NAME] | NOT RIGHT,Distance is greater than 26 feet
The size of my (x, y) scatter plot in FEET are these dimensions
Y axis (North and South) = 1,290 ft..
X axis (East and West) = 1,790 ft..
If we start from the origin of x=0, y=0 then we would divide the overall distances in half
Y axis (North and South) = 645 ft. in one direction (+)
Y axis (North and South) = 645 ft. in the other direction (-)
Y axis total footage is = 1,290 ft.
If we start from the origin of x=0, y=0 then we would divide the overall distances in half
X axis (East and West) = 895 ft. in one direction (+)
X axis (East and West) = 895 ft. in the other direction (-)
X axis total footage is = 1,790 ft.
Spreadsheet: 4f38c457-80f8-4f94-ac43-773c56c8c695
Sheet: Sheet1

Research and Clinical Trials Administration Office | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | FUND BUDGET REQUEST FORM Version: 9-1-11 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
707 South Wood Street, 0 [NAME]
Chicago, IL 60612
Phone: (312) 942-5498
Fax: (312) 563-2734 |  | New Fund Number |  |  | Additional Funding
 |  |  |  |  |  |  |  |  | Fund Number
CLINICAL TRIAL FUND BUDGET REQUEST FORM
ORA Number: |  |  |  |  |  |  |  |  |  |  | Cost Center # ____________
Principal Investigator: |  |  | Employee #
Sponsor Name:
Protocol Number:
Study Title:
Estimated Start Date: |  | MM/YYYY
Estimated End Date: |  | MM/YYYY
Authorized Signers:
Send Fund Report to: |  |  | Address:
(limit 4) |  |  | Address:
 |  |  | Address:
 |  |  | Address:
Contract Amount: |  | 0
Revenue:
 | Budget per Subject
 | Number of Subjects |  |  |  |  |  |  | Note: | They gray cells are locked for editing.  These cells will auto-populate from data entered into other cells within this worksheet.
 | Subject Revenue |  |  |  | 0
 | Study Start Up Fees
 | IRB Fees
 | Screen Failures
 | Storage Fees
 | Advertising
 | Pharmacy Set Up Fees
 | Close - Out Fees
 | Other Revenue
Total Revenue: |  |  |  |  | 0
Expenses:
 | 40102 | Salaries
 | 16250 | [NAME] (27%) |  |  | 0
 | 42050 | [NAME])
 | 45050 | Freight & Messenger Serv
 | 45110 | Advertising
 | 45186 | Subject Stipend (Commissions & Fees) |  |  |  |  |  |  |  |  |  |  | Target Direct Costs | 0
 | 45300 | Ancillary Services Outside RUMC
 | 45780 | Subject Travel (Travel Non-employee)
 | 49010 | Pharmacy (Pro Bldg Pharmacy Charges)
 | 49350 | Telephone recharge |  |  |  |  |  |  |  |  |  |  | Remainder of expenses to be allocated | 0
 | 49530 | Ancillary Services at RUMC
 | 55555 | Equipment (Capital)
 | xxxxxx | Other (Specify)
Total Direct Costs: |  |  |  |  | 0
Total Indirect Costs: |  | (23.08% of revenue) |  |  | 0
Total Expenses: |  |  |  |  | 0
 | APPROVALS
 | __________________________________________
 | Principal Investigator signature |  |  |  | Date
 | Department Chairman signature |  |  |  | Date |  |  |  | Section Director signature (if applicable) |  |  |  |  | Date
 | Research and Clinical Trials Administration Office |  |  |  | Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PW: 1234
Spreadsheet: 737275d1624311356-different-pay-rates-for-different-hours-during-the-day-wage-comparison
Sheet: 13 June

 |  |  |  |  |  |  |  | Award times |  |  | Award | from 1/7 |  |  | Woolies |  |  | Coles
base rate |  |  |  |  | 24.24 | 24.96 |  |  |  |  | 21.41 | 21.94 |  |  | 22.06 |  |  | 22.29
 | Start | Finish | Total |  | now | 2021-07-01 00:00:00 |  | 6.30-18.00 | 18.00-23.00 | total |  |  | 6.30-7.00 | 7.00-23.00 |  | 6.30-18.00 | 18.00-23.00
M | 10:00:00 | 17:00:00
T | 14:00:00 | 22:00:00
W | 06:30:00 | 15:30:00
T | 15:00:00 | 22:00:00
F | 14:00:00 | 22:00:00
S | 10:00:00 | 17:00:00
S | 06:30:00 | 15:30:00
 |  |  |  |  |  |  |  |  |  |  |  | Sunday | 6.30-9.00 | 9.00-23.00
Spreadsheet: 98300d1297265508-vlookup-returning-blank-cells-excelforum-sample-sheet
Sheet: Sheet1

Site-1 | ID |  | Raw Pic | Pictures Valid | Pictures sent?
2 | 2 | Data 1 | 5 | 5
3 | 3 | Data 2 | 3 | 3
4 | 4 | Data 3 | 5 | 5
5 | 5 | Data 4 | 12 | 12
7 | 7 | Data 5 | 22 | 22
13 | 20 | Data 6 | 9 | 9
20 | 21 | Data 7 | 9 | 9
21 | 31 | Data 8 | 9 | 9
30 | 33 | Data 9 | 6 | 6
These are the first ten cells, the actual sheet is over 1,000 cells long.  If you look at column A7 you'll see it has a value of 13, however column B has no 13.  I should return a "No" in column F, as should the value in cell A10.  All others should return "Yes".
Spreadsheet: 848138d1698929570-formula-to-adjust-daily-sales-target-required-example
Sheet: Sheet1

MONTH | TARGET | 2024 Monthly total | Daily Target | Adjsuted Daily Target? |  |  |  |  | Holidays
2023-11-01 00:00:00 | 22 | 10 |  |  |  |  |  |  | 2023-12-25 00:00:00
 | 15 | 7 |  |  |  |  |  |  | 2023-12-26 00:00:00
 | 21 | 0 |  |  |  |  |  |  | 2023-12-31 00:00:00
 | 21 | 0
 | 21 | 0
 | 22 | 0
 | 23 | 0
 | 20 | 0
 | 23 | 0
 | 22 | 0
 | 21 | 0
 | 22 | 0
Yearly Target Total
2024 Grand Total
Remaining Total to reach
Spreadsheet: 0c1f4102-6b35-44f4-852b-428f6e0a9765
Sheet: M300SAL

DISTRIBUTIVE SCHOOL ACCOUNT - DECISION M-300 SALARY
 | POS | POS | $ | POS | $ | POS | $
WEIGHTED ENROLLMENT
AVG STARTING TEACHER SALARY
INSTRUCTIONAL PERSONNEL
LICENSED
STUDENT RATIO
2%ROLL-UP
INSTRUCTIONAL PERSONNEL
NON-LICENSED
STUDENT RATIO
2%ROLL-UP
INSTRUCTION SUPPORT PERSONNEL
LICENSED
STUDENT RATIO
2%ROLL-UP
NON-LICENSED
STUDENT RATIO
2%ROLL-UP
ADMINISTRATIVE SUPPORT PERSONNEL
LICENSED
STUDENT RATIO
2%ROLL-UP
NON-LICENSED
STUDENT RATIO
2%ROLL-UP
OTHER LICENSED & NON-LICENSED
STUDENT RATIO
2%ROLL-UP
TOTAL SALARIES
PERS Rate Change (23.75%-21.5%*.50)
TOTAL SALARIES LESS PERS RATE CHANGE
SUBSTITUTE SALARIES
FRINGE BENEFITS
[NAME]
WORKER'S COMP
UNEMP INS
MEDICARE
MEDICAL INS
OTHER
TOTAL POSITIONS/SALARIES
AND FRINGE BENEFITS
BENEFIT/SALARY RATIO
 |  |  | Net |  |  | Net
Summary | M200 | M300 | Diff | M200 | M300 | Diff
Salaries
Substitute Salaries
Extra Duty, Misc Salaries
Retirement
Worker's Comp
Unemp Comp
Medicare
Medical
Other
Total Salaries and Fringe Benefits
 |  |  | PERS+UI |  |  | PERS+UI
Spreadsheet: 813215d1673617582-countif-between-two-dates-fin-result-between-two-dates-based-on-different-critereas
Sheet: Feuil1

 |  |  |  |  |  | Mois | 2 |  | Année | 2023 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026
 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 1
ID | leave | Return | Type |  | ID |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
E001 | 2023-02-01 00:00:00 | 2023-02-15 00:00:00 | LO |  | E001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
E002 | 2023-02-06 00:00:00 | 2023-02-10 00:00:00 | LO |  | E002 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
E001 | 2023-02-18 00:00:00 | 2023-02-25 00:00:00 | MI |  | E003 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
E002 | 2023-02-18 00:00:00 | 2023-02-28 00:00:00 | MI |  | E004 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
Spreadsheet: 34280d1231439975-drop-down-box-vlookup-not-giving-results-estimate
Sheet: Excel Quote Master

Whaley Foodservice Repairs, Inc.
#N/A
Estimate for Repairs
This estimate is for the location listed below.
This is only an estimate.  The actual cost at the time of repair may vary.
This estimate is in effect for 30 days from the "Date of Estimate."
 |  |  |  |  |  |  |  | BRANCH
Attention: |  |  |  | Date:
Phone # |  |  |  | Fax:
Location: |  |  |  | Make:
Street: |  |  |  | Description:
City: |  |  |  | Model:
State: |  | Zip: |  | Serial :
 |  |  |  | Rating:
Cust. PO# |  |  | Work Order #:
Quantity | Description |  |  |  |  |  | Unit | Total
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | CHOOSE
 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | EPA
 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | TRUCK
 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | LIFT
 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | CRANE
 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | WELDING
 | Miscellaneous Charges |  |  |  |  | Parts sub-total |  | 0 |  |  |  |  |  |  |  |  |  |  | TORCH
0 |  | CHOOSE | 0 |  |  | Tax |  | 0
0 |  | CHOOSE | 0 |  |  | Regular Shipping |  | 0
0 |  | CHOOSE | 0 |  |  | Priority Shipping |  | 0
0 |  | CHOOSE | 0 |  | PARTS TOTAL |  |  | 0
0 |  | CHOOSE | 0 |  | Miscellaneous Charges |  |  | 0
0 |  |  |  | [NAME] | Hours |  | Travel | 0
 | Total Misc. |  | 0 |  |  | Labor in Job: Reg |  | 0
NOTE: |  |  |  |  |  | Labor in Job: O/T |  | 0
This job is quoted for normal business |  |  |  |  |  | Labor to Comp: [NAME] |  | 0
hours ( 8am - 5pm, Mon - Fri) unless otherwise |  |  |  |  |  | Labor to Comp: O/T |  | 0
noted.  All work prior to 8am or after 5pm will |  |  |  | TOTAL ESTIMATE: |  |  | 0
be charged at overtime rates.
Comments:
 |  |  |  |  |  | Date:
Quote Approved by: |  |  |  |  |  | Date:
Spreadsheet: 156528d1337335644-vlookup-match-not-100-sure-121
Sheet: Sheet2

100 | 2010-03-01 00:00:00 | 2010-03-28 00:00:00 | 247.26 | true
103 | 2012-03-19 00:00:00 | 2012-03-25 00:00:00 | 98.89 | False
104 | 2012-03-12 00:00:00 | 2012-03-25 00:00:00 | 103.85 | False
107 | 2012-03-24 00:00:00 | 2012-04-01 00:00:00 | 42.16 | False
Spreadsheet: 805426d1668681849-drag-formula-over-columns-issue-book5
Sheet: Copy formula

NODATA | DATA 1 | NODATA | DATA 2 | NODATA | DATA 3
Spreadsheet: 731466d1620355384-please-help-me-with-these-functions-excel-test-junior-accountant
Sheet: Test 3

Student Name | Test 1 | Test 2 | Pass / Fail
[NAME] | 76 | 78
[NAME] | 66 | 80
[NAME] | 80 | 81
[NAME] | 71 | 76
Lauren | 60 | 95
[NAME] | 90 | 92
[NAME] | 89 | 71
[NAME] | 61 | 82
Create a formula to give each student a "Pass" or "Fail" grade.  To pass a student must achieve a grade greater than 65 on both tests.