tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 480433d1473912154-formula-for-incremental-increase-of-count-book1
Sheet: Sheet1

 |  |  | Solution sought: |  | Everytime the character count of the character in column E increases, incremental increase of that character in column F
 |  |  |  | A | A1
 |  |  |  | B | B1
 |  |  |  | C | C1
 |  |  |  | D | D1
 |  |  |  | A | A2
 |  |  |  | B | B2
 |  |  |  | D | D2
 |  |  |  | A | A3
 |  |  |  | D | D3
Spreadsheet: 481730d1474622905-please-advice-me-on-how-to-analyze-and-find-patterns-in-my-dataset-for-forecasting-sample
Sheet: Ark1

Date | Day | Change | Open | High | Low | Close | TypeOfDay | Gap | GapClose | Range | TrueRange | Pivot | PivotTouched | FirstSwing | LastSwing | Direction
2012-12-19 00:00:00 | Wednesday | -0.0071 | 1443.75 | 1444.25 | 1431 | 1431.5 | HL | 2 | NA | 13.25 | 13.25 | 1435.5 | Yes | Down | Down | Down
2012-12-18 00:00:00 | Tuesday | 0.0114 | 1427.5 | 1443.5 | 1425.25 | 1441.75 | LH | 2 | NA | 18.25 | 18.25 | 1436.75 | No | Up | Up | Up
2012-12-17 00:00:00 | Monday | 0.0124 | 1412 | 1426.25 | 1411.5 | 1425.5 | LH | 4 | No | 14.75 | 18.25 | 1421 | No | Up | Up | Up
2012-12-14 00:00:00 | Friday | -0.0042 | 1410.25 | 1413 | 1405.75 | 1408 | HL | -3.75 | No | 7.25 | 8.25 | 1409 | No | Up | Down | Down
2012-12-13 00:00:00 | Thursday | -0.0098 | 1421.25 | 1425.25 | 1409.75 | 1414 | HL | -6.75 | No | 15.5 | 18.25 | 1416.25 | No | Down | Down | Down
2012-12-12 00:00:00 | Wednesday | 0.0005 | 1433.25 | 1438.75 | 1426.25 | 1428 | HL | 6 | Yes | 12.5 | 12.5 | 1431 | Yes | Down | Down | Up
2012-12-11 00:00:00 | Tuesday | 0.0067 | 1423.75 | 1434.25 | 1422.75 | 1427.25 | LH | 6 | No | 11.5 | 16.5 | 1428 | No | Up | Up | Up
2012-12-10 00:00:00 | Monday | 0.0005 | 1415 | 1421 | 1414.5 | 1417.75 | LH | -2 | NA | 6.5 | 6.5 | 1417.75 | Yes | Up | Up | Up
2012-12-07 00:00:00 | Friday | 0.0032 | 1418.5 | 1420 | 1409.5 | 1417 | HL | 6 | Yes | 10.5 | 10.5 | 1415.5 | Yes | Down | Up | Up
Spreadsheet: 850376d1700735066-head-count-by-month-sample1-1-
Sheet: Sheet1

Name | Value | Date | Location
[NAME] | 50 | 2022-12-01 00:00:00 | Norm
[NAME] | 50 | 2022-12-01 00:00:00 | Norm |  |  |  | Month | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00
[NAME] | 50 | 2022-12-01 00:00:00 | Norm |  |  |  | Name Count
[NAME] | 50 | 2022-12-01 00:00:00 | Norm |  |  |  | Gross Invoicing
[NAME] | 50 | 2022-12-01 00:00:00 | Norm |  |  |  | Norm
[NAME] | 50 | 2022-12-01 00:00:00 | Norm |  |  |  | Complaint Payroll
[NAME] | 50 | 2022-12-31 00:00:00 | Norm
[NAME] | 50 | 2022-12-31 00:00:00 | Norm
[NAME] | 50 | 2022-12-31 00:00:00 | Norm
[NAME] | 80 | 2023-01-31 00:00:00 | Norm
[NAME] | 50 | 2023-02-28 00:00:00 | Norm
[NAME] | 80 | 2023-04-24 00:00:00 | Gross Invoicing
[NAME] | 80 | 2023-04-24 00:00:00 | Gross Invoicing
Geoff | 60 | 2023-04-30 00:00:00 | Norm
[NAME] | 80 | 2023-05-22 00:00:00 | Gross Invoicing
[NAME] | 80 | 2023-06-05 00:00:00 | Gross Invoicing
Geoff | 80 | 2023-06-05 00:00:00 | Gross Invoicing
Geoff | 69.96 | 2023-06-30 00:00:00 | Norm
Sue | 60 | 2023-07-10 00:00:00 | Gross Invoicing
[NAME] | 75 | 2023-07-31 00:00:00 | Norm
Sue | 66 | 2023-08-29 00:00:00 | Complaint Payroll
[NAME] | 75 | 2023-08-31 00:00:00 | Norm
[NAME] | 50 | 2023-09-30 00:00:00 | Norm
Spreadsheet: 701016d1603463191-formula-to-compare-tables-and-flag-rows-that-have-been-updated-customer-list
Sheet: New Table

ADDRESS_NO | Account_ID | ADDRESS_TYPE | CUSTOMER | [NAME] | ADDRESS_2 | CITY | PROVINCE | POST_CODE | [NAME] | _REP_NAME | _REP_NAME | _REP_NAME | _REP_NAME | _REP_NAME | _REP_NAME | _REP_NAME | AIAC01 | AIAC05 | AIAC08 | ABAC04/L01 | DRDL01 | [NAME] | Flag
1 | End | End | Customer 1 | 1212 second street |  | Toronto | ON | L1L 1L1 | 2892222222 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | 20 | 20 | 20 | 20 | 20 | 20
2 | End | End | Customer 2 | 1225 third street |  | Mississauga | ON | L1L 1L1 | 2892222222 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | 20 | 20 | 20 | 20 | 20 | 20 | 1
Spreadsheet: scott_neal__37824__historical info 10-3-00
Sheet: Summary

 |  | Value as Of | Intrinsic Value | Extrinsic Value | Intrinsic Delta | Extrinsic Delta
 |  | "Original" Deals
 |  | 1999-11-03 00:00:00
 |  | 2000-02-29 00:00:00
 |  | 2000-09-18 00:00:00
 |  | Added after 11/03/1999 to original model
 |  | 2000-02-29 00:00:00
 |  | 2000-09-18 00:00:00
 |  | Deals Added to Current Model
 |  | Initially
 |  | (various 06/00 and 07/00 dates)
 |  | 2000-09-18 00:00:00
 |  |  |  | Total Delta
Spreadsheet: 794031d1661855738-refferal-issues-invoice-template
Sheet: gegevens ondernemer

[NAME] diensten die uw onderneming levert:
[NAME] dienst/product |  |  |  |  |  | Prijs/uurtarief
[NAME] |  |  |  |  |  | 1
[NAME] |  |  |  |  |  | 2
[NAME] |  |  |  |  |  | 3
[NAME] |  |  |  |  |  | 4
[NAME] |  |  |  |  |  | 5
[NAME] 6 |  |  |  |  |  | 6
[NAME] |  |  |  |  |  | 7
[NAME] 8 |  |  |  |  |  | 8
[NAME] 9 |  |  |  |  |  | 9
[NAME] 10 |  |  |  |  |  | 10
[NAME] 11 |  |  |  |  |  | 11
[NAME] 12 |  |  |  |  |  | 12
[NAME] 13 |  |  |  |  |  | 13
[NAME] 14 |  |  |  |  |  | 14
[NAME] 15 |  |  |  |  |  | 15
[NAME] 16 |  |  |  |  |  | 16
[NAME] 17 |  |  |  |  |  | 17
[NAME] 18 |  |  |  |  |  | 18
[NAME] 19 |  |  |  |  |  | 19
[NAME] 20 |  |  |  |  |  | 20
[NAME] 21 |  |  |  |  |  | 21
[NAME] 22 |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  | 0.21
 |  |  |  |  |  |  |  |  |  | 0.06
 |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 96542d1295925670-sum-an-index-match-test
Sheet: Sheet1

Budget
Total Spent: | 1813.03 | NB: Total Spent is inclusive of specific items allocated below plus additional R&R not allocated
 | Total Allocated | Total Spent | Total Remaining
SC | 1000 | 122.1 |  | SC
GH |  |  |  | GH
R&R |  |  |  | R&R
POM |  |  |  | POM
AN |  |  |  | AN
Date |  |  |  | Amt | Code
2010-01-13 00:00:00 |  |  |  | 122.1 | SC
 |  |  |  | 500 | SC
 |  |  |  | 750.53 | GH
 |  |  |  | 300 | SC
 |  |  |  | 10.4 | R&R
 |  |  |  | 50 | R&R
 |  |  |  | 80 | GH
Spreadsheet: 216749d1361878993-find-data-betwwen-two-dates-datest
Sheet: Sheet2

2012-11-02 00:00:00 | Suppose I Give Assigned Date as 11/2/2012
2013-02-19 22:07:29 | Suppose I Give Closed Date as 2/5/2012
Incident No. | Description | Assignee Individual | Assigned date | Closed date | Acknowledment time(mins) | Resolution time (hrs) | Effots spent | Resolved within  SLA
Spreadsheet: 136054d1326387277-index-formula-duplicate-records-problem-book10_3
Sheet: Sheet1

corpid | chain | external |  | corp | chain | external
[PHONE] | [PHONE] | [PHONE] |  |  |  |  | 1 corp | 1 chain | 1 external
[PHONE] | [PHONE] | [PHONE] |  |  |  |  | 7corp | 7 chain | 7external
[PHONE] | [PHONE] | [PHONE]
[PHONE] | [PHONE] | [PHONE]
[PHONE] | [PHONE] | [PHONE]
[PHONE] | [PHONE] | [PHONE]
[PHONE] | [PHONE] | [PHONE]
[PHONE] | [PHONE] | [PHONE]
 | [PHONE] | 334507057966 |  |  |  |  |  | 9 chains | 9 external
 | [PHONE] | 334507057925
 | [PHONE] | 334507057933
 | [PHONE] | 334507057958
 | [PHONE] | 334507057974
 | [PHONE] | 334507057941
 | [PHONE] | 334507034502 |  |  |  |  |  | Different chain from here, so I suppose the 9 above sould be split up in  6 and 3?
 | [PHONE] | 334507034486
 | [PHONE] | 334507034494
 | [PHONE] | 520334507055663 |  |  |  |  |  | 2chains | 2external
 | [PHONE] | 520334507055655
 | [PHONE] | 520334507056927 |  |  |  |  |  | 1chain | 1 external
 | [PHONE] | 334507057602 |  |  |  |  |  | 2chains | 2external
 | [PHONE] | 520334507057834
 | [PHONE] | 334507053528 |  |  |  |  |  | 2chains | 2external
 | [PHONE] | 520334507057610
 | [PHONE] | 520334507057594 |  |  |  |  |  | 1chain | 1 external
 | [PHONE] | 520334507057578 |  |  |  |  |  | 1chain | 1 external
 | [PHONE] | 334507057768 |  |  |  |  |  | 1chain | 1 external
 |  |  | sum
Spreadsheet: 751840d1634371308-if-and-and-search-formula-aged-debtor-small
Sheet: Sheet2

Row Labels | Sum of Invoice Value | Count of Invoice Value2 | Sum of Invoice Value3
Company 3 | 2471 | 17 | 0.1432879095389968
Company 2 | 2212 | 15 | 0.1282690634966657
Company 5 | 2014 | 18 | 0.1167874746303276
Company 8 | 1970 | 13 | 0.1142360104378081
Company 7 | 1820 | 15 | 0.1055378370542186
Company 1 | 1799 | 16 | 0.1043200927805161
Company 6 | 1672 | 12 | 0.09695563931574369
Company 10 | 1535 | 11 | 0.08901130762539866
Company 4 | 1147 | 10 | 0.06651203247318063
Company 9 | 605 | 7 | 0.0350826326471441
Grand Total | 17245 | 134 | 1
Sum of Invoice Value | Column Labels
Row Labels | 2019 | 2020 | 2021 | Grand Total
Company 3 | 748 | 785 | 938 | 2471
Company 2 | 631 | 354 | 1227 | 2212
Company 5 | 735 | 825 | 454 | 2014
Company 8 | 377 | 1231 | 362 | 1970
Company 7 | 680 | 913 | 227 | 1820
Company 1 | 877 | 681 | 241 | 1799
Company 6 | 492 | 794 | 386 | 1672
Company 10 | 1241 | 171 | 123 | 1535
Company 4 | 384 | 763 |  | 1147
Company 9 | 298 | 165 | 142 | 605
Grand Total | 6463 | 6682 | 4100 | 17245
Spreadsheet: 688700d1595917296-return-value-for-mapped-rows-workbook-example-v2
Sheet: Sheet1

Group | Rows |  |  | Text | Num | Group 1 | Group 2
Group 1 | Row A |  |  | Row A | 21
Group 1 | Row B |  |  | Row B | 27
Group 2 | Row B |  |  | Row C | 30
Group 2 | Row C
Spreadsheet: 852998d1702966954-need-formula-for-price-comparison-book3
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FORMULA REQUIRED |  |  | FORMULA REQUIRED |  |  | FORMULA REQUIRED
 |  |  |  | [NAME] |  |  |  |  |  |  |  | VENDOR 1 |  |  |  |  |  |  |  | VENDOR 2 |  |  |  |  |  |  |  | VENDOR 3 |  |  |  |  |  |  |  | VENDOR 4 |  |  |  |  |  |  |  | VENDOR 5 |  |  |  |  |  |  |  | 1st Option |  |  | 2nd Option |  |  | 3rd Option
 |  |  |  | [NAME] |  |  |  |  |  | REQ. QTY |  | incl. gst rate | ex. gst rate | disc. | MIN RATE | TOTAL | TAX | AVAILABILITY |  | incl. gst rate | ex. gst rate | disc. | MIN RATE | TOTAL | TAX | AVAILABILITY |  | incl. gst rate | ex. gst rate | disc. | MIN RATE | TOTAL | TAX | AVAILABILITY |  | incl. gst rate | ex. gst rate | disc. | MIN RATE | TOTAL | TAX | AVAILABILITY |  | incl. gst rate | ex. gst rate | disc. | MIN RATE | TOTAL | TAX | AVAILABILITY |  | MIN RATE | VENDOR | AVAILABILITY | MIN RATE | VENDOR | AVAILABILITY | MIN RATE | VENDOR | AVAILABILITY
 |  |  |  | A |  |  |  |  |  | 10 |  | 5000 |  | 0.05 |  |  | 0 | READY STOCK |  | 4600 |  | 0.06 |  |  | 0 | NOT AVAILABLE |  | 3900 |  | 0.02 |  |  | 0 | READY STOCK |  | 6000 |  | 0.1 |  |  | 0 | READY STOCK |  | 3900 |  | 0 |  |  | 0 | READY STOCK
 |  |  |  | B |  |  |  |  |  | 25 |  | 780 |  | 0.05 |  |  | 0 | 2~3 DAYS |  | 690 |  | 0.04 |  |  | 0 | 2~3 DAYS |  | 590 |  | 0 |  |  | 0 | 2~3 DAYS |  | 550 |  | 0.02 |  |  | 0 | READY STOCK |  | 680 |  | 0.05 |  |  | 0 | READY STOCK |  |  | VENDOR 4 |  |  | VENDOR 4 |  |  | VENDOR 4
Spreadsheet: 65829d1266486574-updating-2-workbooks-sample
Sheet: illustration

SHEET1: |  |  |  |  |  |  | there will be more colums in between  G & H and also L & M
CLIENT CODE | COMPANY CODE | PRODUCT LENGTH | REJECT NO. |  |  |  | TOTAL REJECTS | DELIVERY DATE |  |  |  | TOTAL QTY. DELIVERED | BALANCE
 |  |  | 120 | 121 | 122 | & so on… |  | 2010-01-04 00:00:00 | 2010-01-09 00:00:00 | 2010-01-18 00:00:00 | & so on…
AD2-001 | 94001 | 5.15 |  |  |  |  | 0 |  |  |  |  | 0 | 0
AD2-001 | 94001 | 4.25 | 1 |  | 4 |  | 5 |  | 1 |  |  | 1 | 4
AD2-001 | 94001 | 6.56 |  | 7 |  |  | 7 |  | 2 |  |  | 2 | 5
AD2-002 | 94002 | 5.15 | 10 |  | 3 |  | 13 | 6 |  |  |  | 6 | 7
AD2-002 | 94002 | 4.65 |  | 5 |  |  | 5 |  |  |  |  | 0 | 5
AD2-002 | 94002 | 6.56 |  |  | 1 |  | 1 |  |  |  |  | 0 | 1
AD2-003 | 94003 | 5.15 | 8 |  |  |  | 8 |  | 4 |  |  | 4 | 4
AD2-003 | 94003 | 4.5 |  |  |  |  | 0 |  |  |  |  | 0 | 0
AD2-003 | 94003 | 6.45 |  | 2 | 9 |  | 11 | 5 |  | 3 |  | 8 | 3
AD2-003 | 94003 | 4.1 |  |  |  |  | 0 |  |  |  |  | 0 | 0
SHEET2: |  |  |  |  |  |  |  | ROW # since this table should be in sheet2: |  |  |  | 1
REJECT NO. | CLIENT CODE | COMPANY CODE | PRODUCT LENGTH | REJECT QTY | DELIVERIES |  |  |  |  |  | BALANCE | 2
 |  |  |  |  | QTY | DATE | QTY | DATE | QTY | DATE |  | 3
120 | AD2-001 | 94001 | 4.25 | 1 | 1 | 2010-01-09 00:00:00 |  |  |  |  | 0 | 4
120 | AD2-002 | 94002 | 5.15 | 10 | 6 | 2010-01-04 00:00:00 |  |  |  |  | 4 | 5
120 | AD2-003 | 94003 | 5.15 | 8 | 4 | 2010-01-09 00:00:00 |  |  |  |  | 4 | 6
121 | AD2-001 | 94001 | 6.56 | 7 | 2 | 2010-01-09 00:00:00 |  |  |  |  | 5 | 7
121 | AD2-002 | 94002 | 4.65 | 5 |  |  |  |  |  |  | 5 | 8
121 | AD2-003 | 94003 | 6.45 | 2 | 2 | 2010-01-04 00:00:00 |  |  |  |  | 0 | 9
122 | AD2-001 | 94001 | 4.25 | 4 |  |  |  |  |  |  | 4 | 10
122 | AD2-002 | 94002 | 5.15 | 3 |  |  |  |  |  |  | 3 | 11
122 | AD2-002 | 94002 | 6.56 | 1 |  |  |  |  |  |  | 1 | 12
122 | AD2-003 | 94003 | 6.45 | 9 | 5 | 2010-01-04 00:00:00 | 3 | 2010-01-18 00:00:00 |  |  | 1 | 13
& so on… |  |  |  |  |  |  |  |  |  |  |  | 14
part 1 |  |  |  |  |  |  | note: please see matching highlighted cells
if D5 (of sheet1) has cell qty,  then get qty & copy it to e4 (in sheet 2)
also copy corresponding A5, B5 & C5 (of sheet1) to B4, C4 & D4 (in sheet2)
also copy [NAME] (of sheet1) to corresponding A4 (in sheet2)
part 2
if [NAME] (of sheet1) has cell qty, then
find & match corresponding B12& C12(of sheet1) to columns C & D (in sheet2),
if match is found and if corresponding F (in sheet2) is blank,  get & copy K12 (of sheet1) to corresponding F (in sheet2)
also copy K3 (of sheet1) to G (cell next to corresponding F (in sheet2)
if match is found but corresponding F (in sheet2) is not blank
and  corresponding H (in sheet2) is blank , get & copy K12 to corresponding H (in sheet2)
also copy K3 (of sheet1) to I (in sheet2)
if match is found but corresponding H (in sheet2) is still not blank, and corresponding J (in sheet2) is blank
get & copy K12 to corresponding J
also copy K3 (of sheet1) to K (in sheet2)
and so on for L & M, N & O, P & Q etc
Spreadsheet: 90118d1289883171-excel-2007-display-output-from-a-row-of-data-optimizer-i
Sheet: Correlations

 | YEYC | YEY | YEY2 | Yield4 | YldYear | YldDiv | L_ZLTD | LLTD_C | LPE_YLD | PE_GrNet | CheapHi | Balance | H52Earn | [NAME] | History | BOUNCE | HICCUP | My PIH | My PIH2 | My PIH3 | Alt_PIH | PIH_CSO | PIH_MCP | [NAME] | SomeMo | SomeMoSafe | NoMoSafe | HI_INC | T_VALUE | PlowBVS | EG5_AT | EG5_PE | TREPPE | PL_LD_NRS | PEBSize | PEG | PEG13 | PEG-NT | PLOW_PE2 | AssRS13 | AssRS26 | Plow26 | TPEGME | RS2020 | Screamer | Value_EG | PEG-Min | Smooth | BlueChip | SmallMo | SmMoEY | Pharstad | Cash | Hook
YEYC
YEY
YEY2
Yield4
YldYear
YldDiv
L_ZLTD
LLTD_C
LPE_YLD
PE_GrNet
CheapHi
Balance
H52Earn
[NAME]
History
BOUNCE
HICCUP
My PIH
My PIH2
My PIH3
Alt_PIH
PIH_CSO
PIH_MCP
[NAME]
SomeMo
SomeMoSafe
NoMoSafe
HI_INC
T_VALUE
PlowBVS
EG5_AT
EG5_PE
TREPPE
PL_LD_NRS
PEBSize
PEG
PEG13
PEG-NT
PLOW_PE2
AssRS13
AssRS26
Plow26
TPEGME
RS2020
Screamer
Value_EG
PEG-Min
Smooth
BlueChip
SmallMo
SmMoEY
Pharstad
Cash
Hook
Spreadsheet: 89766d1289504540-converting-time-to-hours-and-minutes-comp-form-fy-2011
Sheet: Dec

Comp Time Form
 | Name : |  |  | Month: | December 2010
 | Title:
 | Earned/Taken  E or T | Date Earned/Taken | Activity | Director [NAME] | Time Worked | Time Granted      (@ time & 1/2) | Time Used | Time Available
 | E |  | Forwarded from Previous Month
 |  |  |  | Sub Totals
Spreadsheet: 685943d1594287869-daily-appointment-calendar-tf00000044
Sheet: Daily Appointment Calendar

 | DAILY APPOINTMENT CALENDAR
 | SCHEDULE START: | 07:00:00 | TIME INTERVAL: | 30 MIN | WEEK START DATE: | 2020-07-13 00:00:00
 | TIME
Spreadsheet: stacey_white__39023__Pwr west P&L
Sheet: Stacey's Working Sheet

ENRON POWER TRADING & TRANSMISSION
DAILY POSITION STATEMENT
DATE:
 | LT-ECAR | LT-ERCOT | LT-HED | LT-MAIN | LT-MAPP | LT-MGMT | LT-MKTRSCH | LT-NEMGMT | LT-NENG | LT-NEUTIL | LT-OPTION | LT-PJM | LT-SERC | LT-SPP | LT-TRANS | MAIN-ANYST | MW-ANALYST | NE TRANS | PJM FTR | SE-ANALYST | LT-ECAR | LT-ECAR | LT-ECAR | LT-ECAR | LT-ECAR | LT-ECAR | LT-ECAR | LT-ECAR | LT-ECAR | LT-ECAR | LT-ECAR | LT-ECAR | LT-ECAR | LT-ECAR | LT-ECAR
[NAME])  (Million MMbtu)
Net NPV Position (MWH)
Net NPV Position (MMBtu)
Net NPV Position (MM Bbls)
Gross Purchases Position
Gross Sales Position
Net Notional Position
Gross Purchases Position
Gross Sales Position
Net Notional Position
[NAME]  (in thousands)
Gross Book Balance
Prudence
Liquidated
LTD Gross Recognized Balance
Originated Transactions / Credit Reserve
Hedge management
New Deals
Change in Price
Change in Basis Price
Change in Index Price
Gamma
Change in Implied Volatility (Vega)
Theta
Change in Time
Change in Interest Rates
Broker Fees
Adjustments
Total Hedge Management
Change in Price Prudence
Financial Liquidations
Physical Liquidations
Other Changes
MTD Income (Loss)
Gross Book Balance (including Current Month Rho & Drift)
Current Month:        Rho
Drift
Gross Book Balance (excluding Current Month Rho & Drift)
Prudence
Liquidated
Gross Recognized Balance
LTD Through December 31, 1999
Gross Recognized Balance
Originated Transactions / Credit Reserve
Gross Book Balance
Prudence
Liquidated
Gross Recognized Balance
Income (Loss) from Today's....
Originated Transactions / Credit Reserve
Hedge management
New Deals
Change in Price
Change in Basis Price
Change in Index Price
Gamma
Change in Implied Volatility (Vega)
Theta
Change in Time
Broker Fees
Adjustments
Total Hedge Management
Change in Price Prudence
Financial Liquidations
Physical Liquidations
Other Changes
Total Income (Loss)
YTD Check Figures
Spreadsheet: 799356d1665056525-sumif-xlookup-combo-without-a-lookup-cell-testsumiflookup
Sheet: Sheet1

Tier | Name | Month | XLOOKUP
Mega | [NAME] | July
Mega | YYY | July
Mid | ZZZ | July | 10
Mega | WWW | June
Name | Result |  |  | Tier | Sum
[NAME] | 2 |  |  | Mega
YYY | 4 |  |  | Mid
ZZZ | 6
WWW | 8
Spreadsheet: 843775d1695623759-finding-max-deviation-from-a-specific-number-qc-data-irh-3-
Sheet: Sheet1

MPVC | 331.31 | 287.14 | 287.14
MPVLCW | 329.26 | 284.04 | 284.04
MPVRCW | 318.62 | 274.94 | 296.02
MPVLN | 334.04 | 290.3 | 290.3
MPVRN | 321.16 | 280.11 | 280.11
[NAME] deviation in corner MPV from MPVc
Spreadsheet: 854937d1704702236-filter-without-result-to-show-blank-for-vstack-filter-without-result
Sheet: Sheet2

Code | Start | End | Prorate |  |  | 2024-06-30 00:00:00 |  | Code | Start | End | Cost
#1 | 2023-05-12 00:00:00 |  | 500 |  |  |  |  |  |  |  |  |  | Basically, I want the top to be Code that start in the Month (E1) and bottom to show Code that end in the Month (E1)
#2 | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 600 |  |  |  |  |  |  |  |  |  | However, the formula only work nicely if the filter is a valid for both Start and End.
#3 | 2023-06-11 00:00:00 |  | 150 |  |  |  |  |  |  |  |  |  | How do I make a Iferror, then it will show blank?
#4 | 2023-06-26 00:00:00 | 2023-09-16 00:00:00 | 3600
#5 | 2023-07-11 00:00:00 |  | 800 |  |  |  |  |  |  |  |  |  | *If the eomonth of START = G1, den ((G1-Start)/day(G1))*column D
#6 | 2023-09-01 00:00:00 |  | 300 |  |  |  |  |  |  |  |  |  | if eomonth of [NAME], den ((Day(end)/Day(g1))*column D
#7 | 2023-09-16 00:00:00 |  | 600
#8 | 2023-10-01 00:00:00 |  | 900
#9 | 2023-10-16 00:00:00 | 2023-12-31 00:00:00 | 7500
#10 | 2023-10-31 00:00:00 |  | 3000
 |  |  |  |  |  |  |  | Code | Start | End | Cost | Prorate
Spreadsheet: 839947d1692304151-threshold-tracking-risk-management-threshold-tracking-2023
Sheet: Data Entry

Date | Individual Name | Home | Incident Type | IDT threshold met | Facility threshold met |  |  |  | Incident Type | IDT Threshold | Time period, months | Time Period, days | Facility Threshold | Time period, months | Time Period, days
2023-07-31 00:00:00 | [NAME], [NAME] | 2W | SIB - Minor Injury |  |  |  |  |  | Chemical or Mechanical [NAME] | 1 |  |  | 2 | 2
2023-08-01 00:00:00 | Bond, Melvina | 2E | Falls |  |  |  |  |  | Choking | 1 |  |  | 2 | 6
2023-08-01 00:00:00 | Radford, Cameron | 3E | Chemical or Mechanical [NAME] |  |  |  |  |  | Decubitus | 1 |  |  | 2 | 12
2023-08-02 00:00:00 | Shields, [NAME] | 3E | Minor Injury |  |  |  |  |  | Falls | 3 |  | 30 | 4 |  | 30
2023-08-03 00:00:00 | Shields, [NAME] | 3E | Minor Injury |  |  |  |  |  | Individual to Staff Aggression - Minor Injury to Staff | 3 |  | 14 | 4 |  | 30
2023-08-03 00:00:00 | Swift, Katrina W | ME | Peer to Peer Aggressor - No/Minor Injury |  |  |  |  |  | Individual to Staff Aggression - Serious Injury to Staff | 1 |  |  | 2 |  | 30
2023-08-04 00:00:00 | Bond, Melvina | 2E | Falls |  |  |  |  |  | LOS - Behavioral/Psychiatric >72 Hrs. | 1 |  |  | 2 |  | 7
2023-08-04 00:00:00 | [NAME], [NAME] | 2W | SIB - Minor Injury |  |  |  |  |  | Major Injury | 1 |  |  | 3 | 6
2023-08-05 00:00:00 | [NAME], [NAME] | 2W | SIB - Minor Injury |  |  |  |  |  | Minor Injury | 5 | 1 |  | 15 | 3
2023-08-05 00:00:00 | Bond, Melvina | 2E | Falls |  |  |  |  |  | Mortality - Expected or Unexpected Death | 1 |  |  | N/A
2023-08-05 00:00:00 | Shields, [NAME] | 3E | Minor Injury |  |  |  |  |  | Peer to Peer Aggressor - No/Minor Injury | 3 |  | 14 | 4 |  | 30
2023-08-07 00:00:00 | [NAME], [NAME] | 2W | SIB - Minor Injury |  |  |  |  |  | Peer to Peer Aggressor - Serious Injury | 1 |  |  | 2 |  | 30
2023-08-07 00:00:00 | Bond, Melvina | 2E | Falls |  |  |  |  |  | Peer to [NAME] | 3 |  | 14 | 4 |  | 30
2023-08-07 00:00:00 | Shields, [NAME] | 3E | Minor Injury |  |  |  |  |  | Peer to Peer Victim - Serious Injury | 1 |  |  | 2 |  | 30
2023-08-07 00:00:00 | Swift, Katrina W | ME | Peer to Peer Aggressor - No/Minor Injury |  |  |  |  |  | Physical Restraint | 1 |  |  | 6 | 2
2023-08-07 00:00:00 | Swift, Katrina W | ME | Peer to Peer Aggressor - No/Minor Injury |  |  |  |  |  | Pica | 1st event |  |  | 2 |  | 180
2023-08-08 00:00:00 | [NAME], [NAME] | 2W | SIB - Minor Injury |  |  |  |  |  | Pneumonia - Aspiration | 1 |  |  | 2 | 12
2023-08-09 00:00:00 | Shields, [NAME] | 3E | Minor Injury |  |  |  |  |  | Pneumonia - Non-Aspiration | 1 |  |  | 2 | 12
2023-08-09 00:00:00 | [NAME], [NAME] | 2W | SIB - Minor Injury |  |  |  |  |  | Polypharmacy - Interclass | 1 |  |  | Ongoing until resolved
2023-08-10 00:00:00 | Bell, Charlesetta D | WS | Choking |  |  |  |  |  | Polypharmacy - Intraclass | 1 |  |  | Ongoing until resolved
2023-09-11 00:00:00 | [NAME], [NAME] | 2W | SIB - Minor Injury |  |  |  |  |  | SIB - Minor Injury | 3 |  | 14 | 6 | 3
2023-09-12 00:00:00 | Radford, Cameron | 3E | Chemical or Mechanical [NAME] |  |  |  |  |  | SIB - Serious Injury | 1 |  |  | 2 | 3
Spreadsheet: 646567d1571916322-help-to-count-cells-on-sheets-with-changing-names-example-1
Sheet: 2209

 |  |  | ROTA W/E: | 2019-09-22 00:00:00
 | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY
SITE 1
0600-1800 | Name A
1800-0600 |  |  | Name B
 |  |  | Name B
 |  |  | Name B
SITE 2
SAT 1200-1800 -SUN 0600-1200 |  |  |  |  | Name B
1800-0600 |  |  |  |  |  | Name F
SITE 3
2000-0800
SITE 4
2000-0800
SITE 5
Spreadsheet: 0dd97f25-fb77-4cc2-a7d3-0631445fb21e
Sheet: Exhibit B - % of Subcontracting

Attachment 7
DE-SOL-0003816
Percentage of Subcontracting - See FAR 52.219-14
Amendment 000006
Description | Base Year 1 | % of | Option Year 1 (Year 2) | % of | Option Year 2 (Year 3) | % of | Option Year 3 (Year 4) | % of | Option Year 4 (Year 5) | % of | Total Option | % of | Total Contract | % of
 |  | Total |  | Total |  | Total |  | Total |  | Total | Years | Total |  | Total
Total Proposal:
Prime Contractor Fully-Loaded Labor | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Teaming Partner(s) Fully-Loaded Labor (if applicable)
Subcontractor(s) Fully-Loaded Labor
Travel
Materials
Other Direct Costs
Total Proposal | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0
Proposed Fully-Loaded Labor, Exclusive of Fee:
Prime Contractor Fully-Loaded Labor | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Teaming Partner(s) Fully-Loaded Labor (if applicable)
Subcontractor(s) Fully-Loaded Labor
Total Proposed Labor | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0
Proposed Direct Productive Labor Hours (DPLH):
Prime Contractor DPLH | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Teaming Partner(s) [NAME] (if applicable)
Subcontractor(s) DPLH
Total Proposed DPLH | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0