tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 104124d1301764957-multiple-if-using-indirect-to-reference-series
Sheet: Sheet1

 |  |  | Enter details for price
 | series | sq' | W | H | List
 | 850 | 11.5 | 60 | 30 | 854.4499999999999 |  |  |  |  | 830
 |  |  |  |  |  | 1033.8845 |  |  | 5 | 536.78
 |  |  |  |  |  |  |  |  | 11 | 854.4499999999999
 |  |  |  |  |  |  |  |  | 14 | 744.97
 |  |  |  |  |  |  |  |  | 15 | 644
 |  |  |  |  |  |  |  |  |  | 840
830 | EightThirty |  | Tables are named after the numeric values on left |  |  |  |  |  | 5 | 590.458
840 | EightForty |  | <<<<, this lookup table can be hiden somewhere out of the road |  |  |  |  |  | 11 | 939.895
850 | EightFifty |  |  |  |  |  |  |  | 14 | 819.467
860 | EightSixty |  |  |  |  |  |  |  | 15 | 708.4
870 | EightSeventy |  |  |  |  |  |  |  |  | 850
880 | EightEighty |  |  |  |  |  |  |  | 5 | 649.5038
890 | EightNinety |  |  |  |  |  |  |  | 11 | 1033.8845
 |  |  |  |  |  |  |  |  | 14 | 901.4137
 |  |  |  |  |  |  |  |  | 15 | 779.24
 |  |  |  |  |  |  |  |  |  | 860
 |  |  |  |  |  |  |  |  | 5 | 714.45418
 |  |  |  |  |  |  |  |  | 11 | 1137.27295
 |  |  |  |  |  |  |  |  | 14 | 991.5550699999999
 |  |  |  |  |  |  |  |  | 15 | 857.164
 |  |  |  |  |  |  |  |  |  | 870
 |  |  |  |  |  |  |  |  | 5 | 785.899598
 |  |  |  |  |  |  |  |  | 11 | 1251.000245
 |  |  |  |  |  |  |  |  | 14 | 1090.710577
 |  |  |  |  |  |  |  |  | 15 | 942.8804
 |  |  |  |  |  |  |  |  |  | 880
 |  |  |  |  |  |  |  |  | 5 | 864.4895578
 |  |  |  |  |  |  |  |  | 11 | 1376.1002695
 |  |  |  |  |  |  |  |  | 14 | 1199.7816347
 |  |  |  |  |  |  |  |  | 15 | 1037.16844
 |  |  |  |  |  |  |  |  |  | 890
 |  |  |  |  |  |  |  |  | 5 | 950.93851358
 |  |  |  |  |  |  |  |  | 11 | 1513.71029645
 |  |  |  |  |  |  |  |  | 14 | 1319.75979817
 |  |  |  |  |  |  |  |  | 15 | 1140.885284
Spreadsheet: 737583d1624481183-capturing-down-events-with-dates-downtime-calc-eba
Sheet: Sheet1

TIME | Running |  | Down (in Min)
 |  |  |  |  | Down Events | From What Time | Total Min |  |  |  | In Hours
2021-12-01 05:00:00 | 0 |  |  |  | 1 |  | 20 |  |  | Total Down
2021-12-01 05:01:00 | 0 |  |  |  | 2 |  | ??
2021-12-01 05:01:59.990000 | 0 |  |  |  | 3 |  | ??
2021-12-01 05:02:59.985000 | 0
2021-12-01 05:03:59.980000 | 0
2021-12-01 05:04:59.975000 | 0
2021-12-01 05:05:59.970000 | 0
2021-12-01 05:06:59.965000 | 0
2021-12-01 05:07:59.960000 | 0
2021-12-01 05:08:59.955000 | 0
2021-12-01 05:09:59.950000 | 0
2021-12-01 05:10:59.945000 | 0
2021-12-01 05:11:59.940000 | 0
2021-12-01 05:12:59.935000 | 0
2021-12-01 05:13:59.930000 | 0
2021-12-01 05:14:59.925000 | 0
2021-12-01 05:15:59.920000 | 0
2021-12-01 05:16:59.915000 | 0
2021-12-01 05:17:59.910000 | 0
2021-12-01 05:19:00 | 0
2021-12-01 05:19:59.900000 | 7866
2021-12-01 05:20:59.895000 | 7866
2021-12-01 05:21:59.890000 | 7866
2021-12-01 05:22:59.885000 | 7866
2021-12-01 05:23:59.880000 | 7866
2021-12-01 05:24:59.875000 | 7866
2021-12-01 05:25:59.870000 | 0
2021-12-01 05:26:59.865000 | 0
2021-12-01 05:27:59.860000 | 0
2021-12-01 05:28:59.855000 | 0
2021-12-01 05:29:59.850000 | 0
2021-12-01 05:30:59.845000 | 7866
2021-12-01 05:31:59.840000 | 0
2021-12-01 05:32:59.835000 | 0
2021-12-01 05:33:59.830000 | 0
Spreadsheet: 778796d1651324954-formula-to-check-crossed-dates-from-to-crossed-dates
Sheet: Sheet1

# | From | To |  | From | To | result
 | 2022-01-01 00:00:00 | 2022-01-05 00:00:00 |  | 2022-06-20 00:00:00 | 2022-06-25 00:00:00 | 5
 | 2022-01-06 00:00:00 | 2022-02-20 00:00:00
3 | 2022-02-24 00:00:00 | 2022-03-04 00:00:00
4 | 2022-06-16 00:00:00 | 2022-06-19 00:00:00
5 | 2022-06-21 00:00:00 | 2022-06-21 00:00:00
Spreadsheet: 175205d1345456876-problem-with-removing-duplicates-example
Sheet: Sheet1

blue | color a
red | color b
black | color c
blue | color d
red | color e
red | color f
black | color j
black | color h
black | color i
black | color k
Spreadsheet: 702581d1604420352-top-25-values-based-on-another-criteria-top-n-example-simplified
Sheet: simple explanation

 | Item | Month | Price 1 | Price 2
 | Item 1 | 1 | 10 | 5
 | Item 2 | 1 | 11 | 9
 | Item 1 | 1 | 12 | 3
 | Item 3 | 1 | 13 | 7
 | Item 1 | 2 | 13 | 3 |  |  |  |  |  | All months | 1 | 2
 | Item 2 | 2 | 14 | 3
 | Item 2 | 2 | 15 | 2
 | Item 1 | 2 | 16 | 4
 |  |  |  |  |  |  | Example of end result after we have identified and listed the order of the top 3 items:
 |  |  |  |  |  |  |  |  | Price 1 | 1 | 2
 |  |  |  |  |  |  |  |  | Item 2
 |  |  |  |  |  |  |  |  | Item 1
 |  |  |  |  |  |  |  |  | Item 3
Spreadsheet: 74117d1274717988-excel-2007-need-a-formula-to-search-specific-worksheet-sample
Sheet: 4

SKU # | [NAME] | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE |  | Total
12456 | Chicken | 8 | 2010-05-14 00:00:00 | 6 | 2010-05-12 00:00:00
Spreadsheet: 4ac3ce0d-457e-4519-b7bc-0a07616e7b1c
Sheet: SCI % by Contract Type

 | General Services Administration
 | FY 2013 Service Contract Inventory
 | Contract Type Analysis as % of PSC Obligations
 | Total Obligations FY2013:
 | 2764494142.05
Special Interest Functions |  | Obligations | % Total Obligations | Fixed Price | Fixed Price | Cost | Cost | T&M/LH | T&M/LH | Other | Other |  |  |  |  | Biggest Percentage of Obligations |  | Obligations | % Total Obligations | Fixed Price | Fixed Price | Cost | Cost | T&M/LH | T&M/LH | Other | Other
B505 | SPECIAL STUDIES/ANALYSIS- COST BENEFIT | 48772.93 |  | 48772.93 |  |  |  |  |  |  |  |  |  |  |  | C1AZ | ARCHITECT AND ENGINEERING- CONSTRUCTION: OTHER ADMINISTRATIVE FACILITIES/SERVICE BUILDINGS | 319505922.75 |  | 319505922.75
D302 | IT AND TELECOM- SYSTEMS DEVELOPMENT | 13894781.6 |  | 10385613.6 |  |  |  | 3509168 |  |  |  |  |  |  |  | D399 | IT AND TELECOM- OTHER IT AND TELECOMMUNICATIONS | 270044047.55 |  | 165254318.18 |  |  |  | 103619262.03 |  | 1170467.34
D307 | IT AND TELECOM- IT STRATEGY AND ARCHITECTURE | 5990718.78 |  | 4087104.52 |  |  |  | 1903614.26 |  |  |  |  |  |  |  | Z2AA | REPAIR OR ALTERATION OF OFFICE BUILDINGS | 235207008.23 |  | 233779520.23 |  |  |  |  |  | 1427488
D310 | IT AND TELECOM- CYBER SECURITY AND DATA BACKUP | 1911582.62 |  | 1242050.62 |  |  |  | 669532 |  |  |  |  |  |  |  | S201 | HOUSEKEEPING- CUSTODIAL JANITORIAL | 222916873.71 |  | 220723769.51 |  |  |  |  |  | 2193104.2
D314 | IT AND TELECOM- SYSTEM ACQUISITION SUPPORT | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  | S216 | HOUSEKEEPING- FACILITIES OPERATIONS SUPPORT | 196840092.87 |  | 196008390.38 |  |  |  | 766211.56 |  | 65490.93
R406 | POLICY REVIEW/DEVELOPMENT SERVICES | 478314.11 |  |  | 0 |  | 0 | 478314.11 |  |  | 0 |  |  |  |  | Z111 | MAINT-REP-ALT/OFFICE BLDGS | 170142796.95 |  | 157356016.76 |  |  |  | 3909859.36 |  | 8876920.83
R407 | PROGRAM EVALUATION SERVICES | 276740 |  | 276740 |  |  |  |  |  |  |  |  |  |  |  | R499 | SUPPORT- PROFESSIONAL: OTHER | 144644300.77 |  | 122129570.79 |  |  |  | 22468267.98 |  | 46462
R408 | SUPPORT- PROFESSIONAL: PROGRAM MANAGEMENT/SUPPORT | 34418459.42 |  | 27428237.68 |  |  |  | 6990221.74 |  |  |  |  |  |  |  | S112 | UTILITIES- ELECTRIC | 108170918.36 |  | 108170918.36
R409 | PROGRAM REVIEW/DEVELOPMENT SERVICES | 222946.38 |  |  |  |  |  | 222946.38 |  |  |  |  |  |  |  | Y111 | CONSTRUCTION OF OFFICE BUILDINGS | 90531531.37 |  | 90531531.37
R413 | SUPPORT- PROFESSIONAL: SPECIFICATIONS DEVELOPMENT | 283238.18 |  | 283238.18 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | MAINTENANCE OF OFFICE BUILDINGS | 90089028.26 |  | 88739107.87 |  |  |  |  |  | 1349920.39
R414 | SYSTEMS ENGINEERING SERVICES | 2281672.83 |  | 1318944 |  |  |  | 962728.83
R423 | INTELLIGENCE SERVICES | 0 |  |  | 0 |  | 0 |  | 0 |  | 0
R425 | SUPPORT- PROFESSIONAL: ENGINEERING/TECHNICAL | 15047492.17 |  | 12169505.17 |  |  |  | 2877987 |  |  | 0
R497 | SUPPORT- PROFESSIONAL: PERSONAL SERVICES CONTRACTS | 9453597.8 |  | 9115631 |  |  |  | 337966.8
R707 | SUPPORT- MANAGEMENT: CONTRACT/PROC/ACQ SUPPORT | 8102571.8 |  | 6113465.44 |  |  |  | 1989106.36
Spreadsheet: 8eb41800-9afc-433a-94d8-03f3210c42a6
Sheet: Sheet1

Dear Brothers / Sisters,
AsSalamu Alaikum WRWB
Indeed ahead of you is the blessed month of Allah. A month of blessing,
mercy and forgiveness. A month which with Allah is the best of months. Its days,
the best of days, its nights, the best of nights, and its hours, the best of hours.
It is the month which invites you to be the guests of Allah and invites you to be one
of those near to Him. Each breath you take glorifies Him; your sleep is worship, your
deeds are accepted and your supplications are answered.
So, ask Allah, your Lord; to give you a sound body and an enlightened
heart so you may be able to fast and recite His book, for only he is unhappy who is
devoid of Allah's forgiveness during this great month.
*** <<< *** >>> ***
For something so important, we need to PLAN - to get the maximum out of it. Please see
the attached forms for the RAMADAN PLAN 1429H (2008) - Take the prints and fill it up:
A) RESOLUTION FORM: These are the commitments we make to ourselves regarding
this year's Ramadan.
1 - There are 10 sections of this form
2 - You may tick as many as you like under each section
3 - Post it on your notice board at home or workplace to remind you of commitments
B) RAMADAN PLANNER: This form helps you to assess your present status of various
activities, to set a goal for this Ramadan, to evaluate your performance every week,
and finally to assess your growth post-Ramadan.
1 - It consists of various aspects/activities of a Muslim's life during Ramadan
2 - Fill the "present status" column using the measure in "unit" column (the present
status could be of previous Ramadan as well)
3 - Set a goal for this years Ramadan in the "Ramadan Goal" column
4 - Evaluate your performance (with respect to goal) at the end of each week
5 - Assess the level achieved at the end of Ramadan in the last column
6 - The "codes" on the left side of this form are to be used in "Ramadan Timetable"
C) RAMADAN TIMETABLE: This is the daily schedule for this year’s Ramadan
1 - Fill out the job timings, and sleeping hours with different COLORS
2 - Modify the prayer timings for your own city {http://www.islamicfinder.org}
3 - Plan the activities for the whole month by filling the "codes" (from Ramadan
Planner form)
4 - The odd nights during last 10 days have been shaded for [NAME]-e-Qadr
5 - The whole month should be full of activities (every good deed during this
months gets you a reward of 10-700 times)
6 - Keep it in your pocket during the whole month
NOTE:
1. These Forms are not perfect, and does not claim to encompass every aspect of Ramadan
2. Please feel free to modify them as per your needs
3. Cross-check prayer timings for your city from authentic sources
Wishing you a Happy and Blessed Ramadan.
May Allah (SWT) grant us the taufeeq to PLAN & UTILIZE this blessed month to achieve
highest rewards and maghfirah - Aamin.
Spreadsheet: 832422d1686320830-formula-for-getting-all-names-just-once-wether-they-are-duplicate-of-unique-excel-forum-requied-formula
Sheet: Sheet2

Day | District | Facility Name
 |  |  |  |  | Sample  result
 |  |  |  |  | Day | District | Facility Name
 |  |  |  |  | 2021-12-01 00:00:00 | Sheikhan | [NAME]
 |  |  |  |  | 2022-01-22 00:00:00 | Sheikhan | FP Ibrahim
 |  |  |  |  | 2022-01-22 00:00:00 | Sheikhan | FP Shafia
 |  |  |  |  | 2022-01-22 00:00:00 | Sheikhan | Shazia
Spreadsheet: 005f9c80-9c3f-4037-8fd1-57eab132d944
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6202.0 Labour Force, Australia
 | Table 11. Labour force status by Sex - Australian Capital Territory - Trend and Original
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Employed - full-time ;  [NAME] ; |  |  | Trend | A184182L | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | 000 | STOCK | Month | 1
Employed - full-time ;  Females ; |  |  | Trend | A184199J | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | 000 | STOCK | Month | 1
Employed - full-time ;  Persons ; |  |  | Trend | A184216X | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | 000 | STOCK | Month | 1
Employed - total ;  [NAME] ; |  |  | Trend | A184184T | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | 000 | STOCK | Month | 1
Employed - total ;  Females ; |  |  | Trend | A184201J | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | 000 | STOCK | Month | 1
Employed - total ;  Persons ; |  |  | Trend | A184218C | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | 000 | STOCK | Month | 1
Unemployed - total ;  [NAME] ; |  |  | Trend | A184187X | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | 000 | STOCK | Month | 1
Unemployed - total ;  Females ; |  |  | Trend | A184204R | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | 000 | STOCK | Month | 1
Unemployed - total ;  Persons ; |  |  | Trend | A184221T | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | 000 | STOCK | Month | 1
Unemployment rate ;  [NAME] ; |  |  | Trend | A184194W | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | Percent | PERCENT | Month | 1
Unemployment rate ;  Females ; |  |  | Trend | A184211L | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | Percent | PERCENT | Month | 1
Unemployment rate ;  Persons ; |  |  | Trend | A184228J | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | Percent | PERCENT | Month | 1
Participation rate ;  [NAME] ; |  |  | Trend | A184193V | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | Percent | PERCENT | Month | 1
Participation rate ;  Females ; |  |  | Trend | A184210K | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | Percent | PERCENT | Month | 1
Participation rate ;  Persons ; |  |  | Trend | A184227F | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | Percent | PERCENT | Month | 1
Civilian population ;  [NAME] ; |  |  | Original | A163537W | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | 000 | STOCK | Month | 1
Civilian population ;  Females ; |  |  | Original | A163554X | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | 000 | STOCK | Month | 1
Civilian population ;  Persons ; |  |  | Original | A163571A | 1978-02-01 00:00:00 | 2010-12-01 00:00:00 | 395 | 000 | STOCK | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 698191d1601844100-inventory-cost-calculation-fifo-easy-finaly-3-_error-tacir-4-a
Sheet: Fifo

Date | Item.Code | Type | Note | Purchase | Cost / Unit - Manual | Sale | Cumulative purchase Quantity  irrespective Of [NAME] code | Balance | Cucmulative sales quantity irrespective of item.code | TransactionType | Movement | Total Cost irrespective of item code (works) | Total Cost based on FIFO / item code (problem) | Cumulative purchase Cost irrespective of item.code | ESQty | ESCost | cpq.item | csq.item | excess | cpc.item
2013-01-01 00:00:00 | product1 | 1 |  | 10.4 | 179
2013-01-15 00:00:00 | product2 | 1 |  | 600 | 9.5
2013-01-31 00:00:00 | product2 | 1 |  | 1020 | 9
2013-01-31 00:00:00 | product2 | 2 |  |  |  | 600
2013-01-31 00:00:00 | product2 | 2 |  |  |  | 10
2013-01-31 00:00:00 | product2 | 2
2013-01-31 00:00:00 | product1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | the cost of sales
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | this formula multiplies cost by quantity again  M4 * G4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TRUE | IF($L4>=0;L4*F4;sum(M4*G4;SUMIFS(M$3:M3;G$3:G3;">0";B$3:B3;B4)))
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TRUE | IF($L5>=0;L5*F5;sum(M5*G5;SUMIFS(M$3:M4;G$3:G4;">0";B$3:B4;B5)))
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TRUE | IF($L6>=0;L6*F6;sum(M6*G6;SUMIFS(M$3:M5;G$3:G5;">0";B$3:B5;B6)))
 |  |  |  |  |  | Sale |  |  |  |  |  |  |  | FALSE | IF($L7>=0;L7*F7;sum(M7*G7;SUMIFS(M$3:M6;G$3:G6;">0";B$3:B6;B7)))
 |  |  |  |  | True | 600 * 9,5 =  5700 |  |  |  |  |  |  |  | FALSE | IF($L8>=0;L8*F8;sum(M8*G8;SUMIFS(M$3:M7;G$3:G7;">0";B$3:B7;B8)))
 |  |  |  |  | True | 10* 9  =  90
 |  |  |  |  |  | Total | 5790 | True
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I change it     N Colm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF($L4>=0;L4*1;sum(M4*1;SUMIFS(M$3:M3;G$3:G3;">0";B$3:B3;B4)))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF($L5>=0;L5*F1;sum(M5*1;SUMIFS(M$3:M4;G$3:G4;">0";B$3:B4;B5)))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF($L6>=0;L6*F1;sum(M6*1;SUMIFS(M$3:M5;G$3:G5;">0";B$3:B5;B6))) |  |  |  |  |  |  |  | correct result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF($L7>=0;L7*F1;sum(M7*1;SUMIFS(M$3:M6;G$3:G6;">0";B$3:B6;B7)))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF($L8>=0;L8*F1;sum(M8*1;SUMIFS(M$3:M7;G$3:G7;">0";B$3:B7;B8)))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The calculation is correct with the formula I have changed
Spreadsheet: bill_williams_iii__1399__xxxdealenterySeptember
Sheet: 9-5

Tuesday
Deal #s | 760909 |  | 760983 | 760998 | 761001 | 761004 | 761010 | 761012 | 761145 | 761098 | 761119
2001-09-05 00:00:00 |  |  | NP | SP | SP | SP | PV | PV | SP | Gas Recovery | Buy
Delivery Pt. | EPMI CA Pool |  | Sale | Buy | Sale | Buy | STSW | STCA | W. Service | W. Service | Wheelabrator
Counterparty | NP | SP | EES | CA Imbalance | EES | EES | CISO_EPMI_5000 | EPMI_CISO_5001 | Ca Imbal | sell | NP
Totals | 80 | -80 | -4400 | 1200 | -880 | 3728 | -3328 | 800
1 | -156 | 156 | -250 | 17 | -110 |  |  | 100 | 8 | -8 | 8
2 | -156 | 156 | -250 | 17 | -110 |  |  | 100 | 8 | -8 | 8
3 | -156 | 156 | -250 | 17 | -110 |  |  | 100 | 8 | -8 | 8
4 | -156 | 156 | -250 | 17 | -110 |  |  | 100 | 8 | -8 | 8
5 | -156 | 156 | -250 | 17 | -110 |  |  | 100 | 8 | -8 | 8
6 | -156 | 156 | -250 | 17 | -110 |  |  | 100 | 8 | -8 | 8
7 | 95 | -95 | -150 | 17 |  | 233 | -208 |  | 8 | -8 | 8
8 | 95 | -95 | -150 | 42 |  | 233 | -208 |  | 8 | -8 | 8
9 | 95 | -95 | -150 | 42 |  | 233 | -208 |  | 8 | -8 | 8
10 | 95 | -95 | -150 | 42 |  | 233 | -208 |  | 8 | -8 | 8
11 | 95 | -95 | -150 | 42 |  | 233 | -208 |  | 8 | -8 | 8
12 | 95 | -95 | -150 | 42 |  | 233 | -208 |  | 8 | -8 | 8
13 | 95 | -95 | -150 | 42 |  | 233 | -208 |  | 8 | -8 | 8
14 | 95 | -95 | -150 | 42 |  | 233 | -208 |  | 8 | -8 | 8
15 | 95 | -95 | -150 | 42 |  | 233 | -208 |  | 8 | -8 | 8
16 | 95 | -95 | -150 | 42 |  | 233 | -208 |  | 8 | -8 | 8
17 | 95 | -95 | -150 | 42 |  | 233 | -208 |  | 8 | -8 | 8
18 | 95 | -95 | -150 | 42 |  | 233 | -208 |  | 8 | -8 | 8
19 | 95 | -95 | -150 | 42 |  | 233 | -208 |  | 8 | -8 | 8
20 | 95 | -95 | -150 | 42 |  | 233 | -208 |  | 8 | -8 | 8
21 | 95 | -95 | -150 | 42 |  | 233 | -208 |  | 8 | -8 | 8
22 | 95 | -95 | -150 | 42 |  | 233 | -208 |  | 8 | -8 | 8
23 | -156 | 156 | -250 | 42 | -110 |  |  | 100 | 8 | -8 | 8
24 | -156 | 156 | -250 | 42 | -110 |  |  | 100 | 8 | -8 | 8
TIE POINTS
Spreadsheet: 290575d1389905391-formula-to-count-consecutive-blank-cells-in-a-range-depending-on-todays-date-sample-workbook
Sheet: Class Roster

Student ID | Student Name | Class Name | Class Start Date | [NAME] | FORMULA TO COUNT CONSECUTIVE BLANK CELLS | Student Email | 2014-01-13 00:00:00 | 2014-01-20 00:00:00 | 2014-01-27 00:00:00 | 2014-02-03 00:00:00 | 2014-02-10 00:00:00 | 2014-02-17 00:00:00 | 2014-02-24 00:00:00 | 2014-03-03 00:00:00 | 2014-03-10 00:00:00 | 2014-03-17 00:00:00 | 2014-03-24 00:00:00 | 2014-03-31 00:00:00 | 2014-04-07 00:00:00 | 2014-04-14 00:00:00 | 2014-04-21 00:00:00 | 2014-04-28 00:00:00 | 2014-05-05 00:00:00 | 2014-05-12 00:00:00 | 2014-05-19 00:00:00 | 2014-05-26 00:00:00 | 2014-06-02 00:00:00 | 2014-06-09 00:00:00 | 2014-06-16 00:00:00 | 2014-06-23 00:00:00 | 2014-06-30 00:00:00 | 2014-07-07 00:00:00 | 2014-07-14 00:00:00 | 2014-07-21 00:00:00 | 2014-07-28 00:00:00 | 2014-08-04 00:00:00 | 2014-08-11 00:00:00 | 2014-08-18 00:00:00 | 2014-08-25 00:00:00 | 2014-09-01 00:00:00 | 2014-09-08 00:00:00 | 2014-09-15 00:00:00 | 2014-09-22 00:00:00 | 2014-09-29 00:00:00 | 2014-10-06 00:00:00 | 2014-10-13 00:00:00 | 2014-10-20 00:00:00 | 2014-10-27 00:00:00 | 2014-11-03 00:00:00 | 2014-11-10 00:00:00 | 2014-11-17 00:00:00 | 2014-11-24 00:00:00 | 2014-12-01 00:00:00 | 2014-12-08 00:00:00 | 2014-12-15 00:00:00 | 2014-12-22 00:00:00 | 2014-12-29 00:00:00
[NAME] | STUDENT 1 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered |  | [EMAIL]
[NAME] | STUDENT 2 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered |  | [EMAIL]
[NAME] | STUDENT 3 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered |  | [EMAIL]
[NAME] | STUDENT 4 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered |  | [EMAIL]
[NAME] | STUDENT 5 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered |  | [EMAIL]
[NAME] | STUDENT 6 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered |  | [EMAIL]
[NAME] | STUDENT 7 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered |  | [EMAIL]
[NAME] | STUDENT 8 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered |  | [EMAIL]
[NAME] | STUDENT 9 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered |  | [EMAIL]
[NAME] | STUDENT 10 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered |  | [EMAIL]
[NAME] | STUDENT 11 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered |  | [EMAIL]
[NAME] | STUDENT 12 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered |  | [EMAIL]
[NAME] | STUDENT 13 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered |  | [EMAIL]
[NAME] | STUDENT 14 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered |  | [EMAIL]
[NAME] | STUDENT 15 | SAMPLE CLASS | 2014-01-14 12:30:00 | Registered |  | [EMAIL]
Class #:
Spreadsheet: tracy_geaccone__40252__C0366-112458
Sheet: Dept_100192

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
CAFETERIA - Dept. 100192
April, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 112458
2001-04-23 00:00:00 | [NAME] |  | Work Place | Work Place Count | 2 | 14.08 | /MNTH | 28.16
 |  |  |  |  |  |  | Ticket Total |  | 28.16
 |  |  |  |  |  |  | Total for R/C: 112458 |  | 28.16
 |  |  |  |  |  |  | Total for Dept_100192 |  | 28.16
Spreadsheet: 167964d1342172533-how-to-list-the-vav-locations-depending-upon-its-room-maximum-temperature-value-vav-july-5
Sheet: 7F

Date | Time | odc1 | [NAME] | odc3 | odc4 | odc5 | odc6 | odc7 | [NAME]
2012-07-05 00:00:00 | 23:00:00 | 25.36 | 25.25 | 22 |  | 25.22 | 22 | 22 | 26
2012-07-05 00:00:00 | 22:00:00 | 25.13 | 25.02 | 24 |  | 24.9 | 24 | 24 | 25.02
2012-07-05 00:00:00 | 21:00:00 | 24.82 | 24.79 | 22.34 |  | 24.48 | 22.34 | 22.34 | 25.8
2012-07-05 00:00:00 | 20:00:00 | 24.47 | 24.63 | 23.11 |  | 24.1 | 23.11 | 23.11 | 24.63
2012-07-05 00:00:00 | 19:00:00 | 24.23 | 23.75 | 19.23 |  | 23.54 | 19.23 | 19.23 | 23.75
2012-07-05 00:00:00 | 18:00:00 | 24.04 | 22.68 | 20.207 |  | 22.78 | 20.207 | 20.207 | 22.68
2012-07-05 00:00:00 | 17:00:00 | 24.14 | 23.02 | 19.564 |  | 23.04 | 19.564 | 19.564 | 23.02
2012-07-05 00:00:00 | 16:00:00 | 24.49 | 23.97 | 18.921 |  | 23.87 | 18.921 | 18.921 | 23.97
2012-07-05 00:00:00 | 15:00:00 | 24.4 | 24.46 | 18.278 |  | 23.93 | 18.278 | 18.278 | 24.46
2012-07-05 00:00:00 | 14:00:00 | 24.13 | 23.71 | 17.635 |  | 23.27 | 17.635 | 17.635 | 23.71
2012-07-05 00:00:00 | 13:00:00 | 23.98 | 22.47 | 16.992 |  | 22.63 | 16.992 | 16.992 | 22.47
 |  | Expecting answer
 |  | [NAME] temperature reached
 |  | odc1
 |  | [NAME]
 |  | odc5
 |  | [NAME]
Spreadsheet: 00c29aa8-b6b9-44e2-ab5f-e4d0f8f3238f
Sheet: Utaranchal

Place | Address | Contact Person / NO | Mutt | Other Places near by
Badrinath | [NAME] | 01381 - 222 251,094129 61274 | [NAME] mutt
 | Sri Ananth Mutt, Chamoli Dist
 | BADRINATH – 246 422
 | Uttaranchal.
Haridwar | [NAME], Manager, | Phone: 01334-260793, [PHONE] | [NAME] mutt
 | [NAME]
 | 336, Near Birla Farm, Shantikunj University Road ,
 | Haripurkala, HARIDWAR-249205.
Haridwar | [NAME], | Phone : 01334-320927 | Udupi [NAME]
 | [NAME] | mob no ; [PHONE]
 | Shri Palimaru Matha, Ahatmal Village | Pradeep : [PHONE]
 | Kankhal Post, | Tel : 01334 – 260793
 | HARIDWAR, Uttarakhand-249 205
Haridwar | vyasa ashrama | 1334-260110 | [NAME]
 | located about 250 mtrs from madwa ashrama