tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0184a0f3-0590-4571-bf12-bcfe4ffdd6bc
Sheet: 9d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis* | 1041746 | 782415 | 1021917 | 2584674 | 1543290 | 546334 | 220870 | 7741246
FRA | 15474886 | 10058076 | 5650603 | 5497164 | 123851 |  |  | 36804580
IRS- [NAME] | 6454156 | 6083443 | 5330235 | 21352361 | 32935166 | 26787117 | 13380066 | 112322544
OIS | 8561054 | 4335352 | 2990436 | 5643202 | 85698 |  |  | 21615742
VNS | 455 | 420 | <100 | <100 | 635 | 988 | 1141 | 3639
Zero Coupon | 62936 | 23990 | 16800 | 56745 | 40396 | 7324 | 32528 | 240719
TOTAL | 31595234 | 21283697 | 15009991 | 35134147 | 34729036 | 27341763 | 13634605 | 178728473
Estimated gross notional amount outstanding, December 14 weekly snapshot, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 52190d1251890578-create-lookup-function-samplea
Sheet: Raw Data

Name | Document
AA | FRACA 05548
 | FRACA 06504
 | FRACA 06920
 | FRACA 07203
 | FRACA 07206
 | FRACA 07209
 | FRACA 07361
 | FRACA 07482
BB | FRACA 05552
 | FRACA 05560
 | FRACA 05561
 | FRACA 07287
 | FRACA 07325
CC | FRACA 06181
 | FRACA 06194
 | FRACA 07223
 | FRACA 07613
 | FRACA 07862
DD | FRACA 05869
 | FRACA 06802
 | FRACA 07365
 | FRACA 07864
EE | FRACA 07246
 | FRACA 07419
 | FRACA 07620
 | FRACA 07654
Spreadsheet: 774673d1648608213-fetching-data-from-row-book1
Sheet: Sheet2

Daily Income | 52352 | 52352
Daily Expense | 52525
Weekly Income | 525252 | 525252
Weekly Expense | 525252
Monthly Income | 2525252 | 2525252
Monthly Expense | 2525252
Quarterly Income | 52525252 | 52525252
Quarterly Expense | 52525252
Yearly Income | 252525252 | 252525252
Yearly Expense | 255252525
Spreadsheet: 537300d1504936302-combining-2-rows-into-1-final-invoice-1-
Sheet: page 8

Description of Goods |  |  |  |  | Quantity | Cost | Total
Item # | Color | UPC Code | Country Origin | HS Code
[NAME]: 7.5"x11" Chalkboard Organizer Wall Sticker |  |  |  |  | 24 | 0.82 | 19.68
CD984A | A) Notes | 775749190335 | TAIWAN | 3919.90.0090
[NAME]: 7.5"x11" Chalkboard Organizer Wall Sticker |  |  |  |  | 24 | 0.82 | 19.68
CD984B | B) Weekly Planner | 775749190342 | TAIWAN | 3919.90.0090
[NAME]: 7.5"x11" Chalkboard Organizer Wall Sticker |  |  |  |  | 24 | 0.82 | 19.68
CD984C | C) Memo | 775749190359 | TAIWAN | 3919.90.0090
[NAME]: 7.5"x11" Chalkboard Organizer Wall Sticker |  |  |  |  | 24 | 0.82 | 19.68
CD984D | D) To Do - To Get | 775749190366 | TAIWAN | 3919.90.0090
[NAME]: 7.5"x11" Chalkboard Organizer Wall Sticker |  |  |  |  | 24 | 0.82 | 19.68
CD984E | E) Weekly Menu | 775749190373 | TAIWAN | 3919.90.0090
[NAME]: 7.5"x11" Chalkboard Organizer Wall Sticker |  |  |  |  | 24 | 0.82 | 19.68
[NAME] | F) To Do List | 775749190380 | TAIWAN | 3919.90.0090
[NAME]: Chalk-It-Up Storage Bin 9.13"x7.13"x3.63" w/Handles |  |  |  |  | 60 | 1.48 | 88.8
CD996 | - | 775749200713 | CHINA | 4819.20.0090
Color Factory: 4oz Acrylique Paint for Crafter's |  |  |  |  | 48 | 0.75 | 36
CF100-001 | 001 White | 775749095487 | USA | 3209.10.0020
Color Factory: 4oz Acrylique Paint for Crafter's |  |  |  |  | 48 | 0.75 | 36
CF100-005 | 005 [NAME] | 775749095494 | USA | 3209.10.0020
Color Factory: 4oz Acrylique Paint for Crafter's |  |  |  |  | 48 | 0.75 | 36
CF100-010 | 010 Cream | 775749140293 | USA | 3209.10.0020
Color Factory: 4oz Acrylique Paint for Crafter's |  |  |  |  | 48 | 0.75 | 36
CF100-015 | 015 [NAME] | 775749095500 | USA | 3209.10.0020
Color Factory: 4oz Acrylique Paint for Crafter's |  |  |  |  | 48 | 0.75 | 36
CF100-020 | 020 Deep Turquoise | 775749140378 | USA | 3209.10.0020
Color Factory: 4oz Acrylique Paint for Crafter's |  |  |  |  | 48 | 0.75 | 36
CF100-030 | 030 Bright Red | 775749095524 | USA | 3209.10.0020
Color Factory: 4oz Acrylique Paint for Crafter's |  |  |  |  | 48 | 0.75 | 36
CF100-035 | 035 Holiday Red | 775749095531 | USA | 3209.10.0020
Color Factory: 4oz Acrylique Paint for Crafter's |  |  |  |  | 48 | 0.75 | 36
CF100-040 | 040 Tuscan Red | 775749095548 | USA | 3209.10.0020
Color Factory: 4oz Acrylique Paint for Crafter's |  |  |  |  | 48 | 0.75 | 36
CF100-050 | 050 Wild Eggplant | 775749140361 | USA | 3209.10.0020
Color Factory: 4oz Acrylique Paint for Crafter's |  |  |  |  | 48 | 0.75 | 36
CF100-055 | 055 Fuchsia Fun | 775749140354 | USA | 3209.10.0020
Color Factory: 4oz Acrylique Paint for Crafter's |  |  |  |  | 48 | 0.75 | 36
CF100-060 | 060 Pumpkin Orange | 775749095562 | USA | 3209.10.0020
Color Factory: 4oz Acrylique Paint for Crafter's |  |  |  |  | 48 | 0.75 | 36
CF100-065 | 065 Purple Velvet | 775749140330 | USA | 3209.10.0020
Color Factory: 4oz Acrylique Paint for Crafter's |  |  |  |  | 48 | 0.75 | 36
CF100-070 | 070 Butter Yellow | 775749095579 | USA | 3209.10.0020
Color Factory: 4oz Acrylique Paint for Crafter's |  |  |  |  | 48 | 0.75 | 36
CF100-075 | 075 [NAME] | 775749095586 | USA | 3209.10.0020
Spreadsheet: 864980d1712090839-help-extracting-values-from-cell-test-04022024
Sheet: Digital

 |  | Totals |  |  |  |  |  |  |  |  |  |  |  | Links
 | Sq Ft |  |  |  | Total Print TIme |  | hrs |  | Upload of Art | 2024-05-14 00:00:00 |  |  |  | Large Job Gant Chart for KS.xlsx
 | [NAME] |  |  |  | Total Cutting Time |  | hrs |  | Proof Approvals | 2024-05-17 00:00:00 |  |  |  | PACE JOBS FOR MS.xlsx | MS List for Nathan
 |  |  |  |  | Total Pieces |  | pcs |  | Released to Production | 2024-05-20 00:00:00 |  |  |  | Timeline Requests (V3).xlsx | Timeline Sheet
 |  |  |  |  | Stores |  |  |  | Ship Date | 2024-06-11 00:00:00 |  |  |  | https://www.weprint.com/number-out-calculator.asp | ←#Up Calculator
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Scheduling Kansas.xlsx | ←Old Timelines
Press | SchedTime | Due Date | Job# | Line# | Master [NAME] | QTY | H | W | Material | Sides | PrintMode | Kitting | #OfKits | Notes | DateRecieved | SqFt | LinearFT | MatH | MatW | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | NumUp | Sheets Needed
[NAME] |  |  |  |  |  | 121 | 37 | 27 | PAP-  444054 - 60X120 4MM COROPLAST | 1 | 4 Pass
[NAME] |  |  |  |  |  | 117 | 37 | 27 | PAP-  444054 - 60X120 4MM COROPLAST | 1 | 4 Pass
[NAME] |  |  |  |  |  | 34 | 37 | 27 | PAP-  444054 - 60X120 4MM COROPLAST | 1 | 4 Pass
[NAME] |  |  |  |  |  | 1000 | 10 | 10 | PAP- SO-  2265 - STYRENE WHITE 18PT 29.5X20.5 | 1 | 4 Pass
[NAME] |  |  |  |  |  | 1000 | 3 | 3 | PAP-  449847 - 48 X 96 2MM WHITE SINTRA 700 SERIES | 1 | 4 Pass
[NAME] |  |  |  |  |  | 500 | 2 | 2 | PAP- SO-  2265 - STYRENE WHITE 18PT 29.5X20.5 | 1 | 4 Pass
[NAME] |  |  |  |  |  | 20 | 5 | 5 | PAP- SO-  0017 - 50X99 20PT DEAD WHITE | 1 | 4 Pass
[NAME] |  |  |  |  |  | 100 | 10 | 10 | PAP-  449847 - 48 X 96 2MM WHITE SINTRA 700 SERIES | 1 | 4 Pass
[NAME] |  |  |  |  |  | 1000 | 20 | 20 | PAP-  442004 - 60X120 3MM SINTRA WHITE | 1 | 4 Pass
[NAME] |  |  |  |  |  | 50 | 48 | 48 | ART- 4237 - SINTRA 6MM BLACK 48X96 | 1 | 4 Pass
[NAME] |  |  |  |  |  | 100 | 10 | 10 | ART-  4026 - 24X50 30MIL ADH BACK MAGNETIC BOARD | 1 | 4 Pass
[NAME] |  |  |  |  |  | 100 | 14 | 15 | ART- 4361 - SINTRA WHITE 19MM 48X96 | 1 | 4 Pass
[NAME] |  |  |  |  |  | 50 | 12 | 36 | PAP-  413740 - 48X60 24PT C2S SBS | 1 | 4 Pass
[NAME] |  |  |  |  |  | 100 | 20 | 10 | PAP-  412430 - 100# COMMERCIAL COVER 35X45 | 1 | 4 Pass
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheer Voile Fabric
Spreadsheet: 543716d1508519277-data-validation-sample-2-
Sheet: Sheet1

List A | List B |  | DD List
Org1 | Option 1
Org2 | Option 2
Org1 | Option 3 |  |  |  |  | Select Org | Select Option
Org2 | Option 4
Spreadsheet: 9cd0bcf5-497a-4653-948f-bea640d9de56
Sheet: Sheet1

*Please complete this form and email to [EMAIL].
If email is not an option, please fax to [PHONE] (*email is preferred).
COMPANY
JOB TITLE
FIRST NAME
LAST NAME
BUSINESS STREET
BUSINESS STREET 2
BUSINESS CITY
BUSINESS STATE
BUSINESS POSTAL CODE
BUSINESS PHONE #
EMAIL ADDRESS
WEB PAGE
RESELLER PERMIT #
STATE ISSUED
PREFERRED DISTRIBUTOR #1 |  | ACCOUNT #
PREFERRED DISTRIBUTOR #2 |  | ACCOUNT #
PREFERRED DISTRIBUTOR #3 |  | ACCOUNT #
*CasePartners will respond to your request within 3-4 weeks.
As a CasePartner member you agree not to sell  any Case Logic product on the Amazon Marketplace or any other consumer internet marketplace. Doing so could result in the cancellation of your CasePartner membership and all benefits.
Spreadsheet: 197219d1354254642-top-5-selling-items-sample
Sheet: Sheet1

 |  | [NAME] | 2
 |  | [NAME] | 3
 |  | S/F Noodle Soup | 6
 |  | [NAME] | 5
 |  | [NAME] | 6
 |  | Century Egg | 10
 |  | Scallop | 3
 |  | Peking Duck Ent | 8
 |  | Prawn Curry | 1
 |  | [NAME] Quail | 10
Spreadsheet: 166937d1341848448-excel-2007-automatically-select-the-next-cell-once-a-data-validation-menu-option-has-been-selected-data-validation
Sheet: Data Validation - Change Lists

 | Colour | Select Option
 | Red | Select Answer
 | Option | Project
 | Colour | Red
 | Colour | Orange
 | Colour | Green
 | Colour | Blue
 | Number | One
 | Number | Two
 | Number | Three
 | Country | England
 | Country | America
 | Country | China
 | Vehicle | Car
 | Vehicle | Bus
 | Vehicle | Truck
Spreadsheet: 54612d1254655055-excel-accounting-help-pm-tracking
Sheet: Period Reporting

Start Date | 2009-07-22 00:00:00
End Date | 2009-10-04 00:00:00
[NAME] | 0.75 | per kilometre
 | Amount | GST
Sales | 284 | 25.81818181818182
Purchases | 377 | 34.27272727272727
Expenses | 10 | 0.9090909090909091
[NAME] | 566
Travel | 424.5 | 38.59090909090909
Total | -527.5 | -47.95454545454546
Spreadsheet: john_forney__15513__SCHED2001
Sheet: MARCH'01

 |  |  |  |  |  |  |  |  |  |  | 24 HOUR SCHEDULE
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
NAME | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
ERCOT | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
[NAME] | D | D |  |  | D | D | D | D | D |  |  | D | D | D | A/SA | A/SA |  |  | D | D | D | D | D |  |  | D | D | D | D | D
KELLER MAYEAUX | D | V |  |  | T | T | T | T | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
[NAME] |  |  |  |  |  | N | N | N | N |  |  |  | N |  |  | N | N | N | N |  |  |  |  | D | D |  |  |  |  | N | N
CHRIS WATTS | N |  | D | D |  |  |  |  |  | V | V | V | V |  |  |  |  |  |  | N | N |  | N | N | N | N | N
[NAME] |  | N | N | N | N |  |  |  |  | D | D | T | T | T | T |  | D | D |  |  |  | N |  |  |  |  |  | N | N |  | D
SOUTHEAST
[NAME] | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | V | D | D | D | D
RUDY ACEVEDO |  |  | D | D | D | D | D |  |  |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
MIGUEL GARCIA |  |  |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
DEAN LAURENT |  |  | N | N | N |  |  |  |  | D | D |  |  |  | N | N | N | N |  |  | N | N |  |  |  |  | N | N
[NAME] | V | V | V | V | V | N | N | N |  |  |  |  | N | N |  |  | D | D |  |  |  |  |  | D | D |  |  |  |  |  | D
MAURICIO TREJO |  |  |  |  |  |  |  | N | N | N | N | N |  |  |  |  |  |  | N | N |  |  | N | N | N | N |  |  | N |  | N
GREG TREFZ | N | N |  |  |  |  |  | N | N | N | N | N
MIDWEST
[NAME] | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
J.D.KINSER | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
[NAME] | D | D |  |  | D | D | D | D | D |  |  | D | D | D | V | V |  |  | D | D | D | D | D |  |  | D | D | D | D | D
CYRIL PRICE |  |  | D | D |  |  |  | N | N | N | N
JUAN PADRON | N | N | N | N |  |  |  |  |  | D | D |  |  | N | N |  |  |  | N | N | N |  |  | D | D |  |  |  |  | N | N
DUSTIN COLLINS |  |  |  |  | N | N | N |  |  |  |  | N | N |  |  | N | N | N | N |  |  |  |  | N | N | N | N |  |  |  | D
NORTHEAST
Spreadsheet: 863876d1711271055-google-sheet-function-to-excel-2016-function-stock-portfolio-tracking-spreadsheet-11
Sheet: Portfolio Summary

Total Portfolio Cost
Total Portfolio Value
Total Value Portfolio Cost
Total Value Portfolio Value
Total Value Portfolio Unrealised Gain/Loss
Total Value Portfolio Realised Gain/Loss
Total Value Portfolio Dividends Collected
Expected Value Portfolio Income
Expected Value Portfolio Income Yield on Cost
Total Special Situation Portfolio Cost
Total Special Situation Portfolio Value
Total Special Situation Portfolio Unrealised Gain/Loss
Total Special Situation Portfolio Realised Gain/Loss
Total Special Situation Portfolio Dividends Collected
Expected Special Situation Portfolio Income
Expected Special Situation Portfolio Income Yield on Cost
Total Growth Portfolio Cost
Total Growth Portfolio Value
Total Growth Portfolio Unrealised Gain/Loss
Total Growth Portfolio Realised Gain/Loss
Total Growth Portfolio Dividends Collected
Expected Growth Portfolio Income
Expected Growth Portfolio Income Yield on Cost
Total Dividend Portfolio Cost
Total Dividend Portfolio Value
Total Dividend [NAME] Gain/Loss
Total Dividend [NAME] Gain/Loss
Total Dividend Portfolio Dividends Collected
Expected Dividend Portfolio Income
Expected Dividend Portfolio Income Yield on Cost
Spreadsheet: 484236d1476185149-updating-holiday-planner-for-this-year-proposed-holiday-planner-based-on-2015-16
Sheet: NOV

 |  | Days
1
 |  | Entitlement | Taken | Remaining
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Entering '1' in the relevant row/column represents 0.5 of a day
Spreadsheet: 86280d1286295579-split-date-ranges-into-single-rows-per-date-date-split-after
Sheet: Output

Date | Rate | Segment
2010-10-05 00:00:00 | 100 | A
2010-10-06 00:00:00 | 100 | A
2010-10-07 00:00:00 | 100 | A
2010-10-08 00:00:00 | 100 | A
2010-10-09 00:00:00 | 100 | A
2010-10-05 00:00:00 | 200 | B
2010-10-06 00:00:00 | 200 | B
2010-10-07 00:00:00 | 200 | B
2010-10-06 00:00:00 | 300 | A
Spreadsheet: 114962d1310619745-automatically-updating-data-from-one-sheet-to-another-june
Sheet: 5570

Date | Trip Details | Amount | Toll | Other | Party | Payment Yes/N0 | [NAME]
2011-06-01 00:00:00
 | Royal Ship
 | [NAME] (11-20) | Yes
 | [NAME] | Yes
 | [NAME] | Yes
 | [NAME] | Yes
 | [NAME] | Yes
 | [NAME] | Yes
 | [NAME] | Yes
 | [NAME] | Yes
 | [NAME] | Yes
 | Sidha Travels Ramada | Yes
 | Thrissur
Spreadsheet: 215347d1361354735-drop-down-list-to-autofill-cells-cleaning-check
Sheet: RefLists

 | Front of Building | Front of Building | Front Entry | Front Counter | Fountain | [NAME] | [NAME] | Indoor Dining | Outdoor Dining | Large Storage | Small Storage | Kitchen | Parking | D. Bathroom
1 | Front Entry | Walls | Gate | Display Case | Appliances | Sink | Sink | Employee Door | Back Entry Door | Employee Door | Door | Trash Recepticle | Property | Sink
2 | Front Counter | Floor | Walls | Counter | Counter | [NAME] | [NAME] | Trash Recepticle | Trash Recepticle | Trash Recepticle | Walls | Sinks | Cigarette Recepticle | [NAME]
3 | Fountain |  | Steps | Glass Partition | Walls | Soap Dispenser | Soap Dispenser | Salsa Bar | Tables | Cleaning Station | Floor | [NAME] | [NAME] | Soap Dispenser
4 | [NAME] |  | Sign | Walls | Floor | Toilets | Urinal | [NAME] | Chairs | Lockers |  | Glass Partition |  | Toilet
5 | [NAME] |  | Doors | Floor | Trash Recepticle | Stall | Toilet | Tables | Walls | [NAME] |  | Walls |  | Walls
6 | Indoor Dining |  | Pictures | Pictures | Pictures | Doors | Stall | Chairs | Floor | Ice Machine |  | Floor |  | Floor
7 | Outdoor Dining |  |  |  |  | Walls | Door | Pictures | Employee Door | Coffee Station |  |  |  | Trash Recepticle
8 | Large Storage |  |  |  |  | Floor | Walls | Walls |  | Walls
9 | Small Storage |  |  |  |  | [NAME] | Floor | Floor |  | Floor
10 | Kitchen |  |  |  |  | [NAME] | [NAME] | Windows
11 | Parking |  |  |  |  |  |  | Pictures
12 | D. Bathroom |  |  |  |  |  |  | Back Entry Door
13
14
15
16
17
18
19
20
Spreadsheet: 158437d1338239701-align-two-graphs-of-the-weight-development-of-my-two-puppy-dogs-rottweilers-another-copy-of-ggptt
Sheet: MAX

Date |  | Together | Me | Difference | "Slope"
2011-11-09 00:00:00 | BIRTH
2012-03-03 00:00:00 |  |  |  | 15.7
2012-03-10 00:00:00 |  | 89.9 | 73.5
2012-03-13 00:00:00 |  |  | 92.5
2012-03-17 00:00:00 |  | 93.8 | 74.8
2012-03-21 00:00:00 |  | 110.8 | 91.9
2012-03-28 00:00:00 |  |  |  | 19.9
2012-04-01 00:00:00 |  | 96 | 75.2
2012-04-04 00:00:00 |  | 116.7 | 94.7
2012-04-12 00:00:00 |  | 99 | 75
2012-04-18 00:00:00 |  | 100.7 | 75.6
2012-04-23 00:00:00 |  | 99.4 | 74.7
2012-04-30 00:00:00 |  | 102.4 | 76
2012-05-06 00:00:00 |  | 106 | 77.7
2012-05-15 00:00:00 |  | 104.9 | 75.3
2012-05-28 00:00:00 |  | 107.2 | 75.7
Spreadsheet: 41593d1240114780-rolling-average-rollingaverage
Sheet: Sheet1

Date | Cost | Four week Rolling Average
2008-03-18 00:00:00 | 45
2008-03-19 00:00:00 | 55
2008-03-25 00:00:00 | 65
2008-04-01 00:00:00 | 78
2008-04-02 00:00:00 | 45
2008-04-15 00:00:00 | 46
2008-04-29 00:00:00 | 36
2008-05-01 00:00:00 | 33
2008-05-05 00:00:00 | 88
2008-05-15 00:00:00 | 55
2008-05-25 00:00:00 | 67
2008-06-01 00:00:00 | 89
2008-06-15 00:00:00 | 45
2008-06-25 00:00:00 | 66
2008-06-30 00:00:00 | 76
2008-07-06 00:00:00 | 77
2008-07-08 00:00:00 | 55
Spreadsheet: 733303d1621501520-help-with-formula-based-on-number-of-occurences-of-values-in-another-column-sample
Sheet: Sheet1

 | 1
 | 0.5
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1000
 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
 | 0
 | 2000
Time | S | N | Result | T | T+L | S2 | W/L | P | CP | SP | Reset
04/05/2019 11:25:00 | A | 5.6 | Won
04/05/2019 11:50:00 | B | 3.56 | Won
04/05/2019 11:53:00 | C | 3.8 | Lost
04/05/2019 12:18:00 | D | 3.45 | Lost
04/05/2019 12:41:00 | E | 4.93 | Lost
04/05/2019 12:50:00 | C | 4.1 | Won
04/05/2019 13:00:00 | F | 4.2 | Lost
04/05/2019 13:06:00 | S | 3.45 | Lost
04/05/2019 [NAME] | T | 3.45 | Lost
04/05/2019 13:16:00 | A | 2.66 | Lost
04/05/2019 13:50:00 | U | 3.1 | Lost
04/05/2019 14:01:00 | Y | 4.6 | Lost
04/05/2019 14:05:00 | Z | 5.32 | Lost
04/05/2019 14:10:00 | X | 3.6 | Lost |  |  |  |  |  |  |  | <--- after 7 consecutive losses, this number is 0 as per the formula in Col G
04/05/2019 14:12:00 | C | 3 | Won
04/05/2019 14:18:00 | B | 4.59 | Won
04/05/2019 14:25:00 | A | 4.2 | Lost |  |  |  |  |  |  |  | <--- after the zeros in col G above, there have been two occurances of the value "Won" in Col D, so the value in Col E should now be one more than the previous (in this case it was 7 so add one equals 8)
04/05/2019 14:30:00 | R | 3.05 | Lost
04/05/2019 14:36:00 | K | 3.85 | Lost
04/05/2019 14:38:00 | O | 3.55 | Lost
04/05/2019 14:45:00 | P | 4.58 | Lost
04/05/2019 17:15:00 | C | 3.86 | Lost
04/05/2019 17:30:00 | F | 3.5 | Lost
04/05/2019 18:15:00 | S | 5.59 | Lost |  |  |  |  |  |  |  | <--- after 7 consecutive losses, this number is 0 as per the formula in Col G
04/05/2019 19:15:00 | T | 3.7 | Lost
04/05/2019 20:15:00 | A | 5.3 | Lost
11/05/2019 11:50:00 | U | 4.2 | Won
11/05/2019 12:18:00 | Y | 3.15 | Lost
11/05/2019 12:30:00 | Z | 5.16 | Lost
11/05/2019 13:16:00 | X | 4 | Won
11/05/2019 13:40:00 | C | 5.5 | Lost |  |  |  |  |  |  |  | <--- after the zeros in col G above, there have been two occurances of the value "Won" in Col D, so the value in Col E should now be one more than the previous (in this case it was 15 so add one equals 16)
11/05/2019 13:53:00 | B | 3.06 | Won
11/05/2019 14:12:00 | A | 3.08 | Lost
18/05/2019 12:05:00 | A | 5.2 | Lost
18/05/2019 12:15:00 | U | 5.59 | Lost
18/05/2019 12:25:00 | Y | 5.08 | Lost
[NAME] 12:40:00 | Z | 4.06 | Lost
18/05/2019 12:47:00 | X | 3.56 | Lost
[NAME] 12:50:00 | C | 4.1 | Lost
18/05/2019 13:06:00 | A | 4.5 | Won |  |  |  |  |  |  |  | <--- after 7 consecutive losses, this number is 0 as per the formula in Col G
18/05/2019 13:10:00 | U | 4.6 | Lost
[NAME] 13:15:00 | Y | 3.85 | Won
18/05/2019 13:18:00 | Z | 3.6 | Lost |  |  |  |  |  |  |  | <--- after the zeros in col G above, there have been two occurances of the value "Won" in Col D, so the value in Col E should now be one more than the previous (in this case it was 24 so add one equals 25)
18/05/2019 13:40:00 | X | 5.1 | Lost
[NAME] 13:46:00 | C | 3.05 | Lost
Spreadsheet: 770407d1646052067-calculate-how-many-days-people-have-from-start-date-until-end-date-from-month-to-month-enddate-aligw-3-
Sheet: English (4)

September |  |  |  |  | Calculation date
 |  | Start date | End date |  | 2021-02-28 00:00:00 | I want to get | AliGW
 | Anne | 2019-09-02 00:00:00 | 2021-01-31 00:00:00 |  |  | 0
 | Nina |  | 2021-09-30 00:00:00 |  |  | 30
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00 |  |  | 0
 | [NAME] | 2021-02-03 00:00:00 | 2021-10-31 00:00:00 |  |  | 28
 | [NAME] |  |  |  |  | 0
 | Sigrid | 2021-09-09 00:00:00 | 2021-11-30 00:00:00 |  |  | 0
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00 |  |  | 30
 | Heida | 2021-02-03 00:00:00 | 2021-02-18 00:00:00
 | Sandra | 2021-02-28 00:00:00 | 2021-12-31 00:00:00
 | Eva | 2022-11-03 00:00:00 |  |  |  | 0
Oktobere
 |  | Upphafsdagur | Lokadagur |  | 2021-10-31 00:00:00 | The correct answer would be
 | Anne | 2021-01-01 00:00:00 |  |  |  |  | [NAME]=MAX(MIN(IF(OR(D3="";AND(D3<=Calcul_9;D3-Calcul_9>30));30;-((Calcul_9-30)-D3));30);0)
 | Nina |  | 2021-09-30 00:00:00 | 0 |  |  | =MIN(30;MAX(0;1+MIN(Calcul_9;$D3)-MAX($C3;EOMONTH(Calcul_9;-1)+1))*SIGN(COUNT($C3:$D3)))
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00 | 0
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00 | 30 |  |  |  |  | 1. If a start date has started the take it in the calculation
 | [NAME] |  |  | 0 |  |  |  |  | 2. If neither [NAME] date nor End date is available  then =0
 | Sigrid | 2021-09-09 00:00:00 | 2021-11-30 00:00:00 | 30 |  |  |  |  | 3. If there is a Start date that has not started then =0
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00 | 0 |  |  |  |  | 4. If there is no [NAME] date but only End date then only consider End date
 | Heida | 2021-09-02 00:00:00 |  | 30
 | Sandra | 2021-10-03 00:00:00 | 2021-12-31 00:00:00 | 28
 | Eva | 2022-11-03 00:00:00 |  | 0
November
 |  | Upphafsdagur | Lokadagur |  | 2021-11-30 00:00:00 | The correct answer would be
 | Anne | 2021-01-01 00:00:00
 | Nina |  | 2021-09-30 00:00:00
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00
 | [NAME]
 | Sigrid | 2021-09-09 00:00:00 | 2021-11-30 00:00:00
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00
 | Heida | 2021-09-02 00:00:00
 | Sandra | 2021-10-03 00:00:00 | 2021-12-31 00:00:00
 | Eva | 2021-11-03 00:00:00