tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 884179d1733242877-sumif-index-match-array-sum-if-index-match-array
Sheet: MTH

 |  |  | FY2324 | FY2324 | FY2324 | FY2324 | FY2324 | FY2324 | FY2324 | FY2324 | FY2324 | FY2324 | FY2324 | FY2324 | FY2425 | FY2425 | FY2425 | FY2425 | FY2425 | FY2425 | FY2425 | FY2425 | FY2425 | FY2425 | FY2425 | FY2425 | FY2526 | FY2526 | FY2526 | FY2526 | FY2526 | FY2526 | FY2526 | FY2526 | FY2526 | FY2526 | FY2526 | FY2526 | FY2627 | FY2627 | FY2627 | FY2627 | FY2627 | FY2627 | FY2627 | FY2627 | FY2627 | FY2627 | FY2627 | FY2627 | FY2728 | FY2728 | FY2728 | FY2728 | FY2728 | FY2728 | FY2728 | FY2728 | FY2728 | FY2728 | FY2728 | FY2728 | FY2829 | FY2829 | FY2829 | FY2829 | FY2829 | FY2829 | FY2829 | FY2829 | FY2829 | FY2829 | FY2829 | FY2829 | FY2930 | FY2930 | FY2930 | FY2930 | FY2930 | FY2930 | FY2930 | FY2930 | FY2930 | FY2930 | FY2930 | FY2930 | FY3031 | FY3031 | FY3031 | FY3031 | FY3031 | FY3032 | FY3031 | FY3031 | FY3031 | FY3031 | FY3031 | FY3031 | FY3132 | FY3132 | FY3132 | FY3132 | FY3132 | FY3132 | FY3132 | FY3132 | FY3132 | FY3132 | FY3132 | FY3132 | FY3233 | FY3233 | FY3233 | FY3233 | FY3233 | FY3233 | FY3233 | FY3233 | FY3233 | FY3233 | FY3233 | FY3233 | FY3334 | FY3334 | FY3334 | FY3334 | FY3334 | FY3334 | FY3334 | FY3334 | FY3334 | FY3334 | FY3334 | FY3334 | FY3435 | FY3435 | FY3435 | FY3435 | FY3435 | FY3435 | FY3435 | FY3435 | FY3435 | FY3435 | FY3435 | FY3435
 |  | a
 |  | b
 |  | c
 |  | d
 |  | e | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
 |  | f
 |  | g
Spreadsheet: 820488d1678125487-product-percentages-based-on-a-date-criteria-sample-sheet-1-
Sheet: Sheet1

 |  | Year | increase
 |  | 2022 | 0.031
 |  | 2021 | 0.005
 |  | 2020 | 0.017
 |  | 2019 | 0.024
 |  | 2018 | 0.03
 |  | 2017 | 0.01
 |  | 2016 | 0
 |  | 2015 | 0.012
 |  | 2014 | 0.027
 |  | 2013 | 0.022
 |  | 2012 | 0.052
 |  | 2011 | 0.031
 |  | 2010 | 0
 |  | 2009 | 0.05
 |  | 2008 | 0.039
 |  | 2007 | 0.036
 |  | 2006 | 0.027
 |  | 2005 | 0.031
 |  | 2004 | 0.028
 |  | 2003 | 0.017
 |  | 2002 | 0.017
 |  | 2001 | 0.033
 |  | 2000 | 0.011
 |  |  |  |  |  |  |  |  | Task: instead of having to break down the criteria in columns E,F and [NAME] And instead of using a shift+ctrl+enter cell with product. I want to use an aggregate formula that take criteria from anything within or equal to the date ranges and the products those percentage increase. Output should be 1.0834
 |  | Date Lower Range |  | 2016 |  | Desired output
 |  | Date Upper Range |  | 2020
 |  |  |  |  |  | Failed attempt
Spreadsheet: 3c3fb57a-02a8-4b86-afbe-ed320a1d0d5f
Sheet: Capacity Zone

Annual Reconfiguration Auction Result Report
SP_ARARESULT_<customer id>_<commitment period begin>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Capacity Zone Information |  |  | Capacity Zone RA Result
Capacity Zone ID | Capacity Zone Name | Capacity Zone Type | Start Date | End Date | Total Supply Offers Submitted | Total Demand Bids Submitted | Total Supply Offers Cleared | Total Demand Bids Cleared | Net Capacity Cleared | ISO Supply Offer | [NAME] | ISO Supply Offer Cleared | [NAME] | Clearing Price
Number | String | String | Date | Date | MW | MW | MW | MW | MW | MW | MW | MW | MW | $/kW-Month
Spreadsheet: 783581d1654932359-search-exact-match-not-sure-where-the-problem-is-sample-data
Sheet: data (2)

 |  |  |  |  |  |  |  | Sales Team
 |  |  |  |  |  |  |  | Jo
 |  |  |  |  |  |  |  | [NAME]
Email_subject | Email_date | Email_sender | Email_text | Sender |  |  |  | Meg
[NAME] | [NAME] date | Sender | Content including same Meg
[NAME] | [NAME] date | Sender | Content including job [NAME]
[NAME] | [NAME] date | Sender | Content including mega [NAME]
Spreadsheet: 010a065c-2e75-4483-b4d0-2eb957a26867
Sheet: General Education

Foundations |  |  |  |  | Required
Requirement | Y | N | Course(s) taken | Credits | Credits
 |  |  |  |  | 4
 |  |  |  |  | 4
3. Quantitative Reasoning (Q) |  |  |  |  |  | Uses MTH 1217
 |  |  |  |  | 4
Explorations |  |  |  |  | Required
Requirement | Y | N | Course(s) taken | Credits | Credits
 |  |  |  |  | 4
 |  |  |  |  | 4
7. Foreign language* |  |  |  |  | 4 | Uses MTH 1218
 |  |  |  |  | 4
 |  |  |  |  | 4
 |  |  |  |  | 4
10. STEM |  |  |  |  | 4 | Uses MTH 1217
10. STEM |  |  |  |  | 4 | Uses PHY 2217
11. Cultural Diversity (D)
Connections
Writing intensive (W)** |  |  |  |  |  | Uses GEN 1001
Experiential (X)*** |  |  |  |  |  | Uses CEN 4901
FE Exam taken
* Uses Calculus II as replacement for this requirement
 |  |  | TOTALS
Spreadsheet: 92288d1291904151-average-random-cells-no-array-bypassing-cells-with-zeros-example-2010-2011
Sheet: DeMar11

2011-03-01 00:00:00
Product Technician | Project Name | Branch / Salesperson | Complexity Level | Date Received | [NAME] | Number Of Line Items | Notes | Potential Points | Earned Points
Submitted Projects - East
Kirchgessner |  |  | 0 |  |  | No BOM
Kirchgessner |  |  |  |  |  | No BOM
Kirchgessner |  |  |  |  |  | No BOM
 | 0
Morris |  |  | 0 |  |  | No BOM
Morris |  |  |  |  |  | No BOM
Morris |  |  |  |  |  | No BOM
 | 0
McGill |  |  | 0 |  |  | No BOM
McGill |  |  |  |  |  | No BOM
McGill
 | 0
[NAME] |  |  | 0 |  |  | No BOM
[NAME] |  |  |  |  |  | No BOM
[NAME] |  |  |  |  |  | No BOM
 | 0
Submitted Projects - West/Central
Spaw |  |  | 0 |  |  | No BOM
Spaw |  |  |  |  |  | No BOM
Spaw |  |  |  |  |  | No BOM
 | 0
Wilson |  |  | 0 |  |  | No BOM
Wilson |  |  |  |  |  | No BOM
Wilson |  |  |  |  |  | No BOM
 | 0
DeYoung |  |  | 0 |  |  | No BOM
DeYoung |  |  |  |  |  | No BOM
DeYoung |  |  |  |  |  | No BOM
 | 0
Karger |  |  | 0 |  |  | No BOM
Karger |  |  |  |  |  | No BOM
Karger |  |  |  |  |  | No BOM
 | 0
Completed Projects - East
Kirchgessner |  |  | 0
Kirchgessner
Kirchgessner
 | 0
Morris |  |  | 0
Morris
Morris
 | 0
McGill |  |  | 0
McGill
McGill
 | 0
[NAME] |  |  | 0
[NAME]
[NAME]
 | 0
Completed Projects - West/Central
Spaw |  |  | 0
Spaw
Spaw
 | 0
Wilson |  |  | 0
Wilson
Wilson
 | 0
DeYoung |  |  | 0
DeYoung
DeYoung
 | 0
Karger |  |  | 0
Karger
Karger
 | 0
 | Group totals for the Month: |  |  |  |  | Total Line Items:
Submitted: |  |  | Average difficulty:
Completed: |  |  | Average difficulty:
Group Errors
Spreadsheet: 102238d1300217687-excel-2007-merging-sorting-and-conditional-formatting-6b-math-full-report
Sheet: Class Roster

Instructor: | [NAME] | Total Possible: | 32 |  | Exams Graded: | 19
Exam Name: | 6 Math 2nd Interim Assessment | Highest Score: | 27 | 0.84 | Average: | 18.4 | 0.58
Exam Date: | Friday, January 07, 2011 | Lowest Score: | 8 | 0.25 | Median: | 18 | 0.56
Name | ID Number | Score | Percentage | Grade
AKERS, CALEB | 10003 | 21 | 0.66 | D
ASHBY, JAROD | 22401 | 16 | 0.5 | F
CUDWORTH, CHRISTOPHER | 22245 | 17 | 0.53 | F
DUNN, KAYLEE | 22022 | 14 | 0.44 | F
EDWARDS, BRANDON | 10116 | 19 | 0.59 | F
GORE, CALE | 10149 | 24 | 0.75 | C
HAYS, ASHLEY | 10171 | 14 | 0.44 | F
HOLTON, DAVIANNE' | 10664 | 18 | 0.56 | F
KEY, [NAME] | 10212 | 23 | 0.72 | C-
LEE, CHRISTOPHER | 10642 | 20 | 0.63 | D
MCCLURE, WADE | 1167617 | 25 | 0.78 | C+
MILROY, TERRA | 21005 | 23 | 0.72 | C-
PACE, [NAME] | 10521 | 8 | 0.25 | F
PARKER, REED | 10304 | 10 | 0.31 | F
RAY, MACKENZIE | 22460 | 24 | 0.75 | C
SHANKLE, JULIE | 10357 | 18 | 0.56 | F
WARD, DUKE | 22397 | 11 | 0.34 | F
WEBB, JASMYN | 22562 | 18 | 0.56 | F
WILSON, [NAME] | 10792 | 27 | 0.84 | B
Spreadsheet: 873163d1719586532-how-to-count-names-in-range-and-add-the-average-value-of-them-kms
Sheet: Sheet1

Date | [NAME] | End Kms | No of clients | Client names |  |  |  |  |  | Kms gone | kms/client |  | Client Name | Client initial
2024-06-01 00:00:00 | 11473 | 11493 | 4 | dw | an | at | rg |  |  |  |  |  | [NAME] | dw
2024-06-01 00:00:00 | 11493 | 11500 | 2 | ca | mr |  |  |  |  |  |  |  | [NAME] | an
2024-06-01 00:00:00 | 11500 | 11508 | 3 | an | at | rg |  |  |  |  |  |  | [NAME] | at
2024-06-02 00:00:00 | 11508 | 11520 | 1 | dw |  |  |  |  |  |  |  |  | [NAME] | rg
2024-06-03 00:00:00 | 11520 | 11544 | 2 | ca | mr |  |  |  |  |  |  |  | [NAME] | ca
2024-06-04 00:00:00 | 11544 | 11546 | 4 | dw | an | rg | mr |  |  |  |  |  | [NAME] | mr
2024-06-05 00:00:00 | 11546 | 11550 | 2 | mr | an
2024-06-06 00:00:00 | 11550 | 11555 | 1 | dw
2024-06-07 00:00:00 | 11555 | 11563 | 3 | at | an | mr
2024-06-08 00:00:00 | 11563 | 11570 | 2 | ca | dw |  |  |  |  |  |  |  | Current Month
 |  |  |  |  |  |  |  |  |  |  |  |  | End of month Kms summary
 |  |  |  |  |  |  |  |  |  |  |  |  | Client Name | End of month kms gone
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 92941d1292450832-extract-values-from-multiple-worksheets-book3
Sheet: Result

807 | 1
807 | 2
807 | 3
807 | 4
807 | 5
807 | 6
807 | 7
807 | 8
807 | 9
807 | 10
807 | 11
807 | 12
807 | 13
807 | 14
807 | 15
807 | 16
807 | 17
807 | 18
807 | 19
807 | 20
807 | 21
807 | 22
807 | 23
807 | 24
807 | 25
807 | 26
807 | 27
807 | 28
807 | 29
807 | 30
1010 | 1
1010 | 2
1010 | 3
1010 | 4
1010 | 5
1010 | 6
1010 | 7
1010 | 8
1010 | 9
1010 | 10
1010 | 11
1010 | 12
1010 | 13
1010 | 14
1010 | 15
1010 | 16
1010 | 17
1010 | 18
1010 | 19
1010 | 20
1010 | 21
1010 | 22
1010 | 23
1010 | 24
1010 | 25
1010 | 26
1010 | 27
1010 | 28
1010 | 29
1010 | 30
Spreadsheet: c018da72-95f5-49bf-a0e5-de4b7387eabb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: New Home Sales
 |  | New Single-family [NAME]: United States
 |  | Seasonally Adjusted All Houses [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: August 1, 2014 (6:02 am)
Period | Value
Jan-2008
Feb-2008
Mar-2008
Apr-2008
May-2008
Jun-2008
Jul-2008
Aug-2008
Sep-2008
Oct-2008
Nov-2008
Dec-2008
Jan-2009
Feb-2009
Mar-2009
Apr-2009
May-2009
Jun-2009
Jul-2009
Aug-2009
Sep-2009
Oct-2009
Nov-2009
Dec-2009
[NAME]
[NAME]
Mar-2010
Apr-2010
[NAME]
[NAME]
[NAME]
Aug-2010
Sep-2010
Oct-2010
Nov-2010
Dec-2010
Jan-2011
Feb-2011
Mar-2011
Apr-2011
May-2011
Jun-2011
Jul-2011
Aug-2011
Sep-2011
Oct-2011
Nov-2011
Dec-2011
Jan-2012
Feb-2012
Mar-2012
Apr-2012
May-2012
Jun-2012
Jul-2012
Aug-2012
Sep-2012
Oct-2012
Nov-2012
Dec-2012
Spreadsheet: 17e05bd4-1537-4b90-8c85-3506c9dcf367
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  |  |  |  |  |  | แนบรูปถ่ายสี
 |  |  |  | ใบสมัครสมาชิกตลอดชีพ |  |  |  | 1"  หรือ  2"
 |  | สมาคมอัสสัมชัญ |  |  | Assumption  Association |  |  | จำนวน 2 รูป
4810  ถนนพระราม 4  แขวงพระโขนง  เขตคลองเตย  กรุงเทพ  10110    โทรศัพท์  02-3901062-3  FAX  02-3915417
(ใกล้สถานีรถไฟฟ้าพระโขนงและศูนย์การค้าพระโขนง  ติดกับธนาคารไทยพาณิชย์และร้านขายเตาอบ)
ก่อตั้ง  1 มิถุนายน  2447 |  |  | www.acassoc.com |  |  |  | เลขประจำตัว อสช ...................
เข้าเรียนชั้น …………. |  | เมื่อปี พ.ศ. ………….. |  | ลาออกชั้น.................เรียนจบชั้น...................พ.ศ................ |  |  |  | รุ่นที่ ..............
ชื่อ-นามสกุล (ไทย) |  |  |  |  |  |  | ชื่อเดิม (ถ้ามี)
ชื่อ-นามสกุล (อังกฤษ) |  |  |  |  |  |  | ชื่อเล่น (ถ้ามี)
บัตรประชาชนเลขที่ |  |  |  |  | วันเดือนปีเกิด |  |  | อายุ
[NAME] |  |  | เชื้อชาติ |  | ศาสนา |  | ชื่อครูที่เคยสอน
มีเพื่อนร่วมรุ่นชื่อ
ที่อยู่ปัจจุบัน
โทรศัพท์ |  |  | มือถือ |  | FAX |  | E-MAIL
ในกรณีที่มีภูมิลำเนาอยู่ต่างจังหวัด เป็นที่อยู่ถาวร โปรดกรอกที่อยู่โดยละเอียดดังนี้
โทรศัพท์ที่บ้านต่างจังหวัด |  |  |  |  | FAX ที่บ้านต่างจังหวัด
ชื่อสถานที่ทำงาน
[NAME]
โทรศัพท์ |  |  |  |  |  | FAX
คำแหน่ง |  |  |  |  | ทำงาน-ค้าขายเกี่ยวกับ
เล่นกีฬา |  |  |  |  | ความสามารถพิเศษ
ประวัติการศึกษา
 |  | โรงเรียน |  |  | จากชั้น | ถึงชั้น | จาก ปี พ.ศ.  ถึง  ปี พ.ศ.
1
2
3
ข้าพเจ้าได้กรอกข้อความในใบสมัครเรียบร้อยแล้ว เพื่อสมัครเข้าเป็นสมาชิกตลอดชีพของสมาคมอัสสัมชัญตั้งแต่วันนี้
และได้แนบรูปถ่าย 2 ใบ พร้อมเงินค่าสมาชิกตลอดชีพ จำนวน 1,525 บาทมาด้วยแล้ว โปรดส่งใบเสร็จรับเงินและบัตร
สมาชิกไปให้ข้าพเจ้าที่บ้านตามที่อยู่ปัจจุบันข้างต้น
ข้าพเจ้ายินดีช่วยสนับสนุนกิจกรรมและการงานของสมาคมอัสสัมชัญ เพื่อสืบทอดเจตนารมณ์จากรุ่นพี่สู่รุ่นน้อง ให้
เอ.ซี. ทุกรุ่นรวมกลุ่มกันติด เป็นพลังที่มีคุณภาพ และคุณธรรม [NAME] ให้มีความเจริญมั่นคงสืบไป
วันที่สมัคร |  |  |  | ลงชื่อ |  |  |  | ผู้สมัคร
Spreadsheet: 150190d1334329056-ytd-horizontal-sumifs-sumifshoriz
Sheet: Feuil1

 | Period | 1 | 1 | 2 | 2 | 3 | 3 | YTD | YTD | Current period | 2
Client |  | Apples | oranges | Apples | oranges | Apples | oranges | Apples | Oranges
[NAME] |  | 10 | 20 | 30 | 40 | 50 | 60
[NAME] |  | 15 | 25 | 35 | 45 | 55 | 65
Spreadsheet: 42510d1241055332-employee-schedule-help-schedual09b
Sheet: Sunday

 | Area |  | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 10:00:00 |  | Total Hours
 | Service Desk |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
62 | [NAME] | 1 | x | x | x | x | x | x |  |  |  |  |  |  |  |  |  |  |  | 6
74 | Hayley | 2 |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x |  |  | 4
9 | [NAME] | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
26 | [NAME] | 4 |  |  |  |  |  |  | x | x | x | x | x |  |  |  |  |  |  | 5
43 | Ramsay | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | #N/A | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 268040d1380378799-matching-the-cells-with-the-same-data-in-different-rows-and-columns-workbook1
Sheet: REPORT

 |  |  | Day | MTD | Budget (Mounth) | Var Mounth/Bud
 | Occupancy |  | 0.71
 | Guest in House |  | 75
 | Nb of Breakfast
 | Nb of Breakfast Package
 | Nb of Breakfast Extra
 | Aver Breakfast Rate
 | Breakfast Capture Rate
 | Rti Breakfast
 | Rti Breakfast Package
 | Rti Breakfast Full Rate
 | Room Service Breakfast Food
 | Room Service Breakfast Beverage
 | Nb of Covers Lunch
 | Aver Lucnh Rate
 | Rti Lunch
 | Rti Lunch Food
 | Rti Lunch Beverage
 | Nb of Covers Dinner
 | Aver Dinner Rate
 | Rti Dinner
 | Rti Dinner Food
 | Rti Dinner Beverage
 | Nb of Covers Lunch Room Service
 | Aver Lunch Room Service Rate
 | Rti Lunch Room Service
 | Rti Lunch Room Service Food
 | Rti Lunch Room Service Beverage
 | Nb of Covers Dinner Room Service
 | Aver Dinner Room Service Rate
 | Rti Dinner Room Service
 | Rti Dinner Room Service Food
 | Rti Dinner Room Service Beverage
 | Nb of Covers Banqueting
 | Aver Banqueting Rate
 | Rti  Banqueting
 | Rti Banqueting Food
 | Rti Banqueting Beverage
 | Nb of Covers Bar
 | Aver Bar Rate
 | Rti  Bar
 | Rti Bar Food
 | Rti Bar Beverage
 | Rti  Minibar
 | Rti Minibar Food
 | Rti Minibar Beverage
 | Rti  Banquets Room Hire
 | F&B TOTAL
 | Micros Sales Total
 | Opera F&B Total
Spreadsheet: 866500d1713432520-a-formula-to-select-the-highest-cell-in-a-column-that-then-shows-the-entire-row-walks
Sheet: Ian

 | # | Date | Name | Distance in        Miles | Total Elevation in Feet | Total Time HH:MM | Moving Time HH:MM | Stoped Time HH:MM | Avarage Speed MPH | Average Moving Speed MPH
 |  |  | 2017
 |  |  | 2018
 |  |  | 2019
 |  |  | 2020
 |  |  | 2021
 |  | 2022-05-29 00:00:00 | Pensford to Chewton Keynsham | 8.7 | 1067 |  | 03:38:00 | 00:34:00
 |  |  | 2022
 |  |  | 2023
Spreadsheet: 702664d1604470740-who-to-vlookup-with-pervious-column-xforum
Sheet: Sheet1

Original Table
Payment | Emp# | Name
Bank | 10 | [NAME]
Cash | 16 | [NAME]
cheque | 19 | Jhon |  |  |  |  | [NAME]
Bank | 24 | Lillian |  |  |  |  | Payment | Emp# | Name
Cash | 29 | Nella |  |  |  |  | ??? | 24
cheque | 32 | Tia |  |  |  |  | ??? | 35
Cash | 35 | Scarlet |  |  |  |  | ??? | 63
cheque | 40 | [NAME] |  |  |  |  | ??? | 42
Bank | 42 | Hayley |  |  |  |  | ??? | 16
Cash | 46 | Tara |  |  |  |  | ??? | 10
Cash | 63 | [NAME]
cheque | 64 | [NAME]
Cash | 65 | [NAME]
cheque | 68 | [NAME]
Spreadsheet: 97024d1296234901-compute-project-start-end-date-state-it-spending-2007-2011
Sheet: Strategic Plan

STATE | FY2010  IT SPEND ($M) | COUNTY AGENCIES | POST-SECONDARY INSTITUTIONS | TOTAL CONTACTS | EST.  PROCESSING TIME (MONTHS) | BEGIN DATE | END DATE | STRATEGIC PLACEMENT
California | 2409.487604556806 |  |  |  |  |  |  | 1Q2011 |  |  | New York, New Jersey, Virginia, Pennsylvania, Arkansas, North Carolina, Maine, Mississippi, and California
New York | 1788.824460552066 | 62
Texas | 1215.428490624481 | 254
Illinois | 1189.191343407895 | 100
Ohio | 1034.534305810557 | 88
Pennsylvania | 821.4270940853368 | 67 | 83
Florida | 793.3814105877623
North Carolina | 666.9240753706189 | 98
New Jersey | 614.6944819628037 | 21 | 27
Massachusetts | 611.2163809290954 | 14 | 56
Wisconsin | 563.2109672357537 |  | 29
Alabama | 541.815359554758
Louisiana | 541.12863199888
Georgia | 511.761790684774
Virginia | 491.8142053249891 | 136
Michigan | 487.8569663581036 | 83
Washington | 465.9488193119547
Maryland | 432.399270856357 | 23
Indiana | 403.7032272217629 | 92
Arizona | 374.109317530906 |  | 5
Minnesota | 371.129504765048 | 87
Mississippi | 366.7035803161941 | 82 | 15
Connecticut | 358.7975435739108 |  | 19
West Virginia | 354.9620868710744
Kentucky | 348.7425247458587 | 120
Missouri | 331.296430914615
Tennessee | 312.145893646529 | 95
Arkansas | 283.1521335552869 | 75
Colorado | 264.8473793475591
Oklahoma | 262.4666484496651 | 77 | 20
Iowa | 248.8896416118606 | 99
Oregon | 228.1122513673997
Kansas | 202.4469543453758 | 103
New Mexico | 202.1081708726665
South Carolina | 197.4019168919547 |  | 26
Alaska | 171.9302437702147 |  | 4
Hawaii | 171.8594537298531 | 5 | 5
Utah | 146.4173466883235 | 29 | 6
Nevada | 146.092768419409
Nebraska | 131.3181955874834 |  | 16
Delaware | 117.6701565096356 |  | 5
Maine | 104.3968447839554 | 16
Rhode Island | 86.43239372222516
Idaho | 85.67050242156533 | 44 | 9
Montana | 77.85876681692753 | 57
New Hampshire | 73.4864229696679 |  | 13
Wyoming | 66.81075940528135 | 23
Vermont | 65.03012962767303 |  | 14
North Dakota | 57.69276203594998 | 53 | 8
South Dakota | 49.27238827117637 |  | 11
TOTAL TIME (WKS)
TOTAL TIME (MOS)
Spreadsheet: 296587d1392134815-replace-mulitple-if-isnumber-search-with-vlookup-car
Sheet: CAR

DATE | CAR MODEL | MANUFACTURE
2013-01-02 00:00:00 | Volt-2Door
2013-01-02 00:00:00 | [NAME]
2013-01-02 00:00:00 | Golf GTI
2013-01-02 00:00:00 | Hydro Power Volt
2013-01-02 00:00:00 | Focus |  | *Ford is the answer, but I do not have it in the forumla
2013-01-02 00:00:00 | 4 dr Focus |  | *Ford is the answer, but I do not have it in the formula
2013-01-02 00:00:00 | Acadian
2013-01-02 00:00:00 | Sunfire-manual
2013-01-02 00:00:00 | [NAME]
2013-01-02 00:00:00 | [NAME] -7 passenger
Spreadsheet: 126998d1320095755-how-do-you-return-table-values-to-another-sheet-sample
Sheet: Sheet2

Likelihood | A - 1 | B - 2 | C - 3 | D - 4 | E - 5
 | Minor | Moderate | Significant | Major | Catastrophic
A - 5 | Moderate 11 | High 16 | High 20 | Extreme 23 | Extreme 25
Almost Certain
B - 4 | Moderate 7 | Moderate 12 | High 17 | High 21 | Extreme 24
Likely
C - 3 | Low 4 | Moderate 8 | Moderate 13 | High 18 | High 22
Moderate
D - 2 | Low 2 | Low 5 | Moderate 9 | Moderate 14 | High 19
Unlikely
E – 1 | Low 1 | Low 3 | Moderate 6 | Moderate 10 | High 15
Rare
 | Consequences
Spreadsheet: 96165d1295574122-create-sheets-based-on-cells-and-modify-formulas-within-sheets-gradesbook
Sheet: Master

 | 1st section | 2nd section | 3rd Section
 | Points | Points | Points
 | 1 | 3
 | Number Wrong | Number Wrong | Number Wrong
 | Total number | Total number | Total points
 | 45 | 13 | 16
Names
[NAME] | 2 | 2 | 1
happy harry | 4 | 5 | 6
[NAME] | 1 | 0 | 1
[NAME] | 6 | 2 | 1
Spreadsheet: 11bf04c2-04bc-4c36-8fa2-03e046d07548
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0022156 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Morehead City WWTP | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | [NAME] | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did conjunctive utilization occur at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  |  |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 4.9 |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage             (if applicable) | 5-Day Upset              (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading (gallons): |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Spreadsheet: 202444d1356575551-help-compounding-annual-returns-for-periodic-cash-flows-for-forum
Sheet: Sheet1

 | Annual | Monthly | Use
Preferred Return | 0.09
Hurdle | 3
[NAME] | 0.2
[NAME] | 0.3
 | Total | i. Dist to Inv | Cash | Tot Contribut | Preferred | [NAME] | ii. Pfd | Cash
Period | Cash Flow |  | Remaining | Inc Accum pfd | Return |  | Return | Remaining
Spreadsheet: 268489d1380654330-sign-switch-logic-and-subtotal-excel-forum-test-file
Sheet: Sheet1

 |  | A Chg | B Chg | C Chg | LY A Amount | LY B Amount | [NAME] | A Composite | B Composite | C Composite | A [NAME] | B [NAME] | C [NAME] |  | Sign Equal?
 |  | -4.561725 | -4.561725 | -0.912345 | 0.3245 | 2.9205 | 0.3245
 |  | -3.64938 | 1.82469 | 4.561725 | 1.947 | 1.6225 | 0.3245
 |  | 2.737035 | 5.63 | 4.561725 | 0.649 | 1.298 | 1.6225
 |  | -4.561725 | -4.561725 | 0.912345 | 2.596 | 1.6225 | 1.298
 |  | 3.64938 | 3.64938 | 4.561725 | 2.9205 | 0.649 | 2.9205
 |  | 3.64938 | -2.737035 | 0.912345 | 1.298 | 2.2715 | 1.6225
 |  | 2.737035 | 0.912345 | 4.561725 | 0.649 | 1.947 | 1.947
 |  | -3.64938 | 1.82469 | -1.82469 | 0.649 | 1.298 | 1.947
 |  | -2.737035 | -3.64938 | -4.561725 | 1.6225 | 1.6225 | 0.3245
 |  | -4.561725 | 3.64938 | 0.912345 | 0.649 | 0.649 | 1.6225
 |  |  |  |  | This is just raw data. |  |  |  | This is just CxF, [NAME], [NAME], etc. |  |  | These calculate the percent of the total for each Composite number in Column I through K
 |  |  |  |  |  |  |  |  |  |  |  | Then that is multiplied by the total Chg in C2, D2, E2.
 |  |  |  |  |  |  |  |  |  |  |  | THEREFORE, the totals in L2, [NAME], N2 should equal C2, D2, E2, and they do, but there is a sign issue with [NAME].
 |  |  |  |  |  |  |  |  |  |  |  | Do you know why it is somehow negative?