tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1303b488-5cb2-4987-b01f-dfe4cc4b6b12
Sheet: Teams

Team | OPR | QS | QS+CP | RS | Extra Match (0 or Match Number) | Sort by me! | OPR | OPR High | OPR Norm
1403 |  |  |  |  | 0 |  |  |  |  |  | You should paste in the team numbers so that funky things don't happen when you sort.
1736 |  |  |  |  | 0 |  |  |  |  |  | I don't remember where I got the OPR High and OPR Norm from…
67 |  |  |  |  | 0
2826 |  |  |  |  | 0 |  |  |  |  |  | Search for a team by entering in their number here:
2056 |  |  |  |  | 0 |  |  |  |  |  | 1114
3997 |  |  |  |  | 0
716 |  |  |  |  | 0
359 |  |  |  |  | 0
1592 |  |  |  |  | 0
195 |  |  |  |  | 0
1218 |  |  |  |  | 0
1676 |  |  |  |  | 0
128 |  |  |  |  | 0
3947 |  |  |  |  | 0
2046 |  |  |  |  | 0
781 |  |  |  |  | 0
1311 |  |  |  |  | 0
126 |  |  |  |  | 0
2898 |  |  |  |  | 0
236 |  |  |  |  | 0
144 |  |  |  |  | 0
272 |  |  |  |  | 0
1796 |  |  |  |  | 0
2415 |  |  |  |  | 0
692 |  |  |  |  | 0
245 |  |  |  |  | 0
2603 |  |  |  |  | 0
2512 |  |  |  |  | 8
4256 |  |  |  |  | 0
2557 |  |  |  |  | 0
1756 |  |  |  |  | 0
2949 |  |  |  |  | 0
1816 |  |  |  |  | 0
4334 |  |  |  |  | 0
3008 |  |  |  |  | 0
190 |  |  |  |  | 0
2403 |  |  |  |  | 0
1504 |  |  |  |  | 0
3481 |  |  |  |  | 0
3128 |  |  |  |  | 0
1458 |  |  |  |  | 0
4001 |  |  |  |  | 0
1987 |  |  |  |  | 0
1114 |  |  |  |  | 0
1868 |  |  |  |  | 0
3015 |  |  |  |  | 9
2648 |  |  |  |  | 0
839 |  |  |  |  | 0
2590 |  |  |  |  | 0
2395 |  |  |  |  | 0
4082 |  |  |  |  | 0
246 |  |  |  |  | 0
956 |  |  |  |  | 0
3968 |  |  |  |  | 0
1647 |  |  |  |  | 0
587 |  |  |  |  | 0
3456 |  |  |  |  | 0
2851 |  |  |  |  | 0
2974 |  |  |  |  | 0
973 |  |  |  |  | 0
3476 |  |  |  |  | 0
1261 |  |  |  |  | 0
2638 |  |  |  |  | 0
247 |  |  |  |  | 0
4143 |  |  |  |  | 0
20 |  |  |  |  | 2
3999 |  |  |  |  | 0
3927 |  |  |  |  | 12
1642 |  |  |  |  | 0
234 |  |  |  |  | 3
3410 |  |  |  |  | 0
2996 |  |  |  |  | 4
1902 |  |  |  |  | 31
1014 |  |  |  |  | 0
2815 |  |  |  |  | 0
2614 |  |  |  |  | 0
3747 |  |  |  |  | 0
3081 |  |  |  |  | 0
4356 |  |  |  |  | 0
4300 |  |  |  |  | 0
1018 |  |  |  |  | 31
3158 |  |  |  |  | 0
2410 |  |  |  |  | 0
3335 |  |  |  |  | 0
1058 |  |  |  |  | 1
1306 |  |  |  |  | 0
75 |  |  |  |  | 5
4403 |  |  |  |  | 0
100 |  |  |  |  | 6
369 |  |  |  |  | 0
4218 |  |  |  |  | 0
2809 |  |  |  |  | 0
1710 |  |  |  |  | 0
1 |  |  |  |  | 7
2022 |  |  |  |  | 0
4206 |  |  |  |  | 0
3634 |  |  |  |  | 0
1875 |  |  |  |  | 11
2085 |  |  |  |  | 0
3585 |  |  |  |  | 10
Spreadsheet: kate_symes__18265__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-02 00:00:00 |  | 234.1 | 20032 | 134.92 | 8456
 | 2001-04-01 00:00:00 |  | 150 | 800 | 130 | 0 | 169.97 | 4993 | 179.55 | 3133 |  | 136.89 | 20112
 | 2001-03-31 00:00:00 |  | 155.24 | 26800 | 79.32 | 5000 | 203.27 | 4434 | 161.69 | 2164
 | 2001-03-30 00:00:00 |  | 155.24 | 26800 | 78.68 | 5600 | 166.55 | 6883 | 125.76 | 3604
 | 2001-03-29 00:00:00 |  | 149.29 | 27472 | 74.97 | 7680 | 151.01 | 3119 | 106.73 | 2737
 | 2001-03-28 00:00:00 |  | 117.91 | 28384 | 64.05 | 8795 | 135.59 | 5365 | 79.21 | 2138
 | 2001-03-27 00:00:00 |  | 107.14 | 26352 | 54.09 | 6800 | 138.05 | 5768 | 73.14 | 3889
 | 2001-03-26 00:00:00 |  | 280.53 | 20768 | 160.99 | 5520 | 115.17 | 3547 | 66.57 | 2059
 | 2001-03-25 00:00:00 |  | 200 | 0 | 135 | 200 | 80.99 | 1643 | 75.59 | 545 |  | 162.46 | 16560
 | 2001-03-24 00:00:00 |  | 233.04 | 14608 | 130.51 | 4880 | 130 | 6097 | 179.92 | 3350
 | 2001-03-23 00:00:00 |  | 233.24 | 14448 | 130.51 | 4880 | 324.97 | 6129 | 242.2 | 3200
 | 2001-03-22 00:00:00 |  | 281.29 | 18448 | 160.38 | 5360 | 385.71 | 8040 | 282.16 | 2915
 | 2001-03-21 00:00:00 |  | 460.02 | 24848 | 198.73 | 8120 | 350.98 | 4786 | 253.67 | 1853
 | 2001-03-20 00:00:00 |  | 377.03 | 18384 | 176.12 | 5120 | 390.83 | 2452 | 357.57 | 1668
 | 2001-03-19 00:00:00 |  | 297.33 | 24848 | 176.6 | 9000 | 258.33 | 3388 | 199.67 | 2448
 | 2001-03-18 00:00:00 |  | 220 | 0 | 185 | 0 | 170.47 | 4949 | 156.95 | 2582 |  | 178.66 | 28200
 | 2001-03-17 00:00:00 |  | 195.41 | 17152 | 121.88 | 8832 | 191.77 | 10872 | 180.55 | 1883
 | 2001-03-16 00:00:00 |  | 195.98 | 16352 | 121.88 | 8832 | 219.02 | 5921 | 173.76 | 3142
 | 2001-03-15 00:00:00 |  | 180.19 | 17472 | 98.04 | 5160 | 188.69 | 6005 | 136.45 | 3320
 | 2001-03-14 00:00:00 |  | 162.56 | 17184 | 81.84 | 6960 | 194.59 | 4065 | 117.41 | 1400
 | 2001-03-13 00:00:00 |  | 157.46 | 17840 | 69.39 | 7288 | 171.29 | 4137 | 134.75 | 1330
 | 2001-03-12 00:00:00 |  | 166.55 | 12544 | 91.58 | 6920 | 186.95 | 2928 | 114.77 | 1215
 | 2001-03-11 00:00:00 |  | 163 | 3200 | 90 | 1600 | 104.25 | 1435 | 110.05 | 945 |  | 93.34 | 17760
 | 2001-03-10 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 109.79 | 3007 | 124.99 | 2735
 | 2001-03-09 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 175.73 | 6415 | 122.41 | 1756
 | 2001-03-08 00:00:00 |  | 185.11 | 22848 | 92.66 | 8640 | 191.53 | 4219 | 145.14 | 1004
 | 2001-03-07 00:00:00 |  | 300.27 | 25616 | 169.6 | 6824 | 225.26 | 4337 | 151.01 | 1201
 | 2001-03-06 00:00:00 |  | 309.17 | 20320 | 175.44 | 6728 | 215.32 | 7762 | 192.69 | 3047
 | 2001-03-05 00:00:00 |  | 276.65 | 9792 | 162.76 | 4656 | 215.88 | 4042 | 160.99 | 832
 | 2001-03-04 00:00:00 |  | 240 | 800 | 165 | 0 | 168.1 | 2613 | 141.45 | 365 |  | 163.88 | 14568
 | 2001-03-03 00:00:00 |  | 239.87 | 18240 | 148.58 | 7800 | 188.15 | 5032 | 117.4 | 2417
Spreadsheet: 203541d1357158945-help-with-linking-sheets-together-trailer-2f-dock-control
Sheet: Trailer Summary 

Trailer Summary
Trailer # | Location | Door | Empty / Loaded | Client | Project # | Project | [NAME]. | Load Date | Unload Date | Notes
53901 | Evans | 7
53902 | Evans | Yard |  |  | Test | BP-CP |  | 1995-02-03 00:00:00 | 1995-02-04 00:00:00
53906 | Evans | Yard
53907 | Evans | 6
53909 | Evans | Yard
53910 | Evans | Yard
53911 | Evans | 5
 |  |  |  |  | Test 2 | AA-UU |  | 04-12-96 | 04-14-96
Spreadsheet: c5ca32ee-9ed4-4a69-a6f6-66dd04e3b187
Sheet: Table 4.4

4.4 Business investment
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013-14
Chain volume measures (a) (b) – $ million
September | 46005 | 47877 | 61396 | 67764 | 65473
December | 48040 | 49734 | 60034 | 64461 | 63142
March | 46290 | 53050 | 63992 | 64222
June | 47668 | 54654 | 65948 | 70622
Annual | 188003 | 205315 | 251370 | 267069
Annual change (b) – per cent
September | -8.433183392380872 | 4.069122921421586 | 28.23694049334753 | 10.37201120594176 | -3.380851189422107
December | -3.115861651709184 | 3.526228143213994 | 20.71017814774601 | 7.37415464570077 | -2.046198476598249
March | -4.758965495957035 | 14.60358608770793 | 20.62582469368521 | 0.3594199274909338
June | -1.943924464649371 | 14.65553411093397 | 20.66454422366157 | 7.087402195669323
Annual | -4.6 | 9.208363696323994 | 22.43138591919733 | 6.245375343119703
(a) Reference year for chain volume measures is 2011–12.
(b) Figures are seasonally adjusted.
Source: ABS, Australian National Accounts: National Income, Expenditure and Product, | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007
cat. no. 5206.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-06-04 00:00:00
Spreadsheet: cara_semperger__1448__ENA_PGE_DEC05_2001
Sheet: LOSSES

From: | EPMI
To: | PGE System Transactions
Date:
HE
ENDING | TOTAL |  | TOTAL
Pacific
Prevailing
Time | CWI SHOWS FOLLOWING VALUES | THIS IS AN OVER-RETURN
(PPT) | TAG 39375
0100 |  | 1
0200 |  | 1
0300 |  | 1
0400 |  | 1
0500 |  | 1
0600 |  | 1
0700 |  | 3
0800 |  | 3
0900 |  | 3
1000 |  | 3
1100 | 1 | 3
1200 | 3 | 3
1300 |  | 3
1400 |  | 3
1500 | 1 | 3
1600 |  | 3
1700 | 1 | 3
1800 |  | 3
1900 | 1 | 3
2000 |  | 3
2100 | 1 | 3
2200 |  | 3
2300 |  | 1
2400 |  | 1
 | PGE | PGE | PGE
 | REAL POWER LOSSES | PGE LOSSES | [NAME] [NAME]
 | PGE | PGE | PGE
 | 640902
 | 640903
 | NEW COLUMN
Spreadsheet: tracy_geaccone__40591__CF_GPG_CONS
Sheet: JulyCM 

Enron Gas Pipeline Group
Statement of Consolidated Cash Flows
For the 1 month ended July 31, 2000
 | CONSOLIDATED |  |  |  |  |  |  | HPLO | HPL | LRC | LIQUIDS | GATHER | LIQUIDS | SERVICE | GPG CASH |  |  | TOTAL
(In Thousands) | GPG & EOTT |  | GPG | NNG | TW | EC | NP | 543 | 584 | 583 | DOMESTIC |  | GROUP | COS | SERVICES | OTHER |  | EOTT
Operating Cash Inflows (Outflows)
Net income before financing costs
Financing costs
NI after financing costs (excluding cons subs equity earn)
Depreciation, depletion and amortization
Deferred income taxes
Gains on sales of assets and investments
Dividends on pref securities of subsidiary cos.
Equity earnings
Equity/partnership distributions
Other, net
Funds Flow
Changes in components of working capital
Receivables
A/R, A/P - Intercompany
Inventories
Prepayments
Payables
Exchange Rec/Payable
Accrued taxes
Accrued interest
Other working capital
Total changes in components of working capital
Net Cash Provided by Operating Activities
Investing Cash Inflows (Outflows)
Proceeds from sale of assets and investments
Capital Expenditures
Underground Storage,Salvage & Removal Costs
EOTT Revolver and API's
Other investing activities - intercompany
Other investing activities, net
Net Cash Provided by Investing Activities
Cash Flows From Financing Activities
Net increase (decrease) in short-term borrowings
Issuance of long-term debt
Repayment of long-term debt
Other financing activities - I/C
Other financing activities, net
Net Cash Provided by Financing Activities
INC (DEC) IN CASH & CASH EQUIV, I/C CASH FROM CORP
INC (DEC) IN CASH & CASH EQUIV |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
INC (DEC) INTERCOMPANY CASH FROM CORPORATE
Change in other obligations |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0
Change in total obligations
Spreadsheet: 95323d1294933484-excel-2007-adding-2-sets-of-data-to-a-single-calendar-calendar-test
Sheet: Install Pivot

Count of Temp Date
Install Date | combined | Total
2011-01-13 00:00:00 | KRAFT-HYATT RESTAURANT {Ramiro} 173.06 | 1
2011-01-14 00:00:00 | Stock-Classics Lot 18 {Ramiro} 130.25 | 1 | Stock-Classics Lot 18 {Ramiro} 130.25
2011-01-18 00:00:00 | Stock-Sarita 136 {Ramiro} 130.51 | 1 | Stock-Sarita 136 {Ramiro} 130.51
2011-01-26 00:00:00 | Stock-ALDEN WOODS 3-101 {Ramiro} 77.5 | 1 | Stock-ALDEN WOODS 3-101 {Ramiro} 77.5  Stock-ALDEN WOODS 3-102 {Ramiro} 77.5  Stock-ALDEN WOODS 3-201 {Ramiro} 85.67  Stock-ALDEN WOODS 3-202 {Ramiro} 85.67
 | Stock-ALDEN WOODS 3-102 {Ramiro} 77.5 | 1 | Stock-ALDEN WOODS 3-102 {Ramiro} 77.5
 | Stock-ALDEN WOODS 3-201 {Ramiro} 85.67 | 1 | Stock-ALDEN WOODS 3-201 {Ramiro} 85.67
 | Stock-ALDEN WOODS 3-202 {Ramiro} 85.67 | 1 | Stock-ALDEN WOODS 3-202 {Ramiro} 85.67
2011-01-28 00:00:00 | Stock-CALDECOTT 13 {0} 105.15 | 1 | Stock-CALDECOTT 13 {0} 105.15
2011-01-31 00:00:00 | Stock-MARTINIQUE 1 {0} 0 | 1 | Stock-MARTINIQUE 1 {0} 0
2012-01-06 00:00:00 | Stock-Lakoya 147 {RAMIRO} 137.3 | 1 | Stock-Lakoya 147 {RAMIRO} 137.3
Spreadsheet: 853133d1703067934-solved-validate-month-based-on-contract-dates-and-calculate-correct-number-of-weeks-on-date-issue-new
Sheet: Sheet1

Name | Start contract | End contract | Contract weeks | Hours a week |  | begin month | end month | Months |  | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
Piet | 2024-01-08 00:00:00 | 2024-04-15 00:00:00 |  | 30
Kees | 2024-01-15 00:00:00 | 2024-03-04 00:00:00 |  | 20
Jan | 2024-10-08 00:00:00 | 2024-12-31 00:00:00 |  | 25
Spreadsheet: 742252d1627625163-automatically-summing-weeks-into-months-weeks-into-months-v2
Sheet: Months

 |  |  |  | Year
 |  |  | Hours | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | Task 1 | 1 | 30
 | Task 2 | 2 | 30
Spreadsheet: 143911d1330624399-calculating-contract-values-over-a-defined-number-of-months-for-multiple-contracts-contracted-revenue
Sheet: Contracted Revenue Projections

 | NOTES:
 | First revenue value for each Customer/Service Order should first appear in the month indicate in the Service Date
 | First month revenue calculation should consist of the SUM of the NRC TOTAL and the NRC TOTAL pro-rated for the remainder of the month from the Service Date
 | Subsequent months revenue is simply the MRC total
 | The final month of each Customer/Service Order should be the number of months detailed in the term after the Service Date and should not be pro-rated.
Customer Name | Service Order # | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00
Contracted Monthly Revenue
Spreadsheet: andy_zipper__170__DYNEGY-ICE VOL Apr16
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-16-01 thru Apr-16-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
 |  |  |  | No Activity
Spreadsheet: 196503d1354027797-sumproduct-problem-combined-with-filtering-sumproductissue
Sheet: Sheet1

 | Need to Filter
 | on range and get sumproduct total here
 |  |  | Price | Units
 |  |  | 22200
 | Range 1 | Item 1 | 6 | 500
 | Range 1 | Item 2 | 59 | 100
 | Range 1 | Item 3 | 6 | 800
 | Range 1 | Item 4 | 5 | 100
 | Range 1 | Item 5 | 6 | 500
 | Range 1 | Item 6 | 5 | 1000
 | Range 2 | Item 1 | 59 | 500
 | Range 2 | Item 2 | 6 | 100
 | Range 2 | Item 3 | 6 | 800
 | Range 2 | Item 4 | 5 | 100
 | Range 2 | Item 5 | 6 | 500
 | Range 2 | Item 6 | 5 | 1000
Spreadsheet: 109219d1306156368-indirect-help-forum-2-
Sheet: Summary

March | Validation here |  | 2001-03-01 00:00:00 |  |  | 2001-02-01 00:00:00 |  |  | 2001-01-01 00:00:00
Account Number | Account Name | Country | Total Market Value | Cash  Value | % Cash | Total Market Value | Cash  Value | % Cash | Total Market Value | Cash  Value | % Cash
111 | Murphy | UK | 110 | 70 | 0.6363636363636364 | 110 | 70 | 0.6363636363636364 | 110 | 70 | 0.6363636363636364
5555 | Harold | AUS | 600 | 250 | 0.4166666666666667 | 300 | 200 | 0.6666666666666666 | 300 | 200 | 0.6666666666666666
333 | Smith | SCO | 500 | 150 | 0.3 | 500 | 150 | 0.3 | 500 | 150 | 0.3
 |  |  |  |  |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  | April
 |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  | July
 |  |  |  |  |  |  |  |  |  |  | August
 |  |  |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  | December
Spreadsheet: 705155d1605893588-vlookup-alternative-sample-sheet-missing-addresses
Sheet: Mailing list

ID | Name | Address | City | State | Zip/Postal Code
100 | [NAME]
101 | Adam
103 | Xenia
105 | [NAME]
108 | [NAME]
110 | Fred
111 | Layla
112 | Shaundra
118 | [NAME]
120 | [NAME]
Spreadsheet: e183dc5c-80a6-45cc-80d9-bdd802743072
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7529 | 30147 | [NAME] | Curr | RSA | 0 | 00:25:14 | 00:01:01 | 01:14:29 | 00:00:22 | 00:43:43 | 1 | 02:24:54
Spreadsheet: e412acd7-2842-4f19-930d-8789a62c238c
Sheet: Sheet1

United States Senator - REP (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 3/11/2014 12:59:52 PM
Precincts Reporting: 505/505 - Total Ballots Cast: 102066
2010 Primary Election - OFFICIAL RESULTS
District | [NAME] | write-in | TOTALS
District 01 | 1570 | 1 | 1571
District 02 | 1209 | 4 | 1213
District 04 | 755 | 1 | 756
District 06 | 1249 | 0 | 1249
District 07 | 2075 | 3 | 2078
District 08 | 602 | 2 | 604
District 09 | 607 | 1 | 608
District 10 | 1782 | 1 | 1783
District 11 | 710 | 2 | 712
District 13 | 1506 | 4 | 1510
District 14 | 1355 | 2 | 1357
District 15 | 1723 | 2 | 1725
District 16 | 127 | 0 | 127
District 17 | 1293 | 5 | 1298
District 18 | 513 | 2 | 515
District 19 | 1186 | 2 | 1188
District 20 | 421 | 1 | 422
District 21 | 401 | 1 | 402
District 22 | 1494 | 2 | 1496
District 23 | 252 | 0 | 252
District 24 | 1648 | 1 | 1649
District 25 | 707 | 4 | 711
District 26 | 1172 | 0 | 1172
District 27 | 723 | 2 | 725
District 28 | 1866 | 2 | 1868
District 29 | 525 | 0 | 525
District 31 | 1529 | 4 | 1533
District 33 | 2345 | 2 | 2347
District 34 | 1050 | 2 | 1052
District 36 | 2250 | 5 | 2255
District 37 | 2309 | 4 | 2313
District 39 | 2570 | 3 | 2573
District 41 | 1067 | 1 | 1068
District 42 | 436 | 0 | 436
District 43 | 680 | 1 | 681
District 44 | 1070 | 7 | 1077
Results provided by the Office of North Dakota Secretary of State | 713 | 1 | 714
District 46 | 1125 | 4 | 1129
TOTAL | 44615 | 79 | 44694
Spreadsheet: 110151d1306916898-look-up-and-find-data-example
Sheet: Sheet1

Name | Status |  |  |  |  |  | Completed | WIP | Rejected
[NAME] | Completed |  |  |  |  | [NAME] | ? | ? | ?
[NAME] | WIP |  |  |  |  | [NAME] | ? | ? | ?
George | Rejected |  |  |  |  | George | ? | ? | ?
[NAME] | WIP
George | WIP
[NAME] | Rejected
[NAME] | Completed |  |  |  |  | Count of Status | Status
[NAME] | Rejected |  |  |  |  | Name | Completed | WIP | Rejected
[NAME] | Rejected |  |  |  |  | [NAME] | 2 | 0 | 4
George | Completed |  |  |  |  | [NAME] | 1 | 2 | 0
[NAME] | Completed |  |  |  |  | George | 1 | 1 | 1
[NAME] | Rejected
Spreadsheet: 771789d1646848308-displaying-info-from-multiple-sheets-on-one-cover-sheet-example-1-
Sheet: Car Hire

Car Hire
Week Commencing | Date Booked | Job Number | Booked Through | Confirmation Number | Cost
2012-03-05 00:00:00 | 2022-02-01 00:00:00 | 8 | Europecar | N/A | 154
2012-03-05 00:00:00 | 2022-02-01 00:00:00 | 9 | Europecar | N/A | 198
2012-03-05 00:00:00 | 2022-02-01 00:00:00 | 15 | Europecar | N/A | 208
2012-03-12 00:00:00 | 2022-02-01 00:00:00 | 18 | Europecar | N/A | 15
2012-02-26 00:00:00 | 2022-02-01 00:00:00 | 45 | Europecar | N/A | 198
Spreadsheet: 482912d1475330893-mid-function-problem-mid-1original30sepwof
Sheet: Sheet1

 |  | 7.54 |  | 7.54
 |  | calculated field |  | calculated field
 |  | data feed (manually feed) |  | data feed
2016-08-01 00:00:00 | mon | 9.543 |  | 9.543
2016-08-02 00:00:00 | tue | 8.97 |  | 8.97
2016-08-03 00:00:00 | wed | 10.47 |  | 10.47
2016-08-04 00:00:00 | thu | 9.87 |  | 9.87
2016-08-05 00:00:00 | fri | 8.79 |  | 8.79
2016-08-06 00:00:00 | sat
2016-08-07 00:00:00 | [NAME]
2016-08-08 00:00:00 | mon | 7.32 |  | 7.32
2016-08-09 00:00:00 | tue | 7.85 |  | 7.85
2016-08-10 00:00:00 | wed | 8.945 |  | 8.945
2016-08-11 00:00:00 | thu | 7.89 |  | 7.89
2016-08-12 00:00:00 | fri | 7.65 |  | 7.65
2016-08-13 00:00:00 | sat
2016-08-14 00:00:00 | [NAME]
2016-08-15 00:00:00 | mon | 7.33 |  | 7.33
2016-08-16 00:00:00 | tue | 6.99 |  | 6.99
2016-08-17 00:00:00 | wed | 7.834 |  | 7.834
2016-08-18 00:00:00 | thu | 6.87 |  | 6.87
2016-08-19 00:00:00 | fri | 17.98 |  | 6.02
2016-08-20 00:00:00 | sat
2016-08-21 00:00:00 | [NAME]
2016-08-22 00:00:00 | mon | 6.02 |  | 17.98
2016-08-23 00:00:00 | tue | 8.02 |  | 8.02
2016-08-24 00:00:00 | wed | 8.04 |  | #8.02
 |  |  |  | here as due to special character added, the formula is not working AND this has further effects
2016-08-25 00:00:00 | thu | 26.89 |  | 6.89
2016-08-26 00:00:00 | fri | 6.34 |  | 6.34
 |  | mid function IS USED AS ONLY RELEVANT NUMBERS FROM A STRING HAS TO BE CONSIDERED
 |  | BUT THIS CREATED PROBLEM WHEN THE NUMBER OF NUMERALS TO BE CONSIDERED ARE NOT ENOUGH AND HAS OTHER CHARACTER/SYMBOLS ahead/BEHIND THE SIGN--if is -ve(WHICH IS NORMAL)
 |  | seen in e57,e60, e63
 |  | So has to make formula such that only numerals string(with -ve sign if is there)  that are at starting of value is considered(till 1 places after decimal, if there is decimal)----
 |  | after "#" delimiter till the next "#" delimiter.
 |  | Last two days average is ALSO calculated seperately in the data feed field before weekly average as this is needed as input in formauls that are used in weekly average, so done this to avoic [NAME] issue
Spreadsheet: 680468d1591037579-linking-cells-to-a-summary-new-mileage-auto-form-forum-copy
Sheet: 11.4.20

Form: Rep08.doc
Revision : 02/01/2018
SALES PERSONNAL - WEEKLY MILEAGE REPORT
Sales Persons Name: [NAME]
Vehicle Model & Registration:
Check List: | Oil | ü | Water | ü | Tyres | ü | Bodywork | ü
Week commencing date: |  |  |  |  | Opening mileage
Day | Date | Business miles |  | Private miles |  | # [NAME] purchased |  | Fuel costs £
Sat
Sun
Mon
Tue
Wed
Thu |  |  |  | 5
Fri
 |  | Total Business miles |  | Total Private miles |  | Total # [NAME] purchased |  | Total Fuel costs £
Check | Closing Mileage |  |  | 99643 |  | Expenses |  | 0
 | Amount to be deducted for PRIVATE use / mileage |  |  |  |  | Fuel - PM + Expences
Signed off  &  confirmed by : |  |  |  |  |  |  | Dated:
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward
 | Measured | Scheduled | Measured | Scheduled
1 |  |  |  | -41120 |  | -40965
2 |  |  |  | -72493 |  | -70588
3 |  |  |  | -47409 |  | -46538
4 |  |  |  | -47409 |  | -44942
5 |  |  |  | -42474 |  | -45635
6 |  |  |  | -22024 |  | -24144
7 |  |  |  | -22030 |  | -22851
8 |  |  |  | -22030 |  | -23255
9 |  |  |  | -27030 |  | -27020
10 |  |  |  | -56575 |  | -56544
11 |  |  |  | -57030 |  | -55455
12 |  |  |  | -57030 |  | -57780
13 |  |  |  | -42348 |  | -40035
14 |  |  |  | -26824 |  | -10052 | -21355
15 |  |  |  | -22485 |  | -18221
16 |  |  |  | -42255 |  | -32655 | -6012
17 |  |  |  | -17398 |  |  | -17955
18 |  |  |  | -17398 |  | -18100
19 |  |  |  | 7602 |  | -2702
20 |  |  |  | -27029 |  | -4008 | -16114
21 |  |  |  | -35554 |  | -5173 | -28317
22 |  |  |  | -36021 |  | -35595 | -1006
23 |  |  |  | -11021 |  | -11032
24 |  |  |  | -11021 |  | -13271
25 |  |  |  | -15210 |  | -2754 | -6517
26 |  |  |  | -21021 |  | -2524 | -20030
27 |  |  |  | -12397 |  | 0 | -13730
28
29
30
31
index
2001-10-31 00:00:00 |  |  |  |  | 389644.14
2001-11-30 00:00:00
CBS Volume
 |  |  | -7465