tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 177985d1346583880-countif-formula-website-sales-31-3-12-to-30-3-13
Sheet: Monthly

Website Figures - Monthly |  | Highest | Up to #780
 |  | Lowest
Live - Saturday 31st March
Month | No. of Orders | Total Spend ([NAME]) | Average Spend ([NAME]) | Total Spend (Inc VAT) | Average Spend (Inc VAT)
April 2012 | 84 | 11775.88 | 140.1890476190476 | 14131.056 | 168.2268571428571
May 2012 | 78 | 10096.5 | 129.4423076923077 | 12115.8 | 155.3307692307692
June 2012 | 38 | 4573.38 | 120.3521052631579 | 5488.056 | 144.4225263157895
July 2012 | 42 | 5182.12 | 123.3838095238095 | 6218.544 | 148.0605714285714
August 2012 |  |  | #N/A |  | #N/A
September 2012 |  |  | #N/A |  | #N/A
October 2012 |  |  | #N/A |  | #N/A
November 2012 |  |  | #N/A |  | #N/A
December 2012 |  |  | #N/A |  | #N/A
January 2013 |  |  | #N/A |  | #N/A
February 2013 |  |  | #N/A |  | #N/A
March 2013 |  |  | #N/A |  | #N/A
 | Orders | Total ([NAME]) | Average ([NAME]) | Total (Inc VAT) | Average (Inc VAT)
Totals for first year | 242 | 31627.88 | 130.6937190082645 | 37953.456 | 156.8324628099173
 | Orders | Total ([NAME]) | Average ([NAME]) | Total (Inc VAT) | Average (Inc VAT)
Average Per Month | 60.5 | 7906.969999999999 |  | 9488.364
Spreadsheet: 68982d1269514465-work-rota-workroatatest
Sheet: Sheet1

 |  | NIKOLA | [NAME] | [NAME] | KAYLEIGH | [NAME] | JESSICA | STEPHEN | [NAME] |  | CHRIS
Day | Date | B | C | D | E | A
FRI | 4 | 12-8 | COURSE | 2.30-10.30 | 6-2 |  | COURSE
SAT | 5 | OFF | 1.30-9.30 | OFF | 10-6 |  | HOL
SUN | 6 | 7-3 | OFF | OFF | 1.30-9.30 |  | HOL
MON | 7 | 6-2 | 7-3 | 2.30-10.30 | OFF |  | HOL
TUE | 8 | OFF | 2.30-10.30 | 7-3 | OFF |  | HOL
WED | 9 | 7-3 | OFF | 6-2 | 2.30-10.30 |  | HOL |  | 12-8
THUR | 10 | 6-2 | 7-3 | 2.30-10.30 | 12-8 |  | HOL
 | Sub Total | 40 | 40 | 40 | 40 | 26 | 8 | 15 | 8 |  | 40 |  | Total | 257
Spreadsheet: 76153d1276701602-accumulated-grades-nested-ifs-btecsheet2
Sheet: Sheet1

 |  | Chemistry
 |  | 1 |  |  |  |  |  | 2 |  |  |  |  |  | 3 |  |  |  |  |  | 4 |  |  |  |  |  | 5 |  |  |  |  |  | Average |  |  |  | COUNT
Tutor | Name | P |  | M |  | D |  | P |  | M |  | D |  | P |  | M |  | D |  | P |  | M |  | D |  | P |  | M |  | D | 5 | P | M | D |  | P | M | D | Grade
U | a | P |  | M |  | X |  | P |  | M |  | X |  | P |  | M |  | X |  | P |  | M |  | X |  | P |  | M |  | X |  |  |  |  |  |  |  |  |  | Lookup
L | b | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  |  |  |  |  |  |  |  |  | P | 3 | P | M | 3 | M | D | 3 | D
M | c | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  |  |  |  |  |  |  |  |  | X | 1 | X | X | 1 | X | X | 1 | X
H | d | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  |  |  |  |  |  |  |  |  | XP | 2 | XP | XM | 2 | XM | XD | 2 | XD
H | e | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X
U | f | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X
M | g | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X
M | h | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X
L | i | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X
F | j | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X
M | k | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X
L | l | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X
U | m | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X
H | n | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X
H | o | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X
U | p | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X
U | q | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X
H | r | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X |  | X
 | Not Met / Attempted | X |  | X |  | X
 | Attempted / Incomplete | XP |  | XM |  | XD
 | Completed | P |  | M |  | D
Spreadsheet: 843637d1695416175-stacking-arrays-from-multiple-worksheets-based-on-the-selected-worksheets-in-a-list-combining-arrays-from-selected-worksheets
Sheet: Summary

 |  |  |  |  |  |  | List of Class to be summarized
Student | Test | Mid-Term | Final | Final Mark |  | 1 | ClassA |  | for example, if class A, B and E are chosen, then vstack the arrays in these three worksheets.  If only class A and class E are chosen, the vstack arrays from these two.  Or, it can be that all the six worksheets are chosen.
 |  |  |  |  |  | 2 | ClassB
 |  |  |  |  |  | 3 | ClassE
 |  |  |  |  |  | 4
 |  |  |  |  |  | 5
 |  |  |  |  |  | 6
Spreadsheet: 680621d1591114259-simplest-way-to-count-the-unique-number-of-license-plates-minus-all-the-zeros-example
Sheet: Sheet1

Local | Operação | Sub_Operação | Sum of Sum of Litros reais | Sum of Sum of Km Mensal
Coruche | ABAPOR | Distribuição | 5554.986835242551 | 15196
 |  | Oficina | 765.2485240761538 | 2163
 |  | [NAME] | 3428.849893717199 | 9419
 |  | SPOA | 82471.41012864496 | 262376
 |  | Transferências SPOA | 62273.97691021392 | 178510
 | ABAPOR Total |  | 154494.4722918948 | 467664
 | ETSA LOG | Oficina | 38.56823164163974 | 104
 |  | [NAME] | 50 | 522
 |  | T.Pessoal | 5746.870000000001 | 66748
 | ETSA LOG Total |  | 5835.43823164164 | 67374
 | ITS | Bovinos | 286002.8254964984 | 985193
 |  | Distribuição | 209.9933537581699 | 548
 |  | Matadouros | 103946.217091875 | 312365
 |  | Oficina | 3686.76288140296 | 13174
 |  | Ovinos | 30744.5216431327 | 230152
 |  | [NAME] | 11180.7973627728 | 83388
 |  | Suínos | 82995.70918094474 | 274324
 |  | Transferências ACOS | 27357.37657786477 | 76123
 |  | Transferências ITS | 24970.90116304086 | 73205
 | ITS Total |  | 571095.1047512905 | 2048472
 | SEBOL | Oficina | 190.0984101709164 | 658
 |  | Sangue | 25677.09018712157 | 64108
 |  | Transferências Sangue | 8183.022678648015 | 22529
 | SEBOL Total |  | 34050.21127594051 | 87295
Coruche Total |  |  | 765475.2265507672 | 2670805
Loures | ABAPOR | Oficina | 99.19807406627191 | 452
 |  | SPOA | 40794.50192593374 | 179426
 | ABAPOR Total |  | 40893.7 | 179878
 | BIOLOGICAL | OAU | 0 | 0
 | BIOLOGICAL Total |  | 0 | 0
 | ETSA LOG | [NAME] | 0 | 0
 |  | T.Pessoal | 4271.94 | 68794
 | ETSA LOG Total |  | 4271.94 | 68794
 | Externo | [NAME] | 0 | 0
 | Externo Total |  | 0 | 0
 | SEBOL | Distribuição | 1204.500995020258 | 3095
 |  | Matadouros | 106785.8122244158 | 319108
 |  | Oficina | 688.220229796687 | 2719
 |  | [NAME] | 0 | 0
 | SEBOL Total |  | 108678.5334492327 | 324922
Loures Total |  |  | 153844.1734492327 | 573594
Tunes | ABAPOR | Oficina | 0 | 105
 |  | SPOA | 16717.29 | 92565
 | ABAPOR Total |  | 16717.29 | 92670
Tunes Total |  |  | 16717.29 | 92670
VNG | ABAPOR | Oficina | 598.7640326499114 | 2297
 |  | SPOA | 76224.58596735007 | 299243
 | ABAPOR Total |  | 76823.34999999998 | 301540
 | BIOLOGICAL | OAU | 0 | 0
 | BIOLOGICAL Total |  | 0 | 0
 | ETSA LOG | Oficina | 15.66326939048695 | 188
 |  | [NAME] | 192.87 | 199
 |  | T.Pessoal | 7011.246730609515 | 100481
 | ETSA LOG Total |  | 7219.780000000002 | 100868
 | ITS | Matadouros | 26873.13882847465 | 77389
 |  | Oficina | 332.0611715253553 | 993
 | ITS Total |  | 27205.2 | 78382
 | SEBOL | Matadouros | 46178.1121683326 | 126343
 |  | Oficina | 2136.348566025321 | 7733
 |  | Sangue | 8172.481955381536 | 22204
 |  | [NAME] | 0 | 0
 |  | Talhos | 60118.20742782202 | 269978
 |  | Transferências Fiais | 31122.85436429556 | 90102
 |  | [NAME] | 119175.0655181429 | 387643
 | SEBOL Total |  | 266903.07 | 904003
VNG Total |  |  | 378151.4 | 1384793
Grand Total |  |  | 1314188.09 | 4721862
Spreadsheet: 0b8c934c-5596-434d-923b-4bb6bc563951
Sheet: Subject TOTALS

[NAME] = % receiving grade other than W | MVC Retention Rates
 | MSJC MVC Total by Subject
[To view course data click on Subject Name below] | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY12-13
Subject | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13
Accounting
Alcohol/Drug Studies
Allied Health
Administration of Justice
Anatomy & Physiology
Anthropology
Art
American Sign Language
Astronomy
Audio Technology
Automotive/Transportation
Business Administration
Biology
Computer Applications
Childhood Development & Education
Chemistry
Communication
Corrections
Computer Science/Informations Systems
Dance
Diagnostic Medical Sonography
Economics
Education/Teacher Preparation
English
Engineering
Environment Science
Earth Science
English as a Second Language
Fire Technology
French
Geography
Geology
Gerontology
Guidance
Honors Enrichment Program
History
Horticulture
Health Science
Humanities
LEAD
Legal Assistant
[NAME]
[NAME]
Mathematics
Management/Supervision
Multimedia
Music
Networking
Nursing
Nutrition
Occupational Internship
Office Technology
Physical Education
PEIC
Philosophy
Photography
Physics
Portuguese
Political Science
Psychology
Real Estate
Reading
Sustainable Energy Management
Sociology
Spanish
Teaching Assistant
Theater Arts
Viticulture and Enology
Water Technology
Term MVC Average Retention Rate
AY MVC Average Retention Rate
Retention rate = # of “A, B, C, CR, P, D, F, NC, NP and I ” grades divided by (the # of all grades) “A, B, C, CR, P, D, F, NC, NP, I and W”
The "Service Area" includes data from the primary location & all education facilities that enrolls MSJC students, except Dual Enrollment and On-Line.
Spreadsheet: 135580d1326131113-how-to-make-summary-from-many-sheets-students
Sheet: Students

No | Student Name
1 | Student1
2 | Student2
3 | Student3
4 | Student4
5 | Student5
6 | Student6
7 | Student7
8 | Student8
9 | Student9
10 | Student10
11 | Student11
12 | Student12
13 | Student13
14 | Student14
15 | Student15
16 | Student16
17 | Student17
18 | Student18
19 | Student19
20 | Student20
Spreadsheet: 128292d1320896702-how-to-group-information-from-a-table-regroup-table
Sheet: Helper Columns

Heading1 | Heading2 |  | A | B | C | A | B | C
A | 1 |  | 2 |  |  | 1 | 2 | 3
B | 2 |  |  | 3 |  | 4 | 5 | 6
C | 3 |  |  |  | 4 | 7 | 8 | 9
A | 4 |  | 5
B | 5 |  |  | 6
C | 6 |  |  |  | 7
A | 7 |  | 8
B | 8 |  |  | 9
C | 9 |  |  |  | 10
Spreadsheet: 04a9e76c-b1bd-4b43-9dfb-54c8f814b77d
Sheet: Requisition

 |  |  |  |  |  |  |  |  |  | URGENT Requests Require Division AVP/VP Approval:________________________________
COMMODITY Requisition
VENDOR |  | Name and Address: |  |  |  |  |  |  |  |  |  |  |  |  |  | Date Requested:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Originator:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Department:
 |  | Project Contact:
 |  | Phone: |  |  |  |  |  |  |  | Fax: |  |  |  |  |  | Phone:
 |  | E-Mail:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-Mail:
 | Payment Terms:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CMA Fixed Asset Contact:
 |  |  |  |  |  |  |  |  |  |  |  |  | Procurement Office Use Only
 | Equipment Info: |  |  |  |  |  |  |  |  |  |  |  |  | Date Received:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Vendor #:
 | Freight/Pick up:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PO #:
 | LINE # |  | CATEGORY |  |  | QUANTITY |  |  | UNIT | [NAME] |  |  |  |  |  |  | No Tax | UNIT PRICE | EXTENSION
 |  |  | 0
 | 0
 | 0
 |  | Warranty (if applicable): |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sub-Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Discount
 |  | Commodity Requisition $25,000 - $50,000:       3 Quotes Attached |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Tax (8.375%)
 |  | Commodity Requisition Over $50,000: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipping
 |  |  |  | If yes, [NAME] for Commodities over 50k |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Split |  | Accounting Approval
 | Line # |  | Account |  |  |  | Fund |  |  |  | Dept ID |  | Class |  | % | $ [NAME] | Initials |  | Date
 | REQUIRED FOR ALL REQUISITIONS:
 |  | I certify that the goods & services requested are necessary for the operation of the department, that there are sufficient funds to cover the expense, and that I am authorized to approve such expenses.
 |  | X |  |  |  |  |  |  |  |  |  |  |  | X
 |  | Authorized Dept/Unit Head Signature |  |  |  |  |  |  |  |  |  |  |  | VP Approval (as needed)
Spreadsheet: 72290d1272987132-gathering-stats-from-multiple-worksheets-example-call-record-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Day | County | Gender | Homeless | Episode | Caller relationship/referred by | Location | Response Type
Date of the Call: |  |  |  |  | Riverwind Crisis Response Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Type 1:  Referral to 911/Other System
Day of the Week: |  |  |  |  |  |  |  |  |  |  |  |  | Sun | Anoka | Male | Yes | Initial | Self | Walk-in | Type 2:  Immediate Site Visit
Time of Call: |  |  |  |  | Contact Report |  |  |  |  |  |  |  | Mon | Ramsey | Female | No | Repeat | Parent/Guardian | Home | Type 3:  Site Visit Scheduled
Length of Call: |  |  |  |  |  |  |  |  |  |  |  |  | Tue | Hennepin |  |  | Frequent | Other Family Member/Friend | School | Type 4:  Immediate Phone Access/ Interv. Phone Support
County: |  |  |  |  |  |  |  |  |  |  |  |  | Wed | Other |  |  |  | Foster Parent | Treatment setting | Type 5:  Information and Referral
 |  |  |  |  |  |  |  |  |  |  |  |  | Thu |  |  |  |  | Hosp./ED | JDC
Client Data |  |  |  |  |  |  |  |  |  |  |  |  | Fri |  |  |  |  | Police | Unknown
Client Name: |  |  |  | Gender: |  | DOB: |  | Age: |  | Homeless: |  |  | Sat |  |  |  |  | School | Other
Client Address: |  |  |  | City: |  | Zip: |  | Phone: |  |  |  |  |  |  |  |  |  | County SW
Client SS#: |  |  | Client's School: |  |  |  |  | Grade: |  |  |  |  |  |  |  |  |  | Probation Officer
Prents/Guardian: |  |  |  | Phone: |  |  | Relationship to client: |  |  |  |  |  |  |  |  |  |  | Therapist/Other treatment provider
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Health Plan
Providers
 |  | Agency: |  |  |  |  | Phone:
 |  | Agency: |  |  |  |  | Phone:
 |  | Agency: |  |  |  |  | Phone:
Call Data
Episode #:
Caller's Name: |  |  |  | Caller Phone #:
Caller's relationship to the client:
Caller referred by:
Client's location:
Safety Information: | (weapons in the house, etc.)
Communication Issues/Barriers to Service |  |  |  | (ASL, non-English-speaking, hard of hearing, vision loss, etc):
If yes, what?
Response Type
Report
Narrative Notes: | (presenting problem, relevant history, assessment of situation, etc.)
Action Taken & Plan
Assessment Scheduled for (date/time/loction):
Follow up Notes
Name:
Title:
Phone: | [PHONE]
Signature: |  |  |  |  |  | Date:
Spreadsheet: 346345d1411090944-auto-populate-sheets-based-on-master-sheet-example-2-
Sheet: Technicians

First Name | Last Name | City | Skills
[NAME] | Doe | Vancouver | Video
[NAME] | Austen | Edmonton | Video
[NAME] | Martin | Calgary | Photo
[NAME] | Grant | Vancouver | Radio
Spreadsheet: 100869d1299090127-vlookup-only-in-blank-cells-dummy
Sheet: Import

Quantity on hand | Item number from dairy department | Cost per unit
 | 123 | 12
 | 456 | 13
 | 789 | 14
 | 101112 | 15
 | 131415 | 16
Quantity on hand | Item number from meat department department | Cost per unit
 | 999 | 17
 | 888 | 12
 | 777 | 11
 | 666 | 13
Spreadsheet: 732621d1621064037-if-all-cells-are-equal-choose-one-and-ignore-blanks-tst
Sheet: Hoja4

SOURCE1 | SOURCE2 | SOURCE3 | NOTE | RESULT
YEPY596003YJYRNR08 | YEPY596003YJYRNR08 | YEPY596003YJYRNR08 | ALL EQUAL | YEPY596003YJYRNR08
 | FOHT320328YDFFLRR08 |  | OK | FOHT320328YDFFLRR08
 | YTGI860367HJYSRV08 | YTGI860367HJYSRV08 | ALL EQUAL | YTGI860367HJYSRV08
 | EIYG820907HJYSRL02 | EIYG820907HJYSRL09 | NOT EQUAL | ?
TUJF626260HJYNYR02 |  |  | OK | TUJF626260HJYNYR02
 | TUJF626260HJYNYR02 |  | OK | TUJF626260HJYNYR02
 |  | JTDY526262HJYRZN08 | OK | JTDY526262HJYRZN08
TUJF626260HJYNYR02 |  |  | OK | TUJF626260HJYNYR02
TTIT586227YJYVXN05 |  |  | OK | TTIT586227YJYVXN05
 | ZULB600726HJYXPN00 |  | OK | ZULB600726HJYXPN00
ROTT990225YYSYNN06 |  |  | OK | ROTT990225YYSYNN06
 | YUBR550309HYSRRB02 | YUBR550309HYSRRB02 | ALL EQUAL | YUBR550309HYSRRB02
Spreadsheet: 025acb2f-e83c-4c56-a5d2-11a5048d1ef7
Sheet: XML valid characters

XML Special Formatting Requirements: |  | When creating a string of characters in an XML file in a field such as the Local Course Code or other string / character data types, the following characters may be included but may need to be entered with special formatting.  Please refer to the XSD file when determining  what characters can be used in a string field.  Below are the formatting requirements for string fields.
Actual Character | Characters used in XML file | Description of the characters
a-z | a-z | All lower case letters are valid to use in strings for an xml file.
A-Z | A-Z | All upper case or capital letters in the alphabet are valid for strings in xml files.
0-8 | 0-9 | All numbers on the keyboard can be used in the xml file.
( " ) | &quot; | A quotation mark will need to be represented with the characters ( &quot; )  substituted for the   ( " ) character.
( & ) | &amp; | The ampersand character used in an xml file will need the ( &amp; ) substituted in place of the ( & ) character.
( < ) | &lt; | The less than character (<) in an xml file must be replaced with the string ( &lt; ).
( > ) | &gt; | The less than character (>) in an xml file must be replaced with the string ( &gt; ).
( ' ) | &apos; | The apostrophy character ( ' ) in an xml file must be replaced with the string ( &apos; ).
! , @ # % ^ | ! , @ # % ^ | Special characters that can be used directly without change.
* ( ) - + _ = | * ( ) - + _ = | Special characters that can be used directly without change.
{ } [ ] \ | { } [ ] \ | Special characters that can be used directly without change.
, . / ? ~ | , . / ? ~ | Special characters that can be used directly without change.
Spreadsheet: sally_beck__34369__FallonDelaneyrpt
Sheet: Richter

Retain - Richter
GIS ID | Formatted Name | Company Name | Job Title | [NAME] | Level1 Full Name | Level2 [NAME] | Level3 [NAME] | Level4 [NAME] | Company | BU Supported: EGM, EIM, EBS, EES or ENA
90145306 | BANNER, KIMBERLY R | ENRON ONLINE LLC | SPEC E COMMERCE | MANDOLA, TERESA L | WHALLEY, [NAME] | PIPER, GREGORY | RICHTER, BRADLEY | MANDOLA, TERESA | Estate
90134393 | BRIDGES, [NAME] | ENRON ONLINE LLC | DIR E-COMMERCE | RICHTER, BRADLEY A | WHALLEY, [NAME] | PIPER, GREGORY | RICHTER, BRADLEY | BRIDGES, [NAME] | Estate
90010227 | CUMMINGS, [NAME] | ENRON ONLINE LLC | DIR E-COMMERCE | RICHTER, BRADLEY A | WHALLEY, [NAME] | PIPER, GREGORY | RICHTER, BRADLEY | CUMMINGS, JOHN | Estate
90137737 | HEUERTZ, KELLY M | ENRON ONLINE LLC | [NAME] SUPPORT | SHAH, KAL H | WHALLEY, [NAME] | PIPER, GREGORY | RICHTER, BRADLEY | SHAH, KAL | Estate
90128066 | PIOTROWSKI, [NAME] | ENRON ONLINE LLC | ANALYST | MANDOLA, TERESA L | WHALLEY, [NAME] | PIPER, GREGORY | RICHTER, BRADLEY | MANDOLA, TERESA | Estate
90012836 | RICHTER, BRADLEY A | ENRON ONLINE LLC | VP E-COMMERCE | PIPER, GREGORY F | WHALLEY, [NAME] | PIPER, GREGORY | RICHTER, BRADLEY |  | Estate
90007467 | WAX, BRANDON L | ENRON ONLINE LLC | MGR E-COMMERCE | RICHTER, BRADLEY A | WHALLEY, [NAME] | PIPER, GREGORY | RICHTER, BRADLEY | WAX, BRANDON | Estate
 |  |  |  |  |  |  |  |  | 7
Spreadsheet: 709105d1608157891-if-statement-lock-cells-vertically-and-horizontally-book1
Sheet: IF

 |  |  |  |  |  | Credit time (days) | 15
 |  |  |  |  |  | Sales January
 |  |  |  |  |  | Outstanding as at 31/1
 |  |  |  |  |  | Total paid
 |  |  |  |  |  | Total outstanding + total paid |  |  | Sales
 |  |  |  |  |  |  |  |  | 0 | 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
 |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 | 2020-01-02 00:00:00 | 2020-01-03 00:00:00 | 2020-01-04 00:00:00 | 2020-01-05 00:00:00 | 2020-01-06 00:00:00 | 2020-01-07 00:00:00 | 2020-01-08 00:00:00 | 2020-01-09 00:00:00 | 2020-01-10 00:00:00 | 2020-01-11 00:00:00 | 2020-01-12 00:00:00 | 2020-01-13 00:00:00 | 2020-01-14 00:00:00 | 2020-01-15 00:00:00 | 2020-01-16 00:00:00 | 2020-01-17 00:00:00 | 2020-01-18 00:00:00 | 2020-01-19 00:00:00 | 2020-01-20 00:00:00 | 2020-01-21 00:00:00 | 2020-01-22 00:00:00 | 2020-01-23 00:00:00 | 2020-01-24 00:00:00 | 2020-01-25 00:00:00 | 2020-01-26 00:00:00 | 2020-01-27 00:00:00 | 2020-01-28 00:00:00 | 2020-01-29 00:00:00 | 2020-01-30 00:00:00 | 2020-01-31 00:00:00
 |  |  |  |  |  |  |  |  |  | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000
 |  |  |  |  |  |  | Payment | 1 | 2020-01-01 00:00:00
 |  |  |  |  |  |  |  | 2 | 2020-01-02 00:00:00
 |  |  |  |  |  |  |  | 3 | 2020-01-03 00:00:00
 |  |  |  |  |  |  |  | 4 | 2020-01-04 00:00:00
 |  |  |  |  |  |  |  | 5 | 2020-01-05 00:00:00
 |  |  |  |  |  |  |  | 6 | 2020-01-06 00:00:00
 |  |  |  |  |  |  |  | 7 | 2020-01-07 00:00:00
 |  |  |  |  |  |  |  | 8 | 2020-01-08 00:00:00
 |  |  |  |  |  |  |  | 9 | 2020-01-09 00:00:00
 |  |  |  |  |  |  |  | 10 | 2020-01-10 00:00:00
 |  |  |  |  |  |  |  | 11 | 2020-01-11 00:00:00
 |  |  |  |  |  |  |  | 12 | 2020-01-12 00:00:00
 |  |  |  |  |  |  |  | 13 | 2020-01-13 00:00:00
 |  |  |  |  |  |  |  | 14 | 2020-01-14 00:00:00
 |  |  |  |  |  |  |  | 15 | 2020-01-15 00:00:00
 |  |  |  |  |  |  |  | 16 | 2020-01-16 00:00:00
 |  |  |  |  |  |  |  | 17 | 2020-01-17 00:00:00
 |  |  |  |  |  |  |  | 18 | 2020-01-18 00:00:00
 |  |  |  |  |  |  |  | 19 | 2020-01-19 00:00:00
 |  |  |  |  |  |  |  | 20 | 2020-01-20 00:00:00
 |  |  |  |  |  |  |  | 21 | 2020-01-21 00:00:00
 |  |  |  |  |  |  |  | 22 | 2020-01-22 00:00:00
 |  |  |  |  |  |  |  | 23 | 2020-01-23 00:00:00
 |  |  |  |  |  |  |  | 24 | 2020-01-24 00:00:00
 |  |  |  |  |  |  |  | 25 | 2020-01-25 00:00:00
 |  |  |  |  |  |  |  | 26 | 2020-01-26 00:00:00
 |  |  |  |  |  |  |  | 27 | 2020-01-27 00:00:00
 |  |  |  |  |  |  |  | 28 | 2020-01-28 00:00:00
 |  |  |  |  |  |  |  | 29 | 2020-01-29 00:00:00
 |  |  |  |  |  |  |  | 30 | 2020-01-30 00:00:00
 |  |  |  |  |  |  |  | 31 | 2020-01-31 00:00:00
 |  |  |  |  |  |  |  |  | Total payment
Spreadsheet: 221290d1363456181-to-look-for-a-value-based-on-2-criteria-pivot-table-dummy-2
Sheet: Sheet1

Date | Lead | RTS or CC? | Items Scanned/Picked
22/01/2013 | keh | Return to [NAME] | 5 |  |  | date to calculate | 23/01/2013 | (H2 to be input by user)
22/01/2013 | keh | Return to [NAME] | 209
22/01/2013 | keh | Return to [NAME] | 114
22/01/2013 | keh | Return to [NAME] | 700 |  |  |  | thas | keh | manob | rao
[NAME] | thas | Return to [NAME] | 754 |  |  | return to supplier | 344 | 0 | 0 | 0
23/01/2013 | keh | Cyclecount | 535 |  |  | cyclecount | 0 | 1860 | 0 | 0
23/01/2013 | keh | Cyclecount | 339
23/01/2013 | keh | Cyclecount | 479
23/01/2013 | keh | Cyclecount | 507
23/01/2013 | thas | Return to [NAME] | 344
24/01/2013 | thas | Return to [NAME] | 31
25/01/2013 | keh | Cyclecount | 323
25/01/2013 | keh | Cyclecount | 371
25/01/2013 | keh | Cyclecount | 256
25/01/2013 | keh | Cyclecount | 471 |  |  | Date | 23/01/2013
 |  |  |  |  |  | Sum of Items Scanned/Picked
 |  |  |  |  |  |  | keh | thas | Grand Total
 |  |  |  |  |  | Cyclecount | 1860 |  | 1860
 |  |  |  |  |  | Return to [NAME] |  | 344 | 344
 |  |  |  |  |  | Grand Total | 1860 | 344 | 2204