tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 35684d1233264087-accruals-formula-help-explanation-of-awesomeness
Sheet: Sheet1

 |  | 2009-01-01 00:00:00 |  |  |  |  |  | 2009-02-01 00:00:00 |  |  |  | 2009-01-01 00:00:00
 |  | Bal. Forward | Accrued | Used | Remaining |  |  | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining
Employee | Hire Date
[NAME] | 2007-12-15 00:00:00 |  | 19.92 |  | 19.92 |  |  | 19.92 | 19.92 |  | 39.84 | 39.84 | 19.92 |  | 59.75999999999999
[NAME] | 2006-06-17 00:00:00 |  | 19.92 |  | 19.92 |  |  | 19.92 | 19.92 |  | 39.84 | 39.84 | 19.92 |  | 59.75999999999999
[NAME] | 2005-03-01 00:00:00 |  | 30 |  | 30 |  |  | 30 | 30 |  | 60 | 60 | 30 |  | 90
 |  |  |  |  | Manual Entry
 |  | cat!
 |  |  |  |  |  |  |  |  |  |  | Remaining Col.' should automate in 'Bal Forward Col.'
 |  |  |  |  |  |  |  |  |  |  | Remaining Col.' = sum [NAME]. Forward + Accrued - used
mew!----- |  |  |  |  | This table is used to reference the appropriate number by # of months
 |  |  |  | 0 | 0.83
 |  |  |  | 37 | 1.25
 |  |  |  | 61 | 1.67 |  |  |  | Please read through the following cells, they contain the formulas used to build
 |  |  |  |  |  |  |  |  | the formula you now see functioning in your worksheet!
 |  |  |  |  |  |  |  |  | 36 | this takes the year value of each cell and subtracts them, then multiplies
 |  |  |  |  |  |  |  |  | + | by 12 to get a month difference value
 |  |  |  |  |  |  |  |  | -5 | this cell subtracts the months from eachother, this is added to j29
 |  |  |  |  |  |  |  |  | 31 | Here is the resulting # of months from employment, to date of column.
 |  |  |  |  |  |  |  |  | 0.83 | This is the great and powerful VLOOKUP function at its best. Here we're
 |  |  |  |  |  |  |  |  |  | looking in the range named "lookuprange". If you highlight cells
 |  |  |  |  |  |  |  |  |  | E25 to F27 (the ones next to the cat ) you'll see in the address bar,
 |  |  |  |  |  |  |  |  |  | the bar to the left of the formula bar, that it says "lookuprange". This
 |  |  |  |  |  |  |  |  |  | is now a named range, and you'll see it in the formula here. To see all
 |  |  |  |  |  |  |  |  |  | named ranges in a worksheet, go to formulas, and choose "Name Manager"
 |  |  |  |  |  |  |  |  | 19.92 | Lastly we're multiplying cell j33 by 24 to reflect an hour value, instead of
 |  |  |  |  |  |  |  |  |  | a decimal day representation
 |  |  |  |  |  |  |  |  | 19.92 | This is the same result, with the custom formatting I mentioned. I'm not
 |  |  |  |  |  |  |  |  |  | familiar with much custom formatting, so this is the best I could come
 |  |  |  |  |  |  |  |  |  | up with.
 |  |  |  |  |  |  |  |  | 19.92 | This is the formula in its entirety, if you'd like to check each part as you go.
 |  |  |  |  |  |  |  |  |  | Note that the cells above all work off of eachother, so you can see the
 |  |  |  |  |  |  |  |  |  | calculation steps involved. There may be an easier way to do this, but if
 |  |  |  |  |  |  |  |  |  | so, I don't know what it is :)
Spreadsheet: james_steffes__12981__Savings_Analysis
Sheet: DWR(MWhs)-Rep

 |  |  |  |  | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00
Net Short (MWh 000s) |  |  |  |  | 6064 | 4750 | 5589 | 6508 | 6868 | 5685 | 5081 | 5103 | 45649
Executed Contracts (MWh 000s) |  |  |  |  | 1592 | 1982 | 2145 | 2286 | 2209 | 2012 | 1884 | 1923 | 16032
AIP Contracts (MWh 000s) |  |  |  |  | 0 | 8 | 327 | 454 | 582 | 691 | 558 | 515 | 3134 | 19167
% of NS Met by Executed Contracts |  |  |  |  | 0.26 | 0.42 | 0.38 | 0.35 | 0.32 | 0.35 | 0.37 | 0.38 | 0.35
% of NS Met by AIP Contracts |  |  |  |  | 0 | 0 | 0.06 | 0.07 | 0.08 | 0.12 | 0.11 | 0.1 | 0.07
% of NS Met by Contracts |  |  |  |  | 0.26 | 0.42 | 0.44 | 0.42 | 0.41 | 0.48 | 0.48 | 0.48 | 0.42
 | 2002-01-02 00:00:00 | 2002-02-02 00:00:00 | 2002-03-02 00:00:00 | 2002-04-02 00:00:00 | 2002-05-02 00:00:00 | 2002-06-02 00:00:00 | 2002-07-02 00:00:00 | 2002-08-02 00:00:00 | 2002-09-02 00:00:00 | 2002-10-02 00:00:00 | 2002-11-02 00:00:00 | 2002-12-02 00:00:00
Net Short (MWh 000s) | 5395 | 5226 | 4847 | 5085 | 5799 | 5240 | 6554 | 7257 | 7537 | 6651 | 5980 | 5700 | 71272
Executed Contracts (MWh 000s) | 1985 | 1782 | 1916 | 2092 | 2166 | 2380 | 3285 | 3304 | 3149 | 3228 | 2813 | 2883 | 30984
AIP Contracts (MWh 000s) | 988 | 904 | 1006 | 1109 | 1351 | 1013 | 1265 | 1457 | 1387 | 1376 | 1298 | 1075 | 14229
 | 2973 | 2686 | 2922 | 3201 | 3517 | 3394 | 4550 | 4761 | 4536 | 4604 | 4111 | 3958 | 45213 | 45213
% of NS Met by Executed Contracts | 0.37 | 0.34 | 0.4 | 0.41 | 0.37 | 0.45 | 0.5 | 0.46 | 0.42 | 0.49 | 0.47 | 0.51 | 0.43
% of NS Met by AIP Contracts | 0.18 | 0.17 | 0.21 | 0.22 | 0.23 | 0.19 | 0.19 | 0.2 | 0.18 | 0.21 | 0.22 | 0.19 | 0.2
% of NS Met by Contracts | 0.55 | 0.51 | 0.6 | 0.63 | 0.61 | 0.65 | 0.69 | 0.66 | 0.6 | 0.69 | 0.69 | 0.69 | 0.63
 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
Net Short (MWh 000s) | 79 | 88 | 91 | 96 | 101 | 107 | 110 | 114
Executed Contracts (MWh 000s) | 48 | 64 | 61 | 62 | 62 | 62 | 62 | 61
AIP Contracts (MWh 000s) | 20 | 23 | 22 | 22 | 19 | 19 | 19 | 19
 | 68 | 87 | 83 | 84 | 81 | 81 | 81 | 80
% of NS Met by Executed Contracts | 0.62 | 0.73 | 0.67 | 0.65 | 0.61 | 0.58 | 0.56 | 0.53
% of NS Met by AIP Contracts | 0.25 | 0.27 | 0.24 | 0.23 | 0.18 | 0.18 | 0.17 | 0.16
% of NS Met by Contracts | 0.87 | 0.99 | 0.91 | 0.87 | 0.8 | 0.75 | 0.73 | 0.7
* Net short is energy requirements before effects of funded programmatic load management and load curtailment.
AIP - Agreement in Principle
Spreadsheet: 697631d1601455698-count-down-from-the-maximum-number-in-each-consecutive-count-herethereeverywhere
Sheet: Sheet1

 | here | there | everywhere
here
here
here
everywhere
here
here
there
there
there
here
there
there
there
everywhere
here
here
there
here
there
there
here
everywhere
here
here
there
there
there
here
there
there
everywhere
here
here
there
here
there
there
here
everywhere
here
here
there
there
there
here
here
here
everywhere
here
here
there
there
there
here
there
there
there
there
there
there
there
there
there
there
there
there
 | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
here
there
everywhere
Spreadsheet: 701424d1603754951-vlookup-not-returning-desired-value-from-another-sheet-based-on-multiple-criteria-client-outreach-individual-draft-michelle
Sheet: MGMT

 | DATE OF PURCHASE | CLIENT | ARTICLE | [NAME] | $ | THANK YOU | SA NOTES | RESULTS | 30 DAY FOLLOW UP | SA NOTES | RESULTS | 90 DAY FOLLOW UP | SA NOTES | RESULTS | 180 DAY FOLLOW UP | SA NOTES | RESULTS | BIRTHDAY | SA NOTES | RESULTS
 | 2020-10-22 00:00:00 | George | [NAME] | Notebooks |  |  |  | Will commit to POA, WE, GC |  |  |  |  | from SA file column D, IF COLUMN C="90 DAY FOLLOW UP" | from SA file column F, IF COLUMN C="90 DAY FOLLOW UP" |  | from SA file column D, if Column C="180 DAY FOLLOW UP" | from SA file column F, IF COLUMN C="180 DAY FOLLOW UP" |  | from SA file column D, IF COLUMN C="BIRTHDAY | from SA file column F, IF COLUMN C="BIRTHDAY"
 | 2020-10-23 00:00:00 | [NAME]
 | 2020-10-24 00:00:00 | [NAME]
 | 2020-10-25 00:00:00 | Mario
 | 2020-10-26 00:00:00 | Taiyu
 | I would populate the orange cells.
 | The red cells would automatically populate
 | The yellow cells would populate from the SA's sheet.
Spreadsheet: 877603d1724406409-function-like-if-function-needed-1-
Sheet: Sheet1

 | Grade 1 | [NAME] | [NAME] | [NAME]
 | 3 | 1 | 1 | 2 | 2
 | 3 | 3 | 3 | 3 | 3
 | 1 | 4 | 2 | 3 | 4
 | 1 | 1 | 4 | 3 | 4 | NEED this one to be 3 not 4 as average is 2.25
 | 1 | 3 | 3 | 2 | 2
 | 1 | 4 | 3 | 2 | 4
 | 4 | 3 | 3 | 4 | 4
 | 4 | 4 | 1 | 3 | 4
 | 2 | 3 | 1 | 1 | 2
 | 1 | 1 | 4 | 4 | 4
 | 1 | 3 | 1 | 4 | 4
 | 1 | 1 | 3 | 1 | 2
 | 1 | 1 | 1 | 3 | 2
 | 1 | 3 | 3 | 2 | 2
 | 1 | 4 | 4 | 2 | 4
 | 1 | 3 | 4 | 4 | 4
 | 3 | 1 | 1 | 4 | 4
 | 1 | 1 | 1 | 2 | 1
Spreadsheet: 143550d1330457833-splitting-text-in-a-cell-example
Sheet: Sheet1

ORIGINAL | Full Name | Full Address | Add minus Post | First Name | Last Name | Address 1 | Address 2 | Address 3 | City | Postcode
[NAME] 15 West Field Drive Leeds LS17 7PB | [NAME] | 15 West Field Drive Leeds LS17 7PB | 15 West Field Drive Leeds | [NAME] | Bloggs | 15 West Field Drive |  |  | Leeds | LS17 7PB
[NAME] West Field Drive Leeds LS10 6EN | [NAME] | Port House West Field Drive Leeds LS10 6EN | Port House West Field Drive Leeds | [NAME] | [NAME] | Port House West Field Drive |  |  | Leeds | LS10 6EN
[NAME] 78 Kings [NAME] WF17 8TN | [NAME] | 78 Kings [NAME] WF17 8TN | 78 Kings [NAME] | Sue | [NAME] | 78 [NAME] |  |  | Warrington | WF17 8TN
Clare Flowers Richmond House 15A Richmond Road Leeds LS12 8CE | Clare Flowers | Richmond House 15A Richmond Road Leeds LS12 8CE | Richmond House 15A Richmond Road Leeds | Clare | Flowers | Richmond House 15A Richmond Road |  |  | Leeds | [NAME]
Spreadsheet: 215899d1361533697-drop-down-queries-drop_down_form
Sheet: Sheet1

Sortation Request Form
Job Name |  |  |  |  | Job Reference
Carrier |  |  |  |  | Mail Item
Weight |  |  |  |  | Mailing Type
[NAME] |  |  |  |  | Sustainability
Collection Date |  |  |  |  | Sortation
Post Class |  |  |  |  | Postal Area
Data Sort File Name |  |  |  |  | Mail Presentation
TNT Specific
Mailing House Name |  |  |  |  | Processing  Depot
[NAME] |  |  |  |  | End-To-End Service?
Spreadsheet: 99995d1298490021-excel-2007-using-the-data-in-one-spreadsheet-to-fill-a-column-in-another-copy-of-modules
Sheet: Sheet1

Module Code | Tutor | Tutor ID
IDCT01 | [NAME]
IDSD02 | [NAME]
IDBO03 | [NAME]
IDBC04 | [NAME]
IDTSOPT1 | [NAME]
IDPGOPT2 | [NAME]
IDIMOPT3 | [NAME]
IDECOPT4 | [NAME]
[NAME] | [NAME]
Spreadsheet: tracy_geaccone__40530__ETS - Total IC 10-19
Sheet: Invoice

 | Enron Net Works
 | 1400 Smith Street
 | Houston, Texas 77002
 | Intercompany billing for 2002
 | Revised 10/21/2001
To: ETS
 | Accounting Contact: | [NAME]
 | Other Contact: | [NAME]
Description | Assessment Information | Amount
EXPENSE
EnronOnline | 2002 Assessments will be based on actuals | 416575.2085455581
IT Development | 2002 Assessments will be based on actuals
IT Infrastructure | 2002 Assessments will be plan with periodic true up
 | TOTAL ALLOCATED EXPENSE
IT Infrastructure - Controllable* | Will not be assessed.  Billed to and budgeted at cost center.
 | (For information purposes only)
Footnotes:
*Consistent with 2001, pass through billings (long distance, market data, WAN, etc.) will not be included in the
standard assessments ("8xxxxxxx" accounts).  They will be posted directly to direct expenses ("52502000" account)
at the cost center level.  This pass through number is only a high level place holder and is not intended to replace
the dollars already being budgeted for by each cost center owner.
Spreadsheet: 35163d1232689560-sorting-issues-off-season-09
Sheet: Spanish Pantalones

Batters |  | H/AB | R | HR | RBI | SB | BB | K | AVG | OBP | SLG | TLR
[NAME] | (Atl - C) | 153/509 | 68 | 23 | 87 | 5 | 57 | 64 | 0.301 | 0.373 | 0.523
Prince Fielder | (Mil - 1B) | 162/588 | 86 | 34 | 102 | 3 | 84 | 134 | 0.276 | 0.372 | 0.507
Robinson Canó | (NYY - 2B) | 162/597 | 70 | 14 | 72 | 2 | 26 | 65 | 0.271 | 0.305 | 0.41
[NAME] | (LAA - 3B,SS) | 30/150 | 12 | 5 | 13 | 4 | 4 | 43 | 0.2 | 0.224 | 0.327
[NAME] | (Bos - 3B,SS) | 67/260 | 34 | 2 | 46 | 1 | 35 | 68 | 0.258 | 0.339 | 0.4
[NAME] | (Cle - OF) | 170/634 | 101 | 33 | 90 | 38 | 98 | 130 | 0.268 | 0.374 | 0.502
[NAME] | (Ari - 1B,OF) | 122/517 | 79 | 40 | 100 | 2 | 122 | 164 | 0.236 | 0.386 | 0.513
[NAME] | (Phi - OF) | 114/418 | 73 | 24 | 67 | 20 | 57 | 119 | 0.273 | 0.363 | 0.498
[NAME] | (Col - 2B,3B) | 69/266 | 33 | 10 | 41 | 1 | 30 | 94 | 0.259 | 0.349 | 0.455
[NAME] | ([NAME]) | 84/295 | 51 | 17 | 55 | 1 | 20 | 88 | 0.285 | 0.331 | 0.549
Edwin Encarnación | (Cin - 3B) | 127/506 | 75 | 26 | 68 | 1 | 61 | 102 | 0.251 | 0.34 | 0.466
Justin Upton | (Ari - OF) | 89/356 | 52 | 15 | 42 | 1 | 54 | 121 | 0.25 | 0.353 | 0.463
[NAME] | (CWS - OF) | 138/480 | 96 | 36 | 100 | 7 | 66 | 80 | 0.287 | 0.394 | 0.571
Pitchers |  | IP | W | L | SV | BB | K | HLD | ERA | WHIP | K/9 | TLR
[NAME] | (Col - SP,RP) | 66.1 | 6 | 6 | 1 | 18 | 56 | 21 | 2.17 | 0.95 | 7.6
[NAME] | (Phi - SP,RP) | 87.2 | 5 | 4 | 1 | 35 | 63 | 17 | 2.87 | 1.32 | 6.47
Félix Hernández | (Sea - SP) | 200.2 | 9 | 11 | 0 | 80 | 175 | 0 | 3.45 | 1.39 | 7.85
[NAME] | (LAD - SP,RP) | 200.2 | 16 | 10 | 0 | 80 | 201 | 1 | 3.14 | 1.34 | 9.01
[NAME] | (Tor - RP) | 58 | 2 | 4 | 32 | 28 | 58 | 1 | 2.95 | 1.28 | 9
[NAME] | (Det - RP) | 40.1 | 0 | 6 | 13 | 30 | 49 | 5 | 4.91 | 1.59 | 10.93
Eddie Guardado | (Min - RP) | 56.1 | 4 | 4 | 4 | 19 | 33 | 25 | 4.15 | 1.22 | 5.27
Octavio Dotel | (CWS - RP) | 67 | 4 | 4 | 1 | 29 | 92 | 21 | 3.76 | 1.21 | 12.36
[NAME] | (Fla - SP) | 212.1 | 15 | 8 | 0 | 42 | 186 | 0 | 3.52 | 1.1 | 7.88
Spreadsheet: 3ff066d5-4e1e-4518-9352-629d9c07e73b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8443 | 72731 | Ricardo | Marin [NAME] | ESP | 41 | 00:13:58 | 00:03:09 | 00:35:23 | 00:02:16 | 00:28:23 | 1 | 01:23:07
8443 | 7966 | [NAME] | Peiffer | FRA | 42 | 00:12:48 | 00:02:39 | 00:38:38 | 00:01:17 | 00:32:30 | 2 | 01:27:50
Spreadsheet: 724795d1616394474-sumifs-with-multiple-criteria-and-multiple-30-ranges-check-test
Sheet: Check

ID Code | &ANN | &PER | &CAR | &COM, &MIL, &DOM, &CORT |  | < Code to summarise in column by ID
469
2708
2786
3180
3387
4455
4840
5000
5110
6958
7502
9922
 | Individual Code | Individual Code | Individual Code | Combined Codes
 |  |  |  | 4 codes combined =formula 4 times as long.
 | expected value
 | 7.6 | 7.6 | 0 | 0
 | 0 | 0 | 0 | 9.6
 | 7.6 | 0 | 0 | 0
 | 0 | 0 | 7 | 0
 | 7.6 | 0 | 0 | 0
 | 0 | 7 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 5
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
Spreadsheet: 87812d1287670702-collating-different-series-to-one-time-series-tempdatepvt
Sheet: Sheet1

Date 1 | Temp 1 | Date 2 | Temp 2
2000-05-31 00:00:00 | 15.7
2000-06-30 00:00:00 | 12.8
2000-07-28 00:00:00 | 16.5
2000-08-31 00:00:00 | 13.3
2000-09-30 00:00:00 | 14.1 |  |  | Sum of Temp 1
2000-10-30 00:00:00 | 11.9 |  |  | Date 1 | Total
2000-11-30 00:00:00 | 12.2 |  |  | 3-Jan | 11.3
2001-01-03 00:00:00 | 11.3 |  |  | 28-Apr | 14.5
2000-04-28 00:00:00 | 14.5 |  |  | 31-May | 28.6
2000-05-31 00:00:00 | 12.9 |  |  | 30-Jun | 26.8
2000-06-30 00:00:00 | 14 |  |  | 28-Jul | 30.4
2000-07-28 00:00:00 | 13.9 |  |  | 31-Aug | 26.9
2000-08-31 00:00:00 | 13.6 |  |  | 30-Sep | 26.1
2000-09-30 00:00:00 | 12 |  |  | 30-Oct | 24.2
2000-10-30 00:00:00 | 12.3 |  |  | 30-Nov | 23.2
2000-11-30 00:00:00 | 11 |  |  | Grand Total | 212
Spreadsheet: 110507d1307130869-pivot-tables-pivot-table
Sheet: data

Division | Category # | Cost | Company A | Company B | Company C
Division 3 | 300 | Initial Amount | 20 | 8 | 30
Division 3 | 300 | Additional Amount | 50 | 10 | 15
Division 4 | 400 | Initial Amount | 10 | 35 | 60
Division 4 | 400 | Additional Amount | 5 | 18 | 75
Spreadsheet: 1f9a49dc-4a07-4711-910a-992a9ad34fe4
Sheet: Sheet1

Értékpapír | CF Dáum | [NAME] | [NAME] esemény | [NAME] mennyisége | Kamat esemény | Kamat | Kamat mennyisége | Kamat fizetés | Kamat nem fizetés
A170305I12 | 2012-03-05 00:00:00 | 1000 | Igen | -1000 | Nem | 0 | 0 | 0 | 0
A170305I12 | 2013-03-05 00:00:00 | 1000 | Nem | 0 | Igen | 9.5 | 95 | 95 | 0
A170305I12 | 2014-03-05 00:00:00 | 1000 | Nem | 0 | Igen | 7.7 | 77 | 77 | 0
A170305I12 | 2015-03-05 00:00:00 | 1000 | Nem | 0 | Igen | 4 | 40 | 40 | 0
A170305I12 | 2016-03-05 00:00:00 | 1000 | Nem | 0 | Igen | 0 | 0 | 0 | 0
A170305I12 | 2017-03-05 00:00:00 | 0 | Igen | 1000 | Igen | 0 | 0 | 0 | 0
Spreadsheet: 105915d1303197012-displaying-values-based-on-calculated-date-educational-hours2
Sheet: Sheet1

Hours/Educator by Month | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun
User 1 | 20.75 | 16.3 | 20 | 12.8 | 6.049999999999999 | 17.95 | 12.85 | 20.25 | 0 | 0 | 0 | 0
User 2 | 20.1 | 74.3 | 60.2 | 18.15 | 6.95 | 13.6 | 16.35 | 13.35 | 16.6 | 6.3 | 0 | 0
User 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 6 | 20.1 | 74.3 | 60.2 | 18.15 | 6.95 | 13.6 | 16.35 | 13.35 | 16.6 | 6.3 | 0 | 0
User 7 | 21.5 | 16 | 16 | 16 | 16 | 7 | 14 | 0 | 0 | 0 | 0 | 0
User 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 10 | 0 | 0 | 0 | 0 | 65 | 16.25 | 87.75 | 0 | 0 | 0 | 0 | 0
User 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
User 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total | 82.45 | 180.9 | 156.4 | 65.10000000000001 | 100.95 | 68.4 | 147.3 | 46.95 | 33.2 | 12.6 | 0 | 0 |  | < conditional formating
Current Month | This |  | Or just
2011-04-19 00:00:00 | 12.6 |  | 12.6
Using Dynamic Named Table |  |  | Or just |  | Or
2011-04-19 00:00:00 | 12.6 |  | 12.6 |  | 12.6
Spreadsheet: 701482d1603792762-vlookup-for-multiple-criterias-explicativ
Sheet: database

 | today
 | nr of days in current month
 |  | curent month consumption/day | Curent month input | Next month input | initial stock
 | product 1
 | product 2
 | product 3
Spreadsheet: 59624d1260217146-excel-2007-checking-a-range-of-dates-with-if-or-select-case-example1
Sheet: TA2009-10

FLEXIBLE SCHEDULE CERTIFICATION FORM
NAME: |  |  |  |  |  |  |  |  |  |  |  | Established Hours:
 |  |  |  |  |  |  |  |  |  |  |  | M |  |  | M:
ORG: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  |  |  |  |  |  |  |  |  |  |  | W |  |  | W:
PP Ending: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  | PP | 09-10 |  |  |  |  |  |  |  |  | F: |  |  | F:
 |  | Working Hours |  | Time in Duty Status |  |  |  | *Telework Hours |  | Credit Hours |  |  | [NAME]
Date |  | Arrive | [NAME] | Regular | Overtime | Comp | Holiday | Worked | Code | Earned | Used | Balance | Annual | Sick | Comp | LWOP | Other | Remarks
Previous Balance
S
M
T
W
T
F
S
S
M
T
W
T
F
S
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL PAYABLE HRS.
Totals
 | Employee Signature: |  |  |  |  |  |  |  |  |  | Supervisor Signature:
 |  |  |  |  |  |  |  |  |  |  |  | *Telework Indicator Codes
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | "Fixed" Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | C | 3 or more days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | F | 2 or fewer days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | “As Needed” Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | I | Work performed at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | The Telework columns are to be left blank for those employees who did not work at an alternate worksite during the Pay Period.
MOST EMPLOYEES SHOULD HAVE NO BALANCE IN LWOP.
Spreadsheet: 778167d1650901008-calculating-difference-for-unique-references-sample-salary-change
Sheet: Sheet1

[NAME] | Salary | Month | %
1000 | 12000 | 2021-04-01 00:00:00
 | 12500 | 2022-04-01 00:00:00
 | 12700 | 2023-04-01 00:00:00
1001 | 10000 | 2021-04-01 00:00:00
 | 10100 | 2022-04-01 00:00:00
 | 10200 | 2023-04-01 00:00:00
1002 | 15000 | 2021-04-01 00:00:00
 | 15500 | 2022-04-01 00:00:00
 | 16000 | 2023-04-01 00:00:00
Spreadsheet: 76712d1277224761-calculating-the-combination-of-items-considering-item-statistics-733969-optimization
Sheet: Sheet1

 | Name | Upkeep | Attack | Defense | Qty |  | Solver Model
 | Weapon A | 200 | 15 | 12 | 0 |  | 4139.7011299972
 | Weapon B | 100 | 14 | 13 | 50 |  | 6
 | Protection A | 150 | 10 | 15 | 50 |  | 1
 | Protection B | 125 | 8 | 12 | 0 |  | 1
 | Vehicle A | 400 | 20 | 18 | 5 |  | 0
 | Vehicle B | 250 | 16 | 14 | 45.000001 |  | 1
 |  | Total | 4139.7011299972 |  | 29890.00028 |  | 100
 |  | Income |  |  | 28000
 |  | Mob Size |  |  | 50
 |  | Mob Size - Weapons |  |  | 0
 |  | Mob Size - Protections |  |  | 0
 |  | Mob Size - Vehicles |  |  | 9.999999974752427e-07
Spreadsheet: 271692d1382022660-drawing-information-from-multiple-worksheets-to-generate-a-summary-report-sample-data
Sheet: Name3

Name: | Name3
Rec | Input Date | Workstream | Projects | Internal Requests | External Requests | CPCMEC Tasking | Management | Tasks | Priority | Comments | Task Progress (%) | Upcoming DD | Concluded
6 | 2013-10-03 00:00:00 | Projects | Project1 |  |  |  |  | Edit Paper | Low |  | 100 | 2013-10-31 00:00:00 | 2013-10-10 00:00:00
7 | 2013-10-02 00:00:00 | Internal Request |  | Stats |  |  |  | Generate spreadsheet | Medium |  | 50 | 2013-10-31 00:00:00
8 | 2013-10-10 00:00:00 | Projects | Project3 |  |  |  |  | Edit Paper | Low |  | 100 | 2013-10-31 00:00:00 | 2013-10-11 00:00:00
Spreadsheet: 139003d1328034964-excel-2007-filter-in-dcount-function-dummy_example
Sheet: Sheet1

Item | Category | X | Y | Item | Category | X | Y | X | Y | X | Y | X | Y
Samsung SI | Smartphone | 1 | 4 |  | Smartphone | 1 | 4 | 2 | 4 | 3 | 4 | 4 | 4
[NAME] | Smartphone | 4 | 4 |  |  | X | Y | X | Y | X | Y | X | Y
Ipad | Tablet | 4 | 4 |  |  | 1 | 3 | 2 | 3 | 3 | 3 | 4 | 3
HTC | Smartphone | 1 | 4 |  |  | X | Y | X | Y | X | Y | X | Y
Samsung Galaxy | Tablet | 3 | 4 |  |  | 1 | 2 | 2 | 2 | 3 | 2 | 4 | 2
Acer One | Notebook | 4 | 4 |  |  | X | Y | X | Y | X | Y | X | Y
Iphone 4S | Smartphone | 2 | 4 |  |  | 1 | 1 | 2 | 1 | 3 | 1 | 4 | 1
HP One | Notebook | 1 | 4
Spreadsheet: sally_beck__33737__MgmtSum-Q3-0728
Sheet: QTD Mgmt Summary

E N R O N   N O R T H   A M E R I C A |  |  |  |  |  |  |  |  |  |  |  |  | 3RD QTR 2000 EARNINGS ESTIMATE
 |  | Margin |  |  |  | Expenses |  |  |  |  | EBIT
Business Team |  | Actual | Plan | [NAME] |  | Forecast | Plan(1) | [NAME] |  |  | Forecast | Plan | [NAME]
 |  |  |  |  |  |  |  | [NAME] | Cash Exp
Gas Trading
Texas Trading
Gas Trading
Canada Trading
East Power Trading (3)
West Power Trading
Financial Drift
Financial Trading
Coal Trading
Emissions (Coal)
Weather Trading
Cross Commodity Trading (2)
Total Trading & Risk Mgmt.
East Midstream
West Midstream
Industrial Downstream
Generation Investments
Coal Origination & Finance
Canada Origination & Finance
Upstream Originations
HPL
LRC
GRM - New Products
Mexico
Total Origination
Principal Investing
Energy Capital Resources
CTG Assets
Total Investing
Commercial Transactions Group
Office of the Chairman
Overview |  |  |  |  |  |  |  | 0
Total Commercial
Group Total |  | 0 | 0 |  |  |  |  | 0
Group Allocated to Teams/BU's |  | 0 | 0 |  |  |  |  | 0
Other Interest Related Charges |  |  |  |  |  |  |  | 0
Capital Charge Offset |  | 0 | 0
ENA EBIT
Interest Expense/(Income) |  | 0 | 0
[NAME]
(1) Includes Capital Charge & Operating, Direct, and Allocated Expenses
(2) Cross Commodity Trading numbers are as of 7/26/2000
(3) Includes Merrill Lynch reclass to Office of the Chair
 |  | Margin change from: 07/21/00 |  |  |  | Expense changes from: 07/21/00
 |  | DPR Change |  |  |  | Operating Expense
 |  | MPR Change |  |  |  | Commercial Expense
 |  | Other Margin Changes |  |  |  | Other
 |  | Total Change |  |  |  | Total Change
 |  | Prior Week: |  |  |  | Prior Week:
 |  | This Week: |  |  |  | This Week:
 |  | Change: |  |  |  | Change: