tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 05c9f88a-10b0-4abb-b956-cbfb4cff5b92
Sheet: Sheet1

SAMPLE FORMAT
This form represents a sample statement which can be utilized as a guide for preparing your Statement of Activities.  Please provide as much detail as possible concerning your revenues and expenses for a 12-month reporting period.  Figures should be actual income/expenses and not projected or estimated.
STATEMENT OF ACTIVITIES (INCOME STATEMENT)
COMPANY/AGENCY NAME:
FOR THE PERIOD OF _______________________________
 |  |  |  | Unrestricted | Restricted*
 |  |  |  | Amount | Amount
PUBLIC SUPPORT AND REVENUES:
Fees for Service/Contracts – (i.e., Revenue received from daycare services
County payments (i.e., Title XX)
Grants -(please list individually each grant)
________________________
________________________
Donations, gift, and/or in-kind contributions
Special events, net
Foundations (identify each separately)
________________________
________________________
Interest Revenue
Seminars and workshops
Other - please provide detail of what is included in this category
Total Public Support and Revenues
EXPENSES:
Pass-thru to sub-recipient**
Professional fees
Fundraising/Charitable Contributions
Wages
Employee Benefit Programs
Education and travel
Internet
Telephone & Utilities
Insurance
Advertising
Amortization
Bad Debts
Bank Charges
Contract Labor
Depreciation
Dues & Subscriptions
Interest Expense
Legal & professionals fees
General office supplies
Postage
Repairs & Maintenance
Contracted Services (accounting, equip. lease)
Rent
Food
Paper Products
Other - please provide detail of what is included from restrictions
Total Expenses
CHANGE IN NET ASSETS***
NET ASSETS, beginning of year**** |  |  |  | 0 | 0
NET ASSETS, end of year*****
Definitions:
*Restricted - funding is dedicated for a specific purpose that cannot be used for general operating purposes.
**Federal/state money given to a provider to perform a function of the grant
***[NAME] has been built in = Total Public Support and Revenues minus Total Expenses
****Net Assets, Beginning of Year  - take from last year's Statement of Activities
*****Automatically calculated - Equals change in Net Assets plus Net Assets, Beginning of the Year
Preparation Date: _______________ |  |  |  | Prepared by:  ____________________
Spreadsheet: 20a392d2-7dd8-4e31-8937-15c2a7566f34
Sheet: L

Course color corresponds with term of offering.  RED for fall semester, PURPLE for J-term, GREEN for both fall and J-term.
 | AOK Designation | CAR Designation | Comment
Latin
LATN 211-212 | Foreign Language
LATN 215 | Foreign Language
LATN 341 | Arts & Literature-Literature
LATN 342 | Arts & Literature-Literature
LATN 343 | Arts & Literature-Literature
LATN 344 | Arts & Literature-Literature
LATN 345 | Arts & Literature-Literature
LATN 346 | Arts & Literature-Literature
LATN 347 | Arts & Literature-Literature
LATN 348 | Arts & Literature-Literature
LATN 481-482 |  | Experiential-Research
LATN 487-488 |  | Experiential-Research
LATN 496-498 |  | Experiential-Research
Spreadsheet: john_zufferli__16711__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to | Hedgeable | Current |  | AECO
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Volume | Gas Hedges |  | Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (cont/day) | (cont/day) | % Hedged | (cont/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 826325d1681929941-unique-values-and-countif-workshop-attendees
Sheet: Attendees

In-person Registrations |  |  |  | In-person Attendees
Virtual Registrations |  |  |  | [NAME]
Total Registrations |  |  |  | Total Attendees |  |  |  | Total Applications
UNIQUE Registrations |  |  |  | * Includes repeat attendees |  |  |  | * Does not include duplicates
Duplicate Registrations
First Name | Last Name | [NAME] | Session Registration | Venue | Attended | Submitted App
Abc | 123 | [EMAIL] | 2023-04-20 00:00:00 | Virtual | Yes | Yes
Abc | 123 | [EMAIL] | 2023-04-06 00:00:00 | In-person | No | No
Def | 456 | [EMAIL] | 2023-04-20 00:00:00 | Virtual | No | No
Ghi | 789 | [EMAIL] | 2023-04-06 00:00:00 | In-person | Yes | Yes
Jkl | 999 | [EMAIL] | 2023-04-20 00:00:00 | Virtual | No | No
Jkl | 999 | [EMAIL] | 2023-04-06 00:00:00 | In-person | Yes | Yes
Abc | 123 | [EMAIL] | 2023-03-23 00:00:00 | In-person | Yes | No
Total
Spreadsheet: 31788d1227730776-transferring-data-from-one-column-to-another-based-upon-a-variable-contract-example
Sheet: Sheet1

Average Selling Price |  | 5000 |  | Average Selling Price |  | 5000
Trade |  | 100 |  | Average Down Payment |  | 800
ACV |  | 100 |  | Trade Allowance |  | 100
Average Cost |  | Trade Pay Off |  | Trade Pay Off
Difference |  | 4900 |  | Unit ACV |  | 1200
Tax | 0.0575 | 281.75 |  | Trade ACV |  | 100
Fees |  | 100 |  | Overhead Per Unit |  | 1000
Payoff |  | 100
Total |  | 5381.75 |  | Average Deal |  | 2900
Cash Invest |  | 0
Adds |  | 100 |  | After Overhead |  | 1900
Amt Fin |  | 5481.75
Profit |  | #N/A
Payment |  | 300.5196131941831
Rate | 0.3
Term | 24
 |  | 299.0244907404806
 |  | 302.0147356478855
 |  | Trade Pay Off
Total Interest |  | 1730.720716660394
Tot at Term |  | #N/A
Total Units Sold |  | 5
Commisssion |  | 100
Spreadsheet: 0208db61-e963-43b7-98f3-67ad452ae351
Sheet: FACTORES DE CONVERSIÓN

COMBUSTIBLES PARA USOS TÉRMICOS
 | TIPO | DENSIDAD 20ºC | Poder Calorífico Inferior (PCI) | Toneladas equivalentes de petróleo (1) |  | Emisiones de CO2 (1) |  | Factor [NAME] final a energía primaria Fp/f
 |  | [NAME] | [kWh/kg] | Ftep/t [tep/t*] | Ftep/MWh [tep/MWh] | [gCO2/kWh] | [tCO2/tep] | [unidades energía primaria/ unidades energía final]
GLP | PROPANO | 506 | 12.88 | 1.12 | 0.087 | 237 | 2.72 | 1.05
 | BUTANO | 580 | 12.72 | 0.98 | 0.077 | 210
GASÓLEOS | A o B | 830 | 11.74 | 1.02 | 0.0869 | 266 | 3.06 | 1.12
 | C | 850 |  | 1.08 | 0.092 | 281
FUELÓLEOS | Nº1 | 944 | 11.28 | 0.94 | 0.0833 | 265 | 3.18 | 1.11
ELECTRICIDAD
 |  |  |  | Toneladas equivalentes de petróleo (1) |  | Emisiones de CO2 (1) (2) |  | Factor [NAME] final a energía primaria Fp/f (2)
 |  |  |  | [tep/MWh] |  | [gCO2/kWh] | [tCO2/tep] | [unidades energía primaria/ unidades energía final]
ELECTRICIDAD CONSUMIDA |  |  |  | 0.086 |  | 786 | 9.14 | 3
Fuente: IDAE (noviembre 2010)
(*) t: [NAME]
(1) Factores de conversión a tep y para emisiones de CO2 referentes a energía final consumida
(2) Fuente: Estadísticas Energéticas de Canarias
Spreadsheet: 770642d1646209872-pasting-column-data-into-selected-cells-of-a-column-book1
Sheet: Sheet1

22R | 1
22R | 3
22R | 2
22R | 6
22R | 4
22R | 3
22R | 9
Spreadsheet: 83182d1283226563-group-multiple-rows-by-earliest-date-group-by-first-date
Sheet: Sheet1

Starting Data |  |  |  |  | Desired Result
Code | Date |  |  |  | Code | Date
ABC123 | 2010-10-16 00:00:00 |  |  |  | ABC123 | 2010-10-16 00:00:00
ABC123 | 2010-10-16 00:00:00 |  |  |  | ABC123 | 2010-10-16 00:00:00
ABC123 | 2010-10-16 00:00:00 |  |  |  | ABC123 | 2010-10-16 00:00:00
ABC123 | 2010-10-16 00:00:00 |  |  |  | ABC123 | 2010-10-16 00:00:00
ABC123 | 2010-10-16 00:00:00 |  |  |  | ABC123 | 2010-10-16 00:00:00
TRG456 | 2010-10-16 00:00:00 |  |  |  | ABC123 | 2010-10-17 00:00:00
TRG456 | 2010-10-16 00:00:00 |  |  |  | ABC123 | 2010-10-17 00:00:00
DEF345 | 2010-10-16 00:00:00 |  |  |  | ABC123 | 2010-10-17 00:00:00
DEF345 | 2010-10-16 00:00:00 |  |  |  | ABC123 | 2010-10-18 00:00:00
DEF345 | 2010-10-16 00:00:00 |  |  |  | ABC123 | 2010-10-18 00:00:00
DEF345 | 2010-10-16 00:00:00 |  |  |  | ABC123 | 2010-10-18 00:00:00
DEF345 | 2010-10-16 00:00:00 |  |  |  | TRG456 | 2010-10-16 00:00:00
ABC123 | 2010-10-17 00:00:00 |  |  |  | TRG456 | 2010-10-16 00:00:00
ABC123 | 2010-10-17 00:00:00 |  |  |  | TRG456 | 2010-10-17 00:00:00
ABC123 | 2010-10-17 00:00:00 |  |  |  | TRG456 | 2010-10-17 00:00:00
DEF345 | 2010-10-17 00:00:00 |  |  |  | TRG456 | 2010-10-17 00:00:00
TRG456 | 2010-10-17 00:00:00 |  |  |  | TRG456 | 2010-10-17 00:00:00
TRG456 | 2010-10-17 00:00:00 |  |  |  | TRG456 | 2010-10-23 00:00:00
TRG456 | 2010-10-17 00:00:00 |  |  |  | TRG456 | 2010-10-23 00:00:00
TRG456 | 2010-10-17 00:00:00 |  |  |  | DEF345 | 2010-10-16 00:00:00
DEF345 | 2010-10-17 00:00:00 |  |  |  | DEF345 | 2010-10-16 00:00:00
DEF345 | 2010-10-18 00:00:00 |  |  |  | DEF345 | 2010-10-16 00:00:00
DEF345 | 2010-10-18 00:00:00 |  |  |  | DEF345 | 2010-10-16 00:00:00
ABC123 | 2010-10-18 00:00:00 |  |  |  | DEF345 | 2010-10-16 00:00:00
ABC123 | 2010-10-18 00:00:00 |  |  |  | DEF345 | 2010-10-17 00:00:00
ABC123 | 2010-10-18 00:00:00 |  |  |  | DEF345 | 2010-10-17 00:00:00
DAZ467 | 2010-10-18 00:00:00 |  |  |  | DEF345 | 2010-10-18 00:00:00
DAZ467 | 2010-10-18 00:00:00 |  |  |  | DEF345 | 2010-10-18 00:00:00
DAZ467 | 2010-10-18 00:00:00 |  |  |  | DAZ467 | 2010-10-18 00:00:00
DAZ467 | 2010-10-18 00:00:00 |  |  |  | DAZ467 | 2010-10-18 00:00:00
DAZ467 | 2010-10-18 00:00:00 |  |  |  | DAZ467 | 2010-10-18 00:00:00
TRG456 | 2010-10-23 00:00:00 |  |  |  | DAZ467 | 2010-10-18 00:00:00
TRG456 | 2010-10-23 00:00:00 |  |  |  | DAZ467 | 2010-10-18 00:00:00
DAZ467 | 2010-10-23 00:00:00 |  |  |  | DAZ467 | 2010-10-23 00:00:00
DAZ467 | 2010-10-23 00:00:00 |  |  |  | DAZ467 | 2010-10-23 00:00:00
Spreadsheet: 27e1420a-22a1-472b-a696-65229cf77692
Sheet: Sheet1

Unnamed: 0 | State of New Hampshire - Primary Election | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
2012-09-11 00:00:00 | Governor - Democratic
Rockingham County | [NAME], d | [NAME], d | [NAME], d | Ovide Lamontagne, r | [NAME], r | [NAME], r | [NAME]
Atkinson | 58 | 271 | 41 | 3 | 2
Auburn | 73 | 210 | 22 | 1 |  |  | 1
Brentwood | 62 | 212 | 17 | 1
Candia | 80 | 148 | 15
Chester | 52 | 145 | 17 | 2 | 1 |  | 1
Danville | 40 | 122 | 26 | 1
[NAME] | 176 | 110 | 8 | 2
[NAME] | 224 | 693 | 92
East Kingston | 17 | 104 | 8 |  | 1
Epping | 110 | 182 | 10 |  |  |  | 1
Exeter | 284 | 1455 | 33 | 2 |  |  | 1
Fremont | 39 | 135 | 8 |  |  |  | 1
Greenland | 96 | 163 | 14
Hampstead | 81 | 251 | 33 | 4
Hampton | 323 | 710 | 60 | 6 |  |  | 1
[NAME] | 15 | 106 | 3 |  | 1 |  | 1
Kensington | 35 | 152 | 9
Kingston | 42 | 220 | 19 |  | 2
[NAME] | 209 | 765 | 69 | 9 | 15 |  | 1
New Castle | 94 | 99 | 4
Newfields | 44 | 122 | 7
Newington | 39 | 45 | 1
Newmarket | 257 | 555 | 45 | 1 | 3 |  | 2
Newton | 28 | 126 | 14 |  | 2
[NAME] | 133 | 240 | 13
Northwood | 165 | 109 | 23
[NAME] | 184 | 105 | 11 |  | 2
Plaistow | 55 | 134 | 33 | 5 | 2
Portsmouth Ward 1 | 174 | 213 | 29 |  |  |  | 1
Portsmouth Ward 2 | 227 | 298 | 15 |  |  |  | 1
Portsmouth Ward 3 | 182 | 194 | 26 |  |  |  | 2
Portsmouth Ward 4 | 116 | 173 | 21 | 1
Portsmouth Ward 5 | 248 | 308 | 9 | 2
[NAME] | 98 | 231 | 32 | 1 |  |  | 1
Rye | 151 | 373 | 18 |  | 1 |  | 1
Salem | 261 | 653 | 174 | 4 | 9 |  | 4
Sandown | 41 | 155 | 41 | 1
Seabrook | 29 | 183 | 23
[NAME] | 7 | 44 | 1
Stratham | 118 | 482 | 16 | 3 | 1
Windham | 102 | 344 | 25 | 5 | 5 |  | 1
TOTALS | 4769 | 11340 | 1085 | 54 | 47 |  | 21
Spreadsheet: 422ffb9c-7874-44fd-bcd4-c18fceb41d7e
Sheet: Sheet1

Table 2--World cotton supply and use estimates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  |  | 2012/13
Item | 2011/12 |  | Oct. |  | Nov. |  | Dec.
 | Million 480-lb. [NAME]
Supply:
Beginning stocks--
World | 48.93 |  | 69.56 |  | 69.63 |  | 69.18
Foreign | 46.33 |  | 66.21 |  | 66.28 |  | 65.83
Production--
World | 124.27 |  | 116.32 |  | 116.83 |  | 116.9
Foreign | 108.69 |  | 99.04 |  | 99.39 |  | 99.65
Imports--
World | 44.8 |  | 36.46 |  | 36.6 |  | 37.71
Foreign | 44.78 |  | 36.46 |  | 36.6 |  | 37.71
Use:
[NAME] use--
World | 103.21 |  | 106.87 |  | 106.33 |  | 106.48
Foreign | 99.91 |  | 103.47 |  | 102.93 |  | 103.08
Exports--
World | 45.86 |  | 36.45 |  | 36.6 |  | 37.73
Foreign | 34.14 |  | 24.85 |  | 25 |  | 25.93
Ending stocks--
World | 69.18 |  | 79.11 |  | 80.27 |  | 79.64
Foreign | 65.83 |  | 73.51 |  | 74.47 |  | 74.24
 | Percent
Stocks-to-use ratio:
World | 67 |  | 74 |  | 75.5 |  | 74.8
Foreign | 65.9 |  | 71 |  | 72.4 |  | 72
 | 3
Last update: 12/12/12.
Source: USDA, World Agricultural Outlook Board.
Spreadsheet: 851616d1701804372-conditional-formatting-using-responses-from-ms-forms-scheduling-test-1-
Sheet: VUTEK 3R's

T1 | 37.63 | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 2 Pass | 2024-01-15 00:00:00 |  |  | For production quote- [NAME]
Spreadsheet: 34185d1231339078-create-a-conditional-string-conditional-string
Sheet: Sheet1

List |  | String
111 |  | 111
222 |  | 111 222
333 |  | 111 222 333
444 |  | 111 222 333 444
111 |  | 111 222 333 444 111
555 |  | 111 222 333 444 111 555
222 |  | 111 222 333 444 111 555 222
666 |  | 111 222 333 444 111 555 222 666
888 |  | 111 222 333 444 111 555 222 666 888
777 |  | 111 222 333 444 111 555 222 666 888 777
Array: [String]
Spreadsheet: 133861d1324714317-function-to-get-the-latest-date-extract-max-date
Sheet: Data

ID number | Dates
4 | 2010-10-26 00:00:00
4 | 2010-10-25 00:00:00
4 | 2010-10-23 00:00:00
10 | 2010-11-28 00:00:00
10 | 2010-11-27 00:00:00
15 | 2010-12-14 00:00:00
15 | 2010-12-16 00:00:00
15 | 2010-12-13 00:00:00
28 | 2010-01-16 00:00:00
28 | 2010-01-21 00:00:00
28 | 2010-01-18 00:00:00
Spreadsheet: 127705d1320497356-spread-cell-value-over-multiple-cell-based-on-dates-orders-spread
Sheet: Trial

 |  | Target | FTE | Months | Value ($K) | Award | Status |  | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00
 |  | Client X - Strategic Plan | 1 | 3 |  | 2012-10-01 00:00:00
Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1207-DFM 3022-01

Phase | Project No. | Segment ID (GIE) | Route No. | Facility Type | Pipe O.D., in. | Segment Length, ft | Proposed [NAME] | Proposed End M.P. | Proposed total length, ft. | Proposed [NAME], in. | Segment Length per Construction Classification, ft |  |  | Bored Crossings |  | HDDs |  | Potential Re-route | Move-arounds | Comments, notes, assumptions
 |  |  |  |  |  |  |  |  |  |  | Non-cong. | Semi-cong. | High-cong. | Q-ty | Length, Feet | Q-ty | Length, Feet | Yes/No | Q-ty |  | [NAME] | MP1 | MP2 | JNTEFF | GIRTH_WELD | LONG_SEAM | JOINT_TYPE | [NAME] | W_THICK | TEST_DATE | TEST_PRESS | [NAME] | TEST_DUR | MAOP | SMYS_MAOP | MOP | SMYS_MOP | YR_INSTALL | CLASSESENT | HCA_ID | SCC_THREAT | MANU_HREAT | CONSTHREAT | OF_THREAT | HS_THREAT | Legend Name | PerSMYS | TestPer | Sub_J | Fab_Note | Threat | Seismic | Object_ID | Shape_Length
1 | 1207 | 15350 | 3022-01 | DFM | 6.625 | 5 | 0 | 0 | 5 | 6.625 |  | 5 |  |  |  |  |  |  |  |  | 104 | 0 | 0 | -1.000 |  |  |  | -35000 | -0.156 |  | 0 |  | 0 | 0 | 0 | -722 | -43.8027 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -43.8 | 0 | N |  |  |  | 21248 | 1.627992885187268
Spreadsheet: 93250d1292863833-sum-matching-text-value-in-table-based-on-list-crew-cost
Sheet: Sheet1

 | Crew # | Weekly Cost |  | Week | Crew 1 | Crew 2 | Crew 3 | Crew 4 | Crew 5 | Crew 6 | Crew 7 | Crew 8 | Crew 9 | Crew 10
 | 1 | 4500 |  | 2010-12-13 00:00:00 | x |  | x | x |  |  |  | x | x | x
 | 2 | 5000 |  | 2010-12-20 00:00:00 | x |  | x | x |  |  |  | x | x | x
 | 3 | 5000 |  | 2010-12-27 00:00:00 | x |  | x | x |  |  |  | x | x | x
 | 4 | 5500 |  | 2011-01-03 00:00:00 | x | x | x | x | x | x | x
 | 5 | 4500 |  | 2011-01-10 00:00:00 | x | x | x | x | x | x | x
 | 6 | 6000 |  | 2011-01-17 00:00:00 | x | x | x | x | x | x | x
 | 7 | 6500 |  | 2011-01-24 00:00:00 | x | x | x | x | x | x | x
 | 8 | 6500 |  | 2011-01-31 00:00:00 | x | x | x | x | x | x | x
 | 9 | 4000 |  | 2011-02-07 00:00:00 | x | x |  |  | x | x | x
 | 10 | 6500 |  | 2011-02-14 00:00:00 | x | x |  |  | x | x | x
 |  |  |  | 2011-02-21 00:00:00 | x | x |  |  | x | x | x
 |  |  |  | 2011-02-28 00:00:00 | x |  |  |  | x | x | x
 |  |  |  | 2011-03-07 00:00:00 | x |  |  |  | x | x | x
 |  |  |  | 2011-03-14 00:00:00 | x |  |  |  | x | x | x
 |  |  |  | 2011-03-21 00:00:00 | x |  |  |  |  | x | x
 |  |  |  | 2011-03-28 00:00:00 | x |  |  |  |  | x | x
 |  |  |  | 2011-04-04 00:00:00 | x |  |  |  |  | x | x
 |  |  |  |  | x
 |  |  |  | #N/A
 |  |  |  | #N/A
Spreadsheet: 106102d1303323339-false-negatives-in-nested-vlookup-confirmed-billing-error
Sheet: Billable Activity

Work Order# | Start Date | Suite | User Name | Start Time | End Time | Billable | Non-Billable | Project Name | Edit Type | Type | Format | Q# | SA NAME | CONFIRMED?
2-1007590 | 2011-04-08 00:00:00 | Suite 44 | [NAME] | 2011-04-08 09:00:00 | 2011-04-08 17:30:00 | 8.5 | 0 | 2097745 | HD
2-1007591 | 2011-04-11 00:00:00 | Suite 44 | [NAME] | 2011-04-11 09:00:00 | 2011-04-11 18:00:00 | 9 | 0 | 2097745 | HD
2-1007592 | 2011-04-12 00:00:00 | Suite 44 | [NAME] | 2011-04-12 09:00:00 | 2011-04-12 19:00:00 | 10 | 0 | 2097745 | HD
2-1007593 | 2011-04-13 00:00:00 | Suite 44 | [NAME] | 2011-04-13 09:30:00 | 2011-04-13 18:00:00 | 8.5 | 0 | 2097745 | HD
2-1007594 | 2011-04-14 00:00:00 | Suite 44 | [NAME] | 2011-04-14 09:00:00 | 2011-04-14 22:00:00 | 13 | 0 | 2094085 | HD
2-1007596 | 2011-04-18 00:00:00 | Suite 44 | [NAME] | 2011-04-18 09:00:00 | 2011-04-18 18:00:00 | 9 | 0 | 2094085 | HD
2-1010978 | 2011-04-18 00:00:00 | Suite 44 | [NAME] | 2011-04-18 18:00:00 | 2011-04-18 19:00:00 | 1 | 0 | 2108924 | HD
2-1007597 | 2011-04-19 00:00:00 | Suite 44 | [NAME] | 2011-04-19 09:00:00 | 2011-04-19 22:00:00 | 13 | 0 | 2097745 | HD
Spreadsheet: 78495d1278901623-creating-a-progress-chart-training-sample
Sheet: Data

Name | Course
[NAME] | Basic Excel
[NAME] | Basic Powerpoint
[NAME] | Basic Office
[NAME] | Basic Word
[NAME] | Basic Excel
[NAME] | Basic Powerpoint
[NAME] | Advanced Office
[NAME] | Management I
[NAME] | Basic Excel
[NAME] | Advanced Word
[NAME] | Advanced Powerpoint
[NAME] | Advanced Excel
[NAME] | Basic Powerpoint
[NAME] | Advanced Powerpoint
Spreadsheet: john_griffith__15641__05_08_01ON
Sheet: Sheet1

N
Commodity: | ON - NAT. GAS OPTS.
Month | STRIKE | BID | OFFER | Volatility | Future
M01-P/C | 425 | 39 | 42
N01-P/C | 435 | 66 | 68
Q01-P/C | 440 | 85 | 88
U01-P/C | 445 | 103 | 106
V01-P/C | 445 | 117 | 121
X01-P/C | 465 | 135 | 138
[NAME]-P/C | 485 | 155.5 | 158
F02-P/C | 490 | 168 | 174
G02-P/C | 480 | 174 | 179
H02-P/C | 460 | 156 | 162
J02-P/C | 430 | 120 | 124
K02-P/C | 425 | 108 | 118
U02_P/C | 435 | 129 | 137
Spreadsheet: 165907d1341395737-calculate-time-related-values-as-minute-average-forum
Sheet: Arkusz2

Time | Time1 | Helper
06:00:13 | 99
06:00:38 | 118 |  |  |  | Etykiety wierszy | Średnia z Time1
06:00:48 | 102 |  |  |  | 0 | 106.3333333333333
06:01:18 | 125 |  |  |  | 1 | 102.25
06:01:23 | 126 |  |  |  | 2 | 100.9230769230769
06:01:33 | 105 |  |  |  | 3 | 108.6666666666667
06:01:38 | 110 |  |  |  | 4 | 106.7692307692308
06:01:43 | 118 |  |  |  | 5 | 106
06:01:48 | 84 |  |  |  | Suma końcowa | 104.62
06:01:49 | 76
06:01:53 | 74
06:02:03 | 114
06:02:07 | 123
06:02:16 | 106
06:02:17 | 96
06:02:18 | 98
06:02:22 | 97
06:02:23 | 101
06:02:24 | 91
06:02:27 | 79
06:02:28 | 79
06:02:32 | 110
06:02:37 | 110
06:02:47 | 108
06:03:11 | 116
06:03:12 | 131
06:03:42 | 76
06:03:52 | 103
06:03:57 | 108
06:03:58 | 118
06:04:02 | 97
06:04:11 | 122
06:04:17 | 101
06:04:22 | 101
06:04:27 | 96
06:04:28 | 95
06:04:32 | 111
06:04:37 | 115
06:04:38 | 112
06:04:42 | 108
06:04:47 | 109
06:04:52 | 114
06:04:57 | 107
06:05:12 | 114
06:05:22 | 95
06:05:23 | 111
06:05:47 | 107
06:05:48 | 117
06:05:57 | 99
06:05:58 | 99
Spreadsheet: 272491d1382402892-how-to-target-a-cell-by-the-data-it-contains-ef509_dashboard_summaries
Sheet: Dashboard

 | last row | Avg Total hours/fortnight | Absenteeism /fortnight | Total Overtime Hours | [NAME]/fortnight | Total Overtime Shifts | [NAME]/fortnight | Worked over # pay cycles
Employee_1
Employee_2
Spreadsheet: 740714d1626492979-hierachy-of-consequence-work-file
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Consequence
Sl | ID | Name | Category | Count | Instance | Consequence | Actual to be | Remarks |  |  |  | Violation | First Instance | Second Instance | Third Instance | Fourth Instance
1 | 12 | ABCD | Violation-2 |  |  |  |  |  |  |  |  | Violation-1 | [NAME]
 | 10 | ADS | Violation-3 |  |  |  |  |  |  |  |  | Violation-2 | Final Warning | [NAME]
 | 1 | BSR | Violation-4 |  |  |  |  |  |  |  |  | Violation-3 | First Warning | Final Warning | [NAME]
 | 22 | RSP | Violation-3 |  |  |  |  |  |  |  |  | Violation-4 | Verbal Warning | First Warning | Final Warning | [NAME]
 | 12 | ABCD | Violation-4 |  |  |  | [NAME] | Already Final Warning is issued, on second instance consequence shall be [NAME]
 | 1 | BSR | Violation-4 |  |  |  | Final Warning | Already First Warning is issued, on second instance consequence shall be Final Warning
 | 21 | [NAME] | Violation-1
 |  | Can someone to help me resolve this issue.
 |  | I am looking for a formula where if a person got the warning for the first instance, second instance consequence has to go to the next level of warning even if the severity of the violation & the consequence for the violation is low.
Spreadsheet: 877636d1724428444-entering-a-cell-number-to-control-a-formula-test-spreadsheet
Sheet: Test 

 |  |  | SS/FS | Cell Ref | + Days |  | Start | Complete | Days
 |  |  |  |  |  |  | 2024-08-04 00:00:00 |  | 5
 |  |  | FS | I3 | 2 |  | 2024-08-11 00:00:00 |  | 7
 |  |  | SS | H5 | 7 |  | 2024-08-27 00:00:00 |  | 4
 |  |  | FS | I5 | 9
 |  |  | FS |  | 12
Spreadsheet: 0bfa01f0-656d-433c-bdbf-d2e5e88245d9
Sheet: Lookups

elapsedTime | physicalNumberProximity | numberUsers | numberPrivilegedUsers | numberPrivilegedUserTypes | numberTypesTraining | numberNetworkedDevices | numberSecurityComponents | numberDomainsZones | numberTechnologies | numberSecurityBoundaries | numberInterconnections | userConnectMethods | accessMethods | fips199Categorization
<6 months | 1 location | 1-100 | 1-25 | 1-5 | <3 | 1-49 | <5 | 0-5 | 1-5 | 1 | <3 | LAN Only | Only one interface (whether public or private) | Low
6-12 months | 2-4 locations | 101-250 | 25-75 | 6-15 | 3-5 | 50-149 | 5-25 | 6-15 | 6-7 | 2-3 | 3-5 | LAN and Internet | Both a public interface and a private interface, provided through separate enclaves | Moderate
>12 months | 5+ locations | 250+ | >75 | >15 | >5 | 150+ | >25 | >15 | 8+ | >3 | >5 | VPN or Private Network | Both public and private interfaces, provided through a single enclave | High
CLINs Requested Sheet
clinsYesNo
Yes
No
Release Statement | yesNo |  | numberAppsDBs
Publicly Releasable | Yes |  | 1-3
For Official Use Only | No |  | 4-5
Other |  |  | 6+