tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 108183d1305235781-changing-conditional-formatting-based-on-a-reference-kessler-1
Sheet: Sheet5

Competitor [NAME]'s
Ticker | Company
SJM | The J.M. Smuckers Company
CAG | ConAgra Foods, Inc
KFT | Kraft Food Inc.
[NAME]
 | 2006 |  |  |  | 2007 |  |  |  | 2008
 | Current | Quick | [NAME] | Debt/Equity | Current | Quick | [NAME] | Debt/Equity | Current | Quick | [NAME] | Debt/Equity
SJM | 2.43 | 1 | 1.53 | 0.25 | 2.7 | 1.37 | 1.5 | 0.22 | 3.24 | 1.45 | 1.74 | 0.44
CAG | 1.62 | 0.51 | 2.63 | 0.68 | 1.87 | 0.51 | 2.57 | 0.75 | 1.67 | 0.28 | 2.56 | 0.63
KFT | 0.79 | 0.39 | 1.95 | 0.25 | 0.63 | 0.34 | 2.49 | 0.47 | 1.03 | 0.54 | 2.84 | 0.84
Competitors Average
 | 2009 |  |  |  | 2010
 | Current | Quick | [NAME] | Debt/Equity | Current | Quick | [NAME] | Debt/Equity
SJM | 1.32 | 0.68 | 1.66 | 0.18 | 2.56 | 1.09 | 1.5 | 0.17
CAG | 2.12 | 0.65 | 2.35 | 0.73 | 1.94 | 0.89 | 2.38 | 0.66
KFT | 1.08 | 0.64 | 2.58 | 0.7 | 1.04 | 0.58 | 2.66 | 0.75
Competitors Average
Profitability Margins and [NAME]'s
 | 2006 |  |  |  | 2007 |  |  |  | 2008
 | Gross Margin | Profit Margin | Return on Assets | Return On Equity | Gross Margin | Profit Margin | Return on Assets | Return On Equity | Gross Margin | Profit Margin | Return on Assets | Return On Equity
SJM | 32.15 | 6.65 | 5.42 | 8.39 | 32.68 | 7.32 | 5.88 | 8.92 | 30.98 | 6.75 | 5.85 | 9.48
CAG | 24.27 | 4.61 | 4.31 | 11.23 | 26.09 | 6.36 | 6.42 | 16.56 | 23.4 | 8.02 | 7.9 | 18.76
KFT | 36.14 | 8.91 | 5.41 | 10.52 | 33.81 | 6.95 | 4.19 | 9.27 | 33.21 | 6.87 | 4.43 | 11.72
Competitors Average
 | 2009 |  |  |  | 2010
 | Gross Margin | Profit Margin | Return on Assets | Return On Equity | Gross Margin | Profit Margin | Return on Assets | Return On Equity
SJM | 33.3 | 7.08 | 4.7 | 7.89 | 38.8 | 10.73 | 6.11 | 9.63
CAG | 22.31 | 7.69 | 7.9 | 19.45 | 25.38 | 6.01 | 6.36 | 15.05
KFT | 36.15 | 7.48 | 4.66 | 12.57 | 36.38 | 8.36 | 5.08 | 13.33
Competitors Average
[NAME]
 | 2006 |  |  |  | 2007 |  |  |  | 2008
 | Acc. [NAME] | Inventory Turnover | Days sales out. | Days Inventory Out. | Acc. [NAME] | Inventory Turnover | Days sales out. | Days Inventory Out. | Acc. [NAME] | Inventory Turnover | Days sales out. | Days Inventory Out.
SJM | 14.67 | 5.02 | 24.88 | 72.67 | 15.79 | 4.95 | 23.11 | 73.67 | 17.63 | 5.24 | 20.71 | 69.71
CAG | 9.37 | 3.69 | 38.97 | 98.79 | 10.09 | 3.97 | 36.17 | 91.99 | 11.09 | 4.15 | 32.92 | 87.86
KFT | 9.47 | 6.41 | 38.53 | 56.97 | 8.22 | 7.2 | 44.43 | 56.28 | 8.52 | 7.2 | 42.82 | 50.67
Competitors Average
 | 2009 |  |  |  | 2010
 | Acc. [NAME] | Inventory Turnover | Days sales out. | Days Inventory Out. | Acc. [NAME] | Inventory Turnover | Days sales out. | Days Inventory Out.
SJM | 17.54 | 5.1 | 20.81 | 71.61 | 18.24 | 4.48 | 20.01 | 81.51
CAG | 15.23 | 5 | 23.97 | 73.01 | 14.81 | 4.96 | 24.64 | 73.52
KFT | 8.16 | 6.87 | 44.74 | 53.11 | 8.39 | 6.89 | 43.53 | 52.96
Competitors Average
*CAG & KFT Ratios were obtained from Mourningstar.com
http://financials.morningstar.com/ratios/r.html?t=KFT
Spreadsheet: 744411d1629224254-how-to-calculate-double-time-hours-between-12-am-and-6-am-test-hours
Sheet: Namelist

 | [NAME] (Last, First) | Social Security # | Department | Rate
 | Winkman, Hedge |  | A2 | 36
 | Dinkle, Horatio
Spreadsheet: 734163d1622023973-required-formula-for-how-many-no-of-avg-days-for-collection-recover-oustanding-reco-days
Sheet: Sheet1

SALESMAN NAME | OPENING OUTSTANDING | SALES AMOUNT | SALES % as per Opening O/s | COLLECTION AMOUNT | COLL % as per Opening O/s | CLOSING OUTSTANDING | AVG NO. OF DAYS FOR RECOVER
AJAY | 37088664 | 12758382 |  | 22722013
VIJAY | 7498228 | 1181154 |  | 1925000
SUNIL | 26494133 | 1539569 |  | 21405192
ANIL | 5746640 | 2910165 |  | 5889533
TOTAL =
Spreadsheet: 110929d1307476716-last-12-entries-dynamicrngfinance
Sheet: Calculation

Date | Net Asset | Investment Income |  |  |  | Expenses |  |  |  |  |  |  |  | Unrealized Gain/Loss | Realized Gain/Loss
2010-07-03 00:00:00 | 205044560 | 5127171 | 0 | 0 | 0 | 991460 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 748375 | 492223.5
2010-07-04 00:00:00 | 2005460000 | 6612000 | 0 | 0 | 0 | 997000 | 100000 | 5000 | 0 | 0 | 0 | 0 | 0 | 673537.5 | 467612.325
2010-07-05 00:00:00 | 1000000 | 5289600 | 0 | 0 | 0 | 987030 | 240540 | 5000 | 0 | 0 | 0 | 0 | 0 | 606183.75 | 444231.7087499999
2010-07-06 00:00:00 | 10000000 | 4231680 | 0 | 0 | 0 | 977159.7 | 350000 | 5000 | 0 | 0 | 0 | 0 | 0 | 545565.375 | 422020.1233124999
2010-07-07 00:00:00 | 2222050 | 3385344 | 0 | 0 | 0 | 967388.103 | 50000 | 5000 | 0 | 0 | 0 | 0 | 0 | 491008.8375 | 400919.1171468749
2010-07-08 00:00:00 | 40640504 | 2708275.2 | 0 | 0 | 0 | 957714.22197 | 100000 | 5000 | 0 | 0 | 0 | 0 | 0 | 441907.95375 | 380873.1612895312
2010-07-09 00:00:00 | 20460540504 | 2166620.16 | 0 | 0 | 0 | 948137.0797502999 | 100000 | 5000 | 0 | 0 | 0 | 0 | 0 | 397717.1583750001 | 361829.5032250546
2010-07-10 00:00:00 | 50050055 | 1733296.128 | 0 | 0 | 0 | 938655.7089527969 | 100000 | 5000 | 0 | 0 | 0 | 0 | 0 | 357945.4425375001 | 343738.0280638019
2010-07-11 00:00:00 | 445048044 | 1386636.9024 | 0 | 0 | 0 | 929269.1518632689 | 100000 | 5000 | 0 | 0 | 0 | 0 | 0 | 322150.8982837501 | 326551.1266606118
2010-07-12 00:00:00 | 4504500 | 1109309.52192 | 0 | 0 | 0 | 919976.4603446362 | 100000 | 5000 | 0 | 0 | 0 | 0 | 0 | 289935.8084553751 | 310223.5703275812
2010-07-13 00:00:00 | 5405040504 | 887447.6175360002 | 0 | 0 | 0 | 910776.6957411899 | 100000 | 5000 | 0 | 0 | 0 | 0 | 0 | 260942.2276098376 | 294712.3918112021
2010-07-14 00:00:00 | 50454545004 | 709958.0940288003 | 0 | 0 | 0 | 901668.928783778 | 100000 | 5000 | 0 | 0 | 0 | 0 | 0 | 234848.0048488538 | 279976.772220642
Spreadsheet: 053ef7c5-aed4-43bb-abb6-f6a8c1a9fb9c
Sheet: Compendex(EI)

Compendex (Engineering Index)
2005-2006
 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | Total | 2005-2006 Price | Price per search
Compendex
Sessions | 65 | 86 | 134 | 370 | 174 | 81 | 80 | 114 | 150 | 131 | 91 | 62
Searches | 155 | 219 | 392 | 2023 | 589 | 261 | 272 | 329 | 528 | 372 | 262 | 183 |  | 13625
Spreadsheet: 161539d1339541901-count-based-on-multiple-criteria-challenging-equation-product-workbook
Sheet: Product Schedule

PRODUCT SCHEDULE
Product Name | Location | Start Date | Thru Date
Product A | Location 1 | 2012-01-01 00:00:00 | 2012-01-10 00:00:00
Product A | Location 2 | 2012-01-01 00:00:00 | 2012-01-10 00:00:00
Product A | Location 3 | 2012-01-01 00:00:00 | 2012-01-10 00:00:00
Product A | Location 4 | 2012-01-01 00:00:00 | 2012-01-10 00:00:00
Product A | Location 5 | 2012-01-01 00:00:00 | 2012-01-10 00:00:00
Product A | Location 6 | 2012-01-01 00:00:00 | 2012-01-10 00:00:00
Product A | Location 7 | 2012-01-01 00:00:00 | 2012-01-10 00:00:00
Product A | Location 8 | 2012-01-01 00:00:00 | 2012-01-10 00:00:00
Product A | Location 9 | 2012-01-01 00:00:00 | 2012-01-10 00:00:00
Product A | Location 10 | 2012-01-01 00:00:00 | 2012-01-10 00:00:00
Product B | Location 1 | 2012-01-01 00:00:00 | 2012-01-05 00:00:00
Product B | Location 2 | 2012-01-01 00:00:00 | 2012-01-05 00:00:00
Product B | Location 3 | 2012-01-01 00:00:00 | 2012-01-05 00:00:00
Product B | Location 4 | 2012-01-01 00:00:00 | 2012-01-05 00:00:00
Product B | Location 5 | 2012-01-01 00:00:00 | 2012-01-05 00:00:00
Product B | Location 6 | 2012-01-01 00:00:00 | 2012-01-05 00:00:00
Product B | Location 7 | 2012-01-01 00:00:00 | 2012-01-05 00:00:00
Product B | Location 8 | 2012-01-01 00:00:00 | 2012-01-05 00:00:00
Product B | Location 9 | 2012-01-01 00:00:00 | 2012-01-05 00:00:00
Product B | Location 10 | 2012-01-01 00:00:00 | 2012-01-05 00:00:00
Spreadsheet: 846718d1697845526-how-to-transform-data-from-a-weekly-schedule-into-daily-shifts-shift-coverage-excel-ahmedsayedmu-
Sheet: Data

Helper Columns |  | Helper Columns |  | Helper Columns |  | Helper Columns |  | Name | Department | Day | Start Shift | End Shift
--Sorted by Date and Shift-- |  |  |  |  |  |  |  | [NAME] | SME | Monday | 15:00:00 | 00:00:00
Employee | Dept | Date | StartShift | EndShift | Shift Start | Shift End |  | [NAME] | SME | Tuesday | 15:00:00 | 00:00:00
[NAME] | SME | Sun, Oct 1 | 15:00:00 | 00:00:00 | 2023-10-01 15:00:00 | 2023-10-02 00:00:00 |  | [NAME] | SME | Friday | 15:00:00 | 00:00:00
[NAME] | SME | Mon, Oct 2 | 15:00:00 | 00:00:00 | 2023-10-02 15:00:00 | 2023-10-03 00:00:00 |  | [NAME] | SME | Saturday | 15:00:00 | 00:00:00
[NAME] | SME | Thu, Oct 5 | 15:00:00 | 00:00:00 | 2023-10-05 15:00:00 | 2023-10-06 00:00:00 |  | [NAME] | SME | Sunday | 15:00:00 | 00:00:00
[NAME] | SME | Fri, Oct 6 | 15:00:00 | 00:00:00 | 2023-10-06 15:00:00 | 2023-10-07 00:00:00 |  | Maria |  | Monday | 11:00:00 | 20:00:00
[NAME] | SME | Sat, Oct 7 | 15:00:00 | 00:00:00 | 2023-10-07 15:00:00 | 2023-10-08 00:00:00 |  | Maria |  | Tuesday | 11:00:00 | 20:00:00
 |  |  |  |  |  |  |  | Maria |  | Wednesday | 11:00:00 | 20:00:00
 |  |  |  |  |  |  |  | Maria |  | Thursday | 11:00:00 | 20:00:00
 |  |  |  |  |  |  |  | Maria |  | Friday | 11:00:00 | 20:00:00
 |  |  |  |  |  |  |  | Adly |  | Monday | 12:00:00 | 21:00:00
 |  |  |  |  |  |  |  | Adly |  | Tuesday | 12:00:00 | 21:00:00
 |  |  |  |  |  |  |  | Adly |  | Wednesday | 12:00:00 | 21:00:00
 |  |  |  |  |  |  |  | Adly |  | Thursday | 12:00:00 | 21:00:00
 |  |  |  |  |  |  |  | Adly |  | Friday | 12:00:00 | 21:00:00
Spreadsheet: 856254d1705572061-count-total-number-of-months-not-counting-overlapping-months-calculatemonths
Sheet: Sheet1

Project Name | Start Period | End Period |  |  |  |  | Array |  | No array
ABC | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  | Total number of days taken |  |  |  |  | [How to calculate the total number of days, not counting overlapping period]
DDD | 2022-05-01 00:00:00 | 2023-02-03 00:00:00
EEE | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  | Total number of months
FFF | 2024-09-02 00:00:00 | 2024-12-31 00:00:00
EFG | 2000-01-01 00:00:00 | 2000-06-30 00:00:00
Spreadsheet: 56e50efa-723f-4303-a814-a245a51cc7f2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Yes, I want to help and want to become a Supporting Member of HelpAlliance e.V.
Please check/indicate amount:
 | 2 € / month |  | 10 € / month |  | 20 € / month
 | 30 € / month |  | 50 € / month |  | ___ € / month (any other amount)
 | I authorize HelpAlliance e.V. to charge my account with the amount indicated in euros (€) above (German bank account required. This authorization can be revoked at any time).
Debits are to be made at these intervals (I will receive a receipt for my annual donation):
 | annually (in case of 1€ per month debit on annual basis only)
 | monthly
 | semiannually
German Bank Details:
Account Number
Bank sorting code
Name of Bank
 | I will transfer the supporting amount from my account by standing order:
Help [NAME], [NAME],  Account Number: 200 029 223, German bank sorting code: 500 502 01;
IBAN: DE89 5005 0201 0200 0292 23; BIC: HELADEF1822
Distribution of information material
Please send me the Annual Report:
 | by eMail |  | by post
 | I want to subscribe to the HelpAlliance newsletter (will be distributed only by eMail)
Personal Data:
Name
First name(s)
Street
Postal code, place
Country
E-mail
LH-Dept.(if applicable)
Place/Date |  |  |  | Signature
If you would like to support a certain project, please insert the name of the project below:
Please print out and sign the application form and send it to:  HelpAlliance e.V., c/o Deutsche Lufthansa AG, FRA HelpAlliance, 60546 Frankfurt a.M, Germany
Spreadsheet: sally_beck__33996__MgmtSum-Q201-Global-0420
Sheet: GrossMargin

PLAN2000
[NAME] | ENRON GLOBAL MARKETS
2000-12-01 00:00:00 | 2nd QUARTER 2001 DETAIL OF GROSS MARGIN
M.QTD
ENA
 |  |  |  |  |  | Accrual / |  | Actual | Deals | Forecast | Total | Margin
 | Business Team |  | DPR(1) | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin | Plan | [NAME]
 | Crude & Products |  | -16830 | 0 | 0 | 0 | 0 |  |  | 0 |  | 32500
COAL | Coal |  | 2395 | 0 | 0 | 0 | 0 |  |  | 0
 | Vessel Trading |  | -3205 | 0 | 0 | 0 | 0 |  |  | 0 |  | 2500
SO2 | Emissions |  | 770 | 0 | 0 | 0 | 0 |  |  | 0
WEATHER | Weather |  | 595 | 0 | 0 | 0 | 0 |  |  | 0
INSURANCE | Global Risk Markets |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 11875
ECT_INV_IRFX | Equity Trading |  | -733 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
ECT_INV_IRFX | Convertible Trading |  | 2310 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | FX / Int Rate Trading |  | -1047 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Soft Commodities Trading |  | -33 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Grain Trading |  | -53 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Meat Trading |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Financial Trading |  |  |  |  |  |  |  |  |  |  | 27500
 | Freight Markets |  | 29 | 0 | 0 | 0 | 0 |  |  | 0
 | LNG |  | 130 | 0 | 0 | 0 | 0 |  |  | 0 |  | 5000
 | Puerto Rico |  | 0 | 0 | 0 | -1445 | 0 |  |  | 0
 | Finance and Structuring |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Office of the Chairman |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Subtotal Gross Margin
 | Other Interest Related Charges |  | 0 | 0 | 0 | -500 | 0 |  |  | 0
 | EGM Gross Margin
 | (1) Excludes Cap. Charge & Operating Costs
Spreadsheet: 699284d1602519486-error-in-autofilling-for-patterned-rows-help-me-pleasee
Sheet: Similarity

 | SIM | SIM(1,1) | SIM(1,2) | [NAME]) | SIM(1,4) | SIM(1,5) | SIM(2,1) | SIM(2,2) | SIM(2,3) | SIM(2,4) | SIM(2,5) | SIM(3,1) | SIM(3,2) | SIM(3,3) | SIM(3,4) | SIM(3,5) | SIM(4,1) | SIM(4,2) | SIM(4,3) | SIM(4,4) | SIM(4,5) | SIM(5,1) | SIM(5,2) | SIM(5,3) | SIM(5,4) | SIM(5,5)
 | SIM(1,1) | 1
 | SIM(1,2) | 0.1866054968633707
 | [NAME]) | 0.25
 | SIM(1,4) | 0.5
 | SIM(1,5) | 0.5
 | SIM(2,1) | 0.1866054968633707
 | SIM(2,2) | 1
 | SIM(2,3) | 0.3333333333333333
 | SIM(2,4) | 0.1566130288262323
 | SIM(2,5) | 0.1951941016011038
 | SIM(3,1) | 0.1463924816619788
 | SIM(3,2) | 0.25
 | SIM(3,3) | 0.1666666666666667
 | SIM(3,4) | 0.3333333333333333
 | SIM(3,5) | 0.1297319075568038
 | SIM(4,1) | 1
 | SIM(4,2) | 0.1350781059358212
 | SIM(4,3) | 0.25
 | SIM(4,4) | 0.1666666666666667
 | SIM(4,5) | 0.3333333333333333
 | SIM(5,1) | 0.1336766024001917
 | SIM(5,2) | 0.5
 | SIM(5,3) | 0.1951941016011038
 | SIM(5,4) | 0.1951941016011038
 | SIM(5,5) | 0.1395787568369994
Spreadsheet: 793341d1661423688-consecutive-numbers-by-id-sample-data-set
Sheet: Sample Data Set

ID | threshold | formula result | [NAME]
1 | 45 |  | 1
1 | 55 |  | 2
1 | 67 |  | 3
2 | 89 |  | 0
2 | 90 |  | 0
2 | 65 |  | 1
2 | 45 |  | 2
3 | 0 |  | 0
3 | 12 |  | 1
3 | 1 |  | 2
4 | 55 |  | 1
Spreadsheet: 820345d1678041526-running-balance-of-two-columns-using-lambda-functions-book1
Sheet: Sheet1

 |  |  | Out | In
 |  |  | 100 | 150
 |  |  | 95 | 97 | 52
 |  |  | 74 | 77 | 55
 |  |  | 10 | 84 | 129
 |  |  | 145 | 38 | 22
 |  |  | 35 | 86 | 73
 |  |  | 20 | 7 | 60
 |  |  | 79 | 70 | 51
 |  |  | 60 | 12 | 3
 |  |  | 48 | 86 | 41
 |  |  | 31 | 72 | 82
 |  |  | 48 | 8 | 42
 |  |  | 62 | 74 | 54
 |  |  | 7 | 48 | 95
Spreadsheet: 775885d1649361976-formula-for-everything-else-or-false-everything-else-value
Sheet: Sheet1

Date | MYID | Case | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Result Comment | AG | GG
2022-03-28 00:00:00 | 222XX02 | CaseA |  |  |  |  |  |  |  | 8.3925 |  |  | 1078 | 40
2022-03-29 00:00:00 | 222XX56 | CaseA |  |  |  |  |  |  |  | 9.8825 |  |  | 63 | 39
2022-04-01 00:00:00 | 222XX52 | CaseA |  |  |  |  |  |  |  | 8.2475 |  |  | 285 | 39
2022-04-01 00:00:00 | 222XX96 | [NAME] |  |  |  |  |  |  |  | 70.47 |  |  | 452 | 37
Spreadsheet: 766332d1643844883-risk-assessment-with-multiple-likelihood-and-consequence-inputs-risk-assessment-template
Sheet: Risk Register

 |  |  |  |  |  |  |  |  | RISK ASSESSSMENT
Category | Item | Risk Title | Causes Triggers Indicators | Impacts Consequences | Existing Controls |  | Operational Safety | Financial Loss | Operational Capability | WHS | Governance | Stakeholders | Environment | Highest Likelihood | Operational Safety | Financial Loss | Operational Capability | WHS | Governance | Stakeholders | Environment | Highest Consequence | Rating
Ref. |  | Risk Description |  |  |  |  | Likelihood |  |  |  |  |  |  |  | Consequence
A | Due Diligence
A | 1 | RISK TITLE |  |  |  |  | Almost Certain | Likely | Remote | Possible | [NAME] |  |  |  |  |  | Catastrophic |  | Minor | Moderate
Spreadsheet: 109669d1306451244-average-a-cell-in-a-column-if-matching-a-set-of-criteria-template
Sheet: AVERAGES

CALL LOG: WEEK OF
COLLECTOR |  | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | SATURDAY |  |  |  | WEEKLY TOTAL
EXT | NAME | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION
7012 | name
7023 | name
7014 | name
7008 | name
7011 | name
7032 | name
7009 | name
7018 | name
7015 | name
7013 | name
COURT TOTALS
COURT AVERAGE
7010 | name
7022 | name
7019 | name
CONSUMER TOTALS
CONSUMER AVERAGE
COMBINED TOTALS
COMBINED AVERAGE
Spreadsheet: 5cf7d403-bf27-41a0-add6-3626d876a4ed
Sheet: Projected Totals

 |  | [NAME] | September | October | November | December | Semester Total
 |  | Income
 |  | Liabilities
 |  | TOTALS
 |  | CASH FLOW ANALYSIS | September | October | November | December | Semester Total
 |  | Chapter Account Totals | 188.57
 |  | Income
 |  | Liabilities
 |  | TOTALS
 |  | End Fall Budget
 |  | Current Chapter Account Balance | 188.57
 |  | Chapter Cash Balance | 980 |  | $200 of this is deposited in rental equipment waiting to be returned
 |  | Account Balance for Winter
 |  | Debt to International Winter | 2335.43
Spreadsheet: 805967d1669038529-countifs-with-date-rules-listing-ans
Sheet: IN-OUT

Total | X | Y | Z
IN
Exit
OUT in 1 year | ??? | ??? | ???
Category | Entry date | Exit date |  | Category | FORMULA
X | 2021-04-21 00:00:00 | 2021-05-21 00:00:00 |  | X
X | 2021-04-24 00:00:00 | 2021-04-25 00:00:00 |  | Y
Y | 2022-10-25 00:00:00 |  |  | Z
Y | 2022-11-21 00:00:00
Y | 2022-11-21 00:00:00
Z | 2022-11-21 00:00:00
Z | 2022-11-21 00:00:00
Z | 2022-11-21 00:00:00 | 2023-11-20 00:00:00
Z
X
Z
Z
Y
X
Y
X
Y
Z
Y
Y
Z
Spreadsheet: 98748d1297616360-conditional-formatting-rule-returning-true-but-format-not-applied-cfexample
Sheet: Sheet1

Task Name | Status | Expected Finish Date | Date Closed | Not Closed | Estimated Finish Date past-due | Today Value | Expected Closed Value | Both Conditions
One | Started | 2011-02-10 00:00:00 | 2011-02-09 00:00:00 | 0 | #N/A | #N/A | 40584 | #N/A
Two | Waiting | 2011-02-11 00:00:00 |  | 1 | #N/A | #N/A | 40585 | #N/A
Three | Started | 2011-02-09 00:00:00 |  | 1 | #N/A | #N/A | 40583 | #N/A
 |  | 2011-02-15 00:00:00
 |  | 2011-02-03 00:00:00 | 2001-02-02 00:00:00
 |  | 2011-02-04 00:00:00
Spreadsheet: 93604d1293193782-inverse-maximum-minimum-function-minmax-2
Sheet: Sheet1

 | MAX BEFORE | MAX AFTER | MIN BEFORE | MIN AFTER
13 | 0 | 3 | 0 | 0
6 | 0 | 0 | 1 | 1
7 | 1 | 1 | 0 | 0
2 | 0 | 0 | 3 | 8
15 | 4 | 10 | 0 | 0
10 | 0 | 3 | 0 | 0
9 | 0 | 2 | 2 | 0
8 | 0 | 1 | 3 | 0
4 | 0 | 0 | 4 | 3
11 | 4 | 0 | 0 | 1
12
5
1
11
3
19
20
2
13
17
12
6
14
7
7
9
10
14
3
15
14
19
15
16
17
11
8
12
16
11
7
20
3
10
4
17
5
11
20
13
8
4
17
10
8
16
18
12
14
19
18
7
5
12
1
8
14
7
20
14
Spreadsheet: 765007d1643118175-consider-empty-cell-with-formula-book1
Sheet: Folha1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 8
Spreadsheet: 152701d1335473037-seperating-lines-in-a-cell-excel
Sheet: Sheet2

Questionnaire |  | COMPUTER TYPE | SERIAL NUMBER | ADDITIONAL EQUIPMNET | SERIAL NUMBER | [NAME]
Computer Type:  LAPTOP Computer Serial Number  WE4545 Additional Equipment  LOCAL PRINTER Additional Equipment Serial Number  sdAD Monitor  Dual Monitor Approved Ergo Chair to Move  No Email: | turns into | Computer Type:  LAPTOP | Computer Serial Number  WE4545 | Additional Equipment  LOCAL PRINTER | Additional Equipment Serial Number  sdAD | Monitor: Dual Monitor Approved ergo chair to move: yes email:
Computer Type:  PC Computer Serial Number: DSD4545 Additional Equipment  SCANNER Additional Equipment Serial Number ASD Monitor  Single Monitor Approved Ergo Chair to Move  Yes Email:  [EMAIL] | turns into | Computer Type:  PC | Computer Serial Number: DSD4545 | Additional Equipment  SCANNER | Additional Equipment Serial Number ASD | Monitor: Single Monitor Approved ergo chair to move: yes email: [EMAIL]
Spreadsheet: 52283d1251987687-counting-transactions-per-agent-sample
Sheet: Sheet1

 |  | Name | Amount
 |  | [NAME] | 23.5
 |  | Gemma | 25
 |  | [NAME] | 26
 |  | Kayleigh | 24
 |  | [NAME] | 10
 |  | [NAME] | 78
 |  | Gemma | 23
 |  | [NAME] | 0
 |  | [NAME] | 0
 |  | [NAME] | 0
 |  | [NAME] | 0
 |  | [NAME] | 0
 |  | [NAME] | 0
 |  | [NAME] | -10
 |  | [NAME] | -10
 |  | [NAME] | 10
 |  | [NAME] | 105
 |  | [NAME] | 0
 |  | [NAME] | -10
 |  | [NAME] | -10
 |  | [NAME] | 10
 |  | [NAME] | 6.5
 |  | [NAME] | 0
 |  | [NAME] | 0
 |  | [NAME] | 0
 |  | [NAME] | -15
 |  | [NAME] | -15
 |  | [NAME] | 15
 |  | [NAME] | 0
 |  | [NAME] | 0
 |  | [NAME] | 0
 |  | [NAME] | 33
 |  | [NAME] | -15
 |  | [NAME] | -15
 |  | [NAME] | 15
 |  | [NAME] | 15
 |  | [NAME] | 101.4
 |  | [NAME] | 0
 |  | [NAME] | -10
 |  | [NAME] | -10
 |  | [NAME] | 10
 |  |  |  |  |  | Count of Amount
 |  |  |  |  |  | Name | Total
 |  |  |  |  |  | [NAME] | 8
 |  |  |  |  |  | [NAME] | 3
 |  |  |  |  |  | [NAME] | 7
 |  |  |  |  |  | [NAME] | 12
 |  |  |  |  |  | Gemma | 2
 |  |  |  |  |  | [NAME] | 8
 |  |  |  |  |  | Kayleigh | 1
 |  |  |  |  |  | Grand Total | 41
Spreadsheet: tracy_geaccone__40345__2002 EREC Preliminary 1015
Sheet: Allocations

 |  |  | NOTE: You made add rows when necessary to include additional senders/receivers.
2002 PLAN |  |  | Reconciliation check:
ALLOCATIONS
(Millions of Dollars)
 |  |  |  |  | Full Year |  | Total Per
 |  |  |  |  | 2002 |  | O&M Detail |  | Difference
Allocations made via primary cost element
 | Allocations Received From:
 |  | EPSC |  |  | 0
 |  | ENW |  |  | 0
 |  | Analyst / Associate |  |  | 0
 |  | Total Allocations Received via Primary Cost Element
 | Allocations Sent To:
 |  | Amercias |  |  | 0
 |  | Europe |  |  | 0
 |  | Global Markets |  |  | 0
 |  | Industrial Markets |  |  | 0
 |  | Net Works |  |  | 0
 |  | EGAS |  |  | 0
 |  | EES |  |  | 0
 |  | Corp |  |  | 0
 |  | Receiver BU |  |  | 0
 |  | Receiver BU |  |  | 0
 |  | Total Allocations Sent via Primary Cost Element
 |  | Total Allocations via Primary Cost Element, net
Allocations made via secondary cost element
 | Allocations Received From:
 |  | Corporate |  |  | 0
 |  | Global Finance |  |  | 0
 |  | Americas |  |  | 0
 |  | [NAME] |  |  | 0
 |  | [NAME] |  |  | 0
 |  | [NAME] |  |  | 0
 |  | [NAME] |  |  | 0
 |  | [NAME] |  |  | 0
 |  | Subtotal Allocations Received
 | Allocations Sent To:
 |  | Amercias |  |  | 0
 |  | Europe |  |  | 0
 |  | Global Markets |  |  | 0
 |  | Industrial Markets |  |  | 0
 |  | Net Works |  |  | 0
 |  | EGAS |  |  | 0
 |  | EES |  |  | 0
 |  | Corp |  |  | 0
 |  | Receiver BU |  |  | 0
 |  | Receiver BU |  |  | 0
 |  | Receiver BU |  |  | 0
 |  | Receiver BU |  |  | 0
 |  | Receiver BU |  |  | 0
 |  | Receiver BU |  |  | 0
 |  | Subtotal Allocations Sent
 |  | Total Allocations via Secondary Cost Element, net
 |  | Total All Allocations, net
Spreadsheet: 214930d1361198840-sumif-problem-staff-requirements
Sheet: Machine 1

 | Staff [NAME] by Job
Machine: | 1 - RV53B
Start Date:
End Date:
Tool | Day | Start Date | Staff Required |  | End Date
 |  |  |  | 3 |  |  | 2013-02-18 00:00:00
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 1
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3