tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 847783d1698657883-conditional-formatting-training-certificate-expiration-dates-course-matrix-august-2023
Sheet: Competency 

 |  | Competency and Asessment
 |  |  | (Annually)
 | Name | Course | Date of course | Date of renewal
 | [NAME] | Competency & Assessment |  | Not required |  |  | Key
 | [NAME] | Competency & Assessment | 25/05/23 | 25/05/24 |  |  |  | Not due
 | [NAME] | Competency & Assessment | 25/04/23 | 25/04/24 |  |  |  | Overdue
 | [NAME] | Competency & Assessment | 26/05/23 | 26/05/24 |  |  |  | Due within the next week
 | [NAME] | Competency & Assessment |  | Required |  |  |  | Required
 | [NAME] | Competency & Assessment |  | Required |  |  |  | Not Required
 | [NAME] | Competency & Assessment | N/A | Not required
 | [NAME] | Competency & Assessment | 2023-05-03 00:00:00 | 2024-05-03 00:00:00
 | [NAME] | Competency & Assessment | 2023-05-24 00:00:00 | 2024-05-24 00:00:00
 | [NAME] | Competency & Assessment | 2023-05-02 00:00:00 | 2024-05-02 00:00:00
 | [NAME] | Competency & Assessment | 2023-05-02 00:00:00 | 2024-05-02 00:00:00
 | Greg Love | Competency & Assessment |  | Required
 | [NAME] | Competency & Assessment | 2023-04-25 00:00:00 | 2024-04-25 00:00:00
 | [NAME] | Competency & Assessment | 2023-04-24 00:00:00 | 2024-04-24 00:00:00
 | [NAME] Parkinson | Competency & Assessment | 2022-11-17 00:00:00 | 2024-11-17 00:00:00
 | [NAME] | Competency & Assessment | 2023-07-17 00:00:00 | 2024-07-17 00:00:00
 | [NAME] | Competency & Assessment |  | Required
 | [NAME] | Competency & Assessment | 2023-05-24 00:00:00 | 2024-05-24 00:00:00
 | [NAME] | Competency & Assessment | 2023-05-02 00:00:00 | 2024-05-02 00:00:00
 | [NAME] | Competency & Assessment | 2023-06-01 00:00:00 | 2024-06-01 00:00:00
 | [NAME] | Competency & Assessment | 2023-05-24 00:00:00 | 2024-05-24 00:00:00
 | [NAME] | Competency & Assessment
 | [NAME] | Competency & Assessment | 2023-04-24 00:00:00 | 2024-04-24 00:00:00
 | [NAME] | Competency & Assessment |  | Required
 | [NAME] | Competency & Assessment | N/A | Not required
 | [NAME] | Competency & Assessment | 2023-05-02 00:00:00 | 2024-05-02 00:00:00
 | [NAME] | Competency & Assessment |  | Required
 | [NAME] | Competency & Assessment |  | Required
 | [NAME] | Competency & Assessment | 2023-05-30 00:00:00 | 2024-05-30 00:00:00
 | [NAME] | Competency & Assessment | 2023-05-26 00:00:00 | 2024-05-26 00:00:00
 | [NAME] | Competency & Assessment |  | Required
Spreadsheet: 484768d1476438786-basic-index-match-question-example
Sheet: Sheet1

 |  |  |  | LOGIC IN COLUMNS B & C
 | [NAME] | michelle |  | <<<< | MIKE IS RELATED TO MICHELLE
 | [NAME] | angelina |  | <<<< | MIKE IS RELATED TO ANGELINA
 | [NAME] | bradley |  | ETC
 | tom | Aiesha |  | <<<< | [NAME] IS RELATED TO AIESHA
 | michelle | [NAME] |  | ETC
 | [NAME] | tom |  | ETC
 | michelle | [NAME] |  | ETC
 | tom | laurance
 | tom | [NAME]
 |  |  |  |  |  |  |  | None duplicate names | relationships (Show all named related to values in column i18:i27)
 |  |  |  |  |  |  |  | [NAME] | michelle | angelina | bradley
 |  |  |  |  |  |  |  | tom | [NAME] | [NAME] | laurance
 |  |  |  |  |  |  |  | [NAME] | etc | etc | etc
 |  |  |  |  |  |  |  | [NAME] | etc | etc | etc
 |  |  |  |  |  |  |  | [NAME] | tom | etc | etc
 |  |  |  |  |  |  |  | angelina | etc | etc | etc
 |  |  |  |  |  |  |  | bradley | etc | etc | etc
 |  |  |  |  |  |  |  | Aiesha | etc | etc | etc
 |  |  |  |  |  |  |  | [NAME] | etc | etc | etc
 |  |  |  |  |  |  |  | [NAME] | etc | etc | etc | <<<<<<<< | INDEX MATCH FORMULA FOR GREEN SECTION??
Spreadsheet: 151303d1334859071-excel-2007-help-with-collapsing-expanding-rows-in-excel-but-still-maintain-summary-row-mainstem-ww-sw-rights-gfid-project
Sheet: Glossary

Owner: | Current owner(s) of place of use of water right
WR#: | Certificate Number of Water Right
WRIS#: | Ecology tracking number, these are a guess using the GWIS system (guesses are best for unchanged rights)
Change #: | The Change Certificate Number(s), if any.
Months: | The monthly allocation of water under the water right.  May not reflect actual use.
Priority: | The priority date, by year, of the subject water right
Purpose: | The authorized purposes of use for the water right
P/N/A: | The relationship of the subject right to other water rights on the same land (Primary/Non-Additive/Additive)
RM: | River mile.  The beginning point is Mile 0 as desgnated on USGS Quad map.
Acres: | Acres authorized for irrigation; may not reflect actual use
POD lat/long: | The GPS coordinates for each pump associated with the water right (WGS 84 datum)
Ditch Link: | Link to separate summary of water rights for ditch diversions
Screen Qi: | The maximum diversion rate associated with pump capacity at the time screen/meter installed
Well: | Is there a 'supplemental' ground water right?
[NAME]: | Yes/No on meter installation
LCD: | Lowden Ditch Company decree Yes/No - right is senior to GFID, even if priority date is junior (more recent)
Notes: | Relevant infomration regarding the water right
If you have comments/edits to this file please do them in a note, or highlight changed cells in some way and send them to [EMAIL] so a current version can be maintained, Thanks
Spreadsheet: 164805d1340896741-how-to-shade-alternate-pairs-of-partial-rows-shading-problem
Sheet: Sheet1

 |  |  | Part | Part | Part
 | Number | [NAME] | Qty | Qty | Qty
 | 51024 | Widget | Doohickey | [NAME] | BoxEmUp
 |  |  | 15 | 5 | 5
 | 82059 | Deluxe Widget | Fixelwhistle | Smackeroon | Handle Bag
 |  |  | 120 | 40 | 20
 | 11053 | AcmeThunder | Rocket | Match | Crate
 |  |  | 1 | 1 | 1
 | 62054 | Slingshot | [NAME] | Big Y Thingies | ShrinkPack
 |  |  | 2 | 1 | 1
 |  | Cells Merged
Spreadsheet: 158465d1338269359-organizing-an-array-into-a-different-array-cseanswer
Sheet: Sheet1

 |  |  |  |  |  |  |  | Num | Let | Want | Extra
 |  |  |  |  |  |  |  |  | a | lskjd | 1.2
 | 1 | 2 | 3 | 4 | 5 |  |  |  | c | [NAME] | 2.4 |  |  | 1 | 2 | 3 | 4 | 5
a | jf | lskjd |  |  | xklvj |  |  |  | e | lskdjf | 4 |  | a
b | lkwkne | [NAME] |  |  |  |  |  |  | a | jf | 0.6 |  | b
c |  | xvlkcj | [NAME] | qrwklr | xkjv |  |  |  | b | [NAME] | 1.2 |  | c
d |  |  |  |  |  |  |  |  | c | xkjv | 4.1 |  | d
e | lvxczjk |  | nskl |  | lskdjf |  |  |  | g | do | 4 |  | e
f |  |  |  |  | werlmk |  |  |  | c | qrwklr | 3.2 |  | f
g |  | lj |  |  | do |  |  |  | e | nskl | 2.2 |  | g
 |  |  |  |  |  |  |  |  | a | xklvj | 4
What I want to do is to display the yellow array according to the green array. |  |  |  |  |  |  |  |  | b | lkwkne | 0.5
The organization is based on the number in column L and the letter in column J |  |  |  |  |  |  |  |  | c | xvlkcj | 1.5 |  | The above uses ARRAY formulas.  You will need to enter the formulas needing
In the green array, the letters from column K are displayed organized according to |  |  |  |  |  |  |  |  | f | werlmk | 4.3 |  | Control+Shift+Enter (CSE) formula
the correct letter in column A and the correct number in row 2 |  |  |  |  |  |  |  |  | e | lvxczjk | 0.1
The numbers are organized as follows: If a number from column L is lower than the |  |  |  |  |  |  |  |  | g | lj | 1
number from row 2 it is organized in under the highest number of row 2
Sorry for the vague explanation
Spreadsheet: 810394d1671732092-extract-all-cell-data-before-the-last-number-digit-extractexample
Sheet: Sheet1

INPUT | REQUIRED OUTPUT
NM030RDL | NMO30 | NM030 | write in cell+Ctrl+E
NM019LNL | NMO19 | NM019
NM042BLALNL | NMO42 | NM042
NM035BLAL | NMO35 | NM035
NM036BLAL | NMO36 | NM036
NM035GLDL | NMO35 | NM035
Spreadsheet: mary_fischer__25611__32E-2001
Sheet: E4.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032E
COMPANY NAME    Enron Building Services, Invest Co
ANALYSIS OF MERCHANT AND OTHER INVESTMENTS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-4
 |  | 12-31-2000 Balance |  | Cash Activity |  |  |  |  |  | Income Statement Activity |  |  |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Received - |  | Return of Principal |  | Cash Paid - |  | Realized Gain/(loss) |  | [NAME]) |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | Proceeds  (CR.) |  | (CR.) |  | Additions  DR. |  | DR. / (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Merchant Investment - Non Current:
 |  | 0
Total  (Hyperion Line 0269)
Asset/Expense Accts:  DR/(CR)
Total Notes Receivable - Non Current:
 |  | 0
Total  (Hyperion Line 0270)
Asset/Expense Accts:  DR/(CR)
Total Other Investments:
 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total  (Hyperion line 0280)
Asset/Expense Accts:  DR/(CR)
Hyperion lines 0269 and 0280 are the only accounts needed to prepare this schedule.
Spreadsheet: 01163a9b-850b-44c9-92e1-b85f2865801c
Sheet: Sheet1

Table 5--USDA-calculated world market rice prices (rough basis) 1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | 2012/13 |  |  | 2011/12 |  |  | 2010/11
 |  | Medium/ |  |  | Medium/ |  |  | Medium/
Month | Long | short |  | Long | short |  | Long | short
 | $/cwt
August | 11.91 | 12.13 |  | 14.08 | 14.4 |  | 9.58 | 9.68
September | 12.57 | 12.81 |  | 15.09 | 15.44 |  | 10.51 | 10.62
October 2/ | 12.68 | 12.93 |  | 15.63 | 15.99 |  | 12.15 | 12.29
November |  |  |  | 14.93 | 15.28 |  | 13.4 | 13.58
December |  |  |  | 13.9 | 14.21 |  | 14.5 | 14.67
January |  |  |  | 12.61 | 12.88 |  | 13.98 | 14.15
February |  |  |  | 11.81 | 12.2 |  | 12.68 | 13.35
March |  |  |  | 11.52 | 11.92 |  | 12.13 | 12.76
April |  |  |  | 11.15 | 11.54 |  | 11.76 | 12.36
May |  |  |  | 11.42 | 11.82 |  | 11.58 | 12.17
June |  |  |  | 11.93 | 12.35 |  | 11.78 | 12.39
July |  |  |  | 11.97 | 12.4 |  | 12.49 | 13.14
Market-year
average 1/ | 12.38666666666666 | 12.62333333333333 |  | 13.00333333333334 | 13.36916666666666 |  | 12.21166666666667 | 12.59666666666666
1/ Simple average of the U.S. Department of Agriculture's weekly adjusted world market price.  2/  Preliminary.
Source: [NAME] and Rice Weekly Prices (ftp://ftp.fsa.usda.gov/public/cotton/default.htm), Farm Service Agency, USDA.
Last updated October 11, 2012.
Spreadsheet: 798579d1664558231-sumproduct-arrays-different-size-match1
Sheet: match-2arrays

UNMATCH |  | (check existing grades) |  | =SUMPRODUCT((1*ISNA(MATCH(A4&A5:A1000,E5:E10&F5:F10,0))=1)*(A5:A1000<>"")*1) |  |  |  |  |  |  |  | case-unsensitive
 | ? |  |  |  |  |  |  |  |  |  |  | case-sensitive
grade | location |  |  | type | grade
A | US |  |  | location | MX
A | DE |  |  | grade | A
B | MX |  |  | grade | B
C | US |  |  | location | US
D | DE |  |  | location | NL
a | MX |  |  | grade | C
F | US
A | DE
A | MX
B | FR
B | DE
D | MX
A | FR
B | US
Spreadsheet: 267208d1380012832-vlookup-function-0a215_a
Sheet: Farmer, Luke

Farmer, [NAME]
Umpire | Player | Team | Position | Votes | Team Margin | K | H | D | CP | UP | DE% | CLG | M | CM | M50 | HO | CLR | CC | ST | R50 | FF | FA | T | 0.01 | Bo | [NAME] | G | B | GA | G% | TG% | DT
Spreadsheet: 30109d1225410079-updating-database-and-chart-book1
Sheet: Sheet1

 |  |  | November 2008
Supervisor | Department | Employee | Previous Total | Acceptable | Unacceptable | New Total
[NAME] | East Cost | [NAME] | 38 | 5 |  | 43
 |  | [NAME] | 47 | 1 | 8 | 40
 |  | [NAME] | 24 | 4 | 2 | 26
Total for [NAME] |  |  | 109 | 10 | 10 | 109
Doug | West Coast | [NAME] | 15 | 7 | 7 | 15
 |  | [NAME] | 18 |  | 12 | 6
 |  | [NAME] | 19 | 7 | 1 | 25
Total for Doug |  |  | 52 | 14 | 20 | 46
[NAME] | East Cost | [NAME] | 35 | 4 |  | 39
 |  | [NAME] | 40 | 8 | 4 | 44
 |  | [NAME] | 48 | 2 | 1 | 49
Total for Bob 2 |  |  | 123 | 14 | 5 | 132
[NAME] | West Coast | [NAME] | 13 |  | 4 | 9
 |  | [NAME] | 10 | 16 | 3 | 23
 |  | [NAME] | 8 | 18 |  | 26
Total for Doug 2 |  |  | 31 | 34 | 7 | 58
TOTALS |  |  | 315 | 72 | 42 | 345
Spreadsheet: 138075d1327507265-quick-question-multi-condition-arrays-example
Sheet: Sheet1

10 | Pippo |  | Pluto |  | Sum items in column A if column B is different from all the items in column D
20 | Pluto |  | [NAME]
10 | [NAME] |  | Ciao
20 | Ciao |  | [NAME]
10 | [NAME]
20 | [NAME]
10 | Topolino
20 | Minni
10 | Asd
20 | Lol
12 | Cane
4 | Gatto
10 | Topolino
20 | Marmotta
12 | Asd
4 | Lol
10 | Cane
20 | Gatto
12 | [NAME]
10 | Ciao
10 | [NAME]
10 | [NAME]
20 | Topolino
12 | Minni
4 | Asd
Spreadsheet: 238985d1369776787-4-digit-code-for-similar-product-new-product-unique-code-unclejemima-example-spencer101-2
Sheet: Sheet1

HIDE THESE COLUMNS |  |  | Product | Colour | Product #
 | 1 |  | Apple | Red
 |  |  | Apple | Red
 |  |  | Apple | Green
 |  |  | Orange | Orange
 |  |  | Orange | Red
 |  |  | [NAME] | Yellow
 |  |  | Apple | Blue
 |  |  | Pear | [NAME]
 |  |  | Pear | Blue
 |  |  | Orange | Orange
 |  |  | Cherries | Black
 |  |  | Tomato | Green
 |  |  | [NAME] | Yellow
 |  |  | [NAME] | Green
 |  |  | [NAME] | White
 |  |  | Apple | Red
 |  |  | [NAME] | White
Spreadsheet: 91055d1290731152-frequency-ranking-function-frequency
Sheet: Sheet2

numbers | unique | frequency
4567 | 4567 | 1
2345 | 2345 | 5
6443 | 6443 | 1
2256 | 2256 | 3
2251 | 2251 | 6
2251 | 3351 | 3
2345 | 4463 | 2
3351 | 5454 | 2
4463 | 4556 | 1
5454 | 6543 | 1
4463 |  | 0
2256 |  | 0
2251 |  | 0
2251 |  | 0
4556 |  | 0
3351 |  | 0
6543 |  | 0
5454 |  | 0
2345 |  | 0
2256 |  | 0
2251 |  | 0
2251 |  | 0
2345 |  | 0
3351 |  | 0
2345 |  | 0
Spreadsheet: 700613d1603265961-find-text-from-multiple-cells-find-text-from-multiple-cells
Sheet: Sheet1

False |  | False |  | True | A1/2 | False |  | False | True | A1/2
True | B1/2,3 | False |  | False |  | False |  | False | True | B1/2,3
False |  | False |  | False |  | False |  | False | False
False |  | False |  | False |  | True | B1/3 | False | True | B1/3
Spreadsheet: 702470d1604371156-index-match-2-criteria-and-return-all-matching-data-match-data
Sheet: Form

 |  |  | Name |  |  | Customer Name
Account # | 1970001655
case#(s) | 910345468 |  | NA Balance | PA Balance | [NAME] | [NAME] | UP Balance | UD Balance | IV Balance | ME Balance | Code | Desc
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SF | SERVICE FEES
 |  |  | 1400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FF | FUEL COSTS
Spreadsheet: 672406d1586864058-adding-from-1-row-to-another-when-criteria-is-met-apples2
Sheet: Sheet1

 | County |  |  | Fruit |  |  |  |  | now |  | Stock
 | Dublin |  |  | apples |  |  |  |  | 1 |  | 0
 | Cork |  |  | oranges |  |  |  |  | 1 |  | 1
 | Limerick |  |  | pear |  |  |  |  | 1 |  | 1
 | Galway |  |  | banana |  |  |  |  | 0 |  | 0
 | Kerry |  |  | kiwi |  |  |  |  | 1 |  | 1
 | Dublin |  |  | apples |  |  |  |  | 0 |  | 1
 | Cork |  |  | oranges |  |  |  |  | 0 |  | 1
 | Limerick |  |  | pear |  |  |  |  | 1 |  | 2
 | Galway |  |  | banana |  |  |  |  | 1 |  | 1
 | Kerry |  |  | kiwi |  |  |  |  | 1 |  | 2
 | dublin |  |  | Pear |  |  |  |  | 1 |  | 1
 | Cork |  |  | apples |  |  |  |  | 0 |  | 0
 | Limerick |  |  | apples |  |  |  |  | 1 |  | 1
 | Limerick |  |  | apples |  |  |  |  | 1 |  | 2
 |  | Everytime dublin Column "B" has an "apple" and has a number 1 column  "J" it adds in column "L" as so does a "Pear" for Limerick if "J" has a one for Limerick then it adds it to "L"so stock is always accumulating  from this example in stock for apples in dublin is 1 and stock for apples in Limerick is 2 - pears in Limerick is 2 this goes from row to row as example when criteria for "b"+"e"+"j" is met exspected result in "L"
 |  | All colums are set as they are in the intended workbook
Spreadsheet: 854150d1704122589-create-spread-for-actual-values-against-planned-plan-vs-actual-distribution-excelforum-windknife-4-
Sheet: Sheet1

Activity | Company | Month | Plan | Actual
Activity 1 | ABC | 2023-01-01 00:00:00 | 100 | 200 |  |  |  | /Actual | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Activity 2 | ABC | 2023-01-01 00:00:00 | 100 | 60 |  |  | 2023-01-01 00:00:00 | 400 | 310 | 190 | 0
Activity 1 | DEF | 2023-01-01 00:00:00 | 200 | 50 |  |  | 2023-02-01 00:00:00 | 300 | 0 | 200 | 0
Activity 1 | ABC | 2023-02-01 00:00:00 | 200 | 150 |  |  | 2023-03-01 00:00:00 | 50 | 0 | 0 | 300
Activity 1 | ABC | 2023-03-01 00:00:00 | 50 | 300
Activity 1 | DEF | 2023-02-01 00:00:00 | 50 | 150
Activity 2 | ABC | 2023-02-01 00:00:00 | 50 | 90
Plan/Actual |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 |  |  | Plan | /Actual | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
2023-01-01 00:00:00 | 400 | 310 | 190 |  |  |  | 2023-01-01 00:00:00 | 400 | 310 | 190
2023-02-01 00:00:00 | 300 |  | 200 | 50 |  |  | 2023-02-01 00:00:00 | 300 |  | 200 | 50
2023-03-01 00:00:00 | 50 |  |  | 250 |  |  | 2023-03-01 00:00:00 | 50 |  |  | 250
[NAME] for January
Activity | Company | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 |  |  |  | /Actual | 44927 | 44958 | 44986
Activity 1 | ABC | 200 |  |  |  |  | 44927 | 400 | 310 | 90 | 0
Activity 2 | ABC | 60 | 40 |  |  |  | 44958 | 300 | 0 | 300 | 0
Activity 1 | DEF | 50 | 150 |  |  |  | 44986 | 50 | 0 | 0 | 300
[NAME] for February
Activity | Company | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Activity 1 | ABC |  | 150 | 50
Activity 2 | ABC |  | 50
Activity 1 | DEF
[NAME] for March
Activity | Company | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Activity 1 | ABC |  |  | 250
Spreadsheet: 149636d1334066231-help-with-converting-huge-amounts-of-half-hourly-data-to-monthly-averages-sample
Sheet: Sheet1

DateTime | Date | Month | Hour | Year | Rg0 | Rg1 | Rg2 | Ta1 | Ta2 | RH | WindSpeed | Precip | NPP | Resp | GPP
2004-11-19 09:45:00 | 2004-11-19 00:00:00 | 11 | 9 | 2004 | 151.1 | 151.1 | 151.1 | -1.864 | -1.864 | 73.9 | 3.75088 | 0 | -5.28313 | 0.067535 | 5.35066
2004-11-19 10:15:00 | 2004-11-19 00:00:00 | 11 | 10 | 2004 | 190.5 | 190.5 | 190.5 | -1.545 | -1.545 | 72.1 | 3.31026 | 0 | -6.25417 | 0.0770645 | 6.33124
2004-11-19 10:45:00 | 2004-11-19 00:00:00 | 11 | 10 | 2004 | 249.6 | 249.6 | 249.6 | -1.047 | -1.047 | 69.56 | 3.10033 | 0.796 | -7.16574 | 0.09425 | 7.25999
2004-11-19 11:15:00 | 2004-11-19 00:00:00 | 11 | 11 | 2004 | 267.9 | 267.9 | 267.9 | -0.698 | -0.698 | 67.69 | 3.58271 | 0 | -7.41719 | 0.108159 | 7.52535
2004-11-19 11:45:00 | 2004-11-19 00:00:00 | 11 | 11 | 2004 | 279.6 | 279.6 | 279.6 | -0.441 | -0.441 | 66.11 | 3.78287 | 0.199 | -7.56367 | 0.119483 | 7.68316
2004-11-19 12:15:00 | 2004-11-19 00:00:00 | 11 | 12 | 2004 | 215.2 | 215.2 | 215.2 | -0.189 | -0.189 | 63.51 | 3.94004 | 1.194 | -6.90279 | 0.131542 | 7.03433
2004-11-19 12:45:00 | 2004-11-19 00:00:00 | 11 | 12 | 2004 | 242.4 | 242.4 | 242.4 | -0.03 | -0.03 | 63.64 | 4.14689 | 0 | -7.24589 | 0.139666 | 7.38556
2004-11-19 13:15:00 | 2004-11-19 00:00:00 | 11 | 13 | 2004 | 245 | 245 | 245 | 0.066 | 0.066 | 60.25 | 4.65803 | 0 | -7.21041 | 0.144773 | 7.35518
2004-11-19 13:45:00 | 2004-11-19 00:00:00 | 11 | 13 | 2004 | 99.5 | 99.5 | 99.5 | -0.385 | -0.385 | 60.48 | 4.25346 | 0 | -4.435 | 0.12209 | 4.55709
2004-11-19 14:15:00 | 2004-11-19 00:00:00 | 11 | 14 | 2004 | 91.8 | 91.8 | 91.8 | -0.658 | -0.658 | 62.94 | 4.27017 | 0 | -4.16219 | 0.109875 | 4.27207
2004-11-19 14:45:00 | 2004-11-19 00:00:00 | 11 | 14 | 2004 | 68.68 | 68.68 | 68.68 | -1.047 | -1.047 | 66.12 | 3.63765 | 0 | -3.32883 | 0.0942686 | 3.4231
2004-11-19 15:15:00 | 2004-11-19 00:00:00 | 11 | 15 | 2004 | 41.87 | 41.87 | 41.87 | -1.218 | -1.218 | 67.97 | 3.737 | 0 | -2.15568 | 0.0880326 | 2.24372
2004-11-19 15:45:00 | 2004-11-19 00:00:00 | 11 | 15 | 2004 | 18.52 | 18.52 | 18.52 | -1.437 | -1.437 | 68.74 | 4.63092 | 0 | -0.860361 | 0.0805644 | 0.940925
Spreadsheet: 222535d1363877236-perhaps-conditional-formatting-tabs-sample-resourcing
Sheet: PM

MONTH | 2013 Actual - RFA | 2013 Actual - EHP | 2013 Actual - EHSQ | 2013 Actual - WHP | Total Days Available
December |  |  |  |  | 22
November |  |  |  |  | 21
October |  |  |  |  | 23
September |  |  |  |  | 21
August |  |  |  |  | 22
July |  |  |  |  | 23
June |  |  |  |  | 20
May |  |  |  |  | 23
April |  |  |  |  | 22
March |  |  |  |  | 21
February | 28 | 17 | 11 |  | 25
January | 36.5 | 39 | 18 | 0.5 | 55
MONTH | 2013 Forecast - RFA | 2013 Forecast - EHP | 2013 Forecast - EHSQ | 2013 Forecast - WHP | Total Days Available
December |  | 35 | 20 |  | 22
November |  | 35 | 20 |  | 21
October | 20 | 35 | 20 |  | 23
September | 20 | 35 | 20 |  | 21
August | 20 | 35 | 20 |  | 22
July | 20 | 40 | 20 |  | 23
June | 20 | 40 |  |  | 20
May | 20 | 40 |  |  | 23
April | 20 | 35 |  |  | 22
March | 10 | 37 |  |  | 21
February |  |  |  |  | 25
January |  |  |  |  | 54.81
MONTH | 2013 Combined - RFA | 2013 Combined - EHP | 2013 Combined - EHSQ | 2013 Combined - WHP | Total Days Available
December |  |  |  |  | 22
November |  |  |  |  | 21
October |  |  |  |  | 23
September |  |  |  |  | 21
August |  |  |  |  | 22
July |  |  |  |  | 23
June |  |  |  |  | 20
May |  |  |  |  | 23
April |  |  |  |  | 22
March |  |  |  |  | 21
February |  |  |  |  | 25
January |  |  |  |  | 54.81
Spreadsheet: 433da04d-0498-4ace-bb62-fcfd8bfba552
Sheet: INDICACIONES

 | INSTRUCCIONES PARA DILIGENCIAR EL FORMATO
 | TODOS LOS CAMPOS DEBEN SER DILIGENCIADOS OBLIGATORIAMENTE
1 | SELECCIONAR EN LA PARTE DE ABAJO LA HOJA PLANTA
2 | INGRESAR EL NUMERO DE CEDULA, EL [NAME] AUTOMATICAMENTE EL NOMBRE DEL FUNCIONARIO
NOTA | SI SE LLEGA A INGRESAR EL NUMERO DE CEDULA Y NO SE CARGA EL NOMBRE VERIFIQUE HABER INGRESADO CORRECTAMENTE EL NUMERO DE CEDULA (EL ARCHIVO CUENTA CON LA
 | BASE DE DATOS ACTUALIZADA DE LOS FUNCIONARIOS QUE HACEN PARTE DE LA SECRETARIA DE EDUCACION DE Bolívar).
3 | SELECCIONAR LA COLUMNA DE CARGO HACER CLICK EN EL BOTON (COMO LO INDICA LA IMAGEN), Y SELECCIONAR EL CARGO DEL FUNCIONARIO
4 | SELECCIONAR LA COLUMNA DEL MUNICIPIO HACER CLICK EN EL BOTON Y SELECCIONAR EL MUNICIPIO DE LA I.E.
NOTA | CUANDO SELECCIONA EL MUNICIPIO EN LA COLUMNA DE LA I.E., SE CARGAN LAS I.E. QUE [NAME] SELECCIONADO ANTERIORMENTE
5 | SELECCIONAR LA INSTITUCION EDUCATIVA
NOTA | CUANDO SELECCIONA LA I.E. EN LA SIGUIENTE  COLUMNA SE CARGAN LAS SEDES QUE TIENE LA INSTITUCION EDUCATIVA
6 | SELECCIONAR LA SEDE DE LA I.E.
7 | SELECCIONAR EL AREA QUE DICTA
8 | SELECCIONAR EL NIVEL QUE DICTA
9 | EN OBSERVACIONES REDACTAR BREVEMENTE ALGUN COMENTARIO (SI ES NECESARIO)
 | ACLARACION
 | LAS INSTITUCIONES Y LAS SEDES QUE SE ENCUENTRAN CARGADAS EN EL ARCHIVO, ESTA BASADO EN EL DIRECTORIO UNICO DE ESTABLECIMIENTOS (DUE) DE 2011,
 | SI SU INSTITUCION Y/O SEDE NO LLEGA APARECER, [NAME] LOS 2 CAMPOS QUE SE ENCUENTRAN DESPUES DE LA COLUMNA DE
 | OBSERVACIONES.
 | EN CASO DE ALGUNA DUDA ESCRIBIR AL CORREO: [EMAIL]
Spreadsheet: 680574d1591096448-time-conversion-with-daylight-savings-time-example-1
Sheet: Sheet1

 |  |  |  |  | Time (LOCAL) | Time (UTC/ZULU) |  | Time (LOCAL) | Time (UTC/ZULU) |  |  |  |  |  |  | YEAR | START | END
 |  |  |  |  | 1100 |  |  |  | 1600 |  |  |  |  |  |  | 2020 | March 8 | November 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021 | March 14 | November 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022 | March 13 | November 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023 | March 12 | November 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024 | March 10 | November 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025 | March 9 | November 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2026 | March 8 | November 1
Spreadsheet: 195090d1353420042-how-to-count-cell-values-based-on-2-conditions-example_excel_help
Sheet: Irvine

Shift Start | Shift End | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Date Shift Vacated |  |  | Shift Start | Shift End | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Date Shift Vacated |  |  | Shift Start | Shift End | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Date Shift Vacated
11:30:00 | 20:15:00 | 1 | 1 | 1 | 1 | 1 |  |  | 2012-08-16 00:00:00 |  |  | 12:15:00 | 21:15:00 |  | 1 | 1 | 1 | 1 |  | 1 | 2012-08-28 00:00:00 |  |  | 12:15:00 | 21:15:00 |  |  | 1 | 1 | 1 | 1 | 1 | 2012-08-18 00:00:00
12:15:00 | 21:15:00 |  |  | 1 | 1 | 1 | 1 | 1 | 2012-08-12 00:00:00
12:15:00 | 21:15:00 | 1 | 1 | 1 |  |  |  | 1 | 2012-08-29 00:00:00
12:00:00 | 21:00:00 |  | 1 | 1 | 1 | 1 | 1 |  | 2012-08-28 00:00:00
14:00:00 | 23:00:00 |  |  | 1 | 1 | 1 | 1 | 1 | 2012-08-30 00:00:00