tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 801836d1666411167-how-do-i-apply-rows-of-many-formulas-to-a-list-of-many-words-phrases-and-cities
Sheet: Sheet1

toronto |  |  | london |  | london
toronto |  |  | berlin |  | london
toronto |  |  | tokyo |  | london
toronto |  |  | munich |  | london
 |  |  | madrid |  | berlin
 |  |  | lisbon |  | berlin
 |  |  | jakarta |  | berlin
 |  |  | barcelona |  | berlin
 |  |  |  |  | tokyo
 |  |  |  |  | tokyo
 |  |  |  |  | tokyo
 |  |  |  |  | tokyo
 |  |  |  |  | munich
 |  |  |  |  | munich
 |  |  |  |  | munich
 |  |  |  |  | munich
 |  |  |  |  | madrid
 |  |  |  |  | madrid
 |  |  |  |  | madrid
 |  |  |  |  | madrid
 |  |  |  |  | lisbon
 |  |  |  |  | lisbon
 |  |  |  |  | lisbon
 |  |  |  |  | lisbon
 |  |  |  |  | jakarta
 |  |  |  |  | jakarta
 |  |  |  |  | jakarta
 |  |  |  |  | jakarta
 |  |  |  |  | barcelona
 |  |  |  |  | barcelona
 |  |  |  |  | barcelona
 |  |  |  |  | barcelona
Spreadsheet: 97994d1297100009-countif-2-columns-excel-help
Sheet: Sheet1

AE | W
AE | W
AN | W
AS | L
AW | L
AE | D
AS | D
AW | W
AN | W
AE | L
 | W | D | L
AE
AN
AS
AW
Spreadsheet: 110471d1307115867-excel-2007-convert-7h-10s-to-hh-mm-ss-format-in-excel-timeconvert
Sheet: Sheet1

TimeText | H | M | S | Converted
7H 10S
10H 30M 05S
01S
1H
13M
02M 4S
Spreadsheet: kim_ward__20771__RFP_loadprofiles_193_151_202_141_113_110
Sheet: Proposal G_110

[NAME]
Please submit your response to this RFP by completing and returning this sheet.
Marketing Company:
Marketing Rep:
Date:
Accounts: | Ventura, CA
 | Corona, CA
Term: | April 1, 2001 - March 31, 2003
Price #1: | NGI "Southern California Border Average"______________________________
 | The monthly volume invoiced by [NAME] will equal metered usage grossed up
 | for interstate pipeline and utility fuel loss.
 | Bid good through
Price #2: | NGI "Southern California Border Average"______________________________
 | The monthly volume invoiced by [NAME] will equal metered usage and will
 | include the cost of interstate pipeline and utility fuel loss.
 | Bid good through
Volume: | Full Requirements |  |  |  |  |  |  | Yes     or      No
Delivery Point: | Southern California Border |  |  |  |  |  |  | Yes     or     No
Transportation: | Primary firm, non-recallable |  |  |  |  |  |  | Yes     or     No
Nominations & | [NAME] will be responsible for utility nominations and associated balancing.
Balancing | [NAME] will make nominations based on historical usage.  [NAME] will notify
 | Buyer of any periods of daily balancing and/or other operational flow orders,
 | which may cause penalties.  [NAME] will indemnify [NAME] against any
 | penalties that occur due to non-performance by [NAME]. |  |  |  |  |  |  | Yes     or     No
Required Contract: | Seller agrees to utilitze [NAME]'s Base Sales Agreement and applicable
 | Exhibits.  [NAME] has reviewed this contract and has submitted all requested |  |  |  |  |  |  | Yes     or     No
 | changes for consideration.
Credit: | All credit arrangements and contractual agreements will be between [NAME]
 | and [NAME]. |  |  |  |  |  |  | Yes     or     No
Other: | Buyer reserves the right to fix a price based on current market conditions
 | for a portion of volumes up to 100% requirements.
 | At any time during the term of this Agreement, [NAME] will fix the cost of
 | commodity and/or basis for any month(s) per [NAME]’s request at no additional
 | cost. |  |  |  |  |  |  | Yes     or     No
Comments:
Spreadsheet: fd15491e-7e5c-49a4-84a6-b632a102cf09
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5839 | 27264 | [NAME] | [NAME] | AUT | 0 | 00:22:56 | [NAME] | 00:40:57 | 00:00:00 | 00:13:06 | 1 | 01:17:41
5839 | 39859 | Toni | [NAME] | ESP | 0 | 00:21:54 | 00:00:41 | 00:46:19 | 00:00:00 | 00:12:45 | 2 | 01:21:41
5839 | 30687 | [NAME] | Perkins | GBR | 0 | 00:23:32 | 00:00:36 | 00:46:04 | 00:00:00 | 00:13:36 | 3 | 01:23:50
5839 | 39856 | Joaquin | Carrasco | ESP | 0 | 00:23:01 | 00:01:06 | 00:50:02 | 00:00:00 | 00:13:12 | 4 | 01:27:22
5839 | 39857 | [NAME] | Pellicer | ESP | 0 | 00:23:31 | 00:00:40 | 00:51:56 | 00:00:00 | 00:13:35 | 5 | 01:29:44
Spreadsheet: 171834d1343881253-time-additions-on-monthly-3-monthly-biannual-and-annual-basis-sample
Sheet: Sheet1

DATE | T1 | T2 | TOTAL TIME
2008-02-01 00:00:00 | 12:00:00 | 13:00:00
2008-02-05 00:00:00 | 13:00:00 | 14:00:00
2008-02-09 00:00:00 | 14:00:00 | 15:00:00
2008-03-08 00:00:00 | 15:00:00 | 16:00:00
2008-03-09 00:00:00 | 16:00:00 | 17:00:00
2008-03-15 00:00:00 | 17:00:00 | 18:00:00
2008-03-19 00:00:00 | 18:00:00 | 19:00:00
2008-04-01 00:00:00 | 19:00:00 | 20:00:00
… | … | … | …
… | … | … | …
… | … | … | …
THE SUMMARIES CAN BE ON THE SHEET 2
Spreadsheet: 807303d1669835608-formatting-day-ranges-on-schedules-schedule-workbook
Sheet: Sheet1

Last Day Off | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Total Days worked | Total Days Off | Next Day Off
 | 2022-12-03 00:00:00 | 2022-12-04 00:00:00 | 2022-12-05 00:00:00 | 2022-12-06 00:00:00 | 2022-12-07 00:00:00 | 2022-12-08 00:00:00 | 2022-12-09 00:00:00
2022-11-27 00:00:00 | x | o | x | x | x | x | x |  |  |  |  |  |  |  |  |  | x
2022-12-01 00:00:00 | x | x | x | x | x | o | x |  |  |  |  |  |  |  |  |  | o
2022-11-28 00:00:00 | x | x | o | x | x | x | x
2022-11-28 00:00:00 | o | x | x | x | x | x | x
2022-11-26 00:00:00 | o | x | x | x | x | x | x
2022-11-26 00:00:00 | o | x | x | x | x | x | x
2022-11-30 00:00:00 | x | x | x | x | o | x | x
2022-11-27 00:00:00 | x | o | x | x | x | x | x
2022-11-28 00:00:00 | x | x | o | x | x | x | x
2022-12-02 00:00:00 | x | x | x | x | x | x | o
2022-11-27 00:00:00 | x | o | x | x | x | x | x
2022-11-29 00:00:00 | x | x | x | o | x | x | x
2022-11-01 00:00:00 | x | x | x | x | x | o | x
2022-11-26 00:00:00 | o | x | x | x | x | x | x
2022-11-26 00:00:00 | o | x | x | x | x | x | x
 | x | x | x | x | x | x | o
 | x | x | x | x | x | o | x
2022-11-30 00:00:00 | x | x | x | x | o | x | x
2022-12-01 00:00:00 | x | x | x | x | x | o | x
2022-12-03 00:00:00 | o | x | x | x | x | x | x
2022-11-27 00:00:00 | x | o | x | x | x | x | x
2022-11-27 00:00:00 | x | o | x | x | x | x | x
2022-11-26 00:00:00 | o | x | x | x | x | x | x
2022-11-27 00:00:00 | x | o | x | x | x | x | x
2022-11-27 00:00:00 | x | o | x | x | x | x | x
2022-11-28 00:00:00 | x | x | o | x | x | x | x
2022-11-26 00:00:00 | o | x | x | x | x | x | x
Indef | o | o | o | o | o | o | o
2022-11-27 00:00:00 | x | o | x | x | x | x | x
2022-11-26 00:00:00 | o | x | x | x | x | x | x
2022-11-30 00:00:00 | x | x | x | o | o | x | x
2022-11-26 00:00:00 | o | x | x | x | x | x | x
Spreadsheet: 03d5e858-3b4a-4531-b503-7fa64f2d87bb
Sheet: 2003

School of Nursing 2003
 |  | BSN |  | Masters |  | Doctoral |  | School Totals |  | Total Grad
Total Number |  | 179 |  | 222 |  | 82
Ethnic Diversity
Citizens/Permanent Residents
American Indian or Native Am. |  | 4 |  | 2 |  | 0
Asian or Asian American |  | 31 |  | 20 |  | 4
African American |  | 10 |  | 4 |  | 1
Hispanic or Latino |  | 12 |  | 5 |  | 1
Hawaiian or Pacific Islander |  | 0 |  | 0 |  | 0
White |  | 105 |  | 165 |  | 48 |  | 318
Not Indicated |  | 17 |  | 17 |  | 0
International Students |  | 0 |  | 9 |  | 28 |  | 37 |  | 37
Minority
Underrepresented Minority
**Based on Autumn quarter 10th day census data / Seattle campus only
***Underrepresented students do not include Asian or Asians Americans
Spreadsheet: phillip_m_love__31136__Orig-Central1001
Sheet: Sheet1

Middle Market - NYMEX
Middle Market - Northeast
Middle Market - East
Middle Market - Central
Middle Market - Texas
Middle Market - West
Middle Market - Canada
Middle Market - BUG
Middle Market-TRANSPORT
Middle Market - Chicago
Gas Origination - West
Gas Assets
East Origination - Gas
Southeast Origination
Short-Term Gas Trading
EGS-Canada - Integrated Solutions
Risk Management
Environmental Energy
Industrial Services
Intl Fuels Mgmt
Upstream Origination
Strategic Origination
Northeast Mktg
Structuring
EFC
Interest
EGS CANADA
Equity Investing
Industrial Finance
Producer Finance
Gas Assets - LRC Business Development
Merchant Assets
Research
Emerging Opportunities
Interest Rate
Risk Mngt Market
Texas Gas
East Origination -
East Origination - Chicago
Gas Prepay
Gas Assets - Utility Operations
Gas Assets - Strategic Ventures
Gas Assets - HPL Business Development
Gas Assets - Enron Compressor Services
Restructured Origination
Gas Assets - Producer Services
Transportation and Storage
HPL - Transport
ECS Compression Company, LLC
Office of the Chairman
West Origination - Gas
Industrial Origination
Energy Capital Resources
Mexico Origination
Steel Origination
Central Orig - Gas
GLOBAL PRODUCTS - ORIGINATION
Enron Fuels Intl.
Interest Rate-Global
GLOBAL MARKETS
Retail
Generation East
Generation West
West Origination
Alberta Power Origination
NE Origination
Northeast Power Trading
Midwest Power Origination
Midwest Power Trading
Midwest Orig
Ercot Origination
Ercot Power Trading
Southeast Orig
Southeast Power Trading
Asset Marketing Group
West Middle Market Origination
NAES - Industrial Coal
Treasury
Finance Book
Group
Capital Book
Reserved
Credit Reserve
Regulatory Reserve
Discounting
GAS NATURAL SUDAMERICANO LTD.
Global Net
Spreadsheet: 680244d1590874171-pivot-table-doesnt-copy-values-as-sums-testing
Sheet: PIVOT TABLE

Suma de Profit | Etiquetas de columna
Etiquetas de fila | 1000 | 2000 | 3000 | 10278 | 21435 | 22324 | 23794 | 181818 | 1234567 | 1367031 | 12344444 | Total general
audusd |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | THIS ZERO
eurchf |  |  |  |  |  |  |  | 4.22 |  |  |  | 4.22
eurgbp |  |  |  |  |  |  |  | -22.56 |  |  | 0 | -22.56 |  | THIS ZERO
eurusd | 363 | 7527.08 | 4310.16 | -128.06 | 2875 | -122.99 | -105.68 |  |  | -715.53 | 0 | 14002.98 |  | THIS ZERO
gbpusd | 2586.04 | 2813.340000000001 | 6076.240000000001 | 18.90000000000001 | 854.42 | 8.309999999999999 | 7.64 | -15.4 | 1.5 |  |  | 12350.99
nzdusd |  |  |  |  |  |  |  |  | -11.97 |  |  | -11.97
usdjpy |  |  |  |  | 881.54 |  |  |  |  |  | -605.82 | 275.7199999999999
Total general | 2949.04 | 10340.42 | 10386.4 | -109.16 | 4610.96 | -114.68 | -98.03999999999999 | -33.74 | -10.47 | -715.53 | -605.82 | 26599.38
Spreadsheet: louise_kitchen__24242__JulYTD Orig w notes
Sheet: Mexico

Mexico
Originator |  | Commodity |  | Team |  | Total |  | %Total
[NAME] |  | Gas |  | Mexico
[NAME] |  | Gas |  | Mexico |  | 388431
Total
Spreadsheet: 712044d1610029807-sum-if-cell-reference-question-project-cash-flow-test-document
Sheet: Gross Application

 | Gross Application
 | Application No. | Application Date | Terms | Due Date | Value
 | 1 | 2020-05-21 00:00:00 |  |  | 50000
 | 2 | 2020-06-21 00:00:00 |  |  | 225000
 | 3 | 2020-07-21 00:00:00 |  |  | 250000
 | 4 | 2020-08-21 00:00:00 |  |  | 300000
 | 5 | 2020-09-21 00:00:00 |  |  | 200000
 | 6 | 2020-10-21 00:00:00 |  |  | 100000
 | 7 | 2020-11-21 00:00:00 |  |  | 75000
 | 8 | 2020-12-21 00:00:00 |  |  | 20000
 | 9 | 2021-01-21 00:00:00 |  |  | 9460
 | 10 | 2021-02-21 00:00:00
Spreadsheet: 844980d1696562981-formula-to-allocate-contract-value-over-4-years-book1-3
Sheet: Sheet1

 |  | Start date | Duration | Amount | 2023 | 2024 | 2025 | 2026 |  | Check
 |  | 2023-12-29 00:00:00 | 1 | 100 |  | 0 | 0 | 0
 |  | 2023-11-03 00:00:00 | 5 | 500 | 200 | 300 | 0 | 0
 |  | 2023-10-03 00:00:00 | 18 | 1800 | 300 | 1200 | 300 | 0
Spreadsheet: 856424d1705667241-cash-flow-help-quote-example-document-2-
Sheet: Sheet1

Quote No | Leads | Client | Estimator | Company (GRBC / SES / Higgins/SHH) | Budget / Estimate quote | Contact Name | Contact Info | Margin | Start Date | Duration | Trade | % likely | Update | Date of Update | Next Action | January | February | March | April | May | June | July | August | September | October | November | December
34428 | Mains Water Pipe Installation - Mechanical | AVD | RC | Projects | 21714.44 |  | 01782 383124 | 0.2165 | January | 4 | M |  | Manager who Response is resigned.  Following up by another Engineer | 2024-01-15 00:00:00
34429 | Mains upgrade |  | RC | Building Services | 50000 |  |  | 0.19 | March | 10 | M | 0.75 |  |  |  |  |  | 20000 | 20000 | 10000
34430 | EICR |  | RC | Sustainable Solutions | 10000 |  |  | 0.18 | May | 3 | M | 0.9 |  |  |  |  |  |  |  | 10000
 | Overall Total:
 | Total: | Projects
 | Total: | Building Services
 | Total: | Sustainable Solutions
 | Total: | SHH
 | Overall Total:
 | Averages
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overall:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrical
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mechancial
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Specialist Gas
Spreadsheet: 679045d1590162566-repost-search-2-columns-for-a-match-samplefile-7-
Sheet: supply

SCAN | [NAME] | PRICE EACH | Qty | Extended Cost | AREA/ UNIT | ITEM NO | Catalog No | DATE/TIME  STAMP
172 |  |  |  |  |  |  |  | 2020-05-21 10:42:52
173 |  |  | do not populate
174 |  |  |  |  |  |  |  | do not populate
175
176
Spreadsheet: e7d32bc6-561d-4d8b-845c-853d0dd6832c
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43510475 | 2014-10-09 22:23:47 | ALLIES | 0 | 1 | 5 | 1611343 | DDB73 | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43510763 | 2014-10-09 22:36:27 | AXIS | 1 | 5 | 2 | 1611343 | DDB73 | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43598048 | 2014-10-15 23:39:29 | ALLIES | 1 | 5 | 2 | 1526787 | browndog | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43609964 | 2014-10-16 22:18:18 | ALLIES | 0 | 4 | 5 | 392838 | [NAME] | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43610222 | 2014-10-16 22:34:38 | AXIS | 0 | 1 | 5 | 392838 | [NAME] | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
Spreadsheet: 678221d1589787152-dynamic-reporting-possible-pivot-table-with-multiple-columns-on-one-sheet-to-source-from-pivottest
Sheet: Reference

Agency | Organisation | Progress
ONETAKE | BUSINESS | STARTUP
TWOTAKE | PRIVATE | ONGOING
GIVEONE | CORPORATION | STALLED
GIVETWO | GOVERNMENT | FINISHED
OUTTERONE |  | UNKNOWN
OUTTERTWO
BEYONDONE
BEYONDTWO
Spreadsheet: 138097d1327512445-price-grid-index-lookup-match-panel-blinds-pricelist-with-profiles-autoprice
Sheet: Automatic Pricing

 | USING Price List |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Type | Name
 | Auto Price List |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | One Way Draw | FP_OWD
 | Item | Type | List | Qty | [NAME] | height | Price Each | Total | Comments |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | FP_SD
 | 1 | One Way Draw | A | 1 | 6000 | 1000 | 284.5799999999999 | 284.5799999999999 | Oversize No Guarantee
 | 2 | [NAME] | B | 2 | 1000 | 1000 | 118.82 | 237.64
 | 3 | [NAME] | C | 3 | 6000 | 4000 | 1020.430000000001 | 3061.290000000002 | Oversize No Guarantee
 |  |  |  |  | TOTAL Including VAT |  |  | 3583.510000000002
 |  |  |  |  | VAT @ 15.0% |  |  | 537.5265000000002
 |  |  |  |  | Net Excluding VAT |  |  | 3045.983500000001
Spreadsheet: 173690d1344658116-combining-sumproduct-with-checked-checkboxes-for-my-friend
Sheet: Sheet1

2012-08-01 00:00:00
2012-08-02 00:00:00
2012-08-03 00:00:00
2012-08-04 00:00:00
2012-08-05 00:00:00
2012-08-06 00:00:00
2012-08-07 00:00:00 |  |  |  |  |  |  |  | =sumproduct( --(d9:d25>datevalue("3/1/08")), --(d9:d25<datevalue("6/30/08")) )
2012-08-08 00:00:00
2012-08-09 00:00:00
2012-08-10 00:00:00
2012-08-11 00:00:00
2012-08-12 00:00:00
2012-08-13 00:00:00
2012-08-14 00:00:00
2012-08-07 00:00:00
2012-08-16 00:00:00
2012-08-17 00:00:00
2012-08-18 00:00:00
2012-08-19 00:00:00
2012-08-20 00:00:00
2012-08-21 00:00:00
2012-08-22 00:00:00
2012-08-23 00:00:00
2012-08-24 00:00:00
2012-08-25 00:00:00
2012-08-26 00:00:00
2012-08-27 00:00:00
2012-08-28 00:00:00
2012-08-29 00:00:00
2012-08-30 00:00:00
2012-08-31 00:00:00
Spreadsheet: 703618d1605086907-converting-data-into-a-monthly-calendar-format-visual-extract
Sheet: Sheet1

Row Labels | Count of Date
<02/01/2020
Jan | 940
02-Jan | 34 |  |  |  |  |  |  | Jan
Thu | 34 |  |  |  |  |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
03-Jan | 31
Fri | 31
06-Jan | 45
Mon | 45
07-Jan | 50
Tue | 50
08-Jan | 50
Wed | 50
09-Jan | 47 |  |  |  |  |  |  | Feb
Thu | 47 |  |  |  |  |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
10-Jan | 35
Fri | 35
13-Jan | 50
Mon | 50
14-Jan | 42
Tue | 42
15-Jan | 49
Wed | 49
16-Jan | 38
Thu | 38
17-Jan | 40
Fri | 40
20-Jan | 40
Mon | 40
21-Jan | 45
Tue | 45
22-Jan | 38
Wed | 38
23-Jan | 53
Thu | 53
24-Jan | 52
Fri | 52
27-Jan | 38
Mon | 38
28-Jan | 45
Tue | 45
29-Jan | 33
Wed | 33
30-Jan | 35
Thu | 35
31-Jan | 50
Fri | 50
Feb | 739
Mar | 393
Apr | 187
May | 256
Jun | 349
Jul | 469
Aug | 436
Sep | 443
Oct | 551
Grand Total | 4763
Spreadsheet: 04628724-ef01-483d-ba6a-802fe2ba74f3
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
HMGP-4 |  | REQUEST FOR REIMBURSEMENT/PAYMENT
APPLICANT: |  |  |  |  |  |  |  |  | HMGP PROJECT NUMBER:
COUNTY: |  |  |  |  |  |  |  |  | DISASTER NUMBER:
COST INCURRED
 |  |  |  | FORCE ACCOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CONTRACTOR, VENDOR & OTHER |  |  | COST INCURRED (SUBTOTAL)
ITEM*
 |  |  |  | LABOR |  |  | EQUIPMENT |  |  |  | MATERIALS
 |  |  |  | $ |  |  | 0 |  |  |  | 0 |  |  |  | $ |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
*EACH ITEM LISTED SHOULD BE AN ITEM IN THE APPROVED PROJECT BUDGET |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL COST INCURRED (100%)    =
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | THIS SECTION TO BE COMPLETED BY |  |  |  |  |  |  |  | FEDERAL SHARE (75%) =
 |  |  |  |  | PEMA only |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | State SHARE (22%) = |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Local SHARE (3%) = |  |  |  |  | 0
CERTIFICATION BY SUBGRANTEE:
I certify that to the best of my knowledge and belief the information above is correct and all reported costs were incurred in accordance with the approved grant and project scope of work.  I further certify that the originals of all the copies of attached canceled checks, payrolls, time records, contracts, etc. Are being maintained for review by appropriate federal/state officials.
 | SIGNATURE OF APPLICANT’S AGENT |  |  |  |  |  |  |  |  |  |  |  |  | DATE
Spreadsheet: 126040d1319487848-formula-problem-fsc-masterlist
Sheet: SAIA

3.35 | 0.165
 | 0.17
 | 0.17
 | 0.17
 | 0.17
 | 0.17
 | 0.175
 | 0.175
 | 0.175
 | 0.175
 | 0.175
 | 0.18
 | 0.18
 | 0.18
 | 0.18
 | 0.18
 | 0.185
 | 0.185
 | 0.185
 | 0.185
 | 0.185
 | 0.19
 | 0.19
 | 0.19
 | 0.19
 | 0.19
 | 0.195
 | 0.195
 | 0.195
 | 0.195
 | 0.195
 | 0.2
 | 0.2
 | 0.2
 | 0.2
 | 0.2
 | 0.205
 | 0.205
 | 0.205
 | 0.205
 | 0.205
 | 0.21
 | 0.21
 | 0.21
 | 0.21
 | 0.215
 | 0.215
 | 0.215
 | 0.215
 | 0.215
 | 0.22
 | 0.22
 | 0.22
 | 0.22
 | 0.22
 | 0.225
 | 0.225
 | 0.225
 | 0.225
 | 0.225
 | 0.23
 | 0.23
 | 0.23
 | 0.23
 | 0.23
 | 0.235
Spreadsheet: 740429d1626340111-power-query-refresh-and-sumifs-excel-forum-example
Sheet: Import Data

 |  | Acc No | Acc Name | Date |  | Order Type | Invoice/Credit |  |  |  | Value
05-0002-009 - Invoices By Rep Report | 2954 | EXAMPLE1 | EXAMPLE 1 | 2021-04-27 00:00:00 |  | Distribution | Invoice |  |  |  | 40.82
05-0002-009 - Invoices By Rep Report | 2961 | EXAMPLE2 | EXAMPLE 2 | 2021-01-07 00:00:00 |  | Distribution | Invoice |  |  |  | 288
05-0002-009 - Invoices By Rep Report | 2961 | EXAMPLE3 | EXAMPLE 3 | 2021-01-12 00:00:00 |  | Distribution | Invoice |  |  |  | 41.12
05-0002-009 - Invoices By Rep Report | 2961 | EXAMPLE4 | EXAMPLE 4 | 2021-01-12 00:00:00 |  | Distribution | Invoice |  |  |  | 246
Spreadsheet: 842659d1694685169-attendance-problem-and-working-across-multiple-worksheets-problem
Sheet: Group 3

Participant Name | [NAME] | School | 1/01/2023 (Mod 1) | Move1 | 2/01/2023 (Mod 2) | Move2
A3 | [EMAIL] | A3 School | y |  | n
B3 | [EMAIL] | B3 School | y |  | y
[NAME] | [EMAIL] | C3 School | n |  | y
D3 | [EMAIL] | D3 School | y |  | y
[NAME]
 | [EMAIL] | E2 School
Spreadsheet: 136502f1-24ac-43de-b4e8-e849930af81b
Sheet: 6.1

Table 6.1:GINI Index
Country | year | GINI Index
Egypt
 | 2005 | 32.14
 | 2008 | 30.77
Iraq | 2007 | 30.86
Jordan | 2008 | 33.82
 | 2010 | 35.43
Morocco | 2001 | 40.63
 | 2007 | 40.88
Qatar | 2007 | 41.1
Syrian Arab Republic | 2004 | 35.78
Sudan | 2009 | 35.29
Tunisia | 2005 | 41.42
 | 2010 | 36.06
Palestine | 2007 | 38.65
 | 2009 | 35.5
Yemen | 2005 | 37.69
Source: World Bank Database, 2013
Spreadsheet: 796575d1663356114-sample-data-for-date-and-time-based-on-specific-person-sample-file-etaf1
Sheet: Sheet2

Time | Date | Salesperson |  |  |  |  |  | 2020-08-12 00:00:00 | 2020-08-13 00:00:00 | 2020-08-14 00:00:00 | 2020-08-16 00:00:00 | 2020-08-17 00:00:00
00:38:00.010000 | 2020-08-10 00:00:00 | [NAME]
00:20:00.010000 | 2020-08-10 00:00:00 | [NAME] |  |  |  | Nick
00:18:00 | 2020-08-12 00:00:00 | Nick |  |  |  | [NAME]
00:09:59.962000 | 2020-08-12 00:00:00 | [NAME] |  |  |  | [NAME]
00:33:59.990000 | 2020-08-13 00:00:00 | [NAME] |  |  |  | [NAME]
00:22:59.981000 | 2020-08-14 00:00:00 | [NAME] |  |  |  | [NAME]
00:49:00.019000 | 2020-08-16 00:00:00 | [NAME]
00:56:00.010000 | 2020-08-17 00:00:00 | Nick
 |  |  |  |  |  | For instance on 8/10/20 mike ahs 0:38 and 0:20 hours. I need that to total to 0.58 hour and search the rest of my sales people for time on that day and then total there time  My end result will scroll a month's worth of time and check everyday for time from all my sales people then list them row A through what ever and shows the days across in each column. If I can get the formula to search properly I think I can get the summary sheet figured out.  in my example to get the value in A15 I got this far =SUMIFS($A$3:$A$10, $B$3:$B$10,G3, $C$3:$C$10, $C$3) but I can not figure out how to get it to check the next name listed for the same date and then move to 8/11
Spreadsheet: 724949d1616456171-calculating-pay-incorporating-anniversary-date-pay-increase-book1
Sheet: Sheet1

 |  |  |  | Basic Pay
Assumed Increment Date | WTE | Basic Pay (Pre Increment) | Basic Pay (Post Increment) | April | May | June | July | August | September | October | November | December | January | February | March
2021-04-01 00:00:00 | 1 | 55450 | 58383
2021-08-01 00:00:00 | 1 | 31365 | 33176
Spreadsheet: 99345d1297989590-automated-data-sorting-table-creation-advfilters
Sheet: Sheet1

x | y | z |  | x | y | z |  | x | y | z
1 | 2 | 4 |  | 1 |  |  |  | 2
2 | 4 | 5
1 | 1 | 6 |  | x | y | z |  | x | y | z
2 | 3 | 2 |  | 1 | 2 | 4 |  | 2 | 4 | 5
 |  |  |  | 1 | 1 | 6 |  | 2 | 3 | 2
 |  |  | This sheet has the data from A1 to C5
 |  |  | One criteria range is e1 to g1
 |  |  | with the records at E4
 |  |  | The second is to the left.
 |  |  | Study Advanced Filters.
Spreadsheet: 40281d1238587218-move-data-between-sheets-by-specifing-certain-criteria-order-2
Sheet: code 4

Date: |  |  |  | Code: | 4 | Count:
Renfro Item | Description |  |  | SKU | Qty | Qty | Qty | Qty | Qty | Qty | Qty | Qty | Qty | Qty | Qty | Qty