tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 867669d1714479329-automatically-copy-and-paste-rows-into-another-sheet-ef1641a_multi_sheets-to-one
Sheet: Bounced

 |  |  |  |  |  |  |  | Sheetname | Match_row |  |  | 0
[EMAIL] | 2024-04-21 00:00:00 | bounced |  |  |  |  |  |  |  |  | Sheet1
[EMAIL] | 2024-04-21 00:00:00 | bounced |  |  |  |  |  |  |  |  | Sheet2
[EMAIL] | 2024-04-23 00:00:00 | bounced |  |  |  |  |  |  |  |  | Sheet3
 |  |  |  |  |  |  |  |  |  |  | Sheet4
 |  |  |  |  |  |  |  |  |  |  | Sheet5
 |  |  |  |  |  |  |  |  |  |  | Sheet6
 |  |  |  |  |  |  |  |  |  |  | Sheet7
 |  |  |  |  |  |  |  |  |  |  | Sheet8
 |  |  |  |  |  |  |  |  |  |  | Sheet9
 |  |  |  |  |  |  |  |  |  |  | Sheet10
 | copy this row further as required ==>
Spreadsheet: 00d28689-b0b1-4542-88de-6c32aa6273c8
Sheet: Positions Funded

Request for Proposals
CDBG Program Year 2012-2013 |  |  |  | Agency Name:
Worksheet # 1 - Positions to be Funded
Please list each position for the activity for which funding is requested.  [NAME] all columns.
 | All Funding Sources |  |  |  | HUD Only
Job Title/Average No.of Weekly Hours Worked(for each person employed) | Total Base Monthly Salary (benefits not included) | Total Monthly Salary (benefits included) | Number of Months        Spent on Activity/         Project | Total Annual Payroll Cost (benefits included) | % of Time to be Spent on HUD Funded Program | Total Annual Payroll Cost HUD Funded
Sample Job Title / 30 Hours | 2000 | 2700 | 10 |  | 0.3
Grand Total
Note: Approved funding of salaries is reimbursable on a monthly basis following receipt of appropriately
documented time distribution and payroll records, i.e. timecards and copy of payroll register or check stubs.
Rev: 10/26/09 ga
Spreadsheet: 5d81c472-f0e2-44fd-9426-ffc18cc42f35
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Manufacturing: Manufacturing Production Process Development
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Manufacturing Production Process Development Pathway of the Manufacturing Career Cluster) can serve as a guide, along with other career planning materi-
als, as learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of
Study, used for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for        Manufacturing Production Process Development Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | ►Design Engineer ►Electrical and Electronic                            .   Technician and Technologist ►Electronics Engineer ►Engineering and [NAME].   Technician and Technologist ►Industrial Engineer ►Labor Relations Manager ►Manufacturing Engineer ►Manufacturing Technician ►Power Generating and Reactor                       .   Plant Operator ►Precision Inspector, [NAME] and                           .   Grader ►Process Improvement Technician ►Production Manager ►Purchasing Agent ►Supervisor
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 855687d1705190602-updating-a-calendar-from-dates-test-calendar-v1-taflorida-
Sheet: January

 |  |  | JANUARY
 |  |  | SUNDAY |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY
1
-1
2
Spreadsheet: 888653d1739222042-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 21

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Tue 3 Oct Glucose mmol/L
Wed 4 Oct Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
[NAME] mmol/L
Fri 6 Oct Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sat 7 Oct Glucose mmol/L
Sun 8 Oct Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Mon 9 Oct Glucose mmol/L
 |  |  |  |  |  |  | 7
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Tue 10 Oct Glucose mmol/L
Spreadsheet: 16c0646d-9f7b-4557-b1f0-b5748af1739e
Sheet: 38

شركت ساختماني گسترش و نوسازي صنايع ايرانیان مانا ([NAME])
يادداشتهاي [NAME] مالي
دوره مالي شش ماهه منتهي به 31 خرداد ماه 1390
25- خالص سایردرآمدهای عملیاتی
 |  |  | 1390/03/31 |  | 1389/06/31 |  | 1389/09/30
 |  |  | ريال |  | ريال |  | ريال
درآمد حق مباشرت پروژهها |  |  | 1786362095 |  | 25999092628 |  | 39073000000
26- هزينه هاي اداري و عمومي
سر فصل فوق متشكل از اقلام زير مي باشد:
 |  |  | 1390/03/31 |  | 1389/06/31 |  | 1389/09/30
 |  |  | ريال |  | ريال |  | ريال
حقوق و دستمزد و مزايا |  |  | 9753468506 |  | 8693053119 |  | 13673009112
مزاياي پايان خدمت كاركنان |  |  | 1667349686 |  | 1415327062 |  | 1872603979
استهلاك دارائيهاي ثابت مشهود |  |  | 437167751 |  | 577099551 |  | 828273477
خدمات پیمانکاری |  |  | 3711346615 |  | 4919950462 |  | 5013583796
بيمه سهم كارفرما و بيمه بيكاري |  |  |  |  | 892752366 |  | 1457843033
بيمه و عوارض و ماليات |  |  | 1329306352 |  | 419978134 |  | 441364724
حسابرسي |  |  | 40000000 |  | 0 |  | 722000000
حمل و نقل و اياب و ذهاب |  |  | 79362000 |  | 156482500 |  | 275943000
تعمير و نگهداري دارائيهاي ثابت مشهود |  |  | 1686573710 |  | 575943030 |  | 1027186666
آب و برق و گاز و سوخت حرارتي |  |  | 123372989 |  | 77767437 |  | 125187503
[NAME] و [NAME] |  |  | 209601950 |  | 219583761 |  | 223909999
تنظيفات و پذيرائي و آبدارخانه |  |  | 269677450 |  | 398975290 |  | 603169490
پست و تلگراف و تلفن |  |  | 35869384 |  | 34388844 |  | 62159246
ساير هزينه ها |  |  | 6954559598 |  | 2459814191 |  | 3032579482
 |  |  |  |  |  | .
Spreadsheet: 177463d1346318698-consolidate-totals-from-data-0a1fsample-exp
Sheet: EXP

Staff Name | Line/Authorising Manager | Course Title | Course Type (e.g. External Course, Conference) | Comments | Date of Course | Cost of Course | Cost Centre | Comments
[NAME] | [NAME] | SSHA Conference | [NAME] |  | 2012-09-29 00:00:00 | 65 | A02530
Jo | [NAME] | SSHA Conference | [NAME] |  | 2012-09-29 00:00:00 | 65 | A02530
[NAME] | [NAME] | Improving Outcomes | [NAME] |  | 2012-09-27 00:00:00 | 325 | A02651
[NAME] | [NAME] | The Future of Early Years Provision - Meeting the New Stat Framework | [NAME] |  | 2012-10-24 00:00:00 | 325 | A02651
[NAME] | [NAME] | Legal Aspects | [NAME] |  | 2012-10-17 00:00:00 | 349 | A02651
 |  |  |  |  |  | 1129
Spreadsheet: 793407d1661448979-combine-let-formulas-let-sample-to-combine
Sheet: Sep

Time Sheet summary
Working Code | Month | Working Area | Jhon | [NAME] | Daren | [NAME] | From Sheet Sep
DA-140200-DD01 | Sep'22 | Warehouse | 10 | 2 | 33
DA-140201-DD19 | Sep'22 | Office | 10 | 2 | 33
DA-140201-DD20 | Sep'22 | Pool |  |  | 33 | 6
DA-140201-DD21 | Sep'22 | Resto | 5 |  |  | 6
DA-140201-DD22 | Sep'22 | Kids Zone | 5 |  |  | 6
Spreadsheet: 40086718-ea9d-467e-ae2e-924b8104d4aa
Sheet: Sheet1

TABLE 1 | 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
June 2009-10 Hawai‘i Public High School Graduates
Enrolled Headcount in English Classes at the University of Hawai‘I By Course Category   1/
Fall 2008 -  Fall 2010
 |  |  |  | FALL 2008 |  |  | FALL 2009 |  |  | FALL 2010 |  |  | FALL 2011 |  |  | FALL 2012
 |  |  |  | TOTAL | V % |  | TOTAL | V % |  | TOTAL | V % |  | TOTAL | V % |  | TOTAL | V %
Public HS Graduates Enrolled at UH |  |  |  | 4409 | 100 |  | 4590 | 100 |  | 4232 | 100
 | Not Enrolled in English |  |  | 1388 | 31.2 |  | 1306 | 28.5 |  | 1274 | 30.1
 | Enrolled in English |  |  | 3021 | 68.5 |  | 3284 | 71.5 |  | 2958 | 69.9
 |  | Remedial / Developmental     2/ |  | 1602 | 36.3 |  | 1605 | 35 |  | 1376 | 32.5
 |  |  | Remedial | 350 | 7.9 |  | 398 | 8.7 |  | 201 | 4.7
 |  |  | Developmental | 1252 | 28.4 |  | 1207 | 26.3 |  | 1175 | 27.8
 |  | College Level      3/ |  | 1361 | 30.9 |  | 1605 | 35 |  | 1509 | 35.7
 |  |  | Business or Technical Writing | 6 | 0.1 |  | 1 | < 0.1 |  | 3 | 0.1
 |  |  | Composition I | 1336 | 30.3 |  | 1586 | 34.6 |  | 1480 | 35
 |  |  | Composition II | 5 | 0.1 |  | 1 | < 0.1 |  | 1 | < 0.1
 |  |  | [NAME] | 2 | < 0.1 |  | 1 | < 0.1 |  | 8 | 0.2
 |  |  | Literature | 12 | 0.3 |  | 16 | 0.3 |  | 17 | 0.4
 |  | Other     4/ |  | 58 | 1.3 |  | 74 | 1.6 |  | 73 | 1.7
 |  |  | [NAME] | 34 | 0.8 |  | 37 | 0.8 |  | 37 | 0.9
 |  |  | Career/Technical | 24 | 0.5 |  | 37 | 0.8 |  | 36 | 0.9
Notes:    V% (vertical percentage) = percentage headcount of the total Public High School Graduates Total at UH per fall semester.
 | 1/  Unduplicated headcount of Hawaii public high school graduates enrolled in a English course.  If the student is registered in more than one       English class, s/he is counted in the higher level course only.
 | 2/  Remedial and developmental classes were identified according to "Remedial and Developmental Education in the University of Hawaii       Community College System, White paper Group Committee, UHCC," no publication date noted, p. 137, as well as in consultation with the       Office of Academic Planning, Assessment and Policy Analysis, UHCC.
 | 3/  College Level courses refer to those that are 100-level and above.
 | 4/  Other courses refer to classes between developmental and 100-level courses and are not classifed as either remedial or developmental.
UH Institutional Research Office, December 2010
Spreadsheet: 4c659ae0-c200-4510-8443-a7aceff33506
Sheet: Sheet1

# | [NAME] | [NAME] | min. | sec. | 2b s. | 2b ú. | 3b s. | 3b ú. | TH s. | TH ú. | DU | DO | DC | Bl | As | M+ | M- | F+ | F- | Val | b.
4 | Jandová | Kristýna | 16 | 4 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 3 | 3 | 4
5 | Bulíčková | [NAME] | 12 | 56 | 1 | 1 | 1 | 0 | 8 | 7 | 1 | 2 | 3 | 0 | 0 | 0 | 0 | 3 | 3 | 10 | 9
9 | Brejchová | Kateřina | 23 | 34 | 4 | 1 | 1 | 1 | 0 | 0 | 3 | 1 | 4 | 0 | 0 | 0 | 0 | 2 | 2 | 6 | 5
12 | Effangová | [NAME] | 23 | 17 | 6 | 5 | 0 | 0 | 6 | 3 | 1 | 1 | 2 | 0 | 1 | 0 | 0 | 3 | 0 | 15 | 13
14 | Mircová | Eliška | 7 | 31 | 2 | 2 | 0 | 0 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 5
15 | [NAME] | [NAME] | 24 | 37 | 5 | 4 | 1 | 0 | 5 | 4 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 5 | 2 | 14 | 12
16 | Vrabcová | [NAME] | 21 | 19 | 5 | 4 | 1 | 0 | 3 | 3 | 2 | 1 | 3 | 0 | 0 | 0 | 0 | 2 | 3 | 11 | 11
19 | Chmelová | Kristina | 8 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | -2 | 0
24 | [NAME] | Monika | 18 | 56 | 6 | 4 | 3 | 1 | 8 | 5 | 4 | 0 | 4 | 0 | 0 | 0 | 1 | 5 | 2 | 15 | 16
31 | Červenková | Lucie | 15 | 31 | 3 | 3 | 2 | 1 | 6 | 1 | 3 | 1 | 4 | 0 | 0 | 0 | 0 | 2 | 3 | 7 | 10
41 | Flašíková | Martina | 15 | 22 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 6
53 | Kracíková | Tereza | 14 | 47 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 4
 |  |  | 40 | 0 | 37 | 29 | 10 | 4 | 41 | 25 | 15 | 7 | 22 | 0 | 2 | 0 | 1 | 27 | 27 | 73 | 95
 |  |  |  |  | 78% |  | 40% |  | 61%
Spreadsheet: 156251d1337242406-one-lookup-value-multiple-matches-book1
Sheet: Statement

[NAME]
Statement
Date
Address | Month Paid | Date Paid | Amount Paid | Other Income | Management Fee | Total
 | May
 | May
 | May
 | May
 | May
Total Income
Property Maintenance
Spreadsheet: 789190d1658992216-removing-duplicates-and-counting-test-sheet
Sheet: Summary

Summary
Invoice # | Sales person |  | Sales person | Invoice count
10001 | Adam |  | Adam | 2 |  |  | 2
10002 | [NAME] |  | [NAME] | 3 |  | [NAME] | 3
10003 | [NAME] |  | [NAME] | 3 |  | [NAME] | 3
10004 | [NAME] |  | [NAME] | 1 |  | [NAME] | 1
10005 | [NAME] |  | [NAME] | 1 |  | [NAME] | 1
10006 | Adam
10007 | [NAME]
10008 | [NAME]
10009 | [NAME]
10010 | [NAME]
Spreadsheet: 118424d1313678306-sign-value-reference-to-value-in-column-quest18-08
Sheet: Sheet1

Sell value | 1.5 | Buy new | 0.7
 |  |  | HOW IT SHOULD BE |  | # OPTIONS | COST OPTIONS
 |  |  |  |  | 1 | 9.2
 |  |  |  |  |  |  |  |  | If there is a 1 in column E, you follow the row to column G and go up to find the first cell with a value. Then you calculate b1*value of cell column G.
 |  |  | 13.8 | 1 |  |  |  |  | If there is a 0 in column E, you follow the row to column G and go up to find the first cell with a value. Then you calculate d1*value of cell column G.
 |  |  | 27.375 | 1 | 1 | 18.25
 |  |  | 1.225 | 0 | 1 | 1.75
 |  |  |  |  | 2 | 3.5
 |  |  | 2.45 | 0
 |  |  |  |  | 3 | 15.75
 |  |  | 23.62499999999999 | 1
 |  |  | 0.175 | 0 | 1 | 0.25
 |  |  |  |  | 2 | 0.5
 |  |  | 0.35 | 0
 |  |  | 1.575 | 0 | 3 | 2.25
 |  |  | 18 | 1 | 4 | 12
 |  |  | 0.07500000000000001 | 1 | 1 | 0.05
 |  |  |  |  | 1 | 0.05
Spreadsheet: 159964d1338914797-serial-number-in-column-leaving-rows-which-has-0-amount-serial-numbers
Sheet: Sheet1

Sr.No. |  | amount
1 |  | 10
2 |  | 0
3 |  | 10 |  | Amount in row 2nd is zero and 3rd is 10$ therefore, I want serial no as "0" on second row and 3rd will carry 2 number and so on for the rest of the column
4 |  | 15
5 |  | 0
6 |  | 11
7 |  | 61
8 |  | 0
9 |  | 21
10 |  | 23
Spreadsheet: 153249d1335825936-search-value-and-return-a-set-of-values-in-the-row-weatherdata_sample
Sheet: InsertIntoTable

Average Solar Radiation based on NREL Data
(kWh/m^2/day) | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Mount0 | 4.44 | 4.85 | 5.48 | 5.78 | 5.73 | 5.48 | 5.09 | 4.87 | 4.87 | 4.61 | 4.39 | 4.21
Mount1
Mount2
Mount3
Mount5
Mount6
Mount7
Mount8
Mount9
Spreadsheet: sally_beck__35758__MgmtSum-Q1-0313
Sheet: Whalley

ENRON NORTH AMERICA
1ST QUARTER 2000 EARNINGS ESTIMATE
Results based on Activity through February 17, 2000
 |  | Earnings Before Tax |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
Business Team |  | Estimate | Plan | [NAME] |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expense | Expense | Total
Gas Trading
Power Trading
Financial Drift
Financial Trading
Canada
Coal
Weather
Emissions
Insurance Group
Gas Assets - Trading
Executive Trading
Total Trading & Risk Mgt.
Spreadsheet: theresa_staab__39598__Producer Pricing Detail Nov01
Sheet: Internal Phillips Combined

FOR INTERNAL USE ONLY
First of Month Nomination:
BTU Factor:
Gathering: |  | per Mcf |  | per Mmbtu
 |  | SITARA #443322 |  | SITARA #443300 |  | SITARA #443314 |  | SITARA # 640466 |  |  | SITARA # 640458
 |  | Over 80% of FOM Nom. | CIG GD Volume MMBtu | 80% of FOM Nom. up to 10,000/Day | NGPL Volume MMBtu | 80% of FOM Nom. Less 10,000/Day | CIG Volume MMBtu | Non Dedicated Bear Paw Receipts | CIG Volume MMBtu |  | Non Dedicated Clydesdale Receipts | CIG Volume MMBtu
 | CIG GD Rockies | CIG GD les Netback |  | NGPL less Netback |  | CIG less Netback |  | CIG -.25-.145 |  |  | CIG -.25-.145
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
Weighted Average
Total Weighted Average Netback
*Total Receipts Fee Adjustment is calculated by applying the Field Services Fee to the fuel volume and then dividing that dollar amount(fee times fuel volume) by the volume purchased.
Spreadsheet: 845337d1696869413-power-query-question-example
Sheet: Sheet1

Name | Date | Time | LN#
[NAME] | 2023-01-02 00:00:00 | 12:36:00 | 123
[NAME] | 2023-01-05 00:00:00 | 01:45:00 | 894 |  |  | I want to move the number "894 into a new column E and number 456 into new column F and be left with only one row based on the latest date. (1/5/2023)
[NAME] | 2023-01-02 00:00:00 | 04:45:00 | 456
[NAME] | 2023-01-04 00:00:00 | 06:30:00 | 652
[NAME] | 2023-01-04 00:00:00 | 07:30:00 | 456
[NAME] | 2023-02-15 00:00:00 | 08:30:00 | 1345
[NAME] | 2023-02-15 00:00:00 | 09:00:00 | 487
Spreadsheet: 82486d1282568136-excel-2007-copy-top-10-from-worksheets-to-a-single-sheet-print-prep
Sheet: Rider Jack 96

Unit Type | Operator ID | Date / Time | Threshold | H Actual | V Actual | Unit No. | Department
[NAME] | [NAME] | 2010-07-12 15:11:00 |  | 7.22 | 0 | A | Shipping
[NAME] | Linus | 2010-07-12 21:37:00 |  | 7.05 | 0 | A | Shipping
Spreadsheet: 126310d1319630803-index-lookup-solution-example-bc
Sheet: Summary

 |  | Sheet Name | Entitlement | Remaining | Sick
 |  | Address | R7 | R9 | R5
[NAME] | Aberdeen
[NAME] | Aberdeen
[NAME] | Bellshill
[NAME] | Bellshill
[NAME] | Bellshill
[NAME] | Bellshill
[NAME] | Bellshill
[NAME] | Bellshill
[NAME] | Bellshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | [NAME]
[NAME] | [NAME]
Clive Postill | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Spreadsheet: 871585d1718030143-previous-month-closing-balance-previous-month-balance
Sheet: Monthly Bank Statement

 | The formula on H8 works when the transactions start on the first day of the month, when the transactions start on the second or fourth day of the month the formula does not work
 | The formula on H8 extract the closing balance of the previous month. Please kindly help with formula that extract the closing balance regardless of which day the transactions
 | starts
 |  |  |  |  | April
 | Date | Description | Account | Reference | Debit | Credit | Balance |  |  |  |  | April
 | Balance B/d |  |  |  |  |  |  |  |  |  |  | May
 |  | April | Swipe | Apb1 | 0 | 100000
 | 2024-04-03 00:00:00 | April | Swipe | Apb2 | 0 | 343459.91
 | 2024-04-03 00:00:00 | April | Swipe | Apb3 | 0 | 37500
 | 2024-04-03 00:00:00 | April | Swipe | Apb4 | 0 | 15000
 | 2024-04-06 00:00:00 | April | Swipe | ZiG Conversion | 0 | 2446419.65
 | 2024-04-17 00:00:00 | April | Fees | 15860 | 1356 | 0
 | 2024-04-23 00:00:00 | April | Telephone & Internet | 2267 | 0 | 65
 | 2024-04-23 00:00:00 | April | Electricity | 2268 | 0 | 675
 | 2024-04-23 00:00:00 | April | Bank Charges | Apb5 | 0 | 13.5
 | 2024-04-23 00:00:00 | April | Bank Charges | Apb6 | 0 | 6.75
 | 2024-04-23 00:00:00 | April | Bank Charges | Apb7 | 0 | 0.75
 | 2024-04-29 00:00:00 | April | Fees | 15862 | 1350 | 0
 | 2024-04-30 00:00:00 | April | Bank Charges | Apb8 | 0 | 192
 | 2024-04-29 00:00:00 | April | Bank Charges | Apb9 | 0 | 9.6