tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 811698d1672754441-copy-whole-rows-if-condition-is-fulfilled-example-file-1-
Sheet: Data

Name | Start | Starts at | End | Ends at | All-day event | Reminder on/off | Reminder on | Reminder at | Organizer | Mandatory participants | Optional participants | Ressources | Information | Description | Categories | Location | Priority | Private | Kilometers | Vertraulichkeit | Show as | Duration | Day | Month | Year | Calendar week
Appointment 1 | 2023-03-06 00:00:00 | 09:00:00 | 2023-03-06 00:00:00 | 18:00:00 | Off | On | 2023-03-06 00:00:00 | 08:45:00 |  |  |  |  |  |  | Blue |  | Normal | Off |  | Normal | 2 |  | Monday | March
Appointment 2 | 2023-03-06 00:00:00 | 11:00:00 | 2023-03-06 00:00:00 | 12:00:00 | Off | On | 2023-03-06 00:00:00 | 10:45:00 |  |  |  |  |  |  | Yellow |  | Normal | Off |  | Normal | 2 |  | Monday | March
Appointment 3 | 2023-03-07 00:00:00 | 08:30:00 | 2023-03-08 00:00:00 | 09:00:00 | Off | On | 2023-03-07 00:00:00 | 16:30:00 |  |  |  |  |  |  | Green |  | Normal | Off |  | Normal | 2 |  | Tuesday | March
Appointment 4 | 2023-03-08 00:00:00 | 08:00:00 | 2023-03-08 00:00:00 | 10:30:00 | Off | On | 2023-03-08 00:00:00 | 07:30:00 |  |  |  |  |  |  | Red |  | Normal | Off |  | Normal | 2 |  | Wednesday | March
 |  |  |  | Appointment 2 |  |  |  | Start | Starts at | End | Ends at
 |  |  |  | Appointment 3Appointment 3 |  |  | Appointment 1 | 2023-03-06 00:00:00 | 09:00:00 | 2023-03-06 00:00:00 | 18:00:00
 |  |  |  | Appointment 4 |  |  | Appointment 2 | 2023-03-06 00:00:00 | 11:00:00 | 2023-03-06 00:00:00 | 12:00:00
 |  |  |  |  |  |  | Appointment 3 | 2023-03-07 00:00:00 | 08:30:00 | 2023-03-08 00:00:00 | 09:00:00
 |  |  |  |  |  |  | Appointment 3 | 2023-03-07 00:00:00 | 08:30:00 | 2023-03-08 00:00:00 | 09:00:00
 |  |  |  | 2 |  |  | Appointment 4 | 2023-03-08 00:00:00 | 08:00:00 | 2023-03-08 00:00:00 | 10:30:00
 |  |  |  | 3
 |  |  |  | 7
 |  |  |  | 8 |  |  |  |  | 44991 | 0.375 | 44991 | 0.75
 |  |  |  |  |  |  | 1 | Appointment 2 | 44991 | 0.4583333333333333 | 44991 | 0.5
 |  |  |  | 1 |  |  | 2 | Appointment 3 | 44992 | 0.3541666666666667 | 44993 | 0.375
 |  |  |  | 2 |  |  | 1 | Appointment 3 | 44992 | 0.3541666666666667 | 44993 | 0.375
 |  |  |  | 3 |  |  |  | Appointment 4 | 44993 | 0.3333333333333333 | 44993 | 0.4375
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
Spreadsheet: 689241d1596210985-assign-unique-value-to-a-state-of-repeating-cycle-file-with-solution-provided
Sheet: Example

Date | Cycle Status | Cycle Number
2020-07-01 00:00:00 | a | 1
 | a
 | a
 | a
 | a
 | a
 | a
 | b
 | b
 | b
 | b
 | b
 | b
 | c
 | c
 | d
 | d
 | d
 | d
 | d
 | d
 | a
 | a
 | a
 | a
 | a
 | a
 | b
 | b
 | b
 | b
 | b
 | c
 | c
 | c
 | a
 | a
 | a
 | a
 | a
 | a
 | b
 | b
 | b
 | b
 | b
 | c
 | c
 | c
 | c
 | d
 | d
 | d
 | d
 | d
Spreadsheet: c0ebe9ff-4a9e-4e3d-b384-aa691ff96e98
Sheet: Sheet1

STUDENT-SPECIFIC DATA COLLECTION | 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 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26
[NAME]: |  |  | County-District #:
Student Name | Age | Date of Birth | Campus where student is enrolled | Grade | Primary disability | Secondary disability | Tertiary disability | Is this student limited English proficient (LEP)? | Instructional arrangement | Instructional arrangement prior to entering the RF | Name of Residential Facility | Number days absent to date for current year | Was student retained in same grade as last year? | Has the student been enrolled in the LEA for at least one year? | Date of current FIE | Date of current ARD committee meeting | Was parent/ guardian/ surrogate parent in attendance at last ARD committee meeting? | Does student have surrogate? | Does student receive special transportation? | Has the student been removed from their current placement due to discipline? | Has student had manifestation determination in last 12 months? | For each subject area which state assessment has the student been assigned for the 2011-2012 school year? | List related services student is receiving (including speech therapy).  Indicate whether service is direct (D) or consultative (C) | Does student have an assistive technology device?  (Enter YES or NO) | Does student receive assistive technology services? | Did student receive ESY in the previous year?
Spreadsheet: 100896d1299105353-excel-2007-conditional-formatting-multiple-conditions-demo-customer-leads-template
Sheet: Agent 1

Lead Id | Lead Type Id | First Name | Last Name | Address | City | State | Zip | [NAME] | Phone | Inquiry Type Id | DateTimeCreated | DateTimeUpdated | Inquiry Type Name
210495 | 2 | Customer | Last Name | 145 main st | Road | ID | 83660 |  |  | 4 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | Residential
210535 | 2 | Customer | Last Name | 146 main st | Mountain Home | ID | 83647 |  |  | 4 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | Residential
210574 | 2 | Customer | Last Name | 147 main st | Kooskia | ID | 83539 |  |  | 4 | 2011-02-25 00:00:00 | 2011-02-25 00:00:00 | Residential
210530 | 2 | Customer | Last Name | 188 main st | Msla | MT | 59804 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210509 | 2 | Customer | Last Name | 189 main st | Moiese | MT | 59824 |  |  | 5 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Home Office (home business)
210449 | 2 | Customer | Last Name | 227 main st | Cottage Grove | OR | 97424 |  |  | 4 | 2011-02-16 00:00:00 | 2011-02-16 00:00:00 | Residential
210493 | 2 | Customer | Last Name | 228 main st | Siletz | OR | 97380 |  |  | 4 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | Residential
210543 | 2 | Customer | Last Name | 229 main st | Monmouth | OR | 97361 |  |  | 4 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | Residential
210609 | 2 | Customer | Last Name | 230 main st | reedsport | OR | 97467 |  |  | 4 | 2011-02-27 00:00:00 | 2011-02-27 00:00:00 | Residential
210625 | 2 | Customer | Last Name | 231 main st | [NAME] | OR | 97411 |  |  | 4 | 2011-02-28 00:00:00 | 2011-02-28 00:00:00 | Residential
210511 | 2 | Customer | Last Name | 309 main st | [NAME] | WA | 98226 |  |  | 4 | 2011-02-23 00:00:00 | 2011-02-23 00:00:00 | Residential
210546 | 2 | Customer | Last Name | 310 main st | [NAME] | WA | 98252 |  |  | 4 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | Residential
Spreadsheet: 744853d1629485903-lookup-info-on-another-sheet-netoutsforupload
Sheet: Seller's NetOut

[NAME]'s Estimated Closing Costs
[NAME]:
Buyer:
Property Address: |  |  |  |  | las cruces
Estimated Sale Price: |  |  | 200000 |  |  | Total days for loan payments | 21900
Estimated Closing Date: |  |  | 2021-09-30 00:00:00
Realtor Commission |  |  |  |  |  |  | Yearly Taxes |  | 4000
[NAME] on Commission
Closing Fee - $425 $1/$1000 of sale price |  |  |  |  |  |  | Realtor Commission | 0.06
[NAME] on Closing Fee
Title Binder/Commitment |  |  |  |  | 100
Title Policy Retrieval Fee |  |  |  |  | 150
Title Policy Cancellation Fee |  |  |  |  | 150
Owner's Title Policy
Special Assessment Search |  |  |  |  | 50
[NAME] |  |  |  |  | 60
Pro-rata data search |  |  |  |  | 50
Tax Service Fee |  |  |  |  | 85
Flood Zone Certificate |  |  |  |  | 25
FedEx fee |  |  |  |  | 20
ILR (If survey is requested need quote) |  |  |  |  | 250
HOA Transfer & Disclosure Fees |  |  |  |  | 700
Prorated Taxes
First Mortgage |  |  |  |  | 100000
Second Mortgage
These expenses are due at the time of service.
Estimated Repairs
Appraisal
Inspections
Buyer's Home Warranty
Total expenses due at time of service (not included in total due to seller below)
Total expenses paid through closing
Estimated Total Due to [NAME] at Closing:
Spreadsheet: 647a6dad-e608-4fb5-acdf-00bc2b3d673a
Sheet: ST16

Supplementary Table 16 ([NAME] et al.) Polymorphism-based sweep analyses. CLSW
chr | start | end | LR1 | 95th percentile2 | p value2
1 | 145037804 | 145040692 | N/A | N/A | N/A |  | GOF
1 | 147717685 | 147719570 | N/A | N/A | N/A
2 | 115419153 | 115420608 | -19.035 | N/A | N/A
2 | 115917965 | 115921773 | 6.999 | 2.483 | 0
2 | 132794729 | 132796576 | N/A | N/A | N/A
2 | 133013735 | 133016150 | N/A | N/A | N/A
3 | 2139182 | 2142802 | -26.395 | 3.104 | 0.544
3 | 237095 | 242136 | -14.496 | -0.627 | 0.178
3 | 87137688 | 87139305 | -63.832 | -1.366 | 0.65
5 | 146762173 | 146763181 | -29.904 | N/A | N/A
6 | 151814531 | 151816287 | -2.704 | 2.464 | 0.136
7 | 152621856 | 152623442 | -46.27 | -13.289 | 0.265
7 | 32800880 | 32802246 | N/A | N/A | N/A
7 | 51538748 | 51540078 | -14.111 | N/A | N/A
10 | 103328874 | 103331401 | 3.702 | 3.293 | 0.04000000000000004
10 | 109673385 | 109675834 | -53.023 | 1.407 | 0.659
10 | 81741180 | 81742583 | -16.324
10 | 830316 | 831468 | -98.064 | -11.023 | 0.6890000000000001
11 | 857724 | 860732 | 13.938 | 3.965 | 0
13 | 31626584 | 31631064 | 2.431 | 3.584 | 0.05900000000000005
15 | 98195675 | 98196486 | -49.74
17 | 21475991 | 21477731 | -18.788 | 0.838 | 0.235
18 | 73627718 | 73628912 | -19.634 | -0.282 | 0.258
18 | 74798658 | 74800451 | -115.52 | -4.385 | 0.831
18 | 903446 | 909852 | -64.236 | 1.596 | 0.7110000000000001
19 | 17558365 | 17559781 | 0.76 | N/A | N/A
19 | 51016136 | 51018764 | 2.627 | 5.953 | 0.08399999999999996
20 | 1782608 | 1784925 | -69.851 | 3.185 | 0.883
20 | 326778 | 329498 | -6.757 | 2.587 | 0.122
20 | 361304 | 363330 | -48.652 | 2.764 | 0.768
20 | 5484588 | 5485659 | -139.708 | -13.644 | 0.78
22 | 27040777 | 27045045 | -0.378 | 0.856 | 0.05700000000000005
22 | 47549899 | 47551490 | -40.017 | -9.32 | 0.255
1N/A in this column if no ancestral alleles for the region or too few SNPs to be
computationally tractable for clsw
2N/A in this column if neutral simulations of the region had low variablilty, making them
computationally intractable for clsw
Spreadsheet: a98b608d-7138-4085-8006-49cac0709522
Sheet: Income Statement

The NASDAQ OMX Group, Inc.
Consolidated Statements of Income
(in millions, except per share amounts)
(unaudited)
 |  | Three Months Ended
 |  | June 30, |  | March 31, |  | June 30,
 |  | 2012 |  | 2012 |  | 2011
Revenues:
Market Services |  | 688 |  | 666 |  | 699
Cost of revenues:
Transaction rebates |  | -299 |  | -306 |  | -322
Brokerage, clearance and exchange fees |  | -100 |  | -84 |  | -100
Total cost of revenues
Total Market Services revenues less transaction rebates,
brokerage, clearance and exchange fees
Issuer Services |  | 91 |  | 90 |  | 92
Market Technology |  | 44 |  | 45 |  | 46
Revenues less transaction rebates, brokerage,
clearance and exchange fees
Operating Expenses:
Compensation and benefits |  | 113 |  | 112 |  | 115
Marketing and advertising |  | 6 |  | 6 |  | 5
Depreciation and amortization |  | 25 |  | 26 |  | 26
Professional and contract services |  | 23 |  | 22 |  | 20
Computer operations and data communications |  | 17 |  | 17 |  | 17
Occupancy |  | 23 |  | 23 |  | 23
Regulatory |  | 9 |  | 9 |  | 8
Merger and strategic initiatives |  | 1 |  | 2 |  | 29
Restructuring charges |  | 17 |  | 9 |  | 0
General, administrative and other |  | 15 |  | 14 |  | 14
Total operating expenses
Operating income
Interest income |  | 2 |  | 2 |  | 3
Interest expense |  | -24 |  | -24 |  | -31
Asset impairment charges |  | -28 |  | -12 |  | 0
Income from unconsolidated investees, net |  | 0 |  | 0 |  | 1
Income before income taxes
Income tax provision |  | 33 |  | 53 |  | 40
Net income
Net loss attributable to noncontrolling interests |  | 1 |  | 1 |  | 1
Net income attributable to NASDAQ OMX
Basic and diluted earnings per share:
Basic earnings per share |  | 0.55 |  | 0.49 |  | 0.52
Diluted earnings per share |  | 0.53 |  | 0.48 |  | 0.51
Cash dividends declared per common share |  | 0.13 |  | 0 |  | 0
Weighted-average common shares outstanding
for earnings per share:
Basic |  | 169 |  | 173 |  | 177
Diluted |  | 173 |  | 178 |  | 181
Spreadsheet: 92510d1292063280-excel-2007-conditional-formating-marked-by-coloured-condition-0format-2
Sheet: DEC

INV | TAKEN BY | RCV DT | INV DT | CUSTOMER | AMOUNT | STATUS
SH297934 |  |  | 2010-12-05 00:00:00 | [NAME] | 10832.5
SH297935 |  |  | 2010-12-06 00:00:00 | ALMAHABAH MEAT SHOP | 13600
SH297936 | SHOUKAT |  | 2010-12-07 00:00:00 | GULF PASTRY | 3100
SH297937 | SHOUKAT | 2010-12-10 00:00:00 | 2010-12-11 00:00:00 | EXPRESS BROOST CHICKEN REST | 863
I need if C2 is empty and D2 date is more then 2 days from today then A2 cell will come red colour
Spreadsheet: 80131d1280340403-converting-monthly-data-into-quarterly-example-dataset-from-months-to-quarters-rev-input-excelforum
Sheet: Sheet1

 | Oct-94 | Nov-94 | Dec-94 | [NAME] | Feb-95 | Mar-95 | Apr-95 | May-95 | Jun-95 | Jul-95 | Aug-95 | Sep-95 | Oct-95 | Nov-95 | Dec-95 |  | Q4 1994 | Q1 1995 | Q2 1995 | Q3 1995 | Q4 1995
Serie A | 27000000 | 26900000 | 26900000 | 27100000 | 30700000 | 31000000 | 31400000 | 31800000 | 32500000 | 33100000 | 33600000 | 33500000 | 38000000 | 34700000 | 35200000
Serie B | 19874704.98920199 | 19561380.26504721 |  | 19321562.08687609 | 19437955.17688743 | 0 | 18905968.48216777 |  | 21232920.13528947 | 21471641.85637053 | 20953960.57121344
Serie C |  |  |  | 146118302 | 143822980 | 131081601 | 123143968 |  |  | 93020486 | 85945233 |  | 74627626 | 69110219
 | Ideally, the data would be as in Row 2: uninterrupted so for every Quarter simply return the latest month of that Quarter (see columns R to V). Note: I do not want to average data for a Quarter, simply the last month of a Quarter.
 | If the cell for a Quarter's last month does not contain any data or a value of '0' (see rows 3 and 4 - Series B and C) the range of Quarters (columns R to V) should either return the preceding month or the month before that.
 | So for example, Cell R3 should normally return the value of [NAME] but since there's no data it now has to return the value in cell [NAME]. Simultaenously, the value in cell [NAME] (i.e. Q2 1995) should normally return the value of
 | cell [NAME] (i.e. June 95) but since there's no data there, it moves one month earlier (May 95) which has no data either and thus it returns Cell H5 (April 95).
 | If a complete Quarter does not contain data or only '0's it should return 0 for that quarter, for example [NAME] from Serie B (Row 3).
 |  | Month | Data | Q | Data
 |  | 1995-01-01 00:00:00 | 545654
 |  | 1995-02-01 00:00:00 | 747456
 |  | 1995-03-01 00:00:00 | 4564546 | Q1 1995
 |  | 1995-04-01 00:00:00 | 3442334
 |  | 1995-05-01 00:00:00 | 23234
 |  | 1995-06-01 00:00:00 | 23426 | Q2 1995
 |  | 1995-07-01 00:00:00 | 753342
 |  | 1995-08-01 00:00:00 | 1345346
 |  | 1995-09-01 00:00:00 | 63453 | Q3 1995
 |  | 1995-10-01 00:00:00 | 23426373
 |  | 1995-11-01 00:00:00 | 345243
 |  | 1995-12-01 00:00:00 | 23426 | Q4 1995
 |  | 1996-01-01 00:00:00 | 24322
 |  | 1996-02-01 00:00:00 | 635735
 |  | 1996-03-01 00:00:00 | 233422 | Q1 1996
 |  | 1996-04-01 00:00:00 | 43535
 |  | 1996-05-01 00:00:00 | 234266
 |  | 1996-06-01 00:00:00 | 25677 | Q2 1996
Spreadsheet: 799703d1665221033-case-sensitive-with-match-while-using-arrays-excel_help-1-
Sheet: control-1array

UNMATCH: |  | (case-unsensitive) |  | =SUMPRODUCT((1*ISNA(MATCH(A5:A1000,E5:E8,0))=1)*(A5:A1000<>"")*1)
 |  | (case-sensitive) |  | =REDUCE(0,FILTER(A5:A1000,A5:A1000<>""),LAMBDA(a,b,a+ISNA(MATCH(TRUE,EXACT(b,E5:E8),0))))
grade |  |  |  | grade
A |  |  |  | A
A |  |  |  | B
B |  |  |  | b
C |  |  |  | C
D
a
F
A
A
B
B
D
A
B
Spreadsheet: 139943d1328552998-consolidating-tabs-into-one-master-sheet-sample-for-posting
Sheet: FY11Items

FY '12: Jul '11 to June '12
[NAME] #322222222-8 |  | Jul '11 | Aug '11 | Sept '11 | Oct '11 | Nov '11 | Dec '11 | Jan '12 | Feb '12 | Mar '12 | Apr '12 | May '12 | Jun '12 | TOTAL
 | Cost
 | Per item
Student Account Tickets | 0.5
Items deposited | 0.1
[NAME] items | 7.5
Foreign items | 0
Outgoing debits | 0
Incoming credits | 0
NSF Activity | 28
Dept Dep Acct #333333333-10
 | Cost
 | Per item
UND Per Item Fee | 0.1
[NAME] items | 7.5
Foreign items | 0
Outgoing debits | 0
Incoming credits | 0
Wire Trasfer Dr. [NAME]
NSF Activity | 28
CC Acct #344444444-9
 | Cost
 | Per item
Items deposited | 0.1
Returned items | 7.5
Foreign items | 0
Outgoing debits | 0
Incoming credits | 0
NSF Activity | 28
TOTAL OF ACCOUNTS
Dividends Paid
 | Cost
 | Per item
Student Payments | 0.5
Items deposited | 0.1
Returned items | 5
Foreign items | 0
Outgoing debits | 0
Incoming credits | 0
Overdraft fee | 27
TOTAL
Spreadsheet: 268865d1380868876-auto-transfer-some-information-from-stock-ledger-to-party-ledger-dg-accounts
Sheet: Stock - A4

 |  |  | ITEM: |  |  | A4 PAPER REAM
 | INVOICE | DATE | PARTY NAME |  | O.B | RECEIPT | ISSUE | C.B |  |  |  |  |  | Party Name
 |  |  | PURCHASE |  | 0 | 1000 |  |  |  |  |  |  |  | Select
 | 25 | 2013-09-20 00:00:00 | A |  |  |  | 10 |  |  |  |  |  |  | A
 |  |  | B |  |  |  | 5 |  |  |  |  |  |  | B
 |  |  | C |  |  |  | 7 |  |  |  |  |  |  | C
 |  |  | B |  |  |  | 4 |  |  |  |  |  |  | D
 | 30 |  | A |  |  |  | 3 |  |  |  |  |  |  | E
 | 31 |  | A |  |  |  | 2 |  |  |  |  |  |  | F
 |  |  | E |  |  |  | 1 |  |  |  |  |  |  | G
 |  |  | G |  |  |  | 10 |  |  |  |  |  |  | H
 |  |  | F |  |  |  | 15 |  |  |  |  |  |  | I
 |  |  | PURCHASE |  |  | 1500 |  |  |  |  |  |  |  | J
 |  |  | Select |  |  |  |  |  |  |  |  |  |  | K
 |  |  | Select |  |  |  |  |  |  |  |  |  |  | L
 |  |  | Select |  |  |  |  |  |  |  |  |  |  | M
 |  |  | Select |  |  |  |  |  |  |  |  |  |  | N
 |  |  | Select |  |  |  |  |  |  |  |  |  |  | O
 |  |  | Select |  |  |  |  |  |  |  |  |  |  | PURCHASE
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
 |  |  | Select
Spreadsheet: 762932d1641910845-cond-formatting-first-monday-on-the-month-sddo-vacation-tracker-2023
Sheet: Aug

Formation /Training
Congés / Leaves | V
Congés fériés / GC holidays
Fin de semaine / Weekend
T:  Tentative | T
Compressed Day / Journée comprimée
Assignment / Left
Half Day / Demie Journée
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
August | Dates of Leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023
08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Vacation
Employee Name | 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 |  | Replaced by:
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
(Vacant CS-03)
[NAME]
[NAME]
[NAME]
(Vacant team lead)
(Vacant CS-03)
Sameer [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
August Total
Spreadsheet: 867515d1714384461-using-array-formula-and-relative-referencing-most-efficiently-sample-data
Sheet: Example

 |  |  |  |  |  |  |  | Comment
 |  | OrderNo | Order qnty | Variable quantity | Difference |  |  | Column to use in formula calculation
 |  |  |  | 501 |  |  |  | E4
 |  | 3233322 | 34343 | 432 | 34343 |  |  | E5
 |  | 432343 | 2323 | 42222 | 2323 |  |  | E6
 |  | 4323423 | 233 | 443332 | 501 |  |  | E7
 |  | 123123 | 33 | 25 | 501 |  |  | E8
 |  | 123123 | 34 | 35 | 501 |  |  | E9
Spreadsheet: 106460d1303750699-sumproduct-formula-2
Sheet: Sheet2

DATE | PITCHER | BATTER | INN | CATCHER |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | RESULT
2011-04-01 00:00:00 | LEWIS | SMITH | 1 | TORREALBA | PITCH | F | S | F | H | F | H | F | F | F | S | F | F | F | F | F | HIT
 |  |  |  |  | START | 1 | 3 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 1
 |  |  |  |  | FINISH | 11 | 2 | 11 | 12 | 11 | 11 | 11 | 11 | 2 | 3 | 12 | 1 | 12 | 11 | 11
2011-04-01 00:00:00 | LEWIS | DAVIS | 1 | TORREALBA | PITCH | F | S | F | H | F | H | F | F | F | S | F | F | F | F | F
 |  |  |  |  | START | 1 | 3 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | 1 | 1
 |  |  |  |  | FINISH | 1 | 2 | 11 | 12 | 11 | 11 | 1 | 1 | 2 | 3 | 1 | 1 | 12 | 11 | 1
2011-04-01 00:00:00 | LEWIS | WELLS | 1 | TORREALBA | PITCH | F | S | F | H | F | H | F | F | F | S | F | F | F | F | F
 |  |  |  |  | START | 1 | 3 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | 1 | 1
 |  |  |  |  | FINISH | 1 | 2 | 11 | 12 | 11 | 11 | 1 | 1 | 2 | 3 | 1 | 1 | 12 | 11 | 1
Spreadsheet: 02f2bf0f-0ec1-457b-ad6d-73eca4c31d95
Sheet: Sheet1

Date: | Age/grade:                 K-5 | Lunch - Week 1 | 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 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | COMMENTS/                   RESULTS
 |  | List food from menu that fit into each category |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly Results/Totals
Component | New Meal Pattern | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  |  | Actual Totals | Required Totals (for the week) in cups | Quantity difference (actual vs required) | RESULTS
 |  | Item | cups | Item | cups | Item | cups | Item | cups | Item | cups | Item | cups | Item | cups
FRUIT
FRUIT | ½ cup of Fruit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 3.5 | -3.5 | DOES NOT MEET
Fruit Totals (for each day |  | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0
VEGETABLE
VEGETABLES - ¾ cup of vegs/day | ½ cup dark green |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.5 | -0.5 | DOES NOT MEET
 | ¾ cup of red/orange |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.75 | -0.75 | DOES NOT MEET
 | ½ cup of legumes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.5 | -0.5 | DOES NOT MEET
 | ½ cup of starchy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.5 | -0.5 | DOES NOT MEET
Required total adds up to 2¾c; weekly total of all vegs  is 5¼c | ½ cup of other |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.5 | -0.5 | DOES NOT MEET
VEG TOTALS (for each day) |  | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 |  | 0 | 5.25 | -5.25 | DOES NOT MEET
Component | New Meal Pattern | Item | oz. eq. | Item | oz. eq. | Item | oz. eq. | Item | oz. eq. | Item | oz. eq. | Item | oz. eq. | Item | oz. eq. |  | Actual Totals | Required Totals (for the week)
GRAINS & BREADS
 | Grains (list all WGR and non-WGR) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 11-12.5 (1 oz eq per day minimum) |  | DOES NOT MEET
 | List only WGR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Half of all grains must be whole grain |  | MEETS
MEAT / MEAT ALTERNATE |  |  | oz |  | oz |  | oz |  | oz |  | oz |  | oz |  | oz
 | Minimum of 1 oz per day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 11-14 per week (minimum of 1 oz eq per day) |  | DOES NOT MEET
MILK |  |  | cup |  | cup |  | cup |  | cup |  | cup |  | cup |  | cup
 | Non-fat (flavored or unflavored) or 1% unflavored |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Offer 1 cup/day |  | DOES NOT MEET
 |  |  |  |  |  |  | 8/3/2012  PDE  Develpoment credit Idaho State Agency with revisions by MARO