tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 214537d1360956345-repost-link-table-to-database-linked-table-survey-ex
Sheet: BSS Score

Created By | 1.	Whic strategic priority does this application support? | 2.	What business purpose does the application serve? | 3.	What is your opinion of the application’s functionality? | 4.	Do the application features meet your business process needs? | 5.	Did the application work properly after initial installation? | 6.	Are you able to easily accomplish your work using this application? | 7.	Are you satisfied with your knowledge and experience with the application? | 8.	Are you able to navigate through the application with ease? | 9.	Are you satisfied with the data flow of the application? | 10.	Is the application uptime acceptable? | 11.	Does the application behave consistently each time you access it to do your work? | 12.	Does the application respond in a reasonable timeframe? | 13.	How often does the application freeze or crash? | 14.	Which work processes suffer during a system outage? | 15.	How many departmental employees are affected during an outage? | 16.	Is there a manual or other workaround for an outage associated with this application? | 17.	Are you satisfied with the overall level of knowledge and ability to answer questions related to this application of your internal business unit SME? | 18.	Are you satisfied with the Help Desk team’s overall level of knowledge and ability to resolve problems related to this application? | 19.	How satisfied are you with the end-user training that accompanied this application? | 20.	How satisfied are you with the end-user documentation (training manuals, checklists) that accompanied this application? | Total Score | [NAME] | Percent Score
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57
Spreadsheet: 093532a8-0569-45ce-b52e-45010cfeeb5c
Sheet: 2.1 Student Tuition & Costs

Institution
Indicator 2: Financial Resources and Student Costs
Table 2.1: Student Tuition, Financial Aid, and Costs / AY 2010-11
Please enter the  tuition cost per credit hour, the total amount of financial aid received and the number of students receiving aid, and undergraduate student costs.
Tuition Cost per Credit Hour |  |  | AY 10-11
Undergraduate | American Indian Student |  | 80
 | Non-Indian Student |  | 98
Graduate | American Indian Student |  | 115
 | Non-Indian Student |  | 115
Sources and Amount of Financial Aid |  |  | AY 10-11
American Indian College Fund Scholarship |  | Total Dollar Amount | 270830
 |  | Total Number of Recipients | 208
Federal [NAME] |  | Total Dollar Amount | 5189010
 |  | Total Number of Recipients | 1445
Federal Supplemental Educational Opportunity Grant |  | Total Dollar Amount | 86872
 |  | Total Number of Recipients | 195
State Scholarships/Grants |  | Total Dollar Amount | 74947
 |  | Total Number of Recipients | 249
Academic Competitiveness Grant |  | Total Dollar Amount | 15893
 |  | Total Number of Recipients | 28
School-to-Work |  | Total Dollar Amount | 0
 |  | Total Number of Recipients | 0
[NAME] |  | Total Dollar Amount | 922811
 |  | Total Number of Recipients | 423
Tuition Waiver/Discount |  | Total Dollar Amount | 30149
 |  | Total Number of Recipients | 67
Other Scholarships |  | Total Dollar Amount | 253854
 |  | Total Number of Recipients | 189
Federal College Work Study |  | Total Dollar Amount | 72855
 |  | Total Number of Recipients | 51
State Work Study |  | Total Dollar Amount | 0
 |  | Total Number of Recipients | 0
Institutional Work Study |  | Total Dollar Amount | 0
 |  | Total Number of Recipients | 0
Average Full Time Undergraduate Student Costs for Academic Year |  |  | AY 10-11
Tuition |  |  | 1920
Room and Board |  |  | 5400
Transportation |  |  | 3000
Text Books |  |  | 1200
Supplies |  |  | m
Personal Expenses |  |  | m
Miscellaneous Expenses |  |  | 1850
Fees |  |  | 476
Total Student Costs
Notes:
Spreadsheet: 166010d1341426861-lookup-value-across-columns-and-return-value-2-columns-further-excel-test-clean-up
Sheet: Clean-up

 | Visit
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Participant
1 | 0.815479819982216 |  | 0.9132601797191283 | 0.9972148987846264 |  | 0.4008669055658101 | 0.9060067276599695 | 0.918869316879322
2 |  |  | 0.1319618734622778 |  | 0.3868080933093616 | 0.06353774906050003 |  | 0.5309539681232994 | 0.5200875829037076
3 | 0.3223667177244848 | 0.9783539464986656 |  | 0.08576964608905102 |  | 0.6334309868430417
4 |  |  |  | 0.7215030337423222 | 0.8596239414422454 |  |  |  | 0.1915680997609776
5 |  |  | 0.9693609827489089 |  | 0.8259112638449115 | 0.3624301776817201 | 0.526732811408897 |  | 0.2744228708836098
6 |  |  |  | 0.3876392187871331 | 0.8764373037498684 |  |  | 0.9553112303457686
7 | 0.7491751922701397 | 0.6100616770713712 |  | 0.2619390011274524 |  | 0.5600352886144593 | 0.2534927760975464
8 | 0.8845706114151499 |  |  |  |  | 0.8747243228795715 | 0.9624296613963566
9 |  | 0.3883527738175335 | 0.1024867200603109 |  | 0.1452344076308235 |  | 0.6670045704478549
10 |  |  |  | 0.4770215664252078 |  | 0.606542860598275
11 | 0.6024661528400714 | 0.3562378879479734 |  | 0.5786683088389225 | 0.4636165615932127
12 |  |  | 0.6984005997923036 |  |  |  |  | 0.0650261277937777
13 |  |  |  |  |  | 0.8676222464545604 |  |  |  | 0.1940879407664665
14 |  | 0.5531617079231573 |  | 0.3142719719269083 | 0.5948613516725609 | 0.6109265789215668
15 |  |  | 0.2416427372973989 |  |  |  | 0.5833709122567476 | 0.9415539446981847
16 | 0.5847680966074363 | 0.57021847020255 |  |  | 0.5023366756656505
17 |  |  |  |  |  |  | 0.890973843678016 | 0.8419721476747595 | 0.4699550579625218 | 0.8993856345478317
18 |  |  |  | 0.9227111976026221 | 0.6717477180271725 |  |  |  | 0.7677016563280878
19 |  | 0.5779927139172939 | 0.7811351092948862 | 0.9266821000896007 |  | 0.5937039988972661 | 0.2034756821055868
20 |  | 0.2086481409639334 | 0.9739070039733274 |  |  |  |  | 0.7066695959424599
21 |  | 0.5344688145593905 |  | 0.741169268873804 | 0.3249086318196009 | 0.8772681604509641
22 | 0.7320843024477838 |  |  |  |  |  | 0.5077087923892166 |  | 0.4108617268935366
23 |  |  |  |  |  | 0.9760197471195883 | 0.447255992916658 | 0.07840297726497591
24 |  |  |  |  |  |  |  | 0.7067460194881312 | 0.6694575287009401
25 |  |  | 0.09068127111955093 | 0.6778005998457944 |  | 0.9445637932382972 |  | 0.1007469266447232
26 |  | 0.1070117388163115 | 0.5639040345742296 |  |  | 0.4012166088676646 | 0.8721608510749004
27 | 0.7300250880888492 | 0.158557682871206 |  |  | 0.6525429916593257
28 | 0.6193800777039186 | 0.8954447054972408 |  |  | 0.2620910523601953
29 |  | 0.5056159568028759 | 0.1839761703558824 | 0.3998387280184723 | 0.2113722612846952
30 | 0.9667001510850055 | 0.04124335451984595 |  |  |  | 0.6839933989840101 | 0.2744206717749024
Spreadsheet: darrell_schoolcraft__7774__imbalsumm0106
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -12949
3531 | -274395 | -169301
60667
60749 |  | -406447
61206
61334 | -70301
62960
INDEX
2001-05-31 00:00:00 |  |  | 1177095.58
2001-06-13 00:00:00
Spreadsheet: 525826d1498938717-conditional-formatting-future-dates-on-cell-tobe-formatted-hr-template
Sheet: 2

 | Mandatory Training |  |  | Induction |  | Customer Complaints |  | Data Protection |  | Anti-Money Laundering |  | Bribery |  | Health & Safety
 | 2 | Director |  | Date Completed | [NAME] Due | Date Completed | [NAME] Due | Date Completed | [NAME] Due | Date Completed | [NAME] Due | Date Completed | [NAME] Due | Date Completed | [NAME] Due
 |  |  |  | 2015-10-15 00:00:00 | 2016-04-15 00:00:00 |  |  | 2002-04-19 00:00:00 | 2002-11-21 00:00:00
 |  |  |  | 2016-10-15 00:00:00 | 2017-04-15 00:00:00
 |  |  |  | 2017-04-15 00:00:00 | 2017-10-15 00:00:00
Spreadsheet: 40925f35-d277-4415-942f-fc4d22f16c73
Sheet: Sheet1

Organization | Iowa Procurement Services Division | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Bid Creator | Ryan  Roovaart Purchasing Agent 3
[NAME] | [EMAIL]
Phone | (515) 281-5602
Fax | (515) 725-0162
Bid Request Number | RFB1011005160
Title | Auto Body Repair and Parts for the Council Bluffs Area
Description
Bid Type | RFB
Open Date | 4/29/2011 11:30:00 AM Central
Close Date | 5/13/2011 3:00:00 PM Central
Need by Date
Line | Quantity | UOM | Description | Manufacturer | Manuf. Number | [NAME] | Award Quantity | Awarded Supplier | [NAME]
1.0 | 1 | EA | Discount on OEM Domestic Replcement Parts |  |  | 10 | 1 | ALL MAKES COLLISION
2.0 | 1 | EA | Discount on OEM Import Replacement Parts |  |  | 10 | 1 | ALL MAKES COLLISION
3.0 | 1 | EA | Discount on aftermarket or quality used parts for vehicles no longer under warranty. |  |  | 10 | 1 | ALL MAKES COLLISION
4.0 | 1 | Hour | Hourly Rate for Metal and [NAME] work. |  |  | 34 | 1 | ALL MAKES COLLISION
5.0 | 1 | Hour | Hourly rate for Frame work. |  |  | 40 | 1 | ALL MAKES COLLISION
6.0 | 1 | Hour | Hourly rate for refinishing. |  |  | 35 | 1 | ALL MAKES COLLISION
7.0 | 1 | Hour | Hourly rate for mechanical work. |  |  | 40 | 1 | ALL MAKES COLLISION
8.0 | 1 | Hour | Hourly rate for Paint and Materials |  |  | 25 | 1 | ALL MAKES COLLISION
9.0 | 1 | mile | Towing price for running mile not to exceed 50 miles. |  |  | 2 | 1 | ALL MAKES COLLISION
10.0 | 1 | EA | Towing per trip charge |  |  | 25 | 1 | ALL MAKES COLLISION
Spreadsheet: bill_williams_iii__1399__xxxdealenterySeptember
Sheet: Blank

0
Deal #s
Delivery Pt.
Counterparty
Totals
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
TIE POINTS
Spreadsheet: 702900d1604596755-cell-to-generate-the-sum-of-the-quantity-of-items-from-multiple-cells-that-have-formulas-order-form1
Sheet: Sheet2

1.5 book cartons | 1.1
3.1 linen cartons | 2.01
4.5 large cartons | 2.49
5.2 dishpack cartons | 4.36
6.1 lampshade cartons | 3.36
Lamp cartons | 3.76
Small Mirror cartons - pair | 5.5
Large Mirror cartons - pair | 6.5
Newsprint sheets 25 lb/bundle | 18
10.1 D/W Wardrobes | 8.58
18" hanger bars | 1.3
Shrink Wrap:  18" x 1500' | 20.685
K/Q Universal Mattress cartons | 23
Double Mattress cartons | 11.69
Single Mattress cartons | 9.82
Crib Mattress Box | 7.58
Paper pads - 60" x 72", 3 ply | 1.63
TV carton, including foam kits | 48
Grandfather Clock [NAME] | 62.426
Tape | 0.96
Mattress [NAME] | 4.17
Export Wrap (Old Bubble Kraft/Brown Paper) per roll | 107
Bubble wrap per roll AUS | 65
Bubble wrap per roll Others | 130
LDN container | 99.75
Blue Moving Blanket | 15.4
Commercial bins | 27
[NAME] | 4.64
Letter Pop Totes | 3.3
Carpet Shield per roll HYM | 18
Carpet Shield per roll Others | 70
[NAME] | 17
Spreadsheet: 9fd3dd05-a3c3-4b06-b886-fcdbc92f0782
Sheet: 3.1

 | Cuadro 3.1
 | [NAME]
 | Matrimonios registrados, según mes, 2010
 | [NAME] | Matrimonios
 | Total País
 | Enero | 3687
 | Febrero | 3478
 | Marzo | 3965
 | Abril | 3422
 | Mayo | 3050
 | [NAME] | 3125
 | [NAME] | 3711
 | [NAME] | 3378
 | Septiembre | 3095
 | Octubre | 3252
 | Noviembre | 3870
 | Diciembre | 5764
 | Nota: Elaborado con datos registrados en las oficialías del estado civil. Junta Central Electoral
 | Fuente: Oficina Nacional de Estadística, (ONE)
Spreadsheet: sally_beck__35760__MgmtSum-Q1-0327
Sheet: Upside Downside

Upside / Downside Analysis
 |  |  | Estimate |  | Plan |  | [NAME]
Actual Margin
Deals Identified
Forecast Items:
 | Financial Drift
 | ECP Accretion
 | Gas Assets
 | City Forest |  | -1
 | Kafus/Canfibre Riverside IPC |  | -3
 | Cgas
 | Private Revaluations
Less Expenses:
 | Operating Expenses
 | Commercial & Group Expenses
 | Interest & Interest Related Charges
Identified Earnings
Potential Upsides:
 | 2000 Bonus Accrual (included in forecast) |  | 20
 | Sithe Interest |  | 8
 | ENE Stock Price (PSU Hedge) |  | 3
 | Kaiser |  | 4
 | Cost of Funds
Potential Downsides:
 | ICAP |  | -20
 | Ecogas |  | -12
 | Turbines (6B's) |  | -5
 | TFM (Mexico Deal) |  | -0.85
 | Duke Gas Contract
Earnings Before Tax
Spreadsheet: 454633d1459921720-how-can-i-use-subtotal-for-count-unduplicates-value-example
Sheet: Sheet1

 |  |  | diplay  result filter of "0" | 5
 |  |  | diplay  result filter of "1" | 4
 | Value | Value filter
 | 1 | 0
 | 0 | 1
 | 5 | 0
 | 1 | 0
 | 2 | 0
 | 3 | 0
 | 2 | 1
 | 3 | 1
 | 4 | 0
 | 4 | 1
 | 3 | 1
 | 2 | 0
 | 2 | 1
 | 3 | 1
 | 4 | 0
 | 4 | 0
 | 3 | 1
 | 3 | 0
 | data always update
Spreadsheet: 294175d1391222046-move-data-from-tab-to-different-named-tab-based-on-value-in-k-master-view
Sheet: SAC

Serial Number | Model | Building | Total [NAME] | Total [NAME] | Room | Campus
ADEFTH |  | [NAME] | 2 | 3 |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  |  |  |  | SAC
 |  |  | 2 | 3
`
Spreadsheet: 174553d1345109104-input-sheet-output-form-can-i-do-it-weeklydata
Sheet: Week3

SL | Name | Amount | Cash/Cheque
1 | I | 100 | Cash
2 | J | 200 | Cash
3 | K | 300 | Cheque
4 | L | 400 | Cheque
Spreadsheet: 017abfa3-0818-4d93-9b25-c02a153956bb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  | BUXHETI  SIPAS BURIMEVE TË FINANCIMIT
 |  |  |  |  |  |  | Tabela.1
 |  |  | Nr | BURIMET E FINANCIMIT |  |  | Shuma
 |  |  | 1 | GRANT QEVERITAR |  |  | 9909297
 |  |  | 2 | TE HYRAT VETANAKE TE VJELURA NË VITIN 2011 |  |  | 1570324.53
 |  |  | 3 | TE HYRAT VETANAKE TE VITIT 2010 TE ALOKUARA NE VITIN 2011 |  |  | 521431.65
 |  |  | 4 | GRANT I DONATORVE TE MBRENDSHEM |  |  | 1034.85
 |  |  | 5 | GRANT I DONATORVE TE JASHTEM |  |  | 33765
 |  |  |  | GJITHËSEJT |  |  | 12035853.03
 |  |  |  | SHPERNDARJA E BUXHETIT SIPAS KATEGORIVE EKONOMIKE
 |  |  |  | KATEGORIT EKONOMIKE |  |  | Shuma
 |  |  | 1 | PAGA DHE MEDITJE |  |  | 6615294
 |  |  | 2 | [NAME] SHËRBIME |  |  | 865090.03
 |  |  | 3 | SHPENZIME KOMUNALE |  |  | 131228.16
 |  |  | 4 | SUBVENCIONE DHE TRANSFERE |  |  | 117202.92
 |  |  | 5 | INVESTIME KAPITALE |  |  | 4307037.92
 |  |  |  | GJITHËSEJT |  |  | 12035853.03
Spreadsheet: 774497d1648502568-selecting-products-using-multiple-drop-down-menus-product-selector-table
Sheet: Selector

 |  |  |  | Attribute 1 | Attribute 2 | Price | Result
 |  |  |  | [NAME] | Travel Cover (Trailerable) |  | Product 1
 |  |  |  |  |  | $$$ | Product 3
 |  |  |  |  |  | $$ | Product 5
 |  |  |  |  |  | $$ | Product 9
 |  |  |  |  |  | $$$ | Product 10
 |  |  |  |  |  | $$ | Product 11
 |  |  |  |  |  | $$$ | Product 12
 |  |  |  |  |  | $$$ | Product 16
Spreadsheet: dutch_quigley__9463__011127 Nemak
Sheet: Deal Sheet for Printing

 |  |  |  |  |  |  |  |  |  |  |  |  |  | PURCHASE BEHIND  PLANT |  |  |  |  |  | DEDICATED RESERVES
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAME PLANT:________________ |  |  |  |  |  | FIRST PURCHASER
Enron Captial & Trade Resources Corp.
 |  |  |  |  |  |  |  | Executed Deal Ticket |  |  |  |  |  | DEAL NUMBER |  |  |  |  | Deal | #________________
COUNTERPARTY/CUSTOMER |  |  | CONTACT |  |  |  |  | ORIGINATOR |  |  | DEAL DATE |  |  | TRANSACTION TYPE(SWAP, CAP, INDEX, ETC.)
Nemak |  |  | [NAME] |  |  |  |  | [NAME] |  |  | 2001-11-27 00:00:00 |  |  | Swap
ECTR COUNTERPARTY |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PHYSICAL DELIVERY POINT/PIPELINE |  |  |  |  | COMMODITY
ENA |  |  |  |  |  |  |  |  |  |  | HPL/SHPCHAN |  |  |  | --- |  |  |  |  | NG
UNIT OF MEASURE |  |  | MW |  |  |  | CURRENCY |  | BROKER |  | FEE |  |  | DEAL STATUS |  |  |  | SETTLEMENT
 |  |  |  | --- |  |  |  |  | --- |  | ---
 |  |  | RISK MANAGER INITIALS:
PHYSICAL  NOTIONAL DEL  START DATE | PHYSICAL  NOTIONAL DEL  END DATE | REFERENCE  CODE (e.g. NX3) | FINANCIAL  REFERENCE  START DATE |  | FINANCIAL REFERENCE END  DATE |  | FIRM  QUANTITY  (A) | OPTION/OMICRON  QUANTITY (B) |  | TOTAL MAXIMUM  QUANTITY (A+B) | FIXED  PRICE | BASIS | C PHYSICAL  PREMIUM | C ADMIN/ OTHER | C TRANSPORT  PRICE |  | C OMICRON  PRICE | CONTRACT  PRICE/ STRIKE | C OPTION  PREMIUM |  | ORIGINATION
 |  |  |  |  |  |  |  |  |  |  |  | EFP
 |  | NX1 | 2002-01-01 00:00:00 |  | 2002-03-01 00:00:00 |  | 234000 |  |  |  | 2.8975 | -0.0375 |  |  |  |  |  | 2.86 |  |  | 0.0225
[NAME]:
Spreadsheet: louise_kitchen__24093__NEWCO HEADCOUNT NAMES
Sheet: Gas Trading

Gas Trading | ok
[NAME] | East Trading | Analyst
[NAME] | West Trading | Analyst
[NAME] | West Trading | Analyst
[NAME] | West Trading | Analyst
[NAME] | West Trading | Analyst | 5
[NAME] | NGL | Associate
[NAME] | Texas Trading | Associate
[NAME] | Financial Trading | Associate
[NAME] | Texas Trading | Associate
[NAME] | West Trading | Associate
[NAME] | Financial Trading | Associate
[NAME] | West Trading | Associate | 7
[NAME] | East Trading | Director
[NAME] | Central Trading | Director
Brad Mckay | East Trading | Director
[NAME] | West Trading | Director
[NAME] | Central Trading | Director
[NAME] | West Trading | Director
[NAME] | East Trading | Director
[NAME] | West Trading | Director
[NAME] May | Financial Trading | Director
[NAME] | Financial Trading | Director
[NAME] | East Trading | Director
Wade Hicks | NGL | Director | 12
[NAME] | West Trading | Director, Managing | 1
[NAME] | Central Trading | Manager
[NAME] | Financial Trading | Manager
[NAME] | East Trading | Manager
[NAME] | Central Trading | Manager
[NAME] | NGL | Manager
[NAME] | Central Trading | Manager
[NAME] | East Trading | Manager
Tori Kuykendall | West Trading | Manager | 8
[NAME] | Central Trading | Sr. Spec
[NAME] | Central Trading | Sr. Spec | 2
[NAME] | Financial Trading | Vice Pres
[NAME] | Trading | Vice Pres
[NAME] | Central Trading | Vice Pres
[NAME] | Texas Trading | Vice Pres
[NAME] | Financial Trading | Vice Pres
[NAME] | West Trading | Vice Pres
[NAME] | East Trading | Vice Pres
[NAME] | Texas Trading | Vice Pres | 8
 |  | TOTAL
Spreadsheet: robert_badeer__33100__Calger Collected Graphs 23 June 2000
Sheet: Table_New Gen

High Probability WSCC Projects
Project | State | On-Line Date | Capacity | Region | Cumulative Capacity
Colorado Springs [NAME] | CO | 1999-10-01 00:00:00 | 70
Deming | NM | 1999-11-01 00:00:00 | 250 | DSW
Priscilla | NV | 2000-03-01 00:00:00 | 216
El Dorado | NV | 2000-05-01 00:00:00 | 492 | DSW
Person | NM | 2000-05-01 00:00:00 | 140 | DSW
Manchief (Brush) | CO | 2000-06-01 00:00:00 | 265 | Rockies
Valmont Repowering | CO | 2000-12-01 00:00:00 | 11 | Rockies
Vestas (100MW Wind) | OR | 2001-01-01 00:00:00 | 25 | PNW
South Point Power Plant [Mojave] | AZ | 2001-05-01 00:00:00 | 545 | DSW
Griffith Energy Project | AZ | 2001-05-01 00:00:00 | 520 | DSW
[NAME] | AZ | 2001-06-01 00:00:00 | 600 | DSW
Sutter | CA | 2001-07-01 00:00:00 | 500 | NP15
[NAME] | OR | 2001-07-01 00:00:00 | 500 | PNW
43rd Avenue Plant Repower | AZ | 2001-08-01 00:00:00 | 70 | DSW
[NAME] (Pittsburg) | CA | 2001-08-01 00:00:00 | 500 | NP15
La Paloma | CA | 2001-09-01 00:00:00 | 1048 | ZP26
Rathdrum | ID | 2001-09-01 00:00:00 | 270 | PNW
43rd Avenue Phase 2 Repower | AZ | 2001-12-01 00:00:00 | 70 | DSW
[NAME] | WA | 2001-12-01 00:00:00 | 248 | PNW
Coyote Springs Phase 2 | OR | 2002-03-01 00:00:00 | 280 | PNW
Delta Energy | CA | 2002-04-01 00:00:00 | 880 | NP15
Powhatan 48 | CO | 2002-05-01 00:00:00 | 150 | Rockies
Hermiston | OR | 2002-05-01 00:00:00 | 536 | PNW
Spreadsheet: 796302d1663209864-matching-sales-amount-to-deposit-date-matching-sales-amount-to-deposit-date
Sheet: Sheet1

Bank Statement |  |  | POS Data
Deposit Date | Deposit Amount |  | Sales Date | Sales Amount | Date Banked-in
2022-01-01 00:00:00 |  |  | 2022-01-01 00:00:00 | 439.79
2022-01-02 00:00:00 |  |  |  | 110.85 |  |  |  | Date Banked-in in column F is derived from Deposit Date in column A
2022-01-03 00:00:00 |  |  |  | 306.93 |  |  |  | How do I set a formula in cells F3 onwards to search for Deposit Date in column A and to search only between 7 days from Sales Date?
2022-01-04 00:00:00 |  |  |  | 168.65 |  |  |  | Example, Sales Amount of $439.79 on 01/01/22 must match to Deposit Amount in column B from 01/01/22 to 07/01/22 (7 days).
2022-01-05 00:00:00 |  |  |  | 215.07
2022-01-06 00:00:00 | 439.79 |  |  | 362.52
2022-01-06 00:00:00 | 110.85 |  |  | 479.76
2022-01-08 00:00:00 | 168.65 |  |  | 439.79
2022-01-08 00:00:00 | 215.07 |  |  | 283.3
2022-01-08 00:00:00 | 362.52 |  |  | 396.53
2022-01-08 00:00:00 | 479.76 |  |  | 174.19
2022-01-13 00:00:00 | 439.79
2022-01-13 00:00:00 | 283.3
Spreadsheet: 836487d1689404667-query-across-multiple-columns-and-multiple-criteria-with-flexible-content-ice-monthly-plan
Sheet: Scratchpad

IGNORE
=SUMPRODUCT(SUMIF(INDIRECT("'"&"Project A"&"'!"&G7:V7),G7,INDIRECT("'"& "Project A" &"'!"&G8:V8)))
Does work as not always row 7 or 8
=SUMPRODUCT(SUMIFS(INDIRECT("'"&F3:F6&"'!"&"D3:D7"),INDIRECT("'"&F3:F6&"'!"&"C3:C7"),H3))
 |  | #REF! | #REF!
 | #REF! | #REF! | #REF!
P | A | B | C
X | 1 | 2 | 3
Y | 4 | 5 | 6
Z | 7 | 8 | 9
Spreadsheet: 174956d1345250925-transpose-and-sort-transpose-and-sort
Sheet: Sheet1

Organization | Record |  |  |  | AB | AC | AH |  |  | Organization | Record | New data being entered
AC | Record-1 |  |  |  |  |  |  |  |  | AB | Record-5
AH | Record-2 |  |  |  |  |  |  |  |  | AC | Record-8
AC | Record-3 |  |  |  |  |  |  |  |  | AH | Record-6
AB | Record-4
AB | Record-5
AH | Record-6
AC | Record-7
AC | Record-8
AC | Record-9
AH | Record-10
AC | Record-11
AC | Record-12
AB | Record-13
AB | Record-14
AB | Record-15
AB | Record-16
Spreadsheet: 273441d1382713236-sumproduct-or-countif-when-1-counting-between-dates-and-2-adding-the-values-that-fall-in-miles1
Sheet: Sheet1

Date | [NAME]
 |  |  |  |  |  | [NAME]
2013-10-01 00:00:00 | 10 |  |  |  | Jan
2013-10-02 00:00:00 | 5 |  |  |  | Feb
2013-10-03 00:00:00 | 3 |  |  |  | Mar
2013-10-04 00:00:00 | 2 |  |  |  | Apr
2013-10-05 00:00:00 | 13 |  |  |  | May
2013-10-06 00:00:00 | 1 |  |  |  | Jun
2013-11-01 00:00:00 | 5 |  |  |  | Jul
2013-11-08 00:00:00 | 9 |  |  |  | Aug
2013-11-15 00:00:00 | 5 |  |  |  | Sep
 |  |  |  |  | Oct | 34
 |  |  |  |  | Nov | 19
 |  |  |  |  | Dec