tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mark_haedicke__24659__SUMMARY
Sheet: summary

MARINER ENERGY, INC.
APPENDIX
WEEKLY DRILLING AND COMPLETION SUMMARY
 |  |  |  |  |  |  |  |  |  |  |  |  | PRESENT |  | PROPOSED
 |  |  | PROSPECT |  | AREA |  | WELL |  | E/D |  | [NAME] |  | DEPTH |  | TD |  | COMMENT
 | I. |  | WELLS CURRENTLY DRILLING
 |  |  | East Breaks 558 |  | Deepwater |  | OCS-G 17266 #1 |  | E |  | 0.33 |  | 13,341' |  | 13,657' |  | TA'd well.
 |  |  | (LaSalle)
 |  |  | Garden Banks 240 |  | Deepwater |  | OCS-G 10342 #4 |  | D |  | 0.33 |  | 9,446' |  | 10,200' |  | Completing.
 |  |  | (Mustique)
 |  |  | [NAME] |  | Onshore, Tx |  | B-1 ST #2 |  | E |  | 0.4 |  | 9,421' |  | 10,720' |  | Completing.
 |  |  | Mississippi Canyon 305 |  | Deepwater |  | OCS-G #3 |  | D |  | 0.25 |  | 9,700' |  | 13,300' |  | Drilling.
 |  |  | (Aconcagua)
 |  |  | East Breaks 579 |  | Deepwater |  | OCS-G 19026 #1 |  | E |  | 0.5 |  | 5,929' |  | 9,060' |  | Drilling.
 |  |  | (Falcon)
 | II. |  | WELLS REACHING TOTAL DEPTH, TESTING, OR TURNED TO SALES THIS WEEK
 |  |  | None to report.
 | III. |  | WELLS ANTICIPATED TO SPUD WITHIN 90 DAYS
 |  |  | Mississippi Canyon 323 |  | Deepwater |  | OCS-G 19936 #1 |  | E |  | 0.4 |  |  |  |  |  | Spud 2nd Quarter 2001.
 |  |  | ([NAME])
 |  |  | Mississippi Canyon 561 |  | Deepwater |  | OCS-G #1 |  | E |  | 0.167 |  |  |  |  |  | Spud 2nd Quarter 2001.
 |  |  | (Hells Canyon)
 |  |  | Green Canyon 516 |  | Deepwater |  | OCS-G # 1 |  | E |  | 0.5 |  |  |  |  |  | Spud 2nd Quarter 2001.
 |  |  | (Yosemite)
 |  |  | Green Canyon 472 |  | Deepwater |  | OCS-G #2 |  | D |  | 0.5 |  |  |  |  |  | Spud 2nd Quarter 2001.
 |  |  | (King Kong)
 | IV. |  | OTHER
 |  |  | None to report.
Spreadsheet: 166320d1341540968-excel-formula-to-calculate-all-costs-within-a-particular-month-for-a-particular-category-excel
Sheet: Input

Date Invoice Received | Month | Invoice Details | Category | Date Paid | GST Y/N | Expenditure              (inc GST) | Expenditure                    (ex GST) |  | Categories
2012-03-15 00:00:00 |  | [NAME] | WEB | 2012-04-01 00:00:00 | Y | 5200 |  |  | POSTAGE
2012-06-20 00:00:00 |  | [NAME] | ADVERTISING | 2012-07-01 00:00:00 | N | 5200 |  |  | NEWSLETTER
 |  |  |  |  |  |  |  |  | ADVERTISING
 |  |  |  |  |  |  |  |  | WEB
Spreadsheet: 112475d1308596802-text-to-columns-help-suppliers
Sheet: Sheet1

SUPPLIERID | country_name | News Letter Subscriptions
 | Spain
Supplier 1 | France | Telecommunications
Supplier 2 | Australia | Business
Supplier 3 | Denmark | Consumer
Supplier 4 | Austria | Business, Energy
Supplier 5 | Singapore | Business
Supplier 6 | Australia | Telecommunications
Supplier 7 | Germany | Manufacturing, Telecommunications
Supplier 8 | United States | Pharmaceuticals
Supplier 9 | British Virgin Islands | Business, Company Reports, Consumer, Country Reports, Energy, Government, Manufacturing, Pharmaceuticals, Telecommunications
Supplier 10 | United States | Business, Consumer, Manufacturing, Telecommunications
Spreadsheet: louise_kitchen__24091__NEWCO HEADCOUNT NAMES
Sheet: Credit

Credit |  | ok
Gil | Mercy | [NAME] | 1
Rance | [NAME] | Analyst
Gonzales | Veronica | Analyst | 2
[NAME] | Rod | Director | 1
Sacks | [NAME] | Manager
[NAME] | [NAME] | Manager
[NAME] | [NAME] | Manager
Radous | [NAME] | Manager
Suttle | [NAME] | Manager | 5
Reasoner | [NAME] | Sr Analyst
Sononstine | [NAME] | Sr Analyst
Conwell | [NAME] | Sr Analyst | 3
Brackett | Debbie | Sr Director
Rohauer | Tanya | Sr Director | 2
Bradford | [NAME] | Vice President | 1
 |  | TOTAL
Spreadsheet: darrell_schoolcraft__7819__imbalsumm0109
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 6447 | 6386 |  |  | 983 | 1674 | 1840 | 1258
2 | 6381 | 6386 |  |  | 971 | 1305 | 1770 | 1258
3 | 6244 | 6374 |  |  | 1013 | 1612 | 2100 | 1258
4 | 6471 | 6386 |  |  | 827 | 1674 | 2290 | 1258
5 | 6275 | 6386 |  |  | 967 | 1674 | 2209 | 1258
6 | 4296 | 6386 |  |  | 964 | 1674 | 2158 | 1258
7 | 6323 | 6386 |  |  | 965 | 1674 | 2108 | 1258
8 | 6044 | 6386 |  |  | 952 | 1674 | 2096 | 1258
9 | 5784 | 6386 |  |  | 1054 | 1674 | 2065 | 1258
10 | 5604 | 6386 |  |  | 906 | 1674 | 2040 | 1258
11 | 5727 | 6386 |  |  | 911 | 1674 | 2015 | 1258
12 | 5764 | 6360 |  |  | 946 | 1674 | 1997 | 1258
13 | 5587 | 6386 |  |  | 911 | 1674 | 1970 | 1258
14 | 5518 | 6386 |  |  | 878 | 1674 | 1951 | 1258
15 | 5916 | 6386 |  |  | 1066 | 874 | 1940 | 1658
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  |  |  |  |  |  |  | 343565.75
2001-09-15 00:00:00
CBS Volume
 |  |  | 135836
Spreadsheet: 473075d1470036872-vlookup-based-on-a-criteria-account-client-wise
Sheet: Sunil

NO. | IMEI | STATUS | CLIENT | PRICE | PAID BY | AMOUNT | PAID DATE | REMARKS
1 | 355409070322593 |  |  |  | Moneygram | 560
2 | 352069066537068
3 | 358363067170423
4 | 354442060877152
5 | 352030074483786
6 | 353270072104419
7 | 354450067605476
8 | 352025078219129
9 | 358370066492294
10 | 353320076541247
11 | 359254064387590
12 | 355418076663512
13 | 356980065237623
14 | 352020070476868
15 | 352067063704285
16 | 355424073063672
17 | 358762058792659 |  |  |  | - | - | -
18 | 353317071192497
19 | 352061068915517
20 | 355432075070769
21 | 353335070712867
22 | 353314073133827
23 | 358369066913002
24 | 356953061971735
25 | 353318079419841
26 | 352032075033131
27 | 358353064316921
28 | 353336070334827
29 | 352023072409390
30 | 358367068551713
31 | 354449066079691
32 | 352092070849055
33 | 353264071704386
34 | 354445062502645
35 | 354383065672182
36 | 356960065010782
37 | 353270072719331
38 | 354435068766831
39 | 359310069874832
40 | 354435068766831
41 | 359310069874832
42 | 353310070204884
43 | 354451065567445
44 | 353265079511459
45 | 358361068540412
46 | 354381069063572
47 | 359226069276523
48 | 352072061212687
49 | 355432075276838
50 | 355696078242761
51 | 359256061068594
52 | 356980060227611
53 | 356952060995604
54 | 359317064517407
55 | 352075062343294
56 | 353287078205834
57 | 359228063650398
58 | 352070066064301
59 | 359244068323683
60 | 358371063529823
61 | 354381060547425
62 | 355430075637199
 | TOTAL
 | TOTAL IMEIS DONE
 | BALANCE PAYABLE AS AT
Spreadsheet: 840982d1693240200-extracting-numbers-from-a-cell-count-demo-aligw
Sheet: number extract

OFFPLAYERS | O1 | O2 | O3 | O4 | O5 | O6 | O7 | O8 | O9 | O10 | O11 | O1 | O2 | O3 | O4 | O5 | O6 | O7 | O8 | O9 | O10 | O11
TNUN 17 (RF2); TNUN 24 (KR); TNUN 89 (MB); TNUN D03 (KFB); TNUN D25 (LF2); TNUN D29 (RF1); TNUN D31 (LB); TNUN D35 (LF3); TNUN [NAME] (LF1); TNUN D44 (RB); TNUN D57 (RF3) |  | 24 | 89 | D03 | D25 | D29 | [NAME] | D35 | [NAME] | D44 | D57
TNUN 02 (HB-R); TNUN 07 (QB); TNUN 10 (SRWR); TNUN 15 (LWR); TNUN 54 (LT); TNUN 58 (RT); TNUN 63 (C); TNUN 75 (LG); TNUN 76 (RG); TNUN 80 (RWR); TNUN 87 (SLWR) |  | 07 | 10 | 15 | 54 | 58 | 63 | 75 | 76 | 80 | 87
TNUN 02 (HB-R); TNUN 07 (QB); TNUN 10 (SRWR); TNUN 15 (LWR); TNUN 54 (LT); TNUN 58 (RT); TNUN 63 (C); TNUN 75 (LG); TNUN 76 (RG); TNUN 80 (RWR); TNUN 87 (FB-L) |  | 07 | 10 | 15 | 54 | 58 | 63 | 75 | 76 | 80 | 87
TNUN 02 (HB-R); TNUN 07 (QB); TNUN 10 (SRWR); TNUN 15 (LWR); TNUN 54 (LT); TNUN 58 (RT); TNUN 63 (C); TNUN 75 (LG); TNUN 76 (RG); TNUN 80 (RWR); TNUN 87 (SLWR) |  | 07 | 10 | 15 | 54 | 58 | 63 | 75 | 76 | 80 | 87
TNUN 02 (HB-L); TNUN 07 (QB); TNUN 10 (TE-R); TNUN 15 (LWR); TNUN 54 (LT); TNUN 58 (RT); TNUN 63 (C); TNUN 75 (LG); TNUN 76 (RG); TNUN 80 (RWR); TNUN 87 (SLWR) |  | 07 | 10 | 15 | 54 | 58 | 63 | 75 | 76 | 80 | 87
TNUN 02 (HB-R); TNUN 07 (QB); TNUN 10 (SRWR); TNUN 15 (LWR); TNUN 54 (LT); TNUN 58 (RT); TNUN 63 (C); TNUN 75 (LG); TNUN 76 (RG); TNUN 80 (RWR); TNUN 87 (SLWR) |  | 07 | 10 | 15 | 54 | 58 | 63 | 75 | 76 | 80 | 87
TNUN 02 (HB-R); TNUN 07 (QB); TNUN 10 (SRWR); TNUN 15 (LWR); TNUN 54 (LT); TNUN 58 (RT); TNUN 63 (C); TNUN 75 (LG); TNUN 76 (RG); TNUN 80 (RWR); TNUN 87 (SLWR) |  | 07 | 10 | 15 | 54 | 58 | 63 | 75 | 76 | 80 | 87
TNUN 65 (PPL); TNUN 66 (PPRi); TNUN D02 (PRT); TNUN D03 (GR); TNUN D14 (PLT); TNUN D28 (GL); TNUN D31 (PRG); TNUN D38 (PLG); TNUN D99 (PPRo); TNUN S37 (P); TNUN S47 (PLS) |  | 66 | D02 | D03 | D14 | D28 | [NAME] | D38 | D99 | S37 | S47
Spreadsheet: phillip_m_love__30659__9909_OA
Sheet: CE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 45552912 | 127714985
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 21483635 | 55906485
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 67036547 | 183621470
 | Purchases:
6 |  | 3rd Party / Inter Enron | -40456462 | -113796910 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -27143223 | -72234874
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 344818 | 851977
 | Total Purchases: |  | -67254867 | -185179807
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | -43669 | 182254
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 22952 | 40763 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | -20717 | 223017
 | Storage:
17 |  | Injection (Sales to Stg) | 299343 | 842651
18 |  | W/D (Purchase from Stg) | -320000 | -900800
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -320000 | -900800
 | Total Storage: |  | -20657 | -58149
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 259694 | 666045.5120079999
23 | Fuel: |  | -344818 | -851977
 | Transport Expense:
24 |  | Commodity | 0 | -143249
25 |  | Demand | 0 | -3106344
 | Total Transport Expense: |  | 0 | -3249593
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 845380
31 |  | Prior Month Book Balance | 0 | -488419
 |  | Total MTM Income | 0 | 356961
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -347357.5294117647
34 |  | Originations | 0 | 79939
35 |  | Broker Fees | 0 | -31729
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 2475161
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 1374258
 |  | TOTAL INTRA-MTH
Spreadsheet: 167943d1342164919-i-want-to-send-data-in-multiple-workbook-projcet-05-expense-ledger
Sheet: Project-05 Company Expense

 |  |  |  |  |  |  | PROJECT # 05
 |  |  |  |  |  |  | Company-Expense |  |  |  |  |  |  |  |  | 8000 | 11000 | -3000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A/C Ref #
DATE | B# | P# | L# | [NAME]# | V# | A/C | Description | Qty | Rate | Cheq#/PS | Bank | Book# | [NAME]# | Page# | Ledger# | DEBIT | CREDIT | BALANCE
2012-04-02 00:00:00 | 408 | 30 | CL-11 | 929 |  | Labour | Labour,21-03 to 31-03-2012 | 13 | 400 |  |  |  | 1 | 74 | PS-09 |  | 5200 | -5200
2012-04-03 00:00:00 | V-01 | 74 | PS-09 |  |  | Payment | Paid Labour from 21-03 to 31-03-2012 |  |  | 59698352 | HMB-A | A-10 |  | 29 | BL-03 | 5200 |  | 0
2012-04-13 00:00:00 | 409 | 30 | CL-11 | 937 |  | Labour | Labour,1-04 to 07-04-2012 | 7 | 400 |  |  |  | 2 | 74 | PS-09 |  | 2800 | -2800
2012-04-16 00:00:00 | V-02 | 74 | PS-09 |  |  | Payment | Labour,1-04 to 07-04-2012 |  |  | 60303109 | HMB-A | A-11 |  | 31 | BL-03 | 2800 |  | 0
2012-04-14 00:00:00 | 410 | 30 | CL-11 | 938 |  | Labour | Labour,send lifting from ground to top floor | 1 | 3000 |  |  |  |  | 74 | PS-09 |  | 3000 | -3000
Spreadsheet: e82e5b43-c768-42e8-9513-be59c4fe25de
Sheet: Sheet1

50 | 5 | 10 | 20 | 1 | 1.1 | 20.1 | 5.1 | 10.1 | 1.2 | 50.1 | 1.3 | 174
50 | 10 | 20 | 5 | 10 | 5 | 1 | 50 | 1 | 1 | 20 |  | 173
20 | 10 | 5 | 1 | 50 | 1 | 50 | 10 | 5 | 20 |  |  | 172
10 | 20 | 20 | 50 | 50 | 1 | 5 | 5 | 10 |  |  |  | 171
130 | 45 | 55 | 76 | 111 | 8 | 76 | 70 | 26 | 22 | 70 | 1 | 690
Spreadsheet: 837971d1690559191-calendar-markers-in-excel-test-file-1-1-aligw
Sheet: Sheet1

Surname | Forenames | Patient Post Code | Patient Address |  | Calculated First Name | Surname | From |  | Actual First Name | Surname | From
[NAME] | fred | DY14 0HJ | [NAME] Residential Home |  |  |  |  |  | fred | [NAME] | [NAME] Residential Home
jones | alice | SY1 1NQ | Swan Hill House Residential Home, 6 [NAME], SHREWSBURY |  |  |  |  |  | alice | jones | Swan Hill House Residential Home, 6 [NAME], SHREWSBURY
[NAME] | [NAME] | SY11 2WZ | 21 [NAME], Rotherhide
[NAME] | billy | SY1 2LN | 6 Berwick Road, [NAME], Shrewsbury |  |  |  |  |  | billy | [NAME] | 6 Berwick Road, [NAME], Shrewsbury
harris | [NAME] | SY1 2PA | Ottley House Nursing Home, [NAME], SHREWSBURY |  |  |  |  |  | [NAME] | harris | Ottley House Nursing Home, [NAME], SHREWSBURY
smart | [NAME] | SY12 2EF | 17 hathers ridge, doncaster
Spreadsheet: 070f5cc3-3ebf-4850-b52e-70cfbb1d9a7f
Sheet: 4.12

Table 4.12: Public expenditure on education (as a percentage of GDP), by country and year (per cent)
Country | 2000 | 2005 | 2010 | 2011
Bahrain | … | 3.4 (2006) | 2.9 (2008) | ...
Egypt | ... | 4.79443 | 3.8 (2008) | ...
Kuwait | 6.6 (2001) | 4.73825 | ... | ...
Lebanon | 1.94449 | 2.60221 | 1.67065 | 1.64562
Morocco | 5.76051 | 5.6 (2004) | 5.4 (2009) | …
Oman | 3.14218 | 3.53734 | 4.3 (2009) | ...
Qatar | … | 2.1 (2004) | 2.5 (2008) | …
Saudi Arabia | 5.94348 | 5.7 | 5.6 (2008) | ...
Syrian Arab Republic | 4.4 (2001) | 5.4 (2004) | 5.1 (2009) | …
Tunisia | 6.2 | 6.45157 | 6.20874 | ...
United Arab Emirates | 1.3 | 1.1 (2004) | … | ...
Yemen | 9.7 | ... | 5.2 (2008) | ...
Source: UIS 2013
Spreadsheet: 202659d1356675678-sumif-with-thresholds-attached-workbook-threshold-issue_2
Sheet: Sheet1

Threshold 1 | 100 | 200 | Corresponding value 1 | 24 |  | Random value input | 150 |  | <-Should be 24
Threshold 2 | 201 | 300 | Corresponding value 2 | 31 |  | Random value input | 202 |  | <-Should be 31
Threshold 3 | 301 | 400 | Corresponding value 3 | 43 |  | Random value input | 305 |  | <-Should be 43
 |  |  |  |  |  |  | 102 |  | <-Should be 24
 |  |  |  |  |  |  | 200 |  | <-Should be 24
 |  |  |  |  |  |  | 266 |  | <-Should be 31
Spreadsheet: 783011d1654521968-merge-file-merage-file
Sheet: Sheet 3

 | from sheet 1 col.D | from sheet 1 col.E | from sheet 2 col.B | from sheet 2 col.C | from sheet 2 col.F
SUBID | [NAME] | [NAME] | AGE_AT_CALL_DATE | GENDER | _[NAME] | _[NAME]Date
114785
120142
12308
124866
125045
125332
130656
133251
135657
135942
136699
137304
138751
138852
139502
139530
13955
140026
140190
140191
140309
140370
140845
141790
141943
142780
142909
144759
145158
145193
146625
146892
1478
148159
148976
151722
152469
153124
154185
154238
156551
158841
159625
160118
160841
161589
161889
162383
162490
162556
163667
164497
164733
165146
165500
165612
165701
166302
167571
169258
170808
172149
172229
173497
174211
174279
174379
174500
176147
176195
177272
177276
17988
182939
183641
183716
186261
186283
186759
187083
187268
189964
193797
194238
194575
194637
195475
195732
195906
196975
197427
197635
197657
197875
197907
199715
200223
200256
200886
200935
201172
201498
201507
236957
237162
238518
239193
239437
239652
240906
242067
243013
243188
244161
244290
245404
246760
246971
247623
247929
248666
248684
249401
249584
249930
249941
251279
251828
252237
252547
252885
253169
254172
254698
254775
256510
256571
258153
259724
260363
260534
261181
261742
262452
262495
262942
265696
266133
266342
266801
26709
267415
268923
270452
271245
271270
271345
271747
272358
273279
273396
274584
275300
275788
276086
276689
277158
279080
279122
279291
279563
279710
279765
280198
280274
280300
280328
280455
280958
281033
281221
281313
281403
281969
282428
282479
282571
Spreadsheet: 802954d1667174131-formula-to-match-mutiple-items-and-detect-exception-book1
Sheet: Data

Store Number | Items | Revenue | Cost
22113 | A - Rev | -5 | 0
22113 | A - Cos |  | 3
22113 | B - Rev | -7 | 0
22113 | B - Cos |  | 6
22055 | A - Rev | -4 | 0
22055 | A - Cos |  | 2
22055 | B - Rev | -8 | 0
Spreadsheet: 148036d1333112219-excel-2007-if-function-for-revenue-bc-drafting
Sheet: Funded Pipeline 

QCF Pipelline |  |  |  |  |  |  | Sign Ups Pipeline
 |  |  |  |  |  |  | Sign Ups Booked
 |  |  |  |  |  |  | Sign Ups Completed
 |  |  |  |  |  |  | Revenue Pipeline
 |  |  |  |  |  |  | Revenue Generated
Sign up Date | Company Name | Centre | Telesales Rep | Sign Ups Pipeline | Sign Ups  Booked | Sign Ups Completed | Course | Revenue Pipeline | Revenue Generated
2012-08-31 00:00:00 |  | Middlesbrough
Spreadsheet: 703774d1605170905-to-show-result-the-total-count-on-specific-character-formula-2
Sheet: Dashboard

 |  | Low | Moderate | High | Extreme
 | Team A | 3 | 1 | 1 | 0
 | Team B | 1 | 2 | 1 | 1
 | Team C | 1 | 1 | 1 | 2
 |  |  |  | On all this tab (C4 - F6, I want to insert formula and capture from the tabs (TEAM A, B and C
Spreadsheet: eric_saibi__9758__012102R
Sheet: Rock Creek 02

Owner Name |  | Pacific Gas and Electric Company
Station Name |  | Rock Creek Hydro Power House
Unit Name |  | Hydro 02
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Hydro
Capacity |  | 62 MW
Start Date |  | 2001-10-23 00:00:00
End Date |  | 2002-01-20 00:00:00
Prv. Start Date |  | 2001-10-23 00:00:00
Prv. End Date |  | 2002-01-28 00:00:00
Comments |  | [NAME]
SIC |  | 4911
Plant ID |  | 1056456
Unit ID |  | 1020033
Outage ID |  | 18706
Spreadsheet: 83366d1283354879-data-validation-warning-alert-test-validation
Sheet: Sheet1

Employee grade | A |  |  |  |  |  | A
 | Total |  |  |  |  |  | B
kpi 1 | 20 |  |  |  |  |  | C
kpi 2 | 20
kpi 3 | 20
kpi 4 | 20
kpi 5 | 20 |  | All of these are actually taking up the same space on the table. So there is only 1 table and people choose there employee grade and enter there scores
Total | 100
Employee grade | A
 | Total
kpi 1 | 20
kpi 2 | 20
kpi 3 | 20
kpi 4 | 20
kpi 5 | 10
Total | 90 | This doesn’t equal 100 so need to flag up as an error!!
Employee grade | B | Now this is B
 | Total
kpi 1 | 20
kpi 2 | 20
kpi 3 | 20
kpi 4 | 20
kpi 5 | 0
Total | 80 | This is fine as 80
Employee grade | B
 | Total
kpi 1 | 10
kpi 2 | 20
kpi 3 | 20
kpi 4 | 20
kpi 5 | 0
Total | 70 | This doesn’t equal 80 so needs to flag up as an error
Employee grade | C
 | Total
kpi 1 | 10
kpi 2 | 20
kpi 3 | 20
kpi 4 | 20
kpi 5 | 0
Total | 70 | This doesn't equal 70 so error
Spreadsheet: 74117d1274717988-excel-2007-need-a-formula-to-search-specific-worksheet-sample
Sheet: 5

SKU # | [NAME] | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE |  | Total
12456 | Chicken | 3 | 2010-05-14 00:00:00 | 6 | 2010-05-15 00:00:00
Spreadsheet: 124964d1318773799-excel-2007-if-statement-and-sumif-main
Sheet: Cost

Type | Error | Supply | Inventory
PC | Harddrive | 50 | 30
MAC | Harddrive | 60 | 65
PC | Monitor | 44 | 30
MAC | Monitor | 20 | 25
PC | Keyboard | 10 | 15
PC | Touchpad | 5 | 2
PC | Sound | 8 | 1
Spreadsheet: 819918d1677766549-count-range-with-dates-not-working-aet-2-copy
Sheet: SUMMARY

 | SUMMARY
 | Week Commencing: Monday |  | <> | "<>" Means all
 | Dayes in the week (date above) |  | <>
 | Any date range | From | 2023-02-28 00:00:00 | To | 2023-02-28 00:00:00
 | Name | TOTAL ID COUNT | Date AET to do dropped
 | ACTON |  | COUNTIFS('RAW DATA'!$E$2:$E$141,"<>",'RAW DATA'!$C$2:$C$141,SUMMARY!B9,'RAW DATA'!$B$2:$B$141,SUMMARY!$D$4,'RAW DATA'!$E$2:$E$141,SUMMARY!$D$5,IF(OR($D$6="All",$F$6="All"),C9,COUNTIFS(Query1[Date AET to do dropped],"<="&SUMMARY!$D$6,Query1[Date AET to do dropped],"<="&SUMMARY!$F$6))
 | EALING
 | FULHAM
 | HARLESDEN
 | HARROW
 | HAYES
 | HOUNSLOW
 | KINGSTON
 | SHEPHERDSBUSH
 | TWICKENHAM
 | UXBRIDGE
 | WANDSWORTH
 | WEMBLEY
 | TOTAL
Spreadsheet: 120283d1315164656-rearranging-data-from-multiple-rows-to-columns-zota-example
Sheet: final

Member | RAS No | Registration number | Chassis number | Pax capacity | Permit / OL number
BIYELA, PN | RASGPA33760M79645 | JRF894GP | R023002 | 15 | [NAME]
BUTHELEZI, MJ | RASGPA33760M79663 | CXT196GP | JTFSX22PX06033330 | 15 | LGPGP0137889/1
 |  | WSF848GP | AHT41YH6309088188 | 14 | Unlinked
DLADLA, Z | RASGPA33760M79688 | DPV705GP | MR205657 | 15 | LGPGP0115437/1
Spreadsheet: 834158d1687494159-need-help-to-find-out-code-wise-rate-calculation-code-wise-rate-calculation-individual-2
Sheet: COM

Example | Code | From Date | To Date | Days | Connected Load | Load | Rate/Month | Calculation method used for reference | Remarks
1 | COM | 2022-01-11 00:00:00 |  |  |  | 10 |  | (50*G2*E2)/30 | here 50 is the rate for the load upto 10, 30 is the days of one month as per sheet COMR
2 | COM | 2022-09-22 00:00:00 |  | 65 |  | 40 |  | ((10*50*E3)+(85*E3*(G3-10)))/30 | here 10 is load, 50 is rate for upto 10 load, 85 is rate for load greater than 10 as per sheet COMR, first 10 load is Subtracted
3 | COM | 2023-03-20 00:00:00 |  | 59 |  | 75 |  | ((10*50*E4)+(85*E4*(G4-10)))/30 | here 10 is load, 50 is rate for upto 10 load, 85 is rate for load greater than 10 as per sheet COMR, first 10 load is Subtracted
Spreadsheet: 126718d1319832879-running-average-productivity-2011adam
Sheet: Jul

July Valet Totals
PIPER |  |  |  |  | MAIN |  |  |  |  | TOTAL
Average Wait Time |  |  |  |  | Average Wait Time |  |  |  |  | Average Wait Time
Average Storage Length |  |  |  |  | Average Storage Length |  |  |  |  | Average Storage Length
 | Total Parked/            Returned | Average/hour | Scheduled Productive Hours |  |  | Total Parked/            Returned | Average/hour | Scheduled Productive Hours |  |  | Total Parked/            Returned | Average/hour | Scheduled Productive Hours
5:00am-5:59am | 114 | 5.4 | 1 |  | 5:00am-5:59am | 0 | 0 | 0 |  | 5:00am-5:59am | 114 | 2.7 | 1
6:00am-6:59am | 169 | 8 | 2 |  | 6:00am-6:59am | 0 | 0 | 0 |  | 6:00am-6:59am | 169 | 4 | 2
7:00am-7:59am | 328 | 15.6 | 3.5 |  | 7:00am-7:59am | 77 | 3.7 | 2 |  | 7:00am-7:59am | 405 | 9.65 | 5.5
8:00am-8:59am | 587 | 28 | 5 |  | 8:00am-8:59am | 169 | 8 | 2 |  | 8:00am-8:59am | 756 | 18 | 7
9:00am-9:59am | 768 | 37.4 | 5.5 |  | 9:00am-9:59am | 240 | 11.4 | 2 |  | 9:00am-9:59am | 1008 | 24.4 | 7.5
10:00am-10:59am | 895 | 42.6 | 5 |  | 10:00am-10:59am | 380 | 18.1 | 3 |  | 10:00am-10:59am | 1275 | 30.35 | 8
11:00am-11:59am | 754 | 35.9 | 5 |  | 11:00am-11:59am | 350 | 16.7 | 3 |  | 11:00am-11:59am | 1104 | 26.3 | 8
12:00pm-12:59pm | 745 | 35.5 | 5 |  | 12:00pm-12:59pm | 334 | 15.9 | 2 |  | 12:00pm-12:59pm | 1079 | 25.7 | 7
1:00pm-1:59pm | 794 | 37.8 | 5 |  | 1:00pm-1:59pm | 344 | 16.4 | 2 |  | 1:00pm-1:59pm | 1138 | 27.1 | 7
2:00pm-2:59pm | 702 | 33.4 | 4.5 |  | 2:00pm-2:59pm | 388 | 18.5 | 3 |  | 2:00pm-2:59pm | 1090 | 25.95 | 7.5
3:00pm-3:59pm | 580 | 27.6 | 3.5 |  | 3:00pm-3:59pm | 280 | 13.3 | 3 |  | 3:00pm-3:59pm | 860 | 20.45 | 6.5
4:00pm-4:49pm | 376 | 17.9 | 1.5 |  | 4:00pm-4:49pm | 201 | 9.6 | 2 |  | 4:00pm-4:49pm | 577 | 13.75 | 3.5
5:00pm-5:59pm | 234 | 11.1 | 1 |  | 5:00pm-5:59pm | 105 | 5 | 2 |  | 5:00pm-5:59pm | 339 | 8.05 | 3
6:00pm-6:59pm | 126 | 6 | 1 |  | 6:00pm-6:59pm | 111 | 5.3 | 2 |  | 6:00pm-6:59pm | 237 | 5.65 | 3
7:00pm-8:00pm | 0 | 0 | 0 |  | 7:00pm-8:00pm | 55 | 2.6 | 2 |  | 7:00pm-8:00pm | 55 | 1.3 | 2
 | 7172 | 22.81333333333333 | 48.5 |  |  | 3034 | 9.633333333333335 | 30 |  |  | 10206 | 16.22333333333333 | 78.5
Spreadsheet: 76365d1276869932-lookups-on-repeated-entries-example-workbook-reply
Sheet: Book Request Log

Name | Book Name | Date Requested
Martin | Feel the Fear and Do It Anyway | 2010-06-10 00:00:00
[NAME] | [NAME] | 2010-06-11 00:00:00
[NAME] | [NAME] | 2010-06-06 00:00:00
[NAME] | 7 Secrets of Confidence | 2010-05-12 00:00:00
[NAME] | Feel the Fear and Do It Anyway | 2010-06-05 00:00:00
[NAME] | 7 Secrets of Confidence | 2010-06-06 00:00:00
[NAME] | 7 Secrets of Confidence | 2010-06-10 00:00:00
[NAME] | Improve Your Communication Skills | 2010-05-11 00:00:00
[NAME] | Feel the Fear and Do It Anyway | 2010-06-12 00:00:00
Cath | Design Driven Innovation | 2010-06-10 00:00:00
Ray | Design Driven Innovation | 2010-05-11 00:00:00