tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 716758d1612354303-lookup-all-the-columns-with-certain-word-extract-the-value-sum-jameshelp
Sheet: Sheet1

 | TOTAL |  |  |  | 2020-05-01 00:00:00 |  |  |  | 2020-06-01 00:00:00 |  |  |  | 2020-06-01 00:00:00 |  |  |  | 2020-06-01 00:00:00
 | SPEND | SALES | REVENUE | GP | SPEND | SALES | REVENUE | GP | SPEND | SALES | REVENUE | GP | SPEND | SALES | REVENUE | GP | SPEND | SALES | REVENUE | GP
a |  | 1028 |  |  | 17505.51 | 500 | 28568 |  | 23225.96 | 528 | 29868 | 6642.04 | 26859 | 589 | 33265 |  | 23225.96 | 528 | 29868
b
c
d
e
f
g
h
TOTAL
Spreadsheet: 062428e1-a832-42d9-97fb-2d962286e0d9
Sheet: Sheet1

UTAH STATE OFFICE OF EDUCATION | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
District Pupil Transportation
Annual Statistical Report Form "D" (Minutes)
District: |  |  |  | Date: |  |  | Year:
 | Annual Minutes Statistics
 | Area | Total Minutes | Instructions: |  |  |  |  | Notes:
1 | To and From School Minutes |  | Summary of all minutes from fall [NAME] report.
2 | Activity & Field Trip Minutes |  | Summary of all activity & field trip report minutes.
3 | Misc. & Other Program Minutes |  | Summary of all misc. & other program minutes.
4 | Driver in Instruction Minutes |  | Summary of all minutes drivers spent in instruction.
5 | Instruction & Supervision Minutes |  | Summary of all minutes Instructors and supervisors spent.
6 | Administrative Minutes |  | Summary of all administrative minutes including administrative secretarial minutes.
7 | Bus Shop Staff Minutes |  | Summary of all bus shop staff minutes not already accounted for.
8 | Other Support Staff Minutes |  | Summary of all other support staff minutes not already accounted for.
Spreadsheet: 841305d1693494716-show-a-value-for-every-group-of-data-rows-test-file-2-rafael1024-
Sheet: Sheet1

 |  |  |  | I am looking for a way to show "YES" in column E for every zone if an instance of the word "Perimeter" is mentioned in column D.
Zone | Type | Name | Located | Heat needed per Zone
1 | OPEN OFFICE | Office 1 | Perimeter | Yes | yes would appear in cell E14
 | OPEN OFFICE | Office 2 | Perimeter
2 | CORRIDOR | [NAME] | Perimeter | Yes | yes would appear in cell E17
3 | CORRIDOR | [NAME] | Interior | Yes | yes would appear in cell E19
 | CORRIDOR | [NAME] | Interior
 | CORRIDOR | [NAME] | Perimeter
4 | CLASSROOM | Classroom 1 | Interior | Yes | yes would appear in cell E23
 | CLASSROOM | Classroom 2 | Perimeter
5 | CLASSROOM | Classroom 3 | Interior | No |  |  |  |  | Yes
 | CLASSROOM | Classroom 4 | Interior
6 | CORRIDOR | [NAME] | Interior | No
7 | CORRIDOR | [NAME] | Interior | Yes | yes would appear in cell E31
 | CORRIDOR | [NAME] | Perimeter
 | CORRIDOR | [NAME] | Interior
8 | CLASSROOM | Classroom 1 | Perimeter | Yes | yes would appear in cell E35
 | CLASSROOM | Classroom 2 | Interior
Spreadsheet: 674249d1587734577-n-a-error-when-using-format-control-with-index-match-client-list_eh
Sheet: Client Data

Client | ACV | Renwal Date | Product Reviews | Brand Reviews | Dealership Reviews | AAO | Experiences | URL | Product Reviews | Brand Review | Dealership Reviews | AAO | Experiences | Stakeholders | Project?
Company 1 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 2 | Yes | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 3 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 4 | Maybe | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 5 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 6 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 7 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 8 | TBC | TBC | TBC | Different | TBC | TBC | TBC | Test | TBC | New | TBC | TBC | TBC | TBC | TBC
Company 9 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 10 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | tEST | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Company 11 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | Boo | TBC | TBC | TBC | TBC
Company 12 | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC | TBC
Spreadsheet: 105711d1302978477-help-setting-up-workbook-stocksku
Sheet: Quick Lookup

Fiscal Week | 2011 10
Store Name | EDMONTON
 | Values
Row Labels | Count of Reg.Sales Units | Sum of Reg.Sales $
106 | 7 | 97.6
150 | 16 | 300.25
283 | 2 | 16.68
428 | 11 | 149.03
438 | 3 | 5.069999999999999
Grand Total | 39 | 568.63
Spreadsheet: 180954d1347885981-particular-cells-lock-dummy-sheet-for-cell-lock
Sheet: Dummy

 | Name :                                                                      Team / Part :                                                                                   Grade/Designation :
 | No | % | Key Result Areas Identified  for 1st half |  | % | Performance Parameters |  | Target | Self Grading |  |  |  |  | Appraisor Grading(1st) | Appraisor Grading(2nd) | Appraisor Grading(3rd)
 |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | Total
 | 1 | 0.1 | ABC |  | 0.4 | Abc |  | 110228 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 |  |  |  |  | 0.2 | Def |  | 110405 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 |  |  |  |  | 0.4 | Ghi |  | 110615 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 | 2 | 0.1 | Def |  | 0.5 | Jkl |  | 110131 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 |  |  |  |  | 0.5 | Mno |  | 110630 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 | 3 | 0.2 | Ghi |  | 1 | Pqr |  | 110510 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 | 4 | 0.2 | Jkl |  | 1 | [NAME] |  | 110601 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 | 5 | 0.05 | Mno |  | 0.5 | Vwx |  | 110330 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 |  |  |  |  | 0.5 | Yza |  | 110630 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 | 6 | 0.05 | Pqr |  | 0.6 | Bcd |  | 110210 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 |  |  |  |  | 0.4 | Efg |  | 110310 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 | 7 | 0.1 | [NAME] |  | 0.7 | Hij |  | 110530 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 |  |  |  |  | 0.3 | Klm |  | 110610 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 | 8 | 0.05 | Vwx |  | 0.4 | Nop |  | 110228 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 |  |  |  |  | 0.3 | Qrs |  | 110331 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 |  |  |  |  | 0.3 | Tuv |  | 110530 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 | 9 | 0.05 | Yza |  | 1 | Wxy |  | 110630 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 | 10 | 0.1 | Bcd |  | 1 | Zab |  | 110531 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 | Total
Spreadsheet: 270360d1381446139-increment-letters-2013-10-10-excel-forum-oeldere3-
Sheet: Blad1

200
Spreadsheet: 295427d1391697162-find-the-week-ending-date-book1
Sheet: Sheet1

DueDateStart | Month | Day | Year | Week
2014-Feb-06 06:35:00 PM
2014-Jan-31 05:01:00 PM
2014-Feb-10 04:07:00 PM
2014-Feb-10 04:04:00 PM
2014-Feb-04 04:01:00 PM
2014-May-05 03:12:00 PM
2014-Jan-28 03:03:00 PM
2014-Feb-06 03:07:00 PM
2014-Jan-28 03:07:00 PM
2014-Jan-28 01:21:00 PM
2014-Jan-31 01:20:00 PM
2014-Feb-04 01:11:00 PM
2014-Feb-03 01:08:00 PM
Spreadsheet: 835484d1688626153-need-help-developing-formula-to-track-weiight-loss-goals-weight-loss-journal
Sheet: Sheet1

date | actual weight | goal weight | act loss | goal loss | scheduled weight | weeks behind/ahead
2023-06-15 00:00:00 | 112.7 |  |  |  | 112.7
2023-06-22 00:00:00 | 110
2023-06-29 00:00:00 | 109.3
2023-07-06 00:00:00 | 108.5
2023-07-13 00:00:00 | 108
2023-07-20 00:00:00 | 107
2023-07-27 00:00:00 | 107.2
2023-08-03 00:00:00 | 106.5
2023-08-10 00:00:00 | 106.3
2023-08-17 00:00:00 | 104.8
2023-08-24 00:00:00 | 105.1
2023-08-31 00:00:00
2023-09-07 00:00:00
2023-09-14 00:00:00
2023-09-21 00:00:00
2023-09-28 00:00:00
2023-10-05 00:00:00
2023-10-12 00:00:00
2023-10-19 00:00:00
2023-10-26 00:00:00
2023-11-02 00:00:00
2023-11-09 00:00:00
2023-11-16 00:00:00
2023-11-23 00:00:00
2023-11-30 00:00:00
2023-12-07 00:00:00
2023-12-14 00:00:00
2023-12-21 00:00:00
2023-12-28 00:00:00
2024-01-04 00:00:00
2024-01-11 00:00:00
2024-01-18 00:00:00
2024-01-25 00:00:00
Spreadsheet: 57655d1257870308-extraction-sample-of-emails-from-a-sheet-proportionate-to-the-original-sample-emails
Sheet: Sheet1

 | Total Emails
 | Extract | 20
 | Actually Extracted
 | Town | Employee Cat | email | Town_Emp | A | B | C
 | A | 1 | email [EMAIL] |  |  |  |  |  | Count of email | Column Labels
 | A | 1 | email [EMAIL] |  |  |  |  |  | Row Labels | A | B | C | Grand Total
 | A | 1 | email [EMAIL] |  |  |  |  |  | 1 | 11 | 3 | 7 | 21
 | A | 1 | email [EMAIL] |  |  |  |  |  | 2 | 5 | 3 |  | 8
 | A | 1 | email [EMAIL] |  |  |  |  |  | 3 | 5 | 3 |  | 8
 | A | 1 | email [EMAIL] |  |  |  |  |  | 4 | 4 |  |  | 4
 | A | 1 | email [EMAIL] |  |  |  |  |  | 5 | 5 | 4 | 10 | 19
 | A | 1 | email [EMAIL] |  |  |  |  |  | Grand Total | 30 | 13 | 17 | 60
 | A | 1 | email [EMAIL]
 | A | 1 | email [EMAIL] |  |  |  |  |  |  | A | B | C
 | A | 1 | email [EMAIL]
 | A | 2 | email [EMAIL]
 | A | 2 | email [EMAIL]
 | A | 2 | email [EMAIL]
 | A | 2 | email [EMAIL]
 | A | 2 | email [EMAIL]
 | A | 3 | email [EMAIL] |  |  |  |  |  | Number of email addresses to extract by Town
 | A | 3 | email [EMAIL] |  |  |  |  |  |  | A | B | C
 | A | 3 | email [EMAIL] |  |  |  |  |  | No.
 | A | 3 | email [EMAIL]
 | A | 3 | email [EMAIL] |  |  |  |  |  | Number of email addresses to extract by Employee Cat
 | A | 4 | email [EMAIL] |  |  |  |  |  | Employee Cat | No.
 | A | 4 | email [EMAIL] |  |  |  |  |  | 1
 | A | 4 | email [EMAIL] |  |  |  |  |  | 2
 | A | 4 | email [EMAIL] |  |  |  |  |  | 3
 | A | 5 | email [EMAIL] |  |  |  |  |  | 4
 | A | 5 | email [EMAIL] |  |  |  |  |  | 5
 | A | 5 | email [EMAIL]
 | A | 5 | email [EMAIL]
 | A | 5 | email [EMAIL]
 | B | 1 | email [EMAIL]
 | B | 1 | email [EMAIL]
 | B | 1 | email [EMAIL]
 | B | 2 | email [EMAIL]
 | B | 2 | email [EMAIL]
 | B | 2 | email [EMAIL]
 | B | 3 | email [EMAIL]
 | B | 3 | email [EMAIL]
 | B | 3 | email [EMAIL]
 | B | 5 | email [EMAIL]
 | B | 5 | email [EMAIL]
 | B | 5 | email [EMAIL]
 | B | 5 | email [EMAIL]
 | C | 1 | email [EMAIL]
 | C | 1 | email [EMAIL]
 | C | 1 | email [EMAIL]
 | C | 1 | email [EMAIL]
 | C | 1 | email [EMAIL]
 | C | 1 | email [EMAIL]
 | C | 1 | email [EMAIL]
 | C | 5 | email [EMAIL]
 | C | 5 | email [EMAIL]
 | C | 5 | email [EMAIL]
 | C | 5 | email [EMAIL]
 | C | 5 | email [EMAIL]
 | C | 5 | email [EMAIL]
 | C | 5 | email [EMAIL]
 | C | 5 | email [EMAIL]
 | C | 5 | email [EMAIL]
 | C | 5 | email [EMAIL]
Spreadsheet: 39238d1237413619-count-function-sales
Sheet: Sheet1

 |  |  |  | 1193998.390844565
 |  |  |  | 2010
 |  | Status | Item | Sales
 |  | Active | TEA CUP LEIGH | 573970.0260588143
 |  | Active | TEA SAUCER | 383518.4422052684
 |  | Active | PLATE 20CM LINC | 104074.7611620183
 |  | Deactive | MUG                LEIGH | 68122.16757407809
 |  | Deactive | PLATE 27CM LINC | 60853.39188810952
 |  | Deactive | COVERED ORIENTAL TEACUP | 34533.07007653296
 |  | Deactive | TEA POT S/S | 45115.57248547567
 |  | Deactive | [NAME]8.2 5352 | 33865.13881780054
 |  | Deactive | B & B PLATE | 45826.42469536637
 |  | Active | PETIT TRAY SQUARE 11.5CM | 18568.12594526805
 |  | Active | PETIT TRAY ROUND 12CM | 13148.51605316368
 |  | Active | SUGAR BOX TEA S/S | 17157.29790660225
 |  | Active | CREAMER TEA S/S | 12320.34635416667
 |  | Active | OATMEAL         6.2  PLN | 10250.04922253115
 |  | Active | PLATE   10.7 LINC | 60990.82593673218
Spreadsheet: 855633d1705144209-count-continuous-occurences-restart-counting-when-condition-met-exclude-conditions-met-excelforum_count_contious_and_skipped-copy
Sheet: Sheet1

Values | In Column A, count "A" from last "C" occurence downwards. Cells with B should be skipped in the counting) | In Column A, count "C" from last "A" occurence downwards. Cells with B should be skipped in the counting)
C
A | 1
A | 2
A | 3
B
B
A | 4
C |  | 1
C |  | 2
B
B
C |  | 3
A | 1
A | 2
A | 3
B
A | 4
A | 5
B
A | 6
B
C |  | 1
C |  | 2
C |  | 3
A | 1
C |  | 1
C |  | 2
B
C |  | 3
C |  | 4
C |  | 5
B
A | 1
A | 2
A | 3
 | New rows will be added downwards every day.
Spreadsheet: 713512d1610745578-meal-plan-hyperlink-vlookup-result-to-worksheet-in-same-workbook-meal-plan
Sheet: Breakfast

KID APPROVAL? | BREAKFAST CODE | BREAKFAST MEAL | BREAKFAST INGREDIANTS
 | EGG BISCUIT | EGG BISCUITS | EGGS, BISCUITS, PARSLEY ETC…
 | CINNAMIN BUNS | CINNAMIN BUNS | FLOUR, EGGS, MILK, CINNAMIN, BROWN SUGAR, WHITE SUGAR, BAKING SODA AND OTHERS
 | YOGURT | YOGURT | YOGURT, FRUITS (STRAWBERRIES, BLUE BERRIES, BANANA), FLAKSEED, HONEY, COCONUT
 | BACON AND EGGS | BACON AND EGGS | BACON, EGGS, MILK,
 | TOAST | TOAST | BREAD, SPREAD/JAM/NUTELLA
 | WAFFLES | WAFFLES | [NAME], SYRUP
 | PANCAKES | PANCAKES | PANCAKE [NAME], SYRUP
 | BK8 | BREAKFAST 8 | BK INGREDIANTS 8
 | BK9 | BREAKFAST 9 | BK INGREDIANTS 9
 | BK10 | BREAKFAST 10 | BK INGREDIANTS 10
 | BK11 | BREAKFAST 11 | BK INGREDIANTS 11
 | BK12 | BREAKFAST 12 | BK INGREDIANTS 12
 | BK13 | BREAKFAST 13 | BK INGREDIANTS 13
 | BK14 | BREAKFAST 14 | BK INGREDIANTS 14
 | BK15 | BREAKFAST 15 | BK INGREDIANTS 15
 | BK16 | BREAKFAST 16 | BK INGREDIANTS 16
 | BK17 | BREAKFAST 17 | BK INGREDIANTS 17
 | BK18 | BREAKFAST 18 | BK INGREDIANTS 18
 | BK19 | BREAKFAST 19 | BK INGREDIANTS 19
 | BK20 | BREAKFAST 20 | BK INGREDIANTS 20
 | NONE | NONE | NONE
 | TBD | TO BE DETERMINED | TO BE DETERMINED
Spreadsheet: 3eb1411d-5a37-40c3-acb8-fb0f50e50feb
Sheet: Sheet1

Member Association | Name | Last | [NAME] | Phone | Assignor | Last | [NAME] | Phone #
Seattle Youth Soccer Association | Cyndy | Masada | [EMAIL] | [PHONE] | Greg | Parker | [EMAIL] | [PHONE]
Yakima Youth Soccer Association | [NAME] | Bredwell | [EMAIL] | [PHONE] | [NAME] | Sabari | [EMAIL] | [PHONE]
North County Youth Soccer Association | Naomi | [NAME] | [EMAIL] | [PHONE]
Spokane Valley Junior Soccer Association | [NAME] | Philp | [EMAIL] | [PHONE] | [NAME] | [NAME] | [EMAIL] | [PHONE]
Lake Washington Youth Soccer Association | Connie | [NAME] | [EMAIL] | [PHONE] | [NAME] | Butler | [EMAIL] | [PHONE]
Federal Way Soccer Association | Novella | [NAME] | [EMAIL] | [PHONE] | [NAME] | Simone | [EMAIL] | [PHONE]
Northwest Sound Youth Soccer Association | [NAME] | Bjornemo | [EMAIL] | [PHONE] | [NAME] | Sommers | [EMAIL] | [PHONE]
South Snohomish County Youth Soccer Association | Dina | [NAME] | [EMAIL] | [PHONE] | Betty | Schmeck | [EMAIL] | [PHONE]
Whatcom County Youth Soccer Association | Lauire | Mueller | [EMAIL] | [PHONE] | Lance | Calloway | [EMAIL] | [PHONE]
Inland Empire Youth Soccer Association | [NAME] | Heuett | [EMAIL] | [PHONE] | Saeed | [NAME] | [EMAIL] | [PHONE]
Kent Youth Soccer Association | [NAME] | Crocker | [EMAIL] | 9194644613 | Scott | [NAME] | [EMAIL] | [PHONE]
Southwest Washington Youth Soccer Association | [NAME] | Hunting | [EMAIL] | [PHONE] | [NAME] | Brooks | [EMAIL] | [PHONE]
Eastside Youth Soccer Association | [NAME] | deCillia | [EMAIL] | 4253927966 | Iraj | Jalali | [EMAIL] | [PHONE]
Eastside Youth Soccer Association | [NAME] | deCillia | [EMAIL] |  | [NAME] | Isaacson | [EMAIL] | [PHONE]
Tacoma Pierce County Junior Soccer Association | Ray | Moffatte | [EMAIL] | 2532975040 | [NAME] | Schmitt | [EMAIL] | [PHONE]
Whidbey Island Youth Soccer Association | Mark | Helpenstell | [EMAIL] | 4258792603 | Nick | Buschko | [EMAIL] | [PHONE]
 |  |  |  | 3605798633 |  |  |  | [PHONE]
Northshore Youth Soccer Association | M'ily | Reiter | [EMAIL] | (406) 671-5804 | Iraj | Jalali | [EMAIL] | [PHONE]
Three Rivers Soccer Club | [NAME] | [NAME] | [EMAIL]
Greater Renton Junior Soccer Association | Rich | Turner | [EMAIL] | (206) 948-6936 | [NAME] | Moore | [EMAIL] | (253) 653-1342
Snohomish County Youth Soccer Association | [NAME] | [NAME] | [EMAIL] | [PHONE]
Highline Soccer Association | [NAME] | [NAME] | [EMAIL] | [PHONE] | Adrian | [NAME] | [EMAIL] | [PHONE]
Spreadsheet: 16c0646d-9f7b-4557-b1f0-b5748af1739e
Sheet: 11

 | [NAME] گسترش و نوسازی صنایع ایرانیان مانا ( سهامی خاص )
 | یادداشتهای توضیحی صورتهای مالی
 | دوره مالي شش ماهه منتهي به 31 خرداد ماه 1390
 | 4-1-2- صورت ريزحسابهای جاری نزد بانکها به قرار زيرمی باشد:
 |  |  |  |  |  |  |  | 1390/03/31 |  | 1389/09/30
 |  |  |  |  |  |  |  | ریال |  | ریال
 | بانک ملی جم-[PHONE] |  |  |  |  |  |  | 10217296 |  | 4235199
 | [NAME]  2900/79 |  |  |  |  |  |  | 157820995 |  | 894439166
 | بانک ملت - فجر  2812659/78 |  |  |  |  |  |  | 53124614 |  | 50054536
 | [NAME]2500/49 |  |  |  |  |  |  | 606417 |  | 15586783
 | بانک تجارت -ميرعماد  122109100 |  |  |  |  |  |  | 890000 |  | 0
 | [NAME] پاسارگاد- حساب سپرده سلیمان خاطر  [PHONE] |  |  |  |  |  |  | 0 |  | 19639
 | بانک ملت -شعبه [NAME] |  |  |  |  |  |  | 19435555 |  | 8447835
 | [NAME] مدرس  [PHONE] |  |  |  |  |  |  | 0 |  | 500000
 | [NAME] مدرس 1414/16 |  |  |  |  |  |  | 2665693027 |  | 0
 | [NAME] پاسارگاد- میرزای شیرازی [PHONE] |  |  |  |  |  |  | 0 |  | 1000000
 | [NAME] پاسارگاد- میرزای شیرازی [PHONE] |  |  |  |  |  |  | 1035600 |  | 957000
 | بانک توسعه صادرات - بلوار کشاورز [PHONE] |  |  |  |  |  |  | 1981250 |  | 1981250
 | 4-1-3- صورت ريزحسابهای جاری ارزی به شرح زير می باشد:
 |  |  |  | 1390/03/31 |  |  |  | 1389/09/30
 |  |  |  | مبلغ - ارز |  | ریال |  | مبلغ - ارز |  | ریال
 | پاسارگاد میرزای شیرازی   30771608395041 |  |  | 100 |  | 1179600 |  | 100 |  | 1035600
 | موجودی های ارزی نزد بانکها در پايان سال بر اساس هر دلار 11796ریال تسعیر [NAME] .
 | 4-2- مشترک با کارفرمایان بشرح زیر میباشد : |  |  |  |  |  |  | 1390/03/31 |  | 1389/09/30
 |  |  |  |  |  |  |  | ریال |  | ریال
 | [NAME] با کارفرمای شهرداری |  |  |  |  |  |  | 889935 |  | 0
 | [NAME] [NAME] بانک صادرات |  |  |  |  |  |  | 9841382 |  | 0
Spreadsheet: 168577d1342513865-excel-2007-rounding-hours-up-and-down-for-15minute-clock-in-out-intervals-hours-totals-and-rounding
Sheet: Sheet1

 |  | Mon | Tue | Wed | Thur | Fri | Sat | Sun | Weekly
 |  | 2012-07-09 00:00:00 | 2012-07-10 00:00:00 | 2012-07-11 00:00:00 | 2012-07-12 00:00:00 | 2012-07-13 00:00:00 | 2012-07-14 00:00:00 | 2012-07-15 00:00:00 | Total
 | Actual In | 15:09:00 | 07:49:00 | 07:46:00 | 07:55:00 | 07:58:00 | 07:56:00 | 07:48:00
 | Interval In
 | Actual Out | 00:03:00 | 16:31:00 | 16:33:00 | 16:30:00 | 16:43:00 | 16:42:00 | 16:55:00
 | Interval Out
 | Breaks | 0:30:00 | 0:30:00 | 0:30:00 | 0:30:00 | 0:30:00 | 0:30:00 | 0:30:00
 | Actual Total
 | Interval Total
 |  |  |  |  | Whats happened here??
Spreadsheet: jane_tholt__13262__WestRateSheet
Sheet: EOLID's

Note: table must be sorted in [NAME] |  |  |  |  |  |  |  | formula
Cash Product | EOL ID | Bid | Offer | Mid
Aeco | 30858
[NAME] | 34860
CIG Mainline | 33884
[NAME] | 30016
EPNG [NAME] | 27761
Kern Opal | 27825
NWPL RkyMtn Pool | 43798
NWPL SanJuan Pool | 43808
NWPL Wyoming Pool | 43818
Opal | 27825
PEPL | 27826
PG&E Baja Pool | 60157
PG&E CtyGte | 27765
[NAME] | 27827
PGT Stanfield | 57246
[NAME] | 43788
[NAME] | 58038
[NAME] | 58042
[NAME] | 58600
[NAME] | 27762
SoCal TW Needles | 58034
[NAME] | 58604
Sumas | 31101
TransCol CIG | 33884
TW Blanco | 30016
TW Permian | 27761
Waha | 52231
WIC | 33885
Spreadsheet: 89483d1289275995-how-to-change-multiple-date-formats-in-same-column-sample
Sheet: Sheet1

My formula | DateOpened | [NAME] | Status
2010-11-05 00:00:00 | 2010-05-11 10:54:58 | 20056 | Open
2010-11-03 00:00:00 | 2010-03-11 18:35:43 | 19925 | Closed
2010-11-03 00:00:00 | 2010-03-11 10:42:20 | 19841 | Closed
2010-11-03 00:00:00 | 2010-03-11 10:14:26 | 19839 | Open
2010-11-03 00:00:00 | 2010-03-11 09:59:09 | 19837 | Open
2010-11-02 00:00:00 | 2010-02-11 16:52:54 | 19806 | Closed
2010-11-02 00:00:00 | 2010-02-11 12:25:53 | 19750 | Closed
2010-11-02 00:00:00 | 2010-02-11 12:19:05 | 19746 | Closed
2010-11-01 00:00:00 | 2010-01-11 16:26:54 | 19685 | Closed
2010-11-01 00:00:00 | 2010-01-11 14:55:11 | 19674 | Closed
2010-11-01 00:00:00 | 2010-01-11 11:28:29 | 19633 | Open
2010-11-01 00:00:00 | 2010-01-11 11:11:03 | 19630 | Closed
#N/A | 10/28/2010 1:24:07 PM | 19390 | Closed
#N/A | 10/28/2010 12:53:10 PM | 19383 | Open
#N/A | 10/28/2010 10:09:23 AM | 19358 | Closed
2010-10-12 00:00:00 | 2010-12-10 15:09:27 | 17904 | Closed
2010-10-12 00:00:00 | 2010-12-10 14:34:53 | 17896 | Closed
2010-10-12 00:00:00 | 2010-12-10 14:31:24 | 17893 | Closed
2010-10-12 00:00:00 | 2010-12-10 13:32:20 | 17886 | Closed
2010-10-12 00:00:00 | 2010-12-10 13:32:16 | 17885 | Closed
#N/A | 9/30/2010 5:28:51 PM | 17041 | Closed
#N/A | 9/30/2010 12:21:57 PM | 16985 | Closed
#N/A | 9/30/2010 12:11:21 PM | 16983 | Closed
#N/A | 9/30/2010 11:36:51 AM | 16981 | Closed
#N/A | 9/29/2010 7:08:08 PM | 16957 | Closed
#N/A | 9/29/2010 3:37:33 PM | 16909 | Closed
#N/A | 9/29/2010 1:48:24 PM | 16876 | Closed
#N/A | 9/29/2010 12:17:01 PM | 16859 | Closed
Spreadsheet: 700184d1603046285-count-equal-and-adjacent-cells-example
Sheet: Folha1

Date | Local | Type | Result |  | Location | Count
2020-10-01 00:00:00 | 1/20 | Test | Conform
2020-10-02 00:00:00 | 2/35 | Test | Conform
2020-10-03 00:00:00 | 2/25 | Test | Non-conform
2020-10-04 00:00:00 | 1/20 | Repetition | Conform
2020-10-05 00:00:00 | 1/25 | Test | Non-conform
2020-10-06 00:00:00 | 1/25 | Repetition | Non-conform
2020-10-07 00:00:00 | 1/25 | Test | Conform
2020-10-08 00:00:00 | 1/20 | Test | Non-conform
2020-10-09 00:00:00 | 1/20 | Repetition | Non-conform
2020-10-10 00:00:00 | 1/20 | Test | Non-conform
2020-10-11 00:00:00 | 1/35 | Test | Non-conform
2020-10-20 00:00:00 | 1/25 | Test | Non-conform
2020-10-20 00:00:00 | 1/20 | Test | Conform
Spreadsheet: eric_saibi__9855__101101U
Sheet: Palo Verde 02 R7

Owner Name | Arizona Public Service Company
Station Name | Palo Verde Nuclear Power Station
Unit Name | Palo Verde 02 R7
NERC Region | WSCC
State | AZ
Fuel Type | Nuclear
Capacity | 1,403 MW
Start Date | 2001-10-11 00:00:00
End Date | 2001-10-14 00:00:00
Comments | [NAME]
SIC | 4911
Plant ID | 1015283
Unit ID | 1007874
Outage ID | 18635
Spreadsheet: eric_saibi__9985__112601
Sheet: Colstrip 03

Owner Name | PPL Montana LLC
Station Name | Colstrip Power Station
Unit Name | Colstrip 03
NERC Region | WSCC
State | MT
Fuel Type | Coal
Capacity | 778 MW
Start Date | 2001-11-24 00:00:00
End Date | 2001-12-01 00:00:00
Comments | Bearing Work
SIC | 4931
Plant ID | 1015370
Unit ID | 1007494
Outage ID | 18968
Spreadsheet: 34865d1232264171-summarize-daily-data-into-weekly-average-average-of-daily-data
Sheet: Summary

Month | Monthly Average
2008-11-01 00:00:00 | 52.75
2008-12-01 00:00:00 | 53.82608695652174
2009-01-01 00:00:00 | 47.5
2009-02-01 00:00:00 | #N/A
2009-03-01 00:00:00 | #N/A
2009-04-01 00:00:00 | #N/A
2009-05-01 00:00:00 | #N/A
2009-06-01 00:00:00 | #N/A
2009-07-01 00:00:00 | #N/A
2009-08-01 00:00:00 | #N/A
2009-09-01 00:00:00 | #N/A
2009-10-01 00:00:00 | #N/A
2009-11-01 00:00:00 | #N/A
2009-12-01 00:00:00 | #N/A
Week starting | Weekly average
2008-11-03 00:00:00 | 45.4
2008-11-10 00:00:00 | 74.2
2008-11-17 00:00:00 | 51.6
2008-11-24 00:00:00 | 39.8
2008-12-01 00:00:00 | 78
2008-12-08 00:00:00 | 53.4
2008-12-15 00:00:00 | 47
2008-12-22 00:00:00 | 43
2008-12-29 00:00:00 | 36.2
2009-01-05 00:00:00 | 28.8
2009-01-12 00:00:00 | 53.6
2009-01-19 00:00:00 | 54.4
2009-01-26 00:00:00 | 62.2
2009-02-02 00:00:00 | #N/A
2009-02-09 00:00:00 | #N/A
2009-02-16 00:00:00 | #N/A
2009-02-23 00:00:00 | #N/A
2009-03-02 00:00:00 | #N/A