tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 884005d1732871265-working-with-representations-of-time-durations-2024-25-track-timing-cut-down-
Sheet: Reference

Date | Week | Athletes | Prog | Calendar Notes |  |  | Date
2024-09-20 00:00:00 | 1 | 382 | A | Abnormal - skills week
2024-09-27 00:00:00 | 2 | 317 | B | Abnormal - skills week
2024-10-04 00:00:00 | 3 | 331 | A
2024-10-11 00:00:00 | 4 | 381 | B
2024-10-18 00:00:00 | 5 | 415 | A | Weather caused early end to the night.
2024-10-25 00:00:00 | 6 | 412 | B
2024-11-01 00:00:00 | 7 | 373 | A
2024-11-08 00:00:00 | 8 | 397 | B
2024-11-15 00:00:00 | 9 | 350 | A
2024-11-22 00:00:00 | 10 | 387 | B
2024-11-29 00:00:00 | 11 |  | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B |  | EVENT
TRANSPOSE(UNIQUE(FILTER(tbl_RaceRpts[Age], (tbl_RaceRpts[Event]='CT-WkA Races'!A$2)*(tbl_RaceRpts[Date]='CT-WkA Races'!A$4)*(tbl_RaceRpts[racenumber]='CT-WkA Races'!A5)))) |  |  |  |  |  |  |  |  |  |  |  |  |  | 400m | 200m |  | 200m
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 800m | 1500m |  | 300m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 400m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 700m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 800m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1500m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3000m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100m
Spreadsheet: 289529d1389619192-need-to-structure-my-data-properly-but-out-of-ideas-growth-example
Sheet: Sheet1

Month | Year | Region | Team | Person | Sales | Commission | Revenue | Growth Rate Sales | Growth Rate Commision
12 | 1 | UK | Sales | A | 100 | 0.1
1 | 2 | UK | Sales | A |  |  |  | 0.05 | 0.2
Spreadsheet: 545167d1509331130-can-anyone-help-on-this-golf-scorecard-challenge-scorecardv2
Sheet: Course 1

School | Player | Hole | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | Out | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | Back | Total | -2 | -1 | 0 | +1 | +2
 |  | Yard | 291 | 381 | 190 | 377 | 124 | 304 | 563 | 419 | 491 |  | 364 | 337 | 595 | 347 | 419 | 193 | 460 | 180 | 368
 |  | Par | 4 | 4 | 3 | 4 | 3 | 4 | 5 | 4 | 5 |  | 4 | 4 | 5 | 4 | 4 | 3 | 5 | 3 | 4
School 1 | Arvay, [NAME] | Score | 5 | 5 | 4 | 5 | 3 | 5 | 6 | 5 | 7 |  | 4 | 5 | 6 | 4 | 5 | 4 | 6 | 3 | 6
 |  | Point | 1 | 1 |  |  |  |  |  |  |  |  | 2
School 1 | Atkins, Merne | Score | 5 | 5 | 4 | 5 | 3 | 5 | 6 | 5 | 7 |  | 4 | 5 | 6 | 4 | 5 | 4 | 6 | 3 | 6
 |  | Point | 4 |  |  |  |  |  |  |  |  |  | 4
School 1 | Bailey, Victor | Score | 5 | 5 | 4 | 5 | 3 | 5 | 6 | 5 | 7 |  | 4 | 5 | 6 | 4 | 5 | 4 | 6 | 3 | 6
 |  | Point | 6 |  |  |  |  |  |  |  |  |  | 6
School 1 | Bell, Jermaine | Score | 3 | 4 | 4 | 5 | 4 | 3 | 3 | 4 | 4 |  | 7 | 2 | 2 | 2 | 3 | 2 | 3 | 2 | 3
 |  | Point | 8 |  |  |  |  |  |  |  |  |  | 8
School 2 | Bonin, [NAME] | Score
 |  | Point | 10 |  |  |  |  |  |  |  |  |  | 10
School 2 | Bousfield, Rita | Score
 |  | Point | 12 |  |  |  |  |  |  |  |  |  | 12
School 2 | Bradley, [NAME] | Score
 |  | Point | 14 |  |  |  |  |  |  |  |  |  | 14
School 2 | Brethet, Lana | Score
 |  | Point | 16 |  |  |  |  |  |  |  |  |  | 16
School 3 | Bryant, [NAME] | Score
 |  | Point | 18 |  |  |  |  |  |  |  |  |  | 18
School 3 | Callan, [NAME] | Score
 |  | Point | 20 |  |  |  |  |  |  |  |  |  | 20
School 3 | Childs, Marion | Score
 |  | Point | 22 |  |  |  |  |  |  |  |  |  | 22
School 3 | Cortez, [NAME] | Score
 |  | Point | 24 |  |  |  |  |  |  |  |  |  | 24
School 4 | Curtis, Bradley | Score
 |  | Point | 26 |  |  |  |  |  |  |  |  |  | 26
School 4 | Dales, [NAME] | Score
 |  | Point | 28 |  |  |  |  |  |  |  |  |  | 28
School 4 | [NAME], [NAME] | Score
 |  | Point | 30 |  |  |  |  |  |  |  |  |  | 30
School 4 | Barton, Cliff | Score
 |  | Point | 32 |  |  |  |  |  |  |  |  |  | 32
Spreadsheet: 767873d1644685652-having-trouble-coming-up-with-combination-lookup-value-based-on-rank-result-2021-auto-update-test
Sheet: TOURNEY2

LAKE LORAMIE - April 18th, 2021
ANGLER | FISH CT. | WGTS. LBs | BIG BASS | PLACED
 | 5 | 11.11 | 3.87
 | 2 | 2.86 | 0
 | 1 | 2.4 | 0
 | 2 | 3.92 | 0
 | 1 | 1.18 | 0
 | 5 | 6.62 | 0
 | 0 | 0 | 0
 | 4 | 4.68 | 0
 | 1 | 1.07 | 0
 | 0 | 0 | 0
 | 5 | 7.71 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
Spreadsheet: 889972d1741061480-interest-calculation-based-on-fifo-clearing-interest-cal-based-on-fifo-clearing-sharad2025-
Sheet: Amount Cal

 |  |  |  |  |  | Posting Date
 |  |  |  |  |  | Customer
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Invoice No.
 |  |  |  |  |  | Amount (Rs.)
 |  |  |  |  |  | Due Date
Posting Date | Customer | [NAME] | Invoice No. | Amount (Rs.) | Due Date
 | A | RV | 101 | 100 | 2025-01-03 00:00:00
2025-01-02 00:00:00 | A | RV | 102 | 200 | 2025-01-04 00:00:00
2025-01-03 00:00:00 | B | RV | 201 | 150 | 2025-01-05 00:00:00
Spreadsheet: benjamin_rogers__1053__Asset Summary
Sheet: Sheet1

 | Core Portfolio - FPLE
 | Plants | Location | Pool | In-service Date | Regulatory Classification | Gross Capacity (MW) | Net Capacity (MW) | Gross Contract MW | Gross Merchant MW | Fuel | Plant Type | Partner
 | Merchant Assets
 | Maine Hydro | Maine | NEPOOL | 1902-1989 | EWG | 373 | 373 | 0 |  | Hydro | Hydro
 | Mason | Wicasset, ME | NEPOOL | 1942-1955 | EWG | 101 | 101 | 0 |  | # 6 Fuel Oil | Steam S/C
 | Wyman | Yarmouth, ME | NEPOOL | 1957-1978 | EWG | 610 | 610 | 0 |  | # 6 Fuel Oil | Steam S/C
 | Avec | Fort Fairfield, ME | NEPOOL | 1987-11-01 00:00:00 | EWG | 31 | 31 | 0 |  | [NAME] | Steam S/C
 | [NAME] | Paris, TX | ERCOT/SPP | 2000-07-01 00:00:00 | EWG | 1000 |  | 0 |  | Natural Gas | Gas C/C | Panda 1%
 | Marcus Hook 50 | Delaware, PA | PJM | 1987 | EWG - Cogen | 50 | 50 | 0 |  | Natural Gas | Gas S/C - Cogen
 | Sub-Total
 | Contract Assets
 | Doswell | Hanover, VA |  | 1992-05-01 00:00:00 | EWG | 665 | 665 |  |  | NG, # 2 LS Oil | Gas, Oil C/C
 | Wind (17) | CA, IA, TX, OR |  |  | QF - SPP, EWG, IPP | 955 | 479 |  |  | Wind | Wind | Various Partners
 | [NAME] | Barstow, CA |  | 1989-12-01 00:00:00 | QF - SPP | 80 | 40 |  |  | Solar, NG | Solar | Caithness 50%
 | [NAME] | Barstow, CA |  | 1990-11-01 00:00:00 | QF - SPP | 80 | 40 |  |  | Solar, NG | Solar | Caithness 50%
 | [NAME] | Norfolk, MA |  | 1991 | QF - Cogen | 303 | 150 |  |  | NG, # 2 LS Oil | Gas, Oil C/C | Tratebel 50%
 | Sayreville | Middlesex, NJ |  | 1991-08-01 00:00:00 | QF - Cogen | 264 | 150 |  |  | Natural Gas | Gas C/C | Tratebel 50%
 | Cherokee | [NAME], SC |  | 1998-07-01 00:00:00 | QF - Cogen | 100 | 50 | 80 |  | Natural Gas | Gas C/C | Caithness 50%
 | Sub-Total
 | Total
 | * [NAME]'s contract MW varies by year.
Spreadsheet: 163055d1340180377-problem-working-with-pictures-utd-fixtures-2012-13-b
Sheet: Sheet1

 |  | Should be [NAME] badge |  | HomePicture |  | AwayPicture
 |  |  |  | [NAME] | v | Fulham
 |  |  | Index/Match functions |  |  | Match Date:
 |  |  |  |  |  | 2012-08-25 00:00:00
Date | Home Venue | Away Team
2012-08-18 00:00:00 | Everton | [NAME] |  |  |  | List dropdown
2012-08-25 00:00:00 | [NAME] | Fulham
2012-09-01 00:00:00 | Southampton | [NAME]
2012-09-15 00:00:00 | [NAME] | Wigan Athletic
2012-09-22 00:00:00 | Liverpool | [NAME]
2012-09-29 00:00:00 | [NAME] | [NAME]
2012-10-06 00:00:00 | Newcastle United | [NAME]
2012-10-20 00:00:00 | [NAME] | Stoke City
2012-10-27 00:00:00 | Chelsea | [NAME]
2012-11-03 00:00:00 | [NAME] | Arsenal
2012-11-10 00:00:00 | [NAME] | [NAME]
2012-11-17 00:00:00 | Norwich City | [NAME]
2012-11-24 00:00:00 | [NAME] | Queens Park Rangers
2012-11-27 00:00:00 | [NAME] | West Ham United
2012-12-01 00:00:00 | Reading | [NAME]
2012-12-08 00:00:00 | Manchester City | [NAME]
2012-12-15 00:00:00 | [NAME] | Sunderland
2012-12-22 00:00:00 | Swansea City | [NAME]
2012-12-26 00:00:00 | [NAME] | Newcastle United
2012-12-29 00:00:00 | [NAME] | West Bromwich Albion
2012-01-01 00:00:00 | Wigan Athletic | [NAME]
2012-01-12 00:00:00 | [NAME] | Liverpool
2012-01-19 00:00:00 | [NAME] | [NAME]
2012-01-29 00:00:00 | [NAME] | Southampton
2012-02-02 00:00:00 | Fulham | [NAME]
2012-02-09 00:00:00 | [NAME] | Everton
2012-02-23 00:00:00 | Queens Park Rangers | [NAME]
2012-03-02 00:00:00 | [NAME] | Norwich City
2012-03-09 00:00:00 | West Ham United | [NAME]
2012-03-16 00:00:00 | [NAME] | Reading
2012-03-30 00:00:00 | Sunderland | [NAME]
2012-04-06 00:00:00 | [NAME] | Manchester City
2012-04-13 00:00:00 | Stoke City | [NAME]
2012-04-20 00:00:00 | [NAME] | [NAME]
2012-04-27 00:00:00 | Arsenal | [NAME]
2012-05-04 00:00:00 | [NAME] | Chelsea
2012-05-12 00:00:00 | [NAME] | Swansea City
2012-05-19 00:00:00 | West Bromwich Albion | [NAME]
 | Old Trafford
 | Away Venue
 | Man United
 | Arsenal
 | [NAME]
 | Chelsea
 | Everton
 | Fulham
 | Liverpool
 | Man City
 | Newcastle
 | [NAME]
 | QPR
 | Reading
 | Southampton
 | Stoke
 | Sunderland
 | Swansea
 | Tottenham
 | WBA
 | West Ham
 | [NAME]
 | PL
Spreadsheet: 152768d1335521482-sorting-across-column-labels-in-a-pivot-pivot-prob
Sheet: Sheet1

Item Number | Caption | [NAME] | Sales |  | Sum of Sales |  | [NAME]
123456 | mum | a | 830 |  | Item Number | Caption | a | b | c | Grand Total
123457 | mum | a | 300 |  | 21364 | dad |  | 977 |  | 977
123458 | mum | a | 922 |  | 123460 | mum |  | 308 |  | 308
123459 | mum | a | 1026 |  | 28378271 | dad |  | 194 |  | 194
123460 | mum | b | 308 |  | 13443 | sister |  |  | 1079 | 1079
21364 | dad | b | 977 |  | 123458 | mum | 922 |  |  | 922
28378271 | dad | b | 194 |  | 123459 | mum | 1026 |  |  | 1026
23453245 | dad | c | 1143 |  | 325 | dad |  |  | 1253 | 1253
325 | dad | c | 1253 |  | 435413 | sister |  |  | 1116 | 1116
235 | sister | c | 539 |  | 23453245 | dad |  |  | 1143 | 1143
435413 | sister | c | 1116 |  | 123456 | mum | 830 |  |  | 830
13443 | sister | c | 1079 |  | 235 | sister |  |  | 539 | 539
 |  |  |  |  | 123457 | mum | 300 |  |  | 300
 |  |  |  |  | Grand Total |  | 3078 | 1479 | 5130 | 9687
Spreadsheet: 46393d1245265022-ranking-ties-rank_score
Sheet: Sheet1

Match | a | b | c | d |  | a | b | c | d
1 | 7 | 8 | 5 | 9
2 | 13 | 8 | 23 | 9
3 | 24 | 24 | 5 | 9
4 | 45 | 24 | 5 | 9
5 | 24 | 12 | 25 | 24
Spreadsheet: 815043d1674715759-range-criteria-problem-in-the-function-countifs-sample
Sheet: constants

Expense Items | In-Year Spend | who
[NAME] |  | Tümü |  | All
Araba |  | Mehmet
Cep Telefonu Faturası |  | Nihal
Doğalgaz Faturası |  | Emir
[NAME]
Emir
[NAME]
İnternet Faturası
[NAME]
[NAME]
[NAME]
[NAME]
Okul -Yemek
Sağlık
Savrandere
Sigara
Su Faturası
[NAME]
[NAME]
Yazlık
Diğer
Tümü
Spreadsheet: 525918d1499017430-conditional-formatting-future-dates-on-cell-tobe-formatted-hr-template
Sheet: 1

 | Mandatory Training |  |  | Induction |  | Customer Complaints |  | Data Protection |  | Anti-Money Laundering |  | Bribery |  | Health & Safety
 | 1 | Director |  | Date Completed | [NAME] Due | Date Completed | [NAME] Due | Date Completed | [NAME] Due | Date Completed | [NAME] Due | Date Completed | [NAME] Due | Date Completed | [NAME] Due
Spreadsheet: 54094d1254127411-dynamic-questions-bank-700114_task_v2
Sheet: inputQ

 | 5
 |  |  |  | Can be hidden
Question | Answer | JCODE / price |  | Helper
List Price of Config | 5 |  |  | #N/A
Number of hours | 100 |  |  | #N/A
Site Survey | Yes | 30 |  | [NAME]
Dial Plan | No | b |  | J20002
Select Letter |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
Spreadsheet: 0c79b9a8-fb2f-4909-9abd-067130a9002f
Sheet: 2006

2006 Rank | NAME OF EMPLOYER | EMPLOYEES(1) | BUSINESS | 2005 Rank
1 | HARVARD UNIVERSITY | 10068 | HIGHER EDUCATION | 1
2 | MASSACHUSETTS INSTITUTE OF TECHNOLOGY | 7864 | HIGHER EDUCATION | 2
3 | CITY OF CAMBRIDGE(2) | 2819 | GOVERNMENT | 3
4 | MT. AUBURN HOSPITAL | 1813 | MEDICAL | 7
5 | CAMBRIDGE HEALTH ALLIANCE | 1567 | MEDICAL | 4
6 | FEDERAL GOVERNMENT | 1514 | GOVERNMENT | 6
7 | BIOGEN IDEC | 1434 | BIOTECHNOLOGY | 5
8 | GENZYME CORPORATION | 1370 | BIOTECHNOLOGY | 9
9 | NOVARTIS INSTITUTE FOR BIOMEDICAL RESEARCH | 1200 | BIOTECHNOLOGY | 11
10 | MILLENIUM PHARMACEUTICALS | 1175 | BIOTECHNOLOGY | 8
11 | DRAPER LABORATORY | 1061 | RESEARCH & DEVELOPMENT | 10
12 | COMMONWEALTH OF MASSACHUSETTS | 933 | GOVERNMENT | 14
13 | VERTEX PHARMACEUTICALS | 836 | BIOTECHNOLOGY | 19
14 | [NAME] CAMBRIDGE | 704 | BIOTECHNOLOGY | 12
15 | EF INTERNATIONAL | 685 | TRAVEL & EXCHANGE PROGRAMS | 13
16 | CAMP, DRESSER & MCKEE | 682 | ENGINEERING CONSULTANTS | 16
17 | WHOLE FOODS | 593 | RETAIL SUPERMARKET | 17
18 | QUEST DIAGNOSTICS | 570 | CLINICAL TESTING SERVICES | 15
19 | LESLEY COLLEGE | 551 | HIGHER EDUCATION | 18
20 | SHIRE PHARMACEUTICALS/TKT(3) | 475 | BIOTECHNOLOGY | 26
21 | YOUVILLE HOSPITAL & REHABILITATION CENTER | 463 | MEDICAL | 25
22 | MONITOR GROUP | 455 | MANAGEMENT CONSULTING | 22
23 | FORRESTER RESEARCH(3) | 444 | BUSINESS SERVICES | 28
24 | AKAMAI(3) | 417 | INTERNET NETWORK SERVICES | 29
25 | ABT ASSOCIATES | 411 | MEDICAL | 24
25 | BBN TECHNOLOGIES(3) | 411 | RESEARCH & DEVELOPMENT | NA
Spreadsheet: 39142d1237340979-want-to-get-the-last-available-value-in-a-list-of-columns-excel-forum-last-column-data
Sheet: Present tab

air plane | purchase date | Cost | FMV | FMV (Date) | Multiple | Qtr (%) | FYTD (%)
a |  |  | 300 | Q3 2008 | be able to get 1.5 from Multiple Database based on E1's Q3 2008
b |  |  | 500 | Q4 2008 | be able to return nothing sinceMultiple [NAME] has no info based on E2's Q4 2008
c |  |  | 600 | Q1 2008 | be able to get 1.9 from Multiple Database based on E1's Q1 2008
 |  |  |  |  | could you also show me how the formula is going to different for F4 if i want the excel be
 |  |  |  |  | able to return 1.2 (Q2 2008 data from Multiple database),
 |  |  |  |  | , ie return the previous quarter data or if no data in previous quarter, then try go for previous previous quarter.  Thanks.
Spreadsheet: 71289d1271960577-stopping-spreadsheet-at-a-certain-number-roadmap-template
Sheet: "What-If" Questions

 |  |  |  |  |  |  |  | What-If?: Q & A: Sam & Sally Sample
 |  |  |  |  |  |  |  | What Would Happen If…
 |  |  |  |  |  |  |  | Some questions that you may have about certain scenarios…
 | With the assumptions that we have made, does my plan work at this time?
 |  | No, the plan still needs some tweaking. Some suggestions are shown below.
 | THE "RISK-REWARD" RELATIONSHIP & HOW IT RELATES TO YOUR PLAN...
 | What is the lowest "growth phase" rate of return needed and therefore the least amount of risk
 | that I must take to still be certain that I will achieve my retirement goals?
 |  | 0.095 | is the return target that has thus far been estimated as reasonable
 |  |  | when considering your investment horizon and risk tolerance.
 |  | 0.2318768078793429 | is the lowest rate of return that will achieve your goals.
 |  | NOT RECOMMENDED: Involves more risk than you are comfortable with.
 | FOR PLANS THAT STILL NEED SOME "TWEAKING"…
 | How much total do I need to contribute monthly (in today's dollars) to achieve my retirement goal?
 |  | 5000 | is the amount that you have indicated that you are planning to contribute.
 |  | 35899.26840853559 | is the amount that you would have to contribute monthly to achieve your goals.
 | What monthly retirement income (in today's dollars) can I take and not erode my assets?
 |  | 20000 | is the after-tax monthly amount that you have indicated that you desire.
 |  | 9681.532238555988 | is the maximum after-tax monthly amount that your plan will allow.
Spreadsheet: 693492d1598990138-count-the-number-of-days-a-job-has-been-excuted-with-pivot-summary-daily-production-sheet
Sheet: 02072020

 |  |  | JO/20/179 HRS | JO/20/179 OT | JO/20/144 HRS | JO/20/144 OT | [NAME] | JO/20/180 OT | JO/20/120-B HRS | JO/20/120-B OT | [NAME] | [NAME] | JO/20/186 HRS | JO/20/186 OT | [NAME] | [NAME] | JO/20/149 HRS | JO/20/149 OT | [NAME] | [NAME] | JO/20/162 HRS | [NAME] | ADMIN WORK HRS | ADMIN WORK OT | Maintainance / Other works  HRS | Maintainance / Other works  OT
1 | 1 | MATHEW |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 3 | 3.3
2 | 2 | GEORGE
3 | 3 | SIVA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 3.3
4 | 4 | CHRISTOPHER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
5 | 5 | SAMUEL | 8 | 6
6 | 6 | BOMMANNA |  |  | 8 | 3
7 | 7 | SATIYAR |  |  |  |  |  |  |  |  | 8 | 4
8 | 8 | KUMAR RAM
9 | 9 | MARTIN
22 | 10 | [NAME] |  |  |  | 2 | 4 |  |  |  |  |  |  |  | 4
10 | 11 | FELIX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 1 | 2.3
11 | 12 | DIPAK |  | 5 | 4 |  |  |  | 4
12 | 13 | SATHYAPALAN
13 | 14 | RAJEEV |  | 5 |  |  |  |  |  |  | 8 | 4
16 | 15 | [NAME]
17 | 16 | FLORENCIO |  |  | 8
14 | 17 | VINOTH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 1 | 2.3
 | 18 | SHAM |  |  |  |  |  |  | 8
15 | 19 | RAJASEKAR |  |  |  |  |  |  |  |  |  |  | 8
19 | 20 | FRANCIS JOSEPH |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 2.5
24 | 21 | SONU  CHAUHAN |  |  |  |  |  |  | 8
25 | 22 | MALIK
18 | 23 | SIVA |  |  | 3 |  | 4 |  |  |  |  |  | 1 |  |  | 2.5
20 | 24 | SURENDRA |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 2.5
21 | 25 | RAVI |  |  |  |  |  |  | 8
23 | 26 | HEMRAJ |  |  |  |  | 8
 | 27 | AJMER SINGH
26 | 28 | RASHID
27 | 29 | BALJIT | 2 |  | 2 |  | 4
28 | 30
34 | 31
35
COMMENTS :
Prepared by: |  |  |  |  |  |  |  |  | Approved by:
Name: |  |  |  |  |  |  |  |  | Name:
Sign: |  |  |  |  |  |  |  |  | Sign:
Date: |  |  |  |  |  |  |  |  | Date:
Iss.No./Date: 02/01.06.2013
Rev.No/Rev.Date:02/23.06.2020
Spreadsheet: kim_ward__20665__griffith1
Sheet: Sheet2

Citizens Utilities Company
Griffith Power Plant
Gas Supply Proposal #1
Sample Capacity Economics:  Assuming 100% Takes
Transwestern |  |  | Case 1 | Case 2 | Case 3
SoCal Border Gas Daily Index = |  |  | 10 | 6 | 38
San Juan Gas Daily Mid-Point = |  |  | 5 | 5 | 5
Spread
[NAME] |  |  | 20 | 20 | 20
Floor |  |  | 3 | 3 | 3
Effective Spread
Price to Griffith
Quantity in Basin
Quantity at Citygate |  |  | 20000 | 20000 | 20000
Demand Charge
Base Rate |  |  | 3 | 3 | 3
TW Reservation
SJ Lateral
Mainline
Total Demand Charge
Days in Month |  |  | 31 | 31 | 31
Total Demand Charge
Commodity Charge
[NAME]
Discount |  |  | -0.1 | -0.1 | -0.1
Reservation Charge
Index
Billing Index
Pipeline Variable Costs
San Juan Lateral Commodity |  |  | 0.0011 | 0.0011 | 0.0011
Mainline Commodity |  |  | 0.0253 | 0.0253 | 0.0253
Total Commodity Charge
Total Commodity Charge
Total Commodity Charge
Total Demand and Commodity Charge
Total Demand and Commodity Charge
Price to Enron
Demand Charge
Gas Commodity |  |  | 0.07 | 0.07 | 0.07
Transwestern Services |  |  | 0.02 | 0.02 | 0.02
Profit to ENA |  |  | 0.13 | 0.13 | 0.13
Pipeline Charges
San Juan - Thoreau |  |  | 0.1031 | 0.1031 | 0.1031
Thoreau - Griffith |  |  | 0.2082 | 0.2082 | 0.2082
Total Demand Charge
Total Demand Charge
Commodity Charge
Gas Commodity
Pipeline Charges
San Juan - Thoreau |  |  | 0.0011 | 0.0011 | 0.0011
Thoreau - Griffith |  |  | 0.0253 | 0.0253 | 0.0253
Total Commodity Charge
Total Commodity Charge
Total Demand and Commodity Charge
Total Demand and Commodity Charge
Profit to Citizens
Revenue from Griffith
Cost to Enron
Profit
Profit
Spread
Cost to Enron
Profit
Spreadsheet: 848820d1699456415-ways-to-make-workbook-set-up-more-efficient-run-faster-081123-example
Sheet: Project details

Hidden tab | Hidden tab | Autofilled | Autofilled | Autofilled | Free text | Auto generated
Project number | Task number | Project name | Region | Team | Name of task | Task name
 |  |  | US | Team 1 | Task 1
1 |  | US - Team 1 - Project - Project 1 - Low - Solo | US | Team 1 | Task 2
2 |  | India - Team 3 - Project - Project 2 - Medium - Collaborative | India | Team 3 | Task 1
2 |  | India - Team 3 - Project - Project 2 - Medium - Collaborative | India | Team 3 | Task 2
2 |  | India - Team 3 - Project - Project 2 - Medium - Collaborative | India | Team 3 | Task 3
3 |  | APAC - Team 2 - Project - Project 3 - High - Collaborative | APAC | Team 2 | Task 1
3 |  | APAC - Team 2 - Project - Project 3 - High - Collaborative | APAC | Team 2 | Task 2
3 |  | APAC - Team 2 - Project - Project 3 - High - Collaborative | APAC | Team 2 | Task 3
3 |  | APAC - Team 2 - Project - Project 3 - High - Collaborative | APAC | Team 2 | Task 4
Spreadsheet: 857615d1706594304-need-formula-in-sheet2-vlook-2colume-marge-sample
Sheet: Sheet1

S.no | Card num from | Card numb to | CARD RECIVER NAME
1 | R0000100 | R0000200 | ABC
2 | R0000201 | R0000250 | DCE
3 | R0000251 | R0000500 | XXXX
4 | [NAME] | R0000625 | TEAM
Spreadsheet: phillip_platter__31373__ca0912EES
Sheet: SP15_T1_Detail

LastModified | CalendarDate | StartDate | EndDate | CounterParty | PeerID | LegID | StripID | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500 | 1600 | 1700 | 1800 | 1900 | 2000 | 2100 | 2200 | 2300 | 2400
Spreadsheet: 680613d1591111015-unable-to-calculate-columns-based-on-cell-values-using-a-sumif-formula-test_data
Sheet: DataSheet

 | [NAME] |  |  |  |  |  |  |  |  |  |  | Summary
 | Cost | MonthINV | Cost | MonthINV | Cost | MonthINV | Cost | MonthINV | Cost | MonthINV |  | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00
 | 23 | 2020-06-01 00:00:00 | 78 | 2020-07-01 00:00:00 | 12 | 2020-01-01 00:00:00 | 78 | 2020-08-01 00:00:00 | 23 | 2020-12-01 00:00:00
 | 265 | 2020-08-01 00:00:00 | 84 | 2020-08-01 00:00:00 | 13 | 2020-08-01 00:00:00 | 98 | 2020-09-01 00:00:00 | 22 | 2020-11-01 00:00:00
 | 549 | 2020-05-01 00:00:00 | 69 | 2020-09-01 00:00:00 | 15 | 2020-09-01 00:00:00 | 78 | 2020-11-01 00:00:00 | 24 | 2020-01-01 00:00:00
 | 266 | 2020-01-01 00:00:00 | 69 | 2020-01-01 00:00:00 | 16 | 2020-03-01 00:00:00 | 87 | 2020-07-01 00:00:00 | 25 | 2020-02-01 00:00:00
 | 258 | 2020-02-01 00:00:00 | 58 | 2020-08-01 00:00:00 | 15 | 2020-08-01 00:00:00 | 58 | 2020-07-01 00:00:00 | 58 | 2020-03-01 00:00:00
 | 57 | 2020-12-01 00:00:00 | 58 | 2020-09-01 00:00:00 | 145 | 2020-09-01 00:00:00 | 58 | 2020-08-01 00:00:00 | 24 | 2020-04-01 00:00:00
 | 14 | 2020-10-01 00:00:00 | 87 | 2020-01-01 00:00:00 | 148 | 2020-03-01 00:00:00 | 58 | 2020-09-01 00:00:00 | 256 | 2020-07-01 00:00:00
 | 25 | 2020-04-01 00:00:00 | 896 | 2020-08-01 00:00:00 | 169 | 2020-08-01 00:00:00 | 58 | 2020-11-01 00:00:00 | 25 | 2020-01-01 00:00:00
 | 23 | 2020-07-01 00:00:00 | 45 | 2020-09-01 00:00:00 | 269 | 2020-09-01 00:00:00 | 58 | 2020-07-01 00:00:00 | 87 | 2020-02-01 00:00:00
 | 96 | 2020-02-01 00:00:00 | 74 | 2020-01-01 00:00:00 | 248 | 2020-03-01 00:00:00 | 58 | 2020-07-01 00:00:00 | 54 | 2020-03-01 00:00:00
 | 25 | 2020-12-01 00:00:00 | 858 | 2020-08-01 00:00:00 | 265 | 2020-08-01 00:00:00 | 58 | 2020-08-01 00:00:00 | 12 | 2020-04-01 00:00:00
 | 14 | 2020-10-01 00:00:00 | 875 | 2020-09-01 00:00:00 | 239 | 2020-09-01 00:00:00 | 78 | 2020-09-01 00:00:00 | 26 | 2020-07-01 00:00:00
 | 145 | 2020-04-01 00:00:00 | 489 | 2020-01-01 00:00:00 | 93 | 2020-03-01 00:00:00 | 98 | 2020-11-01 00:00:00 | 25 | 2020-02-01 00:00:00
 | 78 | 2020-07-01 00:00:00 | 65 | 2020-08-01 00:00:00 | 12 | 2020-08-01 00:00:00 | 658 | 2020-07-01 00:00:00 | 25 | 2020-03-01 00:00:00
 | 52 | 2020-04-01 00:00:00 | 5 | 2020-09-01 00:00:00 | 10 | 2020-09-01 00:00:00 | 23 | 2020-07-01 00:00:00 | 25 | 2020-04-01 00:00:00
 | 25 | 2020-07-01 00:00:00 | 2 | 2020-01-01 00:00:00 | 11 | 2020-03-01 00:00:00 | 19 | 2020-07-01 00:00:00 | 25 | 2020-07-01 00:00:00
Spreadsheet: 713067d1610544771-nominal-data-details-test-sheet
Sheet: Sheet1

S.No | Names | Papers | Marks |  |  | A
1 | A | Bio | 59 |  |  | Names | Papers | Marks
2 | B | Statistics | 60
3 | A | Match | 59
4 | B | Statistics | 58
5 | C | Chemistry | 65
6 | A | Physics | 63
7 | C | Drawing | 87