tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 737789d1624605928-vlookup-2-conditions-pb_sample
Sheet: Names

 |  |  | RANK |  |  |  | NAME |  | ACTIVE
 |  |  | 4 | 79601.75 | 20 | 3980.0875 | Sharleen | B | INACTIVE
 | 28 | 76859.890028 | 3 | 28057.78 | 7 | 4008.254285714286 | Alimba | M | ACTIVE
 | 29 | 28057.780029 | 1 | 37591.22 | 7 | 5370.174285714286 | Nelly | M | ACTIVE
 | 30 | 37591.22003 | 2 | 76859.89 | 19 | 4045.257368421052 | Diego C | M | ACTIVE
 |  |  |  | Inactive people should not appear in the List tab
Spreadsheet: 719369d1613650767-compare-the-value-to-matrix-and-provide-out-as-count-compare-and-count
Sheet: Sheet1

 | Table 1 |  | Class
 | Topics | Category | AB | BC | CD
 | 1+1 = 2 | A | Y | Y
 | Enjoy View | A | Y | Y
 | Sky is blue | B |  | Y | Y
 | Love Earth | B | Y | Y | Y
 | Sun is RED | C | Y | Y | Y
 | Grow Trees | C | Y | Y
 | Water is colurless | D |  | Y | Y
 | Conserve Water | D |  | Y | Y
 |  |  | Class
 |  | Category | AB | BC | CD
 |  | A | 2 | 2
 |  | B | 1 | 2 | 2
 |  | C | 2 | 2
 |  | D |  | 2 | 2
 | No. of Topics under each category to be updated against respective class
 | Input details are section in YELLOW and based on the input, output to be updated in GREY
Spreadsheet: 55871d1256045005-sum-if-array-sumif
Sheet: Summary

INVOICE ANALYSIS
EQUIPMENT | SALES REVENUE | AVERAGE DAYS HIRED |  | MONTH | SALES  REVENUE
Chainsaws |  |  |  | January
Lawnmowers |  |  |  | February
[NAME] |  |  |  | March
Basic Toolkits |  |  |  | April
Heavy Toolkits |  |  |  | May
Strimmers |  |  |  | June
Rotavators |  |  |  | July
[NAME] |  |  |  | August
TOTAL |  |  |  | September
CHECK |  | - |  | October
 |  |  |  | November
 |  |  |  | December
 |  |  |  | CHECK
EQUIPMENT | No. HIRED  (Schools) | GROSS SALES REVENUE | GROSS SALES AS % OF TOTAL REVENUE | DISCOUNT AMOUNT | DISCOUNT %
Chainsaws
Lawnmowers
[NAME]
Basic Toolkits
Heavy Toolkits
Strimmers
Rotavators
[NAME]
TOTAL
INVOICES SHEET TOTAL |  |  | - |  | -
CHECK |  |  | - |  | -
HIGHEST SALES REVENUE
EQUIPMENT | No. HIRED (Community Groups) | GROSS SALES REVENUE | GROSS SALES AS % OF TOTAL REVENUE | DISCOUNT AMOUNT | DISCOUNT %
Chainsaws
Lawnmowers
[NAME]
Basic Toolkits
Heavy Toolkits
Strimmers
Rotavators
[NAME]
TOTAL
INVOICES SHEET TOTAL |  |  | - |  | -
CHECK |  |  | - |  | -
HIGHEST SALES REVENUE
EQUIPMENT | No. HIRED | GROSS SALES REVENUE | GROSS SALES AS % OF TOTAL REVENUE | DISCOUNT AMOUNT | DISCOUNT %
Chainsaws
Lawnmowers
[NAME]
Basic Toolkits
Heavy Toolkits
Strimmers
Rotavators
[NAME]
TOTAL
INVOICES SHEET TOTAL | =SUM(IF(LEFT(INVOICES[CUSTOMER ID],1)="S",IF(LEFT(INVOICES[CUSTOMER ID],1)="C",1,0)) |  | - |  | - | =SUM(IF($D510:$G510,"=0",IF($L510="ONGOING",1,0)))
CHECK |  |  | - |  | - | =SUM(IF((A2:A10="Fax")+(B2:B10="Jones"),1,0))
MAXIMUM |  |  | - |  | -
MINAMUM |  |  | - |  | -
AVERAGE |  |  | - |  | -
Spreadsheet: 701792d1603932150-formula-for-specific-cell-to-trigger-from-multiple-drop-downs-book2
Sheet: Sheet2

GSR |  | Post Doc
Step | Salary | Step | Salary
 | 42729 | 0 | 53460
2 | 46053 | 1 | 55596
3 | 51072 | 2 | 57456
4 | 55163 | 3 | 59580
5 | 58834 | 4 | 61800
6 | 61565 | 5 | 64008
7 | 66497
8 | 71787
9 | 77547
10 | 83727
GSR | 0
Post Doc | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
Spreadsheet: 137854d1327410594-calculating-week-and-highlighting-cells-vacation_planner_final_2
Sheet: March

Week # |  | 1 |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 4 |  |  |  |  |  |  | 5
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | Total | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar | Mar
 | March
Spreadsheet: 71322d1271984622-excel-2007-how-to-add-a-duplicate-condition-to-if-formula-test-20v2-1-
Sheet: Sheet1

 | Tracking Number | Processed | [NAME] | 2nd Scan
991120330008956 |  |  |  |  | 991120330008977
991120330008957 |  |  |  |  | 991120330008958
991120330008958 |  |  |  |  | 991120330008970
991120330008959 |  |  |  |  | 8796789
991120330008960 |  |  |  |  | 991120330008967
991120330008961
991120330008962
991120330008963
991120330008964
991120330008965
991120330008966
991120330008967
991120330008968
991120330008969
991120330008970
991120330008956
991120330008972
991120330008973
991120330008957
991120330008975
991120330008976
991120330008977
991120330008978
991120330008979
991120330008980
991120330008981
991120330008982
991120330008983
991120330008984
991120330008956
8796789
Spreadsheet: 785670d1656535032-conditional-formatting-to-identify-duplicates-over-several-cells-book1-etaf
Sheet: Sheet1

 |  | Date | Sample | Batch
 |  | 2022-06-22 00:00:00 | A | 13
 |  | 2022-06-01 00:00:00 | B | 6
 |  | 2022-06-24 00:00:00 | A | 2
 |  | 2022-06-01 00:00:00 | C | 11
 |  | 2022-06-01 00:00:00 | C | 4
 |  | 2022-06-13 00:00:00 | C | 13
 |  | 2022-06-22 00:00:00 | A | 13
Spreadsheet: 866808d1713729653-using-vlookup-to-find-different-instances-vlookup
Sheet: Sheet1

 |  |  |  |  | job no | result1 | [NAME]
 |  |  |  |  | 444 | TRAIN | CAR
 | Job No
 | 444 | TRAIN
 | 666 | BUS |  |  | WOULD LIKE TO REPEAT PROCESS SO IT PICKS UP CAR AS SECOND OPTION
 | 777 | CAR
 | 888 | BUS
 | 444 | CAR
 | 555 | BIKE
Spreadsheet: john_griffith__15638__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 | 430 | 66 | 68
Q01-P/C | 440 | 85 | 88
U01-P/C | 440 | 103 | 106
V01-P/C | 445 | 117 | 121
X01-P/C | 465 | 135 | 138
[NAME]-P/C | 480 | 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
Spreadsheet: 08cae973-a59a-40cd-8bd1-14481440a549
Sheet: 24

 |  | Transactions
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated swap dollar volumes, week ending January 18, by product type and cleared status (value of all trades in millions of USD), all participant types, tenors, and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 740440d1626343071-count-the-number-of-occurrences-in-a-table-plot-count
Sheet: Osma

Plot No |  |  |  | No 0f
 | Lymner | [NAME]
 | Cutler | [NAME]
 | Coppersmith M4(2) | [NAME]
 | Cobbler M4(2) | [NAME]
 | Mason | [NAME]
 | Baxter | [NAME]
 | Japonica SP | [NAME]
 | Blacksmith / Blacksmith | Semi
 | Thespian / Tailor | Semi
 | Joiner / Joiner | Semi
 | Single Garage | [NAME]
 | Double Garage | [NAME]
 | Tailor / Tailor | semi
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Spreadsheet: rick_buy__32777__Daily Treas By BU Q3
Sheet: Sept

 | Net Cash Source / (Use)
 | Current Day and Month to Date
 | Sept 2001
 |  |  |  |  | Total
 |  |  |  |  | Month to Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00
 | Enron Transportation Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.4 | 1.3 | -0.8 | -1.2 | 0 | 0 | 0
 | Portland General Electric |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Distribution
 | Enron North America |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93.5 | 269.8 | -3 | 136.9 | 0 | 0 | 0
 | Enron South America |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Americas
 | Europe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -16.2 | 0.9 | -10 | -7.9
 | Global Markets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -7.7 | 43.5 | -28.3 | -6.1
 | Industrial Markets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3 | -0.7 | -1.4 | 2.6
 | Networks |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.9 | -0.7 | -1.2 | -1.1
 | Other |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -0.1 | -0.2 | 0 | 0
 | Total Traditional Wholesale
 | Enron Broadband Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.1 | -0.8 | -1.1 | -0.8
 | EGEP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.2 | 6.8 | 0 | 0.4
 | Other Wholesale (EE&CC) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -12 | -6 | -7.4 | 9
 | Total Wholesale
 | Enron Energy Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.7 | -13.9 | 2.2 | 9.6
 | Enron Global Assets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.9 | 0.2 | 1.1 | -0.8 | 0 | 0 | 0
 | Corp |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -9.3 | -29.1 | 12.7 | -92.4 | 0.1
 | Other |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Enron
 | ONLY includes cash movement monitored from Houston.
 | Does NOT include Canada, London or any other banking center.
 | Certain items such as payroll that is paid by Corp on behalf of a business unit has NOT been allocated to the business units
Spreadsheet: 848366d1699086329-tiered-bonus-structure-bonus-structure-ans
Sheet: Sheet1 (2)

Bonus Structure
 |  | 60000 | 90000
 |  | 0.15 | 0.25 | 0.35
Quarter | Income | Tier 1 | Tier 2 | Tier 3 | Total
1st | 65819 | 872.85 | 0 | 0
2nd | 30665 | 0 | 0 | 0
3rd | 131885 | 4500 | 7500 | 4159.75
4th | 25065 | 0 | 0 | 0
Total
Spreadsheet: darrell_schoolcraft__7827__imbalsumm0110
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 15647 | 15382 | -17185 | -15000
2 | 16345 | 16343 | -32177 | -31880
3 | 16347 | 16343 | -48681 | -45990
4 | 21176 | 21343 | -22645 | -19747
5 | 21302 | 21343 | -42584 | -42866
6 | 18399 | 18394 | -42956 | -43347
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-09-30 00:00:00 |  |  |  |  | 122493
2001-10-06 00:00:00
CBS Dollars
 |  |  | 323932
Spreadsheet: 96928d1296164312-excel-2007-getting-only-selcted-rows-to-transfer-to-a-new-sheet-for-printing-sample-sheet
Sheet: dec

Last Name | First Name | MI | Address | City | State | Zip | Phone | FAX | E-Mail | Salary | Insurance | 401K
Applegate | [NAME] | A | 3180 Cross Fox Ave. | [NAME] | FL. | 33860 | 8634251442 | 8636646542 |  | 65500 | No | Yes
[NAME] | Briana | J | 3845 Eddie Dr. | [NAME] | FL. | 33860 | 8634256699 | 8636465623 |  | 55600 | Yes | Yes
[NAME] | [NAME] | R | 5995 Becker Ave | [NAME] | FL. | 33860 | 8634257788 | 8636465120 | [EMAIL] | 49500 | Yes | No
[NAME] | Fred | W | 228 Miami Ave. | [NAME] | FL. | 33860 | 8634257788 | 8636547923.95935 |  | 72500 | Yes | No
O'Neal | Gina | V | 2233 Burns St. | [NAME] | FL. | 33860 | 8634257700 | 8636507494.4393 |  | 59600 | Yes | Yes
Oconner | Carmen | M | 554 Weber St. | [NAME] | FL. | 33860 | 8634250236 | 8636502440.7493 |  | 55600 | Yes | Yes
First | Brittany | J | 4942 [NAME] | [NAME] | FL. | 33860 | 8634250895 | 8636371044.80915 |  | 27000 | Yes | Yes
Hicks | Leroy | J | 939 [NAME]. | [NAME] | FL. | 33860 | 8634259920 | 8636365991.11914 |  | 38000 | Yes | Yes
Ralley | Lesley | J | 3443 Barkley Ave. | [NAME] | FL. | 33860 | 8634259802 | 8636360937.42914 |  | 44500 | No | Yes
Green | [NAME] | S | 21 Ashley Ave. | [NAME] | FL. | 33860 | 8634251133 | 8636355883.73913 |  | 25000 | No | No
McDottle | Mural | K | [NAME]. | [NAME] | FL. | 33860 | 7942935589.96731 | 8636290185.76906 |  | 42366.6666666667 | No | Yes
Witfield | Gina | F | 6652 Hayter Rd. | [NAME] | FL. | 33860 | 7605534394.28893 | 8636194165.65895 | [EMAIL] | 75000 | No | Yes
[NAME] | Victoria | N | 5433 Rebecca St. | [NAME] | FL. | 33860 | 7161585452.60684 | 8636067823.40879 |  | 55600 | No | No
[NAME] | Jarred | C | 136 High St. | Winter Haven | FL. | 33810 | 8637986565 | 8636839632 | [EMAIL] | 39200 | No | No
[NAME] | [NAME] | E | 1510 Ariana St. | Winter Haven | FL. | 33810 | 8636821478 | 8636598460.8594 |  | 72500 | No | No
Truman | [NAME] | B | 212 Ester Ave. | Winter Haven | FL. | 33810 | 8637945566 | 8636578246.09938 |  | 49500 | Yes | Yes
Lexington | [NAME] | E | 604 Garden St. | Winter Haven | FL. | 33810 | 8634895623 | 8636573192.40937 |  | 72500 | Yes | Yes
Zeller | Tara | O | 7 Casa Ave | Winter Haven | FL. | 33810 | 8636665914 | 8636426635.39921 |  | 32500 | No | Yes
Binder | [NAME] | K | PO Box 4321 | Winter Haven | FL. | 33810 | 8636651147 | 8636421581.70921 |  | 49500 | No | No
Bonita | [NAME] | M | 645 Park St. | Winter Haven | FL. | 33810 | 7925177632.30003 | 8636285132.07905 |  | 46016.6666666667 | Yes | Yes
Sanchez | Ophelia | G | 1726 Shorewood Rd. | Winter Haven | FL. | 33823 | 7356922986.94696 | 8636123413.99886 |  | 28500 | Yes | No
Spreadsheet: a250db6a-8bf4-48fc-b8df-1c99fb880427
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
opticalCON Power Budget Calculator
1. Mode and wavelength:
2. Attenuation properties:
Minimum transmit power 1) | 0 | [dBm] (available power, e.g. -10dB)
Minimum receive sensitivity 1) | 0 | [dBm] (e.g. -21dB)
Overal cable length 2) | 0 | [m] (e.g. 150m)
Number of connections 3) | 0
Number of splices 4) | 0
3. Calculation:
Power budget | 0 | [dB] (= transmit power - receive sensitivity)
- Overal cable attenuation | 0 | km of cable    x | -0.3 | dB/km    = | 0
- Overal connector attenuation | 0 | connections    x | -0.5 | dB/con.  = | 0
- Overal splice attenuation | 0 | splices            x | -0.1 | dB/spl.   = | 0
= Link margin | 0 | [dB]
- Safety system margin | -3 | [dB]
= Excess power | Not enough power! | [dB]
Notes:
1) ... Type in power values with the algebraic sign, values are usually negative!
Find power information's in the manual of your fiber optic transmitting / receiving device or ask the manufacturer.
2) ... Summarize the length of all involved cables between transmitter and receiver.
3) ... Count the numbers of physical contact connections. The connection into transmitter and receiver has no effect.
Example: Count 4 connections for an installation of two opticalCON drums, one opticalCON coupler
and two patch cables from / to the  transmitting / receiving device.
4) ... Running an installation (e.g. into a building) may add several fiber optic splices to a link.
Calculation is based on electrical arc splice technology. ( 0.2dB for multimode , 0.1dB for single-mode)
IMPORTANT ! This part number generator works with Excel macros, please select the macro security level "medium" or "low" when you want to work with it. Choose TOOLS / MACRO / SECURITY in the Excel pulldown menue to select the security level.
Spreadsheet: 6bee2ed5-90d9-44b5-8195-df40e2d5b086
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2014
 |  | Data Extracted on: July 22, 2014 (1:52 pm)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 229371
2004 | 229646 | 233241 | 235336 | 237875
2005 | 242085 | 244136 | 247183 | 247443
2006 | 250954 | 254990 | 258328 | 262731
2007 | 263776 | 266272 | 270025 | 272054
2008 | 276019 | 278206 | 280691 | 273572
2009 | 267266 | 267665 | 268736 | 271174
2010 | 273058 | 275612 | 279685 | 281383
2011 | 283078 | 290271 | 293177 | 293795
2012 | 297910 | 301286 | 303811 | 309614
2013 | 311967 | 314808 | 320087 | 326348
2014 | 329985 | X | X | X
Spreadsheet: b8a89ca5-748f-4137-ac75-4109b15a1eec
Sheet: Cash Flow

[NAME] AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF CASH FLOWS
(In thousands)
 |  |  |  |  | Year Ended July 31,
 |  |  |  |  | 2011 |  | 2010
Cash Flows From Operating Activities:
 | Net loss |  |  |  | -112305.9796998499 |  | -93672
 | Adjustments to reconcile net loss to net cash (used in) provided by
 |  | operating activities:
 |  | Non-cash interest |  |  | 34579.683 |  | 3380
 |  | Depreciation and amortization |  |  | 41325.5392139 |  | 50005
 |  | Deferred taxes |  |  | 5279.943859250014 |  | 39
 |  | Loss on disposition of property and equipment |  |  | 1430.747865249999 |  | 1005
 |  | Impairment of property and equipment |  |  | 6762 |  | 29944
 |  | Gain on warrants |  |  | 0 |  | -8315
 |  | Stock-based compensation |  |  | 2149.6 |  | 3865
 |  | Loss (earnings) from discontinued operations |  |  | 264 |  | -2118
 |  | Conversion of paid in kind interest to Senior Secured Term Loan |  |  | 0 |  | 1703
 | Changes in assets and liabilities:
 |  | Merchandise inventories |  |  | -8070.779866700004 |  | 42374
 |  | Other current assets |  |  | -6912.996876999994 |  | 10103
 |  | Other assets |  |  | -1982.25516 |  | 2071
 |  | Accounts payable and accrued liabilities |  |  | -3461.848234750019 |  | 24226
 |  | Other liabilities |  |  | -6004.976070749995 |  | -12288
Net cash (used in) provided by operating activities |  |  |  |  | -46946.32197064991 |  | 52322
Cash Flows From Investing Activities:
 | Payments for property and equipment |  |  |  | -15315.4910418685 |  | -14650
 | Purchase of available-for-sale investments |  |  |  | -9387.91228 |  | -2959
 | Proceeds from sales of available-for-sale investments |  |  |  | 6140.181439999999 |  | 2409
Net cash used in investing activities |  |  |  |  | -18563.2218818685 |  | -15200
Cash Flows From Financing Activities:
 | Borrowings under revolving credit agreement |  |  |  | 3604800 |  | 4465100
 | Payments on revolving credit agreement |  |  |  | -3514800 |  | -4610600
 | Proceeds from Senior Secured Term Loan |  |  |  | 0 |  | 150000
 | Debt issuance costs |  |  |  | 0 |  | -25523
 | Payments on Senior Secured Term Loan |  |  |  | -11250 |  | 0
 | Proceeds from exercise of stock options |  |  |  | 67.33500000000004 |  | 0
Net cash provided by (used in) financing activities |  |  |  |  | 78817.335 |  | -21023
Cash Flows Used in Discontinued Operations:
Net cash used in operating activities of discontinued operations |  |  |  |  | -5391 |  | -15395
Effect of exchange rate changes on cash |  |  |  |  | 972.6751573844967 |  | 544
Net change in cash and cash equivalents |  |  |  |  | 8890.466304866088 |  | 1248
Cash and cash equivalents at beginning of period |  |  |  |  | 26234.8718832 |  | 24987
Cash and cash equivalents at end of period |  |  |  |  | 35125.33818806609 |  | 26235
Spreadsheet: 09e6a2e2-2356-4f26-b5a7-d165817acf12
Sheet: SCTD1

Team | [NAME] | Set | PPG | PPB | 15PG
Bellaire (TX) | Texas Invitational | SCT D1 | 167.2 | 11.67
Bellarmine (CA) | Texas Invitational | SCT D1 | 386.9 | 19.43
Centennial (GA) | Texas Invitational | SCT D1 | 305.9 | 15.92
Chattahoochee (GA) | Texas Invitational | SCT D1 | 173.4 | 12.23
Cistercian (TX) | Texas Invitational | SCT D1 | 253.1 | 14.72
Detroit Catholic Central (MI) | Texas Invitational | SCT D1 | 315.6 | 17.08
Dorman (SC) | Texas Invitational | SCT D1 | 295 | 16.63
Georgetown Day (DC) | Texas Invitational | SCT D1 | 240.9 | 14.94
[NAME] (NY) | Texas Invitational | SCT D1 | 405.9 | 19.05
[NAME] (TX) | Texas Invitational | SCT D1 | 157.8 | 11.18
Kinkaid (TX) | Texas Invitational | SCT D1 | 65.6 | 6.77
LASA A (TX) | Texas Invitational | SCT D1 | 273.8 | 15.86
LASA B (TX) | Texas Invitational | SCT D1 | 196.6 | 12.3
Loyola (IL) | Texas Invitational | SCT D1 | 221.2 | 13.42
Seven Lakes (TX) | Texas Invitational | SCT D1 | 296.2 | 17.46
St. John's A (TX) | Texas Invitational | SCT D1 | 130.9 | 10.67
St. John's B (TX) | Texas Invitational | SCT D1 | 109.7 | 11.18
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 14b

Product1 | HY3 | IG | Other | TOTAL
Index Tranche | 7 | 3 | 3 | 13
Index | 2067 | 2001 | 3316 | 7384
Other | - | - | 37 | 37
TOTAL | 2074 | 2004 | 3356 | 7434
Spreadsheet: 715451d1611712482-combining-multiple-countif-statements-2021-scorecard-test
Sheet: CORE Process Audits

Assessment | # of Audits
Process Compliance Total
Area for assessment | # of Audits | # of findings | Audits w/findings | Clean Audits |  | Label
Peer Review |  | 25 | 19 | 47 |  | PEER_REVIEW_PROCESS_AUDIT
Peer_Deficient_Description |  | 0
Peer_Missing_Required_Fields |  | 6
Peer_No_Participation |  | 2
Peer_No_Independence |  | 1
Peer_No_Config_Control |  | 0
Peer_No_Criteria |  | 4
Peer_Unresolved_Issue |  | 1
Peer_Checklist_Issue |  | 9
Peer_No_Parent_Baseline |  | 2
Training |  | 0 |  |  |  | TRAINING
Training_Peer_Review |  | 0
Training_Risk |  | 0
Training_CCB |  | 0
[NAME] |  | 0
Change Mgmt |  | 2 | 2 | 6 |  | CHANGE_MGMT
PR_Deficient_Description |  | 0
PR_Unauthorized_Work |  | 0
PR_Implementation_Detail |  | 1
PR_Verification_Detail |  | 0
PR_No_Config_Control |  | 0
PR_No_Independence |  | 1
Risk |  | 0 |  |  |  | RISK_MGMT_ASSESSMENT
Risk_Opp_No_Management_Plan
Risk_Opp_No_Mitigation
Risk_Opp_No_Participation
Risk_Opp_No_Meetings
Risk_Opp_No_Authorized_Tool
Risk_Opp_Not_Documented
Risk_Opp_No_Owner
Risk_Opp_No_Burndown
Risk_Opp_No_Participation
Trace/Thread |  | 3 |  |  |  | TRACE_THREAD
Thread_Item_Incorrect |  | 1
Thread_Trace_Incorrect |  | 1
Thread_Incomplete |  | 1
Trace/Gap |  | 7 |  |  |  | TRACE_GAP
Trace_Missing |  | 7
Trace_Not_Required |  | 0
Trace_Missing_Rationale |  | 0
Test Witness |  | 0 |  |  |  | TEST_WITNESS
TW_No_CM |  | 0
TW_Test_Not_Followed |  | 0
TW_Incorrect_Test |  | 0
TW_No_Investigation |  | 0
TW_No_PR |  | 0
TW_Log_No_CM |  | 0
TW_Log_Date_Mismatch |  | 0
TW_Log_No_Results |  | 0
TW_Log_No_PR |  | 0
TW_Log_No_Tester |  | 0
TRR |  | 3 |  |  |  | TEST_READINESS_REVIEW
TRR_PR_Issues |  | 1
TRR_No_Baselines |  | 1
TRR_Peer_Reviews_Not_Complete |  | 0
TRR_Trace_Not_Complete |  | 0
TRR_Configuration_Not_Controlled |  | 0
TRR_Test_Environment_Not_Controlled |  | 1
TRR_Actions_Not_Addressed |  | 0
CCB |  | 0 |  |  |  | CCB_EVENT
CCB_Entry_Criteria |  | 0
CCB_No_Evidence |  | 0
CCB_Frequency_Not_Met |  | 0
CCB_Missing_Impacts |  | 0
CCB_Deficient_Description |  | 0
CCB_State_Transition |  | 0
Spreadsheet: 292083d1390489228-conditional-formatting-if-a-number-starts-with-specific-digits-vipin
Sheet: Sheet1

 | 85204 | 5556879
 | 45286 | 5556879
 | 91099 | 5556879
 | 91004 | 5556879
 | 85204 | 5556879
 | 45286 | 5556879
 | 91099 | 5556879
 | 91004 | 5556879
 | 85204 | 5556879
 | 45286 | 5556879
 | 91099 | 5556879
 | 91004 | 5556879
 | 85204 | 5556879
 | 45286 | 5556879
 | 91099 | 5556879
 | 91004 | 5556879
Spreadsheet: 888406d1738880161-create-summary-by-month-for-data-on-multiple-monthly-sheets-cust-info
Sheet: Summary

 | 9097
 |  | Current
Maj | Units | $ | Units | $ | Units | $ | Units | $ | Units | $
YO
HK
Spreadsheet: 736882d1623933592-match-data-from-multiple-sheet-test
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | RESULT
 | APPLE |  |  |  |  |  |  | CC |  | 3
 | ORANGE |  |  |  |  |  |  | DD |  | 4
 | KIWI |  |  |  |  |  |  | EE |  | 5
 | WATERMELON |  |  |  |  |  |  | FF |  | 6
 | BIKE |  |  |  |  |  |  | DD |  | 16
 | SOFA |  |  |  |  |  |  | WW |  | 17
 | BUS |  |  |  |  |  |  | QQ |  | 18
 | GREEN |  |  |  |  |  |  | GREEN |  | 14
 | BLUE |  |  |  |  |  |  | BLUE |  | 15
 | PEAR |  |  |  |  |  |  | GG |  | 7
 | ORANGE |  |  |  |  |  |  | HH |  | 8