tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 678722d1590039669-formula-needed-for-expiry-date-book1-1-
Sheet: Sheet1

WHAT IT LOOKS LIKE NOW |  |  |  |  | WHAT I WANT IT TO LOOK LIKE
Annual appraisal |  |  |  |  | Annual appraisal |  |  | Here you can give the required date | 2020-01-01 00:00:00
Complete | Date |  |  |  | Complete | Date
1 | 2020-02-06 00:00:00 |  |  |  | 1 | 2020-02-06 00:00:00
1 | 2019-09-17 00:00:00 |  |  |  | 1 | 2019-09-17 00:00:00
1 | 2019-09-15 00:00:00 |  |  |  | 1 | 2019-09-15 00:00:00
1 | 2017-09-06 00:00:00 |  |  |  | 1 | 2017-09-06 00:00:00
1 | 2019-05-14 00:00:00 |  |  |  | 1 | 2019-05-14 00:00:00
1 | 2017-09-01 00:00:00 |  |  |  | 1 | 2017-09-01 00:00:00
1 | 2017-06-28 00:00:00 |  |  |  | 1 | 2017-06-28 00:00:00
1 | 2019-09-26 00:00:00 |  |  |  | 1 | 2019-09-26 00:00:00
1 | 2019-09-06 00:00:00 |  |  |  | 1 | 2019-09-06 00:00:00
Spreadsheet: 99234d1297943733-why-doesnt-this-vlookup-work-test
Sheet: Interest Static

Unit | PU | Balance of unit 1 | Balance of unit 2 |  | Difference |  | Adjustment V1 | Adjustment V2 | Value 1 | Value 2 |  | [NAME] |  | >200k | Interest | Quarterly interest | Posting to self?
1100 | 2006 | 5 | -5 |  | 0 |  |  |  | 5 | -5 |  | No |  |  | 5 | 1.25 | No
1130 | 2006 | 6 | -6 |  | 0 |  |  |  | 6 | -6 |  | No |  |  | 6 | 1.5 | No
Spreadsheet: b5447809-84ae-48cc-a658-d325b196b450
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Bilverksteder
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Autosalg AS | [NAME]. 58 | 5072 | Bergen | 55 36 10 00 | 55 36 10 01
Sandberg Auto AS | Løxav. 5 | 1351 | Rud | 67 17 22 00 | 67 17 22 01
Alfa Bilverksted AS | Tornerosev. 3 | 4315 | Sandnes | 51 63 05 33
[NAME] avd Årnes | [NAME]. 15A | 2150 | Årnes | 63 90 06 20 | 63 90 06 21
Skattøra Bil & Lakk AS | Ringv. 17 | 9018 | Tromsø | 77 60 62 10 | 77 60 62 11
Florø Bil & Havneservice AS | Strandav. 19 | 6900 | Florø | 57 74 05 30 | 57 74 05 31
Bjørn Myhrens Verksted AS |  | 7250 | Melandsjø | 72 44 49 30 | 72 44 49 31
Toyota Follo AS | Industriv. 1A | 1400 | Ski | 64 91 78 00
Ernstsen MC & Scooter AS | Lagerv. 7 | 8250 | [NAME] | 75 69 19 11
[NAME] | [NAME]. 4 | 7670 | Inderøy | 74 15 60 60 | 74 15 60 61
Tau Auto AS | Ryfylkev. 1970 | 4120 | Tau | 51 74 65 90
[NAME] | Skjoldastraumsv. 1150 | 5567 | Skjoldastraumen | 52 77 91 93
Automiljø AS | Ånev. 7 | 4580 | Lyngdal | 38 34 34 01 | 38 34 34 88
Nye Folla Auto AS |  | 7985 | [NAME] | 74 39 61 59 | 74 39 61 54
Otters Biloppretting Otter Ødegården | Semsv. 41B | 3676 | Notodden | 35 01 35 00
Lunde H Autoverksted |  | 2266 | [NAME] | 62 95 32 83 | 62 95 32 83
Mekonomen | Fjukv. 7 | 1925 | Blaker | 63 82 19 96
BilXtra verksted (Storo Bil AS) | Vitaminv. 6 | 0485 | Oslo | 21 39 56 35
Helgerud Bilverksted |  | 1963 | [NAME] | 63 85 50 66 | 63 85 55 32
Brabil AS | Synnalandsv. 22 | 6270 | Brattvåg | 70 20 80 20 | 70 20 80 37
Økern Karosseri AS | Solheimv. 62 | 1473 | Lørenskog | 67 90 20 30
Bilskade & Lakk AS | Verkseier Furulunds v 17 | 0668 | Oslo | 22 90 51 80 | 22 90 51 81
Østbyen Bil & Karosseri AS | Brusdalsv. 244 | 6011 | Ålesund | 70 16 94 00 | 70 16 93 99
[NAME] | Bjørumsv. 16 | 4820 | Froland | 37 03 70 30
[NAME] | Lerkev. 50 | 2209 | Kongsvinger | 954 34 013 | 62 82 65 28
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 727561d1617964276-data-reference-based-on-variable-dates-example
Sheet: Data

Metric | Month / Year | Tickets logged | Tickets Resolved | % resolution
Metric 1 | 2021-03-01 00:00:00 | 85 | 80
Metric 2 | 2021-03-01 00:00:00 | 98 | 80
Metric 3 | 2021-03-01 00:00:00 | 98 | 25
Spreadsheet: 138650d1327785493-double-criteria-search-exact-match-on-first-but-closest-match-on-second-double-example
Sheet: Sheet1

Item | Cost | Return Value
Car | 100 | A |  | Car | 350
Car | 200 | B
Car | 300 | C
Bus | 100 | D
Bus | 200 | E
Bus | 300 | F
Train | 100 | G
Train | 200 | H
Train | 300 | I
Spreadsheet: 45836d1244630298-matching-criteria-from-table-sample-query-
Sheet: Sheet1

a
 | groups
stud1 | a
stud2 |  | b
stud3 |  | b | c
stud4 |  | b | c
stud5 | a |  | c
stud6
stud7
[NAME]
stud9
stud10 | a | b | c
stud11 |  |  | c
stud12 |  |  | c
stud13
stud14 |  | b | c
stud15 | a
stud16
stud17 |  |  | c
stud18 | a | b | c
stud19
stud20 |  |  | c
List of names below
Spreadsheet: 865484d1712573114-calculating-a-rebate-scheme-using-different-ranges-rebate-test
Sheet: Sheet1

 |  | £0 - £499,999 |  | £500,000 - £999,999 |  | £1,000,000 - 1,999,999 |  | £2,000,000 - £3,999,999 |  | £4,000,000 +
 |  | 499999 |  | 999999 |  | 1999999 |  | 3999999 |  | 4000000
Brexons Turnover Todate |  | [NAME] on Annual Spend |  |  |  |  |  |  |  |  |  | Rebate based on proposed percentages.
Year September - August | Turnover | 0.015 |  | 0.025 |  | 0.035 |  | 0.045 |  | 0.06
 |  | Tier Spend | [NAME] | Tier Spend | [NAME] | Tier Spend | [NAME] | Tier Spend | [NAME] | Tier Spend | [NAME]
Quarter 1 2024 | 0
Quarter 2 2024 | 2500000 | 499999 |  | 500000 |  | 1000000 |  | 500001 |  | 0
Spreadsheet: 729110d1618916124-how-to-deal-with-empty-cells-errors-norealnames
Sheet: PS-Output

Should look something like: | But for ever class | Also should work with classes smaller / bigger than 30
1A
$group New-Team -DisplayName "Klasse 1A" -Description "Klasse 1A" -Template “EDU_Class” -Owner "[EMAIL]" -"MailNickName [EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Add-TeamUser -GroupId $group.[NAME] -User "[EMAIL]"
Spreadsheet: jeff_dasovich__14105__Response to 10-12 Workshop Questions
Sheet: Q11-12

QUESTION 11
Q. How would the allocation of Local Transmission costs to core and noncore customers
change if it were based on some allocation other than Cold Year Winter January?
A. |  | Core | Noncore | Total | Core | Noncore
 |  |  |  |  | Percentage
 |  | Marginal Cost Revenues(1) |  |  | Allocation
GAS ACCORD I - Local Transmission Allocation |  | 141186 | 109584 | 250770 | 0.563 | 0.437
CURRENT ALLOCATORS (2) |  | Annual Average (MDth)
COLD YEAR-BASED
 | Cold Year Coincident Peak Month (January) (3) | 52370.9055 | 38460.6182639037 | 90831.52376390371
 | Cold Year - Annual | 334333.618 | 473572.019852158 | 807905.6378521579
 | Cold Year Winter Season (Nov-March) | 204644.695 | 188006.6108006949 | 392651.305800695
AVERAGE YEAR-BASED
 | Average Year (Equal cents per therm) | 306051.19 | 472944.1692186411 | 778995.3592186412
 | Average Year Winter Season (Nov-March) | 184586.404 | 187564.499006998 | 372150.903006998
 | Average Year January | 48024.0975 | 38395.7161781226 | 86419.8136781226
 | Cold Winter Day (in Average Year) | 2065.0361925 | 1577.376821403465 | 3642.413013903465
OTHER ALLOCATORS:
1 in 4 COLD WINTER DAY (38 degrees) (4)
(1) Scaled equalized 2 year marginal cost revenues used to allocate local transmission costs, consistent
 | with 1995 BCAP Decision (D. 95-12-053).
(2) Marginal demand measures based on 2000 BCAP Settlement Agreement
(3) Currently adopted method of allocating local transmission marginal cost revenues.
(4) Based on data presented at September 27, 2000, Reliability Workshop
QUESTION 12
Q. What are the detailed changes in O&M and A&G costs from 1999 to 2003?
What plant additions and retirements are forecast for 1999 to 2003?
A.  PG&E is working to complete the detailed cost of service and its supporting information
and will provide parties with this information as soon as it is available.
Spreadsheet: 836965d1689760917-help-in-pivot-table-filtering-pivot_filter
Sheet: Sheet1

Type | Doc. | Set 1 | Set 2
EF | ZNB | 9101 | 1001 |  |  |  | Type | EF |  |  |  |  |  |  |  | EF | ZNB
EF | ZNB | 9101 | 1001 |  |  |  | Doc | ZNB |  |  |  |  |  |  |  | EV | NB
EF | ZNB | 9101 | 1001
EF | ZNB | 1000 | 1010
EF | ZNB | 1000 | 1010 |  |  |  |  | Set 2
EF | ZNB | 1001 | 1010 |  |  |  | 9101 | 1001
EF | ZNB | 1001 | 1010 |  |  |  | 1000 | 1010
EF | ZNB | 1001 | 1010 |  |  |  | 1001 | 1010
EF | ZNB | 1002 | 1010 |  |  |  | 1002 | 1010
EF | NB | 9201 | 2001
EF | NB | 9201 | 2001
EF | NB | 9201 | 2001
EF | NB | 9201 | 2001
EF | NB | 9201 | 2001
EF | NB | 9201 | 2001
EV | UB | 1000 | 1010
EV | UB | 1001 | 1010
EV | UB | 1001 | 1010
Spreadsheet: 215005d1361223356-furmula-that-searches-for-a-text-value-in-a-specific-heet-then-calls-a-corresponding-cell-example-sheet
Sheet: Cost of Goods Sold

 |  |  |  | Cost of Goods Sold
 |  |  |  | February
Item Line # | Company | Code | Account # | Invoice # | Visibility | Status | Categories | Action |  |  |  |  |  |  |  |  |  |  |  | Amount Due | Amount Paid | Due Date | Paid from or Deposited to Account #
1 | AlphaGraphics | ProdM | - | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 148.32 | 148.32 | 2013-02-18 00:00:00 | DDA
2 | Northwest Shipping | PackM | - | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39.42 | 39.42 | 2013-02-07 00:00:00 | DDA
3 | Wasatch | ProdM | - | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1050 | 1050 | 2/31/13 | DDA
4 | UPS | ShipE | - | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 24 | 2013-02-02 00:00:00 | DDA
5 | UPS | ShipE | - | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 322.66 | 322.66 | 2013-02-04 00:00:00 | DDA
6 | [NAME] | ProdM | - | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.4 | 7.4 | 2013-02-09 00:00:00 | DDA
7 | Safeway | ProdD | - | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.37 | 4.37 | 2013-02-09 00:00:00 | DDA
8 | UPS | ShipE | - | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 96.52 | 96.52 | 2013-02-09 00:00:00 | DDA
9 | [NAME] | ProdM | - | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67.9 | 67.9 | 2013-02-08 00:00:00 | DDA
10 | Uline | ProdM | - | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 213.63 |  | 2013-02-08 00:00:00
11
12
13
14
15
16
17
18
19
20
21 |  | Cost of Goods Sold |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
22 |  | Feathers |  | FTHS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
23 |  | Packaging Materials |  | PackM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
24 |  | Product Materials |  | ProdM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
25 |  | Shipping Expenses |  | ShipE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
26 |  | Research and Development |  | R&D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
27 |  | Shipping Expenses |  | ShipE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 849021d1699585672-sales-forecasting-template-franztupaz-data-sample
Sheet: Original

 |  |  |  |  |  |  | WEIGHTED DISTRIBUTION FORECAST IN UNITS
ACCNT # | NAME | CODE | BRANCH | ANNUAL FORECAST | DATE OF SELL IN | MO. CONVERSION | JANUARY | FEBRUARY | [NAME] | APRIL | MAY | [NAME] | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER | TOTAL
12345 | DEALER A | AAAAA | ABC MARKETING | 1000 | 2024-03-01 00:00:00
12346 | DEALER B | BBBBBB | ABCD MARKETING | 2000 | 2024-04-01 00:00:00
12347 | DEALER C | CCCCCC | ABCDE MARKETING | 3000 | 2024-04-01 00:00:00
Spreadsheet: 20f8cb87-d9aa-42aa-aa45-09ef2cdc5cf6
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
[NAME] | Test | [NAME] | Thyroglobulin, [NAME], Fine-Needle Aspiration (FNA)-Needle [NAME], [NAME] | Thyroglobulin, FNA, [NAME] | Immunoenzymatic Assay |  |  |  | 1.5 | mL | Container/Tube: Sterile vial  Collection Instructions: After collection of the cytology specimens and expulsion of the material for smear or CytoTrap processing: 1. Wash/rinse each FNA needle from a single lymph node nodule with 0.1 to 0.5 mL of normal saline. 2. Pool each wash from a single lymph node nodule into 1 vial. If more than 1 nodule is biopsied, each nodule biopsy should be submitted as a separate specimen. 3. Inspect the specimen as follows: a. If the specimen shows visible blood or tissue contamination, centrifuge the specimen. Transfer the supernatant to a new plastic vial. Freeze specimen. b. If specimen is clear, freeze specimen in plastic vial. Additional Information: If multiple lymph node testing is needed, submit each under a separate order. Clearly identify each specimen. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.5 mL | Hemolysis	NA Thawing	Cold OK; [NAME] Lipemia	NA Icterus	NA Other	NA | < or =1.0 ng/mL This cutoff has been validated for total needle wash volumes of < or =1.5 mL of normal saline. If wash volumes are substantially larger, a lower cutoff might apply. | Monday through Friday; 5 a.m.-12 a.m., Saturday; 6 a.m.-6 p.m. | Same day/1 day | 3 days | 1 | 84432 |  |  |  |  | Rochester
[NAME] | [NAME] | FNWASH | Fine Needle Wash |  |  |  | Frozen | 7 days
[NAME] | Result | TGFN | Thyroglobulin, FNA, [NAME] | Thyroglobulin, FNA, [NAME] | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 53920-5
[NAME] | Result | [NAME] | Site | Site | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39111-0
Spreadsheet: 835470d1688608802-looking-to-count-months-dependent-of-factors-in-other-cells-2023-log
Sheet: Totals

Number of Files Received
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
EA
IA
LoGS Ext.
RM
SM
SM / IA
Totals
Number of Files Processed
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
EA
IA
LoGS Ext.
RM
SM
SM / IA
Totals
Spreadsheet: 2a1eb375-0ee4-43a9-8e4a-28bbb93b2c5e
Sheet: 7.1 Personnel Demographics

Institution
Indicator 7: Personnel Demographics, Professional Development, Research, and Outcomes
Table 7.1: Personnel Demographics / AY 2011-12
Please note that an individual should only be counted once in the following four tables.
Number of Individuals Who Are Faculty Only |  |  | AY 2011-12
 | American Indian |  | Non-Indian |  | Total
 | M | F | M | F
Full Time Faculty | 14 | 16 | 18 | 21
Part Time/Adjunct Faculty | 13 | 31 | 15 | 37
Visiting Faculty | 0 | 0 | 0 | 0
Total Headcount
Number of Individuals Who Are Administrators Only |  |  | AY 2011-12
 | American Indian |  | Non-Indian |  | Total
 | M | F | M | F
Full Time | 2 | 15 | 1 | 2
Part Time | 0 | 0 | 0 | 0
Total Headcount
Number of Individuals Who Are Staff Only |  |  | AY 2011-12
 | American Indian |  | Non-Indian |  | Total
 | M | F | M | F
Full Time | 17 | 68 | 4 | 9
Part Time | 29 | 27 | 6 | 4
Total Headcount
Number of Individuals Who Are Both Faculty and Administrators/Staff |  |  | AY 2011-12
 | American Indian |  | Non-Indian |  | Total
 | M | F | M | F
Full Time | 0 | 0 | 0 | 0
Part Time / Adjunct | 0 | 0 | 0 | 0
Visiting | 0 | 0 | 0 | 0
Total Headcount
We do not have employees that combine three functions.
Spreadsheet: 103701d1301433052-formula-to-extrapolate-dates-dates1
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Start | Price
2011-03-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 3 | 107.5
2011-04-01 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 4 | 120
2011-05-01 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 5 | 105
2011-06-01 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 6 | 103
2011-07-01 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 7 | 101
2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 4 | 103
2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 7 | 100
2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 10 | 108
2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 1 | 105.3
2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 1 | 102
Spreadsheet: 275542d1383569406-if-function-or-alternative-if-function-further-nesting
Sheet: Calculations

 |  |  |  |  |  | Calculations |  |  |  | Pension One
 |  |  |  | Year | Age | RPI | Stage of Employment | Employed | Stage - State Pension qualification | Pension One Stage | Defered Income
 | General [NAME]
 | Start Year | 2013 |  |  |  | 1
 | Summary and Plots in current £ | 0 | 1 = Yes, 0 = No
 | Client Name | Anon
 | Current Age | 57
 | Age Pension to be taken | 60
 | State Pension Age | 66
 | Spouse and/or eligible dependants | 0 | 1 = Yes, 0 = No
 | Life Expectancy | 80
 | Inflation & Returns
 | RPI (Inflation) | 0.03
 | Salary Growth | 0.02
 | DC Pension investment return | 0.05
 | TFC investment return | 0.05
 | Income, Tax & Pension contributions
 | Income from work | 25000
 | Tax code now | 0
 | Total pension contribution pa | 0
 | Pension One
 | CETV Total | 460463
 | Estimated Income Now/or earliest allowable retirement Age
 | Deferred Benefits payable from age selected | 17260
 | Deferred Benefits payable after State Pension Age | 15215
 | Revaluation Rates before income taken: | 0.03
 | Increases after income taken | 0.01
Spreadsheet: 35597d1233183327-conditional-counting-in-excel-2003-sumproduct
Sheet: Sheet1

 |  | abc | y | abc | 2
 |  | bcd | y | bcd | 1
 |  | abc | n | dfg | 0
 |  | dfg | n | cdf | 0
 |  | dfv | y
 |  | cdf | n
 |  | abc | y
Spreadsheet: 152895d1335571190-excel-2007-conditional-formatting-by-row-and-column-numerical-labels-format-table-diagonals-bvj-
Sheet: Sheet1

 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | 1 | 1219 | 0.5 | 0.476 | 0.375 | 0.24 | 0.241 | 0.426 | 0.317 | 0.641 | 0.529 | 0.398
 | 2 | 1236 | 0.524 | 0.5 | 0.398 | 0.259 | 0.26 | 0.45 | 0.339 | 0.664 | 0.553 | 0.422
 | 3 | 1308 | 0.625 | 0.602 | 0.5 | 0.345 | 0.347 | 0.553 | 0.437 | 0.749 | 0.652 | 0.524
 | 4 | 1419 | 0.76 | 0.741 | 0.655 | 0.5 | 0.501 | 0.701 | 0.595 | 0.85 | 0.78 | 0.676
 | 5 | 1418 | 0.759 | 0.74 | 0.653 | 0.499 | 0.5 | 0.7 | 0.594 | 0.849 | 0.779 | 0.675
 | 6 | 1271 | 0.574 | 0.55 | 0.447 | 0.299 | 0.3 | 0.5 | 0.385 | 0.707 | 0.602 | 0.471
 | 7 | 1352 | 0.683 | 0.661 | 0.563 | 0.405 | 0.406 | 0.615 | 0.5 | 0.794 | 0.707 | 0.587
 | 8 | 1118 | 0.359 | 0.336 | 0.251 | 0.15 | 0.151 | 0.293 | 0.206 | 0.5 | 0.385 | 0.27
 | 9 | 1199 | 0.471 | 0.447 | 0.348 | 0.22 | 0.221 | 0.398 | 0.293 | 0.615 | 0.5 | 0.371
 | 10 | 1291 | 0.602 | 0.578 | 0.476 | 0.324 | 0.325 | 0.529 | 0.413 | 0.73 | 0.629 | 0.5
Spreadsheet: 695510d1600255769-section-wise-summarize-the-data-into-one-sheet-from-other-work-sheets-summarize-the-data-into-one-sheet-from-multiple-work-sheets
Sheet: 01.09.20

Ref | Description | Total | Total Consumed Hrs
Number | Under Section | Qty | Man Power | Machinery
 | Section-A
1212 | Fiiling | 10 | 22 | 22
1315 | Excavation | 12 | 11 | 41
 | Section-B
2510 | Trimming | 15 | 25 | 20
2456 | Laying | 14 | 21 | 21
 | Section-C
2141 | Cutting | 12 | 14.5 | 41
1236 | Snags | 14 | 15 | 30
Spreadsheet: 785620d1656515623-auto-calculate-workdays-for-table-monthly-referral-tracking-sheet-adjusting
Sheet: August

2022-08-01 00:00:00 |  |  |  |  |  | Monthly Admission Goal: | 0
 |  |  |  |  |  | Month's Working Days:
 |  |  |  |  |  | Daily Referral Goal:
 |  |  |  |  |  | Referrals Still Needed to Meet Goal:
 | Mon | Tue | Wed | Thu | Fri | Actual Referrals/Week | Weekly Referral Goal
Week 1 | 0 | 0 | 0 | 0 | 0
Week 2 | 0 | 0 | 0 | 0 | 0
Week 3 | 0 | 0 | 0 | 0 | 0
Week 4 | 0 | 0 | 0 | 0 | 0
Week 5 | 0 | 0 | 0
 |  |  |  |  | TOTAL:
Spreadsheet: 93962d1293723174-counting-days-in-a-different-manner-sum-of-data-back-into-monthly-ws
Sheet: JANUARY

 | JANUARY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRESENCE | ABSENCES COUNTED AS PRESENCE |  |  |  |  |  | TOTAL
 | NAME | DATE OF ENTRY | DATE OF LEAVING | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 2010-01-07 00:00:00 | 2010-01-08 00:00:00 | 2010-01-09 00:00:00 | 2010-01-10 00:00:00 | 2010-01-11 00:00:00 | 2010-01-12 00:00:00 | 2010-01-13 00:00:00 | 2010-01-14 00:00:00 | 2010-01-15 00:00:00 | 2010-01-16 00:00:00 | 2010-01-17 00:00:00 | 2010-01-18 00:00:00 | 2010-01-19 00:00:00 | 2010-01-20 00:00:00 | 2010-01-21 00:00:00 | 2010-01-22 00:00:00 | 2010-01-23 00:00:00 | 2010-01-24 00:00:00 | 2010-01-25 00:00:00 | 2010-01-26 00:00:00 | 2010-01-27 00:00:00 | 2010-01-28 00:00:00 | 2010-01-29 00:00:00 | 2010-01-30 00:00:00 | 2010-01-31 00:00:00 |  | F | V | C | H | U | R
1 | PERSON1 | 2009-10-31 00:00:00 |  | F | F | F |  | V | V | V | V | V | V | V |  |  |  |  | F | F |  |  |  |  |  | F |  |  |  |  |  |  | F |  | 17.5 | 6.5 | 7 |  |  |  |  | 31
2 | PERSON2 | 2009-06-16 00:00:00 | 2010-10-12 00:00:00 | F | F | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H
3 | PERSON3 | 2008-11-24 00:00:00 |  | F | F | F |  |  |  |  |  | F | F |  |  |  |  |  | F | F |  |  |  |  |  | F |  |  |  |  |  |  | F
4 | PERSON4 | 2009-06-05 00:00:00 |  | F | F | F |  |  |  |  |  | F | F |  |  |  |  |  | F | F |  |  |  |  |  | F |  |  |  |  |  |  | F
5 | PERSON5 | 2007-05-12 00:00:00 | 2010-11-04 00:00:00 | F | F | F |  |  |  |  |  |  |  |  |  |  |  |  |  | F |  |  |  |  |  |  | F
6 | [NAME] | 2006-01-18 00:00:00 | 2010-03-03 00:00:00 | F | F | F |  |  |  |  |  |  |  |  |  |  |  |  | F | F |  |  |  |  |  | F | F
7 | PERSON7 | 2009-03-23 00:00:00 | 2010-03-03 00:00:00 | F | F | F |  |  |  |  |  | F | F |  |  |  |  |  | F | F |  |  |  |  |  | F | F |  |  |  |  |  | F
8 | PERSON8 | 2009-05-19 00:00:00 | 2010-04-20 00:00:00 | F | F | F |  |  |  |  |  | F | F |  |  |  |  |  | F |  |  |  |  |  |  | F
9 | PERSON9 | 2010-03-03 00:00:00
10 | PERSON10 | 2010-03-03 00:00:00
11 | PERSON11 | 2010-04-22 00:00:00
12 | PERSON12 | 2010-10-22 00:00:00
13 | PERSON13 | 2010-11-23 00:00:00
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.5 | 6.5 | 7 | 0 |  | 0 | 0 | 31 | 31