tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 469624d1468007246-conditionally-give-a-value-to-a-cell-contain-operator-case
Sheet: Feuil1

NOME | COLIGACAO | PT | PP | PDT | PSDB | PRTB | PSB | PR | PTB | PROS | PMDB | DEM | PPS | PRB | SD | PSL | PEN | PT DO B | PSC | PTN | PSOL | PSDC | PV | PSOL | PRB | PDT | PRP | PSD | PEN | PMDB | PPS | PSC | PRB | PPL | PDT | PT | PRB | DEM | PP | PSL | PSDC | PTB | SD | PT DO B | PT | PSB | PSD | PTC | PMN | PR | PSDB | PMN | PRP | PV | PSDC | PSD | PSTU | SD | PPL | PTN | PROS | PSL | PRTB | PC DO B | PHS | PROS | PC DO B | PMDB | PSOL | PCDOB | PRTB | PDT | DEM | PCDOB | PTC | PPS | PTN | PR | PEN | PSDB | PT DO B | PTB | PSB | PSC | PTDOB | PV | PHS | SEM COLIGACAO | (CASSADO) PP
RAIMUNDO ANGELIM | PT / PEN / PROS / PDT / PTB / PSL / PTN / PSDC / PHS / PSB / PRP / PPL / PRB / PCDOB | 1/0?
CESAR MESSIAS | PT / PEN / PROS / PDT / PTB / PSL / PTN / PSDC / PHS / PSB / PRP / PPL / PRB / PCDOB
MAJOR ROCHA | PP / PMDB / PSC / PR / PPS / PTC / PSDB / PSD / PTDOB / SD
LEO DE BRITO | PT / PEN / PROS / PDT / PTB / PSL / PTN / PSDC / PHS / PSB / PRP / PPL / PRB / PCDOB
JESSICA SALES | PP / PMDB / PSC / PR / PPS / PTC / PSDB / PSD / PTDOB / SD
SIBA MACHADO | PT / PEN / PROS / PDT / PTB / PSL / PTN / PSDC / PHS / PSB / PRP / PPL / PRB / PCDOB
FLAVIANO MELO | PP / PMDB / PSC / PR / PPS / PTC / PSDB / PSD / PTDOB / SD
[NAME] | PT / PEN / PROS / PDT / PTB / PSL / PTN / PSDC / PHS / PSB / PRP / PPL / PRB / PCDOB
JHC | PP / PPS / PSDC / PRP / PR / PSL / PSB / SD / DEM
[NAME] | PDT / PSC / PMDB / PV / PTB / PSD / PT DO B / PROS / PCDOB / PT / PHS
PEDRO VILELA | PSDB / PRB
ARTHUR LIRA | PP / PPS / PSDC / PRP / PR / PSL / PSB / SD / DEM
RONALDO LESSA | PDT / PSC / PMDB / PV / PTB / PSD / PT DO B / PROS / PCDOB / PT / PHS
GIVALDO CARIMBAO | PDT / PSC / PMDB / PV / PTB / PSD / PT DO B / PROS / PCDOB / PT / PHS
NIVALDO ALBUQUERQUE | PP / PPS / PSDC / PRP / PR / PSL / PSB / SD / DEM
VAL AMELIO | PRTB / PPL / PMN
PAULAO | PDT / PSC / PMDB / PV / PTB / PSD / PTDOB / PROS / PCDOB / PT / PHS
ROBERTO GOES | PP / PDT / PMDB
JANETE CAPIBERIBE | PSB / PT / PSOL / PCDOB
CABUCU BORGES | PP / PDT / PMDB
VINICIUS GURGEL | PR / PRB / PHS / PROS / PSDC / PEN / PV / PT DO B
PROFESSORA MARCIVANIA | PSB / PT / PSOL / PCDOB
ANDRE ABDON | PR / PRB / PHS / PROS / PSDC / PEN / PV / PT DO B
MARCOS REATEGUI | PTB / PSC / PPS / PRTB / PMN / PTC / PRP / PPL
JOZI ARAUJO | PTB / PSC / PPS / PRTB / PMN / PTC / PRP / PPL
ARTHUR BISNETO | PROS / DEM / PSDB / PR / PTN / PSC / PT DO B / PTC / PRTB / PEN / PV / PHS / PSL / PSD / SD
SILAS CAMARA | PROS / DEM / PSDB / PR / PTN / PSC / PT DO B / PTC / PRTB / PEN / PV / PHS / PSL / PSD / SD
ALFREDO NASCIMENTO | PROS / DEM / PSDB / PR / PTN / PSC / PT DO B / PTC / PRTB / PEN / PV / PHS / PSL / PSD / SD
MARCOS ROTTA | PMDB / PP / PT / PDT / PTB / PPS / PRB / PSDC / PPL / PC DO B
Spreadsheet: 105438d1302788973-excel-2007-schedule-help-schedule
Sheet: Schedule

 | NAME 1 | [NAME] 2 | NAME 3 | NAME 4 | NAME 5 | NAME 6 | NAME 7 | [NAME] 8 | NAME 9 | NAME 10 | NAME 11 | NAME 12 | NAME 13 | NAME 14 | NAME 15 | [NAME] 16 | [NAME] 17 | NAME 18 | NAME 19 | NAME 20
2011-04-01 00:00:00 | 7h-15h | 15h-22h
2011-04-02 00:00:00 | 15h-22h | 15h-22h
2011-04-03 00:00:00 | 15h-22h | 15h-22h
2011-04-04 00:00:00 | 15h-22h | 15h-22h
2011-04-05 00:00:00 | 15h-22h | 7h-15h
2011-04-06 00:00:00 | 7h-15h | 7h-15h
2011-04-07 00:00:00 | 7h-15h | 7h-15h
2011-04-08 00:00:00 | 7h-15h | 15h-22h
2011-04-09 00:00:00 | 7h-15h | 15h-22h
2011-04-10 00:00:00
2011-04-11 00:00:00
2011-04-12 00:00:00
2011-04-13 00:00:00
2011-04-14 00:00:00
2011-04-15 00:00:00
2011-04-16 00:00:00
2011-04-17 00:00:00
2011-04-18 00:00:00
2011-04-19 00:00:00
2011-04-20 00:00:00
2011-04-21 00:00:00
2011-04-22 00:00:00
2011-04-23 00:00:00
2011-04-24 00:00:00
2011-04-25 00:00:00
2011-04-26 00:00:00
2011-04-27 00:00:00
2011-04-28 00:00:00
2011-04-29 00:00:00
2011-04-30 00:00:00
Spreadsheet: 270009d1381345062-if-sumif-formula-help-sample-worksheet2
Sheet: Sales Invoice

Product | Qty | Line Total
Product A | 10
Product A | 12
Product C | 14
Product D | 5
Product D | 6
Product D | 1
 | Total Product A | 22
 | Total Product C | 14
 | Total Product D | 12
 | Total Qty Ordered
Product A | 3
Product B | 2
Product D | 1
Product E | 8
 | Total Product A | 3
 | Total Product C | 2
 | Total Product D | 1
 | Total Product E | 8
 | Total Qty Ordered
Spreadsheet: 87501d1287395354-minimize-rounded-amounts-twsactivex-hedge-workbook-2
Sheet: Greeks Hedge

CONTRACT ID | OPT. 1 GREEKS (DESCENDING: δ,Γ,τ,Θ) | OPT. 2 GREEKS ( δ,Γ,τ,Θ) | OPT. 3 [NAME] ( δ,Γ,τ,Θ) | OPT. 4 GREEKS ( δ,Γ,τ,Θ) | NET GREEKS (DESCENDING: δ,Γ,τ,Θ) | MINVERSE ARRAY |  |  |  | HEDGE RATIO | HEDGE RATIO ROUNDED | AMOUNT ROUNDED
 | -0.1915882234300216 | -0.3796261600852154 | 0.4740565074668973 | 0.1949375628389736 | 0 | 0.4628333114264059 | -6.028309323503428 | -25.23880654861851 | -483.1765306211468 | -30.14154661751714 | -30 | 0.1415466175171396
 | 0.1265548112808108 | 0.1235308628729943 | 0.1536710039120389 | 0.1936426286296687 | 5 | -1.41488807699808 | 2.651291177536972 | 27.87479882237577 | 228.9887044175117 | 13.25645588768486 | 13 | 0.2564558876848615
 | 0.01702324683749141 | 0.03591581912107791 | 0.03760061204384307 | 0.01714775996177544 | 0 | 1.360728040398077 | -4.989536283452913 | 18.77992693816167 | -121.2486898012977 | -24.94768141726457 | -25 | 0.05231858273543466
 | -0.004721320779978577 | -0.003780933427494026 | -0.003427239675396337 | -0.003124951165037201 | 0 | -0.4797284670135805 | 11.37219798763868 | -16.19083462869077 | 265.9205292367487 | 56.86098993819338 | 57 | 0.1390100618066157
Spreadsheet: 36336d1234222085-matching-similar-cells-from-2-seperate-worksheets-example
Sheet: Non R1 #s

012-00003-00
012-00003-00
033-00001-00
033-00001-00
033-00001-00
071-00006-00
071-00006-00
071-00006-00
071-00006-00
071-00006-00
101-00031-00
101-00060-01
101-00060-01
101-00060-01
101-00060-01
101-00061-01
101-00062-01
101-00062-01
101-00062-01
101-00062-01
101-00062-01
101-00064-01
101-00064-01
101-00064-01
101-00064-01
101-00064-01
101-00065-01
101-00065-01
101-00065-01
101-00065-01
Spreadsheet: 730961d1620070517-populating-cells-based-on-dependent-drop-down-lists-within-a-table-costing-sheet-v2
Sheet: Ingredients - Meat

Supplier | Product Code | Ingredient Description | Pack Size | Pack Unit | Pack Cost | Cost per Unit | Cost per Item
ABC Produce |  | Beef - Topside | 1 | 2000g | 18 |  | -
ABC Produce |  | [NAME] | 6 |  | 3.6
ABC Produce |  | Lamb - Leg | 1 | 1000g | 12 |  | -
ABC Produce |  | Pork - Rolled Loin | 1 | 1000g | 9.62 |  | -
Spreadsheet: 1189ea00-425e-4f42-8d8b-62233097c80c
Sheet: Mod 37 Additions

Addition of Items Spreadsheet
Part Number | SIN | PRODUCT NAME | Commercial List Price | MFC DISCOUNT | Discount to GSA | RELATIONSHIP | Proposed GSA Price | Proposed GSA Price including IFF | DELIVERY | FOB POINT | COO
105978 | 398-59 | Drum kit | 200 | 0.05 | 0.1 |  |  |  | 30 days | Destination | USA
Spreadsheet: 141773d1329436324-multi-criteria-formula-with-pro-rata-commdv4
Sheet: Regle (2)

 | Taux de commission | 0.002
 |  |  |  |  |  |  | cash |  |  |  | monthly accrual |  |  |  | debt recognized by accounting |  |  |  | charge to debt
 |  |  | T1 | T2 | T3 | T4 | T1 | T2 | T3 | T4 | T1 | T2 | T3 | T4 | T1 | T2 | T3 | T4 | T1 | T2 | T3 | T4
 | 2012-01-01 00:00:00 | 1200000
 | 2012-02-01 00:00:00 | 1300000
 | 2012-03-01 00:00:00 | 1500000 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012-04-01 00:00:00 | 1500000
 | 2012-05-01 00:00:00 | 1500000
 | 2012-06-01 00:00:00 | 1500000 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012-07-01 00:00:00 | 800000
 | 2012-08-01 00:00:00 | 800000
 | 2012-09-01 00:00:00 | 800000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012-10-01 00:00:00 | 400000
 | 2012-11-01 00:00:00 | 200000
 | 2012-12-01 00:00:00 | 100000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 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
 |  |  |  |  |  |  | situation | on the monthly accrual column, the simple formula i create work when its on a jan to dec basis.
 |  |  |  |  |  |  | Problem: | i wish i was able to build a formula that integrate the same analysis on a 12 month basis. Thus the end of each quarter i will have the same formula but the the add accrual if column C starts in april.
 |  |  |  |  |  |  | Problem: | the same logic should work with all other column…
 |  |  |  |  |  |  |  | the idea is to find the same final result 1933 whether my month starts in january to dec  or in april 2012  thru march 2013
 |  |  |  |  |  |  | tip | as long as my C column has a twelve month basis and has a result of 11600000
 |  |  |  |  |  |  |  | please help!!
Spreadsheet: 221204d1363412187-i-need-to-be-able-to-group-and-sum-by-values-in-a-column-by-using-a-function-example
Sheet: Sheet1

company | item class | item desc | total cost
C | lighting | 75W bulbs | 3
D | lighting | 100W bulbs | 4
B | lighting | 75W bulbs | 3
B | lighting | 75W bulbs | 3
B | paper | copy paper, standard | 8
A | paper | legal paper | 9
A | plumbing | plunger, toilet | 10
D | plumbing | [NAME] | 50
item class | item desc | A | B | C | D
lighting | 75W bulbs |  | 6 | 3
lighting | 100W bulbs |  |  |  | 4
paper | copy paper, standard |  | 8
paper | legal paper | 9
plumbing | plunger, toilet | 10
plumbing | [NAME] |  |  |  | 50
Spreadsheet: 98183d1297201415-printing-problem-example
Sheet: Finish summary by age

FINISHING BARNS
WEEKLY MORTALITY AND SALES SUMMARY
 |  |  |  |  |  | REPORT DATE:
GROWER & FLOCK | START | PRIOR WEEK LIVE COUNT |  |  | MORTALITY |  | SALES & TRANSFERS |  | ENDING COUNT |  |  | FINAL
INFORMATION | COUNT |  |  | TOTAL |  |  |  |  |  |  | TOTAL | [NAME] %
 |  |  |  |  |  |  |  |  |  |  | CLOSED
 | 133 |  |  | 7 |  | -5 |  | -2
2010-07-30 00:00:00 |  |  |  |  |  |  |  |  |  |  | 01-18-11
 |  |  |  |  |  |  |  |  |  |  | CLOSED
 | 1260 |  |  | 513 |  | -26 |  | -487
2010-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 01-18-11
 |  |  |  |  |  |  |  |  |  |  | CLOSED
 | 2331 |  |  | 447 |  | -27 |  | -420
2010-08-09 00:00:00 |  |  |  |  |  |  |  |  |  |  | 01-20-11
 | 1250 |  |  | 841 |  | -4 |  | -177
2010-08-18 00:00:00
 | 1248 |  |  | 1018 |  | -2 |  | 0
2010-08-23 00:00:00
 | 1548 |  |  | 1316 |  | -2 |  | 0
2010-08-30 00:00:00
 | 1547 |  |  | 1501 |  | -1 |  | -178
2010-09-30 00:00:00
 | 1249 |  |  | 1218 |  | -2 |  | -180
2010-09-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  | CLOSED
 | 1122 |  |  | 566 |  | -5 |  | -561
2010-09-13 00:00:00 |  |  |  |  |  |  |  |  |  |  | 01-20-11
 | 1248 |  |  | 1217 |  | 0 |  | 0
2010-09-15 00:00:00
 | 1250 |  |  | 1216 |  | -2 |  | 0
2010-09-20 00:00:00
 | 1267 |  |  | 1242 |  | -1 |  | 0
2010-09-27 00:00:00
 | 1014 |  |  | 987 |  | -3 |  | 0
2010-10-04 00:00:00
 | 1025 |  |  | 1001 |  | 0 |  | 0
2010-10-06 00:00:00
 | 1025 |  |  | 985 |  | -2 |  | 0
2010-10-11 00:00:00
 | 1021 |  |  | 989 |  | 0 |  | 0
2010-10-15 00:00:00
 | 1250 |  |  | 1216 |  | 0 |  | 0
2010-10-20 00:00:00
 | 1250 |  |  | 1221 |  | -5 |  | 0
2010-10-25 00:00:00
 | 1250 |  |  | 1228 |  | -4 |  | 0
2010-10-29 00:00:00
 | 1250 |  |  | 1226 |  | -4 |  | 0
2010-11-03 00:00:00
 | 1250 |  |  | 1225 |  | -2 |  | 0
2010-11-10 00:00:00
 | 1246 |  |  | 1199 |  | 0 |  | 0
2010-11-15 00:00:00
 | 1254 |  |  | 1226 |  | -5 |  | 0
2010-11-19 00:00:00
 | 1243 |  |  | 1200 |  | -5 |  | 0
11/24/106
 | 1823 |  |  | 1798 |  | -3 |  | 0
2010-12-01 00:00:00
 | 1820 |  |  | 1801 |  | -3 |  | 0
2010-12-08 00:00:00
 | 1245 |  |  | 1238 |  | -1 |  | 0
2010-12-17 00:00:00
 | 1250 |  |  | 1238 |  | -2 |  | 0
2006-12-22 00:00:00
 | 1236 |  |  | 1242 |  | -5 |  | 0
2010-12-27 00:00:00
 | 1258 |  |  | 1255 |  | -2 |  | 0
2010-12-31 00:00:00
 | 1262 |  |  | 1262 |  | -3 |  | 0
2011-01-10 00:00:00
 | 1263 |  |  | 1263 |  | -2 |  | 0
2011-01-07 00:00:00
 | 1232 |  |  | 1232 |  | 0 |  | 0
2011-01-17 00:00:00 |  |  |  | NEW
 | 615 |  |  | 615 |  | 0 |  | 0
2011-01-21 00:00:00 |  |  |  | NEW
 |  |  |  |  | MORTALITY |  | SALES & TRANSFERS |  | REMAINING INVENTORY
 |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  | WEEKLY TOTALS
Spreadsheet: 119105d1314200665-remove-space-in-date-test_book
Sheet: Sheet1

England - Premier League 2011/2012
28.8. 2011 | [NAME] | : | Arsenal | More details about [NAME] game
10.9. 2011 | [NAME] | : | [NAME] | More details about [NAME]-Manchester United game
18.9. 2011 | [NAME] | : | Chelsea | More details about [NAME] game
24.9. 2011 | Stoke | : | [NAME] | More details about Stoke-Manchester United game
01.10. 2011 | [NAME] | : | [NAME] | More details about [NAME] game
15.10. 2011 | Liverpool | : | [NAME] | More details about Liverpool-Manchester United game
23.10. 2011 | [NAME] | : | Manchester City | More details about [NAME] game
29.10. 2011 | Everton | : | [NAME] | More details about [NAME] game
05.11. 2011 | [NAME] | : | Sunderland | More details about [NAME] game
19.11. 2011 | Swansea | : | [NAME] | More details about Swansea-Manchester United game
26.11. 2011 | [NAME] | : | Newcastle | More details about [NAME] game
03.12. 2011 | [NAME] | : | [NAME] | More details about [NAME] game
10.12. 2011 | [NAME] | : | Wolverhampton | More details about [NAME] game
17.12. 2011 | Queens Park Rangers | : | [NAME] | More details about Queens Park Rangers-Manchester United game
21.12. 2011 | Fulham | : | [NAME] | More details about Fulham-Manchester United game
26.12. 2011 | [NAME] | : | [NAME] | More details about [NAME] game
31.12. 2011 | [NAME] | : | [NAME] | More details about [NAME] game
02.1. 2012 | Newcastle | : | [NAME] | More details about Newcastle-Manchester United game
14.1. 2012 | [NAME] | : | [NAME] | More details about [NAME] game
21.1. 2012 | Arsenal | : | [NAME] | More details about Arsenal-Manchester United game
31.1. 2012 | [NAME] | : | Stoke | More details about [NAME] game
04.2. 2012 | Chelsea | : | [NAME] | More details about Chelsea-Manchester United game
11.2. 2012 | [NAME] | : | Liverpool | More details about [NAME] game
25.2. 2012 | [NAME] | : | [NAME] | More details about [NAME]-Manchester United game
03.3. 2012 | Tottenham | : | [NAME] | More details about Tottenham-Manchester United game
10.3. 2012 | [NAME] | : | West Bromwich | More details about [NAME] game
17.3. 2012 | Wolverhampton | : | [NAME] | More details about Wolverhampton-Manchester United game
24.3. 2012 | [NAME] | : | Fulham | More details about [NAME] game
31.3. 2012 | [NAME] | : | [NAME] | More details about [NAME]-[NAME] game
07.4. 2012 | [NAME] | : | Queens Park Rangers | More details about [NAME] Park Rangers game
09.4. 2012 | [NAME] | : | [NAME] | More details about [NAME]-Manchester United game
14.4. 2012 | [NAME] | : | [NAME] | More details about [NAME] game
21.4. 2012 | [NAME] | : | Everton | More details about [NAME] game
28.4. 2012 | Manchester City | : | [NAME] | More details about Manchester City-Manchester United game
05.5. 2012 | [NAME] | : | Swansea | More details about [NAME] game
13.5. 2012 | Sunderland | : | [NAME] | More details about Sunderland-Manchester United game
Spreadsheet: darrell_schoolcraft__7335__imball0203
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1 | -25763 | -20490
2 | -50011 | -52345
3 | -52259 | -52345
4 | -52407 | -52345
5 | -37005 | -29116
6 | -14185 | -7970
7 | -25788 | -25810
8 | -21508 | -13646
9 | -72478 | -80000
10 | -72964 | -80000
11 | -76847 | -78520
12 | -39678 | -39175
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00
2002-03-12 00:00:00
CBS Dollars
 |  |  | 154736
Spreadsheet: 99030d1297807439-filter-where-certain-line-is-missing-2-ways
Sheet: Sheet1

 |  |  |  |  | with filter |  | or just with formula using col g as a key
Cell nr | Service | Amount | Kb |  |  |  | 4567890
1234567 | Service 1 | 31 |  |  |  |  | 6789101
1234567 | Service 2 | 765 | 35189
1234567 | Service 3
2345678 | Service 1 | 31
2345678 | Service 2 | 654 | 11315
2345678 | Service 4 | 105 | 1950
2345678 | Service 5 | 1
2345678 | Service 6 | 1
2345678 | Service 3
3456789 | Service 1 | 31
3456789 | Service 2 | 762 | 34243
3456789 | Service 3
4567890 | Service 1 | 31 |  |  | filter me | 18
4567890 | Service 3
5678910 | Service 1 | 31
5678910 | Service 2 | 766 | 7719
5678910 | Service 3
6789101 | Service 1 | 31 |  |  | filter me | 25
6789101 | Service 4 | 105 | 1950
6789101 | Service 5 | 1
6789101 | Service 6 | 1
6789101 | Service 3
Spreadsheet: 390351d1429608440-conditional-formatting-based-on-difference-example
Sheet: Sheet1

VENUE | APRIL - INVITES | APRIL ATTENDANCE | MAY - INVITES | MAY [NAME] | April | May
Amherst | 100 | 6 | 50 | 35
Ash | 0 | 15 | 30 | 56
Aylesford | 450 | 480 | 500 | 508
Aylesham | 700 | 789 | 650 | 650
Balmoral | 60 | 55 | 80 | 95
Bearsted | 210 | 0 | 160 | 165
Darenth | 95 | 96 | 0 | 0
Birchington | 0 | 0 | 70 | 73
Blackthorn | 535 | 538 | 480 | 475
Borough Green | 300 |  | 225 | 219
[NAME] | 10 | 5 | 0 | 10
Bower | 560 | 582 | 475 | 489
 |  | I want to highlight any figures in column C that have a 10% difference from those figures in column B
 | 1 | If the amount <= 10% lower than column B - green
 | 2 | If the amount is >= 10% higher than column B - red
 | 3 | If no difference black font on white
 | 4 | If blank, count as lower (rule 1)
Spreadsheet: 137023d1326914010-excel-2007-create-custom-list-from-excel-table-with-array-formula-data6-modified-by-tigeravatar-
Sheet: Sheet6

 | ACCOUNT | [NAME] | NSA | BRZ | EUM | MEA | APR | CORPORATE | TOTAL |  | Code | Description | Amount
Short Term Investments
 | 021000 | ACCOUNTS RECEIVABLE - BILLED | 30836822.32999999 | 0 | 6807259.110000003 | 72834486.03 | 4182788.440000001 | 0 | 114661355.91
 | 021001 | JDE Machine generated AR | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 021002 | JDE AR2 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 021099 | TRADE REC-RECLASS | 742550.72 | 0 | 0 | 0 | 0 | 0 | 742550.72
 | 021100 | [NAME] | -1781012.81 | 0 | 0 | 0 | 0 | 0 | -1781012.81
A/R Billed |  |  |  |  |  |  |  | 0 | 113622893.8200001
 | 023000 | A/R - ACCRUED DAYWORK REVENUE | 0 | 112171.8 | 0 | 0 | 0 | 0 | 112171.8000000003
 | 023100 | Accrued Revenue | -4112684.060000002 | 18126.91 | 52909.72000000253 | 34250877.41 | 14409876.24 | 0 | 44619106.22
A/R Unbilled Dayrates |  |  |  |  |  |  |  | 0 | 44731278.02
 | 024000 | A/R - UNBILLED REIMBURSABLES | 1337498.640000001 | 29145489.04 | -935897.9799999999 | 24666403.64 | -1042070.2 | 0 | 53171423.13999999
 | 24099 | PR ContraA/R - UNBILLED | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 024100 | CONVERSION | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 024101 | CONVERSION | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 024170 | CONVERSION | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 024171 | CONVERSION | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 024172 | CONVERSION | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 024176 | CONVERSION | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 024180 | CONVERSION | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 024185 | CONVERSION | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 024192 | CONVERSION | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 024601 | CONVERSION | 0 | 0 | 0 | 0 | 0 | 0 | 0
A/R Unbilled Reimbursables |  |  |  |  |  |  |  | 0 | 53171423.13999999
 | 025000 | JV RECEIVABLES | 0 | 0 | 0 | 0 | 0 | 0 | 0
Joint Venture Receivables |  |  |  |  |  |  |  | 0 | 0
 | 028000 | ALLOWANCE FOR DOUBTFUL ACCOUNT | -1298004.316000001 | -101636.159 | -73916.74199999997 | -125997.26 | -105071.277 | 0 | -1704625.754000001
Allowance for Doubtful Accts |  |  |  |  |  |  |  | 0 | -1704625.754000001
Spreadsheet: 879163d1726609050-calculate-hours-falling-within-defined-windows-of-time-schedule-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | End
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM Hours | 07:00:00 | 15:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM Hours | 15:00:00 | 23:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ON Hours | 23:00:00 | 07:00:00
 | Front Desk |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HELPER COLUMNS
 | Day of Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total for Week
 | Date
 | Shift Start/End | Start | End | Hours | Start | End | Hours | Start | End | Hours | Start | End | Hours | Start | End | Hours | Start | End | Hours | Start | End | Hours | Hours |  |  |  | AM | PM | ON | AM | PM | ON | AM | PM | ON | AM | PM | ON | AM | PM | ON | AM | PM | ON | AM | PM | ON
 | Twanda | 07:00:00 | 15:00:00 |  | 15:00:00 | 23:00:00 |  | 07:00:00 | 15:00:00 |  | 15:00:00 | 23:00:00 |  |  |  |  | 11:00:00 | 19:00:00
 | [NAME] | 22:00:00 | 09:00:00 |  | 15:00:00 | 23:00:00 |  | 07:00:00 | 15:00:00 |  | 11:00:00 | 19:00:00 |  |  |  |  | 11:00:00 | 19:00:00 |  | 15:00:00 | 23:00:00
 | Lichardo | 07:00:00 | 15:00:00 |  |  |  |  |  |  |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00 |  | 07:00:00 | 15:00:00
 | [NAME] |  |  |  | 07:00:00 | 11:00:00
 | [NAME] | 20:00:00 | 03:00:00
 | [NAME]
 | [NAME] |  |  |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  | 23:00:00 | 07:00:00 |  | 15:00:00 | 23:00:00
 | Romario | 15:00:00 | 23:00:00 |  |  |  |  | 07:00:00 | 15:00:00 |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  |  |  |  | 15:00:00 | 23:00:00
 | [NAME] |  |  |  | 23:00:00 | 07:00:00 |  | 23:00:00 | 07:00:00 |  | 23:00:00 | 07:00:00 |  |  |  |  | 23:00:00 | 07:00:00 |  | 23:00:00 | 07:00:00
 | Krystal | 23:00:00 | 07:00:00 |  |  |  |  |  |  |  | 23:00:00 | 07:00:00 |  | 23:00:00 | 07:00:00
 | [NAME] | 14:00:00 | 22:00:00 |  | 09:00:00 | 16:00:00 |  | 14:00:00 | 22:00:00 |  |  |  |  |  |  |  | 14:00:00 | 22:00:00
 | Enter Employee Name
 | Enter Employee Name
 | Enter Employee Name
 | Enter Employee Name
 | Enter Employee Name
 | Enter Employee Name
 | Enter Employee Name
 | Enter Employee Name
 | Enter Employee Name
 | Total AM Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM | PM | ON | AM | PM | ON | AM | PM | ON | AM | PM | ON | AM | PM | ON | AM | PM | ON | AM | PM | ON
 | Total PM Hours
 | Total ON Hours
 | Total Hours
Spreadsheet: 827186d1682528292-combining-cells-with-the-same-data-but-keeping-some-data-separate-combining-cells-with-the-same-data-but-keeping-some-data-separate
Sheet: Sheet1

Data Before formula
[NAME] | 1255887 | The office stop |  | 2xABC1234-40004
[NAME] | 1234466 | Two tree style shop |  | 2xABC1111-4004
[NAME] | 1255442 | Viewing Galary | 1 x Green Tray | 5x1155-1234tt
[NAME] | 1245222 | The Ark | 1x white tree | 3xABC1234-9999
[NAME] | 1245222 | The Ark | 3x blue sheet + 1x Green Tray | 2x1234-9999_SS
[NAME] | 5222369 | Park Plaza |  | 7xABC1235-1994
[NAME] | 5478116 | Orange floor shop |  | 3xC111_2_4-SS
[NAME] | 5544899 | The top stop | 1x [NAME] 2x White Tree | 1xABC4004-1234
[NAME] | 1234455 | The big tree hotel, abc london |  | 6xABC1155-9999
[NAME] | 1234455 | The big tree hotel, abc london |  | 2xABC1155-9999
Data after formula
[NAME] | 1245222 | The Ark | 1x white tree + 3x blue sheet + 1x Green Tray | 5xABC1234-9999
[NAME] | 1234455 | The big tree hotel, abc london |  | 8xABC1155-9999
[NAME] | 5222369 | Park Plaza |  | 7xABC1235-1994
[NAME] | 5478116 | Orange floor shop |  | 3xC111_2_4-SS
[NAME] | 5544899 | The top stop | 1x [NAME] 2x White Tree | 1xABC4004-1234
[NAME] | 1255887 | The office stop |  | 2xABC1234-40004
[NAME] | 1234466 | Two tree style shop |  | 2xABC1111-4004
[NAME] | 1255442 | Viewing Galary | 1 x Green Tray | 5x1155-1234tt
 | 1255887 | The office stop
[NAME] | 1234466 | Two tree style shop
[NAME] | 1255442 | Viewing Galary
[NAME] | 1245222 | The Ark
[NAME] | 5222369 | Park Plaza
[NAME] | 5478116 | Orange floor shop
[NAME] | 5544899 | The top stop
[NAME] | 1234455 | The big tree hotel, abc london