tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 847783d1698657883-conditional-formatting-training-certificate-expiration-dates-course-matrix-august-2023
Sheet: DSE Training

 |  | DSE
 |  | (Yearly)
 | Name | Course | Date of course | Date of renewal
 | [NAME] | DSE | 23/08/23 | 23/08/24
 | [NAME] | DSE | Not Required | Not Required
 | [NAME] | DSE | Not Required | Not Required |  |  |  | Key
 | [NAME] | DSE | Not Required | Not Required |  |  |  |  | Not due
 | [NAME] | DSE |  |  |  |  |  |  | Overdue
 | [NAME] | DSE |  |  |  |  |  |  | Due within the next week
 | [NAME] | DSE | 2023-04-09 00:00:00 | 2024-04-09 00:00:00 |  |  |  |  | Required
 | [NAME] | DSE | Not Required | Not Required |  |  |  |  | Not Required
 | [NAME] | DSE
 | [NAME] | DSE
 | Greg Love | DSE | 23/10/23 | 23/10/24
 | [NAME] | DSE | Not Required | Not Required
 | [NAME] | DSE | Not Required | Not Required
 | [NAME] Parkinson | DSE | Not Required | Not Required
 | [NAME] | DSE | 23/08/23 | 23/08/24
 | [NAME] | DSE | 13/09/23 | 13/09/24
 | [NAME] | DSE | Not Required | Not Required
 | [NAME] | DSE | 24/08/23 | 24/08/24
 | [NAME] | DSE | Not Required | Not Required
 | [NAME] | DSE | Not Required | Not Required
 | [NAME] | DSE | 25/09/23 | 25/09/24
 | [NAME] | DSE | Not Required | Not Required
 | [NAME] | DSE | Not Required | Not Required
 | [NAME] | DSE
 | [NAME] | DSE | Not Required | Not Required
 | [NAME] | DSE | 17/10/23 | 17/10/24
 | [NAME] | DSE | Not Required | Not Required
 | [NAME] | DSE | 24/08/23 | 24/08/24
 | [NAME] | DSE | Not Required | Not Required
 | [NAME] | DSE
Spreadsheet: 00e38a92-1963-4e16-b477-4e82f3b8d2b6
Sheet: Sheet1

OBEC  DOBŠICE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Brněnská 70
671 82 DOBŠICE
ZÁMĚR ZASTUPITELSTVA OBCE DOBŠICE |  | č. [NAME]
O PRODEJI NEMOVITOSTI
Název nemovitosti : | [NAME] majetku [NAME] :
 | Pozemek : | 20,- Kč/m2
pozemek
 | Stavby: | 0
Umístění nemovitosti : | [NAME] a zařízení : | 0
 | Základní prostředky : | 0
stráň za areálem Elektro Švéda | Předměty postupné spotřeby: | 0
na ul. Leska
 | CELKEM :
parcela číslo : | Žadatel :
pozemek  p.č. 489/40
[NAME] území : | Navrhovaný účel využití :
Dobšice u Znojma | trvalý travní porost
[NAME] :
trvalý travní porost | [NAME] vlastnických práv :
výměra : | [NAME] a jízdy pro JMP Net, s.r.o.
 | v celkové délce 3,85 m.
985 m2
Připomínky a nabídky podávejte do 15 dnů ode dne vyvěšení na podatelně
Obecního úřadu v Dobšicích, Brněnská 70, 671 82 Dobšice
Záměr schválen ZO dne :   25.06.2012
[NAME]                  26.06.2012 | Ing. [NAME]
 | starosta obce
Sejmuto dne :                     11.07.2012
[NAME]: 26.06.2012
Spreadsheet: 709084d1608148062-report-values-between-2-sheets-cerca-vert-partic-2
Sheet: Sheet2

 |  |  |  | ordine | PZ | SETTIMANA 1 |  | RESULT IS THIS
 |  |  |  | 1234 | 22 | ABC1 |  | ITALIA
 |  |  |  | 1234 | 22 | ABC1 |  | FRANCIA
 |  |  |  | 1235 | 22 | ABC3 |  | SPAGNA
 |  |  |  | 1237 | 22 | ABC1 |  | ITALIA
 |  |  |  | 1237 | 22 | ABC1 |  | FRANCIA
 |  |  |  | 1237 | 22 | ABC1 |  | GERMANIA
 |  |  |  | 4533 | 12 | DSC1 |  | SPAGNA
 |  |  |  | 4533 | 12 | DSC1 |  | FRANCIA
 |  |  |  | 4533 | 12 | DSC1 |  | GERMANIA
 |  |  |  | 3344 | 5 | EFG3 |  | FRANCIA
 |  |  |  | 8899 | 12 | [NAME] |  | ITALIA
 |  |  |  | 8899 | 12 | [NAME] |  | FRANCIA
 |  |  |  | 8899 | 12 | [NAME] |  | SPAGNA
 |  |  |  | 9999 | 12 | [NAME] |  | SPAGNA
 |  |  |  | 9999 | 12 | [NAME] |  | SPAGNA
 |  |  |  | 7788 | 12 | ABC5 |  | FRANCIA
 |  |  |  | 1237 | 33 | ABC1 |  | ITALIA
 |  |  |  | 1237 | 33 | ABC1 |  | FRANCIA
 |  |  |  | 789 | 12 | ABC5 |  | FRANCIA
 |  |  |  | 789 | 12 | DSC1 |  | SPAGNA
 |  |  |  | 789 | 12 | DSC1 |  | FRANCIA
 |  |  |  | 789 | 12 | DSC1 |  | FRANCIA
 |  |  |  | 148 | 24 | DSC2 |  | SPAGNA
 |  |  |  | 148 | 24 | DSC2 |  | SPAGNA
 |  |  |  | 99 | 24 | EFG1 |  | SPAGNA
 |  |  |  | 99 | 24 | EFG1 |  | SPAGNA
 |  |  |  | 24 | 24 | EFG2 |  | ITALIA
 |  |  |  | 33 | 24 | EFG2 |  | FRANCIA
 |  |  |  | 987 | 45 | EFG3 |  | FRANCIA
 |  |  |  | 85 | 12 | [NAME] |  | ITALIA
 |  |  |  | 85 | 12 | [NAME] |  | FRANCIA
 |  |  |  | 1237 | 33 | ABC1 |  | ITALIA
 |  |  |  | 1237 | 33 | ABC1 |  | FRANCIA
 |  |  |  | 99 | 24 | EFG1 |  | SPAGNA
 |  |  |  | 58 | 21 | EFG1 |  | GERMANIA
 |  |  |  | 99 | 24 | EFG3 |  | FRANCIA
 |  |  |  | 99 | 24 | EFG3 |  | ITALIA
 |  |  |  | 99 | 24 | EFG3 |  | USA
Spreadsheet: 22493d1211404013-highlight-columns-example
Sheet: Sheet1

 |  |  |  | 24 | 31 | 36
 | Change me: |  |  | 26 | 31 | 36
 | 30 |  |  | 25 | 34 | 39
 |  |  |  | 25 | 35 | 60
 |  |  |  | 25 | 35 | 70
 |  |  |  | 30 | 33 | 67
 |  |  |  | 24 | 33 | 45
 |  |  |  | 28 | 33 | 42
Spreadsheet: 740082d1626178826-need-a-formula-to-match-and-pull-data-from-a-separate-sheet-referencematching
Sheet: Main

Owner | Car | Owner ID
? | Mazda 6 | 123
? | Buick | 123
? | Mazda CX5 | 123
? | Honda | 12344
? | Honda | 12344
? | BMW | 12344
? | Subaru | 9566
? | Mercedes | 8611
? | Mercedes | 8611
? | Fiat | 8611
? | Acura | 5445
? | Acura | 5445
? | Acura | 5445
? | BMW | 7854
? | BMW | 7854
? | BMW | 7854
? | Mercedes | 7854
Spreadsheet: 168575-excel-2007-rounding-hours-up-and-down-for-15minute-clock-in-out-intervals-hours-totals-and-rounding
Sheet: Sheet1

 |  | Mon | Tue | Wed | Thur | Fri | Sat | Sun | Weekly
 |  | 2012-07-09 00:00:00 | 2012-07-10 00:00:00 | 2012-07-11 00:00:00 | 2012-07-12 00:00:00 | 2012-07-13 00:00:00 | 2012-07-14 00:00:00 | 2012-07-15 00:00:00 | Total
 | Actual In | 07:51:00 | 07:49:00 | 07:46:00 | 07:55:00 | 07:58:00 | 07:56:00 | 07:48:00
 | Interval In | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 |  |  |  | [NAME] to round UP the actual clock in to the nearest 15mins ????????
 | Actual Out | 16:38:00 | 16:31:00 | 16:33:00 | 16:30:00 | 16:43:00 | 16:42:00 | 16:55:00
 | Interval Out | 16:30:00 | 16:30:00 | 16:30:00 | 16:30:00 | 16:30:00 | 16:30:00 | 16:45:00 |  |  |  | [NAME] to round DOWN the actual clock out to the nearest 15mins ?????????
 | Breaks | 00:30:00 | 00:30:00 | 00:30:00 | 00:30:00 | 00:30:00 | 00:30:00 | 00:30:00
 | Actual Total
 | Interval Total
 |  |  |  |  |  |  |  | 08:27:00
Spreadsheet: chris_germany__2310__Colsale1 (June 2000)
Sheet: Manual Invoice

Type | Delivery_Start_Date | Delivery_End_Date | Pipeline_Id | Point_Name | Sitara # | Item_Description | Quantity | Quantity_Unit_Id | Unit_Price | Extended_Amount
Manual Billing Items
Sale | 2000-06-01 00:00:00 | 2000-06-30 00:00:00 | CGAS | Citygate Sales |  | Cost of Gas | 646620 | MMBtu | 4.6613
Overtakes Using CES Trans. | 2000-06-01 00:00:00 | 2000-06-30 00:00:00 |  | Citygate Sales |  | Cost of Gas | 255462 |  | 4.6155
 |  |  |  |  |  |  | Total
Spreadsheet: 738140d1624870657-number-of-cells-between-2-cells-in-a-range-cell-spacing-2-
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
6 | 7 | 8 | 9 | 10 | 1 | 2 | 3 | 4 | 5
10
2
Spreadsheet: a383921f-370f-455a-bf1b-8004df2d7a66
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
42246976 | 2014-07-10 23:05:53 | AXIS | 1 | 10 | 6 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42329170 | 2014-07-16 19:00:09 | ALLIES | 0 | 4 | 7 | 1606046 | Mormant | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42371364 | 2014-07-19 23:40:36 | ALLIES | 1 | 6 | 1 | 1503523 | glaubermoreirabs | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42385548 | 2014-07-20 22:32:41 | ALLIES | 0 | 4 | 7 | 778385 | Major [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42426060 | 2014-07-23 20:49:42 | AXIS | 1 | 6 | 5 | 1589254 | Dieudonné de Laubier | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
42426397 | 2014-07-23 21:20:38 | ALLIES | 1 | 6 | 3 | 1589254 | Dieudonné de Laubier | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
Spreadsheet: 827756d1683018373-formulas-to-find-a-linear-interpolation-of-a-value-in-a-table-interpolation-array-aligw
Sheet: Sheet1

 |  | inclination
 | Height | Column1 | 0 | 1 | 2 | 3 | 4 | 5
 |  | 0 | 0.062 | 0.053 | 0.045 | 0.036 | 0.029 | 0.024
 |  | 5 | 0.159 | 0.15 | 0.141 | 0.133 | 0.124 | 0.115
 |  | 10 | 0.256 | 0.247 | 0.238 | 0.23 | 0.221 | 0.212
 |  | 15 | 0.353 | 0.344 | 0.335 | 0.327 | 0.318 | 0.309
 |  | 20 | 0.45 | 0.441 | 0.432 | 0.424 | 0.415 | 0.406
 |  | 25 | 0.547 | 0.538 | 0.529 | 0.52 | 0.512 | 0.503
 |  | 30 | 0.644 | 0.635 | 0.626 | 0.617 | 0.609 | 0.6
 |  | 35 | 0.74 | 0.732 | 0.723 | 0.714 | 0.706 | 0.697
 |  | 40 | 0.837 | 0.829 | 0.82 | 0.811 | 0.802 | 0.794
 |  | 45 | 0.934 | 0.926 | 0.917 | 0.908 | 0.899 | 0.891 |  | Inclination variable |  | 2.2
 |  | 50 | 1.031 | 1.023 | 1.014 | 1.005 | 0.996 | 0.988 |  | Height variable | 43
 |  | 55 | 1.128 | 1.119 | 1.111 | 1.102 | 1.093 | 1.085
 |  | 60 | 1.225 | 1.216 | 1.208 | 1.199 | 1.19 | 1.181
 |  | 65 | 1.322 | 1.313 | 1.305 | 1.296 | 1.287 | 1.278
 |  | 70 | 1.419 | 1.41 | 1.401 | 1.393 | 1.384 | 1.375
 |  | 75 | 1.516 | 1.507 | 1.498 | 1.49 | 1.481 | 1.472
 |  | 80 | 1.613 | 1.604 | 1.595 | 1.587 | 1.578 | 1.569
 |  | 85 | 1.71 | 1.701 | 1.692 | 1.684 | 1.675 | 1.666
 |  | 90 | 1.807 | 1.798 | 1.789 | 1.78 | 1.772 | 1.763
 |  | 95 | 1.904 | 1.895 | 1.886 | 1.877 | 1.869 | 1.86
 |  | 100 | 2.001 | 1.992 | 1.983 | 1.974 | 1.966 | 1.957
 |  | 105 | 2.097 | 2.089 | 2.08 | 2.071 | 2.062 | 2.054
 |  | 110 | 2.194 | 2.186 | 2.177 | 2.168 | 2.159 | 2.151
 |  | 115 | 2.291 | 2.283 | 2.274 | 2.265 | 2.256 | 2.248
 |  | 120 | 2.326 | 2.326 | 2.326 | 2.326 | 2.324 | 2.321
 |  | 125 | 2.326 | 2.326 | 2.326 | 2.326 | 2.326 | 2.326
 |  | 130 | 2.326 | 2.326 | 2.326 | 2.326 | 2.326 | 2.326
Spreadsheet: 46450d1245318544-if-statement-or-vlookup-help-example6
Sheet: Special Agreements By Code

Special Agreements By Code
Trade | Customer Name | Named Account | Contract Number | Description | Name | POL | POD | 20ft | 40ft | TEU
AUSTRALIA | a | AUS/NZ MEAT | 34 | 20RE: 7 free days, day 8-14 £60 per day, £90 per day thereafter. 40RE AND 40HR: 7 free days, day 8-14 £80 per day, £140 per day thereafter. | Demurrage - POD | All Ports | FELIXSTOWE
AUSTRALIA | b | AUS/NZ MEAT | 65 | 20RE: 7 free days, day 8-14 £60 per day, £90 per day thereafter. 40RE AND 40HR: 7 free days, day 8-14 £80 per day, £140 per day thereafter. | Demurrage - POD | All Ports | TILBURY
AUSTRALIA | c | BRISTOL QUAY DEVAN | 23 | No LoLo if devan on quay | LO/LO | All Ports | BRISTOL
AUSTRALIA | d | Constellation | 46 | 14 FREE DAYS | Demurrage - POD | All Ports | All Ports
AUSTRALIA | e | Constellation | 67 | No Lo/Lo | LO/LO | All Ports | BRISTOL
AUSTRALIA | f | Constellation | 68 | 14 FREE DAYS | Demurrage - POD | All Ports | All Ports
AUSTRALIA | g | Constellation | 69 | NO LO/LO | LO/LO | All Ports | All Ports
AUSTRALIA | h | Constellation | 74 | 14 free days | Demurrage - POD | All Ports | All Ports
AUSTRALIA | i | Constellation | 76 | NIL | LO/LO | All Ports | BRISTOL
AUSTRALIA | j | Constellation | 79 | 14 free days | Demurrage - POD | All Ports | All Ports
AUSTRALIA | k | Constellation | 12 | NIL | LO/LO | All Ports | BRISTOL
AUSTRALIA | l | DEVAN ON QUAY | 14 | 10 FREE DAYS | Demurrage - POD | All Ports | All Ports
AUSTRALIA | m | DEVAN ON QUAY | 16 | NO LO/LO IF DEVANED ON QUAY | LO/LO | All Ports | All Ports
Spreadsheet: 824421d1680573494-error-occurred-when-it-comes-to-month-end-rolling-programme-excel-forum-
Sheet: Summary Sheet

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-01 00:00:00
 | Annual Test 年檢
 | Annual Test  (AT) |  |  |  | 5Y Full-Load (FL)
 | Leave and Holiday Duty 放假及當更
Spreadsheet: 858484d1707153968-counting-the-controls-passed-failed-sample_file
Sheet: OutPut

Month | Jan'24 |  |  | Feb'24
 | Pass | Fail | Not Completed | Pass | Fail | Not Completed
[NAME]
User 2
User 3
Spreadsheet: 45237d1244025118-summarising-51-different-dsums-muni-masters
Sheet: Municipal Collections Summary

Municipal Cages Collections Summary
Week commencing
Site | District | [NAME] | [NAME] CRTs | Fridges | Total all collections
[NAME] | Calderdale
Elland | Calderdale
[NAME] | Calderdale
Milner Royd | Calderdale
Todmorden | Calderdale
Calverley Bridge | Leeds
East Leeds | Leeds
[NAME] | Leeds
Holmewell Road | Leeds
[NAME] | Leeds
[NAME] | Leeds
Meanwood Road | Leeds
Milners Road | Leeds
[NAME] | Leeds
St Judes | Leeds
Stanley Road | Leeds
[NAME] | Leeds
 | Total
Spreadsheet: 749481d1632830774-calculating-difference-between-cells-containing-date-and-time-sample-68-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  | Date/Time Logged | Date/Time Completed | Duration | CF formula
 |  |  |  |  |  |  |  | 2021-08-02 09:16:00 | 2021-08-02 11:11:00
 |  |  |  |  |  |  |  | 2021-08-02 09:30:00 | 2021-08-03 05:58:00
 |  |  |  |  |  |  |  | 2021-08-02 09:45:00 | 2021-08-03 09:46:00
 |  |  |  |  |  |  |  | 2021-08-02 09:51:00 | 2021-08-02 12:21:00
 |  |  |  |  |  |  |  | 2021-08-02 10:29:00 | 2021-08-03 11:26:00
 |  |  |  |  |  |  |  | 2021-08-02 10:32:00 | 2021-08-03 07:06:00
 |  |  |  |  |  |  |  | 2021-08-02 10:38:00 | 2021-08-03 15:38:00
 |  |  |  |  |  |  |  | 2021-08-02 11:08:00 | 2021-08-03 09:26:00
 |  |  |  |  |  |  |  | 2021-08-02 11:39:00 | 2021-08-03 09:42:00
 |  |  |  |  |  |  |  | 2021-08-02 13:31:00 | 2021-08-03 10:23:00
 |  |  |  |  |  |  |  | 2021-08-02 10:32:00 | 2021-08-03 07:06:00
 |  |  |  |  |  |  |  | 2021-08-02 14:30:00 | 2021-08-17 10:22:00
 |  |  |  |  |  |  |  | 2021-08-02 14:43:00 | 2021-08-17 10:53:00
Spreadsheet: 530aa39a-067d-45e1-b64a-e5689155c1e4
Sheet: Sheet1

Table 7--U.S. textile exports, by fiber | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | July | Aug | Sep. | Sep.
Item | 2012 | 2012 | 2012 | 2011
 | 1,000 pounds 1/
[NAME], thread, and fabric: | 233263.105 | 244659.083 | 245843.685 | 244989.708
Cotton | 124127.247 | 129911.083 | 130962.124 | 132364.631
Linen | 6875.116 | 6645 | 6762.965 | 6627.188
Wool | 2624.69 | 3112 | 2929.695 | 3282.234
Silk | 893.746 | 917 | 1053.537 | 1016.515
Manmade | 98742.306 | 104074 | 104135.364 | 101699.14
Apparel: | 25193.2 | 26286.066 | 25480.095 | 22492.675
Cotton | 11551.455 | 11888.666 | 11166.389 | 9892.443
Linen | 351.068 | 407.018 | 305.216 | 561.512
Wool | 1208.407 | 1513.395 | 1739.337 | 1580.354
Silk | 1108.365 | 1528.725 | 1363.611 | 1270.359
Manmade | 10973.905 | 10948.262 | 10905.542 | 9188.007
Home furnishings: | 5447.964 | 5946.236000000001 | 5902.689 | 4157.464
Cotton | 2677.186 | 2915 | 2878.091 | 1894.343
Linen | 181.718 | 203.677 | 268.422 | 196.193
Wool | 108.414 | 111.217 | 162.174 | 131.928
Silk | 92.893 | 73.618 | 150 | 104
Manmade | 2387.753 | 2642.724 | 2444.002 | 1831
Floor coverings: | 26980.204 | 31400.243 | 29665.881 | 31760.807
Cotton | 1785.142 | 2076.261 | 2292.731 | 2107.784
Linen | 813.49 | 975.399 | 1077.15 | 1082.641
Wool | 2127.362 | 2087 | 2252 | 3491.98
Silk | 31.732 | 28.758 | 29 | 33.408
Manmade | 22222.478 | 26232.825 | 24015 | 25044.994
Total exports: 2/ | 290990.193 | 308449.449 | 307004.413 | 303647.081
Cotton | 140219.039 | 146906.627 | 147381.019 | 146356.596
Linen | 8221.393 | 8231 | 8413.753 | 8476.886
Wool | 6071.804 | 6827.389 | 7086.891 | 8496.739
Silk | 2126.736 | 2548.585 | 2595.628 | 2424.556
Manmade | 134351.221 | 143935.848 | 141527.122 | 137892.304
1/ Raw-fiber equivalent.  2/ Includes headgear.
Last update:  12/12/12.
Sources: USDA, Economic Research Service; and USDC,
U.S. Census Bureau.
Spreadsheet: michelle_lokay__26570__imbalsumm0012
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 874740 | 852410
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 |  | 735368 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 896463 | 934551
500293 | 481044 | 610626
500302 |  | 7950
500303 | 278090 | 242018
500305 | 1412054 | 1344321
500307 | 36311 | 55275
500313 |  | 3196
500314
500655 | 51442
500657 | 257670 | 228846
INDEX
2000-11-30 00:00:00 |  |  | -122087.9
2000-12-25 00:00:00
Spreadsheet: 57139d1257291078-how-to-find-at-what-attempt-completed-course-table-file
Sheet: Results Table

Salary No | M003753
# of Attempts
Course | Attempt 1 | Attempt 2 | Attempt 3
AML Client Identification & Verification
Basis of Advice (LEAP)
Business Insurance Fundamentals
Client Profile Book
Financial Planning FSG
Handling Objections
Investment Fundamentals - Managed Funds Assessment
Reasonable Basis of Advice
Risk - Ownership & Payment
Risk Profile Tool
Superannuation - Basics and Contribution Rules Assessment for Advanced Planners
Superannuation - Contributions Assessment for Foundation Planners
Superannuation - Life Insurance Within Super Assessment for Foundation Planners
Superannuation - Preservation and ETPs Assessment for Foundation Planners
Superannuation - Retirement Income Assessment for Advanced Planners
Superannuation - Self Managed Super Assessment for Senior Planners
Welcome to Advice Academy
What not to do in a 1st interview
Spreadsheet: 79360d1279640512-excel-2007-loop-to-check-if-date-is-between-two-dates-from-2nd-workbook-and-loop-until-true-summary
Sheet: Sheet1

Week Start | 2010-06-06 00:00:00
Job 1
Job 2
Job 3
Job 4
Job 5
Job 6
Job 7
Job 8
Spreadsheet: 676136d1588675181-conditional-formatting-of-due-date-scheduletemplate-etaf
Sheet: LIST

MONTH NO. | MONTH | time card due dates
1 | JANUARY | 2020-01-16 00:00:00
2 | FEBRUARY | 2020-01-31 00:00:00
3 | [NAME] | 2020-02-14 00:00:00
4 | APRIL | 2020-02-28 00:00:00
5 | MAY | 2020-03-13 00:00:00
6 | [NAME] | 2020-03-31 00:00:00
7 | JULY | 2020-04-16 00:00:00
8 | AUGUST | 2020-05-01 00:00:00
9 | SEPTEMBER | 2020-05-15 00:00:00
10 | OCTOBER | 2020-05-29 00:00:00
11 | NOVEMBER | 2020-06-16 00:00:00
12 | DECEMBER | 2020-06-30 00:00:00
 |  | 2020-07-16 00:00:00
 |  | 2020-07-31 00:00:00
 |  | 2020-08-14 00:00:00
 |  | 2020-08-28 00:00:00
 |  | 2020-09-16 00:00:00
 |  | 2020-09-30 00:00:00
 |  | 2020-10-16 00:00:00
 |  | 2020-10-30 00:00:00
 |  | 2020-11-13 00:00:00
 |  | 2020-12-01 00:00:00
 |  | 2020-12-14 00:00:00
 |  | 2020-12-31 00:00:00
Spreadsheet: 718366d1613124060-substract-value-add-no-macros-fruits
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | How I want to see here on L
 |  |  | banana | 50 |  |  |  |  |  |  | [NAME] | 80
 |  |  | apple | 35 |  |  |  |  |  |  | banana | 55
 |  |  | [NAME] | 70 |  |  |  |  |  |  | apple | 35
 |  |  | peach | 5 |  |  |  |  |  |  | apricot | 24
 |  |  | mangoes | -2 |  |  |  |  |  |  | peach | 5
 |  |  | watermelons | 1 |  |  |  |  |  |  | watermelons | 1
 |  |  | apricot | 22 |  |  |  |  |  |  | mangoes | -2
 |  |  | cherry | -17 |  |  |  |  |  |  | cherry | -37
 |  |  | banana | 5
 |  |  | [NAME] | 10
 |  |  | apricot | 2
 |  |  | cherry | -20
Spreadsheet: 746345d1630654572-identify-weeks-in-rolling-12-month-calculations-bo-backtesting-1-ans2
Sheet: RESULTS

 | ANNUALIZED GAIN |  |  |  |  |  |  |  |  |  |  |  |  |  | MARKET CAP |  | Min 10 results per section
 |  |  |  |  | Price | Shares | ATI |  |  |  |  |  |  |  | FLOAT |  | Average results
 | Position size for price < |  |  |  | 10 | 1000
 | Position size for price < > |  |  |  |  | 500 |  |  |  |  |  |  |  |  | TRADES | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Position size for price > |  |  |  | 30 | 200 |  |  |  |  |  |  |  |  | < 100M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 | Multiplier for PM Consolidation setups = |  |  | 1.5 |  |  |  |  |  |  |  |  |  |  | 500M-1B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | NOTES
 |  |  |  |  |  |  |  |  | Year |  |  |  |  |  | ENTRY | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Enter only on 1 of 7 setups |  |  |  |  |  |  |  | WEEKLY |  |  |  |  |  | < 100M
 | Entry is within 10c of identified entry level |  |  |  |  |  |  |  | YEAR & WEEK | TRADES | WIN % | G/L | Entry % |  | 100-500M
 | [NAME] stop loss for price < 30.00 is 30c |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | [NAME] stop loss for price > 30.00 is 50c |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | Exit for BO trades is 5x20, over 10 point gain, or BE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WIN % | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 | GAIN/LOSS |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 |  | All | Last 5 Wk | > 1 pt | > 2 pt | > 3 pt | > 4 pt |  |  |  |  |  |  |  | 500M-1B
 | Win/Loss % |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | Days
 | Trades |  |  |  |  |  |  |  |  |  |  |  |  |  | G/L | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Wins |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 | Gain /s (Net) |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 | % Gain /s (Net) |  |  |  |  |  |  |  | All formulas in Table2 are modified |  |  |  |  |  | 500M-1B
 | Gain /s (Wk Ave) |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | Entry Success %
 | SETUP
 |  | Count |  | Win % | Last 5 Wk | G/L | Entry %
 | PMH
 | PM Consolidation
 | Pivot
 | Consolidation
 | HOD
 | R2G
 | Daily Resistance
 | MAX GAIN
 |  | Ave | Mean 20%
 | Entry-High
 | High-Exit
 |  |  |  | > 1 pt | > 2 pt | > 3 pt | > 4 pt
 | Trades
 | % of All
 | ENTRY TIMES (WINNING TRADES)
 |  | Trades |  | Ave
 | 8:00-8:59
 | 9:00-9:29
 | 9:30-9:49
 | 9:50-10:29
 | 10:30-11:29
 | 11:30-14:59
Spreadsheet: 3a2e1603-998a-44e6-9c89-9184f2b6b301
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
8761 | 46796 | Polina | [NAME] | RUS | 134 | 00:23:55 | 00:00:36 | 00:43:01 | 00:02:12 | 00:22:35 | 1 | 01:32:20
8761 | 45993 | Nadia | [NAME] | ITA | 135 | 00:23:44 | 00:00:58 | 00:52:44 | 00:02:27 | 00:23:56 | 2 | 01:43:50
Spreadsheet: 848127d1698925559-formula-to-adjust-daily-sales-target-required-example
Sheet: Sheet1

MONTH | TARGET | 2024 Monthly total | Daily Target | Adjsuted Daily Target?
NOVEMBER | 22 | 10
DECEMBER | 15 | 0
JANUARY | 21 | 0
FEBRUARY | 21 | 0
[NAME] | 21 | 0
APRIL | 22 | 0
MAY | 23 | 0
[NAME] | 20 | 0
JULY | 23 | 0
AUGUST | 22 | 0
SEPTEMBER | 21 | 0
OCTOBER | 22 | 0
Yearly Target Total
2024 Grand Total
Remaining Total to reach
Spreadsheet: 846067d1697364900-trying-to-consolidate-data-for-upload-example-problem
Sheet: Sheet1

Name | UPRN | Address | Crew | Day | Product | Postcode
Star | 1010101 | XYZ | [NAME] | Monday | General Waste | -
[NAME] | 1010101 | XYZ | Garry | Monday | General Waste | -
Planet | 1010101 | XYZ | Smith | Monday | General Waste | -
Space | 1010101 | XYZ | [NAME] | Tuesday | General Waste | -
Sun | 1010101 | XYZ | [NAME] | Tuesday | General Waste | -
Luna | 1010101 | XYZ | Derek | Wednesday | Recycling | -
Station | 1010101 | XYZ | [NAME] | Wednesday | Recycling | -
Ship | 1010101 | XYZ | [NAME] | Thursday | Recycling | -
Meteor | 1010101 | XYZ | [NAME] | Thursday | Recycling | -
Rock | 1010101 | XYZ | [NAME] | Friday | Recycling | -