tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 776986d1650039011-return-monthly-ending-balance-end-of-month-balance
Sheet: End Of Month Balance

Date | Amount
2021-05-02 00:00:00 | 6320.7
2021-05-21 00:00:00 | 6240.7 |  | Months | End Balance
2021-05-23 00:00:00 | 6200.7 |  | 2021-04-30 00:00:00
2021-05-27 00:00:00 | 4636.7 |  | 2021-05-31 00:00:00
2021-05-27 00:00:00 | 7136.7 |  | 2021-06-30 00:00:00
2021-05-27 00:00:00 | 4636.7 |  | 2021-07-31 00:00:00
2021-05-27 00:00:00 | 4136.7 |  | 2021-08-31 00:00:00
2021-06-20 00:00:00 | 4066.7 |  | 2021-09-30 00:00:00
2021-07-03 00:00:00 | 3686.7 |  | 2021-10-31 00:00:00
2021-07-05 00:00:00 | 6686.7 |  | 2021-11-30 00:00:00
2021-07-06 00:00:00 | 6631.7 |  | 2021-12-31 00:00:00
2021-07-13 00:00:00 | 6581.7 |  | 2022-01-31 00:00:00
2021-07-15 00:00:00 | 6501.7 |  | 2022-02-28 00:00:00
2021-07-20 00:00:00 | 6001.7 |  | 2022-03-31 00:00:00
2021-07-20 00:00:00 | 5501.7 |  | 2022-04-30 00:00:00
2021-07-25 00:00:00 | 5517.34
2021-08-02 00:00:00 | 5485.34
2021-08-03 00:00:00 | 4985.34
2021-08-03 00:00:00 | 4485.34
2021-08-06 00:00:00 | 4435.34
2021-08-24 00:00:00 | 4385.34
2021-09-02 00:00:00 | 4365.34
2021-09-02 00:00:00 | 4345.34
2021-09-16 00:00:00 | 6845.34
2021-09-16 00:00:00 | 4345.34
2021-09-17 00:00:00 | 4145.34
2021-09-18 00:00:00 | 8035.34
2021-09-19 00:00:00 | 5035.34
2021-09-26 00:00:00 | 4460.34
2021-10-03 00:00:00 | 11950.34
2021-10-03 00:00:00 | 11610.34
2021-10-05 00:00:00 | 11110.34
2021-10-06 00:00:00 | 10765.34
2021-10-07 00:00:00 | 10600.34
2021-10-07 00:00:00 | 10480.34
2021-10-08 00:00:00 | 10330.34
2021-10-19 00:00:00 | 10260.34
2021-10-24 00:00:00 | 12260.34
2021-10-24 00:00:00 | 9260.34
2021-10-26 00:00:00 | 17260.34
2021-10-29 00:00:00 | 16760.34
2021-10-29 00:00:00 | 16260.34
2021-11-07 00:00:00 | 19260.34
2021-11-17 00:00:00 | 22408.34
2021-11-25 00:00:00 | 21908.34
2021-11-25 00:00:00 | 21408.34
2021-11-27 00:00:00 | 24408.34
2021-11-27 00:00:00 | 21408.34
2021-12-05 00:00:00 | 26408.34
2021-12-07 00:00:00 | 25908.34
2021-12-09 00:00:00 | 29620.34
2021-12-10 00:00:00 | 25620.34
2021-12-19 00:00:00 | 25600.34
2021-12-30 00:00:00 | 25100.34
2021-12-30 00:00:00 | 24600.34
2022-01-06 00:00:00 | 37180.34
2022-01-14 00:00:00 | 35180.34
2022-01-24 00:00:00 | 35170.34
2022-01-24 00:00:00 | 34660.34
2022-01-28 00:00:00 | 33660.34
2022-01-28 00:00:00 | 33410.34
2022-01-28 00:00:00 | 33152.34
2022-01-28 00:00:00 | 32642.34
2022-02-05 00:00:00 | 32542.34
2022-02-07 00:00:00 | 47542.34
2022-02-16 00:00:00 | 45542.34
2022-02-21 00:00:00 | 44542.34
2022-02-25 00:00:00 | 43542.34
2022-02-27 00:00:00 | 43532.34
2022-03-02 00:00:00 | 43482.34
2022-03-04 00:00:00 | 42482.34
2022-03-09 00:00:00 | 57482.34
2022-03-11 00:00:00 | 55982.34
2022-03-18 00:00:00 | 53982.34
2022-03-21 00:00:00 | 52962.34
2022-03-26 00:00:00 | 52952.34
2022-04-01 00:00:00 | 51452.34
2022-04-06 00:00:00 | 66452.34
2022-04-08 00:00:00 | 65452.34
2022-04-15 00:00:00 | 63952.34
Spreadsheet: 856420d1705666010-division-formula-test
Sheet: Sheet1

 | 2021-12-01 00:00:00 |  | 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
 | A | B | A | B | A | B | A | B | A | B | A | B | A | B | A | B | A | B | A | B | A | B | A | B | A | B | A | B
Total
 | 2021-12-01 00:00:00 | 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
Total (A/B)
Spreadsheet: 2e3a47f3-21d4-4f78-ba71-3371ac1e22b5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-04-28 11:31:05.840000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5 | 101.897 | 101.647 | 101.522 | 101.147 |  | and are added to price quote
4.875 | 101.397 | 101.147 | 101.022 | 100.647
4.75 | 100.404 | 100.154 | 100.029 | 99.654 |  | Note: | Refer To Price [NAME]
4.625 | 99.322 | 99.072 | 98.947 | 98.572 |  |  | For all Price Adjs
4.5 | 98.825 | 98.575 | 98.45
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.25 | 101.601 | 101.351 | 101.226 | 100.851
4.125 | 100.619 | 100.369 | 100.244 | 99.869
4 | 100.258 | 100.008 | 99.883 | 99.508
3.875 | 99.85 | 99.6 | 99.475 | 99.1
3.75 | 99.295 | 99.045 | 98.92
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-05-12 11:31:05.840000
30 DAY | 2011-05-27 11:31:05.840000
45 DAY | 2011-06-11 11:31:05.840000
60 DAY | 2011-06-26 11:31:05.840000
90 DAY | 2011-07-26 11:31:05.840000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 798852d1664787121-first-instance-of-number-less-than-or-equal-to-number-w-other-conditions-first-instance-of-number-less-than-or-equal-to-number-wt-other-conditions
Sheet: Sheet1 (2)

2022-09-01 00:00:00 | 1.1 |  | Number | Desired Result | Notes |  |  | [NAME]
 | 1.2 |  | 2.7 |  | Because all #'s still greater than 2.7
 | 1.8
 | 1.9
 | 2
 | 2.5
 | 2.7
 | 3
 | 4
 | 5
 | 2
 | 1
 | 2.7
 | 3
 | 4
 | 1
 | 2
 | 1
 | 0.5
Spreadsheet: 720152d1614034154-how-to-assign-a-number-for-item-tracking-flight-saturday
Sheet: Data

Flight: | 10
Day: | Saturday
 | Flight # | Start | End | Duration |  |  |  | Weekday |  |  | Saturday |  |  | Sunday
 |  | 05:50:00 | 13:16:00 |  |  |  |  | 0:00:00 | 1 |  | 00:00:00 | 5 |  | 00:00:00 | 7
 |  | 06:20:00 | 13:46:00 |  |  |  |  | 0:00:00 | 2 |  | 12:00:00 | 6 |  | 12:00:00 | 8
 |  | 06:50:00 | 14:16:00 |  |  |  |  | 12:00:00 | 3 |  | Extra | 9 |  | Extra | 9
 |  | 07:20:00 | 12:16:00 |  |  |  |  | 12:00:00 | 4
 |  | 07:50:00 | 15:26:00
 |  | 08:00:00 | 10:36:00
 |  | 08:20:00 | 15:56:00
 |  | 08:30:00 | 11:06:00
 |  | 08:50:00 | 18:56:00
 |  | 09:00:00 | 19:06:00
1090 |  | 09:20:00 | 14:26:00
1091 |  | 09:30:00 | 19:55:00
1092 |  | 09:50:00 | 14:56:00
1093 |  | 10:00:00 | 15:06:00
1094 |  | 10:10:00 | 15:16:00
1095 |  | 10:30:00 | 20:25:00
1096 |  | 11:00:00 | 21:05:00
 |  | 12:10:00 | 19:35:00
1097 |  | 13:10:00 | 15:46:00
 |  | 13:30:00 | 23:14:00
 |  | 14:10:00 | 23:34:00
 |  | 14:20:00 | 23:54:00
1098 |  | 14:30:00 | 17:06:00
 |  | 14:50:00 | 1900-01-01 00:14:00
 |  | 15:10:00 | 1900-01-01 00:34:00
 |  | 15:20:00 | 1900-01-01 00:54:00
 |  | 15:40:00 | 22:54:00
1099 |  | 15:50:00 | 20:45:00
1000 |  | 17:00:00 | 19:25:00
Spreadsheet: 165744d1341330895-looking-for-a-fuction-to-group-same-data-sample
Sheet: Sheet1

 | B | D1 | D2 | E1 | E2 | FOUND IN | CATEGORY GROUP
 | CHARLESTON |  |  |  |  | B | 1
 | SAVANNAH |  |  |  |  | B | 1
 | PORT SAID |  |  |  |  | B | 1
 | PARANAGUA |  |  |  |  | B | 1
 | NORFOLK, VA | NORFOLK, VA |  |  |  | BD1 | 2
 | [NAME] | [NAME] |  | [NAME] |  | BD1E1 | 3
 | AMSTERDAM | AMSTERDAM |  | AMSTERDAM |  | BD1E1 | 3
 | PIRAEUS | PIRAEUS |  | PIRAEUS |  | BD1E1 | 3
 | SINGAPORE | SINGAPORE |  | SINGAPORE |  | BD1E1 | 3
 | GENOA | GENOA |  | GENOA |  | BD1E1 | 3
 | DUBAI | DUBAI |  | DUBAI |  | BD1E1 | 3
 | FUJAIRAH | FUJAIRAH |  | FUJAIRAH |  | BD1E1 | 3
 | ALGECIRAS | ALGECIRAS |  | ALGECIRAS |  | BD1E1 | 3
 | NEW ORLEANS | NEW ORLEANS |  | NEW ORLEANS |  | BD1E1 | 3
 | HOUSTON | HOUSTON |  | HOUSTON |  | BD1E1 | 3
 | GIBRALTAR | GIBRALTAR |  | GIBRALTAR |  | BD1E1 | 3
 | NEW YORK | NEW YORK |  | NEW YORK |  | BD1E1 | 3
 | NEW HAVEN, CT | NEW HAVEN, CT |  | NEW HAVEN, CT |  | BD1E1 | 3
 | DURBAN |  | DURBAN |  |  | BD2 | 4
 | CAPE TOWN |  | CAPE TOWN |  |  | BD2 | 4
 | BALTIMORE |  | BALTIMORE |  |  | BD2 | 4
 | BEAUMONT |  | BEAUMONT |  |  | BD2 | 4
 | TAMPA, FL |  | TAMPA, FL |  |  | BD2 | 4
 | PORTLAND, OR |  | PORTLAND, OR |  |  | BD2 | 4
 | CORPUS CHRISTI |  | CORPUS CHRISTI | CORPUS CHRISTI |  | BD2E1 | 5
 | MIAMI |  | MIAMI | MIAMI |  | BD2E1 | 5
 | BOSTON, MA |  | BOSTON, MA | BOSTON, MA |  | BD2E1 | 5
 | SUEZ |  | SUEZ | SUEZ |  | BD2E1 | 5
 | PUSAN |  | PUSAN | PUSAN |  | BD2E1 | 5
 | BUENOS AIRES |  | BUENOS AIRES |  | BUENOS AIRES | BD2E2 | 6
 | RIO DE JANEIRO |  | RIO DE JANEIRO |  | RIO DE JANEIRO | BD2E2 | 6
 | SANTOS |  | SANTOS |  | SANTOS | BD2E2 | 6
 | RECIFE |  | RECIFE |  | RECIFE | BD2E2 | 6
 | VITORIA |  | VITORIA |  | VITORIA | BD2E2 | 6
 | ROSARIO |  | ROSARIO |  | ROSARIO | BD2E2 | 6
 |  |  | PORT SAID |  |  | D2 | 7
 |  |  | WILMINGTON, NC |  |  | D2 | 7
 |  |  | FORTALEZA |  | FORTALEZA | D2E2 | 7
 |  |  | SALVADOR |  | SALVADOR | D2E2 | 7
Spreadsheet: 68860d1269391790-bring-over-only-data-only-data
Sheet: Sheet2

1 | 25
2 | 34
3 | 32
4 | 64
5 | 15
6 | 63
7 | 101
8 | 25
9 | 34
10 |  |  | Not Sorted as requested
11
12
13
14
15
16
17
Spreadsheet: 232752d1367517055-one-excel-file-pages-will-not-print-other-excel-files-print-just-fine-sample-employee-list-2013
Sheet: Sick Days Report

Clock # | First Name | MI | Last Name | Sick Days  Eligible |  | Clock # | First Name | MI | Last Name | Sick Days  Eligible
0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 3
0 | 0 | 0 | 0 | 2 |  | 0 | 0 | 0 | 0 | 0.5
0 | 0 | 0 | 0 | 3 |  | 0 | 0 | 0 | 0 | 1.5
0 | 0 | 0 | 0 | 1.5 |  | 0 | 0 | 0 | 0 | 2.5
0 | 0 | 0 | 0 | 2.5 |  | 0 | 0 | 0 | 0 | 2.5
0 | 0 | 0 | 0 | 1 |  | 0 | 0 | 0 | 0 | 1.5
0 | 0 | 0 | 0 | 1 |  | 0 | 0 | 0 | 0 | 1
0 | 0 | 0 | 0 | 0.5 |  | 0 | 0 | 0 | 0 | 2.5
0 | 0 | 0 | 0 | 0.5 |  | 0 | 0 | 0 | 0 | 0.5
0 | 0 | 0 | 0 | 1 |  | 0 | 0 | 0 | 0 | 1.5
0 | 0 | 0 | 0 | 1.5
0 | 0 |  | 0 | 3
0 | 0 | 0 | 0 | 3
0 | 0 | 0 | 0 | 3
0 | 0 | 0 | 0 | 0.5
0 | 0 | 0 | 0 | 0.5
0 | 0 | 0 | 0 | 1.5
0 | 0 | 0 | 0 | 3
0 | 0 | 0 | 0 | 0.5
0 | 0 | 0 | 0 | 0.5
0 | 0 | 0 | 0 | 0.5
0 | 0 | 0 | 0 | 1.5
0 | 0 | 0 | 0 | 1
0 | 0 | 0 | 0 | 1.5
0 | 0 | 0 | 0 | 1.5
0 | 0 | 0 | 0 | 2.5
0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 2
0 | 0 | 0 | 0 | 2.5
0 | 0 | 0 | 0 | 1.5
0 | 0 | 0 | 0 | 2.5
0 | 0 | 0 | 0 | 1
0 | 0 | 0 | 0 | 3
0 | 0 | 0 | 0 | 1.5
0 | 0 | 0 | 0 | 1
0 | 0 | 0 | 0 | 0.5
0 | 0 | 0 | 0 | 0.5
0 | 0 | 0 | 0 | 0.5
0 | 0 | 0 | 0 | 0
 | [NAME] | E | [NAME]
301 | [NAME] | G | Combow
303 | Walter | S | [NAME]
304 | Arlin | L | [NAME]
305 | [NAME] | R | [NAME]
306 | [NAME] | L | [NAME]
309 | Walter | L | [NAME]
310 | [NAME] | W | [NAME]
311 | [NAME] | R | Penland
312 | [NAME] | P | Robins
313 | [NAME] | L | Street
314 | [NAME] | D | Street
315 | Curtis | R | Saul
316 | [NAME] | N | [NAME]
318 | [NAME] | L | [NAME]
319 | Timothy | A | Roe
320 | [NAME] | s | [NAME]
321 | Timothy | M | Groseclose
322 | [NAME] | P | McCray
323 | [NAME] | R | Fuller
324 | [NAME] | B | [NAME]
325 | [NAME] | J | [NAME]
326 | [NAME] | T | Woosley
330 | [NAME] | B | Ratcliffe
334 | Fain | W | Goodpasture
335 | [NAME] | T | Mutter
336 | Jeffery | L | Mullins
337
Spreadsheet: 127068d1320154466-conditional-sum-example-16-
Sheet: New Layout

Period | Date | Amount | Paid | Reference
1 | 2011-08-23 00:00:00 | 100.56 | X | AB58637F
1 | 2011-09-02 00:00:00 | 212 | X | 36519735665
1 | 2011-08-26 00:00:00 | 150 | X | R369FG3584WS325
1 | 2011-08-23 00:00:00 | 139.73 | X | AC79534F
2 | 2011-09-30 00:00:00 | 95 | X | AB58637G
2 | 2011-09-28 00:00:00 | 375 | X | 36519735666
2 | 2011-10-01 00:00:00 | 160 | X | S369FG3584WS325
2 | 2011-09-24 00:00:00 | 128 | X | AC79534G
3 | 2011-10-29 00:00:00 | 95 | X | AB58637H
3 | 2011-10-25 00:00:00 | 300.27 | X | 36519735667
3 |  | 150 |  | T369FG3584WS325
3 | 2011-10-25 00:00:00 | 117.69 | X | AC79534H
4 | 2011-11-26 00:00:00 | 120 |  | AB58637I
4 | 2011-11-26 00:00:00 | 351 |  | 36519735668
4 | 2011-11-26 00:00:00 | 180 |  | U369FG3584WS325
4 | 2011-11-26 00:00:00 | 117 |  | AC79534I
Spreadsheet: 878949d1726303913-xirr-with-criteria-xirr-with-criteria
Sheet: JT

Tran Date | Amount Invest | Value Return | Net Cash Flow | XIRR To-Date | 6-Period XIRR | Fund Code |  | XIRR To-Date | 6-Period XIRR
2013-12-30 00:00:00 | 3000 | 2902.91 |  |  |  | 123 |  |  |  |  | Change column D "Total Value Return" to "Net Cash Flow"
2014-04-01 00:00:00 | 0 | 53.66 |  |  |  | 123
2014-12-29 00:00:00 | 3000 | 2904.86 |  |  |  | 123
2015-04-01 00:00:00 | 0 | 131.12 |  |  |  | 123
2015-12-22 00:00:00 | 3000 | 2899.32 |  |  |  | 123
2016-04-01 00:00:00 | 0 | 234.31 |  |  |  | 123
2016-12-20 00:00:00 | 3000 | 2899.32 |  |  |  | 123
2017-04-03 00:00:00 | 0 | 322.24 |  |  |  | 123
2017-12-13 00:00:00 | -12506.55 | -12506.55 |  |  |  | 123
2017-12-13 00:00:00 | 12506.55 | 12506.55 |  |  |  | 456
2018-04-03 00:00:00 | 0 | 454.46 |  |  |  | 456
2018-12-11 00:00:00 | 3000 | 2904.85 |  |  |  | 456
2019-04-01 00:00:00 | 0 | 438.11 |  |  |  | 456
2019-12-16 00:00:00 | 3000 | 2904.85 |  |  |  | 456
2020-04-01 00:00:00 | 0 | 530.99 |  |  |  | 456
2021-04-01 00:00:00 | 0 | 729.13 |  |  |  | 456
2021-12-29 00:00:00 | 3000 | 2904.85 |  |  |  | 456
2022-04-01 00:00:00 | 0 | 852.81 |  |  |  | 456
2010-01-11 00:00:00 | 10000 | 9708.74 |  |  |  | 789
2010-11-01 00:00:00 | 0 | 923.37 |  |  |  | 789
2011-11-01 00:00:00 | 0 | 785 |  |  |  | 789
2012-11-01 00:00:00 | 0 | 614.54 |  |  |  | 789
2013-11-01 00:00:00 | 0 | 677.89 |  |  |  | 789
2014-11-03 00:00:00 | 0 | 958 |  |  |  | 789
2015-11-02 00:00:00 | 0 | 1031.28 |  |  |  | 789
2016-11-01 00:00:00 | 0 | 827.93 |  |  |  | 789
2017-11-01 00:00:00 | 0 | 871.57 |  |  |  | 789
2018-11-01 00:00:00 | 0 | 917.2 |  |  |  | 789
2019-11-01 00:00:00 | 0 | 161.54 |  |  |  | 789
2020-11-02 00:00:00 | 0 | 522.03 |  |  |  | 789
2021-11-01 00:00:00 | 0 | 538.49 |  |  |  | 789
2022-11-01 00:00:00 | 0 | 345.51 |  |  |  | 789
2010-09-07 00:00:00 | 6000 | 5825.24 |  |  |  | 234
2011-04-01 00:00:00 | 0 | 465.41 |  |  |  | 234
2011-04-21 00:00:00 | 4500 | 4368.93 |  |  |  | 234
2012-04-02 00:00:00 | 0 | 746.59 |  |  |  | 234
2013-04-01 00:00:00 | 0 | 905.77 |  |  |  | 234
2014-03-03 00:00:00 | 3000 | 2912.62 |  |  |  | 234
2014-04-01 00:00:00 | 0 | 1072.88 |  |  |  | 234
2015-04-01 00:00:00 | 0 | 1023.25 |  |  |  | 234
2016-04-01 00:00:00 | 0 | 642.76 |  |  |  | 234
2017-04-03 00:00:00 | 0 | 511.84 |  |  |  | 234
2018-04-02 00:00:00 | 5000 | 585.71 |  |  |  | 234
2019-04-01 00:00:00 | 0 | 603.94 |  |  |  | 234
2020-04-01 00:00:00 | 0 | 624.74 |  |  |  | 234
2021-04-01 00:00:00 | 0 | 813.3 |  |  |  | 234
2022-04-01 00:00:00 | 0 | 847.29 |  |  |  | 234
2023-04-03 00:00:00 | 0 | 424.43 |  |  |  | 234
2024-04-01 00:00:00 | 0 | 658.07 |  |  |  | 234
Spreadsheet: 853767d1703733786-function-for-permutation-and-combination-permutation-combination-dj-hd
Sheet: Sheet1

Given numbers |  |  | function results Permutation & Combination Example |  |  |  |  |  |  |  |  |  | Example 2, if Col A data is replace by 2, 4,6,8
1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
3 |  | 3 | 3 |  | Note |  |  |  |  |  |  |  |  | 4
5 |  | 5 | 5 |  | Small to large only, 1,3 if OK NOT 3,1 |  |  |  |  |  |  |  |  | 6
7 |  | 7 | 7 |  | Given number to change |  |  |  |  |  |  |  |  | 8
9 |  | 9 | 9 |  | Given  number , goes maximum up to two digits
 |  | 1,3 | 1,3
 |  | 1,5 | 1,5 |  | The way to go for a more mathematical solution:
 |  | 1,7 | 1,7 |  |  | 3,1 | 5,1 | 7,1 | 9,1
 |  | 1,9 | 1,9 |  | 1,3 | 3,3 | 5,3 | 7,3 | 9,3
 |  | 3,5 | 3,5 |  | 1,5 | 3,5 | 5,5 | 7,5 | 9,5
 |  | 3,7 | 3,7 |  | 1,7 | 3,7 | 5,7 | 7,7 | 9,7
 |  | 3,9 | 3,9 |  | 1,9 | 3,9 | 5,9 | 7,9 | 9,9
 |  | 5,7 | 5,7
 |  | 5,9 | 5,9
 |  | 7,9 | 7,9 |  | One cell solution:
 |  | 1,3,5 | 1,3,5
 |  | 1,3,7 | 1,3,7
 |  | 1,3,9 | 1,3,9
 |  | 1,5,7 | 1,5,7
 |  | 1,5,9 | 1,5,9
 |  | 1,7,9 | 1,7,9
 |  | 3,5,7 | 3,5,7
 |  | 3,5,9 | 3,5,9
 |  | 3,7,9 | 3,7,9 |  | One cell solution:
 |  | 5,7,9 | 5,7,9
 |  | 1,3,5,7 | 1,3,5,7
 |  | 1,3,5,9 | 1,3,5,9
 |  | 1,3,7,9 | 1,3,7,9
 |  | 1,5,7,9 | 1,5,7,9
 |  | 3,5,7,9 | 3,5,7,9
 |  | 1,3,5,7,9 | 1,3,5,7,9
Spreadsheet: 33666d1230192108-problem-with-showing-rows-and-columns-in-a-pivot-table-pivot-table-example
Sheet: Article ID

Article ID | Exp 1 | Exp 2 | Exp 3 | Exp 4 | Exp 5
1 | 0.02 | 0.54 | 0.25 | 0.35 | 0.65
2 | 1.02 | 0.84 | 0.65 | 0.15 | 0.95
3 | 0.52 | 0.44 | 0.28 | 0.3 | 0.62
4 | 0.2 | 0.35 | 0.18 | 0.45 | 0.85
5 | 1.36 | 1.58 | 1.8 | 2.02 | 2.24
6 | 1.52 | 1.051 | 0.582 | 0.113 | -0.356
7 | 0.52 | 1.166 | 1.812 | 2.458 | 3.104
8 | 0.48 | 1.281 | 2.082 | 2.883 | 3.684
9 | 0.09 | 1.396 | 2.702 | 4.008 | 5.314
10 | 1.62 | 1.511 | 1.402 | 1.293 | 1.184
11 | 18 | 1.626 | -14.748 | -31.122 | -47.496
12 | 0.98 | 1.741 | 2.502 | 3.263 | 4.024
13 | 1.01 | 1.856 | 2.702 | 3.548 | 4.394
Spreadsheet: 708097d1607614599-lookup-with-3-criteria-test-5-ans
Sheet: Data

MFG | Part Number | Part Description | Qty | Part Price | Labor Price | Selling Price | Cost
1001
32 - LOF Services
VLV | 881041 | Valv maxlife hm 5w20 oil | 4.9 | 33.27 | 0 | 33.27 | 12.99
VLV | 881629 | Val synpower 5w30 oil | 27 | 264.33 | 0 | 264.33 | 107.46
VLV | 881663 | Valv synpower 0w20 oil | 21.3 | 165.46 | 0 | 165.46 | 84.57
VLV | VV1550 | Valv maxlife hm 5w30 oil | 4.5 | 30.56 | 0 | 30.56 | 11.03
VLV | VV1740 | Valv 5w20 motor oil | 5.5 | 20.85 | 0 | 20.85 | 8.47
VLV | VV1770 | Valv 5w30 motor oil | 4.5 | 17.06 | 0 | 17.06 | 6.84
Pkg | BMLOFP1 | Valvoline conventional lof | 2 | 0 | 0 | 0 | 0
Pkg | BMLOFP4 | Valvoline high mileage lof | 2 | 0 | 0 | 0 | 0
Pkg | BMLOFP5 | Valvoline synthetic lof | 9 | 0 | 0 | 0 | 0
Pkg | LIFELOFP | Lifetime lof service package | 1 | 0 | 0 | 0 | 0
Other | OFS | Oil & filter service | 14 | 0 | 249.76 | 249.76 | 0
32 - LOF Services | 95.7 | 531.53 | 249.76 | 781.29 | 231.36
group total: | 95.7 | 531.53 | 249.76 | 781.29 | 231.36
1002
32 - LOF Services
VLV | 881041 | Valv maxlife hm 5w20 oil | 18 | 122.22 | 0 | 122.22 | 47.88
VLV | 881048 | Valv maxlife hm 0w20 oil | 6.5 | 44.14 | 0 | 44.14 | 17.29
VLV | 881050 | Valv synpower mst 5w40 oil | 5 | 48.95 | 0 | 48.95 | 21.2
VLV | 881629 | Val synpower 5w30 oil | 27 | 215.38 | 0 | 215.38 | 107.73
VLV | 881655 | Valv synpower 5w20 oil | 16.9 | 165.45 | 0 | 165.45 | 67.43
VLV | 881663 | Valv synpower 0w20 oil | 36.5 | 259.43 | 0 | 259.43 | 145.63
VLV | VV1550 | Valv maxlife hm 5w30 oil | 19.1 | 129.69 | 0 | 129.69 | 46.6
VLV | VV1740 | Valv 5w20 motor oil | 21 | 41.69 | 0 | 41.69 | 33.39
VLV | VV1770 | Valv 5w30 motor oil | 35.9 | 117.11 | 0 | 117.11 | 57.44
Pkg | BMLOFP1 | Valvoline conventional lof | 9 | 0 | 0 | 0 | 0
Pkg | BMLOFP4 | Valvoline high mileage lof | 7 | 0 | 0 | 0 | 0
Pkg | BMLOFP5 | Valvoline synthetic lof | 16 | 0 | 0 | 0 | 0
Pkg | LIFELOFP | Lifetime lof service package | 2 | 0 | 0 | 0 | 0
Other | OFS | Oil & filter service | 30 | 0 | 450.48 | 450.48 | 0
32 - LOF Services | 249.9 | 1144.06 | 450.48 | 1594.54 | 544.59
group total: | 249.9 | 1144.06 | 450.48 | 1594.54 | 544.59
Spreadsheet: 94716d1294445507-create-a-graph-qualifying-questions
Sheet: Sheet1

Have you been to an over 50’s Resort before | 5 | no | no | no | no | yes | yes | no | yes
Which one? What did you like / dislike | 0 |  |  |  |  | Halcyon | Ruby Gardens |  | Halcyon
How did you hear about us | 2 | friend | senior paper | website | friend | signage | website | website | website
What prompted you to start looking at 50+ Resorts | 0 | family in area |  | downsizing | travel | downsizing | retirement | burden of home | downsizing
Where do you currently live | 0 | NSW North Coast | NZ | Carseldine | Sunshine coast | Gold Coast Local | Brisbane South | Sydney | Gold Coast Local
How long have you been there | 0 | 5 | 20 | 3 |  | 20 | 10 | 3 | 3
Would you be selling your current home to be able to move into Seachange | 0 | yes | yes | yes | yes | yes | yes | yes | yes
What do you think your time frame is for moving | 0 | 9 - 12 months | 3 - 6 months | 2 years | 6 - 12 months | 3 - 6 months | 2+ | 2+ | 6 - 12 months
Is your home on the market | 0 | no | no | no | no | no | no | no | yes
Have you had an appraisal | 0 | yes | no | no | no | yes | no | no | no
Do you know what it would sell for | 0 | 310000 | 650000 | 600000 | no | no | no | no
What are your hobbies, sports, activities | 0 | travel, socialising | Arts & Crafts | Fishing, camping, bowling, tennis | golf | Arts & Crafts | workshop
What do you think the most important aspect of 50+ living is for you | 0 | Security, gated community | Security, gated community | Security, gated community | Security, gated community | Security, gated community | no gardening |  | Security, gated community
Do you have family living on the Coast / where are they? | 0 | yes | no | no | no | no | yes | no | yes
Spreadsheet: 876557d1723276185-how-do-lyou-do-this-nrygiel-sample-sum-or-count-2019-aligw
Sheet: Sheet1

NOT B |  | NOT B | 30 |  | NOT B | 30
2023-10-28 00:00:00 |  | 2023-10-28 00:00:00 | 14 |  | 2023-10-28 00:00:00 | 14
2023-09-27 00:00:00 |  | 2023-09-27 00:00:00 | 12 |  | 2023-09-27 00:00:00 | 12
NOT B |  | NOT B | 6 |  | NOT B | 6
2023-10-12 00:00:00 |  | 2023-10-12 00:00:00 | 78 |  | 2023-10-12 00:00:00 | 78
NOT b |  | NOT b | 46 |  | NOT b | 46
NOT b |  | NOT b | 91 |  | NOT b | 91
2023-09-21 00:00:00 |  | 2023-09-21 00:00:00 | 121 |  | 2023-09-21 00:00:00 | 121
NOT B |  | NOT B | 3 |  | NOT B | 3