tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darron_c_giron__8010__EMW0831a
Sheet: DPR

enovate P/L
 |  |  |  | NSS1 |  | NSS2 |  | MEH |  | TP-NSS |  | EMW Total
CURRENT BOOK VALUE
 | Physical
 |  | Physical
 |  | Other |  | 0 |  | 0 |  | 0 |  | 0
 |  | Prompt
 |  | Reversal
 |  | TOTAL
 | Financial
 |  | Price Swaps
 |  | Options
 |  | Basis
 |  | Index
 |  | Gas Daily
 |  | Gas Daily Options
 |  | Broker Fees
 |  | TOTAL
 | Omicron
 |  | Physical |  | 0 |  | 0 |  | 0 |  | 0
 |  | Financial |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL
 | Transport - Accrued
 |  | Revenue (Gas Daily Spreads)
 |  | Commodity Expense
 |  | Fuel Expense
 |  | 3rd Party Demand Charges |  | 0 |  | 0 |  | 0 |  | 0
 |  | 3rd Party Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Charges |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL
 | Transport - MTM
 |  | Revenue (Gas Daily Spreads)
 |  | Commodity Expense
 |  | Fuel Expense
 |  | 3rd Party Demand Charges |  | 0 |  | 0 |  | 0 |  | 0
 |  | 3rd Party Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Charges |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL
 | Other
 |  | People's Share of P&L |  |  |  |  |  | 0
 |  | Origination |  | 0 |  | 0 |  | 0 |  | 0
 |  | Flash to Actual |  | 0 |  | 0 |  | 0 |  | 0
 |  | Origination's Share of P&L |  | 0 |  |  |  | 0 |  | 0
 |  | TOTAL
NET CURRENT MONTH P&L
DAILY CHANGE
 | Physical
 |  | Physical
 |  | Other
 |  | Prompt
 |  | Reversal
 |  | TOTAL
 | Financial
 |  | Price Swaps
 |  | Options
 |  | Basis
 |  | Index
 |  | Gas Daily
 |  | Gas Daily Options
 |  | Broker Fees
 |  | TOTAL
 | Omicron
 |  | Physical
 |  | Financial
 |  | TOTAL
 | Transport - Accrued
 |  | Revenue (Gas Daily Spreads)
 |  | Commodity Expense
 |  | Fuel Expense
 |  | 3rd Party Demand Charges
 |  | 3rd Party Demand Reimbursements
 |  | Transport Book Demand Charges
 |  | Transport Book Demand Reimbursements
 |  | TOTAL
 | Transport - MTM
 |  | Revenue (Gas Daily Spreads)
 |  | Commodity Expense
 |  | Fuel Expense
 |  | 3rd Party Demand Charges
 |  | 3rd Party Demand Reimbursements
 |  | Transport Book Demand Charges
 |  | Transport Book Demand Reimbursements
 |  | TOTAL
 | Other
 |  | People's Share of P&L
 |  | Origination
 |  | Flash to Actual
 |  | Origination's Share of P&L
 |  | TOTAL
NET DAILY CHANGE P&L
MONTH TO DATE
YEAR TO DATE
 |  |  |  | NSS1 |  | NSS2 |  | MEH |  | TP-NSS |  | EMW Total
 |  | Physical:
 |  | Curve Shift
 |  | New Deals
 |  | Changed Deals
 |  | Trans. Reversal
 |  | Liquidated Day
 |  | New Financial Deals:
 |  | Price
 |  | Basis
 |  | Index
 |  | Gas Daily
Spreadsheet: 113333d1309271830-solving-equation-n-a-error-spreadsheet-error
Sheet: Walls

WIND LOAD ANALYSIS - WALL COMPONENTS AND CLADDING
ASCE 07-05 - BUILDINGS > 60ft
Project: | Montgomery Courthouse |  |  | Name: | Marcio |  | Date: | 05/25/11
Input Data:
Wind Speed (V) |  | = | 90 | mph (wind [NAME], Fihure 6-1)
Building Clasification |  | = | III | (Table 1-1 Occupancy Category)
Exposure Category |  | = | C | (Sect. 6.5.6)
Importance Factor |  | = | 1.15
Mean [NAME] |  | = | 15 | ft |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Building Width |  | = |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.15
Building Hight |  | = |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.25
Topografic  Factor (Kzt) |  | = | 1 | (Sect. 6.5.7 & Figure 6-4)
Directionality Factor (Kd) |  | = | 0.85 | (Table 6-4) |  |  |  |  |  |  |  |  |  |  |  |  |  | I
Panel Area |  | = | 20 | ft^2 |  |  |  |  |  |  |  |  |  |  |  |  |  | II
Velocity Pressure Exp. [NAME]. (Kz) |  | = | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | III
Comments:
B
C
height (ft) | Exposure B | Exposure C
15 | 0.7 | 0.85
20 | 0.7 | 0.9
25 | 0.7 | 0.94
30 | 0.7 | 0.98
40 | 0.76 | 1.04
50 | 0.81 | 1.09
60 | 0.85 | 1.13
70 | 0.89 | 1.17
80 | 0.93 | 1.21
90 | 0.96 | 1.24
100 | 0.99 | 1.26
120 | 1.04 | 1.31
140 | 1.09 | 1.36
160 | 1.13 | 1.39
180 | 1.17 | 1.43
200 | 1.2 | 1.46
250 | 1.28 | 1.53
300 | 1.35 | 1.59
350 | 1.41 | 1.64
400 | 1.47 | 1.69
450 | 1.52 | 1.73
500 | 1.56 | 1.77
Spreadsheet: 674616d1587951616-list-multiple-pages-and-remove-duplicates-test123-xatomicx-
Sheet: Tuesday

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday | Tuesday (new) |  | Cumulative
 | [NAME]
 | Lorelei Daniel
 | Darsh Bartlett
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Total
Spreadsheet: 470010d1468291492-predictive-analysis-icecream-sales
Sheet: Sheet1

 | Sales per Week
 | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5
Chocolate | 546 | 736 | 507 | 954 | 647
Vanilla | 1262 | 1330 | 1158 | 2534 | 1399
[NAME] | 1839 | 2190 | 1812 | 2645 | 3038
Black Cherry | 1586 | 1945 | 1552 | 2341 | 2761
[NAME] | 1117 | 1116 | 940 | 1409 | 1456
Rainbow | 1421 | 1683 | 1418 | 1864 | 2334
[NAME] | 3258 | 3598 | 3162 | 4431 | 4776
Mint Chip | 1037 | 1226 | 968 | 1415 | 1133
Grean Tea | 1466 | 1703 | 1447 | 2207 | 1887
 | Growth v. Same Week LY
 | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5
Chocolate | 6.81 | 2.712 | 2.092 | 3.2299 | 2.078
Vanilla | 0.13 | -0.004 | 0.048 | -0.042 | -0.02
[NAME] | 0.138 | -0.003 | 0.039 | 0.125 | 0.433
Black Cherry | 0.026 | 0.031 | -0.013 | 0.068 | 0.461
[NAME] | 0.147 | -0.085 | 0.001 | 0.031 | 0.076
Rainbow | 0.041 | -0.098 | -0.064 | 0.093 | 0.297
[NAME] | 0.059 | -0.023 | 0.054 | 0.067 | 0.217
Mint Chip | -0.04 | -0.057 | -0.123 | 0.023 | 0.035
Grean Tea | 0.008 | -0.06 | -0.017 | 0.1 | 0.159
Weighted Avg | 0.098 | 0.002 | 0.028 | 0.107 | 0.258
Spreadsheet: 681453d1591579168-index-match-on-non-adjacent-columns-index-match-homework-question
Sheet: Sheet1

 | Index(Match) Question
 | How do I use column B & D in an Index(Match) formula?
 | I don't know what to insert in the shaded cells, B37 and B38.
 | Date | Col 1 | Col 2
 | 2019-01-31 00:00:00 | 110800 | 52000
 | 2019-02-28 00:00:00 | 111255 | 50000
 | 2019-03-31 00:00:00 | 112544 | 51000
 | 2019-04-30 00:00:00 | 110585 | 52500
 | 2019-05-31 00:00:00 | 114200 | 56000
 | 2019-06-30 00:00:00 | 106500 | 58000
 | 2019-07-31 00:00:00 | 108600 | 60000
 | 2019-08-31 00:00:00 | 115900 | 62000
 | 2019-09-30 00:00:00 | 115700 | 58000
 | 2019-10-31 00:00:00 | 109200 | 56000
 | 2019-11-30 00:00:00 | 108500 | 54000
 | 2019-12-31 00:00:00 | 107300 | 52000
 | Solved for Column C
 |  | Last Closing Value
 |  | [NAME]
 |  | Delta of the Max Closing Value and the last Closing Value
 |  | Date of the highest Closing Value
 |  | Nearest Closing Value to current Closing Value
 |  | Date of nearest [NAME] to current Closing Value
 |  | Weeks between last Closing Value and nearest [NAME]
 | Solved for Column D
 |  | Last Closing Value
 |  | [NAME]
 |  | Delta of the Max Closing Value and the last Closing Value
 |  | Date of the highest Closing Value
 |  | Nearest Closing Value to current Closing Value
 |  | Date of nearest [NAME] to current Closing Value
 |  | Weeks between last Closing Value and nearest [NAME]
Spreadsheet: 02ecbd2a-9e45-47b5-943d-47b9b16ccc9f
Sheet: Application

Vandal Strategic Loan Fund (VSLF)
Request for Internal Loan
Updated 12/05/2013
Section I:  To be completed by requesting college/division/unit
 | College/Division/Unit requesting internal loan:
 | Loan amount requested:
 |  | Note:  Per VSLF policy loan requests exceeding $250,000 require both VSLF Committee and Board approval
 | Purpose/justification of internal loan including how the request supports the Strategic Plan (attach additional pages if needed):
 | Other financing options explored and why an internal loan is preferred (attach additional pages if needed):
 | Time frame over which borrowed funds will be expended: |  |  |  |  |  |  |  |  |  | to
 |  |  |  |  |  |  |  |  | Start |  |  | Finish
 | Describe repayment source (i.e. gift revenue, operating revenue, base budget, etc.).  Include a schedule showing 3 years history, if applicable, and estimated annual cash flow for the repayment source including any existing commitments against this source through the requested repayment timeframe (see separate tab for example).
 | Alternate repayment source (required, provide specific budget(s)):
 |  | Note:  Per VSLF policy the University is authorized to draw funds from alternative funding sources if needed in order to meet the approved repayment schedule.
 | Repayment terms:
 |  |  |  | Interest Rate: |  | 0.02
 |  |  |  | [NAME]:
 |  |  |  | Note:  Per VSLF policy repayment terms exceeding 3 years require both VSLF Committee and Board approval
 |  |  |  | First Scheduled Annual Payment:
 | Is this loan being used to meet a cost share / matching requirement?  If yes please attach a copy of the grant proposal (draft version if necessary) indicating the cost share / matching requirement.
 |  |  |  | No, this loan is not being used to meet a cost share / matching requirement
 |  |  |  | Yes, this loan is being used to meet a cost share / matching requirement -see attached grant proposal
For equipment requests: Please attach bids or quotes documenting the equipment cost, installation costs and other needs related to the equipment (i.e. infrastructure needs, etc.)
Internal Loan Requested by:
Signature / Title |  |  |  |  |  |  |  |  |  |  | Date
Dean / VP |  |  |  |  |  |  |  |  |  |  | Date
Please send the original signed request to the Budget Office (campus zip 3156) for review by the Vandal Strategic Loan Fund committee.
Section II:  To be completed by the Vandal Strategic Loan Fund loan committee:
Date Received:
 |  |  | [NAME]
 |  |  | Loan Denied
 |  |  | Requesting Additional Information:
Spreadsheet: mary_fischer__25640__31W - 2001
Sheet: E8.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031W
COMPANY NAME    Harper Mechanical Corp.
ANALYSIS OF OTHER DEFERRED CHARGES
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Work in Progress:
 |  | 0
Total  (Hyperion Line 0343)
Asset/Expense Accts:  DR/(CR)
Other Deferred Charges:
 |  | 0
Total (Hyperion line 360)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: robin_rodrigue__33410__P&LSum
Sheet: Summary

SUMMARY OF CANADA'S TRADING INCOME BY DESK - IN C$
 |  |  |  |  |  |  |  |  |  |  | To Nov 17
 |  |  |  |  |  |  |  |  |  |  | MTD |  |  |  |  |  |  | To date
 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 |  | TOTAL |  | Q1 | Q2 | Q3 | Q4 |  | TOTAL
BY BOOK:
TERM: | (Note:  Q1 Orgination has been manually backed out)
[NAME] |  |  |  |  |  |  |  |  |  |  | -8241953
BC Term |  |  |  |  |  |  |  |  |  |  | -7499455
EOL - Term |  |  |  |  |  |  |  |  |  |  | -550812
Options |  |  |  |  |  |  |  |  |  |  | 6048314
CASH
[NAME]
BC Cash
BC Pipe Cash
[NAME]
BC Term - GD
Options - GD
Power
PMA
TOTAL CANADA
BY RISK TYPE: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BY RISK TYPE:
Total Term |  |  |  |  |  |  |  |  |  |  | -10243906
Check
Total Cash
Check
TOTAL CANADA
BY AREA/TRADER:
West Term - Lavorato
West Term - Mckay
West Term - Lambie
Options - Disturnal
[NAME]
BC Cash - Clark
Power - Greenizan
TOTAL CANADA
Check
Spreadsheet: 718448d1613143165-if-cell-contains-some-text-from-another-cell-then-return-true-book2
Sheet: Sheet1

123_A | 123 | This row should return TRUE
123_B | 123 | This row should return TRUE
123_C | 123 | This row should return TRUE
123_D | 12345 | This row should return False
123_E | 123 | This row should return TRUE
Spreadsheet: 116845d1312220832-formula-for-picking-out-all-or-first-and-last-or-all-but-one-from-a-list-gm_example
Sheet: Sheet1

Sample | X |  | =IF(A2="STANDARD",COUNTIF($A$1:A2,"STANDARD"),"")
STANDARD | 101 |  | Notes:  There will always be at least 3 standards, and about half the time there will be 4.
STANDARD | 102 |  | There may only be one numbered sample, or up to twenty.
Sample 100001 | 103 |  | The location of the STANDARDs will vary - that is, not always in the same rows
Sample 100002 | 104
Sample 100003 | 105 |  | WHAT I WANT TO DO:
Sample 100004 | 106 |  | Compute the average and standard deviation of X for:
Sample 100005 | 107 |  | ...all four standards.
Sample 100006 | 108 |  | …just the first three standards
Sample 100007 | 109 |  | …the first two, and the last standard (that ism standards 1, 2, and 4)
Sample 100008 | 110
Sample 100009 | 111 |  | I can do the first set: |  | =AVERAGEIF(A2:A27,"STANDARD",B2:B27)
Sample 100010 | 112 |  |  |  | {=STDEV(IF(A2:A27="STANDARD",B2:B27,""))}
STANDARD | 113
Sample 100011 | 114 |  | The second and third, though, I can't wrap my head around.
Sample 100012 | 115 |  |  |  | =[NAME])
Sample 100013 | 116 |  |  |  | =STDEV(IF(C2:C27<=3,$B$2:$B$27,""))
Sample 100014 | 117
Sample 100015 | 118 |  |  |  | =SUMPRODUCT(--($C$2:$C$27<3)+--($C$2:$C$27=4),$B$2:$B$27)/3
Sample 100016 | 119 |  |  |  | {=STDEV(IF(OR(C2:C27<3,C2:[NAME],""))}
Sample 100017 | 120
Sample 100018 | 121
Sample 100019 | 122
Sample 100020 | 123
Sample 100021 | 124
Sample 100022 | 125
STANDARD | 126
Spreadsheet: 0af21663-5dfa-44a7-8d63-f8332ecfd9d0
Sheet: Table S1 inventory

Supplementary Information
Table S1: | Supplementary Table 1
Table S1a: | differentially expressed genes in the different time points in BPH1 cells
Table S1b: | differentially expressed genes in the different time points in PrSF cells
Table S1c: | differentially expressed genes in common between BPH1 and PrSF cells in the different time points
Table S1d: | GO biological processes differentially regulated in the different time points in BPH1 cells
Table S1e: | GO biological processes differentially regulated in the different time points in PrSF cells
Table S1f: | differentially expressed genes related to proliferation in the different time points in BPH1  cells
Table S1g: | differentially expressed genes related to apoptosis in the different time points in BPH1  cells
Table S1h: | differentially expressed genes related to proliferation in the different time points in PrSF cells
Table S1i: | differentially expressed genes related to apoptosis in the different time points in PrSF  cells
Table S1j: | differentially expressed genes related to inflammation in the different time points in BPH1 cells
Table S1k: | differentially expressed genes related to inflammation in the different time points in PrSF  cells
Spreadsheet: 120854d1315585055-problem-using-conditional-formatting-to-flag-cells-by-color-and-count-them-example2
Sheet: Dr. Jones

PT. # | LAST NAME | FIRST NAME | REQUIRED | IN DATE | COM DATE | NOTES
59784 | Patridge | Holly | PN | 2011-07-10 00:00:00 |  | HP also required | Total # of Yellow
57373 |  |  |  |  |  |  | Total # of Orange
78945 |  |  |  |  |  |  | Total # of Red
56123
45678
19584
Spreadsheet: 107236d1304445509-need-to-create-report-from-sheet-test-admin-field-time-2011
Sheet: Aaron L. X

[NAME]
Field Time Calculator |  |  |  | "Every Person Going Home Safe and [NAME]" |  |  |  |  |  |  |  |  |  |  |  | "Coaching Contacts"
 | 2011 |  |  |  |  |  |  |  |  |  |  |  | YTD 2011 |  |  | 2011
 | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Avg |  |  | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec
1 |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1
2 |  |  | 4 |  | 1 |  |  |  |  |  |  |  |  |  | 2 |  |  | 1
3 |  |  | 7.5 |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  | 2
4 |  |  |  | 0 |  |  | HOLIDAY |  |  |  |  |  |  |  | 4
5 |  |  |  | 2 |  |  |  |  | HOLIDAY |  |  |  |  |  | 5 |  |  |  | 1
6 |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | 1
7 |  |  | 1 | 2 |  |  |  |  |  |  |  |  |  |  | 7 |  |  | 1 | 1
8 |  | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 1
9 |  | 5 | 6 |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 1
10 |  | 2 | 3 |  |  |  |  |  |  |  |  |  |  |  | 10
11 |  | 3.5 |  |  |  |  |  |  |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
14 |  | 1 | 3 |  |  |  |  |  |  |  |  |  |  |  | 14
15 |  | 5 | 1 |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  | 1
16 |  | 3 | 3 |  |  |  |  |  |  |  |  |  |  |  | 16 |  |  | 1
17 |  | 3 | 4 |  |  |  |  |  |  |  |  |  |  |  | 17 |  |  | 1
18 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 18
19 |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
21 |  | HOLIDAY | 3.5 | 3 |  |  |  |  |  |  |  |  |  |  | 21 |  |  |  | 2
22 |  | 1 | 2 |  |  |  |  |  |  |  |  | HOLIDAY |  |  | 22
23 |  | 6 | 4 |  |  |  |  |  |  |  | HOLIDAY |  |  |  | 23
24 |  | 4 | 3 |  |  |  |  |  |  |  | HOLIDAY |  |  |  | 24
25 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 25 |  |  |  | 1
26 |  |  |  | 2 |  |  |  |  |  |  |  | HOLIDAY |  |  | 26
27 |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  | 27
28 |  | 1 | 5 | 1 |  |  |  |  |  |  |  |  |  |  | 28 |  | 1
29 |  | NA | 7.5 |  |  |  |  |  |  |  |  | HOLIDAY |  |  | 29
30 |  | NA | 4 |  | HOLIDAY |  |  |  |  |  |  |  |  |  | 30
31 |  | NA | 0 | NA |  | NA |  |  | NA |  | NA |  |  |  | 31
Count | 0 | 12 | 19 | 11 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Count | 0 | 2 | 9 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17
Field Hrs | 0 | 36.5 | 67.5 | 22 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 127 | FLRA Coaching |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Total Hrs | 0 | 120 | 190 | 110 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 430 |  | FLRA var. | 5 | 3 | -4 | -1 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Percent | #N/A | 0.3041666666666666 | 0.3552631578947368 | 0.2 | 0.1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0.2953488372093023
Days on Site with field time = 2
Days on Site W/O field time=NT
H=Holidays
V=Vacation
O=Off Site
S=Sick/Personal
Attended EH&S mtgs
Schd/Missed EH&S mtgs
Spreadsheet: 738348d1624982016-general-question-about-countif-with-operator-formula-book1
Sheet: Sheet1

1 |  |  |  |  |  |  |  |  | Q
2 | x |  |  |  |  |  |  |  | W | x
3 |  |  |  |  |  |  |  |  | E
4 |  |  |  |  |  |  |  |  | R
5 | x |  |  |  |  |  |  |  | T | x
6 |  |  |  |  |  |  |  |  | Y
 | x |  |  |  |  |  |  |  | U | x
8 |  |  |  |  |  |  |  |  | I
9 |  |  |  |  |  |  |  |  | O
Spreadsheet: 151028d1334761472-lookup-nearest-billing-cycle-and-count-days-xl0000068
Sheet: Decription

No | Purchase Date(dd/mm/yyyy) | Billing Cycle(dd/mm/yyyy) | Total Days |  | Billing Cycle Fixed for every month:
1 | 2012-03-01 00:00:00 | 2012-02-07 00:00:00 | 29 |  | 25
2 | 2012-03-24 00:00:00 | 2012-02-25 00:00:00 | 29 |  | 22
3 | 2012-03-26 00:00:00 | 2012-02-13 00:00:00 | 29 |  | 19
4 | 2012-01-01 00:00:00 | 2011-12-07 00:00:00 | 31 |  | 16
5 | 2012-01-17 00:00:00 | 2011-12-19 00:00:00 | 31 |  | 13
 |  |  |  |  | 10
 |  |  |  |  | 7
 |  |  |  |  | Example on no of days in the month of BC range
 |  |  |  |  | 1.       On 1st March, the nearest BC is 7th Mar, the proration calculation is based on 7th Feb to 6th Mar, therefore is no. of days is 29.
 |  |  |  |  | 2.       On 24th [NAME], the nearest BC is 25th Mar, the proration calculation is based on 25th Feb to 24th Mar, therefore the no. of days is 29
 |  |  |  |  | 3.       On 26th Mar, the nearest BC is 7th Apr, the proration calculation is based on 7th Mar to 6th April, therefore the no. of days is 31.
Spreadsheet: 4ec44d6a-6137-4345-9cf0-c90b58e65dc9
Sheet: 15a

Product |  | Transactions
Single - Name* | Corporate | 26618
 | Loans | <100
 | Municipal | <100
 | Recovery | <100
 | Sovereign | 2295
Index Tranche | Asia | <100
 | Europe | <100
 | North America | 103
Index | Asia | 229
 | Europe | 5426
 | North America | 5718
TOTAL |  | 40389
Estimated swap transaction volumes, week ending October 25, by product type (in number of transactions), all tenors and currencies. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
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 Data Dictionary for product descriptions.
**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: 128237d1320868197-if-function-psh9
Sheet: Sheet1

Account Number | Effective Date | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | State
1 |  | x | x | x | x | x | x | GA
2 |  | x | x | x | x | x | x | FL
3 |  | x | x | x | x | x | x | AL
4 |  | x | x | x | x | x | x | MS
5 |  | x | x | x | x | x | x | IL
6 |  | x | x | x | x | x | x | CA
7 |  | x | x | x | x | x | x | NY
8 |  | x | x | x | x | x | x | KY
9 |  | x | x | x | x | x | x | AL
10 |  | x | x | x | x | x | x | NE
Spreadsheet: 32be5294-a1b7-47aa-ad50-82fb4d9fa304
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | [NAME] 2014
 |  | 2014-01-01 00:00:00 | 2014-01-02 00:00:00 | 2014-01-03 00:00:00 | 2014-01-04 00:00:00 | 2014-01-05 00:00:00 | 2014-01-06 00:00:00 | 2014-01-07 00:00:00 | 2014-01-08 00:00:00 | 2014-01-09 00:00:00 | 2014-01-10 00:00:00
 |  | quarta-feira | [NAME] | sexta-feira | sábado | domingo | segunda-feira | terça-feira | quarta-feira | [NAME] | sexta-feira
 | [NAME]
 | Lanche da manhã
 | Almoço
 | Lanche da tarde
 | Jantar
 | Ceia
 |  | 2014-01-11 00:00:00 | 2014-01-12 00:00:00 | 2014-01-13 00:00:00 | 2014-01-14 00:00:00 | 2014-01-15 00:00:00 | 2014-01-16 00:00:00 | 2014-01-17 00:00:00 | 2014-01-18 00:00:00 | 2014-01-19 00:00:00 | 2014-01-20 00:00:00
 |  | sábado | domingo | segunda-feira | terça-feira | quarta-feira | [NAME] | sexta-feira | sábado | domingo | segunda-feira
 | [NAME]
 | Lanche da manhã
 | Almoço
 | Lanche da tarde
 | Jantar
 | Ceia
 |  | 2013-01-21 00:00:00 | 2013-01-22 00:00:00 | 2013-01-23 00:00:00 | 2013-01-24 00:00:00 | 2013-01-25 00:00:00 | 2013-01-26 00:00:00 | 2013-01-27 00:00:00 | 2013-01-28 00:00:00 | 2013-01-29 00:00:00 | 2013-01-30 00:00:00
 |  | terça-feira | quarta-feira | [NAME] | sexta-feira | sábado | domingo | segunda-feira | terça-feira | quarta-feira | [NAME]
 | [NAME]
 | Lanche da manhã
 | Almoço
 | Lanche da tarde
 | Jantar
 | Ceia
 |  | 2014-01-31 00:00:00 |  | Análise do Mês:
 |  | sexta-feira
 | [NAME] |  |  | O que preciso melhorar?
 | Lanche da manhã |  |  | O que preciso aumentar?
 | Almoço |  |  | O que preciso diminuir?
 | Lanche da tarde |  |  | Quais dias como mais?
 | Jantar |  |  | Porque comi mais?
 | Ceia |  |  | Anotações: