tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 705885d1606356879-sumif-between-date-ranges-depending-on-condition-examplesum
Sheet: SHEET A

Name
[NAME]
[NAME]
Spreadsheet: 275650d1383598326-collate-lookup-multiple-orders-at-the-same-time-based-on-date-range-in-a-table-orders-filter-for-prodschdler
Sheet: ORDER STATUS

Start Date | 2013-11-04 00:00:00 | End Date | 2013-11-10 00:00:00
SalesOrderNo | OrderDate | UDF_SCHED_DATE | Days to Produce | Ord Type | BillToName | Qty Yet to Ship | Cust. # | Promise Date
Spreadsheet: 545717d1509633438-extracting-and-consolidate-raw-data-from-one-sheet-to-another-545614d1509574590-extracting-and-consolidate-raw-data-from-one-sheet-to-another-raw-data-help
Sheet: Upload Template

IMPORT | EMPLOYEE_ID | BEGIN_DATE | [NAME] | STATE | PROJECT_ID | TASK_NAME | CUSTOMER_ID | ITEM_ID | TIME_TYPE | BILLABLE | BILLED | DEPARTMENT_ID | LOCATION_ID | TIMESHEETENTRY_DATE | TIMESHEETENTRY_HOURS | TIMESHEETENTRY_DESCRIPTION | TIMESHEETENTRY_NOTES | TIMESHEETENTRY_PROJECTID | TIMESHEETENTRY_VENDORID | TIMESHEETENTRY_CLASSID
 | 12345678 |  |  |  | 147-258-369-CT |  |  |  |  |  |  | 130 |  |  | 11
 |  |  |  |  | 654-847-631-CT |  |  |  |  |  |  | 130 |  |  | 15
 | 85471452 |  |  |  | 451-02-1475-CT |  |  |  |  |  |  | 380 |  |  | 11
 |  |  |  |  | PAT-321-004-CT |  |  |  |  |  |  | 380 |  |  | 1
 |  |  |  |  | PAT-418-004-CT |  |  |  |  |  |  | 380 |  |  | 1
 |  |  |  |  | [NAME] |  |  |  |  |  |  | 380 |  |  | 1
 |  |  |  |  | 801-02-1416-CT |  |  |  |  |  |  | 380 |  |  | 1
 |  |  |  |  | 647-01-1747-CT |  |  |  |  |  |  | 380 |  |  | 2
 | 41112478 |  |  |  | PAT-476-000-CT |  |  |  |  |  |  | 417 |  |  | 10
 | 98741258 |  |  |  | 357-417-000-CT |  |  |  |  |  |  | 471 |  |  | 10
 |  |  |  |  | 628-000-417-CT |  |  |  |  |  |  | 471 |  |  | 10
 |  |  |  |  | 364-871-000-CT |  |  |  |  |  |  | 471 |  |  | 7
 | 98742351 |  |  |  | 919-07-147-CT |  |  |  |  |  |  | 817 |  |  | 32
 |  |  |  |  | 657-00-7941-CT |  |  |  |  |  |  | 817 |  |  | 26
 |  |  |  |  | PAT-654-001-CT |  |  |  |  |  |  | 817 |  |  | 1
 |  |  |  |  | PAT-418-004-CT |  |  |  |  |  |  | 817 |  |  | 1
Spreadsheet: 132782d1323925223-excel-2012-calendar-copy-of-2012-monthly-calendar
Sheet: Nov 2012

November 2012 Calendar.  This calendar is designed for easy use as a planner and has print range preset. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Made with [NAME]: | Calendar Creator Software
 | ◄ Oct 2012 |  |  |  | ~ November 2012 ~ |  |  |  |  |  |  |  | Dec 2012 ► |  |  |  |  |  |  |  |  |  |  |  | 2011 XLS Calendars
 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  |  |  |  |  |  |  |  |  |  |  | 2012 XLS Calendars
 |  |  |  |  |  |  |  |  | 2012-11-01 00:00:00 |  | 2012-11-02 00:00:00 |  | 2012-11-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | XLS Calendar Templates
 | 2012-11-04 00:00:00 |  | 2012-11-05 00:00:00 |  | 2012-11-06 00:00:00 |  | 2012-11-07 00:00:00 |  | 2012-11-08 00:00:00 |  | 2012-11-09 00:00:00 |  | 2012-11-10 00:00:00
 | 2012-11-11 00:00:00 |  | 2012-11-12 00:00:00 |  | 2012-11-13 00:00:00 |  | 2012-11-14 00:00:00 |  | 2012-11-15 00:00:00 |  | 2012-11-16 00:00:00 |  | 2012-11-17 00:00:00
 | 2012-11-18 00:00:00 |  | 2012-11-19 00:00:00 |  | 2012-11-20 00:00:00 |  | 2012-11-21 00:00:00 |  | 2012-11-22 00:00:00 |  | 2012-11-23 00:00:00 |  | 2012-11-24 00:00:00
 | 2012-11-25 00:00:00 |  | 2012-11-26 00:00:00 |  | 2012-11-27 00:00:00 |  | 2012-11-28 00:00:00 |  | 2012-11-29 00:00:00 |  | 2012-11-30 00:00:00 |  | Notes:
 |  |  |  |  |  |  |  | Future Month Calendars: |  | Dec 2012 |  | Jan 2013 |  | Feb 2013
 | Created with [NAME]
 | ► For more layouts, colors, options & for calendars with [NAME] (for 10 Countries + Christian, Jewish & Muslim)  download [NAME] from WinCalendar.com.
 | ► You can even import Microsoft Outlook & Google Calendar appointment data onto created calendars using WinCalendar.
 | ► WinCalendar is also a integrated Windows, Word & Excel popup calendar that supports storing of daily appointments that display on created calendars.
Spreadsheet: 719877d1613864280-auto-populate-date-ranges-to-linear-calendar-weekly-list-template
Sheet: Weekly Task Schedule

 | To Task List
 | WEEKLY
 | TASK SCHEDULE |  |  |  |  |  | Schedule Start Date:
 | Winter
 | ENG 101
 | ART 101
 | MTH 101
 | LIT 101
 | HIS 101
 | OTHER
Spreadsheet: 179519d1347287722-changing-pie-chart-data-labels-to-include-symbol-sector-percentages
Sheet: Sheet1

Top 10 Sectors | Percent
Electronic Technology | 33.37
Health Services | 13.8
Communications | 7.49
Technology Services | 6.9
Consumer Services | 6.66
Finance | 5.88
Consumer Durables | 5.85
Process Industries | 4.02
[NAME] | 3.25
Industrial Services | 2.86
Spreadsheet: 196872d1354131719-editing-a-pre-made-excel-worksheet-1yorkshires-snooker-league-2012
Sheet: Setting

 | R | Team | Last Year Rank | M | P | W | D | L | F | A | [NAME] | Pt | P | W | D | L | F | A | [NAME] | Pt | P | W | D | L | F | A | [NAME] | Pt | Pt Rank | GD Rank | F Rank | Last Year Position
 | 1 | Bradford No1 | 2012 | 10 | 4 | 4 | 0 | 0 | 18 | 6 | 12 | 12 | 2 | 2 | 0 | 0 | 9 | 3 | 6 | 6 | 2 | 2 | 0 | 0 | 9 | 3 | 6 | 6 | 1 | 0 | 0 | 0
 | 4 | Harrogate | 2012 | 10 | 4 | 1 | 1 | 2 | 11 | 13 | -2 | 4 | 1 | 1 | 0 | 0 | 4 | 2 | 2 | 3 | 3 | 0 | 1 | 2 | 7 | 11 | -4 | 1 | 3 | 1 | 0 | 0
 | 2 | Sheffield No1 | 2012 | 10 | 5 | 1 | 3 | 1 | 14 | 16 | -2 | 6 | 3 | 1 | 2 | 0 | 10 | 8 | 2 | 5 | 2 | 0 | 1 | 1 | 4 | 8 | -4 | 1 | 2 | 0 | 0 | 0
 | 6 | Sheffield No3 | 2012 | 10 | 3 | 0 | 1 | 2 | 7 | 11 | -4 | 1 | 2 | 0 | 1 | 1 | 5 | 7 | -2 | 1 | 1 | 0 | 0 | 1 | 2 | 4 | -2 | 0 | 6 | 0 | 0 | 0
 | 3 | [NAME] No1 | 2012 | 10 | 3 | 1 | 1 | 1 | 9 | 9 | 0 | 4 | 1 | 1 | 0 | 0 | 5 | 1 | 4 | 3 | 2 | 0 | 1 | 1 | 4 | 8 | -4 | 1 | 3 | 0 | 0 | 0
 | 5 | Barnsley | 2012 | 10 | 3 | 0 | 2 | 1 | 7 | 11 | -4 | 2 | 2 | 0 | 1 | 1 | 4 | 8 | -4 | 1 | 1 | 0 | 1 | 0 | 3 | 3 | 0 | 1 | 5 | 0 | 0 | 0
Spreadsheet: 762783d1641819111-how-to-use-if-or-something-else-to-insert-a-value-based-on-percentage-of-change-file2
Sheet: Sheet1

Deposit | 100
Rate | 0.015
Units | 0.01 | 0.1
 |  |  | Transaction No. | Deposit | Rate | Final Deposit | Units
 |  |  | 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
 |  |  | 32
 |  |  | 33
 |  |  | 34
 |  |  | 35
 |  |  | 36
 |  |  | 37
 |  |  | 38
 |  |  | 39
 |  |  | 40
 |  |  | 41
 |  |  | 42
 |  |  | 43
 |  |  | 44
 |  |  | 45
 |  |  | 46
 |  |  | 47
 |  |  | 48
 |  |  | 49
 |  |  | 50
 |  |  | 51
 |  |  | 52
 |  |  | 53
 |  |  | 54
 |  |  | 55
 |  |  | 56
 |  |  | 57
 |  |  | 58
 |  |  | 59
 |  |  | 60
 |  |  | 61
 |  |  | 62
 |  |  | 63
 |  |  | 64
 |  |  | 65
 |  |  | 66
 |  |  | 67
 |  |  | 68
 |  |  | 69
 |  |  | 70
 |  |  | 71
 |  |  | 72
 |  |  | 73
 |  |  | 74
 |  |  | 75
 |  |  | 76
 |  |  | 77
 |  |  | 78
 |  |  | 79
 |  |  | 80
 |  |  | 81
 |  |  | 82
 |  |  | 83
 |  |  | 84
 |  |  | 85
 |  |  | 86
 |  |  | 87
Spreadsheet: 746142d1630524165-sum-values-in-a-column-based-on-three-different-columns-sample
Sheet: Sample Data

Job ID | Parent | Part | Cost | Program | Year
1000 | ABC | BC | 1000 | Program 1 | 2021
1000 | ABC | BC | 1000 | Program 1 | 2021
1001 | BC | B | 500 | Program 1 | 2021
1001 | BC | C | 500 | Program 1 | 2021
1002 | ABC | BC | 1000 | Program 1 | 2022
1002 | ABC | BC | 1000 | Program 1 | 2022
1003 | BC | B | 500 | Program 1 | 2022
1003 | BC | C | 500 | Program 1 | 2022
 | 2021 Report |  |  |  |  | 2022 Report
 | Program 1 |  |  | O |  | Program 1 |  |  | O
 | Program 1 | 2000 |  | P |  | Program 1 | 2000 |  | P
Spreadsheet: 115784d1311282735-trying-to-extract-rows-of-info-based-on-2-or-3-conditions-and-paste-to-other-sheet-sample
Sheet: JILL

Change ID*+ | Site+ | Ticket Type | Status* | Change Assignee+ | Site Group | Submit Date | Req Due Date | Last Modified Date | Summary*
Only [NAME]'s projects here older than 2 weeks from date last modified
Change ID*+ | Site+ | Ticket Type | Status* | Change Assignee+ | Site Group | Submit Date | Req Due Date | Last Modified Date | Summary*
Only Jill's Requests for Information older than 2 weeks from date last modified
Spreadsheet: 846123d1697438677-excel-formula-with-multiple-conditions-downgrade-template
Sheet: New Downgrade Dec 2021

 | Always remember, material on this list may already be committed but not removed and that material on site may not be listed, but already sold and awaiting collection or delivery (and not yet picked). |  |  |  |  |  | SHOW T/RATES |  | RESELLER | END USER | **DO NOT SELL USING TONNE RATE, USE PER LENGTH PRICING BELOW** |  | COST RATES
 |  |  |  |  |  |  | PIPE BLK / PTD | 845 |  | 1500 |  |  |  | RESELLER |  |  | END USER
 |  |  | Please ask sales staff to confirm availability on all items prior to ordering |  |  |  | PIPE GAL | 945 |  | 1600 |  |  | PIPE | COST | RATE | MARGIN | COST | RATE | MARGIN
 |  |  | Quantities are subject to change frequently |  |  |  | RHS BLK / PTD | 845 |  | 1500 |  |  | PTD
 |  |  | PLEASE NOTE:  ALL LENGTHS ARE APPROXIMATES ONLY | ALL LENGTHS AVAILABLE INDIVIDUALLY |  |  |  | RHS GAL | 945 |  | 1600 |  |  | GAL
 |  |  | THERE ARE NO RETURNS, EXCHANGES AND/OR REFUNDS ON DOWNGRADE MATERIAL |  |  |  | C/RAIL BLK | 845 |  | 1500 |  |  | RHS
 |  |  |  |  |  |  | C/RAIL GAL | 945 |  | 2000 |  |  | PTD
 |  |  |  |  |  |  |  |  |  |  | HIDE T/RATES |  | GAL
 |  | DOWNGRADE MATERIAL |  |  |  |  | TOTAL TONNES |  | *PRICE PER LENGTH* |  | SHOW T/RATES |  | C/RAIL
 | Date received | QTY Approx. | Type & Finish | Size & Approximate Length | Log # | [NAME] | KG / Length | KG Total | Reseller | End User | Offered to |  | **DON'T CHANGE ANY OF THE DATA ABOVE, CHANGE IT IN COLUMN K, L & M**
 |  |  |  |  |  |  |  |  | 90 | 90 | LOWEST WE WILL TAKE ON THIS IS $90+GST EA ($800/T), TRY TO GET MORE.
 |  |  |  |  |  |  |  |  | 90 | 90 | LOWEST WE WILL TAKE ON THIS IS $90+GST EA ($800/T), TRY TO GET MORE.
 |  | 3
 |  |  |  |  |  |  |  |  |  |  | [NAME] will take this line.
Spreadsheet: 0d0a8731-43cc-461d-936b-3480f89d4f76
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
INSTITUTO COLOMBIANO DEL DEPORTE
COLDEPORTES
RESUMEN DE LOS CONTRATOS
[NAME]
2001
Contrato | Municipio | [NAME] | Contratista | Valor Asignado | Valor Ejecutado | Población Beneficiada
94 | Tabio | [NAME] cubierto | MUNICIPIO | 200000000 | 199848212.75 | 12155
129 | Guayabal de Siquima | [NAME] | MUNICIPIO | 92453000 | 92452510 | 4065
156 | [NAME] | [NAME], cerramiento, drenaje, graderias y camerinos campo de fútbol | MUNICIPIO | 100000000 | 100000000 | 3000
164 | Sibate | Continuación [NAME] | J-G- C CONSTRUCCIONES DE COL. & CIA LTDA | 83824000 | 83823766 | 26956
188 | [NAME] | [NAME] | MUNICIPIO | 150000000 | 150000000 | 7000
219 | Funza | [NAME] | MUNICIPIO | 1000000000 | 500000000 | 50000
474 |  |  | MUNICIPIO |  | 48858456 | 663
279 | Sibate | Terminación Polideportivo [NAME] Ana | ERNESTO GARCIA VALDERRAMA | 48858000 | 250000000 | 3000
451 | [NAME] | [NAME] | ALCALDIA | 250000000 | 500000000 | 50000
491 | Tausa | [NAME] | ALCALDIA | 200000000 | 200000000 | 6927
503 | [NAME] | [NAME] cubierta y camerinos cancha múltiple Colegio Departamental Nacionalizado Manuel Murillo Toro | CUNDEPORTES | 200000000 | 200000000 | 3906
543 | El Rosal | [NAME] múltiples Barrios San José , [NAME]  y Vereda San Antonio | ANIBAL SCHNETDER REYES | 78929000 | 78928782 | 2000
544 | Factativa | Construcción villa Deportiva (Red de Iluminación y Mantenimiento Estadio Municipal) | DISEÑOS POMBO LTDA | 79203000 | 79203303 | 10000
TOTALES |  |  |  | 2483267000 | 2483115029.75 | 179672
Spreadsheet: 102549d1300470365-drop-down-menu-not-working-properly-new-job-template-autofill
Sheet: Final Payment

INVOICE
For Customer: |  |  |  |  |  | From: |  | Terms | Final Payment
Name: | 0 |  |  |  |  | LaMorinda Tile and Stone
Address: | 0 |  |  |  |  | 2261 Commerce Ave., Suite B
City: | 0 |  |  |  |  | Concord, CA 94520 |  | Work Order#
Phone: | 0 |  |  |  |  | [PHONE]
Fax: | 0 |  |  |  |  | [PHONE] |  | Date | 2011-03-18 00:00:00
Phase/Date |  | Description |  |  |  |  |  |  | Price
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
TOTAL DUE: |  |  |  |  |  |  |  |  | 0
We Appreciate Your Prompt Payment.
Spreadsheet: 542871d1508150683-getting-data-from-one-sheet-to-another-depending-on-two-text-values-incident-summary-dummy
Sheet: Summary

 | Windscreen |  | RTA |  | Property Damage (Wall, gate etc.) |  | [NAME] |  | Vehicle Sunk |  | Vehicle Overturned |  | [NAME] |  | Smashed Mirror |  | [NAME] (Puncture, side wall etc.)
Driver | No. Incidents | Total £ | No. Incidents | Total £ | No. Incidents | Total £ | No. Incidents | Total £ | No. Incidents | Total £ | No. Incidents | Total £ | No. Incidents | Total £ | No. Incidents | Total £ | No. Incidents | Total £
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Ulysses Smith
[NAME]
[NAME]
[NAME]
[NAME]
Company Total:
Company - Total Incidents
Company - Total Cost
Spreadsheet: 759491d1639576523-multiple-if-statements-and-left-function-in-one-cell-function-problem
Sheet: Sheet1

 | AGE | ID number | SEX
 |  | 60101104236 |  |  | IF(LEFT(C3;1)=3;5;"M";IF(LEFT(C3;1)=4;6;"N"))
 |  | 38607272761 | M
 |  | 49909010226 | F
 |  | 50108020879 | M
 |  | 60110154912 | F
 |  | 50205162742 | M
 |  | 38807062210 | M
 |  | 50006110865 | M
Spreadsheet: 704320d1605499719-index-and-match-returns-partially-incorrect-match-after-sorted-index_match_partially-matched_vlookup-100-matched_after_sort
Sheet: DYNAMIC_Summary

 |  | INDEX & MATCH - PARTIALLY UNMATCHED
 |  | No. | Oirigin | Personnel | AFTER SORT | TOTAL
 |  | 1 | PG | STAFF 8
 |  | 2 |  | STAFF 4
 |  | 3 |  | STAFF 7
 |  | 4 |  | STAFF 5
 |  | 5 |  | STAFF 6
 |  | 6 |  | STAFF 3
 |  | 7 |  | STAFF 2
 |  | 8 |  | STAFF 1
 |  | 9 |  | Company
 |  | 10 | JB | STAFF 9
 |  | 11 |  | STAFF 11
 |  | 12 |  | STAFF 10
 |  |  |  | TOTAL
 |  | VLOOKUP - 100% MATCHED
 |  | No. | Oirigin | Personnel | BEFORE SORT | TOTAL
 |  | 1 | PG | STAFF 6
 |  | 2 |  | STAFF 8
 |  | 3 |  | STAFF 7
 |  | 4 |  | STAFF 5
 |  | 5 |  | STAFF 4
 |  | 6 |  | STAFF 3
 |  | 7 |  | STAFF 2
 |  | 8 |  | STAFF 1
 |  | 9 |  | Company
 |  | 10 | JB | STAFF 10
 |  | 11 |  | STAFF 11
 |  | 12 |  | STAFF 9
 |  |  |  | TOTAL
Spreadsheet: 824859d1680894087-help-with-creating-formula-to-meet-3-different-criterias-2-duplicate-1-unique-formula-help-1-
Sheet: Open Positions

Job ID | Store | Job Title
9144583 | 3012 | Service Advisor
9163658 | 3012 | Service Advisor
9198747 | 3012 | Tire Technician
1504215 | 3013 | Mechanic
1619873 | 3013 | Service Advisor
1620573 | 3013 | Store Manager
1597093 | 3013 | Tire Technician
1597093 | 3013 | Tire Technician
1597093 | 3013 | Tire Technician
9163661 | 3014 | Tire Technician
Spreadsheet: 120149d1315011818-array-to-count-how-many-days-within-a-range-are-greater-than-5-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Text Entry
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Marcol |  | Check |  |  |  |  | Countif |  | Martin |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-06 00:00:00 | 2011-09-07 00:00:00 |  | 2011-09-09 00:00:00 | 2011-09-10 00:00:00 |  | 3 |  | Tue | Wed |  | Fri |  | 3 |  | 3 |  | 3 |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-07 00:00:00 | 2011-09-08 00:00:00 | 2011-09-09 00:00:00 | 2011-09-10 00:00:00 | 2011-09-11 00:00:00 |  | 3 |  | Wed | Thu | Fri |  |  | 3 |  | 3 |  | 3 |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-08 00:00:00 | 2011-09-09 00:00:00 |  | 2011-09-11 00:00:00 | 2011-09-12 00:00:00 |  | #N/A |  | Thu | Fri | #N/A |  | Mon | 3 |  | #N/A |  | 3 |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-09 00:00:00 | 2011-09-10 00:00:00 | 2011-09-11 00:00:00 | 2011-09-12 00:00:00 | 2011-09-13 00:00:00 |  | 3 |  | Fri |  |  | Mon | Tue | 3 |  | 3 |  | 3 |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-10 00:00:00 | 2011-09-11 00:00:00 | 2011-09-12 00:00:00 | 2011-09-13 00:00:00 | 2011-09-14 00:00:00 |  | 3 |  |  |  | Mon | Tue | Wed | 3 |  | 3 |  | 3 |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-11 00:00:00 | 2011-09-12 00:00:00 | Test | 2011-09-14 00:00:00 | 2011-09-15 00:00:00 |  | #N/A |  |  | Mon | #N/A | Wed | Thu | 3 |  | #N/A |  | 3 |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-12 00:00:00 | 2011-09-13 00:00:00 | 2011-09-14 00:00:00 | 2011-09-15 00:00:00 | 2011-09-16 00:00:00 |  | 5 |  | Mon | Tue | Wed | Thu | Fri | 5 |  | 5 |  | 5 |  | 5
Spreadsheet: 176707d1346078365-what-if-help-what-if-help
Sheet: BoDog

Total | +/- | Poker |  | Tied up |  | W | L | B  O  V  A  D  A  .  L  V
 |  | 0 |  | 0
Pick | Opponent | Sport | Type | Date | Time | Line | Bet | To Win | Score |  | W/L | +/-
Team A | Team B | NFL | L | 2012-08-23 00:00:00 | 08:00:00 | -3 | 110 | 100 | 32 | 27
Spreadsheet: 838041d1690640418-office-365-return-last-entered-value-based-on-multiple-conditions-zpc-daily-oil-top-up-service-report-july-v3
Sheet: LISTS

VEH CATEGORY | MILOTO | CAT | COMPONENT | TRANS TYPE
MILOTO | MT-01 | LD-01 | ENGINE | SERVICE
CAT | MT-02 | LD-02 | [NAME] | TOPUP
 | MT-03 | LD-03 | HYDRAULIC
 | MT-04 | [NAME] | FR_DIFF
 | MT-05 | LD-05 | [NAME]
 | MT-06 | LD-06 | RE_DIFF
 | MT-07 | LD-07 | ATF
 | MT-08 | ADT730-01 | COOLANT
 | MT-09 | ADT730-02 | DEGREASER
 | MT-10 | ADT725-03
 | MT-11 | EX345
 | MT-12 | EX365
 | [NAME] | EX374
 | MT-14 | D8N
 | MT-15 | D6R
 | MT-16 | ADT740-01
 | MT-17 | ADT740-02
 | MT-18 | ADT740-03
 | MT-19 | ADT740-04
 | MT-20 | ADT740-05
 | MT-21 | ADT740-06
 | MT-22 | ADT740-07
 | MT-23 | ADT740-08
 | MT-24 | ADT740-09
 | MT-25 | ADT740-10
 | MT-26 | ADT740-11
 | MT-27 | ADT740-12
 | MT-28 | COMPACTOR
 | MT-29 | GRADER 140K
 | MT-30 | TH460
 | MT-31 | WB740
 | MT-32 | CRANE LOCATELLI
 | MT-33 | CRANE KRUPP
 | MT-34 | CRANE GOTTWALD
 | MT-35 | CRANE PPM
 | MT-36 | DR-01
 | MT-37 | DR-02
 | MT-38
 | [NAME]
 | MT-40
 | MT-41
 | MT-42
 | MT-43
 | MT-44
 | MT-45
 | MT-46
 | MT-47
 | MT-48
 | MT-49
 | MT-50
 | MT-51
 | MT-52
 | MT-53
 | MT-54
 | MT-55
 | MT-56
 | MT-57
 | MT-58
 | MT-59
 | MT-60
 | [NAME]
 | MT-62
 | MT-63
 | MT-64
 | MT-65
 | MT-66
 | MT-67
 | MT-68
 | MT-69
 | [NAME]
 | MT-71
 | MT-72
 | MT-73
 | MT-74
 | MT-75
 | [NAME]
 | [NAME]
 | MT-78
 | MT-79
 | MT-80
 | MT-81
 | [NAME]
 | MT-83
 | MT-84
 | MT-85
 | MT-86
 | MT-87
 | MT-88
 | MT-89
 | MT-90
 | MT-91
 | CM01
 | CM02
 | CM03
 | CM04
 | CM05
 | CM06
 | CM07
Spreadsheet: b0be4fcc-7d11-45cd-8ca6-de43e598912b
Sheet: Sheet1

microarray data selected for mouse mRNA | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Tissue name in Atlas | Corresponding microarrays ([NAME])
mmu_Cerebellum | 130362 | 130363 | 130364
mmu_Cortex | 149511 | 154320 | 107464
mmu_Placenta | 252125 | 252126 | 252127
mmu_Liver | 252076 | 252075 | 252074
mmu_Heart | 147451 | 77688 | 77689
mmu_Spleen | 162086 | 252067 | 252068
mmu_SpinalCord | 113714 | 113715 | 113716
mmu_Eye | 252120 | 252119 | 252121
mmu_Skin | 177486 | 216653 | 216654
mmu_Adipo-diff | 215285 | 252093 | 252094
mmu_Kidney | 252083 | 252084 | 252085
mmu_Embryonic-kidney | 96563 | 96567 | 141682
mmu_Podocytes-K8-undiff | 253173
mmu_Podocytes-K8-diff | 253174
[NAME] | 252080 | 252081 | 252082
mmu_Small-intestine | 252116 | 252117 | 252118
mmu_Colon | 198101 | 198102 | 198112
mmu_T-cell-CD8-ctrl | 252716 | 149586 | 219550
mmu_Thymus | 252107 | 252108 | 252109
mmu_B-cell-K4-WT | 160730 | 160731 | 160739
mmu_B-lymphoma-A20_OP | 181858 | 181859
mmu_Embryo-E11 | 203995
mmu_ESC-fem | 144634 | 144635 | 144636
mmu_Teratocarcinoma-F9 | 209561 | 209563 | 209569
mmu_Fibrobl-MEF-mock | 156795 |  | 198072
mmu_Ovary | 252128 | 252129 | 252130
mmu_Testis | 252110 | 252111 | 252112
mmu_Spermatogonia-C18 | 95928 | 95929
Spreadsheet: 139706d1328395827-solved-rate-as-result-of-multiple-cells-and-tables-basic-invoice
Sheet: 2011

2011 | Out 4 Area1 | Out 4 Low Area1 | Out 4 High Area1 | Out 4 Area2 | Out 4 Low Area2 | Out 4 High Area2 | Out T Area1 | Out T Area2 | Out J Area1 | Out J Area2 | Out 8 Area1 | Out 8 Area2 | Out 7 Area1 | Out 7 Area2 | In 4 [NAME] | In 4 Area2 | In T Area1 | In T Area2 | In J Area1 | In J Area2 | In 8 Area1 | In 8 Area2 | In 7 [NAME] | In 7 Area2
Client1 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 41 | 72
Client2 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96
 | normal |  |  | normal
For OUT 4 we have 3 rates depending on Density:
Low=under 5.5
Normal=between 5.5 and 5.9
High=over 6.0
Spreadsheet: 214355d1360869623-combining-or-stacking-columns-crc-sample-table
Sheet: Sheet1

UPE | Count of UPE | Sum of UPE Value
69 | 2 | 10980
E7 | 16 | 50570
F3 | 13 | 148151
F5 | 54 | 242342
H1 | 4 | 13220
N0 | 390 | 4852830
Grand Total | 479 | 5318093
This table was created using a pivot table of columns A and B of the crc sample file.
Spreadsheet: 438621d1452060686-days-calculation-and-salary-bifurcation-problem-days-calculation-problem
Sheet: Sheet1

Period | Salary | Remaining Days Formula | salary | Total Earning | <=========This is my Manual Calculation
2015-01-05 00:00:00 | 5000 |  | 5000 | 4354.83
2015-02-01 00:00:00 | 5000 |  | 5000 | 5000
2015-03-01 00:00:00 | 5000 |  | 5000 | 5000
2015-04-01 00:00:00 | 5000 |  | 5000 | 5000
2015-05-06 00:00:00 | 5000 |  | 5000 | 4193.54
Period | Salary | Remaining Days Formula | salary | Total Earning | 1. I want separate formula for days calculation in C13, please check my formula is right or wrong.                                2. I want a formula in E13 which calculate C13 Days and implement in E13 and show the result like E2, for example 5000*27/31=4354.83
2015-01-05 00:00:00 | 5000 |  | 5000 | 4354.83
2015-02-01 00:00:00 | 5000 |  | 5000 | 5000
2015-03-01 00:00:00 | 5000 |  | 5000 | 5000
2015-04-01 00:00:00 | 5000 |  | 5000 | 5000
2015-05-06 00:00:00 | 5000 |  | 5000 | 4193.54
Spreadsheet: benjamin_rogers__1094__Ops Summary
Sheet: Sheet1

Plant |  | Starts |  | Run Hours
Brownsville |  | YTD (since 1/1/00) | Life to Date | YTD (since 1/1/00) | Life to Date
 | Unit 1 | 83 | 178 | 543.7 | 1100.9
 | Unit 2 | 77 | 151 | 457 | 917.8
 | Unit 3 | 77 | 174 | 348.8 | 819.3
 | Unit 4 | 81 | 166 | 376.2 | 933.2
 | Average/Unit
Caledonia
 | Unit 1 | 80 | 147 | 564.2 | 953
 | Unit 2 | 76 | 139 | 512.2 | 915
 | Unit 3 1 | 6 | 65 | 24.9 | 801.7
 | Unit 4 | 63 | 137 | 501.6 | 940.7
 | Unit 5 | 70 | 137 | 532.4 | 940.7
 | Unit 6 | 58 | 120 | 454.7 | 816.7
 | Average/Unit
[NAME]
 | Unit 1 | 44 | 44 | 179.5 | 179.5
 | Unit 2 | 40 | 40 | 247 | 247
 | Unit 3 | 55 | 55 | 276.4 | 276.4
 | Average/Unit
Lincoln Center
 | Unit 1 | 47 | 47 | 300.8 | 300.8
 | Unit 2 | 48 | 48 | 266.8 | 266.8
 | Unit 3 | 38 | 38 | 229.8 | 229.8
 | Unit 4 | 39 | 39 | 279 | 279
 | Unit 5 | 28 | 28 | 147.7 | 147.7
 | Unit 6 | 33 | 33 | 177.4 | 177.4
 | Unit 7 | 24 | 24 | 150 | 150
 | Unit 8 | 30 | 30 | 178.5 | 178.5
 | Average/Unit
New Albany 2
 | Unit 1 | 32 | 144 | 221 | 598.7
 | Unit 2 | 43 | 92 | 306 | 634.5
 | Unit 3 | 31 | 127 | 187 | 554.9
 | Unit 4 | 41 | 120 | 178 | 648.2
 | Unit 5 | 33 | 117 | 243 | 654.7
 | Unit 6 | 51 | 170 | 335 | 699.2
 | Average/Unit
Wheatland
 | Unit 1 | 46 | 46 | 97.8 | 97.8
 | Unit 2 | 44 | 44 | 116.9 | 116.9
 | Unit 3 | 34 | 34 | 132 | 132
 | Unit 4 | 24 | 24 | 60.5 | 60.5
 | Average/Unit
Notes:
1 | Caledonia unit 3 starts counter was reset during DCS Upgrade
2 | New Albany YTD numbers are estimates pending receipt of YTD data