tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 718982d1613459936-conditional-formatting-with-protection-sample2
Sheet: Master

SRJBT  Master
No | Book No | Received Or Lost | Blank (No of pages left) | No | Book No | Received Or Lost | Blank (No of pages left) | No | Book No | Received Or Lost | Blank (No of pages left)
1
2
3 |  |  |  |  |  |  |  | 86
4 |  |  |  |  |  |  |  | 87
5 |  |  |  |  |  |  |  | 88
6 |  |  |  |  |  |  |  | 89
7 |  |  |  |  |  |  |  | 90
8 |  |  |  |  |  |  |  | 91
9 |  |  |  |  |  |  |  | 92
10 |  |  |  |  |  |  |  | 93
11 |  |  |  |  |  |  |  | 94
12 |  |  |  |  |  |  |  | 95
13 |  |  |  |  |  |  |  | 96 |  |  |  |  |  |  |  | `
14 |  |  |  |  |  |  |  | 97
15 |  |  |  |  |  |  |  | 98
16 |  |  |  |  |  |  |  | 99
17 |  |  |  |  |  |  |  | 100
18 |  |  |  |  |  |  |  | 101
19 |  |  |  |  |  |  |  | 102
20 |  |  |  |  |  |  |  | 103
21 |  |  |  |  |  |  |  | 104
22 |  |  |  |  |  |  |  | 105
23 |  |  |  |  |  |  |  | 106
24 |  |  |  |  |  |  |  | 107
25 |  |  |  |  |  |  |  | 108
26 |  |  |  |  |  |  |  | 109
27 |  |  |  |  |  |  |  | 110
28 |  |  |  |  |  |  |  | 111
29 |  |  |  |  |  |  |  | 112
30 |  |  |  |  |  |  |  | 113
31 |  |  |  |  |  |  |  | 114
32 |  |  |  |  |  |  |  | 115
33 |  |  |  |  |  |  |  | 116
34 |  |  |  |  |  |  |  | 117
35 |  |  |  |  |  |  |  | 118
36 |  |  |  |  |  |  |  | 119
37 |  |  |  |  |  |  |  | 120
38 |  |  |  |  |  |  |  | 121
39 |  |  |  |  |  |  |  | 122
40 |  |  |  |  |  |  |  | 123
41 |  |  |  |  |  |  |  | 124
42 |  |  |  |  |  |  |  | 125
Spreadsheet: 489654d1479377676-caculate-time-worked-overtime-from-one-day-to-the-next-ot-auto-calc
Sheet: Sheet2

 |  |  | Time IN |  | Time OUT | Hours - Minutes worked
 |  | 2016-11-13 00:00:00 | 1015 | 2016-11-14 07:15:00 | 730 | 9.15
 |  | 2016-11-14 00:00:00 | 1015 | 2016-11-15 00:00:00 | 745 | ?
 |  | 2016-11-15 00:00:00 | 1015 | 2016-11-16 00:00:00 | 800 | ?
 |  | 2016-11-16 00:00:00 | 1015 | 2016-11-17 00:00:00 | 730 | ?
 |  | 2016-11-17 00:00:00 | 1020 | 2016-11-18 00:00:00 | 700 | ?
 |  | 2016-11-18 00:00:00 | 1025 | 2016-11-19 00:00:00 | 745 | ?
 |  | 2016-11-19 00:00:00 | 1015 | 2016-11-20 00:00:00 | 815 | ?
 |  | 2016-11-20 00:00:00 | 1015 | 2016-11-21 00:00:00 | 830 | ?
 |  |  | This will always be PM |  | This will always be AM
Spreadsheet: be7a0424-e573-473f-9ff5-fbd24299c743
Sheet: Sheet1

CAPITAL PROJECT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 120512 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Ordinance Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Estimate and appropriate federal grant money for green impact zone project
Is this ordinance for the following: |  |  |  |  | New Construction
 |  |  |  | X | 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 | 2013
 | 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? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify source and amount.
 | Source of Funds: |  |  |  | Tiger Grant
 | Year Funded: |  |  |  | 2013
 | Amount of Non-City Funds: |  |  | $ | 1647419.3
 | If no, please identify source and amount of city funds.
 | Acct #:
 | Name of Fund:
 | Year Funded:
 | Amount of City Funds: |  |  | $
If ordinance is for new construction or replacement of asset please provide the following information:
 | Total estimated costs (design through construction): |  |  | $ | 1647419.3
 | Estimated lifespan of project in years |  |  | $ | 25 years
 | Estimated annual operating and maintenance costs |  |  | $ | 0
 | (Please detail type of maintenance or operating costs needed, additional staffing, capital maintenance costs, utilities, etc.)
Are these O&M costs reflected in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please please provide source of funds.
 | If no, please identify year in which additional operating and maintenance costs will be needed. |  |  |  |  |  |  |  |  |  | 2038
 | It will be included in all years of general operation money and fixed as needed.
Reference Numbers: (Previously approved legislation):
Reviewed by:
 |  |  |  |  |  | OMB Approval Date
Spreadsheet: 136284d1326508984-get-rid-of-n-a-invoice-template
Sheet: Sheet1

Date |  |  |  | Customer
Invoice Number |  |  |  | Address
Item |  |  |  |  |  | Quantity | Unit Price | Price
Hands Free Kit Supply Only |  |  |  |  |  | 2
 |  |  |  |  |  | Sub Total
 |  |  |  |  |  | Carriage |  | 0
 |  |  |  |  |  | Total
Spreadsheet: eric_saibi__9913__102601
Sheet: Joliet 29 Unit 07

Owner Name |  | Midwest Generation Company
Station Name |  | Joliet 29 Power Station
Unit Name |  | Unit 07
NERC Region |  | MAIN
State |  | IL
Fuel Type |  | Coal
Capacity |  | 660 MW
Start Date |  | 2001-10-22 00:00:00
End Date |  | 2001-10-29 00:00:00
Comments |  | Transmission line problem
SIC |  | 4931
Plant ID |  | 1507809
Unit ID |  | 1005795
Outage ID |  | 18737
Spreadsheet: 716049d1612000279-merge-vlookup-and-lookup-with-lookup-criteria-of-name-and-date-range-test-formula
Sheet: Example

Name | From | TO | Value |  | Name | Date | Value
Ravi | 2020-01-01 00:00:00 | 2020-02-28 00:00:00 | 200 |  | Ravi | 2020-01-10 00:00:00 | 200 |  | Here the value should come by searching name in the given date range
rahul | 2020-01-01 00:00:00 | 2020-02-28 00:00:00 | 300 |  | Rahul | 2020-01-10 00:00:00 | 300
[NAME] | 2020-01-01 00:00:00 | 2020-02-28 00:00:00 | 400 |  | Jeetu | 2020-01-10 00:00:00 | 400
Ravi | 2020-03-01 00:00:00 | 2020-04-30 00:00:00 | 300
rahul | 2020-03-01 00:00:00 | 2020-04-30 00:00:00 | 400
[NAME] | 2020-03-01 00:00:00 | 2020-04-30 00:00:00 | 500
Ravi | 2020-05-01 00:00:00 | 2020-07-30 00:00:00 | 400
rahul | 2020-05-01 00:00:00 | 2020-07-30 00:00:00 | 500
[NAME] | 2020-05-01 00:00:00 | 2020-07-30 00:00:00 | 600
Spreadsheet: 106674d1303899982-get-data-from-another-cell-sample
Sheet: BCH

0002 | [NAME]
0006 | [NAME]
0019 | [NAME]
0027 | [NAME]
0040 | [NAME]
0041 | Eileen
0042 | [NAME]
0044 | [NAME]
0056 | Teresa
0061 | [NAME]
0148 | [NAME]
0149 | Julian
0150 | Pad
0154 | [NAME]
0174 | Sue
0180 | [NAME]
Spreadsheet: chris_germany__2373__BeldBlake0713
Sheet: Per John Singer

Belden & Blake Corp.
Recap of Invoices vs Payments
Invoice | Invoice | Production |  | Invoice |  |  |  | Invoice |  | ENA | Date | Check
Date | Number | Month | Pipeline | Volume | Price |  |  | Amount |  | Sitara # | Paid | Number
2000-02-04 00:00:00 | 3163182 | 2000-01-01 00:00:00 | CGas | 10000 | 2.365 |  |  |  |  | 145309>227006
2000-03-03 00:00:00 | 3211713 | 2000-02-01 00:00:00 | CGas | 10000 | 2.365 |  |  |  |  | 145309>227006
2000-03-06 00:00:00 | 3302475 | 2000-03-01 00:00:00 | CGas | 10000 | 2.365 |  |  |  |  | 145309>227006
2000-03-06 00:00:00 | 3302475 | 2000-03-01 00:00:00 | CGas | 15500 | 2.73 |  | 1 |  |  |  | 2000-04-24 00:00:00 | [PHONE]
2000-02-16 00:00:00 | 3168421 | 2000-01-01 00:00:00 | Midwestern | 23272 | 2.319 |  |  |  |  | 150715
2000-02-16 00:00:00 | 3168421 | 2000-01-01 00:00:00 | Midwestern | -9672 |  | -14203.74
2000-03-08 00:00:00 | 321898 | 2000-02-01 00:00:00 | Midwestern | 23200 | 2.58 |  |  |  |  | 157562 | 2000-04-14 00:00:00 | [PHONE]
2000-04-19 00:00:00 | 3307510 | 2000-03-01 00:00:00 | Midwestern | 24800 | 2.573 |  | 1 |  |  |  | 2000-04-24 00:00:00 | [PHONE]
2000-03-02 00:00:00 | 3211623 | 2000-01-01 00:00:00 | NYSEG | 28206 | 2.954
2000-03-02 00:00:00 | 3211623 | 2000-01-01 00:00:00 | NYSEG | 13287 | 2.91
2000-03-02 00:00:00 | 3211623 | 2000-01-01 00:00:00 | NYSEG | 7370 | 2.8
2000-03-31 00:00:00 | 3217489 | 2000-02-01 00:00:00 | NYSEG | 13341 | 2.91
2000-03-31 00:00:00 | 3217489 | 2000-02-01 00:00:00 | NYSEG | 29000 | 3.22 |  |  |  |  |  | 2000-04-14 00:00:00 | [PHONE]
2000-03-31 00:00:00 | 3217489 | 2000-02-01 00:00:00 | NYSEG | 8762 | 2.8
2000-04-27 00:00:00 | 3308115 | 2000-03-01 00:00:00 | NYSEG | 5916 | 2.8
2000-04-27 00:00:00 | 3308115 | 2000-03-01 00:00:00 | NYSEG | 31000 | 3.213 |  |  |  |  |  | 2000-04-24 00:00:00 | [PHONE]
2000-05-30 00:00:00 | 3356983 | 2000-04-01 00:00:00 | NYSEG | 6130 | 2.8
2000-03-31 00:00:00 | 3217210 | 2000-02-01 00:00:00 | NFGD PA | 3000 | 2.85
2000-04-30 00:00:00 | 3308195 | 2000-03-01 00:00:00 | NFGD PA | 6882 | 3.3
2000-05-31 00:00:00 | 3356710 | 2000-04-01 00:00:00 | NFGD PA | 2610 | 3.3
 |  |  |  | TOTAL INVOICED
 |  |  |  | Payments:
 |  |  |  | #[PHONE] | 2000-04-14 00:00:00 | -198740.8
 |  |  |  | #[PHONE] | 2000-04-24 00:00:00 | -219703.2
 |  |  |  | #[PHONE] | 2000-05-24 00:00:00 | -20728
 |  |  |  |  |  | UNPAID
Spreadsheet: 8d678447-8222-45c5-bbb1-42b215869b13
Sheet: Sheet1

PPI | Unnamed: 1
 | All fresh vegetables
 | Beets
 | Broccoli
 | Cabbage
 | Carrots
 | Cauliflower
 | Celery
 | Cucumbers
 | Eggplant
 | Endive
 | Green peas
 | Green peppers
 | Greens
 | Lettuce
 | Onions, dry
 | Potatoes, all
 | Potatoes, long white
 | Potatoes, round red
 | Potatoes, round white
 | Potatoes, russet
 | Snap beans
 | Spinach
 | Squash
 | Sweet corn
 | Sweet potatoes
 | Tomatoes
Spreadsheet: 03928b0c-5c77-41f1-a4ed-22bbc69a8f70
Sheet: Math

Math - Lesson Planning
 | Fall 2011 | Sp 2012 | Fall 2012 | Sp 2013 | Fall 2013
Curriculum and Standards | 4.4 | 4.6 | 5 | 4.8 | 5
Objectives should define what students will know and be able to do.) | 4.5 | 4.5 | 5 | 4.7 | 5
Introductory activities set the stage for learning by providing background information about the topic to help orient investigations | 4.8 | 4.7 | 5 | 4.6 | 5
All activities are aligned with the objective(s), build upon each other, are appropriately paced, and developmentally appropriate. | 4.7 | 4.6 | 5 | 4.5 | 5
The course of instruction responds to student needs and interests, and students can make key decisions regarding their learning | 4.5 | 4.5 | 5 | 4.7 | 5
Collaborative learning allows all students opportunities to develop teamwork, communication, problem-solving skills, and reflection | 4.8 | 4.6 | 5 | 4.8 | 5
Concluding activities re-examine the important points of the lesson | 4.7 | 4.7 | 5 | 4.7 | 5
A variety of technology is integrated appropriately throughout the lesson in a manner that enhances the effectiveness of the lesson and the learning of the student. | 4.6 | 4.5 | 5 | 4.6 | 5
Emphasis on the technology standards and performance indicators are clearly seen through the major components of the lesson plan | 4.7 | 4.6 | 5 | 4.6 | 5
Assessment opportunities are ongoing and inform students | 4.8 | 4.4 | 5 | 4.7 | 5
Methods should include both formal and informal tools | 4.4 | 4.5 | 5 | 4.8 | 5
Materials and resources—exclusive of technology tool—that are needed by the student or the teacher to execute the lesson.) | 4.5 | 4.6 | 5 | 4.7 | 5
Accommodations do not change lesson or criteria. | 4.7 | 4.7 | 5 | 4.6 | 5
Modifications change lesson and criteria | 4.8 | 4.8 | 5 | 4.4 | 5
Explorations identify further study activities; extensions identify bridge activities | 4.7 | 4.8 | 5 | 4.5 | 5
Resources used by the teacher to create this lesson, i.e. books, journals, magazines, web sites, school/public library resources, outside experts, etc.) | 4.6 | 4.5 | 5 | 4.8 | 5
 |  |  |  |  |  | Sp 2014
Professional Writing |  |  |  |  |  | 3.8
Essential Question |  |  |  |  |  | 3.5
Standards and Benchmarks |  |  |  |  |  | 3.7
Student Outcomes |  |  |  |  |  | 3.8
Materials/Technology |  |  |  |  |  | 3.9
Procedures |  |  |  |  |  | 3.5
[NAME] “Hook” |  |  |  |  |  | 3.6
Pre-planned (seed) Questions |  |  |  |  |  | 3.8
Modeling, guided, collaborative and independent practice |  |  |  |  |  | 3.7
Formative/Summative |  |  |  |  |  | 3.8
Assessment |  |  |  |  |  | 3.9
Closure |  |  |  |  |  | 3.8
Differentiation |  |  |  |  |  | 3.7
Post-Lesson Reflection/Analysis |  |  |  |  |  | 3.6
Spreadsheet: 808893d1670745549-countif-or-counta-centre-across-selection-timetable-ans
Sheet: Term 1

LSU Teacher Timetable |  | T1 | Week | 1 | 2023-01-30 00:00:00 |  | Class 1 | Class 2 | Class 3 | Class 4 | Class 5 | Class 6 | Class 7 | N-A
Day | Teacher | 7 AM | 8 AM | 9 AM | 10 AM | 11 AM | 12 PM | 1 PM | 2 PM | 3 PM | 4 PM | 5 PM | 6 PM | 7 PM | 8 PM | 9 PM | 10 PM | Total teaching |  | FORMULA
 | Teacher 1 | x
 | Teacher 2 |  |  |  |  |  | 12:00 pm-3:00 pm |  |  |  |  |  | 6:00 pm-8:00 pm
 | Teacher 3 |  |  | 9:30 am-12:30 pm
 | Teacher 4 |  |  |  |  |  | 12:30 pm -2:30 pm |  |  |  |  |  | 6:00 pm-8:00 pm
 | Teacher 5 |  |  |  | 10:00-12:00 |  |  |  |  |  |  |  | 6:00-8:00
 | Teacher 1 |  |  | 9:00-3:30 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | I have changed "." to ":" otherwise excel will not read it as time.
 | Teacher 2 |  | 8:00-9:00 |  | 10:00-1:00 |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | am and pm entry is must. I have done for rows 3 to 6.
 | Teacher 3 | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Teacher 4 |  |  | 9:00-12:00 |  |  | 12:30-3:30 |  |  |  |  |  |  |  |  |  |  | 6
 | Teacher 5 |  |  | 9:00-12:00 |  |  |  |  |  |  |  |  | 6:00-8:00 |  |  |  |  | 5
 | Teacher 1 |  |  | 9:00 am-3:30 pm |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | Teacher 2 |  |  | 9:00-12:00 |  |  |  | 1:00-3:00 |  |  |  |  |  |  |  |  |  | 5
 | Teacher 3 |  |  |  |  |  |  |  | 2:00-4:00 |  |  |  |  |  |  |  |  | 2
 | Teacher 4 |  |  | 9:30-12:00 |  |  | 12:30-3:00 |  |  |  |  |  | 6:00-8:00 |  |  |  |  | 7
 | Teacher 5 |  |  | 9:00-12:00 |  |  |  |  | 2:00-4:00 |  |  |  | 6:00-8:00 |  |  |  |  | 7
Spreadsheet: 549607d1511820182-sumifs-multiple-include-and-exclude-dropdowns-all-if-blank-sumifs-dropdown
Sheet: GROUP Summary

 |  |  |  | Aug 2017
 |  |  |  | $ | $ | Δ$ | Sales
 |  |  |  |  | Sales | Sales Change | Sales Volume
 | Included Brands |  | Small
 | If blank, all are incldued |  | Med
 | Apples |  | Large
 | Oranges
 |  |  | Expected Result if All Blank
 |  |  | Small |  | 197615987.1 | 147420 | 52122
 |  |  | Med |  | 65871995.7 | 49140 | 0
 | Excluded Brands |  | Large |  | 0 | 0 | 0
 | If blank, nothing is excluded
 |  |  | Expected Result if Apples and Oranges Inc.
 |  |  | Small |  | 55659345 | 0 | 11334
 |  |  | Med |  | 18553115 | 0 | 3778
 |  |  | Large
 |  |  | Expected Result if Peachs Excluded
 |  |  | Small |  | 151203257.1 | 0 | 11769
 |  |  | Med |  | 65871995.7 | 49140 | 0
 |  |  | Large |  | 0 | 0 | 0
Spreadsheet: 1d5a1a04-2497-4745-b073-43da5556e815
Sheet: Sheet1

Sunday Mens 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Date | Day | Time | Location | Home | Visitor
2014-06-01 00:00:00 | Sun | 7:00PM | Field 1 | Terminators | Iguana Tap It
2014-06-01 00:00:00 | Sun | 8:00PM | Field 1 | Terminators | [NAME]
2014-06-01 00:00:00 | Sun | 9:00PM | Field 1 | Abq Hitmen | Ace of Bases
2014-06-01 00:00:00 | Sun | 10:00PM | Field 1 | [NAME] | [NAME]
2014-06-08 00:00:00 | Sun | 7:00PM | Field 1 | Terminators | [NAME]
2014-06-08 00:00:00 | Sun | 8:00PM | Field 1 | [NAME] | Abq Hitmen
2014-06-08 00:00:00 | Sun | 9:00PM | Field 1 | Iguana Tap It | Ace of Bases
2014-06-08 00:00:00 | Sun | 10:00PM | Field 1 | Iguana Tap It | Abq Hitmen
2014-06-22 00:00:00 | Sun | 7:00PM | Field 1 | [NAME] | Iguana Tap It
2014-06-22 00:00:00 | Sun | 8:00PM | Field 1 | Terminators | Ace of Bases
2014-06-22 00:00:00 | Sun | 9:00PM | Field 1 | Abq Hitmen | [NAME]
2014-06-22 00:00:00 | Sun | 10:00PM | Field 1 | [NAME] | Ace of Bases
2014-06-29 00:00:00 | Sun | 7:00PM | Field 1 | [NAME] | Ace of Bases
2014-06-29 00:00:00 | Sun | 8:00PM | Field 1 | [NAME] | Abq Hitmen
2014-06-29 00:00:00 | Sun | 9:00PM | Field 1 | Abq Hitmen | Iguana Tap It
2014-06-29 00:00:00 | Sun | 10:00PM | Field 1 | [NAME] | Terminators
2014-07-13 00:00:00 | Sun | 7:00PM | Field 1 | Iguana Tap It | [NAME]
2014-07-13 00:00:00 | Sun | 8:00PM | Field 1 | Ace of Bases | [NAME]
2014-07-13 00:00:00 | Sun | 9:00PM | Field 1 | [NAME] | Terminators
2014-07-13 00:00:00 | Sun | 10:00PM | Field 1 | Terminators | Abq Hitmen
2014-07-20 00:00:00 | Sun | 7:00PM | Field 1 | Ace of Bases | Abq Hitmen
2014-07-20 00:00:00 | Sun | 8:00PM | Field 1 | Iguana Tap It | Terminators
2014-07-20 00:00:00 | Sun | 9:00PM | Field 1 | [NAME] | [NAME]
2014-07-27 00:00:00 | Sun | 7:00PM | Field 1 | Abq Hitmen | Terminators
2014-07-27 00:00:00 | Sun | 8:00PM | Field 1 | Ace of Bases | [NAME]
2014-07-27 00:00:00 | Sun | 9:00PM | Field 1 | Iguana Tap It | [NAME]
2014-08-03 00:00:00 | Sun | 7:00PM | Field 1 | Abq Hitmen | [NAME]
2014-08-03 00:00:00 | Sun | 8:00PM | Field 1 | [NAME] | Iguana Tap It
2014-08-03 00:00:00 | Sun | 9:00PM | Field 1 | Ace of Bases | Terminators
2014-08-03 00:00:00 | Sun | 10:00PM | Field 1 | Ace of Bases | Iguana Tap It
Spreadsheet: 759356d1639501050-month-to-date-over-prior-and-week-to-date-over-prior-automation-week-over-week-month-over-month-change-ans
Sheet: Sheet1

 | Date | Orders | Returns |  |  |  | Week to Date / Prior Week to Date | Month to Date / Prior Month to Date | Week to Date / Prior Week to Date | Month to Date / Prior Month to Date
 | 2021-11-01 00:00:00 | 1991 | 147 |  |  | Units Ordered
 | 2021-11-02 00:00:00 | 2332 | 105 |  |  | Units Returned
 | 2021-11-03 00:00:00 | 2038 | 111 |  |  | Return Rate
 | 2021-11-04 00:00:00 | 1843 | 103
 | 2021-11-05 00:00:00 | 1729 | 123
 | 2021-11-08 00:00:00 | 1862 | 120
 | 2021-11-09 00:00:00 | 2020 | 66
 | 2021-11-10 00:00:00 | 1861 | 162
 | 2021-11-12 00:00:00 | 1546 | 125
 | 2021-11-15 00:00:00 | 1773 | 78
 | 2021-11-16 00:00:00 | 1942 | 68
 | 2021-11-17 00:00:00 | 1772 | 136
 | 2021-11-18 00:00:00 | 1948 | 188
 | 2021-11-19 00:00:00 | 1645 | 115
 | 2021-11-22 00:00:00 | 1744 | 75
 | 2021-11-23 00:00:00 | 1841 | 165
 | 2021-11-24 00:00:00 | 1485 | 92
 | 2021-11-26 00:00:00 | 743 | 0
 | 2021-11-29 00:00:00 | 1636 | 104
 | 2021-11-30 00:00:00 | 1968 | 132
 | 2021-12-01 00:00:00 | 1903 | 155
 | 2021-12-02 00:00:00 | 1753 | 144
 | 2021-12-03 00:00:00 | 1602 | 135
 | 2021-12-06 00:00:00 | 1937 | 108
 | 2021-12-07 00:00:00 | 1805 | 123
 | 2021-12-08 00:00:00 | 1958 | 146
 | 2021-12-09 00:00:00 | 1887 | 143
 | 2021-12-10 00:00:00 | 1696 | 140
 | 2021-12-13 00:00:00 | 1779 | 127
Spreadsheet: 731654d1620482672-sumifs-problem-merged-cells-claims-recap-marie-
Sheet: RECAP

CLAIMS PER CIE
 | Received
COMPANY | in EUR | in USD | Total equivalent in EUR
AIG
ALLIANZ
Aquilano
AXA
[NAME]
HELVETIA
[NAME]
NHC
RSA
Satec
Siat
STARSTONE
Swiss Re
Spreadsheet: 162445d1339886113-help-with-calculations-in-a-meal-plan-menucopy
Sheet: ServSize

Serving Sizes
1/8 | Oz.
0.67 | Apple
0.75 | Bag
1.25 | Bar
1.5 | Crackers
1 | Cup
1/2 | Large
1/3 | Med.
1/4 | Olives
10 | Packet
2 | Pancakes
3 | Person
4 | Piece
5 | Roll
6 | Scoop
7 | Slice
8 | Stick
9 | Taco's
 | Tbsp.
 | Tsp.
 | Fillet
 | Pattie
 | Container
 | Orange
Spreadsheet: mark_taylor__24951__PRC LEGAL
Sheet: Sheet1

MID - YEAR    PRC    REPS.
 | LEGAL   (R. YOUNG)
HIRED DATE | REVIEWEE | DEPARTMENT | JOB TITLE | JOB GROUP | PEER GROUP | SUPERVISOR | PRC REP | HR REP NAME
03/16/1998 | NOVAK, [NAME] | BRAZIL LEGAL RIO | VP & SR COUNSEL | VP | SPECIALIZED TECHNICAL | YOUNG, RANDEL R | YOUNG, RANDEL R | PADRON, MIGUEL A.
08/02/1999 | ARAP SOBRINHO, SAMI | LEGAL | GERENTE JURIDICO SR | DIR SR | SPECIALIZED TECHNICAL | YOUNG, RANDEL R | NOVAK, [NAME] | PADRON, MIGUEL A.
07/07/1997 | GEORGE, ROBERT H | BRAZIL LEGAL | GEN COUNSEL ASST | DIR SR | SPECIALIZED TECHNICAL | YOUNG, RANDEL R | NOVAK, [NAME] | PADRON, MIGUEL A.
12/16/1998 | WATANABE, LUIZ [NAME] | LEGAL | ADVOGADO SR | DIR | SPECIALIZED TECHNICAL | YOUNG, RANDEL R | NOVAK, [NAME] | PADRON, MIGUEL A.
02/22/1999 | BERTONE, [NAME] | LEGAL | ADVOGADO SR | DIR | SPECIALIZED TECHNICAL | ARAP SOBRINHO, SAMI | NOVAK, [NAME] | PADRON, MIGUEL A.
03/30/1998 | FRUMKIN, [NAME] | BRAZIL LEGAL | COUNSEL SR III | DIR | SPECIALIZED TECHNICAL | WATANABE, LUIZ [NAME] | NOVAK, [NAME] | PADRON, MIGUEL A.
 | CALO, [NAME] | LEGAL | ATTORNEY | DIR | SPECIALIZED TECHNICAL | HENDRY, BRENT J | NOVAK, [NAME]
12/31/1997 | MARTINEZ, VICKY L | BRAZIL LEGAL RIO | COUNSEL SR I | MGR | COMMERCIAL | NOVAK, [NAME] | NOVAK, [NAME] | PADRON, MIGUEL A.
06/01/1999 | PORTO, PAULA M A P | LEGAL | ADVOGADO SR | MGR | SPECIALIZED TECHNICAL | NOVAK, [NAME] | NOVAK, [NAME] | PADRON, MIGUEL A.
03/01/2000 | DUTRA, PATRICIA MARIA F C | LEGAL | ADVOGADO | MGR | SPECIALIZED TECHNICAL | WATANABE, LUIZ [NAME] | NOVAK, [NAME] | PADRON, MIGUEL A.
Spreadsheet: 816003d1675303293-lookup-function-s666-pq-trial
Sheet: Sheet1

 |  | Time | Monday | Tuesday | Wednesday | Thursday | Friday
 |  | 16:30:00 | 6 | 6 | 7 | 7 | 6
 |  | 17:00:00 | 7 | 7 | 8 | 8
 |  | 17:30:00 |  |  | 9
 |  | 18:00:00 | 8 | 8 |  | 9 | 7
 |  | 18:30:00 | 9 |  | 10 | 10
 |  | 19:00:00 |  | 9 |  |  | 8
 |  | 19:30:00 |  |  | 11
 |  | 20:00:00 | 10 | 10
 |  | 20:30:00 |  |  |  | 11 | 9
 |  | 21:00:00 | 11 | 11 | 12
 |  | 21:30:00 |  |  | 13 | 12 | 10
 |  | 22:00:00 | 12 | 12 |  |  | 11
 |  | 22:30:00 |  | 13 | 14 | 13
Spreadsheet: 109002d1305910625-excel-2007-multiple-frequencies-book1
Sheet: Result

1 | 5 | 1 | 11
1 | 7 | 2 | 10
2 | 2 | 7 | 1
3 | 1 | 9 | 11
2 | 1 | 2 | 9
1 | 6 | 1 | 10
1 | 5 | 1 | 11
1 | 6 | 1 | 10
1 | 5 | 1 | 11
1 | 6 | 1 | 10
1 | 6 | 1 | 10
Spreadsheet: 682996d1592417875-v-lookup-or-other-solution-needed-20200617-v2
Sheet: Sheet1

General | 400288 | 2012
General | 400340 | 2013
General | 400348 | 2013
General | 268445 | 2013
General | 268697 | 2013
General | 268723 | 2013
General | 271522 | 2013
General | 278423 | 2013
General | 281763 | 2013
General | 270999 | 2013
General | 271108 | 2013
General | 266744 | 2015
General | 266744 | 2017
General | 266745 | 2017
General | 266745 | 2015
General | 266746 | 2015
General | 266746 | 2019
General | 266746 | 2017
General | 266748 | 2017
General | 266748 | 2015
General | 266748 | 2019
General | 266748 | 2017
General | 266750 | 2015
General | 266752 | 2015
General | 266752 | 2017
Spreadsheet: 119509d1314475987-count-if-if-value-in-other-cell-in-the-row-matches-answer
Sheet: Sheet1

name | city | letter
tom | new york | A
[NAME] | new york
[NAME] | london | B
kate | washington | C
jake | washington | A
all
A | 2
B | 1
C | 1
new york
A | 1
B | 0
C | 0
london
A | 0
B | 1
C | 0
washington
A | 1
B | 0
C | 1
Spreadsheet: 829621d1684336089-match-data-in-one-column-formula-to-locate-mismatch-data-in-another-column-mismatch-sample-1-
Sheet: Sheet1

ACCOUNT |  |  |  |  |  |  |  |  |  |  |  |  |  | DATA TO COMPARE IF MATCHED | formula here | Example of  wanted results
19850029616 |  |  |  |  |  |  |  |  |  |  |  |  |  | Judgment of Divorce
19890009390 |  |  |  |  |  |  |  |  |  |  |  |  |  | Judgment of Divorce
19910011318 |  |  |  |  |  |  |  |  |  |  |  |  |  | Default Judgment Filiation |  | MISMATCH
19910011318 |  |  |  |  |  |  |  |  |  |  |  |  |  | Default Judgment |  | MISMATCH
19910045015 |  |  |  |  |  |  |  |  |  |  |  |  |  | Judgment of Divorce
19192002185 |  |  |  |  |  |  |  |  |  |  |  |  |  | Judgment of Divorce
11993001769 |  |  |  |  |  |  |  |  |  |  |  |  |  | Default Judgment Filiation
19940002758 |  |  |  |  |  |  |  |  |  |  |  |  |  | Judgment of Divorce
19940002758 |  |  |  |  |  |  |  |  |  |  |  |  |  | Judgment of Divorce
19950002016 |  |  |  |  |  |  |  |  |  |  |  |  |  | Consent Judgment Filiation |  | MISMATCH
19950002016 |  |  |  |  |  |  |  |  |  |  |  |  |  | Default Judgment Filiation |  | MISMATCH