tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 700593d1603262910-return-a-filtered-unique-records-without-no-blanks-and-duplicates-return-a-unique-filtered-list-with-no-blanks
Sheet: Sheet1

 |  |  |  |  |  |  |  | Unique records without duplicates and blanks
Consumer | BS Cont | Activity | BS Code | Code | Liability | Certified |  | Consumer | BS Cont | Activity | BS Code | Code | Liability | Certified |  | Consumer | BS Cont | Activity | BS Code | Code | Liability | Certified
ABC | RI15121 | 1212 | 1255000020 | 1505050110 | 650000 |  |  |  |  |  |  |  |  |  |  | ABC | RI15121 | 1212 | 1255000020 | 1505050110 | 650000 | 650000
CBF | RI15023 | 1563 | 55010119 | 1505050111 | 273100 |  |  |  |  |  |  |  |  |  |  | CBF | RI15023 | 1563 | 55010119 | 1505050111 | 273100 | 273100
ABC | RI15121 | 1212 | 1255000020 | 1505050110 | 650000 |  |  |  |  |  |  |  |  |  |  | CUB | RI151565 | 2321 | 55000028 | 12719050163 | 60000 | 60000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GHF | RW129190 | 1563 | 55000050 | 12719050165 | 1777087 | 1777087
CBF | RI15023 | 1563 | 55010119 | 1505050111 | 273100 |  |  |  |  |  |  |  |  |  |  | LPO | RW129230 | 5654 | 55000001 | 72319050148 | 141096 | 141096
CBF | RI15023 | 1563 | 55010119 | 1505050111 | 273100 |  |  |  |  |  |  |  |  |  |  | OPO | RW126569 | 1245 | 55000013 | 72319050149 | 4245286 | 4245286
CUB | RI151565 | 2321 | 55000028 | 12719050163 | 60000 |  |  |  |  |  |  |  |  |  |  | SDF | RWA23210 | 1000 | 57110055 | 78919010161 | 172443.13 | 172443.13
CUB | RI151565 | 2321 | 55000028 | 12719050163 | 60000 |  |  |  |  |  |  |  |  |  |  | QWE | RWA23652 | 1563 | 51100101 | 78919010161 | 185415.65 | 185415.65
GHF | RW129190 | 1563 | 55000050 | 12719050165 | 1777087
LPO | RW129230 | 5654 | 55000001 | 72319050148 | 141096 |  |  |  | RI15121 | 1212 | 1255000020 | 1505050110 | 650000 | 650000
OPO | RW126569 | 1245 | 55000013 | 72319050149 | 4245286 |  |  | CBF | RI15023 | 1563 | 55010119 | 1505050111 | 273100 | 273100
CUB | RI151565 | 2321 | 55000028 | 12719050163 | 60000 |  |  | CUB | RI151565 | 2321 | 55000028 | 12719050163 | 60000 | 60000
 |  |  |  |  |  |  |  | GHF | RW129190 | 1563 | 55000050 | 12719050165 | 1777087 | 1777087
SDF | RWA23210 | 1000 | 57110055 | 78919010161 | 172443.13 |  |  | LPO | RW129230 | 5654 | 55000001 | 72319050148 | 141096 | 141096
QWE | RWA23652 | 1563 | 51100101 | 78919010161 | 185415.65 |  |  | OPO | RW126569 | 1245 | 55000013 | 72319050149 | 4245286 | 4245286
LPO | RW129230 | 5654 | 55000001 | 72319050148 | 141096 |  |  | SDF | RWA23210 | 1000 | 57110055 | 78919010161 | 172443.13 | 172443.13
 |  |  |  |  |  |  |  | QWE | RWA23652 | 1563 | 51100101 | 78919010161 | 185415.65 | 185415.65
Spreadsheet: 05937cd1-e300-4e11-b7b0-cf9f7dfd25d4
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
Transportation, Distribution and Logistics: Logistics Planning and Management Services
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Logistics Planning and Management Services Pathway of the Transportation, Distribution and Logistics Career Cluster) can serve as a guide, along with other
career planning materials, 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        Logistics Planning and Management Services Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | ►International Logistics Specialist  ►Logistician  ►Logistics Analyst  ►Logistics Consultant  ►Logistics Engineer  ►Logistics Manager
 |  | 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: 270833d1381699950-return-a-date-in-2nd-spreadsheet-using-an-if-statement-0a2
Sheet: Sheet2

Column A | Column B | Column C | Column D
123456789 | 2013-07-10 00:00:00 | BOOK | 2013-07-31 00:00:00 | 2013-07-31 00:00:00
777555444 | 2013-07-10 00:00:00 | RED | 2013-07-28 00:00:00 | 2013-07-28 00:00:00
999222333 | 2013-07-10 00:00:00 | ORANGE | N | N
888444666 | 2013-07-10 00:00:00 | BLUE | #N/A | 2013-07-20 00:00:00
Spreadsheet: 714592d1611304736-how-to-get-monthly-headcount-sample-data_monthly-hc
Sheet: Desired Output

 | Month | Total Active Headcount
2020 | 2020-01-01 00:00:00
 | 2020-02-01 00:00:00
 | 2020-03-01 00:00:00
 | 2020-04-01 00:00:00
 | 2020-05-01 00:00:00
 | 2020-06-01 00:00:00
 | 2020-07-01 00:00:00
 | 2020-08-01 00:00:00
 | 2020-09-01 00:00:00
 | 2020-10-01 00:00:00
 | 2020-11-01 00:00:00
 | 2020-12-01 00:00:00
Year | Month | Total Active Headcount
2021 | 2021-01-01 00:00:00
 | 2021-02-01 00:00:00
 | 2021-03-01 00:00:00
 | 2021-04-01 00:00:00
 | 2021-05-01 00:00:00
 | 2021-06-01 00:00:00
 | 2021-07-01 00:00:00
 | 2021-08-01 00:00:00
 | 2021-09-01 00:00:00
 | 2021-10-01 00:00:00
 | 2021-11-01 00:00:00
 | 2021-12-01 00:00:00
Spreadsheet: 863947d1711347340-count-and-match-column-heading-9-number-green-box-aligw
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4
 | 1 | 29 | 20 | 30 | 11 |  |  |  |  |  |  |  |  | 1 | 1
 | 2 | 28 |  |  |  |  |  |  |  |  |  |  |  | 2 | 1
 | 3 | 29 | 20 | 30 | 11 |  |  |  |  |  |  |  |  | 3 | 1
 | 4 | 28 |  |  |  |  |  |  |  |  |  |  |  | 4 | 1
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 1
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 1
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 1
 | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 1
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 1
 | 10 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 2
 | 11 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 2
 | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 2
 | 13 |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 2
 | 14 |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 2
 | 15 |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 2
 | 16 |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 2
 | 17 |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 2
 | 18 |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 2
 | 19 |  |  |  |  |  |  |  |  |  |  |  |  | 19 | 3
 | 20 |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 | 4
Spreadsheet: 269560d1381210589-index-and-match-help-production-status-1-
Sheet: Line2

 | BUTTER PRODUCTION LINE B
Order # | Item # | CUSTOMER | TYPE | COUNT | POUNDS | Production Date | Lot # | Request | [NAME]
p | 1 |  |  |  |  | Not Happy |  | Date
j | 2 |  |  |  |  | Not Happy
t | j |  |  |  |  | Not Happy
h | h |  |  |  |  | Not Happy
g | j |  |  |  |  | Not Happy
v | y |  |  |  |  | Not Happy
d | g |  |  |  |  | Not Happy
a | 3 |  |  |  |  | Not Happy
r | k |  |  |  |  | Not Happy
f | u |  |  |  |  | Not Happy
d | j |  |  |  |  | Not Happy
a | b |  |  |  |  | Not Happy
m | 1 |  |  |  |  | Not Happy
t | 2 |  |  |  |  | Not Happy
y | 3 |  |  |  |  | Not Happy
ui | 4 |  |  |  |  | Not Happy
ui | 5 |  |  |  |  | Not Happy
j | 6 |  |  |  |  | Not Happy
n | 7 |  |  |  |  | Not Happy
j | 8 |  |  |  |  | Not Happy
n | 9 |  |  |  |  | Not Happy
k | 10 |  |  |  |  | Not Happy
Spreadsheet: 88331d1288186753-excel-2007-transpose-salesperson-saleperson-advanced-transpose-mockup
Sheet: mock up result

Salesperson | Saleperson_Email | Customer_Name1 | Customer_Email1
[NAME] | [EMAIL] | [NAME] | [EMAIL]
[NAME] | [EMAIL] | Biggie | [EMAIL]
[NAME] | [EMAIL] | Helen | [EMAIL]
[NAME] | [EMAIL] | [NAME] | [EMAIL]
[NAME] | [EMAIL] | [NAME] | [EMAIL]
[NAME] | [EMAIL] | [NAME] | [EMAIL]
[NAME] | [EMAIL] | [NAME] | [EMAIL]
[NAME] | [EMAIL] | [NAME] | [EMAIL]
[NAME] | [EMAIL] | [NAME] | [EMAIL]
[NAME] | [EMAIL] | lennon | [EMAIL]
[NAME] | [EMAIL] | [NAME] | [EMAIL]
[NAME] | [EMAIL] | Caroline | [EMAIL]
Spreadsheet: kam_keiser__17890__EWS DPR 2002
Sheet: support for reclass of ENA

 | Regrouping of Gas & Power |  |  |  |  |  |  |  |  | to be moved to line:
 |  |  |  | Daily | 5 day | MTD | QTD | YTD |  |  |  | Daily | 5 day | MTD | QTD | YTD |  | Daily | 5 day | MTD | QTD | YTD
 | N America Natural Gas
1 |  | U.S. |  | -70412.32621000003 | 55616.11706999997 | 123841.5564 | 80576.46400000002 | 1327038.06721 |  |  |  |  |  |  |  |  |  | -74926.95199000003 | 71930.91055999997 | 214898.72119 | 120289.29247 | 1407451.91236
2 |  | Canada |  | 1250.83736 | -11502.74473 | -12273.36717 | 6306.665579999998 | 1753.096360000016 |  |  |  |  |  |  |  |  |  | -1477.59374 | -5617.29592000002 | 89690.7702 | -20420.85972000001 | 211520.84453
 | N America Electricity
3 |  | East |  | -23585.28095 | 12085.91396 | 57487.63651 | 15905.52142 | 432261.2030999999 |  |  |  |  |  |  |  |  |  | -23585.28095 | 11886.78996 | 57158.60251 | 15912.62042 | 433114.5040999998
4 |  | West |  | 9811.592970000002 | 28092.73502 | 60096.31193999999 | 60746.63885999999 | 853917.9342899999 |  |  |  |  |  |  |  |  |  | 9720.799970000002 | 27878.09402 | 59508.78393999999 | 60661.39285999999 | 878751.8902899999
5 |  | Canada |  | 1593.62194 | -4809.011830000006 | -97026.92766 | 36574.70105000001 | 116965.81342 |  |  |  |  |  |  |  |  |  | 1360.65994 | -4440.992830000006 | -97141.51566 | 37978.36805000001 | 110851.73842
6 |  | Canada Power-Gas |  | -2728.4311 | 5885.44880999998 | 101964.13737 | -26727.52530000001 | 209767.74817 |  | 2
 | Cross Commodity
 |  | Cross Commodity Gas |  | -4514.62578 | 16314.79349 | 91057.16479 | 39712.82846999999 | 80413.84514999998 |  | 1
 |  | CC Power - East |  | 0 | -199.124 | -329.034 | 7.099 | 853.301 |  | 3
 |  | CC Power - West |  | -90.793 | -214.641 | -587.528 | -85.246 | 24833.956 |  | 4
 |  | CC Power - Canada |  | -232.962 | 368.019 | -114.588 | 1403.667 | -6114.075 |  | 5
 |  | Global Products |  | 0 | -1000.001 | 500.13461 | 3728.26396 | 5115.72842 |  |  |  | 0 | -1000.001 | 500.13461 | 3728.26396 | 5115.72842 |  | 0 | -1000.001 | 500.13461 | 3728.26396 | 5115.72842
 |  | Steel |  | 0 | 0 | 0 | 0 | 161.21241 |  |  |  | 0 | 0 | 0 | 0 | 161.21241 |  | 0 | 0 | 0 | 0 | 161.21241
 |  | Coal |  | 0 | 0 | 0 | 0 | 9.704180000000001 |  |  |  | 0 | 0 | 0 | 0 | 9.704180000000001 |  | 0 | 0 | 0 | 0 | 9.704180000000001
 |  | Currency Swap |  | 15.73 | 72.734 | 1399.858 | 1272.918 | 723.206 |  |  |  | 15.73 | 72.734 | 1399.858 | 1272.918 | 723.206 |  | 15.73 | 72.734 | 1399.858 | 1272.918 | 723.206
 |  | Total
 |  | Other |  | 9882 | 9882 | 9882 | 33555 | 806789 |  |  |  | 9882 | 9882 | 9882 | 33555 | 806789
 |  | Drift |  | 7049.537 | 7049.537 | 7049.537 | 17113.789 | 138489.6825 |  |  |  | 7049.537 | 7049.537 | 7049.537 | 17113.789 | 138489.6825
Spreadsheet: 04b03813-db54-45d5-8513-b4d5729496df
Sheet: Sheet1

CWSP 2014- 2015 Budget Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Project Name:
Activity/ Expense | CWSP Funds | In-kind donations and other funding | Source of Match | Comments | Totals
Materials and Supplies
Plants |  |  |  |  | 0
Mulch |  |  |  |  | 0
Rentals |  |  |  |  | 0
Tools |  |  |  |  | 0
Erosion Control |  |  |  |  | 0
[NAME] and Disposal |  |  |  |  | 0
Other (specify) |  |  |  |  | 0
Refreshments ($200 [NAME])
Work Party Snacks |  |  |  |  | 0
Staff/Professional Services | $3,000 maximum on services, fees, and compensation. Youth compensation may comprise some or all of the $3,000 Services, Fees, and Compensation Limit. An additional $2,000 beyond that limit may be spent on youth participant compensation.
Project Coordinator |  |  |  |  | 0
Contracted Services |  |  |  |  | 0
Administrative Fees |  |  |  |  | 0
Insurance |  |  |  |  | 0
Permits |  |  |  |  | 0
Other (specify) |  |  |  |  | 0
[NAME] |  | Hours (estimate) | Estimated Value Per Hour | Comments
Student Volunteers |  |  | 9 |  | 0
[NAME] |  |  | 20 |  | 0
Professional Volunteers |  |  | 25 |  | 0
Volunteer Project Coordinator |  |  | 25 |  | 0
Total for Grant Project | CWSP Total | Matching Total |  |  | Project Total
 | 0 | 0 |  |  | 0
Note: Suggested line items are provided here.  These may be amended for your particular project, but please retain the blue category labels. Total CWSP budget may not exceed $10,000.
Spreadsheet: 770791d1646252633-working-time-directive-calculations-time-sheet
Sheet: 28-02-22

 | HMP BARLINNIE ESTATES |  |  |  |  | Week No. |  |  |  |  | Week Commencing |  |  |  |  |  |  | On Call Engineer |  |  | B Bamber / G McDade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On Call Manager |  |  | D reid
Toil | Name | Leave | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | SATURDAY |  | SUNDAY |  | Signature | leave |  | toil
 |  |  | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | O/T | TOIL | O/T | TOIL |  | Total | Balance | Total | Balance | total from last week | total leave taken | TOTAL | 17 WEEK Average | Avrage
 | [NAME] |  | 0 |  |  | AL | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  | TR | 7.5 |  |  |  | 7
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] |  | 7.5 | 1 |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 0 |  |  | AL | 0 |  |  | AL
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] |  | 7.5 |  |  | TR | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 0 |  |  | AL
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] |  | 7.5 |  |  |  | 7.5 | -1.5 |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | Vacant Post |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | I CONFIRM THE HOURS ABOVE ARE ACCURATE:
 | OTHER |  |  |  |  | TECHNICAL MANAGER
 | Description | Code
 | ANNUAL LEAVE | AL
 | SICK | SK |  |  |  | [NAME] MANAGER
 | SPECIAL LEAVE | SP
 | TRAINING | TR
 | OVERTIME AUTHORISED | TR
 | WORKING FROM HOME | WFH
 | MEETING | MT
 | WORKING FROM HOME |  | WFH
 | WORKING AT OTHER ESTABLISHMENT | O/ES
 | MONDAY | O/T
 |  | TOIL
 |  | OTHER
 | TUESDAY | O/T
 |  | TOIL
 |  | OTHER
 | WEDNESDAY | O/T
 |  | TOIL
 |  | OTHER
 | THURSDAY | O/T
 |  | TOIL
 |  | OTHER
 | FRIDAY | O/T
 |  | TOIL
 |  | OTHER
 | SATURDAY | O/T
 |  | TOIL
 | SUNDAY
 |  |  | TOIL
Spreadsheet: 468672d1467444809-lookup-problem-to-excel-forum-010716-part2
Sheet: sales

Date | Particulars | Vch Type | Vch No. | Debit
2015-05-21 00:00:00 | M/S M | sales | LS/15-16/1315 | 100
2015-03-09 00:00:00 | M/S E | sales | LS/14-15/7939 | 101
2015-03-12 00:00:00 | M/S C | sales | LS/14-15/8000 | 102
2015-03-02 00:00:00 | M/S C | sales | LS/14-15/7771 | 103
2015-06-02 00:00:00 | M/S D | sales | LS/14-15/8007 | 104
Spreadsheet: 152184d1335279922-ranking-on-particular-percentage-of-data-from-any-range-ranking-scores-rating
Sheet: Sheet1

User | Total Point | Rank
[NAME] | 693.7333333333332
[NAME] | 417.5666666666667
[NAME] | 415.9266666666667
[NAME] | 268.1333333333334
Priyanshu [NAME] | 219.6266666666667
[NAME] | 178
[NAME] | 142.4
[NAME] | 89.50000000000003
[NAME] | 89.20666666666666
Prashant Singh | 86.5
[NAME] | 63
[NAME] | 55.96000000000001
[NAME] | 52.58666666666666
KHEEM SINGH | 41.73333333333334
[NAME] | 28.56000000000002
Ishita dutta | 26.38666666666668
Meenal Rohela | 7.333333333333333
Manisha Madhu | 0.6666666666666667
[NAME] | -4.013333333333321
[NAME] | -6.453333333333319
Samsul Choudhary | -59.14666666666665
[NAME] | -91.83999999999999
Mohinish Baluni | -205.4
Grand Total | 2509.966666666667
Spreadsheet: 3f4b971a-4b2e-4314-bb78-8e5640b8b013
Sheet: 5.1 Table

5.1 Business interest rates
Month | 2010–11 | 2011–12 | 2012–13 | 2013–14 | 2014-15
Small business interest rate (a) (b) – per cent
September | 8.25 | 8.5 | 7.7 | 6.800000000000001 | 6.65
December | 8.6 | 8.15 | 7.25 | 6.75
March | 8.55 | 8.200000000000001 | 7.2 | 6.7
June | 8.55 | 7.75 | 7.050000000000001 | 6.7
Annual average (d) | 8.4875 | 8.15 | 7.3 | 6.7375
Large business interest rate (a) (c) – per cent
September | 6.4 | 6.45 | 5.65 | 4.75 | 4.45
December | 6.65 | 6.25 | 5.2 | 4.600000000000001
March | 6.600000000000001 | 6.2 | 5.100000000000001 | 4.600000000000001
June | 6.550000000000001 | 5.7 | 4.95 | 4.5
Annual average (d) | 6.550000000000001 | 6.149999999999999 | 5.225000000000001 | 4.612500000000001
(a) The data are weighted average rates, which are calculated from outstanding credit
held by businesses.
(b) In this context, a small business loan is defined as being less than $2 million.
(c) In this context, a large business loan is defined as being $2 million or more.
(d) Year ending June.
Source: RBA website, Statistical Tables, Interest Rates, Indicator [NAME] (F5).
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2015-01-02 00:00:00
Spreadsheet: 44336d1242925233-vlookup-to-return-multiple-values-test
Sheet: COMBINED

---------------- | ------ | ---- | ----- | ----------------------------------- | ------------ | -------
AGA.L | 2009-05-14 00:00:00 | IT |  | A S Roma Calcio SpA | Q3 | Q3 2008 A S ROMA SPA ROMA Earnings Release
AGA.L | 2009-05-14 00:00:00 | IT |  | A2A SpA | Q1 | Q1 2009 AEM SpA Earnings Release
AGA.L | 2009-05-12 00:00:00 | NL |  | Aalberts Industries NV | TRADE | Aalberts Industries N.V. Trading Update
INF.L | 2009-05-14 00:00:00 | IT |  | A S Roma Calcio SpA | Q3 | Q3 2008 A S ROMA SPA ROMA Earnings Release
INF.L | 2009-05-14 00:00:00 | IT |  | A2A SpA | Q1 | Q1 2009 AEM SpA Earnings Release
INF.L | 2009-05-12 00:00:00 | NL |  | Aalberts Industries NV | TRADE | Aalberts Industries N.V. Trading Update
Spreadsheet: 31107d1226865793-drop-down-boxes-eg
Sheet: Front Sheet

Drinks |  | Cost |  | time
beer
tea
coke
Spreadsheet: 471872d1469223801-incremental-formula-add-every-four-cell-of-same-row-adjacently-sum-blocks-of-4
Sheet: Sheet1

1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 11 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  | =[NAME]:A1)-1)*4+0
 |  |  |  |  |  |  | =[NAME]:A1)-1)*4-3
Spreadsheet: 152290d1335332461-credit-monitoring-arrangement-cma-demo-project
Sheet: Sheet1

State Bank of India
Balance Sheet
 |  |  |  |  |  | Rs in Cr.
 | 11 | 10 | 9 | 8 | 7 | 1900-01-12 00:00:00
P
 | 12 mths | 12 mths | 12 mths | 12 mths | 12 mths | Projected
Capital and Liabilities:
Total Share Capital | 635 | 634.88 | 634.88 | 631.47 | 526.3
Equity Share Capital | 635 | 634.88 | 634.88 | 631.47 | 526.3
Share Application Money | 0 | 0 | 0 | 0 | 0
Preference Share Capital | 0 | 0 | 0 | 0 | 0
Reserves | 64351.04 | 65314.32 | 57312.82 | 48401.19 | 30772.26
Revaluation Reserves | 0 | 0 | 0 | 0 | 0
Net Worth |  | 65949.2 | 57947.7 | 49032.66 | 31298.56
Deposits | 933932.81 | 804116.23 | 742073.13 | 537403.94 | 435521.09
Borrowings | 119568.96 | 103011.6 | 53713.68 | 51727.41 | 39703.34
Total Debt | 1053501.77 | 907127.83 | 795786.81 | 589131.35 | 475224.43
Other Liabilities & Provisions | 105248.39 | 80336.7 | 110697.57 | 83362.3 | 60042.26
Total Liabilities | 1223736.2 | 1053413.73 | 964432.08 | 721526.31 | 566565.25
 | Mar '11 | Mar '10 | Mar '09 | Mar '08 | Mar '07
 | 12 mths | 12 mths | 12 mths | 12 mths | 12 mths
Assets
Cash & Balances with RBI | 94395.5 | 61290.87 | 55546.17 | 51534.62 | 29076.43
Balance with Banks, Money at Call | 28478.65 | 34892.98 | 48857.63 | 15931.72 | 22892.27
Advances | 756719.45 | 631914.15 | 542503.2 | 416768.2 | 337336.49
Investments | 295600.57 | 285790.07 | 275953.96 | 189501.27 | 149148.88
Gross Block | 13189.28 | 112371.63 | 10403.06 | 8988.35 | 8061.92
Accumulated Depreciation | 8757.33 | 7253.9 | 6828.65 | 5849.13 | 5385.01
Net Block | 4431.95 |  | 3574.41 | 3139.22 | 2676.91
Capital Work In Progress | 332.23 |  | 263.44 | 234.26 | 141.95
Other Assets | 43777.85 | 35112.76 | 37733.27 | 44417.03 | 25292.31
Total Assets | 1223736.2 | 1053413.74 | 964432.08 | 721526.32 | 566565.24
Spreadsheet: 758791d1639067253-averaging-entries-per-day-by-date-excel_example-1-
Sheet: Sheet1

ID | Start time | Completion time | Call Number
43 | 2021-12-06 09:00:03 | 2021-12-06 09:17:47 | 904
44 | 2021-12-06 06:05:43 | 2021-12-06 10:37:33 | 935
45 | 2021-12-06 09:39:49 | 2021-12-06 12:11:45 | 914
46 | 2021-12-06 12:14:06 | 2021-12-06 12:15:18 | 947
47 | 2021-12-06 12:15:22 | 2021-12-06 12:15:58 | 947 |  |  |  | Samba's formula works here perfectly!
48 | 2021-12-06 12:22:30 | 2021-12-06 12:23:18 | 904
49 | 2021-12-06 10:37:38 | 2021-12-06 14:14:43 | 935 |  |  |  | But not if I expand the range, it does this >
50 | 2021-12-06 14:14:53 | 2021-12-06 15:33:54 | 935
51 | 2021-12-06 15:39:35 | 2021-12-06 15:40:27 | 904
52 | 2021-12-06 15:56:19 | 2021-12-06 15:58:58 | 752
53 | 2021-12-06 15:59:01 | 2021-12-06 15:59:37 | 752 |  |  |  | This formula seems to be working here
54 | 2021-12-07 16:00:17 | 2021-12-07 16:00:17 | 752
55 | 2021-12-07 16:10:08 | 2021-12-07 16:10:08 | 947 |  |  |  | But it did give me a bit of a differnet answer
56 | 2021-12-07 16:44:02 | 2021-12-07 16:44:02 | 947 |  |  |  | once the range was expanded.
Spreadsheet: 775493d1649151375-create-an-excel-table-that-sums-multiple-columns-from-a-multiple-drop-down-selection-example
Sheet: TABLE

Select >>>
[NAME] | Dance
Tier (Financial) | 1
Deal Type | Ongoing
GBP | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00
Spreadsheet: 329763d1404400035-formula-in-column-only-on-visible-cells-dynamic-referencing-konfis-v1
Sheet: Sheet1

ID | Num | Date | Dif
i1 | 11 | Date1
i1 | 12 | Date2
i1 | 13 | Date3
i3 | 20 | [NAME]
i3 | 21 | Date5
i5 | 41 | Date6
Spreadsheet: 192475d1352415704-finding-the-last-occurrence-of-a-value-in-a-list-lookup
Sheet: Sheet1

INPUT |  |  |  | DESIRED RESULT |  |  |  | VLOOKUP |  |  |  | LOOKUP
Time | Item | Action |  | Item | Last Action | Last Time |  | Item | Last Action | Last Time |  | Item | Last Action | Last Time
1 | A | Download |  | A | Install | 3 |  | A | Download |  |  | A | Download | 1
2 | B | Download |  | B | Download | 2 |  | B | Download |  |  | B | Download | 2
3 | A | Install |  | C | Inventory | 4 |  | C | Inventory |  |  | C | Inventory | 4
4 | C | Inventory