tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 4591cba1-c7a8-4502-b37e-d555e2c34646
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-09-25 09:41:40.130000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.625 | 101.95 | 101.825 | 101.7 | 101.325
4.5 | 101.36 | 101.235 | 101.11 | 100.735 |  | Note: | Refer To Price [NAME]
4.375 | 100.484 | 100.359 | 100.234 | 99.859 |  |  | For all Price Adjs
4.25 | 99.958 | 99.833 | 99.708 | 99.083
4.125 | 99.216 | 99.091 | 98.966 | 98.341
4 | 98.297 | 98.172 | 98.047 | 97.422
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.125 | 102 | 101.875 | 101.5
3.75 | 101.751 | 101.626 | 101.501 | 101.126
3.625 | 101.36 | 101.235 | 101.11 | 100.735
3.5 | 100.855 | 100.73 | 100.605 | 100.23
3.375 | 100.152 | 100.027 | 99.902 | 99.277
3.25 | 99.409 | 99.284 | 99.159 | 98.534
3.125 | 98.494 | 98.369 | 98.244 | 97.619 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-10-09 09:41:40.130000
30 DAY | 2013-10-24 09:41:40.130000
45 DAY | 2013-11-08 09:41:40.130000
60 DAY | 2013-11-23 09:41:40.130000
90 DAY | 2013-12-23 09:41:40.130000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 40657d1239048579-how-to-lookup-a-value-and-return-a-formula-variable-formula
Sheet: Conditional Formulas

Condition | Divisor | Corresponding Check Formula
A | 100 | (C5*(B5/100)*E5)/D5
B | 1 | ((B5*(C5/1))*E5)/D5
C | 1 | ((B5*(C5/1))*E5)/D5
D | 1 | ((B5*(C5/1))*E5)/D5
E | 1 | ((B5*(C5/1))*E5)/D5
F | 10 | ((B5*(C5/10))*E5)/D5
G | 10 | ((B5*(C5/10))*E5)/D5
H | 10 | ((B5*(C5/10))*E5)/D5
I | 0.192308 | ((B5*(C5/10))*E5)*52/D5
J | 0.192308 | ((B5*(C5/10))*E5)*52/D5
K | 100 | ((B5*(C5/100))*E5)/D5
L | 100 | ((B5*(C5/100))*E5)/D5
M | 100 | ((B5*(C5/100))*E5)/D5
N | 1000 | ((B5*(C5/1000))*E5)/D5
O | 1000 | ((B5*(C5/1000))*E5)/D5
P | 1000 | ((B5*(C5/1000))*E5)/D5
Q | 1000 | ((B5*(C5/1000))*E5)/D5
R | 1000 | ((B5*(C5/1000))*E5)/D5
S | 1000 | ((B5*(C5/1000))*E5)/D5
T | 1000 | ((B5*(C5/1000))*E5)/D5
U | 1000000 | ((B5*(C5/1000000))*E5)/D5
D | 1000000 | ((B5*(C5/1000000))*E5)/D5
W | 1000000 | ((B5*(C5/1000000))*E5)/D5
X | 1000000 | ((B5*(C5/1000000))*E5)/D5
Y | 1000000 | ((B5*(C5/1000000))*E5)/D5
Z | 1000000 | ((B5*(C5/1000000))*E5)/D5
AA | 1000000 | ((B5*(C5/1000000))*E5)/D5
BB | 1000000 | ((B5*(C5/1000000))*E5)/D5
CC | 1000000 | ((B5*(C5/1000000))*E5)/D5
Spreadsheet: 0c853bbf-9a24-4f69-b05b-829dd918068e
Sheet: Introduction

This spreadsheet accompanies the U.S. GAAP Financial Reporting Taxonomy v2011 Final Release Notes (January 31, 2011).
Below are the links to the worksheets which lists the elements by changes made. This file corresponds to "Appendix 3- Deprecated Items" in the Final Release Notes.
 | Appendix 3 |  |  |  |  |  |  | No. of Elements
 | A. | Deprecated elements with no relationship |  |  |  |  | No Relationship'!A1 | 299
 | B. | Deprecated elements with a dep-aggregateConcept-deprecatedPartConcept relationship |  |  |  |  | dep-agg-depPartConcept'!A1 | 69
 | C. | Deprecated elements which have a dep-concept-deprecatedConcept relationship |  |  |  |  | dep-concept-depConcept'!A1 | 203
 | D. | Deprecated elements which have a dep-dimensionllyQualifiedConcept-deprecatedConcept |  |  |  |  | [NAME] | 130
 | E. | Deprecated elements which have a dep-mutuallyExclusiveConcept-deprecatedConcept |  |  |  |  | dep-MutuallyExclusive'!A1 | 2
 | F. | Deprecated elements which have a dep-partConcept-deprecatedAggregateConcept |  |  |  |  | dep-PartConcept-depAgg'!A1 | 37
 | G. | Undeprecated elements |  |  |  |  | Undeprecated!A1 | 7
Spreadsheet: 94252d1294121553-help-on-calculating-time-and-date-test
Sheet: Sheet1

Date Opened | Time Opened | Date Closed | Time  Closed | Total Time in Position
2011-01-12 00:00:00 | 13:00:00 | 2011-01-14 00:00:00 | 23:00:00 | 2 days 10:00
2011-01-14 00:00:00 | 01:30:00 | 2011-01-14 00:00:00 | 03:00:00 | 0 days 1:30
2011-01-14 00:00:00 | 05:00:00 | 2011-01-21 00:00:00 | 23:00:00 | 7 days 18:00
 |  |  |  | 0 days 0:00
 |  |  |  | 0 days 0:00
 |  |  |  | 0 days 0:00
 |  |  |  | 0 days 0:00
 |  |  |  | 0 days 0:00
 |  |  |  | 0 days 0:00
 |  |  |  | Total Time in Position
 |  |  |  |  | <<<< I require the following Cell to add the sum of the days in column V
Spreadsheet: 867575d1714409854-help-with-sumifs-sumproduct-forum
Sheet: Annual Summary

 |  | Month End>> |  |  | Date | 2022-12-31 00:00:00
 |  | Year>> |  |  | Year
 |  | CANASURIA
 |  | CMELITAH
 |  | CUNITYGOLD
 |  | [NAME]
 |  | CEGINA
 |  | [NAME]
 |  | CEKOFISK
 |  | CBONGA
 |  | CSCHIEHALLION
 |  | CELSHARARA
 |  | CGOLIAT
 |  | CGULLFAKS
 |  | COSEBERG
 |  | CSTATFJORD
 |  | CSVERDRUP
 |  | CCLAIR
 |  | CURAL
 |  | CGINAKROG
 |  | CSLOP
 |  | CNIGFORC
 |  | CWTIMID
 |  | CERHA
 |  | CRUDE
 |  | CLNG
 |  | FIVGO
 |  | OTHERS IMPORT
 |  | RO-CETAN
 |  | RO-CFPPADD
 |  | RO-MKGADD
 |  | RO-OLI ADD
 |  | RO-POUR PT
 |  | ADDITIVE
 |  | [NAME]
 |  | [NAME]
 |  | BUTANE
 |  | LPRO
 |  | AUTOGAS
 |  | TOTAL PROPAN
 |  | [NAME]
 |  | TOTAL PROPYLENE
 |  | ETHANOL-KOMP
 |  | [NAME]
 |  | MHEX
 |  | MISO-LYR
 |  | MPOLY
 |  | MREFLYR
 |  | NTO
 |  | MHCN
 |  | TOTAL MS-COMPONENT
 |  | M92DK
 |  | M92SEV
 |  | M92SES
 |  | M92NO
 |  | TOTAL MOTORSPIRIT 92
 |  | M95EUROS
 |  | M95EUROV
 |  | M93NO
 |  | M95GL
 |  | MEVONOS
 |  | M95E10S
 |  | MEVONOV
 |  | M95NO
 |  | M95E10W
 |  | TOTAL MOTORSPIRIT 95
 |  | GHSHGO
 |  | GLCOB
 |  | GMG
 |  | GE10
 |  | [NAME]
 |  | TOTAL HEATING
 |  | D1210DK
 |  | D2510NO
 |  | D510FR
 |  | D510UK
 |  | DGTL
 |  | GDSHGO
 |  | GDSLGO
 |  | GHSLGO
 |  | IDHVO
 |  | D1710NO
 |  | [NAME]
 |  | D010PL
 |  | G850DK
 |  | D910DK
 |  | D+510FR
 |  | D710DE
 |  | D2250GL
 |  | D810-GL
 |  | [NAME]
 |  | D010DK
 |  | D010NO
 |  | D210DK
 |  | D+310UK
 |  | D+510DE
 |  | D0110NO
 |  | RME
 |  | G+150DE
 |  | TOTAL ULSD
 |  | DMK1
 |  | TOTAL MK1 DIESEL
 |  | FDCO
 |  | FLCO
 |  | FLS380
 |  | FLSTAR
 |  | TOTAL LSCR
 |  | FRESLS
 |  | SC-SLOP
 |  | FRES07
 |  | TOTAL LSSR
 |  | FBC380
 |  | FHSTAR
 |  | FRESHS
 |  | TOTAL HSCR
 |  | FHGORA
 |  | FICB
 |  | FRMD01
 |  | FULTRA500
 |  | FVGO05
 |  | FVGOHS
 |  | VGO
 |  | SULP
 |  | SULPHUR
 |  | GKERO
 |  | TOTAL JET FUEL
 |  | LLNG
 |  | SC-COKE
 |  | SC-REFG
 |  | SC-REFF
 |  | REFFUEL
 |  | DHVO-US
 |  | IPYRO
 |  | IRSO
 |  | TME
 |  | TPO
 |  | DITME
 |  | IRME
 |  | TOTAL RENEWABLE FEED
 |  | NFRPA
 |  | NHYNA
 |  | [NAME]
 |  | NAPHTHA
 |  | Total
 |  | Check
Spreadsheet: daren_farmer__5619__Tenaska IV 2000
Sheet: November 2000 Est.

Enron North America Corp
Summary of Gas Activity for Tenaska IV Partners, Ltd.
November 2000
November Sales
 | Counterparty | Volume | Dollars
 | Brazos Electric and Power | 1035000 | 2995290
 | [NAME] | 30 | 183.08
 | Tenaska IV Partners | 267300 | 777843
 | Tenaska Marketing | 20000 | 85800
 | TXU Gas Distribution | 20000 | 87400
 | Total Sales per Unify |  |  | estimate
November Purchases
 | Apache Marketing | -580000 | -1325300.03
 | [NAME] | -750000 | -1740000
 | TXU [NAME] |  | -30000
 | Total Purchases per Unify |  |  | estimate
November Netout
 | Total Sales
 | Total Purchases
 | Amount due Enron from Plant
 | Agency Fee (1,342,330 x $0.04) |  | -53693.2 | estimate
 | Estimated Payable to Tenaska IV Partners: |  |  | estimate
Spreadsheet: 4a329220-da11-4b9c-b5d4-a2992940ebd5
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
 | Time Series Workbook
 | 9314.0 Sales of New Motor Vehicles, Australia
 | Table 1: New Motor Vehicles Sales by Type, All series
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Aust. ;  Passenger vehicles ; |  |  | Original | A367169W | 1994-01-01 00:00:00 | 2012-09-01 00:00:00 | 225 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Original | A367214W | 1994-01-01 00:00:00 | 2012-09-01 00:00:00 | 225 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Original | A367259A | 1994-01-01 00:00:00 | 2012-09-01 00:00:00 | 225 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Original | A367304A | 1994-01-01 00:00:00 | 2012-09-01 00:00:00 | 225 | Number | FLOW | Month | 1
Aust. ;  Passenger vehicles ; |  |  | Seasonally Adjusted | A367170F | 1994-01-01 00:00:00 | 2012-09-01 00:00:00 | 225 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Seasonally Adjusted | A367215X | 1994-01-01 00:00:00 | 2012-09-01 00:00:00 | 225 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Seasonally Adjusted | A367260K | 1994-01-01 00:00:00 | 2012-09-01 00:00:00 | 225 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Seasonally Adjusted | A367305C | 1994-01-01 00:00:00 | 2012-09-01 00:00:00 | 225 | Number | FLOW | Month | 1
Aust. ;  Passenger vehicles ; |  |  | Trend | A367171J | 1994-01-01 00:00:00 | 2012-09-01 00:00:00 | 225 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Trend | A367216A | 1994-01-01 00:00:00 | 2012-09-01 00:00:00 | 225 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Trend | A367261L | 1994-01-01 00:00:00 | 2012-09-01 00:00:00 | 225 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Trend | A367306F | 1994-01-01 00:00:00 | 2012-09-01 00:00:00 | 225 | Number | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 116957d1312362580-array-formula-or-possible-macro-to-match-and-calculate-between-multiple-sheets-testbook
Sheet: IngredientRecipes

Ingredient | Unit | Falafel | Marinated Chicken | [NAME] Dough | White Dough | [NAME] | [NAME]
Amount |  | 2 | 2 | 2 | 2 | 2 | 2
Unit |  | oz | oz | oz | oz | oz | oz
Chickpeas | oz | 6 | 2 | 3
Carrots | oz | 3 | 3 | 2 | 3 |  | 1
Butter | oz | 4 |  |  |  | 2 | 3
Salt | oz |  |  | 3
Sugar | oz | 1 |  |  | 2
Spreadsheet: 153441d1335908158-populate-columns-in-one-sheet-based-off-of-a-few-lists-in-a-different-sheet-sample-passport-survey-annual-study-2011-jd-5-1
Sheet: Results

Theme | Cluster | QuestionShort | Geography | Respondants | LongLegendValue1 | LongLegendValue2 | LongLegendValue3 | LongLegendValue4 | LongLegendValue5 | LongLegendValue6 | LongLegendValue7 | LongLegendValue8 | LongLegendValue9 | LongLegendValue10
 | Q2_1
 | Q2_1
 | Q2_1
 | Q2_1
 | Q2_1
 | Q2_1
 | Q2_1
 | Q2_1
 | Q2_1
 | Q2_1
 | Q2_1
Spreadsheet: 205081d1357735806-how-to-automatically-copy-specific-rows-in-excel-sample
Sheet: Sheet1

[NAME] | good | new | 34523
jade | bad | new | 2354
[NAME] | good | old | 2113
tom | good | old | 6442
billy | normal | new | 63434
bob | bad | new | 642342
Spreadsheet: 272496d1382405926-problem-with-index-small-if-row-to-list-results-based-on-more-than-one-criteria-testing
Sheet: Summary

Unique Report Number | Person Name | Report Date |  | Period Begin | Period End
 |  |  |  | 2013-01-02 00:00:00 | 2013-02-27 00:00:00
 |  |  |  | Person Name
 |  |  |  | [NAME]
Spreadsheet: 149989d1334238344-call-a-formula-sum-all-the-figures-before-a-certain-cell-reference-data
Sheet: Input List

Code | Quantity of GO  before AI
103 | 1
107 | 6
120 | 3
121 | 11
123 | 6
126 | 5
129 | 22
130 | 8
131 | 15
132 | 8
134 | 1
139 | 5
Spreadsheet: 118f3d15-0560-4303-a3d8-f7d94364cfa7
Sheet: Sheet1

Table 1--U.S. rice supply and use  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Item | 2006/07 | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13
 |  |  |  |  |  | 2/ | 2/
TOTAL RICE |  |  |  | Million acres
Area:
Planted | 2.838 | 2.761 | 2.995 | 3.135 | 3.636 | 2.689 | 2.699
Harvested | 2.821 | 2.748 | 2.976 | 3.103 | 3.615 | 2.618 | 2.677
 |  |  |  | Pounds per harvested acre
Yield | 6898 | 7219 | 6846 | 7085 | 6725 | 7067 | 7428
 |  |  |  | Million cwt
Beginning stocks | 42.992 | 39.315 | 29.492 | 30.419 | 36.499 | 48.467 | 41.07900000000001
Production | 194.585 | 198.388 | 203.733 | 219.85 | 243.104 | 185.009 | 198.86
Imports | 20.581 | 23.9 | 19.218 | 19.019 | 18.336 | 19.361 | 19.5
Total supply | 258.158 | 261.603 | 252.443 | 269.288 | 297.939 | 252.837 | 259.439
Food, industrial,
& residual 3/ | 124.671 | 123.152 | 123.77 | 120.012 | 133.191 | 97.068
Seed | 3.408 | 3.697 | 3.87 | 4.488 | 3.324 | 3.332
Total domestic use | 128.079 | 126.849 | 127.64 | 124.5 | 136.515 | 110.17 | 127
Exports | 90.764 | 105.262 | 94.384 | 108.304 | 112.959 | 101.588 | 100
Rough | 32.112 | 37.663 | 31.633 | 40.351 | 35.146 | 32.72 | 33
Milled 4/ | 58.652 | 67.599 | 62.751 | 67.953 | 77.813 | 68.868 | 67
Total use | 218.843 | 232.111 | 222.024 | 232.793 | 249.474 | 211.758 | 227
Ending stocks | 39.315 | 29.492 | 30.419 | 36.499 | 48.46700000000004 | 41.07900000000001 | 32.43900000000002
 |  |  |  | Percent
Stocks-to-use ratio | 17.96493376530206 | 12.70598980660115 | 13.70077108781033 | 15.67550388462513 | 19.42783158029761 | 19.4 | 14.3
 |  |  |  | $/cwt
Average farm |  |  |  |  |  |  | 14.20 to
price 5/ | 9.96 | 12.8 | 16.8 | 14.4 | 12.7 | 14.3 | 15.2
 |  |  |  | Percent
Average
milling rate | 71 | 69.88 | 70.83 | 71.53 | 68.86 | 69.93 | 70.25
N/A = not available.  1/ August-July market year; rough equivalent.  2/ Projected.  3/ Residual includes unreported
use, processing losses, and estimating errors.  4/  Rough-rice equivalent.  5/ Market-year weighted average.
Source: World Agricultural Supply and Demand Estimates, WAOB, USDA.
Updated October 11, 2012.
Spreadsheet: 44546d1243331020-automatic-week-commence-date-needed-weekly-business-master-main
Sheet: Bar Business

WEEK COMMENCING | 2009-05-25 00:00:00
SALES ANALYSIS | MON | TUES | WED | THURS | FRI | SAT | SUN | TOTAL
DATE | 2009-05-25 00:00:00 | 2009-05-26 00:00:00 | 2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 2009-05-29 00:00:00 | 2009-05-30 00:00:00 | 2009-05-31 00:00:00
Time Closed          ===>
 |  |  |  |  |  |  |  | 0
TILL 1 |  |  |  |  |  |  |  | 0
TILL 2 |  |  |  |  |  |  |  | 0
TOTAL TILL VARIANCE |  |  |  |  |  |  |  | 0
BUDGET | 0 | 0 | 500 | 500 | 1500 | 1500 | 0 | 4000
TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BUDGET V ACTUAL | 0 | 0 | -500 | -500 | -1500 | -1500 | 0 | -4000
DOOR INCOME |  |  |  |  |  |  |  | 0
C/ROOM INCOME |  |  |  |  |  |  |  | 0
TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FOOD SALES |  |  |  |  |  |  |  | 0
GAMES MACHINES |  |  |  |  |  |  |  | 0
MACHINE SALES |  |  |  |  |  |  |  | 0
CIGS MCHINE |  |  |  |  |  |  |  | 0
TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL SALES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EXPENSES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cash on Delivery | 90.66 |  |  |  |  |  |  | 90.66
CASH MACHINE |  |  |  |  |  |  |  | 0
TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL CASH IN BAG | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CASH BAG NUMBER
TOTAL BANKED MONEY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
STAFF LABOUR COST | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LABOUR % | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 62966d1263944645-find-value-in-range-on-second-worksheet-classregistration
Sheet: ClassCapacity

Course # | Class Capacity | Current Number | Helper Column | [NAME] | current num
Workshop101 | 5 | 14 | Workshop101 | 5 | 14
Workshop102 | 10 | 7 | Workshop101 | 5 | 14
Workshop103 | 7 | 7 | Workshop102 | 10 | 7
 |  |  | Workshop103 | 7 | 7
 |  |  | Workshop101 | 5 | 14
 |  |  | Workshop101 | 5 | 14
 |  |  | Workshop102 | 10 | 7
 |  |  | Workshop103 | 7 | 7
 |  |  | Workshop101 | 5 | 14
 |  |  | Workshop101 | 5 | 14
 |  |  | Workshop102 | 10 | 7
 |  |  | Workshop103 | 7 | 7
 |  |  | Workshop101 | 5 | 14
 |  |  | Workshop101 | 5 | 14
 |  |  | Workshop102 | 10 | 7
 |  |  | Workshop103 | 7 | 7
 |  |  | Workshop101 | 5 | 14
 |  |  | Workshop101 | 5 | 14
 |  |  | Workshop102 | 10 | 7
 |  |  | Workshop103 | 7 | 7
 |  |  | Workshop101 | 5 | 14
 |  |  | Workshop101 | 5 | 14
 |  |  | Workshop102 | 10 | 7
 |  |  | Workshop103 | 7 | 7
 |  |  | Workshop101 | 5 | 14
 |  |  | Workshop101
 |  |  | Workshop102
 |  |  | Workshop103
Spreadsheet: 276005d1383722483-formula-to-check-for-name-and-give-a-percentage-lolchamps
Sheet: Raw

Champ | VS | [NAME] | Score | Game
Irelia | [NAME] | Yes | 21/1/10 | Yes
Irelia | [NAME] | No |  | no
Kog | [NAME] | No |  | no
Irelia | [NAME] | yes |  | No
Irelia | [NAME] | yes |  | No
[NAME] | Irelia | No |  | no
[NAME] | [NAME] | No |  | Yes
Irelia | Kog | Yes |  | no
[NAME] | [NAME] | Yes |  | Yes
[NAME] | Kog | Yes
Rene | [NAME] | Yes |  | Yes
Kog | [NAME] | No
[NAME] | Nami | Yes
Spreadsheet: 763349d1642113585-splitting-data-into-two-columns-resource_hourly_bookings__weekly_report_011322
Sheet: Resource_Hourly_Bookings__Weekl

User/Project | Week starting 01/09/2022 | Week starting 01/16/2022 | Week starting 01/23/2022 | Week starting 01/30/2022 | Week starting 02/06/2022 | Week starting 02/13/2022 | Week starting 02/20/2022 | Week starting 02/27/2022
Smith, [NAME] | 39.16 | 39.16 | 38.77 | 31.16 | 41.16 | 41.16 | 41.16 | 36.83
Project1 | 3.16 | 3.16 | 2.53 | 3.16 | 3.16 | 3.16 | 3.16 | 0.63
Project2 | 22 | 22 | 22.24 | 14 | 24 | 24 | 24 | 22.2
Project3 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Project4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
[NAME], [NAME] | 39.16 | 39.16 | 38.77 | 31.16 | 41.16 | 41.16 | 41.16 | 36.83
Project1 | 3.16 | 3.16 | 2.53 | 3.16 | 3.16 | 3.16 | 3.16 | 0.63
Project2 | 22 | 22 | 22.24 | 14 | 24 | 24 | 24 | 22.2
Project3 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Project4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
Jones, [NAME] | 39.16 | 39.16 | 38.77 | 31.16 | 41.16 | 41.16 | 41.16 | 36.83
Project1 | 3.16 | 3.16 | 2.53 | 3.16 | 3.16 | 3.16 | 3.16 | 0.63
Project2 | 22 | 22 | 22.24 | 14 | 24 | 24 | 24 | 22.2
Project3 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Project4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
Custom | [NAME] | Week starting 01/09/2022 | Week starting 01/16/2022 | Week starting 01/23/2022 | Week starting 01/30/2022 | Week starting 02/06/2022 | Week starting 02/13/2022 | Week starting 02/20/2022 | Week starting 02/27/2022
Smith, [NAME] | Project | 39.16 | 39.16 | 38.77 | 31.16 | 41.16 | 41.16 | 41.16 | 36.83
Smith, [NAME] | Project1 | 3.16 | 3.16 | 2.53 | 3.16 | 3.16 | 3.16 | 3.16 | 0.63
Smith, [NAME] | Project2 | 22 | 22 | 22.24 | 14 | 24 | 24 | 24 | 22.2
Smith, [NAME] | Project3 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Smith, [NAME] | Project4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
[NAME], [NAME] | Project | 39.16 | 39.16 | 38.77 | 31.16 | 41.16 | 41.16 | 41.16 | 36.83
[NAME], [NAME] | Project1 | 3.16 | 3.16 | 2.53 | 3.16 | 3.16 | 3.16 | 3.16 | 0.63
[NAME], [NAME] | Project2 | 22 | 22 | 22.24 | 14 | 24 | 24 | 24 | 22.2
[NAME], [NAME] | Project3 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
[NAME], [NAME] | Project4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
Jones, [NAME] | Project | 39.16 | 39.16 | 38.77 | 31.16 | 41.16 | 41.16 | 41.16 | 36.83
Jones, [NAME] | Project1 | 3.16 | 3.16 | 2.53 | 3.16 | 3.16 | 3.16 | 3.16 | 0.63
Jones, [NAME] | Project2 | 22 | 22 | 22.24 | 14 | 24 | 24 | 24 | 22.2
Jones, [NAME] | Project3 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Jones, [NAME] | Project4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
Spreadsheet: kam_keiser__17987__booket info needed
Sheet: Sheet1

ENE
11/30 DPR & Supporting Documentation
 |  |  |  |  |  |  | Risk Lead
Section 1: | Summary ENE DPR 11/30 |  |  |  |  |  | Wilson
 |  | including:  Gross PRMA, A/R, A/P & Unbilled Services | Gross PRMA/L, A/R, A/P & Unbilled Services
 |  |  | (both with & without I/Co, when available)
Section 2 thru 8: | Summary 11/30 DPR for Each Wholesale Business Unit
 |  |  | ENA Gas |  |  |  | R Hall/Albrecht
 |  |  | ENA Power |  |  |  | R Hall/Albrecht
 |  |  | Canada |  |  |  | R Hall/Albrecht
 |  |  | EIM  (with ECTRIC split) |  |  |  | Sweeney
 |  |  | EGM (with ECTRIC split) |  |  |  | Sweeney
 |  |  | EBS |  |  |  | Miralles
 |  |  | EES |  |  |  | Mills
 |  |  | Europe (ECTRIC) |  |  |  | Horn
 |  | including: | Rolls supporting the DPR information
 |  |  | Gross PRMA, A/R, A/P & Unbilled Services
 |  |  | (both with & without I/Co, when available)
 |  |  | Net PRMA
 |  |  | Number of Active Transactions as at 11/30
 |  |  | Number of Open Transactions as at 11/30
 |  |  | Number of Books (with DPR's for each Book)
 |  |  | Number of people, both Comm & Comm Supp as at 11/30
 |  |  | Average number of Transactions per day for 2001
 |  | plus: | E&Y Information
 |  |  | - requests to be provided by [NAME]
 |  |  | - will focus on Realizable Values
 |  |  | - will focus on CP's
 |  |  | - will focus on Legal Entities
Section 9: | Summary 11/30 DPR for Each Non-Wholesale Business Unit
Spreadsheet: 807320d1669840912-using-countifs-with-data-validations-lists-book1
Sheet: Sheet1

Fig. 1
Empl. # | Name | Agency | Sun | Mon | [NAME] | Wed | Thurs | Fri | Sat |  |  | Count of Y & N | Count of N | Absence %
123 | [NAME] | Agency A |  | Y | N | Y | N | Y |  |  | Agency A | 9 | 4
456 | [NAME] | Agency B | N | Y | Y | N | Y | Y | N |  | Agency B | 18 | 7
789 | Mark | Agency C | Y | Y | N |  | N | Y | Y |  | Agency C | 6 | 2
101112 | [NAME] | Agency B | N |  | Y | N | Y | N | Y |  | Count the number of Y and N's (ignore blanks) for each agency
131415 | Jan | Agency B |  | Y | N | Y | Y | Y |  |  | Count the number of  N's only for each agency
161718 | [NAME] | Agency A |  | N | Y |  | Y | N |  |  | Find percentage % of N out of "Y&N"
Assumptions: | Y = Present
 | N = Unscheduled Absence
 | Blank - Scheduled Absence
 | Agency column is a data validation list (containing Agency A, Agency B & Agency C)
 | Each cell under the days of the week are data validation lists (containing Y and N)
Spreadsheet: 704430d1605544032-finding-2-values-from-another-sheet-sample-test
Sheet: Main

TITLE | TEXT A | TEXT B | TEXT C | TEXT D
TEXT 1
TEXT 2
TEXT 3
TEXT 4
Spreadsheet: 191897d1352239949-counting-unique-criteria-example
Sheet: Data

Employee | Branch | Account Number | Checking | Saving | Credit Card
[NAME] | NYC | 1 | y
[NAME] | Philly | 2 | y
[NAME] | NYC | 3 | y
[NAME] | Dallas | 4 |  | y
[NAME] | Dallas | 5 |  |  | y
[NAME] | Dallas | 6 |  | y
[NAME] | HK | 7 | y
[NAME] | Dallas | 8 | y
[NAME] | NYC | 9 |  |  | y
[NAME] | NYC | 10 |  | y
[NAME] | Philly | 11 | y
Exie Desir | India | 12 |  |  | y
Spreadsheet: 881157d1729081434-create-additional-rows-for-second-set-of-data-data-test
Sheet: Sheet1

Item | Cost1 | Status1 | Flavour1 | Cost2 | Status2 | Flavour2
1 | 11 | Out | Horrible | 39 | Out | Horrible
2 | 90 | Out | Tasty | 72 | Out | Tasty |  |  |  | Item | Cost1 | Status1 | Flavour1
3 | 52 | IN | Horrible | 92 | IN | Horrible |  |  |  |  | 39 | Out | Horrible
4 | 76 | Out | Horrible | 99 | Out | Horrible |  |  |  | 1 | 11 | Out | Horrible
5 | 28 | Out | Tasty | 16 | IN | Tasty |  |  |  | 2 | 72 | Out | Tasty
 |  |  |  |  |  |  |  |  |  | 2 | 90 | Out | Tasty
 |  |  |  |  |  |  |  |  |  | 3 | 92 | IN | Horrible
 |  |  |  |  |  |  |  |  |  | 3 | 52 | IN | Horrible
 |  |  |  |  |  |  |  |  |  | 4 | 99 | Out | Horrible
 |  |  |  |  |  |  |  |  |  | 4 | 76 | Out | Horrible
 |  |  |  |  |  |  |  |  |  | 5 | 16 | IN | Tasty
 |  |  |  |  |  |  |  |  |  | 5 | 28 | Out | Tasty