tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 244680a2-c212-4e0a-bdf5-7a615ee35a0e
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Döbeln, Stadt - Variante 1
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 2934 | 3076 | 3030 | 2853
20 - 25 | 1144 | 695 | 778 | 815
25 - 35 | 2547 | 2375 | 1816 | 1447
35 - 55 | 5807 | 5370 | 4759 | 4426
55 - 67 | 3531 | 3840 | 3812 | 3662
67 und mehr | 5114 | 4961 | 5271 | 5388
Insgesamt | 21077 | 20317 | 19466 | 18591
%
unter 20 | 13.92038715187171 | 15.14003051631639 | 15.56560156169732 | 15.34613522672261
20 - 25 | 5.427717417089719 | 3.420780627061082 | 3.996712216171787 | 4.383841643806143
25 - 35 | 12.08426246619538 | 11.68971797017276 | 9.329086612555225 | 7.783336022806735
35 - 55 | 27.55135930160839 | 26.43106757887483 | 24.4477550601048 | 23.80721854660857
55 - 67 | 16.75285856620961 | 18.9004282128267 | 19.58286242679544 | 19.69770318971545
67 und mehr | 24.26341509702519 | 24.41797509474824 | 27.07798212267543 | 28.98176537034049
Insgesamt | 100 | 100 | 100 | 100
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 66a5dbe8-c1e3-49cb-97ec-761c2e81e5c4
Sheet: Sheet1

DRE Ano Fiscal, [NAME] (IFRS) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
Milhões | 4T08 | 1T09 | 2T09 | 3T09 | 4T09 | 1T10 | 2T10 | 3T10 | 4T10 | 1T11 | 2T11 | 3T11 | 4T11 | 1T12 | 2T12 | 3T12 | 4T12 | 1T13
Receita de Venda de Bens e/ou Serviços | 3576.201 | 833.652 | 1867.918 | 2922.808 | 4242.057 | 0 | 2298.009 | 3579.222 | 5136.712 | 0 | 2539.463 | 3920.896 | 5591.374 | 0 | 2884.117 | 4470.651 | 6345.669 | 0
Custo dos Bens e/ou Serviços Vendidos | -1113.237 | -261.577 | -563.366 | -877.563 | -1294.565 | 0 | -711.795 | -1076.198 | -1556.806 | 0 | -756.266 | -1169.931 | -1666.3 | 0 | -836.643 | -1291.652 | -1868.045 | 0
Resultado Bruto | 2462.964 | 572.075 | 1304.552 | 2045.245 | 2947.492 | 0 | 1586.214 | 2503.024 | 3579.906 | 0 | 1783.197 | 2750.965 | 3925.074 | 0 | 2047.474 | 3178.999 | 4477.624 | 0
Despesas/Receitas Operacionais | -1692.829 | -400.558 | -925.102 | -1430.849 | -2031.464 | 0 | -1059.913 | -1669.467 | -2412 | 0 | -1242.718 | -1905.344 | -2610.004 | 0 | -1451.845 | -2233.759 | -3108.074 | 0
Despesas com Vendas | -1259.333 | -296.22 | -661.332 | -679.328 | -1496.125 | 0 | -762.598 | -1203.562 | -1704.322 | 0 | -909.293 | -1409.63 | -1952.74 | 0 | -1038.852 | -1574.114 | -2212.205 | 0
Despesas Gerais e Administrativas | -461.85 | -111.077 | -251.544 | -726.117 | -520.715 | 0 | -284.161 | -451.797 | -690.21 | 0 | -350.217 | -516.724 | -720.341 | 0 | -411.358 | -648.512 | -884.226 | 0
Outras Receitas Operacionais | 28.354 | 0 | 0.581 | 5.419 | 0 | 0 | 0 | 0 | 0 | 0 | 16.792 | 21.01 | 63.077 | 0 | 0 | 0 | 0 | 0
Outras [NAME] | 0 | -0.116 | 0 | 0 | -14.624 | 0 | -13.154 | -14.108 | -17.468 | 0 | 0 | 0 | 0 | 0 | -1.635 | -11.133 | -11.643 | 0
Resultado de Equivalência Patrimonial | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Lucro/Prejuízo do Período | 517.857 | 138.747 | 306.971 | 497.056 | 683.924 | 0 | 333.052 | 524.749 | 744.05 | 0 | 338.611 | 540.194 | 830.901 | 0 | 366.564 | 603.887 | 861.222 | 0
Spreadsheet: 753020d1635184849-date-functions-for-years-of-service-cumulative-years-and-months-pjfox-
Sheet: For Excel HELP 

 | Last Name | First Name | Preferred Name | Job Title Description | Hire/Rehire Date | Cumulative                           Years of Service                      (update each October) | Years of Service for Current Position (formula used) | End Date of Previous Service | New Calculated Future Anniversary Date | Next Award                                     (Award, Date) | Last Awarded                                                                          (Award, Date) | Notes
 |  |  |  |  |  |  |  |  | Years | Months | Mnths to yrs | Remaining Mnths
 |  |  |  |  | 1985-09-01 00:00:00 |  |  | 2000-06-30 00:00:00
 |  |  |  |  | 2008-07-01 00:00:00 |  |  | 2015-06-30 00:00:00
 |  |  |  |  | 2016-08-01 00:00:00
Spreadsheet: 858620d1707241458-sum-hours-based-on-date-range-and-id-and-then-summarize-on-a-separate-tab-eot-06-feb
Sheet: COSTA

Name | ID |  |  |  |  | CHARGE MONTH: |  |  |  | PAYROLL WORKSHEET
COSTA |  |  |  |  |  |  |  |  |  | Schedule: | Weekly |  |  | Mo. [NAME]: |  |  |  | Hrly [NAME].: |  |  |  | Position: | Officer
 |  |  |  |  |  |  |  |  |  | Shift: | Grave |  |  | Stipends/UA |  |  |  | Bi-Wk Equiv.: |  |  |  | Union: | R08
LEAVE USAGE
TYPE | V | S | SF | CTO | HC | IH | PH |  |  |  |  |  | Hours Worked
DATE |  |  |  |  |  |  |  |  |  | Period # | Start | End | Regular | Holiday | Overtime | CTO | Total | Swing | S Due | Grave | G Due | Total Comp | OT Rate
 |  |  |  |  |  |  |  |  |  | 1 | 2023-10-22 00:00:00 | 2023-11-04 00:00:00 | 80
 |  |  |  |  |  |  |  |  |  | 2 | 2023-11-05 00:00:00 | 2023-11-18 00:00:00 | 80
 |  |  |  |  |  |  |  |  |  | 3 | 2023-11-19 00:00:00 | 2023-12-02 00:00:00 | 80
 |  | NO TIME TAKEN |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | Total All OT Worked:
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | OT Reported by Dept:
 |  |  |  |  |  |  |  |  |  |  |  |  | Less Holiday RDO:
OVERTIME AUTHORIZED
REASON | DATE | FROM | TO | HOURS | EARN ID | PAY CODE | SWING | GRAVE |  |  |  |  |  | Difference:
FOOTBALL VS BOISE | 2023-11-04 00:00:00 | 1500 | 2330 | 8.5 | OTPR | 871-425P |  | 1.5
BOARD OF TRUSTEE MEETINGS | 2023-11-06 00:00:00 | 900 | 1330 | 4.5 | OTPR | 213-425P
BOARD OF TRUSTEE MEETINGS | 2023-11-07 00:00:00 | 700 | 2000 | 13 | OTPR | 213-425P |  |  |  |  |  |  | 0 | COSTA | 8.5 | 45234 | OTPR
BOARD OF TRUSTEE MEETINGS | 2023-11-08 00:00:00 | 700 | 1700 | 10 | OTPR | 213-425P |  |  |  |  |  | 66666 | 0 | COSTA | 12 | 45248 | HG6
VETERANS DAY - REG SHIFT | 2023-11-10 00:00:00 |  |  | 12 | HG6 | 213-425HP |  |  |  |  |  | 66666 | 0 | COSTA | 35.3 | 45248 | OTPR
FOOTBALL VS NEW MEXICO | 2023-11-18 00:00:00 | 1600 | 2345 | 7.8 | OTPR | 871-425P |  | 1.75 |  |  |  | 66666 | 0 | COSTA | 12 | 45262 | HG6
THANKSGIVING DAY - REG SHIFT | 2023-11-23 00:00:00 |  |  | 12 | HG6 | 213-425HP
Total
 |  |  |  | Regular Shift Differential Hours: |  |  |  | 180
 |  |  |  | Total Shift Differential Hours to Pay:
Spreadsheet: 147608d1332879299-need-help-populating-data-on-new-spreadsheet-from-extracted-pdf-information-for-forum-help
Sheet: PDF Extracted

All Notes 3/27/2010 - 9/15/2011
ABC COMPANY  --  515
Loan Number: [PHONE] |  | Borrower Name: | WARD,ROSIE L
 | PRI CMT  REFERRING ACCT TO FORECLOSURE ON 5/27/10***
[PHONE]
Collection Note
Date: | 05/26/2010
Time: | 10:07:00
User: | KPM
REFERRING ACCT TO FORECLOSURE ON
5/27/10***
08/22/11 7/19/11 CONTRACTOR COMPLETED INITIAL SECURE
[PHONE]
Foreclosure Process Note
Date: | 08/22/2011
Time: | 09:26:20
User: | REF
7/19/11 CONTRACTOR COMPLETED
INITIAL SECURE BID #796472 WAS
SUBMITTED INTO HUD: EXT DEBRIS;
$850.00 INT DEBRIS: $2,250.00
INSTALL PLYWOOD DOOR: $250.0
08/19/11 [NAME], ALLSTATE INSURANCE, POLICY
[PHONE]
[NAME]
Date: | 08/19/2011
Time: | 08:34:37
User: | ZSH
[NAME], ALLSTATE
INSURANCE, POLICY NO: 011598241.
ISSUED: 8/13/2011 EFFECTIVE:
8/13/2011 FORECLOSURE AND FORCED
PLACE COVERAGE IS ALREADY IN PLACE.
HIPC.
08/18/11 TRANSFER TO RIZ FROM QUY VIA SCRIPT
[PHONE]
Foreclosure Process Note
Date: | 08/18/2011
Time: | 17:51:44
User: | FYS
TRANSFER TO RIZ FROM QUY VIA SCRIPT
08/18/11 8/7/11 PROPERTY IS VACANT AND SECURE
[PHONE]
Foreclosure Process Note
Date: | 08/18/2011
Time: | 14:34:23
User: | REF
8/7/11 PROPERTY IS VACANT AND
SECURE CONTRACTOR COMPLETED
RESECURE WINTERIZATION INTACT
08/16/11 08/14/11 PROPERTY IS VACANT AND NOT SECURE.
[PHONE]
Foreclosure Process Note
Date: | 08/16/2011
Time: | 10:32:19
User: | OKF
Printed By: KBFPD | on 9/15/2011 3:12:12 PM | Page 1 of 26
All Notes 3/27/2010 - 9/15/2011
ABC COMPANY  --  515
Loan Number: [PHONE] | [NAME] Name: WARD,ROSIE L
08/14/11 PROPERTY IS VACANT AND NOT
SECURE. CONTRACTOR COMPLETED
WINTERIZATION.
08/08/11 LETTER SENT    FC504 FHA Occupancy-Local Print
[PHONE]
Foreclosure Process Note
Date: | 08/08/2011
Time: | [NAME]
User: | QUY
LETTER SENT FC504 FHA
Occupancy-Local Print
08/06/11 JUDGMENT ENTERED WAS COMPLETED (ON-TIME) WITH A DA
[PHONE]
Foreclosure Process Note
Date: | 08/06/2011
Time: | 22:59:45
User: | Z1T
JUDGMENT ENTERED WAS COMPLETED
(ON-TIME) WITH A DATE OF
01/10/2011(LOAN NUMBER:
[PHONE]): JUDGMENT ENTERED WAS
COMPLETED (ON-TIME) WITH A DATE OF
01/10/2011 BY [NAME] AT
KOHNER, [NAME], S.C. ON
08/06/2011.
08/06/11 FORECLOSURE SALE HELD WAS REFORECASTED (LATE) TO 1
[PHONE]
Foreclosure Process Note
Date: | 08/06/2011
Time: | 13:52:23
User: | Z1T
FORECLOSURE SALE HELD WAS
REFORECASTED (LATE) TO
10/31/2011(LOAN NUMBER:
[PHONE]): FORECLOSURE SALE HELD
WAS REFORECASTED (LATE) TO
10/31/2011 BY [NAME] AT
KOHNER, [NAME], S.C. ON
08/04/2011.
08/06/11 FORECLOSURE SALE SCHEDULED (LOAN NUMBER: 000816847
[PHONE]
Foreclosure Process Note
Date: | 08/06/2011
Time: | 13:52:21
User: | Z1T
FORECLOSURE SALE SCHEDULED (LOAN
NUMBER: [PHONE]): A FORECLOSURE
SALE WAS SCHEDULED BY [NAME]
AT KOHNER, [NAME], S.C. ON
08/04/2011.SCHEDULED SALE DATE:
10/31/2011
Printed By: KBFPD | on 9/15/2011 3:12:12 PM | Page 2 of 26
Spreadsheet: 57600d1257808296-summing-total-with-pushbutton-testtt6
Sheet: Total By Year

 | Surname | Forename | Gender | Class | Read | Write | Math | Science
 | Eight | [NAME] | F | RF | 7 | 7 | 7 | 7
 | Nine | Simone | F | RF | 8 | 8 | 8 | 8
 | Ten | Lilly | F | RF | 9 | 9 | 9 | 9
 | Eleven | [NAME] | F | RF | 10 | 10 | 10 | 10
 | Twelve | [NAME] | M | RF | 11 | 11 | 11 | 11
 | Eight | [NAME] | F | RT | 7 | 7 | 7 | 7
 | Nine | Simone | F | RT | 8 | 8 | 8 | 8
 | Ten | Lilly | F | RT | 9 | 9 | 9 | 9
 | Eleven | [NAME] | F | RT | 10 | 10 | 10 | 10
 | Twelve | [NAME] | M | RT | 11 | 11 | 11 | 11
 | Eight | [NAME] | F | 1A | 7 | 7 | 7 | 7
 | Nine | Simone | F | 1A | 8 | 8 | 8 | 8
 | Ten | Lilly | F | 1A | 9 | 9 | 9 | 9
 | Eleven | [NAME] | F | 1A | 10 | 10 | 10 | 10
 | Twelve | [NAME] | M | 1A | 11 | 11 | 11 | 11
 | Eight | [NAME] | F | 1J | 7 | 7 | 7 | 7
 | Nine | Simone | F | 1J | 8 | 8 | 8 | 8
 | Ten | Lilly | F | 1J | 9 | 9 | 9 | 9
 | Eleven | [NAME] | F | 1J | 10 | 10 | 10 | 10
 | Twelve | [NAME] | M | 1J | 11 | 11 | 11 | 11
 | Five | [NAME] | M | 2C | 4 | 4 | 4 | 4
 | Six | [NAME] | M | 2C | 5 | 5 | 5 | 5
 | Seven | Jojo | F | 2C | 6 | 6 | 6 | 6
 | One | [NAME] | M | 2W | 1 | 1 | 1 | 1
 | Two | [NAME] | F | 2W | 2 | 2 | 2 | 2
 | Three | [NAME] | M | 2W | 3 | 3 | 3 | 3
 | Four | Devine | F | 2W | 4 | 4 | 4 | 4
 | One | [NAME] | M | 3C | 1 | 1 | 1 | 1
 | Two | [NAME] | F | 3C | 2 | 2 | 2 | 2
 | Three | [NAME] | M | 3C | 3 | 3 | 3 | 3
 | Four | Devine | F | 3C | 4 | 4 | 4 | 4
 | One | [NAME] | M | 3E | 1 | 1 | 1 | 1
 | Two | [NAME] | F | 3E | 2 | 2 | 2 | 2
 | Three | [NAME] | M | 3E | 3 | 3 | 3 | 3
 | Four | Devine | F | 3E | 4 | 4 | 4 | 4
 | One | [NAME] | M | 4M | 1 | 1 | 1 | 1
 | Two | [NAME] | F | 4M | 2 | 2 | 2 | 2
 | Three | [NAME] | M | 4M | 3 | 3 | 3 | 3
 | Four | Devine | F | 4M | 4 | 4 | 4 | 4
 | One | [NAME] | M | 4W | 1 | 1 | 1 | 1
 | Two | [NAME] | F | 4W | 2 | 2 | 2 | 2
 | Three | [NAME] | M | 4W | 3 | 3 | 3 | 3
 | Four | Devine | F | 4W | 4 | 5 | 4 | 4
 | One | [NAME] | M | 5B | 1 | 1 | 1 | 1
 | Two | [NAME] | F | 5B | 2 | 2 | 2 | 2
 | Three | [NAME] | M | 5B | 3 | 3 | 3 | 3
 | Four | Devine | F | 5B | 4 | 4 | 4 | 4
 | One | [NAME] | M | 5G | 1 | 1 | 1 | 1
 | Two | [NAME] | F | 5G | 2 | 2 | 2 | 2
 | Three | [NAME] | M | 5G | 3 | 3 | 3 | 3
 | Four | Devine | F | 5G | 4 | 4 | 4 | 4
 | One | [NAME] | M | 6OK | 1 | 1 | 1 | 1
 | Two | [NAME] | F | 6OK | 2 | 2 | 2 | 2
 | Three | [NAME] | M | 6OK | 3 | 3 | 3 | 3
 | Four | Devine | F | 6OK | 4 | 4 | 4 | 4
 | One | [NAME] | M | 6L | 1 | 1 | 1 | 1
 | Two | [NAME] | F | 6L | 2 | 2 | 2 | 2
 | Three | [NAME] | M | 6L | 3 | 3 | 3 | 3
 | Four | Devine | F | 6L | 4 | 4 | 4 | 4
Spreadsheet: mike_carson__27606__KOCH
Sheet: Sheet1

 | Power for delivery
 | On-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit | EPMI | Total
 |  | Postion | Price |  | Fee | COST | Dollars
 | Entergy | 100 | 16.25 |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -700 | 18.3 |  | 1
 | Comed | -100 | 19 |  | 1
 | Off-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit |  | Total
 |  | Postion | Price |  | Fee |  | Dollars
 | Entergy | 0 |  |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -50 | 13.25 |  | 1
 | Comed | 0 |  |  | 1
 |  |  |  |  | Total
 |  |  |  |  |  | Net AMT
Spreadsheet: 59305d1259794779-excel-formula-help-test-book
Sheet: Sheet1

[NAME] | ITEM TYPE | GROSS ITEMS | SALES ITEMS | CREDIT ITEMS | NET ITEMS | SALES AMOUNT | CREDIT AMOUNT | NET AMOUNT | FEE AMOUNT
1 | Bread | 2 | 2 | 0 | 2 | 20 | 0 | 20 | 1
1 | Butter | 2 | 2 | 0 | 2 | 2.5 | 2 | 0.5 | 1
2 | Bread | 5 | 4 | 1 | 5 | 9.25 | 8 | 1.25 | 1.22
123 | Chicken | 20 | 19 | 1 | 20 | 9.01 | 7.01 | 2 | 1
123 | Bread | 8 | 4 | 4 | 8 | 22 | 8 | 14 | 1
123 | Butter | 24 | 23 | 1 | 21 | 5.720000000000001 | 2.72 | 3 | 1
123 | Carrots | 5 | 5 | 0 | 5 | 14 | 0 | 14 | 1
123 | [NAME] | 12 | 10 | 2 | 12 | 26 | 6 | 20 | 1
123 | EBT | 6 | 6 | 0 | 6 | 12 | 0 | 12 | 1
124 | Chicken | 21 | 21 | 0 | 21 | 21 | 0 | 21 | 1
124 | Bread | 22 | 21 | 1 | 22 | 12 | 7 | 5 | 1
124 | Butter | 10 | 8 | 2 | 10 | 7 | 4 | 3 | 1
124 | Carrots | 2 | 2 | 0 | 2 | 4 | 0 | 4 | 1
124 | [NAME] | 17 | 14 | 3 | 17 | 6 | 4 | 2 | 1
124 | EBT | 14 | 14 | 0 | 14 | 2.81 | 0 | 2.81 | 1
125 | Chicken | 20 | 20 | 0 | 20 | 5 | 0 | 5 | 1
[NAME] | ITEM TYPE | GROSS ITEMS | SALES ITEMS | CREDIT ITEMS | NET ITEMS | SALES AMOUNT | CREDIT AMOUNT | NET AMOUNT | FEE AMOUNT | Total Net Amounts per Location
1 | Bread | 2 | 2 | 0 | 2 | 20 | 0 | 20 | 1
1 | Butter | 2 | 2 | 0 | 2 | 2.5 | 2 | 0.5 | 1
 |  |  |  |  |  |  |  |  |  | 20.5
2 | Bread | 5 | 4 | 1 | 5 | 9.25 | 8 | 1.25 | 1.22
 |  |  |  |  |  |  |  |  |  | 1.25
123 | Chicken | 20 | 19 | 1 | 20 | 9.01 | 7.01 | 2 | 1
123 | Bread | 8 | 4 | 4 | 8 | 22 | 8 | 14 | 1
123 | Butter | 24 | 23 | 1 | 21 | 5.720000000000001 | 2.72 | 3 | 1
123 | Carrots | 5 | 5 | 0 | 5 | 14 | 0 | 14 | 1
123 | [NAME] | 12 | 10 | 2 | 12 | 26 | 6 | 20 | 1
123 | EBT | 6 | 6 | 0 | 6 | 12 | 0 | 12 | 1
 |  |  |  |  |  |  |  |  |  | 65
124 | Chicken | 21 | 21 | 0 | 21 | 21 | 0 | 21 | 1
124 | Bread | 22 | 21 | 1 | 22 | 12 | 7 | 5 | 1
124 | Butter | 10 | 8 | 2 | 10 | 7 | 4 | 3 | 1
124 | Carrots | 2 | 2 | 0 | 2 | 4 | 0 | 4 | 1
124 | [NAME] | 17 | 14 | 3 | 17 | 6 | 4 | 2 | 1
124 | EBT | 14 | 14 | 0 | 14 | 2.81 | 0 | 2.81 | 1
 |  |  |  |  |  |  |  |  |  | 37.81
125 | Chicken | 20 | 20 | 0 | 20 | 5 | 0 | 5 | 1
 |  |  |  |  |  |  |  |  |  | 5
Spreadsheet: 780760d1652754169-a-sum-with-a-nested-countifs-sample
Sheet: Sheet1

 | Date of  Service | Year | Time | Run Number | Station # | Receiving Faciltiy | Initial | Release | Monitor data | autopulse data | Arrest Prior to Arrival | Cardiac Arrest Etiology | Estimated Time of Arrest | Pre-arrival CPR Instructions | Estimated Time Callapse to 911 | Estimated Time Callapse to CPR | witnessed arrest | Arrest Witnessed By | bystander CPR | bystander AED | AED used by | Defibrilliated | Resuscitation Attempted | Type of CPR | CPR Initiated By | Time of 1st CPR | CPR Feedback | Impedance Threshold Device Used | Resuscitation Discontinued | [NAME] | First Defibrillation By | Time of First Defibrillation | Initial Rhythm | [NAME] | Hypothermia Provided | End of Event | ROSC in Field | ROSC Time | ROSC Occurred | Time Code Called | Expired
 |  | 2021 |  |  |  |  |  |  |  |  | yes | Cardiac (Presumed) |  |  |  |  | no |  | no | no |  | no |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  | 2022 |  |  |  |  |  |  |  |  | yes | Respiratory |  |  |  |  | yes |  | no | no |  | no |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  | 2022 |  |  |  |  |  |  |  |  | yes | Cardiac (Presumed) |  |  |  |  | yes |  | no | no |  | no |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  | 2022 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no |  | yes | yes |  | no |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes, At Arrival at the ED
 |  | 2022 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no |  | yes | no |  | no |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes, Sustained for 20 Consecutive Minutes
 |  | 2022 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes |  | no | no |  | no |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes, Prior to ED Arrival Only
 |  | 2022 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no |  | no | no |  | no
 |  | 2022
Spreadsheet: 855270d1704898519-need-help-solving-excell-formula-for-leave-plan-test-leave-plan-admin-shifts-1-
Sheet: Record

Namelist |  |  |  |  | ADMIN (exclude weekends and public holidays) |  |  |  |  | A SHIFT (exc restdays, include weekends and public holidays) |  |  |  |  | Summary of leave days deducted
Nr | Comp | Leave SD | Leave ED |  |  |  |  |  |  |  |  |  |  |  | Calender days | Total Leave days
[NAME] | [NAME] | 2024-01-02 00:00:00 | 2024-01-04 00:00:00
[NAME] | [NAME] | 2024-02-02 00:00:00 | 2024-02-04 00:00:00
[NAME] | [NAME] | 2024-03-02 00:00:00 | 2024-03-04 00:00:00
[NAME] | [NAME] | 2024-04-01 00:00:00 | 2024-04-04 00:00:00
[NAME] | [NAME] | 2024-01-26 00:00:00 | 2024-02-04 00:00:00
[NAME] | [NAME] | 2024-02-01 00:00:00 | 2024-03-04 00:00:00
[NAME] | a-shift | 2024-02-01 00:00:00 | 2024-02-04 00:00:00
[NAME] | a-shift | 2024-02-01 00:00:00 | 2024-03-04 00:00:00
[NAME] | a-shift | 2024-03-01 00:00:00 | 2024-03-04 00:00:00
Spreadsheet: 887901d1738229752-transformation-q-date-transform
Sheet: Sheet1

 |  |  |  |  |  |  |  | ABC | DEF | GHI | JKL | MNO
 | [NAME] | ABC | 1st Jan |  |  |  | [NAME] | 1st Jan | 3rd Jan | 5th Jan | 7th Jan | 9th Jan
 | [NAME] | DEF | 3rd Jan |  |  |  | [NAME] | 1st Jan | 3rd Jan | 5th Jan | 7th Jan | 9th Jan
 | [NAME] | GHI | 5th Jan
 | [NAME] | JKL | 7th Jan
 | [NAME] | MNO | 9th Jan
 | [NAME] | ABC | 1st Jan
 | [NAME] | DEF | 3rd Jan
 | [NAME] | GHI | 5th Jan
 | [NAME] | JKL | 7th Jan
 | [NAME] | MNO | 9th Jan
Spreadsheet: af5b29cd-b2a9-40a1-b72f-882a830b7942
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Inception Media | 815300011928 | Various | Danger In The Manger | 2013-11-19 | DVD | Christmas | 26.98 | Y | Available
Inception Media | 815300011300 | Various | Junior High Spy | 2013-04-23 | DVD | Video | 26.98 | Y | Available
Inception Media | 815300011720 | Various | Wiener Dog Nationals | 2013-07-02 | DVD | Video | 12.98 | Y | Available
Inception Media | 815300012222 | Various | Abner The Invisible Dog | 2014-03-11 | DVD | Film | 12.98 | Y | Available
Spreadsheet: 84952d1285054127-summary-by-columns-book1-1ver2
Sheet: Info

Name | ID | InfoA | InfoB | InfoC | InfoD | [NAME] | InfoF | InfoG | InfoH | InfoI
Name1 | ID1 | InfoA1 | InfoB1 | InfoC1 | InfoD1 | InfoE1 | InfoF1 | InfoG1 | InfoH1 | InfoI1
[NAME] | ID2 | InfoA2 | InfoB2 | InfoC2 | InfoD2 | InfoE2 | InfoF2 | InfoG2 | InfoH2 | InfoI2
Name3 | ID3 | InfoA3 | InfoB3 | InfoC3 | InfoD3 | InfoE3 | InfoF3 | InfoG3 | InfoH3 | InfoI3
Name4 | ID4 | InfoA4 | InfoB4 | InfoC4 | InfoD4 | InfoE4 | InfoF4 | InfoG4 | InfoH4 | InfoI4
Name5 | ID5 | InfoA5 | InfoB5 | InfoC5 | InfoD5 | InfoE5 | InfoF5 | InfoG5 | InfoH5 | InfoI5
Name6 | ID6 | InfoA6 | InfoB6 | InfoC6 | InfoD6 | InfoE6 | InfoF6 | InfoG6 | InfoH6 | InfoI6
Name7 | ID7 | InfoA7 | InfoB7 | InfoC7 | InfoD7 | InfoE7 | InfoF7 | InfoG7 | InfoH7 | InfoI7
Name8 | ID8 | InfoA8 | InfoB8 | InfoC8 | InfoD8 | InfoE8 | InfoF8 | InfoG8 | InfoH8 | InfoI8
Name9 | ID9 | InfoA9 | InfoB9 | InfoC9 | InfoD9 | InfoE9 | InfoF9 | InfoG9 | InfoH9 | InfoI9
Name10 | ID10 | InfoA10 | InfoB10 | InfoC10 | InfoD10 | InfoE10 | InfoF10 | InfoG10 | InfoH10 | InfoI10
Name11 | ID11 | InfoA11 | InfoB11 | InfoC11 | InfoD11 | InfoE11 | InfoF11 | InfoG11 | InfoH11 | InfoI11
Name12 | ID12 | InfoA12 | InfoB12 | InfoC12 | InfoD12 | InfoE12 | InfoF12 | InfoG12 | InfoH12 | InfoI12
Name13 | ID13 | [NAME] | InfoB13 | InfoC13 | InfoD13 | InfoE13 | InfoF13 | InfoG13 | [NAME] | InfoI13
Name14 | ID14 | InfoA14 | InfoB14 | InfoC14 | [NAME] | InfoE14 | InfoF14 | [NAME] | InfoH14 | InfoI14
Name15 | ID15 | InfoA15 | InfoB15 | [NAME] | InfoD15 | InfoE15 | InfoF15 | InfoG15 | InfoH15 | InfoI15
[NAME] | ID16 | InfoA16 | InfoB16 | InfoC16 | InfoD16 | InfoE16 | InfoF16 | InfoG16 | InfoH16 | InfoI16
Name17 | ID17 | InfoA17 | InfoB17 | InfoC17 | InfoD17 | InfoE17 | InfoF17 | InfoG17 | InfoH17 | InfoI17
Name18 | ID18 | InfoA18 | InfoB18 | InfoC18 | [NAME] | InfoE18 | InfoF18 | InfoG18 | InfoH18 | InfoI18
Name19 | ID19 | InfoA19 | InfoB19 | InfoC19 | InfoD19 | InfoE19 | InfoF19 | InfoG19 | InfoH19 | InfoI19
[NAME] | ID20 | InfoA20 | InfoB20 | InfoC20 | InfoD20 | [NAME] | InfoF20 | InfoG20 | InfoH20 | InfoI20
Name21 | ID21 | InfoA21 | InfoB21 | InfoC21 | InfoD21 | InfoE21 | InfoF21 | InfoG21 | InfoH21 | InfoI21
Spreadsheet: 157494d1337766289-excel-2007-bringing-back-the-final-date-time-combo-of-multiple-calls-example-1
Sheet: Data

Job Number | Log | [NAME] | Completed | No of Visits
1-123456789
1-234567890
1-123456789
Question
1 | The formula in [NAME] is:
 | INDEX('Raw Data'!$A$1:$D$4,SMALL(IF('Raw Data'!$A$1:$A$4=[NAME])
Problem | Where the formula indicates which instance to look at (ROW($2:$2)), would normally be entered as 1:1, I need a way of automating this to pick up the final instance of the date.  So where the No of visits is indicated would determine if this part of the fomula would be 1:1,2:2,3:3 etc.
Question
2 | How do I get the formula to apply a blank when the same job number arises again, as this data will now be entered on the first instance.  IE on the above example row 2 and 4 are the same, so I wouild like cell D4 to be blank, indicating that this is a return call.
Spreadsheet: 121134d1315860649-subtotaling-data-with-a-sum-and-count-for-multiple-criteria-pt-multiple-subtotalt-3
Sheet: Sheet1

name | fac | Year | Month | IP_OP | MarginWBadDebt
[NAME] | UT | 2010 | 10 | I | 15
[NAME] | UT | 2010 | 11 | I | 11
[NAME] | UT | 2010 | 11 | O | 1
[NAME] | UT | 2010 | 12 | I | 15 |  |  |  | Sum of MarginWBadDebt
[NAME] | UT | 2010 | 12 | O | 15 |  |  |  | name | Month | Total
[NAME] | UT | 2011 | 1 | I | 11 |  |  |  | [NAME] | 1 | 350
[NAME] | UT | 2011 | 2 | I | 1 |  |  |  |  | 2 | 345
[NAME] | UT | 2011 | 3 | I | 5 |  |  |  |  | 10 | 10
[NAME] | UT | 2011 | 4 | I | 3 |  |  |  |  | 11 | 59
[NAME] | UT | 2011 | 5 | I | 4 |  |  |  |  | 12 | 475
[NAME] | UT | 2011 | 6 | I | 1 |  |  |  | cindy Total |  | 1239
[NAME] | UT | 2011 | 7 | I | 1 |  |  |  | [NAME] | 1 | 11
[NAME] | TX | 2010 | 10 | I | 5 |  |  |  |  | 2 | 1
[NAME] | TX | 2010 | 10 | O | 5 |  |  |  |  | 3 | 5
[NAME] | TX | 2010 | 11 | I | 1 |  |  |  |  | 4 | 3
[NAME] | TX | 2010 | 11 | O | 58 |  |  |  |  | 5 | 4
[NAME] | TX | 2010 | 12 | I | 58 |  |  |  |  | 6 | 1
[NAME] | TX | 2010 | 12 | O | 417 |  |  |  |  | 7 | 1
[NAME] | TX | 2011 | 1 | I | 100 |  |  |  |  | 10 | 15
[NAME] | TX | 2011 | 1 | O | 250 |  |  |  |  | 11 | 12
[NAME] | TX | 2011 | 2 | I | 345 |  |  |  |  | 12 | 30
 |  |  |  |  |  |  |  |  | [NAME] |  | 83
 |  |  |  |  |  |  |  |  | Grand Total |  | 1322