tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 30208d1225586060-manipulating-the-format-of-contents-from-sheet1-and-formatting-them-diff-on-sheet2-test2
Sheet: Sheet1

Location | Category | Type | Possible False Positive | Total High | Total Low | Description
BldgA | High Risk | 516 | 1 | 1 |  | Description:\nHigh weakness1 determined, but no evidence
BldgB | High Risk | 516 | 1 | 1 |  | Description:\nHigh weakness1 determined, but no evidence
BldgA | Low Risk | 216 | 1 |  | 1 | Description:\nLow Weakness1 determined, but no evidence
BldgB | Low Risk | 217 | 0 |  | 1 | Description:\nLow Weakness2 determined with evidence
BldgB | High Risk | 517 | 0 | 1 |  | Description:\nHigh Weakness2 determined with evidence
Spreadsheet: 106205d1303389823-simultaneous-updating-worksheets-overdue-ageing-1-
Sheet: WEST 

NAME OF THE COMPANY |  |  | ABC & CO
 |  |  | WEST ZONE
DETAILS OF AGE-WISE DEBTORS REPORT AS ON |  |  | 2011-04-15 00:00:00
Name of the Party | Party Status | Invoice Date | Invoice No. | Credit Period | Due Date | Delay (Days) | Invoice Amount | Outstanding Invoice Amount (Rs.) | < 0 | <0 - 30> | <31 - 60> | <61 - 90> | <91 - 120> | <121 - 150> | <151 - 180> | > 180 Days
ATLAS COPCO | Dealer | 2010-10-31 00:00:00 | 361 | 60 | 2010-12-30 00:00:00 | 106 | 302400 | 100000 | 0 | 0 | 0 | 0 | 100000 | 0 | 0 | 0
SYNTHTHETIC RESGINS | Dealer | 2010-10-06 00:00:00 | 294 | 60 | 2010-12-05 00:00:00 | 131 | 1410338 | 894380 | 0 | 0 | 0 | 0 | 0 | 894380 | 0 | 0
HIPPO GREASE | Dealer | 2010-12-06 00:00:00 | 419 | 60 | 2011-02-04 00:00:00 | 70 | 894511 | 894511 | 0 | 0 | 0 | 894511 | 0 | 0 | 0 | 0
TOTAL OVERDUE AS ON DATE |  |  |  |  |  |  | 2607249 | 1888891 | 0 | 0 | 0 | 894511 | 100000 | 894380 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1539109 | 0 | 894511 | 192320 | 894380 | 0 | 118288
 |  |  |  |  |  |  |  |  |  | 894511 | 694720 | 1029380 | 0 | 0 | 118288 | 0
 |  |  |  |  |  |  |  |  |  | -894511 | -694720 | -134869 | 100000 | 894380 | -118288 | 0
Spreadsheet: 72153d1272884214-identifying-first-entry-in-long-list-of-duplicates-price
Sheet: Sheet1

Product A | Week 1 | Price $1 | initialprice | initialprice | initialprice
Product A | Week 2 | Price $1 | older prices |  | current price
Product A | Week 3 | Price$1.5 | older prices |  | current price
Product b | Week 1 | Price $12 | initialprice | initialprice | initialprice
Product b | Week 2 | Price $12 | older prices |  | current price
Product b | Week 3 | Price$15 | current price | current price | current price
Product A | Week 4 | price 20 | current price | current price | current price
Spreadsheet: 693863d1599188133-tiered-table-help-tiered
Sheet: Sheet1

Tiered Price Backup | Start | End | Split
 | 0 | 5 | 1 | 195
 | 6 | 25 | 6 | 95
 | 26 | 10000 | 26 | 55
Tiered Price DR | 1 | 5 | 1 | 395
 | 6 | 25 | 6 | 295
 | 26 |  | 26 | 195
Backup | 50
DR | 8
Spreadsheet: 074157d6-6f3b-49a5-891d-0d6b47d2a8b9
Sheet: Introduction

 | This  spreadsheet accompanies the U.S. GAAP Financial Reporting Taxonomy v2013 Release Notes (January 31, 2013):
 | Below is the link to the worksheet which lists the elements by change made.
 |  |  | Appendix | No. of Elements
 |  |  | Appendix 1: Data Type Changes | 5
 |  |  | Appendix 2: Balance Type Changes | 1
 |  |  | Appendix 3: Deprecated Items | 955
 |  |  | Appendix 3: Undeprecated Items | 7
 |  |  | Appendix 4: Label Changes | 673
 |  |  | Appendix 5: Reference Changes | 659
 |  |  | Appendix 6: Definition Changes | 1256
 |  |  | Appendix 7: New Elements | 1006
 |  |  | Appendix 8: Deleted Elements | 357
Spreadsheet: 210138d1359388138-data-validation-fromn-two-different-named-range-alternatives-data-for-help
Sheet: 2013

 |  | NEW CLAIMS |  |  | FEES | 2013
 |  | MONTH | POLICYHOLDER | AGENCY | Jan | Feb | Mar | April | May | June | July | Aug | Sept | Oct | Nov | Dec
 |  | Jan |  | Cambridge
Spreadsheet: 196321d1353955332-moving-email-adresses-into-next-column-names-and-email-address
Sheet: Sheet1

Name | Email address
Arial, [NAME]
[EMAIL]
[NAME], Toby
[EMAIL]
Bacca, Debbie
[EMAIL]
Barer, Leigh
[EMAIL]
Bevers, [NAME]
[EMAIL]
Buell, [NAME]
[EMAIL]
Campbell, [NAME]
[EMAIL]
Carruth, Danielle
[EMAIL]
Cassedy, [NAME]
[EMAIL]
Chambers, Curt
[EMAIL]
Spreadsheet: 63184d1264112399-excel-2007-creating-a-interactive-chart-to-filter-data-survey
Sheet: Data Viewing

 | Total | Never | Sometimes | Regularly | Often | Daily | Addict
How many people use Facebook?
How many people use [NAME]?
Can they use these from their mobile?
 | Atmosphere | Location | Events | Music | Price | Service | Sports | Women
What are these people looking for?
 | Liquor | Beer
What drinks are they looking for?
 | 1 | 2 | 3 | 4
How much are they wanting to spend on drinks?
 | Under 21 | 21-25 | 26-30 | 31-35 | 36-40 | 41 and over
How old are they?
 | Male | Female
Gender ratio
Spreadsheet: 769026d1645261865-getting-a-sum-not-the-basic-formula-forum-post
Sheet: Sheet1

12 | 12 | 12 | 4/8K | d | D | D | 12A | 12B | 12F | 4/8K | 12 | D | D
1st set |  |  |  |  |  |  | 2nd set
this would be the standard look - 40 with 8K |  |  |  |  |  |  | counting the 12's with  A, B, F would be 52 with 8K, red would a fault needing to be corrected
 |  |  |  |  |  |  | my base would be the 40
 |  |  |  |  |  |  | once I make the correction
 |  |  |  |  |  |  | 12A | 12B | 12F | 4/8K | 12K | D | D
 |  |  |  |  |  |  | no fault shown
Spreadsheet: 871754d1718178784-sequential-numbering-based-on-dropdown-selection-seq-number
Sheet: Sheet1

ID | Type | Name
 | P
1.1 | T
1.2 | T
1.3 | T
1.4 | T
1.5 | T
1.6 | T
1.7 | T
1.8 | T
1.9 | T
1.10 | T
1.11 | T
1.11.1 | S
1.11.2 | S
1.12 | T
2 | P
2.1 | T
2.2 | T
2.3 | T
3 | P
3.1 | T
3.1.1 | S
3.1.2 | S
4 | P
4.1 | T
4.2 | T
4.2.1 | S
4.3 | T
4.3.1 | S
Spreadsheet: 466801d1466448770-report-formula-query-profitability-may-2016
Sheet: Cumulative

 | Cumulative Projects Profitability
 | Project | Value based on Cost Values | Value Based on Chargeability Values | Invoiced | Profitability % | Overservicing %
1
 | Project | Value based on Cost Values | Value Based on Chargeability Values | Invoiced | Profitability % CH | Overservicing %
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
Spreadsheet: 125728d1319200137-if-formula-referencing-another-if-formula-returns-value-error-copy-of-nominal-charges
Sheet: Oct11

Date: | RO Ref: | PO Ref: | Quantity: | Item: | Price: | Net: | VAT: | Gross:
2011-10-10 00:00:00 | 1110-05
2011-10-12 00:00:00 | 1110-06
2011-10-04 00:00:00 | 1110-08
2011-10-04 00:00:00 | 1110-09
2011-10-11 00:00:00 | 1110-10
Spreadsheet: 32054520-ccd6-4eca-8680-da06ccd62e27
Sheet: Clinical

Dept No. | Department Name | Manager | Phone | Manager [NAME] | Manager [NAME] | Chair/Dean/Director | Phone | Chair Email | Department Address | Division
4215 | Urology | [NAME] | 445-5298 | [NAME] | [NAME] | Raj Pruthi | 843-9330 | [EMAIL] | 2113 Physicians Office Building | Clinical
4216 | Pathology | [NAME] | 966-4676 | [EMAIL] | [NAME] | [NAME] | 966-4676 | [EMAIL] | 301 Brinkhous Bullitt Building | Clinical
4222 | UNC Center for Heart & Vascular Care | [NAME] | 843-5429 | [EMAIL] | [NAME] | [NAME] | 843-6477 | [EMAIL] | 101 Manning Drive | Clinical
4228 | Medicine | Bruce Wicks  [NAME] | 843-[PHONE] | [EMAIL]  [EMAIL] | [NAME] | Marschall Runge | 966-4468 | [EMAIL] | 125 MacNider Hall | Clinical
4229 | Dermatology | [NAME] | 843-4911 | [EMAIL] | [NAME] | [NAME] | 843-6756 | [EMAIL] | 405 [NAME] | Clinical
4230 | Neurology | [NAME] | 966-5548 | [EMAIL] | [NAME] | [NAME] | 966-5522 | [EMAIL] | Physicians Office Building, 170 Manning Drive | Clinical
4232 | Family Medicine | [NAME] | 966-3102 | [EMAIL] | [NAME] | [NAME] | 966-3711 | [EMAIL] | 590 Manning Drive | Clinical
4233 | Neurosurgery | [NAME] | 962-5099 | [EMAIL] | [NAME] | [NAME] | 966-1374 | [EMAIL] | Physicians Office Building, 170 Manning Drive | Clinical
4236 | Obstetrics & Gynecology | [NAME] | 966-8938 | [EMAIL] | [NAME] | [NAME] | 966-5281 | [EMAIL] | 3009 Old Clinic Building | Clinical
4238 | Otolaryngology (ENT) | [NAME] | 966-3342 | [EMAIL] | [NAME] | [NAME] | 966-8926 | [EMAIL] | Physicians Office Building, Room G-190 | Clinical
4244 | Ophthalmology | [NAME] | 843-5571 | [EMAIL] | [NAME] | [NAME] | 843-0297 | [EMAIL] | 5151 Bioinformatics Building | Clinical
4248 | Pediatrics | [NAME] | 843-8748 / 843-8747 | [EMAIL] | [NAME] | [NAME] | 966-9145 | [EMAIL] | 260 MacNider Hall | Clinical
4256 | Psychiatry | [NAME] | 843-7077 | [EMAIL] | [NAME] | [NAME] | 966-4738 | [EMAIL] | 10617 Neurosciences Hospital | Clinical
4260 | Radiology | [NAME] | 966-3521 | [EMAIL] | [NAME] | [NAME] | 966-4406 | [EMAIL] | 2006 Old Clinic Builidng | Clinical
4262 | Radiation Oncology | [NAME] | 966-0400 | [EMAIL] | [NAME] | [NAME] | 966-0400 | [EMAIL] | 101 [NAME], [NAME], Room CB325 | Clinical
4264 | Surgery | [NAME] | 843-1236 | [EMAIL] | [NAME] | [NAME] | 966-4320 | [EMAIL] | 4001 Burnett-Womack Building | Clinical
4265 | Orthopaedics | [NAME] | 966-4540 | [EMAIL] | [NAME] | [NAME] | 966-9066 | [EMAIL] | 3147 Bioinformatics Building | Clinical
4266 | Emergency Medicine | [NAME] | 843-2611 | [EMAIL] | [NAME] | [NAME] | 843-3045 | [EMAIL] | Physicians Office Building, 170 Manning Drive | Clinical
4268 | Anesthesiology | [NAME] | 966-6182 | [EMAIL] | [NAME] | [NAME] | 966-5136 | [EMAIL] | N2198 UNC Hospitals | Clinical
4273 | Allied Health | [NAME] (interim) | 843-4828 | [EMAIL] | [NAME] | [NAME] | 966-5171 | [EMAIL] | 3108 Bondurant Hall | Clinical
4296 | Physical Medicine & Rehabilitation | [NAME] | 966-0316 | [EMAIL] | [NAME] | [NAME] | 966-5164 | [NAME] | [NAME] 7009 UNC [NAME] | Clinical
Spreadsheet: 722365d1615220467-highlight-cells-if-a-range-does-not-contain-a-date-within-last-7-days-testing-log-example
Sheet: Sheet1

 | Week 1 |  | Week 2 |  | Week 3
 | 2021-03-08 00:00:00
Student 1 | 2021-02-25 00:00:00 | 2021-02-28 00:00:00
Student 2 | 2021-03-04 00:00:00 | 2021-03-07 00:00:00
Student 3 | 2021-03-05 00:00:00 | 2021-03-08 00:00:00
Student 4 | 2021-02-28 00:00:00 | 2021-03-05 00:00:00
Student 5 | 2021-03-02 00:00:00 | 2021-03-08 00:00:00
Student 6 | 2021-03-04 00:00:00 | 2021-03-07 00:00:00
Spreadsheet: 90083d1289839717-formula-based-on-another-cell-efernandes67-serialize-by-value-within-a-list-questionnumber
Sheet: Sheet1

 | ID | nbQuestion | Test | Question
 | 1 |  | Test1 | Question1
 |  |  | Test2 | Question2
 | 3 |  | Test2 | Question3
 | 4 |  | Test3 | Question4
 | 4 |  | Test2 | Question5
 | Expected Result
 | ID | nbQuestion | Test | Question
 | 1 |  | Test1 | Question1
x |  |  | Test2 | Question2
x | 3 |  | Test2 | Question3
 | 4 |  | Test3 | Question4
x | 5 |  | Test2 | Question5
Spreadsheet: 886634d1736711916-is-it-possible-to-speed-up-formula-calculation-patterns
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | TOP COLUMN POSITION | 3 | 3 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | BOTTOM COLUMN POSITION | 3 | 3 | 3 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 | 1 | 1 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | TOP GAP | 17 | 15 | 30 | 3
 | COLUMN | COLUMN | COLUMN |  |  |  |  |  |  |  |  |  | BOTTOM GAP | 0 | 0 | 0 | 5
 | 1 | 2 | 3
 | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | 7 | 2 | 2
 | 4 | 8 | 2
 | 5 | 7 | 9
 | 1 | 3 | 9
 | 9 | 6 | 2
 | 9 | 7 | 7
 | 8 | 8 | 7
 | 8 | 5 | 4
 | 8 | 2 | 1
 | 3 | 6 | 3
 | 1 | 9 | 9
 | 4 | 5 | 2
 | 2 | 5 | 5
 | 1 | 1 | 5
 | 3 | 8 | 7
 | 7 | 5 | 2
 | 7 | 5 | 0
 | 7 | 0 | 8
 | 8 | 5 | 6
 | 4 | 8 | 2
 | 9 | 7 | 4
 | 2 | 5 | 1
 | 1 | 5 | 0
 | 4 | 2 | 1
 | 3 | 4 | 4
 | 3 | 1 | 3
 | 8 | 3 | 7
 | 9 | 0 | 3
 | 9 | 9 | 9
 | 6 | 2 | 8
 | 8 | 4 | 8
 | 2 | 1 | 1
 | 4 | 2 | 6
 | 2 | 7 | 5
 | 0 | 2 | 2
 | 7 | 5 | 8
 | 5 | 3 | 2
 | 6 | 4 | 3
 | 2 | 0 | 6
 | 0 | 0 | 2
 | 9 | 1 | 7
 | 9 | 5 | 4
 | 7 | 2 | 9
 | 5 | 8 | 1
 | 3 | 4 | 3
 | 0 | 9 | 0
 | 2 | 4 | 5
 | 5 | 1 | 7
 | 9 | 5 | 3
 | 3 | 4 | 8
 | 5 | 7 | 4
 | 6 | 2 | 3
 | 8 | 4 | 0
 | 7 | 7 | 9
 | 6 | 3 | 4
 | 9 | 4 | 3
 | 8 | 2 | 2
 | 2 | 0 | 3
 | 2 | 3 | 1
 | 2 | 6 | 2
 | 8 | 5 | 2
 | 0 | 4 | 5
 | 5 | 7 | 2
 | 6 | 4 | 7
 | 5 | 1 | 1
 | 3 | 4 | 4
 | 2 | 5 | 0
 | 0 | 0 | 1
 | 7 | 8 | 3
 | 4 | 4 | 7
 | 5 | 9 | 7
 | 3 | 6 | 2
 | 6 | 1 | 6
 | 0 | 1 | 2
 | 1 | 7 | 4
 | 5 | 2 | 6
 | 5 | 3 | 5
 | 6 | 8 | 8
 | 0 | 4 | 9
 | 3 | 7 | 3
 | 3 | 4 | 3
 | 1 | 5 | 2
Spreadsheet: 0d0eb17a-9507-482c-9eaa-d2b3774e426e
Sheet: Sheet1

LINCOLN UNVERSITY MONTHLY TIMESHEET | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 |  |  | Please type or print all information below.
 |  | EMPLOYEE NAME: |  |  |  | SSN/ID #: |  |  |  |  | Month Worked
 |  | DEPARTMENT: |  |  |  | SUPERVISOR:
 |  | FUNDING ACCOUNT NO. |  |  |  | PHONE EXT:
 |  |  |  |  |  | BUILDING/RM:
 |  | RATE OF PAY: |  |  | Proj # |  |  |  |  |  | Below is for Payroll Office Use Only
 |  |  |  |  |  |  |  |  |  |  | Previous hrs worked in week:
 | DATE | START TIME | END TIME | START TIME | END TIME | TOTAL HRS | REG HRS | OVT HRS
S |  |  |  |  |  | 0 |  |  |  | Payroll Office Use Only
M |  |  |  |  |  | 0
T |  |  |  |  |  | 0
W |  |  |  |  |  | 0
T |  |  |  |  |  | 0
F |  |  |  |  |  | 0
S |  |  |  |  |  | 0
 |  |  |  |  | Weekly Total | 0 | 0 | 0
S |  |  |  |  |  | 0
M |  |  |  |  |  | 0
T |  |  |  |  |  | 0
W |  |  |  |  |  | 0
T |  |  |  |  |  | 0
F |  |  |  |  |  | 0
S |  |  |  |  |  | 0
 |  |  |  |  | Weekly Total | 0 | 0 | 0
S |  |  |  |  |  | 0
M |  |  |  |  |  | 0
T |  |  |  |  |  | 0
W |  |  |  |  |  | 0
T |  |  |  |  |  | 0
F |  |  |  |  |  | 0
S |  |  |  |  |  | 0
 |  |  |  |  | Weekly Total | 0 | 0 | 0
S |  |  |  |  |  | 0
M |  |  |  |  |  | 0
T |  |  |  |  |  | 0
W |  |  |  |  |  | 0
T |  |  |  |  |  | 0
F |  |  |  |  |  | 0
S |  |  |  |  |  | 0
 |  |  |  |  | Weekly Total | 0 | 0 | 0
S |  |  |  |  |  | 0
M |  |  |  |  |  | 0
T |  |  |  |  |  | 0
W |  |  |  |  |  | 0
T |  |  |  |  |  | 0
F |  |  |  |  |  | 0
S |  |  |  |  |  | 0
 |  |  |  |  | Weekly Total | 0 | 0 | 0
 |  |  |  |  | Monthly Totals | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | Hrs in week carried over for OT purposes:
 |  | EMPLOYEE SIGNATURE: |  |  |  |  |  | Payroll Office Use
 |  | SUPERVISOR SIGNATURE:
 |  |  | I HAVE REVIEWED AND APPROVED HOURS AS STATED
 | Lincoln University's work schedule is Sunday through Saturday.
 | Overtime hours are earned if hours worked exceed 40 hours in a week.
Spreadsheet: james_steffes__12842__CTCanalysis3
Sheet: PG&E_Summary

 |  |  | [NAME] 00 | Oct-Dec 00
PG&E |  |  |  |  | Jan 5-18 | Jan 19-31 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | Fwd (PV)
DA Volumes/Fwd Position
Bundled Rate -- No Surcharges
Non-Gen (T&D plus Other)
Gen (Bundled - Non-Gen)
Jan 4 Surcharge |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
[NAME] |  |  | 0 | 0
PX Price: Assuming DWR = $54.71
PX Price: PG&E "Adjusted"
PX Price: Actual/DJ/ENA Fwd
CTC: Assuming DWR = $54.71
CTC: PG&E "Adjusted"
CTC: Actual/DJ/ENA Fwd
As Booked, Collected, Paid, Reserved, Etc.
CTC
[NAME]
PX Price
CTC
MTM Value ($000)
Surcharge(s)
Total Surcharge |  |  | 0 | 0
MTM Value ($000)
Net P/L Impacts of Changes
CTC Eliminated as of Jan 4 |  |  | 0 | 0
CTC Eliminated as of Jan 19 |  |  | 0 | 0 | 0
CTC Adjusted as of Jan 4
DWR = $54.71 |  |  | 0 | 0
PG&E "Adjusted" |  |  | 0 | 0
CTC Adjusted as of Jan 19
DWR = $54.71
PG&E "Adjusted"
Jan Surcharge Goes Away
Jan Surcharge Goes Away as of Sep 1
Return to Bundled Service
Spreadsheet: 768187d1644874034-drag-and-copy-conditional-formatting-for-color-bar-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Ledger | Allocated Budget | Expenses | Remaining
 |  |  |  |  |  |  |  |  | 5100 | 4355.35 | 240.33
 |  |  |  |  |  |  |  |  | 5200 |  |  |  |  | Expenses data bar shows the amount of Allocated Budget in color gradient as a number from 0 to [NAME] in K column.
 |  |  |  |  |  |  |  |  | 5210
 |  |  |  |  |  |  |  |  | 5250 | 9844.6 | 1700.65 |  |  | How can I 'drag down' the conditional formatting in this case and have adjacent K & L cells refer to each other?
 |  |  |  |  |  |  |  |  | 5260 |  |  |  |  | Can't use relative reference such as K3, need to be $[NAME]
 |  |  |  |  |  |  |  |  | 5270 | 158.98 | 50
 |  |  |  |  |  |  |  |  | 6030
 |  |  |  |  |  |  |  |  | 6100 | 2177.1 | 1399.87 |  |  | I want to avoid setting the formatting for every damned cell in the table. I have done two for example.
 |  |  |  |  |  |  |  |  | 6260 | 10800 | 5700
 |  |  |  |  |  |  |  |  | 6261
 |  |  |  |  |  |  |  |  | 6270 | 136.08 | 158
 |  |  |  |  |  |  |  |  | 6400
 |  |  |  |  |  |  |  |  | 6450
 |  |  |  |  |  |  |  |  | 6600 | 698.06 | 198
 |  |  |  |  |  |  |  |  | 6610
 |  |  |  |  |  |  |  |  | 6620 | 12000 | 13100
 |  |  |  |  |  |  |  |  | 6630
 |  |  |  |  |  |  |  |  | 6640
 |  |  |  |  |  |  |  |  | 6650 | 23473 | 22251
 |  |  |  |  |  |  |  |  | 6700
 |  |  |  |  |  |  |  |  | 6701
 |  |  |  |  |  |  |  |  | 6750
 |  |  |  |  |  |  |  |  | 6810 | 1800
 |  |  |  |  |  |  |  |  | 6840
 |  |  |  |  |  |  |  |  | 6960
 |  |  |  |  |  |  |  |  | 6970 | 2600 | 1974
 |  |  |  |  |  |  |  |  | 6990
 |  |  |  |  |  |  |  |  | 6998
 |  |  |  |  |  |  |  |  | 7000 | 2100.5 | 1988.66
 |  |  |  |  |  |  |  |  | 7040
 |  |  |  |  |  |  |  |  | 7070
 |  |  |  |  |  |  |  |  | 7080
 |  |  |  |  |  |  |  |  | 7090
 |  |  |  |  |  |  |  |  | 7100
 |  |  |  |  |  |  |  |  | 9999
 |  |  |  |  |  |  |  |  | Totals:
Spreadsheet: 748930d1632416495-true-false-not-being-picked-up-by-if-function-demo-for-excel-help
Sheet: Sheet1

NAME | Points
[NAME] | 1.5 | True
[NAME] | 4.5 | True
[NAME] | 1
[NAME] | 4
Elijah | 2
[NAME] | 3.5
[NAME] | 3.5
[NAME] | 1.5
Ian | 4.5
[NAME] | 2
Kenan | 1
[NAME] | 3.5
Spreadsheet: 146126d1331910935-calculating-number-of-days-in-leap-year-nav-calculator
Sheet: Sheet1

Policy Number | Effective Date | Dollar Amount | Calculated Value | Principal | Interest Rate | Interest Earned | Year | Combined | Days | Int Rate
INITIAL | 2011-01-01 00:00:00 | 18092.84 | 18092.84 | 18092.84
 | 2012-01-01 00:00:00 | 10000 | 29178.41 | 18092.84 | 6 | 11085.57 | 365 | 0 | 365 | 0.06
 | 2012-12-31 00:00:00 | 15000 | 45929.11 | 18092.84 | 6 | 27836.27 | 0 | 365 | 365 | 0.06
Spreadsheet: 767664d1644576368-variable-column-for-vlookup-possible-book3
Sheet: Sheet2

Aantal ronden aan de leiding gereden per race. |  |  |  | Aantal
 |  |  | Totaal |  | 10° Targa [NAME] | 1° Circuito di Mugello | 11° Targa [NAME]
 |  |  |  |  | nWK | nWK | nWK
 |  |  |  |  | 108 | 64.9 | 108
Abate | Carlo |  |  |  |  |  |  | IFERROR((VLOOKUP($C5;Sheet1!$C$5:H$5000;6)*H$4);"-")
Ábate | Walter
Abecassis | George
Abney | [NAME]
[NAME] | Lino
Accadia | Agostino
Achard | [NAME]
Acheson | Kenny
Ación | [NAME]
Adams | [NAME]
Adant | [NAME]
Adas | [NAME]
Ader | [NAME]
Adolff | Kurt
Agabashian | Fred
Agostini | Giacomo
Agúero | [NAME]
Aguirre | Juan
Aguirre | [NAME]
Ahrens | Kurt
[NAME] | Guido
Aitken | [NAME]
Alabern | [NAME]
Albanese | [NAME]
Albers | Christijan
Alberti | Augustín
Spreadsheet: 91553d1291243937-excel-2007-help-with-formula-trying-to-do-a-multiple-select-based-on-range-example
Sheet: Sheet1

Contract Table |  |  |  |  |  | Actual Invoice Table
Name | Start Date | End Date | Contract Rate |  |  | Name | Date Worked | Invoice Rate | Contract Rate
Smith | 2010-01-01 00:00:00 | 2010-01-31 00:00:00 | 150 |  |  | Smith | 2010-01-02 00:00:00 | 140
Smith | 2010-02-01 00:00:00 | 2010-02-28 00:00:00 | 175 |  |  | Smith | 2010-01-05 00:00:00 | 150
Jones | 2010-01-01 00:00:00 | 2010-01-15 00:00:00 | 140 |  |  | Smith | 2010-02-07 00:00:00 | 250
Jones | 2010-01-16 00:00:00 | 2010-01-31 00:00:00 | 180 |  |  | Jones | 2010-02-15 00:00:00 | 185
Jones | 2010-02-15 00:00:00 | 2010-02-28 00:00:00 | 175 |  |  | Jones | 2010-02-16 00:00:00 | 180
Spreadsheet: ebc452a0-e7d3-45a8-b0e8-5bc452f8df66
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44435976 | 2014-12-14 07:41:10 | AXIS | 0 | 5 | 7 | 1663862 | player1663862 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44436250 | 2014-12-14 08:11:19 | ALLIES | 1 | 7 | 1 | 1007284 | Temple58 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
Spreadsheet: 4e583897-5e51-4db2-bc57-b99c6b32fc99
Sheet: Sheet1

WI Dept of Administration | Envelope [NAME] | Unnamed: 2 | Division of Enterprise Operations
Ch. 35.03 [NAME]. |  |  | State Bureau of Procurement
DOA-3420 (R04/2102) |  |  | http://vendornet.state.wi.us/
Lot A Inkjet PreMade Envelopes |  |  | Lot A
 |  |  | Contract No. 15-99990-117
INSTRUCTIONS: To complete this form, TAB to each GREEN field and fill In the appropriate information. Subtotals wilI fill in automatically.  Print TWO copies: mail one with the purchase order and keep the second copy for your records.
Production Plant Location: | Kenosha WI or Danville IL
Pricing  is for production only. Stocked Blank Envelope prices are additional.
Quantities - 1,000-100,000 |  | Purchase Order No.:
 |  | Quantity:
 |  | Cost | (Enter quanity as 0.000)
Base Prepress: | 1 Color |  | (Units of one thousand)
 | 2 Color
 | 3 Color
 | 4 Color
Image Assembly: | Film/CTP RIP Time
Basic Proof : | 1 Color |  | List PMS Ink numbers below:
 | 2 Color
Color Proof: | 3 Color
 | 4 Color
Scanning: | Each
Production MakeReady: | 1 Color
 | 2 Color
 | 3 Color
 | 4 Color
Costs are based on Running Per One Thousand One side only. |  |  | Type of Envelope:
Commercial Envelope [NAME]: | Run Charges:
6.75 |  | 0 | (Example: Regular )
9 |  | 0
10 |  | 0
Booklet/Catalog Envelope Size: | Run Charges:
6 x 9 |  | 0
6-1/2 x 9-1/2 |  | 0
9 x 12 |  | 0
10 x 13 |  | 0
Additional Items: | Run Charges:
Metal Clasp |  | 0
Latex Gum |  | 0
 | Price per 1,000:
Price for Blank Envelopes: |  | 0
 | TOTAL ORDER COST | 0
Total Order Cost is calculated by adding Prepress costs and multipling the Run Charge/M times the Quantity plus Price for Blank Envelopes/M x Quantity.
Spreadsheet: 69674d1270229010-have-a-cell-hold-a-value-if-conditions-are-not-met-hydraulic1
Sheet: Hyd Cal

 | CRUDE |  |  | CRUDE | CRUDE | CRUDE | CRUDE | CRUDE |  |  |  | Products
API Gr. | 37 |  |  | 36 | 36 | 36 | 36 | 36 |  |  |  | 67.5
Sp. Gr. |  |  |  | 0.84 | 0.84 | 0.84 | 0.84 | 0.84
Vis | 10.4 |  |  | 10.4 | 10.4 | 10.4 | 10.4 | 10.4 |  |  |  | 0.65
C - Factor |  |  |  |  |  |  |  |  |  |  |  | 170
[NAME]. | 0.76 |  |  |  |  |  |  |  |  |  |  | 0.76
B/D Pump
BPH | 800 |  |  | 800 | 800 | 800 | 800 | 800 |  |  |  | 600
GPM
B/D Sch | 10800 |  |  | 10800 | 10800 | 10800 | 10800 | 10800 |  |  |  | 14400
Space B/D
Run Time
Station From
Elevation | 2695 |  |  | 1925 | 2200 | 2150 | 2020 | 1820 |  |  |  | 1490
Station To
End Elevation | 1925 |  |  | 2200 | 2150 | 2020 | 1820 | 1740 |  |  |  | 980
End Pressure |  |  |  |  |  |  |  | 30 |  |  |  | 25
[NAME] | 12.25 |  |  | 12.25 | 12.25 | 12.25 | 12.25 | 12.25 | 12" pipe
[NAME] | 54.87 |  |  | 24.23 | 17.54 | 17.62 | 27.32 | 16.17 |  |  |  | 227.5
Reynolds
PSI/Mi
Elec KWH/Y
Sta Press
hp
$/KWH | 0.05 |  |  | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 |  |  |  | 0.05
$/Y
$/KWH | 0.07 |  |  | 0.07 | 0.07 | 0.07 | 0.07 | 0.07 |  |  |  | 0.07
$/Y
 |  |  |  |  |  |  |  |  |  | BPH | PSI
 |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  | 2400
 |  |  |  |  |  |  |  |  |  | 2300
 |  |  |  |  |  |  |  |  |  | 2200
 |  |  |  |  |  |  |  |  |  | 2100
 |  |  |  |  |  |  |  |  |  | 2000
 |  |  |  |  |  |  |  |  |  | 1900
 |  |  |  |  |  |  |  |  |  | 1800 | 350
 |  |  |  |  |  |  |  |  |  | 1700 | 307
 |  |  |  |  |  |  |  |  |  | 1600 | 265
 |  |  |  |  |  |  |  |  |  | 1500 | 225
 |  |  |  |  |  |  |  |  |  | 1400 | 187
 |  |  |  |  |  |  |  |  |  | 1300 | 151
 |  |  |  |  |  |  |  |  |  | 1200 | 117
 |  |  |  |  |  |  |  |  |  | 1100 | 85
 |  |  |  |  |  |  |  |  |  | 1000 | 56
 |  |  |  |  |  |  |  |  |  | 900 | 28
 |  |  |  |  |  |  |  |  |  | 800