tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 100666d1298969713-sumifs-on-multiple-work-sheets-seatigerorderworksheet-1-
Sheet: Master

Style | Description | Color | Size | Total Units | Balance
1873 | W BAILEY | BLK | 5 | 20
1873 | W BAILEY | BLK | 6 | 6
1873 | W BAILEY | BLK | 7 | 10
Spreadsheet: 539609d1506288470-return-month-value-example-4
Sheet: Sheet1

Example: | Data base up until Aug-17 |  |  | Data base up until Sep-17 |  |  | Data base up until Oct-17
 | Month | Result Month # |  | Month | Result Month # |  | Month | Result Month #
 | [NAME] | 14 |  | [NAME] | 15 |  | [NAME]
 | Aug-16 | 13 |  | Aug-16 | 14 |  | Aug-16
 | Sep-16 | 12 |  | Sep-16 | 13 |  | Sep-16
 | [NAME] | 11 |  | [NAME] | 12 |  | [NAME]
 | Nov-16 | 10 |  | Nov-16 | 11 |  | Nov-16
 | Dec-16 | 9 |  | Dec-16 | 10 |  | Dec-16
 | Jan-17 | 8 |  | Jan-17 | 9 |  | Jan-17
 | Feb-17 | 7 |  | Feb-17 | 8 |  | Feb-17
 | Mar-17 | 6 |  | Mar-17 | 7 |  | Mar-17
 | Apr-17 | 5 |  | Apr-17 | 6 |  | Apr-17
 | May-17 | 4 |  | May-17 | 5 |  | May-17
 | Jun-17 | 3 |  | Jun-17 | 4 |  | Jun-17
 | Jul-17 | 2 |  | Jul-17 | 3 |  | Jul-17
 | Aug-17 | 1 |  | Aug-17 | 2 |  | Aug-17
 |  |  |  | Sep-17 | 1 |  | Sep-17
 |  |  |  |  |  |  | Oct-17 | 1
 | What I want to accomplish is:
 | I want my months to have a number, being "1" the month I have most recent information, in this case Aug-17
 | However, once I have Sep information, I want the number of the month to restate itself into "1" and so on, so I don't have to do it manually.
 | Thanks
 | D2S
Spreadsheet: 783755d1655124992-formula-linked-to-a-table-excel-forum-ans
Sheet: Sheet1

Reference | Code | Description
C | 8520010 | Cash | C
T | 8520020 | Transfer | CA
S | 8520030 | Speedpoint
CA | 9990000 | Cancelled
Spreadsheet: gstorey__12048__NOV00
Sheet: Table 3a

Natural gas Exports by Export Point |  |  |  |  |  |  |  |  |  |  |  |  | Table 3a
Exportations de gaz naturel par point d'exportation
1000 m3
 | 2000/11 | 2000/12 | 2001/01 | 2001/02 | 2001/03 | 2001/04 | 2001/05 | 2001/06 | 2001/07 | 2001/08 | 2001/09 | 2001/10 | TOTAL
ADEN | 28034.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 28034.1
CHIPPAWA | 92209.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 92209.4
CORNWALL | 22700.08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22700.08
EAST HEREFORD | 61326.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 61326.6
ELMORE (ALLIANCE) | 522825.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 522825.5
EMERSON | 1070188.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1070188.3
HIGHWATER | 105914.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 105914.8
HUNTINGDON | 808702.99 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 808702.99
IROQUOIS | 988176.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 988176.9
KINGSGATE | 1965324.62 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1965324.62
MONCHY | 1793119.86 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1793119.86
NAPIERVILLE | 47938.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 47938.2
[NAME] | 1311431.608633 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1311431.608633
NORTH PORTAL | 839.99 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 839.99
PHILIPSBURG | 20992.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20992.5
[NAME] FIELD | 305.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 305.4
SPRAGUE | 15643.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15643.1
ST CLAIR | 22976.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22976.9
ST STEPHEN (M&NE) | 330884.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 330884.9
TOTAL | 9209535.748633001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9209535.7
Spreadsheet: 731129d1620206390-find-column-title-in-a-range-and-return-the-title-of-that-column-excel-forum-example
Sheet: Sheet2

 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Anoop | [NAME] | Eleanor | Emily | Katrina | Bilal | Anna | Ravi | [NAME] | Ashraf | Ahmed | Pranav | Martin | Ray
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Week 8
Week 9
Week 10
Week 11
Week 12
Week 13
Week 14
Week 15
Week 16
Spreadsheet: kate_symes__18540__Cob
Sheet: DJ COB 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-01-30 00:00:00 |  | 475 | 3600 | 330 | 200
 | 2001-01-29 00:00:00 |  | 409.94 | 6640 | 387.5 | 0 | 508.72 | 2665 | 432.7 | 925
 | 2001-01-28 00:00:00 |  |  |  |  |  |  |  | 573.46 | 3080 |  | 350 | 600
 | 2001-01-27 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 575 | 1900 | 453.79 | 896
 | 2001-01-26 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 484.63 | 1750 | 475.17 | 757
 | 2001-01-25 00:00:00 |  | 319.3 | 5760 | 300 | 400 | 408.1 | 3642 | 485.29 | 850
 | 2001-01-24 00:00:00 |  | 314.3 | 4560 | 260 | 0 | 466.67 | 1350 | 450 | 600
 | 2001-01-23 00:00:00 |  | 352.69 | 5200 | 237.5 | 400 | 465.24 | 1025 | 237.5 | 0
 | 2001-01-22 00:00:00 |  | 477.5 | 1600 | 325 | 200 | 404.09 | 5165 | 361.14 | 2480
 | 2001-01-21 00:00:00 |  |  |  |  |  |  |  | 475.58 | 3225 |  | 312.5 | 1200
 | 2001-01-20 00:00:00 |  | 600 | 400 | 325 | 0 | 428.07 | 2240 | 404.59 | 1115
 | 2001-01-19 00:00:00 |  | 600 | 400 | 362.5 | 0 | 417.35 | 3625 | 425 | 250
 | 2001-01-18 00:00:00 |  | 479.29 | 5600 | 233.33 | 600 | 475 | 0 | 185 | 225
 | 2001-01-17 00:00:00 |  | 264.55 | 5840 | 196.25 | 800 | 210 | 135 | 250 | 0
 | 2001-01-16 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 450 | 300 | 170 | 235
 | 2001-01-15 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 183.5 | 0 | 165 | 0
 | 2001-01-14 00:00:00 |  |  |  |  |  |  |  | 129.41 | 170 |  | 152.43 | 8400
 | 2001-01-13 00:00:00 |  | 168.69 | 5200 | 154.24 | 3680 | 115 | 33 | 140 | 20
 | 2001-01-12 00:00:00 |  | 176.68 | 10000 | 152.98 | 2080 | 209.62 | 720 | 134.57 | 350
 | 2001-01-11 00:00:00 |  | 176.75 | 9600 | 152.5 | 1680 | 181.82 | 275 | 185 | 50
 | 2001-01-10 00:00:00 |  | 168.05 | 8800 | 150 | 800 | 172.22 | 1360 | 166.03 | 696
 | 2001-01-09 00:00:00 |  | 165.55 | 8000 | 149.11 | 1080 | 175 | 75 | 150 | 65
 | 2001-01-08 00:00:00 |  | 154.06 | 12320 | 139.02 | 2440 | 170.92 | 1100 | 124.59 | 1220
 | 2001-01-07 00:00:00 |  |  |  |  |  |  |  | 120.71 | 2304 |  | 139.02 | 7320
 | 2001-01-06 00:00:00 |  | 146 | 9600 | 142.53 | 3000 | 119.57 | 1585 | 110.85 | 1970
 | 2001-01-05 00:00:00 |  | 146.36 | 10000 | 142.53 | 3000 | 168.87 | 1857 | 148.05 | 1001
 | 2001-01-04 00:00:00 |  | 154.8 | 8000 | 154.29 | 1400 | 172.79 | 3571 | 156.13 | 1435
 | 2001-01-03 00:00:00 |  | 180.29 | 4160 | 172.5 | 800 | 160.85 | 4323 | 147.25 | 922
 | 2001-01-02 00:00:00 |  | 185 | 800 | 176.58 | 584 | 149.75 | 2900 | 144.12 | 170
 | 2001-01-01 00:00:00 |  |  |  |  |  |  |  | 138.83 | 1790 |  | 175.74 | 2112
 | 2000-12-31 00:00:00 |  |  |  |  |  |  |  | 147.02 | 3015 |  | 150 | 600
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 752557d1634826642-conditional-rank-using-dynamic-array-function-conditional-rank
Sheet: Sheet7

Batch | Control recipe | Step Text | Rank | Rank with dynamic array function with spill range
14384960 | 395235 | Printing reference sample labels
14384960 | 395235 | Printing box labels
14384960 | 395236 | Batch size
14384960 | 395239 | Number approved
14384960 | 395239 | Totals
14506462 | 398600 | Printing box labels
14506462 | 398600 | Printing reference sample labels
14506462 | 398641 | Sampling reference samples start
14506462 | 398641 | Batch size and outlet
14506462 | 398641 | Number of extra samples taken
14506462 | 398644 | Scrap
14506462 | 398644 | Number approved
14506462 | 398644 | Totals
14506462 | 398644 | Within requirements
14523616 | 399167 | Printing box labels
14523616 | 399167 | Printing reference sample labels
14523616 | 399168 | Sampling reference samples start
14523616 | 399168 | Number of extra samples taken
14523616 | 399171 | Scrap
14523616 | 399171 | Number approved
14523616 | 399171 | Totals
14523616 | 399171 | Within requirements
14384960 | 395335 | Printing reference sample labels
14384960 | 395335 | Printing box labels
14384960 | 395336 | Batch size
14384960 | 395339 | Number approved
14384960 | 395339 | Totals
14506462 | 398700 | Printing box labels
14506462 | 398700 | Printing reference sample labels
14506462 | 398741 | Sampling reference samples start
14506462 | 398741 | Batch size and outlet
14506462 | 398741 | Number of extra samples taken
14506462 | 398744 | Scrap
14506462 | 398744 | Number approved
14506462 | 398744 | Totals
14506462 | 398744 | Within requirements
14523616 | 399267 | Printing box labels
14523616 | 399267 | Printing reference sample labels
14523616 | 399268 | Sampling reference samples start
14523616 | 399268 | Number of extra samples taken
14523616 | 399271 | Scrap
14523616 | 399271 | Number approved
14523616 | 399271 | Totals
14523616 | 399271 | Within requirements
14384960 | 395435 | Printing reference sample labels
14384960 | 395435 | Printing box labels
14384960 | 395436 | Batch size
14384960 | 395439 | Number approved
14384960 | 395439 | Totals
14506462 | 398800 | Printing box labels
14506462 | 398800 | Printing reference sample labels
14506462 | 398841 | Sampling reference samples start
14506462 | 398841 | Batch size and outlet
14506462 | 398841 | Number of extra samples taken
14506462 | 398844 | Scrap
14506462 | 398844 | Number approved
14506462 | 398844 | Totals
14506462 | 398844 | Within requirements
14523616 | 399367 | Printing box labels
14523616 | 399367 | Printing reference sample labels
14523616 | 399368 | Sampling reference samples start
14523616 | 399368 | Number of extra samples taken
14523616 | 399371 | Scrap
14523616 | 399371 | Number approved
14523616 | 399371 | Totals
14523616 | 399371 | Within requirements
Spreadsheet: 109724d1306501121-excel-2007-specific-date-compared-to-date-range-fed-calc-v3
Sheet: Entry Screen

Case Number
Non Custodial Parent |  |  |  |  |  | Worker Name
CP/Caretaker |  |  |  |  |  | Worker Address 1
CP/CT Address 1 |  |  |  |  |  | Worker Address 2
CP/CT Address 2 |  |  |  |  |  | Worker Address 3
CP/CT City, State, Zip |  |  |  |  |  | Worker City, State, Zip
Reconciliation Date |  | 2011-04-28 00:00:00 |  |  |  | Date Prepared |  | 2011-04-27 00:00:00
ORDER 1 |  |  | Order | Order | Order | Order | Reason |  | Annual
 | State |  | Number | Date | Eff Date | End Date | Ended |  | Interest*
 | DE |  | caca123 | 1996-08-15 00:00:00 | 1996-08-01 00:00:00
 |  |  | Order |  | Payment |  | Adjudicated |  | Monthly
 |  |  | Amount |  | Frequency |  | Arrears |  | Amount
 |  |  | 50
ORDER 2 |  |  | Order | Order | Order | Order | Reason |  | Annual
 | State |  | Number | Date | Eff Date | End Date | Ended |  | Interest*
 |  |  | idid456 | 2000-04-05 00:00:00 | 2000-04-16 00:00:00
 |  |  | Order |  | Payment |  | Adjudicated |  | Monthly
 |  |  | Amount |  | Frequency |  | Arrears |  | Amount
 |  |  | 100
ORDER 3 |  |  | Order | Order | Order | Order | Reason |  | Annual
 | State |  | Number | Date | Eff Date | End Date | Ended |  | Interest*
 |  |  | Order |  | Payment |  | Adjudicated |  | Monthly
 |  |  | Amount |  | Frequency |  | Arrears |  | Amount
ORDER 4 |  |  | Order | Order | Order | Order | Reason |  | Annual
 | State |  | Number | Date | Eff Date | End Date | Ended |  | Interest*
 |  |  | Payment |  | Payment |  | Adjudicated |  | Monthly
 |  |  | Amount |  | Frequency |  | Arrears |  | Amount
ORDER 5 |  |  | Order | Order | Order | Order | Reason |  | Annual
 | State |  | Number | Date | Eff Date | End Date | Ended |  | Interest*
 |  |  | Order |  | Payment |  | Adjudicated |  | Monthly
 |  |  | Amount |  | Frequency |  | Arrears |  | Amount
 | *NOTE: Rates shown are the rates currently in effect in each state. If different rates were in effect in prior years, these can be changed manually. To change a rate for a particular year, go to the Annual page for that year and overwrite the interest rate value shown for the order.
Spreadsheet: 129342d1321550693-unique-values-on-multiple-sheets-uniquesystemname
Sheet: Old Contract #2

Standalone | Unique System Names
 | EDR |  | Should be 0 because of duplicate from OC1
 | ENG |  | Should be 1 because of duplicate from OC1
Product | Type | System Name
EDR_Product20 | EDR | sys8888
ENG_Product3 | ENG | sys4444
ENG_Product4 | ENG | sys4444
ENG_Product5 | ENG | sys4445
Spreadsheet: 216795d1361891318-array-column-designation-index-match-example2
Sheet: Sheet1

°F | SA-479 S31803 | SA-479 304 | SA-479 316 | SA-479 304H | SA-479 316H | SA-479 347 H
100 | 25700 | 20000 | 20000 | 20000 | 20000 | 20000 |  |  | °F | 550
200 | 25700 | 20000 | 20000 | 20000 | 20000 | 20000 |  |  | Material | SA-479 304
300 | 24800 | 18900 | 20000 | 18900 | 20000 | 18800 |  |  | Result
400 | 23900 | 18300 | 19300 | 18300 | 19300 | 17800
500 | 23300 | 17500 | 18000 | 17500 | 18000 | 17100
600 | 23100 | 16600 | 17000 | 16600 | 17000 | 16900
650 | 16200 | 16600 | 16200 | 16600 | 16800
700 | 15800 | 16300 | 15800 | 16300 | 16800
Spreadsheet: lisa_gang__22241__ENA_PGE_MARCH_28_29_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date:
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  | Total In To PGE Trans
0100 |  | 0 | 0
0200 | 0 | 0 | 0
0300 | 0 | 0 | 0
0400 | 0 | 0 | 0
0500 | 0 | 0 | 0
0600 | 0 | 0 | 0
0700 | 0 | 0 | 0
0800 | 0 | 0 | 0
0900 | 0 | 0 | 0
1000 | 0 | 0 | 0
1100 | 0 | 0 | 0
1200 | 0 | 0 | 0
1300 | 0 | 0 | 0
1400 | 0 | 0 | 0
1500 | 0 | 0 | 0
1600 | 0 | 0 | 0
1700 | 0 | 0 | 0
1800 | 0 | 0 | 0
1900 | 0 | 0 | 0
2000 | 0 | 0 | 0
2100 | 0 | 0 | 0
2200 | 0 | 0 | 0
2300 | 0 | 0 | 0
2400 | 0 | 0 | 0
 | [NAME]) | [NAME]) | BPAP(G)
 | AVISTA(PSE) | AVISTA(PSE) | AVISTA(PSE)
 | BPA(PSE) | EPMI(PSE) | EPMI(PSE)
 | GAC(PSE) | SNPD(PSE) | SNPD(PSE)
 | BPA(T)MIDC/JD | BPA(T)MIDC/JD | BPA(T)BPAT/JD
 | GAC(PSE) | SNPD(PSE) | SNPD(PSE)
 | BPA(PSE) | EPMI(PSE) | EPMI(PSE)
 | AVISTA(PSE) | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | CISO(T)MAL5/NP15 | CISO(T)MAL5/NP15
 | EPMI(PSE) | EPMI(L, FS) CISO (CA) | EPMI(L, FS) CISO (CA)
 | AVISTA(PSE)
 | [NAME])
 | CISO(T)MAL5/NP15
 | CERS(L,FS) CISO (CA)
Spreadsheet: 720169d1614048485-index-and-match-not-returning-the-correct-value-index-match-example
Sheet: Report Filter

CODE | [NAME] | Report
999999 | INTERSTATE INTERLATA NON-CALL | NO
999999 | INTRASTATE INTERLATA NON-CALL | NO
999999 | INTRASTATE INTRALATA NON-CALL | NO
999999 | INTERSTATE INTRALATA NON-CALL | NO
999999 | [NAME] | NO
BUS101 | B Line 10% 1 Yr | YES
BUS152 | B Line 15% 2 Yr | YES
BUS203 | B Line 20% 3 Yr | YES
BUS203 | Prorate Del Bus Line 20 | NO
POFFICI | Bus Line - Official | YES
PRESM | PROD Res | YES
PRESM | Prorate Add PROD Res | NO
Spreadsheet: 263148d1378389033-reoccurring-name-in-2-columns-and-skipping-blanks-max-name
Sheet: Sheet2

martin | [NAME]
fred | pete
[NAME] | [NAME]
pete | [NAME]
george | [NAME]
[NAME] | [NAME]
[NAME] | pete
martin | [NAME]
fred | [NAME]
fred | pete
pete | fred
george | [NAME]
[NAME] | [NAME]
[NAME] | martin
martin | [NAME]
fred | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
george | martin
[NAME] | martin
[NAME] | [NAME]
martin | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
pete | pete
george | fred
[NAME] | [NAME]
[NAME] | [NAME]
martin | [NAME]
martin | [NAME]
Spreadsheet: 166528d1341608547-creating-individualised-schedules-from-class-lists-match-find-excel-help-modified-by-tigeravatar-
Sheet: Sheet1

Monday 1:00 - 2:30 |  |  |  |  |  |  | Monday 2:45 - 4:15
Hula hooping |  | Skipping Rope |  | juggling |  |  | lion taming |  | trapeze |  | unicycle
aaa | 1 | eee | 1 | iii |  | 1 | aaa | 1 | [NAME] | 1 | ggg
bbb | 2 | [NAME] | 2 | jjj |  | 2 | jjj | 2 | bbb | 2 | [NAME]
[NAME] | 3 | ggg | 3 | llll |  | 3 | ddd | 3 | iii | 3 | eee
ddd | 4 | hhh | 4 | mmm |  | 4 | llll | 4 | hhh | 4 | mmm
Spreadsheet: darrell_schoolcraft__7307__imball0201
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1
2
3
4
5
6
7
8
9
10
11 |  |  |  | 200
12
13
14
15
16
17 |  |  |  | 3000
18 |  |  |  | 3000
19 |  |  |  | 3000
20 |  |  |  | 3000
21 |  |  |  | 3000
22 |  |  |  | 3000
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  | 34262
2002-01-22 00:00:00
CBS Volume
 |  |  | 748
Spreadsheet: 586589d1534450789-copy-data-from-one-excel-sheet-to-another-if-a-value-is-present-only-from-drop-down-list-sample-of-billing-matrix
Sheet: ESPN

DATE | COMPANY | TOTAL COUNT | 1 COUNT | 1 AMOUNT | 2 COUNT | 2 AMOUNT | 3 COUNT | 3 AMOUNT | 4 COUNT | 4 AMOUNT | 5 COUNT | 5 AMOUNT | 6 COUNT | 6 AMOUNT | TOTAL AMOUNT
2018-08-01 00:00:00 | 4 - ESPN | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 540 | 0 | 0 | 540
2018-08-02 00:00:00 | 4 - ESPN | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 1200 | 0 | 0 | 1200
2018-08-03 00:00:00 | 4 - ESPN | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 900 | 0 | 0 | 900
Spreadsheet: 328048d1403777001-control-sheet-formula-needed-mtd-revenue-1-31-may-2014
Sheet: OpenX by publisher

Inventory : Site Summary
NOTE: This Report Includes Real Time Data.
Report Inputs:
Start Date: |  | 2014-05-01
End Date: |  | 2014-05-31
Sites Selected: |  | None Selected (default to all applicable values).
Ad Unit Sizes Selected: |  | None Selected (default to all applicable values).
Report Data:
Site Name | Site ID | Currency | Ad Requests | Billable Impressions Delivered | Revenue | eCPM | Fill Rate (%) | Clicks | CTR
minecraft.gamepedia.com | 118530 | GBP | 8453677 | 1452913 | 168.63873 | 0.116069 | 17.186757 | 184 | 0.012664
computerandvideogames.com | 118541 | GBP | 37513 | 7209 | 3.333016 | 0.46234 | 19.217337 | 1 | 0.013871
muzu.tv | 118936 | GBP | 1 | 0 | 0 | 0 | 0 | 0 | 0
coulloffers.com | 118398 | GBP | 238 | 5 | 0.000149 | 0.0298 | 2.10084 | 0 | 0
Coull - Marios - Test | 118815 | GBP | 369 | 70 | 0.003562 | 0.050885 | 18.970189 | 0 | 0
memebase.cheezburger.com | 118511 | GBP | 8501283 | 1128899 | 143.410003 | 0.127035 | 13.27916 | 186 | 0.016476
techradar.com | 118542 | GBP | 2509753 | 634363 | 473.867931 | 0.746998 | 25.275913 | 54 | 0.008512
lolpro.com | 118531 | GBP | 401552 | 100587 | 12.246958 | 0.121754 | 25.049557 | 3 | 0.002982
forums.sidewalkmag.com | 119529 | GBP | 37105 | 548 | 0.051685 | 0.094315 | 1.476889 | 0 | 0
roflrazzi.cheezburger.com | 118509 | GBP | 1814602 | 174104 | 19.824532 | 0.113866 | 9.59461 | 26 | 0.014933
minecraftforum.net | 118535 | GBP | 53179170 | 7502234 | 930.951136 | 0.124089 | 14.107467 | 210 | 0.002799
icanhas.cheezburger.com | 118510 | GBP | 5468928 | 1134981 | 132.193976 | 0.116472 | 20.753262 | 623 | 0.05489
thedailywhat.cheezburger.com | 118512 | GBP | 3156260 | 396527 | 44.127736 | 0.111285 | 12.563191 | 106 | 0.026732
t3.com | 118353 | GBP | 48892 | 13334 | 10.135292 | 0.760108 | 27.272355 | 3 | 0.022498
bikeradar.com | 118324 | GBP | 64197 | 17335 | 9.515725 | 0.548931 | 27.002819 | 2 | 0.011537
mmo-champion.com | 118536 | GBP | 15731859 | 4016283 | 662.893106 | 0.165051 | 25.529614 | 95 | 0.002365
mmorpg.com | 118543 | GBP | 862332 | 299864 | 44.905156 | 0.149751 | 34.773613 | 34 | 0.011338
reignofgaming.net | 118537 | GBP | 1469748 | 371276 | 47.613206 | 0.128242 | 25.261201 | 37 | 0.009965
geek.cheezburger.com | 118513 | GBP | 9273746 | 861162 | 107.442949 | 0.124765 | 9.28602 | 170 | 0.01974
marriland.com | 118534 | GBP | 756148 | 223571 | 27.315601 | 0.122178 | 29.567095 | 46 | 0.020575
failblog.cheezburger.com | 118409 | GBP | 385792 | 89848 | 10.998058 | 0.122407 | 23.289233 | 17 | 0.01892
 |  | GBP | 112153165 | 18425113 | 2849.468507 | 0.154651 | 16.428527 | 1797 | 0.009753
Report ID: 245a0de8-fc8f-419c-98da-51195819573f generated on 2014-06-02 10:06:20 UTC,    Last True-Up Hour: 2014-06-02 07:00:00 UTC,    DataLastUpdated: 2014-06-02 10:00:00
Spreadsheet: 298367d1392770828-create-scroll-bar-to-scroll-through-year-of-dates-book1-ndm
Sheet: Sheet1

 | Start Date | 2013-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 | BROKEN EXAMPLE
 |  |  |  |  |  |  |  |  |  | 0
 | Start Date | 2014-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 1 | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
Spreadsheet: 292427d1390590865-sorting-results-from-subjective-testing-book1
Sheet: Sheet1

Orig. Set | Contents | Ran. Code | x | Ran. Set |  | Q1 | Q2 | Q3 | Q4 | Q5
1 | T1, SF1 | 3 | 2 |  |  | A | A | B | B | A
2 | T2, SF2 | 1 | 6 |  |  | B | A | A | B | A
3 | T1, SFA1 | 6 | 1 |  |  | A | B | B | B | B
4 | T2, SFA2 | 4 | 4 |  |  | A | A | A | B | A
5 | SF1, [NAME] | 5 | 5 |  |  | A | B | A | A | B
6 | SF2, SFA2 | 2 | 3 |  |  | B | A | A | A | A
Spreadsheet: 856776d1705950777-look-up-but-not-sure-how-copy-of-larder-price-compare
Sheet: Sheet1

 | TESCO | [NAME] | MORRISONS | SAINSBURYS |  |  |  |  | Best Price
BEANS | 0.28 | 0.28 | 0.27 | 0.27 |  |  |  |  |  |  |  |  | DATA
TOM SOUP | 0.67 | 0.62 | 0.55 | 0.67
VEG SOUP | 0.55 | 0.62 | 0.75 | 0.55
CHICKEN SOUP | 0.67 | 0.62 | 0.75 | 0.67
SPAGHETTI HOOPS | 0.43 | 0.19 | 0.5 | 0.19
CHOP TOMS | 0.35 | 0.35 | 0.49 | 0.35
PENE PASTA | 0.41 | 0.41 | 0.41 | 0.75
SPAGHETTI | 0.28 | 0.28 | 0.75 | 0.75
MICRO RICE | 0.45 | 0.45 | 0.65 | 0.5
[NAME] | 1.85 | 1.85 | 1.85 | 1.85
TEA | 0.87 | 0.99 | 0.99 | 1.2
COFFEE | 2.25 | 1.99 | 2.25 | 2.25
SUGAR | 2.15 | 1.09 | 1.19 | 0.85
PORRDIGE | 0.9 | 0.9 | 0.9 | 0.9
COCO POPS/HOOPS | 0.89 | 0.89 | 0.95 | 0.89
CONFLAKES | 0.75 | 0.75 | 0.75 | 0.75
TOILET ROLL | 1.69 | 2.99 | 2.39 | 1.8
WASHING UP LQD | 0.69 | 0.69 | 0.55 | 0.62
 | QTY | TESCO | [NAME] | MORRISONS | SAINSBURYS |  |  |  | Best Price | Store | Store | Store | Store
BEANS | 10 |  |  |  |  |  |  |  |  |  | SAINSBURYS |  |  |  |  |  | OUTPUT
TOM SOUP | 1
VEG SOUP | 1 |  |  |  |  |  |  |  |  |  | SAINSBURYS
CHICKEN SOUP | 1
SPAGHETTI HOOPS | 1 |  |  |  |  |  |  |  |  |  | SAINSBURYS
CHOP TOMS | 1 |  |  |  |  |  |  |  |  |  | [NAME] | SAINSBURYS
PENE PASTA | 1 |  |  |  |  |  |  |  |  |  | [NAME] | MORRISONS
SPAGHETTI | 1 |  |  |  |  |  |  |  |  |  | [NAME]
MICRO RICE | 1 |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | 1 |  |  |  |  |  |  |  |  |  | [NAME] | MORRISONS | SAINSBURYS
TEA | 1
COFFEE | 1
SUGAR | 1
PORRDIGE | 1 |  |  |  |  |  |  |  |  |  | [NAME] | MORRISONS | SAINSBURYS
COCO POPS/HOOPS | 1 |  |  |  |  |  |  |  |  |  | [NAME] | SAINSBURYS
CONFLAKES | 1 |  |  |  |  |  |  |  |  |  | [NAME] | MORRISONS | SAINSBURYS
TOILET ROLL | 1
WASHING UP LQD | 1
Grand Total
Spreadsheet: 198636d1354837786-trying-to-calculate-day-and-night-hours-based-on-sunset-and-sunrise-sunset
Sheet: Sunset

Flight | Date | A/C Type | Tail | Origin |  | Dest | [NAME] | Arrive | Block | Credit
 | 2012-12-01 00:00:00 | EM2 |  | PSP |  | LAX | 16:32:00 | 17:15:00 | 0.7 | 0.78
 | 2012-12-01 00:00:00 | EM2 |  | LAX |  | IYK | 18:53:00 | 19:43:00 | 0.8 | 0.9
 | Sunrise | Sunset
2012-12-01 00:00:00 | 06:41:00 | 16:44:00
Spreadsheet: d10dd670-32e1-4c85-bebc-075fa7465b95
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (5 [NAME]):
 | 5 Labortechnische Geräte 5.4 Labortechnik und Laboreinrichtung 5.4.3 Pumpen, Förder- und Verbindungstechnik 5.4.3.18 Wasser- und Abwasseraufbereitung
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | Parker Hannifin GmbH | Deutschland | Kaarst | 41564 | A1.515
2 | Siemens AG, I IA WT HUB EUR | Deutschland | Barsbüttel | 22885 | B1.417
3 | Thermo Scientific | Deutschland | Dreieich | 63303 | B1.101/202
4 | VWS Deutschland GmbH ELGA LabWater | Deutschland | Celle | 29227 | B1.340
5 | [NAME] GmbH | Deutschland | Leverkusen | 51381 | B1.217