tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 117691d1312968765-advanced-formula-for-linking-values-in-two-sheets-differ-under-conditions-help_request
Sheet: Planning_base

LOB | 2011 | Person | Role | Planning percentage
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Project 1 | [NAME] | Tester |  |  |  |  |  |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
 | Project 2 | [NAME] | Tester |  |  |  |  |  |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
 | Project 3 | [NAME] |  |  |  |  |  |  |  |  | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
 |  | [NAME] |  |  |  |  |  |  |  |  | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
 | Project 4 | [NAME] |  |  |  |  |  |  |  |  | 0.4 | 0.4 | 0.4 | 0.4 | 0.4
 |  | [NAME] |  |  |  |  |  |  |  |  | 0.8 | 0.8 | 0.8 | 0.8 | 0.8
 | Project 5 | [NAME] | Dev |  |  |  |  |  |  |  | 0.75 | 0.75 | 0.75 | 0.75 | 0.75
 |  | [NAME] | Dev |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
 |  | [NAME] | Dev |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
 |  | [NAME] | Dev |  |  |  |  |  |  |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2
 |  | [NAME] | Tester |  |  |  |  |  |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
 |  | Eva Poland | Tester |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
 |  | [NAME] | Tester |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
 |  | [NAME] | Analyst |  |  |  |  |  |  |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2
Spreadsheet: 145429d1331578237-need-to-get-average-for-the-elapsed-times-excel-elapsed
Sheet: Sheet1

ITDCREATEDDATE | Elapsed Time from creation to 1st Contact (days, hrs, min, sec) | ACTUALCONTACTDATE | ACTUALFINISH | ACTUALSTART | Elapsed Time-Initial to Finish (days, hrs, min, sec) | AFFECTEDDATE | CLOSEDATE | [NAME] | INTERNALPRIORITY | STATUSDATE
2011-01-01 01:14:37 |  | 2011-01-01 01:17:16 | 2011-01-01 01:16:00 |  |  | 2011-01-01 01:14:00 | 2011-01-05 10:02:12 | NA Domain - Password Reset | 3 | 2011-01-05 10:03:19
2011-01-01 15:36:01 |  | 2011-01-01 16:56:35 | 2011-01-01 16:55:00 |  |  | 2011-01-01 15:36:00 | 2011-01-07 23:19:22 | user is getting blue screen error on her laptop | 3 | 2011-01-07 23:20:29
2011-01-01 15:59:50 |  | 2011-01-01 17:09:54 | 2011-01-01 17:08:00 |  |  | 2011-01-01 15:59:00 | 2011-01-07 23:19:28 | User need to reset Encryption | 3 | 2011-01-07 23:20:35
2011-01-01 16:41:30 |  | 2011-01-01 16:45:09 | 2011-01-01 16:44:00 |  |  | 2011-01-01 16:41:00 | 2011-01-07 23:19:34 | NA Domain - Password Reset | 3 | 2011-01-07 23:20:41
2011-01-01 17:01:57 |  | 2011-01-01 17:05:35 | 2011-01-01 17:04:00 |  |  | 2011-01-01 17:01:00 | 2011-01-07 23:19:39 | Peoplesoft HR password reset | 3 | 2011-01-07 23:20:47
2011-01-02 03:14:59 |  | 2011-01-02 03:29:05 | 2011-01-02 03:28:00 |  |  | 2011-01-02 03:14:00 | 2011-01-07 23:19:45 | User could not view mysource tabs | 3 | 2011-01-07 23:20:53
2011-01-02 11:28:05 |  | 2011-01-02 11:38:28 |  | 2011-01-03 11:17:00 |  | 2011-01-02 11:28:00 |  | user's laptop power is not turning on | 3 | 2011-01-12 01:52:49
2011-01-02 14:58:26 |  | 2011-01-02 15:45:46 | 2011-01-02 15:45:00 |  |  | 2011-01-02 14:58:00 | 2011-01-07 23:19:59 | Ethics and comliance | 3 | 2011-01-07 23:21:07
Spreadsheet: 211437d1359745213-1-1-million-data-points-that-need-to-be-sorted-ef347_split_data
Sheet: Sheet2

Header_1 | Header_2
Spreadsheet: 817003d1675942304-calculating-savings-in-a-year-based-on-a-date-new-microsoft-excel-worksheet
Sheet: Sheet1

 |  |  |  |  | 2023-03-30 00:00:00 | 2023-06-30 00:00:00 | 2023-09-30 00:00:00 | 2023-12-31 00:00:00
 |  |  |  |  | 2023
 | Costs | Cost per Qtr | End Date |  | Q1 | Q2 | Q3 | Q4
 | 90000 |  | 2023-02-28 00:00:00 |  |  | 22500 | 22500 | 22500
 |  |  | 2023-03-30 00:00:00 |  |  | 21375 | 21375 | 21375
 |  |  | 2023-04-05 00:00:00 |  | 0
 |  |  | 2023-04-10 00:00:00 |  | 0
 |  |  | 2023-06-15 00:00:00 |  | 0
 |  |  | 2023-08-20 00:00:00 |  | 0 | 0
 |  |  |  |  | Hard Coded
 |  |  |  |  | Basic Calculation for the current Quarter
Spreadsheet: 784158d1655473862-help-with-if-statement-returning-1900-01-00-ariel1987-mri-line-from-neuro-look-up-
Sheet: Sheet1

MRI Pending |  | Patno | Status | Research Status | Last Name | First name | MRN | HCN | DOB yyyy/mm/dd | Neurologist | MRI Type | Priority | Faxed yyyy/mm/dd | MRI APT.  yyyy_mmm_dd | TIME | SITE | MRI APPT SENT | RESULTS BACK | F/U | DMT | Infusions | JCV Status Ever + | Notes | Match | Validate | Confirm
Match | Validation | 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
Spreadsheet: 771887d1646907696-index-match-function-error-sample
Sheet: Sheet7

SCE
Pro | 2500000
WEE
Salary | 8500000
EVAW | 8500000
IGP
 | 10 | 158400
 |  |  | 351200
Spreadsheet: 268545d1380682614-if-the-difference-is-less-than-or-greater-than-50-return-value-example
Sheet: Sheet1

 |  |  | sold |  |  |  |  |  | sold
US | Exorcist | PLR4 | 100 |  |  | US | Exorcist | PLR4 | 100
US | Top Gun | PLR4 | 200 |  |  | US | Top Gun | PLR4 | 200
US | Jaws | PLR4 | 187 |  |  | US | Jaws | PLR4 | 300 |  | Reconciliation |  |  | [NAME] in M7:O7 can be dragged down
US | Avengers | PLR4 | 400 |  |  | US | Avengers | PLR4 | 400
US | GhostBusters | PLR4 | 500 |  |  | US | GhostBusters | PLR4 | 500 |  | Which films dont reconcile in the US or CA for PLR4 or PLA9
US | Trading Places | PLR4 | 600 |  |  | US | Trading Places | PLR4 | 600
US | Its a Wonderful Life | PLR4 | 700 |  |  | US | Its a Wonderful Life | PLR4 | 700
CA | Exorcist | PLR4 | 800 |  |  | CA | Exorcist | PLR4 | 800
CA | Top Gun | PLR4 | 900 |  |  | CA | Top Gun | PLR4 | 900
CA | Jaws | PLR4 | 1000 |  |  | CA | Jaws | PLR4 | 1000
CA | Avengers | PLR4 | 1100 |  |  | CA | Avengers | PLR4 | 1100
CA | GhostBusters | PLR4 | 1200 |  |  | CA | GhostBusters | PLR4 | 1200
CA | Trading Places | PLR4 | 1300 |  |  | CA | Trading Places | PLR4 | 1300
CA | Its a Wonderful Life | PLR4 | 1400 |  |  | CA | Its a Wonderful Life | PLR4 | 1400
US | Exorcist | PLA9 | 1500 |  |  | US | Exorcist | PLA9 | 1500
US | Top Gun | PLA9 | 1600 |  |  | US | Top Gun | PLA9 | 1600
US | Jaws | PLA9 | 1700 |  |  | US | Jaws | PLA9 | 1700
US | Avengers | PLA9 | 1800 |  |  | US | Avengers | PLA9 | 1800
US | GhostBusters | PLA9 | 1900 |  |  | US | GhostBusters | PLA9 | 1700
US | Trading Places | PLA9 | 2000 |  |  | US | Trading Places | PLA9 | 2000
US | Its a Wonderful Life | PLA9 | 2100 |  |  | US | Its a Wonderful Life | PLA9 | 2100
CA | Exorcist | PLA9 | 2200 |  |  | CA | Exorcist | PLA9 | 2200
CA | Top Gun | PLA9 | 2300 |  |  | CA | Top Gun | PLA9 | 2300
CA | Jaws | PLA9 | 2400 |  |  | CA | Jaws | PLA9 | 2400
CA | Avengers | PLA9 | 2500 |  |  | CA | Avengers | PLA9 | 2000
CA | GhostBusters | PLA9 | 2600 |  |  | CA | GhostBusters | PLA9 | 2600
CA | Trading Places | PLA9 | 2700 |  |  | CA | Trading Places | PLA9 | 2700
CA | Its a Wonderful Life | PLA9 | 2800 |  |  | CA | Its a Wonderful Life | PLA9 | 2800
 | Total |  |  |  |  |  | Total
Spreadsheet: 779861d1652153365-populate-calendars-based-on-office-location-daf-office-scheduling-draft-aligw
Sheet: WFH

Month: | May
Year: | 2022
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2 | 3 | 4 | 5 | 6 | 7
Spreadsheet: 711466d1609738846-subtotal-not-working-in-array-extracted-database-export-performance-reg-2021
Sheet: PROOF SHEET-FOREIGN

 | PROOF SHEET FOREIGN EXPORT-2021
EXPORTER | BILL NUMBER | DATE | BILL AMOUNT IN FC | BILL AMOUNT IN BDT | OD SIGHT/ TT DOC RATE | EXPORT LC/SC | APPLICANT NAME | ISSUING BANK/DOC. SENT TO | TENOR | FDBP NO. | FDBP DATE | PURCHASE AMOUNT OUTSTANDING BDT | DATE OF ACCPTNCE RECEIVED | MATURITY DATE | FDBC OUTSTANDING IN FC | FDBC OUTSTANDING IN BDT
TOTAL
Spreadsheet: f0ad26e7-7b13-4d29-b190-279f9c21fb95
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
258991 | 13392 | Ria | Jotter | GER |  | 00:21:42 | 00:01:13 | 00:39:13 | 00:01:02 | 00:12:32 | 1 | 01:15:39
258991 | 70564 | [NAME] | Bardsley | GBR |  | 00:21:28 | 00:01:32 | 00:41:40 | 00:01:20 | 00:12:43 | 2 | 01:18:40
Spreadsheet: 65178d1265895404-print-range-of-cells-factory-kpis-2010-2011new
Sheet: Press Efficiency 

 |  |  | Nr of operatives who produced data | 0 |  | PRESS EFFICIENCY
Week commencing |  |  | Days under review | 0
 |  |  | Avg hours worked per week | 40.5 |  | 0
* denotes an input cell
 | Mins downtime
Weekly downtime by category (mins) |  |  | Total available hrs | 40.5 |  |  |  | PRESS AMOUNT |  |  | HOURS
Waiting for work | 0 |  | Total available mins | 2430 |  |  |  | MON |  |  | MON | 8.5
Running high gloss | 0 |  | Avg Daily Downtime per person (mins) | #N/A | total downtime/nr of days under review/ nr of people |  |  | TUES |  |  | TUES | 8.5
Problems with temp | 0 |  | % downtime | 0 | mins downtime / available mins *100 |  |  | WEDS |  |  | WEDS | 8.5
Spraying | 0 |  | % uptime | 1 | 100 - % downtime |  |  | THURS |  |  | THURS | 8.5
Bailing | 0 |  | Press Target ( every 15mins ) | 160 | Available mins / 15 |  |  | FRI |  |  | FRI | 6.5
Other | 0 |  | Actual pressed Qty | 0 |  |  |  | TOTAL | 0 |  | TOTLA | 40.5
Changing rolls of foil | 0 |  | Nr of operatives working in the dept |  | Avg nr of people working in the dept
Press maintenance | 0 |  | Average weekly downtime by dept (mins) | #N/A | Avg nr of people working in the dept * avg downtime per person
[NAME] | 0 |  | weekly Cost @ £10 p/h | #N/A | average weekly downtime by dept * £10 per hr
Edgebander Maintenance | 0 |  | Annual cost at this rate (46 working wks) | #N/A
Total downtime (mins) | 0
Spreadsheet: 267597d1380118867-using-tables-contraload-deliveries-into-purfleet
Sheet: Sheet3

Tool | Order Reference | Production Date |  | Qty |  | Tool | Order Reference | Production Date |  | Qty |  | Tool | Order Reference | Production Date |  | Qty |  | Tool | Order Reference | Production Date |  | Qty
Spreadsheet: 1c50d35f-4fa0-4855-be04-1db97715989b
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
42355284 | 2014-07-18 19:58:11 | ALLIES | 0 | 4 | 6 | 331242 | AdairC | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
42355624 | 2014-07-18 20:18:22 | AXIS | 1 | 6 | 2 | 331242 | AdairC | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
42355957 | 2014-07-18 20:43:24 | AXIS | 0 | 2 | 6 | 689752 | Chevron Maze | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
42356265 | 2014-07-18 20:57:05 | ALLIES | 1 | 6 | 1 | 689752 | Chevron Maze | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
42356435 | 2014-07-18 21:18:25 | ALLIES | 1 | 5 | 4 | 1412777 | Royston Warke | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
42356679 | 2014-07-18 21:39:33 | AXIS | 0 | 3 | 5 | 1412777 | Royston Warke | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
42368870 | 2014-07-19 19:53:59 | ALLIES | 1 | 5 | 4 | 843039 | [NAME] | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
42369034 | 2014-07-19 20:13:40 | AXIS | 1 | 5 | 4 | 843039 | [NAME] | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
42369284 | 2014-07-19 20:34:34 | ALLIES | 0 | 5 | 7 | 298050 | MrBlonde | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
42369517 | 2014-07-19 20:46:28 | AXIS | 1 | 7 | 3 | 298050 | MrBlonde | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
42369733 | 2014-07-19 21:00:58 | AXIS | 1 | 5 | 1 | 1591724 | Gladiatore | 7334 | mediterranean | 1941-11-22 | 1941-11-22 | [NAME] | [NAME]
42369865 | 2014-07-19 21:16:05 | ALLIES | 1 | 5 | 4 | 1591724 | Gladiatore | 7334 | mediterranean | 1941-11-22 | 1941-11-22 | [NAME] | [NAME]
42397092 | 2014-07-21 19:02:00 | ALLIES | 0 | 1 | 6 | 1007618 | SFtredo | 12506 | eastern | 1941-07-21 | 1941-07-31 | [NAME] | Percée russe
42397283 | 2014-07-21 19:14:34 | AXIS | 1 | 6 | 0 | 1007618 | SFtredo | 12506 | eastern | 1941-07-21 | 1941-07-31 | [NAME] | Percée russe
Spreadsheet: 220735d1363254868-help-sum-the-cells-based-on-their-values-under-some-classification-sheet
Sheet: ENG

Name | Gender | Section | FA | SA | TOT
RAJ | B | A | A1 | A1 | A3
RAM | B | B | A3 | A3 | A1
JENOI | G | A | A1 | A3 | A2
ROSI | B | C | A1 | A1 | A1
KAN | G | B | A1 | A1 | A1
FAN | B | A | A1 | A2 | A1
Spreadsheet: gerald_nemec__11498__railcar soil and GW results
Sheet: Sheet1

DRAFT
TABLE 3
SOIL & GROUNDWATER SAMPLING RESULTS
COGENTRIX - RAILCAR UNLOADING SITE - LUMBERTON, NORTH CAROLINA
SOIL RESULTS
Parameter | Units | Concentration
 |  | RD-1-1 (11'-12') | RD-2-1 (11'-12')
TPH-Diesel in Soil | mg/kg | <5 | <5
GROUNDWATER RESULTS
Parameter | NC Standard | Units | Concentration
 |  |  | RD-1 | RD-2 | RCP-1 | RCP-2
Arsenic | 0.05 | mg/l | NA | NA | <0.005 | 0.007
Cadmium | 0.005 | mg/l | NA | NA | <0.001 | 0.0026
Chromium | 0.05 | mg/l | NA | NA | 0.0093 | 0.05
Copper | 1 | mg/l | NA | NA | <.002 | 0.005
Iron | 0.3 | mg/l | NA | NA | 5.9 | 9.8
Lead | 0.015 | mg/l | NA | NA | <0.005 | 0.016
Nickel | 0.1 | mg/l | NA | NA | 0.02 | 0.12
Selenium | 0.05 | mg/l | NA | NA | <0.005 | 0.012
Zinc | 2.1 | mg/l | NA | NA | 0.072 | 0.41
Mercury | 0.0011 | mg/l | NA | NA | <0.0002 | <0.0002
TDS | na | mg/l | NA | NA | 160 | 420
Chloride | 250 | mg/l | NA | NA | 4.2 | 4.8
Sulfate | 250 | mg/l | NA | NA | 89 | 260
TPH-Diesel in Water | na | ug/l | <100 | <100 | NA | NA
na - not applicable
NA = Not Analyzed |  |  | TPH = Total Petroleum Hydrocarbons
mg/kg = milligrams per kilogram |  |  | RD = Railcar Diesel
ug/l - micrograms per liter |  |  | RCP = [NAME]
mg/kg = milligrams per kilogram |  |  | Note:  Bold number indicates that result exceeds NC Groundwater Standard
Spreadsheet: eric_saibi__9846__100801
Sheet: Beaver Valley 01

Owner Name |  | First Energy Corporation
Station Name |  | Beaver Valley Nuclear Power Station
Unit Name |  | Beaver Valley 01
NERC Region |  | ECAR
State |  | PA
Fuel Type |  | Nuclear
Capacity |  | 923
Start Date |  | 2001-08-31 00:00:00
End Date |  | 2001-10-10 00:00:00
Prv. Start Date |  | 2001-08-31 00:00:00
Prv. End Date |  | 2001-10-07 00:00:00
Comments |  | Refuel
SIC |  | 4911
Plant ID |  | 1017303
Unit ID |  | 1004148
Outage ID |  | 11712
Spreadsheet: fe93c696-32e5-48a7-a7ca-a30630ef0654
Sheet: Sheet1

Online
Sales
Day | Flavorings | Condiments | Confections
Sun | 854.26 | 968.75 | 976.22
Mon | 1253.24 | 1256.55 | 725.39
Tue | 885.12 | 1345.74 | 972.83
Wed | 1128.64 | 935.04 | 1196.73
Thu | 946.28 | 768.54 | 1283.09
Fri | 874.21 | 889.67 | 909.65
Sat | 989.98 | 920.98 | 1176.87
Recorded on:
2014-08-03 00:00:00
Reviewed on:
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 6464 | 6163 |  |  | 1156 | 1178 | 2086 | 1619
2 | 6245 | 6163 |  |  | 1038 | 1178 | 2024 | 1619
3 | 6272 | 6163 |  |  | 1004 | 1178 | 1965 | 1619
4 | 6068 | 6163 |  |  | 1008 | 1178 | 2150 | 1619
5 | 5980 | 6163 |  |  | 571 | 1178 | 1663 | 1619
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  |  |  |  |  |  |  | 346806
2001-06-05 00:00:00
Spreadsheet: 798195d1664363139-find-last-occurrence-of-value-across-two-columns-and-return-adjacent-value-sample-hd
Sheet: Sheet1

Date | Home Team | Away Team | Home Team Score Pre | Away Team Score Pre | Winning Team | Home Team | Home Team Score Post | Away Team | Away Team Score Post | HD | HD
 | SS | BH | 1st | 1st | SS |  | 105 |  | 110 |  |  | <-- no previous values of team so input value of '1st'
2021-02-01 00:00:00 | MS | ST | 1st | 1st | ST |  | 112 |  | 101 |  |  | <-- no previous values of team so input value of '1st'
2021-03-01 00:00:00 | AS | MR | 1st | 1st | AS |  | 95 |  | 112 |  |  | <-- no previous values of team so input value of '1st'
2021-04-01 00:00:00 | PS | HH | 1st | 1st | HH |  | 131 |  | 117 |  |  | <-- no previous values of team so input value of '1st'
2021-05-01 00:00:00 | BH | MS |  |  | MS |  | 117 |  | 121 |  |  | <--- team BH last occurrence in cell C2 so return value from J2 in D6 | <--- team MS last occurrence in cell B3 so return value from H3 in E6
2021-06-01 00:00:00 | HH | SS |  |  | HH |  | 145 |  | 101
2021-07-01 00:00:00 | MR | PS |  |  | MT | MR | 110 | PS | 45
2021-08-01 00:00:00 | ST | AS |  |  | ST | ST | 142 | AS | 69
2021-09-01 00:00:00 | SS | MS |  |  | MS | SS | 132 | MS | 108
2021-10-01 00:00:00 | AS | HH |  |  | AS | AS | 147 | HH | 117
2021-11-01 00:00:00 | PS | BH |  |  | PS | PS | 101 | BH | 154
2021-12-01 00:00:00 | ST | MR |  |  | MR | ST | 96 | MR | 164
2022-01-01 00:00:00 | SS | ST | 1st | 1st | SS | SS | 105 | ST | 110 |  |  | <--- year changes in this row
2022-02-01 00:00:00 | PS | AS | 1st | 1st | AS | PS | 99 | AS | 108
2022-03-01 00:00:00 | HH | MS | 1st | 1st | HH | HH | 114 | MS | 121
2022-04-01 00:00:00 | AS | SS |  |  | SS | AS | 110 | SS | 120
Spreadsheet: 189440d1351190037-need-to-know-where-to-begin-in-creating-a-nutritional-spreadsheet-ingredients_example
Sheet: calculator

ingredient | amount | fat | protein | carbs | energy
dog meat (100 grams) | 5 | 150 | 200 | 250 | 4000
grass (150 pieces) | 2 | 10 | 20 | 14 | 200
sugar (100 grams) | 0.5 | 0 | 0 | 50 | 350
 |  | 160 | 220 | 314 | 4550
Spreadsheet: daren_farmer__6512__HPL-Jan
Sheet: JAN 00

 |  |  | Reliant Energy - Entex
 |  |  | Enron Capital &  Trade/Houston Pipe Line
 |  |  | MONTHLY NOMINATION SUMMARY
 |  |  | From |  |  | Month to Date
Gas Flow Day |  | [NAME]. | 2000-01-01 00:00:00 |  | 1999-09-18 00:00:00
Houston Pipe Line
982000 |  | HPL  Points | 175000
981258 | Industrial Tier 1 & 2 | CHAMPIONS | 0
981195 | Industrial Tier 1 & 2 | Huntsman East | 4000
981279, 981280, 981293 | Lufkin/Diboll- Temple Inland
980073 | Huntv,Woodls,[NAME]
Total HPL
Midcon
Total  Midcon |  |  | 20000
PAYBACK |  |  | 0
Total Available
Allocated as Follows:
Residential
012-41991-301 | 91% Domestic | HPL 76 | 910
016-41991-301 | Transactions 2-5,7 | ECT Trans # 1
016-41991-313 | existing | NGMS 308 | 10000
016-41991-306 | Trans 6- Silsbee |  | 250
016-41991-301 | Trans 10 [NAME]. | Lufkin Diboll | 0
 | Subtotal
016-41991-301 | Transaction 1 - Overflow | ECT Trans # 1
Total Residential
Industrial
012-41991-301 | 9% Industrial | HPL 76 | 90
016-41991-311 |  | CNG | 250
016-41991-306 | Trans 6 -Tier 1 - Entex | Tier 1 | 21000
016-91000-303 | Trans 6 -Tier 1 - Unit | Tier 1
016-41991-306 | Trans 6 -Tier 2 - Entex | [NAME] | 7500
016-91000-303 | Trans 6 - Tier 2  - Unit | [NAME] | 2000
016-41991-306 | VA Hospital | VA Hosp | 500
Total Industrial at meter 2000
016-91000-301 | existing | NSS/Vidor | 4000
016-41991-306 | [NAME]. | Lufkin Diboll | 8000
016-41991-312 | [NAME]. | Temple Inland | 2800
Total Industrial not at meter 2000
Total Industrial
Huntsville/Woodlands/Conroe
016-41991-301 | Trans 6 -Huntsville |  | 3000
016-41991-301 | Trans 9 -Woodlands |  | 12500
016-41991-301 | Trans 8 - Conroe |  | 3000
Total H/W/C
Transportation
012-41991-204 |  | IT | 10000
012-41991-203 |  | Firm Trsp
Total Transportation
Total Allocated
Check Available = Allocated
Transport Receipts |  | [NAME]
012-41991-204 | PG&E THOMPSONVILLE | 6296 | 10000
012-41991-203 | TEJAS THOMPSONVILLE | 6351 | 5000
012-41991-203 | TEJAS THOMPSONVILLE | 6351 | 10000
Spreadsheet: darrell_schoolcraft__7786__imbalsumm0107
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -22211 | -17333 |  | -4000
2 | -25985 | -18363 |  | -6075
3 | -55902 | -35058 |  | -19575
4 | -46173 |  |  | -45075
5 | -34325 |  |  | -45075
6 | -13615 | -4000 |  | -9075
7 | -55972 | -40448 | -61162 | -74075
8 | -58458 | -40448 | -57018 | -74075
9 | -55552 | -36966 | -56667 | -72894
10 | -46442 |  | -6239 | -52075
11 | -62328 |  |  | -61075
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-06-30 00:00:00 |  |  |  | 69314
 | 2001-07-11 00:00:00
Spreadsheet: 103550d1301322149-summing-rows-where-the-data-is-offset-sample1
Sheet: Sheet1

AccountID | March 2010 | April 2010 | May 2010 | June 2010 | July 2010 | August 2010
ABC123 | 32 | 12 | 55 | 66 | 87 | 44
AccountID | May 2010 | June 2010 | July 2010 | August 2010
ABC456 | 43 | 112 | 32 | 66
AccountID | January 2010 | February 2010 | March 2010 | April 2010 | May 2010
DEF543 | 44 | 23 | 87 | 99 | 32
Total | January 2010 | February 2010 | March 2010 | April 2010 | May 2010 | June 2010 | July 2010 | August 2010
Spreadsheet: 62435d1263389475-formula-excel-forms
Sheet: sheet1

 | How I can calculate this using two different columns. One for dollars and one for cents?
Date | Description |  |  |  |  |  | A |  |  |  |  | B |  |  |  | OTHERS
 |  |  |  |  |  | CT | IN |  | OUT |  |  | IN |  | OUT |  | IN |  | OUT
 |  |  |  |  |  |  | 125 | 30
 |  |  |  |  |  |  | 175 | 55
 |  |  |  |  |  |  | 56 | 32
 |  |  |  |  |  |  | 89 | 92
TOTAL
 |  |  |  |  |  | $ | 446 | 99
Spreadsheet: 103044d1300893560-excel-2007-data-validation-du
Sheet: Sheet1

 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | M=
 | M=
 | M=
 | M=
 | V=
 | V=
 | V=
 | V=
Spreadsheet: 775142d1648836375-simplifying-a-vlookup-or-suggest-a-better-formula-sample-data
Sheet: SUMMARY

 |  | [NAME] | DATA2 | DATA3 | DATA4 | DATA5 | DATA6 | DATA7 | DATA8 | DATA9 | DATA10
 | TYPE 1
 | TYPE 2
 | TYPE 3
 | Name | [NAME] | DATA2 | DATA3 | DATA4 | DATA5 | DATA6 | DATA7 | DATA8 | DATA9 | DATA10
 | TYPE 1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | TYPE 2 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | TYPE 3 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
Spreadsheet: 10f6c516-3f01-471e-a626-df4157d0186d
Sheet: Table 7.1

Monthly Statistical Bulletin
7.1 Population
Quarter | 2008–09 | 2009–10 | 2010–11 | 2011–12 | 2012–13
Estimated resident population (a) – '000
September | 21366 | 21788.1 | 22104.4 | 22432 | 22826
December | 21475.6 | 21865.6 | 22172.5 | 22520.3 | 22920.5
March | 21601.7 | 21964.1 | 22268.8 | 22637.1 | 23035.2
June | 21691.7 | 22031.8 | 22340 | 22723.9 | 23130.9
Annual change – '000
September | 441.9 | 422 | 316.3 | 327.6 | 394
December | 459.5 | 390 | 306.8 | 347.8 | 400.2
March | 452.7 | 362.4 | 304.7 | 368.4 | 398.1
June | 442.5 | 340.1 | 308.3 | 383.9 | 407
Annual change – per cent
September | 1.85 | 1.74 | 1.21 | 1.24 | 1.76
December | 1.93 | 1.58 | 1.16 | 1.36 | 1.78
March | 1.89 | 1.44 | 1.14 | 1.65 | 1.76
June | 1.84 | 1.32 | 1.17 | 1.72 | 1.79
(a) At the end of the quarter.
Source: ABS, Australian demographic statistics, Cat. no. 3101.0 | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3101.0&viewtitle=Australian%20Demographic%20Statistics~Sep%202007~Latest~19/03/2008&&tabname=Past%20Future%20Issues&prodno=3101.0&issue=Sep%202007&num=&view=&
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-03-27 00:00:00
Spreadsheet: 869274d1715874504-sumproduct-for-tiered-pricing-structure-threshold_test
Sheet: Bag price Luggage Logistics

From | 1 | per 1000 units |  | Threshold | diff
1 | 83000 | 26.58 |  |  |  |  |  | 83000
 | 166000 | 20.63 |  |  |  |  |  | 83000
 | 250000 | 16.83
 | 500000 | 12.15
 | 1000000 | 8.4
 | 2000000 | 5.16 |  |  |  |  | Total
 | 999999999 | 3.8
Input units |  | 200000
Output price | my formula |  | "=SUMPRODUCT(--(C11>$E$2:$E$8),(C11-($E$2:$E$8)), $[NAME]
 | BrianSheen formula |  | "=SUM(SUMPRODUCT(($C$11>=$B$2:$B$8)*C2:C8*(B2:B8-B1:B7)),SUMPRODUCT(($C$11>=B1:B7)*($C$11<B2:B8)*($C$11-(B1:B7))*C2:C8))/1000
Whatif units | manual output | BrianSheen formula output
100000 | 2556.82342 | 2556.82342 | ok !
200000 | 3918.43 | 4490.62342 | nok !
300000
600000
900000
1100000